- Answer for question 1 is in the attached excel screenshot. based on that please answer questions 2 and 3

1. Utilizing the DQ Week 3 Template in Week 3 materials, complete scenarios for each of the Aggregate Planning Strategies. Go to the data tab, copy the data in each column for Chase, Flex, and Level into the Cost column (right now the original column data is in the Cost column). Then click on Production tab and run Solver. You will need to this for each strategy. .
2. Once completed compare and contrast the results for each strategy in terms of soft costs (impact to people and brand image) and tangible costs (financials).
3. Identify one company or industry which utilizes each of the strategies (exclusively) and identify how you see them implementing it.

Hybrid Strategy Total cost = $ Per unit cost = 359,015,040 24.18 Scenario Analysis Section Hybrid Strategy Total cost = $ $ 349,917,014 Per unit cost = 23.56 = Cost of Chase Strategy Total cost = $ Per unit cost = 350,566,667 23.61 Cost of Flexibility Strategy Total cost = $ 353,393,600 Per unit cost = 23.80 Cost of Level Strategy Total cost = $ 359,015,040 Per unit cost = 24.18