Front Office Formulas
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
Comments