Free Seasonal Forecast Calculator

Seasonal indices and next year's forecast from two years of history, and how far a moving average misses the peak.
Free Seasonal Forecast Calculator

A moving average is always late to a seasonal peak. Paste two or more years of history for one item and this builds a seasonal forecast using the same method as the Excel tutorial.

Seasonal forecast calculator

Paste at least two years of sales history for one item. It works out a seasonal index for each period and builds next season's forecast, then shows how far a plain moving average would miss the peak. Nothing is uploaded: the numbers stay in your browser.

Actual salesSeasonal forecastMoving average forecast

Method: each period's seasonal index is its average sales divided by the average of all periods, using complete years only. The level is the average of your most recent periods with the seasonality taken out (each one divided by its index). Forecast = level x seasonal index. It assumes the seasonal pattern repeats and does not project growth or decline. Remove one-off spikes (a big promotion, a lost customer) before you paste, or they will be copied into every future year.

Want someone to look at the whole picture? The Planning Health Check from Forward Cover reviews your forecasting, inventory and supply planning and tells you where the money is leaking.