Dynamic Hotel USAH Profit & Loss Statement

Description
Dynamic Hotel USAH Profit & Loss Report:


This report will enable you to track your monthly Hotel Profit & Loss reports to see Actual / Forecast performance vs Budget for both Month to Date and Year to Date.


The USAH Profit & Loss report also includes key ratios as below:


- Rooms Available
- Rooms Occupied
- Occupancy Percentage
- Average House Rate (AHR)
- Revenue Per Available Room (RevPAR)
- Rooms Profitability Percentage
- Food & Beverage Profitability Percentage
- Other Operating Department Profitability Percentage
- Energy Costs Per Available Room
- Energy Costs Per Occupied Room
- Gross Operating Profit Percentage
- EBITDAR Percentage
- EBT Percentage
- Net Operating Profit Percentage 


Visual graphs will aid to see business trends and help with key decision making.


This template is simple and easy to use with following steps below:


- Input Actuals / Forecast: In this sheet input your monthly actuals or forecast
- Input Budget: In this sheet input your monthly budget
- Dynamic USAH Report: Simply select the month from the drop down list to instantly see your Hotel P & L for the month to date as well as year to date
- Graphs dashboard: Covers visuals for key amounts and figures such as revenues and ratios as below:


- 1st Graph: Toggle from drop down list to view the below:
Rooms Revenue
F & B Revenue
M & E Revenue
OOD Revenue
Total Revenue
AHR
RevPAR  



- 2nd Graph: Toggle from drop down list to view the below:
Occupancy 
Rooms Profit
F & B Profit
OOD Profit
GOP
EBITDAR
EBT
NOP


Sit back.. Relax and get on top of your Hotel Financial performance!