Scarn Logistics has two plants and ships canned vegetables to customers in four cities. The

Question: Scarn Logistics has two plants and ships canned vegetables to customers in four cities. The cost of shipping one case from a plant to a customer is given in the accompanying table. The plant in Akron has a capacity of 3,700 cases per​ week, and the Evansville plant can produce 4,200 cases per week. Customer orders for the next week are as​ follows:Scarn Logistics has two plants and ships canned vegetables to customers in four cities. The cost of shipping one case from a plant to a customer is given in the accompanying table. The plant in Akron has a capacity of 3,700 cases per​ week, and the Evansville plant can produce 4,200 cases per week. Customer orders for the next week are as​ follows: Chicago:1,200 ​cases; Cincinnati: 2,100 ​cases; Indianapolis: 2,500 cases; Pittsburgh:1,400 cases. Find the​ minimum-cost shipping plan.

Plant/Customer Chicago Cincinnati Indianapolis Pittsburgh Akron 1.72 2.26 2.47 2.15 Evansville 1.91 2.39 1.64 2.98
We have been given the following cost matrix for shipping a case between different locations along with Customer orders and plant capacity: To determine the minimum cost shipping plan, we can develop the case as a transportation model and use Excel S…View the full answer