Cook County General Hospital is attempting to schedule work for its 20 nurses. Each nurse will work

Question:

Cook County General Hospital is attempting to schedule work for its 20 nurses. Each nurse will work four consecutive days and is assigned to one of the following schedules:image


image


Each nurse will be assigned for the week to either the ICU or a patient ward. Each nurse’s satisfaction with their assignment is given in the file named Nursejackiedata.xlsx. For example, if Nurse 5 is assigned to the ICU, Nurse 5 gives a perfect 10 rating to work schedule 3.


Each day, the ICU needs six nurses, and the patient wards need five nurses. Schedule the nurses to maximize their satisfaction and meet hospital needs. You will need to know which schedules satisfy the nurse demand for different days. For example, nurses starting on Monday, Friday, Saturday, and Sunday will work on Monday.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: