Formulas for Front Office
· Percentage of No-Shows =
Total number of No-Shows X
100
Number of Room Reservations
·
Percentage of Walk-Ins
=
Number of Room Walk-Ins X 100
Total Number of Room
Arrivals
·
Percentage of Over Stays =
Number of Over stay Rooms X 100
Number of Expected
Check-Outs
·
Percentage of Under stays =
Number of Under stay Rooms X 100
Number of Expected
Check-Outs
·
The
forecasted Number of rooms available
for Sale for any future date can be tracked using the following
formula:-
Total number
of guest rooms
- Number of out of order rooms
- Number of stay over rooms
- Number of room reservations
+ (Number of
room reservation) x (% of no show rooms)
+ Number of
under stay rooms
- Number of overstay rooms___________
= Total
number of rooms available for sale
·
Forecasted room revenue = Room available x
occupancy percentage
x Average Daily rate (ADR)
·
Occupancy Percentage = Number of Rooms
occupied x 100
Number of Rooms available
for sale
· Multiple
Occupancy Percentage =
Number of rooms occupied by more than one
guest x
100
Total number of rooms occupied
·
Average Guest Per Room Sold =
Total number of guests
Total no. of rooms sold
·
Average Daily Rate (ADR) = Total
rooms revenue
Total no. of rooms sold
·
Average Rate per Guests (ARG) = Total room
revenue
Number
of Guest
·
Yield Statistics =
Actual Room Revenue
Potential Room
Revenue
·
Yield Calculation
1. Yield =
(Occupancy percentage) x (Achievement
factor)
2. Yield = Revenue
realized
Revenue Potential
1. Yield = Number
of rooms night sold x Actual average
room rate Number of available rooms Potential room rate
·
House count
=
Previous night's house
count + arrivals for today - departures for today
·
Room Occupancy Percentage =
Number of rooms
occupied x 100
Number of rooms available
for sale
·
Bed Occupancy Percentage
= Number of beds sold x
100
Number of beds available for sale
·
Double Occupancy Percentage =
Number of double occupants x
100
Number of rooms sold
·
Double Occupancy Percentage
=
Total number of guests – total rooms
occupied x 100
Number of rooms sold
·
Double Occupancy Percentage =
House count – Room count x 100
Room count
·
Average Room Rate (ARR)= Total room revenue
Number of rooms sold
·
Average occupancy per room = Total number of Guests
Number of rooms occupied
by Guests
·
Potential Average Single Rate = Single
Room Revenue
Number of Rooms
·
Potential Average Double Rate
= Double Room Revenue
Number of Rooms
·
Rate spread = (Potential average double rate) –
(Potential average single rate)
·
Potential Average Rate (PAR) =
(Multiple occupancy percentage)
x (Rate spread) + (Potential average single rate)
· Rate
Achievement Factor = Actual Average Rate
Potential
Average Rate
·
Local occupancy percentage =
Number of local guest in the hotel x
100
Total number of guests in the hotel
(House
Count)
·
Foreign occupancy percentage
=
Number of foreign guest in the hotel x
100
Total number
of guests in the hotel
(House Count)
·
Sleeper Occupancy Percentage = Actual
Sleepers x
100
Potential Sleepers
·
Percentage Revenue achieved
= Actual revenue x
100
Potential revenue
·
Gross Operating Profit Per Available Room (GOP PAR) =
Gross
operating profit
Rooms available
·
Revenue per available room (REV PAR)
1. Revenue
per available room =
Actual room revenue
Rooms available for sale
2. Revenue per available room = Occupancy percentage x
Average daily rate
These formulas r so handy. Great.
ReplyDeleteThanks Gagan.
ReplyDelete