Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

THE ANSWER IS 20, BUT I NEED TO PROVE WHY Listed below is the minimum amount of nurses that need to be staffed per day

THE ANSWER IS 20, BUT I NEED TO PROVE WHY

Listed below is the minimum amount of nurses that need to be staffed per day of the week at a hospital:

Monday - at least 5 nurses working

Tuesday - at least 13 nurses working

Wednesday - at least 15 nurses working

Thursday - at least 19 nurses working

Friday - at least 14 nurses working

Saturday - at least 16 nurses working

Sunday - at least 11 nurses working

Each nurse may start on any day of the week, but must work 5 consecutive days with 2 consecutive days off.

Use Excel to prove the minimum number of nurses that can be hired to meet shift requirements and follow the 5 days on and 2 days off set schedule. (Hint: Some days will have more nurses than the shift requires).

Please show proof formulas in Excel!!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these General Management questions

Question

2. What we can learn from the past

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago