SL Return to question Problem 4-23 Schedule of cash payments [LO4-2] The Volt Battery Company has forecast its sales in units as follows January 2.200 February 2010 March 2. April 2,500 Hay 2.750 June 2.000 July 2,600 Volt Battery always keeps an ending inventory equal to 120 percent of the next month's expected sales. The ending inventory for December January's beginning inventory is 2640 units, which is consistent with this policy Materials cost 11 per unit and are paid for in the month after purchase Labor cost is 54 per unit and is paid in the month the cost is incurred Overhead costs 53.000 per month Interest of $9400 is scheduled to be paid in March, and employee bonuses of $14,500 will be paid in June BAN 1 of 10 Next > P 8 DO 8 This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question Incurred. Overhead costs are $13,000 per month Interest of 59.400 is scheduled to be paid in March, and employee bonuses of $14,600 will be paid in June o. Prepare a monthly production schedule for January through June. Answer is complete and correct. July 2.500 Projected unit Sales Desired ending inventory Total units required Beginning inventory Units to be produced January 2200 2460 4660 2.540 2.020 Volt Battery Company Production Schedule February March 2050 2000 2.400 3.000 4 450 5 000 2.460 2.400 1990 2.600 April 2.500 3.300 5.800 3000 2.800 May 2.750 3.100 230 3200 2.930 June 2.900 3120 5020 3.480 2.540 RAM 1 of 10 DIE Next > Return to question b. Prepare a monthly summary of cash payments for January through June Volt Battery produced 2,000 units in December 3 Answer is not complete. Volt Battery Company Summary of Cash Payments February January March April June May December 2.000 5 22.000 8.000 13.000 22.220 S 1960 13.000 Units produced Material cost Labor cost Overhead cost interest Employee bonus Total cash payments 2850 10,000 13,000 9:00 28.600 11 200 13.00 30.800 11.720 13 000 32 230 10.160 13.000 GOD 69990 $ 5 43.80 543,080 5 54890 5 3 52.000 55520 ROBY 110 15 Next > & ING DO 9 4 80