Please use Excel Solver to solve this question. Also please show the formulae that you apply in each cell along with screenshots of constraints etc.

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