Demo Health System

What happened: 366 schedule records (8.5%) do not match between the EHR and Finance system feeds; the most common issue is "missing_in_finance".

Likely driver: Point differences in time, room, and duration between the two systems even though both feeds are current.

Impact: Reconciliation gaps undermine trust in capacity numbers and can double-count or miss visits.

Suggested next action: Resolve time/room mismatches starting with the most common issue, "missing_in_finance".

What happened: Baseline no-show rate is 7.3%, but 3 days spiked as high as 16.5%.

Likely driver: Clustered no-shows, consistent with reminder gaps or external factors (weather, holidays) on specific dates.

Impact: Each no-show leaves a fully-staffed room idle for the scheduled duration, directly lowering utilization.

Suggested next action: Enable targeted reminders for high-risk slots and consider controlled overbooking on historically high-no-show days.

What happened: 20 room blocks removed 1,710 min from bookable capacity.

Likely driver: Maintenance, training, administrative holds, and a few rooms with mapping issues recorded as unmapped blocks.

Impact: Blocked time reduces the available-minutes denominator; avoidable blocks suppress true capacity.

Suggested next action: Audit recurring blocks, consolidate maintenance into low-demand windows, and resolve unmapped rooms.

What happened: Utilization dips at the start and end of the week relative to Tuesday–Thursday.

Likely driver: Synthetic demand seasonality — typical of elective specialty scheduling patterns.

Impact: Predictable weekly troughs leave recoverable capacity on Mondays and Fridays.

Suggested next action: Shift flexible visit types and outreach toward Monday/Friday to smooth the weekly curve.