please show the formula you inserted into each cell thank you in advance

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 16(H) cars and Detroit can produce lip 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 3 Problem 5.54(a) - General Ford (p. 269) - Unit shipping costs From LA Detroit Atlanta Houston Tampa To LA Detroit Atlanta Houston Tampa $97 $95 S125 $156 $94 S103 S110 $148 587 $100 $95 556 S129 S103 S88 $100 S147 $145 560 S103 Range names used: Capacities 'Part (@'ISJS14 $J$15 Cost Matrix Part(a)!SC$6:SGSTO Costs --'Part (ay'!SC$14:50$31 Demands Part(a)!SJS17 SUSTS Dests Part (ay!SBS14 SB$31 Flows "Part(@"ISD$14:SDS31 Inflows = 'Part (@) ISHS17:SHST8 NetOutllow Parta)'ISHSI Ongins 'Part (a)'ISAS14:SAS31 Outflows Part (a)' ISHS14:SHS15 TotCost Part (W/ISB$33 Cost Flow Reqt CH Flow balance constraints Location Index Net flow out/in LA Detroit 2 Atlanta 3 Houston 4 Tampa $ Network formulation Origin Destination 1 2 3 4 1 5 2 1 2 3 2 4 5 1 3 2 3 4 3 5 4 1 2 3 5 1 1 Total cost