Hotel Math Fundamentals: The Metrics used by the Hotel Industry Flashcards
How does STR obtain Raw Data?
Most raw property sales data is directly exposed from the systems of the hotel companies. This helps increase the reliability of the data.
Most _____________ is directly exposed from the systems of the hotel companies. This helps increase _________ of the data.
raw property sales data; reliability
Companies send STR a _______ each month, week, and/or day
raw data file
Some hotels and smaller companies enter the data on. _________ which can be used to enter monthly or daily data. Users can also enter ________ via the web-later
the STR website; segmentation data
Hotel ID, Hotel Name, Date, Rooms Available, Rooms Sold, Room Revenue
“Sample” Raw Data
Raw Data includes…
Hotel ID, Hotel Name, Date, Rooms Available, Rooms Sold, Room Revenue
In most cases, companies provide their own…
unique hotel identification without a hotel name
A daily file would look the same as…
a monthly raw data file except for the date field
YYYMMDD
A non-US data file would have a…
currency indicator (i.e. USD, EUR, GBP)
DATA ERROR CHECKS: STR performs a large volume of….
comprehensive error checks upon the raw data
DATA ERROR CHECKS: New data is compared to prior data for __________
consistency
DATA ERROR CHECKS: There are ___________ limits related to geography and type of hotel.
Occupancy and ADR
DATA ERROR CHECKS: STR also tracks special events that would…..
cause unusual occupancies and ADR
DATA ERROR CHECKS: Any exceptions are verified with…..
the data provider (company or hotel) before the data is accepted.
STR DATA Guidelines: STR uses a strict set of definitions based on the…
UNIFORM SYSTEM OF ACCOUNTS FOR THE LODGING INDUSTRY
rooms available
SUPPLY
the number of rooms in a hotel multiplied by the days in the month
SUPPLY
(# of rooms in a hotel) x (days in the month)
SUPPLY
rooms sold
DEMAND
number of rooms sold by a hotel
DEMAND
does not include complimentary rooms
DEMAND
does not include “no-shows”
DEMAND
does not include complimentary rooms or “no-shows”
DEMAND
reservations not cancelled but no one checked in towards them
NO-SHOWS
total room revenue generated from the sales of rooms
Revenue
does not include taxes
Revenue
total room revenue generated from sales of rooms, not including taxes
Revenue
Includes service charges
Revenue
does not include resort fees
Revenue
includes service charges NOT resort fees, nothing else such as F&B
Revenue
The Uniform System of Accounts for the Lodging Industry is…
available from the AHLA or HFTP
What does KPI stand for?
Key Performance Indicators
From these raw data values, STR calculates the _______ hotel industry Key Performance Indicators.
three
Occupancy (%), Average Daily rate ($), Revenue per Available Rooms ($)
Hotel Industry Key Performance Indicators
What does ADR stand for?
Average Daily Rate
What does RevPAR stand for?
Revenue per Available Room
Important metric that is based upon ALL rooms
Revenue per Available Room
combination of occupancy and Average Daily Rate
Revenue per Available Room
Important metric that is based upon ALL rooms, combination of occupancy and Average Daily Rate
RevPAR
The percentage of available rooms that were sold during a specific time period
Occupancy
Calculated by dividing the Demand (# of rooms sold) by the supply (# of rooms available)
Occupancy
((# of rooms sold) / (# of rooms available)) x 100
Occupancy
A percentage; Divide the SMALLER number by the large number
Occupancy
(Demand/Supply) x 100
Occupancy
A measure of the average rate paid for rooms sold during a specific time period
Average Daily Rate
divide the Room Revenue by the Demand (# of rooms Sold)
ADR
(Revenue/Demand)
ADR
(Revenue)/((# of Rooms Sold)
ADR
A dollar amount
ADR
A Measure of the revenue that is generated by a property in terms of each room available
Revenue per Available Room
Differs from Average Daily Rate because it is affected by the amount of unoccupied room while Average Daily Rate only shows the average rate of rooms actually sold
Revenue per Available Room
How is RevPAR different from ADR?
it is affected by the amount of unoccupied rooms
How is ADR different from RevPAR?
it only shows the average rate of rooms actually sold
Differs from Revenue per Available Rooms because it only shows the average rate of rooms actually sold while Revenue per Available Rooms is affected by the amount of unoccupied room
Average Daily Rate
divide the Room Revenue by the total number of Rooms available (Supply)
Revenue per Available Room
(Room Revenue) / (total # of Rooms Availabl)
RevPAR
A dollar amount
RevPAR
(Revenu/Supply)
RevPAR
Of the three Key Performance Indicators, ADR and RevPAR…
are both Dollar amounts
To get the ADR value…
divide Revenue by Rooms Sold (Demand)
To get the RevPAR value…
divide Revenue by Rooms Available (Supply)
What is the difference between how you find ADR and RevPAR?
To get ADR value, you divide Revenue by Rooms Sold (Demand) whereas to get the RevPAR, you divide Revenue by Rooms Available (Supply)
In most cases, the RevPAR amount should be _______ than the ADR amount
lower
the Revenue per Available Room amount should be lower than the Average Daily Rate amount
helps to check your math
The only time that Revenue per Available Room amount is not lower than the Average Daily Rate amount would be…
if the rooms sold number was GREATER than the Rooms Available.
When the rooms sold number is Greater than the Rooms Available occupancy…
would be greater than 100%
Some people calculate RevPAR by…
multiplying ADR times Occupancy
important metric for the Hotel Industry since it is a combination of Occupancy and ADR
RevPAR
A hotel could have 100% Occupancy because of a low ADR
RevPAR will reflect that
A hotel could have a very high ADR but only sell one Room
RevPAR would reflect that
Often people will talk about whether a RevPAR increase(or decrease) is attributed more to…
an increase(or decrease) in occupancy or ADR.
Frequently when a hotel or General Manager is evaluated or measured….
RevPAR is the metric that is being looked at.
The comparison of the THIS YEAR (TY) number versus the LAST YEAR (LY) number, whether a raw value or a Key Performance Indicator (KPI)
Percent Changes
What does TY stand for?
This Year
What does LY stand for?
Last Year
Illustrates the amount of growth (up, flat, down) from the same period last year
Percent Changes
The “TY” number minus the “LY number divided by the “LY” number, then times 100 since it is a percentage
Percent Changes
((TY-LY)/LY)*100
Percent Changes
Remember the parentheses for the “order of operations”
Percent Changes
STR typically shows Percent Changes numbers such as…
Occupancy Percent Change
Sometimes people talk about…
Point Change
IF the occupancy was 51% this year compared to 50% last year, the point change would be _____ and the percent change would be _____
1 ; 2%
STAR Reports always show…
Percent Change
shows whether the occupancy this year is greater or less rooms than the occupancy last year
Occupancy Percent Change
changes could be related to supply and demand changes
Occupancy Percent Change
shows whether the average rate this year is greater or less than the average rate last year
Average Daily Rate Percent Change
shows whether the RevPAR amount is greater or less than the amount last year
Revenue Per Available Room Percent Change
changes could be related to Occupancy and ADR differences
Revenue Per Available Room Percent Change
roughly the combination of Occupancy and ADR Precent Change Great to know for checking math
RevPAR Percent Change
Great to know for checking math
RevPAR Percent Change
If occupancy percent change is 2% and ADR Percent Change is 2% than RevPAR percent change will roughly be…
4%
If occupancy percent change is 2% and ADR Percent Change is -2%, than RevPAR percent change will roughly be…
0%
People will talk about whether a RevPAR Percent Change, whether positive or negative, is more attributed to the _______ or the _________.
Occupancy Percentage Change; ADR Percent Change
If the occupancy Percent Change is 4% and the ADR Percent change is 1%, than the RevPAR Percent Change will roughly be…
5%
more influenced by Occupancy than ADR
RevPAR Percent Change
RevPAR Percent Change is more influenced by __________ than _________.
Occupancy; ADR
If the Occupancy percent change is -4% and the ADR Percent Change is -1%, than the RevPAR Percent Change will roughly be…
- 5%
* In this case, the negative RevPAR percent change is more a factor of occupancy than ADR
1 What is the general trend over time? (Are Occupancies or ADRs going up,down,or are they constant?)
Thing/Scenarios to consider when Analyzing Percent Change Numbers
Thing/Scenarios to consider when Analyzing Percent Change Numbers are…
1 What is the general trend over time? (Are Occupancies or ADRs going up,down,or are they constant?)
If there was a big event, during the current month this year, than…
the numbers will probably go up.
If there was a big even last year, than the numbers…
may go down.
When looking at monthly numbers, always check…
the number of weekends compared to week days.
In a month there cane be anywhere from ______ weekend days
8-10
If a hotel does better on the weekends, than…
a month with more weekend days will always look better
Be sure to check holiday. Some are ________ and some have ______ but vary the day of weekend while others vary _______.
consistent ; consistent dates ; substantionally
The __________ of holidays related to weekends can have a significant impact
juxtaposition
1st Friday of the month
Consistent holiday
Christmas
vary the day of the week but have consistent date
Easter
vary substantially and falls on different months
When checking daily data…
be sure to check special events