Guide · stock control for small businesses

Reorder point and safety stock: how to set them for every item

The reorder point tells you when to order new inventory: when the stock of an item falls to it, you order again. Safety stock is the backup stock needed to meet late deliveries or sudden changes in demand. It is the part of the reorder point that you hope never to sell.

Reorder point = daily demand × lead time + safety stock

Why the timing matters

Leave the order too long and you'll run out of stock. Go too early and you'll pile up more inventory than you need. The reorder point sits between the two: the stock that sells while the order travels, plus a buffer for the days when it travels slowly or sells fast.

The formula has three inputs. Each one comes from your own records, not from a rule of thumb.

InputWhat it isWhere you get it
Daily demandThe units of the item you sell on an average daySales of the last 8 to 13 weeks, divided by the days the shop was open
Lead timeThe days from the purchase order to the goods on the shelfThe dates of your past purchase orders and receipts
Safety stockThe buffer for slow deliveries and busy daysThe service level you choose and how much the daily sales swing

Some suppliers have delivery lead times of many days or weeks. Use the time that the goods really took, not the time on the price list. Sales levels are subject to fluctuations over time, so an average alone gives a reorder point that runs out in every week busier than average. That is the job of the safety stock.

How to set reorder points for every item, in six steps

  1. Take the recent sales of each item. Eight to thirteen weeks is a good window: long enough to smooth out a quiet week, short enough to follow a trend. Leave out a one-off bulk order, or it will raise the reorder point for months.
  2. Use the right season. Seasonality is critical for forecasting your stock requirements. For a garden hose in May, take the sales of last May and June, not the average of the year.
  3. Measure the lead time of each supplier. Take the last five or six orders and count the days from the order date to the receipt date. When the supplier is sometimes late, use a figure near the slow end.
  4. Choose a service level for each item. The service level is the chance that the stock lasts until the order arrives. High service levels may require a large safety stock for each item, so do not give every item the same one.
  5. Calculate the safety stock. Safety stock is designed to cover a shop's needs while it places an order with the supplier and waits for the order to arrive. With the service level: safety stock = z × σ × √lead time, where σ is the standard deviation of the daily sales and z comes from the service level (table below).
  6. Enter the result and review it. Then set reorder points for each product. The reorder points should be reviewed regularly: once a quarter, and at once when a supplier or the sales of an item change.

Which service level for which item

ABC analysis is a commonly used method that helps to identify your most valuable items. Class A items, for example, should rarely (if ever) run out and be given the highest priority and focus, while C items may not warrant quite so much attention.

ClassShare of sales valueService levelz
AAbout 80 % from the top 20 % of items98 %2.05
BAbout 15 %95 %1.65
CAbout 5 %90 %1.28

The last points of service cost the most. For an item that sells 5 a day with σ = 2.5 and a 10-day lead time, the safety stock grows like this:

Service level90 %95 %98 %99 %99.9 %
Safety stock10.113.016.218.424.4
Reorder point6164676975

Going from 90 % to 95 % costs 3 units. Going from 99 % to 99.9 % costs 6 more, for one stock-out in a thousand order cycles instead of one in a hundred. To get the class of each item, run the ABC analysis on your sales.

Worked example: three items in a hardware shop

The shop buys screws and paint rollers from a wholesaler that delivers in 10 days, and ladders from a factory that delivers in 14 days. The daily demand and σ come from the last 13 weeks of sales.

ItemClassDaily demandσLead timezSafety stockReorder point
Wood screws 4×40, boxA18610 days2.0538.9219
Paint roller 25 cmB52.510 days1.6513.064
Step ladder, 3 stepsC0.40.714 days1.283.49

For the screws: 2.05 × 6 × √10 = 38.9 boxes of safety stock. The reorder point is 18 × 10 + 38.9 = 218.9, rounded up to 219. When the stock plus the boxes already on order falls to 219, the shop orders again.

Look at the safety stock as a share of the demand during the lead time: 22 % for the screws, 26 % for the rollers and 60 % for the ladders. The screws sell every day in similar numbers, so a small buffer covers them. The ladders sell one on some days and none for a week, so the buffer must be large compared with the sales.

With one rule of 7 safety days for every item, the screws would carry 126 boxes of safety stock instead of 39, and the ladders 2.8 instead of 3.4. The shop would hold 87 more boxes of screws and still run out of ladders more often.

The reorder point calculator and the safety stock calculator do the same arithmetic for one item, and add the review period when you check the stock once a week rather than every day.

Six mistakes that make reorder points wrong

  1. Mixed units. Weekly demand times a lead time in days gives a reorder point seven times too high. Put both in days.
  2. Stock on hand only. Compare the reorder point with the stock on hand plus the stock already on order. Otherwise the item is ordered again every day until the first delivery comes.
  3. The same safety days for every item. As the example shows, it gives too much stock of the steady sellers and too little of the irregular ones.
  4. Set once, never changed. If demand drops permanently, safety stock levels will be too large and may represent a risk of obsolescence. When sales grow, the same reorder point runs out.
  5. The promised lead time. Shortages occur if the delivery time is longer than the cover of the safety stock. Use the days the goods really took.
  6. Wrong stock figures. A reorder point is only as good as the stock it is compared with. Entering inaccurate information will quickly eliminate any degree of accuracy in the inventory records, resulting in many physical counts to correct the problem. See how to do a stock count.

Reorder point, min-max or EOQ?

They answer different questions and work together. The reorder point says when to order. If inventory position falls below the minimum at the beginning of a period, an order is issued to bring the inventory position up to the maximum: that is min-max, and the minimum is the reorder point. The economic order quantity says how much to order when ordering and storage both cost money.

MethodAnswersBest forFree tool
Reorder pointWhen to orderEvery stocked itemReorder point calculator
Min-maxWhen to order and up to which levelShops that order from a list each day or weekMin-max calculator
EOQHow much to orderItems with a high order cost or a high storage costEOQ calculator

Reorder points in Golden Inventory System 5

Many inventory systems contain a flag in the item record, indicating that the system should create a purchase order to replenish stock when a minimum level is reached. In System 5 each item has a minimum and a maximum quantity. The minimum is your reorder point; the maximum is the level to order up to.

System 5 does not calculate the minimum for you: use the steps above, or the calculators, and type the result.

Questions

How often should I recalculate reorder points?

Once a quarter for most items. If the minimums are based on past sales, they should be revised as the recent sales trend indicates a change in demand.

What if the supplier's lead time varies?

Then the safety stock must also cover the slow deliveries. The simple way is to use the longest lead time you see often in the last orders, not the single worst one.

Is the reorder point the same as the minimum stock level?

In most inventory programs, yes. The minimum is the stock level at which the item appears on the list of items to order.

Does every item need a reorder point?

No. Items made to order, or bought for one customer, have no minimum. Give them a minimum of zero so that they never appear on the reorder list.

Which service level should a small shop use?

Most small shops do well with 98 % for class A items, 95 % for class B and 90 % for class C. Raise it for an item whose stock-out sends the customer to a competitor.

Can the safety stock be zero?

Yes, when the sales are steady and the supplier always delivers on time, or when a stock-out costs nothing because the customer waits. For most shop items one of the two is not true.

Let the program watch the minimums

Golden Inventory System 5 is a Windows program that you pay for once: $99 for up to 5 users, $199 for any number. Its Overview shows the items to order every morning.