MOGA World
MOGA World blog

Reorder Point Formula: When to Order, in 3 Lines and a Template

You sell something that sells every day, and twice you have looked up and found the shelf empty. The reorder point is the number that stops that: the stock level at which you place the next order. This article gives you the formula in three lines, one product worked through with every step of the arithmetic, and the mistakes that make the number wrong.

Short on time? The free sample page shows the stock check as one decision, with its reason and a Go button: See the free sample page

What the reorder point is

The reorder point is the number of units left at which you place a new order, so that the delivery arrives before you run out. Formula: reorder point = (average units sold per day × supplier lead time in days) + a buffer. When stock drops to that number, order. Not when the shelf looks thin, and not on a fixed day of the month.

It answers one question only: when. How many to order is a separate number, covered further down.

The reorder point formula in 3 lines

  1. Units sold per day. Total sold in the last 30 days, divided by the days you actually had stock.
  2. Lead time in days. From the day you place the order to the day the units are on your shelf and can be sold.
  3. Reorder point = line 1 × line 2, plus a buffer. The buffer covers a sales spike or a late delivery. A simple starting buffer is half of line 1 × line 2, which is the same as multiplying by 1.5.

The safety stock calculation behind the buffer has its own article: the safety stock formula. Until you have read it, the 1.5 multiplier is a workable place to start.

A worked example, step by step

Sample product, invented numbers. You sold 180 units in the last 30 days, and the product was in stock on all 30 days. The supplier takes 21 days from order to your shelf.

StepArithmeticResult
1. Sold per day180 ÷ 306 units a day
2. Sold during the lead time6 × 21126 units
3. Buffer, half of step 2126 × 0.563 units
Reorder point126 + 63 (or 6 × 21 × 1.5)189 units

Read it as a timeline. Stock falls by 6 a day. At 189 you place the order. Over the next 21 days you sell 126 units, so the delivery lands with 63 left. The buffer is what is still on the shelf when the truck arrives.

A line chart of one sample product: stock falls from 300 units at 6 a day, hits the 189 unit reorder point on day 18.5, and reaches the delivery on day 39.5 with 63 units left as a buffer
One reorder cycle with the numbers above. The order goes in at 189, and the 21 day wait uses 126 units, leaving the 63 unit buffer.

What happens if you order at 50 instead of 189

Ordering at 50 units leaves you out of stock for about 13 days on this product. At 6 a day, 50 units last 50 ÷ 6 = 8 days. The delivery takes 21 days. 21 minus 8 is 13 days with nothing to sell.

Two bars compared for the same product: ordering at 189 units keeps stock for all 21 days of lead time, ordering at 50 units gives 8 days of stock then about 13 days out of stock
The same product with two reorder points. Thirteen days at 6 a day is about 76 units you could have sold.

Ordering at 50 feels safe when you look at the shelf, because 50 units still looks like plenty. The shelf does not show the 21 days between the order and the delivery. The formula does.

On video: why your stock will run out in 8 days. Watch on YouTube.

Which numbers to use, so the result is not wrong

The formula is simple. The inputs are where it goes wrong.

Already below your number today? Order now. You cannot get the missing days back, but every day you wait adds one more day without stock. If a supplier is new and you have no real lead times yet, use their quote plus 30 percent until you have three.

Reorder point versus order quantity

The reorder point says when to order. The order quantity says how many. A common starting quantity is the sales of the next full cycle: 6 a day × the days you want one order to last, minus what will still be on the shelf on arrival. Your supplier’s minimum order can override it.

A weekly stock check is where both numbers get used: for each product, compare units left to its reorder point, and write a card for every product that is at or below it.

Three Reorder this week cards on a sample board, each with units left and a suggested order quantity, marked Added by AI
What a finished stock check leaves behind on a sample board: one card per product that is at its reorder point. The quantity is a suggestion, the order is yours.

When to recalculate

A reorder point template you can copy

One row per product is enough. Three numbers you fill in, one the sheet works out.

ProductSold in 30 daysDays in stockLead time (days)Reorder pointRule
Sample product1803021180 ÷ 30 × 21 × 1.5 = 189Order when units left is 189 or less

In a spreadsheet the reorder point cell is =B2/C2*D2*1.5. On the Operations board the same rule sits on the stock check card, so a product at or below its number becomes a card with a due date. A card without a due date does not get done, which is why the check creates them with one.

Where it stops

How I use it

I spent six years running ecommerce businesses, and a stockout on a best seller taught me the lead time lesson faster than any article. The rule above is the one the stock check on my own boards uses. How I run MOGA with the same method is on How MOGA is run, and the other five weekly procedures are in the ecommerce SOP template article.

See the stock check as one decision, free

The free sample page shows a stock check as one decision with its reason and a Go button. No signup, and nothing you press is sent. The free starter board, the Trello version with the stock check card, is the email step behind it.

The free sample decision page: three steps (see what to do and why, check the facts, click Go or Skip) beside a phone view of one decision row for a demo business
The free sample decision page: three steps and one decision row, with sample data. Nothing you press is sent.

See the free sample page

Want the whole weekly routine? It is in the packs. If you want Claude to run the check for you, this article shows how.

MOGA World is independent and not affiliated with Anthropic or Atlassian. Sample businesses and numbers in this article are invented. Questions: stef@mogaworld.co