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. Need the formulas also. I am having trouble with this.

Problem 3 Problem 5.54(a) - General Ford (p. 269) Ushipping costs LA Detroit Atlanta 597 $95 $94 S10 $87 S100 SIN SIGB SS Houston S12 S110 $95 Tampa S156 S148 556 S100 Ranges used: Capacities -Parts S15 Cost Max-Parts S10 -Part 1 41631 -Part I I Dests - Part ( SRS14 SRS Parta SD514581 fos Part (SISIT-SHISIS NetOutlow Parta SHS16 Oncis Part (SASSAU Part ( SHISTESHESS To Lost Part (SB33 Sios Network formula Origin Destination CostFlow Flow balance cost Index No flow Lac Reqt Houston MGMT 5260 Decision-Making Techniques for Managers Page 3 of 3 Problem 3 Problem 5.54(a) - General Ford (p. 269) Ushipping costs LA Detroit Atlanta 597 $95 $94 S10 $87 S100 SIN SIGB SS Houston S12 S110 $95 Tampa S156 S148 556 S100 Ranges used: Capacities -Parts S15 Cost Max-Parts S10 -Part 1 41631 -Part I I Dests - Part ( SRS14 SRS Parta SD514581 fos Part (SISIT-SHISIS NetOutlow Parta SHS16 Oncis Part (SASSAU Part ( SHISTESHESS To Lost Part (SB33 Sios Network formula Origin Destination CostFlow Flow balance cost Index No flow Lac Reqt Houston MGMT 5260 Decision-Making Techniques for Managers Page 3 of 3