2. Transportation & Transshipment Problem General Ford produces cars at L.A. and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The cost of shipping a car between points is given in Table 2 ("" means that a shipment is not allowed). L.A. 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 Table 2 To From L.A. Detroit Atlanta Houston Tampa Supply L.A. $0 $140 $100 $90 $225 1100 Detroit $145 $0 $111 &110 $119 2900 Atlanta $105 $115 $0 $113 $78 Houston $89 $109 $121 $0 Tampa Demand $210 $117 $82 $0 2400 1500 1) Formulate a balanced transshipment problem to minimize the shipping costs incurred in meeting demands at Houston and Tampa, use Excel to find the optimal solution. 2) If shipments between L.A. and Detroit are not allowed, modify the model and use Excel to find the optimal solution. 3) If shipments between Houston and Tampa are allowed at a cost of $5, modify the model and use Excel to find the optimal solution.