For each of the following situations, how would you modify the model? 1) Consultants 1 and 5 have an expertise in sustainable development (all other consultants don’t). Project C requires at least one expert in sustainable development. 2) Consultant 6 is a mentor for Consultant 4 and they need to be assigned to the same project. Write down additional constraints to ensure that 4 and 6 work on the same project. 3) Consultant 6 decided that she will not take the position unless she is assigned to a project in which her level of interest is at least 7 (that is either Project C or D).
You work at McKinsey Company and you are in charge of assigning 6 new consultant analysts to projects. There are 5 projects in total. For a given project, up to 3 new consultants can be assigned (i.e., either 0,1,2 or 3 consultants will be assigned to each project). Each consultant is assigned to exactly one project. The table below indicates on which projects the new consultants can be assigned based on their skills and areas of expertise.
Project A Project B Project C Project D Project E
Consultant 1 Yes Yes Yes No Yes
Consultant 2 No Yes No No Yes
Consultant 3 Yes No No Yes Yes
Consultant 4 Yes Yes Yes Yes No
Consultant 5 Yes No Yes Yes No
Consultant 6 Yes Yes Yes Yes Yes
The table below indicates the level of interest of each consultant in each project on a 10-point scale.
Project A Project B Project C Project D Project E
Consultant1 5 3 3 4 7
Consultant2 7 9 5 6 3
Consultant3 1 2 3 8 4
Consultant4 10 5 4 5 6
Consultant5 8 3 6 7 7
Consultant6 6 4 8 10 5
For each of the following situations, how would you modify the model?
1) Consultants 1 and 5 have an expertise in sustainable development (all other consultants don’t). Project C requires at least one expert in sustainable development.
2) Consultant 6 is a mentor for Consultant 4 and they need to be assigned to the same project. Write down additional constraints to ensure that 4 and 6 work on the same project.
3) Consultant 6 decided that she will not take the position unless she is assigned to a project in which her level of interest is at least 7 (that is either Project C or D).
Step by step
Solved in 5 steps with 28 images