6.2 Most profitable room types
In module 4 we calculated the total profit of each room type. Now we would like to know whether the most profitable room type remains the same over the entire first semester (Q1 & Q2).
Just like we did in module 4, we calculate the profit of a room type by summing:
- 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.
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/.