View the step-by-step solution to:

# Please Solve these two problems using Excel Solver with detailed instructions for solving.

Please Solve these two problems using Excel Solver with detailed instructions for solving.
1.  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: PLEASE SEE ATTACHMENT FOR FULL PROBLEM AND DIAGRAM OF NETWORK
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.
2.  The members of the Vistas Club are planning a month long hike trip through the Blue Ridge Mountains from Virginia to North Georgia.  There are a number of trails through the mountains that connect at various campgrounds, camping and cabins.  The following network shows the different connecting trails and the distance of each connecting branch in miles:  PLEASE SEE ATTACHMENT FOR FULL PROBLEM AND DIAGRAM OF NETWORK
Determine the shortest path from node 1 in North Georgia to Node 11 in Virginia and indicate the total mileage of the trail.

Please Solve these two problems using Excel Solver with detailed
instructions for solving - I really want to understand how to do these
problems...
1. 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.
2. The members of the Vistas Club are planning a month long hike trip
through the Blue Ridge Mountains from Virginia to North Georgia. There
are a number of trails through the mountains that connect at various
campgrounds, camping and cabins. The following network shows the
different connecting trails and the distance of each connecting branch
in miles:
Determine the shortest path from node 1 in North Georgia to Node 11 in
Virginia and indicate the total mileage of the trail.
3
6
5
4
1
2
Winchester
Washington DC
Charlottesville
Staunton
Richmond
Roanoke
2
2
3
2
2
3
4
1
2
94
78
71
55
58
73
144
75
89
54
81
47
85
43
84
6
10
9
3
98
13
7
8
11
5
4
2
1
12
106
81
73
105
96
62

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents