Module B Check Your Understanding Fari Help Save & Exit Submit 1 A plumbing repair company has 3 employees and must choose which of 3 jobs to assign each to leech employee is assigned to cxactly onc jab and each job must have someone assigned. Each employee can perfarm cachjob, but the cost to perform any given Job can vary. The following table shows the cost for each employee to perform each job Eorployee Engloyee Erployecc 44 43 5 50 Sulve this assignment problem in Excel to find the lowest cost solution and enswer the following questions: a. Which employee is assigned ta jabs 1? Click to sclecti b. Which employee is assigned to job 2? Click to see c. Which employee is assigned to job 3? Click to enlad d. What is the minimum cost to complete all three johs? Minimum