(Solution) If You Are Good At Excell Can You Solve This Problem?? | Snapessays.com

(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.

Solution details:
STATUS
QUALITY
Approved

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)

STATUS

QUALITY

Approved

May 23, 2022

EXPERT

Tutor