1. The working system in a hospital is divided into 8 time periods, each of which is 3 hours, as in the table below. If the doctor who starts working in any time period works for 5 time periods, that is 15 hours, he/she gets 300$ per day, if he/she works for 3 time periods, he/she gets 200$. There is no other working schedule other than 9 hours or 15 hours. The minimum number of doctors required for each time period is given in the table. Write a model to minimize the total salary for doctors. (The doctor who starts working in last periods he/she is going on working with the period 1 of the other day. For example 7-8-1-2-3 periods can be chosen for a doctor to work.) Time Period Doctor Need Hours 06.00-09.00 1 3 2 09.00-12.00 6 3 12.00-15.00 7 4 15.00-18.00 5 5 18.00-21.00 4 6 21.00-00.00 3 7 00.00-03.00 2 8 03.00-06.00 2
1. The working system in a hospital is divided into 8 time periods, each of which is 3 hours, as in the table below. If the doctor who starts working in any time period works for 5 time periods, that is 15 hours, he/she gets 300$ per day, if he/she works for 3 time periods, he/she gets 200$. There is no other working schedule other than 9 hours or 15 hours. The minimum number of doctors required for each time period is given in the table. Write a model to minimize the total salary for doctors. (The doctor who starts working in last periods he/she is going on working with the period 1 of the other day. For example 7-8-1-2-3 periods can be chosen for a doctor to work.) Time Period Doctor Need Hours 06.00-09.00 1 3 2 09.00-12.00 6 3 12.00-15.00 7 4 15.00-18.00 5 5 18.00-21.00 4 6 21.00-00.00 3 7 00.00-03.00 2 8 03.00-06.00 2
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...
Related questions
Question
Please explain both subparts
Transcribed Image Text:1. The working system in a hospital is divided into 8 time periods, each of which is 3
hours, as in the table below. If the doctor who starts working in any time period works
for 5 time periods, that is 15 hours, he/she gets 300$ per day, if he/she works for 3
time periods, he/she gets 200$. There is no other working schedule other than 9 hours
or 15 hours. The minimum number of doctors required for each time period is given in
the table. Write a model to minimize the total salary for doctors. (The doctor who
starts working in last periods he/she is going on working with the period 1 of the other
day. For example 7-8-1-2-3 periods can be chosen for a doctor to work.)
Time Period
Doctor Need
Hours
06.00-09.00
1
3
2
09.00-12.00
6
12.00-15.00
7
15.00-18.00
5
18.00-21.00
4
21.00-00.00
3
00.00-03.00
2
03.00-06.00
2
3
4
5
6
7
8
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.