Test first
Upload the sample CSV to see mixed results: Reorder now, Reorder soon, Healthy, Overstocked, and Missing data.
Sample Inventory CSV
Download this sample CSV to test the calculator before preparing your own file. It shows the exact columns used by the reorder point, safety stock, stockout risk, and suggested reorder quantity formulas.
How to use the sample
Replace rows later
Keep the column headers, then replace the sample rows with your own SKUs, stock levels, sales rate, and supplier lead times.
Fields explained
| Column | Required | Purpose |
|---|---|---|
| sku | Yes | Unique product identifier. |
| current_stock | Yes | Units currently available. |
| lead_time_days | Yes | Supplier replenishment time. |
| average_daily_sales | Conditional | Direct demand input; otherwise use recent sales fields. |
| minimum_order_quantity | No | Rounds suggested reorder quantity to supplier MOQ. |
| incoming_stock | No | Counts purchase orders already on the way. |
| unit_cost / selling_price | No | Used for value at risk and gross margin estimates. |
FAQ
Can I remove optional fields?
Yes. Optional fields can be blank or omitted unless you need cost, price, or historical fallback calculations.
What causes Missing data?
A row is marked Missing data when SKU, current stock, lead time, or a valid demand source is missing.
Will the sample CSV produce mixed statuses?
Yes. It includes Reorder now, Reorder soon, Healthy, Overstocked, and Missing data examples.