A manufacturer produces goods at five US cities, from which the goods are sent to seven major
Question:
A manufacturer produces goods at five US cities, from which the goods are sent to seven major customers in the following cities: Frankfort, Greenville, Jackson, Kankakee, Louisville, Miami, and Oakdale. The monthly production of the goods is shown in the table below:
Manufacturing Cities | Monthly Production (tons) |
Atlanta | 500 |
Boston | 800 |
Chicago | 600 |
Dallas | 400 |
Evansville | 400 |
The monthly demands for each customer (in tons) are shown below.
Frankfort | Greenville | Jackson | Kankakee | Louisville | Miami | Oakdale | |
Demand | 200 | 300 | 400 | 200 | 400 | 500 | 200 |
The shipping costs per ton of product from the manufacturers to the customers are shown in the table below.
Shipping costs per ton ($): | |||||||
From/to | Frankfort | Greenville | Jackson | Kankakee | Louisville | Miami | Oakdale |
Atlanta | 90 | 100 | 130 | 200 | 120 | 120 | 150 |
Boston | 70 | 80 | 90 | 90 | 160 | 200 | 180 |
Chicago | 220 | 120 | 140 | 100 | 100 | 70 | 90 |
Dallas | 180 | 150 | 110 | 50 | 140 | 80 | 110 |
Evansville | 50 | 110 | 100 | 60 | 80 | 150 | 120 |
Solve a Transportation Problem in Excel to find the lowest cost delivery plan to meet the customers' requirements.
(i) Report the minimum cost from your solution.
(ii) Insert (paste) below the Excel spreadsheet that you used showing the optimal solution. (include all rows and columns of the spreadsheet)
Minimum cost =
(iii) - - Paste Your Excel Spreadsheet Here - -
How much does Chicago send to each destination?
From where does Frankfort receive shipments?
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley