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

þ