HomeMy WebLinkAboutWK - November 22, 20229 C I T Y 0 kNDOV '
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
City Council Workshop
Tuesday, November 22, 2022
City Hall — Conference Rooms A & B
1. Call to Order— 6:00 p.m.
2. Discuss Nightingale Villas Development Storm Water Design —Engineering
3. Discuss Grey Oaks Development Mill & Overlay Assessment Method — Engineering
4. Discuss Commercial Recreation Concept —Planning
5. 2023 Budget Discussion —Administration
6. October 2022 Community Center Update —Administration
7. October 2022 General Fund Budget Progress Report — Administration
8. October 2022 City Investment Reports — Administration
9. Other Topics
10. Closed Session — City Administrator Performance Review
11. Adjournment
�N-DOVENA
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Council
CC: Jim Dickinson, City
FROM: David Berkowitz, Director of Public vv.Q&s/City Engineer
SUBJECT: Discuss Nightingale Villas Development Storm Water Design —Engineering -
DATE: November 22, 2022
INTRODUCTION
The City Council is requested to discuss the Nightingale Villas development storm water design.
DISCUSSION
Ms. Rhonda Ganske who resides at 2159 153d Lane NW in Andover has requested the City Council
address her concerns regarding the storm water design for the Nightingale Villas development. Refer
to the attached email and attachment that Ms. Ganske has requested to be entered into the record.
City staff along with representatives from the Coon Creek Watershed District will review the storm
water design for Nightingale Villas and answer questions.
COUNCIL ACTION
The City Council is requested to discuss Nightingale Villas development storm water design and direct
staff on how to proceed.
Respectfully submitted,
David D. Berkowitz, P.E.
Attachment: Email and Attachment from Ms. Ganske V111
Cc: Rhonda Ganske (Email)
Tim Kelly, Coon Creek Watershed District (Email)
Dave Berkowitz
From:
James Dickinson
Sent:
Sunday, November 06, 2022 8:09 AM
To:
Dave Berkowitz
Subject:
FW: Nightingale Villas filtration pond
Attachments:
November6CC.pdf
Sent from my Verizon, Samsung Galaxy smartphone
Original message
From: gans0024 University of Minnesota <gans0024@umn.edu>
Date: 11/6/22 7:58 AM (GMT -06:00)
To: Sheri Bukkila <cm.bukkila@andovermn.gov>, Jamie Barthel <cm.barthel@andovermn.gov>, Ted Butler
<cm.butler@andovermn.gov>, Valerie Holthus <cm.holthus@andovermn.gov>, Randy Nelson
<cm.nelson@andovermn.gov>, City Council <council@andovermn.gov>
Cc: James Dickinson <J.Dickinson @andovermn.gov>
Subject: Nightingale Villas filtration pond
EXTERNAL EMAIL ALERT: This message originated from outside the City of Andover email system. Use Caution when
clicking hyperlinks, downloading pictures or opening attachments.
Since you still have not discussed my request that I made to the City Council back on October 4th, 2022, 1 have a few
more items that I would like you to consider. I also have proposed a potential solution. Please see the attached
document. If it does not work with your programs, I will deliver a printed hard copy on Monday.
Thank you for your time and consideration of this request.
Please enter this email and attachment into the record.
Rhonda Ganske
2159 153rd Lane NW
Andover, MN. 55304
(763)862-8967
Rhonda Ganske-2159153`dLane NW
Under section 9.5 Stormwater of the CURRENT Coon Creek Watershed District Rules it states under Standards:
1) Stormwater leaving the site must be routed to a PUBLIC drainage system.
2) Drainage sensitive uses downstream from the proposed site must be accounted for and their ability to discharge in a
TIMELY MANNER must be assured.
3) Stormwater plans must ensure that discharge rates from the proposal are controlled such that within Drainage -Sensitive
Uses Areas the post -development 100 -year peak flow rate shall NOT EXCEED predevelopment 25 -year peak flow rate.
The CURRENT City of Andover Surface Water Management Plan has the following policies under section 5.1 (Water Quantity):
5.1.5 Stormwater leaving a site must be routed to a PUBLIC DRAINAGE SYSTEM.
5.1.16 The design of storm water facilities will consider and identify location(s) of overflow(s) that PREVENT PROPERTY
DAMAGE TO ADJACENT PROPERTIES FROM EXTREME WATER LEVELS.
5.1.19 Emergency overflows or outlets to drainage systems will be provided to any landlocked area if the available storm
water storage capacity is inadequate to prevent flooding of residences and IF THE AVAILABLE DOWNSTREAM CONVEYANCE SYSTEM
CAPACITY IS ADEQUATE TO ACCEPT ADDITIONAL FLOW.
The CURRENT city code 12-14-11 states: No land shall be developed and no use shall be permitted that results in water runoff
causing flooding, erosion or deposit of minerals on adjacent properties. Such runoff shall be properly channeled into a
storm/drain, watercourse, ponding area or other PUBLIC facilities.
These are the rules that were in effect when the Nightengale Villas development was approved. They were in effect when the
outflow culvert and emergency overflow were put in place. They were in effect when I made my initial presentation/request to the
City Council on October 4, 2022. They are in place now and will be until January, 2023. The revised rules for the CCWD were
presented at a meeting on October 10, 2022, six days AFTER I made my initial presentation to the City Council. They were approvec
on October 24, 2022, but do not go into effect until next year.
In the email from Jason Law dated September 16, 2022, he states: "Under existing conditions (before the new development),
stormwater runoff from the property east of you would head up and flow to the low area north of your house. In turn, when the
low area on your property heads up high enough, it would flow west and north across your neighbor's property north of you. Now,
you likely have not seen this happen recently or ever, but I'm talking about extreme rainfall events." He also states "If a back to
back 100 -year storm event happened (7.2" of rainfall one day, then 7.2" again the following day) ... half the town would be under
water."
The neighbors that Jason Law refers to are Mike and Jan Schendel who live at 2170 —154th Lane NW. She sent an email to Erin
Edison at the Coon Creek Watershed District on October 21, 2022 expressing her concerns about water from the new development
flowing onto their private property. Erin Edison responded on October 27, 2022 by stating: "For stormwater from this development
to reach your property, we would have to get more than two 100 -year events back-to-back, which is 14.2" of rainfall in 48 hours.
The probability of a rainfall of that magnitude is less than 0.001% and there would be substantial flooding throughout the city." She
goes on to say that "The District reviews the stormwater system extensively to ensure there are no impacts to neighboring
properties."
The report from Borgart, Pederson and Associates states that "there is outflow through the culvert and emergency overflow on 2B
(the northern filtration pond) to the NW depression 4P" (my backyard). It does not state that it will flow to a public drainage
system. It also states that "The infiltration rate for most of the site is designed to be 0.8 in/hr due to the SP soils. The northwest
depression 4P (my backyard) is shown to have a layer of SP -SM so the infiltration rate is limited to be 0.45 in/hr."
As I have stated before, the water would have to travel UPHILL to leave my property and there is no established route for it to do so.
Therefore the stormwater leaving the Nightengale Villas development is NOT being routed to a PUBLIC drainage system. There is no
CONVEYANCE SYSTEM and instead the water will just stay in my private landscaped backyard where it will not infiltrate as quickly
and will NOT DISCHARGE INA TIMELY MANNER. It will not drain along the edge of my property. Instead the water will just sit in the
depression in my backyard. While some of the water from that land may have entered my property in the past, it also flowed in
other directions. The only offsite drainage for the stormwater runoff for the entire development is my backyard. The city code
specifically states that no land shall be developed and no use shall be permitted that results in water runoff causing flooding on
adjacent properties.
Even in the new rules of the CCWD, it states in section 3.3.6 that "If a drainage system is proposed to outlet a landlocked basin,
sufficient storage volume must be provided to RETAIN back-to-back 100 -year, twenty -four-hour rainfalls and runoff." This is not
the case for the Nightengale Villas development.
Mr. Berkowitz repeatedly stated in his memorandum dated October 18, 2022 that the water discharge on my property will be
significantly less than it has been in the past. However, if you examine the peak water elevations pre and post rainfall events on
page 4, you will note that the differences are negligible and not statistically significant. This is especially true for 2 year rainfall
events. He also refers to the CCWD rules, Section 9.1 Regulation which states: "Temporary storage areas or retention areas
scattered throughout DEVELOPED areas shall be encouraged to reduce peak flow, erosion damage, and construction cost." He
states: "In essence, low areas holding water such as Ms. Ganske's low area are encouraged and a benefit to the environment."
However, my land is not part of the DEVELOPED area for Nightengale Villas.
As I mentioned in my letter to you dated October 25, 2022, 1 am also concerned that the water discharge from Nightengale Villas will
damage my new privacy fence. This fence runs right in front of the outflow culvert and emergency overflow. As noted in the
October 18, 2022 memorandum, "there is not a reverse grade pipe out of the NW infiltration basin that would provide skimming."
The water and debris will be discharged directly at my fence. This fence was agreed to by the city and voted into effect with the
plat on May 3, 2022. The permits were filed and approved by the city on 8/22/22. Removal of the outflow culvert and emergency
overflow would allow the city to remain consistent with the decisions made by the City Council on November 1, 2022 to deny fences
that could inhibit water flow.
Pictures of the outflow culvert and emergency
overflow of the northern filtration pond where
thev are adiacent to my new orivacv fence.
This picture
is from my
side of the
fence. The
dirt is from
where they
initially
extended the
outflow
culvert onto
my property.
I have noted that the southern filtration pond is significantly more shallow than the northern one which is adjacent to my property.
The water from southern pond is diverted under the street to the northern pond. If the southern pond were made deeper, it would
then discharge less water to the northern pond. Perhaps the direction of water flow between the ponds could be reversed as well.
Given that the original plat showed a single filtration pond on the south side of the development, this should be possible.
2
Preexisting filtration pond for th ,
3
The
southern
filtration
pond as
viewed
from its
southwest
corner.
The southern
filtration pond as
viewed from its
northern edge
and facing south.
The preexisting
filtration pond for
the development
to the south of
Nightengale Villas
is in the back.
The western half
of the northern
filtration pond as
viewed from its
southern edge
and facing
northwest.
The eastern half of
the northern
filtration pond as
viewed from its
southern edge and
facing northeast.
Also, water could be diverted south of the development as it was predevelopment. According to the report from Bogart, Pederson
and Associates, "No proposed impervious runoff is directed to the Southeast of the site in depressions 2P and 713" post
development. The neighbors to the south of the development already have a filtration pond and drainage easements on their
property. These were already in place when those homes were built. I have no filtration ponds or drainage easements on my
property. Couldn't the emergency overflow be directed to the filtration pond that already exists to the south of the development?
These remedies would allow for significantly less water being sent to the northern filtration pond, and the outflow culvert and
emergency overflow could then be removed.
View of the preexisting filtration pond south of the View of the filtration pond to the south of the Nightengale Villas
Nightengale Villas development as seen from the development as seen from Veterans Memorial Drive facing north.
southern border of the development.
I realize these changes could be costly, but it will be more expensive if you include court costs, if homes have already been built or if
the courts issue a stop work order.
It has been over a month since I made my initial presentation and request to the City Council. The Council has not even discussed
the issue, even though there have been 2 regular council meetings since then and a workshop on October 25, 2022. What is the
reason for the delay? Please let me know as soon as possible when you will be discussing this matter and be able to give me a
response. Please enter this document into the record. Thank you.
(T
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Council Members
CC: Jim Dickinson, City Administrator
FROM: David Berkowitz, Director of PublV/01tyneer
SUBJECT: Discuss Grey Oaks Development Mill & Overlay Assessment Method —
Engineering
DATE: November 22, 2022
INTRODUCTION
The City Council is requested to discuss the Mill & Overlay proposed assessment method for Grey
Oaks.
Identified in the 2024-2028 Capital Improvement Plan is a mill & overlay for the Grey Oaks development
area as shown on the attached location map.
Due to the multiunit buildings within the development staff is requesting direction on the assessment
method for the project which will be discussed in detail at the meeting. Once there is direction on the
assessment method the feasibility report will be completed and information will be sent out to the
property owners regarding the project and estimated assessment cost.
COUNCIL ACTION
The City Council is requested to discuss the Mill & Overlay assessment method for Grey Oaks and
direct staff on how to proceed.
Respectfully submitted,
David D. Berkowitz, P. .
Attachment: Grey Oaks Location Map
N CAPITAL IMPROVEMENT PLAN
(2023)
PROJECT NAME: STATE AID ROUTES / MILL & OVERLAY
LOCATION. GREY OAKS (MSA PORTION)
♦t 's
CJ � � - j•,+ � fir.
• < I�f. .15Ti11 AVE
158THLN
7r."
LST(N W r - � -- •' ISTHIN �': Y'_EC ?
.� N .. � ♦ '4 a1.1.. .i J I � Y � � �i
• ... j 4F r _
_
TH
-
_ 156LN
1
- 156TH AVE F' ' ;y�"•T �� �r �� � \ %�
ll r.- yT.-1 ' - NE
T_.��.>. a• � .. � 155TH AVE � .� .� '.�. ,'d!
t. ! F�. y:•,. 159THW % 1 ,.f i,
153RD LN
N Lt. 0 •a
0 255 510 Feel
I I I 0 Project Location C I T Y O F
11YsAW kh<atlNbrtrwl¢ is VE
pv�56 Mfy wRF ma<ptr99 �emuary of 0 Parcel Boundary
Incorporated 1974
wrn wlm. mange aw"`°R"�`m "" Q city Limits
wrabrs; mo-el«e we CM asumes m
I W Ab b xry ertus rc onk4m Fertln.
„m: n:�wswwwrovnxm�e c::+wxwicrrnarawzzlcv_zozzao.. uau eooma: uslzou,:avx Andover GIS
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor & Councilmembers �Q
CC: Jim Dickinson, City Administrator�e\
Joe Janish, Community Development ctor 7
FROM: Jake Griffiths, Associate Planner
SUBJECT: Discuss Commercial Recreation Concept — Planning
DATE: November 22, 2022
DISCUSSION
Jess and Billy Evers of Maximum Sports Minnesota, LLC have submitted the attached letter
outlining their ideas for a private sports facility at 1657 — 161" Ave NW which is currently
referred to as Prairie Oak Church. The Evers have had discussions with City staff regarding their
ideas and City staff found that they most closely resemble commercial recreation in the City
Code. Commercial recreation is defined as "A recreation facility operated as a business and open
to the public for a fee".
City Code 12-11 prohibits commercial recreation in all residential zoning districts but allows
commercial recreation indoors as a permitted use and commercial recreation outdoors as a
conditional use in all commercial or industrial zoning districts. Since 1657 — 16151 Ave NW is
currently zoned R-1: Single Family Rural, a rezoning would need to be completed in order for
the Evers' ideas to be allowed on the site. Other related approvals such as a comprehensive plan
amendment, commercial site plan, building permit, etc. would also be required.
ACTION REQUESTED
The City Council is requested to discuss the potential of rezoning 1657 — 1615 Ave NW from
residential to a commercial zoning district so that a commercial recreation facility could operate
on the property and provide informal feedback to the Evers.
Respectfully sub
Jake Griffiths
Associate Planner
Attachments
Letter from Jess & Billy Evers
Site Location Map
Zoning Map
Future Land Use Map
CC: Jess & Billy Evers, Minnesota Sports Minnesota, LLC (Via Email)
To Whom it May Concern,
My name is Jess Evers and I live in Andover, MN with my husband Billy. We have a
true passion for youth athletics, specifically girls' basketball. We have 4 young
daughters of our own, all who are very competitive in basketball and other sports
including softball, lacrosse and soccer. In 2018, we formed The Minnesota Max
AAU Basketball program. The purpose of The Max was to offer girls in the "North
Metro" area of Minnesota a lower cost option for spring basketball. The Max also
focuses on a less rigorous schedule than some of the other programs and takes
pride in supporting the multi -sport athlete. We began with 1 team of 12 girls and
now, 4 seasons later, we have 6 teams with a total of 58 girls. The future includes
the addition of a sports facility in the Andover, MN area. This facility will house
basketball/volleyball courts that are available for practices/training, games and
tournaments and also has an area that offers a variety of training opportunities
including agility, speed and strength among many others. We also plan to have an
outdoor/dome area that is finished with turf to allow for soccer/lacrosse/football
games and practices. Additionally, we want to offer a program that focuses on
youth development outside of athletics. This will include events and programs
focused on kids making friends, having fun and supporting each other. These
events will range from game nights, leadership programs, movie nights, yoga
classes, etc. We are very excited to grow this program and see what impact we
can make.
We are interested in purchasing the Prairie Oak Church Campus property located
at 1657161St Ave NW. The plan for this property would include the addition of a
3+ court gymnasium and also a turf field. We understand that the current zoning
for this property does not allow for this type of a business. The reason for this
letter is to ask what the possibility would be for us to pursue our business at this
location. Any insight that you have would be greatly appreciated. Thank you for
your time.
Sincerely,
Jess and Billy Evers
Maximum Sports Minnesota, LLC.
h N. �.i v v c r-�
Site Location
Date Created: November 16, 2022
Disclaimer The provider makes no representation or warranties with respect to the reuse o/ this data.
� ' �•�,'_
I �
I �
TT Y O F
) 0V.
0
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO:
FROM:
SUBJECT:
DATE:
Mayor and Councilmembers
Jim Dickinson, City Administrator
2023 Budget Development Discussion
November 22, 2022
The Council has had several reviews of the 2023 Proposed General Fund Budget that will be supported by
the 2023 Tax Levy. The Council did adopt at the September 6th regular Council meeting a
Preliminary 2023 Property Tax Levy & General Fund Budget. The Preliminary 2023 Budget
proposes a total property tax levy of $17,073,084: $10,891,789 (63.80%) operational levy, $3,766,697
(22.06%) debt service levy, and $2,414,598 (14.14%) other levies. (See attached Property Tax Levy
worksheet)
The 2023 Proposed Property Tax Levy is estimated to decrease the current City tax rate by 14.40%.
That rate will be applied to the City's growing tax base and will reflect a 6.00% increase in the gross
tax levy. The focus of the 2023 Budget and Levy is an infusion of funds into the mill and overlay
program and a commitment to public safety. The Council has the right to reduce or keep constant
this levy until the final certification date of December 28, 2022.
By the November 22nd workshop, all the City of Andover residents and businesses should have received
property tax statements.
Much of what will be covered at the workshop will be repeat information with updates to date:
Council the bold italics items at the meetine. Also....
Administration/Finance will review with the Council the following attachments at the meeting.
1. Pay 2023 Valuation Estimates (pi.8)
2. City ofAndover Property Tax Lew — 2017 to proposed 2023 (pts 9 —10)
3. Proposed Resolution to Adopt the 2023 Budget and Tax Levy (pgs 11-13)
4. City ofAndover 2023 Budget Summary by Fund Types (pis 14 — 23)
5. Proposed 2023 General Fund Revenue & Expense Summary (pis 24 — 27)
6. Graphs that will be used at the December 6 2022 Budget Hearing (pis 28 — 34)
DISCUSSION
The following are the 2023 Budget Development guidelines adopted at the April 19th City Council meeting:
1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and positioning the
City for long-term competitiveness using sustainable revenue sources and operational efficiencies.
Note: The Anoka County Assessor is showing a 23.41 % increase in the taxable market value for the
Preliminary 2023 tax rate calculations. The preliminary 2023 property tax rate is anticipated to
decrease by close to 14.4 % (from 36.081 to 30.886). (See attached Pay 2023 Valuation Estimates)
2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less
than 45% of planned 2023 General Fund expenditures and the preservation of emergency fund balances
(snow emergency, public safety, facility management & information technology) through targeting
revenue enhancements or expenditure limitations in the 2022 adopted General Fund budget.
Note: With property tax revenues making up close to 80% of the total General Fund revenues cash
flow designations approaching 50% are appropriate and recommended by the City's auditor. The
2022 budget development exceeded this guideline for cash flow, also Emergency Fund Balances
(approximately 3 % ofplanned General Fund expenditures per finance policy) are in place to stabilize
a situation, not be a complete solution.
Staff did review with the Council the General Fund 2022 Fund Balance Analysis over the summer
3) A commitment to limit the 2023 debt levy to no more than 25% of the gross tax levy and a commitment
to a detailed city debt analysis to take advantage of alternative financing consistent with the City's
adopted Debt Policy.
Note: The adopted 2022 debt levy was 23.29% of the gross tax levy, the 25% guideline for the 2023
debt levy will be attained via the structured management of the current long-term debt, the current
preliminary 2023 debt levy is at 22.06%
4) A comprehensive review of the condition of capital equipment to ensure that the most cost-effective
replacement schedule is followed. Equipment will be replaced based on a cost benefit analysis rather
than a year -based replacement schedule.
Note: The City Vehicle Purchasing Committee has met and performed this analysis and made
recommendations on equipment needs as part of the 2023-2027 Capital Improvement Plan (CIP)
development process. The 2023-2027 Capital Improvement Plan was approved by the City Council
5) The use of long-term financial models that identify anticipated trends in community growth and
financial resources that will help designate appropriate capital resources for future City needs. The
financial models will be used in the budget planning process to ensure that key short-term fiscal targets
are in line with long-term fiscal projections.
Note: The City continually maintains various financial models to determine the long-term impacts
of present-day expenditures and financing decisions. Fiscal assumptions are based upon a set of
financial data including growth factors, tax capacity valuations, per capita spending, fund balance
reserve, and debt ratios.
6) Continued commitment to strategic planning targeted toward meeting immediate and long-term
operational, staffing, infrastructure and facility needs.
Note: The most recent Council Community Vision and Organizational Goals and Values document
was adopted by the City Council on December 3, 2019. Administration will assure that direction
provided in that document is integrated into department work plans and budgets.
7) A management philosophy that actively supports the funding and implementation of Council policies
and goals, and a commitment to being responsive to changing community conditions, concerns, and
demands, and to do so in a cost-effective manner.
Note: Special attention will be given to fiscal values, commercial & residential development or
redevelopment, collaboration opportunities, service delivery, livability, and image of the community.
Staffing:
Fire Department—New for the 2022 budget was to fill a full-time Assistant Chief position; that position
was filled early August. The 2022 budget also contained additional funds to help meet acceptable
response times with an enhanced Duty Crew model. Administration and Fire are closely monitoring the
progress of the Duty Crew model, success is crucial as duty crew alternatives such as fulltime firefighters
is very expensive. The Andover Fire Chief and Deputy Fire Chief were present at the September
workshop meeting to discuss the challenges associated with implementing the enhanced Duty Crew
model.
(The Fire Department did provide a staffing request as part of the 2023 budget process that outlines what a
fulltime firefighting model would look like; an additional $1.5 million per year for the operating budget,
plus capital expenses to bring fire stations up to code for fulltime staffing (sleeping quarters).
Administration is not recommending the fulltime firefighting model for the 2023 budget but does want the
Council to be aware of the cost of a fulltime model.)
There are some anticipated retirements and staff vacancies within the coming year and the next few years;
in response Administration/Human Resources continues to focus on succession planning, utilization of
internship opportunities, continued cross -training of staff, and/or realignment of resources. Some
realignments added significant new responsibilities and pay adjustments were made, all
accommodated within the current Human Resources budget.
Personnel Related Implications:
To date the following are the other projected issues facing personnel related expenses
Human Resources will review all position -based salaries and the associated benefit package to
determine if the total package is competitive with other government entities.
Pay steps for eligible employees will be included in a 2023 budget proposal. A cost -of -living
adiustment (COLA) for non -bargaining employees is being evaluated and will be discussed with
the Council at the Workshoa.
The current Public Works Union contract expires December 31, 2023. That contract is provided
for in the 2023 budget.
2. A midyear review of the employee health plan for the 2022 Budget was conducted with our
broker on July 27", a significant increase in the renewal rates was forecasted.
A marketing of the group to various insurance carriers was done and results of the marketing
yielded a 3% increase. The increase is provided for in the proposed 2023 budget for employee
health insurance.
For the 2023 budget, Administration at the November 1, 2022, Council meeting, recommended to
stay with the Health Partners Open Access program, our existing plan with the 3% increase. The
HSA plan with higher deductibles ($6,900 single and $13,800 family) and stacked with an HRA
(Health Reimbursement Arrangement) is being offered. The HRA was originally funded utilizing
premium savings that were achieved from a proposed renewal to a new higher deductible plan.
Employees have $3,500 single and $7,000 family deductibles; but with the stacked HRA, the City
will reimburse the remainder of the deductible, if needed, to the provider up to $3,400 for single
and $6,800 for family.
The plan offered is accompanied with a health spending account (HSA), originally implemented in
2006. The City does contribute annually to an employee's HSA to assist with the high deductible
out of pocket costs. That contribution was evaluated as part of the marketing of the health insurance
plans and will remain the same as the 2022 amount for 2023.
Contractual Departments:
1. The City Attorney 2022 contract reflected a 2% increase over the 2021 contract. A status quo
contract with a 2% increase is budgeted for 2023.
2. The Anoka County Sheriff's Office presented a proposed 2023 Law Enforcement Contract to the
City Council at the August 16 h Council meeting. The proposal was the outcome of
Administrations discussions with the Anoka County Sheriff for a 2023 contract taking into
consideration efficiencies brought about by technology investments and a detailed evaluation of
reactive/proactive patrolling, and matching staffing with historical incident call times. The
Council approve thatproposal and authorized the 2023 Law Enforcement Contract.
The approved 2023 City of Andover Law Enforcement expenditure is budgeted at $3,347,315
(0.3% increase) which is offset by a Police State Aid revenue budget of $126,192 and School
Liaison revenue budget of $106,465 reflecting a net tax levy impact of $3,114,658 (0.68%
increase).
The proposed 2023 Sheriff's cantractprovides for:
a. 72 hours per day of patrol service
b. 6 hours per day of service provided by a Community Service Officer
c. School Liaison Officers in the middle school and high school
d. 2 Patrol Investigators
e. 50% of the Crime Watch Program's coordinator position
Per contract, the Sheriff always provides the required number of deputies for all hours contracted
by the City. If the Sheriff s Office has a deputy vacancy or a deputy is injured etc., they still provide
the City with a deputy at straight time even though they may have to fill those hours with overtime
which at times may cost the Sheriff's Department additional but is not billable per the contract.
Council Memberships and Donations/Contributions:
The following memberships/contributions are in the 2022 proposed budget, updated for 2023:
• North Metro Mayors Association
• Metro Cities
• Mediation Services
• YMCA — Water Safety Program
• Alexandra House
$14,261 (GF)
$ 9,569 (GF)
$ 6,628 (GF)
$ 9,000 (GF)
$20,928 ($15,000 GF & $8,600 CG)
• Youth First (Program Funding)
$15,000 ($12,000 GF & $3,000 CG)
• NW Anoka Co. Community Consortium - JPA
$10,000 (GF)
• Teen Center Funding (YMCA)
$26,000 ($5,600 GF & $20,400 CG)
• Family of Promise
$ 3,000 (CG)
• Lee Carlson Central Center for Family Resources
$ 1,500 (GF)
• Senior High Parties
$ 1,000 (CG)
• Stepping Stone
$ 1,000 (CG)
• Hope for Youth
$ 1,000 (CG)
• Andover Senior Center
$ 3,500 (GF)
Some are funded via the General Fund (GF), and those that qualify for charitable gambling funding are
done through the Charitable Gambling (CG) Special Revenue Fund.
Capital Projects Levy:
Capital Projects Levy — The 2022 Capital Projects Levy Budget specifically designates $2,162,822 of the
general tax levy to capital projects and equipment needs relating to Capital Project Outlay ($275,000), Road
and Bridge ($1,409,579), Pedestrian Trail Maintenance ($108,243), Park Projects ($15,000) and Facility
Maintenance Reserve ($355,000). Specific designation of the tax levy to anticipated City needs and
priorities for transportation and trail maintenance, park projects and equipment outlays allows the city to
strategically allocate its resources and raise the public's awareness of City spending priorities. The Road
and Bridge levy is evaluated annually and along with Capital Outlay, Pedestrian Trail Maintenance, Parks
Projects, and Facility Maintenance levies increased/decreased according to the City Council budget
guidelines.
Road and Bridge
An adjustment was made to the Road & Bridge funding formula in 2014, primarily to stop the
continual decrease in the levy that has been happening over the past few years due to decreases in
the Anoka County Assessor taxable market value figures for the City of Andover. Based on Council
discussion, consensus was to stop the decline in road funding and evaluate annually through the
adopted City Council Budget Development Guidelines. It should be noted that in 2014, Local
Government Aid (LGA) in the amount of $74,655 was used to help fund the Road & Bridge Fund.
That State of Minnesota funding has gone away, down to $0.00 in 2017, and remain at 0.00 each
year since. Future increases in LGA or even the presence of LGA for the City of Andover based on
the current State formula are remote.
In 2021, as part of the 2022 budget process, Administration has had discussions with the Council
regarding the use of debt service levy and the Permanent Improvement Revolving (PIR) Fund fund
balance to address immediate street maintenance needs in the community based on En ing eering
analysis of the street infrastructure. The Council did approve the 2022 Street Reconstruction Bonds
infusing $7.33m into the Road & Bridge program to focus on mill and overlays and reclaims of
city streets
The 2019 City of Andover Road & Bridge levy was $1,254,788, a 7.34% increase over 2018. The
2020 budget contained a 2.60% increase ($32,681) to $1,287,469, the 2021 budget contained a
4.27% increase ($54,967) to $1,342,456 and 2022 budget contained a 5.0 % increase ($67,123) to
$1,409,579.
The proposed 2023 levy is an increase for 2023 to $1,619,190, a 14.87% increase, following
previous Council guidelines capturing market value increases to dedicate to roads.
• Pedestrian Trail Maintenance
The 2020 City of Andover Pedestrian Trail Maintenance levy was $104,040. The 2021 budget and
2022 budgets each included a 2% increase leading to a $108,243 levy for 2022.
The proposed 2023 levy is a 2% increase ($2,165) for 2023 to $110.408.
• Park Improvements
This levy is an annual appropriation to be used to underwrite park improvement projects as
recommended by the Park and Recreation Commission and approved by the City Council. This
funding is intended to be a supplemental source of capital funding for park projects that is separately
identified in the City's Five -Year Capital Improvement Plan.
The 2015 levy was $61,500, but only $15,000 was levied for 2016. $46,500 of the previous levy
was re -assigned to the General Fund to focus on Park's maintenance/replacement items. In addition
to the re -assigned funds, an additional $43,500 of General Fund levy was assigned to Parks
Repair/Replacement items for a total levy of $90,000 in 2016, and that continued for 2017. The
2018 General Fund levy assigned to Parks Repair/Replacement items levy was increased to
$100,000 for 2019, to $120,000 for 2020 & 2021 and then to 130,000 for 2022; the Parks Project
levy continues to remain at $15,000.
Per Council direction at a Joint Meeting with the Park and Recreation Commission, there will
be a $15,000 adiustment to these levies for 2023. The Parks Repair/Replacement items proposes
a 2023 levy at $145,000 and the Parks Proiect levy at $15,000.
• Capital Equipment/Projects
Under the Capital Projects Levy, a levy is proposed to be designated to Capital Equipment/Project
expenditures identified through the CIP process. Through this designation, the City, over time, will
build a fund reserve to avoid cash flow "spikes" and address a wide range of capital improvement
needs such as facility maintenance projects under a more controlled spending environment.
The 2022 levy was $275,000, the preliminary 2023 levy is proposing no increase to the $275,000
to continue to meet the needs of the CIP.
Facility Maintenance
This was a new $50,000 levy proposed for 2018. A facility condition assessment study identified
many maintenance repairs for City facilities such as roof repairs, HVAC, electrical panels, fire
alarm systems, windows, and air quality related items (the comprehensive listing which is proactive
and reactive was shared with the Council at the August 25t° workshop meeting). This levy was
increased to $355,000 for the 2019 budget to help address the significant deferred maintenance
items that have been identified. Most recently for the Public Works and Community Center
buildings expansion projects within the City Campus Master Plan materialized. The $355,000 levy
is anticipated to continue at that level into the future to address additional facility repairs.
Debt Service Lew:
Annually the Finance Department conducts a detailed debt service analysis to monitor outstanding debt and
to look for early debt retirement or refinancing opportunities that will yield interest expense savings to the
city. (Staff, along with Ehlers & Associates have completed reviews to see if any refinancing opportunities
are available at this time, currently there are none, we will then continue to monitor refunding
opportunities, as markets move quickly, and calculate potential savings for each issue that may meet
parameters which may generate savings)
The preliminary 2023 Debt Service levy is proposed as follows:
• 2012C Taxable G.O. Abatement Bonds $ 969,745 Final levy year 2031
• 2018A Capital Improvement Plan Bonds $ 612,794 Final levy year 2043
• 2019A GO Abatement Bonds $1,028,782 Final levy year 2039
• 2020A GO Equipment Certificates $ 376,740 Final levy year 2023
• 2021A GO Equipment Certificates $ 174,773 Final levy year 2025
• 2021A GO Street Reconstruction 603,863 Final levy year 2029
Total 3.766.697
ACTION REQUESTED
The Council is requested to receive a presentation and provide direction to staff.
submitted,
CITY OF ANDOVER
Pay 2023 Valuation Estimates
City of Andover
Taxable Market Values
$6,000,000,000
$5,000,000,000
$4,000,000,000
$3,000,000,000
$2,000,000,000
$1,000,000,000
$0
Pay 2020 Pay 2021 Pay 2022 Pay 2023
City of Andover
Tax Capacity Values
$60,000,000
$50,000,000 ■
$40,000,000
$30,000,000
$20,000,000
$10,000,000
$0
Pay 2020 Pay 2021 Pay 2022 Pay 2023
ESTIMATE
Pay 2020
Pay 2021
Pay 2022
Pay 2023
Taxable
Tax
Taxable
Tax
Taxable
Tax
Taxable
Tax
Market
Capacity
Market
Capacity
Market
Capacity
Market
Capacity
Value
Value
Value
Value
Value
Value
Value
Value
Andover Valuation Totals
$
3,561,318,700 $
36,099,539
$ 3,615,408,106 $
37,366,775
$ 3,885,459,439
$
40,210,548
$ 4,795,209,296 $
50,361,431
Captured Tax Increment
(114,064)
(119,819)
(122,976)
(141,310)
Fiscal Disparity Contribution
(1,310,143)
(1,348,420)
(1,414,808)
(1,368,461)
Local Tax Rate Value
34,675,332
35,898,536
38,672,764
48,851,660
Fiscal Disparity Distribution
5,355,244
5,475,223
6,037,850
5,500,256
Total Adjusted Values
$
40,030,576
$
41,373,759
$
44,710,614
$
54,351,916
3.36%
8.07%
21.56%
Taxable Market Value
Tax Capacity Value
% Change
% Change
co
Pay 2020
$
3,561,318,700
Pay 2020
$
36,099,539
Pay 2021
$
3,615,408,106
1.52%
Pay 2021
$
37,366,775
3.51%
Pay 2022
$
3,885,459,439
7.47%
Pay 2022
$
40,210,548
7.61%
Pay 2023
$
4,795,209,296
23.41%
Pay 2023
$
50,361,431
25.24%
City of Andover
Taxable Market Values
$6,000,000,000
$5,000,000,000
$4,000,000,000
$3,000,000,000
$2,000,000,000
$1,000,000,000
$0
Pay 2020 Pay 2021 Pay 2022 Pay 2023
City of Andover
Tax Capacity Values
$60,000,000
$50,000,000 ■
$40,000,000
$30,000,000
$20,000,000
$10,000,000
$0
Pay 2020 Pay 2021 Pay 2022 Pay 2023
City of Andover, Minnesota
Property Tax Levy
Less Fiscal Disparities Distribution
Local Tax Rate Levy
Certified
Certl9ed
Conrad
Cued
Carded
Requested
Less Law Based on Market Value
E 188,]71
Change
$ 184,199
§ 151,076
2018
2019
2020
2021
2022
2023
% of Total
_L13.953.343
$
%
General & Other Operational Lewes
31,604.711
5.32%
34,615,332
9.72%
35,898,536
13.59%
38,672,764
11.5376
48,051,660
26.32%
General Operations
$ 8,543,256
$ 8,845,970
$ 9.194,032
$ 9,396,493
$ 9,868,370
$ 10,591,789
62.04%
$
723,419
7.33%
Community Center Operations
-
-
-
155,000
155,000
155,000
0.91%
$
-
0.00%
PaMS Repair/Replacement Items
100,000
100,000
120,000
120,000
130,000
145,000
0.85%
$
15.000
11.54%
Total General & Other Operational Levies
8,643,256
8.945,970
9,314,032
9.671,493
10,153,370
10,891,789
63.80%
$
738,419
7.27%
Dbt EmMat LeAee
2010A G.O.Open Space Referendum Bonds
188,777
183,989
184,199
151,078
-
-
2012C Taxable G.O. Abatement Bonds
972,055
969,378
976,780
973.283
974,628
969,745
2014A G.O. Equipment Certificate
294.945
294,525
-
-
-
-
2016AG.O.Equipment CertiOcate
143,310
142,837
143,373
-
-
-
201BAG.O.Cap lmprovPlan Bonds
-
525,000
433.603
456,344
617,519
612,794
2019A G.O. Abatement Bonds
-
-
1,001,090
976,966
1,014,065
1,028,782
2020 G.O. Equipment Centime,
-
-
350,000
406.224
374,850
376,740
2021A G.O. Equipment Cefcate
-
-
-
170,000
170,000
174,773
2021A G.O. Street Reconstruction Bonds
600,000
603,863
Total Debt Service Levies
1,599,087
2,115.729
3,089,045
3,133,875
3.751,062
3,766,697
22.06%
$
15,635
0.42%
Other Levies
Capital Projects Levy
Capital Equlpmen/Project
275,000
275,000
275,000
250,000
275,000
275,000
1.61%
$
-
0.00%
Capital Equipment Purchases
525,000
-
-
-
-
-
0.00%
$
-
#DIV/01
LO Facility Maintenance Reserve
50,000
355,000
355,000
355,000
355,000
355,000
2.08%
$
-
0.00%
Palls Projects
16,000
15,000
15,000
15,000
15,000
15,000
0.09%
$
-
0.00%
Road & Bridge
1,169,014
1,254,788
1,287,469
1,342,456
1,409,579
11619.190
9.48%
It
209,611
14.87%
Pedestrian Trull Maintenance
100,000
102,000
104,040
106,121
108,243
110,408
0.65%
$
2.165
2.00%
Lower Rum River Watershed
40,000
40,000
40,000
40,000
40.000
40,000
0.23%
$
0.00%
Total Other Levies
2,174,014
2,041,788
2,076.509
2,108,577
2,202,822
2,414,598
14.14%
$
211,776
9.61%
Gross City Levy
12,416,357
13,103,487
14,479,506
14,913,945
16,107,254
17,073,084
100.00%
$
965,829
6.00%
Less Fiscal Disparities Distribution
Local Tax Rate Levy
1,002,963
$ 10,613,394
1,725,448
$ 11,378,039
1,896,892
$ 12,502,694
1,957,824
$ 12,956,121
2,153,911
$ 13,953,343
1,984,687
$ 15,080,397
Less Law Based on Market Value
E 188,]71
E 183,989
$ 184,199
§ 151,076
E
§
Net Local Tax Rate Levy
_L 10,424,611
_L_11,194,050
_L 12,398,495
§ 12.805,043
_L13.953.343
_L15.088,397
Adjusted Tax Capacity Value" (1)
30,007,904
rima
31,604.711
5.32%
34,615,332
9.72%
35,898,536
13.59%
38,672,764
11.5376
48,051,660
26.32%
Tax Capacity Rate- 34.740% 35.419% 35.756%
Tax Capacity Rate W/O LRRWSD 34.627% 35.310% 35.656%
Tax Capacity Rate With LRRWSD 34.952% 35.621% 35.942%
Voter Approved Ref -MV 0.00681% 0.00572% 0.00526%
"Adjusted Value determined by adjusting for Fiscal Oispallies and Tax Increment esfimales.
"' Blendedrate due to the Clty dAnmwarlevying for Lower Rum w'var Watershed Dledd
(1) Adjusted Tax Capacity Value Is subject to change.
Chance
% Chancre
35.670%
36.081%
30.886%
-5.194%
-14.400%
35.574%
35.993%
30.814%
-5.179%
-14.390%
35.845%
36.243%
31.013%
-5.230%
-14.430%
0.00418%
0.00000%
0.00000%
r
0
City of Andover
Gross Tax Levy
$19,000,000
$17,000,000
$17,073,084
$15,000,000
$16,107,254
$14,913,945
14,479,586
$13,000,000
$13,103,487
$12,416,357
$11,000,000
$11,143,925
$9,000,000
$7,000,000
$5,000,000
2015 2016 2017 2018 2019 2020 2021 2022 2023
r
r
CITY OF ANDOVER
COUNTY OF ANOKA
STATE OF MINNESOTA
[[7.7.31hNCea
A RESOLUTION ADOPTING THE CITY OF ANDOVER 2023 BUDGET AND 2023 PROPERTY TAX LEVY TO BE CERTIFIED TO THE COUNTY AUDITOR.
WHEREAS, the preparation and adoption of budgets is recognized as sound financial practice; and
WHEREAS, the City of Andover receives significant financial support from its residents through the payment of property taxes; and
WHEREAS, the City of Andover has the responsibility to appropriately and efficiently manage the public's funds; and
WHEREAS, Minnesota State Law requires the City to certify to the County Auditor an adopted tax levy and budget prior to December 28, 2022; and
WHEREAS, Minnesota State Law requires the City to certify to the State of Minnesota Department of Revenue an adopted tax levy by December 28, 2022.
NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Andover hereby adopts the 2023 City of Andover Budget and the 2023 property tax levy
totaling $17,073,084 as listed on Attachment A.
BE IT FURTHER RESOLVED that the City Council of the City of Andover hereby establishes the 2023 City of Andover Budget by fund type as follows:
REVENUES
General Fund
Special Revenue Funds
Debt Service Funds
Capital Projects Funds
Enterprise Funds
Internal Service Funds
Total
Adopted by the City of Andover this
ATTEST:
Michelle Hartner — Deputy City Clerk
$ 13,564,378
4,135,216
4,661,997
14,778,263
6,461,274
1,616,630
$_45L217,758
day of December 2022.
EXPENDITURES
General Fund
$ 13,906,093
Special Revenue Funds
4,476,705
Debt Service Funds
4,393,198
Capital Projects Funds
21,028,445
Enterprise Funds
8,604,707
Internal Service Funds
1.718.091
Total $ 54,127,239
CITY OF ANDOVER
Sheri Bukkila - Mayor
CITY OF ANDOVER, MINNESOTA
2023 Property Tax Levy
Proposed
2023
Levy
General Fund Levy
General Operations $ 10,591,789
Community Center Operations 155,000
Park Repair/Replacement Items 145,000
Total General Fund 10,891,789
Debt Service Funds Levy
2012C Taxable G.O. Abatement Bonds
969,745
2018A G.O. Capital Improvement Plan Bonds
612,794
2019A Taxable G.O. Abatement Bonds
1,028,782
2020A G.O. Equipment Certificate
376,740
�- 2021A G.O. Equipment Certificate
N
174,773
2021A G.O. Street Reconstruction Bonds
603,863
Total Debt Service
3,766,697
Other Levies
Capital Projects Levy
Capital Equipment/Project
275,000
Facility Maintenance Reserve
355,000
Parks Projects
15,000
Road & Bridge
1,619,190
Pedestrian Trail Maintenance
110,408
Lower Rum River Watershed
40,000
Total Other
2,414,598
Gross City Levy
$ 11,073,084
Attachment A
r
W
STATE OF MINNESOTA)
COUNTY OF ANOKA )
CNoyce]"091610 17
I, the undersigned, being the duly qualified and acting City Clerk of the City of Andover, Minnesota, do hereby certify that I have carefully compared the attached Resolution No.
adopting the City of Andover 2023 Budget and 2023 Property Tax Levy with the original record thereof preserved in my office, and have found the same to be true and correct
transcript of the whole thereof.
IN TESTIMONY WHEREOF, I have hereunto subscribed my hand this _ day of December 2022.
Michelle Harmer — Deputy City Clerk
N
A
General Fund
Revenues: $13,564,378
Expenditures: $13,906,093
General Government
Public Safety
Public Works
Other
Fund Definitions
CITY OF ANDOVER
2023 Budget Summary By Fund Type
City of Andover- Budgeted Funds
Total Revenues: $45,217,758
Total Expenditures: $54,127,239
I Governmental Funds I
Special Revenue Funds
Revenues: $4,135,216
Expenditures: $4,476,705
EDA
Drainage & Mapping
LRRWMO
Forestry
ROW Mgmt / Utility
Construction Seal Coating
Community Center
CDBG
Charitable Gambling
CARES Act / ARPA Funding
Debt Service Funds
Revenues: $4,661,997
Expenditures: $4,393,198
G.O. CIP Bonds
G.O. Street Recon Bonds
G.O. Equip Certificates
G.O. Referendum Bonds
G.O. Abatement Bonds
Capital Projects Funds
Revenues: $14,778,263
Expenditures: $21,028,445
Proprietary Funds
Enterprise Funds
Revenues: $6,461,274
Expenditures: $8,604,707
Water Trunk I
Sewer Trunk IIC
Road & Bridge
Trail & Transportation
Cap Equip Reserve
Tax Increment
Park Dedication
PIR Projects
Building
CIP / Street Recon Bond Projects
Equipment Certificates
Sewer Fund
Water Fund
Stone Sewer Fund
Internal Service Funds
Revenues: $1,616,630
Expenditures: $1,718,091
Central Equipment / Maint.
Risk Management
General Fund - accounts for the revenues and expenditures necessary to carry out basic governmental activities of the City such as general government, public safety, public works, and other.
Special Revenue Funds - accounts for revenue sources that finance particular functions and projects.
Debt Service Funds - accounts for the accumulation of resources for, and the payment of general long-term debt.
Capital Projects Funds - accounts for the acquisition or construction of major capital facilities financed mainly with governmental fund sources, general obligation debt, special assessments, and other.
Enterprise Funds - accounts for activities that consist of rendering services or providing goods to the public for which a fee or charge is collected.
Internal Service Funds - accounts for goods and services that are provided to other City departments, or to other governments, on a cost reimbursement basis.
Fund Balance/Net Assets, January 1
Revenues & Other Sources
General
Special Revenue
Debt Service
Capital Projects
Enterprise
Internal Service
Total Revenues & Other Sources:
Total Available:
Expenditures & Other Uses
General
Ln Special Revenue
Debt Service
Capital Projects
Enterprise
Internal Service
Total Expenditures & Other Uses:
Fund Balance/Net Assets, December 31
Change in Fund Balance
CITY OF ANDOVER
2023 Budget Summary
Revenues and Expenditures Fund Summary
Actual
2021
$ 54,366,101
12,813,448
2,355,642
3,679,722
14,409,355
6,967,837
1,397,297
41,623,301
95,989,402
12,841,500
1,853,094
3,223,217
5,502,782
6,524,391
1,449,640
31,394,624
$ 64,594,778
$ 10,228,677
18.81%
Adopted
2022
$ 64,594,778
12,699,145
4,117,588
4,659,505
15,021,155
6,140,115
1,437,715
44,075,223
108,670,001
13,382,093
3,753,769
3,617,529
13,294,520
6,264,073
1,612,431
41,924,415
$ 66,745,586
$ 2,150,808
3.33%
Estimate
2022
$ 64,594,778
12,983,268
4,348,820
4,660,255
10,092,680
6,210,115
1,458,715
39,753,853
104,348,631
13,747,893
4,246,534
3,660,933
9,327,749
6,264,073
1,627,331
38,874,513
$ 65,474,118
$ 879,340
1.36%
Budget
2023
$ 65,474,118
13,564,378
4,135,216
4,661,997
14,778,263
6,461,274
1,616,630
45,217,758
110,691,876
13,906,093
4,476,705
4,393,198
21,028,445
8,604,707
1,718,091
54,127,239
$ 56,564,637
$ (8,909,481)
-13.61%
CITY OF ANDOVER
2023 Budget Summary
Revenues and Expenditures by Fund Type
Special
Debt
Capital
2,374,598
Internal
General Revenue
Service
Projects
Enterprise
Service Total
Fund Balance/Net Assets, January 1 $ 8,861,841 $ 1,612,751
$ 3,555,703
$ 39,337,553
$ 11,311,382
$ 794,888 $ 65,474,118
Revenues
General Property Taxes
Tax Increments
Special Assessments
Licenses and Permits
Intergovernmental
Charges for Services
Fines
Investment Income
User Charges
Meters
Miscellaneous
Total Revenues:
Other Financing Sources
F. Operating Transfers In
Bond Proceeds
Total Other Financing Sources:
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Capital Outlay
Debt Service
Total Operating Expenditures:
Other Uses
Operating Transfers Out
Total Other Uses:
Total Expenditures and Other Uses:
Fund Balance/Net Assets, December 31
Change in Fund Balance
10,814,789
195,000
3,766,697
2,374,598
-
-
17,151,084
-
-
-
100,000
-
-
100,000
-
-
-
1,963,000
-
-
1,963,000
573,000
-
-
-
-
-
573,000
839,907
1,700,948
-
8,619,954
-
-
11,160,809
839,110
1,241,000
-
-
6,207,829
1,612,630
9,900,569
45,500
-
-
-
-
-
45,500
75,000
8,200
-
107,500
62,500
4,000
257,200
-
-
-
384,911
-
-
384,911
-
-
-
-
13,000
-
13,000
148,300
990,068
520,000
44,000
1,702,368
13,335,606
4,135,216
3,766,697
14,069,963
6,327,329
1,616,630
43,251,441
228,772
-
895,300
708,300
133,945
-
1,966,317
228,772
895,300
708,300
133,945
1,966,317
13,564,378
4,135,216
4,661,997
14,778,263
6,461,274
1,616,630
45,217,758
22,426,219
5,747,967
8,217,700
54,115,816
17,772,656
2,411,518
110,691,876
6,374,964
924,676
-
-
1,318,317
632,788
9,250,745
847,544
117,570
-
-
510,800
480,920
1,956,834
4,635,276
629,932
-
-
-
-
5,265,208
1,900,309
740,227
-
10,056,000
3,165,818
604,383
16,466,737
148,000
1,756,000
-
10,288,500
1,853,500
-
14,046,000
4,393,198
782,200
5,175,398
13,906,093
4,168,405
4,393,198
20,344,500
7,630,635
1,718,091
52,160,922
308,300
683,945
974,072
1,966,317
308,300
683,945
974,072
1,966,317
13,906,093
4,476,705
4,393,198
21,028,445
8,604,707
1,718,091
54,127,239
$ 8,520,126
$ 1,271,262
$ 3,824,502
$ 33,087,371
$ 9,167,949
$ 693,427
$ 56,564,637
$ (341,715)
$ (341,489)
$ 268,799
$ (6,250,182)
$ (2,143,433)
$ (101,461)
$ (8,909,481)
-3.86%
-21.17%
7.56%
-15.89%
-18.95%
-12.76%
-13.61%
CITY OF ANDOVER
2023 Budget Summary
Revenues and Expenditures - All Funds
Actual
Budget
Estimate
Budget
2021
2022
2022
2023
Fund Balance/Net Assets, January l
$ 64,366,101
$ 64,594,778
$ 64,594,778
$
65,474,118
Revenues
General Property Taxes
14,924,342
16,185,254
16,185,254
17,151,084
Tax Increments
103,474
100,000
106000
100,000
Special Assessments
696,591
1,503,900
959,500
1,963,000
Licenses and Permits
891,762
535,500
692,400
573,000
Intergovernmental
1,102,318
3,937,941
4,176,116
11,160,809
Charges for Services
10,330,177
9,271,063
9,441,743
9,900,569
Fines
53,747
50,500
46,000
45,500
Investment Income
(89,313)
261,700
287,570
257,200
User Charges
1,688,172
360,776
3,575,000
384,911
Meters
44,946
13,000
13,000
13,000
Miscellaneous
1,476,624
1,500,300
1,438,641
1,702,368
Total Revenues:
31,222,840
33,719,934
36,915,224
43,251,441
Other Financing Sources
-
OperatingTransfersln
2,427,827
2,395,289
2,793,629
1,966,317
Bond Proceeds
7,765,000
7,960,000
-
-
F.. Proceeds from Sale of Property
18,800
45,000
v Total Other Financing Sources:
10,400,461
10,355,289
2,838,629
1,966,317
Total Revenues and Other Sources:
41,623,301
44,075,223
39,753,853
45,217,758
Total Available:
95,989,402
108,670,001
104,348,631
110,691,876
Expenditures
Personal Services
7,876,259
8.686.225
8,724,425
9,250,745
Supplies and Matenals
1,479,647
1,866,335
1,855,475
1,956,834
Purchased Services
4,671,592
6,546,215
6887,186
5,265208
Other Services and Charges
7,663,305
15,465,310
11,965,360
16,466,737
Capital Outlay
3,129,784
2,819,000
2,457,333
14,046,000
Debt Service
4,146,210
4,146.041
4,191,105
5,175,398
Total Operating Expenditures:
28,966,797
39,529,126
36,080,884
52,160,922
Other Uses
Operating Transfers Out
2,427,827
2,395,289
2,793,629
1,966,317
Total Other Uses:
2,427,827
2,395,289
2,793,629
1,966,317
Total Expenditures and Other Uses:
31,394,624
41,924,415
38,874,513
54,127,239
Fund Balance/Net Assets, December 31
$ 64,594,778
$ 66,745,586
$ 65,474,118
$
56,564,637
Change in Fund Balance
$ 10,228,677
$ 2,150,808
$ 879,340
$
(8,909.481)
18.81%
3.33%
1.36%
-13.61%
N
City of Andover
2023 Budget - General Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Licenses and Permits
Intergovernmental
Charges for Services
Fines
Investment Income
Miscellaneous Revenue
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses
Fund Balance, December 31
Change in Fund Balance
$ 9,654,518 $ 9,626,466 $ 9,626,466 $ 8,861,841
9,527,670
Actual
1
Adopted
1
Estimate
Adopted
1
Description
2021
2022
1 2022
2023
Fund Balance, January 1
Revenues
General Property Taxes
Licenses and Permits
Intergovernmental
Charges for Services
Fines
Investment Income
Miscellaneous Revenue
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses
Fund Balance, December 31
Change in Fund Balance
$ 9,654,518 $ 9,626,466 $ 9,626,466 $ 8,861,841
9,527,670
10, 076, 370
10, 076, 370
10, 814, 789
891,762
535,500
692,400
573,000
939,174
817,284
839,347
839,907
1,036,929
799,110
907,290
839,110
53,747
50,500
46,000
45,500
(15,183)
75,000
75,000
75,000
167,318
148,300
149,780
148,300
12,601,417
12, 502, 064
12, 786,187
13, 335, 606
212,031
197,081
197,081
228,772
12, 813, 448
12, 699,145
12, 983, 268
13, 564, 378
22,467,966
22,325,611
22,609,734
22,426,219
5,421,531
5,928,069
5,925,169
6,374,964
693,444
825,015
826,515
847,544
4,297,302
4,577,595
4,547,295
4,635,276
1,491,605
1,756,414
1,753,914
1,900,309
187,618
145,000
145,000
148,000
12,091,500
13,232,093
13,197,893
13,906,093
750,000
150,000
550,000
-
12,841,500
13,382,093
13,747,893
13,906,093
$ 9,626,466
$ 8,943,518
$ 8,861,841 $
8,520,126
$ (28,052)
$ (682,948)
$ (764,625) $
(341,715)
0%
-7%
-8%
-4%
City of Andover
Special Revenue Funds
2023 Budget Summary - All Special Revenue Funds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Intergovernmental
Charges for Services
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
$ 1,007,917 $ 1,510,465 $ 1,510,465
194,718
3,166
1,231,389
15,447
910,922
2,355,642
2,355,642
3,363,559
731,616
88,978
188,607
538,893
1,548,094
305,000
1,853,094
195,000
1,790,888
1,170, 500
5,200
806,000
3,967,588
150,000
4,117, 588
5,628,053
825,896
118,820
1,813,620
658,033
30,000
3,446,369
307,400
3,753,769
195,000
1,955,000
1,184,000
4,320
$ 1,612,751
195,000
1,700,948
1,241,000
8,200
860,500 990,068
4,198,820 4,135,216
150,000
4,348,820
5,859,285
855,896
106,460
2,309,495
640,783
26,500
3,939,134
307,400
4,246,534
Fund Balance, December 31 $ 1,510,465 $ 1,874,284 $ 1,612,751
Change in Fund Balance $ 502,548 $ 363,819 $ 102,286
50% 24% 7%
4,135,216
5,747,967
924,676
117,570
629,932
740,227
1,756,000
4,168,405
308,300
4,476,705
$ 1,271,262
$ (341,489)
-21%
Actual
1
Adopted
1
Estimate
1 1
Adopted
Description
2021
2022
2022
2023
Fund Balance, January 1
Revenues
General Property Taxes
Intergovernmental
Charges for Services
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
$ 1,007,917 $ 1,510,465 $ 1,510,465
194,718
3,166
1,231,389
15,447
910,922
2,355,642
2,355,642
3,363,559
731,616
88,978
188,607
538,893
1,548,094
305,000
1,853,094
195,000
1,790,888
1,170, 500
5,200
806,000
3,967,588
150,000
4,117, 588
5,628,053
825,896
118,820
1,813,620
658,033
30,000
3,446,369
307,400
3,753,769
195,000
1,955,000
1,184,000
4,320
$ 1,612,751
195,000
1,700,948
1,241,000
8,200
860,500 990,068
4,198,820 4,135,216
150,000
4,348,820
5,859,285
855,896
106,460
2,309,495
640,783
26,500
3,939,134
307,400
4,246,534
Fund Balance, December 31 $ 1,510,465 $ 1,874,284 $ 1,612,751
Change in Fund Balance $ 502,548 $ 363,819 $ 102,286
50% 24% 7%
4,135,216
5,747,967
924,676
117,570
629,932
740,227
1,756,000
4,168,405
308,300
4,476,705
$ 1,271,262
$ (341,489)
-21%
City of Andover
Debt Service Funds
2023 Budget Summary - All Debt Service Funds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 2,099,876 $ 2,556,381 $ 2,556,381 $ 3,555,703
3,133,512
(1,694)
3,131,818
547,904
3,679,722
5,779,598
1,899,000
1,278,030
5,500
3,182,530
40,687
3,223,217
$ 2,556,381
$ 456,505
22%
3,751,062
3,751,062
908,443
4,659,505
7,215,886
2,110,000
1,246,741
4,800
3,361,541
255,988
3,617,529
$ 3,598,357
$ 1,041,976
41%
3,751,062
750
3,751,812
908,443
4,660,255
7,216,636
2,110,000
1,291,280
5,325
3,406,605
254,328
3,660,933
$ 3,555,703
$ 999,322
39%
3,766,697
3,766,697
895,300
4,661,997
8,217,700
3,125,000
1,260,998
7,200
4,393,198
4,393,198
$ 3,824,502
$ 268,799
8%
Actual
Adopted
Estimate
Adopted
Description
2021
2022
2022
2023
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 2,099,876 $ 2,556,381 $ 2,556,381 $ 3,555,703
3,133,512
(1,694)
3,131,818
547,904
3,679,722
5,779,598
1,899,000
1,278,030
5,500
3,182,530
40,687
3,223,217
$ 2,556,381
$ 456,505
22%
3,751,062
3,751,062
908,443
4,659,505
7,215,886
2,110,000
1,246,741
4,800
3,361,541
255,988
3,617,529
$ 3,598,357
$ 1,041,976
41%
3,751,062
750
3,751,812
908,443
4,660,255
7,216,636
2,110,000
1,291,280
5,325
3,406,605
254,328
3,660,933
$ 3,555,703
$ 999,322
39%
3,766,697
3,766,697
895,300
4,661,997
8,217,700
3,125,000
1,260,998
7,200
4,393,198
4,393,198
$ 3,824,502
$ 268,799
8%
City of Andover
Capital Projects Funds
2023 Budget Summary - All Capital Projects Funds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Tax Increments
Special Assessments
Intergovernmental
Investment Income
User Charges
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Bond Proceeds
r Bond Premium
Proceeds from Sale of Capital Assets
Total Other Sources:
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Other Services and Charges
Capital Outlay
Debt Service - Principal Retirement
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses
Fund Balance, December 31
$ 29,666,049
2,068,442
103,474
696,591
159,978
(65,622)
1,688,172
266,499
4,917,534
1,519,187
7,765,000
188,834
18,800
9,491,821
14,409,355
44,075,404
185,683
2,813,288
1,969,315
183,187
5,151,473
351,309
5,502,782
$ 38,572,622
$ 38,572,622
2,162,822
100,000
1,503,900
1,329,769
115,000
360,776
502,000
6,074,267
986,888
7,960,000
8,946,888
15,021,155
53,593,777
155,000
9,889,500
2,534,000
12,578,500
716,020
13,294,520
$ 40,299,257
Change in Fund Balance $ 8,906,573 $ 1,726,635
30% 4%
$ 38,572,622
2,162,822
100,000
959,500
1,381,769
141,000
3,575,000
342,361
8,662,452
1,385,228
45,000
1,430,228
10,092,680
48,665,302
30,396
6,405,500
2,175,833
8,611,729
716,020
9,327,749
$ 39,337,553
$ 764,931
2%
$ 39,337,553
2,374,598
100,000
1,963,000
8,619,954
107,500
384,911
520,000
14,069,963
708,300
708,300
14,778,263
54,115,816
10,056,000
10,288,500
20,344,500
683,945
21,028,445
$ 33,087,371
$ (6,250,182)
-16%
Actual
1
Adopted
1
Estimate
1
Adopted
Description
20
2022
2022
2023
Fund Balance, January 1
Revenues
General Property Taxes
Tax Increments
Special Assessments
Intergovernmental
Investment Income
User Charges
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Bond Proceeds
r Bond Premium
Proceeds from Sale of Capital Assets
Total Other Sources:
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Other Services and Charges
Capital Outlay
Debt Service - Principal Retirement
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses
Fund Balance, December 31
$ 29,666,049
2,068,442
103,474
696,591
159,978
(65,622)
1,688,172
266,499
4,917,534
1,519,187
7,765,000
188,834
18,800
9,491,821
14,409,355
44,075,404
185,683
2,813,288
1,969,315
183,187
5,151,473
351,309
5,502,782
$ 38,572,622
$ 38,572,622
2,162,822
100,000
1,503,900
1,329,769
115,000
360,776
502,000
6,074,267
986,888
7,960,000
8,946,888
15,021,155
53,593,777
155,000
9,889,500
2,534,000
12,578,500
716,020
13,294,520
$ 40,299,257
Change in Fund Balance $ 8,906,573 $ 1,726,635
30% 4%
$ 38,572,622
2,162,822
100,000
959,500
1,381,769
141,000
3,575,000
342,361
8,662,452
1,385,228
45,000
1,430,228
10,092,680
48,665,302
30,396
6,405,500
2,175,833
8,611,729
716,020
9,327,749
$ 39,337,553
$ 764,931
2%
$ 39,337,553
2,374,598
100,000
1,963,000
8,619,954
107,500
384,911
520,000
14,069,963
708,300
708,300
14,778,263
54,115,816
10,056,000
10,288,500
20,344,500
683,945
21,028,445
$ 33,087,371
$ (6,250,182)
-16%
City of Andover
Enterprise Funds
2023 Budget Summary - All Enterprise Funds
Statement of Revenues, Expenditures and Changes in Fund Net Assets
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Meters
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Debt Service
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
$ 10,921,894
6,740,115
(17,603)
44,946
51,674
6,819,132
148,705
$ 11,365,340
5,867,738
62,500
13,000
44,000
5,987,238
152,877
6,967,837 6,140,115
17,889,731
1,176,277
337,097
2,276,842
972,851
780,493
5,543,560
980,831
6,524,391
$ 11,365,340
Change in Unrestricted Net Assets $ 443,446
4%
17,505,455
1,319,670
506,800
2,577,222
110,000
784,500
5,298,192
965,881
6,264,073
$ 11,241,382
$ (123,958)
-1%
$ 11,365,340 $ 11,311,382
5,916,738
62,500
13,000
65,000
6,057,238
152,877
6,210,115
17,575,455
1,319,670
506,800
2,577,222
110,000
784,500
5,298,192
965,881
6,264,073
$ 11,311,382
$ (53,958)
0%
6,207,829
62,500
13,000
44,000
6,327,329
133,945
6,461,274
17,772,656
1,318,317
510,800
3,165,818
1,853,500
782,200
7,630,635
974,072
8,604,707
$ 9,167,949
$ (2,143,433)
-19%
Actual
Adopted
1
Estimate
1
Adopted
Description
2021
2022
2022
2023
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Meters
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Debt Service
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
$ 10,921,894
6,740,115
(17,603)
44,946
51,674
6,819,132
148,705
$ 11,365,340
5,867,738
62,500
13,000
44,000
5,987,238
152,877
6,967,837 6,140,115
17,889,731
1,176,277
337,097
2,276,842
972,851
780,493
5,543,560
980,831
6,524,391
$ 11,365,340
Change in Unrestricted Net Assets $ 443,446
4%
17,505,455
1,319,670
506,800
2,577,222
110,000
784,500
5,298,192
965,881
6,264,073
$ 11,241,382
$ (123,958)
-1%
$ 11,365,340 $ 11,311,382
5,916,738
62,500
13,000
65,000
6,057,238
152,877
6,210,115
17,575,455
1,319,670
506,800
2,577,222
110,000
784,500
5,298,192
965,881
6,264,073
$ 11,311,382
$ (53,958)
0%
6,207,829
62,500
13,000
44,000
6,327,329
133,945
6,461,274
17,772,656
1,318,317
510,800
3,165,818
1,853,500
782,200
7,630,635
974,072
8,604,707
$ 9,167,949
$ (2,143,433)
-19%
N
W
City of Andover
Internal Service Funds
2023 Budget Summary - All Internal Service Funds
Statement of Revenues, Expenditures and Changes in Unrestricted Net Assets
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures and Other Uses
Personal Services
Supplies and Materials
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses
$ 1,015,847 $ 963,504 $ 963,504
1,321,744
(4,658)
80,211
1,397,297
1,397,297
2,413,144
546,835
360,128
542,677
1,449,640
1,449,640
Unrestricted Net Assets, December 31 $ 963,504
Change in Unrestricted Net Assets $ (52,343)
-5%
1,433,715
4,000
1,437,715
1,437, 715
2,401,219
612,590
415,700
584,141
1,612,431
1,612,431
$ 788,788
$ (174,716)
-18%
1,433,715
4,000
21,000
1,458,715
1,458,715
2,422,219
623,690
415,700
587,941
1,627,331
1,627,331
$ 794,888
$ (168,616)
-18%
$ 794,888
1,612,630
4,000
1,616,630
1,616,630
2,411,518
632,788
480,920
604,383
1,718,091
1,718,091
$ 693,427
$ (101,461)
-13%
Actual
1
Adopted
1 1
Estimate
Adopted
Description
2021
2022
2022
2023
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures and Other Uses
Personal Services
Supplies and Materials
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses
$ 1,015,847 $ 963,504 $ 963,504
1,321,744
(4,658)
80,211
1,397,297
1,397,297
2,413,144
546,835
360,128
542,677
1,449,640
1,449,640
Unrestricted Net Assets, December 31 $ 963,504
Change in Unrestricted Net Assets $ (52,343)
-5%
1,433,715
4,000
1,437,715
1,437, 715
2,401,219
612,590
415,700
584,141
1,612,431
1,612,431
$ 788,788
$ (174,716)
-18%
1,433,715
4,000
21,000
1,458,715
1,458,715
2,422,219
623,690
415,700
587,941
1,627,331
1,627,331
$ 794,888
$ (168,616)
-18%
$ 794,888
1,612,630
4,000
1,616,630
1,616,630
2,411,518
632,788
480,920
604,383
1,718,091
1,718,091
$ 693,427
$ (101,461)
-13%
CITY OF ANDOVER
General Fund
Revenue & Expense Summary
EXPENDITURES
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested *
Budget Change (')
General Government
2017
2018
2019
2020
2021
2022
2022
2023
$
%
REVENUES
4,778,336
4,956,352
5,091,793
5,162,234
5,532,429
5,743,417
5,743,417
5,943,867
200,450
3.49%
Property Taxes
$ 8,332,634
$ 8,634,130
$ 8,864,720
$ 9,303,235
$ 9,527,670
$ 10,076,370
$ 10,076,370
$ 10,814,789
738,419
7.33%
License and Permits
546,378
562,525
855,831
892,277
891,762
535,500
692,400
573,000
37,500
7.00%
Intergovernmental Revenues
793,932
829,861
822,129
861,178
939,174
817,284
839,347
839,907
22,623
2.77%
Charges for Current Services
843,022
888,944
1,133,160
1,070,788
1,036,929
799,110
907,290
839,110
40,000
5.01%
Fines and Forfeits
75,287
73,719
62,349
47,630
53,747
50,500
46,000
45,500
(5,000)
-9.90%
Interest Income
64,751
107,560
208,957
148,974
(15,183)
75,000
75,000
75,000
0
0.00%
Miscellaneous Revenue
178,616
176,662
192,058
172,174
167,318
148,300
149,780
148,300
0
0.00%
Transfers
196,930
178,558
188,008
190,688
212,031
197,081
197,081
228,772
31,691
16.08%
TOTAL REVENUES
11,031,550
11,451,959
12,327,212
12686,944
12,813,448
12,699,145
12,983,268
13,564,378
865,233
6.66%
EXPENDITURES
General Government
2,642,223
2,748,464
2,843,957
2,906,325
3,020,260
3,504,589
3,475,939
3,812,860
308,271
8.80%
N
A Public Safety
4,778,336
4,956,352
5,091,793
5,162,234
5,532,429
5,743,417
5,743,417
5,943,867
200,450
3.49%
Public Works
2,854,540
3,158,490
3,148,743
3,314,542
3,522,626
3,888,159
3,882,609
4,058,766
170,607
4.39%
Other
764,875
241,940
15,001
1,012,778
766,109
245,928
645,928
90,600
(155,328)
-63.16%
TOT AL EXPENDITURES
11,039,974
11105,246
11,099,494
12,395,879
12,841424
13,382,093
13747,893
13906,093
524,000
3.92%
UNDER(OVER)BUDGET $ 8424 $ 346,713 $ 1,227718 $ 291,065 $ 27,976 $ 682948 $ 764,625 $ 341,715 $ 341,233
N
Ln
CITY OF ANDOVER
Revenue Comparison - General Fund
City of Andover
Actual
Actual
Actual
Budget
Estimate
Budget
2019
2020
2021
2022
2022
2023
REVENUES
Permits
Property Taxes
$ 8,864,720
$ 9,303,235
$ 9,527,670
$ 10.076,370
$ 10,076,370
$ 10,814,789
License and Permits
855,831
692,277
891,762
535,500
692,400
573,000
Intergovernmental Revenues
822,129
861,178
939,174
817,284
839,347
839,907
Charges for Services
1,133,160
1,070,788
1,036,929
799,110
907,290
839,110
Fines and Forfeits
62,349
47,630
53,747
50.500
46,000
45,500
Interest Income
208,957
148,974
(15,183)
75,000
75,000
75,000
Miscellaneous Revenue
192,058
172,174
167,318
148,300
149,780
148,300
Transfers
188,008
190,688
212,031
197,081
197,081
228,772
TOTAL REVENUES
$ 12,327.212
$ 12,686,944
$ 12,813,448
$ 12,699,145
$ 12,983,268
$ 13,564,378
City of Andover
2023 Revenue Comparison - General Fund
Prop
rty Taxes
Licenses
Permits
Inte
oYl Rev
Charge
for Svcs ---
Fines
Fo ei s
Rev
Inlere
ncome
Asc.
Transfers
$2.00 $0.00 $2.00 $4.00 $6.00 $8.00 $10.00 $12.00
lions
0 Budget 2023 ■ Estimate 2022 0 Actual 2021 0 Actual 2020 • Actual 2019
City of Andover
2023 Revenue by Source -General Fund
Misc. Rev
1 % Interest income
Transfers
1%
2%
Fines &Forfeits
0%
Charges for Svcs
6%
IntargoJl Rev
6%
Licenses &
Permits
4%
Propert
Rev
N
T
EXPENDITURES
General Government
Public Safety
Public Works
Other
r -Ci rY/d��49q:17Y1q:��.
CITY OF ANDOVER
Expenditure Comparison - General Fund
Actual
Actual
Actual
Budget
Estimate
Budget
2019
2020
2021
2022
2022
2023
$ 2,843.957
26%
$ 2,906,325
23%
$ 3,020,260
24%
$ 3,504,589
26%
$ 3.475,939
25%
$ 3,812,860
27%
5,091,793
46%
5,162,234
42%
5,532,429
431/6
5.743,417
43%
5,743,417
42%
5.943,867
43%
3,148,743
28%
3,314,542
27%
3,522,626
27%
3,888,159
29%
3,882,609
28%
4,058,766
29%
15,001
0%
1,012,778
8%
766,109
6%
245,928
2%
645,928
5%
90,600
1%
$ 11,099,494
$ 12,395,879
$ 12,841,424
$ 13,382,093
$ 13,747,893
$ 13,906,093
City of Andover
2023 Expenditure Comparison -General Fund
General Govt
Public Safety
Public Works
1
Other
$0.00 $1.00 $2.00 $3.00 $4.00 $5.00 $6.00 $7.00
Millions
0 Budget 2023 0 Estimate 2022 0 Actual 2021 0 Actual 2020 a Actual 2019
City of Andover
2023 Expenditures by Function - General Fund
General Go,
27%
Other
1%
PLAAC Safety
43
blic Works
29%
CITY OF ANDOVER
General Fund - Expenditure Budget Summary Totals - By Department
Budget Year 2023
PUBLICSAPETY
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested*
Change (*)
N Police Protection
2017
2018
2019
2020
2021
2022
2022
2023
$
%
GENERAL GOVERNMENT
1,353,209
1,445,167
1,391252
1,508,854
1,706,876
1,841,166
1,841,166
1,992,865
151,699
8.24%
Mayor and Council
$ 84,136
$ 87,813
$ 99,001
$ 95,519
$ 95,658
$ 107,347
$ 102,347
$ 110,104
2,757
2.57%
Administration
187,514
198,945
211,898
187,758
229,314
238,442
236,842
297,277
58,835
24.67%
Newsletter
25,287
17,770
24,413
22,156
22,945
27,300
29,000
30,000
2,700
9.89%
Human Resources
15,520
13,666
15,842
16,181
20,836
34,661
34,661
35,458
797
2.30%
Attorney
188,644
188,031
191,782
195,721
199,809
212,041
212,041.
219,221
7,180
3.39%
City Clerk
147,450
149,769
160,184
166,221
175,177
185,278
185,278
196,235
10,957
5.91%
Elections
17,852
50,629
20,452
91,643
20,260
77,188
77,188
85,140
7,952
10.30%
Finance
258,883
272,851
280,199
294,501
307,009
337,466
334,716
355,854
18,388
5.45%
Assessing
147,915
149,040
149,033
154,482
128,829
161,000
140,000
161,000
0
0.00%
Information Services
149,512
171,637
169,827
187,703
185,642
226,601
226,601
242,922
16,321
7.20%
Planning & Zoning
398,780
422,983
412,282
453,133
491,395
526,669
526,669
567,673
41,004
7.79%
Engineering
511,183
527,688
561,642
566,224
594,720
652,908
652,908
741,037
88,129
13.50%
Facility Management
509,547
497,642
547,402
475,083
548,666
717,688
717,688
770,939
53,251
7.42%
Total General Gov
2,642,223
2,748,464
2,843,957
2,906,325
3,020560
3,504,589
3,475,939
3,812,860
308,271
8.80%
PUBLICSAPETY
N Police Protection
2,962,551
3,053,526
3,183,610
3,114,623
3,287,046
3,337,486
3,337,486
3,347,315
9,829
0.29%
V Fire Protection
1,353,209
1,445,167
1,391252
1,508,854
1,706,876
1,841,166
1,841,166
1,992,865
151,699
8.24%
Protective Inspection
443,712
436,790
493,955
519,183
519,787
529,812
529,812
559,182
29,370
5.54%
Emergency Management
16,320
18,060
18,608
17,227
15,203
29,003
29,003
33,555
4,552
15.69%
Animal Control
2,544
2,809
4,368
2,347
3,517
5,950
5,950
10,950
5,000
84.03%
Total Public Safety
4,778,336
4,956,352
5,091,793
5,162,234
5,532,429
5,743,417
5,743,417
5,943,867
200,450
3.49%
PUBLIC WORKS
Streets and Highways
597,963
656,194
615,450
686,978
804,392
868,864
868,864
915,356
46,492
5.35%
Snow and Ice Removal
449,881
599,029
703,647
496,668
540,226
702,923
707,373
774,897
71,974
10.24%
Street Signs
214,540
206,890
202,996
257,281
196,782
230,094
230,094
212,254
(17,840)
-7.75%
Traffic Signals
36,151
33,857
26,422
23,045
33,362
40,000
40,000
44,000
4,000
10.00%
Street Lighting
27,735
32,829
32,716
34,211
36,533
40,400
40,400
42,400
2,000
4.95%
Street Lights - Billed
144,451
142,937
145,604
152,181
156,841
180,500
180,500
180,500
0
0.00%
Park & Recreation
1,207,360
1,282,414
1,180,502
1,426,233
1,505,145
1,573,086
1,573,086
1,637,954
64,868
4.12%
Natmsl Resource Preservatim
6,503
5,158
16,831
9,821
9,738
14,311
14,311
13,398
(913)
-6.38%
OTHER 764,875 241,940 15,001 1,012,778 766,109 245,928 645,928 90,600 (155,328) -63.16%
Total Other 764,875 241,940 15,001 1,012,778 766,109 245,928 645,928 90,600 (155,328) -63.16%
GRAND TOTAL $ 11,039,974 $ 11,1059246 $ 11,099,494 $ 12,395,879 $ 12,841,424 $ 13,382,093 $ 13,747,893 $ 13,906,093 524,000 3.92%
N
00
MUNICIPALITIES
WITHIN ANOKA
COUNTY
Proposed
2023 City
Tax Rate Comparison
Municipalities
Only
Hilltop
98.86
Columbia
Heights
59.533
St. Francis
49.51
ColumbusJ:V�
45.711
Circle Pines4.038
Fridley.685
Lexington313
Centerville81
Ramsey79
NSpring Lake
Z Park
3
0 Bethel
3(.74
moon
Rapids
35.3
39
Lino Lakes
35.3
57
Blaine
32.131
East Bethel
31.749
Andover
30.814
Anoka
30.738
Nowthen
20.703
Ham Lake
20.144
Linwood
19.985
Oak Grove
19.781
0 20 40 60 80 100 120
TAX RATE
N
tD
CITY OF ANDOVER
2023 Proposed Tax Rate Breakdown
Other
School District 3.728% County
19.170% 33.866%
City
43.236%
PERCENTAGES ARE PROPORTIONAL TO REFLECT 100% RATHER THAN ACTUAL AMOUNT OF 71.269%.
w
0
CITY OF ANDOVER
2023 General Fund Revenue Types
Intergovernmental FinPc R FnrFaitc
Miscellane
1%
License & Permits
4%
Property Taxes
80%
CITY OF ANDOVER
2023 General Fund Expenditures by Function
Other
0.7% General Government
Public Works 27.4%
29.2%
w
r
Public Safety
42.7%
IW
N
Engineering
19.4%
CITY OF ANDOVER
General Fund - General Government Expenditures
Facility MgmtA
20.2%
Council
2.9%
Administration
rine NP.WSIP.ttP.r
Planning & Zoning Information Systems
14.9% 6.4%
Human Resources
0.9%
Attorney
5.7%
City Clerk
5.1%
Elections
2.2%
Finance
9.3%
Assessing
4.2%
w
w
Fire Protection
33.5%
CITY OF ANDOVER
General Fund - Public Safety Expenditures
Fmcrnonr�i �Ao nonom cn# Animal (.nntrnl
roiice rrotection
56.3%
w
A
Natural Resource
Preservation
0.3%
Parks & Recreation
40.4%
CITY OF ANDOVER
General Fund - Public Works Expenditures
Recycling
r 5.9%
Street Lights - Billed
4.4%
Streets & Highways
22.6%
-*,,— Street Signs
Street Lighting Traffic Signals 5.2%
1.0% 1.1%
Snow & Ice
19.1%
ANL6, W'k J
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Councilmembers
FROM: Jim Dickinson, City Administrato
SUBJECT: October 2022 Andover Community Cen er Update
DATE: November 22, 2022
Attached for Council review is the Andover Community Center (ACC) Budget Summary Report
for Budget Year 2022. The reports reflect activity through September 2022, comparative data with
September 2021 and the entire year of 2021.
September 2022 Financials
Coming off 2020 imposed COVID restrictions shutting down the entire facility mid-March of
2020, the facility was allowed to reopen in a restricted capacity early January 2021. The ACC
operated at near full capacity for close to twelve months in 2021 making current year (2022)
activities comparable to the previous year.
2022 Revenues are just slightly ahead in comparison to 2021, this is due to assorted reasons
attributed to turf usage vs ice, fieldhouse usage, vending machine use, a large donation and
payment timing. Ice Rental to date is less in 2022 versus 2021 primarily due to the Sports Complex
ice was not converted to turf in 2021. The 2022 expenses are ahead of 2021 primarily in salaries
and operating costs. 2022 Full capacity reflects additional utility costs and hiring challenges which
required the use of more full-time staffing overtime hours rather than the use of part-time staffing
for the first three month of 2022. In addition, 2022 has a Capital Outlay line item (tied to a
donation) where 2021 did not.
Also provided is an ACC historical perspective of actual costs dating back to 2015. This is the
reporting previously provided to the ACC Advisory Commission. This report also provides history
on debt service payments and the property tax levy assigned to debt and operations.
PROGRAMS/ACTIVITIES-
ACC staff has switch gears into the busy fall now winter season, but over the summer ACC
hosted several large weekend events on the main rink and the Sports Complex (Jr Hockey tryout
camps and youth hockey tournaments).
The fieldhouse hosted a MN Timberwolves camp, Fun Fest Craft Show, Jut Between Friends
Sale, and the Andover Fire Open House.
The ACC was selected to host the U.S. Hockey Hall of Fame Museum Women's Face -Off
Classic on November 7, 2022 (University of Minnesota vs. St. Cloud State University). ACC
staff spent a lot of time preparing for and did an exceptional display of the ACC and provided a
wonderful experience for the teams and spectators.
ACC hosted the MN Hockey Tier One Girls Invitational on Oct 21-23. Eight teams from MN
along with another sixteen teams from all over the US, including Boston, Chicago, Detroit,
Philadelphia, Wisconsin, Arizona, North Dakota, California, etc.
Pickleball has returned. ACC has been offering pickleball lessons and skills and drills sessions
since September.
Fall ACC programs were very strong. Skating Lessons and Indoor Soccer both filled with well
over one hundred participants each.
High School Hockey has started in early November with the first games later in the month.
Mn Premier Volleyball has started in November as well as Andover Athletic Association Girls
Basketball.
Election Day was hosted at the ACC for two precincts on November 8th.
CONCESSIONS -
After a Request for Proposal (RFP) process in March — May, the Council approved Crooked Lake
Concessions as our selected vendor and a lease was approved at the May 17`h Council meeting.
Crooked Lake Concessions ordered and installed materials for the space.
Concessions opened mid-September and has been well received. ACC shares event schedules
monthly to help coordinate staffing and inventory needs.
STAFFING -
The ACC is at full complement of approved fulltime staffing.
All around, ACC staffing is in decent shape. ACC continues to look for additional part-time
staffing as we enter the 2022 -2023 busy season.
SCHEDULING -
Scheduling for the 2022-23 busy season is complete. ACC is in continual contact with all our user
groups to better understand how we can better address their needs. ACC also continues to look to
fill off season times and fine tune our spring turf season. Also, ACC is in the process of migrating
to new scheduling software.
Informational. Council is requested to review the staff report and attached reports.
Attachments
CITY OF ANDOVER
Community Center Budget Summary Totals
Budget Year 2022
Current
2021
2022
REVENGES
Budget
Oct YTD
%Bud
Audit
Budget
Oct YTD
%Bud
Departmental
Charges for services
62,798
60%
82,655
97,100
75,935
78%
Operating
Ice Rental
$ 668,000
$ 510,357
76%
$ 823,856
$ 729,000
$ 463,715
64%
Turf Rental
70,000
3,782
v/a
3,782
50,000
18,553
37%
Tack
-
2,617
Na
3,950
2,500
3,950
da
Fieldhouse Rental
270,000
164,117
61%
220,527
240,000
228,901
95%
Proshop
15,000
5,667
38%
9,606
13,000
8,460
65%
Vending
16,000
5,084
32%
7,763
15,000
16,249
108%
Advertising
50,000
75,752
152%
84,700
63,000
94,606
150%
Total Charges for services
1,089,000
767,376
70%
1,154,184
1,112,500
834,434
75%
Miscellaneous
140,000
81,543
58%
134,072
182,000
160,646
88%
(300,000)
(300,000)
100%
(300,000)
(300,000)
(300,000)
100%
Total financing sources(uses)
Total revenues
1,229,000
848,919
69%
1,288,256
1,294,500
995,080
77%
fund balance $
69.575
$ 245.101
2021
$ 404.79R A
26.532 $
9n R67
id9 L.
2022
EXPENDITURES
Budget
Oct YTD
%Bud
Audit
Budget
Oct YTD
%Bud
Current
Salaries & benefits
757,753
527,212
70%
692,742
770,110
650,448
84%
Departmental
105,100
62,798
60%
82,655
97,100
75,935
78%
Operating
635,197
372,201
59%
515,308
603,233
430,083
71%
Professional services
154,375
57,949
38%
85,130
248,525
130,628
53%
Capital outlay
Na
42,000
37,358
89%
Current
1,652,425
1,020,160
62%
1,375,835
1,760868
1,324,452
75%
Revenue over(under) expense
(423,425)
(171,241)
40%
(87,579)
(466,468)
(329,372)
7l%
Other financing sources (uses)
Geneml Property Tax Levy
155,000
80,723
52%
154,534
155,000
81,815
53%
Investment income
-
1,137
n/a
2,817
-
2,012
da
Rental/Lease Pymt
638,000
634,482
99%
635,026
638,000
636,412
100%
Transfers out
(300,000)
(300,000)
100%
(300,000)
(300,000)
(300,000)
100%
Total financing sources(uses)
493,000
416,342
84%
492,377
493,000
420,239
85%
Ne[increase (decrease)in
fund balance $
69.575
$ 245.101
352%
$ 404.79R A
26.532 $
9n R67
id9 L.
CITY OF ANDOVER, MINNESOTA
Andover Community Center / YMCA Historical Comparison
Debt Service Payments
2012C GO Abatement Bonds (P+I)
2015
2016
$
2017
$
2018
$
2019
$ 1,208,931
2020
1,215,981
2021
1,212,631
2022
2022
2019A GO Abatement Bonds (P +
Actual
Actual
Actual
Actual
Actual
Actual
590,150
Actual
819,725
Budget
Oct - YTD
Revenues:
$
1,214,906
$
1,2(6,506
$
],213,731
$
1,211,481
$ 1,208,931
$
1,806,131
$
2,032,356
$ 2,323,686
$ 2,323,686
Charges for services
Ice Rental
$ 400,619
$ 405,990
$
392,828
$
435,716
$
442,995
$
361,796
$
823,856
$
729,000
$ 463,715
Turf Rental
-
-
-
-
-
-
-
1,001,090
3,782
976,966
50,000
18,553
Track
-
-
-
-
-
301
3,950
155,000
2,500
3,950
Fieldhouse Rental
187,007
199,286
$
215,089
$
218,667
$
220,225
$ 969,378
133,126
1,977,870
220,527
2,105,229
240,000
228,901
Proshop
9,258
9,412
9,247
8,606
9,680
4,394
9,606
13,000
8,460
Vending
9,279
8,588
9,182
7,470
8,427
6,148
7,763
15,000
16,249
Advertising
31,758
26,450
38,819
34,000
40,850
8,000
84,700
63,000
94,606
Charges for services
637,921
649,726
665,165
704,459
722,177
513,765
1,154,184
1,112,500
834,434
Miscellaneous
174,788
136,552
136,149
142,768
131,386
110,781
134,072
182 000
160,646
Total revenues
812,709
786,278
801,314
847,227
853,563
624,546
1,288,256
1,294,500
995,080
Expenditures:
Current:
Salaries & benefits
439,304
451,332
481,926
501,108
533,044
503,842
692,742
770,110
650,448
Departmental
74,949
77,945
65,612
76,448
66,570
74,809
82,655
97,100
75,935
Operating
388,492
364,935
3645242
352,067
330,084
345,588
515,308
603,233
430,083
Professional services
142,602
106,381
125,034
104,076
77,818
129,261
85,130
248,525
130,628
Capital outlay
47,859
4,900
11,442
39,888
100,000
42,000
37,358
Current
1,045,347
1,048,452
1,041,714
1,045,141
1,047,404
1,153,500
1,375,835
1,760,968
1,324,452
Revenue over under expenditures;
(232,638)
(262,174)
(240,400)
(197,914)
(193,841)
(528,95
(87,579)1
466 468
329 372
Other financing sources (uses)
General Property Tax Levy
-
-
-
-
-
-
154,534
155,000
81,815
Investment income
(1,078)
2,190
2,779
5,780
16,107
6,793
2,817
-
2,012
Rental / Lease Pymt
638,220
640,303
641,691
637,150
636,803
635,629
635,026
638,000
636,412
Transfers out
(300,000)
(300.000)
(300,000)
(300,000)
(300,000)
(300,000)
(300,000)
(300,000)
(300,000)
Total financing sources (uses)
337,142
342,493
344,470
342,930
352,910
342,422
492,377
493,000
420,239
Net increase (decrease) in fund balance
104,504
80,319
104,070
145,016
159,069
(186,532)
404,798
26,532
90,867
Fund balance (deficit)- January 1
(48,364)
56,140
136,459
240,529
385,545
544,614
358,082
762,880
762,880
Fund balance (deficit) - December 31
$ 56,140
$ 136,459
$
240,529
$
385,545
$
544,614
$
358 082
$
762,880
$
789,412
$ 853,747
Fund Balance Detail:
FB- Replac Res for Common Space
$ 143,702
$ 154,449
$
179,283
$
173,560
$
200,606
$
190,067
$
216,790
$
241,790
$ 241,790
FB - Unassigned
(87,562)
(17,990)
61,246
211,985
344,008
168,015
546,090
547,622
611,957
_S56
$ 136,459
$
240,529
$
385,545
$
544,614
$
358,082
$
762,880
$
789412
$ 853747
Debt Service Payments
2012C GO Abatement Bonds (P+I)
$
1,214,906
$
1,216,506
$
1,213,731
$
1,211,481
$ 1,208,931
$
1,215,981
$
1,212,631
$ 1,213,931
$ 1,213,931
2019A GO Abatement Bonds (P +
590,150
819,725
1,109,755
1,109,755
$
1,214,906
$
1,2(6,506
$
],213,731
$
1,211,481
$ 1,208,931
$
1,806,131
$
2,032,356
$ 2,323,686
$ 2,323,686
Property Tax Levy
2012C GO Abatement Bonds
$
975,632
$
977,332
$
974,418
$
972,055
$ 969,378
$
976,780
$
973,263
$ 974,628
$ 974,628
2019A GO Abatement Bonds
-
-
-
-
-
1,001,090
976,966
1,014,065
1,014,065
Community Center Operations
155,000
1552000
155,000
$
975632
$
977,332
$
974,418
$
972,055
$ 969,378
$
1,977,870
$
2,105,229
$ 2,143,693
$ 2,143,693
1-41
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Councilmembers
FROM: Jim Dickinson, City Administrator
SUBJECT: October 2022 General Fund Budget Progress Report
DATE: November 22, 2022
INTRODUCTION
The City of Andover 2022 General Fund Budget (as amended) contains total revenues of $12,759,623
and total expenditures of $13,911,071 (as amended); a decrease in fund balance is planned.
Monthly reporting of the City Budget progress to the Governing body is a recommended financial
practice and often viewed positively by rating agencies.
DISCUSSION
Attached is the General Fund Revenue & Expenditure Budget Summary - Budget Year 2022,
reflecting year to date actual through October 2022.
The following represents Administration's directives and departmental expectations for 2022:
1. Expenditure budgets while approved, expenses are to meet with the spirit that needs are
fulfilled first, expansions of service and special requests are to be reviewed with City
Administration before proceeding.
2. Departments are to be committed to search for the best possible prices when purchasing goods
and services.
3. Departments are to be committed to continually searching out new efficiencies and to
challenge the status quo of how the City provides services.
4. Departments are to be committed to searching out collaborative opportunities to facilitate
efficient and cost-effective utilization of governmental assets and personnel.
5. Departments are to be committed to developing effective, consistent and ongoing
communications with City residents, businesses and other stakeholders.
6. Departments are to be cognizant that services provided are subject to available revenues and
should not commit to services that are not sustainable.
ACTION REQUESTED
Informational, review and receive brief presentation of the October 2022 General Fund Budget
Progress Report.
CITY OF ANDOVER
General Fund Budget Summary Totals
Budget Year 2022
2021 2022
REVENUES Budget Oct YTD %Bud Audit Budget Oct YTD %Bud
General Property Tax
$ 9,594,493
$ 4,989,624
52%
$ 9,527,670
$ 10,076,370
$ 5,283,227
52%
Licenses and Permits
436,450
724,378
166%
891,762
535,500
809,107
151%
Intergovernmental
938,041
876,223
93%
939,174
877,762
638,710
73%
Charges for Services
752,360
847,774
113%
1,036,929
799,110
1,073,003
134%
Fines
50250
41,786
83%
53,747
50,500
42,323
84%
Investment Income
75,000
31,487
42%
(15,184)
75,000
9,194
12%
Miscellaneous
138,850
143,162
103%
167,318
148,300
160,152
108%
Transfers In
212,031
212,031
100%
212,031
197,081
197,081
100%
Total Revenues
$ 12,197,475
$ 7,866.465
64%
$ 12,813,447
$ 12,759,623
$ 8,212,797
64%
2021 1 2022
EXPENDITURES Budget Oct YTD %Bud Audit Budget Oct YTD %Bud
GENERAL GOVERNMENT
Mayor and Council
$ 108,015
$ 85,153
79%
$ 95,659
$ 107,347
$ 84,538
79%
Administration
236,244
187,221
79%
229,314
238,442
204,298
86%
Newsletter
25,000
22,687
91%
22,945
27,300
20,062
73%
Human Resources
35,202
22,259
63%
20,836
34,661
21,738
63%
Attorney
206,941
149,909
72%
199,809
212,041
154,641
73%
City Clerk
176,206
148,280
84%
175,177
185,278
153,710
83%
Electiona
74,212
17,429
23%
20260
77,188
47,244
61%
Finance
320,768
272,538
85%
307,009
337,466
281,199
83%
Assessing
161,000
128,829
80%
128,829
161,000
131,097
81%
Information Services
213,738
155,700
73%
185,642
226,601
190,395
84%
Planning & Zoning
504,204
401,554
80%
491,395
526,669
408,059
77%
Engineering
631,401
496,697
79%
594,717
652,908
544,775
83%
Facility Management
713,197
456,371
64%
548,747
742,688
448,218
60%
Total General Gov
3,406,128
2,544,627
75%
3 020 39
3,529,589
2 689 974
76%
PUBLICSAFETY
Police Protection
3,287,046
3,287,046
100%
3,287,046
3,296,486
3,261,423
99%
Fire Protection
1,711,769
1,403,238
82%
1,706,875
1,942,644
1,395,081
72%
Protective Inspection
533,561
417,332
78%
519,787
529,812
378,772
71%
Civil Defense
26,844
10,877
41%
15,202
29,003
10,722
37%
Animal Control
5,950
2,757
46%
3,517
5,950
2,684
45%
Total Public Safety
5,565,170
5121 50
92%
5,532,427
5,803,895
5,048,682
87%
PUBLIC WORKS
Streets and Highways
788,241
671,741
85%
805,391
868,864
651,805
75%
Snow and Ice Removal
675,888
399,169
59%
540,226
702,923
530,077
75%
Street Signs
240,842
166,953
69%
195,783
230,094
160,553
70%
Traffic Signals
40,000
27,520
69%
33,362
40,000
19,587
49%
Street Lighting
40,400
27,461
68%
36,533
40,400
26,914
67%
Street Lights - Billed
180,500
117,550
65%
156,841
180,500
117,818
65%
Park & Recreation
1,560,640
1,277,606
82%
1,505,145
1,613,086
1,248,291
77%
Natural Resource Preservation
13,383
5,926
44%
9,738
17,811
11,732
66%
Recycling
233,759
205,500
88%
239,606
237,981
157,160
66%
Total Public Works
3,773,653
2,899,426
77%
3522,625
3,931,659
2,923,937
74%
OTHER
Miscellaneous
806,828
754,459
94%
757,109
609,328
556,748
91%
Youth Services
39,100
9,000
23%
- 9,000
36,600
9,000
25%
Total Other
845.928
763,459
90%
766,109
645,928
565,748
88%
Total Expenditures $
13,590,879
$ 11,328,762
83%
S 12,841,500
$ 13,911,071
$ 11,228,341
81%
NETINCREASE(DECREASE) $
(1,393,404)
$ (3,462,297)
$ (28,053)
$ (1,1519448)
S (3,015,544)
F-^;^;^NDOVE
•
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 . WWW.ANDOVERMN.GOV
TO: Mayor and Councilmembers
FROM: Jim Dickinson, City Administrator
SUBJECT: October 2022 City Investment Reports
DATE: November 22, 2022
INTRODUCTION
Summary reporting of the City Investment portfolio to the Governing body is a recommended
financial practice and often viewed positively by rating agencies.
Furthermore, the City of Andover Investment Policy recommends the Finance Director presents
to the City Council at least quarterly the type of investments held by the City.
DISCUSSION
Attached is the Investment Maturities Summary for October 2022, the October 2022
Investment Detail Report, and the October 2022 Money Market Funds Report. These
attachments are intended to provide a status report on the October 2022 investments.
ACTION REQUESTED
Informational, Council requested to receive a brief presentation of the October 2022 Investment
Reports.
submitted,
1i M44
Investment Maturities - October 2022
Credit
Investment Type Rating % of Total
Investment Maturities (in Years)
Fair Less Than More Than
Value 1 1 - 5 6-10 10
Money market funds (WF)
N/A
4.10%
$ 2,515,593
$ 2,515,593
$
$ $
MN Municipal Money
Market Fund (4M)
N/A
2.16%
1,324,896
1,324,896
Certificates of deposit
FDIC
20.54%
12,599,635
7,018,008
5,581,627
Local governments
A/Al/A2
0.10%
59,698
59,698
-
AA/AAl/AA2/AA3
13.13%
8,055,038
1,169,167
6,188,330
697,541
AAA
12.10%
7,418,792
1,439,838
5,321,492
657,462
State governments
A/Al/A2
0.00%
-
-
-
-
AA/AAl/AA2/AA3
1.65%
1,014,023
-
1,014,023
AAA
1.47%
904,078
440,747
463,331
-
U.S. agencies
AAA
44.74%
27,443,355
12,856,233
14,060,071
527,051
Total investments
100.00%
$ 61,335,107
$ 26,824,180
$ 32,628,873
$ 1,882,054 $
Deposits
1,027,711
Total cash and investments
$ 62,362,818
October 2022 Investment Detail
Description
Cusip
Number
Cred t
RatinglF Type
DIC #
Purchase Price Carrying Cost
I
Maturity
Amount
Interest
Rate
Current Market
Value
Date
Acquired
Coupon
Date
Maturity I
Due Date
First Comm Bk USA
31984WAP9
34496 CD
245,000.00 245,000.00
245,000.00
0.140%
244,625.15
maturity 11/18/21
none
11/18/22
Webbank
947547NP6
34404 CD
245,000.00 245,000.00
245,000.00
0.150%
244,627.60
maturity 11/19/21
none
11/18/22
New York Community Bank
649447UF4
16022 CD
245,000.00 245,000.00
245,000.00
0.200%
244,125.35
semi-annual 12/11/20
06/11/21
12112122
Medallion Bank Utah
58404DMMO
57449 CD
245,000.00 245,000.00
245,000.00
0.250%
244,039.60
maturity 12/16121
none
12116122
Beal Bank - Plano TX
07371ATD5
32574 CD
245,000.00 245,000.00
245,000.00
0.250%
243,922.00
maturity 12/22121
none
12/21/22
Texas Bank Financial
882213AH4
26967 CD
245,000.00 245,000.00
245,000.00
0.150%
243,841.15
semi-annual 12/23/20
06/23/21
12/23/22
Bank of India
06279KZ33
33648 CD
245,000.00 245,000.00
245,000.00
0.750%
243,946.50
maturity 03/31/22
none
12/28/22
First Nail Bk of America
32110YUW3
17438 CD
245,000.00 245,000.00
245,000.00
0.250%
243,728.45
maturity 12/30/21
none
12129/22
Wells Fargo Bank
949763W93
3511 CD
245,000.00 245,000.00
245,000.00
2.1500/a
244,218.45
maturity 07/15/22
none
01/17/23
Meridian Bank
58958PJF2
57777 CD
245,000.00 245,000.00
245,000.00
0.250%
243,142.90
maturity 01/21/22
none
01/20/23
First Svgs Bank
33621LFB4
29961 CD
245,000.00 245,000.00
245,000.00
2.150%
244,125.35
maturity 07/22/22
none
01/23/23
Wood America Bank
981059CCO
24920 CD
245,000.00 245,000.00
245,000.00
2.150%
244,125.35
maturity 07/22/22
none
01/23/23
Pacific Western Bk
69506YSM2
24045 CD
245,000.00 245,000.00
245,000.00
1.000%
243,380.55
maturity 04/27/22
none
01/27/23
Academy Bank NA
0040008,13
19600 CD
245,000.00 245,000.00
245,000.00
0.150%
242,812.15
semi-annual 07/28/21
01/28122
01/30/23
Bank Hapoalim BM NY
06251A2T6
33686 CD
245,000.00 245,000.00
245,000.00
0.150%
242,341.75
semi-annual 07/14/21
08/16121
02/16/23
Guthrie County State Bank
40341PAZ1
226 CD
245,000.00 245,000.00
245,000.00
0.9501/6
241,905.65
maturity 03/31/22
none
03/31/23
Equity Bank Kansas
29461MAC6
25858 CD
245,000.00 245,000.00
245,000.00
1.150%
241,631.25
maturity 04/20/22
none
04/20/23
Mizuho Bank USA
60688M7G3
21843 CD
245,000.00 245,000.00
245,000.00
2.350%
242,998.35
maturity 07/20/22
none
04120/23
Bank Baroda NY Branch
06063HNG4
33681 CD
245,000.00 245,000.00
245,000.00
1.550%
241,971.80
maturity 04/27/22
none
04/25123
Flagstar Bank FSB
33847E41.8
32541 CD
245,000.00 245,000.00
245,000.00
0.150%
239,316.00
semi-annual 05/28/21
11/28/21
05/30/23
Fifth Third Bank
316777XT3
6672 CD
245,000.00 245,000.00
245,000.00
2.450%
242,064.90
maturity 06/23/22
none
06/23/23
Bank of the Sierra
06486OLH0
22597 CD
245,000.00 245,000.00
245.000.00
0.200%
238,463.40
semi-annual 12/29/20
06/29/21
06/29/23
Stanon Financial
85528WDY6
33758 CD
245,000.00 245,000.00
245,000.00
2.800%
242,192.30
maturity 07/20/22
none
07/20/23
State Bank of India
856285WF4
682 / 33E CD
245,000.00 245,000.00
245,000.00
0.250%
237,806.80
semi-annual 07/21/21
01/21/22
07/21/23
CapstarBank
14069HAWI
58823 CD
245,000.00 245,000.00
245,000.00
2.600%
241,780.70
maturity 07/22/22
none
07/24/23
Envision Bank
29415LBZ3
90270 CD
245,000.00 245,000.00
245,000.00
0.200%
237,485.85
semiannual 07/28/21
01/28/22
07/28/23
Industrial & Com Bk
45581 ECP4
24387 CD
245,000.00 245,000.00
245,000.00
0.250%
236,927.25
semi-annual 08/20/21
02/20/22
08/18/23
Synovus Bank
87164DSR2
873 CD
245,000.00 245,000.00
245,000.00
1.000%
238,218.40
semi-annual 02/25/22
08/25/22
08/25/23
Morgan Stanley Bank NA
61773TDD2
32992 CD
245,000.00 245,000.00
245,000.00
1.250%
238,242.90
semiannual 03/31/22
09/29/22
09/29/23
Kaufman TX
486206KR5
A3 local
61,821.00 61,821.00
60,000.00
3.000%
59,697.60
semi-annual 06/28/16
02/15117
02/15/23
Saint Anthony MN
787260R75
AA local
216,076.00 216,076.00
200,000.00
4.000%
200,432.00
semi-annual 12/11/20
none
02/01/23
Albert Lea MN
012788ZS7
AA- local
108,038.00 108,038.00
100,000.00
4.000%
100,169.00
semi-annual 12/11/20
none
02/01/23
Alexandria MN ISD #206
015131 LOS
AA1 local
279,760.50 279,760.50
270,000.00
3.000%
268,744.50
semi-annual 01/21/15
none
02/01/23
New Ulm MN
6490247D2
AA2 local
214,950.00 214,950.00
200,000.00
4.000%
200,126.00
semi-annual 12111/20
06/01/20
12/01/22
Monroe Woodbury NY
611441 PH3
AA2 local
182,928.60 182,928.60
180,000.00
1.000%
176,583.60
semi-annual 12/22/20
12/01/21
06/01/23
Monroe WI
611407KMB
AA3 local
230,769.00 230,769.00
225,000.00
1.500%
223,112.25
semi-annual 10/27/20
none
03/01/23
Outagamie Cnty WI
689900698
AAA local
85,000.00 85,000.00
85,000.00
2.350%
85,000.00
semi-annual 11/07/17
05/01/18
11/01/22
Mora MN ISO #332
616395FH7
AAA local
105,908.00 105,906.00
100,000.00
3.000%
99,922.00
semi-annual 12/11/20
none
none
02/01/23
02/01/23
Saint Michael MN
792767OH1
AAA local
105,906.00 105,906.00
100,000.00
3.000%
99,922.00
semi-annual 12/11/20
Polk Cnty IA
731197Y78
W local
302,913.00 302,913.00
300,000.00
3.000%
297,120.00
semi-annual 05/17/22
12/01/22
06/01/23
Chandler AZ
158843Yd5
AAA local
300,000.00 300,000.00
300,000.00
0.600%
292,026.00
semi-annual 12/01/21
01/01/22
07/01123
Brooks Crity TX ISD Zero Cpn
114385FSI
AAA kcal
166,230.00 166,230.00
180,000.00
1
173,142.00
maturity 11/26/19
none
06/15/23
7,018,007.85 CD
Description
Custp
Number
Number
Credit
RatinglF
DIC #
Type Purchase Price
I
Carrying Cost
Maturity
Amount
Interest
Rate
Cu
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturityl
Due Date
Hurst -Euless -Bedford Tx ISD
447819DZ3
AAA
local 106,611.00
106,611.00
100,000.00
2.825%
98,601.00
semi-annual
semi-annual
11/17/20
none
08/15/23
Hams Cnty Texas
414005SC3
AAA
local 300,960.00
300,960.00
300,000.00
2.473%
294105.00
D4/12122
04101/13
10/01/23
Georgia State
3733842Q8
AAA
state 204,444.00
204,444.00
200,000.00
2.780%
199,346.00
semiannual
12113/16
none
02/01/23
Texas Sl
882723YM5
AAA
state 250,639.90
250,639.90
245,ODO.00
2.732%
241,400.95
semi-annual
07/19/19
none
08/01/23
Fed Farm Credit Bank
3133EMGX4
AAA
US 299,784.00
299,784.00
300,000.00
0.125%
299,124.00
semi-annual
11/24/20
05123/21
11/23/22
Fed Farm Credit Bank
3133EMKH4
AAA
US 300,000.00
300,000.00
300,000.00
0.1600/6
298,428.00
semi-annual
12/15/20
06/15/21
12/15/22
Fed Home Ln Bank
313OAQGP2
AAA
US 500,155.00
500,155.00
500,000.00
0.375%
497,050.00
semi-annual
01/05/22
06/30/22
12/30/22
Fed Farm Credit Bank
3133EMML3
AAA
US 998,790.00
998,790.00
1,000,000.00
0.1200%
991,910.00
semi-annual
02/08/21
07/12/21
01/12/23
Fed Home Ln Mtg Corp Mad Term Note
3134GXFB5
AAA
US 300,000.00
300,000.00
300,000.00
0.220%
295,164.00
semi-annual
12/14/20
06/14/21
03/14/23
Fed Home Ln Bank
3130ALRG1
AAA
US 299,817.00
299,817.00
300,000.00
0.125°h
295,320.00
semi-annual
04/28/21
09/17121
03/17/23
Fed Farts Credit Bank
3133EMVP4
AAA
US 299,811.00
299,811.00
300,000.00
0.125%
294,306.00
semi-annual
04/28/21
10113/21
04/13/23
Fed Home Ln Mlg Corp
3137EAEO8
AM
US 992,270.00
992,270.00
1,000,000.00
0.375%
980,820.00
semi-annual
12/20/21
10/20/20
04/20/23
Fed Home Ln Mtg Carp
3137EAER6
AAA
US 301,452.00
301,452.00
300,000.00
0.375%
293,598.00
semi-annual
12110/20.
11/05/20
05/05/23
Fed Natl Mtg Assn
3135GO4Q3
AAA
US 800,906.00
600,906.00
600,000.00
0.250%
585,726.00
semi-annual
04/05/21
11/22/20
05/22/23
Fed Farts Credit Bank
3133ENDK3
AAA
US 498,155.00
498,155.00
500,000.00
0.350%
487,320.00
semi-annual
01/05/22
12/08/21
06/08/23
Fed Farm Credit Bank
3133EMKG6
AAA
US 300,000.00
300,000.00
300,000.00
0.200%
291,168.00
semiannual
12/15/20
06/15/21
06/15/23
Fed Home Ln Mlg Corp
3137EAES4
AAA
US 398,596.00
398,596.00
400,000.00
0.250%
388,624.00
semi-annual
12/14/21
12/26/20
06/26/23
Fed Home Ln Mlg Corp Med Tenn Note
3134GXHHO
AAA
US 300,000.00
300,000.00
300,000.00
0.220%
290,772.00
semi-annual
12/30/20
06/30/21
06/30/23
Fed Nag Mtg Assn
3135GO5G4
AAA
US 1,301,322.00
1,301,322.00
1,300,000.00
0.250%
1,260,389.00
semi-annual
07110/20
01/10/21
07/10/23
Federal Farts Credit Bank
3133ENA83
AAA
Us 500,120.99
500,120.99
200,000.00
3.000%
494,140.00
semi-annual
07/13/22
01111/23
07/11/23
Federal Home Loan Bank _ _
3130ASHV4
AAA
US 500,000.00
500,000.00
500,000.00
3.050%
492,750.00
semi-annual
06/28/22
12128/22
07/28/23
Fed Home Ln Mtg Corp
3137EAEV7
AM
US 600,456.00
600,456.00
600,000.00
0.250%
578,628.00
semi-annual
12/10/20
02124121
08/24/23
Fed Home Ln Bank
Fed Home Ln Mtg Corp
3130AJXD6
3137EAEW5
AAA
AAA
US 399,224.00
399,224.00
400,000.00
0.125%
385,160.00
semi-annual
08/13/21
03/08/21
09/08/23
US 600,567.00
600,567.00
600,000.00
0.250%
577,308.00
semi-annual
07/22/21
03/08/21
09/08/23
Fed Farts Credit Bank
Fed Farm Credit Bank
3133EL61.13
AAA
US 300,000.00
US 1,298,751.00
300,000.00
300,000.00
0.280%
288,066.00
semi-annual
09116/20
03/14121
09/14123
3133EMBSO
AAA
1,298,751.00
1,300,000.00
0.200%
1,246,791.00
semi-annual
07/22/21
64/02/21
10/02/23
Fad Home Ln Mtg Corp
3137EAEYI
AAA
US 1,294,003.00
1,294,003.00
1,300,000.00
0.125%
1,243,671.00
semi-annual
09/16/21
04/16/21
10/16/23
22,983,690.75
BMW Bank North America
05580AXY5
35141
CD 245,000.00
245,000.00
245,000.00
0.300%
233,788.80
semi-annual
12/11/20
06/11/21
12/11/23
Third Federal S&L
88413QCV8
30012
CD 245,000.00
245,000.00
245,000.00
0.250%
233,367.40
semi-annual
12121/20
06/21/21
12/21/23
Peoples Security Bank & Trust
712303AQ9
7514
CD 245,000.00
245,000.00
245,000.00
2.650%
239,761.90
semi-annual
06/24/22
12/24/22
12/26/23
Beal Bank USA
07371 DCT2
57833
CD 245,000.00
245,000.00
245,000.00
2.750%
239,700.65
semi-annual
07120/22
01/20/23
01/17/24
Apple Bank for Savings
03784JSL9
16068
CD 245,000.00
245,000.00
245,000.00
0.600%
233,455.60
semi-annual
01/21/22
07/21/22
01/22/24
Nano Banc
63008MAG6
58590
CD 245,000.00
245,000.00
245,000.00
0.200%
232,267.35
semi-annual
07/23/21
01/23/22
01/23/24
Haven Savings Bank
41939HBQ4
30039
CD 245,000.00
245,000.00
245,000.00
2.7500/6
239,399.30
semi-annual
08/10/22
02/10/23
02/09/24
Ally Bank
02007GNS8
57803
CD 245,000.00
245,000.00
245,000.00
1.300%
234,885.50
semi-annual
02/24/22
08/24/22
02123/24
Barclays Bank
06740KNV5
57203
CD 245,000.00
245,000.00
245,000.00
1.350%
234,923.15
semi-annual
02/23/22
08123/22
02123/24
OceanFirst Bank
67523TAF0
28359
CD 245,000.00
245,000.00
245,000.00
1.450%
234,955.00
semi-annual
03/08/22
09108/22
03/08/24
American Expr Nag Bank
02589ABX9
27471
CD 245,000.00
245,000.00
245,000.00
1.950%
236,106.50
semi-annual
03/30/22
09130/22
04/01/24
Capital One Bank USA NA
14042TFR3
33954
CD 245,000.00
245,000.00
245,000.00
2.550%
237,699.00
semi-annual
04/27/22
10/27/22
04/29/24
Capital One NA
14D42RQV6
4297
CD 245,000.00
245,000.00
245,000.00
2.550%
237,699.00
semi-annual
04/27/22
10127122
04/29/24
Mega Bank
58517JAH5
56401
CD 245,000.00
245,000.00
245,000.00
0.250%
229,623.80
semi-annual
04/29/21
10129/21
04/29/24
Sallie Mae Bank/Salt Lake
795450785
58177
CD 245,000.00
245,000.00
245,000.00
0.550%1
228,592.35
semi-annual
07/14/21
01/14/22
07/15/24
2,668,702.95 local
440,746.95 state
12,856,233.00 US
Less Than 1 Year
Description
Credd
CusipNumber
Number RatinglF
DIC #
Type
Purchase Price Carrying Cost
Maturity Interest
Amount Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturity)
Due Date
Synchrony Bank
87165HC32 27314
CD
245,000.00 245,000.00
245,000.00 0.550%
227,293.85
239,624.70
semi-annual
semi-annual
09/03/21
03/03/22
09/03/24
Pacific Premier Bk
694780GQ7 32172
CD
245,000.00 245,000.00
245,000.00 3.450%
09/09/22
03/09/23
09/09/24
Morgan Stanley Pvt Bank
61768U4C8 34221
CD
245,000.00 245,000.00
245,000.00 2.700%
235,670.40
semi-annual
04/29/22
10/29/22
10/29/24
Dallas Capital Bank
234553CZ6 20727
CD
245,000.00 245,000.00
245,000.00 0.700%
224,824.25
semi-annual
12/30/21
06/30/22
12/30/24
Fourth Capital Bank
35115LAE1 59101
CD
245,000.00 245,000.00
245,000.00 0.600%
224,309.75
quarterly
12/29/21
03/29/22
12/30/24
Eaglemark Savings Bank
27004PCL5 34313
CD
245,000.00 245,000.00
245,000.00 1.700%
228,736.90
semi-annual
03/02/22
09/02/22
03/03/25
BMO Hams Bank NA
0560OXCVO 16571
CD
245,000.00 245,000.00
245,000.00 0.700%
221,876.90
quarterly
04/28/21
07/28/21
04/28/25
Discover Bank
254673870 5649
CD
245,000.00 245,000.00
245,000.00 2.800%
233,984.80
semi-annual
04/27/22
10127/22
04/28/25
Toyota Financial Sgs Bk
89235MLH2 57542
CD
245,000.00 245,000.00
245,000.00 0.7000/0
219,279.90
semi-annual
08/19/21
02119122
08/19/25
Saint Joseph MN
790739YY6 AA-
local
190,000.00 190,000.00
190,000.00 0.500%
181,296.10
semi-annual
11112/20
06/01/21
12/01/23
Everett MA
299839E48 AA+
local
317,883.00 317,883.00
300,000.00 3.000%
283,599.00
semi-annual
01/25/22
07/15/22
01/15116
Snohomish Cty WI
833086CX7 AA1
local
299,604.00 299,604.00
300,000.00 0.450%
286,014.00
semi-annual
12101/21
06/01/22
12/01/23
Midland Texas
5977494118 AA1
local
354,452.60 354,452.60
370,000.00 0.613%
350,619.40
semi-annual
08/19/22
03/01/21
03/01/24
Kennebunkport Maine
489299AV9 AA1
kcal
250,000.00 250,000.00
250,000.00 3.250%
243,370.00
semi-annual
07/14/22
10/01/19
10/01/24
Austin TX
052397RE8 AA1
local
359,971.20 359,971.20
360,000.00 2.124%
326,786.40
semi-annual
10/02/19
03/01/20
09/01/26
Denver City & Cnty CO SCh Dist
249174SF1 AA1
local
219,768.00 219,768.00
200,000.00 5.000%
200,300.00
semi-annual
10/26/20
none
12/01/26
Bangor ME
060095484 AA2
local
235,428.00 235,428.00
240,000.00 2.850%
235,466.40
semiannual
11/21/18
none
11/01/23
Plymouth-Canton MI Sch Dst
729429QZ6 AA2
local
282,489.00 282,489.00
300,000.00 0.464%
281,394.00
semi-annual
09/27/22
11/01/21
05/01/24
Duluth MN
264438ZL9 AA2
local
29,767.20 29,767.20
30,000.00 2.6250/.
28,551.00
semi-annual
12/05/12
08/01/13
02/01/25
Duluth MN _
264439DA5 AA2
local
455,000.00 455,000.00
455,000.00 0.850%
416,047.45
semi-annual
11/03/21
08/01/22
02/01/25
Eau Claire WI
278444QS6 AA2
local
300,348.00 300,348.00
300,000.00 4.000%
294,852.00
semi-annual
10/05/22
04/01/23
04/01125
New York NY
Opelika AL
South Milwaukee WI
Allegheny Cnty, Pennsylvania
Connecticut State
649666LG3 AA2
local
301,506.00 301,506.00
300,000.00 0.800%
300,000.00 2.363%
265,785.00
semi-annual
09/15/20
11/01/20
11/01/25
683489ZD3 AA2
kcal
301,848.00 301,848.00
278,835.00
305,292.00
semi-annual
semi-annual
12/19/19
01/25/19
05/01/20
04/01/19
11/01/25
10/01/26
838855M AA2
local
327,798.25 327,79825
325,000.00 3.350%
01728WHO AA3
local
291,204.00 291,204.00
300,000.00 0.694%
287,406.00
487,160.00
semi-annual
semi-annual
07/11/22
06/23/22
11/01/20
10115/19
11/01/23
04/15/24
20772KGN3 AA3
local
497,725.00 497,725.00
500,000.00 3.041%
Monroe Cty PA
610767TPO AA3
local
294,867.00 294,867.00
300,000.00 2.430%
286,158.00
semi-annual
07/27/22
12/15/19
12/15/24
Birmingham AL
09088RB70 AA3
local
83,255.20 83,255.20
80,000.00 2.951%
76,552.00
seml-annual
10/03/19
none
03/01/25
Burlington VT
122062G89 AA3
local
256,190.00 256,190.00
250,000.00 2.306%
230,425.00
semi-annual
01/30/20
05/01/20
11/01125
Manchester New Hampshire
5623330V9 AA3
local
289,172.40 289,172.40
285,000.00 4.000%
275,971.20
semi-annual
07/14/22
01/01/23
07/01126
Florence AL
3398731.11.13 AA3
local
251,055.00 251,055.00
250,000.00 1.971%
224,310.00
semi-annual
03/19/20
08/01/20
08/01126
Hubbard Cnty MN
443348DKO AA3
local
341,643.65 341,643.65
365,000.00 3.500%
342,140.05
semi-annual
10/18/22
04/01/15
10101/27
Canutillo TX ISD
138735YA7 AAA
local
200,600.00 200,600.00
200,000.00 0.836%
190,474.00
semi-annual
07/29/20
08/15/20
02/15/24
Charleston SC
160357XCB AAA
local
307,836.00 307,836.00
300,000.00 1.2500/.
286,794.00
semiannual
05/26/21
09/01/21
03/01/24
Arlington Cnty VA
041431VF1 AAA
local
280,479.00 280,479.00
300,000.00 0.640%
280,143.00
semi-annual
09/29/22
08/01/21
08/01/24
Hennepin Cnty MN
425507MF4 AAA
local
405,312.00 405,312.00
400,000.00 4.000%
395,892.00
semi-annual
09/01/22
12/01/22
12/01/24
Ramsey Cnty, MN
751622SS1 AAA
local
295,845.00 295,845.00
300,000.00 0.750%
274,803.00
semiannual
01/18122
02/01/21
02/01/25
Saint Louis Park MN
79174OU92 AAA
local
180,005.00 180,005.00
175,000.00 4.500%
174,646.50
semi-annual
09/07/22
08/01/23
02/01/25
Suffolk VA
86481ACU6 AAA
local
150,000.00 150,000.00
150,000.00 0.650%
137,325.00
semi-annual
10/05/21
02/01/22
02/01/25
Lewisville TX
528815KR3 AAA
local
251,825.00 251,825.00
250,000.00 1.270%
231,427.50
semi-annual
12/14/21
02/15/22
02/15/25
Alpine Utah Sch Dist
021087YH8 AAA
local
300,078.00 300,078.00
300,000.00 2.700%
287,346.00
semi-annual
04/19/22
09/15/22
03!15/25
Columbus OH
199492W70 AAA
local
293,235.00 293,235.00
300,000.00 2.960%
287,445.00
semi-annual
09/16/22
10101/22
04/01/25
Asheville NC
044033RW0 AAA
local
229,369.50 229,369.50
225,000.00 1.4301/o
207,022.50
semi-annual
05/04/20
12/01/20
06/01/25
Charlotte NC
161035,104 AAA
local
298,317.00 298,317.00
300,000.00 1.790%
277,868.00
semi-annual
08/28/19
12/01/19
06/01125
5,581,626.75 CD
Description
Nuumber
Number
Credit
RatinglF
DIC #
Type
Purchase Price
Maturity
Carrying Cost Amount
Interest
Rate
Current Market
Value
Date Coupon
Interest Paid Acquired Date
Maturity)
Due Date
Minnesota State
60412AZM8
AAA
local
377,189.10
377,189.10 370,000.00
4.000%
364,934.70
269,574.00
semi-annual 08/23122 02/01/23
semi-annual 07/14/21 02115/22
08/01/25
McKinney TX
58178CEN3
AAA
local
302,502.00
302,502.00 300,000.00
1.000%
08/15/25
Madison WI
55844RXA7
AAA
local
403,360.00
403,360.00 400,000.00
4.000%
393,028.00
semiannual 10/06/22 04/01/23
10/01/25
Andover Massachusetts
034286FF6
AAA
local
281,388.00
281,388.00 300,000.00
1.330%
271,218.00
semi-annual 07/20122 11/01/22
11/01/25
Bellevue WA
0793654E9
AAA
local
212,901.80
212,901.80 230,000.00
1.247%
207,945.30
semi-annual 09/13/22 06/01/22
12101/25
Minneapolis MN
60375BJN7
AAA
local
300,000.00
300,000.00 300,000.00
1.100%
268,044.00
semi-annual 11/18121 06/01122
12/01/25
Minneapolis MN Spl SCh Dist#1
6037893UO
AAA
local
268,815.00
268,815.00 300,000.00
1.150%
265,563.00
1 semiannual 04/22/19 none
12/15125
Ice Deposit- National Sports Center
none
local
250,000.00
250,000.00 250,000.00
250,000.00
maturity 02106/08 none
01/01126
Oregon St
68609TWC8
AA1
state
254,082.50
254,082.50 250,000.00
0.795%
235,882.50
semi-annual 12111/20 11/01/20
05/01/24
Wisconsin State
97705MDW2
AA1
state
201,126.00
201,126.00 200,000.00
1.800%
191,412.00
semiannual 02107/20 none
05/01/24
Rhode Island State
762223MG7
AA2
state
319,545.00
319,545.00 300,000.00
3.000%
292,278.00
semi-annual 10/21/21 08/01/22
08/01/24
Maine State
56052AG75
AA2
state
300,747.00
300,747.00 300,000.00
4.000%
294,450.00
semi-annual 09120/22 12101/22
06/01/25
Texas St Transprtn Cmssn
882830AT9
AAA
stale
109,051.80
109,051.80 110,000.00
0.617%
101,730.20
semi-annual 11118/21 10/01/20
10/01/24
Utah Sl
917542QV7
AAA
stale
378,508.26
378,508.26 367,033.33
3.539%
361,601.24
semi-annual 03109/20 01101/11
07/01/25
Fed Farts Credit Bank
3133ENEX4
AAA
US
497,895.00
497,895.00 500,000.00
0.550%
478,785.00
semi-annual 01105/22 05124/22
11/24/23
Fed Farm Credit Bank_
3133EMN81
AAA
US
300,000.00
300,000.00 300,000.00
0.310%
285,063.00
semi-annual 06/30/21 12/29/21
12/29/23
Fed Home Ln Bank
313OAKJP2
AAA
US
300,000.00
300,000.00 300,000.00
0.250%
284,073.00
semi-annual 12129/20 06129/21
12/29/23
Fed Natl Mtg Assn
3135GABNO
AAA
US
300,000.00
300,000.00 300,000.00
0.280%
284,337.00
semi-annual 12/29/20 06/29/21
12/29/23
Fed Farm Credit Bank
3133ENLF5
AAA
US
499,700.00
499,700.00 500,000.00
0.900%
478,430.00
semi-annual 01/18/22 07/18/22
01/18/24
Fed Home Ln Bank
313OAQFK4
AAA
US
400,000.00
400,000.00 400,000.00
0.760%
380,152.00
semi-annual 01/19/22 07/19/22
01/19/24
Fed Nag Mtg Assn
3135GOV34
AAA
US
316,302.00
316,302.00 300,000.00
2.500%
292,119.00
semi-annual 08/31/21 08/05/19
02/05/24
Fed Farts Credit Bank
3133ENNJ5
AAA
US
496,695.00
496,695.00 500,000.00
1.180%
479,210.00
semi-annual 02/17/22 08/09/22
02/09/24
Fed Home Ln Bank
3130AOXE5
AAA
US
299,844.00
299,844.00 300,000.00
3.250%
294,027.00
semi-annual 06/16/22 09/08/14
03/08/24
Federal Farm Credit Bank
3133ENYH7
AAA
US
494,626.94
494,626.94 500,000.00
2.625%
484,600.00
semi-annual 07/14/22 12/10/22
06/10/24
Fed Home Ln Bank
3130AM2
AAA
US
297,390.00
297,390.00 300,000.00
2.875%
291,282.00
semi-annual 06116/22 12/14114
06/14/24
Federal Home Loan Bank
3130ASHK8
AAA
US
298,008.00
298,008.00 300,000.00
3.125%
292,848.00
semi-annual 08/31122 12/14/22
06/14/24
Federal Home Loan Bank
3130AT4D6
AAA
US
299,262.00
299,262.00 300,000.00
3.375%
293,754.00
semi-annual 08/31122 12114/22
06/14124
Fed Home Ln Bank
3130ANSM3
AAA
US
300,000.00
300,000.00 300,000.00
0.400%
278,667.00
semi-annual 08/26/21 02125122
06/25/24
Federal Home Loan Bank
3130ASME6
AAA
US
499,568.01
499,568.01 500,000.00
3.000%
487,155.00
semi-annual 07/13/22 01/08/23
07/08124
Federal Fane Credit Bank
3133ENA91
AAA
US
500,693.13
500,693.13 500,000.00
3.150%
487,800.00
semi-annual 07/15/22 01/15/23
07/15124
Federal Farm Credit Bank
3133ENC73
AAA
US
499,710.00
499,710.00 500,000.00
3.250%
488,060.00
semi-annual 07/26122 01/26/23
07/26/24
Fed Farm Credit Bank
3133EL5D2
AAA
US
300,000.00
300,000.00 300,000.00
0.420%
277,059.00
semi-annual 08/26/20 02/26/21
08/26/24
Fed Home Ln Bank
3130AQV75
AAA
US
400,000.00
400,000.00 400,000.00
1.4000%
375,744.00
semi-annual 02128/22 08/28/22
08/28/24
Federal Home Loan Bank
3130AFBCO
AAA
US
499,840.00
499,840.00 500,000.00
3.250%
487,550.00
semi-annual 08/19/22 03113/19
09113/24
Federal Home Loan Bank
3130AT6G7
AAA
US
299,907.00
299,907.00 300,000.00
3.5000%
293,787.00
semi-annual 09101/22 03/13/23
09/13/24
Fed Natl Mtg Assn
3135GOW66
AAA
US
499,020.00
499,020.00 500,000.00
1.6259.4
472,420.00
semiannual 02117/22 04/15/20
10/15/24
Fed Home Ln Bank
313OAQG64
AAA
US
400,000.00
400,000.00 400,000.00
1.000%
371,176.00
semi-annual 01/18/22 07/18/22
10/18/24
Fed Nail Mtg Assn
3135GO6E8
AAA
US
196,422.00
196,422.00 200,000.00
0.4201/6
182,984.00
semi-annual 12/15/21 05/18/21
11/18/24
Fed Home Ln Bank
3130APR80
AAA
US
498,995.00
498,995.00 500,000.00
0.750%
461,575.00
semi-annual 11/12/21 06/13/22
12113/24
Fed Home Ln Bank
313OAQF40
AAA
US
473,768.19
473,768.19 500,000.00
1.0001/6
463,370.00
semi-annual 07/14/22 06/20122
12/20/24
Fed Home Ln Bank
313OAQGT4
AAA
US
496,170.00
496,170.00 500,000.00
1.100%
461,470.00
semi-annual 01120122 07/13122
01/13/25
Fed Home Ln Bank
313OAQMR1
AAA
US
491,850.00
491,850.00 500,000.00
1.2509/6
462,070.00
semi-annual 02/24/22 07/27/22
01/27/25
Fed Farts Credit Bank
3133ENMOO
AAA
US
400,000.00
400,000.00 400,000.00
1.310%
370,336.00
semi-annual 02/04/22 08/03122
02/03/25
Federal Home Loan Bank
3130ATDL8
AAA
US
398,896.00
398,896.00 400,000.00
3.750%
392,324.00
semi-annual 09/16/22 03/14/23
03/14/25
11,509,821.50 local
1,477,353.94 state
Description
Cusip
Number
Credit
Rating1F
DIC #
Type
Purchase Price
Maturity
Carrying Cost Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturity I
Due Date
Fed Nall Mtg Assn
3135G03U5
AAA
US
467,397.20
467,397.20 500,000.00
0.625%
453,930.00
semi-annual
semi-annual
07/13/22
10122/20
04/22/25
Fed Home Ln Bank
3130APVBB
AAA
US
300,000.00
300,000.00 300,000.00
1.000%
272,670.00
12/10/21
05122/22
05122/25
Federal Home Loan Bank
3130ASTV1
AAA
US
500,000.00
500,000.00 500,000.00
3.550%
487,065.00
semi-annual
08104/22
01/25/23
07125/25
Federal Home Loan Bank
3130ASZ93
AAA
US
500,000.00
500,000.00 500,000.00
4.000%
489,270.00
semiannual
08/30/22
02/28/23
08/28/25
Fed Home Ln Mtg Carp
3137EAEX3
AAA
US
291,732.00
291,732.00 300,000.00
0.375%
266,895.00
semi-annual
12115/21
03/23/21
09/23/25
Tennessee Valley Auth Ser E
880591Cd9
AAA
US
121,500.00
121,500.00 100,000.00
6.750%
106,158.00
semi-annual
03119/09
none
11/01/25
Federal Home Loan Bank
3130ASPD5
AAA
US
300,000.00
300,000.00 300,000.00
4.000%
290,202.00
semi-annual
07/29122
01/28/23
01/28/26
Fed Home Ln Bank
3130ANSG6
AAA
US
300,000.00
300,000.00 300,000.00
0.8750/6
261,654.00
semiannual
08/26121
02/25/22
06/25/26
32,628,873.19
Will County IL Cavity Zero Coupon
Waterloo IA
969078QM9
941647URB
AA2
AA2
local
159,000.00
159,000.00 500,000.00
384,910.00
maturity
08/25/09
none
11/01/27
local
173,216.40
173,216.40 170,000.00
2.600%
149,696.90
semi-annual
09/13/19
06/01/25
06/01/28
Allegheny Cnty PA
01728VVN7
AA3
local
204,746.00
204,746.00 200,000.00
1.586%
162,934.00
semi-annual
08/20/20
11/01/20
11/01/28
Sl Paul MN
792882CA8
AAA
local
240,000.00
240,000.00 240,000.00
2.400%
210,700.80
semi-annual
12/11/19
05/01/20
05/01/28
Anoka -Hennepin MN ISD #11
0363032115
AAA
local
323,613.50
323,613.50 350,000.00
2.550%
295,991.50
semi-annual
01/25/19
none
02/01/30
Vestavia Hills AL
925479RY5
AAA
local
202,566.00
202,566.00 200,000.00
1.870%
150,770.00
semi-annual
07/16/20
02/01/21
02101/32
Fed Farm Credit Bank
31331VLC8
AAA
US
106,030.45
199,500.00
106,030.45 100,000.00
5.250%
104,224.00
semi-annual
02126/10
none
04/21/28
09/29/28
Fed Home Ln Mtg Corp Med Term Note
3134GWUM6
AAA
US
199,500.00 200,000.00
0.750%
160,252.00
semi-annual
10/07/20
03/29/21
Fed Home Ln Bank
3130AGT21
AAA
US
300,000.00
300,000.00 300,000.00
2.640%
262,575.00
semi-annual
07/26/19
01/26/20
07126/29
1,882,054.20
57,494,618.14
14,060,071.00 US
1- 5 Years
1,355,003.20 local
527,051.00 US
6 -10 Years
INVESTMENT SCHEDULE - Money Market Funds
October 31, 2022
Description
Current Market
Value
YTD Interest
Wells Fargo
1 lWells Fargo Government Money Market Fund
$2,515,593.321
$29,212.88
4M
1 4M
548,588.66
4,587.22
4M PLUS
1 4M Plus
776,307.02
5,611.65
Grand Total MoneyMarket Funds 1 $3,840,489.00 1 $39,411.75
Updated: 11/9/2022
Awbw^-o
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER. MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and CouncilmeZinistrat
�4
CC: James Dickinson, City
FROM: Dana Makinen, Human Resources Mand r
SUBJECT: Discuss City Administrator's Performance
DATE: November 22, 2022
The City Council is requested to discuss the 2022 performance of City Administrator James Dickinson
All employees are required to have an annual review. The City Councilmembers were requested to
evaluate Mr. Dickinson in the areas of Council relations, fiscal management, personnel, supervision,
leadership, intergovernmental relations, and community relations. Responses were then sent to the Human
Resources Manager to complete. The compiled version of the performance review will be provided at the
workshop as a supplemental item.
ACTION REQUESTED
Council is requested to discuss Mr. Dickinson's 2022 performance.
Respectfully submitted,
Dana Makinen