>Joe cannot work beyond his capacity:)
>
>What does delinquent mean?

I think, it means, that the user didn't work them on the day they were scheduled to be resolved.

>
>Are they delinquent if he reassigns them (within his overflow limit) to another day?
>
If it's a future day, they are not considered delinquent. E.g. he may want to follow up these accounts in two weeks. They are not then in his daily queue. But my program should calculate how many accounts he already have scheduled on that particular day and don't add more records.

Right now I implemented this algorithm:
nAccountsToAssign = iRegular_Count_Limit - NumberOfAlreadyScheduledForThatDay

Obviously I'm not considering delinquent, because I wanted to write a procedure, then try to make it more complex.

>
>Delinquent accounts would need to be redistributed for resolution.
>Two ways to do this:
>1) Reduce the number of incoming counts to assure redistributed accounts are being handled in a timely fashion.

I think, once the accounts are assigned, they should not be re-assigned to another user. So, Joe has to somehow catch up. There is a temporary transfer allowed, but total re-assignment is a rare case.

>2) Increase the work load for account managers.
>
>Is the project scheduling capacity (accounts/day/worker) or is it reporting delinquent accounts and poor production.
>
>Are accounts priority rated?
>

I guess they are, but this is not yet implemented. We have "Forced" queue, so manager can define which accounts the user has to work first in addition to the daily queue.

>I thought you were in Ohio?:-)

I were :) Not anymore for 3 months already...
>
>
>>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.