Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
FIGURE D-24
Solver could not find a feasible solution with a reduced vehicle fleet
Fortunately, Solver did find an optimal solution. To update the spreadsheet with the new optimal values
for the Changing Cells and the Optimization Cell, click OK in the Solver Results dialog box. You can also print
an Answer Report by clicking the Answer option in the Solver Results dialog box (see Figure D-25) and then
clicking OK.
FIGURE D-25
Printing an Answer Report
Excel will create a report in a separate sheet called Answer Report 1. The Answer Report is shown in
Figures D-26 and D-27.
 
Search JabSto ::




Custom Search