The quiet cost of dead stock in hospital pharmacies

Dead stock is unusual among hospital losses in that nothing announces it. A wrong bill gets disputed at the counter. An unhappy patient tells you. But a box of medicine sliding quietly toward its expiry date generates no signal at all until the day it is worthless, at which point the only remaining decision is how to write it off.

How pharmacies accumulate stock nobody will use

• Ordering against last month rather than next month. Reordering what you consumed works until prescribing patterns shift, a consultant leaves, or a seasonal illness passes.
• Bulk discounts on slow movers. A supplier discount for a larger quantity is only a saving if the quantity gets used before it expires. On a slow-moving item it reliably is not.
• Consultant-specific preferences. A visiting specialist prescribes a particular brand, the pharmacy stocks it, the specialist stops visiting. Nobody connects the two events.
• No batch-level expiry visibility. If the system tracks quantity but not batch and expiry, near-expiry stock is invisible until someone physically checks the shelf.
• Last-in-first-out shelving. New stock placed in front of old is a purely physical problem that reliably produces expiry write-offs.

The numbers worth watching

You do not need a sophisticated analytics setup. Four figures, reviewed monthly, catch most of it:

• Value of stock with under 90 days to expiry. The single most useful number, because it is the one where action is still possible. At 30 days your options have mostly closed.
• Items with no dispensing in 60 days. Slow movers, before they become expiry write-offs.
• Stock value as a multiple of monthly consumption. A rough holding measure. Rising over several months means you are accumulating.
• Write-off value per month. The scoreboard. If the other three improve and this does not, the others are being measured wrong.

Track them per category as well as in total. A single aggregate number hides the fact that the problem is usually concentrated in a small set of high-value, low-velocity items.

What to do with what you find

Near-expiry stock has a shrinking set of options, so the value of finding it early is almost entirely about preserving choice:

1. Return to supplier. Only possible if your purchase terms allow it, which is worth negotiating before you need it rather than after.
2. Redistribute internally, between branches or between IPD and OPD pharmacy, if consumption differs.
3. Prescribing awareness. Telling clinicians what is near expiry, where clinically equivalent options exist, is legitimate and effective. It must never override clinical judgment, and framing matters: this is information, not instruction.
4. Stop reordering. Obvious, routinely missed, because reorder points are often set once and never revisited.

Why this usually stays broken

The information needed to prevent dead stock exists in most hospitals. It is simply spread across a purchase register, a dispensing record, and a shelf, with nobody whose job is to join them up. The pharmacist sees the shelf but not the consumption trend. The administrator sees the write-off, months later, as a number in a report.

Which is why this is a reporting problem more than a discipline problem. If someone has to run a manual reconciliation to see near-expiry value, it will happen occasionally at best. If it appears without being asked for, decisions get made while they still have options.

pulse-grid surfaces idle pharmacy inventory as part of its AI co-pilot, alongside revenue and occupancy, precisely because this is a number that only gets looked at when it arrives unprompted.