Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-03_BC Revenue Reports
2018 3 March General Fund Jefferson County Treasurer 6-Apr-2018 REVENUE NAME BARS BUDGET MAR Y-T-D Y-T-D ACTUAL MAR Y-T-D Y-T-D ACTUAL MAR Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % Property Tax 1 311.10 7,850,027 464,793 817,533 10.4%7,643,881 529,547 855,100 11.2%7,514,257 467,615 841,663 11.2% Diverted Road Prop Tax 1 311.20 720,000 44,191 77,282 10.7%720,000 51,106 83,584 11.6%720,000 45,987 83,604 11.6% Private Harvest Tax 2 317.40.10/.20 335,000 - 186,243 55.6%377,824 - 80,745 21.4%281,335 - 72,085 25.6% Sales Tax 1 313.11 3,040,000 206,999 694,199 22.8%2,876,339 189,576 685,810 23.8%2,738,244 194,466 643,063 23.5% special purpose 313.15 955,428 66,479 224,325 23.5%903,099 61,183 215,586 23.9%876,170 62,285 203,831 23.3% Local Criminal Justice 1 313.71 380,070 28,024 93,674 24.6%375,219 24,824 88,485 23.6%364,508 25,745 84,717 23.2% Leasehold Excise Tax 3 317.20 62,000 - 13,824 22.3%69,801 - 13,291 19.0%55,407 - 15,378 27.8% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 5,723 14,793 18.5%90,727 7,167 20,901 23.0%84,213 6,076 13,407 15.9% Penalties on delinquent taxes 1 359.40.10/.20 133,332 5,424 22,565 16.9%98,944 6,824 23,088 23.3%112,239 9,893 25,018 22.3% Interest on delinquent taxes 1 361.40.10 210,000 9,860 30,757 14.6%193,625 11,399 31,781 16.4%213,458 19,450 38,047 17.8% 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 - 108,130 23.3%435,778 - 109,769 25.2%477,057 - 128,762 27.0% Marijuana Enforcement/Excise 6 336.06.41 24,720 27,251 27,251 110.2%21,297 5,676 5,676 26.7%36,920 12,784 12,784 34.6% Liquor Excise Tax 8 336.06.94 41,536 - 10,819 26.0%44,174 - 10,241 23.2%41,772 - 9,372 22.4% Liquor Profit 6 336.06.95 90,203 21,065 21,065 23.4%84,441 21,155 21,155 25.1%84,749 21,220 21,220 25.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 - 186,331 56.7%143,455 - 9,022 6.3%294,890 - 0 0.0% Investment Income 1 361.11 230,000 39,823 101,014 43.9%354,385 114,564 135,660 38.3%682,617 19,888 23,829 3.5% Treasurer Invest & Other Fees 1 341.42.15-19/50 16,290 2,644 7,677 47.1%33,805 2,153 10,292 30.4%11,599 704 1,901 16.4% DNR Timber 1 395.1.1 250,000 2,090 2,539 1.0%207,899 - 0 0.0%336,350 68,367 212,153 63.1% Transfer in 1 397.00 3,000 6,482 7,232 241.1%40,322 0 750 1.9%46,441 20,187 20,937 45.1% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 762 2,566 21.6%9,020 919 1,645 18.2%3,854 1,264 3,854 100.0% Assessor 1 001-010-000 8,700 70 1,954 22.5%10,970 69 2,054 18.7%8,761 20 2,138 24.4%Auditor-Recording Fees 1 341.21.10 72,063 6,178 16,358 22.7%74,248 6,727 18,746 25.2%74,077 5,457 15,392 20.8% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 47,364 70,415 30.3%242,031 55,376 76,439 31.6%229,927 14,259 70,925 30.8% Auditor-Other Revenue 1 26,605 2,626 7,623 28.7%29,714 3,520 8,732 29.4%32,440 1,961 7,335 22.6% Elections 1 001-021-000 146,191 10,454 63,487 43.4%138,996 22,206 22,206 16.0%160,903 19,169 51,816 32.2% Clerk 1 001-020-000 170,768 13,717 44,518 26.1%179,130 13,920 41,219 23.0%192,402 14,198 44,998 23.4% County Administrator 1 001-059-000 4,260 0 4,260 3,700 0 0 Commissioners 1 001-060-000 8,000 711 1,958 24.5%8,923 851 2,250 25.2%8,609 661 1,820 21.1% Safety & Security 1 001-067-000 64,959 0 15,742 24.2%66,877 0 9,636 14.4%70,305 0 15,403 21.9% Community Services 1 001-068-000 6,900 29 421 6.1%4,611 157 1,898 41.2%8,269 46 1,194 14.4% District Court 1 001-080-000 603,032 45,171 113,796 18.9%596,433 44,759 110,228 18.5%632,629 42,053 129,324 20.4% Juvenile Service 1 001-110-000 259,676 34,167 73,951 28.5%290,984 26,629 69,566 23.9%260,358 17,491 70,518 27.1% Prosecuting Attorney 1 001-150-000 178,690 7,169 25,503 14.3%151,185 7,746 62,661 41.4%124,918 19,405 44,159 35.4% Coroner 1 001-151-000 25,348 1,700 1,700 6.7%24,610 24,610 24,610 100.0%8,340 - 8,340 100.0% Sheriff 1 001-180-000 563,077 24,767 93,388 16.6%722,960 71,242 142,917 19.8%626,703 109,030 138,464 22.1% Superior Court 1 001-240-000 40,038 25 11,840 29.6%90,193 - 4,500 5.0%26,142 - 9,911 37.9% 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,125,759 3,229,534 17.4%19,181,590 1,303,903 3,000,252 15.6%19,235,620 1,219,677 3,067,372 15.9% * 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 9,039 253,160 8.01 58 194,294 1942.74 2,936 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view 4/6/2018 March 3 FUND Fund #Budget Mar YTD YTD ACTUAL Mar YTD YTD ACTUAL Mar YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,192 6,057 8.0%77,983 2,419 6,645 8.5%74,342 2,018 5,579 7.5% Court Facilitator 106 5,100 300 1,340 26.3%5,920 880 1,720 29.1%6,220 500 1,480 23.8% Boating Safety 107 48,740 - - 0.0%49,100 - 218 0.4%61,493 - 8,787 14.3% WSU Cooperative 108 510,294 36,541 109,620 21.5%534,494 25,044 104,434 19.5%528,605 34,969 134,270 25.4% 4-H After School 113 37,250 2,500 29,750 79.9%44,475 1,783 22,733 51.1%10,600 - 10,600 100.0% JeffComCap 119 119 204,000 22,058 66,174 32.4%254,838 21,221 63,851 25.1%276,062 22,899 68,698 24.9% Crime Victim's Svc 120 110,757 1,607 26,726 24.1%99,707 1,379 26,239 26.3%79,335 1,677 16,562 20.9% Grant Mgmt 123 150,000 17,840 42,062 28.0%76,723 9,152 29,063 37.9%95,126 15,306 51,123 53.7% Hotel-Motel 125 500,500 19,419 88,821 17.7%507,868 16,889 89,375 17.6%449,148 14,554 84,104 18.7% Jeff Co Public Health 127 3,956,447 235,719 1,048,414 26.5%4,064,163 308,280 1,133,792 27.9%4,076,806 261,539 1,336,048 32.8% Water Quality 128 960,714 47,214 216,532 22.5%975,455 101,680 206,780 21.2%999,219 107,331 197,741 19.8% Mental Health 130 45,150 2,693 5,754 12.7%47,474 3,059 5,425 11.4%46,854 3,051 6,397 13.7% Chem Dep Mnt Hlth tx 131 490,490 38,529 128,787 26.3%516,131 34,220 121,976 23.6%500,457 35,431 116,413 23.3% Drug Fund 135 18,288 2,037 3,677 20.1%11,819 1,062 3,228 27.3%23,562 1,184 3,353 14.2% Law Library 140 10,150 749 2,093 20.6%10,049 1,011 2,450 24.4%9,692 826 2,281 23.5% Trial Court Imprvmnt 141 25,000 - 5,807 23.2%23,449 - 5,863 25.0%22,669 - 5,618 24.8% Public Defense Fnd 142 35,000 - - 0.0%0 - - 0.0%36,673 - - 0.0% Community Develpmnt 143 1,663,379 86,980 337,472 20.3%1,418,569 75,419 350,224 24.7%1,668,687 118,315 394,978 23.7% Jeff Co Affrdbl Hsg 148 237,381 20,399 56,491 23.8%250,150 22,658 61,150 24.4%243,809 18,391 51,378 21.1% Treasurer's O & M 150 47,280 1,815 2,904 6.1%28,653 22 60 0.2%23,981 212 2,539 10.6% REET technology 151 14,420 1,151 3,561 24.7%16,827 1,140 3,497 20.8%16,194 1,059 3,302 20.4% Veteran's Relief 155 59,820 2,804 22,886 38.3%65,060 3,132 21,926 33.7%63,652 3,111 22,386 35.2% Water Pollution Cntrl 160 - - - - - - 18,607 10,115 10,315 55.4% Park & Rec 174 648,380 12,513 155,159 23.9%625,429 10,573 166,995 26.7%569,174 14,161 133,206 23.4% County Park Imprvmnt 175 131,185 - - 0.0%119,426 - - 0.0%84,284 276 312 0.4% County Roads 180 7,838,108 457,672 1,604,914 20.5%9,773,015 1,584,715 2,139,938 21.9%8,949,637 1,056,586 1,764,355 19.7% Facilities Mgmt 183 1,074,934 119,626 298,544 27.8%1,040,019 97,034 259,826 25.0%1,116,468 89,200 322,981 28.9% County Fair 199 250,000 41,669 55,497 22.2%308,594 12,413 25,395 8.2%269,769 9,029 22,238 8.2% Total Special Revenue 19,148,104 1,132,357 4,319,041 22.6%20,945,389 2,322,772 4,852,801 23.2%20,321,124 1,812,711 4,777,043 23.5% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Mar YTD YTD YTD Mar YTD YTD Budget Mar YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 - 1,808 0.2%517,754 - 501,755 96.9%1,113,333 68 285,634 25.7% Capital Improvement 302 1,072,938 75,558 190,455 17.8%1,285,270 91,388 217,838 16.9%1,537,774 79,657 187,949 12.2% Public Infrastructure 306 451,400 36,079 120,072 26.6%477,127 31,506 112,086 23.5%456,854 32,307 106,018 23.2% Conservation Futures 308 239,400 14,985 32,728 13.7%256,431 16,427 29,472 11.5%244,237 15,894 33,422 13.7% Total CAP IMP 2,763,738 126,622 345,064 12.5%2,536,581 139,321 861,152 33.9%3,352,198 127,925 613,023 18.3% ENTERPRISE Solid Waste 401 3,357,942 251,170 747,833 22.3%3,488,829 304,335 753,154 21.6%3,481,538 264,825 776,385 22.3% Solid Waste Post Clos 402 150 70 192 128.3%516 41 118 22.9%335 21 55 16.5% Solid Waste Eqpt Res 403 4,000 1,093 2,993 74.8%7,601 571 1,649 21.7%302,768 172 452 0.1% Yard Waste Educ Fnd 404 5,800 7 20 0.3%5,750 2 6 0.1%1,781 3 8 0.4% Tri Area Sewer 405 226,000 877 2,636 1.2%297,554 344 1,834 0.6%172,740 181 472 0.3% Total ENTERPRISE 3,593,892 253,217 753,674 21.0%3,800,250 305,292 756,761 19.9%3,959,162 265,202 777,372 19.6% INTERNAL SERVICE Equipment Rental 501 2,451,202 189,105 411,820 16.8%2,508,636 171,147 413,679 16.5%2,179,575 297,465 342,666 15.7% Risk Management 502 215,000 - 0 0.0%112,770 - - 0.0%57,666 - - 0.0% Benefit Reserve 505 208,000 21,507 69,485 33.4%225,590 20,584 64,619 28.6%215,434 23,503 65,311 30.3% Information Services 506 2,103,298 49,827 534,525 25.4%1,832,926 43,447 423,081 23.1%1,551,832 647 348,252 22.4% Total INT SERV 4,977,500 260,439 1,015,831 20.4%4,679,922 235,179 901,380 19.3%4,004,508 321,615 756,228 18.9% Total 30,483,234 1,772,635 6,433,609 21.1%31,962,142 3,002,564 7,372,093 23.1%31,636,992 2,527,454 6,923,667 21.9% GENERAL FUND CASH BALANCE REPORT 4/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$ 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$ 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 3 March GENERAL SALES TAX RECEIPTS 4/6/2018 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End 3 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 96.28%$2,927,043 -$112,957 April 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 6.7%203,686 - May 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 8.4%256,612 - June 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 694,199 100.0%$3,040,000 $694,199ytd 549,637 471,619 475,166 459,855 600,029 551,913 567,988 643,063 685,810 694,199 711,803 694,199 ytd change -14.19%0.75%-3.22%30.48%-8.02%2.91%13.22%6.65%1.22%-2.47%over (under) ytd expected annual % chg.-10.25%2.64%3.98%14.73%-2.03%8.07%10.12% Special Purp./Public Safety Tax Actual Actual Actual 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 6.7%64,462 - 268,148 - May 51,908 58,324 56,012 62,613 74,233 78,716 8.5%80,820 - 337,432 - 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 224,325 100.0%955,428 224,325 3,995,428 918,525 ytd 177,703 167,667 175,505 203,831 215,586 $224,325 223,052 $224,325 934,855 $918,525 -1.7% 0.57%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 March 3 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$ 68,249$ 63,245$ -$ May 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 88,832$ 82,320$ -$ 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 $190,455 1,106,090$ 1,025,000$ 190,455$ -81% YTD 200,562$ 95,239$ 157,229$ 98,437$ 89,794$ 111,709$ 250,192$ 187,949$ 217,838$ $190,455 191,922$ 177,852$ 190,455$ 7% Y/Y chg -52.51%65.09%-37.39%-8.78%24.41%123.97%-24.88%15.90%-12.57% Jan 2017 1@1.565M, 6 Res>$500k Sept 2017 12>$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 ----1@1.435M, 3 Res>$500k Aug 2017 1@$1.024, 1@1.37 and 11>$500k 3/9/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 3 March 4/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$ 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$ 16,710$ 19,926$ May 19,646$ 19,561$ 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 29,611$ 35,308$ 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$ 87,656$ 419,737$ 500,500$ 87,656$ YTD 66,710$ 42,299$ 49,445$ 42,504$ 58,340$ 56,646$ 67,537$ 84,104$ 89,375$ 87,656$ 74,415$ 88,734$ 87,656$ -1.2% $- $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