You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Cliente Andrea Bruno Claudio Daniela Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Now consider the following additional conditions:- Bravia and Cúbika projects cannot be assigned to the same collaborator.- The Fenix and Golden projects cannot be assigned to the same collaborator.State and solve the problem through excel
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table:
|
Cliente |
Andrea |
Bruno |
Claudio |
Daniela |
|
Arkitex |
3 |
3 |
2 |
1 |
|
Bravia |
3 |
3 |
4 |
3 |
|
Cúbika |
4 |
5 |
6 |
4 |
|
Doratta |
8 |
6 |
5 |
7 |
|
Evergreen |
3 |
4 |
2 |
2 |
|
Fenix |
5 |
6 |
3 |
4 |
|
Golden |
3 |
3 |
1 |
4 |
|
Horizon |
6 |
8 |
6 |
5 |
|
Icónika |
5 |
5 |
5 |
5 |
|
Luxus |
4 |
4 |
1 |
2 |
Now consider the following additional conditions:
- Bravia and Cúbika projects cannot be assigned to the same collaborator.
- The Fenix and Golden projects cannot be assigned to the same collaborator.
State and solve the problem through excel
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
