Blog · Territory, capacity and quota planning · Supply chain
Inventory reorder level is expected demand during replenishment lead time plus safety stock. Work it from usage and receipt exports, compare it with inventory position, and check the assumptions before changing a workbook threshold.
Inventory reorder level is expected demand during replenishment lead time plus safety stock. It tells a buyer when stock needs a replenishment decision; the amount to buy is a separate calculation. A useful threshold starts with consistent usage and supplier receipt rows, then checks stock already on order before raising another purchase request.
Inventory reorder level = Expected demand during lead time + Safety stock
With steady average usage: Reorder level = Average daily demand × Replenishment lead time in days + Safety stock
The daily-demand version assumes the average rate is a reasonable estimate for the coming replenishment period. Seasonal demand, a known customer order, or a promotion may require a dated demand plan instead. Safety stock covers uncertainty around the expected demand; it is not another copy of ordinary lead-time usage.
MIT's inventory management lecture presents a threshold as expected demand over the relevant protection period plus a variability allowance. It also highlights demand versus sales, lead-time collection, and ownership of service levels as practical input problems.
Keep the time interval explicit. A continuously monitored reorder point covers replenishment lead time. A policy that only reviews stock at fixed intervals must also address the wait until the next review; the base-stock inventory method explains that different target.
Work at SKU and stocking location level. A company total can hide a shortage at the site that actually serves the customer.
| File | Rows and fields needed | Check before calculating |
|---|---|---|
| Usage export | Date, SKU, location, quantity requested or consumed, unit | Separate demand from transfers and adjustments |
| Purchase and receipt export | PO line, release date, usable receipt date, received quantity | Match partial receipts and exclude canceled balances |
| Stock snapshot | As-of date, SKU, location, usable on-hand quantity | Keep inspection holds outside usable stock |
| Open commitments | Open inbound units and unfilled customer demand at the same cutoff | Remove duplicates and completed lines |
| Policy workbook | Approved safety stock, current threshold, calendar basis | Retain the approval and effective date |
Shipments can understate demand during a stockout because an unavailable unit cannot ship. Use customer requests or a supported lost-demand adjustment where available. For an item that has no usable demand history, mark the input as missing and route it for review rather than treating the blank as zero.
Lead time runs from the policy's order-release event until the stock can be used. If receiving inspection delays availability, the dock arrival date is too early. The distinction matters even when the supplier ships on time.
An Ohio industrial distributor reviews a seal stocked at its Columbus location. The short history below is deliberately small so every input is visible; a production review would use an appropriate history and examine variation.
| Operating day | Demand (units) |
|---|---|
| Monday | 80 |
| Tuesday | 100 |
| Wednesday | 120 |
| Thursday | 90 |
| Friday | 110 |
| Total | 500 |
| Completed PO receipt | Lead time (operating days) |
|---|---|
| Receipt A | 3 |
| Receipt B | 4 |
| Receipt C | 5 |
The buyer supplies approved safety stock of 150 units. The calculation is:
| Step | Calculation | Result |
|---|---|---|
| Average daily demand | 500 / 5 | 100 units |
| Average lead time | (3 + 4 + 5) / 3 | 4 operating days |
| Expected lead-time demand | 100 × 4 | 400 units |
| Add approved safety stock | 400 + 150 | 550 units |
The proof is the difference: 550 − 400 = 150 units, exactly the approved buffer. The inventory safety stock formula covers how a buffer can be assessed; this example uses a supplied policy input rather than presenting the buffer as an optimized result.
If the buyer changes the lead-time assumption to the observed five-day receipt, while keeping demand and safety stock unchanged, the threshold becomes 100 × 5 + 150 = 650 units. That is a sensitivity check, not proof that the largest observed lead time is the right planning input.
Physical stock alone omits material already ordered and obligations already waiting. MIT's manufacturing inventory notes distinguish inventory position from physical inventory and separate the reorder trigger from the purchase quantity.
For this example, there are no separately reserved commitments beyond the backorders shown:
| Component at the review cutoff | Units | Treatment |
|---|---|---|
| Usable on hand | 390 | Add |
| Open inbound supply | 200 | Add |
| Unfilled customer backorders | 60 | Subtract |
| Inventory position | 530 | 390 + 200 − 60 |
| Reorder level | 550 | Compare with position |
| Position below threshold | 20 | 550 − 530 |
The position is below the trigger, so the buyer reviews replenishment. The 20-unit difference is not automatically the purchase quantity. Pack sizes, order economics, and the approved replenishment policy determine that quantity.
Also inspect the inbound due date. A valid open order can still arrive too late to protect near-term demand. Keep it in the inventory-position reconciliation and flag its timing separately rather than silently deleting it to force a purchase signal.
Bring your usage export, supplier lead-time history, stock snapshot, and approved safety-stock inputs. Covirage maps the columns, and its tools compute and check the thresholds and inventory-position comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for supply chain teams for the wider business context.
Reorder level is the threshold used to decide when replenishment needs attention. Reorder quantity is the amount purchased after that trigger. A supplier minimum, pack size, or economic order quantity can affect the quantity without changing the meaning of the trigger.
A threshold intended to protect against demand or delivery variation normally includes an approved safety buffer. Keep that buffer separate from expected lead-time demand so reviewers can see which assumption changed and whether the service objective still supports it.
Either basis can work when demand and lead time use the same clock. If usage is measured per operating day, convert supplier lead time into operating days too. Document holidays, receiving closures, and inspection time before comparing the two inputs.
Choose a review cadence that matches changes in demand, supplier performance, and the cost of a shortage. Also review after a promotion, sourcing change, repeated expedite, or stockout. A regular workbook review and the frequency of checking a replenishment trigger are different decisions.