A plumbing repair company has 3 employees and must choose which of 3 jobs to assign...

 

Transcribed Image Text:

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. Job 1 Job 2 Job 31 Employee A 48 43 51 Employee B 45 35 51 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? Minimum cost Employee C 44 45 50 (Click to select) d. What is the minimum cost to complete all three jobs? 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. Job 1 Job 2 Job 31 Employee A 48 43 51 Employee B 45 35 51 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? Minimum cost Employee C 44 45 50 (Click to select) d. What is the minimum cost to complete all three jobs?

Answer rating: 100% (QA)

1 To determine which employee should be assigned to Job 1 we need to find the employee with the lowest cost for performing that job Looking at the tab... View the full answer