Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
FIGURE D-22
Excel status bar showing Solver running through possible solutions
A new dialog box will appear eventually, indicating that Solver has found an optimal solution to the
problem (see Figure D-23). The portion of the spreadsheet that displays the assigned vehicles and shipping
cost is visible below the Solver Results dialog box. Solver has assigned nine of the 12 trucks and all six
tractor-trailers, for a total shipping cost of $17,398. The earlier manual attempt to solve the problem (see
Figure D-16) assigned all 12 trucks and four tractor-trailers, for a total shipping cost of $18,122. Using Solver
saved your company $724.
FIGURE D-23
Solver Results dialog box
If the Solver Results dialog box does not report an optimal solution to the problem, it will report that the
problem could not be solved given the Changing Cells and constraints you specified. For instance, if you had
not had enough vehicles in your fleet to carry the required shipping volume to all the destinations, the Solver
Results dialog box might have looked like Figure D-24. In the figure, your vehicle fleet was reduced to
10 trucks and five tractor-trailers, so Solver could not find a solution that satisfied the shipping volume
constraints.
 
Search JabSto ::




Custom Search