Demand forecasting in supply chain: The impact of demand volatility in the presence of promotion

The demand for a particular product or service is typically associated with different uncertainties that can make them volatile and challenging to predict. Demand unpredictability is one of the managers' concerns in the supply chain that can cause large forecasting errors, issues in the upstream supply chain and impose unnecessary costs. We investigate 843 real demand time series with different values of coefficient of variations (CoV) where promotion causes volatility over the entire demand series. In such a case, forecasting demand for different CoV require different models to capture the underlying behavior of demand series and pose significant challenges due to very different and diverse demand behavior. We decompose demand into baseline and promotional demand and propose a hybrid model to forecast demand. Our results indicate that our proposed hybrid model generates robust and accurate forecast across series with different levels of volatilities. We stress the necessity of decomposition for volatile demand series. We also model demand series with a number of well known statistical and machine learning (ML) models to investigate their performance empirically. We found that ARIMA with covariate (ARIMAX) works well to forecast volatile demand series, but exponential smoothing with covariate (ETSX) has a poor performance. Support vector regression (SVR) and dynamic linear regression (DLR) models generate robust forecasts across different categories of demands with different CoV values.

[1]  Michael Gilliland,et al.  The Business Forecasting Deal: Exposing Myths, Eliminating Bad Practices, Providing Practical Solutions , 2010 .

[2]  Martin Christopher,et al.  “Supply Chain 2.0”: managing supply chains in the era of turbulence , 2011 .

[3]  George Athanasopoulos,et al.  Forecasting: principles and practice , 2013 .

[4]  Marco A. Villegas,et al.  A support vector machine for model selection in demand forecasting applications , 2018, Comput. Ind. Eng..

[5]  Ying-Chyi Chou,et al.  Demand forecasting and smoothing capacity planning for products with high random demand volatility , 2008 .

[6]  D. Basak,et al.  Support Vector Regression , 2008 .

[7]  M. Qi,et al.  Forecasting Aggregate Retail Sales: a Comparison of Arti"cial Neural Networks and Traditional Methods , 2001 .

[8]  Howard E. Thompson,et al.  Optimality of Myopic Inventory Policies for Certain Dependent Demand Processes , 1975 .

[9]  Juuso Liesiö,et al.  Forecasting replenishment orders in retail: value of modelling low and intermittent consumer demand with distributions , 2018, Int. J. Prod. Res..

[10]  Sven F. Crone,et al.  Forecasting and operational research: a review , 2008, J. Oper. Res. Soc..

[11]  Max A. Little,et al.  Highly comparative time-series analysis: the empirical structure of time series and their methods , 2013, Journal of The Royal Society Interface.

[12]  Jeremy Hope,et al.  Beyond Budgeting: How Managers Can Break Free from the Annual Performance Trap , 2003 .

[13]  Fred Collopy,et al.  Rule-Based Forecasting: Development and Validation of an Expert Systems Approach to Combining Time Series Extrapolations , 1992 .

[14]  Scott A. Neslin,et al.  Sales Promotion Models , 2008 .

[15]  Stefan Fritsch,et al.  neuralnet: Training of Neural Networks , 2010, R J..

[16]  B. Ratchford,et al.  Practice Prize Article-CHAN4CAST: A Multichannel, Multiregion Sales Forecasting Model and Decision Support System for Consumer Packaged Goods , 2005 .

[17]  G. Walker,et al.  A Transaction Cost Approach to Make-or-Buy Decisions , 1984 .

[18]  Robert Fildes,et al.  A retail store SKU promotions optimization model for category multi-period profit maximization , 2017, Eur. J. Oper. Res..

[19]  T. Evgeniou,et al.  To combine or not to combine: selecting among forecasts and their combinations , 2005 .

[20]  Robert C. Blattberg,et al.  How Promotions Work , 1995 .

[21]  P. Phillips,et al.  Testing the null hypothesis of stationarity against the alternative of a unit root: How sure are we that economic time series have a unit root? , 1992 .

[22]  S. Kolassa,et al.  Advantages of the MAD/Mean ratio over the MAPE , 2007 .

[23]  V. Muggeo.  Estimating regression models with unknown break‐points , 2003, Statistics in medicine.

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

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

[26]  Nigel Meade,et al.  Evidence for the selection of forecasting methods , 2000 .

[27]  Chandra Shah,et al.  Model selection in univariate time series forecasting using discriminant analysis , 1997 .

[28]  Robert Fildes,et al.  Forecasting retailer product sales in the presence of structural change , 2019, Eur. J. Oper. Res..

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

[30]  K. Nikolopoulos,et al.  The theta model: a decomposition approach to forecasting , 2000 .

[31]  Spyros Makridakis,et al.  The M3-Competition: results, conclusions and implications , 2000 .

[32]  Manoochehr Ghiassi,et al.  A dynamic artificial neural network model for forecasting nonlinear processes , 2009, Comput. Ind. Eng..

[33]  George Athanasopoulos,et al.  Modelling and Forecasting Australian Domestic Tourism , 2006 .

[34]  Nikolaos Kourentzes,et al.  Feature selection for time series prediction - A combined filter and wrapper approach for neural networks , 2010, Neurocomputing.

[35]  S. Chopra,et al.  Supply Chain Management: Strategy, Planning & Operation , 2007 .

[36]  Usha Ramanathan,et al.  Supply chain collaboration for improved forecast accuracy of promotional sales , 2012 .

[37]  A. Koehler,et al.  Exponential Smoothing Model Selection for Forecasting , 2006 .

[38]  Giovanni Petris,et al.  An R Package for Dynamic Linear Models , 2010 .

[39]  Jan Fransoo,et al.  SKU demand forecasting in the presence of promotions , 2009, Expert Syst. Appl..

[40]  Xiaozhe Wang,et al.  Characteristic-Based Clustering for Time Series Data , 2006, Data Mining and Knowledge Discovery.

[41]  Georg M. Goerg.  Forecastable Component Analysis , 2013, ICML.

[42]  M. Christopher.  The Agile Supply Chain : Competing in Volatile Markets , 2000 .

[43]  Josef Packowski.  LEAN Supply Chain Planning: The New Supply Chain Management Paradigm for Process Industries to Master Today's VUCA World , 2013 .

[44]  Giovanni Petris,et al.  Dynamic linear models , 2009 .

[45]  M C Hughes.  Forecasting practice: organisational issues , 2001, J. Oper. Res. Soc..

[46]  Amir F. Atiya,et al.  An Empirical Comparison of Machine Learning Models for Time Series Forecasting , 2010 .

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

[48]  Martin Christopher,et al.  Supply chain 2.0 revisited: a framework for managing volatility-induced risk in the supply chain , 2017 .

[49]  Juan R. Trapero,et al.  On the identification of sales forecasting models in the presence of promotions , 2015, J. Oper. Res. Soc..

[50]  Evangelos Spiliotis,et al.  Statistical and Machine Learning forecasting methods: Concerns and ways forward , 2018, PloS one.

[51]  Richard Weber,et al.  Improved supply chain management based on hybrid demand forecasts , 2007, Appl. Soft Comput..

[52]  R. Genesio,et al.  Short term load forecasting in electric power systems: A comparison of ARMA models and extended wiener filtering , 1983 .

[53]  Anandamayee Majumdar,et al.  Forecasting aggregate retail sales : the case of South Africa , 2015 .

[54]  J. Scott Armstrong,et al.  Demand Forecasting II : Evidence-Based Methods and Checklists , 2017 .

[55]  Konstantinos Nikolopoulos,et al.  Supply chain forecasting: Theory, practice, their gap and the future , 2016, Eur. J. Oper. Res..

[56]  Robert Fildes,et al.  Demand forecasting with high dimensional data: The case of SKU retail sales forecasting with intra- and inter-category promotional information , 2016, Eur. J. Oper. Res..

[57]  Fotios Petropoulos,et al.  Relative performance of methods for forecasting special events , 2015 .

[58]  J. Winch,et al.  Supply Chain Management: Strategy, Planning, and Operation , 2003 .

[59]  Hokey Min,et al.  Artificial intelligence in supply chain management: theory and applications , 2010 .

[60]  R Core Team,et al.  R: A language and environment for statistical computing. , 2014 .

[61]  Seyda Serdarasan,et al.  A review of supply chain complexity drivers , 2013, Comput. Ind. Eng..

[62]  Bernd Scholz-Reiter,et al.  of Productivity and Performance Management Integration of demand forecasts in ABC-XYZ analysis : practical investigation at an industrial company , 2018 .

[63]  Dick R. Wittink,et al.  How Promotions Work: SCAN*PRO-Based Evolutionary Model Building , 2002 .

[64]  Michael Y. Hu,et al.  Forecasting with artificial neural networks: The state of the art , 1997 .

[65]  John E. Boylan,et al.  On the interaction between forecasting and stock control: The case of non-stationary demand , 2011 .

[66]  R. Brown.  Statistical forecasting for inventory control , 1960 .

[67]  P. Goodwin,et al.  Judgmental forecasting: A review of progress over the last 25 years , 2006 .

[68]  Kurt Jetta,et al.  A Model to Improve the Estimation of Baseline Retail Sales , 2011 .

[69]  Gérard P. Cachon,et al.  Managing Supply Chain Demand Variability with Scheduled Ordering Policies , 1999 .

[70]  Robert Fildes,et al.  The value of competitive information in forecasting FMCG retail product sales and the variable selection problem , 2013, Eur. J. Oper. Res..

[71]  Hosang Jung,et al.  Managing demand uncertainty through fuzzy inference in supply chain planning , 2012 .

[72]  Fotios Petropoulos,et al.  The inventory performance of forecasting methods: Evidence from the M3 competition data , 2019, International Journal of Forecasting.

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

[74]  Qiang Sun,et al.  A double-level combination approach for demand forecasting of repairable airplane spare parts based on turnover data , 2017, Comput. Ind. Eng..

[75]  Joshua Garland,et al.  Model-free quantification of time-series predictability. , 2014, Physical review. E, Statistical, nonlinear, and soft matter physics.

[76]  Ping-Feng Pai,et al.  A hybrid ARIMA and support vector machines model in stock price forecasting , 2005 .

[77]  Evangelos Spiliotis,et al.  The M4 Competition: Results, findings, conclusion and way forward , 2018, International Journal of Forecasting.

[78]  K. Donohue.  Efficient Supply Contracts for Fashion Goods with Forecast Updating and Two Production Modes , 2000 .

[79]  Fotios Petropoulos,et al.  To select or to combine? The inventory performance of model and expert forecasts , 2016 .

[80]  Ihsan Hakan Selvi,et al.  A real-time inventory model to manage variance of demand for decreasing inventory holding cost , 2016, Comput. Ind. Eng..

[81]  Rob J Hyndman,et al.  Forecasting with Exponential Smoothing: The State Space Approach , 2008 .

[82]  Lisa Werner,et al.  Principles of forecasting: A handbook for researchers and practitioners , 2002 .

[83]  Rustam M. Vahidov,et al.  Application of machine learning techniques for supply chain demand forecasting , 2008, Eur. J. Oper. Res..

[84]  Timo Teräsvirta,et al.  POWER OF THE NEURAL NETWORK LINEARITY TEST , 1993 .

[85]  David F. Pyke,et al.  Inventory management and production planning and scheduling , 1998 .

[86]  Martin Messner,et al.  The Use of Forecast Accuracy Indicators to Improve Planning Quality: Insights from a Case Study , 2019, The European accounting review.

[87]  Luc Muyldermans,et al.  Identifying the underlying structure of demand during promotions: A structural equation modelling approach , 2011, Expert Syst. Appl..

[88]  Markus Christen,et al.  Using Market-Level Data to Understand Promotion Effects in a Nonlinear Model , 1997 .

[89]  Xiaozhe Wang,et al.  Rule induction for forecasting method selection: Meta-learning the characteristics of univariate time series , 2009, Neurocomputing.

[90]  Arunachalam Narayanan,et al.  Demand and order‐fulfillment planning: The impact of point‐of‐sale data, retailer orders and distribution center orders on forecast accuracy , 2019, Journal of Operations Management.

[91]  Borja Ponte,et al.  Applying machine learning to the dynamic selection of replenishment policies in fast-changing supply chain environments , 2018, Int. J. Prod. Res..