Hotel Asset Management & Yield Benchmarking Lab

Hotel RevPAR Index (RGI) Calculator

Calculate Hotel RevPAR Index (RGI), Occupancy Penetration (MPI), ADR Index (ARI), and fair share revenue premium over compset.

Hospitality Presets

Load benchmark hotel market positions.

Step 1: Subject Property vs. Competitive Set (CompSet) Rooms, Occupancy & ADR

Hotel Market Benchmarking Inputs

🏨 Subject Hotel Performance

Total available rooms.

e.g., 78.0% occ.

Subject ADR ($).

🏙️ Competitive Set (CompSet) Benchmark

Total peer room pool.

Peer average occupancy.

Peer average rate ($).

RevPAR Index Key Metrics

RevPAR Index (RGI)
133.3 RGI
+33.3 pts vs 100.0 fair share (RevPAR $249.60 vs $187.20)
Market Penetration (MPI)
108.3 MPI
78.0% occupancy vs 72.0% compset market average
Average Rate Index (ARI)
123.1 ARI
$320.00 ADR vs $260.00 compset average room rate
Fair Share Premium
+$2.12M
21.0% revenue capture on 16.7% room supply capacity ($10.93M total)

Hotel Yield Matrix: Subject ADR vs. Occupancy %

Simulates RevPAR Index (RGI) scores, realized property RevPAR ($), and annual fair share revenue variance ($M) across pricing and volume trade-offs.

Subject ADR 60% Occ 70% Occ 78% Occ 85% Occ 92% Occ

Hotel Asset Management & Benchmarking

Understanding STR Performance Indices

Key revenue management principles governing competitive performance:

  • The 100-Point Index Parity Benchmark: An index of 100.0 represents perfect fair share. An RGI of 115 means the hotel captures 15% more RevPAR than its competitive fair share; an RGI of 85 indicates a 15% revenue deficit.
  • The RGI Triad Equation: $RGI = rac{MPI imes ARI}{100}$. High RGI can be achieved via Rate Leadership ($ARI > 100, MPI approx 100$) or Volume Penetration ($MPI > 100, ARI approx 100$). Rate-driven RGI typically yields superior GOPPAR flow-through due to lower marginal operating wear.
  • Fair Share vs Revenue Share: If a hotel represents 16.7% of competitive rooms but captures 21.0% of total compset revenue, it enjoys a powerful brand pricing premium and superior market distribution.
  • OTA Commission & Channel Yield: True net profit also depends on distribution cost. Compare direct bookings vs intermediaries in the Hotel OTA Commission Lab.

Explore bottom-line hotel operating profit in the Hotel GOPPAR & TrevPAR Lab.

Mathematical Formulation

Hotel index & yield equations

ext{RevPAR} = ext{Occupancy %} imes ext{ADR} = rac{ ext{Room Revenue}}{ ext{Available Room Nights}}

ext{MPI (Market Penetration Index)} = rac{ ext{Subject Occupancy %}}{ ext{CompSet Occupancy %}} imes 100

ext{ARI (Average Rate Index)} = rac{ ext{Subject ADR}}{ ext{CompSet ADR}} imes 100

ext{RGI (Revenue Generation Index)} = rac{ ext{Subject RevPAR}}{ ext{CompSet RevPAR}} imes 100 = rac{ ext{MPI} imes ext{ARI}}{100}

ext{Capacity Fair Share %} = rac{ ext{Subject Available Rooms}}{ ext{Total CompSet + Subject Rooms}} imes 100

ext{Revenue Premium} = ext{Subject Actual Revenue} - ( ext{Total Market Revenue} imes ext{Fair Share %})

Model hotel room pricing dynamics in the Hotel Revenue Management & RevPAR Lab.

FAQ

Hotel RevPAR index & compset questions

What is the RevPAR Index (Revenue Generation Index / RGI)?

RevPAR Index (RGI) measures a hotel's revenue generation efficiency relative to its competitive set (CompSet): RGI = (Subject RevPAR / CompSet RevPAR) x 100. A score of 100 indicates fair share performance, >100 represents outperformance, and <100 indicates lost market share.

What is the relationship between MPI, ARI, and RGI?

RGI is the mathematical product of Market Penetration Index (MPI) and Average Rate Index (ARI): RGI = (MPI x ARI) / 100. This reveals whether a hotel's market leadership is driven by volume (occupancy) or rate power (ADR).

What is Capacity Fair Share in hotel benchmarking?

Fair Share is the percentage of total market room supply contributed by the subject property: Fair Share % = (Subject Rooms / Total Market Rooms) x 100. If a hotel captures a higher percentage of market revenue than its fair share of rooms, it generates a positive revenue premium.

How can hoteliers improve their RGI?

Hoteliers improve RGI by optimizing revenue strategy: shifting to higher-yielding direct channels, implementing dynamic pricing based on demand elasticity, packaging premium amenities, and driving corporate negotiated contracts.

Can I export hotel compset benchmarking reports to CSV?

Yes. You can export complete STR index scores (RGI, MPI, ARI), fair share revenue variances, and 5x5 ADR vs Occupancy sensitivity heatmaps as a UTF-8 CSV spreadsheet with formula defense.

Continue Exploring Hospitality Management Tools

Explore our Hospitality & Food Service Hub, analyze channel distribution in the Hotel OTA Commission Lab, model hotel operating profits in the Hotel GOPPAR & TrevPAR Lab, optimize restaurant capacity in the RevPASH & Table Turns Lab, or calculate menu profitability in the Menu Engineering Lab.