Which of the following formulas would be correct in cell F25? A B D E F 3 4 5 6 7 8 9 10 11 12 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 March $200 19,000 20,000 21,000 20% 40% 2,400 6,048 1.20 $6.00 2.0 $18.00 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 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 March 19 200 1.20 23,040 10,080 33120 9.216 23 904 28 29 30 31 Material price per pound Total budgeted cost of direct materials purchases $6.00 $99.936 $6.00 $123552 $6.00 $143.424 Multiple Choice O =+F9*F14*F11 =+F9+F14-F11 =+F87F14-F11 =+F8 F14 F10