PLEASE USE LINGO FOR THIS SOLUTION

Instructions You do not need to submit the algebraic model for any of these questions. However, for your own benefit you might wish to construct the algebraic models for questions 1, 2, 4, and 5 to help with the development of the computer models. The LINGO or Excel Solver models must include a definition of variables in the comments at the beginning. 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. Instructions You do not need to submit the algebraic model for any of these questions. However, for your own benefit you might wish to construct the algebraic models for questions 1, 2, 4, and 5 to help with the development of the computer models. The LINGO or Excel Solver models must include a definition of variables in the comments at the beginning. 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