Syntha Lab RU

Top-down vs bottom-up forecast reconciliation

Reconciles the category forecast (top-down) and the sum of the SKU forecasts (bottom-up): the scale, the bias of SKU forecasts and the reconciled SKUs at a given trust in the category level. Shows how much more optimistic the SKU forecasts are than the category.

Forecast and budget For whom: Planners and analysts whose category forecast does not equal the sum of the SKU forecasts.

Calculate on your data →

At a glance

What question does it answer?
How much more optimistic the position forecasts are than the category and how to reconcile them with the chosen trust in the category.
What data is needed?
The category forecast.
How to read the result?
The bias shows the optimism of positions; pass the sum at the chosen trust to buying. Example on the default values: Sum of SKU forecasts, units: 1,150; Bias of the SKU forecasts to the category, %: +15%; Scale λ (category ÷ sum of SKUs): 0.8696; Sum after full reconciliation, units: 1,000. The figures are illustrative: enter your own to see your result.

Why and how to reason

The category forecast is steadier, position forecasts are more detailed, and the sum of positions is usually higher. In the example the category is 1,000 units, four SKUs give 1,150: a bias of +15.0%, a scale of 0.8696; at a trust of 50% the sum is 1,075 units.

When to use it

Apply when reviewing the forecast and before buying. The bias by period is counted by sopbias, forecast methods by forecast, here the reconciliation of levels.

How to read the result

The bias shows the optimism of positions; pass the sum at the chosen trust to buying.

Common mistakes

SKUs are edited by hand without reviewing the category, a trust of 100% is taken for one-off promotions.

What data is needed?

  • The category forecast.
  • The SKU forecasts.
  • Trust in the category.

Inputs

FieldUnitValue in the exampleMeaning
Category forecastpcs1,000The forecast for the whole category in the same units as the SKUs: top-down, usually steadier. The example value is illustrative.
Trust in the category level α%50100% means fitting the SKUs fully to the category, 0% keeping the SKUs as they are. Do not take α = 100% for a one-off category promotion. The example value is illustrative.

How it is calculated

StepFormula
Bottom-upB = the sum of the SKU forecasts
Scale and biasλ = T ÷ B; bias = B ÷ T − 1
Full reconciliationSKU × λ
CompromiseSKU* = α × SKU × λ + (1 − α) × SKU, α = 50%

Worked numbers

Default values from the app; in the interactive version you enter your own.

Sum of SKU forecasts, units
1,150
Bias of the SKU forecasts to the category, %
+15 %
Scale λ (category ÷ sum of SKUs)
0.8696
Sum after full reconciliation, units
1,000
Sum after reconciliation with trust α, units
1,075
Change of the SKU sum at α, units
−75
SKUs: forecast, full and with trust α, units
Bar chart: SKU 1 400, SKU 2 350, SKU 3 250, SKU 4 1500100200300400SKU 1SKU 1Bottom-up: 400Full reconciliation: 348With trust α: 374SKU 2SKU 2Bottom-up: 350Full reconciliation: 304With trust α: 327SKU 3SKU 3Bottom-up: 250Full reconciliation: 217With trust α: 234SKU 4SKU 4Bottom-up: 150Full reconciliation: 130With trust α: 140
  • Bottom-up
  • Full reconciliation
  • With trust α
Data as a table
MeasureBottom-upFull reconciliationWith trust α
SKU 1400348374
SKU 2350304327
SKU 3250217234
SKU 4150130140

SKU reconciliation

SKUBottom-upFull reconciliationWith trust αChange
SKU 1400347.8373.9−26.1
SKU 2350304.3327.2−22.8
SKU 3250217.4233.7−16.3
SKU 4150130.4140.2−9.8

The SKU forecasts add up above the category by 15 %: a typical optimism of position forecasts. Find the cause, do not only scale.

Category forecasts are steadier when sales per position are small; the reconciled sum at α between 0 and 100% lies between bottom-up and top-down.

What to do with the result: edit SKUs together with the review of the category, not by hand one by one; pass the reconciled values to the size split and to buying.

A typical mistake: editing SKUs by hand without reviewing the category and taking α = 100% for one-off promotions.

Nuances and limits

  • Editing SKUs by hand without reviewing the category.
  • Taking α = 100% for one-off promotions.
  • Mixing units and periods.

Terms used

Calculate on your data →