Exponential Smoothing Forecast Calculator

Calculate demand forecasts using simple exponential smoothing. Apply a smoothing constant (alpha) to weight recent demand more heavily.

Enter demand for each period, e.g.: 100, 110, 105, 120
Between 0.01 and 0.99 (higher = more responsive)
Defaults to first demand value if blank
Next Period Forecast
130.1
Simple exponential smoothing with alpha = 0.3
MAD (Mean Abs Deviation)
9.12
Average absolute forecast error across all periods
MAPE
7.3%
Excellent accuracy (under 10%)
RMSE
10.70
Root mean squared error - penalizes large deviations
Forecast Bias
9.12
Consistently under-forecasting
Tracking Signal
1.00
Within acceptable range (under 4)
Demand Variability (CV)
9.5%
Stable demand pattern
Periods Analyzed
12
Range: 100 to 140 | Avg: 120.7

Forecast Accuracy (MAPE)

92.7% accuracy

Excellent: MAPE under 10% indicates high forecast reliability

Forecast vs Actual Comparison

PeriodActualForecastError|Error|% Error
1100100.0---
2110100.010.010.09.1%
3105103.02.02.01.9%
4120103.616.416.413.7%
5115108.56.56.55.6%
6125110.514.514.511.6%
7118114.83.23.22.7%
8130115.814.214.210.9%
9122120.02.02.01.6%
10135120.614.414.410.6%
11128124.93.13.12.4%
12140125.914.114.110.1%
13 (forecast)-130.1---
14 (forecast)-130.1---
15 (forecast)-130.1---
Planning notes, formulas, and examples

About the Exponential Smoothing Forecast Calculator

Simple Exponential Smoothing (SES) forecasts next-period demand using a weighted combination of the most recent actual demand and the previous forecast. The smoothing constant alpha (α) controls how much weight is given to the latest observation versus the historical forecast.

When α is close to 1, the forecast reacts quickly to recent changes. When α is close to 0, the forecast changes slowly and smooths out noise. SES inherently applies exponentially decreasing weights to older observations, giving it more responsiveness than a simple moving average.

This calculator lets you enter a sequence of demand values and an alpha value to compute the exponentially smoothed forecast for the next period step by step.

Use the result to compare operating scenarios, pressure-test assumptions, and rerun the model when volumes, rates, or service targets change.

When This Page Helps

Exponential smoothing is the workhorse of demand planning — simple to implement yet effective for a wide range of demand patterns. It requires only one parameter (α) and minimal historical data. This calculator makes it easy to experiment with different alpha values to find the best fit for your demand profile.

How to Use the Inputs

  1. Enter historical demand values separated by commas.
  2. Enter the smoothing constant alpha (0 < α < 1).
  3. Optionally enter an initial forecast (defaults to the first demand value).
  4. Review the smoothed forecast for the next period.
  5. Experiment with different alpha values to optimize responsiveness.
  6. Compare forecast accuracy using MAD or MAPE calculators.
Formula used
F_t = α × D_{t-1} + (1 − α) × F_{t-1} Where: F_t = Forecast for period t D_{t-1} = Actual demand in the previous period F_{t-1} = Previous forecast α = Smoothing constant (0 < α < 1)

Example Calculation

Result: Next Period Forecast = 109.7

Starting with F1 = 100: F2 = 0.3×100 + 0.7×100 = 100. F3 = 0.3×110 + 0.7×100 = 103. F4 = 0.3×105 + 0.7×103 = 103.6. F5 = 0.3×120 + 0.7×103.6 = 108.5. F6 = 0.3×115 + 0.7×108.5 = 110.5.

Tips & Best Practices

  • Typical alpha values range from 0.1 to 0.3 for stable demand and 0.3 to 0.5 for volatile demand.
  • Use forecast error metrics (MAD, MSE) to optimize alpha for your specific demand pattern.
  • SES works well for level demand without trend or seasonality.
  • For trending demand, consider Holt's double exponential smoothing.
  • Initialize the first forecast as the average of the first few demand periods for stability.
  • Many ERP systems use exponential smoothing as their default forecasting algorithm.

How Exponential Weights Decay

In SES, the most recent observation gets weight α, the one before gets α(1−α), the one before that gets α(1−α)², and so on. Weights decrease exponentially, meaning very old data has negligible influence. This self-weighting property makes SES adaptive without explicitly choosing a window size.

Alpha Selection Strategies

Optimal alpha can be found by minimizing the sum of squared errors over historical data. Many tools use grid search (testing alpha from 0.01 to 0.99 in steps of 0.01) to find the minimum-error value. In practice, alpha between 0.1 and 0.3 works well for most supply chain applications.

Beyond Simple Exponential Smoothing

SES is the foundation of a family of methods: Holt's method adds a trend component (double exponential smoothing), and Holt-Winters adds seasonality (triple exponential smoothing). Understanding SES provides the basis for these more sophisticated approaches.

Sources & Methodology

Last updated:

Frequently Asked Questions

  • Alpha (α) is a value between 0 and 1 that determines how much weight the model gives to the most recent demand observation. Higher alpha values make the forecast more responsive; lower values produce smoother, more stable forecasts.