Period:
Centre:
Department:
Insurance:
Total Patients MTD
28,441
↑ 12.4% vs prior
Revenue MTD
₹18.4Cr
↑ 14.8% vs prior
Collection Rate
84.2%
↑ 2.1pp vs target
Bed Occupancy
82.4%
Target: 88% — gap
Cancellations
2,184
7.7% cancel rate ↑
Avg Revenue / Patient
₹6,470
↑ ₹320 vs prior
CSAT Score
4.4/5
↑ 0.2 vs last month
Net Margin
18.2%
↑ 1.4pp vs prior
Monthly Revenue vs Cost
6M Trend
Patient Visit Status
Revenue by Department
Patient Source
Insurance vs Self-Pay
OPD Visits
21,840
76.8% of all visits
IPD Admissions
4,284
↑ 8.2%
Emergency Cases
2,317
8.1% of visits
Avg Wait Time
24 min
↑ 4 min vs target
No-Shows
1,842
6.5% rate — ↑
Avg LOS (IPD)
3.8 days
↓ 0.4 days vs prior
Daily Patient Volume — 30 Days
Patient Age & Gender Distribution
Cancellation Reasons
Hourly OPD Flow
Active Departments
14
Across 5 centres
Top Dept Revenue
₹4.82Cr
Cardiology · MTD
Below Target Depts
3
Ortho, Neuro, Peds
Highest Margin Dept
32.4%
Oncology
Revenue by Department
Department P&L Matrix
| Department | Patients | Revenue | Cost | Margin | Avg Rev/Pat | Status |
|---|
Tests Processed
84,280
↑ 11.2% vs prior
Diagnostic Revenue
₹6.84Cr
37.2% of total revenue
TAT Compliance
91.4%
↑ 2.8pp
Critical Alerts
284
↑ 18 vs last week
Sample Rejection Rate
2.4%
Target: 1.5%
Avg TAT
4.2 hrs
↓ 0.6 hrs vs prior
Top 10 Tests by Volume
Diagnostic Revenue Breakdown
Lab Performance by Centre
| Centre | Tests | Revenue | TAT% | Rejection% | Critical | Avg TAT | Status |
|---|
Gross Revenue
₹18.4Cr
↑ 14.8%
Total Costs
₹15.1Cr
↑ 9.2% vs plan
Net Profit
₹3.35Cr
18.2% margin
EBITDA
₹4.20Cr
22.8% EBITDA margin
Staff Costs
₹6.84Cr
37.2% of revenue
Uncollected
₹2.92Cr
15.8% — bad debt risk
P&L Waterfall
Cost Structure
Revenue by Centre
Payer Mix & Collections
Active Doctors
184
Across 14 departments
Top Doctor Revenue
₹1.84Cr
Dr. Sharma · Cardiology
Below Target
24
13% of team
Avg CSAT
4.4★
↑ 0.2 vs prior
Doctor Revenue — Top 15
Performance Overview
Top 5 Performers
Doctor Leaderboard
| # | Doctor | Dept | Centre | Patients | Revenue | CSAT | OPD% | Avg Rev/Pat | Band |
|---|
Bed Occupancy
82.4%
Target: 88%
Surgical Success Rate
98.7%
↑ 0.3pp vs prior
Readmission Rate
4.2%
↑ 0.8pp — review
Staff:Patient Ratio
1:4.2
Target: 1:4.0
CSAT Score
4.4/5
↑ 0.2 this month
Infection Rate
0.8%
↓ 0.2pp — improving
Bed Occupancy by Dept
Quality KPI Tracker
Compare:
vs
Centre Performance Chart
All Centres — Full Table
| Centre | Patients | Revenue | Margin | Occupancy | CSAT | Status |
|---|
Compare by:
A:
vs B:
Head-to-Head Chart
🔴 Clinical & Critical
🟡 Operational Warnings
📋 Management Actions
✅ Positive Signals