Question: Problem #3 (20 points) Read the attached conference proceedings article by Bastian et al (2015) titled, Optimizing Forward Surgical Team Operating Room Scheduling for Mass

Problem #3 (20 points) Read the attached conference proceedings article by Bastian et al (2015) titled, "Optimizing Forward Surgical Team Operating Room Scheduling for Mass Casualty Events." In this problem, you will mimic the computational experiment using integer linear programming (ILP) In solve the FST OR scheduling problem for MASCAL events for the three problem instances: 3 patients, 10 patients, and 15 patients. 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 Evolutionary Solver. Instead, you need to use sub-schedule elimination constraints. For each problem instance. report the optimal surgical schedule with minimal makespan (ie. total surgical actup time). Solve the three problem instances using Gurobi Python and compare contrast with the ASPE results. Here are the problem instance data: 1 2 4 1 20 15 8 15 0 18 9 28 24 21 13 13 4 15 27 14 5 8 17 24 15 0 1 H 9 1 12 26 24 12 13 17 15 24 ZH IN 14 301 15 22 25 15 28 15 18 10 27 12 19 11 T 17 30 23 17 10 13 28 20 20 24 30 0 18 27 H 23 20 22 14 14 12 7 13 19 19 29 27 18 23 0 30 10 16 10 1 11 28 26 6 I1 12 0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
