Loading...
HomeMy WebLinkAbout2018-06_BC_RevenueReports2018 6 June General Fund 16-Jul-2018 Current Expense Jefferson County TreasurerREVENUE NAME BARS BUDGET JUN Y-T-D Y-T-D ACTUAL JUN Y-T-D Y-T-D ACTUAL JUN Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % Property Tax 1 311.10 7,850,027 57,650 4,423,105 56.3%7,643,881 52,098 4,347,627 56.9%7,514,257 51,831 4,270,081 56.8%Diverted Road Prop Tax 1 311.20 720,000 5,654 409,254 56.8%720,000 5,219 413,088 57.4%720,000 5,213 412,667 57.3% Private Harvest Tax 2 317.40.10/.20 335,000 - 309,599 92.4%377,824 - 171,790 45.5%281,335 - 183,394 65.2%Sales Tax 1 313.11 3,040,000 248,506 1,416,669 46.6%2,876,339 208,349 1,337,617 46.5%2,738,244 196,762 1,247,500 45.6% special purpose 313.15 955,428 75,141 447,608 46.8%903,099 65,229 419,441 46.4%876,170 65,832 403,377 46.0%Local Criminal Justice 1 313.71 380,070 31,603 187,088 49.2%375,219 27,351 173,585 46.3%364,508 27,611 167,710 46.0% Leasehold Excise Tax 3 317.20 62,000 16,641 31,549 50.9%69,801 16,256 34,549 49.5%55,407 13,659 29,729 53.7%Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 9,359 39,628 49.5%90,727 8,678 43,384 47.8%84,213 13,529 41,507 49.3% Penalties on delinquent taxes 1 359.40.10/.20 133,332 12,819 58,426 43.8%98,944 11,017 56,126 56.7%112,239 11,069 65,356 58.2%Interest on delinquent taxes 1 361.40.10 210,000 19,409 112,887 53.8%193,625 20,388 114,785 59.3%213,458 16,403 129,313 60.6% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 572,220 1,833,818 1,833,818 320.5%1,458,645 1,390,772 1,390,772 95.3%1,476,638 1,422,312 1,422,312 96.3%P.U.D. Privilege Tax 4 335.00.91 323,420 - 0 0.0%314,148 314,148 314,148 100.0%318,107 318,107 318,107 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 463,500 - 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 12,337 39,588 160.1%21,297 5,678 11,354 53.3%36,920 12,784 25,568 69.3% 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 42,130 46.7%84,441 21,155 42,310 50.1%84,749 21,220 42,439 50.1% 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 6.0%Investment Income 1 361.11 230,000 34,443 220,754 96.0%354,385 30,797 207,851 58.7%682,617 15,009 54,628 8.0% Treasurer Invest & Other Fees 1 341.42.15-20/50 16,290 2,223 27,204 167.0%33,805 1,755 20,765 61.4%11,599 873 4,308 37.1%DNR Timber 1 395.1.1 250,000 1,016 5,923 2.4%207,899 4,884 4,884 2.3%336,350 11,977 224,129 66.6% Transfer in 1 397.00 3,000 11,212 19,194 639.8%40,322 12,226 19,546 48.5%46,441 - 21,687 46.7% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 818 4,577 38.5%9,020 752 3,267 36.2%14,629 3,822 14,629 100.0% Assessor 1 001-010-000 8,700 171 3,985 45.8%10,970 2,154 6,223 56.7%8,761 42 4,004 45.7% Auditor-Recording Fees 1 341.21.10 72,063 6,086 35,255 48.9%74,248 6,623 37,134 50.0%74,077 7,459 35,185 47.5% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 16,584 118,406 50.9%242,031 18,609 126,215 52.1%229,927 18,121 118,273 51.4% Auditor-Other Revenue 1 26,605 3,102 16,600 62.4%29,714 2,164 15,364 51.7%32,440 2,943 16,305 50.3%Elections 1 001-021-000 146,191 13,563 89,791 61.4%138,996 31,790 55,987 40.3%160,903 - 73,405 45.6% Clerk 1 001-020-000 170,768 12,755 87,442 51.2%179,130 13,562 88,514 49.4%192,402 14,849 97,578 50.7%County Administrator 1 001-059-000 4,260 - 4,260 3,700 0 0 Commissioners 1 001-060-000 8,000 708 4,321 54.0%8,923 792 4,402 49.3%8,609 861 4,125 47.9%Safety & Security 1 001-067-000 64,959 - 30,414 46.8%66,877 - 29,574 44.2%70,305 - 27,802 39.5% Community Services 1 001-068-000 6,900 57 1,367 19.8%4,611 35 2,036 44.2%8,269 52 2,288 27.7%District Court 1 001-080-000 603,032 154,389 353,800 58.7%596,433 32,980 318,325 53.4%632,629 107,678 329,753 52.1% Juvenile Service 1 001-110-000 259,676 28,132 148,252 57.1%290,984 50,602 150,310 51.7%260,358 8,742 127,107 48.8%Prosecuting Attorney 1 001-150-000 178,690 7,049 50,849 28.5%151,185 6,911 88,714 58.7%124,918 6,776 75,571 60.5% 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 127,250 289,289 51.4%722,960 121,997 303,411 42.0%626,703 63,885 335,917 53.6% Superior Court 1 001-240-000 40,038 - 26,043 65.0%90,193 - 46,660 51.7%26,142 - 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 2,763,560 11,375,619 61.2%19,181,590 2,484,972 10,686,214 55.7%19,246,395 2,439,421 10,646,041 55.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 exclud 388/89 4,138 15,006 253,160 10,395 12,421 194,294 3,654.65 10,032 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view June 6 7/16/2018 FUND Fund #Budget Jun YTD YTD ACTUAL Jun YTD YTD ACTUAL Jun YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,446 13,318 17.7%77,983 2,405 13,220 17.0%74,342 2,619 12,655 17.0% Court Facilitator 106 5,100 520 2,540 49.8%5,920 600 3,300 55.7%6,220 640 3,000 48.2% Boating Safety 107 48,740 - 30,607 62.8%49,100 - 30,458 62.0%61,493 - 39,200 63.7% WSU Cooperative 108 510,294 4,298 301,948 59.2%534,494 4,897 242,497 45.4%528,605 4,987 288,941 54.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 132,348 64.9%254,838 37,601 143,893 56.5%276,062 22,899 137,395 49.8% Crime Victim's Svc 120 110,757 1,799 53,491 48.3%99,707 1,137 53,274 53.4%79,335 2,074 25,451 32.1% Grant Mgmt 123 150,000 6,504 67,983 45.3%76,723 2,541 52,644 68.6%95,126 - 61,954 65.1% Hotel-Motel 125 500,500 36,556 190,187 38.0%507,868 31,485 187,705 37.0%449,148 29,476 161,572 36.0% Jeff Co Public Health 127 3,956,447 222,934 2,111,967 53.4%4,064,163 194,265 2,166,885 53.3%4,076,806 225,018 2,235,671 54.8% Water Quality 128 960,714 148,166 565,170 58.8%975,455 5,380 524,824 53.8%999,219 46,632 524,133 52.5% Mental Health 130 45,150 433 27,326 60.5%47,474 417 26,223 55.2%46,854 454 26,961 57.5% Chem Dep Mnt Hlth tx 131 490,490 43,449 257,216 52.4%516,131 37,601 239,075 46.3%500,457 37,883 230,515 46.1% Drug Fund 135 18,288 1,658 7,181 39.3%11,819 1,138 6,256 52.9%23,562 10,135 16,861 71.6% Law Library 140 10,150 725 4,970 49.0%10,049 938 4,914 48.9%9,692 921 4,694 48.4% 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 51,715 651,476 39.2%1,418,569 97,918 720,869 50.8%1,668,687 141,445 915,051 54.8% Jeff Co Affrdbl Hsg 148 237,381 28,948 128,286 54.0%250,150 22,174 122,367 48.9%243,809 24,224 117,560 48.2% Treasurer's O & M 150 47,280 5,451 13,788 29.2%28,653 6,757 12,544 43.8%23,981 3,954 11,080 46.2% REET technology 151 14,420 1,525 7,845 54.4%16,827 1,615 7,789 46.3%16,194 1,497 7,573 46.8% Veteran's Relief 155 59,820 536 45,022 75.3%65,060 483 43,144 66.3%63,652 488 43,290 68.0% Water Pollution Cntrl 160 - - - - - - 18,607 7,350 17,665 94.9% Park & Rec 174 648,380 10,183 314,337 48.5%625,429 10,151 298,874 47.8%569,174 6,182 267,564 47.0% County Park Imprvmnt 175 131,185 35,524 98,139 74.8%119,426 6,295 13,774 11.5%84,284 5,195 60,867 72.2% County Roads 180 7,838,108 208,083 4,231,547 54.0%9,773,015 188,965 4,330,293 44.3%8,949,637 203,450 4,045,831 45.2% Facilities Mgmt 183 1,074,934 94,493 572,701 53.3%1,040,019 87,074 520,203 50.0%1,116,468 86,931 594,732 53.3% County Fair 199 250,000 19,061 95,819 38.3%308,594 47,043 150,769 48.9%269,769 10,966 95,189 35.3% Total Special Revenue 19,148,104 928,004 9,969,064 52.1%20,945,389 741,837 9,944,389 47.5%20,321,124 864,453 9,967,240 49.0% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Jun YTD YTD YTD Jun YTD YTD Budget Jun YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 10,500 16,117 1.6%517,754 - 511,754 98.8%1,113,333 - 559,891 50.3% Capital Improvement 302 1,072,938 147,514 568,634 53.0%1,285,270 147,551 555,012 43.2%1,537,774 241,046 615,102 40.0% Public Infrastructure 306 451,400 40,816 240,347 53.2%477,127 35,111 220,996 46.3%456,854 34,680 210,320 46.0% Conservation Futures 308 239,400 3,231 149,479 62.4%256,431 2,672 140,450 54.8%244,237 2,535 139,981 57.3% Total CAP IMP 2,763,738 202,061 974,576 35.3%2,536,581 185,334 1,428,212 56.3%3,352,198 278,261 1,525,294 45.5% ENTERPRISE Solid Waste 401 3,357,942 210,319 1,557,748 46.4%3,488,829 226,441 1,535,077 44.0%3,481,538 306,929 1,650,988 47.4% Solid Waste Post Clos 402 150 81 428 285.2%516 57 279 54.1%335 23 124 37.0% Solid Waste Eqpt Res 403 4,000 1,279 6,685 167.1%7,601 793 3,895 51.2%302,768 186 1,016 0.3% Yard Waste Educ Fnd 404 5,800 9 47 0.8%5,750 3 13 0.2%1,781 3 18 1.0% Tri Area Sewer 405 226,000 1,094 5,860 2.6%297,554 524 3,258 1.1%172,740 251 1,135 0.7% Total ENTERPRISE 3,593,892 212,782 1,570,767 43.7%3,800,250 227,818 1,542,522 40.6%3,959,162 307,392 1,653,280 41.8% INTERNAL SERVICE Equipment Rental 501 2,451,202 162,849 918,060 37.5%2,508,636 285,401 1,030,162 41.1%2,179,575 161,101 810,072 37.2% Risk Management 502 215,000 - 0 0.0%112,770 - - 0.0%57,666 - 178 0.3% Benefit Reserve 505 208,000 25,644 140,571 67.6%225,590 21,821 130,764 58.0%215,434 21,401 128,046 59.4% Information Services 506 2,103,298 1,279 995,307 47.3%1,832,926 573 821,986 44.8%1,551,832 778 734,627 47.3% Total INT SERV 4,977,500 189,771 2,053,939 41.3%4,679,922 307,796 1,982,912 42.4%4,004,508 183,281 1,672,924 41.8% Total 30,483,234 1,532,619 14,568,346 47.8%31,962,142 1,462,785 14,898,035 46.6%31,636,992 1,633,387 14,818,738 46.8% GENERAL FUND CASH BALANCE REPORT 7/16/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$ 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 $7,000,000 GENERAL FUND END OF MONTH CASH BALANCE 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 6 June 7/16/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 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 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,416,669 100.0%$3,040,000 $1,416,669ytd 1,052,690 911,430 936,188 869,332 1,136,672 1,040,565 1,139,719 1,247,500 1,337,617 1,416,669 1,397,757 1,416,669 ytd change -13.42%2.72%-7.14%30.75%-8.46%9.53%9.46%7.22%5.91%1.35%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 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 447,608 100.0%955,428 447,608 3,995,428 1,864,276 ytd 337,148 319,899 349,376 403,377 419,441 $447,608 439,487 $447,608 1,837,244 $1,864,276 1.5% 1.85%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 June 6 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$ 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 $568,634 1,106,090$ 1,025,000$ 568,634$ -45% YTD 286,430$ 222,784$ 243,416$ 237,545$ 264,393$ 300,812$ 503,893$ 615,102$ 555,012$ $568,634 493,705$ 457,510$ 568,633.76$ 24% Y/Y chg -22.22%9.26%-2.41%11.30%13.77%67.51%22.07%-9.77%2.45% 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 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 7/16/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 6 June 7/16/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$ 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$ 189,022$ 419,737$ 500,500$ 189,022$ YTD 116,905$ 93,444$ 102,680$ 92,512$ 104,257$ 107,010$ 131,476$ 161,572$ 187,705$ 189,022$ 146,941$ 175,214$ 189,022$ 7.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