Sensitivity Analysis

 

Changes

Graphical interpretation

Impact

Excel output

Change a non-basic decision variable to basic

 

Change from one corner point to the other

Impair the optimal objective function value (i.e., Z or C)

The magnitude of impairment can be derived from the column "Reduced Cost" under the block Adjust Cells

Change the coefficient of a given decision variable in the objective function

 

Change the slope of the objective function

May or may not change the optimal solution mix depending on the allowable range associated with that decision variable

The range can be derived from the column "Allowable Increase" and "Allowable Decrease" under the block Adjust Cells

Change the right hand side (RHS) value of a given constraint

 

shift the constraint 

May or may not change the optimal objective function value depending on the allowable range associated with that RHS

The change in optimal objective function value can be derived from the column "Shadow Price" under the block Constraints  The allowable range can be derived from the column "Allowable Increase" and "Allowable Decrease" under the block Constraints

Objective function:
1.  The opportunity/reduced cost of a given decision variable can be interpreted as the rate at which the value of the objective function (i.e., profit) will deteriorate for each unit change in the optimized value of the decision variable with all other data held fixed.

2.  The allowable increase/decrease associated with the original coefficient of a decision variable tells us the range in which the coefficient of a given decision variable in the objective function may be increased/decreased without changing the optimal solution, where all other data are fixed.

Constraint:
1.  The shadow price of a given constraint can be interpreted as the rate of improvement in the optimal objective function value, (e.g., Z in maximizing profit or C in minimizing cost) as RHS of that constraint increases with all other data held fixed. "Rate of improvement" means "rate of increase" for a maximization model; and "rate of decrease" for a minimization model. If the RHS is decreased, the shadow price is the rate at which Z (or C) is impaired.

2.  The above interpretation of shadow price is valid only within a range of the given RHS. The shadow price may change to a different value outside this allowable range. The shadow price information does not tell us how the optimal solution mix (i.e., the values for decision variables X1, X2, etc.) changes.