Assignment:
A planner has developed an aggregate forecast for demand for the next 6 months as shown below: Month January February March April May June Forecast 6000 5000 6000 5500 6000 7000 Use the following information to develop aggregate plans: Regular production cost: $10.00 per case Regular production capacity: 5500 cases/month Overtime production cost: $15.00 per case Subcontracting cost: $20.00 per case Holding/Carrying cost: $2.00 per case per month Develop an aggregate production plan for each of the following guidelines and compute the total cost for each plan. Note: backlogs are not allowed.
1. Use level-capacity production and supplement with inventory and subcontracting as needed.
2. Use a combination of inventory, regular production, overtime (maximum 200 cases per month), and subcontracting (maximum 300 cases per month) as needed.
3. Use regular production, inventory and overtime (500 cases maximum per month). Use "Solver" to set up and answer all three parts.