Loading...
HomeMy WebLinkAbout2018-01_RevenueReports2018 1 January General Fund Jefferson County Treasurer 7-Feb-2018 REVENUE NAME BARS BUDGET JAN Y-T-D Y-T-D ACTUAL JAN Y-T-D Y-T-D ACTUAL JAN Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % Property Tax 1 311.10 7,850,027 20,847 20,847 0.3%7,643,881 16,489 16,489 0.2%7,514,257 12,049 12,049 0.2% Diverted Road Prop Tax 1 311.20 720,000 1,871 1,871 0.3%720,000 1,804 1,804 0.3%720,000 1,318 1,318 0.2% Private Harvest Tax 2 317.40.10/.20 335,000 - 0 0.0%377,824 - 0 0.0%281,335 - 0 0.0% Sales Tax 1 313.11 3,040,000 207,899 207,899 6.8%2,876,339 185,505 185,505 6.4%2,738,244 185,292 185,292 6.8% special purpose 313.15 955,428 66,993 66,993 7.0%903,099 61,161 61,161 6.8%876,170 58,026 58,026 6.6% Local Criminal Justice 1 313.71 380,070 28,043 28,043 7.4%375,219 25,334 25,334 6.8%364,508 24,298 24,298 6.7% Leasehold Excise Tax 3 317.20 62,000 - 0 0.0%69,801 - 0 0.0%55,407 - 0 0.0% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 4,701 4,701 5.9%90,727 5,197 5,197 5.7%84,213 4,054 4,054 4.8% Penalties on delinquent taxes 1 359.40.10/.20 133,332 12,066 12,066 9.0%98,944 8,220 8,220 8.3%112,239 5,764 5,764 5.1% Interest on delinquent taxes 1 361.40.10 210,000 14,270 14,270 6.8%193,625 8,809 8,809 4.5%213,458 3,107 3,107 1.5% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 572,220 - 0 0.0%1,458,645 - 0 0.0%1,476,638 - 0 0.0% P.U.D. Privilege Tax 4 335.00.91 323,420 - 0 0.0%314,148 - 0 0.0%318,107 - 0 0.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 463,500 108,130 108,130 23.3%435,778 109,769 109,769 25.2%477,057 128,762 128,762 27.0% Marijuana Enforcement/Excise 6 336.06.41 24,720 - 0 0.0%21,297 - 0 0.0%36,920 - 0 0.0% Liquor Excise Tax 8 336.06.94 41,536 10,819 10,819 26.0%44,174 10,241 10,241 23.2%41,772 9,372 9,372 22.4% Liquor Profit 6 336.06.95 90,203 - 0 0.0%84,441 - 0 0.0%84,749 - 0 0.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 186,331 186,331 56.7%143,455 9,022 9,022 6.3%294,890 - 0 0.0% Investment Income 1 361.11 230,000 44,659 44,659 19.4%354,385 13,370 13,370 3.8%682,617 745 745 0.1% Treasurer Invest & Other Fees 1 341.42.15-19/50 16,290 2,252 2,252 13.8%33,805 5,700 5,700 16.9%11,599 496 496 4.3% DNR Timber 1 395.1.1 250,000 448 448 0.2%207,899 - 0 0.0%336,350 104,625 104,625 31.1% Transfer in 1 397.00 3,000 - 0 0.0%40,322 - 0 0.0%46,441 - 0 0.0% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 884 884 7.4%9,020 344 344 3.8%625 625 625 100.0% Assessor 1 001-010-000 8,700 37 37 0.4%10,970 171 171 1.6%8,761 155 155 1.8% Auditor-Recording Fees 1 341.21.10 72,063 5,740 5,740 8.0%74,248 6,254 6,254 8.4%74,077 5,389 5,389 7.3% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 11,451 11,451 4.9%242,031 10,842 10,842 4.5%229,927 10,597 10,597 4.6% Auditor-Other Revenue 1 26,605 2,781 2,781 10.5%29,714 2,982 2,982 10.0%32,440 2,241 2,241 6.9% Elections 1 001-021-000 146,191 34,408 34,408 23.5%138,996 - 0 0.0%160,903 32,115 32,115 20.0% Clerk 1 001-020-000 170,768 20,817 20,817 12.2%179,130 16,675 16,675 9.3%192,402 16,029 16,029 8.3% County Administrator 1 001-059-000 4,260 - 0 3,700 0 0 Commissioners 1 001-060-000 8,000 696 696 8.7%8,923 742 742 8.3%8,609 603 603 7.0% Safety & Security 1 001-067-000 64,959 12,345 12,345 19.0%66,877 - 0 0.0%70,305 1,450 1,450 2.1% Community Services 1 001-068-000 6,900 63 63 0.9%4,611 23 23 0.5%8,269 29 29 0.3% District Court 1 001-080-000 603,032 33,403 33,403 5.5%596,433 30,107 30,107 5.0%632,629 34,114 34,114 5.4% Juvenile Service 1 001-110-000 259,676 18,261 18,261 7.0%290,984 14,911 14,911 5.1%260,358 20,193 20,193 7.8% Prosecuting Attorney 1 001-150-000 178,690 7,087 7,087 4.0%151,185 7,241 7,241 4.8%124,918 6,792 6,792 5.4% Coroner 1 001-151-000 25,348 - 0 0.0%24,610 - 0 0.0%8,340 - 0 0.0% Sheriff 1 001-180-000 563,077 59,195 59,195 10.5%722,960 57,694 57,694 8.0%626,703 7,170 7,170 1.1% Superior Court 1 001-240-000 40,038 250 250 0.6%90,193 - 0 0.0%26,142 - 0 0.0% Non Departmental 1 001-270-000 50,447 32,802 32,802 65.0%49,196 10 10 0.0%10 10 10 TOTAL CURRENT EXPENSE 18,582,629 949,547 949,547 5.1%19,181,590 608,618 608,618 3.2%19,232,390 675,407 675,417 3.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 REFUND EXPEND CY/PRIOR exclude 388/89 1,146 1,146 253,160 0 194,294 642 642 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view 2/7/2018 January 1 FUND Fund #Budget Jan YTD YTD ACTUAL Jan YTD YTD ACTUAL Jan YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,152 2,152 2.9%77,983 2,228 2,228 2.9%74,342 1,853 1,853 2.5% Court Facilitator 106 5,100 520 520 10.2%5,920 380 380 6.4%6,220 400 400 6.4% Boating Safety 107 48,740 - - 0.0%49,100 218 218 0.4%61,493 8,787 8,787 14.3% WSU Cooperative 108 510,294 9,929 9,929 1.9%534,494 6,010 6,010 1.1%528,605 8,039 8,039 1.5% 4-H After School 113 37,250 - - 0.0%44,475 - - 0.0%10,600 - - 0.0% JeffComCap 119 119 204,000 22,058 22,058 10.8%254,838 21,221 21,221 8.3%276,062 22,899 22,899 8.3% Crime Victim's Svc 120 110,757 4,812 4,812 4.3%99,707 23,854 23,854 23.9%79,335 10,611 10,611 13.4% Grant Mgmt 123 150,000 13,376 13,376 8.9%76,723 - - 0.0%95,126 1,195 1,195 1.3% Hotel-Motel 125 500,500 23,177 23,177 4.6%507,868 19,394 19,394 3.8%449,148 18,473 18,473 4.1% Jeff Co Public Health 127 3,956,447 422,554 422,554 10.7%4,064,163 455,471 455,471 11.2%4,076,806 572,416 572,416 14.0% Water Quality 128 960,714 4,563 4,563 0.5%975,455 3,150 3,150 0.3%999,219 2,009 2,009 0.2% Mental Health 130 45,150 123 123 0.3%47,474 95 95 0.2%46,854 601 601 1.3% Chem Dep Mnt Hlth tx 131 490,490 38,554 38,554 7.9%516,131 34,923 34,923 6.8%500,457 33,439 33,439 6.7% Drug Fund 135 18,288 845 845 4.6%11,819 934 934 7.9%23,562 1,163 1,163 4.9% Law Library 140 10,150 640 640 6.3%10,049 666 666 6.6%9,692 616 616 6.4% Trial Court Imprvmnt 141 25,000 - - 0.0%23,449 - - 0.0%22,669 - - 0.0% Public Defense Fnd 142 35,000 - - 0.0%0 - - 0.0%36,673 - - 0.0% Community Develpmnt 143 1,663,379 56,746 56,746 3.4%1,418,569 74,361 74,361 5.2%1,668,687 77,714 77,714 4.7% Jeff Co Affrdbl Hsg 148 237,381 20,086 20,086 8.5%250,150 20,035 20,035 8.0%243,809 17,389 17,389 7.1% Treasurer's O & M 150 47,280 246 246 0.5%28,653 15 15 0.1%23,981 6 6 0.0% REET technology 151 14,420 1,287 1,287 8.9%16,827 1,267 1,267 7.5%16,194 1,290 1,290 8.0% Veteran's Relief 155 59,820 206 206 0.3%65,060 128 128 0.2%63,652 623 623 1.0% Water Pollution Cntrl 160 - - - - - - 18,607 100 100 0.5% Park & Rec 174 648,380 2,842 2,842 0.4%625,429 2,104 2,104 0.3%569,174 2,053 2,053 0.4% County Park Imprvmnt 175 131,185 - - 0.0%119,426 - - 0.0%84,284 36 36 0.0% County Roads 180 7,838,108 532,718 532,718 6.8%9,773,015 190,751 190,751 2.0%8,949,637 261,683 261,683 2.9% Facilities Mgmt 183 1,074,934 78,074 78,074 7.3%1,040,019 76,473 76,473 7.4%1,116,468 78,165 78,165 7.0% County Fair 199 250,000 3,540 3,540 1.4%308,594 6,581 6,581 2.1%269,769 4,625 4,625 1.7% Total Special Revenue 19,148,104 1,239,047 1,239,047 6.5%20,945,389 940,258 940,258 4.5%20,321,124 1,126,187 1,126,187 5.5% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Jan YTD YTD YTD Jan YTD YTD Budget Jan YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 1,808 1,808 0.2%517,754 1,755 1,755 0.3%1,113,333 10,567 10,567 0.9% Capital Improvement 302 1,072,938 49,830 49,830 4.6%1,285,270 78,597 78,597 6.1%1,537,774 57,144 57,144 3.7% Public Infrastructure 306 451,400 36,077 36,077 8.0%477,127 32,116 32,116 6.7%456,854 30,422 30,422 6.7% Conservation Futures 308 239,400 1,375 1,375 0.6%256,431 747 747 0.3%244,237 3,202 3,202 1.3% Total CAP IMP 2,763,738 89,090 89,090 3.2%2,536,581 113,214 113,214 4.5%3,352,198 101,334 101,334 3.0% ENTERPRISE Solid Waste 401 3,357,942 238,390 238,390 7.1%3,488,829 244,166 244,166 7.0%3,481,538 217,149 217,149 6.2% Solid Waste Post Clos 402 150 63 63 42.2%516 34 34 6.6%335 14 14 4.0% Solid Waste Eqpt Res 403 4,000 984 984 24.6%7,601 477 477 6.3%302,768 111 111 0.0% Yard Waste Educ Fnd 404 5,800 4 4 0.1%5,750 2 2 0.0%1,781 2 2 0.1% Tri Area Sewer 405 226,000 816 816 0.4%297,554 307 307 0.1%172,740 113 113 0.1% Total ENTERPRISE 3,593,892 240,257 240,257 6.7%3,800,250 244,986 244,986 6.4%3,959,162 217,388 217,388 5.5% INTERNAL SERVICE Equipment Rental 501 2,451,202 45,103 45,103 1.8%2,508,636 78,930 78,930 3.1%2,179,575 42,509 42,509 2.0% Risk Management 502 215,000 - 0 0.0%112,770 - - 0.0%57,666 - - 0.0% Benefit Reserve 505 208,000 22,013 22,013 10.6%225,590 21,954 21,954 9.7%215,434 21,571 21,571 10.0% Information Services 506 2,103,298 408,497 408,497 19.4%1,832,926 297,105 297,105 16.2%1,551,832 128,187 128,187 8.3% Total INT SERV 4,977,500 475,613 475,613 9.6%4,679,922 397,989 397,989 8.5%4,004,508 192,267 192,267 4.8% Total 30,483,234 2,044,007 2,044,007 6.7%31,962,142 1,696,447 1,696,447 5.3%31,636,992 1,637,176 1,637,176 5.2% GENERAL FUND CASH BALANCE REPORT 2/7/2018 END OF MONTH CASH BALANCES 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 January 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$ 4,416,485$ February 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,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,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 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 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 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 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,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 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 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,297,287$ 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2009 2010 2011 2012 2013 2014 2015 2016 2017 Budg ***2018 Budg *** Total Reserve $ 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 $ 2,653,611 10% GF Budgeted Expenditures $ 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 $ 1,927,611 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,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. $- $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 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 1 January GENERAL SALES TAX RECEIPTS 2/7/2018 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End 3 yr. avg Expected Actual Over/Under Cum %projection 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2015-17 2018 2018 Expected expected Projection Over/Under January 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 6.6%200,614 207,899 $7,285 103.63%$3,150,395 $110,395February219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 10.0%305,388 - March 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 6.8%205,802 - April 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 6.7%203,686 - May 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 8.4%256,612 - June 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 7.4%225,655 - July 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 7.7%235,089 - August 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 10.2%310,571 - September 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 8.8%268,857 - October 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 9.4%285,439 - November 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 10.0%305,512 - December 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 7.8%236,775 - TTL 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,876,339 207,899 100.0%$3,040,000 $207,899ytd 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 200,614 207,899 ytd change -12.48%2.93%-0.12%29.18%-0.46%-7.43%13.11%0.12%12.07%3.63%over (under) ytd expected annual % chg.-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 Actual 3 yr avg.Projection Actual20122013201420152016201720182015-17 2018 2018 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 6.69%63,886 66,993 264,500 274,892 3.9% February 61,899 70,678 67,508 73,364 83,521 93,242 9.8%93,779 - 399,167 - March 40,604 56,106 49,782 50,931 62,285 61,183 6.8%65,387 - 271,189 - April 43,155 51,054 47,573 52,541 59,481 59,911 6.7%64,462 - 268,148 - May 51,908 58,324 56,012 62,613 74,233 78,716 8.5%80,820 - 337,432 - June 46,797 50,067 48,647 58,717 65,832 65,229 7.4%71,153 - 296,808 - July 49,385 68,295 54,074 56,793 69,908 73,136 7.8%74,924 - 310,013 - August 56,220 56,063 68,712 76,734 87,275 89,679 10.0%95,114 - 405,686 - September 54,902 61,455 64,622 72,022 77,854 77,534 8.9%85,262 - 354,119 - October 61,120 64,400 64,152 73,903 82,028 82,991 9.4%89,578 - 375,017 - November 60,952 64,915 71,491 77,947 89,596 90,736 10.1%96,836 - 402,348 - December 49,281 52,177 59,043 62,263 66,133 69,582 7.8%74,227 - 311,003 - TOTAL 621,440 704,453 701,993 769,039 876,170 903,099 66,993 100.0%955,428 66,993 3,995,428 274,892 ytd 50,919 50,377 51,210 58,026 61,161 $66,993 63,886 $66,993 264,500 $274,892 3.9% 4.86%over (under) ytd expected TOTAL 2018 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 2018 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 January 1 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation TOTAL Recent 2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 4 YR AVG Budget Actual Difference January 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 53,263$ 49,358$ 49,830$ 1.0% February 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 43,542$ 40,350$ -$ March 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 95,117$ 88,144$ -$ April 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 68,249$ 63,245$ -$ May 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 88,832$ 82,320$ -$ June 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 144,702$ 134,093$ -$ July 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 97,339$ 90,203$ -$ August 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 95,860$ 88,833$ -$ September 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 142,117$ 131,698$ -$ October 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 104,607$ 96,938$ -$ November 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 75,648$ 70,102$ -$ December 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 96,815$ 89,717$ -$ Total $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $49,830 1,106,090$ 1,025,000$ 49,830$ -95% YTD 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ $49,830 53,263$ 49,357.72$ 49,830.45$ 1% Y/Y chg -76.76%98.67%-49.96%-1.32%57.28%-24.82%72.24%37.54%-36.60% Jan 2017 1@1.565M, 6 Res>$500k Sept 2017 12>$500k Feb 2017 5 Res>$500k Oct 2017 2 sales @$1.31M and $1.445M, 6 res>$500k Mar 2017 6 Res>$500k Nov 2017 12 sales>$500k Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k Dec 2017 1 sale @ $1.529M, 11>$500k May 2017 1@$1.098, 1@$1.035, 6 Res>$500k Jan 2018 no unincorp sales>$445k Jun 2017 1@$1.05, 16>$500k July 2017 6>$500k Aug 2017 1@$1.024, 1@1.37 and 11>$500k 2/7/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 1 January 2/7/2018 REVENUE 4 yr avg *2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2013-16 Budget Actual Difference January 16,089$ 10,732$ 11,507$ 12,045$ 8,863$ 13,575$ 17,051$ 18,473$ 19,394$ 23,177$ 17,123$ 20,418$ 23,177$ 13.5% February 27,998$ 21,729$ 25,532$ 23,188$ 38,274$ 30,356$ 36,141$ 51,077$ 53,093$ 42,667$ 50,876$ March 22,623$ 9,838$ 12,406$ 7,271$ 11,203$ 12,715$ 14,345$ 14,554$ 16,889$ 14,626$ 17,440$ April 11,344$ 11,934$ 10,791$ 14,950$ 11,430$ 12,427$ 14,983$ 18,530$ 20,901$ 16,710$ 19,926$ May 19,646$ 19,561$ 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 29,611$ 35,308$ June 19,205$ 19,650$ 17,302$ 17,916$ 16,477$ 18,786$ 25,070$ 29,476$ 31,485$ 26,204$ 31,247$ July 20,155$ 14,326$ 19,311$ 20,201$ 21,512$ 24,536$ 27,711$ 33,687$ 38,400$ 31,083$ 37,064$ August 35,178$ 36,076$ 24,742$ 31,171$ 33,140$ 37,534$ 48,845$ 56,349$ 64,820$ 51,887$ 61,871$ September 41,757$ 40,208$ 42,500$ 40,882$ 39,890$ 42,349$ 44,713$ 53,487$ 56,561$ 49,278$ 58,759$ October 43,012$ 46,548$ 43,861$ 41,015$ 41,741$ 43,659$ 49,182$ 59,970$ 58,458$ 52,817$ 62,980$ November 44,351$ 43,285$ 38,547$ 36,906$ 39,146$ 46,879$ 58,967$ 57,999$ 69,054$ 58,225$ 69,428$ December 19,873$ 18,741$ 21,703$ 11,109$ 15,514$ 33,858$ 25,213$ 26,084$ 32,870$ 29,506$ 35,184$ Total 321,231$ 292,628$ 293,344$ 273,796$ 295,200$ 335,825$ 386,107$ 449,148$ 507,868$ 25,195$ 419,737$ 500,500$ 23,177$ YTD 16,089$ 10,732$ 11,507$ 12,045$ 8,863$ 13,575$ 17,051$ 18,473$ 19,394$ 23,177$ 17,123$ 20,418$ 23,177$ 13.5% $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 2018 HOTEL/MOTEL LODGING TAX -Fund 125 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018