论文信息 - A spreadsheet modeling approach to the Holt-Winters optimal forecasting

A spreadsheet modeling approach to the Holt-Winters optimal forecasting

Abstract The objective of this paper is to determine the optimal forecasting for the Holt–Winters exponential smoothing model using spreadsheet modeling. This forecasting procedure is especially useful for short-term forecasts for series of sales data or levels of demand for goods. The non-linear programming problem associated with this forecasting model is formulated and a spreadsheet model is used to solve the problem of optimization efficiently. Also, a spreadsheet makes it possible to work in parallel with various objective functions (measures of forecast errors) and different procedures for calculating the initial values of the components of the model. Using a scenario analysis, the set of local minima obtained may be visualized. We have solved some examples in order to illustrate this approach.

Enriqueta Vercher | José Vicente Segura | E. Vercher | J. V. Segura

[1] Graham K. Rand,et al. Decision Systems for Inventory Management and Production Planning , 1979 .

[2] Garth P. McCormick,et al. Communications to the Editor--Exponential Forecasting: Some New Variations , 1969 .

[3] Gene K. Groff. Empirical Comparison of Models for Short Range Forecasting , 1973 .

[4] Leon S. Lasdon,et al. Generalized Reduced Gradient Software for Linearly and Nonlinearly Constrained Problems , 1978 .

[5] Robert Goodell Brown,et al. Smoothing, forecasting and prediction of discrete time series , 1964 .

[6] Peter R. Winters,et al. Forecasting Sales by Exponentially Weighted Moving Averages , 1960 .

[7] Eric R. Zieyel. Operations research : applications and algorithms , 1988 .

[8] Steven C. Wheelwright,et al. Forecasting methods and applications. , 1979 .

[9] Lawrence L. Lapin,et al. Cases in management science , 1996 .

[10] E. S. Gardner,et al. FORECASTING WITH EXPONENTIAL SMOOTHING: SOME GUIDELINES FOR MODEL SELECTION , 1980 .

[11] C. Granger,et al. Forecasting Economic Time Series. , 1988 .

[12] Chris Chatfield,et al. Holt‐Winters Forecasting: Some Practical Issues , 1988 .

[13] C. B. Tilanus,et al. Applied Economic Forecasting , 1966 .

[14] Juan Larrañeta,et al. Métodos modernos de gestión de la producción , 1988 .

[15] George E. P. Box,et al. Time Series Analysis: Forecasting and Control , 1977 .