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 on your destination. Depending on which route you...

Show your solution when necessary and provide a brief description on how you arrive with the answer. Capture your answer well.


Extracted text: 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 on 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 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. Miles between Adjacent Towns Town A B C D E Destination Origin 40 60 50 A. 10 70 20 55 40 50 10 60 E Formulate and solve a spreadsheet model for this problem and determine the following: a) Shortest route (answer format: Origin-A-B-Destination) = b) Total distance = miles