Given an example:
Employee A,B,C can work on three tasks 1,2,3. The value created by each employee on each task are: A:(9,10,11) B:(4,5 ,10) C:(1,3 ,5) Ideally, A,B,C all work on task 3 will create the highest value.
But there is a constraint that each task can only be worked on by one person.
So the best solution will be A1, B3, C2 with total value of 9 + 10 + 3.
Is there any optimization algorithm can do solve problem like this if I have more people, more tasks and not only one but several people can work on one task together?
Thanks to forecaster, problem solved by using excel solver. I am trying to replicate this in R now: