Using an excel and the solver tool to complete. Find the shortest route from node 1 to node 7 in the network shown.for question 23

to teach the Ph.D. level course. If the department head makes teaching assigninents based on maximizing the student evaluation ratings over all four courses, what staffing assignments should be made? LO 2 23. Finding the Shortest Route. Find the shortest route from node 1 to node 7 in the network shown. LO 4 24. Gorman Construction (revisited). In the original Gorman Construction Company example (Section 6.3), we found the shortest distance from the office (node 1) to the construction site located at node 6 . Because some of the roads are highways and others are city streets, the shortest-distance routes between the office and the construction site may not necessarily provide the quickest or shortest-time route. Shown here is the Gorman road network with travel time rather than distance. Find the shortest route from Gorman's office to the construction site at node 6 if the objective is to minimize travel time rather than distance. LO 4