please use excel solver and the range names to fill out the chart.

54. General Ford produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points are listed in the file P05_54.xlsx, where a blank means that a shipment is not allowed. Los Angeles can produce up to 1600 cars, and Detroit can produce up to 3200 cars. Houston must receive 1800 cars, and Tampa must receive 2900 cars. a. Determine how to minimize the cost of meeting demands in Houston and Tampa. b. Modify the answer to part a if no shipments through Atlanta are allowed. Problem 5.54(a) - General Ford (p. 269) Range names used: Unit shipping costs Capacitics ='Part (a)'1SJS14:5JS15 CostMatrix - Part (a)'SCS6:56510 Costs ='Part (a) =SCS14.SCS31 Demands =Part (a)'ISJS17:SIS18 Dests =Part (a) 15B$14.5B$31 Flows ='Part (a)!SDS14:5DS31 Inflows -Part (a) 'ISHS17:SHS18 NetOutflow ='Part (a)'LSHS16 Origins ='Part (a)'SAS14:5A531 Outflows, ='Part (a)'ISHS14:SHS15 Network formulation Flow balance constrants lotCost "-Part (a)'ISB\$33 Origin Destination Cost Flow Location Index Net flow oat/in LA. Detroit Atlanta. Houston Reqt