Please show on microsoft excel using solver.

4. Members of AAA often have different objectives in planning driving trips. Some are interested in identifying routes that minimize travel times. AAA wants to develop an automated system for identifying an optimal travel plan for its members. Consider the simplified network shown below for a travel member who wants to drive from Birmingham, Alabama to Virginia Beach, Virginia. The nodes in this graph represent different cities and the arcs indicate the possible travel routes between the cities. For each arc the picture below lists both the estimated driving time to travel the road represented by each arc and the number of points that route has received on the AAA's system for rating the scenic quality of the various routes. Find the shortest route in travel times and what cities AAA recommends to reduce the amount of time to travel. +0 +1 Courg 33 trs Spts Valch 11 n pts 47 20hs * 9 27 KVM 40 Tv 4 2.us Good B Raleigh 10 0, 1.7 AV SOS 40 pts 151 ps Chat 20 23 3 pts 40 3 70 17 30 4 0 1.5 2 Gie 4 A 25 pl 361 40 10 a. Create a spreadsheet model for the problem and solve it. (6 points) b. What is the shortest time? (6 points) 4. Members of AAA often have different objectives in planning driving trips. Some are interested in identifying routes that minimize travel times. AAA wants to develop an automated system for identifying an optimal travel plan for its members. Consider the simplified network shown below for a travel member who wants to drive from Birmingham, Alabama to Virginia Beach, Virginia. The nodes in this graph represent different cities and the arcs indicate the possible travel routes between the cities. For each arc the picture below lists both the estimated driving time to travel the road represented by each arc and the number of points that route has received on the AAA's system for rating the scenic quality of the various routes. Find the shortest route in travel times and what cities AAA recommends to reduce the amount of time to travel. +0 +1 Courg 33 trs Spts Valch 11 n pts 47 20hs * 9 27 KVM 40 Tv 4 2.us Good B Raleigh 10 0, 1.7 AV SOS 40 pts 151 ps Chat 20 23 3 pts 40 3 70 17 30 4 0 1.5 2 Gie 4 A 25 pl 361 40 10 a. Create a spreadsheet model for the problem and solve it. (6 points) b. What is the shortest time? (6 points)