Loading...
HomeMy WebLinkAbout2019-12_RevenueRpts_December2019 12 December General Fund 9-Jan-2019 General Fund County Treasurer REVENUE NAME BARS BUDGET Quarterly AMENDED DEC Y-T-D Y-T-D Y-T-D BUDGET ACTUAL DEC Y-T-D Y-T-D Y-T-D ACTUAL DEC Y-T-D Y-T-D *2019 Approp Budget 2019 2019 2019 % Over/Under Amended Budget 2018 2018 2018 2018 % of Actual % of Final Amended Budget 2017 2017 2017 % of ActualProperty Tax 1 311.10 8,021,323 8,021,323 52,255 7,992,860 99.6%(28,463)7,850,027 7,805,908 27,797 7,805,908 100.0%99.4%7,643,881 45,801 7,643,881 100.0%Diverted Road Prop Tax 1 311.20 720,000 720,000 3,953 720,000 100.0%0 720,000 720,000 4,677 720,000 100.0%100.0%720,000 3,784 720,000 100.0%Sales Tax 1 313.11 3,204,826 192,869 3,397,695 337,112 3,601,761 106.0%204,066 3,040,000 3,195,259 280,843 3,195,259 100.0%105.1%2,876,339 219,772 2,876,339 100.0% special purpose 313.15 1,006,979 55,384 1,062,363 93,783 1,064,119 100.2%1,756 955,428 999,945 83,431 999,945 100.0%104.7%903,099 69,582 903,099 100.0% Local Criminal Justice 1 313.71 407,177 22,395 429,572 38,953 442,239 102.9%12,667 380,070 417,655 35,010 417,655 100.0%109.9%375,219 29,090 375,219 100.0% Leasehold Excise Tax 3 317.20 66,801 66,801 17,415 75,500 113.0%8,699 62,000 65,642 13,910 65,642 100.0%105.9%69,801 16,019 69,801 100.0%Private Harvest Tax - TAV 2 317.40.10/.20 339,599 339,599 - 363,246 107.0%23,647 335,000 537,635 - 537,635 100.0%160.5%377,824 - 377,824 100.0%P.I.L.T. (incl DNR)4 332.15.23/336.02.31 1,015,136 537,328 1,552,464 16,127 1,553,455 100.1%991 1,867,988 1,850,941 17,123 1,850,941 100.0%99.1%1,458,645 67,873 1,458,645 100.0%P.U.D. Privilege Tax 4 335.00.91 375,296 375,296 - 385,397 102.7%10,101 323,420 393,491 - 393,491 100.0%121.7%314,148 - 314,148 100.0%Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 438,612 438,612 - 336,086 76.6%(102,526)463,500 425,438 - 425,438 100.0%91.8%435,778 - 435,778 100.0%Marijuana Enforcement/Excise 6 336.06.41/42 51,017 51,017 12,294 170,903 335.0%119,886 24,720 63,962 12,187 63,962 100.0%258.7%21,297 4,973 21,297 100.0%Liquor Excise Tax 8 336.06.94 47,321 47,321 - 51,439 108.7%4,118 41,536 47,254 - 47,254 100.0%113.8%44,174 - 44,174 100.0% Liquor Profit 6 336.06.95 88,873 88,873 20,844 83,623 94.1%(5,250)90,203 84,066 20,968 84,066 100.0%93.2%84,441 21,065 84,441 100.0% Treasurer Invest & Other Fees 1 341.42.15-20/50 35,000 35,000 2,412 43,596 124.6%8,596 16,290 42,753 2,476 42,753 100.0%262.5%33,805 (1,893) 33,805 100.0%Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 87,175 8,254 85,234 97.8%(1,941)80,000 83,290 4,961 83,290 100.0%104.1%90,727 6,896 90,727 100.0%Penalties on delinquent taxes 1 359.40.10/.20 117,409 117,409 15,206 113,976 97.1%(3,433)133,332 98,079 9,483 98,079 100.0%73.6%98,944 18,310 98,944 100.0%Investment Income 1 361.11 349,847 600,000 949,847 37,794 1,028,831 108.3%78,984 230,000 534,468 48,362 534,468 100.0%232.4%354,385 (35,653) 354,385 100.0%Interest on delinquent taxes 1 361.40.10 188,545 188,545 23,553 224,004 118.8%35,459 210,000 197,154 9,899 197,154 100.0%93.9%193,625 21,221 193,625 100.0%Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 329,632 329,632 193,507 232,066 70.4%(97,566)328,526 409,407 193,381 409,407 100.0%124.6%143,455 116,388 143,455 100.0%DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 250,000 500,000 15,376 352,075 70.4%(147,925)250,000 330,761 33,907 330,761 100.0%132.3%207,899 448 207,899 100.0% Transfer in 1 397.00 8,000 8,000 - 21,798 272.5%13,798 3,000 42,992 12,065 42,992 100.0%1433.1%40,322 1,484 40,322 100.0% Miscellaneous 162.50.1/369.81/369.9 13,631 13,631 59,426 111,997 821.6%98,366 11,900 43,811 28,764 43,811 100.0%368.2%9,020 2,157 9,020 100.0%Assessor 1 001-010-000 8,300 8,300 1,725 9,642 116.2%1,342 8,700 8,542 715 8,542 100.0%98.2%10,970 367 10,970 100.0%Auditor-Recording Fees 1 341.21.10 70,510 70,510 7,165 69,039 97.9%(1,471)72,063 70,227 5,446 70,227 100.0%97.5%74,248 6,318 74,248 100.0%Auditor-M.V. License Fees 1 341.48+/336.00.93 229,257 229,257 14,779 302,603 132.0%73,346 232,703 234,383 10,663 234,383 100.0%100.7%242,031 9,346 242,031 100.0%Auditor-Other Revenue 1 42,450 42,450 1,374 35,127 82.7%(7,323)26,605 34,184 2,671 34,184 100.0%128.5%29,714 2,356 29,714 100.0%Elections 1 001-021-000 130,160 130,160 9,948 161,606 124.2%31,446 159,722 101,546 10 101,546 100.0%63.6%138,996 24,791 138,996 100.0%Clerk 1 001-020-000 152,506 152,506 7,725 149,436 98.0%(3,070)170,768 181,580 17,420 181,580 100.0%106.3%179,130 12,740 179,130 100.0%County Administrator 1 001-059-000 4,260 (560) 3,700 - 4,260 115.1%560 4,260 4,260 - 4,260 100.0%100.0%3,700 3,700 3,700 Commissioners 1 001-060-000 8,000 8,000 837 7,843 98.0%(157)8,000 8,522 661 8,522 100.0%106.5%8,923 850 8,923 100.0% Safety & Security 1 001-067-000 70,604 70,604 - 36,232 51.3%(34,372)64,959 44,082 2,537 44,082 100.0%67.9%66,877 - 66,877 100.0%Community Services 1 001-068-000 4,005 4,005 829 3,987 99.5%(18)6,900 4,180 29 4,180 100.0%60.6%4,611 657 4,611 100.0%District Court 1 001-080-000 636,823 (612) 636,211 71,232 682,644 107.3%46,433 603,032 674,579 31,551 674,579 100.0%111.9%596,433 62,426 596,433 100.0%Juvenile Service 1 001-110-000 298,727 (13,500) 285,227 23,632 243,744 85.5%(41,483)259,676 288,710 31,209 288,710 100.0%111.2%290,984 22,571 290,984 100.0%Prosecuting Attorney 1 001-150-000 148,916 16,789 165,705 47,544 257,902 155.6%92,197 178,690 110,543 15,149 110,543 100.0%61.9%151,185 7,049 151,185 100.0%Coroner 1 001-151-000 25,348 25,348 - 18,324 72.3%(7,024)25,348 32,723 - 32,723 100.0%129.1%24,610 - 24,610 100.0%Sheriff 1 001-180-000 561,174 483,436 1,044,610 112,170 1,141,545 109.3%96,935 625,969 618,527 65,862 618,527 100.0%98.8%722,960 202,044 722,960 100.0% Superior Court 1 001-240-000 60,912 109 61,021 41,194 50,414 82.6%(10,607)60,822 51,520 - 51,520 100.0%84.7%90,193 0 90,193 100.0% Non Departmental 1 001-270-000 50,437 25,000 75,437 1,250 39,722 52.7%(35,715)50,447 32,802 - 32,802 100.0%65.0%49,196 49,186 49,196 100.0% TOTAL CURRENT EXPENSE REVENUE 19,664,588 2,168,638 21,833,226 1,289,667 22,268,272 102.0%435,046 19,975,604 20,890,820 1,023,164 20,890,820 100.0%104.6%19,181,590 1,011,720 19,181,590 100.0% * 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 0 534 32,037 0 19,484 (83,690)253,160 21,705 253,160 *Oct 2019 Judgements/settlements for Federal PILT incl in Misc - 27,227*Dec 2019 foreclosure surplus from 2016 incl in Misc 58,450 58,450*2018 Budget Amendments made: Superior Court, PILT, SheriffDec 2018: 2015 Foreclosure surplus to General Fund Misc Revenue was $27,647.33 OTHER FUNDS REVENUE REPORT 2019 3 year view December 12 1/10/2019 FUND Fund #Orig Budget Budget Amended BDGT Dec YTD YTD ACTUAL Dec YTD YTD ACTUAL Dec YTD YTD 2019 Amendment 2019 2019 2019 %2019 2018 2018 %2017 2017 2017 % SPECIAL REVENUE Auditor's O & M 105 80,480 80,480 2,961 72,512 90.1%76,912 2,367 76,912 100.0%77,983 2,246 77,983 100.0% Court Facilitator 106 4,100 4,100 280 4,300 104.9%4,820 280 4,820 100.0%5,920 360 5,920 100.0% Boating Safety 107 48,500 1,638 50,138 50,138 100.0%47,887 436 47,887 100.0%49,100 - 49,100 100.0% WSU Cooperative 108 416,215 52,707 468,922 28,145 352,814 75.2%556,121 17,000 556,121 100.0%534,494 108,589 534,494 100.0% Noxious Weed 109 141,217 119,599 260,816 3,842 198,125 76.0%- 4-H After School 113 47,600 47,600 300 49,508 104.0%37,750 - 37,750 100.0%44,475 - 44,475 100.0% JeffComCap 119 119 204,000 204,000 17,000 204,000 100.0%264,695 22,058 264,695 100.0%254,838 21,221 254,838 100.0% Crime Victim's Svc 120 140,813 140,813 3,307 127,920 90.8%113,502 2,125 113,502 100.0%99,707 871 99,707 100.0% Grant Mgmt 123 150,000 150,000 10,911 119,570 79.7%101,793 13,345 101,793 100.0%76,723 18,378 76,723 100.0% Hotel-Motel 125 500,500 500,500 42,545 579,805 115.8%542,805 46,067 542,805 100.0%507,868 32,870 507,868 100.0% Jeff Co Public Health 127 4,422,082 229,547 4,651,629 390,359 4,758,462 102.3%4,606,955 257,481 4,606,955 100.0%4,064,163 275,247 4,064,163 100.0% Water Quality 128 1,163,949 1,163,949 77,942 1,025,077 88.1%969,155 66,710 969,155 100.0%975,455 118,089 975,455 100.0% Water Quality Land Acq 129 234,448 40,552 275,000 - 160,179 58.2%132,825 - 132,825 100.0%- Mental Health 130 47,637 47,637 560 50,299 105.6%50,132 499 50,132 100.0%47,474 355 47,474 100.0% Chem Dep Mnt Hlth tx 131 527,003 527,003 53,349 612,026 116.1%573,509 48,027 573,509 100.0%516,131 39,978 516,131 100.0% Drug Fund 135 12,249 12,249 306 5,982 48.8%14,395 2,611 14,395 100.0%11,819 898 11,819 100.0% Law Library 140 10,927 10,927 686 9,149 83.7%9,915 679 9,915 100.0%10,049 947 10,049 100.0% Trial Court Imprvmnt 141 23,000 23,000 - 22,806 99.2%23,201 - 23,201 100.0%23,449 5,864 23,449 100.0% Community Develpmnt 143 1,731,920 80,930 1,812,850 102,546 1,635,441 90.2%1,476,187 56,471 1,476,187 100.0%1,418,569 70,001 1,418,569 100.0% Federal Forest Title III 147 - - 169 21,440 20,164 175 20,164 100.0%669 71 669 Jeff Co Affrdbl Hsg 148 48,000 48,000 5,207 50,363 104.9%310,493 28,985 310,493 100.0%250,150 21,010 250,150 100.0% Homeless Housing Fund 149 315,000 272,282 587,282 31,991 304,747 51.9%- Treasurer's O & M 150 47,624 47,624 23,031 49,566 104.1%46,224 16,658 46,224 100.0%28,653 9,252 28,653 100.0% REET technology 151 15,690 15,690 1,266 15,250 97.2%16,175 1,174 16,175 100.0%16,827 1,372 16,827 100.0% Veteran's Relief 155 64,975 25,015 89,990 705 95,103 105.7%105,484 35,618 105,484 100.0%65,060 428 65,060 100.0% Park & Rec *174 669,649 669,649 13,770 665,738 99.4%674,760 (6,935) 674,760 100.0%625,429 40,184 625,429 100.0% County Park Imprvmnt 175 184,125 (24,000) 160,125 24,000 185,875 116.1%155,581 - 155,581 100.0%119,426 32,500 119,426 100.0% Post Harvest Timber Mgm 178 50 50 13 209 417.3%- County Roads 180 8,938,628 (6,707) 8,931,921 291,836 8,166,809 91.4%8,929,361 248,643 8,929,361 100.0%9,773,015 629,046 9,773,015 100.0% Facilities Mgmt 183 1,065,393 1,065,393 91,204 1,111,711 104.3%1,121,480 92,278 1,121,480 100.0%1,040,019 104,856 1,040,019 100.0% County Fair 199 280,000 515 280,515 3,685 298,092 106.3%252,937 5,993 252,937 100.0%308,594 4,440 308,594 100.0% Total Special Revenue 21,535,774 792,078 22,327,852 1,221,918 21,003,015 94.1%21,235,218 958,745 21,235,218 106.1%20,946,058 1,534,633 20,946,058 100.0% OTHER FUNDS REVENUE REPORT 2019 3 year view FUND Orig Budget Amended BDGT Dec YTD YTD YTD Dec YTD YTD YTD Dec YTD YTD 2019 2019 2019 2019 %2018 2018 2,018 %2017 2017 2017 % CAPITAL IMPROVEMENT Const/Renovation 301 518,500 518,500 510,415 773,299 149.1%110,679 46,000 110,679 11.1%517,754 2,413 517,754 100.0% Capital Improvement 302 1,072,125 1,072,125 125,158 1,246,025 116.2%1,264,506 74,910 1,264,506 117.9%1,285,270 100,034 1,285,270 100.0% Public Infrastructure 306 510,100 510,100 49,964 572,302 112.2%536,758 45,169 536,758 118.9%477,127 33,742 477,127 100.0% Conservation Futures 308 258,841 258,841 3,999 280,835 108.5%284,064 3,874 284,064 118.7%256,431 2,431 256,431 100.0% Total CAP IMP 2,359,566 - 2,359,566 689,535 2,872,460 121.7%2,196,007 169,953 2,196,007 79.5%2,536,581 138,620 2,536,581 100.0% ENTERPRISE Solid Waste 401 3,336,196 300,117 3,636,313 274,019 3,866,094 106.3%3,680,126 408,952 3,680,126 109.6%3,488,829 289,786 3,488,829 100.0% Solid Waste Post Clos 402 - - 64 1,094 979 95 979 652.9%516 (185) 516 100.0% Solid Waste Eqpt Res 403 8,000 8,000 1,287 19,648 245.6%15,780 1,696 15,780 394.5%7,601 (2,217) 7,601 100.0% Yard Waste Educ Fnd 404 6,800 6,800 9 209 3.1%5,765 11 5,765 99.4%5,750 5,725 5,750 100.0% Tri Area Sewer 405 234,500 69,132 303,632 100,406 303,778 100.0%42,268 1,166 42,268 16.5%297,554 86,399 297,554 100.0% Total ENTERPRISE 3,585,496 369,249 3,954,745 375,785 4,190,823 106.0%3,744,918 411,921 3,744,918 103.4%3,800,250 379,508 3,800,250 100.0% INTERNAL SERVICE Equipment Rental 501 2,421,684 717,803 3,139,487 322,889 2,915,525 92.9%2,950,721 697,255 2,950,721 120.4%2,508,636 279,082 2,508,636 100.0% Risk Management 502 215,000 215,000 38,522 38,522 17.9%27,431 - 27,431 12.8%112,770 37,659 112,770 100.0% Benefit Reserve 505 208,000 208,000 13,091 257,890 124.0%239,489 13,101 239,489 115.1%225,590 14,378 225,590 100.0% Information Services 506 1,901,855 295,210 2,197,065 21,097 2,116,237 96.3%2,004,180 91,194 2,004,180 91.9%1,832,926 121,680 1,832,926 100.0% Total INT SERV 4,746,539 1,013,013 5,759,552 395,600 5,328,174 92.5%5,221,821 801,551 5,221,821 103.3%4,679,922 452,798 4,679,922 100.0% Total 32,227,375 2,174,340 34,401,715 2,682,838 33,394,473 97.1%32,397,965 2,342,169 32,397,965 103.0%31,962,811 2,505,559 31,962,811 100.0% GENERAL FUND CASH BALANCE REPORT 1/22/2019 END OF MONTH CASH BALANCES 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 January 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$ 5,320,169$ February 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$ 4,464,746$ March 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$ 4,861,100$ April 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$ 7,300,275$ May 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$ 7,124,392$ June 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$ 8,169,229$ July 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$ 8,112,936$ August 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$ 6,926,951$ September 1,596,637$ 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ 4,511,047$ 5,850,565$ October 3,363,104$ 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ 6,245,727$ 6,682,718$ 8,291,898$ November 3,339,559$ 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ 6,098,807$ 6,804,203$ 7,781,753$ December 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ 6,038,266$ 7,658,281$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Budg Total Reserve $ 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,703,102 $ 3,281,222 15% GF Budgeted Expenditures * $ 1,530,071 $ 1,566,150 $ 1,608,161 $ 1,646,000 $ 1,681,257 $ 1,700,726 $ 1,806,223 $ 1,863,184 $ 1,977,102 $ 3,281,222 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 n/a ***The Required Reserve is based on 10% of the total General Fund budgeted expenditures (Res 59-15), 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 $8,000,000 $9,000,000 GENERAL FUND END OF MONTH CASH BALANCE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 12 December 1/9/2019 General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End3 yr. avg Expected Actual Over/Under Cum %projection 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2016-18 2019 2019 Expected expected Projection Over/Under January 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 258,313 6.6%223,186 258,313 $35,127 115.74%$3,932,455 $534,760February215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 314,528 9.7%329,106 314,528 -$14,578 103.72%$3,524,114 $126,419March122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 241,958 6.7%227,947 241,958 $14,011 104.43%$3,548,193 $150,498April131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 209,415 6.6%222,832 209,415 -$13,416 102.11%$3,469,315 $71,620May175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 295,191 8.5%288,218 295,191 $6,973 102.18%$3,471,676 $73,981June 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 263,069 7.4%252,081 263,069 $10,989 100.30%$3,407,933 $10,238July136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 308,592 8.0%271,157 308,592 $37,435 104.22%$3,541,015 $143,320August184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 355,294 10.0%339,327 355,294 $15,967 104.29%$3,543,624 $145,929September173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 319,609 9.0%307,168 319,609 $12,441 104.26%$3,542,587 $144,892October161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 306,832 334,704 9.4%319,373 334,704 $15,331 104.33%$3,544,678 $146,983 November 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 311,101 363,975 10.0%341,101 363,975 $22,874 104.59%$3,553,514 $155,819December150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 280,843 337,112 8.1%276,199 337,112 $60,913 106.01%$3,601,761 $204,066TTL1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 2,876,339 3,195,259 3,601,761 100.0%$3,397,695 $3,601,761ytd 1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 2,876,339 3,195,259 3,601,761 3,397,695 3,601,761 ytd change -10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09%12.72%6.01%over (under) ytd expected annual % chg.-10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09% Special Purp./Public Safety Tax Actual 3 yr avg.Projection Actual20102011201220132014201520162017201820192016-18 2019 2019 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 6.70%71,168 79,236 294,354 337,549 14.7%February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 9.6%102,297 94,690 431,403 409,218 -5.1%March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 6.8%72,608 70,614 300,555 312,572 4.0%April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 6.6%70,020 65,310 292,851 274,725 -6.2%May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 8.5%90,711 88,754 378,929 383,945 1.3%June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 7.4%78,821 77,429 330,902 340,499 2.9%July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 8.1%85,686 89,815 356,843 398,407 11.6%August 59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 9.9%104,820 107,514 444,146 462,808 4.2%September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 9.1%96,490 94,733 403,657 414,342 2.6% October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 9.4%99,574 97,187 418,947 431,890 3.1%November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 10.0%106,401 105,075 447,502 469,051 4.8%December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 7.9%83,769 93,783 359,968 430,895 19.7%TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 100.0%1,062,363 1,064,140 4,460,058 4,665,900 ytd 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 $1,064,140 1,062,363 $1,064,140 4,460,058 $4,665,900 4.6%ytd change 13.36%-0.35%9.55%13.93%3.07%10.72%6.42%0.17%over (under) ytd expectedannual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%0.17%over (under) ytd expected Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules. TOTAL 2019 SALES TAX 100,000 150,000 200,000 250,000 300,000 350,000 GENERAL SALES TAX RECEIPTS 2019 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 12/31/2019 Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 General & Optional F 2,311,638 2,469,708 2,453,909 2,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,876,339 3,195,259 3,264,649 Special Purpose FY - - - - - - 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 970,356 G&O and SP Sales T 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,235,005 Total Year 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,235,005 - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Sales Tax Total Received, Current Year is YTD General & Optional FY Special Purpose FY - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Sales Tax Per Year, Current Year is YTD General & Optional FY Special Purpose FY G&O and SP Sales Tax YTD Total Year 12 December 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation Recent 2019 2019 % Budget Change from 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 4 YR AVG Budget Actual Difference month prior year January 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 64,496 54,687 45,420 64,496 42.0%29.4% February 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 51,891 53,087 44,091 51,891 17.7%-20.2% March 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 82,105 103,834 86,239 82,105 -4.8%8.7% April 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 89,657 79,982 66,429 89,657 35.0%-12.5% May 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 105,332 87,483 111,001 26.9%-13.4% June 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 104,991 163,737 135,990 104,991 -22.8%-28.8% July 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 136,683 107,600 89,366 136,683 52.9%25.7% August 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 130,942 114,713 95,274 130,942 37.4%-0.1% September 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 105,075 153,642 127,606 105,075 -17.7%-10.7% October 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 134,016 117,994 97,999 134,016 36.8%12.5% November 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 110,009 89,362 74,219 110,009 48.2%14.2% December 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 74,910$ 125,158 90,165 74,885 125,158 67.1%67.1% Total $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 1,234,136$ 1,025,000$ 1,246,024$ 22%2.4% YTD 426,058 443,450 549,121 707,883 704,385 1,196,934 1,237,774 1,285,270 1,216,569 1,246,024 1,234,136$ 1,025,000$ 1,246,024$ 22%2.4% YTD change -23.84%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42% Annual % chg -23.84%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42% Total Sales Value for year incl City of PT 219,533,884 237,164,120 348,155,918 395,379,956 404,420,675 365,442,489 369,816,284 Jan 2018 no unincorp sales>$445k Jul 2018 10>$500k Jan 2019 7 sales>$500k Jul 2019 1@$3.3M, 16>$500k Feb 2018 1@1.435M, 3 Res>$500k Aug 2018 1@$1.4M, 8>$500k Feb 2019 1@$1M, 4 sales>$500k Aug 2019 2@$1.25M &1.2M, 12>$500k Mar 2018 4 Res>$500k Sep 2018 1@1.2M, 14>$500k Mar 2019 1@$1.4M, 6 sales>$500k Sep 2019 1@$1.25M & 1.425M, 11>$500k Apr 2018 1@2.16M, 11 Res>$500k Oct 2018 14>$500k Apr 2019 9 sales>$500k Oct 2019 2@$1.475M and 1.5M, 6>$500k May 2018 2@1.044 and 1.165M, 13 >$500k Nov 2018 12>$500k May 2019 1@1.045M, 9 sales>$500k Nov 2019 2@$1.75M & 1.1M, 12>$500k Jun 2018 1 sale@$3M, 16>$500k Dec 2018 2 sales @1.75M & 1.14M and 5>$500k Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k 1/10/2019 $- $50,000 $100,000 $150,000 $200,000 $250,000 2019 REET RECEIPTS 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 12 December 1/10/2019 4 yr avg *2019 2019 % Budget % Diff 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2015-18 Budget Actual Difference Prior Year January 10,732$ 11,507$ 12,045$ 8,863$ 13,575$ 17,051$ 18,473$ 19,394$ 23,177$ 29,854$ 19,524$ 20,725$ 29,854$ 44.0%28.8% February 21,729$ 25,532$ 23,188$ 38,274$ 30,356$ 36,141$ 51,077$ 53,093$ 46,226$ 41,186$ 46,634$ 49,504$ 41,186$ -16.8%-10.9%March 9,838$ 12,406$ 7,271$ 11,203$ 12,715$ 14,345$ 14,554$ 16,889$ 19,419$ 25,281$ 16,302$ 17,305$ 25,281$ 46.1%30.2% April 11,934$ 10,791$ 14,950$ 11,430$ 12,427$ 14,983$ 18,530$ 20,901$ 23,749$ 22,829$ 19,541$ 20,743$ 22,829$ 10.1%-3.9%May 19,561$ 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 41,061$ 41,546$ 35,088$ 37,248$ 41,546$ 11.5%1.2%June 19,650$ 17,302$ 17,916$ 16,477$ 18,786$ 25,070$ 29,476$ 31,485$ 36,556$ 43,299$ 30,647$ 32,533$ 43,299$ 33.1%18.4% July 14,326$ 19,311$ 20,201$ 21,512$ 24,536$ 27,711$ 33,687$ 38,400$ 44,445$ 48,748$ 36,061$ 38,280$ 48,748$ 27.3%9.7%August 36,076$ 24,742$ 31,171$ 33,140$ 37,534$ 48,845$ 56,349$ 64,820$ 64,934$ 70,516$ 58,737$ 62,352$ 70,516$ 13.1%8.6% September 40,208$ 42,500$ 40,882$ 39,890$ 42,349$ 44,713$ 53,487$ 56,561$ 68,870$ 88,306$ 55,908$ 59,349$ 88,306$ 48.8%28.2%October 46,548$ 43,861$ 41,015$ 41,741$ 43,659$ 49,182$ 59,970$ 58,458$ 65,200$ 60,682$ 58,203$ 61,785$ 60,682$ -1.8%-6.9%November 43,285$ 38,547$ 36,906$ 39,146$ 46,879$ 58,967$ 57,999$ 69,054$ 63,101$ 65,013$ 62,280$ 66,113$ 65,013$ -1.7%3.0% December 18,741$ 21,703$ 11,109$ 15,514$ 33,858$ 25,213$ 26,084$ 32,870$ 46,067$ 42,545$ 32,559$ 34,562$ 42,545$ 23.1%-7.6% Total 292,628$ 293,344$ 273,796$ 295,200$ 335,825$ 386,107$ 449,148$ 507,868$ 542,805$ 579,805$ 471,482$ 500,500$ 579,805$ YTD 292,628$ 293,344$ 273,796$ 295,200$ 335,825$ 386,107$ 449,148$ 507,868$ 542,805$ 579,805$ 471,482$ 500,500$ 579,805$ 15.8%6.8% YTD Change -8.90%0.24%-7.14%7.25%12.10%13.02%14.04%11.56%6.44%6.38% Annual % Change -8.90%0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88% 2% Basic RCW 67.28.180 2% Special RCW 67.28.181(1).11% Total sales tax paid on a lodging charges for periods of less than 30 consecutive days Revenue reflects 2% "basic" as a credit against 6.5% state sales tax, 2% "special" tax levied locally, interest on amounts held at DOR until disbursement, and 1% Admin fee from DOR. Revenue is reported one month after reporting to DOR. It typically reflects collections for activity from two months prior to distribution. Some businesses may report quarterly or annually. $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 2019 HOTEL/MOTEL LODGING TAX -Fund 125 Includes Investment Interest 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019