case study, you need to submit only the model (Variable Definition, Expression for objective, Mathematical Expressions...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
case study, you need to submit only the model (Variable Definition, Expression for objective, Mathematical Expressions for Constraints, etc.) - do not try to solve it using SOLVER yet! In many situations like Call Centers, Banks, and Hospitals, the manpower planning is a non-trivial task as the staffing needs varies over time (hour to hour or shift to shift). In such cases, one would like to achieve a cost efficient staffing without sacrificing the customer service. Consider for example, hospitals where scheduling of nursing staff is a very critical task. It is crucial that each shift is fully staffed (based on projected needs), and no person is given an unreasonable schedule. A local hospital in consultation with their nursing staff has decided to follow four basic policies in scheduling -- (1) Each person should have at least every other weekend off, (2) On an average, a person should work 5 days a week, (3) a nurse should not work more than 5 days without an off day, and (4) there will not be any shift change. The policy (4) is restrictive, but makes the scheduling task much simpler, as each shift now can be scheduled independent of the other. Also, based on the historical data, this hospital has observed that the demand for nursing staff in a particular shift varies from day to day within a week, but does not vary too much from week to week. The administration expects this observation to be true in near future. Based on this observation and policy (1), each person can be assigned a two-week rolling schedule. In accordance with policies (1) through (4), and some other considerations, the administration has enumerated 15 acceptable schedules as shown in following table. In this table, a 0 indicates an off day, and I a working day. For example, schedule 1 (S1) in row 1 implies that over next two weeks, the person will be off on the first Monday, then off for the weekend (Saturday and Sunday), and off on Wednesday of the second week. This two-week schedules then repeats for subsequent weeks. $1 S2 S3 $4 $5 S6 S7 S8 S9 $10 $11 $12 $13 S14 $15 wk1- wk1-wk1- wk1- wk1-wk1- wk1- wk2-wk2-wk2-wk2-wk2-wk2-k2- mon tue wed thur fri sat sun mon tue wed thur fri sat sun 0 0 0 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 11 1 ol 0 D 0 1 1 1 1 1 1 1 1 1 11 1 11 1 Minimum number of nurses required 1 1 D 0 0 1 1 1 1 1 1 1 1 1 1 11 1 1 1 1 0 0 1 0 0 o 0 0 0 0 0 0 1 1 of 1 1 0 C 0 of 1 1 1 1 1 1 1 1 1 1 0 0 1 1 of 1 al 1 1 1 1 1 1 1 1 0 1 0 1 1 0 1 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1 1 1 Mon Tue Wed Thur. Fri. Sat. Sun. of 1 0 1 1 1 1 1 1 1 1 1 D 1 1 1 1 0 1 1 1 1 ol 1 0 d 1 1 7 1 1 1 1 1 1 1 1 1 1 0 0 C 0 C C 0 C 1 0 1 1 1 1 1 1 0 0 0 To schedule the nursing staff for the third shift at the rehab floor of this hospital, the historical data projects the following demand for nurses for each day of the week. 0 0 20 10 | 12 | 15 | 17 | 14 | 10 | 11 The hospital currently has two grades of nurses -- registered nurses (RN) or practitioner nurses (PN). However, hospital has a rule that requires that, at all times, there should be at least 1 registered nurse for every two practitioner nurses (that is ratio of RN to PN every day should be at least 1/2). Assuming that an RN is paid 20% more than a PN, develop a mathematical model to decide how many RN and PN should be assigned to each of the 15 schedules, so that each day is properly staffed. The Hospital will like to achieve this with the least cost. (Hint: Define a variable for each type of nurse (RN and PN) to be assigned to each schedule. Hence you will have 30 variables and 28 constraints - a demand and a ration constraint (at least 1 to 2 ratio between registered nurses and practitioner nurses) for each day in a two week cycle. This model is very similar to the one developed in class for the ambulance staffing problem where table above is the "time chart") case study, you need to submit only the model (Variable Definition, Expression for objective, Mathematical Expressions for Constraints, etc.) - do not try to solve it using SOLVER yet! In many situations like Call Centers, Banks, and Hospitals, the manpower planning is a non-trivial task as the staffing needs varies over time (hour to hour or shift to shift). In such cases, one would like to achieve a cost efficient staffing without sacrificing the customer service. Consider for example, hospitals where scheduling of nursing staff is a very critical task. It is crucial that each shift is fully staffed (based on projected needs), and no person is given an unreasonable schedule. A local hospital in consultation with their nursing staff has decided to follow four basic policies in scheduling -- (1) Each person should have at least every other weekend off, (2) On an average, a person should work 5 days a week, (3) a nurse should not work more than 5 days without an off day, and (4) there will not be any shift change. The policy (4) is restrictive, but makes the scheduling task much simpler, as each shift now can be scheduled independent of the other. Also, based on the historical data, this hospital has observed that the demand for nursing staff in a particular shift varies from day to day within a week, but does not vary too much from week to week. The administration expects this observation to be true in near future. Based on this observation and policy (1), each person can be assigned a two-week rolling schedule. In accordance with policies (1) through (4), and some other considerations, the administration has enumerated 15 acceptable schedules as shown in following table. In this table, a 0 indicates an off day, and I a working day. For example, schedule 1 (S1) in row 1 implies that over next two weeks, the person will be off on the first Monday, then off for the weekend (Saturday and Sunday), and off on Wednesday of the second week. This two-week schedules then repeats for subsequent weeks. $1 S2 S3 $4 $5 S6 S7 S8 S9 $10 $11 $12 $13 S14 $15 wk1- wk1-wk1- wk1- wk1-wk1- wk1- wk2-wk2-wk2-wk2-wk2-wk2-k2- mon tue wed thur fri sat sun mon tue wed thur fri sat sun 0 0 0 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 11 1 ol 0 D 0 1 1 1 1 1 1 1 1 1 11 1 11 1 Minimum number of nurses required 1 1 D 0 0 1 1 1 1 1 1 1 1 1 1 11 1 1 1 1 0 0 1 0 0 o 0 0 0 0 0 0 1 1 of 1 1 0 C 0 of 1 1 1 1 1 1 1 1 1 1 0 0 1 1 of 1 al 1 1 1 1 1 1 1 1 0 1 0 1 1 0 1 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1 1 1 Mon Tue Wed Thur. Fri. Sat. Sun. of 1 0 1 1 1 1 1 1 1 1 1 D 1 1 1 1 0 1 1 1 1 ol 1 0 d 1 1 7 1 1 1 1 1 1 1 1 1 1 0 0 C 0 C C 0 C 1 0 1 1 1 1 1 1 0 0 0 To schedule the nursing staff for the third shift at the rehab floor of this hospital, the historical data projects the following demand for nurses for each day of the week. 0 0 20 10 | 12 | 15 | 17 | 14 | 10 | 11 The hospital currently has two grades of nurses -- registered nurses (RN) or practitioner nurses (PN). However, hospital has a rule that requires that, at all times, there should be at least 1 registered nurse for every two practitioner nurses (that is ratio of RN to PN every day should be at least 1/2). Assuming that an RN is paid 20% more than a PN, develop a mathematical model to decide how many RN and PN should be assigned to each of the 15 schedules, so that each day is properly staffed. The Hospital will like to achieve this with the least cost. (Hint: Define a variable for each type of nurse (RN and PN) to be assigned to each schedule. Hence you will have 30 variables and 28 constraints - a demand and a ration constraint (at least 1 to 2 ratio between registered nurses and practitioner nurses) for each day in a two week cycle. This model is very similar to the one developed in class for the ambulance staffing problem where table above is the "time chart")
Expert Answer:
Answer rating: 100% (QA)
Model for Scheduling Nursing Staff at a Hospital Variable Definition xiNumber of nurses assigned to scheduleiwherei1215 Expression for Objective Minim... View the full answer
Related Book For
An Introduction to Management Science Quantitative Approach to Decision Making
ISBN: 978-1337406529
15th edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Posted Date:
Students also viewed these business communication questions
-
You need to submit your Business Case Presentation. You will gain practical experience applying the System Development Life Cycle model and related techniques by undertaking an individual project...
-
You need to submit drafts of any communication pieces of your communication plan. 1. Thoroughly demonstrated the communication plan visually 2. Thoroughly analyzed how to manage risk 3. Thoroughly...
-
You need to submit drafts of any communication pieces of your communication plan. 1. Thoroughly demonstrated the communication plan visually 2. Thoroughly analyzed how to manage risk 3. Thoroughly...
-
Refer to the information in BE4-7 for Hébert Company. Prepare the correcting journal entries. Information in BE4-7 1. A collection of cash on account from a customer for $750 was recorded as a...
-
Consider the balance sheet for the DI listed below: The DI is expecting a $ 15 million net deposit drain. Show the DI's balance sheet under these two conditions: a. The DI purchases liabilities to...
-
Using the following information, complete the balance sheet given below: Total debt to net worth: 0.5 to 1. Turnover of total assets (based on year-end sales figures): 2. Gross profit: 30 per cent...
-
Refer to Samsungs financial statements in Appendix A. Compute its debt ratio as of December 31, 2015, and December 31, 2014. Data From Samsung Financial Statement Appendix A Samsung Electronics Co.,...
-
How would each of the following items be reported on the balance sheet? (a) Gift certificates sold to customers but not yet redeemed. (b) Discount on notes payable. (c) Current maturities of...
-
Two transverse sinusoidal waves combining in a medium are described by the wave functions V = 5.00 sin[(x + 0.300t)] Y25.00 sin[(x -0.300)] where x, y, and y are in centimeters and t is in seconds....
-
Dairy Services was organized on August 1, 20Y2. A summary of the revenue and expense transactions for August follows: Fees earned ..................................... $627,600 Wages expense...
-
Lecker quickly exchanged real property that was used exclusively for business and had an adjusted tax basis of $20,000 for new real property. The new real property had a fair market value of $10,000,...
-
Can you identify at least two specific ways that incorporate presence in your argument using delivery. "Arguments & arguing" .
-
What evolutionary benefits and intricate molecular adaptations underlie the resilience of extremophiles, emphasizing their capacity to flourish amidst the challenges posed by extreme environmental...
-
At present the United States does not have a press council to deal with cases involving breach of media ethics. What would be the ethical advantages and disadvantages of having a press council that...
-
What is the history of uniforms? When did people start to uniforms?
-
State space model of a dc motor roroor L U Re Ry voor eh 0 rrrrrr Hilt K = 1.2 N-m/amp K = 1.2 V/(rad/sec) = 100 V/amp The figure above, show a control scheme for controlling the azimuth angle of a...
-
Using Picard's process of successive approximations, obtain a solution up to the fifth approximation of the equation dy/dx = y + x, such that y = 1 whenx=0. Check your answer by finding the exact...
-
Estimate a range for the optimal objective value for the following LPs: (a) Minimize z = 5x1 + 2x2 Subject to X1 - x2 3 2x1 + 3x2 5 X1, x2 0 (b) Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 +...
-
Construct a spreadsheet simulation in which each trial consists of rolling of four dice. That is, there are four random variables each with an outcome of 1, 2, 3, 4, 5, or 6. For each trial, record...
-
Schneiders Sweet Shop specializes in homemade candies and ice cream. Schneider produces its ice cream in-house, in batches of 50 pounds. The first stage in ice cream making is the blending of...
-
Assume that the project in Problem 3 has the following activity times (in months): a. Find the critical path. b. The project must be completed in 1.5 years. Do you anticipate difficulty in meeting...
-
Deficits and fiscal consolidation As seen in the following table, the 2008 financial crisis left the United States with an enormous federal budget deficit in 2009. There was a substantial fiscal...
-
Which (if any) of the following statements about Pvalues is CORRECT? A. The Pvalue from a hypothesis test is the probability of obtaining your results, or more extreme results. B. The Pvalue from a...
-
Which (if any) of the following statements about the Type I error is CORRECT? A. The Type I error is the probability of rejecting the null hypothesis when it is true. B. The Type I error is the...
Study smarter with the SolutionInn App