Thesis/Capstone
Publication Date
Authored By
Advisor(s): Sergio Alex Caballero
Topic(s) Covered:
  • Demand Planning
  • Forecasting
  • Metrics
  • Strategy
Abstract

Business forecasting frequently combines quantitative time series techniques with qualitative expert opinion overrides to create a final consensus forecast. The objective of these overrides is to reduce forecast error, which enables safety stock reduction, customer service improvement, and manufacturing schedule stability. However, these overrides often fail to improve final forecast accuracy. Process mis-steps include small adjustments, adjustments to accurate statistical forecasts, and adjustments to match financial goals. At best, these overrides waste scare forecasting resources; at worst, they seriously impact business performance.

This report offers a framework for identifying overrides that are likely to improve forecast accuracy. A new class of metrics, Dispersion-Scaled Overrides, was developed as an input to the framework. Other inputs included statistical forecast accuracy and auto-correlation. Classification techniques were used to identify whether an override was likely to create forecast value add. These techniques were found to be approximately 80% accurate in predicting success. This result suggests that using Dispersion-Scaled Overrides alongside common forecast accuracy metrics can reliably predict forecast value add. In turn, this can maximize the value that experts add to the business forecasting process.