It is a mgmt science question, slover by excel please.

17. There are G contractors and 5 different tasks . Each contractor charges differently for each task . Task I Task Z Task 3 Task 4 Task 5 Contractor ] 5.01 5.5 35 45 Contractor ?' 40) 45 35 Contractor 3 45 15 45 5.17 Contractor 4 35 35 5 5 Contractor 5 35 55 401 5.5 Contractor 6 5.5 407 65 65 45 2. Formulate an ILP to assign the five tasks to Five contractors ( each contractor can do only one task ; at the lowest total cost . b . Suppose Contractor & cannot do task 1 . How would you modify your formula - tion in part a to handle this situation ?"