The Ace Battery Company has forecast its sales in units as follow January 2.500 May February 2,354 March 2,300 July April 2,000 Ace always keeps on ending wwentory equal to 110 percent of the next month's expected saler The ending inventory for December January's beginning inventory) is 2750 units, which is consistent with this policy Materials cost $14 per unit and are paid for in the month after production Labour cost is $7 per unit and paid in the month the cost incurred Overhead costs are $14,500 per month Interest of 59.700 is scheduled to be paid in March and employee bonuses of $14.900 will be paid in June m. Prepare a monthly production schedule for January through June (Enteral values as positive value) A Battery Comp Production Schedule February January March Aarti June July Forecasted unit sales 2500 2150 2300 2800 3450 3200 2900 Besired anding inventory 2585 2530 3080 3355 3190 3520 2750 2585 Beginning inventory 2530 3880 3355 3520 OOO Units to be produced 2335 2295 265a 3075 3215 2870 GT ay 1215 ~ b. Prepare a monthly summary of cash payments for January through June, Ace produced 2300 units in Decembet Ace Battery Company sary of cash rets December February March Apen Units produced 2300 12335 2295 2550 2015 Material cost 532200 332650 512150 39900 16100 163450 16065 19950 Labour cost Overhead cost 16500 145e 14500 16500 Interest 9700 Employee bonuses $ 5 5 OC OOO $3250 21535 14500 OOO 2820 45010 22505 14500 OOOO 16900 89 O SESES Total cash payments O $122395 S74350 O 520625 O S16965