2022-08-09 City Council - Full FIN Agenda-32421.
Op E D
o Agenda
Edmonds City Council
tnl. }nyo FINANCE COMMITTEE
CITY COUNCIL CONFERENCE ROOM
121 - 5TH AVENUE N, EDMONDS, WA 98020
AUGUST 9, 2022, 5:30 PM
COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF.
COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS.
PERSONS WISHING TO ATTEND THIS MEETING VIRTUALLY IN LIEU OF IN -PERSON ATTENDANCE
CAN CLICK ON OR PASTE THE FOLLOWING ZOOM MEETING LINK INTO A WEB BROWSER USING A
COMPUTER OR SMART PHONE:
HTTPS://ZOOM. US/J/95798484261
OR JOIN BY DIAL -UP PHONE:
US: +1 253 215 8782
WEBINAR ID: 957 9848 4261
STAFF AND COUNCILMEMBERS ATTEND COMMITTEE MEETINGS VIRTUALLY, AND MEMBERS OF
THE PUBLIC ARE ENCOURAGED TO ATTEND THE SAME WAY.
IF MEMBERS OF THE PUBLIC CANNOT ACCESS THE VIRTUAL COMMITTEE MEETINGS WITH THEIR
PERSONAL DEVICES, A MONITOR IS PROVIDED ON CITY COUNCIL COMMITTEE NIGHTS FROM 430-
930 PM AT THE CITY COUNCIL CONFERENCE ROOM AT 150 5TH AVE N, EDMONDS WA.
COMMITTEE MEMBERS: DIANE BUCKSHNIS (CHAIR), WILL CHEN, COUNCIL PRESIDENT (EX-OFFICIO
MEMBER)
CALL TO ORDER
COMMITTEE BUSINESS
1. Clean Building Act Investment Grade Audit - Frances Anderson Center (10 min)
2. Waterfront Center Loan Update Chris Wolfe, Daniel Johnson (15 min)
3. Employee Expense Reimbursement Policy (20 min)
4. Monthly Financial Report (20 min)
ADJOURN
Edmonds City Council Agenda
August 9, 2022
Page 1
2.1
City Council Agenda Item
Meeting Date: 08/9/2022
Clean Building Act Investment Grade Audit - Frances Anderson Center
Staff Lead: Thom Sullivan, Facilities Manager - Department of Public Works
Department: Public Works & Utilities
Preparer: Royce Napolitino
Background/History
Clean buildings are essential to meeting our state energy goals. In 2019 the Clean Buildings bill was
signed into law and later expanded in 2022. The objective is to lower costs and pollution from fossil fuel
consumption in the state's existing buildings. The law directed Commerce to develop and implement an
energy performance standard for covered buildings, and the expansion now includes multifamily
buildings. The law also provides incentives to encourage building owners to make energy efficiency
improvements earlier than required. Buildings over 50,000 square feet will be required to meet these
requirements by 2028 with two prior years of Energy Use Intensity compliance verification.
Staff Recommendation
Approve Investment Grade Audit with ESCO Contractor McKinstry for $93,900 for design and
compliance of the Frances Anderson HVAC System
Narrative
We propose renovation of the Frances Anderson Center HVAC system. This includes replacing two large
gas -heated boilers to a modern all -electric variable refrigerant system. This system would supply the
building with forced air heating and cooling, as well as mechanical ventilation separate from the heating
and cooling system. This proposal outlines the building's pathway to compliance with divestment from
fossil fuels while increasing the buildings resilience to climate change. With year round space
conditioning, the Parks department would be better positioned to serve the public with regulated air
temperatures and filtered air ventilation. Staff recommends that funding for the Investment Grade
Audit come from the 2020 Bond dollars that were allocated for facilities deferred maintenance in Fund
016.
Attachments:
City of Edmonds - FAC HVAC IGA Proposal_08-02-22
Packet Pg. 2
2.1.a
try
ito Of Your Building
August 2nd, 2022
To: Thom Sullivan, Facilities Manager, City of Edmonds
Cc: Novella Randall - Energy Engineer; Department of Enterprise Services
From: Andrew Williamson - Municipal Business Manager; McKinstry
Project: Frances Anderson Center (FAC) HVAC Upgrade
Subject: Investment Grade Audit Proposal
Dear Mr. Sullivan:
The Frances Anderson Center is a pivotal recreation and cultural facility in the City of Edmonds. It also has a
historical significance. The City is interested in upgrading the building's HVAC system to provide improved
occupant comfort and experience. The City would like this upgrade to enhance the energy efficiency and
operation of the City buildings through a performance -based contract with McKinstry. This proposal will provide
the guidelines for which McKinstry will provide the following tasks:
1. Conduct an Investment Grade Audit of the HVAC system at the Frances Anderson Center (700 Main St,
Edmonds, WA 98020)
2. Develop a comprehensive Energy Services Proposal for upgrading the HVAC System.
INVESTMENT GRADE AUDIT (IGA): The audit will be a collaborative effort with City of Edmonds and the Washington
State Department of Enterprise Services (DES). It will identify and analyze performance -based contracting
measures along with their associated savings, costs, and potential for utility rebates and grants. The final
deliverable of the IGA will be an Energy Services Proposal (ESP) for implementation of viable initiatives with
associated energy cost savings.
The following scope of work is included:
✓ Preliminary evaluation of the building's existing electrical infrastructure's available capacity.
✓ Identify and document existing HVAC system and its operation.
✓ Code review.
✓ Preliminary Load Analysis to establish new system's capacity and system alternatives.
✓ Preliminary system selection, zoning and sizing.
✓ Evaluation of Clean Building Performance Standard compliance for the proposed system.
✓ Preliminary Structural review to confirm installation pf new system components.
✓ Review existing good faith surveys, identify and communicate any data gaps to the City
✓ Initiate discussion with local AHJ for clarifications etc as necessary.
REQUESTED INFORMATION: For effective execution of this proposal we ask that the City of Edmonds provide access
to the following:
✓ Good Faith Survey for the building in scope.
✓ Historical utility bills for the last 60 months.
✓ All mechanical, electrical, architectural, structural and building controls drawings.
✓ Access to Building Automation System (BAS).
✓ All operational and maintenance manuals, balancing records, & specifications.
✓ Operational records related to the cost of maintaining specific equipment.
✓ Information with regards to any on -going maintenance contracts.
✓ Access to individuals that have relevant information pertaining to the day-to-day operation of energy
using systems on site.
5005 Third Avenue South * Seattle, WA * 98124-0567 * 206.762.3311 * Fax 206.762.2624
Packet Pg. 3
2.1.a
try
ife Ol Your Building
Page 2
TIMELINE AND MILESTONES: McKinstry will initiate this scope of work immediately upon acceptance of this proposal
and establishment of a professional services agreement based on McKinstry's existing master agreement with
the Department of Enterprise Services (DES). Formal progress review meetings will be conducted regularly
throughout the study phase. During these review meetings, McKinstry will recommend measures based on the
analysis, while the City of Edmonds and DES will provide final direction regarding recommended measures. The
goal of these review meetings is to focus engineering efforts, budgeting, and savings assessment on those
solutions that possess a high probability for implementation. McKinstry will target completion of the IGA within
105 calendar days of a notice to proceed.
CRITERIA FOR IMPLEMENTATION: It Is the City of Edmonds's intent that McKinstry will implement all approved projects
that meet the following criteria.
✓ Facility Improvement Measures shall be life cycle cost effective as an aggregate using the Office of
Financial Management (OFM) life cycle cost model tool.
✓ Not more than 90% of the energy cost savings may be used to help repay a loan, if applicable.
✓ McKinstry will work with the clients' utilities and other entities to secure conservation grant funding or
low interest loans for applicable measures.
✓ Client may list favorable subs and equipment
Investment Grade Audit Fee: The City of Edmonds will reimburse McKinstry for a lump sum of $86,000 for this
scope of work. All fees assessed under this proposal will be included in the final project implementation costs.
In the event that McKinstry is unable to recommend projects that meet the criteria above, the City of Edmonds
has no financial obligation to McKinstry. However, if the recommendations meet or exceed the Criteria for
Implementation and the City of Edmonds chooses not to enter into an agreement with McKinstry to install the
projects, the City of Edmonds will reimburse McKinstry for the Investment Grade Audit fee. All associated
information, including deliverables, will become the property of the City of Edmonds upon final receipt of
payment. Deliverables are listed in attachment (A).
We look forward to working with the City of Edmonds and DES on a successful project. Please call should you
have any questions.
": �/, " o �� �
Andrew Williamson, LEED AP
McKinstry Energy Services
Account Executive
206.491.7117
5005 Third Avenue South * Seattle, WA * 98124-0567 * 206.762.3311 * Fax 206.762.2624
Packet Pg. 4
2.1.a
try
ife Ol Your Building
Attachment A
Investment Grade Audit Deliverables
The Investment Grade Audit for the City of Edmonds Frances Anderson Center will include the following
elements:
Page 3
1. A description of the systems which shall receive new Equipment and Services;
2. The cost-effective Facility Improvement Measures (FIMs) to be installed or caused to be installed
by McKinstry and a description of the FIMs analyzed but disqualified under the cost effectiveness
criteria;
3. A description of the services that McKinstry will perform or cause to be performed on or in the
infrastructure, including but not limited to engineering, construction management, the operations
and maintenance procedures for use on Equipment, training for personnel, warranty service
provided, and equipment maintenance provided;
4. The Maximum Allowable Project Cost, itemized in detail, which may be amended to represent
actual costs;
5. Recommendations for replacement of existing equipment, along with recommendations for
improvements to existing equipment and operating conditions;
6. The service standards appropriate for the infrastructure;
7. The baseline energy consumption, including the data, methodology and variables used to
compute the baseline, and the baseline calendar period which shall not be less than twelve (12)
months;
8. The estimated energy savings and energy cost savings that are expected to result from the
installation of the Equipment and from the Services, and an explanation of the method used to
make the estimate;
9. The method by which Energy Savings and Energy Cost Savings will be calculated during the term
of the Energy Services Agreement;
10. A description of how project financing (if allowed by the client) will be completed;
11. A description of how the Energy Savings will be guaranteed by McKinstry;
12. A description of how McKinstry proposes to be compensated;
13. The term of the Energy Services Authorization;
14. The Termination Value for each year during the term of the Energy Services Authorization;
15. The schedule for project completion;
16. The nature and extent of the Work and equipment that ESCO anticipates it will receive from other
firms under subcontract.
5005 Third Avenue South * Seattle, WA * 98124-0567 * 206.762.3311 * Fax 206.762.2624
Packet Pg. 5
2.2
City Council Agenda Item
Meeting Date: 08/9/2022
Waterfront Center Loan Update Chris Wolfe, Daniel Johnson
Staff Lead: Dave Turley
Department: Administrative Services
Preparer: Dave Turley
Background/History
The Waterfront Center took out a loan from First Financial Northwest Bank for approximately $2 million
to enable them to complete construction on the Center. In order to help them secure this loan, the City
placed a Certificate of Deposit with FFNB as collateral. The Waterfront Center has been paying back the
loan over time. This is an opportunity for Waterfront Center representatives to share the progress they
have made on the loan, and give the City an idea of how long they anticipate it will take them to pay the
loan off in full.
Staff Recommendation
No recommendation, informational only. This information will assist staff in having a better
understanding of future City cash flows.
Narrative
N/A
Packet Pg. 6
2.3
City Council Agenda Item
Meeting Date: 08/9/2022
Employee Expense Reimbursement Policy
Staff Lead: Dave Turley
Department: Administrative Services
Preparer: Dave Turley
Background/History
The Administrative Services Department works with the Finance Committee to update and improve
Finance policies. We would like to bring these updates to the Expense Reimbursement Policy to
Committee for discussion.
Staff Recommendation
No final action tonight, staff recommendation is to discuss and make suggestions for improvement. An
updated version will be brought back to a future committee meeting, hopefully for final approval at that
time.
Attachments:
Employee Expense Reimbursement Policy
Packet Pg. 7
2.3.a
City of Edmonds
Employee Expenses, Volunteer Recognition and
Reimbursements Policy
2022
V
0
a
r
c
as
E
a�
L
E
.N�
LPL
N
C
d
Q
X
W
0
Q
W
ci
0
(L
c
E
0)
U)
L
E
U)
Q
K
W
0
Q
E
W
0
0
E
M
U
2
Y
Y
Q
Packet Pg. 8
2.3.a
City of Edmonds
Employee Expenses, Volunteer Recognition and Reimbursement Policy
EMPLOYEE EXPENSES. VOLUNTEER RECOGNITION, AND REIMBURSEMENTS
General Reimbursement Policy
The City of Edmonds reimburses its employees and eleeted er appeinted effiei for reasonable
expenses incurred conducting City business providing the expenses are prudent and directly related
to the individual's service on behalf of the City.
The City of Edmonds is best served by the active participation of community citizens as volunteers.
Volunteers learn more about their City and contribution to its effectiveness, thereby fostering
increased cooperation and understanding.
Administration
The Finance Director administers the reimbursement program, designs and distributes forms and
instruction and carries responsibility for review of claims. Claims will not be allowed without a
detailed account of monies spent certified by the individual making the claim, ^^��
State nudit,
vr.
Documentation
Claims for personal reimbursement must be made on official Employee Claim for Expenses form, be
accompanied by the vendor's or-iginal-Invoice, receipt or bankcard charge slip showing the date,
vendor imprinted -name, amount paid and items/services received, and must be ^ -44fiea eei*eet ^^a
signed by the individual seeking reimbursement. Should a receipt be lost or not be obtainable, an
employee must fill out a Lost Receipt form and attach to the Claim for Expenses signed by his/her
Department Head (or Mayor if the employee is a Department Head). This will serve as a substitute
for a receipt.
In addition to the documentation above, claims for meals that feed others require the following
documentation:
1. The names of the individuals being hosted
2. Their official title or capacity as it relateds to City business
3. The nature of the topics discussed, nature of the occasion, what public purpose or policy was
being served (and/or copy of agenda)
Reimbursement is sSubject to budget beins available for the event, and preapproval by the
Mayor for staff -sponsored events, ^d by ,. he r. neil President f m., _ mote:, ^Spesareaand even4s.
Employee claims for expenses must be signed by department heads, or in his/her absence, by his/her
designee. Department head or acting department head claims must be signed by the Mayor.
r,.unei1 member expenses must be signed by the r,.unei1 President Whenever possible, City
expenses should be paid for using City funds. At times, however, an employee or eleeted ,true;^,
may find it expedient or necessary to pay for an expenditure out of their own pocket and seek
reimbursement from the City afterwards. When this occurs, the employee ^r eleetea ^r -ei-a should
Formatted: Indent: Left: 0.25'
E
Q
Packet Pg. 9
2.3.a
City of Edmonds
Employee Expenses, Volunteer Recognition and Reimbursement Policy
obtain pre -approval for the expenditure, before usingtheir personal funds. If such pre -approval was
not obtained, approval after -the -fact is at the sole discretion of their Supervisor, Department
Director or Mayor, ^r Cotmeil PresidefA whichever applies.
All Employee claims should be submitted in a timely manner; within 30-60 days. Ne ..ei fflbt ffse..,erequests will be autho-ii-modd f-or any e?qwnses taking plaeo in a previous budget year-.
.
Q
Packet Pg. 10
2.3.a
City of Edmonds
Employee Expenses, Volunteer Recognition and Reimbursement Policy
Food and Beverage v
There is no state law explieitly authorizing eities to pay for food and beverages with ptiblie funds-.
O
IL
Laeking a law, the responsibility is plaeed on the leeal eity to detefmine its pahey far- paying fer fe
c
m
and bevef ages for- employees.
E
Based on ^ ^.,a.,4ion, from the State udit,.rl. nrr ^^ •The City uses the following guidelines
m
in determining the use of public funds for expenditures for food and beverages:
1. Who consumed this food and drink?
E
2. What was the nature of the occasion for the consumption?
3. What public purpose or policy objective was served?
d
4. M4iy was it neeessar., to e ^ food and beverage to e out the pokey?
M
c
5:4. Were the expenses "reasonable"?
m
6-.5. Were the expenses consistent with the policy authorizing reimbursement?
K
W
The city must also consider Internal Revenue Service regulations covering the income tax
(,
consequences of providing food and beverages to employees. Payment for food and beverage
O
expenses that meet the IRS non-taxable criteria will be made through Accounts Payable. Payment for
a
food and beverage expenses that do not meet the IRS non-taxable criteria will be made through
E
W
Payroll and taxed at the current IRS rate.
2
General IRS Meal Reimbursement Regulations
(See following sections for specific examples)
d
Please note that reimbursement for out-of-town travel is covered by ECC 2.25.050, Travel
Authorization and Expense Reimbursement Policies
The following food and beverage expenses qualify as non-taxable under the IRS code and will be
m
L
reimbursed through Accounts Payable.
O
1. Meals consumed while traveling on city business. To qualify as travel the employee must
E
travel a distance of 40 miles or more from Edmonds and stay overnight.
2. Business meals between city employees and non -city employees that can reasonably be
expected to bring a specific business benefit to the city,
loeating in Edmonds). These meals would bpieally involve the Mayor- and business people
c
d
seeking to ifiefease business in-E^^a^ Restaurant meals with current or potential city
Q-
suppliers (vendors/contractors/consultants, etc.) would not qualify under this category.
W
3. Meal expenses directly related to and necessary for attending business meetings or
m
conventions of organizations directly related to city business. These organizations include
C
chambers of commerce, business leagues and trade or professional organizations such as the
O.
American Planning Association, American Public Works Association, etc.
E
4. Meals provided by the city that meet the following three criteria:
W
a. The meal must be brought to the employee; cash may not be given to the employee to buy
a meal.
E
b. The meal must be provided at the city's business premises. This may include temporary
work sites, such as a rented -hotel conference room, if business is conducted there. Ppblie
v
r
Q
Packet Pg. 11
2.3.a
City of Edmonds
Employee Expenses, Volunteer Recognition and Reimbursement Policy
c. The meal must be provided for the city's convenience and have a sound business
justification. Examples include:
i. Meals furnished during work hours so employees are available for emergency calls
during the meal. Evidence must be provided that an emergency occurred.
ii. Meals delivered to the office at a group meeting that spans a mealtime a ^rm the
The following food and beverage expenses are taxable under the IRS code and will be reimbursed
through Payroll.
1. Meals consumed while attending local training sessions/classes. Local training means
training that does not qualify for travel by being 40 miles or more from the city and
requiring an overnight stay.
2. Meals consumed while transporting city or non -city participants to recreation programs.
3. Meals between city employees and/or non -city employees off the city premises that
otherwise qualify for reimbursement under city policy.
4. Meals consumed while transporting and/or chaperoning city or non -city participants to city
sponsored Parks and Recreation programs or events where paid staff are required for safety
and supervision. Examples include, but are not limited to, programs or events at restaurants
for senior participants.
Claims for taxable meal reimbursements must be submitted to Payroll on an Employee
v
Reimbursement form. Meal reimbursements are included in the employee's regular paycheck.
a
Retreats/Meetings/Training
d
Couneil Retreats Executive Team Retreats/Department Retreats to determine goals and
E
m
objectives for the department/City: The reasonable cost of necessary food and beverages while
L
conducting a C4y-retreat is authorized for reimbursement. Eaeh depai4ment "^" h^'""i*^a to one
3
Fetmat peter. Non -taxable -paid through Accounts Payable
E
City Sponsored Training/Staff Meetings: the general rule is that meals and snacks are not
W
reimbursable and are to be purchased by those individuals attending. However, the City will pay
y
reasonable cost of beverages. Non-taxable under the IRS De Minimis meals category paid through
y
Accounts Payable.
Q-
k
W
Non -City Sponsored Training: The City of Edmonds considers training a necessary and
m
reasonable cost of maintaining a high level of excellence in the services we provide. The City
C
��n..d ^a will pay for reasonable trainings, conferences, and workshops for employees ^-elee
Q.
rTraining should be approved by an employee's supervisor or Department Director,
E
and in the ease of Couneil membeFs, should be approved by the Couneil P.residen-t-, prior to
LU
registration and payment for the event.. ;-- Formatted: Font: Not Italic
d
Professional Organization Sponsored Training or Seminars/Business Luncheon Meetings: The
t
City will pay the cost of meals included as part of the registration or purchased separately to be v
consumed at meetings held during a meal time. Examples include the Chamber of Commerce, Q
Packet Pg. 12
2.3.a
City of Edmonds
Employee Expenses, Volunteer Recognition and Reimbursement Policy
American Planning Association, Snohomish County Clerks & Finance Officers Association, etc.
Non-taxable per specific IRS regulation -paid through Accounts Payable
Awards/Recognition
Service Awards Ceremonies: Expenditures for reasonable refreshments served at the Mayor's
Annual City-wide Employee Awards Programs, including luncheon to recognize employees with
n 15 and 20 phF years of service and breakfast or lunch to recognize employees selected for service
awards. (Limited to one each per year) Non-taxable under the IRS De Minimis meals category -
paid through Accounts Payable.
Department Head Appreciation Luncheon: Expenditures for reasonable refreshments served at
the Annual Department Head Appreciation Luncheon for only City of Edmonds staff and Council
members. (Limited to one per year) Non-taxable under the IRS De Minimis meals categorypaid
through Accounts Payable.
Special Events
The City policy is to allow for reimbursement for the costs of reasonable refreshments for publie
events such as Open Houses, City Anniversary Celebrations, and hosting delegations from other
jurisdictions. Reimbursement requests must be aeeempanied by the publiely published fietiee of t
e
Non-taxable under the IRS De Minimis meals categorypaid through Accounts Payable.
Birthday Celebrations/ Retirement Welcoming Parties: these events are considered
private parties and as such represent an inappropriate expenditure of public funds. The cost of any
food or beverage or any incidental expenses related to these events (film, flowers, cards, etc.) are not
eligible for reimbursements.
Retirement Recognition: The City recognizes that it is sometimes appropriate to recognize and Formatted: Font: Bold
acknowledge the contribution that employees have made to the City during their career. The City will
pay the reasonable cost of food and beverages at such an event. The City may also pay a reasonable
cost for providing a service award to the retiring employee, not to exceed $4-200 in value.
Normally when an employee retires there are small items that were issued to the employee that must
be returned to the city. Examples of this are credit cards, cell phones, office keys, and IPads. Due to
the nature of IPads, unless they are essentially brand new, they have no remaining value after an
employee retires and the IPads are disposed of. If an IPad is more than a year old and has no useful
value or monetary value to the City, rather than being disposed of, any IPad with no value may be
given to the retiree.
Volunteers: It is the policy of the City of Edmonds to recognize and acknowledge the contribution
that volunteers make to the City. The City will pay the reasonable cost for providing service awards,
as well as food and beverages, at an annual recognition event..- These are non-taxable to Volunteers.
Non-taxable to Mployees if held on city premises and meals are provided paid through Accounts
v
Q
Packet Pg. 13
2.3.a
City of Edmonds
Employee Expenses, Volunteer Recognition and Reimbursement Policy
Payable. Taxable to Employees if held off city premises -employee's meal reimbursement paid
through Payroll.
Meals
Business Meals between City Employees: Meals (including snacks) between City Employees will
not normally be reimbursed. It is expected that City Business between City employees can for the
most part be conducted on City premises during normal work hours.
Working Lunches: the City recognizes that there are occasions when it may be necessary for a group
of employees to work through lunch in order to meet a deadline or to keep a group convened in order
to accomplish the task. To be considered for reimbursement as a working lunch, the meeting must
span over a three hour period which includes the group's normal lunch hour and have approval of the
Mayor. Non-taxable if the meal is provided on the citypremises for the convenience of the city -
paid through Accounts Payable
Business Meals between City Employees and Non -City Employees: the reasonable costs of
necessary meals while conducting City Business with persons other than City employees either
locally or out of town are authorized for reimbursement. Employees seeking reimbursement for meals
of a non -City person must obtain prior approval from the Mayor. The employee's meal is non-
taxable if the meal is provided on the city premises for the convenience of the city or the employee
is on out of town travel for the city —paid through Accounts Payable. The employee's meal is non-
taxable if it meets the IRS test of providing a specific business benefit to the city (normally only the
Mayor will qualify in the specific business benefit category) —paid through Accounts Payable. The
employee's meal is taxable if the meal is not related to city travel and is eaten off the citypremises
paid through Payroll. The meals for the non -city employees are paid through Accounts Payable.
Packet Pg. 14
2.4
City Council Agenda Item
Meeting Date: 08/9/2022
Monthly Financial Report
Staff Lead: Dave Turley
Department: Administrative Services
Preparer: Dave Turley
Background/History
Monthly financial report for June, 2022.
Staff Recommendation
Review financial activity and place report on Consent for following Council meeting.
Narrative
N/A
Attachments:
Jan -June 2022 P&L
June 2022 Monthly Financial Report
Finance Committee Mtg 08_09
Packet Pg. 15
2.4.a
GENERAL FUND CHANGES IN FUND BALANCE
2021 2022
2017 2018 2019 2020 2021 (Jan -June) (Jan -June)
Beginning Fund Balance 9,841,719 10,273,342 11,233,279 15,552,188 13,868,744 13,868,744 15,931,353
Revenue
Taxes
Licenses and permits
Intergovernmental
Charges for services
Fines and forfeitures
Investment earnings
Miscellaneous
Operating Revenues
Nononeratine Revenues
Transfers in
Debt proceeds
Sale of capital assets
Insurance recoveries
Total Revenue
Expenditures
General government
Public safety
Transportation
Economic environment
Mental and physical health
Culture and recreation
Debt service
Capital outlay
Operating Expenditures
Nononeratine Expenditures
Transfers out
Debt refunding
Total Expenditures
Prior Period Adjustments
Change in position
29,572,203
30,755,578
30,846,665
30,738,452
32,979,704
16,881,848
17,660,679
2,506,800
2,401,855
2,299,972
2,276,861
2,453,186
1,203,207
1,340,224
890,572
1,014,434
1,008,432
1,633,633
1,608,646
938,675
481,432
5,463,913
5,810,961
6,419,836
5,412,044
5,913,557
3,181,196
2,068,027
459,929
616,783
496,093
287,693
272,302
177,919
65,865
154,737
273,228
573,806
265,627
122,241
176,458
139,824
471,675
931,495
587,882
322,816
347,519
147,536
188,450
39,519,829 41,804,334 42,232,686 40,937,126 43,697,155 22,706,839 21,944,502
26,300 75,884 4,793,650 1,535,800 388,547 165,176 13,150
7,143 5,273 - - -
- 15,570 - 16,977 - - -
39,553,272 41,901,061 47,026,336 42,489,903 44,085,702 22,872,014 21,957,652
9,714,867
10,288,694
11,565,563
12,514,526
11,850,838
5,907,983
6,415,103
22,228,871
22,585,212
23,036,185
23,759,212
22,765,260
11,951,306
13,083,358
3,600
4,779
5,012
5,012
2,088
1,671
-
1,551,152
1,460,763
1,562,702
1,675,334
1,991,624
874,739
1,045,179
126,791
178,859
164,888
147,957
84,642
31,629
31,392
3,959,731
4,331,806
4,158,397
3,732,644
4,341,658
2,052,897
2,169,413
198,361
197,694
197,967
296,624
60,228
60,087
72,505
90,573
93,105
110,935
835,048
268,885
-
141,537
37,873,946 39,140,912 40,801,649 42,966,358 41,365,223
1,247,703 1,800,212 1,905,778 1,206,990 657,870
20,880,312 22,958,487
234,945 542,500
39,121,649 40,941,124 42,707,427 44,173,348 42,023,093 21,115,256 23,500,987
431,623 959,937 4,318,909 (1,683,445) 2,062,609 1,756,758 (1,543,336)
Ending Fund Balance 10,273,342 11,233,279 15,552,188 13,868,744 15,931,353 15,625,502 14,388,018
O
O.
2
v
c
M
c
IL
21
t
c
O
J
a
N
N
O
N
O
C
7
C
r
C
d
t
t,1
a
R:\Finance Committee\2022\Jan-June 2022 P&L 7/28/2022 Packet Pg. 16
I 2.4.b I
OF
EDP
� d
lac. 1 $9v
CITY OF EDMONDS
QUARTERLY BUDGETARY FINANCIAL REPORT
JUNE 2022
Packet Pg. 17 1
INVESTMENT PORTFOLIO SUMMARY
I 2.4.b I
City of Edmonds Investment Portfolio Detail
As of June 30, 2022
Years
Agency/ Investment Purchase to Par Market
Issuer Tvpe Price Maturitv Value Value
Energy Northwest
Bonds
Energy Northwest
Bonds
Mason & Kitsap Cnty WA
Bonds
Grant Cnty WA
Bonds
Grant Cnty WA
Bonds
Seattle WA Muni
Bonds
FHLMC
Bonds
FHLB
Bonds
First Financial - ECA
CD
Kent WA
Bonds
FNMA
Bonds
Spokane County WA
Bonds
First Financial - Waterfront Center
CD
TOTAL SECURITIES
Washington State Local Gov't Investment
Pool
Snohomish County Local Gov't Investment
Pool
TOTAL PORTFOLIO
Maturity Coupon
Date Rate
1,466,077
0.00
1,345,000
1,345,000
07/01/22
5.00%
260,748
0.00
250,000
250,000
07/01/22
2.95%
948,084
0.42
855,000
867,415
12/01/22
5.00°%
1,517,955
0.51
1,500,000
1,489,965
01/01/23
1.54%
576,332
0.51
520,000
529,048
01/01/23
5.00%
2,224,500
0.59
2,000,000
2,040,900
02/01/23
5.00%
988,678
0.81
1,000,000
979,596
04/20/23
0.38%
1,996,590
1.27
2,000,000
1,937,612
10/05/23
0.22°%
2,803,516
1.38
2,803,516
2,803,516
11/15/23
2.08%
286,648
1.42
250,000
260,980
12/01/23
5.00%
992,693
2.01
1,000,000
973,649
07/02/24
1.75%
207,260
2.42
200,000
194,528
12/01/24
2.10%
1,575,000
5.34
1,575,000
1,575,000
11/01/27
0.20%
15, 844, 079
1.28
15, 298, 516
15, 247, 209
Seattle WA Issuer Diversification
Muni, 13%
Kent WA,�
2%
Mason & First
Kitsap Cnty--,' Financial -
WA, 6% CD, 294
Spokane
Grant Cnty County
WA, 13% FHLB, WA, 1%
Energy 13%
Northwest,
10% FNMA, 7% FHLMC, 7%
18,334,716 18,334,716 Demand 1.01 %
42,793,517 42,793,517 Demand 1.28%
$ 76,426,749 $ 76,375,442
Bonds, Cash and Investment Balances Checki ng,
$10.9, 13% (in $ Millions) $5.3 , 79/c
CD's,
i�
$4.4 , 5%
County
LGIP,
$42.8, 52%
State LGIP,
$18.3, 23%
E
O
CL
d
to
C
R
C
LL
>4
z
C
O
O
N
O
C
C
LL
A
L
r
C
O
2
tV
tV
O
N
N
C
3
7
r
C
a�
E
s=
Q
1
Packet Pg. 18 1
I 2.4.b I
INVESTMENT PORTFOLIO SUMMARY
Annual Interest Income
$1,400, 000
$1,236,875
$1,200, 000
$1,000,000 $882556 947 931 $950,684
$800,000 $635,781
$600,000 476,273
$400,000
$200,000 - INV
$-
2017 2018 201 2020 2021 YTD 2022
2
Packet Pg. 19
2
GENERAL FUND SUMMARY
General Fund Revenues and Expenses (Rolling 24 months)
General Fund Revenues General Fund Expenses
10,000, 000 —
9,000,000
8,000,000 + ; ,
7,000, 000 •
6,000,000 • •
5,000,000 •
4,000, 000
3,000,000
2,000, 000
1,000, 000
July October January April July October January April
General Fund Tax Revenue (2016 through 2021)
Sales Tax Property Tax EMS Tax Other Taxes
12,000, 000
10,000, 000
8,000, 000
6,000,000
4,000, 000
2,000,000
2016 2017 2018 2019 2020 2021
General Fund Tax Revenue (2022 YTD)
7,000,000
6,500,000
6,000,000
5 797 199
5,500, 000
5 402 133
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
—
Sales Tax Property Tax EMS Tax Other Taxes
L
0
a
m
2
v
C
0
c
ii
z
c
0
L
0
m
�a
.v
C
C
ii
A
t
r
C
0
2
N
N
0
N
0
C
7
a+
a�
E
U
M
.r
Q
3
I Packet Pg. 20
I 2.4.b I
City of Edmonds, WA
Monthly Revenue Summary -General Fund
2022
General Fund
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals %
January
$ 2,486,429 $
2,486,429
$ 2,291,020
-7.86%
February
4,917,170
2,430,740
4,711,093
-4.19%
March
7,380,020
2,462,851
7,394,990
0.20%
April
10,516,012
3,135,992
10,451,247
-0.62%
May
19,357,334
8,841,322
19,394,416
0.19%
June
21,935,611
2,578,276
21,957,652
0.10%
July
24,465,539
2,529,929
August
27,084,819
2,619,280
September
29,465,113
2,380,294
October
33,512,944
4,047,830
November
42,090,496
8,577,552
December
44,640,708
2,550,212
City of Edmonds, WA
Monthly Revenue Summary -Real Estate Excise Tax
2022
Real Estate Excise Tax 1 & 2
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
%
January
$ 381,097 $
381,097
$ 377,895
-0.84%
February
611,562
230,465
620,392
1.44%
March
952,142
340,580
793,926
-16.62%
April
1,227,434
275,291
1,165,930
-5.01%
May
1,586,772
359,339
1,544,140
-2.69%
June
1,961,879
375,106
1,945,474
-0.84%
July
2,368,248
406,370
August
2,810,074
441,826
September
3,256,638
446,564
October
3,660,486
403,848
November
4,056,561
396,075
December
4,400,000
343,439
*The monthly budget forecast columns are based on a five-year average.
O
rL
d
R
C
C
LL
t
C
O
0
Q.
d
c
0
c
LL
t
C
O
2
N
N
O
N
d
C
7
7
C
t
V
r+
Q
4
Packet Pg. 21
SALES TAX SUMMARY
I 2.4.b I
Construction Trade,
$836,588
Accommodation,
$19,092
Clothing and
Accessories, $167,490
Communications,
$123,400
Wholesale Trade, —
$179,266
12,000, 000
10,000, 000
8,000,000
6,000,000
4,000,000
2,000,000
0
Sales Tax Analysis By Category
Current Period: June 2022
Year -to -Date
Total $5,402,133
Health & Automotive Repair, Business Services,
$604,914
Personal $115,946
Care, A sement & Gasoline, $15,526
$138,686 Recre tion, $35,935
Retail Food Stores,
—�MZ� $171,442
Misc Retail,
$948,811 g
Others, $107,983
Retail Automotive,
,._ $1,313,688 _,d
Manufacturing, $60,811
Eating & Drinking,
$562,555
Annual Sales Tax Revenue
Lm-- — —
7.395.114 $8,406,296 $8,452,715 $8,317,046
$10,302,518
$5,402,133
2016 2017 2018 2019% 2020 2021 YTD 2022
5
I Packet Pg. 22
I 2.4.b I
City of Edmonds, WA
Monthly Revenue Summary -Sales and Use Tax
2022
Sales and Use Tax
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 763,651
$ 763,651
$ 857,872
12.34%
February
1,704,609
940,958
1,853,000
8.71%
March
2,420,254
715,646
2,666,259
10.16%
April
3,074,639
654,384
3,469,412
12.84%
May
3,893,081
818,442
4,483,349
15.16%
June
4,672,507
779,426
5,402,133
15.62%
July
5,523,403
850,896
August
6,439,084
915,680
September
7,293,649
854,565
October
8,203,996
910,347
November
9,139,425
935,429
December
10,000,000
860,575
City of Edmonds, WA
Monthly Revenue Summary -Gas Utility Tax
2022
Gas Utility Tax
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 79,399
$ 79,399
$ 96,596
21.66%
February
164,205
84,806
96,596
-41.17%
March
246,125
81,920
305,138
23.98%
April
313,860
67,734
397,808
26.75%
May
367,416
53,556
469,966
27.91%
June
402,173
34,757
524,767
30.48%
July
429,975
27,802
August
452,332
22,357
September
472,668
20,335
October
496,035
23,367
November
534,998
38,963
December
595,000
60,002
Gas Utility Tax
700,000
600,000
500,000
400,000
300,000
200,000
100,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Current Year Budget Prior Year
*The monthly budget forecast columns are based on a five-year average.
Q
6
Packet Pg. 23
I 2.4.b I
City of Edmonds, WA
Monthly Revenue Summary -Telephone Utility Tax
2022
Telephone Utility Tax
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
53,352 $
53,352 $
43,844
-17.82%
February
96,981
43,629
66,255
-31.68%
March
143,255
46,275
130,244
-9.08%
April
192,397
49,142
175,045
-9.02%
May
232,481
40,084
208,020
-10.52%
June
277,770
45,288
250,253
-9.91%
July
321,046
43,277
August
362,710
41,663
September
400,099
37,389
October
445,363
45,264
November
482,039
36,676
December
523,000
40,961
Electric Utility Tax
Telephone Utility Tax
600,000
500,000
400,000
300,000
200,000
100,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Current Year Budget -*-- Prior Year
City of Edmonds, WA
Monthly Revenue Summary -Electric Utility Tax
2022
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
148,905 $
148,905 $
183,023
22.91%
February
312,488
163,583
377,116
20.68%
March
449,608
137,121
534,798
18.95%
April
602,286
152,678
726,969
20.70%
May
723,393
121,107
858,720
18.71%
June
824,492
101,099
993,628
20.51%
July
920,639
96,147
August
1,015,921
95,282
September
1,108,535
92,614
October
1,199,070
90,535
November
1,299,972
100,902
December
1,410,000
110,028
Electric Utility Tax
1,zsuu,uuu
1,600,000
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
-*-- Current Year Budget � Prior Year
*The monthly budget forecast columns are based on a five-year average.
E
O
rL
d
fC
U
C
cc
a
LL
t
C
O
O
!a.
d
c
c
LL
t
C
O
2
N
N
O
N
d
C
7
C
E
t
V
l4
r+
Q
Packet Pg. 24
I 2.4.b I
City of Edmonds, WA
Monthly Revenue Summary -Meter Water Sales
2022
Meter Water Sales
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 809,979
$ 809,979
$ 827,704
2.19%
February
1,383,405
573,426
1,383,308
-0.01%
March
2,213,219
829,814
2,127,271
-3.88%
April
2,744,029
530,810
2,688,719
-2.02%
May
3,542,697
798,668
3,507,398
-1.00%
June
4,167,857
625,160
4,071,843
-2.30%
July
5,138,308
970,451
August
5,986,736
848,427
September
7,133,311
1,146,575
October
7,954,825
821,514
November
8,891,706
936,881
December
9,464,783
573,077
City of Edmonds, WA
Monthly Revenue Summary -Storm Water Sales
2022
Storm Water Sales
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 426,464
$ 426,464
$ 417,730
-2.05%
February
1,352,938
926,475
1,322,856
-2.22%
March
1,779,789
426,851
1,740,623
-2.20%
April
2,159,443
379,654
2,114,167
-2.10%
May
2,586,880
427,437
2,531,673
-2.13%
June
2,966,444
379,564
2,904,040
-2.10%
July
3,385,868
419,425
August
4,311,526
925,657
September
4,738,766
427,240
October
5,118,192
379,426
November
5,545,860
427,668
December
5,911,497
365,637
Storm Water Sales
6,000,000
5,500,000
5,000,000
4,500,000
4,000,000
3,500,000
3,000,000
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Current Year Budget - Prior Year
*The monthly budget forecast columns are based on a five-year average.
Q
Packet Pg. 25
I 2.4.b I
City of Edmonds, WA
Monthly Revenue Summary-Unmeter Sewer Sales
2022
Unmeter Sewer Sales
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 863,521
$ 863,521
$ 877,046
1.57%
February
1,571,494
707,973
1,604,010
2.07%
March
2,435,565
864,071
2,451,231
0.64%
April
3,143,499
707,934
3,183,083
1.26%
May
4,009,811
866,312
4,066,458
1.41%
June
4,719,932
710,121
4,800,930
1.72%
July
5,593,564
873,631
August
6,307,925
714,362
September
7,215,145
907,220
October
7,936,868
721,723
November
8,819,637
882,769
December
9,528,089
708,452
Q
*The monthly budget forecast columns are based on a five-year average.
9
Packet Pg. 26
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -General Fund
2022
General Fund
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
5,342,528 $
5,342,528
$ 4,601,625
-13.87%
February
9,225,120
3,882,592
8,134,057
-11.83%
March
13,453,045
4,227,925
11,966,023
-11.05%
April
17,154,891
3,701,846
15,469,533
-9.82%
May
21,081,164
3,926,273
19,144,529
-9.19%
June
25,953,408
4,872,244
23,500,987
-9.45%
July
30,083,274
4,129,866
August
33,991,194
3,907,920
September
38,121,718
4,130,524
October
42,646,764
4,525,046
November
47,397,312
4,750,547
December
52,360,872
4,963,560
City of Edmonds, WA
Monthly Expenditure Report -Non -Departmental
2022
Non -Departmental
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 2,508,279
$ 2,508,279
$ 2,099,939
-16.28%
February
3,543,187
1,034,908
2,938,380
-17.07%
March
4,861,868
1,318,681
4,088,791
-15.90%
April
5,666,194
804,326
5,036,007
-11.12%
May
6,662,820
996,625
6,003,725
-9.89%
June
8,507,675
1,844,856
7,622,093
-10.41%
July
9,572,392
1,064,717
August
10,448,509
876,116
September
11,463,698
1,015,189
October
12,742,850
1,279,152
November
14,166,478
1,423,628
December
15,574,121
1,407,643
Q
*The monthly budget forecast columns are based on a five-year average.
10
Packet Pg. 27
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -City Council
2022
City Council
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
33,985 $
33,985 $
23,687
-30.30%
February
71,308
37,323
43,670
-38.76%
March
112,128
40,821
71,408
-36.32%
April
150,174
38,046
100,819
-32.87%
May
199,408
49,234
129,439
-35.09%
June
253,207
53,799
157,419
-37.83%
July
291,886
38,679
August
345,215
53,328
September
382,380
37,165
October
414,981
32,601
November
455,321
40,340
December
497,900
42,579
City of Edmonds, WA
Monthly Expenditure Report -Office of Mayor
2022
Office of Mayor
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 36,522
$ 36,522
$ 28,255
-22.63%
February
74,639
38,117
59,226
-20.65%
March
111,240
36,600
89,568
-19.48%
April
148,486
37,247
119,372
-19.61%
May
185,158
36,671
148,671
-19.71%
June
221,111
35,953
178,561
-19.24%
July
257,901
36,789
August
295,030
37,129
September
331,738
36,709
October
367,805
36,067
November
405,747
37,941
December
443,913
38,166
Office of Mayor
500,000
450,000
400,000
350,000
300,000
250,000
200,000
150,000
100,000
50,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
--"-CurrentYeaz Budget --*-PriorYeaz
*The monthly budget forecast columns are based on a five-year average.
Q
11
Packet Pg. 28
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -Human Resources
2022
Human Resources
Cumulative
Budget Forecast
Monthly
Budget Forecast
YTD
Actuals
Variance
January
$ 77,402
$ 77,402
$ 59,932
-22.57%
February
141,639
64,236
135,524
-4.32%
March
202,815
61,176
203,581
0.38%
April
266,756
63,941
270,474
1.39%
May
331,195
64,439
334,902
1.12%
June
405,872
74,678
458,397
12.94%
July
464,145
58,273
August
524,126
59,981
September
590,408
66,282
October
654,662
64,254
November
726,800
72,138
December
824,831
98,031
Municipal Court
Human Resources
900,000
800,000
700,000
600,000
500,000
400,000
300,000
200,000
100,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
--"-Current Year Budget --&-PriorYeaz
City of Edmonds, WA
Monthly Expenditure Report -Municipal Court
2022
Cumulative Monthly
Budget Forecast Budget Forecast
YTD
Actuals
Variance
January
$ 104,268
$ 104,268
$ 91,643
-12.11%
February
213,906
109,638
187,919
-12.15%
March
322,490
108,584
284,025
-11.93%
April
431,592
109,102
386,046
-10.55%
May
548,505
116,913
482,322
-12.07%
June
654,584
106,079
591,066
-9.70%
July
763,667
109,084
August
884,110
120,443
September
995,910
111,800
October
1,110,987
115,077
November
1,227,059
116,072
December
1,368,755
141,696
Municipal Court
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
--"-CurrentYeaz Budget -mF-PriorYear
*The monthly budget forecast columns are based on a five-year average.
E
O
sz
d
R
C
C
LL
t
C
O
O
sa.
d
c
c
LL
t
C
O
2
N
N
O
N
d
C
7
C
E
t
V
to
r+
Q
12
Packet Pg. 29
I 2Ab I
City of Edmonds, WA
Monthly Expenditure Report -Community Services/Economic Development
2022
Community Services/Economic Development
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
49,857 $
49,857 $
33,127
-33.56%
February
103,113
53,256
72,230
-29.95%
March
155,568
52,455
122,479
-21.27%
April
205,451
49,882
179,118
-12.82%
May
260,752
55,301
216,588
-16.94%
June
315,986
55,234
250,483
-20.73%
July
373,132
57,147
August
434,777
61,645
September
492,000
57,223
October
552,240
60,239
November
622,590
70,351
December
719,388
96,798
Community Services/Economic Development
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
-0-- Current Year Budget -0-- Prior Year
Q
*The monthly budget forecast columns are based on a five-year average.
13
Packet Pg. 30
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -Technology Rental Fund
2022
Technology Rental Fund
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
176,962 $
176,962 $
216,858
22.55%
February
334,966
158,004
287,295
-14.23%
March
484,397
149,431
502,978
3.84%
April
566,805
82,408
545,022
-3.84%
May
674,037
107,232
603,046
-10.53%
June
784,541
110,504
705,231
-10.11%
July
877,847
93,306
August
989,174
111,327
September
1,106,217
117,044
October
1,245,373
139,155
November
1,341,722
96,350
December
1,539,022
197,300
Administrative Services
Technology Rental Fund
1,600,000
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
-0-- Current Yeaz Budget -d Prior Year
City of Edmonds, WA
Monthly Expenditure Report -Administrative Services
2022
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
238,721 $
238,721
$ 217,022
-9.09%
February
399,953
161,232
380,532
-4.86%
March
563,330
163,378
547,460
-2.82%
April
729,233
165,903
722,690
-0.90%
May
896,198
166,965
901,287
0.57%
June
1,121,628
225,430
1,088,001
-3.00%
July
1,314,351
192,723
August
1,478,599
164,248
September
1,647,511
168,911
October
1,824,204
176,693
November
1,989,608
165,404
December
2,156,911
167,303
Administrative Services
1,800,000
1,600,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
-0-- Current Yeaz Budget -0-- Prior Year
*The monthly budget forecast columns are based on a five-year average.
Q
14
Packet Pg. 31
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -City Attorney
2022
City Attorney
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
80,982 $
80,982
$ 77,656
-4.11%
February
161,963
80,982
155,234
-4.16%
March
242,945
80,982
233,065
-4.07%
April
323,927
80,982
287,018
-11.39%
May
404,908
80,982
388,315
-4.10%
June
485,890
80,982
465,893
-4.12%
July
566,871
80,982
August
647,853
80,982
September
728,835
80,982
October
809,816
80,982
November
890,798
80,982
December
971,780
80,982
Police
City of Edmonds, WA
Monthly Expenditure Report -Police
2022
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
1,045,238 $
1,045,238
$ 973,358
-6.88%
February
2,105,968
1,060,730
1,945,020
-7.64%
March
3,177,596
1,071,629
3,008,075
-5.33%
April
4,236,492
1,058,896
4,001,453
-5.55%
May
5,296,298
1,059,805
5,133,192
-3.08%
June
6,428,932
1,132,634
6,213,167
-3.36%
July
7,551,012
1,122,080
August
8,579,704
1,028,692
September
9,657,485
1,077,782
October
10,845,669
1,188,184
November
12,168,634
1,322,964
December
13,375,470
1,206,836
Police
8,000,000
6,000,000
4,000,000
2,000,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
--"— Current Yeaz Budget �Prior Year
*The monthly budget forecast columns are based on a five-year average.
Q
15
Packet Pg. 32
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -Development Services
2022
Development Services
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
272,173 $
272,173
$ 309,139
13.58%
February
567,186
295,012
661,303
16.59%
March
860,247
293,062
909,669
5.75%
April
1,174,618
314,370
1,157,411
-1.46%
May
1,488,050
313,432
1,419,912
-4.58%
June
1,792,716
304,666
1,678,976
-6.34%
July
2,114,310
321,593
August
2,423,605
309,295
September
2,733,462
309,857
October
3,039,102
305,640
November
3,402,002
362,901
December
3,791,859
389,857
City of Edmonds, WA
Monthly Expenditure Report -Parks & Recreation
2022
Parks & Recreation
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
358,065 $
358,065
$ 319,222
-10.85%
February
748,023
389,958
651,988
-12.84%
March
1,136,243
388,220
1,040,803
-8.40%
April
1,535,144
398,902
1,354,932
-11.74%
May
1,941,016
405,872
1,709,318
-11.94%
June
2,369,808
428,792
2,119,385
-10.57%
July
2,835,053
465,245
August
3,347,305
512,252
September
3,871,489
524,184
October
4,291,784
420,295
November
4,690,353
398,569
December
5,125,535
435,182
Parks & Recreation
5,500,000
4,000,000
1,500,000
500,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
-*-- Current Yeaz Budget -0-- Prior Year
*The monthly budget forecast columns are based on a five-year average.
O
rL
d
fC
C
cc
a
M
t
C
O
O
!a.
d
c
c
LL
t
C
O
2
N
N
O
N
d
C
7
7
C
E
t
V
to
r+
Q
16
Packet Pg. 33
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -Public Works Administration
2022
Public Works Administration
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
49,466 $
49,466 $
22,716
-54.08%
February
100,066
50,600
46,637
-53.39%
March
150,167
50,100
71,242
-52.56%
April
201,867
51,701
94,556
-53.16%
May
252,421
50,554
117,239
-53.55%
June
303,852
51,431
140,684
-53.70%
July
355,684
51,832
August
405,471
49,786
September
455,172
49,701
October
504,185
49,013
November
567,424
63,239
December
614,113
46,689
Facilities Maintenance
Public Works Administration
700,000
600,000
500,000
400,000
300,000
200,000
100,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Current Year Budget � Prior Year
City of Edmonds, WA
Monthly Expenditure Report -Facilities Maintenance
2022
Cumulative Monthly YTD Variance
Budget Forecast Budget Forecast Actuals
January $
219,301 $
219,301
$ 109,202
-50.20%
February
456,337
237,035
369,398
-19.05%
March
723,326
266,990
562,089
-22.29%
April
964,010
240,684
782,173
-18.86%
May
1,206,775
242,765
942,003
-21.94%
June
1,404,870
198,095
1,081,995
-22.98%
July
1,647,775
242,905
August
1,934,891
287,116
September
2,271,751
336,861
October
2,655,928
384,177
November
2,962,277
306,349
December
3,425,275
462,998
Facilities Maintenance
500,000
0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
-0-- Current Yeaz Budget -0-- Prior Year
*The monthly budget forecast columns are based on a five-year average.
17
Packet Pg. 34
I 2.4.b I
City of Edmonds, WA
Monthly Expenditure Report -Engineering
2022
Engineering
Cumulative
Budget Forecast
Monthly
Budget Forecast
YTD
Actuals
Variance
%
January
$ 225,595
$ 225,595
$ 226,829
0.55%
February
452,988
227,392
457,182
0.93%
March
684,071
231,083
685,977
0.28%
April
917,956
233,885
914,235
-0.41%
May
1,175,026
257,070
1,140,813
-2.91%
June
1,412,521
237,495
1,368,545
-3.11%
July
1,660,688
248,167
August
1,900,016
239,329
September
2,131,816
231,799
October
2,366,570
234,755
November
2,602,612
236,042
December
2,845,336
242,724
O
rL
d
fC
C
cc
C
M
t
C
O
O
Q.
N
C
O
C
LL
t
C
O
2
N
N
O
N
d
C
7
C
O
E
t
V
O
r+
Q
*The monthly budget forecast columns are based on a five-year average.
18
Packet Pg. 35
I 2.4.b I
Page 1 of 1
C ITY O F IDMO NDS
REVINUES BY FUND - SUMMARY
Fund
2022 Amended
6/30/2021
6/30/2022
Amount
No.
Title
Budget
Revenues
Revenues
Remaining
%Received
001
GENERAL FUND
$ 44,640,708
$ 22,872,014 $
21,957,652
$ 22,683,056
490
009
LEOFF-MEDICAL INS. RESERVE
225,000
-
112,500
112,500
500
014
HISTORIC PRESERVATION GIFT FUND
-
2,500
-
-
04
016
BUILDING MAINTENANCE FUND
119,645
-
17,627
102,018
150
017
MARSH RESTORATION & PRESERVATION FUND
-
150
-
-
00
018
EDMONDS HOMELESSNESS RESPONSE FUND
200,000
-
200,000
-
1000
104
DRUG ENFORCEMENT FUND
167,210
1,397
901
166,309
14
Ill
STREET FUND
1,751,930
917,170
871,295
880,635
500
112
COMBINED STREET CONST/IMPROVE 1
13,684,871
1,116,918
1,655,558
12,029,313
120 p
Q
117
MUNICIPAL ARTS ACQUIS. FUND
216,701
24,688
96,554
120,147
450
!Y
118
MEMORIAL STREET TREE
-
380
-
-
04
120
HOTEL/MOTEL TAX REVENUE FUND
84,410
26,546
44,483
39,927
530
121
EMPLOYEE PARKING PERMIT FUND
26,540
10,360
12,294
14,246
460
122
YOUTH SCHOLARSHIP FUND
1,550
260
171
1,379
110 -
123
TOURISM PROMOTIONAL FUND/ARTS
29,590
9,981
15,705
13,885
530
125
REAL ESTATE EXCISE TAX 2 2
2,271,020
1,219,196
1,021,776
1,249,244
450 0
126
REAL ESTATE EXCISE TAX 1 2
2,261,030
1,211,916
1,015,115
1,245,915
127
GIFT S CAT ALOG FUND3
82,750
39,696
2,964,266
(2,881,516)
35820 p
Q.
130
CEMETERY MAINTENANCE/IMPROVEMT
182,430
124,765
111,976
70,454
610 0)
136
PARKS TRUST FUND
4,330
3,131
2,012
2,318
460
137
CEMETERY MAINTENANCE TRUST FD
43,520
31,778
23,165
20,355
530
138
SISTER CITY COMMISSION
10,290
2,695
2,687
7,603
C
260LL
140
BUSINESS IMPROVEMENT DISTRICT
79,349
55,440
55,878
23,471
700
141
AFFORDABLE AND SUPPORTIVE HOUSING FUND
65,000
32,633
24,287
40,713
370
C
142
EDMONDS RESCUE PLAN FUND
4,856,549
5,946,550
-
4,856,549
00 0
143
TREE FUND
215,330
-
245
215,085
00 CV
N
231
2012 LT GO DEBT SERVICE FUND
611,370
40,853
41,009
570,361
74 N
332
PARKS CAPITAL CONSTRUCTION FUND
3,822,685
403,147
829,172
2,993,513
220 C
411
COMBINED UTILITY OPERATION
-
5,320
82,560
(82,560)
04
421
WATER UTILITY FUND
11,018,136
4,750,644
4,802,340
6,215,796
440
422
STORM UTILITY FUND 5
7,877,897
3,518,958
3,287,736
4,590,161
420 E
423
SEWERWTP UTILITY FUND 6
/W
24,820,083
11,905,781
8,985,295
15,834,788
360 0
424
BOND RESERVE FUND
1,988,700
600,422
591,150
1,397,550
300 Q
511
EQUIPMENT RENTAL FUND
1,925,920
771,931
916,397
1,009,523
480
512
TECHNOLOGY RENTAL FUND
1,153,570
613,153
579,987
573,583
500
$ 124,438,114
$ 56,260,373 $
50,321,792
$ 74,116,322
400
Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Traffic Impact fee in March 2022.
Z REET revenues are down a total of $(4384,591) from this point in time last year.
i Differences due to a large donation received in June of 2022.
4 Differences due to Grant reimbursement received in 2022 for 2021, as well as a large Park Impact fee in March 2022.
5 2022 Utility Rate Increases are 4.5%for Water, 5%for Sewer, and 9.5%for Storm Drain.
6 Differences due primarily to WWTP partner bilings in 2021.
19
Packet Pg. 36
I 2.4.b I
Page 1 of 1
C ITY OF EDMO NDS
EXPENDITURES BY FUND - SUMMARY
Fund
2022 Amended
6/30/2021
6/30/2022
Amount
No.
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
001
GENERAL FUND
$ 52,360,872
$ 21,115,256
$ 23,500,987
$ 28,859,885
450,
009
LEOFF-MEDICAL INS. RESERVE
260,490
146,122
143,526
116,964
5501
014
HISTORIC PRESERVATION GIFT FUND
5,900
-
-
5,900
00
016
BUILDING MAINTENANCE FUND
545,000
-
17,074
527,926
30,
017
MARSH RESTORATION & PRESERVATION FUND
-
16,149
-
-
00
018
EDMONDS HOMELESSNESS RESPONSE FUND
200,000
123,581
-
200,000
00
019
EDMONDS OPIOID RESPONSE FUND
-
28,445
-
-
00
104
DRUG ENFORCEMENT FUND
45,800
-
-
45,800
00,
III
STREET FUND
2,315,780
1,105,696
1,082,668
1,233,112
470 G
112
COMBINED STREET CONST/IMPROVE
12,868,796
995,087
674,183
12,194,613
5y °
Q'
117
MUNICIPAL ARTSACQUIS. FUND
195,380
18,016
26,630
168,750
140/
120
HOTEL/MOTEL TAX REVENUE FUND
100,900
24,303
26,566
74,334
260,
121
EMPLOYEE PARKING PERMIT FUND
26,880
-
-
26,880
00, C
122
YOUTH SCHOLARSHIP FUND
3,000
-
3,000
00 L+
123
TOURISM PROMOTIONAL FUND/ARTS
28,200
-
533
27,667
20/
C
125
REAL ESTATE EXCISE TAX 2
4,589,688
160,981
921,189
3,668,499
200, O
126
REAL ESTATE EXCISE TAX 1
2,483,667
439,724
222,256
2,261,411
127
GIFTS CATALOG FUND
78,400
32,879
19,509
58,891
250/ O
Q.
130
CEMETERY MAINTENANCE/IMPROVEMT
220,561
117,703
94,544
126,017
430/
136
PARKS TRUST FUND
50,000
-
2,540
47,460
54
137
CEMETERY MAINTENANCE TRUST FUND
25,000
-
25,000
00,
eo
138
SISTER CITY COMMISSION
11,900
-
70
11,830
10/ C
140
BUSINESS IMPROVEMENT DISTRICT
87,680
20,636
31,164
56,516
LL
360/ >%
142
EDMONDS RESCUE PLAN FUND
6,077,492
-
433,332
5,644,160
70,
C
143
TREE FUND
214,800
-
-
214,800
00,
231
2012 LT GO DEBT SERVICE FUND
611,370
40,853
41,009
570,361
71, tV
N
332
PARKS CAPITAL CONSTRUCTION FUND
7,614,418
225,719
2,903,702
4,710,716
380/ N
421
WATER UTILITY FUND
11,490,988
3,602,271
3,114,209
8,376,779
274 C
422
STORM UTILITY FUND
9,619,649
2,235,061
2,167,378
7,452,271
7
230,
423
SEWER/WWTP UTILITY FUND
29,529,856
12,080,851
8,121,701
21,408,155
28°
d
424
BOND RESERVE FUND
1,988,710
600,417
589,342
1,399,368
300/ E
t
511
EQUIPMENT RENTAL FUND
1,950,371
623,977
673,957
1,276,414
350, 1U
512
TECHNOLOGY RENTAL FUND
1,539,022
519,736
705,231
833,791
460, Q
617
FIREMEN'S PENSION FUND
-
43,148
-
-
00/
$ 147,140,570
$ 44,316,612
$ 45,513,301
$1019627,269
310,
20
Packet Pg. 37
I 2Ab I
Page 1 of 3
Title
TAXES:
1 REAL PERSONAL / PROPERTY TAX
2 EMS PROPERTY TAX
3 VOTED PROPERTY TAX
4 LOCAL RETAIL SALESIUSE TAX 7
5 NATURAL GAS USE TAX
6 1/10 SALES TAX LOCAL CRIM JUST
7 ELECTRIC UTILITY TAX
8 GAS UTILITY TAX
9 SOLID WASTE UTILITY TAX
10 WATERUTILITY TAX
11 SEWER UTILITY TAX
12 ST ORMWAT ER UT ILIT Y T AX
13 T.V. CABLE UTILITY TAX
14 TELEPHONE UTILITY TAX
15 PULLTABSTAX
16 AMUSEMENT GAMES
17 LEASEHOLD EXCISE TAX
LICENSES AND PERMITS:
18 FIRE PERMITS -SPECIAL USE
19 POLICE - FINGERPRINTING
20 VENDING MACHINE/CONCESSION
21 FRANCHISE AGREEMENT -COMCAST
22 FRANCHISE FEE-EDUCATION/GOVERNMENT
23 FRANCHISE AGREEMENT-ZIPLY FIBER
24 OLYMPIC VIEW WATER DISTRICT FRANCHISE
25 GENERAL BUSINESS LICENSE
26 DEV SERV PERMIT SURCHARGE
27 RIGHT OF WAY FRANCHISE FEE
28 BUILDING STRUCTURE PERMITS
29 ANIMAL LICENSES
30 STREET AND CURB PERMIT
31 OT R NON -BUS LIC/PERMIT S
INTERGOVERNMENTAL:
32 DOJ 15-0404-0-1-754 - BULLET PROOF VEST
33 WA ASSOC OF SHERRIF'S TRAFFIC GRANT
34 HIGH VISIBILITY ENFORCEMENT
35 CORONAVIRUS RELIEF FUND 2
36 WA STATE TRAFFIC COMM GRANT
37 WASHINGTON STATE ARTS COMMISSION
38 DOC FAC ROOFING
39 STATE GRANTS- BUDGET ONLY
40 WA STATE ART COMMISSION 2021-003-CD
41 PUD PRIVILEDGE TAX
42 TRIAL COURT IMPROVEMENT
43 CJ - POPULATION
44 CRIMINAL JUSTICE -SPECIAL PROGRAMS
45 MARIJUANA EXCISE TAX DISTRIBUTION
46 DUI - CITIES
47 FIRE INS PREMIUM TAX
48 LIQUOR EXCISE TAX
49 LIQUOR BOARD PROFITS
50 INT ERLOCAL GRANTS
51 FIRST RESPONDERS FLEX FUND
52 DISCOVERY PROGRAMS TECHNOLOGY ACQ.
53 VERDANT INTERLOCAL GRANTS
C ITY O F IDMO NDS
REVENUES - GENERAL FUND
2022 Amended 6/30/2021
Budget Revenues
6/30/2022 Amount
Revenues Remaining %Received
$ 11,127,000
$ 5,748,063
$ 5,797,199
$ 5,329,801
520/
4,278,000
2,266,601
2,308,771
1,969,229
540/
500
1
27
473
501
10,000,000
4,797,214
5,402,133
4,597,867
540/
7,600
5,808
8,932
(1,332)
1180i
870,000
449,520
498,770
371,230
570i
1,410,000
987,183
993,628
416,372
700r
595,000
453,419
524,767
70,233
880/
284,000
184,535
181,436
102,564
640r
953,000
418,145
407,126
545,874
430/
894,600
449,296
395,305
499,295
440/
471,900
264,818
290,407
181,493
620/
792,000
400,616
410,719
381,281
520/
523,000
274,873
250,253
272,747
480r
55,200
38,156
38,435
16,765
700/
350
143
-
350
00/
306,000
143,456
152,773
153,227
5001
32,568,150
16,881,848
17,660,679
14,907,471
540,
250
400
100
150
400/
700
-
20
680
30/
40,000
17,560
36,271
3,729
910/
702,700
335,040
349,602
353,098
5001
41,000
19,150
18,000
23,000
440/
100,600
32,964
24,677
75,923
250/
384,000
186,343
199,970
184,030
520/
250,000
121,077
121,129
128,871
480/
63,000
43,550
51,535
11,465
820/
30,000
14,440
30,173
(173)
1010/
650,600
381,670
436,120
214,480
670/
24,000
8,388
10,938
13,062
460i
55,000
33,341
51,835
3,165
940/
20,000
9,284
9,854
10,146
490r
2,361,850
1,203,207
1,340,224
1,021,626
570,
9,000
6,464
5,237
3,763
580/
-
-
992
(992)
00/
11,100
916
718
10,382
60r
-
3,947
-
-
00/
3,448
307
(307)
00/
-
-
2,000
(2,000)
00/
-
379,270
-
-
00/
273,000
-
-
273,000
00/
-
6,000
-
-
00/
210,500
-
-
210,500
00/
16,740
8,070
10,776
5,964
640/
13,070
6,757
7,142
5,928
5501
45,600
24,120
25,386
20,214
560/
60,000
35,791
49,330
10,670
820/
4,500
3,335
3,587
914
800r
-
53,334
56,744
(56,744)
00/
261,500
146,188
152,556
108,944
580/
343,200
167,820
166,379
176,821
480/
-
27,216
-
-
00/
1,000
-
279
721
280/
550
-
-
550
00/
-
66,000
-
-
00/
1,249,760
938,675
481,432
768,328
390,
7 2022 Local Retail Sales/Use Tax revenues are $604,919 higher than 2021 revenues. Please also see pagespages 5 & 6.
21 1
Packet Pg. 38 1
2.4.b
Page 2 of 3
C TTY O F IDMO NDS
REVENUES - GENERAL FUND
2022 Amended 6/30/2021 6/30/2022 Amount
Title Budget Revenues Revenues Remaining %Received
CHARGES FOR GOODS AND SERVICES:
1 RECORD/LEGAL INSTRUMENTS
2 ATM SURCHARGE FEES
3 CREDIT CARD FEES
4 COURT RECORD SERVICES
5 D/M COURT REC SER
6 DRE REIMBURSEABLE
7 WARRANT PREPARATION FEE
8 IT TIME PAY FEE
9 MUNIC.-DIST. COURT CURR EXPEN
10 SALE MAPS & BOOKS
11 CLERKS TIME FOR SALE OF PARKING PERMITS
12 BID SUPPLIES REIMBURSEMENT
13 PHOTOCOPIES
14 POLICE DISCLOSURE REQUESTS
15 ENGINEERING FEES AND CHARGES
16 ELECTION CANDIDATE FILINGFEES
17 CUSTODIAL SERVICES (SNO-ISLE)
18 PASSPORTS AND NATURALIZATION FEES
19 POLICE SERVICES SPECIAL EVENTS
20 CAMPUS SAFETY-EDM. SCH. DIST.
21 WOODWAY-LAW PROTECTION
22 MISCELLANEOUS POLICE SERVICES
23 FIRE DISTRICT #1 STATION BILLINGS
24 LEGAL SERVICES
25 ADULT PROBATION SERVICE CHARGE
26 BOOKING FEES
27 FIRE CONSTRUCTION INSPECTION FEES
28 EMERGENCY SERVICE FEES
29 EMS TRANSPORT USER FEE
30 FLEX FUEL PAYMENTSFROM STATIONS
31 ANIMAL CONTROL SHELTER
32 ZONING/SUBDIVISION FEE
33 PLAN CHECKING FEES
34 FIRE PLAN CHECK FEES
35 PLANNING 1% INSPECTION FEE
36 S.E.P.A. REVIEW
37 CRITICAL AREA STUDY
38 GYM AND WEIGHTROOM FEES
39 PROGRAM FEES
40 TAXABLE RECREATION ACTIVITIES
41 HOLIDAY MARKET REGISTRATION FEES
42 UPTOWN EVENING MARKET FEES
43 WINTER MARKET FEES
44 BIRD FEST REGISTRATION FEES
45 INTERFUND REIMBURSEMENT -CONTRACT SVCS
$ 3,000
$ 3,250 $
2,844
$ 157
950/
600
59
109
491
180/
11,000
2,813
441
10,559
40r
150
2
1
149
10/
300
-
-
300
00/
-
168
-
-
00/
4,000
98
98
3,902
20/
1,000
340
54
946
501
50
90
103
(53)
2060/
100
-
-
100
00/
25,000
-
-
25,000
00/
600
-
-
600
00/
1,000
165
51
949
501
5,000
-
-
5,000
00/
180,000
133,491
118,548
61,452
660/
1,400
-
2,885
(1,485)
2060/
85,000
35,542
47,068
37,932
5501
10,000
-
2,628
7,372
260/
30,000
-
-
30,000
00/
14,000
-
3,169
10,831
230/
210,970
153,619
105,485
105,485
5001
-
-
25
(25)
00/
57,000
33,108
35,250
21,750
620/
1,050
309
702
348
670r
38,000
17,331
10,225
27,775
270/
3,000
599
317
2,683
110i
10,000
13,522
14,335
(4,335)
1430/
3,500
1,355
451
3,049
130/
1,007,500
465,101
486,524
520,976
480r
2,500
1,727
2,356
144
940/
100
-
-
100
00/
65,600
56,253
55,959
9,641
850r
425,000
268,787
181,346
243,654
430/
4,000
7,735
7,782
(3,782)
1950/
500
158
110
390
220/
3,000
2,960
3,700
(700)
1230/
14,000
8,800
9,330
4,670
670/
13,000
-
1,202
11,798
90/
1,011,580
272,442
377,080
634,500
370/
1,300
-
-
1,300
00/
5,000
2,820
-
5,000
00/
-
1,060
1,295
(1,295)
00/
-
-
7,310
(7,310)
00/
1,000
-
-
1,000
00/
4,011,558
1,697,495
589,245
3,422,313
1501
7,261,358
3,181,196
2,068,027
5,193,331
280i
22
Packet Pg. 39
2Ab
Page 3 of 3
CITY OF EDMO NDS
REVENUES - GENERAL FUND
2022 Amended 6/30/2021 6/30/2022 Amount
Title Budget Revenues Revenues Remaining %Received
FINES AND PENALTIES:
1 PROOF OF VEHICLE INS PENALTY
2 TRAFFIC INFRACTION PENALTIES
3 NC TRAFFIC INFRACTION
4 CRT COST FEE CODE LEG ASSESSMENT (LGA)
5 NON -TRAFFIC INFRACTION PENALTIES
6 OTHER INFRACTIONS'04
7 PARKING INFRACTION PENALTIES
8 PARK/INDDISZONE
9 DWI PENALTIES
10 DUI - DP ACCT
11 CRIM CNV FEE DUI
12 DUI - DP FEE
13 CRIMINAL TRAFFIC MISDEMEANOR 8/03
14 CRIMINAL CONVICTION FEE CT
15 CRIM CONV FEE CT
16 OTHER NON-T RAF MISDEMEANOR PEN
17 OTHER NON TRAFFIC MISD. 8/03
18 COURT DV PENALTY ASSESSMENT
19 CRIMINAL CONVICTION FEE CN
20 CRIM CONV FEE CN
21 PUBLIC DEFENSE RECOUPMENT
22 BANK CHARGE FOR CONV. DEFENDANT
23 COURT COST RECOUPMENT
24 BUS. LICENSE PERMIT PENALTY
25 MISC FINES AND PENALTIES
$ 2,000 $
1,521 $
961 $
1,039
480/
230,000
104,405
31,310
198,690
140/
18,000
6,036
2,104
15,896
120/
10,000
7,884
2,036
7,964
200/
1,000
203
-
1,000
00/
1,500
913
298
1,202
200/
100,000
31,322
8,152
91,848
80/
2,000
250
114
1,886
60/
7,000
3,996
1,840
5,160
260/
300
73
47
253
160/
100
59
14
86
140/
1,500
1,034
718
782
480/
25,000
9,044
5,209
19,791
210/
2,000
1,098
759
1,241
380/
700
53
74
626
110/
100
12
-
100
00/
10,000
764
8,383
1,617
840/
800
115
27
773
30/
1,000
130
225
775
220/
200
64
-
200
00/
8,000
3,112
1,931
6,069
240/
14,000
4,598
1,464
12,536
100/
3,000
1,047
147
2,853
50/
10,100
-
50
10,050
00/
150
187
-
150
00/
448,450
177,919
65,865
382,585
150,
F
O
Q
d
C
to
C
M
21
s
C
O
2
MISCELLANEOUS:
26 INVESTMENT INTEREST
270,390
167,505
132,806
137,584
490/ p,
27 INTEREST ON COUNTY TAXES
13,340
4,169
4,173
9,167
310/
28 INTEREST - COURT COLLECTIONS
10,180
4,784
2,845
7,335
280/
29 SPACE/FACILITIES RENTALS
153,000
31,377
70,576
82,424
460/ v
30 BRACKET ROOM RENTAL
2,100
-
-
2,100
00/ C
31 LEASESLONGTERM
205,000
96,605
103,112
101,888
50°1
32 DONATION/CONTRIBUTION
2,500
-
239
2,261
100/ jL
33 PARKS DONATIONS
3,500
-
4,800
(1,300)
1370/ >,
34 BIRD FEST CONTRIBUTIONS
1,500
500
515
985
340/
35 POLICE CONTRIBUTIONS FROM PRIV SOURCES
5,000
3,503
249
4,751
50/ C
36 SALE OF JUNK/SALVAGE
300
130
76
224
250/ 0
37 SALES OF UNCLAIM PROPERTY
3,800
3,340
1,761
2,039
460/ N
38 CONFISCATED AND FORFEITED PROPERTY
2,000
-
-
2,000
00/ N
39 OT HER JUDGEMENT /SET T LEMENT
2,000
102
-
2,000
00/ N
40 POLICE JUDGMENT S✓RESTITUTION
200
50
30
170
150/ d
41 CASHIERS OVERAGES/SHORTAGES
-
19
100
(100)
00/ 7
42 OTHER MISCREVENUES
41,180
4,722
911
40,269
20/
43 SMALL OVERPAYMENT
100
49
21
79
210/
44 NSF FEES- PARKS& REC
100
30
30
70
300/ G1
45 NSF FEES - MUNICIPAL COURT
150
-
-
150
0°/ t
46 NSF FEES - POLICE
-
30
-
-
00/ c�
47 NSF FEES - DEVELOPMENT SERVICES
-
-
60
(60)
00/
48 US BANK REBATE
8,500
7,079
5,970
2,530
700/ Q
724,840
323,994
328,274
3969567
45°r
TRANSFERS -IN:
49 OPERATING TRANSFER IN
-
28,445
-
-
00/
50 INTERFUND TRANSFER FROM FUND 018
-
123,581
-
-
00/
51 TRANSFER FROM FUND 127
26,300
13,150
13,150
13,150
500/
269300
165,176
139150
139150
500/
TO TAL GENERAL FUND REVENUE
$ 44,640,708
$ 22,872,014
$ 21,957,652
$ 22,683,056
490/
23
Packet Pg. 40
I 2.4.b I
Page 1 of 6
CITY OF EDMONDS
EXPENDITURES BY FUND - DETAIL
2022 Amended
6/30/2021
6/30/2022
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
GENERAL FUND EXPENDITURES (001)
1 SALARIES AND WAGES
$ 19,196,413
$ 8,528,330
$ 8,658,715
$ 10,537,698
45a/a
2 OVERTIME
594,080
284,859
542,414
51,666
910/0
3 HOLIDAY BUY BACK
294,001
3,558
10,798
283,203
4a/c
4 BENEFITS
6,820,049
3,202,942
3,219,831
3,600,218
470/a
5 UNIFORMS
119,151
34,831
44,036
75,115
370%
6 PENSION AND DISABILITY PAYMENTS
70,944
-
41,550
29,395
590/a
7 SUPPLIES
481,165
210,207
218,203
262,962
45%
8 FUEL CONSUMED
-
17
-
-
Oa/a
9 SMALL EQUIPMENT
204,019
81,188
78,358
125,661
380/c
10 PROFESSIONAL SERVICES
17,411,043
6,395,092
7,456,557
9,954,486
43ON
11 COMMUNICATIONS
171,235
80,818
71,497
99,738
420/c
12 TRAVEL
81,155
11,152
30,075
51,080
37ON
13 EXCISE TAXES
16,500
10,686
14,225
2,275
86ON
14 RENTAL/LEASE
2,091,693
759,238
1,013,259
1,078,434
48%
15 INSURANCE
503,161
405,121
503,160
1
100a/o
16 UTILITIES
529,462
247,810
272,347
257,115
51ON
17 REPAIRS& MAINTENANCE
1,090,350
264,722
244,927
845,423
22a/a
18 MISCELLANEOUS
652,023
249,653
274,495
377,528
42a/a
19 INTERGOVERNMENTAL PAYMENTS
50,000
50,000
50,000
-
100%
20 BUILDINGS
-
-
45,195
(45,195)
0%
21 INTERFUND SUBSIDIES
1,385,000
234,945
542,500
842,500
39%
22 MACHINERY/EQUIPMENT
-
-
96,343
(96,343)
00/0
23 CONSTRUCTION PROJECTS
270,180
-
270,180
00/0
24 GENERAL OBLIGATION BOND PRINCIPAL
55,170
-
-
55,170
0%
25 INTEREST ON LONG-TERM EXTERNAL DEBT
4,790
60,087
72,294
(67,504)
1509%
26 DEBT ISSUE COSTS
268,788
-
-
268,788
0%
27 OTHER INTEREST & DEBT SERVICE COSTS
500
212
288
42%
52,3 0,872
21,115,256
$
23,500,987
28,859,885 450a
LEOFF-MEDICAL INS. RESERVE(009)
28 BENEFITS
$
-
$
89,347
$
86,911
$
(86,911) 00/0
29 PENSION AND DISABILITY PAYMENTS
252,990
56,775
42,426
210,564 17%
30 PROFESSIONAL SERVICES
7,000
-
13,704
(6,704) 196%
31 MISCELLANEOUS
500
-
485
15 970%
260,490
146,122
143,526
116,964 55a/a
HISTORIC PRESERVATION GIFT FUND (014)
32 SUPPLIES
$
100
$
$
$
100 Oa/a
33 PROFESSIONAL SERVICES
200
200 0%
34 MISCELLANEOUS
5,600
5,600 00/0
5,900
-S
5,900 0%
BUILDING MAINTENANCE FUND (016)
35 PROFESSIONAL SERVICES
$
195,000
$
$
450
$
194,550 00/0
36 REPAIR&MAINTENANCE
150,000
16,072
133,928 110/0
37 MACHINERY/EQUIPMENT
90,000
552
89,448 10/0
38 CONSTRUCTION PROJECTS
110,000
-
110,000 0%
545,000
17,074
527,926 3%
MARSH RESTORATION & PRESERVATION (017)
39 PROFESSIONAL SERVICES
$
-
$
16,149
$
-
$
- 00/0
-
16,149
-
- 0%
EDMONDS HOMELESSNESS RESPONSEFUND (018)
40 PROFESSIONAL SERVICES
$
200,000
$
-
$
-
$
200,000 0%
41 INTERFUND SUBSIDIES
-
123,581
- Oa/o
200,000
123,581
200,000 0%
EDMONDS OPIOED RESPONSEFUND (019)
42 INTERFUND SUBSIDIES
$
$
28,445
$
$
- Oa/a
-
28,445
- 0%
DRUG INFO RCEMENTFUND (104)
43 PROFESSIONAL SERVICES
$
45,000
$
$
$
45,000 00/0
44 REPAIR/MAINT
800
800 0%
45,800
45,800 00/0
Q
24
Packet Pg. 41
Page 2 of 6
C ITY O F EDMO NDS
EXPENDITURES BY FUND - DETAIL
2022 Amended
6/30/2021
6/30/2022
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
STREETFUND (111)
1 SALARIES AND WAGES
$ 749,110
$ 372,872
$ 349,036
$ 400,074
47%
2 OVERTIME
38,400
21,363
18,101
20,299
47%
3 BENEFITS
347,919
183,700
170,959
176,960
49%
4 UNIFORMS
6,000
5,432
3,912
2,088
65%
5 SUPPLIES
263,000
100,566
54,702
208,298
21%
6 SMALL EQUIPMENT
20,000
770
985
19,015
5%
7 PROFESSIONAL SERVICES
23,210
5,572
10,200
13,010
44%
8 COMMUNICATIONS
4,500
3,015
3,097
1,403
69%
9 TRAVEL
1,000
-
-
1,000
0%
10 RENTAL/LEASE
290,150
122,800
144,207
145,943
50%
11 INSURANCE
184,111
148,533
184,111
0
100%
12 UTILITIES
273,730
120,183
110,454
163,276
40%
13 REPAIRS& MAINTENANCE
72,000
10,114
21,167
50,833
29%
14 MISCELLANEOUS
8,000
10,557
11,552
(3,552)
144%
15 MACHINERY/EQUIPMENT
30,000
-
-
30,000
0%
16 GENERAL OBLIGATION BOND PRINCIPAL
4,270
-
-
4,270
0%
17INTEREST
380
220
185
195
49%
$
2,315,780
$
1,105,696
$ 1,082,668
$
1,233,112
47%
COMBINED STREETCONST/IMPROVE(112)
18 PROFESSIONAL SERVICES
$
3,159,560
$
520,208
$ 237,716
$
2,921,844
8%
19 REPAIR & MAINTENANCE
1,508,270
947
22,408
1,485,862
1%
20 INTERFUND SUBSIDIES
108,975
39,925
-
108,975
0%
21 LAND
-
(842)
69,759
(69,759)
0%
22 CONSTRUCTION PROJECTS
8,018,521
361,056
270,868
7,747,653
3%
23 INTERGOVERNMENTAL LOANS
72,220
72,201
72,201
19
100%
24 INTEREST
1,250
1,591
1,230
20
98%
$
12,868,796
$
995,087
$ 674,183
$
12,194,613
5%
MUNICIPAL ARTS ACQUIS. FUND (117)
25 SUPPLIES
$
4,700
$
265
$ 892
$
3,808
19%
26 SMALL EQUIPMENT
1,700
-
-
1,700
0%
27 PROFESSIONAL SERVICES
180,000
16,253
24,529
155,471
14%
28 TRAVEL
80
-
-
80
0%
29 RENTAL/LEASE
2,000
-
2,000
0%
30 REPAIRS & MAINTENANCE
300
-
-
300
0%
31 MISCELLANEOUS
6,600
1,498
1,209
5,391
18%
$
195,380
$
18,016
$ 26,630
$
168,750
14%
HO TEL/MO TEL TAX REV NUE FUND (120)
32 PROFESSIONAL SERVICES
$
95,900
$
22,303
$ 24,566
$
71,334
26%
33 MISCELLANEOUS
1,000
-
-
1,000
0%
34 INTERFUND SUBSIDIES
4,000
2,000
2,000
2,000
50%
$
100,900
$
24,303
$ 26,566
$
74,334
26%
EMPLO YEE PARKING PERMIT FUND (121)
35 SUPPLIES
$
1,790
$
-
$ -
$
1,790
0%
36 PROFESSIONAL SERVICES
25,090
-
25,090
0%
$
26,880
$
$ -
$
26,880
0%
YOUTH SCHOLARSHIP FUND (122)
37 MISCELLANEOUS
$
3,000
$
$
$
3,000
0%
$
3,000
$
$
$
3,000
0%
TO URISM PRO MO TIO NAL FUND/ARTS (123)
38 PROFESSIONAL SERVICES
$
28,200
$
$ 533
$
27,667
2%
$
28,200
$
$ 533
$
27,667
2%
25
Packet Pg. 42
I 2Ab I
Page 3 of 6
C ITY O F EDMO NDS
EXPENDITURES BY FUND - DETAIL
2022 Amended
6/30/2021
6/30/2022
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
REAL ESTATE EXCISE TAX (125)
SUPPLIES
$ 21,000
$ 28,636
$ 11,221
$ 9,779
53%
PROFESSIONAL SERVICES
469,320
73,961
211,627
257,693
450/Q
REPAIRS& MAINTENANCE
668,258
12,991
63,167
605,091
90/0
INTERFUND SUBSIDIES
2,534
-
-
2,534
00/0
CONSTRUCTION PROJECTS
3,428,576
45,393
635,174
2,793,402
190/0
$ 4,589,688
$ 160,981
$ 921,189
$ 3,668,499
200/c
REAL ESTATE EXCISE TAXI (126)
6 PROFESSIONAL SERVICES
7 REPAIRS& MAINTENANCE
8 INTERFUND SUBSIDIES
9 CONSTRUCTION PROJECTS
10 GENERAL OBLIGATION BONDS
11 INTEREST
12 OTHER INTEREST & DEBT SERVICE COSTS
GIFTS CATALOG FUND (127)
13 SUPPLIES
14 PROFESSIONAL SERVICES
15 MISCELLANEOUS
16 INTERFUND SUBSIDIES
CEMETERY MAINTENANCEIIMPROVEMENT(130)
17 SALARIES AND WAGES
18 OVERTIME
19 BENEFITS
20 UNIFORMS
21 SUPPLIES
22 SUPPLIES PURCHASED FOR INVENTORY/RESALE
23 PROFESSIONAL SERVICES
24 COMMUNICATIONS
25 TRAVEL
26 RENTAL/LEASE
27 UTILITIES
28 REPAIRS &MAINTENANCE
29 MISCELLANEOUS
PARKS TRUSTFUND (136)
30 PROFESSIONAL SERVICES
CEMETERY MAINTENANCE TRUST FUND (137)
31 SMALL EQUIPMENT
SISTER CITY COMMISSION (138)
32 SUPPLIES
33 TRAVEL
34 MISCELLANEOUS
BUSINESS IMPROVEMENTDISTRICTFUND (140)
35 SUPPLIES
36 PROFESSIONAL SERVICES
37 MISCELLANEOUS
EDMONDS RESCUEPLAN FUND (142)
38 PROFESSIONAL SERVICES
TREE FUND (143)
39 SUPPLIES
40 PROFESSIONAL SERVICES
41 LAND
2012 LTGO DEBTSERVIC FUND (231)
42 GENERAL OBLIGATION BOND
43 INTEREST
$ 673,827 $
190,410 $
43,869 $
629,958
70/c
878,353
14,850
15,081
863,272
20/c
144,970
11,863
10,138
134,833
7%
526,057
221,320
97,473
428,584
19%
149,820
-
-
149,820
0%
110,640
1,282
55,314
55,326
50%
-
-
380
(380)
0%
$ 2,483,667 $
439,724 $
222,256 $
2,261,411
9%
$ 45,000 $ 19,729 $ 6,359 $ 38,641 14%
6,500 - - 6,500 0%
600 - - 600 0%
26,300 13,150 13,150 13,150 50%
$ 78,400 $ 32,879 $ 19,509 $ 58,891 25%
$ 119,837 $
47,668 $
49,325 $
70,512
41%
3,500
249
715
2,785
20%
41,069
19,876
19,494
21,575
47%
1,000
-
-
1,000
0%
7,000
485
520
6,480
7%
20,000
15,766
10,777
9,223
54%
4,200
800
1,150
3,050
27%
1,700
842
860
840
51%
500
-
-
500
0%
11,690
8,325
5,874
5,816
50%
5,565
1,915
1,884
3,681
34%
500
19,211
-
500
0°/a
4,000
2,567
3,946
54
99%
$ 220,561 $
117,703 $
94,544 $
126,017
43%
$ 50,000 $ $ 2,540 $ 47,460 5%
$ 50,000 $ $ 2,540 $ 47,460 5%
$ 25,000 $ $ $ 25,000 0%
$ 25,000 $ $ $ 25,000 00
$ 1,500 $ $ - $ 1,500 0%
4,500 - 4,500 0%
5,900 70 5,830 1%
$ 11,900 $ $ 70 $ 11,830 1%
$ 4,050 $
372 $
5,335 $
(1,285)
132%
77,535
19,274
25,090
52,445
32%
6,095
990
738
5,357
12%
87,680
20,636
31,164
56,516
36%
$ 6,077,492 $ $ 433,332 $ 5,644,160 7%
6,077,492 433,332 5,644,160 7%
$ 1,000 $ $ - $ 1,000 0%
14,800 - 14,800 0%
199,000 - 199,000 0%
214,800 - 214,800 0%
$ 550,000 $ - $ - $ 550,000 0%
61,370 40,853 41,009 20,361 67%
$ 611,370 $ 40,853 $ 41,009 $ 570,361 7%
O
Q
d
2
C
to
c
U-
t
r
C
O
O
Q.
N
Ta
Z
C
ev
C
E
t
r�
C
O
2
N
N
O
N
d
C
7
C
d
E
t
V
.r
Q
26
Packet Pg. 43
I 2.4.b I
Page 4 of 6
CITY OF EDMO NDS
EXPENDITURES BY FUND - DETAIL
2022 Amended
6/30/2021
6/30/2022
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
PARKS CONSTRUCTION FUND (332)
1 PROFESSIONAL SERVICES
$ 95,832
$ 121,636
$ 221,208
$ (125,376)
231%
2 INTERFUND SUBSIDIES
63,000
-
62,656
344
990/0
3 CONSTRUCTION PROJECTS
7,357,188
-
26,059
7,331,129
0%
4 INTEREST
-
104,083
2,593,779
(2,593,779)
0%
5 DEBT ISSUE COSTS
98,398
-
-
98,398
0%
$ 7,614,418
$ 225,719
$ 2,903,702
$ 4,710,716
38%
WATER FUND (421)
6 SALARIES AND WAGES
7 OVERTIME
8 BENEFIT S
9 UNIFORMS
10 SUPPLIES
11 WATER PURCHASED FOR RESALE
12 SUPPLIES PURCHASED FOR INVENTORY/RESALE
13 SMALL EQUIPMENT
14 PROFESSIONAL SERVICES
15 COMMUNICATIONS
16 TRAVEL
17 EXCISE TAXES
18 RENTAL/LEASE
19INSURANCE
20 UTILITIES
21 REPAIRS& MAINTENANCE
22 MISCELLANEOUS
23 INTERFUND SUBSIDIES
24 MACHINERY/EQUIPMENT
25 CONSTRUCTION PROJECTS
26 GENERAL OBLIGATION BONDS
27 REVENUE BONDS
28 INTERGOVERNMENTAL LOANS
29 INTEREST
30 OTHER INTEREST & DEBT SERVICE COSTS
STORM FUND (422)
31 SALARIES AND WAGES
32 OVERTIME
33 BENEFITS
34 UNIFORMS
35 SUPPLIES
36 SMALL EQUIPMENT
37 PROFESSIONAL SERVICES
38 COMMUNICATIONS
39 TRAVEL
40 EXCISE TAXES
41 RENTAL/LEASE
42INSURANCE
43 UTILITES
44 REPAIR & MAINTENANCE
45 MISCELLANEOUS
46 INTERFUND SUBSIDIES
47 CONSTRUCTION PROJECTS
48 GENERAL OBLIGATION BONDS
49 REVENUE BONDS
50 INTERGOVERNMENTAL LOANS
51 INTEREST
52 OTHER INTEREST & DEBT SERVICE COSTS
$
842,096
$
335,349
$
381,385
$
460,711
45%
24,000
10,395
6,804
17,196
28%
330,100
144,025
160,455
169,645
49%
4,000
2,691
2,659
1,341
66%
150,000
39,524
63,413
86,587
42%
2,170,000
574,330
699,886
1,470,114
32%
170,000
110,579
83,769
86,231
49%
11,000
3,917
2,692
8,308
2 4 % Q
2,237,439
1,117,586
319,295
1,918,144
14% d
30,000
13,920
15,324
14,676
5 1 %
200
-
-
200
0% cC
1,649,700
642,514
629,628
1,020,072
38%
152,590
61,436
75,484
77,106
49% cp
122,359
98,196
122,359
(0)
100%
35,000
15,055
17,087
17,913
49% iL
176,130
11,030
21,230
154,900
12%
123,600
91,901
99,973
23,627
81%
645,370
198,136
194,533
450,837
30% p
10,000
-
-
10,000
0% 2
1,998,334
7,513
87,212
1,911,122
4% .�
2,870
-
-
2,870
0% G
399,780
-
-
399,780
0% Q.
25,840
25,839
25,839
1
100% 0
180,580
98,336
104,805
75,775
58%
378
(378)
0% 0
$
11,490,988
$
3,602,271
$
3,114,209
$
8,376,779
27%
ev
C
$
734,284
$
348,704
$
384,271
$
350,013
52% jL
26,000
13,945
9,824
16,176
38% a,
294,767
153,422
159,458
135,309
54% t
6,500
4,555
5,543
957
85% C
46,000
22,686
28,774
17,226
63% 0
2
4,000
304
985
3,015
25%
3,481,263
801,072
412,052
3,069,211
12% N
3,200
2,634
2,660
540
8 3 % N
4,300
150
1,982
2,318
46% d
470,100
308,155
337,572
132,528
72%
267,150
132,220
131,662
135,488
49%
82,335
66,228
82,335
(0)
100%:
10,500
7,047
7,853
2,647
75% CD
67,130
19,629
11,852
55,278
18% E
232,300
133,058
110,513
121,787
48% tl
297,787
76,327
74,810
222,977
25% ca
3,137,333
32,679
281,617
2,855,716
9%
Q
104,540
-
-
104,540
0%
195,390
-
-
195,390
0%
53,590
53,576
61,590
(8,000)
115%
101,180
58,672
61,859
39,321
61%
-
-
165
(165)
0%
$
9,619,649
$
2,235,061
$
2,167,378
$
7,452,271
23%
27
Packet Pg. 44
I 2.4.b I
Page 5 of 6
CITY OF EDMO NDS
EXPENDITURES BY FUND - DETAIL
2022 Amended
6/30/2021
6/30/2022
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
SEWER FUND (423)
1 SALARIES AND WAGES
$ 2,090,461
$ 879,906
$ 897,697
$ 1,192,764
430%
2 OVERTIME
95,000
65,078
70,432
24,568
740/c
3 BENEFITS
847,408
391,443
359,571
487,837
420%
4 UNIFORMS
9,500
8,011
7,399
2,101
78°/a
5 SUPPLIES
421,000
208,428
155,544
265,456
37°/a
6 FUEL CONSUMED
60,000
50,107
-
60,000
0%
7 SUPPLIES PURCHASED FOR INV OR RESALE
4,000
-
-
4,000
00/0
8 SMALL EQUIPMENT
35,000
74,469
99,144
(64,144)
283°/a
9 PROFESSIONAL SERVICES
2,315,884
2,198,972
1,124,702
1,191,182
490/c
10 COMMUNICATIONS
43,000
19,849
22,230
20,770
520/c
11 TRAVEL
5,000
1,919
-
5,000
00/0
12 EXCISE TAXES
978,000
548,220
505,350
472,650
52°/a
13 RENTAL/LEASE
317,410
189,365
160,257
157,153
50°/a
14 INSURANCE
202,407
162,851
203,936
(1,529)
101%
15 UTILITIES
1,532,060
659,985
1,181,279
350,781
77%
16 REPAIR & MAINTENANCE
790,630
217,087
492,934
297,696
62%
17 MISCELLANEOUS
126,350
-
68,126
58,224
54%
18 MACHINERY/EQUIPMENT
-
72,232
122,258
(122,258)
0%
19 INTERFUND SUBSIDIES
6,388,519
1,953,015
319,999
6,068,520
5%
20 CONSTRUCTION PROJECTS
12,520,297
4,018,210
1,989,039
10,531,258
16%
21 GENERAL OBLIGATION BONDS
126,500
-
-
126,500
0%
22 REVENUE BONDS
89,840
-
-
89,840
0%
23 INTERGOVERNMENTAL LOANS
174,610
158,667
159,017
15,593
91%
24 INTEREST
356,980
199,266
179,830
177,150
50%
25 DEBT ISSUE COSTS
-
1,518
-
-
0%
26 OTHER INTEREST & DEBT SERVICE COSTS
-
2 252
2 959
(2 959)
0%
$ 29,529,856 $ 12,080,851 $ 8,121,701 $ 21,408,155 28%
BOND RESERVEFUND (424)
27 REVENUE BONDS $ 810,010 $ - $ - $ 810,010 0%
28 INTEREST 1,178,700 600,417 589,342 589,358 50%
$ 1,988,710 $ 600,417 $ 589,342 $ 1,399,368 3 0 %
Q
28
Packet Pg. 45
I 2.4.b I
Page 6 of 6
C ITY O F EDMO NDS
EXPENDITURES BY FUND - DETAIL
2022 Amended
6/30/2021
6/30/2022
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
EQ UIPNIENT RENTAL FUND (511)
1 SALARIES AND WAGES
$ 275,712
$ 136,488
$ 168,065
$ 107,647
61 ON
2 OVERTIME
2,000
1,573
222
1,778
110/0
3 BENEFITS
112,077
57,574
55,921
56,156
50%
4 UNIFORMS
1,500
1,022
838
662
56%
5 SUPPLIES
120,000
31,054
57,956
62,044
48%
6 FUEL CONSUMED
1,000
-
-
1,000
0%
7 SUPPLIES PURCHASED FOR INVENTORY/RESALE
268,000
101,031
181,762
86,238
68%
8 SMALL EQUIPMENT
58,000
5,979
2,282
55,718
4%
9 PROFESSIONAL SERVICES
46,750
684
752
45,998
2%
10 COMMUNICATIONS
3,000
1,095
1,088
1,912
36%
11 TRAVEL
1,000
-
-
1,000
0%
12 RENTAL/LEASE
11,160
6,198
5,184
5,976
46%
13INSURANCE
49,172
39,334
51,903
(2,731)
106%
14 UTILITIES
14,000
8,983
10,912
3,088
78%
15 REPAIRS& MAINTENANCE
60,000
8,734
14,224
45,776
24%
16 MISCELLANEOUS
12,000
7,723
5,139
6,861
43%
17 MACHINERY/EQUIPMENT
915,000
216,503
117,710
797,290
13%
$ 1,950,371
$ 623,977
$ 673,957
$ 1,276,414
350/c
TEC HNO LO GY RENTAL FUND (512)
18 SALARIES AND WAGES
$
442,074
$
154,630
$
145,073
$
297,001
33%
19 OVERTIME
2,000
1,583
169
1,831
8%
20 BENEFITS
159,538
52,627
57,164
102,374
36%
21 SUPPLIES
5,000
3,012
4,196
804
84%
22 SMALL EQUIPMENT
357,900
10,575
22,268
335,632
6%
23 PROFESSIONAL SERVICES
61,860
20,352
11,138
50,722
18%
24 COMMUNICATIONS
58,770
39,408
38,625
20,145
66%
25 TRAVEL
1,500
-
-
1,500
0%
26 RENTAL/LEASE
7,460
2,200
2,230
5,230
30%
27 REPAIRS & MAINTENANCE
381,920
234,196
397,181
(15,261)
104%
28 MISCELLANEOUS
5,000
1,153
841
4,159
17%
29 MACHINERY/EQUIPMENT
56,000
-
26,346
29,654
47%
$
1,539,022
$
519,736
$
705,231
$
833,791
46%
FIREMAN'S PENSION FUND (617)
30 BENEFITS
$
$
12,911
$
-
$
-
0%
31 PENSION AND DISABILITY PAYMENTS
30,237
-
0%
$
-
$
43,148
$
$
-
0%
TOTAL EXPENDITURE ALL FUNDS
$
147,140,570
$
44,316,612
$
45,513,301
$
101,627,269
317N
Q
29
Packet Pg. 46
2Ab
Page 1 of 1
C ITY O F IDMO NDS
EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY
2022 Amended 6/30/2021 6/30/2022 Amount
Title Budget Expenditures Expenditures Remaining %Spent
CITY COUNCIL
OFFICE OF MAYOR
HUMAN RESOURCES
MUNICIPAL COURT
CITY CLERK
ADMINISTRATIVE SERVICES
CITY ATTORNEY
NON -DEPARTMENTAL
POLICE SERVICES
SATELLITE OFFICE
COMMUNITY SERVICES✓ECONOMIC DEV
DEVELOPMENT SERVICES
HUMAN SERVICES PROGRAM
PARKS & RECREATION
PUBLIC WORKS
FACILITIES MAINTENANCE
Title
$ 497,900
$ 164,613
$ 157,419
$ 340,481
32%
443,913
166,677
178,561
265,352
40%
824,831
368,323
458,397
366,434
56%
1,368,755
535,746
591,066
777,689
43%
-
351,029
-
-
0%
2,156,911
625,371
1,088,001
1,068,910
50%
971,780
404,226
465,893
505,887
48%
15,574,121
6,412,264
7,622,093
7,952,028
49%
Q
13,375,470
5,731,600
6,213,167
7,162,303
46%
d
is
166,576
-
37,314
129,262
C
719,388
263,632
250,483
468,905
35%
3,791,859
1,471,283
1,678,976
2,112,883
44%
459,109
27,733
49,010
410,099
11%
5,125,535
2,002,869
2,119,385
3,006,150
41%
O
3,459,449
1,600,266
1,509,229
1,950,220
44%
r
O
3,425,275
989,625
1,081,995
2,343,280
32%
N
$ 52,360,872
$ 21,115,256
$ 23,500,987
$ 28,859,885
45%
ca
Z
C
O
C
LL
CITY OF E DMO NDS
t
EXPENDITURES - UTILITY- BY FUND
IN SUMMARY
O
2022 Amended
6/30/2021
6/30/2022
Amount
2
Budget
Expenditures
Expenditures
Remaining
%Spent
N
^
WATER UTILITYFUND $ 11,490,988 $
3,602,271 $
3,114,209 $
8,376,779
27%
N
STORM UTILITY FUND 9,619,649
2,235,061
2,167,378
7,452,271
23%
G1
=
SEWER/WWTP UTILITY FUND 29,529,856
12,080,851
8,121,701
21,408,155
28%
BOND RESERVE FUND 1,988,710
600,417
589,342
1,399,368
30%
O
t
$ 52,629,203 $
18,518,601 $
13,992,630 $
38,636,573
27%
R
w
Q
30
Packet Pg. 47
I 2Ab I
Page 1 of 2
C ITY O F EDMO NDS
EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL
Title
2022 Amended
Budget
6/30/2021
Expenditures
6/30/2022
Expenditures
Amount
Remaining
%Spent
CPIY COUNCIL
SALARIES AND WAGES
$
204,132
$
100,010
$
88,197
$
115,935
43%
BENEFITS
121,868
52,262
47,038
74,830
39%
SUPPLIES
2,000
1,708
1,069
931
53%
SERVICES
169,900
10,632
21,116
148,784
12%
$
497,900
$
164,613
$
157,419
$
340,481
32%
O FFIC E O F MAYO R
SALARIES AND WAGES
$
232,296
$
114,747
$
124,292
$
108,004
54%
BENEFITS
81,787
42,250
42,870
38,917
52%
SUPPLIES
1,500
311
1,643
(143)
110%
SERVICES
128,330
9,369
9,755
118,575
8%
$
443,913
$
166,677
$
178,561
$
265,352
40%
HUMAN RESOURCES
_
SALARIES AND WAGES
$
398,299
$
201,759
$
234,176
$
164,123
59%
O
Q
BENEFITS
142,526
76,531
80,361
62,165
56%
SUPPLIES
13,600
896
701
12,899
5%
SERVICES
270,406
89,138
143,158
127,248
53%
2
v
$
824,831
$
368,323
$
458,397
$
366,434
56%
r-
MUNICIPAL C O URT
C
SALARIES AND WAGES
$
910,606
$
337,607
$
379,034
$
531,572
42%
LL
BENEFITS
217,654
113,230
116,480
101,174
54%
2%
SUPPLIES
11,600
3,065
4,829
6,771
42%
SERVICES
228,895
81,843
90,724
138,171
40%
O
$
1,368,755
$
535,746
$
591,066
$
777,689
43%
C ITY CLERK
SALARIES AND WAGES
$
$
166,661
$
-
$
0%
0
BENEFITS
67,480
0%
SUPPLIES
-
781
-
0%
c�
SERVICES
-
116,107
-
0%
$
-
$
351,029
$
-
$
0%
ADMINIS TRATIVE S ERVIC ES
C
SALARIES AND WAGES
$
1,301,073
$
405,027
$
665,439
$
635,634
51%
LL
BENEFITS
413,858
135,401
213,378
200,480
52%
ZI
t
SUPPLIES
13,000
2,137
6,253
6,747
48%
SERVICES
428,980
82,806
202,930
226,050
47%
O
2
$
2,156,911
$
625,371
$
1,088,001
$
1,068,910
50%
N
C ITY ATTO RNEY
NC
SERVICES
$
971,780
$
404,226
$
465,893
$
505,887
48%
N
$
971,780
$
404,226
$
465,893
$
505,887
48%
NON -DEPARTMENTAL
O
SALARIES AND WAGES
$
101,750
$
-
$
-
$
101,750
0%
BENEFITS
145,504
24,849
62,143
83,361
43%
SUPPLIES
5,000
1,152
-
5,000
0%
d
i=
SERVICES
13,557,619
6,041,230
6,894,945
6,662,674
51%
t
INTERFUND SUBSIDIES
1,435,000
284,945
592,500
842,500
41%
DEBT SERVICE - PRINCIPAL
55,170
-
-
55,170
0%
r
Q
DEBT SERVICE - INTEREST
274,078
60,087
72,505
201,573
26%
$
15,574,121
$
6,412,264
$
7,622,093
$
7,952,028
49%
POLICE SERVICES
SALARIES AND WAGES
$
8,723,512
$
3,825,116
$
3,983,715
$
4,739,797
46%
BENEFITS
2,994,876
1,354,132
1,402,791
1,592,085
47%
SUPPLIES
281,569
120,820
107,199
174,370
38%
SERVICES
1,375,513
431,532
623,118
752,395
45%
MACHINERY/EQUIPMENT
96,343
(96,343)
0%
$
13,375,470
$
5,731,600
$
6,213,167
$
7,162,303
46%
S ATELLITE O FFIC E
SALARIES AND WAGES
$
25,000
$
-
$
-
$
25,000
0%
BENEFIT S
5,000
-
5,000
0%
SUPPLIES
12,000
11,057
943
92%
SERVICES
124,576
26,257
98,319
21%
$
166,576
$
$
37,314
$
129,262
22%
31
Packet Pg. 48
Page 2 of 2
C ITY O F EDMO NDS
EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL
2022 Amended
6/30/2021
6/30/2022
Amount
Title
Budget
Expenditures
Expenditures
Remaining
%Spent
COMMUNITY SERVICES/ECON DEV.
SALARIES AND WAGES
$ 365,627
$ 146,764
$ 99,087
$ 266,540
27%
BENEFITS
111,361
44,843
32,127
79,234
29%
SUPPLIES
4,075
111
269
3,806
7%
SERVICES
238,325
71,914
119,000
119,325
50%
$ 719,388
$ 263,632
$ 250,483
$ 468,905
35%
DEVELO PMEVT S ERVIC ES /PLANNING
SALARIES AND WAGES
$
1,978,832
$
939,641
$
1,017,598
$
961,234
51%
BENEFITS
681,706
326,942
351,886
329,820
52%
SUPPLIES
19,400
3,287
4,133
15,267
21%
SERVICES
1,111,921
201,412
305,360
806,561
27%
MACHINERY/EQUIPMENT
0%
$
3,791,859
$
1,471,283
$
1,678,976
$
2,112,883
44%
HUMAN SERVICES PROGRAM
SALARIES AND WAGES
$
101,496
$
22,372
$
32,570
$
68,926
32%
BENEFITS
29,113
5,110
7,196
21,917
25%
SUPPLIES
15,000
-
442
14,558
3%
SERVICES
313,500
251
8,802
304,698
3%
459,109
27,733
49,010
410,099
11%
PARKS & REC REATIO N
SALARIES AND WAGES
$
2,627,863
$
1,139,793
$
1,169,918
$
1,457,945
45%
BENEFITS
865,945
418,563
404,786
461,159
47%
SUPPLIES
166,640
87,599
115,179
51,461
69%
SERVICES
1,465,087
356,914
429,502
1,035,585
29%
$
5,125,535
$
2,002,869
$
2,119,385
$
3,006,150
41%
PUBLIC WORKS ADMINISTRATION
SALARIES AND WAGES
$
387,424
$
149,786
$
65,140
$
322,284
17%
BENEFITS
126,689
53,170
31,451
95,238
25%
SUPPLIES
9,600
6,976
2,519
7,081
26%
SERVICES
90,400
44,094
41,574
48,826
46%
$
614,113
$
254,025
$
140,684
$
473,429
23%
FACILITIFS MAINTENANCE
SALARIES AND WAGES
860,456
384,227
429,253
431,203
50%
BENEFIT S
369,679
168,643
172,048
197,631
47%
SUPPLIES
128,000
61,773
41,268
86,732
32%
SERVICES
1,796,960
374,982
394,231
1,402,729
22%
MACHINERY/EQUIPMENT
270,180
-
45,195
224,986
17%
$
3,425,275
$
989,625
$
1,081,995
$
2,343,280
32%
ENGINEERING
SALARIES AND WAGES
$
1,866,128
$
883,236
$
923,510
$
942,618
49%
BENEFITS
702,578
354,367
340,861
361,717
49%
SUPPLIES
2,200
795
-
2,200
0%
SERVICES
274,430
107,843
104,174
170,256
38%
$
2,845,336
$
1,346,241
$
1,368,545
$
1,476,791
48%
TOTAL GENERAL FUND EXPENDITURES
$
52,360,872
$
21,115,256
$
23,500,987
$
28,859,885
45%
r�
Q
32
Packet Pg. 49
2.4.b
GENERAL FUND OVERVIEW
BALANCES
CHANGE IN FUND BALANCES
GENERAL FUND
---- ACTUAL ----
---- ACTUAL
----
& SUBFUNDS
6/30/2022 6/30/2022
Q2
YTD
Fund Balance Cash Balance
001-General Fund *
$
14,388,014 $ 6,904,231
$ 3,027,697 $
(1,543,336
009-Leoff-Medical Ins. Reserve
224,192 224,192
57,060
(31,026
011-Risk Management Reserve Fund
25,000 25,000
-
-
012-ContingencyReserve Fund
1,782,150 1,782,150
-
-
014-Historic Preservation Gift Fund
16,422 16,421
-
-
0
a
016-Building Maintenance
4,400,553 4,400,554
1,816
554
W
017 - Marsh Restoration & Preservation
848,617 848,616
-
-
.v
018 - Edmonds Homelessness Response Fd
200,000 200,000
200,000
200,000
Total General Fund & Subfunds
$
21,884,948 $ 14,401,163
$ 3,286,573 $
(1,373,808
LL
c
*$8,067,160 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012, represent the
required
�0
20% operating reserve.
0
There are no interfund loans outstanding at this time.
c
c
ii
GOVERNMENTAL FUNDS
OVERVIEW
2'
0
2
N
N
O
N
N
BALANCES
CHANGE IN FUND BALANCES
---- ACTUAL ----
---- ACTUAL
----
r
c
GOVERNMENTAL
FUNDS
6/30/2022 6/30/2022
Q2
—
YTD
—
E
Fund Balance Cash Balance
c�
General Fund & Subfunds
$
21,884,948 $ 14,401,163
$ 3,286,573 $
(1,373,808
Q
Special Revenue
22,761,905 21,233,780
3,713,230
4,383,184
Capital Projects
2,039,333 2,289,500
(1,252,457)
(2,074,530
Total Governmental Funds
$
46,686,186 $ 37,924,443
$ 5,747,347 $
934,845
*Please note that these revenues and expenses occur within annual cycles.
This Interim Report is not
adjusted for accruals or those annual cycles.
33
Packet Pg. 50
2.4.b
SPECIAL REVENUE FUNDS OVERVIEW
BALANCES
CHANGE IN FUND BALANCES
GOVERNMENTAL
---- ACTUAL ----
---- ACTUAL
----
SPECIAL REVENUE
6/30/2022
6/30/2022
Q2
YTD
Fund Balance
Cash Balance
104 - Drug Enforcement Fund
$ 76,076
$ 76,576
$ 324 $
901
1 1 1 - Street Fund
739,792
603,307
79,264
(21 1,373
112- Combined Street Const/Improve
3,219,823
2,084,785
309,484
981,375
117 - Municipal Arts Acquis. Fund
718,802
722,265
5,634
69,924
120 - Hotel/Motel Tax Revenue Fund
89,031
75,794
6,508
17,917
121 - Employee Parking Permit Fund
88,818
89,212
4,048
12,294 a
122 - Youth Scholarship Fund
14,431
14,503
61
171
123 -Tourism Promotional Fund/Arts
111,143
107,077
7,973
15,172
125 - Real Estate Tax2
4,154,002
4,079,117
96,203
100,587
126 - Real Estate Excise Tax 1 *
4,106,198
3,935,112
502,714
792,859
127 - Gifts Catalog Fund
3,246,282
3,247,864
2,881,289
2,944,757 u_
130-CemeteryMaintenance/Improvement
283,637
285,046
11,419
17,432
136 - Parks Trust Fund
168,062
168,929
(1,822)
(528 c
137 - Cemetery Maintenance Trust Fund
1,130,240
1,135,937
9,134
23,165 2
138- Sister City Comm ission
18,097
18,177
2,498
2,617
le-
140 -Business Improvement Disrict
53,845
53,846
(1,597)
24,714 o
141 -Affordable and Supportive Housing I'd
183,701
176,308
1,253
24,287 m
142 - Edmonds Rescue Plan Fund
4,339,048
4,339,048
(201,157)
(433,332
143 -Tree Fund
20,877
20,877
-
W
Total Special Revenue
$ 22,761,906
$ 21,233,780
$ 3,713,230 $
4,383,184
*$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $500,000 for
the purchase of Open Space.
2+
ENTERPRISE FUNDS OVERVIEW
r
c
2
N
N
O
N
N
C
3
7
BALANCES
CHANGE IN FUND BALANCES
a�
ENTERPRISE
---- ACTUAL ----
---- ACTUAL
---- E
FUNDS
6/30/2022
6/30/2022
Q2
YTD
Fund Balance
Cash Balance
Q
421 -Water Utility Fund
$ 30,415,298
$ 8,231,193
$ 556,701 $
1,688,131
422-Storm Utility Fund"
16,767,735
6,616,665
278,943
1,120,358
423-Sewer/WWTPUtility Fund
61,216,123
16,618,742
(560,785)
863,594
424-Bond Reserve Fund
845,769
845,769
1,805
1,808
411 -Combined Utility Operation
82,560
122,447
35,770
82,560
Total Enterprise Funds
$ 109,327,486
$ 32,434,815
$ 312,433 $
3,756,450
*$250,000 of the Storm Utility Fund Balance
has been reserved for Marsh Restoration Funding.
*Please note that these revenues and expenses occur within annual cycles.
This Interim Report is not adjusted for accruals or those annual cycles.
34
Packet Pg. 51
2.4.b
SUMMARY OVERVIEW
BALANCES
CHANGE IN FUND BALANCES
---- ACTUAL ----
---- ACTUAL
----
CITY-WIDE
6/30/2022 6/30/2022
Q2
YTD
Fund Balance Cash Balance
Governmental Funds
$ 46,686,186 $ 37,924,443
$ 5,747,347 $
934,845
Enterprise Funds
109,327,486 32,434,815
312,433
3,756,450
Internal Services Fund
10,404,747 5,980,148
210,841
117,195
Total City-wide Total
$ 166,418,419 $ 76,339,407
$ 6,270,621 $
4,808,491
0
a
m
�a
INTERNAL SERVICE FUNDS OVERVIEW
u_
0
BALANCES
CHANGE IN FUND BALANCES
---- ACTUAL ----
---- ACTUAL
----
Fa
INTERNAL SERVICE
FUNDS
6/30/2022 6/30/2022
Q2
YTD
Fund Balance Cash Balance
c
ii
511 - Equipment Rental Fund
$ 9,450,950 $ 5,199,074
$ 124,919 $
242,439
>+
512 -Technology Rental Fund
953,797 781,074
85,922
(125,244
r
c
0
Total Internal Service Funds
$ 10,404,747 $ 5,980,148
$ 210,841 $
117,195
N
0
N
N
C
3
7
r
C
N
E
L
V
Q
*Please note that these revenues and expenses occur within annual cycles.
This Interim Report is not adjusted for accruals or those annual cycles.
35
Packet Pg. 52
June 2022 Monthly Financial Report
August 9, 2022
OF Eb4Q�O
w
Packet Pg. 53
F
0
a
a�
�a
c
c�
c
ii
21
r
c
0
2
CD 0�
0
E
E
0
U
a�
v
c
to
c
ii
c
w
E
t
U
ca
Q
Noteworthy items:
0
0
• Page 4 &
19 — REET revenues are down a total of $(384,591) from this time last year, but still right on budget.
• Page 19 —
The difference for Fund 422 is primarily due a Grant reimbursement in January of 2021.
U-
• Page 19 —Fund
112 -The large Traffic Impact Fee that was received in March of 2022 was for $133,582.
.�
• Page 19 —
Fund 332 — The large Park Impact Fee that was received in March of 2022 was for $288,260.
• Page 21—
Sales Tax is up $604,919 from this time last year.
• Page 21—
Gas Utility Tax is up $71,348 from this point in time last year; this is not due to a timing difference, but,
00
likely due to the unusually cold and rainy first half of 2022.
0
• Page 22 —
Plan Checking Fees are down $(87,441) from this point in time last year, while Building Structure Permits
0
E
are up $54,450 from this point in time last year. The overall outlook for Development Services remains favorable.
• Page 22 —
Parks & Recreation Program Fees are up $104,638 from this point in time last year.
• Page 22 —
Interfund Reimbursement — Contract Services — January through June of 2022 Engineering Overhead has
U-
not yet been recorded; January through June of 2021 was a total of $1,090,344.
0
• Page 23 —
As expected, total Interest Earnings for all funds are down a total of $(81,544) from this time last year; Fund
E
001 interest is down $(34,699). a
F. D
Packet Pg. 54
General Fund Spending for 6 months ended June 30
$2.5 million under budget
General Fund
Cumulative
Monthly
YTB
Va ria nce
Budget Forecast
Budget Forecast
Actuals
%
55,400,00 C
Ge ne i-al Duid
January
$ 5,142r528
5,142,529
4,601,62-5
-13.8796
50,000, CI,
February
9,225,120
3,882,592
8,134,057
-11,83%
5a 000 C)
March
13,451,045
4,227,925
11,966,C23
-11..05%
,000,000
April
17,154,991
3,701,846
15,469,511
-9.82%
35,00O, ("
A40V
21,081,164
3,926,271
19 144 529
-9.19%
30,000,00c.
25,000,00()
20,000,000 -
June 25,951,408 4,872,244 23,500,987 -9.45%
itify
10,083,274
4,129,866
15,DO0,{10
Augvst
33,991,194
3,907,920
10,DO0,00
September
38,121,718
4,130,524
5,000,000
October
42,646,764
4,525,046
0
November
47,397,112
4,750,547
JAN FEB AdAR APR MAY JUN JUL ALIT SFP OCT NOV DEC
December
52,360,872
4,963,560
--i—CwTr mt Year —Budget PricrYear
�
n
E.
E.
0
aL
0
w
C
CU
c
ii
0
a�
0
00
0
a�
a�
a�
r
r
E
E
0
U
a�
v
c
CU
c
ii
c
w
E
CU
a
Packet Pg. 55
Sales Tax Revenues for 6 months ended June 30
$605,000 ahead of last year, and $730,000 ahead of budget
Sales and Use Tax
Cumulative
Morthly
YTD
Variance
Budget Forecast
Budget Forecast
ActuaIs
%
JGnunry $
I63,651 $
763,651
$ 857,872
12.34%
Feb riinry
1,704,609
940,959
1,853,000
8.71%
March
2,420,254
715,646
2,666,259
10.16%
April
3,074,639
654,384
3,469,412
12.84%
May
3,893,081
818,442
4,483,349
15.16%
June
4,672,507
119,426
5,402,133
15.62%
July
5,523,403
850,896
August
6,439,084
915,680
September
7,293,649
8.54,565
October
8,203,996
910,34/
November
9,139,425
935,429
December
10,000,000
860,515
Sales and iTse Tax
11.000.000
10.000.000
9.00a000
s.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 ILL-kR APR MAY JLTN
JLTL AUG SEP OCT NOV DEC
--D-- C'uirent Year -Bud2et Prior Year
E.
E.
0
aL
0
w
CU
_
i-
t
r
_
0
00
0
vM
a�
a�
r
E
E
0
U
a�
U
_
�a
_
ii
_
w
E
t
U
2
a
Packet Pg. 56
Sales Tax Revenues for 12 months ended June 30, by Category
Sales Tax Analysis By C ategoii-
un-ent Pedod: June 202
Year -to -Date
Total 940 J3
Health & Autoimtive Repair, lsines s Services,
604.914
ConstructioaTmde. Personal $115,946
836,588 Care- 6A semeut Gasoline, $15,526
$138,86 Recce tion. S35.935
Acconxmdatian, Retail Food Stores,
19,092. $171,442
Clothing and
Accessanes_5167,490 R&O Automa
commMuications, disc RetaiL 51313.688
$123,400 S"8_S11
Wholesale Trade_
5179,266
Others. $107.M
Manufacturing, $60.811
Eating & Ihialang,
$562,555
;�rQ
Packet"Pg. 57
Real Estate Excise Tax Revenues for 6 months ended June 30
Under budget by $16,000 (99.16% of budget)
Real Estate Excise Tax 1 & ?
Cumulative Monthly YTa Variance
Budget Forecast Budget Forecast Actua Is %
lanDory 381,007 381,097 5 3 77,89 5 4V.
Februory 611,562 230,465 620,392 1.44
A40rch
952,142
340,580
703,526
-16.62
Aprif
1,227,434
275,291
1,165,930
-5.01
May
1,596,772
35S,339
1,544,140
-2.69
�urre
1,961,879
375,106
1,945,474
-0.84%
Iuiy
2,358, 248
406,370
August
2,810,074
441,826
September
3,256,638
446,564
October
3,660,486
403,849
November
4,056,561
396,075
December
4,400,000
343,439
I
, 50 0,000
7000, 00
50 O,OOD
700 0,000
37500,000
3,00O,ODD
5OO,OOD
00 0,OOD
175007000
1700 07000
50 0, D00
0
JAIN
Real Estate Excise Tax 1
FEB MAR APR MAY JUN JUL AUGSEP
�CnrrentYear -Budget priorYear
Q[ .'T NOV DEC
1 LO
Packet Pg. 58
E.
E.
0
0
Cu
U-
c
0
0
of
0
E
E
0
U
a�
c
c
U-
c
0
E
Q
Preliminary results are in for last year:
The General Fund's ending fund balance at 12/31/2021 is
$15.9 million. See attached P&L.
Ending Fund Balance - General Fund
$18,000,000
$16,000,000
$14,000,000
$12,000,000
$10,000,000
$8,000,000
$6,000,000
2015 2016 2017 2018 2019 2020 2021
pp ED4Q�O
w
Packet Pg. 59
Thank you.
OF EbAfQ�O
w
Packet Pg. 60
a