Fine Office Company 200 Selling and Adel Dinet Lab Fine Office Company Badged all your 2004 P 10 Variable Ca 8 Jomer Supple Po The use as P20 ml 2022 fatheringhampappoint the cost matter hemant che Fine Offer Company will cheese machine in 11:282) worth m 88 0x0 1509 Marking Tab Sales Budget Quarter 1 2. 3 4 Year P100 Expected Sales units 16,600 17.700 19,000 19,000 72.300 Selling Price $1,820 $1,820 $1,820 $1,820 $1,820 Total Sales P100 530,212,000 $32,214,000 $34,580,000 $34,580,000 $131,586,000 P200 Expected 20,400 20,400 19,900 21,300 82,000 Sales units Selling Price $1,920 $1,920 $1,920 $1,920 $1,920 Total Sales P200 $39,168,000 539,168,000 $38,208,000 $40,896,000 $157,440,000 Total Sales $69,380,000 $71,382,000 $72,788,000 $75,476,000 $289,026,000 Max. Points Group Points 1 Production Budget Quarter 2 3 4 Year Expected Sales Units P100 16,600 17,700 19,000 19,000 72,300 Add desired ending of Inventory P100 18 19 19 16 72 Total needs P100 16,617.7 17,719 19,019 19,015.9 72,371.6 Less beginning of Inventory P100 197.8 17.7 19 19 253.502 P100 Required Production: Units 16,419.898 17,701.3 19,000 18,996.9 72,118.098 Expected Sales Units P200 20,400 20,400 19,900 21,300 82,000 Add desired ending of Inventory P200 20 20 21 17 79 Total needs P200 20,420.4 20,419.9 19,921.3 21,317 82,078.6 Less beginning of Inventory P200 156.25 20.4 19.9 21.3 217.85 P200 Required Production: Units 20,264.15 20,399.5 19,901.4 21,295.7 81,860.75 Quarter P100 Production units Materials per unit P100 Total material needs/Used P200 Production units Materials per unit Direct Materials Budget 16,419.898 2 3 4 Year 205 17,701.3 205 19,000 18,996.9 72,118.098 205 205 205 3,366,079 20.264 225 3,628,767 3,895,000 3,894,365 14,784,210 20,400 225 19.901 225 21,296 81.861 225 225 P200 Total material needs/Used 4,559,434 4,589,888 4,477,815 4,791,533 18,418,669 Total Material needs for P100 and P200 7.925.513 8,218,654 8,372,815 8,685,897 33,202,879 Add desired ending of Inventory 143,000 143,000 143,000 143,000 $72,000 Total needs 80,68,512.799 83,61,654 85,15,815 88,28,897 3,37,74,878.799 Less beginning of Inventory 30,000 1,43,000 1,43,000 1,43,000 4,59,000 Materials to be purchased: Units 80,38,512.799 82,18,654 83,72,815 Unit price 8 8 8 8 Materials to be purchased: S 6.43.08.102.396 6,57,49,232 6,69,82,520 86,85,897 3,33,15,878,799 6,94,87,176 26,65.27.030.396 8 Cost of Ending Inventory of Direct materials 31st december 2023: 266,527,030 Quarter 1 Direct Labour Budget 2 3 4 Production Units Labour per unit Total labour needs Labour Rates Paid 36,684.048 8.40 308,146 52.8 38,100.8 8.40 320,047 52.8 38,901.4 40,292.6 8.40 326,772 52.8 8.40 Year 1,53,978.848 8.40 338,458 52.8 1,293,422 52.8 Total Direct Labour cost: $ $16,270,109 $16,898,467 $17,253,549 $17,870,574 $68,292,699 Direct Labour Budget Quarter 1 Production Units Labour per unit Total labour needs Labour Rates Paid 36,684.048 8:40 308,146 52.8 38,100.8 8.40 320,047 52.8 Total Direct Labour cost: S $16,270,109 $16,898,467 38,901.4 8.40 326,772 52.8 $17,253,549 40,292.6 Year 1,53,978.848) 8.40 338,458 52.8 $17,870,574 8.40 1,293,422 52.8 $68,292,699 Budeted Production units Machine hours per unit Total Budeted Machine hours Manufacturing Overhead Budget 2 Budgeted Manufacturing Overhead 3 4 Year Predetermined Overhead Rate: Estimated Manufacturing Overhead Machine Hours S per machine hour Cost Total Direct Materials Ending Finished Goods Inventory Budget P100 Cost Element + Direct Labour + Manufacturing Overhead = Product Cost Per Unit X Ending Inventory in Units Ending Finished Goods Inventory Quantity Ending Finished Goods Inventory Budget P200 Cost Element Direct Materials + Direct Labour + Manufacturing Overhead = Product Cost Per Unit X Ending Inventory in Units Ending Finished Goods Inventory Quantity Cost Total