Loading...
2022-09-13 City Council - Full Agenda-32621. Op E D o Agenda Edmonds City Council tnl. }nyo FINANCE COMMITTEE CITY COUNCIL CONFERENCE ROOM 121 - 5TH AVENUE N, EDMONDS, WA 98020 SEPTEMBER 13, 2022, 5:30 PM COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. PERSONS WISHING TO ATTEND THIS MEETING VIRTUALLY IN LIEU OF IN -PERSON ATTENDANCE CAN CLICK ON OR PASTE THE FOLLOWING ZOOM MEETING LINK INTO A WEB BROWSER USING A COMPUTER OR SMART PHONE: HTTPS://ZOOM. US/J/95798484261 OR JOIN BY DIAL -UP PHONE: US: +1 253 215 8782 WEBINAR ID: 957 9848 4261 STAFF AND COUNCILMEMBERS ATTEND COMMITTEE MEETINGS VIRTUALLY, AND MEMBERS OF THE PUBLIC ARE ENCOURAGED TO ATTEND THE SAME WAY. IF MEMBERS OF THE PUBLIC CANNOT ACCESS THE VIRTUAL COMMITTEE MEETINGS WITH THEIR PERSONAL DEVICES, A MONITOR IS PROVIDED ON CITY COUNCIL COMMITTEE NIGHTS FROM 430- 930 PM AT THE CITY COUNCIL CONFERENCE ROOM AT 150 5TH AVE N, EDMONDS WA. COMMITTEE MEMBERS: DIANE BUCKSHNIS (CHAIR), WILL CHEN, COUNCIL PRESIDENT (EX-OFFICIO MEMBER) CALL TO ORDER COMMITTEE BUSINESS 1. 2022 September Budget Amendment (20 min) 2. ARPA Program Status Report (20 min) 3. July 2022 Monthly Financial Report (10 min) 4. Employee Expense Reimbursement Policy (10 min) 5. 2020 Audit Follow-up Actions (20 min) 6. Risk Management Policy (20 min) 7. Business Improvement District - Collections Update (10 min) ADJOURN Edmonds City Council Agenda September 13, 2022 Page 1 2.1 City Council Agenda Item Meeting Date: 09/13/2022 2022 September Budget Amendment Staff Lead: Dave Turley Department: Administrative Services Preparer: Marissa Cain Background/History Amend the 2022 Ordinance No. 4270 Staff Recommendation Staff recommends that Finance Committee review the attached budget amendment ordinance and place on full council agenda for September 20. Attachments: 2022 September Decision Package Exhibits 2022 September Budget Amendment Ordinance Packet Pg. 2 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: This request is for additional funds needed to continue Temporary staffing to cover the workload while a person is on administrative leave. Because this is paid leave, we do not have salary savings to offset this expenditure. Finance hired a temporary consultant through Robert Half starting full-time at $60 per hour. The City has a standing contract with Robert Half. In April, Council approved a budget amendment which allowed for a consultant for three months, at a weekly rate of $2,400 ($60 per hour X 40 hours). We would like to ask for additional budget to be able to keep this person for another four months, through the end of 2022. Department: Administrative Services Fund Name: 001 GENERAL Division: Finance Title: Temporary Staff Preparer: Dave Turley Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance One -Time Operating Account Number Description 2022 2023 2024 2025 2026 001.000.31.514.23.41.00 Professional Services $ 40,800 $ - $ - $ - $ - Total Expenditure Increase (Decrease) $ 40,800 $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ 40,800 $ - $ - $ - $ - Total Ending Fund Balance Increase Decrease $ 40,800 $ - $ - $ - $ - Packet Pg. 3 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: Many city public meetings, including meetings of boards and commissions, are being carried out primarily remotely, using the Zoom platform. For all public meetings, including those primarily over Zoom, the city is required to provide a physical location for people to attend the meeting. For the last several months we have utilized a room at the Waterfront Center for this purpose, but this room is no longer available. We would like to convert the two offices in the South East corner of the first floor of City Hall into a room that can be used for this purpose for a longer term basis. For this to be optimal, we would like to combine two offices, paint the room and make some minor repairs, and add a small amount of technological equipment to make this a functional meeting room. Department: Administrative Services Finance Fund MULTIPLE FUNDS Division: Title: Building modification Name: Dave Turlev Prenarer: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider OEM 100% Ending Fund Balance One -Time Operating JIL Account Number Description 2022 2023 2024 2025 2026 001.000.66.518.30.48.00 Repair and Maintenance $ 25,000 $ - $ - S - $ - 512.000.31.594.18.64.00 IS Equipment $ 5,000 - - - - Total Expenditure Increase Decrease $ 30,000 $ - $ - S - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 512.000.333.21.019.00 Coronavirus Relief Fund / Technology $ 5,000 S - $ - S Total Revenue Increase Decrease $ 5,000 $ - $ - S Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ 25,000 $ - $ - S - $ - Total Ending Fund Balance Increase Decrease $ 25,000 $ - $ - S Packet Pg. 4 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: This adjustment moves the cost of software for public records requests between departments. GovQA historically charged to different departments will be paid by Information Services and charged back to Departments. This is an accounting change with a net -zero cost. Department: Information Services Division: Administrative Services Fund MULTIPLE FUNDS Title: Public record request system maintenance Name: Preparer: Brian Tuley Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance On -Going Operating Fill out on -going costs & revenues Account Number Description 2022 2023 2024 2025 2026 512.000.31.518.88.48.00 IS REPAIR & MAINTENANCE $ 27,950 $ 27,950 $ 27,950 $ 27,950 $ 27,950 001.000.31.514.31.48.00 CITY CLERK REPAIR & MAINTENANCE $ (27,950) $ (27,950) $ (27,950) $ (27,950) $ (27,950) Total Expenditure Increase (Decrease) $ - $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ 27,950 $ - $ - $ - $ - 512.000.39.508.00.00.00 Ending Fund Balance 27,950 - - - - Total Ending Fund Balance Increase Decrease $ - $ - $ - $ - $ - Packet Pg. 5 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: Microsoft office 365 uses a subsection -based pricing model. The City subscription contract go through an annual review process termed a "true -up" which audits user counts versus licensing. Increasing staff and committee group numbers requires additional licensing. This decision package provides for the increased license counts need to cover existing user levels. Department: Information Services Division: Administrative Services Fund MULTIPLE FUNDS Title: Increases in Microsoft license counts and costs Name: Preparer: Brian Tuley Budget Amendment Type New Item For Council To Consider Date of Discussion or Budget Approval? How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? On -Going Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Fill out on going costs & revenues Account Number Description 2022 2023 2024 2025 2026 512.000.31.518.88.48.00 IS REPAIR & MAINTENANCE $ 18,760 $ 18,760 $ 18,760 $ 18,760 $ 18,760 001.000.62.524.20.45.11 INTERFUND RENTAL $ 381 $ 381 $ 381 $ 381 $ 381 001.000.31.514.31.45.11 INTERFUND RENTAL $ 339 $ 339 $ 339 $ 339 $ 339 001.000.61.557.20.45.11 INTERFUND RENTAL $ 5,888 $ 5,888 $ 5,888 $ 5,888 $ 5,888 001.000.11.511.60.45.11 INTERFUND RENTAL $ 466 $ 466 $ 466 $ 466 $ 466 001.000.23.512.51.45.11 INTERFUND RENTAL $ 42 $ 42 $ 42 $ 42 $ 42 001.000.62.524.10.45.11 INTERFUND RENTAL $ 333 $ 333 $ 333 $ 333 $ 333 001.000.67.518.21.45.11 INTERFUND RENTAL $ 890 $ 890 $ 890 $ 890 $ 890 001.000.31.514.23.45.11 INTERFUND RENTAL $ 339 $ 339 $ 339 $ 339 $ 339 001.000.39.522.20.45.11 INTERFUND RENTAL $ 169 $ 169 $ 169 $ 169 $ 169 001.000.22.518.10.45.11 INTERFUND RENTAL $ 212 $ 212 $ 212 $ 212 $ 212 001.000.21.513.10.45.11 INTERFUND RENTAL $ 127 $ 127 $ 127 $ 127 $ 127 001.000.64.571.22.45.11 INTERFUND RENTAL $ 2,499 $ 2,499 $ 2,499 $ 2,499 $ 2,499 001.000.41.521.10.45.11 INTERFUND RENTAL $ 3,135 $ 3,135 $ 3,135 $ 3,135 $ 3,135 001.000.62.558.60.45.11 INTERFUND RENTAL $ 424 $ 424 $ 424 $ 424 $ 424 001.000.65.518.20.45.11 INTERFUND RENTAL $ 1,417 $ 1,417 $ 1,417 $ 1,417 $ 1,417 423.000.75.535.80.45.11 INTERFUND RENTAL $ 533 $ 533 $ 533 $ 533 $ 533 422.000.72.531.90.45.11 INTERFUND RENTAL $ 351 $ 351 $ 351 $ 351 $ 351 421.000.74.534.80.45.11 INTERFUND RENTAL $ 579 $ 579 $ 579 $ 579 $ 579 423.000.76.535.80.45.11 INTERFUND RENTAL $ 636 $ 636 $ 636 $ 636 $ 636 Total Expenditure Increase Decrease $ - $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase Decrease $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ (16,661) $ (16,661) $ (16,661) $ 16,661 $ (16,661) 512.000.39.508.00.00.00 Ending Fund Balance 18,760 18,760 18,760 18,760 18,760 423.000.75.508.00.00.00 Ending Fund Balance (1,169) (1,169) (1,169) (1,169) (1,169) 421.000.74.508.00.00.00 Ending Fund Balance (579) (579) (579) (579) (579) 422.000.72.508.00.00.00 Ending Fund Balance (351) (351) (351) (351 (351) Total Ending Fund Balance Increase (Decrease) $ - $ - $ - $ - Packet Pg. 6 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Description: Remote work has become more prevalent and widespread throughout the enterprise. Working from home or remote locations introduces new vectors for bad actors to exploit. Unfortunately, municipalities have become a frequent target. New technology trends require new methods and tools to protect the enterprise from cyberthreats. This decision package implements tools that enhance security by better protecting workstations and providing visibility into network activity. Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Services Ive Services New Item For Council To Consider 100 % Ending Fund Balance On -Going Operating Fund MULTIPLE FUNDS Name: Fill out on -going costs & revenues Account Number Description 2022 2023 2024 2025 2026 512.000.31.518.88.48.00 Repair / Maintenance $ 18,500 $ 18,760 $ 18,760 $ 18,760 $ 18,760 001.000.62.524.20.45.11 Interfund Rental $ 376 $ 381 $ 381 $ 381 $ 381 001.000.31.514.31.45.11 Interfund Rental $ 334 $ 339 $ 339 $ 339 $ 339 001.000.61.557.20.45.11 Interfund Rental $ 5,807 $ 5,888 $ 5,888 $ 5,888 $ 5,888 001.000.11.511.60.45.11 Interfund Rental $ 460 $ 466 $ 466 $ 466 $ 466 001.000.23.512.51.45.11 Interfund Rental $ 41 $ 42 $ 42 $ 42 $ 42 001.000.62.524.10.45.11 Interfund Rental $ 328 $ 333 $ 333 $ 333 $ 333 001.000.67.518.21.43.11 Interfund Rental $ 877 $ 890 $ 890 $ 890 $ 890 001.000.31.514.23.45.11 Interfund Rental $ 334 $ 339 $ 339 $ 339 $ 339 001.000.39.522.20.45.11 Interfund Rental $ 167 $ 169 $ 169 $ 169 $ 169 001.000.22.518.10.45.11 Interfund Rental $ 209 $ 212 $ 212 $ 212 $ 212 001.000.21.513.10.45.11 Interfund Rental $ 125 $ 127 $ 127 $ 127 $ 127 001.000.64.571.22.45.11 Interfund Rental $ 2,465 $ 2,499 $ 2,499 $ 2,499 $ 2,499 001.000.41.521.10.45.11 InterfundRental $ 3,091 $ 3,135 $ 3,135 $ 3,135 $ 3,135 001.000.62.558.60.43.11 Interfund Rental $ 418 $ 424 $ 424 $ 424 $ 424 001.000.65.518.20.45.11 Interfund Rental $ 1,398 $ 1,417 $ 1,417 $ 1,417 $ 1,417 423.000.75.535.80.45.11 Interfund Rental $ 526 $ 533 $ 533 $ 533 $ 533 422.000.72.531.90.45.11 Interfund Rental $ 346 $ 351 $ 351 $ 351 $ 351 421.000.74.534.80.45.11 Interfund Rental $ 571 $ 579 $ 579 $ 579 $ 579 423.000.76.535.80.45.11 Interfund Rental $ 627 $ 636 $ 636 $ 636 $ 636 Total Expenditure Increase Decrease $ $ $ $ $ Revenue Increase (Decrease) Account Number Description 1 2022 2023 2024 1 2025 2026 Total Revenue Increase Decrease $ $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ 16,430 $ 16,661 $ 16,661 $ 16,661 $ 16,661 512.000.39.508.00.00.00 Ending Fund Balance 18,500 18,760 18,760 18,760 18,760 423.000.75.508.00.00.00 Ending Fund Balance (1,153) (1,169) (1,169) (1,169) (1,169) 421.000.74.508.00.00.00 Ending Fund Balance (571) (579) (579) (579) (579) 422.000.72.508.00.00.00 Ending Fund Balance (346) (351) (351) (351) (351) Total Ending Fund Balance Increase (Decrease) $ $ $ $ $ Packet Pg. 7 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: The Ebb Tide Trial scheduled for October 2022 requires expenditures for professional services of several architectural, engineering and environmental firms contracted with by the City relating to the design and development of the potential Ebb Tide walkway. Department: Parks, Recreation and Human Services Fund Name: 001 GENERAL Division: Administration Title: Ebb Tide Trial Expenses Preparer: Angie Feser Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance One -Time Operating Account Number Description 2022 2023 2024 2025 2026 001.000.64.571.21.41.00 Professional Services $ 130,000 $ - $ - $ - $ - Total Expenditure Increase Decrease $ 130,000 $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ (130,000) $ - $ - $ - $ - Total Ending Fund Balance Increase (Decrease) $ (130,000) $ - $ - $ - $ - Packet Pg. 8 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: Parks Maintenance exceeded the division's $10,000 Overtime budget allocation by mid -year due to lack of seasonal staff, the lack of an FTE for several months and service demand. An additional allocation is needed to cover costs through the second half of the year. Department: Parks, Recreation and Human Services Fund Name: 001 GENERAL Division: Parks Title: Park Maintenance Overtime Preparer: Angie Feser Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance One -Time Operating Account Number Description 2022 2023 2024 2025 2026 001.000.64.576.80.12.00 Overtime $ 12,000 $ - $ - $ - $ - Total Expenditure Increase Decrease $ 12,000 $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ (12,000) $ - $ - $ - $ - Total Ending Fund Balance Increase (Decrease) $ (12,000) $ - $ - $ - $ - Packet Pg. 9 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: Washington State's Growth Management Act (GMA) requires that cities and counties update their Comprehensive Plans on a periodic schedule. The City of Edmonds' periodic update is due December 31, 2024. This periodic update will be an extensive update ofthe Comprehensive Plan addressing residential density; community character; housing affordability and displacement; equity and inclusion; environmental protection and climate change; economic development. A significant focus of the update will be a visioning and extensive community engagement, with a particular effort on inclusive outreach.The Department of Commerce has provided a $125,000 reimbursable grant to the City to assist with the Comprehensive Plan update. Half of the $125,000 ($62,500) is available on a reimbursment basis beginning July 1, 2022. This budget amendment is to begin accessing this funding source. Services Division: jPlanning Title: I Comprehensive Plan Undate Kernen Lien Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) 100% Ending Fund Balance One -Time Operating Fund 001 GENERAL Name: Ir Account Number Description 2022 2023 2024 2025 2026 00 1.000.62.558.60.4 1.00 Professional Services $ 62,500 $ - $ - S - $ - Total Expenditure Increase Decrease $ 62,500 $ - $ - S - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.334.00.000.00 State Grants - Budget Only $ 62,500 $ - $ - S - $ - Total Revenue Increase Decrease $ 62,500 S - $ - S - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 $ - S - $ - S - $ - Total Ending Fund Balance Increase Decrease $ - S - $ - S Packet Pg. 10 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Description: The need for outside consultant plan review of building permits has exceeded the existing budget of $43,000 by over $50,000 due to increases in permitting activity and larger developments. Larger scale developments require a level of complexity that requires additional expertise in structural and non structural review. We anticipate additional consultant needs through the end of the year. However, the requested increase in funding will be recoverable by increased permit revenues. Services clonal Services orback Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance One -Time Operating Fund 001 GENERAL Name: Account Number Description 2022 2023 2024 2025 2026 001.000.62.524.20.41.00 Professional Services $ 167,000 $ $ $ $ Total Expenditure Increase (Decrease' $ 167,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.345.83.000.00 Permit Revenue $ 167,000 $ $ $ $ Total Revenue Increase Decrease $ 167,000 1 $ S S $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Ending Fund Balance Increase (Decrease' $ $ $ $ $ Packet Pg. 11 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: To provide Budget Authority for Small Claims to be paid from the Risk Fund Department: Human Resources Division: Risk Management Fund Olt RISK MANAGEMENT Title: Risk Fund Small Claims Name: RESERVE Preparer: Dave Turley Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance On -Going Operating Fill out on -going costs & revenues Account Number Description 2022 2023 2024 2025 2026 011.000.39.518.61.49.00 Miscellaneous - Judgements & Settlements $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 Total Expenditure Increase (Decrease) $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 011.000.39.508.00.00.00 Ending Fund Balance $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000) Total Ending Fund Balance Increase Decrease $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ (25,000) 10 Packet Pg. 12 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: In 2022 Mayor Nelson approved a change order for additional work required by the PUD at City Park odor unit which was $83,191.51. The new screenings conveyor (May 2022 $223,048.53), ash thickener drive (March 2022, $121,220.44) and HKA Technology contract (to support the Carbon Recovery Project May 2022 $134,175.00) were presented to City Council and approved. Our prior public Works Director approved wetland survey work being completed by Landau to support the Carbon Recovery Project with totaled $18,800. Due to staff safety concerns a carport cover was purchased to cover the sludge trailers and loading operation. The total of these additions to the CIP is $578,690.99. Public Works Division: JWWTP Title: WWTP CIP Amendment Prevarer: Pamela Randolph Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 3 items were previously discussed in March and May of 2022 100% Ending Fund Balance One -Time Capital_ Fund I 423 SEWER / TREATMENT Name: PLANT Account Number Description 2022 2023 2024 2025 2026 423.100.76.594.35.41.00 HJK and Landau $ 152,975 $ - $ - S - $ - 423.100.76.594.35.65.10 Thickener, Carport 119,478 - - - - 423.100.76.594.35.65.00 Carbon Recovery Project 306,239 - - - - 423.000.75.597.35.55.23 Intrafund Transfer to 423.100 293,901 - - - - Total Expenditure Increase Decrease $ 872,593 $ - $ - S Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.100.374.07.020.00 OVWS District $ 95,779 $ - $ - S - $ - 423.100.374.07.010.00 City of Mountlake Terrace 134,106 - - - - 423.100.374.07.030.00 City of Shoreline 54,906 - - - - 423.100.397.38.423.20 Intrafund Transfer from 423.000 293,901 - - - - Total Revenue Increase Decrease $ 578,692 $ - $ - S - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.75.508.00.00.00 Ending Fund Balance $ 293,901 $ - $ - S - $ - Total Ending Fund Balance Increase Decrease $ 293,901 $ - $ - S - $ - 11 Packet Pg. 13 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: In early January the WWTP experienced a peak flow event which caused severe flooding of the 400 building. Due to regulatory and potential enviornmentatl impacts the repairs had to begin immediately. All the equipment in the 400 building has been assessed and repaired if possible. Some equipment had to be replaced or is still on order. We are awaiting final assessment on our Genie Lift. We are hoping to have repaired as opposed to replaced due to the long lead time. The final piece will be the detailed cleaning of the area which we have a quote for. An insurance claim has been filed and our deductible is $25,000. Public Works Division: WWTP Title: WWTP O&M Budget Amendment Preparer: Pamela Randolph Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider Jan 22 flood and increased sludge hauling 100% Ending Fund Balance One -Time Operating Fund I 423 SEWER / TREATMENT Name: PLANT Account Number Description 2022 2023 2024 2025 2026 423.000.76.535.80.48.00 Flooding Damages $ 444,959 $ - $ - $ - $ - 423.000.76.535.80.46.00 Flooding Deductable 25,000 - - - - Total Expenditure Increase Decrease $ 469,959 $ - $ - $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.343.50.300.00 OVWS District 14.08% $ 3,520 $ - $ - $ - $ - 423.000.343.50.400.00 City of Mountlake Terrace 29.47% 7,368 - - - - 423.000.343.50.500.00 City of Shoreline 12.54% 3,135 - - - - 423.000.372.10.000.00 Insurance reimbursement 419,959 - - - - Total Revenue Increase Decrease $ 433,982 $ - $ - $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.75.508.00.00.00 Ending Fund Balance $ (35,977) $ - $ Total Ending Fund Balance Increase (Decrease) 1$ (35,977) $ -1 $ - $ - $ - 12 Packet Pg. 14 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: The budget amendment is due to the carbon recovery project being extended. There have some some reductions in the O&M expenses (due to significant under staffing and the ability to perform repair and maintenance work) that will offset the total estimated hauling expenses this year. We anticipate the increase in budget authority to be $450,000. Public Works Division: WWTP Title: WWTP O&M Budget Amendment Preparer: Pamela Randolph Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider Increase sludge hauling 100% Ending Fund Balance One -Time Operating Fund I 423 SEWER / TREATMENT Name: PLANT Account Number Description 2022 2023 2024 2025 2026 423.000.76.535.80.48.00 Increased Sludge hauling expense $ 450,000 $ - $ - $ Total Expenditure Increase Decrease $ 450,000 $ - $ - $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.343.50.300.00 OVWS District 14.08% $ 63,360 $ - $ - $ - $ - 423.000.343.50.400.00 City of Mountlake Terrace 29.47% 132,615 - - - - 423.000.343.50.500.00 City of Shoreline 12.54% 56,430 - - - - Total Revenue Increase Decrease $ 252,405 $ - $ - $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.75.508.00.00.00 Ending Fund Balance $ (197,595) $ - $ Total Ending Fund Balance Increase (Decrease) $ (197,595)1 $ 13 Packet Pg. 15 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: Due to high fuel prices there is a need for $40,000 additional for Diesel fuel and $75,000 additional for regular unleaded gas. Department: Fleet Maintenance Division: Fund MULTIPLE FUNDS Title: Increased Fuel Costs Name: Preparer: Carl Rugg Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance One -Time Operating Account Number Description 2022 2023 2024 2025 2026 511.000.77.548.68.34.10 Fuel - Diesel $ 40,000 $ - $ - $ - $ - 511.000.77.548.68.34.11 Fuel - Regular Unleaded 75,000 - - - - Total Expenditure Increase (Decrease) $ 115,000 $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 511.000.77.508.00.00.00 Ending Fund Balance $ 115,000 $ - $ - $ - $ - Total Ending Fund Balance Increase Decrease $ 115,000 $ - $ - $ - $ - 14 Packet Pg. 16 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: This decision package moves designated ARPA budget to the accounts from which the expenditures will be made through the end of 2022. OpenGov - $394,610 ARPA Grant Contractors - $70,000 Datafy - $12,456 Hiatt Consulting - $11,820 Uptown Market - $22,000 Green Streets Conceptual Designs - $89,250 Finance Division: Title: 12022 ARPA Budget Prenarer: IMarissa Cain Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 100% Ending Fund Balance One -Time Operating IM Fund I MULTIPLE FUNDS Name: Account Number Description 2022 2023 2024 2025 2026 00 1.000.61.558.70.4 1.00 Professional Services $ 24,276 $ - $ - S - $ - 512.000.31.518.88.48.00 Repair & Maintenance 394,610 - - - - 001.000.61.558.70.41.00 Professional Services 22,000 - - - - 001.000.31.514.23.41.00 Professional Services 70,000 - - - - 422.000.72.594.31.41.00 Capital Professional Services 89,250 - - - - 142.000.39.518.63.41.00 Community Relief Funds 600,136 - - - - Total Expenditure Increase (Decrease) $ - $ - $ - S Revenue Increase (Decrease) Account Number Description 2022 2023 2024 202.5 2026 142.000.333.21.019.00 Coronavirus Relief Fund $ 600,136 $ - $ - S - $ - 001.000.333.21.019.00 Coronavirus Relief Fund 116,276 - - - - 422.000.333.21.019.00 Coronavirus Relief Fund 89,250 - - - - 512.000.333.21.019.00 Coronavirus Relief Fund 394,610 - - - - Total Revenue Increase Decrease $ - $ - $ - S Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 $ - S - $ - S Total Ending Fund Balance Increase Decrease $ - S - $ - S 15 Packet Pg. 17 2.1.a September Budget Amendment for Council to Consider (September 2022) Budget Amendment for: September 13, 2022 Item Description: On September 7, 2022 City Council authorized the allocation of up to $450,000 of ARPA funding to construct the 96th Avenue Stormwater Mitigation project as required for the completion of Civic Center Playfields Park project. Although tied to the Civic Park project, this is a stormwater project located in public right-of-way and therefore, qualifies for Federal American Rescue Plan Act (ARPA) funding. Currently, city revenues are allocated for this stormwater project but by using ARPA funding, those dollars can be used for additional costs related to Civic Park and other park capital projects. Department: Parks Fund Name: 332 PARKS CAPITAL CONSTRUCTION FUND Division: Title: Civic Park Mitigation Project Preparer: Marissa Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Previously Discussed By Council Sep 6 2022 100% Ending Fund Balance One -Time Capital Account Number Description 2022 2023 2024 2025 2026 332.000.64.594.76.65.00 Parks Construction $ 450,000 $ - $ - $ - $ - 142.000.39.518.63.41.00 Community Relief Funds (450,000) - - - - Total Expenditure Increase (Decrease) $ - $ - $ - $ - $ - Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 332.000.333.21.019.00 Coronavirus Relief Fund $ 450,000 $ - $ - $ - $ - 142.000.333.21.019.00 Coronavirus Relief Fund (450,000) - - - - Total Revenue Increase (Decrease) $ - $ - $ - $ - $ - Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Ending Fund Balance Increase Decrease $ - $ - $ - $ - $ - 16 Packet Pg. 18 ORDINANCE NO. AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4270 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, previous actions taken by the City Council require Interfund Transfers and increases in appropriations; and WHEREAS, state law requires an ordinance be adopted whenever money is transferred from one fund to another; and WHEREAS, the City Council has reviewed the amended budget appropriations and information which was made available; and approves the appropriation of local, state, and federal funds and the increase or decrease from previously approved programs within the 2022 Budget; and THEREFORE, WHEREAS, the applications of funds have been identified; THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. Section 1. of Ordinance No. 4270 adopting the final budget for the fiscal year 2022 is hereby amended to reflect the changes shown in Exhibits A, B, C, and D adopted herein by reference. 1 Packet Pg. 19 2.1.b Section 2. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum, and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. ATTEST/AUTHENTICATE: CITY CLERK, SCOTT PASSEY APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: IM JEFF TARADAY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. APPROVED: MAYOR, MIKE NELSON 2 Packet Pg. 20 SUMMARY OF ORDINANCE NO. of the City of Edmonds, Washington On the day of , 2022, the City Council of the City of Edmonds, passed Ordinance No. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4270 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this day of 12022. CITY CLERK, SCOTT PASSEY 3 Packet Pg. 21 EXHIBIT "A": Budget Amendment Summary (September 2022) FUND NO. FUND DESCRIPTION 2022 BEGINNING FUND BALANCE REVENUE EXPENDITURES 2022 ENDING FUND BALANCE 001 GENERAL FUND 15,931,350 44,986,484 52,919,589 7,998,245 009 LEOFF-MEDICAL INS. RESERVE 255,218 225,000 260,490 219,728 011 RISK MANAGEMENT RESERVE FUND 25,000 - 25,000 - 012 CONTINGENCY RESERVE FUND 1,782,150 - 1,782,150 014 HISTORIC PRESERVATION GIFT FUND 16,421 - 5,900 10,521 016 BUILDING MAINTENANCE 4,400,001 119,645 545,000 3,974,646 017 MARSH RESTORATION & PRESERVATION FUND 848,616 - - 848,616 018 EDMONDS HOMELESSNESS RESPONSE FUND - 200,000 200,000 - 019 EDMONDS OPIOID RESPONSE FUND - - - - 104 DRUG ENFORCEMENT FUND 75,174 167,210 45,800 196,584 111 STREET FUND 951,166 1,751,930 2,315,780 387,316 112 COMBINED STREET CONST/I MP ROVE 2,238,449 13,684,871 12,868,796 3,054,524 117 MUNICIPAL ARTS ACQUIS. FUND 648,879 216,701 195,380 670,200 120 HOTEL/MOTELTAX REVENUE FUND 71,114 84,410 100,900 54,624 121 EMPLOYEE PARKING PERMIT FUND 76,524 26,540 26,880 76,184 122 YOUTH SCHOLARSHIP FUND 14,259 1,550 3,000 12,809 123 TOURISM PROMOTIONAL FUND/ARTS 95,972 29,590 28,200 97,362 125 PARK ACQ/IMPROVEMENT 4,053,415 2,271,020 4,589,688 1,734,747 126 SPECIAL CAPITAL FUND 3,313,338 2,261,030 2,483,667 3,090,701 127 GIFTS CATALOG FUND 301,524 82,750 78,400 305,874 130 CEMETERY MAINTENANCE/IMPROV 266,205 182,430 220,561 228,074 136 PARKSTRUSTFUND 168,589 4,330 50,000 122,919 137 CEMETERY MAINTENANCE TRUSTFD 1,107,074 43,520 25,000 1,125,594 138 SISTER CITY COMMISSION 15,481 10,290 11,900 13,871 140 BUSINESS IMPROVEMENT DISTRICT FUND 29,132 79,349 87,680 20,801 141 AFFORDABLE & SUPPORTIVE HOUSING FUND 159,414 65,000 - 224,414 142 EDMONDS RESCUE PLAN FUND 4,772,380 3,806,413 5,027,356 3,551,437 143 TREE FUND 20,632 215,330 214,800 21,162 211 LID FUND CONTROL - - - - 231 2012 LTGO DEBT SERVICE FUND - 611,370 611,370 - 332 PARKS CONSTRUCTION 4,113,862 4,272,685 8,064,418 322,129 421 WATER 28,727,168 11,018,136 11,492,138 28,253,166 422 STORM 15,647,377 7,967,147 9,709,596 13,904,928 423 SEWER/TREATMENT PLANT 60,352,529 26,085,162 31,324,730 55,112,961 424 BOND RESERVE FUND 843,961 1,988,700 1,988,710 843,951 511 EQUIPMENT RENTAL FUND 9,208,511 1,925,920 2,065,371 9,069,060 512 Technology Rental Fund 1,079,041 1,553,180 1,929,322 702,899 Totals 161,609,926 125,937,693 149,515,422 138,032,197 C N E C N E Q r N 7 m L d E N r Q d co N N O L N E N d N N O N C d E t v R r r Q Packet Pg. 22 EXHIBIT "B": Budget Amendments by Revenue (September 2022) FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4240 1/1/2022 Adopted Amendment Ord. #4249 3/1/2022 Adopted Amendment Ord. #4250 3/15/2022 Adopted Amendment Ord. #4257 4/26/2022 Proposed Amendment Ord. # 2022 Amended Revenue Budget 001 General Fund $ 44,204,863 $ (35,000) $ 470,845 $ $ 345,776 $ 44,986,484 009 Leoff-Medical Ins. Reserve 225,000 - - 225,000 011 Risk Management Reserve Fund - 012 Contingency Reserve Fund 014 Historic Preservation Gift Fund - 016 Building Maintenance Fund 119,645 119,645 017 Marsh Restoration & Preservation Fund - - 018 Edmonds Homelessness Response Fund 200,000 200,000 019 Edmonds Opioid Response Fund - - - 104 Drug Enforcement Fund 167,210 167,210 111 Street Fund 1,751,930 - 1,751,930 112 Combined Street Const/Improve 13,359,021 325,850 13,684,871 117 Municipal Arts Acquis. Fund 216,701 - 216,701 118 Memorial Street Tree - - 120 Hotel/Motel Tax Revenue Fund 84,410 84,410 121 Employee Parking Permit Fund 26,540 26,540 122 Youth Scholarship Fund 1,550 1,550 123 Tourism Promotional Fund/Arts 29,590 29,590 125 ParkAcq/Improvement 2,271,020 2,271,020 126 Special Capital Fund 2,261,030 2,261,030 127 Gifts Catalog Fund 82,750 82,750 130 Cemetery Maintenance/Improv 182,430 182,430 136 Parks Trust Fund 4,330 4,330 137 Cemetery Maintenance Trust I'd 43,520 43,520 138 Sister City Commission 10,290 10,290 140 Business Improvement District Fund 79,349 79,349 141 Affordable and Supportive Housing Fund 65,000 65,000 142 Edmonds Rescue Plan Fund 4,856,549 (1,050,136) 3,806,413 143 Tree Fund 215,330 215,330 211 Lid Fund Control - - 231 2012 LTGO Debt Service fund 611,370 - 611,370 332 Parks Construction 3,822,685 450,000 4,272,685 421 Water 11,018,136 - 11,018,136 422 Storm 8,277,897 (400,000) - 89,250 7,967,147 423 Sewer/Treatment Plant 16,001,340 8,818,743 1,265,079 26,085,162 424 Bond Reserve Fund 1,988,700 - - 1,988,700 511 Equipment Rental Fund 1,925,920 - 1,925,920 512 Technology Rental Fund 1,153,570 399,610 1,553,180 617 Firemen's Pension Fund - - - Totals $ 114,938,031 1 $ (235,000) $ 9,615,438 1 $ 119,645 1 $ 1,499,579 1 $ 125,937,693 C N E C N E Q r N 7 m L d E N Q d CV CV O CV N E C� d Cn CV CV 0 CV C d E t v R r Q Packet Pg. 23 EXHIBIT "C": Budget Amendment by Expenditure (September 2022) FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4240 1/1/2022 Adopted Amendment Ord. #4249 3/1/2022 Adopted Amendment Ord. #4250 3/15/2022 Adopted Amendment Ord. #4257 Proposed Amendment Ord. # 2022 Amended Expenditure Budget 001 General Fund $ 49,246,551 $ (1,677) $ 126,661 $ 2,989,337 $ 558,717 $ 52,919,589 009 Leoff-Medical Ins. Reserve 260,490 - - 260,490 011 Risk Management Reserve Fund - 25,000 25,000 012 Contingency Reserve Fund - - - 014 Historic Preservation Gift Fund 5,900 5,900 016 Building Maintenance Fund 980,000 (435,000) 545,000 017 Marsh Restoration & Preservation Fund - - 018 Edmonds Homelessness Response Fund 200,000 200,000 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 45,800 - 45,800 111 Street Fund 2,254,676 61,104 2,315,780 112 Combined Street Const/Improve 12,542,946 325,850 - 12,868,796 117 Municipal Arts Acquis. Fund 181,880 13,500 195,380 118 Memorial Street Tree - - - 120 Hotel/Motel Tax Revenue Fund 100,900 100,900 121 Employee Parking Permit Fund 26,880 26,880 122 Youth Scholarship Fund 3,000 3,000 123 Tourism Promotional Fund/Arts 28,200 - 28,200 125 ParkAcq/Improvement 4,279,876 309,812 4,589,688 126 Special Capital Fund 1,922,273 561,394 2,483,667 127 Gifts Catalog Fund 78,400 - 78,400 130 Cemetery Maintenance/Improv 220,561 - 220,561 136 Parks Trust Fund - 50,000 50,000 137 Cemetery Maintenance TrustFd 25,000 - 25,000 138 Sister City Commission 11,900 11,900 140 Business Improvement District Fund 87,680 87,680 141 Affordable and Supportive Housing Fund - - - - 142 Edmonds Rescue Plan Fund 1,250,000 4,727,492 100,000 (1,050,136) 5,027,356 143 Tree Fund 214,800 - - 214,800 211 Lid Fund Control - - 231 2012LTGO Debt Service Fund 611,370 - - 611,370 332 Parks Construction 7,321,018 293,400 - 450,000 8,064,418 421 Water 11,110,498 365,396 15,094 1,150 11,492,138 422 Storm 8,638,202 (400,000) 1,443,238 (61,791) 89,947 9,709,596 423 Sewer/Treatment Plant 15,656,812 13,855,689 17,355 1,794,874 31,324,730 424 Bond Reserve Fund 1,988,710 - - - 1,988,710 511 Equipment Rental Fund 1,942,460 - 7,911 115,000 2,065,371 512 Technology Rental Fund 1,447,422 91,600 - 390,300 1,929,322 617 Firemen Pension Fund - - Totals 1 $122,484,205 1 $ (201,677) $ 22,164,032 1 $ 2,694,010 1 $ 2,374,852 1 $ 149,515,422 C N E C N E Q r N 7 m L d E N r Q d N N O L N E N d N N 0 N C d E t v R r Q Packet Pg. 24 EXHIBIT "D": Budget Amendment Summary (September 2022) Fund Number Proposed Amendment Changein Revenue Proposed Amendment Change in Expense Proposed Amendment Change in Ending Fund Balance 001 345,776 558,717 (212,941) 011 - 25,000 (25,000) 142 (1,050,136) (1,050,136) 332 450,000 450,000 421 1,150 (1,150) 422 89,250 89,947 (697) 423 1,265,079 1,794,874 (529,795) 511 115,000 (115,000) 512 399,610 390,300 9,310 Total Change 1,499,579 2,374,852 (875,273) N E C N E Q N 7 m L d E N Q d In N N O N L I_ Y Q ,Q1 v/ N N O N C d E t V R a+ a+ Q Packet Pg. 25 2.2 City Council Agenda Item Meeting Date: 09/13/2022 ARPA Program Status Report Staff Lead: Todd Tatum Department: Community Services Preparer: Todd Tatum Background/History American Rescue Plan Act funding was allocated to specific programmatic elements in Ordinance 4229 in July 2021, and further amended by Ordinances 4237 and 4259. These elements are: A. City Expenditure Reimbursement B. Edmonds Rescue Plan Household Support C. Edmonds Rescue Plan Business Support D. Edmonds Rescue Plan Nonprofit Support E. Edmonds Rescue Plan Job Retraining Program F. Edmonds Rescue Plan City Green Infrastructure Staff Recommendation None. This is a report only. Narrative This agenda item gives a recap of the efforts to establish programs in each of the six established areas. A break down of accomplishments by program will be given, highlighting the successes and opportunities in each. Attachments: 1) ARPA Funding Status Graphs Attachments: FINAL ARPA Finance Committee Sept 13 2022 Packet Pg. 26 f 12C. 10,9V City of Edmonds Finance Committee Meeting. Sep 13, 20 Discussions for this agenda item: 1) Program overview 2) Program status by category 3) Remaining budget "il Packet Pg. 27 1 REVIEW: SUBDIVISION OF FUNDS BY ORDINANCE •City Expenditure Reimbursements: $750,000 •Edmonds Rescue Plan Household Support: $4,150,000 •Household Support •Utility Bill Support •Housing Repair •Edmonds Rescue Plan Business Support: $1,125,000 •General Business Support •Tourism Support •Small Business Support •Edmonds Rescue Plan Nonprofit Support: $500,000 •Edmonds Rescue Plan Job Retraining Program: $600,000 •City Green Infrastructure: $427682099 •Edmonds Marsh •Lower Perrinville Creek Realignment •Green Streets and Rain Gardens Packet Pg. 28 B - Household Support - 34.9% C - Business Support - 9.5% D - Nonprofit Support - 4.2% E - Job Retraining - 5.ON F - Green Infrastructure - 40.1% Total ARPA Funds - $11,893,099 A - City Expenditures - 6.3% "7,785 WE •� MM $2,450,404 2$264,525 $608, 83 $1,125,000 $420,50 $420,50 $500,0 4 00 00 $14,526 $$.9,254 $394,74a $�4a,sa9 � $�5a,aaa �199,999 $fi00, $6a0, CL IM $4,150,000 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 S pent by 9/6%22 Cornmitme nts 0 9 f 6 f 22 Allocated Funds $5,004,040 E 0 N L 0 IL Q IL Q Packet Pg. 29 Household Support Subcategories - $41150,000 $0 Housing Repair - 24.1% $0 $5,443 Utility Support - 3.6% $50,000 Household Grants - 72.3% $150,000 $1,000,000 $772,343 $2,000,000 ................................................................. $0 $1,000,000 $2,000,000 $3,000,000 $3,000,000 $4,000,000 5pent by 9f 6j22 Corr mitme nts @ 9f 6f 22 ■ Allocated Funds 0 CL N 3 r+ N E aM 0 L. IL Q a w N N O N M a+ Q 0 d E E 0 t� I d c c� U. IL Q J Q z d E Packet Pg. 30 1 Business Support Subcategories - 11125,000 Small Business Support Grants - 55.6% Tourism Support- 26.7% General Business Support -17.B% $625,0 0 $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,00 ■ Spent by 9/6/22 Commitments @ 9/6/22 Allocated Funds r a Packet Pg. 31 Nonprofit Support: • 15 total grantees • All in 2021 • Ranged from $8,000-$50,000 D - Nonprofit Support - 4. 2 $4200500 $4200500 ML 5o0+oo0 Spent by 8f 22/22 ■ Commitments @ 8f 22/22 Allocated Funds Packet Pg. 32 1 Job Retraining: • Edmonds College: $325,000 over three years • Shoreline CC: $275,000 over three years E - Job Retraining - 5.0 Spent by 8/22/22 $1991999 $600, 00 $600, 00 $0 Commitments @ 8/22/22 $110001000 Allocated Funds Packet Pg. 33 Green Infrastructure: • Edmonds Marsh Water Quality & Flood Control • Lower Perrinville Creek Realignment • Green Streets • 96t" Right of Way Infiltration F- Green Infrastructure -40.1% so SUM" $2,000,000 ■ S pent by 9 f 6/22 Cc mm itmen is @ 9/6/22 $ 750,000 $2,968,099 $ 600,000 $ 450,000 ■Allocated Fj-ids Packet Pg. 34 Discussion L I a jL 0 F 0 a m N 3 r+ Cl) E L IM 0 L. IL Q IL Q N N O N M a+ CL w E E 0 U. Q a Q J Q Z C d Packet Pg. 35 1 2.3 City Council Agenda Item Meeting Date: 09/13/2022 July 2022 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Move to full council to be received for filing. Narrative July 2022 Monthly Financial Report Attachments: July Monthly Financial Report Packet Pg. 36 I 2.3.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT JULY 2022 Packet Pg. 37 1 INVESTMENT PORTFOLIO SUMMARY I 2.3.a I City of Edmonds Investment Portfolio Detail As of July 31, 2022 Years Agency/ Investment Purchase to Par Market Issuer TvPe Price Maturitv Value Value Mason & Kitsap Cnty WA Bonds Grant Cnty WA Bonds Grant Cnty WA Bonds Seattle WA Muni Bonds FHLMC Bonds FHLB Bonds First Financial - ECA CD Kent WA Bonds FHLB Bonds FM Bonds FNMA Bonds FHLB Bonds Spokane County WA Bonds First Financial - Waterfront Center CD TOTAL SECURITIES Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO Maturity Coupon Date Rate 948,084 0.34 855,000 865,021 12/01/22 5.00% 1,517,955 0.42 1,500,000 1,490,280 01/01/23 1.54% 576,332 0.42 520,000 527,675 01/01/23 5.00% 2,224,500 0.51 2,000,000 2,036,060 02/01/23 5.00% 988,678 0.72 1,000,000 981,517 04/20/23 0.38% 1,996,590 1.18 2,000,000 1,932,910 10/05/23 0.22% 2,803,516 1.29 2,803,516 2,803,516 11/15/23 2.08% 286,648 1.34 250,000 261,250 12/01/23 5.00% 954,866 1.70 1,000,000 957,183 04/10/24 0.35% 996,082 1.88 1,000,000 997,043 06/17/24 2.80% 992,693 1.92 1,000,000 980,291 07/02/24 1.75% 950,774 2.30 1,000,000 953,340 11/18/24 0.90% 207,260 2.34 200,000 195,410 12/01/24 2.10% 1,575,000 5.26 1,575,000 1,575,000 11/01/27 0.20% 17,018,977 1.54 16,703,516 16,556,496 Seattle WA Issuer Diversification Muni, 12%� Kent WA, rhF: 1% r s t Financial- Mason & � CD, 26% Kitsap Cnty WA, 5% Gra nt Cnty_ Spokane WA, 12% FHLB, 12% . County FNMA, 6% WA, 1% FHLMC, 6% 26,018,466 26,018,466 Demand 1.63% 42,835,212 42,835,212 Demand 1.37% $ 85,557,193 $ 85,410,173 Cash and Investment Balances Bonds, (in $ Millions) $12.3, 14%— CD's, $4.4, 5% State LGIP, $26.0, 29% ■ County LGIP, $42.8 , 48% Checki ng, —$3.0,4% Q 1 Packet Pg. 38 1 I 2.3.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 77771 $1,236,875 $1,200, 000 $1,000,000 $882556 947 931 $950,684 $800,000 $635,781 $600,000 $508,183 4 $400,000 $200,000 $- 2017 2018 201 2020 2021 YTD 2022 2 Packet Pg. 39 GENERAL FUND SUMMARY I 2.3.a I General Fund Revenues and Expenses (Rolling 24 months) Series5 Seriesl 10,000, 000 — — — 9,000,000 8,000,000 �♦ 7,000, 000 6,000,000 • i • 5,000,000 • ♦ 4,000, 000 • • 3,000000 , 2,000, 000 1,000, 000 - - August November February May August November February May General Fund Tax Revenue (2016 through 2021) Sales Tax Property Tax EMS Tax Other Taxes 12,000, 000 10,000,000 8,000, 000 6,000,000 4,000, 000 2,000,000 2016 2017 2018 2019 2020 2021 7,000, 000 6,500,000 6,000,000 5,500, 000 5,000,000 4,500,000 4,000, 000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 Sales Tax General Fund Tax Revenue (2022 YTD) 55,761,874 54,770,936 Property Tax EMS Tax Other Taxes 3 I Packet Pg. 40 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2022 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,485,140 $ 2,485,140 $ 2,186,816 -12.00% February 4,914,775 2,429,635 4,606,889 -6.26% March 7,376,703 2,461,928 7,290,787 -1.16% April 10,510,823 3,134,120 10,347,043 -1.56% May 19,347,867 8,837,044 19,290,212 -0.30% June 21,924,850 2,576,983 21,853,448 -0.33% July 24,4S3,S03 2,528,653 24,106,033 -1.42% August 27,071,593 2,618,090 September 29,450,864 2,379,271 October 33,497,347 4,046,483 November 42,070,966 8,573,619 December 44,640,708 2,569,742 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2022 Real Estate Excise Tax 1 & 2 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 376,007 $ 376,007 $ 135,500 -63.96% February 604,057 228,050 377,997 -37.42% March 942,203 338,145 551,531 -41.46% April 1,215,412 273,209 923,535 -24.01% May 1,570,915 355,503 1,301,746 -17.13% June 1,942,927 372,012 1,703,080 -12.34% July 2,344,831 401,904 2,043,169 -12.86% August 2,781,982 437,151 September 3,225,577 443,595 October 3,626,122 400,545 November 4,018,664 392,542 December 4,400,000 381,336 *The monthly budget forecast columns are based on a five-year average. O CL C M C lL t r C O M N N O N 21 3 O 0. O U a M a M t r C O M 21 7 7 �.i C d E t t� M 4+ a w Packet Pg. 41 1 SALES TAX SUMMARY I 2.3.a I Sales Tax Analysis By Category Current Period: July 2022 Year -to -Date Total $6,337,518 Automotive Repair, $134,596 Business Services, Amusement $673,026 Construction Trade, &Recreation, $978,353 Health & Personal Accommodation, Care, $44,216 $42,386 Gasoline, $60 $23,736 Retail Food Stores, Clothing and $200,594 Accessories,$212,740 , Retail Automotive, Communications, Misc Retail, $1,551,113 $131,511 Wholesale Trade, $1,222,364 $208,818Irs Manufacturing, $71,469 Others, $169,295 Eating &Drinking, $673,239 12,000,000 10,000, 000 8,000,000 6,000,000 4,000,000 2,000,000 0 Annual Sales Tax Revenue L0__ - - 7.395.114 $8,406,296 $8,452,715 $8,317,046 $10,302,518 $6,337,518 2016 2017 2018 2019% 2020 2021 YTD 2022 5 I Packet Pg. 42 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2022 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 763,651 $ 763,651 $ 857,872 12.34% February 1,704,609 940,958 1,853,000 8.71% March 2,420,254 715,646 2,666,259 10.16% April 3,074,639 654,384 3,469,412 12.84% May 3,893,081 818,442 4,483,349 15.16% June 4,672,507 779,426 5,402,133 15.62% July 5,523,403 850,896 6,337,518 14.74% August 6,439,084 915,680 September 7,293,649 854,565 October 8,203,996 910,347 November 9,139,425 935,429 December 10,000,000 860,575 City of Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2022 Gas Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 79,399 $ 79,399 $ 96,596 21.66% February 164,205 84,806 96,596 -41.17% March 246,125 81,920 305,138 23.98% April 313,860 67,734 397,808 26.75% May 367,416 53,556 469,966 27.91% June 402,173 34,757 524,767 30.48% July 429,975 27,802 563,428 31.04% August 452,332 22,357 September 472,668 20,335 October 496,035 23,367 November 534,998 38,963 December 595,000 60,002 Gas Utility Tax 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. O CL C M C LL t r C O N N O N 21 M O CL O U a M C LL t r C O 7 �.i C d E t U M 4+ a 6 Packet Pg. 43 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2022 Telephone Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 53,352 $ 53,352 $ 43,844 -17.82% February 96,981 43,629 66,255 -31.68% March 143,255 46,275 130,244 -9.08% April 192,397 49,142 175,045 -9.02% May 232,481 40,084 208,020 -10.52% June 277,770 45,288 250,253 -9.91% July 321,046 43,277 293,198 -8.67% August 362,710 41,663 September 400,099 37,389 October 445,363 45,264 November 482,039 36,676 December 523,000 40,961 Electric Utility Tax Telephone Utility Tax 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget -*-- Prior Year City of Edmonds, WA Monthly Revenue Summary -Electric Utility Tax 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ February March April May June July August September October November December 148,905 $ 312,488 449,608 602,286 723,393 824,492 920,639 1,015,921 1,108,535 1,199,070 1,299,972 1,410,000 148,905 $ 183,023 163,583 377,116 137,121 534,798 152,678 726,969 121,107 858,720 101,099 993,628 96,147 1,117, 008 95,282 92,614 90,535 100,902 110,028 22.91 20.68 18.95 20.70% 18.71 20.51 21.33 Electric Utility Tax 1,zsuu,uuu 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. Packet Pg. 44 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2022 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 809,979 $ 809,979 $ 827,704 2.19% February 1,383,405 573,426 1,383,308 -0.01% March 2,213,219 829,814 2,127,271 -3.88% April 2,744,029 530,810 2,688,719 -2.02% May 3,542,697 798,668 3,507,398 -1.00% June 4,167,857 625,160 4,071,843 -2.30% July 5,138,308 970,451 4,964,389 -3.38% August 5,986,736 848,427 September 7,133,311 1,146,575 October 7,954,825 821,514 November 8,891,706 936,881 December 9,464,783 573,077 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2022 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 426,464 $ 426,464 $ 417,730 -2.05% February 1,352,938 926,475 1,322,856 -2.22% March 1,779,789 426,851 1,740,623 -2.20% April 2,159,443 379,654 2,114,167 -2.10% May 2,586,880 427,437 2,531,673 -2.13% June 2,966,444 379,564 2,904,040 -2.10% July 3,385,868 419,425 3,322,096 -1.88% August 4,311,526 925,657 September 4,738,766 427,240 October 5,118,192 379,426 November 5,545,860 427,668 December 5,911,497 365,637 Storm Water Sales 6,000,000 5,500,000 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. O CL C M C LL t r C O N N O N 21 M O CIL U a M a LL 21 t r C O M 21 M �.i C d E t U M a Packet Pg. 45 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2022 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 863,521 $ 863,521 $ 877,046 1.57% February 1,571,494 707,973 1,604,010 2.07% March 2,435,565 864,071 2,451,231 0.64% April 3,143,499 707,934 3,183,083 1.26% May 4,009,811 866,312 4,066,458 1.41% June 4,719,932 710,121 4,800,930 1.72% July 5,593,564 873,631 5,679,193 1.53% August 6,307,925 714,362 September 7,215,145 907,220 October 7,936,868 721,723 November 8,819,637 882,769 December 9,528,089 708,452 r Q *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 46 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2022 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 5,342,104 $ 5,342,104 $ 4,585,579 -14.16% February 9,224,399 3,882,295 8,118,010 -11.99% March 13,452,004 4,227,605 11,949,976 -11.17% April 17,153,547 3,701,543 15,453,486 -9.91% May 21,079,517 3,925,970 19,128,482 -9.26% June 25,951,414 4,871,897 23,484,941 -9.50% July 30,080,975 4,129,561 27,097,845 -9.92% August 33,988,564 3,907,589 September 38,118,760 4,130,195 October 42,643,501 4,524,741 November 47,393,697 4,750,196 December 52,360,872 4,967,175 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2022 Non -Departmental Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 2,507,470 $ 2,507,470 $ 2,083,892 -16.89% February 3,542,042 1,034,573 2,922,333 -17.50% March 4,860,388 1,318,346 4,072,745 -16.21% April 5,664,390 804,002 5,019,960 -11.38% May 6,660,696 996,306 5,987,679 -10.10% June 8,505,096 1,844,400 7,606,046 -10.57% July 9,569,495 1,064,399 8,530,659 -10.86% August 10,445,244 875,749 September 11,460,143 1,014,899 October 12,738,982 1,278,840 November 14,162,256 1,423,274 December 15,574,121 1,411,865 *The monthly budget forecast columns are based on a five-year average. O CL C M C tL t r C O M N N O N 21 3 O 0. O U a M a M t r C O M 21 7 7 �.i C d E t t� M -W a 10 Packet Pg. 47 1 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2022 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 33,985 $ 33,985 $ 23,687 -30.30% February 71,308 37,323 43,670 -38.76% March 112,128 40,821 71,408 -36.32% April 150,174 38,046 100,819 -32.87% May 199,408 49,234 129,439 -35.09% June 253,207 53,799 157,419 -37.83% July 291,886 38,679 188,068 -35.57% August 345,215 53,328 September 382,380 37,165 October 414,981 32,601 November 455,321 40,340 December 497,900 42,579 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2022 Office of Mayor Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 36,522 $ 36,522 $ 28,255 -22.63% February 74,639 38,117 59,226 -20.65% March 111,240 36,600 89,568 -19.48% April 148,486 37,247 119,372 -19.61% May 185,158 36,671 148,671 -19.71% June 221,111 35,953 178,561 -19.24% July 257,901 36,789 208,847 -19.02% August 295,030 37,129 September 331,738 36,709 October 367,805 36,067 November 405,747 37,941 December 443,913 38,166 Office of Mayor 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-CurrentYeaz Budget --&---PriorYeaz *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 48 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2022 Human Resources Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 77,402 $ 77,402 $ 59,932 -22.57% February 141,639 64,236 135,524 -4.32% March 202,815 61,176 203,581 0.38% April 266,756 63,941 270,474 1.39% May 331,195 64,439 334,902 1.12% June 405,872 74,678 458,397 12.94% July 464,145 58,273 537,794 15.87% August 524,126 59,981 September 590,408 66,282 October 654,662 64,254 November 726,800 72,138 December 824,831 98,031 City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2022 Municipal Court Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 104,268 $ 104,268 $ 91,643 -12.11% February 213,906 109,638 187,919 -12.15% March 322,490 108,584 284,025 -11.93% April 431,592 109,102 386,046 -10.55% May 548,505 116,913 482,322 -12.07% June 654,584 106,079 591,066 -9.70% July 763,667 109,084 691,341 -9.47% August 884,110 120,443 September 995,910 111,800 October 1,110,987 115,077 November 1,227,059 116,072 December 1,368,755 141,696 Municipal Court 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-CurrentYeaz Budget -m-PriorYear *The monthly budget forecast columns are based on a five-year average. O CL C M C LL t r C O N N O N 21 M O CL O U a M C LL t r C O 7 7 �.i C d E t U M 4+ a 12 Packet Pg. 49 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2022 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 49,857 $ 49,857 $ 33,127 -33.56% February 103,113 53,256 72,230 -29.95% March 155,568 52,455 122,479 -21.27% April 205,451 49,882 179,118 -12.82% May 260,752 55,301 216,588 -16.94% June 315,986 55,234 250,483 -20.73% July 373,132 57,147 288,425 -22.70% August 434,777 61,645 September 492,000 57,223 October 552,240 60,239 November 622,590 70,351 December 719,388 96,798 O CL FY C M C ILL t r C O N N O N 3 O CL O U C M C LL z r C O 7 r C d E z U M 4+ a *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 50 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2022 Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 176,962 $ 176,962 $ 216,858 22.55% February 334,966 158,004 287,295 -14.23% March 484,397 149,431 502,978 3.84% April 566,805 82,408 545,022 -3.84% May 674,037 107,232 603,046 -10.53% June 784,541 110,504 705,231 -10.11% July 877,847 93,306 771,437 -12.12% August 989,174 111,327 September 1,106,217 117,044 October 1,245,373 139,155 November 1,341,722 96,350 December 1,539,022 197,300 Administrative Services Technology Rental Fund 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget -d­ Prior Year City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ February March April May June July August September October November December 238,721 $ 399,953 563,330 729,233 896,198 1,121,628 1,314,351 1,478,599 1,647,511 1,824,204 1,989,608 2,156,911 238,721 $ 217,022 161,232 380,532 163,378 547,460 165,903 722,690 166,965 901,287 225,430 1,088,001 192,723 1,236,936 164,248 168,911 176,693 165,404 167,303 -9.09 -4.86 -2.82 -0.90 0.57 -3.00 -5.89 Administrative Services 1,800,000 1,600,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 Yeaz Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. 14 Packet Pg. 51 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2022 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 80,982 $ 80,982 $ 77,656 -4.11% February 161,963 80,982 155,234 -4.16% March 242,945 80,982 233,065 -4.07% April 323,927 80,982 287,018 -11.39% May 404,908 80,982 388,315 -4.10% June 485,890 80,982 465,893 -4.12% July 566,871 80,982 545,067 -3.85% August 647,853 80,982 September 728,835 80,982 October 809,816 80,982 November 890,798 80,982 December 971,780 80,982 Police City Attorney 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-- Current Yeaz Budget Prior Yeaz City of Edmonds, WA Monthly Expenditure Report -Police 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 1,045,238 $ 1,045,238 $ 973,358 -6.88% February 2,105,968 1,060,730 1,945,020 -7.64% March 3,177,596 1,071,629 3,008,075 -5.33% April 4,236,492 1,058,896 4,001,453 -5.55% May 5,296,298 1,059,805 5,133,192 -3.08% June 6,428,932 1,132,634 6,213,167 -3.36% July 7,551,012 1,122,080 7,213,970 -4.46% August 8,579,704 1,028,692 September 9,657,485 1,077,782 October 10,845,669 1,188,184 November 12,168,634 1,322,964 December 13,375,470 1,206,836 Police 8,000,000 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"- Current Yeaz Budget �Prior Year *The monthly budget forecast columns are based on a five-year average. O CL C LL t r C O N N O N 21 3 O sZ O U c C LL t r C O M 21 7 �.i C d E t U O a 15 Packet Pg. 52 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2022 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 272,173 $ 272,173 $ 309,139 13.58% February 567,186 295,012 661,303 16.59% March 860,247 293,062 909,669 5.75% April 1,174,618 314,370 1,157,411 -1.46% May 1,488,050 313,432 1,419,912 -4.58% June 1,792,716 304,666 1,678,976 -6.34% July 2,114,310 321,593 1,985,079 -6.11% August 2,423,605 309,295 September 2,733,462 309,857 October 3,039,102 305,640 November 3,402,002 362,901 December 3,791,859 389,857 Parks & Recreation Development Services 4,000,000 3,500,000 3,000,000 2,500,000 2,000,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 -d­ Prior Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 358,065 $ 358,065 $ 319,222 -10.85% February 748,023 389,958 651,988 -12.84% March 1,136,243 388,220 1,040,803 -8.40% April 1,535,144 398,902 1,354,932 -11.74% May 1,941,016 405,872 1,709,318 -11.94% June 2,369,808 428,792 2,119,385 -10.57% July 2,835,053 465,245 2,564,042 -9.56% August 3,347,305 512,252 September 3,871,489 524,184 October 4,291,784 420,295 November 4,690,353 398,569 December 5,125,535 435,182 Parks & Recreation 5,500,000 4,000,000 1,500,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Yeaz Budget -0-- Prior Year *The monthly budget forecast columns are based on a five-year average. 16 Packet Pg. 53 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Public Works Administration 2022 Public Works Administration Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 49,466 $ 49,466 $ 22,716 -54.08% February 100,066 50,600 46,637 -53.39% March 150,167 50,100 71,242 -52.56% April 201,867 51,701 94,556 -53.16% May 252,421 50,554 117,239 -53.55% June 303,852 51,431 140,684 -53.70% July 355,684 51,832 163,431 -54.05% August 405,471 49,786 September 455,172 49,701 October 504,185 49,013 November 567,424 63,239 December 614,113 46,689 Facilities Maintenance Public Works Administration 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2022 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 219,301 $ 219,301 $ 109,202 -50.20% February 456,337 237,035 369,398 -19.05% March 723,326 266,990 562,089 -22.29% April 964,010 240,684 782,173 -18.86% May 1,206,775 242,765 942,003 -21.94% June 1,404,870 198,095 1,081,995 -22.98% July 1,647,775 242,905 1,236,300 -24.97% August 1,934,891 287,116 September 2,271,751 336,861 October 2,655,928 384,177 November 2,962,277 306,349 December 3,425,275 462,998 *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 54 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2022 Engineering Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 225,595 $ 225,595 $ 226,829 0.55% February 452,988 227,392 457,182 0.93% March 684,071 231,083 685,977 0.28% April 917,956 233,885 914,235 -0.41% May 1,175,026 257,070 1,140,813 -2.91% June 1,412,521 237,495 1,368,545 -3.11% July 1,660,688 248,167 1,597,752 -3.79% August 1,900,016 239,329 September 2,131,816 231,799 October 2,366,570 234,755 November 2,602,612 236,042 December 2,845,336 242,724 Engine a ring 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 18 Packet Pg. 55 I 2.3.a I Page 1 of 1 C ITY O F IDMO NDS REVINUES BY FUND - SUMMARY Fund 2022 Amended 7/31/2021 7/31/2022 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 44,640,708 $ 25,583,320 $ 24,106,033 $ 20,534,675 540 009 LEOFF-MEDICAL INS. RESERVE 225,000 - 112,500 112,500 500 014 HISTORIC PRESERVATION GIFT FUND - 2,500 - - 00 016 BUILDING MAINTENANCE FUND 119,645 - 22,390 97,255 190 017 MARSH RESTORATION & PRESERVATION FUND - 150 1,150 (1,150) 00 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 - 200,000 - 1000 104 DRUG ENFORCEMENT FUND 167,210 1,645 885 166,325 14 Ill STREET FUND 1,751,930 1,042,541 988,280 763,650 560 C 112 COMBINED STREET CONST/IMPROVE 1 13,684,871 1,135,453 1,711,170 11,973,701 O 130 d 117 MUNICIPAL ARTS ACQUIS. FUND 216,701 27,138 96,406 120,295 440 iC 118 MEMORIAL STREET TREE - 447 - - 04 'V 120 HOTEL/MOTEL TAX REVENUE FUND 84,410 34,240 54,413 29,997 C 640 C 121 EMPLOYEE PARKING PERMIT FUND 26,540 11,638 12,725 13,815 480 li 122 YOUTH SCHOLARSHIP FUND 1,550 306 727 823 470 t r 123 TOURISM PROMOTIONAL FUND/ARTS 29,590 12,768 18,997 10,593 640 G 125 REAL ESTATE EXCISE TAX 2 2 2,271,020 1,505,209 1,069,772 1,201,248 47° 126 REAL ESTATE EXCISE TAX 1 2 2,261,030 1,496,114 1,063,137 1,197,893 N 470 G 127 GIFT S CAT ALOG FUND3 82,750 41,374 2,970,680 (2,887,930) 35900 130 CEMETERY MAINTENANCE/IMPROVEMT 182,430 168,463 126,523 55,907 690 136 PARKS TRUST FUND 4,330 3,685 1,977 2,353 460 137 CEMETERY MAINTENANCE TRUST FD 43,520 40,206 24,549 18,971 0 560 CL 138 SISTER CITY COMMISSION 10,290 2,737 2,683 7,607 O 260 140 BUSINESS IMPROVEMENT DISTRICT 79,349 60,185 66,328 13,021 844 tt 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 40,407 32,377 32,623 500 142 EDMONDS RESCUE PLAN FUND 4,856,549 5,946,550 5,952,359 (1,095,810) 1230 LL 143 TREE FUND 215,330 - 241 215,089 00 % z 231 2012 LT GO DEBT SERVICE FUND 611,370 40,853 41,009 570,361 74 332 PARKS CAPITAL CONSTRUCTION FUND 4 3,822,685 385,689 1,741,465 2,081,220 O 460 M 411 COMBINED UTILITY OPERATION - 5,590 93,080 (93,080) 04 421 WATER UTILITY FUND 11,018,136 5,845,898 5,805,093 5,213,043 7 530 422 STORM UTILITY FUND 5 7,877,897 3,903,543 3,757,939 4,119,958 484 423 SEWER/WWTP UTILITY FUND 6 24,820,083 12,990,644 11,860,767 12,959,316 480 z 424 BOND RESERVE FUND 1,988,700 600,423 592,065 1,396,635 300 M 511 EQUIPMENT RENTAL FUND 1,925,920 886,499 1,057,748 868,172 r� 554 Q 512 TECHNOLOGY RENTAL FUND 1,153,570 715,800 674,665 478,905 580 $ 124,438,114 $ 62,532,012 $ 64,260,132 $ 60,177,982 520 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Traffic Impact fee in March 2022. z REET revenues are down a total of $(835,896) from this point in time last year. i Differences due to a large donation received in June of 2022. 4 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Park Impact fee in March 2022. 5 2022 Utility Rate Increases are 4.5%for Water, 5%for Sewer, and 9.5%for Storm Drain. 6 Differences due primarily to WWTP partner bilings in 2021. 19 Packet Pg. 56 I 2.3.a I Page 1 of 1 C ITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2022 Amended 7/31/2021 7/31/2022 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 52,360,872 $ 24,346,357 $ 27,097,845 $ 25,263,027 520, 009 LEOFF-MEDICAL INS. RESERVE 260,490 193,928 170,531 89,959 650/ 014 HISTORIC PRESERVATION GIFT FUND 5,900 - - 5,900 00 016 BUILDING MAINTENANCE FUND 545,000 - 17,074 527,926 30, 017 MARSH RESTORATION & PRESERVATION FUND - 16,149 - - 00 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 123,581 - 200,000 00 019 EDMONDS OPIOID RESPONSE FUND - 28,445 - - 00 104 DRUG ENFORCEMENT FUND 45,800 - - 45,800 001 O III STREET FUND 2,315,780 1,256,963 1,263,886 1,051,894 550 d 112 COMBINED STREET CONST/IMPROVE 12,868,796 1,307,320 722,544 12,146,252 60/ 117 MUNICIPAL ARTSACQUIS. FUND 195,380 22,318 60,699 134,681 310/ tt 120 HOTEL/MOTEL TAX REVENUE FUND 100,900 32,289 36,018 64,882 360, C 121 EMPLOYEE PARKING PERMIT FUND 26,880 - - 26,880 00 jL 122 YOUTH SCHOLARSHIP FUND 3,000 - 3,000 00 r 123 TOURISM PROMOTIONAL FUND/ARTS 28,200 - 533 27,667 20/ O 125 REAL ESTATE EXCISE TAX 2 4,589,688 246,022 988,448 3,601,240 220, M N 126 REAL ESTATE EXCISE TAX 1 2,483,667 568,724 239,583 2,244,084 100 G 127 GIFTS CATALOG FUND 78,400 32,879 20,260 58,140 260/ 130 CEMETERY MAINTENANCE/IMPROVEMT 220,561 118,129 113,496 107,065 5101 136 PARKS TRUST FUND 50,000 - 2,540 47,460 50, 137 CEMETERY MAINTENANCE TRUST FUND 25,000 19,211 - 25,000 0 04 CL O 138 SISTER CITY COMMISSION 11,900 - 70 11,830 1° W 140 BUSINESS IMPROVEMENT DISTRICT 87,680 30,144 36,407 51,273 420/ .@ U 142 EDMONDS RESCUE PLAN FUND 6,077,492 - 461,521 5,615,971 84 r- 143 TREE FUND 214,800 - - 214,800 04 LL 231 2012 LT GO DEBT SERVICE FUND 611,370 40,853 41,009 570,361 70/ >% t 332 PARKS CAPITAL CONSTRUCTION FUND 7,614,418 243,769 2,939,095 4,675,323 390/ _ O 421 WATER UTILITY FUND 11,490,988 4,219,882 3,610,757 7,880,231 310, 422 STORM UTILITY FUND 9,619,649 2,621,939 2,406,422 7,213,227 250, 7 423 SEWER/WWTP UTILITY FUND 29,529,856 14,690,197 9,875,949 19,653,907 330/ 424 BOND RESERVE FUND 1,988,710 600,417 589,342 1,399,368 300 y 511 EQUIPMENT RENTAL FUND 1,950,371 799,843 761,458 1,188,913 390, s t� 512 TECHNOLOGY RENTAL FUND 1,539,022 572,585 771,437 767,585 500, 617 FIREMEN'S PENSION FUND - 63,132 - - 00 Q $ 147,140,570 $ 52,195,076 $ 52,226,924 $ 94,913,646 350, 20 Packet Pg. 57 I 2.3.a I Page 1 of 3 Title TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 7 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GAS UTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWER UTILITY TAX 12 ST ORMWAT ER UT ILIT Y T AX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABSTAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT -COMCAST 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-ZIPLY FIBER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OT R NON -BUS LIC/PERMIT S INTERGOVERNMENTAL: 32 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 33 WA ASSOC OF SHERRIF'S TRAFFIC GRANT 34 HIGH VISIBILITY ENFORCEMENT 35 CORONAVIRUS RELIEF FUND 2 36 WA STATE TRAFFIC COMM GRANT 37 WASHINGTON STATE ARTS COMMISSION 38 DOC FAC ROOFING 39 STATE GRANTS- BUDGET ONLY 40 WA STATE ART COMMISSION 2021-003-CD 41 2022-2023 BIENNUM ONE-TIME ALLOCATION 42 PUD PRIVILEDGE TAX 43 TRIAL COURT IMPROVEMENT 44 CJ -POPULATION 45 CRIMINAL JUSTICE -SPECIAL PROGRAMS 46 MARIJUANA EXCISE TAX DISTRIBUTION 47 DUI - CITIES 48 FIRE INS PREMIUM TAX 49 LIQUOR EXCISE TAX 50 LIQUOR BOARD PROFITS 51 MISCELLANEOUS INTERLOCAL REVENUE 52 INTERLOCAL GRANTS 53 FIRST RESPONDERS FLEX FUND 54 DISCOVERY PROGRAMS TECHNOLOGY ACQ. 55 VERDANT INTERLOCAL GRANTS C ITY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 7/31/2021 Budget Revenues 7/31/2022 Amount Revenues Remaining %Received $ 11,127,000 $ 5,820,281 $ 5,761,874 $ 5,365,126 520/ 4,278,000 2,295,063 2,294,959 1,983,041 540/ 500 1 32 468 60/ 10,000,000 5,699,002 6,337,518 3,662,482 630/ 7,600 6,644 10,796 (3,196) 1420/ 870,000 529,162 583,066 286,934 670/ 1,410,000 1,105,355 1,117,008 292,992 790r 595,000 489,128 563,428 31,572 950/ 284,000 204,210 209,730 74,270 740r 953,000 514,074 496,381 456,619 520/ 894,600 528,207 483,064 411,536 540/ 471,900 299,942 332,213 139,687 700/ 792,000 460,775 479,212 312,788 610/ 523,000 322,813 293,198 229,802 560r 55,200 52,580 48,415 6,785 880/ 350 143 - 350 00/ 306,000 143,456 154,393 151,607 5001 32,568,150 18,470,834 19,165,287 13,402,863 59F 250 450 100 150 400/ 700 - 20 680 30r 40,000 18,595 42,307 (2,307) 1060/ 702,700 500,753 523,616 179,084 750/ 41,000 22,286 20,913 20,087 5101 100,600 32,964 24,677 75,923 250/ 384,000 271,246 199,970 184,030 520/ 250,000 138,903 140,724 109,276 560/ 63,000 51,550 60,775 2,225 960/ 30,000 14,440 30,173 (173) 1010/ 650,600 433,381 482,204 168,396 740/ 24,000 8,799 11,708 12,292 490r 55,000 35,101 65,441 (10,441) 1190/ 20,000 11,328 12,505 7,495 630r 2,361,850 1,539,796 1,615,133 746,717 680, 9,000 6,464 5,237 3,763 580/ - - 992 (992) 00/ 11,100 916 718 10,382 60r - 3,947 - - 00/ 3,448 307 (307) 00/ - - 2,000 (2,000) 00/ - 379,270 - - 00/ 273,000 - - 273,000 00/ - 6,000 - - 00/ 168,950 - - 00/ 210,500 - - 210,500 00/ 16,740 8,070 10,776 5,964 640r 13,070 10,362 10,942 2,128 840/ 45,600 36,923 38,827 6,773 850/ 60,000 35,791 49,330 10,670 820/ 4,500 5,143 3,497 1,003 780/ - 53,334 56,744 (56,744) 00/ 261,500 216,694 221,986 39,514 850/ 343,200 167,820 166,379 176,821 480/ - 13,780 (13,780) 00/ - 27,216 - - 00/ 1,000 335 279 721 280i 550 - - 550 00/ - 66,000 - - 00/ 1,249,760 1,196,682 581,793 667,967 470, O O. C O C LL z r c O 2 N N O N 3 O CL O C R C iL z C O C d z t� t0 a 7 2022 Local Retail Sales/Use Tax revenues are $638,516 higher than 2021 revenues. Please also see pagespages 5 & 6. 21 1 Packet Pg. 58 1 2.3.a Page 2 of 3 C TTY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Revenues Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS 2 ATM SURCHARGE FEES 3 CREDIT CARD FEES 4 COURT RECORD SERVICES 5 D/M COURT REC SER 6 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 PAYMENTSFROM 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 40 TAXABLE RECREATION ACTIVITIES 41 HOLIDAY MARKET REGISTRATION FEES 42 UPTOWN EVENING MARKET FEES 43 WINTER MARKET FEES 44 BIRD FEST REGISTRATION FEES 45 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 3,566 $ 3,241 $ (241) 1080/ 600 98 141 459 230/ 11,000 3,322 441 10,559 40r 150 2 1 149 10/ 300 - - 300 00/ - 168 - - 00/ 4,000 98 98 3,902 20/ 1,000 375 54 946 501 50 117 128 (78) 2560/ 100 - - 100 00/ 25,000 - - 25,000 00/ 600 - - 600 00/ 1,000 165 51 949 501 5,000 - - 5,000 00/ 180,000 147,941 130,437 49,563 720/ 1,400 - 2,885 (1,485) 2060/ 85,000 49,902 66,573 18,427 780/ 10,000 - 2,873 7,127 290/ 30,000 - - 30,000 00/ 14,000 2,505 3,169 10,831 230/ 210,970 153,619 105,485 105,485 5001 - 20 25 (25) 00/ 57,000 45,982 49,842 7,158 870/ 1,050 309 702 348 670r 38,000 18,812 11,221 26,779 300/ 3,000 610 371 2,629 120i 10,000 16,202 17,049 (7,049) 1700/ 3,500 1,427 460 3,040 130/ 1,007,500 465,101 486,524 520,976 480r 2,500 2,140 2,356 144 940/ 100 - - 100 00/ 65,600 70,163 69,248 (3,648) 1060r 425,000 305,471 212,529 212,471 5001 4,000 11,349 9,371 (5,371) 2340/ 500 158 110 390 220/ 3,000 3,700 4,440 (1,440) 1480/ 14,000 10,450 10,375 3,625 740/ 13,000 31 1,272 11,728 100/ 1,011,580 315,996 385,188 626,392 380/ 1,300 - - 1,300 00/ 5,000 3,885 370 4,630 70/ - 2,040 4,290 (4,290) 00/ - - 7,310 (7,310) 00/ 1,000 - - 1,000 00/ 4,011,558 1,966,602 687,450 3,324,108 170/ 7,261,358 3,602,324 2,276,080 4,985,278 310i 22 Packet Pg. 59 2.3.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Revenues Revenues Remaining %Received FINES AND PENALTIES: 1 PROOF OF VEHICLE INS PENALTY 2 TRAFFIC INFRACTION PENALTIES 3 NC TRAFFIC INFRACTION 4 CRT COST FEE CODE LEG ASSESSMENT (LGA) 5 NON -TRAFFIC INFRACTION PENALTIES 6 OTHER INFRACTIONS'04 7 PARKING INFRACTION PENALTIES 8 PARK/INDDISZONE 9 DWI PENALTIES 10 DUI - DP ACCT 11 CRIM CNV FEE DUI 12 DUI - DP FEE 13 CRIMINAL TRAFFIC MISDEMEANOR 8/03 14 CRIMINAL CONVICTION FEE CT 15 CRIM CONV FEE CT 16 OTHER NON-T RAF MISDEMEANOR PEN 17 OTHER NON TRAFFIC MISD. 8/03 18 COURT DV PENALTY ASSESSMENT 19 CRIMINAL CONVICTION FEE CN 20 CRIM CONV FEE CN 21 PUBLIC DEFENSE RECOUPMENT 22 BANK CHARGE FOR CONV. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIES RENTALS 30 BRACKET ROOM RENTAL 31 LEASES LONG TERM 32 DONATION/CONTRIBUTION 33 PARKS DONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHER JUDGEMENT/SETTLEMENT 40 POLICE JUDGMENT S✓RESTITUTION 41 CASHIERS OVERAGES✓SHORTAGES 42 OTHER MISCREVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - MUNICIPAL COURT 46 NSF FEES -POLICE 47 NSF FEES - DEVELOPMENT SERVICES 48 US BANK REBATE TRANSFERS -IN: 49 OPERATING TRANSFER IN 50 INTERFUND TRANSFER FROM FUND 018 51 TRANSFER FROM FUND 127 TO TAL GENERAL FUND REVENUE $ 2,000 $ 1,668 $ 968 $ 1,032 480/ 230,000 119,851 37,523 192,477 160/ 18,000 6,214 2,599 15,401 140/ 10,000 8,783 2,504 7,496 250/ 1,000 6,803 - 1,000 00/ 1,500 997 698 802 470/ 100,000 35,562 13,372 86,628 130/ 2,000 250 114 1,886 60/ 7,000 4,189 2,005 4,995 290/ 300 73 47 253 160/ 100 59 18 82 180/ 1,500 1,098 838 662 560/ 25,000 9,835 5,838 19,162 230/ 2,000 1,221 860 1,140 430/ 700 56 103 597 150/ 100 12 - 100 00/ 10,000 764 8,383 1,617 840/ 800 215 27 773 30/ 1,000 159 225 775 220/ 200 64 - 200 00/ 8,000 3,475 1,933 6,067 240/ 14,000 5,184 1,827 12,173 130/ 3,000 1,191 196 2,804 70/ 10,100 - 50 10,050 00/ 150 187 - 150 00/ 448,450 207,909 80,130 368,320 IF 270,390 207,006 129,961 140,429 480/ 13,340 4,670 5,047 8,293 380/ 10,180 5,010 3,225 6,955 320/ 153,000 47,383 96,212 56,789 630/ 2,100 - - 2,100 00/ 205,000 112,074 120,296 84,704 590/ 2,500 - 239 2,261 100/ 3,500 750 5,050 (1,550) 1440/ 1,500 1,510 1,515 (15) 1010/ 5,000 3,503 249 4,751 50/ 300 118 76 224 250/ 3,800 6,371 1,761 2,039 460/ 2,000 - - 2,000 00/ 2,000 102 - 2,000 00/ 200 50 55 145 280/ - 21 100 (100) 00/ 41,180 4,822 4,550 36,630 110/ 100 68 36 64 360/ 100 30 30 70 300/ 150 - 30 120 200/ - 30 - - 00/ - - 60 (60) 00/ 8,500 7,079 5,970 2,530 700/ 724,840 4009597 374,460 350,380 52°/ 28,445 - - 00/ - 123,581 - - 00/ 26,300 13,150 13,150 13,150 500/ 26,300 165,176 13,150 13,150 500/ $ 44,640,708 $ 25,583,320 $ 24,106,033 $ 20,534,675 540/ 23 Packet Pg. 60 I 2.3.a I Page 1 of 6 CITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 19,196,413 $ 9,886,954 $ 10,104,040 $ 9,092,373 53°/a 2 OVERTIME 594,080 352,609 644,898 (50,818) 1090/0 3 HOLIDAY BUY BACK 294,001 3,558 10,798 283,203 4°/a 4 BENEFITS 6,820,049 3,695,644 3,768,602 3,051,447 5501c 5 UNIFORMS 119,151 42,751 51,197 67,954 430% 6 PENSION AND DISABILITY PAYMENTS 70,944 - 48,981 21,963 69°/a 7 SUPPLIES 481,165 238,730 248,442 232,723 52% 8 FUEL CONSUMED - 125 - - 0°/a 9 SMALL EQUIPMENT 204,019 91,741 96,178 107,841 470/a 10 PROFESSIONAL SERVICES 17,411,043 7,386,112 8,621,986 8,789,057 50ON 11 COMMUNICATIONS 171,235 105,171 83,900 87,335 49% 12 TRAVEL 81,155 15,729 32,784 48,371 40% 13 EXCISE TAXES 16,500 13,189 17,159 (659) 104°/a 14 RENTAL/LEASE 2,091,693 883,252 1,176,114 915,579 56% 15 INSURANCE 503,161 405,121 503,160 1 1MON 16 UTILITIES 529,462 305,613 325,757 203,705 620/c 17 REPAIRS& MAINTENANCE 1,090,350 301,053 258,460 831,890 24ON 18 MISCELLANEOUS 652,023 273,974 298,849 353,174 46°/a 19 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 50,000 - 100% 20 BUILDINGS - - 45,195 (45,195) 0% 21 INTERFUND SUBSIDIES 1,385,000 234,945 542,500 842,500 39% 22 MACHINERY/EQUIPMENT - - 96,343 (96,343) 00/0 23 CONSTRUCTION PROJECTS 270,180 - 270,180 00/0 24 GENERAL OBLIGATION BOND PRINCIPAL 55,170 - - 55,170 00/0 25 INTEREST ON LONG-TERM EXTERNAL DEBT 4,790 60,087 72,294 (67,504) 15090/c 26 DEBT ISSUE COSTS 268,788 - - 268,788 0% 27 OTHER INTEREST & DEBT SERVICE COSTS 500 212 288 42% 52,3 0,872 24,346,357 27,097,845 25,2 3,027 5207c LEOFF-MEDICAL INS. RESERVE(009) 28 BENEFITS $ - $ 105,903 $ 104,944 $ (104,944) 00/0 29 PENSION AND DISABILITY PAYMENTS 252,990 71,025 51,398 201,592 200/c 30 PROFESSIONAL SERVICES 7,000 17,000 13,704 (6,704) 196% 31 MISCELLANEOUS 500 - 485 15 970/c 260,490 1937928 170,531 89,959 65% HISTORIC PRESERVATION GIFT FUND (014) 32 SUPPLIES $ 100 $ $ - $ 100 0°/a 33 PROFESSIONAL SERVICES 200 200 00/0 34 MISCELLANEOUS 5,600 5,600 00/0 5,900 - 5,900 0% BUILDING MAINTENANCE FUND (016) 35 PROFESSIONAL SERVICES $ 195,000 $ $ 450 $ 194,550 0% 36 REPAIR&MAINTENANCE 150,000 16,072 133,928 110/0 37 MACHINERY/EQUIPMENT 90,000 552 89,448 10/0 38 CONSTRUCTION PROJECTS 110,000 - 110,000 0% 545,000 17,074 527,926 30/c MARSH RESTORATION & PRESERVATION (017) 39 PROFESSIONAL SERVICES $ - $ 16,149 $ - $ - 00/0 - 16,149 - - 00/0 EDMONDS HOMELESSNESS RESPONSEFUND (018) 40 PROFESSIONAL SERVICES $ 200,000 $ - $ - $ 200,000 00/0 41 INTERFUND SUBSIDIES - 123,581 - 0°/a 200,000 123,581 200,000 0% EDMONDS OPIOED RESPONSEFUND (019) 42 INTERFUND SUBSIDIES $ - $ 28,445 $ $ - 00/0 - 28,445 - 0% DRUG INFO RCEMENTFUND (104) 43 PROFESSIONAL SERVICES $ 45,000 $ - $ $ 45,000 00/0 44 REPAIR/MAINT 800 800 0% 45,800 45,800 00/0 a 24 Packet Pg. 61 Page 2 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent STREETFUND (111) 1 SALARIES AND WAGES $ 749,110 $ 435,405 $ 406,779 $ 342,331 54% 2 OVERTIME 38,400 26,589 21,222 17,178 55% 3 BENEFITS 347,919 213,572 199,032 148,887 57% 4 UNIFORMS 6,000 5,432 3,912 2,088 65% 5 SUPPLIES 263,000 105,334 104,145 158,855 40% 6 SMALL EQUIPMENT 20,000 3,565 985 19,015 5% 7 PROFESSIONAL SERVICES 23,210 7,396 11,039 12,171 48% 8 COMMUNICATIONS 4,500 3,988 3,687 814 82% 9 TRAVEL 1,000 - - 1,000 0% 10 RENTAL/LEASE 290,150 143,256 170,584 119,566 59% 11 INSURANCE 184,111 148,533 184,111 0 100% 12 UTILITIES 273,730 141,461 132,316 141,414 48% 13 REPAIRS& MAINTENANCE 72,000 10,793 22,493 49,507 31% 14 MISCELLANEOUS 8,000 11,421 3,396 4,604 42% 15 MACHINERY/EQUIPMENT 30,000 - - 30,000 0% 16 GENERAL OBLIGATION BOND PRINCIPAL 4,270 - - 4,270 0% 17INTEREST 380 220 185 195 49% $ 2,315,780 $ 1,256,963 $ 1,263,886 $ 1,051,894 55% COMBINED STREETCONST/IMPROVE(112) 18 PROFESSIONAL SERVICES $ 3,159,560 $ 630,663 $ 277,159 $ 2,882,401 9% 19 REPAIR & MAINTENANCE 1,508,270 14,236 31,326 1,476,944 2% 20 INTERFUND SUBSIDIES 108,975 39,925 - 108,975 0U/a 21 LAND - (842) 69,759 (69,759) 0% 22 CONSTRUCTION PROJECTS 8,018,521 549,545 270,868 7,747,653 3% 23 INTERGOVERNMENTAL LOANS 72,220 72,201 72,201 19 100% 24 INTEREST 1,250 1,591 1,230 20 98% $ 12,868,796 $ 1,307,320 $ 722,544 $ 12,146,252 6% MUNICIPAL ARTS ACQUIS. FUND (117) 25 SUPPLIES $ 4,700 $ 265 $ 930 $ 3,770 20% 26 SMALL EQUIPMENT 1,700 - - 1,700 0% 27 PROFESSIONAL SERVICES 180,000 19,862 57,429 122,571 32% 28 TRAVEL 80 - - 80 0% 29 RENTAL/LEASE 2,000 - 2,000 0% 30 REPAIRS & MAINTENANCE 300 - - 300 0% 31 MISCELLANEOUS 6,600 2,191 2,340 4,260 35% $ 195,380 $ 22,318 $ 60,699 $ 134,681 31% HO TEL/MO TEL TAX REV NUE FUND (120) 32 PROFESSIONAL SERVICES $ 95,900 $ 30,289 $ 34,018 $ 61,882 35% 33 MISCELLANEOUS 1,000 - - 1,000 0% 34 INTERFUND SUBSIDIES 4,000 2,000 2,000 2,000 50% $ 100,900 $ 32,289 $ 36,018 $ 64,882 36U/a EMPLO YEE PARKING 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 $ $ $ 3,000 0% $ 3,000 $ $ $ 3,000 0% TO URISM PRO MO TIO NAL FUND/ARTS (123) 38 PROFESSIONAL SERVICES $ 28,200 $ $ 533 $ 27,667 2% $ 28,200 $ $ 533 $ 27,667 2% O O. d is C O C IL z C O 2 N N O N 3 O CL O 2 U C O C LL z r C O 7 C d s t� t0 a 25 Packet Pg. 62 I 2.3.a I Page 3 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) SUPPLIES $ 21,000 $ 36,880 $ 13,609 $ 7,391 65% PROFESSIONAL SERVICES 469,320 86,569 241,246 228,074 51% REPAIRS& MAINTENANCE 668,258 72,284 98,419 569,839 15010 INTERFUND SUBSIDIES 2,534 - - 2,534 00/0 CONSTRUCTION PROJECTS 3,428,576 50,288 635,174 2,793,402 190/0 $ 4,589,688 $ 246,022 $ 988,448 $ 3,601,240 220/c REAL ESTATE EXCISE TAXI (126) 6 PROFESSIONAL SERVICES 7 REPAIRS& MAINTENANCE 8 INTERFUND SUBSIDIES 9 CONSTRUCTION PROJECTS 10 GENERAL OBLIGATION BONDS 11 INTEREST 12 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 13 SUPPLIES 14 PROFESSIONAL SERVICES 15 MISCELLANEOUS 16 INTERFUND SUBSIDIES CEMETERY MAINTENANCEIIMPROVEMENT(130) 17 SALARIES AND WAGES 18 OVERTIME 19 BENEFITS 20 UNIFORMS 21 SUPPLIES 22 SUPPLIES PURCHASED FOR INVENTORY/RESALE 23 PROFESSIONAL SERVICES 24 COMMUNICATIONS 25 TRAVEL 26 RENTAL/LEASE 27 UTILITIES 28 REPAIRS &MAINTENANCE 29 MISCELLANEOUS PARKS TRUSTFUND (136) 30 PROFESSIONAL SERVICES CEMETERY MAINTENANCE TRUST FUND (137) 31 SMALL EQUIPMENT 32 MACHINERY/EQUIPMENT SISTER CITY COMMISSION (138) 33 SUPPLIES 34 TRAVEL 35 MISCELLANEOUS BUSINESS IMPROVEMENTDISTRICTFUND (140) 36 SUPPLIES 37 PROFESSIONAL SERVICES 38 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 39 PROFESSIONAL SERVICES TREE FUND (143) 40 SUPPLIES 41 PROFESSIONAL SERVICES 42 LAND 2012 LTGO DEBTSERVIC FUND (231) 43 GENERAL OBLIGATION BOND 44 INTEREST $ 673,827 $ 231,419 $ 59,381 $ 614,446 90/0 878,353 51,435 16,897 861,456 20/c 144,970 11,863 10,138 134,833 7% 526,057 272,726 97,473 428,584 19% 149,820 - - 149,820 0% 110,640 1,282 55,314 55,326 50% - - 380 (380) 0% $ 2,483,667 $ 568,724 $ 239,583 $ 2,244,084 10% $ 45,000 $ 19,729 $ 7,110 $ 37,890 16% 6,500 - - 6,500 0% 600 - - 600 0% 26,300 13,150 13,150 13,150 50% $ 78,400 $ 32,879 $ 20,260 $ 58,140 26% $ 119,837 $ 57,696 $ 59,360 $ 60,477 50% 3,500 302 788 2,712 23% 41,069 23,304 22,941 18,128 56% 1,000 - - 1,000 0% 7,000 1,355 636 6,364 9% 20,000 18,724 10,702 9,298 54% 4,200 800 1,150 3,050 27% 1,700 982 1,004 696 59% 500 - - 500 0% 11,690 9,713 6,857 4,833 59% 5,565 2,687 2,540 3,025 46% 500 - 3,536 (3,036) 707% 4,000 2,567 3,981 19 100% $ 220,561 $ 118,129 $ 113,496 $ 107,065 51% $ 50,000 $ $ 2,540 $ 47,460 5% $ 50,000 $ $ 2,540 $ 47,460 5% $ 25,000 $ - $ - $ 25,000 0% - 19,211 - - 0% $ 25,000 $ 19,211 $ - $ 25,000 0% $ 1,500 $ $ $ 1,500 0% 4,500 4,500 0% 5,900 70 5,830 1% $ 11,900 $ $ 70 $ 11,830 1% $ 4,050 $ 394 $ 6,211 $ (2,161) 153% 77,535 28,529 29,441 48,094 38% 6,095 1,221 755 5,340 12% 87,680 30,144 36,407 51,273 42% $ 6,077,492 $ $ 461,521 $ 5,615,971 8% 6,077,492 461,521 5,615,971 8% $ 1,000 $ $ $ 1,000 0% 14,800 14,800 0% 199,000 199,000 0% 214,800 214,800 0% $ 550,000 $ - $ - $ 550,000 0% 61,370 40,853 41,009 20,361 67% $ 611,370 $ 40,853 $ 41,009 $ 570,361 7` O Q d w i0 C O c li z r C O 2 N N O N 3 O M O lY U C R C M 21 z C O 2 21 7 C d E z U M 4� a 26 Packet Pg. 63 I 2.3.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL Title 2022 Amended Budget 7/31/2021 Expenditures 7/31/2022 Expenditures Amount Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 95,832 $ 132,730 $ 256,601 $ (160,769) 268% 2 INTERFUND SUBSIDIES 63,000 - 62,656 344 990/0 3 CONSTRUCTION PROJECTS 7,357,188 - 26,059 7,331,129 0% 4 INTEREST - 111,039 2,593,779 (2,593,779) 0% 5 DEBT ISSUE COSTS 98,398 - - 98,398 0% $ 7,614,418 $ 243,769 $ 2,939,095 $ 4,675,323 39% WATER FUND (421) 6 SALARIES AND WAGES 7 OVERTIME 8 BENEFIT S 9 UNIFORMS 10 SUPPLIES 11 WATER PURCHASED FOR RESALE 12 SUPPLIES PURCHASED FOR INVENTORY/RESALE 13 SMALL EQUIPMENT 14 PROFESSIONAL SERVICES 15 COMMUNICATIONS 16 TRAVEL 17 EXCISE TAXES 18 RENTAL/LEASE 19INSURANCE 20 UTILITIES 21 REPAIRS& MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 MACHINERY/EQUIPMENT 25 CONSTRUCTION PROJECTS 26 GENERAL OBLIGATION BONDS 27 REVENUE BONDS 28 INTERGOVERNMENTAL LOANS 29 INTEREST 30 OTHER INTEREST & DEBT SERVICE COSTS STORM FUND (422) 31 SALARIES AND WAGES 32 OVERTIME 33 BENEFITS 34 UNIFORMS 35 SUPPLIES 36 SMALL EQUIPMENT 37 PROFESSIONAL SERVICES 38 COMMUNICATIONS 39 TRAVEL 40 EXCISE TAXES 41 RENTAL/LEASE 42INSURANCE 43 UTILITES 44 REPAIR & MAINTENANCE 45 MISCELLANEOUS 46 INTERFUND SUBSIDIES 47 CONSTRUCTION PROJECTS 48 GENERAL OBLIGATION BONDS 49 REVENUE BONDS 50 INTERGOVERNMENTAL LOANS 51 INTEREST 52 OTHER INTEREST & DEBT SERVICE COSTS $ 842,096 $ 383,026 $ 442,505 $ 399,591 53% 24,000 12,623 7,509 16,491 31% 330,100 165,487 186,506 143,594 56% 4,000 3,222 2,659 1,341 66% 150,000 50,352 86,409 63,591 58% 2,170,000 828,238 878,940 1,291,060 41% '- 170,000 116,024 90,186 79,814 5 3 % 0 CL 11,000 3,917 2,692 8,308 24% 41 2,237,439 1,225,335 357,654 1,879,785 16% 30,000 16,898 18,303 11,697 61% i0 200 - - 200 0% .v 1,649,700 773,963 749,620 900,080 45% M 152,590 74,497 87,940 64,650 5 8 % S 122,359 98,196 122,359 (0) 100% LL 35,000 16,590 18,843 16,157 54% 176,130 18,537 23,203 152,927 13% 123,600 103,151 112,618 10,982 91% p 645,370 198,136 194,533 450,837 3 0 % M 10,000 - 10,044 (44) 100% N 1,998,334 7,513 87,212 1,911,122 4% p 2,870 - - 2,870 0% N 399,780 - - 399,780 0% 25,840 25,839 25,839 1 100% 180,580 98,336 104,805 75,775 5 8 % v - - 378 (378) 0% $ 11,490,988 $ 4,219,882 $ 3,610,757 $ 7,880,231 31% Q. w $ 734,284 $ 403,768 $ 445,089 $ 289,195 61% 26,000 15,739 10,792 15,208 42% 294,767 175,860 185,073 109,694 63% C 6,500 5,049 5,543 957 85% C 46,000 22,824 30,874 15,126 67% LL 4,000 304 985 3,015 25% 3,481,263 961,163 479,713 3,001,550 14% z 3,200 3,591 3,229 (29) 101% = 4,300 150 1,982 2,318 46% G 470,100 348,881 385,427 84,673 82% 2 267,150 154,076 153,466 113,684 57% 82,335 66,228 82,335 (0) 100% 10,500 8,292 9,258 1,242 88% 67,130 19,629 12,402 54,728 18% d 232,300 147,195 120,211 112,089 52% E 297,787 76,327 74,810 222,977 25% v 3,137,333 100,618 281,617 2,855,716 9% M 104,540 - - 104,540 0% Q 195,390 - - 195,390 0% 53,590 53,576 61,590 (8,000) 115% 101,180 58,672 61,859 39,321 61% - - 165 (165) 0% $ 9,619,649 $ 2,621,939 $ 2,406,422 $ 7,213,227 25% 27 Packet Pg. 64 I 2.3.a I Page 5 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,090,461 $ 1,022,074 $ 1,057,085 $ 1,033,376 51°/a 2 OVERTIME 95,000 75,744 80,217 14,783 840/c 3 BENEFITS 847,408 452,348 423,799 423,609 50°/a 4 UNIFORMS 9,500 8,291 7,643 1,857 80°/a 5 SUPPLIES 421,000 231,036 176,105 244,895 42% 6 FUEL CONSUMED 60,000 52,818 - 60,000 0% 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 00/0 8 SMALL EQUIPMENT 35,000 79,889 99,144 (64,144) 283°/a 9 PROFESSIONAL SERVICES 2,315,884 3,053,848 1,258,368 1,057,516 54% 10 COMMUNICATIONS 43,000 24,126 26,166 16,834 610/c 11 TRAVEL 5,000 1,919 - 5,000 00/0 12 EXCISE TAXES 978,000 642,628 611,317 366,683 630/c 13 RENTAL/LEASE 317,410 216,261 186,374 131,036 59°/a 14 INSURANCE 202,407 162,851 203,936 (1,529) 1010/0 15 UTILITIES 1,532,060 739,572 1,488,020 44,040 97°/a 16 REPAIR&MAINTENANCE 790,630 240,953 538,194 252,436 680/o 17 MISCELLANEOUS 126,350 - 68,126 58,224 540/u 18 MACHINERY/EQUIPMENT - 78,431 145,210 (145,210) 0% 19 INTERFUND SUBSIDIES 6,388,519 1,953,015 1,175,403 5,213,116 180/c 20 CONSTRUCTION PROJECTS 12,520,297 5,292,686 1,989,039 10,531,258 160/Q 21 GENERAL OBLIGATION BONDS 126,500 - - 126,500 0% 22 REVENUE BONDS 89,840 - - 89,840 0% 23 INTERGOVERNMENTAL LOANS 174,610 158,667 159,017 15,593 91O/C 24 INTEREST 356,980 199,266 179,830 177,150 500/c 25 DEBT ISSUE COSTS - 1,518 - - 0% 26 OTHER INTEREST & DEBT SERVICE COSTS - 2 252 2 959 (2 959) 0% $ 29,529,856 $ 14,690,197 $ 9,875,949 $ 19,653,907 3 3 % BOND RESERVEFUND (424) 27 REVENUE BONDS $ 810,010 $ - $ - $ 810,010 0% 28 INTEREST 1,178,700 600,417 589,342 589,358 50% $ 1,988,710 $ 600,417 $ 589,342 $ 1,399,368 300/a O CL O io C M c li z r C O 2 N N O N 7 O M O U C M C LL z r C O 7 r C d 1= z t� c0 a 2s Packet Pg. 65 I 2.3.a I Page 6 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPNIENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 275,712 $ 159,491 $ 181,823 $ 93,889 66°/a 2 OVERTIME 2,000 1,573 222 1,778 110/0 3 BENEFITS 112,077 66,538 61,625 50,452 55ON 4 UNIFORMS 1,500 1,056 880 620 590/0 5 SUPPLIES 120,000 41,279 62,466 57,534 52% 6 FUEL CONSUMED 1,000 - - 1,000 0% 7 SUPPLIES PURCHASED FOR INVENT ORY/RESALE 268,000 110,454 238,812 29,188 890/0 8 SMALL EQUIPMENT 58,000 5,979 2,380 55,620 4% 9 PROFESSIONAL SERVICES 46,750 776 862 45,888 2% 10 COMMUNICATIONS 3,000 1,316 1,184 1,816 39% 11 TRAVEL 1,000 - - 1,000 0% 12 RENTAL/LEASE 11,160 7,204 6,057 5,103 54% 13INSURANCE 49,172 39,334 51,903 (2,731) 106% 14 UTILITIES 14,000 10,232 12,317 1,683 88% 15 REPAIRS& MAINTENANCE 60,000 23,974 16,678 43,322 28% 16 MISCELLANEOUS 12,000 8,365 5,722 6,278 48% 17 MACHINERY/EQUIPMENT 915,000 322,273 118,526 796,474 13% $ 1,950,371 $ 799,843 $ 761,458 $ 1,188,913 39% TEC HNO LO GY RENTAL FUND (512) 18 SALARIES AND WAGES $ 442,074 $ 178,504 $ 178,904 $ 263,170 40% 19 OVERTIME 2,000 1,987 677 1,323 34% 20 BENEFITS 159,538 61,553 69,227 90,311 43% 21 SUPPLIES 5,000 3,089 4,784 216 96% 22 SMALL EQUIPMENT 357,900 18,305 27,832 330,068 8% 23 PROFESSIONAL SERVICES 61,860 22,224 18,203 43,657 29% 24 COMMUNICATIONS 58,770 43,855 41,979 16,791 71% 25 TRAVEL 1,500 - - 1,500 0% 26 RENTAL/LEASE 7,460 5,348 2,602 4,858 35% 27 REPAIRS & MAINTENANCE 381,920 236,516 399,603 (17,683) 105% 28 MISCELLANEOUS 5,000 1,205 1,280 3,720 26% 29 MACHINERY/EQUIPMENT 56,000 - 26,346 29,654 47% $ 1,539,022 $ 572,585 $ 771,437 $ 767,585 50% FIREMAN'S PENSION FUND (617) 30 BENEFITS $ - $ 15,483 $ - $ - 0% 31 PENSION AND DISABILITY PAYMENTS - 36,149 - - 0% 32 PROFESSIONAL SERVICES 11,500 - - 0% $ - $ 63,132 $ - $ - 0% TOTAL EXPENDITURE ALL FUNDS $ 147,140,570 $ 52,195,076 $ 52,226,924 $ 94,913,646 35% O M O io C M C li 21 z r C O 2 N N 0 N 3 O M O U C M C li 21 z r C O 2 7 r C d 1= z t� t0 a 29 Packet Pg. 66 2.3.a Page 1 of 1 C ITY O F IDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT CITY CLERK ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPARTMENTAL POLICE SERVICES SATELLITE OFFICE COMMUNITY SERVICES✓ECONOMIC DEV DEVELOPMENT SERVICES HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE Title $ 497,900 $ 192,621 $ 188,068 $ 309,832 38% 443,913 194,309 208,847 235,066 47% 824,831 419,004 537,794 287,037 65% 1,368,755 622,191 691,341 677,414 51% - 363,075 - - 0% 2,156,911 766,314 1,236,936 919,975 57% 971,780 492,368 545,067 426,713 56% _ 0 O CL 15,574,121 7,203,386 8,530,659 7,043,462 55% 13,375,470 6,626,850 7,213,970 6,161,500 54% io 166,576 - 50,104 116,472 30% CM C 719,388 308,903 288,425 430,963 40% j,i 21 3,791,859 1,730,845 1,985,079 1,806,780 52% r 459,109 31,912 60,031 399,078 13% 0 O 2 5,125,535 2,366,948 2,564,042 2,561,493 50% N N 3,459,449 1,857,140 1,761,183 1,698,266 51% N 3,425,275 1,170,492 1,236,300 2,188,975 36% 2+ 3 $ 52,360,872 $ 24,346,357 $ 27,097,845 $ 25,263,027 52% O 0. O CITY OF EDMO NDS U C EXPENDITURES - UTILITY- BY FUND IN SUMMARY C LL 2022 Amended 7/31/2021 7/31/2022 Amount Budget Expenditures Expenditures Remaining %Spent r WATER UTILITYFUND $ 11,490,988 $ 4,219,882 $ 3,610,757 $ 7,880,231 31% r_ 0 STORM UTILITY FUND 9,619,649 2,621,939 2,406,422 7,213,227 25% 2' SEWER/WWTP UTILITY FUND 29,529,856 14,690,197 9,875,949 19,653,907 33% w BOND RESERVE FUND 1,988,710 600,417 589,342 1,399,368 30% d $ 52,629,203 $ 22,132,435 $ 16,482,470 $ 36,146,733 31% s t� t0 a 30 Packet Pg. 67 I 2.3.a I Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2022 Amended Budget 7/31/2021 Expenditures 7/31/2022 Expenditures Amount Remaining %Spent CPIY COUNCIL SALARIES AND WAGES $ 204,132 $ 116,857 $ 107,870 $ 96,262 53% BENEFITS 121,868 60,816 53,993 67,875 44% SUPPLIES 2,000 1,708 1,194 806 60% SERVICES 169,900 13,241 25,011 144,889 15% $ 497,900 $ 192,621 $ 188,068 $ 309,832 38% O FFIC E O F MAYO R SALARIES AND WAGES $ 232,296 $ 133,872 $ 145,000 $ 87,296 62% BENEFITS 81,787 48,767 49,915 31,872 61% SUPPLIES 1,500 358 1,664 (164) 111% SERVICES 128,330 11,312 12,268 116,062 10% $ 443,913 $ 194,309 $ 208,847 $ 235,066 47% HUMAN RESOURCES O CL SALARIES AND WAGES $ 398,299 $ 225,271 $ 274,667 $ 123,632 69% BENEFITS 142,526 85,669 93,441 49,085 66% SUPPLIES 13,600 1,156 701 12,899 5% SERVICES 270,406 106,907 168,985 101,421 62% C $ 824,831 $ 419,004 $ 537,794 $ 287,037 65% a C MUNICIPAL C O URT 11 SALARIES AND WAGES $ 910,606 $ 392,657 $ 443,519 $ 467,087 49% % BENEFITS 217,654 130,742 137,702 79,952 63% +�+ SUPPLIES 11,600 3,250 6,382 5,218 55% p SERVICES 228,895 95,542 103,738 125,157 45% M $ 1,368,755 $ 622,191 $ 691,341 $ 677,414 51% N C ITY CLERK G N SALARIES AND WAGES $ $ 166,661 $ $ 0% >% BENEFITS 67,480 0% SUPPLIES - 1,306 - 0% 0 SERVICES - 127,628 - 0% O $ - $ 363,075 $ - $ 0% Q' O ADMINIS TRATIVE S ERVIC ES SALARIES AND WAGES $ 1,301,073 $ 509,270 $ 767,273 $ 533,800 59% BENEFITS 413,858 165,579 241,657 172,201 58% SUPPLIES 13,000 2,608 7,544 5,456 58% Mr SERVICES 428,980 88,857 220,462 208,518 51% - 'LL $ 2,156,911 $ 766,314 $ 1,236,936 $ 919,975 57% >, C ITY ATTO RNEY r SERVICES $ 971,780 $ 492,368 $ 545,067 $ 426,713 56% G $ 971,780 $ 492,368 $ 545,067 $ 426,713 56% NON -DEPARTMENTAL >+ SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% BENEFITS 145,504 26,878 77,493 68,011 53% SUPPLIES 5,000 1,152 - 5,000 0% d SERVICES 13,557,619 6,830,323 7,788,161 5,769,458 57% E INTERFUND SUBSIDIES 1,435,000 284,945 592,500 842,500 41% DEBT SERVICE - PRINCIPAL 55,170 - - 55,170 0% c�0 DEBT SERVICE - INTEREST 274,078 60,087 72,505 201,573 26% r� Q $ 15,574,121 $ 7,203,386 $ 8,530,659 $ 7,043,462 55% POLICE SERVICES SALARIES AND WAGES $ 8,723,512 $ 4,417,115 $ 4,638,140 $ 4,085,372 53% BENEFIT S 2,994,876 1,570,707 1,638,959 1,355,917 55% SUPPLIES 281,569 125,741 120,925 160,644 43% SERVICES 1,375,513 513,288 719,603 655,910 52% MACHINERY/EQUIPMENT 96,343 (96,343) 0% $ 13,375,470 $ 6,626,850 $ 7,213,970 $ 6,161,500 54% S ATELLITE O FFIC E SALARIES AND WAGES $ 25,000 $ - $ - $ 25,000 0% BENEFIT S 5,000 - 5,000 0% SUPPLIES 12,000 11,057 943 92% SERVICES 124,576 39,047 85,529 31% $ 166,576 $ $ 50,104 $ 116,472 30% 31 Packet Pg. 68 Page 2 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2022 Amended 7/31/2021 7/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY SERVICES/ECON DEV. SALARIES AND WAGES $ 365,627 $ 172,390 $ 117,085 $ 248,542 32% BENEFITS 111,361 52,439 36,228 75,133 33% SUPPLIES 4,075 509 269 3,806 7% SERVICES 238,325 83,565 134,843 103,482 57% $ 719,388 $ 308,903 $ 288,425 $ 430,963 40% DEVELO PMEVT S ERVIC ES /PLANNING SALARIES AND WAGES $ 1,978,832 $ 1,076,844 $ 1,176,411 $ 802,421 59% BENEFITS 681,706 373,058 411,480 270,226 60% SUPPLIES 19,400 4,504 4,503 14,897 23% SERVICES 1,111,921 276,440 392,686 719,235 35% MACHINERY/EQUIPMENT - - - - 0% $ 3,791,859 $ 1,730,845 $ 1,985,079 $ 1,806,780 52% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 101,496 $ 25,730 $ 39,832 $ 61,664 39% BENEFITS 29,113 5,780 10,869 18,244 37% SUPPLIES 15,000 - 442 14,558 3% SERVICES 313,500 402 8,888 304,612 3% 459,109 31,912 60,031 399,078 13% PARKS & REC REATIO N SALARIES AND WAGES $ 2,627,863 $ 1,342,835 $ 1,393,994 $ 1,233,869 53% BENEFITS 865,945 483,263 481,021 384,924 56% SUPPLIES 166,640 110,531 141,392 25,248 85% SERVICES 1,465,087 430,319 547,636 917,451 37% $ 5,125,535 $ 2,366,948 $ 2,564,042 $ 2,561,493 50% PUBLIC WORKS ADMINISTRATION SALARIES AND WAGES $ 387,424 $ 175,970 $ 75,620 $ 311,804 20% BENEFITS 126,689 61,687 36,545 90,144 29% SUPPLIES 9,600 7,381 2,733 6,867 28% SERVICES 90,400 52,064 48,533 41,867 54% $ 614,113 $ 297,102 $ 163,431 $ 450,682 27% FACILITIFS MAINTENANCE SALARIES AND WAGES 860,456 459,908 503,230 357,226 58% BENEFITS 369,679 196,988 203,041 166,638 55% SUPPLIES 128,000 69,597 45,413 82,587 35% SERVICES 1,796,960 443,999 439,421 1,357,539 24% MACHINERY/EQUIPMENT 270,180 - 45,195 224,986 17% $ 3,425,275 $ 1,170,492 $ 1,236,300 $ 2,188,975 36% ENGINEERING SALARIES AND WAGES $ 1,866,128 $ 1,027,744 $ 1,077,095 $ 789,033 58% BENEFITS 702,578 408,543 396,437 306,141 56% SUPPLIES 2,200 795 402 1,798 18% SERVICES 274,430 122,957 123,818 150,612 45% $ 2,845,336 $ 1,560,038 $ 1,597,752 $ 1,247,584 56% TOTAL GENERAL FUND EXPENDITURES $ 52,360,872 $ 24,346,357 $ 27,097,845 $ 25,263,027 52% a 32 Packet Pg. 69 2.3.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 7/31 /2022 7/31 /2022 Q2 YTD Fund Balance Cash Balance 001-General Fund * $ 12,939,537 $ 5,526,986 $ 3,027,697 $ (2,991,812 009-Leoff-Medical Ins. Reserve 197,187 197,187 57,060 (58,031 011-Risk Management Reserve Fund 25,000 25,000 - - 012-ContingencyReserve Fund 1,782,150 1,782,150 - - 0 014-Historic Preservation Gift Fund 16,422 16,421 - - 016-Building Maintenance 4,405,316 4,405,316 1,816 5,316 017 - Marsh Restoration & Preservation 849,767 849,766 - 1,150 c 018 - Edmonds Homelessness Response Fd 200,000 200,000 200,000 200,000 c� Total General Fund & Subfunds $ 20,415,379 $ 13,002,826 $ 3,286,573 $ (2,843,377 �, t c 0 *$8,067,160 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012, represent the required 20% operating reserve. N N No N There are no interfund loans outstanding at this time. , 0 a a� 76 GOVERNMENTAL FUNDS OVERVIEW LL 21 0 BALANCES CHANGE IN FUND BALANCES a , GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- FUNDS 7/31 /2022 7/31 /2022 Q2 YTD c Fund Balance Cash Balance — m E t U General Fund & Subfunds $ 20,415,379 $ 13,002,826 $ 3,286,573 $ (2,843,377 r Q Special Revenue 28,626,946 27,616,390 3,713,230 10,248,224 Capital Projects 2,916,232 2,864,020 (1,252,457) (1,197,631 Total Governmental Funds $ 51,958,557 $ 43,483,236 $ 5,747,347 $ 6,207,216 *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 33 Packet Pg. 70 2.3.a SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 7/31/2022 7/31/2022 Q2 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 76,060 $ 76,560 $ 324 $ 885 111 - Street Fund 675,559 539,074 79,264 (275,606 112 - Combined Street Const/Improve 3,227,073 2,367,211 309,484 988,626 117 - Municipal Arts Acquis. Fund 684,586 688,048 5,634 35,707 �E 120 - Hotel/Motel Tax Revenue Fund 89,509 76,271 6,508 18,395 Q. 121 - Employee Parking Permit Fund 89,249 89,643 4,048 12,725 122 - Youth Scholarship Fund 14,987 15,059 61 727 123 -Tourism Promotional Fund/Arts 114,436 110,369 7,973 18,464 .3 125 - Real Estate Tax2 4,134,739 4,181,051 96,203 81,324 c 126 - Real Estate Excise Tax 1 * 4,136,892 4,087,004 502,714 823,554 ii 127 - Gifts Catalog Fund 3,251,945 3,253,527 2,881,289 2,950,420 21 130- Cemetery Mai ntenance/Improve ment 279,233 280,642 11,419 13,027 136 - Parks Trust Fund 168,027 168,893 (1,822) (563 0 137- Cemetery Maintenance Trust Fund 1,131,625 1,137,322 9,134 24,549 N 138- Sister City Comm ission 18,093 18,173 2,498 2,613 N 140 -Business Improvement Disrict 59,052 59,052 (1,597) 29,920 >, 141 -Affordable and Supportive Housing I'd 191,791 184,398 1,253 32,377 142 - Edmonds Rescue Plan Fund 10,263,218 10,263,218 (201,157) 5,490,838 .. 143 -Tree Fund 20,873 20,873 - 241 0 Total Special Revenue $ 28,626,946 $ 27,616,390 $ 3,713,230 $ 10,248,224 aQi *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $700,000 for the purchase of Open Space. 76 U c c� ENTERPRISE FUNDS OVERVIEW LL O a 21 BALANCES CHANGE IN FUND BALANCES ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- y FUNDS 7/31/2022 7/31/2022 Q2 YTD E t Fund Balance Cash Balance U r r Q 421 -Water Utility Fund $ 30,921,503 $ 8,519,057 $ 556,701 $ 2,194,336 422 -Storm Utility Fund " 16,998,895 6,868,067 278,943 1,351,517 423-Sewer/WWTPUtility Fund 62,337,347 16,962,769 (560,785) 1,984,818 424 - Bond Reserve Fund 846,684 846,684 1,805 2,723 411 -Combined Utility Operation 93,080 146,238 35,770 93,080 Total Enterprise Funds $ 111,197,509 $ 33,342,815 $ 312,433 $ 5,626,474 *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding. *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 34 Packet Pg. 71 2.3.a SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 7/31/2022 7/31/2022 Q2 YTD Fund Balance Cash Balance Governmental Funds $ 51,958,557 $ 43,483,236 $ 5,747,347 $ 6,207,216 Enterprise Funds 111,197,509 33,342,815 312,433 5,626,474 Internal Services Fund 10,487,070 6,062,471 210,841 199,518 Total City-wide Total $ 173,643,136 $ 82,888,522 $ 6,270,621 $ 12,033,208 0 Q. a� 76 U c c� INTERNAL SERVICE FUNDS OVERVIEW c LL 0 a N N O N BALANCES CHANGE IN FUND BALANCES 3 ---- ACTUAL ---- ---- ACTUAL ---- INTERNAL SERVICE FUNDS 7/31/2022 7/31/2022 Q2 YTD Fund Balance Cash Balance 76 511 - Equipment Rental Fund $ 9,504,801 $ 5,252,925 $ 124,919 $ 296,290 c M 512 -Technology Rental Fund 982,268 809,546 85,922 (96,772 Total Internal Service Funds $ 10,487,070 $ 6,062,471 $ 210,841 $ 199,518 21 t c 0 2 2, c m E U 0 r r a *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. 72 2.4 City Council Agenda Item Meeting Date: 09/13/2022 Employee Expense Reimbursement Policy Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The Administrative Services Department works with the Finance Committee to update and improve Finance policies. We would like to bring these updates to the Expense Reimbursement Policy to Committee for discussion. Staff Recommendation Staff recommendation is to review the updates made as a result of last month's discussion and see if there are more suggestions for improvement. Attachments: EMPLOYEE EXPENSES AND REIMBURSEMENTS_Updating Packet Pg. 73 2.4.a City of Edmonds ng �D-�9 G Al J090 ��q0 Employee Expenses, Volunteer Recognition and Reimbursements Policy anuarSeptember 7 2022 Packet Pg. 74 2.4.a City of Edmonds Employee Expenses, Volunteer Recognition and Reimbursement Policy EMPLOYEE EXPENSES. VOLUNTEER RECOGNITION, AND REIMBURSEMENTS General Reimbursement Policy The City of Edmonds reimburses its employees and elected or appointed officials for reasonable expenses incurred conducting City business providing the expenses are prudent and directly related to the individual's service on behalf of the City. The City of Edmonds is best served by the active participation of community citizens as volunteers. Volunteers learn more about their City and contribution to its effectiveness, thereby fostering increased cooperation and understanding. Administration The Finance Director administers the reimbursement program, designs and distributes forms and instruction and carries responsibility for review of claims. Claims will not be allowed without a detailed account of moneyies spent certified by the individual making the claim_. , o ,,,;, o,a 1.., * Documentation Claims for personal reimbursement must be made on official Employee Claim for Expenses form, be accompanied by the vendor's or-iginal-4nvoice, receipt or bankcard charge slip showing the date, vendor name, amount paid and items/services received, and must be eertified ,.efTe t an signed by the individual seeking reimbursement. Should a receipt be lost or not be obtainable, an employee must fill out a Lost Receipt form and attach to the Claim for Expenses signed by his/her Department Head (or Mayor if the employee is a Department Head). This will serve as a substitute for a receipt. The person seeking reimbursement is responsible for ensuring that the reimbursement request is accurate and that receipts or requests are not duplicated. In addition to the documentation above, claims for meals that feed others require the following documentation: 1. The names of the individuals being hosted 2. Their official title or capacity as it relateds to City business 3. The nature of the topics discussed, nature of the occasion, what public purpose or policy was being served (and/or copy of agenda) 4. The -per-son being r-eimbtir-sed midst explain why it was neeessafy to eenduet this business ever- -a meal r-a4her- than on City pf:emises-. Reimbursement is sSubject to budget being available for the event., and preapproval by the Mayor for staff -sponsored events., and by the Council President for Council-s Sponsored events. Employee claims for expenses must be signed by department heads, or in his/her absence, by his/her designee. Department head or acting department head claims must be signed by the Mayor. Council member expenses may be approved either „st be signed by the Council President or by placing the reimbursement request on the Consent Agenda, giving the full Council the opportunity to approve or deny the request. Packet Pg. 75 2.4.a City of Edmonds Employee Expenses, Volunteer Recognition and Reimbursement Policy Whenever possible, City expenses should be paid for using City funds. At times, however, an employee or elected official may find it expedient or necessary to pay for an expenditure usingtheir heir personal funds and seek reimbursement from the City afterwards. When this occurs, the employ or elected official should obtain pre -approval for the expenditure, before usingtheir heir personal funds. If such pre -approval was not obtained, approval after -the -fact is at the sole discretion of their Department Director, the Mayor, or in the case of Council members by placing the he request on the Council Consent agenda, whichever applies. All Employee claims should be submitted in a timely manner; within 3&60 days. No reimbufseme requests will be authorized for- any expenses taking plaee in a pr-eviotts budget yea-F. 0 IL c as E as E as c as 0. x w m m 0 a E w 0 z Q w U) z w IL x w w w O J IL M w c a� E z 0 Q Packet Pg. 76 2.4.a City of Edmonds Employee Expenses, Volunteer Recognition and Reimbursement Policy Food and Beverage •'. ;wed on r-eeemmend-ations from the St -at tor-'s O f ee, tThe City uses the following guidelines in determining the use of public funds for expenditures for food and beverages: 1. Who consumed this food and drink? 2. What was the nature of the occasion for the consumption? 3. What public purpose or policy objective was served? 4. Why . it neeessary t eenstime feedand beverage t eany w the ,.oliey7 -54. Were the expenses "reasonable"? 6-.5. Were the expenses consistent with the policy authorizing reimbursement? The city must also consider Internal Revenue Service regulations covering the income tax consequences of providing food and beverages to employees. Payment for food and beverage expenses that meet the IRS non-taxable criteria will be made through Accounts Payable. Payment for food and beverage expenses that do not meet the IRS non-taxable criteria will be made through Payroll and taxed at the current IRS rate. General IRS Meal Reimbursement Regulations (See following sections for specific examples) Please note that reimbursement for out-of-town travel is covered by ECC 2.25.050, Travel Authorization and Expense Reimbursement Policies The following food and beverage expenses qualify as non-taxable under the IRS code and will be reimbursed through Accounts Payable. 1. Meals consumed while traveling on city business. To qualify as travel the employee must travel a distance of 40 miles or more from Edmonds and stay overnight. 2. Business meals between city employees and non -city employees that can reasonably be expected to bring a specific business benefit to the city_ (e.g. a new store is eentemplating leeating in Edmonds). These meals would t"ieally 4welve the Mayor- and biisiness people seeking to inerease business in Edmonds. Restaurant meals with current or potential city suppliers (vendors/contractors/consultants, etc.) would not qualify under this category. 3. Meal expenses directly related to and necessary for attending business meetings or conventions of organizations directly related to city business. These organizations include chambers of commerce, business leagues and trade or professional organizations such as the American Planning Association, American Public Works Association, etc. 4. Meals provided by the city that meet the following three criteria: a. The meal must be brought to the employee; cash may not be given to the employee to buy a meal. b. The meal must be provided at the city's business premises. This may include temporary work sites, such as a rented -hotel conference room, if business is conducted there. die r-estaiffants do not qualify as busine . Packet Pg. 77 2.4.a City of Edmonds Employee Expenses, Volunteer Recognition and Reimbursement Policy The meal must be provided for the city's convenience and have a sound business justification. Examples include: i. Meals furnished during work hours so employees are available for emergency calls during the meal. Evidence must be provided that an emergency occurred. ii. Meals delivered to the office at a group meeting that spans a mealtime and the Mee ing The following food and beverage expenses are taxable under the IRS code and will be reimbursed through Payroll. 1. Meals consumed while attending local training sessions/classes. Local training means training that does not qualify for travel by being 40 miles or more from the city and requiring an overnight stay. 2. Meals consumed while transporting city or non -city participants to recreation programs. 3. Meals between city employees and/or non -city employees off the city premises that otherwise qualify for reimbursement under city policy. 4. Meals consumed while transporting and/or chaperoning city or non -city participants to city sponsored Parks and Recreation programs or events where paid staff are required for safety and supervision. Examples include, but are not limited to, programs or events at restaurants for senior participants. Claims for taxable meal reimbursements must be submitted to Payroll on an Employee Reimbursement form. Meal reimbursements are included in the employee's regular paycheck. Retreats/Meetings/Training Council Retreats/Executive Team Retreats/Department Retreats to determine goals and objectives for the department/City: The reasonable cost of necessary food and beverages while conducting a C4t�-retreat is authorized for reimbursement. Each depa A, ent will be limited to one Non -taxable -paid through Accounts Payable City Sponsored Training/Staff Meetings: the general rule is that meals and snacks are not reimbursable and are to be purchased by those individuals attending. However, the City will pay reasonable cost of beverages. Non-taxable under the IRS De Minimis meals category paid through Accounts Payable. Non -City Sponsored Training: The City of Edmonds considers training a necessary and reasonable cost of maintaining a high level of excellence in the services we provide. The City will pay for reasonable trainings, conferences, and workshops for employees and elected officials. Training should be approved by an employee's supervisor or Department Director, or the Council President for Council members, prior to registration and payment for the event. Professional Organization Sponsored Training or Seminars/Business Luncheon Meetings: The City will pay the cost of meals included as part of the registration or purchased separately to be consumed at meetings held during a meal time. Examples include the Chamber of Commerce, American Planning Association, Snohomish County Clerks & Finance Officers Association, etc. Non-taxable per specific IRS regulation- paid through Accounts Payable 4 Packet Pg. 78 2.4.a City of Edmonds Employee Expenses, Volunteer Recognition and Reimbursement Policy Awards/Recognition Service Awards Ceremonies: Expenditures for reasonable refreshments served at the Mayor's Annual City-wide Employee Awards Programs, including luncheon to recognize employees with n, 15 and 2 ltts years of service and breakfast or lunch to recognize employees selected for service awards. (Limited to one each per year) Non-taxable under the IRS De Minimis meals category - paid through Accounts Payable. Department Head Appreciation Luncheon: Expenditures for reasonable refreshments served at the Annual Department Head Appreciation Luncheon for only City of Edmonds staff and Council members. (Limited to one per year) Non-taxable under the IRS De Minimis meals category paid through Accounts Payable. Special Events The City policy is to allow for reimbursement for the costs of reasonable refreshments for puie events such as Open Houses, City Anniversary Celebrations, and hosting delegations from other jurisdictions. emit. Non-taxable under the IRS De Minimis meals category paid through Accounts Payable. Birthday Celebrations/ Reti .,,m ent Cell FadOn elcoming Parties: these events are considered private parties and as such represent an inappropriate expenditure of public funds. The cost of any food or beverage or any incidental expenses related to these events (film, flowers, cards, etc.) are not eligible for reimbursements. Retirement Recognition: The City recognizes that it is sometimes appropriate to recognize and acknowledge the contribution that employees have made to the City during their career. The City will pay the reasonable cost of food and beverages at such an event. The City may also pay a reasonable cost for providing a service award to the retiring employee, not to exceed $4-200 in value. Normally when an employee retires there are small items that were issued to the employee that must be returned to the city. Examples of this are credit cards, cell phones, office keys, and IPads. Due to the nature of IPads, unless they are essentially brand new, they have no remaining value after an employee retires and the IPads are disposed of. If an IPad is more than a year old and has no useful value or monetary value to the City, rather than being disposed of, any IPad with no value may be given to the retiree. after being scanned by an Information Services technician to ensure that sensitive or proprietary information has been removed. Volunteers: It is the policy of the City of Edmonds to recognize and acknowledge the contribution that volunteers make to the City. The City will pay the reasonable cost for providing service awards, as well as food and beverages= at an annual recognition event... These are non-taxable to Volunteers. Non-taxable to Employees if held on city premises and meals are provided paid through Accounts Payable. Taxable to Employees if held off city premises -employee's meal reimbursement paid through Payroll. 5 Packet Pg. 79 2.4.a City of Edmonds Employee Expenses, Volunteer Recognition and Reimbursement Policy Meals Business Meals between City Employees: Meals (including snacks) between City Employees will not normally be reimbursed. It is expected that City Business between City employees can for the most part be conducted on City premises during normal work hours. Working Lunches: the City recognizes that there are occasions when it may be necessary for a group of employees to work through lunch in order to meet a deadline or to keep a group convened in order to accomplish the task. To be considered for reimbursement as a working lunch, the meeting must span over a three hour period which includes the group's normal lunch hour and have approval of the Mayor. Non-taxable if the meal is provided on the city premises for the convenience of the city - paid through Accounts Payable Business Meals between City Employees and Non -City Employees: the reasonable costs of necessary meals while conducting City Business with persons other than City employees either locally or out of town are authorized for reimbursement. Employees seeking reimbursement for meals of a non -City person must obtain prior approval from the Mayor. The employee's meal is non- taxable if the meal is provided on the city premises for the convenience of the city or the employee is on out of town travel for the city —paid through Accounts Payable. The employee's meal is non- taxable if it meets the IRS test of providing a specific business benefit to the city (normally only the Mayor will qualify in the specific business benefit category) —paid through Accounts Payable. The employee's meal is taxable if the meal is not related to city travel and is eaten off the city premises paid through Payroll. The meals for the non -city employees are paid through Accounts Payable. 0 Packet Pg. 80 2.5 City Council Agenda Item Meeting Date: 09/13/2022 2020 Audit Follow-up Actions Staff Lead: Council Department: City Council Preparer: Beckie Peterson Background/History During 2020 the City distributed CARES funds to Edmonds individuals and businesses in the form of small grants. These grants had specific requirements attached to them to determine eligibility. As part of a subsequent audit it was determined that some of the grant recipients did not meet the eligibility requirements as laid out by the City. The audit identified 109 recipients who did not provide sufficient information for the city to clearly determine if they were eligible, but who were given grants anyway. Staff has examined the audit results and determined that of the 109 questioned recipients, the City would like to pursue repayment from 33 of the businesses, totaling $268,500. In July, staff sent letters to those businesses requesting that they pay the grant back to the City (see attached draft letter). Recommendation Discuss status of audit follow-up actions. Narrative Council requests an update. Attachments: Letter to Ineligible Businesses Packet Pg. 81 2.5.a CITY OF EDMONDS 121 5TH AVENUE NORTH • EDMONDS. WA 98020 • (425) 771-0240 FINANCE AND INFORMATION SERVICES DEPARTMENT ft)c. 1890 To "Business Name", According to our records, in 2020 your business applied for and received a grant from the City of Edmonds in the amount of $X,XXX. As part of a follow-up audit it has been determined that your business did not meet the requirements that for the grant. Since you were not eligible to receive this grant, we are asking you to repay the money to the City of Edmonds. If you believe there may be mitigating circumstances that would justify your not repaying the grant despite this determination of ineligibility, I ask you to contact me so that you can supply us with that information. Please respond by July 29, 2022. Thank you, Dave Turley Administrative Services Director, City of Edmonds 121 5th Ave N Edmonds WA 98020 Phone 425.275.4688 Dave.Turley@EdmondsWA.Gov • Incorporated August 11, 1890 • Sister City - Hekinan, Japan Packet Pg. 82 2.6 City Council Agenda Item Meeting Date: 09/13/2022 Risk Management Policy Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The City does not have a formal Risk Management Policy approved. We are bringing this draft policy to committee for review. This policy includes both City Risk Management as well as use of the Risk Management Reserve Fund 011. Staff Recommendation For review and discussion. We would like Council feedback before finalizing the policy. Narrative N/A Attachments: Risk Management Policy_Draft Packet Pg. 83 2.6.a City of Edmonds RISK MANAGEMENT POLICIES 1.0 STATEMENT OF PURPOSE The mission of the Risk Management function of the City of Edmonds is to minimize the cost of risk and to maximize protection of City employees and its assets. The Risk Management Program at the City of Edmonds establishes a coordinated program for the processing, adjudication and determination of claim and litigation against the City, its elected officials, officers, and employees. 2.0 RISK MANAGEMENT PROGRAM The Risk Management Program shall be included in the City of Edmonds Human Resource Department. 3.0 MANAGEMENT AND CONTROL OF THE RISK MANAGEMENT PROGRAM • The management and control of the City's Risk Management Program shall be the function of the Risk Manager. • The Risk Manager shall have authority to establish rules and procedures consistent with Council policy to ensure the safety and well-being of employees and the public while on or using City property. • These rules shall be drawn to aid in keeping the City's liability to a minimum and premiums for insurance as low as possible consistent with the insurance requirements and the exposures insured. • The Risk Management Program shall be established as part of the function of the Human Resources department, under control of the department Director with the Administrative Service Director serving as the alternate in the absence of the Human Resources Director. • The City Safety & Disaster Coordinator shall be assigned to the Department of Human Resources. • The City Attorney shall serve as the legal advisor to Risk Management 1036=11,11111*1 • The Risk Manager shall be responsible for reviewing, assessing and controlling the exposures to City employees, property and the general public. • The Risk Manager shall identify and analyze risks to the City and make recommendations to the Mayor and City Council regarding insurance coverage's, reserves, Self -insured retention (SIR) levels, loss prevention, and general risk issues. • The Risk Manager shall review the City's loss reports and annual Risk Pool report annually with the City Council. Created September 2022 Page 1 Risk Management Policy Packet Pg. 84 2.6.a 4.0 SAFETY AND LOSS PREVENTION Safety and Loss Prevention Policies and Procedures shall be maintained by the Risk Manager. • All mandated trainings shall be maintained by the Safety and Disaster Coordinator and approved by the Risk Manager. • Policies and procedures will be reviewed and updated to ensure compliance. 5.0 INSURANCE POLICIES Liability and property policies will be maintained by the Human Resources department. Copies of all Certificates of Insurance certificates issued on behalf of the City shall be maintained by the Human Resources department. I:- 1=Z1xd07:711.1 • Complete and accurate records regarding all claims against or by the City shall be maintained by the Human Resources department. • Files shall include but are not limited to claimants name, address, description of claim and determination. • Loss Runs shall be maintained prepared and available at least once per year or as needed. 7.0 CLAIMS AND LITIGATION The Risk Manager shall be the main point of contact with the City's Risk Pool for all claims and litigation. 8.0 RISK EVALUATION COMMITTEE • The Risk Manager and the City Attorney shall meet as needed to review claims and litigation. • The City Council shall be updated on large claims, or those with the potential of litigation. 9.0 SETTLEMENT FUND • A fund for small claim settlement of those claims not covered by the City's insurance through the Risk Pool and for immediate claims expenses and costs shall be established in the budget. • Payments drawn on the account will require the authorization of these positions: 1. Risk Manager 2. City Attorney • The balance of the fund shall be $25,000 with no draft drawn on the account in excess of $5,000. Created September 2022 Page 2 Risk Management Policy Packet Pg. 85 2.6.a 10.0 PLACEMENT OF INSURANCE The Risk Manager may engage one or more Consultant/Broker(s) to assist and advise the City in the placement of insurance for those losses not covered by insurance through the risk pool and other lines as deemed appropriate by the Risk Manager. Insurance carried by the City shall be obtained through negotiations directed by the Consult/Broker or the Risk Manager and when deemed necessary and to the best interests of the City, by competitive process solicited by the Consult/Broker or the Risk Manager and shall be awarded to the insurance agents and/or companies who agree to furnish the coverage required at the lowest and best price consistent with good service and security. 11.0 AUTHORIZED INSURANCE The coverages set forth below are intended as guidelines to the Risk Manager. The following insurance may be carried in accordance with applicable rules and regulations. • Fire insurance covering all buildings owned or occupied by the City in amounts as recommended by the Risk Manager or Risk Pool. • Comprehensive liability insurance covering elected City officials, the City's officers, agents and employees while acting in the discharge of their duties within the scope of their employment and/or under the direction of the City. • Fidelity bonds protecting the members of the Council against loss occasioned by fraud or dishonesty of officers and employees of the City. • Workers' Compensation insurance covering all employees of the City, in accordance with the laws of the State of Washington governing Workers' Compensation. • Casualty, fire and theft insurance covering City property. • Burglary and robbery insurance covering City property. • Boiler and pressure vessel property damage insurance covering steel boilers and other pressure vessels and property limits deemed sufficient by the Risk Manager and Risk Pool. • Underground and Above Ground Storage Tank coverage. • Any other insurance coverage deemed appropriate such as inland marine, money and securities, performance bonds or as the Council may authorize. Created September 2022 Page 3 Risk Management Policy i� Packet Pg. 86 2.6.a 12.0 INSURABLE VALUE — BUILDINGS AND CONTENTS • The insurable value of a building shall be defined as the replacement cost of the building less the non insurable items set forth in the City's property insurance forms. • The term "contents" as used in connection with insurance shall be defined to include all personal property not specifically excluded by the terms of the standard form for fire insurance policies. The valuation of contents, for insurance purposes, shall be the full replacement cost or the actual cash value of the insured property. • Uninsured property normally is defined as that which cannot be replaced after a loss by standard fire/EC policies. Personal property brought on work sites by employees usually is not insured. Verifiable losses of uninsured property may be replaced or repaired using actual cash value. • Acquisition of property (real and personal) will be reported to Risk Management each year. The statement of values with insurance carriers will be updated as required by the Risk Pool and carriers as necessary. Acquisition of larger parcels of improved real property will be reported to Risk Management upon acquisition. Disposition of real and personal property will be updated annually with the Risk Pool and carriers as necessary. 13.0 LIABILITY CLAIM MANAGEMENT • All claims against the City require a notarized claim form to be filed with the City Clerk. Upon receipt, the City Clerk shall forward the claim to the designated employee who will submit the claim to the Risk Pool and contact named departments for additional information. • All investigative materials will be forwarded to the Risk Manager. Should insurance carriers be involved, the Risk Manager shall notify those companies. Claims will be managed on a "need -to -know" basis. City officials and employees that are involved or need to be involved in the claim will be notified. The City Attorney will be notified of all claims that involve bodily injury or death. 14.0 SETTLEMENT OF LOSSES Risk Manager shall have the authority to settle small claims, not to exceed $5,000 that are not covered by the City's insurance coverage through the Risk Pool. Claims will be reviewed with the City Attorney. Claims made for more than $5,000 will be brought forward to the City Council Finance Committee for review. Created September 2022 Page 4 Risk Management Policy Packet Pg. 87 2.6.a 15.0 PROPERTY LOSS REPORTING Although most property losses are not insured, a property loss reporting system enables the gathering of loss data that helps determine the following: • Property insurance deductibles • Budget line items for replacement of uninsured losses. • Property inventory updates Property losses that should NOT be reported under this procedure are: • Vehicular accident damages that were reported under Section 13.4 — Automobile/Equipment Accident • Routine losses that are budgeted by Departments and where a loss accounting system is already in use. Examples would be vandalized signs, picnic tables, turf damage at parks, etc. • Routine wear and tear of equipment or machinery Property losses that should be reported under this procedure are: THEFT: Any theft of City owned property. All thefts must be reported to the law enforcement agency having jurisdiction. • VANDALISM: Any vandalism that is not a routine budgeted loss • FIRE: Any property loss that occurs as a result of fire, flood, earthquake, windstorm, explosion or act of God. isZ�1����K�]►�I,�����17�7:�►���r�1:��9:�J/_V/_�el�Jl�►��i 16.0 RISK RESERVE FUND The Risk Reserve Fund as established by Ordinance 3891 shall be expended for the administration, settlement, allocated expense of claims brought against the City, its officers, agents, commissioners and employees that are not covered by the City's insurance coverages either through the Risk Pool or through the purchase of additional coverages. An account will exist to pay small claims not covered by insurance coverage through the Risk Pool or through purchased additional policies. The account balance will be maintained at $25,000. Drafts drawn on that account will require the authorization of: the Risk Manager; and that of the City Attorney. Budget amendments will be submitted as needed in order to maintain the Risk Fund to the maximum level established. Departments may be charged for payments made from the Risk Reserve fund as deemed appropriate by the Director of Administrative Services. Created September 2022 Page 5 Risk Management Policy Packet Pg. 88 2.6.a 17.0 RISK RESERVE FUND CONTROLS • The Risk Reserve Fund will require two (2) authorizations. 1. Risk Manager 2. City Attorney • Each claim payment shall include an authorization signed by the two (2) above listed position. The authorization shall be presented as the means to initiate payment. A copy of each authorization shall be by the Human Resources and Risk Management Department. • A full Release of Damages shall be secured from the claimant(s) prior to making payment. • The Release of Damages and the payment authorization shall become part of the permanent claims record. • All payments made to claimants shall be through the City's Department of Administrative Services. Created September 2022 Page 6 Risk Management Policy Packet Pg. 89 2.7 City Council Agenda Item Meeting Date: 09/13/2022 Business Improvement District - Collections Update Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The Business Improvement District (BID) was formed by Council in early 2013, see ECC 3.75. The Finance Department provides services to the BID, and has since startup. Staff has some policy questions regarding the BID that we would like to discuss with Council members. In addition, staff has sought feedback from BID stakeholders and has received a significant amount of negative feedback. In the nine years that the BID has been operating, financial policies have not been discussed or updated. Staff Recommendation Staff is not asking for action to be taken tonight. Narrative Tonight we will give a brief update on our attempts to collect BID dues that are in arrears. Packet Pg. 90