Multivariate Demand : Modeling and Estimation from Censored Sales

Demand modeling and forecasting is important for inventory management, retail assortment and revenue management applications. Current practice focuses on univariate demand forecasting, where models are built separately for each product. However, in many industries there is empirical evidence of correlated product demand. In addition, demand is usually observed in several periods during a selling horizon, and it may be truncated due to inventory constraints so that in practice only censored sales data are recorded. Ignoring the inter-product demand correlation or the serial correlation of demand from one selling period to the next leads to biased and inefficient estimates of the true demand distributions. In this paper we propose a class of models for multi-product multiperiod aggregate demand forecasting. We develop an approach for estimating the parameters of the demand models from censored sales data in a maximum likelihood framework using the Expectation-Maximization (EM) algorithm. Through a simulation study, we show that the algorithm is computationally attractive and leads to maximum likelihood estimates with good properties, under different demand and censoring scenarios. We exemplify the methodology with the analysis of two booking data sets from the entertainment and the airline industries, and show that the use of these models in a revenue management setting for airlines increases the revenue by up to 11% relative to the use of alternative demand forecasting methods.

[1]  Anton J. Kleywegt,et al.  Models of the Spiral-Down Effect in Revenue Management , 2006, Oper. Res..

[2]  Jeffrey I. McGill,et al.  Censored regression analysis of multiclass passenger demand data subject to joint capacity constraints , 1995, Ann. Oper. Res..

[3]  Hans Jan. Schneider,et al.  Matrices and Linear Algebra , 1973 .

[4]  Larry Weatherford,et al.  Better unconstraining of airline demand data in revenue management systems for improved forecast accuracy and greater revenues , 2002 .

[5]  Victor DeMiguel,et al.  What Multistage Stochastic Programming Can Do for Network Revenue Management , 2006 .

[6]  M. Kenward,et al.  An Introduction to the Bootstrap , 2007 .

[7]  Peter E. Rossi,et al.  Bayesian Statistics and Marketing , 2005 .

[8]  Garrett J. van Ryzin,et al.  Revenue Management Under a General Discrete Choice Model of Consumer Behavior , 2004, Manag. Sci..

[9]  Marshall L. Fisher,et al.  Demand Estimation and Assortment Optimization Under Substitution: Methodology and Application , 2007, Oper. Res..

[10]  Garrett J van Ryzin Future of Revenue Management: Models of demand , 2005 .

[11]  Jeffrey I. McGill,et al.  Airline Seat Allocation with Multiple Nested Fare Classes , 1993, Oper. Res..

[12]  N. L. Johnson,et al.  Continuous Univariate Distributions. , 1995 .

[13]  Stephen A. Smith,et al.  Estimating negative binomial demand for retail inventory management with unobservable lost sales , 1996 .

[14]  E. Kaplan,et al.  Nonparametric Estimation from Incomplete Observations , 1958 .

[15]  G. Ryzin,et al.  On the Relationship Between Inventory Costs and Variety Benefits in Retailassortments , 1999 .

[16]  W. E. Wecker Predicting Demand from Sales Data in the Presence of Stockouts , 1978 .

[17]  M. Pagano,et al.  Survival analysis. , 1996, Nutrition.

[18]  G. Ryzin,et al.  Revenue Management Without Forecasting or Optimization: An Adaptive Algorithm for Determining Airline Seat Protection Levels , 2000 .

[19]  New York Dover,et al.  ON THE CONVERGENCE PROPERTIES OF THE EM ALGORITHM , 1983 .

[20]  Christopher T. Conlon,et al.  Demand Estimation Under Incomplete Product Availability , 2008 .

[21]  M. Dada,et al.  Estimation of Consumer Demand with Stock-Out Based Substitution: An Application to Vending Machine Products , 1998 .

[22]  Mark Ferguson,et al.  A Comparison of Unconstraining Methods to Improve Revenue Management Systems , 2009 .

[23]  Martin A. Koschat Store inventory can affect demand: Empirical evidence from magazine retailing , 2008 .

[24]  Yi Xu,et al.  Retail Assortment Planning in the Presence of Consumer Search , 2005, Manuf. Serv. Oper. Manag..

[25]  Gordon Johnston,et al.  Statistical Models and Methods for Lifetime Data , 2003, Technometrics.

[26]  Jeffrey I. McGill,et al.  Revenue Management: Research Overview and Prospects , 1999, Transp. Sci..

[27]  S. Nahmias Demand estimation in lost sales inventory systems , 1994 .

[28]  R. Ratliff,et al.  A multi-flight recapture heuristic for estimating unconstrained demand from airline bookings , 2008 .

[29]  K. Talluri,et al.  The Theory and Practice of Revenue Management , 2004 .

[30]  S. Karabati,et al.  Can the desired service level be achieved when the demand and lost sales are unobserved? , 2004 .

[31]  Evan L. Porteus,et al.  Stalking Information: Bayesian Inventory Management with Unobserved Lost Sales , 1999 .

[32]  Peter Paul Belobaba,et al.  Air travel demand and airline seat inventory management , 1987 .

[33]  Amy Hing-Ling Lau,et al.  Estimating the demand distributions of single-period items having frequent stockouts , 1996 .