Solved: Hospital staffing is a primary concern for the business office at the hospital. Due to state

Question 3: Hospital staffing is a primary concern for the business office at the hospital. Due to state regulations, there are maximum patient/nurse ratios required by law (due to high patient mortality and morbidity rates if the nurses are spread too thin.) Suppose we are trying to staff an emergency department with the following demands per day Time of Day 8:00 am to 12:00 pm 12:00 pm to 4:00 4:00 pm to 8:00 pm 8:00 pm to 12:00 am 12:00 am to 4:00 am 4:00 am to 8:00 am Minimum Nurses Required 5 6 10 7 8 Thanks to the nursing union, nurses are to be scheduled in only 12 hour shifts (i.e. overlapping 3 of these blocks). Start times must be on one of the start times listed on the table (trust me, these two things actually simplify this problem dramatically from what it is in the real world), In order to minimize costs kindly set up and solve the minimization linear programming problem associated with minimizing the staff necessary to meet these minimum conditions. How many nurses are needed, and how many will be staffed at each of the times listed (i.e. how much staffing will be wasted?) Hint: Shift 1 + Shift 2 + Shift 3 >= 10, shift 6 + Shift 1 + Shift 2 >= 6, etc

Hospital staffing is a primary concern for the business office at the hospital. Due to state regulations, there are maximum patient/nurse ratios required by law (due to high patient mortality and morbidity rates if the nurses are spread too thin.) Suppose we are trying to staff an emergency department with the following demands per day. Thanks to the nursing union, nurses are to be scheduled in only 12 hour shifts (i.e. overlapping 3 of these blocks). Start times must be on one of the start times listed on the table (trust me, these two things actually simplify this problem dramatically from what it is in the real world). In order to minimize costs kindly set up and solve the minimization linear programming problem associated with minimizing the staff necessary to meet these minimum conditions. How many nurses are needed, and how many will be staffed at each of the times listed (i.e. how much staffing will be wasted?)

Expert Answer

IP model and solution of the problem using Excel Solver is as follows

Solved: Hospital staffing is a primary concern for the business office at the hospital. Due to state 1

Formulae: I2 =SUMPRODUCT(C2:H2,$C$10:$H$10)   copy to I2:I8

Total number of nurses needed = 14

Time of Day Nurses required Nurses Staffed Staffing Wasted
8 am to 12 pm 5 6 1
12 pm to 4 pm 6 6 0
4 pm to 8 pm 10 10 0
8 pm to 12 am 7 8 1
12 am to 4 am 8 8 0
4 am to 8 am 4 4 0
Still stressed from student homework?
Get quality assistance from academic writers!