An ABA capacity planning calculator should find the smallest usable capacity across clinically planned demand, verified authorization limits, eligible staff time, calendar fit, supervisor workload, and facilities. It should then reduce scheduled hours by expected cancellations and uncovered absences. Count travel, documentation, meetings, training, supervision, and operating buffer before adding clients, and keep every assumption traceable to a source and effective date.

Use five linked worksheets

The SBA Business Guide provides planning and management resources for businesses. For this calculator, build five worksheet tabs named Demand, Staff, BCBA workload, Calendar and rooms, and Outputs. Use hours for the planning period throughout. Preserve payer units in a separate field and convert them only with a verified payer rule.

Demand inputs

Create one row per client and service configuration. A client with two services, settings, or payer rules needs two rows.

InputDefinition
Planning IDInternal pseudonymous identifier
Clinical hoursHours the responsible clinician currently plans for the period
Remaining authorized hoursApproved quantity remaining after a verified unit conversion
Planning periods leftSame-sized planning periods remaining before the authorization ends
Verified current-period authorization ceilingMaximum amount permitted after applying remaining quantity, dates, service or code, frequency, provider, setting, location, and other governing terms
Availability windowsUsable start and end times by day and setting
ConfigurationService, staff role, payer, location, language, competency, and safety needs
Expected client lossHistorical unrecovered cancellation rate for the matching cohort
BCBA case workForecast assessment, analysis, treatment planning, caregiver work, coordination, and review time

Calculate the monitoring reference internal pacing target = remaining authorized hours ÷ remaining same-sized planning periods. Keep that reference separate from the verified current-period authorization ceiling. Then calculate authorization-feasible demand = MIN(clinical hours, verified current-period authorization ceiling), authorization gap = MAX(0, clinical hours - verified current-period authorization ceiling), and pacing variance = clinical hours - internal pacing target. An approval defines an administrative boundary. It does not prescribe dosage or establish staff capacity.

The CMS Prior Authorization API FAQ describes an API and decision-response requirements for impacted payers. It supplies administrative context for prior authorization data. It supplies no clinical staffing rule, caseload ratio, or instruction to schedule every approved unit.

Staff supply inputs

Create one base row per worker so the paid-hour pool appears once. Link that row to a configuration eligibility matrix with one record for each materially different service, payer, setting, location, language, competency, and safety combination. Set an eligibility gate to 0 until current evidence supports the assignment and its effective date.

InputScopeDefinition
Eligibility gateConfiguration1 only when role, certification or license, competence, credentialing or enrollment, location, and effective date support the assignment; otherwise 0
Gross paid hoursWorkerScheduled paid hours in the planning period before approved leave
Approved leaveWorkerPaid hours removed for known leave
Documentation hoursWorkerSession notes, corrections, data review, and other required records
Travel hoursWorkerCompensable travel forecast under applicable law and policy
Paid meetings and trainingWorkerRequired onboarding, competency, clinical, safety, and operating time
Nonoverlap supervisionWorkerRBT supervision time that occurs outside concurrent service delivery
Other paid nonservice timeWorkerPaid breaks, setup, coordination, and assigned administrative work
Operating bufferWorkerReserved hours for variability, incidents, and work that the forecast missed
Expected staff lossCohortHistorical uncovered absence rate for comparable eligible workers and periods

Calculate each unique worker's direct-hour pool once:

worker direct-hour pool = MAX(0, gross paid hours - approved leave - documentation - travel - paid meetings and training - nonoverlap supervision - other paid nonservice - operating buffer)

Allocate that pool only to configurations whose eligibility gate equals 1. Across configurations, allocated hours for one worker cannot exceed that worker's pool. Then calculate eligible staff supply = SUM(allocated hours from unique worker pools).

An observed RBT session may use RBT direct-service time and supervisor time concurrently. Count that hour once in the RBT service supply and once in the BCBA workload. Subtract it from RBT supply only when the RBT stops service delivery.

BCBA, calendar, room, and safety inputs

BCBA capacity needs a work forecast, not a clients-per-BCBA constant:

available BCBA case-work hours = MAX(0, gross paid hours - approved leave - organization work - noncase training and meetings - paid breaks - other noncase paid time - operating buffer)

required BCBA hours = SUM(client-specific clinical work + related documentation + client/site travel) + RBT supervision labor not already included + assessments or starts outside active case forecasts

Count every activity once. A practice may place case-specific travel and documentation in required case work or deduct them from available hours, provided it uses one method consistently.

The BCBA gate passes only when required hours fit, every case has an accountable qualified clinician, the supervisor has sufficient client-specific knowledge, and the supervisor accepts the volume. Convert a passing roster to BCBA-supported direct hours by summing the authorization-feasible direct demand attached to that roster.

Calculate calendar-fit hours by assigning actual client windows to eligible workers, travel routes, breaks, rooms, and supervision events. Summed availability can overstate capacity because two clients may need the same scarce slot. Use calendar-fit hours = SUM(duration of feasible assigned slots) after conflict checks.

For facilities, use usable room hours = staffed open room hours - known closures - safety buffer hours. Set the buffer from documented operating risk. A safety staffing or room gate blocks the affected slot even when a room appears open. OSHA hazard-identification guidance supports reviewing hazards, incidents, emergencies, and nonroutine work. The chosen buffer is an internal planning control and creates no regulatory safe harbor.

Calculate the outputs in order

Keep each layer separate so one strong number cannot hide another constraint.

OutputFormula
Clinically planned demandSUM(clinical hours)
Authorization-feasible demandSUM(authorization-feasible demand)
Eligible staff supplySUM(allocated hours from unique worker pools) across valid configurations
Sustainable scheduled hoursMIN(authorization-feasible demand, eligible staff supply, calendar-fit hours, usable room hours, BCBA-supported direct hours)
Expected delivered hoursscheduled hours × (1 - client loss rate) × (1 - staff loss rate conditional on the client not cancelling)
Clinical capacity gapMAX(0, clinically planned demand - scheduled hours)
Fully feasible clientsCount unique Planning IDs whose hard gates pass and whose service rows together meet the current clinical plan
New-start capacityCount unique prospective Planning IDs that still pass after the current roster and downside case are loaded

Run the final minimum separately for each service and setting pool, then aggregate the results. Omit the room constraint for home and community pools. If client and staff rates use the same scheduled-hour denominator and reason categories are mutually exclusive, subtract their sum. If events can overlap, use a deduplicated combined loss outcome or estimate the union rather than multiplying marginal rates without an independence assumption. Report scheduled supply and expected delivery as different outputs. Cancellation losses can reduce delivered service while still consuming paid staff time, so add unused hours back to supply only when an actual recovery process makes them schedulable.

Reserve RBT supervision precisely

The June 2026 BACB RBT Handbook requires an RBT to receive ongoing supervision equal to at least 5% of the hours spent providing behavior-analytic services in each calendar month. It also requires at least two face-to-face, real-time contacts that month. At least one monthly contact must include direct observation of the RBT providing services, and at least one of the two contacts must be individual. Internet-based supervision must meet applicable law, and passive video monitoring alone may fail to count.

For planning, calculate RBT supervision floor = 5% × all monthly hours the RBT spends providing behavior-analytic services at that organization, then reconcile the required floor to actual service hours at month close. Classify documentation, data work, client-specific training, competency work, and other paid activities against the current Handbook definition. Direct-service hours alone are insufficient when the RBT performs other behavior-analytic services. Maintain contact, observation, individual-session, client-focus, supervisor-qualification, organization, and documentation gates separately. Apply the requirements independently at each organization where the RBT provides behavior-analytic services. Professional development and ongoing supervision are separate requirements in the Handbook.

The 5% floor is not a universal caseload ratio or proof of sufficient clinical oversight. State, payer, employer, client, competence, risk, and service needs may require more. Section 4.03 of the BACB Ethics Code for Behavior Analysts says behavior analysts accept only a supervisee or trainee volume that permits effective supervision and training. They consider client demands, supervisee or trainee caseload, time, and logistical resources, reassess volume, and document and communicate when they reach their effective threshold.

Count paid travel, meetings, and training

Every capacity model should account for time unavailable for service. For employees subject to FLSA hours-worked rules, compensable-time inputs must also reconcile to timekeeping and payroll. Classification, exemptions, and additional state or local requirements require qualified review. The U.S. Department of Labor's Fact Sheet 22 states that travel from job site to job site during the workday is work time under the FLSA. Ordinary home-to-work travel is generally outside work time. Lectures, meetings, and training may be excluded from working time only when all four federal criteria are satisfied: outside normal hours, voluntary, unrelated to the job, and no productive work performed.

Check a fictional monthly scenario

Clearwater Behavior Services is fictional. Its 20-service-day month has 12 center-based clients, two eligible RBTs, one BCBA, and two staffed rooms. Every amount below is synthetic.

Demand layerChecked calculationHours
Clinical plan12 clients × 20 hours240.0
Verified current-period authorization ceilings8 × 20 + 4 × 16224.0
Authorization gap240 - 22416.0
Calendar fit after window matchingFeasible assigned slots210.0
Room supply before buffer2 rooms × 6 hours × 20 days240.0
Usable rooms240 - 24 safety-buffer hours216.0

Each RBT has 160 gross paid hours and no approved leave. The copy-ready staff row is 160 - 16 documentation - 12 travel - 8 meetings/training - 1 separate supervision - 9 other paid time - 10 buffer = 104 direct hours. Two RBTs provide 104 × 2 = 208 eligible direct hours.

All 16 documentation hours in this fictional scenario are session-note and data work that qualify as behavior-analytic services. Each RBT therefore has a 120-hour denominator: 104 direct + 16 documentation = 120. The minimum supervision is 120 × 5% = 6.0 hours. The schedule provides 5.0 hours of qualifying concurrent, face-to-face, real-time observed supervision across two contacts plus one separate 1.0-hour individual, face-to-face, real-time, client-focused contact. Each RBT receives 6.0 hours, and the BCBA supplies 6.0 × 2 = 12.0 hours of supervision labor.

The center-only BCBA has 160 gross - 8 approved leave - 12 organization work - 6 noncase training and meetings - 5 paid-break hours - 10 buffer = 119 available case-work hours. The model has no BCBA travel or other noncase paid time. The 96 client-specific case-work hours already include related documentation. Required BCBA time is 96 + 12 = 108 hours, leaving 119 - 108 = 11 hours. The current 12-client roster passes the BCBA workload gate and supports all 224 authorization-feasible direct-demand hours.

For the current month, the practice has verified that 8 client-configuration rows permit up to 20 hours and 4 permit up to 16 after remaining quantity, effective dates, service, frequency, provider, setting, and location terms are applied. Final scheduled capacity is MIN(224 authorization-feasible, 208 RBT, 210 calendar, 216 rooms, 224 BCBA-supported) = 208 hours. The practice has a 240 - 208 = 32-hour clinical capacity gap and zero new-start capacity. Eight clients can receive their 20 planned hours; four receive 12 scheduled hours each in this allocation: 8 × 20 + 4 × 12 = 208. The fully feasible-client count is 8 unique Planning IDs.

With an 8% unrecovered client cancellation rate and a 3% uncovered staff-absence rate conditional on the client not cancelling, expected delivery is 208 × 0.92 × 0.97 = 185.6192, rounded to 185.6 hours. Expected delivery rate is 185.6192 ÷ 208 = 89.24%.

Run sensitivities and apply decision rules

CaseBinding inputsScheduledExpected deliveredDecision signal
BaseRBT 208; calendar 210208185.6RBT time binds
Client loss rises to 14%Same supply; 208 × .86 × .97208173.5Investigate causes and access barriers
Routing saves 8 travel hoursRBT 216; calendar 210210187.4Calendar fit binds
Add one equally available eligible RBTRBT 312; calendar 210210187.4Headcount adds two scheduled hours
Second RBT loses eligibilityRBT 10410492.8Hold affected assignments immediately
Add RBT and expand fit to 224Rooms 216216192.8Facility supply binds

Use these release rules:

  1. A failed eligibility, authorization, safety, supervisor, or location gate blocks the affected configuration.
  2. A clinical plan above the internal pacing target remains visible for clinical and utilization review. It becomes an authorization gap only when it exceeds a verified current-period authorization ceiling.
  3. New starts require a feasible client-level schedule in the base and approved downside case.
  4. BCBA volume closes when forecast work exceeds available hours or the accountable supervisor judges effective oversight infeasible.
  5. Hiring becomes a candidate action after travel, calendar fit, credentialing lead time, cancellations, rooms, and BCBA workload are tested.
  6. Reforecast after a new authorization, clinical change, hire, credential effective date, leave, room change, or sustained variance.

Protect the calculator's data

Use pseudonymous planning IDs and keep diagnoses, goals, notes, and family narratives in the restricted clinical record. A pseudonymous ID does not by itself de-identify PHI. If the planning table can be linked back to a client or otherwise identifies the client, treat it as PHI and apply the relevant Privacy and Security Rule controls. HHS explains the two HIPAA de-identification methods and their limits in its de-identification guidance. Give each input an owner, source, effective date, refresh cadence, and change history. Limit exports, small-cell reporting, and access to workforce details. When HIPAA applies, HHS describes minimum-necessary controls for covered-entity uses, disclosures, and requests, subject to stated exceptions. Any system holding ePHI belongs in the organization's documented Security Rule risk analysis.

Validate aggregate rates before use. State the numerator, denominator, period, exclusions, sample size, and reason-code logic. Small cohorts and stale averages can create false precision. Use synthetic data for demonstrations and approved, access-controlled first-party data for operations.

Related resources

Sources