Question
The Volt Battery Company has forecast its sales in units as follows: January 2,000 May 2,550 February 1,850 June 2,700 March 1,800 July 2,400 April
The Volt Battery Company has forecast its sales in units as follows:
January | 2,000 | May | 2,550 | |
February | 1,850 | June | 2,700 | |
March | 1,800 | July | 2,400 | |
April | 2,300 | |||
Volt Battery always keeps an ending inventory equal to 140% of the next months expected sales. The ending inventory for December (Januarys beginning inventory) is 2,800 units, which is consistent with this policy. Materials cost $15 per unit and are paid for in the month after purchase. Labor cost is $8 per unit and is paid in the month the cost is incurred. Overhead costs are $12,000 per month. Interest of $9,200 is scheduled to be paid in March, and employee bonuses of $14,400 will be paid in June. a. Prepare a monthly production schedule for January through June.
Volt Battery Company Production Schedule | |||||||
January | February | March | April | May | June | July | |
Projected unit sales | |||||||
Desired ending inventory | |||||||
Total units required | |||||||
Beginning inventory | |||||||
Units to be produced | |||||||
Summary Of Cash Payments | |||||||
December | January | February | March | April | May | June | |
Units produced | |||||||
Payments: | |||||||
Material cost | $ | $ | $ | $ | $ | $ | |
Labor cost | |||||||
Overhead cost | |||||||
Interest | |||||||
Employee bonuses | |||||||
Total cash payments | $ | $ | $ | $ | $ | $ | |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started