Question: 6. (40 points) For the network below, 2 5 ) B a 4 4 5 3 a) (20 points) Formulate an LP problem to find

6. (40 points) For the network below, 2 5 ) B a 4 4 5 3 a) (20 points) Formulate an LP problem to find the shortest path from A to F. The number on an arc is its distance. b) (15 points) Use Excel Solver to find an optimal solution. Submit the Excel file with Solver setup and optimal solution saved. Draw the resulting shortest path on paper. c) (5 points) Now the question has been changed to find the shortest path from A to F with at most 2 arcs. I. How would you change the formulation in a)? II. Would the optimal solution change with the additional constraint? Why or why not
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
