Many businesses see the same highs and lows every year. The seasonal index calculator takes four quarters over three years, computes the seasonal index of each quarter and then uses a forecast of next year’s total to give a forecast for each quarter. The indexes show which quarters are above and below average and by how much.
How the calculation works
- Enter the values of four quarters for three years, in the same units, such as sales or visitors.
- The calculator averages each quarter over the three years, then divides each average by the overall quarterly average. This gives the seasonal index.
- An index of 1.20 means the quarter is typically 20 % above the average, and 0.80 means 20 % below. The four indexes always average 1.
- Enter a forecast of next year’s total to split it into quarterly forecasts: total ÷ 4 × seasonal index.
Example
The quarterly averages of the default data are 130, 193.3, 160 and 225, and the overall average is 177.08. The seasonal indexes are 0.734, 1.092, 0.904 and 1.271. The fourth quarter is the peak at 27 % above average. A forecast of 760 for next year (190 per quarter on average) is split into 139.5, 207.4, 171.7 and 241.4.
Why it matters
Seasonality hides trends and makes a good or bad quarter hard to judge. An index lets you compare a quarter against what is normal for that time of year, plan stock and staff for the peak and avoid reading a seasonal dip as a decline.
Good to know
The simple average method assumes there is no strong trend and equal weights for all years. It does not remove outliers, holidays that move from year to year or one-off events. For a trending series, de-trend the data first or use a ratio-to-moving-average method.
Related tools
The demand forecast calculator projects the level, the percent error calculator checks how far a forecast is from the actual value, and the exponential moving average calculator smooths a series.