Jan Feb March April Wood Purchase Budget May June Total Production Budget (Units) 2,560 1,740 1,400 1,000 Budget Use in Production 1,040 1,220 8.960 2 2 Board Metres Required 2 2 2 2 2 5, 120 3,480 2,800 2,000 2,080 2,440 17,920 (add) Target Ending Inventory (25.0%) 870 700 500 520 Units Required 610 720 720 5,990 4,180 3,300 2,520 Beginning Inventory 2,690 3,160 21,840 1,400 870 700 500 Total Purchased 520 610 1,400 4,590 3,310 2,600 2,020 Wood Purchase Costs ($16 per BM) 2,170 2,550 17,240 73,440 52,960 41,600 32,320 34,720 Wood Used in Production 40,800 $ 275,840 $ 286,720 Glass Purchase Budget Jan Feb March April Production Budget (Units) May June 2,560 1,740 1,400 1,000 Budget Use in Production 1,040 1,220 8.960 1 Sheets Required 2,560 1,740 1,400 1,000 1,040 1,220 (add) Target Ending Inventory (20.0%) 8,960 348 280 200 208 Units Required 244 360 285 2,908 2,020 1,600 1,208 Beginning Inventory 1,284 1,580 10,600 500 348 280 200 208 Total glass sheet Purchased 244 2.408 500 1,672 1,320 1,008 1,076 Glass Purchase Costs ($22per sheet) 1,336 8,820 52,976 36,784 29,040 22,176 Glass Used in Production 23,672 29,392 $ 194,040 CA Total DM Purchases Budget 126,416 197, 120 89,744 70,640 54,496 58,392 70, 192 $ 469,880Schedule d Direct Labour Budget Jan Feb March April May June Total (Requried Production) Total Production Budge 2,560 1,740 1,400 1,000 1,040 1,220 8,960 Hours (4.0 per table) 10,240 6,960 5.600 4,000 4.160 4.880 35,840 Cost ($25.0 per hour) $ 256,000 $ 174,000 $ 140,000 $ 100,000 $ 104,000 $ 122,000 $ 896,000 Total Direct Labour Budget 896,000 Schedule e Manufacturing Overhead Budget Jan Feb March April May June Total Variable Cost ($15.00 per DLH) 153,600 $ 104,400 84,000 $ 60,000 62,400 $ 73,200 $ 537,600 Fixed Manufuring Costs (excl Deprec.) 149,000 $ 149,000 149,000 $ 149,000 149,000 $ 149,000 894,000 Fixed Manufuring Costs - Deprec. Component 60,000 $ 60,000 60,000 $ 60,000 60,000 60,000 360,000 Depreciation From New CAPEX 6,667 6,667 13,333 Total Manufacturing Overhead Costs $ 362,600 $ 313,400 $ 293,000 $ 269,000 278,067 288,867 $1,804,933 Less Non cash Fixed Man Cost (Deprec.) $ 60,000 $ 60,000 $ 60,000 60,000 60,000 60,000 360,000 Less Non cash New CAPEX Deprec 6.667 6,667 $ 13,333 Total Cash Disbursement Factory OHs $ 302,600 $ 253,400 $ 233,000 $ 209,000 211,400 $ 222,200 $1,431,600 Schedule f Manufacturing overhead rate (% of Sales) 57% Manufacturing overhead rate ($/DLH) 50.36MASTER BUDGET - Fantastic Lid Jan Feb March April May June Total Schedule a Sales revenue Budget Jan Feb March April May June Total Budget Sales (units) 2,700 1,800 1,500 1,000 1,000 1,200 9,200 Selling Price $400 $300 $300 $350 $350 $350 Total Sales Revenue Budget $1,080,000 $540,000 $450,000 $350,000 $350,000 $420,000 $3, 190,000Schedule a Sales revenue Budget Jan Feb March April May June Total Budget Sales (units) 2,700 1.800 1,500 1,000 1,000 1.200 9,200 Selling Price $400 $300 $300 $350 $350 $350 Total Sales Revenue Budget $1,080,000 $540,000 $450,000 $350,000 $350,000 $420,000 $3, 190,000 Schedule b Production Budget (Units) Jan Feb March April May June Total Budget Sales (units) 2,700 1,800 1,500 1,000 1,000 1,200 9,200 (add) Target Ending Inventory (20.0%) 360 300 200 200 240 260 260 Units Required 3,060 2,100 1,700 1,200 1,240 1,460 9.460 (less) Beginning Inventory 500 360 300 200 200 240 500 (Requried Production) Total Production Budge 2,560 1,740 1,400 1,000 1,040 1,220 8,960 8,960Schedule h Selling, Admin Expenses Jan Feb March April May June Total Fixed NorrManuluring Costs (excl Deprec.) 50,000 50,000 50,000 50,000 50,000 50,000 350,000 NonManufacturing Depreciation 20,000 20,000 20,000 20,000 20,000 20,000 120,000 New Software Depreciation 5,000 5,000 Commission 54,000 27,000 22,500 17,500 17,500 21,000 159,500 Total Selling 8. Admin Costs 134,000 107,000 102,500 97,500 97,500 105,000 544,500 Less: Non cash 20,000 20,000 20,000 20,000 20,000 25,000 125,000 Total Cash Disbursement Selling 8. Admin 94,000 57,000 52,500 57,500 57,500 55,000 394,500 Schedule i (1 ): Cost of goods sold budget Starting inventory + purchases ending inventory = cost of goods sold Direct materials used in Production $ 433,841)" Direct labour used 5 895,000 Manufacturing Overhead $ 1,304,932!" Budgeted manufacturing costs 5 3,184,773 Add: Beginning nished goods inventory 5 105,000 Cost of goods available for sale 5 3,259,773 Less: Ending nished goods inventory 5 92,415 Budgeted cost of goods sold 5 3,197,358 Schedule g Ending Finished Goods Inventory Budget Quantity Cost Total Unit cost computation: $54.00 $54.00 A $25.00 $100.00 Overhead: A $50.36 $201.44 Unit Product Cost $355.44 Ending Finished Goods Inventory in Units 260 Ending Finished Goods Inventory $92, 415.30