第五章 线性规划的What-If分析.ppt

Table of ContentsChapter 5 (What-If Analysis for Linear Programming) Wyndor (Before What-If Analysis) Using the Spreadsheet to do Sensitivity Analysis Using the Spreadsheet to do Sensitivity Analysis Using the Spreadsheet to do Sensitivity Analysis Using Solver Table to do Sensitivity Analysis Using Solver Table to do Sensitivity Analysis Using the Sensitivity Report to Find the Allowable Range Graphical Insight into the Allowable Range Using the Spreadsheet to do Sensitivity Analysis Using the Spreadsheet to do Sensitivity Analysis Using Solver Table to do Sensitivity Analysis Using Solver Table to do Sensitivity Analysis Using Solver Table to do Sensitivity Analysis The 100 Percent Rule The 100 Percent Rule for Simultaneous Changes in Objective Function Coefficients: If simultaneous changes are made in the coefficients of the objective function, calculate for each change the percentage of the allowable change (increase or decrease) for that coefficient to remain within its allowable range. If the sum of the percentage changes does not exceed 100 percent, the original optimal solution definitely will still be optimal. (If the sum does exceed 100 percent, then we cannot be sure.) Graphical Insight into 100 Percent Rule Graphical Insight into 100 Percent Rule Using the Spreadsheet to do Sensitivity Analysis Using the Spreadsheet to do Sensitivity Analysis Using the Spreadsheet to do Sensitivity Analysis Using Solver Table to do Sensitivity Analysis Using the Sensitivity Report Graphical Interpretation of the Allowable Range Using the Spreadsheet to do Sensitivity Analysis Using Solver Table to do Sensitivity Analysis The 100 Percent Rule The 100 Percent Rule for Simultaneous Changes in Right-Hand Sides: The shadow prices remain valid for predicting the effect of simultaneously changing the right-hand sides of some of the functional constraints as long as the changes are not too large. To check whether the changes are small enough, calculate for each change the perce