In: Operations Management
J.C. Howard's medical testing company in Kansas wishes to assign a set of jobs to a set of machines. The following table provides the production data of each machine when performing the specific job:
Machine |
||||
Job |
A |
B |
C |
D |
1 |
7 |
9 |
8 |
10 |
2 |
10 |
9 |
7 |
6 |
3 |
11 |
5 |
9 |
6 |
4 |
9 |
11 |
5 |
8 |
a) The optimal assignment of jobs to machine that will maximize total production is:
Machine A |
→ |
Job ___ |
Machine B |
→ |
Job ___ |
Machine C |
→ |
Job ___ |
Machine D |
→ |
Job ___ |
b) The total production of the assignment = ______ units (enter your response as a whole number).
Please SHOW WORK
The cell reference used for allotted and assigned and total production has been mentioned
We have to maximize the total production
Each job can be assigned to 1 machine and one machine can handle one job
Solver Parameters:
Optimal Solution:
Answers:
Machine A: Job 2
Machine B: Job 4
Machine C: Job 3
Machine D: Job 1
The total production of the assignment = 40 units
********
IF YOU HAVE ANY DOUBT, KINDLY COMMENT. I WOULD LOVE TO HELP YOU!!!
IF YOU LIKE THE ANSWER, PLEASE GIVE AN UP-VOTE OR THUMB UP. THIS WILL ENCOURAGE ME TO ANSWER MORE!!