IDEAS home Printed from https://ideas.repec.org/a/inm/oropre/v63y2015i1p134-150.html
   My bibliography  Save this article

Demand Estimation and Ordering Under Censoring: Stock-Out Timing Is (Almost) All You Need

Author

Listed:
  • Aditya Jain

    (Indian School of Business, Hyderabad 500 032, India)

  • Nils Rudi

    (INSEAD, 138676 Singapore)

  • Tong Wang

    (NUS Business School, National University of Singapore, 119245 Singapore)

Abstract

Retailers facing uncertain demand can use observed sales to update demand estimates. However, such learning is limited by the amount of inventory carried; when demand exceeds inventory (i.e., when a stock-out event occurs), a retailer in general cannot observe actual demand. We propose using observations on the timing of sales occurrences in a Bayesian fashion to learn about demand, and we analyze this learning method for a multiperiod newsvendor setting. We find that, as previously shown with the use of only stock-out event observations, the optimal order quantity with timing observations is greater than the optimal order quantity with full demand observations. We prove this result using a novel methodology from the statistics literature on comparison of experiments. Although the optimal over-ordering with timing observations tends to be less than that with only stock-out event observations in most cases, we do observe cases where the opposite is true. Such cases correspond to high demand uncertainty and low margins, where marginal learning from timing observations is significantly higher than using only a stock-out event. In an extensive numerical study we find that, on average and with respect to uncensored demand observations, the use of timing observations eliminates 76.1% of the loss in expected profit from using only stock-out event observations. We show that, for Poisson and normal demand with unknown mean, the proposed learning method is tractable as well as intuitively appealing: the information contained in the timing of sales occurrences is fully captured by a single number—the timing of stock-out. We also investigate checkpoint models in which the newsvendor can make observations only at predetermined times in a period, and illustrate its convergence to the models with timing and stock-out event observations.

Suggested Citation

  • Aditya Jain & Nils Rudi & Tong Wang, 2015. "Demand Estimation and Ordering Under Censoring: Stock-Out Timing Is (Almost) All You Need," Operations Research, INFORMS, vol. 63(1), pages 134-150, February.
  • Handle: RePEc:inm:oropre:v:63:y:2015:i:1:p:134-150
    DOI: 10.1287/opre.2014.1326
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/opre.2014.1326
    Download Restriction: no

    File URL: https://libkey.io/10.1287/opre.2014.1326?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Gustavo Vulcano & Garrett van Ryzin & Richard Ratliff, 2012. "Estimating Primary Demand for Substitutable Products from Sales Transaction Data," Operations Research, INFORMS, vol. 60(2), pages 313-334, April.
    2. Li Chen & Erica L. Plambeck, 2008. "Dynamic Inventory Management with Learning About the Demand Distribution and Substitution Probability," Manufacturing & Service Operations Management, INFORMS, vol. 10(2), pages 236-256, May.
    3. Katy S. Azoury, 1985. "Bayes Solution to Dynamic Inventory Models Under Unknown Demand Distribution," Management Science, INFORMS, vol. 31(9), pages 1150-1160, September.
    4. William E. Wecker, 1978. "Predicting Demand from Sales Data in the Presence of Stockouts," Management Science, INFORMS, vol. 24(10), pages 1043-1054, June.
    5. Ravi Anupindi & Maqbool Dada & Sachin Gupta, 1998. "Estimation of Consumer Demand with Stock-Out Based Substitution: An Application to Vending Machine Products," Marketing Science, INFORMS, vol. 17(4), pages 406-423.
    6. Arnab Bisi & Maqbool Dada & Surya Tokdar, 2011. "A Censored-Data Multiperiod Inventory Problem with Newsvendor Demand Distributions," Manufacturing & Service Operations Management, INFORMS, vol. 13(4), pages 525-533, October.
    7. Steven Nahmias, 1994. "Demand estimation in lost sales inventory systems," Naval Research Logistics (NRL), John Wiley & Sons, vol. 41(6), pages 739-757, October.
    8. A. Gürhan Kök & Marshall L. Fisher, 2007. "Demand Estimation and Assortment Optimization Under Substitution: Methodology and Application," Operations Research, INFORMS, vol. 55(6), pages 1001-1021, December.
    9. Alain Bensoussan & Metin Çakanyıldırım & Suresh P. Sethi, 2009. "Technical Note---A Note on “The Censored Newsvendor and the Optimal Acquisition of Information”," Operations Research, INFORMS, vol. 57(3), pages 791-794, June.
    10. Lau, Hon-Shiang & Hing-Ling Lau, Amy, 1996. "Estimating the demand distributions of single-period items having frequent stockouts," European Journal of Operational Research, Elsevier, vol. 92(2), pages 254-265, July.
    11. Gregory A. Godfrey & Warren B. Powell, 2001. "An Adaptive, Distribution-Free Algorithm for the Newsvendor Problem with Censored Demands, with Applications to Inventory and Distribution," Management Science, INFORMS, vol. 47(8), pages 1101-1112, August.
    12. Li Chen, 2010. "Bounds and Heuristics for Optimal Bayesian Inventory Control with Unobserved Lost Sales," Operations Research, INFORMS, vol. 58(2), pages 396-413, April.
    13. Christopher T. Conlon & Julie Holland Mortimer, 2013. "Demand Estimation under Incomplete Product Availability," American Economic Journal: Microeconomics, American Economic Association, vol. 5(4), pages 1-30, November.
    14. Gustavo Vulcano & Garrett van Ryzin & Wassim Chaar, 2010. "OM Practice--Choice-Based Revenue Management: An Empirical Study of Estimation and Optimization," Manufacturing & Service Operations Management, INFORMS, vol. 12(3), pages 371-392, February.
    15. Woonghee Tim Huh & Paat Rusmevichientong, 2009. "A Nonparametric Asymptotic Analysis of Inventory Planning with Censored Demand," Mathematics of Operations Research, INFORMS, vol. 34(1), pages 103-123, February.
    16. David J. Braden & Marshall Freimer, 1991. "Informational Dynamics of Censored Observations," Management Science, INFORMS, vol. 37(11), pages 1390-1404, November.
    17. Xiangwen Lu & Jing-Sheng Song & Kaijie Zhu, 2008. "Analysis of Perishable-Inventory Systems with Censored Demand Data," Operations Research, INFORMS, vol. 56(4), pages 1034-1038, August.
    18. Vivek F. Farias & Srikanth Jagabathula & Devavrat Shah, 2013. "A Nonparametric Approach to Modeling Choice with Limited Data," Management Science, INFORMS, vol. 59(2), pages 305-322, December.
    19. Woonghee Tim Huh & Ganesh Janakiraman & John A. Muckstadt & Paat Rusmevichientong, 2009. "An Adaptive Algorithm for Finding the Optimal Base-Stock Policy in Lost Sales Inventory Systems with Censored Demand," Mathematics of Operations Research, INFORMS, vol. 34(2), pages 397-416, May.
    20. Kalyan Talluri & Garrett van Ryzin, 2004. "Revenue Management Under a General Discrete Choice Model of Consumer Behavior," Management Science, INFORMS, vol. 50(1), pages 15-33, January.
    21. Martin A. Lariviere & Evan L. Porteus, 1999. "Stalking Information: Bayesian Inventory Management with Unobserved Lost Sales," Management Science, INFORMS, vol. 45(3), pages 346-363, March.
    22. Donald L. Iglehart, 1964. "The Dynamic Inventory Problem with Unknown Demand Distribution," Management Science, INFORMS, vol. 10(3), pages 429-440, April.
    23. Woonghee Tim Huh & Retsef Levi & Paat Rusmevichientong & James B. Orlin, 2011. "Adaptive Data-Driven Inventory Control with Censored Demand Based on Kaplan-Meier Estimator," Operations Research, INFORMS, vol. 59(4), pages 929-941, August.
    24. Apostolos N. Burnetas & Craig E. Smith, 2000. "Adaptive Ordering and Pricing for Perishable Products," Operations Research, INFORMS, vol. 48(3), pages 436-443, June.
    25. Narendra Agrawal & Stephen A. Smith, 1996. "Estimating negative binomial demand for retail inventory management with unobservable lost sales," Naval Research Logistics (NRL), John Wiley & Sons, vol. 43(6), pages 839-861, September.
    26. Andrés Musalem & Marcelo Olivares & Eric T. Bradlow & Christian Terwiesch & Daniel Corsten, 2010. "Structural Estimation of the Effect of Out-of-Stocks," Management Science, INFORMS, vol. 56(7), pages 1180-1197, July.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Anna‐Lena Sachs & Michael Becker‐Peth & Stefan Minner & Ulrich W. Thonemann, 2022. "Empirical newsvendor biases: Are target service levels achieved effectively and efficiently?," Production and Operations Management, Production and Operations Management Society, vol. 31(4), pages 1839-1855, April.
    2. Wan, Mingchao & Huang, Yihui & Zhao, Lei & Deng, Tianhu & Fransoo, Jan C., 2018. "Demand estimation under multi-store multi-product substitution in high density traditional retail," European Journal of Operational Research, Elsevier, vol. 266(1), pages 99-111.
    3. Mendes, Paulo & Leal, José Eugênio & Thomé, Antônio Márcio Tavares, 2016. "A maturity model for demand-driven supply chains in the consumer product goods industry," International Journal of Production Economics, Elsevier, vol. 179(C), pages 153-165.
    4. Derhami, Shahab & Montreuil, Benoit & Bau, Guilhem, 2021. "Assessing product availability in omnichannel retail networks in the presence of on-demand inventory transshipment and product substitution," Omega, Elsevier, vol. 102(C).
    5. Zizhuo Wang & Chaolin Yang & Hongsong Yuan & Yaowu Zhang, 2021. "Aggregation Bias in Estimating Log‐Log Demand Function," Production and Operations Management, Production and Operations Management Society, vol. 30(11), pages 3906-3922, November.
    6. Li, Xishu & Yin, Ying & Manrique, David Vergara & Bäck, Thomas, 2021. "Lifecycle forecast for consumer technology products with limited sales data," International Journal of Production Economics, Elsevier, vol. 239(C).
    7. Ali Hortacsu & Olivia R. Natan & Hayden Parsley & Timothy Schwieg & Kevin R. Williams, 2021. "Incorporating Search and Sales Information in Demand Estimation," Cowles Foundation Discussion Papers 2313R1, Cowles Foundation for Research in Economics, Yale University, revised Mar 2023.
    8. Joonkyum Lee & Vishal Gaur & Suresh Muthulingam & Gary F. Swisher, 2016. "Stockout-Based Substitution and Inventory Planning in Textbook Retailing," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 104-121, February.
    9. Michael Jong Kim, 2020. "Variance Regularization in Sequential Bayesian Optimization," Mathematics of Operations Research, INFORMS, vol. 45(3), pages 966-992, August.
    10. Georgia Perakis & Melvyn Sim & Qinshen Tang & Peng Xiong, 2023. "Robust Pricing and Production with Information Partitioning and Adaptation," Management Science, INFORMS, vol. 69(3), pages 1398-1419, March.
    11. Jiri Chod & Mihalis G. Markakis & Nikolaos Trichakis, 2021. "On the Learning Benefits of Resource Flexibility," Management Science, INFORMS, vol. 67(10), pages 6513-6528, October.
    12. Mou, Shandong & Robb, David J. & DeHoratius, Nicole, 2018. "Retail store operations: Literature review and research directions," European Journal of Operational Research, Elsevier, vol. 265(2), pages 399-422.
    13. Li Chen & Adam J.Mersereau & Zhe (Frank) Wang, 2017. "Optimal Merchandise Testing with Limited Inventory," Operations Research, INFORMS, vol. 65(4), pages 968-991, August.
    14. Rong Li & Jing‐Sheng Jeannette Song & Shuxiao Sun & Xiaona Zheng, 2022. "Fight inventory shrinkage: Simultaneous learning of inventory level and shrinkage rate," Production and Operations Management, Production and Operations Management Society, vol. 31(6), pages 2477-2491, June.
    15. Alain Bensoussan & Pengfei Guo, 2015. "Technical Note—Managing Nonperishable Inventories with Learning About Demand Arrival Rate Through Stockout Times," Operations Research, INFORMS, vol. 63(3), pages 602-609, June.
    16. Boone, Tonya & Ganeshan, Ram & Jain, Aditya & Sanders, Nada R., 2019. "Forecasting sales in the supply chain: Consumer analytics in the big data era," International Journal of Forecasting, Elsevier, vol. 35(1), pages 170-180.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Boxiao Chen & Xiuli Chao, 2020. "Dynamic Inventory Control with Stockout Substitution and Demand Learning," Management Science, INFORMS, vol. 66(11), pages 5108-5127, November.
    2. Adam J. Mersereau, 2015. "Demand Estimation from Censored Observations with Inventory Record Inaccuracy," Manufacturing & Service Operations Management, INFORMS, vol. 17(3), pages 335-349, July.
    3. Alain Bensoussan & Pengfei Guo, 2015. "Technical Note—Managing Nonperishable Inventories with Learning About Demand Arrival Rate Through Stockout Times," Operations Research, INFORMS, vol. 63(3), pages 602-609, June.
    4. Gen Sakoda & Hideki Takayasu & Misako Takayasu, 2019. "Data Science Solutions for Retail Strategy to Reduce Waste Keeping High Profit," Sustainability, MDPI, vol. 11(13), pages 1-30, June.
    5. Gah-Yi Ban, 2020. "Confidence Intervals for Data-Driven Inventory Policies with Demand Censoring," Operations Research, INFORMS, vol. 68(2), pages 309-326, March.
    6. Woonghee Tim Huh & Paat Rusmevichientong, 2009. "A Nonparametric Asymptotic Analysis of Inventory Planning with Censored Demand," Mathematics of Operations Research, INFORMS, vol. 34(1), pages 103-123, February.
    7. Jiri Chod & Mihalis G. Markakis & Nikolaos Trichakis, 2021. "On the Learning Benefits of Resource Flexibility," Management Science, INFORMS, vol. 67(10), pages 6513-6528, October.
    8. Joonkyum Lee & Vishal Gaur & Suresh Muthulingam & Gary F. Swisher, 2016. "Stockout-Based Substitution and Inventory Planning in Textbook Retailing," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 104-121, February.
    9. Omar Besbes & Alp Muharremoglu, 2013. "On Implications of Demand Censoring in the Newsvendor Problem," Management Science, INFORMS, vol. 59(6), pages 1407-1424, June.
    10. Hao Yuan & Qi Luo & Cong Shi, 2021. "Marrying Stochastic Gradient Descent with Bandits: Learning Algorithms for Inventory Systems with Fixed Costs," Management Science, INFORMS, vol. 67(10), pages 6089-6115, October.
    11. Woonghee Tim Huh & Retsef Levi & Paat Rusmevichientong & James B. Orlin, 2011. "Adaptive Data-Driven Inventory Control with Censored Demand Based on Kaplan-Meier Estimator," Operations Research, INFORMS, vol. 59(4), pages 929-941, August.
    12. Li Chen & Adam J.Mersereau & Zhe (Frank) Wang, 2017. "Optimal Merchandise Testing with Limited Inventory," Operations Research, INFORMS, vol. 65(4), pages 968-991, August.
    13. Cong Shi & Weidong Chen & Izak Duenyas, 2016. "Technical Note—Nonparametric Data-Driven Algorithms for Multiproduct Inventory Systems with Censored Demand," Operations Research, INFORMS, vol. 64(2), pages 362-370, April.
    14. Boxiao Chen & Xiuli Chao & Cong Shi, 2021. "Nonparametric Learning Algorithms for Joint Pricing and Inventory Control with Lost Sales and Censored Demand," Mathematics of Operations Research, INFORMS, vol. 46(2), pages 726-756, May.
    15. Rong Li & Jing‐Sheng Jeannette Song & Shuxiao Sun & Xiaona Zheng, 2022. "Fight inventory shrinkage: Simultaneous learning of inventory level and shrinkage rate," Production and Operations Management, Production and Operations Management Society, vol. 31(6), pages 2477-2491, June.
    16. Wan, Mingchao & Huang, Yihui & Zhao, Lei & Deng, Tianhu & Fransoo, Jan C., 2018. "Demand estimation under multi-store multi-product substitution in high density traditional retail," European Journal of Operational Research, Elsevier, vol. 266(1), pages 99-111.
    17. Anyan Qi & Hyun-Soo Ahn & Amitabh Sinha, 2017. "Capacity Investment with Demand Learning," Operations Research, INFORMS, vol. 65(1), pages 145-164, February.
    18. Mila Nambiar & David Simchi‐Levi & He Wang, 2021. "Dynamic Inventory Allocation with Demand Learning for Seasonal Goods," Production and Operations Management, Production and Operations Management Society, vol. 30(3), pages 750-765, March.
    19. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    20. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:oropre:v:63:y:2015:i:1:p:134-150. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.