5. The Gaint Farmer Company Processes food for Sale in discount food stores. It has two plants: One in Chicago and one in Houston, The Company also operate warehouses in Miami, Florida; Denver, Colorado; Lincoln, Nebraska; and Jackson, Mississippi. Forecasts indicate that demand soon will exceed supply and that a new plant with a capacity of 8,000 cases per week is needed. The question is where to locate the new plant. Two potential sites are Buffalo, New York, and Atlanta. The two tables at the bottom give data on capacities, forecasted demand and, and shipping costs that have been gathered. For each alternative new plant location, determine the shipping pattern that will minimize total transportation costs. Where should the new plant be located? Capacity (Cases for Week) Demand (Cases Plant Warehouse for Week) Miami Chicago 10,000 7,000 9,000 ouston New Plant 500Denver 8,000 Lincoln Jakson Total Demand 5,000 r Case Plant Miami Denver $2.00 $1.00 59.00 10.00 $4.00 $5.00 $7.00 $8.00 Chicago $7.00 $5.00 $2.00 $4.00 Buffal ofaltemate 1)56.00