Loading...
HomeMy WebLinkAbout2018-07_Revenue Rpts_BC2018 7 July General Fund 15-Aug-2018 Jefferson County TreasurerREVENUE NAME BARS BUDGET JUL Y-T-D Y-T-D ACTUAL JUL Y-T-D Y-T-D ACTUAL JUL Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 %Property Tax 1 311.10 7,850,027 36,075 4,459,181 56.8%7,643,881 25,476 4,373,103 57.2%7,514,257 31,476 4,301,556 57.2% Diverted Road Prop Tax 1 311.20 720,000 3,466 412,719 57.3%720,000 2,457 415,545 57.7%720,000 2,841 415,508 57.7% 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 262,489 1,679,158 55.2%2,876,339 236,448 1,574,065 54.7%2,738,244 204,143 1,451,643 53.0% special purpose 313.15 955,428 81,117 528,724 55.3%903,099 73,136 492,577 54.5%876,170 69,908 473,285 54.0%Local Criminal Justice 1 313.71 380,070 33,908 220,996 58.1%375,219 30,359 203,944 54.4%364,508 28,992 196,702 54.0% Leasehold Excise Tax 3 317.20 62,000 - 31,549 50.9%69,801 - 34,549 49.5%55,407 - 29,729 53.7% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 7,350 46,978 58.7%90,727 7,145 50,530 55.7%84,213 8,104 49,611 58.9% Penalties on delinquent taxes 1 359.40.10/.20 133,332 9,937 68,363 51.3%98,944 5,883 62,008 62.7%112,239 6,764 72,121 64.3%Interest on delinquent taxes 1 361.40.10 210,000 17,363 130,250 62.0%193,625 11,474 126,259 65.2%213,458 11,526 140,839 66.0% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 572,220 - 1,833,818 320.5%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 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,569 320,837 69.2%435,778 108,119 327,664 75.2%477,057 109,812 367,324 77.0%Marijuana Enforcement/Excise 6 336.06.41-42 24,720 - 39,588 160.1%21,297 - 11,354 53.3%36,920 - 25,568 69.3% Liquor Excise Tax 8 336.06.94 41,536 10,673 34,380 82.8%44,174 9,670 32,161 72.8%41,772 9,328 30,739 73.6% Liquor Profit 6 336.06.95 90,203 - 42,130 46.7%84,441 - 42,310 50.1%84,749 - 42,439 50.1% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 11,104 206,731 62.9%143,455 10,777 30,577 21.3%294,890 8,846 26,537 9.0%Investment Income 1 361.11 230,000 72,344 293,098 127.4%354,385 42,143 249,994 70.5%682,617 11,766 66,394 9.7% Treasurer Invest & Other Fees 1 341.42.15-20/50 16,290 2,193 29,397 180.5%33,805 1,808 22,573 66.8%11,599 1,236 5,544 47.8% DNR Timber 1 395.1.1 250,000 2,277 8,200 3.3%207,899 - 4,884 2.3%336,350 - 224,129 66.6% Transfer in 1 397.00 3,000 - 19,194 639.8%40,322 - 19,546 48.5%46,441 - 21,687 46.7%Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 863 5,440 45.7%9,020 733 4,000 44.3%15,701 1,072 15,701 100.0% Assessor 1 001-010-000 8,700 46 4,031 46.3%10,970 65 6,288 57.3%8,761 340 4,345 49.6% Auditor-Recording Fees 1 341.21.10 72,063 6,169 41,423 57.5%74,248 5,626 42,760 57.6%74,077 6,408 41,593 56.1% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 18,069 136,476 58.6%242,031 15,421 141,636 58.5%229,927 15,085 133,358 58.0%Auditor-Other Revenue 1 26,605 3,726 20,326 76.4%29,714 2,326 17,690 59.5%32,440 1,692 17,997 55.5% Elections 1 001-021-000 146,191 3,598 93,388 63.9%138,996 - 55,987 40.3%160,903 78,529 151,935 94.4% Clerk 1 001-020-000 170,768 16,550 103,992 60.9%179,130 9,545 98,059 54.7%192,402 14,038 111,616 58.0% County Administrator 1 001-059-000 4,260 - 4,260 3,700 0 0Commissioners1001-060-000 8,000 776 5,097 63.7%8,923 684 5,086 57.0%8,609 716 4,841 56.2% Safety & Security 1 001-067-000 64,959 - 30,414 46.8%66,877 10,216 39,790 59.5%70,305 - 27,802 39.5% Community Services 1 001-068-000 6,900 40 1,407 20.4%4,611 40 2,077 45.0%8,269 534 2,822 34.1% District Court 1 001-080-000 603,032 43,337 397,137 65.9%596,433 31,076 349,401 58.6%632,629 33,599 363,352 57.4% Juvenile Service 1 001-110-000 259,676 7,716 155,969 60.1%290,984 11,874 162,184 55.7%260,358 23,536 150,644 57.9%Prosecuting Attorney 1 001-150-000 178,690 26,439 77,288 43.3%151,185 11,535 100,249 66.3%124,918 6,776 82,347 65.9% 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 13,823 303,112 53.8%722,960 47,938 351,348 48.6%626,703 7,865 343,782 54.9% 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 1,189,506 12,565,125 67.6%19,181,590 711,973 11,398,187 59.4%19,247,467 694,931 11,340,973 58.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 367.24 15,374 253,160 1544.44 13,965 194,294 1190.16 11,222 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view July 7 8/16/2018 FUND Fund #Budget Jul YTD YTD ACTUAL Jul YTD YTD ACTUAL Jul YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 51,260 64,578 85.7%77,983 53,239 66,459 85.2%74,342 50,246 62,901 84.6% Court Facilitator 106 5,100 400 2,940 57.6%5,920 340 3,640 61.5%6,220 540 3,540 56.9% Boating Safety 107 48,740 - 30,607 62.8%49,100 11,420 41,877 85.3%61,493 - 39,200 63.7% WSU Cooperative 108 510,294 31,101 333,049 65.3%534,494 13,211 255,708 47.8%528,605 1,235 290,176 54.9% 4-H After School 113 37,250 5,500 37,750 101.3%44,475 - 22,733 51.1%10,600 - 10,600 100.0% JeffComCap 119 119 204,000 22,058 154,406 75.7%254,838 4,841 148,734 58.4%276,062 22,899 160,294 58.1% Crime Victim's Svc 120 110,757 5,764 59,256 53.5%99,707 19,825 73,099 73.3%79,335 24,348 49,799 62.8% Grant Mgmt 123 150,000 - 67,983 45.3%76,723 - 52,644 68.6%95,126 - 61,954 65.1% Hotel-Motel 125 500,500 44,445 234,632 46.9%507,868 38,400 226,104 44.5%449,148 33,687 195,259 43.5% Jeff Co Public Health 127 3,956,447 692,218 2,804,185 70.9%4,064,163 324,451 2,491,336 61.3%4,076,806 328,341 2,564,012 62.9% Water Quality 128 960,714 27,709 592,879 61.7%975,455 5,335 530,160 54.3%999,219 6,055 530,188 53.1% Mental Health 130 45,150 220 27,545 61.0%47,474 148 26,371 55.5%46,854 184 27,145 57.9% Chem Dep Mnt Hlth tx 131 490,490 46,515 303,731 61.9%516,131 41,721 280,796 54.4%500,457 39,849 270,364 54.0% Drug Fund 135 18,288 809 7,990 43.7%11,819 814 7,070 59.8%23,562 1,016 17,877 75.9% Law Library 140 10,150 825 5,795 57.1%10,049 758 5,671 56.4%9,692 824 5,518 56.9% Trial Court Imprvmnt 141 25,000 5,798 17,403 69.6%23,449 5,863 11,726 50.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 123,603 775,079 46.6%1,418,569 113,533 834,402 58.8%1,668,687 76,561 991,612 59.4% Jeff Co Affrdbl Hsg 148 237,381 31,594 159,879 67.4%250,150 19,393 141,760 56.7%243,809 20,401 137,961 56.6% Treasurer's O & M 150 47,280 8,586 22,374 47.3%28,653 4,684 17,228 60.1%23,981 2,201 13,281 55.4% REET technology 151 14,420 1,519 9,364 64.9%16,827 1,548 9,337 55.5%16,194 1,531 9,104 56.2% Veteran's Relief 155 59,820 343 45,366 75.8%65,060 218 43,362 66.6%63,652 267 43,556 68.4% Water Pollution Cntrl 160 - - - - - - 18,607 - 17,665 94.9% Park & Rec 174 648,380 10,129 324,466 50.0%625,429 3,201 302,074 48.3%569,174 9,047 276,610 48.6% County Park Imprvmnt 175 131,185 14,213 112,352 85.6%119,426 52,640 66,414 55.6%84,284 8,701 69,568 82.5% County Roads 180 7,838,108 329,608 4,561,154 58.2%9,773,015 421,777 4,752,070 48.6%8,949,637 363,717 4,409,548 49.3% Facilities Mgmt 183 1,074,934 89,578 662,279 61.6%1,040,019 86,659 606,863 58.4%1,116,468 86,931 681,663 61.1% County Fair 199 250,000 31,840 127,659 51.1%308,594 31,641 182,410 59.1%269,769 28,194 123,383 45.7% Total Special Revenue 19,148,104 1,543,796 11,544,699 60.3%20,945,389 1,224,017 11,200,047 53.5%20,321,124 1,078,580 11,074,014 54.5% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Jul YTD YTD YTD Jul YTD YTD Budget Jul YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 - 16,117 1.6%517,754 77 511,831 98.9%1,113,333 1,721 561,612 50.4% Capital Improvement 302 1,072,938 108,763 677,397 63.1%1,285,270 105,582 660,594 51.4%1,537,774 105,451 720,552 46.9% Public Infrastructure 306 451,400 43,755 284,102 62.9%477,127 38,912 259,908 54.5%456,854 36,566 246,886 54.0% Conservation Futures 308 239,400 2,225 151,705 63.4%256,431 1,351 141,800 55.3%244,237 1,175 141,155 57.8% Total CAP IMP 2,763,738 154,744 1,129,320 40.9%2,536,581 145,921 1,574,133 62.1%3,352,198 144,912 1,670,206 49.8% ENTERPRISE Solid Waste 401 3,357,942 460,917 2,018,664 60.1%3,488,829 468,255 2,003,332 57.4%3,481,538 311,614 1,962,602 56.4% Solid Waste Post Clos 402 150 89 517 344.5%516 65 343 66.6%335 36 159 47.6% Solid Waste Eqpt Res 403 4,000 1,401 8,086 202.1%7,601 902 4,797 63.1%302,768 291 1,308 0.4% Yard Waste Educ Fnd 404 5,800 11 57 1.0%5,750 3 17 0.3%1,781 4 21 1.2% Tri Area Sewer 405 226,000 1,096 6,956 3.1%297,554 531 3,789 1.3%172,740 276 1,410 0.8% Total ENTERPRISE 3,593,892 463,513 2,034,280 56.6%3,800,250 469,756 2,012,278 53.0%3,959,162 312,221 1,965,501 49.6% INTERNAL SERVICE Equipment Rental 501 2,451,202 227,661 1,145,721 46.7%2,508,636 177,565 1,207,727 48.1%2,179,575 164,116 974,188 44.7% Risk Management 502 215,000 - 0 0.0%112,770 - - 0.0%57,666 - 178 0.3% Benefit Reserve 505 208,000 20,575 161,145 77.5%225,590 19,461 150,224 66.6%215,434 18,764 146,810 68.1% Information Services 506 2,103,298 407,267 1,402,575 66.7%1,832,926 425,124 1,247,111 68.0%1,551,832 341,918 1,076,546 69.4% Total INT SERV 4,977,500 655,503 2,709,442 54.4%4,679,922 622,150 2,605,062 55.7%4,004,508 524,798 2,197,722 54.9% Total 30,483,234 2,817,556 17,417,742 57.1%31,962,142 2,461,844 17,391,520 54.4%31,636,992 2,060,511 16,907,443 53.4% GENERAL FUND CASH BALANCE REPORT 8/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$ 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$ 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 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 7 July 8/1/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 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 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,679,158 100.0%$3,040,000 $1,679,158ytd 1,211,966 1,047,803 1,102,464 1,025,213 1,325,629 1,214,695 1,325,608 1,451,643 1,574,065 1,679,158 1,632,846 1,679,158 ytd change -13.55%5.22%-7.01%29.30%-8.37%9.13%9.51%8.43%6.68%2.84%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 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 528,724 100.0%955,428 528,724 3,995,428 2,207,882 ytd 405,443 373,973 406,170 473,285 492,577 $528,724 514,411 $528,724 2,147,257 $2,207,882 2.8% 2.78%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 July 7 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$ 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 $677,397 1,106,090$ 1,025,000$ 677,397$ -34% YTD 329,584$ 257,177$ 280,074$ 266,401$ 322,016$ 368,534$ 614,496$ 720,552$ 660,594$ $677,397 591,044$ 547,713$ 677,397.24$ 24% Y/Y chg -21.97%8.90%-4.88%20.88%14.45%66.74%17.26%-8.32%2.54% 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 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 8/1/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 7 July 8/1/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$ 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$ 233,467$ 419,737$ 500,500$ 233,467$ YTD 137,060$ 107,770$ 121,991$ 112,713$ 125,769$ 131,546$ 159,187$ 195,259$ 226,104$ 233,467$ 178,024$ 212,278$ 233,467$ 10.0% $- $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