Syntha Lab RU

In-season reforecast

Adjusts the forecast of the rest of the season by how the actual is going: the more weeks have passed, the more weight the ratio of the actual to the plan to date gets. Shows the season forecast, the deviation from the plan and the change in the rest.

Forecast and budget For whom: Planners and category managers who review the season plan by the actual.

Calculate on your data →

At a glance

What question does it answer?
What the season forecast is if the rest behaves like the actual to the plan but with caution at the start of the season.
What data is needed?
The season plan and the plan to date.
How to read the result?
Look at the coefficient κ and the weight of the actual: at a small weight the conclusion is cautious. Compare the deviation from the plan with the budget remainder. Example on the default values: Weight of the actual: 57.1%; Coefficient κ to the plan of the rest: 0.857; Plan of the rest of the season: 6,000; Forecast of the rest of the season: 5,142.9. The figures are illustrative: enter your own to see your result.

Why and how to reason

A few weeks into the season the actual already says something about the plan, but the first weeks are random. The weight of the actual grows with the weeks passed. In the example the season plan is 10,000, to date 4,000, the actual 3,000, 8 weeks, half-threshold 6: the weight is 0.571, the coefficient 0.857, the forecast of the rest 5,142.9, the season forecast 8,142.9, which is 18.6% below the plan.

When to use it

Apply once in two to four weeks in the season and after major events. Forecast methods by history are counted by forecast, the pace inside a period by planfactday.

How to read the result

Look at the coefficient and the weight of the actual: at a small weight the conclusion is cautious; compare the deviation with the budget remainder.

Common mistakes

The pace of the first week is extrapolated, everything is recounted every week, a plan with and without promotions is mixed.

What data is needed?

  • The season plan and the plan to date.
  • The actual to date and the weeks passed.
  • The half-trust threshold.

Inputs

FieldUnitValue in the exampleMeaning
Season planunits or RUB10,000Planned sales of the whole season in the same units as the other fields (units or roubles excl. VAT). The example value is illustrative.
Plan to dateunits or RUB4,000The accumulated plan for today by your calendar, cleaned of promotions and events that are not in the actual. The example value is illustrative.
Actual to dateunits or RUB3,000The accumulated sales from the season start to today. The example value is illustrative.
Weeks passedwk8How many weeks of the season are already in the actual. The example value is illustrative.
Half-trust threshold, weekswk6After this many weeks the weight of the actual equals one half. A larger value: more careful with extrapolation. The example value is illustrative.
Purchase price per unit (optional)₽—If the plan is in units, the cost of the change of the purchase or top-up is shown. Empty: not shown. The example value is illustrative.

How it is calculated

StepFormula
Weight of the actualw = 8 ÷ (8 + 6) = 0.571
Coefficientκ = (1 − w) + w × actual ÷ plan to date = 0.857
Forecast of the rest(season plan − plan to date) × κ = 5,142.9
Season forecastactual + forecast of the rest = 8,142.9
Deviationseason forecast ÷ season plan − 1

Worked numbers

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

Weight of the actual
57.1 %
Coefficient κ to the plan of the rest
0.857
Plan of the rest of the season
6,000
Forecast of the rest of the season
5,142.9
Season forecast
8,142.9
Deviation of the season forecast from the plan, %
−18.6 %
Deviation of the season forecast from the plan
−1,857.1
Ratio of the actual to the plan to date
0.75
Change of the purchase or top-up at the unit price
unit price not given
Plan and forecast: the rest and the season
Bar chart: Rest of the season 6,000, Whole season 10k02,0004,0006,0008,00010kRest of the seasonRest of the seasonPlan: 6,0006,000Forecast: 5,1435,143Whole seasonWhole seasonPlan: 10k10kForecast: 8,1438,143
  • Plan
  • Forecast
Data as a table
MeasurePlanForecast
Rest of the season6,0005,143
Whole season10k8,143

The weight of the actual is 57.1%: after 6 weeks it is one half. Recount once in two to four weeks, not every week: otherwise the plan “shakes”.

What to do with the result: compare the change of the rest with the possibility of a top-up (wosreceipts) and with the open-to-buy remainder; for a shortfall think about price and sizes, not only about the purchase.

A typical mistake: extrapolating the pace of the first week, recounting everything every week and mixing a plan with and without promotions.

Nuances and limits

  • Extrapolating the pace of the first week.
  • Recounting everything every week.
  • Mixing a plan with and without promotions.

Terms used

Calculate on your data →