Hotel Management Reports and Formulas

Internal Management Report

A detailed operational report covering a specific time period for a specific product, customer, department, or entire hotel

Performance Reports

Internal management reports that record actual historical operational results for the previous day, week, or month

Planning Reports

Internal management reports that contain forecasts and information required to plan revenues, expenses, and staffing for upcoming periods

Daily Revenue Report

A report prepared during the night audit shift that details daily and month-to-date actual revenues, room statistics (RevPAR, ADR, Occupancy %), and restaurant summaries

Daily Labor Productivity Report

A daily report that combines both revenue and labor cost data in a single report, allowing managers to adjust schedules and control operational costs

Man-Hour

The number of hours one employee works in performing their job responsibilities (measures labor productivity in units without dollar costs)

Man-Hours per Room Sold Formula

Total Man-Hours Worked / Total Rooms Sold

Rooms Cleaned per Shift Formula

Total Rooms Cleaned / One 8-Hour Shift

Man-Hours per Customer Formula

Total Man-Hours Used / Total Customers Served

Total Wage Cost ($) Formula

Total Man-Hours Worked · Average Hourly Wage Rate

Wage Cost per Occupied Room Formula

Total Wage Cost ($) / Total Rooms Occupied (Sold)

Departmental Wage Cost Percentage Formula

(Total Departmental Wage Cost in $ / Total Departmental Revenue in $) · 100

Weekly Revenue Forecast

A weekly planning report that projects daily rooms sold, arrivals, departures, average room rates, and daily room revenues

Weekly Wage and Cost Scheduling Report

A weekly report that uses the revenue forecast to schedule appropriate employee man-hours and wage costs

Management Planning vs. Operating Rule

While hotel operations are managed daily, they are planned and scheduled weekly

Monthly P&L Statement Report

A monthly report summarizing departmental revenues, expenses, and profits, comparing actual results against budget and prior periods