The evolution of family level sales forecasts into product level forecasts: Modeling and estimation

Author: Zhou Shu   Jackson Peter   Roundy Robin O.   Zhang Rachel Q.  

Publisher: Taylor & Francis Ltd

ISSN: 0740-817X

Source: IIE Transactions, Vol.39, Iss.9, 2007-09, pp. : 831-843

Disclaimer: Any content in publications that violate the sovereignty, the constitution or regulations of the PRC is not accepted or approved by CNPIEC.

Previous Menu Next

Abstract

It is frequently the case that sales forecasts are available at the detailed product level for only a relatively short time horizon. For the rest of the forecast horizon, only aggregate sales forecasts at the product family level are available. The problem addressed in this paper is how to fit a forecast simulation model to a history of these aggregate and disaggregate forecasts. Our approach to develop such a model is to combine a forecast update model with a forecast disaggregation model. The forecast update model is called the Martingale model of forecast evolution. The parameters of the two models must be estimated from historical forecast data. It is this statistical parameter estimation problem that occupies the major part of our investigation. We recommend an estimation technique based on the method of moments.