Define the stock and consumption used in the calculation
The simplest calculation divides available inventory by average consumption over a consistent period. Daily consumption produces coverage in days; weekly consumption produces coverage in weeks.
Define what “available stock” means before calculating. Blocked, reserved, non-conforming or already allocated inventory may need to be excluded. Physical stock that cannot be used creates a false sense of security.
Basic formula
Coverage = genuinely available stock ÷ average consumption per unit of time.
- Use consistent units.
- Choose a representative consumption period.
- Treat reserved stock explicitly.
- Analyse incoming orders separately.
Choose a meaningful consumption reference
A recent historical average works for stable demand, but it can be misleading during growth, decline or seasonality. In those cases, use a forecast or weighted average that better represents future needs.
For intermittent items, coverage may appear extremely high simply because recent consumption is low. Add the next known requirement, consumption frequency and obsolescence risk to the analysis.
Compare different views
A useful dashboard can show both historical and forecast coverage when the difference matters.
- Past average.
- Future forecast.
- Known firm demand.
- Expected seasonality.
Connect coverage with supplier lead time
Coverage only becomes actionable when compared with replenishment time. Five weeks of stock may be comfortable for a local supplier with a short lead time and critical for an item sourced over two months.
Create warning zones around supplier lead time, safety stock and the next requirement. This separates genuinely urgent items from references that look low but remain covered until the next reliable receipt.
Read coverage against lead time
The operational question is whether current stock covers demand until the next dependable receipt.
- Coverage above lead time plus buffer: comfortable.
- Coverage close to lead time: monitor closely.
- Coverage below lead time: action or escalation required.
Identify both shortage and excess risk
Low coverage signals shortage risk; very high coverage can indicate over-ordering, declining demand, an excessive MOQ or an item moving towards obsolescence.
Rank items by coverage and value. High coverage on an expensive item may deserve attention before the same ratio on a low-value, stable reference.
Avoid one universal threshold
Acceptable coverage depends on lead time, criticality, value and variability for each product family.
Use coverage as a management indicator
Track the trend rather than a single snapshot. Coverage that steadily declines can signal future tension before it reaches the threshold, while a continuous increase may reveal slowing demand or oversized orders.
Combine coverage with open orders, supplier delays, forecast demand and inventory value. It then becomes an anticipation tool rather than a reporting ratio.
Common mistake to avoid
Reading coverage without supplier lead time leads to poor prioritisation.
Implementation checklist
Before considering the topic under control, check these points in your procurement process.
- Usable stock defined.
- Consumption reference selected.
- Lead time compared.
- Thresholds segmented.
- Trend monitored.
Continue with related procurement guides
Conclusion
Reliable procurement combines coherent parameters, current information and the ability to prioritise exceptions. Use this method as a working framework: adapt thresholds and indicators to your context, measure results and improve the rules progressively instead of managing only through emergencies.