Application of SARIMAX Model to Forecast Daily Sales in Food Retail Industry

During retail stage of food supply chain FSC, food waste and stock-outs occur mainly due to inaccurate sales forecasting which leads to inappropriate ordering of products. The daily demand for a fresh food product is affected by external factors, such as seasonality, price reductions and holidays. In order to overcome this complexity and inaccuracy, the sales forecasting should try to consider all the possible demand influencing factors. The objective of this study is to develop a Seasonal Autoregressive Integrated Moving Average with external variables SARIMAX model which tries to account all the effects due to the demand influencing factors, to forecast the daily sales of perishable foods in a retail store. With respect to performance measures, it is found that the proposed SARIMAX model improves the traditional Seasonal Autoregressive Integrated Moving Average SARIMA model.

[1]  Carlos Mena,et al.  The causes of food waste in the supplier–retailer interface: Evidences from the UK and Spain , 2011 .

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

[3]  Sanjay Jharkharia,et al.  Applicability of ARIMA Models in Wholesale Vegetable Market: An Investigation , 2013, Int. J. Inf. Syst. Supply Chain Manag..

[4]  Suleman Nasiru,et al.  The Efficacy of ARIMAX and SARIMA Models in Predicting Monthly Currency in Circulation in Ghana , 2013 .

[5]  Nor Aishah Hamzah,et al.  Calendar variation model based on ARIMAX for forecasting sales data with Ramadhan effect , 2010 .

[6]  Ali Emrouznejad,et al.  Handbook of Research on Strategic Performance Management and Measurement Using Data Envelopment Analysis , 2013 .

[7]  Ole Jørgen Hanssen,et al.  Initiatives on prevention of food waste in the retail and wholesale trades , 2011 .

[8]  E. Feunteun,et al.  Forecasting animal migration using SARIMAX: an efficient means of reducing silver eel mortality caused by turbines , 2013 .

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

[10]  John E. Thornes,et al.  The weather sensitivity of the UK food retail and distribution industry , 2007 .

[11]  Yongwimon Lenbury,et al.  Document heading doi : Modeling seasonal leptospirosis transmission and its association with rainfall and temperature in Thailand using time-series and ARIMAX analyses , 2012 .

[12]  G. Wets,et al.  INVESTIGATING THE VARIABILITY IN DAILY TRAFFIC COUNTS USING ARIMAX AND SARIMA(X) MODELS: ASSESSING THE IMPACT OF HOLIDAYS ON TWO DIVERGENT SITE LOCATIONS , 2008 .

[13]  Mohammed Amir Hamjah.  Climatic Effects on Major Pulse Crops Production in Bangladesh: An Application of Box-Jenkins ARIMAX Model , 2014 .

[14]  Richard Weber,et al.  Demand Forecast in a Supermarket Using a Hybrid Intelligent System , 2003, HIS.

[15]  Lisa M. Ellram,et al.  Causes of waste across multi-tier supply networks: Cases in the UK food sector , 2014 .

[16]  P. V. Beek,et al.  Supply Chain Management in Food Chains: Improving Performance by Reducing Uncertainty , 1998 .

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

[18]  Armand Faganel,et al.  Forecasting the Primary Demand for a Beer Brand Using Time Series Analysis , 2008 .

[19]  Chaleampong Kongcharoen,et al.  Autoregressive Integrated Moving Average with Explanatory Variable (ARIMAX) Model for Thailand Export , 2013 .

[20]  P. Young,et al.  Time series analysis, forecasting and control , 1972, IEEE Transactions on Automatic Control.

[21]  Charles Normand,et al.  Impact of the smoking ban on the volume of bar sales in Ireland: evidence from time series analysis. , 2012, Health economics.

[22]  Siddhartha Bhattacharyya,et al.  Data mining on time series: an illustration using fast-food restaurant franchise data , 2001 .

[23]  Paul Herbig,et al.  The do's and don'ts of sales forecasting , 1993 .