South Texas Behavioral Institute

South Texas Behavioral Institute

San Antonio, TX

Turnaround Command Center • 7+1 Shift Engine (7 Direct / 1 Admin) • CentralReach API Sync

🎯
NEW SHEET BUILT & ACTIVE STXBI Turnaround Target Model

Tab 2: Capacity, Hours & Debt Target ($123,318 Payoff Plan)

Includes FTE Staffing Goals, Revenue Delta to Breakeven, Required Billable Hours, and 12/18/24-Month Payoff Roadmaps.

Weekly Billed Revenue 37% Collected
$9,357/wk
Trapped Cash Gap: -$5,857/wk
Actual Bank Deposits: $3,500/wk
RBT Margin (35h Direct) Per Staff
+$1,460
/wk net profit
Billed (TriWest): $2,472/wk 40h Wage: -$1,012/wk
Generates +$6,328/month profit per RBT!
School-Age Gap Daytime Gap
24.0
hrs/wk unfillable
Daytime Shortfall: -$1,695/wk Fix: 2 Toddlers
Outstanding Slow AR CentralReach
$123,318
total debt owed
Back Payroll: $78,450 | QB Loans: $36k

Financial Trajectory & Profitability Radar

Goal Tracker

Real-time visual benchmarks comparing where STXBI sits today vs. breakeven and week-over-week profit targets.

🟡 STATUS: CLOSE TO BREAKEVEN (Need +$2,200/wk cash to cover debt & payroll)
Monthly Cash In vs. Milestones

Survival to Profit Meter

42% of Goal
Bank Cash: $15,000 Target (18-Mo Payoff): $47,949 / mo
$15.0k
$0 Rent: $4.4k Run-Rate: $41.1k Debt-Free: $47.9k
1. Monthly Run-Rate ($41,098/mo): Needs $9,484/wk Cash
2. 18-Mo Debt Paydown ($47,949/mo): Needs $11,065/wk (161.5 hrs)
3. Full 12-Mo Debt Payoff ($51,375/mo): Needs $11,856/wk (173.1 hrs)
Week-over-Week Trapped Cash

Billed Claims vs. Actual Bank Deposits

Cash Gap: -$5.8k/wk
Week 1 (Oct 10): Billed $9,120 vs. Cash $3,800
Week 2 (Oct 17): Billed $9,357 vs. Cash $3,500
Week 3 Target (Plan 1): Target Billed $9,480 vs. Cash $7,200
Week 4 Goal (Plan 2): Target Billed $10,480 vs. Cash $9,500
Bank Cash Trapped in AR Goal: > $8,300/wk
Team Production Engine

Weekly Billable Hours vs. Target

84% of Auths
Delivered: 127.0 hrs/wk Target: 175.0 hrs/wk
127h Rendered
24h Gap
+24h Goal
Current: 127h ($9.3k) Auths: 151h ($10.6k) Full 5 RBTs: 175h ($12.3k)
• Authorized 1:1 Available: 151.0 hrs/wk
• School Daytime Gap (GiSu, etc.): -24.0 hrs/wk (-$1,695/wk)
• Full 7+1 RBT Target (5 RBTs × 35h): 175.0 hrs/wk (+48h Growth)
Active Production

Billable Hours Completed

⏱️
139.1 hrs this week
Monthly Accumulative: 556.4 hrs / mo
Current: 139.1h Goal: 222.5h (5 RBTs + 2 BCBAs)
Gross Billings

Total Revenue Generated

💵
$9,357 / week
Monthly Accumulative: $37,430 / mo
Baseline: $9.4k Full Capacity: $16.8k/wk
Cash Flow Gap

Bank Cash vs. Billed Gap

🏦
$3,500 deposited/wk
Weekly Cash Gap: -$5,857 / wk
37% Collected AR Backlog: $48,000
Debt Liquidation

Backlog Payoff Horizon

🎯
~6.2 Mos to $0 debt
Total Debt Backlog: $123,318
Free Surplus: +$19.8k/mo
📋

Current Client Caseload & Weekly Revenue Realization

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
💡
Immediate Cash Flow Opportunity: You are leaving $3,412 / week ($14,784 / month) unbilled on existing insurance authorizations already in hand.
💳

Monthly Commitments

$41,098 / mo
Staff Payroll & Wages $28,000 / mo
Facility Rent (7400 Blanco) $4,434 / mo
QuickBooks Loans $5,980 / mo
CentralReach Billing Software $1,104 / mo
SSFCU Commercial Loan $980 / mo
IRS Payment Plan $600 / mo
Weekly Run-Rate Needed: $10,274.50 / wk
🎯

Debt Elimination Waterfall

$123,318 Total
1. Outstanding Payroll (Urgent) $78,450
2. QuickBooks Loans $36,000
3. Outstanding Facility Rent $8,868

Clinic Engine Navigation Shortcuts

Quickly jump into any specific operational or clinical module:

Staff Labor Rates, Unblended Billing & Debt Horizon Engine

Unblended Payer Model

Calculated from STXBI's verified obligations: $41,098/mo hard commitments + $123,318 debt backlog using exact position billing rates (Medicaid $52 / TriWest $70.64 / BCBA $125) and individual employee labor rates.

Debt Backlog: $123,318
1. Monthly Run-Rate
$41,098 / mo

Payroll ($28k) + Rent ($4.4k) + QB Loan ($6k) + CR/SSFCU/IRS.

2. Total Debt Backlog
$123,318

$78.5k Back Payroll + $36k QB Loans + $8.9k Outstanding Rent.

3. 2 BCBAs Revenue Salaried in $28k
+$7,131 / wk

60.0 billable hrs/wk (30h each @ $125 TriWest / $100.40 Medicaid) = +$28,524/mo pure gross margin.

4. 5 Full-Time RBTs
$9,662 / wk

162.5 billable hrs (32.5h direct @ unblended rates: $52 Medicaid / $70.64 TriWest) = $38,646 / mo.

5. Total Clinic Capacity
$16,793 / wk

222.5 hrs/wk = $67,170 / mo (4w) / $72,768 / mo (4.33w). Net Surplus: +$26,072/mo!

BCBA

Active BCBA Contributions to the Plan (2 Analysts Modeled @ 30.0h Direct)

Both BCBAs are already on staff & salaried in the $28,000 monthly payroll ($0 added labor cost).

Combined 2 BCBAs: +60.0 hrs/wk = +$7,131 / wk (+$28,524 / mo)
BCBA 1 (Clinical Lead - TriWest Focus) 30.0 hrs @ $125.00
CPT 97155 Supervision:16.0 hrs/wk ($125/hr)
CPT 97156 Parent Training:6.0 hrs/wk ($125/hr)
CPT 97153 Direct 1:1:8.0 hrs/wk ($125/hr)
Weekly Gross Revenue: +$3,750.00 / wk
Monthly Revenue: $15,000 / mo (4-wk basis)
BCBA 2 (Staff Analyst - TriWest / Medicaid Mix) 30.0 hrs @ $112.70 avg
CPT 97151 Assessments:8.0 hrs/wk ($100.40–$125)
CPT 97155 Protocol Mod:16.0 hrs/wk ($100.40–$125)
CPT 97156 Parent Training:6.0 hrs/wk ($92.04–$125)
Weekly Gross Revenue: +$3,381.00 / wk
Monthly Revenue: $13,524 / mo (up to $15k if TriWest)
Direct Turnaround Impact 100% Margin

Because both BCBAs are already on payroll, this $28,524/month in clinical billing eliminates the cash deficit and shrinks remaining overhead:

• Overhead without BCBAs: $41,098/mo
• Overhead remaining after BCBA billing: ONLY $12,574/mo
• RBT hours needed to break even drops to ONLY ~53.0 hrs/wk!

Interactive Debt Horizon & Position Capacity Modeler

Unblended Rates Active

Calculates exact hours and staffing using distinct position billing rates (Medicaid $52 vs TriWest $70.64 vs BCBA $125).

Dynamic Calculator
Backlog: $123,318
Bi-weekly payroll budget
Unblended
Unblended
32.5h Direct + 7.5h Admin (40h)
30.0h Billable per Analyst
Accelerates Debt Payoff to ~4 - 6 Months!
1. Workforce Composition Goal 5 RBTs + 2 BCBAs
5.0 RBTs + 2 BCBAs

5 FTE RBTs (32.5h direct / 7.5h admin) + 2 Active BCBAs (60h billable).

2. Weekly Billable Hours Goal 222.5h Total
222.5 hrs/wk

Breakdown: 162.5h RBT (73%) + 60.0h BCBA (27%).

3. Weekly Gross Revenue Unblended
$17,162 / wk

Breakdown: RBT: $9.7k/wk + 2 BCBAs: $7.5k/wk.

4. Monthly Revenue Target Target Horizon
$68,649 / mo

Surplus of +$27,551/mo clears debt in ~4.5 Months!

👥

Individual Staff Labor Rates & Position Billing Engine

Person-by-Person Modeler

Adjust each individual employee's hourly wage / salary, paid hours, direct billable time, and unblended payer billing rate to model exact clinical gross profit and margin.

%
Employee Name / Role Assigned Caseload / Primary Payer Billable Time Hourly Bill Rate Paid Hours Labor Rate / Wage Weekly Gross Billing Weekly Loaded Labor Gross Profit Margin Action
FULL CLINIC PRODUCTION (5 RBTs + 2 BCBAs) 222.5 hrs Avg: $75.47/h 260.0 hrs - $16,792.60/wk -$8,560.00/wk +$8,232.60/wk -
1. Clinic Monthly Payroll 5 RBTs + 2 BCBAs
$34,240 / mo

Weekly: $8,560 / wk loaded (Baseline was $28,000/mo).

2. Clinic Monthly Billing Unblended
$67,170 / mo

Weekly: $16,793 / wk across 222.5 billable hours.

3. Non-Payroll Fixed Costs Fixed Overhead
$13,098 / mo

Rent ($4,434) + QB Loans ($5,980) + CR ($1,104) + SSFCU/IRS.

4. Net Free Cash Surplus Active Surplus
+$19,832 / mo

After all payroll + rent + loans. Debt free in ~6.2 Months!

🛡️

2 BCBAs Revenue Power & CPT Code Overlap Compliance Guard

Payer Guardrails Enforced

Rates and strict anti-overlap billing regulations for TriWest vs. Texas Medicaid.

2 BCBAs Production: +$7,131 – $7,500 / week (+$28,524 – $30,000 / month)
CPT 97151 BCBA Only
Behavior Assessment & Plan
TriWest:$125.00 / hr
TX Medicaid:$100.40 / hr
$25.10 / 15-min unit (TMHP)
CPT 97153 RBT / BCBA
1:1 Direct Adaptive Treatment
TriWest:$70.64 / hr
TX Medicaid:$52.00 / hr
BCBA direct can bill at $125 for TriWest
CPT 97155 BCBA Protocol
Protocol Modification / Direction
TriWest:$125.00 / hr
TX Medicaid:$100.40 / hr
🚫 CANNOT overlap with 97153!
CPT 97156 BCBA Parent
Family / Caregiver Guidance
TriWest:$125.00 / hr
TX Medicaid:$92.04 / hr
✅ Overlap OK with modifier
⚠️ Mandatory Regulatory Billing Guardrails:
🚫 1. Strict 97155 & 97153 Non-Overlap Rule

97155 and 97153 CANNOT OVERLAP under any circumstances.

Protocol modification (97155 by BCBA) and direct 1:1 (97153 by RBT or BCBA) must be scheduled sequentially at distinct non-overlapping times. Simultaneous billing is strictly blocked by CentralReach audit flags.

✅ 2. Medicaid Parent Training (97156) Overlap Rules

Medicaid 97156 CAN overlap with treatment IF billed with the modifier indicating the client is NOT present.

• Parent training session cannot exceed 2.0 hours at a time.
• Total daily direct treatment (97153) + protocol direction (97155) + caregiver guidance (97156) cannot push any child's cumulative billing past 8.0 hours (32 units) in a single treatment day.

🪜

The 4-Stage Operational Recovery Roadmap

Clear benchmarks from survival to long-term profitability.

Execution Steps
Stage 1: Breakeven Immediate
$41,098 / mo
Weekly Run-Rate: $10,275 / wk
Required Hours: 105.0 hrs/wk
Covers active monthly commitments (Payroll, Loans, Rent, Software).
Stage 2: Target Paydown 18-Mo Target
$47,949 / mo
Weekly Run-Rate: $11,987 / wk
Required Hours: 135.5 hrs/wk
Covers all commitments + $6,851/mo steady debt backlog liquidation.
Stage 3: Full Team 5+2 Current Team
$67,170 / mo
Weekly Billing: $16,793 / wk
Required Hours: 222.5 hrs/wk
All 5 RBTs @ 32.5h + 2 BCBAs @ 30h. Slashes debt in ~6 Months!
Stage 4: Debt-Free Growth Scaled
$85,000+ / mo
Weekly Billing: $21,250+ / wk
Required Hours: 280+ hrs/wk
$0 debt, full reserve funds, expansion to second facility / school contracts.

Verified Debt Elimination Priority Waterfall ($123,318 Total)

Priority 1: Outstanding Payroll $78,450

Immediate risk of RBT/BCBA resignation. Settle first via AR cash collections.

Priority 2: Outstanding Rent $8,868

2 months unpaid at 7400 Blanco ($4,434/mo). Landlord notice risk.

Priority 3: QuickBooks Loans $36,000

Active commercial debt. Ongoing $5,980/mo payment maintains current standing.