

Pharmacy Reorder Level and Min-Max Stock: How to Stop Shortages and Dead Stock
In short: Most pharmacies in Pakistan order the way they always have: the counter staff notices a gap, someone calls the distributor. That is why fast movers run out on a Sunday and why slow movers sit until they expire. A reorder level with a minimum and maximum quantity for each medicine fixes both problems, and you can set it up from the sales history you already have.
The two losses nobody adds up
A shortage looks like one lost sale. It is usually more: the customer walks to the next pharmacy for one item and buys the rest of the prescription there too, and sometimes does not come back. Nothing in your books records that.
Dead stock is the opposite and easier to see once you look. Boxes bought in quantity for a discount, medicines ordered for a single patient who never returned, strengths that stopped being prescribed. That money is on the shelf until the expiry date turns it into a return claim or a write-off.
Reorder levels sit between these two. They tell you when to buy and how much, so neither loss becomes a habit.
The four numbers you need per item
- Average daily sale. Take the quantity sold over the last 60 or 90 days and divide by the number of days. Use a longer window for seasonal medicines.
- Lead time. How many days from placing the order to the stock actually being on your shelf, for that distributor. Measure it; do not assume it.
- Safety stock. A buffer for the days the distributor is late or demand jumps. A few days of average sale is enough for most items.
- Order cycle. How often you place orders with that supplier, weekly or twice a week.
How to work out the levels
The minimum, also called the reorder level, is the quantity at which you must place an order:
Reorder level = (average daily sale x lead time in days) + safety stock
The maximum is the most you want on the shelf at any time:
Maximum = reorder level + (average daily sale x order cycle in days)
An example with round numbers. A tablet sells about 8 strips a day. Your distributor takes 3 days. You keep 2 days as safety. Reorder level is 8 x 3 + 16, which is 40 strips. You order weekly, so the maximum is 40 + 8 x 7, which is 96 strips. When stock touches 40 you order roughly 56 strips to bring it back up to 96. These are illustrative numbers, not a recommendation for any particular medicine.
Do not set levels for every item the same way
- Sort by value sold. Run a report of quantity and value sold over the last three months and sort it highest first.
- Take the top group seriously. The small number of items that make most of your sales deserve properly calculated levels and a weekly check.
- Give the middle group a simple rule. A round reorder level and a round maximum, reviewed once a quarter, is enough.
- Put the tail on order-to-demand. Items that sell a few times a year should not be stocked at all unless a regular patient needs them. Order when asked.
- Flag the cold chain separately. Items needing refrigeration carry more risk, so keep levels tight and quantities small.
- Review after any change. A new clinic opening nearby, a doctor changing prescription habits, or a season ending all change the average daily sale.
Where the shelf and the system stop matching
Reorder levels only work if the stock figure in your system is true. In a pharmacy the usual culprits are loose sales from a strip not being deducted correctly, returns taken back without an entry, free goods received but never entered, and expiries removed from the shelf but left in the system. Fix the unit of sale first: if you sell by tablet but buy by box, the conversion has to be right or every level you set is nonsense.
This is where pharmacy management software earns its place. It holds the pack-to-loose conversion, keeps batch and expiry against each pack, and prints a reorder list of exactly which items have fallen to their minimum, so the purchase order is a report rather than a memory test.
Turning the levels into a purchase order
- Run the below-minimum report on the same day each week, before the distributor’s cut-off.
- Order up to the maximum, not up to whatever discount tier is being offered that week.
- Check near-expiry stock in hand before ordering more of the same item.
- Split large orders between the two best suppliers for that item if availability has been unreliable.
- After delivery, enter free goods and bonus packs into stock, otherwise your next level calculation is wrong.
Before accepting a large bonus offer, work out what it does to your cost per box: see distributor bonus and discounts in a pharmacy.
Want a reorder list instead of a guess?
Message us on WhatsApp and we will show you how minimum and maximum levels are set in our pharmacy software and how the below-minimum purchase list is produced. Local support from Karachi.
Frequently asked questions
What is a reorder level in a pharmacy?
It is the stock quantity at which you must place a fresh order for that medicine. It is calculated as average daily sale multiplied by supplier lead time, plus a safety buffer.
What is the difference between minimum and maximum stock?
The minimum, or reorder level, tells you when to order. The maximum tells you how much to bring the stock back up to, so you do not over-order on discounts.
How much sales history should I use?
Sixty to ninety days works for most medicines. Use a longer period for seasonal items so a quiet month does not drag the level down.
Should every medicine have a reorder level?
No. Set proper levels for your top sellers, simple round levels for the middle group, and order the slow-moving tail only when a patient asks for it.
How do reorder levels reduce expiry losses?
A maximum quantity stops the bulk buying that leaves boxes sitting past their expiry date, and reviewing levels regularly catches items whose demand has dropped.
Why do my system stock figures not match the shelf?
Usually loose sales not deducted correctly, returns or free goods not entered, or expired stock removed from the shelf but not from the system. Fix the pack-to-loose conversion first.
The figures used above are illustrative examples of the calculation only. Set your own levels from your own sales history, supplier lead times and the storage rules that apply to your pharmacy.
