Loading...
HomeMy WebLinkAbout2018-09_BC_RevenueReports2018 9 September General Fund 10-Oct-2018 Jefferson County TreasurerREVENUE NAME BARS BUDGET SEP Y-T-D Y-T-D ACTUAL SEP Y-T-D Y-T-D ACTUAL SEP Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 %Property Tax 1 311.10 7,850,027 151,258 4,660,319 59.4%7,643,881 139,973 4,563,803 59.7%7,514,257 144,452 4,494,533 59.8% Diverted Road Prop Tax 1 311.20 720,000 13,383 430,671 59.8%720,000 12,853 433,121 60.2%720,000 13,579 433,795 60.2% Sales Tax 1 313.11 3,040,000 307,750 2,296,483 75.5%2,876,339 241,325 2,109,343 73.3%2,738,244 247,376 1,975,327 72.1% special purpose 313.15 955,428 97,036 723,021 75.7%903,099 77,534 659,790 73.1%876,170 77,854 638,413 72.9%Local Criminal Justice 1 313.71 380,070 40,861 302,199 79.5%375,219 32,265 273,880 73.0%364,508 32,302 265,166 72.7%Leasehold Excise Tax 3 317.20 62,000 - 48,627 78.4%69,801 - 50,748 72.7%55,407 - 44,666 80.6% 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 - 320,837 69.2%435,778 - 327,664 75.2%477,057 - 367,324 77.0% Marijuana Enforcement/Excise 6 336.06.41-42 24,720 12,187 51,775 209.4%21,297 4,970 16,324 76.7%36,920 5,676 31,244 84.6% Liquor Excise Tax 8 336.06.94 41,536 - 34,380 82.8%44,174 - 32,161 72.8%41,772 - 30,739 73.6% Liquor Profit 6 336.06.95 90,203 20,968 63,098 70.0%84,441 21,065 63,375 75.1%84,749 21,155 63,594 75.0%Treasurer Invest & Other Fees 1 341.42.15-20/50 16,290 2,254 35,510 218.0%33,805 1,908 26,369 78.0%11,599 1,261 8,119 70.0% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 7,711 63,295 79.1%90,727 8,640 66,655 73.5%84,213 6,729 64,152 76.2% Penalties on delinquent taxes 1 359.40.10/.20 133,332 3,766 76,610 57.5%98,944 3,119 69,113 69.9%112,239 3,168 81,625 72.7% Investment Income 1 361.11 230,000 55,502 386,758 168.2%354,385 46,180 317,048 89.5%682,617 30,557 641,605 94.0%Interest on delinquent taxes 1 361.40.10 210,000 14,730 151,515 72.2%193,625 5,453 138,025 71.3%213,458 5,292 157,887 74.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 - 206,731 62.9%143,455 - 30,577 21.3%294,890 - 26,537 9.0% DNR Timber 1 395.1.1 250,000 116,213 160,930 64.4%207,899 - 94,176 45.3%336,350 38,458 296,001 88.0% Transfer in 1 397.00 3,000 10,233 30,177 1005.9%40,322 17,792 38,087 94.5%46,441 23,254 45,691 98.4%Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 956 12,925 108.6%9,020 589 5,613 62.2%16,462 469 16,462 100.0% Assessor 1 001-010-000 8,700 53 5,894 67.7%10,970 44 8,173 74.5%8,761 25 6,160 70.3% Auditor-Recording Fees 1 341.21.10 72,063 5,557 53,404 74.1%74,248 6,346 54,610 73.6%74,077 5,407 53,616 72.4% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 12,914 201,492 86.6%242,031 47,380 207,781 85.8%229,927 14,743 200,163 87.1%Auditor-Other Revenue 1 26,605 2,441 26,184 98.4%29,714 2,044 22,392 75.4%32,440 3,029 23,446 72.3% Elections 1 001-021-000 159,722 5,147 98,536 61.7%138,996 58,218 114,205 82.2%160,903 1,532 153,467 95.4% Clerk 1 001-020-000 170,768 9,911 130,070 76.2%179,130 14,070 134,514 75.1%192,402 15,791 147,081 76.4% County Administrator 1 001-059-000 4,260 - 4,260 3,700 0 0Commissioners1001-060-000 8,000 624 6,526 81.6%8,923 728 6,500 72.8%8,609 640 6,310 73.3% Safety & Security 1 001-067-000 64,959 - 41,545 64.0%66,877 8,154 55,509 83.0%70,305 5,333 58,168 82.7% Community Services 1 001-068-000 6,900 46 3,273 47.4%4,611 29 3,885 84.3%8,269 3,461 6,318 76.4% District Court 1 001-080-000 603,032 37,597 529,017 87.7%596,433 33,834 466,196 78.2%632,629 37,504 487,689 77.1% Juvenile Service 1 001-110-000 259,676 14,788 198,622 76.5%290,984 12,164 196,071 67.4%260,358 14,621 183,635 70.5%Prosecuting Attorney 1 001-150-000 178,690 (11,959) 76,576 42.9%151,185 7,097 125,797 83.2%124,918 6,911 100,109 80.1% 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 74,179 460,772 76.4%722,960 4,172 440,703 61.0%626,703 57,018 474,379 75.7% Superior Court 1 001-240-000 *60,822 - 37,764 62.1%90,193 - 67,739 75.1%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 1,006,108 14,601,908 73.2%19,181,590 807,945 13,260,488 69.1%19,248,227 817,598 13,605,258 70.7% * 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 1,288 (111,173)253,160 2,888 31,003 194,294 608 12,366 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view September 9 10/10/2018 FUND Fund #Budget Sep YTD YTD ACTUAL Sep YTD YTD ACTUAL Sep YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,261 69,648 92.4%77,983 2,303 70,875 90.9%74,342 1,955 67,370 90.6% Court Facilitator 106 5,100 360 3,720 72.9%5,920 500 4,420 74.7%6,220 600 4,600 74.0% Boating Safety 107 48,740 - 47,451 97.4%49,100 - 41,877 85.3%61,493 - 52,033 84.6% WSU Cooperative 108 *557,432 64,268 400,459 71.8%534,494 10,503 315,609 59.0%528,605 7,047 381,532 72.2% 4-H After School 113 *50,450 - 37,750 74.8%44,475 19,000 41,733 93.8%10,600 - 10,600 100.0% JeffComCap 119 119 *264,695 33,907 210,371 79.5%254,838 21,221 191,176 75.0%276,062 22,899 206,093 74.7% Crime Victim's Svc 120 110,757 20,997 82,362 74.4%99,707 1,272 75,447 75.7%79,335 1,492 53,094 66.9% Grant Mgmt 123 150,000 3,488 82,211 54.8%76,723 - 58,345 76.0%95,126 - 61,954 65.1% Hotel-Motel 125 500,500 34,962 334,529 66.8%507,868 56,561 347,485 68.4%449,148 53,487 305,095 67.9% Jeff Co Public Health 127 *4,372,775 255,247 3,549,938 81.2%4,064,163 179,717 3,044,733 74.9%4,076,806 168,254 3,193,859 78.3% Water Quality 128 960,714 50,609 731,517 76.1%975,455 33,927 701,746 71.9%999,219 98,697 693,687 69.4% Mental Health 130 45,150 1,462 30,197 66.9%47,474 806 28,726 60.5%46,854 1,028 29,059 62.0% Chem Dep Mnt Hlth tx 131 490,490 56,054 415,126 84.6%516,131 44,340 376,906 73.0%500,457 44,398 364,466 72.8% Drug Fund 135 18,288 626 10,196 55.8%11,819 1,148 9,206 77.9%23,562 1,229 20,171 85.6% Law Library 140 10,150 822 7,483 73.7%10,049 877 7,493 74.6%9,692 770 7,215 74.4% Trial Court Imprvmnt 141 25,000 - 17,403 69.6%23,449 - 11,726 50.0%22,669 - 16,903 74.6% Public Defense Fnd 142 35,000 - - 0.0%0 - - 0.0%36,673 - - 0.0% Community Develpmnt 143 *1,792,406 77,886 1,080,776 60.3%1,418,569 59,633 1,106,641 78.0%1,668,687 87,742 1,284,483 77.0% Federal Forest Title III 147 - 159 19,656 - 71 456 - 31 21,856 Jeff Co Affrdbl Hsg 148 *318,881 27,575 222,218 69.7%250,150 22,268 183,882 73.5%243,809 18,228 179,494 73.6% Treasurer's O & M 150 47,280 54 25,075 53.0%28,653 505 19,274 67.3%23,981 17 15,471 64.5% REET technology 151 14,420 1,428 12,366 85.8%16,827 1,688 12,492 74.2%16,194 1,500 12,107 74.8% Veteran's Relief 155 59,820 1,586 49,985 83.6%65,060 884 45,883 70.5%63,652 1,068 45,551 71.6% Water Pollution Cntrl 160 - - - - - - 18,607 - 17,665 94.9% Park & Rec 174 659,282 25,471 492,663 74.7%625,429 19,675 443,955 71.0%569,174 18,494 412,363 72.4% County Park Imprvmnt 175 *146,185 6,906 136,150 93.1%119,426 5,597 84,137 70.5%84,284 3,357 83,106 98.6% County Roads 180 7,838,108 536,454 6,096,022 77.8%9,773,015 711,321 6,221,326 63.7%8,949,637 395,090 5,313,675 59.4% Facilities Mgmt 183 1,074,934 89,578 849,681 79.0%1,040,019 91,833 780,125 75.0%1,116,468 86,931 855,524 76.6% County Fair 199 250,000 27,063 221,694 88.7%308,594 25,732 283,315 91.8%269,769 29,577 236,381 87.6% Total Special Revenue 19,921,894 1,292,159 15,236,650 76.5%20,945,389 1,285,648 14,508,991 69.3%20,321,124 1,014,314 13,945,408 68.6% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Sep YTD YTD YTD Sep YTD YTD Budget Sep YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 24,254 40,371 4.0%517,754 - 511,831 98.9%1,113,333 - 836,612 75.1% Capital Improvement 302 1,072,938 117,652 926,146 86.3%1,285,270 181,336 951,966 74.1%1,537,774 95,883 942,154 61.3% Public Infrastructure 306 451,400 52,383 388,230 86.0%477,127 41,494 349,731 73.3%456,854 40,422 332,730 72.8% Conservation Futures 308 239,400 8,899 174,978 73.1%256,431 4,839 155,343 60.6%244,237 5,531 151,484 62.0% Total CAP IMP 2,763,738 203,189 1,529,725 55.3%2,536,581 227,669 1,968,871 77.6%3,352,198 141,835 2,262,980 67.5% ENTERPRISE Solid Waste 401 3,357,942 329,690 2,733,970 81.4%3,488,829 352,151 2,657,637 76.2%3,481,538 427,742 2,653,210 76.2% Solid Waste Post Clos 402 150 90 697 464.4%516 76 492 95.4%335 36 232 69.2% Solid Waste Eqpt Res 403 4,000 1,412 10,921 273.0%7,601 1,062 6,885 90.6%302,768 296 1,901 0.6% Yard Waste Educ Fnd 404 5,800 11 80 1.4%5,750 4 22 0.4%1,781 4 28 1.6% Tri Area Sewer 405 *255,399 1,159 9,265 3.6%297,554 600 4,952 1.7%172,740 279 1,963 1.1% Total ENTERPRISE 3,623,291 332,361 2,754,932 76.0%3,800,250 353,893 2,669,988 70.3%3,959,162 428,357 2,657,333 67.1% INTERNAL SERVICE Equipment Rental 501 2,451,202 240,860 1,624,501 66.3%2,508,636 284,807 1,887,162 75.2%2,179,575 409,479 1,544,129 70.8% Risk Management 502 215,000 758 27,431 12.8%112,770 - 75,111 66.6%57,666 - 15,034 26.1% Benefit Reserve 505 208,000 17,389 197,578 95.0%225,590 16,636 183,713 81.4%215,434 15,808 178,869 83.0% Information Services 506 2,103,298 51,233 1,461,463 69.5%1,832,926 17,457 1,267,664 69.2%1,551,832 1,517 1,120,032 72.2% Total INT SERV 4,977,500 310,240 3,310,973 66.5%4,679,922 318,900 3,413,650 72.9%4,004,508 426,804 2,858,065 71.4% Total 31,286,423 2,137,949 22,832,280 73.0%31,962,142 2,186,110 22,561,500 70.6%31,636,992 2,011,310 21,723,786 68.7% GENERAL FUND CASH BALANCE REPORT 10/10/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$ 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 9 September 10/10/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,223August199,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 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 2,296,483 100.0%$3,040,000 $2,296,483ytd 1,599,081 1,405,881 1,458,975 1,460,127 1,744,091 1,665,497 1,810,743 1,975,327 2,109,343 2,296,483 2,212,274 2,296,483 ytd change -12.08%3.78%0.08%19.45%-4.51%8.72%9.09%6.78%8.87%3.81%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 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 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 723,021 100.0%955,428 723,021 3,995,428 3,019,504 ytd 522,961 507,307 554,926 638,413 659,790 $723,021 694,787 $723,021 2,907,061 $3,019,504 3.9%4.06%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 September 9 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$ 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 $926,146 1,106,090$ 1,025,000$ 926,146$ -10% YTD 423,762$ 334,992$ 348,570$ 365,001$ 460,393$ 495,771$ 926,194$ 942,154$ 951,966$ $926,146 829,021$ 768,243$ 926,146$ 21% Y/Y chg -20.95%4.05%4.71%26.13%7.68%86.82%1.72%1.04%-2.71% 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 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 9/12/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 9 September 10/10/2018 REVENUE 4 yr avg *2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2013-16 Budget Actual DifferenceJanuary16,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$ 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$ 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$ 367,271$ 419,737$ 500,500$ 367,271$ YTD 213,995$ 184,054$ 189,233$ 184,766$ 198,799$ 211,429$ 252,746$ 305,095$ 347,485$ 367,271$ 279,189$ 332,908$ 367,271$ 10.3% $- $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