Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-05_BC_RevenueReports-extra page
2018 5 May General Fund 8-Jun-2018 Jefferson County Treasurer REVENUE NAME BARS BUDGET MAY Y-T-D Y-T-D ACTUAL MAY Y-T-D Y-T-D ACTUAL MAY Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % Property Tax 1 311.10 7,850,027 632,604 4,365,455 55.6%7,643,881 944,457 4,295,530 56.2%7,514,257 790,542 4,218,249 56.1% Diverted Road Prop Tax 1 311.20 720,000 62,614 403,600 56.1%720,000 95,787 407,869 56.6%720,000 79,893 407,454 56.6% Private Harvest Tax 2 317.40.10/.20 335,000 123,357 309,599 92.4%377,824 91,045 171,790 45.5%281,335 111,309 183,394 65.2% Sales Tax 1 313.11 3,040,000 271,431 1,168,163 38.4%2,876,339 249,596 1,129,268 39.3%2,738,244 226,291 1,050,738 38.4% special purpose 313.15 955,428 84,357 372,467 39.0%903,099 78,716 354,212 39.2%876,170 74,233 337,545 38.5% Local Criminal Justice 1 313.71 380,070 35,044 155,486 40.9%375,219 32,611 146,234 39.0%364,508 30,646 140,099 38.4% Leasehold Excise Tax 3 317.20 62,000 - 14,908 24.0%69,801 - 18,293 26.2%55,407 - 16,069 29.0% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 8,542 30,268 37.8%90,727 8,328 34,706 38.3%84,213 8,549 27,978 33.2% Penalties on delinquent taxes 1 359.40.10/.20 133,332 8,888 45,607 34.2%98,944 13,137 45,108 45.6%112,239 14,525 54,287 48.4% Interest on delinquent taxes 1 361.40.10 210,000 33,387 93,478 44.5%193,625 41,254 94,398 48.8%213,458 42,624 112,910 52.9% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 572,220 - 0 0.0%1,458,645 - 0 0.0%1,476,638 - 0 0.0% P.U.D. Privilege Tax 4 335.00.91 323,420 - 0 0.0%314,148 - 0 0.0%318,107 - 0 0.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 463,500 4,288 216,268 46.7%435,778 - 219,545 50.4%477,057 - 257,512 54.0% Marijuana Enforcement/Excise 6 336.06.41-42 24,720 - 27,251 110.2%21,297 - 5,676 26.7%36,920 - 12,784 34.6% Liquor Excise Tax 8 336.06.94 41,536 - 23,707 57.1%44,174 - 22,491 50.9%41,772 - 21,411 51.3% Liquor Profit 6 336.06.95 90,203 - 21,065 23.4%84,441 - 21,155 25.1%84,749 - 21,220 25.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 - 195,627 59.5%143,455 - 19,800 13.8%294,890 17,692 17,692 6.0% Investment Income 1 361.11 230,000 47,617 186,312 81.0%354,385 22,721 177,054 50.0%682,617 12,934 39,618 5.8% Treasurer Invest & Other Fees 1 341.42.15-20/50 16,290 12,270 24,981 153.4%33,805 4,504 19,010 56.2%11,599 756 3,435 29.6% DNR Timber 1 395.1.1 250,000 1,127 4,907 2.0%207,899 - 0 0.0%336,350 - 212,153 63.1% Transfer in 1 397.00 3,000 750 7,982 266.1%40,322 750 7,319 18.2%46,441 750 21,687 46.7% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 544 3,759 31.6%9,020 464 2,516 27.9%10,807 1,595 10,807 100.0% Assessor 1 001-010-000 8,700 1,821 3,814 43.8%10,970 1,879 4,069 37.1%8,761 1,788 3,963 45.2% Auditor-Recording Fees 1 341.21.10 72,063 6,468 29,169 40.5%74,248 6,134 30,511 41.1%74,077 6,524 27,726 37.4% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 17,615 101,822 43.8%242,031 16,985 107,605 44.5%229,927 14,525 100,153 43.6% Auditor-Other Revenue 1 26,605 2,797 13,498 50.7%29,714 2,586 13,199 44.4%32,440 2,596 13,362 41.2% Elections 1 001-021-000 146,191 12,207 76,227 52.1%138,996 122 24,197 17.4%160,903 6,007 73,405 45.6% Clerk 1 001-020-000 170,768 19,156 74,688 43.7%179,130 14,338 74,952 41.8%192,402 20,038 82,730 43.0% County Administrator 1 001-059-000 4,260 - 4,260 3,700 0 0 Commissioners 1 001-060-000 8,000 825 3,612 45.2%8,923 703 3,610 40.5%8,609 760 3,264 37.9% Safety & Security 1 001-067-000 64,959 - 30,414 46.8%66,877 11,688 29,574 44.2%70,305 12,399 27,802 39.5% Community Services 1 001-068-000 6,900 34 1,310 19.0%4,611 58 2,002 43.4%8,269 40 2,237 27.0% District Court 1 001-080-000 603,032 47,567 199,411 33.1%596,433 136,472 285,345 47.8%632,629 46,824 222,075 35.1% Juvenile Service 1 001-110-000 259,676 32,392 120,120 46.3%290,984 13,434 99,708 34.3%260,358 35,614 118,365 45.5% Prosecuting Attorney 1 001-150-000 178,690 11,247 43,799 24.5%151,185 11,109 81,803 54.1%124,918 10,851 68,796 55.1% Coroner 1 001-151-000 25,348 - 18,140 71.6%24,610 - 24,610 100.0%8,340 - 8,340 100.0% Sheriff 1 001-180-000 563,077 59,652 162,039 28.8%722,960 24,816 181,413 25.1%626,703 22,297 272,032 43.4% Superior Court 1 001-240-000 40,038 14,203 26,043 65.0%90,193 42,160 46,660 51.7%26,142 5,411 15,321 58.6% Non Departmental 1 001-270-000 50,447 - 32,802 65.0%49,196 10 0.0%10 10 TOTAL CURRENT EXPENSE 18,582,629 1,552,803 8,612,059 46.3%19,181,590 1,865,851 8,201,243 42.8%19,242,572 1,598,010 8,206,620 42.6% * 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 exclud 388/89 295.09 10,868 253,160 1,846.71 2,026 194,294 1,147.84 6,377 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view May 5 6/8/2018 FUND Fund #Budget May YTD YTD ACTUAL May YTD YTD ACTUAL May YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,429 10,872 14.4%77,983 2,172 10,815 13.9%74,342 2,344 10,036 13.5% Court Facilitator 106 5,100 300 2,020 39.6%5,920 580 2,700 45.6%6,220 380 2,360 37.9% Boating Safety 107 48,740 15,000 30,607 62.8%49,100 15,000 30,458 62.0%61,493 15,000 39,200 63.7% WSU Cooperative 108 510,294 98,797 297,649 58.3%534,494 78,554 237,600 44.5%528,605 81,930 283,953 53.7% 4-H After School 113 37,250 - 32,250 86.6%44,475 - 22,733 51.1%10,600 - 10,600 100.0% JeffComCap 119 119 204,000 22,058 110,290 54.1%254,838 21,221 106,292 41.7%276,062 22,899 114,496 41.5% Crime Victim's Svc 120 110,757 22,507 51,692 46.7%99,707 24,548 52,137 52.3%79,335 5,530 23,377 29.5% Grant Mgmt 123 150,000 10,542 61,479 41.0%76,723 6,029 50,103 65.3%95,126 497 61,954 65.1% Hotel-Motel 125 500,500 41,061 153,631 30.7%507,868 45,943 156,219 30.8%449,148 29,462 132,096 29.4% Jeff Co Public Health 127 3,956,447 486,799 1,889,033 47.7%4,064,163 484,777 1,972,620 48.5%4,076,806 447,675 2,010,653 49.3% Water Quality 128 960,714 58,131 417,003 43.4%975,455 170,484 519,444 53.3%999,219 107,969 477,501 47.8% Mental Health 130 45,150 4,289 26,892 59.6%47,474 5,925 25,806 54.4%46,854 5,142 26,507 56.6% Chem Dep Mnt Hlth tx 131 490,490 48,179 213,767 43.6%516,131 44,950 201,474 39.0%500,457 42,176 192,632 38.5% Drug Fund 135 18,288 895 5,523 30.2%11,819 883 5,118 43.3%23,562 2,298 6,726 28.5% Law Library 140 10,150 818 4,245 41.8%10,049 825 3,975 39.6%9,692 674 3,773 38.9% Trial Court Imprvmnt 141 25,000 - 11,605 46.4%23,449 - 5,863 25.0%22,669 - 11,236 49.6% Public Defense Fnd 142 35,000 - - 0.0%0 - - 0.0%36,673 - - 0.0% Community Develpmnt 143 1,663,379 195,890 599,761 36.1%1,418,569 178,899 622,951 43.9%1,668,687 277,973 773,606 46.4% Jeff Co Affrdbl Hsg 148 237,381 23,056 99,338 41.8%250,150 20,715 100,193 40.1%243,809 22,149 93,336 38.3% Treasurer's O & M 150 47,280 3,230 8,337 17.6%28,653 4,100 5,787 20.2%23,981 2,713 7,126 29.7% REET technology 151 14,420 1,432 6,320 43.8%16,827 1,362 6,174 36.7%16,194 1,407 6,076 37.5% Veteran's Relief 155 59,820 4,440 44,486 74.4%65,060 6,052 42,662 65.6%63,652 5,233 42,802 67.2% Water Pollution Cntrl 160 - - - - - - 18,607 - 10,315 55.4% Park & Rec 174 648,380 142,424 304,154 46.9%625,429 116,132 288,723 46.2%569,174 124,619 261,382 45.9% County Park Imprvmnt 175 131,185 60,332 62,615 47.7%119,426 6,147 7,479 6.3%84,284 53,302 55,672 66.1% County Roads 180 7,838,108 925,362 4,023,463 51.3%9,773,015 697,254 4,141,328 42.4%8,949,637 661,738 3,842,381 42.9% Facilities Mgmt 183 1,074,934 90,086 478,208 44.5%1,040,019 86,672 433,129 41.6%1,116,468 86,931 507,801 45.5% County Fair 199 250,000 14,478 76,758 30.7%308,594 19,568 103,727 33.6%269,769 15,999 84,223 31.2% Total Special Revenue 19,148,104 2,258,059 9,021,999 47.1%20,945,389 2,019,225 9,155,509 43.7%20,321,124 2,000,038 9,091,820 44.7% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget May YTD YTD YTD May YTD YTD Budget May YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 2,000 5,617 0.6%517,754 9,999 511,754 98.8%1,113,333 274,257 559,891 50.3% Capital Improvement 302 1,072,938 128,185 421,120 39.2%1,285,270 111,101 407,461 31.7%1,537,774 108,945 374,056 24.3% Public Infrastructure 306 451,400 44,830 199,531 44.2%477,127 41,666 185,885 39.0%456,854 38,501 175,640 38.4% Conservation Futures 308 239,400 23,600 146,248 61.1%256,431 31,665 137,778 53.7%244,237 26,688 137,446 56.3% Total CAP IMP 2,763,738 198,615 772,515 28.0%2,536,581 194,431 1,242,878 49.0%3,352,198 448,391 1,247,033 37.2% ENTERPRISE Solid Waste 401 3,357,942 296,521 1,347,429 40.1%3,488,829 268,516 1,308,636 37.5%3,481,538 433,989 1,344,059 38.6% Solid Waste Post Clos 402 150 80 346 231.0%516 56 222 43.0%335 22 101 30.2% Solid Waste Eqpt Res 403 4,000 1,257 5,406 135.2%7,601 779 3,101 40.8%302,768 182 830 0.3% Yard Waste Educ Fnd 404 5,800 9 38 0.6%5,750 3 11 0.2%1,781 3 14 0.8% Tri Area Sewer 405 226,000 1,094 4,766 2.1%297,554 480 2,734 0.9%172,740 206 884 0.5% Total ENTERPRISE 3,593,892 298,961 1,357,985 37.8%3,800,250 269,834 1,314,704 34.6%3,959,162 434,402 1,345,889 34.0% INTERNAL SERVICE Equipment Rental 501 2,451,202 172,749 755,212 30.8%2,508,636 203,749 744,761 29.7%2,179,575 149,572 648,971 29.8% Risk Management 502 215,000 - 0 0.0%112,770 - - 0.0%57,666 - 178 0.3% Benefit Reserve 505 208,000 22,391 114,927 55.3%225,590 21,505 108,942 48.3%215,434 19,906 106,644 49.5% Information Services 506 2,103,298 6,333 994,029 47.3%1,832,926 10,796 821,413 44.8%1,551,832 2,165 733,849 47.3% Total INT SERV 4,977,500 201,473 1,864,167 37.5%4,679,922 236,050 1,675,116 35.8%4,004,508 171,643 1,489,642 37.2% Total 30,483,234 2,957,108 13,016,666 42.7%31,962,142 2,719,539 13,388,207 41.9%31,636,992 3,054,474 13,174,384 41.6% GENERAL FUND CASH BALANCE REPORT 6/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$ 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$ 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$ 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$ 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$ 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 Budg ***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,653,611 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,927,611 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 GENERAL FUND END OF MONTH CASH BALANCE 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 5 May 6/8/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/UnderJanuary152,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 7.4%225,655 - July 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 7.7%235,089 - August 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 10.2%310,571 - September 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 8.8%268,857 - October 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 9.4%285,439 - November 213,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 1,168,163 100.0%$3,040,000 $1,168,163 ytd 879,743 777,837 781,519 735,423 969,922 884,203 943,488 1,050,738 1,129,268 1,168,163 1,172,101 1,168,163 ytd change -11.58%0.47%-5.90%31.89%-8.84%6.70%11.37%7.47%3.44%-0.34%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 Actual20122013201420152016201720182015-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 7.4%71,153 - 296,808 - July 49,385 68,295 54,074 56,793 69,908 73,136 7.8%74,924 - 310,013 - August 56,220 56,063 68,712 76,734 87,275 89,679 10.0%95,114 - 405,686 - September 54,902 61,455 64,622 72,022 77,854 77,534 8.9%85,262 - 354,119 - October 61,120 64,400 64,152 73,903 82,028 82,991 9.4%89,578 - 375,017 - 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 372,467 100.0%955,428 372,467 3,995,428 1,540,629 ytd 287,081 271,252 290,659 337,545 354,212 $372,467 368,334 $372,467 1,540,435 $1,540,629 0.0%1.12%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 May 5 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$ 144,702$ 134,093$ -$ July 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 97,339$ 90,203$ -$ August 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 95,860$ 88,833$ -$ September 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 142,117$ 131,698$ -$ October 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 104,607$ 96,938$ -$ 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 $421,120 1,106,090$ 1,025,000$ 421,120$ -59% YTD 255,642$ 187,136$ 206,222$ 193,477$ 201,188$ 229,439$ 385,057$ 374,056$ 407,461$ $421,120 349,003$ 323,417$ 421,119.58$ 30% Y/Y chg -26.80%10.20%-6.18%3.99%14.04%67.83%-2.86%8.93%3.35% 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 Mar 2017 6 Res>$500k Nov 2017 12 sales>$500k Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k Dec 2017 1 sale @ $1.529M, 11>$500k May 2017 1@$1.098, 1@$1.035, 6 Res>$500k Jan 2018 no unincorp sales>$445k Jun 2017 1@$1.05, 16>$500k Feb 2018 1@1.435M, 3 Res>$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 6/8/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 5 May 6/8/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$ 45,060$ 42,667$ 50,876$ 45,060$ -11.4% 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$ 26,204$ 31,247$ July 20,155$ 14,326$ 19,311$ 20,201$ 21,512$ 24,536$ 27,711$ 33,687$ 38,400$ 31,083$ 37,064$ August 35,178$ 36,076$ 24,742$ 31,171$ 33,140$ 37,534$ 48,845$ 56,349$ 64,820$ 51,887$ 61,871$ September 41,757$ 40,208$ 42,500$ 40,882$ 39,890$ 42,349$ 44,713$ 53,487$ 56,561$ 49,278$ 58,759$ October 43,012$ 46,548$ 43,861$ 41,015$ 41,741$ 43,659$ 49,182$ 59,970$ 58,458$ 52,817$ 62,980$ 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$ 152,466$ 419,737$ 500,500$ 152,466$ YTD 97,700$ 73,794$ 85,378$ 74,596$ 87,780$ 88,224$ 106,406$ 132,096$ 156,219$ 152,466$ 120,736$ 143,968$ 152,466$ 5.9% $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 2018 HOTEL/MOTEL LODGING TAX -Fund 125 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018