Pharmacy Chain: Uncovering 59.5% Dead Stock and 10.3M Frozen Capital
PharmaHow a pharmacy chain with 8 locations discovered that nearly 60% of their inventory was dead stock — and what AI recommended to fix it.
Company Overview
A pharmacy chain operating 8 locations, managing approximately 1,000 active SKUs across 78 product categories sourced from 72 suppliers. The chain serves a broad customer base with everything from prescription medications and OTC drugs to medical devices and supplements.
The Challenge
Management suspected that inventory was bloated, but lacked visibility into the real numbers. There was no systematic way to answer basic questions: Which products actually generate profit? How much capital is frozen in items that barely move? Which suppliers deliver value and which deliver dead weight?
Manual spreadsheet analysis covered only the top sellers. The long tail — hundreds of slow-moving SKUs — went unexamined quarter after quarter.
The AI Analysis
After connecting sales and inventory data to the platform, the AI engine ran a comprehensive diagnostic across all 8 locations. The findings were stark.
Frozen Capital: 10.3M (59.5% of All Inventory)
Nearly 60% of total inventory value was frozen in products with over 90 days of supply on hand. The top offenders:
| Product | Frozen Value | Days of Stock |
|---|---|---|
| Enzyme supplement (Group A) | 1.47M | 1,244 days |
| Diagnostic test strips | 660K | 26,378 days |
| Hepatoprotector (capsules) | 364K | 847 days |
| Hepatoprotector (tablets) | 290K | 623 days |
| Vitamin B complex | 242K | 512 days |
The diagnostic test strips alone represented a 72-year supply at current sales velocity — a dramatic illustration of a purchasing decision made without demand data.
Dead Stock: 574 of 1,000 SKUs
More than half of the entire assortment had stock levels exceeding 90 days of supply. These items were tying up shelf space, warehouse capacity, and capital that could be deployed elsewhere.
ABC Analysis: The Profit Concentration
The AI segmented all products by their contribution to gross profit:
| Segment | Products | % of Assortment | % of Profit |
|---|---|---|---|
| A (core profit drivers) | 84 | 8% | 80% |
| B (moderate contributors) | 210 | 21% | 15% |
| C (minimal contribution) | 706 | 71% | 5% |
This meant 706 products — nearly three-quarters of the catalog — contributed just 5% of total profit while consuming significant working capital.
Hidden Risk: High-Margin Items Running Low
While capital was locked in dead stock, several high-margin products were at risk of going out of stock:
| Product | Days of Supply Left | Margin |
|---|---|---|
| Supplement (mineral complex) | 25 days | 2,052% |
| Vitamin supplement | 18 days | 1,340% |
| Supplement (fatty acids) | 31 days | 890% |
These items needed urgent replenishment — but the budget was tied up in slow movers.
AI Recommendations
The platform generated 83 actionable recommendations across four categories:
- 884 markdown candidates — products to discount for capital recovery, prioritized by frozen value and shelf life
- 20 purchase recommendations — high-demand items requiring immediate reorder
- 20 capital release recommendations — specific actions to free up the largest blocks of frozen capital
- Supplier consolidation suggestions — 393 products were available from more than one supplier, creating price negotiation opportunities
Location-Level Dead Stock Analysis
| Location | Total Inventory | Dead Stock % | Frozen Capital |
|---|---|---|---|
| Location #1 | 2.56M | 64.2% | 1.64M |
| Location #2 | 1.68M | 58.1% | 980K |
| Location #3 | 1.58M | 62.7% | 1.00M |
| Location #4 | 1.82M | 55.3% | 1.00M |
| Location #5 | 2.04M | 61.8% | 1.26M |
| Location #6 | 2.30M | 57.4% | 1.32M |
| Location #7 | 2.62M | 60.9% | 1.60M |
| Location #8 | 2.70M | 56.0% | 1.50M |
The problem was systemic — no single location was healthy.
Projected Impact
Based on the AI recommendations, the estimated financial impact for year one:
- 3.9M recoverable through targeted markdowns on dead stock
- 5–7M total inventory optimization potential in the first 12 months
- Turnover improvement from 180+ days to under 90 days for the majority of the assortment
Key Takeaway
The pharmacy chain's situation is not unusual — it is typical. Most retailers operate with 40–60% excess inventory simply because they lack the tools to see it. The AI diagnostic turned invisible losses into a concrete action plan with measurable financial outcomes.