Loading...
HomeMy WebLinkAbout2017-06_RevenueReports2017 BARS General Fund Current Expense 6-Jul-17 Jefferson County Treasurer REVENUE NAME BUDGET JUN Y-T-D Y-T-D ACTUAL JUN Y-T-D Y-T-D ACTUAL JUN Y-T-D Y-T-D *2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % Property Tax 1 311.10 7,696,105 52,098 4,347,627 56.5%7,514,257 51,831 4,270,081 56.8%7,388,068 65,212 4,197,581 56.8% Diverted Road Prop Tax 1 311.20 720,000 5,219 413,088 57.4%720,000 5,213 412,667 57.3%720,000 7,327 421,714 58.6% Private Harvest Tax 2 317.40.10/.20 335,000 - 171,790 51.3%281,335 - 183,394 65.2%460,885 - 366,366 79.5% Sales Tax 1 313.11 2,742,000 208,349 1,337,617 48.8%2,738,244 196,762 1,247,500 45.6%2,486,611 196,231 1,139,719 45.8% special purpose 313.15 870,430 65,229 419,441 48.2%876,170 65,832 403,377 46.0%769,039 58,717 349,376 45.4% Local Criminal Justice 1 313.71 366,157 27,351 173,585 47.4%364,508 27,611 167,710 46.0%318,901 24,430 144,631 45.4% Leasehold Excise Tax 3 317.20 62,000 16,256 34,549 55.7%55,407 13,659 29,729 53.7%59,267 15,264 31,722 53.5% Treas. Collection Fees (REET)3 341.42.31/32/33 70,000 8,678 43,384 62.0%84,213 13,529 41,507 49.3%74,197 7,755 32,401 43.7% Penalties on delinquent taxes 1 359.40.10/.20 132,300 11,017 56,126 42.4%112,239 11,069 65,356 58.2%109,143 10,182 65,384 59.9% Interest on delinquent taxes 1 361.40.10 204,300 20,388 114,785 56.2%213,458 16,403 129,313 60.6%200,845 22,330 130,203 64.8% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 561,000 1,390,772 1,390,772 247.9%1,476,638 1,422,312 1,422,312 96.3%1,408,800 1,253,823 1,253,823 89.0% P.U.D. Privilege Tax 4 335.00.91 348,000 314,148 314,148 90.3%318,107 318,107 318,107 100.0%370,446 370,446 370,446 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 476,845 - 219,545 46.0%477,057 - 257,512 54.0%488,746 - 232,313 47.5% Marijuana Enforcement 336.06.41 39,530 5,678 11,354 28.7%36,920 12,784 25,568 69.3%25,568 - 0 Liquor Excise Tax 8 336.06.94 40,722 - 22,491 55.2%41,772 - 21,411 51.3%21,930 - 8,488 38.7% Liquor Profit 6 336.06.95 88,434 21,155 42,310 47.8%84,749 21,220 42,439 50.1%85,021 21,291 42,582 50.1% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.0671 307,661 - 19,800 6.4%294,890 - 17,692 6.0%293,327 - 17,503 6.0% Investment Income 1 361.11 218,484 30,797 207,851 95.1%682,617 15,009 54,628 8.0%465,346 2,071 16,293 3.5% Treasurer Invest & Other Fees 1 341.42.15/16/17/18/19/50 16,290 1,755 20,765 127.5%11,599 873 4,308 37.1%4,080 351 1,881 46.1% DNR Timber 1 395.1.1 250,000 4,884 4,884 2.0%336,350 11,977 224,129 66.6%473,880 14,665 325,972 68.8% Transfer in 1 397.00 3,000 12,226 19,546 651.5%46,441 - 21,687 46.7%10,373 - 5,000 48.2% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 752 3,267 27.5%46,095 3,822 14,629 31.7%299,479 4,723 14,284 4.8% Assessor 1 001-010-000 8,700 2,154 6,223 71.5%8,761 42 4,004 45.7%1,125 17 474 42.2% Auditor-Recording Fees 1 341.21.10 70,000 6,623 37,134 53.0%74,077 7,459 35,185 47.5%72,112 6,624 34,659 48.1% Auditor-M.V. License Fees 1 341.48/336.00.93 222,601 18,609 126,215 56.7%229,927 18,121 118,273 51.4%157,587 17,378 80,650 51.2% Auditor-Other Revenue 1 25,252 2,164 15,364 60.8%32,440 2,943 16,305 50.3%84,605 1,858 38,149 45.1% Elections 1 001-021-000 110,711 31,790 55,987 50.6%160,903 - 73,405 45.6%101,929 3,516 55,146 54.1% Clerk 1 001-020-000 199,087 13,562 88,514 44.5%192,402 14,849 97,578 50.7%211,930 12,181 105,981 50.0% Commissioners 1 001-060-000 8,000 792 4,402 55.0%8,609 861 4,125 47.9%8,663 774 4,141 47.8% Safety & Security 1 001-067-000 64,959 - 29,574 45.5%70,305 - 27,802 39.5%71,593 4,774 15,003 21.0% Community Services 1 001-068-000 9,900 35 2,036 20.6%8,269 52 2,288 27.7%4,488 35 2,820 62.8% District Court 1 001-080-000 660,257 32,980 318,325 48.2%632,629 107,678 329,753 52.1%667,142 120,181 336,498 50.4% Juvenile Service 1 001-110-000 253,516 50,602 150,310 59.3%260,358 8,742 127,107 48.8%248,694 26,939 141,051 56.7% Prosecuting Attorney 1 001-150-000 195,552 6,911 88,714 45.4%124,918 6,776 75,571 60.5%224,953 13,051 132,279 58.8% Coroner 1 001-151-000 17,200 - 24,610 143.1%8,340 - 8,340 100.0%11,140 - 3,480 31.2% Sheriff 1 001-180-000 567,029 121,997 303,411 53.5%626,703 63,885 335,917 53.6%530,346 62,389 294,256 55.5% Superior Court 1 001-240-000 19,500 - 46,660 239.3%26,142 - 15,321 58.6%19,952 - 4,500 22.6% Non Departmental 1 001-270-000 49,416 - 10 0.0%- 10 TOTAL CURRENT EXPENSE 18,041,838 2,484,972 10,686,214 59.2%19,277,851 2,439,421 10,646,031 55.2%18,950,211 2,344,534 10,416,768 55.0% * 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 10,395 12,421 3,654.65 10,032 0 10,426 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2017 3 year view 7/6/2017 FUND Fund #Budget Jun YTD YTD ACTUAL Jun YTD YTD ACTUAL Jun YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % SPECIAL REVENUE Auditor's O & M 105 77,169 2,405 13,220 17.1%74,342 2,619 12,655 17.0%71,081 2,317 12,396 17.4% Court Facilitator 106 6,000 600 3,300 55.0%6,220 640 3,000 48.2%5,989 520 2,948 49.2% Boating Safety 107 54,632 - 30,458 55.8%61,493 - 39,200 63.7%44,988 436 34,378 76.4% WSU Cooperative 108 590,016 4,897 242,497 41.1%528,605 4,987 288,941 54.7%326,722 2,076 150,264 46.0% 4-H After School 113 20,950 - 22,733 108.5%10,600 - 10,600 100.0%46,129 - 28,225 61.2% JeffComCap 119 119 254,650 37,601 143,893 56.5%276,062 22,899 137,395 49.8%286,656 24,551 139,347 48.6% Crime Victim's Svc 120 50,418 1,137 53,274 105.7%79,335 2,074 25,451 32.1%62,364 2,632 28,525 45.7% Grant Mgmt 123 150,000 2,541 52,644 35.1%95,126 - 61,954 65.1%69,440 - 34,086 49.1% Hotel-Motel 125 425,500 31,485 187,705 44.1%449,148 29,476 161,572 36.0%386,107 25,070 131,476 34.1% H&HS Site Abatement 126 - - - - - - 14,139 - - 0.0% Jeff Co Public Health 127 3,964,210 194,265 2,166,885 54.7%4,076,806 225,018 2,235,671 54.8%3,898,751 330,659 2,032,494 52.1% Water Quality 128 1,029,803 5,380 524,824 51.0%999,219 46,632 524,133 52.5%880,574 38,474 486,764 55.3% Mental Health 130 47,650 417 26,223 55.0%46,854 454 26,961 57.5%47,746 552 27,989 58.6% Chem Dep Mnt Hlth tx 131 490,490 37,601 239,075 48.7%500,457 37,883 230,515 46.1%442,353 33,619 199,241 45.0% Drug Fund 135 23,438 1,138 6,256 26.7%23,562 10,135 16,861 71.6%18,657 2,321 8,307 44.5% Law Library 140 10,150 938 4,914 48.4%9,692 921 4,694 48.4%10,334 702 5,239 50.7% Trial Court Imprvmnt 141 25,000 - 5,863 23.5%22,669 - 11,236 49.6%22,905 - 11,348 49.5% Public Defense Fnd 142 35,000 - - 0.0%36,673 - - 0.0%42,076 - - 0.0% Community Develpmnt 143 1,594,110 97,918 720,869 45.2%1,668,687 141,445 915,051 54.8%1,555,523 97,900 752,129 48.4% Jeff Co Affrdbl Hsg 148 198,431 22,174 122,367 61.7%243,809 24,224 117,560 48.2%240,673 21,057 112,465 46.7% Treasurer's O & M 150 47,140 6,757 12,544 26.6%23,981 3,954 11,080 46.2%26,138 6,888 13,072 50.0% REET technology 151 14,420 1,615 7,789 54.0%16,194 1,497 7,573 46.8%15,156 1,295 6,885 45.4% Veteran's Relief 155 59,330 483 43,144 72.7%63,652 488 43,290 68.0%63,899 567 43,834 68.6% Water Pollution Cntrl 160 - - - 18,607 7,350 17,665 94.9%12,058 100 11,458 95.0% Park & Rec 174 586,640 10,151 298,874 50.9%569,174 6,182 267,564 47.0%594,033 9,854 307,933 51.8% County Park Imprvmnt 175 61,000 6,295 13,774 22.6%84,284 5,195 60,867 72.2%60,301 4,175 38,068 63.1% County Roads 180 10,012,963 188,965 4,330,293 43.2%8,949,637 203,450 4,045,831 45.2%9,720,929 594,454 4,079,811 42.0% Facilities Mgmt 183 1,037,953 87,074 520,203 50.1%1,116,468 86,931 594,732 53.3%958,738 68,984 493,679 51.5% County Fair 199 250,000 47,043 150,769 60.3%269,769 10,966 95,189 35.3%271,091 23,525 118,644 43.8% Total Special Revenue 21,117,063 741,837 9,944,389 47.1%20,321,124 864,453 9,967,240 49.0%20,195,549 1,269,203 9,311,005 46.1% OTHER FUNDS REVENUE REPORT 2017 3 year view FUND Budget Jun YTD YTD Budget Jun YTD YTD Budget Jun YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % CAPITAL IMPROVEMENT Const/Renovation 301 500,000 - 511,754 102.4%1,113,333 - 559,891 50.3%234,915 - 131,511 56.0% Capital Improvement 302 1,048,750 147,551 555,012 52.9%1,537,774 241,046 615,102 40.0%2,076,934 118,836 503,893 24.3% Public Infrastructure 306 411,400 35,111 220,996 53.7%456,854 34,680 210,320 46.0%399,328 30,631 181,350 45.4% Conservation Futures 308 239,645 2,672 140,450 58.6%244,237 2,535 139,981 57.3%246,862 2,897 144,373 58.5% Total CAP IMP 2,199,795 185,334 1,428,212 64.9%3,352,198 278,261 1,525,294 45.5%2,958,038 152,364 961,126 32.5% ENTERPRISE Solid Waste 401 3,408,989 226,441 1,535,077 45.0%3,481,538 306,929 1,650,988 47.4%3,137,778 362,612 1,518,942 48.4% Solid Waste Post Clos 402 150 57 279 185.8%335 23 124 37.0%103 8 46 45.0% Solid Waste Eqpt Res 403 1,500 793 3,895 259.6%302,768 186 1,016 0.3%779 62 349 44.8% Yard Waste Educ Fnd 404 7,740 3 13 0.2%1,781 3 18 1.0%12 1 5 40.5% Tri Area Sewer 405 201,000 524 3,258 1.6%172,740 251 1,135 0.7%206,433 85 415 0.2% Total ENTERPRISE 3,619,379 227,818 1,542,522 42.6%3,959,162 307,392 1,653,280 41.8%3,345,106 362,769 1,519,758 45.4% INTERNAL SERVICE Equipment Rental 501 2,411,194 285,401 1,030,162 42.7%2,179,575 161,101 810,072 37.2%2,146,936 143,549 867,739 40.4% Risk Management 502 150,000 - - 0.0%57,666 - 178 0.3%76,871 - - 0.0% Benefit Reserve 505 198,000 21,821 130,764 66.0%215,434 21,401 128,046 59.4%251,189 18,762 122,631 48.8% Information Services 506 1,696,833 573 821,986 48.4%1,551,832 778 734,627 47.3%1,639,415 879 770,268 47.0% Total INT SERV 4,456,027 307,796 1,982,912 44.5%4,004,508 183,281 1,672,924 41.8%4,114,411 163,190 1,760,638 42.8% Total 31,392,264 1,462,785 14,898,035 47.5%31,636,992 1,633,387 14,818,738 46.8%30,613,104 1,947,525 13,552,527 44.3% GENERAL FUND CASH BALANCE REPORT 7/6/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$ 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$ 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$ 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$ 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 7/6/2017 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End3 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/Under January 207,318 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 7.0%191,668 185,505 -$6,163 96.78%$2,653,836 -$88,164February206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 9.6%262,727 310,729 $41,840 109.21%$2,994,476 $252,476March170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 6.9%187,936 189,576 $43,479 106.77%$2,927,606 $185,606April162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 6.7%183,321 193,862 $54,020 106.54%$2,921,401 $179,401May212,586 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 8.1%223,095 249,596 $80,521 107.68%$2,952,525 $210,525June 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 7.3%200,156 208,349 $88,713 107.10%$2,936,773 $194,773 July 174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 7.5%205,551 - -$116,837 91.97%$2,521,733 -$220,267 August 244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 10.3%281,444 - -$398,281 77.06%$2,112,880 -$629,120 September 213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 9.1%250,365 - -$648,646 67.34%$1,846,556 -$895,444 October 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 9.3%255,644 - -$904,290 59.66%$1,635,994 -$1,106,006 November 239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 10.2%278,820 - -$1,183,110 53.06%$1,455,035 -$1,286,965 December 197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 8.1%221,273 - -$1,404,383 48.78%$1,337,617 -$1,404,383 TTL 2,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 1,337,617 100.0%$2,742,000 $1,337,617 ytd 1,127,351 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,248,903 1,337,617 through December ytd change 16.49%-6.62%-13.42%2.72%-7.14%30.75%-8.46%9.53%9.46%7.22%7.10%over (under) ytd expectedannual % chg.-1.77%-11.33%-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 3 yr avg.Projection Actual2012201320142015201620172014-16 2017 2017 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 6.80%59,190 61,161 250,858 246,667 -1.7%February 61,899 70,678 67,508 73,364 83,521 93,242 9.56%83,213 93,242 345,940 403,971 16.8%March 40,604 56,106 49,782 50,931 62,285 61,183 6.94%60,446 61,183 248,382 250,759 1.0%April 43,155 51,054 47,573 52,541 59,481 59,911 6.80%59,184 59,911 242,505 253,772 4.6% May 51,908 58,324 56,012 62,613 74,233 78,716 8.22%71,519 78,716 294,614 328,312 11.4% June 46,797 50,067 48,647 58,717 65,832 65,229 7.38%64,228 65,229 264,384 273,577 3.5% July 49,385 68,295 54,074 56,793 69,908 7.70%67,038 - 272,589 - August 56,220 56,063 68,712 76,734 87,275 9.91%86,302 - 367,746 - September 54,902 61,455 64,622 72,022 77,854 9.14%79,544 - 329,909 - October 61,120 64,400 64,152 73,903 82,028 9.38%81,615 - 337,258 - November 60,952 64,915 71,491 77,947 89,596 10.18%88,643 - 367,463 - December 49,281 52,177 59,043 62,263 66,133 7.99%69,509 - 290,783 - TOTAL 621,440 704,453 701,993 769,039 876,170 419,441 100.0%870,430 419,441 3,612,430 1,757,058 ytd $289,580 $337,148 $319,899 $349,376 $403,377 $419,441 $397,780 $419,441 $1,646,683 1,757,058 6.7%5.45%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. 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 2016 % 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$ 85,350$ 93,071$ -$ August $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 86,183$ 93,980$ -$ September $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 113,545$ 123,818$ -$ October $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 90,715$ 98,922$ -$ 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 $555,012 961,744$ 1,048,750$ 555,012$ -47% YTD $364,150 $286,430 $222,784 $243,416 $237,545 $264,393 $300,812 $503,893 $615,102 $555,012 421,050$ 459,141$ 555,012$ 21% Y/Y chg -33.00%-21.34%-22.22%9.26%-2.41%11.30%13.77%67.51%22.07%-9.77% 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 Apr 2016 3 Res >$500k Dec 2016 1@1.69M, 1@2.08M, 2 Res>$500k May 2016 5 Res >$500k Jan 2017 1@1.565M, 6 Res>$500k Jun 2016 11.7k acres for $27.4M, 6 Res>$500k Feb 2017 5 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 7/6/2017 $0 $50,000 $100,000 $150,000 $200,000 $250,000 REET RECEIPTS 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 7/6/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 26,861$ 31,180$ August $37,302 35,178$ 36,076$ 24,742$ 31,171$ $33,140 $37,534 $48,845 $56,349 43,967$ 51,035$ September $41,768 41,757$ 40,208$ 42,500$ 40,882$ $39,890 $42,349 $44,713 $53,487 45,110$ 52,362$ October $42,480 43,012$ 46,548$ 43,861$ 41,015$ $41,741 $43,659 $49,182 $59,970 48,638$ 56,457$ 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 $106,841 $116,905 $93,444 $102,680 $92,512 $104,257 $107,010 $131,476 $161,572 $187,705 $126,079 146,347$ $187,705 28.3% Total $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $187,705 $366,570 425,500$ $187,705 $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