Loading...
HomeMy WebLinkAbout2018-08_BC_RevenueReports2018 8 August General Fund 12-Sep-2018 Jefferson County TreasurerREVENUE NAME BARS BUDGET AUG Y-T-D Y-T-D ACTUAL AUG Y-T-D Y-T-D ACTUAL AUG Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % Property Tax 1 311.10 7,850,027 49,880 4,509,061 57.4%7,643,881 50,727 4,423,830 57.9%7,514,257 48,525 4,350,081 57.9% Diverted Road Prop Tax 1 311.20 720,000 4,568 417,288 58.0%720,000 4,723 420,267 58.4%720,000 4,708 420,216 58.4%Sales Tax 1 313.11 3,040,000 309,575 1,988,733 65.4%2,876,339 293,953 1,868,018 64.9%2,738,244 276,309 1,727,952 63.1% special purpose 313.15 955,428 97,261 625,985 65.5%903,099 89,679 582,256 64.5%876,170 87,275 560,560 64.0% Local Criminal Justice 1 313.71 380,070 40,342 261,338 68.8%375,219 37,671 241,615 64.4%364,508 36,162 232,864 63.9%Leasehold Excise Tax 3 317.20 62,000 17,077 48,627 78.4%69,801 16,199 50,748 72.7%55,407 14,937 44,666 80.6% Private Harvest Tax - TAV 2 317.40.10/.20 335,000 69,678 379,277 113.2%377,824 139,212 311,003 82.3%281,335 68,938 252,332 89.7% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 572,220 - 1,833,818 320.5%1,458,645 - 1,390,772 95.3%1,476,638 - 1,422,312 96.3% P.U.D. Privilege Tax 4 335.00.91 323,420 - 393,491 121.7%314,148 - 314,148 100.0%318,107 - 318,107 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 463,500 - 320,837 69.2%435,778 - 327,664 75.2%477,057 - 367,324 77.0%Marijuana Enforcement/Excise 6 336.06.41-42 24,720 - 39,588 160.1%21,297 - 11,354 53.3%36,920 - 25,568 69.3% Liquor Excise Tax 8 336.06.94 41,536 - 34,380 82.8%44,174 - 32,161 72.8%41,772 - 30,739 73.6% Liquor Profit 6 336.06.95 90,203 - 42,130 46.7%84,441 - 42,310 50.1%84,749 - 42,439 50.1%Treasurer Invest & Other Fees 1 341.42.15-20/50 16,290 3,859 33,256 204.2%33,805 1,888 24,461 72.4%11,599 1,315 6,858 59.1% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 8,606 55,584 69.5%90,727 7,485 58,015 63.9%84,213 7,812 57,423 68.2% Penalties on delinquent taxes 1 359.40.10/.20 133,332 4,482 72,844 54.6%98,944 3,986 65,994 66.7%112,239 6,336 78,457 69.9%Investment Income 1 361.11 230,000 38,157 331,255 144.0%354,385 20,875 270,868 76.4%682,617 544,654 611,048 89.5% Interest on delinquent taxes 1 361.40.10 210,000 6,535 136,785 65.1%193,625 6,313 132,572 68.5%213,458 11,755 152,594 71.5% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 - 206,731 62.9%143,455 - 30,577 21.3%294,890 - 26,537 9.0%DNR Timber 1 395.1.1 250,000 36,517 44,717 17.9%207,899 89,291 94,176 45.3%336,350 33,414 257,543 76.6% Transfer in 1 397.00 3,000 750 19,944 664.8%40,322 750 20,296 50.3%46,441 750 22,437 48.3% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 6,528 11,969 100.6%9,020 1,024 5,024 55.7%15,993 292 15,993 100.0% Assessor 1 001-010-000 8,700 1,810 5,840 67.1%10,970 1,840 8,129 74.1%8,761 1,791 6,135 70.0% Auditor-Recording Fees 1 341.21.10 72,063 6,424 47,848 66.4%74,248 5,504 48,264 65.0%74,077 6,616 48,209 65.1%Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 52,102 188,578 81.0%242,031 18,765 160,401 66.3%229,927 52,062 185,420 80.6% Auditor-Other Revenue 1 26,605 3,417 23,743 89.2%29,714 2,658 20,348 68.5%32,440 2,420 20,417 62.9% Elections 1 001-021-000 146,191 - 93,388 63.9%138,996 - 55,987 40.3%160,903 - 151,935 94.4%Clerk 1 001-020-000 170,768 16,167 120,160 70.4%179,130 22,385 120,444 67.2%192,402 19,675 131,291 68.2% County Administrator 1 001-059-000 4,260 - 4,260 3,700 0 0 Commissioners 1 001-060-000 8,000 805 5,902 73.8%8,923 686 5,772 64.7%8,609 829 5,670 65.9%Safety & Security 1 001-067-000 64,959 11,132 41,545 64.0%66,877 7,565 47,355 70.8%70,305 25,034 52,836 75.2% Community Services 1 001-068-000 6,900 1,821 3,228 46.8%4,611 1,780 3,857 83.6%8,269 34 2,857 34.5% District Court 1 001-080-000 603,032 94,284 491,420 81.5%596,433 82,960 432,362 72.5%632,629 86,833 450,185 71.2% Juvenile Service 1 001-110-000 259,676 27,865 183,834 70.8%290,984 21,724 183,907 63.2%260,358 18,370 169,014 64.9% Prosecuting Attorney 1 001-150-000 178,690 11,247 88,534 49.5%151,185 18,451 118,699 78.5%124,918 10,851 93,198 74.6%Coroner 1 001-151-000 25,348 14,583 32,723 129.1%24,610 - 24,610 100.0%8,340 - 8,340 100.0% Sheriff 1 001-180-000 563,077 83,481 386,593 68.7%722,960 85,183 436,531 60.4%626,703 73,579 417,361 66.6% Superior Court 1 001-240-000 *60,822 11,721 37,764 62.1%90,193 21,080 67,739 75.1%26,142 5,411 20,732 79.3% Non Departmental 1 001-270-000 50,447 - 32,802 65.0%49,196 10 0.0%10 10 TOTAL CURRENT EXPENSE REVENUE 18,603,413 1,030,674 13,595,799 73.1%19,181,590 1,054,356 12,452,543 64.9%19,247,758 1,446,688 12,787,660 66.4% * 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 (127,834)(112,461)253,160 14,150 28,115 194,294 536 11,758 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view August 8 9/12/2018 FUND Fund #Budget Aug YTD YTD ACTUAL Aug YTD YTD ACTUAL Aug YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 2,810 67,388 89.4%77,983 2,112 68,571 87.9%74,342 2,514 65,415 88.0% Court Facilitator 106 5,100 420 3,360 65.9%5,920 280 3,920 66.2%6,220 460 4,000 64.3% Boating Safety 107 48,740 16,844 47,451 97.4%49,100 - 41,877 85.3%61,493 12,833 52,033 84.6% WSU Cooperative 108 *552,594 36,842 369,892 66.9%534,494 49,398 305,106 57.1%528,605 84,309 374,485 70.8% 4-H After School 113 *45,250 - 37,750 83.4%44,475 - 22,733 51.1%10,600 - 10,600 100.0% JeffComCap 119 119 204,000 22,058 176,463 86.5%254,838 21,221 169,955 66.7%276,062 22,899 183,193 66.4% Crime Victim's Svc 120 110,757 2,109 61,365 55.4%99,707 1,077 74,175 74.4%79,335 1,803 51,602 65.0% Grant Mgmt 123 150,000 10,740 78,723 52.5%76,723 5,701 58,345 76.0%95,126 - 61,954 65.1% Hotel-Motel 125 500,500 64,934 299,567 59.9%507,868 64,820 290,924 57.3%449,148 56,349 251,608 56.0% Jeff Co Public Health 127 *4,372,775 490,506 3,294,691 75.3%4,064,163 373,680 2,865,016 70.5%4,076,806 461,594 3,025,605 74.2% Water Quality 128 960,714 88,030 680,908 70.9%975,455 137,660 667,819 68.5%999,219 64,803 594,991 59.5% Mental Health 130 45,150 1,191 28,736 63.6%47,474 1,550 27,921 58.8%46,854 886 28,032 59.8% Chem Dep Mnt Hlth tx 131 490,490 55,342 359,072 73.2%516,131 51,770 332,566 64.4%500,457 49,704 320,068 64.0% Drug Fund 135 18,288 1,581 9,571 52.3%11,819 989 8,058 68.2%23,562 1,065 18,942 80.4% Law Library 140 10,150 866 6,661 65.6%10,049 945 6,616 65.8%9,692 927 6,445 66.5% Trial Court Imprvmnt 141 25,000 - 17,403 69.6%23,449 - 11,726 50.0%22,669 5,667 16,903 74.6% Public Defense Fnd 142 35,000 - - 0.0%0 - - 0.0%36,673 - - 0.0% Community Develpmnt 143 *1,717,406 227,811 1,002,890 58.4%1,418,569 212,606 1,047,007 73.8%1,668,687 205,129 1,196,741 71.7% Federal Forest Title III 147 - 129 19,497 - 66 385 - 30 21,826 Jeff Co Affrdbl Hsg 148 *318,881 34,764 194,643 61.0%250,150 19,854 161,614 64.6%243,809 23,305 161,266 66.1% Treasurer's O & M 150 47,280 2,648 25,022 52.9%28,653 1,542 18,769 65.5%23,981 2,173 15,454 64.4% REET technology 151 14,420 1,574 10,938 75.9%16,827 1,468 10,805 64.2%16,194 1,503 10,607 65.5% Veteran's Relief 155 59,820 3,034 48,399 80.9%65,060 1,637 44,999 69.2%63,652 926 44,483 69.9% Water Pollution Cntrl 160 - - - - - - 18,607 - 17,665 94.9% Park & Rec 174 648,380 142,726 467,192 72.1%625,429 122,206 424,280 67.8%569,174 117,259 393,869 69.2% County Park Imprvmnt 175 131,185 16,892 129,244 98.5%119,426 12,126 78,540 65.8%84,284 10,181 79,749 94.6% County Roads 180 7,838,108 998,414 5,559,568 70.9%9,773,015 757,936 5,510,006 56.4%8,949,637 509,037 4,918,585 55.0% Facilities Mgmt 183 1,074,934 97,825 760,103 70.7%1,040,019 81,430 688,292 66.2%1,116,468 86,931 768,593 68.8% County Fair 199 250,000 66,972 194,632 77.9%308,594 75,173 257,583 83.5%269,769 83,421 206,805 76.7% Total Special Revenue 19,750,259 2,320,088 13,951,128 70.6%20,945,389 1,922,071 13,197,610 63.0%20,321,124 1,722,287 12,901,518 63.5% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Aug YTD YTD YTD Aug YTD YTD Budget Aug YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 - 16,117 1.6%517,754 - 511,831 98.9%1,113,333 275,000 836,612 75.1% Capital Improvement 302 1,072,938 131,097 808,495 75.4%1,285,270 110,037 770,631 60.0%1,537,774 125,719 846,272 55.0% Public Infrastructure 306 451,400 51,745 335,847 74.4%477,127 48,329 308,237 64.6%456,854 45,422 292,308 64.0% Conservation Futures 308 239,400 14,374 166,078 69.4%256,431 8,703 150,504 58.7%244,237 4,797 145,953 59.8% Total CAP IMP 2,763,738 197,216 1,326,536 48.0%2,536,581 167,070 1,741,202 68.6%3,352,198 450,939 2,121,145 63.3% ENTERPRISE Solid Waste 401 3,357,942 385,616 2,404,280 71.6%3,488,829 302,154 2,305,486 66.1%3,481,538 262,866 2,225,468 63.9% Solid Waste Post Clos 402 150 90 607 404.7%516 73 416 80.8%335 36 196 58.4% Solid Waste Eqpt Res 403 4,000 1,424 9,509 237.7%7,601 1,025 5,822 76.6%302,768 297 1,605 0.5% Yard Waste Educ Fnd 404 5,800 11 69 1.2%5,750 2 19 0.3%1,781 4 25 1.4% Tri Area Sewer 405 226,000 1,150 8,106 3.6%297,554 563 4,352 1.5%172,740 273 1,684 1.0% Total ENTERPRISE 3,593,892 388,291 2,422,571 67.4%3,800,250 303,817 2,316,095 60.9%3,959,162 263,475 2,228,976 56.3% INTERNAL SERVICE Equipment Rental 501 2,451,202 237,920 1,383,641 56.4%2,508,636 394,627 1,602,354 63.9%2,179,575 160,462 1,134,650 52.1% Risk Management 502 215,000 26,672 26,672 12.4%112,770 75,111 75,111 66.6%57,666 14,856 15,034 26.1% Benefit Reserve 505 208,000 19,044 180,189 86.6%225,590 16,853 167,077 74.1%215,434 16,252 163,061 75.7% Information Services 506 2,103,298 7,656 1,410,230 67.0%1,832,926 3,097 1,250,207 68.2%1,551,832 41,969 1,118,515 72.1% Total INT SERV 4,977,500 291,291 3,000,733 60.3%4,679,922 489,688 3,094,750 66.1%4,004,508 233,538 2,431,260 60.7% Total 31,085,389 3,196,886 20,700,968 66.6%31,962,142 2,882,645 20,349,658 63.7%31,636,992 2,670,239 19,682,899 62.2% GENERAL FUND CASH BALANCE REPORT 9/11/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$ 3,681,133$ 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$ 3,580,887$ 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$ 5,572,170$ 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$ 5,330,488$ 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$ 6,795,577$ 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$ 6,177,104$ 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$ 5,237,488$ 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 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,654,557 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,928,557 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 $7,000,000 GENERAL FUND END OF MONTH CASH BALANCE 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 8 August 9/12/2018 GENERAL SALES TAX RECEIPTS Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End3 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/UnderJanuary152,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 279,301 10.0%305,388 279,301 -$26,087 96.28%$2,927,043 -$112,957March177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 6.8%205,802 206,999 $1,197 97.53%$2,964,815 -$75,185April148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 6.7%203,686 202,532 -$1,154 97.95%$2,977,712 -$62,288May181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 8.4%256,612 271,431 $14,819 99.66%$3,029,784 -$10,216June 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 7.4%225,655 248,506 $22,850 100.97%$3,069,524 $29,524July159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 7.7%235,089 262,489 $27,400 102.84%$3,126,223 $86,223August199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 10.2%310,571 309,575 -$996 102.33%$3,110,885 $70,885September187,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 1,988,733 100.0%$3,040,000 $1,988,733ytd 1,411,867 1,232,148 1,289,596 1,217,815 1,545,212 1,453,479 1,582,977 1,727,952 1,868,018 1,988,733 1,943,417 1,988,733 ytd change -12.73%4.66%-5.57%26.88%-5.94%8.91%9.16%8.11%6.46%2.33%over (under) ytd expectedannual % chg.-10.25%2.64%3.98%14.73%-2.03%8.07%10.12% Special Purp./Public Safety TaxActualActualActual 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 90,853 9.8%93,779 90,853 399,167 370,154 -7.3%March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 6.8%65,387 66,479 271,189 273,478 0.8%April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 6.7%64,462 63,784 268,148 266,316 -0.7%May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 8.5%80,820 84,357 337,432 355,788 5.4%June 46,797 50,067 48,647 58,717 65,832 65,229 75,141 7.4%71,153 75,141 296,808 323,647 9.0%July 49,385 68,295 54,074 56,793 69,908 73,136 81,117 7.8%74,924 81,117 310,013 343,606 10.8%August 56,220 56,063 68,712 76,734 87,275 89,679 97,261 10.0%95,114 97,261 405,686 406,836 0.3%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 625,985 100.0%955,428 625,985 3,995,428 2,614,718 ytd 461,506 442,685 482,904 560,560 582,256 $625,985 609,525 $625,985 2,552,942 $2,614,718 2.4% 2.70%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 August 8 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$ 65,067$ 43,542$ 40,350$ 65,067$ 61.3% March 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 95,117$ 88,144$ 75,558$ -14.3% April 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 68,249$ 63,245$ 102,480$ 62.0% May 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 88,832$ 82,320$ 128,185$ 55.7% June 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 144,702$ 134,093$ 147,514$ 10.0% July 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 97,339$ 90,203$ 108,763$ 20.6% August 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 95,860$ 88,833$ 131,097$ 47.6% 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 $808,495 1,106,090$ 1,025,000$ 808,495$ -21% YTD 376,242$ 288,548$ 310,929$ 310,375$ 393,343$ 424,219$ 706,497$ 846,272$ 770,631$ $808,495 686,904$ 636,546$ 808,495$ 27% Y/Y chg -23.31%7.76%-0.18%26.73%7.85%66.54%19.78%-8.94%4.91% Jan 2017 1@1.565M, 6 Res>$500k Sept 2017 12>$500k May 2018 2@1.044 and 1.165M, 13 >$500k Feb 2017 5 Res>$500k Oct 2017 2 sales @$1.31M and $1.445M, 6 res>$500k Jun 2018 1 sale@$3M, 16>$500k Mar 2017 6 Res>$500k Nov 2017 12 sales>$500k Jul 2018 10>$500k Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k Dec 2017 1 sale @ $1.529M, 11>$500k Aug 2018 1@$1.4M, 8>$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 Feb 2018 1@1.435M, 3 Res>$500k July 2017 6>$500k Mar 2018 4 Res>$500k Aug 2017 1@$1.024, 1@1.37 and 11>$500k Apr 2018 1@2.16M, 11 Res>$500k 9/12/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 8 August 9/12/2018 REVENUE 4 yr avg *2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2013-16 Budget Actual DifferenceJanuary16,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$ 45,060$ 42,667$ 50,876$ 45,060$ -11.4% March 22,623$ 9,838$ 12,406$ 7,271$ 11,203$ 12,715$ 14,345$ 14,554$ 16,889$ 19,419$ 14,626$ 17,440$ 19,419$ 11.3% April 11,344$ 11,934$ 10,791$ 14,950$ 11,430$ 12,427$ 14,983$ 18,530$ 20,901$ 23,749$ 16,710$ 19,926$ 23,749$ 19.2% May 19,646$ 19,561$ 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 41,061$ 29,611$ 35,308$ 41,061$ 16.3%June 19,205$ 19,650$ 17,302$ 17,916$ 16,477$ 18,786$ 25,070$ 29,476$ 31,485$ 36,556$ 26,204$ 31,247$ 36,556$ 17.0% July 20,155$ 14,326$ 19,311$ 20,201$ 21,512$ 24,536$ 27,711$ 33,687$ 38,400$ 44,445$ 31,083$ 37,064$ 44,445$ 19.9%August 35,178$ 36,076$ 24,742$ 31,171$ 33,140$ 37,534$ 48,845$ 56,349$ 64,820$ 64,934$ 51,887$ 61,871$ 64,934$ 5.0% 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$ 298,401$ 419,737$ 500,500$ 298,401$ YTD 172,238$ 143,846$ 146,733$ 143,884$ 158,909$ 169,080$ 208,032$ 251,608$ 290,924$ 298,401$ 229,911$ 274,149$ 298,401$ 8.8% $- $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