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:
Task A - 200, Task B - 450, Task C - 800, Task D - 1250, Task E - 1802
Contractor 1 - 100, Contractor 2 - 150, Contractor 3 - 150, Contractor 4 - 150, Contractor 5 - 155, Contractor 6 - 225
Expected Results:
Task A - Contractor 6 (Wastage 25)
Task B - Contractor 2, 3, 4 (Wastage 0)
Task C - Add more contractors.
Whilst the tasks and the hours are repetitive, the contractor hours change weekly, hence I am looking to automate the process of finding the best fit.
I was wondering if there was an easier way to do this other than manual trial and error.
Regards,
Benjamin
Replies