(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
Answered
QUALITY
Approved
ANSWER RATING

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

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:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote