Pharmacy Inventory Management: Stop Dead Stock and Short Expiry
Pharmacy inventory management for Indian chemists: sort fast and slow movers, set reorder levels and review monthly so dead stock and short expiry stop.
Pharmacy inventory management means buying each medicine in the quantity you will sell before it nears expiry. In practice that comes down to four habits: sort stock into fast and slow movers, set a reorder level for each item, buy slow movers in the smallest pack you can, and review short-expiry and dead stock once a month.
Consider Imran's medical store in Bhopal, which carries about 1,800 products. A count shows ₹3.2 lakh of stock on the shelves, but a sales report shows that about ₹70,000 of it has not sold a single unit in four months. That ₹70,000 is dead stock: money already paid to distributors, sitting on a shelf and getting closer to expiry every week. If even a third of it expires before he acts, that is over ₹23,000 lost.
Why does a medical store end up with dead stock?
Dead stock is stock that has not sold for a long time, typically 90 days or more. In a pharmacy it builds up for a few predictable reasons:
- A doctor nearby prescribed a brand for a few months, then switched to another
- A distributor scheme (buy 10, get 2 free) made you take more than you sell
- One patient on a long-term medicine moved away or changed treatment
- Seasonal stock, like cough syrups or anti-allergy tablets, was bought late in the season
- Orders were placed by habit or memory, not from sales figures
None of these is a mistake on its own. They become a problem when nobody looks at the stock list until the expiry date arrives.
How do you find fast and slow moving medicines?
Fast movers are items that sell every day or two, like common painkillers, antacids and the diabetes and blood pressure medicines your regular patients buy each month. Slow movers sell a few times a month or less. Take your last 90 days of sales by item and sort them into three groups:
- Fast movers: sold most days. Never let these run out, because a missed sale often sends the customer to another shop for good
- Slow movers: sold a few times a month. Keep a small stock and reorder only when it runs low
- Non-movers: no sale in 90 days. These need action this month, not next
In most medical stores a small share of items brings in most of the sales. Knowing which items those are tells you where running out hurts, and where extra stock only ties up money.
How do you set a reorder level in a pharmacy?
A reorder level is the stock count at which you place the next order, so new stock arrives before the old runs out. A simple formula works well for a single store:
Reorder level = daily sale x days the distributor takes to deliver + a small safety stock.
Say Imran sells 6 strips a day of a common blood pressure tablet and his distributor delivers in 2 days. Six times two is 12 strips. Add a safety stock of one day, 6 strips, and his reorder level is 18. When the count drops to 18, he orders. For a slow mover that sells 4 strips a month, a reorder level of 2 strips is plenty, and he orders the smallest quantity the distributor will supply.
Reorder levels are not fixed for life. Cough, cold and fever medicines need higher levels in the monsoon and winter, and lower ones in summer. Look at the list at the start of each season and adjust the top 50 items.
What is a short-expiry window, and how should you manage it?
Short-expiry stock is stock that is close to its expiry date, usually within the next three months. It can still be sold legally until the end of the expiry month, but the time left to sell it, or to return it, is running out. Every pharmacy needs its own short-expiry window, the number of months before expiry at which an item gets special attention.
- Set your window to match your distributors' return terms, so you still have time to claim
- Move short-expiry stock to the front of the shelf and tell the counter staff about it
- Check whether the batch can go back to the distributor before it expires
- Do not accept new stock from a distributor that is already inside your window, unless the price reflects it
Tracking stock batch by batch is what makes this possible, because each batch carries its own expiry date. Software that sells the soonest-expiring batch first, as Mapis does, keeps the old stock moving before the new.
Why the batch, and not the product, is the real unit of medicine stock is explained here: Medical Store Batch and Expiry Management in India
How can substitutes reduce dead stock?
A substitute is a medicine with the same salt (active ingredient), strength and form as another, made by a different company. Many common salts are sold by a dozen or more companies. If you stock every brand that every doctor in the area has ever written, your slow-mover list will keep growing.
- For each common salt, keep the brands local doctors actually prescribe, plus one or two well-known alternatives
- When a doctor's prescribing changes, stop reordering the old brand at once and sell down what is left
- Talk to nearby doctors about which brands they are writing now, so you are not caught out
- Never swap a prescribed brand without the prescriber's agreement; the substitute question is for your buying, not for dispensing on your own
What should a monthly pharmacy stock review cover?
Set a fixed day, such as the first Monday of every month, and spend an hour on these steps:
- Print or open a list of every batch expiring in the next three months
- Mark which of those batches can still go back to a distributor, and start the claim
- List items with no sale in 90 days, and decide for each: return, sell down, or move to a sister store
- Check the fast-mover list for any item that ran out last month, and raise its reorder level
- Compare the last month's purchases with sales; buying much more than you sold is an early warning
- Count a few high-value items physically and match them with the system
Stock you cannot sell in time is best sent back before it expires, and the paperwork for that is simpler than it looks: Return Near-Expiry Medicines to Your Distributor: A Simple Process
How much stock should a medical store carry?
There is no single right number, but a useful check is stock days: the value of stock on hand divided by the average daily purchase value of what you sell. If Imran sells about ₹12,000 of stock at purchase price each day and holds ₹3.2 lakh of stock, he is holding about 27 days of stock. If much of that is in non-movers, the number hides a real problem, so always look at it next to the dead stock list.
The aim is not the lowest possible stock. A pharmacy that keeps running out of common medicines loses regular patients. The aim is plenty of what sells, very little of what does not, and nothing that expires on the shelf.
If you want batch-wise stock, expiry alerts and soonest-expiry-first selling without a separate register, here is how the pharmacy setup works. See how Mapis tracks pharmacy stock by batch
Dead stock does not appear overnight. It builds up one extra box at a time. An hour a month with the right list is enough to stop it.
Frequently asked questions
How do I manage stock in a medical store?
Sort your items into fast movers, slow movers and non-movers using the last 90 days of sales. Set a reorder level for each item based on daily sales and delivery time. Buy slow movers in small quantities. Track stock by batch with expiry dates, and do a monthly review of short-expiry and dead stock so you can return or sell it in time.
What is dead stock in a pharmacy?
Dead stock is medicine that has not sold for a long period, usually 90 days or more. It ties up money you have already paid to distributors and moves closer to expiry every week. It often comes from a doctor changing brands, a bulk scheme bought too heavily, or seasonal stock bought late. Review it monthly and return or sell it down early.
How do you calculate the reorder level for medicines?
Multiply the average daily sale by the number of days your distributor takes to deliver, then add a small safety stock. If you sell 6 strips a day and delivery takes 2 days, that is 12 strips, plus a day's safety stock of 6, so you reorder at 18. Review reorder levels at the start of each season.
What is short expiry stock in a pharmacy?
Short-expiry stock is medicine close to its expiry date, usually within the next three months. It can legally be sold until the end of its expiry month, but the time to sell or return it is running out. Move it to the front of the shelf, alert counter staff, and start a return claim if your distributor accepts it.
How often should a medical store check expiry?
At least once a month, with a list of every batch expiring in the next three months. A fixed day, such as the first Monday, makes it a habit. The monthly check should also list items with no sale in 90 days, so slow stock is returned or sold before it expires instead of being written off.