Purchase Solution

Tucker Lighting Company: Compute purchases budget

Not what you're looking for?

Ask Custom Question

14-7. Tucker Lighting Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Tucker Lighting's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $85,000.

January February March
Budgeted cost of goods sold $70,000 $74,000 $80,000
Plus: Desired ending inventory $7,400 ? ?
Inventory needed $77,400 ? ?
Less: Beginning inventory $18, 000 ? ?
Required purchases (on account) $59,400 ? ?

a. Complete the inventory purchases budget by filling in the missing amounts
b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement.
c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter

Purchase this Solution

Solution Summary

I have computed the required amounts in Excel so you can see the formulas and have a template for other problems like this. Notice that the ending balance in one month = beginning balance of the next month.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.