Rig 0 (0,0) Rig 1 (14,27) Rig 2 (22,14) Rig 3 (1,13) Rig 4 (20,4) Rig 5 (20,1
Posted: Thu May 19, 2022 10:37 am
Rig 0 (0,0)
Rig 1 (14,27)
Rig 2 (22,14)
Rig 3 (1,13)
Rig 4 (20,4)
Rig 5 (20,16)
Rig 6 (12,18)
Rig 7 (30,31)
1) Consider a TSP problem based on an operation at an oil rig where a ship must visit 8 locations. The coordinates for rig 0 to rig 7 are given below. Rigo (0,0) Rig 1 (14,27) Rig 2 (22,14) Rig 3 (1.13) (20,4) Rig 5 (2016) Rig 6 (12,18) Rig 7 (30,31) Rig 4 1) Develop an excel solver worksheet to determine the optimal tour. Show the subtour elimination constraint that needs to be added in each iteration 2) In the same excel file, create a tab that display the optimal route by using a chart similar to what we did in inclassAssignment.
Rig 1 (14,27)
Rig 2 (22,14)
Rig 3 (1,13)
Rig 4 (20,4)
Rig 5 (20,16)
Rig 6 (12,18)
Rig 7 (30,31)
1) Consider a TSP problem based on an operation at an oil rig where a ship must visit 8 locations. The coordinates for rig 0 to rig 7 are given below. Rigo (0,0) Rig 1 (14,27) Rig 2 (22,14) Rig 3 (1.13) (20,4) Rig 5 (2016) Rig 6 (12,18) Rig 7 (30,31) Rig 4 1) Develop an excel solver worksheet to determine the optimal tour. Show the subtour elimination constraint that needs to be added in each iteration 2) In the same excel file, create a tab that display the optimal route by using a chart similar to what we did in inclassAssignment.