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 NETWORKThe 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 NETWORKDetermine 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 detailedinstructions for solving – I really want to understand how to do theseproblems…1. Frieda Millstone and her family live in Roanoke, VA and they areplanning an auto vacation across Virginia, their ultimate destinationbeing Washington DC. The family has developed the following network ofpossible routes and cities to visit on their trip:The time in hours between cities (which is affected by the type of roadand number of intermediate towns) is shown along each branch. Determinethe shortest route that the Millstone family can travel from Roanoke toWashington DC.2. The members of the Vistas Club are planning a month long hike tripthrough the Blue Ridge Mountains from Virginia to North Georgia. Thereare a number of trails through the mountains that connect at variouscampgrounds, camping and cabins. The following network shows thedifferent connecting trails and the distance of each connecting branchin miles:Determine the shortest path from node 1 in North Georgia to Node 11 inVirginia and indicate the total mileage of the trail.365412WinchesterWashington DCCharlottesvilleStauntonRichmondRoanoke2232234129478715558731447589548147854384610939813781154211210681731059662
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
