Loading...
HomeMy Public PortalAbout7-Clerk FY20 Tourism LOT Revenue ProjectionsTOURISM 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 48,889 -1.20% 163,291 152,594 7.01% 50,481 73,678 47,782 -5.35% 211,073 203,075 3.94% 42,895 62,605 45,125 5.20% 256,198 245,969 4.16% 142,860 208,506 141,796 -0.74% 20,959 30,590 3,409 -83.74% 259,607 266,929 -2.74% 33,242 48,517 32,331 -2.74% 81,774 119,350 79,533 -2.74% 135,975 198,458 115,273 -15.22% 126,964 185,306 123,485 -2.74% 112,107 163,622 109,035 -2.74% 91,234 133,158 88,734 -2.74% 330,305 482,085 321,254 -2.74% 712,249 1,039,539 692,726 97.26% 712,249 1,039,539 Year to date the actual revenues received for FY20 are 0.82% under the year to date revenues for FY19 and 36.02% over the 5 year average year to date. 29-May-20 LOT FiveYear Average Compared to FY20 Actual 40 1 ,VVV 120,000 100,000 80,000 60,000 40,000 20,000 / May June July August September October November December January February March April 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 48,889 47,782 45,125 3,409 - - - - - iiiFY20Actual Forecast 32,331 79,533 123,485 109,035 88,734 Average 0 Budget -A-FY20 Actual Forecast FY20 Five Year Actuals Comparison to Average October November December January February March ❑ Averages FY15 ❑ FY 16 April I L ■IIL N I L N May June 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 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 45,125 348,035 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,409 138,463 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 209,704 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 259,607 5,189,379 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 (391,137) 1,344 Percent of change 9% -5% -13% -5% 9% 9% 18% 9% 15% 17% 9% 16% 16% 1 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