Abstract
This paper deals with the issue of forecastability of sales activities of independent financial advisers (agents). Employing the most common quantitative methods on a diverse sample of timelines from multiple advisory companies, we have found that under most settings, these methods offer sub-par performance with high relative errors and no statistical differences between them. When a more granular approach is applied (reflecting sales unit size), ARIMA and the simple moving average emerge as significantly less accurate. This outcome is true for all sales units regardless of their size, when relative error is concerned. Thus, our analysis confirms the difficult forecastability of financial sales, speaking against the utilisation of more sophisticated forecasting methods, which mostly fail when compared to their much simpler and less costly counterparts.
Similar content being viewed by others
Notes
Total sample n = 134 US companies.
Results for 3-month–2-year forecasting horizon, total sample n = 186 US companies.
Autumn annual prediction, published usually by November of the previous year.
Scale dependent measures such as MAE or RMSE are disqualified by different units among the timelines.
See Hyndman and Athanasopoulos (2018), chapter Time series cross-validation for details on this technique.
In detail: 10.2 years for big units, 7.9 for medium units and 5.2 for small units.
Other common variation metrics (mean, standard deviation) are not usable because of different units used by individual time series.
References
Ali, M.M., and J.E. Boylan. 2010. The value of forecast information sharing in supply chains. Foresight: The International Journal of Applied Forecasting 18: 14–18.
Catt, P.M. 2009. Forecastability: Insights from physics, graphical decomposition, and information theory. Foresight 13 (Spring): 24–33.
Chen, K.Y. 2011. Combining linear and nonlinear model in forecasting tourism demand. Expert Systems with Applications 38 (8): 10368–10376.
Chu, C.W., and G.P. Zhang. 2003. A comparative study of linear and nonlinear models for aggregate retail sales forecasting. International Journal of Production Economics 86 (3): 217–231.
Czech National Bank—CNB. 2018a. Inflation statistics. Accessed 6 September 2018. https://www.cnb.cz/en/statistics/inflation/index.html.
Czech National Bank—CNB. 2018b. Repo interest rate over time. Accessed 6 September 2018. https://www.cnb.cz/cs/faq/jak_se_vyvijela_dvoutydenni_repo_sazba_cnb.html.
Czech Statistical Office—CZSO. 2018a. Employment, unemployment statistics. Accessed 6 September 2018. https://www.czso.cz/csu/czso/employment_unemployment_ekon.
Czech Statistical Office—CZSO. 2018b. Wages and labour statistics. Accessed 6 September 2018. https://www.czso.cz/csu/czso/labour_and_earnings_ekon.
Dalrymple, D.J. 1975. Sales forecasting methods and accuracy. Business Horizons 18 (6): 69–73.
Dalrymple, D.J. 1987. Sales forecasting practices: Results from a United States survey. International Journal of Forecasting 3 (3–4): 379–391.
Gilliland, M. 2010. The Business Forecasting Deal: Exposing Myths, Eliminating Bad Practices, Providing Practical Solutions. New York, USA: Wiley.
Goodwin, P. 2011. High on complexity, low on evidence: Are advanced forecasting methods always as good as they seem?. Foresight: The International Journal of Applied Forecasting 23: 10–12.
Gordon, A. 2010. The boundaries of quantitative forecasting methods: Respecting the limits of determinism. Foresight: The International Journal of Applied Forecasting 19: 9–15.
Green, K.C., and J.S. Armstrong. 2015. Simple versus complex forecasting: The evidence. Journal of Business Research 68 (8): 1678–1685.
Green, K.C., J.S. Armstrong, and W. Soon. 2009. Validity of climate change forecasting for public policy decision making. International Journal of Forecasting 25 (4): 826–832.
Hyndman, R.J., and G. Athanasopoulos. 2018. Forecasting: Principles and practice. Published by OTexts.com, full text available at: https://www.otexts.org/fpp.
Hyndman, R.J., and A.B. Koehler. 2006. Another look at measures of forecast accuracy. International Journal of Forecasting 22 (4): 679–688.
Hyndman, R.J., and A.V. Kostenko. 2007. Minimum sample size requirements for seasonal forecasting models. Foresight 6 (Spring): 12–15.
Hofer, P., C. Eisl, and A. Mayr. 2015. Forecasting in Austrian companies: Do small and large Austrian companies differ in their forecasting processes? Journal of Applied Accounting Research 16 (3): 359–382.
Kaltenbacher, J., and R. Decker. 2014. New product sales forecasting: An approach for the insurance business. World Journal of Management 5 (1): 36–53.
Lee, J., Lee, C. Y., & Lee, K. S. (2012). Forecasting demand for a newly introduced product using reservation price data and Bayesian updating. Technological Forecasting and Social Change 79 (7): 1280–1291.
Madhani, P.M. 2016. Sales and marketing integration: Enhancing competitive advantages. The IUP Journal of Business Strategy 13 (4): 50–77.
Makridakis, S., and M. Hibon. 2000. The M3-Competition: Results, conclusions and implications. International Journal of Forecasting 16 (4): 451–476.
Makridakis, S., A. Andersen, R. Carbone, R. Fildes, M. Hibon, R. Lewandowski, and R. Winkler. 1982. The accuracy of extrapolation (time series) methods: Results of a forecasting competition. Journal of Forecasting 1 (2): 111–153.
Ministry of Finance of the Czech Republic—MF. 2018. Macroeconomic forecast. Accessed 6 September 2018. http://www.mfcr.cz/cs/verejny-sektor/makroekonomika/makroekonomicka-predikce.
McCarthy, T.M., D.F. Davis, S.L. Golicic, and J.T. Mentzer. 2006. The evolution of sales forecasting management: A 20-year longitudinal study of forecasting practices. Journal of Forecasting 25 (5): 303–324.
Mentzer, J.T., and K.B. Kahn. 1995. Forecasting technique familiarity, satisfaction, usage, and application. Journal of Forecasting 14 (5): 465–476.
Merrilees, B., and K.S. Fam. 1999. Effective methods of managing retail sales. The International Review of Retail, Distribution and Consumer Research 9 (1): 81–92.
O’Grady, J.P. 1965. Sales forecasting techniques used by selected life insurance companies. The Journal of Risk and Insurance 32 (1): 113–120.
Peterson, R.M., G.L. Gordon, and V. Krishnan. 2015. When sales and marketing align: Impact on performance. Journal of Selling 1 (15): 29–43.
Ramos, P., N. Santos, and R. Rebelo. 2015. Performance of state space and ARIMA models for consumer retail sales forecasting. Robotics and Computer-Integrated Manufacturing 34: 151–163.
Reifner, U., Neuberger, D., Rissi, R., Riefa, Ch., Knobloch, M., Clerc-Renaud, S. and Finger Ch. 2012. Study on remuneration structures of financial services intermediaries and conflicts of interest. [Working Paper, No. MARKT/2012/026/H]. Hamburg, Germany: IFF - Institut für Finanzdienstleistungen.
Salomon, R., and J.M. Shaver. 2005. Export and domestic sales: Their interrelationship and determinants. Strategic Management Journal 26 (9): 855–871.
Syntetos, A.A., M.Z. Babai, and E.S. Gardner. 2015. Forecasting intermittent inventory demands: Simple parametric methods vs. bootstrapping. Journal of Business Research 68 (8): 1746–1752.
Acknowledgements
This work was supported by the Czech Science Foundation under Grant No. 16-21506S: New sources of systemic risk on financial markets (2016–2018).
Author information
Authors and Affiliations
Corresponding author
Additional information
Publisher's Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Rights and permissions
About this article
Cite this article
Šindelář, J. Sales forecasting in financial distribution: a comparison of quantitative forecasting methods. J Financ Serv Mark 24, 69–80 (2019). https://doi.org/10.1057/s41264-019-00068-3
Revised:
Published:
Issue Date:
DOI: https://doi.org/10.1057/s41264-019-00068-3