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

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

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!