PLEASE USE LINGO TO SOLVE!! IF YOU USE EXCEL PLEASE SHOW SCREENSHOT

1. (20 marks) A house renovator has six employees, and there are six tasks to be done. Each employee will be assigned to one of these tasks. The employees differ in their capabilities, so the times to do each task are different. The following table gives the number of hours required for each employee to complete each task. Once an employee's task has been completed, he or she will move on to another house renovation. In some cases, an employee lacks the qualifications to do a particular task; this is indicated by the symbol _. Employee 1 2 3 4 5 6 Task 1 2 3 4 5 6 4.5 4.1 3.2 5.0 4.9 5.0 4.7 4.6 5.0 5.4 4.4 3.5 6.0 5.8 5.7 5.1 5.2 3.9 5.0 5.5 4.8 4.9 4.8 4.2 5.3 5.1 5.6 4.6 5.3 5.4 5.6 4.9 (a) The contractor wishes to minimize the total number of hours used to do these jobs. Use LINGO or the Excel Solver to determine the optimal solution. (b) State this solution so that anyone would be able to understand it