A plumbing repair company has 3 employees and must choose which of the 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 Job1 48 45 44 Job2 43 35 45 Job3 51 51 50

Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions? A. Which employee is assigned to job1? B. Which employee is assigned to job 2? C. Which employee is assigned to job 3? D. Which is the minimum cost to complete all three jobs?