I Just need someone to do c ) please

1 of 2 urers produces different models of product P. The Operations Manager of ABC has to develop aggregate production plan for the next 6 months, April to September. Below given are the data for the aggregate unit of product P. 24 Month April May June July August September Working days Demand 20 15000 7000 189000 12000 20000 14000 26 The Operations Manager found that there will be 130 workers working in March and 900 units in the inventory at the end of March. He wants to have 1400 units in the inventory at the end of September. A worker requires 2 hours to make one unit. It works 8 hours a day. Cannot hold more than 200 workers. Cost Data are given below: Hiring cost/worker $500 Firing cost/worker $1,000 Inventory holding cost $8/unit/month Shortage cost $15/unit/month Regular labor cost $20/hour Overtime labor cost $30/hour Material cost $75/unit Subcontract cost $140/unit ABC's labor policy restricts the overtime production not to exceed 15% of regular production. Workers are paid full time payment. Develop aggregate production plan for ABC for the month April to September using the following methods: a. Pure Level (constant workforce with no overtime, subcontract, hire, or fire during the planning horizon) b. Pure Chase ((production - demand) with no overtime, subcontract, or shortage during the planning horizon) c. Constant workforce of 125 and any excess requirement will be met by subcontracting (no overtime during the planning horizon) d. Optimal plan using excel i. Write down the mathematical model (Decision Variables, Objective Function, and Constraints). ii. Develop the excel model Use excel solver to get the optimal plan