Risk labels
The calculator labels each SKU as Reorder now, Reorder soon, Healthy, Overstocked, or Missing data using inventory position, reorder point, lead time, and days remaining.
Search intent: Users want to find products that may run out soon.
Stockout Risk Calculator for Multiple SKUs
Use this stockout risk calculator to rank SKUs by reorder status, days remaining, reorder point, and estimated value at risk. It is built for sellers who need a quick priority list from a spreadsheet, not a full inventory management system.
Single-SKU calculator
How the calculation works
Best use case
This works best for weekly purchasing reviews where you need to decide which SKUs deserve attention first.
What it cannot know
It cannot see supplier cancellations, future promotions, marketplace ranking changes, or purchase budget unless you include those decisions yourself.
Input fields explained
| Field | Why it matters |
|---|---|
| sku | Lets the result table identify each product. |
| current_stock | Calculates days remaining and inventory position. |
| average_daily_sales or recent sales totals | Estimates demand rate. |
| lead_time_days | Compares stock coverage against replenishment time. |
| selling_price / unit_cost | Optional fields for value at risk and margin estimates. |
Worked example
If current stock is 32 units and demand is 4.5 units/day, days remaining is 7.1. With a 21-day lead time and reorder point of 126, the SKU is Reorder now because stock may run out before replenishment arrives.
Common mistakes
- Sorting only by units left instead of days remaining.
- Ignoring incoming stock that is already on order.
- Treating estimated stockout date as a guaranteed date.
When not to rely on the result
Do not rely on the label alone for purchase orders when supplier minimums, cash flow, warehouse space, or planned promotions change the real decision.
FAQ
How is stockout risk ranked?
Statuses are sorted first, then by days remaining and value at risk.
Does this predict exact stockout dates?
No. Estimated stockout date is current stock divided by average daily demand, added to the calculation date.
Can I export the result?
Yes. The tool exports a result CSV with formulas, labels, and per-SKU explanations.