By Raied Muheisen · Reviewed October 16, 2026. These are illustrative planning examples, not forecasts or evidence of a software test.
A reorder point tells you when to start replenishing an item. Safety stock is the buffer chosen for uncertainty in demand or delivery. Neither number, by itself, tells you how much to buy. Keeping the decisions separate makes inventory settings easier to explain and maintain.
The basic reorder-point formula
Reorder point = expected demand during replenishment lead time + safety stock. For reasonably stable demand, multiply average daily demand by lead time in days, then add a chosen buffer. Match the units: daily demand with days, or weekly demand with weeks.
An item selling four units daily with six days to replenish has expected lead-time demand of 4 × 6 = 24 units. A six-unit illustrative buffer creates a 30-unit reorder point. Reaching 30 triggers a review; it does not automatically justify buying 30 more. The calculation depends on the demand period and replenishment process you selected.
Define the stock position consistently
A common inventory position is usable on-hand stock plus reliable incoming stock minus outstanding allocations or backorders not already deducted. Applications define fields differently, so verify them before adopting the rule. Do not subtract a reservation twice.
With 22 usable units, ten reliably incoming and five outstanding allocated units, the example position is 27. Against a threshold of 30, that calls for a replenishment review. Overdue or uncertain deliveries need separate attention instead of being treated as guaranteed availability. Quarantined goods should not become saleable stock just because they are physically in the building.
Measure the complete lead time
Measure from the decision that releases the order until the goods are saleable. Processing, production, transport, receiving and inspection may all contribute. A shipment arriving at the door is not ready to sell if it remains uncounted for two days.
Keep order date, promised date, arrival date, usable quantity and saleable date. Examine the spread as well as the average. If variability is material, a simple average-based threshold may be inadequate. More precise-looking formulas are not a substitute for appropriate data or a realistic operating policy.
Choose a buffer without pretending certainty
For a simple low-risk starting policy, an owner might select a number of days of average demand. Four daily units with a two-day buffer creates eight safety units. That is a policy choice, not a statistical service-level guarantee. Explain why it suits the item’s value, supply reliability and consequence of a stockout.
Expiry, storage cost and falling demand can make a large buffer inappropriate. Essential consumables with variable supply require different attention. Statistical models need suitable demand and lead-time data and defensible assumptions. Do not label a rough buffer a guaranteed 95% service level.
Reorder point and order quantity answer different questions
| Decision | Question | Typical input |
|---|---|---|
| Reorder point | When should we review replenishment? | Lead-time demand plus buffer |
| Order quantity | How much should we buy? | Target stock, pack size, cash and storage |
| Safety stock | What uncertainty are we buffering? | Risk policy and variability |
| Review interval | How often do we check? | The operating cadence |
Suppose target stock is 50 and the relevant position is 27. The starting purchase suggestion is 23 units. A supplier pack of six means rounding up to 24 if that is appropriate. Check shelf life, open orders, storage and budget before approval. Keep the proposed amount separate from the buyer’s decision and record overrides.
A spreadsheet layout you can understand later
- One stable SKU per sellable variant; keep the description for readability.
- Demand period, units sold and notes about unusual events.
- Average demand using a consistent calendar policy.
- Lead time, chosen safety stock, source and review date.
- Reorder point calculated from those assumptions.
- Usable stock, reliable incoming and allocations with clear definitions.
- Suggested purchase, supplier pack size and approved order.
A simple example formula is =B2*C2+D2 when B holds average daily demand, C lead time and D safety stock. A position calculation could be =E2+F2-G2 for usable stock, reliable incoming and outstanding allocations. These references are illustrative: label your own sheet before using them.
Handle promotions, stockouts and new products
Sales during a stockout understate potential demand. Promotions can temporarily inflate it. New products may need an initial buying policy until sufficient history exists. Annotate those events rather than allowing an unexplained formula to reset the baseline.
Review fast-moving items more frequently. Investigate repeated emergency purchases and excess stock. Fix count errors before tuning thresholds, or the model becomes an elaborate way to act on incorrect quantities. The purpose is a repeatable decision with traceable inputs, not set-and-forget automation.
What to ask an inventory-software supplier
Ask which field triggers an alert, whether incoming purchase orders count, how reservations affect availability and how pack sizes or minimum orders work. Reproduce the example with a real SKU and inspect the suggested purchase. Use the retail inventory comparison for the wider workflow and the demonstration checklist to record evidence.