A plumbing repair company has $3$ employees and must choose which of $3$ jobs to assign each to $($each employee is assigned to exactly one job and each job must have someone assigned$).$ Each employee can perform each job, but the cost to perform any given job can vary. The following table shows the cost for each employee to perform each job.

Employee A Employee B Employee C

Job $1553749$

Job $2494435$

Job $3393749$

Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions:

Which employee is assigned to job $1?$

Employee B Correct

Which employee is assigned to job $2?$

Employee C Correct

Which employee is assigned to job $3?$

Employee A Correct

What is the minimum cost to complete all three jobs?