Inventory Reorder Point: Why a Universal Minimum Stock Level is a Trap

9 min read

Most businesses reorder when they see inventory running low. That's already too late. The time from ordering to receiving stock — called lead time — is a blind spot: demand continues, but the warehouse isn't replenished. The crucial decision isn't 'how much is left,' but 'at what level should you order.' This level is called reorder point, and how most SMEs set it — a universal minimum number for all items — is a trap that can be measured in monetary terms.

Each order placed when stock hits zero is a firefighting moment

Inventory is working capital trapped between two opposing costs. On one side are stockout costs: lost orders, production stops, urgent ordering at high prices and rush shipping fees. On the other side are inventory holding and excess costs: capital frozen on shelves, warehouse rental, outdated or damaged goods. What makes both dangerous is that they rarely appear clearly on profit and loss statements — you only feel them after paying the price.

Ordering when inventory is near 0 means you've unconsciously chosen to save on holding costs, at the expense of stockouts. Each stockout is a fire to put out: calling the supplier to ask for expedited shipping, accepting higher prices, or watching customers leave. In classic textbooks Inventory Management and Production Planning and Scheduling, Silver, Pyke, and Peterson point out that good inventory management is not about keeping the least or the most, but balancing these two costs at the lowest total cost point. And the lever for that balance is the ordering timing, not the current inventory level.

Seven minimum concepts to decide on correct ordering

Before calculating, we need to name things correctly. Here are the minimal vocabulary for the ordering problem:

• Lead time is the number of days from order placement to when goods arrive at the warehouse and are ready for sale. This is the blind spot that must be covered by inventory.
• Average daily demand is the average quantity sold per day for a specific item.
• Safety stock is the buffer inventory to counter fluctuations — when demand suddenly increases or suppliers are delayed.
• Reorder point (ROP) is the inventory level at which you must place a new order immediately.
• Days of Cover is current inventory divided by average daily demand — the number of days that can be sold without additional restocking.
• Order Quantity (EOQ) is the recommended quantity to order each time.
• Service Level is the percentage of demand that can be immediately fulfilled from inventory, without making customers wait.

A critical principle: days of cover must always be placed alongside lead timeAn item with 20 days of inventory might seem safe — until you learn its supplier takes 30 days to deliver.

Reorder Point Equation: Demand During Lead Time Plus Safety Stock

This is the core thinking framework, and it's surprisingly concise:

Reorder Point = (Average Daily Demand × Lead Time) + Safety Stock

The first part — average daily demand multiplied by lead time — represents the inventory you'll sell while waiting for a new order. The second part — safety stock — is a buffer for days with faster sales or delayed deliveries. Together, ROP precisely answers the question: at what level should you place a new order just as the old inventory is about to run out.

This operating method is called: continuous review model (s, Q). You continuously monitor inventory; when inventory reaches level s (the Reorder Point), you order a quantity Q. It differs from periodic review (R, S) — only checking according to a fixed schedule (e.g., every Monday) and then replenishing to a ceiling level. Continuous review responds faster to fast-selling items; periodic review is more streamlined in operations but accepts a blind spot between checks.

How is safety stock calculated? The simplest model — and sufficient for most SMEs — is safety stock = Safety factor × Daily demand × Lead time, with the safety factor typically set around 1.5 and fine-tuned according to the item's criticality. At an advanced level, textbooks like Production and Operations Analysis by Nahmias use statistical formulas z × standard deviation of demand × square root of lead time, where z reflects the target service level. You don't need to start with an advanced level; you need to start by calculating ROP for từng individual items instead of applying a universal number.

"How much to order" is a completely different question

that ROP answers "when to order". It doesn't say "how much". This is a separate problem, and combining the two questions into one is a common mistake.

The optimal order quantity is answered by EOQ (Economic Order Quantity), the Ford Harris formula proposed in 1913 and later associated with Wilson. EOQ balances two opposing costs: ordering frequently in small quantities increases ordering costs (processing orders, shipping, verification); ordering less frequently in large quantities increases inventory holding costs. The intersection point of these two curves represents the order quantity with the lowest total cost.

In parallel with "how much to order" is "which items to focus on". This is the role of ABC classification, applying the Pareto principle: typically around 20% of items account for 80% of value. Group A — high-value items — deserve close review and careful ROP calculation. Group C — low-value items — can be managed more loosely. Best practice is to fine-tune safety factors based on item importance and supplier reliability, and set ROP according to the lead time of từng the supplier — not a universal level.

A universal minimum stock level cannot be correct for both fast-moving and slow-moving items

This is the crux of the issue. Most SMEs manage inventory using a single "minimum inventory level" applied to all items: when inventory falls below X, they order. It's simple, easy to remember — and structurally incorrect.

The reason: Reorder Point (ROP) depends on two very different variables across product lines — daily demand and lead time. A product selling 100 units per day with a 3-day lead time needs an ROP around 300 plus buffer. A product selling 2 units per day with a 30-day lead time needs an ROP around 60 plus buffer. A common number — say, 100 — will cause the fast-selling product to constantly run out of stock (ordering too late) and the slow-selling product to have excess inventory (ordering too early, capital unnecessarily tied up). You lose on both ends simultaneously.

The gap between common practice and best practice lies exactly here: instead of a universal level, calculate ROP individually for each product code based on its corresponding supplier's lead time; review the entire catalog weekly and review fast-moving or long-lead groups daily. Ignoring lead time variations is another form of the same mistake — having too thin a buffer by assuming suppliers always deliver on time.

The long-lead trap: looking like there's "enough inventory" but still running out of stock before the order arrives

This is the most expensive and counterintuitive mistake, as it bypasses even those who track remaining stock days.

Imagine a product with 25 days of inventory. On the tracking board, it looks green — seemingly safe. hôm nayBut if its lead time is 30 days, even when you order, new stock will only arrive after inventory has been depleted for 5 days. This product is already in a pre-programmed stockout state, despite the inventory numbers looking fine. The principle to draw: the longer the lead time, the earlier you must order compared to when you feel you need to — and “days of stock” only make sense when compared to lead time.

In the tool's sample dataset, SKU-009 (5HP electric motor) has the longest lead time in the category — 30 days — and has fallen below the safety stock level. It must be ordered first, as replenishing it takes a full month; waiting longer means risking a month of stockouts. On the other hand, SKU-001 (steel bolt) has about 42 days of stock — which is idle on the shelf while other items need the money to be ordered. A scatter plot that puts “days of stock” on one axis and “lead time” on the other is a tool to detect this trap: any point that lies beyond the lead time exceeding the days of stock is a time bomb. (In this sample dataset, no items fall into that category — but that's exactly why the chart exists: to catch it as soon as it happens.)

Why tools are designed this way: from principle to each calculation cell

Each component of the Inventory Reorder Point Tracker exists for a specific principle — and to block a particular mistake.

This is not a feature list. It's a chain of reasoning: operations follow the ROP equation, best practices require specific codes and lead time tracking, common mistakes stem from overlooking these two things — therefore tools are built precisely in this shape. In the illustrative dataset: 6 out of 10 codes need ordering, 3 codes are below safe inventory, total order value is around 490 million VND, against a total inventory of about 723 million VND — numbers that transform a static spreadsheet into a daily decision.

Frequently asked questions

What is a reorder point?

Reorder Point (ROP) is the inventory level at which a business must immediately place an order to ensure new stock arrives before the existing inventory is depleted. Formula: ROP = (average daily demand × lead time) + safety stock.

How is the reorder point calculated?

The reorder point equals average daily demand multiplied by lead time (delivery days), plus safety stock. For example: selling 18 units/day, 5-day lead time, 30 safety stock → ROP = 18 × 5 + 30 = 120 units.

When should you reorder?

Reorder immediately when current inventory reaches or drops below the item's reorder point — not when inventory is near zero. For items with long lead times, order even earlier due to extended delivery periods.

How is safety stock calculated?

Simple method: safety stock = safety factor × average daily demand × lead time, with the factor typically around 1.5. Advanced statistical method: z × demand standard deviation × square root of lead time, where z reflects the target service level.

Why you shouldn't use a single minimum inventory level for all items?

The reorder point depends on daily demand and lead time — two variables that vary significantly between different products. A universal number will cause fast-selling items to run out of stock while slow-moving items simultaneously accumulate excess inventory. Each product code requires a unique Reorder Point (ROP) based on its specific supplier lead time.

You can view the entire logic operating directly on the demo dashboard: Inventory Reorder Point Tracker on BEUP Canvas — which items need immediate reordering, the required expenditure, which codes are below safe inventory levels, and a chart detecting long lead time traps. Complete Excel + Google Sheets tool: Inventory Reorder Point Tracker.