Calima - Executive BI Dashboards with One Governed Set of Hotel and Restaurant KPIs

Group overview, daily pulse, scorecard, property detail with 7 tabs and variance and commentary. Every one of the 26 demo properties opens its own detail page.

Each with its formula, version, sensitivity and green and amber tolerance bands, from RevPAR and ADR on STR definitions to GOP margin on the client's USALI 12th edition mapping.

A variance to budget needs an explanation when it breaches both limits. Commentary moves from required to requested, drafted, submitted and approved, or is sent back or marked not required with a reason.

14 hotels across two brands and 12 Sal y Lava restaurants in the Canary Islands and on the mainland, with 18 commentary items, 10 alerts and 10 events such as a 60-room renovation.

Ratios That Do Not Add Up

Occupancy is rooms sold over rooms available, ADR is rooms revenue over rooms sold and RevPAR is rooms revenue over rooms available. Averaging property percentages gives the wrong group figure, and out-of-order and complimentary rooms have to be counted the way the benchmarking provider does.

Two Regions, Two Clocks, Two Taxes

The Canary Islands run one hour behind the mainland, so yesterday closes at a different time per property. Revenue must always be net of indirect tax, IGIC in the Canaries and IVA on the mainland, and never mix gross and net figures.

Restricted Figures Without Leaks

Labour, GOP and payroll were emailed as attachments with no record of who opened them. Under GDPR and the LOPDGDD, labour metrics for very small teams can reveal one person's pay, and logging who views financials is employee monitoring that staff must be told about.

Variances Nobody Owned

Large misses against budget reached the board without an explanation, or with one written after the meeting. Renovations, strikes and flight cuts that moved the numbers lived in email, so nobody could see later why a month looked the way it did.