How to Calculate Reorder Quantities Accurately
A reorder quantity is not simply the amount that gets a SKU back in stock. It is the amount that will carry that SKU through the next supply cycle without creating a stockout, an avoidable surplus, or a purchasing decision that strains working capital. For operators managing growing catalogs across direct, marketplace, and wholesale channels, learning how to calculate reorder quantities means turning inventory data into a buying decision you can defend.
The calculation starts with demand, but it cannot end there. Demand can move, suppliers can be late, purchase orders can be partially received, and inventory may already be committed to a different warehouse or channel. A useful reorder quantity accounts for the full position of the SKU, not just the on-hand number in a warehouse report.
Start with the reorder decision, not a fixed formula
There are two related questions in every purchase cycle: Should I reorder now? and How much should I order? The first is governed by a reorder point. The second is governed by your target stock level, current inventory position, and supplier constraints.
A basic reorder point is:
`Reorder point = Expected demand during lead time + Safety stock`
If a product sells 20 units per day, has a 30-day supplier lead time, and requires 150 units of safety stock, its reorder point is 750 units:
`(20 × 30) + 150 = 750`
When available inventory reaches 750 units, it is time to consider a new order. But that does not mean you should automatically buy 750 units. The reorder point tells you when to act. The reorder quantity tells you what to buy.
How to calculate reorder quantities
The most practical approach is a target-stock calculation:
`Reorder quantity = Target stock level - Inventory position`
Your target stock level should cover expected demand through the period you want inventory to last, plus safety stock. Your inventory position should include more than physical stock on the shelf:
`Inventory position = On-hand inventory + Incoming inventory - Committed inventory`
For a product business, committed inventory may include confirmed wholesale allocations, open fulfillment orders, or stock reserved for a warehouse or sales channel. The right treatment depends on whether that inventory is genuinely available to cover the demand in your forecast.
Here is a straightforward example. You sell a SKU at an expected rate of 15 units per day. Its supplier lead time is 40 days. You want to hold 20 additional days of supply after receipt, and your safety stock is 120 units.
Your target stock level is:
`Expected demand for lead time + Review period + Safety stock`
`15 × (40 + 20) + 120 = 1,020 units`
You have 300 units on hand, 500 units on an open purchase order, and 80 units committed to wholesale orders. Your inventory position is 720 units:
`300 + 500 - 80 = 720`
Your preliminary reorder quantity is 300 units:
`1,020 - 720 = 300`
That answer is operationally useful because it reflects stock already on the way. A spreadsheet that ignores incoming inventory would suggest ordering 800 units, tying up cash in inventory you may not need.
Choose the right coverage period
The target stock level depends on how often you review and place orders. If you assess replenishment weekly, your coverage period usually includes supplier lead time plus roughly one review cycle. If you place orders monthly, it needs to cover lead time plus a longer review period.
This is where many fixed reorder-point systems become unreliable. They assume that the same reorder point works whether a buyer reviews stock daily or once each month. It does not. A SKU reviewed monthly needs more coverage than one watched closely every few days.
For a weekly buying process, a useful formula is:
`Target stock = Forecast daily demand × (Lead time days + Review period days) + Safety stock`
The review period is not extra padding. It represents the demand that can occur between the moment you place an order and the next time you are prepared to make another purchasing decision. Add too little, and you repeatedly expedite. Add too much, and slow-moving SKUs accumulate excess inventory.
Use a per-SKU forecast, not a single historical average
Average sales are a starting point, not a demand plan. A trailing 90-day average may hide a promotion, a seasonal change, a growing channel, or a recent decline. If wholesale orders arrive in batches, the average may also understate the lumpy demand that procurement needs to cover.
Use a per-SKU forecast that reflects the demand you expect during the relevant coverage window. For fast-moving SKUs, weekly forecasts may be more appropriate than monthly averages. For slower products, monthly demand may provide a more stable planning signal.
The decision depends on the SKU. A core replenishment item with steady demand can tolerate a relatively simple forecast. A seasonal product or a SKU with volatile marketplace demand needs more frequent review and a broader safety-stock policy. Treating every item with the same days-of-supply target is convenient, but it often shifts risk from the planning process to the warehouse and purchasing team.
Set safety stock based on risk, not habit
Safety stock protects against uncertainty in demand and supply. It should not be a blanket percentage applied to the entire catalog.
A practical starting point is to consider three sources of risk: forecast error, supplier lead-time variability, and the cost of a stockout. A high-margin bestseller with a supplier that is frequently late usually deserves more protection than a low-volume SKU that can be replenished quickly.
You can express safety stock in units or days of supply. Days of supply are often easier for operators to discuss because the trade-off is visible. Holding 14 days of safety stock for a stable item may be reasonable. Holding 60 days for every SKU can quietly consume a large amount of working capital.
Review safety stock separately from the reorder quantity. If every recommendation looks too high, do not immediately reduce purchase quantities across the board. Check whether your forecast, lead time, incoming inventory, or safety-stock assumptions are causing the result. A buying plan is only as credible as the policies behind it.
Apply supplier and purchasing constraints after the calculation
The calculated quantity is the demand-based answer. The final purchase order must also meet supplier realities, including minimum order quantities, case packs, order multiples, and supplier-specific ordering calendars.
Suppose the calculation recommends 300 units, but the supplier requires cases of 72. You may round to 288 or 360 units. The better choice depends on projected days of supply after receipt, cash availability, and the next opportunity to reorder. If 360 units pushes the SKU well beyond its target coverage, ask whether the supplier can accept a mixed order or whether a temporary exception is justified.
Do not let a minimum order quantity become the target stock level by default. MOQ rules are commercial constraints, not evidence of customer demand. When an MOQ consistently creates excess inventory, the operational answer may involve renegotiating pack sizes, consolidating buys across SKUs, or changing the reorder cadence.
Check the recommendation against timing and location
Before approving a reorder, test the result against the delivery date, not just the order date. A purchase order placed today may arrive after a projected stockout if lead time has slipped or if goods are waiting for transfer between warehouses.
For multi-warehouse operations, calculate inventory position at the location that serves the demand. Stock sitting in another facility may be available in total, but it is not immediately useful if a transfer takes a week and the fulfillment warehouse has three days of supply left. A transfer recommendation can be better than a purchase order when it protects availability without adding inventory to the network.
Also look at open purchase orders by expected receipt date. Incoming inventory that arrives after the risk window should not be counted as if it were already available. This is a common reason teams think they have enough stock until the actual delivery schedule proves otherwise.
Build a repeatable reorder review
A reorder calculation should produce a clear workflow: review stock risk, validate demand and lead-time assumptions, inspect incoming supply, then prepare the purchase decision. The operator should be able to see why a quantity was recommended and adjust it when commercial context requires a different call.
This is where a planning system is more useful than a historical report. Spark Inventory can combine a per-SKU forecast, on-hand and incoming inventory, supplier lead times, and inventory policies into a buying plan, then prepare draft purchase orders for operator review. The draft is a starting point, not an automatic commitment. The buyer adjusts and approves before anything is sent or committed.
A good reorder quantity is not the highest amount that avoids a stockout. It is the smallest well-supported buy that protects the required service level through the next replenishment cycle, while keeping inventory and cash exposure deliberate.