Syntha Lab RU

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.

Replenishment and stock cover For whom: Planners, analysts and buyers who need a rate of sale free from stock-out and promotion distortions.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Minimum in-stock days to count a weekdays3A 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, %%10Class 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, %%25Above this limit it is class Z: unstable demand, count safety stock from the forecast error (ssforecasterr). The example value is illustrative.
Available stock now, unitspcs96The cover in weeks is counted from it. Empty counts as zero. The example value is illustrative.

How it is calculated

StepFormula
Weekly ratesales ÷ in-stock days × 7
Clean weeksweeks with a promotion or with stock below 3 days are excluded
Base ratethe average rate of clean weeks
Promotion upliftthe average rate of promotion weeks ÷ the base rate
Cover and classstock ÷ 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 and the base, units/week
Line chart: Weekly rate: 14 → 13; Base rate: 12 → 128101214161820123456Weekly rate, 1: 14Weekly rate, 2: 9Weekly rate, 3: 20Weekly rate, 4: 12Weekly rate, 5: 10.5Weekly rate, 6: 13Base rate, 1: 12Base rate, 2: 12Base rate, 3: 12Base rate, 4: 12Base rate, 5: 12Base rate, 6: 12
  • Weekly rate
  • Base rate
Data as a table
MeasureWeekly rateBase rate
11412
2912
32012
41212
510.512
61312

Cleaning by week

WeekSalesIn-stock daysRate, units/weekStatus
114714in the base
2979in the base
320720promotion: excluded
412712in the base
53210.5few days: excluded
613713in 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.

Terms used

Calculate on your data →