Demand:

Week 1: 2850

Week 2: 2900

Week 3: 2950

Week 4: 3000

Please show all steps in excel.

Paragraph Styles 3. Product E is a new product and manufactured by Alpha company itself. This product was introduced to the market on July 2018 and the feedback of the market was very positive. Mary had provided the 2018 historical sale data of product E in the attached file. She wanted Jason to determine the optimal production plan for the first 4 weeks of 2019 for product E. Some information is given here: 2018 last week's output =2,800 Beginning inventory = 0 Inventory holding cost = $40 per unit per week Hiring employees = $40 per unit Terminating employee = $80 per unit Subcontracting cost =$60 per unit Unit cost on regular time = $30 per unit Overtime cost = $15 extra per unit Jason's job is to develop an aggregate plan. The three initial options he wants to evaluate are: a. Plan A: a chase strategy that hires and fires personnel as necessary to meet the forecast b. Plan B: a level strategy. C. Plan C: a level strategy that produces 2,800 units per week and meets the forecasted demand with inventory and subcontracting. Which strategy Jason should to choose to get the lowest expected cost? (35 points) RI F. F7 F8 F9 FID