A hospital emergency room is open $24$ hours a day. Nurses report for duty at $1$ a$.$m$.,5$ a$.$m$.,9$ a$.$m$.,1$ p$.$m$.,5$ p$.$m$.,$ or $9$ p$.$m$.,$ and each works an $8-$hour shift. Nurses are paid the same, regardless of the shift they work. The following table shows the minimum number of nurses needed during the six periods into which the day is divided. How should the hospital schedule the nurses so that the total staff required for one day$$s operation is minimized?

Shift Time Nursed Needed

$11-5$am $4$

$25-9$am $13$

$39$am$-1$pm $17$

$41-5$pm $10$

$55-9$pm $12$

$69$pm$-1$am $5$

Problem $3-17$

In addition to uploading the solution in the solutions view, take a screenshot or PDF of the formula view and upload it as well.

You are required to provide a written answer to the specific questions asked, to show that you understand how to interpret the spreadsheet solution. Failure to do so will result in a deduction of $10$ points. An example of the written answer is: The number of units that should be produced to maximize profit is $5,000$ units of product A and $4,000$ units of product B$.$ That combination will yield a maximum profit of $$50,000.$

PLEASE ANSWER THIS IN EXCEL WITH THE FORMAT REQUIRED. ALSO, MAKE SURE YOU INCLUDE THE FORMULA VIEW I NEED TO ALSO UPLOAD

Thank you so much, I will vote you!