Calculate seasonal indices to adjust demand forecasts for seasonal patterns. Compute seasonal factors and deseasonalized base demand for any period.
Many products exhibit predictable seasonal demand patterns — higher sales in certain months, quarters, or weeks. The Seasonal Index quantifies these patterns by calculating how much each period's demand deviates from the overall average. A seasonal index of 1.20 means that period typically has 20% higher demand than average.
Once you know the seasonal indices, you can deseasonalize historical data to reveal the underlying trend, and re-seasonalize forecasts to produce accurate period-specific predictions.
This calculator computes seasonal indices from historical demand data, then optionally adjusts a base forecast by applying the appropriate seasonal factor.
Supply-chain managers, warehouse operators, and shipping coordinators rely on precise seasonal index data to maintain efficiency and control costs across complex distribution networks. Revisit this calculator whenever conditions change to keep your logistics plans aligned with real-world performance.
From regional delivery fleets to global freight operations, knowing your precise seasonal index figures empowers you to negotiate better carrier rates, optimize routes, and allocate resources more effectively. Adjust the inputs above to model your specific supply-chain variables and uncover hidden savings opportunities.
From regional delivery fleets to global freight operations, knowing your precise seasonal index figures empowers you to negotiate better carrier rates, optimize routes, and allocate resources more effectively. Adjust the inputs above to model your specific supply-chain variables and uncover hidden savings opportunities.
Ignoring seasonality causes systematic over- and under-forecasting throughout the year. This calculator quantifies your seasonal pattern and produces adjusted forecasts that account for predictable peaks and troughs, leading to better inventory planning and fewer stockouts during high-demand periods. Real-time recalculation lets you model different scenarios quickly, ensuring your logistics decisions are backed by accurate, up-to-date numbers.
Overall Average = Σ(Demand_i) / N Seasonal Index_i = Demand_i / Overall Average Adjusted Forecast_i = Base Forecast × Seasonal Index_i Where N is the number of periods in a full cycle.
Result: Indices range from 0.66 to 1.23; July index = 1.23
Overall average = 1,230/12 = 102.5. July (150) index = 150/102.5 = 1.46. With a base forecast of 110, the July adjusted forecast = 110 × 1.46 = 161 units.
For robust indices, average each period's index across multiple years. For example, average all January values across 3 years, then compute January's index from that average. This approach smooths out year-specific anomalies and produces more reliable factors.
The workflow is: (1) compute seasonal indices, (2) deseasonalize historical data by dividing by indices, (3) fit a trend or level model to the deseasonalized data, (4) generate a base forecast, (5) reseasonalize by multiplying by indices. This classic decomposition approach remains widely used in demand planning.
Ensure that the sum of seasonal indices equals the number of periods (e.g., 12 for monthly). If the raw indices sum to 11.8, multiply each by 12/11.8 to normalize. This ensures the seasonal adjustment does not inflate or deflate total annual demand.
A seasonal index is a ratio that shows how a particular period's demand compares to the overall average. An index of 1.0 means average demand; above 1.0 means above-average; below 1.0 means below-average for that period.
Ideally 2–3 complete seasonal cycles (e.g., 24–36 months for monthly data). More data produces more stable indices. With only one cycle, the indices may be influenced by one-time events.
Deseasonalized demand removes the seasonal effect by dividing actual demand by the seasonal index. This reveals the underlying trend and base demand level, which is useful for trend analysis and long-term planning.
Multiply your base forecast (deseasonalized or trend-based) by the seasonal index for each period. For example, if the base forecast is 100 units/month and January's index is 0.80, the January forecast is 80 units.
Yes. Consumer preferences, market conditions, and competitive dynamics can shift seasonal patterns. Recalculate indices annually and compare to prior years to detect changes.
Seasonal indices provide static factors applied manually to a base forecast. Holt-Winters (triple exponential smoothing) dynamically estimates and updates level, trend, and seasonal components simultaneously. Seasonal indices are simpler; Holt-Winters is more adaptive.
Remove the trend first (detrend) before computing seasonal indices. Otherwise, early periods will appear low and late periods will appear high, contaminating the seasonal factors with trend effects.