Loading...
HomeMy WebLinkAbout2017-11_RevenueRpts2017 BARS General Fund 11-Dec-17 y Treasurer REVENUE NAME BUDGET NOV Y-T-D Y-T-D ACTUAL NOV Y-T-D Y-T-D ACTUAL NOV Y-T-D Y-T-D *2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % Property Tax 1 311.10 7,696,105 574,713 7,598,080 98.7%7,514,257 651,392 7,470,260 99.4%7,388,068 674,072 7,340,255 99.4% Diverted Road Prop Tax 1 311.20 720,000 60,623 716,216 99.5%720,000 68,091 716,840 99.6%720,000 68,783 724,725 100.7% Private Harvest Tax 2 317.40.10/.20 335,000 66,821 377,824 112.8%281,335 29,003 281,335 100.0%460,885 94,519 460,885 100.0% Sales Tax 1 313.11 2,918,722 279,959 2,656,567 91.0%2,738,244 293,377 2,522,707 92.1%2,486,611 240,812 2,290,946 92.1% special purpose 313.15 907,549 90,736 833,517 91.8%876,170 89,596 810,037 92.5%769,039 77,947 706,776 91.9% Local Criminal Justice 1 313.71 366,157 37,400 346,128 94.5%364,508 37,398 336,684 92.4%318,901 32,328 292,940 91.9% Leasehold Excise Tax 3 317.20 62,000 - 53,782 86.7%55,407 - 46,960 84.8%59,267 - 47,584 80.3% Treas. Collection Fees (REET)3 341.42.31/32/33 70,000 8,413 83,831 119.8%84,213 5,679 78,120 92.8%74,197 4,768 67,438 90.9% Penalties on delinquent taxes 1 359.40.10/.20 132,300 6,183 80,634 60.9%112,239 7,196 93,540 83.3%109,143 4,594 89,851 82.3% Interest on delinquent taxes 1 361.40.10 204,300 22,455 172,405 84.4%213,458 22,742 190,119 89.1%200,845 16,184 181,910 90.6% 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,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 - 435,778 91.4%477,057 - 477,104 100.0%488,746 - 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 - 44,174 108.5%41,772 - 41,772 100.0%21,930 - 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 - 27,067 8.8%294,890 - 35,383 12.0%293,327 - 35,006 11.9% Investment Income 1 361.11 218,484 28,968 390,038 178.5%682,617 14,041 665,615 97.5%465,346 119,610 174,868 37.6% Treasurer Invest & Other Fees 1 341.42.15-19/50 16,290 5,461 35,698 219.1%11,599 1,121 10,456 90.1%4,080 388 3,722 91.2% DNR Timber 1 395.1.1 250,000 39,951 207,451 83.0%336,350 13,240 328,785 97.8%473,880 14,619 473,880 100.0% Transfer in 1 397.00 3,000 750 38,837 1294.6%46,441 750 46,441 100.0%10,373 - 5,000 48.2% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 855 6,864 57.7%46,095 605 17,552 38.1%299,479 2,626 288,169 96.2% Assessor 1 001-010-000 8,700 1,926 10,603 121.9%8,761 1,984 8,327 95.1%1,125 86 840 74.7% Auditor-Recording Fees 1 341.21.10 70,000 6,252 67,930 97.0%74,077 6,839 67,692 91.4%72,112 4,888 65,589 91.0% Auditor-M.V. License Fees 1 341.48/336.00.93 222,601 9,799 232,685 104.5%229,927 10,754 222,810 96.9%157,587 9,434 146,998 93.3% Auditor-Other Revenue 1 25,252 2,226 27,358 108.3%32,440 4,470 30,526 94.1%84,605 1,551 76,445 90.4% Elections 1 001-021-000 110,711 - 114,205 103.2%160,903 - 153,467 95.4%101,929 - 69,248 67.9% Clerk 1 001-020-000 199,087 21,620 166,390 83.6%192,402 15,442 178,051 92.5%211,930 17,083 186,738 88.1% Commissioners 1 001-060-000 8,000 693 8,073 100.9%8,609 748 7,877 91.5%8,663 621 7,917 91.4% Safety & Security 1 001-067-000 64,959 - 66,877 103.0%70,305 1,199 59,367 84.4%71,593 13,120 71,593 100.0% Community Services 1 001-068-000 9,900 23 3,954 39.9%8,269 52 8,241 99.7%4,488 1,029 4,436 98.8% District Court 1 001-080-000 660,257 35,845 534,007 80.9%632,629 73,618 602,934 95.3%667,142 78,120 618,320 92.7% Juvenile Service 1 001-110-000 253,516 72,343 268,414 105.9%260,358 45,502 253,990 97.6%248,694 13,118 222,966 89.7% Prosecuting Attorney 1 001-150-000 195,552 11,277 144,135 73.7%124,918 10,986 118,007 94.5%224,953 14,927 202,052 89.8% 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 68,305 520,916 91.9%626,703 103,797 591,799 94.4%530,346 71,230 521,378 98.3% Superior Court 1 001-240-000 19,500 21,080 90,193 462.5%26,142 5,411 26,142 100.0%19,952 - 4,686 23.5% Non Departmental 1 001-270-000 49,416 10 0.0%10 TOTAL CURRENT EXPENSE 18,255,679 1,474,677 18,169,870 99.5%19,277,851 1,515,033 18,342,537 95.1%18,950,211 1,576,458 17,712,689 93.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 4,205.85 231,455.67 7.50 17,338 173,517.00 10,426 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2017 3 year view 12/11/2017 FUND Fund #Budget Nov YTD YTD ACTUAL Nov YTD YTD ACTUAL Nov YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % SPECIAL REVENUE Auditor's O & M 105 77,169 2,158 75,737 98.1%74,342 2,269 72,127 97.0%71,081 1,887 68,780 96.8% Court Facilitator 106 6,000 580 5,560 92.7%6,220 660 5,620 90.4%5,989 260 5,448 91.0% Boating Safety 107 54,632 - 49,100 89.9%61,493 5 61,493 100.0%44,988 - 34,856 77.5% WSU Cooperative 108 590,016 20,924 425,905 72.2%528,605 108,297 522,685 98.9%326,722 71,310 326,522 99.9% 4-H After School 113 20,950 2,743 44,475 212.3%10,600 - 10,600 100.0%46,129 8,952 46,129 100.0% JeffComCap 119 119 254,650 21,221 233,618 91.7%276,062 22,899 253,163 91.7%286,656 24,551 262,104 91.4% Crime Victim's Svc 120 50,418 22,380 98,836 196.0%79,335 1,263 78,184 98.5%62,364 1,332 59,639 95.6% Grant Mgmt 123 150,000 - 58,345 38.9%95,126 - 61,954 65.1%69,440 15,401 53,971 77.7% Hotel-Motel 125 425,500 69,054 474,998 111.6%449,148 57,999 423,064 94.2%386,107 58,967 360,895 93.5% H&HS Site Abatement 126 - - - - - - 14,139 - - 0.0% Jeff Co Public Health 127 3,964,210 363,368 3,788,916 95.6%4,076,806 450,701 3,874,995 95.0%3,898,751 379,741 3,676,081 94.3% Water Quality 128 1,029,803 51,022 857,366 83.3%999,219 90,039 884,586 88.5%880,574 91,122 827,435 94.0% Mental Health 130 47,650 3,850 47,119 98.9%46,854 3,965 46,518 99.3%47,746 4,434 47,405 99.3% Chem Dep Mnt Hlth tx 131 490,490 51,397 476,153 97.1%500,457 50,849 462,213 92.4%442,353 47,904 406,649 91.9% Drug Fund 135 23,438 947 10,921 46.6%23,562 1,095 22,617 96.0%18,657 3,346 16,618 89.1% Law Library 140 10,150 703 9,102 89.7%9,692 879 8,967 92.5%10,334 712 9,435 91.3% Trial Court Imprvmnt 141 25,000 5,859 17,585 70.3%22,669 - 22,669 100.0%22,905 - 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 163,151 1,348,568 84.6%1,668,687 200,826 1,562,596 93.6%1,555,523 149,460 1,333,405 85.7% Jeff Co Affrdbl Hsg 148 198,431 20,292 229,140 115.5%243,809 21,286 223,646 91.7%240,673 17,501 218,455 90.8% Treasurer's O & M 150 47,140 28 19,402 41.2%23,981 771 17,873 74.5%26,138 4 17,251 66.0% REET technology 151 14,420 1,443 15,455 107.2%16,194 1,307 14,832 91.6%15,156 1,266 14,017 92.5% Veteran's Relief 155 59,330 3,961 64,632 108.9%63,652 4,041 63,285 99.4%63,899 4,500 63,543 99.4% Water Pollution Cntrl 160 - - - 18,607 - 18,607 100.0%12,058 100 11,958 99.2% Park & Rec 174 586,640 129,328 585,245 99.8%569,174 135,830 557,839 98.0%594,033 135,331 591,838 99.6% County Park Imprvmnt 175 117,886 60 86,926 73.7%84,284 456 84,284 100.0%60,301 292 60,109 99.7% County Roads 180 10,012,963 658,533 9,143,969 91.3%8,949,637 1,533,395 8,356,559 93.4%9,720,929 1,003,098 8,898,838 91.5% Facilities Mgmt 183 1,037,953 68,407 935,163 90.1%1,116,468 86,931 1,029,537 92.2%958,738 129,988 914,542 95.4% County Fair 199 250,000 9,896 304,154 121.7%269,769 14,408 264,195 97.9%271,091 4,332 265,371 97.9% Total Special Revenue 21,173,949 1,661,408 19,406,386 91.7%20,321,124 2,775,763 19,004,707 93.5%20,195,549 2,151,460 18,614,202 92.2% OTHER FUNDS REVENUE REPORT 2017 3 year view FUND Budget Nov YTD YTD Budget Nov YTD YTD Budget Nov YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % CAPITAL IMPROVEMENT Const/Renovation 301 500,000 - 515,341 103.1%1,113,333 275,000 1,113,333 100.0%234,915 - 234,915 100.0% Capital Improvement 302 1,048,750 119,897 1,185,236 113.0%1,537,774 375,151 1,454,497 94.6%2,076,934 746,034 1,774,495 85.4% Public Infrastructure 306 411,400 47,585 443,385 107.8%456,854 46,826 421,665 92.3%399,328 40,445 366,866 91.9% Conservation Futures 308 239,645 21,061 254,000 106.0%244,237 20,732 242,277 99.2%246,862 22,981 245,036 99.3% Total CAP IMP 2,199,795 188,543 2,397,962 109.0%3,352,198 717,708 3,231,772 96.4%2,958,038 809,460 2,621,312 88.6% ENTERPRISE Solid Waste 401 3,408,989 257,016 3,199,043 93.8%3,481,538 284,606 3,219,736 92.5%3,137,778 388,767 2,904,723 92.6% Solid Waste Post Clos 402 150 55 701 467.3%335 35 304 90.8%103 11 94 91.4% Solid Waste Eqpt Res 403 1,500 771 9,818 654.5%302,768 300,288 302,495 99.9%779 82 709 91.0% Yard Waste Educ Fnd 404 7,740 1 25 0.3%1,781 1,748 1,780 99.9%12 1 11 90.2% Tri Area Sewer 405 201,000 205,613 211,155 105.1%172,740 170,272 172,523 99.9%206,433 129 170,950 82.8% Total ENTERPRISE 3,619,379 463,457 3,420,742 94.5%3,959,162 756,949 3,696,838 93.4%3,345,106 388,990 3,076,487 92.0% INTERNAL SERVICE Equipment Rental 501 2,411,194 170,738 2,229,555 92.5%2,179,575 167,714 1,900,217 87.2%2,146,936 174,623 1,877,786 87.5% 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 12,720 211,212 106.7%215,434 11,881 204,134 94.8%251,189 11,405 194,615 77.5% Information Services 506 1,696,833 5,368 1,711,246 100.8%1,551,832 6,797 1,511,152 97.4%1,639,415 205,236 1,536,621 93.7% Total INT SERV 4,456,027 188,826 4,227,124 94.9%4,004,508 186,392 3,630,536 90.7%4,114,411 391,264 3,684,835 89.6% Total 31,449,150 2,502,235 29,452,213 93.7%31,636,992 4,436,812 29,563,854 93.4%30,613,104 3,741,175 27,996,836 91.5% GENERAL FUND CASH BALANCE REPORT 12/11/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$ 6,098,807$ 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 12/11/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 279,959 10.2%296,790 279,959 -$26,621 99.01%$2,889,765 -$28,957December197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 8.1%235,535 - -$262,155 91.02%$2,656,567 -$262,155TTL2,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,656,567 100.0%$2,918,722 $2,656,567ytd 2,212,564 1,981,413 1,767,796 1,822,230 1,870,560 2,179,506 2,104,824 2,290,946 2,522,707 2,656,567 2,683,187 2,656,567 through December ytd change 128.63%-10.45%-10.78%3.08%2.65%16.52%-3.43%8.84%10.12%5.31%-0.99%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 90,736 10.18%92,423 90,736 389,213 370,695 -4.8%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 833,517 100.0%907,549 833,517 3,826,271 3,490,084 ytd $572,159 $652,276 $642,950 $706,776 $810,037 $833,517 $835,076 $833,517 $3,518,263 $3,490,084 -0.8% -0.19%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$ 119,897$ 77,577$ 84,596$ 119,897$ 42% 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,185,236 961,744$ 1,048,750$ 1,185,236$ 13% YTD $566,016 $455,568 $366,374 $382,801 $431,935 $518,201 $561,365 $1,028,461 $1,079,347 $1,185,236 874,421$ 953,527$ 1,185,236$ 24% Y/Y chg -33.00%-19.51%-19.58%4.48%12.84%19.97%8.33%83.21%4.95%9.81% 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 Nov 2017 12 sales>$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 12/11/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 $69,054 50,748$ 58,906$ $69,054 17.2%December $21,753 19,873$ 18,741$ 21,703$ 11,109$ $15,514 $33,858 $25,213 $26,084 25,167$ 29,213$ YTD $296,691 $301,358 $273,887 $271,641 $262,687 $279,686 $301,967 $360,895 $423,064 $474,998 $341,403 396,287$ $474,998 19.9% Total $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $474,998 $366,570 425,500$ $474,998 $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 HOTEL/MOTEL LODGING TAX -Fund 125 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017