Inventory Replenishment Planner
Calculate daily demand, reorder points, stock cover and purchase quantities by SKU. Check inbound timing and export a replenishment plan.
Inventory Replenishment Planner
Use your own sales and stock to spot gaps before the next purchase.
One SKU per row. on_hand is physical stock; reserved is allocated stock. Daily demand = sold / period_days. Only inbound due within the protection period reduces the suggested quantity. MOQ and pack rounding apply; no purchase order is created.
No analysis yet. Load the labeled example or import your own spreadsheet.
No analysis yet. Load the labeled example or import your own spreadsheet.
Method and scope
Constant daily-demand model; no seasonality or growth forecast. Protection period = lead time + coverage days. Safety stock is entered in units, not a service-level guarantee. Chart covers at most 180 days; negatives represent cumulative gaps. No live inventory or sailing schedules.
Spreadsheet data stays in this page’s memory and is removed on refresh or clear. Analysis and export send no spreadsheet content; the site’s existing analytics and ads load separately.
Replenishment planning guide
What does this replenishment planner calculate?
Combine sales, physical stock, allocations and inbound timing in one replenishment worksheet, separating current availability from future purchasing needs.
Who is this for, and when is it useful?
For cross-border sellers, buyers and warehouse operators reviewing weekly replenishment, supplier lead times or changed inbound arrivals.
How should I prepare and check the data?
Import verified SKU figures using the example headers, check the sales period and arrival days, review gaps first, then inspect purchase quantities and export.
How should I interpret suggested purchases and negative stock?
Need = max(0, daily demand × protection days + safety units − available stock − inbound due within that period). Apply MOQ and pack multiples only when need is positive. Negative stock means a modeled backlog, not sellable inventory. Review seasonality, discontinued items and unconfirmed lead times.
Where is the spreadsheet processed and stored?
SKU, inventory and sales figures are calculated only in this browser page. No spreadsheet upload, ERP lookup or supplier order is sent; refresh or clear removes the data.