Please ignore the data provided in the case study and use the following data :

Opening Stock: 80 units

Desired Closing Stock: 300 units

Backorder Costs: $ 70/ unit

In-house production costs: $ 49.5 per unit

Subcontract Production costs: $ 75 per unit

Inventory Holding costs: $ 15 / unit/ month

Production Capacity: 25 units per month per worker

There are currently 80 workers employed

Hiring Costs 450$ per worker

Firing Costs 1200$ per worker

Please use the Forecast Demand data in the worksheet provided and modify the worksheet as required. Please note the Case data is refreshed with new demand and other data.

1. Compute the total using this sheet for Chase strategy, Level and Subcontract.