Assignment 4

Revenue Management at a Hotel

hotel bedroom

A hotel with 100 rooms considers entering into the booking market. There are two demands:

  • Early demand: Before one week to the date U(80, 120) ​
  • Late demand: During one week to the date U(10, 50)​

Early customers first book and pay $10 which is non-refundable. They can cancel the booking anytime before one week to the date. In the case of finalizing, they pay another $50. Late customers pay $80 which is non-refundable.

The hotel currently plans for booking policy. Past data shows that at least 80% of early customers finalize the booking. If overbooking is realized, the hotel pays a penalty of $150 to each booked customer.​

Use the dataset, Assignment Hotel.xlsx, to analyze how the hotel can maximize profit.

Maximize Profit (X) = Booking fee + Early demand profit + Late demand profit – Overbooked cost 



Icon for the Creative Commons Attribution 4.0 International License

Data Analytics and Decision Making Copyright © 2022 by Ali AbdulHussein is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book