AI Daily Management Brief — 23 Aug
Revenue was ₹2.8L below target (‑9%), driven mainly by Orthopedics OPD, down 18% against the trailing 4‑week average. Bed utilization fell from 71% to 62%. On the positive side, Pharmacy revenue is up 11% and MRI utilization climbed to 82%. Suggested focus: Orthopedics appointment cancellations, referral volume, and weekend OPD staffing.
Revenue & Patient Trend
→ Power BI: line chart, dual‑axis
Revenue (₹L)
Target
Patients (000s)
Management Alerts
→ Power BI: alert cards / DAX rulesCritical
AR >90 days up ₹18L this month — TPA B accounts for the largest share of the increase.
Attention
Bed occupancy down 13pts — Orthopedics ward driving most of the drop over 7 days.
Attention
Radiology utilization at 48% — well below the 70% capacity benchmark for CT/MRI.
Opportunity
Pharmacy revenue +14% with margin holding steady — a candidate for a small stocking increase.
Department Profitability
→ Power BI: matrix + conditional formatting| Department | Revenue | Cost | Profit | Margin | Recommended action |
|---|---|---|---|---|---|
| Cardiology | ₹35L | ₹22L | ₹13L | 37% | Invest more |
| Orthopedics | ₹28L | ₹21L | ₹7L | 25% | Investigate costs |
| General Medicine | ₹18L | ₹16L | ₹2L | 11% | Review viability |
| Radiology | ₹14L | ₹7L | ₹7L | 50% | Marketing opportunity |
Doctor Performance
→ Power BI: table + slicer by doctor| Doctor | OPD | Admits | Revenue | Rev/Pt |
|---|---|---|---|---|
| Dr. A | 842 | 86 | ₹18.4L | ₹2,185 |
| Dr. B | 710 | 72 | ₹21.2L | ₹2,986 |
| Dr. C | 1,120 | 44 | ₹12.5L | ₹1,116 |
Receivables Aging
→ Power BI: stacked barInsurance / TPA Performance
→ Power BI: table + KPI cards| TPA | Claims | Rejection | Avg Days |
|---|---|---|---|
| TPA A | 420 | 5% | 18 |
| TPA B | 350 | 13% | 31 |
| TPA C | 280 | 8% | 24 |