NEXALYPLANNER JOURNAL

Reorder Point Calculation for Small Business: Worked Examples

NexalyPlanner Journal · Practical planning guide · Published September 14, 2026

Organized stockroom with parcels, a low-stock shelf marker and the heading When to Reorder
Plan replenishment before stock runs short. The worked calculations appear below; this is an editorial illustration.

A reorder point tells you when to place the next purchase order for a product. For a small business that reviews inventory continuously, a practical starting formula is average daily demand multiplied by replenishment lead time, plus safety stock. Calculate it separately for each SKU and location that needs its own supply.

Suppose a shop sells four replacement filters per calendar day. Its supplier takes seven calendar days to deliver usable stock, and the owner chooses a 12-unit buffer. The reorder point is (4 × 7) + 12 = 40 units. That is the replenishment trigger. The quantity to buy requires a separate decision.

The numbers in this guide are fictional examples you can check by hand. They are not customer results or a recommendation to carry the same buffer in every business.

Start with demand during lead time

inFlow's reorder point guide describes the standard demand-times-lead-time calculation with an added safety-stock allowance. The useful work happens before you multiply: choosing a representative demand period and measuring how long replenishment actually takes.

Reorder point = average daily demand × lead time in days + safety stock.
Use matching units throughout. If demand is measured per calendar day, lead time must also use calendar days.

For the filter example, expected demand while waiting is 28 units. The additional 12 units provide a buffer against some delays or extra demand. They do not guarantee that the shop will avoid a stockout.

Worked example: replacement filter SKU FLT-01
Input or resultValueHow it was obtained
Units demanded120Illustrative 30-day period with stock available
Average daily demand4 units120 ÷ 30
Lead time7 daysOrder placement to usable receipt
Safety stock12 unitsChosen assumption, equivalent to three average days
Lead-time demand28 units4 × 7
Reorder point40 units28 + 12

Choose inputs that reflect the next replenishment

Use units demanded, not sales revenue. A higher selling price can increase revenue without changing the number of units you need to replenish. Keep a separate row for each size, color or part number; a total for an entire product family can hide a shortage of its busiest variant.

Historical sales are a useful demand proxy only when stock was available. If a filter sold out for ten days, dividing its recorded sales by the whole month can understate demand. Record the stockout and examine unfilled orders or a comparable in-stock period. Do not invent missed sales to fill the gap.

Measure lead time through the point at which the delivery is ready to use. Supplier processing, transit and receiving checks can all add time. Keep actual order and usable-receipt dates. If partial deliveries arrive, record what quantity became available on each date rather than treating the first small shipment as full replenishment.

A recent average may be unsuitable during a planned promotion, a supplier shutdown or a seasonal change. Write down why you selected the demand period and review that choice before committing cash to the purchase order.

Check inventory position before ordering twice

Looking only at the shelf count can trigger a duplicate order when replenishment is already on the way. A basic inventory-position calculation is usable on-hand stock plus open replenishment orders, minus unfilled customer demand. Keep your definitions consistent: if an available-stock figure already subtracts allocations, do not subtract the same units again.

A second example with an open purchase order
RecordUnits
Usable on hand32
Open replenishment order24
Unfilled customer demand8
Inventory position: 32 + 24 − 848

The shelf count of 32 is below the 40-unit trigger, but inventory position is 48. Under this simple continuous-review policy, that does not trigger another order. Check the arrival date anyway: a late delivery can leave a near-term shortage even when inventory position looks adequate. An uncertain or overdue order needs investigation, not automatic confidence.

Exclude damaged or quarantined units from usable stock. Reconcile orders, receipts and returns with your sales and inventory records so the calculation uses quantities you can explain.

Separate when to buy from how much to buy

For a brand-new boutique, use a cash ceiling and a small test assortment for the opening inventory purchase. A reorder point becomes useful after you have observed demand and actual replenishment time for a SKU. Keep the first buy and the later replenishment decision separate.

A 40-unit reorder point does not mean every purchase order should contain 40 units. Order quantity depends on your replenishment policy, demand outlook, case packs, minimum order quantity, storage and available cash. Expiry dates can make a large discount less attractive than it first appears.

For example, if your independently chosen target inventory position is 100 units and the current position is 40, the gap is 60 units. With a 24-unit case pack, buying whole cases would require 72 units to meet or exceed that target. Your resulting position would be 112. That extra stock should be a visible purchasing decision, not hidden rounding.

Allow for the time between reviews

The basic trigger assumes you review stock often enough to act when the threshold is reached. If you check only once a week, demand continues between reviews. A weekly review policy needs to cover the review interval as well as supplier lead time.

With four units of daily demand, seven days between reviews, seven days of replenishment lead time and the same assumed 12-unit buffer, an illustrative periodic-review target is 4 × (7 + 7) + 12 = 68 units. This is an order-up-to target for that simplified policy, not a replacement name for the 40-unit continuous-review trigger. Actual variability may require a different buffer.

Keep a reusable SKU worksheet

Use the fields below in your current spreadsheet or stock records. Record the source period and the person responsible for the next review so the number does not become a permanent setting without an owner.

FieldExample entry
SKU and locationFLT-01 / Main store
Demand period and quantity30 calendar days / 120 units
Daily demand and lead time4 units / 7 calendar days
Buffer and reason12 units / illustrative three-day allowance
Trigger and review policy40 units / check each business day
On hand, on order, unfilled demand32 / 24 / 8
Inventory position and action48 / verify incoming order date
Next reviewAfter the next receipt or a material demand change

Retain decimals during the calculation. If a finished trigger is 18.4 and you stock indivisible units, round the operational threshold up to 19. Keep the unrounded calculation in your notes. For bulk materials measured by weight or length, use the unit precision your operation actually supports.

Turn the trigger into a controlled purchase request

When inventory position reaches the trigger, create a purchase request with the SKU, required-by date, calculation date, open-order check and proposed quantity. Do not overwrite the reorder point with the order quantity: the first answers when to review, while the second reflects case packs, minimum order quantity, storage, demand outlook and available cash.

Carry the approved request into one purchase order and keep its PO number beside the replenishment record. As receipts arrive, update the same line’s accepted, rejected, cancelled and open quantities. The purchase-order tracker example shows how to keep a 100-unit order open after a partial delivery without ordering the balance twice.

Before releasing the PO: confirm the supplier quote is still valid, the promised date covers the shortage window, the pack size matches the approved quantity and existing inbound stock has not already solved the need.

Put the calculation beside your purchasing records

The NexalyPlanner Inventory & Procurement Planner product page describes SKU records, stock movements, purchase orders, receiving and reorder planning in an offline HTML system. Those records provide a place to organize the inputs and follow-up work discussed here. The arithmetic examples above are a planning method, not a claim that the product implements every policy in this guide.

Before moving your records, check the preview, supported browser and backup/import workflow. If you are comparing local tools with shared online systems, use the inventory software buying checklist. A formula will not correct an unrecorded receipt or a stock count entered against the wrong SKU.

Questions about reorder points

Is safety stock the same as the reorder point?

No. Safety stock is the buffer allowance. The reorder point also includes expected demand during replenishment lead time.

What if demand is zero?

Check whether the item is genuinely inactive, seasonal, newly introduced or unavailable during the measurement period. Zero recorded sales alone is not enough to decide whether it should be replenished.

How often should I update the calculation?

Review it when demand, supplier lead time or your service requirements change. A missed delivery, repeated shortage or accumulated excess stock is a reason to inspect the assumptions and records.

Can this method guarantee no stockouts?

No. Unexpected demand and supply delays can exceed the buffer. Track exceptions and adjust the policy using your own operating evidence.