🚧 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 9
HOS-HOTE29-04 · Lesson 9 · 13 clock hours · lab

Revenue Management Technology and Reporting Tools

Objective. Students will navigate a simulated property management system revenue dashboard and generate a basic daily revenue report from entered 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.

What Revenue Management Technology Does

Modern hotels do not track revenue by hand. A Property Management System (PMS) is the central software platform that records every reservation, check-in, check-out, and room rate posted at a property. Within the PMS, a revenue dashboard pulls that raw transaction data together into summary views that managers can read at a glance. Understanding how to navigate these screens and generate accurate reports is a core skill for anyone working in hotel operations or supervision.

The three numbers you will see on almost every revenue screen are occupancy rate, Average Daily Rate (ADR), and Revenue Per Available Room (RevPAR). Occupancy rate tells you what percentage of available rooms were sold. ADR tells you the average price paid for each occupied room. RevPAR combines both by dividing total rooms revenue by the total number of available rooms, whether they were sold or not. Together, these three metrics give a complete picture of how well the property converted its room inventory into dollars.

Key Screens in a PMS Revenue Dashboard

Although every PMS looks a little different, the following screens appear in nearly all systems:

When you first open a revenue dashboard, confirm the date range displayed in the upper corner. A common error is generating a report for the wrong date or a partial day, which produces numbers that look plausible but are wrong.

Entering Data Accurately

In this lab you will enter one week of simulated occupancy and rate data into a training PMS or a structured spreadsheet dashboard. Accurate data entry is not just a classroom exercise — in a real property, a keying error can cause a manager to make a pricing decision based on false numbers, resulting in lost revenue or rooms sold below cost.

Follow these habits every time you enter data:

1. Read the field label before you type. ADR and RevPAR fields are different; entering ADR into the RevPAR column will cascade errors through every calculated cell.

2. Use the exact date format the system expects. PMS platforms are sensitive to date formats; an incorrect format may cause the record to post to the wrong day.

3. Double-check totals as you go. After entering each day's data, scan the row totals before moving to the next day.

4. Save frequently. In a live PMS, data is saved to a server automatically, but in a spreadsheet environment, unsaved work can be lost.

Generating a Daily Revenue Report

Once data is entered, you generate the report by selecting the correct date range and choosing the Daily Revenue Summary report type. The system compiles the figures and presents them in a standard layout that typically shows:

Export or print the report immediately after generation. Note the timestamp on the report — this tells any reader exactly when the data was pulled and whether it reflects a completed business day or a partial day.

Cross-Checking Against an Answer Key

After printing your report, compare every field to the provided answer key line by line. Do not skim. Mark any cell where your figure differs from the key. For each discrepancy, ask two questions: Where did the error enter the data? and What decision would a manager make incorrectly if this error went undetected?

For example, if your occupancy rate for Tuesday reads 72% but the answer key shows 78%, a manager relying on your report might incorrectly believe demand was softer than it was and drop rates for the following Tuesday, reducing revenue unnecessarily.

Data Integrity and Workplace Safety

Revenue data is confidential business information. In a real property, PMS access is controlled by login credentials, and you should never share your password or leave a revenue screen open and unattended — another employee or guest could view sensitive financial data. Log out of any system when you step away from the terminal.

In the lab environment, treat the simulated data with the same care. Do not photograph answer keys or share data sets with students in other sections, as doing so undermines the validity of the assessment for everyone.

There are no physical hazards in this particular lab, but ergonomic awareness applies: position your monitor at eye level, keep your wrists neutral when typing, and take short breaks if you are entering data for an extended period to avoid repetitive strain.

Why This Skill Matters for Your Career

Employers expect front desk representatives and supervisors to read a revenue report without confusion. When a department head walks in and asks why RevPAR dropped on Wednesday, you need to be able to open the PMS, pull the numbers, and explain what happened. Practicing data entry and report generation now — in a low-stakes training environment — builds the speed and accuracy you will need on the job.

Key terms8

Property Management System (PMS)The central hotel software platform that records reservations, check-ins, check-outs, and room charges, and from which revenue reports are generated.
Occupancy RateThe percentage of available rooms that were actually sold during a given period; calculated by dividing rooms occupied by rooms available.
Average Daily Rate (ADR)The average revenue earned per occupied room in a given period; calculated by dividing total rooms revenue by the number of rooms occupied.
Revenue Per Available Room (RevPAR)A key hotel performance metric calculated by dividing total rooms revenue by the total number of available rooms, whether occupied or not.
Daily Revenue SummaryA standard report generated from the PMS that lists rooms available, rooms occupied, occupancy rate, ADR, RevPAR, and total rooms revenue for each day in the selected date range.
Flash ReportA brief daily snapshot of key revenue metrics — typically occupancy, ADR, and RevPAR — used by managers to monitor performance at a glance and compare to prior periods.
Data IntegrityThe accuracy and consistency of data stored in a system; in revenue management, a single keying error can distort every calculated metric that depends on that value.
Rate and Inventory ScreenThe PMS screen showing which room types are open for sale and at what rates, allowing managers to open, close, or adjust pricing in real time.

Worked examples4

1. A hotel has 120 available rooms on a given night. Records show 90 rooms were occupied. What is the occupancy rate?
  1. Identify the formula: Occupancy Rate = Rooms Occupied ÷ Rooms Available × 100
  2. Substitute the values: 90 ÷ 120 = 0.75
  3. Multiply by 100 to convert to a percentage: 0.75 × 100 = 75%
Answer: Occupancy rate is 75%.
2. The same hotel with 90 occupied rooms collected total rooms revenue of $10,800 that night. What is the ADR?
  1. Identify the formula: ADR = Total Rooms Revenue ÷ Rooms Occupied
  2. Substitute the values: $10,800 ÷ 90 = $120
  3. Confirm the unit: the result is dollars per occupied room.
Answer: ADR is $120.00 per occupied room.
3. Using the same data (120 available rooms, total rooms revenue of $10,800), calculate RevPAR.
  1. Identify the formula: RevPAR = Total Rooms Revenue ÷ Rooms Available
  2. Substitute the values: $10,800 ÷ 120 = $90
  3. Alternative check: RevPAR can also be calculated as ADR × Occupancy Rate = $120 × 0.75 = $90. Both methods agree.
Answer: RevPAR is $90.00.
4. A student's report shows Tuesday ADR as $105, but the answer key shows $112. Total rooms revenue entered for Tuesday was $9,450 and rooms occupied was 90. Which figure is correct and what was the data-entry error?
  1. Calculate the correct ADR from the raw data: $9,450 ÷ 90 = $105.
  2. The answer key shows $112. Check whether the answer key uses a different rooms-occupied figure: $9,450 ÷ $112 ≈ 84.375 — not a whole number, so the revenue figure may differ in the key.
  3. Check the answer key's rooms revenue: if the key shows 84 rooms occupied, then ADR = $9,450 ÷ 84 = $112.50, still not matching. Re-examine: if the key revenue is $10,080 and occupied rooms are 90, then $10,080 ÷ 90 = $112 — a match.
  4. Conclusion: The student likely entered $9,450 instead of $10,080 for Tuesday's rooms revenue — a $630 keying error. This caused ADR to appear $7 lower than actual, which could lead a manager to believe rates were weaker than they were and make unnecessary rate cuts.
Answer: The answer key figure of $112 ADR is correct. The student entered the wrong revenue total ($9,450 instead of $10,080), producing an understated ADR and a misleading picture of rate performance.

The math in this lesson1

Learners divide 90 occupied rooms by 120 available for 75% occupancy from system reports.
7.RP.3
Brush up in the math halls at newSchoolWorks.com:
In class: Instructor demonstrates key revenue-related screens in a training PMS environment (simulated or demo version), showing how rooms revenue, occupancy, and ADR are displayed and exported. · Students enter one week of simulated occupancy and rate data into the training PMS or a structured spreadsheet template configured to replicate a PMS dashboard, then generate and print the resulting daily revenue summary. · Students cross-check their generated report against a provided answer key, identify any discrepancies, and write a brief explanation of what caused each error and how it would affect decision-making.
Materials: Training PMS demo environment or instructor-built spreadsheet dashboard, simulated occupancy and rate data set, printed answer key, spreadsheet software
Check: Generated report accuracy checked against answer key: 90% of data fields must be correct; written error analysis must correctly explain each identified discrepancy; both components must meet standard to pass.

Practice check8

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

Rooms Revenue Management
1. A hotel has 200 available rooms and 150 occupied rooms on a given night. What is the occupancy rate?
Rooms Revenue Management
2. A property records $18,000 in rooms revenue from 150 occupied rooms. What is the ADR?
Rooms Revenue Management
3. Using the same property data — 200 available rooms, $18,000 total rooms revenue — what is RevPAR?
Front Office Operations
4. When generating a daily revenue report in a PMS, what is the first thing a user should confirm before exporting the report?
Front Office Operations
5. A student's daily revenue report shows an ADR of $95 on Friday, but the answer key lists $102. Which action should the student take first?
Rooms Revenue Management
6. Why does an occupancy rate error in a Tuesday revenue report matter beyond just that single day's record?
Rooms Revenue Management
7. Which of the following best describes the purpose of the Rate and Inventory screen in a PMS?
Hospitality Supervision and Professionalism
8. A colleague leaves a revenue dashboard visible on an unattended terminal in the front office. What is the most important reason to log out of the system before walking away?
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.