Advanced SearchSearch Tips
Lessons Learned and Challenges Encountered in Retail Sales Forecast
facebook(new window)  Pirnt(new window) E-mail(new window) Excel Download
 Title & Authors
Lessons Learned and Challenges Encountered in Retail Sales Forecast
Song, Qiang;
  PDF(new window)
Retail sales forecast is a special area of forecasting. Its unique characteristics call for unique data models and treatment, and unique forecasting processes. In this paper, we will address lessons learned and challenges encountered in retail sales forecast from a practical and technical perspective. In particular, starting with the data models of retail sales data, we proceed to address issues existing in estimating and processing each component in the data model. We will discuss how to estimate the multi-seasonal cycles in retail sales data, and the limitations of the existing methodologies. In addition, we will talk about the distinction between business events and forecast events, the methodologies used in event detection and event effect estimation, and the difficulties in compound event detection and effect estimation. For each of the issues and challenges, we will present our solution strategy. Some of the solution strategies can be generalized and could be helpful in solving similar forecast problems in different areas.
Multiple Seasonalities;Event Handling;Modeling;Noise Suppression;Best Forecasting Practice;
 Cited by
Armstrong, J. S. (2001), Principles of Forecasting: A Handbook for Researchers and Practitioners, Springer.

Box, G. E. P., Jenkins, G. M., and Reinsel, G. C. (1994), Time Series Analysis: Forecasting and Control, Third Edition, Prentice-Hall, Inc. New Jersey.

Bunn, D. W. and Taylor, J. W. (2001), Setting accuracy targets for short-term judgmental sales forecasting, International Journal of Forecasting, 17, 159-169. crossref(new window)

Chen, F. L. and Ou, T. Y. (2011), Sales forecasting system based on Gray extreme learning machine with Taguchi method in retail industry, Expert Systems with Applications, 38(3), 1336-1345. crossref(new window)

Chu, C. W. and Zhang, P. G. (2003), A comparative study of linear and nonlinear models for aggregate retail sales forecasting, International J. of Production Economics, 86(3), 217-231. crossref(new window)

Dunn, D. M., William, W. H., and Dechaine, T. L. (1976), Aggregate versus subaggregate models in local area forecasting, Journal of the American Statistical Association, 71(353), 68-71. crossref(new window)

Hoover, J. (2008), Commentary on benchmarking, Foresight, 11.

Hubrich, K. (2005), Forecasting euro area inflation: Does aggregating forecasts by HICP component improve forecast accuracy?, International Journal of Forecasting, 21(1), 119-136. crossref(new window)

Guo, Z. X., Wong, W. K., and Li, M. (2013), A multivariate intelligent decision-making model for retail sales forecasting, Decision Support Systems, 55(1), 247-255. crossref(new window)

Kolassa, S. (2008), Can we obtain valid benchmarks from published surveys of forecast accuracy? Foresight, 11.

Lundholm, R., McVay, S. and Randall, T. (2010), Forecasting sales: A model and some evidence from the retail industry, Unpublished working paper. University of British Columbia and University of Washington.

McCarthy, T., Davis, D., Golicic, S., and Mentzer, J. (2008), Commentary on benchmarking, Foresight, 11.

Ni, Y. and Fan, F. (2010), A two-stage dynamic sales forecasting model for the fashion retail, Expert Systems with Applications, 38(3), 1529-136.

Schervish, M. J. (1997), Theory of Statistics, Springer-Verlag, New York.

Song, Q. (2011), Average Power Function of Noise and Its Applications in Seasonal Time Series Modeling and Forecasting, American Journal of Operations Research, 1, 293-304. crossref(new window)

Stoica, P. and Moses, R. (2005), Spectral Analysis of Signals, Pearson Prentice Hall, New Jersey.

Taylor, J. W. (2008), A comparison of univariate time series methods for forecasting intraday arrivals at a call center, Management Science, 54, 253-265. crossref(new window)