Unformatted text preview: BIO Appendix A Building Spreadsheet Models FIGURE A.l6 EXCEL WORKSHEET USED TO CALCULATE TOTAL SI‘UPPING COSTS
FOR THE FOSTER GENERATORS TRANSPORTATION PROBLEM 9..
El Figure AJG displays an Excel worksheet for the Foster Generators Problem that ap—
pears in Chapter 10. This problem involves the transportation of a product from three plants
(Cleveland. Bedford. and York) to four distribution centers (Boston. Chicago. St. Louis.
and Lexington). The costs for each unit shipped from each plant to each distribution center
are shown in cells B5337, and the values in cells Bl7in9 are the number of units shipped
from each plant to each distribution center. Cell )K13 will contain the total transportation
cost corresponding to the transportation cost value? in cells 35:13? and the values of the
number of units shipped in cells B l?:E19. The following steps show how to use the SUMPRODUCT function to compute the total
transPortation cost for Foster Generators. Step 1. Select cell C13
Step 2. Click fx on the formula bar
Step 3. When the Insert Function dialog box appears:
Select Math & Trig in the 01' select a category box
Select SUMPRODUCT in the Selects function box (as shown in Figure A15)
Step 4. When the Function Arguments box appears (see Figure A17):
Enter 35 :E 7 in the Array] box
Enter 81 7:13.19 in the Arrayz box
Click OK The worksheet then appears as shown in Figure A. 18. The value of the total transportation
cost in cell C13 is 39500. or $39,500. ...
View Full Document
- Fall '08