jagomart
digital resources
picture1_Excel Sample Sheet 32910 | 2018 Kalibri Labs Geohipo Sample


 159x       Filetype XLSX       File size 0.25 MB       Source: www.kalibrilabs.com


File: Excel Sample Sheet 32910 | 2018 Kalibri Labs Geohipo Sample
sheet 1 summary august hotel industry performance overview sample market august 18 direct bookings 434 33 yoy indirect bookings 436 37 yoy group bookings yoy 3404 14 yoy 188 05 ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Summary - August

Hotel Industry Performance Overview - Sample Market
August '18





































DIRECT BOOKINGS





43.4% 3.3%









YOY


INDIRECT BOOKINGS





43.6% 3.7%



YOY















































GROUP BOOKINGS
































YOY






34.04 -1.4%

YOY













1.88 -0.5%



YOY







79.6% -1.0%
YOY










Sheet 2: Summary - YTD

Hotel Industry Performance Overview - Sample Market
2018 YTD (January - August)





































DIRECT BOOKINGS





42.9% -1.6%









YOY


INDIRECT BOOKINGS





40.4% 1.6%



YOY





















































GROUP BOOKINGS






























YOY






31.84 +3.2%

YOY













1.91 +1.3%


YOY








80.6% -0.7%
YOY



















Sheet 3: Trend
Monthly Hotel Industry Performance Overview - 12 Month Trend - Sample Market













Aug 2018 Analysis








































Occupancy & Loyalty Contribution






























Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18
TTM - Aug 2018

Occupancy 89.3% 89.1% 88.7% 89.3% 77.7% 80.7% 88.2% 88.2% 91.1% 90.8% 90.8% 88.7%
87.7%

Loyalty Contribution 42.2% 43.5% 45.1% 45.7% 44.2% 44.5% 44.4% 45.0% 44.5% 46.8% 44.2% 44.6%
44.6%

Loyalty Contribution 37.69% 38.72% 40.04% 40.84% 34.35% 35.94% 39.15% 39.74% 40.50% 42.56% 40.18% 39.57%
39.11%

Non Loyalty 51.61% 50.35% 48.66% 48.47% 43.35% 44.74% 49.09% 48.49% 50.60% 48.28% 50.64% 49.09%
48.63%

ADR & RevPAR


































Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18
TTM - Aug 2018

Guest-Paid ADR $313.39 $305.37 $282.80 $298.71 $192.05 $188.04 $241.32 $262.50 $286.76 $278.69 $246.63 $240.09
$263.31

Hotel Collected ADR $303.69 $295.33 $274.23 $287.43 $186.55 $182.39 $234.52 $254.22 $277.49 $270.47 $238.02 $231.04
$254.81

COPE ADR $284.46 $276.43 $256.72 $270.03 $174.21 $170.37 $219.92 $237.86 $259.62 $253.34 $223.28 $216.19
$238.63

Guest-Paid RevPAR $279.87 $271.99 $250.86 $266.77 $149.24 $151.70 $212.93 $231.60 $261.25 $253.15 $223.99 $212.87
$231.04

Hotel-Collected RevPAR $271.21 $263.05 $243.26 $256.70 $144.96 $147.15 $206.93 $224.30 $252.80 $245.69 $216.17 $204.84
$223.59

COPE RevPAR $254.03 $246.21 $227.73 $241.16 $135.37 $137.45 $194.04 $209.86 $236.52 $230.13 $202.78 $191.67
$209.39



































COPE % & Booking Costs per RN


































Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18
TTM - Aug 2018

COPE % 90.8% 90.5% 90.8% 90.4% 90.7% 90.6% 91.1% 90.6% 90.5% 90.9% 90.5% 90.0%
90.6%

Booking Cost / RN $28.93 $28.94 $26.08 $28.68 $17.84 $17.67 $21.40 $24.64 $27.14 $25.35 $23.36 $23.90
$24.68





































































Room Night Demand Share by Channel





















































































































Loyalty















Non Loyalty











































































































































































































Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18
TTM - Aug 2018

Transient Direct 41.56% 42.61% 44.33% 47.37% 43.78% 41.98% 42.56% 41.29% 41.96% 44.85% 43.51% 43.41%
43.29%

Brand.com 21.31% 21.92% 23.79% 26.46% 23.24% 22.78% 22.15% 22.54% 22.96% 24.76% 23.76% 23.70%
23.29% SB10
Voice 7.11% 7.57% 7.78% 8.66% 6.44% 6.30% 7.25% 6.86% 7.18% 7.96% 7.64% 7.36%
7.37% SB40
Property Direct 13.13% 13.11% 12.76% 12.24% 14.10% 12.89% 13.15% 11.89% 11.82% 12.14% 12.10% 12.35%
12.63% SB50

















Transient Indirect 38.84% 39.64% 38.34% 41.40% 40.35% 42.43% 37.42% 40.62% 41.23% 37.90% 40.31% 43.56%
40.14%

OTA 23.75% 23.45% 22.79% 28.13% 23.90% 24.74% 21.88% 24.49% 25.32% 22.32% 25.53% 27.88%
24.52% SB20
GDS 11.99% 13.06% 12.61% 9.38% 13.79% 14.40% 12.23% 12.88% 12.68% 12.95% 10.95% 11.38%
12.31% SB30
FIT / Wholesale 3.11% 3.13% 2.95% 3.90% 2.65% 3.29% 3.32% 3.25% 3.22% 2.63% 3.84% 4.31%
3.31% SB60

















Group 19.60% 17.75% 17.32% 11.23% 15.87% 15.60% 20.01% 18.09% 16.81% 17.24% 16.18% 13.03%
16.57% SB70


































Other National Metrics


















































Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18
TTM - Aug 2018

Avg. Length of Stay (Days) 2.10 2.06 2.05 2.05 2.04 2.06 2.11 2.09 2.09 2.01 2.12 2.02
2.07

Avg. Booking Lead Time (Days) 36.6 36.0 37.6 44.0 27.5 26.5 29.7 33.6 37.7 35.2 35.2 35.3
34.8

Global Review Index % 79.9% 79.5% 80.3% 80.7% 81.2% 82.1% 81.1% 80.9% 79.9% 80.1% 79.6% 79.6%
80.4%



The words contained in this file might help you see if this file matches what you are looking for:

...Sheet summary august hotel industry performance overview sample market direct bookings yoy indirect group ytd january trend monthly month aug analysis occupancy amp loyalty contribution sep oct nov dec jan feb mar apr may jun jul ttm non adr revpar guestpaid collected cope hotelcollected booking costs per rn cost room night demand share by channel transient brandcom sb voice...

no reviews yet
Please Login to review.