Normalized rate of sale
The average over clean weeks: weekly sales ÷ in-stock days × 7; weeks with a promotion and low availability are excluded
- Formula
The average over clean weeks: weekly sales ÷ in-stock days × 7; weeks with a promotion and low availability are excluded- Unit
- pcs
- Aggregation rule
- Average over dates
- Source system
- ERP and accounting system; Warehouse and stock system
- Owning role
- Head of buying / buyer
- Frequency
- Weekly
Passport
- Grain
- SKU × store or warehouse × week
- Numerator
- The average over clean weeks: weekly sales ÷ in-stock days × 7
- Denominator
- In-stock days of the week
- At zero or no data
- No clean weeks (all with a promotion or low availability): show “—”, not 0.
- Limits
- Weeks with a promotion and with availability below the threshold are excluded. In-stock days are taken from stock balances, not from the card. At least three clean weeks are needed.
- Check example
- Rate of week 1, units: 14; Rate of week 2, units: 9; Rate of week 4, units: 12; Rate of week 6, units: 13.
(a+b+c+d)/4. Result: 12.0 units a week - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Normalized rate of sale
- Calculation: Normalized rate of sale
Definition
The rate of sale without distortions: weekly sales are divided by in-stock days, weeks with a promotion and with few in-stock days are excluded. The base rate is the average of clean weeks, the promotion uplift is the ratio of the promotion rate to the base.
Take in-stock days from stock balances of the store or the platform warehouse, not from the item card.