Question
Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun
Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. |
Month | May | Jun | Jul | Aug | Sep | Oct |
Forecast | 4,000 | 4,800 | 5,600 | 7,200 | 6,400 | 5,000 |
Use the following information to develop aggregate plans. |
Regular production cost | $10 | per case |
Regular production capacity | 5,000 | cases |
Overtime production cost | $16 | per case |
Subcontracting cost | $20 | per case |
Holding cost | $1 | per case per month |
Beginning inventory | 0 | |
1. | Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. |
a. | Use level production. Supplement using overtime as needed. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) |
Period | May | Jun | Jul | Aug | Sep | Oct | Total |
Forecast | 4,000 | 4,800 | 5,600 | 7,200 | 6,400 | 5,000 | 33,000 |
Output | |||||||
Regular | |||||||
Overtime | |||||||
Output - Forecast | |||||||
Inventory | |||||||
Beginning | |||||||
Ending | |||||||
Average | |||||||
Backlog | |||||||
Costs: | |||||||
Regular | $ | $ | |||||
Overtime | |||||||
Inventory | |||||||
Back orders | |||||||
Total | $ | $ | |||||
b. | Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) |
Period | May | Jun | Jul | Aug | Sep | Oct | Total |
Forecast | 4,000 | 4,800 | 5,600 | 7,200 | 6,400 | 5,000 | 33,000 |
Output | |||||||
Regular | |||||||
Overtime | |||||||
Subcontract | |||||||
Output - Forecast | |||||||
Inventory | |||||||
Beginning | |||||||
Ending | |||||||
Average | |||||||
Backlog | |||||||
Costs: | |||||||
Regular | $ | $ | |||||
Overtime | |||||||
Subcontract | |||||||
Inventory | |||||||
Back orders | |||||||
Total | $ | $ | |||||
c. | Use overtime up to 750 cases per period and inventory to handle variations in demand. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) |
Period | 1 | 2 | 3 | 4 | 5 | 6 | Total |
Forecast | 4,000 | 4,800 | 5.600 | 7,200 | 6,400 | 5,000 | 33,000 |
Output | |||||||
Regular | |||||||
Overtime | |||||||
Output - Forecast | |||||||
Inventory | |||||||
Beginning | |||||||
Ending | |||||||
Average | |||||||
Backlog | |||||||
Costs: | |||||||
Regular | $ | $ | |||||
Overtime | |||||||
Hire/Lay off | |||||||
Inventory | |||||||
Back orders | |||||||
Total | $ | $ | |||||
2. | Which plan has the lowest total cost? | ||||||||
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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