Applying Excel 14: Budgeted units in ending raw materials inventory Which of the following formulas would be correct in cell D25? 3 4 5 March 7 8 9 10 Budget Assumptions For the months of January, February, and March January February Selling price per unit $200 $200 Budgeted sales (units) 12,000 15,000 Budgeted sales (units) April Budgeted production (units) April Ratio of ending finished goods inventory to next month's sales Ratio of ending raw materials inventory to next month's requirements Number of units in finished goods inventory, January 1 Number of pounds in raw materials inventory, January 1 Number of pounds of raw materials required per unit Cost per pound of raw materials Number of direct labor hours required per unit Rate per direct labor hour 11 $200 19,000 20,000 21,000 20% 40% 2,400 6,048 1.20 $6.00 2.0 $18.00 12 13 14 15 16 17 18 19 20 21 22 23 Direct Materials Budget For the months of January, February, and March January February Budgeted units to produce 12,600 15,800 Materials requirements per unit 1.20 1.20 Materials needed for production (pounds) 15,120 18,960 Add: Budgeted ending inventory (pounds) 7,584 9,216 Total materials requirements (pounds) 22,704 28,176 Deduct: Beginning inventory (pounds) 6,048 7,584 Materials to be purchased (pounds) 16,656 20,592 24 March 19,200 1.20 23,040 10,080 33,120 9,216 23,904 25 26 27 28 29 30 Material price per pound Total budgeted cost of direct materials purchases $6.00 $99,936 $6.00 $123,552 $6.00 $143.424 31 Multiple Choice =+D 22+F14+F15 =+D24*F11 =+E24*$F$11 =+$D$24*$F$11