A plumbing repair cmpany has 3 employees and must choose which of 3 jobs to assign each to (each employee is a exactly one job anc each job must have someone assigned). Each employee can perform each job, but the cost to perform job can vary. The fo owing table shows the cost for each employee to perform each job. Employee A Job 1 Job 2 Job 3 Employee B 45 38 51 Employee c 49 35 45 43 47 Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions: a. Which employee is assigned to job 1? (Click to select) b. Which employee is assigned to job 2? (Click to select) c. Which employee is assigned to job 3? (Click to select) d. What is the minimum cost to complete all three jobs? Minimum cost Next) < Prev 1 of 5