Question: PLEASE DO NOT USE EXCEL SOLVER. I DO NOT NEED THE SOLUTION, I ONLY NEED THE IP FORMULATION Q4) (30p) The IT department of OzU

PLEASE DO NOT USE EXCEL SOLVER. I DO NOT NEED THE SOLUTION, I ONLY NEED THE IP FORMULATIONPLEASE DO NOT USE EXCEL SOLVER. I DO NOT NEED THE

Q4) (30p) The IT department of OzU has to take care of some problems occurred in the student's computers. There are 8 different computers and each computer has different type of problem. The IT department consists of 3 workers and these workers can only fix the problems they are trained for. Each computer's problem will be assigned to 1 worker and obviously, more than one computer will be assigned to some workers. And at least one problem has to be fixed by each worker. The rank of fixing a problem differs for each worker and the ranks are in the below table. Problem 5 1 2 3 4 5 6 7 8 1 5 6 7 1 2 5 0 5 Worker |N| 2 9 5 0 2 3 3 5 6 4 5 3 5 8 Develop an integer programming formulation to determine the assignment of problems to the operators such that the difference between the maximum and minimum among the rankings of the problems assigned to the workers is minimized. With ensuring this, the service of IT has high rank. (For ex: the total ranks of the assigned problems for the 3 workers are 35, 40, 32. Then the difference between the maximum and minimum is 40-32=8)

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!