Page 684 - Excel 2013 All-in-One For Dummies

666 Using the Solver
The report shows the changing cells with their final values and the reduced gradient for each cell. (The reduced gradient measures the objective per unit increase in the changing cell.) If you defined con- straints, the Sensitivity report lists them with their final values and the Lagrange multiplier for each constraint. (The Lagrange multiplier mea- sures the objective per unit increase that appears in the right side of the constraint equation.)
✦ Limits report: Shows the target cell and the changing cells with their values, lower and upper limits, and target results. The lower limit rep- resents the lowest value that a changing cell can have while fixing the values of all other cells and still satisfying the constraints. The upper limit represents the highest value that will do this.
Excel places each report that you generate for a Solver problem in a sepa- rate worksheet in the workbook. To generate one (or all) of these reports, select the report type (Answer, Sensitivity, or Limits) from the Reports list box of the Solver Results dialog box (as shown previously in Figure 1-13). To select more than one report, just click the name of the report.
When you click OK to close the Solver Results dialog box (after choosing between the Keep Solver Solution and Restore Original Values options), Excel generates the report (or reports) that you selected in a new worksheet that it adds to the beginning of the workbook. (Report sheet tabs are named by report type, as in Answer Report 1, Sensitivity Report 1, and Limits Report 1.)