Title: An expected value approach to forecast reconciliation with forecast targets and under asymmetric costs

Authors: Alan Fask

Addresses: Fairleigh Dickinson University, Madison, New Jersey 07940, USA

Abstract: A common problem in many business, economic and government organisations is the reconciliation of a group of lower level forecasts to the forecast of the aggregate of that group. Reconciliation may focus on a particular target for the aggregate forecast, or there may be no target. A number of approaches have been suggested, including top-down, bottom-up, hybrid and regression based methods. The reconciliation problem may be for only a single level, but often extends to the entire hierarchy of the organisation. This paper examines a different approach to forecast reconciliation, a minimum expected value approach, both analytically and through examples. Particular concern is the cost implications of forecast errors. Both symmetric cost functions (quadratic) and asymmetric cost functions (linex) are examined. Although the focus is on a single level hierarchy, multilevel and multidimensional reconciliation are also discussed. This paper is unique in that it studies asymmetrical forecast cost functions in an organisational hierarchy through simulations and an actual data example. Both targeted and non-targeted forecasts are considered. It also introduces the minimum expected value method, a new method of forecast reconciliation.

Keywords: reconciling forecasts; top-down forecasting; bottom-up forecasting; forecast cost functions; asymmetric forecast cost functions; symmetric forecast cost functions.

DOI: 10.1504/IJBFMI.2023.134476

International Journal of Business Forecasting and Marketing Intelligence, 2023 Vol.8 No.4, pp.332 - 346

Received: 13 Sep 2022
Accepted: 23 Oct 2022
Published online: 24 Oct 2023 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article