Loading...
2021-03-09 City Council - Full FIN Agenda-28101 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 MARCH 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. Resolution adopting Electronic Signatures Policy and Budget Authorization (10 min) 2. Job Order Contracting (10 min) 3. January 2021 Monthly Financial Report (10 min) 4. PFD Financial Presentation (20 min) ADJOURN COUNCIL AGENDA ITEMS Edmonds City Council Agenda March 9, 2021 Page 1 2.1 City Council Agenda Item Meeting Date: 03/9/2021 Resolution adopting Electronic Signatures Policy and Budget Authorization Staff Lead: Scott Passey Department: City Clerk's Office Preparer: Scott Passey Background/History State and local agencies are authorized to use and accept electronic signatures, making them a good option for those agencies that can invest in the technology needed to use them. Beginning in 2016, local agencies were specifically authorized to use electronic signatures by Chapter 19.360 RCW, and effective June 11, 2020, Chapter 19.360 RCW was repealed and replaced by the Uniform Electronic Transactions Act (UETA). UETA provides for essentially the same authority as Chapter 19.360 RCW with respect to a local agency's use of electronic signatures: Unless state or federal law requires a wet signature, an electronic signature can be used and must be given the same legal effect as a wet signature. Therefore, typical local government records requiring a signature - such as contracts, meeting minutes, and claim vouchers - can utilize electronic signatures in lieu of wet signatures. Given the changes to the way public agencies must do business in the era of a worldwide pandemic, the use of electronic signature technology has not only become commonplace, but is quickly becoming the practical standard. To use electronic signatures, the agency must first adopt a local policy. Staff Recommendation Review the proposed policy and budget estimate and adopt on a future council agenda. Narrative The proposed policy authorizes electronic signature platforms, such as DocuSign, to be utilized in applying electronic signatures to City documents. DocuSign appears to be the frontrunner in electronic document signature technology, occupying approximately 70% market share among local government agencies. The estimated cost of an annual contract for this service is approximately $3,200-$5,200. Staff estimates that the Business Pro Package should suit the city's needs, which is on the lower range of the cost estimate. Attachments: DRAFT Electronic Signature and Remote Notarization Policy 2.18.2021 DRAFT Resolution to Adopt Electronic Signature and Remote Notarization Policy 2.18.2021 DocuSign Package Comparison DRAFT - City of Edmonds WA - Public Works Dept_DocuSign Order Form FX2_2021-02-25 DRAFT - City of Edmonds WA - Public Works Dept_DocuSign Order Form FX2_2021-02-25 (1) Packet Pg. 2 2.1.a City of Edmonds Electronic Signature and Remote Notarization Policy March , 2021 Resolution # XXXX Packet Pg. 3 2.1.a City of Edmonds Electronic Signature and Remote Notarization Policy Policy Statement The Washington State Uniform Electronic Transactions Act, Chapter 1.80 RCW, authorizes the electronic execution and remote notarization of City documents. Streamlining processes that require wet signatures and replacing them with electronic signatures, and remote notarizations when necessary, is consistent with the intent of this law to promote electronic transactions and remove barriers that might prevent the use of electronic transactions by governmental entities. By transitioning to a policy of executing documents electronically/remotely, the City will reduce its reliance on paper -based transactions and will further improve information security and sharing. Further, such transition will facilitate more efficient approval of and access to documents and reduce both costs and environmental impact. Reason for Policy The intent of this policy is to establish procedures for the acceptance, submission, and retention of electronic signatures and for the remote notarization of documents, as necessary, in compliance with State law. The guidelines set forth in this policy apply to the use of any electronic signature provider, such as DocuSign; any video conferencing provider, such as Zoom; and any other similar platform used to obtain such services. Who Must Comply This policy is applicable to all City departments, employees, volunteers, and officials References Chapter 1.80 RCW Uniform Electronic Transactions Act 15 U.S.C. Ch. 96 Electronic Signatures in Global and National Commerce Act WA Senate Bill 5641 Notary Laws RCW 42.45.280 Electronic Records Notary Public Proclamation 20-27 Electronic Notary Proclamation Amending Proclamation 20-05 (as amended or extended) Packet Pg. 4 2.1.a Definitions Electronic signature: An electronic sound, symbol, or process attached to or logically associated with a record and executed or adopted by a person with the intent to sign the record. Notary: An individual with the authorization to execute specific legal formalities, such as witnessing signatures on documents. Record: Information that is inscribed on a tangible medium or that is stored in an electronic or other medium and is retrievable in perceivable form. Remote notarization: A form of notarization where the signer appears before the notary at the time of notarization using audio-visual technology, as opposed to being in the room physically. Wet signature: A signature created in person when the signer physically marks a document. All other definitions set forth in RCW 1.80.010 shall also apply to this policy. Responsibilities It is the responsibility of all City of Edmonds employees, elected officials, and volunteers to ensure that they adhere to the electronic signature and remote notary procedures outlined in this policy to provide reasonable assurance of authenticity and accuracy when using electronic documents. Transmission and Storage of Electronic Transactions and Signatures Electronically signed electronic records shall be stored in such a way as to ensure their preservation, disposition, integrity, security, confidentiality, and auditability. Electronic records shall be transmitted only via secure services including, but not limited to, email, drop box, and cloud -based electronic signature platforms. Packet Pg. 5 2.1.a ELECTRONIC SIGNATURE POLICY 1. The City of Edmonds recognizes electronic signatures as legally binding and equivalent in nature to wet signatures. 2. The City of Edmonds authorizes electronic signature platforms, such as DocuSign, to be utilized in applying electronic signatures to City documents. 3. Any electronic signature platform used by the City of Edmonds is authorized to apply electronic signatures to any contracts or other documents to which the City of Edmonds is a party, including but not limited to City Council, Board or Commission actions or meeting minutes, Resolutions and Ordinances adopted or passed by the City Council, and claim vouchers approved by the City Council. 4. Electronic signatures may be used on City records requiring execution by a third party. 5. Electronic signatures may be applied using other electronic signature tools, such as Adobe, for documents such as internal city documents. 6. Electronic signatures may not be applied using another employee's name. Any employee or official applying an electronic signature shall use his or her own name. 7. If an electronic or digital signature is used for interstate transactions or for documents required by the US Federal government, the signature shall comply with the requirements of the Electronic Signatures in Global and National Commerce Act. 8. This policy does not impact the use or legitimacy of wet signatures. 9. A City document that is required by law to be signed in non -electronic media may not be electronically signed. ELECTRONIC SIGNATURE PROCEDURES 1. A limited number of individuals are permitted to route documents for signatures between the City and outside organizations. The City Clerk determines who may use this tool for signatures that bind the City. The City Clerk will develop procedures for using electronic signature platforms, such as DocuSign; for establishing an approved list of individuals who may route documents for official signatures; and for the retention of electronically signed/notarized documents. The City Clerk will work with City Departments to support electronic signatures with software programs, such as Adobe, for internal signature processes. Packet Pg. 6 2.1.a 2. Process. a. If you receive a document from an electronic signature platform, such as DocuSign, that requires an electronic signature, select the "review document" or equivalent option. b. Once the document opens, review the contents of the document fully. When you are satisfied that you have the authority to sign the document, and that you agree to comply fully with the obligations of the document, you may proceed to take the steps required by the platform to apply your electronic signature to the document. c. Once you have applied your electronic signature to a document, take the steps required by the platform to return the signed document to the original sender. d. Alternatively, you may decline to sign a document, or just not proceed. If you would like assistance, you may contact the City Clerk or the City Attorney. REMOTE NOTARIZATION POLICY 1. The City of Edmonds recognizes remote notarization as legally binding and equivalent in nature to electronic notarization and physical notarization. 2. The City authorizes the use of remote notarization platforms, such as DocuSign, in conjunction with audio-visual platforms, such as Zoom, to notarize City documents. 3. Any remote notarization platform and any audio-visual platform used by the City is authorized to remotely notarize any contracts to which the City of Edmonds is a party. 4. Per RCW 42.45.280, a remotely located individual must personally appear for the notarial act using communication technology and must be identified by the notary public using at least two forms of valid identification. 5. A notary public must have an electronic notary endorsement and remote online notary (RON) authority prior to performing remote notarial acts. 6. A notary public must retain an audio-visual recording of the notarial act as outlined in RCW 42.45.280. 7. Per WAC 308-30-220, the maximum fee that a notary may charge for witnessing or attesting to a signature, taking an acknowledgement or a verification upon oath or affirmation, certifying or attesting a copy, administering an oath or affirmation or certifying that an event has occurred or an act has been performed is $10. 8. This policy does not impact the use or legitimacy of electronic or physical notarization. Packet Pg. 7 2.1.a REMOTE NOTARIZATION PROCEDURES Notary to Obtain Authorization. a. Apply for a remote online notary (RON) authority by sending an email to the Washington Department of Licensing notary group at notaries(a-dol.wa.gov. b. In the subject line, place "Remote Online Notary Endorsement Application" and in the body of the email, include your name, your notary license number, and the date that you applied for the electronic notary endorsement. 2. Notarization Process. a. The online notarization process begins when a sender prepares a document to send to the signer and the notary. b. After receiving the document, the notary schedules a remote audio-visual conferencing session with the signer. c. When the audio-visual conferencing session begins, the notary will start recording the session. d. Once the recording has begun, the notary will confirm the identity of the signer. e. After the signer's identity has been verified, the notary will share their screen to begin the signing portion of the process. The notary will indicate through the platform that they are witnessing a signature. g. The notary will then grant the signer control of the session to proceed with affixing their signature to the document. h. Once the signer has finished signing the document, they will notify the notary that they have signed, and the notary will then take back control of the session. The notary then stops sharing the audio-visual conferencing session and regains control of the session. The notary then completes the platform's processes to confirm the signer's identity. k. The notary then applies their electronic notarial stamp to the appropriate location of the document. If needed, the notary can also attach a notarial certificate. m. The notary then undertakes the platform's required processes to complete the remote notarization process. n. Once the remote notarization process has been completed, the notary will retain the recording and any relevant documentation in a secure area for the allotted length of time listed on the records retention schedule. Packet Pg. 8 2.1.b RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, AUTHORIZING THE USE OF ELECTRONIC SIGNATURES AND REMOTE NOTARIZATION IN CONDUCTING CITY BUSINESS; AND ADOPTING AN ELECTRONIC SIGNATURE AND REMOTE NOTARIZATION POLICY. WHEREAS, in Chapter 19.360 RCW, the Washington State Legislature, to the extent not already authorized by federal or state law, authorized municipalities in Washington to utilize electronic signatures in the conduct of governmental affairs and transactions; and WHEREAS, in March 2020, through Engrossed Substitute Senate Bill 6028, now codified at Chapter 1.80 RCW, the Washington State Legislature repealed Chapter 19.360 RCW and adopted the Uniform Electronic Transactions Act, effective June 11, 2020, which is intended to facilitate the use of electronic transactions consistent with other applicable law, and to bring consistency to reasonable practices concerning electronic transactions; and WHEREAS, RCW 1.80.010 defines "electronic signature" as "an electronic sound, symbol, or process attached to or logically associated with a record and executed or adopted by a person with the intent to sign the record"; and WHEREAS, RCW 1.80.010 defines "electronic record" as "a record created, generated, sent, communicated, received, or stored by electronic means"; and WHEREAS, RCW 1.80.060 provides that "[a] record or signature may not be denied legal effect or enforceability solely because it is in electronic form; a contract may not be denied legal effect or enforceability solely because an electronic record was used in its formation; if a law requires a record to be in writing, an electronic record satisfies the law; and if a law requires a signature, an electronic signature satisfies the law"; and WHEREAS, RCW 1.80.100 provides that "[i]f a law requires a signature or record to be notarized, acknowledged, verified, or made under oath, the requirement is satisfied if the electronic signature of the person authorized to perform those acts, together with all other information required to be included by other applicable law, is attached to or logically associated with the signature or record"; and WHEREAS, electronic signatures and remote notarization provide a convenient, time -saving, and secure way of signing documents, and the use of such procedures, where appropriate and permitted by law, will lessen administrative demands and improve efficiency; and WHEREAS, the value of electronic signatures and the need for remote notarization has been proven during the COVID-19 pandemic, when City business has been and continues to be largely conducted via remote technologies due to the Governor's Stay Home Stay Safe Proclamation and subsequent orders; and Packet Pg. 9 2.1.b WHEREAS, for these reasons, the City desires to leverage technology solutions which are in compliance with the Uniform Electronic Transactions Act to apply notarized electronic signatures to legally enforceable electronic records as allowed by Chapter 1.80 RCW; and WHEREAS, the method and process for electronic submissions and the use of electronic signatures must be established by ordinance, resolution, policy or rule, and the City wishes to establish a policy for using electronic signatures and remote notarization by way of a resolution adopted by Council; and WHEREAS, the City Council desires to adopt a policy to provide reasonable assurance of the integrity, authenticity, and non -repudiation of electronic records when electronic signatures and submissions are used and accepted and to formally authorize the use of electronic signatures and remote notarization in conducting City business; NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, HEREBY RESOLVES AS FOLLOWS: 1. Recitals. The foregoing recitals are incorporated and fully made a part of this Resolution. 2. Public Interest. The City Council finds it to be in the public interest to allow the use of electronic signatures and remote notarization for City business to the fullest extent allowed by law. 3. Adoption ofPolicy. City Council hereby adopts the Electronic Signature and Remote Notarization Policy attached hereto as Exhibit A. 4. Ratification of Prior Signatures. The use and acceptance of electronic signatures by the City prior to the effective date of this Resolution that is consistent with its terms is hereby ratified and confirmed. 5. Severability. If any one or more section, subsections, or sentences of this Resolution are held to be unconstitutional or invalid, such decision shall not affect the validity of the remaining portion of this Resolution and the same shall remain in full force and effect. 6. Effective Date. This Resolution and policy shall take effect immediately. RESOLVED this day of APPROVED: 2021. MAYOR, MIKE NELSON Packet Pg. 10 2.1.b ATTEST/AUTHENTICATED: CITY CLERK, SCOTT PASSEY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: RESOLUTION NO. Packet Pg. 11 2.1.c DocuSign Package Comparison Features Business Pro Enterprise Pro Send documents for eSignature Basic fields Mobile app Reusable templates Real-time audit trail Multiple languages Reminders and notifications Personalized branding Comments Collect Payments Advanced fields Signer attachments Bulk Send PowerForms Collaborative Fields In -person Signatures Advanced Authentication Single Sign On Advanced Workflows eNotary Document Visibility Org Admin Connectors Included Web Application Administrator Course Business Process Automation Standard Edition included Advanced Fields: formulas, custom fields, data fields, conditional logic, data validation Form Fields: radio buttons, drop downs, notes Bulk Send: create and send out up to 1,000 unique envelopes for signature, all at once PowerForms: enable self-service signing Payments: collect payment during the signing process Signer Attachments: upload attachment(s) during signing process DocuSign Connect: set up custom integrations or integrate with 300+ pre -built partner apps PDF Conversion: converts PDF fields to signer fields Approve/Decline Buttons In -Person Signing Business Transformation Business Pro Edition included Access Management wl SSO: enforce unique security policies using single sign -on Organization Management: centralized administrative tools to simplify enterprise management Advanced Workflows: signing groups, supplemental documents, document visibility, draft watermark, conditional routing, and more Advanced Compliance: read-only fields, masked fields, locked templates QA Testing Environment: testing environment enabling stable integration at launch Expanded Branding: multiple brands (up to 5) Document Retention Policies: automate your policies to ensure compliance SMS Authentication, eNotary & eWitness: authenticate signing DocuSign Packet Pg. 12 2.1.d DocuSign, Inc. Offer Valid Through: Mar 15, DocuSign, 221 Main Street, Suite 1000 2021 San Francisco, CA 94105 Prepared By: Weston Miller Quote Number: Q-00561883 SUBJECT TO APPROVAL ORDER FORM Address Information Bill To: City of Edmonds 121 5th Ave N, Edmonds, WA, 98020 United States Billing Contact Name: Scott Passey Billing Email Address: scott.passey@edmondswa.gov Billing Phone: +1.425.775.2525 Order Details Order Start Date: Mar 15, 2021 Order End Date: Mar 14, 2022 Billing Frequency: Annual Products Ship To: City of Edmonds 121 5th Ave N, Edmonds, WA, 98020 United States ,Shipping Contact Name: ,Scott Passey 'Shipping Email Address: scott.passey@edmondswa.gov Shipping Phone: +1.425.775.2525 Payment Method: Check Payment Terms: Net 30 Currency: USD Product Name Start Date End.. eSignature Enterprise Pro Edition - Envelope Subs. Mar 15, 2021 Mar 14, 2022 500 $3,900.00 Enterprise Premier Support Mar 15, 2021 Mar 14, 2022 1 $858.00 Adoption Consulting Lite Mar 15, 2021 Mar 14, 2022 1 $400.00 Single Sign -On Implementation Services Mar 15, 2021 Jun 13, 2021 1 $0.00 Product Details eSignature Envelope Allowance: 500 Grand Total: $5,158.00 Packet Pg. 13 2.1.d Overage/Usage Fees eSignature Enterprise Pro Edition - Envelope Subs. (Per Transaction): $8.80 Order Special Terms Terms & Conditions This Order Form is governed by the terms Master Services Agreement available online at: https://www.docusign.com/companv/terms-and-conditions/msa and the applicable Service Schedule(s) and Attachments for the DocuSign Services described herein available online at https://www.docusign.com/companv/terms-and-conditions/msa-service-schedules. Adoption Consulting Lite will expire if not used within 90 days of the product start date. The Single Sign -On Implementation Services indicated in the Products table above will be available to Customer during the longer of 90 days from the Order Start Date or the End Date stated in the Product table. The availability of the SSO services shall only be valid for such specified time period; no refunds will be provided for services not used by Customer during the specified time period. Billing Information Prices shown above do not include any state and local taxes that may apply. Any such taxes are the responsibility of the Customer and will appear on the final Invoice. Is the contracting entity exempt from sales tax? Please select Yes or No: If yes, please send the required tax exemption documents immediately to taxexempt(a)docusign.com. Invoices for this order will be emailed automatically from invoicing(a)_docusign.com. Please make sure this email is on an approved setting or safe senders list so notifications do not go to a junk folder or caught in a spam filter. Purchase Order Information Page 2 of 3 Packet Pg. 14 2.1.d Is a Purchase Order (PO) required for the purchase or payment of the products on this Order Form? Please select Yes or No: If yes, please complete the following: PO Number: PO Amount: $ Page 3 of 3 Packet Pg. 15 2.1.e DocuSign, Inc. Offer Valid Through: Mar 15, DocuSign, 221 Main Street, Suite 1000 2021 San Francisco, CA 94105 Prepared By: Weston Miller Quote Number: Q-00561883 SUBJECT TO APPROVAL ORDER FORM Address Information Bill To: City of Edmonds 121 5th Ave N, Edmonds, WA, 98020 United States Billing Contact Name: Scott Passey Billing Email Address: scott.passey@edmondswa.gov Billing Phone: +1.425.775.2525 Order Details Order Start Date: Mar 15, 2021 Order End Date: Mar 14, 2022 Billing Frequency: Annual Products Ship To: City of Edmonds 121 5th Ave N, Edmonds, WA, 98020 United States ,Shipping Contact Name: ,Scott Passey 'Shipping Email Address: scott.passey@edmondswa.gov Shipping Phone: +1.425.775.2525 Payment Method: Check Payment Terms: Net 30 Currency: USD Product Name Start Date End.. eSignature Business Pro Edition - Envelope Subs. Mar 15, 2021 Mar 14, 2022 500 $2,400.00 Premier Support Mar 15, 2021 Mar 14, 2022 1 $360.00 Adoption Consulting Lite Mar 15, 2021 Mar 14, 2022 1 $400.00 Product Details eSignature Envelope Allowance: 500 Grand Total: $3,160.00 Packet Pg. 16 2.1.e Overage/Usage Fees eSignature Business Pro Edition - Envelope Subs. (Per Transaction): $5.80 Order Special Terms Terms & Conditions This Order Form is governed by the terms Master Services Agreement available online at: https://www.docusign.com/company/terms-and-conditions/msa and the applicable Service Schedule(s) and Attachments for the DocuSign Services described herein available online at https://www.docusign.com/company/terms-and-conditions/msa-service-schedules. Adoption Consulting Lite will expire if not used within 90 days of the product start date. Billing Information Prices shown above do not include any state and local taxes that may apply. Any such taxes are the responsibility of the Customer and will appear on the final Invoice. Is the contracting entity exempt from sales tax? Please select Yes or No: If yes, please send the required tax exemption documents immediately to taxexempt(a)docusign.com. Invoices for this order will be emailed automatically from invoicinpCa_)docusign.com. Please make sure this email is on an approved setting or safe senders list so notifications do not go to a junk folder or caught in a spam filter. Purchase Order Information Is a Purchase Order (PO) required for the purchase or payment of the products on this Order Form? Please select Yes or No: If yes, please complete the following: PO Number: Page 2 of 3 Packet Pg. 17 2.1.e PO Amount: $ Page 3 of 3 Packet Pg. 18 2.2 City Council Agenda Item Meeting Date: 03/9/2021 Job Order Contracting Staff Lead: {Type Name of Staff Lead} Department: Public Works & Utilities Preparer: Royce Napolitino Background/History During the 2019 Legislative Sessions, RCW 39.10.420-460 was amended to allow all public agencies to use Job Order Contracting (JOC) for public works projects when a determination is made that the use of job order contracts will benefit the public. The COE has determined that the use of Job Order Contracting will benefit the public by providing an effective means of reducing total lead-time and cost for the construction of public works projects for repair and renovation required at public facilities through the use of unit price books and work orders by eliminating time-consuming, costly aspects of the traditional public works process, which require separate contracting actions for each small project. Staff Recommendation Proceed with advertising for proposals from Job Order Contracting firms to create and administer the City's program. Narrative The objectives of the City's JOC program are to rapidly engage contractors in the performance of small to medium sized public works projects; to reduce construction, design, and planning costs; and to develop relationships and contracts with contractors to more quickly and efficiently respond to emergency situations. The JOC program is anticipated to be utilized in many different departments/divisions including Public Works Engineering & Construction, Road Maintenance, Wastewater, Surface Water, Facilities, Parks, Recreation and Cultural Services and other public works areas/projects Attachments: Job Order Contracting RFP Draft (with SEC edits) (redlined) 2.23.2021 Job Order Contracting RFP Draft (with SEC edits) (clean) 2.23.2021 Packet Pg. 19 2.2.a City of Edmonds Request for Proposal (RFP) ef-Job Order Contractine Consultine Services RFP-# Due Date: / /2021 No Later than 4 P.M. Pacific Standard Time Resubmit to City of Edmonds City Clerk's Office: 121 SO Avenue North, Edmonds WA 98020 1_ INTRnnHrTInN The City of Edmonds (COE), Washington is soliciting proposals from qualified consultants to develop, implement, and support a Job Order Contracting (JOC) program for the City as provided for in Chapter 39.10 RCW Alternative Public Works Contracting Procedures. 2. PRIMARY OBJECTIVES The objectives of the City's JOC program are to rapidly engage contractors in the performance of small to medium sized public works projects; to reduce construction, design, and planning costs; and to develop relationships and contracts with contractors to more quickly and efficiently respond to emergency situations. 3.BACKGROUND During the 2019 Legislative Sessions, RCW 39.10.410-.420 — .460 was amended to allow all public agencies to use Job Order Contracting (JOC) for public works projects when a determination is made that the use of job order contracts will benefit the public. Formatted: Centered Packet Pg. 20 2.2.a The JOC program is anticipated to be utilized in many different departments/divisions including Public Works Engineering & Construction. Road Maintenance, Wastewater, Surface Water, Facilities. Parks. Recreation and Cultural Services and other public works areas/projects. R04 Chapter 39.10 RCW outlines the requirements and authorizes the COE to utilize this contracting procedure. All proposal under this solicitation are subject to RCW 39.10.470. n i N"T PR'Cr Qnnv -4. SCOPE OF WORK' WORM A:F'Q^' The Scope of Work is expected to include, but not be limited to, the following tasks: A. Development Stage: The successful consultant will work with the COE to develop the JOC program. Program development includes meeting with various departments and divisions to assess their needs for this program and then preparing and proposing a JOC program which will most effectively meet the City's requirements. B. Request for Proposal Stage: The successful consultant will work with the COE to develop specifications, terms, and conditions for a Request for Proposal (RFP) to contract with one or two contractors as determined in the Development Stage. The successful consultant will also assist with the evaluation of the proposals submitted. C. Implementation Stage: The successful consultant will assist the COE with implementation of the JOC Program, including training for both the contractor(s) and City staff. Training will include administration, performing estimates, and reconciliation. The successful consultant will work with the COE to create and document all processes and forms needed to successfully implement the JOC Program. D. Ongoing JOC Program Support: The successful consultant will assist the COE with initial and ongoing job orders and follow-up as needed. The successful consultant will also provide updates for unit price books. Books must be updated at least annually. If the awarded contract includes software, the successful consultant will also provide ongoing technical support and training for the software. Packet Pg. 21 2.2.a The proposed timeline is to engage the successful consultant's services starting in May 2021, resulting in the implementation of a JOC Program no later than December 31, 2021. The contract term will be effective upon the date of contract execution for two (2) years with the option to renew for two (2) additional one-year terms. Contract prices shall remain firm during the contract term. 6. PRELIMINARY TIMELINE RFP Release March 2021. Deadline for Written Inauiries [Date 2 weeks after RFT Release date Proposals Due [Date 4 weeks after RFP Release date] Interview Top Candidates [Dates during week after Proposals Due date] (if needed)* Selection April 2021* Contract Executed April -May 2021* *dates are approximate A. Proposal Format and Submission Requirements 10 ] The minirm.., fent fer all text in the Proposal shall he nA I..« than 11 point. 104€ The electronic copy of the Proposal should be in PDF format, should be all inclusive, and should be formatted as a single file being not more than 30MB in size. 10.5 The felleyVing elements of the Proposal will be exempt frem the page count: a. FFont and hark 10.6 All Fespenses te this RFP shall be organized in the e­rde.r kSted below. a. Ability and qualifications of pF9fessienal peFsennel b. Past performance on similar eei#Faets. Ability te Fneet time and budget B. Proposal Content Requirements The following proposal content requirements will be adhered to by each firm and presented in the following order: 2_342LAUroach. a. Methodology(iesl:T""r^hl ^`"^"I'' Clearly describeyourapproach toindeveloping implementing; and supporting a JOC program, including how training is accomplished for both contractor(s) Packet Pg. 22 2.2.a and City staff, and the methodology or methodologies planned to be used to carry out the specific tasks described in the Work Plan. b. 31.3Work Plan: Describe the sequential tasks to be used to accomplish this project. Indicate all key deliverables and their contents. Include a list of information required or tasks to be completed by City staff. c. Unit Price Book: Propose the use of a unit price book for 10C cost reference and determination. Respondents may propose the use of their own unit price book, propose to create a new book, and/or propose the use of a unit price book from a third -party source, or a combination of any of the aforementioned. Identify what type of unit price book is proposed and provide a representative snapshot sample. Tasks and prices in the unit price book(s) must reflect the local prevailing and other wage requirements of applicable local laws in Snohomish County and the State of Washington. Please provide the following information on the unit price book(s): i. Revision cycle (when was it last updated/when is it scheduled to be updated); ii. Revision methodology; iii. Price collection methodology; iv. Approach to localizing prices; v. Anticipated number of materials, labor, and equipment line items; vi. Maturity of book (how long has it been published/in use); and vii. Other relevant factors to describe the quality or comprehensiveness of the book. aA.34-4Software: Respondent may propose software that will be helpful in the implementation of this program. Respondent shall be very specific on the cost of the software, the complexity of using it, training to be provided, and whether this software is optional, recommended, or required for implementation. e_311.5 Project Organization and Staffing: Describe the qualifications and experience of key personnel who will be assigned to this project. Identify each by their proposed role and the percentage of time they will be committed to the City. Include for each their name and current, pertinent resume. Identify and provide the same information for any proposed subcontractors. Packet Pg. 23 2.2.a b-f_1:1.6 Proiect Schedule: Provide a schedule for completing each task in the Scope of Work, including deadlines for preparing project deliverables. Demonstrate your team's ability to perform the work requested within an established budget and schedule. 3. Related Experience. Describe recent (within the last 4 years), directly related experience in JOC program development and implementation. Briefly describe each project and for each reference provide up-to-date individual contact name with email and phone number. Provide the size, scope, and dates of each project. At least four llreferences should be included. The City reserves the right to contact any organizations or individuals listed_ 8. EVALUATION OF PROPOSALS The City's Evaluation Panel will use the following criteria to evaluate each RFP proposal: Criteria Points Approach Maximum 30 Points Related Project Experience Maximum 20 Points Expertise of Project Team Maximum 20 Points Cost Maximum 30 Point Maximum Points Maximum 100 Points The proposals will be the basis from which interested individuals or firms will be selected for interviews. Following the City staff evaluation of the proposals received, selected individuals or firms may be invited to make oral presentations before the City's Evaluation Panel. The City's Project Manager will provide Formatted: Font: Bold Commented [SECT]: These are the point totz Shoreline used, and they made sense to me, bu can be adjusted as the City sees fit. Formatted: Font: Bold Packet Pg. 24 2.2.a additional details outlining the preferred content of the presentation to each firm or team of firms that isafe invited to participate. Upon completion of the evaluations, the City's Evaluation Panel will determine the most qualified individual or firm based on all materials and information presented. The City will then begin the negotiations for an agreement with the selected individual or firm. Any individual or firm failing to submit information in accordance with the procedures set forth in the RFP may be subject to disqualification. The City reserves the right to change the solicitation schedule or issue amendments to the solicitation at any time. The City reserves the right, at its sole discretion, to waive immaterial irregularities contained in the solicitation. The City reserves the right to reject any and all proposals at any time, without penalty. The City reserves the right to refrain from contracting with any respondent. Individuals or firms eliminated from further consideration will be notified in writinehy rna44 by the City as soon as practical. Proposals remain confidential until closing deadline after which proposals are considered a public record subject to public disclosure under RCW 42.56, the Public Records Act. Proposers shall mark as "proprietary" any information that the Proposer believes meets the exemption under RCW 42.56.270(1). This designation will be considered by the City in response to public records requests. Any Proposal may be withdrawn, either personally or by written request, at any time prior to the time set for the Proposal submittal deadline. The City of Edmonds, in accordance with Title VI of the Civil Rights Act of 1964, 78 Stat. 252, 42 U.S.C. 2000d to 2000d-4 and Title 49, Code of Federal Regulations, Department of Transportation, Subtitle A, Office of the Secretary, Part 21, Nondiscrimination in Federally -assisted programs of the Department of Transportation, issued pursuant to such Act, hereby notifies all bidders that it will affirmatively ensure that in any contract entered into pursuant to this advertisement, disadvantaged business enterprises as defined at 49 CFR Part 26 will be afforded full opportunity to submit bids in response to this invitation and will not be discriminated against on the grounds of race, color, national origin, or sex in consideration for an award. Attachments: City of Edmonds Sample Contract Document PROFESSIONAL SERVICES AGREEMENT THIS AGREEMENT ("Agreement") is made and entered into between the City of Edmonds, hereinafter referred to as the "City," and , hereinafter referred to as the "Consultant." WHEREAS, the City desires to engage the professional services and assistance of a consulting firm to provide services related to the project ("Project"); and Packet Pg. 25 2.2.a WHEREAS, the Consultant has the necessary skills and experience, and desires to provide such services to the City; NOW, THEREFORE, in consideration of the mutual benefits accruing, it is agreed by and between the parties hereto as follows: 1. Scope of work. The scope of work shall include all services and material necessary to accomplish the above mentioned objectives in accordance with the Scope of Work that is marked as Exhibit A, attached hereto and incorporated herein by this reference. 2. Payments. The Consultant shall be paid by the City for completed work for services rendered under this Agreement as provided hereinafter. Such payment shall be full compensation for work performed or services rendered and for all labor, materials, supplies, equipment and incidentals necessary to complete the work. A. Payment for work accomplished under the terms of this Agreement shall be on a time and expense basis as set forth in Exhibit B, attached hereto and incorporated herein by this reference; provided, in no event shall the paMent for work performed pursuant to this Agreement exceed the sum of THOUSAND DOLLARS ($ ,000.00). B. All vouchers shall be submitted by the Consultant to the Cijy for payment pursuant to the terms of this Agreement. The City shall pay the appropriate amount for each voucher to the Consultant. The Consultant may submit vouchers to the City monthly during the progress of the work for payment of completed phases of the project. Billings shall be reviewed in conjunction with the City's warrant process. No billing shall be considered for payment that has not been submitted to the City three (3) days prior to the scheduled cut-off date. Such late vouchers will be checked by the City and payment will be made in the next regular payment C. The costs records and accounts pertaining to this Agreement are to be kept available for inspection by representatives of the City for a period of three (3) years after final payment. Copies shall be made available upon request. 3. Ownership and use of documents. All research, tests, surveys, preliminary reports, and any and all other work product prepared or gathered by the Consultant in preparation for the services rendered by the Consultant under this Agreement shall be and are the property of the Consultant, provided, however, that: A. All final reports, presentations, documentation and testimony prepared by the Consultant shall become the property of the City upon their presentation to and acceptance by the City and shall at that date become the property of the City, Packet Pg. 26 2.2.a B. The City shall have the right,upon reasonable request, to inspect, review and copy work product during normal office hours. Documents prepared under this Agreement and in the possession of the Consultant may be subject to public records request and release under Chapter 42.56 RCW. C. In the event that the Consultant shall default on this Agreement, or in the event that this Agreement shall be terminated prior to its completion as herein provided, the work product of the Consultant, along with a summary of work done to date of default or termination, shall become the property of the City and tender of the work product and summary shall be a prerequisite to final payment under this Agreement. The summary of work done shall be prepared at no additional cost. 4. Time of performance. The Consultant shall perform the work authorized by this Agreement promptly in accordance with the receipt of the required ,governmental approvals. 5. Indemnification / Hold harmless agreement. The Consultant shall defend, indemnify and hold the City, its officers, officials, employees and volunteers harmless from any and all claims, injuries, damages, losses, demands, or suits at law or equity arising from the acts, errors or omissions of the Consultant in the performance of this Agreement, except for injuries and damages caused by the sole negligence of the City. Should a court of competent jurisdiction determine that this Agreement is subject to RCW 4.24.115, then, in the event of liability for damages arising out of bodily injury to persons or damages to property caused by or resulting from the concurrent negligence of the Consultant and the City, its officers, officials, employees, and volunteers, the Consultant's liability, including the duty and cost to defend, hereunder shall be only to the extent of the Consultant's negligence. The Consultant shall comply with all applicable sections of the applicable Ethics laws, including RCW 42.23, which is the Code of Ethics for regulating contract interest by municipal officers. The Consultant specifically assumes potential liability for actions brought by the Consultant's own employeesgainst the City and, solely for the purpose of this indemnification and defense, the Consultant specifically waives any immunity under the state industrial insurance law, Title 51 RCW. This waiver has been mutually negotiated by the parties. The provisions of this section shall survive the expiration or termination of this Agreement. 6. General and professional liability insurance. The Consultant shall obtain and keep in force during the term of this Agreement, or as otherwise required, the following insurance with companies or through sources approved by the State Insurance Commissioner pursuant to Title 48 RCW. Insurance Coverage A. Worker's compensation and employer's liability insurance as required by the State. B. Commercial general liability and property damage insurance in an aggregate amount not less than two million dollars ($2,000,000) for bodily injury, including death and property damage. The per occurrence amount shall be written with limits no less than one million dollars ($1,000,000). C. Vehicle liability insurance for any automobile used in an amount not less than a one million dollar ($1,000,000) combined single limit. D. Professional liability insurance in the amount of one million dollars ($1,000,000). Packet Pg. 27 2.2.a Excepting the Worker's Compensation Insurance and Professional Liability Insurance secured by the Consultant, the City will be named on all policies as an additional insured. The Consultant shall furnish the City with verification of insurance and endorsements required by the Agreement. The City reserves the right to require complete, certified copies of all required insurance policies at any time. All insurance shall be obtained from an insurance company authorized to do business in the State of Washington. The Consultant shall submit a verification of insurance as outlined above within fourteen days of the execution of this Agreement to the City. No cancellation of the foregoing policies shall be effective without thirty (30) days prior notice to the Cit. The Consultant's professional liability to the City shall be limited to the amount payable under this Agreement or one million dollars ($1,000,000), whichever is the greater, unless modified elsewhere in this Agreement. In no case shall the Consultant's professional liability to third parties be limited in any way, 7. Discrimination prohibited. The Consultant shall not discriminate against any employee or applicant for employment because of race, color, religion, national origin, age, sex, sexual orientation, marital status, veteran status, liability for service in the armed forces of the United States, disability, or the presence of any sensory, mental or physical handicap, or an, other ther protected class status, unless based upon a bona fide occupational qualification. 8. Consultant is an independent contractor. The parties intend that an independent contractor relationship will be created by this Agreement. No agent, employee or representative of the Consultant shall be deemed to be an agent, employee or representative of the City for anypurpose. The Consultant shall be solely responsible for all acts of its agents, employees, representatives and subcontractors during the performance of this Agreement. 9. City approval of work and relationships. Notwithstanding the Consultant's status as an independent contractor, results of the work performed pursuant to this Agreement must meet the approval of the City. During pendency of this Agreement, the Consultant shall not perform work for anyparty with respect to anyproperty located within the City of Edmonds or for anyproiect subject to the administrative or quasijudicial review of the City without written notification to the City and the City's prior written consent. 10. Termination. This being an Agreement for professional services, either party may terminate this Agreement for any reason upon giving the other party written notice of such termination no fewer than ten (10) days in advance of the effective date of said termination. 11. Integration. The Agreement between the parties shall consist of this document and the Scope of Work and fee schedule attached hereto as Exhibits A and B. These writings constitute the entire Agreement of the parties and shall not be amended except by a writing executed by bath parties. In the event of any conflict between this written Agreement and any provision of Exhibit A or B, this Agreement shall control. 12. Changes/Additional Work. The City may engage the Consultant to perform services in addition to those listed in this Agreement, and the Consultant will be entitled to additional compensation for authorized additional services or materials. The City shall not be liable for additional compensation until and unless any and all additional work and compensation is approved in advance in writing and signed by both parties to this Agreement. If conditions are encountered which are not anticipated in the Scope of Work, the City understands that a revision to the Scope of Work and fees may be required. Provided, however, that nothingin n this parag-aph shall be interpreted to obligate the Consultant to render services, or Packet Pg. 28 2.2.a the City to pay for services rendered, in excess of the Scope of Work in Exhibit A unless or until an amendment to this Agreement is approved in writing by both parties. 13. Standard of Care. The Consultant represents that the Consultant has the necessary knowledge, skill and experience to perform services required by this Agreement. The Consultant and any persons employed by the Consultant shall use their best efforts to perform the work in a professional manner consistent with sound practices, in accordance with the schedules herein and in accordance with the usual and custornga professional care required for services of the We described in the Scope of Work. 14. Non -waiver. Waiver by the City of anyprovision of this Agreement or any time limitation provided for in this Agreement shall not constitute a waiver of an,, o�provision. 15. Non -assignable. The services to be provided by the Consultant shall not be assigned or subcontracted without the express written consent of the City. 16. Covenant against contingent fees. The Consultant warrants that he/she/they has/have not employed or retained any company or person, other than a bona fide employee working solely for the Consultant, to solicit or secure this Agreement, and that he/she/they has/have not paid or agreed ed to pay any company or person, other than a bona fide employee working solely for the Consultant, any fee, commission, percentage, brokerage fee, gifts, or any other consideration contingent upon or resultingfrom rom the award of making of this Agreement. For breach or violation of this warranty, the City shall have the right to annul this Agreement without liability or, in its discretion to deduct from the contract price or consideration, or otherwise recover, the full amount of such fee, commission, percentage, brokerage fee, gift, or contin eng t fee. 17. Compliance with laws. The Consultant in the performance of this Agreement shall comply with all applicable Federal, State or local laws and ordinances, including regulations for licensing, certification and operation of facilities, programs and accreditation, and licensing of individuals, and any other standards or criteria as described in the Agreement to assure quality of services. The Consultant specifically agrees to pay M applicable business and occupation (B & O) taxes which may be due on account of this Agreement. 18. Notices. Notices to the City of Edmonds shall be sent to the following address: City of Edmonds 121 Fifth Avenue North Edmonds, WA 98020 Notices to the Consultant shall be sent to the following address: Name Address Packet Pg. 29 2.2.a a� c L City, State, Zip] c Receipt of any notice shall be deemed effective three (3) days after deposit of written notice in the U.S. O mails, with proper postage and properly addressed. V d L DATED THIS day of 2021. 0 O CITY OF EDMONDS [NAME OF CONSULTANT] C O y d Michael Nelson, Mayor [Name, Title] N 0 N M N ATTEST/AUTHENTICATED: nj d C O Scott Passey, City Clerk APPROVED AS TO FORM: Office of the City Attorney Packet Pg. 30 2.2.b City of Edmonds Request for Proposal (RFP) Job Order Contractine Consultine Services Due Date: / /2021 No Later than 4 P.M. Pacific Standard Time Submit to City of Edmonds City Clerk's Office: 12151h Avenue North, Edmonds WA 98020 1. INTRODUCTION The City of Edmonds (COE), Washington is soliciting proposals from qualified consultants to develop, implement, and support a Job Order Contracting (JOC) program for the City as provided for in Chapter 39.10 RCW Alternative Public Works Contracting Procedures. 2. PRIMARY OBJECTIVES The objectives of the City's JOC program are to rapidly engage contractors in the performance of small to medium sized public works projects; to reduce construction, design, and planning costs; and to develop relationships and contracts with contractors to more quickly and efficiently respond to emergency situations. 3.BACKGROUND During the 2019 Legislative Sessions, RCW 39.10.420—.460 was amended to allow all public agencies to use Job Order Contracting (JOC) for public works projects when a determination is made that the use of job order contracts will benefit the public. The COE has determined that the use of Job Order Contracting will benefit the public by providing an effective means of reducing total lead-time and cost for the construction of public works projects for repair and renovation required at public facilities through the use of unit price books and work orders by eliminating time-consuming, costly aspects of the traditional public works process, which require separate contracting actions for each small project. The JOC program is anticipated to be utilized in many different departments/divisions including Public Works Engineering & Construction, Road Maintenance, Wastewater, Surface Water, Facilities, Parks, Recreation and Cultural Services and other public works areas/projects. Chapter 39.10 RCW outlines the requirements and authorizes the COE to utilize this contracting procedure. All proposal under this solicitation are subject to RCW 39.10.470. Packet Pg. 31 2.2.b 4. SCOPE OF WORK The Scope of Work is expected to include, but not be limited to, the following tasks: A. Development Stage: The successful consultant will work with the COE to develop the JOC program. Program development includes meeting with various departments and divisions to assess their needs for this program and then preparing and proposing a JOC program which will most effectively meet the City's requirements. B. Request for Proposal Stage: The successful consultant will work with the COE to develop specifications, terms, and conditions for a Request for Proposal (RFP) to contract with one or two contractors as determined in the Development Stage. The successful consultant will also assist with the evaluation of the proposals submitted. C. Implementation Stage: The successful consultant will assist the COE with implementation of the JOC Program, including training for both the contractor(s) and City staff. Training will include administration, performing estimates, and reconciliation. The successful consultant will work with the COE to create and document all processes and forms needed to successfully implement the JOC Program. D. Ongoing JOC Program Support: The successful consultant will assist the COE with initial and ongoing job orders and follow-up as needed. The successful consultant will also provide updates for unit price books. Books must be updated at least annually. If the awarded contract includes software, the successful consultant will also provide ongoing technical support and training for the software. 5.SCHEDULE The proposed timeline is to engage the successful consultant's services starting in May 2021, resulting in the implementation of a JOC Program no later than December 31, 2021. The contract term will be effective upon the date of contract execution for two (2) years with the option to renew for two (2) additional one-year terms. Contract prices shall remain firm during the contract term. 6. PRELIMINARY TIMELINE RFP Release Deadline for Written Inquiries Proposals Due Interview Top Candidates Selection Contract Executed March J 2021. [Date 2 weeks after RFT Release date] [Date 4 weeks after RFP Release date] [Dates during week after Proposals Due date] (if needed)* April 2021* April -May 2021* *dates are approximate Packet Pg. 32 2.2.b 7. SUBMISSION INFORMATION A. Proposal Format and Submission Requirements One (1) unbound original and One (1) CD or flash drive in pdf format of the RFP shall be submitted to the City of Edmonds City Clerk's Office, 1215th Ave N, Edmonds, Washington, 98020. Please mark the outside of the envelope with "JOC RFP Response". The deadline for proposals by interested parties is DATE HERE by 4:00 p.m. exactly Pacific Local Time. Respondents assume the risk of the method of dispatch chosen. The City assumes no responsibility for delays caused by any delivery service. Postmarking by the due date will not substitute for actual receipt of qualifications. Proposals shall not be delivered by facsimile transmission or other telecommunication or electronic means. The Proposals are limited to fifteen (15) single-spaced, double -sided, 8.5"x11" pages (or maximum of 30 single -sided pages) of content in no less than 12 point font, not including resumes and Unit Price Book sample. Supplemental information, such as brochures, may be submitted if desired. The electronic copy of the Proposal should be in PDF format, should be all inclusive, and should be formatted as a single file being not more than 30MB in size. Questions related to this solicitation may be directed to Thom Sullivan, Facilities Manager, at thom.suilivan@edmondswa.gov. Questions via phone will not be accepted. The deadline for written inquiries is DATE HERE by 4:00 p.m. All substantive questions and answers will be formalized and issued as an addendum to this RFP. B. Proposal Content Requirements The following proposal content requirements will be adhered to by each firm and presented in the following order: 1. Executive Summary. An executive summary letter should include the key elements of the respondent's RFP and an overview of the consultant team. Indicate the address and telephone number of the respondent's office located nearest to Edmonds, Washington, and the office from which the project will be managed. 2. Approach. a. Methodoloey(ies): Clearly describe your approach to developing, implementing, and supporting a JOC program, including how training is accomplished for both contractor(s) and City staff, and the methodology or methodologies planned to be used to carry out the specific tasks described in the Work Plan. b. Work Plan: Describe the sequential tasks to be used to accomplish this project. Indicate all key deliverables and their contents. Include a list of information required or tasks to be completed by City staff. c. Unit Price Book: Propose the use of a unit price book for JOC cost reference and determination. Respondents may propose the use of their own unit price book, propose to create a new book, and/or propose the use of a unit price book from a third -party source, or a combination of any of the aforementioned. Identify what type of unit price book is Packet Pg. 33 2.2.b proposed and provide a representative snapshot sample. Tasks and prices in the unit price book(s) must reflect the local prevailing and other wage requirements of applicable local laws in Snohomish County and the State of Washington. Please provide the following information on the unit price book(s): i. Revision cycle (when was it last updated/when is it scheduled to be updated); ii. Revision methodology; iii. Price collection methodology; iv. Approach to localizing prices; v. Anticipated number of materials, labor, and equipment line items; vi. Maturity of book (how long has it been published/in use); and vii. Other relevant factors to describe the quality or comprehensiveness of the book. d. Software: Respondent may propose software that will be helpful in the implementation of this program. Respondent shall be very specific on the cost of the software, the complexity of using it, training to be provided, and whether this software is optional, recommended, or required for implementation. e. Proiect Organization and Staffing: Describe the qualifications and experience of key personnel who will be assigned to this project. Identify each by their proposed role and the percentage of time they will be committed to the City. Include for each their name and current, pertinent resume. Identify and provide the same information for any proposed subcontractors. f. Proiect Schedule: Provide a schedule for completing each task in the Scope of Work, including deadlines for preparing project deliverables. Demonstrate your team's ability to perform the work requested within an established budget and schedule. 3. Related Experience. Describe recent (within the last 4 years), directly related experience in JOC program development and implementation. Briefly describe each project and for each reference provide up-to-date individual contact name with email and phone number. Provide the size, scope, and dates of each project. At least four (4) references should be included. The City reserves the right to contact any organizations or individuals listed. Expertise of Proiect Team. The respondent is required to provide evidence of experience in working with local agencies to develop, implement, support and train all parties in a successful JOC program. The experience listed must be that which was performed by the respondent's staff and/or team's staff that will be assigned to this project. The City will be focusing on the experience of the Lead Consultant/Project Manager who will be assigned to this project. The RFP shall also identify other projects the proposed Lead Consultant/Project Manager will be committed to during the same timeline. 5. Cost. Provide estimate of cost for services, initial and on -going costs of proposed software, and other costs that may be incurred to develop, implement, and support a JOC program. Packet Pg. 34 2.2.b 8. EVALUATION OF PROPOSALS The City's Evaluation Panel will use the following criteria to evaluate each RFP proposal: Criteria Points Approach Maximum 30 Points Related Project Experience Maximum 20 Points Expertise of Project Team Maximum 20 Points Cost Maximum 30 Point Maximum Points Maximum 100 Points The proposals will be the basis from which interested individuals or firms will be selected for interviews. Following the City staff evaluation of the proposals received, selected individuals or firms may be invited to make oral presentations before the City's Evaluation Panel. The City's Project Manager will provide additional details outlining the preferred content of the presentation to each firm or team of firms that is invited to participate. Upon completion of the evaluations, the City's Evaluation Panel will determine the most qualified individual or firm based on all materials and information presented. The City will then begin the negotiations for an agreement with the selected individual or firm. Any individual or firm failing to submit information in accordance with the procedures set forth in the RFP may be subject to disqualification. The City reserves the right to change the solicitation schedule or issue amendments to the solicitation at any time. The City reserves the right, at its sole discretion, to waive immaterial irregularities contained in the solicitation. The City reserves the right to reject any and all proposals at any time, without penalty. The City reserves the right to refrain from contracting with any respondent. Individuals or firms eliminated from further consideration will be notified in writing by the City as soon as practical. Proposals remain confidential until closing deadline after which proposals are considered a public record subject to public disclosure under RCW 42.56, the Public Records Act. Proposers shall mark as "proprietary" any information that the Proposer believes meets the exemption under RCW 42.56.270(1). This designation will be considered by the City in response to public records requests. Any Proposal may be withdrawn, either personally or by written request, at any time prior to the time set for the Proposal submittal deadline. The City of Edmonds, in accordance with Title VI of the Civil Rights Act of 1964, 78 Stat. 252, 42 U.S.C. 2000d to 2000d-4 and Title 49, Code of Federal Regulations, Department of Transportation, Subtitle A, Office of the Secretary, Part 21, Nondiscrimination in Federally -assisted programs of the Department of Transportation, issued pursuant to such Act, hereby notifies all bidders that it will affirmatively ensure that in any contract entered into pursuant to this advertisement, disadvantaged business enterprises as defined at 49 CFR Part 26 will be afforded full opportunity to submit bids in response to this invitation and will not be discriminated against on the grounds of race, color, national origin, or sex in consideration for an award. Attachment: City of Edmonds Sample Contract Document Commented [SECT]: These are the point totz Shoreline used, and they made sense to me, bu can be adjusted as the City sees fit. Packet Pg. 35 2.2.b PROFESSIONAL SERVICES AGREEMENT THIS AGREEMENT ("Agreement") is made and entered into between the City of Edmonds, hereinafter referred to as the "City," and , hereinafter referred to as the "Consultant." WHEREAS, the City desires to engage the professional services and assistance of a consulting firm to provide services related to the project ("Project"); and WHEREAS, the Consultant has the necessary skills and experience, and desires to provide such services to the City; NOW, THEREFORE, in consideration of the mutual benefits accruing, it is agreed by and between the parties hereto as follows: 1. Scope of work. The scope of work shall include all services and material necessary to accomplish the above mentioned objectives in accordance with the Scope of Work that is marked as Exhibit A, attached hereto and incorporated herein by this reference. 2. Payments. The Consultant shall be paid by the City for completed work for services rendered under this Agreement as provided hereinafter. Such payment shall be full compensation for work performed or services rendered and for all labor, materials, supplies, equipment and incidentals necessary to complete the work. A. Payment for work accomplished under the terms of this Agreement shall be on a time and expense basis as set forth in Exhibit B, attached hereto and incorporated herein by this reference; provided, in no event shall the payment for work performed pursuant to this Agreement exceed the sum of THOUSAND DOLLARS ($_,000.00). B. All vouchers shall be submitted by the Consultant to the City for payment pursuant to the terms of this Agreement. The City shall pay the appropriate amount for each voucher to the Consultant. The Consultant may submit vouchers to the City monthly during the progress of the work for payment of completed phases of the project. Billings shall be reviewed in conjunction with the City's warrant process. No billing shall be considered for payment that has not been submitted to the City three (3) days prior to the scheduled cut-off date. Such late vouchers will be checked by the City and payment will be made in the next regular payment cycle. Packet Pg. 36 2.2.b C. The costs records and accounts pertaining to this Agreement are to be kept available for inspection by representatives of the City for a period of three (3) years after final payment. Copies shall be made available upon request. 3. Ownership and use of documents. All research, tests, surveys, preliminary data, reports, and any and all other work product prepared or gathered by the Consultant in preparation for the services rendered by the Consultant under this Agreement shall be and are the property of the Consultant, provided, however, that: A. All final reports, presentations, documentation and testimony prepared by the Consultant shall become the property of the City upon their presentation to and acceptance by the City and shall at that date become the property of the City. B. The City shall have the right, upon reasonable request, to inspect, review and copy any work product during normal office hours. Documents prepared under this Agreement and in the possession of the Consultant may be subject to public records request and release under Chapter 42.56 RCW. C. In the event that the Consultant shall default on this Agreement, or in the event that this Agreement shall be terminated prior to its completion as herein provided, the work product of the Consultant, along with a summary of work done to date of default or termination, shall become the property of the City and tender of the work product and summary shall be a prerequisite to final payment under this Agreement. The summary of work done shall be prepared at no additional cost. 4. Time of performance. The Consultant shall perform the work authorized by this Agreement promptly in accordance with the receipt of the required governmental approvals. 5. Indemnification / Hold harmless areement. The Consultant shall defend, indemnify and hold the City, its officers, officials, employees and volunteers harmless from any and all claims, injuries, damages, losses, demands, or suits at law or equity arising from the acts, errors or omissions of the Consultant in the performance of this Agreement, except for injuries and damages caused by the sole negligence of the City. Should a court of competent jurisdiction determine that this Agreement is subject to RCW 4.24.115, then, in the event of liability for damages arising out of bodily injury to persons or damages to property caused by or resulting from the concurrent negligence of the Consultant and the City, its officers, officials, employees, and volunteers, the Consultant's liability, including the duty and cost to defend, hereunder shall be only to the extent of the Consultant's negligence. The Consultant shall comply with all applicable sections of the applicable Ethics laws, including RCW 42.23, which is the Code of Ethics for regulating contract interest by municipal officers. The Consultant specifically assumes potential liability for actions brought by the Consultant's own employees against the City and, solely for the purpose of this indemnification and defense, the Consultant specifically waives any immunity under the state industrial insurance law, Title 51 RCW. This waiver has been mutually negotiated by the parties. The provisions of this section shall survive the expiration or termination of this Agreement. Packet Pg. 37 2.2.b 6. General and professional liability insurance. The Consultant shall obtain and keep in force during the term of this Agreement, or as otherwise required, the following insurance with companies or through sources approved by the State Insurance Commissioner pursuant to Title 48 RCW. Insurance Coverage A. Worker's compensation and employer's liability insurance as required by the State. B. Commercial general liability and property damage insurance in an aggregate amount not less than two million dollars ($2,000,000) for bodily injury, including death and property damage. The per occurrence amount shall be written with limits no less than one million dollars ($1,000,000). C. Vehicle liability insurance for any automobile used in an amount not less than a one million dollar ($1,000,000) combined single limit. D. Professional liability insurance in the amount of one million dollars ($1,000,000). Excepting the Worker's Compensation Insurance and Professional Liability Insurance secured by the Consultant, the City will be named on all policies as an additional insured. The Consultant shall furnish the City with verification of insurance and endorsements required by the Agreement. The City reserves the right to require complete, certified copies of all required insurance policies at any time. All insurance shall be obtained from an insurance company authorized to do business in the State of Washington. The Consultant shall submit a verification of insurance as outlined above within fourteen days of the execution of this Agreement to the City. No cancellation of the foregoing policies shall be effective without thirty (30) days prior notice to the City. The Consultant's professional liability to the City shall be limited to the amount payable under this Agreement or one million dollars ($1,000,000), whichever is the greater, unless modified elsewhere in this Agreement. In no case shall the Consultant's professional liability to third parties be limited in any way. 7. Discrimination prohibited. The Consultant shall not discriminate against any employee or applicant for employment because of race, color, religion, national origin, age, sex, sexual orientation, marital status, veteran status, liability for service in the armed forces of the United States, disability, or the presence of any sensory, mental or physical handicap, or any other protected class status, unless based upon a bona fide occupational qualification. 8. Consultant is an independent contractor. The parties intend that an independent contractor relationship will be created by this Agreement. No agent, employee or representative of the Consultant shall be deemed to be an agent, employee or representative of the City for any purpose. The Consultant shall be solely responsible for all acts of its agents, employees, representatives and subcontractors during the performance of this Agreement. City approval of work and relationships. Notwithstanding the Consultant's status as an independent contractor, results of the work performed pursuant to this Agreement must meet the approval of the City. During pendency of this Agreement, the Consultant shall not perform work for any party with respect to any property located within the City of Edmonds or for any project subject to the administrative or quasijudicial review of the City without written notification to the City and the City's prior written consent. 10. Termination. This being an Agreement for professional services, either party may terminate this Agreement for any reason upon giving the other party written notice of such termination no fewer than ten (10) days in advance of the effective date of said termination. Packet Pg. 38 2.2.b 11. Integration. The Agreement between the parties shall consist of this document and the Scope of Work and fee schedule attached hereto as Exhibits A and B. These writings constitute the entire Agreement of the parties and shall not be amended except by a writing executed by both parties. In the event of any conflict between this written Agreement and any provision of Exhibit A or B, this Agreement shall control. 12. Changes/Additional Work. The City may engage the Consultant to perform services in addition to those listed in this Agreement, and the Consultant will be entitled to additional compensation for authorized additional services or materials. The City shall not be liable for additional compensation until and unless any and all additional work and compensation is approved in advance in writing and signed by both parties to this Agreement. If conditions are encountered which are not anticipated in the Scope of Work, the City understands that a revision to the Scope of Work and fees may be required. Provided, however, that nothing in this paragraph shall be interpreted to obligate the Consultant to render services, or the City to pay for services rendered, in excess of the Scope of Work in Exhibit A unless or until an amendment to this Agreement is approved in writing by both parties. 13. Standard of Care. The Consultant represents that the Consultant has the necessary knowledge, skill and experience to perform services required by this Agreement. The Consultant and any persons employed by the Consultant shall use their best efforts to perform the work in a professional manner consistent with sound practices, in accordance with the schedules herein and in accordance with the usual and customary professional care required for services of the type described in the Scope of Work. 14. Non -waiver. Waiver by the City of any provision of this Agreement or anytime limitation provided for in this Agreement shall not constitute a waiver of any other provision. 15. Non -assignable. The services to be provided by the Consultant shall not be assigned or subcontracted without the express written consent of the City. 16. Covenant against contingent fees. The Consultant warrants that he/she/they has/have not employed or retained any company or person, other than a bona fide employee working solely for the Consultant, to solicit or secure this Agreement, and that he/she/they has/have not paid or agreed to pay any company or person, other than a bona fide employee working solely for the Consultant, any fee, commission, percentage, brokerage fee, gifts, or any other consideration contingent upon or resulting from the award of making of this Agreement. For breach or violation of this warranty, the City shall have the right to annul this Agreement without liability or, in its discretion to deduct from the contract price or consideration, or otherwise recover, the full amount of such fee, commission, percentage, brokerage fee, gift, or contingent fee. 17. Compliance with laws. The Consultant in the performance of this Agreement shall comply with all applicable Federal, State or local laws and ordinances, including regulations for licensing, certification and operation of facilities, programs and accreditation, and licensing of individuals, and any other standards or criteria as described in the Agreement to assure quality of services. The Consultant specifically agrees to pay any applicable business and occupation (B & O) taxes which may be due on account of this Agreement. Packet Pg. 39 2.2.b a� 18. Notices. Notices to the City of Edmonds shall be sent to the following address:cc L City of Edmonds = O 121 Fifth Avenue North V L d Edmonds, WA 98020 O O Notices to the Consultant shall be sent to the following address: [Name] _ [Address] .N G City, State, Zip] _d Receipt of any notice shall be deemed effective three (3) days after deposit of written notice in the U.S. mails, with proper postage and properly addressed. DATED THIS day of CITY OF EDMONDS Michael Nelson, Mayor ATTEST/AUTHENTICATED: Scott Passey, City Clerk APPROVED AS TO FORM: Office of the City Attorney 2021. [NAME OF CONSULTANT] [Name, Title] Packet Pg. 40 2.3 City Council Agenda Item Meeting Date: 03/9/2021 January 2021 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Review and move to full council on consent Narrative January 2021 Monthly Financial Report Attachments: January 2021 Monthly Financial Report Packet Pg. 41 I 2.3.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT JAN UARY 2021 Packet Pg. 42 1 I 2.3.a I Page 1 of 1 C ITY OF EDMO NDS REVENUES BY FUND - SUMMARY Fund 2021 Adopted 1/31/2020 1/31/2021 Amount No. Title Budget Revenues Revenues Remaining %Receive 001 GENERAL FUND $ 42,450,777 $ 2,376,947 $ 2,740,276 $ 39,710,501 6 009 LEOFF-MEDICAL INS. RESERVE 300,000 - - 300,000 0 012 CONTINGENCY RESERVE FUND 2,620 - 2,620 0 014 HISTORIC PRESERVATION GIFT FUND 5,010 - 5,010 0 104 DRUG ENFORCEMENT FUND 165,370 117 310 165,060 0 -r- O Ill STREET FUND 1,722,360 127,413 111,823 1,610,537 6 Q- N 112 COMBINED STREET CONS'T/IMPROVE 3,048,185 137,786 9,353 3,038,832 0 O 117 MUNICIPAL ARTS ACQUIS. FUND 165,060 1,845 2,840 162,220 2 U 118 MEMORIAL STREET TREE 270 58 84 186 31LL O C 120 HOTEL/MOTEL TAX REVENUE FUND 71,460 6,361 3,993 67,467 6 121 EMPLOYEE PARKING PERMIT FUND 25,240 8,472 4,308 20,932 17 122 YOUTH SCHOLARSHIP FUND 1,390 41 58 1,332 4 0 123 TOURISM PROMOTIONAL FUND/ARTS 24,000 2,236 1,560 22,440 7 N 125 REAL ESTATE EXCISE TAX 2 1,282,050 169,198 324,010 958,040 25 0 N 126 REAL ESTATE EXCISE TAX 1 1,285,240 168,964 322,781 962,459 25 O 127 GIFTS CATALOG FUND 103,930 1,585 984 102,946 1 cv 130 CEMETERY MAINTENANCE/IMPROVEMT 179,800 11,884 22,035 157,765 12 136 PARKS TRUST FUND 2,200 477 696 1,504 32 O O. 137 CEMETERY MAINTENANCE TRUST FD 29,220 4,317 6,911 22,309 24 � 138 SISTER CITY COMMISSION 10,120 30 43 10,077 0 iC .v 140 BUSINESS IMPROVEMENT DISTRICT 79,239 28,992 23,740 55,499 30 O 141 AFFORDABLE AND SUPPORTIVE HOUSINGFUND 65,000 5,895 6,696 58,304 10 c LL 231 2012 LT GO DEBT SERVICE FUND 759,710 - - 759,710 0 z 332 PARKS CAPITAL CONSTRUCTION FUND 1,392,520 31,469 11,093 1,381,427 1 C 411 COMBINED UTILITY OPERATION - 12,015 80 (80) 0 421 WATER UTILITY FUND 10,299,357 851,740 868,240 9,431,117 8 r Np 422 STORM UTILITY FUND 1 6,012,300 386,687 920,517 5,091,783 15 N 423 SEWER/WWTP UTILITY FUND 2 28,131,150 1,468,879 2,459,980 25,671,170 9 M c 424 BOND RESERVE FUND 1,985,870 1 1 1,985,869 0 511 EQUIPMENT RENTAL FUND 1,331,100 136,607 117,942 1,213,158 9 O 512 TECHNOLOGY RENTAL FUND 1,204,880 100,385 103,236 1,101,644 9 E t 617 FIREMEN'S PENSION FUND 67,270 429 - 67,270 0 v O $ 102,202,698 $ 6,040,830 $ 8,063,589 $ 94,139,109 8 r .r Q 1 Difference primarily due to a Grant reimbursement in January 2021. 2 Differences primarily due to WWTP billings to their partners in January 2021. 1 Packet Pg. 43 1 I 2.3.a I Page 1 of 1 CITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2021 Adopted 1/31/2020 1/31/2021 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 45,179,468 $ 3,641,481 $ 4,488,492 $ 40,690,976 1C 009 LEOFF-MEDICAL INS. RESERVE 467,140 19,826 35,624 431,516 8 014 HISTORIC PRESERVATION GIFT FUND 016 BUILDING MAINTENANCE FUND 018 EDMONDS HOMELESSNESS RESPONSE FUND 019 EDMONDS OPIOID RESPONSE FUND 104 DRUG ENFORCEMENT FUND 111 STREET FUND 112 COMBINED STREET CONST/IMPROVE 117 MUNICIPAL ARTS ACQUIS. FUND 120 HOTEL/MOTEL TAX REVENUE FUND 121 EMPLOYEE PARKING PERMIT FUND 122 YOUTH SCHOLARSHIP FUND 123 TOURISM PROMOTIONAL FUND/ARTS 125 REAL ESTATE EXCISE TAX 2 126 REAL ESTATE EXCISE TAX 1 127 GIFTS CATALOG FUND 130 CEMETERY MAINTENANCE/IMPROVEMT 136 PARKSTRUST FUND 137 CEMETERY MAINTENANCE TRUST FUND 138 SISTER CITY COMMISSION 140 BUSINESS IMPROVEMENT DISTRICT 231 2012 LT GO DEBT SERVICE FUND 332 PARKS CAPITAL CONSTRUCTION FUND 421 WATER UTILITY FUND 422 STORM UTILITY FUND 423 SEWER/WWTP UTILITY FUND 424 BOND RESERVE FUND 511 EQUIPMENT RENTAL FUND 512 TECHNOLOGY RENTAL FUND 617 FIREMEN'S PENSION FUND 5,900 - 5,900 C 210,222 - 210,222 C 123,581 - 123,581 C 28,445 - 28,445 C G 45,800 - - 45,800 C Q' d 2,172,530 311,388 275,734 1,896,796 13 2,781,828 41,487 - 2,781,828 C C 236,880 4,965 4,424 232,456 2 C 87,150 2,366 1,866 85,284 2 LL 26,880 - - 26,880 C 3,000 300 3,000 C p 29,900 468 - 29,900 C 1,428,736 - 4,494 1,424,242 C N 1,761,841 13,727 - 1,761,841 C �+ 100,900 2,762 - 100,900 C 7 C 200,998 10,963 13,305 187,693 7 50,000 - - 50,000 C 25,000 - 25,000 C C 0. 11,900 - 11,900 4) C w 76,340 5,089 17 76,323 C .� t� 759,700 - 759,700 C 5,360,378 - - 5,360,378 C C jL 10,578,596 482,583 364,887 10,213,709 3 s 6,847,783 353,267 281,015 6,566,768 r 4 C 35,634,329 736,167 658,837 34,975,492 2 1,985,870 - - 1,985,870 r C 04 1,292,815 90,505 135,027 1,157,788 1C 1,251,409 81,888 117,002 1,134,407 9 7 96,167 8,172 7,930 88,237 8 M n $ 118,861,486 $ 5,807,404 S 6,388,652 $ 112,472,834 5 }; .r Q 2 Packet Pg. 44 I 2.3.a I Page 1 of 3 Title TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMSPROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALES/USE TAX 3 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 PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT -COMCAST 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-VERIZON/FRONTIER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OT R NON -BUS LIC/PERMIT S INTERGOVERNMENTAL: 32 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 33 TARGET ZERO TEAMS GRANT 34 HIGH VISIBILITY ENFORCEMENT 35 CORONAVIRUS RELIEF FUND 2 36 DOC FAC ROOFING 37 STATE GRANTS- BUDGET ONLY 38 PUD PRIVILEDGE TAX 39 ARCHIVES AND RECORDS MANAGEMENT 40 CJ - POPULATION 41 TRIAL COURT IMPROVEMENT 42 CRIMINAL JUSTICE -SPECIAL PROGRAMS 43 MARIJUANA EXCISE TAX DISTRIBUTION 44 DUI - CITIES 45 LIQUOR EXCISE TAX 46 LIQUOR BOARD PROFITS 47 FIRST RESPONDERS FLEX FUND 48 DISCOVERY PROGRAMS TECHNOLOGY ACQ. C ITY O F IDMO NDS REVENUES - GENERAL FUND 2021 Adopted 1/31/2020 Budget Revenues 1/31/2021 Amount Revenues Remaining %Received $ 10,936,400 $ 38,921 $ 108,345 $ 10,828,055 1% 4,137,031 15,048 42,305 4,094,726 1% 500 (93) 1 499 0% 8,600,000 692,248 774,198 7,825,802 9% 7,600 698 500 7,100 7% 828,500 67,953 70,622 757,878 9% 1,710,000 179,486 192,356 1,517,644 11% 595,000 82,496 84,132 510,868 14% 364,000 31,041 27,563 336,437 8% 1,153,000 93,508 78,573 1,074,427 7% 894,600 79,154 80,611 813,989 9% 471,900 34,798 37,788 434,112 8% 722,000 68,728 67,310 654,690 9% 723,000 70,129 56,592 666,408 8% 55,200 18,305 21,500 33,700 39% 350 184 143 207 41% 295,900 - - 295,900 0% 31,494,981 1,472,606 1,642,539 29,852,442 5% 250 - 100 150 40% 700 40 - 700 0% 50,000 259 4,253 45,747 9% 702,700 173,761 170,449 532,251 24% 41,000 3,429 3,221 37,779 8% 100,600 - - 100,600 0% 434,000 79,538 - 434,000 0% 201,000 31,925 21,921 179,079 11% 58,700 5,230 7,190 51,510 12% 30,000 - 14,440 15,560 48% 650,600 56,046 31,022 619,578 5% 22,000 3,301 2,914 19,086 13% 50,000 50,481 2,280 47,720 5% 20,000 1,765 1,238 18,762 6% 2,361,550 405,775 259,027 2,102,523 11% 6,000 - 2,671 3,329 45% 4,000 - - 4,000 0% 7,100 - 417 6,683 6% - - 3,947 (3,947) 0% - - 379,270 (379,270) 0% 198,000 - - 198,000 0% 210,500 - 210,500 0% - 564 - - 0% 13,070 3,197 3,379 9,691 26% 16,740 4,038 - 16,740 0% 45,600 11,474 12,061 33,539 26% 60,000 - - 60,000 0% 4,500 1,383 1,667 2,833 37% 261,500 55,939 68,016 193,484 26% 343,200 - - 343,200 0% 2,000 1,812 2,000 0% 550 - - 550 0% 1,172,760 78,408 471,429 701,331 40% 3 2021 Local Retail Sales/Use Taxrevenues are $81,950 higher than 2020 revenues. Please also see pages pages 18 & 19 . 3 Packet Pg. 45 I 2.3.a I Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2021 Adopted 1/31/2020 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 CUSTODIAL SERVICES(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 DISTRICT #1 STATION BILLINGS 24 LEGAL SERVICES 25 ADULT PROBATION SERVICE CHARGE 26 BOOKING FEES 27 FIRE CONSTRUCTION INSPECTION FEES 28 EMERGENCY SERVICE FEES 29 EMS TRANSPORT USER FEE 30 FLEX FUEL PAYMENTS FROM STATIONS 31 ANIMAL CONTROL SHELTER 32 ZONING/SUBDIVISION FEE 33 PLAN CHECKING FEES 34 FIRE PLAN CHECK FEES 35 PLANNING 1 % INSPECTION FEE 36 S.E.P.A. REVIEW 37 CRITICAL AREA STUDY 38 GYM AND WEIGHTROOM FEES 39 PROGRAM FEES 4 40 TAXABLE RECREATION ACTIVITIES 41 WINTER MARKET REGISTRATION FEES 42 BIRD FEST REGISTRATION FEES 43 INTERFUND REIMBURSEMENT -CONTRACT SVCS 1/31/2021 Amount Revenues Remaining % Received $ 3,000 $ 554 $ 417 $ 2,583 140/( 600 21 11 590 20/( 11,000 1,342 437 10,564 40/( 150 - - 150 00/( 300 10 - 300 00/c - - 168 (168) 00/( 4,000 639 - 4,000 00/( 1,000 72 28 972 30/( 50 3 20 30 400/( 100 - - 100 00/( O 25,100 - - 25,100 00/( y 600 - - 600 00/, 1,000 14 - 1,000 00/( io 500 - - 500 00/( 200,000 12,630 6,640 193,360 3°/ tC 1,400 - - 1,400 0% 85,000 22,954 600 84,400 10/( LL 10,000 2,520 - 10,000 00/( 30,000 - - 30,000 00/( 41 76,800 36,753 - 76,800 00/( O 195,000 49,715 51,206 143,794 260/( 2 - 20 - - 00/ N 57,000 16,140 - 57,000 00/( c 04 1,050 25 28 1,022 30/( 38,000 3,606 3,576 34,424 9°/ to 3,000 206 45 2,955 10/( O 10,000 1,485 1,748 8,252 170/( 3,500 353 187 3,313 501( 1,007,500 - - 1,007,500 00/( 2,500 555 - 2,500 00/( O 50 - - 50 CL 00/( 65,600 13,740 6,910 58,690 110/( 350,900 23,846 99,215 251,685 280/( 4,000 5,157 809 3,191 200/( .v 500 - - 500 00/( 3,000 670 - 3,000 00/c 14,000 1,495 715 13,285 501( LL 15,500 1,482 - 15,500 00/, s 900,662 38,235 7,559 893,104 1% 55 1,300 - - 1,300 00x O z 5,000 - 185 4,815 40/( 800 - - 800 00/( N 2,892,106 90,609 101,192 2,790,914 30/( N 6,021,568 324,853 281,694 5,739,874 571, >, 4 2021 Parks & Recreation Program Revenues are $(30,677) lower than 2020 revenues. 4 Packet Pg. 46 1 2.3.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2021 Adopted 1/31/2020 1/31/2021 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 CRIMINAL TRAFFIC MISDEMEANOR 8/03 14 CRIMINAL CONVICTION FEE CT 15 CRIM CONV FEE CT 16 OTHER NON-T RAF MISDEMEANOR PEN 17 OTHER NON TRAFFIC MISD. 8/03 18 COURT DV PENALTY ASSESSMENT 19 CRIMINAL CONVICTION FEE CN 20 CRIM CONV FEE CN 21 PUBLIC DEFENSE RECOUPMENT 22 BANK CHARGE FOR CONV. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIESRENTALS 30 BRACKET ROOM RENTAL 31 LEASESLONG-TERM 32 DONATION/CONTRIBUTION 33 PARKSDONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHER JUDGEMENT/SETTLEMENT 40 POLICE JUDGMENTSiRESI'ITUTION 41 CASHIERS OVERAGES/SHORTAGES 42 OTHER MISC REVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - MUNICIPAL COURT 46 US BANK REBATE TRANSFERS -IN: 47 OPERATINGTRANSFER-IN 48 INTERFUND TRANSFER FROM FUND 018 49 TRANSFER FROM FUND 127 $ 2,000 $ 204 $ 244 $ 1,756 120/( 230,000 13,159 14,030 215,970 60% 18,000 809 946 17,054 50/c 10,000 1,089 1,154 8,846 120/( 1,000 - - 1,000 00/( 1,500 148 281 1,219 190/( 100,000 10,570 5,320 94,680 501( 2,000 272 - 2,000 0°/ 7,000 603 696 6,304 100/( 300 14 5 295 20/( 100 1 3 97 30/( 1,500 292 253 1,247 170/( 25,000 2,257 1,257 23,743 501( 2,000 220 151 1,849 80/( 700 17 13 687 20/( 100 9 - 100 00/( 10,000 (146) 298 9,702 3°/ 800 53 - 800 0°/ 1,000 73 1 999 00/c 200 4 7 193 30/( 8,000 492 205 7,795 30/( 14,000 1,061 757 13,243 501( 3,000 323 272 2,728 90/( 10,100 - - 10,100 00/( 150 - - 150 00/( 448,450 31,521 25,895 422,555 60% 155,090 35,988 40,842 114,248 260/( 9,980 1,281 755 9,225 80/( 3,400 364 835 2,566 250/( 153,000 5,314 183 152,817 00/( 2,100 200 - 2,100 00/( 205,000 17,584 16,215 188,785 80/( 2,500 58 - 2,500 00/( 3,500 300 - 3,500 00/( 2,000 - - 2,000 00/c 5,000 - - 5,000 00/( 300 - - 300 00/( 3,000 - - 3,000 00/( 2,000 - - 2,000 00/c 2,000 - - 2,000 0°/ 200 50 - 200 00/( - - 2 (2) 00/( 5,000 2,617 829 4,171 170/( 100 24 3 97 30/( 100 - 30 70 300/( 150 5 - 150 0°/ 8,500 - - 8,500 00/( 562,920 63,785 59,693 503,227 11% 238,667 - - 238,667 00/( 123,581 - - 123,581 00/( 26,300 - - 26,300 00/( 388,548 - - 388,548 00/( TOTAL GENERAL FUND REVENUE $ 42,450,777 $ 2,376,947 $ 2,740,276 $ 39,710,501 60% 5 Packet Pg. 47 I 2.3.a I Page I of 6 CITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining '%Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 17,135,234 $ 1,283,573 $ 1,472,550 $ 15,662,684 9 2 OVERTIME 485,080 43,391 50,514 434,566 10 3 HOLIDAY BUY BACK 281,329 - 1,951 279,378 1 4 BENEFITS 6,665,844 525,968 548,288 6,117,556 8 5 UNIFORMS 88,651 11,546 7,484 81,167 8 6 SUPPLIES 397,115 32,923 22,981 374,134 6 7 SMALL EQUIPMENT 106,603 20,535 1,281 105,322 1 8 PROFESSIONAL SERVICES 14,779,455 878,969 1,573,825 13,205,630 11 9 COMMUNICATIONS 159,495 1,845 5,878 153,617 4 10 TRAVEL 68,760 1,207 - 68,760 0 11 EXCISE TAXES 6,500 414 1,061 5,439 16 12 RENTAL/LEASE 1,574,465 155,815 123,212 1,451,253 8 13 INSURANCE 403,973 393,746 405,121 (1,148) 100 14 UTILITIES 536,762 42,334 36,889 499,873 7 15 REPAIRS & MAINTENANCE 917,742 99,939 82,644 835,098 9 16 MISCELLANEOUS 505,730 74,278 103,968 401,762 21 17 INTERGOVERNMENTAL PAYMENTS 50,000 75,000 50,000 - 100 18 INTERFUND SUBSIDIES 932,880 - - 932,880 0 19 MACHINERY/EQUIPMENT 23,120 - 844 22,276 4 20 GENERAL OBLIGATION BOND PRINCIPAL 54,530 - - 54,530 0 21 OTHER INTEREST & DEBT SERVICE COSTS 500 - 500 0 22 INTEREST ON LONG-TERM EXTERNAL DEBT 5,700 - 5,700 0 45,179,468 3,641,481 4,488,492 40,690,976 10 LEOFF-MEDICAL INS. RESERVE(009) 23 BENEFITS $ 206,650 $ 5,211 $ 15,899 $ 190,751 8 24 PENSION AND DISABILITY PAYMENTS 252,990 14,615 19,725 233,265 8 25 PROFESSIONAL SERVICES 7,000 - - 7,000 0 26 MISCELLANEOUS 500 - - 500 0 467,140 19,826 35,624 431,516 8 HISTORIC PRESERVATION GIFT FUND (014) 27 SUPPLIES $ 100 $ - $ - $ 100 0 28 PROFESSIONAL SERVICES 200 - 200 0 29 MISCELLANEOUS 5,600 - 5,600 0 5,900 - 5,900 0 BUILDING MAINTENANCEFUND (016) 30 INTERFUND SUBSIDIES $ 210,222 $ $ $ 210,222 0 210,222 210,222 0 EDMONDS HOMELESSNESS RESPONSEFUND (018) 31 PROFESSIONAL SERVICES $ 123,581 $ $ $ 123,581 0 123,581 123,581 0 EDMONDS OPIOID RESPONSEFUND (019) 32 INTERFUND SUBSIDIES $ 28,445 $ $ $ 28,445 0 28,445 28,445 0 DRUG ENFO RC EMENT FUND (104) 33 PROFESSIONAL SERVICES $ 45,000 $ $ $ 45,000 0 34 REPAIR/MAINT 800 800 0 45,800 45,800 0 .r Q 6 Packet Pg. 48 I 2.3.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent STREEI'FUND (111) 1 SALARIES AND WAGES $ 716,890 $ 56,318 $ 63,485 $ 653,405 9 2 OVERTIME 18,400 9,926 4,417 13,983 24 3 BENEFITS 378,236 28,971 30,344 347,892 8 4 UNIFORMS 6,000 - - 6,000 0 5 SUPPLIES 263,000 17,123 151 262,849 0 6 SMALL EQUIPMENT 20,000 - - 20,000 0 7 PROFESSIONAL SERVICES 23,210 452 3,505 19,705 15 8 COMMUNICATIONS 4,500 130 121 4,379 3 9 TRAVEL 1,000 - - 1,000 0 10 RENTAL/LEASE 247,270 19,063 20,471 226,799 8 11 INSURANCE 148,436 156,937 148,533 (97) 100 12 UTILITIES 280,918 18,654 2,775 278,143 1 13 REPAIRS & MAINTENANCE 52,000 3,814 - 52,000 0 14 MISCELLANEOUS 8,000 - 1,931 6,069 24 15 GENERAL OBLIGATION BOND PRINCIPAL 4,220 - - 4,220 0 16 INTEREST 450 - 450 0 $ 2,172,530 $ 311,388 $ 275,734 $ 1,896,796 13 COMBINED STREETCONST/1IMPROVE(112) 17 PROFESSIONAL SERVICES $ 1,560,378 $ - $ - $ 1,560,378 0 18 REPAIR & MAINTENANCE 88,670 - 88,670 0 19 MISCELLANEOUS - 8 - 0 20 INTERFUND SUBSIDIES 114,950 - 114,950 0 21 LAND 33,000 - 33,000 0 22 CONSTRUCTION PROJECTS 911,000 41,479 911,000 0 23 INTERGOVERNMENTAL LOANS 72,220 - 72,220 0 24 INTEREST 1,610 - 1,610 0 $ 2,781,828 $ 41,487 $ $ 2,781,828 0 MUNICIPAL ARTS ACQUIS. FUND (117) 25 SUPPLIES $ 4,700 $ - $ $ 4,700 0 26 SMALL EQUIPMENT 1,700 - 1,700 0 27 PROFESSIONAL SERVICES 221,500 4,046 3,812 217,688 2 28 TRAVEL 80 - - 80 0 29 RENTAL/LEASE 2,000 2,000 0 30 REPAIRS & MAINTENANCE 300 - - 300 0 31 MISCELLANEOUS 6,600 919 612 5,988 9 $ 236,880 $ 4,965 $ 4,424 $ 232,456 2 HO TEL/MO TEL TAX REVENUE FUND (120) 32 PROFESSIONAL SERVICES $ 83,150 $ 1,866 $ 1,866 $ 81,284 2 33 MISCELLANEOUS - 500 - - 0 34 INTERFUND SUBSIDIES 4,000 - - 4,000 0 $ 87,150 $ 2,366 $ 1,866 $ 85,284 2 EMPLO YEE PARIUNG PERMIT FUND (121) 35 SUPPLIES $ 1,790 $ - $ - $ 1,790 0 36 PROFESSIONAL SERVICES 25,090 - 25,090 0 $ 26,880 $ - $ $ 26,880 0 YOUTH SCHOLARSHIP FUND (122) 37 MISCELLANEOUS $ 3,000 $ 300 $ $ 3,000 0 $ 3,000 $ 300 $ $ 3,000 0 TO URISM PRO MO TIO NAL FUND/ARTS (123) 38 PROFESSIONAL SERVICES $ 29,900 $ 468 $ $ 29,900 0 $ 29,900 $ 468 $ $ 29,900 0 .r Q 7 Packet Pg. 49 I 2.3.a I Page 3 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ 121,000 $ - $ 4,494 $ 116,506 4 2 PROFESSIONAL SERVICES 148,000 - - 148,000 0 3 REPAIRS & MAINTENANCE 152,000 - 152,000 0 4 INTERFUND SUBSIDIES 190 - 190 0 5 CONSTRUCTION PROJECTS 1,007,546 - 1,007,546 0 $ 1,428,736 $ - $ 4,494 $ 1,424,242 0 REAL ESTATE EXC ISE TAX 1 (126) 6 PROFESSIONAL SERVICES 7 REPAIRS & MAINTENANCE 8 INTERFUND SUBSIDIES 9 CONSTRUCTION PROJECTS 10 GENERAL OBLIGATION BONDS 11 INTEREST GIFTS CATALOG FUND (127) 12 SUPPLIES 13 PROFESSIONAL SERVICES 14 MISCELLANEOUS 15 INTERFUND SUBSIDIES C EVIEIERY MAINTENANC UIMPRO VEMEVT (130) 16 SALARIES AND WAGES 17 OVERTIME 18 BENEFIT S 19 UNIFORMS 20 SUPPLIES 21 SUPPLIES PURCHASED FOR INVENTORY/RESALE 22 PROFESSIONAL SERVICES 23 COMMUNICATIONS 24 TRAVEL 25 RENTAL/LEASE 26 UTILITIES 27 REPAIRS & MAINTENANCE 28 MISCELLANEOUS PARKS TRUST FUND (136) 29 PROFESSIONAL SERVICES CEMETERY MAINTENANCE TRUST FUND (137) 30 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 31 SUPPLIES 32 TRAVEL 33 MISCELLANEOUS BUSINESS IMPROVEMEVTDISTRICTFUND (140) 34 SUPPLIES 35 PROFESSIONAL SERVICES 36 MISCELLANEOUS 2012 LTGO DEBT SERVIC FUND (231) 37 GENERAL OBLIGATION BOND 38 INTEREST $ 560,000 $ - $ $ 560,000 0 32,000 7,253 32,000 0 138,910 - 138,910 0 769,351 6,474 769,351 0 144,530 - 144,530 0 117,050 - 117,050 0 $ 1,761,841 $ 13,727 $ $ 1,761,841 0 $ 67,500 $ 2,762 $ $ 67,500 0 6,500 - 6,500 0 600 - 600 0 26,300 - 26,300 0 $ 100,900 $ 2,762 $ $ 100,900 0 $ 95,824 $ 6,938 $ 7,143 $ 88,681 7 3,500 - 30 3,470 1 40,472 3,050 3,177 37,295 8 1,000 - - 1,000 0 7,000 - - 7,000 0 20,000 150 627 19,373 3 4,200 - 800 3,400 19 1,700 139 140 1,560 8 500 - - 500 0 16,650 686 1,388 15,263 8 5,652 - - 5,652 0 500 - 500 0 4,000 - - 4,000 0 $ 200,998 $ 10,963 $ 13,305 $ 187,693 7 $ 50,000 $ - $ $ 50,000 0 $ 50,000 $ - $ $ 50,000 0 $ 25,000 $ $ $ 25,000 0 $ 25,000 $ - $ $ 25,000 0 $ 1,500 $ - $ $ 1,500 0 4,500 - 4,500 0 5,900 - 5,900 0 $ 11,900 $ - $ $ 11,900 0 $ 2,050 $ 4,388 $ $ 2,050 0 70,035 701 70,035 0 4,255 - 17 4,238 0 76,340 5,089 17 76,323 0 $ 677,990 $ - $ $ 677,990 0 81,710 - 81,710 0 $ 759,700 $ - $ $ 759,700 0 8 Packet Pg. 50 I 2.3.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 113,453 $ - $ $ 113,453 0 2 INTERFUND SUBSIDIES 44,000 - 44,000 0 3 CONSTRUCTION PROJECTS 5,202,925 - 5,202,925 0 $ 5,360,378 $ - $ $ 5,360,378 0 WATER FUND (421) 4 SALARIES AND WAGES 5 OVERTIME 6 BENEFIT S 7 UNIFORMS 8 SUPPLIES 9 WATER PURCHASED FOR RESALE 10 SUPPLIES PURCHASED FOR INVENTORY/RESALE 11 SMALL EQUIPMENT 12 PROFESSIONAL SERVICES 13 COMMUNICATIONS 14 TRAVEL 15 EXCISE TAXES 16 RENTAL/LEASE 17 INSURANCE 18 UTILITIES 19 REPAIRS & MAINTENANCE 20 MISCELLANEOUS 21 INTERFUND SUBSIDIES 22 CONSTRUCTION PROJECTS 23 GENERAL OBLIGATION BONDS 24 REVENUE BONDS 25 INTERGOVERNMENTAL LOANS 26 INTEREST STORM FUND (422) 27 SALARIES AND WAGES 28 OVERTIME 29 BENEFIT S 30 UNIFORMS 31 SUPPLIES 32 SMALL EQUIPMENT 33 PROFESSIONAL SERVICES 34 COMMUNICATIONS 35 TRAVEL 36 EXCISE TAXES 37 RENTAL/LEASE 38 INSURANCE 39 UTILITES 40 REPAIR & MAINTENANCE 41 MISCELLANEOUS 42 INTERFUND SUBSIDIES 43 CONSTRUCTION PROJECTS 44 GENERAL OBLIGATION BONDS 45 REVENUE BONDS 46 INTERGOVERNMENTAL LOANS 47 INTEREST $ 781,175 $ 75,363 $ 57,280 $ 723,895 7 24,000 1,208 1,468 22,532 6 325,765 28,144 23,617 302,148 7 4,000 - - 4,000 0 150,000 - 994 149,006 1 2,170,000 119,857 - 2,170,000 0 170,000 15,716 2,934 167,066 2 11,000 1,042 - 11,000 0 1,421,647 31,465 36,717 1,384,930 3 30,000 1,027 878 29,122 3 200 - - 200 0 1,649,700 121,017 109,183 1,540,517 7 124,630 10,784 10,086 114,544 8 97,844 52,541 98,196 (352) 100 35,775 2,745 2,079 33,696 6 258,130 12,967 10,211 247,919 4 123,600 8,707 11,242 112,358 9 644,130 - - 644,130 0 1,947,050 - 1,947,050 0 2,840 - 2,840 0 385,100 - 385,100 0 25,840 - 25,840 0 196,170 - - 196,170 0 $ 10,578,596 $ 482,583 $ 364,887 $ 10,213,709 3 $ 716,300 $ 51,356 $ 62,433 $ 653,867 9 6,000 2,700 1,395 4,605 23 316,335 25,827 27,072 289,263 9 6,500 396 20 6,480 0 46,000 - 969 45,031 2 4,000 - - 4,000 0 2,434,709 58,506 33,281 2,401,428 1 3,200 44 35 3,165 1 4,300 - - 4,300 0 470,100 38,496 42,906 427,194 9 267,778 25,465 21,872 245,906 8 66,216 116,576 66,228 (12) 100 11,025 1,418 1,636 9,389 15 64,130 12,967 10,211 53,919 16 232,300 16,246 12,959 219,341 6 281,810 - - 281,810 0 1,461,000 3,271 1,461,000 0 103,340 - 103,340 0 188,240 - 188,240 0 53,590 - 53,590 0 110,910 - - 110,910 0 $ 6,847,783 $ 353,267 $ 281,015 $ 6,566,768 4 9 Packet Pg. 51 I 2.3.a I Page 5 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 1,997,208 $ 160,318 $ 151,850 $ 1,845,358 8 2 OVERTIME 95,000 15,777 12,123 82,877 13 3 BENEFITS 863,464 76,692 65,060 798,404 8 4 UNIFORMS 8,500 1,891 267 8,233 3 5 SUPPLIES 404,000 21,331 13,736 390,264 3 6 FUEL CONSUMED 30,000 2,399 - 30,000 0 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 0 8 SMALL EQUIPMENT 35,000 5,465 1,468 33,532 4 9 PROFESSIONAL SERVICES 2,049,848 79,915 67,560 1,982,288 3 10 COMMUNICATIONS 43,000 1,431 1,086 41,914 3 11 TRAVEL 5,000 - - 5,000 0 12 EXCISE TAXES 968,000 91,033 93,839 874,161 10 13 RENTAL/LEASE 329,898 30,931 26,905 302,993 8 14 INSURANCE 160,967 174,140 162,851 (1,884) 101 15 UTILITIES 1,979,985 32,440 38,612 1,941,373 2 16 REPAIR & MAINTENANCE 520,630 35,574 12,679 507,951 2 17 MISCELLANEOUS 129,350 6,831 9,420 119,930 7 18 INTERFUND SUBSIDIES 8,657,681 - - 8,657,681 0 19 CONSTRUCTION PROJECTS 16,552,508 - 16,552,508 0 20 GENERAL OBLIGATION BONDS 157,060 - 157,060 0 21 REVENUE BONDS 86,670 - 86,670 0 22 INTERGOVERNMENTAL LOANS 173,900 - 173,900 0 23 INTEREST 382,660 - - 382,660 0 24 DEBT ISSUE COSTS - - 1 380 (1 380) 0 $ 35,634,329 $ 736,167 $ 658,837 $ 34,975,492 2 BOND RESERVEFUND (424) 25 REVENUE BONDS $ 785,020 $ - $ - $ 785,020 0 26 INTEREST 1,200,850 - 1,200,850 0 $ 1,985,870 $ - $ $ 1,985,870 0 Q 10 Packet Pg. 52 I 2.3.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent EQUIPMENTRENTAL FUND (511) 1 SALARIES AND WAGES $ 269,184 $ 22,831 $ 23,099 $ 246,085 9 2 OVERTIME 2,000 606 - 2,000 0 3 BENEFITS 115,681 9,923 9,450 106,231 8 4 UNIFORMS 1,000 31 41 959 4 5 SUPPLIES 120,000 4,008 2,862 117,138 2 6 FUEL CONSUMED 1,000 - - 1,000 0 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 258,000 6,359 5,128 252,872 2 8 SMALL EQUIPMENT 58,000 - 55 57,945 0 9 PROFESSIONAL SERVICES 46,750 445 ill 46,639 0 10 COMMUNICATIONS 3,000 121 121 2,879 4 11 TRAVEL 1,000 - - 1,000 0 12 RENTAL/LEASE 12,790 1,019 1,036 11,754 8 13 INSURANCE 40,910 40,270 39,334 1,576 96 14 UTILITIES 14,500 1,985 1,636 12,864 11 15 REPAIRS&MAINTENANCE 60,000 1,495 1,106 58,894 2 16 MISCELLANEOUS 12,000 - 1,487 10,513 12 17 MACHINERY/EQUIPMENT 277,000 1,412 49,560 227,440 18 $ 1,292,815 $ 90,505 $ 135,027 $ 1,157,788 10 TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 373,762 $ 25,102 $ 25,594 $ 348,168 7 19 OVERTIME 2,000 - 303 1,697 15 20 BENEFITS 126,557 8,542 8,848 117,709 7 21 SUPPLIES 5,000 - 226 4,774 5 22 SMALL EQUIPMENT 141,300 - 1,922 139,378 1 23 PROFESSIONAL SERVICES 171,460 - 1,016 170,444 1 24 COMMUNICATIONS 58,770 4,345 4,410 54,360 8 25 TRAVEL 1,500 - - 1,500 0 26 RENTAL/LEASE 7,400 374 367 7,033 5 27 REPAIRS & MAINTENANCE 302,660 39,671 74,316 228,344 25 28 MISCELLANEOUS 5,000 3,853 - 5,000 0 29 MACHINERY/EQUIPMENT 56,000 - - 56,000 0 $ 1,251,409 $ 81,888 $ 117,002 $ 1,134,407 9 FIR]IVIEN'S PENSION FUND (617) 31 BENEFITS $ 24,560 $ 2,969 $ 2,804 $ 21,757 11 32 PENSION AND DISABILITY PAYMENTS 70,407 5,202 5,127 65,280 7 33 PROFESSIONAL SERVICES 1,200 - - 1,200 0 $ 96,167 $ 8,172 $ 7,930 $ 88,237 8 TOTAL EXPENDITURE ALL FUNDS $ 118,861,486 $ 5,807,404 $ 6,388,652 $ 112,472,834 5 Q 11 Packet Pg. 53 2.3.a Page 1 of 1 C ITY O F EDMO NDS EXPENDPTURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2021 Adopted 1/31/2020 1/31/2021 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 $ 430,493 $ 23,825 $ 26,808 $ 403,685 6% 345,501 28,750 27,531 317,970 8% 807,176 68,346 75,120 732,056 9% 1,157,083 79,231 93,953 1,063,130 8% 750,555 83,447 78,859 671,696 11% 0. 1,104,378 148,549 137,736 966,642 12% � 936,480 49,883 69,941 866,540 7% 12,881,593 1,280,852 2,013,112 10,868,481 16% 11,917,523 887,236 992,942 10,924,581 8% C LL 1,211,100 40,001 43,221 1,167,879 4% t 3,419,119 241,446 219,157 3,199,962 6% r� 4,503,783 278,296 308,283 4,195,500 7% T_ 3,286,985 254,086 258,921 3,028,064 8% N N 2,427,699 177,532 142,909 2,284,790 6% cv $ 45,179,468 $ 3,641,481 $ 4,488,492 $ 40,690,976 10% C ITY O F EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2021 Adopted Budget 1/31/2020 Expenditures 1/31/2021 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 10,578,596 $ 482,583 $ 364,887 $ 10,213,709 3% STORM UTILITY FUND 6,847,783 353,267 281,015 6,566,768 4% SEWER/WWTP UTILITY FUND 35,634,329 736,167 658,837 34,975,492 2% BOND RESERVE FUND 1,985,870 - - 1,985,870 0% $ 55,046,578 $ 1,572,016 $ 1,304,739 $ 53,741,839 2% 12 Packet Pg. 54 Page 1 of 4 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2021 Adopted Budget 1/31/2020 Expenditures 1/31/2021 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES $ 199,052 $ 14,933 $ 17,347 $ 181,705 9% OVERTIME 1,000 - - 1,000 0% BENEFITS 118,713 7,675 8,436 110,277 7% SUPPLIES 2,000 49 - 2,000 0% PROFESSIONAL SERVICES 62,160 - 62,160 0% COMMUNICATIONS 3,000 - 3,000 0% TRAVEL 6,700 90 - 6,700 0% RENTAL/LEASE 12,368 1,078 1,024 11,344 8% REPAIRS/MAINTENANCE 500 - - 500 0% MISCELLANEOUS 25,000 25,000 0% $ 430,493 $ 23,825 $ 26,808 $ 403,685 6% OFFICEOFMAYOR SALARIES $ 229,512 $ 18,536 $ 19,125 $ 210,387 8% BENEFITS 85,243 8,844 7,039 78,204 8% SUPPLIES 1,500 54 - 1,500 0% PROFESSIONAL SERVICES 3,000 - 3,000 0% COMMUNICATION 1,400 - 1,400 0% TRAVEL 3,000 - - 3,000 0% RENTAL/LEASE 17,396 1,317 1,367 16,029 8% MISCELLANEOUS 4,450 - - 4,450 0% $ 345,501 $ 28,750 $ 27,531 $ 317,970 8% HUMAN RFS O URC ES SALARIES $ 387,048 $ 29,761 $ 32,894 $ 354,154 8% OVERTIME - - 121 (121) 0% BENEFITS 154,430 11,697 13,009 141,421 8% SUPPLIES 13,300 70 386 12,914 3% SMALL EQUIPMENT 300 - 198 102 66% PROFESSIONAL SERVICES 175,000 1,041 717 174,283 0% COMMUNICATIONS 1,550 - - 1,550 0% TRAVEL 1,500 - - 1,500 0% RENTAL/LEASE 36,102 2,557 2,923 33,179 8% REPAIR/MAINTENANCE 8,380 7,832 8,067 313 96% MISCELLANEOUS 29,566 15,388 16,806 12,760 57% $ 807,176 $ 68,346 $ 75,120 $ 732,056 9% MUNICIPAL C O URT SALARIES $ 643,567 $ 51,891 $ 62,317 $ 581,250 10% OVERTIME 800 19 5,621 (4,821) 703% BENEFITS 242,359 20,671 19,223 223,136 8% SUPPLIES 10,600 232 - 10,600 0% SMALL EQUIPMENT 1,000 - 1,000 0% PROFESSIONAL SERVICES 124,925 - 124,925 0% COMMUNICATIONS 3,550 - 3,550 0% TRAVEL 6,500 - - 6,500 0% RENTAL/LEASE 70,682 5,429 5,657 65,025 8% REPAIR/MAINTENANCE 4,880 - - 4,880 0% MISCELLANEOUS 25,100 989 1,135 23,965 5% MACHINERY/EQUIPMENT 23,120 23,120 0% $ 1,157,083 $ 79,231 $ 93,953 $ 1,063,130 8% 13 Packet Pg. 55 1 I 2.3.a I Page 2 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY CLERK SALARIES AND WAGES $ 391,926 $ 33,945 $ 33,306 $ 358,620 8% BENEFITS 168,469 14,324 14,985 153,484 9% SUPPLIES 7,000 266 403 6,597 6% PROFESSIONAL SERVICES 34,200 459 1,094 33,106 3% COMMUNICATIONS 33,000 - 4,000 29,000 12% TRAVEL 1,980 - - 1,980 0% RENTAL/LEASE 55,980 5,357 3,332 52,648 6% REPAIRS & MAINTENANCE 48,000 28,915 21,244 26,756 44% MISCELLANEOUS 10,000 181 494 9,506 5% $ 750,555 $ 83,447 $ 78,859 $ 671,696 11% FINANCE SALARIES $ 732,408 $ 72,777 $ 61,812 $ 670,596 8% OVERTIME 4,500 - - 4,500 0% BENEFITS 238,064 25,511 21,831 216,233 9% SUPPLIES 7,350 391 166 7,184 2% SMALL EQUIPMENT 2,650 - 73 2,577 3% PROFESSIONAL SERVICES 9,300 - 18 9,282 0% COMMUNICATIONS 2,000 - - 2,000 0% TRAVEL 3,100 - - 3,100 0% RENTAL/LEASE 55,176 4,857 5,297 49,879 10% REPAIR/MAINTENANCE 41,480 43,963 45,281 (3,801) 109% MISCELLANEOUS 8,350 1,051 3,258 5,092 39% $ 1,104,378 $ 148,549 $ 137,736 $ 966,642 12% CITY ATTO RNEY PROFESSIONAL SERVICES $ 936,480 $ 49,883 $ 69,941 $ 866,540 7% $ 936,480 $ 49,883 $ 69,941 $ 866,540 7% NON -DEPARTMENTAL SALARIES $ 101,750 $ - $ - $ 101,750 0% BENEFITS -UNEMPLOYMENT 50,000 84 8,868 41,132 18% SUPPLIES 5,000 195 - 5,000 0% PROFESSIONAL SERVICES 11,168,050 767,851 1,478,954 9,689,096 13% EXCISE TAXES 6,500 414 1,061 5,439 16% RENTAL/LEASE 6,366 1,689 532 5,835 8% INSURANCE 403,973 393,746 405,121 (1,148) 100% MISCELLANEOUS 96,344 41,874 68,576 27,768 71% CONTRIBUTION TO ECA 50,000 75,000 50,000 - 100% INTERFUND SUBSIDIES 932,880 - - 932,880 0% GENERAL OBLIGATION BOND 54,530 - 54,530 0% INTEREST ON LONG-TERM DEBT 5,700 - 5,700 0% FISCAL AGENT FEES 500 500 0% $ 12,881,593 $ 1,280,852 $ 2,013,112 $ 10,868,481 16% 14 Packet Pg. 56 1 2.3.a Page 3 of 4 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining �/, Spent POLICE SERVIC ES SALARIES $ 7,206,549 $ 514,591 $ 636,168 $ 6,570,381 9% OVERTIME 454,780 38,819 43,775 411,005 10% HOLIDAY BUYBACK 281,329 - 1,951 279,378 1% BENEFITS 2,819,711 215,970 225,810 2,593,901 8% UNIFORMS 78,426 11,050 7,216 71,210 9% SUPPLIES 86,500 5,234 6,326 80,174 7% SMALL EQUIPMENT 77,453 19,887 1,009 76,444 1% PROFESSIONAL SERVICES 122,220 9,509 15,299 106,921 13% COMMUNICATIONS 34,000 275 325 33,675 1% TRAVEL 29,310 1,075 - 29,310 0% RENTAL/LEASE 651,715 68,320 52,810 598,905 8% REPAIR/MAINTENANCE 15,180 907 979 14,201 6% MISCELLANEOUS 60,350 1,598 1,275 59,075 2% $ 11,917,523 $ 887,236 $ 992,942 $ 10,924,581 8% COMMUNITY S ERVIC ES /EC 0 N DEV. SALARIES $ 390,687 $ 21,050 $ 26,976 $ 363,711 7% BENEFITS 109,147 6,864 7,562 101,585 7% SUPPLIES 3,275 6,376 - 3,275 0% SMALL EQUIPMENT 800 - - 800 0% PROFESSIONAL SERVICES 660,400 4,250 5,500 654,900 1% COMMUNICATIONS 3,675 21 22 3,653 1% TRAVEL 2,000 - - 2,000 0% RENTAL/LEASE 21,116 982 1,625 19,491 8% REPAIR/MAINTENANCE 10,500 - - 10,500 0% MISCELLANEOUS 9,500 460 1,536 7,964 16% $ 1,211,100 $ 40,001 $ 43,221 $ 1,167,879 4% DEVELO PMENT SERVIC ES/PLANNING SALARIES $ 1,830,748 $ 140,364 $ 145,459 $ 1,685,289 8% OVERTIME 1,300 3,056 - 1,300 0% BENEFITS 680,921 53,307 54,939 625,982 8% UNIFORMS 500 - - 500 0% SUPPLIES 12,100 557 474 11,626 4% SMALL EQUIPMENT 7,300 648 - 7,300 0% PROFESSIONAL SERVICES 678,380 24,915 3,015 675,365 0% COMMUNICATIONS 9,000 - - 9,000 0% TRAVEL 7,300 42 - 7,300 0% RENTAL/LEASE 135,710 14,066 10,847 124,863 8% REPAIRS & MAINTENANCE 6,800 - - 6,800 0% MISCELLANEOUS 49,060 4,492 3,579 45,481 7% MACHINERY/EQUIPMENT - - 844 (844) 0% $ 3,419,119 $ 241,446 $ 219,157 $ 3,199,962 6% ENGINEERING SALARIES $ 1,773,720 $ 139,971 $ 144,364 $ 1,629,356 8% OVERTIME 5,000 891 408 4,592 8% BENEFITS 733,487 59,272 59,852 673,635 8% UNIFORMS 450 - - 450 0% SMALL EQUIPMENT 2,200 - 2,200 0% PROFESSIONAL SERVICES 13,840 - 13,840 0% COMMUNICATIONS 19,600 20 19,600 0% TRAVEL 600 - - 600 0% RENTAL/LEASE 146,935 11,030 11,799 135,136 8% REPAIR/MAINTENANCE 2,600 - - 2,600 0% MISCELLANEOUS 80,000 1,107 1,893 78,107 2% $ 2,778,432 $ 212,290 $ 218,316 $ 2,560,116 8% 15 Packet Pg. 57 I 2.3.a I Page 4 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DEr'AIL 2021 Adopted 1/31/2020 1/31/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS & REC REATIO N SALARIES $ 2,179,335 $ 150,486 $ 196,730 $ 1,982,605 9% OVERTIME 10,000 70 25 9,975 0% BENEFITS 804,577 61,215 69,709 734,868 9% UNIFORMS 6,275 255 203 6,072 3% SUPPLIES 127,890 11,759 5,942 121,948 5% SMALL EQUIPMENT 10,900 - - 10,900 0% PROFESSIONAL SERVICES 718,300 4,647 (963) 719,263 0% COMMUNICATIONS 31,370 347 358 31,012 1% TRAVEL 5,270 - - 5,270 0% RENTAL/LEASE 251,549 26,891 17,068 234,481 7% PUBLIC UTILITY 230,507 14,891 13,795 216,712 6% REPAIR/MAINTENANCE 29,700 596 - 29,700 0% MISCELLANEOUS 98,110 7,139 5,418 92,692 6% $ 4,503,783 $ 278,296 $ 308,283 $ 4,195,500 7% PUBLIC WORKS ADMINIS TRATIO N SALARIES OVERTIME BENEFITS SUPPLIES SMALL EQUIPMENT PROFESSIONAL SERVICES COMMUNICATIONS TRAVEL RENT AL/LEASE PUBLIC UTILITY REPAIR/MAINTENANCE MISCELLANEOUS FACILITIES MAINTENANCE SALARIES OVERTIME BENEFITS UNIFORMS SUPPLIES SMALL EQUIPMENT PROFESSIONAL SERVICES COMMUNICATIONS TRAVEL RENT AL/LEASE PUBLIC UTILITY REPAIR/MAINTENANCE MISCELLANEOUS TO TAL GENERAL FUND EXPENDITURES $ 296,962 $ 24,320 $ 24,948 $ 272,014 8% 200 - - 200 0% 106,203 8,940 8,267 97,936 8% 8,600 138 1 8,599 0% 1,000 - - 1,000 0% 200 5 7 193 4% 1,350 24 24 1,326 2% 500 - - 500 0% 84,320 7,997 6,927 77,393 8% 3,318 373 430 2,888 13% 1,000 - - 1,000 0% 4,900 4,900 0% $ 508,553 $ 41,796 $ 40,605 $ 467,948 8% 771,970 70,950 71,104 700,866 9% 7,500 536 564 6,936 8% 354,520 31,593 28,759 325,761 8% 3,000 241 65 2,935 2% 112,000 7,604 9,282 102,718 8% 3,000 - - 3,000 0% 73,000 16,409 244 72,756 0% 16,000 1,158 1,150 14,850 7% 1,000 - - 1,000 0% 29,050 4,245 2,004 27,046 7% 302,937 27,069 22,664 280,273 7% 748,722 17,726 7,073 741,649 1% 5,000 5,000 0% $ 2,427,699 $ 177,532 $ 142,909 $ 2,284,790 6% S 45,179,468 S 3,641,481 S 4,488,492 S 40,690,976 10% 16 Packet Pg. 58 2.3.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2021 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 2,288,254 $ 2,288,254 $ 2,740,276 19.75% February 4,615,700 2,327,446 March 7,110,111 2,494,410 April 10,178,867 3,068,757 May 18,381,821 8,202,954 June 20,794,250 2,412,429 July 23,089,086 2,294,836 August 25,626,204 2,537,118 September 27,892,507 2,266,303 October 31,761,425 3,868,919 November 40,124,213 8,362,788 December 42,450,777 2,326,564 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2021 Real Estate Excise Tax 1 & 2 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 195,748 $ 195,748 $ 625,840 219.72% February 341,557 145,810 March 525,343 183,786 April 697,989 172,646 May 895,413 197,424 June 1,120,061 224,648 July 1,335,075 215,015 August 1,581,214 246,138 September 1,849,736 268,522 October 2,083,774 234,038 November 2,308,787 225,013 December 2,500,000 191,213 *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 59 SALES TAX SUMMARY I 2.3.a I Sales Tax Analysis By Category Current Period: January 2021 Year -to -Date Total $774,198 Health & Personal Care, Automotive Repair, $24,118 1 $15,564 Construction Trade, $108,586 Accommodation, $1,817 Clothing and Accessories, $26,985 Communications, $20,829 Wholesale Trade, $37,746 Misc Retail, $158,008 1 10,000,000 8,000,000 $6,741,838 $6,905,122 6,000,000 4,000,000 2,000,000 0 2015 Amusement & Recreation, $3,363 Business Services, $77,563 Gasoline, $3,123 Retail Food Stores, k, $27,679 L Retail Automotive, 'M7$183,277 Manufacturing, $7,641 Others, $16,335 Eating & Drinking, $61,564 Annual Sales Tax Revenue $8,406,296 $8,452,715 $8,317,046 2017 2018 2019 2020 $774,198 YTD 2021 0 c c ii t w c 0 N O N L c V- 0 a a� c �a c ii 21 t c 0 N O N m r- m c d E R a 18 Packet Pg. 60 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2021 Sales and Use Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 661,963 $ 661,963 $ 774,198 16.95% February 1,491,081 829,118 March 2,110,825 619,744 April 2,677,870 567,045 May 3,379,279 701,409 June 4,038,220 658,941 July 4,756,025 717,805 August 5,547,915 791,890 September 6,288,480 740,565 October 7,063,515 775,035 November 7,866,501 802,986 December 8,600,000 733,499 City of'Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2021 Gas Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 82,557 $ 82,557 $ 84,132 1.91% February 170,654 88,097 March 250,947 80,292 April 317,447 66,501 May 368,586 51,139 June 403,108 34,522 July 430,884 27,777 August 454,299 23,415 September 475,121 20,822 October 498,594 23,472 November 537,295 38,702 December 595,000 57,705 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. O !Z N C flf C LL t C O N O N M 7 C tv O CL O U a M a E t r C O r N O N 7 C O 7 C E t U r Q 19 Packet Pg. 61 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2021 Telephone Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 69,351 $ 69,351 $ 56,592-18.40% February 138,426 69,074 March 199,085 60,660 April 265,909 66,823 May 325,636 59,728 June 385,177 59,540 July 443,946 58,770 August 501,501 57,554 September 557,882 56,382 October 615,320 57,437 November 665,999 50,679 December 723,000 57,001 Electric Utility Tax 800,000 Telephone 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 City of Edmonds, WA Monthly Revenue Summary -Electric Utility Tax 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 179,984 $ 179,984 $ 192,356 6.87% February 379,889 199,905 March 546,637 166,748 April 730,293 183,656 May 873,813 143,520 June 997,568 123,755 July 1,114,337 116,769 August 1,230,154 115,816 September 1,342,671 112,517 October 1,453,976 111,305 November 1,576,729 122,753 December 1,710,000 133,271 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 -0- Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. 20 Packet Pg. 62 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2021 Meter Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 779,311 $ 779,311 $ 785,708 0.82% February 1,323,513 544,201 March 2,123,378 799,865 April 2,634,733 511,355 May 3,397,533 762,799 June 3,993,888 596,356 July 4,928,107 934,219 August 5,728,520 800,414 September 6,831,863 1,103,343 October 7,628,547 796,684 November 8,538,589 910,042 December 9,090,825 552,236 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2021 Storm Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 384,276 $ 384,276 $ 377,845 6.87% February 1,216,009 831,732 March 1,599,504 383,495 April 1,939,303 339,799 May 2,323,204 383,901 June 2,663,931 340,727 July 3,048,086 384,154 August 3,880,066 831,980 September 4,263,771 383,706 October 4,604,458 340,687 November 4,988,465 384,006 December 5,316,477 328,012 Storm Water Sales 5,500,000 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 - 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --6-- Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. O Q N C f� C LL t C O N O N O 7 c O CL O U a M C LL t r C O N O N 7 C O n C E t U r Q 21 Packet Pg. 63 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2021 Unmeter Sewer Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast ActuaIs January $ 846,742 $ 846,742 $ 806,699 -4.73% February 1,539,036 692,295 March 2,387,119 848,083 April 3,078,705 691,586 May 3,923,269 844,563 June 4,616,005 692,736 July 5,485,907 869,902 August 6,180,993 695,086 September 7,065,967 884,974 October 7,769,759 703,792 November 8,630,384 860,626 December 9,319,928 689,544 O sZ d C f� C LL t C O N O N M 7 C O CL O U a M a IL z r C O r N O N 7 C M 7 C E t C� r Q *The monthly budget forecast columns are based on a five-year average. 22 Packet Pg. 64 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2021 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 4,763,692 $ 4,763,692 $ 4,488,492 -5.78% February 8,102,761 3,339,069 March 11,550,167 3,447,406 April 14,976,824 3,426,657 May 18,175,079 3,198,255 June 22,305,837 4,130,758 July 26,106,634 3,800,797 August 29,720,247 3,613,613 September 33,095,759 3,375,511 October 36,818,699 3,722,940 November 40,835,625 4,016,926 December 45,179,468 4,343,843 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2021 Non -Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,129,707 $ 2,129,707 $ 2,013,112 -5.479/, February 2,964,270 834,564 March 3,918,886 954,616 April 4,746,252 827,366 May 5,429,051 682,799 June 6,890,293 1,461,242 July 7,928,307 1,038,014 August 8,794,775 866,469 September 9,536,123 741,348 October 10,451,643 915,520 November 11,576,017 1,124,374 December 12,881,593 1,305,576 *The monthly budget forecast columns are based on a five-year average. 23 Packet Pg. 65 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2021 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 27,170 $ 27,170 $ 26,808 -1.33% February 57,559 30,389 March 91,021 33,462 April 121,761 30,741 May 162,400 40,639 June 211,053 48,653 July 245,137 34,084 August 292,412 47,276 September 331,547 39,135 October 355,831 24,284 November 391,926 36,095 December 430,493 38,567 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2021 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 28,543 $ 28,543 $ 27,531 -3.55% February 58,378 29,835 March 86,855 28,477 April 115,847 28,992 May 144,377 28,530 June 172,357 27,980 July 200,988 28,631 August 230,481 29,494 September 259,088 28,607 October 287,175 28,087 November 315,280 28,104 December 345,501 30,221 Office of Mayor 350,000.00 300,000.00 250,000.00 200,000.00 150,000.00 / 100,000.00 / 50,000.00 0.00 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - -PriorYear *The monthly budget forecast columns are based on a five-year average. O Q N C f� C LL t C O N O N O 7 C O iz O U a M c LL t r C O r N O N M 7 C O 7 C O E t U M r Q 24 Packet Pg. 66 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2021 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 70,645 $ 70,645 $ 75,120 6.33% February 133,817 63,171 March 194,869 61,053 April 253,374 58,505 May 314,638 61,264 June 389,004 74,366 July 447,996 58,992 August 509,552 61,556 September 577,098 67,546 October 640,237 63,138 November 705,461 65,225 December 807,176 101,715 Municipal Court Human Resources 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget Prior Year City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 87,732 $ 87,732 $ 93,953 7.09% February 183,658 95,926 March 277,088 93,430 April 372,050 94,962 May 474,182 102,132 June 564,520 90,338 July 657,862 93,341 August 754,726 96,864 September 848,582 93,856 October 947,082 98,500 November 1,039,678 92,596 December 1,157,083 117,405 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. 67 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2021 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 80,002 $ 80,002 $ 43,221-45.98% February 171,172 91,170 March 262,430 91,258 April 357,508 95,078 May 453,339 95,831 June 545,783 92,444 July 645,125 99,342 August 751,947 106,822 September 843,469 91,522 October 945,696 102,227 November 1,067,925 122,230 December 1,211,100 143,175 City of Edmonds, WA Monthly Expenditure Report -City Clerk 2021 City Clerk Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 72,647 $ 72,647 $ 78,859 8.55% February 132,803 60,156 March 194,510 61,706 April 259,653 65,143 May 319,306 59,653 June 377,113 57,807 July 440,842 63,728 August 507,499 66,657 September 562,881 55,383 October 619,955 57,074 November 686,148 66,192 December 750,555 64,407 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. O Q N C f� C LL t C O N O N O 7 C O O. O U C M c LL t r C O r N O N 7 C M n C O E t U M r Q 26 Packet Pg. 68 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2021 Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 136,016 $ 136,016 $ 117,002-13.98% February 289,014 152,998 March 384,228 95,214 April 451,482 67,254 May 540,191 88,709 June 631,052 90,861 July 710,229 79,177 August 802,445 92,216 September 897,442 94,997 October 980,269 82,826 November 1,061,491 81,223 December 1,251,409 189,918 Finance Technology Rental Fund 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 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 115,331 $ 115,331 $ 137,736 19.43% February 200,151 84,821 March 286,138 85,987 April 373,267 87,129 May 460,772 87,505 June 569,205 108,432 July 661,728 92,524 August 746,841 85,112 September 842,777 95,936 October 931,701 88,925 November 1,017,542 85,840 December 1,104,378 86,836 Finance 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 4 CPO` 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. O Q N C O C LL t C O N O N M 7 C O CL O U a M a LL t r C O r N O N 7 C O 7 C E t U M r Q 27 Packet Pg. 69 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2021 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 78,040 $ 78,040 $ 69,941-10.38% February 1S6,080 78,040 March 234,120 78,040 April 312,160 78,040 May 390,200 78,040 June 468,240 78,040 July 546,280 78,040 August 624,320 78,040 September 702,360 78,040 October 780,400 78,040 November 858,440 78,040 December 936,480 78,040 Police City Attorney 1,000,000 900,000 800,000 700,000 _100000- 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 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 925,403 $ 925,403 $ 992,942 7.30% February 1,886,416 961,013 March 2,829,982 943,566 April 3,782,981 952,999 May 4,725,632 942,651 June 5,729,411 1,003,779 July 6,736,463 1,007,052 August 7,660,147 923,684 September 8,630,143 969,996 October 9,691,161 1,061,018 November 10,910,020 1,218,859 December 11,917,523 1,007,503 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 Q *The monthly budget forecast columns are based on a five-year average. Z$ Packet Pg. 70 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2021 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 244,151 $ 244,151 $ 219,157-10.24% February 512,682 268,530 March 780,153 267,471 April 1,064,982 284,829 May 1,353,718 288,736 June 1,619,863 266,145 July 1,907,483 287,620 August 2,201,287 293,804 September 2,485,656 284,370 October 2,763,764 278,107 November 3,086,765 323,002 December 3,419,119 332,354 Parks &z Recreation Development Services 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 --0-- Current Yeaz Budget - Prior Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 304,498 $ 304,498 $ 308,283 1.24% February 620,652 316,154 March 956,699 336,047 April 1,305,795 349,096 May 1,666,114 360,320 June 2,028,272 362,158 July 2,484,241 455,969 August 3,009,180 524,938 September 3,435,053 425,873 October 3,799,710 364,658 November 4,117,176 317,466 December 4,503,783 386,607 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. 71 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Public Works Administration 2021 Public Works Administration Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 41,785 $ 41,785 $ 40,605 -2.82% February 84,383 42,598 March 126,606 42,223 April 169,031 42,425 May 211,539 42,508 June 254,896 43,358 July 298,440 43,543 August 340,623 42,183 September 382,623 42,000 October 423,711 41,088 November 465,344 41,633 December 508,553 43,209 Facilities Maintenance Public Works Administration 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 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 166,680 $ 166,680 $ 142,909-14.26% February 346,708 180,027 March 529,946 183,238 April 702,232 172,286 May 888,675 186,443 June 1,037,310 148,634 July 1,216,290 178,980 August 1,406,137 189,848 September 1,612,152 206,015 October 1,886,923 274,771 November 2,112,684 225,761 December 2,427,699 315,015 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. O Q N C O C LL t C O N O N O 7 c O CL O U a O a LL t r C O r N O N 7 C M 7 C E t C� r Q 30 Packet Pg. 72 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2021 Engineering Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 211,557 $ 211,557 $ 218,316 3.20% February 421,058 209,501 March 649,561 228,503 April 886,152 236,591 May 1,124,971 238,819 June 1,364,775 239,803 July 1,608,706 243,931 August 1,859,537 250,831 September 2,090,173 230,636 October 2,325,192 235,019 November 2,546,320 221,128 December 2,778,432 232,112 *The monthly budget forecast columns are based on a five-year average. 31 Packet Pg. 73 I 2.3.a I INVESTMENT PORTFOLIO SUMMARY Issuer Diversification Seattle WA Muni, 10% WA, 12% FFCB, City of Edmonds Investment Portfolio Detail As of January 31, 2021 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate First Financial CD 3,000,000 0.19 3,000,000 3,000,000 04/10/21 2.86% Port of Seattle WA Bonds 273,305 0.25 270,000 271,242 05/01/21 2.23% Grant Cnty WA Bonds 410,553 0.92 405,000 410,589 01/01/22 1.79% FFCB Bonds 1,998,548 1.37 2,000,000 2,047,512 06/14/22 1.88% Energy Northwest Bonds 1,466,077 1.41 1,345,000 1,437,079 07/01/22 5.00% Energy Northwest Bonds 260,748 1.41 250,000 259,118 07/01/22 2.95% Mason & Kitsap Cnty WA Bonds 948,084 1.83 855,000 928,906 12/01/22 5.00% Grant Cnty WA Bonds 1,517,955 1.92 1,500,000 1,534,905 01/01/23 1.54% Grant Cnty WA Bonds 576,332 1.92 520,000 568,038 01/01/23 5.00% Seattle WA Muni Bonds 2,224,500 2.00 2,000,000 2,193,220 02/01/23 5.00% FHLB Bonds 1,996,590 2.68 2,000,000 1,999,686 10/05/23 0.22% First Financial - ECA CD 2,803,516 2.79 2,803,516 2,803,516 11/15/23 2.08% Kent WA Bonds 286,648 2.83 250,000 284,008 12/01/23 5.00% Spokane County WA Bonds 259,075 3.84 250,000 264,913 12/01/24 2.10% First Financial - Waterfront Center CD 2,000,000 6.75 2,000,000 2,000,000 11/01/27 0.25% TOTAL SECURITIES 20,021,929 2.14 19,448,516 20,002,730 Washington State Local Gov't Investment Pool 24,409,886 24,409,886 Demand 0.14% Snohomish County Local Gov't Investment Pool 20,170,697 20,170,697 Demand 1.43% TOTAL PORTFOLIO $ 64,029,099 $ 64,583,313 Port of Kent WA, Seattle 1% Mason & Kitsap Cnty WA, 4% Grant Cnty J . 10% Energy FHLB, Spokane Northwest, 10% _ County 8% WA, 1% Fi rst Financial - CD, 40%4 Checking, Cash and Investment Balances $0.9 , 1%—__ (in $Millions) Bonds, $11.6, 18% State LGIP, CD's, $7.8, $24.4, 38% 12% County LGIP, I 32 Packet Pg. 74 1 I 2.3.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,306, 698 $1,200,000 $1,000,000 917 754 $970,550 $800,000 $653,690 $600,000 423,816 $400,000 $200,000 0 $123,799 $- 11 2016 2017 2018 2019 2020 YTD 2021 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% _ _ _ _ February April June August October December Maturity Distribution and Rate of Return $6,000,000 5.00% $ 5,000, 000 4.00% $4,000,000 3.00% $3,000,000 $2,000,000 2.00% $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. 75 2.3.a GENERAL FUND OVERVIEW CHANGE IN FUND BALANCES BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 1 /31 /2021 1 /31 /2021 Q1 YTD Fund Balance Cash Balance 001-General Fund " $ 8,843,662 $ 6,091,706 $ (1,748,216 009-Leoff-Medical Ins. Reserve 501,553 501,553 0 (35,624 0. 012-Contingency Reserve Fund 1,768,863 1,768,863 014-Historic Preservation Gift Fund 17,096 17,097 - .v 016-Building Maintenance 210,221 210,221 c 017 - Marsh Restoration & Preservation 864,616 864,616 - ii 018 - Edmonds Homelessness Response 123,581 123,581 - 019 - Edmonds Opioid Response 28,445 28,445 .r - 0 Total General Fund & Subfunds $ 12,358,037 $ 9,606,082 $ - $ (1,783,839 *$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. N N *$7,267,031of the fund balance in Fund 001 added to the $1,768,863 balance in Fund 012, represent the required 20% operating reserve. R 1` 0 GOVERNMENTAL FUNDS OVERVIEW 2 U U_ CHANGE IN FUND 2' FUND BALANCES BALANCES c GOVERNMENTAL ---- ACTUAL ---- 0 ---- ACTUAL ---- 2 FUNDS 1 /31 /2021 1 /31 /2021 Q1 YTD c Fund Balance Cash Balance N c� General Fund & Subfunds $ 12,358,037 $ 9,606,082 $ (1,783,839 c Special Revenue 10,330,042 9,928,663 542,384 Debt Service - - - m Capital Projects 5,980,832 5,987,481 11,093 t Total Governmental Funds $ 28,668,911 $ 25,522,226 1 $ - $ (1,230,362 43 Q *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. 76 2.3.a SPECIAL REVENUE FUNDS OVERVIEW FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- GOVERNMENTAL SPECIAL REVENUE 1/31/2021 1/31/2021 Q1 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 74,238 $ 74,352 $ 310 111 - Street Fund 830,465 834,529 (163,911 112- Combined Street Const/Improve 1,638,828 1,450,272 9,353 Q. 117 - Municipal Arts Acquis. Fund 679,521 679,521 (1,584 118 - Memorial Street Tree 20,258 20,258 84 120 - Hotel/Motel Tax Revenue Fund 61,926 61,926 2,127 Z 121 - Employee Parking Permit Fund 111,133 111,133 4,308 c 122 - Youth Scholarship Fund 13,854 13,854 58 ii 123 -Tourism Promotional Fund/Arts 79,414 79,415 1,560 2, 125 - Real Estate Tax 2 2,589,088 2,589,088 319,515 126 - Real Estate Excise Tax 1 2,326,313 2,326,312 322,781 0 127 - Gifts Catalog Fund 298,234 298,235 984 130 - Cemetery Maintenance/Improvement 213,556 213,555 8,730 0 136 - Parks Trust Fund 166,972 166,971 696 N, 137 - Cemetery Maintenance Trust Fund 1,094,366 1,094,366 6,911 m 138- Sister CityCommission 10,387 10,387 43 140 -Business Improvement Disrict 42,875 42,876 23,723 141 - Affordable and Supportive Housing Fd 78,441 78,441 6,696 142 - Edmonds Cares Fund 174 (216,826) - Q. Total Special Revenue $ 10,330,042 $ 9,928,663 1 $ - $ 542,384 *$200,000 of the fund balance in Fund 125 has been reserved for Marsh Restoration Funding. ENTERPRISE FUNDS OVERVIEW c LL O FUND BALANCES CHANGE IN FUND o ---- ACTUAL ---- ---- ACTUAL ---- N ENTERPRISE FUNDS 1/31/2021 1/31/2021 Q1 YTD Fund Balance Cash Balance 421 -Water Utility Fund $ 21,527,615 $ 5,344,238 $ 503,354 c m 422 - Storm Utility Fund * 9,922,344 4,389,179 639,502 E 423 - Sewer/WWTP Utility Fund 39,403,158 19,761,274 1,801,142 Q 424 - Bond Reserve Fund 843,962 843,974 1 411 -Combined Utility Operation 80 37,899 80 Total Enterprise Funds $ 71,697,158 $ 30,376,564 $ - $ 2,944,079 *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding. *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 35 Packet Pg. 77 2.3.a SUMMARY OVERVIEW CHANGE IN FUND FUND BALANCES BALANCES CITY-WIDE ---- ACTUAL ---- ---- ACTUAL ---- 1 /31 /2021 1 /31 /2021 Q1 YTD Fund Balance Cash Balance Governmental Funds $ 28,668,910 $ 25,522,226 $ (1,230,362 Enterprise Funds 71,697,158 30,376,564 2,944,079 0. Internal Services Fund 9,398,166 5,372,443 (30,850 am Agency Funds 112,185 112,185 (7,930 Total City-wide Total $ 109,876,420 $ 61,383,417 $ - $ 1,674,937 c ii t .r c 0 INTERNAL SERVICE FUNDS OVERVIEW N 0 N R 7 C R 7 FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- INTERNAL SERVICE FUNDS 1 /31 /2021 1 /31 /2021 Q1 YTD Fund Balance Cash Balance ii 511 - Equipment Rental Fund $ 8,474,401 $ 4,632,081 $ (17,085 >, t 512 -Technology Rental Fund 923,765 740,363 (13,766 c 0 Total Internal Service Funds $ 9,398,166 $ 5,372,443 $ - $ (30,850 N 0 N fC 3 C fC 7 C d E L V r Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 36 Packet Pg. 78 2.4 City Council Agenda Item Meeting Date: 03/9/2021 PFD Financial Presentation Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The Edmonds Public Facilities District, per our Contingent Loan Agreement, is to make periodic financial reports to Council. Staff Recommendation Presentation only, no action is necessary. Narrative: Staff from the EPFD will give a financial presentation to Council. Attachments: Edmonds PFD COE FC Packet 3-2021 Packet Pg. 79 42,4,a i �dmonds Public Facilities District Edmonds Public Facilities District/ Edmonds Center for the Arts Quarterly Presentation - Edmonds City Council Finance Committee Tuesday, March 9t'', 2021 Discussion Items: 1. Finance Report — Draft Year End 2020 (pp. 2-4) 2. Projected Budget - 2021 (p 5) 3. Cash Management — FY 2021— Tool Presentation (p 6) 4. Long-term financial outlook 5. Introduction to the refinancing effort for our 2012 Bonds Packet Pg. 80 Edmonds Public Facilities District eca �� Statement of Revenue, Expenses and Changes in Net Position (Income Statement) December, 2020 edmonds center for the arts Amounts in thousands Col Col Col Col Col Col Col Col Col Col 10 December, 2020 FAVORABLE Year To Date FAV. ACTUAL UNFAVORABLE FAV. ACTUAL ACTUAL BUDGET (UNFAV.) % VAR. LAST ACTUAL BUDGET (UNFAV.) % VAR. LAST VARIANCE YEAR VARIANCE YEAR Operating Revenues: $2 $27 $(25) -94% $38 1 Ticket Sales and Fees $107 $739 $(632) -86% $706 11 56 (45) -80% 75 2 Rentals 231 615 (384) -63% 608 - - - 3 3 Education and Outreach 15 58 (43) -74% 51 - 21 (21) -100% 11 4 Concessions 44 170 (126) -74% 140 269 51 218 425% 42 5 Contributions 1,206 1,170 36 3% 1,161 - 7 (7) -100% 1 6 Advertising 1 42 (41) -98% 21 0 10 (9) -95% 5 7 Historic Facility Preservation Fee 12 55 (43) -77% 52 - - - 9 8 Special Project Revenue 31 - 31 20 $282 $172 $110 64% $183 9 Total Operating Revenue $1,647 7,849 $(1,202) -42% $2,760 10 11 Operating Expenses: $14 $39 $25 65% $43 12 Artist Presentations and Theatre $96 $535 $439 82% $550 - 2 2 100% 2 13 Rentals 12 28 16 57% 28 1 6 4 77% 5 14 Advertising and Marketing 36 170 134 79% 157 2 - (2) 4 15 Education and Outreach 48 75 27 36% 72 2 3 1 37% 3 16 Development 60 93 33 36% 114 77 129 52 40% 94 17 Payroll and Employee Benefits 1,081 1,532 451 29% 1,490 7 14 7 50% 17 18 Facilities Maintenance and Utilities 125 159 34 21% 180 0 1 1 100% 1 19 Minor Equipment 1 12 11 94% 10 - (1) (1) -100% 4 20 Concessions and Merchandise 16 40 24 60% 36 1 6 5 88% - 21 Insurance, Audit, and Legal 43 102 60 58% - - - - 6 22 Special Project Expense 32 - (32) 27 16 7 (9) -133% (7) 23 Supplies and Other 158 103 (56) -54% 196 $120 $206 $86 42% $172 24 Total Operating Expenses $1,707 $2,849 $1,142 40% $2,860 25 $163 $(34) $197 577% $12 26 OPERATING SURPLUS (LOSS) $(60) $0 $(60) -80678% $(100) 27 28 Non -Operating Revenue and (Expenses): $56 $56 $(0) 0% $61 29 Intergovernmental Revenue $916 $867 $49 6% $824 23 - 23 6 30 Grant Revenue Capital Related 112 178 (66) -37% 175 0 0 (0) -75% 0 31 Interest Earned 1 2 (1) -70% 3 - 1 (1) -100% (0) 32 Gain (Loss) on Stock Sold 0 2 (2) -99% 1 (13) (22) 9 41% (9) 33 Interest Expense (166) (180) 14 8% (182) - (51) 51 100% (107) 34 Depreciation (575) (614) 39 6% (680) $66 $(16) $82 525% $(50) 35 Total Non -Operating Surplus (Loss) $288 $254 $34 13% $142 36 $229 $(50) $279 561% $(38) 37 TOTAL NET SURPLUS (LOSS) $228 $254 $(26) -10% $42 Col 11 ANNUA BUDGE 12 MO. O TOTAL O C O $73 61 G rn 17 a 1,17 4 .v F � c $2,84 a LL IL $53 T_ 2 N 0 17 N 7 o Y 1,53 15 11 1 V LL 4 Lu 10 O U 10 0 $2,84 11 to $ O E Lu $86 +% 17 (D E t U (18 (61 Q $25 $25 PFD ECA FINST 12-2020 IS 1 of 4 Packet Pg. 81 1 /21 /2021 9:49 AM Edmonds Public Facilities District pca I/ Statement of Net Position (Balance Sheet) edmo ds -te, f�'rth, � is December, 2020 Amounts in thousands December 2020 ASSETS: Current Assets: Cash and Cash Equivalents - Unrestricted $104 Cash and Cash Equivalents - Restricted for Debt Service 92 Cash and Cash Equivalents - Facility Restricted 46 Cash and Cash Equivalents - Special Projects 1 Receivables from Customers 12 Pledges Receivables from Donors 114 Receivables from Other Governments 165 Inventories 6 Prepayments 60 Total Current Assets $599 Property, Plant and Equipment Land $3,445 Buildings and renovations 14,607 Equipment and technology 636 Construction in Progress 143 subtotal PPE $18,830 Accumulated Depreciation (8,340) Total PPE, net $10,490 Deferred Pension Asset $148 Total Assets $11,237 LIABILITIES: Current Liabilities: Accounts Payable $118 Payroll and Benefits Payable 51 Compensated Absences Liability $36 Unearned Ticket and Other Unearned Revenue 466 Customer Deposits Liabilities 28 Accrued Interest 33 Current Portion of Long -Term Debt 300 Total Current Liabilities $1,032 Long Term Debt: First Financial NW Bank (2018 note payable from refinancing) $2,243 Contractual Obligation to the City of Edmonds (2012 bonds) 2,585 Loan Payable to the City of Edmonds 1,206 Note Payable to DanSound (Equip loan) 8 Total Long -Term Debt $6,042 Non Current Libilities: Pension Liability Deferred Pension Libility Total Noncurrent Liabilities Total Liabilities Net Position: Net Investment in Capital Assets Restricted Unrestricted accumulated surplus/(deficit) Total Net Position Total Liabilities and Net Position PFD ECA FINST 12-2020 BS 346 195 $541 $7,615 $4,149 985 (1,512) $3,622 $11,237 2 of 4 December 2019 $78 65 40 28 53 90 79 6 37 $476 $3,445 14,618 636 2 $18,701 (7,724) $10, 976 $148 $11,600 $237 87 $36 471 38 5 679 $1,553 $2,243 2,585 1,206 27 $6,061 346 195 $541 $8,155 $4,237 507 (1,298) $3,446 $11,600 2.4.a BS December 2019 (Last Year End) $78 65 40 28 53 90 79 6 37 $476 $3,445 14,618 636 2 $18, 701 (7,724) $10, 976 $148 $11,600 $237 87 $36 471 38 5 679 $1,553 $2,243 2,585 1,206 27 $6,061 346 195 $541 $8,155 4,237 507 (1,298) $3,446 $11,600 Packet Pg. 82 1/21/2021 9:49 AM 2.4.a eca F/ Edmonds Public Facilities District December, 2020 Graphs of Financial Statistics OPERATING SURPLUS (LOSS) $300 $250 $200 v $150 w e $100 E50 $- $(50) $(100) $(150) J F M A M J J A S O N D ■ Actual ■ Budget ■ Last Year CASH BALANCES $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $- J F N D +Actual 2020 (Last Year 2019 GRAPHS TOTAL OPERATING EXPENSES $400 $300 L C N o $200 t F $100 $-- K F M A M J J A S O N D ■ Actual ■ Budget ■ Last Year TOTAL NET SURPLUS (LOSS) $300 $250 $200 v $150 e o$100 $50 $- $(50) $(100) E(150) J F M A M J J A S O N D ■ Actual ■ Budget ■ Last Year TOTAL LONG-TERM DEBT $7,600 $7,400 $7,200 $7,000 a o $6,800 $6,600 $6,400 $6,200 $6,000 $5,800 J F r N D +Actual -2020 (Last Year 2019 C 3 O U O bd O d U) O L a tC U C tC C LL 0 LL IL T— N O N M tU Y V M a U LL UJ 0 U 0 LL a C O E LLJ C E t U tt3 Q Packet Pg. 83 1I21I2021 9:49AM 2.4.a Edmonds Public Facilities District / Edmonds Center for the Arts OPERATING BUDGET: FY 2021 Sept 2021 Active Status Year End Year End Year End Budget Projected YE Budget % Change 2017 2018 2019 2020 2020 2021 YE 19 vs 20 OPERATING REVENUES: Fav/-Unfav 1 Ticket Sales & Fees $ 762,000 $ 660,000 $ 706,000 $ 739,000 $ 104,000 $ 284,000 -578.3% 2 Rentals 605,000 609,000 611,000 615,000 224,000 257,000 -173.2% 3 Education & Outreach 42,000 45,000 51,000 58,000 15,000 17,000 -241.6% 4 Concessions 140,000 137,000 140,000 170,000 44,000 64,000 -217.8% 5 Contributions 935,000 1,125,000 1,178,000 1,170,000 1,126,000 965,000 -4.6% 6 Advertising / Other 84,000 14,000 21,000 42,000 1,000 26,000 -2048.7% 7 Facilities Preservation Fee - 50,000 52,000 55,000 11,000 23,000 -368.0% 8 Total Operating Revenue $ 2,568,000 $ 2,640,000 $ 2,759,000 $ 2,849,000 $ 1,525,000 $ 1,636,000 OPERATING EXPENSES: 9 Artist Presentations & Theatre $ 579,000 $ 527,000 $ 550,000 $ 535,000 $ 84,000 $ 248,000 558.3% 10 Rental $ - 33,000 39,000 28,000 12,000 12,000 225.2% 11 Advertising & Marketing 229,000 168,000 72,000 170,000 41,000 65,000 75.1% 12 Education & Outreach 69,000 69,000 120,000 75,000 40,000 4,000 199.4% 13 Development 99,000 99,000 157,000 93,000 54,000 65,000 188.7% 14 Payroll, Taxes & Employee Benefits 1,244,000 1,308,000 1,464,000 1,532,000 1,044,000 923,000 40.3% 15 Facilities Maintenance & Utilities 167,000 168,000 189,000 159,000 107,000 121,000 76.4% 16 Contracted Services 42,000 14,000 9,000 - 1,000 - 1447.7% 17 Supplies & Other Operating Expenses 271,000 249,000 260,000 257,000 194,000 195,000 33.8% 18 Total Operating Expenses $ 2,700,000 $ 2,635,000 $ 2,860,000 $ 2,849,000 $ 1,605,000 $ 1,633,000 TOTAL OPERATING INCOME (LOSS) $ (132,000) $ 5,000 $ (101,000) $ - $ (80,000) $ 3,000 26.5% NON - OPERATING REVENUE (EXPENSE): 19 Intergovernmental Revenue $ 672,000 $ 788,000 $ 825,000 $ 867,000 $ 873,000 $ 848,000 5.5% 20 Debt Service Interest Expense (215,000) (199,000) (182,000) (180,000) (168,000) (180,000) 8.3% 21 Interest Earned 3,000 7,000 2,000 2,000 - 2,000 -6766.3% 22 Other Income 25,000 493,000 175,000 178,000 181,000 125,000 -3.4% 23 Loss/Gain on Stock Realized 1,000 - 1,000 2,000 - 2,000 -2832.8% 24 TOTAL NON -OPERATING INCOME (LO: $ 486,000 $ 1,089,000 $ 821,000 $ 869,000 $ 886,000 $ 797,000 0.0% 25 Depreciation and Amortization (632,000) $ (599,000) (680,000) (614,000) (630,000) (630,000) 7.9% 26 TOTAL NET INCOME (LOSS) $ (278,000) $ 495,000 $ 40,000 $ 255,000 $ 176,000 $ 170,000 324.0% Packet Pg. 84 2.4.a EPFD/ECA MONTHLY CASH FLOW PROJECTIOSN FOR 2021 SUMMARY VIEW ACTUAL PROJECT PROJECT PROJECT PROJECT PROJECT PROJECT PROJECT PROJECT PROJECT PROJECT PROJECT Line Main category JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Column 1 2 3 4 5 6 7 8 9 10 11 12 13 1 OPERATING ACTIVITIES v 2 Revenues/receipts 3 3 Presented Events - - - - - - - 5,000 5,000 10,000 10,000 10,000 40,000 V 4 Rentals 16,860 30,000 30,000 10,000 10,000 10,000 10,000 10,000 39,250 39,250 39,250 39,250 283,860 O 5 Contributions -City of Edmonds, Hazel Miller, Rick Steves - 50,000 50,000 - - - - - - - - 85,000 185,000 6 Contributions -Substitute for Center Stage - - 50,000 - - - - 50,000 0 O 7 Contributions -Gala - - - - - 10,000 40,000 208,700 - - 258,700 ' cc 8 Contributions -all other 66,558 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 10,000 30,000 115,558 C 9 Grants -Snohomish LTAC 1st year commitment - - 100,000 - - - - - - - - - 100,000 N 30 Grants -Other 16,000 8,000 2,000 2,000 7,600 7,600 7,600 - - 50,800 N 11 Special Donor Pandemic Contributions - - - - - - - - 60,000 70,000 70,000 70,000 L 270,000 a 12 Shuttered Venue Operating Grant/Fed Gov/SBA - - - - - 13 Additional COE Grant funded by Fed Gov't support to COE V 14 Other Cash items (used to balance to ending cash for actuals - - - - - - - - - - - - - R 15 Total Revenues/receipts A=sum 2..14 99,418 89,000 183,000 13,000 11,000 61,000 11,000 33,600 152,850 336,550 129,250 234,250 1,353,918 C 16 - LL 17 Expenses/Disbursements a LL 18 Mo Payroll, taxes, benefits 69,500 65,000 65,000 65,000 65,000 65,000 65,000 65,000 130,000 130,000 130,000 130,000 1,044,500 d .... 19 Other Recurring Monthly expenses (eg. Util, Maint, Supplies) 36,555 36,930 36,930 36,930 36,930 36,930 36,930 36,930 46,930 46,930 46,930 46,930 482,782 20 Presented Events Expense/ Once opened Sept 1 onward - - - - - - - - 62,450 62,450 62,450 62,450 249,800 N 21 Unidentified Items 3,000 3,000 CD 22 Other Cash items (used to balance to ending cash for actuals M 23 Total Expenses/disbursements B=sum 18..22 109,055 101,930 101,930 101,930 101,930 101,930 101,930 101,930 239,380 239,380 239,380 239,380 1,780,082 24 Y t1 25 Net Increase Cash (Revenues less Expenses) C=A+B (9,637) (12,930) 81,070 (88,930) (90,930) (40,930) (90,930) (68,330) (86,530) 97,170 (110,130) (5,130) (426,164 <C 26 Transfer in/(out) from Non Operating D - - - - 18,356 40,930 90,930 68,330 86,530 - 12,960 - 318,034 CL 27 Cash balance end of period E=C+D+pr mo bal 94,363 81,433 162,504 73,574 1,000 1,000 1,000 1,000 1,000 98,170 1,000 (4,130) LL 28 LV 29 NON OPERATING (Sales Tax Revenue and Debt Service Payments) O V 30 Sales Taxes 58,636 52,994 177,994 52,994 52,994 52,994 52,994 52,994 177,994 52,994 52,994 52,994 891,570 31 Debt Payments Interest - - (18,924) - (26,546) (18,924) - - (18,924) - (26,546) (18,924) (128,787 in 32 Principal Payment - - - - - - - - - - (400,000) (280,361) (680,361 d 33 Net Increase (Decrease) cash non operating F=sum29..31 58,636 52,994 159,070 52,994 26,448 34,070 52,994 52,994 159,070 52,994 (373,552) (246,291) 82,422 34 C 35 Transfer in/(out) from Operating G - - - - (18,356) (40,930) (90,930) (68,330) (86,530) - (12,960) (318,034 0 36 Cash balance end of period H=F+G+pr mo ba 129,545 182,539 341,609 394,603 402,695 395,836 357,900 342,564 415,105 468,099 81,587 (164,704) - -0 37 W 38 Total Operating and Debt Service Cash at end of Month E+H 223,908 263,972 504,113 468,177 403,695 396,836 358,900 343,564 416,105 566,269 82,587 (168,834) +' C 39 G� 40 E t 41 POTENTIAL INITIATIVES TO ELIMINATE NEGATIVE CASH POSITION (Not included in above) V 42 Shuttered Venue Operating Grant - 200,000 200,000 43 Additional C of E Grant funded by Fed Gov't support to COE 100,000 - 100,000 Q 44 Defer NWFFB Principal payment due 12/31/21 to end of loan in 2030 - 280,352 280,352 45 Sale of 2012 Bonds 400,000 400,000 46 Increased 2021 Fundraising Performance beyond $595K - - Packet Pg. 85