Question: Using Microsoft Excel with ASPE, setup the spreadsheet model and solve the ILP for the three problem instances. You should use the Premium Solver that

 Using Microsoft Excel with ASPE, setup the spreadsheet model and solve

Using Microsoft Excel with ASPE, setup the spreadsheet model and solve the ILP for the three problem instances. You should use the Premium Solver that comes with ASPE, and do not use the Evoluti utionary Solver. Instead, you need to use sub-schedule elimination on constraints. For each problem instance, report the optimal surgical schedule with minimal makespan (i.e., total surgical setup time). Solve the three problem instances using Gurobi Python and compare/contrast with the ASPE results. Here are the problem instance data: sij 1 2 3 4 5 0 20 15 8 2 28 3 13 13 4 15 27 8 14 8 17 24 15 0 sij 1 2 3 4 5 6 7 8 9 10 1 0 9 12 26 11 24 12 13 17 15 2 24 0 28 23 22 5 7 18 9 23 3 19 30 0 30 15 22 25 15 28 15 4 18 10 27 0 28 12 16 19 22 5 15 28 10 13 28 23 26 20 20 24 30 0 16 18 27 8 23 20 22 8 18 10 14 0 14 9 13 9 19 29 27 18 23 0 30 10 16 10 11 11 28 26 6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!