PerformIQ | Executive Command Centre
Predictive Intelligence Active
Last Updated: Today, 18:10 IST
!
Clinical Intelligence Alert
Pediatric ICU occupancy in Tier 1 hospitals projected to exceed 89% over next 14 days. Antibiotic consumption trend indicates possible respiratory seasonal spike. Escalate procurement and staffing now.
Network Financial Overview
Annual Revenue
₹1,550 Cr
FY 2025–26
EBITDA
₹490 Cr
31.6% margin
Monthly Run Rate
₹129 Cr
Total Hospitals
30
Pan-India network
Total Beds
3,200
Bed Occupancy
71%
Monthly Footfall
1,85,000
ICU Occupancy
82%
OT Utilization
76%
Rev / Occupied Bed
₹48,500
Revenue Leakage Risk
₹4.8 Cr
Per month
Consumables Leakage
₹2.1 Cr
Per month
Nursing OT Cost
₹1.4 Cr
Per month
Energy Cost
₹6.2 Cr
Per month
Patient Experience
84 / 100
NABH Compliance
88 / 100
Total EBITDA Protection Opportunity
₹28–36 Cr annually
Revenue leakage · Consumables · Workforce · Energy · Procurement · Clinical efficiency
Hospital Tier Performance Summary
Tier 1 — Metro
5
Hyderabad · Bengaluru · Chennai · Delhi NCR · Mumbai
Occupancy
79%
Revenue Share
58%
EBITDA%
34.2%
ICU Occ.
87%
Tier 2 — Regional
13
Vizag · Vijayawada · Coimbatore · Kochi · Pune + 8 more
Occupancy
68%
Revenue Share
32%
EBITDA%
29.8%
ICU Occ.
76%
Tier 3 — Hub & Spoke
12
Regional pediatric centers · Referral network
Occupancy
61%
Revenue Share
10%
EBITDA%
24.1%
Referral↑
+11%
Patient Flow Forecast — Predictive Models
Current Monthly Footfall
1,85,000
Forecast May-2026
1,87,000
Peak Forecast Month
Oct-2026
Seasonal surge
NICU Admissions / Month
1,840
Emergency Visits / Month
22,400
Referral Intake Rate
+11%
YoY growth
Monthly Patient Footfall — Actual & Forecast
24-month actual + 6-month predictive forecast
Tier-wise Patient Flow Forecast (May–Oct 2026)
MonthTotalTier 1Tier 2Tier 3OPD Est.IP AdmissionsICUNICUEmergency
May-20261,87,00092,00061,00034,0001,41,2008,8201,4801,86022,600
Jun-20261,82,00089,00059,40033,6001,37,6008,5801,4401,82021,800
Jul-20261,78,00087,00058,10032,9001,34,4008,4001,5601,90024,200
Aug-20261,91,00094,00062,00035,0001,44,2009,0201,6402,04026,400
Sep-20261,96,00096,00063,80036,2001,48,0009,2401,7202,12028,800
Oct-20262,04,000100,00066,40037,6001,54,0009,6201,8402,28031,200
Predictive Model Performance
LSTM Neural Network
Forecast Accuracy94.2%
MAPE5.8%
RMSE2,840
Confidence Interval±4.6%
Best performer — recommended for ICU and emergency forecasting
XGBoost Ensemble
Forecast Accuracy93.1%
MAPE6.3%
RMSE3,120
Confidence Interval±5.1%
Best for seasonal demand and pharmacy consumption prediction
Prophet (Meta)
Forecast Accuracy91.4%
MAPE8.2%
RMSE3,680
Confidence Interval±6.8%
Strong for OPD trend forecasting with holiday and seasonal effects
SARIMA
Forecast Accuracy88.7%
MAPE10.4%
RMSE4,210
Confidence Interval±8.4%
Baseline model — used for validation and ensemble weighting
Seasonal Intelligence
Respiratory seasonal surge expected in Tier 1 metro centers during Aug–Oct 2026. Tier 2 hospitals showing 18% increase in neonatal admissions. Tier 3 referral dependency growing by 11% — consider capacity expansion in high-referral zones. ICU demand forecast exceeds current capacity threshold at Hyderabad and Bengaluru by Sep-2026.
Revenue & Revenue Leakage Intelligence
Total Monthly Leakage
₹4.8 Cr
Insurance Delay Leakage
₹1.6 Cr
Unbilled Procedures
₹0.9 Cr
Pharmacy Leakage
₹0.7 Cr
OT Idle Time
₹1.1 Cr
Delayed Discharge Cost
₹0.5 Cr
Payer Mix — Cash
42%
Insurance AR Days
48
Revenue Leakage by Category (₹ Cr/month)
Total: ₹4.8 Cr recoverable
Payer Mix — Revenue Contribution
Insurance · Cash · Government · Corporate
Insurance Authorization Intelligence
InsurerPending Auth.Avg Delay (Hrs)Approval RateRevenue HeldRejection RiskAction
Star Health18618.4 hrs91%₹38.4LMediumEscalate 48hr+ cases
Ayushman / PMJAY24831.2 hrs84%₹62.8LHighDedicated auth team
New India Assurance12414.6 hrs88%₹28.4LMediumMonitor aging
HDFC Ergo969.8 hrs94%₹18.2LLowNormal track
Corporate TPA14212.4 hrs92%₹24.6LLowBatch process
Revenue Intelligence
Insurance authorization delays across Tier 1 hospitals extending average discharge cycle by 7.4 hours. PMJAY/Ayushman cases show highest auth delay risk. Dedicating a 4-person authorization desk per Tier 1 hospital can recover ₹1.2–1.4 Cr/month. Unbilled procedure detection through clinical audit can recover additional ₹0.9 Cr/month.
Consumables Intelligence
Active SKUs
12,400
Expiry Risk Inventory
₹1.8 Cr
Fast Moving SKUs
420
Critical Shortage Risk
18 SKUs
Inventory Holding Days
29
Procurement Saving Opp.
₹2.4 Cr
Slow-Moving Stock
₹3.6 Cr
Supplier Count
284
Top Consumable Categories — Monthly Cost (₹ L)
Network-wide consumption
Inventory Risk Distribution
By expiry and shortage category
Critical SKU Risk Table
SKU CategoryMonthly UsageStock LevelDays CoverExpiry RiskShortage RiskAction
IV Cannula (24G Peds)84,000 units12,4004 daysLowCriticalEmergency PO today
Neonatal ET Tubes2,840 units3804 daysLowCriticalEmergency PO today
Surgical Gloves (Peds)1,42,000 units28,4006 daysLowHighOrder within 24 hrs
Infusion Pumps (Disp.)18,400 units6,20010 daysMediumMediumReorder this week
Phototherapy Covers4,200 units3,80027 daysMediumLowConsume before expiry
Suction Catheters22,400 units18,60025 daysLowLowNormal replenishment
Medicine Demand Prediction
Total Medicine Cost/Month
₹18.4 Cr
High Volatility Drugs
4
Stockout Risk Drugs
3
Procurement Saving Opp.
₹2.8 Cr
Import Dependent Drugs
6
Generic Substitution Opp.
₹1.2 Cr/month
Top 10 Medicine Cost Forecast — Next 3 Months (₹ Lakhs)
Current vs forecast consumption cost
Medicine Intelligence Table
MedicineMonthly UnitsForecast UnitsCost/UnitVolatilitySupplier RiskStockout RiskEBITDA ExposureAction
Ceftriaxone1,82,0002,01,000₹42HighMediumMedium₹0.8 CrForward buy 45 days
Meropenem48,40058,200₹184HighHighHigh₹1.4 CrSecure supply now
Human Albumin8,2009,840₹1,240HighHighMedium₹1.8 CrMulti-source import
Vancomycin24,60028,400₹320MediumMediumMedium₹0.9 CrStagger purchase
Amoxicillin2,84,0003,12,000₹18MediumLowLow₹0.3 CrNormal order
Paracetamol IV4,82,0004,96,000₹28LowLowLow₹0.2 CrStable
Dopamine12,40014,800₹96MediumMediumHigh₹0.6 CrICU critical stock
Midazolam9,80011,200₹148MediumHighMedium₹0.5 CrControlled drug watch
Salbutamol1,24,0001,68,000₹24HighLowMedium₹0.4 CrSeasonal spike prep
Pantoprazole3,64,0003,72,000₹12LowLowLow₹0.1 CrStable
Critical Drug Alert
Meropenem and Human Albumin price volatility projected to increase due to imported API dependency. Salbutamol demand forecasted to spike 35% due to seasonal respiratory surge in Aug–Sep. Secure multi-supplier contracts for these 3 drugs immediately. Combined EBITDA exposure: ₹3.6 Cr.
Resource & Workforce Intelligence
Nursing OT Cost
₹1.4 Cr
Per month
Doctor Utilization
78%
Nurse Utilization
84%
Attrition Risk
12%
Agency Nursing Cost
₹0.9 Cr
Per month
Shift Fatigue Alerts
84
ICU Staffing Risk
Medium
Vacancy Rate
8.4%
Overtime Hours by Department (Monthly)
Network-wide
Workforce Utilization by Hospital Tier
Nurses · Doctors · Support Staff
Workforce Risk
Tier 1 NICU staffing showing elevated overtime risk — 3 hospitals exceeding 180 OT hours/month per unit. Night-shift nursing utilization exceeds threshold in 4 hospitals (Hyderabad, Bengaluru, Chennai, Delhi NCR). Agency cost of ₹0.9 Cr/month can be reduced by 40% through predictive roster optimisation. Attrition risk of 12% requires structured retention programme.
Workforce Risk by Hospital
HospitalTierNurse OT HrsFatigue AlertsVacancy %Agency DependencyAttrition RiskAction
HyderabadT1214 hrs189.2%HighHighUrgent hire — 12 nurses
BengaluruT1188 hrs148.6%MediumMediumRoster optimise
ChennaiT1172 hrs126.8%MediumMediumMonitor night shift
VizagT2124 hrs85.4%LowLowStable
OT / ICU Utilization Intelligence
OT Utilization
76%
ICU Occupancy
82%
NICU Occupancy
88%
Avg Surgery Delay
41 mins
Emergency OT Usage
18%
ICU Turnaround Delay
6.2 hrs
OT Idle Slots / Week
48
PICU vs NICU Ratio
62 : 38
OT Utilization by Hospital — Current Month
% scheduled slots used
ICU / NICU Occupancy Trend (6 months)
Network average
Critical ICU Alert
NICU occupancy at 88% across the network — Hyderabad and Bengaluru NICU units projected to hit 96% capacity by Jun-2026. ICU turnaround delay of 6.2 hours is creating downstream bed crunch. OT delay of 41 minutes is reducing effective OT utilization. Combined revenue impact: ₹2.4 Cr/month in lost capacity.
Surgical Procedure Forecast — Top 6
ProcedureMonthly VolumeForecast+1 MonthAvg DurationOT RevenueDelay RiskCapacity Status
Neonatal Surgery2843182.8 hrs₹2.4 CrHighAt Capacity
Paediatric Cardiac1481624.4 hrs₹3.1 CrMediumNear Full
Laparoscopic Peds3864021.6 hrs₹1.9 CrLowAvailable
LSCS / Obstetrics6426881.4 hrs₹2.8 CrMediumNear Full
Orthopaedic Peds2242362.2 hrs₹1.4 CrLowAvailable
Marketing & Growth Intelligence
Monthly Leads
14,800
Conversion Rate
21%
Referral Share
42%
Digital Acq. Cost
₹1,480
Per patient
Occupancy Growth Pot.
+6%
Brand NPS
68
Google Rating (Avg)
4.4 / 5
Marketing Spend / Month
₹4.2 Cr
Lead Source Distribution
Monthly acquisition channel mix
Occupancy Growth by Tier — 6 Month Forecast
% bed occupancy trend
Growth Intelligence
Doctor referral network (42% share) remains the highest-quality lead source with lowest acquisition cost (₹480/patient). Digital channels growing but cost at ₹1,480/patient requires optimisation. Specialty-specific campaigns for NICU and paediatric cardiac surgery can drive 8–10% occupancy uplift in Tier 2 hospitals. Tier 3 referral growth of 11% needs structured hub-and-spoke incentive programme.
Patient CX Intelligence
NPS Score
68
Patient Satisfaction
84%
Avg OPD Wait Time
32 mins
Complaint Closure SLA
89%
Discharge Experience
81%
Repeat Visit Rate
64%
Escalated Complaints
48
This month
App Rating
4.3 / 5
Satisfaction Score by Hospital Tier
OPD · IP · Emergency · Discharge
Complaint Category Distribution
Top complaint types — this month
CX Intelligence
Discharge process is the weakest CX touchpoint (81%) — primarily driven by billing wait times and insurance authorization delays adding 7.4 hours to average discharge. OPD wait time of 32 minutes exceeds target of 20 minutes in Tier 1 hospitals. Predictive appointment scheduling can reduce wait time to under 18 minutes and improve NPS by 8–12 points.
NABH / JCI Quality Intelligence
NABH Compliance
88 / 100
JCI Readiness
81 / 100
Open CAPA Actions
126
Infection Control Score
92%
Medication Errors
11
This month
Critical Audit Risk Areas
4
Documentation Gaps
284
HAI Rate
0.8%
Below 1% target
NABH Compliance by Chapter
Score out of 100 per chapter
CAPA Action Status
126 total open actions
Quality AreaScoreOpen CAPAsStatusJCI ImpactDue DateAction
Medication Management82/10028At RiskHigh25 MayUrgent remediation
Infection Control92/1008CompliantLow15 JunMaintain
Patient Rights88/10014CompliantMedium31 MayDocumentation update
Clinical Outcomes76/10042Non-CompliantCritical20 MayImmediate action
Facility Management84/10018ReviewMedium30 MaySafety walk required
Staff Qualifications91/1006CompliantLow30 JunTraining update
Energy & Utility Intelligence
Monthly Energy Cost
₹6.2 Cr
Energy Cost / Bed / Month
₹19,400
HVAC Energy Share
41%
Generator Diesel Cost
₹1.1 Cr
Per month
Water Usage / Bed / Day
1,240 L
Energy Leakage Opp.
₹1.8 Cr
Annually recoverable
Solar Coverage
12%
Expansion opportunity
Peak Demand Penalty
₹0.48 Cr
Energy Cost by Source (%)
Monthly distribution
Energy Cost per Bed — By Hospital Tier (₹/month)
Network comparison
Energy Optimisation Opportunity
₹1.8 Cr annual energy savings recoverable through: HVAC scheduling optimisation in low-occupancy wards (₹0.6 Cr) · Solar panel expansion from 12% to 28% coverage (₹0.5 Cr) · Peak demand load shifting to off-peak tariff windows (₹0.4 Cr) · DG diesel reduction through UPS upgrade (₹0.3 Cr). HVAC alone accounts for 41% of energy cost — highest impact intervention.
Predictive EHS Management
Daily Movement Events
12,400
High-Risk Zones
7
Near Miss Events
18
This month
Bio-Medical Waste Compl.
91%
Elevator Congestion
Medium
Fire Readiness Score
89%
Ambulance Turnaround
14.2 mins
Visitor Congestion Risk
Medium
EHS Alert
ICU transfer congestion between Emergency and PICU during evening hours (18:00–21:00) increasing patient movement delay risk by 24%. Pharmacy-to-ward medication cart routes intersecting with ICU transfer corridors in 3 Tier 1 hospitals. Bio-medical waste segregation compliance at 91% — needs improvement in 4 Tier 2 locations before next inspection.
Risk Zone Intelligence
ZoneHospital TypePeak Risk HoursMovement TypeNear MissesRisk ScoreAction
Emergency → PICU TransferT118:00–21:00Patient transfer691Dedicated transfer lane
ICU Medication CorridorT108:00–10:00Pharmacy cart478Reroute pharmacy carts
NICU Entry ZoneT1All hoursVisitor + staff374Strict visitor protocol
Ambulance BayT220:00–23:00Emergency inbound368Traffic coordinator
Bio-Medical Waste RouteT307:00–09:00Waste transport254Compliance audit
New Projects & Expansion Intelligence
Capex Pipeline
₹420 Cr
New Beds Planned
620
Projects Under Execution
4
Avg Payback Period
4.2 yrs
Ramp-up Time (Est.)
18–24 mos
Projected Revenue (New)
₹180 Cr
At full occupancy
Project Pipeline
ProjectCity / TierBedsCapexStatusCompletionForecast OccupancyPaybackIRR
New Tower — HyderabadT1180₹128 CrConstructionDec-202674% yr23.8 yrs26%
Greenfield — IndoreT2120₹86 CrFoundationJun-202758% yr24.6 yrs21%
Expansion — PuneT280₹54 CrInteriorSep-202668% yr14.1 yrs23%
Greenfield — BhubaneswarT2/3100₹72 CrPlanningMar-202852% yr25.1 yrs18%
Hub Upgrade — VizagT2140₹80 CrCivil WorksFeb-202771% yr24.0 yrs24%
Expansion Intelligence
Hyderabad new tower has highest IRR (26%) due to existing brand strength and NICU demand overflow. Pune expansion delivers fastest ramp-up at 68% occupancy in Year 1 — recommend accelerating timeline. Indore and Bhubaneswar greenfield projects should integrate hub-and-spoke referral model from day 1 to accelerate occupancy. Total incremental revenue potential at full occupancy: ₹180 Cr.
CFO Financial Intelligence
EBITDA Margin
31.6%
Annual EBITDA
₹490 Cr
AR Days
48
Target: 32 days
Working Capital Stress
Medium
Procurement Saving Opp.
₹8.4 Cr
Cost per Patient
₹4,840
ROCE
18.4%
Debt / EBITDA
1.8x
EBITDA Trend — Monthly (₹ Cr)
Last 12 months
Cost Structure Breakdown
% of total operating cost
AR Aging Analysis
Aging BucketAmount (₹ Cr)% of ARRecovery RiskPrimary PayerAction
0–30 Days₹48.2 Cr38%LowCash + CorporateNormal collection
31–60 Days₹34.6 Cr27%MediumStar Health + HDFCFollow-up this week
61–90 Days₹22.8 Cr18%MediumPMJAY + GovernmentEscalate to TPA
91–180 Days₹14.4 Cr11%HighPMJAY / Govt schemeLegal notice / review
180+ Days₹7.6 Cr6%Bad Debt RiskMixedWrite-off analysis
CFO Intelligence
AR days at 48 vs target of 32 represents ₹22–28 Cr of trapped working capital. Reducing AR days to 36 can free ₹16 Cr cash immediately. Procurement centralisation across 30 hospitals can deliver ₹8.4 Cr annual savings. Insurance mix optimisation (reducing PMJAY share from 31% to 24%) can improve cash collection by 18 days.
CEO Strategic Risk Dashboard
Critical Risks
3
High Risks
5
Total Exposure
₹84 Cr
Actionable This Month
6
🔴 CRITICAL — ICU / NICU Capacity Breach88% Probability
Patient overflow + reputation
₹18 Cr
Jun–Sep 2026
CEO Decision
Accelerate Hyderabad tower completion timeline by 8 weeks. Activate transfer protocol with partner hospitals. Add 24 NICU beds across Bengaluru and Chennai on modular basis immediately.
🔴 CRITICAL — Clinical Nursing Shortage74% Probability
Care quality + OT delays
₹12 Cr
12% attrition + 8.4% vacancy
CEO Decision
Approve structured nursing retention programme with 12% pay revision and career pathway. Partner with 3 nursing colleges for dedicated pipeline. Reduce agency dependency by ₹0.6 Cr/month through intern integration.
🟡 HIGH — Medicine Inflation Risk71% Probability
Cost per patient increase
₹8.4 Cr
Import API + USD/INR
CEO Decision
Lock 90-day supply contracts for Meropenem, Human Albumin, and Vancomycin. Approve 8% formulary review to improve generic substitution rate. Centralise procurement across all 30 hospitals to leverage ₹8.4 Cr negotiation power.
🟡 HIGH — Insurance Authorization & AR Risk68% Probability
Working capital + CX
₹22 Cr AR trapped
PMJAY delay + TPA process
CEO Decision
Deploy dedicated authorization teams at all 5 Tier 1 hospitals. Implement pre-authorization workflow for elective procedures. Target AR days reduction from 48 to 36 within 90 days to free ₹16 Cr working capital.
🟡 JCI Compliance Gap62%
₹6 Cr
81/100
Action
Close 42 Clinical Outcomes CAPAs before Aug-2026 JCI review window.
🔵 Expansion Execution Risk58%
₹420 Cr
4 active
Action
Monthly capex review cadence. Prioritise Hyderabad and Pune — highest IRR projects.
PerformIQ Strategic Intelligence
PerformIQ helps R Children's Hospital leadership predict patient demand, optimise resources, reduce revenue leakage, improve clinical operations, control consumables, strengthen quality compliance, and protect EBITDA before operational inefficiencies impact care delivery. Total addressable EBITDA protection: ₹28–36 Cr annually.