Ferdinando MercuriManagement control

Tool

KPI calculator for hotels, campsites and B&Bs

Enter the data for a period and get GOPPAR, RevPAR, ADR, occupancy and the other indicators straight away. The calculation runs only in your browser: no data is sent anywhere.

How to use it

  1. Choose the property type: for campsites and B&Bs “rooms” become “units”.
  2. Enter the data for a period (last season or last year), net of VAT.
  3. Tap the “f” next to each result to see the formula.
Property type

Results

Occupancy
—
ADR
—
RevPAR
—
TRevPAR
—
GOP
—
GOP margin
—
GOPPAR
—
CPOR
—
Payroll / revenue
—

Indicative calculation, for illustration only. The pre-filled values are an example (60 rooms, 270 days).

Definitions

Occupancy
Rooms sold over rooms available= Rooms sold ÷ rooms available
ADR
Rooms revenue per room sold= Rooms revenue ÷ rooms sold
RevPAR
Rooms revenue per available room= Rooms revenue ÷ rooms available
TRevPAR
Total revenue per available room= Total revenue ÷ rooms available
GOP margin
GOP as a percentage of revenue= GOP ÷ total revenue
GOPPAR
GOP per available room= GOP ÷ rooms available
CPOR
Rooms costs per occupied room= Rooms department costs ÷ rooms sold
Payroll / revenue
Weight of labour cost= Payroll cost ÷ total revenue

Contact

Let's talk about your numbers

Tell me about your property or group: I'll explain how I can help and where it makes sense to start. The first meeting is free and without obligation: at your premises for properties in Lombardy, online via Microsoft Teams for other regions.

or controller.fm@outlook.com · Vertemate (CO)