Question: Job 3 2) (30 points] ASSIGNMENT PROBLEM: JoShop needs to assign 4 jobs to 4 workers. The cost of performing a job is a function

Job 3 2) (30 points] ASSIGNMENT PROBLEM: JoShop

Job 3 2) (30 points] ASSIGNMENT PROBLEM: JoShop needs to assign 4 jobs to 4 workers. The cost of performing a job is a function of the skills of the workers. Following table summarizes the cost of the assignments. Worker I cannot do job 3 and worker 3 cannot do job 4. Job 1 Job 2 Job 4 Worker 1 $50 $50 $40 Worker 2 $70 S40 $20 $30 Worker 3 $30 $50 Worker 4 $90 S20 $60 $70 Determine the optimal assignment using the EXCEL solver (you can use the assignment problem $90

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!