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.
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.
Related
- How to Build a Seasonal Forecast in Excel, Step by Step
- How to Build a Demand Forecast in Excel
- Nerd Foods dataset (two years of history to practise on)
- All free Nerd Tools
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.