Create a template in Excel, including all of the appropriate Solver settings, that would accommodate a standard
Question:
Create a template in Excel, including all of the appropriate Solver settings, that would accommodate a standard shortest path problem with 8 nodes, where the objective is to find the shortest path through the network from node 1 to node 8. In Solver, specify all cells in the decision variable table in the By Changing Variable Cells box. Insert a large distance into all cells in the distance table. (The user can then insert the actual, i.e., smaller, distances into each cell that represents an actual route.)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Managerial Decision Modeling Business Analytics With Spreadsheet
ISBN: 9781501515101
4th Edition
Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson
Question Posted: