This question has already been answered on transtutors but I would like an original solution. Attached is the answers I have. Specifically answers to the questions below.
Aggregate Planning in a Supply Chain
1. Right click and save theRed Tomato DemoPreview the documentView in a new window to your hard drive. (file attached) Using the original data in the file, what happened to inventory and stockouts over the six periods of the planning horizon?
2. See theRed Tomato Demo for Example 1Preview the documentView in a new window (File attached) What happened to stockouts as demand fluctuation increased? What happened to profits? What did you learn from this exercise?
3. SeeRed Tomato Demo for Example 2Preview the documentView in a new window. What happened to the use of subcontractors as holding costs increased? What happened to profits? What did you learn from this exercise?
Note: Use the "Solver" capability under the "Tools" menu for the above three exercises.
*Note on using the "Solver" Add-In:The Solver Add-in is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first. You should have completed doing so in Module 3.
Link to the problem solved but the questions do not seemed to be answered.