Article ID: | iaor19941712 |
Country: | Netherlands |
Volume: | 9 |
Issue: | 4 |
Start Page Number: | 509 |
End Page Number: | 515 |
Publication Date: | Dec 1993 |
Journal: | International Journal of Forecasting |
Authors: | Miller Tan, Liberatore Matthew |
Keywords: | time series & forecasting methods, spreadsheets |
This paper reviews a spreadsheet-based forecasting approach which a process industry manufacturer developed and implemented to link annual corporate forecasts with its manufacturing/distribution operations. First, the authors consider how this forecasting system supports overall production planning and why it must be compatible with corporate forecasts. They then review the results of substantial testing of variations on the Winters three-parameter exponential smoothing model on 28 actual product family time series. In particular, the authors evaluate whether the use of damping parameters improves forecast accuracy. The paper concludes that a Winters four-parameter model (i.e. the standard Winters three-parameter model augmented by a fourth parameter to damp the trend) provides the most accurate forecasts of the models evaluated. The present application confirms the fact that there are situations where the use of damped trend parameters in short-run exponential smoothing based forecasting models is beneficial.