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. I am reposting this as someone from Chegg didn't answer it properly previously. They didn't put any effort and just provided final answer. I need to solve it with Excel Solver, so plz don't waste my question by not properly answering. I am paying for the subscription.

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