(Step-by-Step) A manufacturer of commercial furniture develops an 8-month aggregate plan. Demand and capacity (in units) for display cabinet are forecast
Question:
A manufacturer of commercial furniture develops an 8-month aggregate plan. Demand and capacity (in units) for display cabinet are forecast as follows:
| Capacity | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |
| Regular time | 235 | 255 | 290 | 300 | 300 | 290 | 300 | 290 |
| Overtime | 20 | 24 | 26 | 24 | 30 | 28 | 30 | 30 |
| Subcontract | 12 | 16 | 15 | 17 | 17 | 19 | 19 | 20 |
| Demand | 255 | 294 | 321 | 301 | 330 | 320 | 345 | 340 |
The cost of producing each unit is $1000 on regular time, $1300 on overtime, and $1800 on a subcontract. Inventory carrying cost is $200 per unit per month. There is no beginning and ending inventory in stock and no backorders are permitted from period to period.
- Setup a production plan that minimizes cost. Use regular time capacity first, then overtime, and then subcontracting. What is this plan’s cost?
- Through better planning, regular time production can be set at exactly the same amount, 275 units per month. Does this alter the solution? Why or why not?
- If overtime costs rise from $1300 to $1400, will your answer to part (a) change? What if overtime costs fall to $1200?
Deliverable: Word Document 