Reorder point, minimum and maximum stock levels — how to set them

What a reorder point is

A reorder point is the stock level at which a new order should be placed so that replenishment arrives before stock runs out. The standard formula is reorder point = (average daily consumption × lead time in days) + safety stock. In an inventory system the reorder point is held per item on the item master as the item's minimum level; the moment on-hand stock touches or falls below it, the item is flagged on the reorder dashboard as due for replenishment.

Paired with it is the maximum level — the ceiling replenishment should not push stock past. Minimum and maximum together define the band each item should live inside: order when you touch the bottom of the band, and order a quantity that takes you towards — not beyond — the top. One protects service; the other protects cash and shelf space.

The reorder point formula, unpacked

Each term in the formula is knowable from records you already have:

• Average daily consumption — total quantity issued over a recent period divided by working days. This comes straight out of the stock ledger's movement history, which is why reorder discipline depends on capturing every issue and receipt at source.
• Lead time — the days from placing an order to goods being received and usable. Use the realistic figure, including supplier delays, transport and inward inspection — not the figure printed on the quotation.
• Safety stock — the buffer for the bad week. The simplest practical method: (maximum daily consumption × maximum lead time) − (average daily consumption × average lead time). It covers demand running high at the same time as a delivery running late.

Safety stock is the term teams most often get wrong in both directions. Too little and every supplier delay becomes a stockout; too much and the buffer silently becomes dead weight in the valuation report. The honest approach is to compute it, then audit it twice a year against reality: stockouts on the item mean the buffer is too thin, stock that never dips below the safety line means it is too fat.

Minimum and maximum levels — the band, not just the trigger

Min/max control is the working discipline built on the reorder point:

The order quantity connects the two ends of the band. A common approach is to order roughly up to the maximum: order quantity ≈ maximum level − current stock − quantity already on order, rounded to the item's order multiple and at least its minimum order quantity. Note the "already on order" term — ignoring open purchase orders is how the same shortage gets ordered twice.

Where the levels live — the item master fields

Reorder control is only as systematic as the master data behind it. In Fast Inventory Software each item carries the full set of planning fields on the item & material master:

• Minimum level — the reorder point the dashboard watches, and maximum level — the replenishment ceiling.
• Lead time — the supplier lead-time input to the reorder point.
• Minimum order quantity and order multiple — so the suggested buy respects supplier pack sizes instead of ordering seventeen of something sold in boxes of ten.
• On-hand, reserved and ordered quantities — the live picture the levels are compared against, maintained by the running stock balance.

Because the levels sit on the same item record that every movement posts against, there is no separate "planning file" to fall out of date — the comparison of stock against minimum happens on live data.

The reorder dashboard — levels turned into action

Levels on a master record do nothing by themselves; the point of holding them in software is that the comparison runs continuously. Fast Inventory's reorder-level and replenishment dashboards check every item's current stock against its minimum and flag everything at or below it — the buyer opens one screen and sees the day's replenishment worklist, rather than paging through an item list hoping to notice shortages. Alerts can also go out by email, so a reorder breach is pushed to the buyer rather than waiting to be found.

Because stock is a running balance updated at every commit point — receipt, issue, return, transfer, adjustment — the dashboard needs no batch job or manual refresh to be right. That is the practical difference between levels in an inventory system and levels in a spreadsheet column: the spreadsheet compares against a number somebody last typed; the dashboard compares against the ledger. The pillar guide explains that running-balance model in full.

Setting policy by ABC class

Not every item deserves the same reorder rigour, and ABC analysis is the natural way to grade it:

• A items — tight minimums computed from fresh consumption and lead-time data, reviewed every quarter, and a same-day response when they hit the dashboard. These are the items whose stockout stops revenue.
• B items — standard formula-set levels, reviewed half-yearly, replenished on the normal buying cycle.
• C items — generous bands set once, bulk-bought against the maximum, revisited only when the non-moving report or a stockout says otherwise.
• Critical spares — whatever their value class, items that stop a line when missing get an exception buffer. Value ranks money; it does not rank consequence.

Common mistakes

• Levels set once, never revisited. Consumption doubles, a supplier's lead time stretches, and a minimum set two years ago quietly becomes a stockout generator. Review A-item levels quarterly.
• Trusting a stock figure that is wrong. A perfect reorder point compared against a wrong balance still fails. Reorder discipline stands on count accuracy and clean adjustment practice.
• Ignoring open orders. If the suggested buy does not subtract quantity already ordered, every alert eventually gets ordered twice.
• No maximum level. A minimum without a ceiling invites "round it up to be safe" buying — which is how safety stock becomes dead stock with a purchase order behind it.
• Levels held outside the system. A planning spreadsheet beside the inventory system means two versions of the truth. The levels belong on the item master, where the dashboard reads them.

How Fast Inventory Software implements reorder control

In Fast Inventory Software, every item on the item & material master carries minimum and maximum levels alongside lead time, minimum order quantity and order multiple. On-hand stock is a running balance maintained by the shared movement engine — every goods receipt, issue, return, transfer and adjustment updates it at commit and writes an immutable ledger row — so the comparison of stock against minimum is always live.

The reorder-level and replenishment dashboards flag items at or below minimum as the buyer's daily worklist, and email alerts push breaches out. Because the platform is shared, the same levels serve the wider suite when licensed — a Fast Planning reorder run reads the very same minimum and maximum fields — and the reports layer adds ABC, valuation and non-moving views so replenishment decisions are made with the value picture in front of you.

Frequently asked questions