Distinct Resource Allocation
Hi All,
I have a list of tasks ( Task A to Task Z) each requiring different amount of hours. On the other hand I also have a list of contractors each of which is able to commit to a specific amount of hours.
Is there a excel formula that I can use so that I can meet the following criteria:
1. I need to clear Task A to Task Z in that sequence.
2. Each contractor can only be used once.
3. I want to clear the maximum number of tasks with my limited pool of contractors.
Example:
- Read more about Distinct Resource Allocation
- 5 comments
- Log in or register to post comments


