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 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
Get step-by-step solutions from verified subject matter experts
