IDEAS home Printed from https://ideas.repec.org/a/pal/jorapm/v22y2023i6d10.1057_s41272-023-00424-y.html
   My bibliography  Save this article

Estimation of passenger sell-up rates in airline revenue management by considering the effect of fare class availability

Author

Listed:
  • Resul Aydemir

    (Istanbul Technical University, İTÜ Maçka Campus)

  • Mehmet Melih Değirmenci

    (Istanbul Technical University, İTÜ Maçka Campus)

  • Abdullah Bilgin

    (Istanbul Technical University, İTÜ Ayazağa Campus)

Abstract

This paper introduces a new method for estimating sell-up rates that show a passenger’s propensity to purchase the upper fare class using class-based historical booking data. The performance of models in the literature, such as Direct Observation (DO) and Inverse Cumulative (IC), is not satisfactory when applied to the actual historical booking data since their results do not match the business expectations. We improve these models and design data pre-processing and solution techniques that can be beneficial for practitioners in dealing with historical booking data. Adjusting the past bookings with fare class availability data, our model provides a robust sell-up rate estimation. We examine data of a major European airline in our analysis. Numerical results show that our proposed method decreases MAPE (mean absolute percentage error) significantly.

Suggested Citation

  • 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.
    • Handle: RePEc:pal:jorapm:v:22:y:2023:i:6:d:10.1057_s41272-023-00424-y
    DOI: 10.1057/s41272-023-00424-y
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1057/s41272-023-00424-y
    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-023-00424-y?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. 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. Kevin Pak & Nanda Piersma, 2002. "overview of OR techniques for airline revenue management," Statistica Neerlandica, Netherlands Society for Statistics and Operations Research, vol. 56(4), pages 479-495, November.
    3. Octavian Oancea, 2021. "The implications of behavioural economics for pricing in a world of offer optimisation," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 20(6), pages 626-633, December.
    4. Bertalan Juhasz, 2021. "Optimal prices for multiple products in classless revenue management," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 20(5), pages 588-595, October.
    5. 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.
    6. Larry Weatherford, 2016. "The history of forecasting models in revenue management," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 15(3), pages 212-221, July.
    7. 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.
    8. Michael D. Wittman & Peter P. Belobaba, 2019. "Dynamic pricing mechanisms for the airline industry: a definitional framework," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 18(2), pages 100-106, April.
    9. Ian Yeoman, 2021. "Pricing and revenue management relationships," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 20(5), pages 529-529, October.
    10. 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.
    11. Andreea Popescu & Earl Barnes & Ellis Johnson & Pinar Keskinocak, 2013. "Bid Prices When Demand Is a Mix of Individual and Batch Bookings," Transportation Science, INFORMS, vol. 47(2), pages 198-213, May.
    12. Sébastien Touraine, 2021. "The industry transformation to dynamic offering," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 20(6), pages 611-614, December.
    13. Swan, William M., 2002. "Airline demand distributions: passenger revenue management and spill," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 38(3-4), pages 253-263, May.
    14. Jost Daft & Sascha Albers & Sebastian Stabenow, 2021. "From product-oriented flight providers to customer-centric retailers: a dynamic offering framework and implementation guidelines for airlines," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 20(6), pages 615-625, December.
    15. Bazyli Szymański & Peter P. Belobaba & Alexander Papen, 2021. "Continuous pricing algorithms for airline RM: revenue gains and competitive impacts," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 20(6), pages 669-688, December.
    16. 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.
    17. Z.F. Li, Michael & Hoon Oum, Tae, 2000. "Airline spill analysis - beyond the normal demand," European Journal of Operational Research, Elsevier, vol. 125(1), pages 205-215, August.
    18. Thomas Fiig & Larry R. Weatherford & Michael D. Wittman, 2019. "Can demand forecast accuracy be linked to airline revenue?," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 18(4), pages 291-305, August.
    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. Ian Yeoman, 2023. "Diversification of revenue management and pricing," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 22(6), pages 429-430, 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. Stacey Mumbower & Susan Hotle & Laurie A. Garrow, 2023. "Highly debated but still unbundled: The evolution of U.S. airline ancillary products and pricing strategies," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 22(4), pages 276-293, August.
    2. Fukushi, Mitsuyoshi & Delgado, Felipe & Raveau, Sebastián & Santos, Bruno F., 2022. "CHAIRS: A choice-based air transport simulator applied to airline competition and revenue management," Transportation Research Part A: Policy and Practice, Elsevier, vol. 155(C), pages 297-315.
    3. 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.
    4. Yanbin Long & Peter Belobaba, 2024. "Airline revenue management with segmented continuous pricing: methods and competitive effects," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 23(1), pages 14-27, February.
    5. Barbier, Thibault & Anjos, Miguel F. & Cirinei, Fabien & Savard, Gilles, 2020. "Product-closing approximation for ranking-based choice network revenue management," European Journal of Operational Research, Elsevier, vol. 286(3), pages 1002-1017.
    6. Sanjay Dominik Jena & Andrea Lodi & Claudio Sole, 2021. "On the estimation of discrete choice models to capture irrational customer behaviors," Papers 2109.03882, arXiv.org.
    7. Kevin K. Wang & Michael D. Wittman & Thomas Fiig, 2023. "Dynamic offer creation for airline ancillaries using a Markov chain choice model," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 22(2), pages 103-121, April.
    8. Hans Corsten & Michael Hopf & Benedikt Kasper & Clemens Thielen, 2018. "Assortment planning for multiple chain stores," OR Spectrum: Quantitative Approaches in Management, Springer;Gesellschaft für Operations Research e.V., vol. 40(4), pages 875-912, October.
    9. Kavitha Balaiyan & R. K. Amit & Atul Kumar Malik & Xiaodong Luo & Amit Agarwal, 2019. "Joint forecasting for airline pricing and revenue management," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 18(6), pages 465-482, December.
    10. Shivaram Subramanian & Pavithra Harsha, 2021. "Demand Modeling in the Presence of Unobserved Lost Sales," Management Science, INFORMS, vol. 67(6), pages 3803-3833, June.
    11. 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.
    12. Gah-Yi Ban, 2020. "Confidence Intervals for Data-Driven Inventory Policies with Demand Censoring," Operations Research, INFORMS, vol. 68(2), pages 309-326, March.
    13. 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.
    14. Ruxian Wang & Ozge Sahin, 2018. "The Impact of Consumer Search Cost on Assortment Planning and Pricing," Management Science, INFORMS, vol. 64(8), pages 3649-3666, August.
    15. Philipp Bartke & Natalia Kliewer & Catherine Cleophas, 2018. "Benchmarking filter-based demand estimates for airline revenue management," EURO Journal on Transportation and Logistics, Springer;EURO - The Association of European Operational Research Societies, vol. 7(1), pages 57-88, March.
    16. Jeffrey P. Newman & Mark E. Ferguson & Laurie A. Garrow & Timothy L. Jacobs, 2014. "Estimation of Choice-Based Models Using Sales Data from a Single Firm," Manufacturing & Service Operations Management, INFORMS, vol. 16(2), pages 184-197, May.
    17. Catherine Cleophas & Daniel Kadatz & Sebastian Vock, 2017. "Resilient revenue management: a literature survey of recent theoretical advances," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 16(5), pages 483-498, October.
    18. Meng Qi & Ho‐Yin Mak & Zuo‐Jun Max Shen, 2020. "Data‐driven research in retail operations—A review," Naval Research Logistics (NRL), John Wiley & Sons, vol. 67(8), pages 595-616, December.
    19. Boxiao Chen & Xiuli Chao, 2020. "Dynamic Inventory Control with Stockout Substitution and Demand Learning," Management Science, INFORMS, vol. 66(11), pages 5108-5127, November.
    20. Muzaffer Buyruk & Ertan Güner, 2022. "Personalization in airline revenue management: an overview and future outlook," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 21(2), pages 129-139, April.

    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:22:y:2023:i:6:d:10.1057_s41272-023-00424-y. 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.