HomeMy WebLinkAboutWK - October 25, 2016ANL66W^�
1685 CROSSTOWN BOULEVARD N.W.. ANDUVLR, MINNtSUTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
City Council Workshop
Tuesday, October 25, 2016
Conference Rooms A & B
Call to Order — 6:00 p.m.
2. Comprehensive Plan Amendment Discussions —Administration
Discuss Wetland Restoration Project Access/12-23 - Engineering
4. Discuss Memorial Proposal - Engineering
5. 2017 Proposed Road Reconstruction Project Scoping Discussion17-2 & 17-11 -
Engineering
6. Discuss Street Lights on Crosstown Blvd. NW by the WDE Site - Engineering
2017 Special Revenue, Debt Service, Capital Projects, Enterprise & Internal Service Funds
Budget Discussion -Administration
8. 2016 Budget Progress Reports -Administration
9. 2016 City Investments Review -Administration
10. Other Business
11. Adjournment
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 . WWW.CLAN DOVER. MN. US
TO: Mayor and Councilmembers
CC: James Dickinson, City Administ
FROM: Stephanie L. Hanson, City Plann
SUBJECT: Discuss Comprehensive Plan Amendment — Rural Reserve - planning
DATE: October 25, 2016
INTRODUCTION
The City Council is requested to discuss and provide direction to staff on the City Council's
desire to proceed with a Comprehensive Plan Amendment (CPA) and Zoning Code text
amendment to address future development within the rural reserve area.
BACKGROUND
Jake and Jon Packer submitted a CPA request to amend the existing Comprehensive Plan to
allow the subdivision of land within the Rural Reserve District into parcels smaller than what is
currently allowed in the city Comprehensive Plan. The applicants are requesting to subdivide
and create 2 — 8 acre parcels from a 40 acre parcel owned by 5 family members. The Packer
family owns acreage in the City of Andover, located in the vicinity of Round Lake Blvd and
161St Ave NW. A map is attached showing Packer owned parcels. The land is zoned Rural
Residential and is located within the Rural Reserve Land Use District.
Review Process
City staff and the applicants' have been discussing the process and the time frame for the
proposed amendment request. City staff has also been working with the Metropolitan Council
staff regarding the proposed CPA request. The review period for the request ends November 19,
2016; at which time the City of Andover is required to either deny the proposed request or direct
staff to begin the CPA process. If staff is directed by City Council to move forward with a CPA,
staff will prepare the documents and submit it to the Metropolitan Council for review. The
Metropolitan Council has 60 days to review and act on the CPA.
DISCUSSION
Comprehensive Plan
According to the Andover Comprehensive Plan, the Rural Reserve District was designated as an
area to accommodate future urban growth beyond the planned Municipal Urban Service Area
(MUSA). Lot splits of less than one parcel per 20 acres and subdivisions of less than 1 parcel
per 40 acres is prohibited to prevent this area from rural residential development that would
preclude orderly MUSA expansion. The city has reached an agreement with the Metropolitan
Council that areas designated for residential development in the Rural Reserve will be developed
at 3 units per net acre once MUSA is available.
City staff is working with the Metropolitan Council to address the proposed Comprehensive Plan
Amendment. There are 3 options to consider:
1. Leave the existing regulations in the plan in place. No changes. This change will not
meet the applicants' request.
2. Amend the plan to allow for 1 unit per 10 acres in the rural reserve area. The
Metropolitan Council supports this change since it complies with the Council policy;
however, this change will not meet the request of the applicants. This change would
require an amendment to the plan and will not require changes to the zoning code. This
would allow staff and City Council more time to research different flexible development
options for the 2040 Comprehensive Plan Update.
3. *Amend the plan to allow densities greater than 1 unit per 10 acres. This will require the
adoption of flexible development guidelines as part of a zoning text amendment as well.
This option may or may not meet the applicants' request.
*an amendment to allow densities greater than 1 unit per 10 acres would affect all parcels
throughout the rural reserve land use area.
Flexible Development
The Metropolitan Council supports densities of 1 unit per 10 acres. However density beyond this
requires layout and provisions of such an ordinance or overlay to allow for future wastewater
service at a minimum density of 3 units per acre. Planning tools that would need to be considered
include density bonuses, cluster ordinances or provisions, use of Planned Unit Development
(PUD) to control development, requirements of build -out plans (ghost platting), and the use of
deed restrictions, easements, and covenants to protect open space for future development. This is
a project the City of Andover and the Metropolitan Council staff would need to work on together
to ensure compliancy with the Council policies.
According to the Metropolitan Council, there are 28 communities in the metropolitan area that
are designated for future wastewater service, including Andover; 22 of which have some type of
ordinances in place that allows higher density development while preserving open space for
future expansion of municipal services. The variations in these ordinances differ among
communities to reflect their original intent for adopting the ordinance. Some communities wish
to preserve expanses of undeveloped land, while others have landscapes that are restricted by
limiting features, and still others have planned to accommodate future growth.
Some examples of community ordinances are as follows:
Scott Countv
Scott County administers zoning for 8 townships that are within the long-term wastewater
services area, similar to the designated rural reserve area in Andover. The Scott County
ordinance is intended to preserve land in those areas for logical future extension of urban land
uses served by public utilities. Typical rural development is allowed at a density of 1 unit per 10
acres. However, there is a possibility for the land to be developed at a gross density of 1 unit per
5 acres and a net density of at least 1 unit per 1.5 acres. This is achieved through cluster
development, density bonuses and the preservation of open space. Lots may be served with
individual well and septic and/or community septic.
Washington County
Washington County administers zoning for 2 townships that are within the long -tern wastewater
services area. Similar to Scott County, Washington County ordinances allow for the same type of
developments with the administration of cluster development, density bonuses and the
preservation of open space. The cities of Hugo, Forest Lake and Lake Elmo have adopted similar
ordinances. Typical rural development is allowed at a density of 1 unit per 10 acres. However,
there is a possibility for the land to be developed at a gross density of 1 unit per 5.6 acres and a
net density of at least 1 unit per 1.7 acres.
ACTION REQUIRED
The City Council is requested to discuss the proposed comprehensive plan amendment request
by Jake and Jon Packer and provide staff with direction.
Attachments
Maps — Packer Parcels Location
Rural Reserve Location
ANOVE R Packer Family Parcels
Date Created: October 17. 2016
Disclaimer: The provider makes no representation or warranties with respect to the reuse of this data.
r
C I T Y O F
ND OVE
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.AN DOVE RMN.GOV
TO: Mayor and Council Members
CC: Jim Dickinson, City
FROM: David D. Berkowitz, Director of kblic Vorks/City Engineer
SUBJECT: Discuss Wetland Restoration Project Access/12-23 - Engineering
DATE: October 25, 2016
INTRODUCTION
The City Council is requested to discuss a possible access location and estimated cost for an
access on the south side of the Wetland Restoration project (Old Woodland Creek Golf Course).
DISCUSSION
The access location has been surveyed and a cost estimate prepared for review and discussion.
Refer to the location map, cost estimate and draft plan for detail information. An easement
would be required from the property to the west of the access location which is not identified in
the cost estimate.
If the City Council is interested in pursuing this access location, staff will contact the adjacent
property owners to discuss project details and pursue an easement on the west side.
BUDGETIMPACT
The project improvements would be funded by proceeds received from the easement sale and
development of the old Woodland Creek Golf Course.
ACTION REQUIRED
The City Council is requested to direct staff on how to proceed with the trail access to the
Wetland Restoration Project area.
Respectfully submitted,
(00, Z 0 I 1
David D. Berkowitz
Attachments: Location Map, Cost Estimate & Draft Trail Design
ANT,)OVER
Location Map
1 122 5+
h4. 5110
r �', `
119393 143'
r
A
_ 1 1 2 1 8
I
o s
^ ag."
1 1 372
3100
AV
00
1 o
- S 117,.
�i�2I
-
570
�" 11 I 11st''.
• '�'.
3 5'' �
-.
C A5.
.5200
"
,3167
-',5108
x14189
1.
it
'� `
3 33
111625
-.-
1 21 1
+.
�I ..
o 1 II(�a
7
3161
'
� r
3+11210
3447 3437 3427
j I 1
F:C -
Location Map
122 I -
1 122 5+
p�
^
_ 1 1 2 1 8
I
o s
^ ag."
011 367
AV
00
1 o
- S 117,.
�i�2I
-
570
(�I 12110.
122 I -
1 122 5+
p�
^
_ 1 1 2 1 8
I
1 o
- S 117,.
570
(�I 12110.
.5200
"
-',5108
x14189
3448 3436 3426
'� `
111625
r
o 1 II(�a
'
_
3447 3437 3427
j I 1
z
I 1 1'3 fi
-��
III 3 3
�
'� �
` rr
� ""�
- _S•1 12
3 L5 �
� 3 1211
�
it
—
Fir
I
Date Created: October 20, 2016
Disclaimer: The provider makes no representation or warranties with respect to the reuse of this data.
,3200
Woodland Creek Wetland Bank Southerly Access Trail
10/4/2016
ENGINEER'S ESTIMATE
ITEM
No.
DESCRIPTION
UNITS
EST.
QUAN
UNIT
PRICE
TOTAL
1
Mobilization
L.S.
1
$5,000.00
$5,000.00
2
Traffic Control
L.S.
1
$500.00
$500.00
3
Clear & Grub Tree
EA
40
$150.00
$6,000.00
4
Common Excavation E
CY
116
$20.00
$2.320.00
5
Granular Borrow L
CY
373
$22.00
$8,206.00
6
Aggregate Base Class 5 4"
T
50
$25.00
$1,250.001
7
T e SP 9.5 WearingCourse Mix (2,13) 2.5"
T
30
$180.00
$5,400.00
8
Remove & Replace Surmountable Concrete Curb & Gutter
LF
16
$40.00
$640.00
9
Concrete Pedestrian Curb Rams
SF
104
$15.00
$1,560.00
10
Truncated Domes
SF
16
$45.00
$720.00
11
Remove Existing18" Rc Storm Sewer
LF
24
$15.00
$360.00
12
Connect To ExistingStorm Sewer
EA
1
$500.00
$500.00
13
18" RCP CL 5 Storm Sewer
LF
24
$45.00
$1,080.00
14
18" RCP Apron
EA
1
$1,200.00
$1,200.00
15
15" RCP CL 5 Strom Sewer
LF
8
$40.00
$320.00
16
15"RCP Apron
EA
1
$1400.00
$1,400.00
17
Catch Basin type 409
EA
1
$3,500.00
$3,500.00
18
Rip Rap Class II
CY
8
$150.00
$1,200.00
19
Extend 4" PVC Down Spout Drains
EA
2
$300.00
$600.00
20
Retaining Wall
SF
50
$40.00
$2,000.00
21
Privacy Fence 4' Hie ht
LF
40
$34.00
$1,360.00
21
Privacy Fence 6' Hie ht
LF
128
$38.00
$4,864.00
22
Sediment Control Log
LF
360
$3.00
$1,080.00
23
Topsoil Borrow
CY
122
$35.00
$4,270.00
24
Erosion Control Blanket, Category 1 with seed & fertilizer
SY
1100
$3.50
$3,850.00
15% Contingency
$8,880.00
Indirect Costs (Permits, Consultants, Legal, etc.)
$0.00
Easement Acquisition
$0.00
Total
$68,060.00
i
0
i
/ CLEARING & GRUBBING LIMITS
o �
I / �
GARAGE
/ PROPOSED 8' WIDE
F&I 4" PVC DOWN BITMINOUS TRAIL s x m
i
/ SPOUT DRAINS o 30 o a $ = 8
LWOODS + 6 z
a EM
>> i i _ —a �� U —UGE < moa
\ ryx 0
BP: 0+00.00 L F
--
i ug
___________ ___ __retaining ___f` __ WOODS a pwB
/ y: HOUSE CONO SHED I \ \\ \\��----------- $
PROPOSED I F&I 6' HIGH REAR I ------ — ±-- ---
YARD PRIVACY FENCE
PED. RAMP F&I 4' HIGH FRONT
YARD PRIVACY FENCE
F&I 24" HIGH c�
RETAINING WALL %
PROPOSED +
rO
STORM SEWER
PROPOSED 10' WIDE
\ MOWED TRAIL �` __-----
' Y
Z (q M
W v V
W
w O
0.
K
i z Iz
/ JSV
i O�
3 W
i
PLAN
0+00 TO 4+06 SHEEP N0. 1 OF 4 SHEETS
m
z
O
N
O
m
m
U1
+ 877.7
0 877.37
00 00 00
V J W
O N O
874.8
CITY 0 F
DOVE
86&0
.
I.
1
878.94
.
.
. \
868.3
....
....
.I
....
....
....
....
867.7
!
/.
.
o! wo
./
873.2
. . .
875.98
\
.
m x
.
.
.
.
.
. 873.0
.
.�.
PVI:
0+75.00
.
875.01
. . . . . .
. . . . . . .
. . .
/
PVI
L• 875.01
.
'
N
o
Z
Z 90 .
.
V
N
872.6
0 O
.
_ _873.78
u
. v 0 .
O
.O
.F
.
FI
.
871.6
BVCS: 1+30.
v�
BVCE 872.. 2
c.� m y
871.2
971.62
EVCS:: 1+52.3
EVCE: 871.6
.
'
m+
.
c
870.6
A.
871.41
l
MS: 1+85.00
BVCE 871.36
_ v9
I
< mw
869.2
?F C).. �y
871.12
O N ro
O � m +
. O
C
EVCS: 2+15.00
1NjI �
EVCE: 870.62
869.2
/
870.19
.
..
.
.
.
868.3
I
..
. .. .
. .. .
.
889.13
.'
. .. .
. .. . .
. . ..
.'
868.0 my �s�y.
88&18 EDN Wm<
W} OtDm+
-.. N OD O.
868.0
CD Co 00 CD
W V v DD
cn o Ln O
WOODLAND CREEK WETLAND BANK
SOUTHERLY TRAIL ACCESS TRAIL
CITY PROJECT 12-23
CITY 0 F
DOVE
86&0
.
I.
1
.
.
868.3
....
....
.I
....
....
....
....
867.7
!
/.
.
o! wo
. . .
.
m x
0
+ -
867.2
N
o
CD Co 00 CD
W V v DD
cn o Ln O
WOODLAND CREEK WETLAND BANK
SOUTHERLY TRAIL ACCESS TRAIL
CITY PROJECT 12-23
CITY 0 F
DOVE
6f 2 QRyUNDQt MY DIRM SUPE(MSION MVD
MAT I MI A DULY 11LEN5E0 PROFMIOD ENGINEER
UN0°` ME DOF d � "
>�
DAND D. BERKOMR
DA E RED. ND.
DMGNED
WL
aP „„
MK
CHECKED
DDB
N0. DAIE
DESCRIPNON OF RNSIONS
STA 0+25
STA 0+10
STA 0+00
875
870
865
STA 1+25
5
0
30 20 10 0 10 20 5
STA 0+75
880 875-
875 870-
870 865-
30 20 10 0 10 20 '"
U
STA 0+50
SSo
875
870
865
87
47
87
A;1
86
5
0
30 20 10 0 10 20 5
STA 0+75
880 875-
875 870-
870 865-
30 20 10 0 10 20 '"
U
STA 0+50
SSo
875
870
865
880_: _
a� �m
nig
€a� o
875 doe
a
870
ww
N�
865 E<Q
880
87
A;1
870
86
880_: _
a� �m
nig
€a� o
875 doe
a
870
ww
N�
865 E<Q
5
Y
ZJ
m
0 F
5 Z 0) iy
JWN
W U �
�a(~j
LLI
V r a
}
Zw
g="
13
3U)
30 20 10 0 10 20
CROSS SECTIONS
0+00 TO 1+25 SHEEP NO. 3 OF 4 SHEETS
880
87
870
86
5
Y
ZJ
m
0 F
5 Z 0) iy
JWN
W U �
�a(~j
LLI
V r a
}
Zw
g="
13
3U)
30 20 10 0 10 20
CROSS SECTIONS
0+00 TO 1+25 SHEEP NO. 3 OF 4 SHEETS
STA 2+00
875
870
oic
870
86
865
20 10
870
865
STA 2+75
of
--
—
865
860
86
865
20 10
870
865
STA 2+75
0 10 20 20 10 0
STA 1 +75 STA 2+50
STA 1+50
875
870
865
of
--
—
865
860
0 10 20 20 10 0
STA 1 +75 STA 2+50
STA 1+50
875
870
865
i
0
5
20 10 0 10 20
STA 2+25
87
87
86
5 875
0 ^ 1 870
5 865
20 10 0 10 20
STA 3+00
SO
W
O
z
C
3
go�a
R €
m
€$e a o
cs
W83�
s
�.w
o�
�o
F/1
U
Y
aJ
to
o1 -
J W N
LU
�QV
Y—j'
LU
LU
v1'a
z0
g=am
pF
00
SHEET NO. XX OF XX SHEETS
of
--
87
86
i
0
5
20 10 0 10 20
STA 2+25
87
87
86
5 875
0 ^ 1 870
5 865
20 10 0 10 20
STA 3+00
SO
W
O
z
C
3
go�a
R €
m
€$e a o
cs
W83�
s
�.w
o�
�o
F/1
U
Y
aJ
to
o1 -
J W N
LU
�QV
Y—j'
LU
LU
v1'a
z0
g=am
pF
00
SHEET NO. XX OF XX SHEETS
20 10 0 10 20
STA 3+00
SO
W
O
z
C
3
go�a
R €
m
€$e a o
cs
W83�
s
�.w
o�
�o
F/1
U
Y
aJ
to
o1 -
J W N
LU
�QV
Y—j'
LU
LU
v1'a
z0
g=am
pF
00
SHEET NO. XX OF XX SHEETS
C I T Y O F
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
FROM: David D. Berkowitz, Director of Pub-Tic-Works/City Engineer
SUBJECT: Discuss Memorial Proposal - Engineering
DATE: October 25, 2016
INTRODUCTION
Discuss Memorial proposal and location for the late Mr. Tony Emmerich.
DISCUSSION
Friends of Mr. Emmerich have been discussing with staff a Memorial for him and have proposed
the location in Shawdowbrook West Park in which Mr. Emmerich was the developer. The
location proposed is at the trail intersection of the Shawdowbrook West Park trail and the trail
along Bunker Lake Boulevard. The Memorial improvements would not be installed until after
the Bunker Lake Boulevard reconstruction project is complete.
Attached is a concept plan for review. The location is important to determine at this point and a
final plan would be prepared once construction of Bunker Lake Boulevard is completed so that
improvements would limit the impacts to the existing landscape.
BUDGETIMPACT
The cost of the Memorial would be funded by friends of Mr. Emmerich. They may also be
interested in providing some maintenance a few times a year around the Memorial.
ACTION REQUIRED
The City Council is requested to approve Memorial location and a final plan would come back to
the City Council for review before the improvements would be installed.
Respectfully submitted,
David D. Berkowitz
Attachments: Memorial Concept Plan
--
I
K-
35
E
EX5� Row.
-C 0
r, D
CBs
PLANT SURD"
cope arr
C4= IMON NAPWLATIH
em
leapt
IREMMAP"
A A
R A- A T p
IV
7e0
BTRAIGIR lFAD6e
GETLLA X WO PROeY
GL
A.n FLLL aecKN
E N
GFLVI LQY 6RIl RWf gM1G
Ni
LOM.
MAN! w O.G
IOFN APQMM.4'GW'N LOW
SPA= e y
c n
PF'Allo<o6`-0PEECD
w
Por
P wo.C.
6POFITOUD 1l11R0.2P6M
POf
TAGGB®
0 IS
MAY NGNT 6.LLNA
SI
POT
RYII N' as
6A -NA TAY NGNY
POr
6TAGGHMD
E 16
AYTI L41R1 6EDUM
N
POf
PCMB N' O.C.
SELM1 Al1TUMi CHARM
POT
6TAGGEMD
OUANIRiEB !NOSH N INE PLANING SCNE LE ARE roR rIR COMRACTMS
�CR TO VE "OIANNTIEA SNWM ON THE PLAN
cQJJ
E.
—��
L
BENCH
LOC4THJN
4'X9' CONCRETE PAD
GGr1mGETE PAD
.mom mew i '4xrc uivrMOOfe. �r
CONCRETE PAD
u IJTS
L[1 SEKECi DESIRED T RBD L[ISflE4R 0ESIREO PECYCLED
POWDERCOATEDcmm PLASTK: LUABARCOLORS:
❑BOSiWItI(BROWN ❑CILRUBBRONTE ❑SArN ❑GREEN
Cl CAgNAL BLACK ❑NONTEKNRED PEIYEER [I MY Cl BLACK
❑ CAROINALCREV ❑BENGAL SILVER ❑REDWOOD ❑ WALNUT
[I COW BROWN ❑ SLACK SUPER TEKTURE SELECT DESIRED LENGTH:
❑ LAKESIDE SAND ❑ EII9HOWN)
www.wishbcnelld.wn
C
11 rnq_
I.p
I Ir I� K
PLAN wEW
SIDE IB E
SIDE EIEVAiKKVADDN
! FRONT NEW
2 PARK BENCH Wl MEMORIAL PLAGUE
LI USH90NE'RLITHERF D' (F2AL-6) M6
W
SN•6v.:
wN: eaoam ur...:_
C I T Y O F
,ND OVE.
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.AN DOVE RMN. GOV
TO: Mayor and Council Members
CC: Jim Dickinson, City Administ
FROM: David D. Berkowitz, Director
Engineer
SUBJECT: 2017 Proposed Road Reconstruction Project Scoping Discussion/17-2 & 17-
11 - Engineering
DATE: October 25, 2016
INTRODUCTION
The City Council is requested to review and discuss the project scoping for the proposed 2017
Street Reconstruction project and the proposed reconstruction of 168' Lane.
DISCUSSION
Identified on the attached location map is a breakout of the three proposed project areas. The
colors on the map identify differences in improvements.
Blue area has existing ditches that are utilized for storm water drainage which would not require
concrete curb.
Green area has existing bituminous curb or sections that do not have a drainage ditch that would
require concrete curb.
Red area represents a combination of bituminous curb (narrower street section) and concrete curb
& gutter (wider street section).
These areas will be reviewed in detail and discussed in regards to the proposed improvements
and assessing methodology.
ACTION REQUIRED
The City Council is requested to review and discuss the project scoping for the proposed 2017
Street Reconstruction project and the proposed reconstruction of 168u' Lane.
Respectfully submitted,
David D. Berkowitz
Attachments: Project Location/Parcel Breakout Mapes
AN , OV E h PROJECT LOCATION / PARCEL BREAKOUT
` 17-02A - Curb Area - 26 lots
- 17-11 - 168th Lane Recon (curb) - 23 lots, includes 16881 RLB
Date Created: October 13, 2016
Disclaimer The prancer makes no representation or warranties with respect to the reuse W this data. _J 17-02B - Ditch Area - 26 lots
C I T Y O F
,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 Administ
FROM: David D. Berkowitz, Director
Engineer
SUBJECT: Discuss Street Lights on Crosstown Blvd. NW by the WDE Site - Engineering
DATE: October 25, 2016
INTRODUCTION
The City Council is requested to discuss and direct staff on how to proceed with a request to add
street lighting on the east side of Crosstown Boulevard from Andover Boulevard to Partridge
Court.
DISCUSSION
A request has been received through the Mayor to install street lights along the trail/roadway
section described above and identified on the attached map. Staff met with Connexus to
determine the most feasible option to provide lighting. There are existing poles that lights can be
added on. See the attached summary for review and discussion.
BUDGETIMPACT
The improvement cost could be funded by the Trail Fund or the Road & Bridge Fund or a
combination of the two. Long term maintenance and electrical cost would be funded from the
General Fund.
ACTION REQUIRED
The City Council is requested to direct staff on how to proceed with the street light request.
Respectfully submitted,
David D. Berkowitz
Attachments: Crosstown Blvd NW Trail Lighting Costs Summary & Street Light Location Map
Crosstown Blvd NW Trail Lighting Costs
10/11/16
Based on staff's discussion with Connexus Energy, there are 3 existing wood poles that could
support lighting for the existing trail along the east of Crosstown Blvd NW.
Attached is a map identifying the proposed locations between Partridge Street NW and
Andover Blvd NW. There is already one street light on existing pole at the intersection of Osage
Street NW and Crosstown Blvd NW.
The cost for each new light is approximately $1300 for a total of $3900. This estimate also
includes a transformer that will need to be installed. There is also an additional cost for an
Anoka County Highway Department Permit for around $175.
Please contact me if you are need of anything else.
Todd Haas
Crosstown Blvd Possible Street Light
Locations for Trail
2345 .
14441 p'
14429
14393 §.
14'404
419 14380 X144m)v�
1435'4 / •�
4361.`.." FS
14330
14349
is "=
14:395
..1'4360 - 143751
14355 11357
14351 14320
14 33:)s
G
131.7 14310 t j1131 i «
r
0
�V .
vsr g. i
Y
;991r.
'ylop,
AW
�v 3s
or
"
g1313i a �s,yn',''`.
�\
Needs /.ah7 and jrta,ns Fory�Qr
Date Created: October 11, 2016 - Ex (r +il Lit- On pole
Disclaimer. The provider makes no representation or warranties wi resp ct to the reuse of this data.
0 — Ne.eds r as+
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO:
FROM:
SUBJECT:
DATE
Mayor and Councilmembers
Jim Dickinson, City Administrator
2017 Special Revenue, Debt Service, Capital Projects, Enterprise & Internal
Service Funds Budget Discussion
October 25, 2016
The Council has had a number of reviews of the 2017 Proposed General Fund Budget that will
be supported by the 2017 Tax Levy. The Council did adopt at the September 6th regular
Council meeting a Preliminary 2017 General Fund Levy & Budget. The Preliminary 2017
Levy & Budget proposes a total property tax levy of $11,938,555: $8,344,354 (69.89%)
operational levy, $1,610,047 (13.49%) debt service levy, and $1,984,154 (16.62%)
capital/watershed levy.
The 2017 Proposed Property Tax Levy is estimated to reduce the current City tax rate by
close to 2% but will generate additional tax revenue through growth identified in the City's
tax base, a 2.97% increase in the gross tax levy. The Council has the right to reduce or
keep constant this levy until the final certification date of December 28, 2016.
This agenda item will focus on all the other City fund budgets.
DISCUSSION
Other Funds:
The attachments to this staff report are draft budgets for all the other funds outside of the General
Fund within the Citv. The attachments are grouped by fund types' bolded below:
For the most part these budgets are self eUlanatorv, with the exception of the Community
Center, Economic Development Authority (EDA) and Entemrise Funds. The Community Center
Fund will be presented at a future workshop by the Recreational Facilities Manager, the EDA
Fund detail will be presented to the EDA at a future meeting, and the Enterprise Funds are driven
by a rate analysis that is part of the Capital Improvement Plan (CIP) Development process
I will provide a brief presentation of the attached budgets and answer any questions the
Council may have.
The Special Revenue Funds (pgs 1 — 20) are established to justify and account for revenue
sources to finance particular functions or projects. Revenues for these funds come from a variety
of sources (taxes, fees, gifts, grants or other contributions). Expenditures from these funds are
normally restricted by statute, local ordinance or grant agreement. Also the funds may be used
for either operations or capital outlay as legal restrictions mandate.
Administration will be discussing with the Council the following funds.•
1. Economic Development Authority Fund
2. Community Center
3. Charitable Gambling Fund
The Debt Service Funds (pgs 21 — 36) account for the accumulation of resources for, and the
payment of general long-term principal and interest. Repayment of the debt through principal
and interest payments to bond holders is backed by the full faith and credit of the City of
Andover.
Administration will briefly discussing with the Council how the overall debt service
spreadsheet impacts the individual Debt Service Funds and the proposed 2017 Debt
Service Levy.
The Capital Project Funds (pgs 37 — 64) are used to account for the acquisition or construction
of major capital facilities or equipment financed by a variety of funding sources, including tax
levy, debt, special assessments, grants or other governmental fund resources.
Administration be discussing the Trail & Transportation fund with the Council, all other
funds will not be discussed in detail. These funds are the primary funds that facilitate the
annual Capital Improvement Plan (CIP).
The Enterprise Funds (pgs 65 — 72) are dependent on multiple factors such as community
growth and demand for and usage of the service. The Enterprise funds are generally in line and
step with the rate analysis done for these funds as part of the CIP development and review.
Administration will discuss how these funds are impacted by rate analysis that facilitates
the Enterprise Funds' annual Capital Improvement Plan (CIP).
Internal Service Funds (pgs 73 — 78) are used to account for services that are provided to other
City Departments, or to other governments, on a cost reimbursement basis.
Administration will briefly discuss with the Council the following funds:
1. Central Equipment Fund
2. Risk Management Fund
ACTION REQUESTED
The Council is requested to review the staff report, attachments, receive a presentation, and
&Qvide direction to staff.
submitted,
CITY OF ANDOVER, MINNESOTA
2017 ANNUAL BUDGET
SPECIAL REVENUE FUNDS
DEFINITION:
Special revenue funds are established to justify revenue sources to finance particular functions or projects.
Revenue for these funds can come from a variety of sources, such as taxes, fees, gifts and grants or contributions
from other governmental entities. Expenditures from these funds are normally restricted by statute, local ordinance,
or grant agreements. The funds may be used for either operations or capital outlay as legal restrictions mandate.
City of Andover
Special Revenue Funds
2017 Budget Summary - All Special Revenue Funds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Intergovernmental
Charges for Services
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
$ 607,404 $ 669,442 $ 669,442 $ 597,779
39,927
695,681
7,533
854,396
1,597,537
1,597,537
2,204,941
527,207
82,383
210,983
414,926
1,235,499
300,000
1,535,499
40,000
37,500
671,700
7,500
805,500
1,562,200
1,562,200
2,231,642
483,086
85,570
256,035
481,597
56,000
1,362,288
378,398
1,740,686
Fund Balance, December 31 $ 669,442 $ 490,956
Change in Fund Balance $ 62,038 $ (178,486)
10% -27%
40,000
669,400
5,300
795,000
1,509,700
1,509,700
2,179,142
497,086
79,920
236,035
405,522
56,000
1,274,563
306,800
1,581,363
$ 597,779
$ (71,663)
-11%
40,000
37,500
687,200
5,800
796,500
1,567,000
1,567,000
2,164,779
518,671
89,020
240,180
469,929
66,000
1,383,800
305,000
1,688,800
$ 475,979
$ (121,800)
-20%
2
Actual
Adopted
1
Estimate
1
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Intergovernmental
Charges for Services
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
$ 607,404 $ 669,442 $ 669,442 $ 597,779
39,927
695,681
7,533
854,396
1,597,537
1,597,537
2,204,941
527,207
82,383
210,983
414,926
1,235,499
300,000
1,535,499
40,000
37,500
671,700
7,500
805,500
1,562,200
1,562,200
2,231,642
483,086
85,570
256,035
481,597
56,000
1,362,288
378,398
1,740,686
Fund Balance, December 31 $ 669,442 $ 490,956
Change in Fund Balance $ 62,038 $ (178,486)
10% -27%
40,000
669,400
5,300
795,000
1,509,700
1,509,700
2,179,142
497,086
79,920
236,035
405,522
56,000
1,274,563
306,800
1,581,363
$ 597,779
$ (71,663)
-11%
40,000
37,500
687,200
5,800
796,500
1,567,000
1,567,000
2,164,779
518,671
89,020
240,180
469,929
66,000
1,383,800
305,000
1,688,800
$ 475,979
$ (121,800)
-20%
2
City of Andover
Special Revenue Funds
Economic Development Authority Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Charges for Services
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 380,792 $ 334,451 $ 334,451 $ 238,791
20,895 20,000 10,000 10,000
3,831 5,000 2,500 3,000
930 - - -
25,656 25,000 12,500 13,000
25,656
406,448
49,457
5,064
8,230
9,246
71,997
71,997
$ 334,451
$ (46,341)
-12%
25,000
359,451
22,610
18,900
78,800
14,850
135,160
135,160
$ 224,291
$ (110,160)
-33%
12,500
346,951
22,610
13,900
58,800
12,850
108,160
108,160
13,000
251,791
14,632
18,900
79,000
13,850
126,382
126,382
$ 238,791 $ 125,409
$ (95,660)
-29%
$ (113,382)
-47%
3
Actual.
1
Adopted
Estimate
1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Charges for Services
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 380,792 $ 334,451 $ 334,451 $ 238,791
20,895 20,000 10,000 10,000
3,831 5,000 2,500 3,000
930 - - -
25,656 25,000 12,500 13,000
25,656
406,448
49,457
5,064
8,230
9,246
71,997
71,997
$ 334,451
$ (46,341)
-12%
25,000
359,451
22,610
18,900
78,800
14,850
135,160
135,160
$ 224,291
$ (110,160)
-33%
12,500
346,951
22,610
13,900
58,800
12,850
108,160
108,160
13,000
251,791
14,632
18,900
79,000
13,850
126,382
126,382
$ 238,791 $ 125,409
$ (95,660)
-29%
$ (113,382)
-47%
3
4
Fund: Economic Development Authority
ActivityType/Code: Special Revenue
Expenditure Highlights
2016 & 2017 includes funding for monument entrance signs.
EDA Budget provides for ongoing maintenance around the Andover Station
Development area.
Department Head: City Administrator
General Activity Description
To provide for the quality development of commercial and industrial
properties to ensure a strong, viable and diversified tax base.
Process Used
Promotion and expansion of the commercial and industrial tax base
through the development and redevelopment of land.
The EDA is the primary authority involved in managing the City's four
Tax Increment Financing (TIF) Districts. The EDA monitors and initiates
the activities within the TIF Districts to reach the goals of the TIF plans.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Special Revenue Funds
Community Development Block Grant Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1 $ -
Actual
Adopted
Estimate
1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1 $ -
$ - $
$
Revenues
Intergovernmental -
25,000
25,000
Other Sources
Transfers In -
-
-
Total Revenues and Other Sources: -
25,000
25,000
Total Available: -
25,000
25,000
Expenditures
Other Services and Charges -
25,000
25,000
Other Uses
Transfers Out
-
-
Total Expenditures and Other Uses:
25,000
25,000
Fund Balance, December 31 $
$ - $
$ -
Change in Fund Balance $
$ $
$ -
n/a
n/a n/a
n/a
A
D
Fund: Community Development Block Grant
Activity Type/Code: Special Revenue
Expenditure Highlights
This was a new fund created in 2004 to track the Community Development Block
Grant (CDBG) Rental Rehab program. In 2017, additional grant monies will be
applied for to study areas that have access to city water but are not currently
hooked up.
Department Head: Community Development Dir.
General Activity Description
The Rental Rehab program provides low-interest loans for the rehabilitation
of rental housing units. This fund accounts for the loans disbursed, as well
as the payments received. In 2008, a housing rehab program was started.
Due to the lack of interest, the rental rehab program was terminated in 2012.
Process Used
Rehab Grants are received from CDBG and disbursed to qualified applicants.
As payments come in, these funds create a revolving loan program and new
loans are given out to qualified applicants.
ADOPTED 2017 BUDGET
CITY OF ANDOVER. MINNESOTA
City of Andover
Special Revenue Funds
Community Center Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Actual
Adopted
1
Estimate
1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1
$ (48,364)
$ 56,140
$ 56,140
$ 112,562
Revenues
Charges for Services
637,921
618,700
626,400
632,200
Investment Income
(1,079)
-
-
-
Miscellaneous
813,009
784,000
765,000
775,000
Total Revenues:
1,449,851
1,402,700
1,391,400
1,407,200
Other Sources
Transfers In
-
-
-
-
Total Revenues and Other Sources:
1,449,851
1,402,700
1,391,400
1,407,200
Total Available:
1,401,487
1,458,840
1,447,540
1,519,762
Expenditures
Personal Services
439,304
441,231
455,231
484,119
Supplies and Materials
74,949
56,850
62,000
59,300
Purchased Services
142,602
96,000
81,500
89,000
Other Services and Charges
388,492
429,147
380,247
406,479
Capital Outlay
-
56,000
56,000
66,000
Total Expenditures:
1,045,347
1,079,228
1,034,978
1,104,898
Other Uses
Transfers Out
300,000
371,598
300,000
300,000
Total Expenditures and Other Uses: 1,345,347 1,450,826 1,334,978 1,404,898
Fund Balance, December 31 $ 56,140
Change in Fund Balance $ 104,504
-216%
$ 8,014 $ 112,562 $ 114,864
$ (48,126) $ 56,422 $ 2,302
-86% 101% 2%
7
Fund: Community Center
Activity Type/Code: Special Revenue
Expenditure Highlights
1.9
2009 was the first year the YMCA made a full lease payment of $635,000.
The transfer out is the difference between the tax levied for the Community
Center debt service and the total annual debt service for the Community Center
The capital outlay expenditure for 2016 is for replacement of the rink rubber
flooring ($36,000) in the hallways and locker rooms; and to crack seal the
parking lot ($20,000). In 2017, $60,000 is to seal coat the parking lot and
$6,000 is for painting the entrances.
Department Head: Recreation Facility Manager
General Activity Description
This fund accounts for the operations of the Andover/YMCA Community
Center, particularly the ice arena, field house and concessions. The
aquatic's portion of the Community Center is under the operations of the
YMCA.
Process Used
The Community Center construction started in 2004 and was completed
in the summer of 2005. The facility will be managed by the Recreational
Facility Manager with oversight by a Community Center Advisory Board
and the City Council. The YMCA is a long-term tenant and started making
lease payments in 2008.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Special Revenue Funds
Drainage and Mapping Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Charges for Services
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Supplies and Materials
Purchased Services
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 154,838 $ 144,771 $ 144,771 $ 136,041
317
1,768
2,085
2,085
156,923
1,870
4,636
5,646
12,152
8,000
1,200
9,200
9,200
153,971
2,300
9,500
7,000
18,800
8,000
1,200
9,200
9,200
153,971
3,000
8,000
6,930
17,930
12,152 18,800 17,930
$ 144,771
$ (10,067)
-7%
$ 135,171
$ (9,600)
-7%
$ 136,041
$ (8,730)
-6%
8,000
1,200
9,200
9,200
145,241
3,300
9,500
7,000
19,800
19,800
$ 125,441
$ (10,600)
-8%
w
Actual
1 1
Adopted
Estimate
1
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Charges for Services
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Supplies and Materials
Purchased Services
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 154,838 $ 144,771 $ 144,771 $ 136,041
317
1,768
2,085
2,085
156,923
1,870
4,636
5,646
12,152
8,000
1,200
9,200
9,200
153,971
2,300
9,500
7,000
18,800
8,000
1,200
9,200
9,200
153,971
3,000
8,000
6,930
17,930
12,152 18,800 17,930
$ 144,771
$ (10,067)
-7%
$ 135,171
$ (9,600)
-7%
$ 136,041
$ (8,730)
-6%
8,000
1,200
9,200
9,200
145,241
3,300
9,500
7,000
19,800
19,800
$ 125,441
$ (10,600)
-8%
w
Fund: Drainage and Mapping
Activity Type/Code: Special Revenue
Expenditure Highlights
10
Minimal changes are planned for this fund as monies are set aside for future
mapping needs.
Department Head: Dir of PW / City Engineer
General Activity Description
The drainage and mapping activity provides the resource to maintain
existing and develop new maps and mapping systems for the City. The
City GIS is a key component in this mapping and data inventory task.
Process Used
Existing mapping systems and data are maintained manually in a
reproducible format. The existing information is being converted to a
digital format as is all new data which is developed for the City. All data
will be accessible either manually or through a computerized application.
ADOPTED 2017 BUDGET
CITY OP ANDOVER, MINNESOTA
City of Andover
Special Revenue Funds
Lower Rum River Watershed Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Total Expenditures:
Other Uses
$ 2,295
$ 1,385 $ 1,385 $ 9,340
39,927
Actual
1 1
Adopted
Estimate
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Total Expenditures:
Other Uses
$ 2,295
$ 1,385 $ 1,385 $ 9,340
39,927
40,000
40,000
40,000
(204)
100
100
100
39,723
40,100
40,100
40,100
40,100
40,100
40,100
39,723
42,018
41,485
41,485
49,440
16,766
9,425
9,425
9,747
-
520
520
520
23,702
22,035
22,035
12,680
165
200
165
200
40,633
32,180
32,145
23,147
Transfers Out - - -
Total Expenditures and Other Uses: 40,633 32,180 32,145
Fund Balance, December 31 $ 1,385 $ 9,305 $ 9,340
Change in Fund Balance $ (910) $ 7,920 $ 7,955
-40% 572% 574%
$ 26,293
$ 16,953
182%
11
12
Fund: Lower Rum River Watershed Management Organization
Activity Type/Code: Special Revenue
Expenditure Highlights
2017 includes a reduction in annual funding to the LRRWMO.
Department Head: Assistant City Engineer
General Activity Description
The function of the Lower Rum River Watershed Management
Organization (LRRWMO) is to provide for: conservation of water and natural
resources; prevention and alleviation of flood damage; and regulation of
creeks, lakes, water courses and storm water conveyance systems for
domestic, recreational and public use across municipal boundaries.
To achieve this purpose, state law gives watershed management
organizations several powers, among which are:
1. Responsibility for preserving natural retention areas.
2. Preparation of plans for water management.
3. Review of municipal water management plans and of projects
directly affecting the water resources of the watershed.
4. Review of local land use in the absence of an approved municipal
surface water management plan.
6. Collection of data.
6. Conducting of studies and investigations.
7. Construction of improvements, either in response to petition or on
the initiative of the LRRWMO.
8. Levying of taxes and assessments for the financing of the previously
mentioned activities and for general administration of the organization.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Special Revenue Funds
Forestry Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Intergovernmental
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Supplies and Materials
Purchased Services
Total Expenditures:
Other Uses
$ 7,243
Actual
1
Adopted
Estimate
1
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Intergovernmental
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Supplies and Materials
Purchased Services
Total Expenditures:
Other Uses
$ 7,243
$ 6,831 $
6,831 $
3,431
-
12,500
-
12,500
88
100
100
100
3,431 $
6,500
6,500
88
19,100
100
19,100
88
19,100
100
19,100
7,331
25,931
6,931
2 2, 531
500 6,500 - 6,500
- 12,500 3,500 12,500
500 19,000 3,500 19,000
Transfers Out -
-
-
-
Total Expenditures and Other Uses: 500
19,000
3,500
19,000
Fund Balance, December 31 $ 6,831 $
6,931 $
3,431 $
3,531
Change in Fund Balance $ (412) $
100 $
(3,400) $
100
-6%
1 %
-50%
3%
13
Fund: Forestry
Activity Type/Code: Special Revenue
Expenditure Highlights
This fund tracks forestry -related grants with state agencies like the
Minnesota Department of Natural Resources (DNR) and administers the
bare root tree sale.
A tree sale is proposed for 2017.
Department Head: Dir of PW / City Engineer
General Activity Description
Forestry shall preserve Andover's forest resources and develop control
plans to ensure preservation and/or restoration of these resources.
Process Used
The City utilizes the Natural Resources Technician to administer the annual
bare root tree sale, coordinate various tree plantings with local organizations
like the Eagle Scouts, and monitor preservation and disease tree management
grants.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
14
City of Andover
Special Revenue Funds
Right of Way Management / Utility Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
1
Actual
Adopted
1
Estimate
1
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Charges for Services
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Purchased Services
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses
Fund Balance, December 31
Change in Fund Balance
$ 49,998
27,135
727
27,862
27,862
77,860
21,680
7,941
330
29,951
$ 47,909
20,000
500
20,500
20,500
68,409
9,820
500
11,200
400
21,920
- 6,800
29,951 28,720
$ 47,909
$ (2,089)
-4%
$ 39,689
$ (8,220)
-17%
$ 47,909
20,000
500
20,500
20,500
68,409
9,820
500
11,200
330
21,850
6,800
28,650
$ 39,759
$ (8,150)
-17%
39,759
20,000
500
20,500
20,500
60,259
10,173
500
11,200
400
22,273
5,000
27,273
$ 32,986
$ (6,773)
-17%
15
16
Fund: Right of Way Management/Utility
Activity Type/Code: Special Revenue
Expenditure Highlights
The transfer to the Road & Bridge Capital Projects is for the degredation
of roadways associated with right-of-way permits.
Department Head: Dir of PW / City Engineer
General Activity Description
The function of Right -of -Way Management is to provide for:
management of the public rights-of-way and to recover the rights-of-way
management costs; and to regulate the use of public rights-of-way
by providers of telecommunication services, public utility services
and the like, in a fair, efficient, competitively neutral and
substantial uniform manner.
Process Used
To achieve this purpose, state law gives the City several powers to
include requiring the following:
1. Require permits for work within the right-of-way.
2. Collect fees to recover costs associated with the permit including
damages to the right-of-way.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Special Revenue Funds
Charitable Gambling Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Other Uses
Transfers Out
Total Expenditures and Other Uses
Fund Balance, December 31
Change in Fund Balance
$ 57,236 $ 74,742 $ 74,742 $ 54,142
921
40,457
41,378
41,378
98,614
23,872
300
15,000
15,300
15,300
90,042
23,872 26,000
$ 74,742
$ 17,506
31%
$ 64,042
$ (10,700)
-14%
400
30,000
30,400
30,400
105,142
51,000
400
15,000
15,400
15,400
69,542
26,300
51,000 26,300
$ 54,142
$ (20,600)
-28%
$ 43,242
$ (10,900)
-20%
17
Actual
1 1
Adopted
Estimate
1 1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Other Uses
Transfers Out
Total Expenditures and Other Uses
Fund Balance, December 31
Change in Fund Balance
$ 57,236 $ 74,742 $ 74,742 $ 54,142
921
40,457
41,378
41,378
98,614
23,872
300
15,000
15,300
15,300
90,042
23,872 26,000
$ 74,742
$ 17,506
31%
$ 64,042
$ (10,700)
-14%
400
30,000
30,400
30,400
105,142
51,000
400
15,000
15,400
15,400
69,542
26,300
51,000 26,300
$ 54,142
$ (20,600)
-28%
$ 43,242
$ (10,900)
-20%
17
Fund: Charitable Gambling
Activity TypelCode: Special Revenue
Expenditure Highlights
flu
This fund was created to track the donations received from the Andover
Hockey Association and Andover Football Association from their gambling
activities. Funding is used towards the Alexandra House, Youth First,
Family of Promise, teen programing, etc.. Funding for these expenditures is
dependent upon donations.
Department Head: Finance Director
General Activity Description
The licensed organizations are required to donate 10% of their net profits to
the City.
Process Used
According to State Statute, all expenditures from this fund must be for police,
fire and other emergency or public safety-related services, equipment, and
and training, excluding pension obligations, or qualifying public service
organizations.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Special Revenue Funds
Construction Seal Coating Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Charges for Services
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Other Uses
Transfers Out
Total Expenditures and Other Uses:
$ 3,366 $ 3,213 $ 3,213 $ 3,713
9,413
Actual
Adopted
1
Estimate
Adopted
Description tion
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Charges for Services
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Other Uses
Transfers Out
Total Expenditures and Other Uses:
$ 3,366 $ 3,213 $ 3,213 $ 3,713
9,413
5,000
5,000
17,000
1,481
300
500
500
10,894
5,300
5,500
17,500
5,300
17,500
10,894
5,500
14,260
8,513
8,713
21,213
11,047
5,000
5,000
17,000
11.047
Fund Balance, December 31 $ 3,213
Change in Fund Balance $ (153)
-5%
5,000 5,000 17,000
$ 3,513 $ 3,713 $ 4,213
$ 300 $ 500 $ 500
9% 16% 13%
19
Fund: Construction Seal Coating
ActivityType/Code: Special Revenue
Expenditure Highlights
20
The Construction Seal Coating Special Revenue Fund was established in
1996 and is utilized for the first application of crack seal and seal coat in new
developments.
Department Head: Dir of PW / City Engineer
General Activity Description
The Construction Seal Coating Special Revenue Fund accounts for contributions
associated with land development to be used for the respective developments
first application of crack seal and seal coat.
Process Used
The City has an annual crack seal and seal coat program. Currently the City
is divided into nine zones and these developments are done within four years of
being constructed. Crack sealing is completed one year prior to seal coating.
This allows the crack sealing material to cure and minimize bleed through once
seal coated.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
21
CITY OF ANDOVER, MINNESOTA
2017 ANNUAL BUDGET
DEBT SERVICE FUNDS
DEFINITION:
A debt service fund accounts for the accumulation of resources for, and the payment of general long-term principal
and interest. Repayment of the debt through principal and interest payments to bond holders is backed by the full
faith and credit of the government unit.
City of Andover
Debt Service Funds
2017 Budget - All Debt Service Funds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
$ 1,073,535 $ 1,217,300 $ 1,217,300 $ 1,308,862
2,134,650
(1,287)
2,133,363
2,100,413
2,000
2,102,413
300,000 376,860
2,433,363
3,506,898
1,765,000
470,687
5,009
2,240,696
48,902
2,289,598
$ 1,217,300
2,479,273
3,696,573
1,770,000
439,698
2,450
2,212,148
104,123
2,316,271
$ 1,380,302
2,100,413
(8,000)
2,092,413
311,417
2,403,830
3,621,130
1,770,000
444,144
2,375
2,216,519
749
1,610,047
1,610,047
300,000
1,910,047
3,218,909
1,800,000
418,419
2,000
2,220,419
48,819
2,312,268 2,269,238
$ 1,308,862 $ 949,671
Change in Fund Balance $ 143,765 $ 163,002 $ 91,562 $ (359,191)
13% 13% 8% -27%
W -A
Actual
Adopted
Estimate
1
Adopted
1
Description
2015.
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
$ 1,073,535 $ 1,217,300 $ 1,217,300 $ 1,308,862
2,134,650
(1,287)
2,133,363
2,100,413
2,000
2,102,413
300,000 376,860
2,433,363
3,506,898
1,765,000
470,687
5,009
2,240,696
48,902
2,289,598
$ 1,217,300
2,479,273
3,696,573
1,770,000
439,698
2,450
2,212,148
104,123
2,316,271
$ 1,380,302
2,100,413
(8,000)
2,092,413
311,417
2,403,830
3,621,130
1,770,000
444,144
2,375
2,216,519
749
1,610,047
1,610,047
300,000
1,910,047
3,218,909
1,800,000
418,419
2,000
2,220,419
48,819
2,312,268 2,269,238
$ 1,308,862 $ 949,671
Change in Fund Balance $ 143,765 $ 163,002 $ 91,562 $ (359,191)
13% 13% 8% -27%
W -A
City of Andover
Debt Service Funds
Certificates/Capital Notes - 2012A G.O. Equipment Certificate
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 373,049 $ 506,434 $ 506,434 $ 589,669
139,881
5,738
145,619
145,619
518,668
11,700
534
12,234
142,885
2,000
144,885
144,885
651,319
50,000
11,200
500
61,700
142,885
2,000
144,885
144,885
651,319
50,000
11,200
450
61,650
589,669
535,000
5,350
500
540,850
- - - 48,819
12,234 61,700 61,650 589,669
$ 506,434
$ 133,385
36%
$ 589,619
$ 83,185
16%
$ 589,669
$ 83,235
16%
$ (589,669)
-100%
23
Actual
Adopted
Estimate
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 373,049 $ 506,434 $ 506,434 $ 589,669
139,881
5,738
145,619
145,619
518,668
11,700
534
12,234
142,885
2,000
144,885
144,885
651,319
50,000
11,200
500
61,700
142,885
2,000
144,885
144,885
651,319
50,000
11,200
450
61,650
589,669
535,000
5,350
500
540,850
- - - 48,819
12,234 61,700 61,650 589,669
$ 506,434
$ 133,385
36%
$ 589,619
$ 83,185
16%
$ 589,669
$ 83,235
16%
$ (589,669)
-100%
23
24
Fund: 3211
Cost Center: 2012A G.O. Equipment Certificates Department Head: Finance Director
Activity Type/Code: Debt Service
Debt Service is scheduled as listed below:
Year Amount Principal Interest
2017 $ 540,350 $ 535,000 $ 5,350
General Activity Description
To account for the payment of principal and interest on long-term debt.
Process Used
The City issued $585,000 of Capital Notes in 2012 to facilitate the
purchase of new equipment.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Debt Service Funds
Certificates/Capital Notes - 2014 G.O. Equipment Certificate
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
$ 263,348 $ 303,366
295,803
1,351
297,154
295,470
295,470
297,154 295,470
560,502 598,836
303,366 $ 314,986
295,470
295,470
295,260
295,260
295,470 295,260
598,836 610,246
225,000
Actual
Adopted
Estimate
1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
$ 263,348 $ 303,366
295,803
1,351
297,154
295,470
295,470
297,154 295,470
560,502 598,836
303,366 $ 314,986
295,470
295,470
295,260
295,260
295,470 295,260
598,836 610,246
225,000
260,000
260,000
31,926
23,350
23,350
210
500
500
257,136
283,850
283,850
279,300
Total Expenditures and Other Uses: 257,136
283,850
283,850
279,300
Fund Balance, December 31 $ 303,366
$ 314,986
$ 314,986
$ 330,946
Change in Fund Balance $ 40,018
$ 11,620
$ 11,620
$ 15,960
15%
4%
4%
5%
25
26
Fund: 3212
Cost Center: 2014A G.O. Equipment Certificates Department Head: Finance Director
Activity Type/Code: Debt Service
Debt Service is scheduled as listed below:
Year
Amount
Principal
Interest
2017
$ 278,800
$ 260,000
$ 18,800
2018
278,550
265,000
13,550
2019
278,200
270,000
8,200
2020
277,750
275,000
2,750
$ 1,113,300 $ 1,070,000 $ 43,300
General Activity Description
To account for the payment of principal and interest on long-term debt.
Process Used
The City issued $1,355,000 of Capital Notes in 2014 to facilitate the
purchase of equipment.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover 27
Debt Service Funds
Certificates/Capital Notes - 2016 G.O. Equipment Certificate
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1 $ $
Actual
1
Adopted
Estimate
1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1 $ $
$
$ 4,940
Revenues
General Property Taxes -
-
152,529
Investment Income -
-
-
Total Revenues: -
-
152,529
Other Sources
Operating Transfers In - -
9,386
-
Total Revenues and Other Sources: - -
9,386
152,529
Total Available: - -
9,386
157,469
Expenditures
Debt Service
Principal - -
-
-
Interest - -
4,446
9,880
Other - -
-
-
Total Expenditures: - -
4,446
9,880
Other Uses
Operating Transfers Out - -
-
-
Total Expenditures and Other Uses: - -
4,446
9,880
Fund Balance, December 31 $ - $ -
$ 4,940
$ 147,589
Change in Fund Balance $ - $
$ 4,940
$ 142,649
n/a n/a
n/a
2888%
W.
Fund: 3213
Cost Center: 2016A G.O. Equipment Certificates Department Head: Finance Director
Activity Type/Code: Debt Service
Debt Service is scheduled as listed below:
Year
Amount
Principal
Interest
2017
$ 9,880
$ -
$ 9,880
2018
134,683
126,000
8,683
2019
135,260
129,000
6,260
2020
134,791
131,000
3,791
2021
135,273
134.000
1,273
$ 549,887 $ 520,000 $ 29,887
General Activity Description
To account for the payment of principal and interest on long-term debt.
Process Used
The City issued $520,000 of Capital Notes in 2016 to facilitate the
purchase of equipment.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Debt Service Funds
General Obligation Bonds - 2012B G.O. Capital Improvement Refunding Bonds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
$ 55,568 $ 76,564 $ 76,564 $
539,660 498,435 498,435
(3,730) - (4,000)
535,930 498,435 494,435
535,930
591,498
500,000
14,400
534
514,934
514.934
Fund Balance, December 31 $ 76,564
Change in Fund Balance $ 20,996
38%
498,435
574,999
470,000
4,700
450
475,150
104,123
579.273
$ (4,274)
$ (80,838)
-106%
494,435
570.999
470,000
4,700
550
475,250
95,749
570,999
$ (76,564)
-100%
Actual
1
Adopted
Estimate
1
Adopted
Description
2015
2018
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
$ 55,568 $ 76,564 $ 76,564 $
539,660 498,435 498,435
(3,730) - (4,000)
535,930 498,435 494,435
535,930
591,498
500,000
14,400
534
514,934
514.934
Fund Balance, December 31 $ 76,564
Change in Fund Balance $ 20,996
38%
498,435
574,999
470,000
4,700
450
475,150
104,123
579.273
$ (4,274)
$ (80,838)
-106%
494,435
570.999
470,000
4,700
550
475,250
95,749
570,999
$ (76,564)
-100%
M
n/a
M
Fund: 3303
30
Cost Center: 2012B G.O. Capital Improvement Refunding Bonds Department Head: Finance Director
Activity Type/Code: Debt Service
This fund will be closed in 2016.
General Activity Description
To account for the payment of principal and interest on long-term debt.
Process Used
The City sold $3,890,000 of General Obligation Bonds in 2004 to finance
the purchase of the Public Works Facility from the Andover Economic
Development Authority and the construction of Fire Station #3. This issue
will be used to refund the original issue sold in 2004.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Debt Service Funds
General Obligation Bonds - 2012C G.O. Abatement Bonds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
$ 64,809
974,822
(5,810)
969,012
300,000
1,269,012
1,333,821
835,000
379,906
3,113
1,218,019
Fund Balance, December 31 $ 115,802
Change in Fund Balance $ 50,993
79%
$ 115,802
977,332
977,332
371,598
1,348,930
1,464,732
845,000
371,506
500
1,217,006
$ 247,726
$ 131,924
114%
$ 115,802
977,332
(6,000)
971,332
300,000
1,271,332
1,387,134
845,000
371,506
425
1,216,931
$ 170,203
$ 54,401
47%
$ 170,203
974.418
974,418
300,000
1,274,418
1,444,621
855,000
358,731
500
1,214,231
$ 230,390
$ 60,187
35%
31
Actual
Adopted
Estimate
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
Operating Transfers Out
$ 64,809
974,822
(5,810)
969,012
300,000
1,269,012
1,333,821
835,000
379,906
3,113
1,218,019
Fund Balance, December 31 $ 115,802
Change in Fund Balance $ 50,993
79%
$ 115,802
977,332
977,332
371,598
1,348,930
1,464,732
845,000
371,506
500
1,217,006
$ 247,726
$ 131,924
114%
$ 115,802
977,332
(6,000)
971,332
300,000
1,271,332
1,387,134
845,000
371,506
425
1,216,931
$ 170,203
$ 54,401
47%
$ 170,203
974.418
974,418
300,000
1,274,418
1,444,621
855,000
358,731
500
1,214,231
$ 230,390
$ 60,187
35%
31
32
Fund: 3405
Cost Center: 2012C G.O. Abatement Bonds Department Head: Finance Director
Activity Type/Code: Debt Service
Debt Service is scheduled as listed below:
Year
Amount
Principal
Interest
2017
$ 1,213,731
$ 855,000
$ 358,731
2018
1,211,482
870,000
341,482
2019
1,208,932
885,000
323,932
2020
1,215,982
910,000
305,982
2021
1,212,632
925,000
287,632
2022
1,213,932
945,000
268,932
2023
1,209,282
960,000
249,282
2024
1,213,000
985,000
228,000
2025
1,209,356
1,005,000
204,356
2026
1,208,275
1,030,000
178,275
2027
1,205,250
1,055,000
150,250
2028
1,205,147
1,085,000
120,147
2029
1,212,675
1,125,000
87,675
2030
1,213,400
1,160,000
53,400
2031
1,218,000
1,200,000
18,000
$18,171,076
$14,995,000
$ 3,176,076
General Activity Description
To account for the payment of principal and interest on long-term debt.
Process Used
The City sold $19,580,000 of Lease Revenue Bonds in 2004 to finance
the construction of a community center. Approximately 50% of the debt
will be paid for by a long-term lease arrangement with the YMCA of
Minneapolis. The YMCA will run a full service YMCA out of the Community
Center building. This issue will be used to advance refund the refunding
issues sold in 2006 and 2007 that refunded the 2004 issue.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover 33
Debt Service Funds
State Aid Bonds - 2009A G.O. State Aid Road Refunding Bonds
Statement of Revenues, Expenditures and Changes in Fund Balance
1
Actual
Adopted
1
Estimate
1
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
$
109,742
$
$ $
Revenues
Intergovernmental
-
-
Investment Income
-
-
- -
Total Revenues:
-
-
- -
Other Sources
Operating Transfers In
-
-
- -
Total Revenues and Other Sources:
-
-
- -
Total Available:
109,742
Expenditures
Debt Service
Principal
60,000
-
- -
Interest
840
Other
-
-
Total Expenditures:
60,840
-
- -
Other Uses
Operating Transfers Out
48,902
-
- -
Total Expenditures and Other Uses:
109,742
-
- -
Fund Balance, December 31
$
-
$ -
$ - $ -
Change in Fund Balance
$
(109,742)
$ -
$ - $ -
-100%
n/a
n/a n/a
34
Fund: 3702
Cost Center: 2009A G.O. State Aid Refunding Bonds Department Head: Finance Director
Activity Type/Code: Debt Service
This fund was closed in 2015.
General Activity Description
To account for the payment of principal and interest on long-term debt.
Process Used
The City sold $2,755,000 of G.O. State Aid Bonds in 2001 to finance
state aid eligible road improvement projects in the City. This issue
will be used to refund a portion of the original issue sold in 2001.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Debt Service Funds
General Obligation Bonds - 2010A G.O. Open Space Referendum Bonds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
$ 207,019
184,484
1,164
185,648
$ 215,134 $ 215,134 $ 229,064
186,291
186,291
186,291
186,291
187,840
187,840
- 5,262 2,031
185,648 191,553 188,322 187,840
392,667 406,687 403,456 416,904
145,000
Actual
Adopted
1
Estimate
1
Adopted
1
Description
201'5
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Total Revenues:
Other Sources
Operating Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Debt Service
Principal
Interest
Other
Total Expenditures:
Other Uses
$ 207,019
184,484
1,164
185,648
$ 215,134 $ 215,134 $ 229,064
186,291
186,291
186,291
186,291
187,840
187,840
- 5,262 2,031
185,648 191,553 188,322 187,840
392,667 406,687 403,456 416,904
145,000
145,000
31,915
28,942
618
500
177,533
174,442
145,000
28,942
450
174,392
150,000
25,658
500
176,158
Operating Transfers Out
-
-
-
-
Total Expenditures and Other Uses:
177,533
174,442
174,392
176,158
Fund Balance, December 31 $
215,134
$ 232,245
$ 229,064
$ 240,746
Change in Fund Balance $
8,115
$ 17,111
$ 13,930
$ 11,682
4%
8%
6%
5%
35
36
Fund: 3901
Cost Center: 2010A G.O. Open Space Referendum Bonds Department Head: Finance Director
Activity Type/Code: Debt Service
Debt Service is scheduled as listed below:
Year
Amount
Principal
Interest
2017
$ 175,658
$ 150,000
$ 25,658
2018
176,841
155,000
21,841
2019
177,507
160,000
17,507
2020
172,827
160,000
12,827
2021
172,870
165,000
7,870
2022
172,656
170,000
2,656
$ 1,048,359
$ 960,000
$ 88,359
General Activity Description
To account for the payment of principal and interest on long-term debt.
Process Used
The City sold $1,660,000 of Open Space Referendum Bonds in 2010 to
finance the purchase of land to remain as open space.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
37
CITY OF ANDOVER, MINNESOTA
2017 ANNUAL BUDGET
y.
x
?
-TROMEGY-MAR MEMO.
Capital Projects Funds can be used to account for acquisition or construction of major capital facilities financed
mainly with governmental fund resources, general obligation debt, special assessments, special assessment debt,
grants, or other resources that are not part of proprietary funds or trust funds.
City of Andover
Capital Projects Funds
2017 Budget Summary - All Capital Projects Funds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Tax Increments
Special Assessments
Intergovernmental
Investment Income
User Charges
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Bond Proceeds
Proceeds from Sale of Capital Assets
Total Other Sources:
Total Revenues and Other Sources:
Total Available:
Expenditures
$ 19,915,930
1,338,858
213,020
690,161
210,220
271,437
615,544
162,574
3,501,814
648,902
854,057
1,502,959
5,004,773
24,920,703
$ 22,165,776 $ 22,165,776
1,415, 984
1,153,000
813,743
158,400
262,421
2,000
3,805,548
510,923
580,000
1,090,923
4,896,471
27,062,247
1,415, 984
118,480
584,032
829,544
179,805
844,682
381,755
4,354,282
752,549
520,000
352,482
1,625,031
5,979,313
28,145,089
$ 21,033,420
1,944,154
118,480
687,000
1,314,902
163,000
270,183
102,000
4,599,719
453,819
453,819
5,053,538
26,086,958
Purchased Services
Actual
Adopted
Estimate
1
Adopted
1
Description
2015
2016
2016
2016
Fund Balance, January 1
Revenues
General Property Taxes
Tax Increments
Special Assessments
Intergovernmental
Investment Income
User Charges
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Bond Proceeds
Proceeds from Sale of Capital Assets
Total Other Sources:
Total Revenues and Other Sources:
Total Available:
Expenditures
$ 19,915,930
1,338,858
213,020
690,161
210,220
271,437
615,544
162,574
3,501,814
648,902
854,057
1,502,959
5,004,773
24,920,703
$ 22,165,776 $ 22,165,776
1,415, 984
1,153,000
813,743
158,400
262,421
2,000
3,805,548
510,923
580,000
1,090,923
4,896,471
27,062,247
1,415, 984
118,480
584,032
829,544
179,805
844,682
381,755
4,354,282
752,549
520,000
352,482
1,625,031
5,979,313
28,145,089
$ 21,033,420
1,944,154
118,480
687,000
1,314,902
163,000
270,183
102,000
4,599,719
453,819
453,819
5,053,538
26,086,958
Purchased Services
148,506
370,000
346,500
205,000
Other Services and Charges
1,278,383
4,193,000
5,027,867
3,772,470
Capital Outlay
1,073,070
2,085,000
1,444,070
3,124,800
Debt Service - Principal Retirement
196,719
196,719
196,719
196,719
Total Expenditures:
2,696,678
6,844,719
7,015,156
7,298,989
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
58,249 90,358
2,754,927
$ 22,165,776
Change in Fund Balance $ 2,249,846
11%
6,935,077
$ 20,127,170
$ (2,038,606)
-9%
96,513
7,111,669
$ 21,033,420
$ (1,132,356)
-5%
54,228
7,353,217
$ 18,733,741
$ (2,299,679)
-11 %
M
City of Andover
Capital Projects Funds
Water Trunk Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
1
Actual
Adopted
1
Estimate
1 1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Special Assessments
Investment Income
User Charges
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 2,637,713 $ 2,854,563 $ 2,854,563 $ 2,841,345
42,342
35,034
309,873
387,249
387,249
3,024,962
2,290
109,860
112,150
58,249
170,399
$ 2,854,563
$ 216,850
8%
30,000
50,000
67,756
147,756
147,756
3,002,319
oo
M,
85,096
125,096
$ 2,877,223
$ 22,660
1%
286,072
25,000
231,598
542,670
542,670
3,397,233
430,792
40,000
470,792
85,096
555,888
$ 2,841,345
$ (13,218)
0%
30,000
25,000
70,471
125,471
125,471
2,966,816
43,000
43,000
54,228
97,228
$ 2,869,588
$ 28,243
1%
wo
Fund: 4110 40
Cost Center: Water Trunk Department Head: City Engineer
ActivityType/Code: Capital Projects
Expenditure Highlights
Projects planned for 2017 include:
New Development Projects $ 43,000
A portion of the connection fee is used to support the Water Treatment
Plant and is transferred to the Water Enterprise Fund.
2016 included the advance payment of permit fees to various funds, in which,
the Water Trunk fund will get reimbursed through the assessment process
with interest ($327,854).
Projects for 2016 included:
Water Main Extension - Country Oaks North $ 75,495
Water Main Extension - Bunker Lake Blvd 15,272
General Activity Description
The Water Trunk Capital Projects Fund accounts for water access fees
and trunk improvements as part of development.
Process Used
The water system is continually reviewed by the Engineering and Water
Departments through studies of service, water quality, and future system
expansion or improvements.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
Sewer Trunk Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Special Assessments
Investment Income
User Charges
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 51541,793 $ 6,081,930
27,195
75,978
96,094
199,267
400,000
599,267
6,141,060
1,035
58,095
59,130
20,000
50,000
12,415
82,415
400,000
482,415
6,564,345
110,000
110,000
$ 6,081,930
20,000
50,000
147,780
217,780
400,000
617,780
6,699,710
110,000
110,000
$ 6,589,710
105,000
50,000
12,912
167,912
400,000
567,912
7,157,622
502,000
502,000
59,130 110,000 110,000 502,000
$ 6,081,930
$ 540,137
10%
$ 6,454,345
$ 372,415
6%
$ 6,589,710
$ 507,780
8%
$ 6,655,622
$ 65,912
1%
41
Actual
Adopted
Estimate
I Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Special Assessments
Investment Income
User Charges
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 51541,793 $ 6,081,930
27,195
75,978
96,094
199,267
400,000
599,267
6,141,060
1,035
58,095
59,130
20,000
50,000
12,415
82,415
400,000
482,415
6,564,345
110,000
110,000
$ 6,081,930
20,000
50,000
147,780
217,780
400,000
617,780
6,699,710
110,000
110,000
$ 6,589,710
105,000
50,000
12,912
167,912
400,000
567,912
7,157,622
502,000
502,000
59,130 110,000 110,000 502,000
$ 6,081,930
$ 540,137
10%
$ 6,454,345
$ 372,415
6%
$ 6,589,710
$ 507,780
8%
$ 6,655,622
$ 65,912
1%
41
Fund: 4120 42
Cost Center: Sewer Trunk Department Head: City Engineer
Activity Type/Code: Capital Projects
Expenditure Highlights
Projects planned for 2017 include:
New Development Projects
Lift Station #4 Upgrade
Sanitary Sewer Extensions
Replacement - JetNac Truck
Projects for 2016 included:
$ 117,000
50,000
105,000
230,000
$ 502,000
General Activity Desciption
The Sewer Trunk Capital Projects Fund accounts for access fees and
sanitary sewer improvements. City sewage flows through a pipe and lift
station system to a large sewer interceptor, which is then carried to a
metro treatment plant.
Process Used
The Sewer and Engineering Departments continually review the system
Sanitary Sewer Extension - 7th Ave $ 29,877 to determine the proper sizing of pipes and lift stations to process sewage.
Sanitary Sewer Oversizing - Winslow Woods 2nd 64,725
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
Fund: 4130 43
Cost Center: Storm Sewer Department Head: City Engineer
Activity Type/Code: Capital Projects
Expenditure Highlights
No expenditures planned for 2017.
General Activity Description
The Storm Sewer Capital Projects Fund accounts for storm sewer fees
and improvements as part of development and ongoing maintenance.
Process Used
The storm sewer system is continually reviewed by Public Works and
Engineering through studies of storm water runoff and drainage patterns.
Note: There is one part of the City where a special storm sewer trunk area
assessment is required as part of any new development. This will be used
to fund the oversizing of the storm sewer that was constructed under
Project #93-3: Xeon Street Trunk Storm Sewer.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
Storm Sewer Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1 $
Actual
1
Adopted
Estimate
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1 $
(64,418)
$ (63,357)
$ (63,357)
$ (64,157)
Revenues
Investment Income
(807)
(800)
Miscellaneous
1,868
-
Total Revenues:
1,061
(800)
Other Sources
Transfers In
-
-
Total Revenues and Other Sources:
1,061
(800)
Total Available:
(63,357)
(63,357)
(64,157)
(64,157)
Expenditures
Other Services and Charges
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31 $
(63,357)
$ (63,357)
$ (64,157)
$ (64,157)
Change in Fund Balance $
1,061
$
$ (800)
$
-2%
0%
1%
0%
44
City of Andover
Capital Projects Funds
Road and Bridge Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Special Assessments
Intergovernmental
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Proceeds from Sale of Capital Assets
Total Other Sources:
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 4,998,161
1,026,577
493,996
194,797
65,307
1,780,677
48,902
104,791
153,693
1,934,370
6,932,531
1,103,853
316,931
1,420,784
1,420,784
$ 5,511,747
$ 513,586
10%
$ 5,511,747
1,150,984
1,053,000
813,743
25,000
3,042,727
6,800
6,800
3,049,527
8,561,274
4,178,000
4,178,000
4,178,000
$ 4,383,274
$ (1,128,473)
-20%
$ 5,511,747 $ 3,925,030
1,150,984
200,000
829,544
45,000
358,955
2,584,483
6,800
2,591,283
8,103,030
4,178,000
4,178,000
4,178,000
$ 3,925,030
$ (1,586,717)
-29%
1,179,154
552,000
1,314,902
35,000
3,081,056
5,000
5,000
3,086,056
7,011,086
3,657,000
3,657,000
3,657,000
$ 3,354,086
$ (570,944)
-15%
26,
Actual
1
Adopted
1
Estimate
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Special Assessments
Intergovernmental
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Proceeds from Sale of Capital Assets
Total Other Sources:
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 4,998,161
1,026,577
493,996
194,797
65,307
1,780,677
48,902
104,791
153,693
1,934,370
6,932,531
1,103,853
316,931
1,420,784
1,420,784
$ 5,511,747
$ 513,586
10%
$ 5,511,747
1,150,984
1,053,000
813,743
25,000
3,042,727
6,800
6,800
3,049,527
8,561,274
4,178,000
4,178,000
4,178,000
$ 4,383,274
$ (1,128,473)
-20%
$ 5,511,747 $ 3,925,030
1,150,984
200,000
829,544
45,000
358,955
2,584,483
6,800
2,591,283
8,103,030
4,178,000
4,178,000
4,178,000
$ 3,925,030
$ (1,586,717)
-29%
1,179,154
552,000
1,314,902
35,000
3,081,056
5,000
5,000
3,086,056
7,011,086
3,657,000
3,657,000
3,657,000
$ 3,354,086
$ (570,944)
-15%
26,
Fund: 4140 46
Cost Center: Road and Bridge Department Head: City Engineer
Activity TypelCode: Capital Projects
Expenditure Highlights
Some of the major 2017 projects are as follows:
Annual street seal coat
Annual street crack seal
New / reconstruct routes
MSA - New / reconstruct routes
Pedestrian trail maintenance
Pedestrian trail reconstruction
Pedestrian curb ramp replacement
LED Crosswalk Warning system
Annual pavement markings
Gravel road improvements
Curb replacement
Some of the major 2016 projects are as follows:
Annual street seal coat
Annual street crack seal
New / reconstruct routes
MSA - New / reconstruct routes
Pedestrian trail maintenance
Pedestrian trail reconstruction
Annual pavement markings
Gravel road improvements
Curb replacement
$ 725,000
143,000
1,236,000
1,300,000
50,000
60,000
15,000
21,000
42,000
15,000
50,000
$ 3,657,000
$ 460,000
225,000
693,000
2,600,000
45,000
50,000
40,000
15,000
50,000
$ 4,178,000
General Activity Description
The Road and Bridge Fund accounts for road projects and the Pavement
Management Program.
Process Used
Construction projects are identified by the capital improvement process
and contained in the five-year Capital Improvement Plan (CIP). The
council approves the CIP annually, thereby initiating a process of feasibility
study, preparation of plans and specifications, public hearings, ordering of
the project, bidding the project and construction.
This fund also accounts for the pavement management program, which
includes annual seal coating, crack sealing and overlays for roads.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
Park Dedication Projects
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
User Charges
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 334,566 $ 376,632 $ 376,632 $ 376,120
61,918 15,000
Actual
1
Adopted
Estimate
Adopted
Description
2015
2016
1 2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
User Charges
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 334,566 $ 376,632 $ 376,632 $ 376,120
61,918 15,000
15,000
15,000
4,584 -
3,500
-
170,144 144,950
365,830
147,600
21,289
7,500
100,000
257,935 159,950
391,830
262,600
257,935
592,501
43,811
172,058
215,869
159,950 391,830
536,582 768,462
15,000
258,000
273,000
15,000
377,342
392,342
215,869 273,000 392,342
$ 376,632
$ 42,066
13%
$ 263,582
$ (113,050)
-30%
$ 376,120
$ (512)
0%
262,600
638,720
15,000
584,800
599,800
599,800
$ 38,920
$ (337,200)
-90%
47
Fund: 4150 48
Cost Center: Park Dedication Projects Department Head: City Engineer
Activity Type/Code: Capital Projects
Expenditure Highlights
2017 Projects include:
Annual Miscellaneous Projects
$ 15,000
Pine Hills North - Phase II
100,000
Fox Meadows Park - Renovation
457,300
Irrigation Projects - Small Parks
20,000
Nordeen's Park - Basketball Court
7,500
$ 599,800
2016 Projects include:
Annual Miscellaneous Projects
$ 15,000
Timber Trails Park Renovation
284,000
Terrace Park - Irrigation & Water Service
35,000
Mapleview Park - Playground structure
26,910
Sunshine Park - Scoreboard Wiring & Design
23,000
$ 383,910
General Activity Desciption
The Park Dedication Fund accounts for contributions associated with
land development to be used for constructing and upgrading the City's
park system.
Process Used
The Park and Recreation Commission evaluates the needs of the
community with regard to park and recreation facilities.
Recommendations are made to the City Council and projects are then
placed into the annual City Capital Improvement Plan.
ADOPTED 2017 BUDGET
CITY OP ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
Building Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Other Services and Charges
Debt Service - Principal Retirement
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 846,411 $ 779,066 $ 779,066 $ 671,110
10,843 6,000 5,000 5,000
135,003 - -
145,846 6,000 5,000 5,000
145,846
992,257
16,472
196,719
213,191
213,191
$ 779,066
$ (67,345)
-8%
104,123
110,123
889,189
196,719
196,719
196,719
$ 692,470
$ (86,596)
-11%
95,749
100,749
879,815
2,600
196,719
199,319
9,386
208,705
$ 671,110
$ (107,956)
-14%
5,000
676,110
196,719
196,719
196,719
$ 479,391
$ (191,719)
-29%
M
Actual
Adopted
1
Estimate
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources
Total Available:
Expenditures
Other Services and Charges
Debt Service - Principal Retirement
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 846,411 $ 779,066 $ 779,066 $ 671,110
10,843 6,000 5,000 5,000
135,003 - -
145,846 6,000 5,000 5,000
145,846
992,257
16,472
196,719
213,191
213,191
$ 779,066
$ (67,345)
-8%
104,123
110,123
889,189
196,719
196,719
196,719
$ 692,470
$ (86,596)
-11%
95,749
100,749
879,815
2,600
196,719
199,319
9,386
208,705
$ 671,110
$ (107,956)
-14%
5,000
676,110
196,719
196,719
196,719
$ 479,391
$ (191,719)
-29%
M
Fund: 4160 50
Cost Center: Building Fund Department Head: Finance Director
Activity Type/Code: Capital Projects
Expenditure Highlights
In 2013, the City has signed a contract for deed to purchase some land
adjacent to the city hall / public works campus. As part of that agreement,
annual payments will be made starting in 2013 with final payment in 2018.
2017 $ 196,719
2018 196,719
$ 393,438
General Activity Description
The Building Fund accounts for miscellaneous building improvement
projects for all facilities, including land acquisitions.
Process Used
Facilities are reviewed annually for non-recurring repairs or for future
facility needs.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
Trail & Transportation
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Investment Income
User Charges
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 134,963 $ 347,400 $ 347,400 $ 343,474
2,124
39,433
41,557
200,000
241,557
376,520
6,092
23,028
29,120
400
37,300
37,700
37,700
385,100
357,000
357,000
29,120 357,000
$ 347,400
$ 212,437
157%
$ 28,100
$ (319,300)
-92%
3,600
99,474
103,074
250,000
353,074
700,474
357,000
357,000
357,000
$ 343,474
$ (3,926)
-1%
3,000
39,200
42,200
42,200
385,674
565,000
565,000
565,000
$ (179,326)
$ (522,800)
-152%
51
Actual
1
Adopted
1
Estimate
1
Adopted
1
Description
2016
2016
2016
2017
Fund Balance, January 1
Revenues
Investment Income
User Charges
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 134,963 $ 347,400 $ 347,400 $ 343,474
2,124
39,433
41,557
200,000
241,557
376,520
6,092
23,028
29,120
400
37,300
37,700
37,700
385,100
357,000
357,000
29,120 357,000
$ 347,400
$ 212,437
157%
$ 28,100
$ (319,300)
-92%
3,600
99,474
103,074
250,000
353,074
700,474
357,000
357,000
357,000
$ 343,474
$ (3,926)
-1%
3,000
39,200
42,200
42,200
385,674
565,000
565,000
565,000
$ (179,326)
$ (522,800)
-152%
51
Fund: 4170
Cost Center: Trail & Transportation
Activity Type/Code: Capital Projects
Expenditure Highlights
Projects planned for 2017 include:
8' Bituminous trail along Crosstown Blvd - Bunker Lake Blvd NW to
140th Ave - $565,000
Projects planned for 2016 include:
8' Bituminous trail along Crosstown Blvd - Coon Creek bridge to
South Coon Creek Drive - $118,000
5' Concrete sidewalk along Bunker Lake Blvd - Yukon St to Hidden
Creek Park North - $52,000
5' Concrete sidewalk along Bunker Lake Blvd - Crosstown Blvd to
Yukon St -$187,000
Department Head: Dir of PW / City Engineer
General Activity Description
The Trail and Transportation Capital Projects Fund accounts for contributions
associated with land development to be used for constructing and upgrading
the City's Trail System.
Process Used
The Park and Recreation Commission evaluates the needs of the community
with regard to trail facilities. Recommendations are made to the City Council
and projects are then placed into the annual City Capital Improvement Plan.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
52
City of Andover
Capital Projects Funds
Capital Equipment Reserve
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Proceeds from Sale of Capital Assets
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 886,768 $ 1,051,687
250,363
12,872
4,414
267,649
113,150
380,799
1,267,567
142,414
73,466
215,880
215,880
$ 1,051,687
$ 164,919
19%
250,000
4,000
2,000
256,000
256,000
1,307,687
340,000
20,000
360,000
360,000
$ 947,687
$ (104,000)
-10%
$ 1,051,687
250,000
6,000
15,300
271,300
14,337
285,637
1,337,324
340,000
20,000
360,000
360,000
$ 977,324
$ (74,363)
-7%
$ 977
750,000
5,000
2,000
757,000
48,819
805,819
1,783,143
205,000
680,000
885,000
885,000
$ 898,143
$ (79,181)
-8%
53
Actual
Adopted
1
Estimate
Adopted
1
Description
2015
2016.
2016
2017
Fund Balance, January 1
Revenues
General Property Taxes
Investment Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Proceeds from Sale of Capital Assets
Total Revenues and Other Sources:
Total Available:
Expenditures
Purchased Services
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 886,768 $ 1,051,687
250,363
12,872
4,414
267,649
113,150
380,799
1,267,567
142,414
73,466
215,880
215,880
$ 1,051,687
$ 164,919
19%
250,000
4,000
2,000
256,000
256,000
1,307,687
340,000
20,000
360,000
360,000
$ 947,687
$ (104,000)
-10%
$ 1,051,687
250,000
6,000
15,300
271,300
14,337
285,637
1,337,324
340,000
20,000
360,000
360,000
$ 977,324
$ (74,363)
-7%
$ 977
750,000
5,000
2,000
757,000
48,819
805,819
1,783,143
205,000
680,000
885,000
885,000
$ 898,143
$ (79,181)
-8%
53
Fund: 4180
Cost Center: Capital Equipment Reserve
Activity Type/Code: Capital Projects
Expenditure Highlights
54
Projects outlined in the 2017 - 2021 CIP for year 2017 using the Capital
Equipment Reserve Capital Projects Fund include:
Department Head: Finance Director
General Activity Description
Resources for this fund come from residual fund transfers, interest earnings,
and property tax (capital) levy.
Using 2017 Capital Projects Reserve / levy:
Process Used
Annual Parking Lot Maintenance
$ 30,000
During 2016 and 2017 budget processes, it was determined that various capital
Replacement - Planning Vehicle #7
30,000
expenditures were necessary. The Andover Management Team and Andover
Replacement - Carpet / Tile
10,000
Vehicle Purchasing Committee reviewed departmental needs and prioritized
Replacement - Security System
100,000
capital needs.
Public Works Relocation / Expansion Plan
50,000
HD Upgrade - City Hall Council Chambers
60,000
2017 includes a Capital Equipment Purchases levy of $500,000 to purchase
Replacement - Extrication (Rescue) Equipment
80,000
equipment with levy dollars instead of issuing debt.
Emergency Operations Center Improvement
40,000
Replacement - Emergency Sirens
45,000
Replacement - One Ton Truck w/ Plow #134
80,000
New - One Ton Truck w/ Reg. Box w/ Lift & Plow
55,000
New - Bobcat Paver
20,000
Sign Design Software & Plotter
10,000
ACC / YMCA Expansion Plan
75,000
New - Trail Machine
150,000
Replacement - One Ton Crew Cab Pickup #502
50,000
$ 885,000
Using 2016 Capital Projects Reserve / levy:
Annual Parking Lot Maintenance $ 30,000
Public Works/Community Center Master Planning 25,000
Replacement - SCBA's 250,000
Add / Replace server 20,000
Replacement - 800 MHz Radios 35,000
$ 360,000
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
2014 G.O. Equipment Certificates
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1 $
Actual
1
Adopted
Estimate
Adopted
1
Description
2015
2016
2016
2017
Fund Balance, January 1 $
112,513 $
25,223 $
25,223 $
Revenues
Investment Income
681
-
-
Other Sources
Transfers In
-
Total Revenues and Other Sources:
681
-
-
Total Available:
113,194
25,223
25,223
Expenditures
Capital Outlay
87,971
-
25,223
Other Uses
Operating Transfers Out
-
-
Total Expenditures and Other Uses:
87,971
25,223
Fund Balance, December 31 $
25,223 $
25,223 $
- $
Change in Fund Balance $
(87,290) $
- $
(25,223) $
n/a
0%
-100% n/a
55
Fund:
Cost Center:
Activity Type/Code:
4212
2014 G.O. Capital Notes
Capital Projects
Expenditure Highlights
56
The following is a list of equipment purchased with a 2014 Capital Note.
Capital Note.
Vehicle / Equipment Replacements:
New - Mobile Vehicle Lifts
$ 24,000
Survey Equipment
32,000
Replacement - Ladder Truck #11
1,100,000
Replacement - Bobcat #610
36,000
Replacement - Dump Truck w/ Snow Removal Equipment
150,000
Replacement - Fire Utility #4
32,000
Replacement - Fire Utility #5
32,000
Replacement - Toro Groundmaster #559
35,000
Replacement - One Ton Truck w/ Plow #503
65,000
New - Snowblower Attachment - Belos
23,000
Replacement -Snowblower Attachment - Bobcat
7,000
New - Add Rear Wing to Plow Truck
30,000
$ 1,566,000
This fund was closed in 2016.
Department Head: Finance Director
General Activity Description
This fund accounts for major capital equipment purchases. Resources
for the capital equipment come from the issuance of equipment notes.
The notes are typically of a 5 -year duration and debt service is funded via
the annual tax levy.
Process Used
During the 2014 budget process it was determined that various capital
equipment was necessary.
ADOPTED 2017 BUDGET,
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
2016 G.O. Equipment Certificates
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1 $ -
Actual
1
Adopted
Estimate
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1 $ -
$
$ - $
Revenues
Investment Income -
-
1,005
Other Sources
Bond Proceeds -
580,000
520,000
Total Revenues and Other Sources: -
580,000
521,005
Total Available: -
580,000
521,005
Expenditures
Purchased Services -
30,000
6,500
Capital Outlay -
550,000
514,505
Total Expenditures: -
580,000
521,005
Other Uses
Operating Transfers Out -
-
-
Total Expenditures and Other Uses: -
580,000
521,005
Fund Balance, December 31 $ -
$ -
$ - $
Change in Fund Balance $
$
$ $
n/a
n/a
n/a n/a
57
Fund: 4213 58
Cost Center: 2016 G.O. Capital Notes Department Head: Finance Director
Activity Type/Code: Capital Projects
Expenditure Highlights
The following is a list of equipment purchased with a 2016 Capital Note.
Capital Note.
Vehicle / Equipment Replacements:
Replacement- Small Extended Cab Pick Up #9
Replacement - Fire Marshall Vehicle
Replacement - Breathing Air Compressor at St. #1
Replacement - Toro Groundmaster #559
Replacement -Toro Groundmaster #585
Replacement - Toro Groundmaster 4000-D #583
Replacement - Dump Truck w/ Snow Removal #196
This fund was closed in 2016.
$ 30,000
40,000
80,000
45,000
110,000
70,000
200,000
$ 575,000
General Activity Descrintion
This fund accounts for major capital equipment purchases. Resources
for the capital equipment come from the issuance of equipment notes.
The notes are typically of a 5 -year duration and debt service is funded via
the annual tax levy.
Process Used
During the 2016 budget process it was determined that various capital
equipment was necessary.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
Tax Increment Projects
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Tax Increments
Intergovernmental
Investment Income
Total Revenues:
Other Sources
Proceeds from Sale of Capital Assets
Total Revenues and Other Sources
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
$ 3,546,286 $ 4,358,069 $ 4,358,069 $ 4,448,219
213,020
15,423
56,778
285,221
636,116
921,337
4,467,623
109,554
109,554
20,000
20,000
20,000
4,378,069
750,000
750,000
109,554 750,000
Fund Balance, December 31 $ 4,358,069 $ 3,628,069
Change in Fund Balance $ 811,783 $ (730,000)
23% -17%
118,480
35,000
153,480
338,145
491,625
4,849,694
401,475
401,475
118,480
35,000
153,480
153,480
4,601,699
100,470
750,000
850,470
401,475 850,470
$ 4,448,219
$ 90,150
2%
$ 3,751,229
$ (696,990)
-16%
59
Actual
1
Adopted
1 1
Estimate
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1
Revenues
Tax Increments
Intergovernmental
Investment Income
Total Revenues:
Other Sources
Proceeds from Sale of Capital Assets
Total Revenues and Other Sources
Total Available:
Expenditures
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
$ 3,546,286 $ 4,358,069 $ 4,358,069 $ 4,448,219
213,020
15,423
56,778
285,221
636,116
921,337
4,467,623
109,554
109,554
20,000
20,000
20,000
4,378,069
750,000
750,000
109,554 750,000
Fund Balance, December 31 $ 4,358,069 $ 3,628,069
Change in Fund Balance $ 811,783 $ (730,000)
23% -17%
118,480
35,000
153,480
338,145
491,625
4,849,694
401,475
401,475
118,480
35,000
153,480
153,480
4,601,699
100,470
750,000
850,470
401,475 850,470
$ 4,448,219
$ 90,150
2%
$ 3,751,229
$ (696,990)
-16%
59
Fund: 4501 60
Cost Center: Tax Increment Projects Department Head: Finance Director
Activity Type/Code: Capital Projects
Expenditure Highlights
2017 Budgeted expenditures include:
Redevelopment Site Purchases $ 750,000
Pay -As -You -Go Note 58,623
Administration 41,847
$ 850,470
2016 expenditures include:
Pay -As -You -Go Note
$ 58,623
Soil Corrections
35,000
Administration
31,847
Decertification payback
276,005
$ 401,475
TIF District 1-1 was decertified In 2012 and TIF District 1-2 was decertified in 2014.
TIF District 1-3 and TIF District 1-4 was decertified in 2016.
General Activity Description
The Tax Increment Projects Fund accounts for activities in TIF districts
1-1, 1-2, 1-3, 1-4, 1-5 and 1-6 and all TIF land sales and expenditures to
reach the goals of the TIF district plans.
Process Used
Promotion and expansion of the commercial / industrial tax base through
redevelopment of land.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Capital Projects Funds
Permanent Improvement Revolving
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1
Revenues
Special Assessments
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 705,751
Actual
Adopted
Estimate
Adopted
1
Description 1
2015
1 2016.
2016
2017
Fund Balance, January 1
Revenues
Special Assessments
Investment Income
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Other Services and Charges
Other Uses
Operating Transfers Out
Total Expenditures and Other Uses:
Fund Balance, December 31
Change in Fund Balance
$ 705,751
$ 840,785
$ 840,785
$ 925,245
126,628
50,000
77,960
-
9,774
3,000
6;500
5,000
136,402
53,000
84,460
5,000
136,402
53,000
84,460
5,000
842,153
893,785
925,245
930,245
1,368
-
-
-
1,368
$ 840,785
$ 893,785
$ 925,245
$ 930,245
$ 135,034
$ 53,000
$ 84,460
$ 5,000
19%
6%
10%
1%
61
Fund: 4601
Cost Center: Permanent Improvement Revolving
Activity Type/Code: Capital Projects
Expenditure Highlights
No expenditures are planned for 2017.
Department Head: Finance Director
General Activity Description
The Permanent Improvement Revolving (PIR) Fund serves as a long-term
funding source for large improvement expenditures. These funds can be
used to finance infrastructure improvements for new developments if
requested instead of bonding for them.
Process Used
The City has issued four bonds totaling $15.4 million thru 2008 in the
PIR Fund for large capital projects. This fund has collected $19.12 million
of special assessments over the past 15 years. The annual cash flow of
this fund is intended to eliminate unfunded projects through effective
management of debt payments and project expenditures.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
62
City of Andover
Capital Projects Funds
2010A G.O. Open Space Referendum Bonds
Statement of Revenues, Expenditures and Changes in Fund Balance
Fund Balance, January 1 $
Actual
Adopted
1
Estimate
1
Adopted
Description
2015
2016
2016
2017
Fund Balance, January 1 $
235,423 $
2,031 $
2,031 $
Revenues
Investment Income
(1,731)
-
-
Other Sources
Transfers In
-
Total Revenues and Other Sources:
(1,731)
-
-
Total Available:
233,692
2,031
2,031
Expenditures
Capital Outlay
231,661
-
-
Other Uses
Operating Transfers Out
-
5,262
2,031
Total Expenditures and Other Uses:
231,661
5,262
2,031
Fund Balance, December 31 $
2,031 $
(3,231) $
- $
Change in Fund Balance $
(233,392) $
(5,262) $
(2,031) $
-99%
-259%
-100% n/a
63
Fund: 4901 64
Cost Center: 2010A G.O.Open Space Referendum Bonds Department Head: Finance Director
Activity Type/Code: Capital Projects
Expenditure Highlights
Over the past four years, four parcels have been purchased for the preservation
of open space in the City of Andover. The remaining funds ($2,031) were
transferred to the Open Space Referendum Bonds Debt Service Fund to assist
in the debt payments in 2016.
General Activity Description
This fund is used to finance various land acquisitions for open space
preservation within the City of Andover through the use of G.O. Open Space
Referendum Bonds.
Process Used
An Open Space Advisory Commission has been created to establish both
short and long term goals, in addition to, determining the criteria for which
to acquire open space.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
65
CITY OF ANDOVER, MINNESOTA
Governments establish enterprise funds to account for activities that consist of rendering services or providing
goods to the public for which a fee or charge is collected.
City of Andover
Enterprise Funds
2017 Budget Summary -All Enterprise Funds
Statement of Revenues, Expenditures and Changes in Fund Net Assets
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Meters
Permits
Penalties
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Debt Service
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
$ 6,225,766 $ 6,910,106 $ 6,910,106 $ 7,275,072
5,095,857
57,291
16,055
4,650
50,277
5,224,130
58,249
5,282,379
11,508,145
951,162
216,414
1,924,080
87,475
821,978
4,001,109
596,930
4,598,039
$ 6,910,106
4,982,202
56,000
13,000
3,500
16,000
67,000
5,137,702
85,096
5,222,798
12,132,904
1,000,820
289,200
2,192,448
833,101
4,315,569
596,930
4,912,499
$ 7,220,405
5,046,869
46,000
13,000
3,500
16,000
67,000
5,192,369
85,096
5,277,465
12,187,571
1,000,820
289,200
2,192,448
5,119,626
46,000
13,000
16,000
67,000
5,261,626
54,228
5,315,854
12,590,926
1,033,288
308,200
2,272,623
260,000
833,101 828,751
4,315,569 4,702,862
596,930 596,930
4,912,499 5,299,792
$ 7,275,072 $ 7,291,134
Change in Unrestricted Net Assets $ 684,340 $ 310,299 $ 364,966 $ 16,062
11% 4% 5% 0%
H.H.
Actual
Adopted
Estimate
Adopted
Description
2015
201.6
2016
2017
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Meters
Permits
Penalties
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Debt Service
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
$ 6,225,766 $ 6,910,106 $ 6,910,106 $ 7,275,072
5,095,857
57,291
16,055
4,650
50,277
5,224,130
58,249
5,282,379
11,508,145
951,162
216,414
1,924,080
87,475
821,978
4,001,109
596,930
4,598,039
$ 6,910,106
4,982,202
56,000
13,000
3,500
16,000
67,000
5,137,702
85,096
5,222,798
12,132,904
1,000,820
289,200
2,192,448
833,101
4,315,569
596,930
4,912,499
$ 7,220,405
5,046,869
46,000
13,000
3,500
16,000
67,000
5,192,369
85,096
5,277,465
12,187,571
1,000,820
289,200
2,192,448
5,119,626
46,000
13,000
16,000
67,000
5,261,626
54,228
5,315,854
12,590,926
1,033,288
308,200
2,272,623
260,000
833,101 828,751
4,315,569 4,702,862
596,930 596,930
4,912,499 5,299,792
$ 7,275,072 $ 7,291,134
Change in Unrestricted Net Assets $ 684,340 $ 310,299 $ 364,966 $ 16,062
11% 4% 5% 0%
H.H.
City of Andover
Enterprise Funds
Water
Statement of Revenues, Expenditures and Changes in Fund Net Assets
1
Actual
Adopted
1
Estimate
1
Adopted
Description
2015
2016
2016
2017
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Meters
Permits
Penalties
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Debt Service
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
$ 2,561,528 $ 3,040,230 $ 3,040,230 $ 3,314,427
2,524,089
25,353
16,055
4,650
48,509
2,618,656
58,249
2,676,905
5,238,433
421,575
179,464
622,073
2,863
821,978
2,047,953
150,250
2,198,203
2,415,186
15,000
13,000
3,500
6,000
67,000
2,519,686
85,096
2,604,782
5,645,012
446,234
229,700
703,800
833,101
2,212,835
150,250
2,363,085
Unrestricted Net Assets, December 31 $ 3,040,230 $ 3,281,927
Change in Unrestricted Net Assets $ 478,702 $ 241,697
19% 8%
2,447,686
15,000
13,000
3,500
6,000
67,000
2,552,186
85,096
2,637,282
5,677,512
446,234
229,700
703,800
833,101
2,212,835
150,250
2,363,085
$ 3,314,427
$ 274,197
9%
2,433,052
15,000
13,000
6,000
67,000
2,534,052
54,228
2,588,280
5,902,707
460,299
238,200
747,115
15,000
828,751
2,289,365
150,250
2,439,615
$ 3,463,092
$ 148,665
4%
67
Fund: 5100 68
Cost Center: Water Department Head: Utility Supervisor
Activity Type/Code: Enterprise Fund
Expenditure Highlights
No major changes planned in 2017.
General Activity Description
Operate and maintain the City's water system including WTP, wells, towers
and water mains. Provide a continuous, potable, bacteria free water supply
at proper pressure levels. Maintain customer water meters and respond to
other service requests. Maintain water distribution for fire protection system
needs. Conform to all State and Federal monitoring rules, provide tours and
information to the public.
Process Used
Operate wells and WTP in a manner that ensures a safe, clean and adequate
water supply, that will meet peak daily demands and fire protection demands.
Maintain wells, treatment facility, and related infrastructure. Operate and
maintain chemical feed equipment. Collect, analyze and record water samples
daily. Maintain, test and repair water meters. Respond to emergencies 24 hours
a day. Work with contractors to locate watermains, locate and operate gate valves,
monitor tests during final inspections. Check WTP, 6 wells, 7 days a week, 365
days per year. Flush all watermains in the spring every other year. Maintain all
hydrants. Locate operate and clean gate valves to ensure proper operation.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Enterprise Funds
Sanitary Sewer
Statement of Revenues, Expenditures and Changes in Fund Net Assets
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Penalties
Miscellaneous
Total Revenues:
Other Sources
Gain on the Sale of Capital Assets
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
$ 3,495,412 $ 3,618,050 $ 3,618,050 $ 3,668,547
2,129,201
Actual
Adopted
1
Estimate
1
Adopted
Description
2015
2016
2016
2017
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Penalties
Miscellaneous
Total Revenues:
Other Sources
Gain on the Sale of Capital Assets
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
$ 3,495,412 $ 3,618,050 $ 3,618,050 $ 3,668,547
2,129,201
2,142,281
2,142,281
2,215,411
30,934
40,000
30,000
30,000
-
10,000
10,000
10,000
2,160,135
2,192,281
2,182,281
2,255,411
2,160,135
2,192,281
2,182,281
2,255,411
5,655,547
5,810,331
5,800,331
5,923,958
316,472
337,491
337,491
349,622
19,756
31,300
31,300
36,800
1,172,840
1,316,313
1,316,313
1,348,612
81,749
-
-
245,000
1,590,817
1,685,104
1,685,104
1,980,034
446,680
446,680
446,680
446,680
2,037,497
2,131,784
2,131,784
2,426,714
$ 3,618,050
$ 3,678,547
$ 3,668,547
$ 3,497,244
Change in Unrestricted Net Assets $ 122,638 $ 60,497 $ 50,497 $ (171,303)
4% 2% 1 % -5%
Fund: 5200
Cost Center: Sanitary Sewer
Activity Type/Code: Enterprise Fund
Expenditure Hiehliehts
70
In 2017, the Metropolitan Waste Water Charge to Metropolitan Council
increased 3% ($33,761).
2015 included the purchase of new televising equipment. 2017 includes the
purchase of a new vac truck split with the Sanitary Sewer Trunk Capital
Projects Fund.
Department Head: Utility Supervisor
General Activity Desciption
City sewage is collected through a pipe and lift station network to large
Metro City Sewer interceptor pipes that carry it to the Metro Treatment Plant
for processing. The sewer division inspects, cleans, and maintains the City's
collection system which includes breaks in pipes, manholes, and lift stations.
Sewer backups caused by blockage due to debris or breaks in pipe are
cleaned and/or repaired immediately. This department maintains the integrity
of the entire sanitary sewer system.
Process Used
Inspect all lift stations five days per week. Clean one-quarter of the City's
sewer collection system via jetting and vacuuming each year. City has implemented
a televising program of the collection system that analyzes the entire system over a
five year period. A spot check program checks flows in problem areas. Start 1/1
program to monitor inflow and infiltration into sewer system. Clean known problem
area once per month. Monitor inspection and testing of all new sewer lines and
manholes before accepting from contractor. Respond to and record all requests
from customers, respond to emergencies 24 hours a day. Contract out all major
system repairs.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Enterprise Funds
Storm Sewer
Statement of Revenues, Expenditures and Changes in Fund Net Assets
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
Change in Unrestricted Net Assets
$ 168,826 $ 251,826 $ 251,826 $ 292,098
442,567 424,735 456,902 471,163
1,004 1,000 1,000 1,000
1,768 -
445,339 425,735 457,902 472,163
445,339
614,165
213,115
17,194
129,167
2,863
362,339
425,735
677,561
217,095
28,200
172,335
417,630
362,339 417,630
$ 251,826
$ 83,000
49%
$ 259,931
$ 8,105
3%
457,902
709,728
217,095
28,200
172,335
417,630
417,630
$ 292,098
$ 40,272
16%
472,163
764,261
223,367
33,200
176,896
433,463
433,463
$ 330,798
$ 38,700
13%
71
Actual
1
Adopted
Estimate
1 1
Adopted
Description
2015
2016
2016
2017
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures
Personal Services
Supplies and Materials
Other Services and Charges
Capital Outlay
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
Change in Unrestricted Net Assets
$ 168,826 $ 251,826 $ 251,826 $ 292,098
442,567 424,735 456,902 471,163
1,004 1,000 1,000 1,000
1,768 -
445,339 425,735 457,902 472,163
445,339
614,165
213,115
17,194
129,167
2,863
362,339
425,735
677,561
217,095
28,200
172,335
417,630
362,339 417,630
$ 251,826
$ 83,000
49%
$ 259,931
$ 8,105
3%
457,902
709,728
217,095
28,200
172,335
417,630
417,630
$ 292,098
$ 40,272
16%
472,163
764,261
223,367
33,200
176,896
433,463
433,463
$ 330,798
$ 38,700
13%
71
Fund: 5300 72
Cost Center: Storm Sewer Department Head: Utility Supervisor
Activity Type/Code: Enterprise Fund
Expenditure Highlights
No major changes planned in 2017.
General Activity Description
Maintenance of all storm sewers, catch basins, manholes, pipes, ditches,
and sediment ponds.
Process Used
The ditches are cleaned with a backhoe for better drainage and to avoid the
ponding of stagnant water. This dirt is hauled away or dumped in low places
on ditch banks. When it is dumped on site, it becomes necessary to level and
grade the banks to facilitate proper mowing. All catch basins and pipes are
cleaned with a vac truck. The material is then hauled away for proper
disposal. Occasional use of outside contractors to maintain parts of the system.
Televising a portion of the system each year to help comply with new federal
regulations.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
73
CITY OF ANDOVER, MINNESOTA
2017 ANNUAL BUDGET
INTERNAL SERVICE FUNDS
DEFINITION:
Internal Service Funds are used to account for goods and services that are provided to other City departments, or to
other governments, on a cost reimbursement basis.
City of Andover
Internal Service Funds
2017 Budget Summary - All Internal Service Funds
Statement of Revenues, Expenditures and Changes in Unrestricted Net Assets
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures and Other Uses
Personal Services
Supplies and Materials
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
$ 613,684 $ 744,804 $ 744,804 $ 690,401
1,112, 578
7,493
97,856
1,217,927
1,217,927
1,831,611
421,664
297,248
367,895
1,086,807
Total Expenditures and Other Uses: 1,086,807
Unrestricted Net Assets, December 31 $ 744,804
1,111,844
1,500
1,113, 344
1,113,344
1,858,148
419,835
388,010
360,122
1,167,967
1,167,967
$ 690,181
1,119,764
3,800
1,123,564
1,123,564
1,868,368
419,835
388,010
370,122
1,177,967
1,177,967
$ 690,401
1,158,507
3,000
1,161,507
1,161,507
1,851,908
443,362
404,160
360,672
1,208,194
1,208,194
$ 643,714
Change in Unrestricted Net Assets $ 131,120 $ (54,623) $ (54,403) $ (46,687)
21% -7% -7% -7%
M!
Actual
1
Adopted
1
Estimate
1
Adopted
Description
2015
2016
2016.
2017
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures and Other Uses
Personal Services
Supplies and Materials
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
$ 613,684 $ 744,804 $ 744,804 $ 690,401
1,112, 578
7,493
97,856
1,217,927
1,217,927
1,831,611
421,664
297,248
367,895
1,086,807
Total Expenditures and Other Uses: 1,086,807
Unrestricted Net Assets, December 31 $ 744,804
1,111,844
1,500
1,113, 344
1,113,344
1,858,148
419,835
388,010
360,122
1,167,967
1,167,967
$ 690,181
1,119,764
3,800
1,123,564
1,123,564
1,868,368
419,835
388,010
370,122
1,177,967
1,177,967
$ 690,401
1,158,507
3,000
1,161,507
1,161,507
1,851,908
443,362
404,160
360,672
1,208,194
1,208,194
$ 643,714
Change in Unrestricted Net Assets $ 131,120 $ (54,623) $ (54,403) $ (46,687)
21% -7% -7% -7%
M!
City of Andover
Internal Service Funds
Central Equipment Maintenance
Statement of Revenues, Expenditures and Changes in Fund Net Assets
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures and Other Uses
Personal Services
Supplies and Materials
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
Change in Unrestricted Net Assets
$ 322,692 $ 412,179 $ 412,179 $ 396,681
720,592
4,849
910
726,351
726,351
1,049,043
253,142
275,674
108,048
636,864
636,864
$ 412,179
$ 89,487
28%
720,592
500
721,092
721,092
1,133,271
256,658
360,960
121,272
738,890
738,890
$ 394,381
$ (17,798)
-4%
720,592
2,800
723,392
723,392
1,135,571
256,658
360,960
121,272
738,890
738,890
$ 396,681
$ (15,498)
-4%
698,974
2,000
700,974
700,974
1,097,655
279,543
376,360
121,822
777,725
777,725
$ 319,930
$ (76,751)
-19%
75
Actual
Adopted
1
Estimate
Adopted
Description
2015
2016
2016
2017
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures and Other Uses
Personal Services
Supplies and Materials
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
Change in Unrestricted Net Assets
$ 322,692 $ 412,179 $ 412,179 $ 396,681
720,592
4,849
910
726,351
726,351
1,049,043
253,142
275,674
108,048
636,864
636,864
$ 412,179
$ 89,487
28%
720,592
500
721,092
721,092
1,133,271
256,658
360,960
121,272
738,890
738,890
$ 394,381
$ (17,798)
-4%
720,592
2,800
723,392
723,392
1,135,571
256,658
360,960
121,272
738,890
738,890
$ 396,681
$ (15,498)
-4%
698,974
2,000
700,974
700,974
1,097,655
279,543
376,360
121,822
777,725
777,725
$ 319,930
$ (76,751)
-19%
75
Fund: 6100 76
Cost Center: Central Equipment Department Head: Vehicle Maintenance Supervisor
Activity Type/Code: Internal Service Fund
Expenditure Hi0li2hts
No major changes planned for 2017.
General Activity Description
Maintains and repairs all City motorized and non -motorized vehicles and equipment
to provide safe operation. Evaluates equipment needs, orders equipment/vehicles
and writes specifications. The department maintains nearly 500 pieces of equipment,
in addition to normal preventative maintenance procedures of tires, brakes, electrical,
fabricating and body work. All work; except automatic transmission overhauls,
major engine and major body work are done at the Public Works garage. Staff inspects
garbage trucks as part of their licensure process, and performs commercial vehicle
inspections required on all applicable City vehicles.
Process Used
City equipment is scheduled for normal service by miles driven or hours/days
of service. Most work is done based on a first -in -first -out with the exception of that
emergency repairs are done in the order of importance. Emergency equipment are
fire vehicles and snow plow equipment, streets, utilities, and parks. Non -emergency
equipment are the Building and Engineering departments, Planning and Zoning
department and all other city equipment.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
City of Andover
Internal Service Funds
Risk Management
Statement of Revenues, Expenditures and Changes in Unrestricted Net Assets
1
Actual
Adopted
1
Estimate
Adopted
Description
2015
2016
2016
2017
Unrestricted Net Assets, January 1
Revenues
Charges for Services
Interest Income
Miscellaneous
Total Revenues:
Other Sources
Transfers In
Total Revenues and Other Sources:
Total Available:
Expenditures and Other Uses
Personal Services
Supplies and Materials
Other Services and Charges
Total Expenditures:
Other Uses
Transfers Out
Total Expenditures and Other Uses:
Unrestricted Net Assets, December 31
Change in Unrestricted Net Assets
$ 290,992 $ 332,625 $ 332,625 $ 293,720
391,986
2,644
96,946
491,576
491,576
782,568
168,522
21,574
259,847
449,943
449,943
$ 332,625
$ 41,633
14%
391,252
1,000
392,252
392,252
724,877
163,177
27,050
238,850
429,077
429,077
$ 295,800
$ (36,825)
-11%
399,172
1,000
400,172
400,172
732,797
163,177
27,050
248,850
439,077
439,077
$ 293,720
$ (38,905)
-12%
459,533
1,000
460,533
460,533
754,253
163,819
27,800
238,850
430,469
430,469
$ 323,784
$ 30,064
10%
77
Fund: 6200
Cost Center: Risk Management
Activity Type/Code: Internal Service Fund
Expenditure Highlights
No major changes planned for 2017.
9..1
Department Head: Finance Director
General Activity Desciption
The Risk Management Fund was established to provide funding for compensated
absences, safety, training, loss reduction and insurance premium deductibles.
Social security and Medicare tax savings resulting from participation in the "cafeteria
plan" are recorded in this fund on an annual basis. This fund also functions to
mitigate significant rate increases or decreases. Departmental rates are
managed by analyzing claims history.
Process Used
The City Administrator / Finance Director along with the Human Resources Manager
promote various safety and wellness programs with the funding received. One of
the most notable products is the wellness fitness room. Safety training is provided
both in-house and by contracting for service. The city works through a broker and
is provided insurance for general liability, automotive and workers' compensation
through the League of MN Cities Insurance Trust.
ADOPTED 2017 BUDGET
CITY OF ANDOVER, MINNESOTA
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: September 2016 General Fund Budget Progress Report
DATE: October 25, 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 September 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.
bmitted,
CTTY OF ANDOVER
General Fund Budget Summary Totals
Budget Year 2016
2015 1 2016
REVENUES Budget Sep YTD %Bud YE Budget Sep YTD %Bud
General Property Tax
$ 7,706,892
$ 3,985,563
52%
$ 7,634,714
$ 8,113,528
$ 4,226,438
52%
Licenses and Permits
316,588
324,868
103%
452,422
346,205
439,188
127%
Intergovernmental
633,015
347,366
55%
749,570
673,248
530,633
79%
Charges for Services
748,550
597,986
80%
804,228
767,950
656,427
85%
Fines
100,750
72,610
72%
99,304
100,750
66,940
66%
Investment Income
75,000
4,891
7%
63,709
75,000
7,922
11%
Miscellaneous
98,850
139,374
141%
154,890
116,800
141,710
121%
Transfers In
196,930
196,930
100%
196,930
196,930
196,930
100%
Total Revenues
$ 9,876,575
$ 5,669,588
57%
$ 10,155,767
S 10,390,411
S 6,266,188
60%
Total Expenditures S 10,364,730 $ 7,149,401 69% S 10,089,997 S 11,003,788 $ 7,736,809 70%
NET INCREASE (DECREASE) $ (488,155) S (1,479,813) $ 65,770 S (613,377) S (1,470,621)
2015
2016
EXPENDTTURES
Budget
Sep YTD
%Bud
YE -Unaudited
Budget
Sep YTD
%Bud
GENERAL GOVERNMENT
Mayor and Council
$ 87,154
$ 71,331
82%
$ 85,061
$ 88,780
$ 70,759
80%
Administration
180,888
124,648
69%
172,296
192,778
136,465
71%
Newsletter
26,000
19,216
74%
21,042
26,000
17,429
67%
Human Resources
40,156
13,408
33%
15,909
35,260
13,342
38%
Attorney
182,000
124,510
68%
180,313
187,640
123,372
66%
City Clerk
135,359
101,308
75%
134,776
157,075
108,134
69%
Elections
57,492
12,379
22%
14,496
82,919
43,762
53%
Finance
239,981
186,284
78%
240,317
261,016
195,011
75%
Assessing
150,000
143,431
96%
146,315
150,000
143,883
96%
Information Services
172,239
100,642
58%
131,745
173,483
114,528
66%
Planning & Zoning
412,937
295,501
72%
406,045
435,606
322,101
74%
Engineering
470,631
345,379
73%
464,842
509,514
378,033
74%
Facility Management
579,802
312,283
54%
498,813
568,201
308,163
54%
Total General Gov
2,734,639
1,850,320
68%
2,511,970
2,868,272
1974,982
69%
PUBLICSAFETY
Police Protection
2,918,308
2,188,731
75%
2,918,308
2,936,467
2,202,350
75%
Fire Protection
1,192,330
714,200
60%
1,165,221
1,294,795
795,668
61%
Protective Inspection
423,161
285,010
67%
391,948
441,807
302,516
68%
Civil Defense
39,189
22,317
57%
24,352
22,982
15,262
66%
Animal Control
9,950
2,255
23%
3,498
7,950
2,184
27%
Total Public Safety
4,582,938
3,212,513
70%
4,503,327
4,704,001
3,317,980
71%
PUBLIC WORKS
Streets and Highways
625,664
478,901
77%
629,724
656,237
542,372
83%
Snow and Ice Removal
539,770
310,595
58%
442,077
563,587
338,890
60%
Street Signs
203,533
161,061
79%
204,494
204,193
118,023
58%
Traffic Signals
35,000
19,658
56%
30,169
35,000
17,099
49%
Street Lighting
36,400
20,465
56%
30,664
36,400
25,260
69%
Street Lights - Billed
216,000
133,715
62%
201,501
217,500
132,094
61%
Park & Recreation
1,185,338
833,533
70%
1,151,313
1,257,247
900,174
72%
Natural Resource Preservation
-
-
0%
-
10,096
50
0%
Recycling
135,120
96,947
69%
128,038
130,927
87,278
67%
Total Public Works
2,976,825
2,054,875
69%
2,817,980
3,111,187
2,161,240
69%
OTHER
Miscellaneous
31,728
15,693
49%
221,478
281,728
258,107
92%
Youth Services
38,600
16,000
41%
35,242
38,600
24,500
63%
Total Other
70,328
31,693
45%
256,720
320,328
282,607
88%
Total Expenditures S 10,364,730 $ 7,149,401 69% S 10,089,997 S 11,003,788 $ 7,736,809 70%
NET INCREASE (DECREASE) $ (488,155) S (1,479,813) $ 65,770 S (613,377) S (1,470,621)
A'Lb6q^----L5
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: September 2016 City Investments Review
DATE: October 25, 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 September 2016, the September 2016
Investment Detail Report, and the September 2016 Money Market Funds Report. These
attachments are intended to assist with discussion when reviewing the September 2016
investments.
ACTION REQUESTED
Informational. The Council is requested to review and provide feedback to staff.
tted,
Investment Maturities - September 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
$ 2,430,441
$ 2,430,441
$
$
$
MN Municipal Money
Market Fund (4M) N/A
4,998
4,998
Premier Banks Money
Market Fund N/A
260,649
260,649
-
Certificates of deposit FDIC
11,682,537
7,371,723
4,310,815
-
Local governments A/A1/A2
1,073,420
374,801
531,949
62,572
104,098
AAI/AA2/AA3
7,634,933
1,263,061
4,541,464
1,288,817
541,590
AAA
3,311,467
409,224
2,369,862
532,380
-
_
-
State governments A/AI/A2
-
--
22_5,804
AAl/AA2/AA3
2,602,757
833,703
1,543,250
AAA
401,838
202,530
_
199,308
-
-
U.S. agencies AAA
136,229
3,719,033
1,081,363
2,507,441
-
FNMA REMIC N/A
4,236
-
4,236
-
-
U.S. agencies N/A
1,457,751
-
1,457,751
-
-
Total investments
$ 34,584,061
$ 14,232,494
$ 17,466,077
$ 2,109,573
$ 775,917
Deposits
2,635,308
Total cash and investments
$ 37,219,370
September 2016 Investment Detail
Description
Cusip
Number
Credit
Rating/F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturity/
Due Date
Mizuho Bank USA
60688MSH8
21843
CD
245,000.00
245,000.00
245,000.00
0.700%
245,036.75
maturity
01120/16
none
10/20/16
Bank of Bridger NA
06424WGH1
2224
CD
245,000.00
245,000.00
245,000.00
0.500%
245,004.90
maturity
08/11/16
none
11/10/16
Fortis Private Bank
3495FTAE9
34401
CD
245,000.00
245,000.00
245,000.00
0.500%
245,004.90
maturity
08/12/16
none
11/14/16
Banc of Calif NA Irvine
05961SGX6
35498
CD
245,000.00
245,000.00
245,000.00
0.450%
245,019.60
maturity
07/15/16
none
12/15116
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
12116116
TCF National Bank
872278RE8
28330
CD
248,000.00
248,000.00
248,000.00
0.700%
248,057.04
maturity
12/16/15
none
12/16/16
1 Year CD - Premier Bank Rochester
2055214401
33202
CD
245,000.00
245,000.60
245,000.00
0.600%
245,000.00
maturity
12/16/15
none
12/16/16
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/16116
Wax Bank
92937CDJ4
34697
CD
248,000.00
248,000.00
248,000.00
0.750%
248,062.00
maturity
12/16/15
none
12/16/16
Community First Bk
20368VAH8
7953
CD
245,000.00
245,000.00
245,000.00
0.550%
245,029.40
245,029.40
maturity
maturity
06/17/16
none
12/19/16
First Niagara Bk Nail Assn
33583CVPi
16004
CD
245,000.00
245,000.00
245,000.00
0.550%
06/17/16
none
12/19/16
Cardinal Bank NA
14147VGB6
34733
CD
245,000.00
245,000.00
245,000.00
0.500%
245,034.30
maturity
06/29/16
none
12/29/16
Beal Bk
07370T2G7
32574
CD
245,000.00
245,000.00
245,000.00
0.600%
245,029.40
maturity
07/06/16
none
01/04/17
ZB NA
98878BDF2
2270
CD
245,000.00
245,000.00
245,000.00
0.550%
244,838.30
maturity
08/09/16
none
01/09/17
Georgia Bank & Trust
373128FV4
27574
CD
245,000.00
245,000.00
245,000.00
0.600%
245,041.65
maturity
07/08/16
none
01/09/17
Sterling Bank of Poplar Bluff
85916VAW5
57813
CD
245,000.00
245,000.00
245,000.00
0.600%
245,034.30
maturity
07/08/16
none
01/09/17
Bank of India NY
06279HNB5
33648
CD
245,000.00
245,000.00
245,000.00
0.600%
245,026.95
maturity
07/18/16
none
01/11/17
Everbank
29976DN97
254672864
34775
_ 5649
16571
CD
CD
CD
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
247,000.00
245,000.00
245,000.00
0.600%
0.600%
0.600%
0.850%
0.500%
245,034.30
245,026.95
maturity
maturity
maturity
maturity
07/14/16
07113/16
07115/16
01/27/16
none
none
none
none
06/27/16
01/12/17
Discover Bk Greenwood Del
BMO Harris Bank NA
Whitney Bk New Orleans LA
First State Community Bank
Homestreet Bank
TCM Bank
Amex Centurion Bank
CIT Bank NA _
01/13/17
01/13/17
01/27/17
02!27117
02/27/17
05581WHK4
966594AP8
33708UBZ7
43785QHZ9
872308CB5
02587DE61
245,000.00
244,794.20
247,308.75
12441
17323
32489
34535
CD
CD
CD
247,000.00
245,000.00
245,000.00
245,000.00
247,000.00
245,000.00
245,000.00
245,000.00
245,068.60
245,078.40
maturity
maturity
05/27/16
0.500%
05/27/16
06/27/16
CD
245,000.00
0.650%
245,117.60
maturity
05/31/16
none
03/31/17
27471
CD
248,000.00
248,000.00
248,000.00
0.900%
248,448.88
semi-annual
10/28/15
04/28/16
04/28/17
12556LAA4
58978
CD
245,000.00
245,000.00
245,000.00
0.650%
245,254.80
maturity
05/31/16
none
05/31/17
Bank of America
06051VZY5
3510
CD
245,000.00
245,000.00
245,000.00
0.700%
245,237.65
maturity
06/02/16
none
06/02/17
Capital One NA
14042E4Q0
4297
CD
248,000.00
248,000.00
248,000.00
1.150%
248,704.32
semi-annual
07/15/15
01/15/16
07/17/17
Investors Savings Bank
46176PFF7
28892
CD
245,000.00
245,000.00
245,000.00
0.650%
245,225.40
maturity
07/21/16
none
07/21/17
Mercantil CommerceBank
58733ADB2
22953
CD
245,000.00
245,000.00
245,000.00
0.900%
245,173.95
semi-annual
07/12/16
12/29/16
09/29/17
North Carolina Eastn Mun Pwr
658196U24
A3
local
323,218.40
323,218.40
310,000.00
6.217%
314,135.40
semi-annual
03/16116
07/01/08
01/01/17
Kaufman TX
486206KKO
A3
local
61,128.00
61,128.00
60,000.00
4.000%
60,665.40
semi-annual
06/28/16
none
02/15/17
Chaska MN
161664DU8
AA
local
76,434.00
76,434.00
75,000.00
2.000-41
75,172.50
semi-annual
08/15/13
06/01/14
12/01/16
North Mankato MN Port Auth Com
660760AG4
AA
local
107,657.00
107,657.00
100,000.00
4.000%
100,888.00
semi-annual
09/20113
none
02/01/17
Philadelphia PA Auth Zero Coupon
71781LBJ7
AA
local
161,700.00
161,700.00
245,000.00
243,071.85
maturity
01/12/10
none
04/15/17
Osseo MN ISD#279
688443J27
AA1
local
30,103.25
30,103.25
25,000.00
6.000%
25,438.00
semi-annual
12/22/11
none
02/01/17
McKinney TX
581646Y91
AA1
local
126,856.25
126,856.25
125,000.00
1.472%
125,715.00
semi-annual
05/20/15
none
08/15117
Burlington Cnty NJ
12163741-12
AA2
local
86,387.20
86,387.20
85,000.00
3.750%
85,521.05
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%
252,807.50
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%
101,715.00
semi-annual
02/24/15
none
06/01/17
Tucson AZ
89871103
AA3
local
254,202.50
254,202.50
250,000.00
2.139%
252,732.50
semi-annual
12/09115
none
07/01/17
Maple Grove MN
56516PNY5
AAA
local
230,520.40
230,520.40
220,000.00
2.000%
220,899.80
semi-annual
01/10113
08/01/13
02/01/17
7,371,722.69 CD
September 2016 Investment Detail
Description
Cusip
Number
Credit
RDIC #F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Date
Acquired
Coupon
Date
Maturity
Due Date
Ramsey Cnty MN _
Tennessee Valley Aulh
Minnesota St
Mississippi State
Tennessee State
Fed Natl Mtgg Assn
Fanner Mac
Fed Farm Credit Bank
Fed Farm Credit Bank
Fed Fane Credit Bank _ _
Fed Home Ln Bank _
Fanners & Merchants Svgs Bk
Valley Cent Svgs Bk Reading OH
Key Bank National Association
Capital One Bank (USA)
BMW Bank of North America_
Ally Bank Midvale Utah
Barclays Bank
Synchrony Bank
JP Morgan Chase Bank NA
PrivateBank&Trust Co
Goldman Sachs Bank USA
First Federal Svgs Bk
Victory Bank
751622JG7
880591EA6
604129F92
605581BV8
880541CM2
3136G1YP8
31315PZV4
3133EE6A3
3133EATE8
3133ECA95
3130A15P9
30856PAG1
91944RAE8
49306SWQ5
14042OZO6
05580ADR2
02006LF32
06740KH86
87164WBT4
48125Y51.4
74267GUQB
38147JU59
32021YCH4
92644LAB8
AAA
AAA
local
local
100,000.00
93,153.11
811,520.00
100,000.00
100,000.00
85,000.00
800,000.00
1.130%
5.500%
2.000%
1.116%
2.3269/0
0.800%
100,104.00lei-annual
-annual
-annual
06112/14
06101109
02101115
01/18/08
none
02/01/17
93,153.11
811,520.00
88.220.65i
808,680.00i
07118/17
AA1
state
07/05116
08101117
AA2
AAA
AAA _
AAA
state
state
25,000.00
25,000.00
25,000.00
200,000.00
130,000.00
25,022.75i
202,530.00
130,166.40
-annual
semi-annual
semi-annual
semi-annual
09/12113
none
12101116
201,894.00
130,130.00
201,894.00
130,130.00
10/26/11
02/01/12
08101/17
12/30/16
US
07/08/15
none
08/03/12
02106116
US
200,584.00
200,584.00
200,000.00
1.140%
0.590%
200,506.00
03/21/16
12/09/15
02/03117
02/06/17
AAA
US
200,000.00
200,000.00
200,000.00
200,102.00
semi-annual
AAA
US
99,647.00
199,800.00
99,647.00
199,800.00
251,187.50
249,000.00
150.000.00
245,000.00
245.000.00
245,000.00
245,000.00
247,000.00
247,000.00
245,000.00
247,000.00
247,000.00
249.000.00
247,000.00
128,000.00
247,000.00
100,000.00
0.900%
100,202.00
200,002.00
semi-annual
semi-annual
semi-annual
11/04/13
12/08/12
06/08/17
AAA
US
200,000.00
250,000.00
249,000.00
150,000.00
245,000.00
0.790%
1.000%
12108/15
07108/16
03118113
none
09118/17
AAA
US
251,187.50
249,000.00
150.000.00
245,000.00
245,000.00
245,000.00
245,000.00
247,000.00
247,000.00
245,000.00
247,000.00
247,000.00
249,000.00
247,000.00
128,000.00
247,000.00
247,000.00
249,000.00
249,000.00
170,045.70
101,003.00
68,632.80
250,385.00
09/26/17
CD
11,536,405.49
02/22/16
9298
1.050%
250,399.38
monthly
01/22/16
10/23/17
28555
CD
1.250%
0.850%
0.900%
1.600%
1.200%
2.050%
2.050%
1.100%
2.000%
2.050%
1.500%
2.000%
2.000%
2.050%
1.000%
2.000%
2.100%
2.750%
3.250%
6.250%
150,823.50
monthly
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
quarterly
semi-annual
semi-annual
monthly
12/22/14
07/13116
07/13116
01/22/16
06/30/16
07/03/14
07/11/14
07/15/16
01/22/15
01/13/17
01/13/17
07/22/16
12/30/16
01/02/15
01/11/15
10/15/16
01121/15
01/23/15
02/21/16
12122/17
17534
CD
245,531.65
245,316.05
248,263.40
245,690.90
253,152.77
253,123.13
245,360.15
253,172.53
252,895.89
255,543.72
07/13/18
33954
CD
CD
245,000.00
245,000.00
245,000.00
247,000.00
247,000.00
245,000.00
247,000.00
247,000.00
249,000.00
07/13/18
35141
01/22/19
07/01/19
07/02/19
07/11/19
07115/19
07122/19
57803
CD
CD
CD
CD
CD
CD
CD
57203
27314
628
33306
33124
29690
07/21/14
07123/14
01121116
07123119
08/21119
58615
CD
CD
247,000.00
128,000.00
253,409.65
semi-annual
09/24114
03/24/15
09/24/19
Third Federal Sav & Loan_ _
Celtic Bank
Steams Bank NA _
Citizens Alliance Bank
Enerbank USA _ _
Elbow Lake MN _ _
Oshkosh Wis Storm_Wtr U81
88413QAWB
15118RJMO
857894PB9
30012
131,784.96
semi-annual
semi-annual
semi-annual
monthly
monthly
semi-annual
semi-annual
11/24/14
05/24/15
06/20/14
06126115
07127114
08118114
none
11/25119
57056
CD
CD
247,000.00
255,531.38
254,454.46
12/20/13
12/20/19
10988
247,000.00
247,000.00
12/26/14
12/26/19
17318LAP9
29266NA31
_284281 KC5
68825RBD1
6824543R2
1402
CD
CD
249,000.00
249,000.00
170,045.70
101,003.00
68,632.80
249,000.00
249,000.00
165,000.00
258,125.85
258,235.41
171,966.30
100,220.00
64,125.00
06/27/14
07/18/14
12108/14
06/26/20
_
57293
07120/20
12/01119
A
local
Al
local
100,000.00
60,000.00
10/05110
0.5/01/11
05/01/18
Oneida County NY
Al
local
semi-annual
08/16/10
none
04/15/19
Junction City Kansas _
Augusta ME _
Kaufman TX
481502F72
A2
local
local
101,558.00
16,875.00
72,922.50
102,787.00
45,466.80
101,558.00
100,000.00
5.500%
5.250%
4.000%
2.000%
4.400%
2.100%
2.450%
4.5009/0
107,855.00
15,271.80
72,510.90
semi-annual
semi-annual
05/28/08
03/01/09
09/01/18
051411ND4
486206KLB
311297W84
762698GK8
750021604
A3
16,875.00
15,000.00
03/07112
none
02115/17
10/01/17
A3
local
local
local
72,922.50
70,000.00
semi-annual
06/28116
02/15/18
_ _ _
Farmington MN _
Rice Cnty MN
Racine WI
AA
102,787.00
100,000.00
40,000.00
102,501.00
semi-annual
semi-annual
semi-annual
07/06/16
none
none
06/01/12
02/01/19
AA
45,466.80
43,057.60
03/07/12
02/01/19
AA-
local
101,792.00
101,792.00
100,000.00
101,677.00
01/24112
06/01/18
MinnetristaMN
604229KE3
AA+
local
local
10,000.00
158,677.85
10,000.00
10,000.00
10,012.80
semi-annual
10/10/13
08/01/14
02/01/19
Ramsey MN
751813PB6
AA+
158,677.85
145,000.00
145,430.65
semi-annual
02/16/12
04/01/16
04/01119
2,047,086.65 local
1,036,232.75 state
1,081,363.40 US
Less Than 1 Year
4,310,814.78 CD
September 2016 Investment Detail
Description
Cusip
Number
Credit
Rating/F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
gcquired
Coupon
Date
Maturity/
Due Date
Rothsay MN ISD #850
778731AZ2
AA+
AA+
AA+
local
local
208,640.25
208,640.25
276,875.00
161,038.40
27,593.50
106,487.00
195,000.00
3.000%
208.193.70
255,080.00
semi-annual
semi-annual
semi-annual
semi-annual
07/06/16
04/17/13
10/10/13
07/09/13
none
02/01/20
Steams Co MN
857896MH4
604229KG8
276,875.00
250,000.00
4.500%
none
08/01/14
06/01/20
Minnetrista MN
Greenway MN ISD #31 _
Dane County Wl
local
161,038.40
160,000.00
3.100%
5.000%
2.450%
4.000%
4.400%
3.960%
160,228.80
02/01/21
39678LDF6
AA+
AA1
_ AA1 _
AA1
local
local
27,593.50
106,487.00
25,000.00
27,240.75
101,731.00
none
03/15/21
236D91M92
60374YF93
100,000.00
semi-annual
semi-annual
semi-annual
07/16/12
03/04/14
10131112
none
12/01117
_
Minneapolis MN
local
220,938.00
220,938.00
200,000.00
209,024.00
none
03/01118
_
Scott County IA
809486EZ2
local
114,450.33
112,617.00
100,000.00
104,103.00
12101112
06/01/18
King Cnty WA
4947401.5
AA1
local
224,634.00
224,634.00
200,000.00
211,824.00
semi-annual
03/27/12
none
12/01/18
Minneapolis MN
60374YS73
_
AA1 _
local
111,898.00
111,898.00
_ 100,000.00
3.250%
105,136.00
semi-annual
06/05/12
12/01/11
12/01/18
_
Cedar Rapids IA
Minneapolis MN
150528RM1
60374YS81
AA1
_ AA1
AA1
AA1
AA1
local
217,672.00
278,632.50
217,672.00
278,632.50
200,000.00
3.000%
3.500%
2.209%
3.750%
2.450%
2.000%
1.000%
5.250%
4.000%
4.400%
2.000%
3.150%
2.400%
1.740%
3.800%
4.650%
4.850%
3.750%
3.850%
209,734.00
semi-annual
semi-annual
semi-annual
06111/13
12/01/13
06/01/19
12/01/19
04/01/20
local
250,000.00
267,812.50
02/26/13
01/20/16
none
Hampton VA
Middleton Wl
4095582.11
596782RX2
250097H21
local
100,836.00
106,979.00
100,836.00
106,979.00
50,606.00
100,000.00
100,000.00
50,000.00
102,834.00
none
kcal
kcal
105,084.00
52,598.50
semi-annual
semi-annual
02/24115
11/10/14
07/12/16
05/14/15
04/30/12
08/04/16
08/05/10
06/27/13
08/16/11
07/17/13
08121/15
07/16112
11/14111
none
09/01/20
Des Moines lA Area Cmnty Col
50,606.00
12/01/14
06101/21
Regl Transprin Dist, Denver
Prior Lake MN _
Hopkins Minn ISD#270
Orono MN ISD#278 _
Orange Beach ALA
Waterloo IA
Western Lake Superior MN
Portsmouth VA
Brunswick Cnty
Kane McHenry Cook 8 De Kalb Zero Cpm
Moorhead MN _
Davenport Iowa _
Whitewater Wis
Washington County MN
759136RR7
_
AA2
AA2
_ AA2
AA2
AA2
AA2
AA2
AA2
AA2
AA3
AA3
AA3
AA3 _
AAA
AAA
AAA
AAA
AAA_
kcal
254,312.50
254,312.50
230,000.00
95,278.40
115,511.00
250,000.00
230,000.00
80,000.00
252,710.00
230,253.00
84,371.20
114,592.50
252,736.80
51,052.00
105,219.00
304,976.90
111,820.50
192,270.00
102,975.00
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
11/01/13
11101/17
12/15/17
742617CB7
local
local
local
230,000.00
12/15/15
439881HCO
95,278.40
08/01109
02/01/17
02101/11
12101/13
04101112
02101/14
02/01118
687136LA7
115,511.00
110,000.00
02/01118
02/01/19
06/01/19
10/01/19
02/01/20
05/01/20
12/01/18
68406PHF1
941647PAI
958522WU4
73723RSL8
117061VH1
484080MB9
6161412R7
local
local
local
local
local
local
local
local
local
241,689.60
50,559.50
241,689.60
50,559.50
100,000.00
286,268.00
108,967.10
157,328.00
108,820.00
111,948.00
240,000.00
50,000.00
100,000.00
286,268.00
108,967.10
157,328.00
100,000.00
295,000.00
110.000.00
200,000.00
none
maturity
semi-annual
semi-annual
semi-annual
semi-annual
none
108,820.00
100,000.00
100,000.00
none
none
02/01/20
_238388GS5
966204KA6
111,948.00
102,391.00
09/13/11
06/09/11
07/01/10
12/22/11
06/26/13
12/22/11
07/06/11
12127/13
06101/20
109,541.00
109,541.00
115,000.00
112,114.00
229,640.00
100,000.00
112,793.00
none
12101/20
01/01118
937791K_L4
local
115,000.00
112,114.00
229,640.00
115,000.00
100,000.00
250,000.00
35,000.00
117,503.55
103,722.00
244,797.50
36,326.95
236,486.80
01/01111
none
none
_
Saint Louis Park MN
791740WC3
116421E46
local
semi-annual
02/01/18
Brownsville TX ISD Zero coupon
local
local
local
3.100%
5.898%
4.050%
maturity
08/15/18
Minnetonka MN ISD #276
Palm Beach Cnty FLA
604195RA7
37,433.20
37,433.20
semi-annual
semi-annual
maturity
semi-annual
none
02/01/19
696497TR7
256,504.60
256,504.60
262,890.00
220,000.00
none
none
06/01/19
_
Tenn Val Auth Cpm Strip Zero Cpn
Norwalk Conn
88059EWZ3
_
AAA
local
262,890.00
300,000.00
289,275.00
06/15/19
668844DS9
_ _
AAA_
AAA
AAA
AAA_
local
122,464.80
122,464.80
120,000.00
126,448.80
08104110
08/01/11
08/01/19
_
Greensboro Kc
39546OV21
366,832.80
366,832.80
360,000.00
3.263%
378,892.80
semi-annual
07115/11
none
10/01/19
Woodbury MN
Dallas TX Indpt Sch Dist
97913PCQ7
_local
local
123,037.35
123,037.35
116,900.00
115,000.00
3.250%
119,828.85
semi-annual
12/22111
none
02/01/20
235308QK2
local
116,900.00
100,000.00
4.450%
1.400%
109,833.00
285,540.00
94,628.00
175,248.50
semi-annual
04/16/12
08/15111
02115120
Tenn Valley Auth Zero Cpn
88059EHD9
AAA
local
263,970.00
263,970.00
300,000.00
maturity
03/11/13
none
05/01120
Tenn Val Auth Cpn Strip Zero Cpn
McAllen TX Dev Corp
Baltimore Cnty MD _
88059EMX9
_ AAA
AAA _
AAA
AA
local
88,133.00
88,133.00
100,000.00
maturity
03/18/13
none
07/15/20
579086AW9
local
175,000.00
175,000.00
51,290.00
205,804.00
175,000.00
semi-annual
07/26/16
02/15/17
08/15120
05914FME7
local
stale
51,290.00
50,000.00
2.097%
51,328.50
semi-annual
08/31/16
none
08/01/21
Washington State
93975801-9
205,804.00
200,000.00
4.500%
210,272.00
semi-annual
01/24/12
04/01112
10/01118
7,443,275.45 local
Description
Cusip
Number
CreditRatiri
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
I
Due Dat
Due Date
Massachusetts State
57582P2T6
AA1
state
199,744.00
199,744.00
200,000.00
2.090%
205,282.00
semi-annual
12/17/14
11/01/14
05/01/20
New Hampshire St Hsg
64469DWU1
AA2
state
220,838.20
220,638.20
220,000.00
1.789%
221,551.00
semi-annual
12/09/15
07/01/16
01/01/18
New Hampshire St Hsg
64469DWV9
AA2
state
120,715.20
120,715.20
120,000.00
1.939%
121,198.80
semi-annual
12109/15
07/01/16
07101/18
Kansas St Dev Fin Auth
485429X90
AA3
state
182,743.20
182,743.20
180,000.00
1.877%
181,641.60
semi-annual
07/12/16
none
04/15/18
Florida St Hurricane
34074GDH4
AA3
state
279,439.80
279,439.80
270,000.00
2.995%
283,311.00
semi-annual
11/10/15
07/01/13
07101/20
Minnesota St Colleges & Univ
60414FPJ3
AA3
slate
100,000.00
100,000.00
100,000.00
2.000%
102,200.00
semi-annual
02/26/15
10/01/15
10/01/20
Connecticut State
20772JQN5
AA3
state
214,954.00
214,954.00
200,000.00
3.517%
217,794.00
semi-annual
05127/16
02115/14
08/15/21
Georgia State
373384RQ1
AAA
state
26,742.50
26.742.50
25,000.00
2.970%
25,956.50
semi-annual
02/08112
none
10/01/18
Texas State
882722,151
AAA
state
103,089.00
103,089.00
100,000.00
2.894%
103,837.00
semi-annual
08/10/11
04/01/12
10/01/18
Tennessee State
880541QQ3
AAA
state
48,218.85
48,218.85
45,000.00
3.178%
48,050.10
semi-annual
08/30/16
02/01/12
08/01/20
Virginia State
928109XD4
AAA
state
22,126.00
22,126.00
20,000.00
4.100%
21,464.80
semi-annual
02/07/12
none
06/01/21
Fed Farm Credit Bank
Fed Home Ln Mtg Corp Med Term Note
3133EFJMO
AAA
US
249,750.00
249,750.00
250,000.00
0.930%
249,950.00
semi-annual
05/25/16
04/13/16
04/13/18
3134G3ZK9
AAA
US
200,000.00
200,000.00
200,000.00
1.200%
201,142.00
semi-annual
07/30/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%
107,471.00
semi-annual
09/11/13
none
08/01118
Fed Natl Mtg Assn
3136GOY70
3133EC5NO
AAA
US
199,300.00
199,300.00
200,000.00
100,000.00
1.080%
1.250%
200,496.00
semi-annual
10/30/12
01/30/13
01/30/19
Fed Farm Credit Bank
AAA
US
99,587.00
99,587.00
100,001.00
semi-annual
01/07/13
03/04/13
03/04/19
Fed Home Ln Mtg Corp Med Term Note
3134G96U6
AAA
US
200,000.00
200,000.00
200,000.00
1.050%
199,458.00
quarterly
08/23/16
11/23/16
08/23/19
RFCSP Strip Principal Zero Coupon _ _
Fed Farm Credit Bank
Fed Home Ln Mtg Corp Zero Cpn
Fed Home Ln Bank
Fed Nall Mtg Assn Rennie
FICO Strip Prin Zero Coupon
FICO Strip Pm4 Zero Coupon
FICO Strip Cpn-EZero Coupon
FICO Strip Cpn Zero Coupon
Fed Home Ln Mtg Corp
76116FAA5
AAA
US
185,568.00
185,568.00
200,000.00
193,426.00
maturity
semi-annual
maturity
semi-annual
monthly
maturity
maturity
07122/15
05/25/16
11/02/15
07/22/15
07/30/03
none
11/25/16
none
08/10/15
none
10/15/19
3133EGBKO
31340OBV4
313OA3XL3
31393EAL3
31771 KAC1
31771EAD3
31771JXM7
AAA
AAA
US
US
199,600.00
950,527.00
199,600.00
950,527.00
200,000.00
1,000,000.00
1.300%
199,998.00
955,290.00
11/25/19
11/29/19
02/10/20
08/25/18
10/06/17
AAA
_ _
US
US
US
99,500.00
204,187.50
295,932.00
99,500.00
4,238.14
295.932.00
100,000.00
4,151.21
300,000.00
1.500%
4.500%
100,209.00
4,236.02
297,567.00
198,454.00
221,574.08
10/23/15
none
US
194,572.00
194.572.00
200,000.00
03/16/15
none
10/06/17
11/02/17
US
215,452.16
215,452.16
224,000.00
550,000.00
maturity
12/11/14
none
31771EAA9
US
529,947.00
529,947.00
542,404.50
maturity
06/09/14
none
05/11/18
31393VMQI
US
153,656.25
2,630.74
2,568.13
4.500%
2,617.46
98,023.00
monthly
06/30/03
06/15/18
Fico stocpnl3zero coupon
31771C2G9
US
93,140.00
93,140.00
100,000.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,111.00
maturity
04/17/15
none
02/01/19
17,466,077.09
Kaufman TX
486206KR5
A3
local
61,821.00
61,821.00
60,000.00
3.000%
62,572.20
semi-annual
06/28/16
02/15/17
02/15/23
Chaska MN
1616fi36S3
AA
local
115,122.70
115,122.70
110,000.00
4.000%
116,431.70
semi-annual
09/08/14
none
02/01/24
Mitchell SD Sch Dist#17-2
606687EHO
AA
local
116,702.00
116,702.00
100,000.00
6.000%
109,911.00
semi-annual
12120/11
06/15/19
06/15/24
MinnehistaMN
604229KJ2
AA+
local
40,000.00
40,000.00
40,000.00
3.850%
40,065.60
semi-annual
10/10/13
08/01/14
02/01/23
Savage Minn
80465PAN4
AA+
local
198,018.00
198,018.00
200,000.00
4.800%
211,470.00
semi-annual
06/17/10
02/01/11
02/01/24
Lake City Minn ISD #813
508084DW7
AA+
local
103,933.00
103,933.00
100,000.00
5.000%
106,817.00
semi-annual
05/11/11
none
02/01/25
Minneapolis MN
60374YG68
AA1
local
110,419.00
110,419.00
100,000.00
4.700%
107,902.00
semi-annual
10/31/11
none
03/01/23
Minneapolis MN
60374YG76
AA1
local
72,201.35
72,201.35
65,000.00
4.800%
70,158.40
semi-annual
12/09/14
none
03/01/24
Alexandria MN ISD#206
015131LQ6
AA2
local
279,760.50
279,760.50
29,767.20
270,000.00
30,000.00
3.000%
288,519.30
semi-annual
01/21/15
none
02/01/23
Duluth MN
264438ZL9
AA2
local
29,767.20
2.625%
30,419.10
semi-annual
12/05/12
08/01/13
02/01/25
W Palm Beach FL
955116BE7
AA3
local
101,245.00
101,245.00
100,000.00
2.264%
101,571.00
semi-annual
07/05116
10/01/16
10/01/22
3,969,428.06 US
1- 5 Years
September 2016 Investment Detail
Description
Cusip
Number
l
Type
Purchase Price
Acaired
Due Date
Current Market
Value
Description
Cusip
Number
Credit
RatinglF
DIC
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
q
Hawkins Cnty TN
420218/31-7
AA3
local
111,480.00
111,480.00
100,000.00
4.800%
105,552.00
semi-annual
03/13/12946
05/01/24
New York St Mtge Agy
64988RHGO
AAA
local
100,000-00
100,000.00
100,000.00
2.375%
102,473.00
semi-annual
10/27/15
10/01/21
Columbus OH
199492CS6
AAA
local
39,956.40
39,956.40
40,000.00
100,000.00
2.133%
40,922.80
semi-annual
02/20/1512/01/21
Tennessee Valley Auth Ser E
880591CJ9
AAA
local
121,500.00
121,500.00
6.750%
_138,984.00
semi-annual
03/19/0911/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
01/01/26
Florida St Dept Environmental
3416OWUAO
AA3
state
217,800.00
217,800.00
200,000.00
6.206%
225,804.00
semi-annual
08/30/10
07/01/10
07/01/22
2,109,573.10
Itasca County Minn
465452GP9
A
local
105,024.00
105,024.00
100,000.00
5.550%
104,098.00
semi-annual
07/12/11
none
02/01/28
Milaca Minn ISD #912
598699NT9
920729HD5
AA+
local
106,941.00
106,941.00
100,000.00
5.650%
109,320.00
111.700.00
semi-annual
07/22/11
none
02/01/27
Van Buren Mich Public Schools
AA1
local
102,750.00
102,750.00
100,000.00
6.430%
semi-annual
07/17/09
11/01/09
05/01/29
Will County lL Cmnty Zero Coupon
969078QM9
AA2
local
US
159,000.00
106,030.45
159,000.00
500,000.00
320,570.00
maturity
08/25/09
none
11/01/27
Fed Farm Credit Bank
31331VLC8
AAA
106,030.45
100,000.00
5.250%
775,917.00DateMaturtty
130,229.00
semi-annual
02/26/10
none
04/21/28
31,887,972.68
1,883,769.10 local
225,804.00 state
6 - 30 Years
645,688.00 local
130,229.00 US
10+ Years
INVESTMENT SCHEDULE - Money Market Funds
September 30, 2016
Description
Current Market
Value
YTD Interest
Wells Fargo
I Wells Fargo Government Money Market Fund
$2,430,441.3477
$204.82
4M
z 4M
1,893.64
1.12
4M PLUS
I 14M Plus
1 3,104.801
3.95
Premier Bank
I I Premier Bank Money Market
260,648.951
611.55
Grand Total Money Market Funds 1 $2,696,088.73 1$821.44
Updated: 10/10/2016