Illinois Superconductor Corp. a technology start-up, came up with an innovative new superconducting filter for use in cellular base stations. It needed to estimate the demand for its filters. The manager came up with a simple chain-ratio-based forecasting model that, while simple and intuitive, was too simplistic. The company had also commissioned a research firm to develop a model-based forecast. The model-based forecast used diffusion modeling, analogy-based forecasting, and conjoint analysis to create a forecast that incorporated customer preferences, diffusion effects, and competitive dynamics.
To use the data to generate a model-based forecast and to reconcile the model-based forecast with the manager's forecast. Requires sophisticated spreadsheet modeling and the application of advanced forecasting techniques.
