Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.

1. There are four jobs to be done and four employees to do them. Each resource will take a specific time, translated to salaries, to do each job, as shown in the following table:

Employee
Job	A	B	C	D
1	$20	23	21	17
2	18	18	22	19
3	19	24	23	12
4	21	19	18	18

1. What is the result of the row reduction?

2. What is the result of the column reduction?

3. What is the result of modifying the row and column reductions table?

4. What is the optimum assignment of jobs to employees?

5. What is the total cost for the optimum assignment of jobs to employees?