Loading...
HomeMy WebLinkAbout2018-10_BC_RevenueReports2018 10 October General Fund 5-Nov-2018 Jefferson County Treasurer REVENUE NAME BARS BUDGET OCT Y-T-D Y-T-D ACTUAL OCT Y-T-D Y-T-D ACTUAL OCT Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % Property Tax 1 311.10 7,850,027 2,604,179 7,264,498 92.5%7,643,881 2,459,565 7,023,368 91.9%7,514,257 2,324,335 6,818,868 90.7%Diverted Road Prop Tax 1 311.20 720,000 232,718 663,389 92.1%720,000 222,472 655,593 91.1%720,000 214,953 648,749 90.1% Sales Tax 1 313.11 3,040,000 306,832 2,603,315 85.6%2,876,339 267,264 2,376,608 82.6%2,738,244 254,002 2,229,330 81.4% special purpose 313.15 955,428 95,473 818,495 85.7%903,099 82,991 742,780 82.2%876,170 82,028 720,441 82.2% Local Criminal Justice 1 313.71 380,070 39,819 342,018 90.0%375,219 34,849 308,729 82.3%364,508 34,121 299,286 82.1% Leasehold Excise Tax 3 317.20 62,000 3,106 51,732 83.4%69,801 3,035 53,782 77.1%55,407 2,294 46,960 84.8%Private Harvest Tax - TAV 2 317.40.10/.20 335,000 - 379,277 113.2%377,824 - 311,003 82.3%281,335 - 252,332 89.7% 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 104,600 425,438 91.8%435,778 108,114 435,778 100.0%477,057 109,780 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,768 41,148 99.1%44,174 12,013 44,174 100.0%41,772 11,032 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,398 37,909 232.7%33,805 3,868 30,237 89.4%11,599 1,215 9,334 80.5% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 8,624 71,919 89.9%90,727 8,763 75,418 83.1%84,213 8,289 72,442 86.0%Penalties on delinquent taxes 1 359.40.10/.20 133,332 3,939 80,549 60.4%98,944 5,338 74,451 75.2%112,239 4,719 86,344 76.9% Investment Income 1 361.11 230,000 49,554 436,311 189.7%354,385 44,022 361,070 101.9%682,617 9,969 651,573 95.5% Interest on delinquent taxes 1 361.40.10 210,000 8,262 159,777 76.1%193,625 11,924 149,949 77.4%213,458 9,490 167,377 78.4% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 9,296 216,026 65.8%143,455 (3,510) 27,067 18.9%294,890 8,846 35,383 12.0% DNR Timber 1 395.1.1 250,000 75,063 235,993 94.4%207,899 73,324 167,500 80.6%336,350 19,544 315,545 93.8%Transfer in 1 397.00 3,000 - 30,177 1005.9%40,322 - 38,087 94.5%46,441 - 45,691 98.4% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 978 13,903 116.8%9,020 396 6,009 66.6%16,947 485 16,947 100.0% Assessor 1 001-010-000 8,700 142 6,036 69.4%10,970 504 8,677 79.1%8,761 183 6,343 72.4%Auditor-Recording Fees 1 341.21.10 72,063 6,273 59,677 82.8%74,248 7,069 61,679 83.1%74,077 7,237 60,854 82.1% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 12,696 214,188 92.0%242,031 15,105 222,886 92.1%229,927 11,893 212,056 92.2% Auditor-Other Revenue 1 26,605 2,635 28,820 108.3%29,714 2,740 25,132 84.6%32,440 2,610 26,056 80.3%Elections 1 001-021-000 159,722 3,000 101,536 63.6%138,996 - 114,205 82.2%160,903 - 153,467 95.4% Clerk 1 001-020-000 170,768 21,170 151,241 88.6%179,130 10,256 144,770 80.8%192,402 15,527 162,609 84.5% County Administrator 1 001-059-000 4,260 - 4,260 3,700 0 0 Commissioners 1 001-060-000 8,000 757 7,283 91.0%8,923 880 7,380 82.7%8,609 819 7,129 82.8% Safety & Security 1 001-067-000 64,959 - 41,545 64.0%66,877 11,368 66,877 100.0%70,305 - 58,168 82.7%Community Services 1 001-068-000 6,900 86 3,359 48.7%4,611 46 3,931 85.3%8,269 1,871 8,189 99.0% District Court 1 001-080-000 603,032 37,309 566,326 93.9%596,433 31,966 498,162 83.5%632,629 41,626 529,316 83.7% Juvenile Service 1 001-110-000 259,676 37,651 236,273 91.0%290,984 - 196,071 67.4%260,358 24,853 208,488 80.1%Prosecuting Attorney 1 001-150-000 178,690 7,430 84,006 47.0%151,185 7,062 132,858 87.9%124,918 6,911 107,020 85.7% 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 57,675 518,446 85.9%722,960 11,908 452,611 62.6%626,703 13,623 488,002 77.9% Superior Court *1 001-240-000 60,822 - 37,764 62.1%90,193 1,374 69,113 76.6%26,142 - 20,732 79.3% 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 3,738,432 18,340,340 91.9%19,181,590 3,434,704 16,695,192 87.0%19,248,713 3,222,255 16,827,513 87.4% * 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 7,473 (103,700)253,160 196,247 227,250 194,294 4,972 17,338 *2018 Budget Amendments made: Superior Court, PILT Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view October 10 11/6/2018 FUND Fund #Budget Oct YTD YTD ACTUAL Oct YTD YTD ACTUAL Oct YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,717 72,365 96.1%77,983 2,703 73,578 94.4%74,342 2,488 69,858 94.0% Court Facilitator 106 5,100 540 4,260 83.5%5,920 560 4,980 84.1%6,220 360 4,960 79.7% Boating Safety 107 48,740 - 47,451 97.4%49,100 7,222 49,100 100.0%61,493 9,455 61,488 100.0% WSU Cooperative 108 *557,432 50,254 450,713 80.9%534,494 89,371 404,980 75.8%528,605 32,856 414,388 78.4% 4-H After School 113 *50,450 - 37,750 74.8%44,475 - 41,733 93.8%10,600 - 10,600 100.0% JeffComCap 119 119 *264,695 10,209 220,579 83.3%254,838 21,221 212,397 83.3%276,062 24,172 230,264 83.4% Crime Victim's Svc 120 110,757 27,330 109,693 99.0%99,707 1,009 76,456 76.7%79,335 23,827 76,921 97.0% Grant Mgmt 123 150,000 - 82,211 54.8%76,723 - 58,345 76.0%95,126 - 61,954 65.1% Hotel-Motel 125 500,500 65,200 433,636 86.6%507,868 58,458 405,944 79.9%449,148 59,970 365,065 81.3% Jeff Co Public Health 127 *4,372,775 310,038 3,859,976 88.3%4,064,163 380,814 3,425,547 84.3%4,076,806 230,435 3,424,294 84.0% Water Quality 128 960,714 102,124 833,641 86.8%975,455 104,598 806,344 82.7%999,219 100,859 794,547 79.5% Mental Health 130 45,150 15,368 45,566 100.9%47,474 14,543 43,269 91.1%46,854 13,494 42,553 90.8% Chem Dep Mnt Hlth tx 131 490,490 54,624 469,750 95.8%516,131 47,850 424,756 82.3%500,457 46,898 411,364 82.2% Drug Fund 135 18,288 818 11,015 60.2%11,819 768 9,974 84.4%23,562 1,350 21,521 91.3% Law Library 140 10,150 954 8,437 83.1%10,049 905 8,399 83.6%9,692 873 8,088 83.5% Trial Court Imprvmnt 141 25,000 5,798 23,201 92.8%23,449 - 11,726 50.0%22,669 5,766 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 158,233 1,239,010 69.1%1,418,569 78,776 1,185,416 83.6%1,668,687 77,286 1,361,769 81.6% Federal Forest Title III 147 - 157 19,813 - 70 526 - 32 21,888 Jeff Co Affrdbl Hsg 148 *318,881 33,096 255,314 80.1%250,150 24,965 208,847 83.5%243,809 22,866 202,360 83.0% Treasurer's O & M 150 47,280 60 25,135 53.2%28,653 99 19,374 67.6%23,981 1,631 17,101 71.3% REET technology 151 14,420 1,323 13,689 94.9%16,827 1,520 14,012 83.3%16,194 1,419 13,526 83.5% Veteran's Relief 155 59,820 15,660 65,646 109.7%65,060 14,789 60,671 93.3%63,652 13,693 59,244 93.1% Water Pollution Cntrl 160 - - - - - - 18,607 941 18,607 100.0% Park & Rec 174 659,282 44,125 536,787 81.4%625,429 11,962 455,918 72.9%569,174 9,646 422,009 74.1% County Park Imprvmnt 175 *146,185 19,391 155,541 106.4%119,426 2,729 86,866 72.7%84,284 722 83,828 99.5% County Roads 180 7,838,108 1,830,607 7,926,629 101.1%9,773,015 2,264,110 8,485,436 86.8%8,949,637 1,509,489 6,823,164 76.2% Facilities Mgmt 183 1,074,934 89,735 939,416 87.4%1,040,019 86,631 866,756 83.3%1,116,468 87,082 942,606 84.4% County Fair 199 250,000 13,665 235,359 94.1%308,594 10,943 294,258 95.4%269,769 13,406 249,787 92.6% Total Special Revenue 19,921,894 2,838,362 18,122,584 91.0%20,945,389 3,215,674 17,735,608 84.7%20,321,124 2,277,610 16,236,424 79.9% * 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 Oct YTD YTD YTD Oct YTD YTD Budget Oct YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 6,308 46,679 4.7%517,754 3,510 515,341 99.5%1,113,333 1,721 838,333 75.3% Capital Improvement 302 1,072,938 167,081 1,093,228 101.9%1,285,270 113,373 1,065,339 82.9%1,537,774 137,192 1,079,347 70.2% Public Infrastructure 306 451,400 51,053 439,283 97.3%477,127 46,069 395,800 83.0%456,854 42,109 374,839 82.0% Conservation Futures 308 239,400 82,535 257,513 107.6%256,431 77,596 232,939 90.8%244,237 70,062 221,545 90.7% Total CAP IMP 2,763,738 306,977 1,836,702 66.5%2,536,581 240,548 2,209,419 87.1%3,352,198 251,084 2,514,064 75.0% ENTERPRISE Solid Waste 401 3,357,942 315,183 3,049,153 90.8%3,488,829 284,390 2,942,027 84.3%3,481,538 281,921 2,935,131 84.3% Solid Waste Post Clos 402 150 99 795 530.1%516 154 646 125.3%335 37 269 80.3% Solid Waste Eqpt Res 403 4,000 1,589 12,510 312.7%7,601 2,162 9,047 119.0%302,768 306 2,206 0.7% Yard Waste Educ Fnd 404 5,800 11 91 1.6%5,750 1 24 0.4%1,781 4 32 1.8% Tri Area Sewer 405 *255,399 30,533 39,798 15.6%297,554 590 5,541 1.9%172,740 288 2,251 1.3% Total ENTERPRISE 3,623,291 347,414 3,102,346 85.6%3,800,250 287,296 2,957,284 77.8%3,959,162 282,556 2,939,889 74.3% INTERNAL SERVICE Equipment Rental 501 2,451,202 367,983 1,992,483 81.3%2,508,636 171,654 2,058,816 82.1%2,179,575 188,374 1,732,503 79.5% 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,628 212,206 102.0%225,590 14,778 198,491 88.0%215,434 13,383 192,252 89.2% Information Services 506 2,103,298 448,675 1,910,138 90.8%1,832,926 438,214 1,705,879 93.1%1,551,832 384,323 1,504,355 96.9% Total INT SERV 4,977,500 831,286 4,142,258 83.2%4,679,922 624,647 4,038,297 86.3%4,004,508 586,080 3,444,144 86.0% Total 31,286,423 4,324,039 27,203,891 87.0%31,962,142 4,368,165 26,940,608 84.3%31,636,992 3,397,330 25,134,522 79.4% GENERAL FUND CASH BALANCE REPORT 11/5/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$ 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 10 October 11/5/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 10.0%305,512 - December 155,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,603,315 100.0%$3,040,000 $2,603,315 ytd 1,767,762 1,567,333 1,641,937 1,664,085 1,958,663 1,873,754 2,050,133 2,229,330 2,376,608 2,603,315 2,497,713 2,603,315 ytd change -11.34%4.76%1.35%17.70%-4.34%9.41%8.74%6.61%9.54%4.23%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 10.1%96,836 - 402,348 - 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 818,495 100.0%955,428 818,495 3,995,428 3,421,809 ytd 587,361 571,459 628,829 720,441 742,780 $818,495 784,365 $818,495 3,282,078 $3,421,809 4.3%4.35%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 October 10 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$ 75,648$ 70,102$ -$ 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,045,290 1,106,090$ 1,025,000$ 1,045,290$ 2% YTD 455,568$ 366,374$ 382,801$ 431,935$ 518,201$ 561,365$ 1,028,461$ 1,079,347$ 1,065,339$ $1,045,290 933,628$ 865,181$ 1,045,290$ 21% Y/Y chg -19.58%4.48%12.84%19.97%8.33%83.21%4.95%-1.30%-1.88% 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 Aug 2017 1@$1.024, 1@1.37 and 11>$500k Apr 2018 1@2.16M, 11 Res>$500k 11/7/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 10 October 11/5/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$ 58,225$ 69,428$ 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$ 433,636$ 419,737$ 500,500$ 433,636$ YTD 257,007$ 230,602$ 233,094$ 225,781$ 240,540$ 255,088$ 301,928$ 365,065$ 405,944$ 433,636$ 332,006$ 395,888$ 433,636$ 9.5% $- $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