🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Hospitality, Food & Tourism › Hotel & Hospitality Operations › Hotel Revenue Management › Lesson 2
HOS-HOTE29-04 · Lesson 2 · 13 clock hours · lab

Core Revenue Metrics: Occupancy, ADR, and RevPAR

Objective. Students will correctly calculate occupancy percentage, Average Daily Rate, and Revenue Per Available Room using sample hotel data.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a certified food-safety manager and industry professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Revenue Metrics Matter

Every hotel—from a budget roadside property to a luxury resort—tracks the same three core numbers every single day: occupancy percentage, Average Daily Rate (ADR), and Revenue Per Available Room (RevPAR). These metrics tell ownership and management how well the property is converting its inventory of rooms into money. As a hospitality professional working toward your AHLEI credentials, you must be able to calculate all three from a daily revenue report quickly and accurately.

The Hotel Room as Inventory

Unlike a store that can restock a product, a hotel room that goes unsold tonight is revenue lost forever—that night cannot be recovered. This is why revenue management focuses so sharply on how many rooms are sold, at what price, and what the combined result means per available room. Understanding these three metrics gives you the language to discuss performance with a general manager, an owner, or a corporate revenue team.

Occupancy Percentage

Occupancy percentage (commonly called simply "occupancy") measures what share of a hotel's available rooms were actually sold during a given period.

Formula:

> Occupancy % = (Rooms Sold ÷ Rooms Available) × 100

"Rooms Available" means the total number of rooms the property could have sold—sometimes called the room supply. If a property has 120 rooms but 4 are out of order for maintenance, some revenue systems use 116 as available; your property's policy will specify whether out-of-order rooms are excluded. For this course, use the figure labeled "Rooms Available" on any report you are given.

Occupancy is expressed as a percentage. An occupancy of 78% means 78 out of every 100 available rooms were sold that night.

Average Daily Rate (ADR)

ADR measures the average price actually paid per occupied room. It is calculated from room revenue only—food, beverage, parking, and spa charges are excluded.

Formula:

> ADR = Room Revenue ÷ Rooms Sold

Note carefully: the denominator is rooms sold, not rooms available. ADR reflects pricing strength—it tells you what guests actually paid, on average, after any discounts, packages, or negotiated rates.

Revenue Per Available Room (RevPAR)

RevPAR combines occupancy and rate into a single performance number. It is the industry's most widely used measure of overall room revenue productivity because it captures both how full the hotel is and what it charged.

There are two equivalent formulas:

Formula A (from ADR and Occupancy):

> RevPAR = ADR × (Occupancy % ÷ 100)

Formula B (direct from data):

> RevPAR = Room Revenue ÷ Rooms Available

Both formulas produce the same result. Formula B is often faster when you already have room revenue and rooms available on hand.

RevPAR is expressed in dollars, not as a percentage. A RevPAR of $94.50 means the property earned $94.50 for every room it had available, regardless of whether each room was sold.

Reading a Daily Revenue Report

A standard daily revenue report (also called a daily flash report or night audit summary) lists, at minimum: the date, total rooms available, rooms sold, rooms vacant, room revenue, and sometimes food and beverage revenue. When you pick up one of these reports, locate these fields first before you attempt any calculation. Misreading rooms available as rooms sold is the single most common arithmetic error in this lab.

Rounding Rules

In this course, round occupancy percentage to one decimal place (e.g., 73.3%). Round ADR and RevPAR to two decimal places (e.g., $112.45). Do not round intermediate values mid-calculation; carry full decimal precision until your final answer, then round. Premature rounding creates compounding errors across a 7-day data set.

Safety and Data Integrity

Revenue data is confidential business information. In the lab you will work with simulated data, but in a real property, daily revenue reports are internal documents. Treat them accordingly—do not photograph, share, or post actual hotel data outside authorized channels. Data security is part of professional conduct in this field and is referenced in AHLEI's guest service and supervisor competency standards.

When working in spreadsheet software, always save your file frequently and maintain a backup copy before making edits. If you discover a formula error in a shared file, document the error and your correction in writing rather than silently overwriting another person's work—this is both professional practice and a required step in today's error-correction activity.

Putting the Three Metrics Together

Consider a 100-room hotel: if occupancy rises but management deeply discounts rates, ADR falls. RevPAR will capture that trade-off. Conversely, a hotel can achieve a high ADR by only accepting high-paying guests, but if many rooms sit empty, RevPAR will be depressed. A healthy revenue strategy seeks to grow RevPAR by balancing both factors. These three metrics form the foundation of every revenue management decision you will study in this course.

Key terms8

Occupancy PercentageThe share of available rooms that were sold during a given period, calculated as rooms sold divided by rooms available, multiplied by 100.
Average Daily Rate (ADR)The average room revenue earned per occupied room, calculated as total room revenue divided by the number of rooms sold.
Revenue Per Available Room (RevPAR)A combined performance metric equal to room revenue divided by rooms available, or equivalently ADR multiplied by occupancy percentage expressed as a decimal.
Rooms AvailableThe total number of guest rooms a property could sell during a given period; the denominator used in occupancy and RevPAR calculations.
Room RevenueRevenue generated solely from the sale of guest rooms, excluding food, beverage, parking, or other ancillary charges.
Daily Revenue ReportAn internal hotel document summarizing key operational and financial figures for a single day, typically produced by the night audit; also called a daily flash report.
Out-of-Order RoomA guest room temporarily removed from the saleable inventory due to maintenance or repair; depending on property policy, may be excluded from the rooms-available count.
Night AuditThe end-of-day accounting process that reconciles room charges, verifies room status, and produces the daily revenue report used for metric calculations.

Worked examples4

1. A 150-room hotel sold 117 rooms on a Tuesday night and collected $14,157 in room revenue. Calculate the occupancy percentage.
  1. Identify the values: Rooms Sold = 117; Rooms Available = 150.
  2. Apply the formula: Occupancy % = (Rooms Sold ÷ Rooms Available) × 100.
  3. Divide: 117 ÷ 150 = 0.78.
  4. Multiply by 100: 0.78 × 100 = 78.0%.
Answer: Occupancy = 78.0%
2. Using the same hotel data (117 rooms sold, $14,157 room revenue), calculate the ADR.
  1. Identify the values: Room Revenue = $14,157; Rooms Sold = 117.
  2. Apply the formula: ADR = Room Revenue ÷ Rooms Sold.
  3. Divide: $14,157 ÷ 117 = 121.0.
  4. Round to two decimal places: $121.00.
Answer: ADR = $121.00
3. Using the same hotel data (150 rooms available, $14,157 room revenue, ADR $121.00, occupancy 78.0%), calculate RevPAR using both formulas and confirm they match.
  1. Formula A: RevPAR = ADR × (Occupancy % ÷ 100) = $121.00 × (78.0 ÷ 100) = $121.00 × 0.78 = $94.38.
  2. Formula B: RevPAR = Room Revenue ÷ Rooms Available = $14,157 ÷ 150 = $94.38.
  3. Both formulas yield the same result; round to two decimal places: $94.38.
Answer: RevPAR = $94.38
4. A 200-room hotel reports the following for a Saturday: rooms sold = 186, room revenue = $37,572. A student calculated RevPAR as $37,572 ÷ 186 = $202.00. Identify and correct the error.
  1. Examine the denominator used: the student divided by 186 (rooms sold), which is the ADR formula, not RevPAR.
  2. RevPAR requires dividing by rooms *available*, not rooms sold.
  3. Correct calculation: RevPAR = $37,572 ÷ 200 = $187.86.
  4. For reference, the correct ADR = $37,572 ÷ 186 = $202.00, which is what the student accidentally calculated.
Answer: RevPAR = $187.86 (the student used rooms sold instead of rooms available in the denominator)

The math in this lesson2

Learners compute ADR and RevPAR as unit rates of revenue per room.
6.RP.27.RP.3
Brush up in the math halls at newSchoolWorks.com:
In class: Instructor demonstrates each formula step-by-step using a projected sample daily report; students follow along calculating values on provided worksheets. · Students work in pairs to complete a 20-row spreadsheet lab in which they calculate occupancy, ADR, and RevPAR for a simulated 7-day period using provided rooms-sold and revenue figures. · Students identify and correct three intentionally embedded formula errors in a peer group's completed spreadsheet, then explain the correction in writing.
Materials: Spreadsheet software (Google Sheets or Excel), printed and digital sample daily revenue reports, AHLEI formula reference card, calculators
Check: Scored spreadsheet lab: all 20 calculations must be within rounding tolerance; score of 80% or higher (16/20 correct) required to advance.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Rooms Division Operations
1. A hotel has 80 rooms available and sold 60 of them last night. What is the occupancy percentage?
Hospitality Accounting and Revenue Management
2. Which of the following correctly states the formula for Average Daily Rate (ADR)?
Hospitality Accounting and Revenue Management
3. A 200-room property earned $18,400 in room revenue and sold 160 rooms. What is the RevPAR?
Hospitality Accounting and Revenue Management
4. A hotel's ADR is $130.00 and its occupancy is 85%. Using the ADR-based RevPAR formula, what is RevPAR?
Hospitality Accounting and Revenue Management
5. Why is RevPAR considered a more complete performance indicator than ADR alone?
Hospitality Accounting and Revenue Management
6. A student divides total room revenue by rooms sold and labels the result 'RevPAR.' What error has been made?
Hospitality Accounting and Revenue Management
7. A hotel's daily report shows: rooms available = 250, rooms sold = 200, room revenue = $28,000. Which of the following best explains why a RevPAR calculated as $140.00 is incorrect?
Hospitality Industry Ethics and Professionalism
8. During the lab, you find a formula error in a peer group's spreadsheet. What is the professionally appropriate first step?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.