Loading...
HomeMy Public PortalAbout6-Clerk FY21 Lodging LOT Revenue ProjectionsLODGING LOT ACTUAL PERCENTAGES AND FORECASTED DOLLARS Month FY16 FY17 FY18 FY19 FY20 Five year average October 4.92% 5.29% 4.84% 4.70% 4.36% 4.82% November 2.89% 3.12% 2.98% 2.76% 2.94% 2.94% December 6.94% 6.72% 5.89% 7.55% 9.28% 7.28% January 6.94% 6.46% 7.23% 7.13% 7.07% 6.97% February 7.26% 7.34% 6.86% 6.56% 6.91% 6.99% March 5.28% 5.31% 5.56% 9.16% 5.97% 6.26% April 3.40% 3.05% 2.77% 2.46% 0.50% 2.44% May 4.91% 4.78% 4.49% 4.28% 2.70% 4.23% June 11.20% 11.28% 10.39% 13.37% 13.37% 11.92% July 18.37% 18.19% 18.19% 15.79% 15.22% 17.15% August 15.88% 16.65% 15.82% 13.77% 14.37% 15.30% September 12.02% 11.81% 14.97% 12.39% 16.40% 13.52% Total 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 1st Quarter Total 2nd Quarter Total 3rd Quarter Total 4th Quarter Total FY21 Budget dollars FY21 Budget + Contingent dollars FY21 actual and forecast based on trend Percentage +1- based on budget Actual total Budget total total +1- YTD 28,678 42,152 43,231 50.75% 43,231 28,678 50.75% 19,083 28,048 28,767 50.75% 60,998 89,656 91,954 50.75% 108,759 159,856 163,952 50.75% 46,477 68,313 70,064 50.75% 45,425 66,766 68,478 50.75% 39,205 57,624 59,101 50.75% 131,107 192,703 197,643 50.75% 3,289 4,835 4,959 50.75% 17,724 26,051 26,719 50.75% 87,836 129,103 132,413 50.75% 108,850 159,989 164,091 50.75% 100,007 146,992 150,760 50.75% 94,423 138,785 142,343 50.75% 107,721 158,331 162,390 50.75% 302,151 444,108 455,493 50.75% 650,866 956,656 981,179 150.75% 650,866 956,656 Year to date the actual revenues received for FY21 are 43.31% over the year to date revenues for FY20 and 59.13% over the 5 year average year to date. 25 -Nov -20 140,000 120,000 100,000 80,000 60,000 40,000 20,000 Average ❑ Budget .i1r.FY21 Actual Forecast October 24,994 35,299 43,231 43,231 LOT FiveYear Average Compared to FY21 Actual November 14,931 21,102 18,902 December 33,593 46,708 60,421 January 35,290 49,484 47,011 February 35,614 50,481 45,926 March 31,762 42,895 14,672 20,959 43,086 3,258 23,429 33,242 17,557 Average Budget -1-FY21 Actual -0-Forecast 58,729 81,774 87,005 89,497 126,964 126,964 August 78,925 112,107 112,107 September 64,766 91,234 91,234 180,000 FY21 Five Year Actuals Comparison to Average 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 October November December January February March ❑ Averages FY 16 ❑ FY 17 FY 18 ❑ FY 19 ❑ FY 20 ■ FY21 Forecast June July August September LOT Actual Dollars per Month Month FY06 FY07 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY20 FY21 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 43,231 272,014 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 163,894 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 391,821 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 48,889 395,023 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 47,782 424,247 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 41,239 344,149 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 138,514 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 228,348 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 620,018 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 1,024,399 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 919,816 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 113,311 695,580 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 684,640 43,231 5,614,412 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 33,896 (641,409) (215,032) Percent of change 9% -5% -13% -5% 9% 9% 18% 9% 15% 17% 9% 16% 16% 5% -94% 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 681,878 5,674,440 Contingent Budgeted dollars 52,500 62,543 11,920 50,000 61,315 77,500 45,000 27,090 161,706 327,290 134,164 1,011,028 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 816,042 6,767,068