8. (20 points). General Ford has two plants, two warehouses, and three customers. The location of these are as follows: Plants: Detroit and Atlanta Warehouses: Denver and New York Customers: Los Angeles, Chicago, and Philadelphia Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Detroit can produce 150 cars per week, and Atlanta can produce 100 cars per week. Los Angeles requires 80 cars per week; Chicago, 70; and Philadelphia, 60. It costs $10,000 to produce a car at each plant, and the cost of shipping a car between two cities is given in the two Tables A and B below. Determine how to meet General Ford's weekly demands at minimum cost. Provide an algebraic formulation of your model along with your Excel solution. Table A: Shipping Costs from Plants to Warehouses. + To ($) From Denver New York Detroit 1,253 637 Atlanta 1,398 841 O Table B. Shipping Costs for Warehouses to Customers. From To ($) Chicago Philadelphia 996 1,691 802 100 Los Angeles 1,059 2,786 Denver New York