(Solution) If you are good at excell can you solve this problem??
If you are good at excell can you solve this problem??
A nursing home employs attendants who are needed around the clock. Each attendant is paid the same, regardless of when his or her shift begins. Each shift is 8 consecutive hours. Shifts begin at 6am, 10am, 2pm, 6pm, 10pm and 2am. The following table shows the nursing homes requirements for the number of attendants to be on duty during specific time periods.
Shift A, 2-6AM, needs 8 attendants.
Shift B, 6-10AM, needs 27 attendants.
Shift C, 10AM-2PM, needs 12 attendants
Shift D, 2-6PM, needs 23 attendants
Shift E, 6-10PM, needs 29 attendants
Shift F, 10PM-2AM, needs 23 attendants
(A) what is the minimum number of attendants needed to satisfy the nursing homes requirements.
(B) The nursing home would like to use the same number of attendants determined in part (A) but would now like to minimize the total salary paid. Attendants are paid 16$ per hour during 8AM-8PM, and a 25% premium per hour during 8PM-8AM. How should the attendants be scheduled?
SOLVER and LP models. Business schedule making.
This question was answered on: May 23, 2022
Solution~00021147721269.zip (25.37 KB)
This attachment is locked
Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)
Answered
QUALITYApproved
DATE ANSWEREDMay 23, 2022
EXPERTTutor
ANSWER RATING
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions: