Monday, August 7, 2017

HOTEL (HOSPITALITY) REVENUE CALCULATION



HOTEL REVENUE CALCULATION

NO
OBJECT
FORMULA
1
% Occupancy
(Room Night Sold : Room Available) X 100
2
Double Occupancy
(Number of Guest Room Night Sold) X 100
3
Average Daily Rate (ADR)
Total Room Sale : Room Night Sold
4
Average Room Rate (ARR)
Room Revenue : Room Night Sold
5
Revenue Per Available Room (RevPAR)
Room Revenue : Room Available
% Occupancy X ADR
6
Revenue Per Occupied Room (RevPOC)
Room Revenue : Room Night Sold
7
Revenue Realized
Room Night Sold X Average Daily Rate
Revenue Potential
Room Available X Rack Rate
Yield
Revenue Realized : Revenue Potential
8
(%) Natural Market Share
Room Available : Total Room Available X 100
9
(%) Actual Market Share
Occupied Room : Total Occupied Room X 100
10
Market Penetration Index (MPI)
Actual Market Share : Natural Market Share
11
Average Rate Index (ARI)
Average Room Rate : Total Average Room Rate (City Result)
12
Revenue Generated Index (RGI)
Market Penetration Index X Average Rate Index
13
Natural Share
Room Available : City Result X 100
14
Actual Share
Room Night Occupied : City Result X 100
15
Fair Share
Actual Share Natural Share
16
Target Total Revenue (Yearly)
Total Revenue N1 X (Inflation + Economy Growth + Effort)

-   RAV                       >> Room Available.
-   RNO                       >> Room Night Occupied.
-   RNS                        >> Room Night Sold.
-   ADR                       >> Average Daily Rate.
-   ARR                        >> Average Room Rate.
-   Yield                      >> Income Return of Investment.
-   MPI                        >> Market Penetration Index.
-   ARI                         >> Average Rate Index.
-   RGI                         >> Revenue Generated Index.
-   RevPAR                >> Revenue per Available Room.
-   RevPOC                >> Revenue per Occupied Room.

****************************************Yustianto.AW****************************

3 comments:

  1. Bisa minta contoh real cara menghitung ADR dan ARR kah ?

    ReplyDelete
    Replies
    1. ADR itu menghitung total revenue dibagi jumlah kamar yg available

      klo ARR menghitung total revenue di bagi jumlah kamar yg terjual

      Delete
  2. Having your own house is the dream of every person. For a middle class person, it is considered as a lifetime achievement as it requires quite a huge amount of money. Banks play a pivotal role in fulfilling this basic need. The products they offer and the services they provide are of immense use to people who intend to have their own house. For a safe and beneficial home loan, proper awareness over the products, policies, terms and conditions of the bank is most important as ignorance may result in more payments to the bank in terms of principal and interest components.
    But working with Mr Pedro changed everything in the lending experience, Mr Pedro helped me with a home loan at 2% rate which was very fast and smooth.
    I will recommend Mr Pedro a loan officer and his awesome funding company Email Mr Pedro on pedroloanss@gmail.com.


    Marie Carlos,
    Texas USA

    ReplyDelete