Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
You are ready to solve the shipping problem to include the new stores in Denver and Phoenix. Figure D-36
shows the updated Solver Parameters window.
Solver parameters updated for shipping to seven stores
Before you run Solver again, you might want to attempt to assign the trucks manually, because your fleet
may not be large enough to handle two more stores. In this case, you will quickly realize that the vehicle
fleet is at least one truck or tractor-trailer short of the minimum required to ship the needed volume. You
can confirm this by running Solver (see Figure D-37).
Vehicle fleet does not meet minimum requirements