Your safety levels were set last year. Your patients are here today.
We built a simulation: 500-bed hospital, 3,500 drugs, 15 wards, 24 months of data. ฿600M annual drug budget. What the model reveals: ฿73 million per year lost to a problem hiding in plain sight.
The ICU nurse calls the pharmacy. Vancomycin — stat. The system says zero stock. The patient waits.
It's 2:47 AM in a 500-bed Thai hospital. The ICU attending orders IV Vancomycin for a sepsis patient. The nurse walks to the automated dispensing cabinet. Zero units. She calls the central pharmacy. Also zero. The on-call pharmacist initiates an emergency procurement order. The supplier answers at 3:15 AM. The drug arrives at 4:52 AM — two hours after the order, at 2.8x the contract price.
Meanwhile, three floors down, Ward 5's storeroom holds 142 boxes of Metformin 500mg expiring in 38 days. Nobody will use them in time. Ward 7 has been hoarding Omeprazole 20mg — 6 months of safety stock — while Ward 3 ran out yesterday and borrowed from a neighboring hospital.
This is not a story about a bad hospital. This hospital has JCIA accreditation. Its pharmacists are experienced and dedicated. Its procurement team follows MDS-3 guidelines. The problem isn't people. It's the system they're trapped in.
"The problem isn't shortage or surplus. It's that nobody can see both at the same time."
Static inventory management costs this hospital ฿73 million per year across five categories that most administrators never see combined.
| Cost Category | What Happens | Annual Cost | % of ฿600M Budget |
|---|---|---|---|
| Drug Expiry Waste | Drugs expire before use. Destroyed. | ฿30M | 5.0% |
| Emergency Procurement Markup | Stockouts trigger 2am calls. 2.5× contract price. 20/month. | ฿16.2M | 2.7% |
| Safety Stock Carrying Cost | ฿90M in inventory × 25% annual holding cost | ฿22.5M | 3.8% |
| Ward Excess Carrying Cost | ฿18M hoarded in wards × 25% | ฿4.5M | 0.8% |
| Total Direct Cost | ฿73.2M | 12.2% | |
| Pharmacist Time (not in total) | 62% of 8 FTEs on inventory tasks | ฿3.6M opportunity cost | — |
MDS-3 guidelines assume stable demand, predictable lead times, and rational ordering. Hospital reality delivers none of these.
| Factor | MDS-3 Theory | Hospital Reality |
|---|---|---|
| Demand Pattern | Stable, normally distributed | Intermittent, seasonal, ward-dependent |
| Lead Time | Fixed, known in advance | Variable (3–45 days), supplier-dependent |
| Review Frequency | Regular periodic review | Annual budget cycle, rarely updated |
| Data Quality | Complete consumption records | Dispensing data ≠ actual consumption |
| Ward Behavior | Wards order what they need | Wards hoard to protect against stockouts |
| Safety Stock Formula | Z × σd × √LT | Pharmacist judgment + last year's budget |
"Sick inventory management systems generally feature subjective, ad hoc decisions about what to purchase and how much to buy, often based on budgets rather than actual consumption data."
— MDS-3: Managing Access to Medicines and Health Technologies, Ch. 23Most hospitals set safety stock at a single service level (typically 95%) for all drugs. But a 95% service level for Vancomycin is a clinical risk, while 95% for a common vitamin is wasteful overkill. The right Z-value depends on the drug's criticality, not a blanket policy.
Demand variability amplifies 8.8x as it flows from patient to supplier. This is the hospital bullwhip effect.
The amplification ratio — 72.1% / 8.2% = 8.8x — means a modest fluctuation in patient demand becomes a wild swing in supplier orders. Emergency orders spike. Suppliers respond with longer lead times. The hospital responds by ordering even more. The cycle reinforces itself.
| Metric | Current | Conservative | Base | Optimistic |
|---|---|---|---|---|
| Emergency Orders/mo | 20 | 12 | 10 | 8 |
| Vital Stockouts/mo | 12 | 7 | 4 | 3 |
| Drug Expiry Rate | 5.0% | 2.5% | 2.0% | 1.25% |
| Ward Amplification | 7.0× | 4.5× | 3.0× | 2.5× |
Projected improvements based on simulation modeling calibrated to published benchmarks. See Chapters 4–5 for methodology.
"The ward nurse who hoards isn't irrational. She's protecting her patients with the only tool she has: excess stock."
6.4 million records across 5 hospital systems over 24 months. Enough to see the patterns hiding in daily operations.
We built a simulation engine calibrated to Thai hospital benchmarks — MDS-3 standards, MOPH published data, and peer-reviewed studies (Shen et al. 2024, Gudeta et al. 2024). The numbers below represent a typical 500-bed Thai public hospital with a ฿600M annual drug budget.
Your hospital's numbers will be different. That's the point — this is what the analysis looks like. Your data makes it real.
| Data Source | Records | Description |
|---|---|---|
| HIS (Hospital Information System) | 4.2M | Patient encounters, diagnoses, prescriptions |
| Pharmacy Dispensing | 1.8M | Dispensing events, returns, ward transfers |
| Procurement | 340K | Purchase orders, supplier invoices, lead times |
| Patient Admissions | 89K | Admission/discharge events, ward assignments |
| Operating Room | 12K | Surgical drug usage, anesthesia records |
| Total | 6.4M | 24 months of integrated hospital drug data |
Raw hospital data is never analysis-ready. We applied four critical data quality steps:
Identified periods where zero dispensing was caused by stockouts, not zero demand. Cross-referenced with ward requisition denials and emergency orders.
For stockout periods, estimated true demand using Bayesian imputation from historical patterns, ward census, and diagnosis mix.
Mapped batch-level expiry dates against consumption velocity to identify drugs at risk of expiry 30, 60, and 90 days in advance.
Built consumption profiles for each of 15 wards — identifying hoarding patterns, seasonal demand shifts, and inter-ward transfer opportunities.
Data Pipeline Architecture
"Hospital data is abundant but fragmented. The challenge isn't collecting more — it's connecting what already exists."
Quick ROI math, self-assessment questions, and industry benchmarks to see where you stand.
| Category | Conservative | Base | Optimistic |
|---|---|---|---|
| Expiry savings | ฿12.0M | ฿18.0M | ฿31.5M |
| Emergency savings | ฿2.5M | ฿8.1M | ฿19.8M |
| Carrying cost savings | ฿2.2M | ฿4.5M | ฿9.0M |
| Pharmacist productivity | ฿1.7M | ฿2.4M | ฿3.1M |
| Ward efficiency | ฿2.7M | ฿4.2M | ฿5.7M |
| Total annual savings | ฿21.1M | ฿37.3M | ฿69.1M |
| Investment | ฿8.0M | ฿6.0M | ฿5.0M |
| ROI | 2.6× | 6.2× | 13.8× |
| Payback | 5 months | 2 months | 1 month |
Conservative assumes the lowest published improvement rates and highest investment. Optimistic uses rates near published study results. Base is our calibrated estimate. Even the conservative scenario pays back in 5 months.
[M] Published measurement [E] Estimated from benchmarks [C] Calculated
| Metric | Typical Thai Hospital | Good | Best-in-Class |
|---|---|---|---|
| Drug Expiry Rate | 4–7% | 2–3% | <1.5% |
| Vital Stockouts / Month | 8–20 | 3–5 | <2 |
| Emergency Order Rate | 15–30/mo | 5–10/mo | <5/mo |
| Pharmacist Time on Inventory | 55–70% | 30–40% | <20% |
Don't trust our numbers. Use yours.
These are benchmark numbers — not your hospital's numbers. Share your pharmacy data. We'll return a 1-page waste assessment with your actual expiry rate, your emergency cost, and your top problem drugs. Free.
Your numbers might be better than ours. They might be worse. Either way, you'll know.
Get Your AssessmentThe quantitative results in this study are generated from a financial model calibrated to published benchmarks. They represent a typical scenario, not a specific hospital engagement. Actual results depend on your data, systems, and operational context. Contact us for an assessment using your real data.
Sources:
Full methodology and assumptions: available on request.
