Question
A hotel needs to determine the best rates and room sizes to maximize revenues. Currently the hotel has the following rooms, rates, price elasticity, and
A hotel needs to determine the best rates and room sizes to maximize revenues. Currently the hotel has the following rooms, rates, price elasticity, and historical average number of rooms sold:
Room type | Current Rate | Historical Average Daily Sold | Elasticity | Total Room Capacity |
Standard | $85.00 | 250 | -1.5 | 450 |
Gold | $98.00 | 100 | -2 | |
Platinum | $139.00 | 50 | -1 | |
Suite | $180.00 | 20 | -2.5 |
The price elasticity means for example for every 1% increase in standard room rate, there is a 1.5% decrease in sales of these rooms and by 1% decrease in rate, number of rooms sold will increase by 1.5%.
The following formula calculates the projected number of rooms of a given type sold:
H+( E )( H )( NP - CP )/CP
Where:
H: Historical average daily sold
E: Elasticity
NP: New Price
CP: Current price
Owners want to keep the price of standard room (S) between $70 and 90$, gold room (G) between $90 and $110, platinum room (P) between $120 and $149 and Suite between $150 and $200.
Build a model to maximize the hotel's total revenue.
What is the new price for suite?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started