Client Background
The owner operated a 7-location pharmacy chain in Surabaya and surrounding areas, serving patients with 4,200+ SKUs including prescription drugs, OTC medications, and health products. Despite strong revenue (Rp 36 billion annually), the business faced critical inventory challenges unique to pharmacy operations.
The Problem
Expired Stock Crisis:
Monthly write-offs: Rp 15-18 million
Annual expired stock: Rp 180-216 million (5-6% of COGS)
Each product unit has different expiry dates (batch-specific)
Newest stock often dispensed first, leaving old stock to expire
No systematic tracking across 7 locations and 4,200+ SKUs
Additional Challenges:
Essential medications out of stock 15-20% of the time
Rp 2.8 billion tied up in inventory (much approaching expiry)
No visibility into stock at other locations
Pharmacists spending 6-8 hours weekly on manual inventory counts
The Breaking Point: One month revealed Rp 24 million in expired stock, including Rp 6 million of a single antibiotic over-ordered 18 months prior.
The Solution
Implemented a pharmacy-specific inventory management system designed for healthcare retail's unique requirements:
Core Capabilities:
Expiry Management: Batch-level tracking with automated alerts at 90, 60, 30 days before expiry
FEFO Enforcement: System automatically selects oldest batch when dispensing
Smart Reordering: Demand-based forecasting with automatic purchase order generation
Inter-Location Optimization: Real-time visibility and stock transfer recommendations across all locations
Regulatory Compliance: Controlled substance tracking, temperature monitoring, recall management
Implementation Approach:
Months 1-2: Complete inventory audit, record all batch numbers and expiry dates, system setup and training
Month 3: Pilot at best-performing location with parallel operation
Month 4: Sequential rollout to remaining locations
Month 5: Optimization and process refinement
The Results
Expired Stock Reduction (Primary Goal)
Monthly expired stock: Rp 15-18M → Rp 900K average (-94%)
Annual savings: Rp 169 million from prevented expirations
How: System alerts products 90 days before expiry, enabling proactive action (promotion to doctors, transfers to higher-volume locations, small discounts). FEFO enforcement prevents "back of shelf" expirations.
Stockout Reduction
Stockout rate: 15-20% → 2-3% (-88%)
Customer complaints: 40-50 monthly → 5-8 monthly
How: Demand-based reorder points and inter-location stock balancing. When one location runs low, the system checks if others have excess for same-day transfer.
Cash Flow Improvement
Inventory investment: Rp 2.8B → Rp 1.9B
Released: Rp 900 million in working capital
Inventory turnover: 4.2x → 7.1x annually (+69%)
Operational Efficiency
Weekly inventory count time: 6-8 hours → 1.5 hours
Ordering process: 3-4 hours → 30 minutes weekly
Inventory record accuracy: 78% → 98%
Pharmacist time reallocated to patient counseling: 20+ hours weekly per location
Customer & Compliance
Patient satisfaction: 3.9 → 4.5 (out of 5)
Repeat prescription fill rate: +31%
Regulatory compliance: 100% (automated audit trails)
Key Examples
Preventing Expiry: System flagged 15 boxes of specialty medication expiring in 75 days (velocity suggested only 6 would sell). Actions: contacted prescribing doctors with discount offer, transferred 4 boxes to high-volume location, reduced price 10%. Result: sold 11, transferred 4, expired 0. Saved Rp 3.2 million.
Inter-Location Transfer: Saturday afternoon prescription in Gresik, out of stock. System showed Sidoarjo had 3 boxes. Courier transfer (Rp 25K) delivered in 90 minutes. Customer received same-day vs. going to competitor. Net benefit: Rp 425K + customer retention.
Temperature Monitoring: Digital monitors connected to system alert pharmacist via SMS if refrigeration fails. Zero temperature-related losses in 18 months (previously Rp 2-4M annually).
Investment & ROI
Initial Investment:
Software, hardware, implementation: Rp 192 million
Ongoing: Rp 68.4 million annually
Annual Returns:
Expired stock prevention: Rp 169M
Recovered sales: Rp 48M
Operational efficiency: Rp 72M
Total: Rp 560.5 million
ROI: 192% first year, 720% annually thereafter. Payback: 5 months.
Broader Impact
The foundation built in 2016 enabled sustainable growth:
Opened 2 additional locations (2017-2018) with 40% less initial inventory investment
New locations reached profitability 50% faster
Achieved 8-12% better pricing on top 100 SKUs through data-driven supplier negotiations
Pharmacists shifted from inventory administration to patient care (medication therapy management, chronic disease programs)
"I became a pharmacist to help patients, not to manage inventory. This system gave me back my time and eliminated the stress of expired stock and stockouts. It's the best investment we've ever made." - Owner & Licensed Pharmacist
Today, the pharmacy chain operates 9 locations, all using the same systematic inventory approach, maintaining the highest standards of patient care while operating profitably.
Managing complex inventory in healthcare, food service, or specialty retail? Contact KSI Digital Solutions to discuss inventory optimization, expiry management, and regulatory compliance systems.