IDEAS home Printed from https://ideas.repec.org/a/eee/proeco/v170y2015ipap321-335.html
   My bibliography  Save this article

A hybrid seasonal autoregressive integrated moving average and quantile regression for daily food sales forecasting

Author

Listed:
  • Arunraj, Nari Sivanandam
  • Ahrens, Diane

Abstract

In the retail stage of a food supply chain, food waste and stock-outs occur mainly due to inaccurate forecasting of sales which leads to incorrect ordering of products. The time series sales in food retail industry are characterized by high volatility and skewness, which vary by time. So, the interval forecasts are required by the retail companies to set appropriate inventory policy (reorder point or safety stock level). This paper attempts to develop a seasonal autoregressive integrated moving average with external variables (SARIMAX) model to forecast daily sales of a perishable food. The process of fitting a SARIMAX model in this study involves: (i) the development of Seasonal Autoregressive Integrated Moving Average (SARIMA) model and (ii) combining the SARIMA model and the demand influencing factors using linear regression. As the SARIMAX using multiple linear regression (SARIMA-MLR) model produces only mean forecast, the possibility of underestimation and overestimation is very high due to high service level, peak, and sparse sales in food retail industry. Therefore, a hybrid SARIMA and Quantile Regression (SARIMA-QR) is developed to construct high and low quantile predictions. Instead of extrapolating the quantiles from the mean point forecasts of SARIMA-MLR model based on the assumption of normality, the SARIMA-QR model directly forecasts the quantiles. The developed SARIMA-MLR and SARIMA-QR models are applied in modeling and forecasting of sales data, i.e., the daily sales of banana from a discount retail store in Lower Bavaria, Germany. The results show that the SARIMA-MLR and -QR models yield better forecasts at out-sample data when compared to seasonal naïve forecasting, traditional SARIMA, and multi-layered perceptron neural network (MLPNN) models. Unlike the SARIMA-MLR model, the SARIMA-QR model provides better prediction intervals and a deep insight into the effects of demand influencing factors for different quantiles.

Suggested Citation

  • Arunraj, Nari Sivanandam & Ahrens, Diane, 2015. "A hybrid seasonal autoregressive integrated moving average and quantile regression for daily food sales forecasting," International Journal of Production Economics, Elsevier, vol. 170(PA), pages 321-335.
    • Handle: RePEc:eee:proeco:v:170:y:2015:i:pa:p:321-335
    DOI: 10.1016/j.ijpe.2015.09.039
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0925527315003783
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.ijpe.2015.09.039?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Manish Shukla & Sanjay Jharkharia, 2013. "Applicability of ARIMA Models in Wholesale Vegetable Market: An Investigation," International Journal of Information Systems and Supply Chain Management (IJISSCM), IGI Global, vol. 6(3), pages 105-119, July.
    2. S. Mirasgedis & E. Georgopoulou & Y. Sarafidis & K. Papagiannaki & D. P. Lalas, 2014. "The Impact of Climate Change on the Pattern of Demand for Bottled Water and Non‐Alcoholic Beverages," Business Strategy and the Environment, Wiley Blackwell, vol. 23(4), pages 272-288, May.
    3. Aye, Goodness C. & Balcilar, Mehmet & Gupta, Rangan & Majumdar, Anandamayee, 2015. "Forecasting aggregate retail sales: The case of South Africa," International Journal of Production Economics, Elsevier, vol. 160(C), pages 66-79.
    4. Granger, C. W. J. & White, Halbert & Kamstra, Mark, 1989. "Interval forecasting : An analysis based upon ARCH-quantile estimators," Journal of Econometrics, Elsevier, vol. 40(1), pages 87-96, January.
    5. Ramanathan, Usha & Muyldermans, Luc, 2010. "Identifying demand factors for promotional planning and forecasting: A case of a soft drink company in the UK," International Journal of Production Economics, Elsevier, vol. 128(2), pages 538-545, December.
    6. D. F. Benoit & D. Van Den Poel, 2009. "Benefits of Quantile Regression for the Analysis of Customer Lifetime Value in a Contractual Setting: An Application in Financial Services," Working Papers of Faculty of Economics and Business Administration, Ghent University, Belgium 09/551, Ghent University, Faculty of Economics and Business Administration.
    7. Cadenas, Erasmo & Rivera, Wilfrido, 2010. "Wind speed forecasting in three different regions of Mexico, using a hybrid ARIMA–ANN model," Renewable Energy, Elsevier, vol. 35(12), pages 2732-2738.
    8. Laura Cornelsen & Charles Normand, 2012. "Impact of the smoking ban on the volume of bar sales in Ireland – evidence from time series analysis," Health Economics, John Wiley & Sons, Ltd., vol. 21(5), pages 551-561, May.
    9. Shukur, Osamah Basheer & Lee, Muhammad Hisyam, 2015. "Daily wind speed forecasting through hybrid KF-ANN model based on ARIMA," Renewable Energy, Elsevier, vol. 76(C), pages 637-647.
    10. Taylor, James W., 2007. "Forecasting daily supermarket sales using exponentially weighted quantile regression," European Journal of Operational Research, Elsevier, vol. 178(1), pages 154-167, April.
    11. van Donselaar, K. & van Woensel, T. & Broekmeulen, R. & Fransoo, J., 2006. "Inventory control of perishables in supermarkets," International Journal of Production Economics, Elsevier, vol. 104(2), pages 462-472, December.
    12. Buzby, Jean C. & Wells, Hodan Farah & Axtman, Bruce & Mickey, Jana, 2009. "Supermarket Loss Estimates for Fresh Fruit, Vegetables, Meat, Poultry, and Seafood and Their Use in the ERS Loss-Adjusted Food Availability Data," Economic Information Bulletin 58313, United States Department of Agriculture, Economic Research Service.
    13. Koenker, Roger W & Bassett, Gilbert, Jr, 1978. "Regression Quantiles," Econometrica, Econometric Society, vol. 46(1), pages 33-50, January.
    14. Mena, Carlos & Terry, Leon A. & Williams, Adrian & Ellram, Lisa, 2014. "Causes of waste across multi-tier supply networks: Cases in the UK food sector," International Journal of Production Economics, Elsevier, vol. 152(C), pages 144-158.
    15. Kriechbaumer, Thomas & Angus, Andrew & Parsons, David & Rivas Casado, Monica, 2014. "An improved wavelet–ARIMA approach for forecasting metal prices," Resources Policy, Elsevier, vol. 39(C), pages 32-41.
    16. Roger Koenker & Kevin F. Hallock, 2001. "Quantile Regression," Journal of Economic Perspectives, American Economic Association, vol. 15(4), pages 143-156, Fall.
    17. Fleisch, Elgar & Tellkamp, Christian, 2005. "Inventory inaccuracy and supply chain performance: a simulation study of a retail supply chain," International Journal of Production Economics, Elsevier, vol. 95(3), pages 373-385, March.
    18. Jeong, Kwangbok & Koo, Choongwan & Hong, Taehoon, 2014. "An estimation model for determining the annual energy cost budget in educational facilities using SARIMA (seasonal autoregressive integrated moving average) and ANN (artificial neural network)," Energy, Elsevier, vol. 71(C), pages 71-79.
    19. Zotteri, Giulio & Kalchschmidt, Matteo & Caniato, Federico, 2005. "The impact of aggregation level on forecasting performance," International Journal of Production Economics, Elsevier, vol. 93(1), pages 479-491, January.
    20. Luxhoj, James T. & Riis, Jens O. & Stensballe, Brian, 1996. "A hybrid econometric--neural network modeling approach for sales forecasting," International Journal of Production Economics, Elsevier, vol. 43(2-3), pages 175-192, June.
    21. Dekker, Mark & van Donselaar, Karel & Ouwehand, Pim, 2004. "How to use aggregation and combined forecasting to improve seasonal demand forecasts," International Journal of Production Economics, Elsevier, vol. 90(2), pages 151-167, July.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Egor V. Dudukalov & Galymzhan O. Spabekov & Liudmila V. Kashirskaya & Andrei V. Sevbitov & Olga Yurievna Voronkova & Lidia Vasyutkina, 2020. "Fiscal goals of regulating the activities of the institute of controlled foreign companies in the digital economy," Entrepreneurship and Sustainability Issues, VsI Entrepreneurship and Sustainability Center, vol. 8(2), pages 972-983, December.
    2. Ulrich, Matthias & Jahnke, Hermann & Langrock, Roland & Pesch, Robert & Senge, Robin, 2022. "Classification-based model selection in retail demand forecasting," International Journal of Forecasting, Elsevier, vol. 38(1), pages 209-223.
    3. Ma, Shaohui & Fildes, Robert, 2021. "Retail sales forecasting with meta-learning," European Journal of Operational Research, Elsevier, vol. 288(1), pages 111-128.
    4. Li, Xishu & Yin, Ying & Manrique, David Vergara & Bäck, Thomas, 2021. "Lifecycle forecast for consumer technology products with limited sales data," International Journal of Production Economics, Elsevier, vol. 239(C).
    5. de Souza, Michele & Pereira, Giancarlo Medeiros & Lopes de Sousa Jabbour, Ana Beatriz & Chiappetta Jabbour, Charbel Jose & Trento, Luiz Reni & Borchardt, Miriam & Zvirtes, Leandro, 2021. "A digitally enabled circular economy for mitigating food waste: Understanding innovative marketing strategies in the context of an emerging economy," Technological Forecasting and Social Change, Elsevier, vol. 173(C).
    6. Johannes Habel & Sascha Alavi & Nicolas Heinitz, 2023. "A theory of predictive sales analytics adoption," AMS Review, Springer;Academy of Marketing Science, vol. 13(1), pages 34-54, June.
    7. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    8. Bin Shen & Hau-Ling Chan, 2017. "Forecast Information Sharing for Managing Supply Chains in the Big Data Era: Recent Development and Future Research," Asia-Pacific Journal of Operational Research (APJOR), World Scientific Publishing Co. Pte. Ltd., vol. 34(01), pages 1-26, February.
    9. Erjiang E & Ming Yu & Xin Tian & Ye Tao, 2022. "Dynamic Model Selection Based on Demand Pattern Classification in Retail Sales Forecasting," Mathematics, MDPI, vol. 10(17), pages 1-16, September.
    10. Francisco Carlos Vaz Sales & Michele De Souza & Luiz Reni Trento & Giancarlo Medeiros Pereira & Miriam Borchardt & Gabriel Sperandio Milan, 2023. "Food Waste in Distribution: Causes and Gaps to Be Filled," Sustainability, MDPI, vol. 15(4), pages 1-12, February.
    11. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    12. Jian Liu & Chunlin Liu & Lanping Zhang & Yi Xu, 2020. "RETRACTED ARTICLE: Research on sales information prediction system of e-commerce enterprises based on time series model," Information Systems and e-Business Management, Springer, vol. 18(4), pages 823-836, December.
    13. Tine Van Calster & Filip Van den Bossche & Bart Baesens & Wilfried Lemahieu, 2020. "Profit-oriented sales forecasting: a comparison of forecasting techniques from a business perspective," Papers 2002.00949, arXiv.org.
    14. Huber, Jakob & Stuckenschmidt, Heiner, 2020. "Daily retail demand forecasting using machine learning with emphasis on calendric special days," International Journal of Forecasting, Elsevier, vol. 36(4), pages 1420-1438.
    15. Huber, Jakob & Stuckenschmidt, Heiner, 2021. "Intraday shelf replenishment decision support for perishable goods," International Journal of Production Economics, Elsevier, vol. 231(C).
    16. Ma, Shaohui & Fildes, Robert, 2020. "Forecasting third-party mobile payments with implications for customer flow prediction," International Journal of Forecasting, Elsevier, vol. 36(3), pages 739-760.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    2. Huber, Jakob & Stuckenschmidt, Heiner, 2020. "Daily retail demand forecasting using machine learning with emphasis on calendric special days," International Journal of Forecasting, Elsevier, vol. 36(4), pages 1420-1438.
    3. Huarng, Kun-Huang & Yu, Tiffany Hui-Kuang, 2014. "A new quantile regression forecasting model," Journal of Business Research, Elsevier, vol. 67(5), pages 779-784.
    4. Andrew Phiri, 2018. "Inflation persistence in BRICS countries: A quantile autoregressive (QAR) approach," Business and Economic Horizons (BEH), Prague Development Center, vol. 14(1), pages 97-104, January.
    5. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    6. Cristina Davino & Vincenzo Esposito Vinzi, 2016. "Quantile composite-based path modeling," Advances in Data Analysis and Classification, Springer;German Classification Society - Gesellschaft für Klassifikation (GfKl);Japanese Classification Society (JCS);Classification and Data Analysis Group of the Italian Statistical Society (CLADAG);International Federation of Classification Societies (IFCS), vol. 10(4), pages 491-520, December.
    7. Huber, Jakob & Stuckenschmidt, Heiner, 2021. "Intraday shelf replenishment decision support for perishable goods," International Journal of Production Economics, Elsevier, vol. 231(C).
    8. Ma, Shaohui & Fildes, Robert, 2020. "Forecasting third-party mobile payments with implications for customer flow prediction," International Journal of Forecasting, Elsevier, vol. 36(3), pages 739-760.
    9. Allen, D.E. & Powell, R.J. & Singh, A.K., 2016. "Take it to the limit: Innovative CVaR applications to extreme credit risk measurement," European Journal of Operational Research, Elsevier, vol. 249(2), pages 465-475.
    10. Charles-Olivier Amédée-Manesme & Michel Baroni & Fabrice Barthélémy & Francois des Rosiers, 2017. "Market heterogeneity and the determinants of Paris apartment prices: A quantile regression approach," Urban Studies, Urban Studies Journal Limited, vol. 54(14), pages 3260-3280, November.
    11. Komunjer, Ivana, 2013. "Quantile Prediction," Handbook of Economic Forecasting, in: G. Elliott & C. Granger & A. Timmermann (ed.), Handbook of Economic Forecasting, edition 1, volume 2, chapter 0, pages 961-994, Elsevier.
    12. Wolters, Jannik & Huchzermeier, Arnd, 2021. "Joint In-Season and Out-of-Season Promotion Demand Forecasting in a Retail Environment," Journal of Retailing, Elsevier, vol. 97(4), pages 726-745.
    13. Akosah, Nana Kwame & Alagidede, Imhotep Paul & Schaling, Eric, 2020. "Testing for asymmetry in monetary policy rule for small-open developing economies: Multiscale Bayesian quantile evidence from Ghana," The Journal of Economic Asymmetries, Elsevier, vol. 22(C).
    14. Paul Hewson & Keming Yu, 2008. "Quantile regression for binary performance indicators," Applied Stochastic Models in Business and Industry, John Wiley & Sons, vol. 24(5), pages 401-418, September.
    15. Aboura, Sofiane & Chevallier, Julien, 2016. "Spikes and crashes in the oil market," Research in International Business and Finance, Elsevier, vol. 36(C), pages 615-623.
    16. Trojanek, Radoslaw & Huderek-Glapska, Sonia, 2018. "Measuring the noise cost of aviation – The association between the Limited Use Area around Warsaw Chopin Airport and property values," Journal of Air Transport Management, Elsevier, vol. 67(C), pages 103-114.
    17. Liu, Xiaolei & Lin, Zi & Feng, Ziming, 2021. "Short-term offshore wind speed forecast by seasonal ARIMA - A comparison against GRU and LSTM," Energy, Elsevier, vol. 227(C).
    18. Paulo M.M. Rodrigues & Rita Fradique Lourenço, 2015. "House prices: bubbles, exuberance or something else? Evidence from euro area countries," Working Papers w201517, Banco de Portugal, Economics and Research Department.
    19. Muller, Christophe, 2018. "Heterogeneity and nonconstant effect in two-stage quantile regression," Econometrics and Statistics, Elsevier, vol. 8(C), pages 3-12.
    20. Narula, Subhash C. & Wellington, John F. & Lewis, Stephen A., 2012. "Valuating residential real estate using parametric programming," European Journal of Operational Research, Elsevier, vol. 217(1), pages 120-128.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:proeco:v:170:y:2015:i:pa:p:321-335. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/ijpe .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.