Skip to content

How to Calculate a Reorder Point (With Examples)

Blog Restocked 5 min read

A reorder point is the stock level at which you place a new order, so the new stock arrives before you run out. Get it right and you stop guessing when to reorder. Get it wrong and you either sell out every few weeks or sit on cash you didn’t need to spend. This guide walks through the formula with worked examples, then covers the details that make the number trustworthy in a real store.

The formula

Reorder point = (average daily sales × lead time in days) + safety stock

The first part covers what you expect to sell while you wait for the supplier. Safety stock covers the days when you sell more than average, or the delivery is late.

What you need before you start

  • Average daily sales for the product, measured over a period that reflects normal trading (the last 8 to 12 weeks is a common choice).
  • How much daily sales vary, as a standard deviation. A spreadsheet can calculate this from daily sales figures.
  • Supplier lead time in days, from placing the order to having stock on the shelf. See how to measure lead time.
  • A service level: how often you are willing to run out before the next delivery arrives.

Example 1: no safety stock

A candle sells 4 units a day. The supplier takes 10 days to deliver. Expected sales during the wait are 4 × 10 = 40. With no safety stock, you reorder at 40 units. On an average fortnight that works, but any busy day means a stockout.

Example 2: with safety stock

A common way to set safety stock is:

Safety stock = service level factor × standard deviation of daily sales × √lead time

The service level factor is 1.28 for 90%, 1.65 for 95% and 2.33 for 99%. Say the candle’s daily sales vary with a standard deviation of 2 units. At 95%:

Safety stock = 1.65 × 2 × √10 ≈ 10.4, so about 11 units.
Reorder point = 40 + 11 = 51 units.

Lead time raises both parts of the reorder point10-daylead time4051 units30-daylead time12018138 unitsExpected sales in lead timeSafety stock
A candle selling 4 a day, at a 95% service level.

Example 3: a longer lead time

Same candle, but an overseas supplier with a 30-day lead time:

Expected sales = 4 × 30 = 120. Safety stock = 1.65 × 2 × √30 ≈ 18. Reorder point = 138 units. Longer lead times raise both parts, which is why slow suppliers tie up more cash.

Example 4: when the lead time itself varies

Some suppliers say 10 days but deliver anywhere between 7 and 16. If lead time varies, safety stock needs to cover that too. The fuller formula is:

Safety stock = service level factor × √(lead time × sales SD² + average daily sales² × lead time SD²)

For the candle, with a lead time of 10 days and a lead-time standard deviation of 3 days: 10 × 2² = 40, and 4² × 3² = 144. The square root of 184 is about 13.6, and 1.65 × 13.6 ≈ 22.4, so about 23 units. The reorder point becomes 40 + 23 = 63, compared with 51 when the lead time was reliable. An unreliable supplier costs you 12 extra units of stock on the shelf, all the time.

The mistake that makes it too low

Average daily sales should reflect demand, not just sales. If the candle was out of stock for 10 days last month, a simple average counts those as zero-sales days and understates demand. Exclude days you had no stock, or your reorder point comes out too low and you sell out again. We cover this in how stockouts distort your demand forecast.

Don’t forget stock on order

Compare the reorder point to stock on hand plus stock already on order. Otherwise you will place a second order while the first is still on its way.

Reorder point vs reorder quantity

The reorder point tells you when to order. How much to order is a separate decision. A simple approach is to order enough to cover the lead time plus the time until your next ordering cycle, then round to the supplier’s rules. If the supplier sells in cases of 12 or has a minimum order of 50, your order quantity has to respect that. See MOQs and case packs for how to round without overstocking.

Choosing a service level for each product

Using 99% for everything sounds safe but ties up a lot of cash in slow sellers. A practical approach is to rank products by sales value. Use a higher service level, such as 95 or 99%, for the few products that make up most of your revenue, and 90% for the long tail. The same ranking is used for ABC analysis. For more on the trade-off, read safety stock explained.

Doing it in a spreadsheet

With average daily sales in B2, lead time in B3, the sales standard deviation in B4 and the service level as a decimal (for example 0.95) in B5, the reorder point is:

=B2*B3 + NORM.S.INV(B5)*B4*SQRT(B3)

That works for a handful of products. It becomes hard to maintain across hundreds of variants, because the inputs change every week and stockout days have to be removed by hand.

How often to recalculate

Sales and lead times drift. Recalculate at least monthly, and straight away after a big change: a new supplier, a price change, a product going viral or a season starting. Seasonal products need demand measured from the same season, not the year-round average.

Try it

Use our free reorder point calculator to check your own numbers.

How Restocked helps

Restocked calculates reorder points with safety stock at 90, 95 or 99% service for every product in your Shopify store. It measures demand only on days you actually had stock, uses per-SKU lead times, rounds orders to MOQs and case packs, and counts open purchase orders toward stock. Every recommendation shows its math, so you can check the number before you spend money. The free plan covers 50 tracked variants and 2 suppliers.

Read next: Stocky Alternatives Compared: Purchase Order Apps for Shopify · Shopify Stocky Alternatives: What to Use Now Stocky Is Retired

FAQ

What is a good service level for a small store?

95% is a common default. Use higher for best sellers you can’t afford to run out of and lower for slow, low-value items.

Should the reorder point include stock on order?

Compare the reorder point with stock on hand plus stock on order. The reorder point itself does not change.

What if a product has only a few weeks of sales?

Use what you have, choose a slightly higher service level while data builds up, and recalculate more often for the first few months.