The network in the figure, shows the routes for shipping cars from three (3) plants (nodes,...

Transcribed Image Text:

The network in the figure, shows the routes for shipping cars from three (3) plants (nodes, 1, 2 and 3) to three (3) dealers (nodes, 6, 7, 8) by way of two (2) distribution centers (nodes 4 and 5). The shipping costs per car (in $100) are shown on the arcs. Solve the problem using Excel Solver. 900 1 1200 .2 .3 4.5 .8 6 1400 2 .5 7 1100 3. 4.3 5 2.1 2 4.6 1000 3 1.9 8 1000 The network in the figure, shows the routes for shipping cars from three (3) plants (nodes, 1, 2 and 3) to three (3) dealers (nodes, 6, 7, 8) by way of two (2) distribution centers (nodes 4 and 5). The shipping costs per car (in $100) are shown on the arcs. Solve the problem using Excel Solver. 900 1 1200 .2 .3 4.5 .8 6 1400 2 .5 7 1100 3. 4.3 5 2.1 2 4.6 1000 3 1.9 8 1000