Question #$5$

In Excel, verify your answer to Question $1($from the first part of this problem set$).$

The members of the Vistas Club are planning a month$-$long hiking and camping trip through the Blue Ridge Mountains, from north Georgia to Virginia. There are a number

of trails through the mountains that connect at various campgrounds, crossings, 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 $13$ in Virginia, and indicate the total mileage of the trail.

a$.$ Set up the constraints in the highlighted cells of Column I $($Network Flow$).$ Node $1$ is the origin and node $13$ is the destination.

b$.$ Use Solver to find the shortest route.

c$.$ Use the solution to verify your answer to Question $1.$

give me the complete formulas and what to do in each blank in order to complete this excel sheet