Out-of-Stock % Calculator
On-shelf availability and lost sales from OOS.
Summary
Out-of-Stock % Calculator: On-shelf availability and lost sales from OOS. It uses OOS SKUs ÷ Total SKUs and is suitable for operations decisions in supermarket, convenience, specialty, foodservice and e-commerce retail.
Live results
- OOS %
- 5.00%
- Estimated Weekly Lost Sales
- $6,000.00
- On-Shelf Availability %
- 95.00%
What is the Out-of-Stock % Calculator?
Quantify lost sales from out-of-stocks at SKU or department level.
It belongs to the Operations cluster of Retail Toolkit calculators and shares its formula conventions with the flagship operations calculator. Use it as a one-off check, or as part of a broader operations review alongside the related tools listed below.
Who should use this calculator?
Store managers
Track operational KPIs at department level every shift.
Department heads
Diagnose whether a sales miss is traffic, conversion or basket.
Area managers
Compare like-for-like store performance on a single KPI.
Ops directors
Set realistic targets backed by industry benchmarks.
Supply-chain planners
Tie store-side operational metrics back to upstream replenishment.
New-store opening teams
Pre-set KPI targets for the first 90 days of trading.
Why this metric matters
Operational KPIs are where 80% of in-store profit improvement actually happens. Pricing and assortment are usually set at head office; what the store team controls is execution — conversion, basket size, on-shelf availability and labour productivity. Tracking the right operational metric is the difference between a store that just opens its doors and one that gets the most out of every customer who walks in.
Formula
OOS %
OOS SKUs ÷ Total SKUs
Industry-standard operations formula. The Out-of-Stock % Calculator gives you an instant, defensible answer for out-of-stock % calculator. Operational KPIs determine whether your stock works for you or against you.
Worked example
Using the default inputs (Total SKUs: 1500; SKUs OOS: 75; Avg Weekly Sales / SKU: 80), the calculator returns OOS % 5.00%, Estimated Weekly Lost Sales 6000.00, On-Shelf Availability % 95.00%. Change any field above to see the numbers recalculate instantly.
Real-world examples
Supermarket
Default inputs produce OOS % of 5.0% — typical for a mainstream grocery format.
Convenience store
Higher basket-margin, lower throughput. Re-enter your own numbers to see how the out-of-stock % calculator shifts.
Foodservice / café
Fresh-heavy formats sit at the more demanding end of the benchmark band.
Specialty retail
Higher margins offset lower throughput; the operations KPI usually compares favourably to grocery formats.
E-commerce DTC
Online operators feed the same formula but with fulfilment, ad spend and payment fees baked into the cost line.
Wholesale
Volume-driven, thin margins — small input changes produce outsized output swings, so model carefully.
Industry benchmarks
Operational KPI bands across common retail formats.
| Segment | Excellent | Average | Poor |
|---|---|---|---|
| Supermarket | Conversion > 95% | 85–95% | < 85% |
| Convenience | Basket > 4 units | 3–4 units | < 3 units |
| Specialty | Conversion > 30% | 18–30% | < 18% |
| QSR | Throughput > 80 covers/hr | 55–80 | < 55 |
Operational benchmarks depend heavily on format, fascia and trading hours — calibrate to your own peer set.
Common mistakes to avoid
1. Reading a single KPI in isolation
How to avoid: Always pair the metric with its driver — basket needs conversion, productivity needs sales, waste needs throughput.
2. Comparing different store formats on the same target
How to avoid: Hypermarkets, supermarkets and convenience formats have totally different KPI shapes — set format-specific benchmarks.
3. Letting daily noise drive weekly decisions
How to avoid: Trend 4–13 weeks of data before acting on a single bad day. One outlier rarely justifies a process change.
4. Forgetting weather, events and trading calendars
How to avoid: Always overlay the trading context (heatwave, public holiday, school break) before drawing conclusions from a variance.
5. Not tying the KPI back to a manager
How to avoid: If no one in the store owns the number, the number won't move. Assign every KPI to a specific role.
6. Reporting in absolute values only
How to avoid: Always show % vs LY, vs budget and vs peer stores — an absolute number alone has almost no information.
Frequently asked questions
Downloads
References & methodology
Calculations follow industry-standard definitions documented in our calculator methodology. Benchmarks are compiled from published industry sources.
- Global Retail KPI Benchmark Study — Deloitte
- Retail Conversion & Basket Benchmarks — RetailNext
- Compiled benchmarks — Retail Toolkit Editorial Team (2023–2025)