Objective. Students will correctly calculate occupancy percentage, Average Daily Rate, and Revenue Per Available Room using sample hotel data.
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.
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.
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 (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.
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.
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.
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.
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.
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.
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.
Answer each question, then check it. Nothing is recorded; this is your own practice.
A free tech program — complimentary, as our commitment to get America working. Help us build VoTechWorks. Tell us what works, what doesn’t, and what you want to learn.