Loading...
HomeMy WebLinkAbout2017-10_BC_RevenueRpts2017 BARS General Fund 8-Nov-17 Jefferson County Treasurer REVENUE NAME BUDGET OCT Y-T-D Y-T-D ACTUAL OCT Y-T-D Y-T-D ACTUAL OCT Y-T-D Y-T-D *2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % Property Tax 1 311.10 7,696,105 2,459,565 7,023,368 91.3%7,514,257 2,324,335 6,818,868 90.7%7,388,068 2,248,990 6,666,183 90.2% Diverted Road Prop Tax 1 311.20 720,000 222,472 655,593 91.1%720,000 214,953 648,749 90.1%720,000 212,482 655,942 91.1% Private Harvest Tax 2 317.40.10/.20 335,000 - 311,003 92.8%281,335 - 252,332 89.7%460,885 - 366,366 79.5% Sales Tax 1 313.11 2,918,722 267,264 2,376,608 81.4%2,738,244 254,002 2,229,330 81.4%2,486,611 239,390 2,050,133 82.4% special purpose 313.15 907,549 82,991 742,780 81.8%876,170 82,028 720,441 82.2%769,039 73,903 628,829 81.8% Local Criminal Justice 1 313.71 366,157 34,849 308,729 84.3%364,508 34,121 299,286 82.1%318,901 30,508 260,613 81.7% Leasehold Excise Tax 3 317.20 62,000 3,035 53,782 86.7%55,407 2,294 46,960 84.8%59,267 3,123 47,584 80.3% Treas. Collection Fees (REET)3 341.42.31/32/33 70,000 8,763 75,418 107.7%84,213 8,289 72,442 86.0%74,197 7,050 62,671 84.5% Penalties on delinquent taxes 1 359.40.10/.20 132,300 5,338 74,451 56.3%112,239 4,719 86,344 76.9%109,143 5,289 85,256 78.1% Interest on delinquent taxes 1 361.40.10 204,300 11,924 149,949 73.4%213,458 9,490 167,377 78.4%200,845 12,369 165,726 82.5% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 561,000 - 1,390,772 247.9%1,476,638 - 1,422,312 96.3%1,408,800 106,858 1,360,681 96.6% P.U.D. Privilege Tax 4 335.00.91 348,000 - 314,148 90.3%318,107 - 318,107 100.0%370,446 - 370,446 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 476,845 108,114 435,778 91.4%477,057 109,780 477,104 100.0%488,746 128,816 488,746 100.0% Marijuana Enforcement/Excise 336.06.41/336.06.42 39,530 - 16,324 41.3%36,920 - 31,244 84.6%25,568 - 12,784 Liquor Excise Tax 8 336.06.94 40,722 12,013 44,174 108.5%41,772 11,032 41,772 100.0%21,930 10,036 21,930 100.0% Liquor Profit 6 336.06.95 88,434 - 63,375 71.7%84,749 - 63,594 75.0%85,021 - 63,801 75.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.0671 307,661 (3,510) 27,067 8.8%294,890 8,846 35,383 12.0%293,327 8,752 35,006 11.9% Investment Income 1 361.11 218,484 44,022 361,070 165.3%682,617 9,969 651,573 95.5%465,346 6,115 55,257 11.9% Treasurer Invest & Other Fees 1 341.42.15/16/17/18/19/50 16,290 3,868 30,237 185.6%11,599 1,215 9,334 80.5%4,080 377 3,334 81.7% DNR Timber 1 395.1.1 250,000 73,324 167,500 67.0%336,350 19,544 315,545 93.8%473,880 43,797 459,261 96.9% Transfer in 1 397.00 3,000 - 38,087 1269.6%46,441 - 45,691 98.4%10,373 - 5,000 48.2% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 396 6,009 50.5%46,095 485 16,947 36.8%299,479 4,267 285,543 95.3% Assessor 1 001-010-000 8,700 504 8,677 99.7%8,761 183 6,343 72.4%1,125 114 754 67.1% Auditor-Recording Fees 1 341.21.10 70,000 7,069 61,679 88.1%74,077 7,237 60,854 82.1%72,112 6,356 60,701 84.2% Auditor-M.V. License Fees 1 341.48/336.00.93 222,601 15,105 222,886 100.1%229,927 11,893 212,056 92.2%157,587 12,591 137,564 87.3% Auditor-Other Revenue 1 25,252 2,740 25,132 99.5%32,440 2,610 26,056 80.3%84,605 2,506 74,894 88.5% Elections 1 001-021-000 110,711 - 114,205 103.2%160,903 - 153,467 95.4%101,929 575 69,248 67.9% Clerk 1 001-020-000 199,087 10,256 144,770 72.7%192,402 15,527 162,609 84.5%211,930 13,586 169,655 80.1% Commissioners 1 001-060-000 8,000 880 7,380 92.3%8,609 819 7,129 82.8%8,663 741 7,296 84.2% Safety & Security 1 001-067-000 64,959 11,368 66,877 103.0%70,305 - 58,168 82.7%71,593 - 58,473 81.7% Community Services 1 001-068-000 9,900 46 3,931 39.7%8,269 1,871 8,189 99.0%4,488 46 3,407 75.9% District Court 1 001-080-000 660,257 31,966 498,162 75.4%632,629 41,626 529,316 83.7%667,142 39,808 540,200 81.0% Juvenile Service 1 001-110-000 253,516 - 196,071 77.3%260,358 24,853 208,488 80.1%248,694 31,417 209,848 84.4% Prosecuting Attorney 1 001-150-000 195,552 7,062 132,858 67.9%124,918 6,911 107,020 85.7%224,953 7,061 187,125 83.2% Coroner 1 001-151-000 17,200 - 24,610 143.1%8,340 - 8,340 100.0%11,140 - 11,140 100.0% Sheriff 1 001-180-000 567,029 11,908 452,611 79.8%626,703 13,623 488,002 77.9%530,346 21,102 450,148 84.9% Superior Court 1 001-240-000 19,500 1,374 69,113 354.4%26,142 - 20,732 79.3%19,952 (32) 4,686 23.5% Non Departmental 1 001-270-000 49,416 - 10 0.0%10 TOTAL CURRENT EXPENSE 18,255,679 3,434,704 16,695,192 91.5%19,277,851 3,222,255 16,827,503 87.3%18,950,211 3,277,992 16,136,231 85.2% *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 OCT 2013 LESS $201,525.00 REF EXP LIABILITY PROP INS PREMIUM / 2012 LESS 253,332-CY REF EXP 2014 REFUND EXP 216,222 YTD REFUND EXPEND CY/PRIOR exclu 388/89 196,247 227,250 4,972 17,338 10,426 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2017 3 year view 11/8/2017 FUND Fund #Budget Oct YTD YTD ACTUAL Oct YTD YTD ACTUAL Oct YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % SPECIAL REVENUE Auditor's O & M 105 77,169 2,703 73,578 95.3%74,342 2,488 69,858 94.0%71,081 2,267 66,892 94.1% Court Facilitator 106 6,000 560 4,980 83.0%6,220 360 4,960 79.7%5,989 400 5,188 86.6% Boating Safety 107 54,632 7,222 49,100 89.9%61,493 9,455 61,488 100.0%44,988 - 34,856 77.5% WSU Cooperative 108 590,016 89,371 404,980 68.6%528,605 32,856 414,388 78.4%326,722 380 255,212 78.1% 4-H After School 113 20,950 - 41,733 199.2%10,600 - 10,600 100.0%46,129 - 37,177 80.6% JeffComCap 119 119 254,650 21,221 212,397 83.4%276,062 24,172 230,264 83.4%286,656 24,551 237,553 82.9% Crime Victim's Svc 120 50,418 1,009 76,456 151.6%79,335 23,827 76,921 97.0%62,364 12,133 58,307 93.5% Grant Mgmt 123 150,000 - 58,345 38.9%95,126 - 61,954 65.1%69,440 - 38,570 55.5% Hotel-Motel 125 425,500 58,458 405,944 95.4%449,148 59,970 365,065 81.3%386,107 49,182 301,928 78.2% H&HS Site Abatement 126 - - - - - - 14,139 - - 0.0% Jeff Co Public Health 127 3,964,210 380,814 3,425,547 86.4%4,076,806 230,435 3,424,294 84.0%3,898,751 306,238 3,296,340 84.5% Water Quality 128 1,029,803 104,598 806,344 78.3%999,219 100,859 794,547 79.5%880,574 120,371 736,312 83.6% Mental Health 130 47,650 14,543 43,269 90.8%46,854 13,494 42,553 90.8%47,746 13,184 42,971 90.0% Chem Dep Mnt Hlth tx 131 490,490 47,850 424,756 86.6%500,457 46,898 411,364 82.2%442,353 41,954 358,745 81.1% Drug Fund 135 23,438 768 9,974 42.6%23,562 1,350 21,521 91.3%18,657 1,322 13,272 71.1% Law Library 140 10,150 905 8,399 82.7%9,692 873 8,088 83.5%10,334 851 8,723 84.4% Trial Court Imprvmnt 141 25,000 - 11,726 46.9%22,669 5,766 22,669 100.0%22,905 5,772 22,905 100.0% Public Defense Fnd 142 35,000 - - 0.0%36,673 - - 0.0%42,076 - - 0.0% Community Develpmnt 143 1,594,110 78,776 1,185,416 74.4%1,668,687 77,286 1,361,769 81.6%1,555,523 91,226 1,183,945 76.1% Jeff Co Affrdbl Hsg 148 198,431 24,965 208,847 105.2%243,809 22,866 202,360 83.0%240,673 21,498 200,954 83.5% Treasurer's O & M 150 47,140 99 19,374 41.1%23,981 1,631 17,101 71.3%26,138 943 17,247 66.0% REET technology 151 14,420 1,520 14,012 97.2%16,194 1,419 13,526 83.5%15,156 1,412 12,751 84.1% Veteran's Relief 155 59,330 14,789 60,671 102.3%63,652 13,693 59,244 93.1%63,899 13,360 59,043 92.4% Water Pollution Cntrl 160 - - - 18,607 941 18,607 100.0%12,058 100 11,858 98.3% Park & Rec 174 586,640 11,962 455,918 77.7%569,174 9,646 422,009 74.1%594,033 11,011 456,508 76.8% County Park Imprvmnt 175 117,886 2,729 86,866 73.7%84,284 722 83,828 99.5%60,301 1,862 59,817 99.2% County Roads 180 10,012,963 2,264,110 8,485,436 84.7%8,949,637 1,509,489 6,823,164 76.2%9,720,929 1,518,975 7,895,740 81.2% Facilities Mgmt 183 1,037,953 86,631 866,756 83.5%1,116,468 87,082 942,606 84.4%958,738 23,137 784,554 81.8% County Fair 199 250,000 10,943 294,258 117.7%269,769 13,406 249,787 92.6%271,091 14,164 261,038 96.3% Total Special Revenue 21,173,949 3,215,605 17,735,082 83.8%20,321,124 2,277,578 16,214,536 79.8%20,195,549 2,262,130 16,458,410 81.5% OTHER FUNDS REVENUE REPORT 2017 3 year view FUND Budget Oct YTD YTD Budget Oct YTD YTD Budget Oct YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % CAPITAL IMPROVEMENT Const/Renovation 301 500,000 3,510 515,341 103.1%1,113,333 1,721 838,333 75.3%234,915 1,702 234,915 100.0% Capital Improvement 302 1,048,750 113,373 1,065,339 101.6%1,537,774 137,192 1,079,347 70.2%2,076,934 102,267 1,028,461 49.5% Public Infrastructure 306 411,400 46,069 395,800 96.2%456,854 42,109 374,839 82.0%399,328 38,071 326,421 81.7% Conservation Futures 308 239,645 77,596 232,939 97.2%244,237 70,062 221,545 90.7%246,862 68,216 222,054 90.0% Total CAP IMP 2,199,795 240,548 2,209,419 100.4%3,352,198 251,084 2,514,064 75.0%2,958,038 210,257 1,811,852 61.3% ENTERPRISE Solid Waste 401 3,408,989 284,390 2,942,027 86.3%3,481,538 281,921 2,935,131 84.3%3,137,778 135,661 2,515,955 80.2% Solid Waste Post Clos 402 150 154 646 430.5%335 37 269 80.3%103 10 83 80.9% Solid Waste Eqpt Res 403 1,500 2,162 9,047 603.1%302,768 306 2,206 0.7%779 75 627 80.5% Yard Waste Educ Fnd 404 7,740 1 24 0.3%1,781 4 32 1.8%12 1 10 78.9% Tri Area Sewer 405 201,000 590 5,541 2.8%172,740 288 2,251 1.3%206,433 119 170,821 82.7% Total ENTERPRISE 3,619,379 287,296 2,957,284 81.7%3,959,162 282,556 2,939,889 74.3%3,345,106 135,866 2,687,497 80.3% INTERNAL SERVICE Equipment Rental 501 2,411,194 171,654 2,058,816 85.4%2,179,575 188,374 1,732,503 79.5%2,146,936 336,950 1,703,163 79.3% Risk Management 502 150,000 - 75,111 50.1%57,666 - 15,034 26.1%76,871 - 75,813 98.6% Benefit Reserve 505 198,000 14,778 198,491 100.2%215,434 13,383 192,252 89.2%251,189 12,687 183,210 72.9% Information Services 506 1,696,833 438,214 1,705,879 100.5%1,551,832 384,323 1,504,355 96.9%1,639,415 171,366 1,331,384 81.2% Total INT SERV 4,456,027 624,647 4,038,297 90.6%4,004,508 586,080 3,444,144 86.0%4,114,411 521,003 3,293,571 80.0% Total 31,449,150 4,368,096 26,940,082 85.7%31,636,992 3,397,298 25,112,633 79.4%30,613,104 3,129,256 24,251,329 79.2% GENERAL FUND CASH BALANCE REPORT 11/9/2017 END OF MONTH CASH BALANCES 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 January $3,761,366 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$ February $3,486,901 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$ March $2,898,116 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$ April $4,932,654 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 $4,816,082 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 $4,785,927 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 $4,308,238 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 $3,191,594 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,986,861 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 $4,764,280 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 $4,063,841 3,281,183$ 3,339,559$ 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ December $3,601,124 3,297,287$ 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Budg *** Total Reserve $1,528,008 $ 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 10% GF Budgeted Expenditures $1,528,008 $ 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 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,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. $0 $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 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 GENERAL SALES TAX RECEIPTS 10/30/2017 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End 3 yr. avg Expected Actual Over/Under Cum %projection 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2014-16 2017 2017 Expected expected Projection Over/UnderJanuary207,318 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 7.0%204,021 185,505 -$18,516 90.92%$2,653,836 -$264,886February206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 9.6%279,659 310,729 $12,554 102.60%$2,994,476 $75,754March170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 6.9%200,049 189,576 $2,081 100.30%$2,927,606 $8,884April162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 6.7%195,136 193,862 $807 100.09%$2,921,401 $2,679 May 212,586 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 8.1%237,474 249,596 $12,929 101.16%$2,952,525 $33,803June 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 7.3%213,056 208,349 $8,222 100.62%$2,936,773 $18,051July174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 7.5%218,798 236,448 $25,872 101.67%$2,967,496 $48,774August244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 10.3%299,583 293,953 $20,242 101.10%$2,950,695 $31,973September213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 9.1%266,501 241,325 -$4,934 99.77%$2,911,911 -$6,811 October 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 9.3%272,120 267,264 -$9,790 99.59%$2,906,748 -$11,974November239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 10.2%296,790 - -$306,580 88.57%$2,585,230 -$333,492December197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 8.1%235,535 - -$542,114 81.43%$2,376,608 -$542,114TTL2,410,507 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,376,608 100.0%$2,918,722 $2,376,608ytd 1,972,709 1,767,762 1,567,333 1,641,937 1,664,085 1,958,663 1,873,754 2,050,133 2,229,330 2,376,608 2,386,398 2,376,608 through December ytd change 103.85%-10.39%-11.34%4.76%1.35%17.70%-4.34%9.41%8.74%6.61%-0.41%over (under) ytd expected annual % chg.-1.77%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12% Special Purp./Public Safety TaxActualActualActual Actual Actual Actual 3 yr avg.Projection Actual 2012 2013 2014 2015 2016 2017 2014-16 2017 2017 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 6.80%61,714 61,161 265,736 246,667 -7.2%February 61,899 70,678 67,508 73,364 83,521 93,242 9.56%86,762 93,242 366,421 403,971 10.2%March 40,604 56,106 49,782 50,931 62,285 61,183 6.94%63,023 61,183 263,072 250,759 -4.7%April 43,155 51,054 47,573 52,541 59,481 59,911 6.80%61,707 59,911 256,844 253,772 -1.2% May 51,908 58,324 56,012 62,613 74,233 78,716 8.22%74,569 78,716 312,043 328,312 5.2%June 46,797 50,067 48,647 58,717 65,832 65,229 7.38%66,967 65,229 280,023 273,577 -2.3%July 49,385 68,295 54,074 56,793 69,908 73,136 7.70%69,897 73,136 288,695 309,584 7.2%August 56,220 56,063 68,712 76,734 87,275 89,679 9.91%89,982 89,679 389,565 383,632 -1.5%September 54,902 61,455 64,622 72,022 77,854 77,534 9.14%82,936 77,534 349,437 318,859 -8.8% October 61,120 64,400 64,152 73,903 82,028 82,991 9.38%85,095 82,991 357,215 350,255 -1.9%November 60,952 64,915 71,491 77,947 89,596 10.18%92,423 - 389,213 - December 49,281 52,177 59,043 62,263 66,133 7.99%72,473 - 308,008 - TOTAL 621,440 704,453 701,993 769,039 876,170 742,780 100.0%907,549 742,780 3,826,271 3,119,388 ytd $511,207 $587,361 $571,459 $628,829 $720,441 $742,780 $742,653 $742,780 $3,129,050 $3,119,388 -0.3% 0.02%over (under) ytd expected TOTAL 2017 SALES TAX Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules. Budget Appropriation 9/11/2017 to increase Sales Tax and Special Purpose budgeted revenue 100,000 150,000 200,000 250,000 300,000 GENERAL SALES TAX RECEIPTS 2017 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation TOTAL Recent 2017 2017 % Budget 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 4 YR AVG Budget Actual Difference January $45,530 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 40,628$ 44,304$ 78,597$ 77% February $45,612 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 36,290$ 39,574$ 47,854$ 21% March $63,286 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 82,992$ 90,501$ 91,388$ 1% April $105,272 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 63,828$ 69,602$ 78,523$ 13% May $49,638 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 73,696$ 80,363$ 111,101$ 38% June $54,812 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 123,615$ 134,798$ 147,551$ 9% July $57,890 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 85,350$ 93,071$ 105,582$ 13% August $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 86,183$ 93,980$ 110,037$ 17% September $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 113,545$ 123,818$ 181,336$ 46% October $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 90,715$ 98,922$ 113,373$ 15% November $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 77,577$ 84,596$ -$ December $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 87,323$ 95,223$ -$ Total $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,065,339 961,744$ 1,048,750$ 1,065,339$ 2% YTD $566,016 $455,568 $366,374 $382,801 $431,935 $518,201 $561,365 $1,028,461 $1,079,347 $1,065,339 796,843$ 868,931$ 1,065,339$ 23% Y/Y chg -33.00%-19.51%-19.58%4.48%12.84%19.97%8.33%83.21%4.95%-1.30% Jan 2016 2 sales at $1.275M and $755K Sept 2016 9 sales>$500k in JC May 2017 1@$1.098, 1@$1.035, 6 Res>$500k Feb 2016 3 sales >$500k Oct 2016 3 sales @ $5.3M, 1.9M & 1.3M, 8>$500k Jun 2017 1@$1.05, 16>$500k Mar 2016 3 Res >$500k Nov 2016 1 Res @$1.2M, 4 Res>$500k July 2017 6>$500k Apr 2016 3 Res >$500k Dec 2016 1@1.69M, 1@2.08M, 2 Res>$500k Aug 2017 1@$1.024, 1@1.37 and 11>$500k May 2016 5 Res >$500k Jan 2017 1@1.565M, 6 Res>$500k Sept 2017 12>$500k Jun 2016 11.7k acres for $27.4M, 6 Res>$500k Feb 2017 5 Res>$500k Oct 2017 2 sales @$1.31M and $1.445M, 6 res>$500k July 2016 284 ac for $1.2M, 6 Res > $500k Mar 2017 6 Res>$500k Aug 2016 6 sales >$500k in JC Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k 11/8/2017 $0 $50,000 $100,000 $150,000 $200,000 $250,000 REET RECEIPTS 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 11/8/2017 REVENUE 4 yr avg *2017 2017 % Budget 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2013-16 Budget Actual Difference January $15,742 16,089$ 10,732$ 11,507$ 12,045$ $8,863 $13,575 $17,051 $18,473 $19,394 14,490$ 16,820$ $19,394 15.3% February $29,461 27,998$ 21,729$ 25,532$ 23,188$ $38,274 $30,356 $36,141 $51,077 $53,093 38,962$ 45,225$ $53,093 17.4% March $10,723 22,623$ 9,838$ 12,406$ 7,271$ $11,203 $12,715 $14,345 $14,554 $16,889 13,204$ 15,327$ $16,889 10.2% April $11,702 11,344$ 11,934$ 10,791$ 14,950$ $11,430 $12,427 $14,983 $18,530 $20,901 14,343$ 16,648$ $20,901 25.5%May $20,360 19,646$ 19,561$ 25,142$ 17,142$ $18,010 $19,151 $23,886 $29,462 $45,943 22,627$ 26,265$ $45,943 74.9% June $18,853 19,205$ 19,650$ 17,302$ 17,916$ $16,477 $18,786 $25,070 $29,476 $31,485 22,452$ 26,062$ $31,485 20.8% July $23,514 20,155$ 14,326$ 19,311$ 20,201$ $21,512 $24,536 $27,711 $33,687 $38,400 26,861$ 31,180$ $38,400 23.2% August $37,302 35,178$ 36,076$ 24,742$ 31,171$ $33,140 $37,534 $48,845 $56,349 $64,820 43,967$ 51,035$ $64,820 27.0% September $41,768 41,757$ 40,208$ 42,500$ 40,882$ $39,890 $42,349 $44,713 $53,487 $56,561 45,110$ 52,362$ $56,561 8.0% October $42,480 43,012$ 46,548$ 43,861$ 41,015$ $41,741 $43,659 $49,182 $59,970 $58,458 48,638$ 56,457$ $58,458 3.5% November $44,786 44,351$ 43,285$ 38,547$ 36,906$ $39,146 $46,879 $58,967 $57,999 50,748$ 58,906$ December $21,753 19,873$ 18,741$ 21,703$ 11,109$ $15,514 $33,858 $25,213 $26,084 25,167$ 29,213$ YTD $251,905 $257,007 $230,602 $233,094 $225,781 $240,540 $255,088 $301,928 $365,065 $405,944 $290,655 337,381$ $405,944 20.3% Total $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $405,944 $366,570 425,500$ $405,944 $5,000 $20,000 $35,000 $50,000 $65,000 HOTEL/MOTEL LODGING TAX -Fund 125 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017