Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A hospital with ten operating rooms (OR) must schedule surgeries every day. Each operating room, when it is used, is budgeted for eight hours. There

A hospital with ten operating rooms (OR) must schedule surgeries every day. Each operating room, when it is used, is budgeted for eight hours. There is a fixed cost of $4,800 to staff an open room, and once the OR is opened, this cost is incurred whether or not it is used. Assume that the duration of the procedures is known with certainty as given in the table below. The first column of the table below represents the surgeon identifier and the second column is the duration of the procedure in hours. A surgeon may have multiple procedures.

Procedures Duration

s0390 2.17

s1532 2.58

s1802 2.75

s2734 6

s2734 5.5

s2770 1.83

s5173 3.33

s6820 1

s6930 4.67

s7099 3.25

s7270 2.75

s8487 4.67

s8512 4.25

s8526 2.5

s8534 0.58

s8534 0.42

s9564 1.67

s9564 1.17

Develop a Linear Integer Programming model to help the hospital efficiently (minimum cost) schedule the procedures. Assume that a surgeon can operate in two rooms at the same time.

Assume that all the surgeons with multiple procedures cannot be in two rooms at the same time, i.e., the procedures must be performed consecutively, even if the operating room is used more than the budgeted eight hours. Find the schedule that minimizes costs and satisfies the surgeons’ needs.

Assume that you can extend the use of operating rooms more than the 8 regular budgeted hours at a cost of $1600 per hour per OR. Find an optimal schedule that minimizes costs. (Hint: You do not need to consider the use of a linear model here. i.e., you can develop a nonlinear integer programming model).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

1 Prepare an excel spread sheet as shown below Formulated Spreadsheet is shown below Put the follo... 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

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
6090834d3e63f_21754.pdf

180 KBs PDF File

Word file Icon
6090834d3e63f_21754.docx

120 KBs Word File

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

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

136115837, 978-0136115830

More Books

Students also viewed these Accounting questions

Question

Appreciate the complexity of medical billing.

Answered: 1 week ago