Answer:
Production Budget ( July August September) 5200, 6300, 9000
Sales Budget ( July August September) $ 300,000 $ 360,000 $ 450,000
Direct Materials Budget ( July August September) $ 31860 $ 39,420 $ 48,600
Direct Materials Units Budget ( July August September) 53,100 65,700 81,000
Direct Labor Budget ( July August September) $ 163,800 $ 198450 $ 283,500
Direct Labor Hours Budget ( July August September)7800 9450 13500
Explanation:
The formula used are
<em>1) Production Budget = Sales + Desired Ending Inventory Less Opening Inventory</em>
<em>2) Sales Budget= Sales * Price Per unit</em>
<em>3) Raw Materials Budget = Production + Desired Ending Inventory Less Opening Inventory</em>
<em>Raw Materials Costs= Raw Materials Budget * Costs</em>
<em>4) Direct Labor Hours Budget = Production * Direct Labor Hours</em>
<em>Direct Labor Budget = Direct Labor Hours Budget* Wages Per Hour</em>
<em><u /></em>
<u>School Days Furniture, Inc.</u>
<u>Production Budget</u>
<u> July August September </u>
Sales 5000 6000 7500
+ Desired
Ending Inventory 1200 1500 ------(assuming zero inv)
Less Opening
<u>Inventory 1000 1200 1500 </u>
<u>Production Budget 5200 6300 9000 </u><u> </u>
<u />
Production Budget = Sales + Desired Ending Inventory Less Opening Inventory
<u></u>
<u>School Days Furniture, Inc.</u>
<u>Sales Budget</u>
<u>July August September </u>
Sales 5000 6000 7500
<u>Price Per unit $ 60 $60 $ 60 </u>
<u>Sales Budget $ 300,000 $ 360,000 $ 450,000 </u>
<u />
Sales Budget= Sales * Price Per unit
<u></u>
<u>School Days Furniture, Inc.</u>
<u>Raw Materials Budget</u>
<u> July August September </u>
Production Budget 5200 6300 9000
+ Desired
Ending Inventory 630 900 ------(assuming zero inv)
Less Opening
<u>Inventory 520 630 900 </u>
<u>Materials Requiremnt 5310 6570 8100 </u>
<u>Board (feet) 10 10 10 </u>
Direct Materials 53,100 65,700 81,000
<u>Plank Costs 0.60 0.60 0.60 </u>
<u>Direct Materials $ 31860 $ 39,420 $ 48,600 </u><u> </u>
Raw Materials Budget = Production + Desired Ending Inventory Less Opening Inventory
Raw Materials Costs= Raw Materials Budget * Costs
<u></u>
<u>School Days Furniture, Inc.</u>
<u>Direct Labor Budget</u>
<u> July August September </u>
Production Budget 5200 6300 9000
<u>Direct Labor hours 1.5 1.5 1.5 </u>
<u>Direct Labor Hours 7800 9450 13500</u>
Wages Per hour $ 21 $ 21 $21
<u>Direct Labor Budget $ 163,800 $ 198450 $ 283,500 </u>
Direct Labor Hours Budget = Production * Direct Labor Hours
Direct Labor Budget = Direct Labor Hours Budget* Wages Per Hour
<u />
<u />