Seller utility
CSV multi-SKU replenishment planner
Import your SKUs and keep on-hand, reserved and inbound stock distinct. Use your own sales rate, lead time and safety stock to build a risk-ranked list, adjust quantities and export both the source and your changes.
Import & map columns
The first row is the header. Map every required column; optional units make mismatches visible. Nothing uploads or persists.
Formulas & assumptions
Available stock = max(0, on-hand − reserved). Backlog = max(0, reserved − on-hand). Inbound is not available to sell now.
Cover days = available ÷ daily sales; zero sales has no forecast. Inventory position = on-hand − reserved + inbound (may be negative).
Reorder threshold = daily sales × lead days + safety stock. Suggested = max(0, threshold − inventory position).
Final quantity uses the manual value if entered (zero counts), otherwise the suggestion. Quantities use up to 3 decimals; lead time is 0–3,650 whole days. No unit conversion or case-pack rounding.
Depletion date adds rounded-up cover days to the reference date. Sales are assumed constant. Arrival schedules, seasonality, MOQ and procurement constraints are outside this model; suggestions are not purchase orders.
Replenishment list
Load an example or map a CSV to begin.
Export keeps original fields, edited parameters, calculated values and manual/final quantities. Expand any SKU to edit; calculations update while typing, sorting refreshes after leaving a field.
Frequently asked
Why is inbound stock not available stock?
Inbound units have not arrived and cannot ship now. Available=max(0,on-hand−reserved), backlog=max(0,reserved−on-hand), while inventory position=on-hand−reserved+inbound. Only available stock feeds cover days.
How is the suggestion calculated?
Reorder threshold=daily sales×lead days+safety stock. Default suggestion=max(0,threshold−inventory position). Quantities share one unit and use up to three decimals. MOQ, case packs, funds and supplier constraints are not modelled. A manual zero is valid; blank restores the default.
What about zero sales or missing lead time?
Zero sales never divides by zero: cover and depletion cannot be forecast. Suggestions then use safety stock and inventory position only, flagged for review. Missing lead time, negatives, invalid quantities and mismatched units are flagged without a misleading valid suggestion.
Can I rely on the depletion date?
It adds rounded-up cover days to your reference date. This assumes constant daily sales and unchanged reservations. Arrival schedules, promotions, seasonality and volatility are not modelled; the date is an estimate, not a stockout commitment.
What does the CSV preserve?
Exports include source row, original fields, current parameters, calculations, manual and final quantities, errors, warnings and reference date. Export the filtered view or all rows. Spreadsheet formula prefixes receive an apostrophe for safety. Files and stock data never upload or persist in browser storage.