Retail Inventory Management When Records Are Inaccurate

Inventory record inaccuracy is a significant problem for retailers using automated inventory management systems. In this paper, we consider an intelligent inventory management tool that accounts for record inaccuracy using a Bayesian belief of the physical inventory level. We assume that excess demands are lost and unobserved, in which case sales data reveal information about physical inventory levels. We show that a probability distribution on physical inventory levels is a sufficient summary of past sales and replenishment observations, and that this probability distribution can be efficiently updated in a Bayesian fashion as observations are accumulated. We also demonstrate the use of this distribution as the basis for practical replenishment and inventory audit policies and illustrate how the needed parameters can be estimated using data from a large national retailer. Our replenishment policies avoid the problem of “freezing,” in which a physical inventory position persists at zero while the corresponding record is positive. In addition, simulation studies show that our replenishment policies recoup much of the cost of inventory record inaccuracy, and that our audit policy significantly outperforms the popular “zero balance walk” audit policy.

[1]  R. F. Rinehart Effects and Causes of Discrepancies in Supply Operations , 1960 .

[2]  R. Faure,et al.  Introduction to operations research , 1968 .

[3]  D. A. Schrady,et al.  Operational definitions of inventory record accuracy , 1970 .

[4]  D. Iglehart,et al.  Inventory Systems with Imperfect Asset Information , 1972 .

[5]  Edward J. Sondik,et al.  The Optimal Control of Partially Observable Markov Processes over a Finite Horizon , 1973, Oper. Res..

[6]  Linus Schrage,et al.  A guide to simulation , 1983 .

[7]  Paul Bratley,et al.  A guide to simulation , 1983 .

[8]  Richard C. Morey,et al.  Estimating service level impacts from changes in cycle count, buffer stock, or corrective action , 1985 .

[9]  R. C. Morey,et al.  Optimal Timing of Account Audits in Internal Control , 1986 .

[10]  J. Rice Mathematical Statistics and Data Analysis , 1988 .

[11]  W. Lovejoy A survey of algorithmic methods for partially observed Markov decision processes , 1991 .

[12]  Steven Nahmias,et al.  Optimizing inventory levels in a two-echelon retailer system with partial lost sales , 1994 .

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

[14]  T. Redman Improve Data Quality for Competitive Advantage , 1995 .

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

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

[17]  M. Fisher,et al.  Rocket-Science Retailing Is Almost Here: Are You Ready? , 2000 .

[18]  Paul H. Zipkin,et al.  Foundations of Inventory Management , 2000 .

[19]  A. Raman,et al.  Execution: The Missing Link in Retail Operations , 2001 .

[20]  Martin L. Puterman,et al.  The Censored Newsvendor and the Optimal Acquisition of Information , 2002, Oper. Res..

[21]  C. R. Sox,et al.  Adaptive Inventory Control for Nonstationary Demand and Partial Information , 2002, Manag. Sci..

[22]  Yun Kang,et al.  Information inaccuracy in inventory systems: stock loss and stockout , 2005 .

[23]  Yossi Aviv,et al.  A Partially Observed Markov Decision Process for Dynamic Pricing , 2005, Manag. Sci..

[24]  Kevin H. Shang,et al.  Inspection and Replenishment Policies for Systems with Inventory Record Inaccuracy , 2007, Manuf. Serv. Oper. Manag..

[25]  Hau L. Lee,et al.  Unlocking the Value of RFID , 2007 .

[26]  Suresh P. Sethi,et al.  Partially Observed Inventory Systems: The Case of Zero-Balance Walk , 2007, SIAM J. Control. Optim..

[27]  Ananth Raman,et al.  Inventory Record Inaccuracy: An Empirical Analysis , 2008, Manag. Sci..

[28]  Li Chen,et al.  Dynamic Inventory Management with Learning About the Demand Distribution and Substitution Probability , 2008, Manuf. Serv. Oper. Manag..