(Solved) : Get Answer Excel Plugin Don T Want Photo Q36970387 . . .
Can I get the answer as an excel plugin? I don’t want it as aphoto.
1) 40 pointsl SHORTEST PATH PROBLEM: An express delivery service want to travel the shortest distance to get from node 1 (origin to node 10 (destination), using the arcs (roads) shown on the figure below. The numbers on the arcs are kilometers. Note that the some arcs only have one-way directions and some has both-way directions. In order to find the shortest path from node 1 to 10: 72 17 31 25 63 87 19 10 29 61 56 67 45 69 85 a) Use the shortest path (route) algorithm (Dijkstra’s algorithm) to solve it manually. Prepare a table in EXCEL and show each step of the algorithm in this table (see the example posted in Blackboard in “Week06-Shortest Path Problem.xlsx” in Blackboard) b) Solve the same problem as a minimum cost network flow problem (MCNFP) using EXCEL (as in the example posted in Blackboard, “Week06-Shortest Path Problem.xlsx”. Note that you should get the same answer as in part (a) Submit your EXCEL file (xls OR xlsx only) through the “IE341-Assignment3 Spring2019- EXCEL File Submission” signments” in Blackboard. Failure of submission will ult in amark for this question. You can use the “Week06-Shortest Path Problem.xlsx” file (under “Course Materials/Week05-06 EXCEL Files” in Blackboard) as a template for your answer (note that for part(a) and part(b), you should have separate sheets in the same file). No need to submit your answers as a printout las I will only mark your EXCEL file onl Show transcribed image text
Expert Answer
Answer to Get Answer Excel Plugin Don T Want Photo Q36970387 . . .
OR