Check my work View previous attem The Ace Battery Company has forecast its sales in units as follows: January 800 May 1,350 February 650 June 1,500 March 600 July 1,200 April 1,100 Ace 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 960 units, which is consistent with this policy. Materials cost $12 per unit and are paid for in the month after production. Labour cost is $5 per unit and is paid in the month the cost is incurred. Overhead costs are $6,000 per month. Interest of $8,000 is scheduled to be paid in March, and employee bonuses of $13,200 will be paid in June. a. Prepare a monthly production schedule for January through June. (Enter all values as positive value.) Ace Battery Company Production Schedule February March 36 June 258 5821 357 96 25 April 455 524 245 5541 Forecasted unit sales Desired ending inventory Beginning inventory Units to be produced 38 333 250 7855 357 1288 4587 755 152 Check My WUIK view previous allen UHUJUJU HII ulicu. Vllluuuuuw ui Puiu UU PUI TITUI ILII. TRILLILULUI Puvuvi JCIILUurcu LUWU Puiu III ITIUICII, IU CIPIUL $13,200 will be paid in June. a. Prepare a monthly production schedule for January through June. (Enter all values as positive value.) January Ace Battery Company Production Schedule February March 85 25 April May June B EBE 455 200 121 Forecasted unit sales Desired ending inventory Beginning inventory Units to be produced 35 524 245 5541 333 250 7855 1288 458 755 b. Prepare a monthly summary of cash payments for January through June. Ace produced 600 units in December. May December 852 Ace Battery Company Summary of Cash payments January February March 456 325 1251 951 250 687 852 741 934 360 137 2580 April 521 156 Units produced Material cost Labour cost Overhead cost Interest Employee bonuses Total cash payments 1258 369 650 June 369 520 745 360 753 258 350l $ 128 $ 380 $ 890 $ 750 $ 102 $ 125