5.2 Room prices

Course subject(s) Module 5: Price influences

We are wondering how the price of rooms affect the number of guests in our hotel. We know the following:

  1. The profit for one room is 25% of the room selling price.
  2. 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.

You can check some relevant content from the previous course here and here.

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