A 3 4 Which of the following formulas in cell D24 yields the correct answer when copied to cells E24 and F24? D Budget Assumptions For the months of January, February, and March 5 6 Selling price per unit 7 Budgeted sales (units) January $200 12,000 8. Budgeted sales (units) April 9 Budgeted production (units) April 10 Ratio of ending finished goods inventory to next month's sales 11 12 13 Ratio of ending raw materials inventory to next month's requirements Number of units in finished goods inventory, January 11 Number of pounds in raw materials inventory, January 1 14 15 Number of pounds of raw materials required per unit Cost per pound of raw materials 16 Number of direct labor hours required per unit 17 Rate per direct labor hour February March $200 $200 15,000 19,000 20,000 21,000 20% 40% 2,400 6,048 1.20 $6.00 2.0 $18.00 18 19 Sales Budget 20 For the months of January, February, and March 21 22 Budgeted sales (units) 23 Selling price per unit 24 Total budgeted sales (dollars) January February March 12,000 $200 $2,400,000 15,000 19,000 $200 $3,000,000 $200 $3,800,000