How to estimate average_daily_sales
If you know daily demand, enter it directly. If not, divide recent units sold by the number of days, such as last_30_days_sales / 30 or last_90_days_sales / 90.
Search intent: Users need a CSV format they can copy before using the reorder calculator.
Inventory CSV Template for Reorder Calculations
Use an inventory CSV template with one row per SKU and columns for stock, sales velocity, lead time, optional incoming stock, MOQ, cost, and price. Required fields keep the reorder formulas working; optional fields improve safety stock, value at risk, and explanation quality.
Single-SKU calculator
How the calculation works
How to estimate lead_time_days
Use the typical number of days from placing an order to receiving sellable stock. If suppliers vary, use a realistic average and add lead_time_variability_days.
How to handle optional fields
Optional fields can be blank. Leave unit_cost and selling_price blank if you do not want value or margin estimates. Leave incoming_stock blank when no purchase order is on the way.
Input fields explained
| Field | Why it matters |
|---|---|
| sku | Required product identifier. |
| product_name | Optional readable product name for the result table. |
| current_stock | Required units currently available. |
| average_daily_sales | Preferred demand rate input. |
| lead_time_days | Required supplier replenishment time. |
| lead_time_variability_days | Optional estimate of supplier delay variability. |
| desired_service_level | Optional buffer setting, commonly 0.90, 0.95, 0.98, or 0.99. |
| minimum_order_quantity | Optional supplier MOQ for reorder quantity rounding. |
| incoming_stock | Optional units already ordered and expected to arrive. |
| unit_cost | Optional cost used for inventory value at risk. |
| selling_price | Optional price used for gross margin estimate. |
| last_30_days_sales | Optional fallback for estimating average daily demand. |
| last_60_days_sales | Optional fallback for demand and variability estimates. |
| last_90_days_sales | Optional fallback for demand and variability estimates. |
Worked example
If last_30_days_sales is 120, average daily demand is 120 / 30 = 4 units/day. If supplier lead time is usually 18 days and can vary by 3 days, enter lead_time_days as 18 and lead_time_variability_days as 3.
Common mistakes
- Renaming required headers such as current_stock or lead_time_days.
- Putting currency symbols in numeric fields.
- Mixing units sold and revenue in the sales columns.
- Leaving both average_daily_sales and recent sales totals blank.
When not to rely on the result
A clean CSV format does not make the inputs correct. Review unusual sales periods, stockouts, supplier delays, and one-off bulk orders before using the results.
FAQ
Can I download a sample inventory CSV?
Yes. Use the sample CSV page or direct download link, then replace the sample rows with your own SKUs.
Which columns are required?
sku, current_stock, lead_time_days, and either average_daily_sales or recent sales totals are required for useful results.
Can optional fields be missing?
Yes. Optional fields can be blank, but value at risk, margin, MOQ rounding, and variability estimates may be less useful.