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.