4.2 Most profitable room type
The revenue made on a room type is calculated as the sum of:
- The stay revenue:
room price * stay duration.
- The revenue generated from the ordered food and drinks.
- 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.
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/.