Determining The Optimal Values Of Exponential Smoothing Constants – Does Solver Really Work?

  • Ravinder H
  • 30

    Readers

    Mendeley users who have this article in their library.
  • N/A

    Citations

    Citations of this article.

Abstract

1 A key issue in exponential smoothing is the choice of the values of the smoothing constants used. One approach that is becoming increasingly popular in introductory management science and operations management textbooks is the use of Solver, an Excel-based non-linear optimizer, to identify values of the smoothing constants that minimize a measure of forecast error like Mean Absolute Deviation (MAD) or Mean Squared Error (MSE). We point out some difficulties with this approach and suggest an easy fix. We examine the impact of initial forecasts on the smoothing constants and the idea of optimizing the initial forecast along with the smoothing constants. We make recommendations on the use of Solver in the context of the teaching of forecasting and suggest that there is a better method than Solver to identify the appropriate smoothing constants.

Author-supplied keywords

  • exponential smoothing
  • forecast error
  • non-linear optimization
  • smoothing constants
  • solver

Get free article suggestions today

Mendeley saves you time finding and organizing research

Sign up here
Already have an account ?Sign in

Find this document

There are no full text links

Authors

  • Handanhal V Ravinder

Cite this document

Choose a citation style from the tabs below

Save time finding and organizing research with Mendeley

Sign up for free