Question

In: Statistics and Probability

Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a schedule for...

Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a schedule for nurses to make sure there are enough of them on duty throughout the day. During the day, the demand for nurses varies. Maureen has broken the day in to twelve 2-hour periods. The slowest time of the day encompasses the three periods from 12:00 A.M. to 6:00 A.M., which beginning at midnight; require a minimum of 30, 20, and 40 nurses, respectively. The demand for nurses steadily increases during the next four daytime periods. Beginning with the 6:00 A.M.- 8:00 A.M. period, a minimum of 50, 60, 80, and 80 nurses are required for these four periods, respectively. After 2:00 P.M. the demand for nurses decreases during the afternoon and evening hours. For the five 2-hour periods beginning at 2:00 P.M. and ending midnight, 70, 70, 60, 50, and 50 nurses are required, respectively. A nurse reports for duty at the beginning of one of the 2-hour periods and works 8 consecutive hours (which is required in the nurses’ contract). Dr. Becker wants to determine a nursing schedule that will meet the hospital’s minimum requirement throughout the day while using the minimum number of nurses.

A. Formulate a linear programming model for this problem

B. Solve this model by using the computer - I need to see the excel spreadsheet, formulas, and solver parameters.

Thank you!!!

Solutions

Expert Solution

DATE:29-04-2020

ANSWER:-----------------------


Related Solutions

Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a schedule for...
Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a schedule for nurses to make sure there are enough of them on duty throughout the day. During the day, the demand for nurses varies. Maureen has broken the day in to twelve 2-hour periods. The slowest time of the day encompasses the three periods from 12:00 A.M. to 6:00 A.M., which beginning at midnight; require a minimum of 30, 20, and 40 nurses, respectively. The demand...
You are the hospital administrator for a county hospital, which is funded in a large part...
You are the hospital administrator for a county hospital, which is funded in a large part by that county's property taxes. You discover that you have an indigent patient who has been mistakenly admitted as an inpatient to the hospital strictly for dialysis treatment. The hospital does not, as a general practice, provide only dialysis treatment for patients. This is beyond the scope of the hospital's mandate and is therefore, an inappropriate use of local property tax funding. If the...
You are the hospital administrator for a county hospital, which is funded in a large part...
You are the hospital administrator for a county hospital, which is funded in a large part by that county's property taxes. You discover that you have an indigent patient who has been mistakenly admitted as an inpatient to the hospital strictly for dialysis treatment. The hospital does not, as a general practice, provide only dialysis treatment for patients. This is beyond the scope of the hospital's mandate and is therefore, an inappropriate use of local property tax funding. If the...
Allegheny Community Hospital is a nonprofit hospital operated by the county. The hospital’s administrator is considering...
Allegheny Community Hospital is a nonprofit hospital operated by the county. The hospital’s administrator is considering a proposal to open a new outpatient clinic in the nearby city of New Castle. The administrator has made the following estimates pertinent to the proposal. Construction of the clinic building will cost $640,000 in two equal installments of $320,000, to be paid at the end of 20x0 and 20x1. The clinic will open on January 2, 20x2. All staffing and operating costs begin...
Bravo Community Hospital is a nonprofit hospital operated by the county. The hospital’s administrator is considering...
Bravo Community Hospital is a nonprofit hospital operated by the county. The hospital’s administrator is considering a proposal to open a new outpatient clinic in the nearby city of New Castle. The administrator has made the following estimates pertinent to the proposal. Construction of the clinic building will cost $840,000 in two equal installments of $420,000, to be paid at the end of 20x0 and 20x1. The clinic will open on January 2, 20x2. All staffing and operating costs begin...
In April 1993, Dr. Nancy Olivieri, head of the hemoglobinopathy program at the Hospital for Sick...
In April 1993, Dr. Nancy Olivieri, head of the hemoglobinopathy program at the Hospital for Sick Children (HSC), the teaching hospital for the University of Toronto in Canada, signed an agreement with the Canadian drug company Apotex to undertake clinical trials on a drug called deferiprone (referred to as L1 during the study). The drug was designed to help children with thalassemia, an inherited blood disorder that can cause the fatal buildup of iron in the blood. The agreement that...
A rural county hospital offers several health services. The hospital administrators conducted a poll to determine...
A rural county hospital offers several health services. The hospital administrators conducted a poll to determine whether the residents’ satisfaction with the available services depends on their gender. A random sample of 1000 adult county residents was selected. The gender of each respondent was recorded and each was asked whether he or she was satisfied with the services offered by the hospital. The resulting data are shown in the table below. Using a significance level of 0.05, conduct an appropriate...
One of the important skills that hospital administrator must possess is the analytical skills which involves...
One of the important skills that hospital administrator must possess is the analytical skills which involves the ability to: See the big picture about the future. Diagnose and evaluate problems. Analyze the environment. All of the above.
Question 2(12 Marks) There are 6 cities in Kilroy County.  The county must determine where to build...
Question 2 There are 6 cities in Kilroy County.  The county must determine where to build central fire stations.  The county wants to build the minimum number of central fire stations needed to ensure that at least two fire stations are within 20 minutes (driving time) of each city. The times (in minutes) required to drive between the cities in Kilroy County are given in the table. Formulate a model that will tell Kilroy how many fire stations should be built and...
QDM Question 2 (12 Marks) There are 6 cities in Kilroy County.  The county must determine where...
QDM Question 2 There are 6 cities in Kilroy County.  The county must determine where to build central fire stations.  The county wants to build the minimum number of central fire stations needed to ensure that at least two fire stations are within 20 minutes (driving time) of each city.  The times (in minutes) required to drive between the cities in Kilroy County are given in the table. Formulate a model that will tell Kilroy how many fire stations should be built and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT