---

If you've ever had a best-seller go out of stock because you placed the reorder two weeks too late, you already understand why reorder points matter. The concept is simple: set a threshold for each product, and when inventory drops to that level, it's time to buy more.

In practice, most retail buyers either set reorder points once and forget about them, or don't set them at all — relying on gut feel and weekly inventory reviews instead. Both approaches fail in the same way: you notice the problem after the stockout has already started costing you sales.

The standard reorder point formula

This formula answers the question: "How many units do I need on hand right now so that I don't run out before the next shipment arrives?"

Let's break down each component.

Average daily demand

This is your sell rate — how many units of this product you sell per day, on average. The key word is recent. Using 12 months of sales history to calculate daily demand averages out the seasonality, promotions, and trend shifts that make the number meaningful. Use 4–8 weeks of recent sales as your baseline.

Lead time

Lead time is the total elapsed time from when you place a purchase order to when the inventory is on your shelf and available to sell. This includes:

• Vendor production or processing time
• Shipping and freight time
• Customs and duties clearance (for imports)
• Receiving, quality check, and shelving at your warehouse

Most buyers underestimate lead time because they only count the vendor's quoted production time. A vendor who says "3 weeks" often means 3 weeks to ship — add 2 weeks for ocean freight, 1 week for customs, and 3 days for receiving, and your real lead time is closer to 6.5 weeks.

Safety stock

Safety stock is the buffer that protects you against two kinds of uncertainty:

1. Demand variability — sales might be higher than your average next week
2. Supply variability — your vendor might ship late

The simplest approach is a fixed buffer — "I always want 2 extra weeks of cover." More sophisticated approaches use standard deviation of demand and lead time to calculate a statistically-derived buffer. For most SMB retailers, the simple approach works fine:

If you sell 10 units/day and want a 14-day safety buffer, your safety stock is 140 units. The right buffer depends on how painful a stockout is for this particular product — a core replenishment style that drives repeat traffic deserves a bigger buffer than a seasonal fashion item you're planning to exit.

A worked example

Let's say you're a buyer for a DTC apparel brand and you need to calculate the reorder point for your best-selling cargo pant.

Input	Value	Source
Average daily demand	8 units/day	Last 6 weeks of sales
Lead time	42 days (6 weeks)	Average of last 5 POs
Safety buffer	14 days (2 weeks)	Core replenishment style, high stockout cost

When your on-hand inventory for this cargo pant drops to 448 units, place a new order. If you wait until you have 300 units, you're already too late — you'll stock out before the next shipment arrives.

Where this goes wrong in practice

The formula is straightforward. The execution is where most buyers get burned.

Mistake 1: Setting reorder points once and never updating them

Demand changes. A style that was selling 8 units/day in September might sell 15/day in November and 3/day in January. If your reorder point is still based on the September sell rate, you'll either over-order or under-order for the rest of the season.

Reorder points need to be recalculated regularly — at minimum monthly, ideally weekly. This is the single biggest reason buyers move from spreadsheets to automated tools: nobody has time to manually recalculate reorder points for 200+ styles every week.

Mistake 2: Ignoring on-order inventory

If you have 400 units on hand and a reorder point of 448, the formula says "reorder now." But what if you already have 500 units arriving next week? You don't need another order — you need to wait.

The reorder decision should account for on-hand plus on-order inventory, not just on-hand. The adjusted check becomes:

Mistake 3: Using the same safety buffer for every product

A core t-shirt that accounts for 15% of your revenue deserves a bigger safety buffer than a seasonal novelty item. Yet most buyers apply the same "2 weeks of safety stock" across the entire assortment.

Better approach: tier your safety stock by product importance.

Tier	Products	Safety Buffer	Rationale
A — Never stock out	Top 20% by revenue	3–4 weeks	Stockout directly impacts revenue and customer trust
B — Acceptable risk	Middle 30%	2 weeks	Moderate impact; can survive a brief gap
C — Minimal buffer	Bottom 50%	1 week or none	Low velocity; excess inventory risk outweighs stockout risk

This is the same ABC classification logic used in professional demand planning. Your A-items get the most protection because they generate the most revenue.

Mistake 4: Not accounting for demand seasonality

Using a trailing average sell rate works when demand is stable. It fails badly during seasonal ramps. If you're heading into peak season and your trailing average is based on the slow period, your reorder point is too low — you'll stockout right when demand surges.

The fix: use a forward-looking demand estimate (a forecast) instead of a backward-looking average. This is where demand forecasting and reorder point calculation overlap — your reorder point is only as good as your demand estimate.

Mistake 5: Calculating at style level when the stockout is at size level

You might have 500 units on hand across all sizes — well above your reorder point of 448. But if 400 of those are size XL and you're sold out of M and L, you have a stockout problem that the aggregate number completely hides.

For apparel specifically, size-level reorder tracking catches the problems that style-level misses. Your best-selling sizes stock out first, and by the time the overall number looks low, you've already lost weeks of sales in your key sizes.

When to stop using spreadsheets for reorder points

You can absolutely manage reorder points in Excel if you have a small assortment. Here's when it starts breaking down:

• 50+ active styles — recalculating weekly becomes a full day of work
• Seasonal products — trailing averages produce the wrong answer, and building a forecast model in Excel is a project in itself
• Multiple vendors with different lead times — each vendor needs its own lead time assumption, and they change
• Size-level tracking — multiplies the number of calculations by 5–10x
• On-order inventory — cross-referencing open POs against on-hand by style and size is error-prone in spreadsheets

At around 50 styles, most buyers find that the time spent maintaining the spreadsheet exceeds the time it would take to learn a purpose-built tool. At 100+ styles, the spreadsheet is almost certainly producing stale or incorrect reorder signals.

What automated reorder alerts look like

A demand planning tool that automates reorder points does a few things that spreadsheets can't do efficiently:

• Recalculates weekly — every time new sales data comes in, reorder points update automatically based on the latest demand signal
• Uses forecasted demand, not just trailing averages — accounts for seasonal ramps, trend shifts, and planned promotions
• Incorporates lead time per vendor — a style from a domestic vendor with 2-week lead time gets a different reorder point than one from an overseas vendor with 8-week lead time
• Surfaces urgency — not just "you need to reorder" but "you need to reorder this week or you'll stock out before the next shipment arrives"
• Generates the PO — once you decide to reorder, the recommended quantity and size breakdown are ready to send to the vendor

The difference between a spreadsheet and a tool isn't the formula — it's the fact that the tool runs the formula for every style, every week, automatically, and tells you which ones need attention today.

Connecting reorder points to weeks of cover

If you're already familiar with weeks of cover (WOC), you'll notice that reorder points and WOC are two views of the same underlying question: "When will I run out?"

• WOC tells you: "At the current sell rate, I have X weeks of inventory remaining"
• Reorder point tells you: "When inventory drops below X units, place a new order"

They're complementary. WOC is the metric you monitor — it's intuitive and easy to compare across products. The reorder point is the decision threshold — it's what triggers the action. A good planning system uses WOC to surface the situation and the reorder point to generate the alert.

Quick-start checklist

If you're setting up reorder points for the first time, here's the minimum viable version:

1. Pull the last 6 weeks of unit sales for each style
2. Divide by 42 to get average daily demand (or by 6 for weekly)
3. Measure actual lead time per vendor from your last 3–5 POs
4. Set safety buffer: 3 weeks for A-items, 2 weeks for B, 1 week for C
5. Calculate: (Daily Demand × Lead Time Days) + (Daily Demand × Safety Buffer Days)
6. Compare current on-hand (+ on-order) against the reorder point
7. Review and update monthly at minimum

That gets you 80% of the way there. The remaining 20% — seasonality adjustments, size-level tracking, automated weekly recalculation — is where a purpose-built tool earns its keep.