Use this information to answer the following questions.
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.What cities should he travel through to minimize his distance?

Refer to the following Excel spreadsheet model.

-Refer to the network above and its associated spreadsheet.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:

Question

Use this information to answer the following questions.
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.What cities should he travel through to minimize his distance?
  
Refer to the following Excel spreadsheet model.
 
-Refer to the network above and its associated spreadsheet.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:

Quizplus · Accepted Answer

The Answer of Use this information to answer the following questions.
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.What cities should he travel through to minimize his distance?
  
Refer to the following Excel spreadsheet model.
 
-Refer to the network above and its associated spreadsheet.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:

Use This Information to Answer the Following Questions