Home > Research > Publications & Outputs > Tactical sales forecasting using a very large s...

Electronic data

  • Sagaert_2017_tactical-sales-forecasting

    Rights statement: This is the author’s version of a work that was accepted for publication in European Journal of Operational Research. Changes resulting from the publishing process, such as peer review, editing, corrections, structural formatting, and other quality control mechanisms may not be reflected in this document. Changes may have been made to this work since it was submitted for publication. A definitive version was subsequently published in European Journal of Operational Research, 264, 2, 2017 DOI: 10.1016/j.ejor.2017.06.054

    Accepted author manuscript, 403 KB, PDF document

    Available under license: CC BY-NC-ND: Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License

Links

Text available via DOI:

View graph of relations

Tactical sales forecasting using a very large set of macroeconomic indicators

Research output: Contribution to Journal/MagazineJournal articlepeer-review

Published

Standard

Tactical sales forecasting using a very large set of macroeconomic indicators. / Sagaert, Yves R.; Aghezzaf, El-Houssaine; Kourentzes, Nikolaos et al.
In: European Journal of Operational Research, Vol. 264, No. 2, 16.01.2018, p. 558-569.

Research output: Contribution to Journal/MagazineJournal articlepeer-review

Harvard

Sagaert, YR, Aghezzaf, E-H, Kourentzes, N & Desmet, B 2018, 'Tactical sales forecasting using a very large set of macroeconomic indicators', European Journal of Operational Research, vol. 264, no. 2, pp. 558-569. https://doi.org/10.1016/j.ejor.2017.06.054

APA

Sagaert, Y. R., Aghezzaf, E-H., Kourentzes, N., & Desmet, B. (2018). Tactical sales forecasting using a very large set of macroeconomic indicators. European Journal of Operational Research, 264(2), 558-569. https://doi.org/10.1016/j.ejor.2017.06.054

Vancouver

Sagaert YR, Aghezzaf E-H, Kourentzes N, Desmet B. Tactical sales forecasting using a very large set of macroeconomic indicators. European Journal of Operational Research. 2018 Jan 16;264(2):558-569. Epub 2017 Jun 29. doi: 10.1016/j.ejor.2017.06.054

Author

Sagaert, Yves R. ; Aghezzaf, El-Houssaine ; Kourentzes, Nikolaos et al. / Tactical sales forecasting using a very large set of macroeconomic indicators. In: European Journal of Operational Research. 2018 ; Vol. 264, No. 2. pp. 558-569.

Bibtex

@article{2251c5ad094247cdb03f347f3344147f,
title = "Tactical sales forecasting using a very large set of macroeconomic indicators",
abstract = "Tactical forecasting in supply chain management supports planning for inventory, scheduling production, and raw material purchase, amongst other functions. It typically refers to forecasts up to 12 months ahead. Traditional forecasting models take into account univariate information extrapolating from the past, but cannot anticipate macroeconomic events, such as steep increases or declines in national economic activity. In practice this is countered by using managerial expert judgement, which is well known to suffer from various biases, is expensive and not scalable. This paper evaluates multiple approaches to improve tactical sales forecasting using macro-economic leading indicators. The proposed statistical forecast selects automatically both the type of leading indicators, as well as the order of the lead for each of the selected indicators. However as the future values of the leading indicators are unknown an additional uncertainty is introduced. This uncertainty is controlled in our methodology by restricting inputs to an unconditional forecasting setup. We compare this with the conditional setup, where future indicator values are assumed to be known and assess the theoretical loss of forecast accuracy. We also evaluate purely statistical model building against judgement aided models, where potential leading indicators are pre-filtered by experts, quantifying the accuracy-cost trade-off. The proposed framework improves on forecasting accuracy over established time series benchmarks, while providing useful insights about the key leading indicators. We evaluate the proposed approach on a real case study and find 18.8\% accuracy gains over the current forecasting process.",
keywords = "Forecasting , Tactical planning, Leading indicators, Lasso, Variable selection",
author = "Sagaert, {Yves R.} and El-Houssaine Aghezzaf and Nikolaos Kourentzes and Bram Desmet",
note = "This is the author{\textquoteright}s version of a work that was accepted for publication in European Journal of Operational Research. Changes resulting from the publishing process, such as peer review, editing, corrections, structural formatting, and other quality control mechanisms may not be reflected in this document. Changes may have been made to this work since it was submitted for publication. A definitive version was subsequently published in European Journal of Operational Research, 264, 2, 2017 DOI: 10.1016/j.ejor.2017.06.054",
year = "2018",
month = jan,
day = "16",
doi = "10.1016/j.ejor.2017.06.054",
language = "English",
volume = "264",
pages = "558--569",
journal = "European Journal of Operational Research",
issn = "0377-2217",
publisher = "Elsevier Science B.V.",
number = "2",

}

RIS

TY - JOUR

T1 - Tactical sales forecasting using a very large set of macroeconomic indicators

AU - Sagaert, Yves R.

AU - Aghezzaf, El-Houssaine

AU - Kourentzes, Nikolaos

AU - Desmet, Bram

N1 - This is the author’s version of a work that was accepted for publication in European Journal of Operational Research. Changes resulting from the publishing process, such as peer review, editing, corrections, structural formatting, and other quality control mechanisms may not be reflected in this document. Changes may have been made to this work since it was submitted for publication. A definitive version was subsequently published in European Journal of Operational Research, 264, 2, 2017 DOI: 10.1016/j.ejor.2017.06.054

PY - 2018/1/16

Y1 - 2018/1/16

N2 - Tactical forecasting in supply chain management supports planning for inventory, scheduling production, and raw material purchase, amongst other functions. It typically refers to forecasts up to 12 months ahead. Traditional forecasting models take into account univariate information extrapolating from the past, but cannot anticipate macroeconomic events, such as steep increases or declines in national economic activity. In practice this is countered by using managerial expert judgement, which is well known to suffer from various biases, is expensive and not scalable. This paper evaluates multiple approaches to improve tactical sales forecasting using macro-economic leading indicators. The proposed statistical forecast selects automatically both the type of leading indicators, as well as the order of the lead for each of the selected indicators. However as the future values of the leading indicators are unknown an additional uncertainty is introduced. This uncertainty is controlled in our methodology by restricting inputs to an unconditional forecasting setup. We compare this with the conditional setup, where future indicator values are assumed to be known and assess the theoretical loss of forecast accuracy. We also evaluate purely statistical model building against judgement aided models, where potential leading indicators are pre-filtered by experts, quantifying the accuracy-cost trade-off. The proposed framework improves on forecasting accuracy over established time series benchmarks, while providing useful insights about the key leading indicators. We evaluate the proposed approach on a real case study and find 18.8\% accuracy gains over the current forecasting process.

AB - Tactical forecasting in supply chain management supports planning for inventory, scheduling production, and raw material purchase, amongst other functions. It typically refers to forecasts up to 12 months ahead. Traditional forecasting models take into account univariate information extrapolating from the past, but cannot anticipate macroeconomic events, such as steep increases or declines in national economic activity. In practice this is countered by using managerial expert judgement, which is well known to suffer from various biases, is expensive and not scalable. This paper evaluates multiple approaches to improve tactical sales forecasting using macro-economic leading indicators. The proposed statistical forecast selects automatically both the type of leading indicators, as well as the order of the lead for each of the selected indicators. However as the future values of the leading indicators are unknown an additional uncertainty is introduced. This uncertainty is controlled in our methodology by restricting inputs to an unconditional forecasting setup. We compare this with the conditional setup, where future indicator values are assumed to be known and assess the theoretical loss of forecast accuracy. We also evaluate purely statistical model building against judgement aided models, where potential leading indicators are pre-filtered by experts, quantifying the accuracy-cost trade-off. The proposed framework improves on forecasting accuracy over established time series benchmarks, while providing useful insights about the key leading indicators. We evaluate the proposed approach on a real case study and find 18.8\% accuracy gains over the current forecasting process.

KW - Forecasting

KW - Tactical planning

KW - Leading indicators

KW - Lasso

KW - Variable selection

U2 - 10.1016/j.ejor.2017.06.054

DO - 10.1016/j.ejor.2017.06.054

M3 - Journal article

VL - 264

SP - 558

EP - 569

JO - European Journal of Operational Research

JF - European Journal of Operational Research

SN - 0377-2217

IS - 2

ER -