Loading...
HomeMy WebLinkAbout03. Custom_RNA_and_RNB_RAO_Report_Vail_02-28-2023RAW DATA ACTIVITY REPORT SECTION 1 - 12 MONTH ROLLING SUMMARY GRAPHS 2022/23 YTD (as of February 28, 2023) vs. 2021/22 YTD (as of February 28, 2022) vs. 2021/22 Historical CONFIDENTIAL INFORMATION: Reproduction or Further Distribution Prohibited Period: Bookings as of April 30, 2007 Historic months total Destination: Vail 0. 4 % 0. 3 % -0. 4 % -1. 8 % -3. 3 % -3. 6 % -2. 9 % -4. 1 % -6. 2 % -3. 3 % -4. 3 % 0. 6 % 3. 9 % -10 . 1 % -5. 4 % -9. 0 % 3. 5 % -1. 3 % -4. 6 % -27 . 4 % 5. 0 % -22 . 8 % -26 . 2 % -5. 6 % 5. 5 % -2. 5 % -8. 0 % -9. 0 % 12 . 0 % 7. 3 % -6. 8 % -18 . 1 % -16 . 5 % -15 . 3 % -20 . 4 % -2. 2 % -100.0% -80.0% -60.0% -40.0% -20.0% 0.0% 20.0% 40.0% 60.0% 80.0% 100.0% Sep-22 vs. Sep- 21 Oct-22 vs. Oct- 21 Nov-22 vs. Nov- 21 Dec-22 vs. Dec- 21 Jan-23 vs. Jan- 22 Feb-23 vs. Feb- 22 Mar-23 vs. Mar-22 Apr-23 vs. Apr- 22 May-23 vs. May-22 Jun-23 vs. Jun- 22 Jul-23 vs. Jul-22 Aug-23 vs. Aug- 22 % C h a n g e O c c u p / A D R Chart 1d -% Change in YTD RNA, RNB, and Revenue Percent Change in RNA Percent Change in RNB Percent Change in Revenue $1 1 , 2 4 6 , 3 5 9 $6 , 1 9 9 , 4 1 4 $6 , 5 0 8 , 0 4 5 $34 , 3 3 3 , 0 6 7 $3 8 , 6 8 9 , 0 6 5 $44 , 0 0 0 , 6 9 3 $37 , 0 3 5 , 6 7 1 $5, 2 2 1 , 8 2 4 $1 , 3 7 9 , 3 5 6 $5 , 7 6 1 , 0 7 3 $6 , 9 2 6 , 8 5 8 $4, 2 5 6 , 8 1 7 $1 0 , 6 6 1 , 2 3 7 $6, 3 6 1 , 6 2 6 $7, 0 7 1 , 4 8 1 $37 , 7 1 7 , 6 8 8 $3 4 , 5 4 4 , 5 8 3 $4 1 , 0 0 4 , 4 8 8 $3 9 , 7 4 3 , 3 0 5 $6, 3 7 6 , 5 6 6 $1 , 6 5 1 , 2 3 4 $6, 8 0 4 , 4 9 9 $8, 7 0 5 , 8 7 2 $4, 3 5 0 , 5 7 0 ($50,000,000) ($30,000,000) ($10,000,000) $10,000,000 $30,000,000 $50,000,000 $70,000,000 September October November December January February March April May June July August Chart 1c -Revenue Booked CY Room Revenue PY Room Revenue 72 , 7 5 4 75 , 7 5 4 72 , 8 6 6 75 , 0 4 7 73 , 2 6 1 66 , 3 3 1 73 , 4 6 9 71 , 0 4 9 70 , 6 7 7 70 , 7 4 2 70 , 7 8 1 65 , 0 7 2 72 , 4 5 7 75 , 5 1 3 73 , 1 7 8 76 , 4 4 1 75 , 7 4 7 68 , 7 7 3 75 , 6 5 1 74 , 0 6 8 75 , 3 5 4 73 , 1 8 4 73 , 9 2 5 64 , 6 6 0 0 20,000 40,000 60,000 80,000 100,000 September October November December January February March April May June July August Chart 1a -Room Nights Availble CY Room Night Avail PY Room Night Avail 36 , 5 3 5 23 , 7 8 0 20 , 9 3 7 43 , 4 2 6 50 , 9 9 8 52 , 2 7 5 47 , 9 5 1 12 , 2 8 7 7, 0 9 3 16 , 6 5 5 16 , 8 2 3 10 , 5 2 6 35 , 1 5 5 26 , 4 6 2 22 , 1 2 3 47 , 7 1 2 49 , 2 5 4 52 , 9 8 5 50 , 2 7 0 16 , 9 3 5 6, 7 5 7 21 , 5 6 8 22 , 8 0 2 11 , 1 5 6 (30,000) (20,000) (10,000) - 10,000 20,000 30,000 40,000 50,000 60,000 70,000 September October November December January February March April May June July August Chart 1b -Room Nights Booked CY Room Night Booked PY Room Night Booked 3/10/2023 © 2023 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 (2022/23 & 2021/22)Avail Booked Avail Booked RNA RNB September 72,754 36,535 72,457 35,155 0.4%3.9% October 75,754 23,780 75,513 26,462 0.3%-10.1% November 72,866 20,937 73,178 22,123 -0.4%-5.4% December 75,047 43,426 76,441 47,712 -1.8%-9.0% January 73,261 50,998 75,747 49,254 -3.3%3.5% February Historic Actual 66,331 52,275 68,773 52,985 -3.6%-1.3% March On the Books 73,469 47,951 75,651 50,270 -2.9%-4.6% April 71,049 12,287 74,068 16,935 -4.1%-27.4% May 70,677 7,093 75,354 6,757 -6.2%5.0% June 70,742 16,655 73,184 21,568 -3.3%-22.8% July 70,781 16,823 73,925 22,802 -4.3%-26.2% August 65,072 10,526 64,660 11,156 0.6%-5.6% Grand total 857,803 339,286 878,951 363,179 -2.4%-6.6% Historic months total 436,013 227,951 442,109 233,691 -1.4%-2.5% On the Books months total 421,790 111,335 436,842 129,488 -3.4%-14.0% AVERAGE DAILY RATE CY CY PY PY Percent Percent Room Night Room Room Night Room Change in Change in Month of Occupancy (2022/23 & 2021/22)Booked Revenue Booked Revenue RNA RNB September 36,535 $11,246,359 35,155 $10,661,237 3.9%5.5% October 23,780 $6,199,414 26,462 $6,361,626 -10.1%-2.5% November 20,937 $6,508,045 22,123 $7,071,481 -5.4%-8.0% December 43,426 $34,333,067 47,712 $37,717,688 -9.0%-9.0% January 50,998 $38,689,065 49,254 $34,544,583 3.5%12.0% February Historic Actual 52,275 $44,000,693 52,985 $41,004,488 -1.3%7.3% March On the Books 47,951 $37,035,671 50,270 $39,743,305 -4.6%-6.8% April 12,287 $5,221,824 16,935 $6,376,566 -27.4%-18.1% May 7,093 $1,379,356 6,757 $1,651,234 5.0%-16.5% June 16,655 $5,761,073 21,568 $6,804,499 -22.8%-15.3% July 16,823 $6,926,858 22,802 $8,705,872 -26.2%-20.4% August 10,526 $4,256,817 11,156 $4,350,570 -5.6%-2.2% Grand total 339,286 $201,558,244 363,179 $204,993,149 -6.6%-1.7% Historic months total 227,951 $140,976,644 233,691 $137,361,103 -2.5%2.6% On the Books months total 111,335 $60,581,600 129,488 $67,632,046 -14.0%-10.4% REVENUE PER AVAILABLE ROOM CY CY PY PY Percent Percent Room Night Room Room Night Room Change in Change in Month of Occupancy (2022/23 & 2021/22)Available Revenue Available Revenue RNA Revenue September 72,754 $11,246,359 72,457 $10,661,237 0.4%5.5% October 75,754 $6,199,414 75,513 $6,361,626 0.3%-2.5% November 72,866 $6,508,045 73,178 $7,071,481 -0.4%-8.0% December 75,047 $34,333,067 76,441 $37,717,688 -1.8%-9.0% January 73,261 $38,689,065 75,747 $34,544,583 -3.3%12.0% February Historic Actual 66,331 $44,000,693 68,773 $41,004,488 -3.6%7.3% March On the Books 73,469 $37,035,671 75,651 $39,743,305 -2.9%-6.8% April 71,049 $5,221,824 74,068 $6,376,566 -4.1%-18.1% May 70,677 $1,379,356 75,354 $1,651,234 -6.2%-16.5% June 70,742 $5,761,073 73,184 $6,804,499 -3.3%-15.3% July 70,781 $6,926,858 73,925 $8,705,872 -4.3%-20.4% August 65,072 $4,256,817 64,660 $4,350,570 0.6%-2.2% Grand total 857,803 $201,558,244 878,951 $204,993,149 -2.4%-1.7% Historic months total 436,013 $140,976,644 442,109 $137,361,103 -1.4%2.6% On the Books months total 421,790 $60,581,600 436,842 $67,632,046 -3.4%-10.4% ROOM NIGHTS AVAILABLE AND REVENUE Bookings as of February 28, 2023 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 3/10/2023 © 2023 Sterling Valley Systems, Inc. All rights reserved. Confidential Information not for reproduction and protected by law. DestiMetrics@Inntopia.com www.DestiMetrics.com 2