New Exercise Bank Content Qu$.09-16$

You need to take a trip by car to another town that you have never visited before. Therefore, you are studying a map to determine the shortest route to your destination. Depending on which route you choose, there are five other towns $($call them $A,B,C,D,E$ through which you might pass on the way. The map shows the mileage along each road that directly connects two towns without any intervening towns. These numbers are summarized in the following table, where a dash indicates that there is no road directly connecting these two towns without going through any other towns.

$\backslash$table$[[,$Miles between Adjacent Towns$],[$Town$,$A$,$B$,$C$,$D$,$E$,$Destination$],[$Origin$,40,60,50,-,-,$Destination$],[$A$,,10,-,70,-,-],[$B$,,,20,55,40,-],[$C$,,,,-,50,-],[$D$,,,,,10,60],[$E$,,,,,,80]]$

Click here for the Excel Data File

Formulate and solve a spreadsheet model for this problem.

a$.$ Determine the distance for the shortest route to your destination.

Distance

miles

b$.$ Determine the shortest route to your destination.

Route