Using excel, please solve the following



Download 25.5 Kb.
Date29.07.2022
Size25.5 Kb.
#59248
C7P2

Using excel, please solve the following:
Frieda Millstone and her family live in Roanoke, VA and they are planning an auto vacation across Virginia, their ultimate destination being Washington DC. The family has developed the following network of possible routes and cities to visit on their trip. The time in hours between cities (which is affected by the type of road and number of intermediate towns) is shown along each branch. Determine the shortest route that the Millstone family can travel from Roanoke to Washington DC.

- Winchester-------2------- Washington DC (6)


2 - (5) - -
- - 2 -
- 1 - -
Staunton (2) -------------- Charlottesville (3) -
- - - - 3
- - - -
2 - - 4 2 - -
- - - -
- - - -
Roanoke (1) ---------------------------------------------------Richmond (4) 3


This is as close to looking like the network. Any help would be appreciated!
Download 25.5 Kb.

Share with your friends:




The database is protected by copyright ©ininet.org 2024
send message

    Main page