All 30 Rolling Forecasts questions
More in Rolling Forecasts
How do you calculate and apply seasonal indices? What is forecast bias and how do you correct it? How do you present a rolling forecast to management effectively? How do rolling forecasts fit with 'beyond budgeting'? How do you measure and improve forecast accuracy? How do you combine a rolling forecast with an annual budget? How do you use regression analysis for forecasting? What is the difference between additive and multiplicative seasonal models? How does rolling forecasting improve agility compared to annual budgeting? How do machine learning and predictive analytics enhance forecasting?
Advertisement
Budgeting & Forecasting › Rolling Forecasts

How do you handle seasonality and trend in forecasting?

Advanced

Answer

Decompose the series into trend, seasonal, and residual components. Estimate the underlying trend (e.g., via regression or moving averages), calculate seasonal indices to adjust each period, and combine them to forecast. Deseasonalizing data before trend analysis, then reapplying seasonal factors, produces forecasts that reflect both the growth path and recurring seasonal patterns.
Forecast = Trend x Seasonal index (multiplicative model).
Real-world example Applying quarterly seasonal indices to a rising trend line produces a realistic seasonal sales forecast.

Common follow-ups: What is a seasonal index? | Why deseasonalize before trend analysis?

Rolling Forecasts Cash Budgeting Rolling Forecasts
All 30 Rolling Forecasts questions