Loading...
HomeMy Public PortalAbout5-Clerk FY20 Tourism LOT Revenue Projections MayTOURISM LOT ACTUAL PERCENTAGES AND FORECASTED DOLLARS Month FY15 FY16 FY17 FY18 FY19 Five year average October 5.03% 4.92% 5.29% 4.84% 4.70% 4.96% November 3.06% 2.89% 3.12% 2.98% 2.76% 2.96% December 5.68% 6.94% 6.72% 5.89% 7.55% 6.56% January 6.98% 6.94% 6.46% 7.23% 7.13% 6.95% February 7.43%i 7.26% 7.34% 6.86% 6.56% 7.09% March 4.80% 5.28% 5.31% 5.56% 9.16% 6.02% April 3.03% 3.40% 3.05% 2.77% 2.46% 2.94% May 4.88% 4.91% 4.78% 4.49% 4.28% 4.67% June 11.09% 11.20% 11.28% 10.39% 13.44% 11.48% July 18.58% 18.37% 18.19% 18.19% 15.79% 17.83% August 16.58% 15.88% 16.65% 15.82% 13.77% 15.74% September 12.86% 12.02% 11.81% 14.97% 12.39% 12.81% 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 FY20 Budget dollars FY20 Budget + Contingent dollars FY20 actual and forecast based on trend Percentage +/- based on budget Actual total Budget total total +/- YTD 35,299 51,520 30,166 -14.54% 30,166 35,299 -14.54% 21,102 30,798 20,073 -4.88% 50,239 56,401 -10.93% 46,708 68,171 64,163 37.37% 114,402 103,109 10.95% 103,109 15 0, 49 0 114,402 10.95% 49,484 72,223 50,291 1.63% 164,693 152,594 7.93% 50,481 73,678 48,770 -3.39% 213,463 203,075 5.12% 42,895 62,605 45,931 7.08% 259,394 245,969 5.46% 142,860 208,506 144,992 1.49% 20,959 30,590 3,460 -83.49% 262,854 266,929 -1.53% 33,242 48,517 18,644 -43.91% 281,498 300,170 -6.22% 81,774 119,350 76,688 -6.22% 135,975 198,458 98,792 -27.35% 126,964 185,306 119,067 -6.22% 112,107 163,622 105,134 -6.22% 91,234 133,158 85,559 -6.22% 330,305 482,085 309,760 -6.22% 712,249 1,039,539 667,945 93.78% 712,249 1,039,539 Year to date the actual revenues received for FY20 are 3.06% under the year to date revenues for FY19 and 30.99% over the 5 year average year to date. 1-Jul-20 LOT FiveYear Average Compared to FY20 Actual 40 1 ,VVV 120,000 100,000 80,000 60,000 40,000 20,000Mil July August i June March April J J1 May September October November December January February Average 24,994 14,931 33,593 35,290 35,614 31,762 14,672 23,429 58,729 89,497 78,925 64,766 o Budget 35,299 21,102 46,708 49,484 50,481 42,895 20,959 33,242 81,774 126,964 112,107 91,234 30,166 20,073 64,163 50,291 48,770 45,931 3,460 18,644 - - - - iiiFY20Actual Forecast 30,166 20,073 64,163 48,889 48,770 45,931 3,460 18,644 76,688 119,067 105,134 85,559 Average 0 Budget li-FY20 Actual Forecast FY20 Five Year Actuals Comparison to Average October November December January February March ❑ Averages FY15 ❑ FY 16 April ■IIL May June 1 I L July August September FY 17 ❑ FY 18 ❑ FY 19 ■ FY20 ' Forecast LOT Actual Dollars per Month 06 FY07 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY20 TAM 272,014 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 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 50,291 396,425 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 425,235 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,931 348,841 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 527,624 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 919,203 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 820,493 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 582,269 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 281,498 5,211,270 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 (369,246) 23,235 Percent of change 9% -5% -13% -5% 9% 9% 18% 9% 15% 17% 9% 16% 16% -131% 0 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 4,992,562 Contingent Budgeted dollars 52,500 62,543 11,920 50,000 61,315 77,500 45,000 27,090 161,706 327,290 876,864 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 5,951,026