In the attachment you can find all relevant files and exercises for this section :)

Project 2: Formula fun

To benchmark the performance of choice-based revenue management (RM) algorithms, a major hotel
chain has collected data from one of its U.S. properties.The data contains all transactional information
associated with its bookings and product availability information. lt sells via three distribution channels:
central reservation offices and hotels (CROs/Hotels), the hotel chain’s proprietary website, and global
distribution systems (GDSs). The central reservation system (CRS) is used directly by hotel reservation
staff and reservation personnel employed in the hotel’s CROs. The proprietary website refers to bookings
made directly by guests via the hotel’s websites. Finally, on-line and off-line travel agencies use GDSs to
sell hotel products. Consumed” bookings resulting in the customer staying at the hotel are included in
the dataset, i.e., bookings resulting in cancellations or no-shows are excluded.
You got assigned to answer some questions regarding the data (see assignment data) and already set up
a worksheet (see assignment worksheet). To finish it, you still need to put in the correct formulas that
help you answer the questions below:

What share of bookings is made through each distribution channel?
Does the distribution channel seem to have an influence on the nightly price?
How many days do people book in advance on average? And what is the average stay? Please
round your answer to two decimals
What share of bookings falls within the following buckets: < 250 euro , > = 250 < 500 , >=500
What is the total revenue attributed to suite 1 and 2 combined? Please double check using two
different functions
How many people with membership status booked a room and how many without membership
status?
Do people with membership status pay lower prices on average? How big is the difference?
How high is the highest and lowest nightly rate?
Is there a correlation between the booking window and the nightly rate?

Patrik Doležel

--

5