The URL can be used to link to this page

2020-11-12 City Council - Full S Agenda-27221 o Agenda Edmonds City Council V'J Hv FINANCE COMMITTEE - SPECIAL ZOOM VIRTUAL ONLINE MEETING EDMONDS CITY COUNCIL MEETINGS WEB PAGE, HTTP://EDMONDSWA.IQM2.COM/CITIZENS/DEFAULT.ASPX, EDMONDS, WA 98020 NOVEMBER 12, 2020, 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/91467152084 OR JOIN BY DIAL -UP PHONE: US: +1 253 215 8782 WEBINAR ID: 914 6715 2084 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. Waterfront Center Project Update (10 min) 2. September 2020 Quarterly Financial Report (15 min) ADJOURN Edmonds City Council Agenda November 12, 2020 Page 1 2.1 City Council Agenda Item Meeting Date: 11/12/2020 Waterfront Center Project Update Staff Lead: Angie Feser (PRCS) and Dave Turley (Finance) Department: Parks, Recreation & Cultural Services Preparer: Scott Passey Background/History The Waterfront Center project is nearing completion with late November slated for building occupancy. This presentation to the Finance Committee is an update of the construction project, Senior Center programming, project funding and future plans and how these were impacted by the COVID-19 pandemic this year. The PowerPoint presentation is attached. Staff Recommendation Presentation only. No staff recommendation. Narrative <Type or insert text here> Attachments: Waterfront Center Update Presentation 11-10-2020 Packet Pg. 2 EDMONDS Waterfront Center Connecting & Enriching Our Community Daniel Johnson Edmonds Waterfront Center �� CEO Home Delivered meals 7-day week 0 r_ Tele-health with MSW & RN - Regular check -in calls to members Online programs: 300-400 participants / wk New County SHIBA contract — 25 advisors Tech help for Seniors — expanding On-line intergenerational Triva All programs & services free Packet Pg. 4 instruction Update MMONoE d fiff Cent on Connecting & Enriching Our Comm iWatertr Second floor complete 3 First floor— finishing north stair Testing systems Final inspections underway Certificate of Occupancy by end of Nov Virtual Ribbon cutting in December TBD Packet Pg. 5 CM CD N CD z -lz m Packet Pg. 6 ■i NNFAM i I� IN 0 ^Now -- I Packet Pg. 8 2.1.a !r- Packet Pg. 9 1 r-1 Raised $14.2M toward $16.5M goal To date received 98% of pledges $375,000 in private lending $2M Construction Line of Credit Recent gift $50K for solar + $50K matching Will continue fundraising until last dollar is raised a Packet Pg. 10 LOOKin Continue / tele-health expand online program offerings & COVID-19 Safety Protocol Opening based on State and Snohomish County Health Department guidelines Preparing for year of restricted use Bank extended interest only payment through 2021 a Packet Pg. 11 0 EDMONDS Waterfront Center _ Connoeting & Enriching Qur Community e' I!' r:� WE 1L.�� ■� ■�� ■ i� eta rl w 0 L -- a C U c O IC R O N O N lob 0 0 c d rn m a r Q. a� c m U rr +, - - a" — — -41t ."` - Packet Pg. 12 2.2 City Council Agenda Item Meeting Date: 11/12/2020 September 2020 Quarterly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Scott Passey Background/History N/A Staff Recommendation Review and move to full council for presentation. Narrative September 2020 Quarterly Financial Report. Upcoming Budget Schedule: November 17 Presentation on General Fund Revenue Sources Presentation of Property Tax Ordinance Public Hearing on Property Taxes Public Hearing on the Budget Council Deliberation and opportunity to propose changes to the budget November 24 Public Hearing on the Budget Council Deliberation and opportunity to propose changes to the budget Potential adoption of the budget December 1 Adoption of budget (if not already adopted) December 8 Adoption of budget (if not already adopted) Attachments: Complete September Quarterly Report Jan -Sept P&L Packet Pg. 13 2.2.a INSIDE THIS ISSUE: Revenues By Fund Summary Expenditures By Fund Summary General Fund Revenues Expenditures By Fund Detail Gen. Fund Depart- ment Expenditures Investment Portfolio Fund Balance Overview Below: The COVID pandemic continues to threaten the health and economic vitality of people around the world. 1 4 Summary of Operating Funds: Revenues 1 The Financial Management Report is a summary of the City's 2 preliminary operating results for the nine months ended Sept. 30,2020. 61 12 J32 Revenue Highlights: • The coronavirus pandemic continues to have devastat- ing effects on the local and national economies, with area unemployment hover- ing around 8.5% and many area governments experi- encing General Fund reve- nue declines of 15% or more. Fortunately, Ed- monds is faring better than most of our neighbors. Overall General Fund revenues of $26.98 million are only 5.8% be- hind last year, and only 6.9% be- hind budget. • Collections of Retail Sales Taxes, the City revenue perhaps most af- fected by the pandemic, have per- formed surprisingly well. Year to date Sales Tax revenues COV I D-1•9 _5 CAL.425.38-348 FOR SNOHOMISH COUNTY UPDATES ti4 ": WIV %H W 6noli:':Lary are only behind our budgeted amount by 4.7%, and more surpris- ingly, we are behind last year's actual collections through 9/30 by only 5.7%. This year's collec- tions of $5.9 million are only $358,342 less than last year. (page 3). This contrasts significantly With our neighboring cities, some of whom Above: The City of Edmonds has distrib- uted well over $1 million in relief grants to local businesses and individuals affect- ed by the Pandemic. have forecast a 15% - 20% decline in sales tax revenues for 2021. Revenues by Category: General Fund revenues for Q 1-3 2020 are higher than Q1-3 2019 in the categories of Licenses and Permits, and Intergovern- mental Revenues. General Fund revenues are lower than last year at this time in the categories of Taxes; Charges for Goods and Services, Fines and Penalties; and Other Miscellaneous revenues. Considering the devastating effect the Coronavirus has had on the economy, Ed- monds' revenue situation remains favora- ble by comparison. A more detailed breakdown of infor- mation for City revenues can be found be- ginning on page 3. to Preliminary Financial Management Report as of September Packet Pg. 14 2.2.a Top Right: Edmonds LEAPS into action to help families with school age kids, providing daytime programs so that parents can work without having to manage kids at home simultaneously. Bottom Right: Walkable Main Street has been a popular program that closed downtown Main Street to vehicles oni Saturdays and Sun- days, from mid -June into November. Curbside dining was also allowed, which provided a much -needed shot in the arm for restaurants dealing with the COVID pandemic. LEARNING ENH Er ACTIVITIES Summary of Expenditures L5oL5oL;JoLr a MW IANCEMENT PROGRAM EANWM A safe, supervised, and supporting Q environment for distance learning • General Fund expenditures for the I nine months ended September 30 are $31.1 million, or a full 14.7% under the budgeted amount for I that period, a good sign that the city will be able to live within its I means during the current reces- sion. General Fund expenses by sub - fund and line item categories are on page 6 and expenses by depart- ment are on pages 13-16. Every department in the General Fund is at or near budget at September 30, and the General Fund as a whole has spent only 63% of its annual budget. This same information can be found in graphical form on pages 23-31. • Special Revenue Funds during the I first three -fourths of the year have only spent 43% of their annual _ expense budget. This is partly be- 1 cause most of our summer construc- tion work does not get billed until later in the year, and it is also a result of a major capital project —Civic Field being placed on hold. Additional Spe- cial Revenue Fund expenditure infor- mation can be found on pages 6-8. • The total fund balance for the General Fund and Subfunds at September 30, 2020 is $14.96 million, or approxi- mately 30% of the 2020 expenditure budget for those funds. Other City Highlights • During 2020 the City will be distrib- uting nearly $1.5 million to local busi- nesses and individuals. Much of this has been earmarked for grants to the City's most vulnerable residents, in- cluding lower income residents who are the most hard hit by unemploy- ment and increased expenses brought on by the crisis. Preliminary Financial Management Report as of September Packet Pg. 15 I 2.2.a I Page 1 of 1 C PTY OF EDMO NDS REVENUES BY FUND - SUMMARY Fund 2020 Amended 9/30/2019 9/30/2020 Amount No. Title Budget Revenues Revenues Remaining %Receives 001 GENERAL FUND $ 43,803,858 $ 28,633,850 $ 26,979,585 $ 16,824,273 62 009 LEOFF-MEDICAL INS. RESERVE 437,980 212,500 212,500 225,480 49 O l l RISK MANAGEMENT RESERVE FUND - - - 0 012 CONTINGENCY RESERVE FUND 56,140 - 56,140 0 014 HISTORIC PRESERVATION GIFT FUND 5,230 2,500 2,500 2,730 48 O 017 MARSH RESTORATION & PRESERVATION FUND - 280,187 100 (100) 0 d 104 DRUG ENFORCEMENT FUND 165,390 38,670 64,352 101,038 39 Ill STREET FUND 1,912,768 1,312,593 1,324,391 588,377 69 t� 112 COMBINED STREET CONST/IMPROVE 2,747,881 1,560,252 1,605,788 1,142,093 58 R C 117 MUNICIPAL ARTSACQUIS. FUND 263,576 91,737 32,521 231,055 12 IL 118 MEMORIAL STREET TREE 750 533 437 313 58 L 120 HOTEL/MOTEL TAX REVENUE FUND 98,630 73,837 47,927 50,703 49 d 121 EMPLOYEE PARKING PERMIT FUND 27,270 14,366 11,889 15,381 44 CY 122 YOUTH SCHOLARSHIP FUND 1,790 393 292 1,498 16 N 123 TOURISM PROMOTIONAL FUND/ARTS 34,450 24,655 16,575 17,875 48 N 125 REAL ESTATE EXCISE TAX 2 1,436,090 1,156,769 1,112,754 323,336 77 L 4) 126 REAL ESTATE EXCISE TAX 1 1,453,520 1,168,224 1,106,850 346,670 76 d 127 GIFTS CATALOG FUND 145,050 104,971 45,176 99,874 31 d 130 CEMETERY MAINTENANCE/IMPROVEMT 184,610 177,551 111,789 72,821 61 N 136 PARKS TRUST FUND 6,390 4,439 3,599 2,791 56 137 CEMETERY MAINTENANCE TRUST FD 54,210 44,863 32,929 21,281 61 N Q' 138 SISTER CITY COMMISSION 10,380 6,255 2,750 7,630 26 140 BUSINESS IMPROVEMENT DISTRICT 79,209 67,347 63,142 16,067 80 L 141 AFFORDABLE AND SUPPORTIVE HOUSINGFUND - - 50,924 (50,924) 0 142 EDMONDS CARES FUND 1,265,100 - 1,265,100 0 Cy 211 L.I.D. FUND CONTROL 12,400 30,818 12,400 0 M 231 2012 LT GO DEBT SERVICE FUND 738,400 53,388 47,291 691,109 6 d 332 PARKS CAPITAL CONSTRUCTION FUND t 9,638,306 652,327 1,399,359 8,238,947 15 d to 411 COMBINED UTILITY OPERATION - 110,337 31,765 (31,765) 0 O r 421 WATER UTILITY FUND 11,116,270 7,534,017 7,479,807 3,636,463 67 422 STORM UTILITY FUND 2 6,720,466 4,243,560 4,582,015 2,138,451 68 C 423 SEWER/WWTP UTILITY FUND 3 25,261,935 10,305,436 13,927,175 11,334,760 55 V 424 BOND RESERVE FUND 1,988,100 625,603 616,551 1,371,549 31 r = d 511 EQUIPMENT RENTAL FUND 1,746,160 1,404,137 1,425,297 320,863 82 t 512 TECHNOLOGY RENTAL FUND 1,202,963 830,847 904,475 298,488 75 617 FIREMEN'S PENSION FUND 72,620 53,545 54,747 17,873 75 Q $ 112,687,892 $ 60,820,504 $ 63,2979251 $ 49,390,641 56 Difference primarily due to the Edmonds Waterfront Development Grant received in July of 2020. 2 Difference primarily due to a 9.5%increase in storm rate. 3 Differences primarily due to WWTP Contributed Capital billings to their partners. 1 I Packet Pg. 16 1 I 2.2.a I Page 1 of l C ITY O F EDMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2020 Amended 9/30/2019 9/30/2020 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 49,044,056 $ 31,411,462 $ 31,099,506 $ 17,944,550 630 009 LEOFF-MEDICAL INS. RESERVE 467,140 311,959 188,748 278,392 400 014 HISTORIC PRESERVATION GIFT FUND 5,900 5,533 - 5,900 00 018 EDMONDS HOMELESSNESS RESPONSE FUND 100,000 1,862 - 100,000 00 019 EDMONDSOPI01D RESPONSE FUND 21,555 100,000 - 21,555 01, 104 DRUG ENFORCEMENT FUND 45,800 - 30,332 15,468 66° Q III STREET FUND 2,199,717 1,477,762 1,555,484 644,233 d 710/ 112 COMBINED STREET CONST/IMPROVE 2,717,463 1,185,539 900,136 1,817,327 330/ t� 117 MUNICIPAL ARTS ACQUIS. FUND 243,880 33,091 20,200 223,680 80, 120 HOTEL/MOTEL TAX REVENUE FUND 128,250 59,788 39,007 89,243 30 LL 121 EMPLOYEE PARKING PERMIT FUND 26,880 - 632 26,248 20, >- L 122 YOUTH SCHOLARSHIP FUND 3,000 2,702 450 2,550 1501 ea 123 TOURISM PROMOTIONAL FUND/ARTS 33,900 10,474 3,509 30,391 100/ CY 125 REAL ESTATE EXCISE TAX 2 3,610,520 1,169,323 1,165,383 2,445,137 320, p N 126 REAL ESTATE EXCISE TAX 1 3,401,093 1,079,262 1,245,824 2,155,269 370/ N 127 GIFTSCATALOGFUND 113,782 40,840 64,883 48,899 570/ N 130 CEMETERY MAINTENANCE/IMPROVEMT 195,787 146,370 133,042 62,745 680/ E O 136 PARKS TRUST FUND - 4,935 - - 09 Q. d 138 SISTER CITY COMMISSION 11,900 6,775 11 11,889 00, 140 BUSINESS IMPROVEMENT DISTRICT 80,510 61,572 46,035 34,475 570/ O 142 EDMONDS CARES FUND 1,265,100 - 816,165 448,935 650/ 2- 211 L.I.D. FUND CONTROL 231 2012 LT GO DEBT SERVICE FUND 332 PARKS CAPITAL CONSTRUCTION FUND 421 WATER UTILITY FUND 422 STORM UTILITY FUND 423 SEWER/WWTP UTILITY FUND EM,on �7�I77oiy 7ola[�1�17 511 EQUIPMENT RENTAL FUND 512 TECHNOLOGY RENTAL FUND 617 FIREMEN'S PENSION FUND 12,400 - - 12,400 00/ 738,400 53,388 47,291 691,109 60 13,013,343 134,932 963,763 12,049,580 70 12,809,352 7,140,372 8,102,729 4,706,623 630/ 10,831,951 3,596,458 6,252,778 4,579,173 5M 32,767,560 8,471,145 14,546,529 18,221,031 440 1,988,130 625,592 616,542 1,371,588 310 3,170,398 1,101,569 786,695 2,383,703 250/ 1,454,784 656,143 807,205 647,579 550 78,700 118,580 61,772 16,928 780 $ 140,581,251 $ 59,007,427 $ 69,494,651 $ 71,086,600 49" 2 Packet Pg. 17 2.2.a Page I of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMSPROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 4 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 WATER UTILITY TAX 11 SEWERUTILITYTAX 12 STORMWATERUTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABS TAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LIC INS ES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE -FINGERPRINTING 20 AMUSEMENTS 21 VENDING MACHINE/CONCESSION 22 FRANCHISE AGREEMENT -COMCAST 23 FRANCHISE FEE-EDUCATION/GOVERNMENT 24 FRANCHISE AGREEMENT -VERIZON/FRONT IER 25 OLYMPIC VIEW WATER DISTRICT FRANCHISE 26 GENERAL BUSINESS LICENSE 27 DEV SERV PERMIT SURCHARGE 28 NON-RESIDENT BUS LICENSE 29 RIGHT OF WAY FRANCHISE FEE 30 BUILDING STRUCTURE PERMITS 31 ANIMAL LICENSES 32 STREET AND CURB PERMIT 33 OTRNON-BUSLIC/PERMITS INTERGOVERNMENTAL: 34 DOI 15-0404-0-1-754 - BULLET PROOF VEST 35 NCHIP GRANT 36 WA ASSOC OF SHERIFFS TRAFFIC GRANT 37 TARGET ZERO TEAMS GRANT 38 DOCKSIE DRILLS GRANT REIMBURSE 39 HIGH VISIBILITY ENFORCEMENT 40 STATE GRANTS- BUDGET ONLY 41 PUD PRIVILEDGE TAX 42 ARCHIVES AND RECORDS MANAGEMENT 43 STATE GRANT FROM OTHER JUDICIAL AGENCIES 44 SCHOOL ZONE 45 WA STATE TRAFFIC COMM GRANT 46 MVET/SPECIAL DISTRIBUTION 47 WA91INGTON STATE ARTS COMMISSION 48 SHORELINE MASTER PROGRAM DOE 49 TRIAL COURT IMPROVEMENT 50 CRIMINAL JUSTICE -SPECIAL PROGRAMS 51 MARIJUANA ENFORCEMENT 52 MARIJUANA EXCISE TAX DISTRIBUTION 53 DUI - CITIES 54 LIQUOR EXCISE TAX 55 LIQUOR BOARD PROFITS 56 MISCELLANEOUS INT ERLOCAL REVENUE 57 VERDANT INTERLOCAL GRANTS 58 POLICE TRAINING CLASSES 59 FIRST RESPONDERS FLEX FUND 60 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 10,737,617 $ 5,766,919 $ 5,785,298 $ 4,952,319 540/( 4,112,031 2,229,587 2,258,817 1,853,214 5501( 500 243 26 474 501( 8,450,000 6,278,722 5,920,380 2,529,620 700/( 7,600 8,013 5,629 1,971 740/c 760,500 596,288 590,153 170,347 780/( 1,684,800 1,315,484 1,316,801 367,999 780/c 579,600 452,054 510,729 68,871 880/( 348,800 265,244 275,790 73,010 790/( Q 1,148,400 888,235 812,013 336,387 710/( 896,600 640,061 574,385 322,215 640/( 471,900 353,189 386,876 85,024 820/( v 822,200 600,762 602,599 219,601 730/( C 823,900 613,426 528,163 295,737 640/( C 55,200 43,406 37,754 17,446 680/( jL 40 199 449 (409) 11230/c >, 280,900 212,124 226,105 54,795 800/( d 31,180,588 20,263,957 19,831,968 11,348,620 64% R 250 185 315 (65) 3 1260/( (J 700 495 80 620 110/( o 6,000 4,675 - 6,000 0% p 50,000 52,492 6,526 43,474 130/( L 682,200 504,843 511,351 170,849 750/( d 41,000 31,102 30,154 10,846 740/( £ 100,600 72,818 56,323 44,277 560/( d 358,200 258,588 255,690 102,510 710/( fl. 116,300 93,611 170,045 (53,745) 1460/( CO) 63,700 53,559 50,430 13,270 790/c 64,800 40,200 - 64,800 00/( G 13,500 15,460 - 13,500 00/c Q. 675,600 496,005 528,805 146,795 780/( 24,380 9,323 9,299 15,081 380/( 45,000 34,230 77,312 (32,312) 1720/( 18,500 16,667 12,928 5,572 70% 2,260,730 1,684,252 1,709,258 551,472 760% to 6,000 3,470 2,052 3,949 340/( - 14,616 - - 00/( - 2,285 - - 00/c 4,000 1,852 - 4,000 00/( - 4,138 559 (559) 00/c 7,100 3,501 1,623 5,477 230/( 18,000 - - 18,000 00/( 210,500 - 207,989 2,511 990/( - - 8,599 (8,599) 00/( - - 140 (140) 00/( - - 825 (825) 00/( - 2,594 - - 00/c 13,070 9,316 9,803 3,267 750/( - 5,000 - - 00/( - 7,165 - - 0°/ 16,740 12,658 12,114 4,626 720/( 45,600 33,546 35,117 10,483 770/( 500 - - 500 00/c 48,300 46,665 50,966 (2,666) 106°/ 6,000 4,434 4,448 1,552 740/( 231,500 167,210 191,593 39,907 830/( 338,200 255,686 253,877 84,323 750/( - 2,500 - - 00/( - 2,000 - - 00/( - 211 - - 00/( 1,000 814 4,001 (3,001) 4000/( 550 - - 550 00/c 947,060 579,661 783,705 163,355 830% 4 2020 Local Retail Sa/eslUse Tax revenues are $(358,342) lower than 2019 revenues Please also seepages pages 18 & 19. 3 Packet Pg. 18 1 I 2.2.a I Page 2 of 3 Title 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 FILING FEES 17 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 PROTECTION & EMS FOR DUI 24 FIRE DISTRICT #1 STATION BILLINGS 25 LEGAL SERVICES 26 ADULT PROBATION SERVICE CHARGE 27 BOOKING FEES 28 FIRE CONSTRUCTION INSPECTION FEES 29 EMERGENCY SERVICE FEES 30 EMS TRANSPORT USER FEE 31 FLEX FUEL PAYMENTS FROM STATIONS 32 ANIMAL CONTROL SHELTER 33 ZONING/SUBDIVISION FEE 34 PLAN CHECKING FEES 35 FIRE PLAN CHECK FEES 36 PLANNING 1 % INSPECTION FEE 37 S.E.P.A. REVIEW 38 CRITICAL AREA STUDY 39 DV COORDINATOR SERVICES 40 GYM AND WEIGHTROOM FEES 41 PROGRAM FEES 5 42 TAXABLE RECREATION ACTIVITIES 43 WINTER MARKET REGISTRATION FEES 44 BIRD FEST REGISTRATION FEES 45 INTERFUND REIMBURSEMENT -CONTRACT SVCS C ITY O F EDMO NDS REVENUES - GENERAL FUND 2020 Amended 9/30/2019 Budget Revenues $ 3,000 $ 3,259 600 573 11,000 11,086 300 79 300 53 11,000 8,688 1,000 1,031 100 311 100 50 25,100 - 600 - 1,000 845 500 - 125,000 173,072 1,400 - 85,000 68,892 21,000 19,140 30,000 38,074 126,800 63,275 195,000 163,600 _ 2 - 117 52,500 43,129 1,050 1,203 45,000 34,485 3,000 2,065 10,000 13,695 3,500 4,408 1,007,500 761,350 2,500 836 50 100 72,600 86,530 375,900 435,954 4,000 8,145 500 888 5,000 3,850 14,000 12,575 - 4,707 15,500 8,541 9/30/2020 Amount Revenues Remaining %Received 3,682 $ 120 5,107 7 65 235 2,358 589 66 9 411 205,765 56,685 5,795 36,753 149,144 58 47,791 1,183 31,603 1,997 17,682 3,147 784,324 1,880 60,065 211,993 14,870 2,220 12,897 3,083 (682) 480 5,893 293 235 (235) 8,642 411 34 91 25,100 600 589 500 (80,765) 1,400 28,315 15,205 30,000 90,047 45,856 (58) 4,709 (133) 13,397 1,004 (7,682) 353 223,176 620 50 12,535 163,907 (10,870) 500 2,780 1,103 12,417 123% 20% 46% 2% 220/ 0% 21% 59% 66% O 9% 0% w 0% �p 41% .� 0% 165% 00/ U- 67% 28% O 0% R 29% 3 76% CY 0% N 0% N 91% N 113% 70% E 67% �+ 177% y 90% N 78% 75% O 0% y 83% W 56% >, 372% y 0% 44% 7 92% Ci 0% y 20% 869,162 721,584 88,869 780,293 100/( 1,300 490 - 1,300 00/c 5,000 5,065 4,510 490 900/( 800 585 - 800 00/( 3,290,838 2,133,641 2,216,105 1,074,733 670/( 6,418,500 4,835,973 3,971,068 2,447,432 620/( 5 2020 Parks & Recreation Program Revenues are $(632,715) lower than 2019 revenues. 4 Packet Pg. 19 1 2.2.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2020 Amended 9/30/2019 9/30/2020 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 OTHER CRIMINAL TRAF MISDEM PEN 14 CRIMINAL TRAFFIC MISDEMEANOR 8/03 15 CRIMINAL CONVICTION FEE CT 16 CRIM CONV FEE CT 17 OTHER NON-T RAF MISDEMEANOR PEN 18 OTHER NON TRAFFIC MISD. 8/03 19 COURT DV PENALTY ASSESSMENT 20 CRIMINAL CONVICTION FEE CN 21 CRIM CONV FEE CN 22 PUBLIC DEFENSE RECOUPMENT 23 BANK CHARGE FOR CONV. DEFENDANT 24 COURT COST RECOUPMENT 25 BUS. LICENSE PERMIT PENALTY 26 MISC FINES AND PENALTIES MISCELLANEOUS: 27 INVESTMENT INTEREST 28 INTEREST ON COUNTY TAXES 29 INTEREST - COURT COLLECTIONS 30 PARKING 31 SPACE/FACILITIES RENTALS 32 BRACKET ROOM RENTAL 33 LEASESLONG-TERM 34 DONATION/CONTRIBUTION 35 PARKSDONATIONS 36 BIRD FEST CONTRIBUTIONS 37 POLICE CONTRIBUTIONS FROM PRIV SOURCES 38 SALE OF JUNK/SALVAGE 39 SALES OF UNCLAIM PROPERTY 40 CONFISCATED AND FORFEITED PROPERTY 41 OTHER JUDGEMENT/SETTLEMENT 42 POLICE JUDGMENTS/RESTITUTION 43 CASHIERS OVERAGES✓SHORTAGES 44 OTHER MISC REVENUES 45 SMALL OVERPAYMENT 46 NSF FEES - PARKS & REC 47 NSF FEES - MUNICIPAL COURT 48 L&I STAY AT WORK PROGRAM 49 FLEX -PLAN SERVICES FORFEITURES 50 NSF FEE - DEVEL SERV DEPT 51 US BANK REBATE TRANSFERS -IN: 52 INTERFUND TRANSFER FROM 511 53 TRANSFER FROM FUND 127 TOTAL GENERAL FUND REVENUE $ 4,000 $ 2,945 $ 1,002 $ 2,998 250/c 241,000 170,462 89,134 151,866 370/( 19,000 14,232 10,608 8,392 560/( 20,000 13,047 7,948 12,052 400/( 1,000 1,371 760 240 760/( 2,000 1,143 1,088 912 540/( 147,000 112,395 59,603 87,397 410/( 2,500 2,272 794 1,706 32°/ 7,000 7,641 6,958 42 990/( 700 355 190 510 270/( 200 52 35 165 170/( 1,500 1,614 1,901 (401) 1270/( 140 - - 140 00/( 30,000 23,224 17,782 12,218 590/( 3,600 2,102 1,849 1,751 5101( 1,000 520 455 545 460/( 100 (2,792) 37 63 370/( 13,100 18,780 6,293 6,807 480/( 600 296 955 (355) 1590/( 1,600 723 615 985 380/( 500 240 82 418 160/( 16,000 9,264 6,202 9,798 390/( 14,000 10,702 6,946 7,054 500/( 6,000 4,403 2,921 3,079 490/( 10,100 5,150 - 10,100 00/( 300 1,208 - 300 00/( 542,940 401,348 224,158 318,782 41°/ 399,400 314,896 252,060 147,340 630/( 53,440 20,474 11,507 41,933 220/( 50,950 6,670 5,746 45,204 110/( - 75 - - 0°/ 153,000 127,627 20,404 132,596 130/( 2,100 1,610 380 1,720 180/( 205,000 151,156 122,746 82,254 600/( 22,500 3,473 910 21,590 40/c 3,500 3,050 920 2,580 260/( 2,000 1,597 635 1,365 320/( 5,000 10,621 100 4,900 20/c 300 68 - 300 00/( 3,000 1,764 3,566 (566) 1190/( 2,000 - - 2,000 00/c 2,000 3 1,344 656 670/( 200 429 238 (38) 1190/( - (71) 16 (16) 00/c 5,000 193,535 13,467 (8,467) 2690/( 100 48 34 66 340/( 100 30 30 70 300/( 150 112 142 8 950/( - 10,483 - - 00/( - 370 - - 00/c - - 30 (30) 00/( 8,500 7,490 7,251 1,249 850/( 918,240 855,510 441,527 476,713 480% 1,500,000 - - 1,500,000 00/( 35,800 13,150 17,900 17,900 5001( 1,535,800 13,150 17,900 1,517,900 1 °/ $ 43,803,858 $ 28,6339850 $ 26,979,585 $ 16,824,273 620% tv O CL O R C cc C iL 21 L R 3 CI 0 N O N N E O r N N 5 Packet Pg. 20 I 2.2.a I Page 1 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 17,066,688 $ 11,810,723 $ 12,375,788 $ 4,690,900 73 2 OVERTIME 491,580 589,679 441,861 49,719 90 3 HOLIDAY BUY BACK 262,020 8,449 5,394 256,626 2 4 BENEFITS 6,599,678 4,646,856 4,764,385 1,835,293 72 5 UNIFORMS 90,975 85,261 69,355 21,620 76 6 SUPPLIES 428,811 357,196 327,558 101,253 76 7 SMALL EQUIPMENT 161,262 121,904 128,614 32,648 80 8 PROFESSIONAL SERVICES 15,407,641 9,905,452 9,362,476 6,045,165 61 9 COMMUNICATIONS 169,795 116,464 105,525 64,270 62 10 TRAVEL 78,580 55,227 8,652 69,928 11 11 EXCISE TAXES 6,500 5,303 11,549 (5,049) 178 12 RENTAL/LEASE 1,825,110 1,379,043 1,356,050 469,060 74 13 INSURANCE 394,124 436,448 393,746 378 100 14 UTILITIES 531,525 405,362 370,411 161,114 70 15 REPAIRS& MAINTENANCE 297,010 443,589 495,737 (198,727) 167 16 MISCELLANEOUS 526,991 326,609 280,034 246,957 53 17 INTERGOVERNMENTAL PAYMENTS 75,000 75,000 75,000 - 100 18 INTERFUND SUBSIDIES 3,266,993 625,579 449,033 2,817,960 14 19 MACHINERY/EQUIPMENT 57,173 - 9,053 48,120 16 20 CONSTRUCTION PROJECTS 1,000,000 10,296 - 1,000,000 0 21 GENERAL OBLIGATION BOND PRINCIPAL 168,850 - - 168,850 0 22 OTHER INTEREST & DEBT SERVICE COSTS 500 - - 500 0 23 INTEREST ON LONG-TERM EXTERNAL DEBT 137,250 7,023 69,285 67,965 50 49,044,056 S 31,411,462 S 31,099,506 S 17,944,550 63 LEOFF-MEDICAL INS. RESERVE(009) 24 BENEFITS $ 206,650 $ 122,084 $ 108,192 $ 98,458 52 25 PENSION AND DISABILITY PAYMENTS 252,990 189,240 74,764 178,226 30 26 PROFESSIONAL SERVICES 7,000 180 5,793 1,207 83 27 MISCELLANEOUS 500 455 - 500 0 467,140 S 311,959 S 188,748 278,392 40 HISTORIC PRESERVATION GUT FUND (0 14) 28 SUPPLIES $ 100 $ - $ $ 100 0 29 PROFESSIONAL SERVICES 200 - 200 0 30 MISCELLANEOUS 5,600 5,533 5,600 0 5,900 5,533 S 5,900 0 EDMONDS HOMELESSNESS RESPONSEFUND (018) 31 PROFESSIONAL SERVICES $ 100,000 $ 1,862 $ $ 100,000 0 100,000 1,862 100,000 0 EDMO NDS O PIO ID RES PO NS E FUND (019) 32 INTERFUND SUBSIDIES $ 21,555 $ 100,000 $ - $ 21,555 0 21,555 100,000 s 21,555 0 DRUG ENFORCEMENT FUND (104) 33 PROFESSIONAL SERVICES $ 45,000 $ - $ $ 45,000 0 34 REPAIR/MAINT 800 800 0 35 MISCELLANEOUS - 30,332 (30,332) 0 45,800 30,332 15,468 66 F O Q. O C R C IL A L 4) eo Cl O N O N L d E d Q. d CO) 6 Packet Pg. 21 I 2.2.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent STREETFUND (111) 1 SALARIES AND WAGES $ 723,081 $ 432,245 $ 483,391 $ 239,690 67' 2 OVERTIME 18,400 39,193 32,748 (14,348) 178' 3 BENEFITS 309,539 205,261 238,670 70,869 77' 4 UNIFORMS 6,000 3,278 3,781 2,219 63' 5 SUPPLIES 263,000 209,893 135,304 127,696 51' 6 SMALL EQUIPMENT 20,000 2,279 684 19,316 3' 7 PROFESSIONAL SERVICES 27,930 7,501 2,307 25,623 8' 8 COMMUNICATIONS 4,500 5,340 5,570 (1,070) 124' 9 TRAVEL 1,000 - - 1,000 0' 10 RENTAL/LEASE 230,450 202,126 173,799 56,651 75' 11 INSURANCE 145,219 156,514 156,937 (11,718) 108' 12 UTILITIES 280,918 192,291 193,981 86,937 69' 13 REPAIRS&MAINTENANCE 52,000 19,890 49,147 2,853 95' 14 MISCELLANEOUS 13,000 1,662 3,250 9,750 25' 15 MACHINERY/EQUIPMENT 100,000 - 75,658 24,342 76' 16 GENERAL OBLIGATION BOND PRINCIPAL 4,170 - - 4,170 0' 17 INTEREST 510 289 255 255 50' COMBINED S TREET C O NS T/IMPROVE (112) 18 SALARIES AND WAGES 19 BENEFIT S 20 PROFESSIONAL SERVICES 21 REPAIR & MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 CONSTRUCTION PROJECTS 25 INTERGOVERNMENTAL LOANS 26 INTEREST MUNIC IPAL ARTS ACQUIS. FUND (117) 27 SUPPLIES 28 SMALL EQUIPMENT 29 PROFESSIONAL SERVICES 30 TRAVEL 31 RENTALILEASE 32 REPAIRS&MAINTENANCE 33 MISCELLANEOUS HO TEL /MO TEL TAX REVENUE FUND (120) 34 PROFESSIONAL SERVICES 35 MISCELLANEOUS 36 INTERFUND SUBSIDIES 37 MACHINERY/EQUIPMENT EMPLOYEE PARKING PERMIT FUND (121) 38 SUPPLIES 39 PROFESSIONAL SERVICES YOUTH SCHOLARSHIP FUND (122) 40 MISCELLANEOUS TOURISM PROMOTIONAL FUND/ARTS (123) 41 PROFESSIONAL SERVICES 42 MISCELLANEOUS $ 2,199,717 $ 1,477,762 $ 1,555,484 $ 644,233 71' $ $ 10,567 $ (10,567) 0' - 6,613 (6,613) 0' 586,130 253,980 143,083 443,047 24' 163,028 396,885 320,161 (157,133) 196' _ 8 (8) 0' 40,140 40,318 40,121 19 100' 1,853,975 419,842 305,428 1,548,547 16' 72,220 72,201 72,201 19 100' 1.970 2.313 1.952 18 99' $ 2,717,463 $ 1,185,539 $ 900,136 $ 1,817,327 33' $ 4,700 $ 922 $ 114 $ 4,586 2' 1,700 - 116 1,584 7' 228,500 28,896 18,503 209,997 8' 80 6 - 80 0' 2,000 - - 2,000 0' 300 - - 300 0' 6,600 3,268 1,466 5,134 22' $ 243,880 $ 33,091 $ 20,200 $ 223,680 8' $ 92,487 $ 57,205 $ 36,415 $ 56,072 39' 6,763 583 592 6,171 9' 4,000 2,000 2,000 2,000 50' 25,000 - - 25,000 0' $ 128,250 $ 59,788 $ 39,007 $ 89,243 30' $ 1,790 $ $ 632 $ 1,158 35' 25,090 - 25,090 0' $ 26,880 $ $ 632 $ 26,248 2' $ 3,000 $ 2,702 $ 450 $ 2,550 15' $ 3,000 $ 2,702 $ 450 $ 2,550 15' $ 33,900 $ 8,515 $ 3,509 $ 30,391 10' - 1,959 - - 0' $ 33,900 $ 10,474 $ 3,509 $ 30,391 10' O Q d w C R C IL L d ea 7 Cl O N O N L d M E d Q. d CO) 7 Packet Pg. 22 I 2.2.a I Page 3 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ 21,000 $ 34,096 $ 14,374 $ 6,626 68' 2 PROFESSIONAL SERVICES 479,831 137,745 263,944 215,887 55' 3 RENTAL/LEASE - 381 - - 0' 4 REPAIRS&MAINTENANCE 176,176 373,501 350,618 (174,442) 199' 5 INTERFUND SUBSIDIES 620 - - 620 0' 6 CONSTRUCTION PROJECTS 2,932,893 623,600 536,447 2,396,446 18' $ 3,610,520 $ 1,169,323 $ 1,165,383 $ 2,445,137 32' REAL ESTATE EXCISE TAXI (126) 7 PROFESSIONAL SERVICES 8 REPAIRS&MAINTENANCE 9 INTERFUND SUBSIDIES 10 LAND 11 CONSTRUCTION PROJECTS 12 GENERAL OBLIGATION BONDS 13 INTEREST GIFTS CATALOG FUND (127) 14 SUPPLIES 15 SMALL EQUIPMENT 16 PROFESSIONAL SERVICES 17 REPAIRS&MAINTENANCE 18 MISCELLANEOUS 19 INTERFUND SUBSIDIES C EM E=Y MAINTENANC UIMPRO VEMENT (130) 20 SALARIES AND WAGES 21 OVERTIME 22 BENEFIT S 23 UNIFORMS 24 SUPPLIES 25 SUPPLIES PURCHASED FOR INVENTORY/RESALE 26 SMALL EQUIPMENT 27 PROFESSIONAL SERVICES 28 COMMUNICATIONS 29 TRAVEL 30 RENTAL/LEASE 31 UTILITIES 32 REPAIRS&MAINTENANCE 33 MISCELLANEOUS PARKS TRUSTFUND (136) 34 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 35 SUPPLIES 36 TRAVEL 37 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 38 SUPPLIES 39 PROFESSIONAL SERVICES 40 MISCELLANEOUS EDMONDS CARES FUND (142) 41 PROFESSIONAL SERVICES LID FUND CONTROL (211) 42 INTERFUND SUBSIDIES 2012 LTGO DEBT SERVIC FUND (231) 43 GENERAL OBLIGATION BOND 44 INTEREST $ 883,267 $ 117,219 $ 582,937 300,330 66' 95,963 376,857 257,722 (161,759) 269' 142,736 14,013 12,963 129,774 9' 300,000 - - 300,000 0' 1,951,937 569,494 390,719 1,561,218 20' 24,220 - - 24,220 0' 2,970 1,680 1,484 1,486 50' $ 3,401,093 $ 1,079,262 $ 1,245,824 $ 2,155,269 37' $ 48,882 $ 25,259 $ 39,033 $ 9,849 80' - 574 - - 0' 6,500 - 600 5,900 9' 22,000 1,858 7,183 14,818 33' 600 - 168 432 28' 35,800 13,150 17,900 17,900 50' $ 113,782 $ 40,840 $ 64,883 $ 48,899 57' $ 97,476 $ 69,577 $ 68,905 $ 28,571 71' 3,500 3,101 558 2,942 16' 42,029 31,651 29,697 12,332 71' 1,000 225 - 1,000 0' 7,000 3,492 2,417 4,583 35' 20,000 13,712 14,279 5,721 71' - 1,246 1,184 (1,184) 0' 4,200 866 150 4,050 4' 1,700 1,378 1,261 439 74' 500 - - 500 0' 8,230 4,695 6,172 2,058 75' 5,652 3,434 3,296 2,356 58' 500 - - 500 0' 4,000 12,993 5,124 (1,124) 128' $ 195,787 $ 146,370 $ 133,042 $ 62,745 68' $ - $ 4,935 $ - $ - 0' $ - $ 4,935 $ - $ - 0' $ 1,500 $ 651 $ 11 $ 1,489 1' 4,500 2,705 - 4,500 0' 5,900 3,418 - 5,900 0' $ 11,900 $ 6,775 $ 11 $ 11,889 0' $ 11,850 $ 12,278 $ 9,476 $ 2,374 80' 66,035 47,065 34,286 31,749 52' 2,625 2,229 2,273 352 87' 80,510 61,572 46,035 34,475 57' $ 1,265,100 $ $ 816,165 $ 448,935 65' 1,265,100 816,165 448,935 65' $ 12,400 $ $ - $ 12,400 0' $ 12,400 $ $ - $ 12,400 0' $ 643,810 $ - $ - $ 643,810 0' 94,590 53,388 47,291 47,299 50' $ 738,400 $ 53,388 $ 47,291 $ 691,109 6' F O Q. C C IL d eo Cl 0 N 0 N L d E d Q. d CO) 8 Packet Pg. 23 I 2.2.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 323,349 $ 28,439 $ 339,616 $ (16,267) 105' 2 INTERFUND SUBSIDIES 112,920 - - 112,920 0' 3 CONSTRUCTION PROJECTS 12,577,074 106,493 624,147 11,952,927 5' $ 13,013,343 $ 134,932 $ 963,763 $ 12,049,580 7' WATER FUND (421) 4 SALARIES AND WAGES 5 OVERTIME 6 BENEFIT S 7 UNIFORMS 8 SUPPLIES 9 WAT ER 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 CONST RUCT ION PROJECTS 23 GENERAL OBLIGATION BONDS 24 REVENUE BONDS 25 INTERGOVERNMENTAL LOANS 26 INTEREST STORMFUND (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 $ 845,871 $ 583,056 $ 635,088 $ 210,783 75' 24,000 18,967 14,042 9,958 59' 363,882 263,139 240,113 123,769 66' 4,000 3,326 3,374 626 84' 150,000 48,477 82,698 67,302 55' 2,170,000 1,437,468 1,457,879 712,121 67' 170,000 100,408 131,727 38,273 77' 11,000 4,856 5,197 5,803 47' 1,753,804 639,767 977,347 776,457 56' 30,000 21,843 21,460 8,540 72' 200 - - 200 0' 1,649,700 1,231,489 1,141,355 508,345 69' 133,158 114,481 97,622 35,536 73' 52,865 55,096 52,541 324 99' 35,775 19,677 20,283 15,492 57' 75,830 222,638 19,881 55,949 26' 131,400 88,741 99,971 31,429 76' 650,870 206,313 204,067 446,803 31' 3,946,207 1,941,616 2,766,338 1,179,869 70' 2,800 - - 2,800 0' 370,960 - - 370,960 0' 25,840 25,839 25,839 1 100' 211,190 113,174 105,907 105,283 50' $ 12,809,352 $ 7,140,372 $ 8,102,729 $ 4,706,623 63' $ 728,080 $ 508,721 $ 465,837 $ 262,243 64' 6,000 30,127 10,247 (4,247) 171' 334,154 257,694 214,855 119,299 64' 6,500 4,964 6,437 63 99' 46,000 20,183 18,401 27,599 40' 4,000 3,653 1,629 2,371 41' 3,047,970 833,220 1,392,995 1,654,975 46' 3,200 4,060 4,241 (1,041) 133' 4,300 - - 4,300 0' 470,100 410,295 448,637 21,463 95' 270,830 182,980 203,197 67,633 75' 118,263 127,548 116,576 1,687 99' 11,025 8,572 8,975 2,050 81' 116,183 11,715 15,103 101,080 13' 158,100 118,077 117,342 40,758 74' 282,550 81,819 78,897 203,653 28' 4,758,296 897,798 3,035,064 1,723,232 64' 102,030 - - 102,030 0' 181,210 - - 181,210 0' 60,760 32,063 53,576 7,184 88' 122,400 62,969 60,769 61,631 50' $ 10,831,951 $ 3,596,458 $ 6,252,778 $ 4,579,173 58' O Q- C M C M O 7 C1 O N O N L d E d Q. d CO) 9 Packet Pg. 24 I 2.2.a I Page 5 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining '% Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 1,953,719 $ 1,329,064 $ 1,416,668 $ 537,051 73' 2 OVERTIME 95,000 71,367 75,731 19,269 80' 3 BENEFITS 854,294 580,897 610,307 243,987 71' 4 UNIFORMS 9,500 7,023 7,474 2,026 79' 5 SUPPLIES 421,000 232,648 276,687 144,313 66' 6 FUEL CONSUMED 60,000 30,834 14,928 45,072 25' 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 0' 8 SMALL EQUIPMENT 35,000 18,572 36,680 (1,680) 105' 9 PROFESSIONAL SERVICES 2,286,406 877,061 2,759,995 (473,589) 12P 10 COMMUNICATIONS 43,000 32,226 30,290 12,710 70' 11 TRAVEL 5,000 1,038 - 5,000 0' 12 EXCISE TAXES 978,000 806,192 716,462 261,538 73' 13 RENTAL/LEASE 311,966 258,336 243,714 68,252 78' 14 INSURANCE 182,121 186,110 174,140 7,981 96' 15 UTILITIES 1,540,685 754,978 697,646 843,039 45' 16 REPAIR & MAINTENANCE 745,630 310,271 150,052 595,578 20' 17 MISCELLANEOUS 127,650 66,062 61,964 65,686 49' 18 INTERFUND SUBSIDIES 7,197,114 603,173 2,584,681 4,612,433 36' 19 MACHINERY/EQUIPMENT - 33,647 83,575 (83,575) 0' 20 CONST RUCT ION PROJECTS 15,438,495 2,053,589 4,411,390 11,027,105 29' 21 GENERAL OBLIGATION BONDS 154,660 - - 154,660 0' 22 REVENUE BONDS 82,840 - - 82,840 0' 23 INTERGOVERNMENTAL LOANS 173,210 172,528 158,325 14,885 91' 24 INTEREST 68,270 40,516 33,421 34,849 49' 25 OTHER INT EREST & DEBT SERVICE COSTS - 5,015 2,399 (2,399) 0' $ 32,767,560 $ 8,471,145 $ 14,546,529 $ 18,221,031 44' BOND RFSERVEFUND (424) 26 REVENUE BONDS $ 755,020 $ - $ - $ 755,020 0' 27 INTEREST 1,233,110 625,592 616,542 616,568 50' $ 1,988,130 $ 625,592 $ 616,542 $ 1,371,588 3P O Q. d C C M L d t eo 7 C'1 0 N 0 N L d E fl. d CO) 10 Packet Pg. 25 I 2.2.a I Page 6 of 6 CITY OFEDMONDS EXPENDITURES BY FUND - DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 266,952 $ 195,163 $ 201,881 $ 65,071 76' 2 OVERTIME 2,000 8,081 824 1,176 41' 3 BENEFITS 112,598 84,072 83,912 28,686 75' 4 UNIFORMS 1,000 1,203 1,050 (50) 105' 5 SUPPLIES 130,000 81,129 54,905 75,095 42' 6 FUEL CONSUMED 1,000 - - 1,000 0' 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 243,000 122,870 89,058 153,942 37' 8 SMALL EQUIPMENT 58,000 2,002 1,140 56,860 2' 9 PROFESSIONAL SERVICES 46,750 3,729 3,974 42,776 9' 10 COMMUNICATIONS 3,000 1,722 1,672 1,328 56' 11 TRAVEL 1,000 255 - 1,000 0' 12 RENTAL/LEASE 12,750 10,275 9,240 3,510 72' 13 INSURANCE 27,848 30,167 40,270 (12,422) 145' 14 UTILITIES 14,500 10,945 11,359 3,141 78' 15 REPAIRS & MAINTENANCE 60,000 25,005 34,756 25,244 58' 16 MISCELLANEOUS 12,000 9,181 8,359 3,641 70' 17 INTERGOVERNMENTAL SERVICES 1,500,000 - - 1,500,000 0' 18 MACHINERY/EQUIPMENT 678,000 515,770 244,293 433,707 36' $ 3,170,398 $ 1,101,569 $ 786,695 $ 2,383,703 25' TECHNOLOGY RENTAL FUND (512) 19 SALARIES AND WAGES $ 369,264 $ 224,945 $ 215,189 $ 154,075 58' 20 OVERTIME 2,000 60 - 2,000 0' 21 BENEFITS 124,590 76,241 72,421 52,169 58' 22 SUPPLIES 5,000 3,436 7,500 (2,500) 150' 23 SMALL EQUIPMENT 137,700 36,892 94,263 43,437 68' 24 PROFESSIONAL SERVICES 309,810 9,996 68,799 241,011 22' 25 COMMUNICATIONS 58,770 42,160 48,743 10,027 83' 26 TRAVEL 1,500 359 207 1,293 14' 27 RENTAL/LEASE 7,490 6,250 6,149 1,341 82' 28 REPAIRS&MAINTENANCE 367,660 195,000 282,519 85,141 77' 29 MISCELLANEOUS 5,000 3,232 11,415 (6,415) 228' 30 MACHINERY/EQUIPMENT 66,000 57,571 - 66,000 0' $ 1,454,784 $ 656,143 $ 807,205 $ 647,579 55' FIREMEN'S PENSION FUND (617) 31 BENEFITS $ 23,000 $ 15,072 $ 14,405 $ 8,595 63' 32 PENSION AND DISABILITY PAYMENTS 54,500 103,508 46,359 8,141 85' 33 PROFESSIONAL SERVICES 1,200 - 1,007 193 84' $ 78,700 $ 118,580 $ 61,772 $ 16,928 78' TOTAL EXPENDITURE ALL FUNDS $ 140,581,251 $ 59,007,427 $ 69,494,651 $ 71,086,600 49' O C. d C C M L t eo C C'J 0 N 0 N L N E O d co 11 Packet Pg. 26 2.2.a Page 1 of 1 C ITY O F EDMO NDS EXPENDPTURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2020 Amended 9/30/2019 9/30/2020 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 $ 418,912 $ 316,066 $ 239,066 $ 179,846 57% 306,685 221,509 249,862 56,823 81% 740,691 403,027 476,486 264,205 64% 1,138,771 730,275 775,370 363,401 68% 726,962 527,401 554,592 172,370 76% Q 1,289,583 958,793 1,050,712 238,871 81% d W <0 912,540 656,534 646,093 266,447 71% 'V C 15,322,110 9,284,942 8,970,365 6,351,745 59% C 11,951,730 8,594,346 8,693,795 3,257,935 73% LL 761,493 424,210 408,834 352,659 54% L 4) 3,582,847 2,059,466 2,083,333 1,499,514 58% j C'1 4,594,969 3,147,119 2,706,435 1,888,534 59% p N 3,538,610 2,350,773 2,368,826 1,169,784 67% N 3,758,153 1,737,001 1,875,737 1,882,416 50% L 4) $ 49,044,056 $ 31,411,462 $ 31,099,506 $ 17,944,550 63% £ d 0. d CO) C ITY O F EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2020 Amended Budget 9/30/2019 Expenditures 9/30/2020 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 12,809,352 $ 7,140,372 $ 8,102,729 $ 4,706,623 63% STORM UTILITY FUND 10,831,951 3,596,458 6,252,778 4,579,173 58% SEWER/WWTP UTILITY FUND 32,767,560 8,471,145 14,546,529 18,221,031 44% BOND RESERVE FUND 1,988,130 625,592 616,542 1,371,588 31% $ 58,396,993 $ 19,833,566 $ 29,518,578 $ 28,878,415 51% 12 Packet Pg. 27 Page 1 of 4 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2020 Amended Budget 9/30/2019 Expenditures 9/30/2020 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES $ 191,224 $ 134,414 $ 142,751 $ 48,473 75% OVERTIME 1,000 - - 1,000 0% BENEFITS 95,736 73,110 73,981 21,755 77% SUPPLIES 2,500 1,642 1,544 956 62% SMALL EQUIPMENT 1,000 342 137 863 14% PROFESSIONAL SERVICES 62,160 79,552 3,977 58,183 6% COMMUNICATIONS 5,000 4,894 5,999 (999) 120% TRAVEL 17,500 2,589 587 16,913 3% RENTAL/LEASE 12,292 9,061 9,266 3,026 75% REPAIRS✓MAINTENANCE 500 121 645 (145) 129% MISCELLANEOUS 30,000 10,341 180 29,820 1% $ 418,912 $ 316,066 $ 239,066 $ 179,846 57% OFFICEOFMAYOR SALARIES $ 222,432 $ 164,090 $ 167,820 $ 54,612 75% BENEFITS 54,043 40,066 63,440 (9,397) 117% SUPPLIES 1,500 556 713 787 48% SMALL EQUIPMENT - - 4,199 (4,199) 0% PROFESSIONAL SERVICES 3,000 2,211 512 2,488 17% COMMUNICATION 1,400 827 920 480 66% TRAVEL 3,000 2,603 166 2,834 6% RENTAL/LEASE 16,860 9,381 11,880 4,980 70% MISCELLANEOUS 4,450 1,775 213 4,237 5% $ 306,685 $ 221,509 $ 249,862 $ 56,823 81% HUMAN RESOURCES SALARIES $ 356,658 $ 238,491 $ 266,862 $ 89,796 75% OVERTIME - 197 3,079 (3,079) 0% BENEFITS 142,458 77,803 107,586 34,872 76% SUPPLIES 18,556 3,355 3,490 15,066 19% SMALL EQUIPMENT 300 2,762 893 (593) 298% PROFESSIONAL SERVICES 136,471 36,036 41,809 94,662 31% COMMUNICATIONS 1,550 938 937 613 60% TRAVEL 1,000 668 500 500 50% RENTAL/LEASE 31,921 18,402 22,921 9,000 72% REPAIR/MAINTENANCE 8,380 7,571 7,832 548 93% MISCELLANEOUS 43,397 16,804 20,576 22,821 47% $ 740,691 $ 403,027 $ 476,486 $ 264,205 64% MUNIC IPAL C O URT SALARIES $ 647,030 $ 438,764 $ 471,516 $ 175,514 73% OVERTIME 800 1,219 1,925 (1,125) 241% BENEFITS 223,319 155,085 175,867 47,452 79% SUPPLIES 10,600 4,620 4,994 5,606 47% SMALL EQUIPMENT 1,000 5,155 7,074 (6,074) 707% PROFESSIONAL SERVICES 124,925 54,205 46,811 78,114 37% COMMUNICATIONS 3,550 2,409 1,622 1,928 46% TRAVEL 6,500 2,233 37 6,463 1% RENTAL/LEASE 67,947 48,154 50,745 17,202 75% REPAIR/MAINTENANCE 4,880 277 1,601 3,279 33% MISCELLANEOUS 25,100 18,154 13,178 11,922 53% MACHINERY/EQUIPMENT 23,120 23,120 0% $ 1,138,771 $ 730,275 $ 775,370 $ 363,401 68% F O Q. d C C IL L d t e0 7 Cl O N O N L d E d Q. d CO) 13 Packet Pg. 28 1 I 2.2.a I Page 2 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY CLERK SALARIES AND WAGES $ 376,214 $ 269,287 $ 303,305 $ 72,909 81% BENEFITS 156,718 121,304 122,903 33,815 78% SUPPLIES 10,240 2,080 3,140 7,100 31% SMALL EQUIPMENT - 4,024 1,003 (1,003) 0% PROFESSIONAL SERVICES 37,410 20,044 19,893 17,517 53% COMMUNICATIONS 40,000 24,920 13,037 26,963 33% TRAVEL 2,000 465 6 1,994 0% RENTAL/LEASE 63,850 35,705 38,633 25,217 61% REPAIRS&MAINTENANCE 32,530 41,163 47,700 (15,170) 147% MISCELLANEOUS 8,000 8,408 4,973 3,027 62% $ 726,962 $ 527,401 $ 554,592 $ 172,370 76% FINANCE SALARIES $ 870,882 $ 639,498 $ 750,844 $ 120,038 86% OVERTIME 4,500 - - 4,500 0% BENEFITS 289,923 220,705 202,703 87,220 70% SUPPLIES 7,350 4,694 3,287 4,063 45% SMALL EQUIPMENT 2,650 579 - 2,650 0% PROFESSIONAL SERVICES 9,300 388 1,501 7,799 16% COMMUNICATIONS 2,000 1,008 568 1,432 28% TRAVEL 3,100 2,055 - 3,100 0% RENTAL/LEASE 50,048 37,237 43,940 6,108 88% REPAIR/MAINTENANCE 41,480 42,499 43,963 (2,483) 106% MISCELLANEOUS 8,350 10,128 3,906 4,444 47% $ 1,289,583 $ 958,793 $ 1,050,712 $ 238,871 81% CITY ATPO RNEY PROFESSIONAL SERVICES $ 912,540 $ 656,534 $ 646,093 $ 266,447 71% $ 912,540 $ 656,534 $ 646,093 $ 266,447 71% NON -DEPARTMENTAL SALARIES $ 101,750 $ - $ - $ 101,750 0% BENEFITS -UNEMPLOYMENT 50,000 28,264 1,254 48,746 3% SUPPLIES 5,000 3,463 3,867 1,133 77% PROFESSIONAL SERVICES 11,009,120 8,026,054 7,853,921 3,155,199 71% EXCISE TAXES 6,500 5,303 11,549 (5,049) 178% RENTAL/LEASE 15,249 9,380 11,863 3,386 78% INSURANCE 394,124 436,448 393,746 378 100% MISCELLANEOUS 91,774 68,429 100,847 (9,073) 110% CONTRIBUTION TO ECA 75,000 75,000 75,000 - 100% INTERFUND SUBSIDIES 3,266,993 625,579 449,033 2,817,960 14% GENERAL OBLIGATION BOND 168,850 - - 168,850 0% INTEREST ON LONG-TERM DEBT 137,250 7,023 69,285 67,965 50% FISCAL AGENT FEES 500 - - 500 0% $ 15,322,110 $ 9,284,942 $ 8,970,365 $ 6,351,745 59% kv O CL O R U C cc C IL L O R 7 CI O N O N L N E O r N N 14 Packet Pg. 29 Page 3 of 4 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining 1%SPell t PO LIC E S ERVIC ES SALARIES $ 6,968,887 $ 4,882,489 $ 5,183,937 $ 1,784,950 74% OVERTIME 461,280 549,575 413,096 48,184 90% HOLIDAY BUYBACK 262,020 8,449 5,394 256,626 2% BENEFITS 2,769,042 1,953,550 2,076,391 692,652 75% UNIFORMS 80,750 75,548 51,917 28,833 64% SUPPLIES 90,500 74,491 61,401 29,099 68% SMALL EQUIPMENT 127,739 98,967 98,409 29,330 77% PROFESSIONAL SERVICES 224,548 158,386 123,971 100,577 55% COMMUNICATIONS 36,000 31,757 29,974 6,026 83% TRAVEL 29,310 29,990 5,925 23,385 20% RENTAL/LEASE 826,124 686,770 615,051 211,073 74% REPAIR/MAINTENANCE 15,180 6,795 4,901 10,279 32% MISCELLANEOUS 60,350 37,578 23,427 36,923 39% $ 11,951,730 $ 8,594,346 $ 8,693,795 $ 3,257,935 73% COMMUNITY S ERVIC ES /EC 0 N DEV. SALARIES $ 357,423 $ 196,398 $ 240,495 $ 116,928 67% BENEFITS 114,637 61,481 69,485 45,152 61% SUPPLIES 7,475 6,280 6,826 649 91% SMALL EQUIPMENT 4,173 - 3,321 852 80% PROFESSIONAL SERVICES 214,400 146,304 73,590 140,810 34% COMMUNICATIONS 2,975 1,109 1,381 1,594 46% TRAVEL 2,000 - 1,020 980 51% RENTAL/LEASE 13,410 8,568 8,837 4,573 66% REPAIR/MAINTENANCE 10,500 - - 10,500 0% MISCELLANEOUS 9,500 4,070 3,879 5,621 41% MACHINERY/EQUIPMENT 25,000 25,000 0% $ 761,493 $ 424,210 $ 408,834 $ 352,659 54% DEVELO PM ENT SERVIC ES/PLANNING SALARIES $ 1,760,943 $ 1,222,159 $ 1,281,898 $ 479,045 73% OVERTIME 1,300 7,342 13,366 (12,066) 1028% BENEFITS 658,292 471,103 466,569 191,723 71% UNIFORMS 500 - - 500 0% SUPPLIES 17,100 7,916 5,505 11,595 32% SMALL EQUIPMENT 7,300 2,663 2,189 5,111 30% PROFESSIONAL SERVICES 886,518 198,998 143,599 742,919 16% COMMUNICATIONS 9,000 7,012 7,598 1,402 84% TRAVEL 6,800 8,199 228 6,572 3% RENTAL/LEASE 170,234 106,700 127,255 42,979 75% REPAIRS & MAINTENANCE 6,800 596 - 6,800 0% MISCELLANEOUS 58,060 26,779 35,126 22,934 60% $ 3,582,847 $ 2,059,466 $ 2,083,333 $ 1,499,514 58% ENGINEERING SALARIES $ 1,772,804 $ 1,290,870 $ 1,304,246 $ 468,558 74% OVERTIME 5,000 5,235 2,668 2,332 53% BENEFITS 701,327 525,048 526,455 174,872 75% UNIFORMS 450 - 256 194 57% SUPPLIES - 32 - - 0% SMALL EQUIPMENT 2,200 - 868 1,332 39% PROFESSIONAL SERVICES 188,840 1,961 1,530 187,310 1% COMMUNICATIONS 19,600 12,031 11,140 8,460 57% TRAVEL 600 585 134 466 22% RENTAL/LEASE 134,995 90,915 99,145 35,850 73% REPAIR/MAINTENANCE 2,600 - 769 1,831 30% MISCELLANEOUS 80,000 48,985 39,449 40,551 49% $ 2,908,416 $ 1,975,662 $ 1,986,661 $ 921,755 68% tv O CL O R U C M C IL 21 L O R 7 CI O N O N L E O r N N 15 Packet Pg. 30 I 2.2.a I Page 4 of 4 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2020 Amended 9/30/2019 9/30/2020 Amount Title Budget Expenditures Expenditures Remaining % Spent PARKS & REC REATIO N SALARIES $ 2,272,394 $ 1,544,356 $ 1,451,347 $ 821,047 64% OVERTIME 10,000 19,807 3,177 6,823 32% BENEFITS 864,290 588,695 547,411 316,879 63% UNIFORMS 6,275 5,305 3,351 2,924 53% SUPPLIES 137,390 117,876 117,123 20,267 85% SMALL EQUIPMENT 10,900 2,639 5,052 5,848 46% PROFESSIONAL SERVICES 620,765 369,903 167,037 453,728 27% COMMUNICATIONS 31,370 13,865 14,450 16,920 46% TRAVEL 5,270 4,407 50 5,220 1% RENTAL/LEASE 268,945 208,530 204,952 63,993 76% PUBLIC UTILITY 230,507 167,417 135,321 95,186 59% REPAIR/MAINTENANCE 29,700 22,555 16,593 13,107 56% MISCELLANEOUS 98,110 71,468 31,519 66,591 32% MACHINERY/EQUIPMENT 9,053 - 9,053 0 100% CONSTRUCTION PROJECTS 10,296 0% $ 4,594,969 $ 3,147,119 $ 2,706,435 $ 1,888,534 59% PUBLIC WORKS ADMINISTRATION SALARIES $ 380,790 $ 218,668 $ 223,533 $ 157,257 59% OVERTIME 200 339 - 200 0% BENEFITS 131,041 78,054 79,052 51,989 60% SUPPLIES 8,600 3,427 3,348 5,252 39% SMALL EQUIPMENT 1,000 2,115 264 736 26% PROFESSIONAL SERVICES 200 85 117 83 59% COMMUNICATIONS 1,350 543 526 824 39% TRAVEL 500 1,427 - 500 0% RENTAL/LEASE 97,295 67,463 72,005 25,290 74% PUBLIC UTILITY 3,318 2,256 2,362 956 71% REPAIR/MAINTENANCE 1,000 - - 1,000 0% MISCELLANEOUS 4,900 735 959 3,941 20% $ 630,194 S 375,111 S 382,165 $ 248,029 61% FACILITIES MAINTENANCE SALARIES 787,257 571,238 587,233 200,024 75% OVERTIME 7,500 5,965 4,549 2,951 61% BENEFITS 348,852 252,588 251,288 97,564 72% UNIFORMS 3,000 4,408 13,830 (10,830) 461% SUPPLIES 112,000 126,763 112,321 (321) 100% SMALL EQUIPMENT 3,000 2,658 5,207 (2,207) 174% PROFESSIONAL SERVICES 977,444 154,792 238,114 739,330 24% COMMUNICATIONS 16,000 15,152 17,373 (1,373) 109% TRAVEL 1,000 6 - 1,000 0% RENTAL/LEASE 55,940 42,777 39,558 16,383 71% PUBLIC UTILITY 297,700 235,689 232,728 64,972 78% REPAIR/MAINTENANCE 143,460 322,011 371,734 (228,274) 259% MISCELLANEOUS 5,000 2,954 1,802 3,198 36% CONSTRUCTION PROJECTS 1,000,000 1,000,000 0% $ 3,758,153 $ 1,737,001 $ 1,875,737 $ 1,882,416 50% TOTAL GENERAL FUND EXPENDITURES $ 49,044,056 $ 31,411,462 $ 31,099,506 $ 17,944,550 63% tv O CL O R U C cc C IL 21 R 3 CI O N O N L E O r N N 16 Packet Pg. 31 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2020 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 2,268,581 $ 2,268,581 $ 2,376,947 4.78% February 4,691,156 2,422,575 4,730,574 0.84% March 7,266,925 2,575,769 7,100,593 -2.29% April 10,693,016 3,426,091 9,435,773 -11.76% May 19,106,833 8,413,817 17,528,670 -8.26% June 21,647,958 2,541,125 19,628,003 -9.33% July 23,877,416 2,229,458 22,424,193 -6.09% August 26,676,562 2,799,147 24,769,057 -7.15% September 28,994,637 2,318,075 26,979,585 -6.95% October 32,807,785 3,813,148 November 41,358,293 8,550,508 December 43,803,858 2,445,565 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2020 Real Estate Excise Tax 1 & 2 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 193,769 $ 193,769 $ 323,203 66.80% February 345,606 151,837 496,485 43.66% March 547,140 201,534 685,999 25.38% April 740,550 193,410 857,110 15.74% May 973,673 233,123 998,087 2.51% June 1,219,609 245,935 1,240,599 1.72% July 1,532,815 313,206 1,463,854 -4.50% August 1,804,669 271,854 1,739,374 -3.62% September 2,081,138 276,470 2,115,408 1.65% October 2,301,037 219,898 November 2,520,239 219,202 December 2,700,000 179,761 *The monthly budget forecast columns are based on a five-year average. k1w O IZ a) ra U C M C LL L fC 7 Cy O N O N L E Q. d 17 Packet Pg. 32 I 2.2.a I SALES TAX SUMMARY Sales Tax Analysis By Category Current Period: September 2020 Year -to -Date Total $5,290,380 Automotive Repair, Health & Personal Care, $134 602 $183,613 Amusement & Recreation, $37,322 Construction Trade, Business Services, Accommodation, $898,085 $613,692 $21,870 Gasoline, $27,561 Clothing and Accessories, $177,006 Retail Food Stores, $242,995 Communications, $177,961 Wholesale Trade, Retail Automotive, $205,448 $1,314,93 8 Manufacturing, $72,357 Misc Retail, $1,100,499 Others, $93,185 Eating & Drinking, $619,246 Annual Sales Tax Revenue 10,000,000 8,000,000 7 395 114 $8,406,296 $8,452,715 $5,840,764 $6,741,838 $6,905,122 6,000,000 $5,920,380 4,000,000 11 2,000, 000 0 201 2015 2016 2017 2018 2019 YTD 2020 0 CL 0 U c c ii L L CI 0 N O N L a� E m a m 18 Packet Pg. 33 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2020 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 634,902 $ 634,902 $ 692,248 9.03% February 1,436,667 801,765 1,539,597 7.16% March 2,031,860 595,193 2,187,876 7.68% April 2,597,573 565,713 2,691,601 3.62% May 3,324,621 727,048 3,191,797 -4.00% June 3,990,697 666,076 3,761,924 -5.73% July 4,697,452 706,756 4,450,258 -5.26% August 5,482,731 785,279 5,184,289 -5.44% September 6,213,489 730,757 5,920,380 -4.72% October 6,961,050 747,562 November 7,750,015 788,965 December 8,450,000 699,985 Gas Utility Tax Sales and Use Tax 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 / 1,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year City of Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 81,408 $ 81,408 $ 82,496 1.34% February 168,408 87,000 177,747 5.55% March 245,012 76,604 260,308 6.24% April 308,737 63,725 337,848 9.43% May 358,094 49,357 395,193 10.36% June 392,813 34,720 430,775 9.66% July 419,421 26,607 463,305 10.46% August 441,879 22,458 489,325 10.74% September 462,623 20,744 510,729 10.40% October 486,497 23,874 November 524,782 38,285 December 579,600 54,818 Gas Utility Tax 600,000 500,000 400,000 - 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget Prior Yeaz *The monthly budget forecast columns are based on a five-year average. O d R U C O C LL L d fC 7 CY O N O N L E m CD S 19 Packet Pg. 34 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2020 Telephone Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 79,271 $ 79,271 $ 70,129 -11.53% February 154,920 75,649 134,128 -13.42% March 224,811 69,891 191,257 -14.93% April 298,919 74,108 254,236 -14.95% May 365,795 66,876 309,632 -15.35% June 433,375 67,580 361,422 -16.60% July 497,866 64,491 424,830 -14.67% August 563,527 65,661 479,371 -14.93% September 631,163 67,636 528,163 -16.32% October 697,753 66,590 November 761,530 63,777 December 823,900 62,370 Electric Utility Tax 1,000,000 Telephone Utility Tax 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 ir 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Revenue Summary -Electric Utility Tax 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 176,332 $ 176,332 $ 179,486 1.79% February 369,755 193,422 371,370 0.44% March 530,960 161,206 535,467 0.85% April 710,778 179,818 710,200 -0.08% May 852,710 141,933 854,417 0.20% June 974,520 121,810 970,402 -0.42% July 1,088,754 114,233 1,091,103 0.22% August 1,199,457 110,703 1,214,761 1.28% September 1,311,314 111,857 1,316,801 0.42% October 1,428,233 116,919 November 1,552,157 123,924 December 1,684,800 132,643 *The monthly budget forecast columns are based on a five-year average. tIN O rL O R U C C LL L fC 7 Cy O N O N L E d 20 Packet Pg. 35 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2020 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 804,719 $ 804,719 $ 737,298 -8.38% February 1,363,439 558,720 1,256,012 -7.88% March 2,170,455 807,015 2,048,593 -5.61% April 2,696,703 526,248 2,538,466 -5.87% May 3,481,516 784,813 3,275,201 -5.93% June 4,099,586 618,070 3,855,044 -5.97% July 5,087,366 987,780 4,682,817 -7.95% August 5,941,343 853,977 5,382,918 -9.40% September 7,092,152 1,150,809 6,403,521 -9.71% October 7,892,798 800,646 November 8,818,044 925,246 December 9,384,958 566,914 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2020 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 355,919 $ 355,919 $ 348,012 1.79% February 1,125,592 769,673 1,101,727 0.44% March 1,480,771 355,179 1,449,754 0.85% April 1,795,425 314,654 1,758,968 -0.08% May 2,150,929 355,505 2,107,634 0.20% June 2,466,536 315,606 2,417,745 -0.42% July 2,822,237 355,701 2,766,634 -1.97% August 3,592,736 770,499 3,521,551 -1.98% September 3,947,537 354,801 3,869,253 -1.98% October 4,262,734 315,197 November 4,618,388 355,654 December 4,921,433 303,045 *The monthly budget forecast columns are based on a five-year average. tIN O rL 0) R U C f� C LL L R 7 Cy O N O N L E 4) sa. d ZZ Packet Pg. 36 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2020 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 843,972 $ 843,972 $ 792,168 -6.14% February 1,528,418 684,445 1,457,427 -4.64% March 2,368,523 840,105 2,253,756 -4.85% April 3,057,434 688,911 2,905,227 -4.98% May 3,904,796 847,362 3,666,165 -6.11% June 4,601,743 696,947 4,301,071 -6.53% July 5,475,901 874,158 5,076,023 -7.30% August 6,170,772 694,871 5,723,561 -7.25% September 7,057,714 886,942 6,520,644 -7.61% October 7,759,947 702,233 November 8,620,364 860,417 December 9,307,969 687,605 Unmeter Sewer Sales 10,000,000 9,000,000 8,000,000 — 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Yeaz Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. tIN O CL O R U C M C_ LL L O tC 7 Cy O N O N L E d 22 Packet Pg. 37 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2020 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 5,642,749 $ 5,642,749 $3,641,481 -35.47% February 8,910,266 3,267,517 7,564,087 -1S.11% March 12,507,763 3,597,497 10,796,906 -13.68% April 16,723,319 4,215,556 13,318,642 -20.36% May 19,875,327 3,152,008 17,123,820 -13.84% June 24,725,220 4,849,893 21,049,664 -14.87% July 28,663,754 3,938,534 24,352,711 -15.04% August 32,968,461 4,304,707 27,602,216 -16.28% September 36,464,588 3,496,127 31,099,506 -14.71% October 40,092,243 3,627,655 November 44,563,572 4,471,329 December 49,044,056 4,480,484 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2020 Non -Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 2,923,229 $ 2,923,229 $ 1,280,852 -56.18% February 3,405,897 482,668 2,717,261 -20.22% March 4,567,146 1,161,249 3,569,389 -21.85% April 6,398,890 1,831,744 3,731,670 -41.68% May 6,709,824 310,934 5,129,301 -23.56% June 8,510,257 1,800,433 6,488,886 -23.75% July 9,528,179 1,017,922 7,237,544 -24.04% August 10,974,933 1,446,754 8,074,263 -26.43% September 11,879,864 904,931 8,970,365 -24.49% October 12,546,369 666,505 November 14,100,020 1,553,651 December 15,322,110 1,222,090 *The monthly budget forecast columns are based on a five-year average. t1w O rL 0) R U C f� C LL L fC 7 Cy O N O N L E 4) Q. d 23 Packet Pg. 38 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2020 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 26,361 $ 26,361 $ 23,825 -9.62% February 54,130 27,769 55,625 2.76% March 88,475 34,345 81,971 -7.35% April 119,273 30,799 106,847 -10.42% May 158,791 39,518 133,074 -16.20% June 205,911 47,121 160,080 -22.26% July 239,007 33,095 186,441 -21.99% August 285,476 46,469 212,640 -25.51% September 323,555 38,079 239,066 -26.11% October 346,924 23,369 November 382,373 35,449 December 418,912 36,539 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2020 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 25,001 $ 25,001 $ 28,750 15.00% February 50,898 25,897 60,151 18.18% March 76,062 25,164 87,486 15.02% April 101,769 25,706 114,642 12.65% May 126,945 25,177 142,030 11.88% June 151,749 24,804 169,276 11.55% July 177,563 25,814 196,288 10.55% August 203,939 26,376 222,950 9.32% September 229,480 25,541 249,862 8.88% October 254,419 24,939 November 279,429 25,010 December 306,685 27,256 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 - -Prior Year *The monthly budget forecast columns are based on a five-year average. k1w O iZ iv R U C f� C LL L fC 7 Cy O N O N L E d 24 Packet Pg. 39 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2020 Human Resources Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 59,451 $ 59,451 $ 68,346 14.96% February 117,267 57,816 134,278 14.51% March 178,196 60,929 184,385 3.47% April 229,767 51,571 233,118 1.46% May 284,932 55,165 283,462 -0.52% June 355,895 70,963 335,262 -5.80% July 411,216 55,322 378,306 -8.00% August 469,554 58,338 423,682 -9.77% September 531,309 61,755 476,486 -10.32% October 590,790 59,481 November 649,771 58,981 December 740,691 90,920 Municipal Court Human Resources 800,000 700,000 600,000 500,000 400,000 300,000 - 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget Prior Year City of'Edmonds, WA Monthly Expenditure Report -Municipal Court 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 86,636 $ 86,636 $ 79,231 -8.55% February 180,238 93,602 166,073 -7.86% March 272,302 92,065 249,701 -8.30% April 365,299 92,996 331,047 -9.38% May 465,516 100,217 422,932 -9.15% June 553,704 88,188 507,527 -8.34% July 646,093 92,389 595,161 -7.88% August 743,853 97,760 681,851 -8.34% September 834,912 91,059 775,370 -7.13% October 934,920 100,009 November 1,028,111 93,191 December 1,138,771 110,660 Municipal Court 1,200,000 1,000,000 800,000 600,000 400,000 200,000 I too" 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. O rL 4) R U C f� C LL L 7 0 O N O N L E 4) d 25 Packet Pg. 40 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2020 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 49,169 $ 49,169 $ 40,001 -18.65% February 106,160 56,991 82,357 -22.42% March 165,380 59,220 123,069 -25.58% April 227,893 62,513 165,175 -27.52% May 286,048 58,155 210,066 -26.56% June 342,978 56,930 258,279 -24.70% July 404,684 61,706 309,288 -23.57% August 472,943 68,259 360,249 -23.83% September 532,197 59,254 408,834 -23.18% October 597,110 64,914 November 667,285 70,174 December 761,493 94,208 City of Edmonds, WA Monthly Expenditure Report -City Clerk 2020 City Clerk Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 71,401 $ 71,401 $ 83,447 16.87% February 129,624 58,223 139,339 7.49% March 187,005 57,380 199,113 6.47% April 251,043 64,039 258,617 3.02% May 306,774 55,730 321,093 4.67% June 361,810 55,036 378,904 4.72% July 423,597 61,787 438,669 3.56% August 486,276 62,679 499,805 2.78% September 539,284 53,008 554,592 2.84% October 597,946 58,662 November 662,981 65,035 December 726,962 63,981 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. k1w O rL 0) R U C f� C LL L fC 7 0 O N O N L E d 26 Packet Pg. 41 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2020 Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 177,914 $ 177,914 $ 81,888 -53.97% February 334,463 156,549 291,582 -12.82% March 444,630 110,167 352,886 -20.63% April 528,740 84,111 396,588 -24.99% May 626,604 97,864 462,422 -26.20% June 728,444 101,840 540,328 -25.82% July 813,042 84,598 612,976 -24.61% August 911,499 98,456 699,095 -23.30% September 1,028,310 116,812 807,205 -21.50% October 1,126,888 98,577 November 1,231,196 104,309 December 1,454,784 223,588 Finance Technology Rental Fund 1,500,000 1,200,000 900,000 600,000 300,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 2020 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 124,756 $ 124,756 $ 148,549 19.07% February 235,691 110,935 251,089 6.53% March 337,197 101,506 353,610 4.87% April 438,143 100,947 456,877 4.28% May 539,685 101,542 562,662 4.26% June 639,437 99,752 795,796 24.45% July 7S0,562 111,125 879,925 17.24% August 854,084 103,522 964,589 12.94% September 970,025 115,941 1,050,712 8.32% October 1,081,072 111,048 November 1,184,488 103,415 December 1,289,583 105,095 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. tIN O rL 0) t4 U C C LL L fC 7 Cy O N O N L E d 27 Packet Pg. 42 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2020 City Attorney Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 76,045 $ 76,045 $ 49,883 -34.40% February 1S2,090 76,045 142,611 -6.23% March 228,135 76,045 192,534 -1S.61% April 304,180 76,045 288,462 -5.17% May 380,225 76,045 359,660 -5.41% June 456,270 76,045 431,895 -5.34% July 532,315 76,045 503,028 -5.50% August 608,360 76,045 574,161 -S.62% September 684,405 76,045 646,093 -5.60% October 760,450 76,045 November 836,495 76,045 December 912,540 76,045 City of'Edmonds, WA Monthly Expenditure Report -Police 2020 Police Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 940,461 $ 940,461 $ 887,236 -5.66% February 1,891,364 950,903 1,893,712 0.12% March 2,844,400 953,036 2,821,483 -0.81% April 3,808,566 964,166 3,703,720 -2.75% May 4,764,870 956,304 4,601,807 -3.42% June 5,757,552 992,683 5,628,905 -2.23% July 6,727,081 969,529 6,748,449 0.32% August 7,664,129 937,048 7,666,496 0.03% September 8,620,478 956,349 8,693,795 0.85% October 9,688,901 1,068,423 November 10,939,777 1,250,876 December 11,951,730 1,011,953 Police 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. tIN O rL 0) R U C f� C LL L fC 7 Cy O N O N L E 4) d Z$ Packet Pg. 43 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2020 Development Services Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 249,933 $ 249,933 $ 241,446 -3.40% February 530,487 280,S53 461,847 -12.94% March 820,192 289,705 685,780 -16.39% April 1,114,858 294,666 922,412 -17.26% May 1,418,144 303,286 1,151,071 -18.83% June 1,697,166 279,021 1,370,746 -19.23% July 1,991,793 294,627 1,608,527 -19.24% August 2,295,145 303,352 1,8S1,746 -19.32% September 2,593,333 298,188 2,083,333 -19.67% October 2,899,612 306,279 November 3,239,495 339,883 December 3,582,847 343,352 City of'Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2020 Parks & Recreation Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 310,663 $ 310,663 $ 278,296 -10.42% February 633,218 322,555 596,263 -5.84% March 976,069 342,851 892,745 -8.54% April 1,332,232 356,164 1,186,533 -10.94% May 1,699,847 367,615 1,472,976 -13.35% June 2,069,338 369,491 1,756,039 -15.14% July 2,534,539 465,201 2,047,976 -19.20% August 3,070,105 535,567 2,368,204 -22.86% September 3,504,600 434,495 2,706,435 -22.77% October 3,876,641 372,041 November 4,200,535 323,894 December 4,594,969 394,434 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. t10 O rL 0) R U C f� C LL L fC 7 Cy O N O N L E 4) d 29 Packet Pg. 44 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Public Works Administration 2020 Public Works Administration Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 51,939 $ 51,939 $ 41,796 -19.53% February 105,536 53,597 83,385 -20.99% March 157,916 52,379 125,953 -20.24% April 210,278 52,362 169,511 -19.39% May 262,800 52,522 212,944 -18.97% June 316,459 53,659 256,932 -18.81% July 370,954 54,495 298,731 -19.47% August 422,825 51,871 340,410 -19.49% September 472,902 50,077 382,165 -19.19% October 524,167 51,265 November 575,881 51,714 December 630,194 54,313 Facilities Maintenance Public Works Administration 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Yeaz Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2020 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 284,728 $ 284,728 $ 177,532 -37.65% February 585,426 300,698 353,835 -39.56% March 887,362 301,936 583,052 -34.29% April 1,181,106 293,744 781,557 -33.83% May 1,483,561 302,454 1,002,638 -32.42% June 1,740,520 256,959 1,175,527 -32.46% July 2,069,330 328,810 1,373,287 -33.64% August 2,371,409 302,079 1,592,675 -32.84% September 2,707,430 336,020 1,875,737 -30.72% October 3,011,628 304,199 November 3,381,203 369,574 December 3,758,153 376,950 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. k1w O rL 0) R U C C LL L 7 Cy O N O N L E 4) Q. d 30 Packet Pg. 45 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2020 Engineering Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 219,750 $ 219,750 $ 212,290 -3.39% February 436,542 216,792 426,262 -2.35% March 671,678 235,136 646,635 -3.73% April 915,104 243,427 868,452 -5.10% May 1,155,255 240,151 1,118,106 -3.22% June 1,402,970 247,715 1,335,611 -4.80% July 1,656,398 253,428 1,551,091 -6.36% August 1,917,510 261,112 1,768,495 -7.77% September 2,156,951 239,441 1,986,661 -7.89% October 2,402,446 245,495 November 2,635,839 233,393 December 2,908,416 272,577 Engine a ring 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 31 Packet Pg. 46 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of September 30, 2020 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Rice Maturity Value Value Date Rate Grant Cnty WA Bonds 4,014,120 0.25 4,000,000 4,010,840 01/01/21 1.47% First Financial CD 3,000,000 0.53 3,000,000 3,000,000 04/10/21 2.86% Port of Seattle WA Bonds 273,305 0.58 270,000 272,152 05/01/21 2.23% Grant Cnty WA Bonds 410,553 1.25 405,000 411,994 01/01/22 1.79% FFCB Bonds 1,998,548 1.70 2,000,000 2,058,226 06/14/22 1.88% Energy Northwest Bonds 1,466,077 1.75 1,345,000 1,458,464 07/01/22 5.00% Energy Northwest Bonds 260,748 1.75 250,000 260,448 07/01/22 2.95% Mason & Kitsap Cnty WA Bonds 948,084 2.17 855,000 944,749 12/01/22 5.00% FHLB Bonds 3,000,000 2.25 3,000,000 3,012,225 12/30/22 1.79% Grant Cnty WA Bonds 1,517,955 2.25 1,500,000 1,536,435 01/01/23 1.54% Grant Cnty WA Bonds 576,332 2.25 520,000 575,406 01/01/23 5.00% Seattle WA Muni Bonds 2,224,500 2.34 2,000,000 2,224,360 02/01/23 5.00% First Financial CD 2,803,516 3.13 2,803,516 2,803,516 11/15/23 2.10% Kent WA Bonds 286,648 3.17 250,000 287,653 12/01/23 5.00% Spokane County WA Bonds 259,075 4.17 250,000 265,403 12/01/24 2.10% First Financial CD 2,000,000 7.09 2,000,000 2,000,000 11/01/27 1.68% TOTAL SECURITIES 25,039,459 2.29 24,448,516 25,121,870 Washington State Local Gov't Investment Pool 8,612,009 8,612,009 Demand 0.21% Snohomish County Local Gov't Investment Pool 20,093,253 20,093,253 Demand 1.73% TOTAL PORTFOLIO $ 53,153,778 $ 53,827,132 Issuer Diversification Energy Northwest, 7% First FHLB 12% Financial - Spokane CD, 32% County WA, 1% Cash and Investment Balances (in $ Millions) Checki ng, $4.9 , 8% Bonds, State LGIP, $16.6, 29% $8,6 , 1S% r CD's, $7.8, County 13% LGIP, $20.1, 35% 32 Packet Pg. 47 1 1 2.2.a INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1,200,000 $1,000,000 $917 754 $800,000 $791,022 $653,690 $600,000 335,926 $423,816 $400,000 $200,000 $- -- I A[ 2015 2016 2017 2018 2019 YTD 2020 2.0% 1.8% 1.5% 1.3% 1.0% 0.8% 0.5% 0.3% 0.0 October $10,000,000 $8,000, 000 $ 6,000, 000 $4,000,000 $2,000,000 c_ Edmonds Rate of Return Compared to Benchmark (Rolling 12 months) 6 Month Treasury Rate (Benchmark) City Blended Rate December ♦ -- - - - - - - - - - - - - - - - - - - - - - - - - - February April June August Maturity Distribution and Rate of Return 4.00% 3.50% 3.00% 2.50% 2.00% 1.50% 1.00% 0.50% o.00% 0-6 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 84-90 90-96 Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo W k1w 33 Packet Pg. 48 GENERAL FUND OVERVIEW I 2.2.a I GENERAL FUND & SUBFUNDS 001-General Fund 009-Leoff-Medical Ins. Reserve 012-Contingency Reserve Fund 014-Historic Preservation Gift Fund 016-Building Maintenance 017 - Marsh Restoration & Preservation 018 -Edmonds Homelessness Response 019 - Edmonds Opioid Response Total General Fund & Subfunds FUND BALANCES Iy:/_1►lei a1►1111►19] 1_1WG161[a] ---- ACTUAL ---- 12/31 /2019 6/30/2020 9/30/2020 $ 15,552,187 $ 14,130,526 $ 11,432,266 $ 355,874 416,192 379,625 1,782,149 1,782,149 1,782,149 12,187 14,687 14,687 210,221 210,221 210,221 864,491 864,491 864,591 223,581 223,581 223,581 50,000 50,000 50,000 $ 19,050,690 $ 17,691,847 $ 14,957,121 1 $ ---- ACTUAL ---- �. t Q3 YTD 0 CL (2,698,260) $ am (4,119,92' W (36,566) 23,75: •� c c - 2,501 ii 21 _ 100 _ L m 10( ca - - CY 0 N - - o N (2,734,726) $ (4,093,561 E m *$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. 0 *$7,720,000 of the fund balance in Fund 001 added to the $1,782,149 balance in Fund 012, represent the required c 20% operating reserve. Q- General Fund & Subfunds 21 - 18 General Fund 15 $9 33 & Subfunds $7.97 12 $5.24 General Fund c Operating Reserve = 9 ■ Civic Field 6 $7.72 $7.72 $7.72 3 $2.00 kL<2.00 $2.00 Dec 2019 June 2020 Sept 2020 *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. 49 2.2.a GOVERNMENTAL FUNDS OVERVIEW CHANGE IN FUND FUND BALANCES BALANCES GOVERNMENTAL ---- ACTUAL ---- FUNDS ---- ACTUAL ---- 12/31 /2019 6/30/2020 9/30/2020 Q3 YTD General Fund & Subfunds $ 19,050,690 $ 17,691,847 $ 14,957,121 $ (2,734,726) $ (4,093,56f Special Revenue 10,622,237 10,896,734 10,235,228 (661,506) (387,00� 0 Debt Service - (0) (0) - (C W Capital Projects 6,443,150 6,362,622 6,878,746 516,124 435,59E 2 Total Governmental Funds $ 36,116,078 $ 34,951,202 $ 32,071,095 $ (2,880,107) $ (4,044,98: ii 21 L L CY Q N O N Governmental Fund Balances -By Fund Group Governmental Fund Balances - y Combined E m 21 40 f% _�L9.05 $36.12 $34.95 i 18 17.69 35 $32.07 --*--General Fund & 30 >+ 15 $14.96 Subfunds --a—Special 25 cC r_ 12 Revenue c CY 0 $10.24 2 20 L 9 Debt E Service 15 6.36 $6.88 6 —i(--Capital 10 ar Projects 3 5 E O t) Dec 2019 June 2020 Sept 2020 Dec 2019 June 2020 Sept 2020 m E t v cv 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. 35 Packet Pg. 50 2.2.a SPECIAL REVENUE FUNDS OVERVIEW FUND BALANCES CHANGE IN FUND BALANCE: GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 12/31/2019 6/30/2020 9/30/2020 Q3 YTD 104 - Drug Enforcement Fund $ 39,839 $ 77,411 $ 73,859 $ (3,552) $ 34,02C 1 1 1 - Street Fund 1,298,473 1,088,447 1,067,380 (21,067) (231,092 112- Combined Street Const/Improve 1,421,769 2,197,489 2,127,421 (70,068) 705,652 �. 117 - Municipal Arts Acquis. Fund 634,011 647,244 646,333 (912) 12,322 o 118 - Memorial Street Tree 19,785 20,012 20,222 210 437 m 120 - Hotel/Motel Tax Revenue Fund 93,013 96,191 101,933 5,742 8,92C 121 - Employee Parking Permit Fund 86,844 96,987 98,101 1,114 11,257 'U 122 - Youth Scholarship Fund 13,600 13,303 13,443 139 (15f 123 -Tourism Promotional Fund/Arts 72,101 80,804 85,168 4,363 13,06E LL 125 -Real Estate Tax 2 2,625,364 2,507,321 2,572,735 65,414 (52,62E >, 126 - Real Estate Excise Tax 1 2,486,325 2,177,940 2,347,350 169,411 (138,97E `m 127 - Gifts Catalog Fund 332,255 337,990 312,548 (25,442) (19,707 ca 130- Cemetery Mai ntenance/Improvement 260,685 255,125 239,431 (15,694) (21,25C C3y 136 - Parks Trust Fund 163,071 164,942 166,670 1,728 3,59E N 137 - Cemetery Maintenance Trust Fund 1,053,314 1,070,881 1,086,243 15,362 32,92� N 138- Sister CityCommission 10,129 12,734 12,868 134 2,73E 140 -Business Improvement Disrict 11,546 19,465 28,653 9,188 17,107 141 -Affordable and Supportive Housing Fd 112 32,446 51,036 18,589 50,924 +; 142 - Edmonds Cares Fund - - (816,165) (816,165) (816,16E m Total Special Revenue $ 10,622,237 $ 10,896,734 $ 10,235,228 $ (661,506) $ (387,00� *$200,000 of the fund balance in Fund 125 has been reserved for Marsh Restoration Funding Special Revenue Funds 12 10 8 L 0 6 Special $10.62 $10.90 $10.24 Revenue 4 2 Dec 2019 June 2020 Sept 2020 *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. 51 ENTERPRISE FUNDS OVERVIEW I 2.2.a I ENTERPRISE FUNDS 421 -Water Utility Fund 422 - Storm Utility Fund 423 - Sewer/WWTP Utility Fund 424 - Bond Reserve Fund 411 -Combined Utility Operation Total Enterprise Funds FUND BALANCES ---- ACTUAL ---- 12/31 /2019 6/30/2020 9/30/2020 $ 23,049,550 $ 22,708,684 $ 22,426,629 $ 12,607,151 11,522,128 10,936,388 46,572,051 47,580,092 45,952,697 843,961 843,968 843,970 - 30,710 31,765 $ 83,072,713 $ 82,685,581 $ 80,191,449 $ CHANGE IN FUND ---- ACTUAL ---- (282,055) $ (585,741) (1,627,394) 3 1,055 (2,494,132) $ *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding Enterprise and Agency Fund Balances as of September 30, 2020 50,000,000 45,000,000 40,000,000 35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,000 $31,765 0 Combined Utility Water �14J,7JL,07 / $10. 336.388 (622,922 (1,670,76" (619,354 0 C Q. m 31,76E W c� (2,881,26Z U �a c ii 21 L m L CY Q N O N L �c E Y Q m - $843,970 $139,708 Storm Sewer/WWTP Bond Reserve Firemen's Pension Fund *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 37 Packet Pg. 52 SUMMARY OVERVIEW I 2.2.a I CITY-WIDE Governmental Funds Enterprise Funds Internal Services Fund Agency Funds Total City-wide Total CHANGE IN FUND BALANCES ---- ACTUAL ---- Q3 YTD (2,880,107) $ (4,044,98c p Q. (2,494,132) (2,881,264 279,306 735,87� (15,108) (7,02F (5,110,042) $ (6,197,40C LL L CY Q Governmental Fund Balances (Excluding General Fund) as of September 30, 2020 0 FUND BALANCES ---- ACTUAL ---- i FWAS FK11 i :�Lc�i7f�ZiyZi�7Lc�i7f�ZiyZi $ 36,116,077 $ 34,951,202 $ 32,071,095 $ 83,072,713 82,685,581 80,191,449 10,803,067 11,259,633 11,538,939 146,733 154,816 139,708 $130,138,590 $129,051,233 $123,941,191 $ Drug Enforcement Fund $73,859 Street Fund $1,067,380 Combined Street Const/Improve Fund $2,127, 21 Municipal Arts Acquis. Fund $646,3 3 Memorial Street Fund $20,222 Hotel/Motel Tax Revenue Fund $101,933 Employee Parking Permit Fund $98,101 Youth Scholarship Fund $13,443 Tourism Promotional Fund/Arts $85,168 Real Estate Excise Tax 2 $2 572,735 Real Estate Excise Tax 1 $2,3 7,350 Gifts Catalog Fund $312,548 Cemetery Maintenance/Improvement $239,431 Parks Trust Fund 1 $166,670 Cemetery Maintenance Trust Fund $1 086,243 Sister City Commission $12,868 Business Improvement District $28,653 Parks Capital Construction Fund $1,500,000 $3,000,000 $- $6,8 8,746 $4,500,000 $6,000,000 $7,500,000 *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 38 Packet Pg. 53 1 INTERNAL SERVICE FUNDS OVERVIEW I 2.2.a I INTERNAL SERVICE FUNDS 511 - Equipment Rental Fund 512 -Technology Rental Fund Total Internal Service Funds 12,000,00 10,000,00 8,000, 00 6,000, 00 4,000, 00 2,000, 000 K:$786,798 Dec 2019 FUND BALANCES ---- ACTUAL ---- 12/31 /2019 6/30/2020 9/30/2020 $ 10,016,269 $ 10,412,411 $ 10,654,871 $ 786,798 847,223 884,068 $ 10,803,067 $ 11,259,633 $ 11,538,939 1 $ Internal Service Fund Balances $10,412,411 G$847,223 June 2020 $10,654,871 $884,068 Sept 2020 CHANGE IN FUND BALANCES ---- ACTUAL ---- Q3 YTD 242,460 $ 638,60, Q. 36,845 97,27C m 279,306 $ 735,87� c ii 21 L V O N O N L E m Q. d ■ 511- Equipment Rental Fund ■512- Technology Rental Fund *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 39 Packet Pg. 54 2.2.b GENERAL FUND CHANGES IN FUND BALANCE 2015 2016 2017 2018 2019 (Jan -Sept) 2020 (Jan -Sept) Beginning Fund Balance 6,446,380 9,359,435 9,841,718 10,273,343 11,233,278 15,552,188 Revenue Taxes 28,714,539 29,403,794 29,572,203 30,755,578 20,263,957 19,831,968 Licenses and permits 2,132,897 2,269,313 2,506,800 2,401,855 1,684,252 1,709,258 Intergovernmental 977,585 1,261,998 890,572 1,014,434 579,661 783,705 Charges for services 5,150,816 5,403,786 5,463,913 5,810,961 4,835,973 3,971,068 Fines and forfeitures 535,078 522,051 459,929 616,783 401,348 224,158 Investment earnings 70,045 (26,712) 154,739 273,226 342,041 269,313 Miscellaneous 435,414 441,432 471,675 931,495 513,469 172,214 Transfers in 822,175 82,695 26,300 75,884 13,150 17,900 Debt proceeds - 549,095 - - - - Sale of capital assets - 58,451 7,143 5,273 - - Insurance recoveries - - - 15,570 - - Total Revenue 38,838,549 39,965,902 39,553,274 41,901,058 28,633,850 26,979,585 Expenditures General government 8,836,333 9,969,187 9,714,867 10,288,694 8,718,500 8,910,091 Public safety 19,371,912 20,128,896 22,228,871 22,585,212 17,584,076 17,466,356 Transportation 3,600 3,600 3,600 4,779 4,177 4,177 Economic environment 1,353,548 1,313,430 1,551,152 1,460,763 1,149,187 1,219,800 Mental and physical health 69,762 70,814 126,791 178,859 100,775 199,302 0 Culture and recreation 3,591,029 3,773,633 3,959,731 4,331,806 3,211,849 2,772,409 0 Debt service 272,793 196,663 198,361 197,694 7,023 69,285 Capital outlay 92,202 56,662 90,573 93,105 10,296 9,053 Transfers out 2,334,315 3,414,141 1,247,703 1,800,212 625,579 449,033 U ca Debt refunding - 556,593 - - - - Total Expenditures 35,925,494 39,483,619 39,121,649 40,941,124 31,411,462 31,099,506 U` L Prior Period Adjustments - - - - Change in position 2,913,055 482,283 431,625 959,934 (2,777,612) (4,119,921) Ending Fund Balance 9,359,435 9,841,718 10,273,343 11,233,278 8,455,666 11,432,267 N 0 N L d .0 C d 0. d W J a a 0 CO c c� c a� E z Q R:\Finance Committee\2020\Jan-Sept P&L 10/27/2020 Packet Pg. 55