Microsoft Office Tutorials and References
In Depth Information
Saving and reusing the Solver parameters
you want, and then click OK. Each report is saved on a separate worksheet in the current
The Sensitivity report
The Sensitivity report provides information about how sensitive your target cell is to
changes in your constraints. This report has two sections: one for your variable cells
and one for your constraints. The right column in each section provides the sensitivity
Each changing cell and constraint cell appears in a separate row. The Changing Cell area
includes a Reduced Gradient value that indicates how the target cell would be affected by a
one-unit increase in the corresponding changing cell. Similarly, the Lagrange Multiplier
column in the Constraints area indicates how the target cell would be affected by a one-unit
increase in the corresponding constraint value.
The Answer report
The Answer report lists the target cell, the variable cells, and the constraints. This report
also includes information about the status of and slack value for each constraint. The status
can be Binding, Not Binding, or Not Satisfied. The slack value is the difference between the
solution value of the constraint cells and the number that appears on the right side of the
constraint formula. A binding constraint is one for which the slack value is 0. A nonbinding
constraint is a constraint that was satisfied with a nonzero slack value.
If you select the Assume Linear Model option in the Solver Options dialog box, the
Answer report is the only report that the Solver produces for you. (The Limits and
Sensitivity reports are not meaningful.)
The Limits report
The Limits report tells you how much you can increase or decrease the values of your
variable cells without breaking the constraints of your problem. For each variable cell, this
report lists the optimal value as well as the lowest and highest values you can use without
violating constraints.
Search JabSto ::

Custom Search