Counselor Caseload Tools
A counselor carrying two hundred cases cannot give equal attention to all of them, and the regulatory clocks do not pause while the queue grows. These tools rank the caseload by which cases are closest to a missed deadline and estimate the direct service hours the month actually requires.
The practice problem
Federal rule sets two hard clocks on the front of a VR case. Eligibility must be determined within 60 days of application unless exceptional circumstances beyond the agency's control apply and the applicant agrees to an extension 34 CFR 361.41(b)(1). The individualized plan for employment must then be developed within 90 days of the eligibility determination, again absent an agreed extension 34 CFR 361.45(e). Neither clock is sensitive to how many other cases the counselor is carrying.
What follows is a queueing problem rather than a motivation problem. Cases in different statuses need contact at different intervals, and a case that has gone quiet in plan development carries more regulatory exposure than one that has gone quiet after successful closure. Most case management systems sort by last name or by open date, which buries the exposed cases. The model below ranks statuses by how far past their contact standard they have drifted, converts the caseload into required direct service hours, and states the counselor capacity that implies.
Enter the caseload, how long since the average case was last contacted, and the share of cases sitting in each IPE status. The model returns a prioritized contact queue, the cases at risk of an untimely determination or closure, and the direct service hours the month requires.