This article provides readers and more especially business managers with an overview of moving average, exponential smoothing, trend analysis, and linear regression approaches to forecasting. The authors then provide specific examples for each approach and the Excel formulas necessary to develop effective forecasts. This is an important contribution to the literature because it demonstrates that businesses with limited resources can develop reliable and accurate forecasts in a timely and cost effective manner using readily available software.
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.
Nadler, Scott and Kros, John F.
Forecasting with Excel: Suggestions for Managers,
Spreadsheets in Education (eJSiE):
2, Article 5.
Available at: http://epublications.bond.edu.au/ejsie/vol2/iss2/5