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. (Subtracted amounts should be indicated by a minus sign.) Need help with Begginning Inventory and Units to be prduced. |
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
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