Please help with this question as soon as possible. Show all steps, and answer all questions.

Question 1: Time required (in hours) to complete routine tasks is as below table. The goal (objective) is to minimize resources (hours). Note that 1) every nurse must work, and 2) every patient must be taken care of. Determine how long it will take for the nurses to complete their routine tasks on this shift. Indicate your assignment clearly. What is the average hours to complete tasks? (1pt)

Question 2: (revised) 17.2 (continued from 17.1) Refer to the table below. If the hospital now wants to focus on customer perceptions of quality. Reassign the nursing staff to obtain the highest customer approval rating possible (a perfect score is 100). The same conditions (constraints) apply: that is, 1) every nurse must work, and 2) every patient must be taken care of. What is the average rating? Indicate your assignment clearly. [steps: 1.5 ptfilling below matrixes; final assignment 0.5pts, average rating 0.5pts]

Question 3: (continued from 17-2)

a) If now only the constraint of every nurse must work is lifted (meaning the other constraint remains), re-assignment to maximize the ratings. Show your assignment clearly. Who (i.e., which nurse) doesnt need to work? What is the average rating? (You can make use of your last matrix in 17-2 and just re-assign. Please copy your last matrix in 17-2 below). Point breakdown: Copy the last matrix-0.1pps; assignments:0.2pts; Nurse ________ not working (0.1pt); average rating: ________ (0.1pt)

b) If now only the constraint of every patient must be taken care of is lifted (meaning the other constraint remains), re-assignment to maximize the ratings. Show your assignment clearly. Which patient is not take care of? What is the average rating? (You can make use of your last matrix in 17-2 and just re-assign). Please copy your last matrix 17-2 below). Point breakdown: Copy the last matrix-0.1pps; assignments:0.2pts; Patient ________ not being taken care of (0.1pt); average rating: ________ (0.1pt)

c) Compare the results between:

1) Question 1 (i.e., 17-1) & Question 2 (i.e., 17-2). What do you observe by listing one takeaway (0.1pt per takeaway).

2) Question 2 and Question 3a) & b). What do you observe? Please list one takeaway (0.2pts) and comment on which constraint (not every nurse has to work vs. not every patient must be taken care of) is more restricting and why (0.2pts).

Time (hrs) required to complete tasks Patient Nurse 1 Nurse 2 Nurse 3 Nurse 4 Jones 3 5 4 3 Hathaway 2 1 3 2 Bryant 3 4 2 N Sweeney 4 3 3 4 Step 1: Row reduction Step 2: Column reduction Step 3: Cover all zeros Rating Nurse Patient Nurse 2 Nurse 3 Nurse 4 1 Jones 89 95 83 84 Hathaway 88 80 96 85 Bryant 87 92 82 84 Sweeney 93 82 86 94 Step 1: Row reduction Step 3: Step 2: Column reduction Cover all zeros Step 4: Modify matrix Step 5: Repeat Step 3 &4