b. What would the utilization of the bed capacity become if the new beds were added and the hospital were to perform the number of operations calculated in part a? (Round your answers to 1 decimal place.) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total Utilization % % % % % % %

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%
b. What would the utilization of the bed capacity become if the new beds were added and the hospital were to perform the number of
operations calculated in part a? (Round your answers to 1 decimal place.)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total
Utilization
%
%
%
%
%
%
Transcribed Image Text:b. What would the utilization of the bed capacity become if the new beds were added and the hospital were to perform the number of operations calculated in part a? (Round your answers to 1 decimal place.) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total Utilization % % % % % %
Shouldice Hospital in Canada is widely known for one thing-hernia repair! In fact, that is the only operation it performs, and it
performs a great many of them. Over the past two decades this small 66-bed hospital has averaged 5,080 operations annually. Last
year, it had a record year and performed nearly 5,580 operations.
A hernia repair operation at Shouldice Hospital is performed by one of the 12 full-time surgeons assisted by one of seven part-time
assistant surgeons. The first operations begin at 7:30 AM each day, Monday through Friday. Surgeons generally take about one hour
to prepare for and perform each hernia operation, and they operate on an average of at most four patients per day. This four patient
per day limit on the average number of operations performed per surgeon has been found to be the best operating level for the
hospital as it take into account time the surgeons need for patient exams and consultations, updating medical charts, writing reports,
traveling to professional conferences, vacations, and other times when they are performing other duties or are not available to perfor
surgeries. A given surgeon may perform more than four surgeries on a given day, but the average cannot exceed four without having
adverse effects on overall hospital operations. The surgeons' day ends at 4 p.m. Although hernia repair operations are performed only
five days a week, the remainder of the hospital is in operation continuously to attend to recovering patients.
The table below shows the room occupancy plan for the existing system. Each row in the table follows the patients who checked in on
à given day. The columns indicate the number of patients in the hospital on a given night.
CHECK-IN DAY
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total
MONDAY
22
22
44
BEDS REQUIRED
TUESDAY WEDNESDAY THURSDAY
22
22
22
66
222
66
22
22
22
66
FRIDAY SATURDAY
22
22
44
22
22
SUNDAY
22
22
Transcribed Image Text:Shouldice Hospital in Canada is widely known for one thing-hernia repair! In fact, that is the only operation it performs, and it performs a great many of them. Over the past two decades this small 66-bed hospital has averaged 5,080 operations annually. Last year, it had a record year and performed nearly 5,580 operations. A hernia repair operation at Shouldice Hospital is performed by one of the 12 full-time surgeons assisted by one of seven part-time assistant surgeons. The first operations begin at 7:30 AM each day, Monday through Friday. Surgeons generally take about one hour to prepare for and perform each hernia operation, and they operate on an average of at most four patients per day. This four patient per day limit on the average number of operations performed per surgeon has been found to be the best operating level for the hospital as it take into account time the surgeons need for patient exams and consultations, updating medical charts, writing reports, traveling to professional conferences, vacations, and other times when they are performing other duties or are not available to perfor surgeries. A given surgeon may perform more than four surgeries on a given day, but the average cannot exceed four without having adverse effects on overall hospital operations. The surgeons' day ends at 4 p.m. Although hernia repair operations are performed only five days a week, the remainder of the hospital is in operation continuously to attend to recovering patients. The table below shows the room occupancy plan for the existing system. Each row in the table follows the patients who checked in on à given day. The columns indicate the number of patients in the hospital on a given night. CHECK-IN DAY Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total MONDAY 22 22 44 BEDS REQUIRED TUESDAY WEDNESDAY THURSDAY 22 22 22 66 222 66 22 22 22 66 FRIDAY SATURDAY 22 22 44 22 22 SUNDAY 22 22
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.