Pharmacy Chain: Inventory Optimization Prevents Rp 169M in Expired Stock

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

• 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 of it 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:

1. Expiry Management: Batch-level tracking with automated alerts at 90, 60, 30 days before expiry

2. FEFO Enforcement: System automatically selects oldest batch when dispensing

3. Smart Reordering: Demand-based forecasting with automatic purchase order generation

4. Inter-Location Optimization: Real-time visibility and stock transfer recommendations across all locations

5. 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: The system flags products 90 days before expiry, enabling proactive action (returns to the distributor where the supply agreement allows, transfers to higher-volume locations, markdowns on over-the-counter products). 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: about 8 hours weekly per location

Customer & Compliance

• Patient satisfaction: 3.9 → 4.5 (out of 5)

• Repeat prescription fill rate: +31%

• Audit trail: every batch, expiry date and controlled substance recorded automatically

Key Examples

Preventing Expiry: The system flagged 15 boxes of a specialty medication expiring in 75 days at a location where sales velocity suggested only 6 would be dispensed in time. Actions: moved the surplus to the locations that dispense it most and paused reordering across the chain until the batch was used. Result: all 15 boxes dispensed before expiry, none written off. 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. The customer received the medication the same day instead of going to a competitor. Net benefit: Rp 425K + customer retention.

Temperature Monitoring: Digital monitors connected to the system alert the 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 289 million

ROI: Rp 289 million in annual returns against Rp 68.4 million in running costs. Payback: about 10 months. The Rp 900 million released from inventory is not counted here.

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 to discuss inventory optimization, expiry management, and regulatory compliance systems.