5.2 Room prices
We are wondering how the price of rooms affect the number of guests in our hotel. We know the following:
- The profit for one room is 25% of the room selling price.
- The number of room bookings is modeled as:
-[room selling price]+200
Note that the model used for the number of bookings is hypothetical, an probably not realistic.
Find out what the maximum possible profit (round to closest integer) is. ProTip: Use the Solver.
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/.