Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020-08_August_RevenueReports
JEFFERSON 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 Sabrina Hathaway – Chief Deputy (360) 385-9352 Page | 1 JEFFERSON COUNTY BUDGET COMMITTEE Treasurer’s Revenue Report August 2020 Revenue General Fund at $14,230,493 – 64.7% of the 2020 budget year to date which is 2.1% less than last year. Property tax collections are on track. The second sheet shows general fund revenue charts showing 2015-2020 year to date detail and percentage of actual full year collections. 2020 is shown as a percentage of our adopted budget. Other Funds at $22,543,708– 61.3% of 2020 budget year to date. General Fund Cash Balance - $6,631,983 at the end of August which includes the $3.526 million budgeted reserve. This is slightly less than the amount for this time last year. General Sales Tax Receipts - $442,796 which includes $94,459 for Special Purpose in August 2020. General & Optional Sales tax is $7,000 less than August 2019 and 6.5% over budget for the month. It’s holding at 11.63% over budget for 2020 YTD. Special Purpose was $13,000 less than last year and 91% of budget for the month. Cumulatively they’re 2.15% over budget for the month and 8.5% over for YTD. The charts show the revenue per month back to 2005. Sales Tax Data: This chart is new and shows the sales tax composition by category. Total taxable sales in June was $108.9 million, and the amount collected for General & Optional was 2% less than this period last year. 2020 YTD is 4% over 2019 YTD collections. REET Receipts - Fund 302 - $162,690.68 in August which is 41% over budget and 24% over this month last year. Year to Date REET Collections are 25.6% over budget and 20% over 2019 YTD. One sale in Port Ludlow of a home on 3 acres sold at 1.25 million. There were 23 sales in unincorporated Jefferson County in August with selling prices between $500,000 and $1 million. Hotel/Motel Lodging Tax – Fund 125 - $40,530 in August with $202,811 YTD. This puts it 40% under budget for the month and less than half what was collected this month last year. Year to date is 30.6% under budget and 37.3% less than 2019 YTD. 2020 8 August Jefferson County Treasurer 10-Sep-2020 General Fund REVENUE NAME BARS BUDGET QTRLY AMENDED AUG Y-T-D Y-T-D BUDGET Quarterly AMENDED ACTUAL AUG Y-T-D Y-T-D BUDGET ACTUAL AUG Y-T-D Y-T-D *2020 Approp Budget 2020 2020 2020 %2019 Approp Budget 2019 2019 2019 2019 %2018 2018 2018 2018 % of Actual Property Tax 1 311.10 8,290,037 8,290,037 59,634 4,801,218 57.9%8,021,323 8,021,323 7,992,860 53,574 4,658,973 58.1%7,850,027 7,805,908 49,880 4,509,061 57.8% Diverted Road Prop Tax 1 311.20 720,000 720,000 5,687 427,054 59.3%720,000 720,000 720,000 5,191 421,964 58.6%720,000 720,000 4,568 417,288 58.0% Sales Tax 1 313.11 3,326,609 3,326,609 348,337 2,342,991 70.4%3,204,826 192,869 3,397,695 3,601,761 355,294 2,246,361 66.1%3,040,000 3,195,259 309,575 1,988,733 62.2% special purpose 313.15 1,045,244 1,045,244 94,459 653,272 62.5%1,006,979 55,384 1,062,363 1,064,119 107,514 673,342 63.4%955,428 999,945 97,261 625,985 62.6% Local Criminal Justice 1 313.71 422,650 422,650 39,580 272,218 64.4%407,177 22,395 429,572 442,239 44,629 279,742 65.1%380,070 417,655 40,342 261,338 62.6% Leasehold Excise Tax 3 317.20 66,801 66,801 21,170 59,895 89.7%66,801 66,801 75,500 19,167 56,297 84.3%62,000 65,642 17,077 48,627 74.1% Private Harvest Tax - TAV 2 317.40.10/.20 339,599 339,599 71,714 209,039 61.6%339,599 339,599 363,246 89,840 349,118 102.8%335,000 537,635 69,678 379,277 70.5% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 1,015,150 1,015,150 - 1,572,825 154.9%1,015,136 537,328 1,552,464 1,553,455 - 1,537,328 99.0%1,867,988 1,850,941 - 1,833,818 99.1% P.U.D. Privilege Tax 4 335.00.91 386,555 386,555 - 398,063 103.0%375,296 375,296 385,397 - 385,397 102.7%323,420 393,491 - 393,491 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 451,770 451,770 - 385,846 85.4%438,612 438,612 336,086 - 333,709 76.1%463,500 425,438 - 320,837 75.4% Marijuana Enforcement/Excise 6 336.06.41/42 52,548 52,548 - 24,461 46.5%51,017 51,017 170,903 - 24,224 47.5%24,720 63,962 - 39,588 61.9% Liquor Excise Tax 8 336.06.94 48,267 48,267 - 43,836 90.8%47,321 47,321 51,439 - 37,729 79.7%41,536 47,254 - 34,380 72.8% Liquor Profit 6 336.06.95 90,650 90,650 - 41,687 46.0%88,873 88,873 83,623 - 41,936 47.2%90,203 84,066 - 42,130 50.1% Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 35,830 495 19,160 53.5%35,000 35,000 43,596 2,469 25,660 73.3%16,290 42,753 3,859 33,256 77.8% Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 87,175 8,428 48,410 55.5%87,175 87,175 85,234 9,518 55,252 63.4%80,000 83,290 8,606 55,584 66.7% Penalties on delinquent taxes 1 359.40.10/.20 119,757 119,757 6,921 91,961 76.8%117,409 117,409 113,976 6,195 81,243 69.2%133,332 98,079 4,482 72,844 74.3% Investment Income 1 361.11 713,000 713,000 105,331 345,277 48.4%349,847 600,000 949,847 1,028,831 78,189 837,087 88.1%230,000 534,468 38,157 331,255 62.0% Interest on delinquent taxes 1 361.40.10 192,316 192,316 12,196 175,967 91.5%188,545 188,545 224,004 21,394 156,648 83.1%210,000 197,154 6,535 136,785 69.4% Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 339,521 339,521 - 29,207 8.6%329,632 329,632 232,066 - 28,985 8.8%328,526 409,407 - 206,731 50.5% DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 250,000 11,382 214,087 85.6%250,000 250,000 500,000 352,075 1,443 330,417 66.1%250,000 330,761 36,517 44,717 13.5% Transfer in 1 397.00 3,000 24,074 27,074 750 26,322 97.2%8,000 8,000 21,798 750 21,048 263.1%3,000 42,992 750 19,944 46.4% Miscellaneous 1341.43/341.81/361.40.00/361.40.30/362.50.1/369.81/369.9 27,784 27,784 1,254 9,103 32.8%13,631 13,631 111,997 1,864 11,503 84.4%11,900 43,811 6,528 11,969 27.3% Assessor 1 001-010-000 8,300 8,300 1,884 5,729 69.0%8,300 8,300 9,642 1,828 5,732 69.1%8,700 8,542 1,810 5,840 68.4% Auditor-Recording Fees 1 341.21.10 69,495 69,495 7,905 58,041 83.5%70,510 70,510 69,039 6,452 42,312 60.0%72,063 70,227 6,424 47,848 68.1% Auditor-M.V. License Fees 1341.48+/336.00.93 246,440 16,370 262,810 54,820 220,768 84.0%229,257 229,257 302,603 63,379 210,515 91.8%232,703 234,383 52,102 188,578 80.5% Auditor-Other Revenue 1 35,330 35,330 1,817 15,602 44.2%42,450 42,450 35,127 3,404 23,933 56.4%26,605 34,184 3,417 23,743 69.5% Elections 1 001-021-000 116,110 116,110 0 309,648 266.7%130,160 130,160 161,606 - 103,962 79.9%159,722 101,546 - 93,388 92.0% Clerk 1 001-020-000 149,591 149,591 11,420 89,390 59.8%152,506 152,506 149,436 15,583 100,499 65.9%170,768 181,580 16,167 120,160 66.2% County Administrator 1 001-059-000 438,600 438,600 0 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 904 6,202 77.5%8,000 8,000 7,843 727 4,916 61.5%8,000 8,522 805 5,902 69.3% Safety & Security 1 001-067-000 75,538 75,538 0 67,399 89.2%70,604 70,604 36,232 - 28,578 40.5%64,959 44,082 11,132 41,545 94.2% Community Services 1 001-068-000 4,155 4,155 40 2,951 71.0%4,005 4,005 3,987 (15,923) 3,067 76.6%6,900 4,180 1,821 3,228 77.2% District Court 1 001-080-000 644,505 644,505 31,287 316,798 49.2%636,823 (612) 636,211 682,644 40,182 401,129 63.0%603,032 674,579 94,284 491,420 72.8% Juvenile Service 1 001-110-000 279,284 279,284 68,089 219,152 78.5%298,727 (13,500) 285,227 243,744 31,613 165,873 58.2%259,676 288,710 27,865 183,834 63.7% Prosecuting Attorney 1 001-150-000 320,633 320,633 12,517 101,030 31.5%148,916 16,789 165,705 257,902 25,005 164,788 99.4%178,690 110,543 11,247 88,534 80.1% Coroner 1 001-151-000 25,348 25,348 6,000 13,958 55.1%25,348 25,348 18,324 6,400 18,324 72.3%25,348 32,723 14,583 32,723 100.0% Sheriff 1 001-180-000 794,303 154,500 948,803 53,427 538,089 56.7%561,174 483,436 1,044,610 1,141,545 30,039 676,377 64.7%625,969 618,527 83,481 386,593 62.5% Superior Court 1 001-240-000 59,421 59,421 238 7,738 13.0%60,912 109 61,021 50,414 220 7,940 13.0%60,822 51,520 11,721 37,764 73.3% Non Departmental 1 001-270-000 35,568 481,500 517,068 23,127 62,100 12.0%50,437 25,000 75,437 39,722 1,280 35,852 47.5%50,447 32,802 - 32,802 100.0% TOTAL CURRENT EXPENSE REVENUE 21,334,884 676,444 22,011,328 1,060,814 14,230,493 64.7%19,664,588 2,168,638 21,833,226 22,268,272 1,007,220 14,592,019 66.8%19,975,604 20,890,820 1,030,674 13,595,799 65.1% * 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 excluded 388/89 0 531 27,645 0 15,471 29,772 0 (127,834)(112,461) August 2020 GENERAL FUND REVENUE 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Property Tax 3,966,338 4,073,940 4,016,093 4,098,054 4,190,900 4,261,692 4,350,081 4,423,830 4,509,061 4,658,973 4,801,218 Diverted Road Prop Tax 409,369 412,733 414,709 415,866 418,550 427,668 420,216 420,267 417,288 421,964 427,054 Sales Tax 1,232,147 1,289,596 1,217,815 1,545,280 1,453,480 1,582,977 1,727,952 1,868,018 1,988,733 2,246,361 2,342,991 special purpose 0 160,996 395,184 461,207 442,686 482,904 560,560 582,256 625,985 673,342 653,272 Local Criminal Justice 166,053 173,988 166,089 192,380 184,517 200,118 232,864 241,615 261,338 279,742 272,218 Leasehold Excise Tax 38,163 42,042 40,542 44,375 48,417 44,462 44,666 50,748 48,627 56,297 59,895 Private Harvest Tax 90,580 218,466 254,250 324,269 358,822 366,366 252,332 311,003 379,277 349,118 209,039 P.I.L.T. (incl DNR)397,957 486,246 641,300 1,283,164 1,330,422 1,253,823 1,422,312 1,390,772 1,833,818 1,537,328 1,572,825 P.U.D. Privilege Tax 50,666 16,788 31,380 32,775 225,457 370,446 318,107 314,148 393,491 385,397 398,063 Crim Just Hi Crime/DUI/Asst 250,761 241,639 248,813 278,952 347,828 359,931 367,324 327,664 320,837 333,709 385,846 Marijuana Enforcement/Excise 0 0 0 0 0 - 25,568 11,354 39,588 24,224 24,461 Liquor Excise Tax 27,662 28,998 31,873 0 9,683 11,894 30,739 32,161 34,380 37,729 43,836 Liquor Profit 36,094 35,925 53,297 42,426 42,354 42,582 42,439 42,310 42,130 41,936 41,687 Treasurer Invest & Other Fees 4,408 3,794 2,992 2,749 1,703 2,604 6,858 24,461 33,256 25,660 19,160 Treas. Collection Fees (REET)18,243 18,801 21,018 25,340 28,366 46,951 57,423 58,015 55,584 55,252 48,410 Penalties on delinquent taxes 54,083 87,856 73,083 81,252 91,226 76,435 78,457 65,994 72,844 81,243 91,961 Investment Income 136,584 77,490 41,991 13,344 16,891 34,928 611,048 270,868 331,255 837,087 345,277 Interest on delinquent taxes 93,477 139,956 134,227 143,990 160,785 147,428 152,594 132,572 136,785 156,648 175,967 Interfund Chg Svc-Cost Alloc 0 0 0 39,051 0 26,255 26,537 30,577 206,731 28,985 29,207 DNR Timber 53,523 502,789 219,885 68,321 253,529 365,227 257,543 94,176 44,717 330,417 214,087 Transfer in 0 0 0 0 0 5,000 22,437 20,296 19,944 21,048 26,322 Miscellaneous 227,634 153,274 22,097 39,813 25,216 25,749 15,993 5,024 11,969 11,503 9,103 Assessor 1,185 826 2,936 228,791 10,495 619 6,135 8,129 5,840 5,732 5,729 Auditor-Recording Fees 41,875 42,274 46,802 53,419 37,227 47,780 48,209 48,264 47,848 42,312 58,041 Auditor-M.V. License Fees 109,833 108,200 108,527 113,839 113,565 112,105 185,420 160,401 188,578 210,515 220,768 Auditor-Other Revenue 23,005 23,095 21,682 23,733 23,727 69,191 20,417 20,348 23,743 23,933 15,602 Elections 112,964 61,374 57,758 46,785 72,862 56,721 151,935 55,987 93,388 103,962 309,648 Clerk 132,796 130,203 137,645 139,394 140,665 142,750 131,291 120,444 120,160 100,499 89,390 County Administrator 0 0 0 0 0 - - - 4,260 4,260 4,000 Commissioners 6,515 4,970 10,075 6,745 4,972 5,773 5,670 5,772 5,902 4,916 6,202 Safety & Security 54,795 28,415 34,015 38,633 28,735 30,334 52,836 47,355 41,545 28,578 67,399 Community Services 0 4,445 914 4,261 3,147 3,292 2,857 3,857 3,228 3,067 2,951 District Court 359,812 436,902 410,676 408,875 396,287 460,147 450,185 432,362 491,420 401,129 316,798 Juvenile Service 166,083 171,077 133,209 216,760 171,625 162,240 169,014 183,907 183,834 165,873 219,152 Prosecuting Attorney 199,704 196,158 134,120 113,151 111,207 167,110 93,198 118,699 88,534 164,788 101,030 Coroner 4,640 14,080 6,380 11,032 3,480 11,140 8,340 24,610 32,723 18,324 13,958 Sheriff 650,540 630,631 417,419 448,074 340,739 372,982 417,361 436,531 386,593 676,377 538,089 Superior Court 19,976 5,329 3,000 4,844 3,000 4,532 20,732 67,739 37,764 7,940 7,738 Non Departmental 0 0 0 0 0 - 10 10 32,802 35,852 62,100 TOTAL CURRENT EXPENSE 9,137,465 10,023,296 9,551,796 10,990,944 11,092,564 11,782,155 12,787,660 12,452,543 13,595,799 14,592,019 14,230,493 TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET 15198876 16349133 15531592 16964139 17374434.53 18,950,211 19,247,758 19,181,590 20,890,820 19,975,604 22,011,328 YTD % of Full Year Actual/2020 Budget 60.1%61.3%61.5%64.8%63.8%62.2%66.4%64.9%65.1%73.0%64.7% 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 GENERAL FUND REVENUE YTD Non Departmental Superior Court Sheriff Coroner Prosecuting Attorney Juvenile Service District Court Community Services Safety & Security Commissioners County Administrator Clerk Elections Auditor-Other Revenue Auditor-M.V. License Fees Auditor-Recording Fees Assessor Miscellaneous Transfer in DNR Timber Interfund Chg Svc-Cost Alloc Interest on delinquent taxes Investment Income Penalties on delinquent taxes Treas. Collection Fees (REET) Treasurer Invest & OtherFees Liquor Profit Liquor Excise Tax Marijuana Enforcement/Excise Crim Just Hi Crime/DUI/Asst P.U.D. Privilege Tax P.I.L.T. (incl DNR) Private Harvest Tax Leasehold Excise Tax Local Criminal Justice special purpose Sales Tax Diverted Road Prop Tax Property Tax 60.1%61.3%61.5%64.8%63.8%62.2% 66.4%64.9%65.1% 73.0% 64.7% 0.0% 20.0% 40.0% 60.0% 80.0% 100.0% 120.0% 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 GENERAL FUND YTD AND FULL YEAR ACTUAL/2020 BUDGET TOTAL CURRENT EXPENSE TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET YTD % of Full Year Actual/2020 Budget OTHER FUNDS REVENUE REPORT 2020 3 year view August 8 9/10/2020 FUND Fund #Orig Budget Budget Amended BDGT Aug YTD YTD Orig Budget Budget Amended BDGT Aug YTD YTD ACTUAL Aug YTD YTD 2020 Amendment 2020 2020 2020 %2019 Amendment 2019 2019 2019 %2019 2018 2018 % SPECIAL REVENUE Elections CARES Act 103 - 153,422 153,422 10 153,462 n/a HAVA 3 Grant 104 - 123,419 123,419 9 123,428 n/a Auditor's O & M 105 77,900 77,900 3,107 73,431 94.3%80,480 80,480 2,551 62,080 77.1%76,912 2,810 67,388 87.6% Court Facilitator 106 4,500 4,500 300 1,840 40.9%4,100 4,100 280 3,220 78.5%4,820 420 3,360 69.7% Boating Safety 107 50,000 50,000 - 30,384 60.8%48,500 1,638 50,138 - 50,138 100.0%47,887 16,844 47,451 99.1% WSU Cooperative 108 532,762 (69,310) 463,452 120,439 358,427 77.3%416,215 52,707 468,922 113,718 288,776 61.6%556,121 3,142 336,192 60.5% Noxious Weed 109 217,717 (23,700) 194,017 1,233 109,305 56.3%141,217 119,599 260,816 5,056 109,777 42.1% 4-H After School 113 Moved to Fund 108 - 47,600 47,600 1,500 62,700 131.7%37,750 - 37,750 100.0% JeffComCap 119 119 206,640 206,640 17,220 137,760 66.7%204,000 204,000 17,000 136,000 66.7%264,695 22,058 176,463 66.7% Crime Victim's Svc 120 81,543 81,543 2,211 85,768 105.2%140,813 140,813 3,523 93,928 66.7%113,502 2,109 61,365 54.1% Grant Mgmt 123 150,000 132,517 282,517 - 64,749 22.9%150,000 150,000 31,505 79,852 53.2%101,793 10,740 78,723 77.3% Hotel-Motel 125 521,444 521,444 40,530 201,749 38.7%500,500 500,500 70,516 323,259 64.6%542,805 64,934 299,567 55.2% Jeff Co Public Health 127 4,994,011 4,994,011 551,043 3,630,113 72.7%4,422,082 229,547 4,651,629 468,256 3,318,335 71.3%4,606,955 490,506 3,294,691 71.5% Water Quality 128 1,307,279 1,307,279 48,970 726,956 55.6%1,163,949 1,163,949 82,768 654,109 56.2%969,155 88,030 680,908 70.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 887 30,255 60.2%47,637 47,637 887 30,734 64.5%50,132 1,191 28,736 57.3% Chem Dep Mnt Hlth tx 131 553,433 553,433 54,156 373,198 67.4%527,003 527,003 61,123 389,476 73.9%573,509 55,342 359,072 62.6% Drug Fund 135 13,850 13,850 346 5,378 38.8%12,249 12,249 162 4,675 38.2%14,395 1,581 9,571 66.5% Law Library 140 16,081 16,081 679 9,915 61.7%10,927 10,927 719 5,979 54.7%9,915 866 6,661 67.2% Trial Court Imprvmnt 141 23,000 23,000 7,084 21,252 92.4%23,000 23,000 - 17,103 74.4%23,201 - 17,403 75.0% Community Develpmnt 143 1,657,637 76,000 1,733,637 239,137 1,122,413 64.7%1,731,920 80,930 1,812,850 268,920 1,142,589 63.0%1,476,187 227,811 1,002,890 67.9% Federal Forest Title III 147 21,000 21,000 (319) 17,904 - - 235 20,655 20,164 129 19,497 96.7% Jeff Co Affrdbl Hsg 148 45,131 103,780 148,911 11,038 63,130 42.4%48,000 48,000 4,640 31,638 65.9%310,493 34,764 194,643 62.7% Homeless Housing Fund 149 272,874 19,234 292,108 32,366 231,534 79.3%315,000 272,282 587,282 27,964 191,047 32.5% Treasurer's O & M 150 54,650 54,650 10 14,233 26.0%47,624 47,624 7,446 22,766 47.8%46,224 2,648 25,022 54.1% REET technology 151 13,816 13,816 1,549 9,289 67.2%15,690 15,690 1,554 9,930 63.3%16,175 1,574 10,938 67.6% Veteran's Relief 155 65,510 65,510 668 49,092 74.9%64,975 25,015 89,990 1,063 49,780 55.3%105,484 3,034 48,399 45.9% Park & Rec 174 684,549 (9,023) 675,526 138,560 426,279 63.1%669,649 669,649 144,623 470,338 70.2%674,760 142,726 467,192 69.2% County Park Imprvmnt 175 171,625 31,360 202,985 23,772 80,065 39.4%184,125 (24,000) 160,125 16,329 150,808 94.2%155,581 16,892 129,244 83.1% Post Harvest Timber Mgmt Rsv178 - - (22) 63 50 50 19 146 292.5% County Roads 180 8,801,630 409,379 9,211,009 639,351 5,258,768 57.1%8,938,628 (6,707) 8,931,921 662,073 5,726,647 64.1%8,929,361 998,414 5,559,568 62.3% Facilities Mgmt *507 eff 7/1/2020183 1,169,335 1,169,335 100,717 820,353 70.2%1,065,393 1,065,393 105,577 748,621 70.3%1,121,480 97,825 760,103 67.8% Total Special Revenue 21,873,206 670,237 22,543,443 2,035,031 13,953,606 61.9%21,535,774 792,078 22,327,852 2,180,797 14,418,803 64.6%21,235,218 2,286,388 13,917,428 69.5% FUND Orig Budget Amended BDGT Aug YTD YTD Orig Budget Amended BDGT Aug YTD YTD YTD Aug YTD YTD 2020 2020 2020 2020 %2019 2019 2019 2019 %2018 2018 2,018 % CAPITAL IMPROVEMENT Const/Renovation 301 363,826 363,826 8,000 58,625 16.1%518,500 518,500 24,059 249,627 48.1%110,679 - 16,117 1.6% Capital Improvement 302 1,156,313 1,000,000 2,156,313 162,691 1,931,527 89.6%1,072,125 1,072,125 130,942 771,767 72.0%1,264,506 131,097 808,495 75.4% Public Infrastructure 306 565,000 565,000 49,524 343,981 60.9%510,100 510,100 57,458 363,646 71.3%536,758 51,745 335,847 74.4% Conservation Futures 308 271,860 271,860 2,859 164,118 60.4%258,841 258,841 6,122 172,443 66.6%284,064 14,374 166,078 69.4% Total CAP IMP 2,356,999 1,000,000 3,356,999 223,073 2,498,252 74.4%2,359,566 - 2,359,566 218,582 1,557,483 66.0%2,196,007 197,216 1,326,536 48.0% OTHER FUNDS REVENUE REPORT 2019 3 year view ENTERPRISE Solid Waste 401 3,718,073 3,718,073 334,787 2,539,586 68.3%3,336,196 300,117 3,636,313 395,571 2,590,068 71.2%3,680,126 385,616 2,404,280 71.6% Solid Waste Post Clos 402 - - 9 248 - - 94 789 979 90 607 404.7% Solid Waste Eqpt Res 403 15,000 15,000 184 4,903 32.7%8,000 8,000 1,662 14,039 175.5%15,780 1,424 9,509 237.7% Yard Waste Educ Fnd 404 7,000 7,000 (8) 23 0.3%6,800 6,800 19 150 2.2%5,765 11 69 1.2% Tri Area Sewer 405 982,500 23,087 1,005,587 (1,635) 153,459 15.3%234,500 69,132 303,632 154,443 199,525 65.7%42,268 1,150 8,106 3.2% Total ENTERPRISE 4,722,573 23,087 4,745,660 333,337 2,698,218 56.9%3,585,496 369,249 3,954,745 551,788 2,804,571 70.9%3,744,918 388,291 2,422,571 66.9% INTERNAL SERVICE Equipment Rental 501 2,617,745 18,883 2,636,628 393,682 1,610,536 61.1%2,421,684 717,803 3,139,487 620,303 1,914,215 61.0%2,950,721 237,920 1,383,641 56.4% Risk Management 502 150,000 150,000 - 529 0.4%215,000 215,000 - 0 0.0%27,431 26,672 26,672 12.4% Benefit Reserve 505 275,000 275,000 21,138 250,765 91.2%208,000 208,000 21,436 195,313 93.9%239,489 19,044 180,189 86.6% Information Services 506 1,968,639 1,076,937 3,045,576 130,096 1,531,802 50.3%1,901,855 295,210 2,197,065 344,224 1,367,494 62.2%2,004,180 7,656 1,410,230 64.7% Total INT SERV 5,011,384 1,095,820 6,107,204 544,915 3,393,632 55.6%4,746,539 1,013,013 5,759,552 985,963 3,477,021 60.4%5,221,821 291,291 3,000,733 59.4% Total 33,964,162 2,789,144 36,753,306 3,136,357 22,543,708 61.3%32,227,375 2,174,340 34,401,715 3,937,130 22,257,877 64.7%32,397,965 3,163,186 20,667,268 65.7% GENERAL FUND CASH BALANCE REPORT 9/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$ 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$ 8,074,825$ 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$ 7,785,971$ 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$ 6,631,983$ 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,526,713 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,526,713 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 8 August 9/2/2020 2020 General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 Revenue Cumulative Cumulative Year End3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/UnderJanuary154,373 180,283 156,597 207,318 152,937 133,849 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,273February224,687 244,043 249,049 206,809 219,448 215,617 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,975March142,119 161,270 157,709 170,679 177,252 122,153 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,807 April 156,731 170,147 181,390 162,253 148,592 131,100 127,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,300May198,754 211,995 207,595 212,586 181,514 175,118 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,406June 164,380 165,275 175,802 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 263,069 243,568 7.4%247,577 243,568 -$4,009 107.94%$3,590,720 $264,111July187,091 235,150 199,236 174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 308,592 323,542 8.3%277,705 323,542 $45,838 108.24%$3,600,762 $274,153 August 220,873 241,022 250,665 244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 355,294 348,337 9.9%329,733 348,337 $18,604 106.57%$3,545,250 $218,641 September 211,602 211,286 200,636 213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 319,609 9.0%298,735 - -$298,735 82.49% October 213,751 244,393 214,468 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 306,832 334,704 9.4%312,531 - -$312,531 62.43% November 253,367 234,710 263,159 239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 311,101 363,975 9.9%328,431 - -$328,431 43.43% December 183,910 170,134 197,603 197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 280,843 337,112 8.7%288,089 - -$288,089 22.36% TTL 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,601,761 2,342,991 100.0%$3,326,609 $2,342,991ytd 1,449,008 1,609,185 1,578,043 1,546,794 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 2,246,361 2,342,991 2,098,823 2,342,991 ytd change 11.05%-1.94%-1.98%-8.72%-12.73%4.66%-5.57%26.88%-5.94%8.91%9.16%8.11%6.46%12.95%4.30%11.63%over (under) ytd expected annual % chg.6.84%-0.64%-1.77%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09%12.72% Special Purp./Public Safety Tax Cumulative Cumulative Year End Actual 3 yr avg.Projection Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection 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 $11,695 116.01%$1,212,562 $167,318 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 $2,973 103.03%$1,076,892 $31,648March40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 6.7%69,846 72,888 $3,042 104.35%$1,090,764 $45,520April43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 6.4%66,580 69,887 $3,306 104.97%$1,097,151 $51,907May51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 8.5%88,710 75,138 -$13,572 84.70%$885,324 -$159,920 June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 7.3%76,724 68,693 -$8,031 89.53%$935,839 -$109,405July55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 86,275 8.2%85,977 86,275 $298 100.35%$1,048,866 $3,622August59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 94,459 9.9%103,727 94,459 -$9,268 91.07%$951,853 -$93,391September55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 9.1%94,867 - -$94,867 0.00% October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 9.3%97,103 - -$97,103 0.00% November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 9.9%103,507 - -$103,507 0.00% December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 8.3%86,938 - -$86,938 0.00% TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 653,272 100.0%1,045,244 653,272 ytd 160,996 395,185 461,506 442,685 482,904 560,560 582,256 625,985 673,362 653,272 662,829 $653,272 ytd change 16.78%-4.08%9.09%16.08%3.87%7.51%7.57%-2.98%-1.44%over (under) ytd expectedannual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42% Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules. 3 yr avg.Projection Actual Over/Under % of projection Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under General & Optional YTD1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,450,592 1,613,000 2,006,718 1,896,164 2,065,881 2,288,511 2,450,274 2,614,718 2,919,723 2,996,263 #VALUE!2,098,823 2,996,263 - - - Special Purpose YTD - - - - - - 160,996 395,185 461,506 442,685 482,904 560,560 582,256 625,985 673,362 653,272 662,829 653,272 - - - G&O and SP Sales Tax YTD1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,611,588 2,008,185 2,468,224 2,338,850 2,548,785 2,849,071 3,032,530 3,240,703 3,593,085 3,649,535 #VALUE!2,761,652 3,649,535 - - - Full Year Total Actual w/ 2020 Budget2,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,371,853 2,996,263 4,371,853 - - MONTHLY SALES TAX GENERAL & OPTIONAL AND SPECIAL PURPOSE Revenue Cumulative Cumulative Year End 3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected ProjectionYear End Projected Over/Under Budget January 154,373 180,283 156,597 207,318 152,937 133,849 137,774 182,832 228,695 227,333 215,021 243,317 246,667 274,892 337,549 387,987 8.9%297,178 387,987 $90,808 130.56%$5,713,443 $1,341,590 February 224,687 244,043 249,049 206,809 219,448 215,617 201,110 268,180 298,312 285,508 313,148 346,826 403,971 370,154 409,218 457,015 12.2%409,279 457,015 $47,736 111.66%$5,173,476 $801,623March142,119 161,270 157,709 170,679 177,252 122,153 136,282 156,563 250,725 206,739 215,324 256,751 250,759 273,478 312,572 324,431 8.7%289,434 324,431 $34,997 112.09%$5,104,180 $732,327April156,731 170,147 181,390 162,253 148,592 131,100 127,885 167,272 225,772 201,789 220,090 240,865 253,772 266,316 274,725 319,060 8.2%274,914 319,060 $44,145 116.06%$5,103,060 $731,207 May 198,754 211,995 207,595 212,586 181,514 175,118 178,468 203,359 253,499 234,086 270,564 300,523 328,312 355,788 383,945 342,896 11.0%369,403 342,896 -$26,507 92.82%$4,703,340 $331,487 June 164,380 165,275 175,802 167,706 172,947 133,593 200,599 180,706 216,817 205,010 254,948 262,594 273,577 323,647 340,499 312,261 9.7%324,301 312,261 -$12,040 96.29%$4,526,560 $154,707July187,091 235,150 199,236 174,881 159,276 136,373 221,764 205,266 257,252 228,204 242,682 274,051 309,584 343,606 398,407 409,818 10.9%363,682 409,818 $46,136 112.69%$4,649,628 $277,775August220,873 241,022 250,665 244,562 199,901 184,345 246,710 248,822 275,646 307,496 334,103 363,584 383,632 406,836 462,808 442,796 13.0%433,460 442,796 $9,337 102.15%$4,497,103 $125,250 September 211,602 211,286 200,636 213,505 187,214 173,733 225,125 297,214 260,334 276,640 299,788 325,230 318,859 404,786 414,342 - 11.8%393,602 - October 213,751 244,393 214,468 212,410 168,681 161,452 242,654 265,078 278,972 272,408 313,293 336,030 350,255 402,305 431,890 - 12.2%409,634 - November 253,367 234,710 263,159 239,855 213,651 200,463 238,400 267,427 285,758 302,561 318,760 382,973 370,695 409,120 469,051 - 12.9%431,938 - December 183,910 170,134 197,603 197,943 155,866 150,355 193,327 225,874 221,344 255,155 257,928 281,670 289,354 364,274 430,895 - 11.2%375,028 - TTL 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 2,996,263 109.6%$4,371,853 $2,996,263 ytd 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,450,592 1,613,000 2,006,718 1,896,164 2,065,881 2,288,511 2,450,274 2,614,718 2,919,723 2,996,263 2,761,652 2,996,263 ytd change 11.05%-1.94%-1.98%-8.72%-12.73%17.73%11.20%24.41%-5.51%8.95%10.78%7.07%6.71%11.66%2.62%8.50%over (under) ytd expectedannual % chg.6.84%-0.64%-1.77%-11.33%-10.25%22.52%13.55%14.41%-1.64%8.42%11.02%4.57%11.00%11.22% - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 GENERAL & OPTIONAL SALES TAX RECEIPTS BY MONTH AND YEAR (Does not include Special Purpose/Public Safety Tax) December November October September August July June May April March February January 2020 - 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 and Special Purpose Sales Tax YTD, Actual Total and 2020 Budget Special Purpose YTD General & Optional YTD Full Year Total Actual w/ 2020Budget August 2020 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 1 2 3 4 5 6 7 8 9 10 11 12 2020 Monthly Actual Revenue & Budgeted Share Actual 2020 Expected 2020 -$500,000 $500,000 $1,500,000 $2,500,000 $3,500,000 $4,500,000 $5,500,000 1 2 3 4 5 6 7 8 9 10 11 12 2020 Cumulative YTD Actual & Budget Expected by Month Year End Projected Over/UnderBudget YTD Budget YTD Actual $0.00 August 5/7/2020 Sales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 General & Optional YTD 1,449,008 1,609,185 1,578,043 1,546,794 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 2,246,361 2,342,991 Special Purpose YTD - - - - - - 160,996 395,185 461,506 442,685 482,904 560,560 582,256 625,985 673,362 653,272 G&O and SP Sales Tax YTD 1,449,008 1,609,185 1,578,043 1,546,794 1,411,867 1,232,148 1,450,592 1,613,000 2,006,718 1,896,164 2,065,881 2,288,511 2,450,274 2,614,718 2,919,723 2,996,263 Full Year Total: 2020 is YTD Actual & 2020 Budget2,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,606,465 - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,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 2020 - 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 2020AugustAugust CATEGORY ANALYSIS BY CODE 1600, 1650 Jefferson County Run Date: 08/10/2020 Current Period: 202005 Cash Basis, Revenue Amounts June 2020 Sales Data $108,962,751 This Year Last Year % Chg This Year Last Year % Chg Last 12 Months Unclassified 25,651 16,427 56 99,661 97,321 2 157,569 Agriculture, Forestry, Fishing and Hunting 793 797 (0)3,921 5,189 (24)6,406 Mining, Quarrying, and Oil and Gas Extraction 1,236 630 96 5,206 3,769 38 7,643 Utilities 239 146 64 974 2,075 (53)2,708 Construction 89,924 103,157 (13)677,521 609,036 11 1,096,694 Manufacturing 9,751 10,840 (15)66,639 59,559 31 102,599 Wholesale Trade 18,133 17,466 4 137,864 143,320 (4)206,684 Retail Trade 118,886 102,097 34 816,422 722,698 27 1,228,052 Transportation and Warehousing 835 1,045 137 5,565 9,090 (43)9,965 Information 12,262 11,084 11 92,134 85,841 7 136,869 Finance and Insurance 1,347 1,119 20 9,564 9,474 1 15,421 Real Estate and Rental and Leasing 7,270 6,128 19 42,022 38,993 8 66,821 Professional, Scientific, and Technical Services 5,099 6,325 (19)38,523 47,460 (19)55,411 Admin & Support, Waste Mgmt & Remediation Svcs 25,684 21,111 22 151,494 128,472 18 217,107 Educational Services 238 635 (62)1,669 2,421 (31)3,998 Health Care and Social Assistance 599 463 29 3,399 3,891 (13)4,990 Arts, Entertainment, and Recreation 1,592 3,673 (57)10,832 15,185 (29)26,708 Accommodation and Food Services 20,829 39,587 (47)127,975 197,421 (35)268,795 Other Services (except Public Administration)7,012 9,228 (124)45,900 54,849 1,092 70,521 Public Administration 958 3,337 (71)5,708 10,297 (45)13,431 Totals 348,337 355,294 (2)2,342,991 2,246,361 4 3,698,391 Current Period Year to Date Unclassified, 25,651, 7% Agriculture, Forestry, Fishing and Hunting, 793, 0% Mining, Quarrying, and Oil and Gas Extraction, 1,236, 0% Utilities, 239, 0% Construction, 89,924, 26% Manufacturing, 9,751, 3% Wholesale Trade, 18,133, 5% Retail Trade, 118,886, 34% Transportation and Warehousing, 835, 0% Information, 12,262, 4% Finance and Insurance, 1,347, 0% Real Estate and Rental and Leasing, 7,270, 2% Professional, Scientific, and Technical Services, 5,099, 1% Admin & Support, Waste Mgmt & Remediation Svcs, 25,684, 7% Educational Services, 238, 0% Health Care and Social Assistance, 599, 0% Arts, Entertainment, and Recreation, 1,592, 0% Accommodation and Food Services, 20,829, 6% Other Services (except Public Administration), 7,012, 2% Current Period This Year, Total Taxable Sales Unclassified Agriculture, Forestry, Fishing and Hunting Mining, Quarrying, and Oil and Gas Extraction Utilities Construction Manufacturing Wholesale Trade Retail Trade Transportation and Warehousing Information Finance and Insurance Real Estate and Rental and Leasing Professional, Scientific, and Technical Services Admin & Support, Waste Mgmt & Remediation Svcs Educational Services Health Care and Social Assistance Arts, Entertainment, and Recreation Accommodation and Food Services Other Services (except Public Administration) June 2020 Sales Data $108,962,751 56 (0) 96 64 (13)(15) 4 34 137 11 20 19 (19) 22 (62) 29 (57)(47) (124)(150) (100) (50) 0 50 100 150 200 -150,000 -100,000 -50,000 0 50,000 100,000 150,000 2020 and 2019 Amounts and Percentage Change from last year This Year Last Year % Chg June 2020 Sales 8 August 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation Recent 2020 % Budget Month Change 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 4 YR AVG Budget Difference prior year January $78,294 $83,384 $72,424 $45,530 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 64,496 69,086 62,517 57,998 19.1%7.1% February $112,120 $74,250 $65,590 $45,612 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 51,891 84,560 53,990 50,087 68.8%63.0% March $92,812 $82,868 $58,766 $63,286 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 82,105 93,964 82,177 76,237 23.3%14.4% April $105,772 $83,776 $95,258 $105,272 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 89,657 78,860 86,955 80,670 -2.2%-12.0% May $124,210 $125,632 $86,666 $49,638 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 75,991 114,808 106,509 -28.7%-31.5% June $164,122 $137,630 $89,338 $54,812 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 104,991 205,638 160,276 148,690 38.3%95.9% July $132,668 $117,584 $108,226 $57,890 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 136,683 160,738 114,120 105,871 51.8%17.6% August $133,848 $355,084 $92,362 $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 130,942 162,691 124,449 115,453 40.9%24.2% September $147,903 $104,040 $67,136 $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 105,075 124,986 115,952 October $203,764 $89,674 $100,551 $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 134,016 125,931 116,828 November $126,964 $99,990 $52,266 $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 110,009 100,356 93,102 December $97,838 $113,314 $46,605 $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 74,910$ 125,158 95,845 88,917 Total $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $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 $931,527 1,246,409$ 1,156,313$ -19.4%-25.2% YTD 943,846 1,060,208 668,630 480,280 376,242 $187,136 310,929 310,375 393,343 424,219 706,497 846,272 770,631 808,495 771,766 931,527 799,291$ 741,514$ 25.6%20.7% YTD change 12.33%-36.93%-28.17%-21.66%-50.26%10.20%-0.18%26.73%7.85%66.54%19.78%-8.94%4.91%-4.54%20.70% Annual % chg 12.33%-36.93%-28.17%-21.66%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42% Actual Full Year or Budget $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $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,156,313 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 July 2020 2 sales over $1M: $1.25M & $1.025M; and 16 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 Aug 2020 1 sales @$1.25M and 23 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 May 2020 1@$1.3M and 6>$500k Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k June 2020 3 sales over $1M: $9.9M, $1.07M & $1.375M; and 19 sales>$500k 9/10/2020 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Real Estate Excise Tax Collections -2005 to 2020 Fund 302 Capital Improvement Fund December November October September August July June May April March February January Actual Full Year or Budget $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 REET YTD, Actual Total and 2020 Budget YTD Actual YTD Budget 0 50,000 100,000 150,000 200,000 250,000 2020 Monthly Actual Revenue & Budgeted Share 2020 Actual Budget August August 9/10/2020 4 yr avg *2020 2020 % Budget % Diff 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2016-19 Budget Actual Difference Prior Year January 16,089 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 27,998 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 22,623 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 11,344 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 19,646 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 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 35,204 35,308 742 -97.9%-98.3% July 20,155 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 24,074 41,320 41,442 24,074 -41.9%-50.6% August 35,178 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 41,591 64,155 64,345 41,591 -35.4%-41.0% September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 40,530 66,806 67,004 40,530 -39.5%-54.1% October 43,012 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 61,077 61,258 November 44,351 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 63,792 63,980 December 19,873 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 36,892 37,001 Full Year 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 243,341 519,906 521,444 243,341 YTD 172,238 146,733 143,884 158,909 169,080 208,032 251,608 290,924 299,567 323,259 202,811 291,339 292,201 202,811 -30.6%-37.3% Full Year Actual/2020 Budget321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 521,444 YTD Change 15.70%-1.94%10.44%6.40%23.04%20.95%15.63%2.97%7.91%-37.26% 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.181(1).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. 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 December November October September August July June May April March February January Full Year Actual/2020 Budget $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2020 YTD Actual and Budget YTD Actual YTD Budget 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 2020 Monthly Actual and Budget 2020 Actual Budget 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,980 December 18,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