I need a solution for a problem I am having at work. I work on a service centre and need to come up with a way to equally distribute work to members of a team.
The workload I have is displayed as follows:
TeamName Number of Cases
TeamA 10
TeamB 15
TeamC 5
TeamD 20
TeamE 1
TeamF 12
TeamG 50
etc
And what I need to do is distribute the teams evenly as possible.
For example:
Person1: TeamG = 50
Person2: TeamA TeamB TeamC TeamE = 31
Person3: TeamD TeamF = 32
There are in the region of 250 teams with a total number of cases of 7500, which I need to distribute to about 30 people.
Is there anyway to automate this?
Bookmarks