Loading...
HomeMy WebLinkAbout2018-11_BC_RevenueReports2018 11 November General Fund 6-Dec-2018 Jefferson County Treasurer REVENUE NAME BARS BUDGET NOV Y-T-D Y-T-D ACTUAL NOV Y-T-D Y-T-D ACTUAL NOV Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 %Property Tax 1 311.10 7,850,027 513,614 7,778,112 99.1%7,643,881 574,713 7,598,080 99.4%7,514,257 651,392 7,470,260 99.4% Diverted Road Prop Tax 1 311.20 720,000 51,934 715,323 99.4%720,000 60,623 716,216 99.5%720,000 68,091 716,840 99.6%Sales Tax 1 313.11 3,040,000 311,101 2,914,415 95.9%2,876,339 279,959 2,656,567 92.4%2,738,244 293,377 2,522,707 92.1% special purpose 313.15 955,428 98,020 916,514 95.9%903,099 90,736 833,517 92.3%876,170 89,596 810,037 92.5%Local Criminal Justice 1 313.71 380,070 40,627 382,645 100.7%375,219 37,400 346,128 92.2%364,508 37,398 336,684 92.4% Leasehold Excise Tax 3 317.20 62,000 - 51,732 83.4%69,801 - 53,782 77.1%55,407 - 46,960 84.8%Private Harvest Tax - TAV 2 317.40.10/.20 335,000 158,358 537,635 160.5%377,824 66,821 377,824 100.0%281,335 29,003 281,335 100.0% P.I.L.T. (incl DNR)*4 332.15.23/336.02.31 1,867,988 - 1,833,818 98.2%1,458,645 - 1,390,772 95.3%1,476,638 - 1,422,312 96.3%P.U.D. Privilege Tax 4 335.00.91 323,420 - 393,491 121.7%314,148 - 314,148 100.0%318,107 - 318,107 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 463,500 - 425,438 91.8%435,778 - 435,778 100.0%477,057 - 477,104 100.0%Marijuana Enforcement/Excise 6 336.06.41-42 24,720 - 51,775 209.4%21,297 - 16,324 76.7%36,920 - 31,244 84.6% Liquor Excise Tax 8 336.06.94 41,536 6,105 47,254 113.8%44,174 - 44,174 100.0%41,772 - 41,772 100.0%Liquor Profit 6 336.06.95 90,203 - 63,098 70.0%84,441 - 63,375 75.1%84,749 - 63,594 75.0% Treasurer Invest & Other Fees 1 341.42.15-20/50 16,290 2,369 40,277 247.3%33,805 5,461 35,698 105.6%11,599 1,121 10,456 90.1%Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 6,409 78,329 97.9%90,727 8,413 83,831 92.4%84,213 5,679 78,120 92.8% Penalties on delinquent taxes 1 359.40.10/.20 133,332 8,047 88,597 66.4%98,944 6,183 80,634 81.5%112,239 7,196 93,540 83.3%Investment Income 1 361.11 230,000 49,794 486,106 211.4%354,385 28,968 390,038 110.1%682,617 14,041 665,615 97.5% Interest on delinquent taxes 1 361.40.10 210,000 27,478 187,255 89.2%193,625 22,455 172,405 89.0%213,458 22,742 190,119 89.1% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 - 216,026 65.8%143,455 - 27,067 18.9%294,890 - 35,383 12.0% DNR Timber 1 395.1.1 250,000 60,862 296,855 118.7%207,899 39,951 207,451 99.8%336,350 13,240 328,785 97.8% Transfer in 1 397.00 3,000 750 30,927 1030.9%40,322 750 38,837 96.3%46,441 750 46,441 100.0% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 1,143 15,047 126.4%9,020 855 6,864 76.1%17,552 605 17,552 100.0% Assessor 1 001-010-000 8,700 1,791 7,827 90.0%10,970 1,926 10,603 96.7%8,761 1,984 8,327 95.1%Auditor-Recording Fees 1 341.21.10 72,063 5,104 64,781 89.9%74,248 6,252 67,930 91.5%74,077 6,839 67,692 91.4% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 9,532 223,721 96.1%242,031 9,799 232,685 96.1%229,927 10,754 222,810 96.9%Auditor-Other Revenue 1 26,605 2,694 31,514 118.5%29,714 2,226 27,358 92.1%32,440 4,470 30,526 94.1% Elections 1 001-021-000 159,722 - 101,536 63.6%138,996 - 114,205 82.2%160,903 - 153,467 95.4%Clerk 1 001-020-000 170,768 12,920 164,160 96.1%179,130 21,620 166,390 92.9%192,402 15,442 178,051 92.5% County Administrator 1 001-059-000 4,260 - 4,260 3,700 0 0Commissioners1001-060-000 8,000 578 7,861 98.3%8,923 693 8,073 90.5%8,609 748 7,877 91.5% Safety & Security 1 001-067-000 64,959 - 41,545 64.0%66,877 - 66,877 100.0%70,305 1,199 59,367 84.4%Community Services 1 001-068-000 6,900 792 4,151 60.2%4,611 23 3,954 85.7%8,269 52 8,241 99.7% District Court 1 001-080-000 603,032 76,702 643,028 106.6%596,433 35,845 534,007 89.5%632,629 73,618 602,934 95.3%Juvenile Service 1 001-110-000 259,676 21,229 257,501 99.2%290,984 72,343 268,414 92.2%260,358 45,502 253,990 97.6% Prosecuting Attorney 1 001-150-000 178,690 11,388 95,394 53.4%151,185 11,277 144,135 95.3%124,918 10,986 118,007 94.5%Coroner 1 001-151-000 25,348 - 32,723 129.1%24,610 - 24,610 100.0%8,340 - 8,340 100.0% Sheriff 1 001-180-000 603,401 34,219 552,665 91.6%722,960 68,305 520,916 72.1%626,703 103,797 591,799 94.4% Superior Court *1 001-240-000 60,822 13,756 51,520 84.7%90,193 21,080 90,193 100.0%26,142 5,411 26,142 100.0% Non Departmental 1 001-270-000 50,447 - 32,802 65.0%49,196 10 0.0%10 10 TOTAL CURRENT EXPENSE REVENUE 19,953,036 1,527,316 19,867,656 99.6%19,181,590 1,474,677 18,169,870 94.7%19,249,318 1,515,033 18,342,547 95.3% * Revenue Schedule 1 monthly, 2 Feb/May/Aug/Nov, 3 Feb/Apr/Jun/Aug/Oct/Dec, 4 Jun 5 Jan/Apr/Jul/Oct 6 Mar/Jun/Sep/Dec 7 Nov 8 Var REFUND EXPEND CY/PRIOR exclude 388/89 0 525 (103,175)253,160 4,206 231,456 194,294 8 17,345 *2018 Budget Amendments made: Superior Court, PILT OTHER FUNDS REVENUE REPORT 2018 3 year view Prepared by the Jefferson County Treasurer November 11 12/6/2018 FUND Fund #Budget Nov YTD YTD ACTUAL Nov YTD YTD ACTUAL Nov YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,179 74,544 98.9%77,983 2,158 75,737 97.1%74,342 2,269 72,127 97.0% Court Facilitator 106 5,100 280 4,540 89.0%5,920 580 5,560 93.9%6,220 660 5,620 90.4% Boating Safety 107 48,740 - 47,451 97.4%49,100 - 49,100 100.0%61,493 5 61,493 100.0% WSU Cooperative 108 *557,432 88,408 539,121 96.7%534,494 20,924 425,905 79.7%528,605 108,297 522,685 98.9% 4-H After School 113 *50,450 - 37,750 74.8%44,475 2,743 44,475 100.0%10,600 - 10,600 100.0% JeffComCap 119 119 *264,695 22,058 242,637 91.7%254,838 21,221 233,618 91.7%276,062 22,899 253,163 91.7% Crime Victim's Svc 120 110,757 1,684 111,377 100.6%99,707 22,380 98,836 99.1%79,335 1,263 78,184 98.5% Grant Mgmt 123 150,000 6,238 88,448 59.0%76,723 - 58,345 76.0%95,126 - 61,954 65.1% Hotel-Motel 125 500,500 63,101 496,737 99.2%507,868 69,054 474,998 93.5%449,148 57,999 423,064 94.2% Jeff Co Public Health 127 *4,372,775 489,498 4,349,474 99.5%4,064,163 363,368 3,788,916 93.2%4,076,806 450,701 3,874,995 95.0% Water Quality 128 960,714 68,803 902,445 93.9%975,455 51,022 857,366 87.9%999,219 90,039 884,586 88.5% Water Quality Land Acq 129 132,825 132,825 Mental Health 130 45,150 4,068 49,633 109.9%47,474 3,850 47,119 99.3%46,854 3,965 46,518 99.3% Chem Dep Mnt Hlth tx 131 490,490 55,731 525,482 107.1%516,131 51,397 476,153 92.3%500,457 50,849 462,213 92.4% Drug Fund 135 18,288 769 11,784 64.4%11,819 947 10,921 92.4%23,562 1,095 22,617 96.0% Law Library 140 10,150 799 9,236 91.0%10,049 703 9,102 90.6%9,692 879 8,967 92.5% Trial Court Imprvmnt 141 25,000 - 23,201 92.8%23,449 5,859 17,585 75.0%22,669 - 22,669 100.0% Public Defense Fnd 142 35,000 - - 0.0%0 - - 0.0%36,673 - - 0.0% Community Develpmnt 143 *1,792,406 180,706 1,419,715 79.2%1,418,569 163,151 1,348,568 95.1%1,668,687 200,826 1,562,596 93.6% Federal Forest Title III 147 - 176 19,990 - 73 598 - 30 21,918 Jeff Co Affrdbl Hsg 148 *318,881 26,193 281,508 88.3%250,150 20,292 229,140 91.6%243,809 21,286 223,646 91.7% Treasurer's O & M 150 47,280 4,431 29,566 62.5%28,653 28 19,402 67.7%23,981 771 17,873 74.5% REET technology 151 14,420 1,312 15,001 104.0%16,827 1,443 15,455 91.8%16,194 1,307 14,832 91.6% Veteran's Relief 155 59,820 4,221 69,867 116.8%65,060 3,961 64,632 99.3%63,652 4,041 63,285 99.4% Water Pollution Cntrl 160 - - - - - - 18,607 - 18,607 100.0% Park & Rec 174 659,282 144,908 681,695 103.4%625,429 129,328 585,245 93.6%569,174 135,830 557,839 98.0% County Park Imprvmnt 175 *146,185 40 155,581 106.4%119,426 60 86,926 72.8%84,284 456 84,284 100.0% County Roads 180 7,838,108 754,089 8,680,718 110.8%9,773,015 658,533 9,143,969 93.6%8,949,637 1,533,395 8,356,559 93.4% Facilities Mgmt 183 1,074,934 89,787 1,029,203 95.7%1,040,019 68,407 935,163 89.9%1,116,468 86,931 1,029,537 92.2% County Fair 199 250,000 11,584 246,944 98.8%308,594 9,896 304,154 98.6%269,769 14,408 264,195 97.9% Total Special Revenue 19,921,894 2,153,889 20,276,473 101.8%20,945,389 1,661,481 19,406,984 92.7%20,321,124 2,775,793 19,026,625 93.6% * 2018 Revenue Budget Amendments Made for WSU Coop, 4-H, Jeff Com Capital 119, Jeff Co Public Health, Community Development, Jeff Co Affordable Housing, County Park Improvement, Tri-Area Sewer OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Nov YTD YTD YTD Nov YTD YTD Budget Nov YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 18,000 64,679 6.5%517,754 - 515,341 99.5%1,113,333 275,000 1,113,333 100.0% Capital Improvement 302 1,072,938 96,368 1,189,596 110.9%1,285,270 119,897 1,185,236 92.2%1,537,774 375,151 1,454,497 94.6% Public Infrastructure 306 451,400 52,307 491,589 108.9%477,127 47,585 443,385 92.9%456,854 46,826 421,665 92.3% Conservation Futures 308 239,400 22,677 280,190 117.0%256,431 21,061 254,000 99.1%244,237 20,732 242,277 99.2% Total CAP IMP 2,763,738 189,352 2,026,054 73.3%2,536,581 188,543 2,397,962 94.5%3,352,198 717,708 3,231,772 96.4% ENTERPRISE Solid Waste 401 3,357,942 222,022 3,271,175 97.4%3,488,829 257,016 3,199,043 91.7%3,481,538 284,606 3,219,736 92.5% Solid Waste Post Clos 402 150 89 884 589.3%516 55 701 136.0%335 35 304 90.8% Solid Waste Eqpt Res 403 4,000 1,574 14,083 352.1%7,601 771 9,818 129.2%302,768 300,288 302,495 99.9% Yard Waste Educ Fnd 404 5,800 5,663 5,754 99.2%5,750 1 25 0.4%1,781 1,748 1,780 99.9% Tri Area Sewer 405 *255,399 1,304 41,102 16.1%297,554 205,613 211,155 71.0%172,740 170,272 172,523 99.9% Total ENTERPRISE 3,623,291 230,651 3,332,998 92.0%3,800,250 463,457 3,420,742 90.0%3,959,162 756,949 3,696,838 93.4% INTERNAL SERVICE Equipment Rental 501 2,451,202 260,983 2,253,466 91.9%2,508,636 170,738 2,229,555 88.9%2,179,575 167,714 1,900,217 87.2% Risk Management 502 215,000 - 27,431 12.8%112,770 - 75,111 66.6%57,666 - 15,034 26.1% Benefit Reserve 505 208,000 14,181 226,387 108.8%225,590 12,720 211,212 93.6%215,434 11,881 204,134 94.8% Information Services 506 2,103,298 2,848 1,912,987 91.0%1,832,926 5,368 1,711,246 93.4%1,551,832 6,797 1,511,152 97.4% Total INT SERV 4,977,500 278,012 4,420,271 88.8%4,679,922 188,826 4,227,124 90.3%4,004,508 186,392 3,630,536 90.7% Total 31,286,423 2,851,904 30,055,795 96.1%31,962,142 2,502,307 29,452,811 92.1%31,636,992 4,436,842 29,585,772 93.5% * 2018 Revenue Budget Amendments Made for WSU Coop, 4-H, Jeff Com Capital 119, Jeff Co Public Health, Community Development, Jeff Co Affordable Housing, County Park Improvement. Tri-Area Sewer GENERAL FUND CASH BALANCE REPORT 12/6/2018 END OF MONTH CASH BALANCES 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 January 3,001,108$ 2,717,342$ 2,548,924$ 3,317,483$ 2,556,108$ 3,030,949$ 2,798,256$ 4,109,412$ 4,360,809$ 4,416,485$ February 2,167,401$ 1,804,045$ 1,882,264$ 3,023,683$ 1,802,345$ 2,041,248$ 2,202,079$ 3,278,685$ 3,622,756$ 3,681,133$ March 2,190,309$ 1,691,583$ 1,934,629$ 2,347,678$ 1,654,411$ 2,108,155$ 2,384,301$ 3,289,638$ 3,759,875$ 3,580,887$ April 4,090,214$ 3,764,298$ 3,819,239$ 4,144,298$ 3,732,606$ 4,429,017$ 4,572,778$ 5,181,554$ 5,391,984$ 5,572,170$ May 3,913,999$ 3,623,704$ 3,850,878$ 4,045,216$ 3,747,009$ 4,421,127$ 4,622,123$ 5,174,859$ 5,455,638$ 5,330,488$ June 3,961,669$ 3,554,636$ 4,081,060$ 3,980,389$ 4,663,469$ 4,818,824$ 5,866,387$ 6,413,636$ 6,593,259$ 6,795,577$ July 3,217,764$ 2,978,751$ 3,732,809$ 3,396,868$ 3,873,932$ 3,736,091$ 5,087,286$ 5,610,102$ 5,806,710$ 6,177,104$ August 2,548,416$ 2,117,574$ 2,974,460$ 2,394,180$ 3,010,467$ 2,898,623$ 4,203,581$ 5,416,407$ 5,111,812$ 5,237,488$ September 2,150,120$ 1,596,637$ 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ 4,511,047$ October 3,787,064$ 3,363,104$ 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ 6,245,727$ 6,682,718$ November 3,281,183$ 3,339,559$ 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ 6,098,807$ 6,804,203$ December 3,297,287$ 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Budg *** Total Reserve $ 1,517,056 $ 1,530,071 $ 1,666,150 $ 1,708,161 $ 1,786,000 $ 2,121,257 $ 2,140,726 $ 2,308,223 $ 2,589,184 $ 2,672,214 10% GF Budgeted Expenditures $ 1,517,056 $ 1,530,071 $ 1,566,150 $ 16,081,612 $ 1,646,000 $ 1,681,257 $ 1,700,726 $ 1,806,223 $ 1,863,184 $ 1,946,214 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 ***The Required Reserve is based on 10% of the total General Fund budgeted expenditures, plus a revenue stabilization reserve. If General Fund budgeted expenditures are amended (e.g. by a Quarterly Budget Extension), or if the revenue stabilization reserve is drawn down or increased, then the Required Reserve will also change. $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 GENERAL FUND END OF MONTH CASH BALANCE 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 11 November 12/6/2018 GENERAL SALES TAX RECEIPTS Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End3 yr. avg Expected Actual Over/Under Cum %projection 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2015-17 2018 2018 Expected expected Projection Over/Under January 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 6.6%200,614 207,899 $7,285 103.63%$3,150,395 $110,395February219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 10.0%305,388 279,301 -$26,087 96.28%$2,927,043 -$112,957March177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 6.8%205,802 206,999 $1,197 97.53%$2,964,815 -$75,185April148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 6.7%203,686 202,532 -$1,154 97.95%$2,977,712 -$62,288May181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 8.4%256,612 271,431 $14,819 99.66%$3,029,784 -$10,216June 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 7.4%225,655 248,506 $22,850 100.97%$3,069,524 $29,524July159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 7.7%235,089 262,489 $27,400 102.84%$3,126,223 $86,223 August 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 10.2%310,571 309,575 -$996 102.33%$3,110,885 $70,885September187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 8.8%268,857 307,750 $38,893 103.81%$3,155,716 $115,716October168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 306,832 9.4%285,439 306,832 $21,393 104.23%$3,168,530 $128,530November213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 311,101 10.0%305,512 311,101 $5,589 103.97%$3,160,582 $120,582December155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 7.8%236,775 - TTL 2,137,279 1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 2,876,339 2,914,415 100.0%$3,040,000 $2,914,415 ytd 1,981,413 1,767,796 1,822,230 1,870,560 2,179,506 2,104,824 2,290,946 2,522,707 2,656,567 2,914,415 2,803,225 2,914,415 ytd change -10.78%3.08%2.65%16.52%-3.43%8.84%10.12%5.31%9.71%3.97%over (under) ytd expectedannual % chg.-10.25%2.64%3.98%14.73%-2.03%8.07%10.12% Special Purp./Public Safety TaxActualActualActual Actual Actual Actual Actual 3 yr avg.Projection Actual 2012 2013 2014 2015 2016 2017 2018 2015-17 2018 2018 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 6.69%63,886 66,993 264,500 274,892 3.9%February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 9.8%93,779 90,853 399,167 370,154 -7.3%March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 6.8%65,387 66,479 271,189 273,478 0.8%April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 6.7%64,462 63,784 268,148 266,316 -0.7% May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 8.5%80,820 84,357 337,432 355,788 5.4%June 46,797 50,067 48,647 58,717 65,832 65,229 75,141 7.4%71,153 75,141 296,808 323,647 9.0%July 49,385 68,295 54,074 56,793 69,908 73,136 81,117 7.8%74,924 81,117 310,013 343,606 10.8%August 56,220 56,063 68,712 76,734 87,275 89,679 97,261 10.0%95,114 97,261 405,686 406,836 0.3%September 54,902 61,455 64,622 72,022 77,854 77,534 97,036 8.9%85,262 97,036 354,119 404,786 14.3%October 61,120 64,400 64,152 73,903 82,028 82,991 95,473 9.4%89,578 95,473 375,017 402,305 7.3% November 60,952 64,915 71,491 77,947 89,596 90,736 98,020 10.1%96,836 98,020 402,348 409,120 1.7%December 49,281 52,177 59,043 62,263 66,133 69,582 7.8%74,227 - 311,003 - TOTAL 621,440 704,453 701,993 769,039 876,170 903,099 916,514 100.0%955,428 916,514 3,995,428 3,830,929 ytd 652,276 642,950 706,776 810,037 833,517 $916,514 881,201 $916,514 3,684,425 $3,830,929 4.0%4.01%over (under) ytd expected TOTAL 2018 SALES TAX Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules. 100,000 150,000 200,000 250,000 300,000 GENERAL SALES TAX RECEIPTS 2018 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 November 11 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation TOTAL Recent 2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 4 YR AVG Budget Actual Difference January 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 53,263$ 49,358$ 49,830$ 1.0% February 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 43,542$ 40,350$ 65,067$ 61.3% March 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 95,117$ 88,144$ 75,558$ -14.3% April 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 68,249$ 63,245$ 102,480$ 62.0% May 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 88,832$ 82,320$ 128,185$ 55.7% June 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 144,702$ 134,093$ 147,514$ 10.0% July 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 97,339$ 90,203$ 108,763$ 20.6% August 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 95,860$ 88,833$ 131,097$ 47.6% September 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 142,117$ 131,698$ 117,652$ -10.7% October 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 104,607$ 96,938$ 119,144$ 22.9% November 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 75,648$ 70,102$ 96,368$ 37.5% December 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 96,815$ 89,717$ -$ Total $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,141,659 1,106,090$ 1,025,000$ 1,141,659$ 11% YTD 509,722$ 398,120$ 416,021$ 499,161$ 645,816$ 602,875$ 1,094,495$ 1,154,497$ 1,185,236$ $1,141,659 1,009,276$ 935,283$ 1,141,659$ 22% Y/Y chg -21.89%4.50%19.98%29.38%-6.65%81.55%5.48%2.66%-3.68% Jan 2017 1@1.565M, 6 Res>$500k Sept 2017 12>$500k May 2018 2@1.044 and 1.165M, 13 >$500k Feb 2017 5 Res>$500k Oct 2017 2 sales @$1.31M and $1.445M, 6 res>$500k Jun 2018 1 sale@$3M, 16>$500k Mar 2017 6 Res>$500k Nov 2017 12 sales>$500k Jul 2018 10>$500k Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k Dec 2017 1 sale @ $1.529M, 11>$500k Aug 2018 1@$1.4M, 8>$500k May 2017 1@$1.098, 1@$1.035, 6 Res>$500k Jan 2018 no unincorp sales>$445k Sep 2018 1@1.2M, 14>$500k Jun 2017 1@$1.05, 16>$500k Feb 2018 1@1.435M, 3 Res>$500k Oct 2018 14>$500k July 2017 6>$500k Mar 2018 4 Res>$500k Nov 2018 12>$500k Aug 2017 1@$1.024, 1@1.37 and 11>$500k Apr 2018 1@2.16M, 11 Res>$500k 12/6/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 11 November 12/6/2018 REVENUE 4 yr avg *2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2013-16 Budget Actual Difference January 16,089$ 10,732$ 11,507$ 12,045$ 8,863$ 13,575$ 17,051$ 18,473$ 19,394$ 23,177$ 17,123$ 20,418$ 23,177$ 13.5%February 27,998$ 21,729$ 25,532$ 23,188$ 38,274$ 30,356$ 36,141$ 51,077$ 53,093$ 46,226$ 42,667$ 50,876$ 46,226$ -9.1% March 22,623$ 9,838$ 12,406$ 7,271$ 11,203$ 12,715$ 14,345$ 14,554$ 16,889$ 19,419$ 14,626$ 17,440$ 19,419$ 11.3% April 11,344$ 11,934$ 10,791$ 14,950$ 11,430$ 12,427$ 14,983$ 18,530$ 20,901$ 23,749$ 16,710$ 19,926$ 23,749$ 19.2% May 19,646$ 19,561$ 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 41,061$ 29,611$ 35,308$ 41,061$ 16.3% June 19,205$ 19,650$ 17,302$ 17,916$ 16,477$ 18,786$ 25,070$ 29,476$ 31,485$ 36,556$ 26,204$ 31,247$ 36,556$ 17.0%July 20,155$ 14,326$ 19,311$ 20,201$ 21,512$ 24,536$ 27,711$ 33,687$ 38,400$ 44,445$ 31,083$ 37,064$ 44,445$ 19.9% August 35,178$ 36,076$ 24,742$ 31,171$ 33,140$ 37,534$ 48,845$ 56,349$ 64,820$ 64,934$ 51,887$ 61,871$ 64,934$ 5.0%September 41,757$ 40,208$ 42,500$ 40,882$ 39,890$ 42,349$ 44,713$ 53,487$ 56,561$ 68,870$ 49,278$ 58,759$ 68,870$ 17.2% October 43,012$ 46,548$ 43,861$ 41,015$ 41,741$ 43,659$ 49,182$ 59,970$ 58,458$ 65,200$ 52,817$ 62,980$ 65,200$ 3.5%November 44,351$ 43,285$ 38,547$ 36,906$ 39,146$ 46,879$ 58,967$ 57,999$ 69,054$ 63,101$ 58,225$ 69,428$ 63,101$ -9.1% December 19,873$ 18,741$ 21,703$ 11,109$ 15,514$ 33,858$ 25,213$ 26,084$ 32,870$ 29,506$ 35,184$ Total 321,231$ 292,628$ 293,344$ 273,796$ 295,200$ 335,825$ 386,107$ 449,148$ 507,868$ 496,737$ 419,737$ 500,500$ 496,737$ YTD 301,358$ 273,887$ 271,641$ 262,687$ 279,686$ 301,967$ 360,895$ 423,064$ 474,998$ 496,737$ 390,231$ 465,316$ 496,737$ 6.8% $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 2018 HOTEL/MOTEL LODGING TAX -Fund 125 Includes Investment Interest 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018