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

Estimating Primary Demand for Substitutable Products from Sales Transaction Data

Author

Listed:
  • Gustavo Vulcano

    (Leonard N. Stern School of Business, New York University, New York, New York 10012)

  • Garrett van Ryzin

    (Graduate School of Business, Columbia University, New York, New York 10027)

  • Richard Ratliff

    (Sabre Holdings, Southlake, Texas 76092)

Abstract

We propose a method for estimating substitute and lost demand when only sales and product availability data are observable, not all products are displayed in all periods (e.g., due to stockouts or availability controls), and the seller knows its aggregate market share. The model combines a multinomial logit (MNL) choice model with a nonhomogeneous Poisson model of arrivals over multiple periods. Our key idea is to view the problem in terms of primary (or first-choice) demand; that is, the demand that would have been observed if all products had been available in all periods. We then apply the expectation-maximization (EM) method to this model, and we treat the observed demand as an incomplete observation of primary demand. This leads to an efficient, iterative procedure for estimating the parameters of the model. All limit points of the procedure are provably stationary points of the incomplete data log-likelihood function. Every iteration of the algorithm consists of simple, closed-form calculations. We illustrate the effectiveness of the procedure on simulated data and two industry data sets.

Suggested Citation

  • 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.
  • Handle: RePEc:inm:oropre:v:60:y:2012:i:2:p:313-334
    DOI: 10.1287/opre.1110.1012
    as

    Download full text from publisher

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

    File URL: https://libkey.io/10.1287/opre.1110.1012?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. 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.
    2. Fitzsimons, Gavan J, 2000. "Consumer Response to Stockouts," Journal of Consumer Research, Journal of Consumer Research Inc., vol. 27(2), pages 249-266, September.
    3. Hernán A. Bruno & Naufel J. Vilcassim, 2008. "—Structural Demand Estimation with Varying Product Availability," Marketing Science, INFORMS, vol. 27(6), pages 1126-1131, 11-12.
    4. Nevo, Aviv, 2001. "Measuring Market Power in the Ready-to-Eat Cereal Industry," Econometrica, Econometric Society, vol. 69(2), pages 307-342, March.
    5. 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.
    6. Sharad Borle & Peter Boatwright & Joseph B. Kadane & Joseph C. Nunes & Shmueli Galit, 2005. "The Effect of Product Assortment Changes on Customer Retention," Marketing Science, INFORMS, vol. 24(4), pages 616-622, July.
    7. 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.
    8. Peter M. Guadagni & John D. C. Little, 1983. "A Logit Model of Brand Choice Calibrated on Scanner Data," Marketing Science, INFORMS, vol. 2(3), pages 203-238.
    9. Garrett van Ryzin & Siddharth Mahajan, 1999. "On the Relationship Between Inventory Costs and Variety Benefits in Retail Assortments," Management Science, INFORMS, vol. 45(11), pages 1496-1509, November.
    10. Nicole DeHoratius & Ananth Raman, 2008. "Inventory Record Inaccuracy: An Empirical Analysis," Management Science, INFORMS, vol. 54(4), pages 627-641, April.
    11. 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.
    12. Berry, Steven & Levinsohn, James & Pakes, Ariel, 1995. "Automobile Prices in Market Equilibrium," Econometrica, Econometric Society, vol. 63(4), pages 841-890, July.
    13. Serguei Netessine & Nils Rudi, 2003. "Centralized and Competitive Inventory Models with Demand Substitution," Operations Research, INFORMS, vol. 51(2), pages 329-335, April.
    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. Pradeep K. Chintagunta, 1993. "Investigating Purchase Incidence, Brand Choice and Purchase Quantity Decisions of Households," Marketing Science, INFORMS, vol. 12(2), pages 184-208.
    Full references (including those not matched with items on IDEAS)

    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. 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.
    2. 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.
    3. 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.
    4. Amr Farahat & Joonkyum Lee, 2018. "The Multiproduct Newsvendor Problem with Customer Choice," Operations Research, INFORMS, vol. 66(1), pages 123-136, January.
    5. 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.
    6. Garrett van Ryzin & Gustavo Vulcano, 2015. "A Market Discovery Algorithm to Estimate a General Class of Nonparametric Choice Models," Management Science, INFORMS, vol. 61(2), pages 281-300, February.
    7. Boxiao Chen & Xiuli Chao, 2020. "Dynamic Inventory Control with Stockout Substitution and Demand Learning," Management Science, INFORMS, vol. 66(11), pages 5108-5127, November.
    8. Vishal Gaur & Young-Hoon Park, 2007. "Asymmetric Consumer Learning and Inventory Competition," Management Science, INFORMS, vol. 53(2), pages 227-240, February.
    9. 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.
    10. Patxi J. Bernales & Yongtao Guan & Harihara Prasad Natarajan & Patricia Souza Gimenez & Mario Xavier Alvarez Tajes, 2017. "Less Is More: Harnessing Product Substitution Information to Rationalize SKUs at Intcomex," Interfaces, INFORMS, vol. 47(3), pages 230-243, June.
    11. Pol Boada-Collado & Victor Martínez-de-Albéniz, 2020. "Estimating and Optimizing the Impact of Inventory on Consumer Choices in a Fashion Retail Setting," Manufacturing & Service Operations Management, INFORMS, vol. 22(3), pages 582-597, May.
    12. Vidya Mani & Douglas J. Thomas & Saurabh Bansal, 2022. "Estimating Substitution and Basket Effects in Retail Stores: Implications for Assortment Planning," Management Science, INFORMS, vol. 68(7), pages 5002-5024, July.
    13. 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.
    14. Srikanth Jagabathula & Gustavo Vulcano, 2018. "A Partial-Order-Based Model to Estimate Individual Preferences Using Panel Data," Management Science, INFORMS, vol. 64(4), pages 1609-1628, April.
    15. Mehrani, Saharnaz & Sefair, Jorge A., 2022. "Robust assortment optimization under sequential product unavailability," European Journal of Operational Research, Elsevier, vol. 303(3), pages 1027-1043.
    16. Victor Martínez-de-Albéniz & Sumit Kunnumkal, 2022. "A Model for Integrated Inventory and Assortment Planning," Management Science, INFORMS, vol. 68(7), pages 5049-5067, July.
    17. Wallace J. Hopp & Xiaowei Xu, 2008. "A Static Approximation for Dynamic Demand Substitution with Applications in a Competitive Market," Operations Research, INFORMS, vol. 56(3), pages 630-645, June.
    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. Hickman, William & Mortimer, Julie Holland, 2016. "Demand Estimation with Availability Variation," SocArXiv qe69j, Center for Open Science.
    20. Lingxiu Dong & Panos Kouvelis & Zhongjun Tian, 2009. "Dynamic Pricing and Inventory Control of Substitute Products," Manufacturing & Service Operations Management, INFORMS, vol. 11(2), pages 317-339, December.

    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:60:y:2012:i:2:p:313-334. 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.