The URL can be used to link to this page

2021-04-13 City Council - Full FIN Agenda-28321 o Agenda Edmonds City Council FINANCE COMMITTEE VIRTUAL ONLINE MEETING EDMONDS CITY COUNCIL MEETINGS WEB PAGE, HTTP://EDMONDSWA.IQM2.COM/CITIZENS/DEFAULT.ASPX, EDMONDS, WA 98020 APRIL 13, 2021, 6:00 PM DUE TO THE CORONAVIRUS, MEETINGS ARE HELD VIRTUALLY USING THE ZOOM MEETING PLATFORM. TO VIEW OR LISTEN TO THE COMMITTEE MEETING IN ITS ENTIRETY, PASTE THE FOLLOWING INTO A WEB BROWSER USING A COMPUTER OR SMART PHONE: HTTPS://ZOOM. US/J/95798484261 OR JOIN BY DIAL -UP PHONE: US: +1 253 215 8782 WEBINAR ID: 957 9848 4261 COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. CALL TO ORDER COMMITTEE BUSINESS 1. Civic Park - Project Construction Contracts (20 min) 2. February 2021 Monthly Financial Report (10 min) 3. 2021 April Budget Amendment (15 min) 4. PFD Financial Presentation (15 min) ADJOURN Edmonds City Council Agenda April 13, 2021 Page 1 2.1 City Council Agenda Item Meeting Date: 04/13/2021 Civic Park - Project Construction Contracts Staff Lead: Angie Feser Department: Parks, Recreation & Cultural Services Preparer: Angie Feser Background/History The Civic Center Playfield project is currently in the bidding process. Due to timing issues of the actual bid opening, this packet does not have the construction contract dollar amount, however, it provides an opportunity for a project update in preparation for council's consideration of the project in the next few weeks. The lowest responsible bidder, contract amount and alternatives is scheduled to be presented for the April 20, 2021 Regular Council meeting for review and discussion with potential Council approval on April 27, 2021. To implement the construction of Civic Center Playfield, there are three Professional Service Agreements which require approval by the Council authorizing the Mayor to execute. They include - 1. Project Construction: TBD (Bid Opening April 8, 2021) 2. Construction Inspection: KBA for $613,251 3. Construction Administration Consultant: Walker Macy for $97,473 Project Construction This contract encompasses the entire construction of the Civic Park project including demolition, site preparation and installation of all components of the park project as designed and permitted. If approved, the project is slated to begin early June with a preliminary estimate of 18 months to complete finishing in fall of 2022. Bids, scheduled for opening for the afternoon of April 8th had not been opened or verified at the time of this writing, but what bid information available will be shared verbally during the April 13th council committee meetings. Construction Inspection Without in-house capabilities as an Owner, inspect services are contracted out including preconstruction photos, material records, testing logs, submittal logs, RFI logs, change order logs, weekly statement of working days, certified payroll tracking, apprenticeship utilization reports, record drawing comments, inspector daily reports, project photos, field note records and force account reports and the firm KBA was selected and requires $631,251 to complete these services. Construction Administration Consultant This contract is an amendment to an existing contract for the additional sum of $91,473. This fee is basically to cover the added work to re -bid, complete additional soil testing and develop required stormwater mitigation. Services provided include during construction review product submittals and shop drawings, respond to contractor requests for information, and produce clarification drawings as needed. Attend of weekly project meetings, conduct Construction Observation site walks, and prepare Packet Pg. 2 2.1 field reports. Upon completion of construction, services include a substantial completion walk-through, punch list, and attendance of a final acceptance walk-through to review completion of the punch list Staff Recommendation Project update only, no recommendation for this agenda item. A full presentation with budget details and contracts is scheduled for review and approval consideration during April 20 and 27, 2021 Regular Council Meetings. Narrative The 8-acre Civic Center Playfield property was acquired by the City from the Edmonds School District in early 2016. With the consulting firm of Walker Macy, a Master Plan using a robust public process was adopted a year later in March of 2017. Shortly thereafter, Walker Macy was approved by the Council to complete the design development, permitting, bidding, and then support during construction. Also in 2017, the Stadium Grandstands were demolished. In 2018, the City began applying for grants and in November the Council adopted the Parks Capital Improvement (CIP) and Capital Facilities (CFP) Plans identifying Civic Park as a project. Historically, this project has been supported by the Council for years as witnessed by the repeated annual approval funding allocation specifically for this potential park within the CIP and CFP. During 2019, the Council had updates of the design progression (April) and funding efforts (June) and the $3.7m bond issuance was approved in October. During the annual budget adoption, Council again, approved the Civic Park project in the CIP and CIP Plans with construction scheduled to being in 2020. The project went to bid early 2020, but only two bids were submitted with the lowest one exceeding the $8.6m cost estimate by $2.7m. An analysis of unsuccessful bid process was completed with findings incorporated into this re -bid including additional soil testing and revising the bid format from State of Washington Department of Transportation (WSDOT) to lump sum, which is more traditionally used for park construction projects. Project Funding The following illustrates the general revenue sources and amounts to provide context of the project. The upcoming full council presentations will include this information in addition to comparative project expenditures which will be fully identified after verification of the April 8t" construction bids. Revenues 2021 2022 Total Grants $ 806,000 $ 2,664,000 $ 3,470,000 General Fund $ 89,833 $ 1,763,167 $ 1,853,000* Bonds $ 3,700,000 $ 3,700,000 Donations $ 400,000 $ 400,000** REET 2 (Fund 125) $ 652,546 $ 652,546 $ 1,305,092 REET 1 (Fund 126) $ 71,816 $ 71,816 Park Impact Fees $ 710,120 $ 642,500 $ 1,352,620 Packet Pg. 3 2.1 Totals $ 5,958,499 $ 6,194,029 $ 12,152,528 *Currently there is $2m allocated from the General Fund as authorized by the City Council, but the $1.85m was needed to cover expenses in this initial budget estimate **Edmonds Rotary has committed to contributing $250,000 and an additional $55,000 through the city's bench/picnic table donor program Attachments: Civic Center Playfield Project Summary Graphic Packet Pg. 4 2.1.a PROJECT OVERVIEW Project Description In the fall of 2015, after leasing the property for 40 years, Civic Center Playfield was acquired by the City of Edmonds from the Edmonds School District. Purchased with the assistance of grants from the Washington State Recreation Conservation Office and the Snohomish County Conservation Futures Program, the City's Recreation & Open Space Plan stipulates that the site will remain accessible to the community as a key asset, providing both passive and active recreation. The City has been operating the property as a park since 1975, with little change to the layout since its former use by Edmonds High School. The city has not invested capital funds into this site but has been maintaining it for public use. Just under 8 acres, the park is positioned near Edmonds downtown commercial area alongside single and multi -family housing. The project goal is to provide the City of Edmonds with a Master Plan based on community input that envisions Civic Center Playfield as a a signature park in the heart of downtown Edmonds. Civic Center Playfield has the potential to energize the local economy, contribute to the 0 sense of community identity and civic pride, and bolster the city's growing reputation as a destination on Puget Sound. By improving this .o public space in the heart of Edmonds, the community can create an exceptional place for gathering, celebration and enhanced daily life. a- -0 d :- History L d Civic Center Playfield was the athletic grounds for Edmonds High School, originally built a block from the site at 410 Fourth Avenue North, ci what is now the Edmonds Center for the Arts. Prior to recreational development it's believed to have been a marshy field. In 1957 the high .2 school relocated to the Holmes Corner neighborhood at 76th and 212th. The City has operated the property as a park since 1975 with minimal change to its amenities or use. 2 1930's - courtesy of the Sno-Isle Musem 1950's 2015 - Google Earth Edmonds Civic Center Playfield Master Plan January 2021 Edmonds Parks, Recreation, & Cultural Services WALKERI- - - - Packet Pg. 5 2.1.a Civic Field Today Today, the approximately 8 acre site includes a playground, basketball and tennis courts, football field, soccer fields, track, skate park, petanque courts, portable restrooms, and the Boys and Girls Club (former high school Field House). Civic Center Playfield is currently used for community sports, team practices and games by local youth organizations, nearby residents, and recreation programs, as well as for events such as the 4th of July, Taste of Edmonds, Edmonds Arts Festival parking and the Wenatchee Youth Circus (likely concluding this year). w\V 6"' Structures The Field House, most likely built after 1935 when the district acquired the property, was remodeled in 1999 and is currently leased to the Edmonds Boys and Girls Club. The former Grand Stand, was over 50 years old and was not structurally sound when it was removed in 2018. The Edmonds Boys & Girls Club has been leasing the Field House since 1962. It is currently operating at full capacity, serving approximately 150 kids. Activities offered at the Boys & Girls Club include arts and crafts, computer use, homework help, volleyball and basketball, arts and music, snacks and meals. The building presently hosts typical Club facilities - ground floor offices, a small game/recreation room, computer lab area, restrooms, storage and service spaces. The upper floor, includes a gym and additional storage. The Boys & Girls Club is in conversation with the Parks Department and City to discuss the needs and plans of the organization. The Field House would likely require expansion if it is to continue to serve the Club. Special Considerations The planning effort considered the full site with special consideration for six of the eight acres that fall under Conservation Easement Deed restrictions as follows: -No parking • Must be preserved as open space (i.e. either passive or active recreation) -Maximum 10% impervious cover (not including pathways) -No synthetic turf -No new playfields, existing fields can remain if desired -Temporary festival use can be accommodated The two acres that include the Field House footprint are exempt from the deed restrictions. Funding Funding for the project includes: $3,400,000 secured grants (Federal, State and Local) $3,700,000 bonds $250,000 park donations $5,250,000 combination of restricted and general city funds c.i �a r c 0 U c 0 r U 0 0 U m 0 L IL IL U U Edmonds Civic Center Playfield Master Plan January 2021 Edmonds Parks, Recreation, & Cultural Services WALKER Tq ` --- Packet Pg. 6 DESIGN Hazel Miller Meadows •A mix of flowers that attract pollinators • Picnic tables and shade • Sloped lawn Petanque Grove • Crushed Granite Playing Surface • Accommodates up to 16 courts for tournaments • Heavily planted area with shade and seating SK6M SrRLIC1 RE5TRQ(.WS f Design The goal is to build a park as similar to these designs as possible. However, final features and installation phases are contingent upon construction bids and pricing. a — CU Enhanced Skate Park N c O r v 7 L O U r m 0 L Q_ tnirance vavinon and Permanent Restrooms _ Inclusive Playground Accessible play for all abilities. W f f 1� } -0 a- L d U U Y fC 64 _ V a of E Edmonds Civic Center Playfield Master Plan January 2021 Edmonds Parks, Recreation, & Cultural Services WALKERI- - - -- - Packet Pg. 7 2.2 City Council Agenda Item Meeting Date: 04/13/2021 February 2021 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Review and move to full council on consent. Narrative February 2021 Monthly Financial Report Attachments: February 2021 Monthly Financial Report Packet Pg. 8 I 2.2.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT FEBRUARY 2021 Packet Pg. 9 1 I 2.2.a I Page 1 of 1 C ITY OF EDMO NDS REVENUES BY FUND - SUMMARY Fund 2021 Adopted 2/28/2020 2/28/2021 Amount No. Title Budget Revenues Revenues Remaining %Receive 001 GENERAL FUND $ 42,450,777 $ 4,730,574 $ 5,089,278 $ 37,361,499 12 009 LEOFF-MEDICAL INS. RESERVE 300,000 - - 300,000 0 012 CONTINGENCY RESERVE FUND 2,620 - 2,620 0 014 HISTORIC PRESERVATION GIFT FUND 5,010 - 5,010 0 104 DRUG ENFORCEMENT FUND 165,370 1,193 502 164,868 0 C Ill STREET FUND 1,722,360 276,931 227,570 1,494,791 13 O. � 112 COMBINED STREET CONS'T/IMPROVE 3,048,185 546,702 483,438 2,564,747 16 117 MUNICIPAL ARTS ACQUIS. FUND 165,060 2,749 4,749 160,311 3 = ca 118 MEMORIAL STREET TREE 270 86 137 133 51 u_ 120 HOTEL/MOTEL TAX REVENUE FUND 71,460 12,751 7,389 64,071 10 >+ z 121 EMPLOYEE PARKING PERMIT FUND 25,240 9,258 5,080 20,160 20 c O 122 YOUTH SCHOLARSHIP FUND 1,390 60 93 1,297 7 M 123 TOURISM PROMOTIONAL FUND/ARTS 24,000 4,425 2,846 21,154 12 r No 125 REAL ESTATE EXCISE TAX 2 1,282,050 259,661 479,346 802,704 37 N 126 REAL ESTATE EXCISE TAX 1 1,285,240 259,135 477,329 807,911 37 to O L 127 GIFTS CATALOG FUND 103,930 22,568 18,231 85,699 18 130 CEMETERY MAINTENANCE/IMPROVEMT 179,800 15,683 31,103 148,697 17 v 136 PARKS TRUST FUND 2,200 709 1,126 1,074 51 O O. 137 CEMETERY MAINTENANCE TRUST FD 29,220 6,201 10,675 18,545 37 0 138 SISTER CITY COMMISSION 10,120 44 70 10,050 1 to .v 140 BUSINESS IMPROVEMENT DISTRICT 79,239 33,446 34,450 44,789 43 O 141 AFFORDABLE AND SUPPORTIVE HOUSINGFUND 65,000 13,126 14,207 50,793 22 c LL 231 2012 LT GO DEBT SERVICE FUND 759,710 - - 759,710 0 t 332 PARKS CAPITAL CONSTRUCTION FUND 1,392,520 43,427 31,155 1,361,365 2 C 411 COMBINED UTILITY OPERATION - 21,495 120 (120) 0 421 WATER UTILITY FUND 10,299,357 1,467,908 1,556,152 8,743,205 15 r p 1 NC, 422 STORM UTILITY FUND 6,012,300 1,490,811 1,847,019 4,165,281 31 423 SEWER/WWTP UTILITY FUND 2 28,131,150 2,423,506 4,419,842 23,711,308 16 L 424 BOND RESERVE FUND 1,985,870 3 2 1,985,868 0 L�4) 511 EQUIPMENT RENTAL FUND 1,331,100 264,578 253,410 1,077,690 19 512 TECHNOLOGY RENTAL FUND 1,204,880 200,436 205,039 999,841 17 d E 617 FIREMEN'S PENSION FUND 67,270 624 - 67,270 0 v M $ 102,202,698 $ 12,108,089 $ 15,200,360 $ 87,002,338 15 Q 1 Difference primarily due to a Grant reimbursement in January 2021. 2 Differences primarily due to WWTP billings to their partners in January 2021. 1 Packet Pg. 10 1 2.2.a Page 1 of 1 CITY OF EDMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2021 Adopted 2/28/2020 2/28/2021 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 45,179,468 $ 7,564,087 $ 7,637,016 $ 37,542,452 17 009 LEOFF-MEDICAL INS. RESERVE 467,140 64,599 55,277 411,863 12 014 HISTORIC PRESERVATION GIFT FUND 5,900 - - 5,900 C 016 BUILDING MAINTENANCE FUND 210,222 - 210,222 C 018 EDMONDS HOMELESSNESS RESPONSE FUND 123,581 - 123,581 C , 019 EDMONDS OPIOID RESPONSE FUND 28,445 - 28,445 C p 0. 104 DRUG ENFORCEMENT FUND 45,800 - - 45,800 C III STREET FUND 2,172,530 456,086 434,795 1,737,735 2C �p 112 COMBINED STREET CONST/IMPROVE 2,781,828 48,740 35,024 2,746,804 1 _ ca 117 MUNICIPAL ARTS ACQUIS. FUND 236,880 7,615 6,141 230,739 3 LL 120 HOTEL/MOTEL TAX REVENUE FUND 87,150 4,232 7,278 79,872 8 121 EMPLOYEE PARKING PERMIT FUND 26,880 - - 26,880 C 122 YOUTH SCHOLARSHIP FUND 3,000 450 3,000 C 0 123 TOURISM PROMOTIONAL FUND/ARTS 29,900 468 - 29,900 C N 125 REAL ESTATE EXCISE TAX 2 1,428,736 23,320 11,457 1,417,279 1 N 126 REAL ESTATE EXCISE TAX 1 1,761,841 150,228 105,293 1,656,548 6 127 GIFTS CATALOG FUND 100,900 2,762 - 100,900 C 130 CEMETERY MAINTENANCE/IMPROVEMT 200,998 26,421 28,671 172,327 14LL 136 PARKS TRUST FUND 50,000 - - 50,000 C r- 137 CEMETERY MAINTENANCE TRUST FUND 25,000 - 25,000 C O 0. 138 SISTER CITY COMMISSION 11,900 11 - 11,900 O C 140 BUSINESS IMPROVEMENT DISTRICT 76,340 9,339 4,600 71,741 6 .� c� 231 2012 LT GO DEBT SERVICE FUND 759,700 - - 759,700 C C 332 PARKS CAPITAL CONSTRUCTION FUND 5,360,378 4,897 67,133 5,293,245 1 jL 421 WATER UTILITY FUND 10,578,596 932,365 792,707 9,785,889 7 z 422 STORM UTILITY FUND 6,847,783 1,105,234 582,617 6,265,166 r S a O 423 SEWER/WWTP UTILITY FUND 35,634,329 1,911,677 1,213,019 34,421,310 3 424 BOND RESERVE FUND 1,985,870 - - 1,985,870 r C 04 511 EQUIPMENT RENTAL FUND 1,292,815 190,490 194,816 1,097,999 15 512 TECHNOLOGY RENTAL FUND 1,251,409 291,582 168,294 1,083,115 13 617 FIREMEN'S PENSION FUND 96,167 17,598 16,682 79,485 1 N $ 118,861,486 $ 12,812,204 $ 11,360,819 $107,500,667 10 1L c d z c� to a z Packet Pg. 11 I 2.2.a I Page 1 of 3 Title TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMSPROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALES/USE TAX 3 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GASUTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWERUTILITYTAX 12 STORMWATER UTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABS TAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT -COMCAST 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-VERIZON/FRONTIER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OT R NON -BUS LIC/PERMIT S INTERGOVERNMENTAL: 32 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 33 TARGET ZERO TEAMS GRANT 34 HIGH VISIBILITY ENFORCEMENT 35 CORONAVIRUS RELIEF FUND 2 36 DOC FAC ROOFING 37 STATE GRANTS- BUDGET ONLY 38 PUD PRIVILEDGE TAX 39 ARCHIVES AND RECORDS MANAGEMENT 40 SCHOOL ZONE 41 CJ - POPULATION 42 TRIAL COURT IMPROVEMENT 43 CRIMINAL JUSTICE -SPECIAL PROGRAMS 44 MARIJUANA EXCISE TAX DISTRIBUTION 45 DUI - CITIES 46 LIQUOR EXCISE TAX 47 LIQUOR BOARD PROFITS 48 FIRST RESPONDERS FLEX FUND 49 DISCOVERY PROGRAMS TECHNOLOGY ACQ. C ITY O F IDMO NDS REVENUES - GENERAL FUND 2021 Adopted 2/28/2020 Budget Revenues 2/28/2021 Amount Revenues Remaining %Received $ 10,936,400 $ 68,387 $ 125,743 $ 10,810,657 1% 4,137,031 26,445 49,084 4,087,947 1% 500 (69) 1 499 0% 8,600,000 1,539,597 1,647,058 6,952,942 19% 7,600 1,289 904 6,696 12% 828,500 149,665 157,476 671,024 19% 1,710,000 371,370 367,328 1,342,672 21% 595,000 177,747 172,999 422,001 29% 364,000 60,734 59,636 304,364 16% 1,153,000 159,285 137,637 1,015,363 12% 894,600 145,697 148,232 746,368 17% 471,900 110,158 120,531 351,369 26% 722,000 134,827 128,053 593,948 18% 723,000 134,128 85,370 637,630 12% 55,200 18,305 23,251 31,949 42% 350 184 143 207 41% 295,900 74,377 75,813 220,087 26% 31,494,981 3,172,124 3,299,257 28,195,724 10% 250 115 100 150 40% 700 70 - 700 0% 50,000 309 5,764 44,236 12% 702,700 173,761 170,449 532,251 24% 41,000 6,835 6,441 34,559 16% 100,600 20,174 15,635 84,965 16% 434,000 79,538 80,860 353,140 19% 201,000 50,146 41,146 159,854 20% 58,700 10,780 13,845 44,855 24% 30,000 - 14,440 15,560 48% 650,600 94,784 87,212 563,388 13% 22,000 4,643 4,017 17,983 18% 50,000 54,171 7,970 42,030 16% 20,000 3,269 2,151 17,849 11% 2,361,550 498,595 450,028 1,911,522 19% 6,000 - 2,671 3,329 45% 4,000 - - 4,000 0% 7,100 - 417 6,683 6% - - 3,947 (3,947) 0% - - 379,270 (379,270) 0% 198,000 - - 198,000 0% 210,500 - 210,500 0% - 564 - 0% - 825 - - 0% 13,070 3,197 3,379 9,691 26% 16,740 4,038 4,035 12,705 24% 45,600 11,474 12,061 33,539 26% 60,000 - - 60,000 0% 4,500 1,383 1,667 2,833 37% 261,500 55,939 68,016 193,484 26% 343,200 - - 343,200 0% 2,000 1,812 2,000 0% 550 - - 550 0% 1,172,760 79,233 475,464 697,296 41% 3 2021 Local Retail Sales/Use Taxrevenues are $107,461 higher than 2020 revenues. Please also seepages pages 18 & 19. 3 Packet Pg. 12 1 I 2.2.a I Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2021 Adopted 2/28/2020 Title Budget Revenues CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS 2 ATM SURCHARGE FEES 3 CREDIT CARD FEES 4 COURT RECORD SERVICES 5 D/M COURT REC SER 6 DRE REIMBURSEABLE 7 WARRANT PREPARATION FEE 8 IT TIME PAY FEE 9 MUNIC.-DIST. COURT CURR EXPEN 10 SALE MAPS & BOOKS 11 CLERKS TIME FOR SALE OF PARKING PERMITS 12 BID SUPPLIES REIMBURSEMENT 13 PHOTOCOPIES 14 POLICE DISCLOSURE REQUESTS 15 ENGINEERING FEES AND CHARGES 16 ELECTION CANDIDATE FILINGFEES 17 CUSTODIAL SERVICES(SNO-ISLE) 18 PASSPORTS AND NATURALIZATION FEES 19 POLICE SERVICES SPECIAL EVENTS 20 CAMPUS SAFETY-EDM. SCH. DIST. 21 WOODWAY-LAW PROTECTION 22 MISCELLANEOUS POLICE SERVICES 23 FIRE DISTRICT #1 STATION BILLINGS 24 LEGAL SERVICES 25 ADULT PROBATION SERVICE CHARGE 26 BOOKING FEES 27 FIRE CONSTRUCTION INSPECTION FEES 28 EMERGENCY SERVICE FEES 29 EMS TRANSPORT USER FEE 30 FLEX FUEL PAYMENTS FROM STATIONS 31 ANIMAL CONTROL SHELTER 32 ZONING/SUBDIVISION FEE 33 PLAN CHECKING FEES 34 FIRE PLAN CHECK FEES 35 PLANNING 1 % INSPECTION FEE 36 S.E.P.A. REVIEW 37 CRITICAL AREA STUDY 38 GYM AND WEIGHTROOM FEES 39 PROGRAM FEES 4 40 TAXABLE RECREATION ACTIVITIES 41 WINTER MARKET REGISTRATION FEES 42 BIRD FEST REGISTRATION FEES 43 INTERFUND REIMBURSEMENT -CONTRACT SVCS 2/28/2021 Amount Revenues Remaining % Received $ 3,000 $ 771 $ 632 $ 2,369 210/( 600 21 18 582 30/( 11,000 2,669 963 10,037 90/( 150 - - 150 00/( 300 20 - 300 00/c - 235 168 (168) 00/( 4,000 1,818 - 4,000 00/c 1,000 120 74 926 70/( 50 3 33 17 67% 100 10 - 100 00/( Q. 25,100 - - 25,100 00/( 600 - - 600 00/c 1,000 62 - 1,000 00/( v 500 - - 500 00/, _ 200,000 26,814 36,966 163,034 180/( 1,400 - - 1,400 00/, jL 85,000 23,554 16,470 68,530 190/( >, 10,000 4,920 - 10,000 00/( w 30,000 - - 30,000 00/( _ 76,800 36,753 - 76,800 00/( 195,000 49,715 51,206 143,794 26% - 20 - - 0a/( cV 57,000 16,140 14,616 42,384 260/( N 1,050 50 33 1,017 30/( �, 38,000 6,949 5,730 32,270 1501( 7 3,000 440 125 2,875 40/c 10,000 3,953 2,618 7,382 260/( N 3,500 601 763 2,737 22% 1,007,500 259,995 201,222 806,278 200/( 2,500 555 520 1,980 210/( O 50 - - 50 CL 00/c 65,600 25,745 17,275 48,325 260/( 350,900 52,656 142,787 208,113 410/( 4,000 6,131 1,209 2,791 300/( .v 500 - - 500 00/( 3,000 2,150 - 3,000 00/c 14,000 2,980 1,485 12,515 110/( LL 15,500 2,776 - 15,500 00/, s 900,662 101,709 12,135 888,527 1% 55 1,300 - - 1,300 0°% O z 5,000 - 185 4,815 40/( 800 - - 800 00/( cV 2,892,106 181,219 202,383 2,689,723 7°/ N 6,021,568 811,554 709,617 5,311,952 127% >, 4 2021 Parks & Recreation Program Revenues are $(89,574) lower than 2020 revenues. 4 Packet Pg. 13 1 2.2.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Revenues Revenues Remaining %Received FINES AND PENALTIES: 1 PROOF OF VEHICLE INS PENALTY 2 TRAFFIC INFRACTION PENALTIES 3 NC TRAFFIC INFRACTION 4 CRT COST FEE CODE LEG ASSESSMENT (LGA) 5 NON -TRAFFIC INFRACTION PENALTIES 6 OTHERINFRACTIONS'04 7 PARKING INFRACTION PENALTIES 8 PARK/INDDISZONE 9 DWI PENALTIES 10 DUI - DP ACCT 11 CRIM CNV FEE DUI 12 DUI - DP FEE 13 CRIMINAL TRAFFIC MISDEMEANOR 8/03 14 CRIMINAL CONVICTION FEE CT 15 CRIM CONV FEE CT 16 OTHER NON-T RAF MISDEMEANOR PEN 17 OTHER NON TRAFFIC MISD. 8/03 18 COURT DV PENALTY ASSESSMENT 19 CRIMINAL CONVICTION FEE CN 20 CRIM CONV FEE CN 21 PUBLIC DEFENSE RECOUPMENT 22 BANK CHARGE FOR CONV. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIESRENTALS 30 BRACKET ROOM RENTAL 31 LEASESLONG-TERM 32 DONATION/CONTRIBUTION 33 PARKSDONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHER JUDGEMENT/SETTLEMENT 40 POLICE JUDGMENTSiRESI'ITUTION 41 CASHIERS OVERAGES/SHORTAGES 42 OTHER MISC REVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - MUNICIPAL COURT 46 US BANK REBATE TRANSFERS -IN: 47 OPERATINGTRANSFER-IN 48 INTERFUND TRANSFER FROM FUND 018 49 TRANSFER FROM FUND 127 $ 2,000 $ 395 $ 514 $ 1,486 260/( 230,000 23,091 32,192 197,808 140/( 18,000 1,758 1,699 16,301 90/( 10,000 2,082 2,638 7,362 260/( 1,000 - - 1,000 00/( 1,500 188 306 1,194 200/( 100,000 21,680 9,724 90,276 100/( 2,000 383 - 2,000 00/( 7,000 1,101 1,330 5,670 190/( 300 20 16 284 50/c 100 1 35 65 350/( 1,500 568 308 1,192 210/( 25,000 4,131 2,349 22,651 90/( 2,000 408 254 1,746 130/( 700 49 13 687 20/( 100 19 12 88 120/( 10,000 4,831 298 9,702 3°/ 800 62 - 800 0°/ 1,000 125 5 995 00/c 200 10 7 193 30/( 8,000 929 545 7,455 70/( 14,000 1,971 1,594 12,406 11 % 3,000 617 469 2,531 160/( 10,100 - - 10,100 00/( 150 - - 150 00/( 448,450 64,418 54,309 394,141 127% 155,090 51,990 64,006 91,084 410/( 9,980 2,508 1,488 8,492 1501( 3,400 824 1,418 1,982 420/( 153,000 8,292 (423) 153,423 00/( 2,100 380 - 2,100 00/( 205,000 35,031 32,293 172,707 160/( 2,500 160 - 2,500 00/( 3,500 300 - 3,500 00/( 2,000 - - 2,000 00/c 5,000 - - 5,000 00/( 300 - - 300 00/( 3,000 - 468 2,532 160/( 2,000 - - 2,000 00/c 2,000 - - 2,000 0°/ 200 80 10 190 501( - 6 2 (2) 00/( 5,000 4,987 1,304 3,696 260/( 100 25 8 92 80/( 100 - 30 70 300/( 150 68 - 150 0°/ 8,500 - - 8,500 00/( 562,920 104,650 100,603 462,317 18% 238,667 - 238,667 00/( 123,581 - 123,581 00/( 26,300 - - 26,300 00/( 388,548 - - 388,548 00% TOTAL GENERAL FUND REVENUE $ 42,450,777 $ 4,730,574 $ 5,089,278 $ 37,361,499 120% 5 Packet Pg. 14 Page I of 6 CITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining '%Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 17,135,234 $ 2,629,365 $ 2,808,687 $ 14,326,547 16 2 OVERTIME 485,080 114,197 96,367 388,713 20 3 HOLIDAY BUY BACK 281,329 1,000 1,951 279,378 1 4 BENEFITS 6,665,844 1,046,823 1,063,517 5,602,327 16 5 UNIFORMS 88,651 25,433 11,822 76,830 13 6 SUPPLIES 397,115 76,587 59,823 337,292 15 7 SMALL EQUIPMENT 106,603 29,155 9,766 96,837 9 8 PROFESSIONAL SERVICES 14,779,455 2,522,771 2,556,380 12,223,075 17 9 COMMUNICATIONS 159,495 11,011 20,147 139,348 13 10 TRAVEL 68,760 2,425 - 68,760 0 11 EXCISE TAXES 6,500 973 2,544 3,956 39 12 RENTAL/LEASE 1,574,465 304,538 255,532 1,318,933 16 13 INSURANCE 403,973 393,746 405,121 (1,148) 100 14 UTILITIES 536,762 85,848 60,817 475,945 11 15 REPAIRS & MAINTENANCE 917,742 134,563 104,472 813,270 11 16 MISCELLANEOUS 505,730 101,600 130,071 375,659 26 17 INTERGOVERNMENTAL PAYMENTS 50,000 75,000 50,000 - 100 18 INTERFUND SUBSIDIES 932,880 - - 932,880 0 19 MACHINERY/EQUIPMENT 23,120 9,053 23,120 0 20 GENERAL OBLIGATION BOND PRINCIPAL 54,530 - 54,530 0 21 OTHER INTEREST & DEBT SERVICE COSTS 500 - 500 0 22 INTEREST ON LONG-TERM EXTERNAL DEBT 5,700 - 5,700 0 45,179,468 7,564,087 7,637,016 37,542,452 17 LEOFF-MEDICAL INS. RESERVE(009) 23 BENEFITS $ 206,650 $ 35,369 $ 32,702 $ 173,948 16 24 PENSION AND DISABILITY PAYMENTS 252,990 29,230 22,575 230,415 9 25 PROFESSIONAL SERVICES 7,000 - - 7,000 0 26 MISCELLANEOUS 500 - - 500 0 467,140 64,599 55,277 411,863 12 HISTORIC PRESERVATION GIFT FUND (014) 27 SUPPLIES $ 100 $ - $ - $ 100 0 28 PROFESSIONAL SERVICES 200 - 200 0 29 MISCELLANEOUS 5,600 - 5,600 0 5,900 - 5,900 0 BUILDING MAINTENANCEFUND (016) 30 INTERFUND SUBSIDIES $ 210,222 $ $ $ 210,222 0 210,222 210,222 0 EDMONDS HOMELESSNESS RESPONSEFUND (018) 31 PROFESSIONAL SERVICES $ 123,581 $ $ $ 123,581 0 123,581 123,581 0 EDMONDS OPIOID RESPONSEFUND (019) 32 INTERFUND SUBSIDIES $ 28,445 $ $ $ 28,445 0 28,445 28,445 0 DRUG ENFO RC EMENT FUND (104) 33 PROFESSIONAL SERVICES $ 45,000 $ $ $ 45,000 0 34 REPAIR/MAINT 800 800 0 45,800 45,800 0 O O. d lY io C O C IL s C O N O N O 7 N LL r- O CL O C O c M 21 t C O r N O N O d LL r c d E z tt to a 6 Packet Pg. 15 I 2.2.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent STREEI'FUND (111) 1 SALARIES AND WAGES $ 716,890 $ 110,827 $ 124,506 $ 592,384 17 2 OVERTIME 18,400 11,112 12,118 6,282 66 3 BENEFITS 378,236 54,593 61,385 316,851 16 4 UNIFORMS 6,000 2,653 3,602 2,398 60 5 SUPPLIES 263,000 27,527 4,155 258,845 2 6 SMALL EQUIPMENT 20,000 - - 20,000 0 7 PROFESSIONAL SERVICES 23,210 472 3,525 19,685 15 8 COMMUNICATIONS 4,500 692 699 3,801 16 9 TRAVEL 1,000 - - 1,000 0 10 RENTAL/LEASE 247,270 38,119 40,935 206,335 17 11 INSURANCE 148,436 156,937 148,533 (97) 100 12 UTILITIES 280,918 46,189 28,616 252,302 10 13 REPAIRS & MAINTENANCE 52,000 6,481 - 52,000 0 14 MISCELLANEOUS 8,000 484 6,721 1,279 84 15 GENERAL OBLIGATION BOND PRINCIPAL 4,220 - - 4,220 0 16 INTEREST 450 - 450 0 $ 2,172,530 $ 456,086 $ 434,795 $ 1,737,735 20 COMBINED STREETCONST/1IMPROVE(112) 17 PROFESSIONAL SERVICES $ 1,560,378 $ - $ 35,024 $ 1,525,354 2 18 REPAIR & MAINTENANCE 88,670 - - 88,670 0 19 MISCELLANEOUS - 8 - 0 20 INTERFUND SUBSIDIES 114,950 - 114,950 0 21 LAND 33,000 - 33,000 0 22 CONSTRUCTION PROJECTS 911,000 48,732 911,000 0 23 INTERGOVERNMENTAL LOANS 72,220 - 72,220 0 24 INTEREST 1,610 - - 1,610 0 $ 2,781,828 $ 48,740 $ 35,024 $ 2,746,804 1 MUNICIPAL ARTS ACQUIS. FUND (117) 25 SUPPLIES $ 4,700 $ - $ 217 $ 4,483 5 26 SMALL EQUIPMENT 1,700 - - 1,700 0 27 PROFESSIONAL SERVICES 221,500 6,696 5,312 216,188 2 28 TRAVEL 80 - - 80 0 29 RENTAL/LEASE 2,000 - 2,000 0 30 REPAIRS & MAINTENANCE 300 - - 300 0 31 MISCELLANEOUS 6,600 919 612 5,988 9 $ 236,880 $ 7,615 $ 6,141 $ 230,739 3 HO TEL/MO TEL TAX REVENUE FUND (120) 32 PROFESSIONAL SERVICES $ 83,150 $ 3,732 $ 7,278 $ 75,872 9 33 MISCELLANEOUS - 500 - - 0 34 INTERFUND SUBSIDIES 4,000 - - 4,000 0 $ 87,150 $ 4,232 $ 7,278 $ 79,872 8 EMPLO YEE PARIUNG PERMIT FUND (121) 35 SUPPLIES $ 1,790 $ - $ - $ 1,790 0 36 PROFESSIONAL SERVICES 25,090 - 25,090 0 $ 26,880 $ - $ $ 26,880 0 YOUTH SCHOLARSHIP FUND (122) 37 MISCELLANEOUS $ 3,000 $ 450 $ $ 3,000 0 $ 3,000 $ 450 $ $ 3,000 0 TO URISM PRO MO TIO NAL FUND/ARTS (123) 38 PROFESSIONAL SERVICES $ 29,900 $ 468 $ $ 29,900 0 $ 29,900 $ 468 $ $ 29,900 0 F O O. io C O C IL z r C O N O N O LL L N r- O CL O C O c M t r C O r N O N O 3 L N LL C d E z tt co r-- r� a 7 1 Packet Pg. 16 I 2.2.a I Page 3 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ 121,000 $ 3,343 $ 6,956 $ 114,044 6 2 PROFESSIONAL SERVICES 148,000 12,001 - 148,000 0 3 REPAIRS & MAINTENANCE 152,000 - 4,501 147,499 3 4 INTERFUND SUBSIDIES 190 - - 190 0 5 CONSTRUCTION PROJECTS 1,007,546 7,976 - 1,007,546 0 $ 1,428,736 $ 23,320 $ 11,457 $ 1,417,279 1 REAL ESTATE EXC ISE TAX 1 (126) 6 PROFESSIONAL SERVICES 7 REPAIRS & MAINTENANCE 8 INTERFUND SUBSIDIES 9 CONSTRUCTION PROJECTS 10 GENERAL OBLIGATION BONDS 11 INTEREST GIFTS CATALOG FUND (127) 12 SUPPLIES 13 PROFESSIONAL SERVICES 14 MISCELLANEOUS 15 INTERFUND SUBSIDIES C EVIEIERY MAINTENANC UIMPRO VEMEVT (130) 16 SALARIES AND WAGES 17 OVERTIME 18 BENEFIT S 19 UNIFORMS 20 SUPPLIES 21 SUPPLIES PURCHASED FOR INVENTORY/RESALE 22 PROFESSIONAL SERVICES 23 COMMUNICATIONS 24 TRAVEL 25 RENTAL/LEASE 26 UTILITIES 27 REPAIRS & MAINTENANCE 28 MISCELLANEOUS PARKS TRUST FUND (136) 29 PROFESSIONAL SERVICES CEMETERY MAINTENANCE TRUST FUND (137) 30 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 31 SUPPLIES 32 TRAVEL 33 MISCELLANEOUS BUSINESS IMPROVEMEVTDISTRICTFUND (140) 34 SUPPLIES 35 PROFESSIONAL SERVICES 36 MISCELLANEOUS 2012 LTGO DEBT SERVIC FUND (231) 37 GENERAL OBLIGATION BOND 38 INTEREST $ 560,000 $ 122,509 $ 18,817 $ 541,183 3 32,000 21,188 14,138 17,862 44 138,910 - - 138,910 0 769,351 6,531 72,339 697,012 9 144,530 - - 144,530 0 117,050 - - 117,050 0 $ 1,761,841 $ 150,228 $ 105,293 $ 1,656,548 6 $ 67,500 $ 2,762 $ $ 67,500 0 6,500 - 6,500 0 600 - 600 0 26,300 - 26,300 0 $ 100,900 $ 2,762 $ $ 100,900 0 $ 95,824 $ 13,721 $ 14,060 $ 81,764 15 3,500 176 30 3,470 1 40,472 6,122 6,248 34,224 15 1,000 - - 1,000 0 7,000 - - 7,000 0 20,000 2,066 1,638 18,362 8 4,200 - 800 3,400 19 1,700 279 281 1,419 17 500 - - 500 0 16,650 1,372 2,775 13,875 17 5,652 361 272 5,380 5 500 - - 500 0 4,000 2,325 2,567 1,433 64 $ 200,998 $ 26,421 $ 28,671 $ 172,327 14 $ 50,000 $ $ - $ 50,000 0 $ 50,000 $ $ - $ 50,000 0 $ 25,000 $ $ $ 25,000 0 $ 25,000 $ - $ $ 25,000 0 $ 1,500 $ 11 $ $ 1,500 0 4,500 - 4,500 0 5,900 - 5,900 0 $ 11,900 $ 11 $ $ 11,900 0 $ 2,050 $ 4,388 $ 273 $ 1,777 13 70,035 4,911 4,254 65,781 6 4,255 40 73 4,182 2 76,340 9,339 4,600 S 71,741 6 $ 677,990 $ - $ $ 677,990 0 81,710 - 81,710 0 $ 759,700 $ - $ $ 759,700 0 O CL O io C M C LL z r c O N O N M 7 N LL 8 Packet Pg. 17 I 2.2.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 113,453 $ 4,897 $ 359 $ 113,094 0 2 INTERFUND SUBSIDIES 44,000 - - 44,000 0 3 CONSTRUCTION PROJECTS 5,202,925 - 66,774 5,136,151 1 $ 5,360,378 $ 4,897 $ 67,133 $ 5,293,245 1 WATER FUND (421) 4 SALARIES AND WAGES 5 OVERTIME 6 BENEFIT S 7 UNIFORMS 8 SUPPLIES 9 WATER PURCHASED FOR RESALE 10 SUPPLIES PURCHASED FOR INVENTORY/RESALE 11 SMALL EQUIPMENT 12 PROFESSIONAL SERVICES 13 COMMUNICATIONS 14 TRAVEL 15 EXCISE TAXES 16 RENTAL/LEASE 17 INSURANCE 18 UTILITIES 19 REPAIRS & MAINTENANCE 20 MISCELLANEOUS 21 INTERFUND SUBSIDIES 22 CONSTRUCTION PROJECTS 23 GENERAL OBLIGATION BONDS 24 REVENUE BONDS 25 INTERGOVERNMENTAL LOANS 26 INTEREST STORM FUND (422) 27 SALARIES AND WAGES 28 OVERTIME 29 BENEFIT S 30 UNIFORMS 31 SUPPLIES 32 SMALL EQUIPMENT 33 PROFESSIONAL SERVICES 34 COMMUNICATIONS 35 TRAVEL 36 EXCISE TAXES 37 RENTAL/LEASE 38 INSURANCE 39 UTILITES 40 REPAIR & MAINTENANCE 41 MISCELLANEOUS 42 INTERFUND SUBSIDIES 43 CONSTRUCTION PROJECTS 44 GENERAL OBLIGATION BONDS 45 REVENUE BONDS 46 INTERGOVERNMENTAL LOANS 47 INTEREST $ 781,175 $ 139,411 $ 112,836 $ 668,339 14 24,000 2,774 3,083 20,917 13 325,765 54,231 47,134 278,631 14 4,000 - 355 3,645 9 150,000 6,578 5,499 144,501 4 2,170,000 257,120 123,474 2,046,526 6 170,000 15,716 18,365 151,635 11 11,000 3,256 - 11,000 0 1,421,647 89,654 96,002 1,325,645 7 30,000 4,161 1,927 28,073 6 200 - - 200 0 1,649,700 228,334 211,492 1,438,208 13 124,630 22,055 20,901 103,729 17 97,844 52,541 98,196 (352) 100 35,775 5,368 4,179 31,596 12 258,130 13,181 11,030 247,100 4 123,600 30,107 38,233 85,367 31 644,130 - - 644,130 0 1,947,050 7,879 1,947,050 0 2,840 - 2,840 0 385,100 - 385,100 0 25,840 - 25,840 0 196,170 - - 196,170 0 $ 10,578,596 $ 932,365 $ 792,707 $ 9,785,889 7 $ 716,300 $ 101,220 $ 124,593 $ 591,707 17 6,000 4,292 10,242 (4,242) 171 316,335 49,111 54,656 261,679 17 6,500 2,299 1,689 4,811 26 46,000 3,081 7,044 38,956 15 4,000 - 304 3,696 8 2,434,709 118,395 72,289 2,362,420 3 3,200 593 491 2,709 15 4,300 - - 4,300 0 470,100 119,572 131,822 338,278 28 267,778 48,076 44,467 223,311 17 66,216 116,576 66,228 (12) 100 11,025 2,017 2,105 8,920 19 64,130 13,181 10,963 53,167 17 232,300 34,197 55,723 176,577 24 281,810 - - 281,810 0 1,461,000 492,624 1,461,000 0 103,340 - 103,340 0 188,240 - 188,240 0 53,590 - 53,590 0 110,910 - - 110,910 0 $ 6,847,783 $ 1,105,234 $ 582,617 $ 6,265,166 9 O CL io C M C LL s C O N O N M 7 L N LL 9 Packet Pg. 18 I 2.2.a I Page 5 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 1,997,208 $ 320,368 $ 299,000 $ 1,698,208 15 2 OVERTIME 95,000 22,205 21,540 73,460 23 3 BENEFITS 863,464 146,731 128,681 734,783 15 4 UNIFORMS 8,500 3,163 3,244 5,256 38 5 SUPPLIES 404,000 46,979 50,738 353,262 13 6 FUEL CONSUMED 30,000 5,328 12,235 17,765 41 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 0 8 SMALL EQUIPMENT 35,000 15,611 1,566 33,434 4 9 PROFESSIONAL SERVICES 2,049,848 477,637 191,351 1,858,497 9 10 COMMUNICATIONS 43,000 5,342 2,868 40,132 7 11 TRAVEL 5,000 - - 5,000 0 12 EXCISE TAXES 968,000 175,548 181,313 786,687 19 13 RENTAL/LEASE 329,898 62,507 54,548 275,350 17 14 INSURANCE 160,967 174,140 162,851 (1,884) 101 15 UTILITIES 1,979,985 116,885 43,515 1,936,470 2 16 REPAIR & MAINTENANCE 520,630 44,955 38,368 482,262 7 17 MISCELLANEOUS 129,350 13,438 19,683 109,667 15 18 INTERFUND SUBSIDIES 8,657,681 - - 8,657,681 0 19 CONSTRUCTION PROJECTS 16,552,508 280,842 - 16,552,508 0 20 GENERAL OBLIGATION BONDS 157,060 - - 157,060 0 21 REVENUE BONDS 86,670 - - 86,670 0 22 INTERGOVERNMENTAL LOANS 173,900 - - 173,900 0 23 INTEREST 382,660 - - 382,660 0 24 DEBT ISSUE COSTS - - 1 518 (1 518) 0 $ 35,634,329 $ 1,911,677 $ 1,213,019 $ 34,421,310 3 BOND RESERVEFUND (424) 25 REVENUE BONDS $ 785,020 $ - $ - $ 785,020 0 26 INTEREST 1,200,850 - 1,200,850 0 $ 1,985,870 $ - $ $ 1,985,870 0 O CL io C M C LL z C O N 0 N 7 L N LL O 0. O C M C IL z r C O r N O N cc 3 L LL d E t V a 10 Packet Pg. 19 I 2.2.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent EQUIPMENTRENTAL FUND (511) 1 SALARIES AND WAGES $ 269,184 $ 45,160 $ 45,834 $ 223,350 17 2 OVERTIME 2,000 606 1,573 427 79 3 BENEFITS 115,681 19,158 19,335 96,346 17 4 UNIFORMS 1,000 62 605 395 60 5 SUPPLIES 120,000 15,585 9,513 110,487 8 6 FUEL CONSUMED 1,000 - - 1,000 0 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 258,000 11,854 13,497 244,503 5 8 SMALL EQUIPMENT 58,000 673 4,749 53,251 8 9 PROFESSIONAL SERVICES 46,750 528 194 46,556 0 10 COMMUNICATIONS 3,000 299 304 2,696 10 11 TRAVEL 1,000 - - 1,000 0 12 RENTAL/LEASE 12,790 2,027 2,070 10,720 16 13 INSURANCE 40,910 40,270 39,334 1,576 96 14 UTILITIES 14,500 2,584 2,526 11,974 17 15 REPAIRS&MAINTENANCE 60,000 8,389 3,886 56,114 6 16 MISCELLANEOUS 12,000 131 1,588 10,412 13 17 MACHINERY/EQUIPMENT 277,000 43,165 49,807 227,193 18 $ 1,292,815 $ 190,490 $ 194,816 $ 1,097,999 15 TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 373,762 $ 50,205 $ 51,188 $ 322,574 14 19 OVERTIME 2,000 - 303 1,697 15 20 BENEFITS 126,557 16,830 17,364 109,193 14 21 SUPPLIES 5,000 267 1,605 3,395 32 22 SMALL EQUIPMENT 141,300 15,765 2,320 138,980 2 23 PROFESSIONAL SERVICES 171,460 20,957 2,478 168,982 1 24 COMMUNICATIONS 58,770 7,345 8,690 50,080 15 25 TRAVEL 1,500 - - 1,500 0 26 RENTAL/LEASE 7,400 748 733 6,667 10 27 REPAIRS & MAINTENANCE 302,660 175,542 83,525 219,135 28 28 MISCELLANEOUS 5,000 3,923 88 4,912 2 29 MACHINERY/EQUIPMENT 56,000 - - 56,000 0 $ 1,251,409 $ 291,582 $ 168,294 $ 1,083,115 13 FIR]IVIEN'S PENSION FUND (617) 31 BENEFITS $ 24,560 $ 7,193 $ 6,428 $ 18,132 26 32 PENSION AND DISABILITY PAYMENTS 70,407 10,405 10,254 60,153 15 33 PROFESSIONAL SERVICES 1,200 - - 1,200 0 $ 96,167 $ 17,598 $ 16,682 $ 79,485 17 TOTAL EXPENDITURE ALL FUNDS $ 118,861,486 $ 12,812,204 $ 11,360,819 $ 107,500,667 10 O Q lY io C O C IL z r C O N O N O 3 N O 0. !Y 2 U C O C iL z C O r N O N M 3 L LL d E t V a 11 Packet Pg. 20 2.2.a Page 1 of 1 C ITY O F EDMO NDS EXPENDPTURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT CITY CLERK FINANCE CITY ATTORNEY NON -DEPARTMENTAL POLICE SERVICES COMMUNITY SERVICES/ECONOMIC DEV DEVELOPMENT SERVICES PARKS& RECREATION PUBLIC WORKS ADMINISTRATION FACILITIES MAINTENANCE % Spent $ 430,493 $ 55,625 $ 53,681 $ 376,812 12% 345,501 60,151 55,740 289,761 16% 807,176 134,278 132,066 675,110 16% 1,157,083 166,073 183,450 973,633 16% _ 750,555 139,339 139,396 611,159 19% 0 CL 1,104,378 251,089 226,074 878,304 20% 936,480 142,611 142,526 793,954 15% v 12,881,593 2,717,261 2,845,113 10,036,480 22% C 11,917,523 1,893,712 1,856,572 10,060,951 16% LL 1,211,100 82,357 85,831 1,125,269 7% w C 3,419,119 461,847 448,394 2,970,725 13% 0 4,503,783 596,263 655,977 3,847,806 15% N O 3,286,985 509,647 517,863 2,769,122 16% cV 2,427,699 353,835 294,332 2,133,367 12% coo 7 $ 45,179,468 $ 7,564,087 $ 7,637,016 $ 37,542,452 17% 'a' C ITY O F EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2021 Adopted Budget 2/28/2020 Expenditures 2/28/2021 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 10,578,596 $ 932,365 $ 792,707 $ 9,785,889 7% STORM UTILITY FUND 6,847,783 1,105,234 582,617 6,265,166 9% SEWER/WWTP UTILITY FUND 35,634,329 1,911,677 1,213,019 34,421,310 3% BOND RESERVE FUND 1,985,870 - - 1,985,870 0% $ 55,046,578 $ 3,949,276 $ 2,588,343 $ 52,458,235 5% 12 Packet Pg. 21 Page 1 of 4 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2021 Adopted Budget 2/28/2020 Expenditures 2/28/2021 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES $ 199,052 $ 31,690 $ 32,572 $ 166,480 16% OVERTIME 1,000 - - 1,000 0% BENEFITS 118,713 15,945 16,707 102,006 14% SUPPLIES 2,000 1,118 335 1,665 17% SMALL EQUIPMENT - - 1,159 (1,159) 0% PROFESSIONAL SERVICES 62,160 3,377 - 62,160 0% COMMUNICATIONS 3,000 610 767 2,233 26% TRAVEL 6,700 135 - 6,700 0% RENTAL/LEASE 12,368 2,106 2,043 10,325 17% REPAIRS✓MAINTENANCE 500 645 - 500 0% MISCELLANEOUS 25,000 97 24,903 0% $ 430,493 $ 55,625 $ 53,681 $ 376,812 12% OFFICEOFMAYOR SALARIES $ 229,512 $ 37,071 $ 38,249 $ 191,263 17% BENEFITS 85,243 15,711 14,075 71,168 17% SUPPLIES 1,500 224 124 1,376 8% SMALL EQUIPMENT - 4,199 - - 0% PROFESSIONAL SERVICES 3,000 101 194 2,806 6% COMMUNICATION 1,400 12 136 1,264 10% TRAVEL 3,000 149 - 3,000 0% RENTAL/LEASE 17,396 2,639 2,763 14,633 16% MISCELLANEOUS 4,450 45 200 4,250 4% $ 345,501 $ 60,151 $ 55,740 $ 289,761 16% HUMAN RESOURCES SALARIES $ 387,048 $ 59,492 $ 65,564 $ 321,484 17% OVERTIME - - 425 (425) 0% BENEFITS 154,430 23,498 27,556 126,874 18% SUPPLIES 13,300 259 487 12,813 4% SMALL EQUIPMENT 300 893 198 102 66% PROFESSIONAL SERVICES 175,000 19,511 7,069 167,931 4% COMMUNICATIONS 1,550 125 101 1,449 7% TRAVEL 1,500 500 - 1,500 0% RENTAL/LEASE 36,102 5,100 5,794 30,308 16% REPAIR/MAINTENANCE 8,380 7,832 8,067 313 96% MISCELLANEOUS 29,566 17,069 16,806 12,760 57% $ 807,176 $ 134,278 $ 132,066 $ 675,110 16% MUNIC IPAL C O URT SALARIES $ 643,567 $ 104,091 $ 114,861 $ 528,706 18% OVERTIME 800 19 9,826 (9,026) 1228% BENEFITS 242,359 39,862 37,929 204,430 16% SUPPLIES 10,600 422 - 10,600 0% SMALL EQUIPMENT 1,000 - - 1,000 0% PROFESSIONAL SERVICES 124,925 7,303 6,571 118,354 5% COMMUNICATIONS 3,550 351 311 3,239 9% TRAVEL 6,500 37 - 6,500 0% RENTAL/LEASE 70,682 11,020 11,314 59,368 16% REPAIR/MAINTENANCE 4,880 645 - 4,880 0% MISCELLANEOUS 25,100 2,323 2,639 22,461 11% MACHINERY/EQUIPMENT 23,120 23,120 0% $ 1,157,083 $ 166,073 $ 183,450 $ 973,633 16% O CL O io C M IL C 21 s C O 2 N O N M 7 N LL 13 Packet Pg. 22 1 I 2.2.a I Page 2 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY CLERK SALARIES AND WAGES $ 391,926 $ 67,375 $ 66,460 $ 325,466 17% BENEFITS 168,469 27,820 27,520 140,949 16% SUPPLIES 7,000 314 403 6,597 6% SMALL EQUIPMENT - 21 - - 0% PROFESSIONAL SERVICES 34,200 3,015 4,665 29,535 14% COMMUNICATIONS 33,000 (253) 8,134 24,866 25% TRAVEL 1,980 3 - 1,980 0% RENTAL/LEASE 55,980 9,223 8,578 47,402 15% REPAIRS&MAINTENANCE 48,000 31,125 22,853 25,147 48% MISCELLANEOUS 10,000 694 784 9,216 8% $ 750,555 $ 139,339 $ 139,396 $ 611,159 19% FINANCE SALARIES $ 732,408 $ 145,644 $ 123,623 $ 608,785 17% OVERTIME 4,500 - - 4,500 0% BENEFITS 238,064 49,250 41,692 196,372 18% SUPPLIES 7,350 880 451 6,899 6% SMALL EQUIPMENT 2,650 - 557 2,093 21% PROFESSIONAL SERVICES 9,300 - 36 9,264 0% COMMUNICATIONS 2,000 67 72 1,928 4% TRAVEL 3,100 - - 3,100 0% RENTAL/LEASE 55,176 9,803 10,627 44,549 19% REPAIR/MAINTENANCE 41,480 43,963 45,281 (3,801) 109% MISCELLANEOUS 8,350 1,481 3,733 4,617 45% $ 1,104,378 $ 251,089 $ 226,074 $ 878,304 20% CITY ATTO RNEY PROFESSIONAL SERVICES $ 936,480 $ 142,611 $ 142,526 $ 793,954 15% $ 936,480 $ 142,611 $ 142,526 $ 793,954 15% NON -DEPARTMENTAL SALARIES $ 101,750 $ - $ - $ 101,750 0% BENEFITS -UNEMPLOYMENT 50,000 84 8,868 41,132 18% SUPPLIES 5,000 195 7 4,993 0% PROFESSIONAL SERVICES 11,168,050 2,193,393 2,308,434 8,859,616 21% EXCISE TAXES 6,500 973 2,544 3,956 39% RENTAL/LEASE 6,366 2,961 1,063 5,303 17% INSURANCE 403,973 393,746 405,121 (1,148) 100% MISCELLANEOUS 96,344 50,910 69,076 27,268 72% CONTRIBUTION TO ECA 50,000 75,000 50,000 - 100% INTERFUND SUBSIDIES 932,880 - - 932,880 0% GENERAL OBLIGATION BOND 54,530 - 54,530 0% INTEREST ON LONG-TERM DEBT 5,700 - 5,700 0% FISCAL AGENT FEES 500 - - 500 0% $ 12,881,593 $ 2,717,261 $ 2,845,113 $ 10,036,480 22% 14 Packet Pg. 23 Page 3 of 4 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent POLICE SERVICES SALARIES $ 7,206,549 $ 1,091,565 $ 1,161,122 $ 6,045,427 16% OVERTIME 454,780 107,317 83,511 371,269 18% HOLIDAY BUYBACK 281,329 1,000 1,951 279,378 1% BENEFITS 2,819,711 444,039 436,162 2,383,549 15% UNIFORMS 78,426 24,525 10,682 67,744 14% SUPPLIES 86,500 21,106 17,576 68,924 20% SMALL EQUIPMENT 77,453 22,385 7,056 70,397 9% PROFESSIONAL SERVICES 122,220 33,823 20,993 101,227 17% COMMUNICATIONS 34,000 3,530 3,402 30,598 10% TRAVEL 29,310 1,518 - 29,310 0% RENTAL/LEASE 651,715 136,558 107,297 544,418 16% REPAIR/MAINTENANCE 15,180 1,315 1,708 13,472 11 % MISCELLANEOUS 60,350 5,031 5,111 55,239 8% $ 11,917,523 $ 1,893,712 $ 1,856,572 $ 10,060,951 16% COMMUNITY SERVICFS/ECON DEV. SALARIES $ 390,687 $ 43,033 $ 53,306 $ 337,381 14% OVERTIME - - 581 (581) 0% BENEFITS 109,147 13,553 15,227 93,920 14% SUPPLIES 3,275 6,598 41 3,234 1% SMALL EQUIPMENT 800 - - 800 0% PROFESSIONAL SERVICES 660,400 15,030 10,400 650,000 2% COMMUNICATIONS 3,675 82 288 3,387 8% TRAVEL 2,000 - - 2,000 0% RENTAL/LEASE 21,116 1,962 3,269 17,847 15% REPAIR/MAINTENANCE 10,500 - - 10,500 0% MISCELLANEOUS 9,500 2,100 2,720 6,780 29% $ 1,211,100 $ 82,357 $ 85,831 $ 1,125,269 7% DEVELO PM FNT SERVIC ES/PLANNING SALARIES $ 1,830,748 $ 281,350 $ 290,566 $ 1,540,182 16% OVERTIME 1,300 4,093 - 1,300 0% BENEFITS 680,921 104,385 107,524 573,397 16% UNIFORMS 500 - - 500 0% SUPPLIES 12,100 2,092 523 11,577 4% SMALL EQUIPMENT 7,300 648 - 7,300 0% PROFESSIONAL SERVICES 678,380 32,169 10,506 667,874 2% COMMUNICATIONS 9,000 910 1,081 7,919 12% TRAVEL 7,300 83 - 7,300 0% RENTAL/LEASE 135,710 28,173 21,987 113,723 16% REPAIRS & MAINTENANCE 6,800 - - 6,800 0% MISCELLANEOUS 49,060 7,945 16,206 32,854 33% MACHINERY/EQUIPMENT - - - - 0% $ 3,419,119 $ 461,847 S 448,394 $ 2,970,725 13% ENGINEERING SALARIES $ 1,773,720 $ 282,641 $ 289,047 $ 1,484,673 16% OVERTIME 5,000 1,047 408 4,592 8% BENEFITS 733,487 116,993 117,673 615,814 16% UNIFORMS 450 - - 450 0% SMALL EQUIPMENT 2,200 - 795 1,405 36% PROFESSIONAL SERVICES 13,840 - - 13,840 0% COMMUNICATIONS 19,600 1,517 1,524 18,076 8% TRAVEL 600 - - 600 0% RENTAL/LEASE 146,935 21,894 23,701 123,234 16% REPAIR/MAINTENANCE 2,600 - - 2,600 0% MISCELLANEOUS 80,000 2,169 2,996 77,004 4% $ 2,778,432 $ 426,262 $ 436,144 $ 2,342,288 16% O CL O w io C c� C LL 21 s C O 2 T- N O N O 7 L N LL 15 Packet Pg. 24 I 2.2.a I Page 4 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2021 Adopted 2/28/2020 2/28/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS & REC REATIO N SALARIES $ 2,179,335 $ 299,566 $ 386,952 $ 1,792,383 18% OVERTIME 10,000 803 25 9,975 0% BENEFITS 804,577 118,185 138,929 665,648 17% UNIFORMS 6,275 504 473 5,802 8% SUPPLIES 127,890 28,032 16,626 111,264 13% SMALL EQUIPMENT 10,900 1,010 - 10,900 0% PROFESSIONAL SERVICES 718,300 52,238 38,461 679,839 5% COMMUNICATIONS 31,370 1,017 1,268 30,102 4% TRAVEL 5,270 - - 5,270 0% RENTAL/LEASE 251,549 48,626 39,246 212,303 16% PUBLIC UTILITY 230,507 24,799 24,584 205,923 11% REPAIR/MAINTENANCE 29,700 596 - 29,700 0% MISCELLANEOUS 98,110 11,833 9,412 88,698 10% MACHINERY/EQUIPMENT 9,053 0% $ 4,503,783 $ 596,263 $ 655,977 $ 3,847,806 15% PUBLIC WORKS ADMINISTRATION SALARIES $ 296,962 $ 48,793 $ 49,897 $ 247,065 17% OVERTIME 200 - - 200 0% BENEFITS 106,203 17,645 17,238 88,965 16% SUPPLIES 8,600 321 63 8,537 1% SMALL EQUIPMENT 1,000 - - 1,000 0% PROFESSIONAL SERVICES 200 11 12 188 6% COMMUNICATIONS 1,350 102 76 1,274 6% TRAVEL 500 - - 500 0% RENTAL/LEASE 84,320 15,982 13,842 70,478 16% PUBLIC UTILITY 3,318 531 513 2,805 15% REPAIR/MAINTENANCE 1,000 - - 1,000 0% MISCELLANEOUS 4,900 - 77 4,823 2% $ 508,553 $ 83,385 $ 81,720 $ 426,833 16% FACILITIES MAINTENANCE SALARIES 771,970 137,053 136,467 635,503 18% OVERTIME 7,500 917 1,590 5,910 21% BENEFITS 354,520 59,853 56,417 298,103 16% UNIFORMS 3,000 404 667 2,333 22% SUPPLIES 112,000 15,024 23,187 88,813 21% SMALL EQUIPMENT 3,000 - - 3,000 0% PROFESSIONAL SERVICES 73,000 20,190 6,512 66,488 9% COMMUNICATIONS 16,000 2,941 2,987 13,013 19% TRAVEL 1,000 - - 1,000 0% RENTAL/LEASE 29,050 8,490 4,008 25,042 14% PUBLIC UTILITY 302,937 60,519 35,720 267,217 12% REPAIR/MAINTENANCE 748,722 48,443 26,563 722,159 4% MISCELLANEOUS 5,000 214 4,786 4% $ 2,427,699 $ 353,835 $ 294,332 $ 2,133,367 12% TOTAL GENERAL FUND EXPENDITURES S 45,179,468 S 7,564,087 S 7,637,016 $ 37,542,452 17% O O. O io C to C M 21 t C O 2 T- N O N O 7 L N LL 16 Packet Pg. 25 2.2.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2021 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 2,288,254 $ 2,288,254 $ 2,740,276 19.75% February 4,615,700 2,327,446 5,089,278 10.26% March 7,110,111 2,494,410 April 10,178,867 3,068,757 May 18,381,821 8,202,954 June 20,794,250 2,412,429 July 23,089,086 2,294,836 August 25,626,204 2,537,118 September 27,892,507 2,266,303 October 31,761,425 3,868,919 November 40,124,213 8,362,788 December 42,450,777 2,326,564 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2021 Real Estate Excise Tax 1 & 2 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 195,748 $ 195,748 $ 625,840 219.72% February 341,557 145,810 922,678 170.14% March 525,343 183,786 April 697,989 172,646 May 895,413 197,424 June 1,120,061 224,648 July 1,335,075 215,015 August 1,581,214 246,138 September 1,849,736 268,522 October 2,083,774 234,038 November 2,308,787 225,013 December 2,500,000 191,213 *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 26 1 SALES TAX SUMMARY I 2.2.a I Sales Tax Analysis By Category Current Period: February 2021 Year -to -Date Total $1,647,058 Automotive Repair Health & Personal Care,, $34 113 $43,940 Construction Trade, $243,479 Accommodation, $3,331 Clothing and Accessories,$65,795 _ Communications, $44,575 Wholesale Trade,_ $73,361 Misc Retail, $349,403 Amusement & Recreation, $5,571 Business Services, $176,723 Gasoline, $6,310 Retail Food Stores, i $59,162 107L Retail Automotive, $363,800 Manufacturing, $22,636 Others, $28,2Ating & Drinking, $126,587 Annual Sales Tax Revenue 1U,000,00U $8,406,296 $8,452,715 $8,317,046 8,000,000 7 395 114 $6,741,838 $6,905,122 6,000,000 4,000,000 2,000,000 51,647,058 0 201 2017 2018 2019 2020 YTD 2021 E 0 Ta c R c ii >, t c 0 r N 0 N R 3 L a� U- V- 0 a a� c �a c ii 21 t c 0 N O N cu L U- r- 0 E t 0 Q 18 Packet Pg. 27 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2021 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 661,963 $ 661,963 $ 774,198 16.95% February 1,491,081 829,118 1,647,058 10.46% March 2,110,825 619,744 April 2,677,870 567,045 May 3,379,279 701,409 June 4,038,220 658,941 July 4,756,025 717,805 August 5,547,915 791,890 September 6,288,480 740,565 October 7,063,515 775,035 November 7,866,501 802,986 December 8,600,000 733,499 City of'Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2021 Gas Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 82,557 $ 82,557 $ 84,132 1.91% February 170,654 88,097 172,999 1.37% March 250,947 80,292 April 317,447 66,501 May 368,586 51,139 June 403,108 34,522 July 430,884 27,777 August 454,299 23,415 September 475,121 20,822 October 498,594 23,472 November 537,295 38,702 December 595,000 57,705 Gas Utility Tax 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget Prior Year *The monthly budget forecast columns are based on a five-year average. F O CL C M C_ LL t r C O N O N M 7 L d O CL O C M C LL 21 t r C O r N O N M 3 L N LL C d E t C� M ++ a 19 Packet Pg. 28 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2021 Telephone Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 69,351 $ 69,351 $ 56,592 -18.40% February 138,426 69,074 85,370 -38.33% March 199,085 60,660 April 265,909 66,823 May 325,636 59,728 June 385,177 59,540 July 443,946 58,770 August 501,501 57,554 September 557,882 56,382 October 615,320 57,437 November 665,999 50,679 December 723,000 57,001 Electric Utility Tax 800,000 Telephone Utility Tax 700,000 600,000 500,000 400,000 300,000 / 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget �Prior Year City of Edmonds, WA Monthly Revenue Summary -Electric Utility Tax 2021 Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals % January $ 179,984 $ 179,984 $ 192,356 6.87% February 379,889 199,905 367,328 -3.31% March 546,637 166,748 April 730,293 183,656 May 873,813 143,520 June 997,568 123,755 July 1,114,337 116,769 August 1,230,154 115,816 September 1,342,671 112,517 October 1,453,976 111,305 November 1,576,729 122,753 December 1,710,000 133,271 Electric Utility Tax 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 , 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0- Current Year Budget - Prior Year *The monthly budget forecast columns are based on a five-year average. 20 Packet Pg. 29 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2021 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 779,311 $ 779,311 $ 785,708 0.82% February 1,323,513 544,201 1,376,327 3.99% March 2,123,378 799,865 April 2,634,733 511,355 May 3,397,533 762,799 June 3,993,888 596,356 July 4,928,107 934,219 August 5,728,520 800,414 September 6,831,863 1,103,343 October 7,628,547 796,684 November 8,538,589 910,042 December 9,090,825 552,236 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2021 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 384,276 $ 384,276 $ 377,845 6.87% February 1,216,009 831,732 1,205,144 -3.31% March 1,599,504 383,495 April 1,939,303 339,799 May 2,323,204 383,901 June 2,663,931 340,727 July 3,048,086 384,154 August 3,880,066 831,980 September 4,263,771 383,706 October 4,604,458 340,687 November 4,988,465 384,006 December 5,316,477 328,012 Storm Water Sales 5,500,000 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 - 2,000,000 1,500,000 1,000,000 500,000 ir 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --6-- Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. F O CL C M a LL t r C O N O N M 7 L d O CL <v C M C LL t r C O N O N M 3 L N LL C d E t C� M ++ a 21 Packet Pg. 30 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2021 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 846,742 $ 846,742 $ 806,699 -4.73% February 1,539,036 692,295 1,482,613 -3.67% March 2,387,119 848,083 April 3,078,705 691,586 May 3,923,269 844,563 June 4,616,005 692,736 July 5,485,907 869,902 August 6,180,993 695,086 September 7,065,967 884,974 October 7,769,759 703,792 November 8,630,384 860,626 December 9,319,928 689,544 *The monthly budget forecast columns are based on a five-year average. 22 Packet Pg. 31 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2021 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 4,763,692 $ 4,763,692 $4,488,492 -5.78% February 8,102,761 3,339,069 7,637,016 -5.75% March 11,550,167 3,447,406 April 14,976,824 3,426,657 May 18,175,079 3,198,255 June 22,305,837 4,130,758 July 26,106,634 3,800,797 August 29,720,247 3,613,613 September 33,095,759 3,375,511 October 36,818,699 3,722,940 November 40,835,625 4,016,926 December 45,179,468 4,343,843 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2021 Non -Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,129,707 $ 2,129,707 $ 2,013,112 -5.479/, February 2,964,270 834,564 2,845,113 -4.02/, March 3,918,886 954,616 April 4,746,252 827,366 May 5,429,051 682,799 June 6,890,293 1,461,242 July 7,928,307 1,038,014 August 8,794,775 866,469 September 9,536,123 741,348 October 10,451,643 915,520 November 11,576,017 1,124,374 December 12,881,593 1,305,576 *The monthly budget forecast columns are based on a five-year average. 23 Packet Pg. 32 1 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2021 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 27,170 $ 27,170 $ 26,808 -1.33% February 57,559 30,389 53,681 -6.74% March 91,021 33,462 April 121,761 30,741 May 162,400 40,639 June 211,053 48,653 July 245,137 34,084 August 292,412 47,276 September 331,547 39,135 October 355,831 24,284 November 391,926 36,095 December 430,493 38,567 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2021 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 28,543 $ 28,543 $ 27,531 -3.55% February 58,378 29,835 55,740 -4.52% March 86,855 28,477 April 115,847 28,992 May 144,377 28,530 June 172,357 27,980 July 200,988 28,631 August 230,481 29,494 September 259,088 28,607 October 287,175 28,087 November 315,280 28,104 December 345,501 30,221 Office of Mayor 350,000.00 300,000.00 250,000.00 200,000.00 150,000.00 / 100,000.00 / 50,000.00 0.00 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - -PriorYear *The monthly budget forecast columns are based on a five-year average. 24 Packet Pg. 33 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2021 Human Resources Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 70,645 $ 70,645 $ 75,120 6.33% February 133,817 63,171 132,066 -1.31% March 194,869 61,053 April 253,374 58,505 May 314,638 61,264 June 389,004 74,366 July 447,996 58,992 August 509,552 61,556 September 577,098 67,546 October 640,237 63,138 November 705,461 65,225 December 807,176 101,715 City of'Edmonds, WA Monthly Expenditure Report -Municipal Court 2021 Municipal Court Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 87,732 $ 87,732 $ 93,953 7.09% February 183,658 95,926 183,450 -0.11% March 277,088 93,430 April 372,050 94,962 May 474,182 102,132 June 564,520 90,338 July 657,862 93,341 August 754,726 96,864 September 848,582 93,856 October 947,082 98,500 November 1,039,678 92,596 December 1,157,083 117,405 Municipal Court 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0---CurrentYeaz Budget �PriorYear *The monthly budget forecast columns are based on a five-year average. F O CIL C M C LL t r C O N O N M 7 L d O CIL O C M C LL t r C O r N O N M 3 L N LL a+ C d E t C� M ++ a 25 Packet Pg. 34 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2021 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 80,002 $ 80,002 $ 43,221-45.98% February 171,172 91,170 85,831-49.86% March 262,430 91,258 April 357,508 95,078 May 453,339 95,831 June 545,783 92,444 July 645,125 99,342 August 751,947 106,822 September 843,469 91,522 October 945,696 102,227 November 1,067,925 122,230 December 1,211,100 143,175 City of Edmonds, WA Monthly Expenditure Report -City Clerk 2021 City Clerk Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 72,647 $ 72,647 $ 78,859 8.55% February 132,803 60,156 139,396 4.96% March 194,510 61,706 April 259,653 65,143 May 319,306 59,653 June 377,113 57,807 July 440,842 63,728 August 507,499 66,657 September 562,881 55,383 October 619,955 57,074 November 686,148 66,192 December 750,555 64,407 City Clerk 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 26 Packet Pg. 35 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2021 Technology Rental Fund Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 136,016 $ 136,016 $ 117,002 -13.98% February 289,014 152,998 168,294 -41.77% March 384,228 95,214 April 451,482 67,254 May 540,191 88,709 June 631,052 90,861 July 710,229 79,177 August 802,445 92,216 September 897,442 94,997 October 980,269 82,826 November 1,061,491 81,223 December 1,251,409 189,918 Finance Technology Rental Fund 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Finance 2021 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 115,331 $ 115,331 $ 137,736 19.43% February 200,151 84,821 226,074 12.95% March 286,138 85,987 April 373,267 87,129 May 460,772 87,505 June 569,205 108,432 July 661,728 92,524 August 746,841 85,112 September 842,777 95,936 October 931,701 88,925 November 1,017,542 85,840 December 1,104,378 86,836 Finance 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC +Current Yeaz Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 27 Packet Pg. 36 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2021 City Attorney Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 78,040 $ 78,040 $ 69,941 -10.38% February 1S6,080 78,040 142,526 -8.68% March 234,120 78,040 April 312,160 78,040 May 390,200 78,040 June 468,240 78,040 July 546,280 78,040 August 624,320 78,040 September 702,360 78,040 October 780,400 78,040 November 858,440 78,040 December 936,480 78,040 City of'Edmonds, WA Monthly Expenditure Report -Police 2021 Police Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 925,403 $ 925,403 $ 992,942 7.30% February 1,886,416 961,013 1,856,572 -1.58% March 2,829,982 943,566 April 3,782,981 952,999 May 4,725,632 942,651 June 5,729,411 1,003,779 July 6,736,463 1,007,052 August 7,660,147 923,684 September 8,630,143 969,996 October 9,691,161 1,061,018 November 10,910,020 1,218,859 December 11,917,523 1,007,503 *The monthly budget forecast columns are based on a five-year average. E O Q N tC U C f� C LL L Y C O r N O N fC 3 L O O rL d R U C O C LL t Y C O r N O N M 3 L N LL Y d E L V tC Y Y Q Z$ Packet Pg. 37 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2021 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 244,151 $ 244,151 $ 219,157-10.249/ February 512,682 268,530 448,394-12.54% March 780,153 267,471 April 1,064,982 284,829 May 1,353,718 288,736 June 1,619,863 266,145 July 1,907,483 287,620 August 2,201,287 293,804 September 2,485,656 284,370 October 2,763,764 278,107 November 3,086,765 323,002 December 3,419,119 332,354 City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2021 Parks &z Recreation Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 304,498 $ 304,498 $ 308,283 1.24% February 620,652 316,154 655,977 5.69% March 956,699 336,047 April 1,305,795 349,096 May 1,666,114 360,320 June 2,028,272 362,158 July 2,484,241 455,969 August 3,009,180 524,938 September 3,435,053 425,873 October 3,799,710 364,658 November 4,117,176 317,466 December 4,503,783 386,607 Parks & Recreation 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC +Current Yeaz Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 29 Packet Pg. 38 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Public Works Administration 2021 Public Works Administration Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 41,785 $ 41,785 $ 40,605 -2.82% February 84,383 42,598 81,720 -3.16% March 126,606 42,223 April 169,031 42,425 May 211,539 42,508 June 254,896 43,358 July 298,440 43,543 August 340,623 42,183 September 382,623 42,000 October 423,711 41,088 November 465,344 41,633 December 508,553 43,209 Facilities Maintenance Public Works Administration 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Yeaz Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2021 Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 166,680 $ 166,680 $ 142,909-14.26% February 346,708 180,027 294,332-15.11% March 529,946 183,238 April 702,232 172,286 May 888,675 186,443 June 1,037,310 148,634 July 1,216,290 178,980 August 1,406,137 189,848 September 1,612,152 206,015 October 1,886,923 274,771 November 2,112,684 225,761 December 2,427,699 315,015 Facilities Maintenance 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 30 Packet Pg. 39 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2021 Engineering Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals % January $ 211,557 $ 211,557 $ 218,316 3.20% February 421,058 209,501 436,144 3.58% March 649,561 228,503 April 886,152 236,591 May 1,124,971 238,819 June 1,364,775 239,803 July 1,608,706 243,931 August 1,859,537 250,831 September 2,090,173 230,636 October 2,325,192 235,019 November 2,546,320 221,128 December 2,778,432 232,112 *The monthly budget forecast columns are based on a five-year average. 31 Packet Pg. 40 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of February 28, 2021 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate First Financial CD 3,000,000 0.11 3,000,000 3,000,000 04/10/21 2.86% Port of Seattle WA Bonds 273,305 0.17 270,000 270,840 05/01/21 2.23% Grant Cnty WA Bonds 410,553 0.84 405,000 410,338 01/01/22 1.79% FFCB Bonds 1,998,548 1.29 2,000,000 2,044,148 06/14/22 1.88% Energy Northwest Bonds 1,466,077 1.34 1,345,000 1,431,860 07/01/22 5.00% Energy Northwest Bonds 260,748 1.34 250,000 258,530 07/01/22 2.95% Mason & Kitsap Cnty WA Bonds 948,084 1.76 855,000 925,555 12/01/22 5.00% Grant Cnty WA Bonds 1,517,955 1.84 1,500,000 1,533,645 01/01/23 1.54% Grant Cnty WA Bonds 576,332 1.84 520,000 564,850 01/01/23 5.00% Seattle WA Muni Bonds 2,224,500 1.93 2,000,000 2,180,720 02/01/23 5.00% FHLB Bonds 1,996,590 2.60 2,000,000 1,997,266 10/05/23 0.22% First Financial - ECA CD 2,803,516 2.71 2,803,516 2,803,516 11/15/23 2.08% Kent WA Bonds 286,648 2.76 250,000 281,783 12/01/23 5.00% Spokane County WA Bonds 259,075 3.76 250,000 262,210 12/01/24 2.10% First Financial - Waterfront Center CD 2,000,000 6.68 2,000,000 2,000,000 11/01/27 0.25% TOTAL SECURITIES 20,021,929 2.06 19,448,516 19,965,260 Washington State Local Gov't Investment Pool 19,394,952 19,394,952 Demand 0.13% Snohomish County Local Gov't Investment Pool 25,177,766 25,177,766 Demand 1.50% TOTAL PORTFOLIO Port of Issuer Diversification Seattle WA Kent WA, Seattle Muni, 10% 1% 1% Mason & . , KitsapCnty First WA, 4% Financial CD, 40% Grant Cnty J WA, 12% FFCB, 10% Energy FHLB, pokane Northwest, 10% _ County 8% WA, 1% $ 64,021,234 $ 64,537,978 Cash and Investment Balances Checking, (in $ Millions) —$3.5 , 5% Bonds, $11.6, 17% CD's, $7.8, State LGIP, 12% $19.4, 29% County LGIP, $25.2, 37% O sZ N R U C O C LL 21 L r� C O 2 r N O N tC 3 L N LL O Q d R U C tC C LL t C O r N O N fC 3 L LL c d t v a r Q 32 Packet Pg. 41 1 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,236,875 $1,200,000 $1,000,000 $947,931 $800,000 $635,781 $600,000 423,799 $400,000 $$200,645 200,000 $- 2016 2017 2018 2019 2020 YTD 2021 1.8% 1.5% 1.3% 1.0% 0.8% 0.5 % 0.3 % 0.0% Edmonds Rate of Return Compared to Benchmark (Rolling 12 months) — - - 6 Month Treasury Rate (Benchmark) City Blended Rate March May July September November January Maturity Distribution and Rate of Return $6,000,000 5.00% $ 5,000, 000 4.00% $4,000,000 3.00% $3,000,000 $2,000,000 2.00% $1,000,000 1.00% $- - 0.00% 0-6 Mo 6-12 12-18 18-24 24-30 30-36 36-42 42-48 48-54 54-60 60-66 66-72 72-78 78-84 Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo F O M m 2 c M LL 21 z c O N O N M 7 L u_ O M m c M c ii 21 z c O N O N M LL L E t v M a 33 Packet Pg. 42 2.2.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 2/28/2021 2/28/2021 Q1 YTD Fund Balance Cash Balance 001-General Fund $ 11,320,118 $ 5,330,172 $ (2,547,738 0 009-Leoff-Medical Ins. Reserve 481,899 481,900 0. (55,277 012-Contingency Reserve Fund 1,782,149 1,782,150 - 014-Historic Preservation Gift Fund 17,188 17,189 - U 016-Building Maintenance 210,221 210,221 c - 017 - Marsh Restoration & Preservation 864,616 864,616 - u_ >, 018 -Edmonds Homelessness Response 123,581 123,581 - 019 - Edmonds Opioid Response 28,445 28,445 c - �0 Total General Fund & Subfunds $ 14,828,218 $ 8,838,273 $ - $ (2,603,015 r N *$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. N *$7,267,031of the fund balance in Fund 001 added to the $1,768,863 balance in Fund 012, represent the required 20% operating reserve. a� u_ 1` 0 GOVERNMENTAL FUNDS OVERVIEW 2 U U_ CHANGE IN FUND 2' FUND BALANCES BALANCES 0 GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- 2 FUNDS 2/28/2021 2/28/2021 Q1 YTD c Fund Balance Cash Balance N c� General Fund & Subfunds $ 14,828,218 $ 8,838,273 $ (2,603,015 Special Revenue 12,090,018 10,324,527 1,165,084 LL Debt Service - - -c Capital Projects 6,017,533 5,925,808 m (35,978 E t Total Governmental Funds $ 32,935,769 $ 25,088,608 $ - $ (1,473,909 r 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. 34 Packet Pg. 43 2.2.a SPECIAL REVENUE FUNDS OVERVIEW FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- GOVERNMENTAL SPECIAL REVENUE 2/28/2021 2/28/2021 Q1 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 74,804 $ 74,417 $ 502 1 1 1 - Street Fund 879,897 768,680 (207,225 1C. 112 - Combined Street Const/Im prove 2,521,819 1,742,927 448,414 o. 117 - Municipal Arts Acquis. Fund 681,335 676,731 (1,392 W 118 - Memorial Street Tree 20,354 20,218 137 6 120 - Hotel/Motel Tax Revenue Fund 67,032 59,480 111 c 121 - Employee Parking Permit Fund 87,079 86,356 5,080 c 122 - Youth Scholarship Fund 13,921 13,828 93 u_ 123 -Tourism Promotional Fund/Arts 83,184 80,344 2,846 125 - Real Estate Tax 2 3,039,871 2,725,730 467,890 0 126 - Real Estate Excise Tax 1 * 2,682,203 2,367,077 372,036 a 127 - Gifts Catalog Fund 316,295 314,286 18,231 N 130- Cemetery Maintenance/Improvement 207,560 206,134 2,432 N 136 - Parks Trust Fund 167,764 166,640 1,126 �+ 137 - Cemetery Maintenance Trust Fund 1,100,535 1,093,187 10,675 138 - Sister City Commission 10,433 10,363 70 140 -Business Improvement Disrict 49,001 49,002 29,850 141 - Affordable and Supportive Housing I'd 86,753 85,952 14,207 142 - Edmonds Cares Fund 174 (216,826) - Q. Total Special Revenue $ 12,090,018 $ 10,324,527 1 $ - $ 1,165,084 *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $500,000 for the purchase of Open Space. ENTERPRISE FUNDS OVERVIEW LL O r N O FUND BALANCES CHANGE IN FUND ---- ACTUAL ---- ---- ACTUAL ---- ENTERPRISE FUNDS 2/28/2021 2/28/2021 Q1 YTD Fund Balance Cash Balance u_ c 421 -Water Utility Fund $ 26,491,658 $ 5,509,018 $ 763,445 E 422 - Storm Utility Fund * 15,528,676 5,275,979 1,264,402 U 423 - Sewer/WWTP Utility Fund 55,983,014 21,319,311 3,206,823 Q 424 - Bond Reserve Fund 843,963 843,963 2 411 -Combined Utility Operation 120 28,242 120 Total Enterprise Funds $ 98,847,431 $ 32,976,513 $ - $ 5,234,791 *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding. *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 35 Packet Pg. 44 2.2.a SUMMARY OVERVIEW CHANGE IN FUND FUND BALANCES BALANCES CITY-WIDE ---- ACTUAL ---- ---- ACTUAL ---- 2/28/2021 2/28/2021 Q1 YTD Fund Balance Cash Balance Governmental Funds $ 32,935,769 $ 25,088,608 $ (1,473,909 0 Enterprise Funds 98,847,431 32,976,513 5,234,791 Internal Services Fund 10,090,458 5,515,052 95,340 76 Agency Funds 118,433 118,433 (16,682 u- c Total City-wide Total $ 141,992,091 $ 63,698,606 $ - $ 3,839,541 c ii 2, t c 0 INTERNAL SERVICE FUNDS OVERVIEW N 0 N fC 3 L L FUND BALANCES CHANGE IN FUND 0. BALANCES ---- ACTUAL ---- ---- ACTUAL ---- INTERNAL SERVICE FUNDS 2/28/2021 2/28/2021 Q1 YTD U Fund Balance Cash Balance ii 511 - Equipment Rental Fund $ 9,202,795 $ 4,733,065 $ 58,595 21 512 -Technology Rental Fund 887,663 781,987 36,745 c 0 Total Internal Service Funds $ 10,090,458 $ 5,515,052 $ - $ 95,340 N 0 N fC 3 L U_ d E L V Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 36 Packet Pg. 45 2.3 City Council Agenda Item Meeting Date: 04/13/2021 2021 April Budget Amendment Staff Lead: Dave Turley Department: Administrative Services Preparer: Marissa Cain Background/History Amend the 2021 Ordinance No. 4216 Staff Recommendation Staff recommends that Council add the 2021 April Budget Amendment to the Consent Agenda on April 20th for the approval of Ordinance No. XXXX amending the 2021 Budget. Attachments: 2021 April Budget Amendment Exhibits 2021 April Budget Amendment Ordinance Packet Pg. 46 2.3.a New Item for Council to Consider (April 2021) Budget Amendment for: April 20th, 2021 Item Description: The Parks, Recreation & Cultural Services (PRCS) Department is requesting the addition of contracted Parks Planning Support services. For 2021, in addition to operating a department during ever -changing COVID guidelines, PRCS has the PROS Plan, Salmon Safe certification (new), and Civic Park project, an active land acquisition program, more than 25 small parks capital projects in deferred maintenance, several with safety issues and, effective April 1st, the administration of Human Services division requiring significant staff time to develop and implement. There is not a designated staff to implement the park planning workload and using contracted services for design, permitting, land acquisition and management of small parks capital projects will allow department Admin to better focus on Human Services implementation and park maintenance. Department: Parks, Recreation & Cultural Serices Fund Name: 001 GENERAL Division: Administration Title: Parks Planning SUDDort Services 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) Director New Item For Council To Consider 100% Ending Fund Balance One -Time Operating Account Number Description 2021 2022 2023 2024 2025 001.000.64.571.21.41.00 Professional Services $ 50,000 $ $ $ S Total Expenditure Increase Decrease $ 50,000 $ $ S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ $ $ S Total Revenue Increase Decrease $ $ $ $ S Ending Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.39.508.00.00.00 Ending Fund Balance $ 50,000 $ $ $ S Total Ending Fund Balance Increase Decrease $ 50,000) $ $ $ $ Packet Pg. 47 2.3.a New Item for Council to Consider (April 2021) Budget Amendment for: April 20th, 2021 Item Description: The Parks, Recreation & Cultural Services (PRCS) Department is requesting funding for additional wetland delination services to meet the permitting requirements necessary to allow access into the Marsh for restoration efforts including volunteer work of invasive plant removal and planting of native vegetation. Without the permit and necessary delination, the City is unable to access significant areas of the Marsh to complete this restoration work. Currently, access is allowed in the northwest and southeast portions and this delineation will meet permit requirements to provide access to the remainder of the Marsh for restoration work. Department: Parks, Recreation & Cultural Services Fund Name: 017 MARSH RESTORATION & PRESERVATION Division: Administration Title: Edmonds Marsh Planning Services Preparer: Angie Feser, Director Budget Amendment Type New Item For Council To Consider Date of Discussion or Budget Approval? How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 017.000.64.576.80.41.00 Professional Services $ 20,000 $ S $ $ Total Expenditure Increase Decrease $ 20,000 $ $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ S $ S Total Revenue Increase(Decrease) $ $ S $ S Ending Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 017.000.64.508.40.00.00 Ending Fund Balance $ 20,000 $ S $ S Total Ending Fund Balance Increase Decrease S (20,000) $ S $ S Packet Pg. 48 2.3.a New Item for Council to Consider (April 2021) Budget Amendment for: April 20th, 2021 Item Description: The Street Department is requesting the funds to purchase a "mini excavator" and the trailer to hual it on. A mini would provide our sidewalk crew the ability to efficiently and safely demo and prep the job sites for a sidewlk pour. A large portion of the crew's efforts are in doing this site preparation, often with a backhoe that is too large for the site or by manually doing the work by hand. A mini fits into a parking stall or onto a sidewalk that is being removed creating a job site compressed enough to not require traffic controls/flaggers thus reducing the required manpower to accomplish the job. A mini is typically the first piece of equipmnet on a sidewalk project and is almost always the last to leave. The purchase of a mini will allow for the sidewalk crew to be more efficientproductive and safe. Department: Street Department/Equipment Rental Fund Name: 511 EQUIPMENT RENTAL Division: Public Works Title: Equipment Purchase Preparer: Tod Moles, Street/Storm Manager Budget Amendment Type New Item For Council To Consider Date of Discussion or Budget Approval? How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Capital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 511.100.77.594.48.64.00 B-Fund/ Streets $ 80,000 $ $ $ S Total Expenditure Increase Decrease $ 80,000 $ $ $ $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ $ $ $ Total Revenue Increase(Decrease) $ $ $ $ S Ending Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 511.100.77.508.00.00.00 Ending Fund Balance $ 80,000 $ S $ S Total Ending Fund Balance Increase Decrease $ 80,000 $ S $ S Packet Pg. 49 2.3.a New Item for Council to Consider (April 2021) Budget Amendment for: April 20th, 2021 Item Description: Currently the three utility funds do not have formal policies for reserve funds needs and the General Facility Charges for new services have not been reviewed and reevaluated for over 8 years. This budget amendment will program the funds to hire a consultant who will help city staff to develop policies to ensure to develop policies to ensure that adequate reserves are in place and to verify if General Facility Charges need to be updated. Department: Public Works Fund Name: MULTIPLE FUNDS Division: Engineering Title: Utility Fund Reserve Policies and Utility Expansion Fees Update Preparer: Michele (Mike) De Lilla Budget Amendment Type New Item For Council To Consider Date of Discussion or Budget Approval? How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? Operating Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.74.534.80.41.67 Interfund Services $ 7,500 $ S $ S 421.000.74.534.80.41.10 Professional Services 22,500 422.000.72.531.70.41.67 Interfund Services 7,500 422.000.72.531.90.41.20 Professional Services 22,500 423.000.75.535.80.41.67 Interfund Services 7,500 423.000.75.535.80.41.30 Professional Services 22,500 Total Expenditure Increase(Decrease) $ 90,000 $ S $ S Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) S $ S $ $ Ending Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 421.000.74.508.00.00.00 Ending Fund Balance $ 30,000 $ S $ S 422.000.72.508.00.00.00 Ending Fund Balance 30,000 423.000.75.508.00.00.00 Ending Fund Balance 30,000 Total Ending Fund Balance Increase Decrease $ 90,000 $ S $ S Packet Pg. 50 2.3.a Previously Discussed by Council (April 2021) Budget Amendment for: April 20th, 2021 Item Description: The Teamsters and AFSCME labor contracts were extended through 2021, and a COLA increase of 2% was included with this extension. This decision package increases the budget expenditures for salaries and benefits under the Teamsters and AFSCME contracts. Department: Multiple Fund Name: MULTIPLE FUNDS Division: Multiple Title: Increase to Salaries / Benefits from new Labor Contract Preparer: Marissa Cain Budget Amendment Type Previously Discussed By Council Date of Discussion or Budget Approval? Approved 12/5/2020 and 1/12/2021 How is this amendment funded? 100% Ending Fund Balance What is the nature of the expenditure? On -Going Is the Expenditure Operating or Capital? 10perating Expenditure Increase (Decrease) Fill out on -going costs & revenues Account Number Description 2021 2022 2023 2024 2025 001.000.23.512.50.23.00 Benefits $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 001.000.31.514.20.23.00 Benefits 2,500 2,500 2,500 2,500 2,500 512.000.31.518.88.23.00 Benefits 1,100 1,100 1,100 1,100 1,100 001.000.25.514.30.23.00 Benefits 1,200 1,200 1,200 1,200 1,200 001.000.61.557.20.23.00 Benefits 700 700 700 700 700 001.000.62.558.60.23.00 Benefits 400 400 400 400 400 001.000.62.524.20.23.00 Benefits 2,700 2,700 2,700 2,700 2,700 001.000.62.524.10.23.00 Benefits 600 600 600 600 600 001.000.67.518.21.23.00 Benefits 2,300 2,300 2,300 2,300 2,300 001.000.64.571.21.23.03 Benefits 2,400 2,400 2,400 2,400 2,400 001.000.64.576.80.23.00 Benefits 4,200 4,200 4,200 4,200 4,200 001.000.65.518.20.23.00 Benefits 700 700 700 700 700 001.000.66.518.30.23.00 Benefits 3,200 31200 3,200 3,200 3,200 422.000.72.531.40.23.00 Benefits 2,400 2,400 2,400 2,400 2,400 111.000.68.542.31.23.00 Benefits 3,100 3,100 3,100 3,100 3,100 421.000.74.534.80.23.00 Benefits 3,100 3,100 3,100 3,100 3,100 423.000.75.535.80.23.00 Benefits 2,700 2,700 2,700 2,700 2,700 423.000.76.535.80.23.00 Benefits 5,400 5,400 5,400 5,400 5,400 511.000.77.548.68.23.00 Benefits 800 800 800 800 800 001.000.41.521.10.23.00 Benefits 6,500 6,500 6,500 6,500 6,500 001.000.23.512.50.11.00 Salaries 7,600 7,600 7,600 7,600 7,600 001.000.31.514.23.11.00 Salaries 11,500 11,500 11,500 11,500 11,500 512.000.31.518.88.11.00 Salaries 5,400 5,400 5,400 5,400 5,400 001.000.25.514.30.11.00 Salaries 5,300 5,300 5,300 5,300 5,300 001.000.61.557.20.11.00 Salaries 1,800 1,800 1,800 1,800 1,800 001.000.62.558.60.11.00 Salaries 1,500 1,500 1,500 1,500 1,500 001.000.62.524.20.11.00 Salaries 11,300 11,300 11,300 11,300 11,300 001.000.62.524.10.11.00 Salaries 3,000 3,000 3,000 3,000 3,000 001.000.67.518.21.11.00 Salaries 12,300 12,300 12,300 12,300 12,300 001.000.64.571.22.11.00 Salaries 11,200 11,200 11,200 11,200 11,200 001.000.64.576.80.11.00 Salaries 15,700 15,700 15,700 15,700 15,700 001.000.65.518.20.11.00 Salaries 3,000 3,000 3,000 3,000 3,000 001.000.66.518.30.11.00 Salaries 12,000 12,000 12,000 12,000 12,000 422.000.72.531.70.11.00 Salaries 7,400 7,400 7,400 7,400 7,400 111.000.68.544.70.11.00 Salaries 11,800 11,800 11,800 11,800 11,800 421.000.74.534.80.11.00 Salaries 12,300 12,300 12,300 12,300 12,300 423.000.75.535.80.11.00 Salaries 10,700 10,700 10,700 10,700 10,700 423.000.76.535.80.11.00 Salaries 19,600 19,600 19,600 19,600 19,600 511.000.77.548.68.11.00 Salaries 3,200 3,200 3,200 3,200 3,200 001.000.41.521.10.11.00 Salaries 13,300 13,300 13,300 13,300 13,300 Total Expenditure Increase Decrease $ 227,400 $ 227,400 $ 227,400 $ 227,400 $ 227,400 Packet Pg. 51 Previously Discussed by Council (April 2021) 2.3.a Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ $ S $ S Total Revenue Increase(Decrease) $ $ $ $ $ Endine Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 001.000.39.508.00.00.00 Ending Fund Balance 138,400 138,400 138,400 138,400 138,400 111.000.68.508.30.00.00 Ending Fund Balance 14,900 14,900 14,900 14,900 14,900 421.000.74.508.00.00.00 Ending Fund Balance 15,400 15,400 15,400 15,400 15,400 422.000.72.508.00.00.00 Ending Fund Balance 9,800 9,800 9,800 9,800 9,800 423.000.75.508.00.00.00 Ending Fund Balance 38,400 38,400 38,400 38,400 38,400 511.000.77.508.00.00.00 Ending Fund Balance 4,000 4,000 4,000 4,000 4,000 512.000.31.508.00.00.00 Ending Fund Balance 6,500 6,500 6,500 6,500 6,500 Total Ending Fund Balance Increase(Decrease) $ 227,400 $ 227,400 $ 227,400 $ 227,400 $ 227,400 r+ Q Packet Pg. 52 2.3.a Previously Discussed by Council (April 2021) Budget Amendment for: April 20th, 2021 Item Description: The construction phase of the Citywide Pedestrian Crossing Enhancements project will begin in March 2021 and be complete by fall 2021. The budget amendment is needed to account for the additional funds programmed for the construction phase and the transfer of funds from decision packages 75 (2021 Pedestrian Safety) and 76 (2021 Traffic Signal Upgrades). The additional funds from the 112 Street Fund are the remaining grant funds from the 2018 Transportation Improvement Board (TIB) Complete Streets Grant. Department: Public Works Fund Name: MULTIPLE FUNDS Division: Engineering Title: Citywide Pedestrian Crossing Enhancements Preparer: Bertrand Hauss Budget Amendment Type Previously Discussed By Council Date of Discussion or Budget Approval? December 15, 2020 City Council Meeting How is this amendment funded? 100°/u Ending Fund Balance What is the nature of the expenditure? One -Time Is the Expenditure Operating or Capital? IC.pital Expenditure Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 112.000.68.595.61.65.00 Construction Sidewalks $ 44,000 $ S $ S 125.000.68.595.61.65.00 Construction Sidewalks 136,000 125.000.68.595.61.41.00 Professional Services - Sidewalks 39,000 125.000.68.542.64.41.67 Interfund Serv-Traffic Control 3,000 125.000.68.542.64.48.00 R&M - Traffic Control 47,000 Total Expenditure Increase Decrease $ 169,000 $ S $ Revenue Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 $ S $ S Total Revenue Increase(Decrease) $ $ S $ S Ending Fund Balance Increase (Decrease) Account Number Description 2021 2022 2023 2024 2025 112.000.68.508.30.00.00 Ending Fund Balance $ 44,000 $ S $ S 125.000.64.508.30.00.00 Ending Fund Balance 125,000 Total Ending Fund Balance Increase Decrease $ 169,000 $ S $ S Packet Pg. 53 gIDPBdgtRpt 4/7/2021 10:09:29AM Decision Package Budget Report City of Edmonds 2.3.a Date 07/28/2020 Budget Year 2021 Decision Package: 670-21022 - 2021 Traffic Calming Program Group Version Priority Duration mcain 0 1 One -Time Approval Status Approved Item Description 2021 Traffic Calming Program Justification The program consists in installing traffic calming devices, such as radar feedback signs, bulb -outs, striping modifications, and other methods. Describe All Funding Sources REET-1 Describe Future or Ongoinq Costs On -going cost in future years if additional stretches needing traffic calming devices are identified. Project Status (if applicable) Narrative Not Defined FISCAL DETAILS 2021 Capital Expenditures 126.000.68.542.64.41.67 INTERFUND SERV-TRAFFIC CONTRC 1,000.00 126.000.68.542.64.48.00 R & M - TRAFFIC CONTROL 14,000.00 Total Capital Expenditures 15,000.00 Total Expenditures 15,000.00 Revenues 001.000.349.18.000.00 CONTRACT SERVICES Total Revenues Net Budget -1,000.00 -1,000.00 14,000.00 r c m E c m E Q m m �L Q Q r N O F4 Packet Pg. 54 gIDPBdgtRpt Decision Package Budget Report 4/7/2021 10:09:29AM City of Edmonds Date 07/29/2020 Budget Year 2021 Decision Package: 670-21023 - 2021 Pedestrian Safety Group Version Priority Duration mcain 0 1 One -Time Approval Status Approved Item Description Installation of new pedestrian improvements such as Rectangular Rapid Flashing beacons (RRFB's), sidewalk, bulb -outs at intersections, red flashing beacons on Stop Signs and other signage and striping improvements throughout the City. Justification This program started in 2019 as part of an effort to improve pedestrian safety (one of the top 2019 Council priorities). Describe All Funding Sources RE ET-2 Describe Future or Ongoinq Costs Expected life cycle of beacons ranges from 10 to 15 years. Project Status (if applicable) This program has been on -going since 2019. FISCAL DETAILS Capital Expenditures 125.000.64.597.73.55.17 TRANSFER TO FUND 117 125.000.68.542.64.41.67 INTERFUND SERV-TRAFFIC CONTRC 125.000.68.542.64.48.00 R & M - TRAFFIC CONTROL Total Capital Expenditures Total Expenditures Revenues 001.000.349.18.000.00 CONTRACT SERVICES 117.200.397.73.125.00 INTERFUND TRANSFER Total Revenues Net Budget 2021 190.00 1,000.00 19, 000.00 20,190.00 20,190.00 -1,000.00 -190.00 -1,190.00 19, 000.00 r c m E c m E Q m m �L Q Q r N O F4 Packet Pg. 55 2.3.b ORDINANCE NO. XXXX AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4216 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, previous actions taken by the City Council require Interfund Transfers and increases in appropriations; and WHEREAS, state law requires an ordinance be adopted whenever money is transferred from one fund to another; and WHEREAS, the City Council has reviewed the amended budget appropriations and information which was made available; and approves the appropriation of local, state, and federal funds and the increase or decrease from previously approved programs within the 2021 Budget; and THEREFORE, WHEREAS, the applications of funds have been identified; THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. Section 1. of Ordinance No. 4216 amending the budget for the fiscal year 2021 is hereby amended to reflect the changes shown in Exhibits A, B, C, and D adopted herein by reference. 1 Packet Pg. 56 2.3.b Section 2. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum, and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. ATTEST/AUTHENTICATE: CITY CLERK, SCOTT PASSEY APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: IM JEFF TARADAY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. APPROVED: MAYOR, MIKE NELSON 2 Packet Pg. 57 2.3.b SUMMARY OF ORDINANCE NO. of the City of Edmonds, Washington On the day of , 2021, the City Council of the City of Edmonds, passed Ordinance No. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 4216 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this day of 12021. CITY CLERK, SCOTT PASSEY 3 Packet Pg. 58 2.3.b EXHIBIT "A": Budget Amendment Summary (April 2021) FUND NO. FUND DESCRIPTION 2021 BEGINNING FUND BALANCE REVENUE EXPENDITURES 2021 ENDING FUND BALANCE 001 GENERAL FUND 13,347,278 42,450,777 45,978,718 9,819,337 009 LEOFF-MEDICAL INS. RESERVE 459,105 300,000 467,140 291,965 012 CONTINGENCY RESERVE FUND 1,825,890 2,620 - 1,828,510 014 HISTORIC PRESERVATION GIFT FUND 11,517 5,010 5,900 10,627 016 BUILDING MAINTENANCE 210,222 - 210,222 - 017 MARSH RESTORATION & PRESERVATION FUND 864,490 20,000 844,490 018 EDMONDS HOMELESSNESS RESPONSE FUND 123,581 123,581 - 019 EDMONDS OPIOID RESPONSE FUND 28,445 - 28,445 - 104 DRUG ENFORCEMENT FUND 159,431 165,370 45,800 279,001 111 STREET FUND 941,253 1,722,360 2,187,430 476,183 112 COMBINED STREETCONST/IMPROVE 2,189,972 3,068,385 2,862,297 2,396,060 117 MUNICIPAL ARTS ACQUIS. FUND 599,272 165,060 236,880 527,452 118 MEMORIAL STREET TREE 20,534 270 - 20,804 120 HOTEL/MOTEL TAX REVENUE FUND 88,392 71,460 87,150 72,702 121 EMPLOYEE PARKING PERMIT FUND 87,233 25,240 26,880 85,593 122 YOUTH SCHOLARSHIP FUND 14,041 1,390 3,000 12,431 123 TOURISM PROMOTIONAL FUND/ARTS 75,353 24,000 29,900 69,453 125 PARK ACQ/IMPROVEMENT 2,000,717 1,282,050 1,601,298 1,681,469 126 SPECIAL CAPITAL FUND 1,946,015 1,285,240 2,053,911 1,177,344 127 GIFTS CATALOG FUND 316,106 103,930 100,900 319,136 130 CEMETERY MAINTENANCE/IMPROV 213,707 179,800 200,998 192,509 136 PARKS TRUST FUND 169,460 2,200 50,000 121,660 137 CEMETERY MAINTENANCE TRUST FD 1,107,524 29,220 25,000 1,111,744 138 SISTER CITY COMMISSION 10,408 10,120 11,900 8,628 140 BUSINESS IMPROVEMENT DISTRICT FUND 10,346 79,239 76,340 13,245 141 AFFORDABLE & SUPPORTIVE HOUSING FUND 65,112 65,000 - 130,112 142 EDMONDS CARES FUND - - - 211 LID FUND CONTROL - - - 231 2012 LTGO DEBT SERVICE FUND - 759,710 759,700 10 332 PARKS CONSTRUCTION 6,046,540 1,392,520 5,552,490 1,886,570 421 WATER 22,026,766 10,299,357 10,760,050 21,566,073 422 STORM 9,914,166 6,265,225 7,293,890 8,885,501 423 SEWER/TREATMENT PLANT 55,138,987 31,130,450 40,492,284 45,777,153 424 BOND RESERVE FUND 843,931 1,985,870 1,985,870 843,931 511 EQUIPMENT RENTAL FUND 8,712,017 1,331,100 1,429,954 8,613,163 512 Technology Rental Fund 734,287 1,204,880 1,257,909 681,258 617 FIREMEN'S PENSION FUND 137,533 67,270 96,167 108,636 Tota I s 130,439, 631 105,475,123 126, 062,004 109, 852, 750 �L sZ Q CV CD CV C w E t v M r Q Packet Pg. 59 EXHIBIT "B": Budget Amendments by Revenue (April 2021) 2.3.b FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4211 1/1/2021 Adopted Amendment Ord. # 3/10/2021 Proposed Amendment Ord. # 4/2021 2021 Amended Revenue Budget 001 General Fund $ 42,450,777 $ $ $ 42,450,777 009 Leoff-Medical Ins. Reserve 300,000 300,000 012 Contingency Reserve Fund 2,620 2,620 014 Historic Preservation Gift Fund 5,010 5,010 016 Building Maintenance Fund - - 017 Marsh Restoration & Preservation Fund 018 Edmonds Homelessness Response Fund 019 Edmonds Opioid Response Fund - - 104 Drug Enforcement Fund 165,370 165,370 111 Street Fund 1,722,360 1,722,360 112 Combined Street Const/Improve 3,048,185 20,200 3,068,385 117 Municipal Arts Acquis. Fund 165,060 - 165,060 118 Memorial Street Tree 270 270 120 Hotel/Motel Tax Revenue Fund 71,460 71,460 121 Employee Parking Permit Fund 25,240 25,240 122 Youth Scholarship Fund 1,390 1,390 123 Tourism Promotional Fund/Arts 24,000 24,000 125 ParkAcq/Improvement 1,282,050 1,282,050 126 Special Capital Fund 1,285,240 1,285,240 127 Gifts Catalog Fund 103,930 103,930 130 Cemetery Maintenance/Improv 179,800 179,800 136 Parks Trust Fund 2,200 2,200 137 Cemetery Maintenance Trust I'd 29,220 29,220 138 Sister City Commission 10,120 10,120 140 Business Improvement District Fund 79,239 79,239 141 Affordable and Supportive Housing Fund 65,000 65,000 142 Edmonds CARES Fund - - 211 Lid Fund Control - - 231 2012 LTGO Debt Service fund 759,710 759,710 332 Parks Construction 1,392,520 1,392,520 421 Water 10,299,357 - 10,299,357 422 Storm 6,012,300 252,925 6,265,225 423 Sewer/Treatment Plant 28,131,150 2,999,300 31,130,450 424 Bond Reserve Fund 1,985,870 - 1,985,870 511 Equipment Rental Fund 1,331,100 1,331,100 512 Technology Rental Fund 1,204,880 1,204,880 617 Firemen's Pension Fund 67,270 - 67,270 Totals $ 102,202,698 $ 3,272,425 $ $ 105,475,123 C d E C E Q d 7 m �L CL Q N O N �L 0. Q N O N 4i C d E t 0 M r Packet Pg. 60 EXHIBIT "C": Budget Amendments by Expenditure (April 2021) 2.3.b FUND NO. FUND DESCRIPTION Adopted Budget Ord. #4211 1/1/2021 Adopted Amendment Ord. # 3/10/2021 Proposed Amendment Ord. # 4/2021 2021 Amended Expenditure Budget 001 General Fund $ 45,179,468 $ 610,850 $ 188,400 $ 45,978,718 009 Leoff-Medical Ins. Reserve 467,140 - - 467,140 012 Contingency Reserve Fund - - 014 Historic Preservation Gift Fund 5,900 5,900 016 Building Maintenance Fund 210,222 - 210,222 017 Marsh Restoration & Preservation Fund - 20,000 20,000 018 Edmonds Homelessness Response Fund 123,581 - 123,581 019 Edmonds Opioid Response Fund 28,445 28,445 104 Drug Enforcement Fund 45,800 - 45,800 111 Street Fund 2,172,530 14,900 2,187,430 112 Combined Street Const/Improve 2,781,828 36,469 44,000 2,862,297 117 Municipal Arts Acquis. Fund 236,880 - - 236,880 118 Memorial Street Tree - - 120 Hotel/Motel Tax Revenue Fund 87,150 87,150 121 Employee Parking Permit Fund 26,880 26,880 122 Youth Scholarship Fund 3,000 3,000 123 Tourism Promotional Fund/Arts 29,900 - 29,900 125 ParkAcq/Improvement 1,428,736 47,562 125,000 1,601,298 126 Special Capital Fund 1,761,841 292,070 2,053,911 127 Gifts Catalog Fund 100,900 - 100,900 130 Cemetery Maintenance/Improv 200,998 200,998 136 Parks Trust Fund 50,000 50,000 137 Cemetery Maintenance Trust I'd 25,000 25,000 138 Sister City Commission 11,900 11,900 140 Business Improvement District Fund 76,340 76,340 141 Affordable and Supportive Housing Fund - - 142 Edmonds CARES Fund 211 Lid Fund Control - - 231 2012LTGO Debt Service Fund 759,700 - 759,700 332 Parks Construction 5,360,378 192,112 - 5,552,490 421 Water 10,578,596 136,054 45,400 10,760,050 422 Storm 6,847,783 406,307 39,800 7,293,890 423 Sewer/Treatment Plant 35,634,329 4,789,555 68,400 40,492,284 424 Bond Reserve Fund 1,985,870 - - 1,985,870 511 Equipment Rental Fund 1,292,815 53,139 84,000 1,429,954 512 Technology Rental Fund 1,251,409 - 6,500 1,257,909 617 Firemen's Pension Fund 96,167 96,167 Totals $ 118,861,486 $ 6,564,118 1 $ 636,400 1 $ 126,062,004 �L 0. Q N O N 4i C d E t 0 M r Q Packet Pg. 61 EXHIBIT "D": Budget Amendment Summary (April 2021) 2.3.b Fund Number Proposed Amendment Change in Revenue Proposed Amendment Change in Expense Proposed Amendment Change in Ending Fund Balance 001 188,400 (188,400) 017 20,000 (20,000) 111 14,900 (14,900) 112 44,000 (44,000) 125 125,000 (125,000) 421 45,400 (45,400) 422 39,800 (39,800) 423 68,400 (68,400) 511 84,000 (84,000) 512 6,500 (6,500) Total Change 636,400 (636,400) �L Q Q r N O N C N E t V M r Q Packet Pg. 62 2.4 City Council Agenda Item Meeting Date: 04/13/2021 PFD Financial Presentation Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The Edmonds Public Facilities District, per our Contingent Loan Agreement, is to make periodic financial reports to Council. Staff Recommendation Presentation only, no action is necessary. Narrative: Staff from the EPFD will give a financial presentation to Council. This is a follow-up to the presentation given at March's Finance Committee meeting. Packet Pg. 63