Analysis: St. Jude Mercy Medical Center

May 2026 · 3 months included

Comparing May 2026 vs Apr 2026

Net Estimated Revenue

$4.28M

+8.4% vs Apr 2026

Gross Charges

$45.05M

+5.1% vs Apr 2026

Billable Rate

92.7%

+1.4% vs Apr 2026

Paid Rate (Billable)

9.5%

+0.4% vs Apr 2026

Billable Charges → Net Estimated Revenue

$4.28M estimated on $41.76M billable charges · 10.2% estimated yield

+5.1%
Billable charges vs Apr 2026

Monthly Revenue Estimation

Engine-estimated revenue vs prior-year baseline

+8.4% MoM

Revenue by EM Level

CPT 99281–99285

Visit volume & charges by acuity level — drives revenue model

99281
142 visits
99282
612 visits
99283
1,840 visits
99284
1,120 visits
99285
488 visits

Revenue by Facility

Stacked by Location

Net estimated revenue split by Facility × Location

Main
Annex
FastTrack

Revenue by Entity Type

May 2026 vs Apr 2026

Net estimated revenue grouped by derived Entity Type

Apr 2026
May 2026

Revenue by Billable Status

May 2026 vs Apr 2026

Derived "Billable Status" column · current vs prior period

Revenue Mix by Fin Class

Net revenue grouped by derived NewFinClass

BCBS
31%
Medicare
22%
Medicaid
18%
United
11%
Aetna
9%
Self-Pay
9%

Strategic Commentary

Projected net revenue of $4.28M exceeds the prior-month baseline by 12.4%, driven by a favorable shift in EM Level mix (99284/99285 share up 4.1pp) at Pflugerville and a 31% reduction in Fin Class mapping errors. Denial risk remains elevated at 8.2%—above the 7.5% target—concentrated in Visit Status inconsistencies (142 events) and unmapped Fin Class rows (98 events). Recommend tightening front-desk Visit Status capture for BCBS and Medicare LocFin segments, which together account for 68% of denial exposure. Clean claim rate of 89.0% is now in the upper quartile vs. peer Altus facilities.

Audit Trail

Excel file imported

Today · 09:12 AM · RCM_dump_May2026.xlsx · 14,802 rows · 49 columns

Schema validated

Today · 09:13 AM · All 49 required columns present

Derived 6 formula columns

Today · 09:13 AM · Billable Status, NewFinClass, LocFinEM, LocFin, New Paid, Paid/Unpaid

S3S engine cleaned 13,991 rows

Today · 09:14 AM · 94.5% auto-resolution