Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
In row 15, columns D, E, and F, enter
respectively, as equipment
In row 15, columns G through N, enter
Volume for Trucks,
Volume for Tractor-Trailers,
Total Vehicle Capacity,
% of Vehicle
respectively, as column headings.
In rows 16 through 20, column B, enter the destination store locations.
In rows 16 through 20, column C, enter the number of miles to the destination store locations.
In rows 16 through 20, columns D through F, enter the number of exercise bikes (EB),
cross-trainers (CT), and treadmills (TM) to be shipped to each store location.
Rows 16 through 20, columns G through N, will contain formulas or
them blank for now, but fill cells H16 through H20 and cells J16 through J20 with a light color to
indicate that they are the Changing Cells for Solver.
In cell F21, enter
to label the following cells in the row.
Cells G21 through N21 will be used for column totals. Highlight cell N21 with a different light
color fill from the Changing Cells. Cell N21 is your Optimization Cell.
In cell B22, enter
as a label.
Fill cell C22 with the fill color you selected for the Changing Cells.
In cells D22 and E22, enter
as the label for the fill color. Merge and center the
label in the cells.
In cell N22, enter
as the label for the value in cell N21.
Fill cell C23 with the fill color you selected for the Optimization Cell.
In cells D23 and E23, enter
as the label for the fill color. Merge and center
the label in the cells.
Figure D-7 illustrates a magnified section of the Distance/Demand table in case the numbers in Figure D-6
are difficult to read.
Magnified view of the Distance/Demand table
Use the Borders menu in the Font group to select and place appropriate borders around parts of the
Calculations and Results section (see Figure D-8). The All Borders and Outside Borders selections are the
most useful borders for your table.