Loading...
HomeMy Public PortalAbout6-Clerk FY20 Tourism LOT Revenue ProjectionsTOURISM LOT ACTUAL PERCENTAGES AND FORECASTED DOLLARS Month FY15 FY16 FY17 FY18 FY19 Five year average FY20 Budget dollars FY20 Budget + Contingent dollars FY20 actual and forecast based on trend Percentage +/- based on budget Actual total Budget total total +/- YTD October 5.03%4.92%5.29%4.84%4.70%4.96%35,299 51,520 30,166 -14.54%30,166 35,299 -14.54% November 3.06%2.89%3.12%2.98%2.76%2.96%21,102 30,798 19,465 -7.76%49,631 56,401 -12.00% December 5.68%6.94%6.72%5.89%7.55%6.56%46,708 68,171 41,103 -12.00%90,734 103,109 -12.00% 1st Quarter Total 103,109 150,490 90,734 -12.00% January 6.98%6.94%6.46%7.23%7.13%6.95%49,484 72,223 43,546 -12.00%134,280 152,594 -12.00% February 7.43%7.26%7.34%6.86%6.56%7.09%50,481 73,678 44,424 -12.00%178,704 203,075 -12.00% March 4.80%5.28%5.31%5.56%9.16%6.02%42,895 62,605 37,747 -12.00%216,451 245,969 -12.00% 2nd Quarter Total 142,860 208,506 125,717 -12.00% April 3.03%3.40%3.05%2.77%2.46%2.94%20,959 30,590 18,444 -12.00%234,895 266,929 -12.00% May 4.88%4.91%4.78%4.49%4.28%4.67%33,242 48,517 29,253 -12.00%264,148 300,170 -12.00% June 11.09%11.20%11.28%10.39%13.44%11.48%81,774 119,350 71,961 -12.00%336,109 381,944 -12.00% 3rd Quarter Total 135,975 198,458 119,658 -12.00% July 18.58%18.37%18.19%18.19%15.79%17.83%126,964 185,306 111,728 -12.00%447,837 508,908 -12.00% August 16.58%15.88%16.65%15.82%13.77%15.74%112,107 163,622 98,654 -12.00%546,491 621,015 -12.00% September 12.86%12.02%11.81%14.97%12.39%12.81%91,234 133,158 80,286 -12.00%626,777 712,249 -12.00% 4th Quarter Total 330,305 482,085 290,668 -12.00% Total 100.00%100.00%100.00%100.00%100.00%100.00%712,249 1,039,539 626,777 88.00% 712,249 1,039,539 626,779 Year to date the actual revenues received for FY20 are 7.65% OVER the year to date revenues for FY19 and 9.8% over the 5 year average year to date. 2-Jan-20 October November December January February March April May June July August September 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 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 FY20 Actual 30,166 19,465 ---------- Forecast 30,166 19,465 41,103 43,546 44,424 37,747 18,444 29,253 71,961 111,728 98,654 80,286 - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 LOT FiveYear Average Compared to FY20 Actual Average Budget FY20 Actual Forecast - 20,000 40,000 60,000 80,000 100,000 120,000 October November December January February March April May June July August September Averages FY15 FY 16 FY 17 FY 18 FY 19 FY20 Forecast FY20 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 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 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 19,465 163,286 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 327,658 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 346,134 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 376,465 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 302,910 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 135,054 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 49,631 4,979,403 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 601,113 993,594 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 515,000 3,771,182 Contingent Budgeted dollars 52,500 62,543 11,920 50,000 61,315 77,500 45,000 27,090 387,868 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 4,234,781