The URL can be used to link to this page

2022-06-14 City Council - Full FIN Agenda-31711. Op E D o Agenda Edmonds City Council tnl. }nyo FINANCE COMMITTEE CITY COUNCIL CONFERENCE ROOM 121 - 5TH AVENUE N, EDMONDS, WA 98020 JUNE 14, 2022, 5:30 PM COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. PERSONS WISHING TO ATTEND THIS MEETING VIRTUALLY IN LIEU OF IN -PERSON ATTENDANCE CAN CLICK ON OR PASTE THE FOLLOWING ZOOM MEETING LINK INTO A WEB BROWSER USING A COMPUTER OR SMART PHONE: HTTPS://ZOOM. US/J/95798484261 OR JOIN BY DIAL -UP PHONE: US: +1 253 215 8782 WEBINAR ID: 957 9848 4261 COMMITTEE MEMBERS: DIANE BUCKSHNIS (CHAIR), WILL CHEN, VIVIAN OLSON (EX-OFFICIO MEMBER) CALL TO ORDER COMMITTEE BUSINESS 1. April 2022 Monthly Financial Report (10 min) 2. 2022 State Auditor Office (SAO) Audit Exit Follow Up (30 min) ADJOURN Edmonds City Council Agenda June 14, 2022 Page 1 2.1 City Council Agenda Item Meeting Date: 06/14/2022 April 2022 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Review and move to full council on consent Narrative April 2022 Monthly Financial Report Attachments: April 2022 Monthly Financial Report Packet Pg. 2 I 2.1.a I OF EDP � d lac. 1SOV CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT AP RI L 2022 Packet Pg. 3 1 INVESTMENT PORTFOLIO SUMMARY I 2.1.a I Agency/ Investment Issuer Type FFCB Bonds Energy Northwest Bonds Energy Northwest Bonds Mason & Kitsap Cnty WA Bonds Grant Cnty WA Bonds Grant Cnty WA Bonds Seattle WA Muni Bonds FHLMC Bonds FHLB Bonds First Financial - ECA CD Kent WA Bonds FNMA Bonds Spokane County WA Bonds First Financial - Waterfront Center CD TOTAL SECURITIES Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO City of Edmonds Investment Portfolio Detail As of April 30, 2022 Years Purchase to Par Price 1,998,548 1,466,077 260,748 948,084 1,517,955 576,332 2,224,500 988,678 1,996,590 2,803,516 286,648 992,693 207,260 1,575,000 0.12 0.17 0.17 0.59 0.67 0.67 0.76 0.97 1.43 1.55 1.59 2.18 2.59 5.51 Value 2,000,000 1,345,000 250,000 855,000 1,500,000 520,000 2,000,000 1,000,000 2,000,000 2,803,516 250,000 1,000,000 200,000 1,575,000 Market Value 2,002,836 1,353,137 250,640 871,459 1,496,940 531,196 2,048,760 983,724 1,947,606 2,803,516 260,825 980,595 196,038 1,575,000 Maturity Date 06/14/22 07/01 /22 07/01 /22 12/01 /22 01 /01 /23 01 /01 /23 02/01 /23 04/20/23 10/05/23 11/15/23 12/01 /23 07/02/24 12/01 /24 11 /01 /27 Coupon Rate 1.88% 5.00% 2.95% 5.00% 1.54% 5.00% 5.00% 0.38% 0.22% 2.08% 5.00% 1.75% 2.10% 0.20% 17, 842, 627 1.36 17,298, 516 17, 302, 272 12,499,942 12,499,942 Demand 0.41% 42,666,548 42,666,548 Demand 1.06% $ 72,465,007 $ 72,468,762 Kent WA, Issuer Diversification Seattle 1% WA Muni, Mason & 12% Kitsap Cnty— WA, 5% Financial - CD, 25% Grant Cnty J I Spokane WA, 12% FHLB, 12% County FFCB, WA, 1% 12% Energy Northwest, FHLMC, 6% 9% FNMA, 6% Checking, Cash and Investment Balances $2.3 , 3%� (in $ Millions) Bonds, State LGIP, CD's, $4.4, $12.9, 17% $12.5, 17% 6% County LGIP, $42.7, 57% O N C C ILL A L r C O 2 N N O N IZ Q O Q d R U C C ILL t C O Z N N O N �L Q Q t to Q 1 Packet Pg. 4 1 I 2.1.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,236,875 $1,200, 000 $1,000,000 $882556 947 931 $950,684 $800,000 $635,781 $600,000 $400,000 317 581 $200,000 $- 2017 2018 201 2020 2021 YTD 2022 2 Packet Pg. 5 GENERAL FUND SUMMARY I 2.1.a I General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenues General Fund Expenses 10,000, 000 — 9,000,000 T 8,000,000 7,000, 000 6,000,000 • 5,000,000 4,000, 000 3,000,000 2,000, 000 1,000, 000 • May August November February May August November February General Fund Tax Revenue (2016 through 2021) Sales Tax Property Tax EMS Tax Other Taxes 12,000, 000 10,000, 000 8,000, 000 6,000,000 4,000, 000 2,000,000 2016 2017 2018 2019 2020 2021 4,000,000 3,500,000 3,000, 000 2,500,000 2,000, 000 1,500,000 1,000,000 500,000 General Fund Tax Revenue (2022 YTD) $965,094 $384,002 Sales Tax Property Tax EMS Tax $2,838,603 Other Taxes 3 Packet Pg. 6 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2022 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 2,486,429 $ 2,486,429 $ 2,291,020 -7.86% February 4,917,170 2,430,740 4,711,093 -4.19% March 7,380,020 2,462,851 7,394,990 0.20% April 10,516,012 3,135,992 10,451,247 -0.62% May 19,357,334 8,841,322 June 21,935,611 2,578,276 July 24,465,539 2,529,929 August 27,084,819 2,619,280 September 29,465,113 2,380,294 October 33,512,944 4,047,830 November 42,090,496 8,577,552 December 44,640,708 2,550,212 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2022 Real Estate Excise Tax 1 & 2 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 381,097 $ 381,097 $ 377,895 -0.84% February 611,562 230,465 620,392 1.44% March 952,142 340,580 793,926 -16.62% April 1,227,434 275,291 1,165,930 -5.01% May 1,586,772 359,339 June 1,961,879 375,106 July 2,368,248 406,370 August 2,810,074 441,826 September 3,256,638 446,564 October 3,660,486 403,848 November 4,056,561 396,075 December 4,400,000 343,439 *The monthly budget forecast columns are based on a five-year average. r Q w Packet Pg. 7 1 SALES TAX SUMMARY I 2.1.a I Construction Trade, $511,594 Accommodation, $11,773 \ Clothing and Accessories, $114,237 - Comnwnications, $83,732 Wholesale Trade, $119,688 Sales Tax Analysis By Category Current Period: Apirl 2022 Year -to -Date Total $3,469,412 Automotive Repair, $75,096 Health & Amusement & Personal Care, Recreation, $23,3044 $96,197 Misc Retail, $643,055 Business Services, $403,478 Gasoline, $10,375 Retail Food Stores, $112,977 Retail Automotive, $809,471 _A Others, $54,026 Eating & Drinking Manufacturing, $40,790 $359,619 Annual Sales Tax Revenue 12,000,000 $10,302,518 10,000, 000 $7,395,114 $8,406,296 $8,452,715 $8,317,046 8,000,000 6,905,122 6,000,000 $3,469,412 4,000,000 2,000,000 0 2016 2017 2018 201 2020 2021 YTD 2022 5 Packet Pg. 8 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2022 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 763,651 $ 763,651 $ 857,872 12.34% February 1,704,609 940,958 1,853,000 8.71% March 2,420,254 715,646 2,666,259 10.16% April 3,074,639 654,384 3,469,412 12.84% May 3,893,081 818,442 June 4,672,507 779,426 July 5,523,403 850,896 August 6,439,084 915,680 September 7,293,649 854,565 October 8,203,996 910,347 November 9,139,425 935,429 December 10,000,000 860,575 City of Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2022 Gas Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 79,399 $ 79,399 $ 96,596 21.66% February 164,205 84,806 96,596 -41.17% March 246,125 81,920 305,138 23.98% April 313,860 67,734 397,808 26.75% May 367,416 53,556 June 402,173 34,757 July 429,975 27,802 August 452,332 22,357 September 472,668 20,335 October 496,035 23,367 November 534,998 38,963 December 595,000 60,002 Gas Utility Tax 700,000 600,000 500,000 - 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. O N C M C LL t C O 2 N N O N �L CL Q O CL C M a LL z C O 2 N N O N �L a C N E t t) M r r Q 6 Packet Pg. 9 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2022 Telephone Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 53,352 $ 53,352 $ 43,844 -17.82% February 96,981 43,629 66,255 -31.68% March 143,255 46,275 130,244 -9.08% April 192,397 49,142 175,045 -9.02% May 232,481 40,084 June 277,770 45,288 July 321,046 43,277 August 362,710 41,663 September 400,099 37,389 October 445,363 45,264 November 482,039 36,676 December 523,000 40,961 Electric Utility Tax Telephone Utility Tax 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget -*-- Prior Year City of Edmonds, WA Monthly Revenue Summary -Electric Utility Tax 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 148,905 $ 148,905 $ 183,023 22.91% February 312,488 163,583 377,116 20.68% March 449,608 137,121 534,798 18.95% April 602,286 152,678 726,969 20.70% May 723,393 121,107 June 824,492 101,099 July 920,639 96,147 August 1,015,921 95,282 September 1,108,535 92,614 October 1,199,070 90,535 November 1,299,972 100,902 December 1,410,000 110,028 Electric Utility Tax 1,zsuu,uuu 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. Packet Pg. 10 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2022 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 809,979 $ 809,979 $ 827,704 2.19% February 1,383,405 573,426 1,383,308 -0.01% March 2,213,219 829,814 2,127,271 -3.88% April 2,744,029 530,810 2,688,719 -2.02% May 3,542,697 798,668 June 4,167,857 625,160 July 5,138,308 970,451 August 5,986,736 848,427 September 7,133,311 1,146,575 October 7,954,825 821,514 November 8,891,706 936,881 December 9,464,783 573,077 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2022 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 426,464 $ 426,464 $ 417,730 -2.05% February 1,352,938 926,475 1,322,856 -2.22% March 1,779,789 426,851 1,740,623 18.95% April 2,159,443 379,654 2,114,167 20.70% May 2,586,880 427,437 June 2,966,444 379,564 July 3,385,868 419,425 August 4,311,526 925,657 September 4,738,766 427,240 October 5,118,192 379,426 November 5,545,860 427,668 December 5,911,497 365,637 Storm Water Sales 6,000,000 5,500,000 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. O N C M C LL t C O 2 N tV O tV �L a Q O CIL C M c LL 21 z r C O 2 N N O tV �L a C N E t t) R r r Q Packet Pg. 11 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2022 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 863,521 $ 863,521 $ 877,046 1.57% February 1,571,494 707,973 1,604,010 2.07% March 2,435,565 864,071 2,451,231 0.64% April 3,143,499 707,934 3,183,083 1.26% May 4,009,811 866,312 June 4,719,932 710,121 July 5,593,564 873,631 August 6,307,925 714,362 September 7,215,145 907,220 October 7,936,868 721,723 November 8,819,637 882,769 December 9,528,089 708,452 EL O N t4 C fC C LL _A L a+ C O 2 N N O N Q Q O rL d R U C C LL t C O 2 N N O N 'L Q Q Q *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 12 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2022 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 5,342,528 $ 5,342,528 $ 4,601,625-13.87% February 9,225,120 3,882,592 8,134,057-11.83% March 13,453,045 4,227,925 11,966,023-11.05% April 17,154,891 3,701,846 15,469,533 -9.82% May 21,081,164 3,926,273 June 25,953,408 4,872,244 July 30,083,274 4,129,866 August 33,991,194 3,907,920 September 38,121,718 4,130,524 October 42,646,764 4,525,046 November 47,397,312 4,750,547 December 52,360,872 4,963,560 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2022 Non -Departmental Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 2,508,279 $ 2,508,279 $ 2,099,939 -16.28% February 3,543,187 1,034,908 2,938,380 -17.07% March 4,861,868 1,318,681 4,088,791 -15.90% April 5,666,194 804,326 5,036,007 -11.12% May 6,662,820 996,625 June 8,507,675 1,844,856 July 9,572,392 1,064,717 August 10,448,509 876,116 September 11,463,698 1,015,189 October 12,742,850 1,279,152 November 14,166,478 1,423,628 December 15,574,121 1,407,643 *The monthly budget forecast columns are based on a five-year average. 10 Packet Pg. 13 1 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2022 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 33,985 $ 33,985 $ 23,687 -30.30% February 71,308 37,323 43,670 -38.76% March 112,128 40,821 71,408 -36.32% April 150,174 38,046 100,819 -32.87% May 199,408 49,234 June 253,207 53,799 July 291,886 38,679 August 345,215 53,328 September 382,380 37,165 October 414,981 32,601 November 455,321 40,340 December 497,900 42,579 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2022 Office of Mayor Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 36,522 $ 36,522 $ 28,255 -22.63% February 74,639 38,117 59,226 -20.65% March 111,240 36,600 89,568 -19.48% April 148,486 37,247 119,372 -19.61% May 185,158 36,671 June 221,111 35,953 July 257,901 36,789 August 295,030 37,129 September 331,738 36,709 October 367,805 36,067 November 405,747 37,941 December 443,913 38,166 Office of Mayor 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-CurrentYeaz Budget --*-PriorYeaz *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 14 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2022 Human Resources Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 77,402 $ 77,402 $ 59,932 -22.57% February 141,639 64,236 135,524 -4.32% March 202,815 61,176 203,581 0.38% April 266,756 63,941 270,474 1.39% May 331,195 64,439 June 405,872 74,678 July 464,145 58,273 August 524,126 59,981 September 590,408 66,282 October 654,662 64,254 November 726,800 72,138 December 824,831 98,031 City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2022 Municipal Court Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 104,268 $ 104,268 $ 91,643 -12.11% February 213,906 109,638 187,919 -12.15% March 322,490 108,584 284,025 -11.93% April 431,592 109,102 386,046 -10.55% May 548,505 116,913 June 654,584 106,079 July 763,667 109,084 August 884,110 120,443 September 995,910 111,800 October 1,110,987 115,077 November 1,227,059 116,072 December 1,368,755 141,696 Municipal Court 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-CurrentYeaz Budget -m-PriorYear *The monthly budget forecast columns are based on a five-year average. 12 Packet Pg. 15 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2022 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 49,857 $ 49,857 $ 33,127 -33.56% February 103,113 53,256 72,230 -29.95% March 155,568 52,455 122,479 -21.27% April 205,451 49,882 179,118 -12.82% May 260,752 55,301 June 315,986 55,234 July 373,132 57,147 August 434,777 61,645 September 492,000 57,223 October 552,240 60,239 November 622,590 70,351 December 719,388 96,798 *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 16 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2022 Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 176,962 $ 176,962 $ 216,858 22.55% February 334,966 158,004 287,295 -14.23% March 484,397 149,431 502,978 3.84% April 566,805 82,408 545,022 -3.84% May 674,037 107,232 June 784,541 110,504 July 877,847 93,306 August 989,174 111,327 September 1,106,217 117,044 October 1,245,373 139,155 November 1,341,722 96,350 December 1,539,022 197,300 Administrative Services Technology Rental Fund 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Year Budget -d Prior Year City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2022 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 238,721 $ 238,721 $ 217,022 -9.09% February 399,953 161,232 380,532 -4.86% March 563,330 163,378 547,460 -2.82% April 729,233 165,903 722,690 -0.90% May 896,198 166,965 June 1,121,628 225,430 July 1,314,351 192,723 August 1,478,599 164,248 September 1,647,511 168,911 October 1,824,204 176,693 November 1,989,608 165,404 December 2,156,911 167,303 *The monthly budget forecast columns are based on a five-year average. 14 Packet Pg. 17 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2022 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 80,982 $ 80,982 $ 77,656 -4.11% February 161,963 80,982 155,234 -4.16% March 242,945 80,982 233,065 -4.07% April 323,927 80,982 287,018 -11.39% May 404,908 80,982 June 485,890 80,982 July 566,871 80,982 August 647,853 80,982 September 728,835 80,982 October 809,816 80,982 November 890,798 80,982 December 971,780 80,982 Police City Attorney 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 oe 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-- Current Yeaz Budget Prior Yeaz City of Edmonds, WA Monthly Expenditure Report -Police 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 1,045,238 $ 1,045,238 $ 973,358 -6.88% February 2,105,968 1,060,730 1,945,020 -7.64% March 3,177,596 1,071,629 3,008,075 -5.33% April 4,236,492 1,058,896 4,001,453 -5.55% May 5,296,298 1,059,805 June 6,428,932 1,132,634 July 7,551,012 1,122,080 August 8,579,704 1,028,692 September 9,657,485 1,077,782 October 10,845,669 1,188,184 November 12,168,634 1,322,964 December 13,375,470 1,206,836 Police 8,000,000 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"- Current Yeaz Budget �Prior Year *The monthly budget forecast columns are based on a five-year average. 15 Packet Pg. 18 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2022 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 272,173 $ 272,173 $ 309,139 13.58% February 567,186 295,012 661,303 16.59% March 860,247 293,062 909,669 5.75% April 1,174,618 314,370 1,157,411 -1.46% May 1,488,050 313,432 June 1,792,716 304,666 July 2,114,310 321,593 August 2,423,605 309,295 September 2,733,462 309,857 October 3,039,102 305,640 November 3,402,002 362,901 December 3,791,859 389,857 Parks & Recreation Development Services 4,000,000 3,500,000 3,000,000 2,500,000 2,000,00001 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Year Budget -d Prior Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2022 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 358,065 $ 358,065 $ 319,222 -10.85% February 748,023 389,958 651,988 -12.84% March 1,136,243 388,220 1,040,803 -8.40% April 1,535,144 398,902 1,354,932 -11.74% May 1,941,016 405,872 June 2,369,808 428,792 July 2,835,053 465,245 August 3,347,305 512,252 September 3,871,489 524,184 October 4,291,784 420,295 November 4,690,353 398,569 December 5,125,535 435,182 *The monthly budget forecast columns are based on a five-year average. 16 Packet Pg. 19 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Public Works Administration 2022 Public Works Administration Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 49,466 $ 49,466 $ 22,716 -54.08% February 100,066 50,600 46,637 -53.39% March 150,167 50,100 71,242 -52.56% April 201,867 51,701 94,556 -53.16% May 252,421 50,554 June 303,852 51,431 July 355,684 51,832 August 405,471 49,786 September 455,172 49,701 October 504,185 49,013 November 567,424 63,239 December 614,113 46,689 Facilities Maintenance Public Works Administration 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 219,301 $ 219,301 $ 109,202 -50.20% February 456,337 237,035 369,398 -19.05% March 723,326 266,990 562,089 -22.29% April 964,010 240,684 782,173 -18.86% May 1,206,775 242,765 June 1,404,870 198,095 July 1,647,775 242,905 August 1,934,891 287,116 September 2,271,751 336,861 October 2,655,928 384,177 November 2,962,277 306,349 December 3,425,275 462,998 Facilities Maintenance 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget -0-- Prior Year *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 20 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2022 Engineering Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 225,595 $ 225,595 $ 226,829 0.55% February 452,988 227,392 457,182 0.93% March 684,071 231,083 685,977 0.28% April 917,956 233,885 914,235 -0.41% May 1,175,026 257,070 June 1,412,521 237,495 July 1,660,688 248,167 August 1,900,016 239,329 September 2,131,816 231,799 October 2,366,570 234,755 November 2,602,612 236,042 December 2,845,336 242,724 Engine a ring 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 18 Packet Pg. 21 I 2.1.a I Page 1 of 1 C ITY O F IDMO NDS REVINUES BY FUND - SUMMARY Fund 2022 Amended 4/30/2021 4/30/2022 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 44,640,708 $ 11,029,475 $ 10,451,247 $ 34,189,461 230 009 LEOFF-MEDICAL INS. RESERVE 225,000 - - 225,000 00 016 BUILDING MAINTENANCE FUND 119,645 - 10,892 108,753 90 017 MARSH RESTORATION & PRESERVATION FUND - 100 - - 04 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 - - 200,000 00 104 DRUG ENFORCEMENT FUND 167,210 1,192 675 166,535 00 Ill STREET FUND 1,751,930 453,730 431,336 1,320,594 250 G 112 COMBINED STREET CONST/IMPROVE 1 13,684,871 677,709 1,097,315 12,587,556 84 117 MUNICIPAL ARTS ACQUIS. FUND 216,701 13,334 83,247 133,454 380 ca 118 MEMORIAL STREET TREE - 324 - - 00 C 120 HOTEL/MOTEL TAX REVENUE FUND 84,410 15,236 26,448 57,962 310 _ 121 EMPLOYEE PARKING PERMIT FUND 26,540 9,710 11,056 15,484 420 LL ZI 122 YOUTH SCHOLARSHIP FUND 1,550 222 128 1,422 80 t 123 TOURISM PROMOTIONAL FUND/ARTS 29,590 6,034 9,457 20,133 r� 320 Co 125 REAL ESTATE EXCISE TAX 2 2 2,271,020 784,296 619,544 1,651,476 270 2 126 REAL ESTATE EXCISE TAX 1 2 2,261,030 778,370 613,917 1,647,113 N 274 C N 127 GIFTS CATALOG FUND 82,750 38,166 74,404 8,346 900 - 130 CEMETERY MAINTENANCE/IMPROVEMT 182,430 77,558 65,814 116,616 'L 360 Q 136 PARKS TRUST FUND 4,330 2,671 1,511 2,819 350 137 CEMETERY MAINTENANCE TRUST FD 43,520 25,777 16,991 26,529 390 C Q. 138 SIST ER CITY COMMISSION 10,290 166 139 10,151 10 � 140 BUSINESS IMPROVEMENT DISTRICT 79,349 49,995 50,408 28,941 64° ca 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 26,290 24,287 40,713 370 r- 142 EDMONDS RESCUE PLAN FUND 4,856,549 - - 4,856,549 04 E 143 TREE FUND 215,330 - 183 215,147 00 >% 231 2012 LT GO DEBT SERVICE FUND 611,370 - - 611,370 00 332 PARKS CAPITAL CONSTRUCTION FUND 2 3,822,685 289,144 808,210 3,014,475 210 0 411 COMBINED UTILITY OPERATION - 2,400 59,500 (59,500) 04 N 421 WATER UTILITYFUND3 11,018,136 3,096,082 3,185,630 7,832,506 290 N 422 STORM UTILITYFUND3 7,877,897 2,705,036 2,401,152 5,476,745 300 .Q 423 SEWER/WWTP UTILITY FUND 24,820,083 6,735,220 6,756,335 18,063,748 27° Q 424 BOND RESERVE FUND 1,988,700 4 514 1,988,186 r-� 04 511 EQUIPMENT RENTAL FUND 1,925,920 542,019 612,108 1,313,812 324 t 512 TECHNOLOGY RENTAL FUND 1,153,570 411,202 387,698 765,872 340 R $ 124,4389114 $ 27,771,460 $ 27,800,146 $ 96,637,968 r 22 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Traffic Impact fee in March 2022. Z REET revenues are down a total of $(312,143) from this point in time last year. 3 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Park Impact fee in March 2022. a 2022 Utility Rate Increases are 4.5%for Water, 5%for Sewer, and 9.5%for Storm Drain. 19 Packet Pg. 22 I 2.1.a I Page 1 of 1 C ITY OF EDMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2022 Amended 4/30/2021 4/30/2022 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 52,360,872 $ 14,232,961 $ 15,469,533 $ 36,891,339 300 009 LEOFF-MEDICAL INS. RESERVE 260,490 124,508 114,099 146,391 440 014 HISTORIC PRESERVATION GIFT FUND 5,900 - - 5,900 04 016 BUILDING MAINTENANCE FUND 545,000 17,074 527,926 30, 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 - 200,000 00 104 DRUG ENFORCEMENT FUND 45,800 - - 45,800 00 III STREET FUND 2,315,780 754,458 781,473 1,534,307 340, O 112 COMBINED STREET CONST/IMPROVE 12,868,796 273,782 494,505 12,374,291 40,, d 117 MUNICIPAL ARTSACQUIS. FUND 195,380 12,451 13,945 181,435 70 120 HOTEL/MOTEL TAX REVENUE FUND 100,900 13,510 12,011 88,889 120/ T c� C 121 EMPLOYEE PARKING PERMIT FUND 26,880 - - 26,880 04 C 122 YOUTH SCHOLARSHIP FUND 3,000 - 3,000 00, IL 123 TOURISM PROMOTIONAL FUND/ARTS 28,200 - - 28,200 ZI 00 125 REAL ESTATE EXCISE TAX 2 4,589,688 54,964 553,438 4,036,250 r� 120/ C 126 REAL ESTATE EXCISE TAX 1 2,483,667 238,618 134,032 2,349,635 50, 2 N 127 GIFTS CATALOG FUND 78,400 10,981 2,462 75,938 30, C 130 CEMETERY MAINTENANCE/IMPROVEMT 220,561 58,898 60,462 160,099 N 270 - 136 PARKS TRUST FUND 50,000 - - 50,000 L 0° C 137 CEMETERY MAINTENANCE TRUST FUND 25,000 - 25,000 00, 138 SISTER CITY COMMISSION 11,900 - - 11,900 00, Q 140 BUSINESS IMPROVEMENT DISTRICT 87,680 18,593 16,298 71,382 190, 142 EDMONDS RESCUE PLAN FUND 6,077,492 - 295,776 5,781,716 501 <0 143 TREE FUND 214,800 - 214,800 00, r- 231 2012 LT GO DEBT SERVICE FUND 611,370 - - 611,370 00, LL 332 PARKS CAPITAL CONSTRUCTION FUND 7,614,418 140,478 2,037,225 5,577,193 270 >% z 421 WATER UTILITY FUND 11,490,988 1,715,970 1,897,778 9,593,210 170/ 422 STORM UTILITY FUND 9,619,649 1,330,584 1,402,081 8,217,568 15° n 423 SEWER/WWTP UTILITY FUND 29,529,856 6,297,879 5,255,655 24,274,201 180, N 424 BOND RESERVE FUND 1,988,710 - - 1,988,710 O 00, N 511 EQUIPMENT RENTAL FUND 1,950,371 338,356 456,143 1,494,228 230/ .a 512 TECHNOLOGY RENTAL FUND 1,539,022 404,389 545,022 994,000 350 Q r-� 617 FIREMEN'S PENSION FUND - 32,192 - - 00, N $ 147,140,570 $ 26,053,570 $ 29,559,012 $117,5819558 200, t 20 Packet Pg. 23 I 2.1.a I Page 1 of 3 Title TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 5 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GAS UTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWER UTILITY TAX 12 ST ORMWAT ER UT ILIT Y T AX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABSTAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT -COMCAST 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-ZIPLY FIBER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OT R NON -BUS LIC/PERMIT S INTERGOVERNMENTAL: 32 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 33 HIGH VISIBILITY ENFORCEMENT 34 CORONAVIRUS RELIEF FUND 2 35 WA STATE TRAFFIC COMM GRANT 36 DOC FAC ROOFING 37 STATE GRANTS- BUDGET ONLY 38 PUD PRIVILEDGE TAX 39 TRIAL COURT IMPROVEMENT 40 CJ - POPULATION 41 CRIMINAL JUSTICE -SPECIAL PROGRAMS 42 MARIJUANA EXCISE TAX DISTRIBUTION 43 DUI - CITIES 44 LIQUOR EXCISE TAX 45 LIQUOR BOARD PROFITS 46 FIRST RESPONDERS FLEX FUND 47 DISCOVERY PROGRAMS TECHNOLOGY ACQ. 48 VERDANT INTERLOCAL GRANTS C ITY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 4/30/2021 Budget Revenues 4/30/2022 Amount Revenues Remaining %Received $ 11,127,000 $ 900,782 $ 965,094 $ 10,161,906 90/ 4,278,000 354,714 384,002 3,893,998 90/ 500 1 27 473 501 10,000,000 3,041,781 3,469,412 6,530,588 350/ 7,600 3,413 6,401 1,199 840/ 870,000 288,337 325,350 544,650 370/ 1,410,000 721,208 726,969 683,031 520r 595,000 350,366 397,808 197,192 670/ 284,000 118,740 113,712 170,288 400r 953,000 273,016 268,813 684,187 280/ 894,600 297,593 233,564 661,036 260/ 471,900 192,636 211,419 260,481 4501 792,000 263,405 273,041 518,959 340/ 523,000 190,824 175,045 347,955 330r 55,200 32,563 29,294 25,906 530/ 350 143 - 350 00/ 306,000 77,762 77,160 228,840 250/ 32,568,150 7,107,282 7,657,111 24,911,039 240, 250 300 50 200 200/ 700 - 20 680 30/ 40,000 9,914 22,202 17,798 560/ 702,700 338,231 349,602 353,098 5001 41,000 9,639 12,098 28,902 300/ 100,600 18,760 12,550 88,050 120/ 384,000 82,609 84,298 299,702 220/ 250,000 82,108 83,329 166,671 330/ 63,000 29,265 32,055 30,945 5101 30,000 14,440 30,173 (173) 1010/ 650,600 205,312 273,423 377,177 420/ 24,000 6,349 7,419 16,581 310r 55,000 26,355 24,602 30,398 450/ 20,000 5,102 4,928 15,072 250r 2,361,850 828,383 936,750 1,425,100 40°r 9,000 2,671 5,237 3,763 580/ 11,100 908 718 10,382 60/ - 3,947 - - 00/ 3,390 - - 00/ - 379,270 - - 00/ 273,000 - - 273,000 00/ 210,500 - - 210,500 00/ 16,740 8,070 10,776 5,964 640i 13,070 6,757 7,142 5,928 5501 45,600 24,120 25,386 20,214 560r 60,000 17,895 24,665 35,335 410/ 4,500 3,335 3,587 914 800r 261,500 146,188 152,556 108,944 580/ 343,200 83,909 83,190 260,010 240/ 1,000 - - 1,000 00/ 550 - - 550 00/ - 66,000 - - 00/ 1,249,760 746,459 313,257 936,503 250, 5 2022 Local Retail Sales/Use Tax revenues are $427,631 higher than 2021 revenues. Please also see pagespages 5 & 6. 21 1 Packet Pg. 24 1 I 2.1.a I Page 2 of 3 C TTY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 4/30/2021 Title Budget Revenues 4/30/2022 Amount Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS $ 3,000 $ 2,198 $ 2,212 $ 789 2 ATM SURCHARGE FEES 600 30 44 557 3 CREDIT CARD FEES 11,000 2,036 441 10,559 4 COURT RECORD SERVICES 150 - 1 149 5 D/M COURT REC SER 300 - - 300 6 DRE REIMBURSEABLE - 168 - - 7 WARRANT PREPARATION FEE 4,000 98 - 4,000 8 IT TIME PAY FEE 1,000 246 49 951 9 MUNIC.-DIST. COURT CURREXPEN 50 67 51 (1) 10 SALE MAPS & BOOKS 100 - - 100 11 CLERKS TIME FOR SALE OF PARKINGPERMITS 25,000 - - 25,000 12 BID SUPPLIES REIMBURSEMENT 600 - - 600 13 PHOTOCOPIES 1,000 83 51 949 14 POLICE DISCLOSURE REQUESTS 5,000 - - 5,000 15 ENGINEERING FEES AND CHARGES 180,000 92,380 89,145 90,855 16 ELECTION CANDIDATE FILING FEES 1,400 - 2,885 (1,485) 17 CUSTODIAL SERVICES(SNO-ISLE) 85,000 34,342 45,868 39,132 18 PASSPORTSANDNATURALIZATION FEES 10,000 - 1,820 8,180 19 POLICE SERVICES SPECIAL EVENTS 30,000 - - 30,000 20 CAMPUS SAFETY-EDM. SCH. DIST. 14,000 - - 14,000 21 WOODWAY-LAW PROTECTION 210,970 102,412 52,742 158,228 22 MISCELLANEOUS POLICE SERVICES - - 25 (25) 23 FIRE DISTRICT #1 STATION BILLINGS 57,000 33,108 35,250 21,750 24 LEGAL SERVICES 1,050 44 302 748 25 ADULT PROBATION SERVICE CHARGE 38,000 11,360 6,745 31,255 26 BOOKING FEES 3,000 313 182 2,818 27 FIRE CONSTRUCTION INSPECTION FEES 10,000 7,424 9,193 807 28 EMERGENCY SERVICE FEES 3,500 1,023 211 3,289 29 EMS TRANSPORT USER FEE 1,007,500 201,222 238,403 769,097 30 FLEX FUEL PAYMENTS FROM STATIONS 2,500 520 1,454 1,046 31 ANIMAL CONTROL SHELTER 100 - - 100 32 ZONING/SUBDIVISION FEE 65,600 28,433 36,168 29,433 33 PLAN CHECKING FEES 425,000 204,113 88,730 336,270 34 FIRE PLAN CHECK FEES 4,000 5,865 4,881 (881) 35 PLANNING 1% INSPECTION FEE 500 - 110 390 36 S.E.P.A. REVIEW 3,000 1,480 2,960 40 37 CRITICAL AREA STUDY 14,000 4,455 5,975 8,025 38 GYM AND WEIGHT ROOM FEES 13,000 - 599 12,401 39 PROGRAM FEES 1,011,580 148,703 284,310 727,270 40 TAXABLE RECREATION ACTIVITIES 1,300 - - 1,300 41 HOLIDAY MARKET REGISTRATION FEES 5,000 185 - 5,000 42 WINTERMARKET FEES - - 7,270 (7,270) 43 BIRD FEST REGISTRATION FEES 1,000 - - 1,000 44 INTERFUND REIMBURSEMENT -CONTRACT SVCS 4,011,558 1,121,306 392,832 3,618,726 7,261,358 2,003,614 1,310,907 5,950,451 74°r 7 °i 4°/ 1 °/ 0°/ 0°r 0°/ 501 101°/ 0°i 0°r 0°/ Q. 501 N 0°/ 50°1 .0 206°/ 54°/ _ 18° iL 0°/ >, 0°/ t r� 25°/ 0°/ 0 62°/ N 29°r C 18°i N 6°i =i 92°r Q 6°/ Q 24°r r 58°/ OQ 0°/ d 55°r W 21 ° rp 122°i t� 22°/ 99°i 43°/ LL 5° >' 28°/ 0°/ O 0 2 0°/ N cm 0°r O 10°i N 180, .Q a a 22 Packet Pg. 25 2.1.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Revenues Revenues Remaining %Received FINES AND PENALTIES: 1 PROOF OF VEHICLE INS PENALTY 2 TRAFFIC INFRACTION PENALTIES 3 NC TRAFFIC INFRACTION 4 CRT COST FEE CODE LEG ASSESSMENT (LGA) 5 NON -TRAFFIC INFRACTION PENALTIES 6 OTHER INFRACTIONS'04 7 PARKING INFRACTION PENALTIES 8 PARK/INDDISZONE 9 DWI PENALTIES 10 DUI - DP ACCT 11 CRIM CNV FEE DUI 12 DUI - DP FEE 13 CRIMINAL TRAFFIC MISDEMEANOR 8/03 14 CRIMINAL CONVICTION FEE CT 15 CRIM CONV FEE CT 16 OTHER NON-T RAF MISDEMEANOR PEN 17 OTHER NON TRAFFIC MISD. 8/03 18 COURT DV PENALTY ASSESSMENT 19 CRIMINAL CONVICTION FEE CN 20 CRIM CONV FEE CN 21 PUBLIC DEFENSE RECOUPMENT 22 BANK CHARGE FOR CONV. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIESRENTALS 30 BRACKET ROOM RENTAL 31 LEASESLONG-TERM 32 DONATION/CONTRIBUTION 33 PARKS DONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHERJUDGEMENT/S'ETTLEMENT 40 POLICE JUDGMENT SREST IT UT ION 41 CASHIERS OVERAGES/SHORTAGES 42 OTHER MISC REVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - MUNICIPAL COURT 46 NSF FEES -POLICE 47 NSF FEES - DEVELOPMENT SERVICES 48 US BANK REBATE TRANSFERS -IN: 49 TRANSFER FROM FUND 127 TO TAL GENERAL FUND REVENUE $ 2,000 $ 1,083 $ 567 $ 1,433 280/ 230,000 73,311 20,907 209,093 90/ 18,000 3,605 1,788 16,212 100/ 10,000 5,718 1,308 8,692 130/ 1,000 203 - 1,000 00/ 1,500 840 254 1,246 170/ 100,000 20,937 5,190 94,810 501 2,000 250 100 1,900 501 7,000 2,981 1,079 5,921 1501 300 16 26 274 90/ 100 59 9 91 90/ 1,500 676 579 921 390/ 25,000 4,445 3,577 21,423 140/ 2,000 563 573 1,427 290/ 700 19 37 663 50/ 100 12 - 100 00/ 10,000 431 1,089 8,911 110/ 800 15 12 788 20/ 1,000 41 142 858 140/ 200 36 - 200 00/ 8,000 1,327 1,404 6,596 180/ 14,000 3,218 1,043 12,957 70/ 3,000 797 74 2,926 20/ 10,100 - 50 10,050 00/ 150 - - 150 00/ 448,450 1209582 39,808 408,642 270,390 132,525 88,188 182,202 330/ 13,340 2,824 1,645 11,695 120/ 10,180 2,696 2,121 8,059 210/ 153,000 7,811 23,556 129,444 1501 2,100 - - 2,100 00/ 205,000 64,449 68,746 136,254 340/ 2,500 - 239 2,261 100/ 3,500 - 2,300 1,200 660/ 1,500 350 370 1,130 250/ 5,000 - 249 4,751 501 300 - 84 216 280/ 3,800 3,185 996 2,804 260/ 2,000 - - 2,000 00/ 2,000 102 - 2,000 00/ 200 30 30 170 1501 - 2 100 (100) 00/ 41,180 4,122 808 40,372 20/ 100 34 26 74 260/ 100 30 - 100 00/ 150 - - 150 00/ - 30 - - 00/ - - 60 (60) 00/ 8,500 4,966 3,896 4,604 460/ 724,840 223,155 193,414 531,426 270, 26,300 - - 26,300 00/ 26,300 - - 26,300 00, $ 44,640,708 $11,029,475 $10,451,247 $ 34,189,461 230, w Q 23 Packet Pg. 26 I 2.1.a I Page 1 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 19,196,413 $ 5,620,596 $ 5,753,269 $ 13,443,144 300 2 OVERTIME 594,080 185,729 381,107 212,973 640 3 HOLIDAY BUY BACK 294,001 1,951 8,212 285,789 M 4 BENEFITS 6,820,049 2,125,750 2,148,219 4,671,830 314 5 UNIFORMS 119,151 26,774 23,139 96,012 190 6 PENSION AND DISABILITY PAYMENTS 70,944 - 23,649 47,295 330 7 SUPPLIES 481,165 143,762 106,353 374,812 224 8 FUEL CONSUMED - 17 - - V 9 SMALL EQUIPMENT 204,019 67,834 36,646 167,373 180 10 PROFESSIONAL SERVICES 17,411,043 4,461,965 5,041,380 12,369,663 29° 11 COMMUNICATIONS 171,235 52,306 41,760 129,475 244 12 TRAVEL 81,155 1,779 9,382 71,773 120 13 EXCISE TAXES 16,500 7,672 10,566 5,934 640 14 RENTAL/LEASE 2,091,693 509,599 676,603 1,415,091 324 15 INSURANCE 503,161 405,121 503,160 1 10V 16 UTILITIES 529,462 169,063 195,426 334,036 370 17 REPAIRS& MAINT ENANCE 1,090,350 225,110 213,762 876,588 200 18 MISCELLANEOUS 652,023 177,934 201,492 450,531 314 19 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 50,000 - 1000 20 BUILDINGS - - 45,195 (45,195) V 21 INTERFUND SUBSIDIES 1,385,000 - - 1,385,000 04 22 MACHINERY/EQUIPMENT - - - - 0° 23 CONSTRUCTION PROJECTS 270,180 - - 270,180 M 24 GENERAL OBLIGATION BOND PRINCIPAL 55,170 - - 55,170 09 25 INTEREST ON LONG-TERM EXTERNAL DEBT 4,790 - - 4,790 04 26 DEBT ISSUE COSTS 268,788 - - 268,788 M 27 OTHER INTEREST & DEBT SERVICE COSTS 500 - 212 288 420 52,360,872 14,232,961 15,469,533 36,891,339 300 LEOFF-MEDICAL INS. RESERVE(009) 28 BENEFITS $ - $ 79,133 $ 76,230 $ (76,230) 00 29 PENSION AND DISABILITY PAYMENTS 252,990 45,375 30,384 222,606 120 30 PROFESSIONAL SERVICES 7,000 - 7,000 - 10V 31 MISCELLANEOUS 500 - 485 15 970 260,490 124,508 114,099 146,391 44U HISTORIC PRESERVATION GIFTFUND (014) 32 SUPPLIES $ 100 $ $ - $ 100 V 33 PROFESSIONAL SERVICES 200 - 200 04 34 MISCELLANEOUS 5,600 - 5,600 V 5,900 - 5,900 04 BUILDING MAINTENANCE FUND (016) 35 PROFESSIONAL SERVICES $ 195,000 $ - $ 450 $ 194,550 04 36 REPAIR & MAINTENANCE 150,000 - 16,072 133,928 110 37 MACHINERY/EQUIPMENT 90,000 - 552 89,448 1° 38 CONSTRUCTION PROJECTS 110,000 - - 110,000 V 545,000 - 17,074 527,926 34 EDMONDS HOMELESSNESS RFSPONSEFUND (018) 39 PROFESSIONAL SERVICES $ 200,000 $ - $ - $ 200,000 V 200,000 - - 200,000 V DRUG ENID RC EMENT FUND (104) 40 PROFESSIONAL SERVICES $ 45,000 $ - $ - $ 45,000 04 41 REPAIR/MAINT 800 - - 800 V 45,800 - - 45,800 V O Q. N 2 C ev C LL t C O 2 N N O N �L CL a O O. d <0 C O C iL z r C O 2 N N O N �L Q. a C N 1= t c� r a 24 Packet Pg. 27 I 2.1.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining yo Spent STREETFUND (111) 1 SALARIES AND WAGES $ 749,110 $ 247,515 $ 234,647 $ 514,463 314 2 OVERTIME 38,400 15,593 10,544 27,856 274 3 BENEFITS 347,919 121,604 114,387 233,532 330 4 UNIFORMS 6,000 5,432 3,912 2,088 650 5 SUPPLIES 263,000 29,162 42,781 220,219 16° 6 SMALL EQUIPMENT 20,000 770 587 19,413 39 7 PROFESSIONAL SERVICES 23,210 4,351 9,878 13,332 430 8 COMMUNICATIONS 4,500 2,280 1,825 2,675 414 9 TRAVEL 1,000 - - 1,000 0° 10 RENTAL/LEASE 290,150 81,865 96,149 194,001 330 11 INSURANCE 184,111 148,533 184,111 0 10W 12 UTILITIES 273,730 78,010 67,108 206,622 250 13 REPAIRS & MAINTENANCE 72,000 9,065 4,653 67,347 64 14 MISCELLANEOUS 8,000 10,278 10,891 (2,891) 1364 15 MACHINERY/EQUIPMENT 30,000 - - 30,000 0° 16 GENERAL OBLIGATION BOND PRINCIPAL 4,270 - - 4,270 W 17 INTEREST 380 - - 380 0° $ 2,315,780 $ 754,458 $ 781,473 $ 1,534,307 34° COMBINED STREETCONST/IMPROVE(112) 18 PROFESSIONAL SERVICES $ 3,159,560 $ 274,625 $ 187,251 $ 2,972,309 6° 19 REPAIR&MAINTENANCE 1,508,270 - 122 1,508,148 0° 20 INTERFUND SUBSIDIES 108,975 - - 108,975 M 21 LAND - (842) 36,264 (36,264) W 22 CONSTRUCTION PROJECTS 8,018,521 - 270,868 7,747,653 M 23 INTERGOVERNMENTAL LOANS 72,220 - - 72,220 M 24 INTEREST 1,250 - - 1,250 04 $ 12,868,796 $ 273,782 $ 494,505 $ 12,374,291 4° MUNICIPAL ARTS ACQUIS. FUND (117) 25 SUPPLIES $ 4,700 $ 217 $ 36 $ 4,664 14 26 SMALL EQUIPMENT 1,700 - - 1,700 W 27 PROFESSIONAL SERVICES 180,000 11,622 12,883 167,117 74 28 TRAVEL 80 - - 80 W 29 RENTAL/LEASE 2,000 2,000 09 30 REPAIRS & MAINTENANCE 300 - - 300 M 31 MISCELLANEOUS 6,600 612 1,025 5,575 164 $ 195,380 $ 12,451 $ 13,945 $ 181,435 74 HO TEL/MO TEL TAX REVENUE FUND (120) 32 PROFESSIONAL SERVICES $ 95,900 $ 13,510 $ 12,011 $ 83,889 1M 33 MISCELLANEOUS 1,000 - - 1,000 04 34 INTERFUND SUBSIDIES 4,000 - - 4,000 W $ 100,900 $ 13,510 $ 12,011 $ 88,889 12° EMPLO YEE PARKING PERMIT FUND (121) 35 SUPPLIES $ 1,790 $ - $ - $ 1,790 M 36 PROFESSIONAL SERVICES 25,090 - - 25,090 M $ 26,880 $ - $ - $ 26,880 W YOUTH SCHOLARSHIP FUND (122) 37 MISCELLANEOUS $ 3,000 $ $ - $ 3,000 0° $ 3,000 $ $ $ 3,000 04 TOURISM PROMOTIONAL FUND/ARTS (123 ) 38 PROFESSIONAL SERVICES $ 28,200 $ $ - $ 28,200 M $ 28,200 $ - $ - $ 28,200 0° a 25 Packet Pg. 28 I 2.1.a I Page 3 of 6 CITY OFEDMONDS EXPENDITURES BY FUND - DETAIL 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXC ISE TAX 2 (125) 1 SUPPLIES $ 21,000 $ 22,938 $ 8,378 $ 12,622 409 2 PROFESSIONAL SERVICES 469,320 26,956 76,748 392,572 169 3 REPAIRS&MAINTENANCE 668,258 5,070 56,168 612,090 M 4 INTERFUND SUBSIDIES 2,534 - - 2,534 09 5 CONSTRUCTION PROJECTS 3,428,576 - 412,144 3,016,432 129 $ 4,589,688 $ 54,964 $ 553,438 $ 4,036,250 129 REAL ESTATE EXCISE TAXI (126) 6 PROFESSIONAL SERVICES 7 REPAIRS & MAINTENANCE 8 INTERFUND SUBSIDIES 9 CONSTRUCTION PROJECTS 10 GENERAL OBLIGATION BONDS 11 INTEREST 12 OTHER INTERESI' & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 13 SUPPLIES 14 PROFESSIONAL SERVICES 15 MISCELLANEOUS 16 INTERFUND SUBSIDIES CEMEIERY MAINTENANCEINWRO VEMENT (130) 17 SALARIES AND WAGES 18 OVERTIME 19 BENEFIT S 20 UNIFORMS 21 SUPPLIES 22 SUPPLIES PURCHASED FOR INVENTORY/RESALE 23 PROFESSIONAL SERVICES 24 COMMUNICATIONS 25 TRAVEL 26 RENTAL/LEASE 27 UTILITIES 28 REPAIRS & MAINTENANCE 29 MISCELLANEOUS PARKS TRUSTFUND (136) 30 PROFESSIONAL SERVICES CEMETERY MAINTENANCE TRUST FUND (137) 31 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 32 SUPPLIES 33 TRAVEL 34 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 35 SUPPLIES 36 PROFESSIONAL SERVICES 37 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 38 PROFESSIONAL SERVICES TREE FUND (143) 39 SUPPLIES 40 PROFESSIONAL SERVICES 41 LAND 2012 LTGO DEBT SERVIC FUND (231) 42 GENERAL OBLIGATION BOND 43 INTEREST $ 673,827 $ 101,624 $ 22,913 $ 650,914 M 878,353 14,138 13,266 865,087 29 144,970 - - 144,970 09 526,057 122,857 97,473 428,584 199 149,820 - - 149,820 09 110,640 - - 110,640 09 - - 380 (380) M $ 2,483,667 $ 238,618 $ 134,032 $ 2,349,635 59 $ 45,000 $ 10,981 $ 2,462 $ 42,538 59 6,500 - - 6,500 09 600 - - 600 09 26,300 - - 26,300 M $ 78,400 $ 10,981 $ 2,462 $ 75,938 M $ 119,837 $ 27,896 $ 29,146 $ 90,691 240 3,500 150 239 3,261 79 41,069 12,623 12,533 28,536 319 1,000 - - 1,000 09 7,000 107 45 6,955 19 20,000 7,497 8,241 11,759 419 4,200 800 800 3,400 199 1,700 561 572 1,128 349 500 - - 500 09 11,690 5,550 3,897 7,793 339 5,565 1,147 1,121 4,444 209 500 - - 500 09 4,000 2,567 3,868 132 970 $ 220,561 $ 58,898 $ 60,462 $ 160,099 279 $ 50,000 $ - $ - $ 50,000 09 $ 50,000 $ - $ - $ 50,000 09 $ 25,000 $ - $ - $ 25,000 09 $ 25,000 $ - $ - $ 25,000 09 $ 1,500 $ - $ - $ 1,500 M 4,500 - - 4,500 M 5,900 - - 5,900 09 $ 11,900 $ - $ - $ 11,900 09 $ 4,050 $ 273 $ 466 $ 3,584 119 77,535 17,651 15,643 61,892 200 6,095 669 189 5,906 39 87,680 18,593 16,298 71,382 199 $ 6,077,492 $ - $ 295,776 $ 5,781,716 59 6,077,492 - $ 295,776 $ 5,781,716 59 $ 1,000 $ $ $ 1,000 M 14,800 - 14,800 09 199,000 - 199,000 M 214,800 - 214,800 09 $ 550,000 $ - $ - $ 550,000 09 61,370 - - 61,370 M $ 611,370 $ - $ - $ 611,370 09 O Q. d Ta C eo C .E- LL L C O 2 N N O N �L O. Q O Q d <0 C R C iL z C O E N N O N a r-� C N 1= t t� R r Q 26 Packet Pg. 29 I 2.1.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 95,832 $ 67,357 $ 127,454 $ (31,622) 13M 2 INTERFUND SUBSIDIES 63,000 - 62,656 344 999 3 CONSTRUCTION PROJECTS 7,357,188 73,121 1,847,115 5,510,073 250 4 DEBT ISSUE COSTS 98,398 - - 98,398 M $ 7,614,418 $ 140,478 $ 2,037,225 $ 5,577,193 270 WATER FUND (421) 5 SALARIES AND WAGES 6 OVERTIME 7 BENEFIT S 8 UNIFORMS 9 SUPPLIES 10 WATER PURCHASED FOR RESALE 11 SUPPLIES PURCHASED FOR INVENTORY/RESALE 12 SMALL EQUIPMENT 13 PROFESSIONAL SERVICES 14 COMMUNICATIONS 15 TRAVEL 16 EXCISE TAXES 17 RENTAL/LEASE 18INSURANCE 19 UTILITIES 20 REPAIRS & MAINTENANCE 21 MISCELLANEOUS 22 INTERFUND SUBSIDIES 23 MACHINERY/EQUIPMENT 24 CONSTRUCTION PROJECTS 25 GENERAL OBLIGATION BONDS 26 REVENUE BONDS 27 INTERGOVERNMENTAL LOANS 28 INTEREST 29 OTHER INT EREST & DEBT SERVICE COSTS STORM FUND (422) 30 SALARIES AND WAGES 31 OVERTIME 32 BENEFIT S 33 UNIFORMS 34 SUPPLIES 35 SMALL EQUIPMENT 36 PROFESSIONAL SERVICES 37 COMMUNICATIONS 38 TRAVEL 39 EXCISE TAXES 40 RENTAL/LEASE 41 INSURANCE 42 UTILITES 43 REPAIR & MAINTENANCE 44 MISCELLANEOUS 45 INTERFUND SUBSIDIES 46 CONSTRUCTION PROJECTS 47 GENERAL OBLIGATION BONDS 48 REVENUE BONDS 49 INTERGOVERNMENTAL LOANS 50 INTEREST 51 OTHER INT EREST & DEBT SERVICE COSTS $ 842,096 $ 223,949 $ 255,783 $ 586,313 3M 24,000 6,079 4,561 19,439 199 330,100 95,239 106,858 223,242 329 4,000 2,179 1,913 2,087 489 150,000 25,738 50,199 99,801 3M 2,170,000 260,968 398,457 1,771,543 189 170,000 77,184 71,614 98,386 429 11,000 3,917 2,527 8,473 239 2,237,439 358,686 223,634 2,013,805 109 30,000 9,262 9,089 20,911 3M 200 - - 200 09 1,649,700 424,636 415,560 1,234,140 259 152,590 41,065 50,376 102,214 339 122,359 98,196 122,359 (0) 10M 35,000 11,201 12,162 22,838 359 176,130 11,030 11,609 164,521 79 123,600 66,640 73,488 50,112 599 645,370 - - 645,370 09 10,000 - - 10,000 09 1,998,334 - 87,212 1,911,122 49 2,870 - - 2,870 09 399,780 - - 399,780 09 25,840 - - 25,840 09 180,580 - - 180,580 09 - - 378 (378) M $ 11,490,988 $ 1,715,970 $ 1,897,778 $ 9,593,210 179 $ 734,284 $ 237,035 $ 260,998 $ 473,286 369 26,000 12,794 8,503 17,497 339 294,767 103,989 107,248 187,519 369 6,500 4,555 5,543 957 859 46,000 16,177 25,208 20,792 559 4,000 304 587 3,413 159 3,481,263 449,989 285,011 3,196,252 89 3,200 2,017 1,555 1,645 499 4,300 150 - 4,300 09 470,100 223,956 245,680 224,420 529 267,150 88,199 88,054 179,096 339 82,335 66,228 82,335 (0) 1009 10,500 5,134 5,701 4,799 549 67,130 19,187 11,040 56,090 169 232,300 100,872 80,388 151,912 359 297,787 - - 297,787 09 3,137,333 - 194,065 2,943,268 69 104,540 - - 104,540 09 195,390 - - 195,390 09 53,590 - - 53,590 09 101,180 - - 101,180 09 - - 165 (165) 09 $ 9,619,649 $ 1,330,584 $ 1,402,081 $ 8,217,568 159 O a d Ta C eo C .E- LL 21 t C O 2 N N O N �L a a O a C O C iL 21 s C O 2 N N O N �L a a C N t t� R r a 27 Packet Pg. 30 I 2.1.a I Page 5 of 6 CITY OF EDMO NDS EXPENDPTURES BY FUND - DETAIL 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,090,461 $ 594,159 $ 608,327 $ 1,482,134 299 2 OVERTIME 95,000 41,609 52,157 42,843 559 3 BENEFITS 847,408 258,494 240,616 606,792 289 4 UNIFORMS 9,500 7,291 5,839 3,661 619 5 SUPPLIES 421,000 134,972 92,496 328,504 229 6 FUEL CONSUMED 60,000 30,050 - 60,000 09 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 09 8 SMALL EQUIPMENT 35,000 70,326 91,475 (56,475) 2619 9 PROFESSIONAL SERVICES 2,315,884 1,322,635 770,350 1,545,534 339 10 COMMUNICATIONS 43,000 13,568 14,069 28,931 339 11 TRAVEL 5,000 1,580 - 5,000 09 12 EXCISE TAXES 978,000 366,321 311,979 666,021 329 13 RENTALILEASE 317,410 135,541 108,391 209,019 349 14INSURANCE 202,407 162,851 203,936 (1,529) 1019 15 UTILITIES 1,532,060 499,573 775,108 756,952 519 16 REPAIR & MAINTENANCE 790,630 55,269 332,387 458,243 429 17 MISCELLANEOUS 126,350 52,198 62,611 63,739 509 18 INTERFUND SUBSIDIES 6,388,519 - - 6,388,519 09 19 CONSTRUCTION PROJECTS 12,520,297 2,529,639 1,564,772 10,955,525 129 20 GENERAL OBLIGATION BONDS 126,500 - - 126,500 09 21 REVENUE BONDS 89,840 - - 89,840 09 22 INTERGOVERNMENTAL LOANS 174,610 15,047 15,397 159,213 99 23 INTEREST 356,980 2,986 2,786 354,194 19 24 DEBT ISSUE COSTS - 1,518 - - 09 25 OTHER INTEREST & DEBT SERVICE COSTS - 2,252 2,959 (2,959) 09 $ 29,529,856 $ 6,297,879 $ 5,255,655 $ 24,274,201 189 BOND RESERVEFUND (424) 26 REVENUE BONDS $ 810,010 $ $ $ 810,010 09 27 INTEREST 1,178,700 1,178,700 09 $ 1,988,710 $ $ $ 1,988,710 09 O t?. d C eo C LL 21 L r., C O 2 N N O N �L O. a O O. d w C M C iL z r C O a N N O N �L a E M a 2s Packet Pg. 31 I 2.1.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent EQUIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 275,712 $ 91,289 $ 100,011 $ 175,701 369 2 OVERTIME 2,000 1,573 222 1,778 119 3 BENEFITS 112,077 38,292 38,654 73,423 349 4 UNIFORMS 1,500 928 742 758 499 5 SUPPLIES 120,000 18,316 50,526 69,474 429 6 FUEL CONSUMED 1,000 - - 1,000 09 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 268,000 58,493 160,901 107,099 609 8 SMALL EQUIPMENT 58,000 5,892 2,072 55,928 49 9 PROFESSIONAL SERVICES 46,750 418 486 46,264 19 10 COMMUNICATIONS 3,000 755 685 2,315 239 11 TRAVEL 1,000 - - 1,000 09 12 RENTAL/LEASE 11,160 4,133 3,438 7,722 319 13 INSURANCE 49,172 39,334 51,903 (2,731) 1069 14 UTILITIES 14,000 6,869 8,256 5,744 599 15 REPAIRS&MAINTENANCE 60,000 8,525 11,896 48,104 209 16 MISCELLANEOUS 12,000 1,852 1,711 10,289 149 17 MACHINERY/EQUIPMENT 915,000 61,687 24,640 890,360 39 $ 1,950,371 $ 338,356 $ 456,143 $ 1,494,228 239 TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 442,074 $ 105,256 $ 88,632 $ 353,442 209 19 OVERTIME 2,000 909 - 2,000 09 20 BENEFITS 159,538 33,761 35,215 124,323 229 21 SUPPLIES 5,000 1,864 2,340 2,660 479 22 SMALL EQUIPMENT 357,900 8,894 18,458 339,442 59 23 PROFESSIONAL SERVICES 61,860 13,894 4,736 57,124 M 24 COMMUNICATIONS 58,770 17,696 16,191 42,579 2M 25 TRAVEL 1,500 - - 1,500 09 26 RENTAL/LEASE 7,460 1,467 1,487 5,973 209 27 REPAIRS & MAINT ENANCE 381,920 219,602 377,903 4,017 999 28 MISCELLANEOUS 5,000 1,046 60 4,940 19 29 MACHINERY/EQUIPMENT 56,000 - - 56,000 09 $ 1,539,022 $ 404,389 $ 545,022 $ 994,000 359 FIREMAN'S PENSION FUND (617) 30 BENEFITS $ - $ 11,684 $ - $ - 09 31 PENSION AND DISABILITY PAYMENTS 20,507 - M $ - $ 32,192 $ - $ - 09 TOTAL EXPENDITURE ALL FUNDS $ 147,140,570 $ 26,053,570 $ 29,559,012 $ 117,581,558 209 O Q. N C O C LL 21 L C O 2 N N O N �L Q. a O Q. d w C O C iL z r C O a N N O N E. a E M a 29 Packet Pg. 32 2.1.a Page 1 of 1 C ITY O F IDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT CITY CLERK ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPARTMENTAL POLICE SERVICES SATELLITE OFFICE COMMUNITY SERVICES✓ECONOMIC DEV DEVELOPMENT SERVICES HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE Title $ 497,900 $ 110,738 $ 100,819 $ 397,081 20% 443,913 111,352 119,372 324,541 27% 824,831 252,612 270,474 554,357 33% 1,368,755 359,370 386,046 982,709 28% - 272,337 - - 0% 2,156,911 402,835 722,690 1,434,221 34% G Q. 971,780 282,407 287,018 684,762 30% LY 15,574,121 4,484,023 5,036,007 10,538,114 32% Ta Z 13,375,470 3,802,023 4,001,453 9,374,017 30% 166,576 - 32,569 134,007 20% C 'L 719,388 157,909 179,118 540,270 25% t 3,791,859 934,573 1,157,411 2,634,448 31% r� C 2 459,109 19,434 30,660 428,449 7% N N 5,125,535 1,273,239 1,354,932 3,770,603 26% N 3,459,449 1,058,659 1,008,792 2,450,657 29% 'Q 3,425,275 711,450 782,173 2,643,102 23% Q $ 52,360,872 $ 14,232,961 $ 15,469,533 $ 36,891,339 30% O C. O lY CITY OF EDMO NDS C EXPENDITURES - UTILITY- BY FUND IN SUMMARY jL 2022 Amended 4/30/2021 4/30/2022 Amount z Budget Expenditures Expenditures Remaining %Spent C WATER UTILITYFUND $ 11,490,988 $ 1,715,970 $ 1,897,778 $ 9,593,210 17% n STORM UTILITY FUND 9,619,649 1,330,584 1,402,081 8,217,568 15% N N N SEWER/WWTP UTILITY FUND 29,529,856 6,297,879 5,255,655 24,274,201 18% .Q BOND RESERVE FUND 1,988,710 - - 1,988,710 0% Q +. $ 52,629,203 $ 9,344,433 $ 8,555,514 $ 44,073,689 16% CD t t� R r Q 30 Packet Pg. 33 I 2.1.a I Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2022 Amended Budget 4/30/2021 Expenditures 4/30/2022 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES AND WAGES $ 204,132 $ 66,636 $ 58,538 $ 145,594 29% BENEFITS 121,868 34,891 31,073 90,795 25% SUPPLIES 2,000 1,494 236 1,764 12% SERVICES 169,900 7,716 10,972 158,928 6% $ 497,900 $ 110,738 $ 100,819 $ 397,081 20% O FFIC E O F MAYO R SALARIES AND WAGES $ 232,296 $ 76,498 $ 82,732 $ 149,564 36% BENEFITS 81,787 28,170 28,764 53,023 35% SUPPLIES 1,500 246 1,539 (39) 103% SERVICES 128,330 6,438 6,338 121,992 5% O $ 443,913 $ 111,352 $ 119,372 $ 324,541 27% HUMAN RESOURCES tY SALARIES AND WAGES $ 398,299 $ 132,514 $ 155,103 $ 243,196 39% BENEFITS 142,526 54,568 54,486 88,040 38% .� SUPPLIES 13,600 845 362 13,238 3% SERVICES 270,406 64,685 60,524 209,882 22% C $ 824,831 $ 252,612 $ 270,474 $ 554,357 33% LL MUNICIPAL C O URT t SALARIES AND WAGES $ 910,606 $ 230,032 $ 254,416 $ 656,190 28% C BENEFITS 217,654 75,101 74,845 142,809 34% 0 SUPPLIES 11,600 2,054 4,268 7,332 37% N SERVICES 228,895 52,184 52,517 176,378 23% C $ 1,368,755 $ 359,370 $ 386,046 $ 982,709 28% N CITY CLERK i SALARIES AND WAGES $ - $ 133,261 $ - $ 0% Q' Q BENEFITS - 54,054 - 0% SUPPLIES - 493 - 0% O SERVICES - 84,529 - 0% CL 4) d $ - $ 272,337 $ - $ - 0% w ADMINIS TRATIVE S ERVIC ES ea SALARIES AND WAGES $ 1,301,073 $ 247,246 $ 446,175 $ 854,898 34% _ BENEFITS 413,858 81,170 146,447 267,411 35% SUPPLIES 13,000 1,644 4,781 8,219 37% jL SERVICES 428,980 72,774 125,287 303,693 29% >% $ 2,156,911 $ 402,835 $ 722,690 $ 1,434,221 34% r CITY ATPO RNEY O SERVICES $ 971,780 $ 282,407 $ 287,018 $ 684,762 30% Z $ 971,780 $ 282,407 $ 287,018 $ 684,762 30% N NON -DEPARTMENTAL o SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% N BENEFITS 145,504 24,849 35,472 110,032 24% Q. SUPPLIES 5,000 71 - 5,000 0% Q SERVICES 13,557,619 4,409,103 4,950,323 8,607,296 37% INTERFUND SUBSIDIES 1,435,000 50,000 50,000 1,385,000 3% N DEBT SERVICE - PRINCIPAL 55,170 - - 55,170 0% DEBT SERVICE - INTEREST 274,078 212 273,866 0% V $ 15,574,121 $ 4,484,023 $ 5,036,007 $ 10,538,114 32% PO LIC E SERVIC ES Q SALARIES AND WAGES $ 8,723,512 $ 2,520,875 $ 2,646,287 $ 6,077,225 30% BENEFITS 2,994,876 892,546 927,186 2,067,690 31% SUPPLIES 281,569 110,746 38,354 243,215 14% SERVICES 1,375,513 277,856 389,626 985,887 28% $ 13,375,470 $ 3,802,023 $ 4,001,453 $ 9,374,017 30% SATELLITE O FFIC E SALARIES AND WAGES $ 25,000 $ - $ - $ 25,000 0% BENEFIT S 5,000 - 5,000 0% SUPPLIES 12,000 11,057 943 92% SERVICES 124,576 21,512 103,064 17% $ 166,576 $ $ 32,569 $ 134,007 20% 31 Packet Pg. 34 1 Page 2 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2022 Amended 4/30/2021 4/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY SERVICES/ECON DEV. SALARIES AND WAGES $ 365,627 $ 95,484 $ 66,566 $ 299,061 18% BENEFITS 111,361 28,322 21,559 89,802 19% SUPPLIES 4,075 111 269 3,806 7% SERVICES 238,325 33,993 90,725 147,600 38% $ 719,388 $ 157,909 $ 179,118 $ 540,270 25% DEVELO PMEVT S ERVIC ES /PLANNING SALARIES AND WAGES $ 1,978,832 $ 581,467 $ 697,722 $ 1,281,110 35% BENEFITS 681,706 213,071 239,274 442,432 35% SUPPLIES 19,400 1,836 2,391 17,009 12% SERVICES 1,111,921 138,199 218,023 893,898 20% MACHINERY/EQUIPMENT 0% $ 3,791,859 $ 934,573 $ 1,157,411 $ 2,634,448 31% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 101,496 $ 15,657 $ 18,045 $ 83,451 18% BENEFITS 29,113 3,575 3,608 25,505 12% SUPPLIES 15,000 - 412 14,588 3% SERVICES 313,500 201 8,596 304,904 3% 459,109 19,434 30,660 428,449 7% PARKS & REC REATIO N SALARIES AND WAGES $ 2,627,863 $ 749,976 $ 768,051 $ 1,859,812 29% BENEFITS 865,945 274,592 267,512 598,433 31% SUPPLIES 166,640 41,362 47,487 119,153 28% SERVICES 1,465,087 207,309 271,881 1,193,206 19% $ 5,125,535 $ 1,273,239 $ 1,354,932 $ 3,770,603 26% PUBLIC WORKS ADMINISTRATION SALARIES AND WAGES $ 387,424 $ 99,794 $ 44,179 $ 343,245 11% BENEFITS 126,689 35,198 21,265 105,424 17% SUPPLIES 9,600 6,356 1,543 8,057 16% SERVICES 90,400 29,311 27,569 62,831 30% $ 614,113 $ 170,658 $ 94,556 $ 519,557 15% FACILITIFS MAINTENANCE SALARIES AND WAGES 860,456 272,806 289,213 571,243 34% BENEFITS 369,679 116,354 114,007 255,672 31% SUPPLIES 128,000 43,561 30,301 97,699 24% SERVICES 1,796,960 278,730 303,457 1,493,503 17% MACHINERY/EQUIPMENT 270,180 - 45,195 224,986 17% $ 3,425,275 $ 711,450 $ 782,173 $ 2,643,102 23% ENGINEERING SALARIES AND WAGES $ 1,866,128 $ 586,029 $ 615,563 $ 1,250,565 33% BENEFITS 702,578 236,062 229,510 473,068 33% SUPPLIES 2,200 795 - 2,200 0% SERVICES 274,430 65,114 69,162 205,268 25% $ 2,845,336 $ 888,001 $ 914,235 $ 1,931,101 32% TOTAL GENERAL FUND EXPENDITURES $ 52,360,872 $ 14,232,961 $ 15,469,533 $ 36,891,339 30% a 32 Packet Pg. 35 2.1.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 4/30/2022 4/30/2022 Q1 YTD Fund Balance Cash Balance 001-General Fund ' $ 10,913,064 $ 3,435,725 $ (4,571,033) $ (5,018,286 009-Leoff-Medical Ins. Reserve 141,119 141,119 (88,086) (114,099 011-Risk Management Reserve Fund 25,000 25,000 - - 0 012-Contingency Reserve Fund 1,782,150 1,782,150 - - 014-Historic Preservation Gift Fund 16,422 16,421 - - 016-Building Maintenance 4,393,818 4,393,818 (1,263) (6,182 017 - Marsh Restoration & Preservation 848,617 848,616 - - ii Total General Fund & Subfunds $ 18,120,189 $ 10,642,849 $ (4,660,382) $ (5,138,567 >, t r c 0 *$8,067,160 of the fund balance in Fund 001 added to the $1,78150 balance in Fund 012, represent the 2, required N 20% operating reserve. N There are no interfund loans outstanding at this time. a Q 1` 0 Q. m GOVERNMENTAL FUNDS OVERVIEW LL 21 0 BALANCES CHANGE IN FUND BALANCES 2 N ---- ACTUAL ---- ---- ACTUAL ---- o N GOVERNMENTAL FUNDS 4/30/2022 4/30/2022 Q1 YTD Fund Balance Cash Balance Q General Fund & Subfunds $ 18,120,189 $ 10,642,849 $ (4,660,382) $ (5,138,567 E Special Revenue 19,141,181 17,933,062 669,865 762,459 Capital Projects 2,884,848 3,135,015 (822,073) (1,229,015 c� Q Total Governmental Funds $ 40,146,218 $ 31,710,926 $ (4,812,590) $ (5,605,123 *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 33 Packet Pg. 36 2.1.a SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 4/30/2022 4/30/2022 Q1 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 75,850 $ 76,350 $ 578 $ 675 111 - Street Fund 601,029 463,485 (290,638) (350,136 112 - Combined Street Const/Improve 2,841,257 2,027,285 671,892 602,810 117 - Municipal Arts Acquis. Fund 718,181 721,643 64,290 69,302 Q 120 - Hotel/Motel Tax Revenue Fund 85,552 72,314 11,410 14,437 121 - Employee Parking Permit Fund 87,580 87,974 8,246 11,056 �a 122 - Youth Scholarship Fund 14,388 14,460 110 128 123 -Tourism Promotional Fund/Arts 105,429 101,363 7,199 9,457 125 - Real Estate Tax2 4,119,520 4,044,636 4,384 66,105 u_ 126 - Real Estate Excise Tax 1 * 3,793,224 3,622,138 290,145 479,885 21 127 - Gifts Catalog Fund 373,467 375,049 63,468 71,942 0 130- Cemetery Mai ntenance/Improve ment 271,558 272,966 6,013 5,352 M 136 - Parks Trust Fund 170,101 170,968 1,294 1,511 N 137 - Cemetery Maintenance Trust Fund 1,124,066 1,129,763 14,031 16,991 N 138- Sister City Comm ission 15,619 15,699 119 139 140 -Business Improvement Disrict 63,242 63,242 26,311 34,110 Q 141 -Affordable and Supportive Housing I'd 183,701 176,308 23,034 24,287 142 - Edmonds Rescue Plan Fund 4,476,604 4,476,604 (232,175) V_ (295,776 143 -Tree Fund 20,816 20,816 157 183 m Total Special Revenue $ 19,141,181 $ 17,933,062 $ 669,865 $ 762,459 *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $500,000 for 'u the purchase of Open Space. ii ENTERPRISE FUNDS OVERVIEW O 2 N N O N BALANCES CHANGE IN FUND BALANCES L a ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- Q :.o FUNDS 4/30/2022 4/30/2022 Q1 YTD Fund Balance Cash Balance a� E t v 421 -Water Utility Fund $ 30,015,020 $ 7,856,422 $ 1,131,430 $ 1,287,852 Q 422 -Storm Utility Fund " 16,646,449 6,572,801 841,415 999,071 423 - Sewer/WWTP Utility Fund 61,853,209 16,598,607 1,424,379 1,500,680 424 - Bond Reserve Fund 844,474 844,474 3 514 411 -Combined Utility Operation 59,500 106,309 46,790 59,500 Total Enterprise Funds 1 $ 109,418,652 $ 31,978,613 1 $ 3,444,017 $ 3,847,617 *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding. *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 34 Packet Pg. 37 2.1.a SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 4/30/2022 4/30/2022 Q1 YTD Fund Balance Cash Balance Governmental Funds $ 40,146,218 $ 31,710,926 $ (4,812,590) $ (5,605,123 Enterprise Funds 109,418,652 31,978,613 3,444,017 3,847,617 Internal Services Fund 10,286,191 5,869,220 (93,646) (1,360 0 n Total City-wide Total $ 159,851,062 $ 69,558,759 $ (1,462,219) $ (1,758,866 c c ii 21 INTERNAL SERVICE FUNDS OVERVIEW t 0 0 2 N N O N Q Q BALANCES CHANGE IN FUND BALANCES o INTERNAL SERVICE ---- ACTUAL ---- ---- ACTUAL ---- 0. FUNDS 4/30/2022 4/30/2022 Q1 YTD Fund Balance Cash Balance c 511 - Equipment Rental Fund $ 9,364,475 $ 5,120,226 $ 117,520 $ 155,964 u_ 21 512 -Technology Rental Fund 921,716 748,993 (211,166) (157,325 0 Total Internal Service Funds $ 10,286,191 $ 5,869,220 $ (93,646) $ (1,360 2 N N O N 'L Q Q E Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 35 Packet Pg. 38 2.2 City Council Agenda Item Meeting Date: 06/14/2022 2022 State Auditor Office (SAO) Audit Exit Follow Up Staff Lead: City Council Department: City Council Preparer: Beckie Peterson Background/History On March 29, 2022 during a Special Meeting, the Office of the Washington State Auditor presented to Council the Financial Statements and Federal Single Audit Report City of Edmonds For the period January 1, 2020 through December 31, 2020. As identified by the Auditor, there were a number of findings; a summary of uncorrected misstatements and a report of identified deficiencies of the city's internal control over major programs of federal awards. Staff Recommendation Council requests an update about the City's planned next steps in response to the auditor's findings. Narrative A number of findings require oversight by Council, including reviewing policies to ensure internal controls for management of federal funds, adequate compliance policies and policy on write-offs. Packet Pg. 39