Reorder Point Calculator — Multi-SKU, from CSV
When should you place the next purchase order? ROP = average daily sales × supplier lead time + safety stock. All calculations run in your browser — nothing leaves your device.
Calculated locally in your browser. No server uploads.
Settings
Manual entry
Set how demand, lead time and safety stock are worked out, then press Analyze.
1. Demand
2. Lead time
3. Safety stock
Results below use these settings.
Executive summary
All 1 item are above their reorder point — no purchase orders are needed today.
- SKUs needing a PO now
- 0
- of 1 item (stock at or below ROP)
- Total units short
- 0
- Gap between stock and the reorder point
- Recommended PO units
- 0
- Shortfall raised to each item's MOQ
- Critical stockout risk
- 0
- Stock won't last the supplier lead time
Based on: Manual entry.
Reorder Point
360
units
Demand during lead time
240
units
Safety stock buffer
120
units
Recommended PO Qty
0
units
Items by status · recommended PO units
1 items · 0 units · bar by item count
Inventory level over time
Stock drains at 15.0 units/day. When it reaches the amber reorder point a PO is raised, and it arrives 16 days later (the lead time). The green zone is your safety buffer; the red line is a stockout.
- Stock on hand
- Reorder point (360)
- Safety zone (0–120)
- Stockout (0)
- PO placed
- PO arrives
Item summary
Items needing a PO are listed first. Click a row (or use the SKU filter on the chart) to choose the item shown in the chart above.
1 of 1 items
| Item Code | Description | Daily Sales | Lead Time | Safety Stock | ROP | Stock on Hand | MOQ | Rec. PO Qty | Status |
|---|---|---|---|---|---|---|---|---|---|
| — | Manual entry | 15 | 16 d | 120 | 360 | 500 | 1 | 0 | OK |
Methodology & Guide
How the reorder point and recommended PO are calculated, with a worked example.
Formula breakdown
Reorder point:
ROP = ( d × LT ) + SS
Order-up-to level shown on the gauge:
Max Stock = ROP + ( d × LT )
Recommended PO quantity (gated on net stock):
Net Stock ≤ ROP → Rec PO = max( ROP − Net Stock , MOQ ) Net Stock > ROP → Rec PO = 0 (status OK)
- ROP
- Reorder point in units: the stock level at which a new order should be placed.
- d
- Average daily sales = monthly sales over the chosen 6- or 12-month window ÷ 30.
- LT
- Lead time in days: average of order date → delivery date on closed PO lines, or your manual value.
- SS
- Safety stock in units, from the Safety Stock method or entered manually.
- Net Stock
- Stock on hand plus stock on order.
- MOQ
- Minimum order quantity from the Operations CSV; missing, zero or negative values count as 1.
Worked example: a fast-moving SKU with an MOQ
An item sells 20 units a day, the supplier delivers in 25 days on average, safety stock is 212 units, 600 units are on hand and the supplier's minimum order is 250 units.
- Demand during lead time = 20 × 25 = 500 units.
- ROP = 500 + 212 = 712 units; Max Stock = 712 + 500 = 1,212 units.
- Net stock 600 ≤ ROP 712, so the status is Reorder.
- Demand deficit = 712 − 600 = 112 units.
- Recommended PO = max(112, MOQ 250) = 250 units.
Place a 250-unit PO now. The MOQ adds 138 units above the deficit, which arrive before they are needed.
Quick FAQs
What is the difference between reorder point and safety stock?
Safety stock is the buffer you keep for surprises. The reorder point adds the stock you expect to sell while you wait for the delivery (d × LT). You reorder when stock falls to the ROP, so the safety stock is still there when the order arrives.
Which lead time is used — requested date or actual delivery?
The actual one: delivery date minus order date on each closed PO line, in calendar days, including early deliveries. Requested dates are only used to score supplier punctuality. Without PO history, your manual lead time is used.
Why is the recommended PO bigger than the shortfall?
Because the supplier's minimum order quantity is larger than what you need. The tool never orders below MOQ, and it never orders at all while net stock is above the ROP — the MOQ only applies when a reorder is due.
Full derivations, data safeguards and the privacy architecture are on the Methodology & Formulas page.