Working Papers

Quantitative Finance

F-series

Date:

Number:CARF-F-448

Application of Online Booking Data to Hotel Revenue Management (Forthcoming in International Journal of Information Management)

Author:Taiga Saito, Akihiko Takahashi, Noriaki Koide, Yu Ichifuji

Abstract

This paper presents an application of online booking data, comprised of big data crawled from a hotel booking website to hotel revenue management. It is important to build a quantitative revenue management method for online hotel booking systems incorporating overbooking strategies, because of increasing numbers of bookings through online booking websites and last-minute cancellations, which cause serious damage to hotel management. We construct a quantitative overbooking model for online booking systems combined with customers’ choice behaviors estimated from the data. Firstly, we present the overbooking model for online booking systems. Secondly, we estimate the choice behaviors of the customers from the online booking data by a discrete choice model. Thirdly, combining the estimated discrete choice model with the theoretical overbooking model, we investigate the expected sales maximization problem where we numerically solve the optimal overbooking level and room charge. Finally, we provide numerical examples of the optimal overbooking strategies and room charges using online booking data of two major luxury hotels in Shinjuku ward, Tokyo. This method, which utilizes online booking data available by crawling from booking websites, helps hotels obtain an optimal room charge and overbooking level maximizing the expected sales.