
A data-driven framework for predicting weather impact on high-volume low-margin retail products
- Author
- Gylian Verstraete, El-Houssaine Aghezzaf (UGent) and Bram Desmet
- Organization
- 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.
- Keywords
- Sales forecasting, Machine learning, Weather forecasting, SUPPORT VECTOR REGRESSION, SUPPLY CHAIN, STATE-SPACE, ELECTRICITY DEMAND, LOAD, MODELS, SALES, FORECASTS, PERFORMANCE, SELECTION
Downloads
-
(...).pdf
- full text
- |
- UGent only
- |
- |
- 2.26 MB
Citation
Please use this url to cite or link to this publication: http://hdl.handle.net/1854/LU-8604299
- MLA
- Verstraete, Gylian, et al. “A Data-Driven Framework for Predicting Weather Impact on High-Volume Low-Margin Retail Products.” JOURNAL OF RETAILING AND CONSUMER SERVICES, vol. 48, Elsevier, 2019, pp. 169–77, doi:10.1016/j.jretconser.2019.02.019.
- APA
- Verstraete, G., Aghezzaf, E.-H., & Desmet, B. (2019). A data-driven framework for predicting weather impact on high-volume low-margin retail products. JOURNAL OF RETAILING AND CONSUMER SERVICES, 48, 169–177. https://doi.org/10.1016/j.jretconser.2019.02.019
- Chicago author-date
- Verstraete, Gylian, El-Houssaine Aghezzaf, and Bram Desmet. 2019. “A Data-Driven Framework for Predicting Weather Impact on High-Volume Low-Margin Retail Products.” JOURNAL OF RETAILING AND CONSUMER SERVICES 48: 169–77. https://doi.org/10.1016/j.jretconser.2019.02.019.
- Chicago author-date (all authors)
- Verstraete, Gylian, El-Houssaine Aghezzaf, and Bram Desmet. 2019. “A Data-Driven Framework for Predicting Weather Impact on High-Volume Low-Margin Retail Products.” JOURNAL OF RETAILING AND CONSUMER SERVICES 48: 169–177. doi:10.1016/j.jretconser.2019.02.019.
- Vancouver
- 1.Verstraete G, Aghezzaf E-H, Desmet B. A data-driven framework for predicting weather impact on high-volume low-margin retail products. JOURNAL OF RETAILING AND CONSUMER SERVICES. 2019;48:169–77.
- IEEE
- [1]G. Verstraete, E.-H. Aghezzaf, and B. Desmet, “A data-driven framework for predicting weather impact on high-volume low-margin retail products,” JOURNAL OF RETAILING AND CONSUMER SERVICES, vol. 48, pp. 169–177, 2019.
@article{8604299, 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.}}, author = {{Verstraete, Gylian and Aghezzaf, El-Houssaine and Desmet, Bram}}, issn = {{0969-6989}}, journal = {{JOURNAL OF RETAILING AND CONSUMER SERVICES}}, keywords = {{Sales forecasting,Machine learning,Weather forecasting,SUPPORT VECTOR REGRESSION,SUPPLY CHAIN,STATE-SPACE,ELECTRICITY DEMAND,LOAD,MODELS,SALES,FORECASTS,PERFORMANCE,SELECTION}}, language = {{eng}}, pages = {{169--177}}, publisher = {{Elsevier}}, title = {{A data-driven framework for predicting weather impact on high-volume low-margin retail products}}, url = {{http://dx.doi.org/10.1016/j.jretconser.2019.02.019}}, volume = {{48}}, year = {{2019}}, }
- Altmetric
- View in Altmetric
- Web of Science
- Times cited: