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

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: Schedule 1 2 3 4 Days worked Monday-Thursday Tuesday-Friday Wednesday-Saturday Thursday-Sunday

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.

Schedule 1 2 3 4 Days worked Monday-Thursday Tuesday-Friday Wednesday-Saturday Thursday-Sunday

Step by Step Solution

★★★★★

3.28 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To solve this scheduling problem we can use integer programming Let xijk be a binary decision variab... View full answer

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 Microsoft Excel Data Analysis 7th Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

1. Hannah is applying for a life policy on her girlfriend Sarahs life. The policy is $500,000 and carries a large premium. Hannah is the main earner, so she is concerned about not being able to pay...

Q4. Company Nebula manufactures and sells the oxygen cylinder with kit (April, 2021 Covid situation in India) to different hospitals in the city. Company operates only two departments: Manufacturing...

1) (A)Model the Nurses shift scheduling problem in Excel and see if you can determine the required number of nurses required for each start day, and the total nurses required. (B) then rerun the...

use an lp model in excel to solve. please show work for a great review! please use lp model to solve in excel and show work! thank you kindly Du Maureen Becker, the head administrator at Jefferson...

Eagle Tavern Cost/Gallon Selling price profit Capacity Demand for Yodel Demand for Shotz Demand for Rainwater Yodel 1.5 3 Shotz 0.9 2.5 Rainwater 0.5 1.75 1 1 0 0 1 0 1 0 1 0 0 1 # of Gallons Yodel...

MAT540 Homework Week 8 Page 1 of 4 MAT540 Week 8 Homework Chapter 4 1. Betty Malloy, owner of the Eagle Tavern in Pittsburgh, is preparing for Super Bowl Sunday, and she must determine how much beer...

Eagle Tavern Cost/Gallon Selling price profit Capacity Demand for Yodel Demand for Shotz Demand for Rainwater Decision Variables Objective Function Yodel 1.5 3 1.5 1 1 0 0 Shotz 0.9 2.5 1.6 1 0 1 0...

Write a report on internal controls, and present a brief report describing the auditor's justifications/reasons for giving the adverse opinion. Procedure reviews the assigned readings and module...

Craft the best self-introduction possible and make sure it should include the following points: Name (using an adjective which defines you) Place (you hail from, you belong to or you come from)...

Calculate the cross rate between the Mexican peso ( Ps ) and the euro ( ) from the following two spot rates: Ps 1 2 . 4 5 / $ and 0 . 7 5 5 0 / $ .

10.17. Consider the design discussed in Example 10.5. (a) Suppose you elect to augment the design with the single run selected in that example. Find the variances and covariances of the regression...

During the next four months, a customer requires, respectively, 500, 650, 1000, and 700 units of a commodity, and no backlogging is allowed (that is, the customers requirements must be met on time)....

A company faces the following demands during the next three weeks: week 1, 2000 units; week 2, 1000 units; week 3, 1500 units. The unit production costs during each week are as follows: week 1, $130;...

Maggie Stewart loves desserts, but due to weight and cholesterol concerns, she has decided that she must plan her desserts carefully. There are two possible desserts she is considering: snack bars...

A report published by the American Hospital Association (AH7) stated that "more than 60 percent of employers are experiencing tension between employees from different generations." A. Explain three...

Stock Issuance Utep Enterprises had the following transactions during 2017, its first year of business. Required: 1. Identify and analyze the effect of each transaction. a. Issued 5,500 shares of $5...

III. a. Prepare journal entries for the following independent situations: 1. The allowance for doubtful accounts has a $ 625 debit balance prior to adjustment. An aging schedule prepared on December...