LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KC
 
Posts: n/a
Default Allocate workload evenly to different staff

We have thousand of customers while they have different
peak seasons. Some of them have more business in summer
and some of them have more business in winter. How to re-
assign these customers to CS staff so that their workload
will be more evenly, but not someone's very busy in summer
but idle in winter.

My raw data looks like following:
Customer A 12/15/2005 Staff A
Customer C 12/15/2005 Staff C
Customer A 12/15/2005 Staff A
Customer A 12/16/2005 Staff A
Customer B 12/16/2005 Staff B
Customer A 12/17/2005 Staff A
Customer A 12/17/2005 Staff A
Customer A 12/17/2005 Staff C
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"