1.Text.P.180.Figure A.16

1.Text.P.180.Figure A.16 - BIO Appendix A Building...

This preview shows page 1 out of 1 page.

Image of page 1

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.. E' i a. E E E: n Illli 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) Click OK 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

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern