Question: Please provide the answer in details Instructions You do not need to submit the algebraic model for any of these questions. However. for your own
Please provide the answer in details

Instructions You do not need to submit the algebraic model for any of these questions. However. for your own benet you might wish to construct the algebraic models for questions II 2. 4, and 5 to help with the development of the computer models. The LING or Excel Solver models must include a denition of variables in the comments at the beginning. L (2-D marks) A house renovator has six employeesI 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. Dnce an employee's task has been completed, he or she will move on to another house renovation. In some casesI an employee lacks the qualications to do a particular task; this is indicated by the symbol \"". 4.1 3.2 5.1] 4.? 4.5 3.5 ll 5.2 3.9 5.1] 4.3 4.2 5.3 5.3 5.4 {a} The contractor wishes to minimize the total number of hours used to do these jobs. Use Lm or the Excel Solver to determine the optimal solution. [b] State this solution so that anyone would be able to understand iL
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
