Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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) to solve the FST OR scheduling problem for MASCAL events for the three problem instances: 5 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 (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 2 3 0 20 15 8 15 0 18 9 28 24 23 15 27 8 0 8 24 15 0 2 3 5 7 8 9 10 0 9 12 26 24 13 15 2 24 28 23 5 18 23 3 19 30 30 15 22 15 28 15 18 27 0 28 12 16 19 22 5 5 25 30 23 15 26 28 10 7 23 20 20 24 30 0 16 8 23 20 8 18 10 14 12 13 9 19 29 27 18 23 0 30 10 16 10 28 26 6 11 sij 2 3 5 6 8 10 11 12 14 0 15 27 19 22 26 5 18 30 25 2 24 0 23 21 15 25 8 8 16 22 8 16 3 22 0 28 14 22 30 7 22 26 8 25 22 14 6 13 0 23 5 15 30 30 26 21 26 5 27 18 17 0 18 26 12 22 16 17 14 24 6 8 8 14 6 25 14 13 14 24 24 5 25 16 24 8 24 12 26 29 28 8 16 23 10 6 9 15 0 12 9 21 23 9 5 23 26 18 21 29 0 8 6 23 10 18 18 8 13 28 20 5 27 25 11 10 18 28 26 24 15 21 25 25 0 30 16 15 20 12 15 17 6 28 30 23 14 22 27 19 28 13 10 19 27 25 17 28 18 25 8 25 13 17 0 28 14 12 10 25 26 22 20 18 16 25 19 24 19 0 16 15 28 13 23 19 16

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra A Modern Introduction

Authors: David Poole

4th edition

1285463242, 978-1285982830, 1285982835, 978-1285463247

More Books

Students also viewed these Mathematics questions