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:

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:

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.

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.

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:

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.