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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Season plan | units or RUB | 10,000 | Planned 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 date | units or RUB | 4,000 | The 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 date | units or RUB | 3,000 | The accumulated sales from the season start to today. The example value is illustrative. |
| Weeks passed | wk | 8 | How many weeks of the season are already in the actual. The example value is illustrative. |
| Half-trust threshold, weeks | wk | 6 | After 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
| Step | Formula |
|---|---|
| Weight of the actual | w = 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 forecast | actual + forecast of the rest = 8,142.9 |
| Deviation | season 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
- Forecast
Data as a table
| Measure | Plan | Forecast |
|---|---|---|
| Rest of the season | 6,000 | 5,143 |
| Whole season | 10k | 8,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.