Loading...
HomeMy WebLinkAbout2017-09_BC_RevenueRpts2017 BARS General Fund 4-Oct-17 Jefferson County Treasurer REVENUE NAME BUDGET SEP Y-T-D Y-T-D ACTUAL SEP Y-T-D Y-T-D ACTUAL SEP Y-T-D Y-T-D *2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % Property Tax 1 311.10 7,696,105 139,973 4,563,803 59.3%7,514,257 144,452 4,494,533 59.8%7,388,068 155,500 4,417,193 59.8% Diverted Road Prop Tax 1 311.20 720,000 12,853 433,121 60.2%720,000 13,579 433,795 60.2%720,000 15,792 443,460 61.6% 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 241,325 2,109,343 72.3%2,738,244 247,376 1,975,327 72.1%2,486,611 227,766 1,810,743 72.8% special purpose 313.15 907,549 77,534 659,790 72.7%876,170 77,854 638,413 72.9%769,039 72,022 554,926 72.2% Local Criminal Justice 1 313.71 366,157 32,265 273,880 74.8%364,508 32,302 265,166 72.7%318,901 29,986 230,104 72.2% Leasehold Excise Tax 3 317.20 62,000 - 50,748 81.9%55,407 - 44,666 80.6%59,267 - 44,462 75.0% Treas. Collection Fees (REET)3 341.42.31/32/33 70,000 8,640 66,655 95.2%84,213 6,729 64,152 76.2%74,197 8,670 55,621 75.0% Penalties on delinquent taxes 1 359.40.10/.20 132,300 3,119 69,113 52.2%112,239 3,168 81,625 72.7%109,143 3,533 79,968 73.3% Interest on delinquent taxes 1 361.40.10 204,300 5,453 138,025 67.6%213,458 5,292 157,887 74.0%200,845 5,929 153,357 76.4% 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 - 327,664 68.7%477,057 - 367,324 77.0%488,746 - 359,931 73.6% Marijuana Enforcement/Excise 336.06.41/336.06.42 39,530 4,970 16,324 41.3%36,920 5,676 31,244 84.6%25,568 12,784 12,784 Liquor Excise Tax 8 336.06.94 40,722 - 32,161 79.0%41,772 - 30,739 73.6%21,930 - 11,894 54.2% Liquor Profit 6 336.06.95 88,434 21,065 63,375 71.7%84,749 21,155 63,594 75.0%85,021 21,220 63,801 75.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.0671 307,661 - 30,577 9.9%294,890 - 26,537 9.0%293,327 - 26,255 9.0% Investment Income 1 361.11 218,484 46,180 317,048 145.1%682,617 30,557 641,605 94.0%465,346 14,214 49,142 10.6% Treasurer Invest & Other Fees 1 341.42.15/16/17/18/19/50 16,290 1,908 26,369 161.9%11,599 1,261 8,119 70.0%4,080 354 2,957 72.5% DNR Timber 1 395.1.1 250,000 - 94,176 37.7%336,350 38,458 296,001 88.0%473,880 50,238 415,464 87.7% Transfer in 1 397.00 3,000 17,792 38,087 1269.6%46,441 23,254 45,691 98.4%10,373 - 5,000 48.2% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 589 5,613 47.2%46,095 469 16,462 35.7%299,479 255,527 281,276 93.9% Assessor 1 001-010-000 8,700 44 8,173 93.9%8,761 25 6,160 70.3%1,125 21 640 56.9% Auditor-Recording Fees 1 341.21.10 70,000 6,346 54,610 78.0%74,077 5,407 53,616 72.4%72,112 6,566 54,345 75.4% Auditor-M.V. License Fees 1 341.48/336.00.93 222,601 47,380 207,781 93.3%229,927 14,743 200,163 87.1%157,587 12,868 124,973 79.3% Auditor-Other Revenue 1 25,252 2,044 22,392 88.7%32,440 3,029 23,446 72.3%84,605 3,197 72,388 85.6% Elections 1 001-021-000 110,711 58,218 114,205 103.2%160,903 1,532 153,467 95.4%101,929 11,952 68,673 67.4% Clerk 1 001-020-000 199,087 14,070 134,514 67.6%192,402 15,791 147,081 76.4%211,930 13,319 156,069 73.6% Commissioners 1 001-060-000 8,000 728 6,500 81.3%8,609 640 6,310 73.3%8,663 782 6,555 75.7% Safety & Security 1 001-067-000 64,959 8,154 55,509 85.5%70,305 5,333 58,168 82.7%71,593 28,139 58,473 81.7% Community Services 1 001-068-000 9,900 29 3,885 39.2%8,269 3,461 6,318 76.4%4,488 69 3,361 74.9% District Court 1 001-080-000 660,257 33,834 466,196 70.6%632,629 37,504 487,689 77.1%667,142 40,245 500,392 75.0% Juvenile Service 1 001-110-000 253,516 12,164 196,071 77.3%260,358 14,621 183,635 70.5%248,694 16,191 178,430 71.7% Prosecuting Attorney 1 001-150-000 195,552 7,097 125,797 64.3%124,918 6,911 100,109 80.1%224,953 12,953 180,064 80.0% 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 4,172 440,703 77.7%626,703 57,018 474,379 75.7%530,346 56,063 429,046 80.9% Superior Court 1 001-240-000 19,500 - 67,739 347.4%26,142 - 20,732 79.3%19,952 186 4,718 23.6% Non Departmental 1 001-270-000 49,416 - 10 0.0%10 TOTAL CURRENT EXPENSE 18,255,679 807,945 13,260,488 72.6%19,277,851 817,598 13,605,248 70.6%18,950,211 1,076,084 12,858,239 67.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 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 2,888 31,003 608 12,366 10,426 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2017 3 year view 10/4/2017 FUND Fund #Budget Sep YTD YTD ACTUAL Sep YTD YTD ACTUAL Sep YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % SPECIAL REVENUE Auditor's O & M 105 77,169 2,303 70,875 91.8%74,342 1,955 67,370 90.6%71,081 2,357 64,626 90.9% Court Facilitator 106 6,000 500 4,420 73.7%6,220 600 4,600 74.0%5,989 600 4,788 80.0% Boating Safety 107 54,632 - 41,877 76.7%61,493 - 52,033 84.6%44,988 - 34,856 77.5% WSU Cooperative 108 590,016 10,503 315,609 53.5%528,605 7,047 381,532 72.2%326,722 2,350 254,832 78.0% 4-H After School 113 20,950 19,000 41,733 199.2%10,600 - 10,600 100.0%46,129 - 37,177 80.6% JeffComCap 119 119 254,650 21,221 191,176 75.1%276,062 22,899 206,093 74.7%286,656 24,551 213,002 74.3% Crime Victim's Svc 120 50,418 1,272 75,447 149.6%79,335 1,492 53,094 66.9%62,364 2,687 46,174 74.0% Grant Mgmt 123 150,000 - 58,345 38.9%95,126 - 61,954 65.1%69,440 4,485 38,570 55.5% Hotel-Motel 125 425,500 56,561 347,485 81.7%449,148 53,487 305,095 67.9%386,107 44,713 252,746 65.5% H&HS Site Abatement 126 - - - - - - 14,139 - - 0.0% Jeff Co Public Health 127 3,964,210 179,717 3,044,733 76.8%4,076,806 168,254 3,193,859 78.3%3,898,751 223,753 2,990,101 76.7% Water Quality 128 1,029,803 33,927 701,746 68.1%999,219 98,697 693,687 69.4%880,574 25,166 615,941 69.9% Mental Health 130 47,650 806 28,726 60.3%46,854 1,028 29,059 62.0%47,746 1,151 29,788 62.4% Chem Dep Mnt Hlth tx 131 490,490 44,340 376,906 76.8%500,457 44,398 364,466 72.8%442,353 41,239 316,791 71.6% Drug Fund 135 23,438 1,148 9,206 39.3%23,562 1,229 20,171 85.6%18,657 1,171 11,951 64.1% Law Library 140 10,150 877 7,493 73.8%9,692 770 7,215 74.4%10,334 820 7,873 76.2% Trial Court Imprvmnt 141 25,000 - 11,726 46.9%22,669 - 16,903 74.6%22,905 5,785 17,133 74.8% Public Defense Fnd 142 35,000 - - 0.0%36,673 - - 0.0%42,076 - - 0.0% Community Develpmnt 143 1,594,110 59,633 1,106,641 69.4%1,668,687 87,742 1,284,483 77.0%1,555,523 59,029 1,092,719 70.2% Jeff Co Affrdbl Hsg 148 198,431 22,268 183,882 92.7%243,809 18,228 179,494 73.6%240,673 21,943 179,456 74.6% Treasurer's O & M 150 47,140 505 19,274 40.9%23,981 17 15,471 64.5%26,138 4 16,304 62.4% REET technology 151 14,420 1,688 12,492 86.6%16,194 1,500 12,107 74.8%15,156 1,386 11,339 74.8% Veteran's Relief 155 59,330 884 45,883 77.3%63,652 1,068 45,551 71.6%63,899 1,174 45,683 71.5% Water Pollution Cntrl 160 - - - 18,607 - 17,665 94.9%12,058 100 11,758 97.5% Park & Rec 174 586,640 19,675 443,955 75.7%569,174 18,494 412,363 72.4%594,033 16,896 445,497 75.0% County Park Imprvmnt 175 61,000 5,597 84,137 137.9%84,284 3,357 83,106 98.6%60,301 5,903 57,955 96.1% County Roads 180 10,012,963 711,321 6,221,326 62.1%8,949,637 395,090 5,313,675 59.4%9,720,929 1,048,971 6,376,764 65.6% Facilities Mgmt 183 1,037,953 91,833 780,125 75.2%1,116,468 86,931 855,524 76.6%958,738 84,151 761,417 79.4% County Fair 199 250,000 25,732 283,315 113.3%269,769 29,577 236,381 87.6%271,091 24,991 246,874 91.1% Total Special Revenue 21,117,063 1,285,578 14,508,535 68.7%20,321,124 1,014,283 13,923,552 68.5%20,195,549 1,620,385 14,182,115 70.2% OTHER FUNDS REVENUE REPORT 2017 3 year view FUND Budget Sep YTD YTD Budget Sep YTD YTD Budget Sep YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % CAPITAL IMPROVEMENT Const/Renovation 301 500,000 - 511,831 102.4%1,113,333 - 836,612 75.1%234,915 - 233,213 99.3% Capital Improvement 302 1,048,750 181,336 951,966 90.8%1,537,774 95,883 942,154 61.3%2,076,934 219,697 926,194 44.6% Public Infrastructure 306 411,400 41,494 349,731 85.0%456,854 40,422 332,730 72.8%399,328 37,516 288,350 72.2% Conservation Futures 308 239,645 4,839 155,343 64.8%244,237 5,531 151,484 62.0%246,862 6,002 153,838 62.3% Total CAP IMP 2,199,795 227,669 1,968,871 89.5%3,352,198 141,835 2,262,980 67.5%2,958,038 263,214 1,601,595 54.1% ENTERPRISE Solid Waste 401 3,408,989 352,151 2,657,637 78.0%3,481,538 427,742 2,653,210 76.2%3,137,778 279,698 2,380,294 75.9% Solid Waste Post Clos 402 150 76 492 328.0%335 36 232 69.2%103 9 73 71.2% Solid Waste Eqpt Res 403 1,500 1,062 6,885 459.0%302,768 296 1,901 0.6%779 68 553 70.9% Yard Waste Educ Fnd 404 7,740 4 22 0.3%1,781 4 28 1.6%12 1 8 68.6% Tri Area Sewer 405 201,000 600 4,952 2.5%172,740 279 1,963 1.1%206,433 99 170,702 82.7% Total ENTERPRISE 3,619,379 353,893 2,669,988 73.8%3,959,162 428,357 2,657,333 67.1%3,345,106 279,876 2,551,631 76.3% INTERNAL SERVICE Equipment Rental 501 2,411,194 284,807 1,887,162 78.3%2,179,575 409,479 1,544,129 70.8%2,146,936 200,793 1,366,213 63.6% 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 16,636 183,713 92.8%215,434 15,808 178,869 83.0%251,189 13,848 170,523 67.9% Information Services 506 1,696,833 17,457 1,267,664 74.7%1,551,832 1,517 1,120,032 72.2%1,639,415 3,851 1,160,018 70.8% Total INT SERV 4,456,027 318,900 3,413,650 76.6%4,004,508 426,804 2,858,065 71.4%4,114,411 218,492 2,772,568 67.4% Total 31,392,264 2,186,040 22,561,044 71.9%31,636,992 2,011,279 21,701,929 68.6%30,613,104 2,381,967 21,107,909 69.0% GENERAL FUND CASH BALANCE REPORT 10/4/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$ 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/4/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 9.3%272,120 - -$277,054 88.39%$2,579,866 -$338,856November239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 10.2%296,790 - -$573,844 78.61%$2,294,505 -$624,217December197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 8.1%235,535 - -$809,379 72.27%$2,109,343 -$809,379TTL2,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,109,343 100.0%$2,918,722 $2,109,343ytd 1,760,299 1,599,081 1,405,881 1,458,975 1,460,127 1,744,091 1,665,497 1,810,743 1,975,327 2,109,343 2,114,278 2,109,343 through December ytd change 81.90%-9.16%-12.08%3.78%0.08%19.45%-4.51%8.72%9.09%6.78%-0.23%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 9.38%85,095 - 357,215 - 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 659,790 100.0%907,549 659,790 3,826,271 2,769,133 ytd $450,087 $522,961 $507,307 $554,926 $638,413 $659,790 $657,558 $659,790 $2,771,835 $2,769,133 -0.1% 0.34%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 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$ 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$ 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 $951,966 961,744$ 1,048,750$ 951,966$ -9% YTD $519,454 $423,762 $334,992 $348,570 $365,001 $460,393 $495,771 $926,194 $942,154 $951,966 706,128$ 770,009$ 951,966$ 24% Y/Y chg -33.00%-18.42%-20.95%4.05%4.71%26.13%7.68%86.82%1.72%1.04% 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 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 10/4/2017 $0 $50,000 $100,000 $150,000 $200,000 $250,000 REET RECEIPTS 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 10/4/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 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 $209,425 $213,995 $184,054 $189,233 $184,766 $198,799 $211,429 $252,746 $305,095 $347,485 $242,017 280,924$ $347,485 23.7% Total $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $347,485 $366,570 425,500$ $347,485 $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