Loading...
2022-03-08 City Council - Full FIN Agenda-31091 o Agenda Edmonds City Council FINANCE COMMITTEE - ZOOM VIRTUAL ONLINE MEETING EDMONDS CITY COUNCIL MEETINGS WEB PAGE, HTTP://EDMONDSWA.IQM2.COM/CITIZENS/DEFAULT.ASPX, EDMONDS, WA 98020 MARCH 8, 2022, 6:00 PM THIS MEETING IS HELD VIRTUALLY USING THE ZOOM MEETING PLATFORM. TO VIEW OR LISTEN TO THE COMMITTEE MEETING IN ITS ENTIRETY, PASTE THE FOLLOWING INTO A WEB BROWSER USING A COMPUTER OR SMART PHONE: HTTPS://ZOOM. US/J/95798484261 OR JOIN BY DIAL -UP PHONE: US: +1 253 215 8782 WEBINAR ID: 957 9848 4261 COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. CALL TO ORDER COMMITTEE BUSINESS 1. 2022 Carryforward Budget Amendment (20 min) 2. 2021 Disposed Assets (5 min) 3. January 2022 Monthly Financial Report (10 min) 4. ARPA Funding Status (30 min) ADJOURN Edmonds City Council Agenda March 8, 2022 Page 1 2.1 City Council Agenda Item Meeting Date: 03/8/2022 2022 Carryforward Budget Amendment Staff Lead: Dave Turley Department: Administrative Services Preparer: Marissa Cain Background/History Amend the 2022 Ordinance No. 4249 Staff Recommendation Staff recommends that Finance Committee review the attached carryforward ordinance and place on full council agenda for March 15. Attachments: 3. 2022 Carryforward Budget Amendment Exhibits 2022 Carryforward Budget Amendment Ordinance Packet Pg. 2 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: On March 11, 2021, the American Rescue Plan Act (ARPA) was signed into law. The Fiscal Recovery Funds are intended to provide support to State, local, and Tribal governments in responding to the impact of COVID-19 and in their efforts to contain COVID-19 on their communities, residents, and businesses. The Fiscal Recovery Funds build on and expand the support provided to these governments over the last year, including through the Coronavirus Relief Fund. The City of Edmonds was awarded a total of $11.9M in Fiscal Recovery Funds, and $5.9M of that award was received June 25th, 2021. These funds were allocated across multiple accounts to meet the financial needs of the city. Per Ordinance 4237, any amounts that are not expended within their designated year may be carried forward to subsequent years. This budget amendment carries forward the remaining amount of ARPA funds that were not spent in 2021. 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) Finance Unspent ARPA Funds Marissa Cain Previously Approved Budget By Council 2021 Adopted Budget 100% Beginning Fund Balance One -Time Capital Fund 142 EDMONDS CARES Name: I FUND Account Number Description 2022 2023 2024 2025 2026 142.000.39.518.63.41.00 COMMUNITY RELIEF FUNDS $ 4,727,492 $ $ $ $ Total Expenditure Increase (Decrease) $ 4,727,492 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 142.000.308.30.000.00 BEGINNING FUND BALANCE $ 4,727,492 $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ 4,727,492 $ $ $ $ Packet Pg. 3 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Early in 2021 the City's PC Support Technician retired, and it took most of the year to fill the position. Later in the year the Information Services Manager left the city and has not yet been replaced. This has left us without sufficient employee bandwidth to keep up on equipment purchases and replacements. During 2021 we had $109,600 budgeted and only spent about $18,000. This request is to carry forward those funds for use in 2022. 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) Administrative Services Information Technologj Equipment Purchase C: Dave Turlev Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund I 512 TECHNOLOC Name: RENTAL FUND Account Number Description 2022 2023 2024 2025 2026 512.100.31.518.88.35.00 Small Equipment $ 91,600 $ $ $ $ Total Expenditure Increase (Decrease) $ 91.600 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 512.100.308.00.000.00 Beginning Fund Balance $ 91,600 $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ 91.600 $ $ $ $ Packet Pg. 4 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) This emergency repair project to replaced failed drainline was budgeted for, started and nearly completed in 2021. However, it was not completed until early 2022 due to supply chain issues. Parks, Recreation & Cultural Services Parks Brackett's North Restroom Repair Shannon Burlev Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 1000/u Beginning Fund Balance One -Time Capital Fund I 125 REET 2 Name: Account Number Description 2022 2023 2024 2025 2026 125.000.64.576.80.48.00 Repairs & Maintenance $ 21,843 $ $ $ $ Total Expenditure Increase (Decrease) $ 21.843 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 125.000.308.30.000.00 Beginning Fund Balance $ 21,843 $ $ $ $ Total Beginning Fund Balance Increase (Decrease) $ 21.843 $ $ $ $ Packet Pg. 5 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Item Description: A total of $50,000 for the EAC Create Grant program was approved in a decision package for 2021. The purpose of this new grant program was to help build and reinforce a diverse, accessible, and equitable cultural community in Edmonds, recognizing the uncertainty and challenges of the COVID-19 pandemic, and the necessity of changing strategies to create access for all to the arts. $36,500 was expended in grants during 2021 in two rounds of grants including projects in performing, visual and literary arts. Due to the continuing pandemic and uncertainties, the third round was not implemented because there was inadequate time to have programs completed by the end of 2021. The remaining funds $13 500 will be used for grants in a similar program for 2022. Department: Parks, Recreation & Cultural Services Fund Name: 117 MUNICIPAL ARTS Division: Cultural Services - Municipal Arts Fund Title: EAC Create Grant program Preparer: Shannon Burley Budget Amendment Type Previously Approved Budget By Council 2021 Adopted Budget Date of Discussion or Budget Approval? Dec 15 2020 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 117.100.64.573.20.41.00 Professional Services $ 13,500 S $ $ S Total Expenditure Increase (Decrease) $ 13,500 $ $ $ - $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 S $ $ S Total Revenue Increase (Decrease) $ S $ $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 117.100.308.40.000.00 Beginning Fund Balance $ 13,500 $ $ $ S Total Beginning Fund Balance Increase (Decrease) $ 13,500 $ $ $ - S Packet Pg. 6 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Item Description: Civic Park entered construction in August 2021. The project is slated to be completed in Winter 2022. Any unspent budget allocation for 2021 is expected to be expended in 2022 as detailed in this carryforward amendment. Department: Parks, Recreation & Cultural Services Division: Parks Title: Civic Park Prenarer: Shannon Burlev 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? EXDenditure Increase (Decrease) Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund I MULTIPLE Name: L Account Number Description 2022 2023 2024 2025 2026 125.000.64.594.76.65.00 Civic Park Construction $ 31,200 $ $ $ $ 126.000.64.594.76.65.00 Civic Park Construction 720 332.000.64.594.76.65.00 Civic Park Construction 293,400 Total Expenditure Increase (Decrease) $ 325,320 S $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 $ $ $ $ $ Total Revenue Increase (Decrease) $ $ $ $ $ Beninninn Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 125.000.308.30.000.00 Beginning Fund Balance $ 31,200 $ $ $ S 126.000.308.30.000.00 Beginning Fund Balance 720 332.000.308.30.000.00 Beginning Fund Balance 293,400 Total Beginning Fund Balance Increase (Decrease) $ 325,320 $ $ $ S 5 Packet Pg. 7 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Item Description: The research for this project is complete and permits are in process. The greenhouse project has a narrow timeframe in which it can be installed and the Department was unable to attain that last year due to supply chain and supplier issues, COVID impact and staff limitations last year. Department: Parks, Recreation & Cultural Services Division: Parks Fund 125 REET 2 Title: Greenhouse Name: Preuarer: Shannon Burley r MA Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Account Number Description 2022 2023 2024 2025 2026 125.000.64.594.76.41.00 Greenhouse $ 50,000 $ $ $ S 136.100.64.573.30.41.00 Greenhouse 50,000 Total Expenditure Increase (Decrease) $ 100,000 $ $ $ - $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 S $ $ S Total Revenue Increase (Decrease) $ S $ $ S Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 125.000.308.30.000.00 Beginning Fund Balance $ 50,000 $ $ $ S 136.100.308.30.000.00 Beginning Fund Balance 50,000 Total Beginning Fund Balance Increase (Decrease) $ 100,000 $ $ $ - S Packet Pg. 8 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Item Description: This project had started but was delayed due to COVID impacts on staff availibility. The project is scheduled to be completed in 2022. Department: Parks, Recreation & Cultural Services Division: Parks Title: City Park Walkway Pedestrian Safety Prenarer: Shannon Burlev 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? EXDenditure Increase (Decrease) Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund F 125 REET 2 Name: Account Number Description 2022 2023 2024 2025 2026 125.000.64.594.76.65.00 City Park Walkway Pedestrian Safety Project $ 30,000 $ $ $ S Total Expenditure Increase (Decrease) $ 30,000 $ $ $ - $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 S $ $ S Total Revenue Increase (Decrease) $ S $ $ S Beninninn Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 125.000.308.30.000.00 Beginning Fund Balance $ 30,000 $ $ $ S Total Beginning Fund Balance Increase (Decrease) $ 30,000 $ $ $ S 7 Packet Pg. 9 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: The Urban Forest Management Plan (UFMP) included a goal to periodically update City of Edmonds Street Plan (UFMP Goal 2.1)). After UFMP adoption, a professional services agreement was entered into with the Watershed Company to help staff move forward with updating the Street Tree Plan by the end of 2020. This PSA with Watershed also inlcuded an inventory of street trees (UFMP Goal 2.Q. The inventory of street trees in the downtown area has been completed, but work on the Street Tree Plan is still ongoing. 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) Development Services Administration 62.524.10 Street Tree Plan Kernen Lien Previously Approved Budget By Council Previous Year Carryforward Amendment Dec 10 2019 100°/ Beginning Fund Balance One -Time Operating Fund I 001 GENERAL Name: Account Number Description 2022 2023 2024 2025 2026 001.000.62.524.10.41.00 Professional Services $ 29,193 $ $ $ $ Total Expenditure Increase (Decrease) $ 29.193 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.308.00.000.00 Beginning Fund Balance $ 29,193 $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ 29.193 $ $ $ $ Packet Pg. 10 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The city entered into a profressional service agreement with ESA to draft the Climate Action Plan (CAP) document. Work on the CAP update is continuing into 2022 and we are requesting carryforward of the remaining $18,639 of the original $30,000 in the PSA. Development Services Administration 62.524.10 Climate Action Plan Upd Kernen Lien Previously Approved Budget By Council Previous Year Carryforward Amendment Dec 10 2019 100°/ Beginning Fund Balance One -Time Operating Fund I 001 GENERAL Name: Account Number Description 2022 2023 2024 2025 2026 001.000.62.524.10.41.00 Professional Services $ 18,639 $ $ $ $ Total Expenditure Increase (Decrease) $ 18,639 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.308.00.000.00 Beginning Fund Balance $ 18,639 $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ 18.639 $ $ $ $ C O E C O E Q d 7 m L O O L tv U N N O N Packet Pg. 11 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The City entered into a professional services agreement with Cascadia Consulting Group near the end of 2020 to assist the City in public engagement for the Climate Action Plan (CAP) update. Work on the CAP update is continuing into 2022 and we are requesting carryforward of the remaining $14,894 of the original $30,000 in the PSA. Development Services Administration 62.524.10 Climate Action Plan Public Kernen Lien Previously Approved Budget By Council Previous Year Carryforward Amendment Dec 10 2019 100°/ Beginning Fund Balance One -Time Operating Fund I 001 GENERAL Name: Account Number Description 2022 2023 2024 2025 2026 001.000.62.524.10.41.00 Professional Services $ 14,894 $ $ $ $ Total Expenditure Increase (Decrease) $ 14.894 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.308.00.000.00 Beginning Fund Balance $ 14,894 $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ 14.894 $ $ $ $ C O E C O E Q d 7 m L O O L tv U N N O N 10 Packet Pg. 12 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: The City of Edmonds adopted an Urban Forest Management Plan (UFMP) in 2019 which included a canopy coverage assessment based on a 2015 aerial photo. Goal 1.I of the UFMP is to report at least every 10 years on canopy coverage. During review of draft tree regulations, the City Council expressed a desire to initiate a new canopy coverage assessment. A budget amendment was passed by the Council in the amount of $25,000 to complete an updated canopy assessment. The canopy assessment is near completion, but $21,250 remains on the contract. 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) Development Services Administration 62.524.10 Canopy Assessment (Saw Kernen Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Operating Fund I 001 GENERAL Name: Account Number Description 2022 2023 2024 2025 2026 001.000.62.524.10.41.00 Professional Services $ 21,250 $ $ $ $ Total Expenditure Increase (Decrease) $ 21,250 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.308.00.000.00 Begimming Fund Balance $ 21,250 $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ 21,250 $ $ $ $ 11 Packet Pg. 13 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Original funding for this plan was included in the 2021 budget under Decision Package #27. Initial progress was made prior to Director Hope's retirement, but to complete the project the remainder of the budget needs to be carried forward into 2022. A total of $42,685 remains from the approved budget for this project. Development Services DS Admin Highway 99 Community Renewal Plan Rob Chave / Susan McLaughlin Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Operating Fund I 001 GENERAL Name: Account Number Description 2022 2023 2024 2025 2026 001.000.62.524.10.41.00 Professional Services $ 42,685 $ $ $ $ Total Expenditure Increase (Decrease) $ 42,685 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.308.00.000.00 Beginning Fund Balance $ 42,685 $ $ $ $ Total Beginning Fund Balance Increase (Decrease) $ 42,685 $ $ $ $ 12 Packet Pg. 14 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: Portion of design phase delayed to 2022. Construction date and budget TBD once design is finalized. Remaining design funding to complete design rolled over from 2021. Department: Public Works Fund Name: 422 STORM Division: Engineering Title: 175th Slope Repair (E21FB/c560) Preparer: Michele (Mike) De Lilla Budget Amendment Type Previously Approved Budget By Council 2021 Adopted Budget Date of Discussion or Budget Approval? Dec 15 2020 How is this amendment funded? 100°/u Beginning Fund Balance What is the nature of the expenditure? I One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 422.000.72.531.31.41.67 Interfund Services $ 30,000 $ $ $ $ 422.000.72.594.31.41.00 Profesional Services 61,857 Total Expenditure Increase (Decrease) $ 91,857 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 30,000 $ $ $ $ Total Revenue Increase (Decrease) $ 30,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 422.000.308.00.000.00 Beginning Fund Balance $ 91,857 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (30,000) Total Beginning Fund Balance Increase (Decrease) $ 61,857 1 $ $ $ $ 13 Packet Pg. 15 Carryforward Budget Amendment for Council to Consider (March 2022) 0 Budget Amendment for: 2022 Carryforward Description: Construction of the Dayton Street Stormwater Pump Station is physically complete, but project budget is being retained to optimize pump operations and ensure successful implementation of a sustainable maintenance program. Public Works ITitle: IDavton Street Stormwater PumD Station (E4FE/c455) I Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Michele (Mike) De Lilla Previously Approved Budget By Council Previous Year Carryforward Amendment Dec 112018 100% Beginning Fund Balance One -Time Capital Fund I 422 STORM Name: Account Number Description 2022 2023 2024 2025 2026 422.000.72.531.31.41.67 Interfund Services $ 18,500 $ $ $ $ 422.000.72.594.31.41.00 Capital Profesional Services 40,000 422.000.72.594.31.65.20 Construction Projects 30,000 Total Expenditure Increase (Decrease) $ 88,500 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 18,500 $ $ $ $ Total Revenue Increase (Decrease) $ 18,500 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 422.000.308.00.000.00 Beginning Fund Balance $ 88,500 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (18,500) Total Beginning Fund Balance Increase (Decrease) $ 70,000 $ $ $ $ 14 Packet Pg. 16 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Item Description: Portion of design phase delayed to 2022. Construction planned in 2022; all remaining design funding rolled over from 2021. Department: Public Works Fund Name: 422 STORM Division: Engineering Title: Seaview Infiltration Facility Phase 2 (EOFA/c546) Preparer: Michele (Mike) De Lilla Budget Amendment Type Previously Approved Budget By Council 2021 Adopted Budget Date of Discussion or Budget Approval? Dec 15 2020 How is this amendment funded? 100°/u Beginning Fund Balance What is the nature of the expenditure? I One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 422.000.72.531.31.41.67 Interfund Services $ 80,000 $ $ $ $ 422.000.72.594.31.41.00 Capital Profesional Services 48,000 422.000.72.594.31.65.20 Construction Projects 330,000 Total Expenditure Increase (Decrease) $ 458,000 $ $ $ $ Revenue Increase (Decreasel Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 80,000 $ $ $ $ Total Revenue Increase (Decrease) $ 80,000 $ $ $ $ Beeinnine Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 422.000.308.00.000.00 Beginning Fund Balance $ 458,000 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (80,000) Total Beginning Fund Balance Increase (Decrease) $ 378,000 $ $ $ $ 15 Packet Pg. 17 Carryforward Budget Amendment for Council to Consider (March 2022) 0 Budget Amendment for: 2022 Carryforward Description: Construction to be completed in 2022. Moved funding to 2022 to account for remaining work to be done. Public Works I Title: I Storm Maintenance Proiect Phase 2 (EOFB/c547) I Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Michele (Mike) De Lilla Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100°/u Beginning Fund Balance One -Time Capital Fund 1 422 STORM Name: Account Number Description 2022 2023 2024 2025 2026 422.000.72.531.31.41.67 Interfund Services $ 80,000 $ $ $ $ 422.000.72.594.31.41.00 Capital Profesional Services 48,000 422.000.72.594.31.65.20 Construction Projects 380,000 Total Expenditure Increase (Decrease) $ 508,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 80,000 $ $ $ $ Total Revenue Increase (Decrease) $ 80,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 422.000.308.00.000.00 Beginning Fund Balance $ 508,000 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (80,000) Total Beginning Fund Balance Increase (Decrease) $ 428,000 $ $ $ $ 16 Packet Pg. 18 Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Construction planned in 2022; all remaining design funding rolled over from 2021. Public Works Storm Maintenance Project Phase 3 Zachary Richardson -Stormwater E Previously Approved Budget By CouncilFM 2021 Adopted Budget Dec 15 2020 100°/u Beginning Fund Balance One -Time Capital Fund 422 STORM Name: Account Number Description 2022 2023 2024 2025 2026 422.000.72.531.31.41.67 Interfund Services $ 58,000 $ $ $ $ 422.000.72.594.31.41.00 Capital Profesional Services 200,000 Total Expenditure Increase (Decrease) $ 258.000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 58,000 $ $ $ $ Total Revenue Increase (Decrease) $ 58,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 422.000.308.00.000.00 Beginning Fund Balance $ 258,000 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (58,000) Total Beginning Fund Balance Increase (Decrease) $ 200,000 $ $ $ $ 17 Packet Pg. 19 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Currently the three utility funds do not have formal policies for reserve funds needs. The work will program the funds to develop policies to ensure that adequate reserves are in place. This work was delayed so that it will be done in conjuction with the rate analysis and GFC update work that was part of the budget approved for 2022. Public Works Fund Reserve Policies Michele (Mike) De Lilla Previously Approved Budget By Council I st Quarter Budget Amendment Apr 27 2021 One -Time Capital Fund I MULTIPLE Name: Account Number Description 2022 2023 2024 2025 2026 421.000.74.534.80.41.67 Interfund Services $ 5,000 $ $ $ $ 421.000.74.534.80.41.10 Professional Services 15,000 422.000.72.531.70.41.67 Interfund Services 5,000 422.000.72.531.90.41.20 Professional Services 15,000 423.000.75.535.80.41.67 Interfund Services 5,000 423.000.75.535.80.41.20 Professional Services 15,000 Total Expenditure Increase (Decrease) I $ 60,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 15,000 $ $ $ $ Total Revenue Increase (Decrease) $ 15,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 421.000.308.00.000.00 Beginning Fund Balance $ 20,000 $ $ $ $ 422.000.308.00.000.00 Beginning Fund Balance 20,000 423.000.308.00.000.00 Beginning Fund Balance 20,000 001.000.308.00.000.00 Beginning Fund Balance (15,000) Total Beginning Fund Balance Increase (Decrease) $ 45,000 $ $ $ 18 Packet Pg. 20 Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Design and construction delayed to 2022. 2021 funds moved to 2022. Public Works Phase 3 Sanitary Sewer CIPP Previously Approved Budget By Councillow Previous Year Carryforward Amendment Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund 423 SEWER / TREATMENT Nam I PLANT Account Number Description 2022 2023 2024 2025 2026 423.000.75.535.80.41.67 Interfund Services $ 20,000 $ $ $ $ 423.000.75.594.35.41.00 Capital Professional Services $ 60,000 423.000.75.594.35.65.30 Construction Projects $ 373,710 Total Expenditure Increase (Decrease) $ 453,710 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 20,000 $ $ $ $ Total Revenue Increase (Decrease) $ 20,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.308.00.000.00 Beginning Fund Balance $ 453,710 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (20,000) Total Beginning Fund Balance Increase (Decrease) $ 433,710 $ $ $ $ 19 Packet Pg. 21 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Remaining construction work is suspended due to contractor. Project is expected to be substantially complete spring 2022. Public Works Phase 7 Sewer Replacement E8GA/c516 Greeory Malowicki Previously Approved Budget By Councillow Previous Year Carryforward Amendment Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund 423 SEWER / TREATMENT Nam I PLANT Account Number Description 2022 2023 2024 2025 2026 423.000.75.535.80.41.67 Interfund Services $ 20,000 $ $ $ $ 423.000.75.594.35.65.30 Construction Projects $ 54,095 Total Expenditure Increase (Decrease) $ 74.095 S $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 20,000 $ $ $ $ Total Revenue Increase (Decrease) $ 20,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.308.00.000.00 Beginning Fund Balance $ 74,095 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (20,000) Total Beginning Fund Balance Increase (Decrease) $ 54,095 1 $ $ $ $ C O E C O E Q tv 7 m L O O L tv U N N O N 20 Packet Pg. 22 Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Project closeout, record drawings of project in progress. Public Works Phase 9 Sewer Replacement E21GA/c559 Michele (Mike) De Lilla Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100°/u Beginning Fund Balance moor One -Time Capital Fund 423 SEWER / TREATMENT Nam I PLANT Account Number Description 2022 2023 2024 2025 2026 423.000.75.535.80.41.67 Interfund Services $ 2,000 $ $ $ $ 423.000.75.594.35.65.30 Construction Projects $ 8,366 Total Expenditure Increase (Decrease) $ 10.366 S $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 2,000 $ $ $ $ Total Revenue Increase (Decrease) $ 2,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.308.00.000.00 Beginning Fund Balance $ 10,366 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (2,000) Total Beginning Fund Balance Increase (Decrease) $ 8,366 $ $ $ $ C O E C O E Q tv 7 m L O O L tv U N N O N 21 Packet Pg. 23 Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: I Project closeout, record drawings of project in progress. Department: Public Works Fund Name: Division: Engineering Title: Phase 11 Waterline Replacement (EOJA/c549) Preparer: Michele (Mike) De Lilla Budget Amendment Type Previously Approved Budget By Council 2021 Adopted Budget Date of Discussion or Budget Approval? Dec 15 2020 How is this amendment funded? 100°/u Beginning Fund Balance What is the nature of the expenditure? I One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 421.000.74.534.34.41.67 Interfund Services $ 30,000 $ $ $ $ 421.000.74.594.34.41.00 Capital Professional Services 60,000 421.000.74.594.34.65.10 Construction 110,000 Total Expenditure Increase (Decrease) $ 200,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 30,000 $ $ $ $ Total Revenue Increase (Decrease) $ 30,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 421.000.308.00.000.00 Beginning Fund Balance $ 200,000 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (30,000) Total Beginning Fund Balance Increase (Decrease) $ 170,000 $ $ $ $ 22 Packet Pg. 24 Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: I Unspent 2021 design dollars moved to 2022 for design completion. Department: Public Works Fund Name: Division: Engineering Title: Phase 12 Waterline Replacement (E21JA/c558) Preparer: Michele (Mike) De Lilla Budget Amendment Type Previously Approved Budget By Council 2021 Adopted Budget Date of Discussion or Budget Approval? Dec 15 2020 How is this amendment funded? 100°/u Beginning Fund Balance What is the nature of the expenditure? I One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 421.000.74.534.34.41.67 Interfund Services $ 40,000 $ $ $ $ 421.000.74.594.34.41.00 Capital Professional Services 105,396 Total Expenditure Increase (Decrease) S 145.396 S $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 40,000 $ $ $ $ Total Revenue Increase (Decrease) $ 40,000 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 421.000.308.00.000.00 Beginning Fund Balance $ 145,396 $ $ $ $ 001.000.308.00.000.00 Beginning Fund Balance (40,000) Total Beginning Fund Balance Increase (Decrease) $ 105,396 $ $ $ $ 23 Packet Pg. 25 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: In 2021 following an evaluation, (3) locations were determined for the installation of radar feedback signs (along 220th St. West of 76th for westbound movement / along 84th Ave. W north of 236th St. SW for nortbound movement, and Main St (west of Maplewood Dr for westbound movement). Poles to hold this sign will be installed at all these locations. Only one feedback sign will be installed and the sign will be switched to other pole locations every couple of months. The carryforward will be used to complete the installation of the radar feedback sign / poles. Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Public Works 2021 Traffic Ca: Bertrand Hauss Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund I 126 REET 1 Name: Account Number Description 2022 2023 2024 2025 2026 126.000.68.542.64.48.00 R&M Traffic Control S 39,250 $ S S $ Total Expenditure Increase (Decrease) S 39,250 $ S S $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 S S S S $ Total Revenue Increase (Decrease) S S S S $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 126.000.308.30.000.00 Beginning Fund Balance S 39.250 S S $ $ Total Beginning Fund Balance Increase (Decrease) S 39,250 S S S $ 24 Packet Pg. 26 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The project is nearing completion with substantial completion scheduled to occur in February 2022. The carryforward will be used to complete the Federal documentation, signal installation at SR-104 @ 23nd St. SW, concrete items, striping, and punhlist items. Public Works Citywide Pedestrian Crossing Enhancments Bertrand Hauss Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund MULTIPLE Name: Account Number Description 2022 2023 2024 2025 2026 112.000.68.595.61.65.00 Capital Professional Services -Sidewalks S 34,094 $ S S $ 112.000.68.595.61.65.00 Construction - Sidewalks 278,956 126.000.68.542.61.41.67 Interfund Services -Sidewalks 41,345 126.000.68.595.33.41.00 Capital Professional Services -Sidewalks 20,281 126.000.68.595.61.65.00 Construction - Sidewalks 87,337 125.000.68.595.61.41.00 Professional Services -Sidewalks 10,000 125.000.68.595.61.65.00 Construction - Sidewalks 86,854 Total Expenditure Increase (Decrease) $ 558,867 $ S S S Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 112.000.333.20.205.19 Citywide Ped Crossing SRTS-0365(013) $ 313,050 $ S S S 001.000.349.18.000.00 Contract Services 41,345 Total Revenue Increase (Decrease) S 354,395 $ S S $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 126.000.308.30.000.00 Beginning Fund Balance $ 148,963 $ $ $ $ 125.000.308.30.000.00 Beginning Fund Balance 96,854 001.000.308.00.000.00 Beginning Fund Balance (41,345) Total Beginning Fund Balance Increase (Decrease) $ 204,472 $ $ $ S 25 Packet Pg. 27 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: I The unspent funds will be programmed for the construction phase in 2022. Public Works Fund 126 REET 1 Highway 99 Revitalization & Gateway - Stage 2 Name: Bertrand Hauss Budget Amendment Type Previously Approved Budget By Council 2021 Adopted Budget Date of Discussion or Budget Approval? Dec 15 2020 How is this amendment funded? 100% Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 126.000.68.542.30.41.67 Interfund Services -Roadway S 27.000 S S S $ 126.000.68.595.33.41.00 Professional Services Capital -Roadway 243.000 Total Expenditure Increase (Decrease) S 270,000 S S S $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services $ 27,000 $ S S S Total Revenue Increase (Decrease) $ 27,000 $ S S S Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 126.000.308.30.000.00 Beginning Fund Balance $ 270,000 S S S S 001.000.308.00.000.00 Beginning Fund Balance $ (27,000) Total Beginning Fund Balance Increase (Decrease) $ 243,000 $ S S S 26 Packet Pg. 28 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) In 2021, the design phase for this project began. The carryforward funds will be used to complete the Design Phase in 2022. Public Works Elm Way Walkway from 8th Ave. S to 9th Ave. S Bertrand Hauss Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund MULTIPLE Name: Account Number Description 2022 2023 2024 2025 2026 126.000.68.595.61.41.00 Professional Services - Capital Sidewalks S 27,108 $ S S $ 126.000.68.542.61.41.67 Interfund Services - Sidewalks 5,040 422.000.72.594.31.41.00 Capital Professional Services 15,921 422.000.72.542.40.41.67 Interfimd Services - Sidewalks 2,960 Total Expenditure Increase (Decrease) S 51,029 $ S S $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services S 8,000 S S $ $ Total Revenue Increase (Decrease) $ 8,000 $ S $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 126.000.308.00.000.00 Beginning Fund Balance $ 32,148 $ S S $ 422.000.308.00.000.00 Beginning Fund Balance 18,881 001.000.308.00.000.00 Beginning Fund Balance (8,000) Total Beginning Fund Balance Increase (Decrease) $ 43,029 $ S S $ 27 Packet Pg. 29 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) In 2021, guardrails were installed along 180th St. and along the alley north of Main St (between 7th Ave. N and 8th Ave. N). One additional guardrail needs to be installed in 2022 at the end of the dead street on 196th St. SW (west of 88th Ave. W). The carryforward will be used to pay the contractor for this remaining work. Public Works 2021 Guardrail Bertrand Hauss Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund 126 REET 1 Name: Account Number Description 2022 2023 2024 2025 2026 126.000.68.542.64.41.67 Interfund Services S 1,000 $ S S $ 126.000.68.542.64.48.00 R & M - Traffic Control 7,363 Total Expenditure Increase (Decrease) S 8,363 $ S S $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.349.18.000.00 Contract Services S 1,000 S S S $ Total Revenue Increase (Decrease) $ 1,000 $ S S $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 126.000.308.00.000.00 Beginning Fund Balance S 8,363 $ $ S $ 001.000.308.00.000.00 Beginning Fund Balance (1,000) Total Beginning Fund Balance Increase (Decrease) S 7,363 $ S S $ 28 Packet Pg. 30 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The carryfoward will be used to pay for contract work completed by the surety and for staff to close-out the project. Public Works 84th Ave. W Overlay from 220th St. SW to 212th St. SW Bertrand Hauss Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 100% Beginning Fund Balance One -Time Capital Fund MULTIPLE Name: Account Number Description 2022 2023 2024 2025 2026 112.000.68.542.30.48.00 Repair & Maint Overlays S 12.800 S S S $ 126.000.68.542.30.48.00 Repair & Maint Overlays 3.200 Total Expenditure Increase (Decrease) S 16,000 1 S S S $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 112.000.333.20.205.20 84th Ave STPUL-2509(001) S 12.800 S S $ $ Total Revenue Increase (Decrease) S 12,800 S S S $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 126.000.308.00.000.00 Beginning Fund Balance S 3,200 S S S $ Total Beginning Fund Balance Increase (Decrease) S 3,200 $ S S $ 29 Packet Pg. 31 2.1.a Carryforward Budget Amendment for Council to Consider (March 2022) Budget Amendment for: 2022 Carryforward Description: I This carryforward will program the unspent funds from the 2021 pavement overlay program to the 2022 program. Public Works Engineering Fund MULTIPLE 2021 Overlav Program Name: Budget Amendment Type Previously Approved Budget By Council 2021 Adopted Budget Date of Discussion or Budget Approval? Dec 15 2020 How is this amendment funded? 1000/u Beginning Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 125.000.68.542.30.48.00 Repair & Maintenance -Overlays $ 79,915 $ $ $ $ 126.000.68.542.30.48.00 Repair & Maintenance -Overlays 58,750 Total Expenditure Increase (Decrease) $ 138.665 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase (Decrease) $ $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 125.000.308.30.000.00 Beginning Fund Balance $ 79,915 $ $ $ $ 126.000.308.30.000.00 Beginning Fund Balance 58,750 Total Beginning Fund Balance Increase (Decrease) $ 138,665 $ $ $ $ 30 Packet Pg. 32 Carryforward Budget Amendment for Council to Consider (March 2022) 2.1.a Budget Amendment for: 2022 Carryforward Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The 2022 Carryforward is to complete the Carbon Recovery Project. Anticipated substantial completion is during the second quarter of 2022. Within Fund 423 there is a GL code for the Wastewater Treatment Plant (WWTP) Capital Program: 423.100. The capital portion, which is per a contract, is posted to 423.100. In order to properly record revenues related to the WWTP for the City of Edmonds portion of the contract, an entry is needed to move funds from the operating program into the capital program. $4,478,775 of the $13,297,518 expenditure is for the interfund transfer required to move Public Works Wastewater Treatment Plant WWTP Capital Carryforward Preuarer: M Derrick / Reviewer Previously Approved Budget By Council 2021 Adopted Budget Dec 15 2020 1000/u Beginning Fund Balance One -Time Capital Fund 1423 Sewer / Treatment Plant Name: Account Number Description 2022 2023 2024 2025 2026 423.100.76.594.35.65.10 Construction Projects $ 8,818,743 $ $ $ $ 423.000.75.597.35.55.23 Interfund Transfer 4,478,775 Total Expenditure Increase (Decrease) $ 13,297,518 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.100.374.07.010.00 Mountlake Terrace (23.174%) $ 2,043,656 $ $ $ $ 423.100.374.07.020.00 Olympic View (16.551%) $ 1,459,590 423.100.374.07.030.00 Shoreline (RonaldWD) (9.488%) 836,722 423.100.397.38.423.20 InterFund (50.787%) $ 4,478,775 Total Revenue Increase (Decrease) $ 8,818,743 $ $ $ $ Beginning Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 423.000.308.89.000.00 Beginning Fund Balance $ 4,478,775 $ $ $ $ Total Ending Fund Balance Increase (Decrease) $ 4,478,775 $ $ $ $ 31 Packet Pg. 33 ORDINANCE NO. XXXX AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4249 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. 4249 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. 34 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: M. JEFF TARADAY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. APPROVED: MAYOR, MIKE NELSON 2 Packet Pg. 35 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. 4249 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 , 2022. CITY CLERK, SCOTT PASSEY 3 Packet Pg. 36 EXHIBIT "A": Budget Amendment Summary (March 2022) FUND NO. FUND DESCRIPTION 2022 BEGINNING FUND BALANCE REVENUE EXPENDITURES 2022 ENDING FUND BALANCE 001 GENERAL FUND 12,908,490 44,640,708 49,371,535 8,177,663 009 LEOFF-MEDICAL INS. RESERVE 370,037 225,000 260,490 334,547 011 RISK MANAGEMENT RESERVE FUND - - - - 012 CONTINGENCY RESERVE FUND 1,784,770 - 1,784,770 014 HISTORIC PRESERVATION GIFT FUND 16,299 5,900 10,399 016 BUILDING MAINTENANCE 4,610,222 980,000 3,630,222 017 MARSH RESTORATION & PRESERVATION FUND 844,866 - - 844,866 018 EDMONDS HOMELESSNESS RESPONSE FUND - 200,000 200,000 - 019 EDMONDS OPIOID RESPONSE FUND - - - - 104 DRUG ENFORCEMENTFUND 193,873 167,210 45,800 315,283 111 STREET FUND 731,490 1,751,930 2,254,676 228,744 112 COMBINED STREETCONST/IMPROVE 2,075,270 13,684,871 12,868,796 2,891,345 117 MUNICIPAL ARTS ACQUIS. FUND 659,041 216,701 195,380 680,362 120 HOTEL/MOTEL TAX REVENUE FUND 51,231 84,410 100,900 34,741 121 EMPLOYEEPARKINGPERMITFUND 80,358 26,540 26,880 80,018 122 YOUTH SCHOLARSHIP FUND 12,768 1,550 3,000 11,318 123 TOURISM PROMOTIONAL FUND/ARTS 85,338 29,590 28,200 86,728 125 PARK ACQ/IMPROVEMENT 3,375,343 2,271,020 4,589,688 1,056,675 126 SPECIAL CAPITAL FUND 2,799,839 2,261,030 2,483,667 2,577,202 127 GIFTS CATALOG FUND 294,795 82,750 78,400 299,145 130 CEMETERY MAINTENANCE/IMPROV 211,509 182,430 220,561 173,378 136 PARKS TRUST FUND 168,837 4,330 50,000 123,167 137 CEMETERY MAINTENANCE TRUSTFD 1,100,900 43,520 25,000 1,119,420 138 SISTER CITY COMMISSION 10,362 10,290 11,900 8,752 140 BUSINESS IMPROVEMENT DISTRICT FUND 23,181 79,349 87,680 14,850 141 AFFORDABLE & SUPPORTIVE HOUSING FUND 143,441 65,000 - 208,441 142 EDMONDS RESCUE PLAN FUND 4,727,492 4,856,549 5,977,492 3,606,549 143 TREE FUND 20,487 215,330 214,800 21,017 211 LID FUND CONTROL - - - - 231 2012 LTGO DEBTSERVICE FUND - 611,370 611,370 - 332 PARKS CONSTRUCTION 4,848,045 3,822,685 7,614,418 1,056,312 421 WATER 26,413,506 11,018,136 11,475,894 25,955,748 422 STORM 15,081,583 7,877,897 9,681,440 13,278,040 423 SEWER/TREATMENT PLANT 48,428,426 24,820,083 29,512,501 43,736,008 424 BOND RESERVE FUND 843,961 1,988,700 1,988,710 843,951 511 EQUIPMENT RENTAL FUND 8,999,440 1,925,920 1,942,460 8,982,900 512 Technology Renta I Fund 1 889,194 1 1,153,570 1 1,539,022 1 503,742 Tota Is 142,804,394 124,318,469 144,446,560 122,676,303 L O w- L U N N O N r C d E t v a Packet Pg. 37 EXHIBIT "B": Budget Amendments by Revenue (March 2022) 2.1.b FUND NO. FUND DESCRIPTION Adopted Budget Ord.#4240 1/1/2022 Adopted Amendment Ord.#4249 3/1/2022 Proposed Amendment Ord.# 3/15/2022 2022 Amended Revenue Budget 001 General Fund $ 44,204,863 $ (35,000) $ 470,845 $ 44,640,708 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 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 4,856,549 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 3,822,685 421 Water 11,018,136 11,018,136 422 Storm 8,277,897 (400,000) - 7,877,897 423 Sewer/Treatment Plant 16,001,340 8,818,743 24,820,083 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 1,153,570 617 Firemen's Pension Fund - - Totals $ 114,938,031 $ (235,000) $ 9,615,438 $ 124,318,469 C Ci) E C Ci) E Q N 3 m L 0 L U CV CV O CV L ca O L R U CV CV O CV r C d E t V M a Packet Pg. 38 EXHIBIT "C": Budget Amendments by Expenditure (March 2022) 2.1.b FUND NO. FUND DESCRIPTION Adopted Budget Ord.#4240 1/1/2022 Adopted Amendment Ord.#4249 3/1/2022 Proposed Amendment Ord.# 3/15/2022 2022 Amended Expenditure Budget 001 General Fund $ 49,246,551 $ (1,677) $ 126,661 $ 49,371,535 009 Leoff-Medical Ins. Reserve 260,490 - 260,490 011 Risk Management Reserve Fund - - 012 Contingency Reserve Fund - - 014 Historic Preservation Gift Fund 5,900 5,900 016 Building Maintenance Fund 980,000 980,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 - 2,254,676 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 Trust I'd 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 5,977,492 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 7,614,418 421 Water 11,110,498 365,396 11,475,894 422 Storm 8,638,202 (400,000) 1,443,238 9,681,440 423 Sewer /Treatment Pla nt 15,656,812 13,855,689 29,512,501 424 Bond Reserve Fund 1,988,710 - 1,988,710 511 Equipment Rental Fund 1,942,460 - 1,942,460 512 Technology Rental Fund 1,447,422 91,600 1,539,022 617 Firemen's Pension Fund - - - Totals $122,484,205 1 $ (201,677) $ 22,164,032 1 $ 144,446,560 L 0 L U N N O N r C d E t V M 41 a Packet Pg. 39 EXHIBIT "D": Budget Amendment Summary (March 2022) 2.1.b Fund Number Proposed Amendment Change in Beginning Fund Balance Proposed Amendment Change in Revenue Proposed Amendment Change in Expense Proposed Amendment Change in Ending Fund Balance 001 (344,184) 470,845 126,661 112 325,850 325,850 117 13,500 13,500 125 309,812 309,812 126 561,394 561,394 136 50,000 50,000 142 4,727,492 4,727,492 332 293,400 293,400 421 365,396 365,396 422 1,443,238 1,443,238 423 5,036,946 8,818,743 13,855,689 512 91,600 91,600 Total Change 12,548,594 9,615,438 22,164,032 C N E C 4) E Q N 3 m L w- L U N N O N L 3� L 0 w- L U N N O N r C d E t V ra a Packet Pg. 40 2.2 City Council Agenda Item Meeting Date: 03/8/2022 2021 Disposed Assets Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History Council notification is required for disposal of assets. As part of our normal asset replacement cycle, the items on the attached list were disposed of during 2021. Staff Recommendation Discussion/notification only. Narrative N/A Attachments: 2021 Disposed Assets Packet Pg. 41 2.2.a Fund Fund Type FA Number FA Description Tvpe Dept# Amount 900 Govemmental 3986 Civic Park Tennis Court Fence 1 640 9,453.16 900 Governmental 4113 Civic Park Tennis Court Part A 1 640 33,315.34 900 Governmental 4129 Civic Park Tennis Court 125 Portion Part B I w 9,804.09 900 Governmental 4130 JR HI Play Field - AKA Civic Field 1 640 62,207.63 900 Governmental 6388 Civic Cntr Basketball Court 640 19,700.26 9OOGovernmental 9769 Civic Park Skate Park 1 640 351,211.27 900 Governmental 9757 CEMETERY WALKER RIDING MOWER e 640 15,239.62 900 Governmental 9804 FAS 2050 Datalink Drive a 310 34,156.48 511 Governmental 6998 1992 CAT BACKHDE 963 STR e 657 54,212.53 511 Governmental 9504 2002 CHEVYSILVERADO TRUCK #81 e 657 18,792.20 511 Governmental 9765 2007 STERLING SC8000 91.38 a 657 197,559,77 511 Governmental 9801 2008 FORD RANGER 379-POL a 657 18,735,02 511 Governmental 9879 2011 FORD CROWN VICTORIA 454-POL a 657 32,775.49 511 Governmental 9969 PROPANE CONVERSION KIT 9454 a 657 6,615.01 511 Governmental 9029 947-POL 2015 FORD POLICE UTILITY INTERCEPTOR e 657 51,700.44 511 Governmental 9137 527-POL 2016 FORD EXPLORER e 657 55,791.77 511 Governmental 9187 435-POL 2017 FORD EXPLORER PPV a 657 59,191,98 423 Proprietary 9573 2003 CHEV. 5-10 TRUCK #131 e 423 15,220.04 423 Proprietary 9652 HEATE3f601-HEAT EXCHANGER REPLACEMENT i 423 328,178.56 423 Proprietary 9782 INC500 - INCINERATOR PROJECT 1 423 120,652.00 423 Proprietary 9021 INC500 - SEWER & SLUDGE INCINERATOR 2012 1 423 208,557.96 Totals 1, 703, 070, 62 N O N a d N O M N C N 0 N Packet Pg. 42 2.3 City Council Agenda Item Meeting Date: 03/8/2022 January 2022 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Review and move to full council on consent. Narrative January 2022 Monthly Financial Report Attachments: January 2022 Monthly Financial Report Packet Pg. 43 I 2.3.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT JAN UARY 2022 Packet Pg. 44 1 I 2.3.a I GENERAL FUND SUMMARY General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenue General Fund Expenses 10,000, 000 — 9,000,000 8,000,000 T 7,000,000 - • +—� 6,000, 000 • 5,000,000 4,000, 000 • 3,000,000 • • �i 2,000,000 1,000, 000 February May August November February May August November 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 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 Sales Tax General Fund Tax Revenue (2022 YTD) $7a,7ng — Property Tax $29,483 EMS Tax Other Taxes 1 I Packet Pg. 45 ■ 2.3.a City of Edmonds, WA Monthly Revenue Summary -General Fund 2022 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,459,602 $ 2,459,602 $ 2,291,020 -6.85% February 4,864,364 2,404,762 March 7,301,150 2,436,786 April 10,403, 201 3,102, 050 May 19,149,158 8,745,957 June 21,699,398 2,S50,240 July 24,202,001 2,S02,603 August 26,793,079 2,S91,078 September 29,147,977 2,354,898 October 33,153,774 4,005,797 November 41,639,264 8,485,491 December 44,204,863 2,565,599 Real Estate Excise Tax 1 & 2 General F'1nd 45,000,000 40,000,000 35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,000 / 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 381,097 $ 381,097 $ 377,895 -0.84% February 611,562 230,465 March 952,142 340,580 April 1,227,434 275,291 May 1,586,772 359,339 June 1,961,879 375,106 July 2,368,248 406,370 August 2,810,074 441,826 September 3,256,638 446,564 October 3,660,486 403,848 November 4,056,561 396,075 December 4,400,000 343,439 *The monthly budget forecast columns are based on a five-year average. 2 Packet Pg. 46 SALES TAX SUMMARY I 2.3.a I Construction Trade, $126,681 Accomniodation, $3,251 Clothing and Accessories, _ Con"uiUtions, $21,588 Wholesale Trade, $28,449 Sales Tax Analysis By Category Current Period: January 2022 Year -to -Date Total $857,872 Automotive Repair, $18,697 Amusement & Health & Recreation, $5,549 Personal Care, Business Services, $23,427 $97,903 Misc Retail, $174,833 -V 21 Others, $17,616 Gasoline, $2,829 Retail Food Stores, olk$26,919 Retail Automotive, $178,335 Manufacturing, $10,404 Eating & Drinking, $90,059 Annual Sales Tax Revenue 12,000,000 $10,302,518 10,000, 000 $7,395,114 $8,406,296 $8,452,715 $8,317,046 8,000,000 6,905,122 6,000,000 4,000,000 2,000,000 $857 872 0 2016 2017 2018 201 2020 2021 YTD 2022 3 I Packet Pg. 47 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2022 Sales and Use Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 763,651 $ 763,651 $ 857,872 12.34% February 1,704,609 940,958 March 2,420,254 715,646 April 3,074,639 654,384 May 3,893,081 818,442 June 4,672,507 779,426 July 5,523,403 850,896 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 YTD Variance Budget Forecast Budget Forecast Actuals January $ 79,399 $ 79,399 $ 96,596 21.66% February 164,205 84,806 March 246,125 81,920 April 313,860 67,734 May 367,416 53,556 June 402,173 34,757 July 429,975 27,802 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. 4 Packet Pg. 48 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 $ February 96,981 43,629 March 143,255 46,275 April 192,397 49,142 May 232,481 40,084 June 277,770 45,288 July 321,046 43,277 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 43,844-17.82% 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 $ 148,905 $ 148,905 $ 183,023 22.91% February 312,488 163,583 March 449,608 137,121 April 602,286 152,678 May 723,393 121,107 June 824,492 101,099 July 920,639 96,147 August 1,015,921 95,282 September 1,108,535 92,614 October 1,199,070 90,535 November 1,299,972 100,902 December 1,410,000 110,028 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. 5 Packet Pg. 49 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2022 Meter Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 809,979 $ 809,979 $ 827,704 2.19% February 1,383,405 573,426 March 2,213,219 829,814 April 2,744,029 530,810 May 3,542,697 798,668 June 4,167,857 625,160 July 5,138,308 970,451 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 YTD Variance Budget Forecast Budget Forecast Actuals January $ 426,464 $ 426,464 $ 417,730 22.91% February 1,352,938 926,475 March 1,779,789 426,851 April 2,159,443 379,654 May 2,586,880 427,437 June 2,966,444 379,564 July 3,385,868 419,425 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. 6 Packet Pg. 50 I 2.3.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2022 Unmeter Sewer Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 863,521 $ 863,521 $ 877,046 1.57% February 1,571,494 707,973 March 2,435,565 864,071 April 3,143,499 707,934 May 4,009,811 866,312 June 4,719,932 710,121 July 5,593,564 873,631 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 Unmeter Sewer Sales 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 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. 7 Packet Pg. 51 L 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,025,667 $ 5,025,667 $ 4,601,625 -8.44% February 8,678,232 3,652,564 March 12,655,283 3,977,051 April 16,137,953 3,482,670 May 19,831,617 3,693,665 June 24,415,118 4,583,501 July 28,300,189 3,885,070 August 31,976,258 3,676,069 September 35,862,308 3,886,050 October 40,118,953 4,256,645 November 44,587,703 4,468,750 December 49,246,551 4,658,848 Non -Departmental General Fund 45,000,000 40,000,000 35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 5,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --*--Current Year Budget —Prior Year City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,203,818 $ 2,203,818 $ 2,099,939 -4.71% February 3,113,611 909,793 March 4,271,805 1,158,194 April 4,979,272 707,467 May 5,855,316 876,044 June 7,476,682 1,621,367 July 8,412,398 935,716 August 9,181,658 769,260 September 10,074,781 893,123 October 11,198,506 1,123,725 November 12,449,206 1,250,700 December 13,677,484 1,228,278 Non -Departmental 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"— Current Year Budget --­ Prior Year *The monthly budget forecast columns are based on a five-year average. Packet Pg. 52 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 March 112,128 40,821 April 150,174 38,046 May 199,408 49,234 June 253,207 53,799 July 291,886 38,679 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 YTD Variance Budget Forecast Budget Forecast Actuals January $ 41,103 $ 41,103 $ 28,255-31.26% February 84,001 42,898 March 125,192 41,191 April 167,110 41,918 May 208,381 41,271 June 248,844 40,463 July 290,247 41,404 August 332,033 41,786 September 373,346 41,313 October 413,937 40,591 November 456,637 42,700 December 499,590 42,953 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. 9 Packet Pg. 53 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2022 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 77,402 $ 77,402 $ 59,932-22.57% February 141,639 64,236 March 202,815 61,176 April 266,756 63,941 May 331,195 64,439 June 405,872 74,678 July 464,145 58,273 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 YTD Variance Budget Forecast Budget Forecast Actuals January $ 104,268 $ 104,268 $ 91,643-12.11% February 213,906 109,638 March 322,490 108,584 April 431,592 109,102 May 548,505 116,913 June 654,584 106,079 July 763,667 109,084 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. 10 Packet Pg. 54 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2022 Community Services/Fconomic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 47,501 $ 47,501 $ 33,127-30.26% February 98,240 50,739 March 148,216 49,976 April 195,741 47,525 May 248,428 52,687 June 301,051 52,623 July 355,497 54,446 August 414,229 58,732 September 468,747 54,519 October 526,140 57,392 November 593,165 67,026 December 685,388 92,223 Community Services/Economic Development 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 -0-- Prior Year *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 55 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 $ 166,430 $ 166,430 $ 216,858 30.30% February 315,029 148,600 March 455,567 140,538 April 533,070 77,503 May 633,919 100,849 June 737,847 103,927 July 825,599 87,752 August 930,300 104,701 September 1,040,377 110,077 October 1,171,250 130,873 November 1,261,865 90,615 December 1,447,422 185,557 Finance Technology Rental Fund 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Year Budget -d­ Prior Year City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 225,174 $ 225,174 $ 217,022 -3.62% February 377,256 152,082 March 531,363 154,106 April 687,851 156,488 May 845,341 157,490 June 1,057,978 212,637 July 1,239,765 181,786 August 1,394,692 154,927 September 1,554,018 159,326 October 1,720,684 166,666 November 1,876,703 156,018 December 2,034,511 157,808 *The monthly budget forecast columns are based on a five-year average. 12 Packet Pg. 56 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 March 242,945 80,982 April 323,927 80,982 May 404,908 80,982 June 485,890 80,982 July 566,871 80,982 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 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 March 3,177,596 1,071,629 April 4,236,492 1,058,896 May 5,296,298 1,059,805 June 6,428,932 1,132,634 July 7,551,012 1,122,080 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. 13 Packet Pg. 57 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 $ 261,646 $ 261,646 $ 309,139 18.15% February 545,248 283,602 March 826,975 281,727 April 1,129,186 302,211 May 1,430,495 301,309 June 1,723,378 292,883 July 2,032,533 309,155 August 2,329,865 297,332 September 2,627,737 297,872 October 2,921,556 293,818 November 3,270,420 348,864 December 3,645,198 374,778 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 Year Budget -d­ Prior Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 355,002 $ 355,002 $ 319,222-10.08% February 741,625 386,623 March 1,126,525 384,900 April 1,522,015 395,490 May 1,924,415 402,401 June 2,349,540 425,125 July 2,810,806 461,266 August 3,318,677 507,872 September 3,838,377 519,700 October 4,255,079 416,701 November 4,650,239 395,160 December 5,081,735 431,496 *The monthly budget forecast columns are based on a five-year average. 14 Packet Pg. 58 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 $ February 100,066 50,600 March 150,167 50,100 April 201,867 51,701 May 252,421 50,554 June 303,852 51,431 July 355,684 51,832 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 22,716-54.08% 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 YTD Variance Budget Forecast Budget Forecast Actuals January $ 146,700 $ 146,700 $ 109,202-25.56% February 305,273 158,573 March 483,933 178,660 April 644,998 161,065 May 807,385 162,387 June 939,883 132,498 July 1,102,376 162,493 August 1,294,586 192,210 September 1,520,112 225,527 October 1,777,361 257,249 November 1,982,355 204,993 December 2,298,775 316,420 Facilities Maintenance 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget -0-- Prior Year *The monthly budget forecast columns are based on a five-year average. 15 Packet Pg. 59 I 2.3.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2022 Engineering Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 226,070 $ 226,070 $ 226,829 0.34% February 453,953 227,883 March 685,522 231,569 April 919,891 234,369 May 1,177,457 257,566 June 1,415,447 237,990 July 1,664,121 248,674 August 1,903,925 239,803 September 2,136,194 232,270 October 2,371,433 235,239 November 2,607,987 236,554 December 2,845,336 237,349 *The monthly budget forecast columns are based on a five-year average. 16 Packet Pg. 60 I 2.3.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of January 31, 2022 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate FFCB Bonds 1,998,548 0.37 2,000,000 2,012,268 06/14/22 1.88% Energy Northwest Bonds 1,466,077 0.41 1,345,000 1,370,985 07/01/22 5.00% Energy Northwest Bonds 260,748 0.41 250,000 252,545 07/01/22 2.95% Mason & Kitsap Cnty WA Bonds 948,084 0.83 855,000 886,173 12/01/22 5.00% Grant Cnty WA Bonds 1,517,955 0.92 1,500,000 1,508,820 01/01/23 1.54% Grant Cnty WA Bonds 576,332 0.92 520,000 540,779 01/01/23 5.0010 Seattle WA Muni Bonds 2,224,500 1.00 2,000,000 2,086,660 02/01/23 5.00% FHLB Bonds 1,996,590 1.68 2,000,000 1,979,934 10/05/23 0.22% First Financial - ECA CD 2,803,516 1.79 2,803,516 2,803,516 11/15/23 2.08% Kent WA Bonds 286,648 1.83 250,000 268,510 12/01/23 5.00% Spokane County WA Bonds 207,260 2.84 200,000 203,266 12/01/24 2.10% First Financial - Waterfront Center CD 1,575,000 5.75 1,575,000 1,575,000 11/01/27 0.25% TOTAL SECURITIES 15,861,256 1.56 15,298,516 15,488,457 Washington State Local Gov't Investment Pool 13,600,981 13,600,981 Demand 0.09% Snohomish County Local Gov't Investment Pool 42,491,058 42,491,058 Demand 1.01% TOTAL PORTFOLIO $ 71,390,555 $ 71,580,496 Issuer Diversification Seattle Kent WA, WA 2% � Muni, 13% Mason & First Kitsap Cnty Financial - WA, 6% CD, 29% Grant Cnty Spokane WA, 13% , County FHLB, WA, 1% FFCB, 13% Energy 13% Northwest, 10% Checking, Cash and Investment Balances $3.9 , 5%� (in $ Millions) CD's, $4.4, Bonds, 6% $10.9, 15% State LGIP, $13.6, 18% County LGIP, 17 Packet Pg. 61 1 I 2.3.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,236,875 18 Packet Pg. 62 I 2.3.a I Page 1 of 1 C ITY O F IDMO NDS REVINUES BY FUND - SUMMARY Fund 2022 Adopted 1/31/2021 1/31/2022 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 44,204,863 $ 2,740,276 $ 2,291,020 $ 41,913,843 50 009 LEOFF-MEDICAL INS. RESERVE 225,000 - - 225,000 00 016 BUILDING MAINTENANCE FUND - - 2,154 (2,154) 04 104 DRUG ENFORCEMENT FUND 167,210 310 350 166,860 04 Ill STREET FUND 1,751,930 111,823 109,840 1,642,090 64 112 COMBINED STREET CONST/IMPROVE 13,359,021 9,353 17,272 13,341,749 04 G 117 MUNICIPAL ARTS ACQUIS. FUND 216,701 2,840 66,051 150,650 300 y 118 MEMORIAL STREET TREE - 84 - - 04 120 HOTEL/MOTEL TAX REVENUE FUND 84,410 3,993 7,443 76,967 94 C� C 121 EMPLOYEE PARKING PERMIT FUND 26,540 4,308 6,544 19,996 25° 122 YOUTH SCHOLARSHIP FUND 1,550 58 66 1,484 40 123 TOURISM PROMOTIONAL FUND/ARTS 29,590 1,560 2,803 26,787 94 t 125 REAL ESTATE EXCISE TAX 2 2,271,020 324,010 207,937 2,063,083 90 _ O 126 REAL ESTATE EXCISE TAX 1 2,261,030 322,781 205,167 2,055,863 90 N 127 GIFT S CAT ALOG FUND 82,750 984 30,682 52,068 370 p N 130 CEMETERY MAINTENANCE/IMPROVEMT 182,430 22,035 21,909 160,521 120 136 PARKS TRUST FUND 4,330 696 785 3,545 180 3 C 137 CEMETERY MAINTENANCE TRUST FD 43,520 6,911 7,454 36,066 170 138 SISTER CITY COMMISSION 10,290 43 72 10,218 14 140 BUSINESS IMPROVEMENT DISTRICT 79,349 23,740 26,615 52,734 340 O Q. 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 6,696 7,392 57,608 110 � 142 EDMONDS RESCUE PLAN FUND 4,856,549 - - 4,856,549 00 <0 143 TREE FUND 215,330 - 95 215,235 04 C 231 2012 LT GO DEBT SERVICE FUND 611,370 - - 611,370 04 E 332 PARKS CAPITAL CONSTRUCTION FUND 3,822,685 11,093 8,968 3,813,717 04 >, 411 COMBINED UTILITY OPERATION - 80 15 140 (15 140) s 00 +r 421 WATER UTILITY FUND 11,018,136 868,240 945,211 10,072,925 94 422 STORM UTILITY FUND 8,277,897 920,517 463,073 7,814,824 64 423 SEWER/WWTP UTILITY FUND 16,001,340 2,459,980 2,368,069 13,633,271 150 424 BOND RESERVE FUND 1,988,700 1 1 1,988,699 00 511 EQUIPMENT RENTAL FUND 1,925,920 117,942 164,644 1,761,276 94 512 TECHNOLOGY RENTAL FUND 1,153,570 103,236 99,804 1,053,766 94 $ 114,938,031 $ 8,063,589 $ 7,076,562 $ 107,861,469 60 19 Packet Pg. 63 I 2.3.a I Page 1 of 1 C ITY OF EDMO NDS EEXPENDPIURES BY FUND - SUMMARY Fund 2022 Adopted 1/31/2021 1/31/2022 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 49,246,551 $ 4,488,492 $ 4,601,625 $ 44,644,926 9° 009 LEOFF-MEDICAL INS. RESERVE 260,490 35,624 24,608 235,882 90 014 HISTORIC PRESERVATION GIFT FUND 5,900 - 5,900 00, 016 BUILDING MAINTENANCE FUND 980,000 - 980,000 00, 104 DRUG ENFORCEMENT FUND 45,800 - 45,800 00, Ill STREET FUND 2,254,676 275,734 305,309 1,949,367 14° G 112 COMBINED STREET CONST/IMPROVE 12,542,946 - 592 12,542,354 00, 117 MUNICIPAL ARTSACQUIS. FUND 181,880 4,424 1,025 180,855 10,, 120 HOTEL/MOTEL TAX REVENUE FUND 100,900 1,866 2,852 98,048 3° 'V C 121 EMPLOYEE PARKING PERMIT FUND 26,880 - - 26,880 0° C 122 YOUTH SCHOLARSHIP FUND 3,000 (150) 3,150 -50, LL 123 TOURISM PROMOTIONAL FUND/ARTS 28,200 - - 28,200 00, t 125 REAL ESTATE EXCISE TAX 2 4,279,876 4,494 113,698 4,166,178 30/ C 126 REAL ESTATE EXCISE TAX 1 1,922,273 - - 1,922,273 00 N 127 GIFTS CATALOG FUND 78,400 - 2,114 76,286 30, NG N 130 CEMETERY MAINTENANCE/IMPROVEMT 220,561 13,305 12,170 208,391 60, 136 PARKS TRUST FUND - - - - 00 C 137 CEMETERY MAINTENANCE TRUST FUND 25,000 - 25,000 0° cc 138 SISTER CITY COMMISSION 11,900 - 11,900 00, 140 BUSINESS IMPROVEMENT DISTRICT 87,680 17 66 87,614 00, Q 142 EDMONDS RESCUE PLAN FUND 1,250,000 8,697 1,241,303 1° � 143 TREE FUND 214,800 - 214,800 0° 231 2012 LT GO DEBT SERVICE FUND 611,370 - 611,370 04 R 332 PARKS CAPITAL CONSTRUCTION FUND 7,321,018 776,108 6,544,910 110, C 421 WATER UTILITY FUND 11,110,498 364,887 395,325 10,715,173 40 422 STORM UTILITY FUND 8,638,202 281,015 297,134 8,341,068 30 423 SEWER/WWTP UTILITY FUND 15,656,812 658,837 813,268 14,843,544 50, 424 BOND RESERVE FUND 1,988,710 - - 1,988,710 00, 511 EQUIPMENT RENTAL FUND 1,942,460 135,027 134,328 1,808,132 70 512 TECHNOLOGY RENTAL FUND 1,447,422 117,002 216,858 1,230,564 150 617 FIREMEN'S PENSION FUND - 7,930 - - 00 $ 122,484,205 $ 6,388,652 $ 7,705,628 $114,778,577 60, 20 Packet Pg. 64 2.3.a Page 1 of 3 C ITY O F IDMO NDS REVENUES - GENERAL FUND 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 1 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GAS UTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWER UTILITYTAX 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 INTERGO VERNNIENTAL: 32 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 33 HIGH VISIBILITY ENFORCEMENT 34 CORONAVIRUS RELIEF FUND 2 35 DOC FAC ROOFING 36 STATE GRANTS- BUDGET ONLY 37 PUD PRIVILEDGE TAX 38 CJ - POPULATION 39 TRIAL COURT IMPROVEMENT 40 CRIMINAL JUSTICE -SPECIAL PROGRAMS 41 MARIJUANA EXCISE TAX DISTRIBUTION 42 DUI - CITIES 43 LIQUOR EXCISE TAX 44 LIQUOR BOARD PROFITS 45 FIRST RESPONDERS FLEX FUND 46 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 11,127,000 $ 108,345 $ 74,705 $ 11,052,295 10/ 4,278,000 42,305 29,483 4,248,517 10/ 500 1 - 500 00/ 10,000,000 774,198 857,872 9,142,128 90/ 7,600 500 1,711 5,889 230/ 870,000 70,622 83,949 786,051 100/ 1,410,000 192,356 183,023 1,226,977 130/ 595,000 84,132 96,596 498,404 160/ 284,000 27,563 19,424 264,576 70/ 953,000 78,573 82,771 870,230 90/ 894,600 80,611 87,637 806,963 100/ 471,900 37,788 41,773 430,127 90/ 792,000 67,310 69,365 722,635 90/ 523,000 56,592 43,844 479,156 80/ 55,200 21,500 11,095 44,105 200/ 350 143 - 350 00/ 306,000 - 0 306,000 00/ 32,568,150 1,642,539 1,683,249 30,884,901 50/ 250 100 - 250 00/ 700 - - 700 00/ 40,000 4,253 3,650 36,350 90/ 702,700 170,449 179,444 523,256 260/ 41,000 3,221 3,060 37,940 70/ 100,600 - - 100,600 00/ 384,000 - - 384,000 00/ 250,000 21,921 23,825 226,175 100/ 63,000 7,190 8,220 54,780 130/ 30,000 14,440 30,173 (173) 1010/ 650,600 31,022 31,790 618,810 50/ 24,000 2,914 5,249 18,751 220/ 55,000 2,280 (13,958) 68,958 -250/ 20,000 1,238 1,250 18,750 60/ 2,361,850 259,027 272,703 2,089,147 120, 9,000 2,671 5,237 3,763 580/ 11,100 417 718 10,382 60/ - 3,947 - - 00/ - 379,270 - - 00/ 273,000 - - 273,000 00/ 210,500 - - 210,500 00/ 13,070 3,379 3,571 9,499 270/ 16,740 - - 16,740 00/ 45,600 12,061 12,693 32,907 280/ 60,000 - - 60,000 00/ 4,500 1,667 1,793 2,707 400/ 261,500 68,016 72,230 189,270 280/ 343,200 - - 343,200 00/ 1,000 - - 1,000 00/ 550 - - 550 00/ 1,249,760 471,429 96,243 1,153,517 80, O d 2 C cC C LL t W c O 2 N N O N t0 3 C ca 2022 Local Retail Sales/Use Tax revenues are $83,674 higher than 2021 revenues. Please also see pagespages 3 & 4 . 21 1 Packet Pg. 65 1 2.3.a Page 2 of 3 C ITY O F IDMO NDS REVENUES - GENERAL FUND 2022 Adopted 1/31/2021 1/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 PAYMENTSFROMSI'ATIONS 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 WINTERMARKET FEES 43 BIRD FEST REGISTRATION FEES 44 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 417 $ 317 $ 2,684 110r 600 11 22 578 40/ 11,000 437 183 10,817 20r 150 - - 150 00/ 300 - - 300 00/ - 168 - - 00/ 4,000 - - 4,000 00/ 1,000 28 31 969 30/ 50 20 5 45 90r 100 - - 100 00/ 25,000 - - 25,000 00/ 600 - - 600 00/ 1,000 - - 1,000 00/ 5,000 - - 5,000 00/ 180,000 6,640 15,852 164,148 90/ 1,400 - - 1,400 00/ 85,000 600 600 84,400 10/ 10,000 - 490 9,510 501 30,000 - - 30,000 00/ 14,000 - - 14,000 00/ 210,970 51,206 - 210,970 00/ - - 13 (13) 00/ 57,000 - 15,373 41,627 270/ 1,050 28 26 1,024 20r 38,000 3,576 1,797 36,203 501 3,000 45 39 2,961 10/ 10,000 1,748 2,625 7,375 260r 3,500 187 64 3,436 20/ 1,007,500 - - 1,007,500 00/ 2,500 - 318 2,182 130/ 100 - - 100 00/ 65,600 6,910 8,525 57,075 130/ 425,000 99,215 18,436 406,564 40/ 4,000 809 1,728 2,272 430/ 500 - - 500 00/ 3,000 - - 3,000 00/ 14,000 715 2,345 11,655 170/ 13,000 - 16 12,984 00/ 1,011,580 7,559 (8,999) 1,020,579 -10/ 1,300 - - 1,300 00/ 5,000 185 - 5,000 00/ - - 3,290 (3,290) 00/ 1,000 - - 1,000 00/ 3,575,713 101,192 98,208 3,477,505 30/ 6,825,513 281,694 161,302 6,664,211 20, 22 Packet Pg. 66 2.3.a Page 3 of 3 C ITY O F EDMO NDS REVENUES - GENERAL FUND 2022 Adopted 1/31/2021 1/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 NIIS C ELLANEO US : 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIESRENTALS 30 BRACKET ROOM RENTAL 31 LEASES LONG TERM 32 DONATION/CONTRIBUTION 33 PARKSDONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHER JUDGEMENT/SETTLEMENT 40 POLICE JUDGMENTS✓RESTITUTION 41 CASHIERS OVERAGES✓SHORTAGES 42 OTHER MISC REVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - MUNICIPAL COURT 46 NSF FEES - DEVEL SERV DEPT 47 US BANK REBATE TRANSFERS -IN: 48 TRANSFER FROM FUND 127 TOTAL GENERAL FUND REVENUE $ 2,000 $ 244 $ 147 $ 1,853 70/ 230,000 14,030 6,182 223,818 30/ 18,000 946 562 17,438 30/ 10,000 1,154 341 9,659 30/ 1,000 - - 1,000 00/ 1,500 281 145 1,355 100/ 100,000 5,320 1,760 98,240 20/ 2,000 - 17 1,983 10/ 7,000 696 240 6,760 30/ 300 5 - 300 00/ 100 3 4 96 40/ 1,500 253 132 1,368 90/ 25,000 1,257 590 24,410 20/ 2,000 151 95 1,905 501 700 13 - 700 00/ 100 - - 100 00/ 10,000 298 252 9,748 30/ 800 - - 800 00/ 1,000 1 47 953 50/ 200 7 - 200 00/ 8,000 205 155 7,845 20/ 14,000 757 295 13,705 20/ 3,000 272 - 3,000 00/ 10,100 - - 10,100 00/ 150 - - 150 00/ 448,450 25,895 10,964 437,486 20, 270,390 40,842 44,969 225,421 170/ 13,340 755 339 13,001 30/ 10,180 835 607 9,573 60/ 153,000 183 1,773 151,228 1 °/ 2,100 - - 2,100 00/ 205,000 16,215 17,594 187,406 90/ 2,500 - - 2,500 00/ 3,500 - 300 3,200 90/ 1,500 - - 1,500 00/ 5,000 - - 5,000 00/ 300 - - 300 00/ 3,800 - 220 3,580 60/ 2,000 - - 2,000 00/ 2,000 - - 2,000 00/ 200 - - 200 00/ - 2 - - 00/ 41,180 829 758 40,422 20/ 100 3 - 100 00/ 100 30 - 100 00/ 150 - - 150 00/ - - - - 00/ 8,500 - - 8,500 00/ 724,840 59,693 66,559 658,281 90, 26,300 - - 26,300 00/ 26,300 - - 265300 00/ $ 44,204,863 $ 2,740,276 $ 2,291,020 $ 41,913,843 50/ 23 Packet Pg. 67 I 2.3.a I Page 1 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 19,287,640 $ 1,472,550 $ 1,446,469 $ 17,841,171 74 2 OVERTIME 594,080 50,514 95,583 498,497 160 3 HOLIDAY BUY BACK 294,001 1,951 - 294,001 04 4 BENEFITS 6,851,499 548,288 558,402 6,293,097 M 5 UNIFORMS 119,151 7,484 2,922 116,229 29 6 PENSION AND DISABILITY PAYMENTS 70,944 - 5,912 65,032 80 7 SUPPLIES 486,165 22,981 12,614 473,551 34 8 SMALL EQUIPMENT 204,019 1,281 3,159 200,860 24 9 PROFESSIONAL SERVICES 15,214,167 1,573,825 1,568,988 13,645,179 100 10 COMMUNICATIONS 171,235 5,878 874 170,361 I° 11 TRAVEL 81,155 - 557 80,598 14 12 EXCISE TAXES 16,500 1,061 1,241 15,259 M 13 RENTAL/LEASE 2,091,693 123,212 172,908 1,918,785 84 14 INSURANCE 375,539 405,121 503,160 (127,621) 1344 15 UTILITIES 529,462 36,889 12,464 516,998 2° 16 REPAIRS&MAINTENANCE 364,850 82,644 67,115 297,735 180 17 MISCELLANEOUS 660,023 103,968 99,256 560,767 150 18 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 50,000 - 10M 19 INTERFUND SUBSIDIES 1,185,000 - - 1,185,000 M 20 MACHINERY/EQUIPMENT - 844 - - 00 21 CONSTRUCTION PROJECTS 270,180 - - 270,180 04 22 GENERAL OBLIGATION BOND PRINCIPAL 55,170 - - 55,170 M 23 INTEREST ON LONG-TERM EXTERNAL DEBT 4,790 - - 4,790 M 24 DEBT ISSUE COSTS 268,788 - - 268,788 00 25 OTHER INTEREST & DEBT SERVICE COSTS 500 - - 500 04 99,246,551 4,488,492 4,601,625 44,644,926 7 LEO FF-MEDIC AL INS. RESERVE (009) 26 BENEFITS $ - $ 15,899 $ 10,187 $ (10,187) 00 27 PENSION AND DISABILITY PAYMENTS 252,990 19,725 14,421 238,569 64 28 PROFESSIONAL SERVICES 7,000 - - 7,000 M 29 MISCELLANEOUS 500 - - 500 09 260,490 S 35,624 24,608 235,882 94 HISTORIC PRESERVATION GIFT FUND (014) 30 SUPPLIES $ 100 $ - $ - $ 100 M 31 PROFESSIONAL SERVICES 200 - 200 09 32 MISCELLANEOUS 5,600 - 5,600 M 5,900 - 5,900 04 BUILDING MAINTENANCE FUND (016) 33 PROFESSIONAL SERVICES $ 115,000 $ - $ - $ 115,000 09 34 REPAIR & MAINTENANCE 665,000 - - 665,000 M 35 MACHINERY/EQUIPMENT 90,000 - - 90,000 M 36 CONSTRUCTION PROJECTS 110,000 - - 110,000 M 980,000 - - 980,000 M DRUG ENFO RC EMENT FUND (104) 37 PROFESSIONAL SERVICES $ 45,000 $ $ $ 45,000 M 38 REPAIR/MAINT 800 800 M 45,800 45,800 M 24 Packet Pg. 68 I 2.3.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent STREETFUND (111) 1 SALARIES AND WAGES $ 749,110 $ 63,485 $ 57,414 $ 691,696 84 2 OVERTIME 38,400 4,417 3,914 34,486 104 3 BENEFITS 347,919 30,344 30,443 317,476 90 4 UNIFORMS 6,000 - - 6,000 04 5 SUPPLIES 263,000 151 - 263,000 0° 6 SMALL EQUIPMENT 20,000 - - 20,000 00 7 PROFESSIONAL SERVICES 23,210 3,505 4,337 18,873 190 8 COMMUNICATIONS 4,500 121 - 4,500 0° 9 TRAVEL 1,000 - - 1,000 04 10 RENTAL/LEASE 290,150 20,471 24,042 266,108 M 11 INSURANCE 123,007 148,533 184,111 (61,104) 1504 12 UTILITIES 273,730 2,775 - 273,730 00 13 REPAIRS & MAINTENANCE 72,000 - - 72,000 0° 14 MISCELLANEOUS 8,000 1,931 1,049 6,951 130 15 MACHINERY/EQUIPMENT 30,000 - - 30,000 0° 16 GENERAL OBLIGATION BOND PRINCIPAL 4,270 - - 4,270 04 17 INTEREST 380 - - 380 04 $ 2,254,676 $ 275,734 $ 305,309 $ 1,949,367 144 COMBINED STREETCONST/IMPROVE(112) 18 PROFESSIONAL SERVICES $ 3,159,560 $ - $ 592 $ 3,158,968 W 19 REPAIR& MAINTENANCE 1,495,470 - - 1,495,470 09 20 INTERFUND SUBSIDIES 108,975 - - 108,975 M 21 CONSTRUCTION PROJECTS 7,705,471 - - 7,705,471 W 22 INTERGOVERNMENTAL LOANS 72,220 - - 72,220 09 23 INTEREST 1,250 - - 1,250 M $ 12,542,946 $ - $ 592 $ 12,542,354 W MUNICIPAL ARTS ACQUIS. FUND (117) 24 SUPPLIES $ 4,700 $ - $ - $ 4,700 M 25 SMALL EQUIPMENT 1,700 - - 1,700 W 26 PROFESSIONAL SERVICES 166,500 3,812 - 166,500 W 27 TRAVEL 80 - - 80 W 28 RENTAL/LEASE 2,000 - - 2,000 W 29 REPAIRS & MAINTENANCE 300 - - 300 09 30 MISCELLANEOUS 6,600 612 1,025 5,575 160 $ 181,880 $ 4,424 $ 1,025 $ 180,855 1° HO TEL/MO TEL TAX REVENUE FUND (120) 31 PROFESSIONAL SERVICES $ 95,900 $ 1,866 $ 2,852 $ 93,048 M 32 MISCELLANEOUS 1,000 - - 1,000 0° 33 INTERFUND SUBSIDIES 4,000 - - 4,000 04 $ 100,900 $ 1,866 $ 2,852 $ 98,048 M EMPLOYEEPARHING PERMIT FUND (121) 34 SUPPLIES $ 1,790 $ - $ - $ 1,790 0° 35 PROFESSIONAL SERVICES 25,090 - 25,090 04 $ 26,880 $ S - $ 26,880 W YOUTH SCHOLARSHIP FUND (122) 36 MISCELLANEOUS $ 3,000 $ $ (150) $ 3,150 -50 $ 3,000 $ $ (150) $ 3,150 -54 TOURISM PROMOTIONAL FUND/ARTS (123) 37 PROFESSIONAL SERVICES $ 28,200 $ - $ - $ 28,200 W $ 28,200 $ - $ - $ 28,200 W 25 Packet Pg. 69 I 2.3.a I Page 3 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXC ISE TAX 2 (125) 1 SUPPLIES $ 21,000 $ 4,494 $ 253 $ 20,747 19 2 PROFESSIONAL SERVICES 409,320 - - 409,320 M 3 REPAIRS & MAINTENANCE 566,500 - 43,686 522,814 M 4 INTERFUND SUBSIDIES 2,534 - - 2,534 09 5 CONSTRUCTION PROJECTS 3,280,522 - 69,759 3,210,763 24 $ 4,279,876 $ 4,494 $ 113,698 $ 4,166,178 34 REAL ESTATE EXCISE TAXI (126) 6 PROFESSIONAL SERVICES 7 REPAIRS & MAINTENANCE 8 INTERFUND SUBSIDIES 9 CONSTRUCTION PROJECTS 10 GENERAL OBLIGATION BONDS 11 INTEREST GWIS CATALOG FUND (127) 12 SUPPLIES 13 PROFESSIONAL SERVICES 14 MISCELLANEOUS 15 INTERFUND SUBSIDIES CEVIEIIItY MAINTENANCE%IlVIPRO VEMENT (130) 16 SALARIES AND WAGES 17 OVERTIME 18 BENEFIT S 19 UNIFORMS 20 SUPPLIES 21 SUPPLIES PURCHASED FOR INVENTORY/RESALE 22 PROFESSIONAL SERVICES 23 COMMUNICATIONS 24 TRAVEL 25 RENTAL/LEASE 26 UTILITIES 27 REPAIRS & MAINTENANCE 28 MISCELLANEOUS CEMEIERY MAINTENANCE TRUST FUND (137) 29 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 30 SUPPLIES 31 TRAVEL 32 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 33 SUPPLIES 34 PROFESSIONAL SERVICES 35 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 36 PROFESSIONAL SERVICES TREE FUND (143) 37 SUPPLIES 38 PROFESSIONAL SERVICES 39 LAND 2012 LTGO DEBT SERVIC FUND (231) 40 GENERAL OBLIGATION BOND 41 INTEREST $ 309,053 $ - $ - $ 309,053 M 769,790 - - 769,790 00 144,970 - - 144,970 M 438,000 - - 438,000 04 149,820 - - 149,820 04 110,640 - - 110,640 09 $ 1,922,273 $ - $ - $ 1,922,273 M $ 45,000 $ - $ 2,114 $ 42,886 59 6,500 - - 6,500 0° 600 - - 600 04 26,300 - - 26,300 04 $ 78,400 $ - $ 2,114 $ 76,286 M $ 119,837 $ 7,143 $ 7,143 $ 112,694 69 3,500 30 30 3,470 14 41,069 3,177 3,083 37,986 M 1,000 - - 1,000 00 7,000 - - 7,000 04 20,000 627 - 20,000 04 4,200 800 800 3,400 190 1,700 140 140 1,560 M 500 - - 500 0° 11,690 1,388 974 10,716 89 5,565 - - 5,565 04 500 - - 500 04 4,000 - - 4,000 09 $ 220,561 $ 13,305 $ 12,170 $ 208,391 64 $ 25,000 $ - $ - $ 25,000 04 $ 25,000 $ - $ - $ 25,000 M $ 1,500 $ - $ - $ 1,500 04 4,500 - 4,500 M 5,900 - 5,900 04 $ 11,900 $ $ - $ 11,900 0° $ 4,050 $ $ - $ 4,050 04 77,535 - 50 77,485 09 6,095 17 17 6,078 04 87,680 17 66 87,614 04 $ 1,250,000 $ - $ 8,697 $ 1,241,303 14 1,250,000 - 8,697 1,241,303 14 $ 1,000 $ - $ - $ 1,000 M 14,800 - - 14,800 04 199,000 - - 199,000 09 214,800 - - 214,800 04 $ 550,000 $ - $ - $ 550,000 04 61,370 - - 61,370 M $ 611,370 $ - $ - $ 611,370 0° 26 Packet Pg. 70 I 2.3.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 95,832 $ - $ - $ 95,832 04 2 INTERFUND SUBSIDIES 63,000 - 62,656 344 990 3 CONSTRUCTION PROJECTS 7,063,788 - 713,452 6,350,336 104 4 DEBT ISSUE COSTS 98,398 - - 98,398 04 $ 7,321,018 $ - $ 776,108 $ 6,544,910 110 WATER FUND (421) 5 SALARIES AND WAGES 6 OVERTIME 7 BENEFIT S 8 UNIFORMS 9 SUPPLIES 10 WATER PURCHASED FOR RESALE 11 SUPPLIES PURCHASED FOR INVENTORY/RESALE 12 SMALL EQUIPMENT 13 PROFESSIONAL SERVICES 14 COMMUNICATIONS 15 TRAVEL 16 EXCISE TAXES 17 RENTAL/LEASE 18 INSURANCE 19 UTILITIES 20 REPAIRS & MAINTENANCE 21 MISCELLANEOUS 22 INTERFUND SUBSIDIES 23 MACHINERY/EQUIPMENT 24 CONSTRUCTION PROJECTS 25 GENERAL OBLIGATION BONDS 26 REVENUE BONDS 27 INTERGOVERNMENTAL LOANS 28 INTEREST STORM FUND (422) 29 SALARIES AND WAGES 30 OVERTIME 31 BENEFIT S 32 UNIFORMS 33 SUPPLIES 34 SMALL EQUIPMENT 35 PROFESSIONAL SERVICES 36 COMMUNICATIONS 37 TRAVEL 38 EXCISE TAXES 39 RENTALILEASE 40INSURANCE 41 UTILITES 42 REPAIR & MAINTENANCE 43 MISCELLANEOUS 44 INTERFUND SUBSIDIES 45 CONSTRUCTION PROJECTS 46 GENERAL OBLIGATION BONDS 47 REVENUE BONDS 48 INTERGOVERNMENTAL LOANS 49 INTEREST $ 842,096 $ 57,280 $ 57,765 $ 784,331 74 24,000 1,468 3,006 20,994 1M 330,100 23,617 25,329 304,771 M 4,000 - - 4,000 00 150,000 994 9,123 140,877 64 2,170,000 - - 2,170,000 0° 170,000 2,934 - 170,000 04 11,000 - - 11,000 04 1,982,043 36,717 26,235 1,955,808 I4 30,000 878 427 29,573 I° 200 - - 200 00 1,649,700 109,183 112,579 1,537,121 74 152,590 10,086 12,398 140,192 80 107,265 98,196 122,359 (15,094) 1140 35,000 2,079 - 35,000 04 176,130 10,211 10,508 165,622 64 123,600 11,242 15,596 108,004 130 645,370 - - 645,370 04 10,000 - - 10,000 04 1,888,334 - - 1,888,334 00 2,870 - - 2,870 04 399,780 - - 399,780 00 25,840 - - 25,840 04 180,580 - - 180,580 04 $ 11,110,498 $ 364,887 $ 395,325 $ 10,715,173 44 $ 734,284 $ 62,433 $ 62,938 $ 671,346 99 26,000 1,395 3,536 22,464 144 294,767 27,072 26,681 268,086 99 6,500 20 - 6,500 0° 46,000 969 - 46,000 0° 4,000 - - 4,000 04 3,178,025 33,281 24,395 3,153,630 I4 3,200 35 - 3,200 00 4,300 - - 4,300 0° 470,100 42,906 47,280 422,820 104 267,150 21,872 21,817 245,333 M 144,126 66,228 82,335 61,791 57 10,500 1,636 - 10,500 04 67,130 10,211 10,508 56,622 164 232,300 12,959 17,643 214,657 84 297,787 - - 297,787 04 2,397,333 - - 2,397,333 09 104,540 - - 104,540 04 195,390 - - 195,390 04 53,590 - - 53,590 04 101,180 - - 101,180 0° $ 8,638,202 $ 281,015 $ 297,134 $ 8,341,068 M 27 Packet Pg. 71 I 2.3.a I Page 5 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,090,461 $ 151,850 $ 171,709 $ 1,918,752 84 2 OVERTIME 95,000 12,123 19,268 75,732 2M 3 BENEFITS 847,408 65,060 60,712 786,696 74 4 UNIFORMS 9,500 267 2,193 7,307 230 5 SUPPLIES 421,000 13,736 14,143 406,857 34 6 FUEL CONSUMED 60,000 - - 60,000 M 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 M 8 SMALL EQUIPMENT 35,000 1,468 41,516 (6,516) 1190 9 PROFESSIONAL SERVICES 2,193,884 67,560 92,109 2,101,775 44 10 COMMUNICATIONS 43,000 1,086 2,740 40,260 6° 11 TRAVEL 5,000 - - 5,000 M 12 EXCISE TAXES 978,000 93,839 103,324 874,676 i i4 13 RENTAL/LEASE 317,410 26,905 25,987 291,423 M 14 INSURANCE 185,052 162,851 202,407 (17,355) 109° 15 UTILITIES 1,532,060 38,612 26,261 1,505,799 20 16 REPAIR & MAINTENANCE 790,630 12,679 39,099 751,531 54 17 MISCELLANEOUS 126,350 9,420 11,801 114,549 94 18 INTERFUND SUBSIDIES 1,909,744 - - 1,909,744 M 19 CONSTRUCTION PROJECTS 3,265,383 - - 3,265,383 M 20 GENERAL OBLIGATION BONDS 126,500 - - 126,500 M 21 REVENUE BONDS 89,840 - - 89,840 M 22 INTERGOVERNMENTAL LOANS 174,610 - - 174,610 M 23 INTEREST 356,980 - - 356,980 M 24 DEBT ISSUE COSTS - 1,380 - - M $ 15,656,812 $ 658,837 $ 813,268 $ 14,843,544 54 BOND RESERVE FUND (424) 25 REVENUE BONDS $ 810,010 $ - $ - $ 810,010 04 26 INTEREST 1,178,700 - - 1,178,700 04 $ 1,988,710 $ - $ - $ 1,988,710 v O d Q-' 2 C O C LL t C O 2 N N O N O 3 C to 28 Packet Pg. 72 I 2.3.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent EQUIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 275,712 $ 23,099 $ 23,511 $ 252,201 99 2 OVERTIME 2,000 - 222 1,778 110 3 BENEFITS 112,077 9,450 9,848 102,229 94 4 UNIFORMS 1,500 41 21 1,479 1° 5 SUPPLIES 120,000 2,862 5,842 114,158 54 6 FUEL CONSUMED 1,000 - - 1,000 04 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 268,000 5,128 41,653 226,347 164 8 SMALL EQUIPMENT 58,000 55 - 58,000 00 9 PROFESSIONAL SERVICES 46,750 ill 56 46,694 09 10 COMMUNICATIONS 3,000 121 - 3,000 0° 11 TRAVEL 1,000 - - 1,000 0° 12 RENTAL/LEASE 11,160 1,036 879 10,281 M 13 INSURANCE 41,261 39,334 51,903 (10,642) 1260 14 UTILITIES 14,000 1,636 - 14,000 0° 15 REPAIRS&MAINTENANCE 60,000 1,106 - 60,000 09 16 MISCELLANEOUS 12,000 1,487 393 11,607 M 17 MACHINERY/EQUIPMENT 915,000 49,560 - 915,000 04 $ 1,942,460 $ 135,027 $ 134,328 $ 1,808,132 74 TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 442,074 $ 25,594 $ 21,273 $ 420,801 54 19 OVERTIME 2,000 303 - 2,000 04 20 BENEFITS 159,538 8,848 10,460 149,078 74 21 SUPPLIES 5,000 226 - 5,000 0° 22 SMALL EQUIPMENT 266,300 1,922 3,084 263,216 19 23 PROFESSIONAL SERVICES 61,860 1,016 968 60,892 24 24 COMMUNICATIONS 58,770 4,410 4,116 54,654 74 25 TRAVEL 1,500 - - 1,500 04 26 RENTAL/LEASE 7,460 367 372 7,088 54 27 REPAIRS & MAINT ENANCE 381,920 74,316 176,586 205,334 464 28 MISCELLANEOUS 5,000 - - 5,000 04 29 MACHINERY/EQUIPMENT 56,000 - - 56,000 09 $ 1,447,422 $ 117,002 $ 216,858 $ 1,230,564 150 FH2EMAN'S PENSION FUND (617) 30 BENEFITS $ - $ 2,804 $ - $ - 0° 31 PENSION AND DISABILITY PAYMENTS 5,127 - 04 $ - $ 7,930 $ - $ - 04 TOTAL EXPENDITURE ALL FUNDS $ 122,484,205 $ 6,388,652 $ 7,705,628 $ 114,778,577 64 29 Packet Pg. 73 2.3.a Page 1 of 1 C ITY O F IDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2022 Adopted 1/31/2021 1/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 $ 497,900 $ 26,808 $ 23,687 $ 474,213 5% 499,590 27,531 28,255 471,335 6% 824,831 75,120 59,932 764,899 7% 1,368,755 93,953 91,643 1,277,113 7% - 78,859 - - 0% G 0. 2,034,511 137,736 217,022 1,817,489 11% lY 971,780 69,941 77,656 894,124 8% 13,677,484 2,013,112 2,099,939 11,577,545 15% 13,375,470 992,942 973,358 12,402,112 7% LL 166,576 - 3,488 163,088 2% 685,388 43,221 33,127 652,261 5% r� C 2 3,645,198 219,157 309,139 3,336,059 8% N 659,109 - 6,409 652,700 1% N N 5,081,735 308,283 319,222 4,762,513 6% cv 3,459,449 258,921 249,545 3,209,904 7% cv 2,298,775 142,909 109,202 2,189,573 5% $ 49,246,551 $ 4,488,492 $ 4,601,625 $ 44,644,926 9% O CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2022 Adopted Budget 1/31/2021 Expenditures 1/31/2022 Expenditures Amount Remaining %Spent WATER UTILITYFUND $ 11,110,498 $ 364,887 $ 395,325 $ 10,715,173 4% STORM UTILITY FUND 8,638,202 281,015 297,134 8,341,068 3% SEWER/WWTP UTILITY FUND 15,656,812 658,837 813,268 14,843,544 5% BOND RESERVE FUND 1,988,710 - - 1,988,710 0% $ 37,394,222 $ 1,304,739 $ 1,505,728 $ 35,888,494 4% 30 Packet Pg. 74 I 2.3.a I Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY COUNCIL SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES O FFIC E O F MAYO R SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES HUMAN RESOURCES SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES MUNICIPAL C O URT SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES CITY CLERK SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES $ 204,132 $ 17,347 $ 14,460 $ 189,672 7% 121,868 8,436 7,836 114,032 6% 2,000 - - 2,000 0% 169,900 1,024 1,392 168,508 1% $ 497,900 $ 26,808 $ 23,687 $ 474,213 5% $ 343,523 $ 19,125 $ 19,358 $ 324,165 6% 113,237 7,039 7,397 105,840 7% t' 6,500 - 20 6,480 0% Q. 36,330 1,367 1,481 34,849 4% 4) $ 499,590 $ 27,531 $ 28,255 $ 471,335 6% _ $ 398,299 $ 33,015 $ 35,351 $ 362,948 9% 142,526 13,009 15,053 127,473 11% 13,600 585 - 13,600 0% IL 270,406 28,512 9,527 260,879 4% >+ $ 824,831 $ 75,120 $ 59,932 $ 764,899 7%�., C O $ 910,606 $ 67,938 $ 67,478 $ 843,128 7% 2 217,654 19,223 17,025 200,629 8% N 11,600 - - 11,600 0% 228,895 6,792 7,140 221,755 3% N $ 1,368,755 $ 93,953 $ 91,643 $ 1,277,113 7% 7 C $ - $ 33,306 $ - $ - 0% - 14,985 - 0% .i 0 - 403 - 0% O - 30,164 - 0% Q- $ - $ 78,859 $ - $ - 0% ADMINIS TRATIVE S ERVIC ES SALARIES AND WAGES $ 1,301,073 $ 61,812 $ 109,250 $ 1,191,823 8% BENEFITS 413,858 21,831 38,720 375,138 9% SUPPLIES 13,000 239 325 12,675 2% SERVICES 306,580 53,855 68,727 237,853 22% $ 2,034,511 $ 137,736 $ 217,022 $ 1,817,489 11% CITY ATPO RNEY SERVICES $ 971,780 $ 69,941 $ 77,656 $ 894,124 8% $ 971,780 $ 69,941 $ 77,656 $ 894,124 8% NON -DEPARTMENTAL SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% BENEFITS 145,504 8,868 7,172 138,332 5% SUPPLIES 5,000 - - 5,000 0% SERVICES 11,860,982 1,954,243 2,042,767 9,818,215 17% INTERFUND SUBSIDIES 1,235,000 50,000 50,000 1,185,000 4% DEBT SERVICE - PRINCIPAL 55,170 - - 55,170 0% DEBT SERVICE - INTEREST 274,078 274,078 0% $ 13,677,484 $ 2,013,112 $ 2,099,939 $ 11,577,545 15% PO LIC E SERVIC ES SALARIES AND WAGES $ 8,723,512 $ 681,894 $ 648,581 $ 8,074,931 7% BENEFITS 2,994,876 233,026 229,670 2,765,206 8% SUPPLIES 281,569 7,336 2,240 279,329 1% SERVICES 1,375,513 70,687 92,867 1,282,646 7% $ 13,375,470 $ 992,942 $ 973,358 $ 12,402,112 7% SATELLITE O FFIC E SALARIES AND WAGES $ 25,000 $ - $ - $ 25,000 0% BENEFIT S 5,000 - 5,000 0% SUPPLIES 12,000 3,159 8,841 26% SERVICES 124,576 329 124,247 0% $ 166,576 $ $ 3,488 $ 163,088 2% 31 Packet Pg. 75 Page 2 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2022 Adopted 1/31/2021 1/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY SERVICES/ECON DEV. SALARIES AND WAGES $ 365,627 $ 26,976 $ 17,317 $ 348,310 5% BENEFITS 111,361 7,562 5,592 105,769 5% SUPPLIES 4,075 - 184 3,891 5% SERVICES 204,325 8,682 10,035 194,290 5% $ 685,388 $ 43,221 $ 33,127 $ 652,261 5% DEVELO PMEVT S ERVIC ES /PLANNING SALARIES AND WAGES $ 1,958,832 $ 145,459 $ 216,256 $ 1,742,576 11% BENEFITS 681,706 54,939 70,753 610,953 10% SUPPLIES 19,400 474 - 19,400 0% SERVICES 985,260 17,441 22,130 963,130 2% MACHINERY/EQUIPMENT 844 0% $ 3,645,198 $ 219,157 $ 309,139 $ 3,336,059 8% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 101,496 $ - $ 5,307 $ 96,189 5% BENEFITS 29,113 - 1,102 28,011 4% SUPPLIES 15,000 - - 15,000 0% SERVICES 513,500 - - 513,500 0% 659,109 - 6,409 652,700 1% PARKS & REC REATIO N SALARIES AND WAGES $ 2,627,863 $ 196,755 $ 180,459 $ 2,447,404 7% BENEFITS 865,945 69,911 69,475 796,470 8% SUPPLIES 166,640 5,942 8,563 158,077 5% SERVICES 1,421,287 35,675 60,725 1,360,562 4% $ 5,081,735 $ 308,283 $ 319,222 $ 4,762,513 6% PUBLIC WORKS ADMINISTRATION SALARIES AND WAGES $ 387,424 $ 24,948 $ 10,480 $ 376,944 3% BENEFITS 126,689 8,267 5,588 121,101 4% SUPPLIES 9,600 1 ill 9,489 1 % SERVICES 90,400 7,389 6,537 83,863 7% $ 614,113 $ 40,605 $ 22,716 $ 591,397 4% FACILITIFS MAINTENANCE SALARIES AND WAGES 860,456 71,668 69,854 790,602 8% BENEFITS 369,679 28,824 28,655 341,024 8% SUPPLIES 128,000 9,282 1,173 126,827 1% SERVICES 670,460 33,135 9,521 660,939 1% MACHINERY/EQUIPMENT 270,180 - - 270,180 0% $ 2,298,775 $ 142,909 $ 109,202 $ 2,189,573 5% ENGINEERING SALARIES AND WAGES $ 1,866,128 $ 144,772 $ 147,900 $ 1,718,228 8% BENEFITS 702,578 59,852 63,199 639,379 9% SUPPLIES 2,200 - - 2,200 0% SERVICES 274,430 13,692 15,729 258,701 6% $ 2,845,336 $ 218,316 $ 226,829 $ 2,618,507 8% TOTAL GENERAL FUND EXPENDITURES $ 49,246,551 $ 4,488,492 $ 4,601,625 $ 44,644,926 9% O d Q-' 2 c cC C LL 21 t C O 2 N N O N 7 C to 32 Packet Pg. 76 2.3.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 1 /31 /2022 1 /31 /2022 Q1 YTD Fund Balance Cash Balance 001-General Fund $ 10,615,608 $ 7,853,797 $ (2,310,606 009-Leoff-Medical Ins. Reserve 230,610 230,610 (24,608 0 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,422 16,421 - c 016-Building Maintenance 4,402,153 4,402,153 2,154 LL 017 - Marsh Restoration & Preservation 848,617 848,616 - >, Total General Fund & Subfunds $ 17,920,560 $ 15,158,748 $ - $ (2,333,059 a *$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. 2 N *$8,067,160 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012, represent the required N 20% operating reserve. There are no interfund loans outstanding at this time. R 1` 0 Q. GOVERNMENTAL FUNDS OVERVIEW U U_ 21 BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL c ---- ACTUAL ---- ---- ACTUAL ---- 0 FUNDS 1 /31 /2022 1 /31 /2022 Q1 YTD N N Fund Balance Cash Balance N General Fund & Subfunds $ 17,920,560 $ 15,158,748 $ (2,333,059 Special Revenue 17,375,406 17,426,772 c 272,106 Capital Projects 3,601,931 3,608,581 (767,141 m Total Governmental Funds $ 38,897,897 $ 36,194,101 $ - $ (2,828,094 t c� Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 33 Packet Pg. 77 2.3.a SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 1/31/2022 1/31/2022 Q1 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 76,351 $ 76,463 $ 350 1 1 1 - Street Fund 612,210 630,530 (195,469 0 112 - Combined Street Const/Im prove 1,325,369 1,358,306 16,680 Q- m 117 - Municipal Arts Acquis. Fund 721,308 721,309 65,026 120 - Hotel/Motel Tax Revenue Fund 62,849 62,849 4,591 2 121 - Employee Parking Permit Fund 83,992 83,992 6,544 a 122 -Youth Scholarship Fund 14,631 14,630 216 .9 123-Tourism Promotional Fund/Arts 95,218 95,219 2,803 U, 125 - Real Estate Tax2 4,095,298 4,095,297 94,238 126 - Real Estate Excise Tax 1 * 3,362,670 3,362,669 205,167 0 127 - Gifts Catalog Fund 333,100 333,099 28,568 2 130 - Cemetery Maintenance/Improvement 278,698 278,698 9,740 04 136 - Parks Trust Fund 171,223 171,222 785 N 137 - Cemetery Maintenance Trust Fund 1,126,666 1,126,665 7,454 138 - Sister City Commission 15,701 15,701 72 140 -Business Improvement Disrict 56,278 56,278 26,549 141 - Affordable and Supportive Housing Fd 159,414 159,414 7,392 .. 142 - Edmonds Rescue Plan Fund 4,763,683 4,763,683 (8,697 p 143 -Tree Fund 1 20,748 20,748 1 95 m Total Special Revenue $ 17,375,406 $ 17,426,772 1 $ - $ 272,106 *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $500,000 for •U the purchase of Open Space. c ii ENTERPRISE FUNDS OVERVIEW O 2 N N O N BALANCES CHANGE IN FUND BALANCES �+ c� ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- FUNDS 1/31/2022 1/31/2022 Q1 YTD Fund Balance Cash Balance m 421 -Water Utility Fund $ 27,568,746 $ 6,996,856 $ 549,886 z 422-Storm Utility Fund 14,181,961 5,725,704 165,938 423 - Sewer/WWTP Utility Fund 48,335,803 16,053,166 1,554,800 Q 424 - Bond Reserve Fund 843,962 843,962 1 411 -Combined Utility Operation 15,140 56,307 15,140 Total Enterprise Funds $ 90,945,612 $ 29,675,995 $ - $ 2,285,766 *$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. 78 2.3.a SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 1/31/2022 1/31/2022 Q1 YTD Fund Balance Cash Balance Governmental Funds $ 38,897,897 $ 36,194,101 $ (2,828,094 Enterprise Funds 90,945,612 29,675,995 2,285,766 0 0. Internal Services Fund 10,450,314 5,994,844 (86,738 0 Total City-wide Total $ 140,293,823 $ 71,864,940 $ - $ (629,066 E c c ii t .r c 0 INTERNAL SERVICE FUNDS OVERVIEW N N O N R 7 C R 7 BALANCES CHANGE IN FUND BALANCES o INTERNAL SERVICE ---- ACTUAL ---- ---- ACTUAL ---- 0. FUNDS 1/31/2022 1/31/2022 Q1 YTD Fund Balance Cash Balance 0 c 511 -Equipment Rental Fund $ 9,423,920 $ 5,047,607 $ 30,317 u_ 21 512 -Technology Rental Fund 1,026,394 947,237 (117,054 c 0 Total Internal Service Funds $ 10,450,314 $ 5,994,844 $ - $ (86,738 2 N N O N fC 3 C fC 7 C d E L V r Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 35 Packet Pg. 79 2.4 City Council Agenda Item Meeting Date: 03/8/2022 ARPA Funding Status Staff Lead: Doug Merriman, Interim CSED Director Department: Economic Development Preparer: Scott Passey Background/History Section 4 of Ordinance No. 4229, passed by the City Council on July 20, 2021, set out the provisions for utilizing the City's allocation of federal American Rescue Plan Act (ARPA) funding to mitigate the local impacts of the COVID-19 pandemic. These provisions divide the total funding of $11,893,099 into six accounts, A through F, to concentrate the expenditure of funds into specific areas of interest. City Council subsequently passed Ordinance. 4237, on November 1, 2021, to "clarifying the availability of the grant funds and increasing the parameters of grant recipient eligibility". During the latter part of 2021 and the first 2 months of 2022, programs within each Account designated in Ordinance No. 4229 have progressed through startup phases with funding being committed and expended per the terms of the ordinance. Staff Recommendation For informational purposes only - no recommendation at this time. Staff have been requested to provide current information as to the financial status of each ARPA account category. For the Committee's review, there are 3 graphs attached to this agenda item which reflect the originating City Council allocation, amounts committed, and funds actually expended, to date, by each category. Please note that any suggested changes to the existing funding allocations will require an amending ordinance. Narrative N/A Attachments: ARPA Funding Slides as of 3-4-2022 Packet Pg. 80 2.4.a 1 $80,788 A - City Expenditures - 6.3% $90,474 _ $7 B - Household Support - aiw 34.9% . $244,369 C - Business Support - 9.5% $56, D - Nonprofit Support - _ $420,5 4.2% $420,5 $500, M $199,999 E - Job Retraining - 5.0% $6( $6( F - Green Infrastructure - $0 40.1 % $0 $0 ■ Expenditures Total ARPA Funds - $11,893,099 $1,050,000 $1,125,000 $4,150, 000 $4 1,768,099 I I 1 1 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 Commitments Funds Allocated - Account r r a� c c LL Q a o: Q N N O N 17 M 0 U) CU U) a) W a� c c LL Q a Q c m E t r a Packet Pg. 81 2.4.a Housing Repair Support - 24.0 Utility Bill Support - 3.6% Household General Support - 72.4 B - Household Support Subcategories - $4,150,000 $3,000,000 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 ■ Expenditures Commitments ■ Funds Allocated w a Packet Pg. 82 2.4.a Small Business Support - 55.6 Tourism Support - 26.6% General Business Support - 17.8 $0 C - Business Support Subcategories - $1,125,000 ■ Expenditures $625,0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 Commitments ■ Funds Allocated w a Packet Pg. 83