Operations Research Models and Methods / Computation / Mathematical Programming /
Linear/Integer Programming

Sensitivity Analysis

The sensitivity analysis provided by the Excel Solver for the example is shown below. We assume that the student is familiar with the meaning of the various terms, so they will not be discussed here. Note however that the ranges associated with the objective coefficients are given by allowable increases and decreases. For example, the row for P1 indicates that the objective coefficient value (18 in the data) can range between 13.26 and 26.81 (to two decimal places) while the current solution remains optimal. The ranges for the R.H. Side values are similarly specified.

Integer Variables

Updated 1/16/01
Operations Research Models and Methods

by Paul A. Jensen and Jon Bard, University of Texas, Copyright by the Authors