Loading...
HomeMy Public PortalAbout5-Clerk FY19 Tourism LOT Revenue ProjectionsTOURISM LOT ACTUAL PERCENTAGES AND FORECASTED DOLLARS Month FY14 FY15 FY16 FY17 FY18 Five year average FY19 Budget dollars FY19 Budget + Contingent dollars FY19 actual and forecast based on trend Percentage +/- based on budget Actual total Budget total total +/- YTD October 4.02%5.03%4.92%5.29%4.84%4.82%24,821 32,729 30,504 22.89%30,504 24,821 22.89% November 2.47%3.06%2.89%3.12%2.98%2.90%14,955 19,719 17,929 19.89%48,433 39,776 21.76% December 5.44%5.68%6.94%6.72%5.89%6.13%31,593 41,658 49,068 55.31%97,501 71,369 36.62% 1st Quarter Total 71,369 94,107 97,501 36.62% January 7.44%6.98%6.94%6.46%7.23%7.01%36,101 47,602 46,286 28.21%143,787 107,470 33.79% February 6.60%7.43%7.26%7.34%6.86%7.10%36,547 48,191 42,568 16.47%186,355 144,017 29.40% March 5.81%4.80%5.28%5.31%5.56%5.35%27,566 36,348 59,451 115.67%245,806 171,582 43.26% 2nd Quarter Total 100,213 132,141 148,305 47.99% April 2.61%3.03%3.40%3.05%2.77%2.97%15,307 19,807 15,499 1.25%261,305 186,889 39.82% May 4.62%4.88%4.91%4.78%4.49%4.73%24,380 31,547 27,806 14.05%289,111 211,269 36.84% June 11.10%11.09%11.20%11.28%10.39%11.01%56,721 73,397 84,836 49.57%373,947 267,990 39.54% 3rd Quarter Total 96,408 124,752 128,141 32.92% July 19.60%18.58%18.37%18.19%18.19%18.59%95,734 126,234 133,587 39.54%507,534 363,724 39.54% August 19.49%16.58%15.88%16.65%15.82%16.88%86,954 114,658 121,336 39.54%628,870 450,679 39.54% September 10.79%12.86%12.02%11.81%14.97%12.49%64,321 84,814 89,754 39.54%718,624 515,000 39.54% 4th Quarter Total 247,010 325,706 344,677 39.54% Total 100.00%100.00%100.00%100.00%100.00%100.00%515,000 676,706 718,624 139.54% 515,000 676,706 718,631 515,000 203,624 Year to date the actual revenues received for FY19 are 29.53% OVER the year to date revenues for FY18 and 61.08% over the 5 year average year to date. 31-Jul-19 October November December January February March April May June July August September Average 18,545 11,091 24,596 26,716 28,244 21,527 11,325 18,115 43,716 74,010 67,764 46,131 Budget 26,925 15,879 34,227 32,891 37,350 27,023 15,519 24,340 57,454 92,614 84,786 60,124 FY19 Actual 30,504 17,929 47,870 46,286 42,568 59,451 15,499 27,808 84,836 --- Forecast 133,587 121,336 89,754 - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 LOT FiveYear Average Compared to FY19 Actual Average Budget FY19 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 FY14 FY15 FY 16 FY 17 FY 18 FY 19 Forecast FY19 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 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 184,052 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,289 109,097 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,068 245,448 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 259,124 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,568 295,270 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 212,120 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,527 103,456 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 156,633 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 84,836 381,877 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 714,245 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 641,981 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 415,829 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 373,335 3,715,722 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 Percent of change 9%-5%-13%-5%9%9%18%9%15%17%9%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 Contingent Budgeted dollars 52,500 62,543 11,920 50,000 61,315 77,500 45,000 27,090 2nd Contingent Budgeted Dollars 38,600 43,000 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