Question: Can someone please help me with this problem. What are the three equations? Bob Jenkins needs to drive from City 1 to City 7 and

Can someone please help me with this problem. What are the three equations?

Can someone please help me with this problem.Can someone please help me with this problem.

Bob Jenkins needs to drive from City 1 to City 7 and would like to find the shortest route between the two. The road system with the distance in miles between cities is shown in the network below. 29 25 15 12 18 20 19 16 22 37 B D E F G H A 1 Bob Jenkins 2. Node 1 Node 4 Node 5 Node 6 Node 7 Node 2 0.0 Node 3 1.0 0.0 o 0.0 0.0 0.0 0.0 1.0 oo 0.0 0.0 0.0 0.0 3 From: To: 4 Node 1 5 Node 2 6 Node 3 7 Node 4 8 Node 5 9 Node 6 10 Node 7 11 Total flow in 12 doa OOO Total flow out 1.0 0.0 1.0 1.0 1.0 0.0 0.0 0.0 1.0 0.0 1.0 0.0 0.0 10 Olo 0.0 1.0 0.0 0.0 0.0 0.0 1.0 1.0 1.0 Node 4 Node 5 Node 6 Node 7 Node 3 19 20 29 15 16 37 16 12 12 18 22 37 18 22 13 Flow capacity: 14 From: To: Node 1 Node 2 15 Node 1 25 16 Node 2 25 17 Node 3 19 20 18 Node 4 15 19 Node 5 29 20 Node 6 21 Node 7 22 Shortest 23 Distance = 65.0 24 25 Flow balance equations: 26 Node Net flow Sign 27 Node 1 -1 28 Node 2 0 = 29 Node 3 0 30 Node 4 0 = 31 Node 5 0 32 Node 6 0 33 Node 7 34 = = RHS -1 0 0 0 0 0 1 = = = What values would you enter in the Solver Parameter dialog box for the Excel spreadsheet model Set Target Cell, By Changing Cells, Subject to the Constraints)? What equation should be entered in cell B23? What equation should be entered in cell B27? What equation should be entered in cell 14

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!