Question: 50. Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the file

50. Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the file

50. Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the file P05_50.xlsx. Determine the assignment of employees to jobs that minimizes the total time required to perform the four jobs. (A blank indicates that a person cannot do that particular job. Also, assume that no person can do more than one job.) A 1 Job assignment data 2 3 Job times B C D E 4 Job 1 Job 2 Job 3 Job 4 5 Person 1 29 30 30 6 Person 2 29 30 16 7 Person 3 18 21 18 18 8 Person 4 9 Person 5 22 21 25 24 15 26

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To solve this assignment problem in detail lets go through the calculations manually to find the optimal assignment of employees to jobs that minimizes the total time This is an assignment problem tha... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

it is question 53 in the textbook and the next photo is the excel spreadsheet 48. The Amorco Oil Company controls two oil fields. Field I can produce up to 22 million barrels of oil per day, and...

I just solved this job assignment problem where I had to use excel and solver to get the answer. I was wondering if I solved it correctly. Below I attached the problem, the data for the problem, my...

SOLVE IN EXCEL USING SOLVER: SHOW ALL FORMULAS USED AND THE SOLVER: P05_50.XLSX: Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the...

Use excel solver and show all the formulas 50. Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the file P05_50.xlsx. Determine the...

Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the file P05_50.xlsx. Determine the assignment of employees to jobs that minimizes the...

Question 1 (25 points): Five employees are available to perform four jobs. The time it takes each person to perform each job is given in Table. Determine the assignment of employees to jobs that...

Determine the moment of inertia of the beam?s cross-sectional area about the y axis. 60 mm 60 mm -15 mm 15 mm 100 mm 15 mm, 50 mm 50 mm 15 mm 100 mm

Identify and contrast the various ways employers can control the costs of healthcare.

Giving the following manually exclusive alternative, which one is preferable if the interest rate is 1 6 % per year compounding quarterly? What is the breakeven initial cost of project A or B to make...

value: 1.00 points Penn Company uses a periodic inventory system. At the end of the annual accounting period, December 31, 2015, the accounting records provided the following information for product...