FO Formula – Average Room Rate (ARR) | Average Daily Rate (ADR) Calculator | Hotels

Support Our Work

Since 2011 Setupmyhotel has been helping hundreds of hoteliers around the world. Support us by becoming our Patron! Exclusive resources, ad-free content, and more!

Formula to Calculate Average Room Rate (ARR) | Average Daily Rate (ADR)

Calculating the Average Room Rate (ARR) and the Average Daily Rate (ADR) are important metrics for hotels to monitor, as they provide insight into the performance of the hotel. The ARR represents the average price of a room for a given period of time, while the ADR represents the average price of a room for each day during that period.

To calculate the ARR, simply divide the total room revenue by the total number of rooms sold during the specified time frame. This will provide an average price per room, which can then be used to monitor the performance of the hotel over time.

The ADR is calculated by dividing the total room revenue by the total number of rooms sold during the same time period. This will provide the average daily rate for each room sold, which is a powerful metric for understanding the day-to-day performance of the hotel.

By monitoring these metrics over time, hotel managers can make informed decisions about pricing strategies, marketing efforts, and other aspects of the business. Ultimately, the FO Formula provides a useful tool for hotels to measure their success and make data-driven decisions for the future.

Some hotels calculate ARR or ADR by also including the complimentary rooms this is called as Hotel Average Rate. By Taking the HARR the management can find out the actual effect of complimentary stays on the average room rate.

The formula for ARR or ADR calculation:

Average Room Rate (ARR or ADR) = Total Room Revenue / Total Rooms Sold

OR

Average Room Rate (ARR or ADR) = Total Room Revenue / Total Occupied Rooms

ADR (Average Daily Rate) or ARR (Average Room Rate) is a measure of the average rate paid for the rooms sold, calculated by dividing total room revenue by rooms sold. 

Average Room Rate (ARR or ADR) Calculator

Total Room Revenue:

Total Rooms Occupied:

Total Comp & House:

ARR or ADR (Occupied Rooms) =

ARR or ADR (Sold Rooms) =


Example 1:

Total Room Revenue for 01st Jan 2017   = 25000.00

Total Room Sold for 01st Jan 2017         = 250

ARR or ADR for 01st Jan 2017        = 25000.00 / 250

                                                         = 100

Example 2:

Total Room Revenue for 31st Dec 2016 = 95985.58

Total Room Sold for 31st Dec 2016       = 277

ARR or ADR for 31st Dec 2016        = 95985.58 / 277

                                                            = 346.52

Example 3 (Monthly ARR/ADR):

Total Room Revenue for the Month of October = 2,250,485.58

Total Room Sold for the Month of October       = 5822

ARR or ADR for October                             = 2,250,485.58 / 5822

                                                                      = 386.55

The formula for Hotel Average Rate HARR or HADR

Average Hotel Room Rate (HARR or HADR) = Total Room Revenue / Total Rooms Sold + Comp Rooms

Example 1:

Total Room Revenue for 21st Mar 2017           = 25000

Total Room Sold for 21st Mar 2017                 = 250

Total Complimentary rooms for 21st Mar 2017 =  2

HARR or HADR for 21st Mar 2017             = 25000 / (250+2) 

                                                                      = 99.20

Example 2:

Total Room Revenue for 3rd Dec 2015             = 95985.58

Total Room Sold for 3rd Dec 2015                   = 277

Total Complimentary rooms for 3rd Dec 2015  =  2

HARR or HADR for 3rd Dec 2015                = 95985.58 / (277+2)

                                                                       = 344.03

Example 3 (Monthly ARR/ADR):

Total Room Revenue for October  = 2,250,485.58

Total Room Sold for October        = 5822

Total Complimentary rooms for October          = 25

ARR or ADR for October                              = 2,250,485.58 / (5822+25)

                                                                       = 384.89

Enjoying our content? Support us on Patreon!
Become a patron at Patreon!
Spread the love

Back Office Job Description Banquet BAR Beverage Service Cashiering Chef Chef Training Cleaning Concierge Duties and Responsibility Engineering Executive Chef F&B Setup F&B Training Finance Food Service Front Desk Front Office Formats Front Office Setup Front Office Training Guest Room Guest Services Hospitality Basics Hotel Formats Hotel Security Hotel Staff Job Description Hotel Staff Training Housekeeping Formats Housekeeping Setup Housekeeping Training Kitchen Kitchen Basics Kitchen Training Maintenance Maintenance Technician Reservation Restaurant Sales SOP SOP F&B Service SOP Finance and Accounting SOP Front Office SOP Housekeeping SOP Kitchen Staff Training

Support Our Work

Since 2011 Setupmyhotel has been helping hundreds of hoteliers around the world. Support us by becoming our Patron! Exclusive resources, ad-free content, and more!

Learn more