Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question: How do i find the ending available inventory of lamp kits in part 7 ( i have starred it 9.13). I just want the
Question: How do i find the ending available inventory of lamp kits in part 7 ( i have starred it 9.13).
I just want the formula broken down on how to obtain that answer. Based on the following data:
Division N has decided to develop its budget based upon projected sales of 37,000 lamps at | ||||
$54.00 per lamp. | ||||
The company has requested that you prepare a master budget for the year. This budget is to be used | ||||
for planning and control of operations and should be composed of: | ||||
1. Production Budget | ||||
2. Materials Budget | ||||
3. Direct Labor Budget | ||||
4. Factory Overhead Budget | ||||
5. Selling and Administrative Budget | ||||
6. Cost of Goods Sold Budget | ||||
7. Budgeted Income Statement | ||||
8. Cash Budget | ||||
Notes for Budgeting: | ||||
The company wants to maintain the same number of units in the beginning and ending inventories of | ||||
work-in-process, and electrical parts while increasing the inventory of Lamp Kits to 750 pieces and | ||||
decreasing the finished goods by 20%. | ||||
Complete the following budgets | ||||
1 | Production Budget | |||
Planned Sales | ||||
Desired Ending Inventory of Finished Goods | ||||
Total Needed | ||||
Less: Beginning Inventory | ||||
Total Production | 36,400 units |
2 | Materials Budget | |||||
Lamp Kits | ||||||
Needed for Production | 36,400 units | {8.01} | ||||
Desired Ending Inventory | 750 units | {8.02} | ||||
Total Needed | 37,150 units | {8.03} | ||||
Less: Beginning Inventory | 500 units | {8.04} | ||||
Total Purchases | 36,650 units | |||||
Cost per piece | $16.72 | {8.05} | ||||
Cost of Purchases (Round to two places, $##.##) | $612,788.00 | {8.06} | ||||
3 | Direct Labor Budget | |||||
Labor Cost Per Lamp | $2.13 | {8.07} | ||||
Production | ||||||
Total Labor Cost (Round to two places, $##.##) | $77,532.00 | {8.08} | ||||
4 | Factory Overhead Budget | |||||
Variable Factory Overhead: | ||||||
Variable Factory Overhead Cost Per Unit | $2.0600000 | |||||
Number of Units to be Produced | ||||||
Total Variable Factory Overhead (Round to two places, $##.##) | $74,984.00 | {8.09} | ||||
Fixed Factory Overhead | $275,000.00 | {8.10} | ||||
Total Factory Overhead (Round to two places, $##.##) | $349,984.00 | {8.11} |
4 | Factory Overhead Budget | ||||||||
Overhead Allocation rate based on: | |||||||||
1. Number of Units | 36400 | ||||||||
Total Factory Overhead / Number of Units | 349984 | ||||||||
(Round to two places, $##.##) | $9.61 | {9.01} | |||||||
5 | Cost of making one unit next year | ||||||||
Cost of one Lamp Kit | 16.72 | ||||||||
Labor Cost Per Lamp | $2.13 | {9.02} | |||||||
Factory overhead per unit | |||||||||
Total cost of one unit | $28.46 | {9.03} | |||||||
(Round to two places, $##.##) | |||||||||
6 | Selling and Admin. Budget | ||||||||
Fixed Selling | 41000 | ||||||||
Variable Selling (Round to two places, $##.##) | $117,660.00 | {9.04} | |||||||
Fixed Administrative | 56000 | ||||||||
Variable Administrative (Round to two places, $##.##) | $75,480.00 | {9.05} | |||||||
Total Selling and Administrative (Round to two places, $##.##) | $290,140.00 | {9.06} | |||||||
7 | Cost of Goods Sold Budget - Assume FIFO (First-In, First-Out) and overhead is applied based on the number of units to be produced. | Round dollars to two places, $##.## | |||||||
Beginning Inventory, Finished Goods | $90,000.00 | {9.07} | |||||||
Production Costs: | $1,035,944.000 | ||||||||
Materials: | |||||||||
Lamp Kits: | |||||||||
Beginning Inventory | $8,000.000 | ||||||||
Purchased | $612,788.000 | ||||||||
Available for Use | $620,788.000 | ||||||||
Ending Inventory of Lamp Kits | $12,540.00 | {9.08} | |||||||
Lamp Kits Used In Production | $608,248.000 | ||||||||
Total Materials: | $608,248.00 | {9.09} | |||||||
Labor | $77,532.00 | {9.10} | |||||||
Overhead | $349,984.00 | {9.11} | |||||||
Cost of Goods Available | $1,125,764.00 | {9.12} | |||||||
***** Less: Ending Inventory, Finished Goods | $68,304.00 | {9.13} | |||||||
Cost of Goods Sold | $1,057,460.00 | {9.14} |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started