Read Chapter 8: Aggregate Planning in a Supply Chain and review the author's PP slides. Homework H1 ...

---

Read Chapter 8: Aggregate Planning in a Supply Chain and review the author's PP slides. Homework H10: Answer any three of the Chapter 8 Discussion Questions on p. 222 (see attached). Please make sure your answers to the textbook questions are detailed and not merely 1- or 2-sentence responses). H10_A. In your own words and no less than 1.5 pages, double-spaced, summarize the major learning points of Chapter 8. H10_B: Exercise 1, page 222. Study the problem setup with variable definitions and equations (see exercise 8 setup and discussion pdf) and open the excel and verify setup of this linear programming problem. Then run Solver to obtain the optimal solution. For Exercise 1 part b), change cell E16 of sheet DATA to 40, and run Solver again to obtain the optimal solution. For Exercise 1 part c), change cell E15 of sheet DATA to 1,200 employees, then 1,300, etc., running Solver after each change. For Exercise 1 part d) we add a new constraint: . The constraint is added in the Solver dialog box as I7:I18 <= 1291.667, then Solve to obtain the result $363,049,982. Required Textbook: Supply Chain Management, 7th Edition, Author: Chopra. Publisher: Pearson, ISBN-10: 0134731883.