Tucker Lighting Company: Compute purchases budget
Not what you're looking for?
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.
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.