Use excel solver and show all the formulas

50. Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the file P05_50.xlsx. Determine the assignment of employees to jobs that minimizes the total time required to perform the four jobs. (A blank indicates that a person cannot do that particular job. Also, assume that no person can do more than one job.) \begin{tabular}{|l|l|r|r|r|r|} \hline & \multicolumn{1}{|c|}{ A } & B & C & \multicolumn{1}{|c|}{D} & \multicolumn{1}{|c|}{ E } \\ \hline 1 & Job assignment data & & & & \\ \hline 2 & & & & \\ \hline 3 & Job times & & & & \\ \hline 4 & & Job 1 & Job 2 & Job 3 & Job 4 \\ \hline 5 & Person 1 & 29 & 30 & & 30 \\ \hline 6 & Person 2 & & 29 & 30 & 16 \\ \hline 7 & Person 3 & 18 & 21 & 18 & 18 \\ \hline 8 & Person 4 & 21 & & & 25 \\ \hline 9 & Person 5 & 24 & & 15 & 26 \\ \hline \end{tabular}