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 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)