Reports and planning

Hotel occupancy index: calculate and interpret MPI

Calculate hotel occupancy index with weighted room-night totals, an Azerbaijan example and practical checks for a reliable MPI comparison.

A navy and ivory miniature hotel beside blank comparison occupancy blocks and a brass ratio arch, without text or people
Editorial illustration · AI generated

The short answer

Hotel occupancy index, or MPI, equals hotel occupancy divided by comparable aggregated occupancy, multiplied by 100. Match stay dates and room-night definitions. A result of 100 means equal occupancy; a higher index does not establish market-share percentage or profit. Without a valid positive benchmark, leave MPI unavailable.

A busy reception does not tell a hotel manager whether occupancy is strong relative to comparable properties. A small hotel in Azerbaijan may sell more room-nights than last month while the wider comparison group improves even faster. Hotel occupancy index, also called MPI, gives that question a numerical starting point.

Use it to investigate demand capture, then consider achieved rates and costs before making a commercial decision. The practical workflow below separates the calculation from the explanation and uses fictional figures, not local market statistics or a customer case study.

Define the comparison

The CoStar STR Benchmark glossary defines MPI = hotel occupancy ÷ aggregated group occupancy × 100. The group may be a competitive set, market or submarket.

HSMAI Academy’s MPI definition uses 100 as the equal-performance reference: values above or below it indicate higher or lower relative occupancy.

Choose the comparison group before reviewing the result. Location, accommodation category, operating pattern and guest demand should make the comparison useful. A seasonal leisure property and a year-round city business hotel may face different booking conditions. Describe those differences instead of treating a convenient available benchmark as a perfect match.

Record whether the provider includes your own hotel in the aggregate. Keep that scope consistent between reviews and disclose any change. A different group can move the index even when your hotel sells exactly the same number of room-nights.

Build both occupancies from the same period

For each side, occupancy is sold room-nights ÷ available room-nights × 100. A room sold for three nights contributes three room-nights, regardless of the number of guests. Use completed stay dates for an actual-performance comparison; do not mix future reservations with a completed-period benchmark.

Calculate comparison occupancy from total sold room-nights divided by total available room-nights, or use the provider’s compatible published aggregate. This weights each hotel’s contribution by available room-nights. An unweighted average of hotel percentages gives a tiny property the same influence as a large one and can distort the denominator.

Match the exact start and end dates and review inventory definitions. Document how temporary closures, rooms under maintenance, complimentary stays and internal use are treated. Do not change your denominator simply to improve the result. The occupancy, ADR and RevPAR guide helps establish the underlying measures.

Use publicly available aggregated reports or a lawfully obtained benchmark with clear methodology. Do not arrange exchanges of competitors’ confidential operating figures. An online booking page showing no rooms may reflect restrictions, closed sales or channel allocation. Scraping availability cannot establish actual competitor occupancy; advertised competitor rates answer a different question.

Follow a fictional Azerbaijan example

Suppose a 20-room hotel in Sheki has all rooms available for a 30-night period. The benchmark below is an invented aggregate covering the same dates and definitions.

Measure Hotel Comparison group
Available room-nights 20 × 30 = 600 3,000
Sold room-nights 420 1,800
Occupancy 420 ÷ 600 = 70% 1,800 ÷ 3,000 = 60%

MPI = 70 ÷ 60 × 100 = 116.67. Keep full precision during calculation and round the final displayed result.

Occupancy exceeds the benchmark by 10 percentage points. Relative to the benchmark, it is 16.67% higher. These describe different comparisons: subtract the percentages for the first, divide their difference by 60% for the second. An MPI of 116.67 does not mean the hotel holds 116.67% of market sales.

Check the price behind the occupied rooms

Now assume achieved ADR is 80 AZN for the hotel and 100 AZN for the aggregate, with consistent room-revenue definitions. Hotel RevPAR is 0.70 × 80 = 56 AZN; benchmark RevPAR is 0.60 × 100 = 60 AZN. The resulting revenue index is 56 ÷ 60 × 100 = 93.33.

The hotel has higher relative occupancy but lower relative revenue per available room. Neither MPI nor this revenue comparison establishes profit, because operating and selling costs still matter. Use the RevPAR index guide for the revenue comparison and investigate the hotel’s own rate and booking mix before proposing a price change.

Review before taking action

  • Confirm the benchmark source, group scope, report version and permitted use.
  • Match stay dates and sold/available room-night definitions.
  • Reconcile your totals and use a weighted aggregate.
  • Show actual occupancy, its trend, ADR and RevPAR beside MPI.
  • Note group changes or unusual closures that affect interpretation.
  • Assign a manager, proposed action and review date.

Retain the original inputs with the calculation. If corrected data arrives, issue a labelled revision. For a small property, investigate whether a handful of room-nights explains a large-looking movement before drawing a broad conclusion about demand.

Frequently asked questions

What if benchmark occupancy is missing or zero? No valid MPI can be calculated. Mark it unavailable, check the source and follow your own comparable historical figures. Zero available room-nights also invalidates the underlying occupancy.

Does MPI above 100 justify raising prices? It warrants review, not an automatic decision. Examine achieved rates, upcoming demand and costs; the example shows why occupancy alone is insufficient.

Does BirOtel automatically supply competitor MPI? A competitor benchmark integration and automatic MPI calculation are not confirmed. BirOtel supports reservations, pricing, guests, payments and reports in Azerbaijani and English. Bring your worksheet to a hotel reporting demonstration to verify the available inputs and maintain the external comparison separately.

These guides are published by BirOtel. General methods, illustrative examples and current product capabilities are identified separately. Sources appear beside the relevant explanations.

[email protected]

Explore these workflows for your own hotel

Use your room inventory and daily tasks to assess whether BirOtel fits your hotel in a live demo.