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.

IMPORTANT:

Submission requirements:

Please make your submission on the provided Excel Work Sheet.

Your group will lose $100\%$ of the assignment grade if you do not submit your work by the due date.

The team will also include an excel worksheet as a consensus submission for all $3$ strategies i$.$e$.$ Level $/$Chase $/$Subcontract$.$ Please ignore the instruction on the case study about submitting the Hybrid case Study $($Submit the subcontract Strategy$).$

Please ensure you include a title page With the names of team members & submit the files with a name format Meridian Name Member $1\_$Name Member $2\_$Name Member $3.$

The Team reserves the right to exclude from the submission the name of any individual who does not contribute to the submission in which case such individual will receive NO grade for the assignment.