2020-12-08 City Council - Full S Agenda-27451
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
DECEMBER 8, 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/95798484261
OR JOIN BY 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. October 2020 Monthly Financial Report (10 min)
2. Fourth Quarter Budget Amendment (15 min)
ADJOURN
Edmonds City Council Agenda
December 8, 2020
Page 1
2.1
City Council Agenda Item
Meeting Date: 12/8/2020
October 2020 Monthly Financial Report
Staff Lead: Dave Turley
Department: Administrative Services
Preparer: Sarah Mager
Background/History
N/A
Staff Recommendation
Please review and move to full council on consent
Narrative
October 2020 Monthly Financial Report
Attachments:
October 2020 Monthly Financial Report
Packet Pg. 2
I 2.1.a I
OF
EDP
� d
1)7 C. 1 $9v
CITY OF EDMONDS
MONTHLY BUDGETARY FINANCIAL REPORT
OCTOBER 2020
Packet Pg. 3 1
I 2.1.a I
Page 1 of 1
C FIY OF EDMO NDS
REVENUES BY FUND - SUMMARY
Fund
2020 Amended
10/31/2019
10/31/2020
Amount
No. Title
Budget
Revenues
Revenues
Remaining %Receive,
001 GENERAL FUND
$ 43,803,858
$ 36,079,131
$ 30,980,306
$ 12,823,552 71
009 LEOFF-MEDICAL INS. RESERVE
437,980
212,500
425,000
12,980 97
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 5,000 230 96
017
MARSH RESTORATION & PRESERVATION FUND
-
280,312
100
(100)
0
p
s?.
104
DRUG ENFORCEMENT FUND
165,390
38,838
64,445
100,945
39
G)
Ill
STREET FUND
1,912,768
1,442,865
1,665,560
247,208
87
112
COMBINED STREET CONST/IMPROVE
2,747,881
1,684,500
1,751,291
996,590
64
.O
C
eo
117
MUNICIPAL ARTSACQUIS. FUND
263,576
98,275
76,399
187,177
29
C
li
118
MEMORIAL STREET TREE
750
617
462
288
62
120
HOTEL/MOTEL TAX REVENUE FUND
98,630
86,076
54,330
44,300
55
C
121
EMPLOYEE PARKING PERMIT FUND
27,270
15,012
12,288
14,982
45
0
122
YOUTH SCHOLARSHIP FUND
1,790
450
341
1,449
19
N
123
TOURISM PROMOTIONAL FUND/ARTS
34,450
28,949
18,709
15,741
54
N
125
REAL ESTATE EXCISE TAX 2
1,436,090
1,290,899
1,345,695
90,395
94
L
a)
126
REAL ESTATE EXCISE TAX 1
1,453,520
1,304,064
1,339,547
113,973
92
c�
127
GIFTS CATALOG FUND
145,050
108,850
48,393
96,657
33
O
130
CEMETERY MAINTENANCE/IMPROVEMT
184,610
201,674
108,920
75,690
59
'C
O
136
PARKS TRUST FUND
6,390
5,135
3,809
2,581
60
Z dt
137
CEMETERY MAINTENANCE TRUST FD
54,210
51,905
36,168
18,042
67
<0
138
SISTER CITY COMMISSION
10,380
6,288
264
10,116
3
'V
C
140
BUSINESS IMPROVEMENT DISTRICT
79,209
74,937
70,106
9,103
89
C
141
AFFORDABLE AND SUPPORTIVE HOUSINGFUND
-
-
57,837
(57,837)
0
LL
21
142
EDMONDS CARES FUND
1,265,100
-
852,137
412,963
67
z
211
L.I.D. FUND CONTROL
12,400
30,893
-
12,400
0
r
O
231
2012 LT GO DEBT SERVICE FUND
738,400
53,388
47,291
691,109
6
C
332
PARKS CAPITAL CONSTRUCTION FUND t
9,638,306
714,160
1,403,521
8,234,785
15
p
N
411
COMBINED UTILITY OPERATION
-
119,777
31,935
(31,935)
0
i
d
421
WATER UTILITY FUND
11,116,270
8,333,498
8,363,142
2,753,128
75
p
422
STORM UTILITY FUND 2
6,720,466
4,563,849
4,925,043
1,795,423
73
r�
00
423
SEWER/WWTP UTILITY FUND 3
25,261,935
11,725,832
15,005,131
10,256,804
59
424
BOND RESERVE FUND
1,988,100
625,604
616,552
1,371,548
31
O
E
511
EQUIPMENT RENTAL FUND
1,746,160
1,566,132
1,551,455
194,705
89
V
512
TECHNOLOGY RENTAL FUND
1,202,963
924,246
1,004,927
198,036
84
Q
617
FIREMEN'S PENSION FUND
72,620
54,205
54,924
17,696
76
$ 112,687,892
$ 71,725,360
$ 71,921,028
$ 40,766,864
64
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. 4 1
I 2.1.a I
Page 1 of 1
C ITY O F EDMO NDS
EXPENDITURES BY FUND - SUMMARY
Fund 2020 Amended
10/31/2019
10/31/2020
Amount
No. Title Budget
Expenditures
Expenditures
Remaining %Spent
001 GENERAL FUND $ 49,044,056
$ 34,483,508
$ 35,443,149
$ 13,600,907 720/
009 LEOFF-MEDICAL INS. RESERVE 467,140
340,924
226,722
240,418 49°
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° G
019
EDMONDSOPIOID RESPONSE FUND
21,555
100,000
21,555
-
1000 y
104
DRUG ENFORCEMENT FUND
45,800
-
30,332
15,468
660
O
111
STREET FUND
2,199,717
1,617,190
1,700,334
499,383
770/ 0
112
COMBINED STREET CONST/IMPROVE
2,717,463
1,325,639
919,137
1,798,326
34°
117
MUNICIPAL ARTS ACQUIS. FUND
243,880
51,601
28,236
215,644
12° LL
120
HOTEL/MOTEL TAX REVENUE FUND
128,250
61,654
47,329
80,921
37°
121
EMPLOYEE PARKING PERMIT FUND
26,880
591
632
26,248
20, O
122
YOUTH SCHOLARSHIP FUND
3,000
2,820
450
2,550
150, C
123
TOURISM PROMOTIONAL FUND/ARTS
33,900
12,574
5,129
28,771
N
1501 N
125
REAL ESTATE EXCISE TAX 2
3,610,520
1,181,723
1,317,203
2,293,317
360/ N
126
REAL ESTATE EXCISE TAX 1
3,401,093
1,209,379
1,341,070
2,060,023
390/ O
127
GIFTSCATALOGFUND
113,782
54,092
85,183
28,599
750, O
130
CEMETERY MAINTENANCE/IMPROVEMT
195,787
160,396
148,952
46,835
760/ r-
136
PARKS TRUST FUND
-
4,935
-
-
00 O
O.
138
SISTER CITY COMMISSION
11,900
6,775
11
11,889
O
00,
140
BUSINESS IMPROVEMENT DISTRICT
80,510
75,218
49,813
30,697
620, •v
142
EDMONDS CARES FUND
1,265,100
-
964,793
300,307
760
C
211
L.I.D. FUND CONTROL
12,400
-
-
12,400
0° jL
231
2012 LT GO DEBT SERVICE FUND
738,400
53,388
47,291
691,109
60, s
332
PARKS CAPITAL CONSTRUCTION FUND
13,013,343
137,607
1,136,879
11,876,464
9° C
421
WATER UTILITYFUND
12,809,352
7,799,919
8,855,472
3,953,880
69° E
0
422
STORM UTILITY FUND
10,831,951
4,034,850
6,660,621
4,171,330
610, G
423
SEWER/WWTP UTILITY FUND
32,767,560
9,338,341
15,522,880
17,244,680
470/
d
424
BOND RESERVE FUND
1,988,130
625,592
616,542
1,371,588
31°
511
EQUIPMENT RENTAL FUND
3,170,398
1,590,603
2,710,622
459,776
0
85°
00
512
TECHNOLOGY RENTAL FUND
1,454,784
709,124
859,114
595,670
59°;
C
617
FIREMEN'S PENSION FUND
78,700
124,976
70,538
8,162
900/
0)
$ 140,581,251
$ 69,878,160
$ 78,809,990
S 61,771,261
56° v
2
Packet Pg. 5
2.1.a
Page 1 of 3
CITY OF EDMO NDS
REVENUES - GENERAL FUND
2020 Amended 10/31/2019 10/31/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,943,393
$ 6,022,077
$ 4,715,540
560/(
4,112,031
2,297,826
2,351,276
1,760,755
570/(
500
244
26
474
501(
8,450,000
6,992,063
6,719,684
1,730,316
800/(
7,600
8,448
6,184
1,416
810/(
760,500
666,839
662,655
97,845
870/(
1,684,800
1,424,234
1,430,598
254,202
850/(
579,600
474,308
535,796
43,804
920/( ..
348,800
286,525
296,691
52,109
850/( G
1,148,400
984,798
911,237
237,163
790/( 0-
896,600
704,116
639,822
256,778
710/(
471,900
381,511
417,899
54,001
89%
822,200
669,936
668,933
153,267
81%
823,900
679,544
579,582
244,318
700/(
55,200
55,915
56,617
(1,417)
1030/( C
40
383
449
(409)
11230/, M
280,900
220,336
228,029
52,871
810/( 2%
31,180,588
21,790,419
21,527,554
9,653,034
690%
C
250
185
315
(65)
126% 2
700
525
80
620
11% p
6,000
4,675
-
6,000
00/, c
50,000
52,821
10,894
39,106
220/( N
682,200
676,201
678,877
3,323
100% d
41,000
34,545
33,381
7,619
810/(
100,600
72,818
56,323
44,277
560/( j
358,200
387,851
255,690
102,510
710/( 0
116,300
106,391
187,404
(71,104)
1610/(
63,700
59,649
61,595
2,105
970/c C
64,800
48,847
-
64,800
00/( Q.
13,500
15,460
-
13,500
00/c
675,600
548,491
558,009
117,591
830/(
24,380
9,918
9,691
14,689
400/( v
45,000
35,430
93,536
(48,536)
2080/( C
18,500
18,546
14,290
4,210
770/(
2,260,730
2,072,354
1,960,085
300,645
870% IL
6,000
3,470
2,052
3,949
340/(
-
14,616
-
-
0°/
-
2,285
-
-
00/(
4,000
1,852
-
4,000
0°/
-
4,138
559
(559)
00/c
7,100
3,501
1,623
5,477
23°/
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
-
-
00/c
13,070
12,536
13,211
(141)
1010/(
-
5,000
-
-
00/c
-
7,165
-
-
0°/
16,740
16,722
12,114
4,626
720/(
45,600
45,102
47,280
(1,680)
1040/(
500
-
-
500
00/c
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)
11501(
338,200
255,686
253,877
84,323
750/(
-
2,500
-
-
00/(
-
2,000
-
-
00/(
-
211
1,194
(1,194)
00/(
1,000
814
4,001
(3,001)
4000/(
550
-
-
550
00/c
947,060 869,767 877,159 69,901 930%
4 2020 Local Retail Sales/Use Taxrevenues are $(272,379) lower than 2019 revenuesL Please also see pages pages 18 & 19.
3
Packet Pg. 6
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
2.1.a
Page 2 of 3
C ITY O F EDMO NDS
REVENUES - GENERAL FUND
2020 Amended 10/31/2019 10/31/2020 Amount
Budget Revenues Revenues Remaining %Received
$ 3,000
$ 3,452
$ 4,336
$ (1,336)
1450/(
600
573
120
480
200/(
11,000
12,231
5,518
5,482
500
300
79
7
293
20/c
300
58
65
235
220/(
-
-
235
(235)
00/c
11,000
9,530
2,358
8,642
210/(
1,000
1,122
589
411
590/c
100
321
66
34
660/(
100
50
9
91
90/( O
25,100
-
-
25,100
00/( y
600
-
-
600
0%
1,000
928
450
550
450/( io
500
-
-
500
00/( .v
125,000
184,534
223,782
(98,782)
1790/( e�0
1,400
-
-
1,400
00/(
85,000
94,875
71,159
13,841
840/( LL
21,000
20,260
5,795
15,205
280/(
30,000
38,074
-
30,000
00/( 41
126,800
62,642
36,753
90,047
290/( O
195,000
211,867
198,859
(3,859)
1020/( 2
-
2
58
(58)
00/( N
117
-
-
00/c C
N
52,500
54,941
59,291
(6,791)
113%
1,050
1,231
1,183
(133)
113%
45,000
37,660
31,603
13,397
700/( O
3,000
2,173
1,997
1,004
670/( v
10,000
15,160
18,602
(8,602)
1860/(
3,500
4,704
3,147
353
900/(
1,007,500
761,350
784,324
223,176
780/( 0
2,500
1,066
1,880
620
CL
750/( O
50
100
-
50
00/,
72,600
92,650
68,214
4,386
940/(
.v
375,900
568,248
236,734
139,166
630/,
4,000
9,190
15,225
(11,225)
3810/(
500
2,236
-
500
00/(
5,000
5,190
2,960
2,040
590/( LL
14,000
14,225
14,382
(382)
1030/(
4,707
-
-
00/(
15,500
9,839
3,083
12,417
200/( O
869,162
742,885
91,025
778,137
100/( c
1,300
512
-
1,300
00/, cV
5,000
8,435
7,998
(2,998)
1600/( N
800
585
-
800
00/(
3,290,838
2,222,254
2,487,084
803,754
760/(
6,418,500
5,200,055
4,378,891
2,039,609
687/, 42
5 2020 Parks & Recreation Program Revenues are $(651,860) lower than 2019 revenues.
4
Packet Pg. 7 1
I 2.1.a I
Page 3 of 3
C ITY O F EDMO NDS
REVENUES - GENERAL FUND
2020 Amended 10/31/2019 10/31/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,066 $
1,002 $
2,998
250/(
241,000
189,561
89,134
151,866
370/(
19,000
15,946
10,608
8,392
560/(
20,000
14,543
7,948
12,052
400/c
1,000
1,371
760
240
760/(
2,000
1,191
1,088
912
540/(
147,000
124,598
59,603
87,397
410/(
2,500
2,644
794
1,706
320/(
7,000
7,974
6,958
42
990/(
700
394
190
510
270/(
200
55
35
165
170/(
1,500
1,716
1,901
(401)
1270/(
140
-
-
140
00/(
30,000
24,202
17,782
12,218
590/(
3,600
2,232
1,849
1,751
5101(
1,000
553
455
545
460/(
100
(2,792)
37
63
370/(
13,100
17,755
6,293
6,807
480/(
600
302
955
(355)
1590/(
1,600
747
615
985
380/(
500
274
82
418
160/(
16,000
9,930
6,202
9,798
390/(
14,000
11,704
6,946
7,054
500/(
6,000
4,480
2,921
3,079
490/(
10,100
5,150
-
10,100
00/(
300
1,208
1,441
(1,141)
4800/(
542,940
438,803
225,599
317,341
427%
399,400
359,644
264,232
135,168
660/c
53,440
22,002
12,300
41,140
230/(
50,950
7,128
5,746
45,204
110/(
-
150
-
-
00/(
153,000
133,238
24,524
128,476
160/(
2,100
1,610
380
1,720
180/(
205,000
168,134
138,784
66,216
680/(
22,500
3,544
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
538
(238)
1790/(
3,000
2,314
3,586
(586)
1200/(
2,000
-
-
2,000
00/(
2,000
3
1,344
656
670/(
200
469
248
(48)
1240/(
-
(71)
16
(16)
00/(
5,000
195,060
13,467
(8,467)
2690/(
100
58
34
66
340/(
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
927,233
475,217
443,023
5207,
3,835,827
- -
00/(
-
931,523
- -
00/(
1,500,000
-
1,500,000 -
1000/(
35,800
13,150
35,800 -
1000/(
1,535,800
4,780,500
1,535,800 -
1000%
$ 43,803,858
$ 36,079,131
$ 30,980,306 $12,823,552
710%
5
Packet Pg. 8
I 2.1.a I
Page 1 of 6
CITY OF EDMONDS
EXPENDITURES BY FUND - DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
GENERAL FUND EXPENDITURES (001)
1 SALARIES AND WAGES
$ 17,066,688
$ 13,138,847
$ 13,781,011
$ 3,285,677
81'
2 OVERTIME
491,580
632,280
489,261
2,319
100'
3 HOLIDAY BUY BACK
262,020
8,449
5,394
256,626
2'
4 BENEFITS
6,599,678
5,150,444
5,288,570
1,311,108
80'
5 UNIFORMS
90,975
94,212
73,733
17,242
81'
6 SUPPLIES
428,811
386,981
359,617
69,194
84'
7 SMALL EQUIPMENT
161,262
129,711
135,627
25,635
84'
8 PROFESSIONAL SERVICES
15,407,641
10,823,215
11,007,014
4,400,627
71'
9 COMMUNICATIONS
169,795
126,222
127,047
42,748
75'
10 TRAVEL
78,580
61,037
9,633
68,947
12'
11 EXCISE TAXES
6,500
6,838
12,850
(6,350)
198'
12 RENTAL/LEASE
1,825,110
1,529,827
1,502,919
322,191
82'
13 INSURANCE
394,124
436,448
393,746
378
100'
14 UTILITIES
531,525
437,676
402,108
129,417
76'
15 REPAIRS&MAINTENANCE
297,010
457,761
577,041
(280,031)
194'
16 MISCELLANEOUS
526,991
345,662
289,997
236,994
55'
17 INTERGOVERNMENTAL PAYMENTS
75,000
75,000
75,000
-
100'
18 INTERFUND SUBSIDIES
3,266,993
625,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
-
-
168,850
0'
22 OTHER INTEREST & DEBT SERVICE COSTS
500
-
212
288
42'
23 INTEREST ON LONG-TERM EXTERNAL DEBT
137,250
7,023
69,285
67,965
50'
49,044,056
S
34,483,508
35,443,149
13,600,907
72'
LEO FF-MEDICAL INS. RESERVE (009)
24 BENEFITS
$
206,650
$
135,964
$
132,391
$
74,259
64'
25 PENSION AND DISABILITY PAYMENTS
252,990
204,325
88,539
164,451
35'
26 PROFESSIONAL SERVICES
7,000
180
5,793
1,207
83'
27 MISCELLANEOUS
500
455
-
500
0'
467,140
S
340,924
226,722
240,418
49'
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
-
100,000
-
-
0'
21,555
100,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'
u
6
Packet Pg. 9
I 2.1.a I
Page 2 of 6
CITY OF EDMO NDS
EXPENDITURES BY FUND - DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
STREETFUND (111)
1 SALARIES AND WAGES
$ 723,081
$ 484,312
$ 542,076
$ 181,005
75'
2 OVERTIME
18,400
41,280
37,182
(18,782)
202'
3 BENEFITS
309,539
230,280
268,438
41,101
87'
4 UNIFORMS
6,000
3,278
3,781
2,219
63'
5 SUPPLIES
263,000
223,529
142,903
120,097
54'
6 SMALL EQUIPMENT
20,000
2,279
684
19,316
3'
7 PROFESSIONAL SERVICES
27,930
7,627
2,423
25,507
9'
8 COMMUNICATIONS
4,500
5,471
6,623
(2,123)
147'
9 TRAVEL
1,000
-
-
1,000
0'
10 RENTAL/LEASE
230,450
224,344
192,873
37,577
84'
11 INSURANCE
145,219
156,514
156,937
(11,718)
108'
12 UTILITIES
280,918
215,368
214,497
66,421
76'
13 REPAIRS&MAINTENANCE
52,000
20,601
52,348
(348)
101'
14 MISCELLANEOUS
13,000
2,019
3,655
9,345
28'
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,617,190
$ 1,700,334 $
499,383
77'
$ - $
-
$ 10,567 $
(10,567)
0'
-
-
6,613
(6,613)
0'
586,130
269,551
162,084
424,046
28'
163,028
396,885
320,161
(157,133)
196'
-
8
(8)
0'
40,140
40,318
40,121
19
100'
-
7,300
-
-
0'
1,853,975
537,070
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,325,639
$ 919,137 $
1,798,326
34'
$ 4,700 $
2,780 $
114 $
4,586
2'
1,700
-
116
1,584
7'
228,500
45,347
26,540
201,960
12'
80
6
-
80
0'
2,000
-
-
2,000
0'
300
-
-
300
0'
6,600
3,468
1,466
5,134
22'
$ 243,880 $
51,601 $
28,236 $
215,644
12'
$ 92,487 $
59,071 $
42,737 $
49,750
46'
6,763
583
592
6,171
9'
4,000
2,000
4,000
-
100'
25,000
-
-
25,000
0'
$ 128,250 $
61,654 $
47,329 $
80,921
37'
$ 1,790 $ 591 $ 632 $ 1,158 35'
25,090 - - 25,090 0'
$ 26,880 $ 591 $ 632 $ 26,248 2'
$ 3,000 $ 2,820 $ 450 $ 2,550 15'
$ 3,000 $ 2,820 $ 450 $ 2,550 15'
$ 33,900 $ 10,615 $ 5,129 $ 28,771 15'
- 1,959 - - 0'
$ 33,900 $ 12,574 $ 5,129 $ 28,771 15'
O
a
d
C
eo
C
IL
21
t
a
O
2
0
N
0
N
L
d
O
tt
7
Packet Pg. 10
I 2.1.a I
Page 3 of 6
CITY OF EDMO NDS
EXPENDITURES BY FUND - DETAIL
2020 Amended
10/31/2019
10/31/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
145,777
302,921
176,910
63'
3 RENTAL/LEASE
-
381
-
-
0'
4 REPAIRS&MAINTENANCE
176,176
373,501
354,028
(177,852)
201'
5 INTERFUND SUBSIDIES
620
-
-
620
0'
6 CONSTRUCTION PROJECTS
2,932,893
627,968
645,880
2,287,013
22'
$ 3,610,520
$ 1,181,723
$ 1,317,203
$ 2,293,317
36'
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 $
124,833
$ 604,778
278,489
68'
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
691,997
463,550
1,488,387
24'
24,220
-
-
24,220
0'
2,970
1,680
1,484
1,486
50'
-
-
575
(575)
0'
$ 3,401,093 $
1,209,379
$ 1,341,070
$ 2,060,023
39'
$ 48,882 $
28,863 $
39,033 $
9,849
80'
-
10,221
-
-
0'
6,500
-
3,000
3,500
46'
22,000
1,858
7,183
14,818
33'
600
-
168
432
28'
35,800
13,150
35,800
-
100'
$ 113,782 $
54,092 $
85,183 $
28,599
75'
$ 97,476 $
76,070 $
78,592 $
18,884
81'
3,500
3,101
558
2,942
16'
42,029
34,788
33,646
8,383
80'
1,000
225
-
1,000
0'
7,000
3,584
2,717
4,283
39'
20,000
15,673
15,165
4,835
76'
-
1,246
1,184
(1,184)
0'
4,200
866
150
4,050
4'
1,700
1,517
1,401
299
82'
500
-
-
500
0'
8,230
5,217
6,858
1,372
83'
5,652
3,643
3,559
2,093
634
500
-
-
500
0'
4,000
14,466
5,124
(1,124)
1284
$ 195,787 $
160,396 $
148,952 $
46,835
764
$ - $ 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,555 $
2,295 81'
66,035
60,388
37,835
28,200 57'
2,625
2,551
2,423
202 92'
$ 80,510
75,218
49,813
30,697 62'
$ 1,265,100 $ $ 964,793 $ 300,307 76'
1,265,100 964,793 300,307 76'
$ 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'
u
8
Packet Pg. 11
I 2.1.a I
Page 4 of 6
CITY OF EDMO NDS
EXPENDITURES BY FUND - DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
PARKS CONSTRUCTION FUND (332)
1 PROFESSIONAL SERVICES
$ 323,349
$ 28,439
$ 363,171
$ (39,822)
112'
2 INTERFUND SUBSIDIES
112,920
-
20,316
92,604
18'
3 CONSTRUCTION PROJECTS
12,577,074
109,168
753,392
11,823,682
6'
$ 13,013,343
$ 137,607
$ 1,136,879
$ 11,876,464
9'
WATER FUND (421)
4 SALARIES AND WAGES
5 OVERTIME
6 BENEFIT S
7 UNIFORMS
8 SUPPLIES
9 WATER PURCHASED FOR RESALE
10 SUPPLIES PURCHASED FOR INVENTORY/RESALE
11 SMALL EQUIPMENT
12 PROFESSIONAL SERVICES
13 COMMUNICATIONS
14 TRAVEL
15 EXCISE TAXES
16 RENTAL/LEASE
17 INSURANCE
18 UTILITIES
19 REPAIRS& MAINTENANCE
20 MISCELLANEOUS
21 INTERFUND SUBSIDIES
22 CONSTRUCTION PROJECTS
23 GENERAL OBLIGATION BONDS
24 REVENUE BONDS
25 INTERGOVERNMENTAL LOANS
26 INTEREST
27 OTHER INTEREST & DEBT SERVICE COSTS
STORMFUND (422)
28 SALARIES AND WAGES
29 OVERTIME
30 BENEFITS
31 UNIFORMS
32 SUPPLIES
33 SMALL EQUIPMENT
34 PROFESSIONAL SERVICES
35 COMMUNICATIONS
36 TRAVEL
37 EXCISE TAXES
38 RENTAL/LEASE
39 INSURANCE
40 UTILITES
41 REPAIR & MAINTENANCE
42 MISCELLANEOUS
43 INTERFUND SUBSIDIES
44 CONSTRUCTION PROJECTS
45 GENERAL OBLIGATION BONDS
46 REVENUE BONDS
47 INTERGOVERNMENTAL LOANS
48 INTEREST
49 OTHER INTEREST & DEBT SERVICE COSTS
$ 845,871 $
641,549
$ 688,932 $
156,939
81'
24,000
20,862
15,595
8,405
65'
363,882
288,861
263,013
100,869
72'
4,000
3,326
3,374
626
84'
150,000
53,890
102,299
47,701
68'
2,170,000
1,612,558
1,651,885
518,115
76'
170,000
126,684
131,727
38,273
77'
11,000
4,856
5,197
5,803
47'
1,753,804
673,823
1,085,927
667,877
62'
30,000
23,624
24,001
5,999
80'
200
-
-
200
0'
1,649,700
1,382,337
1,297,916
351,784
79'
133,158
127,133
108,420
24,738
81'
52,865
55,096
52,541
324
99'
35,775
22,202
22,727
13,048
64'
75,830
223,517
19,881
55,949
26'
131,400
97,922
111,326
20,074
85'
650,870
206,313
204,067
446,803
3 P
3,946,207
2,096,353
2,934,520
1,011,687
74'
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'
-
-
378
(378)
0'
$ 12,809,352 $
7,799,919
$ 8,855,472 $
3,953,880
69'
$ 728,080 $
556,684
$ 524,991
$ 203,089
72'
6,000
31,984
12,016
(6,016)
200'
334,154
280,636
241,396
92,758
72'
6,500
5,215
6,437
63
99'
46,000
22,693
19,055
26,945
41'
4,000
3,653
2,026
1,974
51'
3,047,970
867,736
1,567,146
1,480,824
5P
3,200
4,105
5,159
(1,959)
161'
4,300
-
-
4,300
0'
470,100
443,909
485,391
(15,291)
103'
270,830
203,066
225,328
45,502
83'
118,263
127,548
116,576
1,687
99'
11,025
9,099
9,468
1,557
86'
116,183
12,426
15,103
101,080
13'
158,100
129,527
148,250
9,850
94'
282,550
81,819
78,897
203,653
28'
4,758,296
1,159,718
3,088,873
1,669,423
65'
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)
0'
$ 10,831,951 $
4,034,850
$ 6,660,621
$ 4,171,330
61'
u
9
Packet Pg. 12
I 2.1.a I
Page 5 of 6
C ITY OF EDMO NDS
EXPENDITURES BY FUND - DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
SEWER FUND (423)
1 SALARIES AND WAGES
$ 1,953,719
$ 1,477,963
$ 1,564,447
$ 389,272
80'
2 OVERTIME
95,000
78,736
85,125
9,875
90'
3 BENEFITS
854,294
647,874
674,421
179,873
79'
4 UNIFORMS
9,500
7,039
7,482
2,018
79'
5 SUPPLIES
421,000
255,893
289,072
131,928
69'
6 FUEL CONSUMED
60,000
36,924
16,184
43,816
27'
7 SUPPLIES PURCHASED FOR INV OR RESALE
4,000
-
-
4,000
0'
8 SMALL EQUIPMENT
35,000
19,134
36,680
(1,680)
105'
9 PROFESSIONAL SERVICES
2,286,406
925,225
3,023,707
(737,301)
132'
10 COMMUNICATIONS
43,000
34,645
34,517
8,483
80'
11 TRAVEL
5,000
4,689
-
5,000
0'
12 EXCISE TAXES
978,000
888,302
799,573
178,427
82'
13 RENTAL/LEASE
311,966
283,998
269,140
42,826
86'
14 INSURANCE
182,121
186,110
175,867
6,254
97'
15 UTILITIES
1,540,685
785,711
730,964
809,721
47'
16 REPAIR & MAINTENANCE
745,630
367,202
172,176
573,454
23'
17 MISCELLANEOUS
127,650
72,488
72,899
54,751
57'
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 CONST RUCT ION PROJECTS
15,438,495
2,163,617
4,687,579
10,750,916
30'
21 GENERAL OBLIGATION BONDS
154,660
-
-
154,660
0'
22 REVENUE BONDS
82,840
-
-
82,840
0'
23 INTERGOVERNMENTAL LOANS
173,210
172,528
173,200
10
100'
24 INTEREST
68,270
40,516
36,505
31,765
53'
25 OTHER INT EREST & DEBT SERVICE COSTS
-
5,015
5,085
(5,085)
0'
$ 32,767,560
$ 9,338,341
$ 15,522,880
$ 17,244,680
47'
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 31'
O
a
d
C
eo
C
li
21
t
C
O
2
0
N
0
N
L
GN
O
r
0
u
10
Packet Pg. 13
I 2.1.a I
Page 6 of 6
CITY 0FIDMONDS
EXPENDITURES BY FUND - DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
% Spent
EQ UIPMENT RENTAL FUND (511)
1 SALARIES AND WAGES
$ 266,952
$ 216,517
$ 224,189
$ 42,763
84'
2 OVERTIME
2,000
8,081
824
1,176
41'
3 BENEFITS
112,598
93,096
93,275
19,323
83'
4 UNIFORMS
1,000
1,254
1,092
(92)
109'
5 SUPPLIES
130,000
85,171
61,489
68,511
47'
6 FUEL CONSUMED
1,000
-
-
1,000
0'
7 SUPPLIES PURCHASED FOR INVENTORY/RESALE
243,000
157,568
101,561
141,439
42'
8 SMALL EQUIPMENT
58,000
2,002
1,515
56,485
3'
9 PROFESSIONAL SERVICES
46,750
3,861
4,248
42,502
9'
10 COMMUNICATIONS
3,000
1,843
1,902
1,098
63'
11 TRAVEL
1,000
255
-
1,000
0'
12 RENTAL/LEASE
12,750
11,417
10,273
2,477
81'
13 INSURANCE
27,848
30,167
40,270
(12,422)
145'
14 UTILITIES
14,500
11,725
12,012
2,488
83'
15 REPAIRS & MAINTENANCE
60,000
25,094
35,162
24,838
59'
16 MISCELLANEOUS
12,000
9,670
8,776
3,224
73'
17 INTERFUND SUBSIDIES
1,500,000
-
1,500,000
-
100'
18 MACHINERY/EQUIPMENT
678,000
932,883
614,032
63,968
91'
$ 3,170,398
$ 1,590,603
$ 2,710,622
$ 459,776
85'
TECHNOLOGY RENTAL FUND (512)
19 SALARIES AND WAGES
$
369,264
$
249,332
$
240,316
$
128,948
65'
20 OVERTIME
2,000
125
-
2,000
0'
21 BENEFITS
124,590
84,410
80,751
43,839
65'
22 SUPPLIES
5,000
3,585
8,726
(3,726)
175'
23 SMALL EQUIPMENT
137,700
36,892
101,247
36,453
74'
24 PROFESSIONAL SERVICES
309,810
22,118
69,477
240,333
22'
25 COMMUNICATIONS
58,770
45,886
52,766
6,004
90'
26 TRAVEL
1,500
359
-
1,500
0'
27 RENTAL/LEASE
7,490
6,600
6,523
967
87'
28 REPAIRS & MAINTENANCE
367,660
198,928
287,807
79,853
78'
29 MISCELLANEOUS
5,000
3,319
11,501
(6,501)
230'
30 MACHINERY/EQUIPMENT
66,000
57,571
-
66,000
0'
$
1,454,784
$
709,124
$
859,114
$
595,670
59'
FIREMEN'S PENSION FUND (617)
31 BENEFITS
$
23,000
$
16,265
$
18,045
$
4,955
78'
32 PENSION AND DISABILITY PAYMENTS
54,500
108,711
51,486
3,014
94'
33 PROFESSIONAL SERVICES
1,200
-
1,007
193
84'
$
78,700
$
124,976
$
70,538
$
8,162
90'
TOTAL EXPENDITURE ALL FUNDS
$
140,581,251
$
69,878,160
$ 78,809,990
$
61,771,261
56'
u
11
Packet Pg. 14
2.1.a
Page 1 of 1
C ITY O F EDMO NDS
EXPENDPTURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY
2020 Amended 10/31/2019 10/31/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 $
341,182 $
266,797 $
152,115
64%
306,685
245,087
276,971
29,714
90%
740,691
451,921
535,390
205,301
72%
1,138,771
815,237
872,107
266,664
77%
726,962
583,474
611,198
115,764
84%
G
Q.
1,289,583
1,062,062
1,133,433
156,150
88%
�
912,540
728,368
718,169
194,371
79%
15,322,110
10,029,350
10,148,912
5,173,199
66%
11,951,730
9,559,426
9,682,005
2,269,725
81%
C
LL
761,493
474,870
457,484
304,009
60%
t
3,582,847
2,274,866
2,302,031
1,280,816
64%
r�
C
Q
4,594,969
3,458,166
3,011,118
1,583,851
66%
0
3,538,610
2,593,751
2,628,170
910,440
74%
N
N
3,758,153
1,865,748
2,799,364
958,789
74%
L
a)
$ 49,044,056 $
34,483,508 $
35,443,149 $
13,600,907
72%
V
O
C ITY O F EDMO NDS
EXPENDITURES - UTILITY- BY FUND IN SUMMARY
Title
2020 Amended
Budget
10/31/2019
Expenditures
10/31/2020
Expenditures
Amount
Remaining
%Spent
WATER UTILITY FUND
$ 12,809,352
$ 7,799,919
$ 8,855,472
$ 3,953,880
69%
STORM UTILITY FUND
10,831,951
4,034,850
6,660,621
4,171,330
61%
SEWER/WWTP UTILITY FUND
32,767,560
9,338,341
15,522,880
17,244,680
47%
BOND RESERVE FUND
1,988,130
625,592
616,542
1,371,588
31%
$ 58,396,993
$ 21,798,702
$ 31,655,514
$ 26,741,479
54%
12
Packet Pg. 15
Page 1 of 4
C ITY OF EDMO NDS
EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL
Title
2020 Amended
Budget
10/31/2019
Expenditures
10/31/2020
Expenditures
Amount
Remaining
%Spent
CITY COUNCIL
SALARIES
$
191,224
$
149,989
$
158,990
$
32,234
83%
OVERTIME
1,000
-
-
1,000
0%
BENEFITS
95,736
81,376
82,327
13,409
86%
SUPPLIES
2,500
1,901
1,544
956
62%
SMALL EQUIPMENT
1,000
342
534
466
53%
PROFESSIONAL SERVICES
62,160
79,552
4,263
57,897
7%
COMMUNICATIONS
5,000
4,894
7,442
(2,442)
149%
TRAVEL
17,500
2,625
587
16,913
3%
RENTAL/LEASE
12,292
10,041
10,285
2,007
84%
REPAIRS✓MAINTENANCE
500
121
645
(145)
129%
MISCELLANEOUS
30,000
10,341
180
29,820
1%
$
418,912
$
341,182
$
266,797
$
152,115
64%
OFFICEOFMAYOR
SALARIES
$
222,432
$
182,001
$
186,356
$
36,076
84%
BENEFITS
54,043
44,433
70,261
(16,218)
130%
SUPPLIES
1,500
593
800
700
53%
SMALL EQUIPMENT
-
-
4,199
(4,199)
0%
PROFESSIONAL SERVICES
3,000
2,211
594
2,406
20%
COMMUNICATION
1,400
862
1,156
244
83%
TRAVEL
3,000
2,603
166
2,834
6%
RENTAL/LEASE
16,860
10,425
13,228
3,632
78%
MISCELLANEOUS
4,450
1,960
213
4,237
5%
$
306,685
$
245,087
$
276,971
$
29,714
90%
HUMAN RESOURCES
SALARIES
$
356,658
$
267,560
$
294,047
$
62,611
82%
OVERTIME
-
197
5,491
(5,491)
0%
BENEFITS
142,458
89,640
119,289
23,169
84%
SUPPLIES
18,556
3,990
3,925
14,631
21%
SMALL EQUIPMENT
300
2,762
893
(593)
298%
PROFESSIONAL SERVICES
136,471
40,947
55,449
81,022
41%
COMMUNICATIONS
1,550
938
1,138
412
73%
TRAVEL
1,000
1,075
500
500
50%
RENTAL/LEASE
31,921
20,424
25,442
6,479
80%
REPAIR/MAINTENANCE
8,380
7,571
7,832
548
93%
MISCELLANEOUS
43,397
16,818
21,385
22,012
49%
$
740,691
$
451,921
$
535,390
$
205,301
72%
MUNIC IPAL C O URT
SALARIES
$
647,030
$
488,792
$
527,244
$
119,786
81%
OVERTIME
800
1,219
4,538
(3,738)
567%
BENEFITS
223,319
172,770
195,930
27,389
88%
SUPPLIES
10,600
5,773
5,735
4,865
54%
SMALL EQUIPMENT
1,000
5,155
7,074
(6,074)
707%
PROFESSIONAL SERVICES
124,925
62,353
50,787
74,138
41%
COMMUNICATIONS
3,550
2,409
2,135
1,415
60%
TRAVEL
6,500
3,039
37
6,463
1%
RENTAL/LEASE
67,947
53,620
56,409
11,538
83%
REPAIR/MAINTENANCE
4,880
277
7,896
(3,016)
162%
MISCELLANEOUS
25,100
19,828
14,323
10,777
57%
MACHINERY/EQUIPMENT
23,120
23,120
0%
$
1,138,771
$
815,237
$
872,107
$
266,664
77%
O
a
d
OC
C
eo
C
IL
t
C
O
2
O
N
O
N
L
N
O
0
13
Packet Pg. 16 1
I 2.1.a I
Page 2 of 4
C ITY O F EDMO NDS
EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
CITY CLERK
SALARIES AND WAGES
$ 376,214
$ 300,798
$ 335,263
$ 40,951
89%
BENEFITS
156,718
134,171
136,352
20,366
87%
SUPPLIES
10,240
2,403
3,287
6,953
32%
SMALL EQUIPMENT
-
4,024
2,108
(2,108)
0%
PROFESSIONAL SERVICES
37,410
26,712
21,920
15,490
59%
COMMUNICATIONS
40,000
24,920
17,109
22,891
43%
TRAVEL
2,000
494
6
1,994
0%
RENTAL/LEASE
63,850
38,286
42,287
21,563
66%
REPAIRS&MAINTENANCE
32,530
42,728
47,700
(15,170)
147%
MISCELLANEOUS
8,000
8,938
5,166
2,834
65%
$ 726,962
$ 583,474
$ 611,198
$ 115,764
84%
FINANCE
SALARIES
$
870,882
$
710,203
$
808,910
$
61,972
93%
OVERTIME
4,500
-
-
4,500
0%
BENEFITS
289,923
243,921
221,472
68,451
76%
SUPPLIES
7,350
5,479
3,871
3,479
53%
SMALL EQUIPMENT
2,650
579
-
2,650
0%
PROFESSIONAL SERVICES
9,300
1,725
1,518
7,782
16%
COMMUNICATIONS
2,000
1,008
713
1,287
36%
TRAVEL
3,100
2,371
-
3,100
0%
RENTAL/LEASE
50,048
41,924
48,800
1,248
98%
REPAIR/MAINTENANCE
41,480
42,499
43,963
(2,483)
106%
MISCELLANEOUS
8,350
12,353
4,186
4,164
50%
$
1,289,583
$
1,062,062
$
1,133,433
$
156,150
88%
CITY ATTO RNEY
PROFESSIONAL SERVICES
$
912,540
$
728,368
$
718,169
$
194,371
79%
$
912,540
$
728,368
$
718,169
$
194,371
79%
NON -DEPARTMENTAL
SALARIES
$
101,750
$
-
$
-
$
101,750
0%
BENEFITS -UNEMPLOYMENT
50,000
28,264
1,254
48,746
3%
SUPPLIES
5,000
3,477
3,867
1,133
77%
PROFESSIONAL SERVICES
11,009,120
8,765,450
8,643,724
2,365,396
79%
EXCISE TAXES
6,500
6,838
12,850
(6,350)
198%
RENTAL/LEASE
15,249
10,376
13,135
2,114
86%
INSURANCE
394,124
436,448
393,746
378
100%
MISCELLANEOUS
91,774
70,895
101,806
(10,032)
111%
CONTRIBUTION TO ECA
75,000
75,000
75,000
-
100%
INTERFUND SUBSIDIES
3,266,993
625,579
834,033
2,432,960
26%
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
-
212
288
42%
$
15,322,110
$
10,029,350
$
10,148,912
$
5,173,199
66%
O
Q.
d
20
C
eo
C
IL
t
C
O
2
O
N
O
N
L
N
O
r
0
14
Packet Pg. 17
Page 3 of 4
C ITY OF EDMO NDS
EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
1%SPell t
PO LIC E S ERVIC ES
SALARIES
$ 6,968,887
$ 5,455,650
$ 5,787,513
$ 1,181,374
83%
OVERTIME
461,280
590,785
455,082
6,198
99%
HOLIDAY BUYBACK
262,020
8,449
5,394
256,626
2%
BENEFITS
2,769,042
2,170,997
2,301,254
467,788
83%
UNIFORMS
80,750
84,072
54,486
26,264
67%
SUPPLIES
90,500
79,449
67,534
22,966
75%
SMALL EQUIPMENT
127,739
101,916
102,690
25,049
80%
PROFESSIONAL SERVICES
224,548
190,279
151,680
72,869
68%
COMMUNICATIONS
36,000
32,077
36,043
(43)
100%
TRAVEL
29,310
32,743
6,905
22,405
24%
RENTAL/LEASE
826,124
763,196
682,395
143,729
83%
REPAIR/MAINTENANCE
15,180
9,791
5,007
10,173
33%
MISCELLANEOUS
60,350
40,022
26,022
34,328
43%
$ 11,951,730
$ 9,559,426
$ 9,682,005
$ 2,269,725
81%
COMMUNITY S ERVIC ES /EC 0 N DEV.
SALARIES
$
357,423
$
218,341
$
269,916
$
87,507
76%
BENEFITS
114,637
67,718
77,390
37,247
68%
SUPPLIES
7,475
6,414
6,839
636
91%
SMALL EQUIPMENT
4,173
-
3,321
852
80%
PROFESSIONAL SERVICES
214,400
167,093
83,416
130,984
39%
COMMUNICATIONS
2,975
1,130
1,800
1,175
61 %
TRAVEL
2,000
-
1,020
980
51%
RENTAL/LEASE
13,410
9,522
9,834
3,576
73%
REPAIR/MAINTENANCE
10,500
-
-
10,500
0%
MISCELLANEOUS
9,500
4,651
3,948
5,552
42%
MACHINERY/EQUIPMENT
25,000
25,000
0%
$
761,493
$
474,870
$
457,484
$
304,009
60%
DEVELO PM ENT SERVIC ES/PLANNING
SALARIES
$
1,760,943
$
1,357,050
$
1,423,531
$
337,412
81%
OVERTIME
1,300
8,170
13,366
(12,066)
1028%
BENEFITS
658,292
521,179
517,568
140,724
79%
UNIFORMS
500
-
-
500
0%
SUPPLIES
17,100
8,622
6,129
10,971
36%
SMALL EQUIPMENT
7,300
2,663
2,404
4,896
33%
PROFESSIONAL SERVICES
886,518
209,094
150,589
735,929
17%
COMMUNICATIONS
9,000
7,012
9,759
(759)
108%
TRAVEL
6,800
9,661
228
6,572
3%
RENTAL/LEASE
170,234
118,652
141,318
28,916
83%
REPAIRS & MAINTENANCE
6,800
3,439
-
6,800
0%
MISCELLANEOUS
58,060
29,324
37,139
20,921
64%
$
3,582,847
$
2,274,866
$
2,302,031
$
1,280,816
64%
ENGINEERING
SALARIES
$
1,772,804
$
1,426,597
$
1,448,894
$
323,910
82%
OVERTIME
5,000
5,466
2,668
2,332
53%
BENEFITS
701,327
581,643
584,860
116,467
83%
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,051
13,927
5,673
71%
TRAVEL
600
585
134
466
22%
RENTAL/LEASE
134,995
101,281
110,218
24,777
82%
REPAIR/MAINTENANCE
2,600
-
769
1,831
30%
MISCELLANEOUS
80,000
49,746
40,803
39,197
51%
$
2,908,416
$
2,179,362
$
2,204,927
$
703,489
76%
15
Packet Pg. 18
I 2.1.a I
Page 4 of 4
CITY OF EDMO NDS
EXPENDTIURES - GENERAL FUND - BY DEPARTMENT IN DETAIL
2020 Amended
10/31/2019
10/31/2020
Amount
Title
Budget
Expenditures
Expenditures
Remaining
% Spent
PARKS & REC REATIO N
SALARIES
$ 2,272,394
$ 1,704,624
$ 1,636,328
$ 636,066
72%
OVERTIME
10,000
20,073
3,550
6,450
36%
BENEFITS
864,290
648,022
612,660
251,630
71%
UNIFORMS
6,275
5,635
5,030
1,245
80%
SUPPLIES
137,390
134,832
126,376
11,014
92%
SMALL EQUIPMENT
10,900
4,934
6,066
4,834
56%
PROFESSIONAL SERVICES
620,765
389,348
170,648
450,118
27%
COMMUNICATIONS
31,370
21,698
15,858
15,512
51%
TRAVEL
5,270
4,407
50
5,220
1%
RENTAL/LEASE
268,945
229,787
225,745
43,200
84%
PUBLIC UTILITY
230,507
181,560
151,641
78,866
66%
REPAIR/MAINTENANCE
29,700
26,291
16,593
13,107
56%
MISCELLANEOUS
98,110
76,657
31,521
66,589
32%
MACHINERY/EQUIPMENT
9,053
-
9,053
0
100%
CONSTRUCTION PROJECTS
10,296
0%
$ 4,594,969
$ 3,458,166
$ 3,011,118
$ 1,583,851
66%
PUBLIC WORKS ADMINISTRATION
SALARIES
OVERTIME
BENEFITS
SUPPLIES
SMALL EQUIPMENT
PROFESSIONAL SERVICES
COMMUNICATIONS
TRAVEL
RENT AL/LEASE
PUBLIC UTILITY
REPAIR/MAINTENANCE
MISCELLANEOUS
FACILITIES MAINTENANCE
SALARIES
OVERTIME
BENEFITS
UNIFORMS
SUPPLIES
SMALL EQUIPMENT
PROFESSIONAL SERVICES
COMMUNICATIONS
TRAVEL
RENT AL/LEASE
PUBLIC UTILITY
REPAIR/MAINTENANCE
MISCELLANEOUS
CONST RUCT ION PROJECTS
TOTAL GENERAL FUND EXPENDITURES
$ 380,790 $
242,267 $
247,992 $
132,798
65%
200
339
-
200
0%
131,041
85,771
86,876
44,165
66%
8,600
3,488
3,367
5,233
39%
1,000
2,115
264
736
26%
200
92
127
73
64%
1,350
566
605
745
45%
500
1,427
-
500
0%
97,295
74,954
80,021
17,274
82%
3,318
2,395
2,486
832
75%
1,000
-
-
1,000
0%
4,900
975
1,505
3,395
31%
$ 630,194 $
414,388 $
423,243 $
206,951
67%
787,257
634,975
656,026
131,231
83%
7,500
6,030
4,565
2,935
61%
348,852
280,539
281,078
67,774
81%
3,000
4,505
13,961
(10,961)
465%
112,000
130,528
126,343
(14,343)
113%
3,000
5,222
5,207
(2,207)
174%
977,444
158,030
952,599
24,845
97%
16,000
16,658
19,361
(3,361)
121%
1,000
6
-
1,000
0%
55,940
47,338
43,803
12,138
78%
297,700
253,722
247,981
49,719
83%
143,460
325,043
446,637
(303,177)
311%
5,000
3,153
1,802
3,198
36%
1,000,000
1,000,000
0%
$ 3,758,153 $
1,865,748 $
2,799,364 $
958,789
74%
$ 49,044,056 $ 34,483,508 $ 35,443,149 $ 13,600,907 72%
16
Packet Pg. 19
I 2.1.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
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
December
2,700,000
179,761
*The monthly budget forecast columns are based on a five-year average.
u
17
Packet Pg. 20 1
I 2.1.a I
SALES TAX SUMMARY
Sales Tax Analysis By Category
Current Period: October 2020
Year -to -Date
Total $6,719,684
Automotive Repair,
Health &Personal Care, $151,800
$206,892 Amusement &
Recreation, $39,845
Construction Trade, Business Services,
Accommodation, $1,035,190 $688,775
$24,595
Gasoline, $31,223
Clothing and
Accessories, $200,217 Retail Food Stores,
$269,097
Communications,
$196,288
Wholesale Trade, Retail Automotive,
$230,800 $1,492,973
Manufacturing, $83,699
Misc Retail, $1,239,702
Others, $128,607 Eating & Drinking,
$699,981
10,000,000
8,000,000
$
$5,840,764 6,741,838
6,000,000
4,000,000
2,000, 000
0
2014 2015
Annual Sales Tax Revenue
7 395 114 $8,406,296 $8,452,715
$6,905,122
$6,719,684
2016 2017 2018 L. 2019 YTD 2020
u
18
Packet Pg. 21
I 2.1.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
6,719,684
-3.47%
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
535,796
10.13%
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.
i
O
Q
d
C
R
C
LL
21
t
a+
a
O
2
O
N
O
N
L
O
U
u
19
Packet Pg. 22
I 2.1.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
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
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
Current Year Budget - Prior Year
*The monthly budget forecast columns are based on a five-year average.
u
20
Packet Pg. 23
I 2.1.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
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
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
1,000,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.
O
Q.
d
M
C
C
E
21
t
a
O
2
O
N
O
N
L
d
O
v
u
ZZ
Packet Pg. 24
I 2.1.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
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.
O
Q.
d
M
C
C
LL
21
t
C
O
2
0
N
O
N
L
d
O
LW
22
Packet Pg. 25
I 2.1.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
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
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
M
C
C
E
21
t
C
O
2
O
N
O
N
L
d
O
v
u
23
Packet Pg. 26
I 2.1.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
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
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.
O
Q.
d
M
C
C
E
21
t
a
O
2
O
N
O
N
L
d
O
v
u
24
Packet Pg. 27
I 2.1.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
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
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.
u
25
Packet Pg. 28
I 2.1.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
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
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.
O
Q.
d
M
C
C
E
21
t
C
O
2
O
N
O
N
L
d
O
v
u
26
Packet Pg. 29
I 2.1.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.829/c
March
444,630
110,167
352,886
-20.639/c
April
528,740
84,111
396,588
-24.999/c
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.769/c
November
1,231,196
104,309
December
1,454,784
223,588
City of Edmonds, WA
Monthly Expenditure Report -Finance
2020
Finance
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
1,133,433
4.84%
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.
u
27
Packet Pg. 30
I 2.1.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
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
9,682,005
-0.07%
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.
O
Q.
d
M
C
C
E
21
t
C
O
2
O
N
O
N
L
d
O
v
u
Z$
Packet Pg. 31
I 2.1.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
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
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.
u
29
Packet Pg. 32
I 2.1.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
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
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.
u
30
Packet Pg. 33
I 2.1.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
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. 34
I 2.1.a I
INVESTMENT PORTFOLIO SUMMARY
City of Edmonds Investment Portfolio Detail
As of October 31, 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.17
4,000,000
4,007,160
01/01/21
1.47%
First Financial
CD
3,000,000
0.44
3,000,000
3,000,000
04/10/21
2.86%
Port of Seattle WA
Bonds
273,305
0.50
270,000
271,852
05/01/21
2.23%
Grant Cnty WA
Bonds
410,553
1.17
405,000
411,452
01/01/22
1.79%
FFCB
Bonds
1,998,548
1.62
2,000,000
2,054,418
06/14/22
1.88%
Energy Northwest
Bonds
1,466,077
1.67
1,345,000
1,450,300
07/01/22
5.00%
Energy Northwest
Bonds
260,748
1.67
250,000
260,505
07/01/22
2.95%
Mason & Kitsap Cnty WA
Bonds
948,084
2.08
855,000
939,431
12/01/22
5.00%
FHLB
Bonds
3,000,000
2.16
3,000,000
3,007,986
12/30/22
1.79%
Grant Cnty WA
Bonds
1,517,955
2.17
1,500,000
1,533,945
01/01/23
1.54%
Grant Cnty WA
Bonds
576,332
2.17
520,000
572,203
01/01/23
5.00%
Seattle WA Muni
Bonds
2,224,500
2.25
2,000,000
2,211,800
02/01/23
5.00%
FHLB
Bonds
1,996,590
2.93
2,000,000
1,995,276
10/05/23
0.22%
First Financial
CD
2,803,516
3.04
2,803,516
2,803,516
11/15/23
2.10%
Kent WA
Bonds
286,648
3.08
250,000
286,040
12/01/23
5.00%
Spokane County WA
Bonds
259,075
4.09
250,000
264,260
12/01/24
2.10%
First Financial
CD
2,000,000
7.01
2,000,000
2,000,000
11/01/27
1.68%
TOTAL SECURITIES
27,036,049
2.25
26,448,516
27,070,144
Washington State Local Gov't Investment Pool
6,895,687
6,895,687
Demand
0.19%
Snohomish County Local Gov't Investment Pool
20,107,281
20,107,281
Demand
1.60%
TOTAL PORTFOLIO
$
53,451,483 $
54,073,111
Port of Kent WA, Issuer Diversification Seattle WA
Seattle 1% Muni, 8%
WA, 1%
Fi rst
Mason &
Financial -
KitsapCnty
CD, 30%
WA, 3% Grant Cnty
WA 24% Spokane
County
FHLB, 19%,j WA, 1%
Energy
Northwest,
FFCB, 8% 6%
Cash and Investment Balances
(in $ Millions) Checking,
Bonds, State LGIP,
$18.6, 30% $6.9 , 11%
County
CD's, $7.8, LGIP,
13% $20.1, 33%
32
Packet Pg. 35 1
I 2.1.a I
INVESTMENT PORTFOLIO SUMMARY
Annual Interest Income
$1,400, 000
$1,200,000
$1,000,000 917 754
$834,693
$800,000
$653,690
$600,000 —
335 926 $423,816
$400,000 —
$200,000 -
$-
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% -
November
January
March May July September
Maturity Distribution and Rate of Return
$10, 000,000 5.00
$8,000, 000 4.00
$ 6,000, 000 ` 3.00
$4,000, 000 2.00
$ 2,000, 000 4 1.00
r- 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
C-:
33
Packet Pg. 36
GENERAL FUND OVERVIEW
I 2.1.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►1all .1.1 1_1WG101[a]
---- ACTUAL ----
12/31 /2019
9/30/2020
10/31 /2020
$ 15,552,187
$ 11,432,266
$ 11,089,345
$
355,874
379,625
554,152
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
$ 14,769,671
$
---- ACTUAL
----
Q3
YTD c
(2,698,260) $
(4,462,84,
(36,566)
198,27t
-
- c
-
5,00( .E
u_
100
10(
0
-
0
(21,55! c
(2,734,726) $
(4,281,02(
0
r
U
O
*$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. --
*$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
& Subfunds
12
$5.24
$5.05
General Fund
c
Operating Reserve
= 9
i Civic Field
6
$7.72
$7.72
$7.72
3
$2.00
$2.00
$2.00
Dec 2019
Sept 2020
Oct 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. 37
2.1.a
GOVERNMENTAL FUNDS OVERVIEW
CHANGE IN FUND
FUND BALANCES
BALANCES
GOVERNMENTAL
---- ACTUAL ----
FUNDS
---- ACTUAL ----
12/31 /2019 9/30/2020
10/31 /2020
Q3 YTD
General Fund & Subfunds
$ 19,050,690 $ 14,957,121
$ 14,769,671
$ (2,734,726) $ (4,281,02C
Special Revenue
10,622,237 10,235,228
11,490,334
(661,506) 868,09E
c
Debt Service
- (0)
(0)
- (C
m
Capital Projects
6,443,150 6,878,746
6,709,792
516,124 266,642
Total Governmental Funds
$ 36,116,078 $ 32,071,095
$ 32,969,796
$ (2,880,107) $ (3,146,281
c
ii
21
c
O
2
0
N
O
N
Governmental Fund Balances -By Fund Group
Governmental Fund Balances -
y
Combined
O
r
v
O
21
40
...
$19.05
$36.12
O
18
35
$32.07 $32.97
m
d'
--*--General
Fund &
30
R
v
15 $14.96 $14.77 Subfunds
c
--a—Special
25
jy
0 12 Revenue O
21
$11.49
_
10.24 2
20
G
9 Debt
Service
15
N
$6.71
0
N
6
0fCapital
10
d
Projects
O
3
5
c
Dec 2019 Sept 2020 Oct 2020
_
Dec 2019
�
Sept 2020 Oct 2020
ca
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. 38
2.1.a
SPECIAL REVENUE FUNDS OVERVIEW
FUND
BALANCES
CHANGE IN FUND BALANCE:
GOVERNMENTAL
---- ACTUAL ----
---- ACTUAL ----
SPECIAL REVENUE
12/31/2019
9/30/2020
10/31/2020
Q3 YTD
104 - Drug Enforcement Fund
$ 39,839
$ 73,859 $
73,953
$ (3,552) $
34,11:
1 1 1 - Street Fund
1,298,473
1,067,380
1,263,698
(21,067)
(34,77E
112- Combined Street Const/Improve
1,421,769
2,127,421
2,253,924
(70,068)
832,154
117 - Municipal Arts Acquis. Fund
634,011
646,333
682,174
(912)
48,16: F
118 - Memorial Street Tree
19,785
20,222
20,247
210
462 a
120 - Hotel/Motel Tax Revenue Fund
93,013
101,933
100,015
5,742
7,001
121 - Employee Parking Permit Fund
86,844
98,101
98,500
1,114
11,65E
122 - Youth Scholarship Fund
13,600
13,443
13,492
139
(10�
123 -Tourism Promotional Fund/Arts
72,101
85,168
85,681
4,363
13,58C
125 -Real Estate Tax 2
2,625,364
2,572,735
2,653,856
65,414
28,492 ii
126 - Real Estate Excise Tax 1
2,486,325
2,347,350
2,484,802
169,411
(1,52C
127 - Gifts Catalog Fund
332,255
312,548
295,464
(25,442)
(36,791
130 - Cemetery Maintenance/Improvement
260,685
239,431
220,652
(15,694)
(40,032 0
136 - Parks Trust Fund
163,071
166,670
166,880
1,728
3,80E N
137- Cemetery Maintenance Trust Fund
1,053,314
1,086,243
1,089,483
15,362
36,16E N
138 - Sister City Com m ission
10,129
12,868
10,381
134
25: aD
140 -Business Improvement Disrict
11,546
28,653
31,839
9,188
20,29 0
141 -Affordable and Supportive Housing Fd
112
51,036
57,949
18,589
57,83-1 u
142 - Edmonds Cares Fund
-
(816,165)
(112,656)
(816,165)
(112,65E 0
Total Special Revenue
$ 10,622,237
$ 10,235,228 $
11,490,334
1 $ (661,506) $
868,09E t
*$200,000 of the fund balance in Fund 125 has been reserved for Marsh Restoration Funding
12
10
8
Ln
c
0 6
4
i
Special Revenue Funds
■ Special
$10.42 $10.04 $11.29 Revenue
Dec 2019
Sept 2020
&J
Oct 2020
■ Fund 125 - Marsh
Restoration Funding
*Please note that these revenues and expenses occur within annual cycles.
This Interim Report is not adjusted for accruals or those annual cycles.
36
Packet Pg. 39 1
ENTERPRISE FUNDS OVERVIEW
I 2.1.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
10/31 /2020
$ 22,557,221
10,871,573
46,054,303
843,971
31,935
$ 80,359,003
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 October 31, 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 621 573
10,000,000
5,000,0000 $31935 843,971
$250,000
Combined Water Storm Storm -Marsh Sewer/WWTP Bond Reserve
Utility Restoration
Funding
$46,054,303
*Please note that these revenues and expenses occur within annual cycles.
This Interim Report is not adjusted for accruals or those annual cycles.
(492,32�
(1,735,57E
(517,74�
1C a
31,93E W
(2,713,711 .�
v
c
c
ii
21
c
0
2
0
N
O
N
L
r
V
O
$131,118
Firemen's
Pension Fund
37
Packet Pg. 40
SUMMARY OVERVIEW
I 2.1.a I
FUND BALANCES
CITY-WIDE
---- ACTUAL ----
12/31 /2019 9/30/2020 10/31 /2020
Governmental Funds
$ 36,116,077 $ 32,071,095 $ 32,969,796
$
Enterprise Funds
83,072,713 80,191,449 80,359,003
Internal Services Fund
10,803,067 11,538,939 9,789,712
Agency Funds
146,733 139,708 131,118
TotalCity-wideTotal
$130,138,590 $123,941,191 $123,249,629
1 $
CHANGE IN FUND
BALANCES
---- ACTUAL
----
Q3
YTD
(2,880,107) $
(3,146,281
(2,494,132)
(2,713,711 m
279,306
(1,013,35E W
(15,108)
(15,61E T
(5,110,042) $
c
(6,888,961
u_
21
c
0
2
0
Governmental Fund Balances (Excluding General Fund) as of October 31, 2020 c
Drug Enforcement Fund
Street Fund
Combined Street Const/Improve 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
Parks Capital Construction Fund
M
$73,953
1,263,698
� $2,25 ,924
� $682,1 4
$20,247
$100,015
$98,500
$13,492
$85,681
$ ,653,856
$2,1 84,802
1 $295,464
1 $220,652
$166,880
$1089,483
$10,381
$31,839
$6,701,792
$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.
u
This Interim Report is not adjusted for accruals or those annual cycles.
38
Packet Pg. 41 1
INTERNAL SERVICE FUNDS OVERVIEW
I 2.1.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 10/31 /2020
$ 10,016,269 $ 10,654,871 $ 8,857,102 $
786,798 884,068 932,610
$ 10,803,067 $ 11,538,939 $ 9,789,712 1 $
Internal Service Fund Balances
5 10,654,871
786.798 �$884,068
Dec 2019
Sept 2020
$8,857,102
$932,610
Oct 2020
CHANGE IN FUND
BALANCES
---- ACTUAL ----
Q3 YTD
242,460 $ (1,159,16-1
0
36,845 145,812
a
279,306 $ (1,013,35E
2
c
c
ii
21
c
0
2
0
N
O
N
L
0
r
U
O
■ 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. 42
2.2
City Council Agenda Item
Meeting Date: 12/8/2020
Fourth Quarter Budget Amendment
Staff Lead: Dave Turley
Department: Administrative Services
Preparer: Marissa Cain
Background/History
Amend the 2020 Ordinance No. 4198
Staff Recommendation
Staff recommends that Council approve the proposed 4th Quarter Budget Amendment and Ordinance
No. XXXX, and place on the Consent Agenda at the December 15th City Council Meeting.
Attachments:
2020 4th Quarter Budget Amendment Ordinance
2020 4th Quarter Budget Amendment Exhibits - updated
Packet Pg. 43
2.2.a
ORDINANCE NO. XXXX
AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON,
AMENDING ORDINANCE NO. 4198 AS A RESULT OF UNANTICIPATED
TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A
TIME WHEN THE SAME SHALL BECOME EFFECTIVE.
WHEREAS, previous actions taken by the City Council require Interfund Transfers
and increases in appropriations; and
WHEREAS, state law requires an ordinance be adopted whenever money is
transferred from one fund to another; and
WHEREAS, the City Council has reviewed the amended budget appropriations and
information which was made available; and approves the appropriation of local, state, and federal
funds and the increase or decrease from previously approved programs within the 2020 Budget;
and
THEREFORE,
WHEREAS, the applications of funds have been identified;
THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO
ORDAIN AS FOLLOWS:
Section 1. Section 1. of Ordinance No. 4198 amending the final budget for the
fiscal year 2020 is hereby amended to reflect the changes shown in Exhibits A, B, C, and D adopted
herein by reference.
1
Packet Pg. 44
2.2.a
Section 2. Effective Date. This ordinance, being an exercise of a power specifically
delegated to the City legislative body, is not subject to referendum, and shall take effect five (5)
days after passage and publication of an approved summary thereof consisting of the title.
ATTEST/AUTHENTICATE:
CITY CLERK, SCOTT PASSEY
APPROVED AS TO FORM:
OFFICE OF THE CITY ATTORNEY:
IM
JEFF TARADAY
FILED WITH THE CITY CLERK:
PASSED BY THE CITY COUNCIL:
PUBLISHED:
EFFECTIVE DATE:
ORDINANCE NO.
APPROVED:
MAYOR, MIKE NELSON
2
Packet Pg. 45
2.2.a
SUMMARY OF ORDINANCE NO.
of the City of Edmonds, Washington
On the day of , 2020, the City Council of the City of Edmonds,
passed Ordinance No. A summary of the content of said ordinance, consisting
of the title, provides as follows:
AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING
ORDINANCE NO. 4198 AS A RESULT OF UNANTICIPATED TRANSFERS AND
EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL
BECOME EFFECTIVE.
The full text of this Ordinance will be mailed upon request.
DATED this day of 12020.
CITY CLERK, SCOTT PASSEY
3
Packet Pg. 46
2.2.a
EXHIBIT "A": Budget Amendment Summary (December 2020)
FUND
NO.
FUND
DESCRIPTION
2020
BEGINNING
FUND BALANCE
REVENUE
EXPENDITURES
2020
ENDING
FUND BALANCE
001
GENERAL FUND
15,552,186
44,055,157
49,365,292
10,242,051
009
LEOFF-MEDICAL INS. RESERVE
355,874
437,980
467,140
326,714
012
CONTINGENCY RESERVE FUND
1,782,150
56,140
-
1,838,290
014
HISTORIC PRESERVATION GIFT FUND
12,188
5,230
5,900
11,518
016
BUILDING MAINTENANCE
210,221
-
-
210,221
017
MARSH RESTORATION & PRESERVATION FUND
864,491
-
864,491
018
EDMONDS HOMELESSNESS RESPONSE FUND
223,581
100,000
123,581
019
EDMONDS OPIOID RESPONSE FUND
50,000
-
21,555
28,445
104
DRUG ENFORCEMENT FUND
39,840
165,390
45,800
159,430
111
STREET FUND
1,298,473
1,913,184
2,200,133
1,011,524
112
COMBINED STREETCONST/IMPROVE
1,421,770
2,841,881
2,811,463
1,452,188
117
MUNICIPAL ARTS ACQUIS. FUND
634,011
264,200
244,504
653,707
118
MEMORIAL STREETTREE
19,784
750
-
20,534
120
HOTEL/MOTEL TAX REVENUE FUND
93,013
98,630
128,250
63,393
121
EMPLOYEE PARKI NG PERMIT FUND
86,843
27,270
26,880
87,233
122
YOUTH SCHOLARSHIP FUND
13,601
1,790
3,000
12,391
123
TOURISM PROMOTIONAL FUND/ARTS
72,102
34,450
33,900
72,652
125
PARK ACQ/IMPROVEMENT
2,625,364
1,436,090
3,610,520
450,934
126
SPECIAL CAPITAL FUND
2,486,325
1,453,520
3,401,093
538,752
127
GIFTS CATALOG FUND
332,256
145,050
113,782
363,524
130
CEMETERY MAINTENANCE/IMPROV
260,683
184,610
195,787
249,506
136
PARKSTRUSTFUND
163,070
6,390
-
169,460
137
CEMETERY MAINTENANCE TRUSTFD
1,053,314
54,210
-
1,107,524
138
SISTER CITY COMMISSION
10,128
10,380
11,900
8,608
140
BUSINESS IMPROVEMENT DISTRICT FUND
11,546
79,209
80,510
10,245
141
AFFORDABLE & SUPPORTIVE HOUSING FUND
112
-
-
112
142
EDMONDS CARES FUND
-
1,560,000
1,560,000
-
211
LID FUND CONTROL
12,400
12,400
231
2012 LTGO DEBTSERVICE FUND
-
738,400
738,400
-
332
PARKS CONSTRUCTION
6,443,149
9,638,306
13,013,343
3,068,112
421
WATER
23,049,552
11,121,042
12,814,124
21,356,470
422
STORM
12,607,149
6,745,424
10,856,909
8,495,664
423
SEWER/TREATMENT PLANT
46,572,055
25,279,820
32,785,445
39,066,430
424
BOND RESERVE FUND
843,961
1,988,100
1,988,130
843,931
511
EQUIPMENT RENTAL FUND
10,016,266
1,801,427
3,225,665
8,592,028
512
Technology Rental Fund
786,799
1,265,219
1,517,040
534,978
617
FIREMEN'S PENSION FUND
146,732
72,620
88,700
130,652
Totals
130,138,589
113,494,269
141,467,565
102,165,293
r
Q
Packet Pg. 47
2.2.a
EXHIBIT "B": Budget Amendments by Revenue (December 2020)
FUND
NO.
FUND
DESCRIPTION
Adopted
Budget
Ord.#4168
1/1/2020
Adopted
Amendment
Ord.#4174
2/25/2020
Adopted
Amendment
Ord.#4183
4/15/2020
Adopted
Amendment
Ord.#4187
5/19/2020
Adopted
Amendment
Ord.#4191
7/22/2020
Adopted
Amendment
Ord.#4198
10/23/2020
Proposed
Amendment
Ord.#
1212020
2020
Amended
Revenue
Bud et
001
General Fund
$ 43,803,858
$
$
$
$
$
$ 251,299
$ 44,055,157
009
Leoff-Medical Ins. Reserve
437,980
437,980
012
Contingency Reserve Fund
56,140
56,140
014
Historic Preservation Gift Fund
5,230
5,230
017
Marsh Restoration & Preservation Fund
-
018
Edmonds Homelessness Response Fund
019
Edmonds Opioid Response Fund
-
104
Drug Enforcement Fund
165,390
-
165,390
111
Street Fund
1,893,668
19,100
416
1,913,184
112
Combined StreetConst/Improve
2,433,890
313,991
-
94,000
2,841,881
117
Municipal Arts Acquis. Fund
259,635
-
3,941
-
624
264,200
118
Memorial Street Tree
750
-
-
750
120
Hotel/Motel Tax Revenue Fund
98,630
98,630
121
Employee Parking Permit Fund
27,270
27,270
122
Youth Scholarship Fund
1,790
1,790
123
Tourism Promotional Fund/Arts
34,450
34,450
125
ParkAcq/Improvement
1,436,090
1,436,090
126
Special Capital Fund
1,453,520
1,453,520
127
Gifts Catalog Fund
145,050
145,050
130
Cemetery Maintenance/Improv
184,610
184,610
136
Parks Trust Fund
6,390
6,390
137
Cemetery Maintenance Trust I'd
54,210
54,210
138
Sister City Commission
10,380
10,380
140
Business Improvement District Fund
79,209
79,209
142
Edmonds CARES Fund
-
1,265,100
632,550
(337,650)
1,560,000
211
Lid Fund Control
12,400
-
-
12,400
231
2012 LTGO Debt Service fund
738,400
738,400
332
Parks Construction
9,638,306
9,638,306
421
Water
11,116,270
4,772
11,121,042
422
Storm
5,670,766
545,000
504,700
24,958
6,745,424
423
Sewer/Treatment Plant
24,452,726
809,209
-
17,885
25,279,820
424
Bond Reserve Fund
1,988,100
-
-
1,988,100
511
Equipment Rental Fund
1,746,160
55,267
1,801,427
512
Technology Rental Fund
1,202,963
62,256
1,265,219
617
Firemen's Pension Fund
72,620
-
-
72,620
Totals
$109,226,851
$1,668,200
$ 527,741
$
$ 1,265,100
1 $ 726,550
1 $ 79,8271
$ 113,494,269
a
Packet Pg. 48
2.2.a
EXHIBIT "C": Budget Amendments by Expenditure (December 2020)
FUND
N0.
FUND
DESCRIPTION
Adopted
Budget
Ord. #4168
1/1/2020
Adopted
Amendment
Ord. #4174
2/25/2020
Adopted
Amendment
Ord. #4183
4/15/2020
Adopted
Amendment
Ord.44187
5/19/2020
Adopted
Amendment
Ord. #4191
7/22/2020
Adopted
Amendment
Ord. #4198
10/23/2020
Proposed
Amendment
Ord. #
1212020
2020
Amended
Expenditure
Budget
001
General Fund
$ 48,244,815
$ 313,606
$ 485,635
$
$
$
321,236
$ 49,365,292
009
Leoff-Medical Ins. Reserve
467,140
-
-
-
467,140
012
Contingency Reserve Fund
-
-
014
Historic Preservation Gift Fund
5,900
5,900
017
Marsh Restoration & Preservation Fund
-
-
018
Edmonds Homelessness Response Fund
-
100,000
100,000
019
Edmonds Opioid Response Fund
21,555
-
21,555
104
Drug Enforcement Fund
45,800
-
45,800
111
Street Fund
2,139,717
60,000
416
2,200,133
112
Combined Street Const/Improve
2,403,472
313,991
94,000
-
2,811,463
117
Municipal Arts Acquis. Fund
243,880
-
-
624
244,504
118
Memorial Street Tree
-
-
-
-
120
Hotel/Motel Tax Revenue Fund
122,750
5,500
128,250
121
Employee Parking Permit Fund
26,880
-
26,880
122
Youth Scholarship Fund
3,000
3,000
123
Tourism Promotional Fund/Arts
33,900
-
33,900
125
ParkAcq/Improvement
3,067,616
542,284
620
3,610,520
126
Special Capital Fund
2,661,040
716,786
23,267
3,401,093
127
Gifts Catalog Fund
100,220
10,762
2,800
113,782
130
Cemetery Maintenance/Improv
195,787
-
-
195,787
136
Parks Trust Fund
-
-
137
Cemetery Maintenance Trust I'd
-
-
138
Sister City Commission
11,900
11,900
140
Business Improvement District Fund
80,510
80,510
142
Edmonds CARES Fund
-
-
-
-
1,265,100
632,550
(337,650)
1,560,000
211
Lid Fund Control
12,400
-
-
12,400
231
2012LTGO Debt Service Fund
738,400
738,400
332
Parks Construction
11,942,630
1,070,713
13,013,343
421
Water
12,436,114
373,238
-
4,772
12,814,124
422
Storm
8,357,375
1,190,856
1,283,720
24,958
10,856,909
423
Sewer/Treatment Plant
30,493,425
2,274,135
-
17,885
32,785,445
424
Bond Reserve Fund
1,988,130
-
-
1,988,130
511
Equipment Rental Fund
3,170,398
-
55,267
3,225,665
512
Technology Rental Fund
1,224,784
230,000
62,256
1,517,040
617
Firemen'S Pension Fund
78,700
-
-
10,000
88,700
Totals
1 $130,318,238
$ 7,101,871
$ 1,796,042
$ 100,000
$ 1,265,100
$ 726,550
$ 159,764
$ 141,467,565
a
Packet Pg. 49
EXHIBIT "D": Budget Amendment Summary (December 2020)
2.2.a
Fund Number
Proposed
Amendment
Changein
Revenue
Proposed
Amendment
Changein
Expense
Proposed
Amendment
Change in Ending
Fund Balance
001
251,299
321,236
(69,937)
111
416
416
117
624
624
142
(337,650)
(337,650)
421
4,772
4,772
422
24,958
24,958
423
17,885
17,885
511
55,267
55,267
512
62,256
62,256
-
617
10,000
(10,000)
Total Change
79,827
1 159,764
(79,937)
r
Q
Packet Pg. 50
2.2.b
New Item for Council to Consider (December 2020)
Budget Amendment for:
Fourth Quarter
Item Description:
In late 2019 our previous State Lobbyist resigned requiring an REP for a new Lobbyist, after the 2020
Budget was set. Due to the change in Lobbyist there was a slight increase to the monthly fee, which this
amendment reflects by increasing the total budget from $40,296 to $45,000. This increase will be an on-
E
going expense.
C
d
E
Q
.r
d
Department:
Economic Development/Community Services
Fund
Name:
001 GENERAL
'D
m
O
N
N
Division:
Community Services
Title:
Lobbyist Activities
Preparer:
Patrick Doherty
Budget Amendment Type
New Item For Council To Consider
d
Date of Discussion or Budget Approval?
7
How is this amendment funded?
100% Ending Fund Balance
What is the nature of the expenditure?
On -Going
t
7
Is the Expenditure Operating or Capital?
10perating
IL
Expenditure Increase (Decrease)
Fill out on -going costs & revenues
_
Account Number
Description
2020
2021
2022
2023
2024
001.000.61.511.70.41.00
Professional Services
$ 4,704
$ 4,704
$ 4,704
$ 4,704
$ 4,704
Total Expenditure Increase Decrease
$ 4,704
$ 4,704
$ 4,704
$ 4,704
Revenue Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
$
$
$
$
$
Total Revenue Increase (Decrease)
$
$
$
$
$
Ending Fund Balance Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
001.000.39.508.00.00.00
Ending Fund Balance
(4,704)
(4,704)
(4,704)
4,704)
(4,704
Total Ending Fund Balance Increase Decrease
$ (4,704)
$ 4,704)
$ 4,704)
$ (4,704)
$ (4,704
Packet Pg. 51
2.2.b
New Item for Council to Consider (December 2020)
Budget Amendment for:
Fourth Quarter
Item Description:
This amendment covers three sets of goods/services reimbursed by other entities. The Police Department
opened up a peer support/critical incident class to other agencies. The outside agencies paid a portion of the
instructor costs. The department also received permission to use State School Zone funds to purchase a new
radar gun and motorcycle gloves. Edmonds Police Foundation funded eight bleeding control kits and some
E
supplies for the Peer Support Team.
d
E
Q
.r
d
Department:
Police
Fund
Name:
001 GENERAL
-a
m
O
N
N
Division:
N/A
Title:
Goods and Services Reimbursed by Others
Preparer:
Caroline Thompson, Executive Assistant, x1397
Budget Amendment Type
New Item For Council To Consider
d
Date of Discussion or Budget Approval?
7
How is this amendment funded?
Reimbursed by Grants or Outside Agencies
What is the nature of the expenditure?
One -Time
t
7
Is the Expenditure Operating or Capital?
Orating
pe
LP
L
Expenditure Increase (Decrease)
_
Account Number
Description
2020
2021
2022
2023
2024
001.000.41.521.40.49.00
Police Training - Miscellaneous
$ 1,194
$
$
$
$
001.000.41.521.71.35.00
Police Traffic - Small E ui ment
690
001.000.41.521.71.31.00
Police Traffic - Supplies
142
001.000.41.521.40.31.00
Police Training - Supplies
40
001.000.41.521.22.35.00
Police Patrol - Small Equipment
1,622
Total Expenditure Increase (Decrease)
$ 3,688
$
$
$
$
Revenue Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
001.000.337.30.000.00
Police Training Classes
$ 1,194
$
$
$
$
001.000.334.03.500.01
School Zone Account
832
001.000.367.00.400.00
Police Contributions from Private Sources
1,662
Total Revenue Increase Decrease
$ 3,688
$
$
$
$
Ending Fund Balance Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
S
$
S
$
S
Total Ending Fund Balance Increase Decrease
S
$
S
$
S
Packet Pg. 52
2.2.b
New Item for Council to Consider (December 2020)
Budget Amendment for:
Fourth Quarter
Item Description:
Purchase NPDES Pro Software to assist with tracking and reporting of several requirements related to
NPDES municipal permit compliance. Inspection workloads to meet NPDES requirements continue to
increase without increases in staffing; staff propose this software purchase to help manage increasing
workloads. The proposed budget amendment covers the cost of the initial set up fee and a 3-year license to
E
the software and will be entirely grant -funded by the Stormwater Capacity Grant funds form Ecology
d
which required no City -match and are intended specifically for increasing efficiencies in meeting permit
E
requirements.
Q
.r
d
Department:
Public Works
Fund
Name:
422 STORM
'D
m
O
N
N
Division:
Engineering
Title:
NPDESPro Software Purchase
Preparer:
Zachary Richardson (Stormwater Engineer)
Budget Amendment Type
New Item For Council To Consider
d
Date of Discussion or Budget Approval?
7
How is this amendment funded?
Reimbursed by Grants or Outside Agencies
What is the nature of the expenditure?
One -Time
t
7
Is the Expenditure Operating or Capital?
Operating
ILL
Expenditure Increase (Decrease)
_
Account Number
Description
2020
2021
2022
2023
2024
422.000.72.531.90.49.20
Miscellaneous Engineering
$ 23,000
$
$
$
$
Total Expenditure Increase (Decrease)
$ 23,000
$
$
$
$
Revenue Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
422.000.334.03.102.40
Ecology Capacity Grant
$ 23,000
$
$
$
$
Total Revenue Increase Decrease
$ 23,000
$
$
$
$
Ending Fund Balance Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
S
$
S
$
S
Total Ending Fund Balance Increase Decrease
S
$
S
$
S
Packet Pg. 53
2.2.b
New Item for Council to Consider (December 2020)
Budget Amendment for:
Fourth Quarter
Item Description:
Unit 525-POL a 2019 Ford Explorer police patrol vehicle was totaled in May 2020, WCIA paid us
$53,139.48 to replace it. The money was deposited into the vehicle replacement revenue fund, and this
adjustment creates the spending authority so we can purchase its replacement.
E
C
d
E
Q
.r
d
Department:
Public Works
Fund
Name:
511 EQUIPMENT
RENTAL
-a
al
m
p
N
N
Division:
Fleet
Title:
Police Vehicle Replacement
Preparer:
Mike Adams
Budget Amendment Type
New Item For Council To Consider
d
Date of Discussion or Budget Approval?
7
How is this amendment funded?
100% Self Funded
t
What is the nature of the expenditure?
One -Time
7
Is the Expenditure Operating or Capital?
Capital
LPL
Expenditure Increase (Decrease)
_
Account Number
Description
2020
2021
2022
2023
2024
511.100.77.594.48.64.00
Equipment
$ 53,139
$
$
$
$
Total Expenditure Increase (Decrease)
53,139
$
$
$
$
Revenue Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
511.100.372.00.000.00
Insurance proceeds
53,139
$
$
$
$
Total Revenue Increase Decrease
$ 53,139
$
$
$
$
Ending Fund Balance Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
S
$
S
$
S
Total Ending Fund Balance Increase Decrease
S
$
S
$
S
Packet Pg. 54
2.2.b
New Item for Council to Consider (December 2020)
Budget Amendment for:
Fourth Quarter
Item Description:
To increase spending authority for the Firemen's Pension Fund. Through November, $75,665 has been
expended from this fund, which has a budget of $78,700. This decision package is to add budget
authority to make sure we remain under budget at year-end.
C
d
E
Q
.r
d
Department:
Finance
Fund
Name:
617 FIREMEN'S
PENSION
-a
7
m
N
N
Division:
Title:
Fund 617 Additional Spending Authority
Preparer:
Dave Turley
Budget Amendment Type
New Item For Council To Consider
d
Date of Discussion or Budget Approval?
7
How is this amendment funded?
100% Ending Fund Balance
t
What is the nature of the expenditure?
One -Time
7
Is the Expenditure Operating or Capital?
Operating
IL
Expenditure Increase (Decrease)
_
Account Number
Description
2020
2021
2022
2023
2024
617.000.51.517.20.29.00
PENSION AND DISABILITY PAYMENTS
10,000
$
$
$
$
Total Expenditure Increase (Decrease)
$ 10.000
$
$
$
$
Revenue Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
S
$
$
$
$
Total Revenue Increase Decrease
S
$
$
$
$
Ending Fund Balance Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
617.000.51.508.00.00.00
Ending Fund Balance
$ 10,000)
$
S
$
S
Total Ending Fund Balance Increase Decrease
$ 10,000)
$
S
$
$
Packet Pg. 55
2.2.b
Previously Discussed by Council (December 2020)
Budget Amendment for:
Fourth Quarter
Item Description:
This decision package is a request to increase the budget for salaries and benefits in the Police
Department. This increase is necessary due to increased costs related to the COVID-19 response, as well as
increased labor costs that resulted from the EPOA Commissioned Officers contract that was settled in
July.
E
C
d
E
Q
.r
d
Department:
Police Department
Fund
Name:
001 GENERAL
'D
7
m
O
N
N
Division:
Title:
Increase to budget for Salaries/Benefits
Preparer:
Caroline Thompson
Budget Amendment Type
New Item For Council To Consider
d
Date of Discussion or Budget Approval?
7
How is this amendment funded?
100% Ending Fund Balance
t
What is the nature of the expenditure?
One -Time
7
Is the Expenditure Operating or Capital?
Orating
pe
LP
L
Expenditure Increase (Decrease)
_
Account Number
Description
2020
2021
2022
2023
2024
001.000.41.521.22.11.00
Police - Patrol Salaries
$ 57,268
$
$
$
$
001.000.41.521.22.23.00
Police - Patrol Benefits
7,965
Total Expenditure Increase (Decrease)
$ 65,233
$
$
$
$
Revenue Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
S
$
$
$
$
Total Revenue Increase Decrease
S
$
$
$
$
Ending Fund Balance Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
001.000.39.508.00.00.00
Ending Fund Balance
$ 65,233
$
S
$
S
Total Ending Fund Balance Increase Decrease
$ 65,233
$
S
Packet Pg. 56
2.2.b
Previously Discussed by Council (December 2020)
Budget Amendment for: Fourth Quarter
Item Description: To move the CARES Funds as allocated with Ordinance 4196 to the associated Funds where
reimburseable expenditures were made.
Department: Citywide
Division: Fund
MULTIPLE FUNDS
Title: I COVID-19 Response Name:
Preparers I Dave Turley 7
Budget Amendment Type
Date of Discussion or Budget Approval?
How is this amendment funded?
What is the nature of the expenditure?
Is the Expenditure Operating or Capital?
Expenditure Increase (Decrease)
Previously Discussed By Council
Oct 6 2020
Reimbursed by Grants or Outside Agencies
One -Time
Operating
Account Number
Description
2020
2021
2022
2023
2024
001.000.66.518.30.31.00
SUPPLIES
$ 47,514
$
$
$
$
001.000.64.576.80.45.00
RENTAL/LEASE
12,666
001.000.64.576.80.31.00
SUPPLIES
10,987
001.000.66.518.30.24.00
UNIFORMS
10,823
001.000.64.571.22.41.00
PROFESSIONAL SVC
6,403
001.000.41.521.22.31.00
SUPPLIES
5,028
001.000.23.512.50.35.10
SMALL EQUIPMENT -JUDICIAL
3,144
001.000.41.521.22.35.00
SMALL EQUIPMENT
3,126
001.000.22.518.10.31.00
SUPPLIES
2,510
001.000.64.571.22.49.00
MISCELLANEOUS
2,211
001.000.64.571.22.31.00
SUPPLIES
2,090
001.000.62.524.10.49.00
MISCELLANEOUS
1,303
001.000.22.518.10.49.00
MISCELLANEOUS
1,138
001.000.62.524.10.42.00
COMMUNICATIONS
965
001.000.23.512.50.48.00
REPAIR/MAINT
956
001.000.62.558.60.49.00
MISCELLANEOUS
827
001.000.66.518.30.35.00
MINOR EQUIPMENT
818
001.000.62.524.20.42.00
COMMUNICATIONS
811
001.000.39.525.40.49.00
MISCELLANEOUS
4,439
111.000.68.542.90.24.00
UNIFORMS
416
117.100.64.573.20.41.00
PROFESSIONAL SERVICE
624
421.000.74.534.80.31.00
SUPPLIES
4,772
422.000.72.531.90.31.00
SUPPLIES
1,958
423.000.76.535.80.31.00
SUPPLIES
7,698
423.000.75.535.80.31.00
SUPPLIES
4,772
423.000.76.535.80.41.00
PROFESSIONAL SVC
3,160
423.000.76.535.80.35.00
SMALL EQUIPMENT
1,369
423.000.76.535.80.42.00
COMMUNICATIONS
886
511.000.77.548.68.31.10
SUPPLIES
2,128
512.100.31.518.88.35.00
SMALL EQUIPMENT
30,760
512.000.31.518.88.48.00
REPAIR & MAINTENANCE
14,007
512.000.31.518.88.35.00
SMALL EQUIPMENT
11,095
512.000.31.518.88.31.00
SUPPLIES
6,394
001.000.39.565.10.41.00
COMMUNITY RELIEF FUNDS
76,578
001.000.64.571.30.11.00
SALARIES
44,282
001.000.39.517.78.11.00
SALARIES
8,992
142.000.39.518.63.41.00
CARES RELIEF FUNDS
337,650
Total Expenditure Increase Decrease
$
$
I $ -
$
$
Revenue Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
001.000.333.21.019.00
CORONAVIRUS RELIEF FUND
$ 247,611
111.000.333.21.019.00
CORONAVIRUS RELIEF FUND
416
117.100.333.21.019.00
CORONAVIRUS RELIEF FUND
624
142.000.333.21.019.00
CORONAVIRUS RELIEF FUND
337,650
421.000.333.21.019.00
CORONAVIRUS RELIEF FUND
4,772
422.000.333.21.019.00
CORONAVIRUS RELIEF FUND
1,958
423.000.333.21.019.00
CORONAVIRUS RELIEF FUND
17,885
511.000.333.21.019.00
CORONAVIRUS RELIEF FUND
2,128
512.000.333.21.019.00
CORONAVIRUS RELIEF FUND
31,496
512.100.333.21.019.00
CORONAVIRUS RELIEF FUND
30,760
Total Revenue Increase(Decrease)
$
$
$ -
$
$
Ending Fund Balance Increase (Decrease)
Account Number
Description
2020
2021
2022
2023
2024
$
$
$
$
Total Ending Fund Balance Increase Decrease
$
$
$
$
$
Packet Pg. 57