Forecasting-based SKU classification

Different spare parts are associated with different underlying demand patterns, which in turn require different forecasting methods. Consequently, there is a need to categorise stock keeping units (SKUs) and apply the most appropriate methods in each category. For intermittent demands, Croston's method (CRO) is currently regarded as the standard method used in industry to forecast the relevant inventory requirements; this is despite the bias associated with Croston's estimates. A bias adjusted modification to CRO (Syntetos–Boylan Approximation, SBA) has been shown in a number of empirical studies to perform very well and be associated with a very ‘robust’ behaviour. In a 2005 article, entitled ‘On the categorisation of demand patterns’ published by the Journal of the Operational Research Society, Syntetos et al. (2005) suggested a categorisation scheme, which establishes regions of superior forecasting performance between CRO and SBA. The results led to the development of an approximate rule that is expressed in terms of fixed cut-off values for the following two classification criteria: the squared coefficient of variation of the demand sizes and the average inter-demand interval. Kostenko and Hyndman (2006) revisited this issue and suggested an alternative scheme to distinguish between CRO and SBA in order to improve overall forecasting accuracy. Claims were made in terms of the superiority of the proposed approach to the original solution but this issue has never been assessed empirically. This constitutes the main objective of our work. In this paper the above discussed classification solutions are compared by means of experimentation on more than 10,000 SKUs from three different industries. The results enable insights to be gained into the comparative benefits of these approaches. The trade-offs between forecast accuracy and other implementation related considerations are also addressed.

[1]  Argyrios Syntetos,et al.  FORECASTING OF INTERMITTENT DEMAND , 2001 .

[2]  T. Williams Stock Control with Sporadic and Slow-Moving Demand , 1984 .

[3]  J. D. Croston Forecasting and Stock Control for Intermittent Demands , 1972 .

[4]  Robert Fildes,et al.  The evaluation of extrapolative forecasting methods , 1992 .

[5]  Aris A. Syntetos,et al.  On the categorization of demand patterns , 2005, J. Oper. Res. Soc..

[6]  Rob J Hyndman,et al.  Another look at measures of forecast accuracy , 2006 .

[7]  Rob J. Hyndman,et al.  Another Look at Forecast Accuracy Metrics for Intermittent Demand , 2006 .

[8]  Janne Huiskonen,et al.  Maintenance spare parts logistics: Special characteristics and strategic choices , 2001 .

[9]  Nezih Altay,et al.  Adapting Wright’s modification of Holt’s method to forecasting intermittent demand , 2008 .

[10]  J. Boylan,et al.  Forecasting for Items with Intermittent Demand , 1996 .

[11]  J. Boylan,et al.  The accuracy of intermittent demand estimates , 2005 .

[12]  J. Boylan,et al.  On the stock control performance of intermittent demand estimators , 2006 .

[13]  J. Boylan,et al.  On the bias of intermittent demand estimates , 2001 .

[14]  A. Solis,et al.  Lumpy demand forecasting using neural networks , 2001, PICMET '01. Portland International Conference on Management of Engineering and Technology. Proceedings Vol.1: Book of Summaries (IEEE Cat. No.01CH37199).

[15]  Rob J. Hyndman,et al.  A note on the categorization of demand patterns , 2006, J. Oper. Res. Soc..

[16]  M. Z. Babai,et al.  On the demand distributions of spare parts , 2012 .

[17]  Andrew W. Howard,et al.  FORECASTING FOR THE ORDERING AND STOCK- HOLDING OF CONSUMABLE SPARE PARTS , 2002 .

[18]  Aris A. Syntetos,et al.  Classification for forecasting and stock control: a case study , 2008, J. Oper. Res. Soc..