Loading...
2022-12-12 City Council - Full FIN Agenda-33261. Op E D o Agenda Edmonds City Council tn.. ISLP FINANCE COMMITTEE - SPECIAL MEETING CITY COUNCIL CONFERENCE ROOM 121 - 5TH AVENUE N, EDMONDS, WA 98020 DECEMBER 12, 2022, 1:00 PM COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. PERSONS WISHING TO ATTEND THIS MEETING VIRTUALLY IN LIEU OF IN -PERSON ATTENDANCE CAN CLICK ON OR PASTE THE FOLLOWING ZOOM MEETING LINK INTO A WEB BROWSER USING A COMPUTER OR SMART PHONE: HTTPS://ZOOM. US/J/95798484261 OR JOIN BY DIAL -UP PHONE: US: +1 253 215 8782 WEBINAR ID: 957 9848 4261 STAFF AND COUNCILMEMBERS ATTEND COMMITTEE MEETINGS VIRTUALLY, AND MEMBERS OF THE PUBLIC ARE ENCOURAGED TO ATTEND THE SAME WAY. IF MEMBERS OF THE PUBLIC CANNOT ACCESS THIS VIRTUAL COMMITTEE MEETING WITH THEIR PERSONAL DEVICES, A MONITOR IS PROVIDED IN THE CITY COUNCIL CONFERENCE ROOM AT 121 5TH AVE N, EDMONDS WA. COMMITTEE MEMBERS: DIANE BUCKSHNIS (CHAIR), WILL CHEN, COUNCIL PRESIDENT (EX-OFFICIO MEMBER) CALL TO ORDER COMMITTEE BUSINESS 1. Microsoft Enterprise Agreement and License Contract Renewal (10 min) 2. 2022 December Budget Amendment (20 min) 3. September 2022 Monthly Financial Report (10 min) 4. October 2022 Monthly Financial Report (10 min) 5. Administrative 2023 Budget Items from Council (30 min) ADJOURNMENT: 2:30 PM Edmonds City Council Agenda December 12, 2022 Page 1 2.1 City Council Agenda Item Meeting Date: 12/12/2022 Microsoft Enterprise Agreement and License Contract Renewal Staff Lead: obo IT Manager Department: Administrative Services Preparer: Scott Passey Background/History N/A Staff Recommendation Discussion and approval of Microsoft Enterprise Agreement and License Contract on consent agenda. Narrative N/A Packet Pg. 2 2.2 City Council Agenda Item Meeting Date: 12/12/2022 2022 December Budget Amendment Staff Lead: Dave Turley Department: Administrative Services Preparer: Marissa Cain Background/History Amend the 2022 Ordinance No. 4275 Staff Recommendation Staff recommends that Finance Committee review the attached budget amendment ordinance and place on full council agenda for December 20. Attachments: 2022 December Budget Amendment Ordinance 2022 December Decision Package Exhibits Packet Pg. 3 2.2.a ORDINANCE NO. AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4275 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. 4275 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. 4 2.2.a 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. 5 2.2.a SUMMARY OF ORDINANCE NO. of the City of Edmonds, Washington On the th day of December, 2022, the City Council of the City of Edmonds, passed Ordinance No. XXXX. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4275 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. 6 2.2.a EXHIBIT "A": Budget Amendment Summary (December 2022) FUND NO. FUND DESCRIPTION 2022 BEGINNING FUND BALANCE REVENUE EXPENDITURES 2022 ENDING FUND BALANCE 001 GENERAL FUND 15,931,350 44,986,484 54,304,849 6,612,985 009 LEOFF-MEDICAL INS. RESERVE 255,218 225,000 260,490 219,728 011 RISK MANAGEMENT RESERVE FUND 25,000 - 25,000 - 012 CONTINGENCY RESERVE FUND 1,782,150 - 1,782,150 014 HISTORIC PRESERVATION GIFT FUND 16,421 - 5,900 10,521 016 BUILDING MAINTENANCE 4,400,001 119,645 545,000 3,974,646 017 MARSH RESTORATION & PRESERVATION FUND 848,616 - - 848,616 018 EDMONDS HOMELESSNESS RESPONSE FUND - 200,000 200,000 - 019 EDMONDS OPIOID RESPONSE FUND - - - - 104 DRUG ENFORCEMENT FUND 75,174 167,210 45,800 196,584 111 STREET FUND 951,166 1,751,930 2,315,780 387,316 112 COMBINED STREETCONST/IMPROVE 2,238,449 13,684,871 12,868,796 3,054,524 117 MUNICIPAL ARTS ACQUIS. FUND 648,879 216,701 195,380 670,200 120 HOTEL/MOTEL TAX REVENUE FUND 71,114 84,410 100,900 54,624 121 EMPLOYEE PARKING PERMIT FUND 76,524 26,540 26,880 76,184 122 YOUTH SCHOLARSHIP FUND 14,259 1,550 3,000 12,809 123 TOURISM PROMOTIONAL FUND/ARTS 95,972 29,590 28,200 97,362 125 PARK ACCl/IMPROVEMENT 4,053,415 2,271,020 4,589,688 1,734,747 126 SPECIAL CAPITAL FUND 3,313,338 2,261,030 2,483,667 3,090,701 127 G I FTS CATALOG FU N D 301,524 82,750 138,400 245,874 130 C EMETERY MAI NTENANCE/I MP ROV 266,205 182,430 220,561 228,074 136 PARKSTRUSTFUND 168,589 4,330 50,000 122,919 137 CEMETERY MAINTENANCETRUST FD 1,107,074 43,520 25,000 1,125,594 138 SISTER CITY COMMISSION 15,481 10,290 11,900 13,871 140 BUSINESS IMPROVEMENT DISTRICT FUND 29,132 79,349 87,680 20,801 141 AFFORDABLE & SUPPORTIVE HOUSING FUND 159,414 65,000 - 224,414 142 EDMONDS RESCUE PLAN FUND 4,772,380 3,895,663 5,116,606 3,551,437 143 TREE FUND 20,632 215,330 214,800 21,162 211 LID FUND CONTROL - - - - 231 2012 LTGO DEBTSERVICE FUND - 611,370 611,370 - 332 PARKS CONSTRUCTION 4,113,862 4,272,685 8,064,418 322,129 421 WATER 28,727,168 11,018,136 11,495,988 28,249,316 422 STORM 15,647,377 7,877,897 9,633,496 13,891,778 423 SEWER/TREATMENT PLANT 60,352,529 26,095,636 31,353,823 55,094,342 424 BOND RESERVE FUND 843,961 1,988,700 1,988,710 843,951 511 EQUIPMENT RENTAL FUND 9,208,511 2,090,920 2,230,371 9,069,060 512 Technology Rental Fund 1,079,041 1,553,180 1,992,312 639,909 Totals 161,609,926 126,113,167 151,234,765 136,488,328 C N E C N E a N 7 m L d E N v d N N O N L N E N v N N N O N r C d E t v R r r Q Packet Pg. 7 2.2.a EXHIBIT "B": Budget Amendments by Revenue (December 2022) FUND NO. FUND DESCRIPTION Adopted Budget Ord.#4240 1/1/2022 Adopted Amendment Ord.#4249 3/1/2022 Adopted Amendment Ord.#4250 3/15/2022 Adopted Amendment Ord.#4257 4/26/2022 Adopted Amendment Ord.#4275 9/20/2022 Proposed Amendment Ord.# 2022 Amended Revenue Budget 001 General Fund $ 44,204,863 $ (35,000) $ 470,845 $ $ 345,776 $ $ 44,986,484 009 Leoff-Medical Ins. Reserve 225,000 - - 225,000 011 Risk Management Reserve Fund - - 012 Contingency Reserve Fund 014 Historic Preservation Gift Fund - 016 Building Maintenance Fund 119,645 119,645 017 Marsh Restoration & Preservation Fund - - 018 Edmonds Homelessness Response Fund 200,000 200,000 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 167,210 167,210 111 Street Fund 1,751,930 - 1,751,930 112 Combined StreetConst/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 Fd 43,520 43,520 138 Sister City Commission 10,290 10,290 140 Business Improvement District Fund 79,349 79,349 141 Affordable a nd Supportive Housing Fund 65,000 65,000 142 Edmonds Rescue Plan Fund 4,856,549 (960,886) 3,895,663 143 Tree Fund 215,330 215,330 211 Lid Fund Control - - 231 2012 LTGO Debt Service fund 611,370 - 611,370 332 Parks Construction 3,822,685 450,000 4,272,685 421 Water 11,018,136 - 11,018,136 422 Storm 8,277,897 (400,000) - - 7,877,897 423 Sewer/Treatment Plant 16,001,340 8,818,743 1,275,553 26,095,636 424 Bond Reserve Fund 1,988,700 - - 1,988,700 511 Equipment Rental Fund 1,925,920 - 165,000 2,090,920 512 Technology Renta I Fund 1,153,570 399,610 - 1,553,180 617 Firemen's Pension Fund - - - - - Totals $ 114,938,031 1 $ (235,000)1 $ 9,615,438 1 $ 119,645 1 $ 1,510,053 $ 165,000 $ 126,113,167 C N E C N E Q r i� 7 m L d E N V d C N N O N t1 C M C 7 L 0 E C E C N E a d 7 m N E t� N C N N O N r C d E t t,1 M ++ a Packet Pg. 8 2.2.a EXHIBIT "C": Budget Amendment by Expenditure (December 2022) FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4240 1/1/2022 Adopted Amendment Ord. #4249 3/1/2022 Adopted Amendment Ord. #4250 3/15/2022 Adopted Amendment Ord. #4257 4/26/2022 Adopted Amendment Ord. #4275 Proposed Amendment Ord. # 2022 Amended Expenditure Budget 001 General Fund $ 49,246,551 $ (1,677) $ 126,661 $ 2,989,337 $ 558,717 $ 1,385,260 $ 54,304,849 009 Leoff-Medical Ins. Reserve 260,490 - - - 260,490 011 Risk Management Reserve Fund - 25,000 25,000 012 Contingency Reserve Fund - - - 014 Historic Preservation Gift Fund 5,900 5,900 016 Building Maintenance Fund 980,000 (435,000) 545,000 017 Marsh Restoration & Preservation Fund - - - 018 Edmonds Homelessness Response Fund 200,000 200,000 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 45,800 - 45,800 111 Street Fund 2,254,676 61,104 2,315,780 112 Combined StreetConst/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 - 60,000 138,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 100,000 (960,886) 5,116,606 143 Tree Fund 214,800 - - 214,800 211 Lid Fund Control - - 231 2012LTGO Debt Service Fund 611,370 - - 611,370 332 Parks Construction 7,321,018 293,400 - 450,000 8,064,418 421 Water 11,110,498 365,396 15,094 1,150 3,850 11,495,988 422 Storm 8,638,202 (400,000) 1,443,238 (61,791) 697 13,150 9,633,496 423 Sewer/Treatment Plant 15,656,812 13,855,689 17,355 1,810,667 13,300 31,353,823 424 Bond Reserve Fund 1,988,710 - - - - 1,988,710 511 Equipment Rental Fund 1,942,460 - 7,911 115,000 165,000 2,230,371 512 Technology Rental Fund 1,447,422 91,600 - 390,300 62,990 1,992,312 617 Firemen's Pension Fund - - - - - - Totals $122,484,205 1 $ (201,677)1 $ 22,164,032 1 $ 2,694,010 1 $ 2,390,645 1 $ 1,703,550 1 $ 151,234,765 C N E C N E a r� N 7 m L E N V d N N O N d V C M C 'r3 O C N E C N E Q N Im 3 m L E N V N 0 N N O N r C d E t v R r r Q Packet Pg. 9 EXHIBIT "D": Budget Amendment Summary (December 2022) 2.2.a Fund Number Proposed Amendment Change in Revenue Proposed Amendment Change in Expense Proposed Amendment Change in Ending Fund Balance 001 1,385,260 (1,385,260) 011 - 142 332 - 421 3,850 (3,850) 422 13,150 (13,150) 423 - 13,300 (13,300) 511 165,000 165,000 512 - 62,990 (62,990) Total Change 165,000 1 1,703,550 1 (1,538,550) C N E C N E a N i� 7 m d E N v d N N O N a+ Q Packet Pg. 10 2.2.b Budget Amendment for: December 12, 2022 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The AFSCME Collective Bargaining Agreement was approved by council on November 22, 2022. This agreement rovers the contract period of 1/1/2022-12/31/2024. This decision package is included to add budget authority for the ncreased salaries for the last three payroll cycles of the year. Services Retro Previously Discussed By Council Nov 22 2022 100% Ending Fund Balance One -Time Operating Fund MULTIPLE FUNDS Name Account Number Description 2022 2023 2024 2025 2026 001.000.23.512.51.11.00 Salaries $ 80,000.00 $ $ $ S 001.000.23.512.51.23.00 Benefits $ 16,000.00 001.000.23.523.30.11.00 Salaries $ 10,000.00 001.000.23.523.30.23.00 Benefits $ 2,000.00 001.000.31.514.23.11.00 Salaries $ 20,000.00 001.000.31.514.23.23.00 Benefits $ 4,000.00 001.000.31.514.31.11.00 Salaries $ 10,000.00 001.000.31.514.31.23.00 Benefits $ 2,000.00 001.000.61.557.20.11.00 Salaries $ 10,000.00 001.000.61.557.20.23.00 Benefits $ 2,000.00 001.000.61.573.90.11.00 Salaries $ 2,000.00 001.000.61.573.90.23.00 Benefits $ 400.00 001.000.62.524.10.11.00 Salaries $ 4,000.00 001.000.62.524.10.23.00 Benefits $ 800.00 001.000.62.524.20.11.00 Salaries $ 11,000.00 001.000.62.524.20.23.00 Benefits $ 2,200.00 001.000.62.558.60.11.00 Salaries $ 2,000.00 001.000.62.558.60.23.00 Benefits $ 400.00 001.000.64.571.22.11.00 Salaries $ 20,000.00 001.000.64.571.22.23.00 Benefits $ 4,000.00 001.000.65.518.20.11.00 Salaries $ 5,000.00 001.000.65.518.20.23.00 Benefits $ 1,000.00 001.000.67.518.21.11.00 Salaries $ 14,000.00 001.000.67.518.21.23.00 Benefits $ 2,800.00 422.000.72.531.90.11.00 Salaries $ 2,000.00 422.000.72.531.90.23.00 Benefits $ 400.00 423.000.76.535.80.11.00 Salaries $ 2,000.00 423.000.76.535.80.23.00 Benefits $ 400.00 512.000.31.518.88.11.00 Salaries $ 10,000.00 512.000.31.518.88.23.00 Benefits $ 2,000.00 Total Expenditure Increase (Decrease) $ 242,400 $ $ $ S Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 $ $ $ $ S Total Revenue Increase (Decrease) $ $ $ $ S Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ (225,600) $ $ $ S 422.000.72.508.00.00.00 Ending Fund Balance (2,400) 423.000.75.508.00.00.00 Ending Fund Balance (2,400) 512.000.31.508.00.00.00 Ending Fund Balance (12,000) Total Ending Fund Balance Increase (Decrease) 1 $ (242,400) $ I I $ I S Packet Pg. 11 2.2.b Budget Amendment for: December 12, 2022 Item Description: The AFSCME Collective Bargaining Agreement was approved by council on November 22, 2022. This agreement covers the contract period of 1/l/2022-12/31/2024. This decision package is included to add budget authority for the �retro payment that was processed on 11/30/2022. Iund MULTIPLE FUNDS Name Budget Amendment Type Previously Discussed By Council Date of Discussion or Budget Approval? INov 22 2022 How is this amendment funded? 1 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.23.512.51.11.00 Salaries $ 49,540 $ - $ - $ - $ 001.000.23.512.51.23.00 Benefits 9,150 001.000.23.523.30.11.00 Salaries 43,710 001.000.23.523.30.23.00 Benefits 7,990 001.000.31.514.23.11.00 Salaries 122,770 001.000.31.514.23.23.00 Benefits 22,640 001.000.31.514.31.11.00 Salaries 7,980 001.000.31.514.31.23.00 Benefits 1,480 001.000.60.557.20.11.00 Salaries 4,930 001,000.60.557.20.23.00 Benefits 910 001,000.61.557.20.11.00 Salaries 19,150 001,000.61.557.20.23.00 Benefits 3,540 001,000.61.573.90.11.00 Salaries 12,780 001.000.61.573.90.23.00 Benefits 2,360 001.000.62.524. 10.11.00 Salaries 30,220 001.000.62.524.10.23.00 Benefits 5,540 001.000.62.524.20.11.00 Salaries 83,290 001.000.62.524.20.23.00 Benefits 15,380 001.000.62.558.60.11.00 Salaries 9,530 001.000.62.558.60.23.00 Benefits 1,760 001.000.63.557.20.11.00 Salaries 6,670 001.000.63.557.20.23.00 Benefits 1,230 001.000.64.571.21.11.00 Salaries 25,500 001.000.64.571.21.23.00 Benefits 4,710 001.000.64.571.22.11.00 Salaries 45,200 001,000.64.571.22.23.00 Benefits 8,350 001,000.64.571.23.11.00 Salaries 4,660 001,000.64.571.23.23.00 Benefits 860 001,000.64.571.26.11.00 Salaries 6,100 001,000.64.571.26.23.00 Benefits 1,130 001,000.64.571.28.11.00 Salaries 4,010 001,000.64.571.28.23.00 Benefits 750 001,000.64.571.29.11.00 Salaries 13,160 001.000.64.571.29.23.00 Benefits 2,430 001.000.65.518.20.11.00 Salaries 27,240 001.000.65.518.20.23.00 Benefits 5,030 001.000.67.518.21.11.00 Salaries 97,320 001.000.67.518.21.23.00 Benefits 18,030 421.000.74.534.80.11.00 Salaries 3,250 421.000.74.534.80.23.00 Benefits 600 422.000.72.531.90.11.00 Salaries 6,040 422.000.72.531.90.23.00 Benefits 1,110 423.000.76.535.80.11.00 Salaries 9,200 423.000.76.535.80.23.00 Benefits 1,700 512.000.31.518.88.11.00 Salaries 30,900 512.000.31.518.88.23.00 Benefits 5,690 Total Expenditure Increase Decrease $ 785,520 $ - $ - $ - $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase Decrease $ - $ - $ - $ - $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ (727,030) $ - $ - $ - $ 421.000.65.508,00.00.00 Ending Fund Balance (3,850) 422.000.72.508,00.00.00 Ending Fund Balance 7150 423.000.75.508,00.00.00 Ending Fund Balance (10,900) 512.000.31.508.00.00.00 Ending Fund Balance (36,590) Total Ending Fund Balance Increase Decrease $ 785 520 $ I $ -I $ -I $ Packet Pg. 12 2.2.b Budget Amendment for: December 12, 2022 Description: Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) The AFSCME Collective Bargaining Agreement was approved by council on November 22, 2022. This agreement covers the contract period of 1/1/2022-12/31/2024. This decision package is included to add budget authority for the step -increase for eligible employees to be processed by 12/31/2022. Administrative Services Finance AFSCME Retro Payme Dave Turlev Previously Discussed By Council Nov 22 2022 100%Ending Fund Balance One -Time Operating Fund MULTIPLE FUNDS Name: Account Number Description 2022 2023 2024 2025 2026 001.000.23.523.30.11.00 Salaries 16,000 001.000.23.523.30.23.00 Benefits 3,200 001.000.31.514.23.11.00 Salaries 88,000 001.000.31.514.23.23.00 Benefits 17,600 001.000.62.524.10.11.00 Salaries 10,000 001.000.62.524.10.23.00 Benefits 2,000 001.000.67.518.21.11.00 Salaries 4,000 001.000.67.518.21.23.00 Benefits 800 422.000.72.531.90.11.00 Salaries 3,000 422.000.72.531.90.23.00 Benefits 600 512.000.31.518.88.11.00 Salaries 12,000 512.000.31.518.88.23.00 Benefits 2,400 Total Expenditure Increase Decrease $ 159,605 $ S $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase Decrease S $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ 141,600 $ $ $ $ 422.000.72.508.00.00.00 Ending Fund Balance 3,600 512.000.31.508.00.00.00 Ending Fund Balance 14,400 Total Ending Fund Balance Increase Decrease $ 159,600 $ S S $ C d E C d E a d 73 7 m L d M E d t� N G N N O N Packet Pg. 13 2.2.b Budget Amendment for: December 12, 2022 Description: The MOUs for the EPOA Commissioned and Law Support Collective Bargaining unit were approved by council on November 22, 2022. These MOUs included a retro payment of 2.5% of base salaries for the period 7/1/22-11/30/22, as well as a 2.5% increase of base salaries for the period 12/1/2022-12/31/2022 to be paid in the current year. This decision package adds the additional salary and benefit costs to the budget. Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) Administrative Services Finance AFSCME Retro Payme Dave Turlev Previously Discussed By Council Nov 22 2022 100%Ending Fund Balance One -Time Operating Fund MULTIPLE FUNDS Name: Account Number Description 2022 2023 2024 2025 2026 001.000.41.521.22.11.00 Salaries 80,000 001.000.41.521.22.23.00 Benefits 32,000 Total Expenditure Increase(Decrease) $ 112,000 $ S $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase Decrease $ S S $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ 112,000) $ $ $ $ Total Ending Fund Balance Increase Decrease $ 112,000 $ S $ $ C d E C d E a d 7 m L d M E d t� N G N N O N Packet Pg. 14 2.2.b Budget Amendment for: December 12, 2022 Description: The Clerk's Office proposes to upgrade the City's online code presence by migrating from the existing legacy platform provided by Code Publishing to a modern platform offered by the same vendor. This will make the City and Community Development Codes easier to access and provide additional features the legacy platform does not support. For example, the new platform will allow users to track historical versions of code in one click rather than having to sort through ordinance numbers and pulling each of those up separately in another platform. Also, definitions (primarily for zoning) will be linked to words in the code and when moused over, the definition of the word will immediately pop up and be visible to the reader. The modern platform also provides additional ADA features. 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) City Clerk's Office Administrative Services Online Code Migration & Enhancement Scott Passev New Item For Council To Consider 4th Quarter Budget Amendment 100% Ending Fund Balance On -Going Operating Fund 001 GENERAL Name: Fill out on going costs & revenues Account Number Description 2022 2023 2024 2025 2026 001.000.25.514.30.41.00 Professional Services one-time $ 12,460 $ - $ - $ - $ - 001.000.25.514.30.41.00 Professional Services (on -going) 1,570 1,570 1,570 1,570 1,570 Total Expenditure Increase(Decrease) $ 14,030 $ 1,570 $ 1,570 $ 1,576 Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase Decrease $ $ $ $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 $ 14,030) $ 1,570 $ 1,570 $ 1,570 $ 1,570 Total Ending Fund Balance Increase Decrease $ 14,030) $ 1,570 $ 1,570 $ 1,570 $ 1,570 C d E C d E a r+ d 7 m L d M E d t) N G N N O N Packet Pg. 15 2.2.b Budget Amendment for: December 12, 2022 Description: Fund 127 is the Gift Catalog and represents purchases that are made after receiving donations. Purchases are not made without first receiving in the revenue to cover expenses. In 2022 there were a significant number of donations such as the Goffette Estate donation and an increase in donations for picnic tables and park benches. This amendment increases the expenditure authority of staff to meet the demand. This does not impact the general fund and all expenses are offset by revenues that have been received and are in the fund's balance. Recreation & Human Services Division: I Recreation Title: Fund 127 Expenditure Authority Increase Preparer: Shannon Burley Budget Amendment Type Date of Discussion or Budget Approval? How is this amendment funded? What is the nature of the expenditure? Is the Expenditure Operating or Capital? Expenditure Increase (Decrease) New Item For Council To Consider 4th Quarter Budget Amendment 100% Ending Fund Balance One -Time Operating Fund I 127 GIFTS CATALOG Name: L Account Number Description 2022 2023 2024 2025 2026 127.300.64.576.81.31.00 Supplies $ 6,818 $ $ $ $ 127.000.64.575.50.31.00 Supplies 53,182 Total Expenditure Increase(Decrease) $ 60,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 Total Revenue Increase Decrease S $ S $ S Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 127.300.64.508.30.00.00 Ending Fund Balance $ 6,818 $ $ $ S 127.000.64.508.30.00.00 Ending Fund Balance 53,182 Total Ending Fund Balance Increase Decrease S 60,000 $ S $ - $ Packet Pg. 16 2.2.b Budget Amendment for: December 12, 2022 Description: This budget amendment will purchase a new Ford F-550 4-wheel drive, 3-yard dump truck with snow plow and sander configuration. The new 4-wheel drive truck will improve snow/ice treatments on city streets with steeper slopes that are often the last to receive snow removal due to safety concerns. The truck will also be used by the Street Division throughout the year to complete its annual work program. 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 Street Division Ford F-550 4WD Dump Truck/Snow Plow Oscar Antillon New Item For Council To Consider 4th Quarter Budget Amendment 100% Ending Fund Balance One -Time Capital Fund 511 EQUIPMENT RENTAL Name: Account Number Description 2022 2023 2024 2025 2026 001.000.39.597.48.55.11 Transfer to Fund 511 $ 165,000 $ $ $ $ 511.100.77.594.48.64.00 Equipment - B Fund 165,000 Total Expenditure Increase Decrease $ 330,005 $ S $ $ Revenue Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 511.100.397.48.001.00 Transfer in from 001 165,000 $ $ $ Ls' Total Revenue Increase Decrease $ 165,000 $ S S Ending Fund Balance Increase (Decrease) Account Number Description 2022 2023 2024 2025 2026 001.000.39.508.00.00.00 Ending Fund Balance $ 165,000 $ $ $ $ Total Ending Fund Balance Increase Decrease $ 165,000 $ I S I S I$ C d E C d E a r+ d 7 lb L d M E d t� N G N N O N Packet Pg. 17 2.3 City Council Agenda Item Meeting Date: 12/12/2022 September 2022 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Move to full council to be received for filing. Narrative September 2022 Monthly Financial Report Attachments: Jan -Sept 2022 P&L Complete September 2022 Monthly Financial Report Packet Pg. 18 2.3.a GENERAL FUND CHANGES IN FUND BALANCE 2021 2022 2017 2018 2019 2020 2021 (Jan -Sept) (Jan -Sept) Beginning Fund Balance 9,841,719 10,273,342 11,233,279 15,552,188 13,868,744 13,868,744 15,915,322 Revenue Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Investment earnings Miscellaneous Operating Revenues Nononeratine Revenues Transfers in Debt proceeds Sale of capital assets Insurance recoveries Total Revenue Expenditures General government Public safety Transportation Economic environment Mental and physical health Culture and recreation Debt service Capital outlay Operating Expenditures Nononeratine Expenditures Transfers out Debt refunding Total Expenditures Prior Period Adjustments Change in position 29,572,203 30,755,578 30,846,665 30,738,452 32,979,704 21,665,911 22,538,625 2,506,800 2,401,855 2,299,972 2,276,861 2,453,186 1,785,653 1,940,066 890,572 1,014,434 1,008,432 1,633,633 1,608,646 1,309,318 1,050,462 5,463,913 5,810,961 6,419,836 5,412,044 5,913,557 4,613,516 4,384,598 459,929 616,783 496,093 287,693 272,302 239,018 116,322 154,737 273,228 573,806 265,627 122,257 252,014 191,717 471,675 931,495 587,882 322,816 347,519 256,069 310,943 39,519,829 41,804,334 42,232,686 40,937,126 43,697,171 30,121,500 30,532,733 26,300 75,884 4,793,650 1,535,800 388,547 165,176 13,150 7,143 5,273 - - - 15,570 - 16,977 - - - 39,553,272 41,901,061 47,026,336 42,489,903 44,085,718 30,286,676 30,545,883 9,714,867 10,288,694 11,565,563 12,514,526 11,866,885 8,978,567 9,304,352 22,228,871 22,585,212 23,036,185 23,759,212 22,765,260 17,365,984 19,476,923 3,600 4,779 5,012 5,012 2,088 1,671 - 1,551,152 1,460,763 1,562,702 1,675,334 1,991,624 1,353,579 1,573,686 126,791 178,859 164,888 147,957 84,642 34,808 34,724 3,959,731 4,331,806 4,158,397 3,732,644 4,341,658 3,302,370 3,519,496 198,361 197,694 197,967 296,624 60,228 60,087 72,505 90,573 93,105 110,935 835,048 268,885 - 155,426 37,873,946 39,140,912 40,801,649 42,966,358 41,381,270 31,097,067 34,137,113 1,247,703 1,800,212 1,905,778 1,206,990 657,870 234,945 542,500 39,121,649 40,941,124 42,707,427 44,173,348 42,039,140 31,332,011 34,679,613 431,623 959,937 4,318,909 (1,683,445) 2,046,578 (1,045,335) (4,133,730) Ending Fund Balance 10,273,342 11,233,279 15,552,188 13,868,744 15,915,322 12,823,409 11,781,593 O Q. O .v c cc c ii t c O 2 N N O N L d E d O. am co J 08 a. N N O N r+ N C C d t V Q R:\Finance Committee\2022\Jan-Sept 2022 P&L 12/7/2022 Packet Pg. 19 2.3.b INSIDE THIS ISSUE: Revenues By Fund Summary Expenditures By Fund Summary General Fund Revenues Expenditures By Fund Detail 4 Gen. Fund Depart- ment Expenditures Investment Portfoli, Fund Balance Overview Right. The Council wel- comed two new appointees to the dais. Welcome, Dave Teitzel and Jenna Nand to Edmonds City Council! Summary Revenues 1 This report is a summary of the City's preliminary operating results for the nine months ended September 30,2022. Revenue Update: The economy has been up and down this year. The unemployment rate for September was at 3.50%, an im- provement over the 3.70% of the pre- vious month. Both of these numbers reflect historic lows. Rates on US Treasuries are inching upwards, with a 4.18% return on a one-year invest- ment at the end of the quarter. How- ever, this is offset by high interest rates, with a Seattle region CPI of General Fund revenues through the 3rd quarter of $30.5 million are $866,900 or 2.9% ahead of budget. The largest contributor to this is from sales tax collections that are $820,620 ahead of this time last year, and $1,006,666 ahead of budget. Due to a currently strong local and region- al economy, virtually all tax collections are ahead of last year's pace, as well as ahead of budget. ; (page 21.) hL Revenues by Category: General Fund revenues for the nine months end- ed September 30, 2022 are higher than 2021 in all categories except for Intergovernmental, Charges for Goods and Services, Fines and Pen - alties, and Miscellaneous. General Fund revenues to date exceed revenues for the same period last year by $259,207, or 1%. The General Fund currently has a fund balance of $11,781,589. $8,067,160 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012 represent the required 20% minimum Fund Balance reserve. This leaves the General Fund with an additional $3,714,429 in Unrestricted Fund Balance. A more detailed breakdown of infor- mation for City revenues can be found be- ginning on page 19. The City currently has no interf ind loans outstanding. VM1110n 4F1 1 Preliminary Financial Management Report as of September Packet Pg. 20 2.3.b or"' , , , , , , , , "N Summary of Operating Funds: Expenditures General Fund expendi- tures for the first three quarters of the year are Top: $3,347,601 more than this Budget season is in time last year, which is full swing, with Mayor Nelson deliv- still 9.98% under the ering the City's Pro- budgeted amount. posed Budget to Council on October General Fund expenses 3, 2022. by sub -fund and line item ri a ■ Right: The City hosted Porch Fest, a free music festival / block party support- ing local artists and connecting neigh- bors. Porch Fest was so much fun, it may become an annual event! categories are on page 24 and expenses by depart- ment are on pages 31-32. IEvery department in the General Fund is reasona- bly where expected after nine months, and the General Fund as a whole, while 75% of the way through the year, has spent 66% of its annual budget. This same infor- mation can be found in graphical form on pages 8 -16. ISpecial Revenue Funds during the year have spent only 26% of their annual ex- pense budget. This is expected, as much of the underspending comes from REET funds, which at 75% of the way through the year have spent only 33% of their annual allotment. In addition, the City has an expense budget of Rescue Plan Act (ARPA) Fund 142, of which only $620,470 has been spent so far. Addi- tional Special k Revenue Fund expenditure information can be found on pages 25-26. The total fund balance for the General Fund and Sub -funds at September 30 is $19.2 million, or approximately 36% of the annual expenditure budget for those 0 a as o: c 21 c 0 a N N 0 N N E a� a� *#ft. ow, Preliminary Financial Management Report as of September Packet Pg. 21 I 2.3.b I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of September 30, 2022 Years r Agency/ Investment Purchase to Par Market Maturity Coupon Q Issuer Type Rice Maturity Value Value Date Rate N Mason & Kitsap Cnty WA Bonds 948,084 0.17 855,000 857,625 12/01/22 5.00% .0 Grant Cnty WA Bonds 1,517,955 0.25 1,500,000 1,492,110 01/01/23 1.54% Grant Cnty WA Bonds 576,332 0.25 520,000 522,470 01/01/23 5.00% LL Seattle WA Muni Bonds 2,224,500 0.34 2,000,000 2,012,440 02/01/23 5.00% >, FHLMC Bonds 988,678 0.55 1,000,000 980,541 04/20/23 0.38% :E C FHLB Bonds 1,996,590 1.01 2,000,000 1,915,114 10/05/23 0.22% O M First Financial - ECA CD 2,803,516 1.13 2,803,516 2,803,516 11/15/23 2.08% N Kent WA Bonds 286,648 1.17 250,000 255,258 12/01/23 5.00% G FHLB Bonds 954,866 1.53 1,000,000 942,297 04/10/24 0.35% N FM Bonds 996,082 1.72 1,000,000 975,446 06/17/24 2.80% FNMA Bonds 992,693 1.76 1,000,000 958,091 07/02/24 1.75% d FHLB Bonds 950,774 2.14 1,000,000 929,615 11/18/24 0.90% Q. N Spokane County WA Bonds 207,260 2.17 200,000 190,792 12/01/24 2.10% N First Financial - Waterfront Center CD 1,575,000 5.09 1,575,000 1,575,000 11/01/27 0.20% TOTAL SECURITIES 17,018,977 1.38 16,703,516 16,410,314 00 Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO Seattle WA Issuer Diversification Muni, 12% Kent WA, 1% First Financial- Mason & � CD, 26% Kitsap Cnty WA, 5% Gra nt Cnty o Spokane WA 12% FHLB, 12/ County WA, 1% FNMA, 6% ---=L---FHLMC, 6% 23,197,695 23,197,695 Demand 2.56% 42,940,177 42,940,177 Demand 1.59% $ 82,841,389 $ 82,548,187 Cash and Investment Balances Checking, (in $ Millions) —$3.3 , 4% Bonds, CD's, $4.4, $12.3, 5% 14% State LGIP, $23.2, 27% County LGIP, $42.9 , 50% 1 Packet Pg. 22 1 I 2.3.b I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,236,875 $1,200, 000 $1,000,000 S947,931 $950,684 $882 556 $762,512 $800,000 $635,781 $600,000 $400,000 $200,000 $- 2017 M m 2019 2020 2021 YTD 2022 2 Packet Pg. 23 GENERAL FUND SUMMARY I 2.3.b I General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenue General Fund Expenses 10,000, 000 9,000,000 8,000,000 7,000, 000 6,000, 000 5,000,000 4,000,000 3,000,000 . 2,000, 000 1,000, 000 October January April July October January April July 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 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 General Fund Tax Revenue (2022 YTD) Sales Tax Property Tax $2,328,792 6 062 651 EMS Tax Other Taxes 0 a� .v c R c ii z C 0 a N N 0 N L E 0 ++ Q Cn 3 Packet Pg. 24 I 2.3.b I City of Edmonds, WA Monthly Revenue Summary -General Fund 2022 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,504,390 $ 2,504,390 $ 2,186,816 -12.68% February 4,952,844 2,448,454 4,606,889 -6.98% March 7,433,841 2,480,997 7,290,787 -1.92% April 10,592,238 3,158,396 10,347,043 -2.31% May 19,497,731 8,905,494 19,290,212 -1.06% June 22,094,674 2,596,943 21,853,448 -1.09% July 24,642,914 2,548,239 24,106,033 -2.18% August 27,281,283 2,638,369 27,906,485 2.29% September 29,678,983 2,397,701 30,545,883 2.92% October 33,756,809 4,077,826 November 42,396,838 8,640,029 December 44,986,484 2,589,646 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2022 Real Estate Excise Tax 1 & 2 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 376,007 $ 376,007 $ 135,500 -63.96% February 604,057 228,050 377,997 -37.42% March 942,203 338,145 551,531 -41.46% April 1,215,412 273,209 923,535 -24.01% May 1,570,915 355,503 1,301,746 -17.13% June 1,942,927 372,012 1,703,080 -12.34% July 2,344,831 401,904 2,043,169 -12.86% August 2,781,982 437,151 2,333,624 -16.12% September 3,225,577 443,595 2,664,145 -17.41% October 3,626,122 400,545 November 4,018,664 392,542 December 4,400,000 381,336 *The monthly budget forecast columns are based on a five-year average. O Q N C R C M 21 t y+ a O 2 N N O N L E d -W Q w Packet Pg. 25 1 SALES TAX SUMMARY I 2.3.b I Construction Trade, $1,260,784 Accommodation, $36,902 Clothing and Accessories, $285,060 Communications, $181,333 Wholesale Trade, — $264,874 Sales Tax Analysis By Category Current Period: September 2022 Year -to -Date Total $8,300,315 Automotive Repair, Aniusernent & $176,320 Recreation, $56,553 Health & Personal Care, $53,646 Business Services, Gasoline, $60 $878,891 12,000, 000 10,000, 000 8,000,000 6,905,122 $7,395,114 6,000,000 4,000,000 2,000,000 0 2016 2017 Misc Retail, $1,574,843 4-11 Others, $218,750 Retail Food Stores, $265,919 Retail Automotive, $2,037,799 Manufacturing, $93,717 Eating & Drinking, $914,864 Annual Sales Tax Revenue l $10,302,518 $8,406,296 $8,452,715 $8,317,046 ►L•I1�: 2020 $8,300,315 2021 YTD 2022 5 I Packet Pg. 26 I 2.3.b I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2022 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 763,651 $ 763,651 $ 857,872 12.34% February 1,704,609 940,958 1,853,000 8.71% March 2,420,254 715,646 2,666,259 10.16% April 3,074,639 654,384 3,469,412 12.84% May 3,893,081 818,442 4,483,349 15.16% June 4,672,507 779,426 5,402,133 15.62% July 5,523,403 850,896 6,337,518 14.74% August 6,439,084 915,680 7,348,080 14.12% September 7,293,649 854,565 8,300,315 13.80% October 8,203,996 910,347 November 9,139,425 935,429 December 10,000,000 860,575 O 0. N C R C LL 21 t y+ C O 2 N N O N L E d SZ City of Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2022 Gas Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 79,399 $ 79,399 $ 96,596 21.66% February 164,205 84,806 96,596 -41.17% March 246,125 81,920 305,138 23.98% April 313,860 67,734 397,808 26.75% May 367,416 53,556 469,966 27.91% June 402,173 34,757 524,767 30.48% July 429,975 27,802 563,428 31.04% August 452,332 22,357 590,667 30.58% September 472,668 20,335 615,300 30.18% 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. 6 Packet Pg. 27 I 2.3.b I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2022 Telephone Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 53,352 $ 53,352 $ 43,844 -17.82% February 96,981 43,629 66,255 -31.68% March 143,255 46,275 130,244 -9.08% April 192,397 49,142 175,045 -9.02% May 232,481 40,084 208,020 -10.52% June 277,770 45,288 250,253 -9.91% July 321,046 43,277 293,198 -8.67% August 362,710 41,663 308,018 -15.08% September 400,099 37,389 333,419 -16.67% October 445,363 45,264 November 482,039 36,676 December 523,000 40,961 Electric Utility Tax Telephone Utility Tax 600,000 500,000 400,000 300,000 P. 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 Budget Forecast Budget Forecast YTD Actuals Variance % January $ 148,905 $ 148,905 $ 183,023 22.91% February 312,488 163,583 377,116 20.68% March 449,608 137,121 534,798 18.95% April 602,286 152,678 726,969 20.70% May 723,393 121,107 858,720 18.71% June 824,492 101,099 993,628 20.51% July 920,639 96,147 1,117,008 21.33% August 1,015,921 95,282 1,224,526 20.53% September 1,108,535 92,614 1,349,573 21.74% October 1,199,070 90,535 November 1,299,972 100,902 December 1,410,000 110,028 *The monthly budget forecast columns are based on a five-year average. O Q N C R C LL t C O 2 N N O N L E d SZ 7 Packet Pg. 28 I 2.3.b I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2022 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 809,979 $ 809,979 $ 827,704 2.19% February 1,383,405 573,426 1,383,308 -0.01% March 2,213,219 829,814 2,127,271 -3.88% April 2,744,029 530,810 2,688,719 -2.02% May 3,542,697 798,668 3,507,398 -1.00% June 4,167,857 625,160 4,071,843 -2.30% July 5,138,308 970,451 4,964,389 -3.38% August 5,986,736 848,427 5,758,768 -3.81% September 7,133,311 1,146,575 6,896,184 -3.32% October 7,954,825 821,514 November 8,891,706 936,881 December 9,464,783 573,077 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2022 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 426,464 $ 426,464 $ 417,730 -2.05% February 1,352,938 926,475 1,322,856 -2.22% March 1,779,789 426,851 1,740,623 -2.20% April 2,159,443 379,654 2,114,167 -2.10% May 2,586,880 427,437 2,531,673 -2.13% June 2,966,444 379,564 2,904,040 -2.10% July 3,385,868 419,425 3,322,096 -1.88% August 4,311,526 925,657 4,230,484 -1.88% September 4,738,766 427,240 4,649,179 -1.89% October 5,118,192 379,426 November 5,545,860 427,668 December 5,911,497 365,637 Storm Water Sales 6,000,000 5,500,000 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. O 0. N C R C LL 21 t y+ C O 2 N N O tV L E d SZ Packet Pg. 29 I 2.3.b I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2022 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 863,521 $ 863,521 $ 877,046 1.57% February 1,571,494 707,973 1,604,010 2.07% March 2,435,565 864,071 2,451,231 0.64% April 3,143,499 707,934 3,183,083 1.26% May 4,009,811 866,312 4,066,458 1.41% June 4,719,932 710,121 4,800,930 1.72% July 5,593,564 873,631 5,679,193 1.53% August 6,307,925 714,362 6,408,113 1.59% September 7,215,145 907,220 7,308,487 1.29% October 7,936,868 721,723 November 8,819,637 882,769 December 9,528,089 708,452 *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 30 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -General Fund 2022 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 5,399,107 $ 5,399,107 $ 4,585,579 -15.07% February 9,322,828 3,923,721 8,118,010 -12.92% March 13,595,543 4,272,716 11,949,976 -12.10% April 17,336,584 3,741,040 15,453,486 -10.86% May 21,304,446 3,967,862 19,128,482 -10.21% June 26,228,329 4,923,883 23,484,941 -10.46% July 30,401,954 4,173,626 27,097,845 -10.87% August 34,351,240 3,949,285 30,838,095 -10.23% September 38,525,506 4,174,266 34,679,613 -9.98% October 43,098,529 4,573,023 November 47,899,411 4,800,883 December 52,919,589 5,020,178 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2022 Non -Departmental Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 2,507,524 $ 2,507,524 $ 2,083,892 -16.89% February 3,542,119 1,034,595 2,922,333 -17.50% March 4,860,493 1,318,374 4,072,745 -16.21% April 5,664,513 804,020 5,019,960 -11.38% May 6,660,840 996,327 5,987,679 -10.11% June 8,505,280 1,844,440 7,606,046 -10.57% July 9,569,701 1,064,422 8,530,659 -10.86% August 10,445,469 875,768 9,457,188 -9.46% September 11,460,390 1,014,920 10,403,981 -9.22% October 12,739,257 1,278,867 November 14,162,561 1,423,304 December 15,574,457 1,411,896 *The monthly budget forecast columns are based on a five-year average. O Q N C R C M 21 t y+ a O 2 N N O N L E d -W SZ 10 Packet Pg. 31 1 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -City Council 2022 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 34,048 $ 34,048 $ 23,687 -30.43% February 71,440 37,392 43,670 -38.87% March 112,337 40,897 71,408 -36.43% April 150,453 38,116 100,819 -32.99% May 199,779 49,326 129,439 -35.21% June 253,678 53,900 157,419 -37.95% July 292,429 38,751 188,068 -35.69% August 345,857 53,427 215,904 -37.57% September 383,091 37,235 248,606 -35.11% October 415,753 32,661 November 456,167 40,415 December 498,826 42,659 O 1? N C R C LL 21 t y+ C O 2 N N O N L E d Q City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2022 Office of Mayor Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 36,543 $ 36,543 $ 28,255 -22.68% February 74,682 38,139 59,226 -20.70% March 111,303 36,621 89,568 -19.53% April 148,571 37,268 119,372 -19.65% May 185,263 36,692 148,671 -19.75% June 221,237 35,974 178,561 -19.29% July 258,047 36,810 208,847 -19.07% August 295,197 37,150 238,242 -19.29% September 331,927 36,730 267,964 -19.27% October 368,014 36,088 November 405,977 37,963 December 444,165 38,188 Office of Mayor 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 00, 100,000 50,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-CurrentYeaz Budget --*-PriorYeaz *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 32 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2022 Human Resources Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 77,442 $ 77,442 $ 59,932 -22.61% February 141,711 64,269 135,524 -4.37% March 202,918 61,207 203,581 0.33% April 266,892 63,974 270,474 1.34% May 331,364 64,471 334,902 1.07% June 406,079 74,716 458,397 12.88% July 464,382 58,303 537,794 15.81% August 524,394 60,011 620,253 18.28% September 590,709 66,316 703,791 19.14% October 654,996 64,287 November 727,171 72,174 December 825,252 98,081 O Q N C R C LL 21 t y+ C O 2 N N O N L E d !Z City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2022 Municipal Court Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 104,274 $ 104,274 $ 91,643 -12.11% February 213,919 109,645 187,919 -12.15% March 322,509 108,591 284,025 -11.93% April 431,618 109,109 386,046 -10.56% May 548,538 116,920 482,322 -12.07% June 654,623 106,085 591,066 -9.71% July 763,714 109,090 691,341 -9.48% August 884,164 120,450 799,325 -9.60% September 995,970 111,806 901,515 -9.48% October 1,111,054 115,084 November 1,227,134 116,079 December 1,368,838 141,704 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. 12 Packet Pg. 33 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2022 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 53,875 $ 53,875 $ 33,127 -38.51% February 111,423 57,548 72,230 -35.17% March 168,105 56,682 122,479 -27.14% April 222,007 53,902 179,118 -19.32% May 281,764 59,757 216,588 -23.13% June 341,449 59,685 250,483 -26.64% July 403,201 61,752 288,425 -28.47% August 469,813 66,613 362,340 -22.88% September 531,648 61,834 436,484 -17.90% October 596,741 65,094 November 672,761 76,020 December 777,359 104,598 *The monthly budget forecast columns are based on a five-year average. O Q N C R C M 21 t y+ C O 2 N N O N L E d -W SZ 13 Packet Pg. 34 1 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2022 Technology Rental FLnd Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 221,840 $ 221,840 $ 216,858 -2.25% February 419,914 198,074 287,295 -31.58% March 607,242 187,328 502,978 -17.17% April 710,548 103,307 545,022 -23.30% May 844,974 134,426 603,046 -28.63% June 983,503 138,528 705,231 -28.29% July 1,100,471 116,969 771,437 -29.90% August 1,240,031 139,560 953,307 -23.12% September 1,386,757 146,726 1,118,766 -19.33% October 1,561,202 174,445 November 1,681,987 120,784 December 1,929,322 247,335 Administrative Services Technology Rental Fund 2,000,000 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget --d- Prior Year City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 248,040 $ 248,040 $ 217,022 -12.51% February 415,565 167,525 380,532 -8.43% March 585,320 169,755 547,460 -6.47% April 757,699 172,379 722,690 -4.62% May 931,182 173,483 901,287 -3.21% June 1,165,412 234,230 1,088,001 -6.64% July 1,365,658 200,246 1,236,936 -9.43% August 1,536,317 170,660 1,416,372 -7.81% September 1,711,822 175,505 1,579,959 -7.70% October 1,895,413 183,591 November 2,067,274 171,861 December 2,241,107 173,833 Administrative Services 11,800,000 11,400,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget -0-- Prior Year *The monthly budget forecast columns are based on a five-year average. O Q N 2 C R C LL t C O 2 N N O N L E d -W SZ 14 Packet Pg. 35 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2022 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 80,982 $ 80,982 $ 77,656 -4.11% February 161,963 80,982 155,234 -4.16% March 242,945 80,982 233,065 -4.07% April 323,927 80,982 287,018 -11.39% May 404,908 80,982 388,315 -4.10% June 485,890 80,982 465,893 -4.12% July 566,871 80,982 545,067 -3.85% August 647,853 80,982 622,645 -3.89% September 728,835 80,982 677,108 -7.10% October 809,816 80,982 November 890,798 80,982 December 971,780 80,982 Police City Attorney 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-- Current Yeaz Budget Prior Yeaz City of Edmonds, WA Monthly Expenditure Report -Police 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 1,045,724 $ 1,045,724 $ 973,358 -6.92% February 2,106,948 1,061,224 1,945,020 -7.69% March 3,179,076 1,072,128 3,008,075 -5.38% April 4,238,464 1,059,389 4,001,453 -5.59% May 5,298,763 1,060,299 5,133,192 -3.12% June 6,431,924 1,133,161 6,213,167 -3.40% July 7,554,526 1,122,602 7,213,970 -4.51% August 8,583,697 1,029,171 8,195,392 -4.52% September 9,661,981 1,078,283 9,281,623 -3.94% October 10,850,718 1,188,737 November 12,174,298 1,323,580 December 13,381,696 1,207,398 Police 8,000,000 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"- Current Yeaz Budget �Prior Year *The monthly budget forecast columns are based on a five-year average. O Q N FL& C R C LL t C O 2 N N O N L E d SZ 15 Packet Pg. 36 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -Development Services 2022 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 288,809 $ 288,809 $ 309,139 7.04% February 601,852 313,044 661,303 9.88% March 912,826 310,974 909,669 -0.35% April 1,246,411 333,585 1,157,411 -7.14% May 1,579,000 332,589 1,419,912 -10.08% June 1,902,288 323,288 1,678,976 -11.74% July 2,243,537 341,249 1,985,079 -11.52% August 2,571,736 328,199 2,289,744 -10.97% September 2,900,532 328,796 2,622,604 -9.58% October 3,224,853 324,321 November 3,609,934 385,081 December 4,023,619 413,685 City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2022 Parks & Recreation Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 368,331 $ 368,331 $ 319,222 -13.33% February 769,471 401,139 651,988 -15.27% March 1,168,822 399,351 1,040,803 -10.95% April 1,579,161 410,339 1,354,932 -14.20% May 1,996,670 417,509 1,709,318 -14.39% June 2,437,757 441,087 2,119,385 -13.06% July 2,916,342 478,585 2,564,042 -12.08% August 3,443,282 526,940 3,003,579 -12.77% September 3,982,496 539,213 3,429,154 -13.89% October 4,414,842 432,346 November 4,824,840 409,997 December 5,272,499 447,659 *The monthly budget forecast columns are based on a five-year average. O Q N C R C M 21 t y+ a O 2 N N O N L E d -W Q 16 Packet Pg. 37 1 I 2.3.b 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,693 $ 49,693 $ 22,716 -54.29% February 100,525 50,832 46,637 -53.61% March 150,855 50,330 71,242 -52.77% April 202,793 51,938 94,556 -53.37% May 253,578 50,786 117,239 -53.77% June 305,245 51,667 140,684 -53.91% July 357,315 52,070 163,431 -54.26% August 407,329 50,015 186,004 -54.34% September 457,258 49,929 204,884 -55.19% October 506,496 49,238 November 570,025 63,529 December 616,928 46,903 Facilities Maintenance Public Works Administration 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 220,902 $ 220,902 $ 109,202 -50.57% February 459,667 238,765 369,398 -19.64% March 728,606 268,938 562,089 -22.85% April 971,046 242,441 782,173 -19.45% May 1,215,583 244,537 942,003 -22.51% June 1,415,123 199,540 1,081,995 -23.54% July 1,659,801 244,678 1,236,300 -25.52% August 1,949,013 289,212 1,457,804 -25.20% September 2,288,332 339,319 1,693,627 -25.99% October 2,675,313 386,981 November 2,983,897 308,585 December 3,450,275 466,378 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. O Q N C R C LL 21 t C O 2 N N O N L E d Q 17 Packet Pg. 38 I 2.3.b I City of Edmonds, WA Monthly Expenditure Report -Engineering 2022 Engineering Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 225,735 $ 225,735 $ 226,829 0.48% February 453,269 227,534 457,182 0.86% March 684,496 231,227 685,977 0.22% April 918,526 234,031 914,235 -0.47% May 1,175,756 257,230 1,140,813 -2.97% June 1,413,398 237,642 1,368,545 -3.17% July 1,661,719 248,321 1,597,752 -3.85% August 1,901,196 239,477 1,829,565 -3.77% September 2,133,139 231,943 2,059,840 -3.44% October 2,368,040 234,900 November 2,604,228 236,188 December 2,847,103 242,875 O Q N .0 C fC C M , t a+ C O M N N O N L E d *The monthly budget forecast columns are based on a five-year average. 18 Packet Pg. 39 I 2.3.b I Page 1 of 1 C ITY O F IDMO NDS REVINUES BY FUND - SUMMARY Fund 2022 Amended 9/30/2021 9/30/2022 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 44,986,484 $ 30,286,676 $ 30,545,883 $ 14,440,601 680 009 LEOFF-MEDICAL INS. RESERVE 225,000 - 112,500 112,500 500 014 HISTORIC PRESERVATION GIFT FUND - 2,500 - - 04 016 BUILDING MAINTENANCE FUND 119,645 - 34,275 85,370 290 O Q. d 017 MARSH RESTORATION & PRESERVATION FUND - 150 1,150 (1,150) 00 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 - 200,000 - 1000 t� 104 DRUG ENFORCEMENT FUND 167,210 1,869 1,178 166,032 10 Ill STREET FUND 1,751,930 1,318,882 1,246,979 504,951 710 LL 112 COMBINED STREET CONST/IMPROVE 1 13,684,871 1,935,971 1,816,379 11,868,492 130 % z 117 MUNICIPAL ARTS ACQUIS. FUND 216,701 29,657 119,300 97,401 550 O 118 MEMORIAL STREET TREE - 508 - - 04 M 120 HOTEL/MOTEL TAX REVENUE FUND 84,410 54,892 82,746 1,664 cm 980 N O 121 EMPLOYEE PARKING PERMIT FUND 26,540 12,365 13,913 12,627 520 N L 122 YOUTH SCHOLARSHIP FUND 1,550 537 1,287 263 830 4) 123 TOURISM PROMOTIONAL FUND/ARTS 29,590 19,861 28,789 801 970 E d 125 REAL ESTATE EXCISE TAX 2 2 2,271,020 1,986,272 1,395,599 875,421 61° 126 REAL ESTATE EXCISE TAX 1 2 2,261,030 1,975,448 1,389,382 871,648 610 N 127 GIFT S CAT ALOG FUND 3 82,750 49,788 2,987,696 (2,904,946) 36110 130 CEMETERY MAINTENANCE/IMPROVEMT 182,430 199,874 178,527 3,903 0. 980 136 PARKS TRUST FUND 4,330 4,188 2,658 1,672 61' 137 CEMETERY MAINTENANCE TRUST FD 43,520 46,606 34,800 8,720 800 138 SISTER CITY COMMISSION 10,290 2,776 2,756 7,534 270 ca C 140 BUSINESS IMPROVEMENT DISTRICT 79,349 65,585 78,807 542 990 L 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 55,830 49,379 15,621 760 C 142 EDMONDS RESCUE PLAN FUND 3,895,663 5,952,359 634,470 3,261,193 160 O 143 TREE FUND 215,330 - 215,293 37 1000 N 231 2012 LT GO DEBT SERVICE FUND 611,370 40,853 41,009 570,361 74 332 PARKS CAPITAL CONSTRUCTION FUND 4,272,685 438,755 1,756,523 2,516,162 410 411 COMBINED UTILITY OPERATION - 5,880 123,705 (123,705) 04 421 WATER UTILITY FUND 11,018,136 8,118,880 7,968,102 3,050,034 720 422 STORM UTILITY FUND 5 7,877,897 5,283,056 5,252,382 2,625,515 670 423 SEWER/WWTP UTILITY FUND 6 26,095,636 18,832,083 14,119,537 11,976,099 540 424 BOND RESERVE FUND 1,988,700 600,425 594,350 1,394,350 300 511 EQUIPMENT RENTAL FUND 1,925,920 1,137,597 1,396,161 529,759 720 512 TECHNOLOGY RENTAL FUND 1,553,180 918,257 997,911 555,269 640 $ 125,948,167 $ 79,378,380 $ 73,423,427 $ 52,524,740 580 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Traffic Impact fee in March 2022. REET revenues are down a total of $(1,154,783) from this point in time last year. 3 Differences due to a large donation received in June of 2022. 4 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Park Impact fee in March 2022. 5 2022 Utility Rate Increases are 4.5%for Water, 5%for Sewer, and 9.5%for Storm Drain. 6 Differences due primarily to WWTP partner bilings in 2021. 19 Packet Pg. 40 I 2.3.b I Page 1 of 1 C ITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2022 Amended 9/30/2021 9/30/2022 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 52,919,589 $ 31,332,012 $ 34,679,613 $ 18,239,976 660, 009 LEOFF-MEDICAL INS. RESERVE 260,490 205,570 206,131 54,359 790, Ol l RISK MANANGEMENT RESERVE FUND 25,000 - - 25,000 0° 014 HISTORIC PRESERVATION GIFT FUND 5,900 - 5,900 00 Q 016 BUILDING MAINTENANCE FUND 545,000 - 17,074 527,926 30, 017 MARSH RESTORATION & PRESERVATION FUND - 16,149 - - 00, .D 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 123,581 - 200,000 00, 019 EDMONDS OPIOID RESPONSE FUND - 28,445 - - 0° LL 104 DRUG ENFORCEMENT FUND 45,800 - 6,291 39,509 140/ >% s Ill STREET FUND 2,315,780 1,575,701 1,618,508 697,272 700 _ 112 COMBINED STREET CONST/IMPROVE 12,868,796 1,524,722 2,327,516 10,541,280 180, 2 117 MUNICIPAL ARTSACQUIS. FUND 195,380 32,215 76,955 118,425 390, N 0 120 HOTEL/MOTEL TAX REVENUE FUND 100,900 40,520 49,390 51,510 490, N 121 EMPLOYEE PARKING PERMIT FUND 26,880 1,266 740 26,140 L 3° 122 YOUTH SCHOLARSHIP FUND 3,000 75 322 2,678 11° d 123 TOURISM PROMOTIONAL FUND/ARTS 28,200 - 5,633 22,567 r� 200, 125 REAL ESTATE EXCISE TAX 2 4,589,688 491,761 1,711832 2,877,856 370, N 126 REAL ESTATE EXCISE TAX 1 127 GIFTS CATALOG FUND 130 CEMETERY MAINTENANCE/IMPROVEMT 136 PARKS TRUST FUND 137 CEMETERY MAINTENANCE TRUST FUND 138 SISTER CITY COMMISSION 140 BUSINESS IMPROVEMENT DISTRICT 142 EDMONDS RESCUE PLAN FUND 143 TREE FUND 231 2012 LT GO DEBT SERVICE FUND 332 PARKS CAPITAL CONSTRUCTION FUND 421 WATER UTILITY FUND 422 STORM UTILITY FUND 423 SEWER/WWTP UTILITY FUND 424 BOND RESERVE FUND 511 EQUIPMENT RENTAL FUND 512 TECHNOLOGY RENTAL FUND 617 FIREMEN'S PENSION FUND 2,483,667 731,742 654,577 1,829,090 260 78,400 33,470 31,456 46,944 400 220,561 152,725 151,602 68,959 690 50,000 - 2,687 47,314 50 25,000 19,211 - 25,000 001 11,900 - 70 11,830 10,, 87,680 41,446 46,656 41,024 530 5,116,606 91,666 620,470 4,496,136 120 214,800 - - 214,800 00 611,370 40,853 41,009 570,361 70, 8,064,418 301,059 3,974,111 4,090,307 490, 11,492,138 6,552,692 5,029,624 6,462,514 440 9,620,346 3,265,985 4,329,403 5,290,943 450 31,340,523 18,442,716 11,746,881 19,593,642 370 1,988,710 600,417 589,342 1,399,368 300 2,065,371 956,094 907,060 1,158,311 440, 1,929,322 711,971 1,118,766 810,556 580, - 75,099 - - 00, $ 149,531,215 $ 67,389,163 $ 69,943,716 $ 79,587,499 470, 20 Packet Pg. 41 I 2.3.b I Page 1 of 3 Title TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 7 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GAS UTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWER UTILITY TAX 12 ST ORMWAT ER UT ILIT Y T AX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABSTAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT -COMCAST 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-ZIPLY FIBER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OT R NON -BUS LIC/PERMIT S 32 SPECIAL EVENT REVIEW INTERGOVERNMENTAL: 33 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 34 WA ASSOC OF SHERRIF'S TRAFFIC GRANT 35 HIGH VISIBILITY ENFORCEMENT 36 CORONAVIRUS RELIEF FUND 37 CORONAVIRUS RELIEF FUND 2 38 WA STATE TRAFFIC COMM GRANT 39 WASHINGTON STATE ARTSCOMMISSION 40 DOC FAC ROOFING 41 STATE GRANTS- BUDGET ONLY 42 WA STATE ART COMMISSION 2021-003-CD 43 2022-2023 BIENNUM ONE-TIME ALLOCATION 44 PUD PRIVILEDGE TAX 45 TRIAL COURT IMPROVEMENT 46 CJ- POPULATION 47 CRIMINAL JUSTICE -SPECIAL PROGRAMS 48 MARIJUANA EXCISE TAX DISTRIBUTION 49 DUI - CITIES 50 FIRE INS PREMIUM TAX 51 LIQUOR EXCISE TAX 52 LIQUOR BOARD PROFITS 53 MISCELLANEOUS INTERLOCAL REVENUE 54 INTERLOCAL GRANTS 55 FIRST RESPONDERS FLEX FUND 56 DISCOVERY PROGRAMS TECHNOLOGY ACQ. 57 VERDANT INTERLOCAL GRANTS 58 AWC - SEEK FUND C ITY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 9/30/2021 9/30/2022 Amount Budget Revenues Revenues Remaining %Received $ 11,127,000 $ 5,917,666 $ 5,846,867 $ 5,280,133 530/ 4,278,000 2,333,433 2,328,792 1,949,208 540/ 500 4 32 468 60/ 10,000,000 7,479,695 8,300,315 1,699,685 830/ 7,600 8,320 14,940 (7,340) 1970/ 870,000 698,441 765,182 104,818 880/ Q 1,410,000 1,330,863 1,349,573 60,427 960r 4) 595,000 535,887 615,300 (20,300) 1030/ W 284,000 271,128 278,679 5,321 980r 953,000 713,779 689,561 263,439 720/ _ 894,600 684,749 645,948 248,652 720/ _ 471,900 420,688 464,923 6,977 990i LL 792,000 600,997 618,225 173,775 780/ 523,000 391,086 333,419 189,581 640r s 55,200 58,459 56,600 (1,400) 1030/ _ 350 143 - 350 00/ 2 0 306,000 220,575 230,268 75,732 750r 32,568,150 21,665,911 22,538,625 10,029,525 691, N 0 250 500 250 - 1000/ N L 700 - 90 610 130r 4) 40,000 42,803 69,527 (29,527) 1740/ E 702,700 500,753 523,616 179,084 750/ 42 41,000 28,503 26,679 14,321 650/ y 100,600 47,179 35,890 64,710 360/ N 384,000 271,246 291,170 92,830 760r r_ 250,000 175,248 177,353 72,647 710/ O 63,000 66,750 76,695 (13,695) 1220/ 30,000 21,529 30,173 (173) 1010/ 650,600 564,750 605,259 45,341 930/ 24,000 9,488 12,771 11,229 53°r 'V 55,000 41,921 74,351 (19,351) 1350/ 20,000 - 16,217 3,783 810r C - 14,983 25 (25) 00/ 2,361,850 1,785,653 1,940,066 421,784 820i 9,000 6,464 5,237 3,763 580/ C - - 992 (992) 00r 2 11,100 916 1,190 9,910 110/ cV 116,276 - 71,185 45,091 610r Np - 3,947 - - 00i N L - 3,448 307 (307) 00/ G1 - - 2,000 (2,000) 00/ - 379,270 - - 00/ d 335,500 - - 335,500 00/ Q. - 6,000 - - 00/ 10 168,950 - - 00r d 210,500 - 214,277 (3,777) 1020/ d 16,740 12,105 16,163 577 970/ Q. 13,070 10,362 10,942 2,128 84°/ E 45,600 36,923 38,827 6,773 850/ 0 60,000 60,515 80,089 (20,089) 1330/ 4,500 5,143 3,497 1,003 780/ _ - 53,334 56,744 (56,744) 00/ E 261,500 216,694 221,986 39,514 850/ s 343,200 251,697 249,557 93,643 730/ R - 13,780 (13,780) 00i +"'+ Q - 27,216 - - 00/ 1,000 335 279 721 280/ 550 - - 550 00/ - 66,000 - - 00/ - - 63,411 (63,411) 00/ 1,428,536 1,309,318 1,050,462 378,074 740i 7 2022 Local Retail Sales/Use Tax revenues are $820,619 higher than 2021 revenues. Please also see pagespages 5 & 6. 21 Packet Pg. 42 1 2.3.b Page 2 of 3 C TTY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Revenues Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS 2 ATM SURCHARGE FEES 3 CREDIT CARD FEES 4 COURT RECORD SERVICES 5 D/M COURT REC SER 6 DRE REIMBURSEABLE 7 WARRANT PREPARATION FEE 8 IT TIME PAY FEE 9 MUNIC.-DIST. COURT CURR EXPEN 10 SALE MAPS & BOOKS 11 CLERKS TIME FOR SALE OF PARKING PERMITS 12 BID SUPPLIES REIMBURSEMENT 13 PHOTOCOPIES 14 POLICE DISCLOSURE REQUESTS 15 ENGINEERING FEES AND CHARGES 16 ELECTION CANDIDATE FILINGFEES 17 CUSTODIAL SERVICES (SNO-ISLE) 18 PASSPORTS AND NATURALIZATION FEES 19 POLICE SERVICES SPECIAL EVENTS 20 CAMPUS SAFETY-EDM. SCH. DIST. 21 WOODWAY-LAW PROTECTION 22 MISCELLANEOUS POLICE SERVICES 23 FIRE DISTRICT #1 STATION BILLINGS 24 LEGAL SERVICES 25 ADULT PROBATION SERVICE CHARGE 26 BOOKING FEES 27 FIRE CONSTRUCTION INSPECTION FEES 28 EMERGENCY SERVICE FEES 29 EMS TRANSPORT USER FEE 30 FLEX FUEL PAYMENTSFROM STATIONS 31 ANIMAL CONTROL SHELTER 32 ZONING/SUBDIVISION FEE 33 PLAN CHECKING FEES 34 FIRE PLAN CHECK FEES 35 PLANNING 1% INSPECTION FEE 36 S.E.P.A. REVIEW 37 CRITICAL AREA STUDY 38 GYM AND WEIGHTROOM FEES 39 PROGRAM FEES 40 TAXABLE RECREATION ACTIVITIES 41 HOLIDAY MARKET REGISTRATION FEES 42 UPTOWN EVENING MARKET FEES 43 WINTER MARKET FEES 44 BIRD FEST REGISTRATION FEES 45 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 4,418 $ 3,983 $ (983) 1330/ 600 142 222 378 370/ 11,000 3,924 441 10,559 40r 150 2 1 149 10/ 300 - - 300 00/ - 168 - - 00/ 4,000 98 98 3,902 20/ 1,000 423 56 944 60r 50 144 128 (78) 2560/ 100 - - 100 00/ 25,000 - - 25,000 00/ 600 - - 600 00/ 1,000 165 51 949 501 5,000 - - 5,000 00/ 180,000 184,125 190,712 (10,712) 1060/ 1,400 - 2,885 (1,485) 2060/ 85,000 51,102 67,773 17,227 800/ 10,000 - 3,048 6,952 300/ 30,000 18,118 - 30,000 00/ 14,000 2,505 3,169 10,831 230/ 210,970 204,825 158,227 52,743 750/ - 42 25 (25) 00/ 57,000 45,982 49,842 7,158 870/ 1,050 326 702 348 670/ 38,000 22,283 12,578 25,422 330/ 3,000 657 431 2,569 14°/ 10,000 23,963 21,987 (11,987) 2200/ 3,500 1,823 721 2,779 210/ 1,007,500 662,287 764,912 242,588 760r 2,500 2,496 3,042 (542) 1220/ 100 - 100 - 1000/ 65,600 80,618 75,028 (9,428) 1140r 592,000 365,725 328,786 263,214 5601 4,000 12,439 15,300 (11,300) 3820/ 500 158 110 390 220/ 3,000 3,700 4,715 (1,715) 1570i 14,000 13,475 12,905 1,095 920/ 13,000 91 1,640 11,360 130/ 1,011,580 404,890 543,321 468,259 540/ 1,300 - - 1,300 00/ 5,000 7,605 7,915 (2,915) 1580/ - 2,660 4,690 (4,690) 00/ - - 7,430 (7,430) 00/ 1,000 680 855 145 860/ 4,011,558 2,491,460 2,096,768 1,914,790 520/ 7,428,358 4,613,516 4,384,598 3,043,760 590i t O Q. d is c ev C U_ s_ C O 2 N N 0 N L E d N co 22 Packet Pg. 43 2.3.b Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2022 Amended 9/30/2021 9/30/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 CONY. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIES RENTALS 30 BRACKET ROOM RENTAL 31 LEASES LONG TERM 32 DONATION/CONTRIBUTION 33 PARKS DONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHERJUDGEMENT/SETTLEMENT 40 POLICE JUDGMENT SIREST IT UT ION 41 CASHIERS OVERAGES✓SHORTAGES 42 OTHER MISCREVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - MUNICIPAL COURT 46 NSF FEES - POLICE 47 NSF FEES - DEVELOPMENT SERVICES 49 L&I STAY AT WORK PROGRAM 49 US BANK REBAT E TRANSFERS -IN: 50 OPERATING TRANSFER IN 51 INTERFUND TRANSFER FROM FUND 018 52 TRANSFER FROM FUND 127 TO TAL GENERAL FUND REVENUE $ 2,000 $ 2,139 $ 1,075 $ 925 540/ 230,000 135,851 52,648 177,352 230/ 18,000 7,298 2,904 15,096 160/ 10,000 9,939 3,697 6,303 370/ 1,000 6,803 - 1,000 00/ 1,500 1,503 807 693 540/ 100,000 41,312 22,782 77,218 230/ 2,000 419 364 1,636 180/ 7,000 5,634 2,578 4,422 370/ 300 73 63 237 210/ 100 63 18 82 180/ 1,500 1,247 1,078 422 720/ 25,000 11,520 7,145 17,855 290/ 2,000 1,454 1,050 950 530/ 700 82 103 597 1501 100 12 - 100 00/ 10,000 1,592 14,673 (4,673) 1470/ 800 330 27 773 30/ 1,000 202 234 766 230/ 200 70 - 200 00/ 8,000 4,083 2,058 5,942 260/ 14,000 5,989 2,649 11,351 190/ 3,000 1,216 295 2,705 100/ 10,100 - 75 10,025 10/ 150 187 - 150 00 / 448,450 239,018 116,322 332,128 26°/ 270,390 240,140 180,183 90,207 670/ 13,340 5,598 8,163 5,177 610/ 10,180 6,275 3,372 6,808 330/ 153,000 81,395 128,382 24,618 840/ 2,100 - - 2,100 00/ 205,000 143,012 154,662 50,338 750/ 2,500 - 239 2,261 100/ 3,500 750 5,050 (1,550) 1440/ 1,500 2,010 2,070 (570) 1380/ 5,000 3,503 249 4,751 501 300 118 398 (98) 1330/ 3,800 6,547 2,825 975 740/ 2,000 - - 2,000 00/ 2,000 3,444 - 2,000 00/ 200 743 734 (534) 3670/ - 24 100 (100) 00/ 41,180 5,207 1,010 40,170 20/ 100 73 36 64 360/ 100 60 30 70 300/ 150 - 30 120 200/ - 30 - - 00/ - - 60 (60) 00/ - - 6,527 (6,527) 00/ 8,500 9,153 8,541 (41) 1000/ 724,840 508,083 502,660 222,180 690/ 28,445 - - 00/ - 123,581 - - 00/ 26,300 13,150 13,150 13,150 500/ 26,300 165,176 13,150 13,150 500/ $ 44,986,484 $ 30,286,676 $ 30,545,883 $14,440,601 680/ t O CL d is c O C M 21 s_ C O 2 N N O N L O E d N co 23 Packet Pg. 44 I 2.3.b I Page 1 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Expenditures Expenditures Remaining GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES 2 OVERTIME 3 HOLIDAY BUYBACK 4 BENEFIT S 5 UNIFORMS 6 PENSION AND DISABILITY PAYMENTS 7 SUPPLIES 8 FUEL CONSUMED 9 SMALL EQUIPMENT 10 PROFESSIONAL SERVICES 11 COMMUNICATIONS 12 TRAVEL 13 EXCISE TAXES 14 RENTAL/LEASE 15INSURANCE 16 UTILITIES 17 REPAIRS& MAINTENANCE 18 MISCELLANEOUS 19 INTERGOVERNMENTAL PAYMENTS 20 INTERFUND SUBSIDIES 21 BUILDINGS 22 MACHINERY/EQUIPMENT 23 CONSTRUCTION PROJECTS 24 GENERAL OBLIGATION BOND PRINCIPAL 25 INTEREST ON LONG-TERM EXTERNAL DEBT 26 DEBT ISSUE COSTS 27 OTHER INTEREST & DEBT SERVICE COSTS LEOFF-MEDICAL INS. RESERVE (009) 28 BENEFITS 29 PENSION AND DISABILITY PAYMENTS 30 PROFESSIONAL SERVICES 31 MISCELLANEOUS RISK MANAGEMENT RESERVE FUND (011) 32 MISCELLANEOUS HISTORIC PRESERVATION GIFTFUND (014) 33 SUPPLIES 34 PROFESSIONAL SERVICES 35 MISCELLANEOUS BUILDING MAINTENANCE FUND (016) 36 PROFESSIONAL SERVICES 37 REPAIR & MAINTENANCE 38 MACHINERY/EQUIPMENT 39 CONSTRUCTION PROJECTS MARSH RESTORATION & PRESERVATION (017) 40 PROFESSIONAL SERVICES EDMONDS HOMELESSNESS RESPONSEFUND (018) 41 PROFESSIONAL SERVICES 42 INTERFUND SUBSIDIES EDMONDS OPIOID RESPONSEFUND (019) 43 INTERFUND SUBSIDIES DRUG INFO RCEMENTFUND (104) 44 PROFESSIONAL SERVICES 45 REPAIR/MAINT 46 MACHINERY/EQUIPMENT % Spent $ 19,196,413 $ 12,591,739 $ 13,071,373 $ 6,125,040 68' 606,080 494,159 813,714 (207,634) 134' 294,001 7,101 13,780 280,221 5' 6,820,049 4,676,028 4,841,149 1,978,900 71' 119,151 54,545 66,938 52,213 56' 70,944 - 63,843 7,101 90' 481,165 330,914 346,671 134,494 72' - 215 - - 0' 208,019 178,145 165,450 42,569 80, 17,927,619 9,539,107 11,066,170 6,861,449 62' 173,735 151,313 114,727 59,008 66' 81,155 22,224 41,381 39,774 5P 16,500 18,950 23,313 (6,813) 141' 2,124,784 1,139,145 1,502,510 622,274 71' 503,161 405,121 503,160 1 100' 529,462 419,336 447,565 81,897 85' 1,087,400 632,868 372,292 715,108 34' 645,523 326,069 405,144 240,379 63' 50,000 50,000 50,000 - 100, 1,385,000 234,945 542,500 842,500 39' - - 81,116 (81,116) 0' - - 74,310 (74,310) 0' 270,180 - - 270,180 0' 55,170 - - 55,170 0' 4,790 60,087 72,294 (67,504) 1509' 268,788 - - 268,788 0' 500 - 212 288 42' 22,919,589 31,332,012 34,679,613 18,239,976 66' $ - $ 106,145 $ 122,229 $ (122,229) 0' 252,990 82,425 69,712 183,278 28' 7,000 17,000 13,704 (6,704) 196' 500 - 485 15 97' 260,490 205,570 206,131 54,359 79' $ 25,000 $ - $ $ 25,000 0' 25,000 - 25,000 0' $ 100 $ - $ $ 100 0' 200 - 200 0' 5,600 - 5,600 0' 5,900 - 5,900 0' $ 195,000 $ - $ 450 $ 194,550 0' 150,000 - 16,072 133,928 1 P 90,000 - 552 89,448 1' 110,000 - - 110,000 0' 545,000 - 17,074 527,926 3' $ $ 16,149 $ $ 0' 16,149 0' $ 200,000 $ - $ $ 200,000 0' - 123,581 - 0' 200,000 123,581 200,000 0' $ $ 28,445 $ $ 0' 28,445 0' $ 45,000 $ - $ $ 45,000 0' 800 - 800 0' - - 6,291 (6,291) 0' 45,800 - 6,291 39,509 14' t O tZ d is C R C LL 21 s_ C O 2 N N 0 N L E d N co 24 Packet Pg. 45 I 2.3.b I Page 2 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent STREETFUND (111) 1 SALARIES AND WAGES $ 749,110 $ 547,550 $ 521,363 $ 227,747 70' 2 OVERTIME 38,400 33,348 28,056 10,344 73' 3 BENEFITS 347,919 267,305 254,981 92,938 73' 4 UNIFORMS 6,000 5,432 4,341 1,659 72' 5 SUPPLIES 263,000 125,705 160,504 102,496 61' 6 SMALL EQUIPMENT 20,000 3,565 985 19,015 5' 7 PROFESSIONAL SERVICES 23,210 8,829 16,133 7,077 70' 8 COMMUNICATIONS 4,500 5,162 4,950 (450) 110' 9 TRAVEL 1,000 - - 1,000 0' 10 RENTAL/LEASE 290,150 186,447 218,642 71,508 75' 11 INSURANCE 184,111 148,533 184,111 0 100, 12 UTILITIES 273,730 183,418 175,613 98,117 64' 13 REPAIRS& MAINTENANCE 72,000 48,497 23,570 48,430 33' 14 MISCELLANEOUS 8,000 11,691 3,692 4,308 46' 15 MACHINERY/EQUIPMENT 30,000 - 21,382 8,618 71' 16 GENERAL OBLIGATION BOND PRINCIPAL 4,270 - - 4,270 0' 17INTEREST 380 220 185 195 49' $ 2,315,780 $ 1,575,701 $ 1,618,508 $ 697,272 70' COMBINED STREETCONST/IMPROVE(112) 18 PROFESSIONAL SERVICES $ 3,159,560 $ 744,072 $ 922,210 $ 2,237,350 29' 19 REPAIR & MAINTENANCE 1,508,270 67,863 2,011 1,506,259 0' 20 INTERFUND SUBSIDIES 108,975 39,925 - 108,975 0' 21 LAND - (842) 79,780 (79,780) 0' 22 CONSTRUCTION PROJECTS 8,018,521 599,912 1,250,084 6,768,437 16' 23 INTERGOVERNMENTAL LOANS 72,220 72,201 72,201 19 100' 24 INTEREST 1,250 1,591 1,230 20 98, $ 12,868,796 $ 1,524,722 $ 2,327,516 $ 10,541,280 18' MUNIC IPAL ARTS AC Q UIS. FUND (117) 25 SUPPLIES $ 4,700 $ 265 $ 966 $ 3,734 21' 26 SMALL EQUIPMENT 1,700 - - 1,700 0' 27 PROFESSIONAL SERVICES 180,000 28,877 73,619 106,381 41' 28 TRAVEL 80 - - 80 0' 29 RENTAL/LEASE 2,000 - 2,000 0' 30 REPAIRS& MAINTENANCE 300 - - 300 0' 31 MISCELLANEOUS 6,600 3,074 2,370 4,230 36' $ 195,380 $ 32,215 $ 76,955 $ 118,425 39' HO TEL/MO TEL TAX REVENUE FUND (120) 32 PROFESSIONAL SERVICES $ 95,900 $ 38,520 $ 47,390 $ 48,510 49' 33 MISCELLANEOUS 1,000 - - 1,000 0' 34 INTERFUND SUBSIDIES 4,000 2,000 2,000 2,000 50' $ 100,900 $ 40,520 $ 49,390 $ 51,510 49' EMPLO YEE PARHING PERNHT FUND (121) 35 SUPPLIES $ 1,790 $ 1,266 $ 740 $ 1,050 41' 36 PROFESSIONAL SERVICES 25,090 - - 25,090 0' $ 26,880 $ 1,266 $ 740 $ 26,140 3' YOUTH SCHOLARSHIP FUND (122) 37 SUPPLIES $ - $ - $ 322 $ (322) 0' 38 MISCELLANEOUS 3,000 75 - 3,000 0' $ 3,000 $ 75 $ 322 $ 2,678 11' TO URIS M PRO MO TIO NAL FUND/ARTS (12 3 ) 39 PROFESSIONAL SERVICES $ 28,200 $ $ 5,633 $ 22,567 20' $ 28,200 $ $ 5,633 $ 22,567 20' t O CL d !C C R C LL z C O 2 N N O N E d Q. N Cn 25 Packet Pg. 46 I 2.3.b I Page 3 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ 21,000 $ 55,954 $ 13,609 $ 7,391 65' 2 PROFESSIONAL SERVICES 469,320 112,715 692,236 (222,916) 147` 3 REPAIRS& MAINTENANCE 668,258 263,865 122,234 546,024 18' 4 INTERFUND SUBSIDIES 2,534 - - 2,534 0` 5 CONSTRUCTION PROJECTS 3,428,576 59,227 883,752 2,544,824 26' $ 4,589,688 $ 491,761 $ 1,711,832 $ 2,877,856 37' REAL ESTATE EXCISE TAXI (126) 6 PROFESSIONAL SERVICES 7 REPAIRS& MAINTENANCE 8 INTERFUND SUBSIDIES 9 CONSTRUCTION PROJECTS 10 GENERAL OBLIGATION BONDS 11 INTEREST 12 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 13 SUPPLIES 14 PROFESSIONAL SERVICES 15 MISCELLANEOUS 16 INTERFUND SUBSIDIES C EIVIETERY MAINTENANC EIMPRO VEMIINT (130) 17 SALARIES AND WAGES 18 OVERTIME 19 BENEFIT S 20 UNIFORMS 21 SUPPLIES 22 SUPPLIES PURCHASED FOR INVENTORY/RESALE 23 PROFESSIONAL SERVICES 24 COMMUNICATIONS 25 TRAVEL 26 RENTAL/LEASE 27 UTILITIES 28 REPAIRS& MAINTENANCE 29 MISCELLANEOUS PARKS TRUSTFUND (136) 30 PROFESSIONAL SERVICES CEMETERY MAINTENANCE TRUST FUND (137) 31 SMALL EQUIPMENT 32 MACHINERY/EQUIPMENT SISTER CITY COMMISSION (138) 33 SUPPLIES 34 TRAVEL 35 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 36 SUPPLIES 37 PROFESSIONAL SERVICES 38 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 39 PROFESSIONAL SERVICES TREE FUND (143) 40 SUPPLIES 41 PROFESSIONAL SERVICES 42 LAND 2012 LTGO DEBT SERVIC FUND (231) 43 GENERAL OBLIGATION BOND 44 INTEREST $ 673,827 $ 279,160 $ 472,329 $ 201,498 70' 878,353 194,829 16,897 861,456 2' 144,970 11,863 10,138 134,833 T 526,057 244,609 99,519 426,538 19` 149,820 - - 149,820 0' 110,640 1,282 55,314 55,326 50` - - 380 (380) 0' $ 2,483,667 $ 731,742 $ 654,577 $ 1,829,090 26 $ 45,000 $ 20,320 $ 18,306 $ 26,694 41 6,500 - - 6,500 0` 600 - - 600 0' 26,300 13,150 13,150 13,150 50` $ 78,400 $ 33,470 $ 31,456 $ 46,944 40' $ 119,837 $ 76,479 $ 78,649 $ 41,188 66` 3,500 302 788 2,712 23' 41,069 29,862 29,669 11,400 72' 1,000 - - 1,000 0' 7,000 1,461 2,070 4,930 30' 20,000 23,609 17,713 2,287 89, 4,200 800 1,150 3,050 27 1,700 1,262 1,292 408 76` 500 - - 500 0' 11,690 12,488 8,839 2,851 76` 5,565 3,745 3,915 1,650 70 500 - 3,536 (3,036) 707` 4,000 2,717 3,981 19 100, $ 220,561 $ 152,725 $ 151,602 $ 68,959 69' $ 50,000 $ - $ 2,687 $ 47,314 5' $ 50,000 $ - $ 2,687 $ 47,314 5` $ 25,000 $ - $ $ 25,000 0' - 19,211 - 0' $ 25,000 $ 19,211 $ $ 25,000 0' $ 1,500 $ - $ $ 1,500 0' 4,500 - 4,500 0' 5,900 - 70 5,830 1' $ 11,900 $ - $ 70 $ 11,830 1' $ 4,050 $ 397 $ 6,232 $ (2,182) 154' 77,535 39,795 39,284 38,251 51' 6,095 1,254 1,140 4,955 19, 87,680 41,446 46,656 41,024 53' $ 5,116,606 $ 91,666 $ 620,470 $ 4,496,136 12' 5,116,606 91,666 620,470 4,496,136 IT $ 1,000 $ $ $ 1,000 0` 14,800 14,800 0' 199,000 - 199,000 0' 214,800 - 214,800 0' $ 550,000 $ - $ - $ 550,000 0' 61,370 40,853 41,009 20,361 67' $ 611,370 $ 40,853 $ 41,009 $ 570,361 T t O d is C R C LL 21 z C O 2 N N 0 N L O E d O. N N 26 Packet Pg. 47 I 2.3.b I Page 4 of 6 C ITY O F IDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 95,832 $ 189,094 $ 533,902 $ (438,070) 557' 2 INTERFUND SUBSIDIES 63,000 - 62,656 344 99, 3 CONSTRUCTION PROJECTS 7,807,188 111,965 3,351,494 4,455,694 43' 4INTEREST - - 26,059 (26,059) 0' 5 DEBT ISSUE COSTS 98,398 - - 98,398 0' $ 8,064,418 $ 301,059 $ 3,974,111 $ 4,090,307 49' WATER FUND (421) 6 SALARIES AND WAGES 7 OVERTIME 8 BENEFIT S 9 UNIFORMS 10 SUPPLIES 11 WATER PURCHASED FOR RESALE 12 SUPPLIES PURCHASED FOR INVENTORY/RESALE 13 SMALL EQUIPMENT 14 PROFESSIONAL SERVICES 15 COMMUNICATIONS 16 TRAVEL 17 EXCISE TAXES 18 RENTAL/LEASE 19 INSURANCE 20 UTILITIES 21 REPAIRS& MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 MACHINERY/EQUIPMENT 25 CONSTRUCTION PROJECTS 26 GENERAL OBLIGATION BONDS 27 REVENUE BONDS 28 INTERGOVERNMENTAL LOANS 29 INTEREST 30 OTHER INTEREST & DEBT SERVICE COSTS STORM FUND (422) 31 SALARIES AND WAGES 32 OVERTIME 33 BENEFIT S 34 UNIFORMS 35 SUPPLIES 36 SMALL EQUIPMENT 37 PROFESSIONAL SERVICES 38 COMMUNICATIONS 39 TRAVEL 40 EXCISE TAXES 41 RENTAL/LEASE 42 INSURANCE 43 UTILITES 44 REPAIR & MAINTENANCE 45 MISCELLANEOUS 46 INTERFUND SUBSIDIES 47 CONSTRUCTION PROJECTS 48 GENERAL OBLIGATION BONDS 49 REVENUE BONDS 50 INTERGOVERNMENTAL LOANS 51 INTEREST 52 OTHER INTEREST & DEBT SERVICE COSTS $ 842,096 $ 493,045 $ 557,539 $ 284,557 66' 24,000 15,727 12,559 11,441 52' 330,100 210,218 238,532 91,568 72' 4,000 3,437 3,345 655 84' 150,000 82,297 110,758 39,242 74' 2,170,000 1,358,748 1,430,073 739,927 66' 170,000 151,788 113,009 56,991 66' 11,000 3,917 3,796 7,204 35' 2,237,439 1,470,514 655,384 1,582,055 29' 30,000 22,409 24,052 5,948 80' 200 - - 200 0' 1,649,700 1,075,936 1,034,763 614,937 63' 153,740 94,615 112,725 41,015 73' 122,359 98,196 122,359 (0) 100, 35,000 20,961 22,764 12,236 65' 176,130 158,267 23,457 152,673 13' 123,600 130,502 141,698 (18,098) 115' 645,370 198,136 194,533 450,837 30' 10,000 - 10,044 (44) 100, 1,998,334 839,806 87,212 1,911,122 4' 2,870 - - 2,870 0' 399,780 - - 399,780 0' 25,840 25,839 25,839 1 100, 180,580 98,336 104,805 75,775 58' - - 378 (378) 0' $ 11,492,138 $ 6,552,692 $ 5,029,624 $ 6,462,514 44' $ 734,284 $ 507,777 $ 567,227 $ 167,057 77' 26,000 19,075 10,938 15,062 42' 294,767 218,121 236,683 58,084 80' 6,500 5,049 5,870 630 90, 46,000 27,347 35,016 10,984 76' 4,000 304 985 3,015 25' 3,481,263 1,160,429 2,000,797 1,480,466 57' 3,200 4,656 4,358 (1,158) 136' 4,300 510 1,982 2,318 46' 470,100 488,846 539,880 (69,780) 115' 267,847 197,788 197,074 70,773 74' 82,335 66,228 82,335 (0) 100, 10,500 10,083 11,138 (638) 106' 67,130 80,978 12,663 54,467 19' 232,300 189,602 140,669 91,631 61' 297,787 76,327 75,745 222,042 25' 3,137,333 100,618 282,427 2,854,906 9' 104,540 - - 104,540 0' 195,390 - - 195,390 0' 53,590 53,576 61,590 (8,000) 115' 101,180 58,672 61,859 39,321 61' - - 165 (165) 0' $ 9,620,346 $ 3,265,985 $ 4,329,403 $ 5,290,943 45' t O d is C O C LL s C O 2 N N O N L d E d Q. N to 27 Packet Pg. 48 I 2.3.b I Page 5 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,090,461 $ 1,304,468 $ 1,354,596 $ 735,865 65' 2 OVERTIME 95,000 99,735 96,267 (1,267) 101, 3 BENEFITS 847,408 569,281 540,666 306,742 64' 4 UNIFORMS 9,500 8,514 8,598 902 91, 5 SUPPLIES 421,000 284,325 229,365 191,635 54' 6 FUEL CONSUMED 60,000 55,215 - 60,000 0` 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 0' 8 SMALL EQUIPMENT 35,000 162,103 105,396 (70,396) 301' 9 PROFESSIONAL SERVICES 2,468,859 3,085,205 1,743,687 725,172 71 10 COMMUNICATIONS 43,000 33,315 33,855 9,145 79' 11 TRAVEL 5,000 2,330 240 4,760 5` 12 EXCISE TAXES 978,000 834,493 811,037 166,963 83' 13 RENTAL/LEASE 319,732 328,443 238,404 81,328 75' 14 INSURANCE 227,407 162,851 203,936 23,471 90 15 UTILITIES 1,532,060 1,043,229 1,858,752 (326,692) 121' 16 REPAIR & MAINTENANCE 1,685,589 393,702 728,413 957,176 43 17 MISCELLANEOUS 126,350 92,781 199,009 (72,659) 158' 19 INTERFUND SUBSIDIES 6,687,739 3,804,155 1,175,403 5,512,336 18' 18 MACHINERY/EQUIPMENT - - 68,126 (68,126) 0' 20 CONSTRUCTION PROJECTS 12,956,488 5,796,581 1,989,039 10,967,449 15' 21 GENERAL OBLIGATION BONDS 126,500 - - 126,500 0' 22 REVENUE BONDS 89,840 - - 89,840 0' 23 INTERGOVERNMENTAL LOANS 174,610 173,888 174,591 19 100' 24 INTEREST 356,980 202,153 182,515 174,465 51' 25 DEBT ISSUE COSTS - 1,518 - - 0' 26 OTHER INTEREST & DEBT SERVICE COSTS 4 430 4 985 (4 985) 0' $ 31,340,523 $ 18,442,716 $ 11,746,881 $ 19,593,642 3T BOND RESERVE FUND (424) 27 REVENUE BONDS $ 810,010 $ - $ - $ 810,010 0( 28 INTEREST 1,178,700 600,417 589,342 589,358 50` $ 1,988,710 $ 600,417 $ 589,342 $ 1,399,368 30` t O CL d !C C O C LL z C O 2 N N O N E d rW N Cn 28 Packet Pg. 49 I 2.3.b I Page 6 of 6 C ITY O F IDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 275,712 $ 205,110 $ 210,255 $ 65,457 76' 2 OVERTIME 2,000 2,267 1,409 591 70' 3 BENEFITS 112,077 84,503 73,557 38,520 66' 4 UNIFORMS 1,500 1,129 966 534 64' 5 SUPPLIES 120,000 50,480 72,992 47,008 61' 6 FUEL CONSUMED 1,000 - - 1,000 0' 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 383,000 123,721 297,547 85,453 78' 8 SMALL EQUIPMENT 58,000 5,979 3,264 54,736 6' 9 PROFESSIONAL SERVICES 46,750 985 1,098 45,652 2' 10 COMMUNICATIONS 3,000 1,713 1,583 1,417 53' 11 TRAVEL 1,000 - - 1,000 0' 12 RENTAL/LEASE 11,160 9,215 7,803 3,357 70' 13 INSURANCE 49,172 39,334 51,903 (2,731) 106' 14 UTILITIES 14,000 12,076 14,321 (321) 102' 15 REPAIRS& MAINTENANCE 60,000 31,962 38,079 21,921 63' 16 MISCELLANEOUS 12,000 10,303 7,150 4,850 60' 17 MACHINERY/EQUIPMENT 915,000 377,315 125,132 789,868 14' $ 2,065,371 $ 956,094 $ 907,060 $ 1,158,311 44' TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 442,074 $ 227,065 $ 246,634 $ 195,440 56' 19 OVERTIME 2,000 2,257 880 1,120 44' 20 BENEFITS 159,538 79,646 93,291 66,247 58' 21 SUPPLIES 5,000 3,895 5,853 (853) 117' 22 SMALL EQUIPMENT 357,900 23,871 46,195 311,705 13' 23 PROFESSIONAL SERVICES 61,860 31,790 31,314 30,546 51' 24 COMMUNICATIONS 58,770 53,467 51,149 7,621 87' 25 TRAVEL 1,500 - - 1,500 0' 26 RENTAL/LEASE 7,460 6,081 3,345 4,115 45' 27 REPAIRS& MAINTENANCE 767,220 282,544 386,480 380,740 50' 28 MISCELLANEOUS 5,000 1,356 1,736 3,264 35' 29 MACHINERY/EQUIPMENT 61,000 - 251,887 (190,887) 413' $ 1,929,322 $ 711,971 $ 1,118,766 $ 810,556 58' FIREMAN'S PENSION FUND (617) 30 BENEFITS $ - $ 15,625 $ - $ 0' 31 PENSION AND DISABILITY PAYMENTS 47,974 0' 32 PROFESSIONAL SERVICES 11,500 0' $ - $ 75,099 $ - $ - 0' TOTAL EXPENDITURE ALL FUNDS $ 149,531,215 $ 67,389,163 $ 69,943,716 $ 79,587,499 47' t O 11 d is C R C LL s C O 2 N N O N L d E d rW N N 29 Packet Pg. 50 2.3.b Page 1 of 1 C ITY O F IDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2022 Amended 9/30/2021 9/30/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 $ 498,826 $ 247,315 $ 248,606 $ 250,220 50% 444,165 249,093 267,964 176,201 60% .-. 1= 825,252 506,717 703,791 121,461 85% 0 1,368,838 857,840 901,515 467,323 66% - 444,121 - - 0% .0 2,241,107 990,749 1,579,959 661,148 70% C 971,780 632,249 677,108 294,672 70% U- 15,574,457 8,838,355 10,403,981 5,170,476 67% C 13,381,696 8,445,438 9,281,623 4,100,073 69% 0 166,576 - 59,731 106,845 36% N 0 777,359 427,478 436,484 340,875 56% cV 4,023,619 2,183,294 2,622,604 1,401,015 65% L 0 E 459,109 51,919 108,740 350,369 24% a) 5,272,499 3,252,343 3,429,154 1,843,345 65% N 3,464,031 2,364,647 2,264,724 1,199,307 65% r_ 3,450,275 1,840,452 1,693,627 1,756,648 49% Q. $ 52,919,589 $ 31,332,012 $ 34,679,613 $ 18,239,976 66% N CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY title 2022 Amended Budget 9/30/2021 Expenditures 9/30/2022 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 11,492,138 $ 6,552,692 $ 5,029,624 $ 6,462,514 44% STORM UTILITY FUND 9,620,346 3,265,985 4,329,403 5,290,943 45% SEWER/WWTP UTILITY FUND 31,340,523 18,442,716 11,746,881 19,593,642 37% BOND RESERVE FUND 1,988,710 600,417 589,342 1,399,368 30% $ 54,441,717 $ 28,861,809 $ 21,695,249 $ 32,746,468 40% 30 Packet Pg. 51 I 2.3.b I Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2022 Amended Budget 9/30/2021 Expenditures 9/30/2022 Expenditures Amount Remaining %Spent CPIY COUNCIL SALARIES AND WAGES $ 204,132 $ 150,312 $ 140,021 $ 64,111 69% BENEFITS 121,868 77,903 69,525 52,343 57% SUPPLIES 2,000 1,808 1,956 44 98% SERVICES 170,826 17,291 37,104 133,722 22% ^� $ 498,826 $ 247,315 $ 248,606 $ 250,220 50% O O FFIC E O F MAYO R Q• N SALARIES AND WAGES $ 232,296 $ 172,424 $ 186,416 $ 45,880 80% BENEFITS 81,787 61,843 64,046 17,741 78% cC SUPPLIES 1,500 358 1,732 (232) 115% SERVICES 128,582 14,468 15,770 112,812 12% R $ 444,165 $ 249,093 $ 267,964 $ 176,201 60% C LL HUMAN RESOURCES >, SALARIES AND WAGES $ 398,299 $ 273,622 $ 357,283 $ 41,016 90% BENEFITS 142,526 103,804 119,970 22,556 84% C SUPPLIES 13,600 1,271 1,268 12,332 9% 2 SERVICES 270,827 128,020 225,270 45,558 83% N $ 825,252 $ 506,717 $ 703,791 $ 121,461 85% C MUNICIPAL C O URT N SALARIES AND WAGES $ 910,606 $ 509,139 $ 578,174 $ 332,432 63% L 4) BENEFITS 217,654 167,030 180,980 36,674 83% E SUPPLIES 11,600 5,085 7,763 3,837 67% +; SERVICES 228,978 176,586 134,598 94,380 59% $ 1,368,838 $ 857,840 $ 901,515 $ 467,323 66% (n CITY CLERK r- SALARIES AND WAGES $ $ 201,172 $ - $ 0% 0 BENEFITS 80,791 0% 4) SUPPLIES - 3,054 - 0% SERVICES - 159,105 - 0% v $ - $ 444,121 $ - $ 0% ADMINIS TRATIVE S ERVIC ES S SALARIES AND WAGES $ 1,301,073 $ 673,559 $ 975,824 $ 325,249 75% LL BENEFITS 413,858 215,185 305,796 108,062 74% SUPPLIES 13,000 4,473 7,886 5,114 61% t SERVICES 513,176 97,532 290,453 222,723 57% O $ 2,241,107 $ 990,749 $ 1,579,959 $ 661,148 70% M C ITY ATTO RNEY cV SERVICES $ 971,780 $ 632,249 $ 677,108 $ 294,672 70% N $ 971,780 $ 632,249 $ 677,108 $ 294,672 70% NON -DEPARTMENTAL = SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% d BENEFITS 145,504 26,878 95,161 50,343 65% G. SUPPLIES 5,000 4,447 - 5,000 0% SERVICES 13,557,955 8,461,998 9,643,815 3,914,140 71% d INTERFUND SUBSIDIES 1,435,000 284,945 592,500 842,500 41% d DEBT SERVICE - PRINCIPAL 55,170 - - 55,170 0% 0- DEBT SERVICE - INTEREST 274,078 60,087 72,505 201,573 26% C $ 15,574,457 $ 8,838,355 $ 10,403,981 $ 5,170,476 67% Q PO LIC E SERVIC ES SALARIES AND WAGES $ 8,723,512 $ 5,624,790 $ 5,962,225 $ 2,761,287 68% N BENEFITS 2,994,876 1,991,277 2,103,279 891,597 70% 1= SUPPLIES 281,569 164,291 212,485 69,084 75% V SERVICES 1,381,739 665,080 934,932 446,807 68% r MACHINERY/EQUIPMENT 68,702 (68,702) 0% Q $ 13,381,696 $ 8,445,438 $ 9,281,623 $ 4,100,073 69% S ATELLITE O FFIC E SALARIES AND WAGES $ 25,000 $ - $ 4,348 $ 20,652 17% BENEFITS 5,000 826 4,174 17% SUPPLIES 12,000 11,057 943 92% SERVICES 124,576 43,501 81,075 35% $ 166,576 $ $ 59,731 $ 106,845 36% 31 Packet Pg. 52 Page 2 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2022 Amended 9/30/2021 9/30/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY SERVICES/ECON DEV. SALARIES AND WAGES $ 365,627 $ 223,670 $ 192,855 $ 172,772 53% BENEFITS 111,361 67,636 57,741 53,620 52% SUPPLIES 4,075 999 317 3,758 8% SERVICES 296,296 135,173 185,572 110,724 63% $ 777,359 $ 427,478 $ 436,484 $ 340,875 56% DEVELO PMEVT S ERVIC ES /PLANNING SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES MACHINERY/EQUIPMENT HUMAN SERVICES PROGRAM SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES MACHINERY/EQUIPMENT PARKS & REC REATIO N SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES PUBLIC WORKS ADMINIS TRATIO N SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES FACILITIES MAINTENANCE SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES MACHINERY/EQUIPMENT ENGINEERING SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES TOTAL GENERAL FUND EXPENDITURES $ 1,978,832 $ 1,357,118 $ 1,505,213 $ 473,619 76% 681,706 470,912 526,300 155,406 77% 23,400 6,398 6,668 16,732 28% 1,339,681 348,867 584,424 755,257 44% 0% $ 4,023,619 $ 2,183,294 $ 2,622,604 $ 1,401,015 65% $ 101,496 $ 32,445 $ 54,357 $ 47,139 54% 29,113 7,121 15,224 13,889 52% 15,000 11,850 2,234 12,766 15% 313,500 503 31,317 282,183 10% - - 5,608 (5,608) 0% $ 459,109 51,919 108,740 350,369 24% $ 2,639,863 $ 1,737,024 $ 1,808,744 $ 831,119 69% 865,945 610,961 618,293 247,652 71% 166,640 142,878 193,370 (26,730) 116% 1,600,051 761,479 808,747 791,304 511/0 $ 5,272,499 $ 3,252,343 $ 3,429,154 $ 1,843,345 65% $ 387,424 $ 226,292 $ 96,581 $ 290,843 25% 126,689 78,349 43,024 83,665 34% 9,600 7,573 3,084 6,516 32% 93,215 66,749 62,195 31,020 67% $ 616,928 $ 378,963 $ 204,884 $ 412,044 33% 860,456 598,185 654,932 205,524 76% 369,679 253,508 264,413 105,266 72% 128,000 152,853 61,407 66,593 48% 1,821,960 835,907 631,759 1,190,201 35% 270,180 - 81,116 189,064 30% $ 3,450,275 $ 1,840,452 $ 1,693,627 $ 1,756,648 49% $ 1,866,128 $ 1,313,246 $ 1,381,896 $ 484,232 74% 702,578 517,374 507,353 195,225 72% 2,200 1,937 896 1,304 41% 276,197 153,126 169,696 106,501 61% $ 2,847,103 $ 1,985,684 $ 2,059,840 $ 787,263 72% $ 52,919,589 $ 31,332,012 $ 34,679,613 $ 18,239,976 66% O N !C C O C U- z C O 2 N N O N E d O. N co 32 Packet Pg. 53 2.3.b GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 9/30/2022 9/30/2022 Q3 YTD Fund Balance Cash Balance 0 a� 001-General Fund ' $ 11,781,589 $ 4,278,870 $ (2,606,425) $ (4,133,730 009-Leoff-Medical Ins. Reserve 161,588 161,587 (62,604) (93,631 Z 011-Risk Management Reserve Fund 25,000 25,000 - - 012-ContingencyReserve Fund 1,782,150 1,782,150 - - u_ , 014-Historic Preservation Gift Fund 16,422 16,421 016-Building Maintenance 4,417,201 4,417,201 16,647 17,201 0 017 - Marsh Restoration & Preservation 849,767 849,766 1,150 1,150 N 018 - Edmonds Homelessness Response Fd 200,000 200,000 - 200,000 N Total General Fund & Subfunds $ 19,233,716 $ 11,730,996 $ (2,651,232) $ (4,009,009 L a� E m *$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. 0 There are no interfund loans outstanding at this time. Q- a� c ca c ii GOVERNMENTAL FUNDS OVERVIEW '' 0 M N N O N L BALANCES CHANGE IN FUND BALANCES E ---- ACTUAL ---- ---- ACTUAL ---- Q. GOVERNMENTAL FUNDS 9/30/2022 9/30/2022 Q3 YTD 0 N Fund Balance Cash Balance m m General Fund & Subfunds $ 19,233,716 $ 11,730,996 $ (2,651,232) $ (4,009,009 E Special Revenue 16,626,465 25,569,389 (6,755,910) 2,975,236 U Capital Projects 1,896,274 2,146,442 (143,059) (2,217,588 d Total Governmental Funds $ 37,756,456 $ 39,446,826 $ (9,550,201) $ (3,251,362 E r Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 33 Packet Pg. 54 2.3.b SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 9/30/2022 9/30/2022 Q3 YTD Fund Balance Cash Balance 0 0 a� 104 - Drug Enforcement Fund $ 70,062 $ 70,562 $ (6,014) $ (5,113 111 - Street Fund 579,636 443,151 (160,156) (371,529 112- Combined Street Const/Improve 1,727,311 963,107 (1,492,512) (511,137 117 - Municipal Arts Acquis. Fund 691,223 694,686 (27,579) 42,345 120 - Hotel/Motel Tax Revenue Fund 104,471 91,233 15,440 33,357 121 - Employee Parking Permit Fund 89,697 90,091 879 13,173 r 122 - Youth Scholarship Fund 15,224 15,297 794 965 p 123 -Tourism Promotional Fund/Arts 119,128 115,061 7,984 23,156 M 125 - Real Estate Tax 3,737,182 3,783,495 (416,819) (316,233 c 126 - Real Estate Excise Tax 1 ` 4,048,144 3,998,255 (58,054) 734,805 N 127 - Gifts Catalog Fund 3,257,765 3,259,347 11,483 2,956,240 130 - Cemetery Maintenance/Improvement 293,131 294,540 9,494 26,925 E 136 - Parks Trust Fund 168,562 169,429 500 (28 137- Cemetery Maintenance Trust Fund 1,141,875 1,147,573 11,635 34,800 to 138 - Sister City Commission 18,167 18,246 70 140 -Business Improvement Disrict 61,282 61,282 7,436 32,150 p 141 - Affordable and Supportive Housing Fd 208,793 201,400 25,092 49,379 w 142 - Edmonds Rescue Plan Fund 58,888 9,916,708 (4,900,630) 14,000 143 - Tree Fund 235,925 235,925 215,048 215,293 Total Special Revenue $ 16,626,465 $ 25,569,389 $ (6,755,910) $ 2,975,236 *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $700,000 for the purchase of Open Space. 21 t ENTERPRISE FUNDS OVERVIEW r c a N N O N L E BALANCES CHANGE IN FUND BALANCES Q. ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- in FUNDS 9/30/2022 9/30/2022 Q3 YTD Fund Balance Cash Balance m Q. E 421 -Water Utility Fund $ 31,665,646 $ 9,110,131 $ 1,250,348 $ 2,938,478 U 422 - Storm Utility Fund 16,570,357 6,441,837 (197,378) 922,979 c 423-Sewer/WWTPUtility Fund 62,725,186 18,096,782 1,509,063 2,372,657 d E 424 - Bond Reserve Fund 848,968 848,968 3,200 5,008 t u 411 -Combined Utility Operation 123,705 154,576 41,145 123,705 r Q Total Enterprise Funds $ 111,933,862 $ 34,652,295 $ 2,606,377 $ 6,362,827 *$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. 55 2.3.b SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 9/30/2022 9/30/2022 CO, 3_ YTD Fund Balance Cash Balance 0 0 a a� Governmental Funds $ 37,756,456 $ 39,446,826 $ (9,550,201) $ (3,251,362 Enterprise Funds 111,933,862 34,652,295 2,606,377 6,362,827 c Internal Services Fund 10,655,797 6,230,715 251,050 368,246 f° c Total City-wide Total $ 160,346,115 $ 80,329,836 $ (6,692,774) $ 3,479,710 - t r c 0 a N N INTERNAL SERVICE FUNDS OVERVIEW N L E d L BALANCES CHANGE IN FUND BALANCES Q. a� ---- ACTUAL ---- ---- ACTUAL ---- FU INTERNAL SERVICE FUNDS 9/30/2022 9/30/2022 Q3 YTD c Fund Balance Cash Balance c ii 511 - Equipment Rental Fund $ 9,697,612 $ 5,445,735 $ 246,661 $ 489,101 t 512-Technology Rental Fund 958,186 784,980 4,389 (120,855 r c 0 M Total Internal Service Funds $ 10,655,797 $ 6,230,715 $ 251,050 $ 368,246 N 0 N L E d Q d d Q E 0 U c d E t U 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. 56 2.4 City Council Agenda Item Meeting Date: 12/12/2022 October 2022 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Move to full council to be received for filing. Narrative October 2022 Monthly Financial Report Attachments: October 2022 Monthly Financial Report Packet Pg. 57 I 2.4.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT OCTOBER 2022 Packet Pg. 58 1 INVESTMENT PORTFOLIO SUMMARY I 2.4.a I Agency/ Investment Issuer Type Mason & Kitsap Cnty WA Bonds Grant Cnty WA Bonds Grant Cnty WA Bonds Seattle WA Muni Bonds FHLMC Bonds FHLB Bonds First Financial - ECA CD Kent WA Bonds FHLB Bonds FM Bonds FNMA Bonds FHLB Bonds Spokane County WA Bonds First Financial - Waterfront Center CD TOTAL SECURITIES Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO City of Edmonds Investment Portfolio Detail As of October 31, 2022 Years Purchase to Par Price 948,084 1,517,955 576,332 2,224,500 988,678 1,996,590 2,803,516 286,648 954,866 996,082 992,693 950,774 207,260 1,575,000 0.08 0.17 0.17 0.25 0.47 0.93 1.04 1.08 1.44 1.63 1.67 2.05 2.09 5.01 Value 855,000 1,500,000 520,000 2,000,000 1,000,000 2,000,000 2,803,516 250,000 1,000,000 1,000,000 1,000,000 1,000,000 200,000 1,575,000 Market Value 856,248 1,492,740 521,555 2,008,900 980,588 1,914,970 2,803,516 254,678 941,068 972,038 955,797 927,300 189,298 1,575,000 Maturity Date 12/01/22 01 /01 /23 01 /01 /23 02/01 /23 04/20/23 10/05/23 11 /15/23 12/01 /23 04/10/24 06/17/24 07/02/24 11 /18/24 12/01 /24 11 /01 /27 Coupon Rate 5.00% 1.54% 5.00% 5.00% 0.38% 0.22% 2.08% 5.00% 0.35% 2.80% 1.75% 0.90% 2.10% 0.20% 17, 018, 977 1.29 16, 703, 516 16, 393, 696 20,632,681 20,632,681 Demand 3.03% 42,992,738 42,992,738 Demand 1.66% $ 80,328,935 $ 80,019,115 Seattle WA Issuer Diversification Muni, 12%� Kent WA, rhF: 1% r s t Financial- Mason & � CD, 26% Kitsap Cnty WA, 5% Grant y S okane A12�0 FHLB, 12% . County WA, 1% FNMA, 6% FHLMC, 6% Cash and Investment Balances Checki ng, (in $ Millions) _ $3.3 , 4% Bonds, CD's, $4.4, $12.3, 5% 15% State LGI P, $20.6, 25% County LGIP, $43.0, 51% s.� 11w u 1 Packet Pg. 59 1 I 2.4.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,236,875 $1,200, 000 $1,000,000 $882556 947 931 $950,684 $897 969 $800,000 $635,781 $600,000 $400,000 $200,000 $- 2017 2018 201 2020 2021 YTD 2022 2 Packet Pg. 60 GENERAL FUND SUMMARY I 2.4.a I General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenues General Fund Expenses 10,000, 000 — 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 , 4,000,000 3,000,000 2,000,000 1,000, 000 - - November February May August November February May August General Fund Tax Revenue (2016 through 2021) Sales Tax Property Tax EMS Tax Other Taxes 0 Q. d c 0 c ii 21 t c 0 2 N N O N 0 r u 12,000, 000 10,000,000_ 8,000,000 6,000, 000 4,000, 000 — 2,000, 000 i 2016 2017 2018 2019 2020 2021 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 General Fund Tax Revenue (2022 YTD) Sales Tax Property Tax $6,579,087 $2,400,332 EMS Tax Other Taxes 3 I Packet Pg. 61 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2022 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 2,504,390 $ 2,504,390 $ 2,186,816 -12.68% February 4,952,844 2,448,454 4,606,889 -6.98% March 7,433,841 2,480,997 7,290,787 -1.92% April 10,592,238 3,158,396 10,347,043 -2.31% May 19,497,731 8,905,494 19,290,212 -1.06% June 22,094,674 2,S96,943 21,853,448 -1.09% July 24,642,914 2,S48,239 24,106,033 -2.18% August 27,281,283 2,638,369 27,906,485 2.29% September 29,678,983 2,397,701 30,545,883 2.92% October 33,7S6,809 4,077,826 33,386,077 -1.10% November 42,396,838 8,640,029 December 44,986,484 2,589,646 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2022 Real Estate Excise Tax 1 & 2 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 376,007 $ 376,007 $ 135,500 -63.96% February 604,057 228,050 377,997 -37.42% March 942,203 338,145 551,531 -41.46% April 1,215,412 273,209 923,535 -24.01% May 1,570,915 355,503 1,301,746 -17.13% June 1,942,927 372,012 1,703,080 -12.34% July 2,344,831 401,904 2,043,169 -12.86% August 2,781,982 437,151 2,333,624 -16.12% September 3,225,577 443,595 2,664,145 -17.41% October 3,626,122 400,545 3,011,093 -16.96% November 4,018,664 392,542 December 4,400,000 381,336 *The monthly budget forecast columns are based on a five-year average. O Q. d M C C E 21 t a O 2 N N O N L d O v u w Packet Pg. 62 1 I 2.4.a I SALES TAX SUMMARY Sales Tax Analysis By Category Current Period: October 2022 Year -to -Date Total $9,300,633 Health & Personal Care, Amusement & $58,903 Recreation, $62,465 Automotive Repair, Construction Trade, $200,236 $1,443,364 Business Services, Accommodation, $978,729 Gasoline, $60 $44,157 Retail Food Stores, Clothing and $297,658 Accessories,$315,885 jta$il Automotive, Communications, 2,263,966 $200,167 Misc Retail, $1,740,028 Wholesale Trade, $290,825 - -.4rdManufacturing, Others, $263,015 Eating & Drinking, $105,805 $1,035,369 Annual Sales Tax Revenue 12,000,000 10,000,000 $10,302,518 g 300 633 $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 0 2016 2017 2018 201 2020 2021 YTD 2022 u 5 I Packet Pg. 63 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2022 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 763,651 $ 763,651 $ 857,872 12.34% February 1,704,609 940,958 1,853,000 8.71% March 2,420,254 715,646 2,666,259 10.16% April 3,074,639 654,384 3,469,412 12.84% May 3,893,081 818,442 4,483,349 15.16% June 4,672,507 779,426 5,402,133 15.62% July 5,523,403 850,896 6,337,518 14.74% August 6,439,084 915,680 7,348,080 14.12% September 7,293,649 854,565 8,300,315 13.80% October 8,203,996 910,347 9,300,633 13.37% November 9,139,425 935,429 December 10,000,000 860,575 City of Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2022 Gas Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 79,399 $ 79,399 $ 96,596 21.66% February 164,205 84,806 96,596 -41.17% March 246,125 81,920 305,138 23.98% April 313,860 67,734 397,808 26.75% May 367,416 53,556 469,966 27.91% June 402,173 34,757 524,767 30.48% July 429,975 27,802 563,428 31.04% August 452,332 22,357 590,667 30.58% September 472,668 20,335 615,300 30.18% October 496,035 23,367 641,329 29.29% November 534,998 38,963 December 595,000 60,002 Gas Utility Tax 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. O Q. d M C C E 21 t a O 2 N N O N L d O v u 6 Packet Pg. 64 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2022 Telephone Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 53,352 $ 53,352 $ 43,844 -17.82% February 96,981 43,629 66,255 -31.68% March 143,255 46,275 130,244 -9.08% April 192,397 49,142 175,045 -9.02% May 232,481 40,084 208,020 -10.52% June 277,770 45,288 250,253 -9.91% July 321,046 43,277 293,198 -8.67% August 362,710 41,663 308,018 -15.08% September 400,099 37,389 333,419 -16.67% October 445,363 45,264 374,814 -15.84% November 482,039 36,676 December 523,000 40,961 Electric Utility Tax Telephone Utility Tax 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget -*-- Prior Year City of Edmonds, WA Monthly Revenue Summary -Electric Utility Tax 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ February March April May June July August September October November December 148,905 $ 312,488 449,608 602,286 723,393 824,492 920,639 1,015,921 1,108,535 1,199,070 1,299,972 1,410,000 148,905 $ 183,023 163,583 377,116 137,121 534,798 152,678 726,969 121,107 858,720 101,099 993,628 96,147 1,117, 008 95,282 1,224,526 92,614 1,349,573 90,535 1,466,267 100,902 110,028 22.91 % 20.68 % 18.95 % 20.70% 18.71 % 20.51 % 21.33% 20.53% 21.74% 22.28% 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. u Packet Pg. 65 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2022 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 809,979 $ 809,979 $ 827,704 2.19% February 1,383,405 573,426 1,383,308 -0.01% March 2,213,219 829,814 2,127,271 -3.88% April 2,744,029 530,810 2,688,719 -2.02% May 3,542,697 798,668 3,507,398 -1.00% June 4,167,857 625,160 4,071,843 -2.30% July 5,138,308 970,451 4,964,389 -3.38% August 5,986,736 848,427 5,758,768 -3.81% September 7,133,311 1,146,575 6,896,184 -3.32% October 7,954,825 821,514 7,773,460 -2.28% November 8,891,706 936,881 December 9,464,783 573,077 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2022 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 426,464 $ 426,464 $ 417,730 -2.05% February 1,352,938 926,475 1,322,856 -2.22% March 1,779,789 426,851 1,740,623 -2.20% April 2,159,443 379,654 2,114,167 -2.10% May 2,586,880 427,437 2,531,673 -2.13% June 2,966,444 379,564 2,904,040 -2.10% July 3,385,868 419,425 3,322,096 -1.88% August 4,311,526 925,657 4,230,484 -1.88% September 4,738,766 427,240 4,649,179 -1.89% October 5,118,192 379,426 5,022,476 -1.87% November 5,545,860 427,668 December 5,911,497 365,637 Storm Water Sales 6,000,000 5,500,000 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. O Q. d M C C E 21 t a O 2 tV tV O N L d O v u Packet Pg. 66 I 2.4.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2022 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 863,521 $ 863,521 $ 877,046 1.57% February 1,571,494 707,973 1,604,010 2.07% March 2,435,565 864,071 2,451,231 0.64% April 3,143,499 707,934 3,183,083 1.26% May 4,009,811 866,312 4,066,458 1.41% June 4,719,932 710,121 4,800,930 1.72% July 5,593,564 873,631 5,679,193 1.53% August 6,307,925 714,362 6,408,113 1.59% September 7,215,145 907,220 7,308,487 1.29% October 7,936,868 721,723 8,051,890 1.45% November 8,819,637 882,769 December 9,528,089 708,452 i O rL d fC C R C LL 21 t r+ C O 2 N N O N L O r U *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 67 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2022 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 5,399,107 $ 5,399,107 $ 4,585,579 -15.07% February 9,322,828 3,923,721 8,118,010 -12.92% March 13,595,543 4,272,716 11,949,976 -12.10% April 17,336,584 3,741,040 15,453,486 -10.86% May 21,304,446 3,967,862 19,128,482 -10.21% June 26,228,329 4,923,883 23,484,941 -10.46% July 30,401,954 4,173,626 27,097,845 -10.87% August 34,351,240 3,949,285 30,838,095 -10.23% September 38,525,506 4,174,266 34,679,613 -9.98% October 43,098,529 4,573,023 38,757,475 -10.07% November 47,899,411 4,800,883 December 52,919,589 5,020,178 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2022 Non -Departmental Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 2,507,524 $ 2,507,524 $ 2,083,892 -16.89% February 3,542,119 1,034,595 2,922,333 -17.50% March 4,860,493 1,318,374 4,072,745 -16.21% April 5,664,513 804,020 5,019,960 -11.38% May 6,660,840 996,327 5,987,679 -10.11% June 8,505,280 1,844,440 7,606,046 -10.57% July 9,569,701 1,064,422 8,530,659 -10.86% August 10,445,469 875,768 9,457,188 -9.46% September 11,460,390 1,014,920 10,403,981 -9.22% October 12,739,257 1,278,867 11,393,678 -10.56% November 14,162,561 1,423,304 December 15,574,457 1,411,896 *The monthly budget forecast columns are based on a five-year average. O Q. d M C C E 21 t a O 2 N N O N L d O v u 10 Packet Pg. 68 1 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2022 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 34,048 $ 34,048 $ 23,687 -30.43% February 71,440 37,392 43,670 -38.87% March 112,337 40,897 71,408 -36.43% April 150,453 38,116 100,819 -32.99% May 199,779 49,326 129,439 -35.21% June 253,678 53,900 157,419 -37.95% July 292,429 38,751 188,068 -35.69% August 345,857 53,427 215,904 -37.57% September 383,091 37,235 248,606 -35.11% October 415,753 32,661 278,846 -32.93% November 456,167 40,415 December 498,826 42,659 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2022 Office of Mayor Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 36,543 $ 36,543 $ 28,255 -22.68% February 74,682 38,139 59,226 -20.70% March 111,303 36,621 89,568 -19.53% April 148,571 37,268 119,372 -19.65% May 185,263 36,692 148,671 -19.75% June 221,237 35,974 178,561 -19.29% July 258,047 36,810 208,847 -19.07% August 295,197 37,150 238,242 -19.29% September 331,927 36,730 267,964 -19.27% October 368,014 36,088 297,281 -19.22% November 405,977 37,963 December 444,165 38,188 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. O Q. d M C C E 21 t a O 2 N N O N L d O v u 11 Packet Pg. 69 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2022 Human Resources Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 77,442 $ 77,442 $ 59,932 -22.61% February 141,711 64,269 135,524 -4.37% March 202,918 61,207 203,581 0.33% April 266,892 63,974 270,474 1.34% May 331,364 64,471 334,902 1.07% June 406,079 74,716 458,397 12.88% July 464,382 58,303 537,794 15.81% August 524,394 60,011 620,253 18.28% September 590,709 66,316 703,791 19.14% October 654,996 64,287 760,658 16.13% November 727,171 72,174 December 825,252 98,081 City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2022 Municipal Court Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 104,274 $ 104,274 $ 91,643 -12.11% February 213,919 109,645 187,919 -12.15% March 322,509 108,591 284,025 -11.93% April 431,618 109,109 386,046 -10.56% May 548,538 116,920 482,322 -12.07% June 654,623 106,085 591,066 -9.71% July 763,714 109,090 691,341 -9.48% August 884,164 120,450 799,325 -9.60% September 995,970 111,806 901,515 -9.48% October 1,111,054 115,084 1,009,961 -9.10% November 1,227,134 116,079 December 1,368,838 141,704 *The monthly budget forecast columns are based on a five-year average. O Q. d M C tQ C E 21 t a O 2 N N O N L d O v u 12 Packet Pg. 70 1 I 2.4.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 ActuaIs January $ 53,875 $ 53,875 $ 33,127 -38.51% February 111,423 57,548 72,230 -35.17% March 168,105 56,682 122,479 -27.14% April 222,007 53,902 179,118 -19.32% May 281,764 59,757 216,588 -23.13% June 341,449 59,685 250,483 -26.64% July 403,201 61,752 288,425 -28.47% August 469,813 66,613 362,340 -22.88% September 531,648 61,834 436,484 -17.90% October 596,741 65,094 518,930 -13.04% November 672,761 76,020 December 777,359 104,598 O Q. d M C C E 21 t C O 2 N N O N L d ..0 O LW *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 71 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2022 Technology Rental FLnd Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 221,840 $ 221,840 $ 216,858 -2.25% February 419,914 198,074 287,295 -31.58% March 607,242 187,328 502,978 -17.17% April 710,548 103,307 545,022 -23.30% May 844,974 134,426 603,046 -28.63% June 983,503 138,528 705,231 -28.29% July 1,100,471 116,969 771,437 -29.90% August 1,240,031 139,560 953,307 -23.12% September 1,386,757 146,726 1,118,766 -19.33% October 1,561,202 174,445 1,217,201 -22.03% November 1,681,987 120,784 December 1,929,322 247,335 Administrative Services Technology Rental Fund 2,000,000 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget -d­ Prior Year City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 248,040 $ 248,040 $ 217,022 -12.51% February 415,565 167,525 380,532 -8.43% March 585,320 169,755 547,460 -6.47% April 757,699 172,379 722,690 -4.62% May 931,182 173,483 901,287 -3.21% June 1,165,412 234,230 1,088,001 -6.64% July 1,365,658 200,246 1,236,936 -9.43% August 1,536,317 170,660 1,416,372 -7.81% September 1,711,822 175,505 1,579,959 -7.70% October 1,895,413 183,591 1,768,741 -6.68% November 2,067,274 171,861 December 2,241,107 173,833 Administrative Services 11,800,000 11,400,000 800,000 600,000 - 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -"-- Current Yeaz Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. u 14 Packet Pg. 72 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2022 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 80,982 $ 80,982 $ 77,656 -4.11% February 161,963 80,982 155,234 -4.16% March 242,945 80,982 233,065 -4.07% April 323,927 80,982 287,018 -11.39% May 404,908 80,982 388,315 -4.10% June 485,890 80,982 465,893 -4.12% July 566,871 80,982 545,067 -3.85% August 647,853 80,982 622,645 -3.89% September 728,835 80,982 677,108 -7.10% October 809,816 80,982 788,707 -2.61% November 890,798 80,982 December 971,780 80,982 Police City Attorney 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-- Current Yeaz Budget Prior Yeaz City of Edmonds, WA Monthly Expenditure Report -Police 2022 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 1,045,724 $ 1,045,724 $ 973,358 -6.92% February 2,106,948 1,061,224 1,945,020 -7.69% March 3,179,076 1,072,128 3,008,075 -5.38% April 4,238,464 1,059,389 4,001,453 -5.59% May 5,298,763 1,060,299 5,133,192 -3.12% June 6,431,924 1,133,161 6,213,167 -3.40% July 7,554,526 1,122,602 7,213,970 -4.51% August 8,583,697 1,029,171 8,195,392 -4.52% September 9,661,981 1,078,283 9,281,623 -3.94% October 10,850,718 1,188,737 10,432,886 -3.85% November 12,174,298 1,323,580 December 13,381,696 1,207,398 Police 8,000,000 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"- Current Yeaz Budget �Prior Year *The monthly budget forecast columns are based on a five-year average. O Q. d M C O C E t C O 2 N N O N L d O v u 15 Packet Pg. 73 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2022 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 288,809 $ 288,809 $ 309,139 7.04% February 601,852 313,044 661,303 9.88% March 912,826 310,974 909,669 -0.35% April 1,246,411 333,585 1,157,411 -7.14% May 1,579,000 332,589 1,419,912 -10.08% June 1,902,288 323,288 1,678,976 -11.74% July 2,243,537 341,249 1,985,079 -11.52% August 2,571,736 328,199 2,289,744 -10.97% September 2,900,532 328,796 2,622,604 -9.58% October 3,224,853 324,321 3,009,709 -6.67% November 3,609,934 385,081 December 4,023,619 413,685 City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2022 Parks & Recreation Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 368,331 $ 368,331 $ 319,222 -13.33% February 769,471 401,139 651,988 -15.27% March 1,168,822 399,351 1,040,803 -10.95% April 1,579,161 410,339 1,354,932 -14.20% May 1,996,670 417,509 1,709,318 -14.39% June 2,437,757 441,087 2,119,385 -13.06% July 2,916,342 478,585 2,564,042 -12.08% August 3,443,282 526,940 3,003,579 -12.77% September 3,982,496 539,213 3,429,154 -13.89% October 4,414,842 432,346 3,830,200 -13.24% November 4,824,840 409,997 December 5,272,499 447,659 *The monthly budget forecast columns are based on a five-year average. O Q. d M C C E 21 t a O 2 N N O N L d O v u 16 Packet Pg. 74 1 I 2.4.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,693 $ 49,693 $ 22,716 -54.29% February 100,525 50,832 46,637 -53.61% March 150,855 50,330 71,242 -52.77% April 202,793 51,938 94,556 -53.37% May 253,578 50,786 117,239 -53.77% June 305,245 51,667 140,684 -53.91% July 357,315 52,070 163,431 -54.26% August 407,329 50,015 186,004 -54.34% September 457,258 49,929 204,884 -55.19% October 506,496 49,238 257,124 -49.23% November 570,025 63,529 December 616,928 46,903 Facilities Maintenance Public Works Administration 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2022 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 220,902 $ 220,902 $ 109,202 -50.57% February 459,667 238,765 369,398 -19.64% March 728,606 268,938 562,089 -22.85% April 971,046 242,441 782,173 -19.45% May 1,215,583 244,537 942,003 -22.51% June 1,415,123 199,540 1,081,995 -23.54% July 1,659,801 244,678 1,236,300 -25.52% August 1,949,013 289,212 1,457,804 -25.20% September 2,288,332 339,319 1,693,627 -25.99% October 2,675,313 386,981 1,910,071 -28.60% November 2,983,897 308,585 December 3,450,275 466,378 *The monthly budget forecast columns are based on a five-year average. O Q. d M C 19 C LL t C O 2 N N O N L d O v u 17 Packet Pg. 75 I 2.4.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2022 Engineering Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 225,735 $ 225,735 $ 226,829 0.48% February 453,269 227,534 457,182 0.86% March 684,496 231,227 685,977 0.22% April 918,526 234,031 914,235 -0.47% May 1,175,756 257,230 1,140,813 -2.97% June 1,413,398 237,642 1,368,545 -3.17% July 1,661,719 248,321 1,597,752 -3.85% August 1,901,196 239,477 1,829,565 -3.77% September 2,133,139 231,943 2,059,840 -3.44% October 2,368,040 234,900 2,301,709 -2.80% November 2,604,228 236,188 December 2,847,103 242,875 Engine a ring 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget Prior Year LW *The monthly budget forecast columns are based on a five-year average. 18 Packet Pg. 76 I 2.4.a I Page 1 of 1 C ITY O F IDMO NDS REVINUES BY FUND - SUMMARY Fund 2022 Amended 10/31/2021 10/31/2022 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 44,986,484 $ 33,150,940 $ 33,386,077 $ 11,600,407 740 009 LEOFF-MEDICAL INS. RESERVE 225,000 - 112,500 112,500 500 014 HISTORIC PRESERVATION GIFT FUND - 2,500 - - 04 016 BUILDING MAINTENANCE FUND 119,645 - 41,135 78,510 340 017 MARSH RESTORATION & PRESERVATION FUND - 150 1,150 (1,150) 04 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 - 200,000 - 1000 G 104 DRUG ENFORCEMENT FUND 167,210 1,966 1,325 165,885 14 y Ill STREET FUND 1,751,930 1,435,770 1,361,542 390,388 780 112 COMBINED STREET CONST/IMPROVE 1 13,684,871 2,000,078 3,084,444 10,600,427 230 .3 C 117 MUNICIPAL ARTS ACQUIS. FUND 216,701 46,663 124,366 92,335 570 118 MEMORIAL STREET TREE - 406 - - 00 120 HOTEL/MOTEL TAX REVENUE FUND 84,410 65,811 98,505 (14,095) 1170 t 121 EMPLOYEE PARKING PERMIT FUND 26,540 12,583 14,276 12,264 r� 540 0 O 122 YOUTH SCHOLARSHIP FUND 1,550 555 1,319 231 850 N 123 TOURISM PROMOTIONAL FUND/ARTS 29,590 23,594 34,220 (4,630) 1160 c 125 REAL ESTATE EXCISE TAX 2 2 2,271,020 2,194,260 1,577,004 694,016 N 690 126 REAL ESTATE EXCISE TAX 1 2 2,261,030 2,182,715 1,571,450 689,580 700 C 127 GIFT S CAT ALOG FUND 3 82,750 57,186 2,997,671 (2,914,921) 36230 00 130 CEMETERY MAINTENANCE/IMPROVEMT 182,430 216,266 187,737 (5,307) 1030 r- 136 PARKS TRUST FUND 4,330 4,405 3,011 1,319 700 O lZ 137 CEMETERY MAINTENANCE TRUST FD 43,520 49,813 38,145 5,375 880 4) 138 SISTER CITY COMMISSION 10,290 2,793 2,794 7,496 270 7i 140 BUSINESS IMPROVEMENT DISTRICT 79,349 73,543 85,859 (6,510) 1080 r- 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 64,607 58,039 6,961 890 E 142 EDMONDS RESCUE PLAN FUND 3,895,663 5,991,438 639,820 3,255,843 160 >% 143 TREE FUND 215,330 20,590 215,784 (454) 1000 +sr' 231 2012 LT GO DEBT SERVICE FUND 611,370 40,853 41,009 570,361 74 332 PARKS CAPITAL CONSTRUCTION FUND 4 4,272,685 441,935 1,766,892 2,505,793 410 411 COMBINED UTILITY OPERATION - 6,240 133,095 (133,095) 00 421 WATER UTILITY FUND 11,018,136 8,943,667 8,994,184 2,023,952 820 422 STORM UTILITY FUND 5 7,877,897 5,824,915 5,663,253 2,214,644 720 423 SEWER/WWTP UTILITY FUND 6 26,095,636 19,818,999 15,177,315 10,918,321 580 424 BOND RESERVE FUND 1,988,700 600,426 595,668 1,393,032 300 511 EQUIPMENT RENTAL FUND 1,925,920 1,261,266 1,550,351 375,569 800 512 TECHNOLOGY RENTAL FUND 1,553,180 1,019,283 1,094,298 458,882 700 $ 125,948,167 $ 85,556,215 $ 80,854,239 $ 45,093,928 640 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Traffic Impact fee in March 2022. REET revenues are down a total of $(1,213,888) from this point in time last year. 3 Differences due to a large donation received in June of 2022. 4 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Park Impact fee in March 2022. 5 2022 Utility Rate Increases are 4.5%for Water, 5%for Sewer, and 9.5%for Storm Drain. 6 Differences due primarily to WWTP partner bilings in 2021. 19 Packet Pg. 77 I 2.4.a I Page I of 1 CITY OF EDMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2022 Amended 10/31/2021 10/31/2022 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 52,919,589 $ 34,558,991 $ 38,757,475 $ 14,162,114 730, 009 LEOFF-MEDICAL INS. RESERVE 260,490 227,013 206,131 54,359 790, 011 RISK MANANGEMENT RESERVE FUND 25,000 - 25,000 00 014 HISTORIC PRESERVATION GIFT FUND 5,900 - 5,900 00 016 BUILDING MAINTENANCE FUND 545,000 17,074 527,926 30 017 MARSH RESTORATION & PRESERVATION FUND - 16,149 - - 00, 'i O 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 123,581 - 200,000 00, 019 EDMONDS OPIOID RESPONSE FUND - 28,445 - - 00 104 DRUG ENFORCEMENT FUND 45,800 - 6,291 39,509 140/ 'V C III STREET FUND 2,315,780 1,693,449 1,788,042 527,738 770/ 112 COMBINED STREET CONST/IMPROVE 12,868,796 1,642,307 2,888,803 9,979,993 220, LL 21 117 MUNICIPAL ARTSACQUIS. FUND 195,380 56,435 85,789 109,591 440, t 118 MEMORIAL STREET TREE - 20,487 - - 00 120 HOTEL/MOTEL TAX REVENUE FUND 100,900 43,886 56,846 44,054 560/ N 121 EMPLOYEE PARKING PERMIT FUND 26,880 1,266 740 26,140 30/ p N 122 YOUTH SCHOLARSHIP FUND 3,000 75 322 2,678 110, 123 TOURISM PROMOTIONAL FUND/ARTS 28,200 2,500 8,233 19,967 290, O 125 REAL ESTATE EXCISE TAX 2 4,589,688 584,109 2,051,083 2,538,605 450, O 126 REAL ESTATE EXCISE TAX 1 2,483,667 901,314 683,550 1,800,117 28° r- 127 GIFTS CATALOG FUND 78,400 34,949 96,645 (18,245) 1230/ 0 0. 130 CEMETERY MAINTENANCE/IMPROVEMT 220,561 165,690 169,088 51,473 770 4) 136 PARKS TRUST FUND 50,000 - 2,687 47,314 50, <0 137 CEMETERY MAINTENANCE TRUST FUND 25,000 19,211 - 25,000 00, C 138 SISTER CITY COMMISSION 11,900 - 70 11,830 10, E 140 BUSINESS IMPROVEMENT DISTRICT 87,680 42,087 52,104 35,576 590/ >, 142 EDMONDS RESCUE PLAN FUND 5,116,606 628,177 689,835 4,426,771 s 130/ 143 TREE FUND 214,800 - - 214,800 0° 0 231 2012 LT GO DEBT SERVICE FUND 611,370 40,853 41,489 569,881 70, N 332 PARKS CAPITAL CONSTRUCTION FUND 8,064,418 1,145,475 4,925,900 3,138,518 610 N 421 WATER UTILITY FUND 11,492,138 7,092,861 5,667,596 5,824,542 L 490, 422 STORM UTILITY FUND 9,620,346 3,589,509 5,340,606 4,279,740 560 V 423 SEWER/WWTP UTILITY FUND 31,340,523 21,928,479 12,618,940 18,721,583 400/ O 424 BOND RESERVE FUND 1,988,710 600,417 589,342 1,399,368 300, 511 EQUIPMENT RENTAL FUND 2,065,371 1,054,526 1,139,877 925,494 550, 512 TECHNOLOGY RENTAL FUND 1,929,322 944,850 1,217,201 712,121 630 w 617 FIREMEN'S PENSION FUND - 83,914 - - 00 Q $ 149,531,215 $ 77,271,007 $ 79,101,758 $ 70,429,457 530, 20 Packet Pg. 78 I 2.4.a I Page 1 of 3 Title TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 7 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GAS UTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWER UTILITY TAX 12 ST ORMWAT ER UT ILIT Y T AX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABSTAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT -COMCAST 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-ZIPLY FIBER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OT R NON -BUS LIC/PERMIT S 32 SPECIAL EVENT REVIEW INTERGOVERNMENTAL: 33 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 34 WA ASSOC OF SHERRIF'S TRAFFIC GRANT 35 HIGH VISIBILITY ENFORCEMENT 36 CORONAVIRUS RELIEF FUND 37 CORONAVIRUS RELIEF FUND 2 38 WA STATE TRAFFIC COMM GRANT 39 WASHINGTON STATE ARTSCOMMISSION 40 DOC FAC ROOFING 41 STATE GRANTS- BUDGET ONLY 42 WA STATE ART COMMISSION 2021-003-CD 43 2022-2023 BIENNUM ONE-TIME ALLOCATION 44 PUD PRIVILEDGE TAX 45 TRIAL COURT IMPROVEMENT 46 CJ- POPULATION 47 CRIMINAL JUSTICE -SPECIAL PROGRAMS 48 MARIJUANA EXCISE TAX DISTRIBUTION 49 DUI - CITIES 50 FIRE INS PREMIUM TAX 51 LIQUOR EXCISE TAX 52 LIQUOR BOARD PROFITS 53 MISCELLANEOUS INTERLOCAL REVENUE 54 INTERLOCAL GRANTS 55 FIRST RESPONDERS FLEX FUND 56 DISCOVERY PROGRAMS TECHNOLOGY ACQ. 57 VERDANT INTERLOCAL GRANTS 58 AWC - SEEK FUND C ITY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 10/31/2021 10/31/2022 Amount Budget Revenues Revenues Remaining %Received $ 11,127,000 $ 6,119,988 $ 6,026,481 $ 5,100,519 540/ 4,278,000 2,413,236 2,400,332 1,877,668 560/ 500 4 32 468 60r 10,000,000 8,493,819 9,300,633 699,367 930/ 7,600 9,355 17,012 (9,412) 2240i 870,000 780,773 854,048 15,952 980/ 1,410,000 1,439,342 1,466,267 (56,267) 1040r 595,000 565,388 641,329 (46,329) 108°/ 284,000 300,135 311,692 (27,692) 1100/ .. C 953,000 788,393 777,290 175,710 820/ 0 894,600 754,417 720,312 174,288 810/ 471,900 454,627 502,253 (30,353) 1060i _ 792,000 670,379 618,225 173,775 780/ to 523,000 452,939 374,814 148,186 720r 55,200 70,840 65,493 (10,293) 1190/ 350 279 - 350 00/ LL 306,000 220,575 230,321 75,679 75°1 >, 32,568,150 23,534,489 24,306,533 8,261,617 750, t C 250 550 300 (50) 1200/ 0 700 - 170 530 240r 40,000 52,459 74,631 (34,631) 1870/ N 702,700 676,727 523,616 179,084 750/ N 41,000 31,583 26,679 14,321 650/ L 100,600 47,179 35,890 64,710 360/ 384,000 271,246 291,170 92,830 76°r 250,000 194,162 196,327 53,673 790/ O 63,000 76,265 85,335 (22,335) 1350/ v 30,000 21,529 30,173 (173) 1010/ 650,600 605,697 658,881 (8,281) 1010/ Q 24,000 9,826 13,085 10,915 5501 � 55,000 62,190 80,379 (25,379) 1460 20,000 - 17,715 2,285 890r ea - 16,192 25 (25) 00/ _ 2,361,850 2,065,604 2,034,375 327,475 860i 9,000 6,464 5,237 3,763 580/ IL - - 992 (992) 0°r t 11,100 916 1,190 9,910 110/ 116,276 - 71,185 45,091 610r 0 - 3,947 - - 00/ - 9,777 307 (307) 00/ N N - - 2,000 (2,000) 00/ CD 379,270 - - 00/ 335,500 - - 335,500 00r - 6,000 - - 00/ 42 168,950 - - 00r O 210,500 208,112 214,277 (3,777) 1020/ 16,740 12,105 16,163 577 97°/ C 13,070 13,962 14,744 (1,674) 1130r 45,600 49,717 52,278 (6,678) 1150/ t 60,000 60,515 80,089 (20,089) 1330/ 4,500 6,950 4,913 (413) 1090/ w - 53,334 56,744 (56,744) 00/ Q 261,500 297,159 303,313 (41,813) 1160i 343,200 251,697 249,557 93,643 730/ - 13,780 (13,780) 00i - 27,216 - - 00/ 1,000 442 279 721 280/ 550 - - 550 00/ - 66,000 - - 00/ - - 63,411 (63,411) 00r 1,428,536 1,622,533 1,150,459 278,077 810i 7 2022 Local Retail Sales/Use Tax revenues are $806,814 higher than 2021 revenues. Please also see pagespages 5 & 6. 21 Packet Pg. 79 1 2.4.a Page 2 of 3 C TTY O F IDMO NDS REVENUES - GENERAL FUND 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Revenues Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS 2 ATM SURCHARGE FEES 3 CREDIT CARD FEES 4 COURT RECORD SERVICES 5 D/M COURT REC SER 6 DRE REIMBURSEABLE 7 WARRANT PREPARATION FEE 8 IT TIME PAY FEE 9 MUNIC.-DIST. COURT CURR EXPEN 10 SALE MAPS & BOOKS 11 CLERKS TIME FOR SALE OF PARKING PERMITS 12 BID SUPPLIES REIMBURSEMENT 13 PHOTOCOPIES 14 POLICE DISCLOSURE REQUESTS 15 ENGINEERING FEES AND CHARGES 16 ELECTION CANDIDATE FILINGFEES 17 CUSTODIAL SERVICES (SNO-ISLE) 18 PASSPORTS AND NATURALIZATION FEES 19 POLICE SERVICES SPECIAL EVENTS 20 CAMPUS SAFETY-EDM. SCH. DIST. 21 WOODWAY-LAW PROTECTION 22 MISCELLANEOUS POLICE SERVICES 23 FIRE DISTRICT #1 STATION BILLINGS 24 LEGAL SERVICES 25 ADULT PROBATION SERVICE CHARGE 26 BOOKING FEES 27 FIRE CONSTRUCTION INSPECTION FEES 28 EMERGENCY SERVICE FEES 29 EMS TRANSPORT USER FEE 30 FLEX FUEL PAYMENTSFROM STATIONS 31 ANIMAL CONTROL SHELTER 32 ZONING/SUBDIVISION FEE 33 PLAN CHECKING FEES 34 FIRE PLAN CHECK FEES 35 PLANNING 1% INSPECTION FEE 36 S.E.P.A. REVIEW 37 CRITICAL AREA STUDY 38 GYM AND WEIGHTROOM FEES 39 PROGRAM FEES 40 TAXABLE RECREATION ACTIVITIES 41 HOLIDAY MARKET REGISTRATION FEES 42 UPTOWN EVENING MARKET FEES 43 WINTER MARKET FEES 44 BIRD FEST REGISTRATION FEES 45 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 4,418 $ 5,102 $ (2,102) 1700/ 600 216 256 344 430/ 11,000 4,123 441 10,559 40r 150 2 1 149 10/ 300 - - 300 00/ - 168 - - 00/ 4,000 98 98 3,902 20/ 1,000 465 77 923 80r 50 176 163 (113) 3260/ 100 - - 100 00/ 25,000 - - 25,000 00/ 600 - - 600 00/ 1,000 180 81 919 80/ 5,000 - - 5,000 00/ 180,000 193,020 206,883 (26,883) 1150i 1,400 - 2,885 (1,485) 2060/ 85,000 70,262 68,373 16,627 800/ 10,000 - 3,958 6,042 400/ 30,000 18,118 17,188 12,812 570/ 14,000 2,505 3,169 10,831 230/ 210,970 204,825 158,227 52,743 750/ - 52 25 (25) 00/ 57,000 57,132 49,842 7,158 870/ 1,050 359 702 348 670/ 38,000 24,347 16,736 21,264 440/ 3,000 685 532 2,468 180/ 10,000 26,140 27,784 (17,784) 2780/ 3,500 1,931 1,083 2,417 310/ 1,007,500 662,287 764,912 242,588 760r 2,500 3,351 3,042 (542) 1220/ 100 - 100 - 1000/ 65,600 84,563 81,403 (15,803) 1240r 592,000 399,920 384,068 207,932 650/ 4,000 12,739 15,700 (11,700) 3920/ 500 158 110 390 220/ 3,000 3,700 4,715 (1,715) 1570i 14,000 14,740 14,005 (5) 1000/ 13,000 91 2,299 10,701 180/ 1,011,580 413,314 566,576 445,004 560/ 1,300 - - 1,300 00/ 5,000 12,635 10,875 (5,875) 2180/ - 2,660 4,690 (4,690) 00/ - - 7,430 (7,430) 00/ 1,000 680 855 145 860/ 4,011,558 2,745,897 2,746,202 1,265,356 680/ 7,428,358 4,965,957 5,170,588 2,257,770 700i O CL d C eo C IL t C O 2 N N O N N O tt 22 Packet Pg. 80 2.4.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2022 Amended 10/31/2021 10/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 CONY. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIES RENTALS 30 BRACKET ROOM RENTAL 31 LEASES LONG TERM 32 DONATION/CONTRIBUTION 33 PARKS DONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHERJUDGEMENT/SETTLEMENT 40 POLICE JUDGMENT SIREST IT UT ION 41 CASHIERS OVERAGES✓SHORTAGES 42 OTHER MISCREVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - MUNICIPAL COURT 46 NSF FEES - POLICE 47 NSF FEES - DEVELOPMENT SERVICES 49 L&I STAY AT WORK PROGRAM 49 US BANK REBAT E TRANSFERS -IN: 50 OPERATING TRANSFER IN 51 INTERFUND TRANSFER FROM FUND 018 52 TRANSFER FROM FUND 127 TO TAL GENERAL FUND REVENUE $ 2,000 $ 2,189 $ 1,345 $ 655 670/ 230,000 140,662 71,201 158,799 310/ 18,000 7,883 3,412 14,588 190/ 10,000 10,374 5,069 4,931 510/ 1,000 7,903 - 1,000 00/ 1,500 1,548 842 658 560/ 100,000 42,512 36,087 63,913 360/ 2,000 419 614 1,386 310/ 7,000 6,131 3,473 3,527 5001 300 73 133 167 440/ 100 65 23 77 230/ 1,500 1,359 1,423 77 950/ 25,000 11,971 8,532 16,468 340/ 2,000 1,531 1,422 578 710/ 700 93 103 597 1501 100 12 - 100 00/ 10,000 2,026 14,699 (4,699) 1470/ 800 330 34 766 40/ 1,000 241 326 674 330/ 200 79 - 200 00/ 8,000 4,203 2,973 5,027 370/ 14,000 6,310 3,890 10,110 280/ 3,000 1,240 470 2,530 160/ 10,100 - 188 9,913 20/ 150 (24) - 150 00/ 448,450 249,131 156,258 292,192 35°/ 270,390 252,155 202,957 67,433 750/ 13,340 5,976 10,143 3,197 760/ 10,180 6,590 4,017 6,163 390/ 153,000 83,591 134,229 18,771 880/ 2,100 - - 2,100 00/ 205,000 159,113 171,845 33,155 840/ 2,500 29 1,276 1,224 5101 3,500 750 5,050 (1,550) 1440/ 1,500 2,010 2,070 (570) 1380/ 5,000 3,503 249 4,751 50/ 300 859 398 (98) 1330/ 3,800 6,569 3,810 (10) 1000/ 2,000 - - 2,000 00/ 2,000 3,444 - 2,000 00/ 200 753 734 (534) 3670/ - 24 315 (315) 00/ 41,180 5,475 2,296 38,884 60/ 100 74 47 53 470/ 100 60 30 70 300/ 150 - 60 90 400/ - 30 - - 00/ - - 120 (120) 00/ - 7,893 6,527 (6,527) 00/ 8,500 9,153 8,541 (41) 1000/ 724,840 548,050 554,715 170,125 770/ 28,445 - - 00/ - 123,581 - - 00/ 26,300 13,150 13,150 13,150 500/ 26,300 165,176 13,150 13,150 500/ $ 44,986,484 $ 33,150,940 $ 33,386,077 $11,600,407 740/ 23 Packet Pg. 81 I 2.4.a I Page 1 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Expenditures Expenditures Remaining GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES 2 OVERTIME 3 HOLIDAY BUYBACK 4 BENEFIT S 5 UNIFORMS 6 PENSION AND DISABILITY PAYMENTS 7 SUPPLIES 8 FUEL CONSUMED 9 SMALL EQUIPMENT 10 PROFESSIONAL SERVICES 11 COMMUNICATIONS 12 TRAVEL 13 EXCISE TAXES 14 RENTAL/LEASE 15INSURANCE 16 UTILITIES 17 REPAIRS& MAINTENANCE 18 MISCELLANEOUS 19 INTERGOVERNMENTAL PAYMENTS 20 INTERFUND SUBSIDIES 21 BUILDINGS 22 MACHINERY/EQUIPMENT 23 CONSTRUCTION PROJECTS 24 GENERAL OBLIGATION BOND PRINCIPAL 25 INTEREST ON LONG-TERM EXTERNAL DEBT 26 DEBT ISSUE COSTS 27 OTHER INTEREST & DEBT SERVICE COSTS LEOFF-MEDICAL INS. RESERVE (009) 28 BENEFITS 29 PENSION AND DISABILITY PAYMENTS 30 PROFESSIONAL SERVICES 31 MISCELLANEOUS RISK MANAGEMENT RESERVE FUND (011) 32 MISCELLANEOUS HISTORIC PRESERVATION GIFTFUND (014) 33 SUPPLIES 34 PROFESSIONAL SERVICES 35 MISCELLANEOUS BUILDING MAINTENANCE FUND (016) 36 PROFESSIONAL SERVICES 37 REPAIR & MAINTENANCE 38 MACHINERY/EQUIPMENT 39 CONSTRUCTION PROJECTS MARSH RESTORATION & PRESERVATION (017) 40 PROFESSIONAL SERVICES EDMONDS HOMELESSNESS RESPONSEFUND (018) 41 PROFESSIONAL SERVICES 42 INTERFUND SUBSIDIES EDMONDS OPIOID RESPONSEFUND (019) 43 INTERFUND SUBSIDIES DRUG INFO RCEMENTFUND (104) 44 PROFESSIONAL SERVICES 45 REPAIR/MAINT 46 MACHINERY/EQUIPMENT % Spent $ 19,196,413 $ 13,975,288 $ 14,663,067 $ 4,533,346 76' 606,080 560,932 906,200 (300,120) 150' 294,001 7,458 15,727 278,274 5' 6,820,049 5,171,507 5,398,171 1,421,878 79' 119,151 61,420 76,776 42,375 64' 70,944 - 71,274 (330) 100' 481,165 376,577 374,559 106,606 78' - 215 - - 0' 208,019 194,015 181,098 26,921 87' 17,927,619 10,484,133 12,439,921 5,487,698 69' 173,735 153,750 133,899 39,836 77' 81,155 26,985 45,848 35,307 56' 16,500 21,504 25,470 (8,970) 154' 2,124,784 1,270,455 1,667,150 457,634 78' 503,161 405,121 503,160 1 100' 529,462 449,525 484,411 45,051 91, 1,087,400 703,766 435,305 652,095 40' 645,523 351,308 455,758 189,765 71' 50,000 50,000 50,000 - 100, 1,385,000 234,945 542,500 842,500 39' - - 81,116 (81,116) 0' - - 133,561 (133,561) 0' 270,180 - - 270,180 0' 55,170 - - 55,170 0' 4,790 60,087 72,294 (67,504) 1509' 268,788 - - 268,788 0' 500 - 212 288 42' 52,919,589 34,558,991 38,757,475 14,162,114 73' $ - $ 121,888 $ 122,229 $ (122,229) 0' 252,990 88,125 69,712 183,278 28' 7,000 17,000 13,704 (6,704) 196' 500 - 485 15 97' 260,490 227,013 206,131 54,359 79' $ 25,000 $ - $ $ 25,000 0' 25,000 - 25,000 0' $ 100 $ - $ $ 100 0' 200 - 200 0' 5,600 - 5,600 0' 5,900 - 5,900 0' $ 195,000 $ - $ 450 $ 194,550 0' 150,000 - 16,072 133,928 1 P 90,000 - 552 89,448 1' 110,000 - - 110,000 0' 545,000 - 17,074 527,926 3' $ $ 16,149 $ $ 0' 16,149 0' $ 200,000 $ - $ $ 200,000 0' - 123,581 - 0' 200,000 123,581 200,000 0' $ $ 28,445 $ $ 0' 28,445 0' $ 45,000 $ - $ $ 45,000 0' 800 - 800 0' - - 6,291 (6,291) 0' 45,800 - 6,291 39,509 14' O s?. d C eo C li t C O 2 N N 0 N L d O r c� u 24 Packet Pg. 82 I 2.4.a I Page 2 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Expenditures Expenditures Remaining "/„ Spent STREEl'FUND (111) 1 SALARIES AND WAGES $ 749,110 $ 597,387 $ 575,583 $ 173,527 77' 2 OVERTIME 38,400 35,504 30,960 7,440 81' 3 BENEFITS 347,919 290,284 282,152 65,767 81' 4 UNIFORMS 6,000 5,432 4,341 1,659 72' 5 SUPPLIES 263,000 126,921 193,663 69,337 74' 6 SMALL EQUIPMENT 20,000 3,565 1,517 18,483 8' 7 PROFESSIONAL SERVICES 23,210 8,991 16,803 6,407 72' 8 COMMUNICATIONS 4,500 5,271 5,549 (1,049) 123' 9 TRAVEL 1,000 - - 1,000 0' 10 RENTAL/LEASE 290,150 206,903 242,671 47,479 84' 11 INSURANCE 184,111 148,533 184,111 0 100' 12 UTILITIES 273,730 204,135 196,653 77,077 72' 13 REPAIRS& MAINTENANCE 72,000 48,497 28,783 43,217 40' 14 MISCELLANEOUS 8,000 11,807 3,692 4,308 46' 15 MACHINERY/EQUIPMENT 30,000 - 21,382 8,618 71' 16 GENERAL OBLIGATION BOND PRINCIPAL 4,270 - - 4,270 0' 17 INTEREST 380 220 185 195 49' COMBINED STREErCONST/IMPROVE(112) 18 PROFESSIONAL SERVICES 19 REPAIR & MAINTENANCE 20 INTERFUND SUBSIDIES 21 LAND 22 CONSTRUCTION PROJECTS 23 INTERGOVERNMENTAL LOANS 24 INTEREST MUNIC IPAL ARTS AC Q UIS. FUND (117) 25 SUPPLIES 26 SMALL EQUIPMENT 27 PROFESSIONAL SERVICES 28 TRAVEL 29 RENTAL/LEASE 30 REPAIRS& MAINTENANCE 31 MISCELLANEOUS MEMO RIAL S TREET TREE FUND (118) ki�4lI�YY�1:7�L�1�1�7.Y�17.ylUhfc! HO TEL/MO TEL TAX REVENUE FUND (120) 33 PROFESSIONAL SERVICES 34 MISCELLANEOUS 35 INTERFUND SUBSIDIES EMPLO YEE PARIUNG PERMIT FUND (121) 36 SUPPLIES 37 PROFESSIONAL SERVICES YOUTH SCHOLARSHIP FUND (122) 38 SUPPLIES 39 MISCELLANEOUS TO URIS M PRO MO TIO NAL FUND/ARTS (123) 40 PROFESSIONAL SERVICES $ 2,315,780 $ 1,693,449 $ 1,788,042 $ 527,738 77' $ 3,159,560 $ 861,656 $ 1,043,040 $ 2,116,520 33' 1,508,270 67,863 2,011 1,506,259 0' 108,975 39,925 - 108,975 0' - (842) 80,002 (80,002) 0' 8,018,521 599,912 1,690,318 6,328,203 21' 72,220 72,201 72,201 19 100' 1,250 1,591 1,230 20 98, $ 12,868,796 $ 1,642,307 $ 2,888,803 $ 9,979,993 22' $ 4,700 $ 300 $ 966 $ 3,734 21' 1,700 - - 1,700 0' 180,000 52,862 82,204 97,796 46' 80 - - 80 0' 2,000 - 2,000 0' 300 - - 300 0' 6,600 3,274 2,619 3,981 40' $ 195,380 $ 56,435 $ 85,789 $ 109,591 44' $ $ 20,487 $ $ 0' $ $ 20,487 $ $ 0' $ 95,900 $ 41,886 $ 54,846 $ 41,054 57' 1,000 - - 1,000 0' 4,000 2,000 2,000 2,000 50' $ 100,900 $ 43,886 $ 56,846 $ 44,054 56' $ 1,790 $ 1,266 $ 740 $ 1,050 41' 25,090 - - 25,090 0' $ 26,880 $ 1,266 $ 740 $ 26,140 3' $ - $ - $ 322 $ (322) 0' 3,000 75 - 3,000 0' $ 3,000 $ 75 $ 322 $ 2,678 H, $ 28,200 $ 2,500 $ 8,233 $ 19,967 29' $ 28,200 $ 2,500 $ 8,233 $ 19,967 29' O s?. d C O C E t C O 2 N N O N L d O v 25 Packet Pg. 83 I 2.4.a I Page 3 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX 2 (125) 1 SUPPLIES $ 21,000 $ 61,712 $ 16,925 $ 4,075 81, 2 PROFESSIONAL SERVICES 469,320 199,305 730,570 (261,250) 156 3 REPAIRS& MAINTENANCE 668,258 263,865 157,632 510,626 24' 4 INTERFUND SUBSIDIES 2,534 - - 2,534 0' 5 CONSTRUCTION PROJECTS 3,428,576 59,227 1,145,956 2,282,620 33' $ 4,589,688 $ 584,109 $ 2,051,083 $ 2,538,605 45' REAL ESTATE EXCISE TAXI (126) 6 PROFESSIONAL SERVICES 7 REPAIRS& MAINTENANCE 8 INTERFUND SUBSIDIES 9 LAND 10 CONSTRUCTION PROJECTS 11 GENERAL OBLIGATION BONDS 12 INTEREST 13 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 14 SUPPLIES 15 PROFESSIONAL SERVICES 16 MISCELLANEOUS 17 INTERFUND SUBSIDIES C EVIEIERY MAINTEN ANC EIMPRO VEMEVT (130) 18 SALARIES AND WAGES 19 OVERTIME 20 BENEFIT S 21 UNIFORMS 22 SUPPLIES 23 SUPPLIES PURCHASED FOR INVENTORY/RESALE 24 PROFESSIONAL SERVICES 25 COMMUNICATIONS 26 TRAVEL 27 RENTAL/LEASE 28 UTILITIES 29 REPAIRS& MAINTENANCE 30 MISCELLANEOUS PARKS TRUST FUND (136) 31 PROFESSIONAL SERVICES CEIVIEIERY MAINTENANCE TRUST FUND (137) 32 SMALL EQUIPMENT 32 MACHINERY/EQUIPMENT SISTER CITY COMMISSION (138) 34 SUPPLIES 35 TRAVEL 36 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 37 SUPPLIES 38 PROFESSIONAL SERVICES 39 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 40 PROFESSIONAL SERVICES TREE FUND (143) 41 SUPPLIES 42 PROFESSIONAL SERVICES 43 LAND 2012 LTGO DEBT SERVIC FUND (231) 44 GENERAL OBLIGATION BOND 45 INTEREST $ 673,827 $ 318,410 $ 500,537 $ 173,290 74' 878,353 194,829 16,897 861,456 2' 144,970 11,863 10,138 134,833 T - 46,952 - - 0' 526,057 327,979 99,685 426,372 19' 149,820 - - 149,820 0' 110,640 1,282 55,314 55,326 50` - - 980 (980) 0' $ 2,483,667 $ 901,314 $ 683,550 $ 1,800,117 28` $ 45,000 $ 21,799 $ 83,495 $ (38,495) 186( 6,500 - - 6,500 0' 600 - - 600 0` 26,300 13,150 13,150 13,150 50' $ 78,400 $ 34,949 $ 96,645 $ (18,245) 123` $ 119,837 $ 83,538 $ 89,063 $ 30,774 74' 3,500 302 832 2,668 24 41,069 32,850 33,159 7,910 81' 1,000 490 - 1,000 0' 7,000 1,611 2,792 4,208 40` 20,000 24,059 19,401 599 97' 4,200 800 1,150 3,050 27` 1,700 1,403 1,436 264 84' 500 - - 500 0` 11,690 13,875 9,823 1,867 84' 5,565 4,045 3,915 1,650 70` 500 - 3,536 (3,036) 70T 4,000 2,717 3,981 19 100, $ 220,561 $ 165,690 $ 169,088 $ 51,473 77' $ 50,000 $ $ 2,687 $ 47,314 5' $ 50,000 $ - $ 2,687 $ 47,314 5' $ 25,000 $ - $ $ 25,000 0' - 19,211 - 0' $ 25,000 $ 19,211 $ $ 25,000 0' $ 1,500 $ - $ $ 1,500 0' 4,500 - 4,500 0' 5,900 - 70 5,830 1' $ 11,900 $ - $ 70 $ 11,830 1' $ 4,050 $ 397 $ 6,232 $ (2,182) 154' 77,535 40,049 44,294 33,241 57` 6,095 1,641 1,578 4,517 26' 87,680 42,087 52,104 35,576 59` $ 5,116,606 $ 628,177 $ 689,835 $ 4,426,771 13` 5,116,606 628,177 689,835 4,426,771 13' $ 1,000 $ $ $ 1,000 0' 14,800 14,800 0 199,000 - 199,000 0' 214,800 $ - 214,800 0' 550,000 $ - $ - $ 550,000 0' 61,370 40,853 41,009 20,361 67 - - 481 (481) 0' O a d w W C ea C IL 21 t C O 2 N N O N 4) O v u 26 Packet Pg. 84 I 2.4.a I Page 4 of 6 C ITY O F IDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 95,832 $ 977,510 $ 804,535 $ (708,703) 840' 2 INTERFUND SUBSIDIES 63,000 - 62,656 344 99' 3 CONSTRUCTION PROJECTS 7,807,188 167,965 4,032,650 3,774,538 52' 4 INTEREST - - 26,059 (26,059) 0' 5 DEBT ISSUE COSTS 98,398 - - 98,398 0' $ 8,064,418 $ 1,145,475 $ 4,925,900 $ 3,138,518 61' WATER FUND (421) 6 SALARIES AND WAGES 7 OVERTIME 8 BENEFIT S 9 UNIFORMS 10 SUPPLIES 11 WATER PURCHASED FOR RESALE 12 SUPPLIES PURCHASED FOR INVENTORY/RESALE 13 SMALL EQUIPMENT 14 PROFESSIONAL SERVICES 15 COMMUNICATIONS 16 TRAVEL 17 EXCISE TAXES 18 RENTAL/LEASE 19 INSURANCE 20 UTILITIES 21 REPAIRS& MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 MACHINERY/EQUIPMENT 25 CONSTRUCTION PROJECTS 26 GENERAL OBLIGATION BONDS 27 REVENUE BONDS 28 INTERGOVERNMENTAL LOANS 29 INTEREST 30 OTHER INTEREST & DEBT SERVICE COSTS STORM FUND (422) 31 SALARIES AND WAGES 32 OVERTIME 33 BENEFIT S 34 UNIFORMS 35 SUPPLIES 36 SMALL EQUIPMENT 37 PROFESSIONAL SERVICES 38 COMMUNICATIONS 39 TRAVEL 40 EXCISE TAXES 41 RENTAL/LEASE 42 INSURANCE 43 UTILITES 44 REPAIR & MAINTENANCE 45 MISCELLANEOUS 46 INTERFUND SUBSIDIES 47 CONSTRUCTION PROJECTS 48 GENERAL OBLIGATION BONDS 49 REVENUE BONDS 50 INTERGOVERNMENTAL LOANS 51 INTEREST 52 OTHER INTEREST & DEBT SERVICE COSTS $ 842,096 $ 543,376 $ 619,075 $ 223,021 74' 24,000 17,629 13,628 10,372 57' 330,100 233,498 265,084 65,016 80, 4,000 3,437 3,345 655 84' 150,000 101,474 114,924 35,076 77' 2,170,000 1,550,689 1,655,358 514,642 76' 170,000 161,736 136,806 33,194 80, 11,000 4,437 3,796 7,204 35' 2,237,439 1,068,508 765,711 1,471,728 34' 30,000 24,165 26,602 3,398 89, 200 - - 200 0' 1,649,700 1,210,843 1,184,793 464,907 72' 153,740 104,674 125,117 28,623 81' 122,359 98,196 122,359 (0) 100' 35,000 23,347 25,353 9,647 72' 176,130 158,267 24,249 151,881 14' 123,600 144,739 158,096 (34,496) 128' 645,370 198,136 194,533 450,837 30' 10,000 - 10,044 (44) 100' 1,998,334 1,321,534 87,212 1,911,122 4' 2,870 - - 2,870 0' 399,780 - - 399,780 0' 25,840 25,839 25,839 1 100, 180,580 98,336 104,805 75,775 58' - - 868 (868) 0' $ 11,492,138 $ 7,092,861 $ 5,667,596 $ 5,824,542 49' $ 734,284 $ 560,388 $ 628,363 $ 105,921 86' 26,000 22,040 11,044 14,956 42' 294,767 239,977 262,722 32,045 89' 6,500 5,049 6,040 460 93' 46,000 28,503 42,227 3,773 92' 4,000 304 985 3,015 25' 3,481,263 1,296,882 2,796,760 684,503 80, 3,200 4,720 4,895 (1,695) 153' 4,300 510 1,982 2,318 46' 470,100 529,154 584,110 (114,010) 124' 267,847 219,645 218,877 48,970 82' 82,335 66,228 82,335 (0) 100' 10,500 10,536 11,579 (1,079) 110, 67,130 80,978 13,456 53,674 20' 232,300 206,854 192,675 39,625 83' 297,787 76,327 75,745 222,042 25' 3,137,333 129,168 282,979 2,854,354 9' 104,540 - - 104,540 0' 195,390 - - 195,390 0' 53,590 53,576 61,590 (8,000) 115' 101,180 58,672 61,859 39,321 61' - - 383 (383) 0' $ 9,620,346 $ 3,589,509 $ 5,340,606 $ 4,279,740 56' O a d OC 2 0 c eo C M t r� C O 2 N N O N 4) O v u 27 Packet Pg. 85 I 2.4.a I Page 5 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,090,461 $ 1,459,402 $ 1,510,216 $ 580,245 72' 2 OVERTIME 95,000 110,436 104,413 (9,413) 110' 3 BENEFITS 847,408 632,926 603,878 243,530 71' 4 UNIFORMS 9,500 8,516 9,351 149 98, 5 SUPPLIES 421,000 300,813 237,986 183,014 57' 6 FUEL CONSUMED 60,000 55,215 - 60,000 0' 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 0' 8 SMALL EQUIPMENT 35,000 181,454 115,019 (80,019) 329' 9 PROFESSIONAL SERVICES 2,468,859 3,862,193 1,983,724 485,135 80, 10 COMMUNICATIONS 43,000 35,322 37,377 5,623 87' 11 TRAVEL 5,000 3,825 495 4,505 10, 12 EXCISE TAXES 978,000 926,107 907,781 70,219 93' 13 RENTAL/LEASE 319,732 356,858 264,247 55,485 83' 14INSURANCE 227,407 162,851 203,936 23,471 90' 15 UTILITIES 1,532,060 1,174,315 2,100,718 (568,658) 137' 16 REPAIR & MAINTENANCE 1,685,589 432,059 742,190 943,399 44' 17 MISCELLANEOUS 126,350 100,217 202,277 (75,927) 160' 19 INTERFUND SUBSIDIES 6,687,739 3,804,155 1,175,403 5,512,336 18, 18 MACHINERY/EQUIPMENT - - 68,126 (68,126) 0` 20 CONSTRUCTION PROJECTS 12,956,488 7,939,825 1,989,039 10,967,449 15' 21 GENERAL OBLIGATION BONDS 126,500 - - 126,500 0` 22 REVENUE BONDS 89,840 - - 89,840 0' 23 INTERGOVERNMENTAL LOANS 174,610 173,888 174,591 19 100' 24 INTEREST 356,980 202,153 182,515 174,465 51' 25 DEBT ISSUE COSTS - 1,518 - - 0' 26 OTHER INTEREST & DEBT SERVICE COSTS - 4,430 5,657 (5,657) 0` $ 31,340,523 $ 21,928,479 $ 12,618,940 $ 18,721,583 40' BOND RESERVEFUND (424) 27 REVENUE BONDS $ 810,010 $ - $ - $ 810,010 01 28INTEREST 1,178,700 600,417 589,342 589,358 50' $ 1,988,710 $ 600,417 $ 589,342 $ 1,399,368 30' O a d 2 0 a eo C M t C O 2 N N O N L d O r t) 28 Packet Pg. 86 2.4.a Page 6 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent EQUIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 275,712 $ 228,154 $ 226,611 $ 49,101 82 2 OVERTIME 2,000 2,267 2,598 (598) 130' 3 BENEFITS 112,077 93,442 80,046 32,031 71' 4 UNIFORMS 1,500 1,182 1,006 494 67' 5 SUPPLIES 120,000 60,087 75,991 44,009 63' 6 FUEL CONSUMED 1,000 - - 1,000 0' 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 383,000 131,486 309,121 73,879 81, 8 SMALL EQUIPMENT 58,000 6,022 3,264 54,736 61 9 PROFESSIONAL SERVICES 46,750 1,121 1,208 45,542 3' 10 COMMUNICATIONS 3,000 1,833 1,771 1,229 59' 11 TRAVEL 1,000 - - 1,000 0' 12 RENTAL/LEASE 11,160 10,221 8,676 2,484 78' 13 INSURANCE 49,172 39,334 51,903 (2,731) 106' 14 UTILITIES 14,000 12,495 14,762 (762) 105' 15 REPAIRS& MAINTENANCE 60,000 39,991 65,270 (5,270) 109, 16 MISCELLANEOUS 12,000 10,384 7,150 4,850 60' 17 MACHINERY/EQUIPMENT 915,000 416,505 290,501 624,499 32' $ 2,065,371 $ 1,054,526 $ 1,139,877 $ 925,494 55' TEC HNO LO GY RENTAL FUND (512) 18 SALARIES AND WAGES $ 442,074 $ 289,578 $ 280,464 $ 161,610 63 19 OVERTIME 2,000 2,481 1,286 714 64' 20 BENEFITS 159,538 88,422 105,394 54,144 661 21 SUPPLIES 5,000 4,227 6,110 (1,110) 122' 22 SMALL EQUIPMENT 357,900 34,872 59,900 298,000 17' 23 PROFESSIONAL SERVICES 61,860 32,719 32,054 29,806 52 24 COMMUNICATIONS 58,770 57,403 55,392 3,378 94' 25 TRAVEL 1,500 - 296 1,204 20' 26 RENTAL/LEASE 7,460 6,448 3,717 3,743 50' 27 REPAIRS& MAINTENANCE 767,220 424,699 417,117 350,103 54 28 MISCELLANEOUS 5,000 4,000 3,583 1,417 72' 29 MACHINERY/EQUIPMENT 61,000 - 251,887 (190,887) 4131 $ 1,929,322 $ 944,850 $ 1,217,201 $ 712,121 63' FIREMAN'S PENSION FUND (617) 30 BENEFITS $ - $ 18,528 $ - $ - 0' 31 PENSION AND DISABILITY PAYMENTS 53,886 01 32 PROFESSIONAL SERVICES 11,500 0' $ - $ 83,914 $ - $ 0' TOTAL EXPENDITURE ALL FUNDS $ 149,531,215 $ 77,271,007 $ 79,101,758 $ 70,429,457 53' O a d 2 C ea C IL t r� C O 2 N N O N L N O v 29 Packet Pg. 87 2.4.a Page 1 of 1 C ITY O F IDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2022 Amended 10/31/2021 10/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 $ 498,826 $ 273,284 $ 278,846 $ 219,980 56% 444,165 276,714 297,281 146,884 67% 825,252 554,503 760,678 64,574 92% 1,368,838 955,506 1,009,961 358,877 74% - 475,376 - - 0% G Q. 2,241,107 1,115,329 1,768,741 472,366 79% lY 971,780 702,190 788,707 183,073 81% 15,574,457 9,614,308 11,393,678 4,180,779 73% 13,381,696 9,394,444 10,432,886 2,948,810 78% IL 166,576 - 72,086 94,490 43% 777,359 473,861 518,930 258,429 67% r� C 2 4,023,619 2,430,629 3,009,709 1,013,910 75% N N 459,109 66,376 126,868 332,241 28% N 5,272,499 3,577,972 3,830,200 1,442,299 73% N 3,464,031 2,617,311 2,558,833 905,198 74% V 3,450,275 2,031,188 1,910,071 1,540,204 55% O $ 52,919,589 $ 34,558,991 $ 38,757,475 $ 14,162,114 73% V_ O CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY title 2022 Amended Budget 10/31/2021 Expenditures 10/31/2022 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 11,492,138 $ 7,092,861 $ 5,667,596 $ 5,824,542 49% STORM UTILITY FUND 9,620,346 3,589,509 5,340,606 4,279,740 56% SEWER/WWTP UTILITY FUND 31,340,523 21,928,479 12,618,940 18,721,583 40% BOND RESERVE FUND 1,988,710 600,417 589,342 1,399,368 30% $ 54,441,717 $ 33,211,267 $ 24,216,483 $ 30,225,234 44% 30 Packet Pg. 88 I 2.4.a I Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAH, Title 2022 Amended Budget 10/31/2021 Expenditures 10/31/2022 Expenditures Amount Remaining %Spent CPIY COUNCIL SALARIES AND WAGES $ 204,132 $ 166,568 $ 156,583 $ 47,550 77% BENEFITS 121,868 86,404 77,754 44,114 64% SUPPLIES 2,000 1,808 2,071 (71) 104% SERVICES 170,826 18,504 42,438 128,388 25% $ 498,826 $ 273,284 $ 278,846 $ 219,980 56% O FFIC E O F MAYO R SALARIES AND WAGES $ 232,296 $ 191,549 $ 207,124 $ 25,172 89% BENEFITS 81,787 68,365 71,118 10,669 87% SUPPLIES 1,500 358 1,765 (265) 118% Q. SERVICES 128,582 16,441 17,275 111,307 13% d $ 444,165 $ 276,714 $ 297,281 $ 146,884 67% HUMAN RESOURCES <a SALARIES AND WAGES $ 398,299 $ 299,623 $ 399,039 $ (740) 100% r- BENEFITS 142,526 112,209 132,135 10,391 93% C SUPPLIES 13,600 1,271 1,268 12,332 9% LL SERVICES 270,827 141,400 228,235 42,592 84% $ 825,252 $ 554,503 $ 760,678 $ 64,574 92% +�+ MUNICIPAL C O URT 0 O SALARIES AND WAGES $ 910,606 $ 570,551 $ 645,909 $ 264,697 71% 2 BENEFITS 217,654 185,719 202,090 15,564 93% N SUPPLIES 11,600 5,774 7,763 3,837 67% N SERVICES 228,978 193,462 154,200 74,778 67% i $ 1,368,838 $ 955,506 $ 1,009,961 $ 358,877 74% C ITY CLERK v SALARIES AND WAGES $ $ 218,427 $ $ 0% Q BENEFITS 88,098 0%, SUPPLIES - 3,115 - 0% O SERVICES - 165,736 - 0% 4) $ - $ 475,376 $ - $ - 0% w ADMINIS TRATIVE S ERVIC ES 2 SALARIES AND WAGES $ 1,301,073 $ 763,215 $ 1,080,698 $ 220,375 83% C BENEFITS 413,858 241,405 337,212 76,646 81% C SUPPLIES 13,000 4,608 8,882 4,118 68% LL SERVICES 513,176 106,102 341,948 171,228 67% >+ $ 2,241,107 $ 1,115,329 $ 1,768,741 $ 472,366 79% r C ITY ATTO RNEY 0 O SERVICES $ 971,780 $ 702,190 $ 788,707 $ 183,073 81% E $ 971,780 $ 702,190 $ 788,707 $ 183,073 81% N NON -DEPARTMENTAL G N SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% BENEFITS 145,504 26,878 102,592 42,912 71% SUPPLIES 5,000 4,447 - 5,000 0% -0w SERVICES 13,557,955 9,237,951 10,626,081 2,931,874 78% 0 O INTERFUND SUBSIDIES 1,435,000 284,945 592,500 842,500 41% DEBT SERVICE - PRINCIPAL 55,170 - - 55,170 0% r- DEBT SERVICE - INTEREST 274,078 60,087 72,505 201,573 26% E $ 15,574,457 $ 9,614,308 $ 11,393,678 $ 4,180,779 73% V POLICE SERVICES SALARIES AND WAGES $ 8,723,512 $ 6,251,307 $ 6,683,170 $ 2,040,342 77% Q BENEFITS 2,994,876 2,204,846 2,340,647 654,229 78% SUPPLIES 281,569 195,063 228,908 52,661 81% SERVICES 1,381,739 743,228 1,052,207 329,532 76% MACHINERY/EQUIPMENT 127,953 (127,953) 0% $ 13,381,696 $ 9,394,444 $ 10,432,886 $ 2,948,810 78% S ATELLITE O FFIC E SALARIES AND WAGES $ 25,000 $ - $ 7,246 $ 17,754 29% BENEFITS 5,000 1,375 3,625 27% SUPPLIES 12,000 11,057 943 92% SERVICES 124,576 52,409 72,167 42% $ 166,576 $ $ 72,086 $ 94,490 43% 31 Packet Pg. 89 Page 2 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2022 Amended 10/31/2021 10/31/2022 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY SERVICES/ECON DEV. SALARIES AND WAGES $ 365,627 $ 249,449 $ 234,619 $ 131,008 64% BENEFITS 111,361 75,001 68,858 42,503 62% SUPPLIES 4,075 999 561 3,514 14% SERVICES 296,296 148,413 214,892 81,404 73% $ 777,359 $ 473,861 $ 518,930 $ 258,429 67% DEVELO PMEVT S ERVIC ES /PLANNING SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES MACHINERY/EQUIPMENT HUMAN SERVICES PROGRAM SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES MACHINERY/EQUIPMENT PARKS & REC REATIO N SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES PUBLIC WORKS ADMINIS TRATIO N SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES FACILITIES MAINTENANCE SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES MACHINERY/EQUIPMENT ENGINEERING SALARIES AND WAGES BENEFIT S SUPPLIES SERVICES TOTAL GENERAL FUND EXPENDITURES $ 1,978,832 $ 1,505,736 $ 1,701,066 $ 277,766 86% 681,706 522,585 584,157 97,549 86% 23,400 10,471 8,631 14,769 37% 1,339,681 391,837 715,855 623,826 53% 0% $ 4,023,619 $ 2,430,629 $ 3,009,709 $ 1,013,910 75% $ 101,496 $ 35,803 $ 61,619 $ 39,877 61% 29,113 7,800 17,406 11,707 60% 15,000 13,751 2,434 12,566 16% 313,500 9,023 39,801 273,699 13% - - 5,608 (5,608) 0% $ 459,109 66,376 126,868 332,241 28°/u $ 2,639,863 $ 1,917,731 $ 2,009,685 $ 630,178 76% 865,945 674,961 687,522 178,423 79% 166,640 155,388 208,376 (41,736) 125% 1,600,051 829,892 924,616 675,435 58% $ 5,272,499 $ 3,577,972 $ 3,830,200 $ 1,442,299 73% $ 387,424 $ 251,431 $ 123,065 $ 264,359 32% 126,689 86,014 61,199 65,490 48% 9,600 8,061 3,680 5,920 38% 93,215 74,064 69,179 24,036 74% $ 616,928 $ 419,569 $ 257,124 $ 359,804 42% 860,456 665,744 728,982 131,474 85% 369,679 280,904 294,604 75,075 80% 128,000 163,756 69,364 58,636 54% 1,821,960 920,784 736,005 1,085,955 40% 270,180 - 81,116 189,064 30% $ 3,450,275 $ 2,031,188 $ 1,910,071 $ 1,540,204 55% $ 1,866,128 $ 1,456,545 $ 1,546,189 $ 319,939 83% 702,578 571,738 567,550 135,028 81% 2,200 1,937 896 1,304 41% 276,197 167,521 187,075 89,122 68% $ 2,847,103 $ 2,197,742 $ 2,301,709 $ 545,394 81% $ 52,919,589 $ 34,558,991 $ 38,757,475 $ 14,162,114 73% O Q. d to c to C IL 21 t r� C O 2 N N 0 N L d O r t� u 32 Packet Pg. 90 2.4.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 10/31 /2022 10/31 /2022 Q3 YTD Fund Balance Cash Balance 001-General Fund * $ 10,543,921 $ 3,187,451 $ (2,606,425) $ (5,371,398 009-Leoff-Medical Ins. Reserve 161,588 161,587 (62,604) (93,631 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 016-Building Maintenance 4,424,061 4,424,061 16,647 24,061 E 017 - Marsh Restoration & Preservation 849,767 849,766 1,150 1,150 >, 018 - Edmonds Homelessness Response Fd 200,000 200,000 - 200,000 Total General Fund & Subfunds Is 18,002,908 $ 10,646,437 $ (2,651,232) $ (5,239,817 N N O N *$8,067,160 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012, represent the required 20% operating reserve. o U 0 There are no interfund loans outstanding at this time. V_ 0 Q. m U GOVERNMENTAL FUNDS OVERVIEW c E LL 21 0 2 BALANCES CHANGE IN FUND BALANCES N c N ---- ACTUAL ---- ---- ACTUAL ---- GOVERNMENTAL FUNDS 10/31 /2022 10/31 /2022 Q3 YTD 0 Fund Balance Cash Balance 0 O :.; General Fund & Subfunds $ 18,002,908 $ 10,646,437 $ (2,651,232) $ (5,239,817 E Special Revenue 17,168,412 25,047,808 (6,755,910) 3,517,182 Capital Projects 954,855 1,616,781 (143,059) (3,159,008 Q Total Governmental Funds $ 36,126,175 $ 37,311,027 $ (9,550,201) $ (4,881,643 *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. 91 2.4.a SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 10/31/2022 10/31/2022 Q3 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 70,209 $ 70,709 $ (6,014) $ (4,966 .-. 111 - Street Fund 524,665 394,995 (160,156) (426,500 0 112- Combined Street Const/Improve 2,434,088 440,392 (1,492,512) 195,641 Q- m 117 - Municipal Arts Acquis. Fund 687,455 691,677 (27,579) 38,576 120 - Hotel/Motel Tax Revenue Fund 112,773 99,536 15,440 41,659 121 - Employee Parking Permit Fund 90,060 90,454 879 13,536 122 - Youth Scholarship Fund 15,256 15,329 794 997 .E 123-Tourism Promotional Fund/Arts 121,959 117,892 7,984 25,987 >, 125 - Real Estate Tax 2 3,579,335 3,784,038 (416,819) (474,080 126 - Real Estate Excise Tax 1 * 4,201,238 4,151,350 (58,054) 887,900 0 127 - Gifts Catalog Fund 3,202,551 3,204,134 11,483 2,901,027 2 130 - Cemetery Maintenance/Improvement 284,854 286,263 9,494 18,649 cN� 136 - Parks Trust Fund 168,914 169,781 500 324 N 137 - Cemetery Maintenance Trust Fund 1,145,220 1,150,918 11,635 38,145 w 138 - Sister City Commission 18,205 18,284 70 2,724 r 140 -Business Improvement Disrict 62,886 62,886 7,436 33,755 OU 141 - Affordable and Supportive Housing I'd 217,453 210,060 25,092 58,039 142 - Edmonds Rescue Plan Fund (5,127) 9,852,693 (4,900,630) (50,015 t 143 - Tree Fund 1 236,416 236,416 1 215,048 215,784 m Total Special Revenue $ 17,168,412 $ 25,047,808 1 $ (6,755,910) $ 3,517,182 *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $700,000 for 'u the purchase of Open Space. ii ENTERPRISE FUNDS OVERVIEW O 2 N N O N BALANCES CHANGE IN FUND BALANCES ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- FUNDS 10/31/2022 10/31/2022 Q3 YTD O Fund Balance Cash Balance a� 421 -Water Utility Fund $ 32,053,756 $ 9,646,679 $ 1,250,348 $ 3,326,588 422 - Storm Utility Fund * 15,970,025 5,842,992 (197,378) 322,648 Q 423 - Sewer/WWTP Utility Fund 62,910,905 18,182,693 1,509,063 2,558,376 424 - Bond Reserve Fund 850,287 850,287 3,200 6,326 411 -Combined Utility Operation 133,095 163,265 41,145 133,095 Total Enterprise Funds $ 111,918,068 $ 34,685,915 $ 2,606,377 $ 6,347,033 *$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. 92 2.4.a SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 10/31/2022 10/31/2022 Q3 YTD Fund Balance Cash Balance Governmental Funds $ 36,126,175 $ 37,311,027 $ (9,550,201) $ (4,881,643 Enterprise Funds 111,918,068 34,685,915 2,606,377 6,347,033 0 a Internal Services Fund 10,575,124 6,174,447 251,050 287,572 Total City-wide Total $ 158,619,366 $ 78,171,389 $ (6,692,774) $ 1,752,962 Ta c c ii 21 INTERNAL SERVICE FUNDS OVERVIEW 0 2 N N O N L r V BALANCES CHANGE IN FUND BALANCES S ---- ACTUAL ---- ---- ACTUAL ---- 0 Q. INTERNAL SERVICE FUNDS 10/31/2022 10/31/2022 Q3 YTD Fund Balance Cash Balance U c 511 - Equipment Rental Fund $ 9,618,985 $ 5,392,102 $ 246,661 $ 410,474 ii 512 -Technology Rental Fund 956,138 782,346 4,389 (122,903 >+ t Total Internal Service Funds $ 10,575,124 $ 6,174,447 $ 251,050 $ 287,572 0 N N O N L d O E ci 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. 93 2.5 City Council Agenda Item Meeting Date: 12/12/2022 Administrative 2023 Budget Items from Council Staff Lead: Council Department: City Council Preparer: Beckie Peterson Background/History While reviewing the 2023 Proposed Budget, individual Councilmembers made suggestions or requested changes more adminstrative in nature (documentation, organization of cost centers) that did not involve changes to budget in actual dollar amounts. It was agreed by Council and Director Turley to discuss these suggested items outside of the budget deliberation process. Recommendation Discuss and determine appropriate next steps. Narrative N/A Attachments: Administrative CM Items regarding Budget 2023 Packet Pg. 94 2.5.a DP# or NEW Submitted By Description Responsible Department Discussion of Next Steps 16 Buckshnis Establish Neighborhood City Hall Separate Cost Center Admin 18 and 19 Buckshnis Policy re: short term rentals Planning & Dev 28 Buckshnis Provide atty review of funds Parks 34,35,36,3' Buckshnis Include Carryforward Water Fund 40 Buckshnis Review carryforward from 2022 DP59, is project complete? Storm 54,55,57,51 Buckshnis Review by council, determine if 2022 DP67 of $1,753,156 was spent WWTP Q �.v��srnri� Patrnl . Pnli.,.,') ..,�..Iyed/with d.-,wR 82 Buckshnis Create Taskforce to name, design and coordinate volunteers Parks n.a,--,.sh �ni- Quality Issues $190K ��e�-� TT� NEW Buckshnis Update reference to Edmonds Stream team Admin NEW Buckshnis Hearing Examiner - reassign to Attorney budget Admin n-iPvr R' Gl(s RUS E Feselve.J /wirh.J rawY. fAF4Ag+d Fd� NEW Buckshnis Waterfront Issues Study and Equity Gap Analysis - brought to Council NEW Buckshnis/Chen Display Fire Services info as part of budget Admin NEW Buckshnis Contingency Reserve Fund pg 66/pg 15 Calculation? Admin Q1 Amendment NEW Buckshnis/Teitzel Employee Parking Permit name of Fund PW Change to Ordinance Required > PW Commit NEW Buckshnis Footnote for transfer of ARPA to General Fund Admin E 0 L E a� a� m M N O N d r L E a M N O N d Ol m c =a L d L E a� U m r �a L .E E Q w c 0 E t U R a Packet Pg. 95 2.5.a E a Packet Pg. 96