Loading...
HomeMy WebLinkAbout07. Custom_RNA_and_RNB_RAO_Report_Vail_08-31-2020RAW DATA ACTIVITY REPORT SECTION 1 - 12 MONTH ROLLING SUMMARY GRAPHS 2020/21 YTD (as of August 31, 2020) vs. 2019/20 YTD (as of August 31, 2019) vs. 2019/20 Historical CONFIDENTIAL INFORMATION: Reproduction or Further Distribution Prohibited Period: Bookings as of April 30, 2007 Historic months total Destination: Vail 0.7%1.1%1.0%-3.6%0.5%-2.7%-3.9%-0.8%1.2%0.4%0.8%-4.2%-54.5%-95.1%-79.1%-71.5%-29.0%-14.0%-35.8%-53.8%0.3%-37.0%-42.7%-50.5%-54.2%-98.0%-83.2%-73.4%-27.5%-14.5%-27.3%-46.5%2.3%-45.3%-48.2%-51.9%-150.0% -130.0% -110.0% -90.0% -70.0% -50.0% -30.0% -10.0% 10.0% 30.0% 50.0% Mar-20 vs. Mar-19 Apr-20 vs. Apr- 19 May-20 vs. May-19 Jun-20 vs. Jun- 19 Jul-20 vs. Jul-19Aug-20 vs. Aug- 19 Sep-20 vs. Sep- 19 Oct-20 vs. Oct- 19 Nov-20 vs. Nov-19 Dec-20 vs. Dec- 19 Jan-21 vs. Jan- 20 Feb-21 vs. Feb- 20% Change Occup / ADRChart 1d -% Change in YTD RNA, RNB, and Revenue Percent Change in RNA Percent Change in RNB Percent Change in Revenue$14,407,281 $110,311 $406,996 $2,196,033 $9,410,134 $9,942,743 $4,717,947 $1,242,419 $1,195,749 $6,657,084 $5,513,901 $4,921,880 $31,451,744 $5,621,121 $2,415,763 $8,262,529 $12,981,208 $11,633,023 $6,491,900 $2,321,280 $1,169,199 $12,164,413 $10,650,049 $10,241,067 ($35,000,000) ($25,000,000) ($15,000,000) ($5,000,000) $5,000,000 $15,000,000 $25,000,000 $35,000,000 March April May June July August September October November December January February Chart 1c -Revenue Booked CY Room Revenue PY Room Revenue80,465 74,535 72,371 70,772 74,105 75,365 72,850 74,168 73,291 77,592 77,852 70,189 79,887 73,733 71,650 73,445 73,738 77,472 75,800 74,795 72,403 77,274 77,222 73,290 0 20,000 40,000 60,000 80,000 100,000 March April May June July August September October November December January February Chart 1a -Room Nights Availble CY Room Night Avail PY Room Night Avail 25,353 1,121 3,051 10,548 33,967 37,452 18,611 6,005 4,757 10,804 10,065 8,625 55,763 22,966 14,592 36,983 47,868 43,545 28,968 12,994 4,743 17,142 17,559 17,410 (60,000) (40,000) (20,000) - 20,000 40,000 60,000 80,000 March April May June July August September October November December January February Chart 1b -Room Nights Booked CY Room Night Booked PY Room Night Booked 9/9/2020 © 2020 Sterling Valley Systems, Inc. All rights reserved. Confidential Information not for reproduction and protected by law. DestiMetrics@Inntopia.com www.DestiMetrics.com 1 OCCUPANCY RATE CY CY PY PY Percent Percent Room Night Room Night Room Night Room Night Change in Change in Month of Occupancy (2020/21 & 2019/20)Avail Booked Avail Booked RNA RNB March 80,465 25,353 79,887 55,763 0.7%-54.5% April 74,535 1,121 73,733 22,966 1.1%-95.1% May 72,371 3,051 71,650 14,592 1.0%-79.1% June 70,772 10,548 73,445 36,983 -3.6%-71.5% July 74,105 33,967 73,738 47,868 0.5%-29.0% August Historic Actual 75,365 37,452 77,472 43,545 -2.7%-14.0% September On the Books 72,850 18,611 75,800 28,968 -3.9%-35.8% October 74,168 6,005 74,795 12,994 -0.8%-53.8% November 73,291 4,757 72,403 4,743 1.2%0.3% December 77,592 10,804 77,274 17,142 0.4%-37.0% January 77,852 10,065 77,222 17,559 0.8%-42.7% February 70,189 8,625 73,290 17,410 -4.2%-50.5% Grand total 893,555 170,359 900,709 320,533 -0.8%-46.9% Historic months total 447,613 111,492 449,925 221,717 -0.5%-49.7% On the Books months total 445,942 58,867 450,784 98,816 -1.1%-40.4% AVERAGE DAILY RATE CY CY PY PY Percent Percent Room Night Room Room Night Room Change in Change in Month of Occupancy (2020/21 & 2019/20)Booked Revenue Booked Revenue RNA RNB March 25,353 $14,407,281 55,763 $31,451,744 -54.5%-54.2% April 1,121 $110,311 22,966 $5,621,121 -95.1%-98.0% May 3,051 $406,996 14,592 $2,415,763 -79.1%-83.2% June 10,548 $2,196,033 36,983 $8,262,529 -71.5%-73.4% July 33,967 $9,410,134 47,868 $12,981,208 -29.0%-27.5% August Historic Actual 37,452 $9,942,743 43,545 $11,633,023 -14.0%-14.5% September On the Books 18,611 $4,717,947 28,968 $6,491,900 -35.8%-27.3% October 6,005 $1,242,419 12,994 $2,321,280 -53.8%-46.5% November 4,757 $1,195,749 4,743 $1,169,199 0.3%2.3% December 10,804 $6,657,084 17,142 $12,164,413 -37.0%-45.3% January 10,065 $5,513,901 17,559 $10,650,049 -42.7%-48.2% February 8,625 $4,921,880 17,410 $10,241,067 -50.5%-51.9% Grand total 170,359 $60,722,480 320,533 $115,403,296 -46.9%-47.4% Historic months total 111,492 $36,473,499 221,717 $72,365,388 -49.7%-49.6% On the Books months total 58,867 $24,248,980 98,816 $43,037,908 -40.4%-43.7% REVENUE PER AVAILABLE ROOM CY CY PY PY Percent Percent Room Night Room Room Night Room Change in Change in Month of Occupancy (2020/21 & 2019/20)Available Revenue Available Revenue RNA Revenue March 80,465 $14,407,281 79,887 $31,451,744 0.7%-54.2% April 74,535 $110,311 73,733 $5,621,121 1.1%-98.0% May 72,371 $406,996 71,650 $2,415,763 1.0%-83.2% June 70,772 $2,196,033 73,445 $8,262,529 -3.6%-73.4% July 74,105 $9,410,134 73,738 $12,981,208 0.5%-27.5% August Historic Actual 75,365 $9,942,743 77,472 $11,633,023 -2.7%-14.5% September On the Books 72,850 $4,717,947 75,800 $6,491,900 -3.9%-27.3% October 74,168 $1,242,419 74,795 $2,321,280 -0.8%-46.5% November 73,291 $1,195,749 72,403 $1,169,199 1.2%2.3% December 77,592 $6,657,084 77,274 $12,164,413 0.4%-45.3% January 77,852 $5,513,901 77,222 $10,650,049 0.8%-48.2% February 70,189 $4,921,880 73,290 $10,241,067 -4.2%-51.9% Grand total 893,555 $60,722,480 900,709 $115,403,296 -0.8%-47.4% Historic months total 447,613 $36,473,499 449,925 $72,365,388 -0.5%-49.6% On the Books months total 445,942 $24,248,980 450,784 $43,037,908 -1.1%-43.7% ROOM NIGHTS AVAILABLE AND REVENUE Bookings as of August 31, 2020 SECTION 2 - 12 MONTH ROLLING SUMMARY GRAPHS RESERVATIONS ACTIVITY CONTEXT REPORT CONFIDENTIAL INFORMATION: Reproduction or Further Distribution Prohibited Destination: Vail ROOM NIGHTS AVAILABLE AND BOOKED ROOM NIGHTS BOOKED AND REVENUE 9/9/2020 © 2020 Sterling Valley Systems, Inc. All rights reserved. Confidential Information not for reproduction and protected by law. DestiMetrics@Inntopia.com www.DestiMetrics.com 2