I'm trying create to excel based automated resource allocator. I have 24 agents to work on 6 regions such as North, Northeast, South, Southeast, East and West. We have new and old files on all regions. We recieve 2500 files per day on an average from monday to friday. I need an allocator which assigns agents to the regions depending on the file count on a daily basis. An agent can work on maximum of 160 file/per day irrespective of the region. Agents must be shuffled on a daily basis, this is to make sure every one gets to work on all the regions by the end of week (or no one gets to complaint that he/she is been assigned to same region).
We can get a definite count of the old file however new files keep coming through the day. 75% old files and 25% new files of the total file count.
Please i need urgent assistance on this.