Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
Vehicle Loading and Cost sections with the formulas updated
You are ready to use Solver to determine the optimal vehicle assignment. Click Solver in the Analysis
group of the Data tab. You should notice immediately that you must change the Changing Cells to include the
two new stores; you must also change some of the constraints and add others. Solver has already updated the
Objective cell from $N$21 to $N$23 and has updated the $H$23<
$F$6 constraints for
vehicle fleet size. To update the Changing Cells, click the button to the right of the By Changing Variable
Cells field and select the cells again, or edit the formula in the window by changing cell address $H$20 to
$H$22 and cell address $J$20 to $J$22.
To change a constraint, select the one you want to change, and then click Change (see Figure D-33).
$F$5 and $J$23<
Selecting a constraint to change