1. A distributor received goods at five US ports, from which the goods are sent on to nine major customers in the following nice cities: San Diego, Phoenix, Denver, St. Louis, Dallas, Atlanta, Detroit, Boston, and Albany. Each customer has monthly demand of 350 cases. The monthly availability of the goods at the ports is shown in the table below: Ports Seattle Oakland Norfolk Savannah New York Monthly Availability (cases) 600 1000 800 800 500 a) 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) Fill in the optimal shipping pattern in the table. (iii) Insert below the Excel spreadsheet that you used showing the optimal solution. (iMinimum cost = (0) Optimal shipping pattern (flows): From/t San Denve Atlant Bosto Phoenix Dallas Detroit Louis St. Dieg o Albany o r a n The shipping costs per unit of product from the production plants to the customers are shown below. Seattle Oakland Norfolk Savanna h New York Atlant St. Louis Dallas Detroit Bosto n Albany iii) - Paste Excel Spreadsheet Here - Shipping costs per case (cents): From/t San 0 Dieg Phoenix Denver o Seattle 90 100 130 Oakland 70 60 110 Norfolk 220 250 170 Savanna 180 200 160 h New 200 180 150 York 200 160 100 80 220 180 130 90 260 250 50 25 240 220 70 90 300 290 60 100 280 250 50 90 b) How much does Savannah send to each destination? c) From where does St. Louis receive shipments? 70 90 80 50 60 60