The URL can be used to link to this page

2021-02-09 City Council - Full FIN Agenda-27901 o Agenda Edmonds City Council V,j Hv FINANCE COMMITTEE - SPECIAL ZOOM VIRTUAL ONLINE MEETING EDMONDS CITY COUNCIL MEETINGS WEB PAGE, HTTP://EDMONDSWA.IQM2.COM/CITIZENS/DEFAULT.ASPX, EDMONDS, WA 98020 FEBRUARY 9, 2021, 6:00 PM DUE TO THE CORONAVIRUS, MEETINGS ARE HELD VIRTUALLY USING THE ZOOM MEETING PLATFORM. TO VIEW OR LISTEN TO THE COMMITTEE MEETING IN ITS ENTIRETY, PASTE THE FOLLOWING 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 COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. CALL TO ORDER COMMITTEE BUSINESS 1. Edmonds Solar Cooperative Proposed Asset Purchase (10 min) 2. Close Fund 617, Firemen's Pension Fund (10 min) 3. Preliminary December 2020 Quarterly Financial Report (10 min) 4. 2021 Carryforward Budget Amendment (15 min) ADJOURN Edmonds City Council Agenda February 9, 2021 Page 1 2.1 City Council Agenda Item Meeting Date: 02/9/2021 Edmonds Solar Cooperative Proposed Asset Purchase Staff Lead: Phil Williams Department: Public Works & Utilities Preparer: Royce Napolitino Background/History The City of Edmonds entered into a ten year lease with the Edmonds Solar Cooperative in April, 2011. The Solar Cooperative installed and has since maintained a solar array with a 23 Kilowatt capacity on building roofs at the Anderson Center. The Solar Cooperative was given a six month lease extension in June of 2020 which extended their existing lease agreement ending 12/31/2020 to 7/1/2021 due to the Covid-19 pandemic. At this time the Solar Cooperative is looking for an opportunity to discontinue their business venture and sell this asset to the City. Staff Recommendation Authorize the purchase of and begin operating the solar installation at Frances Anderson Center. The payment can be made from the Capital Renewal funding available in the 2021 Facilities budget. Narrative The Edmonds Solar Cooperative have met their shareholder expectations and are currently trying to dissolve their business venture and have proposed to sell their remaining physical assets and records history to the City of Edmonds. The current valuation of the physical assets is $18,865 for the system. The current out put of the facility is 9.6 Kilowatts. The remaining 13.4 Kilowatt installation is proposed to be removed by the Solar Cooperative prior to any sale agreement ratification. Those panels are no longer productive. The asking price to the City for the remaining 9.6 kilowatt system is $5,000. Additional operational and maintenance costs will be incurred for the proposed 15 year remaining life of the assets. In addition, opportunities exist for expanding the system back to its original capacity when we see a good opportunity. There may be grant opportunities coming that could assist the City in this effort. Attachments: Solar Energy Facility Site Lease with amendment extension 6-1-2020 Correspondence with Solar Cooperative_p. williams_01-23-2021 Packet Pg. 2 2.1.a SOLAR ENERGY FACILITY SITE LEASE AGREEMENT (Frances Anderson Center Project) This SOLAR ENERGY FACILITY SITE LEASE AGREEMENT (this "Agreement') is made as of A Pet I 1 Z 12011 (the "Effective Date") by and between the CITY OF EDMONDS, W SHINGTON, an optional code City, organized under and by virtue of the laws of the State of Washington, whose address is 121 - 5th Avenue North, Edmonds, Washington 98020 ("Lessor"), and EDMONDS COMMUNITY SOLAR COOPERATIVE, a Washington Cooperative Association, located at 999 Northlake Way #301, Seattle, WA 98103 ("Lessee"), Each of Lessee and Lessor are sometimes individually referred to as "Party" and collectively as the "Parties." RECITALS A. Lessor is the owner of certain real property located in Snohomish County, Washington, together with certain improvements, buildings, and other structures, commonly known as "Anderson Center," as more particularly described and depicted on the attached Exhibit A and incorporated herein by this reference (the "Premises"). B. Lessee is the developer, owner, and operator of photovoltaic solar energy generation equipment and facilities suitable for delivery of electrical energy to be used on the Premises. C. Lessor and Lessee are parties to that certain Solar Power Energy Services Agreement dated of even date herewith (the "Solar Services Agreement"), pursuant to which Lessee (as Seller) has agreed to sell to Lessor, and Lessor (as Customer) has agreed to purchase from Lessee, all of the electrical energy produced by a Solar Energy Facility (or "SEF," as defined in the Solar Services Agreement) to be installed and operated on the Premises by Lessee. D. In furtherance of the Solar Services Agreement, Lessee desires to obtain from Lessor, and Lessor desires to grant to Lessee, a lease of the rooftop of the Anderson Center (the "Premises") and related access and use rights on, over, and across the Property for purposes of (i) constructing, installing, owning, and operating the SEF on the Premises, (ii) transmitting electrical energy to, on, over, and across the Anderson Center, and (iii) access to and egress from the Premises for the installation, operation, maintenance, and removal of the SEF. NOW, THEREFORE, in consideration of the foregoing and the mutual covenants and agreements herein contained, and intending to be legally bound hereby, Lessor and Lessee hereby agree as follows: (wSS840944,D0C-,1100006.900000\ } Packet Pg. 3 2.1.a AGREEMENT 1. Definitions and Interpretations. Capitalized terms not otherwise defined herein shall have the meanings assigned to then► in the Solar Services Agreement or in this Section 1. Titles and headings are included in this Agreement for convenience only, and shall not be used for the purpose of construing and interpreting this Agreement. Words in the singular also include the plural and vice versa where the context requires. "Business Day" means any day that is not a Saturday, Sunday, or holiday recognized by Lessor by ordinance. "Hazardous Material" means any substance, material, or waste that is now or hereafter classified as hazardous or toxic, or which is regulated under current or future federal, State, or local laws or regulations. "Payment Schedule" means that schedule attached to this Agreement and incorporated herein by this reference setting forth the consideration to be paid by Lessee to Lessor for the rights and easements set forth in this Agreement. "State" means the State of Washington. 2. Grant of Lease.. Purpose of Lease: Permitted Uses. 2.1 Lease and Confirmation. For good and valuable consideration, the receipt and sufficiency of which are hereby acknowledged by Lessor, Lessor hereby leases the Premises to Lessee. 2.2 Purpose of Lease. The lease created by this Agreement is solely and exclusively for solar energy —generation purposes, and throughout the Term (as defined in Sectian 3), Lessee shall have the exclusive right to use the Premises for solar energy generation purposes 2.3 Permitted Uses and Activities. The rights granted to Lessee in this Agreement permit Lessee to do the following: 2.3.1 Use the Premises and such other areas in and around the Premises as identified and depicted on the attached Exhibit A-2, incorporated herein by this reference (collectively, the "Project Area") for solar energy conversion, the collection and transmission of electrical energy to and from the SEF, and for related and incidental purposes and activities, including but not limited to locating, installing, operating, maintaining, improving, repairing, relocating, and removing the SEF on and from the Premises and to make such limited penetrations in the roof and roof structure (excluding any penetrations that would compromise —th"tructural integrity or watertight character of the Premises) as needed to nm wires and conduit from the SEF to the electrical panel and other areas on and within the Premises, in accordance with Lessee's plans and design pre -approved by Lessor in accordance with the Solar Services Agreement (collectively, "Operations"). [WSS840944.D0Q1\00006.900000\ ) 2 Packet Pg. 4 2.1.a 2.3.2 Park in designated areas on the Property; 2.3.3 Access the Project Area (including but not limited to access for lifting, rigging, and material -handling equipment), and access the SEF on, over, and across the Project Area; and 2.3.4 Construct, install, maintain, repair, and remove the SEF on the,Premises in the manner specifically set forth in the Solar Services Agreement; provided, however, that Lessee will not unreasonably interfere with Lessor's use, operation, or maintenance of the Property, the Premises, or any portion thereof. 2.4 Solar Covenant. Lessor hereby covenants to provide for the free passage of solar radiation to the SEF. Any obstruction to the passage of direct solar radiation across the Premises to the SEF by Lessor or a tenant or assignee of Lessor is prohibited. Except as specified on Attached Exhibit A, trees, structures, and improvements located on the Property as of the Effective Date shall be allowed to remain, and Lessee may not require their removal. Trees shown on Exhibit Ashall be maintained at and trimmed to the height shown on said Exhibit. Lessor shall not place or plant any trees, structures, or improvements on the Property after the Effective Date that may, in Lessee's sole judgment, impede or interfere with the passage of direct solar radiation to the SEF, unless Lessor has received prior written approval from Lessee for any such trees, structures, or improvements. Lessee and Lessor further agree to execute and record such instruments or addenda to this Agreement as may be required under applicable State or local law to evidence the solar covenant made in this Section 2.4. 3. 'Perm• Termination. The term of this Agreement shall commence on the Effective Date and shall expire on July 1, 2020 (the "Term"); provided however, unless Lessor has exercised its Buyout Option under Section 7.6 of the Solar Services Agreement, Lessee's right to access the Premises shall survive for a period of sixty (60) days following the expiration or earlier termination of this Agreement for the sole purpose of removing the SEF from the Premises. Without limiting the generality of the foregoing, if construction of the SEF does not commence on or before October 1, 2011, this Agreement shall terminate by its terms and shall be of no further force or effect, unless otherwise agreed in writing by the Parties. All construction and installation activities associated with the SEF shall be completed on or before December 31, 2012. Failure to complete construction and install shall trigger a default. Upon the expiration or earlier termination of the Solar Services Agreement, Lessee shall quitclaim and surrender to Lessor all of Lessee's right, title, and interest in and to the Premises by executing and recording a quitclaim deed or other instrument evidencing the termination of this Agreement. 4. Rent and Leasehold Excise Tax. As consideration for the rights and interests granted by Lessor under this Agreement, Lessee shall pay Lessor the amounts set forth on the rent schedule attached to this Agreement and incorporated herein by this reference (the "Rent Schedule"). Lessor and Lessee agree that the Rent Schedule shall be redacted for purposes of recording this Agreement in the real property records of Snohomish County, Washington, 5. The Lessee shall also pay leasehold excise tax if required by Chapter 82.29A RCW as now stated or hereafter amended. For purposes of leasehold excise tax, taxable rent for the lease {WSS640944.D0C;1\00006,900000\ } Packet Pg. 5 2.1.a space/area has been determined to be $249 per year. The leasehold excise tax rate at the time of execution of this agreement is 12.84%. The maximum rent Lessor may pay for a 75kW solar power system is $249 per year. 82.29A.130 (8) states that leasehold interests for which annual taxable rent is less than two hundred fifty dollars per year are exempt from Leasehold Exchise _ii _i_ �i_ r Ain nn 7_ ..L ..1 .1 ♦.. d. 41— T ax As a Iesult, Lessee shall also pay ule Lessor $0.00 her year In leasseholu excise tax uurrng ULV duration of the lease. Both taxable rent and leasehold excise tax rate shall be revised accordingly, if necessary, as a result of any amendment to Chapter 82.29A RCW and/or determination by any agency collecting or enforcing leasehold excise tax that additional amounts are owed. Lessee shall be responsible for and pay all past due leasehold excise tax, plus interest and penalties, if any, and all future leasehold excise tax owed under this agreement as determined by said agency pursuant to Chapter 82.29A RCW. Additional Rights of Lessee. 6.1 Temporary Construction Laydown Area. Lessor shall make available within the Project Area a temporary location for the assemblage of materials to construct, erect, and install the SEF (such area, a "Laydown Area") for a period not to exceed twenty (20) business days. Upon completion of construction and installation of the SEF, Lessee will remove all materials from the Laydown Area and will restore the Laydown Area to substantially the same condition in which it existed immediately prior to Lessee's use. 6.2 Signage. Lessee shall have the right to erect, modify, and maintain signage on the Premises with respect to the Solar Energy Facility and to Lessee's interests therein. Such signage shall be in the form, placed in the location, and according to the design set forth on the attached Exhibit C and incorporated herein by this reference. 7. Design and Construction of Solar Energy Facility, Acknowledgment of Lessor. 7.1 Design and Construction. Lessee shall mount the solar panels on ballast trays with concrete blocks and shall not physically attach the solar panels to the Premises; provided, however, Lessee may make limited penetrations of the Premises, as described in the Solar Services Agreement, to install, route, and maintain electrical wiring from the SEF to the Property. Structural evaluation will be provided by a licensed engineer. Any and all changes or deviations from approved plans and specifications set forth in the Solar Services Agreement shall require written notification to Lessor and Lessor's written prior approval, which approval shall not be unreasonably withheld. Lessee shall provide to Lessor a construction schedule, and Lessee and Lessor shall coordinate construction of the SEF so as to minimize disruption to the Property, the Premises, and Lessor's activities thereon. 7.2 Acknowledgment of Lessor. Lessor hereby consents to the construction of the SEF solely in accordance with the plans and specifications set forth on the attached Exhibit B. Lessor has provided data to Lessee concerning the construction, specifications, and condition of the Premises, and warrants that the data is accurate to the best of Lessor's knowledge. 7.3 Permits. Lessee shall be responsible for obtaining any and all governmental permits and approvals required prior to any construction activities. The Lessor will assist in the {WSS840944.1)OC;1\00006.9000tri1\ } 4 Packet Pg. 6 2.1.a preparation and presentation of an application for a certificate of appropriateness pursuant to Section 20.45,050 of the Edmonds Community Development Code. Nothing herein shall be deemed to waive or limit the quasi-judicial discretion of the City of Edmonds. 7.4 Roof Warranty Lessee shall assist in maintaining Roof Warranty converage by conducting its Solar Energy Facility construction and maintenance activities in accordance with written direction from the Roofing Manufacturer and Roofing Installer. Lessee shall additionally keep property liability insurance that supplements the roof warranty coverage as specified in Section 11. Maintenance of the Premises,• Security. 8.1 Maintenance. During the Term, Lessee shall, at Lessee's sole cost and expense, maintain the SEF and the Project Area in accordance with all applicable laws, rules, ordinances, orders, and regulations of all governmental agencies. 8.2 Clean Condition. Lessee shall not unreasonably clutter the Premises or the Project Area, and shall collect and dispose of any and all of Lessee's refuse and trash. 8.3 Security. Lessee shall provide all security measures that Lessor determines are or may be reasonably necessary for the SEF. Such measures may, but will not necessarily, include warning signs, closed and locked doors or gates, and other measures appropriate and reasonable to protect against damage or destruction of the SEF or injury or damage to persons or property resulting from the SEF and Operations. Lessee acknowledges that the Premises are part of a public building complex and no security measure taken by Lessee to secure the SEF on the Premises shall restrict public access to public areas or services on the Property. 9. Lessor's Representations alld Warranties. 9.1 Authority: No Third -Parma Rights. Lessor represents and warrants to Lessee that there are no circumstances known to Lessor and no commitments to third parties that may damage, impair, or otherwise adversely affect the SEF or its function by blocking sunlight to the SEF. Lessor covenants that Lessor has lawful title to the Property and full right to enter into this Agreement. 9.2 No Interference. Lessor hereby agrees, for itself, its agents, employees, representatives, successors, and assigns, that it will not initiate or conduct activities that it knows or reasonably should know may damage, impair, or otherwise adversely affect the SEF or its functions, including without limitation activities that may adversely affect the SEF's exposure to sunlight. Lessor further covenants for itself and its agents, employees, representatives, successors, and assigns that it will not (i) materially interfere with or prohibit the free and complete use and enjoyment by Lessee of its rights granted under this Agreement; (ii) take any action that will materially interfere with the availability and accessibility of solar radiation over and above the Premises; (iii) take any action that will or may materially interfere with the transmission of electrical energy to or from the Premises; (iv) take any action that may impair Lessee's access to the Premises for the purposes specified in this Agreement; (v) plant or [WSS840944.DOC:1\00006.900000\ } Packet Pg. 7 2.1.a maintain any vegetation or erect or maintain any structure that will, during daylight, cast a shadow on the SEF; or (vi) take any action that may impair Lessee's access to any portion of the SEF. r--- r i__ ri__�_ i 1.... ,....1 ...1 ...,� U 9.3 SE Property US Lessee; T rays"IC- of the Property. Lessor acui�wi�.urC� —►A P Y-- - agrees that Lessee is the exclusive owner and operator of the SEF, that no portion or component of the SEF is a fixture, and that the SEF may not be sold, leased, assigned, mortgaged, pledged, or otherwise alienated or encumbered with the conveyance of any fee or leasehold interest in or to the Property (any such conveyance, a "Transfer"). Lessor shall give Lessee at least ten (10) Business Days' written notice prior to any Transfer of all or any portion of the Property. Any such notice shall identify the transferee, the portion of the Property to be transferred, and the proposed date of the Transfer. This Agreement and the lease and rights granted to Lessee herein shall survive any Transfer. 10. Default: Remedies. 10.1 Lessee Default. The following events shall be defaults with respect to Lessee (each, a "Lessee Default"): 10.1.1 Lessee breaches any material term of this Agreement, and (A) if such breach is capable of being cured within thirty (30) days after notice from Lessor of such breach, Lessee has failed to cure the breach within such thirty (30) day period, or (B) if Lessee has diligently commenced work to cure such breach during such thirty (30) day period but such breach is not capable of cure within such period, Lessee has failed to cure the breach within a further thirty (30) day period (such aggregate period not to exceed sixty (60) days from the date of Lessor's notice). 10.1.2 Lessee makes an unauthorized roof penetration; 10.1.3 (A) Lessee commences a voluntary case under any bankruptcy law; (B) Lessee fails to controvert in a timely and appropriate manner, or acquiesces in writing to, any petition filed against Lessee in an involuntary case under any bankruptcy law; or (C) any involuntary bankruptcy proceeding commenced against Lessee remains undismissed or undischarged for a period of sixty (60) days. 9.1.4 Lessee fails to complete construction and installation of the SEF in accord with Section 3, 9.1.2 or 9.1.3. 10.2 Lessor's Remedies. If a Lessee Default described in Section 9.1.2 has occurred, this Agreement shall terminate automatically (without requirement of notice). if a Lessee Default described in Section 9.1.1 has occurred and is continuing, Lessor may terminate this Agreement by written notice to Lessee following the expiration of the applicable cure period. In the event of a Lessee Default, Lessor may also exercise any other remedy it may have at law or equity. In addition to any such remedy at law, Grantor may elect to take possession of the SEF and all equiment and accessories thereto if Grantee defaults as provided in Section 9.1 and the subsections thereof. f WSS840944.DOC;1\00006.900000\ ] Packet Pg. 8 2.1.a 10.2.1 Bond for removal. Grantee shall bond in a fonn approved by the Grantor in the sum of the estimated removal cost at the system's installed size for the purpose of covering all costs associated with removal of SEF and restoration of the Premises to their pre-existing condition in the event of default by Lessee and/or termination for cause by Lessor. 10.3 Lessor Defaults. The following events shall be defaults with respect to Lessor (each, a "Lessor Default"): 10.3.1 Lessor breaches any material term of this Agreement, and (A) if such breach is capable of being cured within thirty (30) days after Lessee's notice of such breach, Lessor has failed to cure the breach within such thirty (30) day period, or (B) if Lessor has diligently commenced work to cure such breach during such thirty (30) day period but such breach is not capable of cure within such period, Lessor has failed to cure the breach within a further thirty (30) day period (such aggregate period not to exceed sixty (60) days from the date of Lessee's notice); 10.3.2 (A) Lessor commences a voluntary case under any bankruptcy law; (B) Lessor fails to controvert in a timely and appropriate manner, or acquiesces in writing to, any petition filed against Lessor in an involuntary case under any bankruptcy law; or (C) any involuntary bankruptcy proceeding commenced against Lessor remains undismissed or undischarged for a period of sixty (60) days. 10.4 Lessee's Remedies. If a Lessor Default described in Section 9.3.1 or 9.3.2 has occurred and is continuing, Lessee may terminate this Agreement immediately upon the expiration of the respective cure periods set forth in such provisions, and in addition to any other remedy hereunder, Lessee may terminate the Solar Services Agreement and pursue all available remedies thereunder. In addition, upon a Lessor Default, Lessee may pursue any other remedy given under this Agreement or now or hereafter existing at law or in equity or otherwise. 11. insurance. At all times during the term of this Agreement, Lessee and Lessor shall each, at its own respective cost and expense, obtain and maintain in effect the insurance policies and limits set forth in the Solar Services Agreement. 12. Liability: Indemnity. The Parties agree to indemnify and hold each other harmless from any claim, loss or litigation of any kind or nature arising from or out of the performance or execution of any term of this Agreement. The "Parties" shall mean the officers, agents, and employees of each party. This right of indemnification shall include any tortious or criminal act as well as acts of negligence committed by a party, its officers, agents, or employees. To the extent necessary to fully enforce this Agreement, each party waives any immunity which it may have under Title 51 RCW. 13. NO CONSEQUENTIAL DAMAGES. NOTWITHSTANDING ANY PROVISION IN THIS AGREEMENT TO THE CONTRARY, NEITHER LESSEE NOR LESSOR SHALL BE LIABLE TO THE OTHER FOR INCIDENTAL, CONSEQUENTIAL, SPECIAL, PUNITIVE, OR INDIRECT DAMAGES, ARISING OUT OF THIS AGREEMENT. THE FOREGOING PROVISION SHALL NOT PROHIBIT LESSEE OR {WSS940944.DOC;1\00006.900000\ 1 Packet Pg. 9 2.1.a LESSOR FROM SEEKING AND OBTAINING GENERAL CONTRACT DAMAGES OR EQUITABLE RELIEF FOR A BREACH OF THIS AGREEMENT. 14. Hazardous Materials. 14.1 Lessor shall not violate, and shall indemnify Lessee for, from, and against, any claims, costs, damages, fees, or penalties arising from a violation (past, present, or future) by Lessor or Lessor's agents or contractors of any federal, State, or local law, ordinance, order, or regulation relating to the generation, manufacture, production, use, storage, release or threatened release, discharge, disposal, transportation, or presence of any Hazardous Material on or under the Property. 14.2 Lessee shall not violate, and shall indemnify Lessor against, any claims, costs, damages, fees, or penalties arising from a violation by Lessee or Lessee's agents or contractors of any federal, State, or local law, ordinance, order, or regulation relating to the generation, manufacture, production, use, storage, release or threatened release, discharge, disposal, transportation, or presence of any Hazardous Material on or under the Property. 15. Estoppel Certificate. From time to time, upon written request by Lessee, Lessor shall provide within seven (7) days thereafter an estoppel certificate attesting, to the knowledge of Lessor, of Lessee's compliance with the terms of this Agreement, or detailing any known issues of noncompliance. 16. Assignment; Successors quid Assigns', A reernent to Run With Property, Except as provided in this Section 15, neither Party shall have the right to assign any of its rights, duties, or obligations under this Agreement without the prior written consent of the other Party, which consent may not be unreasonably withheld or delayed. Lessee may assign any of its rights, duties, or obligations under this Agreement, without the consent of Lessor, (i) to one or more third parties in connection with a financing transaction or (ii) to any Person succeeding to all or substantially all of the assets of Lessee. Lessor agrees that this Agreement and the lease and rights granted to Lessee in Section 2 shall run with the land and survive any transfer or conveyance of the Property. 17. Notice and Notices. 17.1 Notice. Except as may be required by an emergency, Lessee will give Lessor reasonable written or telephonic noticed before any entry onto the Premises by Lessee's employees, agents, or contractors. In the event of Lessee's entry due to an emergency, Lessee will promptly notify Lessor of its entry and the nature of the emergency. 17.2 Addresses for the Delivery of Notices. Any notice required, permitted, or contemplated hereunder shall be in writing, shall be addressed to the Party to be notified at the address set forth below or at such other address or addresses as a Party may designate for itself from time to time by notice hereunder. Such notices may also be sent by fax transmission: Notice to Lessor: Notice to Lessee: [WSS840944.DOC;1\00006.900000\ } Packet Pg. 10 2.1.a City Clerk Sandra S. Chase CITY OF EDMONDS 121 - 5th Avenue North Edmonds WA 98020 425-775-2525 Fax: 425-771-0252 Chris Herman EDMONDS COMMUNITY SOLAR COOPERATIVE 999 N. Northlake Way #301 Seattle, WA 98103 Ph:(206) 525-3969 Fax: (206) 973-5385 17.3 Chan&e of ReciQient or Address. Either Party may, by notice given at any time or from time to time, require subsequent notices to be given to another individual Person, whether a party or an officer or representative, or to a different address, or both. Notices given before actual receipt of notice of change shall not be invalidated by the change. 18. Miscellaneous, 18.1 Further Assurances. Upon the receipt of a written request from the other Party, each Party shall execute such additional documents, instruments, and assurances and take such additional actions as are reasonably necessary and desirable to carry out the terms and intent hereof. Neither Party shall unreasonably withhold, condition, or delay its compliance with any reasonable request made pursuant to this Section 17.1. 18.2 Quiet Enjoyment. Lessor covenants and warrants that Lessee shall peacefully hold and enjoy all of the rights granted by this Agreement for its entire Term without hindrance or interruption by Lessor or any person lawfully or equitably claiming by, through, under or superior to Lessor subject to the terms of this Agreement. 18.3 No Partnership or Sale. Nothing contained in this Agreement shall be deemed or construed by the Parties or by any third person to create the relationship of principal and agent, partnership, joint venture, buyer and seller of electrical energy, or any other association between Lessor and Lessee, other than the relationship of Lessor and Lessee. 18.4 Severabilit . In the event that any provisions of this Agreement are held to be unenforceable or invalid by any court or regulatory agency of competent jurisdiction, Lessor and Lessee shall negotiate an equitable adjustment in the provisions of this Agreement with a view toward effecting the purposes of this Agreement, and the validity and enforceability of the remaining provisions shall not be affected by it. 18.5 HeadingA. The headings in this Agreement are solely for convenience and ease of reference and shall have no effect on interpreting the meaning of any provision of this Agreement 18.6 Time of Essence. Times is of the essence in the performance of this Agreement. 18.7 Recordation. Lessee may, at its sole cost and expense, record in the real property records of Snohomish County, Washington, this Agreement provided that all payment terms shall be redacted for such recording purposes. { WSS840944.DOC;1\00006.900000\ 1 9 Packet Pg. 11 2.1.a 18.8 Amendments. This Agreement may be amended only in writing signed by Lessee and Lessor, or their respective successors in interest. 18.9 Cotinte, xparts. This Agreement may be executed in two or more counterparts, each of which shall be deemed an original, but all of which together shall constitute one and the same agreement. 18.10 Sindiix$ Effect. This Agreement and the rights, privileges, duties, and obligations of the Parties as set forth herein shall inure to the benefit of and be binding upon each of the Parties, together with their respective successors and assigns. 18.11 Entire A reement• Waivers. This Agreement constitutes the entire agreement between the Parties and supersedes the terms of any previous agreements or understandings, oral or written. Any waiver of this Agreement must be in writing. Either Party's waiver of any breach or failure to enforce any of the terms of this Agreement shall not affect or waive that Party's right to enforce any other term of this Agreement. [SIGNATURE PAGES FOLLOW] Ws5840944.DOC;1100006.900000\ 1 10 Packet Pg. 12 2.1.a IN WITNESS WHEREOF, the Parties have executed this Agreement as of the Effective Date. LESSOR: LESSEE: CITY OF EDMONDS EDMONDS COMMUNITY SOLAR COOPERATWVE, a Washington Cooperative Association By: By: Mayor Mike Cooper r1s Herman Its: President & Chairperson ATTEST/AUTHENTICATED: By: .d e4 Saltdra S. Chase, City Cleric APPROVED AS TO FORM: Office of the City Attorney By: Jeffery Taraday ( WSSS40944.DOC;1\00006.900000% ) 11 Packet Pg. 13 2.1.a EXHIBIT A DESCRIPTION AND DEPICTION OF PROPERTY & PROJECT AREA Frances Anderson Center, 700 Main Street, Edmonds WA, 98020 Potential locations of solar equipment highlighted in Red Squares {WSS840944.DOC;1\00006.900000\ ) Exhibit A Packet Pg. 14 2.1.a Narrative The total area of the 5 roofs (3 of SW classroom wing (7296 sf) & 2 due south of tall building section (2730 sf)) that we need for the arrays is 10,026 sq. ft. We will not be able to use all of it due to some side shading from the tall section, south shading by the clerestory on the northernmost classroom roof and some mechanical features but we need to have use of it all for staging and wiring and access. There are 5 trees on the south side of the classroom wing, numbered 1-5 starting at the west end and moving east. Tree 1 is 10' from the building and sticks up approximately 10' above the roof. It needs to be trimmed to no more than 3'6" above the roof which means trimming approximately 6' off the top. It has been previously trimmed to that level. Tree 2 is 5' from the building and sticks up approximately 6' above the roof. It needs to be trimmed to no more than 1'6" above the roof which means trimming approximately 4' off the top, Trees 3,4,5 are 17' from the building and stick up approximately 6' above the roof and do not require trimming but will need to be maintained at that level to avoid shading the southernmost solar array on the classroom wing. All 5 trees are small and will not be difficult to trim or maintain. t 2 o' t!'A r"E I"i I C- . . WtN 1 90 '�'scALffi l�'' F 7 •_ �, �r G- �' rtia a0r,Pq Iit` Ic s►r5 d 1?�M Tim N 4 A FF�•x . Pr'IA I Nrd1M '5 G ° L ,QHrr f 19.'R I fig 7F•� kkW T�k� �,4, r- t �, Fi NI SH t a {WSS840944.DOC;1\00006.900000\ ] Exhibit C Packet Pg. 15 2.1.a EXHIBIT B SOLAR ENERGY FACILITY SPECIFICATIONS Up to 75kW Solar Facility Design Plan to be provided by the Cooperative after Solar Site Design is Completed by its chosen vendor. City of Edmonds Facilities Personnel will have prior approval of the design and location of all equipment to be installed at the Frances Anderson Center. City approval of the design of the SEF will not be unreasonably withheld. {wss840944.DOQ11(0006.90WO A I Exhibit C Packet Pg. 16 2.1.a EXHIBIT C FORM AND DESIGN OF LESSEE'S SIGNAGE To be provided by the Cooperative after Solar Site Design is Delivered. City of Edmonds will have prior approval of format, content and location of all signage, Approval by the City will not be unreasonably withheld. iwsssaogaa.Wc:iw0006MoarxA i F xhibit C Packet Pg. 17 2.1.a EXHIBff D RENT SCHEDULE Edmonds Community Power Cooperative shall pay to the City of Edmonds an annual lease payment of $249. The lease payment will .be due within 10 days of the beginning of each year this contract is in force. iwss84n9d4.00c;tux 06-'xxxW 1 Exhibit D Packet Pg. 18 2.1.a Z Originator: O Department/Division: I~ a W Name of Consultant/Contractor run CONTRACT TITLE: W C No. 20200616 (City Clerk Use Only) CONTRACT ROUTING FORM t "`U.VI / Routed by: v" ,-c Type of Contract: (GR) Grants ❑ (1) Intergovernmental Agreement Z ❑ Z (S) Purchase of Services (W) Public Works W Z Bid/RFP Number: O / u Effective Date: l I (o 7y'Lo 0 Has the original City contract boilerplate language been modified? F If yes, specify which sections have been modified: ZO Description u of Services: Total Amount of Contract: Budget # rn J Budget # W G g Budget # u ZAre there sufficient funds in the current budget to cover this contract. Z Remarks: L (L) Lease Agreement (0) Other Completion Date: -4�..c Yes ©No 07/01 /21 Amount; Amount: Amount: ? E) Yes ©No Authorization Level: Director W j 1. Project Manager & City Council Approval Q 2, Risk Management/Budget Date (if applicable) Z 3, City Attorney ❑ 7. Mayor 4, Consultant/Contractor 8. City Clerk 5. Other Packet Pg. 19 2.1.a AMENDMENT NO. 1 TO SOLAR ENERGY FACILITY SITE LEASE AGREEMENT (Frances Anderson Center Project) WHEREAS, the City of Edmonds, a Washington municipal corporation ("Lessor"), and the Edmonds Community Solar Cooperative ("Lessee"), entered into an underlying Solar Energy Facility Site Lease Agreement dated April 12, 2011 ("Lease"); and WHEREAS, the Lease is for the location of a solar energy facility on the rooftop of the Frances Anderson Center for solar energy generation purposes to facilitate a Solar Services Agreement between the parties; and WHEREAS, the term of the Lease began on April 12, 2011 and is set to expire on July 1, 2020; and WHEREAS, the Lessor and Lessee have been in discussions regarding the future of the Solar Services Agreement, which may require an extension of the Lease; and WHEREAS, due to the ongoing COVID-19 pandemic and the related restrictions on City Council meetings created by Governor Inslee's Proclamation 20-28, which allows only remote public access to City Council meetings and therefore restricts meeting topics to only those matters that are "necessary and routine" or are necessary to respond to the COVID-19 outbreak, the parties have agreed to extend the Lease to allow time for the City Council to consider any recommendations relating to the Solar Services Agreement and related Lease; and WHEREAS, the Lessor and the Lessee have agreed to extend the expiration date of the underlying Lease to December 31, 2020, with the option to extend the Lease an additional six months, through July 1, 2021, should additional time be needed by the parties to finalize discussions on the Lease and the related Solar Services Agreement; NOW, THEREFORE, in consideration of the mutual benefits accruing, it is agreed by and between the parties thereto as follows: 1. The underlying Lease of April 12, 2011 between the parties, which is incorporated by this reference as if fully set forth herein, is amended in, but only in, the following respect: 1.1 Term of Lease. Section 3 of the Lease shall be revised to read as follows: 3. Term: Termination. The term of this Agreement shall commence on the Effective Date and shall expire on December 31, 2020 (the "Term"), which expiration date shall be extended to July 1, 2021 upon written agreement of the Parties; provided however, unless Lessor has exercised its Buyout Option under Section 7.6 of the Solar Services Agreement, Lessee's right to access the Premises shall survive for a period of sixty (60) days following the expiration or earlier termination of this Agreement for the sole purpose of removing the SEF from the Premises. Without limiting the generality of the foregoing, if construction of the SEF does not Packet Pg. 20 2.1.a commence on or before October 1, 2011, this Agreement shall terminate by its terms and shall be of no further force or effect, unless otherwise agreed in writing by the Parties. All construction and installation activities associated with the SEF shall be completed on or before December 31, 2012. Failure to complete construction and install shall trigger a default. Upon the expiration or earlier termination of the Solar Services Agreement, Lessee shall quitclaim and surrender to Lessor all of Lessee's right, title, and interest in and to the Premises by executing and recording a quitclaim deed or other instrument evidencing the termination of this Agreement. 2. In all other respects, the underlying Lease between the parties shall remain in full force and effect, amended as set forth herein, but only as set forth herein. DATED this IOth day of July 2020. LESSOR: CITY OF EDMONDS Michael Nelson, Mayor ATTEST/AUTHENTICATED: Scott Passey, City Clerk APPROVED AS TO FORM: Office of the City Attorney LESSEE: EDMONDS COMMUNITY SOLAR COOPERATIVE Printed Name: Title: Packet Pg. 21 2.1.a STATE OF WASHINGTON) )ss COUNTY OF ) On this day of 2020, before me, the under -signed, a Notary Public in and for the State of Washington, duly commissioned and sworn, personally appeared , and executed the foregoing instrument, and acknowledged the said instrument to be his/her free and voluntary act and deed for the uses and purposes therein mentioned, and on oath stated that he/she was authorized to execute said instrument. WITNESS my hand and official seal hereto affixed the day and year first above written. NOTARY PUBLIC My commission expires: Packet Pg. 22 Sullivan, Thom From: Williams, Phil Sent: Saturday, January 23, 2021 7:17 PM To: Carlo Voli Cc: Sullivan, Thom Subject: Re: Solar system on Frances Anderson center Carlo, Thanks for your efforts and creativity in putting this together. I like this idea and will get this in front of the necessary people for review and get back to you as quick as I can. If we have questions you'll hear even sooner. Thanks Thom - let's discuss Sent from my iPhone On Jan 22, 2021, at 5:50 PM, Carlo Voli <carlovoli@yahoo.com> wrote: Hi Phil, Just checking in to make sure you got the email below I sent earlier this week. Thanks and have a great weekend, Carlo On Monday, January 18, 2021, 02:23:42 PM PST, Carlo Voli <carlovoli@yahoo.com> wrote: Hello Phil, Hope you've had a good transition into the new year. We've finally ran the numbers and have a very generous offer for the city to purchase the solar array on top of the Frances Anderson Center, which would allow the city to break even on power bill savings at 10% discount rate for the next 15 years (taking into account the cost of expected inverter replacement during the 15 years remaining lifespan of the 9.6 kW solar array) The solar system is currently 23KW. Due to the ongoing degradation of some of the Silicon Energy panels, the cooperative is planning to have all the Silicon Energy panels removed. This would leave a solar system of 9.6 kW, composed exclusively of Itek solar panels. The valuation for a new 9.6 kW solar system is $28,926 The valuation for a 10-year-old 9.6 kW solar system (as the one at the Frances Anderson Center) is around $18,865 Our offer to the city of Edmonds for the purchase of the 10-year-old 9.6 kW solar system is $5,000 (which as I mentioned earlier, would allow the city to break even on power bill savings at 10% discount rate for the next 15 years). Packet Pg. 23 To: Napolitino, Royce<Royce.Napo Iitino@edmondswa.gov> Subject: Re: Solar system on Frances Anderson center Go ahead and forward the data to him. I think his only interest is the cost per kilowatt hour for the facility under PUD's schedule 25 1 believe. Sent from my iPhone On Oct 20, 2020, at 7:00 AM, Napolitino, Royce<Royce.Napolitinoaedmondswa.gov> wrote: Phil I returned to my scanned files to retrieve the last three invoices from PUD at the Anderson Center. Please note, these expenses are down nearly $1000 a month now with the programming and recreation that is not happening in the Anderson Center. Note the important message, as well. "... your net metering reserve balance ... minimum charge based on the connected load." I didn't know if that was part of your consideration. I did not include Carlo Voli in this thread. He has yet to receive any information from me in this regard. Find the information attached, Royce Napolitino w 425.771.0235, Ext 1235 From: Williams, Phil <Phil.Wllliams edmondswa. ov> Sent: Sunday, October 18, 2020 1:30 PM To: Napolitino, Royce <Royce.NapolitinoC7edmondswa.gov> Cc: carlovoli(a7�yahoo.com Subject: FW: Solar system on Frances Anderson center Royce — can you send Carlo a copy of our last couple bills from SnoPUD for Anderson Center electric? Thanks Packet Pg. 24 2.2 City Council Agenda Item Meeting Date: 02/9/2021 Close Fund 617, Firemen's Pension Fund Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History We plan to submit a budget amendment in April to close out Fund 617. Staff Recommendation Today is for initial presentation to the Finance Committee and is for discussion only. Narrative: Fund 617 - Firemen's Pension Fund was established as a fiduciary fund to provide retirement pension and medical benefits to retired City firefighters who left service prior to the establishment of the statewide Law Enforcement Officer and Fire Fighter (LEOFF) retirement system. Revenue sources for this fund are General Fund transfers, Interest income, and proceeds from a tax placed by the State on fire insurance premiums. The State Auditor's Office (SAO) has recently come out with revised guidelines on how the tax on fire insurance premiums should be recorded for accounting purposes. Rather than being considered revenue to the Firemen's Pension Fund, the SAO has advised us that the premium tax is now considered revenue to the General Fund. With this new guideline in place, all of the revenue sources for this fund are now general fund dollars, and as such this fund can no longer be classified as a Fiduciary Fund. Instead, all revenues and expenses need to be recorded in the General Fund. As part of the First Quarter budget amendment in April, we plan to submit a decision package that will allow us to close out Fund 617 and move the cash and budget authority currently in that fund to the General Fund. The purpose for adding this to today's agenda is to give Finance Committee members notification before we submit the request in April, in order to give you ample time to gain a full understanding of the request in advance. Packet Pg. 25 2.3 City Council Agenda Item Meeting Date: 02/9/2021 Preliminary December 2020 Quarterly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Review and put on February 16 consent agenda Narrative Preliminary December 2020 Quarterly Financial Report Attachments: Complete December 2020 Quarterly Financial Report Jan -Dec 2020 P&L Revised Packet Pg. 26 2.3.a INSIDE THIS ISSUE: Revenues By Fund Summary Expenditures By Fund Summary General Fund Revenues Expenditures By Fund Detail Gen. Fund Depart- ment Expenditures Investment Portfolio Fund Balance Overview Below: The 2020 Presiden- tial election will have a big impact on local governments. Summary of Operating Funds: Revenues This report is a summary of the City's preliminary 2 operating results for the twelve months ended December 31,2020. Revenue Highlights: • The coronavirus pandemic 3 continues to have devastat- ing effects on the local and national economies, with 6 many area governments ex- periencing General Fund revenue declines of 15% or 12 more. Fortunately, Ed- monds is faring better than 32 most of our neighbors. • Overall General Fund revenues of 34 $41.7 million are only 6% behind budget. The majority of this reduc- tion is from Parks and Rec pro- grams not operating, school pro- grams being closed, and reduc- tions in traffic and parking fines. -ELECTI 21RS Collections of Retail Sales Taxes have remained strong. Year to date Sales Tax revenues are only be- hind our budgeted amount and last year's actual collections by 1.6%. This year's collections of $8.32 million are only $135,669 less than last year (page 3). This contrasts — significantly with IVour neighboring cities, some of whom are experi- encing 10% - 15% reductions in sales tax revenues for 2020. Above: The City of Edmonds has distrib- uted close to $2 million in reliefgrants to local businesses and individuals affected by the Pandemic. Revenues by Category: General Fund revenues for 2020 are high- er than 2019 in the category of Intergov- ernmental Revenues —mostly due to the receipt of CARES funds. General Fund revenues are lower than last year at this time in the categories of Taxes, Licenses and Permits; Charges for Goods and Ser- vices; Fines and Penalties; and Other Mis- cellaneous revenues. Considering the devastating effect the Coronavirus has had on the economy, Ed- monds' revenue situation remains favora- ble by comparison. A more detailed breakdown of infor- mation for City revenues can be found be- ginning on page 3. Preliminary Financial Management Report as of December 31- 2020 Packet Pg. 27 2.3.a Top: The City has given away thousands of compostable containers to local restaurants. Take- out is key to their economic survival and the City is doing what it can to make it more sustainable. Right: Whitney Rivera, a graduate of Edmonds-Woodway High School, the University of Wash- ington, and Boston College Law School, was ap- pointed to be the new Edmonds Municipal Court Judge, replacing Judge Linda Co- burn. Judge Rivera comes most recently from the Snohomish County Public De- fender Association. Welcome Judge Rivera! r", , , , , , , , , "*** Summary of Operating Funds: Expenditures General Fund expenditures for the year ended December 31 are $44.0 million, or a full 12% under the budgeted amount, a good indi- cation that the city will be able to live within its means during the current recession. I General Fund expenses by sub - fund and line item categories are on page 6 and expenses by depart- ment are on pages 13-16. Every department in the General Fund is at or near budget at year-end, and I the General Fund as a whole has spent only 88% of its annual budget. This same information I can be found in graphical form on pages 23-31. I • Special Revenue Funds during the year have only spent 66% of their annual expense budget. This is I partly due to impacts from COVID, but the majority of the underspending comes from REET I funds ($2.99 million less than budget). Much of this is because a major capital project (Civic Field) was placed on hold. Additional Special Reve- nue Fund expenditure in- formation can be found on pages 6-8. • The total fund balance for the General Fund and Sub -funds at December 31, 2020 is $16.76 million, or approximately 34% of the 2020 expenditure budget for those funds. Other City Highlights • During 2020 the City distributed nearly $2 mil- lion in CARES funds to local businesses and indi- viduals. Much of this has been earmarked for grants to the City's most vulnerable residents, in- cluding lower income residents who are the most hard hit by unemploy- ment and increased expenses brought on by the crisis. Whitney Rivera Preliminary Financial Management Report as of December 31- 2020 Packet Pg. 28 I 2.3.a I Page 1 of 1 C PTY OF EDMO NDS REVENUES BY FUND - SUMMARY Fund 2020 Amended 12/31/2019 12/31/2020 Amount No. Title Budget Revenues Revenues Remaining %Receive, 001 GENERAL FUND $ 44,055,157 $46,897,549 $ 41,660,318 $ 2,394,839 95 009 LEOFF-MEDICAL INS. RESERVE 437,980 425,000 425,000 12,980 97 O l l RISK MANAGEMENT RESERVE FUND - - ot - 0 012 CONTINGENCY RESERVE FUND 56,140 30,905 56,140 0 014 HISTORIC PRESERVATION GIFT FUND 5,230 5,000 5,000 230 96 017 MARSH RESTORATION & PRESERVATION FUND - 555,312 125 (125) 0 104 DRUG ENFORCEMENT FUND 165,390 39,507 64,717 100,673 39 Ill STREET FUND 1,913,184 1,886,681 1,908,707 4,477 100 112 COMBINED STREET CONST/IMPROVE 2,841,881 2,703,228 2,030,205 811,676 71 117 MUNICIPAL ARTSACQUIS. FUND 264,200 120,818 89,600 174,600 34 118 MEMORIAL STREET TREE 750 705 536 214 72 120 HOTEL/MOTEL TAX REVENUE FUND 98,630 102,975 66,287 32,343 67 121 EMPLOYEE PARKING PERMIT FUND 27,270 34,697 21,261 6,009 78 122 YOUTH SCHOLARSHIP FUND 1,790 1,211 747 1,043 42 123 TOURISM PROMOTIONAL FUND/ARTS 34,450 34,785 22,536 11,914 65 125 REAL ESTATE EXCISE TAX 2 1,436,090 1,572,421 1,742,948 (306,858) 121 126 REAL ESTATE EXCISE TAX 1 1,453,520 1,586,136 1,736,009 (282,489) 119 127 GIFTS CATALOG FUND 145,050 116,131 55,392 89,658 38 130 CEMETERY MAINTENANCE/IMPROVEMT 184,610 236,723 126,191 58,419 68 136 PARKS TRUST FUND 6,390 5,904 4,420 1,970 69 137 CEMETERY MAINTENANCE TRUST FD 54,210 58,093 41,994 12,216 77 138 SISTER CITY COMMISSION 10,380 8,831 302 10,078 3 140 BUSINESS IMPROVEMENT DISTRICT 79,209 86,026 75,746 3,463 96 141 AFFORDABLE AND SUPPORTIVE HOUSINGFUND - 112 71,633 (71,633) 0 142 EDMONDS CARES FUND 1,860,000 - 1,775,500 84,500 95 211 L.I.D. FUND CONTROL 12,400 30,893 - 12,400 0 231 2012 LT GO DEBT SERVICE FUND 738,400 716,398 738,385 15 100 332 PARKS CAPITAL CONSTRUCTION FUND 1 9,638,306 4,535,024 1,547,100 8,091,206 16 411 COMBINED UTILITY OPERATION - - 32,495 (32,495) 0 421 WATER UTILITY FUND 11,121,042 9,940,889 10,029,572 1,091,470 90 422 STORM UTILITY FUND 2 6,745,424 5,218,370 5,660,499 1,084,925 84 423 SEWER/WWTP UTILITY FUND 3 25,279,820 14,130,995 30,703,680 (5,423,860) 121 424 BOND RESERVE FUND 1,988,100 1,991,199 1,988,096 4 100 511 EQUIPMENT RENTAL FUND 1,801,427 1,881,899 1,821,593 (20,166) 101 512 TECHNOLOGY RENTAL FUND 1,265,219 1,108,644 1,275,841 (10,622) 101 617 FIREMEN'S PENSION FUND 72,620 69,837 55,388 17,232 76 $ 113,794,269 $ 96,132,897 $ 105,777,822 $ 8,016,447 93 Difference primarily due to the Edmonds Waterfront Development Grant received in July of 2020. 2 Difference primarily due to a 9.5%increase in storm rate. 3 Differences primarily due to $13.910 bond proceeds received in November of 2020, as well as WWTP billings to their partners. 1 Packet Pg. 29 1 I 2.3.a I Page 1 of 1 CITY O F EDMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2020 Amended 12/31/2019 12/31/2020 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 49,365,292 $ 42,573,794 $ 44,014,931 $ 5,350,361 89 009 LEOFF-MEDICAL INS. RESERVE 467,140 402,572 243,697 223,443 52 011 RISK MANAGEMENT RESERVE FUND - 931,523 - - C 012 CONTINGENCY RESERVE FUND - 3,835,827 - C 014 HISTORIC PRESERVATION GIFT FUND 5,900 5,533 5,900 C 018 EDMONDS HOMELESSNESS RESPONSE FUND 100,000 1,862 100,000 - 10C 019 EDMONDSOPIOID RESPONSE FUND 21,555 200,000 21,555 - 10C 104 DRUG ENFORCEMENT FUND 45,800 - 30,332 15,468 66 111 STREET FUND 2,200,133 1,959,740 2,076,224 123,909 94 112 COMBINED STREET CONST/IMPROVE 2,811,463 1,924,403 1,393,957 1,417,506 5C 117 MUNICIPAL ARTS ACQUIS. FUND 244,504 63,161 36,493 208,011 15 120 HOTEL/MOTEL TAX REVENUE FUND 128,250 95,008 92,677 35,573 72 121 EMPLOYEE PARKING PERMIT FUND 26,880 25,681 632 26,248 2 122 YOUTH SCHOLARSHIP FUND 3,000 2,768 450 2,550 15 123 TOURISM PROMOTIONAL FUND/ARTS 33,900 31,980 15,510 18,390 46 125 REAL ESTATE EXCISE TAX 2 3,610,520 1,249,293 1,991,212 1,619,308 55 126 REAL ESTATE EXCISE TAX 1 3,401,093 1,730,062 2,030,921 1,370,172 6C 127 GIFTSCATALOGFUND 113,782 82,091 87,919 25,863 77 130 CEMETERY MAINTENANCE/IMPROVEMT 195,787 191,135 180,098 15,689 92 136 PARKS TRUST FUND - 4,935 - - C 138 SISTER CITY COMMISSION 11,900 6,894 11 11,889 C 140 BUSINESS IMPROVEMENT DISTRICT 80,510 98,578 67,611 12,899 84 142 EDMONDS CARES FUND 1,860,000 - 1,775,326 84,674 95 211 L.I.D. FUND CONTROL 12,400 30,905 - 12,400 C 231 2012 LT GO DEBT SERVICE FUND 738,400 716,398 738,385 15 10C 332 PARKS CAPITAL CONSTRUCTION FUND 13,013,343 330,137 1,906,841 11,106,502 15 421 WATER UTILITYFUND 12,814,124 9,869,102 11,188,392 1,625,732 87 422 STORM UTILITY FUND 10,856,909 5,471,427 7,909,445 2,947,464 73 423 SEWER/WWTP UTILITY FUND 32,785,445 13,020,732 24,264,839 8,520,606 74 424 BOND RESERVE FUND 1,988,130 1,991,184 1,988,084 46 10C 511 EQUIPMENT RENTAL FUND 3,225,665 2,584,317 2,947,702 277,963 91 512 TECHNOLOGY RENTAL FUND 1,517,040 924,022 1,052,893 464,147 69 617 FIREMEN'S PENSION FUND 88,700 140,802 82,005 6,695 92 $ 141,767,565 $ 90,495,864 $ 106,238,142 $ 35,529,423 75 2 Packet Pg. 30 1 2.3.a Page 1 of 3 C ITY O F IDMO NDS REVENUES - GENERAL FUND 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALES/USE TAX 4 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GASUTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWERUTILITYTAX 12 STORMWATER UTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABS TAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERNUTS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE -FINGERPRINTING 20 AMUSEMENTS 21 VENDING MACHINE/CONCESSION 22 FRANCHISE AGREEMENT -COMCAST 23 FRANCHISE FEE-EDUCATION/GOVERNMENT 24 FRANCHISE AGREEMENT-VERIZON/FRONTIER 25 OLYMPIC VIEW WAT ER DIST RICT FRANCHISE 26 GENERAL BUSINESS LICENSE 27 DEV SERV PERMIT SURCHARGE 28 NON-RESIDENT BUS LICENSE 29 RIGHT OF WAY FRANCHISE FEE 30 BUILDING STRUCTURE PERMITS 31 ANIMAL LICENSES 32 STREET AND CURB PERMIT 33 OTRNON-BUSLIC/PERMITS INTERGOVERNMENTAL: 34 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 35 NCHIP GRANT 36 WA ASSOC OF SHERIFFS TRAFFIC GRANT 37 TARGET ZERO TEAMS GRANT 38 DOCKSIE DRILLS GRANT REIMBURSE 39 HIGH VISIBILITY ENFORCEMENT 40 CORONAVIRUS RELIEF FUND 41 CORONAVIRUS RELIEF FUND 2 42 STATE GRANTS- BUDGET ONLY 43 PUD PRIVILEDGE TAX 44 ARCHIVES AND RECORDS MANAGEMENT 45 STATE GRANT FROM OTHER JUDICIAL AGENCIES 46 SCHOOL ZONE 47 WA STATE TRAFFIC COMM GRANT 48 MVET/SPECIAL DISTRIBUTION 49 WASHINGTON STATE ARTS COMMISSION 50 SHORELINE MASTER PROGRAM DOE 51 TRIAL COURT IMPROVEMENT 52 CRIMINAL JUSTICE -SPECIAL PROGRAMS 53 MARIJUANA ENFORCEMENT 54 MARIJUANA EXCISE TAX DISTRIBUTION 55 DUI - CITIES 56 LIQUOR EXCISE TAX 57 LIQUOR BOARD PROFITS 58 MISCELLANEOUS INTERLOCAL REVENUE 59 INTERLOCAL GRANTS 60 VERDANT INTERLOCAL GRANTS 61 POLICE TRAININGCLASSES 62 FIRST RESPONDERS FLEX FUND 63 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 10,737,617 $ 10,455,514 $ 10,456,907 $ 280,710 97% 4,112,031 4,042,731 4,083,288 28,743 99% 500 239 27 473 5% 8,450,000 8,452,715 8,317,046 132,954 98% 7,600 9,684 7,657 (57) 101% 760,500 811,796 810,408 (49,908) 107% 1,684,800 1,682,586 1,668,430 16,370 99% 579,600 578,572 639,670 (60,070) 110% 348,800 359,499 358,411 (9,611) 103% 1,148,400 1,166,632 1,091,647 56,753 95% 896,600 841,724 784,219 112,381 87% 471,900 437,283 484,000 (12,100) 103% 822,200 808,538 804,704 17,496 98% 823,900 798,498 666,374 157,526 81% 55,200 55,915 56,617 (1,417) 103% 40 383 476 (436) 1190% 280,900 285,122 300,672 (19,772) 107% 31,180,588 30,787,433 30,530,552 650,036 98% 250 250 465 (215) 186% 700 605 80 620 11% 6,000 4,675 - 6,000 0% 50,000 53,587 13,083 36,917 26% 682,200 676,201 678,877 3,323 100% 41,000 41,414 39,842 1,158 97% 100,600 94,045 73,239 27,361 73% 358,200 387,851 377,553 (19,353) 105% 116,300 159,033 224,179 (107,879) 193% 63,700 70,209 75,040 (11,340) 118% 64,800 53,825 - 64,800 0% 13,500 25,089 45,961 (32,461) 340% 675,600 643,329 655,426 20,174 97% 24,380 24,428 24,485 (105) 100% 45,000 41,400 55,495 (10,495) 123% 18,500 20,520 16,657 1,843 90% 2,260,730 2,296,460 2,280,382 (19,652) 101% 6,000 7,645 2,052 3,949 34% - 14,616 - - 0% - 2,285 - 0% 4,000 1,852 - 4,000 0% - 4,138 559 (559) 0% 7,100 3,501 2,618 4,482 37% 247,611 - 241,210 6,401 97% - - 5,310 (5,310) 0% 18,000 - - 18,000 0% 210,500 208,433 207,989 2,511 99% - 3,836 9,399 (9,399) 0% - 1,530 140 (140) 0% 832 - 825 7 99% - 2,594 - - 0% 13,070 12,536 13,211 (141) 101% - 5,000 - - 0% - 7,165 - - 0% 16,740 16,722 16,152 588 96% 45,600 45,102 47,280 (1,680) 104% 500 - - 500 0% 48,300 63,236 68,959 (20,659) 143% 6,000 5,827 6,129 (129) 102% 231,500 228,650 265,801 (34,301) 115% 338,200 340,906 338,497 (297) 100% - 2,500 - - 0% - 20,761 7,774 (7,774) 0% - 2,000 - 0% 1,194 211 1,194 100% 1,000 1,059 4,001 (3,001) 400% 550 - - 550 0% 1,1969697 1,002,105 1,239,098 (429401) 104% 2020 Local Retail Sa/es/Use Tax revenues are $(135,670) /Swer than 2019 revenues Please also see pagespages 18 & 19. Packet Pg. 31 1 I 2.3.a I Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2020 Amended 12/31/2019 Title Budget Revenues 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 DRE REIMBURSEABLE 7 WARRANT PREPARATION FEE 8 IT TIME PAY FEE 9 MUNIC.-DIST. COURT CURR EXPEN 10 SALE MAPS & BOOKS 11 CLERKS TIME FOR SALE OF PARKING PERMITS 12 BID SUPPLIES REIMBURSEMENT 13 PHOTOCOPIES 14 POLICE DISCLOSURE REQUESTS 15 ENGINEERING FEES AND CHARGES 16 ELECTION CANDIDATE FILINGFEES 17 SNO-ISLE 18 PASSPORTS AND NATURALIZATION FEES 19 POLICE SERVICES SPECIAL EVENTS 20 CAMPUS SAFETY-EDM. SCH. DIST. 21 WOODWAY-LAW PROTECTION 22 MISCELLANEOUS POLICE SERVICES 23 FIRE PROTECTION & EMS FOR DUI 24 FIRE DISTRICT #1 STATION BILLINGS 25 LEGAL SERVICES 26 ADULT PROBATION SERVICE CHARGE 27 BOOKINGFEES 28 FIRE CONSTRUCTION INSPECTION FEES 29 EMERGENCY SERVICE FEES 30 EMS TRANSPORT USER FEE 31 FLEX FUEL PAYMENTS FROM STATIONS 32 ANIMAL CONTROL SHELTER 33 ZONING/SUBDIVISION FEE 34 PLAN CHECKINGFEES ' 35 FIRE PLAN CHECK FEES 36 PLANNING 1%INSPECTION FEE 37 S.E.P.A. REVIEW 38 CRITICAL AREA STUDY 39 DV COORDINATOR SERVICES 40 GYM AND WEIGHT ROOM FEES 41 PROGRAM FEES 5 42 TAXABLE RECREATION ACTIVITIES 43 WINTER MARKET REGISTRATION FEES 44 BIRD FEST REGISTRATION FEES 45 INTERFUND REIMBURSEMENT -CONTRACT SVCS 12/31/2020 Amount Revenues Remaining % Received $ 3,000 $ 3,740 $ 5,204 $ (2,204) 1730/( 600 697 184 416 310/( 11,000 14,051 6,445 4,555 590/( 300 79 7 293 20 300 78 97 203 320/( - - 235 (235) 00/( 11,000 10,910 2,358 8,642 210/( 1,000 1,321 844 156 840/( 100 324 66 34 660/( 100 59 9 91 90/( 25,100 25,090 - 25,100 00/( 600 555 - 600 00/c 1,000 1,138 450 550 450/( 500 - - 500 00/c 125,000 223,633 248,564 (123,564) 1990/( 1,400 - - 1,400 00/( 85,000 96,075 72,359 12,641 850/( 21,000 22,780 5,795 15,205 280 30,000 38,074 - 30,000 00/( 126,800 72,018 36,753 90,047 290/( 195,000 211,867 198,859 (3,859) 1020/( - 2 58 (58) 00/( - 117 - - 00/( 52,500 54,941 59,291 (6,791) 1130/( 1,050 1,277 2,005 (955) 1910/( 45,000 46,102 39,663 5,337 880/( 3,000 2,809 2,157 843 720/( 10,000 16,335 21,269 (11,269) 2130/( 3,500 5,636 4,000 (500) 1140/( 1,007,500 1,043,753 992,345 15,155 980 2,500 1,311 2,396 104 960/( 50 100 100 (50) 2000/( 72,600 121,014 78,222 (5,622) 1080/( 375,900 616,110 263,376 112,524 700/( 4,000 10,160 17,046 (13,046) 4260/( 500 2,814 - 500 00/c 5,000 6,195 4,440 560 890/( 14,000 15,625 16,252 (2,252) 1160/c - 4,707 - - 00/( 15,500 12,160 3,083 12,417 200/( 869,162 852,477 98,503 770,659 110/( 1,300 512 - 1,300 00/( 5,000 10,950 10,328 (5,328) 2070/( 800 585 - 800 00/( 3,290,838 2,898,678 3,017,717 273,121 920/( 6,418,500 6,446,860 5,210,479 1,208,021 810% 5 2020 Parks & Recreation Program Revenues are $(753,974) lower than 2019 revenues. 4 Packet Pg. 32 1 2.3.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Revenues Revenues Remaining %Received FINES AND PENALTIES: 1 PROOF OF VEHICLE INS PENALTY 2 TRAFFIC INFRACTION PENALTIES 3 NC TRAFFIC INFRACTION 4 CRT COST FEE CODE LEG ASSESSMENT (LGA) 5 NON -TRAFFIC INFRACTION PENALTIES 6 OTHERINFRACTIONS'04 7 PARKING INFRACTION PENALTIES 8 PARK/INDDISZONE 9 DWI PENALTIES 10 DUI - DP ACCT 11 CRIM CNV FEE DUI 12 DUI - DP FEE 13 OTHER CRIMINAL TRAF MISDEM PEN 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 CONV. 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 PARKING 32 SP ACE/FACILIT IES RENTALS 33 BRACKET ROOM RENTAL 34 LEASESLONG-TERM 35 DONATION/CONTRIBUTION 36 PARKSDONATIONS 37 BIRD FEST CONTRIBUTIONS 38 POLICE CONTRIBUTIONS FROM PRIV SOURCES 39 SALE OF JUNK/SALVAGE 40 SALES OF UNCLAIM PROPERTY 41 CONFISCATED AND FORFEITED PROPERTY 42 OTHER JUDGEMENT/SETTLEMENT 43 POLICE JUDGMENTS/RESTITUTION 44 CASHIERS OVERAGES✓SHORTAGES 45 OTHER MISC REVENUES 46 SMALL OVERPAYMENT 47 NSF FEES - PARKS & REC 48 NSF FEES - MUNICIPAL COURT 49 L&I STAY AT WORK PROGRAM 50 FLEX -PLAN SERVICES FORFEITURES 51 NSF FEE - DEVEL SERV DEPT 52 US BANK REBATE TRANSFERS -IN: 53 INSURANCE RECOVERIES 54 INTERFUND TRANSFER FROM 012 55 INTERFUND TRANSFER FROM 011 56 INTERFUND TRANSFER FROM 511 57 TRANSFER FROM FUND 127 $ 4,000 $ 3,515 $ 1,202 $ 2,798 300/( 241,000 216,648 120,087 120,913 5001( 19,000 17,784 13,683 5,317 720/( 20,000 16,630 10,557 9,443 530/( 1,000 1,371 1,980 (980) 1980/( 2,000 1,232 1,320 680 660/c 147,000 143,598 70,129 76,871 480/( 2,500 2,939 1,091 1,409 440/( 7,000 9,732 9,604 (2,604) 1370/( 700 448 199 501 280/( 200 89 38 162 190/( 1,500 2,008 2,231 (731) 1490/( 140 - - 140 00/c 30,000 28,338 20,820 9,180 690/( 3,600 2,549 2,278 322 63% 1,000 622 551 9 5501( 100 (2,774) 37 63 370/( 13,100 13,903 7,411 5,689 570/( 600 314 984 (384) 1640/( 1,600 930 733 867 460/( 500 283 132 368 260/( 16,000 11,486 8,148 7,852 5101( 14,000 13,493 8,525 5,475 610/( 6,000 4,598 4,512 1,488 750/( 10,100 5,150 - 10,100 00/( 300 1,208 1,441 (1,141) 4800/( 542,940 496,093 287,693 2559247 530% 399,400 421,005 309,476 89,924 770/( 53,440 28,731 14,293 39,147 270/( 50,950 8,091 8,326 42,624 160/( - 29,239 - - 00/( - 150 - - 00/( 153,000 143,035 22,701 130,299 1501( 2,100 2,330 380 1,720 180/( 205,000 202,088 170,859 34,141 830/( 22,500 4,972 930 21,570 40/( 3,500 3,050 920 2,580 260/( 2,000 1,597 635 1,365 320/( 6,662 10,721 1,766 4,896 270/( 300 68 487 (187) 1620/( 3,000 3,731 3,872 (872) 1290/( 2,000 - - 2,000 0°/ 2,000 3 1,344 656 67°/ 200 619 268 (68) 1340/( - (70) 16 (16) 00/( 5,000 195,529 14,232 (9,232) 285°/ 100 73 95 5 950/( 100 90 30 70 300/( 150 112 142 8 950/( - 10,483 - - 00/( 370 - - 0% - - 30 (30) 0°/ 8,500 8,930 8,534 (34) 1000/( 919,902 1,074,949 559,337 360,565 619/( - 16,977 (16,977) 00/( 3,835,827 - - 00/( - 931,523 - - 00/c 1,500,000 - 1,500,000 - 1000/( 35,800 26,300 35,800 - 1000/( 1,535,800 4,793,650 1,552,777 (16,977) 101°/ TOTAL GENERAL FUND REVENUE $ 44,055,157 $ 46,897,549 $ 41,660,318 $ 2,394,839 950/ 5 Packet Pg. 33 I 2.3.a I Page 1 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 17,177,230 $ 15,758,890 $ 16,528,199 $ 649,031 960/ 2 OVERTIME 491,580 730,413 612,255 (120,675) 1250/ 3 HOLIDAY BUY BACK 262,020 213,691 233,372 28,648 890/ 4 BENEFITS 6,607,643 6,184,431 6,348,656 258,987 960/ 5 UNIFORMS 101,798 100,926 88,202 13,596 870/ 6 SUPPLIES 497,122 451,102 482,079 15,043 970/ 7 SMALL EQUIPMENT 170,662 153,777 175,853 (5,191) 1030/ 8 PROFESSIONAL SERVICES 15,499,765 12,684,371 13,811,032 688,733 890/ 9 COMMUNICATIONS 171,571 168,790 153,430 18,141 890/ 10 TRAVEL 78,580 70,950 10,161 68,419 130/ 11 EXCISE TAXES 6,500 7,993 15,907 (9,407) 2450/ 12 RENTAL/LEASE 1,837,776 1,842,464 1,806,719 31,057 980/ 13 INSURANCE 394,124 436,448 393,746 378 1000/ 14 UTILITIES 531,525 525,607 499,415 32,110 940/ 15 REPAIRS&MAINTENANCE 297,966 633,864 936,856 (638,890) 3140/ 16 MISCELLANEOUS 533,664 421,037 331,383 202,281 620/ 17 INTERGOVERNMENTAL PAYMENTS 75,000 75,000 75,000 - 1000/ 18 INTERFUND SUBSIDIES 3,266,993 1,905,778 1,206,990 2,060,003 370/ 19 MACHINERY/EQUIPMENT 57,173 - 9,053 48,120 160/ 20 CONSTRUCTION PROJECTS 1,000,000 10,296 - 1,000,000 00/ 21 GENERAL OBLIGATION BOND PRINCIPAL 168,850 183,704 163,840 5,010 970/ 22 OTHER INTEREST & DEBT SERVICE COSTS 500 218 212 288 420/ 23 INTEREST ON LONG-TERM EXTERNAL DEBT 137,250 14,045 132,572 4,678 970/ 49,365,292 42,573,794 44,014,931 5,350,361 89°/ LEO FF-MEDIC AL INS. RESERVE(009) 24 BENEFITS $ 206,650 $ 155,117 $ 143,716 $ 62,934 700/ 25 PENSION AND DISABILITY PAYMENTS 252,990 239,839 94,189 158,801 370/ 26 PROFESSIONAL SERVICES 7,000 7,161 5,793 1,207 830/ 27 MISCELLANEOUS 500 455 - 500 00/ 467,140 402,572 243,697 223,443 520/ RISK MANAGEMENT RESERVE FUND (011) 28 INTERFUND SUBSIDIES $ $ 931,523 $ - $ - 00/ 931,523 00/ CONTINGENCY RESERVE FUND (012) 29 INTERFUND SUBSIDIES $ $ 3,835,827 $ $ 00/ 3,835,827 00/ HISTORIC PRESERVATION GIFTFUND (014) 30 SUPPLIES $ 100 $ - $ $ 100 00/ 31 PROFESSIONAL SERVICES 200 - 200 00/ 32 MISCELLANEOUS 5,600 5,533 5,600 00/ 5,900 5,533 5,900 00/ EDMONDS HOMELESSNESS RESPONSEFUND (018) 33 PROFESSIONAL SERVICES $ 100,000 $ 1,862 $ 100,000 $ 1000/ 100,000 s 1,862 100,000 s 1000/ EDMONDS OPIOH) RESPONSE FUND (019) 34 PROFESSIONAL SERVICES $ 21,555 $ - $ 21,555 $ 1000/ 35 INTERFUND SUBSIDIES - 200,000 - 00/ 21,555 200,000 21,555 - 100 / DRUG INFO RC EMENT FUND (104) 36 PROFESSIONAL SERVICES $ 45,000 $ - $ $ 45,000 00/ 37 REPAIR/MAINT 800 800 00/ 38 MISCELLANEOUS - 30,332 (30,332) 00/ 45,800 30,332 15,468 660/ 6 Packet Pg. 34 I 2.3.a I Page 2 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent STREETFUND (111) 1 SALARIES AND WAGES $ 723,081 $ 595,190 $ 662,902 $ 60,179 920/ 2 OVERTIME 18,400 49,613 45,506 (27,106) 2470/ 3 BENEFITS 309,539 283,525 328,778 (19,239) 1060, 4 UNIFORMS 6,416 3,344 4,079 2,337 640/ 5 SUPPLIES 263,000 254,053 198,979 64,021 760/ 6 SMALL EQUIPMENT 20,000 2,854 1,082 18,918 50, 7 PROFESSIONAL SERVICES 27,930 11,295 2,689 25,241 100/ 8 COMMUNICATIONS 4,500 7,089 7,901 (3,401) 1760/ 9 TRAVEL 1,000 - - 1,000 00/ 10 RENTAL/LEASE 230,450 268,813 231,006 (556) 1000/ 11 INSURANCE 145,219 156,514 156,937 (11,718) 1080/ 12 UTILITIES 280,918 268,546 276,907 4,011 990/ 13 REPAIRS&MAINTENANCE 52,000 34,649 70,694 (18,694) 1360/ 14 MISCELLANEOUS 13,000 7,302 8,435 4,565 650/ 15 MACHINERY/EQUIPMENT 100,000 12,343 75,658 24,342 760/ 16 GENERAL OBLIGATION BOND PRINCIPAL 4,170 4,033 4,161 9 1000/ 17INTEREST 510 577 510 0 1000/ COMBINED STREETCONST/IMPROVE(112) 18 SALARIES AND WAGES 19 BENEFITS 20 PROFESSIONAL SERVICES 21 REPAIR & MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 LAND 25 CONSTRUCT ION PROJECTS 26 INTERGOVERNMENTAL LOANS 27 INTEREST MUNICIPAL ARTS ACQUIS. FUND (117) 28 SUPPLIES 29 SMALL EQUIPMENT 30 PROFESSIONAL SERVICES 31 TRAVEL 32 RENTAL/LEASE 33 REPAIRS& MAINTENANCE 34 MISCELLANEOUS HO TEL/MO TEL TAX REVENUE FUND (120) 35 PROFESSIONAL SERVICES 67 MISCELLANEOUS 37 INTERFUND SUBSIDIES 38 MACHINERY/EQUIPMENT EMPLO YEE PARKING PERMIT FUND (121) 39 SUPPLIES 40 PROFESSIONAL SERVICES YOUTH SCHOLARSHIP FUND (122) 41 MISCELLANEOUS TOURISM PROMOTIONAL FUND/ARTS (123) 42 PROFESSIONAL SERVICES 43 MISCELLANEOUS $ 2,200,133 $ 1,959,740 $ 2,076,224 $ 123,909 940/ $ $ 10,567 $ (10,567) 00/ - 6,613 (6,613) 00/ 680,130 391,992 622,464 57,666 920/ 163,028 422,794 322,615 (159,587) 1980/ - - 8 (8) 00/ 40,140 108,907 40,121 19 1000/ - 39,303 4,678 (4,678) 00/ 1,853,975 886,891 312,736 1,541,239 170/ 72,220 72,201 72,201 19 1000/ 1.970 2.313 1.952 18 990/ $ 2,811,463 $ 1,924,403 $ 1,393,957 $ 1,417,506 500/ $ 4,700 $ 3,984 $ 302 $ 4,398 60/ 1,700 640 116 1,584 70/ 229,124 53,962 33,444 195,680 1501 80 6 16 64 200/ 2,000 - - 2,000 00/ 300 - - 300 00/ 6,600 4,569 2,614 3,986 400/ $ 244,504 $ 63,161 $ 36,493 $ 208,011 150, $ 92,487 $ 90,424 $ 88,066 $ 4,421 950/ 6,763 583 612 6,151 90/ 4,000 4,000 4,000 - 1000/ 25,000 - - 25,000 00/ $ 128,250 $ 95,008 $ 92,677 $ 35,573 720/ $ 1,790 $ 591 $ 632 $ 1,158 350/ 25,090 25,090 - 25,090 00/ $ 26,880 $ 25,681 $ 632 $ 26,248 20/ $ 3,000 $ 2,768 $ 450 $ 2,550 1501 $ 3,000 $ 2,768 $ 450 $ 2,550 150/ $ 33,900 $ 28,614 $ 15,510 $ 18,390 460/ - 3,366 - - 00/ $ 33,900 $ 31,980 $ 15,510 $ 18,390 460/ 7 Packet Pg. 35 I 2.3.a I Page 3 of 6 C PIY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ 21,000 $ 77,223 $ 18,697 $ 2,303 890/ 2 PROFESSIONAL SERVICES 479,831 162,209 384,486 95,345 800, 3 RENTAL/LEASE - 381 - - 00/ 4 REPAIRS& MAINTENANCE 176,176 408,388 360,046 (183,870) 2040/ 5 INTERFUND SUBSIDIES 620 - 430 190 690/ 6 CONST RUCT ION PROJECTS 2,932,893 601,092 1,227,553 1,705,340 420/ $ 3,610,520 $ 1,249,293 $ 1,991,212 $ 1,619,308 5501 REAL ESTATE EXCISE TAXI (126) 7 SUPPLIES 8 PROFESSIONAL SERVICES 9 REPAIRS& MAINTENANCE 10 INTERFUND SUBSIDIES 11 LAND 12 CONSTRUCTION PROJECTS 13 GENERAL OBLIGATION BONDS 14 INTEREST 15 OTHER INT EREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 16 SUPPLIES 17 SMALL EQUIPMENT 18 PROFESSIONAL SERVICES 19 REPAIRS& MAINTENANCE 20 MISCELLANEOUS 21 INTERFUND SUBSIDIES C EWE=Y MAINTENANC EIMPRO VEMENT (130) 22 SALARIES AND WAGES 23 OVERTIME 24 BENEFITS 25 UNIFORMS 26 SUPPLIES 27 SUPPLIES PURCHASED FOR INVENTORY/RESALE 28 SMALL EQUIPMENT 29 PROFESSIONAL SERVICES 30 COMMUNICATIONS 31 TRAVEL 32 RENTAL/LEASE 33 UTILITIES 34 REPAIRS&MAINTENANCE 35 MISCELLANEOUS PARKS TRUST FUND (136) 36 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 37 SUPPLIES 38 TRAVEL 39 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 40 SUPPLIES 41 PROFESSIONAL SERVICES 42 MISCELLANEOUS EDMONDS CARES FUND (142) 43 PROFESSIONAL SERVICES LID FUND C O NTRO L (211) 44 INTERFUND SUBSIDIES 2012 LTGO DEBTSERVIC FUND (231) 45 GENERAL OBLIGATION BOND 46 INTEREST $ - $ 55,948 $ - $ - 00/ 883,267 156,343 684,749 198,518 780/ 95,963 400,238 259,551 (163,588) 2700/ 142,736 133,025 142,731 5 1000/ 300,000 - - 300,000 00/ 1,951,937 957,596 916,129 1,035,808 470/ 24,220 23,476 24,219 1 1000/ 2,970 3,360 2,968 2 1000/ - 77 575 (575) 00/ $ 3,401,093 $ 1,730,062 $ 2,030,921 $ 1,370,172 600/ $ 48,882 $ 39,079 $ 39,033 $ 9,849 800/ - 14,694 - - 00/ 6,500 - 5,400 1,100 830/ 22,000 1,858 7,183 14,818 330/ 600 159 503 97 840/ 35,800 26,300 35,800 - 1000/ $ 113,782 $ 82,091 $ 87,919 $ 25,863 770/ $ 97,476 $ 89,239 $ 93,344 $ 4,132 960/ 3,500 3,272 729 2,771 210/ 42,029 40,767 40,160 1,869 960/ 1,000 225 230 770 230/ 7,000 4,837 2,972 4,028 420/ 20,000 17,293 18,196 1,804 910/ - 1,246 1,184 (1,184) 00/ 4,200 2,199 1,835 2,365 440/ 1,700 1,794 1,682 18 990/ 500 - - 500 00/ 8,230 6,260 8,230 0 1000/ 5,652 4,879 4,928 724 870/ 500 - - 500 00/ 4,000 19,124 6,610 (2,610) 1650/ $ 195,787 $ 191,135 $ 180,098 $ 15,689 920/ $ $ 4,935 $ $ 00/ $ $ 4,935 $ $ 00/ $ 1,500 $ 770 $ 11 $ 1,489 10/ 4,500 3,405 4,500 00/ 5,900 2,718 5,900 00/ $ 11,900 $ 6,894 $ 11 $ 11,889 00/ $ 11,850 $ 12,983 $ 9,858 $ 1,992 830/ 66,035 82,306 53,747 12,288 810/ 2,625 3,289 4,006 (1,381) 1530/ 80,510 98,578 67,611 12,899 840/ $ 1,860,000 $ - $ 1,775,326 $ 84,674 950/ 1,860,000 1,775,326 84,674 950/ $ 12,400 $ 30,905 $ $ 12,400 00/ $ 12,400 $ 30,905 $ $ 12,400 00/ $ 643,810 $ 609,623 $ 643,802 $ 8 1000/ 94,590 106,775 94,583 7 1000/ $ 738,400 $ 716,398 $ 738,385 $ 15 1000/ g Packet Pg. 36 I 2.3.a I Page 4 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 323,349 $ 116,848 $ 446,182 $ (122,833) 1380r 2 INTERFUND SUBSIDIES 112,920 - 20,316 92,604 180/ 3 CONST RUCT ION PROJECTS 12,577,074 133,247 1,440,342 11,136,732 110/ 4 DEBT ISSUE COSTS - 80,041 - - 00/ $ 13,013,343 $ 330,137 $ 1,906,841 $ 11,106,502 1501 WATER FUND (421) 5 SALARIES AND WAGES 6 OVERTIME 7 BENEFITS 8 UNIFORMS 9 SUPPLIES 10 WATERPURCHASED FORRESALE 11 SUPPLIES PURCHASED FOR INVENTORY/RESALE 12 SMALL EQUIPMENT 13 PROFESSIONAL SERVICES 14 COMMUNICATIONS 15 TRAVEL 16 EXCISE TAXES 17 RENTAL/LEASE 18 INSURANCE 19 UTILITIES 20 REPAIRS & MAINTENANCE 21 MISCELLANEOUS 22 INTERFUND SUBSIDIES 23 CONST RUCT ION PROJECTS 24 GENERAL OBLIGATION BONDS 25 REVENUE BONDS 26 INTERGOVERNMENTAL LOANS 27 INTEREST 28 OTHER INT EREST & DEBT SERVICE COSTS STORM FUND (422) 29 SALARIES AND WAGES 30 OVERTIME 31 BENEFITS 32 UNIFORMS 33 SUPPLIES 34 SMALL EQUIPMENT 35 PROFESSIONAL SERVICES 36 COMMUNICATIONS 37 TRAVEL 38 EXCISE TAXES 39 RENTAL/LEASE 40 INSURANCE 41 UTILITES 42 REPAIR & MAINTENANCE 43 MISCELLANEOUS 44 INTERFUND SUBSIDIES 45 CONSTRUCT ION PROJECTS 46 GENERAL OBLIGATION BONDS 47 REVENUE BONDS 48 INTERGOVERNMENTAL LOANS 49 INTEREST 50 OTHER INT EREST & DEBT SERVICE COSTS $ 845,871 $ 758,623 $ 796,988 $ 48,883 940/ 24,000 25,056 21,118 2,882 880/ 363,882 340,393 309,245 54,637 850/ 4,000 3,424 4,371 (371) 1090/ 154,772 75,291 107,441 47,331 690r 2,170,000 1,877,946 2,049,587 120,413 940r 170,000 152,622 172,203 (2,203) 1010/ 11,000 5,955 6,927 4,073 630/ 1,753,804 847,220 1,324,226 429,578 760/ 30,000 29,873 30,043 (43) 1000/ 200 - - 200 00/ 1,649,700 1,649,324 1,571,444 78,256 950i 133,158 152,721 130,244 2,914 980/ 52,865 55,096 52,541 324 990/ 35,775 31,828 32,670 3,105 910/ 75,830 237,822 20,613 55,217 270/ 131,400 117,653 138,785 (7,385) 1060/ 650,870 646,366 648,597 2,273 1000/ 3,946,207 2,251,663 3,160,207 786,000 800/ 2,800 2,709 2,794 6 1000/ 370,960 355,732 370,959 1 1000/ 25,840 25,839 25,839 1 1000/ 211,190 225,572 211,169 21 1000/ - 375 378 (378) 00/ $ 12,814,124 $ 9,869,102 $ 11,188,392 $ 1,625,732 870r $ 728,080 $ 652,439 $ 643,183 $ 84,897 880/ 6,000 35,162 13,321 (7,321) 2220/ 334,154 326,307 293,573 40,581 880/ 6,500 6,166 8,407 (1,907) 1290/ 47,958 27,114 25,331 22,627 530/ 4,000 4,114 2,464 1,536 620/ 3,047,970 1,129,413 1,822,002 1,225,968 600/ 3,200 5,391 6,187 (2,987) 1930/ 4,300 - - 4,300 00/ 470,100 509,604 562,212 (92,112) 1200r 270,830 250,181 269,789 1,041 1000/ 118,263 127,548 116,576 1,687 990/ 11,025 11,193 12,102 (1,077) 1100/ 116,183 17,250 18,753 97,430 160/ 181,100 167,833 185,382 (4,282) 1020/ 282,550 295,279 282,545 5 1000i 4,758,296 1,477,403 3,193,179 1,565,117 670/ 102,030 98,899 102,029 1 1000/ 181,210 173,932 181,205 5 1000/ 60,760 32,063 53,576 7,184 880/ 122,400 123,971 117,467 4,933 960/ - 165 165 (165) 00/ $ 10,856,909 $ 5,471,427 $ 7,909,445 $ 2,947,464 730/ 9 Packet Pg. 37 I 2.3.a I Page 5 of 6 CITY 0FFDMONDS EXPENDITURES BY FUND - DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 1,953,719 $ 1,779,083 $ 1,865,904 $ 87,815 960/ 2 OVERTIME 95,000 98,788 106,756 (11,756) 1120r 3 BENEFITS 854,294 782,554 804,842 49,452 940i 4 UNIFORMS 9,500 7,267 7,967 1,533 840i 5 SUPPLIES 433,470 317,346 397,447 36,024 920i 6 FUEL CONSUMED 60,000 44,284 24,125 35,875 400r 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 00/ 8 SMALL EQUIPMENT 36,369 20,645 42,890 (6,521) 1180i 9 PROFESSIONAL SERVICES 2,289,566 1,181,008 4,494,417 (2,204,851) 1960i 10 COMMUNICATIONS 43,886 44,183 42,785 1,101 970r 11 TRAVEL 5,000 5,016 - 5,000 00/ 12 EXCISE TAXES 978,000 1,053,670 978,545 (545) 1000i 13 RENTAL/LEASE 311,966 346,167 320,207 (8,241) 1030i 14 INSURANCE 182,121 186,110 175,867 6,254 970r 15 UTILITIES 1,540,685 1,147,784 983,600 557,085 640, 16 REPAIR & MAINTENANCE 745,630 429,952 252,808 492,822 340i 17 MISCELLANEOUS 127,650 83,617 90,819 36,831 710i 18 INTERFUND SUBSIDIES 7,197,114 1,959,171 3,308,045 3,889,069 460r 19 MACHINERY/EQUIPMENT - 33,647 117,784 (117,784) 00/ 20 CONST RUCT ION PROJECTS 15,438,495 3,021,725 9,502,326 5,936,169 620i 21 GENERAL OBLIGATION BONDS 154,660 150,043 154,652 8 1000i 22 REVENUE BONDS 82,840 80,336 244,944 (162,104) 2960r 23 INTERGOVERNMENTAL LOANS 173,210 172,528 173,200 10 1000r 24 INTEREST 68,270 70,427 63,506 4,764 930i 25 DEBT ISSUE COSTS - - 106,318 (106,318) 00/ 26 OTHER TNT EREST & DEBT SERVICE COSTS - 5,380 5,085 (5,085) 00/ $ 32,785,445 $ 13,020,732 $ 24,264,839 $ 8,520,606 740, BOND RESERVE FUND (424) 27 REVENUE BONDS $ 755,020 $ 740,000 $ 755,000 $ 20 1000i 28INTEREST 1,233,110 1,251,184 1,233,084 26 1000r $ 1,988,130 $ 1,991,184 $ 1,988,084 $ 46 1000r 10 Packet Pg. 38 2.3.a Page 6 of 6 CITY OFEDMONDS EXPENDITURES BY FUND - DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES 2 OVERTIME 3 BENEFIT S 4 UNIFORMS 5 SUPPLIES 6 FUEL CONSUMED 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 8 SMALL EQUIPMENT 9 PROFESSIONAL SERVICES 10 COMMUNICATIONS 11 TRAVEL 12 RENTAL/LEASE 13 INSURANCE 14 UTILITIES 15 REPAIRS & MAINTENANCE 16 MISCELLANEOUS 17 INTERFUND SUBSIDIES 18 MACHINERY/EQUIPMENT TECHNOLOGY RENTAL FUND (512) 19 SALARIES AND WAGES 20 OVERTIME 21 BENEFIT S 22 SUPPLIES 23 SMALL EQUIPMENT 24 PROFESSIONAL SERVICES 25 COMMUNICATIONS 26 TRAVEL 27 RENTAL/LEASE 28 REPAIRS&MAINTENANCE 29 MISCELLANEOUS 30 MACHINERY/EQUIPMENT FIREMEN'S PENSION FUND (617) 31 BENEFITS 32 PENSION AND DISABILITY PAYMENTS 33 PROFESSIONAL SERVICES TO TAL EXPENDITURE ALL FUNDS $ 266,952 $ 260,548 $ 269,774 $ (2,822) 1010/ 2,000 8,081 1,406 594 700, 112,598 111,050 112,088 510 1000/ 1,000 1,347 1,186 (186) 1190, 132,128 96,541 79,828 52,300 600/ 1,000 - - 1,000 00, 243,000 201,116 178,940 64,060 740/ 58,000 2,879 3,487 54,513 60/ 46,750 29,071 4,498 42,252 100/ 3,000 2,285 2,303 697 770/ 1,000 255 - 1,000 00/ 12,750 13,765 12,348 402 970, 27,848 30,167 43,001 (15,153) 1540/ 14,500 14,630 15,444 (944) 1070r 60,000 32,569 44,848 15,152 750/ 12,000 9,994 11,784 216 980/ 1,500,000 - 1,500,000 - 1000/ 731,139 1,770,020 666,766 64,373 910r $ 3,225,665 $ 2,584,317 $ 2,947,702 $ 277,963 910i $ 369,264 $ 298,126 $ 290,526 $ 78,738 790i 2,000 125 165 1,835 80r 124,590 100,677 97,528 27,062 780i 11,394 4,235 9,580 1,814 840r 179,555 50,258 123,180 56,375 690i 309,810 48,188 73,569 236,241 240, 58,770 58,844 61,351 (2,581) 1040i 1,500 359 - 1,500 00/ 7,490 7,300 7,271 219 970i 381,667 272,767 360,311 21,356 940i 5,000 3,491 11,748 (6,748) 2350i 66,000 79,651 17,664 48,336 270i $ 1,517,040 $ 924,022 $ 1,052,893 $ 464,147 690i $ 23,000 $ 20,417 $ 19,258 $ 3,742 840i 64,500 119,116 61,740 2,760 960i 1,200 1,269 1,007 193 840i $ 88,700 $ 140,802 $ 82,005 $ 6,695 920i $ 141,767,565 $ 90,495,864 $ 106,238,142 $ 35,529,423 750, 11 Packet Pg. 39 2.3.a Page 1 of 1 C ITY O F EDMO NDS EXPENDPTURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT CITY CLERK FINANCE CITY ATTORNEY NON -DEPARTMENTAL POLICE SERVICES COMMUNITY SERVICES✓ECONOMIC DEV DEVELOPMENT SERVICES PARKS& RECREATION PUBLIC WORKS ADMINISTRATION FACILITIES MAINTENANCE % Spent $ 418,912 $ 402,243 $ 322,555 $ 96,357 77% 306,685 297,114 331,095 (24,410) 108% 744,339 552,184 692,901 51,438 93% 1,142,871 1,001,064 1,072,252 70,619 94% 726,962 705,593 726,790 172 100% 1 1,289,583 1,262,022 1,306,188 (16,605) 101% 912,540 874,911 860,435 52,105 11� 94% 15,412,119 12,669,606 12,751,867 2,660,252 83% 12,028,805 11,701,666 11,835,142 193,663 98% 766,197 604,295 599,693 166,504 78% 3,586,753 2,833,842 2,814,664 772,089 78% 4,673,608 4,053,149 3,669,440 1,004,168 79% 3,538,610 3,097,068 3,125,780 412,831 88% 3,817,308 2,519,036 3,906,130 (88,822) 102% $ 49,365,292 $ 42,573,794 $ 44,014,931 $ 5,350,361 89% : CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2020 Amended Budget 12/31/2019 Expenditures 12/31/2020 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 12,814,124 $ 9,869,102 $ 11,188,392 $ 1,625,732 87% STORM UTILITY FUND 10,856,909 5,471,427 7,909,445 2,947,464 73% SEWER/WWTP UTILITY FUND 32,785,445 13,020,732 24,264,839 8,520,606 74% BOND RESERVE FUND 1,988,130 1,991,184 1,988,084 46 100% $ 58,444,608 $ 30,352,444 $ 45,350,759 $ 13,093,849 78% 0- 10L A 12 Packet Pg. 40 I 2.3.a I Page 1 of 4 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2020 Amended Budget 12/31/2019 Expenditures 12/31/2020 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES $ 191,224 $ 180,440 $ 190,990 $ 234 100% OVERTIME 1,000 - - 1,000 0% BENEFITS 95,736 97,616 99,057 (3,321) 103% SUPPLIES 2,500 2,309 1,841 659 74% SMALL EQUIPMENT 1,000 342 590 410 59% PROFESSIONAL SERVICES 62,160 81,067 4,263 57,897 7% COMMUNICATIONS 5,000 6,393 8,984 (3,984) 180% TRAVEL 17,500 2,977 587 16,913 3% RENTAL/LEASE 12,292 12,118 12,329 (37) 100% REPAIRS✓MAINTENANCE 500 121 645 (145) 129% MISCELLANEOUS 30,000 18,860 3,271 26,729 11% $ 418,912 $ 402,243 $ 322,555 $ 96,357 77% OFFICEOFMAYOR SALARIES $ 222,432 $ 218,580 $ 223,427 $ (995) 100% BENEFITS 54,043 53,247 83,989 (29,946) 155% SUPPLIES 1,500 1,310 938 562 63% SMALL EQUIPMENT - 442 4,396 (4,396) 0% PROFESSIONAL SERVICES 3,000 2,385 633 2,367 21% COMMUNICATION 1,400 1,258 1,462 (62) 104% TRAVEL 3,000 2,603 166 2,834 6% RENTAL/LEASE 16,860 12,548 15,871 989 94% MISCELLANEOUS 4,450 4,741 213 4,237 5% $ 306,685 $ 297,114 $ 331,095 $ (24,410) 108% HUMAN RESOURCES SALARIES $ 356,658 $ 325,754 $ 356,472 $ 186 100% OVERTIME - 197 5,958 (5,958) 0% BENEFITS 142,458 113,283 143,222 (764) 101% SUPPLIES 21,066 5,512 3,940 17,126 19% SMALL EQUIPMENT 300 2,762 4,336 (4,036) 1445% PROFESSIONAL SERVICES 136,471 50,524 103,856 32,615 76% COMMUNICATIONS 1,550 1,315 1,425 125 92% TRAVEL 1,000 1,255 - 1,000 0% RENTAL/LEASE 31,921 24,624 30,522 1,399 96% REPAIR/MAINTENANCE 8,380 7,571 7,832 548 93% MISCELLANEOUS 44,535 19,388 35,338 9,197 79% $ 744,339 $ 552,184 $ 692,901 $ 51,438 93% MUNIC IPAL C O URT SALARIES $ 647,030 $ 587,294 $ 633,794 $ 13,236 98% OVERTIME 800 1,325 16,013 (15,213) 2002% BENEFITS 223,319 209,208 231,355 (8,036) 104% SUPPLIES 10,600 10,302 10,763 (163) 102% SMALL EQUIPMENT 4,144 5,418 14,461 (10,317) 349% PROFESSIONAL SERVICES 124,925 90,966 70,234 54,691 56% COMMUNICATIONS 3,550 2,920 2,767 783 78% TRAVEL 6,500 3,423 37 6,463 1% RENTAL/LEASE 67,947 64,551 67,698 249 100% REPAIR/MAINTENANCE 5,836 277 7,896 (2,060) 135% MISCELLANEOUS 25,100 25,380 17,236 7,864 69% MACHINERY/EQUIPMENT 23,120 23,120 0% $ 1,142,871 $ 1,001,064 $ 1,072,252 $ 70,619 94% 13 Packet Pg. 41 1 I 2.3.a I Page 2 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY CLERK SALARIES AND WAGES $ 376,214 $ 363,578 $ 399,460 $ (23,246) 106% BENEFITS 156,718 160,152 163,468 (6,750) 104% SUPPLIES 10,240 3,689 3,606 6,634 35% SMALL EQUIPMENT - 4,024 2,682 (2,682) 0% PROFESSIONAL SERVICES 37,410 31,744 26,493 10,917 71% COMMUNICATIONS 40,000 33,150 21,710 18,290 54% TRAVEL 2,000 503 6 1,994 0% RENTAL/LEASE 63,850 45,548 51,510 12,340 81% REPAIRS&MAINTENANCE 32,530 51,805 50,957 (18,427) 157% MISCELLANEOUS 8,000 11,401 6,899 1,101 86% $ 726,962 $ 705,593 $ 726,790 $ 172 100% FINANCE SALARIES $ 870,882 $ 851,763 $ 929,623 $ (58,741) 107% OVERTIME 4,500 - - 4,500 0% BENEFITS 289,923 289,662 260,112 29,811 90% SUPPLIES 7,350 6,928 5,902 1,448 80% SMALL EQUIPMENT 2,650 778 66 2,584 2% PROFESSIONAL SERVICES 9,300 1,725 1,518 7,782 16% COMMUNICATIONS 2,000 1,286 857 1,143 43% TRAVEL 3,100 2,371 - 3,100 0% RENTAL/LEASE 50,048 52,224 58,565 (8,517) 117% REPAIR/MAINTENANCE 41,480 42,499 43,963 (2,483) 106% MISCELLANEOUS 8,350 12,786 5,581 2,769 67% $ 1,289,583 $ 1,262,022 $ 1,306,188 $ (16,605) 101% CITY ATTO RNEY PROFESSIONAL SERVICES $ 912,540 $ 874,911 $ 860,435 $ 52,105 94% $ 912,540 $ 874,911 $ 860,435 $ 52,105 94% NON -DEPARTMENTAL SALARIES $ 110,742 $ - $ - $ 110,742 0% BENEFITS -UNEMPLOYMENT 50,000 46,218 1,254 48,746 3% SUPPLIES 5,000 6,183 5,151 (151) 103% PROFESSIONAL SERVICES 11,090,137 9,908,492 10,637,846 452,291 96% EXCISE TAXES 6,500 7,993 15,907 (9,407) 245% RENTAL/LEASE 15,249 11,950 15,679 (430) 103% INSURANCE 394,124 436,448 393,746 378 100% MISCELLANEOUS 91,774 73,577 103,671 (11,897) 113% CONTRIBUTION TO ECA 75,000 75,000 75,000 - 100% INTERFUND SUBSIDIES 3,266,993 1,905,778 1,206,990 2,060,003 37% GENERAL OBLIGATION BOND 168,850 183,704 163,840 5,010 97% INTEREST ON LONG-TERM DEBT 137,250 14,045 132,572 4,678 97% FISCAL AGENT FEES 500 218 212 288 42% $ 15,412,119 $ 12,669,606 $ 12,751,867 $ 2,660,252 83% 14 Packet Pg. 42 I 2.3.a I Page 3 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent PO LIC E S ERVIC ES SALARIES $ 7,026,155 $ 6,576,027 $ 6,888,107 $ 138,048 98% OVERTIME 461,280 680,738 562,395 (101,115) 122% HOLIDAY BUYBACK 262,020 213,691 233,372 28,648 89% BENEFITS 2,777,007 2,618,757 2,763,366 13,641 100% UNIFORMS 80,750 88,470 67,011 13,739 83% SUPPLIES 95,710 87,533 81,655 14,055 85% SMALL EQUIPMENT 133,177 104,509 121,089 12,088 91% PROFESSIONAL SERVICES 224,548 259,293 210,471 14,077 94% COMMUNICATIONS 36,000 42,058 43,019 (7,019) 119% TRAVEL 29,310 39,517 7,933 21,377 27% RENTAL/LEASE 826,124 916,472 819,650 6,474 99% REPAIR/MAINTENANCE 15,180 10,674 5,684 9,496 37% MISCELLANEOUS 61,544 63,926 31,391 30,153 51% $ 12,028,805 $ 11,701,666 $ 11,835,142 $ 193,663 98% COMMUNITY S ERVIC ES /EC 0 N DEV. SALARIES $ 357,423 $ 262,451 $ 350,150 $ 7,273 98% OVERTIME - - 93 (93) 0% BENEFITS 114,637 79,793 94,536 20,101 82% SUPPLIES 7,475 6,692 7,056 419 94% SMALL EQUIPMENT 4,173 270 3,321 852 80% PROFESSIONAL SERVICES 219,104 235,380 122,308 96,796 56% COMMUNICATIONS 2,975 1,401 2,242 733 75% TRAVEL 2,000 405 1,020 980 51% RENTAL/LEASE 13,410 12,049 11,993 1,417 89% REPAIR/MAINTENANCE 10,500 - - 10,500 0% MISCELLANEOUS 9,500 5,855 6,974 2,526 73% MACHINERY/EQUIPMENT 25,000 - - 25,000 0% $ 766,197 $ 604,295 $ 599,693 $ 166,504 78% DEVELO PMENT SERVIC ES/PLANNING SALARIES $ 1,760,943 $ 1,634,056 $ 1,708,362 $ 52,581 97% OVERTIME 1,300 12,427 13,932 (12,632) 1072% BENEFITS 658,292 622,580 619,940 38,352 94% UNIFORMS 500 401 60 440 12% SUPPLIES 17,100 12,959 6,878 10,222 40% SMALL EQUIPMENT 7,300 6,789 3,729 3,571 51% PROFESSIONAL SERVICES 886,518 339,569 230,662 655,856 26% COMMUNICATIONS 10,776 9,357 11,920 (1,144) 111% TRAVEL 6,800 10,138 228 6,572 3% RENTAL/LEASE 170,234 143,438 169,196 1,038 99% REPAIRS&MAINTENANCE 6,800 3,439 2,928 3,872 43% MISCELLANEOUS 60,190 38,688 46,828 13,362 78% $ 3,586,753 S 2,833,842 S 2,814,664 $ 772,089 78% ENGINEERING SALARIES $ 1,772,804 $ 1,695,173 $ 1,730,869 $ 41,935 98% OVERTIME 5,000 8,311 3,735 1,265 75% BENEFITS 701,327 693,171 697,338 3,989 99% UNIFORMS 450 298 256 194 57% SUPPLIES - 32 - - 0% SMALL EQUIPMENT 2,200 1,744 868 1,332 39% PROFESSIONAL SERVICES 188,840 4,824 1,530 187,310 1% COMMUNICATIONS 19,600 15,983 16,715 2,885 85% TRAVEL 600 1,043 134 466 22% RENTAL/LEASE 134,995 122,033 131,955 3,040 98% REPAIR/MAINTENANCE 2,600 - 769 1,831 30% MISCELLANEOUS 80,000 59,520 34,659 45,341 43% $ 2,908,416 $ 2,602,130 $ 2,618,828 $ 289,588 90% 15 Packet Pg. 43 I 2.3.a I Page 4 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2020 Amended 12/31/2019 12/31/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS & REC REATIO N SALARIES $ 2,316,676 $ 2,007,961 $ 2,029,203 $ 287,473 88% OVERTIME 10,000 20,286 4,853 5,147 49% BENEFITS 864,290 762,646 748,590 115,700 87% UNIFORMS 6,275 6,731 5,707 569 91% SUPPLIES 150,467 151,518 149,211 1,256 99% SMALL EQUIPMENT 10,900 9,514 8,870 2,030 81% PROFESSIONAL SERVICES 627,168 442,370 184,381 442,787 29% COMMUNICATIONS 31,370 31,000 17,670 13,700 56% TRAVEL 5,270 5,282 50 5,220 1% RENTAL/LEASE 281,611 278,452 273,432 8,179 97% PUBLIC UTILITY 230,507 209,970 187,542 42,965 81% REPAIR/MAINTENANCE 29,700 34,334 16,593 13,107 56% MISCELLANEOUS 100,321 82,787 34,286 66,035 34% MACHINERY/EQUIPMENT 9,053 - 9,053 0 100% CONSTRUCTION PROJECTS 10,296 0% $ 4,673,608 $ 4,053,149 $ 3,669,440 $ 1,004,168 79% PUBLIC WORKS ADMINISTRATION SALARIES $ 380,790 $ 289,383 $ 296,910 $ 83,880 78% OVERTIME 200 339 - 200 0% BENEFITS 131,041 101,620 104,236 26,805 80% SUPPLIES 8,600 5,062 3,988 4,612 46% SMALL EQUIPMENT 1,000 2,345 264 736 26% PROFESSIONAL SERVICES 200 124 143 57 72% COMMUNICATIONS 1,350 717 747 603 55% TRAVEL 500 1,427 - 500 0% RENTAL/LEASE 97,295 89,999 96,028 1,267 99% PUBLIC UTILITY 3,318 2,946 3,131 187 94% REPAIR/MAINTENANCE 1,000 - - 1,000 0% MISCELLANEOUS 4,900 975 1,505 3,395 31% $ 630,194 $ 494,938 $ 506,952 $ 123,242 80% FACILITIES MAINTENANCE SALARIES 787,257 766,429 790,833 (3,576) 100% OVERTIME 7,500 6,790 5,274 2,226 70% BENEFITS 348,852 336,477 338,193 10,659 97% UNIFORMS 13,823 5,025 15,168 (1,345) 110% SUPPLIES 159,514 151,074 201,150 (41,636) 126% SMALL EQUIPMENT 3,818 14,839 11,183 (7,365) 293% PROFESSIONAL SERVICES 977,444 360,997 1,356,260 (378,816) 139% COMMUNICATIONS 16,000 21,950 23,913 (7,913) 149% TRAVEL _ 1,000 6 - 1,000 0% RENTAL/LEASE 55,940 56,459 52,293 3,648 93% PUBLIC UTILITY 297,700 312,692 308,742 (11,042) 104% REPAIR/MAINTENANCE 143,460 483,144 799,591 (656,131) 557% MISCELLANEOUS 5,000 3,153 3,532 1,468 71% CONSTRUCTION PROJECTS 1,000,000 - - 1,000,000 0% $ 3,817,308 $ 2,519,036 $ 3,906,130 $ (88,822) 102% TOTAL GENERAL FUND EXPENDITURES $ 49,365,292 $ 42,573,794 $ 44,014,931 $ 5,350,361 89% 16 Packet Pg. 44 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2020 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 2,281,595 $ 2,281,595 $ 2,376,947 4.18% February 4,718,069 2,436,473 4,730,574 0.27% March 7,308,614 2,590,546 7,100,593 -2.85% April 10,754,361 3,445,746 9,435,773 -12.26% May 19,216,447 8,462,087 17,528,670 -8.78% June 21,772,150 2,555,703 19,628,003 -9.85% July 24,014,399 2,242,248 22,424,193 -6.62% August 26,829,604 2,815,205 24,769,057 -7.68% September 29,160,977 2,331,373 26,979,585 -7.48% October 32,996,001 3,835,024 30,980,306 -6.11% November 41,595,562 8,599,561 39,391,635 -5.30% December 44,055,157 2,459,595 41,660,318 -5.44% City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2020 Real Estate Excise Tax 1 & 2 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 193,769 $ 193,769 $ 323,203 66.80% February 345,606 151,837 496,485 43.66% March 547,140 201,534 685,999 25.38% April 740,550 193,410 857,110 15.74% May 973,673 233,123 998,087 2.51% June 1,219,609 245,935 1,240,599 1.72% July 1,532,815 313,206 1,463,854 -4.50% August 1,804,669 271,854 1,739,374 -3.62% September 2,081,138 276,470 2,115,408 1.65% October 2,301,037 219,898 2,574,968 11.90% November 2,520,239 219,202 2,993,059 18.76% December 2,700,000 179,761 3,350,684 24.10% *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 45 1 SALES TAX SUMMARY I 2.3.a I Sales Tax Analysis By Category Current Period: December 2020 Year -to -Date Total $8,317,046 Health & Personal Care, Automotive Repair, $248,327 , $189,028 Construction Trade, Accommodation, $1,322,318 $29,412 Clothing and Accessories, $247,699 Communications, $234,469 Wholesale Trade, $294,254 Misc Retail, $1,531,540 10,000,000 8,000,000 $ $5,840,764 6,741,838 6,000,000 4,000,000 2,000, 000 0 2014 2015 Others, $177,428 Amusement & Recreation, $44,910 Business Services, $862,084 Gasoline, $37,951 iii Retail Food Stores, $323,308 L Retail Automotive, $1,827,793 Manufacturing, $98,904 Eating & Drinking, $847,620 Annual Sales Tax Revenue 7 395 114 $8,406,296 $8,452,715 $8,317,046 $6,905,122 2016 2017 2018 L. 2019 YTD 2020 18 Packet Pg. 46 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2020 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 634,902 $ 634,902 $ 692,248 9.03% February 1,436,667 801,765 1,539,597 7.16% March 2,031,860 595,193 2,187,876 7.68% April 2,597,573 565,713 2,691,601 3.62% May 3,324,621 727,048 3,191,797 -4.00% June 3,990,697 666,076 3,761,924 -5.73% July 4,697,452 706,756 4,450,258 -5.26% August 5,482,731 785,279 5,184,289 -5.44% September 6,213,489 730,757 5,920,380 -4.72% October 6,961,050 747,562 6,719,684 -3.47% November 7,750,015 788,965 7,523,231 -2.93% December 8,450,000 699,985 8,317,046 -1.57% City of Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2020 Gas Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 81,408 $ 81,408 $ 82,496 1.34% February 168,408 87,000 177,747 5.55% March 245,012 76,604 260,308 6.24% April 308,737 63,725 337,848 9.43% May 358,094 49,357 395,193 10.36% June 392,813 34,720 430,775 9.66% July 419,421 26,607 463,305 10.46% August 441,879 22,458 489,325 10.74% September 462,623 20,744 510,729 10.40% October 486,497 23,874 535,796 10.13% November 524,782 38,285 571,050 8.82% December 579,600 54,818 639,670 10.36% Gas Utility Tax 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 19 Packet Pg. 47 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2020 Telephone Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 79,271 $ 79,271 $ 70,129 -11.53% February 154,920 75,649 134,128 -13.42% March 224,811 69,891 191,257 -14.93% April 298,919 74,108 254,236 -14.95% May 365,795 66,876 309,632 -15.35% June 433,375 67,580 361,422 -16.60% July 497,866 64,491 424,830 -14.67% August 563,527 65,661 479,371 -14.93% September 631,163 67,636 528,163 -16.32% October 697,753 66,590 579,582 -16.94% November 761,530 63,777 606,633 -20.34% December 823,900 62,370 666,374 -19.12% Electric Utility Tax 900,000 Telephone Utility Tax 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 �Prior Year City of Edmonds, WA Monthly Revenue Summary -Electric Utility Tax 2020 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ February March April May June July August September October November December 176,332 $ 369,755 530,960 710,778 852,710 974,520 1,088,754 1,199,457 1,311,314 1,428,233 1,552,157 1,684,800 176,332 $ 179,486 193,422 371,370 161,206 535,467 179,818 710,200 141,933 854,417 121,810 970,402 114,233 1,091,103 110,703 1,214,761 111,857 1,316,801 116,919 1,430,598 123,924 1,540,846 132,643 1,668,430 1.79% 0.44 % 0.85 % -0.08 % 0.20 % -0.42 % 0.22 % 1.28 % 0.42% 0.17 % -0.73 % -0.97 % Electric Utility Tax 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. 20 Packet Pg. 48 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2020 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 804,719 $ 804,719 $ 737,298 -8.38% February 1,363,439 558,720 1,256,012 -7.88% March 2,170,455 807,015 2,048,593 -5.61% April 2,696,703 526,248 2,538,466 -5.87% May 3,481,516 784,813 3,275,201 -5.93% June 4,099,586 618,070 3,855,044 -5.97% July 5,087,366 987,780 4,682,817 -7.95% August 5,941,343 853,977 5,382,918 -9.40% September 7,092,152 1,150,809 6,403,521 -9.71% October 7,892,798 800,646 7,186,022 -8.95% November 8,818,044 925,246 8,061,987 -8.57% December 9,384,958 566,914 8,608,757 -8.27% City of'Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2020 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 355,919 $ 355,919 $ 348,012 1.79% February 1,125,592 769,673 1,101,727 0.44% March 1,480,771 355,179 1,449,754 0.85% April 1,795,425 314,654 1,758,968 -0.08% May 2,150,929 355,505 2,107,634 0.20% June 2,466,536 315,606 2,417,745 -0.42% July 2,822,237 355,701 2,766,634 -1.97% August 3,592,736 770,499 3,521,551 -1.98% September 3,947,537 354,801 3,869,253 -1.98% October 4,262,734 315,197 4,179,529 -1.95% November 4,618,388 355,654 4,527,535 -1.97% December 4,921,433 303,045 4,840,626 -1.64% *The monthly budget forecast columns are based on a five-year average. 21 Packet Pg. 49 1 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2020 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 843,972 $ 843,972 $ 792,168 -6.14% February 1,528,418 684,445 1,457,427 -4.64% March 2,368,523 840,105 2,253,756 -4.85% April 3,057,434 688,911 2,905,227 -4.98% May 3,904,796 847,362 3,666,165 -6.11% June 4,601,743 696,947 4,301,071 -6.53% July 5,475,901 874,158 5,076,023 -7.30% August 6,170,772 694,871 5,723,561 -7.25% September 7,057,714 886,942 6,520,644 -7.61% October 7,759,947 702,233 7,174,847 -7.54% November 8,620,364 860,417 7,966,021 -7.59% December 9,307,969 687,605 8,619,282 -7.40% Unmeter Sewer Sales 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 Ir 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. 22 Packet Pg. 50 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2020 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 5,679,709 $ 5,679,709 $3,641,481 -35.89% February 8,968,628 3,288,919 7,564,087 -1S.66% March 12,589,688 3,621,060 10,796,906 -14.24% April 16,832,856 4,243,168 13,318,642 -20.88% May 20,005,510 3,172,654 17,123,820 -14.40% June 24,887,169 4,881,659 21,049,664 -15.42% July 28,851,500 3,964,332 24,352,711 -15.59% August 33,184,403 4,332,902 27,602,216 -16.82% September 36,703,429 3,519,026 31,099,506 -15.27% October 40,354,845 3,651,416 35,443,149 -12.17% November 44,855,461 4,500,616 38,995,587 -13.06% December 49,365,292 4,509,831 44,014,930 -10.84% City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2020 Non -Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 2,940,401 $ 2,940,401 $ 1,280,852 -56.44% February 3,425,904 485,503 2,717,261 -20.68% March 4,593,975 1,168,071 3,569,389 -22.30% April 6,436,480 1,842,505 3,731,670 -42.02% May 6,749,241 312,761 5,129,301 -24.00% June 8,560,250 1,811,009 6,488,886 -24.20% July 9,584,152 1,023,902 7,237,544 -24.48% August 11,039,405 1,455,253 8,074,263 -26.86% September 11,949,652 910,247 8,970,365 -24.93% October 12,620,072 670,421 10,148,912 -19.58% November 14,182,850 1,562,777 11,046,084 -22.12% December 15,412,119 1,229,269 12,751,867 -17.26% Non -Departmental 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 �- 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --ft— Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 23 Packet Pg. 51 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2020 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 26,361 $ 26,361 $ 23,825 -9.62% February 54,130 27,769 55,625 2.76% March 88,475 34,345 81,971 -7.35% April 119,273 30,799 106,847 -10.42% May 158,791 39,518 133,074 -16.20% June 205,911 47,121 160,080 -22.26% July 239,007 33,095 186,441 -21.99% August 285,476 46,469 212,640 -25.51% September 323,555 38,079 239,066 -26.11% October 346,924 23,369 266,797 -23.10% November 382,373 35,449 291,826 -23.68% December 418,912 36,539 322,555 -23.00% City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2020 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 25,001 $ 25,001 $ 28,750 15.00% February 50,898 25,897 60,151 18.18% March 76,062 25,164 87,486 15.02% April 101,769 25,706 114,642 12.65% May 126,945 25,177 142,030 11.88% June 151,749 24,804 169,276 11.55% July 177,563 25,814 196,288 10.55% August 203,939 26,376 222,950 9.32% September 229,480 25,541 249,862 8.88% October 254,419 24,939 276,971 8.86% November 279,429 25,010 303,765 8.71% December 306,685 27,256 331,095 7.96% Office of Mayor 0,000.00 0,000.00 0,000.00 1 50,000.00 0.00 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. 24 Packet Pg. 52 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2020 Human Resources Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 59,744 $ 59,744 $ 68,346 14.40% February 117,844 58,101 134,278 13.94% March 179,074 61,229 184,385 2.97% April 230,899 51,825 233,118 0.96% May 286,335 55,437 283,462 -1.00% June 357,648 71,312 335,262 -6.26% July 413,242 55,594 378,306 -8.45% August 471,867 58,625 423,682 -10.21% September 533,926 62,059 476,486 -10.76% October 593,700 59,774 535,390 -9.82% November 652,971 59,271 589,830 -9.67% December 744,339 91,368 692,901 -6.91% Municipal Court Human Resources 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 Prior Year City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 86,948 $ 86,948 $ 79,231 -8.88% February 180,887 93,939 166,073 -8.19% March 273,283 92,396 249,701 -8.63% April 366,614 93,331 331,047 -9.70% May 467,192 100,578 422,932 -9.47% June 555,697 88,505 507,527 -8.67% July 648,419 92,722 595,161 -8.21% August 746,531 98,112 681,851 -8.66% September 837,918 91,387 775,370 -7.46% October 938,286 100,369 872,107 -7.05% November 1,031,813 93,527 958,702 -7.09% December 1,142,871 111,058 1,072,252 -6.18% Municipal Court 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0---CurrentYeaz Budget �PriorYear *The monthly budget forecast columns are based on a five-year average. 25 Packet Pg. 53 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2020 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 49,473 $ 49,473 $ 40,001 -19.14% February 106,815 57,343 82,357 -22.90% March 166,402 59,586 123,069 -26.04% April 229,301 62,899 165,175 -27.97% May 287,815 58,515 210,066 -27.01% June 345,097 57,281 258,279 -25.16% July 407,184 62,087 309,288 -24.04% August 475,865 68,681 360,249 -24.30% September 535,484 59,620 408,834 -23.65% October 600,799 65,315 457,484 -23.85% November 671,407 70,608 532,055 -20.76% December 766,197 94,790 599,693 -21.73% City of Edmonds, WA Monthly Expenditure Report -City Clerk 2020 City Clerk Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 71,401 $ 71,401 $ 83,447 16.87% February 129,624 58,223 139,339 7.49% March 187,005 57,380 199,113 6.47% April 251,043 64,039 258,617 3.02% May 306,774 55,730 321,093 4.67% June 361,810 55,036 378,904 4.72% July 423,597 61,787 438,669 3.56% August 486,276 62,679 499,805 2.78% September 539,284 53,008 554,592 2.84% October 597,946 58,662 611,198 2.22% November 662,981 65,035 667,372 0.66% December 726,962 63,981 726,789 -0.02% City Clerk 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 *The monthly budget forecast columns are based on a five-year average. 26 Packet Pg. 54 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2020 Technology Rental Fund Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 185,528 $ 185,528 $ 81,888 -55.86% February 348,776 163,248 291,582 -16.40% March 463,657 114,881 352,886 -23.89% April 551,367 87,710 396,588 -28.07% May 653,419 102,052 462,422 -29.23% June 759,617 106,198 540,328 -28.87% July 847,836 88,218 612,976 -27.70% August 950,505 102,670 699,095 -26.45% September 1,072,316 121,810 807,205 -24.72% October 1,175,112 102,796 859,114 -26.89% November 1,283,884 108,772 912,391 -28.94% December 1,517,040 233,156 1,052,893 -30.60% Finance Technology Rental Fund 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Finance 2020 Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 124,756 $ 124,756 $ 148,549 19.07% February 235,691 110,935 251,089 6.53% March 337,197 101,506 353,610 4.87% April 438,143 100,947 456,877 4.28% May 539,685 101,542 562,662 4.26% June 639,437 99,752 795,796 24.45% July 750,562 111,125 879,925 17.24% August 854,084 103,522 964,589 12.94% September 970,025 115,941 1,050,712 8.32% October 1,081,072 111,048 1,133,433 4.84% November 1,184,488 103,415 1,219,675 2.97% December 1,289,583 105,095 1,306,188 1.29% Finance 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC +Current Yeaz Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 27 Packet Pg. 55 ■ 2.3.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2020 City Attorney Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 76,045 $ 76,045 $ 49,883 -34.40% February 1S2,090 76,045 142,611 -6.23% March 228,135 76,045 192,534 -15.61% April 304,180 76,045 288,462 -5.17% May 380,225 76,045 359,660 -5.41% June 456,270 76,045 431,895 -5.34% July 532,315 76,045 503,028 -5.50% August 608,360 76,045 574,161 -S.62% September 684,405 76,045 646,093 -5.60% October 760,450 76,045 718,169 -5.56% November 836,495 76,045 789,302 -5.64% December 912,540 76,045 860,435 -5.71% Police City Attorney 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Police 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 946,525 $ 946,525 $ 887,236 -6.26% February 1,903,561 957,036 1,893,712 -0.52% March 2,862,743 959,182 2,821,483 -1.44% April 3,833,127 970,384 3,703,720 -3.38% May 4,795,598 962,471 4,601,807 -4.04% June 5,794,682 999,084 5,628,905 -2.86% July 6,770,463 975,781 6,748,449 -0.33% August 7,713,554 943,091 7,666,496 -0.61% September 8,676,071 962,516 8,693,795 0.20% October 9,751,383 1,075,313 9,682,005 -0.71% November 11,010,326 1,258,942 10,862,724 -1.34% December 12,028,805 1,018,479 11,835,142 -1.61% Police 12,000,000 10,000,000 8,000,000 6,000,000 / 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. Z$ Packet Pg. 56 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2020 Development Services Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 250,206 $ 250,206 $ 241,446 -3.50% February 531,065 280,859 461,847 -13.03% March 821,086 290,021 685,780 -16.48% April 1,116,073 294,987 922,412 -17.35% May 1,419,690 303,617 1,151,071 -18.92% June 1,699,016 279,326 1,370,746 -19.32% July 1,993,964 294,949 1,608,527 -19.33% August 2,297,647 303,682 1,851,746 -19.41% September 2,596,160 298,513 2,083,333 -19.75% October 2,902,773 306,613 2,302,031 -20.70% November 3,243,027 340,254 2,519,329 -22.32% December 3,586,753 343,726 2,814,664 -21.53% Parks & Recreation Development Services 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 Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 315,980 $ 315,980 $ 278,296 -11.93% February 644,055 328,075 596,263 -7.42% March 992,773 348,718 892,745 -10.08% April 1,355,032 362,259 1,186,533 -12.44% May 1,728,939 373,906 1,472,976 -14.80% June 2,104,753 375,814 1,756,039 -16.57% July 2,577,915 473,162 2,047,976 -20.56% August 3,122,648 544,732 2,368,204 -24.16% September 3,564,579 441,931 2,706,435 -24.07% October 3,942,987 378,408 3,011,118 -23.63% November 4,272,423 329,437 3,343,289 -21.75% December 4,673,608 401,185 3,669,440 -21.49% Parks & Recreation 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 Year *The monthly budget forecast columns are based on a five-year average. 29 Packet Pg. 57 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Public Works Administration 2020 Public Works Administration Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 51,939 $ 51,939 $ 41,796 -19.53% February 105,536 53,597 83,385 -20.99% March 157,916 52,379 125,953 -20.24% April 210,278 52,362 169,511 -19.39% May 262,800 52,522 212,944 -18.97% June 316,459 53,659 256,932 -18.81% July 370,954 54,495 298,731 -19.47% August 422,825 51,871 340,410 -19.49% September 472,902 50,077 382,165 -19.19% October 524,167 51,265 423,243 -19.25% November 575,881 51,714 465,382 -19.19% December 630,194 54,313 506,952 -19.56% Facilities Maintenance Public Works Administration 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Yeaz Budget � Prior Year City of'Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 289,210 $ 289,210 $ 177,532 -38.61% February 594,641 305,431 353,835 -40.50% March 901,330 306,689 583,052 -35.31% April 1,199,698 298,368 781,557 -34.85% May 1,506,913 307,215 1,002,638 -33.46% June 1,767,916 261,003 1,175,527 -33.51% July 2,101,902 333,986 1,373,287 -34.66% August 2,408,736 306,834 1,592,675 -33.88% September 2,750,046 341,309 1,875,737 -31.79% October 3,059,033 308,987 2,799,364 -8.49% November 3,434,424 375,392 3,001,512 -12.61% December 3,817,308 382,884 3,906,130 2.33% Facilities Maintenance 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 30 Packet Pg. 58 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2020 Engineering Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 219,750 $ 219,750 $ 212,290 -3.39% February 436,542 216,792 426,262 -2.35% March 671,678 235,136 646,635 -3.73% April 915,104 243,427 868,452 -5.10% May 1,155,255 240,151 1,118,106 -3.22% June 1,402,970 247,715 1,335,611 -4.80% July 1,656,398 253,428 1,551,091 -6.36% August 1,917,510 261,112 1,768,495 -7.77% September 2,156,951 239,441 1,986,661 -7.89% October 2,402,446 245,495 2,204,927 -8.22% November 2,635,839 233,393 2,404,742 -8.77% December 2,908,416 272,577 2,618,828 -9.96% Engine a ring 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 31 Packet Pg. 59 I 2.3.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of December 31, 2020 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate Grant Cnty WA Bonds 4,014,120 0.00 4,000,000 4,000,000 01/01/21 1.47% First Financial CD 3,000,000 0.27 3,000,000 3,000,000 04/10/21 2.86% Port of Seattle WA Bonds 273,305 0.33 270,000 271,596 05/01/21 2.23% Grant Cnty WA Bonds 410,553 1.00 405,000 410,917 01/01/22 1.79% FFCB Bonds 1,998,548 1.45 2,000,000 2,049,978 06/14/22 1.88% Energy Northwest Bonds 1,466,077 1.50 1,345,000 1,441,114 07/01/22 5.00% Energy Northwest Bonds 260,748 1.50 250,000 259,535 07/01/22 2.95% Mason & Kitsap Cnty WA Bonds 948,084 1.92 855,000 931,411 12/01/22 5.00% Grant Cnty WA Bonds 1,517,955 2.00 1,500,000 1,536,300 01/01/23 1.54% Grant Cnty WA Bonds 576,332 2.00 520,000 569,587 01/01/23 5.00% Seattle WA Muni Bonds 2,224,500 2.09 2,000,000 2,198,740 02/01/23 5.00% FHLB Bonds 1,996,590 2.76 2,000,000 1,997,312 10/05/23 0.22% First Financial - ECA CD 2,803,516 2.87 2,803,516 2,803,516 11/15/23 2.10% Kent WA Bonds 286,648 2.92 250,000 284,558 12/01/23 5.00% Spokane County WA Bonds 259,075 3.92 250,000 265,183 12/01/24 2.10% First Financial - Waterfront Center CD 2,000,000 6.84 2,000,000 2,000,000 11/01/27 1.68% TOTAL SECURITIES 24,036,049 2.09 23,448,516 24,019,746 Washington State Local Gov't Investment Pool 21,445,523 21,445,523 Demand 0.16% Snohomish County Local Gov't Investment Pool 20,132,419 20,132,419 Demand 1.44% TOTAL PORTFOLIO $ 65,026,458 $ 65,597,688 Port of Seattle WA Issuer Diversification Seattle Muni, 9%� WA, 1%— F Kent WA, 1% Fi rst Financial - Mason & CD, 33% KitsapCnty Grant Cnty WA, 4% WA, 27% FFCB, 9% Spokane County WA, 1% E�FHLB, 9% Northwest, 7% Cash and Investment Balances Checking, (in $ Millions) —$5.4 , 8% Bonds, $15.6, 22% State LGIP, CD's, $7.8, $21.4, 30% 11% County LGIP, 32 Packet Pg. 60 1 I 2.3.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,200,000 $1,000,000 917 754 $969 614 $800,000 $653,690 $600,000 335 926 $423,816 $400,000 $200,000 IU 2015 2016 2017 2018 2019 YTD 2020 Edmonds Rate of Return Compared to Benchmark (Rolling 12 months) - - 6 Month Treasury Rate (Benchmark) City Blended Rate 2.0% — 1.8 1.5% 1.3% — 1.0% 0.8 0.5 % ♦ — 0.3% , 0.0% T I I --I January March May July September November Maturity Distribution and Rate of Return $ 8,000, 000 6.00% $7,000,000 5.00% $6,000,000 $ 5,000, 000 4.00 $4,000, 000 3.00% $3,000,000 2.00% $2,000,000 ' $1,000, 000 1.00% $- - 0.00% 0-6 Mo 6-12 12-18 18-24 24-30 30-36 36-42 42-48 48-54 54-60 60-66 66-72 72-78 78-84 Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo 33 Packet Pg. 61 I 2.3.a I GENERAL FUND OVERVIEW FUND BALANCES CHANGE IN FUND BALANCES GENERAL FUND & SUBFUNDS ---- ACTUAL ---- ---- ACTUAL ---- 12/31 /2019 9/30/2020 12/31 /2020 Q4 YTD 001-General Fund $ 15,552,187 $ 11,432,266 $ 13,197,574 $ 1,765,308 $ (2,354,61, 009-Leoff-Medical Ins. Reserve 355,874 379,625 537,176 157,551 181,30, 012-Contingency Reserve Fund 1,782,149 1,782,149 1,782,149 - - 014-Historic Preservation Gift Fund 12,187 14,687 17,187 2,500 5,00( 016-Building Maintenance 210,221 210,221 210,221 - - 017 - Marsh Restoration & Preservation 864,491 864,591 864,616 25 12! 018 -Edmonds Homelessness Response 223,581 223,581 123,581 (100,000) (100,00( 019 - Edmonds Opioid Response 50,000 50,000 28,445 (21,555) (21,55! Total General Fund & Subfunds $ 19,050,690 $ 14,957,121 $ 16,760,950 $ 1,803,829 $ (2,289,74( *$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. *$7,720,000 of the fund balance in Fund 001 added to the $1,782,149 balance in Fund 012, represent the required 20% operating reserve. General Fund & Subfunds 21 � - 18 General Fund 15 $9 33 & Subfunds 12 $5.24 $7.04 General Fund c Operating Reserve = 9 ■ Civic Field 6 $7.72 $7.72 3 — $2.00 $2.00 Dec 2019 Sept 2020 Dec 2020 *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. 62 2.3.a GOVERNMENTAL FUNDS OVERVIEW CHANGE IN FUND FUND BALANCES BALANCES O GOVERNMENTAL ---- ACTUAL ---- FUNDS ---- ACTUAL ---- 12/31 /2019 9/30/2020 12/31 /2020 Q4 YTD F0 General Fund & Subfunds $ 19,050,690 $ 14,957,121 $ 16,760,950 $ 1,803,829 $ (2,289,74C a c Special Revenue 10,622,237 10,235,228 10,677,595 442,366 55,357 ii Debt Service - (0) (0) - (C Capital Projects 6,443,150 6,878,746 6,083,409 (795,337) (359,741 a� O Total Governmental Funds $ 36,116,078 $ 32,071,095 $ 33,521,954 $ 1,450,859 $ (2,594,12z CY 0 N O N L d E d d Governmental Fund Balances -By Fund Group Governmental Fund Balances - � Combined L 21 40 d 0 $19.05 $36.12 O 18 35 33.52 $32.07 Q' m $16.76 General � 15 Fund & 30 v Subfunds R 25 O c2 12 c ii . t Special $10.68 Revenue 2 20 N 9 to 15 CY 6 $6.08—� iCapital 0 o Projects 10 N L d 3 5 m m Dec 2019 Sept 2020 Dec 2020 Dec 2019 Sept 2020 Dec 2020 Q. E O U c O E t U O 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. 63 2.3.a SPECIAL REVENUE FUNDS OVERVIEW GOVERNMENTAL SPECIAL REVENUE FUND BALANCES CHANGE IN FUND BALANCE: ---- ACTUAL ---- 12/31/2019 9/30/2020 12/31/2020 ---- ACTUAL ---- Q4 YTD 104 - Drug Enforcement Fund $ 39,839 $ 73,859 $ 74,225 $ 366 $ 34,38E 111 -Street Fund 1,298,473 1,067,380 1,130,956 63,576 (167,517 112- Combined Street Const/Improve 1,421,769 2,127,421 2,058,018 (69,403) 636,24E 117 - Municipal Arts Acquis. Fund 634,011 646,333 687,118 40,786 53,107 118 - Memorial Street Tree 19,785 20,222 20,321 100 53E 120 - Hotel/Motel Tax Revenue Fund 93,013 101,933 66,623 (35,310) (26,39C 121 - Employee Parking Permit Fund 86,844 98,101 107,473 9,372 20,62� 122 - Youth Scholarship Fund 13,600 13,443 13,897 454 297 123 -Tourism Promotional Fund/Arts 72,101 85,168 79,127 (6,041) 7,02E 125 -Real Estate Tax 2,625,364 2,572,735 2,377,100 (195,635) (248,264 126 - Real Estate Excise Tax 1 2,486,325 2,347,350 2,191,413 (155,938) (294,912 127 - Gifts Catalog Fund 332,255 312,548 299,728 (12,820) (32,52-1 130 - Cemetery Maintenance/Improvement 260,685 239,431 206,777 (32,654) (53,90E 136 - Parks Trust Fund 163,071 166,670 167,491 821 4,42C 137 - Cemetery Maintenance Trust Fund 1,053,314 1,086,243 1,095,308 9,065 41,994 138- Sister CityCommission 10,129 12,868 10,419 (2,448) 291 140 -Business Improvement Disrict 11,546 28,653 19,682 (8,971) 8,13E 141 -Affordable and Supportive Housing Fd 112 51,036 71,745 20,709 71,63: 142 - Edmonds Cares Fund - (816,165) 174 816,339 174 Total Special Revenue $ 10,622,237 $ 10,235,228 $ 10,677,595 $ 442,366 $ 55,35-1 *$200,000 of the fund balance in Fund 125 has been reserved for Marsh Restoration Funding 12 10 8 Ln c 0 6 4 Dec 2019 Special Revenue Funds ■ Special $10.04 $10.48 Revenue I Sept 2020 Dec 2020 ■ Fund 125 - 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. 36 Packet Pg. 64 I 2.3.a I ENTERPRISE FUNDS OVERVIEW FUND BALANCES CHANGE IN FUND ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- FUNDS 12/31/2019 9/30/2020 12/31/2020 Q4 YTD 421 -Water Utility Fund $ 23,049,550 $ 22,426,629 $ 21,890,731 $ (535,898) $ (1,158,82C 422 - Storm Utility Fund 12,607,151 10,936,388 10,358,205 (578,182) (2,248,94E 423 - Sewer/WWTP Utility Fund 46,572,051 45,952,697 53,010,893 7,058,195 6,438,841 424 - Bond Reserve Fund 843,961 843,970 843,973 3 12 411 -Combined Utility Operation - 31,765 32,495 730 32,49E Total Enterprise Funds $ 83,072,713 $ 80,191,449 $ 86,136,296 $ 5,944,847 $ 3,063,58: *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding Enterprise and Agency Fund Balances as of December 31, 2020 60,000,000 55,000,000 $53,010,893 50,000,000 45,000,000 40,000,000 35,000,000 — 30,000,000 25,000,000 $21 890 731 20,000,000 15,000,000 10,000,000 $1 1 205 5,000,000 $32,495 $843,973 0 $250,000 $120,115 Combined Utility Water Storm Storm - Marsh Sewer/WWTP Bond Reserve Firemen's Restoration Funding Pension Fund *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 37 Packet Pg. 65 2.3.a SUMMARY OVERVIEW CITY-WIDE FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- 12/31 /2019 9/30/2020 12/31 /2020 ---- ACTUAL ---- Q4 YTD Governmental Funds Enterprise Funds Internal Services Fund Agency Funds $ 36,116,077 83,072,713 10,803,067 146,733 $ 32,071,095 80,191,449 11,538,939 139,708 $ 33,521,954 86,136,296 9,899,906 120,115 $ 1,450,859 $ (2,594,124 5,944,847 3,063,58c (1,639,033) (903,161 (19,592) (26,617 Total City-wide Total $130,138,590 $123,941,191 $129,678,271 $ 5,737,081 $ (460,31� Governmental Fund Balances (Excluding General Fund) as of December 31, 2020 Drug Enforcement Fund _ $74,225 Street Fund Combined Street ConsUlmprove Fund Municipal Arts Acquis. Fund $687 Memorial Street Tree Fund $20,321 Hotel/Motel Tax Revenue Fund 1 $66,623 Employee Parking Permit Fund 0 $107,473 Youth Scholarship Fund $13,897 Tourism Promotional Fund/Artst72 Real Estate Excise Tax 2 Real Estate Excise Tax 1 Gifts Catalog FundCemetery Maintenance/ImprovementParks Trust Fund Cemetery Maintenance Trust Fund Sister City Commission $10,419 Business Improvement District $19,682 Affordable and Supportive Housing Fund $71,745 Edmonds Cares Fund $174 Parks Capital Construction Fund $11130,956 $1,095,308 $2,058,0 1 $2,37 ,100 $2,191, 13 $- $1,500,000 $3,000,000 $4,500,000 $6,083,409 $6,000,000 *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 38 Packet Pg. 66 I 2.3.a I INTERNAL SERVICE FUNDS OVERVIEW FUND BALANCES CHANGE IN FUND i INTERNAL SERVICE BALANCES o ---- ACTUAL ---- ---- ACTUAL ---- FUNDS 12/31 /2019 9/30/2020 12/31 /2020 Q4 YTD s 511- EquipmentRental Fund $ 10,016,269 $ 10,654,871 $ 8,890,160 $ (1,764,712) $ (1,126,11C u 512 -Technology Rental Fund 786,798 884,068 1,009,746 125,678 222,94E t Total Internal Service Funds $ 10,803,067 $ 11,538,939 $ 9,899,906 $ (1,639,033) $ (903,161 12,000,00 10,000,00 8,000, 00 6,000, 00 4,000, 00 2,000, 000 Internal Service Fund 5 10,654,871 786.798 �$884,068 Dec 2019 Sept 2020 $8,890,160 1,009,746 Dec 2020 ■ 511- Equipment Rental Fund ■512- Technology Rental Fund *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 39 Packet Pg. 67 2.3.b GENERAL FUND CHANGES IN FUND BALANCE 2015 2016 2017 2018 2019 2020 (Preliminary) Beginning Fund Balance 6,446,380 9,359,435 9,841,718 10,273,343 11,233,278 15,552,188 Revenue Taxes 28,714,539 29,403,794 29,572,203 30,755,578 30,846,665 30,530,552 Licenses and permits 2,132,897 2,269,313 2,506,800 2,401,855 2,299,972 2,280,382 Intergovernmental 977,585 1,261,998 890,572 1,014,434 1,008,432 1,239,098 Charges for services 5,150,816 5,403,786 5,463,913 5,810,961 6,419,836 5,210,479 Fines and forfeitures 535,078 522,051 459,929 616,783 496,093 287,693 Investment earnings 70,045 (26,712) 154,739 273,226 573,806 332,096 Miscellaneous 435,414 441,432 471,675 931,495 587,882 227,242 Operating Revenues 38,016,374 39,275,661 39,519,831 41,804,331 42,232,687 40,107,541 Nonoperating Revenues Transfers in 822,175 82,695 26,300 75,884 4,793,650 1,535,800 Debt proceeds - 549,095 - - - - Sale of capital assets - 58,451 7,143 5,273 - - Insurance recoveries - - - 15,570 - 16,977 Total Revenue 38,838,549 39,965,902 39,553,274 41,901,058 47,026,337 41,660,318 Expenditures General government 8,836,333 9,969,187 9,714,867 10,288,694 11,565,563 13,082,198 Public safety 19,371,912 20,128,896 22,228,871 22,585,212 23,036,185 23,645,907 Transportation 3,600 3,600 3,600 4,779 5,012 5,430 Economic environment 1,353,548 1,313,430 1,551,152 1,460,763 1,562,702 1,675,334 Mental and physical health 69,762 70,814 126,791 178,859 164,888 357,982 Culture and recreation 3,591,029 3,773,633 3,959,731 4,331,806 4,158,397 3,735,413 Debt service 272,793 196,663 198,361 197,694 197,967 296,624 Capital outlay 92,202 56,662 90,573 93,105 110,935 9,053 Operating Expenditures 33,591,179 35,512,885 37,873,946 39,140,912 40,801,649 42,807,941 Nononeratina Expenditures Transfers out 2,334,315 3,414,141 1,247,703 1,800,212 1,905,778 1,206,990 Debt refunding - 556,593 - - - - Total Expenditures 35,925,494 39,483,619 39,121,649 40,941,124 42,707,427 44,014,931 Prior Period Adjustments - - - - - - Change in position 2,913,055 482,283 431,625 959,934 4,318,910 (2,354,613) Ending Fund Balance 9,359,435 9,841,718 10,273,343 11,233,278 15,552,188 13,197,575 r Q R:\Finance Committee\2020\Jan-Dec 2020 P&L -Revised 2/4/2021 Packet Pg. 68 2.4 City Council Agenda Item Meeting Date: 02/9/2021 2021 Carryforward Budget Amendment Staff Lead: Dave Turley Department: Administrative Services Preparer: Marissa Cain Background/History Amend the 2021 Ordinance No. 4211 Staff Recommendation Staff recommends that Council add the 2021 Carryforward Budget Amendment to the Consent Agenda on February 16th for the approval of Ordinance No. XXXX amending the 2021 Budget. Attachments: 2021 Carryforward Budget Amendment Exhibits 2021 Carryforward Budget Amendment Ordinance Packet Pg. 69 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Unfreezing park maintenance positions that were not included in the 2021 budget. One (1) Senior Parks Maintenance Worker and four (4) Seasonal Parks Maintenance Laborers (two of them for the beautification program). These positions are critical to providing the current level of service and keeping our parks clean and safe for all to enjoy. In 2020 the seasonal positions were filled late which made catching up with the Spring growing season very challenging. Parks have seen a significant increase in usage since the pandemic hit, therefore these positions have been deemed highly necessary. Department: Parks, Recreation & Cultural Services Fund Name: 001 GENERAL Division: Parks Title: 2021 Frozen Positions: FTE and Seasonals Preparer: Shannon Burley Budget Amendment Type New Item For Council To Consider 2020 Adopted Budget Date of Discussion or Budget Approval? How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.64.576.80.11.00 Salaries: 2 Seasonal Park Maint Laborers $ 28,526 $ S $ S 001.000.64.576.80.23.00 Benefits: 2 Seasonal Park Maint Laborers 2,183 001.000.64.576.81.11.00 Salaries: 2 Seasonal Beautification Workers 23,140 001.000.64.576.81.23.00 Benefits: 2 Seasonal Beautification Workers 1,770 001.000.64.576.80.11.00 Salaries: 1 FTE Senior Park Maint Worker 61,788 001.000.64.576.80.23.00 1 Benefits: 1 FTE Senior Park Maint Worker 7,341 Total Expenditure Increase(Decrease 1 1 $ 124,748 $ S $ S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 Beginning Fund Balance S 124,748 $ S $ S Total Beginning Fund Balance Increase(Decrease) $ 124,748 $ S $ S C O E C N E a r O m L 2M C O M t� N O N to r t k W r� C O E C N E a m L 3M L O L �M♦ V r N O N C O E t V O ++ Q Packet Pg. 70 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: The trial regarding the City's easement in front of the Ebb Tide Condominiums has been postponed due to Covid-19. This is the funding for expert witnesses. Department: Parks, Recreation & Cultural Services Fund Name: 001 GENERAL Division: Parks Title: Ebb Tide Litigation Professional Witness Fees Preparer: Shannon Burley Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.64.571.21.41.00 Ebb Tide Litigation Professional Witness Fees $ 17,250 $ S $ $ Total Expenditure Increase Decrease $ 17,250 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 Beginning Fund Balance S 17,250 $ S $ S Total Beginning Fund Balance Increase Decrease $ 17,250 $ S $ $ Q Packet Pg. 71 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Sign was fabricated in 2020 however delivery is delayed due to COVID-19. Department: Parks, Recreation & Cultural Services Division: Parks Fund 001 GENERAL Title: Portico Informational Panel Name: Preparer: Shannon Burley Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000. 11.511.60.49. 10 Portico Informational Panel $ 1,985 $ S $ $ Total Expenditure Increase Decrease $ 1,985 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 Beginning Fund Balance $ 1,985 $ S $ S Total Beginning Fund Balance Increase Decrease $ 1,985 $ S $ $ C O E C N E a r O m L 2M C O M t� N O N to r t k W r� C O E C N E a m L 3M L O L �M♦ V r N O N C O E t V O ++ Q Packet Pg. 72 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: The Urban Forest Management Plan (UFMP) included a goal to update the City of Edmonds Street Plan and to develop and maintain an inventory of trees in key public places. After UFMP adoption, a professional services agreement was reached with the Watershed Company to help staff move forward with updating the Street Tree Plan to implement the UFMP. Some work was begun but due to COVID impacts, the project is behind. The remaining work will be completed in 2021. Department: Development Services Division: Administration 62.524.10 Fund 001 GENERAL Title: Street Tree Plan and Inventory Name: Preparer: Kernen Lien Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? 12/10/2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.62.524.10.41.00 Professional Services $ 20,000 $ S $ $ Total Expenditure Increase Decrease $ 20,000 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 Beginning Fund Balance S 20,000 $ S $ S Total Beginning Fund Balance Increase Decrease $ 20,000 $ S $ $ Q Packet Pg. 73 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Climate Goals Project: The Climate Goals Project was initiated to follow up on Council Resolution # 1389. Part of the work is being carried out with the professional services assistance of ESA. While much of the work identified in the professional services agreement has been completed, $15,292 remained unspent at the end of 2020. This amount is requested for carryforward into 2021. Department: Development Services Fund Name: 001 GENERAL Division: Administration 62.524.10 Title: Climate Goals Project Preparer: Kernen Lien Budget Amendment Type Previously Approved Budget By Council Previous Year Carryforward Amendment Date of Discussion or Budget Approval? 12/05/2017 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating IL Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.62.524.10.41.00 Professional Services $ 15,292 $ S $ $ Total Expenditure Increase Decrease $ 15,292 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S S S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 Beginning Fund Balance $ 15,292 $ S $ S Total Beginning Fund Balance Increase Decrease $ 15,292 $ S $ $ C O E C N E r O m L 2M C O M t� N O N to r t k W r� C O E C N E a m L 3M L O L �M♦ V r N O N C O E t V O ++ Q Packet Pg. 74 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: The next step of the Climate Goals Project is to update the City's 2010 Climate Action Plan. A professional service agreement was entered into with ESA to draft the Climate Action Plan (CAP) document. Due to the COVID-19 pandemic, little work was completed on updating the CAP. Of the $30,000 in the PSA, only $2,310 has been expended. We are requesting the remaining $27,690 for carryforward into 2021. Department: Development Services Fund Name: 001 GENERAL Division: Administration 62.524.10 Title: Climate Action Plan Update (ESA) Preparer: Kernen Lien Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? 12/10/2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.62.524.10.41.00 Professional Services $ 27,690 $ S $ $ Total Expenditure Increase Decrease $ 27,690 S $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 Beginning Fund Balance S 27,690 $ S $ S Total Beginning Fund Balance Increase Decrease $ 27,690 $ S $ $ C O E C N E r O m L 2M C O M t� N O N to r t k W r� C O E C N E a m L 3M L O L �M♦ V r N O N C O E t V O ++ Q Packet Pg. 75 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: The next step of the Climate Goals Project is to update the City's 2010 Climate Action Plan. The City entered into a professional services agreement with Cascadia Consulting Group near the end of 2020 to assist the City in public engagement for the Climate Action Plan update. No invoices were received for the 2020 budget, so we are requesting the entire $30,000 of this PSA for carryforward into 2021. Department: Development Services Fund Name: 001 GENERAL Division: Administration 62.524.10 Title: Climate Action Plan Public Engagement (Cascadia) Preparer: Kernen Lien Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? 12/10/2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.62.524.10.41.00 Professional Services $ 30,000 $ S $ $ Total Expenditure Increase Decrease $ 30,000 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 Beginning Fund Balance $ 30,000 $ S $ S Total Beginning Fund Balance Increase Decrease $ 30,000 $ S $ $ Q Packet Pg. 76 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: The contract approved by Council was a total of $35,000. $29,137 remains unspent and can be carried over to support code update research and assistance. Department: Development Services Division: Administration 62.524.10 Fund 001 GENERAL Title: Code Research (BHQ Name: Preparer: Shane Hope Budget Amendment Type New Item For Council To Consider 2020 Adopted Budget Date of Discussion or Budget Approval? How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.62.524.10.41.00 Professional Services $ 29,137 $ S $ $ Total Expenditure Increase Decrease $ 29,137 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ S $ S Total Revenue Increase(Decrease) S $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.308.00.000.00 S 29,137 $ S $ S Total Beginning Fund Balance Increase Decrease $ 29,137 $ S $ $ C O E C N E r O m L 2M C O M t� N O N to r t k W r� C O E C N E a m L 3M L O L �M♦ V r N O N C O E t V O ++ Q Packet Pg. 77 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: NR Employee Salary Study funds. This was approved by council at the 12/10/2019 meeting but we were unable to complete the study in 2020 due to the impact of COVID-19. Department: Human Resources Division: Human Resources Fund Title: HR Analyst Name: 001 GENERAL Preparers I Emily Wagener Budget Amendment Type New Item For Council To Consider Previous Year Carryforward Amendment Date of Discussion or Budget Approval? Dec 10 2019 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 2021 2022 2023 2024 2025 001.000.22.518.10.41.00 Professional Services $ 30,000 $ S $ S Total Expenditure Increase Decrease $ 30,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S- Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2 222 2023 2024 2025 001.000.308.00.000.00 Professional Services $ 30,000 $ S $ S Total Beginning Fund Balance Increase Decrease $ 30,000 $ $ $ $ C O E C N E r O fb L 2M C O M t� N O N r t k W C O E C N E a O fb L 3M L O L �M♦ V r N O N C O E t V O ++ Q Packet Pg. 78 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: This project has started but was delayed due to necessary permits being acquired. The project will be completed in 2021. Department: Parks, Recreation & Cultural Services ■ Division: Parks Fund 125 REET 2 Title: City Park Walkway Pedestrian Safety Project Name: Preparer: Shannon Burley Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 125.000.64.594.76.65.00 City Park Walkway Pedestrian Safety Project $ 30,000 $ S $ S Total Expenditure Increase Decrease $ 30,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S- Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2 222 2023 2024 2025 125.000.308.30.000.00 Beginning Fund Balance $ 30,000 $ S $ S Total Beginning Fund Balance Increase Decrease $ 30,000 $ $ $ C O E C N E a r O fb L 2M C O M t� N O N r t k W C O E C N E a O fb L 3M L O L �M♦ V r N O N C O E t V O ++ Q 10 Packet Pg. 79 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: In early 2020, a radar feedback sign was installed along 84th Ave. W facing the southbound movement (south of 230th / within Snohomish County). Another evaluation was completed in 2020 and a radar feedback sign has been installed along 80th Ave. W (between 196th St. SW and 188th St. SW / facing northbound movement). The carryforward will be used to add additional traffic calming devices throughout the City in 2021. Department: Public Works Fund Name: 126 REET 1 Division: Engineering Title: 2020 Traffic Calming Program Preparer: Bertrand Hauss Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 126.000.68.542.64.48.00 R & M - Traffic Control $ 9,395 $ S $ S Total Expenditure Increase Decrease $ 9,395 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S— Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 126.000.308.30.000.00 Beginning Fund Balance $ 9,395 $ S $ S Total Beginning Fund Balance Increase Decrease $ 9,395 $ $ $ S C O E C N E a r O m L 2M C O M t� N O N r t k W C O E C N E a O m L 3M L O L �M♦ V r N O N C O E t V O ++ Q 11 Packet Pg. 80 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: In 2020, existing guardrails at Sprague St., Maple St, and Daley St. were identified for replacement due to their poor condition. A construction contract was executed in December 2020 and the replacement work will be completed in January 2021. The carryforward will be used to pay the contractor after the work is completed. Department: Public Works Division: Engineering Fund 126 REET 1 Title: 2020 Guardrail Program Name: Preparer: Bertrand Hauss Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 126.000.68.542.64.41.67 Interfund Services $ 1,000 $ S $ S 126.000.68.542.64.48.00 R & M - Traffic Control $ 15,655 $ Total Expenditure Increase Decrease $ 16,655 $ S $ S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S— Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 126.000.308.00.000.00 Beginning Fund Balance $ 16,655 $ S $ $ Total Beginning Fund Balance Increase Decrease $ 16,655 $ S $ $ C O E C N E a r O fb L 2M C O M t� N O N to r t k W C O E C N E a O fb L 3M L O L �M♦ V r N O N C O E t t) O ++ Q 12 Packet Pg. 81 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Design phase for project going at a slightly slower pace than planned. Monies moved reflect amount that was unspent in the 2020 design phase that will be now expended in 2021. Department: Public Works Division: Engineering Fund 421 WATER Title: Phase 11 Waterline Replacement (EOJA/c549) Name: Preparer: Michele (Mike) De Lilla Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.74.534.34.41.67 Interfund Services $ 15,000 $ $ $ S 421.000.74.594.34.41.00 Capital Professional Services 22,054 Total Expenditure Increase Decrease $ 37,054 1 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ $ $ S Total Revenue Increase Decrease $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.308.00.000.00 Beginning Fund Balance $ 37,054 $ $ $ $ Total Beginning Fund Balance Increase Decrease $ 37,054 $ S $ $ C O E C N E a r O m L 2M C O M V N O N to r Z k W r� C E C N E a r O m E 2M C O L �M♦ V r N O N C O E t t) O ++ Q 13 Packet Pg. 82 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Project was substantially complete in late 2020. A carry forward of construction funds will pay for the remaining expenses. Department: Public Works Fund Name: 421 WATER Division: Engineering Title: Phase 10 Waterline Replacement (E7JA/c498) Preparer: Michele (Mike) De Lilla Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.74.534.34.41.67 Interfund Services $ 24,000 $ $ $ S 421.000.74.594.34.41.00 Capital Professional Services 4,000 421.000.74.594.34.65.10 Construction 12,000 Total Expenditure Increase (Decrease) $ 40,000 1 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ $ $ S Total Revenue Increase Decrease $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.308.00.000.00 Beginning Fund Balance $ 40,000 $ $ $ $ Total Beginning Fund Balance Increase Decrease $ 40,000 $ S $ $ C O E C N E a r O m L 2M C O M V N O N to r k W r� C E C N E a r O m E 2M C O L �M♦ V r N O N C O E t V O Q 14 Packet Pg. 83 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Project was substantially complete in late 2020. A carry forward of construction funds will pay for the remaining expenses. Funds will also be used to finalize utility easements through the Swedish Edmonds Campus. Department: Public Works Fund Name: 421 WATER Division: Engineering Title: Swedish & 76th Waterline Replacement (EMA/623) Preparer: Michele (Mike) De Lilla Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.74.534.34.41.67 Interfund Services $ 24,000 $ $ $ S 421.000.74.594.34.41.00 Capital Professional Services 4,000 421.000.74.594.34.65.10 Construction 12,000 Total Expenditure Increase (Decrease) $ 40,000 1 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 Total Revenue Increase Decrease $ $ S $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.308.00.000.00 Beginning Fund Balance $ 40,000 $ $ $ $ Total Beginning Fund Balance Increase Decrease $ 40,000 $ S $ $ C O E C N E a r O m L 2M C O M V N O N to r k W r� C E C N E a r O m E 2M C O L �M♦ V r N O N C O E t t) O ++ Q 15 Packet Pg. 84 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Funds for purchase of new software reserved with 2020 Q4 budget amendment. The purchase was initially planned for the end of 2020. However, due to a storm event, progress was slowed. And since it is a three- year license that begins on February 1, 2021, the cost for the software should come from the 2021 Budget. Contracting is underway and the payment for new software and grant reimbursement will occur in 2021. Department: Public Works Division: Engineering Fund 422 STORM Title: NPDES Pro Software Purchase Name: Preparer: Zachary Richardson - Stormwater Engineer Budget Amendment Type Previously Approved Budget By Council 4th Quarter Budget Amendment 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? 10perating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.72.531.90.49.20 Miscellaneous Engineering $ 23,000 $ S $ $ Total Expenditure Increase Decrease $ 23,000 S $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.334.03.102.40 Ecology Capacity Grant $ 23,000 $ S $ S Total Revenue Increase Decrease $ 23,000 $ S $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Beginning Fund Balance Increase(Decrease) S $ S $ S C O E C N E a r O m L 2M C O M t� N O N to r t k W r� C O E C N E a m L 3M L O L �M♦ V r N O N C O E t V O ++ a 16 Packet Pg. 85 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Project constructed but still in close-out process; additional programming work at control panel anticipated in 2021 as well. Carry forward all unused funds to 2021 to fund completion. Department: Public Works Division: Engineering Fund 422 STORM Title: Dayton Street Stormwater Pump Station (E4FE/c455) Name: Preparer: Zachary Richardson - Stormwater Engineer Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.72.531.31.41.67 Interfund Services $12,000 $ S $ $ 422.000.72.594.31.41.00 Capital Profesional Services 15,000 422.000.72.594.31.65.20 Construction Projects 120,000 Total Expenditure Increase Decrease $ 147,000 S S $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.391.80.100.00 Snohomish County Loan $ 136,250 $ S $ S Total Revenue Increase(Decrease) $ 136,250 $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.308.00.000.00 Beginning Fund Balance S 10,750 $ S $ S Total Beginning Fund Balance Increase Decrease $ 10,750 $ S $ S C O E C N E a r O m L 2M C O M t� N O N to r t k W r� C O E C N E a 00 L 3M L O L �M♦ V r N O N C O E t t) O ++ Q 17 Packet Pg. 86 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Project design underway; carry forward all unused funds to 2021 to fund completion. Department: Public Works Division: Engineering Fund 422 STORM Title: Seaview Park Infiltration Facility Phase 2 (EOFA/c546) Name: Preparer: Zachary Richardson - Stormwater Engineer Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? Partially Funded What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.72.531.31.41.67 Interfund Services - Capital $ 11,407 $ S $ $ 422.000.72.594.31.41.00 Capital Profesional Services 115,000 Total Expenditure Increase Decrease $ 126,407 S $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.334.03.103.00 Ecology Grant $ 93,675 $ S $ S Total Revenue Increase Decrease $ 93,675 $ S $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.308.00.000.00 Beginning Fund Balance $ 32,732 $ S $ S Total Beginning Fund Balance Increase Decrease $ 32,732 $ S $ S C O E C N E a r O m L 2M C O M t� N O N to r t k W r� C O E C N E a 00 L 3M L O L �M♦ V r N O N C O E t V O ++ Q 18 Packet Pg. 87 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: The final pre -design report will be completed in the first quarter of 2021. The carry forward will program unused funds to pay for the remaining work. Department: Public Works Division: Engineering Fund 422 STORM Title: Lake Ballinger Regional Facility Pre -Design Phase (EWAAs022) Name: Preparer: Zachary Richardson - Stormwater Engineer Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.72.531.31.41.67 Interfund Services $ 38,190 $ S $ $ 422.000.72.531.90.41.20 Profesional Services - Engineering 59,710 Total Expenditure Increase Decrease $ 97,900 S $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 422.000.308.00.000.00 Beginning Fund Balance S 97,900 $ S $ S Total Beginning Fund Balance Increase Decrease $ 97,900 $ S $ S C O E C N E a r O m L 2M C O M t� N O N to r t k W r� C O E C N E a 00 L 3M L O L �M♦ V r N O N C O E t t) O ++ Q 19 Packet Pg. 88 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: 1 ) The 2021 carryforward for the Carbon Recovery Project is for the final design, permitting fees (C511) and equipment purchase in the amount of $2,999,300. The Carbon Recovery Project consists of Project A and Project B funding approvals. All permitting fees from Project A have not been exhausted and were not re -budgeted in Project B therefore permitting fees from Project A are required to completed Project B. The City Council approved the purchase of the Schwing pump 2 years ago. The pump was put on hold to ensure that it met the needs of final configuration. We need to ensure that funds are available for the purchase. The price has not increased from the original contract that the City Council approved. 2) Within Fund 423 there is a program for the Wastewater Treatment Plant (WWTP) Capital Program, 423.100. The capital portion, which is per a contract, is recorded into 423.100. In order to properly record revenues related to the WWTP for the City of Edmonds portion of the contract, an entry is needed to move funds from the operating program into the capital program. $1,523,255 of the $4,522,555 expenditures below is for the interfund transfer required to move funds from the sewer operating fund into the treatment plant capital program. Department: iPublic Works Fund Name: 423 SEWER / TREATMENT PLANT Division: iWastewater Treatment Plant Title: I WWTP Capital Carryforward Preparer: Preparer: M Derrick / Reviewer: P Randolph Budget Amendment Type New Item For Council To Consider 2020 Adopted Budget Date of Discussion or Budget Approval? How is this amendment funded? Partially Funded What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 423.100.76.594.39.65.10 Construction Projects S 2,999,300 S $ S $ 423.000.75.597.35.55.23 Interfund Transfer 1,523,255 Total Expenditure Increase Decrease $ 4,522,555 1 $ S S S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 423.100.374.07.010.00 Mountlake Terrace 23.174% S 695,058 $ $ $ 423.100.374.07.020.00 Olympic View (16.551%) 496,414 423.100.374.07.030.00 Ronald WD 9.488% 284,573 423.100.397.38.423.20 InterFund (50.787%) 1,523,255 Total Revenue Increase Decrease $ 2,999,300 1 $ $ S S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 423.000.308.89.000.00 Beginning Fund Balance 1,523,255 $ $ S $ Total Beginning Fund Balance Increase Decrease $ 1,523,255 $ $ $ C O E C N E a Ib L 2M C O L M V N O N t k W r� C O E C N E a r O Ib L 3M L O L O V N O N r C O E t V O -W Q 20 Packet Pg. 89 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Citywide rehabilitation of existing sewer pipe using Cured in Place Pipe technology. Substantial completion expected in January 2021. The carry forward will program funds in 2021 to pay for the remaining construction and close-out costs. Department: Public Works Fund Name: 423 SEWER / TREATMENT PLAN Division: Engineering Title: Cured In Place Pipe Sewer Rehab Phase 2 Preparer: Ryan Hague Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 423.000.75.535.80.41.67 Interfund Services $ 15,000 $ S $ S 423.000.75.594.35.65.30 Construction Projects 155,000 Total Expenditure Increase(Decrease) $ 170,000 $ S $ S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 423.000.308.00.000.00 Beginning Fund Balance $ 170,000 $ S $ $ Total Beginning Fund Balance Increase(Decrease) $ 170,000 $ S $ $ C O E C N E a r O m L 2M C O M t� N O N to r t k W C O E C N E a O m L 3M L O L �M♦ V r N O N C O E t t) O ++ Q 21 Packet Pg. 90 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Police patrol vehicle 525-POL was totaled on 5/29/2020 Its replacement vehicle was ordered, but we have not received it yet. Expected delivery date is late 2/l/2021. We need to transfer the money insurance paid to replace it from the 2020 B-fund allocation to the 2021 fund allocation. Department: Public Works Fund Name: 001 GENERAL Division: Fleet Maintenance Title: Police patrol vehicle 525-POL replacement funds Preparer: Mike Adams Budget Amendment Type Previously Approved Budget By Council 4th Quarter Budget Amendment Date of Discussion or Budget Approval? Dec 10 2020 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? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 511.100.77.594.48.64.00 Equipment $ 53,139 $ S $ S Total Expenditure Increase Decrease $ 53,139 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S— Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 511.100.308.00.000.00 Beginning Fund Balance $ 53,139 $ S $ S Total Beginning Fund Balance Increase Decrease $ 53,139 $ $ $ S C O E C N E r O m L 2M C O M t� N O N r t k W C O E C N E a O m L 3M L O L �M♦ V r N O N C O E t t) O ++ a 22 Packet Pg. 91 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Balance of invoices expected to be delivered to complete the Waterfront Redevelopment project Department: Parks, Recreation & Cultural Services Division: Parks Fund MULTIPLE FUNDS Title: Waterfront Redevelopment Name: Preparer: Shannon Burley Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 126.000.64.594.76.65.00 Waterfront Redevelopment $ 175,771 $ S $ S 332.000.64.594.76.65.00 Waterfront Redevelopment $ 165,326 Total Expenditure Increase Decrease $ 341,097 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 126.000.308.30.000.00 Beginning Fund Balance $ 175,771 $ S $ S 332.000.308.30.000.00 Waterfront Redevelopment $ 165,326 Total Beginning Fund Balance Increase(Decrease) $ 341,097 $ S $ S Q 23 Packet Pg. 92 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Funds anticipated to be spent in 2020 for design and permitting that are now expected to come in in 2021 and were not included in the 2021 budget. Department: Parks, Recreation & Cultural Services Fund Name: MULTIPLE FUNDS Division: Parks Title: Civic Center Playfield Preparer: Shannon Burley Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 125.000.64.594.76.65.00 Civic Center Pla field $ 2,396 $ S $ S 126.000.64.594.76.65.00 Civic Center Pla field $ 36,573 332.000.64.594.76.65.00 Civic Center Pla field $ 26,786 Total Expenditure Increase Decrease $ 65,755 $ S $ S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 125.000.308.30.000.00 Beginning Fund Balance $ 2,396 $ S $ S 126.000.308.30.000.00 Beginning Fund Balance $ 36,573 332.000.308.30.000.00 Beginning Fund Balance $ 26,786 Total Beginning Fund Balance Increase(Decrease) $ 65,755 $ S $ S C O E C N E r O Cal L 2M C O M t� N O N to r t k W r� C O E C N E a m L 2M C O L �M♦ V r N O N C O E t V O ++ Q 24 Packet Pg. 93 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: The project reached substantial completion in 2020. The carryfoward will pay for the remaining work that will be completed by the bonding company and close-out of the project. Department: Public Works Fund Name: MULTIPLE FUNDS Division: Engineering Title: 84th Ave. Overlay from 220th St. SW 212th St. SW Preparer: Bertrand Hauss Budget Amendment Type Previously Approved Budget By Council Previous Year Carryforward Amendment Date of Discussion or Budget Approval? How is this amendment funded? Partially Funded What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? 1C.pital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 112.000.68.542.33.41.67 Interfund Services Roadway $ 5,200 $ S $ $ 112.000.68.542.30.48.00 Repair & Maint Roadway 15,000 126.000.68.542.30.41.67 hiterfunds Services 3,800 126.000.68.542.30.48.00 Repair & Maint Overlays $ 40,000 Total Expenditure Increase Decrease $ 64,000 S $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 112.000.333.20.205.20 84th Ave STPUL-2509 001 $ 20,200 $ S $ S Total Revenue Increase Decrease $ 20,200 $ S $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 126.000.308.30.000.00 Beginning Fund Balance 43,800 Total Beginning Fund Balance Increase(Decrease) $ 43,800 $ S S S C O E C N E r O m L 2M C O M t� N O N to r t k W r� C O E C N E a 00 L 3M L O L �M♦ V r N O N C O E t V O ++ Q 25 Packet Pg. 94 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: This carry forward will program the unspent funds from the 2020 pavement preservation program to the 2021 program. Department: Public Works Division: Engineering Fund MULTIPLE FUNDS Title: 2020 Pavement Preservation Program Name: Preparer: Ryan Hague Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Capita Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 112.000.68.542.33.41.67 Interfund Services Roadway $ 4,635 $ S $ $ 112.000.68.542.30.41.00 Professional Services Roadway 11,634 125.000.68.542.30.41.67 Interfund Services Roadway 9,029 125.000.68.542.30.41.00 Professional Services Roadway 2,597 125.000.68.595.33.65.00 Construction Projects Roadway 3,540 126.000.68.542.30.41.67 Interfund Services Roadway 6,608 126.000.68.542.30.41.00 Professional Services Roadway 1,826 126.000.68.595.33.65.00 Construction Projects Roadway 1,442 Total Expenditure Increase Decrease $ 41,311 1 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 S $ $ $ S Total Revenue Increase(Decrease) S $ $ $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 112.000.308.30.000.00 Beginning Fund Balance $ 16,269 $ S $ S 125.000.308.30.000.00 Beginning Fund Balance 15,166 126.000.308.30.000.00 Beginning Fund Balance 9,876 Total Beginning Fund Balance Increase(Decrease) $ 41,311 $ S $ S Q 26 Packet Pg. 95 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Construction funds carryforward for project closeout and asbuilt drafting. Project is substantially complete as of fall 2020. Department: Public Works Division: Engineering Fund MULTIPLE FUNDS Title: JDayton Utility Replacement Project (E5JB/c482) Name: Preparer: Gregory Malowicki Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.74.534.34.41.67 Interfund Services $ 7,000 $ $ $ S 421.000.74.594.34.41.00 Capital Professional Services 5,000 422.000.72.531.31.41.67 Interfund Services $ 7,000 422.000.72.594.31.41.00 Capital Professional Services 5,000 423.000.75.535.80.41.67 Interfund Services $ 7,000 423.000.75.594.35.41.00 Capital Professional Services 5,000 Total Expenditure Increase Decrease $ 36,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 Total Revenue Increase Decrease $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.308.00.000.00 Beginning Fund Balance $ 12,000 $ S $ $ 422.000.308.00.000.00 Beginning Fund Balance $ 12,000 423.000.308.00.000.00 Beginning Fund Balance $ 12,000 Total Beginning Fund Balance Increase Decrease $ 36,000 $ S $ $ Q 27 Packet Pg. 96 2.4.a Carryforward Budget Amendment for Council to Consider (February 2021) Budget Amendment for: Carryforward Item Description: Remaining construction work is suspended until spring due to winter weather. Project is expected to be substantially complete spring 2021. Department: Public Works Fund Name: MULTIPLE FUNDS Division: Engineering Title: 12019 Sewer Replacement (Phase 7) E8GA/c516 Preparer: Gregory Malowicki Budget Amendment Type Previously Approved Budget By Council 2020 Adopted Budget Date of Discussion or Budget Approval? Dec 10 2019 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? lCapital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 423.000.75.535.80.41.67 Interfund Services $ 20,000 $ $ $ S 423.000.75.594.35.41.00 Capital Professional Services 15,000 423.000.75.594.35.65.30 Construction Projects $ 50,000 421.000.74.534.34.41.67 Interfund Services 1,000 421.000.74.594.34.41.00 Capital Professional Services $ 1,000 421.000.74.594.34.65.10 Construction 5,000 Total Expenditure Increase Decrease $ 92,000 $ $ $ S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ $ $ S Total Revenue Increase Decrease $ $ $ $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 423.000.308.00.000.00 Beginning Fund Balance $85,000 $ $ $ S 421.000.308.00.000.00 Beginning Fund Balance $7,000 Total Beginning Fund Balance Increase Decrease $ 92,000 $ $ $ S C O E C N E r O m L 2M C O M V N O N to r t k W r� C O E C N E a Cal L 2M C O L �M♦ V r N O N C O E t t) O Q 28 Packet Pg. 97 2.4.b ORDINANCE NO. XXXX AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4211 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 2021 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. 4211 adopting the final budget for the fiscal year 2021 is hereby amended to reflect the changes shown in Exhibits A, B, C, and D adopted herein by reference. 1 Packet Pg. 98 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: IM JEFF TARADAY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. APPROVED: MAYOR, MIKE NELSON 2 Packet Pg. 99 2.4.b SUMMARY OF ORDINANCE NO. of the City of Edmonds, Washington On the day of , 2021, the City Council of the City of Edmonds, passed Ordinance No. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4211 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 12021. CITY CLERK, SCOTT PASSEY 3 Packet Pg. 100 2.4.b EXHIBIT "A": Budget Amendment Summary (February 2021) FUND NO. FUND DESCRIPTION 2021 BEGINNING FUND BALANCE REVENUE EXPENDITURES 2021 ENDING FUND BALANCE 001 GENERAL FUND 13,057,530 42,450,777 45,475,570 10,032,737 009 LEOFF-MEDICAL INS. RESERVE 459,105 300,000 467,140 291,965 012 CONTINGENCY RESERVE FUND 1,825,890 2,620 - 1,828,510 014 HISTORIC PRESERVATION GIFT FUND 11,517 5,010 5,900 10,627 016 BUILDING MAINTENANCE 210,222 - 210,222 - 017 MARSH RESTORATION & PRESERVATION FUND 864,490 - 864,490 018 EDMONDS HOMELESSNESS RESPONSE FUND 123,581 123,581 - 019 EDMONDS OPIOID RESPONSE FUND 28,445 - 28,445 - 104 DRUG ENFORCEMENT FUND 159,431 165,370 45,800 279,001 111 STREET FUND 941,253 1,722,360 2,172,530 491,083 112 COMBINED STREET CONST/I MP ROVE 2,189,972 3,068,385 2,818,297 2,440,060 117 MUNICIPAL ARTS ACQUIS. FUND 599,272 165,060 236,880 527,452 118 MEMORIAL STREET TREE 20,534 270 - 20,804 120 HOTEL/MOTEL TAX REVENUE FUND 88,392 71,460 87,150 72,702 121 EMPLOYEE PARKING PERMIT FUND 87,233 25,240 26,880 85,593 122 YOUTH SCHOLARSHIP FUND 14,041 1,390 3,000 12,431 123 TOURISM PROMOTIONAL FUND/ARTS 75,353 24,000 29,900 69,453 125 PARK ACQ/IMPROVEMENT 2,000,717 1,282,050 1,476,298 1,806,469 126 SPECIAL CAPITAL FUND 1,946,015 1,285,240 2,053,911 1,177,344 127 GIFTS CATALOG FUND 316,106 103,930 100,900 319,136 130 CEMETERY MAINTENANCE/IMPROV 213,707 179,800 200,998 192,509 136 PARKSTRUST FUND 169,460 2,200 50,000 121,660 137 CEMETERY MAINTENANCE TRUSTFD 1,107,524 29,220 25,000 1,111,744 138 SISTER CITY COMMISSION 10,408 10,120 11,900 8,628 140 BUSINESS IMPROVEMENT DISTRICT FUND 10,346 79,239 76,340 13,245 141 AFFORDABLE & SUPPORTIVE HOUSING FUND 65,112 65,000 - 130,112 142 EDMONDS CARES FUND - - - 211 LID FUND CONTROL - - - 231 2012 LTGO DEBT SERVICE FUND - 759,710 759,700 10 332 PARKS CONSTRUCTION 6,046,540 1,392,520 5,552,490 1,886,570 421 WATER 22,026,766 10,299,357 10,714,650 21,611,473 422 STORM 9,914,166 6,265,225 7,254,090 8,925,301 423 SEWER/TREATMENT PLANT 55,138,987 31,130,450 40,423,884 45,845,553 424 BOND RESERVE FUND 843,931 1,985,870 1,985,870 843,931 511 EQUIPMENT RENTAL FUND 8,712,017 1,331,100 1,345,954 8,697,163 512 Technology Rental Fund 734,287 1,204,880 1,251,409 687,758 617 FIREMEN'S PENSION FUND 137,533 67,270 96,167 108,636 Totals 130,149,883 105,475,123 125,110,856 110,514,150 a Packet Pg. 101 EXHIBIT "B": Budget Amendments by Revenue (February 2021) 2.4.b FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4211 1/1/2021 Proposed Amendment Ord. # 2/2021 2021 Amended Revenue Budget 001 General Fund $ 42,450,777 $ $ 42,450,777 009 Leoff-Medical Ins. Reserve 300,000 300,000 012 Contingency Reserve Fund 2,620 2,620 014 Historic Preservation Gift Fund 5,010 5,010 017 Marsh Restoration & Preservation Fund - - 018 Edmonds Homelessness Response Fund 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 165,370 165,370 111 Street Fund 1,722,360 1,722,360 112 Combined Street Const/Improve 3,048,185 20,200 3,068,385 117 Municipal Arts Acquis. Fund 165,060 - 165,060 118 Memorial Street Tree 270 270 120 Hotel/Motel Tax Revenue Fund 71,460 71,460 121 Employee Parking Permit Fund 25,240 25,240 122 Youth Scholarship Fund 1,390 1,390 123 Tourism Promotional Fund/Arts 24,000 24,000 125 ParkAcq/Improvement 1,282,050 1,282,050 126 Special Capital Fund 1,285,240 1,285,240 127 Gifts Catalog Fund 103,930 103,930 130 Cemetery Maintenance/Improv 179,800 179,800 136 Parks Trust Fund 2,200 2,200 137 Cemetery Maintenance Trust Fd 29,220 29,220 138 Sister City Commission 10,120 10,120 140 Business Improvement District Fund 79,239 79,239 141 Affordable and Supportive Housing Fund 65,000 65,000 142 Edmonds CARES Fund - - 211 Lid Fund Control - - 231 2012 LTGO Debt Service fund 759,710 759,710 332 Parks Construction 1,392,520 1,392,520 421 Water 10,299,357 - 10,299,357 422 Storm 6,012,300 252,925 6,265,225 423 Sewer/Treatment Plant 28,131,150 2,999,300 31,130,450 424 Bond Reserve Fund 1,985,870 - 1,985,870 511 Equipment Rental Fund 1,331,100 1,331,100 512 Technology Rental Fund 1,204,880 1,204,880 617 Firemen'S Pension Fund 67,270 67,270 Totals $ 102,202,698 $ 3,272,425 $ 105,475,123 a Packet Pg. 102 EXHIBIT "C": Budget Amendments by Expenditure (February 2021) 2.4.b FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4211 1/1/2021 Proposed Amendment Ord. # 2/2021 2021 Amended Expenditure Budget 001 General Fund $ 45,179,468 $ 296,102 $ 45,475,570 009 Leoff-Medical Ins. Reserve 467,140 - 467,140 012 Contingency Reserve Fund - - - 014 Historic Preservation Gift Fund 5,900 - 5,900 016 Building Maintenance Fund 210,222 - 210,222 017 Marsh Restoration & Preservation Fund - - - 018 Edmonds Homelessness Response Fund 123,581 - 123,581 019 Edmonds Opioid Response Fund 28,445 - 28,445 104 Drug Enforcement Fund 45,800 - 45,800 111 Street Fund 2,172,530 - 2,172,530 112 Combined Street Const/Improve 2,781,828 36,469 2,818,297 117 Municipal Arts Acquis. Fund 236,880 - 236,880 118 Memorial Street Tree - - - 120 Hotel/Motel Tax Revenue Fund 87,150 - 87,150 121 Employee Parking Permit Fund 26,880 - 26,880 122 Youth Scholarship Fund 3,000 - 3,000 123 Tourism Promotional Fund/Arts 29,900 - 29,900 125 ParkAcq/Improvement 1,428,736 47,562 1,476,298 126 Special Capital Fund 1,761,841 292,070 2,053,911 127 Gifts Catalog Fund 100,900 - 100,900 130 Cemetery Maintenance/Improv 200,998 - 200,998 136 Parks Trust Fund 50,000 - 50,000 137 Cemetery Maintenance Trust Fd 25,000 - 25,000 138 Sister City Commission 11,900 - 11,900 140 Business Improvement District Fund 76,340 - 76,340 141 Affordable and Supportive Housing Fund - - - 142 Edmonds CARES Fund - 211 Lid Fund Control - - - 231 2012LTGO Debt Service Fund 759,700 - 759,700 332 Parks Construction 5,360,378 192,112 5,552,490 421 Water 10,578,596 136,054 10,714,650 422 Storm 6,847,783 406,307 7,254,090 423 Sewer/Treatment Plant 35,634,329 4,789,555 40,423,884 424 Bond Reserve Fund 1,985,870 - 1,985,870 511 Equipment Rental Fund 1,292,815 53,139 1,345,954 512 Technology Rental Fund 1,251,409 - 1,251,409 617 Firemen'SPension Fund 96,167 - 96,167 Totals $118,861,486 1 $ 6,249,370 $ 125,110,856 .r a Packet Pg. 103 EXHIBIT "D": Budget Amendment Summary (February 2021) 2.4.b Fund Number Proposed Amendment Changein Beginning Fund Balance Proposed Amendment Change in Revenue Proposed Amendment Change in Expense Proposed Amendment Change in Ending Fund Balance 001 296,102 296,102 112 16,269 20,200 36,469 125 47,562 47,562 126 292,070 292,070 332 192,112 192,112 421 136,054 136,054 422 153,382 252,925 406,307 423 1,790,255 2,999,300 4,789,555 511 1 53,139 1 1 53,139 Total Change 1 2,976,945 1 3,272,425 1 6,249,370 a Packet Pg. 104