Normalized rate of sale
Cleans the rate of sale: divides weekly sales by in-stock days, excludes promotion weeks and weeks with few in-stock days, counts the base rate, the promotion uplift, the cover of stock and the XYZ stability class.
At a glance
- What question does it answer?
- What the base rate of sale of an item is, how much a promotion raises it and for how many weeks the stock will last.
- What data is needed?
- Sales by week.
- How to read the result?
- Compare the base rate with the raw average: the gap shows how stock-outs and promotions distorted the picture. Take the uplift into promotion planning. Example on the default values: Base rate, units/week: 12; Raw average of sales, units/week: 11.8; Promotion uplift, times: 1.67×; Weeks in the base: 4. The figures are illustrative: enter your own to see your result.
Why and how to reason
Raw weekly sales mix demand, stock-outs and promotions. We divide sales by in-stock days, exclude weeks with a promotion and with low availability and get the base rate. In the example there are six weeks: the base rate is 12.0 units/week (weeks 3 and 5 excluded), the promotion uplift is 1.67, the stock of 96 units lasts 8.0 weeks, a variation of 18% gives class Y.
When to use it
Apply before counting replenishment, cover, safety stock and planning promotions; it is the basis of the other stock calculations. Set the XYZ class limits for your category.
How to read the result
Compare the base rate with the raw average and look at the number of clean weeks: with fewer than three weeks the conclusion is unreliable.
Common mistakes
Raw sales are taken as the rate during stock-outs, promotion weeks are included in the base, in-stock days are taken from the card and not from stock balances.
What data is needed?
- Sales by week.
- In-stock days by week from stock balances.
- The promotion flag by week and the stock now.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Minimum in-stock days to count a week | days | 3 | A week in which the item was in stock fewer days than this is excluded from the base: a rate over two days is random. The example value is illustrative. |
| Class X limit: coefficient of variation up to, % | % | 10 | Class X is stable demand: the variation of the base weeks is not above this limit. Edit the limits for your category. The example value is illustrative. |
| Class Y limit: coefficient of variation up to, % | % | 25 | Above this limit it is class Z: unstable demand, count safety stock from the forecast error (ssforecasterr). The example value is illustrative. |
| Available stock now, units | pcs | 96 | The cover in weeks is counted from it. Empty counts as zero. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Weekly rate | sales ÷ in-stock days × 7 |
| Clean weeks | weeks with a promotion or with stock below 3 days are excluded |
| Base rate | the average rate of clean weeks |
| Promotion uplift | the average rate of promotion weeks ÷ the base rate |
| Cover and class | stock ÷ base rate; variation = standard deviation ÷ mean (X up to 10%, Y up to 25%) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Base rate, units/week
- 12The average rate of clean weeks: sales ÷ in-stock days × 7.
- Raw average of sales, units/week
- 11.8
- Promotion uplift, times
- 1.67×
- Weeks in the base
- 4
- Weeks excluded
- 2
- Cover of stock, weeks
- 8
- Variation of base weeks, %
- 18 %
- XYZ stability class
- Y
- Availability, % of period days
- 88.1 %
- Weekly rate
- Base rate
Data as a table
| Measure | Weekly rate | Base rate |
|---|---|---|
| 1 | 14 | 12 |
| 2 | 9 | 12 |
| 3 | 20 | 12 |
| 4 | 12 | 12 |
| 5 | 10.5 | 12 |
| 6 | 13 | 12 |
Cleaning by week
| Week | Sales | In-stock days | Rate, units/week | Status |
|---|---|---|---|---|
| 1 | 14 | 7 | 14 | in the base |
| 2 | 9 | 7 | 9 | in the base |
| 3 | 20 | 7 | 20 | promotion: excluded |
| 4 | 12 | 7 | 12 | in the base |
| 5 | 3 | 2 | 10.5 | few days: excluded |
| 6 | 13 | 7 | 13 | in the base |
The XYZ class is by the variation of the base weeks: for a seasonal item the variation is inflated by the seasonal course, first divide sales by the seasonality index (seasidx). The class limits are edited above.
What to do with the result: put the base rate into replenishment and cover; use the promotion uplift when planning promotions; count the excluded weeks separately, do not throw them away.
A typical mistake: taking raw sales as the rate during stock-outs and including promotion weeks in the base.
Nuances and limits
- Using raw sales as the rate during stock-outs.
- Including promotion weeks in the base.
- Taking in-stock days from the card and not from stock balances.