Seasonal Index Calculator for Demand Forecasting
Many manufacturing products sell more in some months than others. A seasonal index measures how much a month sits above or below an average month, so you can spread an annual forecast into months or strip seasonality out of history before fitting a model.
Your numbers
Your results
Run this once per calendar month, then check that the twelve indexes average close to 1.00. Three years is a minimum; use more history if demand is erratic.
Monthly forecast vs next-year annual forecast
Sweeps Next year annual forecast from 6000 to 24000, holding your other inputs fixed.
Seasonal indexes from your ERP history
Optional: we can review how your demand history is held and outline an automated seasonal profile by product family.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Pick one calendar month, for example December. Enter demand for that month in each of the last three years, then the total annual demand for the same three years. Enter your annual forecast for next year. The calculator divides each year's month by that year's average month, averages the three ratios to get the index, and multiplies next year's average month by the index to produce the monthly forecast. Repeat for every month, then check that the twelve indexes sum to about 12.
The method
This is the ratio to average method. For each year, the month's ratio is month demand divided by (annual demand / 12). The seasonal index is the average of those ratios across years. An index of 1.45 means the month typically runs 45 percent above an average month. Dividing actual demand by the index gives deseasonalised demand, which can be used with moving average or exponential smoothing. Multiplying a deseasonalised forecast by the index reapplies the season. Because the method divides by each year's own average, it controls for growth between years.
- Index above 1.00: seasonal peak.
- Index below 1.00: seasonal trough.
- Twelve indexes should average 1.00; rescale if they do not.
Worked example
With 1,450, 1,520 and 1,580 units in the month and annual totals of 12,000, 12,600 and 13,100, the ratios are 1.450, 1.448 and 1.447. The index is about 1.448, a stable peak month 45 percent above average. With a next-year forecast of 13,800, an average month is 1,150 units, so the forecast for this month is about 1,665 units. The tight spread across years suggests the seasonal pattern is reliable.
Common mistakes
Using only one year of history mistakes an event for a season. Leaving one-off orders or promotions in the data inflates the index. Ignoring the number of working days can shift a month's index without any real seasonal effect, so adjust if your plants run different days per month. And do not apply a single index to every item: group items with similar seasonality, such as outdoor products versus industrial spares, and calculate each group separately.
Frequently Asked Questions
How do you calculate a seasonal index?
For each year, divide the month's demand by the average monthly demand for that year, then average those ratios across years. An index of 1.2 means the month is typically 20 percent above an average month. Do this for every month and check they average 1.0.
How many years of data do I need?
Three years is a practical minimum and five is better for erratic items. With only one or two years, a single unusual event can look like seasonality. If history is short, group similar products and share one index across them.
What is deseasonalised demand?
It is actual demand divided by the seasonal index for that period. It shows the underlying level and trend without the seasonal swing, so smoothing and trend models work better on it. Multiply the resulting forecast by the index to get back to real units.
Should seasonal indexes be updated every year?
Yes, refresh them at least annually with the newest year of data, and review mid-year if the business changes. A rolling three to five year window balances stability and responsiveness to changing seasonal patterns.
If you want seasonal indexes calculated per product family directly from your ERP history and loaded back as a forecast, we can build that read-only pipeline for you.
Related Tools
Exponential Smoothing Forecast Calculator (Simple and Holt)
Enter the prior level, trend, latest actual and smoothing constants to get the simple and Holt trend forecasts, with a chart showing how alpha changes the result.
Supply Chain & InventoryMoving Average Forecast Calculator
Enter the last six periods of demand, choose a 3, 4 or 6 period window and get the simple moving average forecast with a comparison to the naive forecast.
Supply Chain & InventoryDemand Plan Template by Product Family
An editable demand plan worksheet: statistical baseline, sales and marketing adjustments, consensus, growth versus last year and confidence by product family.
Supply Chain & InventoryForecast Accuracy MAPE and WMAPE Worksheet
Fill in actual and forecast per SKU and get item-level percentage error, plus portfolio MAPE, WMAPE, bias and forecast accuracy. Exports to Excel.
More Supply Chain & Inventory tools
See all- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator
- EOQ with Vendor Minimum Order Calculator