IDEAS home Printed from
   My bibliography  Save this article

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


  • Haensel, Alwin
  • Koole, Ger


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.
  • Handle: RePEc:eee:intfor:v:27:y:2011:i:3:p:942-960 DOI: 10.1016/j.ijforecast.2010.10.004

    Download full text from publisher

    File URL:
    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

    1. Hyndman, Rob J. & Khandakar, Yeasmin, 2008. "Automatic Time Series Forecasting: The forecast Package for R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 27(i03).
    2. Commandeur, Jacques J.F. & Koopman, Siem Jan, 2007. "An Introduction to State Space Time Series Analysis," OUP Catalogue, Oxford University Press, number 9780199228874, June.
    3. Imad A. Moosa, 2000. "The cyclical behaviour of prices in the U.K.: Some structural time series evidence," Empirical Economics, Springer, vol. 25(2), pages 261-278.
    4. Durbin, James & Koopman, Siem Jan, 2012. "Time Series Analysis by State Space Methods," OUP Catalogue, Oxford University Press, edition 2, number 9780199641178.
    5. Athanasopoulos, George & Hyndman, Rob J. & Song, Haiyan & Wu, Doris C., 2011. "The tourism forecasting competition," International Journal of Forecasting, Elsevier, vol. 27(3), pages 822-844, July.
    6. Witt, Stephen F. & Witt, Christine A., 1995. "Forecasting tourism demand: A review of empirical research," International Journal of Forecasting, Elsevier, vol. 11(3), pages 447-475, September.
    7. Siem Jan Koopman & Neil Shephard & Jurgen A. Doornik, 1999. "Statistical algorithms for models in state space using SsfPack 2.2," Econometrics Journal, Royal Economic Society, vol. 2(1), pages 107-160.
    8. Gonzalez, Pilar & Moral, Paz, 1995. "An analysis of the international tourism demand in Spain," International Journal of Forecasting, Elsevier, vol. 11(2), pages 233-251, June.
    9. Song, Haiyan & Witt, Stephen F. & Jensen, Thomas C., 2003. "Tourism forecasting: accuracy of alternative econometric models," International Journal of Forecasting, Elsevier, vol. 19(1), pages 123-141.
    10. Harvey, David & Leybourne, Stephen & Newbold, Paul, 1997. "Testing the equality of prediction mean squared errors," International Journal of Forecasting, Elsevier, vol. 13(2), pages 281-291, June.
    11. Lucas, Robert Jr, 1976. "Econometric policy evaluation: A critique," Carnegie-Rochester Conference Series on Public Policy, Elsevier, vol. 1(1), pages 19-46, January.
    Full references (including those not matched with items on IDEAS)


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

    Cited by:

    1. 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.


    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:2011:i:3:p:942-960. See general information about how to correct material in RePEc.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Dana Niculescu). General contact details of provider: .

    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.

    We have no references for this item. You can help adding them by using 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.

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

    IDEAS is a RePEc service hosted by the Research Division of the Federal Reserve Bank of St. Louis . RePEc uses bibliographic data supplied by the respective publishers.