Excel solver

Exercise 2: Transportation Problem. Minimize the costs of shipping goods from production plants to warehouses near metropolitan demand centers, while not exceeding the supply available from each plant and meeting the demand from each metropolitan area. Number to shipfrom plant I to warehouse y (at intersection): Plants: Total San Fran Denver Chicago Dallas St Carolina 5 l l l 1 Tennessee 5 l l l 1 Arizona 5 l l l 1 Totals: 3 3 3 3 Demands by the n? 180 80 200 160 Plants: Supph) Shipping cosrsfmm plant 3: to warehouse y {at intersection): S. Carolina 310 10 8 6 5 Tennessee 260 6 5 4 3 Arizona 280 3 4 5 5 Shipping: $83 $19 $17 $15 $13 220 Ch $19 The problem presented in this model involves the shipment of goods from three plants to ve regional warehouses. Goods can be shipped from any plant to any warehouse, but it obviously costs more to ship goods over long distances than over short distances. The problem is to determine the amounts to ship from each plant to each warehouse at minimum shipping cost in order to meet the regional demand, while not exceeding the plant supplies