Advanced search
1 file | 2.46 MB Add to list

A leading macroeconomic indicators’ based framework to automatically generate tactical sales forecasts

Author
Organization
Abstract
Tactical sales forecasting is fundamental to production, transportation and personnel decisions at all levels of a supply chain. Traditional forecasting methods extrapolate historical sales information to predict future sales. As a result, these methods are not capable of anticipating macroeconomic changes in the business environment that often have a significant impact on the demand. To account for these macroeconomic changes, companies adjust either their statistical forecast manually or rely on an expert forecast. However, both approaches are notoriously biased and expensive. This paper investigates the use of leading macroeconomic indicators in the tactical sales forecasting process. A forecasting framework is established that automatically selects the relevant variables and predicts future sales. Next, the seasonal component is predicted by the seasonal naive method and the long-term trend using a LASSO regression method with macroeconomic indicators, while keeping the size of the indicator’s set as small as possible. Finally, the accuracy of the proposed framework is evaluated by quantifying the impact of each individual component. The carried out analysis has shown that the proposed framework achieves a reduction of 54.5% in mean absolute percentage error when compared to the naive forecasting method. Moreover, compared to the best performing conventional methods, a reduction of 25.6% is achieved in the tactical time window over three different real-life case studies from different geographical areas.
Keywords
Forecasting, Sales forecasting, Tactical sales forecasting, Macroeconomic indicators, Decomposition, LASSO regression, SUPPLY CHAIN, INVENTORY PERFORMANCE, LARGE NUMBER, DEMAND, SELECTION, MODEL, DECOMPOSITION, PREDICTION, CAPACITY, MARKETS

Downloads

  • (...).pdf
    • full text (Published version)
    • |
    • UGent only
    • |
    • PDF
    • |
    • 2.46 MB

Citation

Please use this url to cite or link to this publication:

MLA
Verstraete, Gylian, et al. “A Leading Macroeconomic Indicators’ Based Framework to Automatically Generate Tactical Sales Forecasts.” COMPUTERS & INDUSTRIAL ENGINEERING, vol. 139, 2020, doi:10.1016/j.cie.2019.106169.
APA
Verstraete, G., Aghezzaf, E.-H., & Desmet, B. (2020). A leading macroeconomic indicators’ based framework to automatically generate tactical sales forecasts. COMPUTERS & INDUSTRIAL ENGINEERING, 139. https://doi.org/10.1016/j.cie.2019.106169
Chicago author-date
Verstraete, Gylian, El-Houssaine Aghezzaf, and Bram Desmet. 2020. “A Leading Macroeconomic Indicators’ Based Framework to Automatically Generate Tactical Sales Forecasts.” COMPUTERS & INDUSTRIAL ENGINEERING 139. https://doi.org/10.1016/j.cie.2019.106169.
Chicago author-date (all authors)
Verstraete, Gylian, El-Houssaine Aghezzaf, and Bram Desmet. 2020. “A Leading Macroeconomic Indicators’ Based Framework to Automatically Generate Tactical Sales Forecasts.” COMPUTERS & INDUSTRIAL ENGINEERING 139. doi:10.1016/j.cie.2019.106169.
Vancouver
1.
Verstraete G, Aghezzaf E-H, Desmet B. A leading macroeconomic indicators’ based framework to automatically generate tactical sales forecasts. COMPUTERS & INDUSTRIAL ENGINEERING. 2020;139.
IEEE
[1]
G. Verstraete, E.-H. Aghezzaf, and B. Desmet, “A leading macroeconomic indicators’ based framework to automatically generate tactical sales forecasts,” COMPUTERS & INDUSTRIAL ENGINEERING, vol. 139, 2020.
@article{8635678,
  abstract     = {Tactical sales forecasting is fundamental to production, transportation and personnel decisions at all levels of a supply chain. Traditional forecasting methods extrapolate historical sales information to predict future sales. As a result, these methods are not capable of anticipating macroeconomic changes in the business environment that often have a significant impact on the demand. To account for these macroeconomic changes, companies adjust either their statistical forecast manually or rely on an expert forecast. However, both approaches are notoriously biased and expensive. This paper investigates the use of leading macroeconomic indicators in the tactical sales forecasting process. A forecasting framework is established that automatically selects the relevant variables and predicts future sales. Next, the seasonal component is predicted by the seasonal naive method and the long-term trend using a LASSO regression method with macroeconomic indicators, while keeping the size of the indicator’s set as small as possible. Finally, the accuracy of the proposed framework is evaluated by quantifying the impact of each individual component. The carried out analysis has shown that the proposed framework achieves a reduction of 54.5% in mean absolute percentage error when compared to the naive forecasting method. Moreover, compared to the best performing conventional methods, a reduction of 25.6% is achieved in the tactical time window over three different real-life case studies from different geographical areas.},
  articleno    = {106169},
  author       = {Verstraete, Gylian and Aghezzaf, El-Houssaine and Desmet, Bram},
  issn         = {0360-8352},
  journal      = {COMPUTERS & INDUSTRIAL ENGINEERING},
  keywords     = {Forecasting,Sales forecasting,Tactical sales forecasting,Macroeconomic indicators,Decomposition,LASSO regression,SUPPLY CHAIN,INVENTORY PERFORMANCE,LARGE NUMBER,DEMAND,SELECTION,MODEL,DECOMPOSITION,PREDICTION,CAPACITY,MARKETS},
  language     = {eng},
  pages        = {10},
  title        = {A leading macroeconomic indicators’ based framework to automatically generate tactical sales forecasts},
  url          = {http://dx.doi.org/10.1016/j.cie.2019.106169},
  volume       = {139},
  year         = {2020},
}

Altmetric
View in Altmetric
Web of Science
Times cited: