Loading...
HomeMy WebLinkAbout2017-07_RevenueRpts2017 BARS General Fund 3-Aug-17 Jefferson County Treasurer REVENUE NAME BUDGET JUL Y-T-D Y-T-D ACTUAL JUL Y-T-D Y-T-D ACTUAL JUL Y-T-D Y-T-D *2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % Property Tax 1 311.10 7,696,105 25,476 4,373,103 56.8%7,514,257 31,476 4,301,556 57.2%7,388,068 30,592 4,228,173 57.2% Diverted Road Prop Tax 1 311.20 720,000 2,457 415,545 57.7%720,000 2,841 415,508 57.7%720,000 2,959 424,673 59.0% 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 236,448 1,574,065 57.4%2,738,244 204,143 1,451,643 53.0%2,486,611 185,889 1,325,608 53.3% special purpose 313.15 870,430 73,136 492,577 56.6%876,170 69,908 473,285 54.0%769,039 56,793 406,170 52.8% Local Criminal Justice 1 313.71 366,157 30,359 203,944 55.7%364,508 28,992 196,702 54.0%318,901 23,622 168,253 52.8% Leasehold Excise Tax 3 317.20 62,000 - 34,549 55.7%55,407 - 29,729 53.7%59,267 - 31,722 53.5% Treas. Collection Fees (REET)3 341.42.31/32/33 70,000 7,145 50,530 72.2%84,213 8,104 49,611 58.9%74,197 8,074 40,475 54.6% Penalties on delinquent taxes 1 359.40.10/.20 132,300 5,883 62,008 46.9%112,239 6,764 72,121 64.3%109,143 6,529 71,913 65.9% Interest on delinquent taxes 1 361.40.10 204,300 11,474 126,259 61.8%213,458 11,526 140,839 66.0%200,845 9,324 139,526 69.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 - 1,253,823 89.0% 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,119 327,664 68.7%477,057 109,812 367,324 77.0%488,746 127,618 359,931 73.6% Marijuana Enforcement/Excise 336.06.41/336.06.42 39,530 - 11,354 28.7%36,920 - 25,568 69.3%25,568 0 Liquor Excise Tax 8 336.06.94 40,722 9,670 32,161 79.0%41,772 9,328 30,739 73.6%21,930 3,406 11,894 54.2% Liquor Profit 6 336.06.95 88,434 - 42,310 47.8%84,749 - 42,439 50.1%85,021 - 42,582 50.1% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.0671 307,661 10,777 30,577 9.9%294,890 8,846 26,537 9.0%293,327 8,752 26,255 9.0% Investment Income 1 361.11 218,484 42,143 249,994 114.4%682,617 11,766 66,394 9.7%465,346 (1,109) 15,184 3.3% Treasurer Invest & Other Fees 1 341.42.15/16/17/18/19/50 16,290 1,808 22,573 138.6%11,599 1,236 5,544 47.8%4,080 382 2,263 55.5% DNR Timber 1 395.1.1 250,000 - 4,884 2.0%336,350 - 224,129 66.6%473,880 30,831 356,803 75.3% Transfer in 1 397.00 3,000 - 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 2,277 5,544 46.6%46,095 1,072 15,701 34.1%299,479 8,212 22,496 7.5% Assessor 1 001-010-000 8,700 65 6,288 72.3%8,761 340 4,345 49.6%1,125 30 504 44.8% Auditor-Recording Fees 1 341.21.10 70,000 5,626 42,760 61.1%74,077 6,408 41,593 56.1%72,112 7,115 41,774 57.9% Auditor-M.V. License Fees 1 341.48/336.00.93 222,601 15,421 141,636 63.6%229,927 15,085 133,358 58.0%157,587 17,389 98,039 62.2% Auditor-Other Revenue 1 25,252 2,326 17,690 70.1%32,440 1,692 17,997 55.5%84,605 3,977 42,126 49.8% Elections 1 001-021-000 110,711 - 55,987 50.6%160,903 78,529 151,935 94.4%101,929 - 55,146 54.1% Clerk 1 001-020-000 199,087 9,545 98,059 49.3%192,402 14,038 111,616 58.0%211,930 15,831 121,812 57.5% Commissioners 1 001-060-000 8,000 684 5,086 63.6%8,609 716 4,841 56.2%8,663 875 5,016 57.9% Safety & Security 1 001-067-000 64,959 10,216 39,790 61.3%70,305 - 27,802 39.5%71,593 - 15,003 21.0% Community Services 1 001-068-000 9,900 40 2,077 21.0%8,269 534 2,822 34.1%4,488 421 3,241 72.2% District Court 1 001-080-000 660,257 31,076 349,401 52.9%632,629 33,599 363,352 57.4%667,142 40,299 376,797 56.5% Juvenile Service 1 001-110-000 253,516 11,874 162,184 64.0%260,358 23,536 150,644 57.9%248,694 6,470 147,521 59.3% Prosecuting Attorney 1 001-150-000 195,552 11,535 100,249 51.3%124,918 6,776 82,347 65.9%224,953 19,842 152,122 67.6% 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 47,938 351,348 62.0%626,703 7,865 343,782 54.9%530,346 57,632 351,887 66.4% 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 713,517 11,399,732 63.2%19,277,851 694,931 11,340,963 58.8%18,950,211 671,755 11,088,523 58.5% * 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 12,421 1190.16 11,222 10,426 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2017 3 year view 8/3/2017 FUND Fund #Budget Jul YTD YTD ACTUAL Jul YTD YTD ACTUAL Jul YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % SPECIAL REVENUE Auditor's O & M 105 77,169 53,239 66,459 86.1%74,342 50,246 62,901 84.6%71,081 47,594 59,989 84.4% Court Facilitator 106 6,000 340 3,640 60.7%6,220 540 3,540 56.9%5,989 600 3,548 59.3% Boating Safety 107 54,632 11,420 41,877 76.7%61,493 - 39,200 63.7%44,988 261 34,638 77.0% WSU Cooperative 108 590,016 13,211 255,708 43.3%528,605 1,235 290,176 54.9%326,722 4,588 154,852 47.4% 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 4,841 148,734 58.4%276,062 22,899 160,294 58.1%286,656 24,551 163,899 57.2% Crime Victim's Svc 120 50,418 19,825 73,099 145.0%79,335 24,348 49,799 62.8%62,364 12,143 40,668 65.2% Grant Mgmt 123 150,000 - 52,644 35.1%95,126 - 61,954 65.1%69,440 - 34,086 49.1% Hotel-Motel 125 425,500 38,400 226,104 53.1%449,148 33,687 195,259 43.5%386,107 27,711 159,187 41.2% H&HS Site Abatement 126 - - - - - - 14,139 - - 0.0% Jeff Co Public Health 127 3,964,210 324,451 2,491,336 62.8%4,076,806 328,341 2,564,012 62.9%3,898,751 336,860 2,369,354 60.8% Water Quality 128 1,029,803 5,335 530,160 51.5%999,219 6,055 530,188 53.1%880,574 61,785 548,549 62.3% Mental Health 130 47,650 148 26,371 55.3%46,854 184 27,145 57.9%47,746 340 28,329 59.3% Chem Dep Mnt Hlth tx 131 490,490 41,721 280,796 57.2%500,457 39,849 270,364 54.0%442,353 32,486 231,728 52.4% Drug Fund 135 23,438 814 7,070 30.2%23,562 1,016 17,877 75.9%18,657 1,150 9,457 50.7% Law Library 140 10,150 758 5,671 55.9%9,692 824 5,518 56.9%10,334 820 6,059 58.6% Trial Court Imprvmnt 141 25,000 5,863 11,726 46.9%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 113,533 834,402 52.3%1,668,687 76,561 991,612 59.4%1,555,523 110,965 863,093 55.5% Jeff Co Affrdbl Hsg 148 198,431 19,393 141,760 71.4%243,809 20,401 137,961 56.6%240,673 24,090 136,556 56.7% Treasurer's O & M 150 47,140 4,684 17,228 36.5%23,981 2,201 13,281 55.4%26,138 3,215 16,288 62.3% REET technology 151 14,420 1,548 9,337 64.7%16,194 1,531 9,104 56.2%15,156 1,610 8,494 56.0% Veteran's Relief 155 59,330 218 43,362 73.1%63,652 267 43,556 68.4%63,899 354 44,189 69.2% Water Pollution Cntrl 160 - - - 18,607 - 17,665 94.9%12,058 100 11,558 95.9% Park & Rec 174 586,640 3,201 302,074 51.5%569,174 9,047 276,610 48.6%594,033 7,539 315,472 53.1% County Park Imprvmnt 175 61,000 52,640 66,414 108.9%84,284 8,701 69,568 82.5%60,301 5,570 43,638 72.4% County Roads 180 10,012,963 421,777 4,752,070 47.5%8,949,637 363,717 4,409,548 49.3%9,720,929 737,178 4,816,989 49.6% Facilities Mgmt 183 1,037,953 86,659 606,863 58.5%1,116,468 86,931 681,663 61.1%958,738 99,363 593,042 61.9% County Fair 199 250,000 31,641 182,410 73.0%269,769 28,194 123,383 45.7%271,091 29,047 147,691 54.5% Total Special Revenue 21,117,063 1,224,017 11,200,047 53.0%20,321,124 1,078,580 11,074,014 54.5%20,195,549 1,540,872 10,880,923 53.9% OTHER FUNDS REVENUE REPORT 2017 3 year view FUND Budget Jul YTD YTD Budget Jul YTD YTD Budget Jul YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % CAPITAL IMPROVEMENT Const/Renovation 301 500,000 77 511,831 102.4%1,113,333 1,721 561,612 50.4%234,915 1,702 133,213 56.7% Capital Improvement 302 1,048,750 105,582 660,594 63.0%1,537,774 105,451 720,552 46.9%2,076,934 110,603 614,496 29.6% Public Infrastructure 306 411,400 38,912 259,908 63.2%456,854 36,566 246,886 54.0%399,328 29,615 210,965 52.8% Conservation Futures 308 239,645 1,351 141,800 59.2%244,237 1,175 141,155 57.8%246,862 1,818 146,191 59.2% Total CAP IMP 2,199,795 145,921 1,574,133 71.6%3,352,198 144,912 1,670,206 49.8%2,958,038 143,738 1,104,864 37.4% ENTERPRISE Solid Waste 401 3,408,989 468,255 2,003,332 58.8%3,481,538 311,614 1,962,602 56.4%3,137,778 302,369 1,821,311 58.0% Solid Waste Post Clos 402 150 65 343 228.8%335 36 159 47.6%103 10 56 54.2% Solid Waste Eqpt Res 403 1,500 902 4,797 319.8%302,768 291 1,308 0.4%779 72 421 54.0% Yard Waste Educ Fnd 404 7,740 3 17 0.2%1,781 4 21 1.2%12 1 6 50.4% Tri Area Sewer 405 201,000 531 3,789 1.9%172,740 276 1,410 0.8%206,433 95 511 0.2% Total ENTERPRISE 3,619,379 469,756 2,012,278 55.6%3,959,162 312,221 1,965,501 49.6%3,345,106 302,547 1,822,305 54.5% INTERNAL SERVICE Equipment Rental 501 2,411,194 177,565 1,207,727 50.1%2,179,575 164,116 974,188 44.7%2,146,936 158,155 1,025,894 47.8% Risk Management 502 150,000 - - 0.0%57,666 - 178 0.3%76,871 - - 0.0% Benefit Reserve 505 198,000 19,461 150,224 75.9%215,434 18,764 146,810 68.1%251,189 17,705 140,336 55.9% Information Services 506 1,696,833 425,124 1,247,111 73.5%1,551,832 341,918 1,076,546 69.4%1,639,415 378,334 1,148,603 70.1% Total INT SERV 4,456,027 622,150 2,605,062 58.5%4,004,508 524,798 2,197,722 54.9%4,114,411 554,194 2,314,832 56.3% Total 31,392,264 2,461,844 17,391,520 55.4%31,636,992 2,060,511 16,907,443 53.4%30,613,104 2,541,351 16,122,925 52.7% GENERAL FUND CASH BALANCE REPORT 8/3/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$ 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 8/3/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%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,401 May 212,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,773July174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 7.5%205,551 236,448 $119,611 108.22%$2,967,496 $225,496August244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 10.3%281,444 - -$161,833 90.68%$2,486,371 -$255,629September213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 9.1%250,365 - -$412,198 79.25%$2,172,969 -$569,031 October 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 9.3%255,644 - -$667,841 70.21%$1,925,186 -$816,814November239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 10.2%278,820 - -$946,661 62.44%$1,712,239 -$1,029,761December197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 8.1%221,273 - -$1,167,935 57.41%$1,574,065 -$1,167,935TTL2,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,574,065 100.0%$2,742,000 $1,574,065ytd 1,302,232 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,454,454 1,574,065 through December ytd change 34.56%-6.93%-13.55%5.22%-7.01%29.30%-8.37%9.13%9.51%8.43%8.22%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%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 73,136 7.70%67,038 73,136 272,589 309,584 13.6%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 492,577 100.0%870,430 492,577 3,612,430 2,066,642 ytd $338,965 $405,443 $373,973 $406,170 $473,285 $492,577 $464,818 $492,577 $1,919,272 2,066,642 7.7% 5.97%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$ 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$ 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 $660,594 961,744$ 1,048,750$ 660,594$ -37% YTD $422,040 $329,584 $257,177 $280,074 $266,401 $322,016 $368,534 $614,496 $720,552 $660,594 506,400$ 552,212$ 660,594$ 20% Y/Y chg -33.00%-21.91%-21.97%8.90%-4.88%20.88%14.45%66.74%17.26%-8.32% 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 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 8/3/2017 $0 $50,000 $100,000 $150,000 $200,000 $250,000 REET RECEIPTS 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 8/3/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 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 $130,355 $137,060 $107,770 $121,991 $112,713 $125,769 $131,546 $159,187 $195,259 $226,104 $152,940 177,527$ $226,104 27.4% Total $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $226,104 $366,570 425,500$ $226,104 $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