Please Solve using Excel Solver. Show exact steps and constraints in excel solver. Please provide pictures of all steps along with the solution.

5. Virat Kohli, the hospital administrator at mythical Trinity Hospital, wants to assign nurses beginning a shift in the oncology ward of the hospital. The time required for patient care varies from one patient to the next based on the type of care, experience, and skill level of the nurses. Given the following patient roster and time estimates in hours required by each nurse for each patient, develop an efficient assignment of nurses to patients