Hi everybody,

I'm writing a procedure which distributes work between employees. I have a pool of unassigned accounts which I'm assigning to the users. Each user has the following fields in his/her profile:

iregular_account_limit
iqueue_overflow_count
idelinquent_account_limit

If the user didn't work his/her accounts, they become delinquent.

I would try to explain the problem in example:
The new user Joe has 50 accounts for his Daily queue as a regular count limit and 10 for overflow. My program assigns him 50 accounts for Monday, 50 for Tuesday, 50 for Wednesday, 50 for Thursday and 50 for Friday.

Now, on Monday he worked up 30 accounts, and re-scheduled 10 for the next week’s Monday. So, he now has 10 delinquent accounts. On Tuesday he had the same situation, e.g. he resolved 30 accounts, re-scheduled 10 and 10 scheduled on the following Tuesday. And so he did the rest of the week. So, at the end of Friday he has 50 delinquent accounts.

Now, how is my program supposed to work? How I’m supposed to assign him accounts for the next week?

Thanks a lot in advance for the ideas.