1. Solve the problem using an Excel Solver.

2. In Sheet 1 place your mathematical model, in Sheet 2 your Spreadsheet model/Recommendation (a), in Sheet 3 your Spreadsheet model/Recommendation (b).

Exercise #5: Shortest Route Problem Southern College is in the process of completing a computer bus network that will connect computer facilities throughout the university. The prime objective is to string a main cable from one end of the campus to the other (nodes 125) through underground conduits. These conduits are shown in the network (see figure below); the distance between them is in hundreds of feet. Fortunately, these underground conduits have remaining capacity throughwhich the bus cable can be placed. (a) Given the network for this problem, how far (in hundreds of feet) is the shortest route from node 1 to node 25? (b) In addition to the computer bus network, a new phone system is also being planned. The phone system would use the same underground conduits. If the phone system were installed, the following paths along the conduit would be at capacity and would not be available for the computer bus network: 6-11, 712, and 1720. What changes (if any) would you have to make to the path used for the computer bus if the phone system were installed? What will be the new minimum distance? 8 15 10 5 5 18 6 8 22 5 6 19 15 6 7 23 8 25 12 5 6 20 16 10 20 8 8 20 13 75 24 17 17 10 10 21