The URL can be used to link to this page

2024-02-13 Council FIN Packet1 2 OF BbMG ti Agenda Edmonds City Council 1,00 FINANCE COMMITTEE CITY COUNCIL CONFERENCE ROOM 121 - 5TH AVENUE N, EDMONDS, WA 98020 FEBRUARY 13, 2024, 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. STAFF AND COUNCILMEMBERS ATTEND COMMITTEE MEETINGS VIRTUALLY, AND MEMBERS OF THE PUBLIC ARE ENCOURAGED TO ATTEND THE SAME WAY. 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 IF MEMBERS OF THE PUBLIC CANNOT ACCESS THE VIRTUAL COMMITTEE MEETINGS WITH THEIR PERSONAL DEVICES, A MONITOR IS PROVIDED ON CITY COUNCIL COMMITTEE NIGHTS FROM 3:30- 930 PM AT THE CITY COUNCIL CONFERENCE ROOM AT 121 5TH AVE N, EDMONDS WA. COMMITTEE MEMBERS: WILL CHEN (CHAIR), JENNA NAND, COUNCIL PRESIDENT (EX-OFFICIO MEMBER) CALL TO ORDER COMMITTEE BUSINESS 1. Committee Updates (10 min) 2. Opioid Funding (10 min) 3. 2024 February Budget Amendment (20 min) 4. Preliminary December 2023 Quarterly Financial Report (10 min) 5. Ordinance Establishing Authorized Employee Positions and Pay Ranges (15 min) ADJOURNMENT: 7:30 PM Edmonds City Council Agenda February 13, 2024 Page 1 2.1 City Council Agenda Item Meeting Date: 02/13/2024 Committee Updates Staff Lead: Committee Chair CM Chen Department: City Council Preparer: Beckie Peterson Background/History The purpose of this standing agenda item is to allow a mechanism for staff to provide committees with brief, verbal updates on an activity or project overseen by a department and so that the Council can be more aware of what is happening around the city. Updates will facilitate a better set of expectations for councilmembers, the public, and the staff. Recommendation N/A Narrative Requested Committee Updates for February 13, 2024: 1. OpenGov and ERP update Packet Pg. 2 2.2 City Council Agenda Item Meeting Date: 02/13/2024 Opioid Funding Staff Lead: Finance Department: Administrative Services Preparer: Scott Passey Background/History To inform Finance Committee Members how much funding the city expects to receive for opioid funding and how much cash we have as of January 1, 2024. Staff Recommendation For presentation only. Narrative According to state reporting, the City of Edmonds will be receiving $1.5 million in funding over 17 years to respond to and address the opioid crisis. Attachments: Opioid Funding Packet Pg. 3 2.2.a Finance Opioid Presentation February 13, 2024 a Packet Pg. 4 -1 ► 2.2.a Washington State Lawsuits on Opioid Epidemic Brief Overview 0 2021 Washington State reached a settlement w McKesson Corp, Cardinal Health Inc, and AmerisourceBergen Drug Corp w Washington state is set to receive $518 million over 17 years 0 2022 Washington joined a multistate resolution w CVS, Walgreens, Teva, and Allergan w Washington State is set to receive $371.8 million over 15 years 0 2024 Washington State reached a settlement (not reflected in Financial Statements) w Johnson & Johnson w Washington State is set to receive $149.5 million lump sum in 2024 fiscal year o Distribution to participating counties and cities is outlined in the MOU between Washington Municipalities Fairly complex allocation that had many factors o "All spending decisions must be consistent with the state Opioid Response Plan." AG Fer uson: Half -billion dollars to fiaht obioid ebidemic Will STarT flowina ec. LL 0 Q 0 0) _ LL 0 Q 0 a� E r a Packet Pg. 5 2.2.a What this means to our community According to the states latest calculation, the city will receive $1,510,717 over 17 years Total cash received as of January 1, 2024, is $74,1 19 Spending must be consistent with the states plan and/or we can work with other local municipalities and pool funds for a larger impact. _ _ U- Q 0 CM LL .o Q 0 E M 0 a Packet Pg. 6 2.2.a Snohomish County and Cities Snohomish County Snohomish Co,mty 6.9054415622% $34.103.904 24 Arlington 0.2620524080% S1.294.198.23 Bothell**" 0.2654558588% $1.311.006 85 Edmonds 0.3058936009% $1.510.716 73 Everett 1.9258363241 % $9.511,127.85 Lake Stevens 0.1385202891 % S684.110.15 (Lynnwood 0.7704629214% S3.805.085.23 Marysville 0.3945067827% $1.948,350 65 Mill Creek 0.1227939546% $606,442.50 Monroe 0.1771621898% $8747950 91 Mountlake Terrace 0.21089358050,o $1.041.540 13 hlukilteo 0.2561790702010 $1.265.191.57 Snohomish 0.0861097964% $425.270.45 Snohomish County total 11.8213083387% $58.381.895.49 _ _ U- Q 0 CM LL 2 s Q 0 E M 0 a Packet Pg. 7 2.2.a References w AG Ferguson: Half -billion dollars to fight opioid epidemic will start flowing Dec. 1 I Washington State U- 2 w WA State - Opioid Response Plan(agportaks3bucket.s3.amazonaws.com� o w AG Ferguson: More than 1370 million coming to Washington to fight opioid epidemic I Washington State U- CL w Updated local government payments-2003-06-09.xlsx (live.com0 E a Packet Pg. 8 2.3 City Council Agenda Item Meeting Date: 02/13/2024 2024 February Budget Amendment Staff Lead: {Type Name of Staff Lead} Department: Administrative Services Preparer: Marissa Cain Background/History Amend the 2024 Ordinance No. 4335 Staff Recommendation Staff recommends that Council approve Ordinance No. XXXX amending the 2024 Budget. Narrative Attachments: 2024 February Budget Amendment Ordinance 2024 February Decision Package Exhibits Packet Pg. 9 2.3.a ORDINANCE NO. AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4335 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, previous actions taken by the City Council require Interfund Transfers and increases in appropriations; and WHEREAS, state law requires an ordinance be adopted whenever money is transferred from one fund to another; and WHEREAS, the City Council has reviewed the amended budget appropriations and information which was made available; and approves the appropriation of local, state, and federal funds and the increase or decrease from previously approved programs within the 2024 Budget; and THEREFORE, WHEREAS, the applications of funds have been identified; THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. Section 1. of Ordinance No. 4335 adopting the final budget for the fiscal year 2024 is hereby amended to reflect the changes shown in Exhibits A, B, C, and D adopted herein by reference. 1 Packet Pg. 10 Section 2. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum, and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. ATTEST/AUTHENTICATE: CITY CLERK, SCOTT PASSEY APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: M. JEFF TARADAY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. APPROVED: MAYOR, MIKE ROSEN 2 Packet Pg. 11 2.3.a SUMMARY OF ORDINANCE NO. of the City of Edmonds, Washington On the th day of Februay, 2024, the City Council of the City of Edmonds, passed Ordinance No. XXXX. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4335 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this day of 52024. CITY CLERK, SCOTT PASSEY 3 Packet Pg. 12 EXHIBIT "A": Budget Amendment Summary (February 2024) 2.3.a FUND NO. FUND DESCRIPTION 2024 ADOPTED BUDGET BEGINNING FUND BALANCE REVENUE EXPENDITURES 2024 ADJUSTED BUDGET ENDING FUND BALANCE 001 GENERAL FUND 3,047,445 51,056,792 51,892,793 2,211,444 009 LEOFF-MEDICAL I NS. RESERVE 130,224 250,000 367,140 13,084 011 RISK MANAGEMENT RESERVE FUND - - - - 012 CONTINGENCY RESERVE FUND 2,228,672 - 2,228,672 014 HISTORIC PRESERVATION GIFT FUND 11,701 - 11,701 - 016 BUILDING MAINTENANCE 3,239,084 112,290 1,125,274 2,226,100 017 MARSH RESTORATION & PRESERVATION FUND 849,766 - - 849,766 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 - 200,000 019 EDMONDS OPIOI D RESPONSE FUND 60,000 50,000 - 110,000 104 DRUG ENFORCEMENT FUND 37,070 4,520 39,000 2,590 111 STREET FUND 446,166 2,630,600 2,662,492 414,274 112 COMBINED STREETCONST/IMPROVE 3,0S1,329 5,396,813 5,395,315 3,0S2,827 117 MUNICIPAL ARTS ACQUIS. FUND 551,571 88,631 282,880 357,322 118 MEMORIAL STREET TREE - - - - 120 HOTEL/MOTELTAX REVENUE FUND 83,864 124,371 131,400 76,835 121 EMPLOYEE PARKING PERMIT FUND 87,112 38,900 26,880 99,132 122 YOUTH SCHOLARSHIP FUND 15,668 1,740 3,000 14,408 123 TOURISM PROMOTIONAL FUND/ARTS 117,111 44,193 43,400 117,904 125 PARK ACQ/IMPROVEMENT 1,096,804 1,627,900 2,776,746 (52,042) 126 SPECIALCAPITAL FUND 2,791,257 1,639,520 2,094,109 2,336,668 127 GIFTS CATALOG FUND 2,829,557 215,830 618,646 2,426,741 130 CEMETERY MAINTENANCE/IMPROV 221,474 152,990 290,559 83,905 136 PARKS TRUST FUND - - - - 137 CEMETERY MAINTENANCE TRUSTFD 1,108,741 55,580 99,500 1,064,821 138 SISTER CITY COMMISSION 18,425 5,680 11,900 12,205 140 BUSINESS IMPROVEMENT DISTRICT FUND 39,854 79,209 103,545 15,518 141 AFFORDABLE & SUPPORTIVE HOUSING FUND 299,566 65,000 - 364,566 142 EDMONDS RESCUE PLAN FUND 64,588 6,550,000 6,550,000 64,588 143 TREE FUND 201,600 220,930 214,800 207,730 211 LID FUND CONTROL - - - - 231 2012 LTGO DEBT SERVICE FUND - 310,420 310,420 - 332 PARKS CONSTRUCTION 728,858 316,240 54,535 990,563 421 WATER 32,049,896 12,314,744 13,837,584 30,527,056 422 STORM 19,239,755 8,971,716 9,697,423 18,514,048 423 SEWER/TREATMENT PLANT 62,322,079 20,019,768 23,397,506 58,944,341 424 BOND RESERVE FUND 846,001 1,996,270 1,988,830 853,441 511 EQUIPMENT RENTAL FUND 9,144,158 2,779,730 2,774,212 9,149,676 512 Technology Rental Fund 502,010 2,173,664 2,011,076 664,598 617 FIREMEN'S PENSION FUND - - - - Totals 1 147,661,406 119,294,041 128,812,666 138,142,781 C d E C d E Q w d 8� 7 m R 3 L d LL le N CD N d C> C R C L 0 r C d E C d E Q 4) co 3 m ca 3 L LL le N CD N C d E t C1 ca Q Packet Pg. 13 EXHIBIT "B": Budget Amendments by Revenue (February 2024) 2.3.a FUND NO. FUND DESCRIPTION Adopted Budget Ord.#4335 1/1/2024 Proposed Amendment Ord.# 2024 Amended Revenue Budget 001 General Fund $ 51,056,792 $ $ 51,056,792 009 Leoff-Medical Ins. Reserve 250,000 250,000 011 Risk Management Reserve Fund - - 012 Contingency Reserve Fund 014 Historic Preservation Gift Fund - - 016 Building Maintenance Fund 112,290 112,290 017 Marsh Restoration & Preservation Fund - - 018 Edmonds Homelessness Response Fund - - 019 Edmonds Opioid Response Fund 50,000 50,000 104 Drug Enforcement Fund 4,520 4,520 111 Street Fund 2,630,600 2,630,600 112 Combined StreetConst/Improve 4,946,998 449,815 5,396,813 117 Municipal Arts Acquis. Fund 87,776 855 88,631 120 Hotel/Motel Tax Revenue Fund 124,371 - 124,371 121 Employee Parking Permit Fund 38,900 38,900 122 Youth Scholarship Fund 1,740 1,740 123 Tourism Promotional Fund/Arts 44,193 44,193 125 Park Acq/Improvement 1,627,900 1,627,900 126 Special Capital Fund 1,639,520 1,639,520 127 Gifts Catalog Fund 215,830 215,830 130 Cemetery Maintenance/Improv 152,990 152,990 137 Cemetery Maintenance Trust I'd 55,580 55,580 138 Sister City Commission 5,680 5,680 140 Business Improvement District Fund 79,209 79,209 141 Affordable and Supportive Housing Fund 65,000 65,000 142 Edmonds Rescue Plan Fund 6,550,000 6,550,000 143 Tree Fund 220,930 220,930 211 Lid Fund Control - - 231 2012 LTGO Debt Service fund 310,420 310,420 332 Parks Construction 316,240 316,240 421 Water 12,314,744 - 12,314,744 422 Storm 8,499,216 472,500 8,971,716 423 Sewer / Treatment Plant 20,019,768 - 20,019,768 424 Bond Reserve Fund 1,996,270 - 1,996,270 511 Equipment Renta I Fund 2,706,730 73,000 2,779,730 512 Technology Rental Fund 2,173,664 - 2,173,664 617 Firemen'S Pension Fund - - - Totals $ 118,297,871 $ 996,170 $ 119,294,041 C d E C d E Q w d 8� 3 m ca 3 L d LL le N CD N d C> C cC C L 0 r C d E C d E Q 4) CID m ca 3 L LL le N CD N C d E t C1 �4 Q Packet Pg. 14 EXHIBIT "C": Budget Amendment by Expenditure (February 2024) 2.3.a FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4335 1/1/2024 Proposed Amendment Ord. # 2024 Amended Expenditure Budget 001 General Fund $ 51,892,793 $ $ 51,892,793 009 Leoff-Medical Ins. Reserve 367,140 367,140 011 Risk Management Reserve Fund - - 012 Contingency Reserve Fund - - 014 Historic Preservation Gift Fund 11,701 11,701 016 Building Maintenance Fund 1,125,274 1,125,274 017 Marsh Restoration & Preservation Fund - - 018 Edmonds Homelessness Response Fund 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 39,000 39,000 111 Street Fund 2,662,492 2,662,492 112 Combined Street Const/I mprove 4,699,705 695,610 5,395,315 117 Municipal Arts Acquis. Fund 282,880 - 282,880 120 Hotel/Motel Tax Revenue Fund 131,400 131,400 121 Employee Parking Permit Fund 26,880 26,880 122 Youth Scholarship Fund 3,000 3,000 123 Tourism Promotional Fund/Arts 43,400 - 43,400 125 ParkAcq/Improvement 2,460,645 316,101 2,776,746 126 Special Capital Fund 1,379,355 714,754 2,094,109 127 Gifts Catalog Fund 618,646 - 618,646 130 Cemetery Maintenance/Improv 290,559 - 290,559 137 Cemetery Maintenance Trust I'd 25,000 74,500 99,500 138 Sister City Commission 11,900 - 11,900 140 Business Improvement District Fund 103,545 103,545 141 Affordable and Supportive Housing Fund - - 142 Edmonds Rescue Plan Fund 6,550,000 6,550,000 143 Tree Fund 214,800 214,800 211 Lid Fund Control - - 231 2012LTGO Debt Service Fund 310,420 310,420 332 Parks Construction 139,685 (85,150) 54,535 421 Water 13,568,408 269,176 13,837,584 422 Storm 8,495,157 1,202,266 9,697,423 423 Sewer/Treatment Plant 22,720,243 677,263 23,397,506 424 Bond Reserve Fund 1,988,830 - 1,988,830 511 Equipment Renta I Fund 1,976,212 798,000 2,774,212 512 Technology Rental Fund 2,011,076 - 2,011,076 617 Firemen'S Pension Fund - - - Totals $ 124,150,146 $ 4,662,520 $ 128,812,666 C d E C d E Q w d 8� 3 m ca 3 L d LL le N CD N d t) C ca C L O r C d E C d E Q 4) co 7 m ca 3 L LL le N CD N C d E t t1 ca Q Packet Pg. 15 EXHIBIT "D": Budget Amendment Summary (February 2024) 2.3.a Fund Number Proposed Amendment Change in Revenue Proposed Amendment Change in Expense Proposed Amendment Change in Ending Fund Balance 112 449,815 695,610 (245,795) 117 855 - 855 125 - 316,101 (316,101) 126 714,754 (714,754) 137 74,500 (74,500) 332 (85,150) 85,150 421 269,176 (269,176) 422 472,500 1,202,265 (729,765) 423 - 677,264 (677,264) 511 73,000 798,000 (725,000) Total Change 996,170 4,662,520 (3,666,350) Packet Pg. 16 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Substantial completion was completed in August 2023. Completion of all work will be reached in Summer 2024 upon completion of the plant establishment and maintenance period. Project close-out will continue through 2024. Public Works ay 99 Revitalization Hawkins Previously Approved Budget By Council Previous Year Carryforward Amendment December 20, 2022 & February 21, 2023 100% Ending Fund Balance One -Time C Fund F 112 STREET Name: CONSTRUCTION Account Number Description 2024 2025 2026 2027 2028 112.000.68.542.33.41.67 Interfund Services - Roadway $ 11,000 $ $ 112.000.68.595.33.41.00 Captial Professional Services - Roadway 25,000 Total Expenditure Increase (Decrease) $ 36,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 112.000.334.03.600.08 SR99 Revitalization HLP-CNWA(013) $ 36,000 $ $ $ $ Total Revenue Increase (Decrease) $ 36,000 $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Ending Fund Balance Increase (Decrease) $ $ $ $ $ Packet Pg. 17 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Item Description: The project started in August 2023 and was suspended due to weather in December. The construction work is scheduled to be completed in Spring 2024 and project close-out will continue through 2024. The remaining construction items include completion of the following: signal upgrades along 100th Ave. at 220th St., SR-104, Old Woodway Campus, and 238th, pavement striping on 100 Ave. / 9th Ave. from Walnut St. to 244th St. and 228th St. from 80th Ave. to Hwy 99 and miscellaneous minor work items. Department: Public Works Fund Name: MULTIPLE FUNDS Division: Engineering iCitvwide Title: Bicvcle Imurovements (EODC/i050) IPreparer: 1Jaime Hawkins Budget Amendment Type Previously Approved Budget By Council Previous Year Carryforward Amendment Date of Discussion or Budget Approval? Jun 27 2023 How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? ICAWW Expenditure Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 112.000.68.595.33.65.00 Construction Project Roadway $ 659,610 $ $ $ 125.000.68.542.30.41.67 Interfund Services - Roadway 69,529 125.000.68.595.33.41.00 Professional Services - Roadway 29,702 125.000.68.595.33.65.00 Construction Project Roadway 131,070 126.000.68.542.30.41.67 Interfund Services - Roadway 22,406 126.000.68.595.33.41.00 Professional Services - Roadway 25,671 126.000.68.595.33.65.00 1 Construction Project Roadway 192,252 Total Expenditure Increase (Decrease) 1 $ 1,130,240 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 112.000.337.10.000.01 Citywide Bicycle Improvements Project $ 413,815 $ $ $ $ Total Revenue Increase (Decrease) $ 413,815 1 $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 112.000.64.508.30.00.00 Ending Fund Balance $ (245,795) $ $ $ 125.000.64.508.30.00.00 Ending Fund Balance (230,301) 126.000.64.508.30.00.00 Ending Fund Balance (240,329) Total Ending Fund Balance Increase (Decrease) 1 $ (716,425)1 1 $ $ $ Packet Pg. 18 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The material for signal upgrades at SR-104 @ 236th St. SW (addition of protected / permissive left turn phasing for 104 movements) was purchased in 2023. Installation scheduled for Spring 2024. Public Works 2023 Trafffic Sil Bertrand Hauss Previously Approved Budget By Council Previous Year Carryforward Amendment Dec 20 2022 100% Ending Fund Balance One -Time C Fund [ 125 REET 2 Name: Account Number Description 2024 2025 2026 2027 2028 125.000.68.542.64.48.00 R&M - Traffic Control $ 11,300 $ $ $ $ Total Expenditure Increase (Decrease) $ 11,300 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 125.000.64.508.30.00.00 Ending Cash Balance $ (11,300) $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ (11,300) $ $ $ $ C N E C d E Q N a1 ZZ 7 m 7 N IL It N O N Packet Pg. 19 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Carryforward will pay to complete the remaining work and close out the project. Public Works 2023 Pavement Preservation Previously Approved Budget By Council Previous Year Carryforward Amendment Dec 20 2022 100% Ending Fund Balance One -Time Operating Fund I MULTIPLE FUNDS Name: Account Number Description 2024 2025 2026 2027 2028 125.000.68.542.30.41.67 Interfund Services -Roadway $ 2,500 $ $ 125.000.68.542.30.48.00 Repair & Maintenance -Overlays 15,000 126.000.68.542.30.41.67 Interfund Services -Roadway 2,500 126.000.68.542.30.48.00 Repair & Maintenance -Overlays 15,000 Total Expenditure Increase (Decrease) $ 35,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 125.000.64.508.30.00.00 Ending Fund Balance $ (17,500) $ 126.000.64.508.30.00.00 Ending Fund Balance (17,500) Total Ending Fund Balance Increase (Decrease) $ (35,000) $ $ $ $ Packet Pg. 20 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Item Description: The Lighting Study was started in September 2023 and the City coordinated with Snohomish County PUD to upload their streetlight data and combine it with the City's existing streetligh information. The remaining work in the first quarter of 2024 is to complete a gap analysis and develop a priority list. Department: Public Works Fund Name: IF 126 BEET 1 Division: Engineering 1Citvwidc Title: Li !htim ! Studv (E23NA/s034) Budget Amendment Type Previously Approved Budget By Council Previous Year Carryforward Amendment Date of Discussion or Budget Approval? Dec 20 2022 How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lcaww Expenditure Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 126.000.68.542.30.41.00 Professional Services - Roadway $ 35,070 $ 126.000.68.542.30.41.67 Interfund Services - Roadway 3,900 Total Expenditure Increase (Decrease) $ 38,970 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 126.000.64.508.30.00.00 Ending Cash Balance $ (38,970) $ Total Ending Fund Balance Increase (Decrease) $ (38,970) $ $ $ $ C N E C d E Q N a1 7 m 7 N Il It N O N Packet Pg. 21 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The expenditures for the 2023 Traffic Calming Program were increased to install speed tables on Olympic View Dr and 8th Ave. The amount programmed for the 1% arts transfer was not enough to complete the $855 transfer in 2023. This budget amendment will allow the transfer to be completed in 2024. Public Works 2023 Traffic New Item For Council To Consider 1st Quarter Budget Amendment 100% Ending Fund Balance One -Time C Fund I MULTIPLE FUNDS Name: Account Number Description 2024 2025 2026 2027 2028 126.000.68.597.73.55.17 Interfund Transfer $ 855 $ $ $ $ Total Expenditure Increase (Decrease) $ 855 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 117.200.397.23.126.00 Interfund Transfer $ 855 $ $ $ $ Total Revenue Increase (Decrease) $ 855 1 $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 126.000.64.508.30.00.00 Ending Fund Balance $ (855) $ 117.200.64.508.40.00.00 Ending Fund Balance 855 Total Ending Fund Balance Increase (Decrease) $ $ $ $ $ Packet Pg. 22 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Item Description: The project started in 2023 and was suspended due to weather in December. The construction work is scheduled to be completed in Spring 2024 and project close-out will continue through 2024. The remaining construction items include the completion of sidewalk, driveway entrance and pedestrian curb ramps between Coronado PI and 100th Ave and pavement striping. Department: Public Works Division: Engineering Fund MULTIPLE FUNDS Title: Elm Wav Walkwav (E21DA/i058) Name: IPreparer: 1Jaime Hawkins Budget Amendment Type Previously Approved Budget By Council Previous Year Carryforward Amendment Date of Discussion or Budget Approval? Jun 27 2023 How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? ICAWW Expenditure Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 126.000.68.542.61.41.67 Interfund Services - Sidewalks $ 18,900 $ 126.000.68.595.61.41.00 Professional Services - Sidewalks 15,900 126.000.68.595.61.65.00 Construction Project - Sidewalks 282,150 422.000.72.542.40.41.67 Interfund Services - Transportation Drainage 12,030 422.000.72.595.40.41.00 Capital Professional Sery - Transportation Drainage 10,090 422.000.72.595.40.65.00 Construction Project - Transportation Drainage 59,060 Total Expenditure Increase (Decrease) $ 398,130 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 126.000.64.508.30.00.00 Ending Fund Balance $ (316,950) $ $ $ $ 422.000.72.508.00.00.00 Ending Fund Balance (81,180) Total Ending Fund Balance Increase (Decrease) $ (398,130) $ $ $ $ Packet Pg. 23 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Carryforward of $32,000 allocation for continuation of Mathay Ballinger Park improvements including construction in 2024. Although the full project expenditures were authoritized by Council, this request is to carryforward the expenditure authority for the allocated funds from 2023 that have not been spent. Department: Parks, Recreation and Human Services Division: Parks Shannon Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider JE Previous Year Carryforward Amendment 2023 Budget Adoption 100% Ending Fund Balance One -Time Capital Fund 125 REET 2 Name: Account Number Description 2024 2025 2026 2027 2028 125.000.64.594.76.65.00 REET Fund 125 - Construction $ 32,000 $ $ $ $ Total Expenditure Increase (Decrease) $ 32,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ - $ - $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 125.000.64.508.30.00.00 REET Fund 125 - Construction $ (32,000) $ $ $ $ Total Ending Fund Balance Increase (Decrease) 1$ (32,000) $ 1 $ 1 $ $ C N E C d E Q N i31 7 m 7 N lL It N O N Packet Pg. 24 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Division: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Carryforward expenditure authority for completion and close out of Civic Park. The funds were unspent in 2023 and will be utilized in early 2024 for completion of this capital project. Parks, Recreation and Human Services Parks Civic Park Shannon Burlev New Item For Council To Consider JE Previous Year Carryforward Amendment 2023 Adopted Budget 100% Ending Fund Balance One -Time Capital Fund MULTIPLE FUNDS Name: Account Number Description 2024 2025 2026 2027 2028 332.100.64.594.76.65.00 Construction - Park Facilities $ 15,000 $ $ $ $ 125.000.64.594.76.65.00 Construction - Park Facilities 25,000 Total Expenditure Increase (Decrease) $ 40,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ $ - $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 332.100.64.508.30.00.00 Ending Fund Balance $ (15,000) $ $ $ $ 125.000.64.508.30.00.00 Ending Fund Balance (25,000) Total Ending Fund Balance Increase (Decrease) 1$ (40,000) $ 1 $ 1 $ $ C N E C d E Q N a1 7 m 7 N IL It N O N Packet Pg. 25 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Two bonds were issued for the Civic Center Playfield Park project. Currently, annual bond payments for one is paid for using REET Fund 126 and the other was paid out of the Parks Capital Construction Fund 332. The Fund 332 is a pass -through fund and will not have sufficient revenues to cover the nearly $100,000 annual payment. The solution is to have the second bond payment come from the BEET Fund 126 account which is the same as the first bond. To offset this increased expenditure from REET Fund 126, there will be a reduction from the $200,000 to $100,000 annual set aside for parkland acquisition. Department: Parks, Recreation and Human Services Division: Parks Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Civic Park Bond Payments & Interest Shannon Burlev New Item For Council To Consider 1st Quarter Budget Amendment 100% Self Funded On -Going Capital_ Fund MULTIPLE FUNDS Name: Fill out on -going costs & revenues Account Number Description 2024 2025 2026 2027 2028 126.000.39.591.76.71.12 2021 LTGO (A) Civic Park Principal $ 55,000 $ 55,000 $ 60,000 $ 60,000 $ 65,000 126.000.39.592.76.83.12 2021 LTGO (A) Civic Park Interest 45,150 42,400 39,650 36,650 33,650 332.000.64.591.76.71.00 2021 LTGO (A) Civic Park Principal (55,000) - - - - 332.000.64.592.76.83.00 2021 LTGO (A) Civic Park Interest (45,150) Total Expenditure Increase (Decrease) $ $ 97,400 $ 99,650 $ 96,650 $ 98,650 Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) 1 $ $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 126.000.39.508.30.00.00 Ending Fund Balance $ (100,150) $ (97,400) $ (99,650) $ (96,650) $ (98,650) 332.000.64.508.30.00.00 Ending Fund Balance 100,150 Total Ending Fund Balance Increase (Decrease) 1 $ (97,400) $ (99,650) $ (96,650) $ (98,650) C N E C d E Q N i31 7 m 7 N U_ It N O N 10 Packet Pg. 26 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The Yost & Seaview Reservoir project design phase is still ongoing. This decision package moves the unspent 2023 design funds to 2024 to aid in the design completion. Public Works & Seaview Reservoir Repairs and iele (Mike) De Lilla Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process 100% Ending Fund Balance One -Time C Fund 1 421 WATER Name: Account Number Description 2024 2025 2026 2027 2028 421.000.74.534.34.41.67 Interfund Services $ 40,000 $ $ $ 421.000.74.594.34.41.00 Capital Professional Services 171,929 Total Expenditure Increase (Decrease) $ 211,929 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 421.000.74.508.00.00.00 Ending Fund Balance $ (211,929) $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ (211,929)1 1 1 1$ C N E C d E Q N a1 7 m 7 N Il It N O N 11 Packet Pg. 27 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The annual water replacement project design phase is still ongoing. This decision packages moves the remaining 2023 funds to 2024 to complete the design phase. Construction is scheduled to begin in 2024. Public Works Phase 14 Waterline Greg Malowicki Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process 100% Ending Fund Balance One -Time C Fund 1 421 WATER Name: Account Number Description 2024 2025 2026 2027 2028 421.000.74.534.34.41.67 Interfund Services $ 17,247 $ $ $ $ 421.000.74.594.34.41.00 Capital Professional Services 40,000 Total Expenditure Increase (Decrease) $ 57,247 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ h h h Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 421.000.74.508.00.00.00 Ending Fund Balance $ (57,247) $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ (57,247) $ $ $ $ 12 Packet Pg. 28 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The budget amendment provides funding for the final payment to the contractor and project close-out. Final close-out was delayed due to the contractor providing required documents needed to complete the final payment and staff availability to review and approve the documents. Public Works Phase 7 Sewer New Item For Council To Consider 1st Quarter Budget Amendment 100% Ending Fund Balance One -Time C Fund 423 SEWER / TREATMENT Name: I PLANT Account Number Description 2024 2025 2026 2027 2028 423.000.75.535.80.41.67 Interfund Services $ 2,000 $ $ 423.000.75.594.35.65.30 Construction Projects 80,000 Total Expenditure Increase (Decrease) $ 82,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 423.000.75.508.00.00.00 Ending Fund Balance $ (82,000) $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ (82,000) $ $ $ $ w C N E C d E Q N al 7 m 7 N Il It N O N 13 Packet Pg. 29 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The annual 2023 sewer replacement project portion of construction was delayed to early 2024 due to weather conditions. This budget amendment moves the remaining 2023 funds for the construction phase to 2024. Public Works Phase 10 Sewer Greg Malowicki Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process 100% Ending Fund Balance One -Time C Fund 423 SEWER / TREATMENT Name: I PLANT Account Number Description 2024 2025 2026 2027 2028 423.000.75.535.80.41.67 Interfund Services $ 38,106 $ $ 423.000.75.594.35.41.00 Capital Professional Services 30,000 423.000.75.594.35.65.30 Construction Projects 120,000 Total Expenditure Increase (Decrease) $ 188,106 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 423.000.75.508.00.00.00 Ending Fund Balance $ (188,106) $ Total Ending Fund Balance Increase (Decrease) $ (188,106) $ $ $ $ w C N E C d E Q N a1 7 m 7 N Il It N O N 14 Packet Pg. 30 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The annual sewer replacement project design is still ongoing. This decision package moves the remaining 2023 funds to 2024 to complete the design phase. Construction is scheduled to begin in 2024. Public Works Phase 11 Sewer Greg Malowicki reviously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process 100% Ending Fund Balance One -Time C Fund 423 SEWER / TREATMENT Name: I PLANT Account Number Description 2024 2025 2026 2027 2028 423.000.75.535.80.41.67 Interfund Services $ 16,682 $ $ $ $ 423.000.75.594.35.41.00 Capital Professional Services 200,000 Total Expenditure Increase (Decrease) $ 216,682 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 423.000.75.508.00.00.00 Ending Fund Balance $ (216,682) $ Total Ending Fund Balance Increase (Decrease) $ (216,682) $ $ $ $ w C N E C d E Q N a1 7 m 7 N Il It N O N 15 Packet Pg. 31 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: The annual sewer cured in place pipe project portion of construction was delayed to early 2024. This decision package moves the remaining 2023 funds for the construction phase into the 2024 budget. Public Works ITitle: ICitvwide CIPP Sewer Rehabilitation Proiect Phase 3 (E6GB/c488) I Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Malowicki Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process 100% Ending Fund Balance One -Time C Fund 423 SEWER / TREATMENT Name: I PLANT Account Number Description 2024 2025 2026 2027 2028 423.000.75.535.80.41.67 Interfund Services $ 13,768 $ $ 423.000.75.594.35.41.00 Capital Professional Services 12,891 423.000.75.594.35.65.30 Construction Projects 163,817 Total Expenditure Increase (Decrease) $ 190,476 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 423.000.75.508.00.00.00 Ending Fund Balance $ (190,476) $ Total Ending Fund Balance Increase (Decrease) $ (190,476) $ $ $ $ w C N E C d E Q N a1 7 m 7 N Il It N O N 16 Packet Pg. 32 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: The project will provide a full -width grind and pavement overlay of Main St from 6th Ave to 8th Ave. This project also includes upgrading all non -compliant ADA pedestrian curb ramps within the project limits Public Works ITitle: IMain St. Overlav from 6th Ave. to 8th Ave (E23CF/i078) I Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 1st Quarter Budget Amendment 100% Ending Fund Balance One -Time C Fund f 422 STORM Name: Account Number Description 2024 2025 2026 2027 2028 422.000.72.595.40.41.00 Professional Services - Transportation $ 36,400 $ $ $ 422.000.72.542.49.41.67 Interfund Services - Transportation 20,000 422.000.72.597.40.65.00 Construction Projects -Transportation 177,870 Total Expenditure Increase (Decrease) $ 234,270 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 422.000.72.508.00.00.00 Ending Fund Balance $ (234,270) $ Total Ending Fund Balance Increase (Decrease) $ (234,270) $ $ $ $ C N E C d E Q N al 7 m 7 N Il It N O N 17 Packet Pg. 33 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) 30% of the design phase is still in progress for the Lower Perrinville Creek Restoration. This decision package moves the unspent 2023 funds for 30% of the remaining design costs to 2024. Public Works Perrinville Creek Restoration ke) De Lilla Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process Reimbursed by Grants or Outside Agencies One -Time Ca ital Fund f 422 STORM Name: Account Number Description 2024 2025 2026 2027 2028 422.000.72.531.31.41.67 Interfund Services $ 20,000 $ $ $ 422.000.72.594.31.41.00 Capital Professional Services 52,518 Total Expenditure Increase (Decrease) $ 72,518 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 422.000.72.508.00.00.00 Ending Fund Balance $ (72,518) $ Total Ending Fund Balance Increase (Decrease) $ (72,518) $ $ $ $ 18 Packet Pg. 34 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Stormwater Comprehensive Plan Document is still a work in progress. This decision package moves the unspent 2023 funds into the 2024 budget. Public Works Title: IStormwater Comprehensive Plan Update (E6FD/s017) Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) ke) De Lilla Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process 100% Ending Fund Balance One -Time C Fund f 422 STORM Name: Account Number Description 2024 2025 2026 2027 2028 422.000.72.531.31.41.67 Interfund Services $ 10,000 $ $ $ 422.000.72.531.90.41.20 Capital Professional Services 31,022 Total Expenditure Increase (Decrease) $ 41,022 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 422.000.72.508.00.00.00 Ending Fund Balance $ (41,022) $ Total Ending Fund Balance Increase (Decrease) $ (41,022) $ $ $ $ 19 Packet Pg. 35 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The annual storm replacement/rehabilitation project design is still ongoing. This decision package moves the 2023 funds into the 2024 budget. Public Works Phase 4 Storm Rehabilitation Malowicki Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process 100% Ending Fund Balance One -Time C Fund f 422 STORM Name: Account Number Description 2024 2025 2026 2027 2028 422.000.72.531.31.41.67 Interfund Services $ 16,000 $ $ $ 422.000.72.594.31.41.00 Capital Professional Services 78,363 Total Expenditure Increase (Decrease) $ 94,363 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 422.000.72.508.00.00.00 Ending Fund Balance $ (94,363) $ Total Ending Fund Balance Increase (Decrease) $ (94,363) $ $ $ $ C N E C d E Q N a1 7 m 7 N Il It N O N 20 Packet Pg. 36 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: City staff have been negotiating with the property owner to purchase the property at 7317 Lake Ballinger Way. The acquisition is anticipated to be completed in the first quarter of 2024. The unspent funds from 2023 are being moved to 2024. Public Works ITitle: 17317 Lake Ballinger Wav Property Purchase & Demolition (E23MA/c581) I Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Previously Approved Budget By Council Previous Year Carryforward Amendment 2023 Budget Process Reimbursed by Grants or Outside Agencies One -Time Ca ital Fund f 422 STORM Name: Account Number Description 2024 2025 2026 2027 2028 422.000.72.531.31.41.67 Interfund Services - Capital $ 27,556 $ $ $ 422.000.72.594.31.41.00 Capital Professional Services 27,556 422.000.72.594.31.61.11 Intangible Rights to Land 480,000 422.000.72.594.31.65.20 Construction Projects 43,800 Total Expenditure Increase (Decrease) $ 578,912 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 422.000.34.334.03.103.00 Dept of Ecology Grant $ 472,500 $ $ $ Total Revenue Increase (Decrease) $ 472,500 $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 422.000.72.508.00.00.00 Ending Fund Balance $ (106,412) $ $ $ Total Ending Fund Balance Increase (Decrease) 1 $ (106,412) $ I $ $ $ 21 Packet Pg. 37 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget amendment for Department of Commerce appropriation portion (east side of SR-104) of Edmonds Marsh Water Quality Improvements Project. Commerce agreement execution is still in progress, but reimbursement for costs incurred prior to the date of contract execution will be allowed. Revenue account number will be generated once Commerce agreement is executed. Public Works ITitle: (Edmonds Marsh Water Oualitv Improvements Phase 2 (TBD) I Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 1st Quarter Budget Amendment Reimbursed by Grants or Outside Agencies One -Time Cam Fund f 422 STORM Name: Account Number Description 2024 2025 2026 2027 2028 422.000.72.531.31.41.67 Interfund Services - Capital $ 30,000 $ $ $ 422.000.72.594.31.41.00 Capital Professional Services 70,000 Total Expenditure Increase (Decrease) $ 100,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 422.000.72.508.00.00.00 Ending Fund Balance $ (100,000) $ Total Ending Fund Balance Increase (Decrease) $ (100,000) $ $ $ $ C N E C d E Q N al 7 m 7 N U_ It N O N 22 Packet Pg. 38 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: This is a one-time purchase of a Mini -Excavator for use at the Edmonds Cemetery to perform burial services and a carport structure for storage. Cost for equipment is approximately $73,000 and $1,500 for the shelter structure. Ongoing costs in the future will include approximately $750/year for fuel and maintenance and $7,000/year for replacement and will be billed to the Cemetery Fund 130. All funding is from Cemetery Funds and is approved by the Cemetery Board. Parks, Recreation and Human Services Division: Shannon Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Excavator New item For Council To Consider 100% Ending Fund Balance On -Going Capital Fund MULTIPLE FUNDS Name: Fill out on -going costs & revenues Account Number Description 2024 2025 2026 2027 2028 511.100.77.594.46.64.00 ERR Equipment $ 73,000 $ $ $ $ 137.000.64.597.36.55.00 Interfund Transfer to 511 for Purchase 73,000 137.000.64.536.50.35.00 Small Equipment - Carport Structure 1,500 - 130.000.64.536.50.35.00 Small Equipment - 7,000 7,000 7,000 7,000 130.000.64.536.50.48.00 Repair & Maintenance 750 750 750 750 JTotal Expenditure Increase (Decrease) $ 147,500 $ 7,750 $ 7,750 $ 7,750 $ 7,750 Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 511.100.397.48.137.00 Interfund transfer from Fund 137 $ 73,000 $ $ $ $ Total Revenue Increase (Decrease) $ 73,000 1 $ $ - $ - 1$ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 137.000.64.508.30.00.00 Ending Fund Balance $ (74,500) $ - $ - $ - $ 130.000.64.508.40.00.00 Ending Fund Balance (7,750) (7,750) (7,750) (7,750) Total Ending Fund Balance Increase (Decrease) 1$ (74,500) $ (7,750) $ (7,750) $ (7,750) $ (7,750) C N E C d E Q N i31 7 m 7 N LL It N O N 23 Packet Pg. 39 2024 February Budget Amendment 2.3.b Budget Amendment for: February 20, 2024 Item Description: Fleet is committed to finding alternative solutions to green house gas emissions reductions through converting many cars and trucks to operate on propane. The city has a significant investment and commitment to this program to continue our efforts in alternative fuels that align with the Climate Action Committee's goals. Fleet carefully selects each vehicle purchase with the option of hybrid, electric, or propane conversions wherever it is applicable. There are 5 new vehicles purchased in 2023 that Fleet reccommends we convert to run on propane gas. 2 Ford F-250 Sewer department crew trucks, 2 Ford F-350 Parks department crew trucks, and 1 Ford F-450 Water department crew truck. In addition to the environmental benefit, these conversions also reduce the annual expenditures for fuel. Propane gas is currently averaging $1.45/Gallon with an additional Federal Tax Refund of $0.45/ allon in 2024. Department: Public Works Fund Name:T511 Division: Fleet EQUIPMENT RENTAL Title: Propane Coversions Preparer: Carl Rugg Budget Amendment Type New Item For Council To Consider 1st Quarter Budget Amendment Date of Discussion or Budget Approval? How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? JCapital Expenditure Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 511.100.77.594.48.64.00 B-Fund $ 35,000 $ $ $ $ Total Expenditure Increase (Decrease) $ 35,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 511.100.77.508.00.00.00 Ending Fund Balance $ (35,000) $ Total Ending Fund Balance Increase (Decrease) $ (35,000) $ $ $ $ 24 Packet Pg. 40 2.3.b 2024 February Budget Amendment Budget Amendment for: February 20, 2024 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The 2023 Fleet B-Fund budget for new vehicle additions and scheduled vehicle replacements was approved for $3,549,411 to purchase a total of 49 vehicles. Production delays and longer than average lead times on equipment have delayed the completion of 19 new vehicle additions and 8 scheduled vehicle replacements. At this time we are bringing forward 2 sewer vehicles, 3 water vehicles, and one storm vehicle for a total of $640,000. The only General Fund item included in this carryforward amendment are the costs to complete two regularly scheduled patrol vehicles that are part of the replacement schedule for a total cost of $50,000. The remaining vehicle budget reauests will be brought forward at a later date. Public Works Carl Previously Approved Budget By Council Previous Year Carryforward Amendment 100% Ending Fund Balance One -Time C Fund Name: EQUIPMENT RENTAL Account Number Description 2024 2025 2026 2027 2028 511.100.77.594.48.64.00 Equipment B-Fund $ 690,000 $ $ $ $ Total Expenditure Increase (Decrease) $ 690,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 Total Revenue Increase (Decrease) $ Ending Fund Balance Increase (Decrease) Account Number Description 2024 2025 2026 2027 2028 511.100.77.508.00.00.00 Ending Fund Balance $ (690,000) $ Total Ending Fund Balance Increase (Decrease) $ (690,000) $ $ $ $ 25 Packet Pg. 41 2.4 City Council Agenda Item Meeting Date: 02/13/2024 Preliminary December 2023 Quarterly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Review and move to full council to be received for filing. Narrative Preliminary December 2023 Quarterly Financial Report Attachments: Complete Preliminary December 2023 Quarterly Financial Report Jan -Dec 2023 P&L Packet Pg. 42 2.4.a INSIDE THIS ISSUE: Revenues By Fun( Summary Expenditures By Fund Summary General Fund Revenues Expenditures By Fund Detail Gen. Fund Depart ment Expenditure; Fund Balance Overviews Right. The Council recently welcomed two new members to the dais. Wel- come, Chris Eck and Michelle Dotsch to the Ed- monds City Council! Summary of Operating Funds: Revenues This report is a summary of the City's preliminary operating results for the year ended December 31, 2023 Revenue Update: The local economy has been doing much better recently, with relatively low unemployment and inflation. In- terest rates remain high, which nega- tively affects home sales and other property transactions, as well as mo- tor vehicle sales. This negatively im- pacts our REET Revenues and sales tax revenues. However, higher inter- est rates have helped our investment portfolio bring in $1.7 million of rev- enue to the city in 2023, almost $450,000 (36%) more than any previ- ous year. General Fund revenues (pg. 4) came in at $50.0 million, which is 4.9% under budget. General Fund expenses (pg. 10) came in at $59.7 million, or 7% under budget. Estimated ending fund balance (pg. 33) came in at $2.2 million, which is $830,000 less than the most recently updated es- timate. Revenues by Category: General Fund revenues for 2023 are higher than 2022 in all catego- ries (pages 21 to 23), and General Fund revenues exceeded budget in Charges for Goods and Services, Miscellaneous, and Transfers -In. General Fund revenues fell short of budgeted projections in Taxes, Licenses and Permits, Intergovern- mental, and Fines and Penalties. Overall General Fund revenues for 2023 exceeded revenues for 2022 by $4.7 mil- lion, or 10.3%. The General Fund currently has a fund balance of $2,231,830. Per policy, $8,914,686 of the fund balance in Fund 001 added to the $2,228,672 balance in Fund 012 represent the required 20% min- imum Fund Balance reserve. This means that the General Fund at year end has uti- lized $6,682,8569 of Restricted Fund Bal- ance. Revenue information for each of the 37 funds reported can be found on page 19. It is important to understand that numbers reported in the monthly reports are esti- mates that are subject to change after the final year-end close is performed. The City currently has no interfund loans out- standing. Preliminary Financial Management Report as of December Packet Pg. 43 2.4.a V � � � � � � � � � Summary of Operating Funds: Expenditures Top: The Edmonds City Council approved the 2024 City Budget on December 27, 2023. Right: December 13-15, people from Wash- ington Tree Experts took care of some much needed prun- ing of the large oak trees that surround the 4-way stop at 5th & Main. Several "widowmakers" (large dead or dying branches) were re- moved, helping to make downtown a safer place to walk and shop. General Fund expenditures for the year are $10.6 million more than this time last year, which is still $4.3 million (7%) under the amount authorized by Council. General Fund expenses by depart- ment can be found on pages 30-32. Every department in the General Fund finished the year under budget except for Administrative Services and the Police Department. These two departments combined were over budget by $261,963, or 1.5%. Expenses by department can be found in graphical form on pages 10 -18. EDMONDS ADOPTED BUDGET 2024 Special Revenue Funds during the - year spent only $17.8 million of their approved $24.7 million ex- penditure budget (72%). Much of CITY OF EDMONDS the underspending comes from REET funds, which spent $2.4 mil- came in $3.1 million (28%) under budget. lion (66%) less than their budget, and Additional Special Revenue Fund ex - the Street Construction Fund, which penditure information can be found on pages 25-26. The total fund balances for the General Fund and Sub -funds (pg. 33) at year-end is $9.4 million. Total fund balances for the Special Revenue Funds are $14.8 million, a year-to-date decline of $1.4 million. The 2024 budget was adopted by Council on December 27, 2023. This budget in- cluded expenditures in excess of revenues of $836,001. With an unsettled labor con- tract and other unknowns, expenses will need to be monitored closely throughout the year, and significant new revenue sources will need to be identified. Much work remains to be done to keep the city financially stable in 2025 and beyond. l Preliminary Financial Management Report as of December Packet Pg. 44 I 2.4.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of Decem be 31, 2023 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate FHLB FHLB FM FNMA FFCB FHLB Spokane County WA First Financial - Waterfront Center FHLMC Farmer Mac FHLB US Treasury Note FFCB Farmer Mac FHLMC Farmer Mac First Financial - ECA Bonds Bonds Bonds Bonds Bonds Bonds Bonds CD Bonds Bonds Bonds Note Bonds Bonds Bonds Bonds CD TOTAL SECURITIES Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO 2,004,464 0.04 2,000,000 1,999,032 954,866 0.28 1,000,000 985,458 996,082 0.46 1,000,000 988,438 992,693 0.50 1,000,000 982,676 1,960,906 0.70 2,000,000 1,978,941 950,774 0.88 1,000,000 962,971 207,260 0.92 200,000 195,130 245,000 0.99 245,000 245,000 974,798 1.20 1,000,000 988,027 1,995,088 1.30 2,000,000 1,988,147 969,524 1.58 1,000,000 986,501 964,597 1.62 1,000,000 979,414 1,982,692 1.94 2,000,000 1,990,299 1,994,172 2.09 2,000,000 1,987,092 993,661 2.56 1,115, 000 1,023,140 2,057,309 2.88 2,305,000 2,118,519 2,803,516 3.88 2,803,516 2,803,516 23,047,403 1.40 23,668,516 23,202,299 Issuer Diversification Fi rst Financial - CD, 13% okane Farmer County Mac, 27% WA, 1% FFCB, 17% FHL0 9% FHLB, 21% 24,706,439 24,706,439 16,482, 540 16, 482, 540 $ 64,857,496 $ 64,391,279 01 / 16/24 04/10/24 06/ 17/24 07/02/24 09/ 13/24 11/18/24 12/01 /24 12/27/24 03/13/25 04/17/25 07/28/25 08/15/25 12/08/25 02/02/26 07/22/26 11 /17/26 11/15/27 Demand Demand 4.81 % 0.35% 2.80% 1.75% 3.50% 0.90% 2.10% 2.47% 3.75% 4.25% 3.60% 3.13% 4.13% 3.95% 0.83% 1.15% 2.96% 5.43% 2.49% Cash and Investment Balances Checki ng, (in $ Millions) _$4.67 , 7% Bonds, $19.62, State LGIP, 28% Note, $24.71, $1.00, 1%� 36% CD's, County $3.05, 4% LGIP, $16.48 , 24% 1 Packet Pg. 45 I 2.4.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income ,i,000,000 $1,683,872 >1,500,000 $1,236,875 >1,000,000 $947,931 $950,684 $1091709 $500,000 $- 2018 2019 2021 2022 YTD 2023 Packet Pg. 46 1 GENERAL FUND SUMMARY I 2.4.a I 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 January 12,000,000 10,000, 000 8,000,000 6,000,000 4,000,000 2,000,000 14,000,000 13,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000, 000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 General Fund Revenues and Expenses (Rolling 24 months) — — — General Fund Revenues General Fund Expenses April July October January April July General Fund Tax Revenue (2017 through 2022) — — — Sales Tax Property Tax EMS Tax Other Taxes 2017 2018 2019 Sales Tax October 2020 2021 2022 General Fund Tax Revenue (2023 YTD) 510 640,784 Property Tax EMS Tax Other Taxes 3 Packet Pg. 47 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2023 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 2,843,094 $ 2,843,094 $ 2,320,252 -18.39% February 5,636,382 2,793,288 4,920,100 -12.71% March 8,487,993 2,851,611 8,150,445 -3.98% April 12,010,212 3,522,219 16,689,365 38.96% May 22,451,612 10,441,400 21,615,550 -3.72% June 25,498,180 3,046,568 23,772,230 -6.77% July 28,462,795 2,964,616 27,008,084 -5.11% August 31,857,014 3,394,219 30,494,023 -4.28% September 34,651,707 2,794,693 33,627,848 -2.95% October 39,245,890 4,594,183 41,665,078 6.16% November 49,438,148 10,192,259 46,406,295 -6.13% December 52,558,830 3,120,682 50,005,535 -4.86% City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2023 Real Estate Excise Tax 1 & 2 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 343,196 $ 343,196 $ 151,084 -55.98% February 564,002 220,806 270,799 -51.99% March 914,189 350,187 521,829 -42.92% April 1,199,839 285,649 745,931 -37.83% May 1,552,936 353,097 1,053,507 -32.16% June 1,933,322 380,387 1,272,041 -34.20% July 2,318,897 385,574 1,582,268 -31.77% August 2,728,590 409,693 1,854,598 -32.03% September 3,157,962 429,373 2,189,986 -30.65% October 3,549,820 391,858 2,358,575 -33.56% November 3,941,307 391,487 2,552,056 -35.25% December 4,400,000 458,693 2,712,025 -38.36% Real Estate Excise Tax 1 & 2 500,000 0 JAN FEB MAR APR MAY RUN JUL AUG SEP OCT NOV DEC +Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. 4 Packet Pg. 48 SALES TAX SUMMARY I 2.4.a I Sales Tax Analysis By Category Current Period: December 2023 Year -to -Date Total $11,614,826 Wholesale Trade, $342,273 Gasoline, Construction Trade, Retail Food Stores, $0 $1,896,934 $388,118 Misc Retail, $2,119,489 Retail Automo r- $2,743,284 Eating & Drinking, $1,380,500 Amusement & Recreation, Automotive Repair, $94,434 $258,574 Clothing and Accessories, $355,403 Others, $318,188 Manufacturing, Accommodation, $51,460 Business Services, $1,195,632 Health & Personal Care, $86,016 Communications, $254,893 Annual Sales Tax Revenue 14,000, 000 12,000,000 $11,614,826 $10,302,518 10,000, 000 $7,395,114 $8,406,296 $8,452,715 $8,317,046 8,000,000 6,000, 000 4,000, 000 2,000, 000 - 0 2017 2018 2019 2020 2021 2022 YTD 2023 5 Packet Pg. 49 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2023 Sales and Use Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 911,577 $ 911,577 $ 879,231 -3.55% February 1,999,408 1,087,831 1,908,832 -4.53% March 2,854,859 855,451 2,781,110 -2.58% April 3,643,225 788,366 3,621,184 -0.60% May 4,624,484 981,259 4,607,308 -0.37% June 5,567,972 943,488 5,538,698 -0.53% July 6,580,085 1,012,114 6,542,037 -0.58% August 7,669,335 1,089,249 7,597,605 -0.94% September 8,683,583 1,014,248 8,581,012 -1.18% October 9,768,647 1,085,064 9,602,316 -1.70% November 10,864,900 1,096,253 10,660,200 -1.88% December 11,900,000 1,035,100 11,614,826 -2.40% Sales and Use Tax 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget � Prior Year City of Edmonds, WA Monthly Revenue Summary -Real Personal/Property Tax 2023 Real Personal/Property Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 49,915 $ 49,915 $ 26,466 -46.98% February 78,108 28,192 147,332 88.63% March 375,054 296,947 824,405 119.81% April 912,236 537,182 4,885,632 435.57% May 5,909,096 4,996,860 5,742,964 -2.81% June 6,029,957 120,861 5,794,100 -3.91% July 6,148,773 118,816 5,817,644 -5.39% August 6,198,768 49,995 5,868,802 -5.32% September 6,260,415 61,647 6,034,775 -3.60% October 6,466,132 205,717 9,911,687 53.29% November 11,227,156 4,761,024 10,603,949 -5.55% December 11,327,000 99,844 10,640,784 -6.06% *The monthly budget forecast columns are based on a five-year average. 6 Packet Pg. 50 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary -Water Utility Tax 2023 Water Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 86,205 $ 86,205 86,092 -0.13% February 146,468 60,263 143,978 -1.70% March 232,107 85,639 221,845 -4.42% April 288,835 56,728 279,282 -3.31% May 373,578 84,744 363,282 -2.76% June 439,121 65,542 431,287 -1.78% July 541,031 101,910 543,193 0.40% August 629,368 88,337 633,755 0.70% September 748,356 118,987 752,727 0.58% October 835,253 86,898 835,975 0.09% November 933,046 97,793 926,022 -0.75% December 993,712 60,666 986,657 -0.71% Water Utility Tax 1,000,000 900,000 800,000 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 -d-- Prior Year City of Edmonds, WA Monthly Revenue Summary -Sewer Utility Tax 2023 Sewer Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 95,852 $ 95,852 $ 89,935 -6.17% February 174,661 78,808 166,439 -4.71% March 269,654 94,993 256,368 -4.93% April 348,626 78,972 333,172 -4.43% May 444,771 96,145 424,703 -4.51% June 523,850 79,080 501,909 -4.19% July 620,193 96,343 596,420 -3.83% August 699,682 79,489 673,646 -3.72% September 799,189 99,507 768,545 -3.83% October 879,620 80,432 846,310 -3.79% November 976,901 97,281 939,080 -3.87% December 1,055,821 78,920 1,016,403 -3.73% Sewer Utility Tax 1,200,000 1,100,000 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY RUN JUL AUG SEP OCT NOV DEC -CurrentYear Budget -d-- Prior Year *The monthly budget forecast columns are based on a five-year average. 7 Packet Pg. 51 I 2.4.a I City of'Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2023 Meter Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 898,592 $ 898,592 $ 860,924 -4.19% February 1,526,893 628,301 1,439,675 -5.71% March 2,419,579 892,685 2,218,275 -8.32% April 3,010,919 591,341 2,792,540 -7.25% May 3,894,276 883,356 3,632,474 -6.72% June 4,577,455 683,180 4,312,420 -5.79% July 5,644,291 1,066,835 5,431,418 -3.77% August 6,565,058 920,767 6,336,928 -3.47% September 7,805,695 1,240,637 7,526,584 -3.58% October 8,711,524 905,829 8,358,957 -4.05% November 9,730,927 1,019,403 9,259,364 -4.85% December 10,363,937 633,010 9,865,628 -4.81% City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2023 Storm Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 484,003 $ 484,003 $ 417,703 February 1,535,452 1,051,449 1,359,827 March 2,020,122 484,671 1,794,224 April 2,451,545 431,422 2,181,313 May 2,936,868 485,323 2,616,433 June 3,368,111 431,243 3,004,165 July 3,844,019 475,908 3,441,481 August 4,895,662 1,051,643 4,390,758 September 5,380,996 485,335 4,827,751 October 5,812,621 431,625 5,215,008 November 6,298,011 485,390 5,652,608 December 6,714,303 416,292 6,040,226 -13.70 % -11.44 % -11.18 % -11.02 % -10.91 % -10.81 % -10.47 % -10.31 % -10.28 % -10.28 % -10.25% -10.04 % Storm Water Sales 0 I 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. g Packet Pg. 52 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2023 Unmeter Sewer Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 958,430 $ 958,430 $ 900,021 -6.09% February 1,745,646 787,217 1,665,119 -4.61% March 2,695,497 949,850 2,565,291 -4.83% April 3,484,346 788,849 3,333,389 -4.33% May 4,445,696 961,351 4,249,590 -4.41% June 5,235,623 789,927 5,021,702 -4.09% July 6,198,081 962,458 5,967,694 -3.72% August 6,992,099 794,018 6,740,009 -3.61% September 7,987,044 994,945 7,689,885 -3.72% October 8,790,485 803,441 8,467,595 -3.67% November 9,763,192 972,707 9,396,183 -3.76% December 10,551,011 787,819 10,169,472 -3.62% Unmeter Sewer Sales I L,000,UUU 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,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. 9 Packet Pg. 53 I 2.4.a I City ofEdmonds, WA Monthly Expenditure Report -General Fund 2023 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 6,139,087 $ 6,139,087 $ 4,868,760 -20.69% February 11,066,844 4,927,757 10,063,682 -9.06% March 15,924,888 4,858,044 14,793,075 -7.11% April 20,588,171 4,663,283 18,985,494 -7.78% May 25,617,603 5,029,432 23,497,459 -8.28% June 31,418,317 5,800,714 28,704,022 -8.64% July 36,370,475 4,952,158 33,359,621 -8.28% August 41,138,767 4,768,292 38,672,822 -5.99% September 46,442,045 5,303,278 43,450,297 -6.44% October 51,703,607 5,261,562 47,415,870 -8.29% November 57,577,998 5,874,392 54,483,300 -5.37% December 63,983,894 6,405,896 59,676,660 -6.73% City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2023 Non -Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,716,685 $ 2,716,685 $ 1,642,894 -39.53% February 4,141,007 1,424,322 3,380,586 -18.36% March 5,447,525 1,306,518 4,986,307 -8.47% April 6,576,327 1,128,802 6,091,521 -7.37% May 7,990,524 1,414,198 7,245,913 -9.32% June 10,085,491 2,094,966 9,392,113 -6.88% July 11,330,044 1,244,553 10,555,304 -6.84% August 12,396,436 1,066,391 12,600,704 1.65% September 13,836,518 1,440,082 13,727,753 -0.79% October 15,167,446 1,330,928 13,998,873 -7.70% November 16,810,986 1,643,540 17,150,215 2.02% December 18,579,347 1,768,361 17,981,733 -3.22% Non -Departmental 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 — 8,000,000 6,000,000 4,000,000 2,000,000 le- 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. 10 Packet Pg. 54 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2023 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 31,587 $ 31,587 $ 33,649 6.53% February 65,597 34,010 71,252 8.62% March 104,151 38,554 108,460 4.14% April 141,020 36,870 142,437 1.00% May 188,108 47,087 180,396 -4.10% June 237,876 49,768 208,152 -12.50% July 275,165 37,290 249,010 -9.51% August 325,994 50,829 283,971 -12.89% September 365,198 39,203 319,066 -12.63% October 398,695 33,497 348,675 -12.55% November 440,782 42,088 390,805 -11.34% December 486,719 45,937 423,907 -12.91% City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2023 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 41,345 $ 41,345 $ 32,343 -21.77% February 84,589 43,243 63,133 -25.37% March 126,357 41,768 101,671 -19.54% April 168,957 42,600 133,210 -21.16% May 210,634 41,677 164,114 -22.09% June 251,812 41,178 195,229 -22.47% July 293,809 41,997 229,429 -21.91% August 335,446 41,636 259,788 -22.55% September 377,299 41,854 290,606 -22.98% October 418,301 41,002 321,038 -23.25% November 461,679 43,378 354,414 -23.23% December 505,239 43,560 383,612 -24.07% *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 55 1 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2023 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 115,695 $ 115,695 $ 93,116 -19.52% February 219,840 104,145 164,590 -25.13% March 315,272 95,432 230,737 -26.81% April 415,812 100,540 296,057 -28.80% May 516,054 100,242 367,942 -28.70% June 651,834 135,780 455,291 -30.15% July 741,246 89,412 531,164 -28.34% August 839,112 97,865 605,627 -27.83% September 944,153 105,041 694,844 -26.41% October 1,042,607 98,454 774,485 -25.72% November 1,156,556 113,949 876,005 -24.26% December 1,297,746 141,190 1,003,524 -22.67% Human Resources 1,300,000 11200,000 1,100,000 1,000,000 900,000 800,000 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 --0--Current Year Budget-PriorYear City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2023 Municipal Court Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 135,694 $ 135,694 $ 114,975 -15.27% February 273,214 137,520 231,321 -15.33% March 414,829 141,615 352,625 -15.00% April 558,136 143,307 476,351 -14.65% May 711,840 153,704 611,186 -14.14% June 853,118 141,278 726,808 -14.81% July 997,788 144,670 855,668 -14.24% August 1,159,264 161,476 980,820 -15.39% September 1,307,192 147,929 1,097,393 -16.05% October 1,460,910 153,718 1,213,326 -16.95% November 1,645,269 184,359 1,343,740 -18.33% December 1,827,709 182,440 1,499,361 -17.97% Municipal Court 800,000 11,400,000 800,000 Illf- 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. 12 Packet Pg. 56 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2023 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 82,768 $ 82,768 $ 84,200 1.73% February 173,748 90,980 172,586 -0.67% March 267,297 93,549 263,059 -1.59% April 356,785 89,487 362,832 1.70% May 449,350 92,565 470,437 4.69% June 543,530 94,180 599,614 10.32% July 642,047 98,517 718,488 11.91% August 759,375 117,328 872,904 14.95% September 869,058 109,683 962,363 10.74% October 983,298 114,241 1,079,290 9.76% November 1,129,896 146,598 1,185,309 4.90% December 1,312,555 182,659 1,310,217 -0.18% *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 57 1 I 2.4.a I City ofEdmonds, WA Monthly Expenditure Report - Fund 512 - Technology Rental Fund 2023 Fund 512 - Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 250,404 $ 250,404 $ 355,645 42.03% February 414,969 164,565 530,347 27.80% March 640,247 225,278 683,467 6.75% April 730,096 89,849 798,011 9.30% May 858,153 128,058 888,529 3.54% June 1,004,204 146,051 982,174 -2.19% July 1,112,961 108,757 1,136,037 2.07% August 1,275,174 162,213 1,265,855 -0.73% September 1,437,766 162,592 1,423,867 -0.97% October 1,620,276 182,510 1,518,443 -6.28% November 1,740,078 119,802 1,623,461 -6.70% December 2,022,460 282,382 1,840,142 -9.01% City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2023 Administrative Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 265,902 $ 265,902 $ 253,437 -4.69% February 452,065 186,163 571,249 26.36% March 638,942 186,877 774,413 21.20% April 830,237 191,295 964,313 16.15% May 1,020,418 190,181 1,156,484 13.33% June 1,279,620 259,202 1,327,293 3.73% July 1,494,954 215,334 1,531,898 2.47% August 1,686,406 191,452 1,715,648 1.73% September 1,878,906 192,501 1,936,486 3.06% October 2,079,936 201,029 2,150,254 3.38% November 2,305,663 225,728 2,347,890 1.83% December 2,502,670 197,007 2,563,246 2.42% Administrative Services 2,600,000 2,400,000 2,200,000 2,000,000 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400000 200: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. 14 Packet Pg. 58 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2023 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 96,815 $ 96,815 $ 24,570 -74.62% February 193,630 96,815 109,813 -43.29% March 290,445 96,815 186,270 -35.87% April 387,260 96,815 276,332 -28.64% May 484,075 96,815 347,909 -28.13% June 580,890 96,815 427,830 -26.35% July 677,705 96,815 534,282 -21.16% August 774,520 96,815 559,282 -27.79% September 871,335 96,815 704,483 -19.15% October 968,150 96,815 788,660 -18.54% November 1,064,965 96,815 888,974 -16.53% December 1,161,780 96,815 1,054,359 -9.25% Police City Attorney 1,200,000 1,100,000 1,000,000 900,000 800,000 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 -Police 2023 Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 1,152,219 $ 1,152,219 $ 1,041,369 -9.62% February 2,303,200 1,150,981 2,119,852 -7.96% March 3,506,383 1,203,182 3,173,554 -9.49% April 4,666,954 1,160,572 4,326,784 -7.29% May 5,869,645 1,202,691 5,521,298 -5.93% June 7,139,594 1,269,949 6,661,514 -6.70% July 8,346,501 1,206,907 7,971,401 -4.49% August 9,483,363 1,136,862 9,201,003 -2.98% September 10,680,325 1,196,962 10,558,632 -1.14% October 11,920,386 1,240,061 11,879,715 -0.34% November 13,374,493 1,454,107 13,446,544 0.54% December 14,839,513 1,465,020 15,040,900 1.36% *The monthly budget forecast columns are based on a five-year average. 15 Packet Pg. 59 I 2.4.a I City ofEdmonds, WA Monthly Expenditure Report -Planning & Development 2023 Planning & Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 396,763 $ 396,763 $ 286,492 -27.79% February 814,630 417,867 595,086 -26.95% March 1,215,923 401,293 913,919 -24.84% April 1,639,139 423,216 1,265,403 -22.80% May 2,055,194 416,055 1,622,646 -21.05% June 2,468,896 413,702 1,934,311 -21.65% July 2,920,497 451,601 2,263,472 -22.50% August 3,344,297 423,800 2,566,672 -23.25% September 3,786,123 441,826 2,913,241 -23.05% October 4,225,508 439,384 3,191,421 -24.47% November 4,698,931 473,423 3,515,544 -25.18% December 5,246,507 547,576 4,047,163 -22.86% Planning & Development 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 Yeaz Budget -0-- Prior Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2023 Parks & Recreation Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 451,633 $ 451,633 $ 589,720 30.57% February 945,523 493,890 958,125 1.33% March 1,439,502 493,979 1,386,849 -3.66% April 1,934,287 494,786 1,788,118 -7.56% May 2,440,135 505,848 2,229,794 -8.62% June 2,977,014 536,879 2,623,359 -11.88% July 3,564,356 587,342 3,206,401 -10.04% August 4,172,695 608,339 3,766,096 -9.74% September 4,827,687 654,992 4,346,603 -9.97% October 5,365,736 538,049 4,977,108 -7.24% November 5,914,991 549,255 5,476,396 -7.41% December 6,484,904 569,913 5,964,309 -8.03% Parks & Recreation 7,000,000 6,500,000 6,000,000 5,500,000 5,000,000 41500,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 Yeaz Budget � Prior Yeaz *The monthly budget forecast columns are based on a five-year average. 16 Packet Pg. 60 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report - Fund 016 - Building Maintenance Fund 2023 Fund 016 -Building Maintenance Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 106,250 $ 106,250 $ 81,158 -23.62% February 212,500 106,250 97,897 -53.93% March 318,750 106,250 100,936 -68.33% April 425,000 106,250 116,404 -72.61% May 531,250 106,250 35,246 -93.37% June 637,500 106,250 102,751 -83.88% July 743,750 106,250 128,411 -82.73% August 850,000 106,250 128,411 -84.89% September 956,250 106,250 229,858 -75.96% October 1,062,500 106,250 406,199 -61.77% November 1,168,750 106,250 625,190 -46.51% December 1,275,000 106,250 728,888 -42.83% City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2023 Facilities Maintenance Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 279,527 $ 279,527 $ 335,018 19.85% February 638,903 359,376 935,298 46.39% March 1,011,874 372,971 1,264,752 24.99% April 1,367,475 355,601 1,451,697 6.16% May 1,690,876 323,401 1,803,967 6.69% June 1,957,047 266,171 2,002,414 2.32% July 2,280,286 323,239 2,209,753 -3.09% August 2,699,956 419,669 2,409,557 -10.76% September 3,185,324 485,369 2,642,907 -17.03% October 3,725,458 540,133 3,067,071 -17.67% November 4,170,818 445,360 3,504,989 -15.96% December 4,877,452 706,634 4,003,536 -17.92% Facilities Maintenance 11500,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. 17 Packet Pg. 61 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2023 Engineering Cumulative Monthly TFD Variance Budget Forecast Budget Forecast ActuaIs January $ 283,132 $ 283,132 $ 261,418 -7.67% February 567,413 284,281 531,670 -6.30% March 856,666 289,253 807,168 -5.78% April 1,149,630 292,964 1,076,687 -6.34% May 1,470,075 320,445 1,353,969 -7.90% June 1,765,968 295,893 1,652,623 -6.42% July 2,074,354 308,386 1,918,939 -7.49% August 2,376,166 301,813 2,184,156 -8.08% September 2,668,549 292,382 2,479,814 -7.07% October 2,965,801 297,252 2,749,498 -7.29% November 3,290,206 324,405 3,028,489 -7.95% December 3,615,509 325,303 3,317,994 -8.23% Engine a ring 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 Yew Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 18 Packet Pg. 62 I 2.4.a I Page 1 of 1 CITY OF EDMONDS REVENUES BY FUND - SUMMARY Fund 2023 Amended 12/31/2022 12/31/2023 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 52,558,830 $ 45,316,180 $ 50,005,535 $ 2,553,295 950/( 009 LEOFF-MEDICAL INS. RESERVE 225,000 225,000 225,000 - 1000/( 012 CONTINGENCY RESERVE FUND 447,522 - 446,522 1,000 1000/( 014 HISTORIC PRESERVATION GIFT FUND - - - - 00/( 016 BUILDING MAINTENANCE FUND 17,480 55,951 99,052 (81,572) 5670/( 017 MARSH RESTORATION & PRESERVATION FUND - 1,150 3,829 (3,829) 00/c 018 EDMONDS HOMELESSNESS RESPONSE FUND - 200,000 - - 00/( 019 EDMONDS OPIOID RESPONSE FUND - 49,007 74,119 (74,119) 00/( 104 DRUG ENFORCEMENT FUND 167,650 1,439 2,094 165,556 10/( Ill STREET FUND 2,415,410 1,805,203 2,031,941 383,469 840/( 112 COMBINED STREET CONST/IMPROVE 12,366,800 4,736,196 9,228,072 3,138,728 750/( 117 MUNICIPAL ARTS ACQUIS. FUND 99,220 137,745 83,686 15,534 840/c 118 MEMORIAL STREET TREE - - - - 00/( 120 HOTEL/MOTEL TAX REVENUE FUND 84,400 120,619 123,092 (38,692) 1460/( 121 EMPLOYEE PARKING PERMIT FUND 38,960 27,423 30,140 8,820 770/c 122 YOUTH SCHOLARSHIP FUND 1,660 1,904 1,650 10 990/( 123 TOURISM PROMOTIONAL FUND/ARTS 30,440 41,726 43,574 (13,134) 1430/( 125 REAL ESTATE EXCISE TAX 2 2,320,090 2,026,204 1,442,288 877,802 620/( 126 REAL ESTATE EXCISE TAX 1 2,302,980 2,021,471 1,495,772 807,208 650/( 127 GIFTS CATALOG FUND 232,490 3,012,757 223,410 9,080 960/( 130 CEMETERY MAINTENANCE/IMPROVEMT 150,960 223,577 186,693 (35,733) 1240/( 136 PARKS TRUST FUND 5,460 3,283 (7,497) 12,957 1370/c 137 CEMETERY MAINTENANCE TRUST FD 51,500 41,700 55,880 (4,380) 1090/( 138 SISTER CITY COMMISSION 10,430 5,327 5,670 4,760 5401( 140 BUSINESS IMPROVEMENT DISTRICT 88,645 91,918 77,373 11,272 870/c 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 74,906 73,802 (8,802) 1140/( 142 EDMONDS RESCUE PLAN FUND 1,879,000 1,046,776 1,307,155 571,845 700/( 143 TREE FUND 215,100 216,163 7,379 207,721 30/c 231 2012 LT GO DEBT SERVICE FUND 309,800 311,184 309,790 10 1000/( 332 PARKS CAPITAL CONSTRUCTION FUND 2,713,902 2,115,970 2,109,838 604,064 780/( 411 COMBINED UTILITY OPERATION - - - - 00% 421 WATER UTILITYFUND 11,950,114 10,811,600 11,556,762 393,352 970/( 422 STORM UTILITY FUND 9,095,452 6,687,933 7,486,675 1,608,777 820/( 423 SEWER/WWTPUTILITY FUND 16,895,408 19,157,080 17,341,312 (445,904) 1030/( 424 BOND RESERVE FUND 1,991,860 1,997,858 2,008,018 (16,158) 1010/( 511 EQUIPMENT RENTAL FUND 4,344,498 1,856,779 2,840,496 1,504,002 650/( 512 TECHNOLOGY RENTAL FUND 1,647,271 1,299,873 1,609,550 37,721 980/( $ 124,723,332 $105,721,902 $ 1129528,670 $ 12,194,662 900% 19 Packet Pg. 63 I 2.4.a I Page 1 of 1 CITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2023 Amended 12/31/2022 12/31/2023 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 63,983,894 $ 49,029,312 $ 59,676,660 $ 4,307,234 930/c 009 LEOFF-MEDICAL INS. RESERVE 367,140 247,402 309,063 58,077 840/c Ol l RISK MANANGEMENT RESERVE FUND 25,000 - 25,000 - 1000/( 014 HISTORIC PRESERVATION GIFT FUND 5,900 4,721 2,757 3,143 470/( 016 BUILDING MAINTENANCE FUND 1,275,000 16,124 728,888 546,112 570/c 017 MARSH RESTORATION & PRESERVATION FUND - - - - 00/( 018 EDMONDS HOMELESSNESS RESPONSE FUND - - 00/c 019 EDMONDS OPIOID RESPONSE FUND - - - - 00/c 104 DRUG ENFORCEMENT FUND 45,800 6,291 32,485 13,315 710/c III STREET FUND 2,746,179 2,155,095 2,617,110 129,069 950/c 112 COMBINED STREET CONST/IMPROVE 11,273,695 5,339,523 8,158,876 3,114,819 720/( 117 MUNICIPAL ARTS ACQUIS. FUND 207,380 125,445 112,134 95,246 540/( 118 MEMORIAL STREET TREE - - - - 00/( 120 HOTEL/MOTEL TAX REVENUE FUND 95,400 111,658 73,446 21,954 770/( 121 EMPLOYEE PARKINGPERMIT FUND 26,880 25,830 25,915 965 960/c 122 YOUTH SCHOLARSHIP FUND 3,000 322 (75) 3,075 -30/c 123 TOURISM PROMOTIONAL FUND/ARTS 28,500 18,487 27,250 1,250 960/c 125 REAL ESTATE EXCISE TAX 2 4,315,418 2,745,445 2,845,933 1,469,485 660/c 126 REAL ESTATE EXCISE TAX 1 2,627,383 1,149,597 1,722,867 904,516 660/c 127 GIFT S CATALOG FUND 551,598 109,969 329,434 222,164 600/c 130 CEMETERY MAINTENANCE/IMPROVEMT 291,530 210,167 274,143 17,387 940/( 136 PARKS TRUST FUND 216,062 3,804 161,439 54,623 750/c 137 CEMETERY MAINTENANCE TRUST FUND 50,000 - 13,813 36,188 280/c 138 SISTER CITY COMMISSION 11,900 70 8,049 3,851 680/c 140 BUSINESS IMPROVEMENT DISTRICT 88,575 81,266 78,809 9,766 890/( 142 EDMONDS RESCUE PLAN FUND 1,879,000 1,027,076 1,334,810 544,190 710/c 143 TREE FUND 239,800 - 25,000 214,800 100/( 231 2012 LT GO DEBT SERVICE FUND 309,800 311,184 310,140 (340) 1000/( 332 PARKS CAPITAL CONSTRUCTION FUND 2,255,647 6,371,883 2,073,371 182,276 920/( 421 WATER UTILITY FUND 11,949,308 8,315,491 10,321,356 1,627,952 860/( 422 STORM UTILITY FUND 8,525,900 7,053,182 5,840,127 2,685,773 680/c 423 SEWER/WWT P UTILITY FUND 18,972,999 19,995,099 16,774,605 2,198,394 880/c 424 BOND RESERVE FUND 1,989,820 1,988,684 1,989,784 36 1000/c 511 EQUIPMENT RENTAL FUND 5,057,583 1,497,185 2,966,013 2,091,570 590/c 512 TECHNOLOGY RENTAL FUND 2,022,460 1,547,277 1,840,142 182,318 910/( $ 141,438,551 $109,487,590 $120,699,346 $ 20,739,205 850/, 20 Packet Pg. 64 2.4.a Page 1 of 3 C ITY O F IDMO NDS REVENUES - GENERAL FUND 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALES/USE TAX 1 5 NATURAL GAS USE TAX 6 1/10 SALESTAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GASUTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWERUTILITYTAX 12 STORMWATER UTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABS TAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE -FINGERPRINTING 20 VENDINGMACHINE/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 BUILDINGPERMITS 29 FIRE PERMIT 30 ENGINEERING PERMIT 31 ANIMAL LICENSES 32 STREET AND CURB PERMIT 33 STREET AND CURB PERMIT W/LEASEHOLD TAX 34 OT R NON -BUS LIC/PERMIT S 35 SPECIAL EVENT REVIEW $ 11,327,000 $ 10,615,296 $ 10,640,784 $ 686,216 940N 4,578,000 4,228,289 4,268,023 309,977 930N 500 67 4 496 10N 11,900,000 11,257,927 11,614,826 285,174 980N 7,600 18,166 13,204 (5,604) 1740% 1,150,000 1,037,663 1,047,939 102,061 91 % 1,900,000 1,716,131 1,773,627 126,373 930% 845,000 768,250 871,234 (26,234) 1030% 384,000 384,011 404,970 (20,970) 1050% 1,000,234 930,784 986,657 13,577 990N 942,960 882,079 1,016,403 (73,443) 1080/( 621,458 581,581 604,027 17,431 970% 850,000 826,116 818,102 31,898 960% 773,000 494,489 421,228 351,772 540/( 80,200 75,083 57,733 22,467 720N 350 - 62 288 180/( 326,000 313,139 319,661 6,339 980N 36,686,302 34,129,072 34,858,487 1,827,815 950% 250 450 50 200 200% 700 320 805 (105) 11501( 94,500 84,172 88,890 5,610 940/( 702,700 696,556 691,132 11,568 980N 41,000 35,189 29,521 11,479 720% 100,600 45,854 47,151 53,449 470N 450,000 434,655 486,551 (36,551) 1080% 250,000 235,256 236,478 13,522 950/( 80,000 99,970 108,365 (28,365) 1350N 30,000 30,173 438,918 (408,918) 14630N 750,600 769,928 270,646 479,954 360N - - 8,546 (8,546) 00% - - 98,748 (98,748) 00/( 24,000 20,483 25,467 (1,467) 1060% 75,000 95,083 21,178 53,822 280% - - 6,798 (6,798) 00N 20,000 75 19,119 881 960N - 20,200 726 (726) 00% 2,619,350 2,568,363 2,579,089 40,261 980% INTERGOVERNMENTAL: 36 FEDERAL GRANTS- BUDGET ONLY 166,309 - - 166,309 00/( 37 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 9,000 5,237 - 9,000 00N 38 WA SASSOC OF SHERIFFS TRAFFIC GRANT - 992 31,313 (31,313) 00% 39 HIGH VISIBILITY ENFORCEMENT 11,100 5,725 16,915 (5,815) 1520/( 40 CORONAVIRUS RELIEF FUND 1,494,875 85,319 116,544 1,378,331 80/( 41 HOUSING TO INFRASTRUCTURE PROGRAM (CHIP) 1,361,011 - 1,361,011 - 1000/( 42 STATE GRANTS- BUDGET ONLY 244,645 - 244,645 00/( 43 STATE GRANT FROM OTHER JUDICIAL AGENCIES 161,004 - - 161,004 00% 44 WA STATE TRAFFIC COMM GRANT - 307 - - 00/( 45 SCHOOL ZONE - 1,337 (1,337) 00/( 46 GMA PERIODIC UPDATE GRANT - FY 2023 - - 62,500 (62,500) 00N 47 WASHINGTON STATE ARTS COMMISSION 34,000 2,000 3,000 31,000 90/( 48 PUT) PRIVILEDGE TAX 210,500 214,277 219,274 (8,774) 1040/( 49 TRIAL COURT IMPROVEMENT 16,740 21,550 21,354 (4,614) 1280/( 50 CJ - POPULATION 13,070 14,744 15,545 (2,475) 1190N 51 CRIMINAL JUSTICE -SPECIAL PROGRAMS 50,600 52,278 54,864 (4,264) 1080% 52 MARIJUANA EXCISE TAX DISTRIBUTION 125,000 109,364 108,470 16,530 870/( 53 DUI - CITIES 4,500 4,913 2,974 1,526 660/( 54 FIRE INS PREMIUM TAX - 56,744 75,698 (75,698) 00N 55 LIQUOR EXCISE TAX 325,000 303,313 301,353 23,647 930/( 56 LIQUOR BOARD PROFITS 343,200 332,720 328,619 14,581 960/( 57 MISCELLANEOUS INTERLOCAL REVENUE - 13,780 500 (500) 00% 58 INTERLOCAL GRANTS 84,506 - - 00/( 59 VERDANT INTERLOCAL GRANTS - - 20,000 (20,000) 00% 60 FIRST RESPONDERS FLEX FUND 1,000 1,693 658 342 660/( 61 DISCOVERY PROGRAMS TECHNOLOGY ACQ. 550 - - 550 00/( 62 AWC - SEEK FUND - 63,757 - - 00% 4,572,104 1,373,217 2,741,928 1,930,176 60% 1 2022 Local Retail Sales/Use Tax revenues are $356,899 hi-34er than 2021 revenues Please also see paces Packet Pg. 65 1 2.4.a Page 2 of 3 CITY OF FDMO NDS REVENUES - GENERAL FUND 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Revenues Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS 2 MUNICIPAL COURT CIVIL FILINGS 3 ATM SURCHARGE FEES 4 CREDIT CARD FEES 5 COURT RECORD SERVICES 6 D/M COURT REC SER 7 WARRANT PREPARATION FEE 8 IT TIME PAY FEE 9 MUNIC.-DIST. COURT CURREXPEN 10 CLERKS TIME FOR SALE OF PARKING PERMIT S 11 BID SUPPLIES REIMBURSEMENT 12 PHOTOCOPIES 13 POLICE DISCLOSURE REQUESTS 14 ENGINEERING FEES AND CHARGES 15 ELECTION CANDIDATE FILING FEES 16 CUSTODIAL SERVICES(SNO-ISLE) 17 PASSPORTS AND NATURALIZATION FEES 18 POLICE SERVICES SPECIAL EVENTS 19 CAMPUS SAFETY-EDM. SCH. DIST. 20 WOODWAY-LAW PROTECTION 21 CJTC TAC REIMBURSEMENT 22 MISCELLANEOUS POLICE SERVICES 23 FIRE DISTRICT #1 STATION BILLINGS 24 LEGAL SERVICES 25 ADULT PROBATION SERVICE CHARGE 26 BOOKING FEES 27 FIRE CONSTRUCTION INSPECTION FEES 28 EMERGENCY SERVICE FEES 29 EMS TRANSPORT USER FEE 30 FLEX FUEL PAYMENTS FROM STATIONS 31 ANIMAL CONTROL SHELTER 32 ZONING/SUBDIVISION FEE 33 BUILDING PLAN REVIEW AND INSPECTION 34 FIRE PLAN REVIEW 35 PLANNINGREVIEW AND INSPECTION 36 S.E.P.A. REVIEW 37 ENGINEERINGPLAN REVIEW AND INSPECTION 38 CRITICAL AREA STUDY 39 GYM AND WEIGHTROOM FEES 40 PROGRAM FEES 41 HOLIDAY MARKET REGISTRATION FEES 42 UP TOWN EVENING MARKET FEES 43 WINTER MARKET FEES 44 EDMONDS COMMUNITY FAIR FEES 45 BIRD FEST REGISTRATION FEES 46 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 5,943 $ 2,214 $ 787 740/ - 22 _ - 00/ 600 310 286 314 480/ 6,000 441 120 5,880 20/ 150 1 1 149 10/ 300 - - 300 00/ 4,000 98 - 4,000 00/ 1,000 81 81 919 80/ 50 172 332 (282) 6650, 25,000 25,090 25,090 (90) 1000/ - 615 - - 00/ 100 78 51 49 510/ 1,000 - - 1,000 00/ 190,000 220,228 34,921 155,079 180/ 1,400 2,885 - 1,400 00/ 100,000 80,443 50,996 49,004 510/ 5,000 4,518 49,051 (44,051) 9810/ 30,000 17,188 14,793 15,207 490/ 14,000 14,358 4,929 9,071 350/ 210,970 171,940 288,460 (77,490) 1370/ - - 88,965 (88,965) 00/ - 25 20 (20) 00/ 67,000 62,047 71,339 (4,339) 1060/ 1,050 902 - 1,050 00/ 38,000 18,704 9,172 28,828 240/ 3,000 539 289 2,711 100/ 10,000 32,382 27,372 (17,372) 2740/ 3,500 1,177 811 2,689 230/ 1,077,500 1,031,623 1,231,212 (153,712) 1140/ 5,000 4,641 5,619 (619) 1120/ - 100 400 (400) 00/ 65,600 98,491 16,819 48,781 260/ 425,000 447,807 888,669 (463,669) 2090/ 4,000 22,438 22,823 (18,823) 5710/ 500 110 81,331 (80,831) 162660/ 3,000 6,935 3,852 (852) 1280/ - - 162,189 (162,189) 00/ 14,000 15,435 16,719 (2,719) 1190/ 13,000 3,881 8,343 4,657 640/ 990,959 641,314 841,507 149,452 850/ 5,000 16,235 17,030 (12,030) 3410/ 5,000 4,505 - 5,000 00/ 5,000 9,350 10,385 (5,385) 2080/ - - 560 (560) 00/ 1,000 855 - 1,000 00/ 3,427,765 3,438,210 3,698,957 (271,192) 1080/ 6,757,444 6,402,115 7,675,709 (918,265) 1140/ 22 Packet Pg. 66 2.4.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Amended 12/31/2022 12/31/2023 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 TRAFFIC CAMERA INFRACTIONS 5 CRT COST FEE CODE LEG ASSESSMENT (LGA) 6 CURRENT TRAFFIC INFRACTIONS 7 NON -TRAFFIC INFRACTION PENALTIES 8 OTHERINFRACTIONS'04 9 PARKING INFRACTION PENALTIES 10 PARK/INDDISZONE 11 DWI PENALTIES 12 DUI - DP ACCT 13 CRIM CNV FEE DUI 14 DUI - DP FEE 15 CRIMINAL TRAFFIC MISDEMEANOR 8/03 16 CRIMINAL CONVICTION FEE CT 17 CRIM CONV FEE CT 18 OTHER NON-T RAF MISDEMEANOR PEN 19 OTHER NON TRAFFIC MISD. 8/03 20 COURT DV PENALTY ASSESSMENT 21 CRIMINAL CONVICTION FEE CN 22 CRIM CONV FEE CN 23 PUBLIC DEFENSE RECOUPMENT 24 BANK CHARGE FOR CONV. DEFENDANT 25 COURT COST RECOUPMENT 26 BUS. LICENSE PERMIT PENALTY 27 MISC FINESAND PENALTIES MISCELLANEOUS: 28 INVESTMENT INTEREST 29 INTEREST ON COUNTY TAXES 30 INTEREST - COURT COLLECTIONS 31 LOAN INTEREST 32 SPACE/FACILITIESRENTALS 33 BRACKET ROOM RENTAL 34 LEASESLONG-TERM 35 DONATION/CONTRIBUTION 36 PARKSDONATIONS 37 BIRD FEST CONTRIBUTIONS 38 POLICE CONTRIBUTIONS FROM PRIV SOURCES 39 SALE OF JUNK/SALVAGE 40 SALES OF UNCLAIM PROPERTY 41 CONFISCATED AND FORFEITED PROPERTY 42 OTHER JUDGEMENT/SETTLEMENT 43 POLICE JUDGMENT SIREST ITUT ION 44 CASHIER'S OVERAGES✓SHORTAGES 45 OTHER MISC REVENUES 46 SMALL OVERPAYMENT 47 NSF FEES - PARKS & REC 48 NSF FEES - MUNICIPAL COURT 49 NSF FEES - DEVEL SERV DEPT 50 L&I STAY AT WORK PROGRAM 51 US BANK REBATE TRANSFER IN: 52 INSURANCE RECOVERIES 53 INTERFUND TRANSFER FROM FUND 011 53 INTERFUND TRANSFER FROM FUND 136 52 TRANSFER FROM FUND 127 TOTAL GENERAL FUND REVENUE $ 2,000 $ 1,689 $ 1,947 $ 53 970/ 130,000 87,706 68,486 61,514 530/ 18,000 3,480 1,798 16,202 100/ 50,000 - - 50,000 00/ 10,000 6,239 1,710 8,290 170/ - - 73,496 (73,496) 00/ 1,000 - 5,386 (4,386) 5390/ 1,500 961 1,938 (438) 1290/ 125,000 41,301 17,500 107,500 140/ 2,000 795 1,420 580 710/ 7,000 3,837 3,073 3,927 440/ 300 154 3 297 10/ 100 26 - 100 00/ 1,500 1,609 1,349 151 900/ 25,000 9,683 6,372 18,628 250/ 2,000 1,592 1,068 932 530/ 700 103 22 678 30/ 100 - 100 0 1000/ 12,000 14,811 518 11,482 40/ 800 34 100 700 130/ 1,000 340 91 909 90/ 200 - - 200 00/ 6,000 3,131 1,179 4,821 200/ 4,000 4,612 5,316 (1,316) 1330/ 1,000 593 1,498 (498) 15001 1,000 188 - 1,000 00/ 150 - - 150 00/ 402,350 182,881 194,369 207,981 480, 321,240 223,497 171,684 149,556 530/ 10,960 22,845 73,150 (62,190) 6670/ 12,180 4,177 2,581 9,599 210/ 12,080 15,494 - 12,080 00/ 175,000 135,168 180,521 (5,521) 1030/ 2,100 - - 2,100 00, 210,000 206,212 225,669 (15,669) 1070/ 1,500 1,276 1,128 372 750/ 3,500 5,050 16,500 (13,000) 4710, 1,500 2,070 2,057 (557) 1370/ 5,000 249 100 4,900 20/ 300 398 7,551 (7,251) 25170/ 3,800 4,269 4,387 (587) 11501 2,000 - - 2,000 00/ 146,000 - 2,542 143,458 20/ 200 308 98 102 490/ - 734 13 (13) 00/ 5,000 (5,402) 333,283 (328,283) 66660/ 100 49 1 99 10/ 100 30 30 70 300/ 150 180 240 (90) 1600/ - 60 64 (64) 00/ - 6,527 8,702 (8,702) 00/ 8,500 11,043 13,486 (4,986) 1590/ 921,210 634,233 1,043,787 (122,577) 1130/ 500,000 815,000 (315,000) 1630/ 25,000 25,000 - 1000/ 75,070 - 72,066 3,004 960/ - 26,300 - - 00/ 600,070 26,300 912,066 (311,996) 1520, $ 52,558,830 $ 45,316,180 $ 50,005,435 $ 2,553,395 950, 23 Packet Pg. 67 I 2.4.a I Page 1 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 23,174,368 $ 18,508,918 $ 21,649,777 $ 1,524,591 930% 2 OVERTIME 649,080 1,067,129 1,053,795 (404,715) 1620% 3 HOLIDAY BUY BACK 294,001 233,490 187,135 106,866 640% 4 BENEFITS 7,959,238 6,660,671 7,745,858 213,380 970% 5 UNIFORMS 130,851 108,323 153,435 (22,584) 1170% 6 PENSION AND DISABILITY PAYMENTS 165,023 86,137 70,052 94,971 420% 7 SUPPLIES 770,473 479,723 572,730 197,743 740/( 8 SMALL EQUIPMENT 307,791 396,578 285,675 22,116 930% 9 PROFESSIONAL SERVICES 21,173,217 14,478,577 19,357,652 1,815,565 910/( 10 COMMUNICATIONS 241,295 179,562 245,659 (4,364) 1020% 11 TRAVEL 86,242 56,036 111,048 (24,806) 1290/( 12 EXCISE TAXES 16,500 29,191 27,624 (11,124) 1670% 13 RENTAL/LEASE 2,882,688 2,033,286 2,819,911 62,777 980/( 14INSURANCE 625,650 503,160 625,650 (0) 1000/( 15 UTILITIES 663,800 626,973 722,228 (58,428) 1090% 16 REPAIRS & MAINTENANCE 673,900 587,214 769,573 (95,673) 1140% 17 MISCELLANEOUS 673,640 555,204 741,068 (67,428) 1100% 18 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 50,000 - 1000/( 19 INTERFUND SUBSIDIES 1,432,740 1,315,062 1,101,522 331,218 770% 20 BUILDINGS 500,000 107,129 325,124 174,876 650/( 21 MACHINERY/EQUIPMENT 339,242 644,962 559,716 (220,474) 1650/( 22 CONST RUCT IONS PROJECTS 800,565 - 178,351 622,214 220% 23 PRINCIPAL PAYMENT LEASES 50,000 - - 50,000 00% 24 GENERAL OBLIGATION BOND PRINCIPAL 191,620 180,164 191,611 9 1000% 25 INTEREST ON LONG-TERM EXTERNAL DEBT 131,470 141,613 131,467 3 1000/( 26 OTHER INT EREST & DEBT SERVICE COSTS 500 212 - 500 00/( 33,983,894 49,029,312 59,676,660 4,307,234 930/( LEOFF-MEDICAL INS. RESERVE(009) 27 BENEFITS 28 PENSION AND DISABILITY PAYMENTS 29 PROFESSIONAL SERVICES 30 MISCELLANEOUS RISK MANAGEMENT RESERVE FUND (011) 31 INTERFUND SUBSIDIES HISTORIC PRESERVATION GIFTFUND (014) 32 SUPPLIES 33 PROFESSIONAL SERVICES 34 MISCELLANEOUS BUILDING MAINTENANCEFUND (016) 35 SUPPLIES 36 PROFESSIONAL SERVICES 37 REPAIR & MAINTENANCE 38 BUILDINGS 39 MACHINERY/EQUIPMENT 40 CONSTRUCTIONS PROJECTS DRUG INFO RCEMENTFUND (104) 41 SMALL EQUIPMENT 42 PROFESSIONAL SERVICES 43 REPAIR/MAINT 44 MACHINERY/EQUIPMENT $ 206,650 $ 135,622 $ 139,961 $ 66,689 680/( 152,990 97,591 150,102 2,888 980/( 7,000 13,704 19,000 (12,000) 2710% 500 485 - 500 00% 367,140 247,402 309,063 58,077 84% $ 25,000 $ $ 25,000 $ 1000% 25,000 25,000 1000% $ 100 $ $ - $ 100 00% 200 - 200 00% 5,600 4,721 2,757 2,843 490/( 5,900 4,721 2,757 3,143 470/( $ - $ $ 16,717 $ (16,717) 00% 121,500 703 120,797 10% 1,153,500 16,072 83,915 1,069,585 70% - - 308,099 (308,099) 00% 52 _ 00% - - 319,454 (319,454) 00/( $ 1,275,000 16,124 728,888 546,112 570% $ 10,000 $ $ 32,485 $ (22,485) 3250% - - - 0% 800 800 0% 35,000 6,291 35,000 00% 45,800 6,291 32,485 13,315 710/( 24 Packet Pg. 68 I 2.4.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent STREETFUND (111) 1 SALARIES AND WAGES $ 1,154,552 $ 693,766 $ 1,014,676 $ 139,876 880/( 2 OVERTIME 38,400 56,047 32,951 5,449 860/( 3 BENEFITS 440,911 342,596 423,279 17,632 960/( 4 UNIFORMS 6,000 5,212 4,404 1,596 730/( 5 SUPPLIES 263,000 214,356 206,099 56,901 780/( 6 SMALL EQUIPMENT 20,000 3,925 6,250 13,750 310/( 7 PROFESSIONAL SERVICES 23,210 20,410 17,070 6,140 740% 8 COMMUNICATIONS 4,500 7,077 6,696 (2,196) 1490/( 9 TRAVEL 1,000 - - 1,000 00/( 10 RENTAL/LEASE 304,730 290,729 305,538 (808) 1000/( 11 INSURANCE 126,466 184,111 126,467 (1) 1000/( 12 UTILITIES 273,730 262,744 269,620 4,110 980/( 13 REPAIRS & MAINTENANCE 52,000 44,890 27,394 24,606 5301( 14 MISCELLANEOUS 8,000 3,771 6,642 1,358 830/( 15 BUILDINGS 25,000 - - 25,000 00/( 16 OTHERIMPROVEMENTS - - 165,353 (165,353) 00% 17 MACHINERY/EQUIPMENT - 20,829 - 00/( 18 GENERAL OBLIGATION BOND PRINCIPAL 4,380 4,263 4,375 5 1000/( 19 INTEREST 300 370 299 1 1000/( $ 2,746,179 $ 2,155,095 $ 2,617,110 $ 129,069 950% COMBINED STREETCONST/IMPROVE(112) 20 PROFESSIONAL SERVICES $ 3,817,980 $ 1,983,655 $ 2,986,307 $ 831,673 780% 21 REPAIRS&MAINTENANCE 1,139,535 288,369 1,074,099 65,436 940% 22 INTERFUND SUBSIDIES 172,650 56,483 57,364 115,286 330/( 23 LAND 270,000 83,013 - 270,000 00% 24 CONST RUCT ION PROJECTS 5,818,580 2,854,570 3,986,178 1,832,402 690/( 25 INTERGOVERNMENTAL LOANS 54,070 72,201 54,058 12 1000/( 26 INTEREST 880 1,230 869 11 990% $ 11,273,695 $ 5,339,523 $ 8,158,876 $ 3,114,819 720% MUNIC IPAL ARTS AC Q UIS. FUND (117) 27 SUPPLIES $ 4,700 $ 2,034 $ 4,971 $ (271) 1060/( 28 SMALL EQUIPMENT 1,700 - 1,066 634 630/( 29 PROFESSIONAL SERVICES 191,000 120,329 96,761 94,239 5101( 30 TRAVEL 80 - 58 22 720% 31 RENTAL/LEASE 3,000 2,414 586 800% 32 REPAIRS & MAINTENANCE 300 - - 300 00/( 33 MISCELLANEOUS 6,600 3,082 6,864 (264) 1040/( $ 207,380 $ 125,445 $ 112,134 $ 95,246 540% HO TEL/MO TEL TAX REVENUE FUND (120) 34 PROFESSIONAL SERVICES $ 90,400 $ 107,658 $ 69,446 $ 20,954 770/( 35 MISCELLANEOUS 1,000 - - 1,000 00% 36 INTERFUND SUBSIDIES 4,000 4,000 4,000 - 1000/( $ 95,400 $ 111,658 $ 73,446 $ 21,954 770/( EMPLOYEEPARKING PERMIT FUND (12 1) 37 SUPPLIES $ 1,790 $ 740 $ 825 $ 965 460/( 38 PROFESSIONAL SERVICES 25,090 25,090 25,090 - 1000/( $ 26,880 $ 25,830 $ 25,915 $ 965 960% YOUTH SCHOLARSHIP FUND (122) 39 SUPPLIES $ - $ 322 $ - $ 00% 40 MISCELLANEOUS 3,000 - (75) 3,075 -30% $ 3,000 $ 322 $ (75) $ 3,075 -30/( TO URIS M PRO MO TIO NAL FUND/ARTS (123) 41 PROFESSIONAL SERVICES $ 28,500 $ 18,487 $ 27,250 $ 1,250 960% $ 28,500 $ 18,487 $ 27,250 $ 1,250 960/( 25 Packet Pg. 69 I 2.4.a I Page 3 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ $ 17,852 $ - $ 00/( 2 PROFESSIONAL SERVICES 616,867 1,029,183 604,253 12,614 980/( 3 REPAIRS&MAINTENANCE 1,148,910 196,512 678,848 470,062 590% 4 INTERFUND SUBSIDIES 5,684 - 4,468 1,216 790N 5 OTHERIMPROVEMENTS - 24,085 (24,085) 00% 6 LAND 200,000 - 195,400 4,600 980/( 7 CONSTRUCTION PROJECTS 2,343,957 1,501,898 1,338,880 1,005,077 570/( $ 4,315,418 $ 2,745,445 $ 2,845,933 $ 1,469,485 660/( REAL ESTATE EXCISE TAX 1 (126) 8 PROFESSIONAL SERVICES 9 REPAIRS & MAINTENANCE 10 INTERFUND SUBSIDIES 11 LAND 12 CONSTRUCTION PROJECTS 13 GENERAL OBLIGATION BONDS 14 INTEREST 15 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 16 SALARIES AND WAGES 17 OVERTIME 18 BENEFIT S 19 SUPPLIES 20 SMALL EQUIPMENT 21 PROFESSIONAL SERVICES 22 RENTAL/LEASE 23 MISCELLANEOUS 24 INTERFUND SUBSIDIES CEMETERY MAINTENANC EIMPRO VEMENT (130) 25 SALARIES AND WAGES 26 OVERTIME 27 BENEFIT S 28 UNIFORMS 29 SUPPLIES 30 SUPPLIES PURCHASED FOR INVENTORY/RESALE 31 PROFESSIONAL SERVICES 32 COMMUNICATIONS 33 TRAVEL 34 RENTAL/LEASE 35 UTILITIES 36 REPAIRS & MAINTENANCE 37 MISCELLANEOUS PARKS TRUSTFUND (136) 38 PROFESSIONAL SERVICES 39 INTERFUND SUBSIDIES CEMETERY MAINTENANCE TRUST FUND (137) 40 SMALL EQUIPMENT 41 REPAIRS & MAINTENANCE SISTER CITY COMMISSION (138) 42 SUPPLIES 43 TRAVEL 44 MISCELLANEOUS BUSINESS IMPROVEMINTDISTRICTFUND (140) 45 SUPPLIES 46 PROFESSIONAL SERVICES 47 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 48 PROFESSIONAL SERVICES TREE FUND (143) 49 SUPPLIES 50 PROFESSIONAL SERVICES 51 LAND $ 292,065 $ 611,705 $ 377,901 $ (85,836) 1290% 578,340 37,746 301,267 277,073 520% 548,575 141,084 365,013 183,562 670% 100,000 - 130,000 (30,000) 1300% 848,963 97,639 288,557 560,406 340% 155,470 149,814 155,465 5 1000% 103,970 110,629 103,964 6 1000N - 980 700 (700) 00/( $ 2,627,383 $ 1,149,597 $ 1,722,867 $ 904,516 660/( $ 241,455 $ $ 186,167 $ 55,288 770% - 5,791 (5,791) 00% 89,033 76,935 12,098 860N 146,000 83,495 42,683 103,317 290% 500 - - 500 00/( 56,500 - 56,500 00/( 17,510 - 17,510 (0) 1000/( 600 174 348 252 580% - 26,300 - - 00% $ 551,598 $ 109,969 $ 329,434 $ 222,164 600N $ 172,817 $ 106,163 $ 143,827 $ 28,990 830% 3,500 1,012 2,717 783 780/( 61,328 39,659 59,000 2,328 960% 1,000 - - 1,000 00% 7,000 4,115 6,273 727 900% 20,000 25,008 25,268 (5,268) 1260/( 4,200 1,695 3,793 407 900/( 1,700 1,724 1,727 (27) 1020/( 500 - - 500 00/( 9,420 11,809 9,538 (118) 1010% 5,565 5,706 11,967 (6,402) 2150% 500 3,536 1,337 (837) 2670/( 4,000 9,741 8,696 (4,696) 2170/( $ 291,530 $ 210,167 $ 274,143 $ 17,387 940/( $ 43,842 $ 3,804 $ - $ 43,842 00% 172,220 - 161,439 10,781 940% $ 216,062 $ 3,804 $ 161,439 $ 54,623 750N $ 50,000 $ $ - $ 50,000 00/( - 13,813 (13,813) 00/( $ 50,000 $ $ 13,813 $ 36,188 280/( $ 1,500 $ $ 315 $ 1,185 210% 4,500 2,323 2,177 520/( 5,900 70 5,412 488 920% $ 11,900 $ 70 $ 8,049 $ 3,851 680/( $ 4,091 $ 13,950 $ 14,150 $ (10,059) 3460% 78,327 64,701 61,767 16,560 790/( 6,157 2,615 2,893 3,264 470/( 88,575 81,266 78,809 9,766 890/( $ 1,879,000 $ 1,027,076 $ 1,334,810 $ 544,190 710% 1,879,000 $ 1,027,076 1,334,810 544,190 71% 1,000 $ $ - $ 1,000 00/( 39,800 25,000 14,800 63% 1 Oa� 00 - 199,000 0% 2 800 s 25,000 214 Packet Pg. 70 I 2.4.a I Page 4 of 6 C TIY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent 2012 LTGO DEBT SERVIC FUND (231) 1 GENERAL OBLIGATION BOND $ 235,000 $ 230,000 $ 235,000 $ - 1000% 2 INTEREST 74,800 80,704 74,790 10 1000/( 3 OTHER INTEREST & DEBT SERVICE COSTS - 481 350 (350) 00/( $ 309,800 $ 311,184 $ 310,140 $ (340) 1000% PARKS CONSTRUCTION FUND (332) 4 INTERFUND SUBSIDIES 5 PROFESSIONAL SERVICES 6 CONSTRUCTION PROJECTS 7 GENERAL OBLIGATION BONDS 8 INTEREST WATER FUND (421) 9 SALARIES AND WAGES 10 OVERTIME 11 BENEFIT S 12 UNIFORMS 13 SUPPLIES 14 WATER PURCHASED FOR RESALE 15 SUPPLIES PURCHASED FOR INVENTORY/RESALE 16 SMALL EQUIPMENT 17 PROFESSIONAL SERVICES 18 COMMUNICATIONS 19 TRAVEL 20 EXCISE TAXES 21 RENTAL/LEASE 22INSURANCE 23 UTILITIES 24 REPAIRS & MAINTENANCE 25 MISCELLANEOUS 26 INTERFUND SUBSIDIES 27 BUILDINGS 28 MACHINERY/EQUIPMENT 29 CONSTRUCTION PROJECTS 30 GENERAL OBLIGATION BONDS 31 REVENUE BONDS 32 INTERGOVERNMENTAL LOANS 33 INTEREST 34 OTHER INTEREST & DEBT SERVICE COSTS STORM FUND (422) 35 SALARIES AND WAGES 36 OVERTIME 37 BENEFITS 38 UNIFORMS 39 SUPPLIES 40 SMALL EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATIONS 43 TRAVEL 44 EXCISE TAXES 45 RENTAL/LEASE 46 INSURANCE 47 UTILITES 48 REPAIR & MAINTENANCE 49 MISCELLANEOUS 50 INTERFUND SUBSIDIES 51 LAND 52 BUILDINGS 53 MACHINERY/EQUIPMENT 54 CONSTRUCTION PROJECTS 55 GENERAL OBLIGATION BONDS 56 REVENUE BONDS 57 INTERGOVERNMENTAL LOANS 58 INTEREST 59 OTHER INTEREST & DEBT SERVICE COSTS $ - $ 62,656 $ 675,000 $ (675,000) 00% 1,352,620 916,696 141,867 1,210,753 100/( 805,377 5,296,522 1,158,855 (353,478) 1440/( 50,000 45,000 50,000 1000/( 47,650 51,009 47,650 - 1000/( $ 2,255,647 $ 6,371,883 $ 2,073,371 $ 182,276 920/( $ 1,205,783 $ 731,112 $ 961,475 $ 244,308 800/( 24,000 17,170 19,585 4,415 820/( 440,577 318,229 394,400 46,177 900/( 4,000 3,560 4,491 (491) 1120/( 150,000 124,598 125,731 24,269 840/( 2,398,000 2,137,891 2,199,854 198,146 920% 180,000 151,916 135,844 44,156 750/( 13,500 3,796 7,363 6,137 550% 2,256,928 1,549,620 1,420,517 836,411 630/( 35,000 33,979 37,058 (2,058) 1060/( 200 - 462 (262) 2310% 1,696,934 1,437,913 1,525,083 171,851 900/( 202,496 149,838 199,156 3,340 980/( 225,380 122,359 225,379 1 1000/( 35,000 37,023 37,119 (2,119) 1060/( 71,130 27,602 62,074 9,056 870/( 123,600 194,131 257,334 (133,734) 2080% 646,370 645,366 646,366 4 1000/( 12,500 - - 12,500 00% 10,000 10,044 5,943 4,057 590/( 1,670,000 87,212 1,507,792 162,208 900/( 2,940 2,863 2,938 2 1000/( 333,830 297,779 333,830 - 1000/( 25,840 25,839 25,839 1 1000/( 185,300 204,784 185,280 20 1000/( - 868 444 (444) 00/( $ 11,949,308 $ 8,315,491 $ 10,321,356 $ 1,627,952 860/( $ 1,113,757 $ 750,851 $ 1,013,545 $ 100,212 910/( 26,000 15,688 13,889 12,111 53 % 398,973 313,713 370,733 28,240 930/( 6,500 7,388 5,716 784 880/( 46,000 57,152 27,224 18,776 590% 4,000 2,090 1,713 2,287 430/( 3,143,445 3,428,392 1,645,327 1,498,118 520/( 3,200 6,547 6,976 (3,776) 2180/( 4,300 1,982 699 3,601 160/( 499,658 676,148 702,950 (203,292) 1410/( 307,168 262,799 302,920 4,248 990/( 31,679 82,335 31,680 (1) 1000/( 10,500 14,622 15,456 (4,956) 1470/( 189,130 14,528 133,542 55,588 710/( 232,300 239,323 269,587 (37,287) 1160/( 283,341 281,980 283,326 15 1000/( 680,000 - - 680,000 00/( 25,000 - 25,000 00/( 56,474 - 12,536 43,938 220/( 1,031,645 471,509 569,322 462,323 5501( 107,290 104,539 107,280 10 1000/( 160,870 145,430 160,869 1 1000/( 61,600 61,590 61,590 10 1000/( 103,070 114,191 103,054 16 1000/( - 383 193 (193) 00/( $ 8,525,900 $ 7,053,182 $ 5,840,127 $ 2,685,773 680/( 27 Packet Pg. 71 I 2.4.a I Page 5 of 6 C TTY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 3,159,792 $ 1,838,475 $ 2,893,482 $ 266,310 920/( 2 OVERTIME 130,000 131,671 178,311 (48,311) 1370/( 3 BENEFITS 1,043,665 738,594 1,056,596 (12,931) 1010% 4 UNIFORMS 11,500 10,450 11,038 462 960% 5 SUPPLIES 453,000 282,817 432,269 20,731 950/( 6 FUEL CONSUMED 20,000 - - 20,000 00% 7 SUPPLIES PURCHASED FOR INV OR RESALE 5,000 - - 5,000 00% 8 SMALL EQUIPMENT 83,900 121,415 9,326 74,574 110% 9 PROFESSIONAL SERVICES 2,587,949 3,617,962 2,513,546 74,403 970/( 10 COMMUNICATIONS 48,000 47,615 51,923 (3,923) 1080/( 11 TRAVEL 5,000 510 (39) 5,039 -10/( 12 EXCISE TAXES 1,026,360 1,107,964 1,247,392 (221,032) 1220% 13 RENTAL/LEASE 344,978 316,133 344,001 977 1000/( 14 INSURANCE 360,663 203,936 364,070 (3,407) 1010/( 15 UTILITIES 3,607,060 2,676,252 3,369,453 237,607 930/( 16 REPAIR & MAINTENANCE 728,630 838,632 797,454 (68,824) 1090% 17 MISCELLANEOUS 138,350 261,699 385,467 (247,117) 2790/( 18 INTERFUND SUBSIDIES 1,588,089 3,396,211 1,183,544 404,545 750% 19 BUILDINGS 12,500 - - 12,500 00% 20 MACHINERY/EQUIPMENT - 68,126 - - 00% 21 CONSTRUCTION PROJECTS 2,976,163 3,601,106 1,287,910 1,688,253 430% 22 GENERAL OBLIGATION BONDS 129,820 126,490 129,807 13 1000/( 23 REVENUE BONDS 55,310 71,791 55,301 9 1000/( 24 INTERGOVERNMENTAL LOANS 104,000 174,591 103,986 14 1000/( 25 INTEREST 353,270 357,001 349,417 3,853 990/( 26 OTHER INT EREST & DEBT SERVICE COSTS - 5,657 4,582 (4,582) 00/( $ 18,972,999 $ 19,995,099 $ 16,768,834 $ 2,204,165 880% BOND RESERVE FUND (424) 27 REVENUE BONDS $ 840,010 $ 810,000 $ 840,000 $ 10 1000/( 28 INTEREST 1,149,810 1,178,684 1,149,784 26 1000/( $ 1,989,820 $ 1,988,684 $ 1,989,784 $ 36 1000% 28 Packet Pg. 72 I 2.4.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent EQUIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 395,171 $ 266,855 $ 387,350 $ 7,821 980/( 2 OVERTIME 2,000 5,666 4,236 (2,236) 2120% 3 BENEFITS 132,345 96,452 129,214 3,131 980/( 4 UNIFORMS 1,500 1,571 1,991 (491) 1330% 5 SUPPLIES 141,280 91,607 149,094 (7,814) 1060/( 6 FUEL CONSUMED 1,000 - - 1,000 00/( 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 466,720 372,851 307,005 159,715 660/( 8 SMALL EQUIPMENT 58,000 5,651 8,154 49,846 140/( 9 PROFESSIONAL SERVICES 46,750 14,999 1,638 45,112 40/( 10 COMMUNICATIONS 3,000 2,480 3,485 (485) 1160% 11 TRAVEL 1,000 - 1,870 (870) 1870% 12 RENTAL/LEASE 17,470 10,422 16,728 742 960% 13 INSURANCE 50,178 51,903 52,373 (2,195) 1040% 14 UTILITIES 14,000 20,064 20,600 (6,600) 1470% 15 REPAIRS & MAINTENANCE 60,000 75,668 58,712 1,288 980% 16 MISCELLANEOUS 12,000 7,870 11,524 476 960/( 17 MACHINERY/EQUIPMENT 3,655,169 473,127 1,812,039 1,843,130 500/( $ 5,057,583 $ 1,497,185 $ 2,966,013 $ 2,091,570 590N TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 657,771 $ 388,239 $ 574,527 $ 83,244 870% 19 OVERTIME 2,000 1,286 270 1,730 130% 20 BENEFITS 191,954 137,337 206,546 (14,592) 1080% 21 SUPPLIES 5,000 8,996 7,530 (2,530) 1510% 22 SMALL EQUIPMENT 181,800 148,972 139,731 42,069 770% 23 PROFESSIONAL SERVICES 61,860 45,506 43,018 18,842 700% 24 COMMUNICATIONS 58,770 67,134 75,375 (16,605) 1280% 25 TRAVEL 1,500 296 - 1,500 00/( 26 RENTAL/LEASE 4,640 4,460 1,640 3,000 350/( 27 REPAIRS& MAINTENANCE 666,729 546,651 694,711 (27,982) 1040/( 28 MISCELLANEOUS 55,600 3,929 11,120 44,480 200% 29 MACHINERY/EQUIPMENT 134,836 194,471 85,674 49,162 640/( $ 2,022,460 $ 1,547,277 $ 1,840,142 $ 182,318 910/( TOTAL EXPENDITURE ALL FUNDS $ 141,438,551 $ 109,487,590 $ 120,693,575 $ 20,744,976 850% 29 Packet Pg. 73 2.4.a Page 1 of 1 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT ]IN SUMMARY 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPART MENTAL POLICE SERVICES SATELLITE OFFICE COMMUNITY SERVICES/ECONOMIC DEV PLANNING& DEVELOPMENT HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE $ 486,719 $ 349,507 $ 423,907 $ 62,812 87% 505,239 359,056 383,612 121,627 76% 1,297,746 913,570 1,003,524 294,222 77% 1,827,709 1,353,088 1,499,361 328,348 82% 2,502,670 2,285,373 2,563,246 (60,576) 102% 1,161,780 947,473 1,054,359 107,421 91% 18,579,347 13,752,781 17,981,733 597,614 97% 14,839,513 13,528,817 15,040,900 (201,387) 101% 230,681 94,770 128,220 102,461 56% 1,312,555 751,724 1,310,217 2,338 100% 5,246,507 3,760,467 4,047,163 1,199,344 77% 347,982 189,038 267,635 80,347 77% 6,484,904 4,845,096 5,964,309 520,595 92% 4,283,090 3,401,408 4,004,938 278,152 94% 4,877,452 2,497,144 4,003,536 873,916 82% $ 63,983,894 $ 49,029,312 $ 59,676,660 $ 4,307,234 93% C ITY O F EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2023 Amended Budget 12/31/2022 Expenditures 12/31/2023 Expenditures Amount Remaining %Spent WATER UTILITYFUND $ 11,949,308 $ 8,315,491 $ 10,321,356 $ 1,627,952 86% STORM UTILITY FUND 8,525,900 7,053,182 5,840,127 2,685,773 68% SEWER/WWTP UTILITY FUND 18,972,999 19,995,099 16,768,834 2,204,165 88% BOND RESERVE FUND 1,989,820 1,988,684 1,989,784 36 100% $ 41,438,027 $ 37,352,456 $ 34,920,101 $ 6,517,926 84% 30 Packet Pg. 74 I 2.4.a I Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2023 Amended Budget 12/31/2022 Expenditures 12/31/2023 Expenditures Amount Remaining %Spent C TIY C O UNC IL SALARIES AND WAGES $ 219,276 $ 193,171 $ 221,618 $ (2,342) 101% BENEFITS 103,845 94,835 103,497 348 100% SUPPLIES 11,000 3,228 2,180 8,820 20% SERVICES 152,598 58,273 96,612 55,986 63% $ 486,719 $ 349,507 $ 423,907 $ 62,812 87% OFFICEOFMAYOR SALARIES AND WAGES $ 282,988 $ 248,540 $ 259,072 $ 23,916 92% BENEFITS 90,087 85,526 86,558 3,529 96% SUPPLIES 1,500 3,674 2,017 (517) 134% SERVICES 130,664 21,317 35,965 94,699 28% $ 505,239 $ 359,056 $ 383,612 $ 121,627 76% HUMAN RESOURCES SALARIES AND WAGES $ 782,258 $ 478,497 $ 567,630 $ 214,628 73% BENEFITS 243,609 158,618 207,667 35,942 85% SUPPLIES 13,600 1,998 13,609 (9) 100% SERVICES 258,279 274,458 214,619 43,660 83% $ 1,297,746 $ 913,570 $ 1,003,524 $ 294,222 77% MUNIC IPAL C O URT SALARIES AND WAGES $ 1,234,740 $ 890,924 $ 973,325 $ 261,415 79% BENEFITS 345,764 265,724 296,157 49,607 86% SUPPLIES 23,048 11,211 21,701 1,347 94% SERVICES 224,157 185,229 208,177 15,980 93% $ 1,827,709 $ 1,353,088 $ 1,499,361 $ 328,348 82% ADMINISTRATIVE SERVICES SALARIES AND WAGES $ 1,601,894 $ 1,459,628 $ 1,656,973 $ (55,079) 103% BENEFITS 465,703 432,872 489,346 (23,643) 105% SUPPLIES 13,000 13,156 9,536 3,465 73% SERVICES 422,073 379,717 407,392 14,681 97% $ 2,502,670 $ 2,285,373 $ 2,563,246 $ (60,576) 102% CITY ATTORNEY SERVICES $ 1,161,780 $ 947,473 $ 1,054,359 $ 107,421 91% $ 1,161,780 $ 947,473 $ 1,054,359 $ 107,421 91% NON -DEPARTMENTAL SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% BENEFITS 239,583 128,335 101,301 138,282 42% SUPPLIES 5,000 - - 5,000 0% SERVICES 16,426,684 11,937,396 16,405,833 20,851 100% INTERFUND SUBSIDIES 1,482,740 1,365,062 1,151,522 331,218 78% DEBT SERVICE - PRINCIPAL 191,620 180,164 191,611 9 100% DEBT SERVICE -INTEREST 131,970 141,824 131,467 503 100% $ 18,579,347 $ 13,752,781 $ 17,981,733 $ 597,614 97% PO LIC E S ERVIC ES SALARIES AND WAGES $ 9,366,760 $ 8,294,956 $ 9,226,883 $ 139,877 99% BENEFITS 3,280,628 2,842,733 3,196,856 83,772 97% SUPPLIES 342,941 472,297 271,146 71,795 79% SERVICES 1,799,184 1,310,985 2,086,753 (287,569) 116% DEBT SERVICE - PRINCIPAL 50,000 - - 50,000 0% MACHINERY/EQUIPMENT - 607,846 259,262 (259,262) 0% $ 14,839,513 $ 13,528,817 $ 15,040,900 $ (201,387) 101% SATELLITE O FFIC E SALARIES AND WAGES $ 38,537 $ 18,798 $ 43,680 $ (5,143) 113% BENEFITS 7,298 3,541 25,719 (18,421) 352% SUPPLIES 17,000 11,057 226 16,774 1% SERVICES 167,846 61,374 58,594 109,252 35% $ 230,681 $ 94,770 $ 128,220 $ 102,461 56% 31 Packet Pg. 75 1 I 2.4.a I Page 2 of 2 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2023 Amended 12/31/2022 12/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY S ERVIC ES/EC 0 N DEV. SALARIES AND WAGES $ 613,413 $ 359,665 $ 649,613 $ (36,200) 106% BENEFITS 165,783 99,042 167,071 (1,288) 101% SUPPLIES 4,075 661 1,870 2,205 46% SERVICES 529,284 292,355 491,664 37,620 93% $ 1,312,555 $ 751,724 $ 1,310,217 $ 2,338 100% PLANNING & DEVELOPMENT SALARIES AND WAGES $ 2,392,581 $ 2,141,549 $ 2,307,415 $ 85,166 96% BENEFITS 779,673 718,552 822,793 (43,120) 106% SUPPLIES 23,400 9,526 19,307 4,093 83% SERVICES 2,050,853 890,841 897,648 1,153,205 44% $ 5,246,507 $ 3,760,467 $ 4,047,163 $ 1,199,344 77% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 121,292 $ 85,126 $ 112,178 $ 9,115 92% BENEFITS 33,190 23,528 33,911 (721) 102% SUPPLIES 15,000 6,159 3,638 11,362 24% SERVICES 178,500 68,617 117,908 60,592 66% MACHINERY/EQUIPMENT - 5,608 - - 0% 347,982 189,038 267,635 80,347 77% PARKS & REC REATIO N SALARIES AND WAGES $ 3,269,091 $ 2,556,516 $ 2,992,185 $ 276,906 92% BENEFITS 1,074,929 854,511 1,063,880 11,049 99% SUPPLIES 468,900 239,386 385,959 82,941 82% SERVICES 1,672,742 1,194,683 1,368,399 304,343 82% MACHINERY/EQUIPMENT (758) - 153,886 (154,644) 0% $ 6,484,904 $ 4,845,096 $ 5,964,309 $ 520,595 92% PUBLIC WORKS ADMINIS TRATIO N SALARIES AND WAGES $ 409,900 $ 216,662 $ 447,144 $ (37,244) 109% BENEFITS 150,075 85,283 134,135 15,940 89% SUPPLIES 9,600 6,455 12,587 (2,987) 131% SERVICES 98,006 83,236 93,078 4,928 95% $ 667,581 $ 391,636 $ 686,944 $ (19,363) 103% FACILITIES MAINTENANCE SALARIES AND WAGES 1,287,006 885,086 1,237,143 49,863 96% BENEFITS 462,021 358,436 471,497 (9,476) 102% SUPPLIES 128,000 93,965 111,254.41 16,746 87% SERVICES 1,359,860 1,021,020 1,533,598 (173,738) 113% MACHINERY/EQUIPMENT 1,640,565 138,637 650,043 990,522 40% $ 4,877,452 $ 2,497,144 $ 4,003,536 $ 873,916 82% ENGINEERING SALARIES AND WAGES $ 2,395,963 $ 1,980,420 $ 2,195,849 $ 200,114 92% BENEFITS 812,924 703,594 768,958 43,966 95% SUPPLIES 2,200 3,529 3,375 (1,175) 153% SERVICES 404,422 322,230 349,814 54,608 86% $ 3,615,509 $ 3,009,772 $ 3,317,994 $ 297,515 92% TOTAL GENERAL FUND EXPENDITURES $ 63,983,894 $ 49,029,312 $ 59,676,660 $ 493079234 93% 32 Packet Pg. 76 2.4.a GENERAL FUND OVERVIEW 0 CL BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 12/31 /2023 12/31 /2023 Q4 YTD Fund Balance Cash Balance = U. 001-General Fund $ 2,231,830 $ (390,350) $ 336,771 $ (9,671,125; 009-Leoff-Medical Ins. Reserve 132,801 148,753 74,867 (84,063 3 011-Risk Management Reserve Fund - - - (25,000 CJ 012-Contingency Reserve Fund 2,228,672 2,228,672 - 446,522 M N 0 014-Historic Preservation Gift Fund 8,944 8,944 (2,757) (2,757 L 016-Building Maintenance 3,666,767 3,874,264 (475,359) (629,836 m E 017 - Marsh Restoration & Preservation 853,595 853,595 - 3,829 4) 018 - Edmonds Homelessness Response Fd 200,000 200,000 - - p 019 - Opioid Response Fund 123,126 74,119 123,126 74,119 Total General Fund & Subfunds $ 9,445,734 $ 6,997,996 $ 56,649 $ (9,888,312 E L a *$8,914,686 of the fund balance in Fund 001 added to the $2,228,672 balance in Fund 012, represent the required 20% operating reserve. 00 d There are no interfund loans outstanding at this time. �a ca GOVERNMENTAL FUNDS OVERVIEW 3 a M N BALANCES CHANGE IN FUND BALANCES N L GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- E FUNDS 12/31 /2023 12/31 /2023 Q4 YTD Fund Balance Cash Balance General Fund & Subfunds $ 9,445,734 $ 6,997,996 $ 56,649 $ (9,888,312 = Special Revenue 14,770,482 20,382,927 (806,357) (1,429,268 . Capital Projects - Fund 332 244,149 129,170 (3,173) 36,466 d a Total Governmental Funds $ 24,460,365 $ 27,510,093 $ (752,881) $ (11,281,113 Q E 0 U _ m E t *Please note that these revenues and expenses occur within annual cycles. w a This Interim Report is not adjusted for accruals or those annual cycles. 33 Packet Pg. 77 2.4.a SPECIAL REVENUE FUNDS OVERVIEW 0 CL BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 12/31/2023 12/31/2023 Q4 YTD = ca Fund Balance Cash Balance c U. 104 - Drug Enforcement Fund $ 37,178 $ 40,318 409 $ (30,392 L 111 - Street Fund (176,485) (90,612) (245,911) (585,169; d 112 - Combined Street Const/Im prove 3,508,700 1,061,378 1,103,950 1,069,195 n 117 - Municipal Arts Acquis. Fund 606,440 639,747 (27,841) (28,448 d 120 - Hotel/Motel Tax Revenue Fund 144,510 161,077 (20,866) 49,645 c 121 - Employee Parking Permit Fund 79,257 82,737 (9,743) 4,225 L 122 -Youth Scholarship Fund 16,933 17,639 238 1,725 123-Tourism Promotional Fund/Arts 131,494 131,468 (2,154) 16,324 y 125 - Real Estate Tax 1,813,370 2,262,136 (981,383) (1,403,645, 126 - Real Estate Excise Tax 1 * 3,722,884 4,074,928 (844,386) (227,096; 127 - Gifts Catalog Fund 2,957,769 3,099,872 (61,388) (106,024 130- Cemetery Mai ntenance/Improvement 180,719 195,471 (41,500) (87,450 136 - Parks Trust Fund (7,497) - - (168,935; 137 - Cemetery Maintenance Trust Fund 1,145,368 1,196,540 2,349 42,068 a 138- Sister CityCommission 17,515 18,563 (4,756) (2,380 140 -Business Improvement Disrict 38,347 44,414 (14,050) (1,437, oo 141 -Affordable and Supportive Housing Fd 308,369 300,730 26,195 73,802 d 142 - Edmonds Rescue Plan Fund 36,932 6,902,348 337,006 (27,656 143 -Tree Fund 208,678 244,175 (22,526) (17,621 Total Special Revenue $ 14,770,482 $ 20,382,927 $ (806,357) $ (1,429,268; *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $1,000,000 LL for the purchase of Open Space. >+ m ENTERPRISE FUNDS OVERVIEW 3 a M N O N L BALANCES CHANGE IN FUND BALANCES E ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- FUNDS 12/31/2023 12/31/2023 Q4 YTD �+ Fund Balance Cash Balance c .E 421 -Water Utility Fund $ 33,124,030 $ 10,222,073 $ (141,459) $ 1,235,406 422 -Storm Utility Fund * 19,718,281 6,879,500 (580,669) 1,646,548 a Q 423-Sewer/WWTPUtility Fund 63,566,042 15,789,074 (1,874,146) 566,707 2 0- 424 - Bond Reserve Fund 862,194 862,194 5,105 18,234 E 0 411 -Combined Utility Operation - - 22,600 - U Total Enterprise Funds $ 117,270,546 $ 33,752,842 $ (2,568,570) $ 3,466,895 *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding. E *Please note that these revenues and expenses occur within annual cycles. a This Interim Report is not adjusted for accruals or those annual cycles. 34 Packet Pg. 78 2.4.a SUMMARY OVERVIEW 0 CL BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 12/31/2023 12/31/2023 Q4 YTD = Fund Balance Cash Balance — ca c ii Governmental Funds $ 24,460,365 $ 27,510,093 $ (752,881) $ (11,281,113; 2. Enterprise Funds 117,270,546 33,752,842 (2,568,570) 3,466,895 M Internal Services Fund 10,002,195 5,769,121 288,116 (356,109 3 CJ M Total City-wide Total $ 151,733,106 $ 67,032,055 $ (3,033,335) $ (8,170,326 N N L d E INTERNAL SERVICE FUNDS OVERVIEW, d E Q L a BALANCES CHANGE IN FUND BALANCES 0a d ---- ACTUAL ---- ---- ACTUAL ---- INTERNAL SERVICE FUNDS 12/31/2023 12/31/2023 Q4 YTD c Fund Balance Cash Balance c ii 511 -Equipment Rental Fund $ 9,270,285 $ 5,273,281 $ 280,221 $ (125,517 L m 512-Technology Rental Fund 731,911 495,839 7,894.60 (230,592 ca 3 Total Internal Service Funds $ 10,002,195 $ 5,769,121 $ 288,116 $ (356,109 d N O N L E d E L a a� a� a E 0 U c m *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. r a 35 Packet Pg. 79 2.4.b GENERAL FUND CHANGES IN FUND BALANCE 2023 2018 2019 2020 2021 2022 Preliminary Beginning Fund Balance 10,273,342 11,233,279 15,552,188 13,868,744 15,915,322 11,902,952 Revenue Taxes 30,755,578 30,846,665 30,738,452 32,979,704 34,209,103 34,858,487 Licenses and permits 2,401,855 2,299,972 2,276,861 2,453,186 2,560,170 2,579,189 Intergovernmental 1,014,434 1,008,432 1,633,633 1,608,646 1,367,288 2,741,928 Charges for services 5,810,961 6,419,836 5,412,044 5,913,557 3,020,623 7,675,709 Fines and forfeitures 616,783 496,093 287,693 272,302 182,881 194,369 Interest earnings 273,228 573,806 265,627 122,257 (34,099) 247,415 Miscellaneous 931,495 587,882 322,816 347,519 368,221 796,372 Operating Revenues Nononeratine Revenues Transfers in Debt proceeds Sale of capital assets Contracts Insurance recoveries Total Revenue Expenditures General government Public safety Transportation Economic environment Mental and physical health Culture and recreation Debt service Capital outlay Operating Expenditures Nononeratine Expenditures Leases Transfers out Debt refunding Total Expenditures Prior Period Adjustments Change in position Ending Fund Balance 41,804,334 42,232,686 40,937,126 43,697,171 41,674,187 49,093,469 75,884 4,793,650 1,535,800 388,547 26,300 97,066 5,273 - - - - - - - - - 482,709 15,570 - 16,977 - 257,520 815,000 41,901,061 47,026,336 42,489,903 44,085,718 42,440,716 50,005,535 10,288,694 11,565,563 12,514,526 11,866,885 9,821,698 16,534,287 22,585,212 23,036,185 23,759,212 22,765,260 26,107,688 31,091,606 4,779 5,012 5,012 2,088 - - 1,460,763 1,562,702 1,675,334 1,991,624 2,245,945 2,927,005 178,859 164,888 147,957 84,642 38,676 86,611 4,331,806 4,158,397 3,732,644 4,341,658 4,926,663 6,139,028 197,694 197,967 296,624 60,228 321,989 323,078 93,105 110,935 835,048 268,885 1,605,828 1,473,524 39,140,912 40,801,649 42,966,358 41,381,270 1,800,212 1,905,778 1,206,990 657,870 40,941,124 42,707,427 44,173,348 42,039,140 45,068,487 58,575,138 69,534 1,315,062 46,453,083 1,101,522 59,676,660 959,937 4,318,909 (1,683,445) 2,046,578 (4,012,367) (9,671,125)06 a 11,233,279 15,552,188 13,868,744 15,915,322 11,902,952 2,231,827 N 0 N V N G R:\Finance Committee\2023\Jan-Dec 2023 P&L 2/1/2024 Packet Pg. 80 2.5 City Council Agenda Item Meeting Date: 02/13/2024 Ordinance Establishing Authorized Employee Positions and Pay Ranges Staff Lead: City Attorney's Office Department: City Attorney's Office Preparer: Scott Passey Background/History On January 2, 2024, the city council adopted Ordinance 4336 establishing authorized employee positions and pay ranges. The ordinance compiled all of the authorized employee positions in one place for ease of use by both the council and the administration. Ordinance 4336 expressly stated: "The authority to hire seasonal employees shall be provided by separate council action." Staff Recommendation Forward the attached ordinance to the city council for adoption on the consent agenda. Narrative The attached ordinance repeats what Ordinance 4336 did, while making additional provisions for irregular (seasonal and hourly) employees. Attachment A to the ordinance reflects the city's regular (benefit -eligible) employees. Two rows were added to Attachment A to address positions that were initially thought to be irregular. Closer analysis revealed that the positions of Parks Maintenance Worker (Seasonal) and Preschool Assistant have the potential to be benefit eligible and therefore should be included in Attachment A. Attachment B to the ordinance is a new attachment that authorizes the hiring of certain irregular (seasonal and hourly) employees. As with Ordinance 4336, this proposed ordinance: Documents all positions approved by council; Sets maximum hiring levels; References the approved salary / pay range that corresponds with each position; For regular employees, is organized to show the prominent funding source for the positions, by grouping the regular employee positions into three groups: 1. those that are funded 66.6%-100% from the General Fund; 2. those that are funded 33.3%-66.6 from the General Fund; and 3. those that are funded 0%-33.3% from the General Fund. As before, any additions or reductions of FTE positions would be authorized through amendments to this ordinance. Attachments: Ordinance establishing authorized positions 2024-02-06 Exhibit A 2024-02-02 Seasonal -Hourly Employees FTE list - Exhibit B Packet Pg. 81 2.5.a ORDINANCE NO. AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING THE CITY' S AUTHORIZED EMPLOYEE POSITIONS AND PAY RANGES AND REPEALING ORDINANCE 4336 WHEREAS, pursuant to RCW 35A.11.020, "[t]he legislative body of each code city shall have power ... to define the functions, powers, and duties of its officers and employees; ..., to fix the compensation and working conditions of such officers and employees..."; and WHEREAS, pursuant to RCW 35A.12.090, "[t]he mayor shall have the power of appointment and removal of all appointive officers and employees;" and WHEREAS, pursuant to RCW 35A.33.050, "[t]he salary or salary range for each office, position or job classification shall be set forth separately together with the title or position designation thereof. PROVIDED, That salaries may be set out in total amounts under each department if a detailed schedule of such salaries and positions be attached to and made a part of the budget document;" and WHEREAS, pursuant to RCW 35A.33.105, "[n]otwithstanding the appropriations for any salary, or salary range of any employee or employees adopted in a final budget, the legislative body of any code city may, by ordinance, change the wages, hours, and conditions of employment of any or all of its appointive employees if sufficient funds are available for appropriation to such purposes;" and WHEREAS, the City of Edmonds has historically adopted its budget at the fund level; and WHEREAS, the City of Edmonds budget book is typically finalized administratively after adoption of the budget ordinance; and WHEREAS, city council intends that the City of Edmonds budget book be conformed to this ordinance, as it may be amended from time -to -time; and WHEREAS, with respect to the employee positions that the mayor is authorized to hire, this ordinance, as it may be amended from time -to -time, is intended to be the controlling document; and Packet Pg. 82 2.5.a WHEREAS, a previous version of this ordinance was adopted with Ordinance 4336; and WHEREAS, should it become necessary to defund or deauthorize the filling of a particular position, it is intended that the FTE levels in this ordinance be adjusted in concert with an associated budget amendment; and WHEREAS, the city council intends to use this ordinance to establish the number and types of employee positions, wage and salary rates and ranges for all the city's employees; NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. The number and titles of authorized Full -Time Equivalent employees (FTEs), including full-time and part-time regular employees, shall be established at 284.9 FTEs, as detailed in Attachment A, which is attached hereto and incorporated herein by this reference as if set forth in full. The mayor is authorized to hire only those authorized positions shown on Attachment A and only pursuant to the salary ranges shown therein. Section 2. The number and titles of authorized Full -Time Equivalent employees (FTEs), including full-time and part-time irregular employees, shall be established at 10.67 FTEs, as detailed in Attachment B, which is attached hereto and incorporated herein by this reference as if set forth in full. It is the intention that irregular positions are not benefit eligible and/or union positions. At no time should the schedule of irregular positions in to which employees are hired be such that it would cause the position to become benefit eligible or covered by a union, unless otherwise called out in a collective bargaining agreement. The mayor is authorized to hire only those authorized positions shown on Attachment B and only pursuant to the salary ranges shown therein. Section 3. This ordinance shall apply and continue in effect until amended by subsequent ordinance of the city council. Ordinance 4336 is hereby repealed. Section 4. This ordinance, as it may be amended from time -to -time, shall be included as an exhibit to every proposed and final budget book, PROVIDED THAT the city council need not Packet Pg. 83 2.5.a take annual action to re -adopt this ordinance unless it deems it necessary to change the number and/or titles of authorized FTEs. Section 5. This ordinance shall control in the event of any conflict between this ordinance and the final budget book or any other action of the city council purporting to authorize the hiring of employees. Nothing in this ordinance shall be construed to abrogate an existing obligation of the City of Edmonds with regard to its various collective bargaining agreements. Section 6. Severability. If any section, subsection, clause, sentence, or phrase of this ordinance should be held invalid or unconstitutional, such decision shall not affect the validity of the remaining portions of this ordinance. Section 7. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. APPROVED: MAYOR MIKE ROSEN ATTEST/AUTHENTICATED: CITY CLERK, SCOTT PASSEY APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: IM JEFF TARADAY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. Packet Pg. 84 2.5.a SUMMARY OF ORDINANCE NO. of the City of Edmonds, Washington On the day of , 2024, the City Council of the City of Edmonds, passed Ordinance No. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING THE CITY' S AUTHORIZED EMPLOYEE POSITIONS AND PAY RANGES AND REPEALING ORDINANCE 4336 The full text of this Ordinance will be mailed upon request. DATED this day of , 2024. 4840-7251-8158,v. 1 M CITY CLERK, SCOTT PASSEY Packet Pg. 85 2.5.b Funded Position FTE Grade Department 66.6%-500% General Fund(001) funded Legislative/Executive Assistant 1.0 NR-33 Council Mayor 1.0 156,123 Mayor Executive Assistant to the Mayor 1.0 NR-34 Mayor Human Resources Director 1.0 NR-44 Human Resources Senior Human Resources Analyst 1.0 NR-34 Human Resources Human Resources Analyst 0.6 NR-32 Human Resources Safety& Disaster Coordinator 1.0 NR-34 Human Resources Human Resources Assistant 1.0 NR-29 Human Resources Human Resources Manager 1.0 NR-40 Human Resources Court Administrator 1.0 NR-43 Court Assistant Court Administrator 1.0 NR-37 Court Lead Court Clerk 1.0 NE-29 Court Court Clerk 4.0 NE-28 Court Probation Officer 2.0 NE-33-NE-34 Court City Clerk 1.0 NR-37 Administrative Services Deputy City Clerk 1.0 NE-31 Administrative Services Accounting Specialist 2.0 NE-30-NE-31 Administrative Services Administrative Assistant 1.0 NE-29-NE-30 Administrative Services Senior Office Specialist 1.0 NE-25 Administrative Services Public Records Officer 1.0 NE-32 Administrative Services Public Records Assistant 1.0 NE-30 Administrative Services Police Chief 1.0 PD-03 Police Police Assistant Chief 2.0 PD-02 Police Executive Assistant Confidential ll 1.0 NR-35 Police Executive Assistant Confidential 1 1.0 NR-33 Police Police Commanders 3.0 PD-01 Police Sergeant 7.0 NE-13 Police Corporal 6.0 NE-12 Police Police Officer 47.0 NE-9-NE-11 Police Police Crime Analyst 1.0 NE-11 Police Animal Control/Ordinance Enforcement Officer 2.0 NE-10-NE-11 Police Parking Enforcement Officer 1.0 NE-6 Police Police Services Assistant 6.0 NE-7-NE-8 Police Property Officer/Evidence Technician 1.0 NE-9 Police Domestic Violence Coordinator 1.0 NE-10 Police Administrative Assistant 0.8 NE-6 Police Police Public Disclosure Specialist 2.0 NE-10 Police Community Engagement/Crime Prevention Coordinator 1.0 NE-11 Police Community Services & Economic Development Director 1.0 NR-44 Community Services & Economic Development Administrative Assistant 0.5 NE-29-NE-30 Community Services& Economic Development Community Services Program Coordinator 1.0 NE-33 Community Services & Economic Development Arts & Cultural Services Program Manager 1.0 NR-35 Community Services & Economic Development Cultural Arts Program Specialist 1.0 NE-29 Community Services & Economic Development Communications Strategist/Public Information Officer 1.0 NE-35 Community Services & Economic Development Diversity Commission Coordinator 0.3 x02 Community Services & Economic Development Planning & Development Director 1.0 NR-44 Planning & Development Code Enforcement Officer 1.0 NE-34 Planning & Development Administrative Assistant 2.0 NE-29-NE-30 Planning & Development Building Official 1.0 NR-39 Planning&Development Plans Examiner 2.0 NE-34-NE-35 Planning & Development Permit Supervisor 1.0 NR-32 Planning & Development Combination Building Inspector 1.0 NE-33-NE-35 Planning & Development Permit Coordinator 2.0 NE-29-NE-31 Planning & Development Building Inspector 1.0 NE-33 Planning & Development Planning Manager 1.0 NR-40 Planning & Development Senior Planner 2.0 NR-35 Planning & Development Associate Planner 1.0 NR-33 Planning & Development Planner 2.0 NR-32 Planning & Development Urban Forest Planner 1.0 NR-35 Planning&Development Associate Transportation Planner 1.0 NR-33 Planning & Development Parks, Recreation, and Human Services Director 1.0 NR-44 Parks & Recreation Executive Assistant 1.0 NE-33 Parks & Recreation Parks Maintenace Manager 1.0 NR-35 Parks & Recreation Parks Maintenace Lead Worker 1.0 N Parks & Recreation Parks Maintenance Worker 13.0 1-1 Parks & Recreation Parks Maintence Worker (Seasonal) 5.0 �H-10/B Parks & Recreation Field Arborist 1.0 J Parks & Recreation Parks Maintenance Mechanic 1.0 K Parks & Recreation Deputy Parks & Recreation Services Director 1.0 NR-41 Parks & Recreation Recreation Supervisor 1.0 NR-35 Parks & Recreation Recreation Coordinator 2.6 NE-33 Parks & Recreation Environmental Education & Sustainability Coordinator 1.0 NE-34 Parks & Recreation Senior Office Specialist 1.0 NE-25 Parks & Recreation Program Assistant 1.0 NE-27 Parks & Recreation Recreation Leader 1.2 NE-23 Parks & Recreation Interpretive Specialist 0.5 NE-23 Parks & Recreation Preschool Assistant 0.5 NE-21 Parks & Recreation Youth Commission Coordinator 0.5 H13 Parks & Recreation Human Services Program Manager 1.0 NE-36 Parks & Recreation Park Planner and Capital Projects Manager 1.0 NR-36 Parks & Recreation Administrative Assistant 1.0 NE-29-NE-30 Public Works Facilities Manager 1.0 NR-38 Public Works Lead Custodian 1.0 H Public Works Custodian 5.0 D-E Public Works City Electrician 1.0 N Public Works Lead Building Maintenance Operator 1.0 M Public Works Building Maintenance Operator 3.0 J Public Works Total FFE count for positions that are 66.6%-100% General Fund(001) funded 184.4 33.3%-66.6%General Fund (001) funded Accountant 3.0 NE-36-NE-37 Administrative Services Administrative Services Director 1.0 NR-44 Administrative Services Deputy Administrative Services Director 1.0 NR-41 Administrative Services Packet Pg. 86 2.5.b Public Works Director 1.0 NR-45 Public Works Executive Assistant 1.0 NE-33 Public Works Total FTE count for positions that are 33.3%-66.6%General Fund (001) funded 7.0 0%-33.3%General Fund (001) funded Accountant 1.0 NE-36-NE-37 Administrative Services Accounting Specialist 2.0 NE-30-NE-31 Administrative Services Information Services Manager 1.0 NR-41 Administrative Services Information Systems Specialist 1.0 NE-35-NE-36 Administrative Services GIS Analyst 1.0 NE-35-NE-36 Administrative Services Systems Support Technician 2.0 NE-32 Administrative Services Web Systems Analyst 1.0 NE-33 Administrative Services Cemetery Sexton 1.0 L Parks & Recreation Parks Maintenance Worker 2.0 I-J Parks & Recreation City Engineer 1.0 NR-43 Public Works Administrative Assistant 1.0 NE-29-NE-30 Public Works Capital Projects Manager 5.0 NR-36 Public Works Transportation Engineer 1.0 NR-39 Public Works Senior Construction Inspector 1.0 NE-35 Public Works Senior Utilities Engineer 1.0 NR-41 Public Works Stormwater Engineer 1.0 NR-38 Public Works Stormwater Technician 1.0 NE-32-NE-33 Public Works Associate Engineer 1.0 NR-33 Public Works Engineering Program Manager II 1.0 NR-38 Public Works Engineering Technician 4.0 NE-30-NE-34 Public Works Permit Coordinator 0.5 NE-29-NE-31 Public Works Public Works Record Administrator 1.0 New, No Grade available Public Works Asset/Project Management Specialist 1.0 NR-36 Public Works Utility Locator 1.0 New, No Grade available Public Works Sewer Maintenance/GIS Worker 1.0 New, No Grade available Public Works Environmental Program Specialist 1.0 NR-33 Public Works Street/Storm Manager 1.0 NR-40 Public Works Stormwater Maintenance Lead Worker 1.0 N Public Works Senior Storm GIS Technician/Maintenance Worker 1.0 K Public Works Storm Maintenance Worker 6.0 I -J Public Works Street Maintenance Lead Worker 1.0 N Public Works Traffic Control Technician 1.0 L Public Works Senior Street Maintenance Worker -Cement Finisher 2.0 K Public Works Street/Storm Maintenance Worker 5.0 I -J Public Works Water/Sewer Manager 1.0 NR-40 Public Works Water Maintenance Lead Worker 1.0 N Public Works Water Maintenance Worker 5.0 1-1 Public Works Water Meter Reader 2.0 E-F Public Works Water Quality Control Technician 1.0 L Public Works Sewer Maintenance Lead Worker 1.0 N Public Works Sewer Maintenance Worker 6.0 I-K Public Works WWTP Manager 1.0 NR-41 Public Works Office Coordinator 1.0 NE-30 Public Works WWTP Pre -Treatment Technician 1.0 K Public Works WWTP Water Quality Analyst 1.0 N Public Works WWTP Instrument Technician/Plant Electrician 1.0 L-N Public Works WWTP Plant Supervisor 1.0 NR-37 Public Works WWTP Operator 11.0 J-N Public Works WWTP Maintenance Mechanic 2.0 J-N Public Works Fleet Manager 1.0 NR-37 Public Works Fleet Mechanic 3.0 K-M Public Works Total FTE count for positions that are 0%-33.3%General Fund (001) funded 93.5 Total All City FTE Count 284.9 Packet Pg. 87 2.5.c Position FTE Grade Department Temporary Executive Assistant to the Mayor 0.24 h15 Mayor Human Resources Intern 0.14 h09 Human Resources Pro-Tem Judge 0.10 h21 Court Audio/Visual Assistant 0.47 h13 Administrative Services Facility Attendant 0.04 h05 Community Services & Economic Development Front Desk Receptionist 1.77 h08 Parks & Recreation Ranger Naturalist 0.89 h09 Parks & Recreation Day Camp Assistant 0.89 h07 Parks & Recreation Gymnastics Assistant 0.53 h07 Parks & Recreation Gymnastics Instructor 0.30 h10 Parks & Recreation Facility Attendant 0.22 h08 Parks & Recreation Preschool Assistant 0.46 h05 - NE-21 Parks & Recreation Seasonal Parks Maintenance Laborer 3.66 h08 - pwb Parks & Recreation Engineering Intern 0.96 h09 Public Works 10.67 Packet Pg. 88