9 Problem 4-23 Schedule of cash payments [LO4-2] The Voit Battery Company has forecast sales in units as follow January 2.100 Ferry 1.0 March 10 April 1.400 wy 2.650 Tura NY 2.1 Pm o Volt Battery always keeps an ending inventory equal to 10 percent of the next month's expected sales. The ending inventory for December January's beginning inventory) 2.310, which consistent with this policy Materials cost $10 petunt and are paid for in the month after purchate tabor cost is $ent and is paid in the month the cost is incurred. Overhead costs are $12,500 per monterest of $9.300 deded to be paid in March, demployee bonuses of $14.500 will be paid in June . Prepare a monthly production schedule for any through June Volt By Company Production Schedule March April May GY Procedures Derdando Total Beginner U to be produced 0 D o b. Prepare a monthly summary of cash payments for January through June Volt Battery produced 1900 units in December Volt Battery Company Summary of Cash Payment February March December January Apr NY dan Units produced Matracost Lix.co Overhead cool Vitet Employee bonus Total cash payments 05 OS MC Problem 4-23 Schedule of cash payments [LO4-2] The Volt Battery Company has forecast its sales in units as follows: January 2,100 February 1,950 March 1,900 April 2,400 May 2,650 June 2,800 July 2,500 July 2,500 Volt Battery always keeps an ending inventory equal to 110 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 2,310 units, which is consistent with this policy Materials cost $10 per unit and are paid for in the month after purchase. Labar cost is $3 per unit and is paid in the month the cost is incurred. Overhead costs are $12.500 per month. Interest of $9,300 is scheduled to be paid in March and employee bonuses of $14,500 will be paid in June a. Prepare a monthly production schedule for January through June a Volt Battery Company Production Schedule February March January April May June July 0 0 Projected unit sales Desired ending inventory Total units required Beginning inventory Units to be produced 0 0 0 0 Units to be produced 0 0 b. Prepare a monthly summary of cash payments for January through June. Volt Battery produced 900 units December Volt Battery Company Summary of Cash Payments February March December January April Mary Jure Units produced Materlalu Labor cost Overhead Interest Employer boris Total cash payments os os OS OM DS 0