Aggregate Planning in a Supply Chain

Instructions: You don’t have to submit the spreadsheet, simply explain your answer in words by what you see/understand in MS Excel. Chapter 8 – Aggregate Planning in a Supply Chain Answer the following question using the spreadsheet. This question is discussed in the textbook in Section 8.2. Right click and save the Red Tomato Demo to your hard drive. Using the original data in the file, what happened to inventory and stock-outs over the six periods of the planning horizon? Right click and save the Red Tomato Demo for Example 1 to your hard drive. What happened to stock-outs as demand fluctuation increased? What happened to profits? What did you learn from this exercise? Right click and save the Red Tomato Demo for Example 2 to your hard drive. What happened to the use of subcontractors as holding costs increased? What happened to profits? What did you learn from this exercise?