I do not understand how to solve for schedule preference score or actual. can you help me sole the problem using excell and excplain how you didi it?

The picture below contains the instructions and the required information for this problem.

B C D S u V w E G J K L M N 0 P Q R For the highest de Use Solver to determine how to assign nurses to the five different schedules you developed in the previous step based on seniority and ther reported preferences Since all the fields in the spreadsheet me provided detalyes of employment and employee responses or calculations Solver should only be allowed to maipulate cell 021:026 (the ones assigned and reres not assigned) Need het? Watch the game Preference of employees Schedule assigned to Seniority Seniority Employee years) factor Mary 5 0.71 Anne 6 086 Susan 4 0.57 Tom 7 1.00 Cathy 3 Jane 2 0 29 A 3 3 2 3 3 5 B 1 2. 3 2 4 4 C 2 1 5 4 5 3 D 4 4 1 1 2 2 E 5 5 4 5 1 1 Weighted preference of employees A B C D E 2.14 0.71 143 286 3.57 2.57 171 0.86 3.43 429 1.14 1.71 286 0.57 2.29 3.00 200 400 100 500 129 171 214 0.06 0.43 1.43 1.1 0.86 0.57 0.29 A 0 0 0 0 0 0 B 0 0 0 0 0 0 C 0 0 0 0 0 0 D 0 0 0 0 0 0 E 0 0 0 0 D 0 Preference Total score 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0.43 Maximum 2 0.0 Actual: Needed: 0 1 0 1. 0 1 0 1 0 2 Employees solution +