Applying Excel 14: Required units of Available Production Which formula would NOT result in the correct units of available production in cell F26? D A 3 4 5 6 7 8 9 B C E 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 10 March $200 19,000 20,000 21,000 20% 40% 2,400 6,048 1.20 $6.00 20 $18.00 11 12 13 14 15 16 17 18 19 20 Production Budget For the months of January February, and March January February Next month's budgeted sales (units) Balt: 15 000 119,000 21 March 20,000 22 9 10 11 12 21,000 20% 40% 2,400 6,048 1.20 $6.00 20 $18.00 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 13 14 15 16 17 18 19 20 21 22 23 24 25 Production Budget For the months of January February, and March January February Next month's budgeted sales (units) 15,000 19,000 Ratio of inventory to future month's sales 20% 20% Budgeted ending inventory (units) 3,000 3,800 Add: BU sales (units) 12.000 15,000 Required units of available production 15,000 18,800 Deduct: Beginning inventory (units) 2.400 3,000 Budgeted units to produce 12,600 15,800 March 20,000 20% 4,000 19.000 23,000 3.800 19 200 26 27 28 29 Multiple Choice =+F22*F23+F25 3+F22*F23+F7 =+F7*F10+F24 =+F24+F25