The URL can be used to link to this page

2021-01-12 City Council - Full FIN Agenda-27641 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 JANUARY 12, 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. Computer Decommissioning and Surplus (10 min) 2. November 2020 Monthly Financial Report (10 min) 3. Finance Committee Planning Ideas (10 min) 4. Finance Policies (10 min) 5. Waiving Rent Payments for the Chamber of Commerce from January -June 2021 (10 min) ADJOURN Edmonds City Council Agenda January 12, 2021 Page 1 2.1 City Council Agenda Item Meeting Date: 01/12/2021 Computer Decommissioning and Surplus Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History Council approval is required for disposal of assets. As part of the normal IT cycle, IT staff have decommissioned 53 computers, and would like to send them to surplus. Staff Recommendation Approve surplus of 53 computers. Narrative: Council approval is required for disposal of assets. As part of the normal IT cycle, IT staff have decommissioned 53 computers, and would like to send them to surplus. Attachments: Surplus_Computers_20200107 Packet Pg. 2 2.1.a Serial Number Model 009277360252 Surface 3 009278254352 Surface 3 014059254352 Surface 3 032275260953 Surface Pro 4 035148762653 Surface Pro 4 2CE3462BOX HP ProBook 450 G1 2UA701ODH7 HPDC5700 5CG4033YK HP EliteBook 850 G1 G6BN714001M3 NUC7i5BNK G6RY506001T5 NUC5i5RYK G6RY506006X7 NUC5i5RYK G6RY506006YY NUC5i5RYK G6RY5070070Y NUC5i5RYK G6RY51400QN3 NUC5i5RYK G6RY5160031M NUC5i5RYK G6RY5160032L NUC5i5RYK G6RY5160034N NUC5i5RYK G6RY5160037C NUC5i5RYK G6RY5160037W NUC5i5RYK G6RY516003B4 NUC5i5RYK G6RY516003B5 NUC5i5RYK G6RY516004QG NUC5i5RYK G6RY5160088G NUC5i5RYK G6RY516008KE NUC5i5RYK G6RY516008L1 NUC5i5RYK G6RY519002DW NUC5i5RYK G6RY537005MR NUC5i5RYK G6RY537005MX NUC5i5RYK G6RY537005ZJ NUC5i5RYK G6RY543006TJ NUC5i5RYK G6RY543007G4 NUC5i5RYK G6RY6010OWP3 NUC5i5RYK G6SY549001BR NUC6i5SYK G6SY549001CA NUC6i5SYK G6SY549001G2 NUC6i5SYK G6SY551003V1 NUC6i5SYK G6SY551003Y8 NUC6i5SYK G6SY55100464 NUC6i5SYK G6SY5510048Z NUC6i5SYK G6SY5510049T NUC6i5SYK G6SY551004EL NUC6i5SYK G6SY551005XJ NUC6i5SYK G6SY551005Z7 NUC6i5SYK G6SY5510066C NUC6i5SYK G6SY5510066F NUC6i5SYK G6SY5510066Q NUC6i5SYK G6SY5510066T NUC6i5SYK G6SY5510067Z NUC6i5SYK G6SY55100684 NUC6i5SYK G6SY604006Q1 NUC6i5SYK G6SY61100048 NUC6i5SYK G6SY617003C5 NUC6i5SYK G6YE3450035G DICP847S Packet Pg. 3 2.2 City Council Agenda Item Meeting Date: 01/12/2021 November 2020 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 November 2020 Monthly Financial Report Attachments: November 2020 Monthly Financial Report Packet Pg. 4 I 2.2.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT NOVEMBER 2020 Packet Pg. 5 1 I 2.2.a I Page 1 of 1 C FIY OF EDMO NDS REVENUES BY FUND - SUMMARY Fund 2020 Amended 11/30/2019 11/30/2020 Amount No. Title Budget Revenues Revenues Remaining %Receive, 001 GENERAL FUND $ 43,803,858 $ 44,646,255 $ 39,391,635 $ 4,412,223 90 009 LEOFF-MEDICAL INS. RESERVE 437,980 425,000 425,000 12,980 97 011 RISK MANAGEMENT RESERVE FUND - - - - 0 012 CONTINGENCY RESERVE FUND 56,140 30,905 56,140 0 014 HISTORIC PRESERVATION GIFT FUND 017 MARSH RESTORATION & PRESERVATION FUND 104 DRUG ENFORCEMENT FUND 111 STREET FUND 112 COMBINED STREET CONST/IMPROVE 117 MUNICIPAL ARTS ACQUIS. FUND 118 MEMORIAL STREET TREE 120 HOTEL/MOTEL TAX REVENUE FUND 121 EMPLOYEE PARKING PERMIT FUND 122 YOUTH SCHOLARSHIP FUND 123 TOURISM PROMOTIONAL FUND/ARTS 125 REAL ESTATE EXCISE TAX 2 126 REAL ESTATE EXCISE TAX 1 127 GIFTS CATALOG FUND 130 CEMETERY MAINTENANCE/IMPROVEMT 136 PARKS TRUST FUND 137 CEMETERY MAINTENANCE TRUST FD 138 SISTER CITY COMMISSION 140 BUSINESS IMPROVEMENT DISTRICT 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 142 EDMONDS CARES FUND 211 L.I.D. FUND CONTROL 231 2012 LT GO DEBT SERVICE FUND 332 PARKS CAPITAL CONSTRUCTION FUND 1 411 COMBINED UTILITY OPERATION 421 WATER UTILITY FUND 422 STORM UTILITY FUND 2 423 SEWER/WWTP UTILITY FUND 3 424 BOND RESERVE FUND 511 EQUIPMENT RENTAL FUND 512 TECHNOLOGY RENTAL FUND 617 FIREMEN'S PENSION FUND 5,230 165,390 1,912,768 2,841,881 263,576 750 98,630 27,270 1,790 34,450 1,436,090 1,453,520 145,050 184,610 5,000 555,312 38,898 1,767,862 1,983,030 108,756 648 94,942 15,303 930 31,979 1,432,948 1,446,566 113,229 224,455 5,000 100 64,489 1,785,348 1,764,428 77,685 474 59,639 12,345 619 20,508 1,556,231 1,550,006 54,658 115,851 230 (100) 100,902 127,420 1,077,453 185,891 276 38,991 14,925 1,171 13,942 (120,141) (96,486) 90,392 68,759 96 C O 0 a d 39 O 93 C 62 29 LL 63 t r� 60 p 45 0 35 0 N 60 CD 108 £ 107 > O 38 Z 63 1= 6,390 5,383 3,906 2,484 61 54,210 53,774 37,560 16,650 69 10,380 8,801 270 10,110 3 79,209 83,968 73,211 5,998 92 - - 64,783 (64,783) 0 1,897,650 - 814,793 1,082,857 43 12,400 30,893 - 12,400 0 738,400 437,184 452,588 285,812 61 9,638,306 4,513,317 1,405,339 8,232,967 15 - 128,912 32,085 (32,085) 0 11,116,270 9,277,084 9,392,901 1,723,369 84 6,720,466 4,917,463 5,311,534 1,408,932 79 25,261,935 12,818,809 29,789,152 (4,527,217) 118 1,988,100 625,605 616,553 1,371,547 31 1,746,160 1,707,959 1,676,467 69,693 96 1,202,963 1,016,278 1,166,903 36,060 97 72,620 54,431 55,001 17,619 76 $ 113,414,442 $ 88,601,880 $ 97,777,063 $ 15,637,379 86 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 $13.910 bond proceeds received in November of 2020, as well as WWTP billings to their partners. 1 Packet Pg. 6 1 I 2.2.a I Page 1 of l C ITY O F EDMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2020 Amended 11/30/2019 11/30/2020 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 49,044,056 $ 38,835,500 $ 38,995,588 $ 10,048,468 800/ 009 LEOFF-MEDICAL INS. RESERVE 467,140 359,126 231,889 235,251 50° 011 RISK MANAGEMENT RESERVE FUND - 931,523 - 00 012 CONTINGENCY RESERVE FUND - 3,835,827 - - 00 014 HISTORIC PRESERVATION GIFT FUND 5,900 5,533 - 5,900 00 018 EDMONDS HOMELESSNESS RESPONSE FUND 100,000 1,862 - 100,000 0° Q. 019 EDMONDSOPIOID RESPONSE FUND 21,555 200,000 21,555 - d 100° 104 DRUG ENFORCEMENT FUND 45,800 - 30,332 15,468 660/ t� 111 STREET FUND 2,199,717 1,757,213 1,859,996 339,721 850/ C 112 COMBINED STREET CONST/IMPROVE 2,811,463 1,538,558 1,064,847 1,746,616 3M j,i 117 MUNICIPAL ARTS ACQUIS. FUND 243,880 54,009 30,367 213,513 120/ 120 HOTEL/MOTEL TAX REVENUE FUND 128,250 66,525 50,215 78,035 r� 390/ C 121 EMPLOYEE PARKING PERMIT FUND 26,880 591 632 26,248 2° 2 0 122 YOUTH SCHOLARSHIP FUND 3,000 2,768 450 2,550 150, C 123 TOURISM PROMOTIONAL FUND/ARTS 33,900 15,274 10,399 23,501 31cm° N 125 REAL ESTATE EXCISE TAX 2 3,610,520 1,212,769 1,485,522 2,124,998 410/ 126 REAL ESTATE EXCISE TAX 1 3,401,093 1,316,452 1,456,999 1,944,094 430/ > 127 GIFTSCATALOGFUND 113,782 68,389 87,751 26,031 770, Z 130 CEMETERY MAINTENANCE/IMPROVEMT 195,787 175,728 165,679 30,108 850/ r- 136 PARKS TRUST FUND - 4,935 - - 00 O CL 138 SISTER CITY COMMISSION 11,900 6,851 11 11,889 O 00/ 140 BUSINESS IMPROVEMENT DISTRICT 80,510 80,787 50,200 30,310 62° •v 142 EDMONDS CARES FUND 1,897,650 - 1,698,013 199,637 890 C 211 L.I.D. FUND CONTROL 12,400 30,905 - 12,400 0° jL 231 2012 LT GO DEBT SERVICE FUND 738,400 53,388 47,291 691,109 69, s 332 PARKS CAPITAL CONSTRUCTION FUND 13,013,343 221,591 1,335,262 11,678,081 100, C 421 WATER UTILITYFUND 12,809,352 8,443,156 9,551,953 3,257,399 75° E 0 422 STORM UTILITY FUND 10,831,951 4,516,795 7,007,409 3,824,542 650/ G 423 SEWER/WWTP UTILITYFUND 32,767,560 10,187,363 16,676,611 16,090,949 5101 d 424 BOND RESERVE FUND 1,988,130 625,592 616,542 1,371,588 31° 511 EQUIPMENT RENTAL FUND 3,170,398 2,421,572 2,814,377 356,021 890/ > 512 TECHNOLOGY RENTAL FUND 1,454,784 802,787 912,391 542,393 630 Z 617 FIREMEN'S PENSION FUND 78,700 130,448 75,665 3,035 960/ $ 141,307,801 $ 77,903,816 S 86,277,947 S 55,029,854 619 O E 2 Packet Pg. 7 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 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 WATERUTILITY TAX 11 SEWER UTILITY TAX 12 STORMWATER UTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABSTAX 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-COMCASI' 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 DOJ 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 CORONAVIRUS RELIEF FUND 41 STATE GRANTS- BUDGET ONLY 42 PUD PRIVILEDGE TAX 43 ARCHIVES AND RECORDS MANAGEMENT 44 STATE GRANT FROM OTHER JUDICIAL AGENCIES 45 SCHOOL ZONE 46 WA STATE TRAFFIC COMM GRANT 47 MVET/SPECIAL DISTRIBUTION 48 WASHINGTON STATE ARTS COMMISSION 49 SHORELINE MASTER PROGRAM DOE 50 TRIAL COURT IMPROVEMENT 51 CRIMINAL JUSTICE -SPECIAL PROGRAMS 52 MARIJUANA ENFORCEMENT 53 MARIJUANA EXCISE TAX DISTRIBUTION 54 DUI - CITIES 55 LIQUOR EXCISE TAX 56 LIQUOR BOARD PROFITS 57 MISCELLANEOUS INT ERLOCAL REVENUE 58 VERDANT INTERLOCAL GRANTS 59 POLICE TRAINING CLASSES 60 FIRST RESPONDERS FLEX FUND 61 DISCOVERY PROGRAMS TECHNOLOGY ACQ. CITY OF EDMO NDS REVENUES - GENERAL FUND 2020 Amended 11/30/2019 11/30/2020 Amount Budget Revenues Revenues Remaining %Received $ 10,737,617 $ 10,407,850 $ 10,393,947 $ 343,670 970/( 4,112,031 4,024,341 4,058,718 53,313 990/( 500 244 26 474 50/c 8,450,000 7,741,745 7,523,231 926,769 890/( 7,600 8,956 6,895 705 910/( 760,500 742,618 738,431 22,069 970/( 1,684,800 1,553,442 1,540,846 143,954 910/( 579,600 518,080 571,050 8,550 990/( 348,800 325,404 316,060 32,740 910/( 1,148,400 1,098,628 1,022,313 126,087 890/( 896,600 781,768 718,876 177,724 800/( 471,900 413,297 452,696 19,204 960/( 822,200 739,228 736,282 85,918 900/( 823,900 739,258 606,633 217,267 740/( 55,200 55,915 56,617 (1,417) 1030/( 40 383 449 (409) 1123°/ 280,900 220,336 228,029 52,871 810/c 31,180,588 29,371,496 28,971,100 2,209,488 93°/ 250 185 365 (115) 1460/( 700 560 80 620 110/( 6,000 4,675 - 6,000 00/c 50,000 53,247 12,881 37,119 260/( 682,200 676,201 678,877 3,323 1000/( 41,000 37,984 36,612 4,388 890/( 100,600 94,045 73,239 27,361 730/( 358,200 387,851 377,553 (19,353) 10501( 116,300 119,787 203,899 (87,599) 1750/( 63,700 64,409 68,800 (5,100) 1080/( 64,800 53,825 - 64,800 0"/ 13,500 25,089 29,782 (16,282) 2210/( 675,600 591,997 589,029 86,571 870/( 24,380 13,334 17,056 7,324 700/( 45,000 36,430 53,405 (8,405) 1190/( 18,500 19,241 15,592 2,908 840/( 2,260,730 2,178,859 2,157,170 103,560 95°/ 6,000 3,470 2,052 3,949 340/( - 14,616 - - 00/( - 2,285 - - 00/( 4,000 1,852 - 4,000 0°/ - 4,138 559 (559) 00/( 7,100 3,501 1,623 5,477 230/( - - 165,164 (165,164) 00/( 18,000 - - 18,000 00/( 210,500 208,433 207,989 2,511 990/( - - 9,399 (9,399) 00/( - - 140 (140) 00/( - - 825 (825) 00/( - 2,594 - - 0"/ 13,070 12,536 13,211 (141) 1010/( - 5,000 - - 0"/ - 7,165 - - 00/( 16,740 16,722 16,152 588 960/( 45,600 45,102 47,280 (1,680) 1040/( 500 - - 500 00/( 48,300 46,665 50,966 (2,666) 1060/( 6,000 5,827 6,129 (129) 1020/( 231,500 228,650 265,801 (34,301) 1150/c 338,200 255,686 253,877 84,323 750/( - 2,500 - - 00/c - 2,000 - - 00/( - 211 1,194 (1,194) 0"/ 1,000 1,059 4,001 (3,001) 4000/( 550 - - 550 00/( 947,060 870,013 1,046,361 (99,301) 110% O Q. d C t0 c M 21 t C O 2 0 N 0 N L N E O O Z 4 2020 Local Retail Sa/es Use Tax revenues are $(218,514) Igwer than 2019 revenues Please also seepages pages 18 & 19. Packet Pg. 8 I 2.2.a I Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2020 Amended 11/30/2019 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 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 BOOKINGFEES 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 CHECKINGFEES 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 WEIGHT ROOM FEES 41 PROGRAM FEES 5 42 TAXABLE RECREATION ACTIVITIES 43 WINTER MARKET REGISTRATION FEES 44 BIRD FEST REGISTRATION FEES 45 INTERFUND REIMBURSEMENT -CONTRACT SVCS 3,000 600 11,000 300 300 11,000 1,000 100 100 25,100 600 1,000 500 125,000 1,400 85,000 21,000 30,000 126,800 195,000 52,500 1,050 45,000 3,000 10,000 3,500 1,007,500 2,500 50 72,600 375,900 4,000 500 5,000 14,000 15,500 869,162 1,300 5,000 800 3,290,838 3,740 678 13,291 79 68 10,320 1,238 321 59 1,002 192,784 95,475 21,310 38,074 72,018 211,867 2 117 54,941 1,273 42,245 2,454 15,450 5,266 1,043,753 1,066 100 97,600 606,848 9,570 2,361 5,190 14,925 4,707 11,062 787,021 512 10,345 585 2,609,364 11/30/2020 Amount Revenues Remaining % Received 4,988 120 5,951 7 97 235 2,358 766 66 9 450 236,177 71,759 5,795 36,753 198,859 58 59,291 1,755 37,329 2,083 20,099 3,876 992,345 1,880 100 75,019 252,860 15,658 2,960 15,262 3,083 94,929 9,938 2,763,401 (1,988) 480 5,049 293 203 (235) 8,642 234 34 91 25,100 600 550 500 (111,177) 1,400 13,241 15,205 30,000 90,047 (3,859) (58) (6,791) (705) 7,671 917 (10,099) (376) 15,155 620 (50) (2,419) 123,040 (11,658) 500 2,040 (1,262) 12,417 774,233 1,300 (4,938) 800 527,437 6,418,500 5,989,080 4,916,313 1,502,187 166% 20% 54% 2% 32% 0% 21% 77% 66% 0 9% d 0% 0% 45% 0% to 189% C 0% LL 84% 28% 0% O 29% 2 102% N o% N 0% 113% 167% E 83% 69% O 201% ? 111% 98% O 75% 200% 103% 67% C1 391% w 0% 59% LL 109% 0% 20% o 77% 5 2020 Parks & Recreation Program Revenues are $(692,091) lower than 2019 revenues. 4 Packet Pg. 9 1 I 2.2.a I Page 3 of 3 C ITY O F EDMO NDS REVENUES - GENERAL FUND 2020 Amended 11/30/2019 11/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-TRAF 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 M1SC 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 JUDGMENT SIRESTITUT ION 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 012 53 INTERFUND TRANSFER FROM 011 54 INTERFUND TRANSFER FROM 511 55 TRANSFER FROM FUND 127 TOTAL GENERAL FUND REVENUE $ 4,000 $ 3,311 $ 1,178 $ 2,822 290/( 241,000 203,129 107,079 133,921 440/( 19,000 16,628 12,638 6,362 670/( 20,000 15,651 9,570 10,430 480/( 1,000 1,371 1,980 (980) 1980/( 2,000 1,232 1,263 737 630/( 147,000 135,348 65,852 81,148 450/( 2,500 2,861 1,066 1,434 430/( 7,000 8,896 9,180 (2,180) 1310/( 700 429 198 502 280/( 200 55 36 164 180/( 1,500 1,932 2,167 (667) 1440/( 140 - - 140 00/( 30,000 26,595 19,927 10,073 660/( 3,600 2,397 2,136 1,464 590/( 1,000 585 503 497 5001( 100 (2,792) 37 63 370/( 13,100 15,519 6,580 6,520 5001( 600 308 967 (367) 1610/( 1,600 832 678 922 420/( 500 274 86 414 170/( 16,000 10,471 7,635 8,365 480/( 14,000 12,653 7,886 6,114 560/( 6,000 4,457 3,945 2,055 660/( 10,100 5,150 - 10,100 00/( 300 1,208 1,441 (1,141) 4800/( 542,940 468,500 264,028 278,912 49°/ 399,400 380,295 271,547 127,853 680/( 53,440 26,274 13,413 40,027 250/( 50,950 7,560 7,390 43,560 1501( - 150 - - 00/( 153,000 137,985 24,010 128,990 160/( 2,100 1,850 380 1,720 180/( 205,000 185,111 154,822 50,178 760/( 22,500 3,582 910 21,590 40/( 3,500 3,050 920 2,580 260/( 2,000 1,597 635 1,365 320/( 5,000 10,721 100 4,900 20/( 300 68 487 (187) 1620/( 3,000 2,314 3,586 (586) 120°/ 2,000 - - 2,000 00/( 2,000 3 1,344 656 670/( 200 529 248 (48) 1240/( - (71) 16 (16) 00/( 5,000 195,060 13,542 (8,542) 2710/( 100 64 60 40 600/( 100 60 30 70 300/( 150 112 142 8 950/( - 10,483 - - 0°/ - 370 - - 00/( - - 30 (30) 00/c 8,500 7,490 7,251 1,249 850/( 918,240 974,658 500,862 417,378 5507, 3,835,827 - - 00/( - 931,523 - - 00/( 1,500,000 - 1,500,000 - 1000/( 35,800 26,300 35,800 - 1000/( 1,535,800 4,793,650 1,535,800 - 1000% $ 43,803,858 $ 44,646,255 $ 39,391,635 $ 4,412,223 900% 5 Packet Pg. 10 I 2.2.a I Page 1 of 6 CITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 17,066,688 $ 14,415,940 $ 15,148,871 $ 1,917,817 89' 2 OVERTIME 491,580 685,310 564,915 (73,335) 115' 3 HOLIDAY BUY BACK 262,020 201,281 233,372 28,648 89' 4 BENEFITS 6,599,678 5,670,556 5,830,538 769,140 88' 5 UNIFORMS 90,975 96,457 76,959 14,016 85' 6 SUPPLIES 428,811 418,486 390,552 38,259 91' 7 SMALL EQUIPMENT 161,262 135,372 156,325 4,937 97' 8 PROFESSIONAL SERVICES 15,407,641 11,956,972 12,025,030 3,382,611 78' 9 COMMUNICATIONS 169,795 135,313 129,517 40,278 76' 10 TRAVEL 78,580 64,720 9,644 68,936 12' 11 EXCISE TAXES 6,500 7,568 14,622 (8,122) 225' 12 RENTAL/LEASE 1,825,110 1,689,025 1,655,006 170,104 91' 13 INSURANCE 394,124 436,448 393,746 378 100' 14 UTILITIES 531,525 485,985 448,729 82,796 84' 15 REPAIRS&MAINTENANCE 297,010 601,203 630,019 (333,009) 212' 16 MISCELLANEOUS 526,991 361,945 300,161 226,830 57' 17 INTERGOVERNMENTAL PAYMENTS 75,000 75,000 75,000 - 100' 18 INTERFUND SUBSIDIES 3,266,993 1,245,579 834,033 2,432,960 26' 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 131,516 - 168,850 0' 22 OTHER INTEREST & DEBT SERVICE COSTS 500 218 212 288 42' 23 INTEREST ON LONG-TERM EXTERNAL DEBT 137,250 10,311 69,285 67,965 50' 49,044,056 S 38,835,500 38,995,588 10,048,468 80' LEO FF-MEDICAL INS. RESERVE (009) 24 BENEFITS $ 206,650 $ 139,390 $ 134,758 $ 71,892 65' 25 PENSION AND DISABILITY PAYMENTS 252,990 219,100 91,339 161,651 36' 26 PROFESSIONAL SERVICES 7,000 180 5,793 1,207 83' 27 MISCELLANEOUS 500 455 - 500 0' 467,140 359,126 231,889 235,251 50' RISK MANAGEMENT RESERVE FUND (011) 28 INTERFUND SUBSIDIES $ - $ 931,523 $ - $ - 0' $ - 931,523 - - 0' C O NTINGENC Y RES ERVE FUND (012) 29 INTERFUND SUBSIDIES $ $ 3,835,827 $ - $ - 0' - 3,835,827 - - 0' HISTORIC PRESERVATION GIFT FUND (014) 30 SUPPLIES $ 100 $ - $ - $ 100 0' 31 PROFESSIONAL SERVICES 200 - 200 0' 32 MISCELLANEOUS 5,600 5,533 5,600 0' 5,900 5,533 5,900 0' EDMONDS HOMELESSNESS RESPONSEFUND (018) 33 PROFESSIONAL SERVICES $ 100,000 $ 1,862 $ $ 100,000 0' 100,000 1,862 100,000 0' EDMONDS OPIOID RESPONSEFUND (019) 34 PROFESSIONAL SERVICES $ 21,555 $ - $ 21,555 $ - 100' 35 INTERFUND SUBSIDIES - 200,000 - - 0' 21,555 200,000 21,555 - 100' DRUG INFO RC EM NT FUND (104) 36 PROFESSIONAL SERVICES $ 45,000 $ - $ - $ 45,000 0' 37 REPAIR/MAINT 800 - 800 0' 38 MISCELLANEOUS - 30,332 (30,332) 0' 45,800 30,332 15,468 66' O a d OC 0 C to C IL t C O 2 0 N O N N I: tU O Z 6 Packet Pg. 11 I 2.2.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent STREETFUND (111) 1 SALARIES AND WAGES $ 723,081 $ 539,193 $ 603,371 $ 119,710 83' 2 OVERTIME 18,400 44,526 40,436 (22,036) 220' 3 BENEFITS 309,539 255,891 298,334 11,205 96' 4 UNIFORMS 6,000 3,278 3,781 2,219 63' 5 SUPPLIES 263,000 231,710 159,814 103,186 61' 6 SMALL EQUIPMENT 20,000 2,279 684 19,316 3' 7 PROFESSIONAL SERVICES 27,930 7,702 2,456 25,474 9' 8 COMMUNICATIONS 4,500 6,034 6,754 (2,254) 150' 9 TRAVEL 1,000 - - 1,000 0' 10 RENTAL/LEASE 230,450 246,589 211,943 18,507 92' 11 INSURANCE 145,219 156,514 156,937 (11,718) 108' 12 UTILITIES 280,918 239,494 235,918 45,000 84' 13 REPAIRS&MAINTENANCE 52,000 21,418 55,353 (3,353) 106' 14 MISCELLANEOUS 13,000 2,296 8,300 4,700 64' 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 STREEI'CONST/IMPROVE(112) 18 SALARIES AND WAGES 19 BENEFIT S 20 PROFESSIONAL SERVICES 21 REPAIR & MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 LAND 25 CONSTRUCTION PROJECTS 26 INTERGOVERNMENTAL LOANS 27 INTEREST MUNICIPAL ARTS ACQUIS. FUND (117) 28 SUPPLIES 29 SMALL EQUIPMENT 30 PROFESSIONAL SERVICES 31 TRAVEL 32 RENTAL/LEASE 33 REPAIRS&MAINTENANCE 34 MISCELLANEOUS HO TEL/MO TEL TAX REVENUE FUND (120) 35 PROFESSIONAL SERVICES 67 MISCELLANEOUS 37 INTERFUND SUBSIDIES 38 MACHINERY/EQUIPMENT EVIPLOYEEPARIIIG PERMIT FUND (121) 39 SUPPLIES 40 PROFESSIONAL SERVICES YOUTH SCHOLARSHIP FUND (122) 41 MISCELLANEOUS TO URIS M PRO MO TIO NAL FUND/ARTS (123 ) 42 PROFESSIONAL SERVICES 43 MISCELLANEOUS $ 2,199,717 $ 1,757,213 $ 1,859,996 $ 339,721 85' $ - $ - $ 10,567 $ (10,567) 0' - - 6,613 (6,613) 0' 680,130 305,235 307,373 372,757 45' 163,028 420,215 320,582 (157,554) 197' - 8 (8) 0' 40,140 40,318 40,121 19 100' - 7,412 - - 0' 1,853,975 690,863 305,428 1,548,547 16' 72,220 72,201 72,201 19 100' 1,970 2,313 1,952 18 99' $ 2,811,463 $ 1,538,558 $ 1,064,847 $ 1,746,616 38' $ 4,700 $ 3,696 $ 302 $ 4,398 6' 1,700 - 116 1,584 7' 228,500 45,347 28,482 200,018 12' 80 6 - 80 0' 2,000 - - 2,000 0' 300 - - 300 0' 6,600 4,960 1,466 5,134 22' $ 243,880 $ 54,009 $ 30,367 $ 213,513 12' $ 92,487 $ 61,942 $ 45,603 $ 46,884 49' 6,763 583 612 6,151 9' 4,000 4,000 4,000 - 100' 25,000 - - 25,000 0' $ 128,250 $ 66,525 $ 50,215 $ 78,035 39' $ 1,790 $ 591 $ 632 $ 1,158 35' 25,090 - - 25,090 0' $ 26,880 $ 591 $ 632 $ 26,248 2' $ 3,000 $ 2,768 $ 450 $ 2,550 15' $ 3,000 $ 2,768 $ 450 $ 2,550 15' $ 33,900 $ 13,315 $ 10,399 $ 23,501 3P - 1,959 - - 0' $ 33,900 $ 15,274 $ 10,399 $ 23,501 31' O a d oc W C t0 C IL t C O 2 0 N O N L d M E d O Z 7 Packet Pg. 12 I 2.2.a I Page 3 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ 21,000 $ 34,096 $ 18,697 $ 2,303 89' 2 PROFESSIONAL SERVICES 479,831 148,857 328,398 151,433 68' 3 RENTAL/LEASE - 381 - - 0' 4 REPAIRS&MAINTENANCE 176,176 400,623 357,539 (181,363) 203' 5 INTERFUND SUBSIDIES 620 - - 620 0' 6 CONSTRUCTION PROJECTS 2,932,893 628,813 780,889 2,152,004 27' $ 3,610,520 $ 1,212,769 $ 1,485,522 $ 2,124,998 41' 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 14 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 15 SUPPLIES 16 SMALL EQUIPMENT 17 PROFESSIONAL SERVICES 18 REPAIRS&MAINTENANCE 19 MISCELLANEOUS 20 INTERFUND SUBSIDIES CEVIEERYMAINTEVANCERMPROVEM NT(130) 21 SALARIES AND WAGES 22 OVERTIME 23 BENEFIT S 24 UNIFORMS 25 SUPPLIES 26 SUPPLIES PURCHASED FOR INVENTORY/RESALE 27 SMALL EQUIPMENT 28 PROFESSIONAL SERVICES 29 COMMUNICATIONS 30 TRAVEL 31 RENTAL/LEASE 32 UTILITIES 33 REPAIRS&MAINTENANCE 34 MISCELLANEOUS PARKS TRUSTFUND (136) 35 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 36 SUPPLIES 37 TRAVEL 38 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 39 SUPPLIES 40 PROFESSIONAL SERVICES 41 MISCELLANEOUS EDMONDS CARES FUND (142) 42 PROFESSIONAL SERVICES LID FUND CONTROL (211) 43 INTERFUND SUBSIDIES 2012 LTGO DEBT SERVIC FUND (231) ## GENERAL OBLIGATION BOND 44 INTEREST $ 883,267 $ 129,465 $ 630,538 252,729 71' 95,963 397,911 258,039 (162,076) 269' 142,736 14,013 12,963 129,774 9' 300,000 - - 300,000 0' 1,951,937 773,307 553,402 1,398,535 28' 24,220 - - 24,220 0' 2,970 1,680 1,484 1,486 50' - 77 575 (575) 0' $ 3,401,093 $ 1,316,452 $ 1,456,999 $ 1,944,094 43' $ 48,882 $ 28,863 $ 39,033 $ 9,849 80' - 11,209 - - 0' 6,500 - 5,400 1,100 83' 22,000 1,858 7,183 14,818 33' 600 159 335 265 56' 35,800 26,300 35,800 - 100' $ 113,782 $ 68,389 $ 87,751 $ 26,031 77' $ 97,476 $ 82,654 $ 86,562 $ 10,914 89' 3,500 3,272 729 2,771 21' 42,029 37,814 37,084 4,945 88' 1,000 225 - 1,000 0' 7,000 3,584 2,802 4,198 40' 20,000 15,673 18,196 1,804 91' - 1,246 1,184 (1,184) 0' 4,200 1,799 795 3,405 19' 1,700 1,655 1,541 159 91' 500 - - 500 0' 8,230 5,738 7,544 686 92' 5,652 4,137 4,118 1,534 734 500 - - 500 0' 4,000 17,930 5,124 (1,124) 1284 $ 195,787 $ 175,728 $ 165,679 $ 30,108 854 $ - $ 4,935 $ - $ - 0' $ - $ 4,935 $ - $ - 0' $ 1,500 $ 727 $ 11 $ 1,489 1' 4,500 2,705 - 4,500 0' 5,900 3,418 - 5,900 0' $ 11,900 $ 6,851 $ 11 $ 11,889 0' $ 11,850 $ 12,278 $ 9,585 $ 2,265 81' 66,035 65,958 38,175 27,860 58' 2,625 2,551 2,440 185 93' 80,510 80,787 50,200 30,310 62' $ 1,897,650 $ $ 1,698,013 $ 199,637 89' 1,897,650 1,698,013 199,637 89' $ 12,400 $ 30,905 $ - $ 12,400 0' $ 12,400 $ 30,905 $ - $ 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' O Q. d C t0 C LL t r� C O 2 0 N O N L d E d O Z 8 Packet Pg. 13 I 2.2.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 323,349 $ 44,827 $ 402,104 $ (78,755) 124' 2 INTERFUND SUBSIDIES 112,920 - 20,316 92,604 18' 3 CONSTRUCTION PROJECTS 12,577,074 114,223 912,842 11,664,232 7' 4 DEBT ISSUE COSTS - 62,541 - - 0' $ 13,013,343 $ 221,591 $ 1,335,262 $ 11,678,081 10' WATER FUND (421) 5 SALARIES AND WAGES 6 OVERTIME 7 BENEFIT S 8 UNIFORMS 9 SUPPLIES 10 WATER PURCHASED FOR RESALE 11 SUPPLIES PURCHASED FOR INVENTORY/RESALE 12 SMALL EQUIPMENT 13 PROFESSIONAL SERVICES 14 COMMUNICATIONS 15 TRAVEL 16 EXCISE TAXES 17 RENTAL/LEASE 18 INSURANCE 19 UTILITIES 20 REPAIRS&MAINTENANCE 21 MISCELLANEOUS 22 INTERFUND SUBSIDIES 23 CONSTRUCTION PROJECTS 24 GENERAL OBLIGATION BONDS 25 REVENUE BONDS 26 INTERGOVERNMENTAL LOANS 27 INTEREST 28 OTHER INTEREST & DEBT SERVICE COSTS STORMFUND (422) 29 SALARIES AND WAGES 30 OVERTIME 31 BENEFIT S 32 UNIFORMS 33 SUPPLIES 34 SMALL EQUIPMENT 35 PROFESSIONAL SERVICES 36 COMMUNICATIONS 37 TRAVEL 38 EXCISE TAXES 39 RENTAL/LEASE 40 INSURANCE 41 UTILITES 42 REPAIR & MAINTENANCE 43 MISCELLANEOUS 44 INTERFUND SUBSIDIES 45 CONSTRUCTION PROJECTS 46 GENERAL OBLIGATION BONDS 47 REVENUE BONDS 48 INTERGOVERNMENTAL LOANS 49 INTEREST 50 OTHER INTEREST & DEBT SERVICE COSTS $ 845,871 $ 700,142 $ 742,779 $ 103,092 88' 24,000 22,686 18,958 5,042 79' 363,882 314,310 285,899 77,983 79' 4,000 3,326 3,473 527 87' 150,000 65,468 103,754 46,246 69' 2,170,000 1,747,306 1,786,606 383,394 82' 170,000 138,405 143,823 26,177 85' 11,000 5,379 5,804 5,196 53' 1,753,804 774,900 1,186,381 567,423 68' 30,000 26,143 25,763 4,237 86' 200 - - 200 0' 1,649,700 1,53 5,128 1,452,789 196,911 88' 133,158 139,852 119,441 13,717 90' 52,865 55,096 52,541 324 99' 35,775 24,375 24,571 11,204 69' 75,830 237,035 20,613 55,217 27' 131,400 106,864 120,680 10,720 92' 650,870 206,313 204,067 446,803 31' 3,946,207 2,201,038 3,121,887 824,320 79' 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' - 375 378 (378) 0' $ 12,809,352 $ 8,443,156 $ 9,551,953 $ 3,257,399 75' $ 728,080 $ 604,229 $ 584,113 $ 143,967 80' 6,000 33,218 12,741 (6,741) 212' 334,154 303,321 267,341 66,813 80' 6,500 5,539 6,437 63 99' 46,000 23,878 20,886 25,114 45' 4,000 3,653 2,026 1,974 51' 3,047,970 1,004,567 1,673,878 1,374,092 55' 3,200 4,533 5,213 (2,013) 163' 4,300 - - 4,300 0' 470,100 480,394 525,221 (55,121) 112' 270,830 223,180 247,669 23,161 91' 118,263 127,548 116,576 1,687 99' 11,025 10,438 11,024 1 100' 116,183 12,644 15,835 100,348 14' 158,100 150,451 158,483 (383) 100' 282,550 81,819 78,897 203,653 28' 4,758,296 1,352,186 3,166,559 1,591,737 67' 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' - 165 165 (165) 0' $ 10,831,951 $ 4,516,795 $ 7,007,409 $ 3,824,542 65' 9 Packet Pg. 14 I 2.2.a I Page 5 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 1,953,719 $ 1,628,375 $ 1,714,559 $ 239,160 88' 2 OVERTIME 95,000 87,115 95,567 (567) 101' 3 BENEFITS 854,294 714,295 739,058 115,236 87' 4 UNIFORMS 9,500 7,146 7,693 1,807 81' 5 SUPPLIES 421,000 271,259 321,524 99,476 76' 6 FUEL CONSUMED 60,000 39,396 17,701 42,299 30' 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 0' 8 SMALL EQUIPMENT 35,000 19,460 42,890 (7,890) 123' 9 PROFESSIONAL SERVICES 2,286,406 1,059,865 3,143,528 (857,122) 137' 10 COMMUNICATIONS 43,000 38,324 36,534 6,466 85' 11 TRAVEL 5,000 5,016 - 5,000 0' 12 EXCISE TAXES 978,000 980,493 894,700 83,300 91' 13 RENTAL/LEASE 311,966 309,796 294,791 17,175 94' 14 INSURANCE 182,121 186,110 175,867 6,254 97' 15 UTILITIES 1,540,685 1,026,522 806,379 734,306 52' 16 REPAIR & MAINTENANCE 745,630 384,242 197,348 548,282 26' 17 MISCELLANEOUS 127,650 77,641 82,272 45,378 64' 18 INTERFUND SUBSIDIES 7,197,114 851,088 2,584,681 4,612,433 36' 19 MACHINERY/EQUIPMENT - 33,647 83,575 (83,575) 0' 20 CONSTRUCTION PROJECTS 15,438,495 2,249,150 5,023,028 10,415,467 33' 21 GENERAL OBLIGATION BONDS 154,660 - - 154,660 0' 22 REVENUE BONDS 82,840 - 162,108 (79,268) 196' 23 INTERGOVERNMENTAL LOANS 173,210 172,528 173,200 10 100' 24 INTEREST 68,270 40,516 36,505 31,765 53' 25 DEBT ISSUE COSTS - - 38,018 (38,018) 0' 26 OTHER INT EREST & DEBT SERVICE COSTS - 5,380 5,085 (5,085) 0' $ 32,767,560 $ 10,187,363 $ 16,676,611 $ 16,090,949 5P BOND RESERVE FUND (424) 27 REVENUE BONDS $ 755,020 $ - $ - $ 755,020 0' 28 INTEREST 1,233,110 625,592 616,542 616,568 504 $ 1,988,130 $ 625,592 $ 616,542 $ 1,371,588 314 O Q. d OC W C t0 C LL t C O 2 0 N 0 N L N E CD Z 10 Packet Pg. 15 I 2.2.a I Page 6 of 6 CITY 0FIDMONDS EXPENDITURES BY FUND - DETAIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 266,952 $ 237,918 $ 246,472 $ 20,480 92' 2 OVERTIME 2,000 8,081 824 1,176 41' 3 BENEFITS 112,598 101,900 102,469 10,129 91' 4 UNIFORMS 1,000 1,285 1,144 (144) 114' 5 SUPPLIES 130,000 87,099 69,800 60,200 54' 6 FUEL CONSUMED 1,000 - - 1,000 0' 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 243,000 168,446 103,592 139,408 43' 8 SMALL EQUIPMENT 58,000 2,058 3,314 54,686 6' 9 PROFESSIONAL SERVICES 46,750 3,944 4,387 42,363 9' 10 COMMUNICATIONS 3,000 2,022 2,022 978 67' 11 TRAVEL 1,000 255 - 1,000 0' 12 RENTAL/LEASE 12,750 12,590 11,301 1,449 89' 13 INSURANCE 27,848 30,167 43,001 (15,153) 154' 14 UTILITIES 14,500 13,413 13,529 971 93' 15 REPAIRS & MAINTENANCE 60,000 26,707 39,369 20,631 66' 16 MISCELLANEOUS 12,000 9,707 9,408 2,592 78' 17 INTERFUND SUBSIDIES 1,500,000 - 1,500,000 - 100' 18 MACHINERY/EQUIPMENT 678,000 1,715,980 663,744 14,256 98' $ 3,170,398 $ 2,421,572 $ 2,814,377 $ 356,021 89' TECHNOLOGY RENTAL FUND (512) 19 SALARIES AND WAGES $ 369,264 $ 273,729 $ 265,409 $ 103,855 72' 20 OVERTIME 2,000 125 165 1,835 8' 21 BENEFITS 124,590 92,533 89,101 35,489 72' 22 SUPPLIES 5,000 3,999 8,726 (3,726) 175' 23 SMALL EQUIPMENT 137,700 38,181 112,405 25,295 82' 24 PROFESSIONAL SERVICES 309,810 27,545 70,185 239,625 234 25 COMMUNICATIONS 58,770 51,326 56,619 2,151 964 26 TRAVEL 1,500 359 - 1,500 0' 27 RENTAL/LEASE 7,490 6,950 6,897 593 92' 28 REPAIRS & MAINTENANCE 367,660 247,098 291,331 76,329 794 29 MISCELLANEOUS 5,000 3,370 11,552 (6,552) 23P 30 MACHINERY/EQUIPMENT 66,000 57,571 - 66,000 0' $ 1,454,784 $ 802,787 $ 912,391 $ 542,393 63' FIREMEN'S PENSION FUND (617) 31 BENEFITS $ 23,000 $ 16,535 $ 18,045 $ 4,955 784 32 PENSION AND DISABILITY PAYMENTS 54,500 113,913 56,613 (2,113) 104' 33 PROFESSIONAL SERVICES 1,200 - 1,007 193 84' $ 78,700 $ 130,448 $ 75,665 $ 3,035 964 TOTAL EXPENDITURE ALL FUNDS $ 141,307,801 $ 77,903,816 $ 86,277,947 $ 55,029,854 614 O fl. d W C to C IL 21 t C O 2 0 N O N N E d O Z 11 Packet Pg. 16 2.2.a Page 1 of 1 C ITY O F EDMO NDS EXPENDPTURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2020 Amended 11/30/2019 11/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 $ 366,198 $ 291,826 $ 127,086 70% 306,685 269,577 303,765 2,920 99% 740,691 495,072 589,830 150,861 80% 1,138,771 896,507 958,702 180,069 84%^+ O 726,962 646,693 667,373 59,589 92% d 1,289,583 1,161,563 1,219,675 69,908 95% O 912,540 777,372 789,302 123,238 86% 15,322,110 11,630,592 11,046,084 4,276,026 72% O C IL 11,951,730 10,676,934 10,862,724 1,089,006 91% >, 761,493 534,111 532,055 229,438 70% z O 3,582,847 2,580,570 2,519,329 1,063,518 70% 22 4,594,969 3,739,491 3,343,289 1,251,680 73% 0 C 3,538,610 2,842,887 2,870,124 668,486 81% N 3,758,153 2,217,933 3,001,512 756,641 80% E $ 49,044,056 $ 38,835,500 $ 38,995,588 $ 10,048,468 80% C Z C ITY O F EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2020 Amended Budget 11/30/2019 Expenditures 11/30/2020 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 12,809,352 $ 8,443,156 $ 9,551,953 $ 3,257,399 75% STORM UTILITY FUND 10,831,951 4,516,795 7,007,409 3,824,542 65% SEWER/WWTP UTILITY FUND 32,767,560 10,187,363 16,676,611 16,090,949 51% BOND RESERVE FUND 1,988,130 625,592 616,542 1,371,588 31% $ 58,396,993 $ 23,772,906 $ 33,852,515 $ 24,544,478 58% 12 Packet Pg. 17 Page 1 of 4 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2020 Amended Budget 11/30/2019 Expenditures 11/30/2020 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES $ 191,224 $ 165,274 $ 174,575 $ 16,649 91% OVERTIME 1,000 - - 1,000 0% BENEFITS 95,736 89,547 90,616 5,120 95% SUPPLIES 2,500 1,931 1,670 830 67% SMALL EQUIPMENT 1,000 342 534 466 53% PROFESSIONAL SERVICES 62,160 79,552 4,263 57,897 7% COMMUNICATIONS 5,000 5,387 7,442 (2,442) 149% TRAVEL 17,500 2,625 587 16,913 3% RENTAL/LEASE 12,292 11,077 11,314 978 92% REPAIRS✓MAINTENANCE 500 121 645 (145) 129% MISCELLANEOUS 30,000 10,341 180 29,820 1% $ 418,912 $ 366,198 $ 291,826 $ 127,086 70% OFFICEOFMAYOR SALARIES $ 222,432 $ 200,668 $ 204,891 $ 17,541 92% BENEFITS 54,043 48,859 77,069 (23,026) 143% SUPPLIES 1,500 794 850 650 57% SMALL EQUIPMENT - - 4,199 (4,199) 0% PROFESSIONAL SERVICES 3,000 2,211 633 2,367 21% COMMUNICATION 1,400 955 1,191 209 85% TRAVEL 3,000 2,603 166 2,834 6% RENTAL/LEASE 16,860 11,503 14,554 2,306 86% MISCELLANEOUS 4,450 1,984 213 4,237 5% $ 306,685 $ 269,577 $ 303,765 $ 2,920 99% HUMAN RESOURCES SALARIES $ 356,658 $ 293,634 $ 324,679 $ 31,979 91% OVERTIME - 197 5,845 (5,845) 0% BENEFITS 142,458 100,815 130,836 11,622 92% SUPPLIES 18,556 4,250 3,925 14,631 21% SMALL EQUIPMENT 300 2,762 893 (593) 298% PROFESSIONAL SERVICES 136,471 44,122 65,266 71,205 48% COMMUNICATIONS 1,550 1,064 1,138 412 73% TRAVEL 1,000 1,241 - 1,000 0% RENTAL/LEASE 31,921 22,597 27,988 3,933 88% REPAIR/MAINTENANCE 8,380 7,571 7,832 548 93% MISCELLANEOUS 43,397 16,818 21,429 21,968 49% $ 740,691 $ 495,072 $ 589,830 $ 150,861 80% MUNIC IPAL C O URT SALARIES $ 647,030 $ 537,521 $ 578,188 $ 68,842 89% OVERTIME 800 1,275 9,041 (8,241) 1130% BENEFITS 223,319 190,349 211,537 11,782 95% SUPPLIES 10,600 7,713 5,933 4,667 56% SMALL EQUIPMENT 1,000 5,155 7,074 (6,074) 707% PROFESSIONAL SERVICES 124,925 67,990 59,168 65,757 47% COMMUNICATIONS 3,550 2,633 2,135 1,415 60% TRAVEL 6,500 3,039 37 6,463 1% RENTAL/LEASE 67,947 59,103 61,845 6,102 91% REPAIR/MAINTENANCE 4,880 277 7,896 (3,016) 162% MISCELLANEOUS 25,100 21,452 15,848 9,252 63% MACHINERY/EQUIPMENT 23,120 23,120 0% $ 1,138,771 $ 896,507 $ 958,702 $ 180,069 84% 13 Packet Pg. 18 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 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY CLERK SALARIES AND WAGES $ 376,214 $ 332,212 $ 367,212 $ 9,002 98% BENEFITS 156,718 147,060 149,762 6,956 96% SUPPLIES 10,240 2,465 3,498 6,742 34% SMALL EQUIPMENT - 4,024 2,682 (2,682) 0% PROFESSIONAL SERVICES 37,410 28,368 23,843 13,567 64% COMMUNICATIONS 40,000 24,997 17,109 22,891 43% TRAVEL 2,000 497 6 1,994 0% RENTAL/LEASE 63,850 46,782 47,856 15,994 75% REPAIRS&MAINTENANCE 32,530 50,240 49,303 (16,773) 152% MISCELLANEOUS 8,000 10,049 6,101 1,899 76% $ 726,962 $ 646,693 $ 667,373 $ 59,589 92% FINANCE SALARIES $ 870,882 $ 781,048 $ 869,021 $ 1,861 100% OVERTIME 4,500 - - 4,500 0% BENEFITS 289,923 266,743 240,697 49,226 83% SUPPLIES 7,350 5,793 5,110 2,240 70% SMALL EQUIPMENT 2,650 579 66 2,584 2% PROFESSIONAL SERVICES 9,300 1,725 1,518 7,782 16% COMMUNICATIONS 2,000 1,116 713 1,287 36% TRAVEL 3,100 2,371 - 3,100 0% RENTAL/LEASE 50,048 47,291 53,005 (2,957) 106% REPAIR/MAINTENANCE 41,480 42,499 43,963 (2,483) 106% MISCELLANEOUS 8,350 12,396 5,581 2,769 67% $ 1,289,583 $ 1,161,563 $ 1,219,675 $ 69,908 95% CITY ATTO RNEY PROFESSIONAL SERVICES $ 912,540 $ 777,372 $ 789,302 $ 123,238 86% $ 912,540 $ 777,372 $ 789,302 $ 123,238 86% NON -DEPARTMENTAL SALARIES $ 101,750 $ - $ - $ 101,750 0% BENEFITS -UNEMPLOYMENT 50,000 31,218 1,254 48,746 3% SUPPLIES 5,000 4,800 3,981 1,019 80% PROFESSIONAL SERVICES 11,009,120 9,604,564 9,537,016 1,472,104 87% EXCISE TAXES 6,500 7,568 14,622 (8,122) 225% RENTAL/LEASE 15,249 11,372 13,989 1,260 92% INSURANCE 394,124 436,448 393,746 378 100% MISCELLANEOUS 91,774 71,999 102,947 (11,173) 112% CONTRIBUTION TO ECA 75,000 75,000 75,000 - 100% INTERFUND SUBSIDIES 3,266,993 1,245,579 834,033 2,432,960 26% GENERAL OBLIGATION BOND 168,850 131,516 - 168,850 0% INTEREST ON LONG-TERM DEBT 137,250 10,311 69,285 67,965 50% FISCAL AGENT FEES 500 218 212 288 42% $ 15,322,110 $ 11,630,592 $ 11,046,084 $ 4,276,026 72% 14 Packet Pg. 19 I 2.2.a I Page 3 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent PO LIC E S ERVIC ES SALARIES $ 6,968,887 $ 5,978,609 $ 6,326,496 $ 642,391 91% OVERTIME 461,280 640,712 523,433 (62,153) 113% HOLIDAY BUYBACK 262,020 201,281 233,372 28,648 89% BENEFITS 2,769,042 2,404,189 2,548,129 220,913 92% UNIFORMS 80,750 85,595 56,903 23,847 70% SUPPLIES 90,500 83,715 72,304 18,196 80% SMALL EQUIPMENT 127,739 103,339 115,311 12,428 90% PROFESSIONAL SERVICES 224,548 215,561 156,266 68,282 70% COMMUNICATIONS 36,000 35,591 36,450 (450) 101% TRAVEL 29,310 34,673 7,417 21,893 25% RENTAL/LEASE 826,124 840,138 750,488 75,636 91% REPAIR/MAINTENANCE 15,180 10,150 5,515 9,665 36% MISCELLANEOUS 60,350 43,383 30,638 29,712 51% $ 11,951,730 $ 10,676,934 $ 10,862,724 $ 1,089,006 91% COMMUNITY S ERVIC ES /EC 0 N DEV. SALARIES $ 357,423 $ 240,459 $ 321,554 $ 35,869 90% OVERTIME - - 93 (93) 0% BENEFITS 114,637 73,573 87,040 27,597 76% SUPPLIES 7,475 6,457 6,961 514 93% SMALL EQUIPMENT 4,173 - 3,321 852 80% PROFESSIONAL SERVICES 214,400 196,196 95,133 119,267 44% COMMUNICATIONS 2,975 1,249 1,822 1,153 61 % TRAVEL 2,000 - 1,020 980 51% RENTAL/LEASE 13,410 11,094 10,814 2,596 81% REPAIR/MAINTENANCE 10,500 - - 10,500 0% MISCELLANEOUS 9,500 5,083 4,297 5,203 45% MACHINERY/EQUIPMENT 25,000 - - 25,000 0% $ 761,493 $ 534,111 $ 532,055 $ 229,438 70% DEVELOPMENT SERVICES/PLANNING SALARIES $ 1,760,943 $ 1,496,536 $ 1,564,613 $ 196,330 89% OVERTIME 1,300 9,002 13,685 (12,385) 1053% BENEFITS 658,292 571,678 568,092 90,200 86% UNIFORMS 500 - - 500 0% SUPPLIES 17,100 10,880 6,321 10,779 37% SMALL EQUIPMENT 7,300 5,796 2,404 4,896 33% PROFESSIONAL SERVICES 886,518 300,489 153,902 732,616 17% COMMUNICATIONS 9,000 7,794 9,759 (759) 108% TRAVEL 6,800 9,918 228 6,572 3% RENTAL/LEASE 170,234 131,518 155,250 14,984 91% REPAIRS&MAINTENANCE 6,800 3,439 2,928 3,872 43% MISCELLANEOUS 58,060 33,521 42,146 15,914 73% $ 3,582,847 S 2,580,570 $ 2,519,329 $ 1,063,518 70% ENGINEERING SALARIES $ 1,772,804 $ 1,560,001 $ 1,589,888 $ 182,916 90% OVERTIME 5,000 7,133 3,012 1,988 60% BENEFITS 701,327 637,227 640,510 60,817 91% UNIFORMS 450 298 256 194 57% SUPPLIES - 32 - - 0% SMALL EQUIPMENT 2,200 552 868 1,332 39% PROFESSIONAL SERVICES 188,840 1,961 1,530 187,310 1% COMMUNICATIONS 19,600 13,354 13,927 5,673 71% TRAVEL 600 1,043 134 466 22% RENTAL/LEASE 134,995 111,785 121,034 13,961 90% REPAIR/MAINTENANCE 2,600 - 769 1,831 30% MISCELLANEOUS 80,000 55,307 32,813 47,187 41% $ 2,908,416 $ 2,388,692 $ 2,404,742 $ 503,674 83% O s?. d C O C LL t r� C O 2 O N O N L N E CD Z 15 Packet Pg. 20 I 2.2.a I Page 4 of 4 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DEr'AIL 2020 Amended 11/30/2019 11/30/2020 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS & REC REATIO N SALARIES $ 2,272,394 $ 1,861,308 $ 1,833,064 $ 439,330 81% OVERTIME 10,000 20,286 4,738 5,262 47% BENEFITS 864,290 706,785 680,228 184,062 79% UNIFORMS 6,275 5,898 5,367 908 86% SUPPLIES 137,390 142,530 137,731 (341) 100% SMALL EQUIPMENT 10,900 5,486 7,925 2,975 73% PROFESSIONAL SERVICES 620,765 399,086 173,972 446,793 28% COMMUNICATIONS 31,370 22,398 16,212 15,158 52% TRAVEL 5,270 5,276 50 5,220 1% RENTAL/LEASE 268,945 250,368 250,790 18,155 93% PUBLIC UTILITY 230,507 199,956 172,905 57,602 75% REPAIR/MAINTENANCE 29,700 34,334 16,593 13,107 56% MISCELLANEOUS 98,110 75,484 34,660 63,450 35% MACHINERY/EQUIPMENT 9,053 - 9,053 0 100% CONSTRUCTION PROJECTS 10,296 0% $ 4,594,969 $ 3,739,491 $ 3,343,289 $ 1,251,680 73% PUBLIC WORKS ADMINISTRATION SALARIES $ 380,790 $ 265,825 $ 272,451 $ 108,339 72% OVERTIME 200 339 - 200 0% BENEFITS 131,041 93,494 95,779 35,262 73% SUPPLIES 8,600 4,063 3,702 4,898 43% SMALL EQUIPMENT 1,000 2,115 264 736 26% PROFESSIONAL SERVICES 200 97 136 64 68% COMMUNICATIONS 1,350 617 628 722 47% TRAVEL 500 1,427 - 500 0% RENTAL/LEASE 97,295 82,496 88,031 9,264 90% PUBLIC UTILITY 3,318 2,747 2,886 432 87% REPAIR/MAINTENANCE 1,000 - - 1,000 0% MISCELLANEOUS 4,900 975 1,505 3,395 31% $ 630,194 $ 454,194 $ 465,382 $ 164,812 74% FACILITIES MAINTENANCE SALARIES 787,257 702,845 722,238 65,019 92% OVERTIME 7,500 6,366 5,067 2,433 68% BENEFITS 348,852 309,019 308,988 39,864 89% UNIFORMS 3,000 4,666 14,432 (11,432) 481% SUPPLIES 112,000 143,065 138,565 (26,565) 124% SMALL EQUIPMENT 3,000 5,222 10,785 (7,785) 359% PROFESSIONAL SERVICES 977,444 237,679 963,083 14,361 99% COMMUNICATIONS 16,000 18,160 20,990 (4,990) 131% TRAVEL 1,000 6 - 1,000 0% RENTAL/LEASE 55,940 51,898 48,048 7,893 86% PUBLIC UTILITY 297,700 283,282 272,938 24,762 92% REPAIR/MAINTENANCE 143,460 452,572 494,576 (351,116) 345% MISCELLANEOUS 5,000 3,153 1,802 3,198 36% CONST RUCT ION PROJECTS 1,000,000 - - 1,000,000 0% $ 3,758,153 $ 2,217,933 $ 3,001,512 $ 756,641 80% TOTAL GENERAL FUND EXPENDITURES $ 49,044,056 $ 38,835,500 $ 38,995,588 $ 10,048,468 80% O Q. d C O C IL Z C O 2 O N O N L N E CD Z 16 Packet Pg. 21 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 30,980,306 -5.57% November 41,358,293 8,550,508 39,391,635 -4.76% 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 2,574,968 11.90% November 2,520,239 219,202 2,993,059 18.76% December 2,700,000 179,761 *The monthly budget forecast columns are based on a five-year average. O Q. d C C E 21 t a O 2 O N O N L N .0 G CD O Z 17 Packet Pg. 22 1 SALES TAX SUMMARY I 2.2.a I Sales Tax Analysis By Category Current Period: November 2020 Year -to -Date Total $7,523,231 Automotive Repair, Health & Personal Care, $172 365 $227,881 ' Construction Trade, Accommodation, $1,177,901 $27,083 Clothing and Accessories, $223,347 Communications, $215,305 Wholesale Trade, $256,775 Misc Retail, $1,389,458 Others, $153,253 Amusement & Recreation, $44,061 Business Services, $779,765 Gasoline, $34,618 Retail Food Stores, iii $299,009 L Retail Automotive, $1,654,759 Manufacturing, $92,206 Eating & Drinking, $775,445 Annual Sales Tax Revenue 10,000,000 7 395 114 $8,406,296 $8,452,715 8,000,000 $7,523,231 $6,741,838 $6,905,122 $5,840,764 6,000,000 4,000,000 2,000, 000 0 201 2015 2016 2017 2018 2019 YTD 2020 F 0 Ta c c ii c 0 2 0 N O N a� E a� 0 z 18 I Packet Pg. 23 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 6,719,684 -3.47% November 7,750,015 788,965 7,523,231 -2.93% December 8,450,000 699,985 Gas Utility Tax Sales and Use Tax 12,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --b 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 535,796 10.13% November 524,782 38,285 571,050 8.82% 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. 19 Packet Pg. 24 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 579,582 -16.94% November 761,530 63,777 606,633 -20.34% 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 1,430,598 0.17% November 1,552,157 123,924 1,540,846 -0.73% December 1,684,800 132,643 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. 25 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 7,186,022 -8.95% November 8,818,044 925,246 8,061,987 -8.57% 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 4,179,529 -1.95% November 4,618,388 355,654 4,527,535 -1.97% December 4,921,433 303,045 Storm Water Sales 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 11000,000 500,000 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. ZZ Packet Pg. 26 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 7,174,847 -7.54% November 8,620,364 860,417 7,966,021 -7.59% 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 Ir 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. 22 Packet Pg. 27 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 35,443,149 -11.60% November 44,563,572 4,471,329 38,995,587 -12.49% 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 10,148,912 -19.11% November 14,100,020 1,553,651 11,046,084 -21.66% December 15,322,110 1,222,090 Non -Departmental 16,000,000 14,000,000 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 --ft— Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. O Q. d C C LL t C O O N O N L d .0 G CD O Z 23 Packet Pg. 28 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 266,797 -23.10% November 382,373 35,449 291,826 -23.68% 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 276,971 8.86% November 279,429 25,010 303,765 8.71% 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. 24 Packet Pg. 29 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 535,390 -9.38% November 649,771 58,981 589,830 -9.22% 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 872,107 -6.72% November 1,028,111 93,191 958,702 -6.75% December 1,138,771 110,660 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. 25 Packet Pg. 30 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 457,484 -23.38% November 667,285 70,174 532,055 -20.27% 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 611,198 2.22% November 662,981 65,035 667,372 0.66% 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. 26 Packet Pg. 31 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2020 Technology Rental Fund Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % 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 859,114 -23.76% November 1,231,196 104,309 912,391 -25.89% December 1,454,784 223,588 City of Edmonds, WA Monthly Expenditure Report -Finance 2020 Finance Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % 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 1,133,433 4.84% November 1,184,488 103,415 1,219,675 2.97% 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. 27 Packet Pg. 32 ■ 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 718,169 -5.56% November 836,495 76,045 789,302 -5.64% December 912,540 76,045 Police City Attorney 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Year Budget � Prior Year City of'Edmonds, WA Monthly Expenditure Report -Police 2020 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 9,682,005 -0.07% November 10,939,777 1,250,876 10,862,724 -0.70% 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. Z$ Packet Pg. 33 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 2,302,031 -20.61% November 3,239,495 339,883 2,519,329 -22.23% December 3,582,847 343,352 Parks & Recreation Development Services 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --*-- Current Yeaz Budget � Prior Year City of'Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2020 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 3,011,118 -22.33% November 4,200,535 323,894 3,343,289 -20.41% December 4,594,969 394,434 Parks & Recreation 5,000,000 4,500,000 �4 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. 34 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 423,243 -19.25% November 575,881 51,714 465,382 -19.19% 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 2,799,364 -7.05% November 3,381,203 369,574 3,001,512 -11.23% 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. 30 Packet Pg. 35 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 2,204,927 -8.22% November 2,635,839 233,393 2,404,742 -8.77% 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. 36 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of November 30, 2020 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate Grant Cnty WA Bonds 4,014,120 0.09 4,000,000 4,003,640 01/01/21 1.47% First Financial CD 3,000,000 0.36 3,000,000 3,000,000 04/10/21 2.86% G Port of Seattle WA Bonds 273,305 0.42 270,000 271,553 05/01/21 2.23% 0- Grant Cnty WA Bonds 410,553 1.09 405,000 411,217 01/01/22 1.79% FFCB Bonds 1,998,548 1.54 2,000,000 2,051,676 06/14/22 1.88% v Energy Northwest Bonds 1,466,077 1.58 1,345,000 1,446,561 07/01/22 5.00% Energy Northwest Bonds 260,748 1.58 250,000 260,153 07/01/22 2.95% LL Mason & Kitsap Cnty WA Bonds 948,084 2.00 855,000 934,712 12/01/22 5.00% >, FHLB Bonds 3,000,000 2.08 3,000,000 3,004,101 12/30/22 1.79% C Grant Cnty WA Bonds 1,517,955 2.09 1,500,000 1,533,810 01/01/23 1.54% O Q Grant Cnty WA Bonds 576,332 2.09 520,000 571,038 01/01/23 5.00% O Seattle WA Muni Bonds 2,224,500 2.17 2,000,000 2,206,320 02/01/23 5.00% p FHLB Bonds 1,996,590 2.85 2,000,000 1,995,632 10/05/23 0.22% N L First Financial - ECA CD 2,803,516 2.96 2,803,516 2,803,516 11/15/23 2.10% .0 Kent WA Bonds 286,648 3.00 250,000 285,513 12/01/23 5.00% N Spokane County WA Bonds 259,075 4.01 250,000 264,790 12/01/24 2.10% p Z First Financial - Waterfront Center CD 2,000,000 6.92 2,000,000 2,000,000 11/01/27 1.68% TOTAL SECURITIES 27,036,049 2.17 26,448,516 27,044,230 r- O rL Washington State Local Gov't Investment Pool 23,170,739 23,170,739 Demand 0.16% Snohomish County Local Gov't Investment Pool 20,124,557 20,124,557 Demand 1.45% �p TOTAL PORTFOLIO $ 69,743,812 $ 70,339,525 M Port of Issuer Diversification Seattle Kent Seattle WA WA WA, 1%� Muni, 1% III 8% Mason & Fi rst KitsapCnty Financial - WA, 3% CD, 30% Grant Cnty WA, 24% � Spokane FHLB, 19% County Energ°� y 1 Northwest, FFCB, 8% 6% Cash and Investment Balances (in $ Millions) Checki ng, $7.1 , 9% Bonds, $18.6, 25% State LGIP, CD's, $7.8, $23.2, 30% 10% County LGIP, 32 Packet Pg. 37 1 INVESTMENT PORTFOLIO SUMMARY 2.2.a Annual Interest Income $1,400, 000 $1,200,000 $1,000,000 917 754 $865,812 $800,000 $653,690 $600,000 335 926 $423,816 $400,000 $200,000 - t $- 2015 2016 2017 2018 2019 YTD 2020 Edmonds Rate of Return Compared to Benchmark (Rolling 12 months) - - - 6 Month Treasury Rate (Benchmark) City Blended Rate 2.0 1.8 % 1.5 % 1.3 % 1.0 % 0.8 % 0.5 % 0.3 % 0.0 % December ♦ `------------- - - - - -- - - - - February April June August October Maturity Distribution and Rate of Return $ 8,000, 000 4.00 % $ 7,000, 000 3.50% $ 6,000, 000 3.00 % $ 5,000, 000 2.50 % $4,000, 000 2.00% $3,000, 000 1.50% $ 2,000, 000 1.00% $1,000,000 ' 0.50% $- — 0.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 O Q. d c c ii 21 t c O 2 O N O N L d G CD 0 z 33 Packet Pg. 38 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 Cya_1►lei a1►1111►191 1G1WG161[a] ---- ACTUAL ---- 12/31 /2019 9/30/2020 11 /30/2020 $ 15,552,187 $ 11,432,266 $ 15,948,234 $ 355,874 379,625 548,985 1,782,149 1,782,149 1,782,149 12,187 14,687 17,187 210,221 210,221 210,221 864,491 864,591 864,591 223,581 223,581 223,581 50,000 50,000 28,445 $ 19,050,690 $ 14,957,121 $ 19,623,393 $ ---- ACTUAL ---- F Q3 YTD a — m 396,04E (2,698,260) $ (36,566) Ta 193,11 ' c - 5,001 L, 100 10( �0 o N - (21,55! N L (2,734,726) $ 572,70, .00 E a� 0 *$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. -1- *$7,720,000 of the fund balance in Fund 001 added to the $1,782,149 balance in Fund 012, represent the required 20% operating reserve. General Fund & Subfunds 21 - 18 General Fund 15 $9 33 $9 90 & Subfunds 12 $5.24 General Fund c Operating Reserve = 9 ■ Civic Field 6 $7.72 $7.72 $ .72 3 $2.00 $2.00 Dec 2019 Sept 2020 Nov 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. 39 2.2.a GOVERNMENTAL FUNDS OVERVIEW CHANGE IN FUND FUND BALANCES BALANCES GOVERNMENTAL ---- ACTUAL ---- FUNDS ---- ACTUAL ---- 12/31 /2019 9/30/2020 11 /30/2020 Q3 YTD General Fund & Subfunds $ 19,050,690 $ 14,957,121 $ 19,623,393 $ (2,734,726) $ 572,70: Special Revenue 10,622,237 10,235,228 10,687,629 (661,506) 65,392 a Debt Service - (0) 405,296 - m 405,29E Capital Projects 6,443,150 6,878,746 6,513,227 516,124 �a 70,077 c Total Governmental Funds $ 36,116,078 $ 32,071,095 $ 37,229,545 $ (2,880,107) $ 1,113,46-1 ii 21 c O 2 0 N O N Governmental Fund Balances -By Fund Group Governmental Fund Balances - L Combined E O Z 21 40 _ $37.23 .. 0 $19.62 $19.05 $36.12 O 18 --*--General 35 $ 32.07 m / Fund & 30 v 15 $14.96 Subfunds C cc c --a—Special 25 jy r_ 12 Revenue >+ =c o_ t $10.69 2 20 Debt 9 Service 15 N 6 $6.51 N --X--Capital 10 d Projects E 3 5 O Z $ $0.41 Dec 2019 Sept 2020 Nov 2020 Dec 2019 Sept 2020 Nov 2020 E t cc 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. 40 2.2.a SPECIAL REVENUE FUNDS OVERVIEW FUND BALANCES CHANGE IN FUND BALANCE; GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 12/31/2019 9/30/2020 11/30/2020 Q3 YTD 104 - Drug Enforcement Fund $ 39,839 $ 73,859 $ 73,996 $ (3,552) $ 34,157 1 1 1 - Street Fund 1,298,473 1,067,380 1,223,825 (21,067) (74,64E 112- Combined Street Const/Improve 1,421,769 2,127,421 2,121,351 (70,068) 699,581 117 - Municipal Arts Acquis. Fund 634,011 646,333 681,329 (912) 47,31 f a 118 - Memorial Street Tree 19,785 20,222 20,259 210 474 0 120 - Hotel/Motel Tax Revenue Fund 93,013 101,933 102,438 5,742 9,424 121 -Employee Parking Permit Fund 86,844 98,101 98,557 1,114 11,71� 122 - Youth Scholarship Fund 13,600 13,443 13,770 139 16� 123 -Tourism Promotional Fund/Arts 72,101 85,168 82,211 4,363 10,10� jL 125 -Real Estate Tax 2 2,625,364 2,572,735 2,696,073 65,414 70,70� 2' 126 - Real Estate Excise Tax 1 2,486,325 2,347,350 2,579,332 169,411 93,007 127 - Gifts Catalog Fund 332,255 312,548 299,162 (25,442) (33,09c 20 130 - Cemetery Maintenance/Improvement 260,685 239,431 210,856 (15,694) (49,82� c 136 - Parks Trust Fund 163,071 166,670 166,977 1,728 3,90E o 137 - Cemetery Maintenance Trust Fund 1,053,314 1,086,243 1,090,874 15,362 N 37,56C 138 - Sister City Com m ission 10,129 12,868 10,387 134 25� 140 -Business Improvement Disrict 11,546 28,653 34,557 9,188 23,011 141 -Affordable and Supportive Housing Fd 112 51,036 64,895 18,589 64,78: o 142 - Edmonds Cares Fund - (816,165) (883,220) (816,165) (883,22C Z Total Special Revenue $ 10,622,237 $ 10,235,228 $ 10,687,629 1 $ (661,506) $ 65,392 *$200,000 of the fund balance in Fund 125 has been reserved for Marsh Restoration Funding Special Revenue Funds 12 10 8 - Ln c 6 ■ Special $10.42 $10.04 $10.49 Revenue 4 ■ Fund 125 - Marsh 2 _ Restoration Funding Dec 2019 Sept 2020 Nov 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. 41 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 BALANCE: ---- ACTUAL ---- 12/31 /2019 9/30/2020 $ 23,049,550 $ 22,426,629 12,607,151 10,936,388 46,572,051 45,952,697 843,961 843,970 - 31,765 $ 83,072,713 $ 80,191,449 11 /30/2020 $ 22,890,499 10,911,275 59,684,593 843,972 32,085 $ 94,362,424 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 November 30, 2020 65,000,000 60,000,000 $59,684,593 55,000,000 50,000,000 45,000,000 40,000,000 35,000,000 30,000,000 25,000,000 $22,890,499 20,000,000 15,000,000 10,000,000 $1 1 275 5,000,000 $32,085 843,972 0 $250,000 $126,068 Combined Utility Water Storm Storm - Marsh Sewer/WWTP Bond Reserve Firemen's Restoration Funding 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. (159,051 (1,695,87E 13,112,541 0 11 m 32,08E 11,289,711 c ii 21 t c O 2 0 N O N L E a� O Z 37 Packet Pg. 42 SUMMARY OVERVIEW I 2.2.a I FUND BALANCES CITY-WIDE ---- ACTUAL ---- 12/31 /2019 9/30/2020 11 /30/2020 Governmental Funds $ 36,116,077 $ 32,071,095 $ 37,229,545 $ Enterprise Funds 83,072,713 80,191,449 94,362,424 Internal Services Fund 10,803,067 11,538,939 9,919,670 Agency Funds 146,733 139,708 126,068 Total City-wide Total $130,138,590 $123,941,191 $141,637,707 $ CHANGE IN FUND BALANCES ---- ACTUAL ---- Q3 YTD (2,880,107) $ 1,113,46E a (2,494,132) 11,289,711 279,306 (883,397 .� (15,108) (20,66E (5,110,042) $ 11,499,11E IE 21 c 0 2 0 N O Governmental Fund Balances (Excluding General Fund) as of November 30, 2020 L' Drug Enforcement Fund Street Fund Combined Street ConsUlmprove Fund Municipal Arts Acquis. Fund Memorial Street Fund Hotel/Motel Tax Revenue Fund Employee Parking Permit Fund Youth Scholarship Fund Tourism Promotional Fund/Arts Real Estate Excise Tax 2 Real Estate Excise Tax 1 Gifts Catalog Fund Cemetery Maintenance/Improvement Parks Trust Fund Cemetery Maintenance Trust Fund Sister City Commission Business Improvement District Affordable and Supportive Housing Fund Edmonds Cares Fund $(883,220) Parks Capital Construction Fund $73,996 $11,223,825 � $2,121, 51 � $681,329 $20,259 $102,438 $98,557 $13,770 $82,211 $299,162 $210,856 $166,977 $1�090,874 $10,387 $34,557 $64,895 $2,696,073 21579,332 $6,513,227 $- $1,500,000 $3,000,000 $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. 43 INTERNAL SERVICE FUNDS OVERVIEW 1 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 FUND BALANCES ---- ACTUAL ---- 12/31 /2019 9/30/2020 11 /30/2020 $ 10,016,269 $ 10,654,871 $ 8,878,360 $ 786,798 884,068 1,041,310 $ 10,803,067 $ 11,538,939 $ 9,919,670 1 $ Internal Service Fund Balances 5 10,654,871 786.798 �$884,068 Dec 2019 Sept 2020 $8,878,360 1,041,310 Nov 2020 CHANGE IN FUND BALANCES ---- ACTUAL ---- Q3 YTD 242,460 $ (1,137,90£ 0 36,845 254,512 279,306 $ (883,391 c ii 21 c 0 2 0 N O N L a) I_ 0 z ■ 511- Equipment Rental Fund i ■ 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. 44 2.3 City Council Agenda Item Meeting Date: 01/12/2021 Finance Committee Planning Ideas Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History Agenda item requested by Councilmember Buckshnis Staff Recommendation N/A Narrative: This agenda item was requested by Councilmember Buckshnis Packet Pg. 45 2.4 City Council Agenda Item Meeting Date: 01/12/2021 Finance Policies Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History City departments should continually review and update their policies. Staff Recommendation N/A Narrative: Review of Finance policies: new policies needed and policy updates needed Attachments: Finance Policy Amendment Schedule Packet Pg. 46 2.4.a City of Edmonds Finance Committee Policy Matrix Order of Ordinance Resolution Target Adoption Original Adoption Policy Name Importance No. No. Date Date Notes N d Existing Policies/Ordinances/Codes 2 O #1387 2-May-17 Finished - Resolution approved by Council (L Contracting and Purchasing Policy N/A -on consent 21-Aug-18 Updated - passed on Consent but we did not do a new Resolution 4) Contracting and Purchasing Policy #4171 18-Dec-19 Finished - Repeal of original Purchasing Ordinance 3303 from 2000 V C Utility Tax and Franchise Payments ???? 6-Mar-18 Finished - Ordinance approved by Council to amend ECC 3.20.080 re: allowing quarterly payments for smaller utilities Capital Asset Policy A #1422 2-Jan-19 Finished - Resolution approved by Council (Replaced Resolution 1407) C Small & Attractive Asset Policy #1423 2-Jan-19 Finished - Resolution approved by Council LL Fund Balance Reserve Policy A #1433 2-Jul-19 Finished - Resolution approved by Council Financial Reporting Policy -Repeal A #4110 27-Apr-18 6-Apr-10 Finished - Ordinance 4110 Repealed Ordinance 3789 Petty Cash Policy A #1086 8-May-18 15-Mar-05 Finished - Reviewed and determined no changes needed Lease Policy A ???? 19-Nov-19 Finished -Resolution approved by Council on 11/19/2019. Need to get copy of final and Resolution # N Financial Policy -Update A #1226 6-Apr-10 Need to review and make changes. Per auditors comment, be sure to include a section on accruals. Travel & Meal Expense Policy B 27-Dec-13 Policy is in City Code 2.25.050. Discussed in Committee on 6/12/2018. Need to coordinate update of ECC with HR Departmer 0 UB Penalty Adjustment Policy B 18-Aug-08 Need to adopt the current policy via a resolution `-' Financial Reporting Policy B Need to create the resolution that will replace Ordinance 3789, which was repealed in April 2018 N Leak Adjustment Policy B February 2013 Need to review and adopt via a resolution Employee Expenses, Volunteer d Recognition & Reimbursements Policy B 12-Jun-18 19-Aug-14 Employee expense policy is in ECC 2.25. Need to review the rest and adopt via a resolution V Investment Policy B #1338 21-Jul-15 Need to make some minor updates U) Need a policy related to acquisition of IT items - especially software. Should address ongoing maintenance, approval by IT, IT Policy B None central coordination and management of all hardware and software O E C Draft O Potential Policies to Develop Timeline Q Debt Policy V Budget Policy O d Asset Management Policies: V Building Maintenance Street Maintenace ADA Compliance LL Parks Library d E t V r R:\Finance Committee\Committee Agenda\Finance Policy Amendment Schedule 1/7/2021 Packet Pg. 47 2.5 City Council Agenda Item Meeting Date: 01/12/2021 Waiving Rent Payments for the Chamber of Commerce from January -June 2021 Staff Lead: Adrienne Fraley-Monillas Department: City Council Preparer: Maureen Judge Background/History Due to the ongoing COVD-19 pandemic and the Stay Home, Stay Healthy order issued on March 24, 2020 revenues to the Edmonds Chamber of Commerce have been severely impacted. Businesses were closed and yearly revenue generating events for the Chamber were cancelled including Taste Edmonds, Halloween, and the annual Tree Lighting event. Staff Recommendation N/A Narrative To relieve financial stress on the Chamber, the Council is asked to consider waiving rent on their offices at City Hall from January 1-June 30, 2021; the monthly rent is $713 for a total of $4,278 for the six- month period. Similarly, the Council voted in April to relieve rent payments on the businesses located in the Frances Anderson Center. Council began discussion of the Chamber rent waiver on 1/5/21; it was determined that this item should be brought to the Finance Committee on 1/12/21. Attachments: Resolution 1467 Packet Pg. 48 2.5.a RESOLUTION NO.1467 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, RELEASING THE EDMONDS CHAMBER OF COMMERCE FROM HAVING TO MAKE RENT PAYMENTS TO THE CITY DURING THE FIRST SIX MONTHS OF 2021 WHEREAS, on February 29, 2020, Governor Inslee issued Proclamation 20-05, proclaiming a State of Emergency for all counties throughout the state of Washington as a result of the coronavirus disease (COVID-19) outbreak; and WHEREAS, the City of Edmonds Mayor, Mike Nelson, declared an emergency due to the COVID-19 outbreak on March 5, 2020, and WHEREAS, on March 23, 2020, Governor Inslee issued Proclamation 20-25, entitled "Stay Home —Stay Healthy," which took effect at midnight on March 25, 2020, and WHEREAS, the "Stay Home — Stay Healthy" order has been extended numerous times during 2020, impacting various of the Chamber's fundraising activities, including but not limited to the Taste of Edmonds, which activities are prohibited or significantly curtailed by the order; and WHEREAS, the City Council believes that the Edmonds Chamber of Commerce provides important services and events that benefit city businesses, the people of Edmonds, and the local economy; and WHEREAS, the community events that are put on by the Chamber, including but not limited to the 41h of July, Taste Edmonds, Halloween, and the annual Tree Lighting event, add to the sense of community that Edmonds' residents enjoy and otherwise support, both directly and indirectly, the public health, safety, and welfare; and WHEREAS, the City Council wants to provide assistance to the Chamber now to increase the likelihood that the Chamber will survive the pandemic and be in a position to continue with its community -benefiting activities later; and WHEREAS, the Chamber rents office space from the City; NOW THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, HEREBY RESOLVES AS FOLLOWS: Section 1. The Edmonds City Council hereby authorizes the administration to waive rent obligations for the Edmonds Chamber of Commerce from January 1, 2021 through June 30, 2021. Packet Pg. 49 2.5.a RESOLVED this 12th day of January 2020. ATTEST: CITY CLERK, SCOTT PASSEY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: RESOLUTION NO. CITY OF EDMONDS MAYOR, MIKE NELSON January 12, 2021 January 12, 2021 1467 2 Packet Pg. 50