Information use in supply chain forecasting

Fildes, Robert and Goodwin, Paul and Onkal, Dilek (2015): Information use in supply chain forecasting.

Abstract

Demand forecasting to support supply chain planning is a critical activity, recognized as pivotal in manufacturing and retailing operations where information is shared across functional areas to produce final detailed forecasts. The approach generally encountered is that a baseline statistical forecast is examined in the light of shared information from sales, marketing and logistics and the statistical forecast may then be modified to take these various pieces of information into account. This experimental study explores forecasters’ use of available information when they are faced with the task of adjusting a baseline forecast for a number of retail stock keeping units to take into account a forthcoming promotion. Forecasting demand in advance of promotions carries a particular significance given their intensive supply chain repercussions and financial impact. Both statistical and qualitative information was provided through a forecasting support system typical of those found in practice. Our results show participants responding to the quantity of information made available, though with decreasing scale effects. In addition, various statistical cues (which are themselves extraneous) were illustrated to be particularly important, including the size and timing of the last observed promotion. Overall, participants appeared to use a compensatory strategy when combining information that had either positive or negative implications for the success of the promotions. However, there was a consistent bias towards underestimating the effect of the promotions. These observed biases have important implications for the design of organizational sales and operations planning processes and the forecasting support systems that such processes rely on.

• Item Type: MPRA Paper
• Language: English
• Keywords: Demand planning; Sales and Operations Planning; Behavioural operations; Forecasting support systems; Promotional planning; Information effects.
• Subjects: D - Microeconomics > D8 - Information, Knowledge, and Uncertainty > D81 - Criteria for Decision-Making under Risk and Uncertainty; M - Business Administration and Business Economics ; Marketing ; Accounting ; Personnel Economics > M1 - Business Administration > M11 - Production Management; M - Business Administration and Business Economics ; Marketing ; Accounting ; Personnel Economics > M1 - Business Administration > M15 - IT Management

References

Allen, M., & Preiss, R. W. (1997). Comparing the persuasiveness of narrative and statistical evidence using meta‐analysis. Communication Research Reports, 14, 125-131

Aviv, Y. (2001). The effect of collaborative forecasting on supply chain performance, Management Science, 47, 1326-1343.

Ben-David, I., J.R. Graham, C.R. Harvey (in press). Managerial miscalibration, The Quarterly Journal of Economics, doi: 10.1093/qje/qjt023

Cooper, L. G., Baron, P., Levy, W., Swisher, M., & Gogos, P. (1999). PromoCast (TM): A new forecasting method for promotion planning. Marketing Science, 18, 301-316.

Croson, R., Schultz, K., Siemsen, E., & Yeo, M. L. (2013). Behavioral operations: The state of the field. Journal of Operations Management, 31, 1-5.

Danese, P., M. Kalchschmidt (2011a). The role of the forecasting process in improving forecast accuracy and operational performance, International Journal of Production Economics, 131, 204-214.

Danese, P., M. Kalchschmidt (2011b). The impact of forecasting on companies’ performance: Analysis in a multivariate setting, International Journal of Production Economics, 133, 458-469.

Dawes, R.M. (1979). The robust beauty of improper linear models in decision making. American Psychologist, 34, 571-582.

Dietvorst, B. J., Simmons, J. P., & Massey, C. (2015). Algorithm Aversion: People Erroneously Avoid Algorithms After Seeing Them Err. Journal of Experimental Psychology-General, 144, 114-126.

Eksoz, C., S.A. Mansouri, M. Bourlakis (2014). Collaborative forecasting in the food supply chain: A conceptual framework. International Journal of Production Economics. 158, 120-135.

Fildes, R., & Goodwin, P. (2007). Against your better judgment? How organizations can improve their use of management judgment in forecasting. Interfaces, 37, 570-576.

Fildes, R., Goodwin, P., & Lawrence, M. (2006). The design features of forecasting support systems and their effectiveness. Decision Support Systems, 42, 351-361.

Fildes, R., Goodwin, P., Lawrence, M., & Nikolopoulos, K. (2009). Effective forecasting and judgmental adjustments: an empirical evaluation and strategies for improvement in supply-chain planning. International Journal of Forecasting, 25, 3-23.

Fildes, R., & Hastings, R. (1994). The organization and improvement of market forecasting. Journal of the Operational Research Society, 45, 1-16.

Franses, P.H. (2014) Expert Adjustment of Model Forecasts, Cambridge: Cambridge University Press.

Franses, P.H., R. Legerstee (2010). Do experts’ adjustments on model-based SKU-level forecasts improve forecast quality? Journal of Forecasting, 29, 331-340.

Franses, P.H., R. Legerstee (2011). Experts’ adjustment to model-based SKU-level forecasts: Does the forecast horizon matter? Journal of the Operational Research Society, 62, 537-543.

Franses, P.H. and Legerstee, R. (2011). Combining SKU-level sales forecast from models and experts. Expert Systems with Applications. 38, 2365-2370.

Franses, P.H., R. Legerstee (2013). Do statistical forecasting models for SKU-level data benefit from including past expert knowledge? International Journal of Forecasting. 29, 80-87.

Goodwin, P. (2005). Providing support for decisions based on time series information under conditions of asymmetric loss. European Journal of Operational Research. 163, 388-402.

Goodwin, P., Lee, W.-Y., Fildes, R., Nikolopoulos, K., & M. Lawrence, M. (2007). Understanding the Use of Forecasting Systems: An Interpretive study in a Supply-Chain Company. University of Bath, School of Management Working Paper Series, 2007.14.

Harvey, N, (2007). Use of heuristics: Insights from forecasting research. Thinking and Reasoning. 13, 5-24.

Harvey, N., F. Bolger. and A.G.R. McClelland. 1994. On the nature of expectations. British Journal of Psychology. 85, 203-229.

Harvey, N., & Bolger, F. (1996). Graphs versus tables: Effects of data presentation format on judgemental forecasting. International Journal of Forecasting. 12(1), 119-137.

Hoch, S. J., & Schkade, D. A. (1996). A psychological approach to decision support systems. Management Science. 42(1), 51-64.

Hong, S., & Park, H. S. (2012). Computer-mediated persuasion in online reviews: Statistical versus narrative evidence. Computers in Human Behavior. 28, 906-919.

Hogarth, R. (1987) Judgment and Choice: The Psychology of Decision 2nd edition, Chichester: Wiley.

Kahneman, D., & Tversky, A. (1973). On the psychology of prediction. Psychological Review. 80, 237-251.

Kahneman, D., & Tversky, A. (1979). Prospect theory – Analysis of decision under risk. Econometrica. 47, 263-291.

Karelaia, N., & Hogarth, R. M. (2008). Determinants of linear judgment: A meta-analysis of lens model studies. Psychological Bulletin. 134, 404-426.

Krizan, Z., & Windschitl, P. D. (2007). The influence of outcome desirability on optimism. Psychological Bulletin. 133, 95-121.

Kunda, Z. (1990). The case for motivated reasoning. Psychological Bulletin. 108, 480-498.

Lawrence, M., Goodwin, P., O'Connor, M., & Onkal, D. (2006). Judgmental forecasting: A review of progress over the last 25 years. International Journal of Forecasting. 22, 493-518.

Lapide, L. (2007). Sales and operations planning (S&OP) mindsets, Journal of Business Forecasting. Spring, 21-31.

Lawrence, M. J., & Makridakis, S. (1989). Factors affecting judgmental forecasts and confidence intervals. Organizational Behavior and Human Decision Processes. 42, 172-187.

Lee, H.L., K.C. So, C.S. Tang (2000). The value of information sharing in a two-level supply chain, Management Science. 46, 626-643.

Lee, W. Y., Goodwin, P., Fildes, R., Nikolopoulos, K., & Lawrence, M. (2007). Providing support for the use of analogies in demand forecasting tasks. International Journal of Forecasting. 23, 377-390.

Legerstee, R., P.H. Franses (2014). Do experts’ SKU forecasts improve after feedback? Journal of Forecasting. 33, 69-79.

Leitner, J., & Leopold-Wildburger, U. (2011). Experiments on forecasting behavior with several sources of information – A review of the literature. European Journal of Operational Research. 213, 459-469.

Lim, J.S. and O'Connor, M. (1995), Judgemental adjustment of initial forecasts: its effectiveness and biases. Journal of Behavioral Decision Making, 8, 149-168.

McGregor, D. (1938). The major determinants of the prediction of social events, Journal of Abnormal Psychology, 33, 179-204.

Moon, M. A., Mentzer, J. T., & Smith, C. D. (2003). Conducting a sales forecasting audit. International Journal of Forecasting. 19, 5-25.

Moore, D. A., Tenney, E. R., & Haran, U. (in press). Overprecision in judgment. In G. Wu and G. Keren (Eds.), Handbook of Judgment and Decision Making. New York: Wiley.

Müller, H. C, (2011). Forecast Errors in Undisclosed Management Sales Forecasts: The Disappearance of the Overoptimism Bias, DICE discussion paper, No. 40

Nikolopoulos, K., & Fildes, R. (2013). Adjusting supply chain forecasts for short-term temperature estimates: a case study in a Brewing company. IMA Journal of Management Mathematics, 24, 79-88.

O'Connor, M., Remus, W., & Griggs, K. (1997). Going up-going down: How good are people at forecasting trends and changes in trends? Journal of Forecasting, 16, 165-176.

Oliva, R., N. Watson (2011). Cross-functional alignment in supply chain planning: A case study of sales and operations planning. Journal of Operations Management. 29, 434-448.

Olsen, R.A. (1997). Desirability bias among professional investment managers: Some evidence from experts, Journal of Behavioral Decision Making. 10, 65-72.

Önkal, D., and E. Aktas (2011). Supply chain flexibility: Managerial implications. In D. Önkal and E. Aktas (eds.), Supply Chain Systems-Pathways for Research and Practice, Croatia: Intech Publ., pp 75-84.

Önkal, D., K. Z. Sayım, and M.S. Gönül (2013). Scenarios as channels of forecast advice, Technological Forecasting & Social Change. 80, 772-788.

Payne, J.W., Bettman, J.R. & Johnson, E.J. (1993). The Adaptive Decision Maker. Cambridge: Cambridge University Press.

Reimers, S., & Harvey, N. (2011). Sensitivity to autocorrelation in judgmental time series forecasting. International Journal of Forecasting. 27, 1196-1214.

Reinard, J. C. (1988). The empirical study of the persuasive effects of evidence – The status after 50 years of research. Human Communication Research. 15, 3-59.

Ritov, I., & Baron, J. (1992). Status-quo and omission biases. Journal of Risk and Uncertainty. 5, 49-61.

Rogers, G., & Soopramanien, D. (2009). The truth is out there! How external validity can lead to better marketing decisions. International Journal of Market Research. 51, 163-180.

Rozin, P., & Royzman, E. B. (2001). Negativity bias, negativity dominance, and contagion. Personality and Social Psychology Review. 5, 296-320.

Seifert, M., Siemsen, E., Hadida, A. L., & Eisingerich, A. B. (2015). Effective judgmental forecasting in the context of fashion products. Journal of Operations Management. 36, 33-45.

Siemsen, E. (2011). The usefulness of behavioral laboratory experiments in supply chain management research. Journal of Supply Chain Management. 47(3), 17-18.

Stahl, R.A. (2010). Executive S&OP: Managing to achieve consensus. Foresight: The International Journal of Applied Forecasting., Fall, 34-38.

Thomé, A.M.T., L.F. Scavarda, N.S. Fernandez, A.J. Scavarda (2012). Sales and operations planning: A research synthesis, International Journal of Production Economics. 138, 1-13.

Tyebjee, T. T. (1987). Behavioral biases in new product forecasting. International Journal of Forecasting, 3, 393–404.

Trapero, J. R., Pedregal, D. J., Fildes, R., & Kourentzes, N. (2013). Analysis of judgmental adjustments in the presence of promotions. International Journal of Forecasting. 29, 234-243.

Tuomikangas, N., & Kaipia, R. (2014). A coordination framework for sales and operations planning (S&OP): Synthesis from the literature. International Journal of Production Economics, 154, 243-262.

Zhao, X., Zhao, X., & Wu, Y. (2013). Opportunities for research in behavioral operations management. International Journal of Production Economics. 142, 1-2.

Weller, M., & Crone, S. F. (2012). Supply Chain Forecasting: Best Practices & Benchmarking Study. Lancaster University. http://www.lancaster.ac.uk/lums/forecasting/material/

Windschitl, P.D., A.R. Smith, J.P.Rose, Z. Krizan (1020). The desirability bias in predictions: Going optimistic without leaving realism, Organizational Behavior and Human Decision Processes. 111, 33-47.

Yu, Z., H. Yan, T.C.E. Cheng (2001). Benefits of information sharing with supply chain partnerships, Industrial Management & Data Systems. 101, 114-121.