Market Penetration Index Calculator — Hotel Occupancy vs Market

About the Market Penetration Index Calculator — Hotel Occupancy vs Market

The Market Penetration Index (MPI) measures how your hotel's occupancy compares to the competitive set's average occupancy. It answers the fundamental question: are you capturing your fair share of market demand? An MPI above 100 means you're filling a larger proportion of your rooms than competitors. Below 100 means demand is flowing to other properties.

MPI is the occupancy component of the STR performance triad (MPI, ARI, RGI). While ARI measures pricing performance, MPI measures demand capture. A hotel can have strong pricing (high ARI) but weak demand capture (low MPI), resulting in suboptimal RevPAR performance.

This calculator computes your MPI and shows the occupancy gap in percentage points. Revenue managers use MPI to evaluate whether their property is effectively attracting guests relative to the competition, and to diagnose whether RevPAR challenges are rate-driven or demand-driven.

When This Page Helps

Occupancy alone doesn't tell you if you're winning or losing demand. A 75% occupancy rate sounds good until you learn the market is running at 85%. MPI provides the competitive context that transforms raw occupancy data into actionable strategy insights.

How to Use the Inputs

1. Enter your hotel's occupancy rate for the period.
2. Enter the market (comp set) average occupancy rate.
3. Review the MPI score and occupancy gap.
4. An MPI above 100 means you capture more than your share of demand.
5. Track MPI by segment (transient, group, corporate) if possible.
6. Compare MPI trends with ARI trends to diagnose competitive dynamics.

Example Calculation

Tips & Best Practices

• MPI above 100 with ARI below 100 suggests you're buying occupancy with low rates.
• MPI below 100 with ARI above 100 means you're pricing guests away.
• Track MPI by day of week to identify specific demand-weak days.
• A new competitor can reduce your MPI even without any change in your operations.
• Use MPI to validate whether marketing and sales initiatives are driving demand.
• During renovations, expect MPI to decline temporarily — monitor recovery closely.

MPI and Market Share Dynamics

MPI is essentially a market share metric expressed as an index. When a new hotel enters your comp set, the total rooms in the market increase, and every existing hotel's fair share decreases. Maintaining an MPI of 100 after new supply enters the market means you've successfully defended your share against the new competitor.

Seasonal MPI Patterns

Most hotels see MPI variation by season. A beach resort may have an MPI of 115 in summer (when its location is the strongest draw) but 90 in winter (when business travelers prefer downtown). Understanding these patterns helps set realistic expectations and focus improvement efforts.

Using MPI to Drive Sales Strategy

If MPI analysis reveals consistently weak performance on Sundays and Mondays, the sales team can target groups or corporate accounts that need those specific nights. MPI by day of week is one of the most actionable competitive metrics for directing sales efforts.

Frequently Asked Questions

• What is a good MPI?

  An MPI of 100 means you're capturing exactly your fair share. Most well-managed hotels target 100-110. An MPI consistently above 115 may suggest your comp set is too weak and needs updating.

• How is MPI different from occupancy?

  Occupancy is an absolute measure (% of rooms filled). MPI is a relative measure comparing your occupancy to the market. You can have high occupancy but low MPI if the market is running even higher.

• What causes a low MPI?

  Common causes include overpricing (high ARI pushing demand to competitors), poor online reputation, ineffective marketing, channel distribution issues, or a new competitor taking market share. Use this calculator to model different scenarios and find the best approach.

• Can MPI and ARI both be above 100?

  Yes, and that's the ideal scenario. It means you're commanding higher rates AND filling more rooms than competitors. This produces an RGI well above 100, indicating strong overall competitive performance.

• How does MPI relate to fair market share?

  Fair market share is the proportion of total rooms your hotel represents in the comp set. If you have 200 of 1,000 total comp set rooms (20% fair share), an MPI of 100 means you're capturing exactly 20% of demand.

• Should MPI influence my pricing decisions?

  Absolutely. If MPI is strong (above 105), you may have room to raise rates. If MPI is weak (below 95), aggressive rate cuts may be warranted to stimulate demand — but always evaluate the RGI impact.