Every buyer balances two risks: running out (a stopped line, a lost order) and holding too much (cash locked on shelves, goods expiring). In spreadsheet companies the balance is set by instinct: "we usually order 500 when it looks low". Instinct does not scale past a few dozen items, and it does not notice when demand changes.
An ERP replaces instinct with a few numbers per item: lead time, safety stock, reorder point and order quantity. This article shows how to calculate them and how Voltrus uses them.
Two ways to plan
| Reorder point (min/max) | MRP | |
|---|---|---|
| Triggers on | Stock falling below a level | Dated demand: sales orders, work orders |
| Looks at | Total stock vs a fixed min | Requirements in time, week by week |
| Best for | Steady, independent demand: consumables, spare parts, fast-moving trade goods | Dependent demand: components of products you make, make-to-order |
| Effort | Low: set two numbers | Needs accurate BOMs, orders and lead times |
Components of a manufactured product should be planned by MRP, because their demand is known exactly from the production plan; a reorder point would either over-stock them or run out when a big order arrives. Everything with steady, unpredictable-in-detail usage suits min/max. MRP covers the time-phased method; this article covers the numbers both methods rely on.
Each item's planning_method is mrp (the default), reorder_point or none.
Lead time
Lead time is the number of days from deciding to order to having the goods usable on the shelf. It includes your own approval time, the supplier's delivery time, transport, and receiving and inspection. Underestimating it is the single most common cause of stock-outs.
Voltrus takes a purchase lead time from, in order: the item's warehouse setting, the default item supplier row, the item's lead_time_days, and finally the supplier's general lead time.
Safety stock
Safety stock is the buffer that covers variation: demand higher than average, or a delivery later than usual, while you wait for the next order. The textbook formula, when demand varies and lead time is fairly stable:
Safety stock = z × σd × √LT
z service factor (1.65 for 95% of cycles without a stock-out, 2.33 for 99%)
σd standard deviation of daily demand
LT lead time in days
A simpler rule used in many plants, when you have no statistics yet:
Safety stock = (maximum daily usage × maximum lead time)
− (average daily usage × average lead time)
Reorder point
The reorder point (ROP) is the stock level at which you must order so the goods arrive before the safety stock is used:
Reorder point = average daily demand × lead time + safety stock
Worked example
A distributor sells cable ties, item TIE-200.
| Input | Value |
|---|---|
| Average daily demand | 40 packs |
| Standard deviation of daily demand | 12 packs |
| Lead time | 10 days |
| Target service level | 95% (z = 1.65) |
- Safety stock = 1.65 × 12 × √10 = 1.65 × 12 × 3.16 ≈ 63 packs
- Demand during lead time = 40 × 10 = 400 packs
- Reorder point = 400 + 63 = 463 packs
When stock on hand plus open orders falls below 463, order.
How much to order
The reorder point says when. The order quantity says how much. Three common approaches.
Order up to a max. Set a maximum level; each order brings projected stock back up to it. Simple, and the usual choice with min/max planning.
Economic order quantity (EOQ). Balances the cost of placing an order against the cost of holding stock:
EOQ = √(2 × D × S ÷ H)
D annual demand (units)
S cost of placing one order (admin, transport, receiving)
H cost of holding one unit for a year (capital, storage, risk)
For TIE-200: D = 10,000 packs a year, S = Rp 500,000, H = Rp 2,000 per pack per year, so EOQ = √(2 × 10,000 × 500,000 ÷ 2,000) ≈ 2,236 packs. A max of about ROP + EOQ, here 463 + 2,236 ≈ 2,700, is a reasonable start.
Supplier constraints. Minimum order quantities and pack sizes override the maths. A supplier who sells only in cartons of 100 turns 2,236 into 2,300.
EOQ is a guide, not a law: its inputs are estimates and the curve is flat near the optimum, so being 20% off costs little.
How Voltrus plans reorder-point items
For an item with planning_method = reorder_point, the MRP run calculates per item (and per warehouse planned on its own):
projected = on hand + all open supply − all open requirements
floor = the higher of reorder_point and safety_stock
If projected is below the floor (or below zero), it suggests an order that brings projected stock up to max_qty (or at least to the floor). The quantity is rounded up to min_order_qty and then to order_multiple. The suggestion is due today, with an expected arrival of today plus the lead time, and names the default supplier. If the item is made rather than bought (it has an active BOM), the make suggestion is also exploded into its components, which MRP then plans with their components due today.
For MRP items, safety_stock is treated as a requirement, so MRP plans to keep it on hand. Items with planning_method = none get no suggestions at all, and create no demand for their components.
Suggestions are only suggestions: a buyer reviews them on the MRP page and converts the chosen ones into draft purchase orders (one per supplier and warehouse), draft work orders or draft transfers.
Per-warehouse levels
A Planning per warehouse row makes that warehouse plan on its own, with its own reorder point, safety stock, max and lead time. Warehouses without a row share one pool using the item's values.
Keeping the numbers current
Demand changes; reorder points set at go-live go stale. Every night Voltrus compares each reorder point with recent usage: average daily material issues over the last 90 days × lead time × 1.5. When that suggestion is more than 25% above the current reorder point, it raises a reorder recommendation, which an operations user can approve as a proposal to update the item. Nothing changes without that approval.
In Voltrus
Checklist
- Choose a planning method per item: MRP for components, reorder point for steady items, none for one-offs.
- Measure real lead times from PO and receipt dates.
- Calculate safety stock and reorder point for A and B items first.
- Enter supplier minimums and pack sizes so suggestions are orderable as they are.
- Review recommendations weekly and planning levels every quarter.