Please ignore the data provided in the Case study and use the following data & the provided Excel Worksheet :

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 the worksheet provided and modify the worksheet as required. Please note the Case data is refreshed with new demand and other data.