IDEAS home Printed from https://ideas.repec.org/a/eee/joreco/v48y2019icp169-177.html
   My bibliography  Save this article

A data-driven framework for predicting weather impact on high-volume low-margin retail products

Author

Listed:
  • Verstraete, Gylian
  • Aghezzaf, El-Houssaine
  • Desmet, Bram

Abstract

Accurate demand forecasting is of critical importance to retail companies operating in high-volume low-margin industries. Inaccuracies in the forecasts lead either to stock-outs or to excess inventories, resulting in either lost sales or higher working capital, and for both cases in extra unnecessary costs. Prediction accuracy is essential to retail companies having a part of their product portfolio manufactured in low-cost countries and requiring long delivery times. It is rather vital when the demand for these goods is strongly weather dependent. The combination of long delivery times and weather dependence creates a business challenge, as the availability period of accurate weather information is much shorter than the lead time. In this paper we propose a methodology that handles the impact of both the short-term (with available weather data) and the long-term weather uncertainty on the forecast. For the former, the proposed framework is capable of automatically selecting the best prediction model. For latter, the framework fits a distribution on simulated and aggregated sales using the short-term regression model with historical weather data. This framework has been tested on a company's sales data and is proven to satisfactorily address the challenges that the company is facing.

Suggested Citation

  • Verstraete, Gylian & Aghezzaf, El-Houssaine & Desmet, Bram, 2019. "A data-driven framework for predicting weather impact on high-volume low-margin retail products," Journal of Retailing and Consumer Services, Elsevier, vol. 48(C), pages 169-177.
    • Handle: RePEc:eee:joreco:v:48:y:2019:i:c:p:169-177
    DOI: 10.1016/j.jretconser.2019.02.019
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0969698918307203
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.jretconser.2019.02.019?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. Hyndman, Rob J. & Koehler, Anne B. & Snyder, Ralph D. & Grose, Simone, 2002. "A state space framework for automatic forecasting using exponential smoothing methods," International Journal of Forecasting, Elsevier, vol. 18(3), pages 439-454.
    2. Fallah Tehrani, Ali & Ahrens, Diane, 2016. "Enhanced predictive models for purchasing in the fashion field by using kernel machine regression equipped with ordinal logistic regression," Journal of Retailing and Consumer Services, Elsevier, vol. 32(C), pages 131-138.
    3. Ben Taieb, Souhaib & Hyndman, Rob J., 2014. "A gradient boosting approach to the Kaggle load forecasting competition," International Journal of Forecasting, Elsevier, vol. 30(2), pages 382-394.
    4. Hu, Zhongyi & Bao, Yukun & Chiong, Raymond & Xiong, Tao, 2015. "Mid-term interval load forecasting using multi-output support vector regression with a memetic algorithm for feature selection," Energy, Elsevier, vol. 84(C), pages 419-431.
    5. Fan, Shu & Hyndman, Rob J., 2011. "The price elasticity of electricity demand in South Australia," Energy Policy, Elsevier, vol. 39(6), pages 3709-3719, June.
    6. Dordonnat, V. & Koopman, S.J. & Ooms, M. & Dessertaine, A. & Collet, J., 2008. "An hourly periodic state space model for modelling French national electricity load," International Journal of Forecasting, Elsevier, vol. 24(4), pages 566-587.
    7. Thomassey, Sébastien, 2010. "Sales forecasts in clothing industry: The key success factor of the supply chain management," International Journal of Production Economics, Elsevier, vol. 128(2), pages 470-483, December.
    8. Melissa Dell & Benjamin F. Jones & Benjamin A. Olken, 2014. "What Do We Learn from the Weather? The New Climate-Economy Literature," Journal of Economic Literature, American Economic Association, vol. 52(3), pages 740-798, September.
    9. Silva, Ana Teresa & Moro, Sérgio & Rita, Paulo & Cortez, Paulo, 2018. "Unveiling the features of successful eBay smartphone sellers," Journal of Retailing and Consumer Services, Elsevier, vol. 43(C), pages 311-324.
    10. Hsu, David, 2015. "Identifying key variables and interactions in statistical models of building energy consumption using regularization," Energy, Elsevier, vol. 83(C), pages 144-155.
    11. Friedman, Jerome H. & Hastie, Trevor & Tibshirani, Rob, 2010. "Regularization Paths for Generalized Linear Models via Coordinate Descent," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 33(i01).
    12. Murray, Kyle B. & Di Muro, Fabrizio & Finn, Adam & Popkowski Leszczyc, Peter, 2010. "The effect of weather on consumer spending," Journal of Retailing and Consumer Services, Elsevier, vol. 17(6), pages 512-520.
    13. Hyndman, Rob J. & Koehler, Anne B., 2006. "Another look at measures of forecast accuracy," International Journal of Forecasting, Elsevier, vol. 22(4), pages 679-688.
    14. Xiao, Tiaojun & Qi, Xiangtong, 2008. "Price competition, cost and demand disruptions and coordination of a supply chain with one manufacturer and two competing retailers," Omega, Elsevier, vol. 36(5), pages 741-753, October.
    15. Di Fatta, Davide & Patton, Dean & Viglia, Giampaolo, 2018. "The determinants of conversion rates in SME e-commerce websites," Journal of Retailing and Consumer Services, Elsevier, vol. 41(C), pages 161-168.
    16. Cancelo, José Ramón & Espasa, Antoni & Grafe, Rosmarie, 2008. "Forecasting the electricity load from one day to one week ahead for the Spanish system operator," International Journal of Forecasting, Elsevier, vol. 24(4), pages 588-602.
    17. Ma, Shaohui & Fildes, Robert & Huang, Tao, 2016. "Demand forecasting with high dimensional data: The case of SKU retail sales forecasting with intra- and inter-category promotional information," European Journal of Operational Research, Elsevier, vol. 249(1), pages 245-257.
    18. Martha Starr-McCluer, 2000. "The effects of weather on retail sales," Finance and Economics Discussion Series 2000-08, Board of Governors of the Federal Reserve System (U.S.).
    19. Raza, Muhammad Qamar & Khosravi, Abbas, 2015. "A review on artificial intelligence based load demand forecasting techniques for smart grid and buildings," Renewable and Sustainable Energy Reviews, Elsevier, vol. 50(C), pages 1352-1372.
    20. Mirasgedis, S. & Sarafidis, Y. & Georgopoulou, E. & Lalas, D.P. & Moschovits, M. & Karagiannis, F. & Papakonstantinou, D., 2006. "Models for mid-term electricity demand forecasting incorporating weather influences," Energy, Elsevier, vol. 31(2), pages 208-227.
    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. Djonata Schiessl & Helison Bertoli Alves Dias & José Carlos Korelo, 2022. "Artificial intelligence in marketing: a network analysis and future agenda," Journal of Marketing Analytics, Palgrave Macmillan, vol. 10(3), pages 207-218, September.
    2. Yoo, Jonghyun & Eom, Jiyong & Zhou, Yuyu, 2024. "Thermal comfort and retail sales: A big data analysis of extreme temperature's impact on brick-and-mortar stores," Journal of Retailing and Consumer Services, Elsevier, vol. 77(C).
    3. Sinha, Rajesh Kumar, 2021. "Subscription and casual customers’ differential sensitivity to meteorological characteristics," Journal of Retailing and Consumer Services, Elsevier, vol. 62(C).
    4. Ketron, Seth & Spears, Nancy, 2020. "Schema-ing with color and temperature: The effects of color-temperature congruity and the role of non-temperature associations," Journal of Retailing and Consumer Services, Elsevier, vol. 54(C).
    5. Tian, Xin & Cao, Shasha & Song, Yan, 2021. "The impact of weather on consumer behavior and retail performance: Evidence from a convenience store chain in China," Journal of Retailing and Consumer Services, Elsevier, vol. 62(C).
    6. Badorf, Florian & Hoberg, Kai, 2020. "The impact of daily weather on retail sales: An empirical study in brick-and-mortar stores," Journal of Retailing and Consumer Services, Elsevier, vol. 52(C).

    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. 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.
    2. Makridakis, Spyros & Hyndman, Rob J. & Petropoulos, Fotios, 2020. "Forecasting in social settings: The state of the art," International Journal of Forecasting, Elsevier, vol. 36(1), pages 15-28.
    3. Shao, Zhen & Chao, Fu & Yang, Shan-Lin & Zhou, Kai-Le, 2017. "A review of the decomposition methodology for extracting and identifying the fluctuation characteristics in electricity demand forecasting," Renewable and Sustainable Energy Reviews, Elsevier, vol. 75(C), pages 123-136.
    4. Gür Ali, Özden & Gürlek, Ragıp, 2020. "Automatic Interpretable Retail forecasting with promotional scenarios," International Journal of Forecasting, Elsevier, vol. 36(4), pages 1389-1406.
    5. Bertrand, Jean-Louis & Brusset, Xavier & Fortin, Maxime, 2015. "Assessing and hedging the cost of unseasonal weather: Case of the apparel sector," European Journal of Operational Research, Elsevier, vol. 244(1), pages 261-276.
    6. Meira, Erick & Cyrino Oliveira, Fernando Luiz & de Menezes, Lilian M., 2022. "Forecasting natural gas consumption using Bagging and modified regularization techniques," Energy Economics, Elsevier, vol. 106(C).
    7. Van Belle, Jente & Guns, Tias & Verbeke, Wouter, 2021. "Using shared sell-through data to forecast wholesaler demand in multi-echelon supply chains," European Journal of Operational Research, Elsevier, vol. 288(2), pages 466-479.
    8. Sagaert, Yves R. & Aghezzaf, El-Houssaine & Kourentzes, Nikolaos & Desmet, Bram, 2018. "Tactical sales forecasting using a very large set of macroeconomic indicators," European Journal of Operational Research, Elsevier, vol. 264(2), pages 558-569.
    9. Webel, Karsten, 2022. "A review of some recent developments in the modelling and seasonal adjustment of infra-monthly time series," Discussion Papers 31/2022, Deutsche Bundesbank.
    10. Taylor, James W., 2008. "An evaluation of methods for very short-term load forecasting using minute-by-minute British data," International Journal of Forecasting, Elsevier, vol. 24(4), pages 645-658.
    11. Bertrand, Jean-Louis & Brusset, Xavier & Chabot, Miia, 2021. "Protecting franchise chains against weather risk: A design science approach," Journal of Business Research, Elsevier, vol. 125(C), pages 187-200.
    12. Angelopoulos, Dimitrios & Siskos, Yannis & Psarras, John, 2019. "Disaggregating time series on multiple criteria for robust forecasting: The case of long-term electricity demand in Greece," European Journal of Operational Research, Elsevier, vol. 275(1), pages 252-265.
    13. Jean-Louis Bertrand & Xavier Brusset, 2018. "Managing the financial consequences of weather variability," Journal of Asset Management, Palgrave Macmillan, vol. 19(5), pages 301-315, September.
    14. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    15. Ma, Shaohui & Fildes, Robert, 2017. "A retail store SKU promotions optimization model for category multi-period profit maximization," European Journal of Operational Research, Elsevier, vol. 260(2), pages 680-692.
    16. Seyedeh Narjes Fallah & Mehdi Ganjkhani & Shahaboddin Shamshirband & Kwok-wing Chau, 2019. "Computational Intelligence on Short-Term Load Forecasting: A Methodological Overview," Energies, MDPI, vol. 12(3), pages 1-21, January.
    17. Coelho, Vitor N. & Coelho, Igor M. & Coelho, Bruno N. & Reis, Agnaldo J.R. & Enayatifar, Rasul & Souza, Marcone J.F. & Guimarães, Frederico G., 2016. "A self-adaptive evolutionary fuzzy model for load forecasting problems on smart grid environment," Applied Energy, Elsevier, vol. 169(C), pages 567-584.
    18. Kourentzes, Nikolaos & Petropoulos, Fotios & Trapero, Juan R., 2014. "Improving forecasting by estimating time series structural components across multiple frequencies," International Journal of Forecasting, Elsevier, vol. 30(2), pages 291-302.
    19. Alysha M De Livera, 2010. "Automatic forecasting with a modified exponential smoothing state space framework," Monash Econometrics and Business Statistics Working Papers 10/10, Monash University, Department of Econometrics and Business Statistics.
    20. Vaz, Lucélia Viviane & Filho, Getulio Borges da Silveira, 2017. "Functional Autoregressive Models: An Application to Brazilian Hourly Electricity Load," Brazilian Review of Econometrics, Sociedade Brasileira de Econometria - SBE, vol. 37(2), November.

    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:joreco:v:48:y:2019:i:c:p:169-177. 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: https://www.journals.elsevier.com/journal-of-retailing-and-consumer-services .

    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.