IDEAS home Printed from https://ideas.repec.org/a/pal/jorapm/v20y2021i3d10.1057_s41272-021-00312-3.html
   My bibliography  Save this article

Demand estimation from sales transaction data: practical extensions

Author

Listed:
  • Norbert Remenyi

    (Sabre)

  • Xiaodong Luo

    (Shenzhen Research Institute of Big Data)

Abstract

In this paper, we discuss practical limitations of the standard choice-based demand models used in the literature to estimate demand from sales transaction data. We present modifications and extensions of the models and discuss data preprocessing and solution techniques which are useful for practitioners dealing with sales transaction data. Among these, we present an algorithm to split sales transaction data observed under partial availability, we extend a popular Expectation Maximization (EM) algorithm for non-homogeneous product sets, and we develop two iterative optimization algorithms which can handle much of the extensions discussed in the paper.

Suggested Citation

  • Norbert Remenyi & Xiaodong Luo, 2021. "Demand estimation from sales transaction data: practical extensions," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 20(3), pages 276-300, June.
    • Handle: RePEc:pal:jorapm:v:20:y:2021:i:3:d:10.1057_s41272-021-00312-3
    DOI: 10.1057/s41272-021-00312-3
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1057/s41272-021-00312-3
    File Function: Abstract
    Download Restriction: Access to the full text of the articles in this series is restricted.
    File URL: https://libkey.io/10.1057/s41272-021-00312-3?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
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Hunter D.R. & Lange K., 2004. "A Tutorial on MM Algorithms," The American Statistician, American Statistical Association, vol. 58, pages 30-37, February.
    2. Guillermo Gallego & Richard Ratliff & Sergey Shebalov, 2015. "A General Attraction Model and Sales-Based Linear Program for Network Revenue Management Under Customer Choice," Operations Research, INFORMS, vol. 63(1), pages 212-232, February.
    3. 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.
    4. Train,Kenneth E., 2009. "Discrete Choice Methods with Simulation," Cambridge Books, Cambridge University Press, number 9780521766555.
    5. Marguerite Frank & Philip Wolfe, 1956. "An algorithm for quadratic programming," Naval Research Logistics Quarterly, John Wiley & Sons, vol. 3(1‐2), pages 95-110, March.
    6. 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.
    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. Resul Aydemir & Mehmet Melih Değirmenci & Abdullah Bilgin, 2023. "Estimation of passenger sell-up rates in airline revenue management by considering the effect of fare class availability," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 22(6), pages 501-513, December.

    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. C. I. Chiang, 2023. "Availability control under online reviews in hospitality," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 22(5), pages 385-398, October.
    2. Strauss, Arne K. & Klein, Robert & Steinhardt, Claudius, 2018. "A review of choice-based revenue management: Theory and methods," European Journal of Operational Research, Elsevier, vol. 271(2), pages 375-387.
    3. Guillermo Gallego & Haengju Lee, 2020. "Callable products with dependent demands," Naval Research Logistics (NRL), John Wiley & Sons, vol. 67(3), pages 185-200, April.
    4. Guang Li & Paat Rusmevichientong & Huseyin Topaloglu, 2015. "The d -Level Nested Logit Model: Assortment and Price Optimization Problems," Operations Research, INFORMS, vol. 63(2), pages 325-342, April.
    5. Kameng Nip & Zhenbo Wang & Zizhuo Wang, 2021. "Assortment Optimization under a Single Transition Choice Model," Production and Operations Management, Production and Operations Management Society, vol. 30(7), pages 2122-2142, July.
    6. Antoine Désir & Vineet Goyal & Danny Segev & Chun Ye, 2020. "Constrained Assortment Optimization Under the Markov Chain–based Choice Model," Management Science, INFORMS, vol. 66(2), pages 698-721, February.
    7. Mika Sumida & Guillermo Gallego & Paat Rusmevichientong & Huseyin Topaloglu & James Davis, 2021. "Revenue-Utility Tradeoff in Assortment Optimization Under the Multinomial Logit Model with Totally Unimodular Constraints," Management Science, INFORMS, vol. 67(5), pages 2845-2869, May.
    8. Nan Liu & Yuhang Ma & Huseyin Topaloglu, 2020. "Assortment Optimization Under the Multinomial Logit Model with Sequential Offerings," INFORMS Journal on Computing, INFORMS, vol. 32(3), pages 835-853, July.
    9. Fleckenstein, David & Klein, Robert & Steinhardt, Claudius, 2023. "Recent advances in integrating demand management and vehicle routing: A methodological review," European Journal of Operational Research, Elsevier, vol. 306(2), pages 499-518.
    10. Ali Aouad & Jacob Feldman & Danny Segev, 2023. "The Exponomial Choice Model for Assortment Optimization: An Alternative to the MNL Model?," Management Science, INFORMS, vol. 69(5), pages 2814-2832, May.
    11. Shivaram Subramanian & Pavithra Harsha, 2021. "Demand Modeling in the Presence of Unobserved Lost Sales," Management Science, INFORMS, vol. 67(6), pages 3803-3833, June.
    12. Hongzhang Shao & Anton J. Kleywegt, 2020. "Joint Estimation of Discrete Choice Model and Arrival Rate with Unobserved Stock-out Events," Papers 2003.02313, arXiv.org.
    13. 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.
    14. 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.
    15. Jacob B. Feldman & Huseyin Topaloglu, 2017. "Revenue Management Under the Markov Chain Choice Model," Operations Research, INFORMS, vol. 65(5), pages 1322-1342, October.
    16. Xi Chen & Zachary Owen & Clark Pixton & David Simchi-Levi, 2022. "A Statistical Learning Approach to Personalization in Revenue Management," Management Science, INFORMS, vol. 68(3), pages 1923-1937, March.
    17. Georg Bechler & Claudius Steinhardt & Jochen Mackert, 2021. "On the Linear Integration of Attraction Choice Models in Business Optimization Problems," SN Operations Research Forum, Springer, vol. 2(1), pages 1-13, March.
    18. Gupta, Vishal Kumar & Ting, Q.U. & Tiwari, Manoj Kumar, 2019. "Multi-period price optimization problem for omnichannel retailers accounting for customer heterogeneity," International Journal of Production Economics, Elsevier, vol. 212(C), pages 155-167.
    19. Philipp Ströhle & Christoph M. Flath & Johannes Gärttner, 2019. "Leveraging Customer Flexibility for Car-Sharing Fleet Optimization," Service Science, INFORMS, vol. 53(1), pages 42-61, February.
    20. Aydın Alptekinoğlu & John H. Semple, 2016. "The Exponomial Choice Model: A New Alternative for Assortment and Price Optimization," Operations Research, INFORMS, vol. 64(1), pages 79-93, February.

    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:pal:jorapm:v:20:y:2021:i:3:d:10.1057_s41272-021-00312-3. 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: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.palgrave.com .

    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.