Module Overview


By the end of this module, what should I be able to do?	Which course materials will support me to do it?	Which activity/assessment lets me demonstrate that I can do it?
1. Explain what is meant by "what-if analysis".	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
2. Summarize the benefits of what-if analysis.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
3. Enumerate the different kinds of changes in the model that can be considered by what-if analysis.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
4. Describe how the spreadsheet formulation of the problem can be used to perform any of these kinds of what-if analysis.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
5. Use Parameters with Risk Solver Platform for Education to systematically investigate the effect of changing either one or two data cells to various other trial values.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
6. Find how much any single coefficient in the objective function can change without changing the optimal solution.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
7. Evaluate simultaneous changes in objective function coefficients to determine whether the changes are small enough that the original optimal solution must still be optimal.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
8. Predict how the value in the objective cell would change if a small change were to be made in the right-had side of one or more of the functional constraints.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
9. Find how much the right hand side of a single functional constraint can change before this prediction becomes no longer valid.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2
10. Evaluate simultaneous changes in right-hand sides to determine whether the changes are small enough that this prediction must still be valid.	Chapter 10: What If Analysis for Linear Programming Instructor videos Solver Table videos What-If Data Table video	Week 4 Assignment Week 4 Check Your Understanding Group Project 2 (week 5) Exam 2