Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
Top portion of the Answer Report
Bottom portion of the Answer Report—note the new tab created by Solver
The Answer Report gives you a wealth of information about the solution. The top portion displays the
original and final values of the Objective cell. The second part of the report displays the original and final
values of the Changing Cells. The last part of the report lists the constraints. Binding constraints are those
that reached their maximum or minimum value; nonbinding constraints did not.
Perhaps a savings of $724 does not seem significant
however, this problem does not have a specified
time frame. The example probably represents one week of shipments for CV Fitness. The store demands will
change from week to week, but you could use Solver each time to optimize the truck assignments. In a
50-week business year, the savings in shipping costs from using Solver could be well over $30,000!