The Volt Battery Company has forecast bs sales in units as follows January 1,300 May1850 February 1,150 June 2000 March 1,100 July 1,700 April 1 1,600 Voit Battery always keeps an ending inventory equal to 110% of the next morm's expected sales. The ending inventory for December (January's beginning inventory) is 1 430 uails, which i& consistent w policy Materials cost $14 per unit and are paid for in the month after parchase Labor cost i7 pecnt and is paid in the month the cost is incurred Overhead costs are 58,500 per month onest of $8 500 scheduled to be paid in March, and employee bonuses of $13.700 wil be paid r,June a. Prepare a monthly production schedule for January theough June. (Subtracted amounts should be Indicated by a minus sign) Vo Battery Company Producion Schedule June 1100 1850 2000 1700 O 150 O Projected uni sales Desired ending inventory 1210 Total units required Beginning inventory 2860 O 1210 635 1760 3870 o 2200 265 O 2635 Units to be produced 1095 O 1650 O b. Prepare a monthly summary of cash payments for January through June Voit produced 1,100 units in December Summary Of Cash Payments March December 1100 1135 1095 1650 1875 2015 1670 Units produced Payments S15400 $ Material cost Labor cost Overhead cost Interest 1550 8500 11690 8500 8500 O 8500 8500 8500 13700 Employee bonuses O s43880 44725 $ Total cash payments