+ Reply to Thread
Results 1 to 2 of 2

Equally Spread Workload

Hybrid View

  1. #1
    Registered User
    Join Date
    03-18-2007
    Posts
    1

    Question Equally Spread Workload

    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?

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    I believe that it is up to you to devise that system using queuing theories pertaining to operational research; its application can then be done by Excel.
    Best regards,

    Ray

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1