pls use excel slover and show the complete solution

pls do not copy other answers

thank you!

1. 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. A 40 B 60 10 Town Origin A B D E Miles between Adjacent Towns D E Destination 50 70 20 55 50 10 60 80 40 1.1. Formulate a network model for this problem as a shortest path problem by drawing a network where nodes represent towns, links represent roads, and numbers indicate the length of each link in miles. 1.2. Formulate and solve a spreadsheet model for this problem. 1.3. Use part 1.2. to identify your shortest route. 1.4. If each number in the table represented your cost (in dollars) for driving your car from one town to the next, would the answer in part c now give your minimum-cost route? 1.5. If each number in the table represented your time in minutes) for driving your car from one town to the next, would the answer in part c now give your minimum-time route