Using clustering to improve sales forecasts in retail merchandising

Given sales forecasts for a set of items along with the standard deviation associated with each forecast, we propose a new method of combining forecasts using the concepts of clustering. Clusters of items are identified based on the similarity in their sales forecasts and then a common forecast is computed for each cluster of items. On a real dataset from a national retail chain we have found that the proposed method of combining forecasts produces significantly better sales forecasts than either the individual forecasts (forecasts without combining) or an alternate method of using a single combined forecast for all items in a product line sold by this retailer.

[1]  John T. Mentzer,et al.  Familiarity, application, and performance of sales forecasting techniques , 1984 .

[2]  Walter D. Fisher.  On Grouping for Maximum Homogeneity , 1958 .

[3]  Derek W. Bunn,et al.  Review of guidelines for the use of combined forecasts , 2000, Eur. J. Oper. Res..

[4]  R. Fay,et al.  Estimates of Income for Small Places: An Application of James-Stein Procedures to Census Data , 1979 .

[5]  P. Brucker.  On the Complexity of Clustering Problems , 1978 .

[6]  Forecasting Time Series from Clusters , 1999 .

[7]  G. W. Milligan,et al.  An examination of procedures for determining the number of clusters in a data set , 1985 .

[8]  Mahesh Kumar,et al.  Clustering data with measurement errors , 2007, Comput. Stat. Data Anal..

[9]  H. L. Le Roy,et al.  Proceedings of the Fifth Berkeley Symposium on Mathematical Statistics and Probability; Vol. IV , 1969 .

[10]  Bernhard Korte,et al.  Optimization and Operations Research , 1976 .

[11]  J. H. Ward.  Hierarchical Grouping to Optimize an Objective Function , 1963 .

[12]  Richard Mitchell,et al.  Forecasting Electricity Demand using Clustering , 2003, Applied Informatics.

[13]  J. Scott Armstrong,et al.  Principles of forecasting : a handbook for researchers and practitioners , 2001 .

[14]  Salvatore J. Terregrossa,et al.  On the efficacy of constraints on the linear combination forecast model , 2005 .

[15]  Mahesh Kumar,et al.  Clustering seasonality patterns in the presence of errors , 2002, KDD.

[16]  Derek W. Bunn,et al.  Comparison of seasonal estimation methods in multi-item short-term forecasting , 1999 .

[17]  Thomas B. Fomby,et al.  Application of Stein Rules to Combination Forecasting , 1991 .

[18]  J. M. Bates,et al.  The Combination of Forecasts , 1969 .

[19]  R. Clemen.  Combining forecasts: A review and annotated bibliography , 1989 .

[20]  George T. Duncan,et al.  Forecasting Analogous Time Series , 2001 .