Loading...
HomeMy WebLinkAbout2020-05_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 May 2020 Revenue  General Fund at $9,372,879 – 43.9% of the 2020 budget year to date which is slightly less than last year. Property tax collections are slightly lower at 55.0%, but the percentage is similar to the past five years where it ranged from 55.9% to 56.5% We have not adjusted budget for the general fund due to COVID-19 impacts yet. Second Quarter budget appropriations in progress will also affect budget percentages.  Other Funds at $15,173,877– 42.1% of 2020 budget year to date. This is higher than previous years, but we also transferred $1 million from the General Fund to Capital Improvement as part of first quarter appropriations. This was possible since 2019 revenue received exceeded budgeted revenues, and it is intended to reimburse previous expenditures and fund future capital expenditures.  General Fund Cash Balance - $7,105,615 at the end of May which includes the $3.392 million budgeted reserve. This is slightly less than the amount for this time last year.  General Sales Tax Receipts - $342,896 which includes $75,138 for Special Purpose in May 2020. General & Optional Sales tax is down 9.3% from this month last year and 14.77% over budget for 2020 YTD. Special Purpose was down 15.3% from this time last year and 1.88% over our budgeted YTD projection. Cumulatively they’re 7.2% under budget for the month but 11.7% over for YTD. The second sheet shows the split of the two with amounts year to date and full year since 2005. The full year amount reflects YTD Actuals plus budgeted amount for the rest of 2020. 2020 Budget has not yet been adjusted due to COVID-19 impacts. Due to the two month time frame for processing and distribution to counties, we saw the first impact with our revenues received in May. In June and July we’ll likely see a better picture of how sales taxes are impacted during Stay Home, Stay Safe. We can hope it goes up in August when we receive sales tax revenue from June. Thankfully, we had a very strong beginning for 2020, but it dropped fast and severely. It helped me to look at the dates of the proclamations to compare revenue and business activity. Heightened awareness occurred mid-March, and most businesses shut down effective March 23. Days 23-31 (nine days) equals 29% of the month. JEFFERSON COUNTY BUDGET COMMITTEE Treasurer’s Revenue Report May 2019 Revenue Page | 2  REET Receipts - Fund 302 - $75,991 in May, which is 8 % over budget and 31.5% under what was collected this month last year. We had six sales in unincorporated Jefferson County in May with selling prices between $500,000 and $1 million, and one sale at $1.3 million for 140 acres forest land and outbuildings in Chimacum.  Hotel/Motel Lodging Tax – Fund 125 - $11,527 in May, which is 70.9% under budget for the month and 72.3% under the amount collected this month last year. Year to date it is 9.7% under budget. This is based on sales tax collected on sales two months prior. I added a sheet like I did for Sales Tax to show the revenue YTD and Full Year. 2020 is comprised of YTD actuals plus the amount budgeted for the rest of the year. Hotel/Motel is at 40% of what it was last month and 27.7% of this month last year. I anticipate Hotel/Motel to be near zero for the next two months (business conducted in April and May), 2020 5 May Jefferson County Treasurer 6-May-2020 General Fund REVENUE NAME BARS BUDGET QTRLY AMENDED MAY Y-T-D Y-T-D BUDGET Quarterly AMENDED ACTUAL MAY Y-T-D Y-T-D BUDGET ACTUAL MAY 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 700,138 4,562,512 55.0%8,021,323 8,021,323 7,992,860 604,467 4,529,478 56.5%7,850,027 7,805,908 632,604 4,365,455 55.9%Diverted Road Prop Tax 1 311.20 720,000 720,000 69,526 404,335 56.2%720,000 720,000 720,000 60,457 409,877 56.9%720,000 720,000 62,614 403,600 56.1%Sales Tax 1 313.11 3,326,609 3,326,609 267,758 1,427,543 42.9%3,204,826 192,869 3,397,695 3,601,761 295,191 1,319,406 38.8%3,040,000 3,195,259 271,431 1,168,163 36.6% special purpose 313.15 1,045,244 1,045,244 75,138 403,845 38.6%1,006,979 55,384 1,062,363 1,064,119 88,734 398,583 37.5%955,428 999,945 84,357 372,467 37.2%Local Criminal Justice 1 313.71 422,650 422,650 31,320 168,662 39.9%407,177 22,395 429,572 442,239 36,826 165,475 38.5%380,070 417,655 35,044 155,486 37.2%Leasehold Excise Tax 3 317.20 66,801 66,801 - 21,815 32.7%66,801 66,801 75,500 - 18,641 27.9%62,000 65,642 - 14,908 22.7%Private Harvest Tax - TAV 2 317.40.10/.20 339,599 339,599 42,393 137,325 40.4%339,599 339,599 363,246 139,839 259,278 76.3%335,000 537,635 123,357 309,599 57.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 - 248,894 55.1%438,612 438,612 336,086 - 209,259 47.7%463,500 425,438 4,288 216,268 50.8%Marijuana Enforcement/Excise 6 336.06.41/42 52,548 52,548 - 12,231 23.3%51,017 51,017 170,903 - 12,113 23.7%24,720 63,962 - 27,251 42.6%Liquor Excise Tax 8 336.06.94 48,267 48,267 - 27,160 56.3%47,321 47,321 51,439 - 26,177 55.3%41,536 47,254 - 23,707 50.2%Liquor Profit 6 336.06.95 90,650 90,650 - 20,844 23.0%88,873 88,873 83,623 - 20,968 23.6%90,203 84,066 - 21,065 25.1%Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 35,830 2,525 16,246 45.3%35,000 35,000 43,596 3,316 18,167 51.9%16,290 42,753 12,270 24,981 58.4%Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 87,175 3,889 24,098 27.6%87,175 87,175 85,234 8,103 29,160 33.5%80,000 83,290 8,542 30,268 36.3%Penalties on delinquent taxes 1 359.40.10/.20 119,757 119,757 13,999 55,772 46.6%117,409 117,409 113,976 10,279 60,261 51.3%133,332 98,079 8,888 45,607 46.5%Investment Income 1 361.11 713,000 713,000 18,763 213,531 29.9%349,847 600,000 949,847 1,028,831 58,803 613,354 64.6%230,000 534,468 47,617 186,312 34.9%Interest on delinquent taxes 1 361.40.10 192,316 192,316 44,805 108,578 56.5%188,545 188,545 224,004 36,719 113,478 60.2%210,000 197,154 33,387 93,478 47.4%Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 339,521 339,521 - 19,471 5.7%329,632 329,632 232,066 - 19,150 5.8%328,526 409,407 - 195,627 47.8%DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 250,000 - 146,897 58.8%250,000 250,000 500,000 352,075 54,039 314,772 63.0%250,000 330,761 1,127 4,907 1.5%Transfer in 1 397.00 3,000 3,000 750 25,572 852.4%8,000 8,000 21,798 750 3,904 48.8%3,000 42,992 750 7,982 18.6%Miscellaneous 1 50.1/369.81/369.9 27,784 27,784 1,199 6,296 22.7%13,631 13,631 111,997 789 6,936 50.9%11,900 43,811 544 3,759 8.6%Assessor 1 001-010-000 8,300 8,300 1,750 3,823 46.1%8,300 8,300 9,642 1,781 3,821 46.0%8,700 8,542 1,821 3,814 44.6%Auditor-Recording Fees 1 341.21.10 69,495 69,495 6,732 31,915 45.9%70,510 70,510 69,039 5,936 24,088 34.2%72,063 70,227 6,468 29,169 41.5%Auditor-M.V. License Fees 1341.48+/336.00.93 246,440 16,370 262,810 17,376 134,631 51.2%229,257 229,257 302,603 16,041 112,988 49.3%232,703 234,383 17,615 101,822 43.4%Auditor-Other Revenue 1 35,330 35,330 1,249 10,605 30.0%42,450 42,450 35,127 2,696 15,012 35.4%26,605 34,184 2,797 13,498 39.5%Elections 1 001-021-000 116,110 116,110 79,945 302,853 260.8%130,160 130,160 161,606 116 98,704 75.8%159,722 101,546 12,207 76,227 75.1%Clerk 1 001-020-000 149,591 149,591 6,102 55,032 36.8%152,506 152,506 149,436 19,753 64,151 42.1%170,768 181,580 19,156 74,688 41.1%County Administrator 1 001-059-000 438,600 438,600 - 4,000 0.9%4,260 (560) 3,700 4,260 - 4,260 115.1%4,260 4,260 - 4,260 100.0%Commissioners 1 001-060-000 8,000 8,000 717 3,389 42.4%8,000 8,000 7,843 688 2,814 35.2%8,000 8,522 825 3,612 42.4%Safety & Security 1 001-067-000 75,538 75,538 51,542 51,542 68.2%70,604 70,604 36,232 11,198 28,578 40.5%64,959 44,082 - 30,414 69.0%Community Services 1 001-068-000 4,155 4,155 11 1,956 47.1%4,005 4,005 3,987 29 1,982 49.5%6,900 4,180 34 1,310 31.3%District Court 1 001-080-000 644,505 644,505 18,228 154,874 24.0%636,823 (612) 636,211 682,644 32,186 182,939 28.8%603,032 674,579 47,567 199,411 29.6%Juvenile Service 1 001-110-000 279,284 279,284 41,050 125,121 44.8%298,727 (13,500) 285,227 243,744 17,067 91,237 32.0%259,676 288,710 32,392 120,120 41.6%Prosecuting Attorney 1 001-150-000 320,633 320,633 12,155 65,016 20.3%148,916 16,789 165,705 257,902 42,750 75,709 45.7%178,690 110,543 11,247 43,799 39.6%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 - 18,140 55.4%Sheriff 1 001-180-000 794,303 794,303 52,522 325,373 41.0%561,174 483,436 1,044,610 1,141,545 104,644 463,973 44.4%625,969 618,527 59,652 162,039 26.2% Superior Court 1 001-240-000 59,421 59,421 660 6,840 11.5%60,912 109 61,021 50,414 220 6,480 10.6%60,822 51,520 14,203 26,043 50.5% Non Departmental 1 001-270-000 35,568 35,568 90 36,324 102.1%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 16,370 21,351,254 1,562,332 9,372,879 43.9%19,664,588 2,168,638 21,833,226 22,268,272 1,653,414 9,771,247 44.8%19,975,604 20,890,820 1,552,803 8,612,059 41.2% * 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 1,043.33 23,132 0 1,577.72 6,116 0 295.09 10,868 OTHER FUNDS REVENUE REPORT 2020 3 year view May 5 6/5/2020 FUND Fund #Orig Budget Budget Amended BDGT May YTD YTD Orig Budget Budget Amended BDGT May YTD YTD ACTUAL May 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,488 11,886 15.3%80,480 80,480 2,453 10,105 12.6%76,912 2,429 10,872 14.1% Court Facilitator 106 4,500 4,500 80 1,100 24.4%4,100 4,100 320 1,960 47.8%4,820 300 2,020 41.9% Boating Safety 107 50,000 50,000 15,000 30,384 60.8%48,500 1,638 50,138 15,000 32,085 64.0%47,887 15,000 30,607 63.9% WSU Cooperative 108 532,762 (69,310) 463,452 73,506 208,982 45.1%416,215 52,707 468,922 56,217 171,278 36.5%556,121 98,797 297,649 53.5% Noxious Weed 109 217,717 (23,700) 194,017 14,532 104,035 53.6%141,217 119,599 260,816 17,878 102,064 39.1% 4-H After School 113 Moved to Fund 108 - 47,600 47,600 1,000 32,732 68.8%37,750 - 32,250 85.4% JeffComCap 119 119 206,640 206,640 17,220 86,100 41.7%204,000 204,000 17,000 85,000 41.7%264,695 22,058 110,290 41.7% Crime Victim's Svc 120 81,543 81,543 37,006 49,929 61.2%140,813 140,813 5,308 54,867 39.0%113,502 22,507 51,692 45.5% Grant Mgmt 123 150,000 150,000 13,250 51,297 34.2%150,000 150,000 2,969 48,346 32.2%101,793 10,542 61,479 60.4% Hotel-Motel 125 521,444 521,444 11,527 136,403 26.2%500,500 500,500 41,546 160,696 32.1%542,805 41,061 153,631 28.3% Jeff Co Public Health 127 4,994,011 4,994,011 707,039 2,409,373 48.2%4,422,082 229,547 4,651,629 479,460 2,129,375 45.8%4,606,955 486,799 1,889,033 41.0% Water Quality 128 1,307,279 1,307,279 105,154 496,334 38.0%1,163,949 1,163,949 120,186 482,110 41.4%969,155 58,131 417,003 43.0% 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 4,265 27,951 55.6%47,637 47,637 4,485 29,228 61.4%50,132 4,289 26,892 53.6% Chem Dep Mnt Hlth tx 131 553,433 553,433 42,970 231,401 41.8%527,003 527,003 50,581 227,282 43.1%573,509 48,179 213,767 37.3% Drug Fund 135 13,850 13,850 168 2,096 15.1%12,249 12,249 603 3,843 31.4%14,395 895 5,523 38.4% Law Library 140 16,081 16,081 400 7,844 48.8%10,927 10,927 781 3,787 34.7%9,915 818 4,245 42.8% Trial Court Imprvmnt 141 23,000 23,000 - 14,168 61.6%23,000 23,000 - 11,400 49.6%23,201 - 11,605 50.0% Community Develpmnt 143 1,657,637 76,000 1,733,637 228,868 648,581 37.4%1,731,920 80,930 1,812,850 260,797 678,123 37.4%1,476,187 195,890 599,761 40.6% Federal Forest Title III 147 21,000 21,000 75 17,777 - - 197 19,955 20,164 107 466 2.3% Jeff Co Affrdbl Hsg 148 45,131 45,131 9,078 30,471 67.5%48,000 48,000 4,510 18,168 37.9%310,493 23,056 99,338 32.0% Homeless Housing Fund 149 272,874 272,874 26,614 128,346 47.0%315,000 272,282 587,282 26,891 109,782 18.7% Treasurer's O & M 150 54,650 54,650 4,213 9,048 16.6%47,624 47,624 5,192 7,778 16.3%46,224 3,230 8,337 18.0% REET technology 151 13,816 13,816 912 5,276 38.2%15,690 15,690 1,326 5,529 35.2%16,175 1,432 6,320 39.1% Veteran's Relief 155 65,510 65,510 4,374 46,696 71.3%64,975 25,015 89,990 4,714 47,733 53.0%105,484 4,440 44,486 42.2% Park & Rec 174 684,549 684,549 141,055 286,040 41.8%669,649 669,649 148,398 310,888 46.4%674,760 142,424 304,154 45.1% County Park Imprvmnt 175 171,625 31,360 202,985 31,505 34,823 17.2%184,125 (24,000) 160,125 7,969 18,809 11.7%155,581 60,332 62,615 40.2% Post Harvest Timber Mgmt Rsv178 - - 6 55 50 50 18 91 181.0% County Roads 180 8,801,630 8,801,630 544,090 4,039,222 45.9%8,938,628 (6,707) 8,931,921 694,054 4,443,440 49.7%8,929,361 925,362 4,023,463 45.1%Facilities Mgmt *507 eff 7/1/2020183 1,169,335 1,169,335 98,681 523,924 44.8%1,065,393 1,065,393 89,133 473,817 44.5%1,121,480 90,086 478,208 42.6% County Fair 199 280,000 515 280,515 16,316 82,519 29.4%252,937 14,478 76,758 30.3% Total Special Revenue 21,873,206 14,350 21,887,556 2,134,077 9,639,543 44.0%21,535,774 792,078 22,327,852 2,075,302 9,802,791 43.9%21,235,218 2,258,166 9,022,464 45.1% OTHER FUNDS REVENUE REPORT 2019 3 year view FUND Orig Budget Amended BDGT May YTD YTD Orig Budget Amended BDGT May YTD YTD YTD May YTD YTD 2020 2020 2020 2020 %2019 2019 2019 2019 %2018 2018 2,018 % CAPITAL IMPROVEMENT Const/Renovation 301 363,826 363,826 - 48,732 13.4%518,500 518,500 - 197,264 38.0%110,679 2,000 5,617 0.6% Capital Improvement 302 1,156,313 1,000,000 2,156,313 1,075,991 1,402,461 65.0%1,072,125 1,072,125 111,002 399,150 37.2%1,264,506 128,185 421,120 39.2% Public Infrastructure 306 565,000 565,000 39,286 214,477 38.0%510,100 510,100 47,753 215,617 42.3%536,758 44,830 199,531 44.2% Conservation Futures 308 271,860 271,860 22,929 151,244 55.6%258,841 258,841 24,880 160,253 61.9%284,064 23,600 146,248 61.1% Total CAP IMP 2,356,999 1,000,000 3,356,999 1,138,206 1,816,913 54.1%2,359,566 - 2,359,566 183,635 972,283 41.2%2,196,007 198,615 772,515 28.0% ENTERPRISE Solid Waste 401 3,718,073 3,718,073 374,841 1,508,632 40.6%3,336,196 300,117 3,636,313 366,094 1,510,907 41.6%3,680,126 296,521 1,347,429 40.1% Solid Waste Post Clos 402 - - 18 214 - - 102 496 979 80 346 231.0% Solid Waste Eqpt Res 403 15,000 15,000 359 4,236 28.2%8,000 8,000 1,807 8,819 110.2%15,780 1,257 5,406 135.2% Yard Waste Educ Fnd 404 7,000 7,000 2 20 0.3%6,800 6,800 19 93 1.4%5,765 9 38 0.6% Tri Area Sewer 405 982,500 23,087 1,005,587 149,453 152,861 15.2%234,500 69,132 303,632 1,500 42,269 13.9%42,268 1,094 4,766 1.9% Total ENTERPRISE 4,722,573 23,087 4,745,660 524,673 1,665,962 35.1%3,585,496 369,249 3,954,745 369,521 1,562,584 39.5%3,744,918 298,961 1,357,985 37.5% INTERNAL SERVICE Equipment Rental 501 2,617,745 2,617,745 200,357 838,930 32.0%2,421,684 717,803 3,139,487 210,524 906,375 28.9%2,950,721 172,749 755,212 30.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 30,303 185,082 67.3%208,000 208,000 25,314 126,018 60.6%239,489 22,391 114,927 55.3% Information Services 506 1,968,639 1,076,937 3,045,576 108,907 1,027,446 33.7%1,901,855 295,210 2,197,065 7,986 917,176 41.7%2,004,180 6,333 994,029 45.6% Facilities Mgmt eff 7/1/2020 507 - - 1,065,393 1,065,393 89,133 473,817 44.5%1,121,480 90,086 478,208 42.6% Total INT SERV 5,011,384 1,076,937 6,088,321 339,566 2,051,458 33.7%4,746,539 1,013,013 5,759,552 243,824 1,949,570 33.8%5,221,821 201,473 1,864,167 36.9% Total 33,964,162 2,114,374 36,078,536 4,136,521 15,173,877 42.1%32,227,375 2,174,340 34,401,715 2,872,283 14,287,227 41.5%32,397,965 2,957,215 13,017,132 41.4% GENERAL FUND CASH BALANCE REPORT 5/6/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$ 8,452,851$ 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$ 7,105,615$ 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,392,138 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,392,138 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 n/a n/a * In 2019, Resolution 41-19 changed the reserve to 15% of the GF Total Spending and eliminated the Revenue Stabilization Reserve - changes with appropriations throughout year $- $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 5 6/5/2020 May 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 249,173 6.3%208,334 249,173 $40,839 120.42%$4,005,909 $679,300 May 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 295,191 267,758 8.4%280,693 267,758 -$12,935 114.77%$3,818,015 $491,406 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 88.72% 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 80.69% 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 68.02% 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 59.54% 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 52.68% 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 46.98% 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 42.91% 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 1,427,543 100.0%$3,326,609 $1,427,543 ytd 781,519 735,423 969,922 884,203 943,488 1,050,738 1,129,268 1,168,163 1,319,406 1,427,543 1,243,808 1,427,543 ytd change 0.47%-5.90%31.89%-8.84%6.70%11.37%7.47%3.44%12.95%8.20%14.77%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 69,887 6.4%66,580 69,887 274,914 319,060 16.1% May 51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 8.5%88,710 75,138 369,403 342,896 -7.2% 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 - 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 - 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 - 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 - 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 - 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 - 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 - TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 403,845 100.0%1,045,244 403,845 4,371,853 1,831,388 ytd 0 242,783 287,081 271,252 290,659 337,545 354,212 372,467 398,603 403,845 396,401 $403,845 1,640,209 $1,831,388 11.7% ytd change 18.25%-5.51%7.15%16.13%4.94%5.15%7.02%1.31%1.88%over (under) ytd expected annual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42% 1.88%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 5/7/2020 Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 General & Optional YTD 876,664 967,738 952,340 959,645 879,743 777,837 781,519 735,423 969,922 884,203 943,488 1,050,738 1,129,268 1,168,163 1,319,406 1,427,543 Special Purpose YTD - - - - - - - 242,783 287,081 271,252 290,659 337,545 354,212 372,467 398,603 403,845 G&O and SP Sales Tax YTD 876,664 967,738 952,340 959,645 879,743 777,837 781,519 978,206 1,257,003 1,155,455 1,234,147 1,388,283 1,483,480 1,540,629 1,718,009 1,831,388 Full Year Total: 2020 is YTD Actua 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,665,900 4,563,032 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2,000,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 5,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Sales Tax Per Year YTD and Full Year General & Optional YTD Special Purpose YTD G&O and SP Sales Tax YTD Full Year Total: 2020 is YTD Actual & 2020 Budget 5 May 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation Recent 2020 2020 % 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 78,860 86,955 80,670 78,860 -2.2%-12.0% May 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 75,991 114,808 106,509 75,991 -28.7%-31.5% 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 $402,461 1,246,409$ 1,156,313$ 402,461$ -65%-67.7% YTD 206,222 193,477 201,188 229,439 385,057 374,056 407,461 421,120 399,149 402,461 400,446$ 371,500$ 402,461$ 8%0.8% YTD change 10.20%-6.18%3.99%14.04%67.83%-2.86%8.93%3.35%-5.22%0.83% Annual % chg 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 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 Apr 2020 8 sales>$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 5/7/2020 $- $50,000 $100,000 $150,000 $200,000 $250,000 2020 REET RECEIPTS 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 5 May 6/8/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$ 29,140$ 21,502$ 21,566$ 29,140$ 35.1%27.6% May 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 41,061$ 41,546$ 11,527$ 39,503$ 39,620$ 11,527$ -70.9%-72.3% 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$ 136,403$ 519,906$ 521,444$ 136,403$ YTD 85,378$ 74,596$ 87,780$ 88,224$ 106,406$ 132,096$ 156,219$ 153,631$ 160,696$ 136,403$ 150,660$ 151,106$ 136,403$ -9.7%-15.1% YTD Change 15.70%-12.63%17.67%0.51%20.61%24.14%18.26%-1.66%4.60%-15.12% Annual % Change 0.24%-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 HOTEL-MOTEL REVENUE *** 2020 is YTD Actual plus budgeted remainder of year 1998 1999 2000 2001 2002 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 January 6,047 15,702 14,839 14,173 15,054 23,014 13,009 13,236 9,908 15,742 16,089 10,732 11,507 12,045 8,863 13,575 17,051 18,473 19,394 23,177 29,854 32,023 February 4,987 9,370 14,953 15,988 22,474 19,563 21,042 19,678 22,155 29,461 27,998 21,729 25,532 23,188 38,274 30,356 36,141 51,077 53,093 46,226 41,186 34,092 March 6,502 9,973 9,552 12,547 13,694 9,311 11,586 12,354 11,250 10,723 22,623 9,838 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 April 5,272 8,642 13,169 13,934 13,220 16,704 8,587 14,078 14,334 11,702 11,344 11,934 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 May 7,063 15,466 15,349 17,692 15,112 16,585 11,482 19,604 19,879 20,360 19,646 19,561 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 June 8,054 11,729 21,021 18,464 13,443 18,218 10,145 18,640 18,954 18,853 19,205 19,650 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 35,308 July 12,517 17,222 20,739 21,245 13,618 16,276 27,584 19,451 20,546 23,514 20,155 14,326 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 41,442 August 15,839 30,016 31,288 25,444 32,509 30,719 30,585 34,443 36,034 37,302 35,178 36,076 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 64,345 September 14,322 32,758 35,138 37,063 27,842 30,977 30,966 34,701 39,236 41,768 41,757 40,208 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 67,004 October 19,863 33,671 37,802 35,994 21,948 15,635 36,840 30,420 40,711 42,480 43,012 46,548 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 61,258 November 32,288 38,816 39,069 35,492 35,316 44,483 46,577 49,067 46,989 44,786 44,351 43,285 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 63,980December18,901 20,782 21,451 22,776 12,733 33,992 18,623 20,872 21,914 21,753 19,873 18,741 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 37,001 Hotel-Motel YTD 29,871 59,153 67,862 74,334 79,554 85,177 65,706 78,950 77,526 87,988 97,700 73,794 85,378 74,596 87,780 88,224 106,406 132,096 156,219 153,631 160,696 136,403 Full Year Total: 2020 is YTD Actual & 2020 Budget 151,655 244,147 274,370 270,812 236,963 275,477 267,026 286,544 301,910 318,444 321,231 292,628 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 506,741 YTD Change 98.03%14.72%9.54%7.02%7.07%-22.86%20.16%-1.80%13.49%11.04%-24.47%15.70%-12.63%17.67%0.51%20.61%24.14%18.26%-1.66%4.60%-15.12% Annual % Change 60.99%12.38%-1.30%-12.50%16.25%-3.07%7.31%5.36%5.48%0.88%-8.90%0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%-12.60% 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 1998199920002001200220042005200620072008200920102011201220132014201520162017201820192020Hotel-Motel May 2020 YTD 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 1998199920002001200220042005200620072008200920102011201220132014201520162017201820192020Hotel-Motel Per Year: May YTD and Full Year Hotel-Motel YTD Full Year Total: 2020 is YTD Actual & 2020 Budget