Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
Next, you write the formulas for the volume and cost calculations. Figure D-9 shows a magnified view of
the Vehicle Loading and Cost sections. A discussion of the formulas required for the cells follows the figure.
Vehicle Loading and Cost sections
For illustration purposes, the cell numbers in the following list refer to values for the Philadelphia store.
Cell G16 contains the total shipping volume of the three types of equipment
shipped to the Philadelphia store. The formula for this cell is
Cells D16, E16, and F16 are the quantities of each item to be shipped, and cells $C$8, $C$9, and
$C$10 are the shipping volumes for the exercise bike, cross-trainer, and treadmill, respectively.