{"id":19559,"date":"2026-05-31T14:43:06","date_gmt":"2026-05-31T07:43:06","guid":{"rendered":"https:\/\/beup.space\/diem-dat-hang-ton-kho\/"},"modified":"2026-06-03T09:14:39","modified_gmt":"2026-06-03T02:14:39","slug":"diem-dat-hang-ton-kho","status":"publish","type":"post","link":"https:\/\/beup.space\/en\/diem-dat-hang-ton-kho\/","title":{"rendered":"Inventory Reorder Point: Why a Universal Minimum Stock Level is a Trap"},"content":{"rendered":"

Most businesses reorder when they see inventory running low. That's already too late. The time from ordering to receiving stock \u2014 called lead time \u2014 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<\/strong>, and how most SMEs set it \u2014 a universal minimum number for all items \u2014 is a trap that can be measured in monetary terms.<\/p>\n

Each order placed when stock hits zero is a firefighting moment<\/h2>\n

Inventory is working capital trapped between two opposing costs<\/strong>. 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 \u2014 you only feel them after paying the price.<\/p>\n

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<\/em>, 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<\/strong>. And the lever for that balance is the ordering timing, not the current inventory level.<\/p>\n

Seven minimum concepts to decide on correct ordering<\/h2>\n

Before calculating, we need to name things correctly. Here are the minimal vocabulary for the ordering problem:<\/p>\n

    \n
  • Lead time<\/strong> 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.<\/li>\n
  • Average daily demand<\/strong> is the average quantity sold per day for a specific item.<\/li>\n
  • Safety stock<\/strong> is the buffer inventory to counter fluctuations \u2014 when demand suddenly increases or suppliers are delayed.<\/li>\n
  • Reorder point (ROP)<\/strong> is the inventory level at which you must place a new order immediately.<\/li>\n
  • Days of Cover<\/strong> is current inventory divided by average daily demand \u2014 the number of days that can be sold without additional restocking.<\/li>\n
  • Order Quantity (EOQ)<\/strong> is the recommended quantity to order each time.<\/li>\n
  • Service Level<\/strong> is the percentage of demand that can be immediately fulfilled from inventory, without making customers wait.<\/li>\n<\/ul>\n

    A critical principle: days of cover must always be placed alongside lead time<\/strong>An item with 20 days of inventory might seem safe \u2014 until you learn its supplier takes 30 days to deliver.<\/p>\n

    Reorder Point Equation: Demand During Lead Time Plus Safety Stock<\/h2>\n

    This is the core thinking framework, and it's surprisingly concise:<\/p>\n

    Reorder Point = (Average Daily Demand \u00d7 Lead Time) + Safety Stock<\/strong><\/p>\n

    The first part \u2014 average daily demand multiplied by lead time \u2014 represents the inventory you'll sell while waiting for a new order. The second part \u2014 safety stock \u2014 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.<\/p>\n

    This operating method is called: continuous review model (s, Q)<\/strong>. You continuously monitor inventory; when inventory reaches level s (the Reorder Point), you order a quantity Q. It differs from periodic review (R, S)<\/strong> \u2014 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.<\/p>\n

    How is safety stock calculated? The simplest model \u2014 and sufficient for most SMEs \u2014 is safety stock = Safety factor \u00d7 Daily demand \u00d7 Lead time<\/strong>, 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<\/em> by Nahmias use statistical formulas z \u00d7 standard deviation of demand \u00d7 square root of lead time<\/strong>, 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\u1eebng<\/em> individual items instead of applying a universal number.<\/p>\n

    \"How much to order\" is a completely different question<\/h2>\n

    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.<\/p>\n

    The optimal order quantity is answered by EOQ (Economic Order Quantity)<\/strong>, 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.<\/p>\n

    In parallel with \"how much to order\" is \"which items to focus on\". This is the role of ABC classification<\/strong>, applying the Pareto principle: typically around 20% of items account for 80% of value. Group A \u2014 high-value items \u2014 deserve close review and careful ROP calculation. Group C \u2014 low-value items \u2014 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\u1eebng<\/em> the supplier \u2014 not a universal level.<\/p>\n

    A universal minimum stock level cannot be correct for both fast-moving and slow-moving items<\/h2>\n

    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 \u2014 and structurally incorrect.<\/p>\n

    The reason: Reorder Point (ROP) depends on two very different variables across product lines \u2014 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 \u2014 say, 100 \u2014 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.<\/p>\n

    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 \u2014 having too thin a buffer by assuming suppliers always deliver on time.<\/p>\n

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

    This is the most expensive and counterintuitive mistake, as it bypasses even those who track remaining stock days.<\/p>\n

    Imagine a product with 25 days of inventory. On the tracking board, it looks green \u2014 seemingly safe. h\u00f4m nay<\/em>But 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<\/strong> \u2014 and “days of stock” only make sense when compared to lead time.<\/p>\n

    In the tool's sample dataset, SKU-009 (5HP electric motor) has the longest lead time in the category \u2014 30 days \u2014 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 \u2014 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 \u2014 but that's exactly why the chart exists: to catch it as soon as it happens.)<\/p>\n

    Why tools are designed this way: from principle to each calculation cell<\/h2>\n

    Each component of the Inventory Reorder Point Tracker exists for a specific principle \u2014 and to block a particular mistake.<\/p>\n\n\n\n\n\n\n\n\n\n\n
    Component<\/th>\nPrinciple it realizes<\/th>\nMistake it prevents<\/th>\n<\/tr>\n<\/thead>\n
    Setup Sheet (safety factor, default lead time, long-standing inventory threshold)<\/td>\nA single data source<\/td>\nScattered hardcoded parameters, lacking consistency<\/td>\n<\/tr>\n
    SKU Inventory Sheet with ROP, safety stock, and order quantity as a living formula<\/td>\nROP equation + continuous review, calculated for each product code<\/td>\nA single minimum stock level for all items<\/td>\n<\/tr>\n
    KPI “Number of SKUs to order now” (count of items with stock \u2264 ROP)<\/td>\nIndicators driving action<\/td>\nReport lacking a clear number saying “what to do today”<\/td>\n<\/tr>\n
    Priority ordering chart (red = below safety stock, amber = below ROP)<\/td>\nCategorized by urgency level<\/td>\nTreating all codes equally, no priority order<\/td>\n<\/tr>\n
    Scatter plot of remaining stock days versus lead time<\/td>\nRemaining stock days always placed next to lead time<\/td>\nLong lead trap \u2014 stockouts despite seemingly normal inventory<\/td>\n<\/tr>\n
    Order action list<\/td>\nWhat to order, how much, and from which supplier<\/td>\nOrder decisions based on intuition<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    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 \u2014 therefore<\/em> 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 \u2014 numbers that transform a static spreadsheet into a daily decision.<\/p>\n

    Frequently asked questions<\/h2>\n

    What is a reorder point?<\/h3>\n

    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 \u00d7 lead time) + safety stock.<\/p>\n

    How is the reorder point calculated?<\/h3>\n

    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 \u2192 ROP = 18 \u00d7 5 + 30 = 120 units.<\/p>\n

    When should you reorder?<\/h3>\n

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

    How is safety stock calculated?<\/h3>\n

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

    Why you shouldn't use a single minimum inventory level for all items?<\/h3>\n

    The reorder point depends on daily demand and lead time \u2014 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.<\/p>\n

    \n

    You can view the entire logic operating directly on the demo dashboard: Inventory Reorder Point Tracker on BEUP Canvas<\/a> \u2014 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<\/a>.<\/p>\n