IDEAS home Printed from https://ideas.repec.org/a/eee/intfor/v27yi3p942-960.html
   My bibliography  Save this article

Booking horizon forecasting with dynamic updating: A case study of hotel reservation data

Author

Listed:
  • Haensel, Alwin
  • Koole, Ger

Abstract

A highly accurate demand forecast is fundamental to the success of every revenue management model. As is often required in both practice and theory, we aim to forecast the accumulated booking curve, as well as the number of reservations expected for each day in the booking horizon. To reduce the dimensionality of this problem, we apply singular value decomposition to the historical booking profiles. The forecast of the remaining part of the booking horizon is dynamically adjusted to the earlier observations using the penalized least squares and historical proportion methods. Our proposed updating procedure considers the correlation and dynamics of bookings both within the booking horizon and between successive product instances. The approach is tested on real hotel reservation data and shows a significant improvement in forecast accuracy.

Suggested Citation

  • Haensel, Alwin & Koole, Ger, 2011. "Booking horizon forecasting with dynamic updating: A case study of hotel reservation data," International Journal of Forecasting, Elsevier, vol. 27(3), pages 942-960, July.
    • Handle: RePEc:eee:intfor:v:27:y::i:3:p:942-960
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0169207011000100
    Download Restriction: Full text for ScienceDirect subscribers only
    ---><---

    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. Peter R. Winters, 1960. "Forecasting Sales by Exponentially Weighted Moving Averages," Management Science, INFORMS, vol. 6(3), pages 324-342, April.
    2. Weatherford, Larry R. & Kimes, Sheryl E., 2003. "A comparison of forecasting methods for hotel revenue management," International Journal of Forecasting, Elsevier, vol. 19(3), pages 401-415.
    3. Weinberg, Jonathan & Brown, Lawrence D. & Stroud, Jonathan R., 2007. "Bayesian Forecasting of an Inhomogeneous Poisson Process With Applications to Call Center Data," Journal of the American Statistical Association, American Statistical Association, vol. 102, pages 1185-1198, December.
    4. Bénédicte Vidaillet & V. d'Estaintot & P. Abécassis, 2005. "Introduction," Post-Print hal-00287137, HAL.
    5. Wen-Chyuan Chiang & Jason C.H. Chen & Xiaojing Xu, 2007. "An overview of research on revenue management: current issues and future research," International Journal of Revenue Management, Inderscience Enterprises Ltd, vol. 1(1), pages 97-128.
    6. Haipeng Shen & Jianhua Z. Huang, 2008. "Interday Forecasting and Intraday Updating of Call Center Arrivals," Manufacturing & Service Operations Management, INFORMS, vol. 10(3), pages 391-410, July.
    7. O'Connor, Marcus & Remus, William & Griggs, Kenneth, 2000. "Does updating judgmental forecasts improve forecast accuracy?," International Journal of Forecasting, Elsevier, vol. 16(1), pages 101-109.
    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. Michael Murimi & Billy Wadongo & Tom Olielo, 2021. "Determinants of revenue management practices and their impacts on the financial performance of hotels in Kenya: a proposed theoretical framework," Future Business Journal, Springer, vol. 7(1), pages 1-7, December.
    2. Tianxiang Zheng & Shaopeng Liu & Zini Chen & Yuhan Qiao & Rob Law, 2020. "Forecasting Daily Room Rates on the Basis of an LSTM Model in Difficult Times of Hong Kong: Evidence from Online Distribution Channels on the Hotel Industry," Sustainability, MDPI, vol. 12(18), pages 1-17, September.
    3. Apostolos Ampountolas & Mark Legg, 2024. "Predicting daily hotel occupancy: a practical application for independent hotels," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 23(3), pages 197-205, June.
    4. Đukec, Damira & Čanadi, Vesna, 2019. "Yield Management in the Hotel Industry of Croatia," Proceedings of the ENTRENOVA - ENTerprise REsearch InNOVAtion Conference (2019), Rovinj, Croatia, in: Proceedings of the ENTRENOVA - ENTerprise REsearch InNOVAtion Conference, Rovinj, Croatia, 12-14 September 2019, pages 309-316, IRENET - Society for Advancing Innovation and Research in Economy, Zagreb.
    5. 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.
    6. Noelia Oses & Jon Kepa Gerrikagoitia & Aurkene Alzua, 2016. "Modelling and prediction of a destination’s monthly average daily rate and occupancy rate based on hotel room prices offered online," Tourism Economics, , vol. 22(6), pages 1380-1403, December.
    7. Apostolos Ampountolas, 2019. "Forecasting hotel demand uncertainty using time series Bayesian VAR models," Tourism Economics, , vol. 25(5), pages 734-756, August.
    8. Naragain Phumchusri & Phoom Ungtrakul, 2020. "Hotel daily demand forecasting for high-frequency and complex seasonality data: a case study in Thailand," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 19(1), pages 8-25, February.
    9. Larissa Koupriouchina & Jean-Pierre van der Rest & Zvi Schwartz, 2023. "Judgmental Adjustments of Algorithmic Hotel Occupancy Forecasts: Does User Override Frequency Impact Accuracy at Different Time Horizons?," Tourism Economics, , vol. 29(8), pages 2143-2164, December.
    10. Timothy Webb, 2022. "Forecasting at capacity: the bias of unconstrained forecasts in model evaluation," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 21(6), pages 645-656, December.
    11. Zvi Schwartz & Timothy Webb & Jean-Pierre I van der Rest & Larissa Koupriouchina, 2021. "Enhancing the accuracy of revenue management system forecasts: The impact of machine and human learning on the effectiveness of hotel occupancy forecast combinations across multiple forecasting horizo," Tourism Economics, , vol. 27(2), pages 273-291, March.
    12. Apostolos Ampountolas, 2021. "Modeling and Forecasting Daily Hotel Demand: A Comparison Based on SARIMAX, Neural Networks, and GARCH Models," Forecasting, MDPI, vol. 3(3), pages 1-16, August.
    13. E. Martinez-De-Pison & J. Fernandez-Ceniceros & A. V. Pernia-Espinoza & F. J. Martinez-De-Pison & Andres Sanz-Garcia, 2016. "Hotel Reservation Forecasting Using Flexible Soft Computing Techniques: A Case of Study in a Spanish Hotel," International Journal of Information Technology & Decision Making (IJITDM), World Scientific Publishing Co. Pte. Ltd., vol. 15(05), pages 1211-1234, September.
    14. Ulrich Gunter, 2021. "Improving Hotel Room Demand Forecasts for Vienna across Hotel Classes and Forecast Horizons: Single Models and Combination Techniques Based on Encompassing Tests," Forecasting, MDPI, vol. 3(4), pages 1-36, November.

    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. Smirnov, Dmitry & Huchzermeier, Arnd, 2020. "Analytics for labor planning in systems with load-dependent service times," European Journal of Operational Research, Elsevier, vol. 287(2), pages 668-681.
    2. E. Martinez-De-Pison & J. Fernandez-Ceniceros & A. V. Pernia-Espinoza & F. J. Martinez-De-Pison & Andres Sanz-Garcia, 2016. "Hotel Reservation Forecasting Using Flexible Soft Computing Techniques: A Case of Study in a Spanish Hotel," International Journal of Information Technology & Decision Making (IJITDM), World Scientific Publishing Co. Pte. Ltd., vol. 15(05), pages 1211-1234, September.
    3. Petropoulos, Fotios & Apiletti, Daniele & Assimakopoulos, Vassilios & Babai, Mohamed Zied & Barrow, Devon K. & Ben Taieb, Souhaib & Bergmeir, Christoph & Bessa, Ricardo J. & Bijak, Jakub & Boylan, Joh, 2022. "Forecasting: theory and practice," International Journal of Forecasting, Elsevier, vol. 38(3), pages 705-871.
      • Fotios Petropoulos & Daniele Apiletti & Vassilios Assimakopoulos & Mohamed Zied Babai & Devon K. Barrow & Souhaib Ben Taieb & Christoph Bergmeir & Ricardo J. Bessa & Jakub Bijak & John E. Boylan & Jet, 2020. "Forecasting: theory and practice," Papers 2012.03854, arXiv.org, revised Jan 2022.
    4. Albrecht, Tobias & Rausch, Theresa Maria & Derra, Nicholas Daniel, 2021. "Call me maybe: Methods and practical implementation of artificial intelligence in call center arrivals’ forecasting," Journal of Business Research, Elsevier, vol. 123(C), pages 267-278.
    5. Barrow, Devon K., 2016. "Forecasting intraday call arrivals using the seasonal moving average method," Journal of Business Research, Elsevier, vol. 69(12), pages 6088-6096.
    6. Kinshuk Jerath & Anuj Kumar & Serguei Netessine, 2015. "An Information Stock Model of Customer Behavior in Multichannel Customer Support Services," Manufacturing & Service Operations Management, INFORMS, vol. 17(3), pages 368-383, July.
    7. Zhengyi Zhou & David S. Matteson & Dawn B. Woodard & Shane G. Henderson & Athanasios C. Micheas, 2015. "A Spatio-Temporal Point Process Model for Ambulance Demand," Journal of the American Statistical Association, Taylor & Francis Journals, vol. 110(509), pages 6-15, March.
    8. Theresa Maria Rausch & Tobias Albrecht & Daniel Baier, 2022. "Beyond the beaten paths of forecasting call center arrivals: on the use of dynamic harmonic regression with predictor variables," Journal of Business Economics, Springer, vol. 92(4), pages 675-706, May.
    9. Ding, S. & Koole, G. & van der Mei, R.D., 2015. "On the estimation of the true demand in call centers with redials and reconnects," European Journal of Operational Research, Elsevier, vol. 246(1), pages 250-262.
    10. Naragain Phumchusri & Phoom Ungtrakul, 2020. "Hotel daily demand forecasting for high-frequency and complex seasonality data: a case study in Thailand," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 19(1), pages 8-25, February.
    11. Webel, Karsten, 2022. "A review of some recent developments in the modelling and seasonal adjustment of infra-monthly time series," Discussion Papers 31/2022, Deutsche Bundesbank.
    12. Aktekin, Tevfik, 2014. "Call center service process analysis: Bayesian parametric and semi-parametric mixture modeling," European Journal of Operational Research, Elsevier, vol. 234(3), pages 709-719.
    13. Kim, Myung Suk, 2013. "Modeling special-day effects for forecasting intraday electricity demand," European Journal of Operational Research, Elsevier, vol. 230(1), pages 170-180.
    14. Tevfik Aktekin & Tahir Ekin, 2016. "Stochastic call center staffing with uncertain arrival, service and abandonment rates: A Bayesian perspective," Naval Research Logistics (NRL), John Wiley & Sons, vol. 63(6), pages 460-478, September.
    15. Itai Gurvich & James Luedtke & Tolga Tezcan, 2010. "Staffing Call Centers with Uncertain Demand Forecasts: A Chance-Constrained Optimization Approach," Management Science, INFORMS, vol. 56(7), pages 1093-1115, July.
    16. Valerio Lacagnina & Davide Provenzano, 2016. "An integrated fuzzy-stochastic model for revenue management," Tourism Economics, , vol. 22(4), pages 779-792, August.
    17. Tevfik Aktekin & Refik Soyer, 2011. "Call center arrival modeling: A Bayesian state‐space approach," Naval Research Logistics (NRL), John Wiley & Sons, vol. 58(1), pages 28-42, February.
    18. Paris A. Mastorocostas & Constantinos S. Hilas & Dimitris N. Varsamis & Stergiani C. Dova, 2016. "Telecommunications call volume forecasting with a block-diagonal recurrent fuzzy neural network," Telecommunication Systems: Modelling, Analysis, Design and Management, Springer, vol. 63(1), pages 15-25, September.
    19. Andrea Bastianin & Marzio Galeotti & Matteo Manera, 2019. "Statistical and economic evaluation of time series models for forecasting arrivals at call centers," Empirical Economics, Springer, vol. 57(3), pages 923-955, September.
    20. Rice, William L. & Park, So Young & Pan, Bing & Newman, Peter, 2019. "Forecasting campground demand in US national parks," Annals of Tourism Research, Elsevier, vol. 75(C), pages 424-438.

    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:eee:intfor:v:27:y::i:3:p:942-960. 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: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/ijforecast .

    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.