Please show all formulas used when solving

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 1100 cars, and Detroit can produce up to 2900 cars. Houston must receive 2400 cars, and Tampa must receive 1500 cars. a. Determine how to minimize the cost of meeting demands in Houston and Tampa. b. Modify the answer to part a if shipments between Los Angeles and Detroit are not allowed. c. Modify the answer to part a if shipments between Houston and Tampa are allowed at a cost of $75 per car. Problem 5.54(a) - General Ford (p. 269) Unit shipping costs From LA Detroit Atlanta Houston Tampa LA Detroit Atlanta Houston Tampa 597 $95 $125 $156 $94 $103 $110 $148 $87 $100 $95 $56 $129 $103 588 $100 $147 $145 $60 $103 Range names used: Capacities Part() t$J$14:51515 Cost Matrix Part()'$C6:5G510 Costs = Party'$C$14:$C$31 Demands "Part() ISJS17 SS18 Dests =Part (a) $B$14:$B$31 Flows = Part @)'$D$14-SD$31 Inflows "Part (@YISH$17:SH$18 NetOutllow Part (@SH$16 Origins = Part()'ISAS145A531 Outflows "Part (SH$14:5HS15 To Cost Part (ay 1$B$33 Cost Flow Flow balance constraints Location Index Net flow out/in Reqt LA . Detroit Atlanta Houston Tampa 2 3 4 5 Network formulation Origin Destination 1 2 1 3 1 4 1 5 2 1 2 3 2 4 2 5 3 1 3 3 4 3 5 4 1 4 2 4 3 4 5 5 1 5 2 3 4 Total cost