# Exponential Smoothing Forecast Calculator > Source: https://netray.co/tools/simple-exponential-smoothing-forecast-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer 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. ## Category supply-chain ## Audience - Demand planner - Supply planner - Data analyst ## Tool **Kind:** calculator **Inputs:** #### Previous level (or previous forecast) **Key:** level **Type:** number **Default:** 500 **Min:** 0 **Step:** 1 **Unit:** units #### Previous trend per period **Key:** trend **Type:** number **Default:** 8 **Step:** 0.5 **Unit:** units **Help:** Used by the Holt forecast only. Enter 0 for a flat series. #### Latest actual demand **Key:** actual **Type:** number **Default:** 520 **Min:** 0 **Step:** 1 **Unit:** units #### Alpha (level smoothing) **Key:** alpha **Type:** slider **Default:** 0.3 **Min:** 0.05 **Max:** 0.95 **Step:** 0.05 **Help:** Higher alpha reacts faster to the latest actual. #### Beta (trend smoothing) **Key:** beta **Type:** slider **Default:** 0.1 **Min:** 0.05 **Max:** 0.95 **Step:** 0.05 **Outputs:** #### Simple exponential smoothing forecast **Key:** ses **Expr:** alpha * actual + (1 - alpha) * level **Format:** decimal **Primary:** true #### Holt updated level **Key:** newlevel **Expr:** alpha * actual + (1 - alpha) * (level + trend) **Format:** decimal #### Holt updated trend **Key:** newtrend **Expr:** beta * (newlevel - level) + (1 - beta) * trend **Format:** decimal #### Holt forecast, next period **Key:** holt **Expr:** newlevel + newtrend **Format:** decimal **Primary:** true #### Last period error (actual - level) **Key:** err **Expr:** actual - level **Format:** decimal #### Average age of data in the forecast **Key:** age **Expr:** 1 / alpha **Format:** decimal **Description:** In periods. Roughly the memory of the model. #### Equivalent moving average length **Key:** mapers **Expr:** 2 / alpha - 1 **Format:** decimal **Description:** Periods of a simple moving average with similar smoothing. **Chart:** #### Forecast vs alpha **Type:** line **X:** alpha **From:** 0.05 **To:** 0.95 **Steps:** 19 **Series:** - ses - holt **Disclaimer:** This updates one step. To fit alpha and beta properly, test candidate values against your own history and choose those that minimise error. Seasonal items need a seasonal method or deseasonalised data. ## Content **Intro:** Exponential smoothing is the workhorse of statistical demand forecasting and sits behind most ERP and planning system forecast models. This calculator shows the one step update for simple smoothing and for Holt linear trend smoothing, with alpha and beta you can change live. **Sections:** #### How to use the calculator **Body:** Enter the previous level, which for simple smoothing is just last period's forecast, plus the previous trend and the latest actual. Move the alpha and beta sliders to see the effect. The simple forecast is alpha times the latest actual plus one minus alpha times the previous level. The Holt forecast updates the level, then updates the trend from the change in level, and adds them. The chart sweeps alpha from 0.05 to 0.95 so you can see how strongly the forecast follows the last actual. #### The formulas **Body:** Simple smoothing: F(t+1) = alpha * A(t) + (1 - alpha) * F(t). Holt: L(t) = alpha * A(t) + (1 - alpha) * (L(t-1) + T(t-1)); T(t) = beta * (L(t) - L(t-1)) + (1 - beta) * T(t-1); forecast = L(t) + T(t). The weights on older data decay geometrically, which is why it is called exponential. A high alpha, such as 0.5 to 0.9, gives a responsive but noisy forecast. A low alpha, such as 0.05 to 0.2, gives a stable forecast that is slow to react. **Bullets:** - Stable, mature items: alpha around 0.1 to 0.3. - New or volatile items: alpha around 0.3 to 0.6. - Trended items: use Holt, with beta usually lower than alpha. #### Worked example **Body:** With a previous level of 500, trend of 8, actual of 520, alpha 0.3 and beta 0.1, the simple forecast is 0.3 x 520 + 0.7 x 500, which is 506. The Holt level is 0.3 x 520 + 0.7 x 508, which is 511.6. The trend becomes 0.1 x 11.6 + 0.9 x 8, about 8.36, and the Holt forecast is about 520. The simple method lags the rising series, which is exactly what Holt corrects. #### Common mistakes **Body:** Choosing alpha by gut feel and never revisiting it is the most common problem; refit regularly using a holdout. Using a high alpha to chase every spike produces a nervous forecast that causes planning churn. Applying simple smoothing to a trended or seasonal series produces consistently biased forecasts, so pair it with the tracking signal. Finally, start values matter for short histories, so initialise the level from the average of the first several periods. **Cta:** If your ERP or planning tool already runs smoothing models, we can review the parameters it uses and help compare them with alternatives on your own history. **Faq:** #### What is a good alpha for exponential smoothing? **Answer:** There is no universal value. Stable demand usually works with 0.1 to 0.3, volatile or changing demand with 0.3 to 0.6. The best way is to try several alphas on past data and choose the one with the lowest error, then recheck periodically. #### What is the difference between simple and Holt smoothing? **Answer:** Simple smoothing tracks a level only, so it lags when demand trends up or down. Holt adds a second equation for trend, so it can project continuing growth or decline. Use Holt when you see a sustained direction, and simple smoothing for flat series. #### How is exponential smoothing different from a moving average? **Answer:** A moving average weights the last n periods equally and ignores older data. Exponential smoothing weights every past period with geometrically decreasing weights, so it needs only the last forecast and the latest actual to update. Both are baselines for stable demand. #### Can exponential smoothing handle seasonality? **Answer:** Not the simple or Holt versions. Holt-Winters adds seasonal factors. A practical alternative is to deseasonalise demand with a seasonal index, forecast the deseasonalised series, then reapply the index to the result. ## Search terms exponential smoothing forecast calculator, simple exponential smoothing example, holt linear trend forecast, alpha smoothing constant demand forecast, exponential smoothing excel, what alpha to use for forecasting, double exponential smoothing calculator, single exponential smoothing formula --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json