Hotel Room Revenue Calculator

Calculate total room revenue by summing rooms sold at each rate tier. Analyze rate mix and total room income for any period.

Rate Tiers

$
$
$
$
$
Total Room Revenue
$43,000.00
Total income before expenses
Total Rooms Sold
210
Sum of all values
Weighted Avg Rate (ADR)
$204.76
Gravitational force measurement
Planning notes, formulas, and examples

About the Hotel Room Revenue Calculator

Total room revenue is the sum of all income generated from selling guest rooms over a specific period. Hotels sell rooms at different rates โ€” rack rate, corporate rate, group rate, promotional rate, and OTA rate โ€” so total room revenue equals the sum of rooms sold at each rate multiplied by that rate.

This calculator lets you enter up to five rate tiers with the number of rooms sold at each tier. It computes total room revenue, weighted average rate, and shows the breakdown by tier. This is essential for revenue managers who need to understand rate mix and total top-line performance.

Accurate room revenue tracking is the foundation for computing ADR, RevPAR, and every other room-centric hotel metric.

When This Page Helps

Understanding room revenue by rate tier reveals how much each segment contributes and whether discounted channels are diluting your overall rate. This analysis guides distribution strategy, contract negotiations, and promotional decisions.

How to Use the Inputs

  1. Enter the rate and rooms sold for your first rate tier (e.g., rack rate).
  2. Add up to four more tiers (corporate, group, OTA, promotional).
  3. Leave unused tiers at zero.
  4. Review total room revenue and the weighted average rate.
  5. Analyze which tiers contribute the most revenue.
  6. Use the weighted average rate as your ADR check.
Formula used
Room Revenue = ฮฃ (Rooms Sold at Rate_i ร— Rate_i) Weighted Avg Rate = Total Room Revenue รท Total Rooms Sold

Example Calculation

Result: $43,000

Tier 1: 80 ร— $250 = $20,000. Tier 2: 70 ร— $200 = $14,000. Tier 3: 60 ร— $150 = $9,000. Total = $43,000. Weighted average rate = $43,000 รท 210 = $204.76.

Tips & Best Practices

  • Include all rate types: rack, negotiated, group, OTA, package, employee, comp.
  • Exclude taxes and resort fees from rates for a clean revenue figure.
  • Use this to verify your PMS room revenue report accuracy.
  • Compare rate mix month over month to spot channel shifts.
  • High OTA tier contribution may signal a need for stronger direct booking efforts.
  • Track weekend vs. weekday rate tiers separately for better insights.

Understanding Rate Mix

A hotel's rate mix โ€” the distribution of rooms sold across different price points and channels โ€” is a key determinant of overall revenue performance. A property that sells mostly at rack rate will have higher ADR and margins than one reliant on deep-discount OTA bookings.

Revenue Building Blocks

Room revenue is built room by room, night by night. Revenue managers must balance the desire for high rates against the risk of unsold inventory. Tools like this calculator help visualise how different rate strategies affect the total revenue picture.

Seasonal Rate Strategy

During peak demand, a higher proportion of rooms should sell at premium rates. During shoulder periods, promotional rates and group business fill inventory. Tracking revenue by tier across seasons reveals whether your pricing calendar is optimised.

Sources & Methodology

Last updated:

Frequently Asked Questions

  • No. Comp rooms have a $0 rate and generate no revenue. Include them only if you want to see their dilutive effect on weighted average rate.