---
name: doluluk-adr-revpar
description: "Use when a daily occupancy, ADR and RevPAR analysis is requested from daily available rooms, revenue-generating rooms sold and net room revenue. Produce a formula-based Excel file and a Word summary."
---

# Daily occupancy, ADR and RevPAR

Is the change in room revenue accompanied by occupancy or by revenue per room sold?

## Input and scope

Daily available rooms, revenue-generating rooms sold and net room revenue.

Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Map synonymous column headers against the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be read in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the outputs. Use the sample only when the user wants to try it with the sample data.

## Analysis

1. Count by stay date. Verify available capacity and the definitions of complimentary, house use and out-of-order rooms from the report. In the sample, the occupancy numerator is revenue-generating rooms sold.

2. ADR = net room revenue / rooms sold. RevPAR = net room revenue / available rooms. Keep the VAT, board and package split consistent across periods. Leave a ratio blank when its denominator is zero.

3. Calculate period ratios as total numerator / total denominator. Report capacity changes separately. Report occupancy in percentage points, and rate and revenue differences in currency.

## Delivery and checks

On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file named Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidence-backed findings and the follow-up the responsible team will check. Reopen both files; independently check the numbers, the denominators of ratios and the source totals. Do not present unverifiable causes as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Date, Occupancy, ADR (TL), RevPAR (TL).

## Try it with the sample

Use the file assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Sample-specific check: Occupancy stayed at 75% on 19 and 20 November. RevPAR rose from 2,400 TL to 2,475 TL.
