Course Hero Logo

Asst2-S21 (1).pdf - ISE 426 (ESYE 549) Logistics Systems...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 2 pages.

1ISE 426 (ESYE 549) Logistics Systems (Logistics Systems Planning and Design)Spring 2021Assignment #2Due on16 April 2021, Friday, 23:59 (thru COADSYSEXAM)YOU SHOULD ATTEMPT TO SOLVE ALL QUESTIONS TO RECEIVE A PASS (100%) or IT IS A FAIL (0%).1)[25 points] TRANSPORTATION PROBLEM:A company that produces a single product has threeplants and four customers. The three plants will produce 3000, 5000, and 5000 units, respectively,during the next time period. The company has made a commitment to sell 4000 units to customer 1,3000 units to customer 2, and at least 3000 units to customer 3. Both customers 3 and 4 also want to buyas many of the remaining units as possible. The profit associated with shipping a unit from each plant toeach customer is given in the following table.Unit ProfitsCust 1Cust 2Cust 3Cust 4Plant 1$65$63$62Plant 2$68$67$66Plant 3$63$60$59Determine how tomaximizethe company’s profitusing EXCEL.$64$62$60Submit your answer in an EXCEL worksheet named as “Q1through the “Assignment2” availableunder “Assignments” in

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
NoProfessor
Tags
Operations Research, Book of Job, Book of Proverbs

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture