Loading...
HomeMy WebLinkAbout2020-03_RevenueRptsJEFFERSON COUNTY TREASURER PO Box 571, Port Townsend WA 98368 Email: sprada@co.jefferson.wa.us Web: www.co.jefferson.wa.us Stacie Prada – Treasurer (360) 385-9150 Janet A. Holbrook – Chief Deputy (360) 385-9151 Page | 1 JEFFERSON COUNTY BUDGET COMMITTEE Treasurer’s Revenue Report March 2020 Revenue April 29, 2020 Meeting  General Fund at $3,850,561 – 18% of the 2020 budget year to date which is slightly higher than last year. Property tax collections are slightly higher than the last two years but the same percentage as 2016 and 2017 YTD.  Other Funds at $6,941,080– 20.4% of 2020 budget year to date. This is similar to previous years.  General Fund Cash Balance - $6,359,340 at the end of March which includes the $3.218 million budgeted reserve.  General Sales Tax Receipts - $324,431 which includes $72,888 for Special Purpose in March 2020. General & Optional Sales tax is 20.65% over budget for 2020 YTD, and Special Purpose was 7.35% over our budgeted projection. Cumulatively they’re 12.1% over budget for the month and 17.4% year to date. The second sheet shows the split of the two and amounts year to date per year since 2005.  REET Receipts - Fund 302 - $93,964 in March, which is 23.3% over budget and 14.4% over what was collected this month last year. One sale of residential property in Quilcene sold for 1.025 million, and ten sales were between $500,000 and $1 million in March. Four were in unincorporated Port Townsend, three in the Nordland/Chimacum tax area, and one each in Port Ludlow, Sequim and Quilcene.  Hotel/Motel Lodging Tax – Fund 125 - $29,621 in March, which is 55% over budget for the month and 17.2% over the amount collected this month last year. Year to date it is 0.6% under budget. 2020 3 March General Fund 2-Apr-2020 General Fund Jefferson County Treasurer General Fund REVENUE NAME BARS BUDGET Quarterly AMENDED MAR Y-T-D Y-T-D BUDGET Quarterly AMENDED ACTUAL MAR Y-T-D Y-T-D BUDGET ACTUAL MAR Y-T-D Y-T-D *2020 Approp Budget 2020 2020 2020 %2019 Approp Budget 2019 2019 2019 2019 %2018 2018 2018 2018 % of ActualProperty Tax 1 311.10 8,290,037 8,290,037 505,975 927,193 11.2%8,021,323 8,021,323 7,992,860 476,566 872,999 10.9%7,850,027 7,805,908 464,793 817,533 10.5%Diverted Road Prop Tax 1 311.20 720,000 720,000 44,119 82,448 11.5%720,000 720,000 720,000 43,768 80,353 11.2%720,000 720,000 44,191 77,282 10.7%Sales Tax 1 313.11 3,326,609 3,326,609 251,543 910,613 27.4%3,204,826 192,869 3,397,695 3,601,761 241,958 814,799 24.0%3,040,000 3,195,259 206,999 694,199 21.7% special purpose 313.15 1,045,244 1,045,244 72,888 258,820 24.8%1,006,979 55,384 1,062,363 1,064,119 70,614 244,540 23.0%955,428 999,945 66,479 224,325 22.4%Local Criminal Justice 1 313.71 422,650 422,650 30,454 107,700 25.5%407,177 22,395 429,572 442,239 29,465 101,443 23.6%380,070 417,655 28,024 93,674 22.4%Leasehold Excise Tax 3 317.20 66,801 66,801 - 18,910 28.3%66,801 66,801 75,500 - 17,921 26.8%62,000 65,642 - 13,824 21.1% Private Harvest Tax - TAV 2 317.40.10/.20 339,599 339,599 - 94,932 28.0%339,599 339,599 363,246 - 119,439 35.2%335,000 537,635 - 186,243 34.6%P.I.L.T. (incl DNR)4 332.15.23/336.02.31 1,015,150 1,015,150 - 0 0.0%1,015,136 537,328 1,552,464 1,553,455 - 0 0.0%1,867,988 1,850,941 - 0 0.0%P.U.D. Privilege Tax 4 335.00.91 386,555 386,555 - 0 0.0%375,296 375,296 385,397 - 0 0.0%323,420 393,491 - 0 0.0%Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 451,770 451,770 - 124,447 27.5%438,612 438,612 336,086 - 104,627 23.9%463,500 425,438 - 108,130 25.4%Marijuana Enforcement/Excise 6 336.06.41/42 52,548 52,548 12,231 12,231 23.3%51,017 51,017 170,903 12,113 12,113 23.7%24,720 63,962 27,251 27,251 42.6%Liquor Excise Tax 8 336.06.94 48,267 48,267 - 12,459 25.8%47,321 47,321 51,439 - 11,710 24.7%41,536 47,254 - 10,819 22.9%Liquor Profit 6 336.06.95 90,650 90,650 20,844 20,844 23.0%88,873 88,873 83,623 20,968 20,968 23.6%90,203 84,066 21,065 21,065 25.1% Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 35,830 2,770 8,383 23.4%35,000 35,000 43,596 3,054 9,283 26.5%16,290 42,753 2,644 7,677 18.0%Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 87,175 4,828 15,189 17.4%87,175 87,175 85,234 6,077 13,979 16.0%80,000 83,290 5,723 14,793 17.8%Penalties on delinquent taxes 1 359.40.10/.20 119,757 119,757 9,477 32,284 27.0%117,409 117,409 113,976 11,800 34,331 29.2%133,332 98,079 5,424 22,565 23.0%Investment Income 1 361.11 713,000 713,000 43,460 158,390 22.2%349,847 600,000 949,847 1,028,831 369,016 486,091 51.2%230,000 534,468 39,823 101,014 18.9% Interest on delinquent taxes 1 361.40.10 192,316 192,316 15,422 38,279 19.9%188,545 188,545 224,004 22,790 46,704 24.8%210,000 197,154 9,860 30,757 15.6%Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 339,521 339,521 - 9,736 2.9%329,632 329,632 232,066 - 9,575 2.9%328,526 409,407 - 186,331 45.5%DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 250,000 53,394 146,719 58.7%250,000 250,000 500,000 352,075 38,848 200,248 40.0%250,000 330,761 2,090 2,539 0.8%Transfer in 1 397.00 3,000 3,000 24,072 24,822 827.4%8,000 8,000 21,798 2,404 3,154 39.4%3,000 42,992 6,482 7,232 16.8%Miscellaneous 162.50.1/369.81/369.9 27,784 27,784 1,631 3,869 13.9%13,631 13,631 111,997 1,355 5,039 37.0%11,900 43,811 762 2,566 5.9%Assessor 1 001-010-000 8,300 8,300 40 2,073 25.0%8,300 8,300 9,642 199 2,029 24.4%8,700 8,542 70 1,954 22.9%Auditor-Recording Fees 1 341.21.10 69,495 69,495 6,488 17,991 25.9%70,510 70,510 69,039 5,293 12,574 17.8%72,063 70,227 6,178 16,358 23.3% Auditor-M.V. License Fees 1 341.48+/336.00.93 246,440 246,440 17,011 68,326 27.7%229,257 229,257 302,603 13,724 79,234 34.6%232,703 234,383 47,364 70,415 30.0%Auditor-Other Revenue 1 35,330 35,330 2,219 8,522 24.1%42,450 42,450 35,127 3,068 8,967 21.1%26,605 34,184 2,626 7,623 22.3%Elections 1 001-021-000 116,110 116,110 135,891 201,895 173.9%130,160 130,160 161,606 58,222 75,218 57.8%159,722 101,546 10,454 63,487 62.5%Clerk 1 001-020-000 149,591 149,591 8,557 36,816 24.6%152,506 152,506 149,436 7,592 30,190 19.8%170,768 181,580 13,717 44,518 24.5%County Administrator 1 001-059-000 438,600 438,600 0 4,000 0.9%4,260 (560) 3,700 4,260 0 4,260 115.1%4,260 4,260 0 4,260 100.0%Commissioners 1 001-060-000 8,000 8,000 679 2,005 25.1%8,000 8,000 7,843 604 1,479 18.5%8,000 8,522 711 1,958 23.0%Safety & Security 1 001-067-000 75,538 75,538 0 0 0.0%70,604 70,604 36,232 0 17,380 24.6%64,959 44,082 0 15,742 35.7% Community Services 1 001-068-000 4,155 4,155 34 815 19.6%4,005 4,005 3,987 40 1,073 26.8%6,900 4,180 29 421 10.1%District Court 1 001-080-000 644,505 644,505 39,329 115,131 17.9%636,823 (612) 636,211 682,644 39,024 108,891 17.1%603,032 674,579 45,171 113,796 16.9%Juvenile Service 1 001-110-000 279,284 279,284 22,654 83,231 29.8%298,727 (13,500) 285,227 243,744 28,252 73,851 25.9%259,676 288,710 34,167 73,951 25.6%Prosecuting Attorney 1 001-150-000 320,633 320,633 7,958 20,113 6.3%148,916 16,789 165,705 257,902 7,190 25,769 15.6%178,690 110,543 7,169 25,503 23.1% Coroner 1 001-151-000 25,348 25,348 - 7,958 31.4%25,348 25,348 18,324 - 11,924 47.0%25,348 32,723 1,700 1,700 5.2%Sheriff 1 001-180-000 794,303 794,303 129,248 231,255 29.1%561,174 483,436 1,044,610 1,141,545 81,232 205,051 19.6%625,969 618,527 24,767 93,388 15.1% Superior Court 1 001-240-000 59,421 59,421 400 5,960 10.0%60,912 109 61,021 50,414 1,320 5,820 9.5%60,822 51,520 25 11,840 23.0% Non Departmental 1 001-270-000 35,568 35,568 36,204 101.8%50,437 25,000 75,437 39,722 - 34,152 45.3%50,447 32,802 - 32,802 100.0% TOTAL CURRENT EXPENSE REVENUE 21,334,884 - 21,334,884 1,463,615 3,850,561 18.0%19,664,588 2,168,638 21,833,226 1,596,555 3,907,177 17.9%19,975,604 20,890,820 1,125,759 3,229,534 15.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 0 626.13 19,416 0 621.65 4,286 0 0 9,039 OTHER FUNDS REVENUE REPORT 2020 3 year view March 3 4/2/2020 FUND Fund #Orig Budget Budget Amended BDGT Mar YTD YTD Orig Budget Budget Amended BDGT Mar YTD YTD ACTUAL Mar YTD YTD 2020 Amendment 2020 2020 2020 %2019 Amendment 2019 2019 2019 %2019 2018 2018 % SPECIAL REVENUE Auditor's O & M 105 77,900 77,900 2,369 7,028 9.0%80,480 80,480 2,177 5,333 6.6%76,912 2,192 6,057 7.9% Court Facilitator 106 4,500 4,500 280 860 19.1%4,100 4,100 540 1,180 28.8%4,820 300 1,340 27.8% Boating Safety 107 50,000 50,000 15,384 15,384 30.8%48,500 1,638 50,138 17,085 17,085 34.1%47,887 - - 0.0% WSU Cooperative 108 532,762 532,762 - 119,020 22.3%416,215 52,707 468,922 4,268 77,463 16.5%556,121 36,541 109,620 19.7% Noxious Weed 109 217,717 217,717 15,055 38,603 17.7%141,217 119,599 260,816 13,401 24,257 9.3% 4-H After School 113 Moved to Fund 108 - 47,600 47,600 - 31,732 66.7%37,750 2,500 29,750 78.8% JeffComCap 119 119 206,640 206,640 17,660 51,660 25.0%204,000 204,000 17,000 51,000 25.0%264,695 22,058 66,174 25.0% Crime Victim's Svc 120 81,543 81,543 2,981 11,226 13.8%140,813 140,813 2,708 29,050 20.6%113,502 1,607 26,726 23.5% Grant Mgmt 123 150,000 150,000 13,953 35,978 24.0%150,000 150,000 11,833 33,509 22.3%101,793 17,840 42,062 41.3% Hotel-Motel 125 521,444 521,444 29,621 95,736 18.4%500,500 500,500 25,281 96,321 19.2%542,805 19,419 88,821 16.4% Jeff Co Public Health 127 4,994,011 4,994,011 341,881 1,265,402 25.3%4,422,082 229,547 4,651,629 259,801 1,181,748 25.4%4,606,955 235,719 1,048,414 22.8% Water Quality 128 1,307,279 1,307,279 95,367 190,539 14.6%1,163,949 1,163,949 164,372 212,851 18.3%969,155 47,214 216,532 22.3% Water Quality Land Acq 129 115,000 115,000 - - 0.0%234,448 40,552 275,000 - - 0.0%132,825 - 0.0% Mental Health 130 50,289 50,289 3,196 6,698 13.3%47,637 47,637 2,953 6,777 14.2%50,132 2,693 5,754 11.5% Chem Dep Mnt Hlth tx 131 553,433 553,433 41,782 147,762 26.7%527,003 527,003 40,471 139,334 26.4%573,509 38,529 128,787 22.5% Drug Fund 135 13,850 13,850 561 1,193 8.6%12,249 12,249 675 2,281 18.6%14,395 2,037 3,677 25.5% Law Library 140 16,081 16,081 742 6,938 43.1%10,927 10,927 757 2,024 18.5%9,915 749 2,093 21.1% Trial Court Imprvmnt 141 23,000 23,000 - 7,084 30.8%23,000 23,000 - 5,700 24.8%23,201 - 5,807 25.0% Community Develpmnt 143 1,657,637 1,657,637 54,919 353,463 21.3%1,731,920 80,930 1,812,850 73,333 314,253 17.3%1,476,187 86,980 337,472 22.9% Federal Forest Title III 147 21,000 21,000 151 486 - - 180 566 20,164 85 258 1.3% Jeff Co Affrdbl Hsg 148 45,131 45,131 4,281 12,574 27.9%48,000 48,000 3,907 9,445 19.7%310,493 20,399 56,491 18.2% Homeless Housing Fund 149 272,874 272,874 25,422 75,646 27.7%315,000 272,282 587,282 23,840 57,401 9.8% Treasurer's O & M 150 54,650 54,650 56 2,401 4.4%47,624 47,624 101 292 0.6%46,224 1,815 2,904 6.3% REET technology 151 13,816 13,816 960 3,246 23.5%15,690 15,690 989 2,967 18.9%16,175 1,151 3,561 22.0% Veteran's Relief 155 65,510 65,510 3,335 25,020 38.2%64,975 25,015 89,990 3,140 24,641 27.4%105,484 2,804 22,886 21.7% Park & Rec 174 684,549 684,549 1,696 153,007 22.4%669,649 669,649 12,834 157,831 23.6%674,760 12,513 155,159 23.0% County Park Imprvmnt 175 171,625 171,625 - 3,317 1.9%184,125 (24,000) 160,125 8,072 8,072 5.0%155,581 - - 0.0% Post Harvest Timber Mgm 178 - - 12 39 50 50 17 53 106.4% County Roads 180 8,801,630 8,801,630 663,590 1,585,440 18.0%8,938,628 (6,707) 8,931,921 653,324 1,750,407 19.6%8,929,361 457,672 1,604,914 18.0%Facilities Mgmt *507 eff 7/1 183 1,169,335 1,169,335 213,557 326,561 27.9%1,065,393 1,065,393 115,193 295,902 27.8%1,121,480 119,626 298,544 26.6% County Fair 199 280,000 515 280,515 8,096 22,383 8.0%252,937 41,669 55,497 21.9% Total Special Revenue 21,873,206 - 21,873,206 1,548,811 4,542,311 20.8%21,535,774 792,078 22,327,852 1,466,348 4,561,861 20.4%21,235,218 1,132,442 4,319,298 21.6% OTHER FUNDS REVENUE REPORT 2019 3 year view FUND Orig Budget Amended BDGT Mar YTD YTD Orig Budget Amended BDGT Mar YTD YTD YTD Mar YTD YTD 2020 2020 2020 2020 %2019 2019 2019 2019 %2018 2018 2,018 % CAPITAL IMPROVEMENT Const/Renovation 301 363,826 363,826 10,467 46,838 12.9%518,500 518,500 - 1,863 0.4%110,679 - 1,808 0.2% Capital Improvement 302 1,156,313 1,156,313 93,964 247,610 21.4%1,072,125 1,072,125 82,105 198,491 18.5%1,264,506 75,558 190,455 17.8% Public Infrastructure 306 565,000 565,000 38,568 137,465 24.3%510,100 510,100 38,654 132,065 25.9%536,758 36,079 120,072 26.6% Conservation Futures 308 271,860 271,860 17,674 37,984 14.0%258,841 258,841 16,643 39,367 15.2%284,064 14,985 32,728 13.7% Total CAP IMP 2,356,999 - 2,356,999 160,673 469,896 19.9%2,359,566 - 2,359,566 137,402 371,786 15.8%2,196,007 126,622 345,064 12.5% ENTERPRISE Solid Waste 401 3,718,073 3,718,073 296,785 861,160 23.2%3,336,196 300,117 3,636,313 303,269 849,097 23.4%3,680,126 251,170 747,833 22.3% Solid Waste Post Clos 402 - - 47 167 - - 102 294 979 70 192 128.3% Solid Waste Eqpt Res 403 15,000 15,000 930 3,317 22.1%8,000 8,000 1,819 5,237 65.5%15,780 1,093 2,993 74.8% Yard Waste Educ Fnd 404 7,000 7,000 4 14 0.2%6,800 6,800 17 55 0.8%5,765 7 20 0.3% Tri Area Sewer 405 982,500 982,500 862 2,709 0.3%234,500 69,132 303,632 1,399 4,304 1.4%42,268 877 2,636 1.0% Total ENTERPRISE 4,722,573 - 4,722,573 298,628 867,367 18.4%3,585,496 369,249 3,954,745 306,606 858,987 21.7%3,744,918 253,217 753,674 20.8% INTERNAL SERVICE Equipment Rental 501 2,617,745 2,617,745 191,291 440,412 16.8%2,421,684 717,803 3,139,487 242,524 505,010 16.1%2,950,721 189,105 411,820 16.8% Risk Management 502 150,000 150,000 - - 0.0%215,000 215,000 - 0 0.0%27,431 - - 0.0% Benefit Reserve 505 275,000 275,000 24,204 129,820 47.2%208,000 208,000 24,318 74,098 35.6%239,489 21,507 69,485 33.4% Information Services 506 1,968,639 1,968,639 7,945 491,273 25.0%1,901,855 295,210 2,197,065 15,505 466,789 21.2%2,004,180 49,827 534,525 24.5%Facilities Mgmt eff 7/1/202 507 - - 1,065,393 1,065,393 115,193 295,902 27.8%1,121,480 119,626 298,544 26.6% Total INT SERV 5,011,384 - 5,011,384 223,440 1,061,506 21.2%4,746,539 1,013,013 5,759,552 282,347 1,045,898 18.2%5,221,821 260,439 1,015,831 20.1% Total 33,964,162 - 33,964,162 2,231,552 6,941,080 20.4%32,227,375 2,174,340 34,401,715 2,192,703 6,838,532 19.9%32,397,965 1,772,721 6,433,867 20.4% GENERAL FUND CASH BALANCE REPORT 4/2/2020 END OF MONTH CASH BALANCES 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 January 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$ 6,803,191$ February 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$ 6,243,097$ March 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$ 6,359,340$ April 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,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 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 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,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 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 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 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,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) 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Budg Total Reserve $ 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 $ 3,218,697 15% GF Budgeted Expenditures * $ 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 $ 3,218,697 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 n/a 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 Resolution 41-19 changed the reserve to 15% of the GF Total Spending and eliminated the Revenue Stabilization Reserve - changes with appropriations throughout yea $- $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 January February March April May June July August September October November December General Fund Cash Balance 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 3 4/2/2020 March General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cumulative Cumulative Year End3 yr. avg Expected Actual Over/Under % of projection 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under January 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 258,313 303,235 6.7%224,122 303,235 $79,114 135.30%$4,500,882 $1,174,273 February 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 314,528 355,834 9.4%311,072 355,834 $44,762 123.15%$4,096,584 $769,975 March 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 241,958 251,543 6.6%219,588 251,543 $31,956 120.65%$4,013,416 $686,807April127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 209,415 6.3%208,334 - -$208,334 94.55% #VALUE! May 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 295,191 8.4%280,693 - -$280,693 73.21% #VALUE! June 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 263,069 7.4%247,577 - -$247,577 47.93% #VALUE! July 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 308,592 8.3%277,705 - -$277,705 51.47% #VALUE! August 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 355,294 9.9%329,733 - -$329,733 43.39% #VALUE! September 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 319,609 9.0%298,735 - -$298,735 37.98% #VALUE! October 182,962 203,958 214,572 208,256 239,390 254,002 267,264 306,832 334,704 9.4%312,531 - -$312,531 33.60% #VALUE! November 180,293 206,475 220,843 231,070 240,812 293,377 279,959 311,101 363,975 9.9%328,431 - -$328,431 29.97% #VALUE! December 146,560 176,593 169,167 196,112 195,665 215,537 219,772 280,843 337,112 8.7%288,089 - -$288,089 27.37% #VALUE!TTL 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 910,613 100.0%$3,326,609 $910,613 ytd 475,166 459,855 600,029 551,913 567,988 643,063 685,810 694,199 814,799 910,613 754,781 910,613 ytd change 0.75%-3.22%30.48%-8.02%2.91%13.22%6.65%1.22%17.37%11.76%20.65%over (under) ytd expected annual % chg.2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09%12.72% Special Purp./Public Safety Tax Actual 3 yr avg.Projection Actual20112012201320142015201620172018201920202017-19 2020 2020 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 7.0%73,057 84,751 297,178 387,987 30.6% February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 9.4%98,207 101,181 409,279 457,015 11.7%March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 6.7%69,846 72,888 289,434 324,431 12.1% April 43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 6.4%66,580 - 274,914 - -100.0% May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 8.5%88,710 - 369,403 - -100.0% June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 7.3%76,724 - 324,301 - -100.0% July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 8.2%85,977 - 363,682 - -100.0% August 59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 9.9%103,727 - 433,460 - -100.0% September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 9.1%94,867 - 393,602 - -100.0% October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 9.3%97,103 - 409,634 - -100.0% November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 9.9%103,507 - 431,938 - -100.0%December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 8.3%86,938 - 375,028 - -100.0% TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 258,820 100.0%1,045,244 258,820 4,371,853 1,169,433 ytd 0 147,720 177,703 167,667 175,505 203,831 215,586 224,325 244,540 258,820 241,110 $258,820 995,892 $1,169,433 17.4% ytd change 20.30%-5.65%4.67%16.14%5.77%4.05%9.01%5.84%7.35%over (under) ytd expected annual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42% 7.35%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 2020 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 4/2/2020 Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 General & Optional Y 521,179 585,596 563,355 584,806 549,637 471,619 475,166 459,855 600,029 551,913 567,988 643,063 685,810 694,199 814,799 910,613 Special Purpose YTD - - - - - - - 147,720 177,703 167,667 175,505 203,831 215,586 224,325 244,540 258,820 G&O and SP Sales T 521,179 585,596 563,355 584,806 549,637 471,619 475,166 607,575 777,732 719,580 743,493 846,894 901,396 918,525 1,059,339 1,169,433 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 4,235,005 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Sales Tax Total Received YTD General & Optional YTD Special Purpose YTD - 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 2020 Sales Tax Per Year YTD General & Optional YTD Special Purpose YTD G&O and SP Sales Tax YTD Total Year 3 March 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation Recent 2019 2019 % Budget Change from 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 4 YR AVG Budget Actual Difference month prior year January 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 64,496 69,086 62,517 57,998 69,086 19.1%7.1% February 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 51,891 84,560 53,990 50,087 84,560 68.8%63.0% March 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 82,105 93,964 82,177 76,237 93,964 23.3%14.4% April 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 89,657 86,955 80,670 0 -100.0% May 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 114,808 106,509 0 -100.0% June 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 104,991 160,276 148,690 0 -100.0% July 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 136,683 114,120 105,871 0 -100.0% August 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 130,942 124,449 115,453 0 -100.0% September 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 105,075 124,986 115,952 0 -100.0% October 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 134,016 125,931 116,828 0 -100.0% November 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 110,009 100,356 93,102 0 -100.0% December 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 74,910$ 125,158 95,845 88,917 0 -100.0% Total $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $247,610 1,246,409$ 1,156,313$ 247,610$ -79%-80.1% YTD 157,229 98,437 89,794 111,709 250,192 187,949 217,838 190,455 198,491 247,610 198,683$ 184,322$ 247,610$ 34%24.7% YTD change -21.61%-37.39%-8.78%24.41%123.97%-24.88%15.90%-12.57%4.22%24.75% Annual % chg -21.61%-37.39%-8.78%24.41%123.97%-24.88%15.90%-12.57%4.22%24.75% 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 2019 7 sales>$500k Jul 2019 1@$3.3M, 16>$500k Jan 2020 9 sales>$500k Feb 2019 1@$1M, 4 sales>$500k Aug 2019 2@$1.25M &1.2M, 12>$500k Feb 2020 1@1.2M & 6 sales>$500k Mar 2019 1@$1.4M, 6 sales>$500k Sep 2019 1@$1.25M & 1.425M, 11>$500k Mar 2020 1@1.025M & 10 sales>$500k Apr 2019 9 sales>$500k Oct 2019 2@$1.475M and 1.5M, 6>$500k May 2019 1@1.045M, 9 sales>$500k Nov 2019 2@$1.75M & 1.1M, 12>$500k Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k 4/2/2020 $- $50,000 $100,000 $150,000 $200,000 $250,000 2020 REET RECEIPTS 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 3 March 4/2/2020 4 yr avg *2020 2020 % Budget % Diff 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2016-19 Budget Actual Difference Prior Year January 11,507$ 12,045$ 8,863$ 13,575$ 17,051$ 18,473$ 19,394$ 23,177$ 29,854$ 32,023$ 22,725$ 22,792$ 32,023$ 40.5%7.3% February 25,532$ 23,188$ 38,274$ 30,356$ 36,141$ 51,077$ 53,093$ 46,226$ 41,186$ 34,092$ 47,895$ 48,037$ 34,092$ -29.0%-17.2% March 12,406$ 7,271$ 11,203$ 12,715$ 14,345$ 14,554$ 16,889$ 19,419$ 25,281$ 29,621$ 19,035$ 19,092$ 29,621$ 55.2%17.2% April 10,791$ 14,950$ 11,430$ 12,427$ 14,983$ 18,530$ 20,901$ 23,749$ 22,829$ 21,502$ 21,566$ May 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 41,061$ 41,546$ 39,503$ 39,620$ June 17,302$ 17,916$ 16,477$ 18,786$ 25,070$ 29,476$ 31,485$ 36,556$ 43,299$ 35,204$ 35,308$ July 19,311$ 20,201$ 21,512$ 24,536$ 27,711$ 33,687$ 38,400$ 44,445$ 48,748$ 41,320$ 41,442$ August 24,742$ 31,171$ 33,140$ 37,534$ 48,845$ 56,349$ 64,820$ 64,934$ 70,516$ 64,155$ 64,345$ September 42,500$ 40,882$ 39,890$ 42,349$ 44,713$ 53,487$ 56,561$ 68,870$ 88,306$ 66,806$ 67,004$ October 43,861$ 41,015$ 41,741$ 43,659$ 49,182$ 59,970$ 58,458$ 65,200$ 60,682$ 61,077$ 61,258$ November 38,547$ 36,906$ 39,146$ 46,879$ 58,967$ 57,999$ 69,054$ 63,101$ 65,013$ 63,792$ 63,980$ December 21,703$ 11,109$ 15,514$ 33,858$ 25,213$ 26,084$ 32,870$ 46,067$ 42,545$ 36,892$ 37,001$ Total 293,344$ 273,796$ 295,200$ 335,825$ 386,107$ 449,148$ 507,868$ 542,805$ 579,805$ 95,736$ 519,906$ 521,444$ 95,736$ YTD 49,445$ 42,504$ 58,340$ 56,646$ 67,537$ 84,104$ 89,375$ 88,821$ 96,321$ 95,736$ 89,655$ 89,921$ 95,736$ 6.5%-0.6% YTD Change -25.88%-14.04%27.14%-2.99%16.13%19.70%5.90%-0.62%7.79%-0.61% Annual % Change -8.68%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%$521,444 2020 Budget 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 2020 HOTEL/MOTEL LODGING TAX -Fund 125 Includes Investment Interest 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020