Please show the steps used to find the answer using Excel st

Please show the steps used to find the answer using Excel step by Step. and provide the answers requested in the table

0·(1 opts) Prolessor Jones wants to assign four research problems to her four research assistants (RA). The RAs have different expertise, and the times required for each of them to solve each problem are listed below. Professor Jones wants all the problems to be assigned; each assigned to at most two problems. RA can be Problems 3 R.A Carl 6 Jennifer 6 4 6 Mat ignment schedule such that the total time needed to solve the problems is minimized. The total time needed to solve all the problems is assignment in the table below. days. Fill the Problems 3 R.A Carl Jennifer Mat

Solution

Since the minium time is 3 days for problem 3rd by jennifer, so problem 3 goes to jennifer,

The next minimium time is 4days for problem 4th by Jennifer so this problem is assigned to her as well.

Problem 1 goes to Harry has he takes 6 days only and probelm 2 goes to Carl who also takes 6 days to solve .

hence the total days to solve 3+4+6+6=19 days