StockPilot

Replenishment planning

Reorder Planner

Estimate reorder timing, on-hand stockout risk, confirmed inbound timing, a purchase quantity, and its estimated cost for one SKU at a time.

Runs locally in your browser. Nothing is uploaded or stored.

Planning inputs

Build a reorder outlook

Results update as you type.

Inventory inputs

Use realistic sales, lead-time, receipt-timing, and supplier-rule values.

Illustrative inputs, not customer data.

units

Sellable units available right now.

units

Optional. Units already on order that are expected to become sellable on the arrival date below. Leave blank or enter 0 if none.

days

Optional when inbound quantity is blank or 0. If inbound is entered, use days until it is expected to become sellable; blank is treated as 0 days.

units/day

A representative sales rate for the stock pool being planned.

days

Decision to sellable stock, including the steps relevant to your operation.

days

How many days of demand you want to hold after the new purchase order arrives.

units

Buffer for demand or delivery variability.

units

Enter 0 if your supplier has no minimum.

units

Rounds the purchase quantity up to full cases.

$

Product, freight, duty, and other unit-level costs.

Worked example

Example scenario: one SKU at reorder time

All numbers below are illustrative data for one product, chosen to match the calculator’s default view. They are not real customer data.

  1. Inputs: on-hand inventory 320 units; average daily sales 18 units; supplier lead time 21 days; safety stock 120 units; target coverage 30 days; MOQ 200 units; case pack / order multiple 20 units; unit cost $7.50; no confirmed inbound.
  2. Days of cover: 320 ÷ 18 ≈ 17.8 days, so on-hand stock is estimated to run out in about 18 days — before a new purchase order could arrive on a 21-day lead time.
  3. Reorder point: 18 × 21 + 120 = 498 units. On-hand stock (320) is below this threshold, so the status shows “order now”.
  4. Projected inventory at PO arrival: 320 − (18 × 21) = −58 units. The negative value means a stockout is projected before the new order arrives, and no confirmed inbound prevents it.
  5. Target stock level: 120 + (18 × 30) = 660 units. Raw recommended quantity: 660 − (−58) = 718 units.
  6. MOQ and rounding: MOQ 200 does not bind; the order multiple of 20 rounds 718 up to 720 units.
  7. Estimated purchase cost: 720 × $7.50 = $5,400.00.

What this result means

A negative projected inventory does not mean the tool expects impossible stock; it is how the calculation shows that current stock plus timing leaves a gap to cover. The recommended quantity closes that gap, restores the target coverage, and is then rounded so it can actually be ordered. Every figure is a planning estimate based on the inputs you provide, not a guarantee of what will happen.

Review before acting

  • Confirm the on-hand count is accurate and sellable in the channel you are planning.
  • Check that the demand window behind average daily sales is representative, not a promotion or stockout period.
  • Confirm lead time includes receiving and availability, not only transit.
  • Confirm whether inbound stock is confirmed and becomes sellable in time.
  • Confirm MOQ, case pack, and unit cost against the current supplier quote.
  • Confirm the cash amount fits your available budget before placing the order.

Input guide

On-hand inventory
units — sellable stock for the SKU right now.
Average daily sales
units per day — from a representative historical window.
Supplier lead time
days — from purchase decision to sellable availability.
Safety stock
units — your buffer above expected demand during lead time.
Target coverage
days — how many days of demand the stock level should cover after the order arrives.
Confirmed inbound quantity
units — leave blank for zero.
Expected arrival in days
days — required only when inbound quantity is greater than zero.
MOQ / case pack
units per order / units per case — from supplier terms.
Unit cost
currency per unit — used for the purchase-cost estimate.

What this tool estimates

When to use this tool: Use this tool when one SKU is approaching a replenishment decision and you want timing, inbound coverage, an orderable quantity, and an estimated cost in one view.

A combined planning view of on-hand cover, stockout timing without inbound, reorder point, inbound timing, projected inventory at new PO arrival, and an orderable quantity after MOQ and case-pack rules.

Inputs to verify

Use the correct sellable stock pool, a representative demand rate, end-to-end lead time, confirmed receipt timing, and supplier order constraints.

Important assumptions

The tool treats confirmed inbound separately from on-hand stock and includes it in the future projection only when its arrival is on or before the new PO arrival. Its quantity target is safety stock plus demand over the target coverage period, less projected inventory at new PO arrival, then floored at zero and adjusted for MOQ and case-pack rules. Target coverage is a policy input, not a forecast.

When not to rely on the result alone

This output is planning assistance, not an automatic purchase instruction. Recheck forecast changes, partial receipts, supplier reliability, returns, warehouse capacity, cash, shelf life, and approval policy before buying.

Related tools

Continue the planning sequence

Safety Stock CalculatorReorder Point CalculatorPurchase Order Quantity CalculatorBulk Inventory PlannerStockout Date CalculatorLearn inventory planning basics

FAQ

Reorder planning questions

Why is inbound inventory not always counted as on hand?

Inbound units cannot support sales until they become sellable. The planner evaluates their arrival timing separately.

What does target stock coverage mean?

It is the number of demand days you want to hold after the new purchase order arrives, in addition to safety stock.

Is this an automatic purchase recommendation?

No. It is a local planning estimate that still needs review against your own policy, supplier conditions, cash, and storage constraints.