The URL can be used to link to this page

2023-04-11 City Council FIN Packet1. Op E D o Agenda Edmonds City Council tnl. }nyo FINANCE COMMITTEE CITY COUNCIL CONFERENCE ROOM 121 - 5TH AVENUE N, EDMONDS, WA 98020 APRIL 11, 2023, 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 430- 930 PM AT THE CITY COUNCIL CONFERENCE ROOM AT 121 5TH AVE N, EDMONDS WA. COMMITTEE MEMBERS: WILL CHEN (CHAIR), SUSAN PAINE, COUNCIL PRESIDENT (EX-OFFICIO MEMBER) CALL TO ORDER COMMITTEE BUSINESS 1. Delegation Bond Ordinance (20 min) 2. Committee Updates (10 min) 3. 4th Avenue Cultural Corridor Contract (10 min) 4. 2023 April Budget Amendment Ordinance (15 min) 5. February 2023 Monthly Financial Report (10 min) ADJOURNMENT: 7:30 PM Edmonds City Council Agenda April 11, 2023 Page 1 2.1 City Council Agenda Item Meeting Date: 04/11/2023 Delegation Bond Ordinance Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The city has an opportunity to refund previously issued debt, which would provide a savings to the city. Staff Recommendation For discussion. Narrative The city has an opportunity to refund previously issued debt, which could provide a savings to the city. Scott Bauer from Northwest Municipal Advisors will share information related to this potential savings, and discuss the city's opportunity to draft a delegation bond ordinance which would allow the city to start the financing process when potential savings are compelling. Attachments: City of Edmonds Finance Committee - Bond Review- April 112023 Packet Pg. 2 City of Edmonds, Washington Finance Committee Review of Outstanding Debt Potential Refunding April 11, 2023 M/ NORTHWEST MUNICIPAL ADVISORS 2.1.a Current Bond Market • Long-term interest rates increased for much of 2022 • Rates decreased at the end of 2022 and in January 2023, but increased through February, before dipping in March • The charts below show an index of well -rated, 20-year, general obligation tax-exempt bonds Bond Buyer 20-Bond General Obligation Index Bond Buyer 20-Bond General Obligation Index November 1986 to March 2023 January 2020 to March 2023 10.50 9.50 8.50 7.50 6.50 v 5.50 4.50 3.50 2.50 1.50 1986 1988 1990 1992 1994 1996 1998 2000 2002 2004 2006 2008 2010 2012 2014 2016 2018 2020 2022 4.30 3.80 3.30 d >_ 2.80 2.30 1.80 oti° oti° oti° oti° o`�° oti° otiti otiti otiti oti oI o, oti' oID oti oti o�� oti oti o�� L L L 'L `L _L 'b 'L 'b `4 'L _L - 'L '� `L L L L 'b \�A met �&�& NORTHWE i MUNICIPAL A Packet Pg. 4 2.1.a Limited Tax General Obligation Debt LTGO Bonds Par Outstanding LTGO Ref 2012• - • $ 880,000 LTGO Ref 20161,335,399 LTGO 2019 3,130,000 LTGO Ref 2021A 11,335,000 LTGO Ref 2021B. Ed am 2,570,000 Total LTGO Bonds Debt $ 19,250,399 $ 2, 500, 000 $2,000,000 $1, 500, 000 — $1,000,000 — — $500,000 -,-,—,—,- ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti 1 Callable Par $ 880,000 1,008,918 2,230,000 3,225,000 1,480,000 $ 8,823,918 Final Maturitv 12/1/2031 12/1/2026 12/1/2039 12/1/2041 12/1/2041 Coupon Ranee 1.75% - 2.25% 1.67% 2.13% - 5.00% 2.00% - 5.00% 2.00% - 2.60% Call Date 12/1/2022 12/1/2023 6/1/2029 12/1/2031 12/1/2032 ■ LTGO Ref 2012 (Unrefunded) ■ LTGO Ref 2016 - LTGO 2019 ■ LTGO Ref 2021A ■ LTGO Ref 2021B (Taxable) Z 2012 Bonds Currently Callable No savings due to rates on outstanding debt versus current bond market rates Bonds remain callable and outstanding 2016 Bond Placed with JP Morgan Callable 12/1/2023 No savings expected due to rates on outstanding debt versus current bond market rates Continue to monitor NORTHWE T MUNICIPAL, Packet Pg. 5 Water and Sewer Revenue Debt Water and Sewer Bonds Par Outstanding Callable Par $ 13,285,000 $ 13,285,000 WS Rev 2015 14,795,000 13,570,000 WS Rev 2020 _ 13,875,000 13,875,000 Total Water and Sewer Bonds Debt $ LTGO 2021A (Ref 2011 WS Bonds) $ $ 3, 500, 000 $3,000,000 $ 2, 500, 000 $2,000,000 $1, 500, 000 $1,000, 000 $500,000 41,955,000 $ 40,730,000 6,070,000 $ - Final Mat. Coupon Range Call Date 12/1/2038 4.00% - 5.00% 6/1/2023 12/1/2040 3.00% - 4.00% 6/1/2025 12/1/2045 2.00% - 2.25% 6/1/2030 12/1/2031 5.00% o'5 o'5 0''1 0''� o''C5 ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti 0 LTGO 2021A (Ref 2011 WS Bonds) ■ WS Rev 2013 WS Rev 2015 WS Rev 2020 None M N O N 2013 Bonds Callable starting on and after a 3 June 1, 2023 Est. savings shown on next c m slide E E 2021A LTGO Bonds 0 Portion of the 2011 Water anc Sewer Revenue Bonds y refunded by the 2021A LTGO r- Bonds 0 Payable from utility revenues U E z U r Q NORTHWE T MUNICIPAL, Packet Pg. 6 2.1.a 2013 Water and Sewer Rev. Bond — Est. Refunding Savings T* City of Edmonds 2013 Bonds N Bond Refunding Analysis 4/5/2023 Estimated net present value savings are better for a Refunding Summary for Water & Sewer Revenue Bonds a public bond issuance a� Final Maturity 2013 12/1/2038 Savings are dependent on current interest rates > Par Amount of Bonds Currently Outstanding $ 13,285,000 • Rates have been fluctuating m Callable Par Amount Outstanding $ 13,285,000 Call Date 6/1/2023 Rates for private placement highly Average Interest Rate 4.56% dependent on bank E Equal Annual Savings All Savings at End • The bank that provided the indicative 0 Public Market (2) Bank Placement (3) Refunding Analysis (1) 2013 2013 rate requires a structure that has a Issuance Date 6/1/2023 6/1/2023 Weighted Average Life of <_ 10 years and L N Final Maturity 12/1/2038 12/1/2037 � Par Amount of Refunding Bonds $ 11,570,000 $ 13,345,000 Final Maturity < 15 years from issuance o All -in TIC of Refunding Bonds 3.41% 3.63% date -0 Gross Savings $ 1,798,878 $ 1,873,929 w 4- Average Annual Savings $ 116,057 All savings at end • In this scenario, all savings is at Net Present Value Savings $ 1,427,584 $ 1,102,090 the end (payments would be L) Net Present Value Savings % 10.7% 8.3% approx. the same until then) E (1) Estimates • One month ago, a private placement was Zu (2) Interest rate comparable: City of Rowlett, TX WS Rev, Aa3/AA Q (3) Indicative bank interest rate (3.58%) estimated to save NPV $384,865 / 2.9% NORTHWES- MUNICIPAL AlPacket Pg. 7 2.1.a Differences of Bond Issue versus Bank Loan Bond Ordinance Official Statement Bond Rating x Request for Proposals Lots of variability in bank loans, therefore RFP advisable City issues bonds competitively, no RFP necessary Cost of Financing Depending on market conditions Time to Complete 6 weeks 12 weeks Interest rate risk NORTHWES- MUNICIPAL AlPacket Pg. 8 M N O N �L Q a 0 m 0 E E 0 U m v c 0 U- N C 0 E W 0 U 0 E 2 a 2.1.a Next Steps Draft and adopt a delegation Bond Ordinance — Allow for the refunding within parameters approved by the City Council — Allow for refunding via public bond issuance or private placement The Designated Representative (Administrative Services Director or other designee) starts financing process when savings are compelling — Bond is only sold if savings exceed target set by the City Council NORTHWE i MUNICIPAL A Packet Pg. 9 2.1.a Contact Information Scott Bauer Principal Scott@NWMunicipalAdvisors.com (425) 452-9551 NORTHWEST \/ V MUNICIPAL ADVISORS Ryan Neumeister Municipal Advisor Ryan@NWMunicipalAdvisors.com (425) 452-9552 Malinda Okerlund Municipal Advisor Malinda@NWMunicipalAdvisors.com (425) 452-9553 Packet P9. 10 Thankyou! /� /V NORTHWEST A V MUNICIPAL ate! Disclosures Conflicts of Interest and Other Matters Requiring Disclosure As of this date, except as disclosed below, NWMA is not aware of actual or potential conflicts of interest that NWMA that might impair its ability to render unbiased and competent advice or to fulfill its fiduciary duty, except as discussed. If NWMA becomes aware of any other material potential conflict of interest that arise after this disclosure, NWMA will disclose the detailed information in writing to the City in a timely manner. NWMA represents that in connection with the issuance of municipal securities, NWMA may receive compensation from an Issuer or Obligated Person for services rendered, which compensation is contingent upon the successful closing of a transaction and/or is based on the size of a transaction. Consistent with the requirements of MSRB Rule G-42, NWMA hereby discloses, that such contingent and/or transactional compensation may present a potential conflict of interest regarding NWMA's ability to provide unbiased advice to enter into such transaction. The contingent fee arrangement may create an incentive for NWMA to recommend unnecessary financings or financings that are disadvantageous to the City, or to advise the City to increase the size of the issue. This potential conflict of interest will not impair NWMA's ability to render unbiased and competent advice or to fulfill its Fiduciary Duty to the City. NWMA fees under this agreement are also based on hourly fees of NWMA's personnel, with the aggregate amount equaling the number of hours worked by such personnel multiplied by an agreed - upon hourly billing rate. This form of compensation presents a potential conflict of interest because it could create an incentive for NWMA to recommend alternatives that would result in more hours worked. This conflict of interest will not impair NWMA's ability to render unbiased and competent advice or to fulfill its Fiduciary Duty to the City. The fee paid to NWMA increases the cost of investment to the City. The increased cost occurs from compensating NWMA for municipal advisory services provided. NWMA serves a wide variety of other clients that may from time to time have interests that could have a direct or indirect impact on the interests of another NWMA client. For example, NWMA serves as municipal advisor to other municipal advisory clients and, in such cases, owes a fiduciary duty to such other clients just as it does to the City. These other clients may, from time to time and depending on the specific circumstances, have competing interests. In acting in the interests of its various clients, NWMA could potentially face a conflict of interest arising from these competing client interests. NWMA fulfills its fiduciary duty and mitigates such conflicts through dealing honestly and with the utmost good faith with City. It should be noted that NWMA's intention is to keep its work for each of its clients separate, and to maintain confidentiality relative to each client, except for information which is clearly public information. Disclosures (font.) Conflicts of Interest and Other Matters Requiring Disclosure (cont.) NWMA does not act as principal in any of the transactions related to this Agreement. NWMA does not have any affiliate that provides any advice, service, or product to or on behalf of the client that is directly or indirectly related to the municipal advisory activities to be performed by NWMA. NWMA has not made any payments directly or indirectly to obtain or retain the City's municipal advisory business. NWMA has not received any payments from third parties to enlist NWMA recommendation to the City of its services, any municipal securities transaction or any municipal finance product. NWMA has not engaged in any fee -splitting arrangements involving NWMA and any provider of investments or services to the City. NWMA does not have any legal or disciplinary event that is material to the City's evaluation of the municipal advisory or the integrity of its management or advisory personnel. NWMA is not involved in the underwriting of bonds and is not associated with any underwriting firm which eliminates any conflicts of interest related to underwriter selection or underwriter compensation. During the term of the municipal advisory relationship, this Agreement will be promptly amended or supplemented to reflect any material changes in or additions to the terms or information within this Agreement and the revised writing will be promptly delivered to the City. Legal Events and Disciplinary History NWMA does not have any legal events and disciplinary history on its Form MA and Form MA-1, which includes information about any criminal actions, regulatory actions, investigations, terminations, judgments, liens, civil judicial actions, customer complaints, arbitrations and civil litigation. The City may electronically access NWMA's most recent Form MA and each most recent Form MA-1 filed with the Commission at the following website: www.sec.gov/edgar/searchedgar/companysearch.htmi. There have been no material changes to a legal or disciplinary event disclosure on any Form MA or Form MA-1 filed with the SEC. 10 2.2 City Council Agenda Item Meeting Date: 04/11/2023 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 April 11, 2023: 1. OpenGov Implementation Plan 3. 2022 ARPA Fund Update Packet Pg. 14 2.3 City Council Agenda Item Meeting Date: 04/11/2023 4th Avenue Cultural Corridor Contract Staff Lead: Todd Tatum Department: Community Services Preparer: Todd Tatum Background/History Planning for the 4th Avenue Cultural Corridor has been ongoing for many years. In 2021, the city received a grant from ArtsWA of $34,000, matching the $34,000 allocated by the city to continue conceptual planning for the corridor. Edmonds Center for the Arts (ECA) and the City entered into an MOA which allows the City to bill the ECA up to $20,000 for design services as part of this contract supporting the design of the connection between 4th Avenue and the ECA's grounds. Staff recognize the challenges in funding and completing this project, and have focused the efforts on three primary areas: the connection with the Edmonds Center for the Arts, the pocket park, and a feasible funding and phasing strategy. Staff Recommendation Forward the contract on April 18th's consent agenda authorizing the Mayor's signature Narrative This contract builds on work done over several years, brings in a partner (the ECA) which may help with eventual funding of construction, and brings together staff from different city departments. This phase of work is important because we'll begin to get into the challenging details of phasing and funding. This contractor was chosen out of several in part because of their funding strategy expertise. The Request for Quotes and Qualifications allowed for the successful bidder to be contracted for future phases. This allows for continuity in design and construction. This contract does not go beyond this phase of design, however, should funding be available for future phases, this contractor may be contracted for that work. Attachments: FINAL DRAFT Professional Services Agreement KPG Psomas 4th Ave CC 20230321 (with SEC edits) 3.23.2023 Exhibit A - Edmonds _4th Avenue Scope of Work 3.20.23 Exhibit B - Edmonds 4th Avenue Fee Estimate 3.20.23 Packet Pg. 15 2.3.a R I . CITY OF EDMONDS MIKE NELSON MAYOR 121 ST" AVENUE NORTH - EDMONDS, WA 98020 - 425-771-0220 - FAX 425-872-5750 d Website: www.edmondswa.gov PUBLIC WORKS DEPARTMENT a Engineering Division PROFESSIONAL SERVICES AGREEMENT THIS AGREEMENT ("Agreement") is made and entered into between the City of Edmonds, hereinafter referred to as the "City," and KPG Psomas, hereinafter referred to as the "Consultant." WHEREAS, the City desires to engage the professional services and assistance of a consulting firm to provide architectural design and cost estimating services with respect to the 4th Avenue Cultural Corridor project; and WHEREAS, the Consultant has the necessary skills and experience, and desires to provide such services to the City; NOW, THEREFORE, in consideration of the mutual benefits accruing, it is agreed by and between the parties hereto as follows: 1. Scope of work. The scope of work shall include all services and material necessary to accomplish the above mentioned objectives in accordance with the Scope of Work that is marked as Exhibit A, attached hereto and incorporated herein by this reference. 2. Payments. The Consultant shall be paid by the City for completed work for services rendered under this Agreement as provided hereinafter. Such payment shall be full compensation for work performed or services rendered and for all labor, materials, supplies, equipment and incidentals necessary to complete the work. A. Payment for work accomplished under the terms of this Agreement shall be on a time and expense basis as set forth in Exhibit B, attached hereto and incorporated herein by this reference; provided, in no event shall the payment for work performed on Phase 1 of the project pursuant to this Agreement exceed the sum of SIXTY-EIGHT THOUSAND DOLLARS ($68,000.00). At the City's option, work to be performed on subsequent phases of the project (Phases 2 and/or 3) and the budget therefor may be added by amendment to this Agreement. B. All vouchers shall be submitted by the Consultant to the City for payment pursuant to the terms of this Agreement. The City shall pay the appropriate amount for each voucher to the Consultant. The Consultant may submit vouchers to the City monthly during the progress of the work for payment of completed phases of the project. Billings shall be reviewed in conjunction with the City's warrant process. No billing shall be considered for payment that has not been submitted to the City three days prior to the scheduled cut-off date. Such late vouchers will be checked by the City and payment will be made in the next regular payment cycle. Packet Pg. 16 2.3.a C. The costs records and accounts pertaining to this Agreement are to be kept available for inspection by representatives of the City for a period of three (3) years after final payment. Copies shall be made available upon request. a 3. Ownership and use of documents. All research, tests, surveys, preliminary data, reports, and any and all other work product prepared or gathered by the Consultant in preparation for the services rendered by the Consultant under this Agreement shall be and are the property of o the Consultant, provided, however, that: M A. All final reports, presentations, documentation and testimony prepared by the Consultant shall become the property of the City upon their presentation to and acceptance by the City and shall at that date become the property of the City. B. The City shall have the right, upon reasonable request, to inspect, review and copy any work product during normal office hours. Documents prepared under this Agreement and in the possession of the Consultant may be subject to public records request and release under Chapter 42.56 RCW. C. In the event that the Consultant shall default on this Agreement, or in the event that this Agreement shall be terminated prior to its completion as herein provided, the work product of the Consultant, along with a summary of work done to date of default or termination, shall become the property of the City and tender of the work product and summary shall be a prerequisite to final payment under this Agreement. The summary of work done shall be prepared at no additional cost. 4. Time of performance. The Consultant shall perform the work authorized by this Agreement promptly in accordance with the receipt of the required governmental approvals. 5. Indemnification / Hold harmless agreement. The Consultant shall defend, indemnify and hold the City, its officers, officials, employees and volunteers harmless from any and all claims, injuries, damages, losses, demands, or suits at law or equity arising from the acts, errors or omissions of the Consultant in the performance of this Agreement, except for injuries and damages caused by the sole negligence of the City. Should a court of competent jurisdiction determine that this Agreement is subject to RCW 4.24.115, then, in the event of liability for damages arising out of bodily injury to persons or damages to property caused by or resulting from the concurrent negligence of the Consultant and the City, its officers, officials, employees, and volunteers, the Consultant's liability, including the duty and cost to defend, hereunder shall be only to the extent of the Consultant's negligence. The Consultant shall comply with all applicable sections of the applicable Ethics laws, including RCW 42.23, which is the Code of Ethics for regulating contract interest by municipal officers. The Consultant specifically assumes potential liability for actions brought by the Consultant's own employees against the City and, solely for the purpose of this indemnification and defense, the Consultant specifically waives any immunity under the state industrial insurance law, Title 51 RCW. This waiver has been mutually negotiated by the parties. The provisions of this section shall survive the expiration or termination of this Agreement. Packet Pg. 17 2.3.a 6. General and professional liability insurance. The Consultant shall obtain and keep in force during the term of this Agreement, or as otherwise required, the following insurance 3 with companies or through sources approved by the State Insurance Commissioner pursuant to Title 48 RCW. a Insurance Coverage A. Worker's compensation and employer's liability insurance as required by the State. B. Commercial general liability and property damage insurance in an aggregate amount not less than two million dollars ($2,000,000) for bodily injury, including death and property damage. The per occurrence amount shall be written with limits no less than one million dollars ($1,000,000). C. Vehicle liability insurance for any automobile used in an amount not less than a one million dollar ($1,000,000) combined single limit. D. Professional liability insurance in the amount of one million dollars ($1,000,000). Excepting the Worker's Compensation Insurance and Professional Liability Insurance secured by the Consultant, the City will be named on all policies as an additional insured. The Consultant shall furnish the City with verification of insurance and endorsements required by the Agreement. The City reserves the right to require complete, certified copies of all required insurance policies at any time. All insurance shall be obtained from an insurance company authorized to do business in the State of Washington. The Consultant shall submit a verification of insurance as outlined above within fourteen days of the execution of this Agreement to the City. No cancellation of the foregoing policies shall be effective without thirty (30) days prior notice to the City. The Consultant's professional liability to the City shall be limited to the amount payable under this Agreement or one million dollars ($1,000,000), whichever is the greater, unless modified elsewhere in this Agreement. In no case shall the Consultant's professional liability to third parties be limited in any way. 7. Discrimination prohibited. The Consultant shall not discriminate against any employee or applicant for employment because of race, color, religion, national origin, age, sex, sexual orientation, marital status, veteran status, liability for service in the armed forces of the United States, disability, or the presence of any sensory, mental or physical handicap, or any other protected class status, unless based upon a bona fide occupational qualification. 8. Consultant is an independent contractor. The parties intend that an independent contractor relationship will be created by this Agreement. No agent, employee or representative of the Consultant shall be deemed to be an agent, employee or representative of the City for any purpose. The Consultant shall be solely responsible for all acts of its agents, employees, representatives and subcontractors during the performance of this Agreement. 9. City approval of work and relationships. Notwithstanding the Consultant's status as an independent contractor, results of the work performed pursuant to this Agreement must meet the approval of the City. During pendency of this Agreement, the Consultant shall not perform work for any party with respect to any property located within the City of Edmonds or for any project subject to the administrative or quasijudicial review of the City without written notification to the City and the City's prior written consent. Packet Pg. 18 2.3.a 10. Termination. This being an Agreement for professional services, either party may terminate this Agreement for any reason upon giving the other parry written notice of such termination no fewer than ten (10) days in advance of the effective date of said termination. a 11. Integration. The Agreement between the parties shall consist of this document, its Appendices 1 & 2, and the Scope of Work and fee schedule attached hereto as Exhibits A and B. These writings constitute the entire Agreement of the parties and shall not be amended except o by a writing executed by both parties. In the event of any conflict between this written Agreement N M and any provision of Exhibit A or B, this Agreement shall control. M 12. Changes/Additional Work. The City may engage the Consultant to perform services in addition to those listed in this Agreement, and the Consultant will be entitled to additional compensation for authorized additional services or materials. The City shall not be liable for additional compensation until and unless any and all additional work and compensation is approved in advance in writing and signed by both parties to this Agreement. If conditions are encountered which are not anticipated in the Scope of Work, the City understands that a revision to the Scope of Work and fees may be required. Provided, however, that nothing in this paragraph shall be interpreted to obligate the Consultant to render services, or the City to pay for services rendered, in excess of the Scope of Work in Exhibit A unless or until an amendment to this Agreement is approved in writing by both parties. 13. Standard of Care. The Consultant represents that the Consultant has the necessary knowledge, skill and experience to perform services required by this Agreement. The Consultant and any persons employed by the Consultant shall use their best efforts to perform the work in a professional manner consistent with sound practices, in accordance with the schedules herein and in accordance with the usual and customary professional care required for services of the type described in the Scope of Work. 14. Non -waiver. Waiver by the City of any provision of this Agreement or any time limitation provided for in this Agreement shall not constitute a waiver of any other provision. 15. Non -assignable. The services to be provided by the Consultant shall not be assigned or subcontracted without the express written consent of the City. 16. Covenant against contingent fees. The Consultant warrants that he/she/they has/have not employed or retained any company or person, other than a bona fide employee working solely for the Consultant, to solicit or secure this Agreement, and that he/she/they has/have not paid or agreed to pay any company or person, other than a bona fide employee working solely for the Consultant, any fee, commission, percentage, brokerage fee, gifts, or any other consideration contingent upon or resulting from the award of making of this Agreement. For breach or violation of this warranty, the City shall have the right to annul this Agreement without liability or, in its discretion to deduct from the contract price or consideration, or otherwise recover, the full amount of such fee, commission, percentage, brokerage fee, gift, or contingent fee. 17. Compliance with laws. The Consultant in the performance of this Agreement shall comply with all applicable Federal, State or local laws and ordinances, including regulations for licensing, certification and operation of facilities, programs and accreditation, and licensing of individuals, and any other standards or criteria as described in the Agreement to assure quality of services. Because this Agreement is subject to federal nondiscrimination laws, the Consultant Packet Pg. 19 2.3.a agrees that the provisions of Appendices 1 & 2, attached hereto and incorporated herein by this reference, apply to this Agreement. The Consultant specifically agrees to pay any applicable business and occupation (B & O) taxes which may be due on account of this Agreement. a 18. Notices. Notices to the City of Edmonds shall be sent to the following address: M City of Edmonds 121 Fifth Avenue North Edmonds, WA 98020 Notices to the Consultant shall be sent to the following address: KPG Psomas 3131 Elliot Avenue #400 Seattle, WA 98121 Receipt of any notice shall be deemed effective three (3) days after deposit of written notice in the U.S. mails, with proper postage and properly addressed. DATED THIS day of CITY OF EDMONDS Mike Nelson, Mayor ATTEST/AUTHENTICATED: Scott Passey, City Clerk APPROVED AS TO FORM: Office of the City Attorney STATE OF WASHINGTON ) 2023. KPG PSOMAS Nandez Miller, Vice President Packet Pg. 20 2.3.a )ss COUNTY OF ) c as On this day of 2023, before me, the undersigned, a Notary a Public in and for the State of Washington, duly commissioned and sworn, personally appeared Nandez Miller, to me known to be the person who executed the foregoing instrument, and acknowledged the said instrument to be the free and voluntary act and deed of said person, for the o uses and purposes therein mentioned, and on oath stated that he/she was authorized to execute said N M instrument. ry WITNESS my hand and official seal hereto affixed the day and year first above written. NOTARY PUBLIC My commission expires: Packet Pg. 21 2.3.a APPENDIX 1 CONTRACT (Appendix A of USDOT 1050.2A Standard Title VI Assurances) 3 c During the performance of this Agreement, the Consultant/Contractor, for itself, its assignees, and successors > in interest (hereinafter collectively referred to as the "Consultant/Contractor") agrees as follows: a 1. Compliance with Regulations: The Consultant/Contractor shall comply with the acts and regulations M relative to nondiscrimination in federally -assisted programs of the United States Department of c Transportation (USDOT), Title 49, Code of Federal Regulations, Part 21 (49 CFR 21), as they may be ri amended from time to time (hereinafter referred to as the Regulations), which are herein incorporated N by reference and made a part of this Agreement. Nondiscrimination: The Consultant/Contractor, with regard to the work performed by it during the Agreement, shall not discriminate on the grounds of race, color, national origin, sex, age, disability, income -level, or LEP in the selection and retention of subcontractors, including procurement of materials and leases of equipment. The Consultant/Contractor shall not participate directly or indirectly in the discrimination prohibited by Section 21.5 of the Regulations, including employment practices when the Agreement covers any activity, project, or program set forth in Appendix B of 49 CFR 21. Solicitations for Subcontracts, Including Procurements of Materials and Equipment: In all solicitations, either by competitive bidding, or negotiation made by the Consultant/ Contractor for work to be performed under a subcontract, including procurement of materials, or leases of equipment, each potential subcontractor or supplier shall be notified by the Consultant/Contractor of the Consultant's/Contractor's obligations under this Agreement and the Regulations relative to nondiscrimination on the grounds of race, color, national origin, sex, age, disability, income -level, or LEP. Information and Reports: The Consultant/Contractor shall provide all information and reports required by the Regulations and directives issued pursuant thereto, and shall permit access to its books, records, accounts, other sources of information, and its facilities as may be determined by the City or the appropriate state or federal agency to be pertinent to ascertain compliance with such Regulations, orders, and instructions. Where any information required of a Consultant/Contractor is in the exclusive possession of another who fails or refuses to furnish the information, the Consultant/Contractor shall so certify to the City, or state or federal agency, as appropriate, and shall set forth what efforts it has made to obtain the information. Sanctions for Noncompliance: In the event of the Consultant's/Contractor's noncompliance with the nondiscrimination provisions of this Agreement, the City shall impose such contract sanctions as it or the appropriate state or federal agency may determine to be appropriate, including, but not limited to: • Withholding of payments to the Consultant/Contractor under the Agreement until the Consultant/Contractor complies; and/or • Cancellation, termination, or suspension of the Agreement, in whole or in part. 6. Incorporation of Provisions: The Consultant/Contractor shall include the provisions of the above paragraphs one (1) through five (5) in every subcontract, including procurement of materials and leases of equipment, unless exempt by the Regulations, or directives issued pursuant thereto. The Consultant/Contractor shall take such action with respect to any subcontractor or procurement as the City or appropriate state or federal agency may direct as a means of enforcing such provisions, including sanctions for noncompliance. Provided, that if the Consultant/Contractor becomes involved in, or is threatened with, litigation by a subcontractor or supplier as a result of such direction, the Consultant/ Contractor may request that the City enter into such litigation to protect the interests of the City; or may request that the appropriate state agency enter into such litigation to protect the interests of the State of Washington. In addition, the Consultant/Contractor may request the appropriate federal agency enter into such litigation to protect the interests of the United States. Packet Pg. 22 2.3.a APPENDIX 2 CONTRACT (Appendix E of USDOT 1050.2A Standard Title VI Assurances) 3 c d Q t During the performance of this Agreement, the Consultant/Contractor, for itself, its assignees, and successors in interest (hereinafter collectively referred to as the "Consultant/Contractor") agrees to comply with the M following non-discrimination statutes and authorities, including but not limited to: c Pertinent Non -Discrimination Authorities: • Title VI of the Civil Rights Act of 1964 (42 U.S.C. § 2000d et seq., 78 stat. 252), (prohibits discrimination on the basis of race, color, national origin); and 49 CFR Part 21. • The Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1970, (42 U.S.C. § 4601), (prohibits unfair treatment of persons displaced or whose property has been acquired because of Federal or Federal -aid programs and proejcts); • Federal -Aid Highway Act of 1973, (23 U.S.C. § 324 et seq.), (prohibits discrimination on the basis of sex); • Section 504 of Rehabilitation Act of 1973, (29 U.S.C. § 794 et seq.), as amended, (prohibits discrimination on the basis of disability); and 49 CFR Part 27; • The Age Discrimination Act of 1975, as amended, (42 U.S.C. § 6101 et seq.), (prohibits discrimination on the basis of age); • Airport and Airway Improvement Act of 1982, (49 U.S.C. § 471, Section 47123), as amended, (prohibits discrimination based on race, creed, color, national origin, or sex); • The Civil Rights Restoration Act of 1987, (PL 100-209), (Broadened the scope, coverage and applicability of Title VI of the Civil Rights Act of 1964, The Age Discrimination Act of 1975 and Section 504 of the Rehabilitation Act of 1973, by expanding the definition of the terms "programs or activities" to include all of the programs or activities of the Federal -aid recipients, sub -recipients and contractors, whether such programs or activities are Federally funded or not); • Titles II and III of the Americans with Disabilties Act, which prohibit discrimination on the basis of disability in the operation of public entities, public and private transportation systems, places of public accommodation, and certain testing entities (42 U.S.C. §§ 12131-12189) as implemented by Department of Transportation regulations at 49 C.F.R. parts 37 and 38; • The Federal Aviation Administration's Non -Discrimination statute (49 U.S.C. § 47123) (prohibits discrimination on the basis of race, color, national origin, and sex); • Executive Order 12898 , Federal Actions to Address Environmental Justice in Minority Populations and Low -Income Populations, which ensures discrimination against minority populations by discouraging programs, policies, and activities with disproportionately high and adverse human health or environmental effects on minority and low-income populations; • Executive Order 13166, Improving Access to Services for Person with Limited English Profcency, and resulting agency guidance, national origin discrimination includes discrimination because of limited English proficiency (LEP). To ensure compliance with Title VI, you must take reasonable steps to ensure the LEP person have meaningful access to your programs (70 Fed. Reg. at 74087 to 74100); • Title IX of the Education Amendments of 1972, as amended, which prohibits you from discriminating because of sex in education programs or activities (20 U.S.C. 1681 et seq). Packet Pg. 23 EXHIBIT A 2.3.b City of Edmonds 4`' Avenue Cultural Corridor Preliminary Plan/10% Engineering for North Segment Edmonds Street to 3rd Avenue N. KPG Psomas Scope of Work March 20, 2023 Introduction As a key enhancement to the Creative District in downtown, the 4' Avenue Cultural Corridor project, from Main St to 3rd Avenue N will provide an improved pedestrian experience, highlight the historic assets along 4" Avenue, showcase a range of integrated public art and provide flexible spaces for event programming, all while maintaining vehicular access to properties and on street parking along the corridor. Project Scope This scope of work outlines the effort required for preliminary design for the north segment of the 4t' Avenue Cultural Corridor, between Edmonds Street and V Avenue N, for a length of approximately 780 LF. Specifically, this project creates alternatives to connect property owned by the Edmonds Center for the Arts (ECA) at the north end of the corridor along 4t' Avenue heading south toward Main Street including a design element for the small art corner park. This scope will build upon the 2009 Funding and Implementation Plan and 2020 refinement and provide a preferred 10% preliminary design, public engagement, and a funding and implementation plan. The scope of work project components include: 1. Refine the north segment with street layout alternatives, based in part on the 2009 plan and 2020 outreach, that results in a preferred alternative and preliminary plan/ 10% engineering layout for this segment. 2. Provide art corner park conceptual alternatives. 3. Provide conceptual alternatives for the adjoining Edmonds Center for the Arts campus on west side of buildings. 4. Provide an art and cultural plan for the corridor within project limits. 5. Provide a funding and implementation plan that includes high level estimated construction costs, design costs, and identifies the required elements and scope for final design for the corridor within the project limits. 6. Identify grant funding opportunities, schedules, and criteria. 7. Provide a public engagement plan, providing content for public outreach, continuing stakeholder outreach, engagement with the project advisory team and City Council presentations. Assumptions The following assumptions were made when preparing the scope and budget: City of Edmonds 4`" Avenue Cultural Corridor KPG Psomas 3/14/2023 Packet Pg. 24 EXHIBIT A Design Status • This scope is for the northern segment of 4' Avenue from Edmonds Street to 3`d Avenue N. A future supplement for additional design services will be presented to review the full 4" Avenue Cultural Corridor from just south of Main Street to 3' Avenue N. • No Final Design or construction documentation is included in this scope. • No specific adaptive reuse review and plan will be included in this scope. • There is currently no secured design or construction funding for this project. • The 4'' Avenue Cultural Corridor project is identified on the City of Edmonds Six Year Transportation Improvement Plan (2023-2028) as #34 under Pedestrian Projects, from Main St. to 3rd Avenue N. The total cost is estimated as $8M. Note, PWT-66 identifies the estimated cost as $9.2M with design as $2.2M and construction as $7M. Products and Project Timeline • The project scope will be completed within 8 months from notice to proceed. • The terms Preliminary Plan and 10% Engineering Plan are one and the same. Survey • KPG Psomas will provide the preliminary layout plan in AutoCAD Civil 3D 2022. No additional survey t will be gathered for this scope. The art pocket park layout will be tied to the survey base map with S augmented information from an aerial photo to show the area missing outside the survey. M N • Note, the 2019 survey has limited information between back of existing sidewalk and right of way near 0 M existing residential and commercial building faces. The Preliminary Plan will identify where the proposed I- layout will go beyond the existing back of sidewalk. Although not in the current scope, there will be future o` 4- coordination with property owners to explain proposed frontage modification and restoration due to the existing encroachment in City right of way. Q. 0 • Prior to final design, there will be additional survey needs depending on final project footprint and CO connection into existing roadway features within right of way. Survey is not included in this scope of work. Engineering Q • The preferred layout plan will include proposed anticipated curb lines, parking channelization, radius returns z V� at intersections, raised intersections, sidewalks, planter strips, and existing utilities from the 2019 survey. The -a driveway, walls, and feature layouts behind sidewalk are not included in this scope. c E • Public Works will review and verify the 10% Preliminary Layout with existing and proposed utilities. w • Consultant transportation planning will review for one way street traffic and downtown circulation and access Q and will include comment during design alternative refinement task. Permitting and Environmental Documentation z x w • Permitting and Environmental Documentation will not be included in this contract. Right of Way Needs E • Right of way acquisition services will not be included in this contract. z Public Outreach and Stakeholder Involvement Q • Consultant shall provide and prepare project materials for meetings and events identified in Task 3. Grant Funding Assistance • The support and writing for specific grant applications is not included in this scope of work. City of Edmonds KPG Psomas 4`h Avenue Cultural Corridor 3/20/2023 2 Packet Pg. 25 EXHIBIT A 2.3.b City of Provided Items: The City will provide/prepare the following: • 2019 4'' Ave Corridor Survey in AutoCAD. • Any additional GIS data on existing utilities, existing ROW limits, sensitive area delineations, and as -built information available within project limits. • Proposed utility work limits for each City owned utility, including Fiber. • Any additional information about the project not included in the 2009 plan and 2020 outreach. • Website and city communications to the community. • Provide meeting room arrangements and advertisement (flyers, mailers & e-blast) for project update, schedule, survey, community meetings and local events: o (1) Advisory Committee Meetings shall be virtual / in -person meetings o (2) community meetings shall be in -person meetings/ one of which will be held at ECA with ECA constituents. o (1) Tabling at one local event shall be in -person (one tabling event at Summer Market in August/September) • Any coordination with Agencies. • (2) City Council meetings shall be an in -person meeting (Committee and Fall) • City will be coordinating with stakeholders to take the lead on the public engagement process. • City will be managing the communications side of public outreach (including project website, processing community feedback, City's social media platforms, relaying information to consultants for consideration, etc.). • ECA will be involved in the project's public outreach process. Deliverables: Deliverables prepared by the Consultant are identified at the end of each task. SCOPE OF WORK The following scope of work includes the effort to complete the above -described improvements: Task 1— Management/Coordination/Administration This task covers the effort required to manage the contract and to ensure that the project meets the client's expectations for schedule, budget, and quality of product: 1.1 Provide project administrative services including: • Project set-up and agreement execution • Execution of subconsultant agreements • Preparation of monthly progress reports and invoices City of Edmonds +' Avenue Cultural Corridor KPG Psomas 3/20/2023 Packet Pg. 26 N EXHIBIT A 2.3.b • Maintaining project files • Record keeping and project closeout 1.2 Provide project management services including: • Project staff management and coordination • Subconsultant management and coordination • Prepare and update project schedule • Schedule and budget monitoring 1.3 Design coordination meetings with City staff and EAC representatives: • Monthly PM coordination meetings. Check in meeting every other week between City and Consultant project managers. Team meeting or phone calls. (Assumes 8 min meetings) Deliverables/Products: • Monthly progress report and invoice • Meeting minutes for Consultant/City meetings Task 2 - Preliminary 10% Design The Consultant shall complete 10% Preliminary engineering plan and supporting plans, sections and sketches. 2.1 Design Alternatives Refinement and ECA Frontage The Consultant shall prepare a roadway layout on the survey based upon the 2009 and 2020 efforts, within the existing right of way showing sidewalk, curb and gutter, planter strip, parking and channelization. This layout will be refined to a preferred alternative and typical section. ADA facility locations, cross street control, curb bulbs/art parklets, street trees, and schematic street furniture locations may be identified. The Consultant shall also develop two (2) conceptual alternatives for the ECA lawn area adjoining the public right of way on the west side of the campus buildings. 2.2 10% Design of Engineering/Preliminary Plan Based upon City and stakeholder review and input of the alternative layouts drafted in 2.1, a Preliminary Plan layout will be developed including supporting cross section graphics for the roadway and urban design components. This Preliminary Plan will show: horizontal location of paving, channelization, sidewalks, parking, driveway cuts, existing utilities, and probable landscape locations and restoration areas. The Preliminary Plan will contain sufficient information for City verification of the overall project scope and for use in providing cost estimates. This scope does not include vertical design information or specific details. Hence it will not fully evaluate the preferred cross section impacts to the vertical design elements listed below. ■ Access Management /Driveways ■ Stormwater facilities (conveyance, water quality, and LID requirements) City of Edmonds KPG Psomas 4`h Avenue Cultural Corridor 3/20/2023 4 1 Packet Pg. 27 EXHIBIT A 2.3.b ■ Water and Sewer facilities ■ Walls and vertical constraints ■ Franchise Utilities ■ Pedestrian and Roadway Lighting 2.3 Preliminary Illustrative Plan The Consultant shall develop a Preliminary Illustrative Plan of the preferred layout identified in 2.2 with theme/character development including an illustrative plan, thematic urban design elements, public art and historic cultural features, and illustrative street cross sections. 2.4 Art Corner Park Plan The Consultant shall develop two (2) conceptual alternatives for art corner park with one (1) refined alternative art corner park plan to be included in the Implementation Plan. Deliverables/Products: • Scroll Plot Design Alternative Layouts (I Vx Project Length hard copy and electronic PDF). There will be two iterations of refined layout scroll plot submittals to the Client for review and discussion. • Scroll Plot Preliminary Plan (11"x Project Length hard copy and electronic PDF). There will be two submittals to the Client. One draft layout to the Client for review and comment, and one final Preliminary Plan that incorporates Client and Stakeholder comments for final deliverable. • Scroll Plot Preliminary Illustrative Plan (matches 10% Engineering Plan) including street furniture, art and cultural elements, pavement types, parklets/curb bulb space for people or for future LID/GSI (11"x Project Length hard copy and electronic PDF) • Refined Preliminary Art Corner Park Plan (Illustrative) (I I "x17" electronic PDF) • Scroll Plot Existing Utilities Plan (11"x Project Length hard copy and electronic PDF) • Typical Cross Sections (Engineering) (11"x17" electronic PDF) • Typical Cross Sections (Illustrative) (11"x17" electronic PDF) • Illustrative Perspectives (2 Photo simulations) (11"x17" electronic PDF) • Preliminary Urban Design Package (Project Narrative & Photo Examples - 11"x17" electronic PDF) Task 3 - Stakeholder Coordination and Public Outreach The Consultant shall lead stakeholder outreach efforts to gain targeted input and consensus from stakeholders on the desired corridor improvements. 3.1 Advisory Committee Meetings The Consultant will facilitate 1 meeting with the Advisory Committee to discuss and refine the corridor plan, to ensure that the vision of the 4`h Avenue and the Creative District will have a cohesive theme. 3.2 Community Meetings The Consultant will attend, facilitate discussions, and present the refined corridor plan at 2 community meetings, one held at the ECA. City of Edmonds KPG Psomas +' Avenue Cultural Corridor 3/20/2023 5 Packet Pg. 28 EXHIBIT A 2.3.b 3.3 Table Local Event The Consultant shall attend a local event, set up a tent and table to provide information on the refined corridor plan and solicit public input via online survey. (One at Summer Market) 3.4 Content for online survey, meetings, events, and city website The Consultant will create content for online surveys, community meetings, and the City's project website. Deliverables/Products: • Meeting Minutes (Electronic PDF) • Illustrative Products from Task 2 • Public feedback data from online surveys Task 4 — Funding and Implementation Plan The Consultant shall develop a funding and implementation plan which shall include a high-level cost estimate, identify potential grand funding programs, and include the deliverables produced in Task 2. 4.1 Cost Estimating The Consultant shall provide an Engineering Opinion of Probable Construction Cost, following City of Edmonds estimating policy, that will be developed based upon the 10% Preliminary Plan. The cost estimate will be to a sufficient level to support funding and grant application requirements. The cost estimate shall include and carry costs for anticipated wet and dry utility replacements, pedestrian and roadway lighting, stormwater conveyance, grading, and other typical roadway components that will need to be analyzed and incorporated into final design. 4.2 Grant Funding The Consultant shall identify probable grant funding programs, eligibility criteria, and application dates for city pursual. The Consultant will identify potential project revisions or new project elements to improve the project's likelihood to receive grant funding which may include but is not limited to safety, pedestrian facilities, economic development, and arts and placemaking. 4.3 Funding and Implementation Plan The Consultant shall package deliverables of Tasks 2, 3 and 4 under one cover sheet for the City to shepherd grant funding, agency coordination, and department coordination for final design scoping and funding. Deliverables/Products: • Project Funding and Implementation Plan with all deliverables included within. o High Level Construction Cost Estimate including Final Design and Construction Management Services estimates. (Electronic PDF & Excel Format) o Grant funding Excel Matrix identifying funding sources, criteria, and application dates. City of Edmonds 4`h Avenue Cultural Corridor KPG Psomas 3/20/2023 Packet Pg. 29 R1 EXHIBIT A (Electronic PDF & Excel Format) o Funding and Implementation Plan ■ Coversheet ■ Two page or less summary of the 10% Engineering Preliminary Plan and preferred layout process and conclusion ■ Appendix A: Tasks 2.2-2.4 - Deliverables ■ Appendix B: Task 4.1 - High Level Construction Cost Estimate Deliverable ■ Appendix C: Task 4.2 Grant Funding Matrix Deliverable ■ Appendix D: Task 3.1-3.5 - Stakeholder Coordination and Public Outreach Summary (may include graphics, minutes, or milestone decision making from events) Additional Services The City may require additional services from the Consultant. The scope of these services will be determined based on unanticipated project needs or other considerations at the sole discretion of the City. This work may include items identified in the current task authorizations as well as other items, which may include, but are not necessarily limited to the following: • Additional full corridor roadway layout alternatives from just south of Main Street to 3rd Avenue N, cross sections, and illustrative drawings • Topographic Survey Services • Grant Writing Services • Transportation Operations Analysis • Street Lighting Analysis • Stormwater Conveyance and Water Quality/LID Requirements Analysis • Water Main Design • Geotechnical Investigation and Analysis • Environmental Analysis • Preliminary/Final Design Services • Construction Services and Administration These services will be authorized by the City under supplemental scope or management reserve. At the time these services are required, the Consultant shall provide a detailed scope of work and an estimate of costs. The Consultant shall not proceed with the work until the City has authorized the work and issued a written notice to proceed. City of Edmonds +' Avenue Cultural Corridor KPG Psomas 3/20/2023 Packet Pg. 30 7 2.3.c KPG Client: City of Edmonds Project Name: 4th Avenue Cultural Corridor - North Segment KPG Psomas Date: 3/20/2023 EXHIBIT D-1 PRIME CONSULTANT COST COMPUTATIONS Task No. Task Description Labor Hour Estimate Total Hours and Labor Cost Computions by Task Q _ L a 'i N m =+ __ c=a w� L a1 _ w = '- C: c L a � _ r c . '�► _ w = y •L 'C% ._ = s ci LU d d � o = r_ (a �� Q V V (C y W o v a= L JQ Q (O 'V 0 ._ v, _ -a t = Ci _J o � L p � N 'e _ = o = a> Q- M N N is o -W L � d 't _ o = a M y Laa=i M L � � _ 0 E E 'tS Q p Cn _ E Q 0 Ci O W+ +� �, N Q p $285.00 $251.00 $175.00 $149.00 $133.00 $114.00 $200.00 $155.00 $102.00 $190.00 $114.00 $178.00 $133.00 $103.00 $82.00 Hours Totals Task 1 - Management/Coordination/Administration 1.1 Provide project administrative services 6 2 4 12 $ 2,394.00 1.2 Provide project management services (8 months) 6 4 10 $ 2,242.00 1.3 Design coordination meetings with City staff (Monthly) 6 8 8 2 24 $ 4,730.00 0 $ - Task Total 12 6 8 0 0 0 0 8 0 2 0 2 8 0 0 46 $ 9,366.00 Task 2 - Preliminary 10% Design 2.1 Design Alternatives Refinement and ECA Frontage 1 2 8 8 8 27 $ 4,947.00 2.2 10% Engineering/Preliminary Plan 1 8 8 24 32 73 $ 9,717.00 2.3 Preliminary Illustrative Plan 1 32 48 81 $ 10,141.00 2.4 Art Corner Park Plan 1 8 16 25 $ 3,157.00 Task Total 4 2 16 8 24 32 0 32 64 8 0 0 0 0 0 206 $ 27,962.00 Task 3 - Stakeholder Coordination and Public Outreach 3.1 Facilitate Advisory Committee Meetings (1) 3 4 7 $ 1,475.00 3.2 Facilitate Community Meetings (2) 4 4 8 4 4 24 $ 3,640.00 3.3 Table Local Events (2) 8 24 32 $ 3,688.00 3.4 Provide content for meetings and website 1 16 48 65 $ 7,661.00 Task Total 4 0 4 0 4 0 0 36 76 4 0 0 0 0 0 128 $ 16,464.00 Task 4 - Funding and Implementation Plan 4.1 Cost Estimating 1 8 24 8 41 $ 6,083.00 4.2 Grant Funding 1 8 16 25 $ 3,595.00 4.3 Funding and Implementation Plan 1 12 12 25 $ 4,173.00 0 $ - Task Total 1 2 20 12 24 0 0 8 0 8 116 0 0 0 0 91 $ 13,851.00 Total Labor Hours and Fee 21 10 48 20 52 32 0 84 140 22 16 2 8 0 0 471 $ 67,643.00 Subconsultants Subtotal $ - Administrative Charge (5%) $ - Total Subconsultant Expense $ - Reimbursable Direct Non -Salary Costs Mileage at current IRS rate $ 150.00 Reproduction Allowance Total Reimbursable Expense $ 150.00 Total Estimated Budget $ 67,793.00 Packet Pg. 31 2.4 City Council Agenda Item Meeting Date: 04/11/2023 2023 April Budget Amendment Ordinance Staff Lead: Dave Turley Department: Administrative Services Preparer: Marissa Cain Background/History Amend the 2023 Ordinance No. 4297 Staff Recommendation Staff recommends to include on the April 18th City Council agenda for review and approval by full Council. Attachments: 2023 April Budget Amendment Exhibits 2023 April Budget Amendment Ordinance Packet Pg. 32 2.4.a Previously Discussed by Council (April 2023) Budget Amendment for: December 13, 2022 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 AFSCME Collective Bargaining Agreement was approved by council on November 22, 2022. This agreement rovers the contract period of 1/1/2022-12/31/2024. This decision package is included to add budget authority for the .ncreased salaries for 2023. Services Increase Cain Previously Discussed By Council Nov 22 2022 100% Ending Fund Balance One -Time Operating Fund MULTIPLE FUNDS Name: Account Number Description 2023 2024 2025 2026 2027 001.000.23.512.51.11.00 Salaries $ 590,000.00 $ $ $ S 001.000.23.512.51.23.00 Benefits $ 118,000.00 001.000.23.523.30.11.00 Salaries $ 50,000.00 001.000.23.523.30.23.00 Benefits $ 10,000.00 001.000.31.514.23.11.00 Salaries $ 140,000.00 001.000.31.514.23.23.00 Benefits $ 28,000.00 001.000.31.514.31.11.00 Salaries $ 10,000.00 001.000.31.514.31.23.00 Benefits $ 2,000.00 001.000.61.557.20.11.00 Salaries $ 40,000.00 001.000.61.557.20.23.00 Benefits $ 8,000.00 001.000.61.573.90.11.00 Salaries $ 14,000.00 001.000.61.573.90.23.00 Benefits $ 2,800.00 001.000.62.524.10.11.00 Salaries $ 29,000.00 001.000.62.524.10.23.00 Benefits $ 5,800.00 001.000.62.524.20.11.00 Salaries $ 85,000.00 001.000.62.524.20.23.00 Benefits $ 17,000.00 001.000.62.558.60.11.00 Salaries $ 10,000.00 001.000.62.558.60.23.00 Benefits $ 2,000.00 001.000.64.571.22.11.00 Salaries $ 140,000.00 001.000.64.571.22.23.00 Benefits $ 28,000.00 001.000.65.518.20.11.00 Salaries $ 33,000.00 001.000.65.518.20.23.00 Benefits $ 6,600.00 001.000.67.518.21.11.00 Salaries $ 107,000.00 001.000.67.518.21.23.00 Benefits $ 21,400.00 422.000.72.531.90.11.00 Salaries $ 13,000.00 422.000.72.531.90.23.00 Benefits $ 2,600.00 423.000.76.535.80.11.00 Salaries $ 13,000.00 423.000.76.535.80.23.00 Benefits $ 2,600.00 512.000.31.518.88.11.00 Salaries $ 50,000.00 512.000.31.518.88.23.00 Benefits $ 10,000.00 Total Expenditure Increase (Decrease) $ 1,588,800 $ $ $ S Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 $ $ $ $ S Total Revenue Increase (Decrease) $ $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 Ending Fund Balance $ (1,497,600) $ $ $ $ 422.000.72.508.00.00.00 Ending Fund Balance (15,600) 423.000.75.508.00.00.00 Ending Fund Balance (15,600) 512.000.31.508.00.00.00 Ending Fund Balance (60,000) Total Ending Fund Balance Increase (Decrease) 1 $ (1,588,800) $ I I I S Packet Pg. 33 2.4.a Previously Discussed by Council (April 2023) Budget Amendment for: April 18, 2023 Description: The Stormwater Engineer can normally review the stream of development permits for compliance with the City's stormwater regulations as part of the position's workload. The City's Storm and Surface Water Comprehensive Plan needs to be updated as a companion to the current update to the City's overall Comprehensive Plan. Working on the Storm and Surface Water Comprehensive Plan will take the Stormwater Engineer's time away from reviewing development permits. Outside professional services are required to fill this gap until the Storm and Surface Water Comprehensive Plan is completed. 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) Public Works Stormwater On -Call Professional Services Jerry Shuster Previously Discussed By Council 1st Quarter Budget Amendment Feb 28 2023 100% Ending Fund Balance 94 One -Time Operating Fund F 001 GENERAL Name: Account Number Description 2023 2024 2025 2026 2027 00 1.00.67.518.21.4 1.00 Professional Services $ 125.000 S $ $ $ Total Expenditure Increase(Decrease) $ 125,000 S $ $ $ Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 $ $ $ $ S Total Revenue Increase Decrease $ S $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 Ending Fund Balance $ 125,000 $ $ $ $ Total Ending Fund Balance Increase Decrease $ 125,000 $ 1 1 1$ Packet Pg. 34 2.4.a Previously Discussed by Council (April 2023) Budget Amendment for: April 18, 2023 Item Description: Along with the OpenGov Budget, Reporting and Transparancy implementation, the next step is acquiring remaining ERP system. As discussed at previous Council meetings, a Project Manager is necessary to lead that search. The goal would be for this to be contracted as a professional service for 3 to 6 months. rice contacted three firms and chose to work with Plante Moran, a recognized consulting firm experienced in this work. Budget was approved in 2022, but the project was placed on hold and only $2,120 was spent in 2022. budget amendment would allow us to take the project off hold and begin the implementation. type of Project Manager work they will be doing for us: 1. Develop detailed project plan 2. Establish project collaboration center (e.g. SharePoint) 3. Schedule and moderate status meetings 4. Develop solution criteria and define the decision -making process 5. Conduct additional due diligence activities 6. Review contracts and Statements of Work 7. Assist in transition to implementation Administrative Services Fund 001 GENERAL Name: Budget Amendment Type Previously Discussed By Council Date of Discussion or Budget Approval? Dec. 14, 2021; Jan. 14, 2022; Jan. 25, 2022; April 19, 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? 10perating Expenditure Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 00 1.000. 31.514.23.4 1.00 Professional Services $ 60,000 $ S S $ Total Expenditure Increase (Decrease) $ 60,000 $ S S $ Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 Total Revenue Increase (Decrease) $ $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 Ending Fund Balance $ (60,000) $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ (60,000) $ $ $ $ Packet Pg. 35 2.4.a Previously Discussed by Council (April 2023) Budget Amendment for: April 18, 2023 Item Description: To adjust the Contingency Reserve to the 2023 balance per the Fund Balance Policy, to bring the Contingency Reserve Fund to 4% of the General Fund Adopted Operating Budget. Department: Administrative Services Division: Finance Fund 001 GENERAL Title: Adjustment to Contingency Reserve Name: Preparer: Dave Turley Budget Amendment Type Previously Discussed By Council Please select when the budget was approved Date of approval 12/20/2022 How is this amendment funded? 100% Self Funded What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.597.19.55.12 Interfund Transfer $ 447,522 Total Expenditure Increase (Decrease) $ 447,522 $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 012.000.397.19.001.00 Interfund Transfer $ 447,522 $ - $ - $ - $ - Total Revenue Increase (Decrease) $ 447,522 $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 012.000.39.508.00.00.00 $ 447,522 $ - $ - $ - $ - 001.000.39.508.00.00.00 (447,522) - - - - Total Ending Fund Balance Increase Decrease $ - $ - $ - $ - $ - r c m E c m E Q m m �L Q Q M N O N Packet Pg. 36 New Item for Council to Consider (April 2023) 2.4.a Budget Amendment for: April 18, 2023 Item Description: The Edmonds School District has been running the "Let's Go" Bicycle Education Program since 2015 within the Edmonds Schools (with collaboration from Cascade Bicycle Club, Edmonds Bicycle Club, and City of Edmonds). Previous transportation grant funds secured by the City of Edmonds and from the Verdant Health Commission have made this program possible in past years. The Edmonds School District requested a $15k funding contribution to cover a shortfall to pay for the 2023 program (April through September). The District's program provides for the delivery of bikes and curriculum materials to Edmonds schools, maintenance and repair services for fleets of bikes, in - class teacher support / consultations, and preparation for Fall program. The District has secured a funding source for the vro2ram in the followin ear 2023-2024 school year). Department: Public Works Fund 7 001 GENERAL Name: Division: Engineering Title: Extension of "Let's Go" Bicycle Education Program Preoarer: Bertrand Hauss 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? Operating Expenditure Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.67.518.21.49.00 Miscellaneous $ 15.000 S $ $ $ Total Expenditure Increase(Decrease) $ 15.000 S $ $ $ Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 $ S $ $ S Total Revenue Increase Decrease $ $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 Ending Fund balance $ 15,000 $ $ $ $ Total Ending Fund Balance Increase Decrease $ (15.000)1 S 1 1 1$ Packet Pg. 37 2.4.a New Item for Council to Consider (April 2023) Budget Amendment for: April 18, 2023 Item Description: The Creative District received a grant in spring of 2022 to support design work for capital improvements within the Creative District limits. The grant is to help cover costs for street improvement conceptual design development specific to the 4th Ave Cultural Corridor project. Department: Community Services/Economic Development Fund Name: 001 GENERAL Division: Community Services/Economic Development Title: Creative District Grant for Conceptual Design Preparer: Todd Tatum Budget Amendment Type New Item For Council To Consider Please select when the budget was approved Date of approval Grant Funded How is this amendment funded? Reimbursed by Grants or Outside Agencies What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.61.558.70.41.00 Professional Services $ 34,000 $ $ $ $ Total Expenditure Increase Decrease $ 34,000 1 $ S S S Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.334.05.800.00 WA State Arts Commission $ 34,000 $ $ $ $ Total Revenue Increase Decrease $ 34,000 $ S S S Ending Fund Balance Increase (Decrease) Account Number Descri tion 2023 2024 2025 2026 2027 Total Ending Fund Balance Increase Decrease $ $ $ $ $ Packet Pg. 38 2.4.a New Item for Council to Consider (April 2023) Budget Amendment for: April 18, 2023 Description: This amendment covers the cost to convert the Neighborhood City Hall (NCH) office to comply with police safety protocols in preparation for the hiring of a "storefront officer" as approved in the 2023 budget. These improvements create a secured area for officer/s to work in while at the NCH, and allow for interaction with the public in a variety of formats in the main lobby of the office. These efforts are necessary to staff this office safely and effectively. 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) Services/Economic Community Services Leasehold Improvements to NCH Todd Tatum New Item For Council To Consider 2nd Quarter Budget Amendment 100% Ending Fund Balance 94 One -Time Operating Fund F 001 GENERAL Name: Account Number Description 2023 2024 2025 2026 2027 001.000.60.557.20.48.00 Repair & Maintenance(Remodeling of NCH $ 80,000 $ $ $ $ 001.000.60.557.20.35.00 Small Equipment Furniture 5,000 Total Expenditure Increase(Decrease) $ 85.000 S $ $ $ Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 $ S $ $ S Total Revenue Increase Decrease $ S $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 Ending Fund Balance $ (85.000) S $ $ $ Total Ending Fund Balance Increase Decrease $ (85.000)1 S 1 1 1$ Packet Pg. 39 2.4.a New Item for Council to Consider (April 2023) Budget Amendment for: April 18, 2023 Item Description: The City is in the process of making repairs to the library from water damage that was incurred prior to this year. Nearly all of the rehab costs will ultimately be reimbursed by insurance. Department: Public Works Fund name: IF 001 GENERAL Division: Building Maintenance Title: Repairs to Library Preparer: Budget Amendment Type New Item For Council To Consider Date of Discussion or Budget Approval? How is this amendment funded? Reimbursed by Grants or Outside Agencies What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Capital Exnenditure Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.66.594.19.62.00 Buildings $ 800,000 $ S $ $ Total Expenditure Increase(Decrease) $ 800,000 $ S $ $ Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.395.40.000.00 Insurance Recovery $ 800,000 $ $ $ $ Total Revenue Increase ecrease $ 800,000 $ $ $ $ Endin¢ Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 $ $ $ $ $ Total Ending Fund Balance Increase Decrease $ $ $ $ $ r+ Q Packet Pg. 40 2.4.a New Item for Council to Consider (April 2023) Budget Amendment for: April 18, 2023 Description: The Household Grant program has been the most active of all of the support grant categories established in Edmonds' ARPA ordinances. Annual funds went from $1,000,000 in 2021 and 2022, to $500,000 in 2023, and $420,000 in 2024. Demand for these grants have steadily increased year over year. The entirety of 2023's allocated funds have either been distributed, or are in the process of being awarded as of 3/13/23. Should Council desire to carry on with this grant program beyond April, we will need more funding. We recommend that this funding come from 2024's allocation of $420,000 which was approved by Council with 2023's budget. 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) Services/Economic Services Household Grant fund increase Todd Tatum New Item For Council To Consider 2nd Quarter Budget Amendment Dec 20 2022 Reimbursed by Grants or Outside Agencies One -Time Operating Fund MULTIPLE FUNDS Name: Account Number Description 2023 2024 2025 2026 2027 142.000.39.518.63.41.00 Community Relief Funds $ 420,000 $ $ $ $ Total Expenditure Increase(Decrease) $ 420,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 142.000.333.21.019.00 Coronavirus Relief Fund $ 420,000 $ $ $ $ Total Revenue Increase Decrease $ 420.000 S $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 S $ $ $ Total Ending Fund Balance Increase Decrease $ S $ $ $ Packet Pg. 41 2.4.a New Item for Council to Consider (April 2023) Budget Amendment for: April 18, 2023 Item Description: Addition of one Full Time Employee (FTE) - This new Fleet Mechanic position will provide much needed support to the Fleet Department to account for the significant growth occuring in 2023. By providing an additional FTE the Fleet department would become more resilient and benefit most departments throughout the city. The Fleet Department will be able to provide improved emergency response support, emergency vehicle support, reduced shop time on repairs and maintenance, and reduce the need for outsourced labor. As with all Fleet positions, the departments that benefit from the service vay for it throu h rates. Department: Public Works Fund 511 EQUIPMENT Name: RENTAL Division: Fleet Title: Add new Fleet Mechanic position Preparers 1 Carl Rugg Budget Amendment Type New Item For oun Please select when the budget was approved Date of approval How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? On -Going Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) ' Fill out on -going costs & revenues Account Number Description 2023 2024 2025 2026 2027 511.000.77.548.68.11.00 Salaries $ 86,556 $ 90,884 $ 95,428 $ 100,199 $ 105,209 511.000.77.548.68.23.00 Benefits 30,000 $ 31,500 $ 33,075 $ 34,729 $ 36,465 Total Expenditure Increase Decrease $ 116,556 $ 122,384 $ 128,503 $ 134,928 $ 141,675 Revenue Increase (Decrease) Account Number Description 2023 2024 202.5 2026 2027 Total Revenue Increase Decrease $ - - $ - $ - - Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 511.000.77.508.00.00.00 Ending Fund Balance $ 116,556 $ 122,384 $ 128,503 $ 134,928 $ 141,675 Total Ending Fund Balance Increase Decrease $ 116,556 $ 122,384 $ 128,503 $ 134,928 $ 141,675 10 Packet Pg. 42 2.4.a New Item for Council to Consider (April 2023) Budget Amendment for: First Quarter Item Description: To adjust for the Teamsters contract wages and benefits increases approved by Council in January of 2023. Department: Administrative Services Fund Name: MULTIPLE FUNDS Division: Finance Title: Adjust for Salary Increases Preparers iMarissa Cain Budget Amendment Type New Item For Council To Consider Please select when the budget was approved Date of approval January 2023 How is this amendment funded? 100% Self Funded What is the nature of the expenditure? On -Going Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Fill out on going costs & revenues Account Number Description 2023 2024 2025 2026 2027 001.000.64.576.80.11.00 Salaries $ 264,000 $ 264,000 $ 264,000 $ 264,000 $ 264,000 001.000.64.576.80.23.00 Benefits 52,800 52,800 52,800 52,800 52,800 001.000.66.518.30.11.00 Salaries 170,000 170,000 170,000 170,000 170,000 001.000.66.518.30.23.00 Benefits 34,000 34,000 34,000 34,000 34,000 422.000.72.531.70.11.00 Salaries 151,000 151,000 151,000 151,000 151,000 422.000.72.531.70.23.00 Benefits 30,200 30,200 30,200 30,200 30,200 111.000.68.542.60.11.00 Salaries 182,000 182,000 182,000 182,000 182,000 111.000.68.542.60.23.00 Benefits 36,400 36,400 36,400 36,400 36,400 421.000.74.534.80.11.00 Salaries 134,000 134,000 134,000 134,000 134,000 421.000.74.534.80.23.00 Benefits 26,800 26,800 26,800 26,800 26,800 423.000.75.535.80.11.00 Salaries 142,000 142,000 142,000 142,000 142,000 423.000.75.535.80.23.00 Benefits 28,400 28,400 28,400 28,400 28,400 423.000.76.535.80.11.00 Salaries 183,000 183,000 183,000 183,000 183,000 423.000.76.535.80.23.00 Benefits 36,600 36,600 36,600 36,600 36,600 511.000.77.548.68.11.00 Salaries 39,000 39,000 39,000 39,000 39,000 511.000.77.548.68.23.00 Benefits 7,800 7,800 7,800 7,800 7,800 Total Expenditure Increase Decrease $1,518,000 $1,518,000 $1,518,000 $1,518,000 $1,518,000 Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 $ $ S $ S Total Revenue Increase Decrease $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 Ending Fund Balance $ 520,800 $ 520,800 $ 520,800 $ 520,800 $ 520,800 111.000.68.508.30.00.00 Ending Fund Balance 218,400 218,400 218,400 218,400 218,400 421.000.74.508.00.00.00 Ending Fund Balance 160,800 160,800 160,800 160,800 160,800 422.000.72.508.00.00.00 Ending Fund Balance 181,200 181,200 181,200 181,200 181,200 423.000.75.508.00.00.00 Endin Fund Balance 390,000 390,000 390,000 390,000 390,000 511.000.77.508.00.00.00 1 Ending Fund Balance 46,800 46,800 46,800 46,800 46,800 Total Ending Fund Balance Increase Decrease ######### ######### ######### ######### ######### 11 Packet Pg. 43 New Item for Council to Consider (April 2023) 2.4.a Budget Amendment for: First Quarter Item Description: To adjust for the non -represented salary and benefits increases approved by Council in December of 2022. Department: Administrative Services Division: Finance Fund MULTIPLE FUNDS Title: Adjust for Salary Increases Name: Preparer: Marisa Cain Budget Amendment Type New Item For Council To Consider Please select when the budget was approved Date of approval How is this amendment funded? 100% Ending Fund Balance What is the nature ofthe expenditure? On -Going Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Fill out on going costs & revenues Account Number Description 2023 2024 2025 2026 2027 001.000. 11.511.60.11.00 Salaries $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 001.000.21.513. 10.11.00 Salaries 8,000 8,000 8,000 8,000 8,000 001.000.22.518. 10.11.00 Salaries 35,000 35,000 35,000 35,000 35,000 001.000.23.512.51.11.00 Salaries 17,000 17,000 17,000 17,000 17,000 001.000.31.514.20.11.00 Salaries 13,000 13,000 13,000 13,000 13,000 001.000.31.514.23.11.00 Salaries 10,000 10,000 10,000 10,000 10,000 001.000.31.514.31.11.00 Salaries 10,000 10,000 10,000 10,000 10,000 001.000.41.521.10.11.00 Salaries 10,000 10,000 10,000 10,000 10,000 001.000.61.557.20.11.00 Salaries 5,000 5,000 5,000 5,000 5,000 001.000.61.573.90.11.00 Salaries 4,000 4,000 4,000 4,000 4,000 001.000.62.524.10.11.00 Salaries 13,000 13,000 13,000 13,000 13,000 001.000.62.524.20.11.00 Salaries 18,000 18,000 18,000 18,000 18,000 001.000.62.558.60.11.00 Salaries 61,000 61,000 61,000 61,000 61,000 001.000.64.571.21.11.00 Salaries 13,000 13,000 13,000 13,000 13,000 001.000.64.571.22.11.00 Salaries 30,000 30,000 30,000 30,000 30,000 001.000.64.576.80.11.00 Salaries 12,000 12,000 12,000 12,000 12,000 001.000.65.518.20.11.00 Salaries 4,000 4,000 4,000 4,000 4,000 001.000.66.518.30.11.00 Salaries 12,000 12,000 12,000 12,000 12,000 001.000.67.518.21.11.00 Salaries 94,000 94,000 94,000 94,000 94,000 111.000.68.542.31.11.00 Salaries 1,000 1,000 1,000 1,000 1,000 111.000.68.542.90.11.00 Salaries 6,000 6,000 6,000 6,000 6,000 421.000.74.534.80.11.00 Salaries 11,000 11,000 11,000 11,000 11,000 422.000.72.531.90.11.00 Salaries 6,000 6,000 6,000 6,000 6,000 423.000.76.535.80.11.00 Salaries 30,000 30,000 30,000 30,000 30,000 511.000.77.548.68.11.00 Salaries 13,000 13,000 13,000 13,000 13,000 512.000.31.518.88.11.00 Salaries 7,000 7,000 7,000 7,000 7,000 001.000. 11.511.60.23.00 Benefits 1,000 1,000 1,000 1,000 1,000 001.000.21.513.10.23.00 Benefits 1,600 1,600 1,600 1,600 1,600 001.000.22.518.10.23.00 Benefits 7,000 7,000 7,000 7,000 7,000 001.000.23.512.51.23.00 Benefits 3,400 3,400 3,400 3,400 3,400 001.000.31.514.20.23.00 Benefits 6,600 6,600 6,600 6,600 6,600 512.000.31.518.88.23.00 Benefits 1,400 1,400 1,400 1,400 1,400 001.000.41.521.10.23.00 Benefits 2,000 2,000 2,000 2,000 2,000 001.000.61.557.20.23.00 Benefits 1,800 1,800 1,800 1,800 1,800 001.000.62.524.10.23.00 Benefits 18,400 18,400 18,400 18,400 18,400 001.000.64.571.21.23.00 Benefits 11,000 11,000 11,000 11,000 11,000 001.000.65.518.20.23.00 Benefits 800 800 800 800 800 001.000.66.518.30.23.00 Benefits 2,400 2,400 2,400 2,400 2,400 001.000.67.518.21.23.00 Benefits 18,800 18,800 18,800 18,800 18,800 111.000.68.542.31.23.00 Benefits 1,400 1,400 1,400 1,400 1,400 422.000.72.531.90.23.00 Benefits 1,200 1,200 1,200 1,200 1,200 421.000.74.534.80.23.00 Benefits 2,200 2,200 2,200 2,200 2,200 423.000.76.535.80.23.00 Benefits 6,000 6,000 6,000 6,000 6,000 511.000.77.548.68.23.00 Benefits 2,600 2,600 2,600 2,600 2,600 Total Expenditure Increase (Decrease) $ 537,600 1 $ 537,600 i $ 537,600 $ 537,600 $ 537,600 Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 $ $ $ $ $ Total Revenue Increase (Decrease) $ - $ - $ - $ - $ Beginning Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 $ (448,800) $ (448,800) $ (448,800) $ (448,800) $ (448,800) 111.000.68.508.30.00.00 (8,400) (8,400) (8,400) (8,400) (8,400) 421.000.74.508.00.00.00 (13,200) (13,200) (13,200) (13,200) (13,200) 422.000.72.508.00.00.00 (7,200) (7,200) (7,200) (7,200) (7,200) 423.000.75.508.00.00.00 (36,000) (36,000) (36,000) (36,000) (36,000) 511.000.77.508.00.00.00 (15,600) (15,600) (15,600) (15,600) (15,600) 512.000.31.508.00.00.00 (8,400) (8,400) (8,400) (8,400) (8,400) Total Ending Fund Balance Increase (Decrease) $ (537,600) $ (537,600) $ (537,600) $ (537,600) $ (537,600) 12 Packet Pg. 44 2.4.a New Item for Council to Consider (April 2023) Budget Amendment for: April 18, 2023 Item Description: The Washington Cities Insurance Authority (WCIA) provided the City with a preliminary estimate of what the assessment would be for the 2023 fiscal year, which we included in the 2023 proposed budget. The actual assessment that we received in January was higher. This budget amendment is to increase the city budget for the updated WCIA assessment. Department: Administrative Services Division: Finance Fund r 01 GENERAL Title: Adjustment for WCIA Insurance Increase Name: Preparer: Dave Turley Budget Amendment Type New Item For Council To Consider Please select when the budget was approved Date of approval How is this amendment funded? 100% Self Funded What is the nature of the expenditure? On -Going Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Fill out on going costs & revenues Account Number Description 2023 2024 2025 2026 2027 001.000.39.518.90.46.00 WCIA Insurance Allocation $ 27,928 $ 27,928 $ 27,928 $ 27,928 $ 27,928 111.000.68.542.90.46.00 WCIA Insurance Allocation 5,645 5,645 5,645 5,645 5,645 421.000.74.534.80.46.00 WCIA Insurance Allocation 10,061 10,061 10,061 10,061 10,061 422.000.72.531.90.46.00 WCIA Insurance Allocation 1,414 1,414 1,414 1,414 1,414 423.000.75.535.80.46.00 WCIA Insurance Allocation 3,718 3,718 3,718 3,718 3,718 423.000.76.535.80.46.00 WCIA Insurance Allocation 12,381 12,381 12,381 12,381 12,381 511.000.77.548.68.46.00 WCIA Insurance Allocation 2,240 2,240 2,240 2,240 2,240 Total Expenditure Increase Decrease $ 63,387 $ 63,387 $ 63,387 $ 63,387 $ 63,387 Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 Total Revenue Increase Decrease $ - $ $ - $ - $ - Beginning Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 001.000.39.508.00.00.00 Ending Fund Balance $ 27,928 $ 27,928 $ 27,928 $ 27,928 $ 27,928 111.000.68.508.30.00.00 Ending Fund Balance 5,645 5,645 5,645 5,645 5,645 421.000.74.508.00.00.00 Ending Fund Balance 10,061 10,061 10,061 10,061 10,061 422.000.72.508.00.00.00 Ending Fund Balance 1,414 1,414 1,414 1,414 1,414 423.000.75.508.00.00.00 Ending Fund Balance 16,099 16,099 16,099 16,099 16,099 511.000.77.508.00.00.00 Ending Fund Balance 2,240 2,240 2,240 2,240 2,240 Total Ending Fund Balance Increase Decrease $ 63,387 $ 63,387 $ 63,387 $ 63,387 $ 63,387 13 Packet Pg. 45 2.4.a Previously Approved Budget by Council (April 2023) Budget Amendment for: April 18, 2023 Item Description: Full width grind and pavement overlay of 76th Ave from 196th St. SW(SR 524) to Olympic View Dr. This project also includes upgrading all non compliant ADA pedestrian curb ramps within the project limits. The east side of the street is within the City of Lynnwood and is included in the project. Construction work began in fall 2022 and was suspended for weather before the project was completed. The contractor will resume work in April 2023 to complete the paving work and pavement striping/markings. Department: Public Works Fund Name: MULTIPLE FUNDS Division: Engineering Title: 76th Ave Overlay (196th St SW to Olympic View Drive) Preparer: Ryan Hague Budget Amendment Type Previously Approved Budget By Council 1st Quarter Budget Amendment Date of Discussion or Budget Approval? Jul 26 2022 How is this amendment funded? Reimbursed by Grants or Outside Agencies What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 112.000.68.542.30.41.00 Professional Services -Roadway $ 88,585 $ $ $ $ 112.000.68.542.30.48.00 Repair & Maintenance -Roadway 1,139,535 112.000.68.542.33.41.67 Interfund Services -Roadway 54,615 126.000.68.542.30.41.00 Professional Services -Roadway 2,535 126.000.68.542.30.48.00 Repair & Maintenance -Overlays 27,540 126.000.68.542.30.41.67 Interfund Services -Roadway 1,625 125.000.68.542.30.41.00 Professional Services -Roadway 18,310 125.000.68.542.30.48.00 Repair & Maintenance Overlays 222,610 125.000.68.542.30.41.67 Interfund Services -Roadway 11,600 001.000.39.597.42.55.12 Interfund Transfer to Fund 112 31,460 Total Expenditure Increase Decrease $ 1,598,415 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 112.000.334.03.800.05 STPUL-2511(005) $ 466,375 $ $ $ $ 112.000.337.10.000.00 Interlocal Grants 784,900 112.000.397.95.001.00 Interfund Transfer -In From 001 31,460 Total Revenue Increase Decrease $ 1,282,735 $ $ $ S Ending Fund Balance Increase (Decrease) Account Number Description 2023 2024 2025 2026 2027 125.000.64.508.30.00.00 Ending Fund Balance $ 252,520 $ $ $ $ 126.000.64.508.30.00.00 Ending Fund Balance 31,700 001.000.39.508.00.00.00 Ending Fund Balance 31,460 Total Ending Fund Balance Increase Decrease $ 315,680 $ I S $ S 14 Packet Pg. 46 2.4.b ORDINANCE NO. AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4297 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 2023 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. 4297 adopting the final budget for the fiscal year 2023 is hereby amended to reflect the changes shown in Exhibits A, B, C, and D adopted herein by reference. 1 Packet Pg. 47 2.4.b 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 NELSON 2 Packet Pg. 48 2.4.b SUMMARY OF ORDINANCE NO. of the City of Edmonds, Washington On the th day of April, 2023, 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. 4297 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 , 2023. CITY CLERK, SCOTT PASSEY 3 Packet Pg. 49 2.4.b EXHIBIT "A": Budget Amendment Summary (April 2023) FUND NO. FUND DESCRIPTION 2023 BEGINNING FUND BALANCE REVENUE EXPENDITURES 2023 ENDING FUND BALANCE 001 GENERAL FUND 16,714,223 51,186,745 61,780,797 6,120,171 009 LEOFF-MEDICAL INS. RESERVE 194,409 225,000 367,140 52,269 011 RISK MANAGEMENT RESERVE FUND 25,000 - 25,000 - 012 CONTINGENCY RESERVE FUND 1,782,150 447,522 - 2,229,672 014 HISTORIC PRESERVATION GIFT FUND 10,522 - 5,900 4,622 016 BUILDING MAINTENANCE 3,739,645 17,480 1,275,000 2,482,125 017 MARSH RESTORATION & PRESERVATION FUND 848,617 - - 848,617 018 EDMONDS HOMELESSNESS RESPONSE FUND - - 019 EDMONDS OPIOID RESPONSE FUND - - - - 104 DRUG ENFORCEMENTFUND 196,584 167,650 45,800 318,434 111 STREET FUND 547,114 1,815,410 2,583,414 (220,890) 112 COMBINED STREET CONST/I MP ROVE 2,669,390 12,366,800 11,273,695 3,762,495 117 MUNICIPAL ARTSACQUIS. FUND 705,480 98,098 207,380 596,198 120 HOTEL/MOTEL TAX REVENUE FUND 54,624 84,400 95,400 43,624 121 EMPLOYEE PARKING PERMIT FUND 76,184 38,960 26,880 88,264 122 YOUTH SCHOLARSHIP FUND 12,808 1,660 3,000 11,468 123 TOURISM PROMOTIONAL FUND/ARTS 97,362 30,440 28,500 99,302 125 PARK ACQ/IMPROVEMENT 3,513,005 2,320,090 4,315,418 1,517,677 126 SPECIAL CAPITAL FUND 3,771,542 2,302,980 1,800,512 4,274,010 127 G I FTS CATALOG F U N D 3,176,109 135,340 497,598 2,813,851 130 C E M ETE RY MAI NTENAN C E/I M P ROV 267,890 150,960 249,413 169,437 136 PARKS TRUST FUND 166,760 5,460 43,842 128,378 137 CEMETERY MAINTENANCETRUST FD 1,175,601 51,500 50,000 1,177,101 138 SISTER CITY COMMISSION 13,869 10,430 11,900 12,399 140 BUSINESS IMPROVEMENT DISTRICT FUND 20,801 88,645 88,575 20,871 141 AFFORDABLE & SUPPORTIVE HOUSING FUND 224,414 65,000 - 289,414 142 EDMONDS RESCUE PLAN FUND 44,888 1,669,000 1,669,000 44,888 143 TREE FUND 236,162 215,100 239,800 211,462 211 LID FUND CONTROL - - - - 231 2012 LTGO DEBTSERVICE FUND - 309,800 309,800 - 332 PARKS CONSTRUCTION 322,129 2,713,902 2,255,647 780,384 421 WATER 30,924,419 11,950,114 11,819,111 31,055,422 422 STORM 15,101,336 9,020,452 8,292,377 15,829,411 423 SEWER/TREATMENT PLANT 57,120,908 15,898,844 16,488,945 56,530,807 424 BOND RESERVE FUND 843,951 1,991,860 1,989,820 845,991 511 EQUIPMENT RENTAL FUND 9,730,472 4,188,740 4,548,414 9,370,798 512 Technology Renta I Fund 693,587 1,481,194 1,753,427 421,354 Totals 155,021,955 121,049,576 134,141,505 141,930,026 �L sZ Q M N O N C N E t U M r Q Packet Pg. 50 EXHIBIT "B": Budget Amendments by Revenue (April 2023) 2.4.b FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4289 1/1/2023 Adopted Amendment Ord. # 3/2/2023 Proposed Amendment Ord. # 2023 Amended Revenue Budget 001 General Fund $ 49,991,791 $ 360,954 $ 834,000 $ 51,186,745 009 Leoff-MedlcalIns. Reserve 225,000 - - 225,000 011 Risk Management Reserve Fund - - - 012 Contingency Reserve Fund 447,522 447,522 014 Historic Preservation Gift Fund - - - 016 Building Maintenance Fund 17,480 17,480 017 Marsh Restoration & Preservation Fund - - 018 Edmonds Homelessness Response Fund 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 167,650 167,650 111 Street Fund 1,815,410 - 1,815,410 112 Combined Street Const/Improve 8,308,065 2,776,000 1,282,735 12,366,800 117 Municipal Arts Acquis. Fund 98,098 - - 98,098 118 Memorial Street Tree - - 120 Hotel/Motel Tax Revenue Fund 84,400 84,400 121 Employee Parking Permit Fund 38,960 38,960 122 Youth Scholarship Fund 1,660 1,660 123 Tourism Promotional Fund/Arts 30,440 30,440 125 ParkAcq/Improvement 2,320,090 2,320,090 126 Special Capital Fund 2,302,980 2,302,980 127 Gifts Catalog Fund 135,340 135,340 130 Cemetery Maintenance/Improv 150,960 150,960 136 Parks Trust Fund 5,460 5,460 137 Cemetery Maintenance Trust I'd 51,500 51,500 138 Sister City Commission 10,430 10,430 140 Business Improvement District Fund 88,645 88,645 141 Affordable and Supportive Housing Fund 65,000 - 65,000 142 Edmonds Rescue Plan Fund 1,249,000 420,000 1,669,000 143 Tree Fund 215,100 - 215,100 211 Lid Fund Control - - 231 2012 LTGO Debt Service fund 309,800 309,800 332 Parks Construction 927,205 1,786,697 2,713,902 421 Water 11,950,114 - 11,950,114 422 Storm 8,903,407 117,045 9,020,452 423 Sewer/Treatment Plant 15,898,844 - 15,898,844 424 Bond Reserve Fund 1,991,860 1,991,860 511 Equipment Rental Fund 4,188,740 - 4,188,740 512 Technology Renta I Fund 1,413,372 67,822 1,481,194 617 Firemen's Pension Fund - - - - Totals $ 112,956,801 $ 5,108,518 $ 2,984,257 $ 121,049,576 �L Q C7 CV CD CV C W E t U M r Q Packet Pg. 51 EXHIBIT "C: Budget Amendment by Expenditure (April 2023) 2.4.b FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4289 1/1/2023 Adopted Amendment Ord. # 3/2/2023 Proposed Amendment Ord. # 2023 Amended Expenditure Budget 001 General Fund $ 55,716,788 $ 1,970,899 $ 4,093,110 $ 61,780,797 009 Leoff-Medical Ins. Reserve 367,140 - - 367,140 011 Risk Management Reserve Fund 25,000 25,000 012 Contingency Reserve Fund - - 014 Historic Preservation Gift Fund 5,900 - 5,900 016 Building Maintenance Fund 1,215,000 60,000 1,275,000 017 Marsh Restoration & Preservation Fund - - - 018 Edmonds Homelessness Response Fund 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 45,800 45,800 111 Street Fund 2,350,969 - 232,445 2,583,414 112 Combined Street Const/Improve 7,214,960 2,776,000 1,282,735 11,273,695 117 Municipal Arts Acquis. Fund 182,880 24,500 - 207,380 118 Memorial Street Tree - - - 120 Hotel/Motel Tax Revenue Fund 95,400 95,400 121 Employee Parking Permit Fund 26,880 26,880 122 Youth Scholarship Fund 3,000 3,000 123 Tourism Promotional Fund/Arts 28,500 - - 28,500 125 ParkAcq/Improvement 2,473,362 1,589,536 252,520 4,315,418 126 Special Capital Fund 1,631,812 137,000 31,700 1,800,512 127 Gifts Catalog Fund 497,598 - - 497,598 130 Cemetery Maintenance/Improv 249,413 - 249,413 136 Parks Trust Fund - 43,842 43,842 137 Cemetery Maintenance TrustFd 25,000 25,000 50,000 138 Sister City Commission 11,900 - 11,900 140 Business Improvement District Fund 88,575 88,575 141 Affordable and Supportive Housing Fund - - - 142 Edmonds Rescue Plan Fund 1,249,000 420,000 1,669,000 143 Tree Fund 239,800 - 239,800 211 Lid Fund Control - - 231 2012LTGO Debt Service Fund 309,800 309,800 332 Parks Construction 468,950 1,786,697 - 2,255,647 421 Water 11,335,050 300,000 184,061 11,819,111 422 Storm 7,603,123 483,840 205,414 8,292,377 423 Sewer/Treatment Plant 15,381,246 650,000 457,699 16,488,945 424 Bond Reserve Fund 1,989,820 - - 1,989,820 511 Equipment Rental Fund 3,695,807 671,411 181,196 4,548,414 512 Technology Renta I Fund 1,617,205 67,822 68,400 1,753,427 617 Firemen'S Pension Fund - Totals $116,145,678 1 $ 10,586,547 1 $ 7,409,280 1 $ 134,141,505 �L Q Q C7 CV CD CV C W E t v M r .r Q Packet Pg. 52 EXHIBIT "D": Budget Amendment Summary (April 2023) 2.4.b Fund Number Proposed Amendment Change in Revenue Proposed Amendment Change in Expense Proposed Amendment Change in Ending Fund Balance 001 834,000 4,093,110 (3,259,110) 012 447,522 - 447,522 111 232,445 (232,445) 112 1,282,735 1,282,735 125 - 252,520 (252,520) 126 - 31,700 (31,700) 142 420,000 420,000 421 - 184,061 (184,061) 422 205,414 (205,414) 423 457,699 (457,699) 511 181,196 (181,196) 512 - 68,400 (68,400) Total Change 2,984,257 7,409,280 (4,425,023) �L Q Q M N O N C N E t V ra r Q Packet Pg. 53 2.5 City Council Agenda Item Meeting Date: 04/11/2023 February 2023 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Move to full council to be received for filing. Narrative February 2023 Monthly Financial Report Attachments: February 2023 Monthly Financial Report Packet Pg. 54 I 2.5.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT FEBRUARY 2023 Packet Pg. 55 1 I 2.5.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of February 28, 2023 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate r- FHLMC Bonds 988,678 0.14 1,000,000 993,867 04/20/23 0.38% 0 !Z FHLB Bonds 1,996,590 0.60 2,000,000 1,940,306 10/05/23 0.22% 0) Kent WA Bonds 286,648 0.76 250,000 253,368 12/01/23 5.00% First Financial - ECA CD 2,803,516 0.83 2,803,516 2,803,516 12/28/23 2.08% First Financial - Waterfront Center CD 245,000 0.83 245,000 245,000 12/28/23 1.49% M FHLB Bonds 2,004,464 0.88 2,000,000 1,995,424 01/16/24 4.81% LL FHLB Bonds 954,866 1.12 1,000,000 946,682 04/10/24 0.35% 21 FM Bonds 996,082 1.30 1,000,000 970,143 06/17/24 2.80% +' C FNMA Bonds 992,693 1.34 1,000,000 956,314 07/02/24 1.75% FHLB Bonds 950,774 1.72 1,000,000 930,953 11/18/24 0.90% N Spokane County WA Bonds 207,260 1.76 200,000 190,366 12/01/24 2.10% N FHLMC Bonds 974,798 2.04 1,000,000 975,821 03/13/25 3.75% �+ FHLB Bonds 969,524 2.41 1,000,000 970,865 07/28/25 3.60% 3 US Treas u ry Note Note 964,597 2.46 1,000,000 965,352 08/15/25 3.13% L TOTAL SECURITIES 15,335,490 1.30 15,498,516 15,137,977 Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO Issuer Diversification Kent WA,- 2% FHLMC, First 13% Financial - CD, 20% Spokane County WA, 1% FHLB, 45% 12,049,613 12,049,613 Demand 4.61% 43,272,667 43,272,667 Demand 2.11% $ 70,820,796 $ 70,460,257 Cash and Investment Balances Checki ng, (in $ Millions) —$4.0 , 6% Note, 1.0 , 1% Bonds, 11.5 , 15% State LGI P, CD's, 3.0 , 12.0 , 16% 4% County LGIP, 43.3 ,58% 1 Packet Pg. 56 1 I 2.5.a I INVESTMENT PORTFOLIO SUMMARY $1,400, 000 $1,200, 000 $1,000, 000 $800,000 $600,000 $400,000 $200,000 Annual Interest Income 2 Packet Pg. 57 2.5.a GENERAL FUND SUMMARY General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenues General Fund Expenses 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 March June September December March June September December General Fund Tax Revenue (2017 through 2022 Sales Tax Property Tax EMS Tax Other Taxes 12,000,000 10,000,000 8,000,000 - — 6,000, 000 4,000, 000 2,000, 000 2017 2018 2019 2020 2021 2022 2,500,000 2,000, 000 1,500,000 1,000,000 500,000 General Fund Tax Revenue (2023 YTD) 32 $1,546,237 $147,332 $59,032 Sales Tax Property Tax EMS Tax Other Taxes 3 I Packet Pg. 58 I 2.5.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2023 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,696,849 $ 2,696,849 $ 2,320,252-13.96% February 5,345,537 2,648,687 4,920,100 -7.96% March 8,048,808 2,703,271 April 11,388,677 3,339,869 May 21,289,904 9,901,228 June 24,179,018 2,889,114 July 26,991,231 2,812,213 August 30,206,838 3,215,607 September 32,856,122 2,649,283 October 37,216,328 4,360,206 November 46,880,651 9,664,323 December 49,991,791 3,111,140 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 Variance Actuals January $ 342,055 $ 342,055 $ 151,084-55.83% February 560,818 218,763 270,799-51.71% March 909,543 348,725 April 1,192,058 282,515 May 1,541,969 349,911 June 1,918,974 377,006 July 2,301,683 382,709 August 2,708,930 407,246 September 3,135,518 426,588 October 3,524,452 388,935 November 3,913,570 389,117 December 4,400,000 486,430 *The monthly budget forecast columns are based on a five-year average. F O IZ C M a LL t r C O r- M tV O tV M 7 L d w Packet Pg. 59 1 SALES TAX SUMMARY I 2.5.a I Sales Tax Analysis By Category Current Period: February 2023 Year -to -Date Total $1,908,832 Automotive Repair, $39,720 Amusement Construction Trade, $283,362 Health & & Recreation, Personal Care, $1 Business Services, Gasoline, $0 I,783 $13,089 $208,392 Retail Food Stores, Accommodation, $6,800 $65,193 Clothing and Accessories, CornnW4Mons, Retail Automotive, $447,288 $42,761 Misc Retail, $407,283 Wholesale Trade, $55,260 -.A Manufacturing, $22,655 Others, $32,653 Eating & Drinking, $207,306 12,000,000 10,000, 000 $7,395,114 $8,406,296 8,000,000 6,000,000 4,000,000 2,000,000 0 Annual Sales Tax Revenue $10,302,518 715 $8,317,046 2017 2018 2019 $1,908,832 2020 2021 2022 YTD 2023 F 0 CL 0 z c 0 a Cl) N O N M d 5 I Packet Pg. 60 I 2.5.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 April 3,643,225 788,366 May 4,624,484 981,259 June 5,567,972 943,488 July 6,580,085 1,012,114 August 7,669,335 1,089,249 September 8,683,583 1,014,248 October 9,768,647 1,085,064 November 10,864,900 1,096,253 December 11,900,000 1,035,100 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 Year 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 April 912,236 537,182 May 5,909,096 4,996,860 June 6,029,957 120,861 July 6,148,773 118,816 August 6,198,768 49,995 September 6,260,415 61,647 October 6,466,132 205,717 November 11,227,156 4,761,024 December 11,327,000 99,844 Real PersonaMoperty 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 Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 6 Packet Pg. 61 I 2.5.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 April 288,835 56,728 May 373,578 84,744 June 439,121 65,542 July 541,031 101,910 August 629,368 88,337 September 748,356 118,987 October 835,253 86,898 November 933,046 97,793 December 993,712 60,666 Sewer Utility Tax 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 --6--- Current Yeaz Budget � Prior Year City of Edmonds, WA Monthly Revenue Summary -Sewer Utility Tax 2023 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 April 348,626 78,972 May 444,771 96,145 June 523,850 79,080 July 620,193 96,343 August 699,682 79,489 September 799,189 99,507 October 879,620 80,432 November 976,901 97,281 December 1,055,821 78,920 Sewer Utility Tax 1,zuu,uuV 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 Yeaz Budget -d-- Prior Year *The monthly budget forecast columns are based on a five-year average. O CL O C M a LL t r C O Cl) 04 O N M 7 L d Packet Pg. 62 I 2.5.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2023 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Variance 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 April 3,010,919 591,341 May 3,894,276 883,356 June 4,577,455 683,180 July 5,644,291 1,066,835 August 6,565,058 920,767 September 7,805,695 1,240,637 October 8,711,524 905,829 November 9,730,927 1,019,403 December 10,363,937 633,010 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2023 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 484,003 $ 484,003 $ 417,703-13.70% February 1,535,452 1,051,449 1,359,827-11.44% March 2,020,122 484,671 April 2,451,545 431,422 May 2,936,868 485,323 June 3,368,111 431,243 July 3,844,019 475,908 August 4,895,662 1,051,643 September 5,380,996 485,335 October 5,812,621 431,625 November 6,298,011 485,390 December 6,714,303 416,292 Storm Water Sales 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 ter- Prior Year *The monthly budget forecast columns are based on a five-year average. F O CL C M a LL t r C O a Cl) tV O tV M 7 L d Packet Pg. 63 I 2.5.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter SewerSales 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 April 3,484,346 788,849 May 4,445,696 961,351 June 5,235,623 789,927 July 6,198,081 962,458 August 6,992,099 794,018 September 7,987,044 994,945 October 8,790,485 803,441 November 9,763,192 972,707 December 10,551,011 787,819 Unmeter Sewer Sales l l ,uuu,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 Yeaz Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 64 ■ 2.5.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2023 General Fund Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals % January $ 5,345,601 $ 5,345,601 $ 4,868,760 -8.92% February 9,636,447 4,290,846 10,063,682 4.43% March 13,866,570 4,230,123 April 17,927,116 4,060,546 May 22,306,491 4,379,376 June 27,357,453 5,050,962 July 31,669,543 4,312,089 August 35,821,515 4,151,973 September 40,439,344 4,617,829 October 45,020,833 4,581,489 November 50,135,899 5,115,066 December 55,716,788 5,580,889 Non -Departmental General Fund 60,000,000 55,000,000 50,000,000 45,000,000 40,000,000 35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,000 OI JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget Prior Year City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2023 Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals % January $ 2,219,693 $ 2,219,693 $ 1,642,894-25.99% February 3,383,447 1,163,755 3,380,586 -0.08% March 4,450,950 1,067,502 April 5,373,248 922,298 May 6,528,731 1,155,483 June 8,240,442 1,711,711 July 9,257,316 1,016,874 August 10,128,621 871,305 September 11,305,253 1,176,632 October 12,392,700 1,087,447 November 13,735,570 1,342,870 December 15,180,425 1,444,855 *The monthly budget forecast columns are based on a five-year average. O CL O 2 U C M a M 21 t r C O Cl) N O N M 7 L d 10 Packet Pg. 65 I 2.5.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,168 $ 31,168 $ 33,649 7.96% February 64,726 33,558 71,252 10.08% March 102,768 38,042 April 139,148 36,380 May 185,610 46,462 June 234,717 49,107 July 271,512 36,795 August 321,665 50,154 September 360,348 38,683 October 393,400 33,052 November 434,929 41,529 December 480,256 45,327 Office of Mayor City CouncH 500,000 450,000 400,000 350,000 300,000 250,000 200,000 - 150,000 100,000 50,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2023 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 40,530 $ 40,530 $ 32,343 -20.20% February 82,920 42,390 63,133 -23.86% March 123,864 40,944 April 165,624 41,760 May 206,480 40,855 June 246,845 40,365 July 288,014 41,169 August 328,829 40,815 September 369,857 41,028 October 410,050 40,193 November 452,572 42,522 December 495,273 42,701 Office of Mayor 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 - 50,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -"-Current Year Budget �PriorYear *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 66 I 2.5.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2023 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 111,879 $ 111,879 $ 93,116-16.77% February 212,590 100,710 164,590-22.58% March 304,874 92,285 April 402,099 97,225 May 499,035 96,936 June 630,337 131,302 July 716,800 86,464 August 811,438 94,638 September 913,015 101,577 October 1,008,222 95,207 November 1,118,413 110,191 December 1,254,947 136,534 Human Resources 1,SUU,000 .00 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 -Municipal Court 2023 Municipal Court Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 107,783 $ 107,783 $ 114,975 6.67% February 217,016 109,233 231,321 6.59% March 329,502 112,486 April 443,331 113,829 May 565,420 122,088 June 677,638 112,218 July 792,551 114,913 August 920,812 128,261 September 1,038,313 117,501 October 1,160,412 122,099 November 1,306,850 146,438 December 1,451,763 144,913 *The monthly budget forecast columns are based on a five-year average. O >Z N R U C C LL _A t Y C O 2 M N O N fC 3 L O 12 Packet Pg. 67 I 2.5.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 $ 69,708 $ 69,708 $ 84,200 20.79% February 146,333 76,625 172,586 17.94% March 225,121 78,788 April 300,489 75,367 May 378,449 77,960 June 457,768 79,319 July 540,740 82,972 August 639,556 98,816 September 731,932 92,376 October 828,147 96,215 November 951,613 123,466 December 1,105,451 153,838 *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 68 I 2.5.a I City of Edmonds, 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 $ 200,229 $ 200,229 $ 355,645 77.62% February 331,818 131,590 530,347 59.83% March 511,956 180,138 April 583,801 71,845 May 686,199 102,398 June 802,985 116,786 July 889,949 86,965 August 1,019,658 129,709 September 1,149,670 130,012 October 1,295,610 145,939 November 1,391,406 95,796 December 1,617,205 225,799 City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2023 Administrative Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 234,130 $ 234,130 $ 253,437 8.25% February 398,050 163,920 571,249 43.51% March 562,597 164,548 April 731,035 168,438 May 898,492 167,457 June 1,126,724 228,231 July 1,316,328 189,604 August 1,484,904 168,576 September 1,654,403 169,499 October 1,831,412 177,009 November 2,030,169 198,756 December 2,203,636 173,467 *The monthly budget forecast columns are based on a five-year average. 14 Packet Pg. 69 I 2.5.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 April 387,260 96,815 May 484,075 96,815 June 580,890 96,815 July 677,705 96,815 August 774,520 96,815 September 871,335 96,815 October 968,150 96,815 November 1,064,965 96,815 December 1,161,780 96,815 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 —0-- Current Yeaz Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Police 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 1,163,207 $ 1,163,207 $ 1,041,369-10.47% February 2,325,164 1,161,957 2,119,852 -8.83% March 3,539,820 1,214,656 April 4,711,460 1,171, 639 May 5,925,620 1,214,160 June 7,207,679 1,282,059 July 8,426,096 1,218,417 August 9,573,799 1,147,703 September 10,782,176 1,208,377 October 12,034,062 1,251,887 November 13,502,037 1,467,974 December 14,981,027 1,478,990 Police 15,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 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget �Prior Year *The monthly budget forecast columns are based on a five-year average. O CL O co U C M C LL t r C O Cl) N O N M 7 L d 15 Packet Pg. 70 I 2.5.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2023 Planning & Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 347,462 $ 347,462 $ 286,492-17.55% February 713,406 365,944 595,086-16.59% March 1,064,835 351,429 April 1,435,462 370,628 May 1,799,819 364,357 June 2,162,115 362,296 July 2,557,600 395,486 August 2,928,740 371,139 September 3,315,666 386,926 October 3,700,453 384,787 November 4,115,049 414,597 December 4,594,584 479,535 Parks & Recreation Planning & Development 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 � Prior Yeaz City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2023 Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 419,238 $ 419,238 $ 589,720 40.66% February 877,712 458,474 958,125 9.16% March 1,336,230 458,519 April 1,795,549 459,318 May 2,265,114 469,566 June 2,763,462 498,348 July 3,308,655 545,192 August 3,873,351 564,696 September 4,481,385 608,035 October 4,980,826 499,441 November 5,490,595 509,769 December 6,022,817 532,222 *The monthly budget forecast columns are based on a five-year average. O CL C ra C LL t r C O a Cl) N O N M 7 L d 16 Packet Pg. 71 I 2.5.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 $ - $ - $ 81,158 0.00% February - - 97,897 0.00% March 622,495 622,495 April 643,293 20,798 May 643,293 - June 643,293 July 643,293 August 643,293 September 643,293 October 643,293 - November 741,244 97,951 December 1,215,000 473,756 Fund 016 - Building Maintenance Fund 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 A. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - Prior Year City ofEdmonds, WA Monthly Expenditure Report -Facilities Maintenance 2023 Facilities Maintenance Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 141,696 $ 141,696 $ 335,018 136.43% February 323,868 182,173 935,298 188.79% March 512,933 189,064 April 693,191 180,259 May 857,127 163,936 June 992,053 134,926 July 1,155,907 163,854 August 1,368,643 212,736 September 1,614,683 246,040 October 1,888,484 273,801 November 2,114,243 225,759 December 2,472,445 358,202 *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 72 I 2.5.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2023 Engineering Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 252,507 $ 252,507 $ 261,418 3.53% February 506,039 253,532 531,670 5.07% March 764,005 257,966 April 1,025,281 261,275 May 1,311,065 285,784 June 1,574,953 263,888 July 1,849,982 275,029 August 2,119,149 269,167 September 2,379,906 260,757 October 2,645,006 265,100 November 2,934,322 289,316 December 3,224,439 290,117 Engine a ring 3,500,000 31000,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 Yew *The monthly budget forecast columns are based on a five-year average. F O CL C M C LL t r C O Cl) N O N M 7 L d LL 18 Packet Pg. 73 I 2.5.a I Page 1 of 1 C TIY OF EDMONDS REVENUES BY FUND - SUMMARY Fund 2023 Adopted 2/28/2022 2/28/2023 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 49,991,791 $ 4,606,889 $ 4,920,100 $ 45,071,691 100/( 009 LEOFF-MEDICAL INS. RESERVE 225,000 - - 225,000 00/c Ol l RISK MANAGEMENT RESERVE FUND - - 0"/ 014 HISTORIC PRESERVATION GIFT FUND 00/c 016 BUILDING MAINTENANCE FUND 17,480 12,371 15,376 2,104 88% , 017 MARSH RESTORATION & PRESERVATION FUND - - - - 00/c O CL 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - - 00/c 104 DRUG ENFORCEMENT FUND 167,650 528 (127) 167,777 0% Ill STREET FUND 1,815,410 220,123 222,470 1,592,940 120/c _ 112 COMBINED STREET CONST/IMPROVE 8,308,065 391,143 878,200 7,429,865 c� 110/( C 117 MUNICIPAL ARTS ACQUIS. FUND 98,098 67,722 (1,040) 99,138 LL -10/c 118 MEMORIAL STREET TREE - - - - 0"/c r C 120 HOTEL/MOTEL TAX REVENUE FUND 84,400 14,104 15,210 69,190 180/c 121 EMPLOYEE PARKING PERMIT FUND 38,960 7,790 9,484 29,476 24% M N 122 YOUTH SCHOLARSHIP FUND 1,660 100 (29) 1,689 -20/( N 123 TOURISM PROMOTIONAL FUND/ARTS 30,440 5,195 4,917 25,523 16"/ 125 REAL ESTATE EXCISE TAX 2 2,320,090 217,629 129,249 2,190,841 60/( i 126 REAL ESTATE EXCISE TAX 1 2,302,980 213,161 127,721 2,175,259 60/c N LL 127 GIFT S CATALOG FUND 135,340 62,990 5,584 129,756 4% v r- 130 CEMETERY MAINTENANCE/IMPROVEMT 150,960 40,753 32,873 118,087 220/c O Q. 136 PARKSTRUST FUND 5,460 1,182 (303) 5,763 -60/, 137 CEMETERY MAINTENANCE TRUST FD 51,500 12,091 1,621 49,879 3% 138 SISTER CITY COMMISSION 10,430 108 (37) 10,467 00/c 140 BUSINESS IMPROVEMENT DISTRICT 88,645 34,985 36,319 52,326 410/( IL 141 AFFORDABLE AND SUPPORTIVE HOUSINGFUND 65,000 16,010 16,509 48,491 250/c 142 EDMONDS RESCUE PLAN FUND 1,249,000 - 350 1,248,650 00/c r C 143 TREE FUND 215,100 143 (425) 215,525 00/, 231 2012 LT GO DEBT SERVICE FUND 309,800 - - 309,800 00/( cM N 332 PARKS CAPITAL CONSTRUCTION FUND 927,205 20,158 156,181 771,024 170/, N 411 COMBINED UTILITY OPERATION - 25,960 21,385 (21,385) 00/, M 421 WATER UTILITYFUND 11,950,114 1,654,074 1,703,200 10,246,914 140/( i 422 STORM UTILITY FUND 8,903,407 1,567,867 1,787,714 7,115,693 200/, LL 423 SEWER/WWTP UTILITY FUND 15,898,844 3,393,406 3,639,281 12,259,563 23"/ C 424 BOND RESERVE FUND 1,991,860 2 1,454 1,990,406 00/c 511 EQUIPMENT RENTAL FUND 4,188,740 318,226 364,198 3,824,542 90/( v 512 TECHNOLOGY RENTAL FUND 1,413,372 196,324 234,607 1,178,765 170/c Q $ 112,956,801 $ 13,101,036 $ 14,322,040 $ 98,634,761 130% 19 Packet Pg. 74 I 2.5.a I Page 1 of 1 CITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2023 Adopted 2/28/2022 2/28/2023 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 55,716,788 $ 8,118,010 $ 10,063,682 $ 45,653,106 180/( 009 LEOFF-MEDICAL INS. RESERVE 367,140 53,349 50,940 316,200 140/c Ol l RISK MANANGEMENT RESERVE FUND 25,000 - - 25,000 0% 014 HISTORIC PRESERVATION GIFT FUND 5,900 - - 5,900 0% 016 BUILDING MAINTENANCE FUND 1,215,000 - 97,897 1,117,103 8% 017 MARSH RESTORATION & PRESERVATION FUND - - - 0% p CL 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - 00/( 019 EDMONDS OPIOID RESPONSE FUND - - - - 0% 104 DRUG ENFORCEMENT FUND 45,800 - - 45,800 0"/ _ Ill STREET FUND 2,350,969 454,338 617,715 1,733,255 260/c C 112 COMBINED STREET CONST/IMPROVE 7,214,960 69,666 751,025 6,463,935 100/c LL 117 MUNICIPAL ARTS ACQUIS. FUND 182,880 2,125 2,312 180,568 10/c r C 118 MEMORIAL STREET TREE - - - - 0% O 120 HOTEL/MOTEL TAX REVENUE FUND 95,400 5,703 370 95,030 0% M N 121 EMPLOYEE PARKING PERMIT FUND 26,880 - - 26,880 00/c N 122 YOUTH SCHOLARSHIP FUND 3,000 (150) - 3,000 00/c Z' 123 TOURISM PROMOTIONAL FUND/ARTS 28,500 - 780 27,720 30/c i 125 REAL ESTATE EXCISE TAX 2 2,473,362 144,516 170,915 2,302,447 70/c 126 REAL ESTATE EXCISE TAX 1 1,631,812 30,676 3,765 1,628,047 0% 127 GIFTSCATALOGFUND 497,598 2,114 11,089 486,509 20/c 0 0. 130 CEMETERY MAINTENANCE/IMPROVEMT 249,413 31,341 52,587 196,826 210/c CD 136 PARKS TRUST FUND - - - - 00/, iC 137 CEMETERY MAINTENANCE TRUST FUND 25,000 - - 25,000 00/c C O 138 SISTER CITY COMMISSION 11,900 - 153 11,747 1°/c E LL 140 BUSINESS IMPROVEMENT DISTRICT 88,575 5,885 5,344 83,231 6"/ >% 142 EDMONDS RESCUE PLAN FUND 1,249,000 114,190 519,688 729,312 420/c 143 TREE FUND 239,800 - - 239,800 0% 231 2012 LT GO DEBT SERVICE FUND 309,800 - - 309,800 0% N 332 PARKS CAPITAL CONSTRUCTION FUND 468,950 834,366 521,725 (52,775) 111% N 421 WATER UTILITY FUND 11,335,050 894,523 1,374,809 9,960,241 120/c 422 STORM UTILITY FUND 7,603,123 833,537 815,089 6,788,034 11% 423 SEWER/WWTP UTILITY FUND 15,381,246 1,545,617 2,392,445 12,988,801 160/c CU 424 BOND RESERVE FUND 1,989,820 - - 1,989,820 0% 511 EQUIPMENT RENTAL FUND 3,695,807 257,364 693,256 3,002,551 190/c d E 512 TECHNOLOGY RENTAL FUND 1,617,205 287,295 530,347 1,086,858 330/c v to 617 FIREMEN'S PENSION FUND - - - - 0% $ 116,145,678 $ 13,684,466 $ 18,675,934 $ 97,469,744 160/ 20 Packet Pg. 75 2.5.a Page 1 of 3 C PIY OF EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMSPROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 1 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GAS UTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWERUTILITYTAX 12 SI'ORMWATERUTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABSTAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LIC INS ES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE -FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT-COMCASf 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-ZIPLY FIBER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OTR NON -BUS LIC/PERMITS 32 SPECIAL EVENT REVIEW INTERGOVERNMENTAL: 33 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 34 HIGH VISIBILITY ENFORCEMENT 35 CORONAVIRUS RELIEF FUND 36 Sr ATE GRANTS - BUDGET ONLY 37 PUD PRIVILEDGE TAX 38 TRIAL COURT IMPROVEMENT 39 CJ - POPULATION 40 CRIMINAL JUSTICE -SPECIAL PROGRAMS 41 MARIJUANA EXCISE TAX DISTRIBUTION 42 DUI - CITIES 43 LIQUOR EXCISE TAX 44 LIQUOR BOARD PROFITS 45 MISCELLANEOUS INTERLOCAL REVENUE 46 FIRST RESPONDERS FLEX FUND 47 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 11,327,000 $ 21,076 $ 147,332 $ 11,179,668 10/( 4,578,000 8,279 59,032 4,518,968 10/( 500 27 - 500 00/( 11,900,000 1,853,000 1,908,832 9,991,168 160/( 7,600 3,599 - 7,600 00/( 1,150,000 178,710 182,193 967,807 160/( 1,900,000 377,116 393,380 1,506,620 210/( 845,000 96,596 242,800 602,200 290/( 384,000 48,316 60,567 323,433 160/( 1,000,234 138,271 143,978 856,256 140/( 942,960 160,357 166,439 776,521 180/( 621,458 132,287 135,983 485,475 220/( 850,000 133,791 66,442 783,558 80/( 773,000 66,255 54,319 718,681 70/( 80,200 18,591 22,264 57,936 280/( 350 - - 350 00/( 326,000 72,345.3 77,872.3 248,128 240/( 36,686,302 3,308,616 3,661,434 33,024,868 100/1 250 50 50 200 20% 700 20 140 560 200/( 94,500 14,505 17,364 77,136 180/( 702,700 179,444 171,516 531,184 240/( 41,000 3,060 2,796 38,204 70/( 100,600 12,550 9,373 91,227 90/( 450,000 84,298 101,463 348,537 230/c 250,000 41,654 42,587 207,413 170/( 80,000 15,575 14,320 65,680 180/( 30,000 30,173 13,962 16,038 470/( 750,600 77,263 113,817 636,783 1501( 24,000 6,357 8,762 15,238 370/( 75,000 (1,806) 17,130 57,870 230/( 20,000 - 2,517 17,483 130/( - 2,388 - - 00/( 2,619,350 465,531 515,796 2,103,554 200% 9,000 5,237 - 9,000 00/( 11,100 718 3,845 7,255 350/( 1,419,875 - - 1,419,875 00/( 125,000 - - 125,000 00/( 210,500 - - 210,500 00/( 16,740 - 5,338 11,402 320/( 13,070 3,571 3,758 9,312 290/( 50,600 12,693 13,294 37,306 260/( 125,000 - - 125,000 00/( 4,500 1,793 53 4,448 10/( 325,000 72,230 71,223 253,777 220/( 343,200 - - 343,200 00/( - - 500 (500) 00/( 1,000 - - 1,000 00/( 550 - - 550 00/( 2,655,135 96,243 98,011 2,557,124 40% F O M O io c ca C IL 21 s c O z Cl) N 0 N 7 L N 2022 Local Retail Sales/Use Tax revenues are $55,833 higher than 2021 revenues. Please also see pages pages 5 & 6. 21 1 Packet Pg. 76 1 2.5.a Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Revenues Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS 2 ATM SURCHARGE FEES 3 CREDIT CARD FEES 4 COURT RECORD SERVICES 5 D/M COURT REC SER 6 WARRANT PREPARATION FEE 7 IT TIME PAY FEE 8 MUNIC.-DIST. COURT CURR EXPEN 9 CLERKS TIME FOR SALE OF PARKING PERMITS 10 PHOTOCOPIES 11 POLICE DISCLOSURE REQUESTS 12 ENGINEERING FEES AND CHARGES 13 ELECTION CANDIDATE FILINGFEES 14 CUSTODIAL SERVICES(SNO-ISLE) 15 PASSPORTS AND NATURALIZATION FEES 16 POLICE SERVICES SPECIAL EVENTS 17 CAMPUS SAFETY-EDM. SCH. DIST. 18 WOODWAY-LAW PROTECTION 19 MISCELLANEOUS POLICE SERVICES 20 FIRE DISTRICT #1 STATION BILLINGS 21 LEGAL SERVICES 22 ADULT PROBATION SERVICE CHARGE 23 BOOKING FEES 24 FIRE CONSTRUCTION INSPECTION FEES 25 EMERGENCY SERVICE FEES 26 EMS TRANSPORT USER FEE 27 FLEX FUEL PAYMENTS FROM STATIONS 28 ZONING/SUBDIVISION FEE 29 BUILDING PLAN REVIEW AND INSPECTION 30 FIRE PLAN REVIEW 31 PLANNING REVIEW AND INSPECTION 32 S.E.P.A. REVIEW 33 CRITICAL AREA STUDY 34 GYM AND WEIGHTROOM FEES 35 PROGRAM FEES 36 HOLIDAY MARKET REGISTRATION FEES 37 UP TOWN EVENING MARKET FEES 38 WINTER MARKET FEES 39 BIRD FEST REGISTRATION FEES 40 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 1,266 $ 401 $ 2,599 130/( 600 32 30 570 501( 6,000 360 - 6,000 00/c 150 - - 150 00/( 300 - - 300 00/( 4,000 - - 4,000 00/c 1,000 34 21 979 20/( 50 21 56 (6) 1120/( 25,000 - - 25,000 00/( 100 57 - 100 00 1,000 - - 1,000 00/c 190,000 46,655 20,166 169,834 110/( 1,400 2,885 - 1,400 00/( 100,000 23,810 12,205 87,795 120/( 5,000 805 8,960 (3,960) 1790/( 30,000 - - 30,000 00/( 14,000 - - 14,000 00/( 210,970 - 56,856 154,114 270/( - 13 - - 00/( 67,000 15,373 19,794 47,206 300/( 1,050 26 - 1,050 00/( 38,000 3,165 1,492 36,508 40/( 3,000 39 35 2,965 10/( 10,000 5,837 2,796 7,204 280/( 3,500 100 157 3,343 40/( 1,077,500 238,403 - 1,077,500 00/( 5,000 600 754 4,246 1501( 65,600 20,885 24,340 41,260 370/( 425,000 37,202 84,021 340,979 200/( 4,000 2,561 3,853 147 960/( 500 110 - 500 00/( 3,000 740 1,480 1,520 490/( 14,000 3,885 3,300 10,700 240/( 13,000 16 2,222 10,778 170/( 990,959 6,406 53,638 937,321 50/c 5,000 - 455 4,545 90/( 5,000 - - 5,000 00/( 5,000 6,080 7,265 (2,265) 1450/( 1,000 - - 1,000 0°/ 3,427,765 196,414 201,435 3,226,330 60/( 6,757,444 613,778 505,733 6,251,711 70% O CL O io U C M c IL s c O M N 0 N M 7 N 22 Packet Pg. 77 2.5.a Page 3 of 3 C ITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 2/28/2022 2/28/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 CRT COST FEE CODE LEG ASSESSMENT (LGA) 5 CURRENT TRAFFIC INFRACTIONS 6 NON -TRAFFIC INFRACTION PENALTIES 7 OTHERINFRACTIONS'04 8 PARKING INFRACTION PENALTIES 9 PARK/INDDISZONE 10 DWI PENALTIES 11 DUI - DP ACCT 12 CRIM CNV FEE DUI 13 DUI - DP FEE 14 CRIMINAL TRAFFIC MISDEMEANOR 8/03 15 CRIMINAL CONVICTION FEE CT 16 CRIM CONV FEE CT 17 OTHER NON-T RAF MISDEMEANOR PEN 18 OTHER NON TRAFFIC MISD. 8/03 19 COURT DV PENALTY ASSESSMENT 20 CRIMINAL CONVICTION FEE CN 21 CRIM CONV FEE CN 22 PUBLIC DEFENSE RECOUPMENT 23 BANK CHARGE FOR CONY. DEFENDANT 24 COURT COST RECOUPMENT 25 BUS. LICENSE PERMIT PENALTY 26 MISC FINES AND PENALTIES MISCELLANEOUS: 27 INVESTMENT INTEREST 28 INTEREST ON COUNTY TAXES 29 INTEREST - COURT COLLECTIONS 30 LOAN INTEREST 31 SPACE/FACILITIESRENTALS 32 BRACKET ROOM RENTAL 33 LEASESLONG-TERM 34 DONATION/CONTRIBUTION 35 PARKSDONATIONS 36 BIRD FEST CONTRIBUTIONS 37 POLICE CONTRIBUTIONS FROM PRIV SOURCES 38 SALE OF JUNK/SALVAGE 39 SALES OF UNCLAIM PROPERTY 40 CONFISCATED AND FORFEITED PROPERTY 41 OTHER JUDGEMENT/SETTLEMENT 42 POLICE JUDGMENT SiRESTITUTION 43 CASHIER'S OVERAGESISHORT AGES 44 OTHER MISC REVENUES 45 SMALL OVERPAYMENT 46 NSF FEES - PARKS & REC 47 NSF FEES - MUNICIPAL COURT 48 L&I STAY AT WORK PROGRAM 49 US BANK REBATE TOTAL GENERAL FUND REVENUE $ 2,000 $ 248 $ 441 $ 1,559 220/c 130,000 10,394 22,083 107,917 170/( 18,000 676 271 17,729 20/( 10,000 638 457 9,543 501( - - 5,970 (5,970) 00/c 1,000 - - 1,000 00/( 1,500 171 477 1,023 320/( 125,000 3,428 2,010 122,990 20/c 2,000 44 - 2,000 00/( 7,000 415 1,019 5,981 1501( 300 - 1 299 00/( 100 4 - 100 00/( 1,500 252 284 1,216 190/( 25,000 1,032 1,058 23,942 40/( 2,000 268 193 1,807 100/( 700 - - 700 00/( 100 - - 100 00/( 12,000 352 108 11,892 10/( 800 12 - 800 0°/ 1,000 52 18 982 20/( 200 - - 200 00/c 6,000 373 534 5,466 9°/ 4,000 536 1,011 2,989 250/( 1,000 49 196 804 200/( 1,000 - - 1,000 00/c 150 - - 150 0°/ 352,350 18,945 36,132 316,218 100% 321,240 63,353 (10,751) 331,991 -3°/ 10,960 699 5,139 5,821 470/( 12,180 877 245 11,935 20/( 12,080 - - 12,080 00/( 175,000 2,973 7,091 167,909 40/( 2,100 - - 2,100 00/( 210,000 34,379 37,727 172,273 180/( 1,500 76 68 1,432 5°/ 3,500 300 500 3,000 140/( 1,500 - - 1,500 00/( 5,000 - - 5,000 0°/ 300 - 625 (325) 2080/( 3,800 324 1,415 2,385 370/( 2,000 - - 2,000 00/( 146,000 - 49,007 96,993 340/( 200 14 - 200 00/( - 10 - - 0°/ 5,000 758 327 4,673 7°/ 100 13 1 99 10/( 100 - - 100 00/( 150 - - 150 00/( - - 8,702 (8,702) 00/( 8,500 - 2,899 5,601 34°/ 921,210 103,776 102,994 818,216 110% $ 49,991,791 $ 4,606,889 $ 4,920,100 $ 45,071,691 100% 23 Packet Pg. 78 I 2.5.a I Page 1 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 21,585,702 $ 2,841,391 $ 3,741,586 $ 17,844,116 170/ 2 OVERTIME 649,080 201,343 130,516 518,564 200/ 3 HOLIDAY BUY BACK 294,001 6,187 824 293,177 00/ 4 BENEFITS 7,619,904 1,072,560 1,283,622 6,336,282 170/ 5 UNIFORMS 130,851 6,880 22,916 107,935 180/ 6 PENSION AND DISABILITY PAYMENTS 165,023 11,825 14,862 150,161 90/ 7 SUPPLIES 759,025 45,215 39,689 719,336 50/ 8 SMALL EQUIPMENT 302,791 15,804 15,414 287,377 501 9 PROFESSIONAL SERVICES 17,677,872 2,637,924 2,964,798 14,713,074 170/ 10 COMMUNICATIONS 181,295 14,441 14,245 167,050 80/ 11 TRAVEL 74,795 3,217 6,205 68,590 80/ 12 EXCISE TAXES 16,500 2,993 3,177 13,323 190/ 13 RENTAL/LEASE 2,780,344 338,100 437,404 2,342,940 160/ 14INSURANCE 597,722 503,160 625,650 (27,928) 10501 15 UTILITIES 663,800 90,751 98,557 565,243 150/ 16 REPAIRS& MAINTENANCE 388,900 144,268 214,245 174,655 550/ 17 MISCELLANEOUS 502,593 131,953 163,085 339,508 320/ 18 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 - 50,000 00/ 19 INTERFUND SUBSIDIES 863,000 - - 863,000 00/ 20 BUILDINGS - 282,622 (282,622) 00/ 21 MACHINERY/EQUIPMENT 90,000 4,264 85,736 50/ 22 GENERAL OBLIGATION BOND PRINCIPAL 191,620 - 191,620 00/ 23 INTEREST ON LONG-TERM EXTERNAL DEBT 131,470 - 131,470 00/ 24 OTHER INTEREST & DEBT SERVICE COSTS 500 500 00/ 55,716,788 8,118,010 10,063,682 45,653,106 180/ LEOFF-MEDICAL INS. RESERVE(009) 25 BENEFITS $ 206,650 $ 35,907 $ 38,355 $ 168,295 190/ 26 PENSION AND DISABILITY PAYMENTS 152,990 17,442 12,586 140,404 80/ 27 PROFESSIONAL SERVICES 7,000 - - 7,000 00/ 28 MISCELLANEOUS 500 - - 500 00/ 367,140 53,349 50,940 316,200 140/ RISK MANAGEMENT RESERVE FUND (011) 29 MISCELLANEOUS $ 25,000 $ - $ - $ 25,000 00/ 25,000 - 25,000 01/ HISTORIC PRESERVATION GIFT FUND (014) 30 SUPPLIES $ 100 $ $ - $ 100 00/ 31 PROFESSIONAL SERVICES 200 - 200 00/ 32 MISCELLANEOUS 5,600 - 5,600 00/ 5,900 $ - 5,900 00/ BUILDING MAINTENANCEFUND (016) 33 PROFESSIONAL SERVICES $ 121,500 $ $ - $ 121,500 00/ 34 REPAIR&MAINTENANCE 1,093,500 81,158 1,012,342 70/ 35 BUILDINGS - 16,739 (16,739) 00/ 1,215,000 97,897 1,117,103 80/ DRUG INFO RC EMENT FUND (104) 35 PROFESSIONAL SERVICES $ 45,000 $ $ - $ 45,000 00/ 36 REPAIR/MAINT 800 - 800 00/ 45,800 - 45,800 01/ O CL O is U C ca C IL s r c O M N O N cc LL L N 24 Packet Pg. 79 I 2.5.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Expenditures Expenditures Remaining % Spent STREETFUND (111) 1 SALARIES AND WAGES $ 828,313 $ 113,792 $ 290,986 $ 537,327 35° 2 OVERTIME 38,400 5,910 6,421 31,979 174 3 BENEFITS 377,585 57,737 92,465 285,120 240 4 UNIFORMS 6,000 1,345 494 5,506 8° 5 SUPPLIES 263,000 10,551 11,241 251,759 4° 6 SMALL EQUIPMENT 20,000 587 552 19,448 M 7 PROFESSIONAL SERVICES 23,210 4,389 4,556 18,654 200 8 COMMUNICATIONS 4,500 672 720 3,780 160 9 TRAVEL 1,000 - - 1,000 0° 10 RENTAL/LEASE 304,730 48,091 50,484 254,246 174 11 INSURANCE 120,821 184,111 126,467 (5,646) 105° 12 UTILITIES 273,730 23,446 25,721 248,009 94 13 REPAIRS&MAINTENANCE 52,000 2,318 1,829 50,171 44 14 MISCELLANEOUS 8,000 1,389 5,778 2,222 724 15 BUILDINGS 25,000 - - 25,000 0° 16 GENERAL OBLIGATION BOND PRINCIPAL 4,380 - - 4,380 04 17 INTEREST 300 - - 300 04 $ 2,350,969 $ 454,338 $ 617,715 $ 1,733,255 264 COMBINED STREET CONST/IMPROVE(112) 18 PROFESSIONAL SERVICES $ 3,344,780 $ 42,490 $ 65,375 $ 3,279,405 24 19 INTERFUND SUBSIDIES 172,650 - - 172,650 0° 20 LAND 270,000 27,176 - 270,000 M 21 CONSTRUCTION PROJECTS 3,372,580 - 685,650 2,686,930 2M 22 INTERGOVERNMENTAL LOANS 54,070 - - 54,070 04 23 INTEREST 880 - - 880 04 $ 7,214,960 $ 69,666 $ 751,025 $ 6,463,935 100 MUNIC IPAL ARTS ACQUIS. FUND (117) 24 SUPPLIES $ 4,700 $ - $ 427 $ 4,273 94 25 SMALL EQUIPMENT 1,700 - - 1,700 04 26 PROFESSIONAL SERVICES 166,500 1,100 1,855 164,645 19 27 TRAVEL 80 - - 80 09 28 RENTAL/LEASE 3,000 - 3,000 M 29 REPAIRS & MAINTENANCE 300 - - 300 M 30 MISCELLANEOUS 6,600 1,025 30 6,570 09 $ 182,880 $ 2,125 $ 2,312 $ 180,568 19 HO TEL/MO TEL TAX REVENUE FUND (120) 31 PROFESSIONAL SERVICES $ 90,400 $ 5,703 $ 370 $ 90,030 M 32 MISCELLANEOUS 1,000 - - 1,000 0° 33 INTERFUND SUBSIDIES 4,000 - - 4,000 04 $ 95,400 $ 5,703 $ 370 $ 95,030 M EMPLO YEE PARIONG PERMIT FUND (121) 34 SUPPLIES $ 1,790 $ - $ - $ 1,790 M 35 PROFESSIONAL SERVICES 25,090 - 25,090 04 $ 26,880 $ - $ - $ 26,880 09 YOUTH SCHOLARSHIP FUND (122) 36 MISCELLANEOUS $ 3,000 $ (150) $ - $ 3,000 M $ 3,000 $ (150) $ - $ 3,000 04 TOURISM PROMOTIONAL FUND/ARTS (123) 37 PROFESSIONAL SERVICES $ 28,500 $ - $ 780 $ 27,720 34 $ 28,500 $ - $ 780 $ 27,720 M F O Q. d w io C ca C M s C O a M N 0 N M 7 L N LL 25 Packet Pg. 80 I 2.5.a I Page 3 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXC ISE TAX 2 (125) 1 SUPPLIES $ - $ 3,050 $ - $ - M 2 PROFESSIONAL SERVICES 586,957 15,539 9,072 577,885 29 3 REPAIRS & MAINTENANCE 851,800 56,168 13,094 838,706 29 4 INTERFUND SUBSIDIES 5,684 - - 5,684 09 5 LAND 200,000 - - 200,000 09 6 CONSTRUCTION PROJECTS 828,921 69,759 148,748 680,173 IM $ 2,473,362 $ 144,516 $ 170,915 $ 2,302,447 79 REAL ESTATE EXCISE TAXI (126) 7 PROFESSIONAL SERVICES 8 REPAIRS & MAINTENANCE 9 INTERFUND SUBSIDIES 10 CONSTRUCTION PROJECTS 11 GENERAL OBLIGATION BONDS 12 INTEREST GIFTS CATALOG FUND (127) 13 SALARIES AND WAGES 14 BENEFIT S 15 SUPPLIES 16 SMALL EQUIPMENT 17 PROFESSIONAL SERVICES 18 RENTAL/LEASE 19 MISCELLANEOUS CEMEIERY MAINTENANCEIMPRO VEMENT (130) 20 SALARIES AND WAGES 21 OVERTIME 22 BENEFIT S 23 UNIFORMS 24 SUPPLIES 25 SUPPLIES PURCHASED FOR INVENTORY/RESALE 26 PROFESSIONAL SERVICES 27 COMMUNICATIONS 28 TRAVEL 29 RENTAL/LEASE 30 UTILITIES 31 REPAIRS & MAINTENANCE 32 MISCELLANEOUS CEMEIERY MAINTENANCE TRUST FUND (137) 33 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 34 SUPPLIES 35 TRAVEL 36 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 37 SUPPLIES 38 PROFESSIONAL SERVICES 39 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 40 PROFESSIONAL SERVICES TREE FUND (143) 41 SUPPLIES 42 PROFESSIONAL SERVICES 43 LAND 2012 LTGO DEBT SERVIC FUND (231) 44 GENERAL OBLIGATION BOND 45 INTEREST $ 231,260 $ 17,410 $ 3,765 $ 227,495 29 457,800 13,266 - 457,800 09 147,557 - - 147,557 09 535,755 - - 535,755 09 155,470 - - 155,470 09 103,970 - - 103,970 09 $ 1,631,812 $ 30,676 $ 3,765 $ 1,628,047 09 $ 196,455 $ - $ - $ 196,455 09 80,033 - - 80,033 09 146,000 2,114 7,998 138,002 59 500 - - 500 09 56,500 - - 56,500 09 17,510 - 2,918 14,592 179 600 - 173 427 290 $ 497,598 $ 2,114 $ 11,089 $ 486,509 29 $ 137,541 $ 14,060 $ 32,589 $ 104,952 249 3,500 210 - 3,500 09 54,487 6,168 9,758 44,729 IM 1,000 - - 1,000 09 7,000 45 1,859 5,141 279 20,000 3,690 2,886 17,114 149 4,200 800 793 3,407 190 1,700 284 288 1,412 179 500 - - 500 09 9,420 1,948 1,593 7,827 179 5,565 267 253 5,312 59 500 - - 500 09 4,000 3,868 2,569 1,431 649 $ 249,413 $ 31,341 $ 52,587 $ 196,826 219 $ 25,000 $ - $ - $ 25,000 09 $ 25,000 $ - $ - $ 25,000 09 $ 1,500 $ - $ - $ 1,500 09 4,500 - 4,500 M 5,900 - 153 5,747 M $ 11,900 $ - $ 153 $ 11,747 19 $ 4,091 $ 94 $ 298 $ 3,793 79 78,327 5,719 4,873 73,454 69 6,157 73 173 5,984 M 88,575 5,885 5,344 83,231 69 $ 1,249,000 $ 114,190 $ 519,688 $ 729,312 429 1,249,000 114,190 519,688 729,312 429 $ 1,000 $ $ $ 1,000 M 39,800 39,800 09 199,000 - 199,000 M 239,800 $ - 239,800 09 $ 235,000 $ $ - $ 235,000 09 74,800 - 74,800 09 $ 309,800 $ $ $ 309,800 09 O CL O io U C M C LL s C O a M N O N M 7 L N LL 26 Packet Pg. 81 I 2.5.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 INTERFUND SUBSIDIES $ - $ 62,656 $ - $ 09 2 PROFESSIONAL SERVICES - 58,258 10,982 (10,982) 09 3 CONSTRUCTION PROJECTS 371,300 713,452 510,743 (139,443) 1389 4 GENERAL OBLIGATION BONDS 50,000 - - 50,000 M 5 INTEREST 47,650 - - 47,650 09 $ 468,950 $ 834,366 $ 521,725 $ (52,775) 1119 WATER FUND (421) 6 SALARIES AND WAGES 7 OVERTIME 8 BENEFIT S 9 UNIFORMS 10 SUPPLIES 11 WATER PURCHASED FOR RESALE 12 SUPPLIES PURCHASED FOR INVENTORY/RESALE 13 SMALL EQUIPMENT 14 PROFESSIONAL SERVICES 15 COMMUNICATIONS 16 TRAVEL 17 EXCISE TAXES 18 RENTAL/LEASE 19INSURANCE 20 UTILITIES 21 REPAIRS & MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 BUILDINGS 25 MACHINERY/EQUIPMENT 26 CONSTRUCTION PROJECTS 27 GENERAL OBLIGATION BONDS 28 REVENUE BONDS 29 INTERGOVERNMENTAL LOANS 30 INTEREST STORM FUND (422) 31 SALARIES AND WAGES 32 OVERTIME 33 BENEFIT S 34 UNIFORMS 35 SUPPLIES 36 SMALL EQUIPMENT 37 PROFESSIONAL SERVICES 38 COMMUNICATIONS 39 TRAVEL 40 EXCISE TAXES 41 RENTAL/LEASE 42 INSURANCE 43 UTILITES 44 REPAIR & MAINTENANCE 45 MISCELLANEOUS 46 INTERFUND SUBSIDIES 47 LAND 48 BUILDINGS 49 CONSTRUCTION PROJECTS 50 GENERAL OBLIGATION BONDS 51 REVENUE BONDS 52 INTERGOVERNMENTAL LOANS 53 INTEREST $ 963,268 $ 120,241 $ 234,617 $ 728,651 249 24,000 3,264 1,936 22,064 89 393,439 51,867 72,644 320,795 189 4,000 686 1,598 2,402 4M 150,000 20,467 34,420 115,580 239 2,398,000 149,684 153,888 2,244,112 69 180,000 23,934 19,051 160,949 119 13,500 587 1,440 12,060 110 2,226,928 49,681 258,264 1,968,664 129 35,000 3,939 4,027 30,973 129 200 - - 200 M 1,696,934 213,695 223,810 1,473,124 139 187,952 25,598 31,275 156,677 179 215,319 122,359 225,379 (10,060) 1059 35,000 5,346 6,673 28,327 199 71,130 11,535 11,705 59,425 169 123,600 49,045 46,799 76,801 380 646,370 - - 646,370 M 12,500 - - 12,500 09 10,000 - - 10,000 09 1,400,000 42,594 47,283 1,352,717 M 2,940 - - 2,940 09 333,830 - - 333,830 09 25,840 - - 25,840 09 185,300 - - 185,300 09 $ 11,335,050 $ 894,523 $ 1,374,809 $ 9,960,241 120 $ 821,952 $ 125,774 $ 281,083 $ 540,869 349 26,000 4,759 1,482 24,518 69 342,317 53,780 81,937 260,380 249 6,500 2,403 1,187 5,313 1M 46,000 18,484 2,051 43,949 49 4,000 587 - 4,000 09 3,013,124 86,715 99,251 2,913,873 M 3,200 534 574 2,626 189 4,300 - - 4,300 09 499,658 144,632 148,903 350,755 309 293,210 44,446 48,547 244,663 179 30,265 82,335 31,680 (1,415) 1059 10,500 2,524 2,743 7,757 269 189,130 11,040 11,065 178,065 69 232,300 61,461 28,818 203,482 129 283,237 - - 283,237 09 680,000 - - 680,000 09 25,000 - - 25,000 09 659,600 194,065 75,768 583,832 119 107,290 - - 107,290 09 160,870 - - 160,870 09 61,600 - - 61,600 09 103,070 - - 103,070 09 $ 7,603,123 $ 833,537 $ 815,089 $ 6,788,034 119 O CL io C M C LL s c O M N 0 N M 7 L N LL 27 Packet Pg. 82 2.5.a Page 5 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,468,518 $ 312,259 $ 654,687 $ 1,813,831 27° 2 OVERTIME 130,000 31,456 39,708 90,292 314 3 BENEFITS 867,257 124,674 209,033 658,224 244 4 UNIFORMS 11,500 3,339 4,910 6,590 4M 5 SUPPLIES 453,000 29,952 66,775 386,225 150 6 FUEL CONSUMED 20,000 - - 20,000 M 7 SUPPLIES PURCHASED FOR INV OR RESALE 5,000 - - 5,000 M 8 SMALL EQUIPMENT 83,900 85,279 2,146 81,754 M 9 PROFESSIONAL SERVICES 2,517,949 203,876 359,266 2,158,683 144 10 COMMUNICATIONS 48,000 7,286 5,497 42,503 il° 11 TRAVEL 5,000 - - 5,000 M 12 EXCISE TAXES 1,026,360 198,449 203,074 823,286 2M 13 RENTAL/LEASE 312,006 52,715 52,058 259,948 174 14 INSURANCE 344,564 203,936 360,663 (16,099) 1054 15 UTILITIES 1,582,060 142,051 320,237 1,261,823 2M 16 REPAIR & MAINTENANCE 728,630 126,645 37,589 691,041 54 17 MISCELLANEOUS 138,350 23,700 56,516 81,834 414 18 INTERFUND SUBSIDIES 1,588,089 - - 1,588,089 M 19 BUILDINGS 12,500 - - 12,500 M 20 CONSTRUCTION PROJECTS 2,396,163 - - 2,396,163 09 21 GENERAL OBLIGATION BONDS 129,820 - - 129,820 M 22 REVENUE BONDS 55,310 - - 55,310 M 23 INTERGOVERNMENTAL LOANS 104,000 - 15,754 88,246 150 24 INTEREST 353,270 - 2,582 350,688 I° 25 OTHER INT EREST & DEBT SERVICE COSTS - - 1,948 (1,948) M $ 15,381,246 $ 1,545,617 $ 2,392,445 $ 12,988,801 16° BOND RESERVEFUND (424) 26 REVENUE BONDS $ 840,010 $ - $ - $ 840,010 M 27 INTEREST 1,149,810 - 1,149,810 M $ 1,989,820 $ - $ $ 1,989,820 M 28 Packet Pg. 83 I 2.5.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 279,652 $ 47,129 $ 97,841 $ 181,811 35° 2 OVERTIME 2,000 222 - 2,000 04 3 BENEFITS 105,497 19,100 26,630 78,867 25° 4 UNIFORMS 1,500 646 476 1,024 32° 5 SUPPLIES 149,120 40,039 11,292 137,828 84 6 FUEL CONSUMED 1,000 - - 1,000 04 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 458,880 81,457 54,331 404,549 120 8 SMALL EQUIPMENT 58,000 1,924 148 57,852 04 9 PROFESSIONAL SERVICES 46,750 223 302 46,448 14 10 COMMUNICATIONS 3,000 309 392 2,608 13° 11 TRAVEL 1,000 - - 1,000 0° 12 RENTAL/LEASE 17,470 1,728 2,795 14,675 169 13 INSURANCE 47,938 51,903 50,178 (2,240) 1054 14 UTILITIES 14,000 3,276 4,817 9,183 34° 15 REPAIRS & MAINTENANCE 60,000 2,002 7,361 52,639 124 16 MISCELLANEOUS 12,000 1,396 1,398 10,602 124 17 MACHINERY/EQUIPMENT 2,438,000 6,008 435,295 2,002,705 184 $ 3,695,807 $ 257,364 $ 693,256 $ 3,002,551 19° TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 600,771 $ 43,726 $ 82,842 $ 517,929 14° 19 OVERTIME 2,000 - - 2,000 04 20 BENEFITS 180,554 18,703 25,429 155,125 14° 21 SUPPLIES 5,000 1,750 1,047 3,953 214 22 SMALL EQUIPMENT 181,800 8,341 15,176 166,624 8° 23 PROFESSIONAL SERVICES 61,860 2,472 9,468 52,392 154 24 COMMUNICATIONS 58,770 7,807 6,455 52,315 114 25 TRAVEL 1,500 - - 1,500 0° 26 RENTAL/LEASE 4,640 743 273 4,367 64 27 REPAIRS & MAINTENANCE 408,710 203,737 379,945 28,766 934 28 MISCELLANEOUS 55,600 16 9,711 45,889 174 29 MACHINERY/EQUIPMENT 56,000 - - 56,000 04 $ 1,617,205 $ 287,295 $ 530,347 $ 1,086,858 334 TOTAL EXPENDITURE ALL FUNDS $ 116,145,678 $ 13,684,466 S 18,675,934 $ 97,469,744 164 O CL O io C M C M 21 z C O a Cl) N 0 N M LL L d 29 Packet Pg. 84 2.5.a Page 1 of 1 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY Title CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPARTMENTAL POLICE SERVICES SATELLITE OFFICE COMMUNITY SERVICESIECONOMIC DEV. PLANNING& DEVELOPMENT HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE 2023 Adopted 2/28/2022 2/28/2023 Amount Budget Expenditures Expenditures Remaining %Spent $ 480,256 $ 43,670 $ 71,252 $ 409,004 15% 495,273 59,226 63,133 432,140 13% 1,254,947 135,524 164,590 1,090,357 13% 1,451,763 187,919 231,321 1,220,442 16% 2,203,636 380,532 571,249 1,632,387 26% 0 CL 1,161,780 155,234 109,813 1,051,967 9% 4) w 15,180,425 2,922,333 3,380,586 11,799,839 22% v 14,981,027 1,945,020 2,119,852 12,861,175 14% C C 145,681 8,348 17,625 128,056 12% LL 1,105,451 72,230 172,586 932,865 16% C 4,594,584 661,303 595,086 3,999,498 13% 0 324,650 21,465 34,052 290,598 10% N 6,022,817 651,988 958,125 5,064,692 16% 0 N 3,842,053 503,819 639,116 3,202,937 17% 7 L 2,472,445 369,398 935,298 1,537,147 38% $ 55,716,788 $ 8,118,010 $ 10,063,682 $ 45,653,106 18% CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2023 Adopted Budget 2/28/2022 Expenditures 2/28/2023 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 11,335,050 $ 894,523 $ 1,374,809 $ 9,960,241 12% STORM UTILITY FUND 7,603,123 833,537 815,089 6,788,034 11% SEWER/WWTP UTILITY FUND 15,381,246 1,545,617 2,392,445 12,988,801 16% BOND RESERVE FUND 1,989,820 - - 1,989,820 0% $ 36,309,239 $ 3,273,677 $ 4,582,343 $ 31,726,896 13% 30 Packet Pg. 85 Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2023 Adopted Budget 2/28/2022 Expenditures 2/28/2023 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES AND WAGES $ 214,276 $ 25,901 $ 36,414 $ 177,862 17% BENEFITS 102,845 14,188 17,150 85,695 17% SUPPLIES 11,000 163 417 10,583 4% SERVICES 152,135 3,419 17,271 134,864 11% $ 480,256 $ 43,670 $ 71,252 $ 409,004 15% OFFICEOFMAYOR SALARIES AND WAGES $ 274,988 $ 40,066 $ 42,826 $ 232,162 16% BENEFITS 88,487 14,439 14,944 73,543 17% 0 O SUPPLIES 1,500 1,357 284 1,216 19% 0- SERVICES 130,298 3,364 5,079 125,219 4% $ 495,273 $ 59,226 $ 63,133 $ 432,140 13% HUMAN RESOURCES SALARIES AND WAGES $ 747,258 $ 76,448 $ 85,877 $ 661,381 11% BENEFITS 236,609 28,671 32,456 204,153 14% O SUPPLIES 13,600 246 241 13,359 2% LL 21 SERVICES 257,480 30,158 46,017 211,463 18% $ 1,254,947 $ 135,524 $ 164,590 $ 1,090,357 13% MUNICIPAL C O URT O SALARIES AND WAGES $ 937,770 $ 129,827 $ 160,069 $ 777,701 17% M BENEFITS 302,672 36,915 50,721 251,951 17% c SUPPLIES 11,600 1,243 - 11,600 0% N SERVICES 199,721 19,934 20,530 179,191 10% Z' $ 1,451,763 $ 187,919 $ 231,321 $ 1,220,442 16% ADMINIS TRATIVE S ERVIC ES SALARIES AND WAGES $ 1,418,894 $ 219,500 $ 363,732 $ 1,055,162 26% LL BENEFITS 429,103 74,226 94,903 334,200 22% SUPPLIES 13,000 2,259 620 12,380 5% C SERVICES 342,639 84,547 111,993 230,646 33% Q. $ 2,203,636 $ 380,532 $ 571,249 $ 1,632,387 26% CITY ATPO RNEY SERVICES $ 1,161,780 $ 155,234 $ 109,813 $ 1,051,967 $ 1,161,790 $ 155,234 $ 109,813 $ 1,051,967 9% NON -DEPARTMENTAL E SALARIES AND WAGES $ 101,750 $ $ - $ 101,750 0% LL BENEFITS 239,583 14,684 26,301 213,282 11% s SUPPLIES 5,000 - - 5,000 0% SERVICES 13,597,502 2,857,649 3,354,285 10,243,217 25% O INTERFUND SUBSIDIES 913,000 50,000 - 913,000 0% z DEBT SERVICE - PRINCIPAL 191,620 - - 191,620 0% N DEBT SERVICE - INTEREST 131,970 - - 131,970 0% N $ 15,180,425 $ 2,922,333 $ 3,380,586 $ 11,799,839 22% PO LIC E SERVIC ES SALARIES AND WAGES $ 9,556,760 $ 1,289,952 $ 1,317,989 $ 8,238,771 14% 3 BENEFITS 3,303,628 449,778 480,018 2,823,610 15% SUPPLIES 342,941 14,102 17,304 325,637 5% Li . SERVICES 1,777,698 191,189 304,541 1,473,157 17% C $ 14,981,027 $ 1,945,020 $ 2,119,852 $ 12,861,175 14% a) S ATELLITE O FFIC E t1 SALARIES AND WAGES $ 38,537 $ $ 7,280 $ 31,257 19% BENEFITS 7,298 1,383 5,915 19% Q SUPPLIES 12,000 8,019 - 12,000 0% SERVICES 87,846 329 8,961 78,885 10% $ 145,681 $ 8,348 $ 17,625 $ 128,056 12% 31 Packet Pg. 86 1 I 2.5.a I Page 2 of 2 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2023 Adopted 2/28/2022 2/28/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY S ERVIC ES /EC O N DEV. SALARIES AND WAGES $ 550,413 $ 33,357 $ 105,173 $ 445,240 19% BENEFITS 153,183 10,865 26,972 126,211 18% SUPPLIES 4,075 184 391 3,684 10% SERVICES 397,780 27,825 40,050 357,730 10% $ 1,105,451 $ 72,230 $ 172,586 $ 932,865 16% PLANNING & DEVELOPMENT SALARIES AND WAGES $ 2,176,581 $ 384,754 $ 367,118 $ 1,809,463 17% BENEFITS 736,473 126,981 134,987 601,486 18% SUPPLIES 23,400 433 539 22,861 2% SERVICES 1,658,130 149,136 92,442 1,565,688 6% $ 4,594,584 $ 661,303 $ 595,086 $ 3,999,498 13% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 101,849 $ 10,782 $ 18,580 $ 83,269 18% BENEFITS 29,301 2,165 5,336 23,965 18% SUPPLIES 15,000 59 - 15,000 0% SERVICES 178,500 8,460 10,135 168,365 6% 324,650 $ 21,465 34,052 290,598 10% PARKS & REC REATIO N SALARIES AND WAGES $ 2,859,976 $ 365,506 $ 612,294 $ 2,247,682 21% BENEFITS 968,480 133,623 187,807 780,673 19% SUPPLIES 468,900 22,326 19,143 449,757 4% SERVICES 1,635,461 130,534 138,881 1,496,580 8% MACHINERY/EQUIPMENT 90,000 - - 90,000 0% $ 6,022,817 $ 651,988 $ 958,125 $ 5,064,692 16% PUBLIC WORKS ADMINIS TRATIO N SALARIES AND WAGES $ 372,900 $ 21,156 $ 69,376 $ 303,524 19% BENEFITS 142,675 10,695 20,963 121,712 15% SUPPLIES 9,600 1,063 2,957 6,643 31% SERVICES 92,439 13,723 14,149 78,290 15% $ 617,614 $ 46,637 $ 107,445 $ 510,169 17% FACILITIES MAINTENANCE SALARIES AND WAGES 981,868 146,231 316,947 664,921 32% BENEFITS 402,717 56,253 97,785 304,932 24% SUPPLIES 128,000 9,563 12,344.83 115,655 10% SERVICES 959,860 157,350 221,335 738,525 23% MACHINERY/EQUIPMENT 286,886 (286,886) 0% $ 2,472,445 $ 369,398 $ 935,298 $ 1,537,147 38% ENGINEERING SALARIES AND WAGES $ 2,194,963 $ 305,443 $ 369,252 $ 1,825,711 17% BENEFITS 772,724 117,782 129,674 643,050 17% SUPPLIES 2,200 - 862 1,338 39% SERVICES 254,552 33,957 31,882 222,670 13% $ 3,224,439 $ 457,182 $ 531,670 $ 2,692,769 16% TOTAL GENERAL FUND EXPENDITURES $ 55,716,788 $ 8,118,010 $ 10,063,682 $ 45,653,106 18% O CL O is U C ca C IL s C O M N O N cc 7 N LL 32 Packet Pg. 87 2.5.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 2/28/2023 2/28/2023 Q1 YTD Fund Balance Cash Balance 001-General Fund $ 6,296,457 $ 2,065,339 $ (5,143,582. �E 009-Leoff-Medical Ins. Reserve 165,923 181,876 (50,940 00. 011-Risk Management Reserve Fund 25,000 25,000 a� - 012-ContingencyReserve Fund 1,782,150 1,782,150 - •6 014-Historic Preservation Gift Fund 11,701 11,701 - c 016-Building Maintenance 4,214,082 4,374,097 (82,522 ii 017 - Marsh Restoration & Preservation 849,766 849,766 - 1 t 018 - Edmonds Homelessness Response Fd 200,000 200,000 - 0 Total General Fund & Subfunds Is 13,545,079 $ 9,489,928 $ - $ (5,277,044 M N O N *$9,361,208 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012, represent the required ca 20% operating reserve. L a� u_ There are no interfund loans outstanding at this time. 0 Q. m GOVERNMENTAL FUNDS OVERVIEW U_ BALANCES CHANGE IN FUND BALANCES 0 GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- N FUNDS 2/28/2023 2/28/2023 0 Q1 YTD N Fund Balance Cash Balance L General Fund & Subfunds $ 13,545,079 $ 9,489,928 $ (5,277,044 'w u_ Special Revenue 15,611,194 23,862,605 (657,198 Capital Projects - Fund 332 (157,862) 83,358 c (365,544 E Total Governmental Funds $ 28,998,411 $ 33,435,891 $ - $ (6,299,787 U r r Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 33 Packet Pg. 88 2.5.a SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 2/28/2023 2/28/2023 Q1 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 67,443 $ 70,695 $ (127 111 - Street Fund 13,439 73,188 (395,245 a 112- Combined Street Const/Improve 2,484,239 783,076 127,175 117 - Municipal Arts Acquis. Fund 631,536 662,189 (3,352 6 120 - Hotel/Motel Tax Revenue Fund 109,704 99,178 14,840 73 121 - Employee Parking Permit Fund 84,516 87,996 9,484 122 - Youth Scholarship Fund 15,180 15,885 (29LL 123 -Tourism Promotional Fund/Arts 119,307 119,281 4,137 2, 125 -Real Estate Tax 2 3,250,891 3,480,648 (41,666, 126 - Real Estate Excise Tax 1 * 4,149,478 4,259,211 123,956 0 127 - Gifts Catalog Fund 3,058,287 3,200,872 (5,506 M 130 - Cemetery Maintenance/Improvement 248,455 261,319 (19,715 0 136 - Parks Trust Fund 161,135 168,632 (303 N 137- Cemetery Maintenance Trust Fund 1,104,921 1,156,094 1,621 138 - Sister City Commission 19,704 20,627 (190 140 -Business Improvement Disrict 70,759 70,759 30,975 141 -Affordable and Supportive Housing Fd 251,075 243,436 16,509 V_ 142 - Edmonds Rescue Plan Fund (454,750) 8,853,149 (519,338; 0 143 - Tree Fund 225,874 236,371 (425 Total Special Revenue $ 15,611,194 $ 23,862,605 1 $ - $ (657,198; *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $1,000,000 Z for the purchase of Open Space. ii ENTERPRISE FUNDS OVERVIEW '' O 2 CO) N O N BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- ENTERPRISE FUNDS 2/28/2023 2/28/2023 Q1 YTD Ui Fund Balance Cash Balance m 421 -Water Utility Fund $ 31,415,661 $ 9,707,884 $ 328,391 t 422 -Storm Utility Fund* 16,276,081 5,877,689 972,626 U r Q 423 - Sewer/WWTP Utility Fund 57,642,302 14,534,249 1,246,836 424 - Bond Reserve Fund 845,414 845,414 1,454 411 -Combined Utility Operation 21,385 74,859 21,385 Total Enterprise Funds $ 106,200,843 $ 31,040,095 $ - $ 2,570,691 *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding. *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 34 Packet Pg. 89 2.5.a SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 2/28/2023 2/28/2023 Q1 YTD Fund Balance Cash Balance Governmental Funds $ 28,998,411 $ 33,435,891 $ (6,299,787 Enterprise Funds 106,200,843 31,040,095 2,570,691 a Internal Services Fund 9,791,173 5,355,633 (624,798 a� Total City-wide Total $ 144,990,427 $ 69,831,619 $ - $ (4,353,893 c c ii 2, t INTERNAL SERVICE FUNDS OVERVIEW c a M N O N fC 3 L BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- o Q- INTERNAL SERVICE FUNDS 2/28/2023 2/28/2023 Q1 YTD W Fund Balance Cash Balance @ U c 511- EquipmentRental Fund $ 9,081,746 $ 4,991,951 $ (329,058; ii 512 -Technology Rental Fund 709,426 363,682 (295,740 21 t Total Internal Service Funds $ 9,791,173 $ 5,355,633 $ - $ (624,798 c 0 Z CO) N O N fC 3 L LL d E L V Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 35 Packet Pg. 90