Issue Jobs Evenly - a little challenge

[Chimp8471]

I have an idea, but don’t know if it can be done,

I am creating a helpdesk and am at the stage of allocating jobs to technicians.

I would like to ensure that the tasks are spread out evenly between the technicians, for example:

I have 4 Technicians and 100 jobs; I would like the jobs to be allocated 25 each,

As the jobs are cleared that technician’s job list will decline.

In the meantime new jobs may come in I would then want these added to the technicians so that they become evenly spread out again.

Is this as complicated as it sounds…….

A nice little example would be nice please…..

 

[Navyguy]

Just a thought,

A job is not a job is not a job...

You might consider the length of time to complete the job/task verses just the job/task itself.

Not being a techie, I would think that setting up a new workstation c/w software, server connections, etc takes alot longer then replacing Bill's mouse. Yet they are both "a job".

Navyguy

 

[neileg]

My colleague has a working prototype of a system like this, although his works by allocating jobs on demand. At the start of the day, the tchnician logs in. He is presented with a llist of jobs he has started, but have been suspended. He can choose to reactivate a job (perhaps he's been waiting for parts) or he can ask for a new job. This is allocated on the basis of geographical area, skills required. Managers have the ability to change job allocation, manually, if required.

This all works very well. However, my colleague can only use macros, and the system is a complete rats' nest behind the scenes, so there's no chance of letting you have a copy!

You might start, however, with the idea of allocating jobs on demand. This will allow you to prioritise jobs, ensuring that whoever is available next, could get the priority job. It should also keep all techs busy.

Hope this helps.