Simple Rate Pricing Formula for Revenue Managers

#Rate #Pricing #RevenueManagement #HarunDagli #HospitalityCode #RoomQuantityRiskFactor

There is a simple concept in hospitality revenue management which is which is pushing the rates as much as possible during the strong demand period and reduce and fill the hotel during low periods. We all been there and done that but most of the time without any scientific work. As a result, we have experienced fluctuations in rate occupancy parity and on the bottom line. Of course, depending on location, market and competition it varies and this is where revenue management as an art come in to force. I will share a simple formula which allows you to clarify the risks associated with GOP, allowing you a reasonable starting point to make smart pricing decisions.

As the nature of our business Revenue managers often focused on the top-line impacts of revenue decisions which are a kind of game between occupancy and the rate. On the other hand, stakeholders, owners, GMs are more focus to figures further down on the P&L including gross operating profit and net operating income, since performance at this level is most often directly tied to the value of their asset.

I believe it would be beneficial to explain this with an example; you are running Hotel-A and you have identified a need period in early November and you are thinking about doing a promotion to drive incremental business.

You did a promotion last year for the same period and sold 650 room nights at a rate of £170 produced £110,5K. Your property didn’t sell out on any given night last year, and you were reasonably pleased with the results. This year, you would like to do even better, but you are not sure whether you should raise rates to £180 and run the risk of selling fewer rooms or to lower rates to £160 in the hopes of selling even more room nights.

So, how can you assess the risks associated with either course of action?

Important Note: Depending on your hotel occupancy and your outlet structure you definitely gain or lose potential revenue. We will knowingly ignore this and will focus on just room revenue throughout this exercise to keep our example relatively simple. Please feel free to contact me on for more detail and tailored assessment for your hotel.

1.Classical Method:

From basic Mathematics and Revenue perspective, the calculation is very straightforward as shown above. Considering that we would like to have the same revenue if you divide this figure by projected rates you can easily find number of rooms required to sell to earn roughly the same revenue as the year prior.

Above you can find YoY differences for rate and room sold in both mathematical terms and percentages;

Opt-1: £110,000 / £160 = 691 691 - 650 = +41 more rooms 691 / 650 -1 = +6.3% Diff

If you reduced the rate £10 (-5.9%) than you need to sell 41 more room vs LY to achieve the same revenue.

Opt-2: £110,000 / £180 = 614 614 – 650 = -36 less rooms 614 / 650 – 1 = -5.6% Diff

If you increase the rate of £10 than 36 rooms less than LY will help you to get the same revenue.

Unfortunately, this does not shed light on the profitability of each possible decision.

2.Pricing Formula:

This simple pricing formula will help clarify the risks associated with a given pricing decision on GOP—before that pricing decision is implemented. We have to gather a few more figures to assess each scenario appropriately;

  • Baseline Production: As per our example, we will use last year’s total room sold which is 650 RNs.

  • % Change in Rate: Last year’s actual rate is £170 and we would like to explore the possibility to choose in between £160 and £180 for this year’s promotion. In this example we selected two option either -£10 (-5.9%) cheaper or £10 (+5.9%) higher than last year’s rate.

  • Variable Cost of Room: Cost of room as it stated variable and based on different factors such as total number of rooms, labour and room amenity costs and market segment. You can get this figure from your P&L or Finance manager of your property could give you this variable cost figure. During this exercise, I will use an estimated fictitious figure of £50.

  • Rooms Gross Margin Percent (GM%):

GM% = (ADR – Variable Cost of Room) / ADR

GM% = (£170 - £50) / £170 = 70.6%.