Reorder point & stock cover
Turn an inventory CSV into a clear replenishment list. See which SKUs need an order and which may run out before new stock arrives.
No signup or file uploads
1. Add an inventory snapshot
CSV / TSVCalculate each SKU locally in your browser. Use a UTF-8 file with a header row, up to 10 MB and 20,000 records.
How to use this tool
- Load a stock snapshot or the sample CSV. Use one row per SKU, with available stock already reduced by commitments.
- Map daily demand, lead time, safety stock and confirmed incoming. Review every suggested mapping; choose zero incoming explicitly when there are no open orders.
- Set additional review / coverage days, such as 7 for a weekly review, and confirm the planning basis.
- Calculate the complete report. Review on-hand coverage risks separately from suggested orders, then export every SKU as CSV.
A worked example
TEA-100 has 30 available units, demand of 5 units per day, a 10-day lead time, 10 safety units and no incoming stock. The reorder point is 60 units. With 7 additional days, the target is 95, so the suggested order is 65 units. On-hand cover is only 6 days, below the 10-day lead time: placing that order does not solve the immediate timing risk. Download the sample CSV.
Know the limits
- This is an arithmetic planning tool. Average daily demand, lead time and safety stock come from you; there is no AI forecast, sales import or automatic purchase order.
- The policy reorders only when available stock plus confirmed incoming is at or below demand during lead time plus safety stock. The target adds your review / coverage days and rounds up to whole units.
- Days of cover uses available stock only. Incoming arrival dates, partial receipts, demand variability, seasonality and supplier delays are not modeled. No coverage warning is a guarantee against stockouts.
- Stock values must be nonnegative whole units up to 1 trillion. Daily demand allows up to 6 decimal places and 1 billion units per day. Lead and additional days must be whole numbers from 0 to 36,500. Negative stock and fractional goods need a different planning model.
- Duplicate exact SKUs or invalid records block the entire calculation. Case and leading zeros are preserved; surrounding or invisible whitespace in a SKU must be cleaned first. Pack sizes, minimum order quantities and supplier constraints are not applied.
A few useful answers
What is the reorder point formula?
Reorder point = average daily demand × lead time in days + safety stock. We compare that threshold with inventory position: available stock net of commitments plus confirmed incoming units.
How is the suggested order calculated?
When inventory position is at or below the reorder point, the target is demand × (lead days + additional review / coverage days) + safety stock. We round the target up to a whole unit, subtract inventory position and floor the suggested order at zero. Above the threshold, we suggest zero units.
Why can a SKU show a coverage risk but no suggested order?
An open purchase order can put inventory position above the reorder point while current stock will run out sooner than the lead time. Because arrival dates are unknown, the tool flags the on-hand shortage independently. Check the existing order or expedite before ordering more.
What happens with zero average daily demand?
Days of cover is shown as N/A because it would divide by zero. A suggested order can still restore the safety stock you entered. Review whether a dormant product should retain that buffer.
Are my inventory files uploaded or stored?
No. Parsing, calculation and CSV generation happen in your browser. Refreshing the page clears the working file and report.