Suppose in the original Grand Prix example that the routes from plant 2 to region 1 and from plant 3 to region 3 are not allowed. How would you modify the original model (Figure 14.12) to rule out these routes? How would you modify the alternative model (Figure 14.17) to do so? Discuss the pros and cons of these two approaches.

Transcribed Image Text:

Figure 14.12 Transportation Model A B D F G H K 1 Grand Prix transportation model Range names used: Capacity Demand Shipping Plan Total_cost =ModellSI$13:SIS15 =Model$C$18:$F$ 18 =Modell$C$13:$F$15 =Modell$B$21 =Modell$C$16:SF$16 =Modell$G$ 13:$G$15 3 Unit shipping costs 4 To Region 1 Region 2 Region 3 Region 4 $266 $263 5 6 From Plant 1 Plant 2 Plant 3 $131 $218 $120 Total_received Total shipped $278 $250 $178 $116 $132 8 $122 $180 10 Shipping plan, and constraints on supply and demand 11 To Region 1 Region 2 Region 3 Region 4 Total shipped 450 300 12 Сарacity| 13 From Plant 1 Plant 2 Plant 3 Total received 150 300 450 14 100 200 600 15 200 300 500 500 16 450 200 300 300 17 >= >= >= 18 Demand 450 200 300 300 19 20 Jobjective to minimize 21 Total cost $176,050