Single master ledger showing target hours, delivered hours, client cancellations, attendance %, remaining hours needed, and weekly gross billing per staff member.
Lost Revenue: -$1,342 / wk
Unlocks +$29,744 / month at full capacity!
Current: 139.1h (+32.4h surplus)
Current: 139.1h (+3.6h surplus)
Need 34.0 more hrs/wk (+$2,364/wk gross)
Need 83.4 more hrs/wk (+$7,436/wk gross)
| Employee Name / Role | Primary Caseload & Payer | Weekly Target | Delivered (This Week) | Cancellations | Hours Needed | Required Daily Pace | Attendance % | Weekly Billed | Pacing Status |
|---|---|---|---|---|---|---|---|---|---|
| CLINICAL TEAM TOTAL PRODUCTION | 222.5h | 139.1h | 19.0h | 83.4h | 41.7h / day | 88.0% | $9,357.48 | 37.5% Deficit | |
Data-driven scheduling algorithms engineered to extract maximum billable revenue from STXBI's 5 RBTs + 2 BCBAs without adding payroll overhead.
TriWest pays +$18.64/hr (+35.8%) more for the exact same direct RBT hour.
School-age clients leave a 19h–24h unfillable morning void (-$1,695/wk dead loss).
Both BCBA salaries are locked into the $28k payroll. Every billable hour generates 100% gross margin!
STXBI already holds 19.0 unrendered approved hours/wk authorized by insurance.
Select a tested turnaround strategy to instantly model hours, revenues, and debt liquidation timeline:
Plugs the 19h auth leak on existing clients + shifts open float slots to TriWest afternoon clients.
Fills open 8:45-11:45 AM & 11:30-2:30 PM windows with 2 early-intervention intakes. Eliminates daytime hole.
5 RBTs @ 32.5h direct + 2 BCBAs @ 30.0h billable. Full fluid stacking with sequential TriWest supervision.
Generates enough net cash surplus to pay off all back payroll ($78.5k), QB loans ($36k), and rent ($8.9k) in under 7 months.
How to assign RBTs and BCBAs throughout Monday–Friday to maximize billable hours and respect daily caps:
• Clients: AdPe, AbPe, Intake Toddler A
• Staff: RBT 1, RBT 2, RBT 5
• Rate: $52.00 – $70.64 / hr
• Clients: Intake Toddler B, OrOr
• Staff: RBT 3, RBT 4 (Float)
• Rate: $52.00 – $70.64 / hr
• Clients: TrAy, AlLl, JeRu, GiSu
• Staff: All 5 RBTs active
• Rate: $70.64 / hr (TRICARE)
• Staff: BCBA 1 & BCBA 2
• Codes: TriWest 97155 & Medicaid 97156
• Rate: $100.40 – $125.00 / hr
Live snapshot of current rendered hours, billing rates, and authorized unbilled capacity.
| Client | Primary Payer | Auth 1:1 | Current Rendered | Unbilled Gap | Weekly Billed | Max Auth Value | Status |
|---|---|---|---|---|---|---|---|
| ACTIVE CLINIC CASELOAD TOTAL | 146.0h | 127.0h | -19.0h | $9,357.48 | $12,769.25 | +$3,412 Leak | |
Jump directly into any of STXBI's 4 core operational engines: