Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
FIGURE D-8
Borders menu
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.
FIGURE D-9
Vehicle Loading and Cost sections
For illustration purposes, the cell numbers in the following list refer to values for the Philadelphia store.
￿
Volume Required
Cell G16 contains the total shipping volume of the three types of equipment
shipped to the Philadelphia store. The formula for this cell is
F16*$C$10.
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.
¼
D16*$C$8
þ
E16*$C$9
þ
 
Search JabSto ::




Custom Search