Reorder Point Calculator

Inventory management: The shelf appear to be stocked, right up until it’s not. That’s what keeps you up at night. You’ll look at the rack of spare parts or box of coffee beans and tell yourself there’s no reason to worry, plenty of time before you run low. Next thing you know, someone orders extra during a holiday sale, your supplier was late shipping by three days, and now you’re looking at a pile of backorders.

The reorder point is the line in the sand. It lets you know precisely when to place an order so that new batch just arrives when old one empties. The formula for this number isn’t guesswork. Calculating this threshold require accounting for average daily demand and time it takes for goods to travel from the dock to your shelf.

How to Calculate Your Reorder Point

However, the true challenge come with variation. When customer purchases is always consistent at 42 units and delivery times are always perfect at 14 days, you can input a fixed amount and go on your way. The world is not so clean. Lead times fluctuate because of port congestion or vendor backlogs. Marketing promotions and weather can cause demand fluctuations.

After plugging in your figures, the calculator above will do the math for you, eliminating boring algebra of squaring roots and standard deviations. Then it’ll boil down the madness into one actionable figure. And how much buffer you have are determined by which service level you select.

For most warehouses and retail operations, default setting is a service level of 95%. You’re fine with going out-of-stock about one time in every twenty times you need something restocked. Move that up to 99%, and your required safety stock go way up. And it doesn’t do so at a linear rate. It does so exponentially. This imposes a lot of pressure on your cash flow.

The tool let you instantly visualize this tradeoff. It allows you to see that when you ask for near perfect availability on something that has low margin, you are almost always paying more than the value of lost sale itself. Most people fail to realize this. They think everything you stock carries equal value. So if you go out-of-stock on a $200 gadget, that’s just an ego-bruising inconvenience. But if you run out of a $2 screw, you can kill a machine.

This is where supplier reliability comes into play so much. Do you have goods shipped across the ocean? You need to consider the inconsistency of freight and time it takes goods to pass through customs. You can adjust for supplier variability profiles by applying multipliers that reflect their actualy behavior. For example, if you have a reliable local supplier, then you might not need as many buffers compared to an unreliable overseas supplier.

Why does that matter? This prevents you from insuring too little against a risky lane (meaning you’re underinsured) or too much against a reliable one (you’re wasting capital by paying for insurance). The page has a reference table which outline these different behaviors of your suppliers and the impact on amount of stock you should hold.

It’s all about paying for certainty with your capital. It also changes the game when it comes to review cycles. Do daily inventory checks make you nimble? Or do you review monthly? In the latter case, your order-up-to level has to be way higher to fill the gap. That’s what they call cycle stock (versus safety stock).

Planners mix these up all the time. Safety stock is for the unexpected. Cycle stock is for the regular time between orders. Mix those up and you end up with an empty shelf or warehouse overflowing with slow moving stuff.

The quality of your data matters. GIGO means garbage in, garbage out. Did you have an unusually promotional period in history? Was there a shutdown? Your average will be skewed by that data. First, clean the history. What was the data like for the past six months to a year when things were running smoothly?

Measure lead time starting with confirmation of purchase order, not when it’s written. These are minor operational points but far more important than the formula itself. The input data matters. And since the math is only as good as the input, make sure that input is good.

So, all told, it’s about balance. How do you get the most availability of products for your customer but also minimize amount of cash sitting inside a box? There is no right answer. You can only find a defensible answer given the reality of your supply chain and your personal level of risk tolerance.

That’s what the calculator gives you. Clarity to do something vs. The paralysis to wait. If you don’t know where to begin, try some conservative assumptions, then update as you get actual receipts in. Eventually, the figures will firm up. What once felt like a mystery shelf will behave like a system. When you know the line you draw, the panic subsides.