Part IV: Managing and Analyzing Data
See Chapter 31, “Performing Spreadsheet What-If Analysis,” for more on Scenario Manager.
The Reports section of the Solver Results dialog box lets you select any or all of three
optional reports. If you specify any report options, Excel creates each report on a new
worksheet, with an appropriate name. Figure 32.8 shows an Answer Report. In the
Constraints section of the report, three of the four constraints are binding, which means
that these constraints were satisfied at their limit with no more room to change.
FIGURE 32.8
One of three reports that Solver can produce
