4.2 Most profitable room type

Course subject(s) Module 4: Data Trends

The revenue made on a room type is calculated as the sum of:

  1. The stay revenue: room price * stay duration.
  2. The revenue generated from the ordered food and drinks.
  3. The revenue from the services that are used.

The profit is calculated by taking 25% of the revenue.

Based on these rules, determine which room type is most profitable for the hotel.

Creative Commons License
Data Analysis: Building your own Business Dashboard by TU Delft OpenCourseWare is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at https://ocw.tudelft.nl/courses/data-analysis-bu…siness-dashboard/.
Back to top