Loading...
HomeMy Public PortalAboutFY23 Lodging LOT Revenue ProjectionsLODGING LOT ACTUAL PERCENTAGES AND FORECASTED DOLLARS Month FY18 FY19 FY20 FY21 FY22 Five year average FY23 Budget dollars FY23 Budget + Contingent dollars FY23 actual and forecast based on trend Percentage +/- based on budget Actual total Budget total total +/- YTD October 4.84%4.71%4.41%4.40%5.14%4.70%58,664 75,585 53,920 -8.09%53,920 58,664 -8.09% November 2.98%2.77%2.93%2.66%2.86%2.84%35,450 45,675 30,705 -13.38%84,625 94,114 -10.08% December 5.89%7.55%9.37%8.98%11.07%8.57%107,004 137,868 119,687 11.85%204,312 201,117 1.59% 1st Quarter Total 201,117 259,128 204,312 1.59% January 7.23%7.14%7.14%5.93%5.66%6.62%82,611 106,440 61,406 -25.67%265,718 283,729 -6.35% February 6.86%6.57%6.98%5.93%6.66%6.60%82,355 106,110 69,067 -16.14%334,785 366,084 -8.55% March 5.56%9.16%6.02%11.73%12.02%8.90%111,084 143,125 113,152 1.86%447,937 477,168 -6.13% 2nd Quarter Total 276,050 355,675 243,625 -11.75% April 2.77%2.46%0.51%2.65%2.54%2.19%27,271 35,137 23,801 -12.72%471,738 504,439 -6.48% May 4.49%4.29%2.72%4.23%3.79%3.90%48,707 62,756 39,144 -19.63%510,882 553,145 -7.64% June 10.39%13.37%13.50%14.43%14.22%13.18%164,504 211,954 142,028 -13.66%652,910 717,650 -9.02% 3rd Quarter Total 240,482 309,847 204,973 -14.77% July 18.19%15.80%15.37%13.80%14.80%15.59%194,585 250,712 141,561 -27.25%794,471 912,235 -12.91% August 15.82%13.77%14.51%12.14%12.99%13.85%172,804 222,648 110,103 -36.28%904,574 1,085,039 -16.63% September 14.97%12.40%16.55%13.13%14.02%14.22%177,422 228,598 149,621 -15.67%1,054,195 1,262,461 -16.50% 4th Quarter Total 544,812 701,959 401,285 -26.34% Total 0.00%100.00%100.00%100.00%100.00%100.00%1,262,461 1,626,609 1,054,195 83.37% 1,262,461 1,626,609 1052513.98 Year to date the actual revenues received for FY23 are 3.38% under the year to date revenues for FY22 and 31.16% over the 5 year average year to date. 3-Oct-23 October November December January February March April May June July August September Average 37,066 22,223 70,201 51,033 51,687 75,796 17,595 30,701 106,102 120,396 106,852 112,483 Budget 58,664 35,450 107,004 82,611 82,355 111,084 27,271 48,707 164,504 194,585 172,804 177,422 FY23 Actual 53,920 30,705 119,687 61,406 69,067 113,152 23,801 39,144 142,028 141,561 110,103 - Forecast 149,621 - 50,000 100,000 150,000 200,000 250,000 LOT FiveYear Average Compared to FY23 Actual Average Budget FY23 Actual Forecast - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 October November December January February March April May June July August September Averages FY 18 FY 19 FY 20 FY21 FY22 FY23 Forecast FY23 Five Year Actuals Comparison to Average LOT Actual Dollars per Month Month FY06 FY07 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY20 FY21 FY22 FY23 Totals October 14,274 16,938 14,412 11,306 10,483 11,520 12,392 12,163 13,390 19,298 22,085 25,791 27,291 30,504 30,166 44,871 52,496 53,920 423,301 November 11,272 9,748 7,978 7,147 5,850 5,535 6,103 7,298 8,233 11,738 12,986 15,209 16,795 17,929 20,073 27,132 29,184 30,705 250,915 December 18,547 21,746 22,261 16,224 14,294 15,459 13,939 19,101 18,122 21,802 31,168 32,785 33,179 49,031 64,163 91,656 112,975 119,687 716,139 January 17,232 18,707 20,163 17,932 17,007 17,510 17,065 19,334 24,733 26,778 31,157 31,506 40,724 46,286 49,923 60,516 57,714 61,406 575,693 February 20,446 22,943 27,324 24,826 18,873 19,921 19,716 22,331 22,013 28,487 32,613 35,777 38,616 42,579 48,770 60,544 67,925 69,067 622,771 March 15,110 13,668 21,527 15,969 8,925 11,941 17,344 20,251 19,365 18,422 23,712 25,885 31,339 59,451 45,755 119,721 122,712 113,152 704,250 April 7,294 8,049 6,425 5,954 6,183 6,210 6,696 6,165 8,719 11,641 15,255 14,865 15,617 15,981 3,460 27,021 25,895 23,801 215,231 May 11,994 11,230 9,368 8,595 7,335 8,074 9,461 11,113 15,390 18,711 22,047 23,315 25,265 27,806 18,644 43,132 38,658 39,144 349,282 June 23,442 24,611 25,426 22,248 21,491 20,728 25,352 33,681 37,000 42,541 50,323 55,034 58,523 87,224 92,394 147,239 145,130 142,028 1,054,415 July 47,654 54,276 47,052 42,408 48,747 49,843 54,214 62,187 65,335 71,296 82,520 88,713 102,486 102,472 105,196 140,826 150,998 141,561 1,457,784 August 44,024 52,948 41,089 32,480 39,398 44,505 48,919 57,546 64,959 63,598 71,300 81,215 89,143 89,369 99,323 123,848 132,577 110,103 1,286,344 September 26,973 26,073 23,600 25,826 20,258 27,603 33,029 35,605 35,959 49,346 53,966 57,591 84,328 82,112 118,823 134,036 143,595 978,723 Total Dollars Received 258,263 280,937 266,627 230,991 218,844 238,849 260,743 306,775 333,218 383,658 449,132 487,686 563,306 650,744 696,690 1,020,542 1,079,859 904,574 8,631,437 Difference compared to prior year 22,674 (14,310) (35,635) (12,148) 20,005 21,894 46,032 26,443 50,440 65,474 38,554 75,620 87,438 45,946 323,852 59,317 (175,285) 646,311 Percent of change 9%-5%-13%-5%9%9%18%9%15%17%9%16%16%7%46%6%-16% Budgeted Dollars 237,858 255,550 309,125 300,000 225,000 175,000 227,500 240,440 255,859 279,620 349,520 400,710 509,131 515,000 712,249 650,866 766,000 1,200,000 7,609,428 Contingent Budgeted dollars 52,500 62,543 11,920 50,000 61,315 77,500 45,000 27,090 161,706 327,290 256,790 227,791 360,000 1,721,445 2nd Contingent Budgeted Dollars 38,600 43,000 81,600 Total Budgeted 237,858 255,550 309,125 300,000 225,000 227,500 290,043 290,960 348,859 340,935 427,020 445,710 536,221 676,706 1,039,539 907,656 993,791 1,262,461 9,114,934