Problem 5.54(a) - General Ford (p. 269) Range hamtes used: Capacities 'Part (a)'!SJ$14:5J$15 Unit shipping costs LostMatrix ='Part (@jiML36:3G$10 To Costs 'Part (a)'15C$14:50$31 LA Detroit Atlanta Houston Tampa Demands ='Part (a)!$J$17:5J$18 From LA $97 $95 $125 $156 Dests 'Part (a)!$8$14:$8$31 Detroit 594 $103 $110 $148 Flows 'Part (a)!SD$14:SD$31 Atlanta $87 $100 $95 $56 Inflows ='Part (a)!SH$17:SH$18 Houston $129 $103 $88 $100 NetOutflow ='Part (a)!SH$ 16 Tampa $147 $145 $60 $103 Origins 'Part (@)!SA$14:5A$31 Outflows ='Part (@)!SH$14:SH$15 Network formulation Flow balance constraints TotCost ='Part (a)!SB$33 Origin Destination Cost Flow Location Index Net flow Reqt out in LA Detroit Atlanta Houston = Tampa Total cost