Reorder point
Know when to reorder, with a buffer for uncertainty.
InventoryINVENTORY
Inventory Projection & Net Requirements Planner
Compare stock without new orders against a lot-sized replenishment scenario, including calendar-day release dates and late-release flags.
Inventory projection / net requirements calculator
Compare stock without new orders against a lot-sized replenishment scenario, including calendar-day release dates and late-release flags.
YOUR RESULT LIVE CALCULATION
Net requirements across the entered horizon
240suggested receipt units
SINGLE SKU / CALENDAR-DAY LEAD TIMEExisting supplyWith suggestionsSafety target
- Opening available stock
- 180
- Safety-stock target
- 40
- Ending stock without new orders
- -200
- Ending stock with suggested receipts
- 40
- First negative baseline date
- 2026-11-02
- Suggested orders requiring an earlier release
- 0
One SKU and one location. Receipts are available before demand on each entered date. Negative baseline balances carry backlog. Suggested receipts restore the safety target and remain hypothetical, including when lead time makes their release late. No orders are submitted.
Dated requirements and suggested supply
6 rows
| Period | Date | Opening with plan | Scheduled receipts | Demand | Baseline balance | Net requirement | Suggested receipt | Balance with plan | Suggested release | Release status |
|---|---|---|---|---|---|---|---|---|---|---|
| W1 | 2026-10-19 | 180 | 0 | 80 | 100 | 0 | 0 | 100 | - | No new supply |
| W2 | 2026-10-26 | 100 | 60 | 100 | 60 | 0 | 0 | 60 | - | No new supply |
| W3 | 2026-11-02 | 60 | 0 | 90 | -30 | 70 | 80 | 50 | 2026-10-19 | Suggested release |
| W4 | 2026-11-09 | 50 | 120 | 110 | -20 | 0 | 0 | 60 | - | No new supply |
| W5 | 2026-11-16 | 60 | 0 | 80 | -100 | 60 | 60 | 40 | 2026-11-02 | Suggested release |
| W6 | 2026-11-23 | 40 | 0 | 100 | -200 | 100 | 100 | 40 | 2026-11-09 | Suggested release |
BEHIND THE NUMBER
How the calculation works
Enter one SKU at one location, one row per distinct date, with demand aggregated for that period and confirmed incoming receipts. Rows sort by date. Receipts are available before demand on that date. Negative stock carries backlog. A second scenario adds only enough suggested supply to restore the safety target, subject to the minimum and order multiple. Release dates subtract calendar days; a release before the as-of date is flagged rather than silently treated as feasible.
Baseline = prior baseline + scheduled receipts - demand; net requirement = max(safety target - balance before new supply, 0); suggested receipt = round max(net requirement, MOQ) up to order multiple; release = receipt date - lead days
When this calculation helps
A dated projection reveals shortages that an average stock-coverage ratio can hide. Follow demand and confirmed receipts through one SKU/location pool, including opening backlog where applicable.
Check the interpretation
Suggested receipts are hypothetical supply, not confirmed purchase orders. Minimums and multiples can raise the quantity above the immediate requirement, and a suggested release before the as-of date is flagged as late. Review supplier capacity and business calendars separately.
A single-item, unconstrained planning aid, not full MRP, BOM explosion, DRP, ATP, or an order-placement system. Same-period timing is aggregated; no intra-period availability guarantee, capacity constraint, business-day calendar, expiry, or forecast consumption logic is applied. Do not count the same demand as both orders and forecast. Suggested receipts are hypothetical even when their releases are late.
Microsoft net-requirements planning referenceGood to know
Does this create purchase orders?
No. It produces a reviewable scenario and CSV. No supplier or ERP is contacted.
Can I mix SKUs or locations?
No. Run each SKU/location separately with consistent units. The CSV represents one stock pool.