HomeMy WebLinkAboutWK - July 26, 2016ANLb Y O F OV E
1685 CROSSTOWN BOULEVARD N.W. -AN DOVER, MINNESUTA 55304 • (763) 755 -5100
FAX (763) 755 -8923 • WWW.ANDOVERMN.GOV
City Council Workshop
Tuesday, July 26, 2016
Conference Rooms A & B
Call to Order — 6:00 p.m.
2. Round Lake Watershed High Water Study — Engineering
3. Discuss Multi -Way Stop Signs - Engineering
4. 2017 -2021 CIP Discussion - Administration
5. 2017 Budget Development Discussion - Administration
6. June 2016 General Fund Budget Progress Report - Administration
7. June 2016 City Investments Review - Administration
8. Other Business
9. Adjournment
Rik
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755 -5100
FAX (763) 755 -8923 • WWW.CI.ANDOVER.MN.US
TO: Mayor and Council Members
CC: Jim Dickinson, City Administrator
FROM: David D. Berkowitz, Director of Pu 'c rorks/City Engineer
SUBJECT: Round Lake Watershed High Water Study — Engineering
DATE: July 26, 2016
INTRODUCTION
The City Council is requested to discuss a Round Lake watershed study to update the high water
level for the lake.
DISCUSSION
The current high water elevation for Round Lake (869) is based on outdated rainfall data (TP 40)
and the old 1929 elevation datum. Staff is recommending that the Round Lake watershed be
studied using Atlas 14 rainfall data, 1988 elevation datum and the DNR LiDAR elevations to set
a high water elevation for the lake utilizing the most current and accurate information.
Attached is the high water approval letter from the DNR which was never formally approved by
FEMA and a FEMA map showing the general floodplain area for Round Lake. With this study
the elevation will change and the flood zone will cover more area then identified on the map.
This is the only section of the City that does not have an updated study or that is currently going
through an updated study.
If the City Council would like to precede with the study a consulting engineering firm would be
hired to complete the work which then will go to the DNR and FEMA for formal approval.
There are many steps to this process in which one step is to notify property owners who will be
impacted.
BUDGET IMPACT
This study would be funded through the Storm Water Utility Fund.
ACTION REQUIRED
Staff is requesting direction on how to proceed with an updated Round Lake high water elevation
study-
Res
e
/ ctfully submitted,
David D. Berkowitz
Attach: 1982 DNR Flood Plain Data Letter & Round Lake Floodplain Map
--�� STATE OF
�(/�aaC��Oo LILa
DEPARTMENT OF NATURAL RESOURCES
19741981
Metro Region Waters, 1200 Warner Road, St. Paul, MN 55106
PHONENO, 296 -1523
February 10, 1982
Mr. Jim Schrantz, Engineer
City of Andover
1685 Crosstown Boulevard N.W.
Andover, Minnesota 55303
Dear Mr. Schrantz:
RE: FLOOD PLAIN DATA - -ROUND LAKE
FILE
This letter is to confirm our telephone discussion of February 9, 1982
regarding the 100 -year flood protection elevation for the approximate
flood hazard area around Round Lake in Andover. Our files indicate an
estimated Ordinary High Water Mark (OHW) of 866.4 feet above MSL (NGVD,
1929). As you are aware, any fill or structure placed below the OHW of
a protected water may require a permit from the Department of Natural
Resources.
Based on the drainage area /surface'area ratio of Round Lake and the topo-
graphy of the area, we agreed that the Regulatory Flood Protection Eleva-
tion for the Round Lake flood hazard area (shown in the Flood Insurance
Study) should be 870.0 feet above MSL (NGVD, 1929). Any proposed construc-
tion within the flood hazard should also be evaluated as outlined in Section
6.0 of Andover Ordinance No. 50. If you have any questions regarding this
information, please feel free to contact me.
Sincerely,
1
o n L. Stine
d Use Hydrologist
JLS /ch
cc: Tom Lutgen, LUMS
Round Lake (2 -89)
AN EQUAL OPPORTUNITY EMPLOYER
s
ANr` i fO r
Round Lake Floodplain
Date Created: July 20, 2016
Disclaimer. The provider makes no representation or warranties with respect to the reuse of this data.
ND OVE:
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
David D. Berkowitz, Public Work it ctor /City EngineerbDB
FROM: Todd J. Haas, Assistant Public Works Director
SUBJECT: Discuss Multi -Way Stop Signs - Engineering
DATE: July 26, 2016
4 0�11
INTRODUCTION
The City Council is requested to discuss the removal of the existing stop signs for various locations in
Zone 2 of the City.
DISCUSSION
The Public Works Committee (Councilmembers Goodrich and Knight) met on February 24, 2016 to
review the locations with staff. Based on direction from the Public Works Committee, staff has
performed the necessary research (traffic counts and accidents data) to determine if the intersection
should remain a multi -way stop or not. The intersections that have been researched the past few
months are as follows:
A. Narcissus Street NW and Orchid Street NW) (3 -way).
B. Narcissus Street NW and Marigold Street NW (3 -way).
C. 134th Avenue NW and Poppy Street NW/Narcissus Street NW (3 -way).
D. 143rd Avenue NW and Xenia Street NW (3 -way).
E. 140'h Avenue NW and Underclift Street NW (3 -way).
F. 138th Lane NW and Underclift Street NW (4 -way).
Based on the research for each of these intersections the existing multiway stop does not meet the
criteria identified in the MN Manuel on Uniform Traffic Control Devices (MNMUTCD) in which the
City follows for proper standards and rules to be utilized for placement of such signs. Please refer to
the attached section of the manual, section 2B.7 Multiway Stop Applications, for the placement
criteria. By following the manual provides the City with consistency throughout the City on when and
where signs are placed. Attached is the approved resolution from 2003 establishing rules and standards
to be followed in in reviewing requests for and ordering installation of traffic control devices which
adopts the MNMUTCD as the standard.
Anoka County Sheriff's Department has no report of accidents at the identified intersections. Vehicle
counts were taken and the amount of vehicles that were counted does not warrant the intersection to be
an all way stop condition.
Mayor and Council Members
July 26, 2016
Page 2 of 2
Attached is the letter that was sent to residents at each of the intersections notifying them of the
removal of the all way stop. All streets in each of the neighborhood are 30 MPH and are posted at the
entrances to the development from the county roads.
ACTION REQUIRED
The City Council is requested to discuss the removal of the existing stop signs for the various
locations.
Respectfully submitted,
;0;�°'/�/��
Todd J. Haas
Attachments: Location Map of Stop Signs (3 or 4 way); MMUTCD Multi -Way Stop Applications;
Example letter sent to residents at each of the intersections; Do Stop Signs Really Slow Traffic article;
Resolution establishing rules and standards
COUNTY D 118
418f AVE
LN
I
38rH ll��
Stop Sign Location
Zone 2
Water
Parks
Feet
0 500 1,000 2,000
lE
EXCEPT
RIGHT
TURN
RMOP
0
An EXCEPT RIGHT TURN (Rl -lOP) plaque may be
mounted below the STOP sign if an engineering study
determines that a special combination of geometry and
traffic volumes is present that makes it possible for right-
turning traffic on the approach to be permitted to enter the
intersection without stopping.
SOPPOSI:
The design and application of Stop Beacons are described
in Section 4L.5.
2B.6 STOP Sign Applications
GQIDANCE:
At intersections where a full stop is not necessary at all
times, consideration should first be given to using less
restrictive measures such as YIELD signs (see Sections 2B.8
and 2B.9).
The use of STOP signs on the minor -street approaches
should be considered if engineering judgment indicates that
a stop is always required because of one or more of the
following conditions:
A. The vehicular traffic volumes on the through street or
highway exceed 6,000 vehicles per day;
B. A restricted view exists that requires road users to stop
in order to adequately observe conflicting traffic on
the through street or highway; and/or
C. Crash records indicate that three or more crashes that
are susceptible to correction by the installation of a
STOP sign have been reported within a 12 -month
period, or that five or more such crashes have been
reported within a 2 -year period. Such crashes include
right -angle collisions involving road users on the
minor -street approach failing to yield the right -of -way
to traffic on the through street or highway.
SQPPOBI:
In many low volume situations with no unusual history of
intersection crashes, no control at the intersections is a cost
effective strategy. Research suggests that at most
locations, increasing the level of intersection control will not
improve safety (see FHWA -RD -81 -084 Stop, Yield and No
Control at Intersections).
The use of STOP signs at grade crossings is described in
Sections 8B.4 and 8B.5.
2B.7 Multi -Way Stop Applications
SUPPOR71
Multi-way stop control can be useful as a safety measure
at intersections if certain traffic conditions exist. Safety
concerns associated with multi-way stops include
pedestrians, bicyclists, and all road users expecting other
road users to stop. Multi-way stop control is used where the
volume of traffic on the intersecting roads is approximately
equal.
The restrictions on the use of STOP signs described in
Section 2B.4 also apply to multi-way stop applications.
GOIDANCI�
The decision to install multi-way stop control should be
based on an engineering study.
The following criteria should be considered in the
engineering study for a multi-way STOP sign installation:
A. Where traffic control signals are justified, the multi-
way stop is an interim measure that can be installed
quickly to control traffic while arrangements are being
made for the installation of the traffic control signal.
B. Five or more reported. crashes in a 12 -month period
that are susceptible to correction by a multi-way stop
installation. Such crashes include right -turn and left-
turn collisions as well as right -angle collisions.
C. Minimum volumes:
L The vehicular volume entering the intersection
from the major street approaches (total of both
approaches) averages at least 300 vehicles per hour
for any 8 hours of an average day; and
2. The combined vehicular, pedestrian, and bicycle
volume entering the intersection from the minor
street approaches (total of both approaches)
averages at least 200 units per hour for the same 8
hours, with an average delay to minor -street
vehicular traffic of at least 30 seconds per vehicle
during the highest hour; but
3. If the 85th percentile approach speed of the major -
street traffic exceeds 40 mph, the minimum
vehicular volume warrants are 70 percent of the
values provided in Items I and 2.
D. Where no single criterion is satisfied, but where
Criteria B, C.1, and C2 are all satisfied to 80 percent
of the minimum values. Criterion C.3 is excluded
from this condition.
2B -9 December, 2011
OPTIONt
Other criteria that may be considered in an engineering
study include:
A. The need to control left-turn conflicts;
B. The need to control vehicle/pedestrian conflicts near
locations that generate high pedestrian volumes;
C. Locations where a road user, after stopping, cannot
see conflicting traffic and is not able to negotiate the
intersection unless conflicting cross traffic is also
required to stop; and
D.An intersection of two residential neighborhood
collector (through) streets of similar design and
operating characteristics where multi-way stop
control would improve traffic operational characteris-
tics of the intersection.
2B.8 YIELD Sign (Rl -2)
R1 -2
=
The YIELD (111 -2) sign shall be a downward- pointing
equilateral triangle with a wide red border and the legend
YIELD in red on a white background.
The YIELD sign assigns right -of -way to traffic on certain
approaches to an intersection. Vehicles controlled by a
YIELD sign need to slow down to a speed that is reasonable
for the existing conditions or stop when necessary to avoid
interfering with conflicting traffic.
2B.9 YIELD Sign Applications
OPTION:
YIELD signs may be installed:
A.On the approaches to a through street or highway
where conditions are such that a full stop is not always
required.
B. At the second crossroad of a divided highway, where
the median width at the intersection is 30 feet or
greater. In this case, a STOP or YIELD sign may be
installed at the entrance to the first roadway of a
divided highway, and a YIELD sign may be installed
at the entrance to the second roadway.
C. For a channelized turn lane that is separated from the
adjacent travel lanes by an island, even if the adjacent
December, 2011 2B -10
lanes at the intersection are controlled by a highway
traffic control signal or by a STOP sign.
D. At an intersection where a special problem exists and
where engineering judgment indicates the problem to
be susceptible to correction by the use of the YIELD
sign.
E. Facing an entrance ramp onto a roadway, if
engineering judgment indicates that control is needed
because acceleration geometry and/or sight distance is
not adequate for merging traffic operation.
A YIELD (R1 -2) sign shall be used to assign right -of -way
at the entrance to a roundabout. YIELD signs at roundabouts
shall be used to control the approach roadways and shall not
be used to control the circulatory roadway.
Other than for all of the approaches to a roundabout,
YIELD signs shall not be placed on all of the approaches to
an intersection. When a YIELD sign is used at an intersec-
tion other than a roundabout, at least one other approach
to an intersection shall remain uncontrolled.
2B.10 STOP Sign or YIELD Sign Placement
The STOP or YIELD sign shall be installed on the near
side of the intersection on the right -hand side of the
approach to which it applies. When the STOP or YIELD sign
is installed at this required location and the sign visibility is
restricted, a Stop Ahead sign (see Section 2C.36) shall be
installed in advance of the STOP sign or a Yield Ahead sign
(see Section 2C.36) shall be installed in advance of the
YIELD sign.
The STOP or YIELD sign shall be located as close as
practical to the intersection it regulates, while optimizing its
visibility to the road user it is intended to regulate.
STOP signs and YIELD signs shall not be mounted on the
same post.
No items other than inventory stickers, sign installation
dates, and bar codes shall be affixed to the fronts of STOP or
YIELD signs, and the placement of these items shall be in
the border of the sign.
No items other than official traffic control signs,
inventory stickers, sign installation dates, anti- vandalism
stickers, and bar codes shall be mounted on the backs of
STOP or YIELD signs.
No items other than retroreflective strips (see Section
2A.21) or official traffic control signs shall be mounted on
the fronts or backs of STOP or YIELD signs supports.
gt,
C I T Y O F V�
NDOVE
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755 -5100
FAX (763) 755 -8923 • WWW.ANDOVERMN.GOV
June 20, 2016
Re: Removal of Existing Stop Signs /138th Lane NW and Underclift Street NW
Dear Owner /Occupant:
Over the past few years the City of Andover has been updating traffic sign
throughout the City. Nine zones (9) are identified throughout the City in which
signs are being removed, replaced or relocated along with potentially new signs
being placed. Zone 2 in which you preside is completed except for the removal of
unwarranted stop signs that are located at the intersection of 138th Lane NW and
Underclift Street NW. The reason for this letter is to notify you that the existing 4
way stop sign at the intersection of 138th Lane NW and Underclift Street NW will
be removed. Only the west leg for eastbound traffic and the east leg for
westbound traffic approaching Underclift Street NW will the stop signs remain in
place.
The reason the City will be removing the stop signs for the northbound and
southbound traffic along Underclift street NW is due to a couple factors that have
come into play. First, the Minnesota Manual of Uniform Traffic Control Devices
(MMUTCD) mandates local authorities to place and maintain traffic control
devices, as they deem necessary to carry out the provisions of Chapter 169 or
local traffic ordinances, or to regulate, warn or guide traffic. Based on the
engineering review of the guidelines in the MMUTCD, the existing all -way stop
does not meet the guidelines as outlined. Second, stops signs are not a good
use for speed control. Research suggests that at most locations, increasing the
level of intersection control will not improve safety and also can provide a false
sense of security as some motorist's tend to roll through stops signs or in some
cases not even stop at all.
If you have any questions or concerns, please contact me at (763) 767 -5131 or
Dave Berkowitz, Director of Public Works /City Engineer at (763) 767 -5133 by
Friday, July 15, 2016.
Sincerely,
Todd J. Haas
Asst. Public Works Director
TJH:tjh
t 1 .
Do Stop Signs
A stop sign is one of our most valu-
able and effective traffic control
devices;... when used at the right
place and under the right condi-
tions. it is intended to help drivers
and pedestrians at an intersection
decide who has the right of way.
Quite often stop signs are arbi-
trarily installed along a roadway
for the expressed purpose of inter-
rupting through traffic and "reduc-
ing speed ". The stop signs are not
needed to assign right of way or to
control traffic volumes. Unfortu-
nately, a number of studies indicate
that stop signs do not slow traffic
at locations where the stop sign is
not justified by traffic volumes.
Where stop signs are installed to
control.. speed, there is a high in-
cidence of intentional violations.
Most of our drivers are reasonable
people and they obey stop signs as
long as the stop makes sense to
them. However, when stop signs
are erected arbitrarily and without
apparent reason, violations increase
rapidly. In those locations where
vehicles do stop, the speed reduc-
tion Is effective only in the immedi-
ate vicinity of the stop sign, and
frequently speeds are higher be-
tween intersections.
A San Francisco study showed that
speeds 100 ft. past the stop sign
were within 3 miles per hour of the
top level of speeds. The study also
showed that speeds in a mid -block
location 2 blocks from any stop
sign were 3 to 5 miles per hour
higher with the stop sign than after
the stop signs had been removed.
A more recent study in Troy, Mich-
igan, showed that average speeds
also increased slightly after instal-
lation of stop signs. This study also
showed that approximately half of
the motorists made a rolling stop
and one -quarter did not stop at all.
An Indiana study of several stop
signs showed that 31% failed to
stop for stop signs installed along
low volume.roads. Several undocu-
mented studies in the Twin City
metropolitan area also indicate a
rather substantial violation rate and
Really Slow Traffic?
an,ancrease In speeds as a result
of unjustified stop sign Installa-
tions. Finally, a citizen successfully
sued a city in northern Ohio for Il-
legally Installing stop signs for the
express purpose of speed control;
The city was forced to remove the
signs and to pay the plaintiff for
his court fees.
Apparently drivers who fail to see
the reason for Installation of a stop
sign develop a tendency to disre-
gard' the sign and to roll past IL
There is also a tendency for drivers
to over accelerate and exceed low-
er speed limits. It 1s also apparent
that a number of drivers are also
somewhat Irritated by the installa-
tion of these signs and develop
a tendency to make up for lost time
by traveling at higher speeds be-
tween signs. A most interesting ob-
servation of enforcement agencies
monitoring these types of installa
tions is that the arrests generally-
are of nearby residents who may
have campaigned for the sign in-
stallation in the first place.
The annual cost to stop 1000 vehi-
cles per-day on a 35 mph street
was calculated- as $9600 in excess
vehicle operation costs,. according
to Long Beach, CA engineers. Also
of concern are additional emis-
sions,'lost time, extra fuel use and- -
the urge to squeal tires.
It is extremely difficult to face a
number of angry citizens armed
with petitions and emotions and not
accede to their demands. Perhaps
studies like these will help citizens
understand -that stop signs will not
automatically solve their "prob-
lem". Many times it is possible to
try to better define the problem
which in turn enables one to find a
solution or means of managing the,
problem by means other than arbi-
trarily installing a stop sign.
\ CITY OF ANDOVER
COUNTY OF ANOKA
STATE OF MINNESOTA
RES. NO. 01 -03
A RESOLUTIN ESTABLISHING RULES AND STANDARDS TO BE FOLLOWED
IN REVIEWING REQUESTS FOR AND ORDERING INSTALLATION OF
TRAFFIC CONTROL DEVICES.
WHEREAS, authority to order installation of traffic control devices rests
with the City Council, and;
WHEREAS, the City Council wishes to delegate this authority to the City
Engineer under certain circumstances, and:
WHEREAS, The City Council wishes to establish standards and rules to
be used in evaluating the need for traffic control devices, and:
NOW, THEREFORE, BE IT RESOLVED the "Minnesota Manual on
Uniform Traffic Control Devices" as adopted by the Minnesota Commissioner of
Public Safety shall be adopted as the rule and standard to be used by the City in
evaluating the need for traffic control devices, and
BE IT FURTHER RESOLVED THE City Engineer shall be delegated the
authority to review traffic control device needs and order their installation.
Adopted by the City Council of the City of Andover this 7th day of
January , 2003.
ATTEST:
dz� a4&
Victoria Volk — City Clerk
CITY OF ANDOVER
Mrchael R. Gamache — Mayor
LC I T Y 0 F
NIDOVEA
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755 -5100
FAX (763) 755 -8923 • WWW.ANDOVERMN.GOV
TO:
FROM:
SUBJECT:
Mayor and Councilmembers
Jim Dickinson, City Administrator
2017 -2021 CIP Discussion
DATE: July 26, 2016
INTRODUCTION
Administration/Finance has been working with Department Heads to prepare a preliminary
2017 -2021 CIP project listing. Various committees (Vehicle Purchasing & Facility Management
Committees) and commissions (Parks and Recreation & Community Center Advisory) have
contributed to the current preliminary 2017 -2021 CIP project listing.
DISCUSSION
To assist with the 2017 -2021 CIP discussion. I have attached for the Council's reference a progress
report on the 2016 Capital Improvement Plan projects, in addition I have attached a preliminary 2017-
2021 CIP project listing and preliminary major Capital Funds proiected fund balance analysis.
Over the summer a significant amount of time is being spent on evaluating utility infrastructure,
transportation improvements, trail improvements, building maintenance, equipment and park and
recreation needs. Each of these items is to be supported by a detailed fund balance analysis of funding
sources (based on various assumptions and estimates).
At this time the Staff will again secure the Council's priorities to assure that Council priorities are
being met as staff develops a draft 2017 -2021 CIP. Staff will also discuss with the Council the current
capital proiect concerns, the impact of recently approved project funding options, and the merit of
some new proiect requests.
ACTION REQUESTED
The Council is requested to review the various attachments, receive a brief presentation, and provide
direction to staff on Council priorities for the 2017 -2021 CIP.
submitted,
-2016 CIP Progress Report
-2017 -2021 CIP Listing
- Capital Equipment Reserve Projected Fund Balance
-Park Improvement Fund Projected Fund Balance
-Trail Fund Projected Fund Balance
-Road & Bridge Funds Projected Fund Balance
CITY OF ANDOVER
2016 Capital Improvement Plan
Projects By Department - Use of Funds
Building
Replacement - Small Extended Cab Pick Up #9
$ 30,000
purchased
Community Center
284,000
Fence complete; well drilled
Replacement - Rink Flooring
36,000
Ordered w/ August replacement
Engineering
23,000
complete
New Development Projects
150,000
ongoing
Pedestrian Trail Maintenance
45,000
August
New Pedestrian Trail & Sidewalk Segments
230,000
Crosstown Trail under construction
Pedestrian Trail Reconstruction
50,000
Carried forward to 2017
475,000
Facility Management
Annual Parking Lot Maintenance
50,000
August
Public Works / Comm Ctr Master Planning
25,000
complete
75,000
Fire
Replacement - Turnout Gear
19,000
purchased
Replacement - SCBRs
250,000
purchased
Replacement - Fire Marshall vehicle
40,000
purchased
Replacement - 800 MHz radios
35,000
purchased
Replacement - Breathing Air Compressor
80,000
purchased
424,000
Information Technology
New Server addition / replacement
20,000
needs assessment
Park & Recreation - Operations
Replace /Repair Play Structures - Various Parks
50,000
Forest Meadows complete; Lions - October
Replace /Repair Major Park Projects - Various Parks
25,000
ongoing, summer
Replacement - Toro Groundsmaster #559
45,000
purchased
Replacement - Toro Groundsmaster #585
110,000
purchased
Replacement - Toro Groundsmaster 4000 -D #583
70,000
purchased
300,000
Park & Recreation - Projects
Annual Miscellaneous Projects
15,000
ongoing
Timber Trails Park - Renovation
284,000
Fence complete; well drilled
Terrace Park Irrigation & Water Service
35,000
70% complete
Sunshine Park Scoreboard Wiring & Design
23,000
complete
Municipal State Aid Routes / New & Reconstruct
357,000
80% complete
Storm Sewer
693,000
complete
Storm Sewer Improvements
50,000
ongoing
Streets / Highways
Annual Street Seal Coat Project
460,000
August
Annual Street Crack Seal Project
230,000
Late July
Annual Pavement Markings
40,000
complete
Annual Curb Replacement
50,000
Awarded
Municipal State Aid Routes / New & Reconstruct
2,600,000
80% complete
Annual Street Reconstruction
693,000
complete
Gravel Road Improvements
15,000
complete
Replacement - Dump Truck w/ Snow Removal Equip #196
200,000
in process
4,288,000
Water
Rehabilitation of Wells
50,000
May be carried forward to 2017
Grand Total $ 6,105,000
City of Andover, MN
Capital Plan
2017 thru 2021
PROJECTS & FUNDING SOURCES BY DEPARTMENT
Department
Project#
Priority 2017
2018
2019
2020
2021 Total
Building
Replacement -Small Extended Cab Pick Up #8
19- 42300 -01
1
35,000
35,000
Equipment Bond
35,000
- 35,000
Building Total
35,000
35,000
Central Equipment
Replacement - Service Truck #371
18 48800 -01
2
40,000
40,000
Equipment Bond
40,000
40,000
Central Equipment Total
40,000
40,000
Community Center
Exterior Painting
17- 44000 -05
1 6,000
6,000
Comm Ctr Operations -
6,000
8,000
Replacement - Carpeting
18 44000 -01
1
18,000
12,000
30,000
Comm Ctr Operations
18,000
12,000
30,000
Replacement- Skate Sharpener
18 -04200 -01
1
10,000
10,000
Comm Ctr Operations
10,000
10,000.
Replacement - Pickleballlnserts /Net System
18-04400 -01
1
10,000
10,000
Comm.CtrOperations
10,000
10,000
New - Inflatables
18-44400 -03
1
10,000
10,000
Comm Ctr Operations
10,000
10,000
Replacement - All Community Center Doors
19 -04000 -02
1
75,000
75,000
G.O. Bond
75,000
75,000
ACCNMCA Expansion
19- 44000 -03
2
7,000,000
7,000,000
G.O. Bond
-
7,006,000
7,000,000
Refacing Rink Boards
19 -04300 -01
1
25,000
25,000
1 Comm Ctr Operations
25,000
25,000
Repaint Ice Arena ceiling
19-04300 -02
1
25,000
25,000
Comm Ctr Operations
25,000
25,000
Replacement - Ice Arena Refrigeration Replacement
19 44300 -03
1
1,000,000
1,000,000
G.O. Bond
1,000,000
1,000,000
Replacement -Heat Exchangers - MuntersUnit
19-04300 -04
1
15,000
15,000
Comm Ctr Operations
15,000
15,000
Replacement - Zamboni Battery Pack
19- 44300 -06
1
14,000
14,000
Comm Ctr Operations
14,000
14,000
Replacement - Scissor Lift
20- 44000 -01
1
15,000
15,000
Equipment Bond
15,000
15,000
Replacement - Lobby Furniture
20- 44000 -02
1
15,000
15,000
Comm Ctr Operations
15,000
15,000
Replacement - Roof
20- 44000 -03
1
500,000
500,000
G.O. Bond
500,000
500,000
Replacement - Kaivac Cleaning System
2044000 -05
1
10,000
10,000
Department
Project#
Priority
2017
2018
2019
2020
2021
Total
Comm Ctr Operations
Annual Parking Lot Maintenance 17 -01900 -01
1 90,000
130,000 30,000 30,000
30,000
310,000
10,000
30,000
10,000
Replacement - Camera/Secudty System
20- 44000 -06
1
60,000
12,000
Replacement - Carpet /Tile 17 -01900 -02
12,000
G.O. Bond
10,000
30,000
Capital Equipment Reserve
10,000
10,000
12,000
30,000
12,000
Replacement- Zamboni Room Water Heater
20- 44300 -02
1
100,000
25,000
25,000
G.O. Bond
25,000
25,000
Replacement - Floor Scrubber
21- 44000 -01
1
15,000
15,000
Comm Ctr Operations
15,000
15,000
Repaint Field House Ceiling
21- 44200 -01
1
25,000
25,000
Comm Ctr Operations
25,000
25,000
Replacement - Munters Desiccant Wheel
21- 44300 -01
1
10,000
10,000
Comm Ctr Operations
10,000
10,000
Replacement - Electric Edger
21- 44300 -02
1
8,000
8,000
Comm Ctr Operations
8,000
8,000
Replacement - Evaporative Condenser
21- 44300 -03
1
60,000
60,000
Comm Ctr Operations
60,000
60,000
Replacement- Field House Floor
21 -04400 -02
1
150,000
150,000
Comm Ctr Operations -
150,000
150,000
Community Center Total
6,000
48,000
8,154,000
589,000
268,000
9,065,000
Emergency Management
Emergency Operations Center Improvement
17- 42400 -01
1
40,000
18,000
7,500
65,500
Capital Equipment Reserve
40,000
18,000
7,500
65,500
Replacement - Emergency Sirens
17 -02400 -02
1
45,000
45,000
45,000
45,000
180,000
Capital Equipment Reserve
45 ,000
45,000
45,000
45,000
180,000
Emergency Management Total
85,000
63,000
52,500
45,000
245,500
Engineering
New Development Projects
17 -01600 -01
1
160,000
160,000
165,000
175,000
180,000
840,000
Sewer Trunk Fund
117,000
117,000
120,000
125,000
125,000
604000
Water Trunk Fund
43,000
43,000
45,000
50,000
55,000
236,000
Pedestrian Trail Maintenance
17 -01600 -02
1
50,000
55,000
60,000
65,000
70,000
300,000
Road &Bridge Funds
50,000
55,000
60,000
65,000
70,000
300,000
New Pedestrian Trail and Sidewalk Segments
17.41600 -03
1
565,000
225,000
265,000
710,000
400,000
2,165,000
Grant
265,000
265,000
Trail Funds
565,000
225,000
710,000
400,000
1,900,000
Pedestrian Trail Reconstruction
17 41600 -04
1
60,000
80,000
100,000
120,000
140,000
500,000
Road &Bridge Funds
60,000
80,000
100,000
120,000
140,000
500,000
Pedestrian Curb Ramp Replacements
17- 41600 -05
1
15,000
16,000
17,000
18,000
19,000
85,000
Road &Bridge Funds
15,000
16,000
17,000
18,000
19,000
85,000
LED Crosswalk Waming System
17- 41600 -06
1
21,000
21,000
Road& Bridge Funds
21,000
21,000
Replacement - Data Collector[Total Station
1841600 -01
1
33,500
33,500
Equipment Bond
33,500
_
33,500
Engineering Total
871,000
569,500 607,000 1,088,000
809,000
3,944,500
Facility Management
Annual Parking Lot Maintenance 17 -01900 -01
1 90,000
130,000 30,000 30,000
30,000
310,000
Capital Equipment Reserve
30,000
130,000 30,000 30,000
30,000
250,000
Comm Ctr Operations
60,000
60,000
Replacement - Carpet /Tile 17 -01900 -02
2 10,000
10,000
10,000
30,000
Capital Equipment Reserve
10,000
10,000
10,000
30,000
Replacement- Security Management System 1741900 -03
1 100,000
100,000
Department Project# Priority 2017 2018 2019 2020 2021 Total
Capital Equipment Reserve
100,000
100,000
Public Works FaciltyNehicle Maim. Shop Construct
17- 41900 -04
1 35,000
500,000 15,000,000
19- 41400 -01
15,535,000
Capital Equipment Reserve
35,000
35,000
G.O. Bond
500,000 15,000,000
15,500,000
HD Cabling - City Hall
17 -01900 -05
1 60,000
Finance Total
60,000
Capital Equipment Reserve
60,000
60,000
Building A - Seal Floor
19- 41900 -01
1
25,000
25,000
Capital Equipment Reserve
25,000
1742200 -01
25,000
Pedestrian Tunnel Under Crosstown Blvd.
19- 41900 -05
1
450,000
20,000
450,000
G.O. Bond
450,000
20,000
450,000
Memorial - Veterans Memorial
19-41900 -06
1
10,000
17- 42200 -02
10,000
Capital Equipment Reserve
10,000
10,000
Surface Seal all Brick Structures
20- 41900 -01
1
80,000
85,000
85,000
Capital Equipment Reserve
80,000
Replacement- Grass #31
48,000
48,000
Comm Ctr Operations
85,000
12,000
12,000
Water Fund
-
25,000
25,000
Facility Management Total
295,000
630,000 15,525,000
115,000
40,000 16,605,000
Finance
Financial/ Payroll System Upgrade/ Replacement
19- 41400 -01
1
150,000
150,000
Capital Equipment Reserve
150,000
150,000
Finance Total
150,000
150,000
Fire
Replacement - Turnout Gear
1742200 -01
1
20,000
20,000
20,000
20,000
20,000
100,000
General Fund
20,000
20,000
20,000
20,000
20,000
100,000
Replacement- Extrication (Rescue) Equipment
17- 42200 -02
1
80,000
80,000
Capitaf Equipment Reserve
80,000
80,000
Replacement- Grass #31
1842200 -01
1
85,000
85,000
Equipment Bond
85,000
85,000
Replacement - Grass #21
18- 42200 -02
1
85,000
85,000
Equipment Bond
85,000
85,000
Replacement - Tanker #11
1942200 -01
1
400,000
400,000
Equipment Bond
-
400,000
400,000
Replacement- Grass Utility Vehicle (UTV) #4813
19 42200 -03
1
45,000
45,000
Equipment Bond
45,000
45,000
Replacement -1999 GMC Sonoma Truck (U -10) #4810
1942200 -05
2
45,000
45,000
Equipment Bond
45,000
45,000
Replacement - SCBA Compressors
2012200 -01
1
130,000
130,000
Equipment Bond
130,000
130,000
Replacement -800 MHz radios
20- 42200 -02
1
35,000
35,000
70,000
Capital Equipment Reserve
35,000
35,000
70,000
Replacement - Engine 21#4884
20 42200 -03
1
450,000
450,000
Equipment Bond
450,000
450,000
Fire Total
100,000
190,000
510,000
635,000
55,000
1,490,000
Information Technology
Smartboard Addition 18 -01420 -01 1
Capital Equipment Reserve
Information Technology Total
12,000
1Z000
12,000
12,000
12,000 12,000
Department
Project#
Priority
2017
2018
2019
2020
2021
Total
Park & Rec - Operations
Replace /Repair Play Structures - Various Parks
1745000 -01
1
50,000
50,000
50,000
50,000
50,000
250,000
General Fund
50,000
50,000
50,000
50,000
50,000
250,000
Replace /Repair Major Park Projects - VariousParks
17 -05000 -02
1
25,000
25,000
25,000
25,000
25,000
125,000
General Fund
25,000
25,000
25,000
25,000
25,000
125,000
Replacement- One Ton Crew Cab Pickup #502
17 45000 -03
1
50,000
50,000
Capital Equipment Reserve
50,000
50,000
New -Trail Machine
17 45000 -04
1
150,000
150,000
Capital Equipment Reserve
150,000
150,000
Replacement - One Ton Truck wl Plow #599
18 -05000 -01
1
80,000
80,000
Equipment Bond
80,000
80,000
New- Wood Ch ipper Tow-Be hind
18 -05000 -02
1
20,000
20,000
Equipment Bond
20,000
20,000
Replacement - Bobcat Track Loader #610
18 -05000 -03
1
55,000
55,000
Equipment Bond
55,000
55,000
Replacement - Small Extended Cab Truck #76
18145000 -04
1
55,000
55,000
Equipment Bond
55,000
55,000
New - "V' Snow Plow for #09-589
18- 45000 -05
1
15,000
15,000
Equipment Bond
15,000
15,000
Replacement- Water Tanker #161
19- 45000 -01
1
150,000
150,000
Equipment Bond
150,000
150,000
Replacement - Trailer #T555
1945000 -02
1
16,000
16,000
Equipment Bond
16,000
16,000
Replacement - Cushman Field Dresser #547
20 45000 -01
1
27,000
27,000
Equipment Bond
27,000
27,000
Park & Rec - Operations Total
275,000
300,000
241,000
102,000
75,000
993,000
Park & Rec - Projects
Annual Miscellaneous Park Projects
17- 45001 -01
1
15,000
15,000
15,000
15,000
15,000
75,000
Park Dedication Funds
15,000
15,000
15,000
15,000
15,000
75,000
Fox Meadows Park- Renovation
17 45001 -02
1
457,300
457,300
Park Dedication Funds
457,300
457,300
Pine Hills North - Phase II
17- 45001 -03
1
100,000
400,000
500,000
Capital Equipment Reserve
280,000
280,000
Donations
100,000
100,000
Park Dedication Funds
120,000
120,000
Irrigation Projects -Small Parks
17 -05001 -04
1
20,000
20,000
20,000
60,000
Park Dedication Funds
20,000
20,000
20,000
60,000
Nordeen's Park Basketball Court
17 -05001 -05
n/a
7,500
7,500
Park Dedication Funds
7,500
7,500
Wild Iris Park Irrigation and Water Service
1945001 -02
1
42,500
42,500
Park Dedication Funds
42,500
42,500
Park & Rec - Projects Total
599,800
35,000
35,000
457,500
15,000
1,142,300
Planning & Zoning
Replacement- Planning Vehicle #7
1741500 -01
1
30,000
30,000
Capital Equipment Reserve
30,000
30,000
Planning & Zoning Total
30,000
30,000
Sanitary Sewer
Sanitary Sewer Extensions
17- 48200 -01
1
105,000
500,000
605,000
Department Project# Priority 2017 2018 2019 2020 2021 Total
Assessments
105,000
105,000
Sewer Trunk Fund
500,000
500,000
Replacement - Jet/Vac Truck #99
1748200 -02
1 460,000
60,000
460,000
Sanitary Sewer Fund
65,000
230,000
Stone Sewer Fund
230,000
Sewer Trunk Fund
55,000
230,000
60,000
230,000
Lift Station #4 Upgrade
1748200 -03
1 50,000
18 -48300 -01
50,000
Sewer Trunk Fund
220,000
50,000
50,000
Yellow Pine Lift Station
18 48200 -01
1
650,000
650,000
Sewer Trunk Fund
650,000
650,000
Replacement - One Ton Utility Truck #69
18- 48200 -02
1
100,000
100,000
Sanitary Sewer Fund
100,000
100,000
Sanitary Sewer Total
615,000
1,250,000
1,865,000
Storm Sewer
Storm Sewer Improvements
17 -08300 -01
1
55,000
60,000
60,000
62,000
65,000
302,000
Stone Sewer Fund
55,000
60,000
60,000
62,000
65,000
302,000
Replacement - Tymoo Street Sweeper #172
18 -48300 -01
1
220,000
220,000
Equipment Bond
220,000
220,000
Replacement- Elgin Street Sweeper #169
19- 48300 -01
1
200,000
200,000
Equipment Bond
200,000
100,000
Storm Sewer Total
55,000
280,000
260,000
62,000
65,000
722,000
Street Signs
Sign Design Software and Plotter
17 43300 -01
2
10,000
10,000
Capital Equipment Reserve
10,000
10,000
Street Signs Total
10,000
10,000
Streets / Highways
Annual Street Seal Coat Project
17 43100 -01
1
725,000
250,000
260,000
275,000
285,000
1,795,000
Road &Bridge Funds
725,000
250,000
260,000
275,000
285,000
1,795,000
Annual Street Crack Seal Project
17 43100 -02
1
160,000
170,000
245,000
290,000
375,000
1,240,000
Construction Seal Coat Fund
17,000
8,000
10,000
10,000
10,000
55,000
Road &Bridge Funds
143,000
162,000
235,000
280,000
365,000
1,185,000
Annual Pavement Markings
17- 43100 -03
1
42,000
44,000
46,000
48,000
50,000
230,000
Road &Bridge Funds
42,000
44,000
46,000
48,000
50,000
230,000
Annual Curb Replacement
17- 43100 -04
1
50,000
52,000
54,000
56,000
58,000
270,000
Road &Bridge Funds
50,000
52,000
54,000
56,000
58,000
270,000
Municipal State Aid Routes / New & Reconstruct
17- 43100 -05
1
1,300,000
820,000
1,690,000
350,000
290,000
4,450,000
Assessments
243,000
75,500
144,000
15,000
15,000
492,500
Municipal State Aid Funds
1,057,000
744,500
1,546,000
335,000
275,000
3,957,500
Annual Street Reconstruction
17 43100 -06
1
1,236,000
821,000
1,143,000
1,092,000
1,268,000
5,560,000
Assessments
309,000
205,000
286,000
273,000
317,000
1,390,000
Road &Bridge Funds
927,000
616,000
857,000
819,000
951,000
4,170,000
Intersection Upgrades
17- 43100 -07
1
285,000
2,075,000
2,360,000
Grant
1,600,000
1,600,000
Municipal State Aid Funds
285,000
475,000
760,000
Gravel Road Improvements
1743100 -08
1
15,000
15,000
15,000
15,000
15,000
75,000
Road &Bridge Funds
15,000
15,000
15,000
15,000
15,000
75,000
Replacement - One Ton Truck w/ Plow #134
17- 43100 -11
1
80,000
80,000
Capital Equipment Reserve
80,000
80,000
New - One Ton Truck w/ Regular Box w/ Lift & Plow
1743100 -12
1
55,000
55,000
Capital Equipment Reserve
55,000
55,000
Department Project# Priority 2017 2018 2019 2020 2021 Total
New - Bobcat paver
17 -03100 -13
1
20,000
20,000
Capital Equipment Reserve
Replacement- Dodge Dakota #95
1748100 -02
20,000
20,000
Street Overlays
18 -03100 -01
1
400,000 400,000
800,000
Assessments
Replacement- Side by Side UTV #70
18 48100 -03
100,000 100,000
200,000
Road& Bridge Funds
Water Fund
300,000 300,000
600,000
New - Dump Truck w/ snow removal
19- 43100 -01
1
220,000
220,000
Equipment Bond
1948100 -01
Water Fund
220,000
220,000
Replacement- Dump Truck w/ Snow removal #198
20 -43100 -01
1
220,000
220,000
Equipment Bond
60,000
220,000
220,000
Replacement- Bobcat S185 #120
20 -03100 -02
1
50,000
50,000
Equipment Bond
50,000
50,000
Replacement - One Ton Truck w /P low #133
20 -03100 -03
1
80,000
80,000
Equipment Bond
16,000
80,000
80,000
Replacement - Backhoe Loader #80
20 -03100 -04
2
110,000
110,000
Equipment Bond
16,000
1
110,000
110,000
Replacement - Dump Truck w/ Snow removal #200
21113100 -01
1
220,000
220,000
Equipment Bond
220.000
220.000
Streets / Highways Total
Water
2,857,000
Rehabilitation of Wells
1748100 -01
Water Fund
17,835,000
Replacement- Dodge Dakota #95
1748100 -02
Sanitary Sewer Fund
50,000
Water Fund
250,000
Replacement - 3/4 Ton Utility Truck #66
.18 48100 -02
Water Fund
50,000
Replacement- Side by Side UTV #70
18 48100 -03
Sanitary Sewer Fund
Storm Sewer Fund
Water Fund
30,000
Water Main Improvements
1848100 -04
Assessments
Water Trunk Fund
15,000
Water Meter Reading System AMI /AMR
1948100 -01
Water Fund
Water Total
3,683,000
2,857,000
3,673,000
2,986,000
4,636,000
17,835,000
1 50,000
50,000
50,000
50,000
50,000
250,000
50,000
50,000
50,000
50,000
50,000
250,000
1 30,000
30,000
15,000
15,000
15,000
15,000
1
60,000
60,000
60,000
60,000
1
48,000
48,000
16,000
16,000
16,000
16,000
16,000
16,000
1
640,000
710,000
1,350,000
500,000
710,000
1,210,000
140,000
140,000
2
900,000
900,000
900,000
900,000
80,000
798,000
1,660,000
50,000
50,000
2,638,000
GRAND TOTAL 6,704,800 7,072,500 30,902,500 6,129,500 6,013,000 56,822,300
CITY OF ANDOVER
Capital Equipment Reserve Fund
Projected Fund Balance
2016 2017 2016 2019 2n2n 2ro1 Tnrei e
Projected Sources of Revenue
Capital Projects Levy 250,000 250,000 250,000 250,000 250,000 250,000 1,500,000
Capital Equipment Purchases Levy - 500,000 - - - - 500,000
Donations 2,000 2,000 - - - - 4,000
Miscellaneous Revenues 6,000 - - - - - 6,000
Operating Transfers In - - - _ _ - -
Total Revenues Available 268,000 762,000 250,000 250,000 260,000 260,000 2,010,000
Projected Commitments
Annual Parking Lot Maintenance
Andover Lions Park
Pine Hills North Parking Lot
Replacement - Crooked Lake School Hockey Rink
Microsoft Upgrade
Public Works / Community Center Master Planning
Replacement - SCBA's
Add /Replace - Server
Replacement - 800 MHz Radios
Sign Design Software & Plotter
Replacement - Secunty Management System
Replacement - Planning Vehicle #7
Public Works FacilityNehicle Maintenance Shop Construction
Replacement - Extrication (Rescue) Equipment
Replacement - One Ton Truck w/ Plow #134
New - One Ton Truck w/ Regular Box w/ Lift & Plow
Now - Bobcat Paver
Replacement - One Ton Crew Cab Pickup #502
New - Trail Machine
Replacement - Carpetf rile
Replacement - Emergency Sirens
Emergency Operations Center Improvements
HD Cabling - City Hall
Smartboard Addition
Financial / Payroll System Upgrade / Replacement
Building A - Seal Floor
Memorial - Veterans Memorial
Surface Seal all Brick Structures
30,000
30,000
130,000
30,000
30,000
30,000
280,000
19,980
93,663
19,980
Total Commitments
832,617
795,000
205,000
280,000
438,000
280,000
7,490
(574,617)
(43,000)
45,000
(27,500)
(188,000)
7,490
15,000
1,051,687
15,000
11,484
477,070
434,070
479,070
451,570
11,484
250,000
$ 477,070
$ 434,070 $
479,070
$ 451,570
$ 263,570 $
250,000
20,000
20,000
35,000
35,000
35,000
105,000
10,000
10,000
100,000
100,000
30,000
30,000
35,000
35,000
80,000
80,000
80,000
80,000
55,000
55,000
20,000
20,000
50,000
50,000
150,000
150,000
110,000
10,000
10,000
30,000
45,000
45,000
45,000
45,000
180,000
40,000
18,000
7,500
65,500
60,000
60,000
12,000
12,000
150,000
150,000
25,000
25,000
10,000
10,000
48,000
48,000
Natural Disaster Reserve
350,000
350,000
QCN - Council Chambers
93,663
93,663
Total Commitments
832,617
795,000
205,000
277,500
438,000
75,000 2,623,117
Revenues Over (Under) Expenditures
(574,617)
(43,000)
45,000
(27,500)
(188,000)
176,000
Fund Balance as of December 31, 2015
1,051,687
Fund Balance Brought Forward
477,070
434,070
479,070
451,570
263,570
Ending Fund Balance
$ 477,070
$ 434,070 $
479,070
$ 451,570
$ 263,570 $
438,570
CITY OF ANDOVER
Park Improvement Fund
Projected Fund Balance
* *Target - $50,000 to create a contingency for any project overages.
2016
2017
2018
2019
2020
2021
TOTALS
Projected Sources of Revenue
Park Dedication Fee - Residential Units
50
25
25
25
25
Park Dedication Fee - Residential ($2,952 /unit)
$ 365,830
$ 147,600
$ 73,800
$ 73,800
$ 73,800
$ 73,800
$ 808,630
Park Dedication Fee - Commercial
-
-
-
Donation / Contribution
-
100,000
-
-
-
-
100,000
Capital Projects Levy- Park Improvements
15,000
15,000
15,000
15,000
15,000
15,000
90,000
Total Revenues Available
380,830
262,600
88,800
88,800
88,800
88,800
998,630
Projected Commitments
Rose Park - tower rental fee
4,635
4,635
Lions Park - irrigation
17,042
17,042
Kelsey Round Lake Park - Master Plan
9,665
9,665
Timber Trails Park - Renovation
284,000
284,000
Terrace Park - Irrigation & Water Service
35,000
35,000
Sunshine Park - Scoreboard Wiring & Design
27,000
27,000
Irrigation Project - Small
20,000
20,000
20,000
60,000
Nordeen's Park - Basketball court
7,500
7,500
Fox Meadows - Reconstruction
457,300
457,300
Pine Hills North - Phase II
Storage Building (Donations)
100,000
100,000
Parking Lot w/ Curb (30% Park Dedication)
120,000
120,000
Wild Iris Park - Irrigation & Water Service
42,500
42,500
Annual Miscellaneous Projects
15,000
15,000
15,000
15,000
15,000
15,000
90,000
Total Commitments
392,342
599,800
35,000
35,000
177,500
15,000
1,254,642
Revenues Over (Under) Expenditures
(11,512)
(337,200)
53,800
53,800
(88,700)
73,800
Fund Balance as of December 31, 2015
376,632
Fund Balance Brought Forward
365,120
27,920
81,720
135,520
46,820
Ending Fund Balance "*
$ 365,120
$ 27,920
$ 81,720
$ 135,520
$ 46,820
$ 120,620
* *Target - $50,000 to create a contingency for any project overages.
CITY OF ANDOVER
Trail Fund
Projected Fund Balance
Projected Commitments
8' Bituminous Trail along Crosstown Blvd -
Coon Creek Bridge to S. Coon Creek Dr
5' Concrete Sidewalk along Bunker Lk Blvd -
Yukon St to Hidden Creek North Park
8' Bituminous Trail and Boardwalk along Crosstown Blvd -
Bunker Lk Blvd to 140th Ave
8' Bituminous Trail along Andover Blvd -
Bluebird St to Vale St
10' Bituminous Trail along WIDE site -
Kennsington Estates 7th Add. to Andover Station North
8' Bituminous Trail along Crosstown Blvd -
Xeon St to railroad tracks
Railroad tracks to 157th Ave
157th Ave to 159th Ave
8' Bituminous Trail along Verdin St-
161 st Ave to 163rd Lane
Total Commitments
Revenues Over (Under) Expenditures
Fund Balance as of December 31, 2015
Fund Balance Brought Forward
Ending Fund Balance *
220,000
220,000
55,000
55,000
565,000
565,000
225,000 225,000
265,000 265,000
2016
2017 2018 2019
2020 2021 TOTALS
Projected Sources of Revenue
165,000
Trail Fee $784 per unit
300,000
platted units
300,000
50 25 25
25 25
Trail Fee
$ 99,474
$ 39,200 $ 19,600 $ 19,600
$ 19,600 $ 19,600 $ 217,074
Grant
-
- - 265,000
- _ 265,000
Operating Transfer In
250,000
- - -
- - 250,000
Total Revenues Available
349,474
39,200 19,600 284,600
19,600 19,600 732,074
Projected Commitments
8' Bituminous Trail along Crosstown Blvd -
Coon Creek Bridge to S. Coon Creek Dr
5' Concrete Sidewalk along Bunker Lk Blvd -
Yukon St to Hidden Creek North Park
8' Bituminous Trail and Boardwalk along Crosstown Blvd -
Bunker Lk Blvd to 140th Ave
8' Bituminous Trail along Andover Blvd -
Bluebird St to Vale St
10' Bituminous Trail along WIDE site -
Kennsington Estates 7th Add. to Andover Station North
8' Bituminous Trail along Crosstown Blvd -
Xeon St to railroad tracks
Railroad tracks to 157th Ave
157th Ave to 159th Ave
8' Bituminous Trail along Verdin St-
161 st Ave to 163rd Lane
Total Commitments
Revenues Over (Under) Expenditures
Fund Balance as of December 31, 2015
Fund Balance Brought Forward
Ending Fund Balance *
220,000
220,000
55,000
55,000
565,000
565,000
225,000 225,000
265,000 265,000
*Target -10% of current years commitments to create a contingency for any project overages.
** It is anticipated that all projects will not be fully expended by the end of the year, and future projects will be contingent on additional revenues.
165,000
165,000
300,000
300,000
245,000
245,000
400,000
400,000
275,000
565,000
225,000
265,000
710,000
400,000
$ 2,440,000
74,474
(525,800)
(205,400)
19,600
(690,400)
(380,400)
347,400
421,874
(103,926)
(309,326)
(289,726)
(980,126)
$ 421,874
$ (103,926)
$ (309,326)
$ (289,726)
$ (980,126)
$ (1,360,526)
*Target -10% of current years commitments to create a contingency for any project overages.
** It is anticipated that all projects will not be fully expended by the end of the year, and future projects will be contingent on additional revenues.
CITY OF ANDOVER
Road & Bridge Funds - Rollup
Projected Fund Balance
* Assuming collected in same year
2016
2017
2018
2019
2020
2021
TOTALS
Projected Sources of Revenue
Est. Annual MSA Construction Allocation
$ 630,121
$ 1,161,947
$ 1,161,947
$ 1,161,947
$ 1,161,947
$ 1,161,947
$ 6,439,856
Est. Annual Maintenance Allocation
387,316
387,316
387,316
387,316
387,316
387,316
2,323,896
General Fund Commitment
(227,535)
(234,361)
(241,392)
(248,634)
(256,093)
(263,775)
(1,471,790)
Available MSA Maintenance
159,781
152,955
145,924
138,682
131,223
123,541
852,106
Total MSA Available for other Commitments
789,902
1,314,902
1,307,871
1,300,629
1,293,170
1,285,488
789,902
Federal /State Funds
Assessments*
-
1,053,000
-
552,000
-
380,500
-
430,000
-
388,000
1,600,000
332,000
1,600,000
3,135,500
LGA - Local Government Aid
2,706
-
-
Tax Levy
1,150,984
1,179,154
1,204,119
-
1,231,405
-
1,259,523
-
1,288,503
2,706
7,313,688
Total Revenues Available
2,996,592
3,046,056
2,892,490
2,962,034
2,940,693
4,505,991
12,841,796
Projected Commitments
MSA- New& Reconstruct Routes
2,600,000
1,300,000
820,000
1,690,000
350,000
290,000
7,050,000
MSA- Intersection Upgrades
-
-
285,000
-
-
2,075,000
2,360,000
R & B - Pavement Markings
40,000
42,000
44,000
46,000
48,000
50,000
270,000
R & B - Curb Replacement
50,000
50,000
52,000
54,000
56,000
58,000
320,000
R & B - New & Reconstruct Routes
693,000
1,236,000
821,000
1,143,000
1,092,000
1,268,000
6,253,000
R & B - Seal Coating
460,000
725,000
250,000
260,000
275,000
285,000
2,255,000
R & B - Crack Sealing
225,000
143,000
162,000
235,000
280,000
365,000
1,410,000
R & B - Gravel Road Improvements
15,000
15,000
15,000
15,000
15,000
15,000
90,000
R & B - Overlays
-
-
400,000
-
400,000
800,000
Pedestrian Trail Reconstruction
50,000
60,000
80,000
100,000
120,000
140,000
550,000
Pedestrian Trail Curb Ramp Replacements
-
15,000
16,000
17,000
18,000
19,000
85,000
Pedestrian LED Crosswalk Warning System
-
21,000
-
Pedestrian Trail Maintenance
45,000
50,000
55,000
-
60,000
-
65,000
-
70,000
21,000
345,000
Total Commitments
4,178,000
3,657,000
3,000,000
3,620,000
2,719,000
4,635,000
21,809,000
Revenues Over (Under) Expenditures
(1,181,408)
(610,944)
(107,510)
(657,966)
221,693
(129,009)
Fund Balance as of December 31, 2015
5,511,747
Fund Balance Brought Forward
4,330,339
3,719,395
3,611,885
2,953,919
3,175,613
Ending Fund Balance
$ 4,330,339
$ 3,719,395
$ 3,611,885
$ 2,953,919
$ 3,175,613
$ 3,046,603
* Assuming collected in same year
CITY OF ANDOVER
MSA Funded Projects
Projected Fund Balance
2016
2017
2018
2019
2020
2021
TOTALS
Projected Sources of Revenue
Est. Annual MSA Construction Allocation
$ 630,121
$ 1,161,947
$ 1,161,947
$ 1,161,947
$ 1,161,947
$ 1,161,947
$ 6,439,856
Est. Annual Maintenance Allocation
387,316
387,316
387,316
387,316
387,316
387,316
2,323,896
General Fund Commitment
(227,535)
(234,361)
(241,392)
(248,634)
(256,093)
(263,775)
(1,471,790)
Available MSA Maintenance
159,781
152,955
145,924
138,682
131,223
123,541
852,106
Total MSA Available for other Commitments
789,902
1,314,902
1,307,871
1,300,629
1,293,170
1,285,488
7,291,962
Federal /State Funds
-
-
-
-
-
1,600,000
1,600,000
Assessments*
850,000
243,000
75,500
144,000
15,000
15,000
1,342,500
Total Revenues Available
1,639,902
1,557,902
1,383,371
1,444,629
1,308,170
2,900,488
10,234,462
Projected Commitments
MSA - New & Reconstruct Routes
2,600,000
1,300,000
820,000
1,690,000
350,000
290,000
7,050,000
MSA - Intersection Upgrades
-
-
285,000
-
-
2,075,000
2,360,000
Total Commitments
2,600,000
1,300,000
1,105,000
1,690,000
350,000
2,365,000
9,410,000
Revenues Over (Under) Expenditures
(960,098)
257,902
278,371
(245,371)
958,170
535,488
824,462
Fund Balance as of December 31, 2015
1,654,830
Fund Balance Brought Forward
694,732
952,634
1,231,005
985,634
1,943,805
Ending Fund Balance
$ 694,732
$ 952,634
$ 1,231,005
$ 985,634
$ 1,943,805
$ 2,479,292
. Projected Sources of Revenue
Tax Levy
LGA - Local Government Aid
Assessments
Total Revenues Available
Projected Commitments
R & B - Pavement Markings
R & B - Curb Replacement
R & B - New & Reconstruct Routes
R & B - Seal Coating
R & B - Crack Sealing
R & B - Gravel Road Improvements
R & B - Overlays
Total Commitments
Revenues Over (Under) Expenditures
Fund Balance as of December 31, 2015
Fund Balance Brought Forward
Ending Fund Balance
CITY OF ANDOVER
Tax Levy Funded - Roadway Projects
Projected Fund Balance
2016
2017
2018
2019
2020
2021
TOTALS
1,089,146
1,116,079
1,139,782
1,165,781
1,192,587
1,220,228
6,923,603
2,706
-
-
-
2,706
203,000
309,000
305,000
286,000
373,000
317,000
1,793,000
1,294,852
1,425,079
1,444,782
1,451,781
1,565,587
1,537,228
8,719,309
40,000
42,000
44,000
46,000
48,000
50,000
270,000
50,000
50,000.
52,000
54,000
56,000
58,000
320,000
693,000
1,236,000
821,000
1,143,000
1,092,000
1,268,000
6,253,000
460,000
725,000
250,000
260,000
275,000
285,000
2,255,000
225,000
143,000
162,000
235,000
280,000
365,000
1,410,000
15,000
15,000
15,000
15,000
15,000
15,000
90,000
-
-
400,000
-
400,000
-
800,000
1,483,000
2,211,000
1,744,000
1,753,000
2,166,000
2,041,000
11,398,000
(188,148)
(785,921)
(299,218)
(301,219)
(600,413)
(503,772)
(2,678,691)
3,642,994
3,454,846
2,668,925
2,369,707
2,068,488
1,468,075
$ 3,454,846
$ 2,668,925
$ 2,369,707
$ 2,068,488
$ 1,468,075
$ 964,303
Projected Sources of Revenue
LGA - Local Government Aid
Tax Levy
Total Revenues Available
Projected Commitments
R & B - Pedestrian Trail Reconstruction
R & B - Pedestrian Trail Curb Ramp Replacements
R & B - Pedestrian LED Crosswalk Warning System
R & B - Pedestrian Trail Maintenance
Revenues Over(Under)Expenditures
Fund Balance as of December 31, 2015
Fund Balance Brought Forward
Ending Fund Balance
CITY OF ANDOVER
Tax Levy Funded - Pedestrian Trail Maintenance
Projected Fund Balance
2016
2017
2018
2019
2020
2021
TOTALS
61,838
63,075
64,337
65,624
66,936
68,275
$ 390,085
61,838
63,075
64,337
65,624
66,936
68,275
390,085
50,000
60,000
80,000
100,000
120,000
140,000
550,000
-
15,000
16,000
17,000
18,000
19,000
85,000
-
21,000
-
-
-
-
21,000
45,000
50,000
55,000
60,000
65,000
70,000
345,000
95,000
146,000
151,000
177,000
203,000
229,000
1,001,000
(33,162)
(82,925)
(86,663)
(111,376)
(136,064)
(160,725)
(610,915)
213,923
180,761
97,836
11,173
(100,203)
(236,267)
$ 180,761
$ 97,836
$ 11,173
$ (100,203)
$ (236,267)
$ (396,992)
City of Andover
Road & Bridge Fund
Tax Levy Computation
Overlay Program
$ 203,269
$ 203,269
$ 203,269
$ 203,269
$ 203,269
$ 203,269
$ 203,269 $
203,269
$ 203,269
"Road and Bridge Analysis with capturing 1 % of the tax capacity levy and increased by a 3% factor annually.
$ 203,269
$ 203,269
Current Year Adjustment
(42,423)
51,178
13,105
(25,956)
13,285
"Assumes 1 %tax capacity growth, to be adjusted up or down based on actuals annually.
8,155
1,516
-
-
-0.98%
403,077
2% of Adj. Net Tax Capacity
544,708
497,424
' "2002 is established a the base year for computation purposes.
457,111
446,008
525,185
547,938
566,742
578,179
589,845
601,744
613,882
Crack Seal & Seal Coating
$ 705,554
$ 751,871
$ 660,882
$ 634,424
$ 662,562
$ 712,702
$ 769,362 $
771,527
$ 781,448
"Assumes a 2% annual inflationary increase, with 2002 as base year.
$ 805,013
$ 817,161
-4.00%
(95,690)
46,317
(90,989)
(26,458)
28,138
50,140
46,660
12,165
9,921
11,666
11,899
Estimate
Estimate
Estimate
Estimate
Estimate
2010 2011 2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
695,587
Net Tax Capacity $ 28,726,619 $ 26,174,350 $ 23,449,581
$ 22,569,018
$ 21,978,322
$ 25,705,350
$ 26,847,273
$ 27,760,080
$ 28,315,282
$ 28,881,587
$ 29,459,219
$ 30,048,403
Growth Factor -8.65% -8.88% - 10.41%
-3.76%
-2.62%
16.96%
4.44%
3.40%
2.00%
2.00%
2.00%
2.00%
Less: TIF (2,284,466) (2,027,557) (1,871,512)
(379,163)
(327,433)
(210,936)
(248,327)
(248,327)
(248,327)
(248,327)
(248,327)
(248,327)
Adjusted Net Tax Capacity $ 26,442,153 $ 24,146,793 _L 21,578,069
_L 22,189,855
_L 21,650,889
$ 25,494,414
$ 26,598,946
$ 27,611,753
$ 28,066,955
$ 28,633,260
$ 29,210,892
$ 29,800,076
Growth factor -9.14% -8.68% - 10.64%
2.84%
-2.43%
17.75%
4.33%
3.43%
2.02%
2.02%
2.02%
2.02%
Oveday Calculation
Base Amount
$ 203,269
$ 203,269
$ 203,269
$ 203,269
$ 203,269
$ 203,269
$ 203,269 $
203,269
$ 203,269
$ 203,269
$ 203,269
$ 203,269
Current Year Adjustment
(42,423)
51,178
13,105
(25,956)
13,285
(15,752)
8,155
1,516
-
-
-0.98%
403,077
2% of Adj. Net Tax Capacity
544,708
497,424
444,508
457,111
446,008
525,185
547,938
566,742
578,179
589,845
601,744
613,882
660,882
$ 705,554
$ 751,871
$ 660,882
$ 634,424
$ 662,562
$ 712,702
$ 769,362 $
771,527
$ 781,448
$ 793,114
$ 805,013
$ 817,161
-4.00%
(95,690)
46,317
(90,989)
(26,458)
28,138
50,140
46,660
12,165
9,921
11,666
11,899
12,137
58,271
2010
2011
2012
2013
2 -
014--F
2015
2016
65,624
3.00%
66,936
0.00%
Total
Est
695,587
687,588
673,733
647,095
678,314
702,147
749,691
$
1,025,468
2.00%
2.00%
Act
747,977
700,693
647,777
660,380
662,562
710,302
751,207
1,231,405
$
1,259,523
$
1,288,503
52,390
13,105
(25,956)
13,285
(15,752)
8,155
1,516
2016
2010
2011
2012
2013
2014
Crack Sealing & Seal Coating
$
304,469
$
313,088
$
361,935
$
332,773
$
346,058
$
387,574
-0.98%
403,077
2.83%
15.60%
- 8.06/
3.99%
Overlays/ Street Recon
$
698,587
$
751,871
$
660,882
$
634,424
$
621,139
$
781,448
- 17.35%
793,114
7.63%
805,013
- 12.10%
817,151
-4.00%
-2.09%
Pedestrian Trails
$
51,773
$
54,926
$
56,574
$
58,271
$
58,271
$
61,838
0.00%
63,075
6.09%
64,337
3.00%
65,624
3.00%
66,936
0.00%
Total
$
1,054,829
$
1,119,885
$
1,079,391
$
1,025,468
$
1,025,468
2016
2016
2017
2018
2019
2020
2020
$ 254,495
$
329,784
$
344,552
$
358,334
$
372,667
$
387,574
$
403,077
- 26.46%
29.58%
4.48%
4.00%
4.00%
4.00%
4.00%
$ 712,702
$
759,362
$
771,527
$
781,448
$
793,114
$
805,013
$
817,151
14.74%
6.55%
1.60%
1.29%
1.49%
1.50%
1.51%
$ 58,271
$
61,838
$
63,075
$
64,337
$
65,624
$
66,936
$
68,275
0.00%
6.12%
2.00%
2.00%
2.00%
2.00%
2.00%
$ 1,025,468
$
1,150,984
$
1,179,154
$
1,204,119
$
1,231,405
$
1,259,523
$
1,288,503
R & B Fund $ 1,064,959 $ 1,022,817 $ 967,197 $ 967,197 $ 967,197 $ 1,089,146 $ 1,116,079 $ 1,139,782 $ 1,165,781 $ 1,192,587 $ 1,220,226
Trail $ 54,926 $ 56,574 $ 58,271 $ 58,271 $ 58,271 $ 61,838 $ 63,075 $ 64,337 $ 65,624 $ 66,936 $ 68,275
$ 1,119,885 $ 1,079,391 $ 1,025,468 $ 1,025,468 $ 1,025,468 $ 1,150,984 $ 1,179,154 $ 1,204,119 $ 1,231,405 $ 1,259,523 $ 1,288,503
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755 -5100
FAX (763) 755 -8923 • WWW.CI.ANDOVER.MN.US
TO:
FROM:
SUBJECT:
DATE:
Mayor and Councilmembers
Jim Dickinson, City Administrator
2017 Budget Development Discussion
July 26, 2016
INTRODUCTION
City Administration/Finance along with the Department Heads are working on the 2017 Annual
Operating Budget Development process and are looking for City Council direction as the
preparation of the 2017 Annual Operating Budget proceeds.
DISCUSSION
The following are the 2017 Budget Development guidelines were 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 through the use of sustainable revenue
sources and operational efficiencies.
Note: Preliminary Anoka County Assessor taxable market value figures for the City of
Andover are reflecting a 4.23% increase in total taxable market value. There will be
adjustments to the valuations up until the end of the year, the most substantive change will
be in response to the TIFDistrict 1 -3 & 1 -4 decertification
2) A fiscal goal that works toward establishing the General Fund balance for working capital at
no less than 45% of planned 2017 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 2016 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% would be appropriate and are
recommended by the City's auditor. Emergency Fund Balances (approximately 3% of
planned General Fund expenditures) are in place to stabilize a situation, not be a complete
solution.
3) A commitment to limit the 2017 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 2016 debt levy was 18.12% of the gross tax levy, the 25% guideline for
2017 will be met easily as $500,000 of existing debt levy was moved to a Capital Levy for
2017 to fund planned equipment purchases. This change will decrease the proposed 2017
debt levy to only 13.57% of the gross tax levy.
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 on the basis of a cost
benefit analysis rather than a year based replacement schedule.
Note: The City Vehicle Purchasing Committee has completed this analysis, and has made
recommendations to the City Council as part of the 2017 -2021 Capital Improvement
Plan(CIP) development process. This will be covered in more detail with the CIP
discussion.
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 complex set of financial data including growth factors, tax capacity valuations, per
capita spending and debt ratios.
6) Continued commitment to strategic planning targeted toward meeting immediate and long-
term operational, staffing, infrastructure and facility needs.
Note: A strategic planning session was held with the City Council in 2015, with a final
Council Community Vision and Organizational Goals and Values document approved by the
City Council. Direction provided in that document is integrated into various department
workplans 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: Management will pay special attention to fiscal values, commercial & residential
development or redevelopment, collaboration opportunities, service delivery and the
livability /image of the community.
Staffing:
Department head deadline to submit new staffing requests for the 2017 Budget was July M.
A request was made for a new Public Works Maintenance Worker for the Streets Department
and a request was made by the Fire Department to consider an expansion of hours of the Fire
Department Duty Crew.
Also there are some anticipated retirements and staff vacancies in the next few years; in response
Administration has made a concerted effort to focus on appropriate succession planning,
effective utilization of internship opportunities in various departments and continued cross-
training of City Hall office staff.
Personnel Related Implications:
To date the following are projected issues facing personnel related expenses:
Human Resources has reviewed position -based salaries and our benefit package in detail
to determine if the total package is competitive with other government entities.
Administration will include a budget for market adjustments for a few positions.
Pay steps for eligible employees are included in the 2017 budget proposal A cost of
living adiustment (COLA) for non - bargaining employees will also be included similar
to the Public Works Union contract not set to expire until December 31 2017
2. A midyear review of the health plan will be conducted with our broker. The current
employee health & dental plan provider is HealthPartners and while we have a second
Vear rate increase guarantee max, Administration anticipates coming in under the rate
increase guarantee max.
The City currently offers the employees a high deductible plan ($5,000 family, $2,500
single for in network expenses) with a health spending account (HSA). As part of the
program, the City pays for 100% of the single health insurance premium for an
accountable care plan and 76% for a family health insurance premium. The City does
contribute annually to the employees HSA.
Contractual Departments:
1. The City Attorney 2016 contract included a 2.5% increase over the 2015 rate.
Discussion for the 2017 contract is if City employees are granted a COLA the legal
service contract would be treated the same.
2. The City of Andover has a Law Enforcement Contract with the Anoka County Sheriff's
Office. The 2016 budget for the contract is $2,936,467 and is offset by a Police State Aid
of $124,800 and School Liaison revenue of $91,820 reflecting a net tax levy impact of
$2,719,847.
The 2016 Sheriff's contract provides for:
a. 80 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.
It should be noted that the Sheriff's Department always provides the required number of
deputies for all hours contracted by the City. If the Sheriff's Department has a 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
The 2016 contract maintained status quo service when compared to 2015, but significant
attention was done relative to equipment purchasing and maintenance. The 2016 contract
reflected a 0.62% increase ($18,159) over the 2015 contract.
Staff has had discussions with the Anoka County Sheriff for a 2017 contract and
the Anoka County Sheriff was before the City Council at the May 24th workshop
meeting. Direction from that workshop was for Administration to work with the
Sheriff and brine back a few costing options to a future workshop Administration
will reviewed the four (4) costing options with the Council at the June workshop A
summary of the options are listed below:
1. Status Quo Contract: the 2017 contract would reflect a 0.71% increase ($19,844)
over the 2016 contract.
2. Status Quo Contract, plus add a Drug Task Force Deputy: the 2017 contract
would reflect a 5.01% increase ($141,855) over the 2016 contract.
3. Reduce Patrol Coverage to 72 hours per day: the 2017 contract would reflect a
7.80% decrease ($219,198) below the 2016 contract. (Not recommended by the
Sheriff)
4. Reduce Patrol Coverage to 72 hours per day, plus add a Drug Task Force Deputy:
the 2017 contract would reflect a 3.44% decrease ($96,822) below the 2016
contract.
Based on Council direction, Administration is focusing on option 1 a Status Quo
Contract.
Council Memberships and Donations /Contributions:
The following memberships /contributions are included in the 2016 Budget, updated for 2017:
•
North Metro Mayors Association
$13,709
•
Metro Cities
$ 9,512
•
Mediation Services
$ 3,366
•
YMCA — Water Safety Program
$ 8,500
•
Alexandra House
$18,328
•
Youth First (Program Funding)
$12,000
•
NW Anoka Co. Community Consortium - JPA
$10,000
•
Teen Center Funding (YMCA)
$24,500
•
Family of Promise
$ 3,000
•
Lee Carlson Central Center for Family Resources
$ 1,500
•
Senior High Parties
$ 1,000
•
Stepping Stone
$ 600
Capital Projects Levy:
Capital Projects Levy — The 2016 Capital Projects Levy Budget specifically designates
$1,415,984 of the general tax levy to capital projects and equipment needs relating to Capital
Outlay ($250,000), Road and Bridge ($1,089,146), Pedestrian Trail Maintenance ($61,838) and
Park Projects ($15,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 and Park Levies increased/decreased according to the City Council
budget guidelines.
Lookinz to 2017, Administration /Finance has recommendations identified below. For the
2017 equipment Purchases Administration/Finance is proposing a straight Capital Levy for
the 2017 equipment purchases rather than through debt service levy and an equipment bond
Administration will review this in detail with the Council at the meeting.
• 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 largely gone away (down to $2,706) for 2016 For 2017 Administration
was notified by State that the City will receive "NO" LGA
For 2016, the levy to Road & Bridge is $1,089,146 a 9.39% increase over 2015
recognizing the significant 2015 taxable market value increase and lost LGA
Administration will be proposing a 2.47% increase in the Road & Bridge levy for 2017
The 2016 levy to pedestrian trail maintenance is $61838 that was a 6.1% increase over
2015. Administration will be proposing a 2.0% increase in the Pedestrian Trail
Maintenance levy for 2017
• 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 be assigned to Parks Repair/Replacement items for
a total levy of $90,000 in 2016.
History of the supplemental Park Improvement Funding_
In 2002, City Council committed $50,000 in tax levy to underwrite park improvement
projects as recommended by the Park and Recreation Commission and approved by City
Council. That levy was intended to be a supplemental source of capital funding for park
projects as development started to slow down and minimal park dedication funds were
available. As of 2015, that levy was up to $61,500 of which $15,000 was designated
towards miscellaneous items that come up throughout the year.
New direction of the Funding in 2016:
With an emphasis on maintaining/preserving parks the City currently has, through the
2016 Budget / Levy process, the City Council re- assigned $46,500 of the Park
Improvement Levy to the General Fund to focus on Park's maintenance /replacement
items. A residual $15,000 of levy remained to the Park Improvement Fund to take care
of miscellaneous items that come up throughout the year that the Park and Recreation
Commission will continue to participate in. A $90,000 tax levy ($46,500 combined with
an additional $43,500 of General Fund levy funding) is now identified as part of the
General Fund levy to replace playground equipment, fences, pedestrian bridges in parks,
parking lot reconstruction, etc. The Parks Maintenance Department will determine which
replacement items have the highest priority through the Capital Improvement Plan (CIP).
Any unused funds in any given year will be specifically designated or carried forward for
future park replacement items. If a park is to be reconstructed as recommended by the
Park and Recreation Commission and approved by City Council through the CIP process,
the Park and Recreation Commission will work with the Parks Maintenance Department
to determine which items are replacements and which items are considered new and /or
enhancements to determine the mix of funding sources to accomplish the project.
• Equipment/Projects
Under the Capital Projects Levy, a levy is proposed to be designated to capital
improvement/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 2016 levy is
$250,000, Administration will be recommending the same for 2017.
Debt Service Levy:
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 a
review and no new refinancing opportunities are available at this time • we continue to monitor,)
The proposed 2017 Debt Service levy is as follows:
• 2010A G.O. Open Space Referendum $ 187,840
• 2012C Taxable G.O. Abatement Bonds $ 974,418
• 2014A G.O. Equipment Certificates $ 295,260
• 2016A G.O. Equipment Certificates $ 152,529
• Proposed New Bond Issuance $ 500,000 (Moved to a Capital Levy)
Total
$2J109047 $19610,047
It should be noted that the levy is offset significantly by a $635,000 YMCA annual rental
payment for the Community Center bonds (2012C Taxable G.O. Abatement Bonds).
The proposed 2017 Debt Service levy reflects a 23.35% decrease ($490,366) as the City
proposed to do a straight Capital Levy for the 2017 equipment purchases rather than an
equipment bond.
ACTION REQUESTED
The Council is requested to receive a presentation and provide direction to staff.
fitted,
CITY OF ANDOVER
Pay 2017 Valuation Estimates
Taxable Market Value
% Change
Pay 2014 $ 2,071,812,281
Pay 2015 $ 2,435,770,612 17.57%
Pay 2016 $ 2,539,686,867 4.27%
Pay 2017 $ 2,647,133,414 4.23% O
Taxable Market Values
$3,000,000,000
$2,500,000,000
$2,000,000,000
$1,500,000,000
$1,000,000,000
$500,000,000
$0
Pay 2014 Pay 2015 Pay 2016 Pay 2017
Tax Capacity Value
% Change
Pay 2014 $ 21,978,322
Pay 2015 $ 25,705,350 16.96%
Pay 2016 $ 26,847,273 4.44%
Pay 2017 $ 27,760,080 3.40%
Tax Capacity Values
$30,000,000
$25,000,000
$20,000,000
$15,000,000
$10,000,000
$5,000,000
$0
Pay 2014 Pay 2015 Pay 2016 Pay 2017
Pay 2014
Pay 2015
Pay 2016
Pay 2017 - Est
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
$ 2,071,812,281 $ 21,978,322
$ 2,435,770,612 $ 25,705,350
$ 2,539,686,867 $ 26,847,273
$ 2,647,133,414
$ 27,760,080
Captured Tax Increment
p
(327,433)
(210,936)
(248,327)
(248,327)
Fiscal Disparity Contribution
(1,035,107)
(998,390)
(1,055,284
(1,124,214)
Local Tax Rate Value
20,615,782
24,496,024
25,543,662
26,387,539
Fiscal Disparity Distribution
4,202,605
4,257,801
4,264,789
4,364,789
Total Adjusted Values
$ 24,818,387
$ 28,753,825
$ 29,808,451
$ 30,752,328
15.86%
3.67%
3.17%
Taxable Market Value
% Change
Pay 2014 $ 2,071,812,281
Pay 2015 $ 2,435,770,612 17.57%
Pay 2016 $ 2,539,686,867 4.27%
Pay 2017 $ 2,647,133,414 4.23% O
Taxable Market Values
$3,000,000,000
$2,500,000,000
$2,000,000,000
$1,500,000,000
$1,000,000,000
$500,000,000
$0
Pay 2014 Pay 2015 Pay 2016 Pay 2017
Tax Capacity Value
% Change
Pay 2014 $ 21,978,322
Pay 2015 $ 25,705,350 16.96%
Pay 2016 $ 26,847,273 4.44%
Pay 2017 $ 27,760,080 3.40%
Tax Capacity Values
$30,000,000
$25,000,000
$20,000,000
$15,000,000
$10,000,000
$5,000,000
$0
Pay 2014 Pay 2015 Pay 2016 Pay 2017
City of Andover, Minnesota
Property Tax Levy
Other Levies
Capital Projects Levy
Capital Equipment/Pmject
210,000
210,000
210,000
250,000
250,000
Preliminary
2.11%
$
-
0.00%
Certified
Certified
Certified
Certified
Certified
Requested
Change
2012
2013
2014
2015
2016
2017
%of Total
$
%
General Fund Levy
4.21%
$
500,000
#DIV /01
Parks Projects
61,500
61,500
61,500
General Operations
$ 7,332,857
$ 7,332,857
$ 7,435,891
$ 7,630,892
$ 7,947,528
$ 8,179,354
68.95%
$ 231,826
2.92%
Parks Repair /Replacement Items
967,197
967,197
1,089,146
1,116,079
90,000
90,000
0.76%
$
0.00%
Total General Fund
7,332,857
7,332,857
7,435,891
7,630,892
8,037,528
8,269,354
69.70%
$ 231,826
2.88%
Debt Service Funds Levy
Lower Rum River Watershed
40,000
40,000
40,000
40,000
40,000
40,000
0.34%
2004A G.O. Capital Improvement Bonds
405,292
381,290
-
-
-
-
1,336,968
1,376,968
1,455,984
2004 EDA Public Facility Revenue Bonds
1,092,684
452,082
181,803
-
-
-
10,631,299
10,631,299
10,843,925
2010A G.O. Open Space Referendum Bonds
182,558
184,973
187,283
184,238
186,291
187,840
Less Fiscal Disparities Distribution
1,791,496
2011A G.O. Equipment Certificate
102,017
101,745
-
-
-
-
2012A G.O. Equipment Certificate
125,000
125,000
140,000
140,000
142,885
-
20128 G.O. Cap Improv Refunding Bonds
-
138,339
561,015
540,120
498,435
-
$ 186,291
$ 187,840
2012C Taxable G.O. Abatement Bonds
-
578,045
740,965
975,652
977,332
974,416
$ 8,938,489
$ 9,113,392
$ 9,820,887
2014A G.O. Equipment Certificate
-
-
260,000
296,055
295,470
295,260
20,514,674
21,155,263
20,615,782
2016A G.O. Equipment Certificate
25,543,662
26,387,539
152,529
Total Debt Service
1,907,551
1,961,474
2,071,066
2,136,065
2,100,413
1,610,047
13.57%
$ (490,366)
- 23.35%
Other Levies
Capital Projects Levy
Capital Equipment/Pmject
210,000
210,000
210,000
250,000
250,000
250,000
2.11%
$
-
0.00%
�(
Capital Equipment Purchases
-
-
-
-
-
500,000 ter'
4.21%
$
500,000
#DIV /01
Parks Projects
61,500
61,500
61,500
61,500
15,000
15,000
0.13%
$
-
0.00%
Road &Bridge
1,022,817
967,197
967,197
967,197
1,089,146
1,116,079
9.41%
$
26,933
2.47%
Pedestrian Trail Maintenance
56,574
58,271
58,271
58,271
61,638
63,075
0.53%
$
1,237
2.00%
Lower Rum River Watershed
40,000
40,000
40,000
40,000
40,000
40,000
0.34%
$
0.00%
Total Other
1,390,891
1,336,968
1,336,968
1,376,968
1,455,984
1,984,154
16.72%
$
528,170
36.28%
Gross City Levy
10,631,299
10,631,299
10,843,925
11,143,925
11,593,925
11,863,555
100%
$
269,630
2.33%
Less Fiscal Disparities Distribution
1,791,496
1,798,577
1,718,153
1,846,295
1,586,747
1,631,840
Local Tax Rate Levy
$ 8,839,803
$ 8,832,722
$ 9,125,772
$ 9,297,630
$ 10,007,178
$ 10,231,715
Less Levy Based on Market Value
$ (182,558)
$ (184,973(
$ (187,283 )
$ 184,238
$ 186,291
$ 187,840
Net Local Tax Rate Levy
$ 8,657,245
$ 8,647,749
$ 8,938,489
$ 9,113,392
$ 9,820,887
$ 10,043,875
Adjusted Tax Capacity Value"
20,514,674
21,155,263
20,615,782
24,496,024
25,543,662
26,387,539
3.30%
Chance
%Chance
Tax Capacity Rate-
42.200%
40.878%
43.358%
37.204%
38.447%
38.063%
- 0.385%
- 1.000%
Tax Capacity Rate W/O LRRWSD
38.407%
42.090%
43.197%
37.070%
38.314%
Tax Capacity Rate With LRRWSD
38.746%
42.539%
43.657%
37.461%
38.702%
Voter Approved Ref - MV
0.00568%
0.00778%
0.00841%
0.00719%
0.00699%
"Adjusted Value determined by adjusting for Fiscal Disparities and Tax Increment estimates
- Blended rate due to the City of Andover levying for Lower Rum River Watershed District
(1) Adjusted Tax Capacity Value is subject to change.
r!
City of Andover
General Fund
2016 Fund Balance Analysis
December 31, 2015
2016 Estimated Fund Balance Increase (Decrease)
Projected December 31, 2016
Less: Snow Emergency
Public Safety
Facility Management
Information Technology
2017 Budgeted Use of Fund Balance
Economic Development
Prepaids / Inventories
Working Cash Flow
Estimated Balance Available for Adjustments
2016 Working Cash Flow Designation Calculation:
2017 Requested Expenditure - Preliminary Estimate
% of 2017 General Fund Expenditures
Requested
Actual
$ 7,267,904
(481, 791)
6,786,113
(80,000)
(80,000)
(80,000)
(80,000)
Mq�rhPS
(277,499)
RP�Pnvp }
(300,000)
(131,813)
Fa(pvns�
(5,494,151)
S�a1nGt�5
$ 262,650
$10,988,302
50.000%
$ 5,494,151
CITY OF ANDOVER
General Fund
Revenue & Expense Summary
EXPENDITURES
General Government
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested *
Budget Change ( *)
3.10%
Public Safety
2011
2012
2013
2014
2015
2016
2016
2017
$
%
REVENUES
2,451,850
2,482,490
2,759,342
2,819,372
2,817,981
3,105,187
3,088,424
3,140,511
35,324
1.14%
Property Taxes
$ 7,115,936
$ 7,340,532
$ 7,376,284
$ 7,476,295
$ 7,634,715
$ 8,113,528
$ 8,113,528
$ 8,345,354
231,826
2.86%
License and Permits
387,206
449,826
- 536,707
364,430
452,616
346,205
365,025
359,205
13,000
3.76%
Intergovernmental Revenues
566,706
653,720
710,071
697,491
749,570
673,248
685,488
764,314
91,066
13.53%
Charges for Current Services
866,584
973,604
1,122,460
998,150
804,684
767,950
750,250
746,450
(21,500)
- 2.80%
Fines and Forfeits
99,777
97,571
96,130
94,375
99,304
100,750
100,750
100,750
-
0.00%
Interest Income
130,368
95,365
(17,096)
144,876
63,709
75,000
75,000
75,000
-
0.00%
Miscellaneous Revenue
127,509
149,857
140,983
150,759
154,239
116,800
124,300
122,800
6,000
5.14%
Transfers
196,930
196,930
196,930
196,930
196,930
196,930
196,930
196,930
0.00%
TOTAL REVENUES
9,491,016
9,957,405
10,162,469
10,123,306
10,155,767
10,390,411
10,411,271
10,710,803
320,392
3.08%
EXPENDITURES
General Government
2,271,094
2,223,773
2,308,882
2,481,927
2,511,970
2,828,272
2,792,859
2,915,962
87,690
3.10%
Public Safety
3,960,221
4,087,065
4,311,340
4,498,920
4,503,332
4,694,001
4,691,451
4,861,501
167,500
3.57%
Public Works
2,451,850
2,482,490
2,759,342
2,819,372
2,817,981
3,105,187
3,088,424
3,140,511
35,324
1.14%
Other
30,631
663,372
210,510
81,185
256,720
70,328
320,328
70,328
-
0.00%
TOTAL EXPENDITURES
8,713,796
9 456 700
9,590,074
9 881 404
10,090,003
10,697,788
10,893,062
10,988,302
290,514
UNDER(OVER)BUDGET $ 777,220 $ 500,705 $ 572,395 $ 241,902 $ 65,764 $ 307,377 $ (481,791) $ 277,499 $ 29 878
V
7/22/2016
CITY OF ANDOVER
General Fund - Expenditure Budget Summary Totals - By Department
Budget Year 2017
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested"
Change (•)
GENERAL GOVERNMENT
2011
2012
2013
2014
2015
2016
2016
2017
$
%
Mayor and Council $
101,373
$ 83,622
$ 83,595
$ 84,650
$ 85,060
$ 88,780
$ 87,030
$ 89,991
Administration
135,523
140,048
147,503
169,218
172,296
192,778
191,364
200,746
1,211
7,968
1.36%
Newsletter
22,897
22,336
17,677
20,974
21,042
26,000
24,650
26,000
4.13%
0
Human Resources
31,855
12,485
17,907
18,038
15,908
35,260
32,685
35,459
0
0.00 /o
Attorney
171,062
170,930
173,244
177,427
180,313
187,640
179,000
191,360
199
3,720
0.56%
City Clerk
100,697
101,377
108,312
128,861
134,775
157,075
155,875
158,828
1.98%
Elections
6,399
39,614
11,352
41,508
14,497
57,919
83,019
64,027
7,753
112% 12%
Finance
207,032
207,337
215,215
230,639
240,319
261,016
260,516
270,474
6,108
9,458
10.55%
Assessing
143,693
143,338
144,561
145,051
146,315
150,000
150,000
150,000
3.62%
Information Services
142,964
136,025
135,982
146,984
131,744
173,483
169,233
176,439
0
0,00%
Planning & Zoning
324,303
318,523
349,489
387,308
406,045
435,606
435,606
468,094
2,956
1.70%
Engineering
413,818
427,339
452,788
460,872
464,843
509,514
509,514
540,712
32,488
7,46%
Facility Management
469,478
420,799
451,257
470,397
498,813
553,201
574,367
31,198
6° .
Total General Gov
2,271,094
2,223,773
2,308,882
2,481,927
2,511,970
2,828,272
2,792,859
_ 543,532
2,915,962
(9,369)
-1.69% 9%
87,690
3.10%
PUBLICSAFETY
Police Protection
2,615,407
2,693,896
2,740,899
2,818,132
2,918,308
2,936,467
2,936,467
2,962,551
26,084
0,89%
Fire Protection
974,988
1,015,825
1,126,979
1,264,018
1,165,223
1,284,795
1,284,795
1,415,391
130,596
Protective Inspection
342,437
354,753
423,495
390,908
391,951
441,807
441,807
452,689
10.16%
Emergency Management
16,301
14,088
13,930
21,836
24,352
22,982
22,982
10,882
2.46%
Animal Control
11,088
8,503
6,037
4,026
3,498
7,050
24,920
1,938
8.43%
Total Public Safety
3,960,221
4,087,065
4,311,340
4,498,920
4,503,332
4,694,001
5,400
4,691,451
5,950
4,861,501
(2,000)
- 25.16%
167,500
3.57%
PUBLIC WORKS
Streets and Highways
594,294
570,630
572,753
600,313
629,724
650,237
650,237
649,672
(565)
Snow and Ice Removal
434,603
420,175
630,799
637,154
442,078
563,587
563,587
562,712
(875)
-0.09%
Street Signs
175,833
170,200
162,861
187,935
204,495
204,193
204,193
216,419
12,226
-0.16%
Traffic Signals
26,569
27,457
26,241
34,901
30,170
35,000
35,000
37,000
2,000
5.99%
5.71%
Street Lighting
32,317
33,439
31,702
32,646
30,664
36,400
36,400
38,400
2,000
Street Lights - Billed
189,144
195,197
210,331
203,148
201,500
217,500
217,500
217,500
0
5.49%
Park & Recreation
889,180
912,750
946,545
1,009,373
1,151,314
1,257,247
1,257,247
1,286,138
28,891
0.00%
2.30%
Natural Resource Preservatim
-
_
Recycling
109,910
152,642
"
179,110
-
113,902
-
128,036
10,096
130,927
10,096
10,234
138
1.37%
Total Public Works
2,451,850
2,482,490
2,759,342
2,819,372
2,817,981
3,105,187
114,164
3,088,424
_ 122,436
(8,491)
°
- 6.49/0
3,140,511
35,324
1.14%
OTHER
30,631
663,372
210,510
81,185
256,720
70,328
320,328
70,328
0
Total Other
30,631
663,372
210,510
81,185
256,720
70,328
320,328
70,328
0.00%
0
0,00%
GRAND TOTAL $
8,713,796
290,514
$ 9,456,700
$ 9,590,074
$ 9,881,404
S 10,090,003
$ 10,697,788
$ 10,893,062
$ 10,988,302
2.72%
I, ,
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: June 2016 General Fund Budget Progress Report
DATE: July 26, 2016
INTRODUCTION
The City of Andover 2016 General Fund Budget contains total revenues of $10,390,411 and
total expenditures of $11,003,788 (includes $56,000 of 2015 budget carry forwards primarily for
elections and facility management and a Council approved $250,000 transfer to the Trail Fund );
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
2016 reflecting year to date actual through June 2016. The attachment provided is to
assist discussion in reviewing 2016 progress; other documents may be distributed at the
meeting.
The following represents Administration's directives and departmental expectations that are in place
again for 2016:
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
The Council is requested to receive a presentation and provide direction to staff.
a\ ly submitted,
CYrY OF ANDOVER
General Fund Budget Summary Totals
Budget Year 2016
2015
2016
REVENUES
Budget
Jun YTD
% Bud
YE
Budget
Jun YTD
% Bud
General Property Tax
$
7,706,892
$
-
0%
S
7,634,714
$
8,113,528
$ 267
0%
Licenses and Permits
316,588
222,305
70%
452,422
346,205
237,033
68%
Intergovernmental
633,015
292,920
46%
749,570
673,248
197,158
29%
Charges for Services
748,550
373,930
50%
804,228
767,950
391,636
51%
Fines
100,750
46,916
47%
99,304
100,750
43,118
43%
Investment Income
75,000
(6,671)
-90/6
63,709
75,000
(8,643)
-12%
Miscellaneous
98,850
106,293
108%
154,890
116,800
105,872
91%
Transfers In
196,930
196,930
100%
196,930
196.930
196.930
100%
Total Revenues
S
9,876,575
$
1,232,623
12%
S
10,155,767
S
10,390,411
S 1,163,371
11
2015
2016
EXPENDITURES
Budget
Jun YTD
% Bud
YE- Unaudited
Budget
Jun YTD
% Bud
GENERAL GOVERNMENT
Mayor and Council
S
87,154
$
55,709
64%
$
85,061
$
88,780
$ 55,702
63%
Administration
180,888
80,803
45%
172,296
192,778
88,366
46%
Newsletter
26,000
12,264
47%
21,042
26,000
12,303
47%
Human Resources
40,156
9,453
24%
15,909
35,260
10,676
30%
Attorney
182,000
78,417
43%
180,313
187,640
76,916
41%
City Clerk
135,359
65,299
48%
134,776
157,075
71,171
45%
Elections
57,492
10,426
18%
14,496
82,919
26,820
32%
Finance
239,981
129,645
54%
240,317
261,016
141,145
54%
Assessing
150,000
56
0%
146,315
150,000
143,883
96%
Information Services
172,239
62,234
36%
131,745
173,483
72,058
42%
Planning & Zoning
412,937
191,396
46%
406,045
435,606
199,922
46%
Engineering
470,631
220,005
47%
464,842
509,514
240,208
47%
Facility Management
579,802
210,540
36%
498,813
568,201
205,972
36%
Total General Gov
2,734,639
1,126,247
41%
2,511,970
2,868,272
1,345,142
47%
PUBLICSAFETY
Police Protection
2,918,308
1,459,154
50%
2,918,308
2,936,467
1,468,231
50%
Fire Protection
1,192,330
469,416
39%
1,165,221
1,294,795
559,064
43%
Protective Inspection
423,161
184,620
44%
391,948
441,807
195,826
44%
Civil Defense
39,189
20,400
52%
24,352
22,982
11,251
49%
Animal Control
9,950
1,583
16%
3,498
7,950
906
II%
Total Public Safety
4,582,938
2,135,173
47%
4,503;327
4,704,001
2,235,278
48%
PUBLIC WORKS
Streets and Highways
625,664
277,740
44%
629,724
656,237
354,431
54%
Snow and Ice Removal
539,770
249,189
46%
442,077
563,587
276,424
49%
Street Signs
203,533
89,511
44%
204,494
204,193
73,411
36%
Traffic Signals
35,000
11,170
32%
30,169
35,000
10,391
30%
Street Lighting
36,400
12,819
35%
30,664
36,400
14,876
41%
Street Lights - Bi0ed
216,000
80,400
37%
201,501
217,500
84,358
39%
Park & Recreation
1,185,338
484,895
41%
1,151,313
1,257,247
564,973
45%
Natural Resource Preservation
-
-
0%
-
10,096
50
0%
Recycling
135,120
44,000
41%
128,038
130,927
54,546
42%
Total Public Works
2,351,161
971,984
41%
2,817,980
3,111,187
1,433,460
46%
OTHER
Miscellaneous
31,728
15,443
49%
221,478
281,728
253,197
90%
Youth Services
38,600
16,000
41%
35,242
38,600
24,500
63%
Total Other
70,328
31,443
45%
256,720
320,328
277,697
87%
Total Expenditures
S
10,364,730
S
4,542,587
44%
S
10,089,997
$
11,003,788
S 5,291,577
48%
NET INCREASE (DECREASE)
S
(488,155)
S
(3,309,964)
5
65,770
S
(613,377)
S (4,128,206)
1
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: June 2016 City Investments Review
DATE: July 26, 2016
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 June 2016, the June 2016 Investment
Detail Report, and the June 2016 Money Market Funds Report. These attachments are
intended to assist with discussion when reviewing the June 2016 investments.
ACTION REQUESTED
Informational. The Council is requested to review and provide feedback to staff.
submitted,
Dickinson
Investment Maturities - June 2016
Investment Maturities
(in Years)
Credit
Fair
Less Than
More Than
Investment Type
Rating
Value
1
1 -5
6- 10
10
Money market funds
N/A
$ 1,384,326
$ 1,384,326
$
$
$
MN Municipal Money
Market Fund (4M)
N/A
4,996
4,996
Premier Banks Money
Market Fund
N/A
260,470
260,470
Certificates of deposit
FDIC
9,442,454
5,376,929
4,065,525
-
Local governments
A /Al /A2
1,085,929
379,606
538,808
62,769
104,746
AAI /AA2 /AA3
7,739,725
1,740,574
4,266,938
1,189,465
542,749
AAA
3,997,669
1,224,085
2,240,807
532,778
-
-
447,276
State governments
A /A1 /A2
-
-
AAl /AA2 /AA3
2,182,899
557,981
1,177,642
AAA
556,352
200,622
355730
-
-
U.S. agencies
AAA
2,605,413
631,471
1,844,402
129,540
FNMA REMIC
N/A
5,544
-
5,544
-
U.S. agencies
N/A
1,457,359
1,457,359
Total investments
$ 30,723,137
$ 11,761,060
$ 15,952,754
$ 2,232,287
$ 777,035
Deposits
2,455,239
Total cash and investments
$ 33,178,376
June 2016 Investment Detail
Description
Cusip Number
Credit
RatinglF
DIC #
Type
Purchase
Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market `
Value
Date
Acquired
Coupon
Date
Maturity /
Due Date
Luana Savings Bank
549103MY2
253
CD
248,000.00
248,000.00
248,000.00
0.750%
248,079.36
semi- annual
08/16/13
02/16/14
08/16/16
Synovus Bank GA
87164DFL9
873
CD
248,000.00
248,000.00
248,000.00
0.800%
248,136.40
semi - annual
09/10/14
03/04/15
09/06/16
Bank of America
06051VZY5
3510
CD
245,000.00
245,000.00
245,000.00
0.700%
245,078.40
maturity
06/02/16
none
06/02/17
Community First Bk
20368VAH8
7953
CD
245,000.00
245,000.00
245,000.00
0.550%
245,007.35
maturity
06/17/16
none
12/19/16
Whitney Bk New Orleans LA
966594AP8
12441
CD
247,000.00
247,000.00
247,000.00
0.850%
247,469.30
maturity
01/27/16
none
01/27/17
First Niagara Bk Nat] Assn
33583CVP1
16004
CD
245,000.00
245,000.00
245,000.00
0.550%
245,007.35
maturity
06/17/16
none
12/19/16
First State Community Bank
33708UBZ1
17323
CD
245,000.00
245,000.00
245,000.00
0.500%
245,017.15
maturity
05/27/16
06/27/16
02/27/17
1 Year CD - Premier Bank
1091003210
21714
CD
250,000.00
250,000.00
250,000.00
0.600%
250,000.00
maturity
12/16/15
none
12/16/16
Mizuho Bank USA
60688MSH8
21843
CD
245,000.00
245,000.00
245,000.00
0.700%
244,973.05
maturity
01/20/16
none
10/20/16
Amex Centurion Bank
02587DE61
27471
CD
248,000.00
248,000.00
248,000.00
0.900%
248,488.56
semi - annual
10/28/15
04/28/16
04/28/17
Lake Forest Bank & Trust
509685ES8
27589
CD
200,000.00
200,000.00
200,000.00
0.850%
200,086.00
semi - annual
08/14/13
02114/14
08/15/16
TCF National Bank
872278RE8
28330
CD
248,000.00
248,000.00
248,000.00
0.700%
248,076.88
maturity
12116/15
none
12/16/16
Santander Bank NA
80280JKY6
29950
CD
249,000.00
249,000.00
249,000.00
0.650%
249,019.92
maturity
01120/16
none
07/20/16
HomestreetBank
43785QHZ9
32489
CD
245,000.00
245,000.00
245,000.00
0.500%
245,031.85
maturity
05/27116
06/27/16
02/27/17
1 Year CD - Premier Bank Rochester
2055214401
33202
CD
245,000.00
245,000.00
245,000.00
0.600%
245,000.00
maturity
12/16/15
none
12116116
1 Year CD - Premier Bank MN
3041574901
33204
CD
245,000.00
245,000.00
245,000.00
0.600%
245,000.00
maturity
12/16/15
none
12/16/16
TCM Bank
872308CB5
34535
CD
245,000.00
245,000.00
245,000.00
0.650%
245,088.20
maturity
05/31/16
none
03/31/17
Wax Bank
92937CDJ4
34697
CD
248,000.00
248,000.00
248,000.00
0.750%
248,086.80
maturity
12/16/15
none
12/16/16
Cardinal Bank NA
14147VGB6
34733
CD
245,000.00
245,000.00
245,000.00
0.500%
245,002.45
maturity
06/29/16
none
12/29/16
CIT Bank NA
12556LAA4
58978
CD
245,000.00
245,000.00
245,000.00
0.650%
245,107.80
maturity
05/31/16
none
05/31/17
BankUnited A Savings
066519BMO
58979
CD
249,000.00
249,000.00
249,000.00
0.550%
249,024.90
maturity
02119116
none
08/19/16
Mountainone Bank
North Carolina Eastn Mun Pwr
62452AAT7
658196U24
90253
CD
245,000.00
245,000.00
245,000.00
0.600%
245,147.00
maturity
01/28/16
none
09/28/16
A3
local
323,218.40
323,218.40
310,000.00
6.217%
318,428.90
semi - annual
03/16/16
07/01/08
01/01/17
Kaufman TX _ _ ._
486206KKO
A3
local
61,128.00
61,128.00
60,000.00
4.000%
61,177.20
semi- annual
06/28/16
none
02/15/17
Prattville AL
740019LG7
AA
local
154,417.50
154,417.50
150,000.00
4.000%
150,822.00
semi - annual
10/27/15
none
09/01/16
Chaska MN
161664DU8
AA
local
76,434.00
76,434.00
75,000.00
2.000%
75,506.25
semi - annual
08/15/13
06/01/14
12/01/16
North Mankato MN Fort Auth Com
660760AG4
AA
local
107,657.00
107,657.00
100,000.00
4.000%
101,655.00
semi- annual
09/20/13
none
02/01/17
Philadelphia PA Auth Zero Coupon
71781 LBJ7
AA
local
161,700.00
161,700.00
245,000.00
242,209.45
maturity
01/12/10
none
04115117
Lake Mills WI
510192FA0
AA-
local
65,000.00
65,000.00
65,000.00
0.700%
65,022.10
semi - annual
06/22/15
none
09/01/16
Osseo MN ISD #279
688443J27
AA1
local
30,103.25
30,103.25
25,000.00
6.000%
25,790.50
semi - annual
12/22/11
none
02/01/17
Met Govt Nashville & Davidson Cc TN
592112EH5
AA2
local
542,169.00
542,169.00
535,000.00
5.000%
535,069.55
semi - annual
03/17/16
none
07/01/16
Grand Forks ND Sales Tax Raven
385492GQO
AA2
local
104,082.00
104,082.00
100,000.00
4.000%
100,586.00
semi - annual
06/23/15
09/01/12
09/01/16
Burlington Cnty NJ
12163741-12
AA2
local
86,387.20
86,387.20
85,000.00
3.750%
86,231.65
semi - annual
05/10/16
none
12/15/16
Buffalo MN ISD #877
119655PS1
AA2
local
264,250.00
264,250.00
250,000.00
4.050%
255,160.00
semi - annual
03/10/15
none
02/01/17
Waterloo IA
941647KE8
AA2
local
105,594.00
105,594.00
100,000.00
3.500%
102,521.00
semi- annual
02/24115
none
06/01/17
Charlotte NC Wtr & Swr Sys
161045GX1
AAA
local
404,208.00
404,208.00
400,000.00
4.000%
400,040.00
semi- annual
03117116
01/01109
07/01/16
Anchorage AK
033161E55
AAA
local
508,285.00
508,285.00
500,000.00
5.000%
501,955.00
semi- annual
03/21/16
none
08/01/16
Maple Grove MN
56516PNY5
AAA
local
230,520.40
230,520.40
220,000.00
2.000%
221,801.80
semi- annual
01/10113
08/01113
02/01/17
Ramsey Cnty MN
751622JG7
AAA
local
100,000.00
100,000.00
100,000.00
1.130%
100,288.00
semi- annual
08112/14
02/01/15
02/01117
Oregon State
68608URVO
AA1
state
70,194.60
70,194.60
70,000.00
0.890%
70,030.10
semi- annual
07/29/14
08101/13
08/01/16
Ohio State
677521BJ4
AA1
state
306,807.00
306,807.00
300,000.00
5.000%
302,865.00
semi - annual
03/17/16
none
09/15116
Mississippi State
605581BV8
AA2
state
25,000.00
25,000.00 1
25,000.00
1.116%
25,081.50
semi - annual
09/12/13 1
none
12101/16
5,376,928.72 CD
3,344,264.40 local
June 2016 Investment Detail
Credit: Purchase Maturity :Interest Current Market Date.
Description Cusip Number Ratlng/F Type I Carrying Cost A 1, mount Coupon Maturity/
DIC # Price Rate Value Acquire Date Due Date,
Florida St Hurricane 34074GDF8 AA3 state 160,836.80 160,836.80 160,000.00 1.298% 160,004.80 semi-annual 08/14/15 07/01/13 07/01/16
Texas State
882723BT5
AAA
state
211,414.00
211,414.00
200,000.00
4.000%
200,622.00
semi-annual
01/14/15
none
08/01/16
758,603.40 state
Fed Nat] Mtg Assn
3136G1YP8
AAA
US
130,130.00
130,130.00
130,000.00
0.800%
130,429.00
semi-annual
07/08/15
none
12/30/16
Farmer Mae
31315PZV4
AAA
US
200,584.00
200,584.00
200,000.00
1.140%
200,714.00
semi-annual
03/21/16
08/03112
02/03/17
Fed Farm Credit Bank
3133EE6A3
AAA
US
200,000.00
200,000.00
200,000.00
0.590%
200,066.00
semi-annual
12109/15
02/06/16
02/06/17
Fed Farm Credit Bank
3133EATE8
AAA
US
99,647.00
99,647.00
100,000.00
0.900%
100,262.00
semi-annual
11/04/13
12/08/12
06/08/17
631,471.00 US
10,111,267.52
Less Than 1 Year
Citizens Alliance Bank
17318LAP9
1402
CID
249,000.00
249,000.00
249,000.00
2.000%
257,729.94
monthly
06/27/14
07/27/14
06/26/20
Capital One
14042E400
4297
CID
248,000.00
248,000.00
249,000.00
248,000.00
1.150%
248,572.88
semi-annual
07/15/15
01/15/16
07/17/17
Farmers & Merchants-Svgs Bk
30856PAG1
9298
CID
249,000.00
249,000.00
1.050%
250,466.61
monthly
01/22/16
02/22/16
10/23/17
Stearns Bank NA
857894PB9
10988
CD
247,000.00
247,000.00
247,000.00
1.000%
254,163.00
semi-annual
12/26/14
06/26115
12/26/19
Bangor Savings Bank-
060243DV1
18408
CID
245,000.00
245,000.00
245,000.00
1.000%
245,083.30
semi-annual
07/30/14
01/30/15
07/30/19
Synchrony Bank
87164WBT4
27314
CID
247,000.00
247,000.00
247,000.00
2.050%
253,081.14
semi-annual
07/11/14
01/11/15
07/11/19
Valley Cent Svgs Bk Reading OH
91944RAE8
28555
CID
150,000.00
150,000.00
150,000.00
1.250%
150,775.50
monthly
12/22/14
01/22/15
12/22/17
First Federal Svgs Bk
32021YCH4
29690
CD
249,000.00
249,000.00
249,000.00
1.500%
255,404.28
monthly
01/21116
02/21/16
08/21/19
Third Federal Sav & Loan
88413QAW8
30012
CID
128,000.00
128,000.00
128,000.00
2.000%
131,645.44
semi-annual
11/24/14
07/23/14
07/21/14
01/22/16
05/24/15
01/23115
01/21/15
07/22116
11/25/19
07123/19
07/22/19
01/22/19
Goldman Sachs Bank USA
38147JU59
33124
CID
247,000.00
247,000.00
247,000.00
2.050%
252,797.09
semi-annual
PrivateBank & Trust Co
74267GU08
33306
CID
247,000.00
247,000.00
247,000.00
2.000%
253,100.90
semi- annual
BMW Bank of North America
05580ADR2
35141
CD
245,000.00
245,000.00
245,000.00
1.600%
248,025.75
semi-annual
Celtic Bank
Barclays Bank
Enerbank USA----
Ally Bank Midvale Utah
15118RJM0
06740KH66
29266NA31
02006LF32
57056
CID
247,000.00
247,000.00
247,000.00
2.050%
255,328.84
semi-annual
12/20/13
06/20114
12/20119
57203
CID
247,000.00
247,000.00
247,000.00
2.050%
253,150.30
semi-annual
07/03/14
01/02/15
07/02/19
57293
- CID
249,000.00
249,000.00
249,000.00
2.100%
257,819.58
monthly
07/18114
08/18/14
07/20/20
57803
CD
245,000.00
245,000.00
245,000.00
1.200%
245,213.15
semi-annual
06/30/16
12/30/16
07/01/19
Victory Bank
92644LAB8
58615
CID
247,000.00
247,000.00
247,000.00
2.000%
253,167.59
semi-annual
09/24/14
03124/15
09/24/19
4,065,525.29 CD
Elbow Lake MN
284281 KC5
A
local
170,045.70
170,045.70
165,000.00
2.750%
173,058.60
semi-annual
12/08/14
none
12/01/19
Oshkosh Wis Storm Wtr Util
68825RBD1
Al
local
101,003.00
101,003.00
100,000.00
3.250%
103,108.00
semi-annual
10/05/10
05/01/11
05/01/18
Oneida County NY
682454382
Al
local
68,632.80
68,632.80
60,000.00
6.250%
64,921.80
semi-annual
08/16/10
none
04/15/19
Junction City Kansas
481502F72
A2
local
101,558.00
101,558.00
100,000.00
5.500%
109,163.00
semi-annual
05128108
03/01/09
09101/18
Augusta ME
051411 ND4
A3
local
16,875.00
16,875.00
15,000.00
5.250%
15,415.35
semi-annual
03/07/12
none
10/01/17
Kaufman TX
486206KL8
A3
local
72,922.50
72,922.50
70,000.00
4.000%
73,141.60
semi-annual
06/28/16
02/15/17
02/15/18
Rice Cnty MN
762698GK8
AA
local
45,466.80
45,466.80
40,000.00
4.400%
43,537.60
semi-annual
03/07/12
none
02/01/19
Racine W1
7500216D4
AA-
local
101,792.00
101,792.00
100,000.00
2.100%
10-2,201.00
semi-annual
01124/12
06/01/12
06/01/18
Minnetrista MN
604229KE3
AA+
local
10,000.00
10,000.00
10,000.00
2.450%
10,014.00
semi-annual
10110/13
08/01/14
02/01/19
Ramsey MN
751813PB6
AA+
local
158,677.85
158,677.85
145,000.00
4.500%
145,446.60
semi-annual
02/16/12
04/01116
04/01/19
Stearns Co MN
857896MH4
AA+
local
276,875.00
276,875.00
250,000.00
4.500%
257,085.00
semi-annual
04/17/13
none
06/01/20
Minnetrista MN
604229KG8
AA+
local
161,038.40
161,038.40
160,000.00
3.100%
160,236.80
semi-annual
10110/13
08/01/14
02/01121
Greenway MN ISD #31
39678LDF6
AA+
local
27,593.50
27,593.50
25,000.00
5.000%
27,498.25
semi-annual
07/09/13
none
03115/21
McKinney TX
581646Y91
AA1
local
126,856.25
126,856.25
125,000.00
1.472%
126,165.00
semi-annual
05/20115
none
08/15/17
Dane County W1
236091M92
AA1
local
106,487.00
106,487.00
100,0.00.00
2.450%
102,333.00
semi-annual
07/16/12
none
12/01117
Minneapolis MN
60374YF93
AA1
local
220,938.00
220,938.00
200,000.00
4.000%
1,166.00
semi-annual
03/04/14
none
03/01118
Scott County IA
809486EZ2
AA1
local
114,450.33
112,617.00
100,000.00
4.400%
105,024.00
semi-annual
10/31/12
12101112
06101118
June 2016 Investment Detail
Description
t'
Cusip Number
:Credit:
Rating/F
DIC #,
�Y,e
,
Purchase
Price
Carrying
Carr
I I
Maturity
Amouni
Interest
Current Market
Value
a
Date.
Acquired...
Coupon
D ate
Maturity./
Dug.Date
King Cnty WA
49474E31_5
AA1
local
224,634.00
224,634.00
200,000.00
3.980%
213,778.00
semi-annual
03127/12
none
12/01118
Minneapolis MN
60374YS73
AA1
local
111,898.00
111,898.100
100,000.00
3.250%
105,941.00
semi-annual
06105/12
12/01/11
12/01/18
Cedar Rapids IA
150528RM1
W
local
F
217,672.00
217,672.00
200,000.00
3.000%
211,420.00
semi-annual
06/11/13
12/01/13
06/01/19
Minneapolis MN
60374YS81
W
local
278,632.50
278,632.50
250,000.00
3.500%
270,035.00
semi-annual
02/26/13
none
-
12/01/19
Hampton VA
4095582JI
AA1
local
100,836.00
100,836.00
100,000.00
2.209%
103,216.00
semi-annual
01/20/16
none
04/01/20
Middleton WI
596782RX2
AA1
local
106,979.00
106,979.00
100,000.00
3.750%
105,937.00
semi-annual
02/24/15
none
09/01/20
Des Moines IA Area Cmnty Col
250097H21
AA1
local
50,606.00
50,606.00
50,000.00
2.450%
52,793.50
semi-annual
11/10/14
12/01/14
06101/21
Prior Lake MN
742617CB7
AA2
local
230,000.00
230,000.00
230,000.00
1.000%
230,846.40
semi-annual
05/14/15
12/15/15
12/15/17
Hopkins Minn ISD #270
439881HCO
AA2
local
95,278.40
95,278.40
80,000.00
5.250%
85,388.00
semi-annual
04/30/12
08/01/09
02/01118
Orange Beach ALA -
68406PHF1
AA2
local
241,689.60
241,689.60
240,000.00
4.400%
255,064.80
semi-annual
08/06/10
02/01/11
02/01/19
Waterloo IA
941647PAI
AA2
local
50,559.50
50,559.50
50,000.00
2.000%
51,318.00
semi-annual
06/27113
12/01/13
06/01/19
Western Lake Superior MN
958522WU4
AA2
local
100,000.00
100,000.00
100,000.00
3.150%
106,019.00
semi-annual
08/16/11
10/01/19
Portsmouth VA
73723RSL8
AA2
local
286,268.00
286,268.00
295,000.00
2.400%
306,233.60
semi-annual
07/17/13
02/01/14
02/01/20
Brunswick Crity
117061VHI
AA2
local
local
108,967.10
108,967.10
110,000.00
1.740%
112,234.10
semi-annual
08/21/15
none
none
05101/20
Tucson AZ
898711033
AA3
local
264,202.50
254,202.50
250,000.00
2.139%
254,092.50
semi-annual
12/09/15
F04/01/12
none
07/01/17
Kane McHenry Cook & De Kalb Zero Cpn
484080MB9
AA3
local
157,328.00
157,328.00
200,000.00
191,322.00
maturity
07/16/12
none
12/01/18
Moorhead MN
6161412R7
AA3
local
108,820.00
108,820.00
100,000.00
3.800%
103,465.00
semi-annual
11/14111
none
02/01/20
Davenport Iowa
238388GS5
AA3
local I
local
111,948.00
111,948.00
100,000.00
4.650%
103,365.00
semi-annual
09/13/11
none
06/01/20
WhitewaterWis
966204KA6
AA3
local
109,541.00
109,541.00
100,000.00
4.850%
113,762.00
semi-annual
semi- annual
06/09/11
06/01/09
none
01/18/08
12101/20
07/18/17
Tennessee Valley Auth
880591 EA6
AAA
local
93,153.11
93,153.11
85,000.00
5.500%
89,295.05
Washington County MN
Saint Louis Park MN
Brownsville TX ISD Zero Coupon
Minnetonka MN ISD#276 __
937791KL4
791740WC3
116421E46
604195RA7
AAA
local
115,000.00
115,000.00
115,000.00
3.750%
118,309.70
semi-annual
07101/10
01/01/11
01/01/18
AAA
local
112,114.00
112 114.00
100,000.00
3.850%
104,666.00
semi-annual
12/22/11
none
02/01118
-_ AAA
local
local
229,640.00
229,640.00
250,000.00
244,435.00
maturity
06/26/13
none
08/15118
AAA
local
37,433.20
37,433.20
35,000.00
3,100%
36,414.35
semi-annual
12/22/11
none
02/01/19
Palm Beach Cnty FLA -
696497TR7
AAA
256,504.60
256,504.60
220,000.00
5.898%
23-6,959.80
semi-annual
07106/11
none
06/01/19
Tenn Val Auth Cpn Strip Zero Cpn
88059EWZ3
AAA
local
262,890.00
262,890.00
300,000.00
289,629.00
maturity
12/27/13
none
06/15119
Norwalk Conn
668844DS9
AAA
local
122,464.80
122,464.80
120,000.00
4.050%
127,651.20
semi-annual
08/04/10
08101/11
08/01/19
Greensboro NC
39546OV21
AAA
local
366,832.80
366,832.80
360,000.00
3.263%
381,776.40
semi-annual
07115/11
none
10/01/19
Woodbury MN
97913PCQ7
AAA
local
123,037.35
123,037.35
115,000.00
3.250%
120,505.05
semi-annual
12/22111
none
02/01/20
Dallas TX Indpt Sch Dist
235308QK2
AAA
local
116,900.00
116,900.00
100,000.00
4.450%
110,729.00
semi-annual
04/16/12
08/15/11
02/15/20
Tenn Valley Auth Zero Cpn
88059EHD9
AAA
local
263,970.00
263,970.00
300,000.00
285,744.00
maturity
03/11/13
none
06101/20
Tenn Val Auth Cpn Strip Zero Cpn
88059EMX9
AAA
local
88,133.00
88,133.00
100,000.00
94,692.00
maturity
03/18/13
none
07/15/20
Washington State
939758DL9
AA
state
205,804.00
205,804.00
200,000.00
4.500%
212,206.00
semi-annual
01124/12
04/01/12
10101/18
Massachusetts State
57582P2T6
AA1
state
199,744.00
199,744.00
200,000.00
2.090%
206,146.00
semi-annual
12/17/14
11/01/14
05/01/20
New Hampshire St Hsg
64469DWU 1
AA2
state
240,914.40
240,914.40
240,000.00
1.789%
242,601.60
semi-annual
12/09/15
07/01/16
01/01/18
New Hampshire St Hsg
64469DWV9
AA2
state
130,774.80
130,774.80
130,000.00
1.939%
131,843.40
semi-annual
12/09/15
07/01/16
07/01/18
Florida St Hurricane
34074GDH4
AA3
state
279,439.80
279,439.80
270,000.00
2.995%
282,303.90
semi-annual
11/10115
07/01/13
07/01/20
Minnesota St Colleges & Univ
60414FPJ3
AA3
state
100,000.00
100,000.00
100,000.00
2.000%
102,541.00
semi-annual
02126/15
10/0-1/15
10101/20
Tennessee State
880541 QM2
AAA
state
201,894.00
201,894.00
200,000.00
2.326%
203,672.00
semi-annual
10/26/11
02/01/12
08/01/17
Georgia State
373384RQ1
AAA
state
26,742.50
26,742.50
25,000.00
2.970%
26,122.50
semi-annual
02/08112
none
10/01/18
Texas State
882722J51
AAA
state
103,089.00
103,089.00
100,000.00
2.894%
104,321.00
semi-annual
08/10/11
04/01/12
10/01/18
Virginia State
928109XD4
AAA
state ,
22,126.00
22,126.00
20,000.00
4.100%
21,614.20
semi-annual
02/07/12
none
06/01/21
7,046,553.05 local
1,533,371.60 state
June 2016 Investment Detail
Description
Cusip.Number
Credit,
Rating/F
DIC #
Type
Purchase
Price:
Carrying Cost
Maturity
Amount
In I terest
Rate.
Current Market
Value
:Date. .
Acquired
Coupon
Date.
Matur I ityJ
Due Date'
Fed Farm Credit Bank
3133ECA95
AAA
US
199,800.00
199,800.00
200,000.00
0.790%
200,004.00
semi-annual
12/08/15
03/18/13
09/18/17
Fed Farm Credit Bank
3133EFJMO
AAA
US
249,750.00
249,750.00
250,000.00
0.930%
250,007.50
semi-annual
05/25/16
04/13/16
04/13/18
Fed Home Ln Mtg Corp Med Term Note
3134G3ZK9
AAA
US
200,000.00
200,000.00
200,000.00
1.200%
202,132.00
semi-annual
07130/12
01/30/13
-
07/30/18
Fed Farm Credit Bank
31331Y4S6
AAA
US
114,000.00
114,000.00
100,000.00
5.050%
108,707.00
semi-annual
09111/13
none
08/01/18
Fed Natl Mtg Assn
3136GOY70
AAA
US
199,300.00
199,300.00
200,000.00
1.080%
201,766.00
semi-annual
10/30/12
01/30/13
01/30/19
Fed Farm Credit Bank
3133EC5NO
AAA
US
99,587.00
99,587.00
100,000.00
1.250%
100,003.00
semi-annual
01/07/13
03/04113
03104119
RFCSP Strip Principal Zero Coupon
76116FAA5
AAA
US
185,568.00
185,568.00
200,000.00
193,586.00
maturity
07/22115
none
10115/19
Fed Farm Credit Bank
3133EGBKO
AAA
US
199,600.00
199,600.00
200,000.00
1.300%
200,118.00
semi-annual
05/25116
11/25/16
11/25/19
Fed Home Ln Mtg Corp Zero Cpn
31340OBV4
AAA
US
278,625.00
278,625.00
300,000.00
287,817.00
maturity
11/02/15
none
11/29/19
Fed Home Ln Bank
313OA3XL3
AAA
US
99,500.00
99,500.00
100,000.00
1.500%
100,261.00
semi-annual
07/22/15
08/10/15
02/10/20
Fed Natl Mtg Assn Remic
31393EAL3
us
204,187.50
5,52733
5,413.97
4.500%
5,544.28
monthly
07/30/03
none
08/25/18
FICO Strip Prin Zero Coupon
31771KACI
US
295,932.00
295,932.00
300,000.00
297,387.00
maturity
10/23/15
none
10/06/17
FICO Strip Pm4 Zero Coupon
31771 EAD3
US
194,572.00
194,572.00
200,000.00
198,354.00
maturity
03/16/15
none
10/06/17
FICO Strip Cpn-E Zero Coupon
31771JXM7
US
215,452.16
215,452.16
224,000.00
221,381.44
maturity
12/11/14
none
11/02/17
FICO Strip Cpn Zero Coupon
31771 EAA1,9
US
529,947.00
529,947.00
550,000.00
541,728.00
maturity
06/09/14
none
05/11/18
Fed Home Ln Mtg C
Corp
31393VMQ1
Q
us
153,656.25
3,238.66
3,161.58
4.500%
3,235.24
monthly
06/30/03
06/15/18
F ICO Str p C Z
ICO Strip Cpn13 Zero Coupon
31771 C2G 9
us
93,140.00
93,140.00
100,000.00
98,074.00
maturity
12/29/14
none
12/27/18
FICO Strip Cpn Zero Coupon
31358BAA6
us
94,480.00
94,480.00
100,000.00
97,199.00
maturity
04/17/15
none
02/01/19
15,952,754.40
Kaufman TX
Chaska MN
Mitchell SD.-Sch Dist #17-2
Minnetrista MN
486206KR5
A3
local
61,821.00
61,821.00
60,000.00
3.000%
62,769.00
semi-annual
06/28/16
02/15/17
02/15/23
1616636S3
606687EHO
604229KJ2
AA
local
115,122.70
115,122.70
110,000.00
4.000%
_117____
092.80
semi-annual
09/08/14
none
02/01/24
AA
local
116,702.00
116,702.00
100,000.00
6.000%
110,952.00
semi-annual
12/20/11
06115/19
06115/24
AA+
local
40,000.00
40,000.00
40,000.00
3.850%
40,068.40
semi-annual
10/10/13
' 0/10/1 3
08/01/14
02/01/23
Savage Minn
80465PAN4
AA+
local
198,018.00
198,018.00
200,000.00
4.800%
212,712.00
semi-annual
06/17/10
06'17" 0
02/01/11
02/01/24
Lake City Minn SID #813
508084DW7
AA+
local
103,933.00
103,933.00
100,000.00
5.000%
106,530.00
semi-annual
05/1 1 /1 1
05/11/11
none
02/01/25
Minneapolis MN
60374YG68
W
local
110,419.00
110,419.00
100,000.00
4.700%
108,956.00
semi-annual
10/31/11
none
03/01/23
Minneapolis MN
60374YG76
W
local
72,201.35
72,201.35
65,000.00
4.800%
70,771.35
semi-annual
09
12/09/14
none
03/01/24
Alexandria MIN ISD #W6
015131LQ6
AA2
local
279,760-50
279,760.50
270,000.00
3.000%
285,565.50
semi-annual
01/21/15
-none
02/01/23
Duluth MN
264438ZL9
AA2
local
29,767.20
29,767.20
30,000.00
2.625%
30,547.50
semi-annual
12/05/12
08/01/13
02101/25
Hawkins Crity TN
420218PL7
AA3
rAAA
local
111,480.00
111,480.00
100,000.00
4.800%
106,269.00
semi-annual
03113/12
none
05/01/24
New York St Mtge Agy
64988RHG0
local
100,000.00
100,000.00
100,000.00
2.375%
102,944.00
semi-annual
10/27115
04/01/16
10/01/21
Columbus OH
199492CS6
AAA
local
39,956.40
39,956.40
40,000.00
2.133%
41,598.80
semi-annual
02/20115
none
12/01121
Tennessee Valley Auth Ser E
880591CJ9
AAA
local
121,500.00
121,500.00
100,000.00
6.750%
138,235.00
semi-annual
03/19/09
none
11/01/25
Ice Deposit - National Sports Center
none
local
250,000.00
250,000.00
250,000.00
250,000.00
maturity
02/06/08
none
01101/26
Connecticut State
20772JQN5
AA3
state
214,954.00
214,954.00
200,000.00
3.517%
219,392.00
semi-annual
05127/16
02/15/14
08/15/21
Florida St Dept Environmental
3416OWUAO
AA3
state
217,800.00
217,800.00
200,000.00
6.206%
227,884.00
semi-annual
08/30/10
07/01/10
07/01/22
2,232,287.36
Itasca County Minn _
465452GP9
A
local
105,024.00
105,024.00
100,000.00
5.550%
104,746.00
semi - annual
07/12/11
none
02/01/28
Milaca Minn ISD 4912
598699NT9
AA+
local
106,941.00
106,941.00
100,000.00
5.650%
110,299.00
semi - annual
07/22/11
none 1
02101/27
Van Buren Mich Public Schools
920729HD5
AA1 I
local
102,750.00
102,750.00
100,000.00
6.430%1
112,595.00
semi-annual
07/17/09
11/01/09 1
05/01/29
3,307,304.46 US
1- 5 Years
1,785,011.35 local
447,276.00 state
3 - 10 Years
June 2016 Investment Detail
Will County IL Cmnty Zero Coupon 969078QM9 AA2 I local 1 159,000.00 159,000.00 1500,000.00 1 319,855.00 maturity 08/25/09 none 11/01/27
Fed Farm Credit Bank 31331VLC8 AAA US 106,030.45 106,030.45 100,000.00 5.250% 129,540.00 semi- annual 02/26/10 no 04/21/28
__.. 1 1 777,035.00
29,073,344.27
647,495.00 local
129,540.00 US
Years
INVESTMENT SCHEDULE - Money Market Funds
June 30, 2016
Description
Current Market
Value
YTD Interest
Wells Fargo
I lWells Fargo Government Money Market Fund
1 $1,384,326.481
$130.05
4M
I 14M
1 1,892.72
0.20
4M PLUS
1 14M Plus
1 3,103.121
2.27
Premier Bank
I Premier Bank Money Market
260,470.14
432.74
Grand Total Money Market Funds 1 $1,649,792.46 1 $565.26
Updated: 711112016