How to Set Reorder Points for Pharmacy Inventory
Calculate a reorder point from expected demand, supplier lead time and safety stock. Copy a five-SKU worksheet and test the thresholds against actual receipts and counts.

Set a pharmacy inventory reorder point at the quantity you expect to use while waiting for a replenishment order, plus safety stock. When inventory reaches that level, review whether to order. Start with a few routinely stocked items whose counts and supplier delivery times you can verify.
- Use the same stock unit for usage, shelf counts and incoming orders.
- Measure lead time from the order cutoff through to stock being available on the shelf.
- Check open orders and near-expiry stock before placing a new order.
What data do you need to set a reorder point?
| Input | What to record |
|---|---|
| Item and location | SKU, pack size, stock unit and the location where the threshold applies. |
| Daily demand | Units sold or used per day over a representative period. Flag stockouts, promotions and other events that distort the average. |
| Replenishment lead time | Days from placing an order to having the stock ready to use. Use actual receipts and account for ordering cutoffs and days without deliveries. |
| Safety stock | A buffer in stock units for demand variation and delays. Record the reason for the initial buffer and who will review it. |
| Inventory position | Usable stock on hand plus confirmed inbound units, less any commitments already allocated against that stock. Keep the expected receipt dates alongside the quantities. |
Use a consistent day basis. If you measure lead time in calendar days, include every calendar day in the demand window and account for weekend demand and supplier closures. A stockout can make sales look lower than actual demand, so flag those days before allowing their sales volume to drive a lower threshold.
How do you calculate the reorder point?
Reorder point = expected demand during replenishment lead time + safety stock.
For an item with steady demand, multiply average daily demand by lead time in days, add the buffer, then round up to a whole stock unit. At four packs per day with three days of lead time and six packs of safety stock, the reorder point is 18 packs. If a routine delivery change raises lead time to five days, the same assumptions give 26 packs. Oracle Inventory reorder point planning
Copy this five-SKU worksheet
These figures are fictional. All quantities are packs, lead times are calendar days, and the sample assumes the team reviews its alerts daily. Each buffer is an illustrative starting assumption.
| SKU | Demand (packs/day) | Lead time (days) | Buffer (packs) | Reorder point (packs) | Assumption to verify |
|---|---|---|---|---|---|
| INV-101 | 4 | 3 | 6 | 18 | Steady demand with occasional receipt delays. |
| INV-102 | 8 | 2 | 4 | 20 | A reliable delivery lane and stable weekday and weekend volume. |
| INV-103 | 1.5 | 3 | 2 | 7 | Expected use of 4.5 packs before receipt, rounded up after adding the buffer. |
| INV-104 | 0.5 | 4 | 1 | 3 | Slow mover with intermittent sales. Review recent demand and expiry by lot. |
| INV-105 | 3 | 5 | 5 | 20 | Longer replenishment across the supplier's delivery schedule. |
What should you check before acting on an alert?
Compare the threshold against your inventory position. For INV-101, 12 usable packs on hand plus 10 confirmed inbound packs minus two committed packs gives a position of 20. That is above the threshold of 18. If the incoming order slips by four days, the ten uncommitted packs on the shelf cover only about 2.5 days at the sample usage rate. Check the delivery date with the supplier and bring forward the review if a shortfall is likely.
If the shelf and system disagree, recount the item and check the pack-size conversion, unposted receipts, returns and transfers. Take stock that is unavailable for use out of the review quantity. Record any correction and the reason before relying on the next alert.
Decide how many packs to order after reviewing consumption, pack multiples, space and expiry exposure. If purchasing happens only on certain days, account for the wait until the next order window in your review process. Check unusual demand and late deliveries with the buyer before changing the standing threshold.
How can you pilot this with your current system?
- Pick five items and assign one person to review their alerts and one backup.
- Enter the starting thresholds and verify them against physical counts and open purchase orders.
- Review the alerts manually for several replenishment cycles. Record missed alerts, unnecessary orders, late receipts and repeat count discrepancies.
- Adjust the input that caused each issue. Recheck the pilot after a change in delivery schedule, pack size or demand.
If purchasing, on-hand counts and usage live in different systems, use the Ontario pharmacy software selection guide to test whether a vendor can bring those records together.
