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?