Question
The Volt Battery Company has forecast its sales in units as follows: January 900 May 1,450 February 750 June 1,600 March 700 July 1,300 April
The Volt Battery Company has forecast its sales in units as follows:
January | 900 | May | 1,450 | |
February | 750 | June | 1,600 | |
March | 700 | July | 1,300 | |
April | 1,200 | |||
Volt Battery always keeps an ending inventory equal to 110% of the next months expected sales. The ending inventory for December (Januarys beginning inventory) is 990 units, which is consistent with this policy. Materials cost $10 per unit and are paid for in the month after purchase. Labor cost is $3 per unit and is paid in the month the cost is incurred. Overhead costs are $6,500 per month. Interest of $8,100 is scheduled to be paid in March, and employee bonuses of $13,300 will be paid in June.
a. Prepare a monthly production schedule for January through June.
b. Prepare a monthly summary of cash payments for January through June. Volt produced 700 units in December.
The Volt Battery Company has forecast its sales in units as follows:
January | 900 | May | 1,450 | |
February | 750 | June | 1,600 | |
March | 700 | July | 1,300 | |
April | 1,200 | |||
Volt Battery always keeps an ending inventory equal to 110% of the next months expected sales. The ending inventory for December (Januarys beginning inventory) is 990 units, which is consistent with this policy. Materials cost $10 per unit and are paid for in the month after purchase. Labor cost is $3 per unit and is paid in the month the cost is incurred. Overhead costs are $6,500 per month. Interest of $8,100 is scheduled to be paid in March, and employee bonuses of $13,300 will be paid in June.
a. Prepare a monthly production schedule for January through June.
b. Prepare a monthly summary of cash payments for January through June. Volt produced 700 units in December.
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