develop an effective approach to the problem. First, here is the forecast developed by Marketing: Opening Stock: 120 units

Desired Closing Stock : 1200 units

Back order Costs : $ 100/ unit

In-house production costs : $ 60 per unit

Subcontract Production costs : $ 81 per unit

Inventory Holding costs : $ 15 / unit/ month

Production Capacity: 30 units per month per worker

There are currently 150 workers employed

Hiring Costs 500$ per worker

Firing Costs 1000$ per worker

Please use the Forecast Demand data in Screenshot provided.

please do the Level, Chase and Subcontract strategy in excel sheet and also share another screenshot with all the formulas used.

\f