HomeMy WebLinkAboutWK - August 28, 20189VNDOVE I T Y O F
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
City Council Workshop
Tuesday, August 28, 2018
Conference Rooms A & B
Call to Order — 6:00 p.m.
2. Joint Meeting with Park & Recreation Commission — Engineering
(76 3) 755-5100
A. Update of the 2019-2023 Trails CIP
B. Update of the 2019-2023 Parks CIP
C. Update of the 2019-2023 CIP for Playground Equipment Replacement
D. Discuss Zones A -D Parks and the Priorities
E. Update on Associations Storage Needs
F. Discuss Fee for Use of Fields by Groups/Organizations/Associations
3. Discuss Remote Control Dirt Track/Median of Eagle St. NW — Engineering
4. Discuss Potential Veterans Memorial Blvd. NW Layouts East of Nightingale St. NW/18-37
— Engineering
5. Update City Campus Master Plan Potential Projects—Administration/Engineering
6. 2019 Budget Development Discussion —Administration
Preview 2019 Preliminary Tax Levy —Administration
8. 2018 Budget Progress Reports —Administration
9. 2018 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.ANDOVERMN.GOV
TO: Mayor and Council Members
CC: Jim Dickinson, City Administrator
David D. Berkowitz, Director of Pui Works/City Engineer
FROM: Todd J. Haas, Assistant Public Works Director/Parks Coordinator
SUBJECT: 2A. Discuss 2019-2023 Trail CIP - Engineering
DATE: August 28, 2018
INTRODUCTION
The City Council is requested to discuss the 2019-2023 Trail Capital Improvement Plan (CIP).
It has been 2 years since the Park and Recreation Commission has reviewed the City trail map
(existing and future trail map) and provided any input regarding future trail projects for the
Capital Improvement Plan. Based on review of the future trail plan, the Commission has ranked
the following trail projects the City Council should consider as part of the 2019-2023 Capital
Improvement Plan (CIP). The top 3 trail projects ranked in order are as follows:
ASN Trail between Kensington Estates 7th Addition and Andover Station North Ball
Field Facility. Note: This section of trail has received approval of a MNDNR Grant and
will be constructed in 2019.
Crosstown Blvd NW from Xeon Street NW to Prairie Road NW including the section
from 157th Avenue NW to 1591h Avenue NW (Millers Woods development). RR
Crossing on Crosstown Blvd NW will be required.
Station Parkway NW (south side of street) from Crosstown Blvd NW to just west of
Partridge Circle NW and from the east leg of Partridge Street NW to Hanson Blvd NW.
Three other trail segments that were considered in order (highest to lowest) are as follows:
A. Tulip Street NW from 157th Avenue NW to 161St Avenue NW to allow access to the Pine
Hills North Facility and Pine Hills South Park.
B. Trail system around perimeter of Round Lake
C. Verdin Street NW form 16151 Avenue NW to 163`d Lane NW (this was presented to the
Commission as an option since this has been identified in past CIP's but there was no
support by the Commission for this improvement).
BUDGETIMPACT
The funding for trail projects has not been identified for 2019-2023. The City Council will need
to determine what year based on funding, the trail segments may want to be constructed.
Mayor and Council Members
August 28, 2018
Page 2 of 2
ACTION REQUIRED
The City Council is requested to discuss the 2019-2023 Trail Capital Improvement Plan (CIP)
and direct staff on how to proceed.
Respectfully submitted,
Todd J. Haas
Cc: Park and Recreation Commission Members
Attachment: Location maps for all 3 segments that was considered by the P&R Commission
a W w-
/m
:4i.
1
0
-e.
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Council Members
CC: Jim Dickinson, City Administrator-
David D. Berkowitz, City Engineer rctorf Public Works
Park and Recreation Commission Members
FROM: Todd J. Haas, Assistant Public Works Director/Parks Coordinator
SUBJECT: 2B. Update of the 2019-2023 CIP for Parks - Engineering
DATE: August 28, 2018
INTRODUCTION
This item is an update in regards to the 2019-2023
Park and Recreation Commission.
CIP for Parks that has been recommended by the
DISCUSSION
Listed below are the projects that have been identified by the Park and Recreation Commission over
the next 5 years:
2019
Small irrigation project (Hills of Bunker Lake West Park) - $20,000 (no recommended changes
from staff).
Kelsey Round Lake Park Trail Expansion -- $152,000 ($76,000 from MNDNR Grant and
$76,000 from Park Dedication Fund)
• Annual Misc. Projects - $15,000 (no recommended changes from staff).
2020
Pine Hills North/Parking lot with curb - $120,000
Annual Misc. Projects - $15,000 (no recommended changes from staff).
2021
• Annual Misc. Projects - $15,000 (no recommended changes from staff).
2022
2023
Annual Misc. Proiects - $15,000 (no recommended changes from staff).
Annual Misc. Projects - $15,000 (no recommended changes from staff).
Note: It was discussed with the Commission to consider paving the north parking lot at Prairie Knoll
Park but at this point was not recommended.
Mayor and Council Members
August 28, 2018
Page 2 of 2
Attached is the Park Improvement Projected Fund Balance spreadsheet for your review identifying
projects listed above.
ACTION REQUIRED
This is for informational only and no action is required.
Respectfully submitted,
.%000f UP
5,
Todd J. Haas
Cc: Park and Recreation Commission Members
Attachment: Proposed 2019-2023 IP Park Improvements Location Maps; Park Improvement
Projected Fund Balance spreadsheet
Capital Improvement Plan (2018)
Project Name: IRRIGATE HILLS OF BUNKER LAKE WEST PARK
L
E G E N D
41
Project Location
Lots/Parcels
Co
Park
Water
Right of Way
City Limits
0
1
L Do Mnt Path: HAGlsdatatEnginea trp\Pgja CIP_2017,0
N
W E
S
100 200 300
Qn
Feet65
Attachment C- Recreational Site Plan LN66AVE^ o r
Kelsey Round Lake Nature Park
- Parking Lot
.. : re•
- Proposed Feature ,� '' � P "•
+ Existing Bench
s'
— Existing Trail s`-
a� Existing Boardwalk
Proposed Trail (for Grant)
m Proposed Boardwalk
Potential Future Dock
Potential Future Trail
Existing Entrance
Possible Entrance �.
OPark Area, 152.6 Acres
Wetlands (NWI)
Note: All surrounding parcels are zone.
R-1 Rural Residential
t
W
N'�t7+.'
0 250 500 1,000
Feet
Applicant Signatu�rte)e and Da
-- ✓W/ dw— 112I91IS
a Round Lake
Capital Improvement Plan (2020)
Project Name: PINE HILLS NORTH PARKING LOT IMPROVEMENTS
L E G E N D
Document Path: HAGisdetetEwineedngW(q as\CIP_2017.mxd
0
0 250 500 750
Feet67
Project Location
Lots/Parcels
Park
Water
Right of Way
City Limits
Document Path: HAGisdetetEwineedngW(q as\CIP_2017.mxd
0
0 250 500 750
Feet67
Projected Sources of Revenue
Park Dedication Fee - Residential Units
Park Dedication Fee - Residential ($3,319/unit)
Donation / Contribution - Kelsey Round Lake Park
Capital Projects Levy - Park Improvements
Total Revenues Available
Projected Commitments
Fox Meadows - Reconstruction
Irrigation Project -Small
Sophies Park - Trail connection
Rose Park -Shelter Expansion, ADA, Slab
Kelsey Round Lake Park - Trail Expansion
Pine Hills North - Phase II
Parking Lot w/ Curb (30% Park Dedication)
Annual Miscellaneous Projects
Total Commitments
Revenues Over (Under) Expenditures
2018
CITY OF ANDOVER
Park Improvement Fund
Projected Fund Balance
2019 2020 2021
2022 2023 TOTALS
25
25
25
25
25
25
$ 82,975
$ 82,975
$ 82,975
$ 82,975
$ 82,975
$ 82,975
$ 497,850
-
76,000
-
-
-
-
76,000
15,000
15,000
15,000
15,000
15,000
15,000
90,000
97,975
173,975
97,975
97,975
97,975
97,975
663,850
20,000
20,000
45,000
20,000
65,000
12,000
12,000
10,500
10,500
152,000
152,000
120,000
120,000
15,000
15,000
15,000 15,000 15,000
15,000 90,000
102,500
187,000
135,000 15,000 15,000
15,000 469,500
(4,525)
(13,025)
(37,025) 82,975 82,975
82,975
Fund Balance as of December 31, 2017 136,375
Fund Balance Brought Forward 131,850 118,825 81,800 164,775 247,750
Ending Fund Balance ** $ 131,850 $ 118,825 $ 81,800 $ 164,775 $ 247,750 $ 3302725
**Target - $50,000 to create a contingency for any project overages.
Funds Available for Rose Park
Rose Park - tower rental fee $ 24,917
Chesterton Commons Park- Donation 1,076
$ 25,993
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and City Council
CC: Jim Dickinson, City Administrator
David D. Berkowitz, Director of Public Works/City Engineer
Park and Recreation Commission Members
FROM: Todd J. Haas, Assistant Public Works Director
SUBJECT: 2C. Update on the 2019-2023 Park Playground Equipment Replacement Plan
DATE: August 28, 2018
INTRODUCTION
This an update in regard to the 2019-2023 CIP for Park Playground Equipment Replacement Plan
that has been prepared by staff.
DISCUSSION
Below are the proposed structures that are being recommended to be replaced as part of the CIP.
• 2019 — Purple Park (City Hall)
• 2020 — Strootman Park and Hawkridge Park
• 2021 — Sunshine Park and Hidden Creek North Park
• 2022 — Prairie Knoll Park and Wild Iris Park
• 2023 — Rose Park and Hidden Creek East Park
The general life expectancy for playground equipment is 15 years. The main playground structure
at Purple Park (City Hall) was built in 2001 and is top priority to be replaced. The structure does
not meet handicapped requirements, decks are in poor condition (due to high usage by the public)
and the metal joints are rusting. The fall zones are sand which also does not meet handicapped
requirements and the wood borders around the playground equipment are rotting. Based on the
potential expansion of the Community Center/YMCA, the existing playground equipment will
not be impacted. The playground equipment is proposed to be replaced in 2019. The $50,000 that
has been identified in the CIP will not be enough to replace it and therefore will require
additional funding. If there is no commitment at this time to replace the structure at Purple Park,
staff recommends Strootman and Hawkridge Park playground structures replaced.
Parks Maintenance Department will continue to review the playground structures from year to
year, so the list may change as the condition of the structures change.
Mayor and Council Members
August 28, 2018
Page 2 of 2
BUDGETIMPACT
As indicated on the attached sheet $50,000 is proposed to be allocated for 2019 and $75,000 for
each year after that from 2020-2023. For the past few years Public Works Parks Maintenance
Department was making every effort to replace at least 2 structures a year but with the rising cost
of equipment and supplies (concrete borders, wood chips, etc.) the number of playground
rebuilds over the last few years has been reduced to 1 or 2 a year depending on what needed to be
done for each playground structure. To keep up with replacing of older/outdated equipment,
additional funds are recommended if the City would like to replace 3 structures a year.
The Park and Recreation Commission has discussed the priorities of the park system which will
be addressed as part of Item 2D.
ACTION REQUIRED
The City Council is requested to direct staff on how to proceed with (2019-2023) playground
replacement schedule.
Respectfully submitted,
Todd J. Haas
Attachments: 2019-2023 CIP Park Playground Equipment Replacement Plan
Capital Plan
City of Andover, MN
2019 thru 2023
Project# 19-45000-01
Project Name Replace/Repair Play Structures -Various Parks
Department Park & Rec - Operations
Contact DPW / CityEngineer
Type
Improvement
Useful Life
15-20 Years
Category
Park Improvements
Priority
1 -High
listed are in need of replacing the existing playground equipment and repairing the fall zones to achieve ADA
playground equipment improvements/rebuilds are as follows:
19 - Purple Park (City Hall)
20 - Strootman Park and Hawkridge Park
21 - Sunshine Park and Hidden Creek North Park
22 - Prairie Knoll Park and Wild Iris Park
23 - Rose Park and Hidden Creek East
Justification
quipment no longer meets ADA requirements, such as entrapments, fall zones and handicap accessibility. Working to bring the parks up to
all safety requirements.
Expenditures 2019 2020 2021 2022 2023 Total
Equipment 50,000 75,000 75,000 75,000 75,000 350,000
Total 50,000 75,000 75,000 75,000 75,000 350,000
Funding Sources
2019
2020
2021
2022
2023
Total
General Fund
50,000
75,000
75,000
75,000
75,000
350,000
Total 50,000
75,000
75,000
75,000
75,000
350,000
maintenance and will meet all safety requirements.
Thursday, August 23, 2018
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Council Members
CC: Jim Dickinson, City Administrator
David D. Berkowitz, Director of orks/City Engineer
Park & Recreation Commission
FROM: Todd J. Haas, Assistant Public Works Director
SUBJECT: 2D. Discuss Zones A -D Parks and the Priorities
DATE: August 28, 2018
INTRODUCTION
The City Council is requested to discuss the priorities as to the importance of each park and
features within the park in Zones A -D as reviewed with the Park and Recreation Commission.
DISCUSSION
Attached is spreadsheets of Area A -D replacements that have been identified for each of the
parks within the system. Staff has identified the priority of each item in each park as either low,
medium, or high. The Commission has reviewed the priorities for each area and had no changes.
The number of and types of parks in each zone are as follows:
Zone A (13 parks)
• Mini Parks — 2 parks
• Neighborhood Parks — 6 parks
• Community Playfields — 4 parks
• Community Parks — 1 park
• Special Use Park — 0 parks
• Linear Parks — 0 parks
Zone B (8 parks)
• Mini Parks — 5 parks
• Neighborhood Parks — 3 parks
• Community Playfields — 0 parks
• Community Parks — 0 parks
• Special Use Park — 0 parks
• Linear Parks — 0 parks
Mayor and Council Members
August 28, 2018
Page 2 of 2
Zone C (21 parks)
• Mini Parks — 9 parks
• Neighborhood Parks — 8 parks
• Community Playfields — 1 park
• Community Parks — 1 park
• Special Use Park — 2 parks
Zone D (27 parks)
• Mini Parks —12 parks
• Neighborhood Parks — 7 parks
• Community Playfrelds — 6 parks
• Community Parks — 0 parks
• Special Use Park — 0 parks
• Linear Parks — 2 parks
This spreadsheet was created at the direction of the City Council at the joint meeting with the
Park and Recreation Commission back in October 2017. The spreadsheet identifies the priority of
each park and features within the park so that when the time comes to replace existing items or
pieces of equipment (for example playground equipment) due to condition, age, ADA
requirements, and/or lack of resident use. The City will then have a plan in place on how to deal
with each park when it comes up for reconstruction or for an additional improvement. By
identifying the priorities for each of these parks and what items or equipment will or will not be
replaced or repaired has an impact on the Existing and Future Park Facilities Chart (replacement
section of the spreadsheet) which could reduce the cost to the general fund to replace or repair
these features.
ACTION REQUIRED
The City Council is requested to discuss the priorities as to the importance of each park and
features within the park in Zones A -D.
Respectfully submitted,
Todd J. Haas
Attachment: Map of Zones A -D; Area A -D Replacement spreadsheet
/l/9IENn INDIAN TRIBES
£/OWE Rf
_
rm^/eimm Darn
^/\/Ha.w.iY
BIRDS
TREES
mn,rt�k.n
PARKS & TRAILS
mnbe
perk Na
MAP
A Ciry Futures
e
BI City Hall/ YMCA/ Community Center
City Map Key for Parks & City Features
f
is
•J
mar AVE
4A
�
OA
276
a
19B
SA '
emNAVR
-2A
+
,.
21B�
4
. 1A
S 7A
12A—V�.J�
1
�A
taarx RYE
q
is �g 1A
a I
RARE _ SA
46C
36C
4 C
j i37C
N 39C
e
38C
J
32C
>n.00.r ........,,.omu
ROUND
LAKE 1
13A Q
C
6A
I
1'42C pC ar:wxa
0 a3C 82D—
r 41Gi 4Of�
�4/8/C �. ••yIt'
\f 1
35C
26B 4 B
680,
22B
1248
WARD,
uRE
20B
mirarABrettvD
0123B
; 1/6203gi1.. •�'74D
K.
E! `72D
t�
63J D
/7SD
�76D
69D
RLw ,
,650
saD _
X10 SOD
e
�W
L F. L E N D
m Pas
a P.__
_
rm^/eimm Darn
^/\/Ha.w.iY
.... m.�Y`.
mn,rt�k.n
PARKS & TRAILS
mnbe
perk Na
MAP
A Ciry Futures
F'✓�`W en`"'r
BI City Hall/ YMCA/ Community Center
City Map Key for Parks & City Features
Rr ' City Features:
i w ••.•• e.mmrefywarcufen®�f.�.r f,n.Fw�nrsn. vmks<nwi
�.. � e nrm... ek�.+rr t emu.a ea. eka.ains.mu r n..nevrrti.r
[ MMrn Hme9lml l Frt fuum.l (. Pun Ekmmury
_ f. /uWarn PULlk Wab I: ive Yrrvm.t P )upkclnrury
ti � •••• F. MOW faw�Y W{lirry P.Wrmry I Fve frrnm.l
... . .c4wYrw nw...nn.. n. i•s..r n........a�r
r: /uel.fwery MrT dr a .V Mmryin Cmwl
..em..
.... m.�Y`.
.Tat
Rr ' City Features:
i w ••.•• e.mmrefywarcufen®�f.�.r f,n.Fw�nrsn. vmks<nwi
�.. � e nrm... ek�.+rr t emu.a ea. eka.ains.mu r n..nevrrti.r
[ MMrn Hme9lml l Frt fuum.l (. Pun Ekmmury
_ f. /uWarn PULlk Wab I: ive Yrrvm.t P )upkclnrury
ti � •••• F. MOW faw�Y W{lirry P.Wrmry I Fve frrnm.l
... . .c4wYrw nw...nn.. n. i•s..r n........a�r
r: /uel.fwery MrT dr a .V Mmryin Cmwl
Replacement Priority
Area A Replacements
High Priority
Medium
Priority
Low Priority
Park # & Park Name
Replacement
Park Name
Cost Estimate
1A - Cedar Crest
N/A
2A - Cedar Crest Estate
N/A
3A - Fox Meadows Park
Field Maintenance: Regrade, Reseed, Irrigation
$
10,000.00
Fox Meadows
Playground Structure (15 Year Cycle)
$
55,000.00
Fox Meadows
950'x 10' Chain Link Fence
$
46,500.00
Fox Meadows
185 yds Engineered Wood Fiber
$
7,400.00
Fox Meadows
50x50 Asphalt Basketball Court
S
19.300.00
Fox Meadows
Medium Shelter with Concrete Pad - Replacement
$
146,000.00
Fox Meadows
4A - Hawk Ridge
Field Maintenance: Regrade, Reseed, Irrigation
$
15,000.00
Hawkridge
Replace Medium Shelter and Concrete Pad
$
30,000.00
Hawkridge
Replace Playground Structure w/ Larger One
$
46,300.00
Hawkridge
Border Magic Edging w/Fibe_ r Chip Fall Zone
$
0,300.00
Hawkridge
Hockey Rink with Lights
$
115,000.00
Hawkridge
2 Sets of Soccer Goals - Regulation Size
$
8,000.00
Hawkridge
Trail Through Park
$
25,600.00
Hawkridge
6 Junior Soccer Goals
$
14,300.00
Hawkridge
(2) 3 -Row Bleachers
$
7,400.00
Hawkridge
(6) 16' Aluminum Players Benches
$
8,750.00 1
Hawkridge
5A - Langseth
Playground Structure (15 year)
$
46,000.00
Langseth
Concrete Edging w/ Wood Fiber Chip Fall Zones
$
10,500.00
1
Langseth
Asphalt Path
$
7,750.00
Langseth
6A - Lund's North
Ballfield Maintenance: Regrade, Resee'
$
5,000.00
Lund's North
Ag Lime Material -
$
1,000.00
Lund's North
260'x 8' Chain Link Fence
$
13,150.00
Lund's North
20' x 16' Chain Link Backstop Sections
$
17,500.00
Lund's North
Asphalt Trail
$
16,600.00
Lund's North
Bleacher / Dugout pads
$
34,300.00
7A - Martin's Meadows
N/A
Page 1
Replacement Priority
Park # & Park Name
Replacement
Park Name
Cost Estimate
8A - Pine Hills South
Ballfield Maintenance: Regrade, Reseed, Irrigation
$
5,000.00
Pine Hills South
Ag Lime Material
$
1,000.00
Pine Hills South
Playground Structure
$
42.000.00
Pine Hills South
430' Infield Fence with Dugouts
$
12,600.00
Pine Hills South
450' Outfield Fence with Foul Poles w/Mow Strip
$
34,300.00
Pine Hills South
Fall Zone with Concrete Sidewalk
$
10,200.00
Pine Hills South
4' Cyclone Fence -100' black vinyl coated Along Road
$
11,500.00
Pine Hills South
Concrete Mow Strips and Dugout Pads
$
19,700.00
Pine Hills South
9A - Timber River
Field Maintenance: Regrade, Reseed (Non -Irrigated)
$
4,000.00
Timber River
Walking Path - Asphalt
$
70,000.00
Timber River
Parking Lot - Paved
$
24,000.00
Timber River
Fishing Pier - Gravel
$
3,800.00
Timber River
Medium Shelter with Concrete Pad (1)
$
14,000.00
Timber River
Playground Structure
$
77,J00.00
Timber River
Concrete Edge w/Chip Fall Zone
$
21,300.00
Timber River
110' Concrete Canoe Landing
$
31,500.00
ITimber River
10A - Timber Trails
Field Maintenance: Regrade, Reseed, Irrigation
$
10,000.00
Timber Trails
Ag Lime Material
$
1,000.00
Timber Trails
Playground Structure - Medium
$
43,000.00
Timber Trails
Playground Surface w/Fiber Chips Fall Zone
$
6,250.00
Timber Trails
Paving Driveway/Trail
$
32,000.00
Timber Trails
Fencing/Concrete Work
$
109,000.00
Timber Trails
11A - Pine Hills North
Field Maintenance: Regrade, Reseed, Irrigation
$
15,000.00
Pine Hills North
Lighting Maintenance
$
3,000.00
Pine Hills North
Playground Structure
$
52,500.00
Pine Hills North
Concrete Border w/Fiber Fall Zones
$
10,500.00
Pine Hills North
330'6' Black Cyclone Fence w/Mow Strip
$
9,000.00
Pine Hills North
Set Soccer/Football Goals
$
7,400.00
Pine Hills North
Sets Full Size Soccer Goals
$
8,000.00
Pine Hills North
Fencing/Concrete Pads for Portable Restrooms
$
43,300.00 jPine
Hills North
12A - Valley View
N/A
13A - White Oaks
N/A
Page 2
Replacement Priority
Area B Replacements
Medium Priority
Low Priority
Park # & Park Name
Replacement
Cost Estimate
Park Name
19B - Birch Ridge
N/A
20B - Country Oaks
Playground Structure - Medium
Playground Surface Wood Fiber
Concrete Curbing & sidewalk
Basketball Court
Climbing Wall / Pod
$
$
$
$
$
64,000.00
6,250.00
30,000.00
8,500.00
10,900.00
Country Oaks
Country Oaks
Country Oaks
Country Oaks
ICountry Oaks
21 B - Forest Meadows
Shelter- Medium with Concrete Pad
Playground Structure
Concrete Border and Fall Zone
Sidewalk and Pedestrian Ramp
Two Stall Parking Area
$
$
$
$
$
30,000.00
48,000.00
10,500.00
13,000.00
17,300.00
Forest Meadows
Forest Meadows
Forest Meadows
Forest Meadows
Forest Meadows
23B - Oak Hollow
N/A
24B - OakView
Playground Structure
200 cu yds Engineered Wood Fiber
$
$
56,500.00
7,500.00
10akview
10akview
25B - Woodland Crossings
Playground Structure
Shelter w/concrete slab
50 x 50 Asphalt Basketball Court
$
$
$
67,500.00
32,000.00 lWoodland
20,000.00 lWoodland
Woodland Crossings
Crossings
Crossings
26B - Woodland Meadows
Playground Structure - Large
Concrete Edging Wood Fiber Surface
$
$
24,000.00 lWoodland
10,500.00
Meadows
Woodland Meadows
28B - Maple View
Playground Structure, Wood Fiber, Digger and Border $
Asphalt parking lot $
Shelter $
46,000.00
18,500.00
50,700.00
Maple View
Maple View
Maple View
Page 3
Replacement Priority
Area C Replacements
High Priority
Medium
Priority
Low Priority
Park # & Park Name
Replacement
Park Name
Cost Estimate
29C - 138th Ave
Playground Structure
$
11,000.00
1138th Ave
Fence 550' Cyclone Fence
$
12,000.00
1138th Ave
30C - Creekridge
NIA
31C - Crooked Lake Boat Landing
Sidew I)(- _..�,
$
15,400.00
CL Boat Landing
Rolling Dock 6'x 40'
$
10.100.00
CL Boat Landing
Large Shelterw/Concrete Pad & Security Light
$
114,)00.00
CL Boat Landing
Parking L
0.00
CL Boat Landing
Rain Garden
$
22,750.00
CL Boat Landing
Concrete Boat Landing
$
30,000.00
CL Boat Landing
32C - Dehn's
N/A
33C - Green Acres
Three -Section Back Stop
$
5,000.00
Green Acres
Concrete Edging w/Wood Fiber Fall Zone
$
8,300.00
Green Acres
Playground Structure
$
40,500.00
lGreen Acres
34C - Hidden Creek North
Field Maintenance: Regrade, Reseed, Irrigation
$
10,000.00
Hidden Creek North
Ag Lime Material
$
1,000.00
Hidden Creek North
Playground Structure
$
48,600.00
Hidden Creek North
Wood Chips
$
13,000.00
Hidden Creek North
128'- 6' Fence w/Mow Strip
$
13,800.00
Hidden Creek North
160'- 4' Sideline Fence w/Mow Strip
$
7,000.00
Hidden Creek North
480'- 8' Outrield Fence w/Mow Strip
$
32,300.00
Hidden Creek North
Soccer Goals - Regulation Set
$
8,000.00
Hidden Creek North
Concrete dugout pads
$
47,000.00
Hidden Creek North
Walking Trail - Asphalt
$
45,000.00
Hidden Creek North
Parkin Lot - Asphalt
$
246,000.00
Hidden Creek North
35C - Hidden Creek South
Playground Structure
$
44,000.00
Hidden Creek South
Engineered Wood Fiber
$
7,100.00
Hidden Creek South
36C - Kelsey Round Lake
380' Adjustable Bridge - Replacement
$
100,000.00
Kelsey Round Lake
Parking Lot - Asphalt (includes entrance) - Replacemen
$
220,C00.00
Kelsey Round Lake
Trail - North/South Asphalt - Replacement
$
610,000.00
Kelsey Round Lake
Page 4
Replacement Priority
Park # & Park Name
Replacement
Cost Estimate
Park Name
37C - Meadowood North
Playground Structure
Wood Fiber Fall Zone
$
$
40,000.00
8,300.00
Meadowood North
Meadowood North
38C - Meadowood South
N/A
39C - Meadows of Round Lake
Playground Structure
Woodchip Fall Zone
108' Retaining Wall
$
$
$
40,000.00
10,000.00
9,000.00
Meadows of RL
Meadows of RL
Meadows of RL
40C - Northwoods East
Ballfield Maintenance: Regrade
Ag Lime Materia
Concrete Border w/Wood Fiber Fall Zone
Playground Structure
60 linear ft op Far.—
12 Space Asphalt Parkin Lot w/Concrete C
$
$
000.00
0.00
8,300.00
30,800.00
00.00
No
North
Northwoods East
Northwoods East
Northwoods E
41C - Northwoods West
Field Maintenance: Regrade & Reseed
225'- 5' Cyclone Fence w/Mow Strip
$
$
5,000.00
9,000.00
Northwoods West
Northwoods West
Tennis ou Pavement with Fen
12,000.00
No
42C - Pleasant Oaks
Concrete EdgingwNVoo F', �I�ZO„r!@-
Playground Structure
420' Cyclone Fence with 12' Gate with Mow Strip
$
00.00
50,000.00 I
27,000.00
Plea _ Oaks -
Pleasant Oaks
Pleasant Oaks
43C - River Trails
N/A
44C- Rose
Ballfield Maintenance: Regrade, Reseed, Irrigation
Ag Lime Material
Shelter with Concrete Pad - Large
Playground Structure
150 cu yds Engineered Wood Fiber
New Ballfield Fencing w/ Mow Strips
Asphalt Parking Lot
$•
$
$
$
$
$
$
0
2,000.00
25,000.00
30,000.00
5,500.00
160,000.00
225,000.00
Rose
Rose
Rose
Rose
Rose
Rose
Rose All
45C - Round Lake Boat Landing
Parking Lot Repairs (Class V Gravel)
$
1,000.00
Round Lake B.L.
Page 5
Replacement Priority
Park # & Park Name
Replacement
Park Name
Cost Estimate
46C - Strootman
Ballfield Maintenance: Regrade & Reseed
$ 5,000.0
Ag Lime Material
$ 1,000.00
Shelter
$ 18,000.00
Strootman
Playground Structure
$ 44,100.00
Strootman
Ballfield Fencing
$ 34,200.00
Strootman
47C - Terrace
Ballfield Maintenance: Regrade, Reseed, Irrigation
$ 5,000.00
Terrace
Ag Lime Material
$ 1,D00.00
Terrace
Sandbox w/Concrete Walk and Retaining Wall
$ 9,D00.00
Terrace
ADA Pads to Powerscape Units
$ 14,400.00
Terrace
Playground Structure
$ 44,100.00
Terrace
WalkingTrail- Asphalt
$ 40,300.00
Terrace
Parking Lot 27 Spaces
$ 248,300.00
Terrace
Fencing with Mow Strip
$ 43,300.00
ITerrace
48C - Wild Iris
Ballfield Maintenance: Regrade & Reseed
$ 5,000.00
Wild Iris
Ag Lime Material
$ 1,000.00
Wild Iris
Playground Structure - 5-12
$ 41,000.00
Wild Iris
Playground Structure - Playsense - 2 to 5
$ 33,000.00
Wild Iris
Wood Chip Fall Zone
$ 13,800.00
Wild Iris
Six Section Backstop w/ Dugouts Cement
$ 25,800.00
Wild Iris
124' Six foot Fence w/ mow strip
$ 8,000.00
Wild Iris
364' Eight foot Outfield Fence w/ Mow Strip
$ 14,600.00
Wild Iris
Basketball Pad Asphalt
$ 11,100.00
Wild Iris
Sixty (60) Place Asphalt Parking Lot w/Curb
Walking Path - Asphalt Expanded
49C - Crooked Lake Warming House & Rink Facility
Eggift,fWaftevAi$
1,000.00
CroaRommmmmopm
New Hockey Rink
$ 75,000.00
Crooked Lake Hockey
Rink Lights
$ 73,000.00
Crooked Lake Hockey
Page 6
Replacement Priority
Area D Replacements
High P
Medium
Priority
Low Priority
Park # & Park Name
Replacement
Park Name
Cost Estimate
59D - Andover Lions
Bellfield Maintenance: Regrade, Reseed. Irrigation
$
5,000.00
Andover Lions
Ag Lime Material
$
1,000.00
Andover Lions
Set of 3 Outdoor Exercise Equipment
$
10,700.00
Andover Lions
Playground Structure
$
67,300.00
Andover Lions
280' Cyclone Fence with Mow Strip
$
16,300.00
Andover Lions
30 Space Asphalt Parking Lot w/Curbs
$
76,300.00
Andover Lions
Backstop Fence, Mow Strips, Dugouts, Bleacher Pads
$
92,700.00
Andover Lions
60D - Andover Station North
Ballfield Maintenance: Regrade, Reseed, Irrigation
$
15,000.00
ASN
Facility Maintenance
$
5,000.00
ASN
Lighting: Maintenance ( 2 Fields and Sliding Hill)
$
3,000.00
ASN
Ag Lime Material
$
3,000.00
ASN
Tilted Sky Wheel
$
7,300.00
ASN
280 cu yds engineered wood fiber
$
11,250.00
ASN
Playground Structure
$
111,000.00
ASN
Fence around playground
$
25,000.00
ASN
Batting Cage Set
$
7,200.00
ASN
Scoreboards (set of 3)
$
32,000.00
ASN
12'x 12' Irrigation Shed
$
32,000.00
ASN
Parking Lot - Replacement
$
350,000.00
JASN
62D - Chesterton Commons
Playground Structure
$
63,500.00
Chesterton Co
Walking Path - Paved
.1000.00
Chesterton Co
63D - City Campus Outdoor Hockey Complex
Facility Maintenance
$
5,000.00
City Campus Hockey
Lighting Maintenance
$
2,000.00
City Campus Hockey
Parking Lot Class V - Add material as needed
$
5,000.00
City Campus Hockey
2 Hockey Rinks wIFencing and 4 Light Poles - Replacer $
110,000.00
City Campus Hockey
64D - City Hall Complex #1/Purple
Field Maintenance: Regrade, Reseed, Irrigation
$
10,000.00
City Campus #1/Purple
Ag Lime Material
$
1,000.00
City Campus #1/Purple
Fencing around Ball Field - Repair
$
1,564.00
City Campus #11 /Purple
Playground Structure -1 Large*
$
100,000.00
City Campus #1/Purple
Sandbox w/ Digger
$
5,000.00
City Campus #1/Purple
340' Cyclone Fence by Soccer Field #2
$
12,600.00
City Campus #1/Purple
Fencing around Ball Field - Replacement
$
10,900.00
City Campus #1/Purple
2 Shelters - Large
$
124,000.00
City Campus #1/Purple
North Parking Lot
$
93,000.00
City Campus #1/Purple
Blacktop Trails
$
25,000.00
City Campus#1/Purple
Page 7
Replacement Priority
Park # & Park Name
Replacement
Park Name
Cost Estimate
65D - Coon Creek/Tom Anderson Trail
N/A
66D - Creekview Crossing
Playground Structure
$
49,000.00
Creekview Crossing
180 cu yds Engineered Wood Fiber
$
7,500.00
Creekview Crossing
Small Shelter w/ Picnic Table
$
10,000.00
I Creekview Crossing
67D - Eveland Fields
Field Maintenance: Regrade, Reseed, Irrigation
$
15,000.00
Eveland Fields
Ag Lime Material
$
3,000.00
Eveland Fields
380'- 8' Fence along property line
$
10,200.00
Eveland Fields
900'- 6' Fence along property line
$
20,300.00
Eveland Fields
300'- 4' ballfield fence w/ mow strips
$
15, )00.00
Eveland Fields
384'- 6' ballfield fence w/ mow strips
$
28,300.00
Eveland Fields
1,146'- 8' ballfield fence w/ mow strips - All Fields
$
63,000.00
Eveland Fields
Backstop Six Section
$
32,000.00
Eveland Fields
Batting Cage 2 Place
$
6,700.00
Eveland Fields
Scoreboard Electronic
$
17,000.00
Eveland Fields
Concrete Pad for Bleacher/Dugouts
$
140,000.00
Eveland Fields
Benches & Message Board
$
26,000.00
Eveland Fields
Parking Lot 35 Spaces
$
230,000.00
Eveland Fields
Concrete Block Dugouts - South Field
$
90,000.00
Eveland Fields
68D - Hartfiel's
N/A
69D - Hickory Meadows
Playground Structure
$
47,000.00
Hickory Meadows
Concrete Enclosure w/block Retaining Wall
$
33,000.00
Hickory Meadows
70D - Hidden Creek East
Playground Structure
$
64,000.00
Hidden Creek East
11 Place Asphalt Parking Lot w/Cement Curb
$
97,000.00
Hidden Creek East
190' asphalt Trail
$
17,000.00
Hidden Creek East
Concrete Pad w/Handball Wall
$
59,000.00
Hidden Creek East
71 D - Hills of Bunker West
Ballfield Maintenance: Regrade & Reseed
$
5,000.00
Hills of Bunker West
Ag Lime Material
$
1,000.00
Hills of Bunker West
Playground Structure
$
52,000.00
Hills of Bunker West
Walking Path - Asphalt
$
78,500.00
Hills of Bunker West
Concrete Sidewalk Border w/Wood Chips
$
8,200.00
Hills of Bunker West
Fencing Backstop, Dugouts, Sidelines w/Concrete Mow
$
29,000.00
Hills of Bunker West
72D - Landlocked
N/A
73D - Moores Estates
N/A
Page 8
Replacement Priority
Park # & Park Name
Replacement
Park Name
Cost
Estimate
74D - Nordeen's
Playground Structure
$
46,000.00
Nordeen's
Skating Rink Repairs - Grading
$
8,000.00
Nordeen's
1/2 Basketball Court
$
17,000.00
Nordeen's
75D - Oak Bluff
Field Maintenance: Regrade, Reseed, Irrigation
$
5,560W
Oak Bluff
Playground Structure
$
40,300.00
Oak Bluff
160 cu yds Engineered Wood Fiber
$
5,500.00
Oak Bluff
18 Space Asphalt Parking Lot
$
82,300.00
Oak Bluff
76D - Prairie Knoll
Field Maintenance: Regrade, Reseed, Irrigation
$
15,000.00
Prairie Knoll
Building Maintenance
$
5,000.00
Prairie Knoll
Lighting Maintenance
$
3,000.00
Prairie Knoll
Playground Structure
$
45,000.00
Prairie Knoll
Concrete Sidewalk Border w/woodchips
$
7,900.00
Prairie Knoll
Landscape Wall around Park Sign
$
10,000.00
Prairie Knoll
8'x 110' Chain link fence
$
11,500.00
Prairie Knoll
Scoreboards Electronic
$
53,000.00
Prairie Knoll
2 sets of 5 -row aluminum bleachers
$
35,000.00
Prairie Knoll
Asphalt Base Hockey Rink & Fencing & Hockey Boards
$
35,000.00
Prairie Knoll
Walking Path - Asphalt
$
18,000.00
Prairie Knoll
Sliding Hill Repairs and Improve Wildlife Pond
$
5,000.00
Prairie Knoll
Shelter (wood frame, concrete pad) - Replacement
$
37,000.00
Prairie Knoll
Parking Lots Asphalt
$
600,000.00
jPrairie Knoll
77D - Red Oaks East
NIA
78D - Red Oaks West
Playground Structure
$
35,000.00
Red Oaks West
Basketball Pad
$
15,000.00
Red Oaks West
Walking Path - Asphalt
$
42,000.00
Red Oaks West
79D - Redwood
N/A
80D - Shadowbrook East
Ballfield Maintenance: Regrade, Reseed, Irrigation
$
10,000.00
Shadowbrook East
Ag Lime Material
$
2,000.00
Shadowbrook East
6 Section Backstop w/Overhang
$
35,000.00
Shadowbrook East
248'- 6' Cyclone Fence Dugout w/Concrete Pad/Mow S
$
15,000.00
Shadowbrook East
208'- 4' Cyclone Sideline Fence w/Mow Strip
$
9,000.00
Shadowbrook East
802'- 8' Cyclone Outfield Fence w/Mow Strip
$
30,000.00
Shadowbrook East
Concrete Pad for Bleacher/Dugouts
$
37,000.00
Shadowbrook East
Park Sign w/Landscaping Keystone wall
$
10,000.00
Shadowbrook East
Playground Structure, Wood Chips and Border
$
89,000.00
Shadowbrook East
Aluminum Bleachers 5 Row
$
35,000.00
Shadowbrook East
51 Space Asphalt Parking Lot w/Cement Curb
$
220,000.00
Shadowbrook East
Basketball Pad
$
13,000.00 IShadowbrook
East
Page 9
Replacement Priority
Park # & Park Name
Replacement
Park Name
Cost Estimate
81D - Shadowbrook West
N/A
82D - Shady Knoll
Playground Structure
$
46,250.00
Shady Knoll
Hard Court - Basketball
$
20,500.00
Shady Knoll
83D - Sophie's
Playground Structure, Sandbox w/ Digger
$
96,700.00
Sophie's
20'x 20' Shelter w/Concrete
$
67,700.00
Sophie's
84D - Sunshine
Ballfield Maintenance: Regrade, Reseed, Irrigation
$
45,700.00
Sunshine
Facility Maintenance
$
5,700.00
Sunshine
Ag Lime Material
$
6,700.00
Sunshine
Lighting Maintenance
$
8,700.00
Sunshine
Playground Structure (Medium Size Structure)
$
46,300.00
Sunshine
Rock Walls
$
7,300.00
Sunshine
Park Name Sign
$
20,000.00
Sunshine
Asphalt Parking Lot - Large
$
280,000.00
Sunshine
Asphalt Parking Lot - Small
$
65,000.00
Sunshine
Asphalt Parking Lot w/Curb - 51 Spaces
$
335,000.00
Sunshine
4 Bleachers - Aluminum - Small
$
85,000.00
Sunshine
4 Flag Poles
$
27,000.00
Sunshine
Large Aluminum Bleacher
$
198,000.00
Sunshine
Basketball Court
$
15,000.00
Sunshine
Sand Volleyball Court
$
17,000.00
Sunshine
Scoreboards
$
120,000.00
Sunshine
Skate Board Park
$
120,000.00
Sunshine
Shelter, Hexagonal - Skate Park
$
50,000.00
Sunshine
North Parking Lot Lights
$
97,000.00
Sunshine
West Parking Lot Lights
$
70,000.00
Sunshine
Dugout shelters
$
96,000.00
Sunshine
2,290' Cyclone Outfield Fence -10' High, two 10' Gates,
$
79,000.00
Sunshine
210'5' Cyclone Fence with Mow Strip
$
25,000.00
Sunshine
220' Infield Fence with Dugout and Concrete Pad
$
62,000.00
Sunshine
350' Cyclone Outfield Fence -10' with Foul Poles
$
28,000.00
Sunshine
Walking Path - Asphalt
$
63,000.00
Sunshine
Shelter/Gazebo
$
1,200,000.00 ISunshine
85D - The Oaks
86D - Woodland Estates
Irrigation System Maintenance
$
1,000.00
Woodland Estates
Playground Structure
$
26,200.00 lWoodland
Estates
Page 10
onmlon
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 Administrat
David D. Berkowitz, Director of P i Works/City Engineer L
Park and Recreation Commission
From: Todd J. Haas, Assistant Public Works Director
Subject: 2E. Discuss Responses Received from Associations Regarding Future
Storage Needs
Date: August 28, 2018
INTRODUCTION
The City Council is requested to discuss responses received from the associations
regarding future storage needs.
DISCUSSION
Based on discussion between the City Council and Park and Recreation Commission in
April 2017, it was requested to contact the associations about future storage needs. The
associations had about a year to submit. The deadline date for submittal was March 30,
2018. Now that the deadline has past, it is time to review the following responses that
were received by the associations:
• Andover Huskies Youth Hockey Association (AHYHA) - Has indicated that no
additional storage is needed.
• Andover Baseball Association (ABA) - Has indicated that no additional storage
is needed.
• Andover Football Association (AFA) — Has indicated they will need short and
long term needs for their program. They also have some thoughts to resolve AFA
needs. Refer to the attached e-mail.
• Andover Athletic Association (AAA) — Originally AAA had indicated that they
do not have short term needs. But now that AAA has received approval from the
City Council to make modifications to Sunshine Park building, that improvement
is adequate for now, so they can store their tractor and other equipment. Note:
AAA will work with other associations (for example football) so they can store
items in the garage during the fall season since the Andover Football Association
practice and play games at Sunshine Park.
• North Metro Soccer Association (NMSA) — Has indicated that they would like
additional storage space. Refer to the attached e-mail. As of right now NMSA
store items at Prairie Knoll Park building but has limited space. Note: NMSA
recently received approval of a 10 ft x l Oft shed at Pine Hills North Facility which
will generally be used for flags and other gear for practices and games. This new
shed will not be large enough to store all the equipment that NMSA owns.
Mayor and Council Members
August 28, 2018
Page 2 of 2
Andover Area Lacrosse Association (AAL A) - Has indicated that in the short
term that the space in Sunshine Park (2nd floor of the main building) works for
them. Long term needs as identified on the attached e-mail would be for an 8 ft x
12 ft (up to 14 ft) garage space to provide storage for the bigger items like nets.
The storage needs request was prompted due to the existing POD at Sunshine Park and
PODS that are not allowed in that Zoning District. Sunshine Park is zoned General
Recreational (GR). Attached is a copy of the April 25, 2017 City Council meeting
minutes along with agenda item for your review.
ACTION REQUESTED
The Park and Recreation Commission is requested to discuss responses received from the
associations regarding future storage needs.
Respectfully submitted,
Todd J. Haas
Attachment: Responses from AHYHA, ABA, AFA, AtA.A, NMSA, and AALA; April 25,
2017 City Council meeting minutes and agenda item✓
R.1Jd�}}kkMteS UU-4k itdcr� ftdmioWon
Todd Haas
From: Jeremy Coe <jeremy.coe@ahyha.com>
Sent: Monday, March 19, 2018 8:34 AM
To: Todd Haas
Subject: RE: Future Storage Needs Reminder
Hello Todd,
The hockey association discussed our storage needs at the rink to the consultant/designer of the potential new
multipurpose arena last month at our meeting with them. Otherwise, we will continue to use the space given to us at
the current arena and pay monthly for a couple of off-site storage areas that we need to manage for the states required
gambling housing of old pull tabs, etc.
Thank you for the reminder, but we are not requesting any additional off-site storage for the hockey association.
Jeremy Coe
President
Andover Huskies Youth Hockey Association
-----Original Message -----
From: Todd Haas [mailto:T.Haas@andovermn.gov]
Sent: Monday, March 19, 2018 8:04 AM
To: 'bed o ragency@ comcast. net' <bedoragency@comcast.net>; Dan Thinnes
(dt2329@icloud.com) <dt2329@icloud.com>; Strasser, Jason
(jason.strasser@minco.com) <jason.strasser@minco.com>;'pmurnane.aba@gmail.com' <pmurnane.aba@gmail.com>;
David Tarleton <president@ northmetrosoccer.org>; 'Jeremy Coe' (jeremy.coe@ahyha.com) <jeremy.coe@ahyha.com>
Subject: RE: Future Storage Needs Reminder
Importance: High
3/19/18
Last reminder before the March 30th deadline.
If have not submitted your future storage needs as of yet, please do so by the deadline. If you do not respond, the City
assumes that your storage needs have been met or you are not looking for future storage needs.
The Park and Recreation Commission will be evaluating the storage needs that have been submitted at their meeting on
Thursday,April19th.— "-Y''"
If you have any questions, feel free to contact me at 763-767-5131.
Thanks.
Todd
---Original Message ----
From: Todd Haas
Sent: Friday, January 12, 2018 9:16 AM
To: 'bedoragency@com cast. net' <bedorage ncy@comcast.net>; Dan Thinnes
(dt2329@icloud.com) <dt2329@icloud.com>; Strasser, Jason
Rnborer _�«seball 1�ss�rafi'art
Todd Haas
From: Patti Murnane <pmurnane.aba@gmail.com>
Sent: Thursday, May 18, 2017 4:28 PM
To: Todd Haas
Cc: Brad Geiss; Steven Williams; bedoragency@comcast.net; 'Jeremy Coe'
(eremy.coe@ahyha.com); Strasser, Jason Qason.strasser@minco.com); David Tarleton;
Antoine Ziegler, Dan Thinnes (dt2329@icloud.com)
Subject: Re: FW: Storage Needs
At the present time Andover Baseball has already contructed the building at ASN and has no plans for future
construction of another building.
On May 18, 2017 3:16 PM, "Todd Haas" <T.Haas@andovermn.gov> wrote:
See attachment.
Todd Haas
City of Andover
��✓ F�ot(oaN /}g�cwtion
Todd Haas
From: Strasser, Jason <jason.strasser@minco.com>
Sent: Friday, March 30, 2018 5:01 PM
To: Todd Haas
Subject: AFA Storage Needs
Good Afternoon;
Andover Football is not planning a large growth in participation numbers. We are also not seeing the decline in football
players like the other surrounding communities.
Andover Football storages needs are the following:
Current:
AFA currently stores equipment at Prairie Knoll Park—year around
AFA currently stores equipment in a 10x16 Trailer—year around
AFA currently rents two storage garages to store—year around
AFA uses the POD at Sunshine for Field Carts during the season
Short Term:
AFA could use an additional space at Prairie Knoll Park to store equipment.
AFA could use a second field box at Sunshine to store Field items.
AFA could use a storage unit near the or inside the building at Sunshine Park for field items.
Long Term:
AFA may need a climate controlled building to store helmets. This requirement is still unknown.
Additional storage space for the trailer and eliminate the storages garages.
Thoughts to resolve AFA needs:
-Add a second level to the building at Prairie Knoll
-Construct a 20x30 Garage type building (needs security and protection from elements)
-Changes to Sunshine Facilities - adding a field box and changes or additional of a field box by the building will resolve
AFA needs
Thanks
Jason Strasser
AFA President
763.528.8907
Jason Strasser I Sales Operations and Channel Manager I Minco Products
7300 Commerce Lane I Minneapolis, MN 55432
Tel: 763.586.2877 1 Mob: 763.528.8907 1iason.strasser@minco.com
� NOrcr�i
vv'�r�Fud ns8tl.� rtau� � tr�r r�ru�c� f�?xs��kars�r�a st,i�*q� G+��r�,�
AY►Javer A04e4ic, 1ssauaTvm%i
Todd Haas
From:
Strasser, Jason <jason.strasser@minco.com>
Sent:
Friday, March 30, 2018 5:13 PM
To:
Todd Haas
Subject:
Andover Athletic Association
Good Afternoon;
Andover Athletic Association programs continue to grow:
Andover Fastpitch —All time high
Andover Track and Field —All time high
Andover Boys Basketball —All time high
Andover Slowpitch —Sustaining
Andover Girls Basketball —Sustaining
Andover Girls Volleyball growing
Andover Cross Country— New
Andover Boys Volleyball — New
Current:
AAA currently stores equipment at City Hall Storage —year around
AAA currently stores equipment Sunshine building upstairs—year around
AAA currently store field tractor, dragging equipment, and chalk at the POD at Sunshine. — year around
AAA currently stores equipment at High School
Short Term:
No needs
Long Term to resolve the need to remove the POD:
AAA needs a place to store the store field tractor, dragging equipment, and chalk.
Thoughts to resolve AAA needs:
-Add a Shed near the building at Sunshine part to store the needed equipment. 16x20.
-Changes to Sunshine Facilities - adding an overhead door to gain access to the lower space to store the field tractor,
dragging equipment, and chalk inside the building at Sunshine.
Thanks
Jason Strasser
AAA Softball Director
763.528.8907
Jason Strasser I Sales Operations and Channel Manager I Minco Products
7300 Commerce Lane I Minneapolis, MN 55432
Tel: 763.586.2877 1 Mob: 763.528.8907 1 iason.strasserCC)minco.com
fi I MING. t
S3°b'T�1 tii�rF�rt$Tet'.ii3 4"X}'IFFtd�R�ESttf�i3C�r*£k,45fftE38}R:Cf'i44�i3 :�1767A�::Fm.*4:�5.
Nor+& 1AAe1wfo .Szccer A-ssxeztK*,
March 30, 2018
Dear Mr Todd Haas,
North Metro would like to express our interest in additional storage space. Currently we have
approximately 450 square feet at Prairie Knoll. In addition to the space at Prairie Knoll we have
items stored at the homes of various board members.
Below is a list of the attributes of our preferred space.
900 - 1200 square feet of secure space located at Pine Hills North or Hawkridge
• Electricity and lighting
• Heated and insulated (space heated to 40 degrees during the winter months)
o Garage door for ease of access.
We would be willing to relinquish the space we have at Prairie Knoll to football or another
activity should we obtain the new space. We are also prepared to make a donation to the City
of Andover to help in the development and building of this space.
Should you have any questions please feel free to contact me at 612-424-0474.
Sincerely,
David Tarleton
President
North Metro Soccer Association
PO Box 99
Andover MN 55304
kpoWer lrawL 1..msroz a Assoe rct+r,a
Todd Haas
From:
Dan Thinnes <dt2329@icloud.com>
Sent:
Friday, March 30, 2018 10:51 AM
To:
Todd Haas
Subject:
Re: Future Storage Needs Reminder
Importance: High
Todd
Short term storage needs for Andover Area Lacrosse Association are currently being met with building space at Sunshine
(room on the 2nd floor of main building).
Long term needs (requests) would be for an 8x12' (up to 14') garage space - similar to the ones at Prairie Knoll. This
would be helpful for storage of our goals/nets to be out of the elements during the offseason and out of the snow -
which does the most damage to the nets.
Other long term storage needs may simply depend on the ability for our association to keep the space at Sunshine, but if
that were compromised, would be some indoor space to store such items as unused paint or other similar items which
would be affected by below freezing temperatures. This space size could be as small as 4'x 6'.
Please let me know if there is anything else that you may require.
Thank you.
Dan Thinnes
President - Andover Area Lacrosse Association
PO Box 48062, Coon Rapids, MN 55448
763-413-2930
dt2329a,icloud.com
On Jan 12, 2018, at 9:16 AM, Todd Haas <T.Haas@andovermn.eov> wrote:
1/12/18
Just as a reminder, a response is needed regarding future storage needs by Friday, March 30, 2018. If
you have not discussed this with your Association Board as of yet, we would recommend you do that
asap and let us know what your plans are for storage needs by the deadline date. If the City does not
back from you, we assume that your association has adequate storage needs.
Attached is a letter that was sent to the associations back in May 2017.
Note: The only association that has responded back to the City so far is the Andover Baseball
Association.
If you have any questions, feel free to contact me at 763-767-5131.
Andover City Council Workshop Meeting
Minutes—April 25, 2017
Page 6
a form of a deed restriction. City Attorney Baumgartner stated an easement is an interest in
property, a deed restriction is only as good as whoever holds that deed, that is the problem he has
with it. Mr. Dickinson stated they need to look at what the County recorder will accept. For the
most part Counties will not record those things unless it is signed off by the municipalities and
that is really where the City wants to get to. City Attorney Baumgartner stated that is what he
wants to see.
Mayor Trude asked when the City went to the Met Council and asked to move down this path,
what was on their list that the City had to do. Mr. Janish stated it is a deed restriction of some
manner to prevent the density and preserve that future development possibility.
Mr. Packer stated they do not necessarily want the easement, if there is another way to do it that
would be the way they would want to go but if it ends up that it is the only way to get it done
then they may need to go along with it. He asked for a status update on the Comprehensive Plan
amendment. Mr. Janish stated he has not heard from the Met Council yet. He reviewed the
process with Mr. Packer and the Council.
Mr. Packer stated they are looking to move forward with building as soon as possible. Staff
reviewed a possible timeline of actions that need to occur before building can happen. Mr.
Dickinson stated they need to figure out Item K in the staff report that talks about blanket
easements on the property.
Councilmember Goodrich stated he did not want to hold the Packers back from building if the
only issue is Item K. Mr. Dickinson stated he would talk to the Packers and help them to work
out a timeframe to build.
* DISCUSS STORAGE UNITS (PODS) IN CITYPAR%S & RESIDENTIAL DISTRICTS
Mr. Berkowitz explained the City Council is requested to discuss portable storage containers,
often referred to as PODS, in City parks and residential districts.
Mr. Berkowitz reviewed the staff report.
Mr. Berkowitz asked if the Council supported permanent PODS in the City. Council consensus
was not to allow them.
Mr. Berkowitz asked if the City Council supported a timeframe for the athletic associations to
get rid of their current PODS. Councilmember Holthus understood why they need them. Mr.
Berkowitz stated staff discussed giving them three to five years to get rid of the PODS. Mayor
Trude disagreed and stated five years was a long time for them to find alternative storage. She
thought a shed looked better than PODS. Mr. Berkowitz stated it is up to the Council to decide
what a reasonable timeframe is for the associations to raise funds to build a structure for storage.
Councilmember Bukkila stated her issue is the burden on one association for multiple structures.
Andover City Council Workshop Meeting
Minutes—April 25, 2017
Page 7
If it was only one park and one organization she would agree to three years but if one
organization had something in two or more parks then she would be more sympathetic to a
longer timeframe to plan out multiple structures.
Mr. Berkowitz reviewed where the PODS are located at. He noted the Andover Baseball
Association wants to move a POD from the high school to Sunshine Park and thought the City
Council would not be in favor of that. The Council agreed. Mr. Berkowitz stated the Andover
Football Association has one at Prairie Knoll Park during the season. He stated they could have
multiple associations put their resources together and build one structure at the parks.
Councilmember Holthus thought the associations need to clean out the buildings and see what
their needs are. Mr. Berkowitz stated they would need to have a structure at each park to house
the equipment needed for that park so he thought the Council should give them enough time to
figure out what their full needs are and how they can do it efficiently so they can raise money,
design and build a structure so it works for them for a long time.
Councilmember Bukkila thought the associations should be given twelve months to make a plan
and tell the Council what they would like to see before a decision is made by the Council. She
stated she wanted the associations to react and not put it off.
Councilmember Knight asked if some of the items being stored at the parks was City owned.
Mr. Berkowitz stated the associations are now buying their own equipment to use at the parks so
the City does not have any equipment that is stored. Mayor Trude stated that takes a big load off
of the City, she wondered if there was a way to find a way to build some little sheds with money
from their reserves to store equipment so the parks look better. Mr. Berkowitz stated he would
need to go to the Park and Recreation Commission to see how they would weigh in on a
recommendation for that.
Councilmember Goodrich asked if they could screen the PODS with some sort of nice fencing so
they cannot be seen. Mayor Trude stated she liked that idea.
Councilmember Bukkila stated she is not ready to put a drop -dead date on this, she would like to
get some feedback from the associations on what they propose. Councilmember Holthus
suggested staff go look at the buildings and see what the associations have in them to see how
space can be better utilized.
Mr. Berkowitz asked if there was support for the associations to come back after twelve months
with a storage plan. Council agreed.
Mayor Trude suggested staff work with the associations on getting a plan together.
Mr. Berkowitz asked if the Council was in favor of using park dedication money to fund the
storage. Mayor Trude stated she is in favor of doing this. The rest of the Council is against.
Andover City Council Workshop Meeting
Minutes—April 25, 2017
Page 8
The Council is not in favor of permanent PODS in residential use. The Council is in favor of
temporary PODS in residential use. Councilmember Bukkila stated she would be in favor of
temporary storage if there is an open construction permit. Mr. Dickinson noted construction
permits could be open for years. Councilmember Goodrich asked what other cities do. Mr.
Dickinson stated most do not allow them at all or for only ninety days. Mayor Trude thought
they should start with ninety days. Mr. Berkowitz stated if allowed there would need to be an
ordinance change because they currently do not allow anything like that in the City. He stated
staff will work on language change and bring it back for Council review. Councilmember
Bukkila stated there needed to be some language stipulating ninety days in total so it does not
disappear for one day and then come back again for another ninety days.
Mr. Berkowitz noted there are not any restrictions on five acres or more. The majority of the
Council did not have an issue with that. Mayor Trude is not sure if she wanted that because then
the property owner can have as many of them as they want and then it starts to look bad. Mr.
Janish thought there needed to be some type of screening on those sites. Mayor Trude stated she
did not support allowing them on five acres or more.
CLOC%TOWER COMMONSAMENDMENT
Mr. Janish stated this is in regard to the Clocktower Commons PUD amendment. He passed out
a building design and stated the new building they are proposing is mostly rock face block and
he is requesting the Council review the building fagade and indicate any changes that should be
made to the building. Mr. Dickinson stated according to the PUD all the buildings need to look
alike in appearance.
The City Council thought the new building fagade looked better than some of the existing
buildings. They thought maybe there could be the same style of roofing or closer looking brick
to the color in the design of the existing buildings.
2018 BUDGETDEVELOPMENTDISCUSSION
Mr. Dickinson reviewed the staff report.
2017 B UDGET PROGRESS REPORTS
Mr. Dickinson reviewed the staff report.
2017 CITYINVESTMENTSREVIEW
Mr. Dickinson reviewed the staff report.
iC I T Y •
LNDOVE
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 Administrat
David D. Berkowitz, Director of bli Works/City Engineer`s
Park and Recreation Commission
From: Todd J. Haas, Assistant Public Works Director
Subject: 2F. Discuss Fee for Use of Fields by Groups/Organizations/Associations
Date: August 28, 2018
INTRODUCTION
The City Council is to consider the idea of having a fee established for use of fields as requested
by the Park and Recreation Commission.
The Park and Recreation Commission earlier this summer discussed the idea of establishing a fee
for the use of the facilities by groups, organizations and/or associations. Below is a list of Cities
that were researched by staff to determine if they have a fee established a fee or not.
• City of Anoka - Does not charge a fee for youth unless they want the fields chalked or
painted or want to use lights for certain fields.
• City of Blaine — Blaine charges a $10 per participant per season athletic facility usage
fee for Blaine youth athletic associations.
• City of Champlin -- Champlin charges a $18 per resident participation per season for an
athletic facility usage fee and $43 per non-resident participation per season.
• City of Coon Rapids — The associations pay $25 per field for tournaments but nothing
else. Their staff is going to propose a per participant fee this fall (they can't keep up with
demands).
• City of Maple Grove — They do not charge a fee to youth organizations for fields.
• City of Oak Grove — Per website and conversing with their staff there is no fee for use of
fields.
• City of Ramsey — The associations pay a weekly maintenance fee depending on the type
and size of field it is.
• City of Roseville — They do not charge a fee, but they do for tournaments.
• City of St. Francis - The associations pay a weekly maintenance fee depending on the
type of field it is.
If a fee were to be collected, the Commission is recommending that fee will only be used only
towards maintenance of the fields/facilities.
ACTION REQUESTED
The City Council is requested to determine if there is interest in establishing a fee for the use of
fields.
Respectfully submitted,
-Ael4vPA-�
Todd J. Haas
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Council Members
CC: Jim Dickinson, City Administrator
FROM: David D. Berkowitz, Director of Public Works/City Engineer
0
SUBJECT: Discuss Remote Control Dirt Track/Median of Eagle Street NW - Engineering
DATE: August 28, 2018
INTRODUCTION
Resident Brandon Dobratz (15950 Eagle Street) has provided staff with a proposal to convert the island
median on Eagle Street to a radio -controlled dirt race track.
DISCUSSION
Mr. Dobratz will be at the meeting to present his idea to the City Council. Attached is a location map,
dirt track proposal, current pictures of the median, Declaration and Convents for Association
maintenance requirements for the median and the approved landscape plan.
BUDGETIMPACT
As currently exist the City is not responsible for any maintenance of the median nor would be if the use
would change.
ACTION REQUESTED
The City Council is requested to review the request and provide direction to Mr. Dobratz on how to
proceed.
Respectfully submitted,
David D. Berkowitz, P.E.
Attach: Location Map, Radio Controlled Vehicle.Dirt Track Proposal, Current Pictures of Median,
Declaration and Convents for Median Maintenance & Original Landscape Plan's
AN_1,�OVER Location Map
Propo Sed ►T ,'4 I ✓AL (C
Date Created: August 22, 2018
Disclaimer: The provider makes no representation or warranties with respect to the reuse of this data.
05/18/2018
DRNNES
PRESENTED BY: BRANDON DOBRATZ
NORDIC DRONES LLC
15950 EAGLE STREET NW ANDOVER MN 55304
PROJECT COMMUNICATION PLAN
PROJECT COMMUNICATION DOCUMENTS
191A31:149414IJJWM011Rh_\IM01ar911111:
Document
Get support of the local city Brandon Dobrat
council
Confidential
z Work with them to 763-218-8999
do everything the
way they want it
Reach out to other
RC Groups/Familys
in the area and
make sure they
would be willing to
help with keeping it
Attend council meetings and speak', Brandon Dobratz
on behalf of the RC Community
and the Andover Community
Get the permits we need Brandon Dobrat
Drivers Stand
Brandon Dobrat
protected from
vandalism
z Work with the city
and hire a
contractor to clear
the area
z This Plan will need
to be approved by
looking great.
An agreement between Nordic Brandon Dobratz
I will hold the lease
Drones LLC. And the city to lease
and make sure it is
and maintain the area in front of
kept up Also I own a
15950 eagle street nw, Andover
Security Distributor
MN 55304 as a free Community
and will work with
RC (radio controlled vehicles)
dealers to make sure
needs to be reached
that the area is
Get the permits we need Brandon Dobrat
Drivers Stand
Brandon Dobrat
protected from
vandalism
z Work with the city
and hire a
contractor to clear
the area
z This Plan will need
to be approved by
the city and also the
materials will need
to procured.
Work with the community
Brandon Dobratz Get Volunteers
Facebook/The
City/local
stores/Business
owners
Make sure we can dig talk to the
Brandon Dobratz Easy to do with
city have 811 come out and
approval
approve us putting drains for the
track
Date
Project Communication Plan 1
Document
Concrete Slab with Handicap Brandon Dobratz
Access
Layout of the track/ Make it look Brandon Dobratz
good the area right now is an
eyesore it should be fenced and
lighted. Hours should be from
10:00 am to 8pm after that will
need to pull a permit for special
events. Must have approval from
Nordic Drones LLC to use the
property. We need to have it
locked up I sell access control I can
release remotely.
Other things that need to be Brandon Dobratz
added outside the fence so people
can see in
GOALS
Confidential
I have a guy
This will be on me
with the city's
approval. They could
help me with this.
BBQ pit, picnic
tables if we could
get it done with help
from the community
The goal is something new and exciting for the neighborhood —Let set Andover apart
TEAM ASSIGNMENTS
Use the following table to outline the project's marketing teams, team goals, team leads, and team
roles.
The Plan — I will work on this once the City says to move forward I will get volunteers
Name of team
Team goals
Team leads
Team roles
Name 1
Goals
Lead name
Roles
Name 2
Goals
Lead name
Roles
Name 3
Goals
Lead name
Roles
Name 4
Goals
Lead name
Roles
Name 5
Goals
Lead name
Roles
TEAM ROLES AND RESPONSIBILITIES
Identify the responsibilities assigned to each of the team roles
Date Project Communication Plan 2
Confidential
RISKS AND ISSUES MANAGEMENT
POTENTIAL EXCEPTIONS AND PROBLEMS
• The big thing is making sure the community in the direct view would like to have it. I would ask
for help on this how does the city go about putting a park in peoples back yard.
APPROPRIATE CORRECTIVE MEASURES
I always think of the good things, I believe if 1 bring this to the city they will tell me the issue they think
will come up and I can work on solutions
TRACKING RISKS AND ISSUES
In the following table, track the risks and issues that you identified.
Date
Plan
Impact
recorded
Risk description
Probability
Date 1
Description
Probability
Date 2
Description
Probability
Date 3
Description
Probability
SOME INFORMATION I HAVE FOUND REGUARDING THIS TOPIC
Impact Mitigation plan
Impact
Plan
Impact
Plan
Impact
Plan
https://fastia phobby.com/blogs/news/44642756-how-a-public-rc-track-got-done-in-our-community
The Area in question
Great Information from Dan Keumwiede
The center median isn't part of his property and would be considered
City ROW. I feel like we would have to treat this the same as we would
be basketball hoops, which we have always enforced for being in the
ROW.
Date Project Communication Plan 3
1.. .. ..
Confidential
City Code 6-2-1: D. Property Other Than Vehicles: No property of any
kind or description, except motorized vehicles, together with property
lawfully attached thereto, may be parked, stored, or permitted to
stand upon any city street or right-of-way at any time, except as the
same may be permitted by resolution of the City Council.
More Great information from
David D. Berkowitz, P.E.
City of Andover
Director of Public Works/City Engineer
763-767-5133
An RC track in the center island is prohibited by City Code. If you
would like to pursue this you could go before the City Council at a
Workshop most likely in late August. I don't believe you would get
approval for this but if you would like to continue please provide a detail
drawing and a narrative of how you would propose to construct and a
long term maintenance plan. I would assume insurance would need to
be provide and you would need to take on any additional liability.
So far the city has been a huge help.
This is end result I am looking for!!!
Not this' I I I A
A
Date
Project Communication Plan
4
� �
:�
y•YW"1,:. qS.
4y �
?tom
ri
r
t�i•/
Ry
Y
1 i
Sr
� �
l
,x•:r I a
ti�
r _
Rol
}' ; :� �
��~ ya
� .2 y�
..r::��
»\\`���
««7a
� ��
� �� ? /� \ \� (\ \\
\���������
: x.. . . . .
�;� 3� y<c,� «»«»�wa ��.»::.
. : w.. »ate .y§� � � :2: : ��.<
�������\� %\�\�� \\\\/~.
,�TrVi A,
n
{
7
i P
Section 10. If any structure, building, or improvement shall be fully erected and
completed without the submission of plans, specifications or proposals as required herein, and
shall remain in existence for one year after completion without a legal or acquirable action
having been commenced by a member of the Committee or any person who has standing to bring
such an action, the structure, building, or improvement shall be permitted to remain as though the
Committee had initially approved of its construction. If such property is sold after the structure,
building, or improvement is completed, but prior to expiration of one year, and no legal or
equitable action has been commenced by service of process prior to the recording of the
conveyance transferring ownership of the property, then such structure, building, or
improvement shall be permitted to remain as though the Connnittee had irdtially approved of its
construction.
Section 11. Nothing contained in this Declaration shall be construed or require the
members of the Committee to bring an action at law or equity to enforce the provisions contained
in this Declaration.
Section 12. Maintenance and Repairs. All maintenance and repair of individual
buildings constructed on a Lot shall be the sole obligation, responsibility and expense of the
individual Owners thereof, except to the extent that repair or maintenance of the cul-de-sac
island are the responsibility of the Association. In the event that any maintenance or repair of
any part of the common improvements is necessitated by the willful or negligent acts of any
owner or his or her family, guests or invitees, the cost of all such maintenance, repairs, attorneys
fees and costs for enforcement shall be added to become part of the assessments to which the Lot
of such owner is subject. If, in the course of the Association carrying out any maintenance or
repairs for which it is responsible pursuant to this Declaration, damage is done to a Lot or the
improvements thereon, then, and in that event, the Association shall be responsible for all
damage done to the Lot and the improvements thereof and shall perform or pay for the
restoration of, and repairs to such improvements. In addition, the Association shall have the
right to enter the owners' Lot and to restore any part of the building or Lot to its prior condition.
If the alterations were made in violation of this Article, the costs of said restoration shall be the
personal obligation of the owner and a lien against the owner's Lot.
Section 13. Exterior Materials. At least 4' high along the front exterior shall have brick,
and nor stone. A minimum of 10 percent of the front exterior must be brick, stone, and/or
stucco. If side and rear exteriors are not brick, shakes, stone, or stucco, then it must be high
grade, maintenance fiee, siding material. In addition, those homes with sides facing the street
will be reviewed in greater detail, and the aforementioned requirements for front exterior may
also be required on the sides directly facing the street, final determination will be made by the
Architectural Control Committee.
Section 14. Requirements. No more than two dwelling units with the exact exterior
configuration shall be erected within any of five abutting, contiguous, successive or adjoining
lots, final determination will be made by the Architectural Control Committee.
Section 15. Roofing Requirements. The roof lines for all homes must have a minimum
Page 12 of 23
tC I T Y ,, Rk�:
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 Administrato
FROM: David D. Berkowitz, Director of Public Works/City Engineer
SUBJECT: Discuss Potential Veterans Memorial Blvd. NW Layout East of Nightingale St.
NW/18-37 - Engineering
DATE: August 28, 2018
INTRODUCTION
The City Council is requested to review the proposed entrance layout for planned extension of Veterans
Memorial Boulevard east of Nightingale Street.
DISCUSSION
Staff has been working with WSB on a layout for Veterans Memorial Boulevard (VMB) and would
like direction for the City Council on how the entrance of VMB should look on the east side of
Nightingale Street. Two entrance concepts are attached, one shows the entrance with a median
(Concept Option No. 1) and the other without a median (Concept Option No. 2).
Also attached are two options that show how the connection would be made at Tower Drive, Option 1
is if no site improvements are done at the Community Center and Option 2 shows a shift of Tower
Drive if expansion of the Community Center is constructed west of the existing building. A
roundabout schematic is shown on both drawings showing how it could be constructed in the future.
ACTION REQUESTED
The City Council is requested to provide staff with direction on how to proceed with the VMB design.
Respectfully submitted,
David D. Berkowitz, P.E.
Attach: Concept drawings for VMB east of Nightingale, Connection Options at Tower Drive. `�
w
I VETERANS MEMORIAL BLVD 1
tc
Y'
ale
r
r
VETERANS MEMORIAL BLVD
tl
WIN
yT ..
a, #
r t rlow4 AYot
itfE fF 1 M ' T
41
w 4
A VETERANS MEMORIAL BLVD N
WcB wS6FR15-000 o.: INTERSECTION CONCEPT OPTION NO. '° '°
a7 012615-000 H SCALE®
- 06/06/2016 ANDOVER, MINNESOTA
VETERANS MEMORIAL BLVD
4'
!w"'
A�
N R
t
WcB VETERANS MEMORIAL BLVD N
a7 wS6PR°'E°T"°.: INTERSECTION CONCEPT OPTION NO. 2 Z° `°
012615000 SCALE IN
- 08/08/2018 ANDOVER, MINNESOTA
E9 I
WSB W5 0 65-0 oNANL6OVER
- 08119/2018
WELL #5
FUTURE ROUNDABOUT
28' WIDE
(2}12' LANES
(2}2' REACTION @ C&G
lHiM
VETERANS MEMORIAL DRIVE
OPTION NO. 1
ANDOVER, MINNESOTA
WELL)
SAN MH
R.E.=903.11
E.(S)=881.97
/ I I
I
-- I
I
Covered
Pic is el e{i
I
I
I
L
EX. AN I H
R.E.=899. 6
2
I.E.(N) 881.27'
EX. SAN MH LA.ovZIP
R.E.=899.61 < <
LE.(S)=880.61
I.E.(E)=880.66 I II I
X. A4 13c sketball F
Bituminous Surf ace
0 40
IN
SCALE IN FEET
- WSBPROJECTNO.WSB °12°66°°
08/1912018ANL6 OVER*
FUTURE ROUNDABOUT
28' WIDE
(2}12' LANES
(2}2' REACTION @ C&G
L
SAN MH
R.E.=903.11
I.E.(S)=881.97
i
I
Covered
Pic is ILI, L+
I
I
i
L
IEX. AN H
R.E.T1.112 99. 6
.E.(W).
G1 I.E.(N)81. 7,
EXE.!89
SMH tx. o ��
R.E.=899.61 ` <
I. E.(S)=880.61 i i i
I.E.(E)=880.66 X. 12" DIP WM Bc sketball
WELL #5 Bituminous Surf ace
I I In I I II I I I
71' DIP MFR M WELL)
VETERANS MEMORIAL DRIVE
OPTION NO. 2
ANDOVER, MINNESOTA
o IN as
H®
SCALE IN FEET
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Council Members
FROM: Jim Dickinson, City Administrator
SUBJECT: Update City Campus Master Plan Potential Projects
DATE: August 28, 2018
ACTION REQUESTED
(D
The City Council is requested to receive a progress update from the City Administrator and Public
Works Director/City Engineer relative to exploring the expansion of the Andover YMCA
Community Center and the Public Works Facility expansions.
Design/development meetings were held with the respective project architects and the construction
manager this past week. The focus of the update/discussion will be on design/development
progress, partnership/stakeholder progress, current construction cost estimates, construction
budgets for the projects, and proposed timing of needed decisions.
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
2019 Budget Development Discussion
August 28, 2018
I
INTRODUCTION
City Administration/Finance along with the Department Heads continue to work on the 2019
Annual Operating Budget Development process and are looking to update the City Council on
progress and seek direction as the preparation of the 2019 Annual Operating Budget proceeds. In
addition, Administration is providing for the Council's reference a General Fund summary and
line item budget (pages 12-64).
City Administration will review with the Council the bold italics items at the meeting. Also,
Administration will review various spreadsheets with the Council using the Smart Board in the
conference room.
DISCUSSION
The following are the 2019 Budget Development guidelines adopted at the April 3`d City Council
meeting:
1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and
positioning the City for long-term competitiveness using sustainable revenue sources and
operational efficiencies.
Note: Preliminary Anoka County Assessor taxable market value figures for the City of
Andover are reflecting a 5.8% increase in total taxable market value. Refer to attached Pay
2019 Valuation Estimates (vane 8).
2) A fiscal goal that works toward establishing the General Fund balance for working capital at
no less than 45% of planned 2019 General Fund expenditures and the preservation of
emergency fund balances (snow emergency, public safety, facility management & information
technology) through targeting revenue enhancements or expenditure limitations in the 2018
adopted General Fund budget.
Note: With property tax revenues making up close to 80% of the total General Fund
revenues cash flow designations approaching 50% are recommended by the City's auditor.
The 2018 budget exceeded this guideline, also Emergency Fund Balances (approximately
3% of planned General Fund expenditures) are in place to stabilize a situation, not be a
complete solution. Staff will review with the Council a 2018 General Fund Fund Balance
Analysis at the meeting (Pape 9).
3) A commitment to limit the 2019 debt levy to no more than 25% of the gross tax levy and a
commitment to a detailed city debt analysis to take advantage of alternative financing
consistent with the City's adopted Debt Policy. (refer to attached page 10)
Note: The adopted 2018 debt levy was 12.88% of the gross tax levy, 2019 is currently
proposed at 16.15% of the gross tax levy, the 25% guideline provides reasonable margin to
accommodate additional debt next year.
Please keep in mind thatfor the 2017 & 2018 budgets, $500,000 & $525,000 respectively of
existing debt levy through 2016 was temporarily moved to a Capital Levy to fund planned
equipment purchases (rather than issuing debt), that decreased the debt levy percentage of
the gross tax levy significantly. The $525,000 is returning to debt leW for the 2019 budget.
4) A comprehensive review of the condition of capital equipment to ensure that the most cost-
effective replacement schedule is followed. Equipment will be replaced based on a cost benefit
analysis rather than a year -based replacement schedule.
Note: The City Vehicle Purchasing Committee has performed this analysis and has made
recommendations to the City Council as part of the 2019-2023 Capital Improvement Plan
(CIP) development process.
5) The use of long-term financial models that identify anticipated trends in community growth
and financial resources that will help designate appropriate capital resources for future City
needs. The financial models will be used in the budget planning process to ensure that key
short-term fiscal targets are in line with long-term fiscal projections.
Note: The City continually maintains various financial models to determine the long-term
impacts of present day expenditures and financing decisions. Fiscal assumptions are based
upon a complex set of financial data including growth factors, tax capacity valuations, per
capita spending and debt ratios.
6) Continued commitment to strategic planning targeted toward meeting immediate and long-
term operational, staffing, infrastructure and facility needs.
Note: A Council Community Vision and Organizational Goals and Values document was
approved by the City Council. Administration is to assure that direction provided in that
document is integrated into various department work plans and budgets.
7) A management philosophy that actively supports the funding and implementation of Council
policies and goals, and a commitment to being responsive to changing community conditions,
concerns, and demands, and to do so in a cost-effective manner.
Note: Administration pays special attention to fiscal values, commercial & residential
development or redevelopment, collaboration opportunities, service delivery, livability and
image of the community.
Staffing:
Administration has received new full-time staffing requests from the Fire Department,
Engineering Department and the Community Centerfor consideration in the 2019 budget. The
Fire Department staffing request focuses on administrative support and community education
activities. The Engineering Department request is for a Geographic Information System (GIS)
specialist position to focus on mapping solutions. The Community Center request for an
Assistant Manager to assist with facility and recreational management. Administration is
continuing to review the requests with the respective departments and will make a
recommendation on the positions to the Council at a future workshop, but the proposed budget
is currently carrying a $50,000 place holder in the General Fund for staffing enhancements.
There are also some anticipated retirements and staff vacancies within the next few years; in
response Administration/Human Resources will continue to focus on succession planning,
utilization of internship opportunities, continued cross -training of staff, and/or possible
realignment of resources.
Personnel Related Implications:
To date the following are the other projected issues facing personnel related expenses:
1. Human Resources has reviewed all position -based salaries and the associated benefit
package to determine if the total package is competitive with other government entities.
Based on the research, there are a few positions where salaries are lagging the market.
The 2019 budget proposal is carrying a place holder to address those positions.
Overall, pay steps for eligible employees are included in the 2019 budget proposal. A cost
of living adjustment (COLA) for non -bargaining employees is currently being evaluated
and the 2019 budget proposal has a placeholder to provide a COLA adiustment. The
current Public Works Union contract expires December 31. 2019 and the negotiated
wage increase of 3% for 2019 is included in the 2019 budget proposal numbers.
2. A midyear review of the employee health plan was conducted with our broker in late
July, our group has had some high claims this past year and the broker is predicting a
significant increase in the rates. Administration is working with the broker to market
our group to other qualified insurance providers and is also considering plan
modifications. The 2019 budget proposal is currently carrying a place holder for a
significant increase in the rates.
The City offers employees an open access high deductible plan ($5, 000 family plan
deductible and $2,500 single plan deductible) with a health spending account (HSA), this
was implemented originally in 2006 As part of the program, the City pays for 100% of
the single health insurance premium and 76% for a family health insurance premium. The
City does contribute annually to the employee's HSA.
Contractual Departments:
The City Attorney agreed to a fee neutral status -quo service level contract for 2018.
There have been discussions on the contract for the 2019 budget, but nothing finalized
as of yet.
2. The 2018 City of Andover Law Enforcement expenditure budget is $3,053,526 which is
offset by a Police State Aid revenue budget of $135,200 and School Liaison revenue budget
of $95,529 reflecting a net tax levy impact of $2,822,797.
The 2018 Sheriff's contract provides for:
a. 80 hours per day of patrol service
b. 6 hours per day of service provided by a Community Service Officer
c. School Liaison Officers in the middle school and high school
d. 2 Patrol Investigators
e. 50% of the Crime Watch Program's coordinator position.
Per contract, the Sheriff always provides the required number of deputies for all hours
contracted by the City. If the Sheriff's Office has a deputy vacancy or a deputy is injured
etc., they still provide the City with a deputy at straight time even though they may have to
fill those hours with overtime which at times may cost the Sheriff's Department additional
but is not billable per the contract.
Staff has had discussions with the Anoka County Sheriff for a 2019 contract and has
received a proposal for a status quo contract. That proposal reflects a 4.26% increase
($130,084) over the 2018 contract. The primary driver of the contract increase is the
recent wage settlements with the various bargaining units for the Anoka County
Sheriffs Departments. Another driver is the inability to be able to acquire sedan squads,
about the only option at this time is the SUV.
Council Memberships and Donations/Contributions:
The following memberships/contributions are currently included in the proposed 2019 Budget:
■ North Metro Mayors Association
$15,150
(GF)
• Metro Cities
$ 9,518
(GF)
• Mediation Services
$ 3,366
(GF)
• YMCA — Water Safety Program
$ 8,500
(GF)
• Alexandra House
$18,328
($15,328 GF & $3,000 CG)
• Youth First (Program Funding)
$14,000
($12,000 GF & $2,000 CG)
• NW Anoka Co. Community Consortium - JPA
$10,000
(GF)
• Teen Center Funding (YMCA)
$24,500
($8,100 GF & $16,400 CG)
■ Family of Promise
$ 3,000
(CG)
■ Lee Carlson Central Center for Family Resources
$ 1,500
(GF)
• Senior High Parties
$ 1,000
(CG)
■ Stepping Stone
$ 900
(CG)
Some are funded via the General Fund (GF), and those that qualify for charitable gambling
funding are done through the Charitable Gambling (CG) Special Revenue Fund
Capital Projects Levy:
Capital Projects Levy—The 2018 Capital Projects Levy Budget specifically designates $2,134,014
of the general tax levy to capital projects and equipment needs relating to Capital Project Outlay
($275,000), Capital Equipment Purchases ($525,000) Road and Bridge ($1,169,014), Pedestrian
Trail Maintenance ($100,000), Park Projects ($15,000) and Facility Maintenance Reserve
($50,000). Specific designation of the tax levy to anticipated City needs and priorities for
transportation and trail maintenance, park projects and equipment outlays allows the City to
strategically allocate its resources and raise the public's awareness of City spending priorities. The
Road and Bridge levy is evaluated annually and along with Capital Outlay, Pedestrian Trail
Maintenance and Park Levies increased/decreased according to the City Council budget guidelines
(refer to attached page 10 for levy details).
• Road and Bridge
An adjustment was made to the Road & Bridge funding formula in 2014, primarily to stop
the continual decrease in the levy that has been happening over the past few years due to
decreases in the Anoka County Assessor taxable market value figures for the City of
Andover. Based on Council discussion, consensus was to stop the decline in road funding
and evaluate annually through the adopted City Council Budget Development Guidelines.
It should be noted that in 2014, Local Government Aid (LGA) in the amount of $74,655
was used to help fund the Road & Bridge Fund That State of Minnesota funding has
largely gone away, down to $0.00 in 2017 and 2018. Future increases in LGA or even
the presence of LGA for the City of Andover based on the current State formula are
remote.
The 2018 City of Andover Road & Bridge levy is $1,169,014. That was a 4.74% increase
over 2017. Administration is proposing a 7.34% increase ($85,774) to $1,254,789 for the
2019 budget.
The 2018 City of Andover Pedestrian Trail Maintenance levy was increased significantly
from $63,075 in 2017 to $100,000 for 2018, a 58.54% increase in funding.
Administration is proposing a 2% increase ($2.000) to $102,000) for the 2019 budget.
• Park Improvements
This levy is an annual appropriation to be used to underwrite park improvement projects
as recommended by the Park and Recreation Commission and approved by the City
Council. This funding is intended to be a supplemental source of capital funding for park
projects that is separately identified in the City's Five -Year Capital Improvement Plan.
The 2015 levy was $61,500, but only $15,000 was levied for 2016. $46,500 of the previous
levy was re -assigned to the General Fund to focus on Park's maintenance/replacement
items. In addition to the re -assigned funds an additional $43,500 of General Fund levy
was assigned to Parks Repair/Replacement items for a total levy of $90,000 in 2016, and
that continued for 2017. The 2018 General Fund levy assigned to Parks
Repair/Replacement items levy was increased to $100,000, and the Parks Project levy
remained at $15,000.
Administration/Finance has evaluated these levy items throughout the CIP process and
is not proposing any adjustment to these levies for the 2019 budget.
• Equipment/Projects
Under the Capital Projects Levy, a levy is proposed to be designated to Capital
Equipment/Project expenditures identified through the CIP process. Through this
designation, the City, over time, will build a fund reserve to avoid cash flow "spikes" and
address a wide range of capital improvement needs such as facility maintenance projects
under a more controlled spending environment. The 2018 levy is $275,000,
Administration is recommending the same $275.000 for the 2019 budnet.
• Equipment/Projects
This was a reassigned levy in 2017 to provide for the 2017 equipment purchases.
Administration/Finance proposed a straight $500,000 Capital Equipment Purchases
Levy for the 2017 equipment purchases rather than through debt service levy and an
equipment bond. This process continued through 2018 but increased the levy by $25,000
to $525,000. In 2019, this levy is turned back to debt service levy for the City Campus
Master Plan implementation.
• Facility Maintenance Reserve
This was a new $50,000 levy proposed for 2018. A facility condition assessment study
identified many maintenance repairs for City facilities such as roof repairs, HVAC,
electrical panels, fire alarm systems, windows and air quality related items. This levy is
anticipated to continue. Administration/Finance after evaluating this levy throughout
the CIP process is recommending a $5,000 increase in this levy to $55,000 to address
maintenance repairs for the 2019 budget.
In addition, Administration is proposing an additional $300,000 levy to address
significant deferred maintenance items that have been identified for buildings (Public
Works & Community Center) being evaluated as potential expansion proiects within the
City Campus Master Plan. This levy could stay as a straight Capital Improvement Levy
or could be converted to a Debt Service Levy based on market conditions at the time of
the project or paired with an expansion project.
Debt Service Levy:
Annually the Finance Department conducts a detailed debt service analysis to monitor outstanding
debt and to look for early debt retirement or refinancing opportunities that will yield interest
expense savings to the City. (Staffalong with Ehlers & Associates have completed reviews to see
if any refinancing opportunities are available at this time, there are none. Finance will continue
to monitor refunding opportunities, as markets can move quickly, and calculate potential savings
for issues that may meet parameters which may generate savings.)
The proposed 2019 Debt Service levy is as follows:
• 2010A G.O. Open Space Referendum
$ 183,989
• 2012C Taxable G.O. Abatement Bonds
$ 969,378
• 2014A G.O. Equipment Certificates
$ 294,525
• 2016A G.O. Equipment Certificates
$ 142,837
• (New) 2019 Capital Improvement Bonds
$ 525,000
Total
$2,115,729
It should be noted that the levy is offset significantly by a $635,000 YMCA annual rental
payment for the Community Center bonds (2012C Taxable G.O. Abatement Bonds).
Staff will review with the Council at the meeting the City of Andover Long Range Debt Service
Levy Summary (page 11). The 2019 proposed levy has reassigned the $525.000 Capital Proiects
Levy back to Debt Service Levy for the City Campus Master Plan implementation.
ACTION REQUESTED
The Council is requested to receive a presentation and provide direction to staff.
Andover Valuation Totals
Captured Tax Increment
CITY OF ANDOVER
Pay 2019 Valuation Estimates
Pay 2016
Pay 2017
4,264,789
Pay 2018
Estimate Pay 2019
Taxable
Tax
Taxable
Tax
Taxable
Tax
Taxable Tax
Market
Capacity
Market
Capacity
Market
Capacity
Market Capacity
Value
Value
Value
Value
Value
- Value
Value Value
$ 2,539,686,867 $
26,847,273
$ 2,636,599,713 $
27,920,178
$ 2,959,411,470 $
31,287,043
$ 3,131,174,122 $ 32,538,525
(248,327)
(91,996)
(94,415)
(94,542)
Fiscal Disparity Contribution (1,055,284) (1,124,211) (1,184,724) (1,269,526)
Local Tax Rate Value 25,543,662 26,703,971 30,007,904 31,174,457
Fiscal Disparity Distribution
4,264,789
4,516,466
4,807,372
5,151,580
Total Adjusted Values
$ 29,808,451
$ 31,220,437
$
34,815,276
$ 36,326,037
4.74%
11.51%
4.34%
Taxable Market Value
Tax Capacity Value
% Change
% Change
OD
Pay 2015
$
2,539,686,867
Pay 2015
$
26,847,273
Pay 2016
$
2,636,599,713
3.82%
Pay 2016
$
27,920,178 4.00%
Pay 2017
$
2,959,411,470
12.24%
Pay 2017
$
31,287,043 12.06%
Pay 2018
$
3,131,174,122
5.80%
Pay 2018
$
32,538,525 4.00%
Taxable Market Values
$3,500,000,000
$3,000.000,000
$2,500,000,000
$2,000,000,000
$1,500,000,000
$1,000,000,000
$500,000,000
$0
Pay 2015 Pay 2016 Pay 2017 Pay 2018
Tax Capacity Values
$35,000,000
$30,000,000
$25,000,000
$20,000,000
$15,000,000
$10,000,000
$5,000,000
$0
Pay 2015 Pay 2016 Pay 2017 Pay 2018
City of Andover
General Fund
2018 Fund Balance Analysis
Round 1
Actual
December 31, 2017 $ 7,789,616
2018 Estimated Fund Balance Increase (Decrease) (78,949)
Projected December 31, 2018 7,710,667
Less: Snow Emergency
(90,000)
Public Safety
(90,000)
Facility Management
(90,000)
Information Technology
(90,000)
2019 Budgeted Use of Fund Balance
(326,450)
Economic Development
(300,000)
Fiscal Disparities Flunctuation
(300,000)
Prepaids / Inventories
(117,253)
Working Cash Flow
(5,870,801)
Estimated Balance Available for Adjustments $ 436;163`
2018 Working Cash Flow Designation Calculation:
2019 Requested Expenditure - Preliminary Estimate $11,741,602
% of 2019 General Fund Expenditures 50.000%
$ 5,870,801
J
CD
General Fund Levv
General Operations
Parks Repair/Replacement Items
Total General Fund
Debt Service Funds Lew
2004 EDA Public Facility Revenue Bonds
2010A G.O. Open Space Referendum Bonds
2012A G.O. Equipment Certificate
2012B G.O. Cap Improv Refunding Bonds
2012C Taxable G.O. Abatement Bonds
2014A G.O. Equipment Conceals
2016A G.O. Equipment Certificate
2019 Capital Improvement Bonds
Total Debt Service
Other Levies
Capital Projects Levy
Capital EquipmentlProjecl
Capital Equipment Purchases
Facility Maintenance Reserve
Parks Projects
Road & Bndge
Pedestdan Trail Maintenance
City of Andover, Minnesota
Property Tax Levy
Carl Contras! Certified Certified Certified Requested Change
2014 2015 2016 2017 2018 2019 %of Total $ %
$ 7,435,891
$ 7,630,892
$ 7,947,528
$ 8,254,354
$ 8543256
$ 8,845,970
67.51%
$
302,714
3.54%
294,945
294,525
90,000
90,000
100,000
100,000
0.76%
$
(525,000)
0.00%
-
-
-
525,000
2,071,065
2,136,065
2,100,413
1,610,047
1,599,087
2,115,729 16.15% $ 516,642 32.3100%
7,435,891
7,630,892
8,037528
8,344,354
8,643,256
8,945,970
68.27%
$
302,714
3.50%
181,803 - - - - -
187,283 184,238 186,291 187,840 188,7T7 183,989
140,000 140,000 142,885-
W1,015 W.120 498,435 - - -
740,955
975,652
977,332
974,418
972,055
969,378
260,000
296,055
295,470
295260
294,945
294,525
-
-
-
152,529
143,310
142,837
(525,000)
-100.00%
-
-
-
525,000
2,071,065
2,136,065
2,100,413
1,610,047
1,599,087
2,115,729 16.15% $ 516,642 32.3100%
210,000
250,000
250,000
250,000
275,000
275,000
2.10%
$
-
0.00%
-
-
-
500,000
525,000
-
0.00%
$
(525,000)
-100.00%
-
-
-
-
50,000
355,000
2.71%
$
305,000
610.00%
61,500
61,500
15,OOD
15,000
15,000
15,000
0.11%
$
-
0.00%
967,197
967,197
1,089,146
1,116,079
1,169,014
1254,788
9.58%
$
85,774
7.34%
58271
58,271
61,838
63,075
100,000
102,000
0.78%
$
2,000
2.00%
Lower Rum River Watershed
40,000
40,000
40.000
40,000
40,000
40,000
0.31% 8 0.00%
Total Other
1,336,968
1,376,968
1,455,984
1,984,154
2,174,014
2,041)88
15.58% $ (132,226)
Gross City Levy
10,843,925
11,143,925
11,593,925
11,938,555
12,416,357
13,103,487
100% $ 687,130 5.53%
Less Fiscal Disparities Distribution
1,718,153
1,846,295
1,586,747
1,736,547
1,802,963
1,789,658
Local Tax Rate Levy
$ 9,125,772
$ 9,297,630
$ 10,007,178
$ 10,202,008
$ 10,613,394
$ 11,313,829
Less LeW Based on Market Value
$ (187,283)
$ 184,238
E 186,297
$ 187,840
$ 188,7]]
$ 183,989
Net Local Tax Rate Levy
$ 8,938,489
$ 9,113,392
$ 9,620,887
$ 10,014,168
$ 10,424,617
$ 11,129,840
Atljustetl Tax Capacity Value" (1)
20,615,782
24,496,024
25,543,662
26,703,971
30,407,904
31,174,45]
18.82%
4.28%
9.01%
17.48%
3.89%
"Adjusted Value determined by adjusting for Fiscal Dispenses and Tax Increment estimates
... Blended rale due to the City of Andover levying for Lower Rum River Watershed District
(1) Adjusted Tax Capacity Value is subject to change.
Chance %C
Tax CapacM1y Rale-
43.358%
37.204%
38.447%
37.501%
34.740% 35.700% 0.960% 2.760%
Tae Capacity Rate WIC LRRWSD
43.197%
37.070%
38.314%
37.374%
37.374%
Tax Capacity Rate With LRRWSD
43.657%
37.461%
36]02%
37.738%
37.738%
VoterApprovetl Ref -MV
0.00841%
0.00719%
0.00699%
0.00681%
0.00681%
"Adjusted Value determined by adjusting for Fiscal Dispenses and Tax Increment estimates
... Blended rale due to the City of Andover levying for Lower Rum River Watershed District
(1) Adjusted Tax Capacity Value is subject to change.
CITY OF ANDOVER
Long Range Debt Service
2017
2018
2019
2020
2021
2022
2023
2024
Certificates of Indebtedness
2011A G.O. Equipment Certificates
2012A G.O. Equipment Certificates
2014A G.O. Equipment Certificates
295,260
294,945
294,525
2016A G.O. Equipment Certificates
152,529
143,310
142,837
143,373
Equiprne Purchases L_
2020 Equipment Certificate -
320,000
320,000
320,000
320,000
2022 Equipment Certificate -
175,000
175,000
175,000
2024 Equipment Certificate -
325,000
947,789
963,255
437,362
463,373
470,000
495,000
495,000
500,000
Capital Improvement Bonds
2004A G.O. Cap Improvement Bonds
2012B G.O. Cap Improvement Ref Bonds
Facility Expansion
525,000
525,000
525,000
710,000
710,000
710,000
-
-
525,000
525,000
525,000
710,000
710,000
710,000
J
Referendum Bonds
Open Space Referendum Bonds
187,840
188,777
183,989
184,199
184,078
Subtotal
1,135,629
1,210,000
1,205,000
1,179,078
1,205,000
1,152,032
1,146,351
1,172,572
Community Center Bonds
2004 EDA Public Facility Revenue Bonds
2012C G.O. Abatement Bonds
1,274,418
1,272,055
1,269,378
1,276,780
1,273,263
1,274,628
1,269,745
1,273,650
*Transfer from Operations
(300,000)
(300,000)
(300,000)
(301000)
(300,000)
(300,000)
(300,000)
(300,000)
Subtotal
974,418
972,055
969,378
976,780
973,263
974,628
969,745
973,650
2,110,047
2,124,087
2,115,729
2,149,352
2,152,341
2,179,628
2,174,745
2,183,650
9,634
14,040
(8,358)
33,623
2,989
27,287
(4,883)
8,905
0.46%
0.67%
-0.39%
1.59%
0.14%
1.27%
-0.22%
0.41%
CIN OF ANDOVER
General Fund
Revenue & Expense Summary
EXPENDITURES
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested*
Budget Change (*)
General Government
2013
2014
2015
2016
2017
2018
2018
2019
$
%
REVENUES
4,371,340
4,498,920
4,503,332
4,667,326
4,778,336
4,978,056
4,978,056
5,174,777
196,721
3.95%
Property Taxes
$ 7,376,284
$ 7,476,295
$ 7,634,715
$ 8,217,768
$ 8,332,634
$ 8,721,256
$ 8,721,256
$ 9,062,986
341,730
3.92%
License and Permits
536,707
364,430
452,616
625,906
546,378
377,900
427,750
384,900
7,000
1.85%
Intergovernmental Revenues
710,071
697,491
749,570
733,953
793,932
766,274
766,274
786,008
19,734
2.58%
Charges for Current Services
1,122,460
998,150
804,684
912,220
843,022
746,700
759,950
708,700
(38,000)
-5.09%
Fines and Forfeits
96,130
94,375
99,304
88,600
75,287
90,250
75,075
75,250
(15,000)
-16.62%
Interest Income
(17,096)
144,876
63,709
68,380
64,751
75,000
75,000
75,000
0
0.00%
Miscellaneous Revenue
140,983
150,759
154,239
194,812
178,616
129,300
144,800
134,300
5,000
3.87%
Transfers
196,930
196,930
196,930
196,930
196,930
178,558
178,558
188,008
9,450
5.29%
TOTALREVENUES
10,162,469
10,123,306
10,155767
11,038,569
11,031,550
11085,238
11,148,663
11,415,152
329,914
2.96%
EXPENDITURES
General Government
2,308,882
2,481,927
2,511,970
2,592,649
2,642,223
3,010,679
3,036,404
3,127,692
117,013
3.89%
J
N Public Safety
4,371,340
4,498,920
4,503,332
4,667,326
4,778,336
4,978,056
4,978,056
5,174,777
196,721
3.95%
Public Works
2,759,342
2,819,372
2,817,981
2,966,674
2,854,540
3,206,152
3,183,152
3,318,705
112,553
3.51%
Other
210,510
81,185
256,720
283,077
764,875
70,428
30,000
120,428
50,000
70.99%
TOTAL EXPENDITURES
9,590,074
9,881,404
10 090 003
10.509-.726
11,039,974
11,265 315
11,227 612
11,741,602
476,287
UNDER OVER BUDGET $ 572,395 $ 241,902 $ 65,764 $ 528,843 $ 8,424 $ 1180,077) $ 78 949 $ (326,450) $ 146,373
8/24/2018
CITY OF ANDOVER
General Fund
Revenue Budget Worksheet - 2019
Miscellaneous Revenue
Actual
Actual
Actual Actual
Actual
Budget*
Estimate
Requested* Change(•)
Account Number Description
2013
2014
2015 2016
2017
2018
2018
2019 $ %
1,512
41230 -Human Resources
595 1,994
1,127 500
41,674
33,000
40,000
40,000
7,000
Miscellaneous Revenue
License & Permits
41230 58100 Refunds & Reimbursements
1,512
4,167
595 1,994
1,127 500
Miscellaneous Revenue
1,512
4,167
595 1,994
1,127 500
Total
1,512
4,167
595 1,994
1,127 500
41,674
33,000
40,000
40,000
7,000
41300 - CiN Clerk
41300
52105
Liquor - Non -Intoxicating
450
License & Permits
41300
52100
Liquor -Intoxicating
35,550
30,100
27,255
36,597
41,674
33,000
40,000
40,000
7,000
21.21%
41300
52105
Liquor - Non -Intoxicating
450
375
400
375
300
300
300
300
-
0.00%
41300
52110
Tobacco
3,750
3,000
2,750
3,250
3,000
3,500
3,000
3,500
-
0.00%
41300
52115
Refuse/Recycler Haulers
3,725
3,600
3,875
3,475
3,600
3,500
3,500
3,500
-
0.00%
41300
52120
Peddler
1,450
1,575
1,950
1,950
2,675
1,500
2,000
1,500
-
0.00%
41300
52125
Therapeutic Massage
912
1,000
650
2,006
2,100
600
1,200
600
-
0.00%
41300
52126
Vehicle Sales License
945
840
420
840
1,260
500
1,000
500
-
0.00%
J
License &Permits
46,782
40,490
37,300
48,493
54,609
42,900
51,000
49,900
7,000
16.32%
W
Charges For Services
41300
54100
Notary Fees
234
183
186
207
297
100
200
100
-
0.00%
41300
54115
Sale of Copies, Ord, etc.
14
IS
14
-
4
50
-
50
-
0.00%
41300
54125
Assessment Searches
5,925
2,125
2,300
1,620
3,225
2,000
2,500
2,000
-
0.00%
41300
54145
Party Permits
155
130
120
120
150
100
100
100
-
0.00%
41300
54155
Recording Fees
800
800
800
700
700
500
700
500
-
0.00%
Charges For Services
7,128
3,253
3,420
2,647
4376
2,750
3,500
2,750
-
0.00%
Fines
41300
56100
Court Fines
95,255
93,700
97,529
88,525
75,212
90,000
75,000
75,000
(15,000)
-16.67%
41300
56200
False Alarm Fines
875
675
1,775
75
75
250
75
250
-
0.00%
Fines
96,130
94,375
99,304
88,600
75,287
90,250
75,075
75,250
(15,000)
-16.62%
Miscellaneous Revenue
41300
58175
Contributions
1,015
1,272
1,341
1,738
1,889
1,000
1,000
1,000
-
0.00%
Miscellaneous Revenue
1,015
1,272
1,341
1,738
1,889
1,000
1,000
1,000
-
0.00%
Total
151,055
139,390
141,365
141,478
136,161
136,900
130,575
128,900
(8,000)
-5.84%
41310 -Elections
Charges For Services
41310
54175
Council Filing Fee
-
30
-
50
50
50
50
-
0.00%
Charges For Services
-
30
-
50
50
50
50
-
0.00%
Miscellaneous Revenue
8/24/2018
CITY OF ANDOVER
General Fund
Revenue Budget Worksheet - 2019
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested*1
Change (*)
Account Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
$
%
41310
58100
Refunds & Reimbursements
-
Miscellaneous Revenue
-
-
#DN/01
-
-
-
-
#DIV/01
Total
-
30
-
50
-
50
50
50
-
0.00%
41400 -Finance
Charges For Services
41400
54165
Bad Check Fee
150
120
60
120
30
150
150
150
-
0.00%
41400
54285
Finance Department Fees
151,602
132,084
34,118
41,400
80,683
35,000
35,000
35,000
-
0.00%
41400
54320
Finance Charge
1,971
494
555
616
219
100
100
100
-
0.00%
Charges For Services
153,723
132,698
34,733
42,136
80,932
35,250
35,250
35,250
-
0.00%
Miscellaneous Revenue
41400
58100
Refunds & Reimbursements
28,407
28,623
27,096
26,386
28,543
20,000
25,000
25,000
5,000
25.00%
Miscellaneous Revenue
28,407
28,623
27,096
26,386
28,543
20,000
25,000
25,000
5,000
25.00%
Total
182,130
161,321
61,829
68,522
109,475
55,250
60.250
60,250
5,000
9.05%
41420 - Information Services
Miscellaneous Revenue
41420
58110
Computer Services
37,800
37,800
37,800
37,800
37,800
37,800
37,800
37,800
-
0.00%
Miscellaneous Revenue
37,800
37,800
37,800
37,800
37,800
37,800
37,800
37,800
-
0.00%
Total
37,800
37,800
37,800
37,800
37,800
37,800
37,800
37,800
-
0.00%
41500 -Planning & Zoning
License & Permits
41500
52130
Rezoning
165
675
-
-
-
500
500
500
-
0.00%
41500
52135
Conditional Use
2,150
1,100
400
-
550
-
-
-
_
#DIV/oi
41500
52140
Variance
300
150
125
-
875
300
300
300
-
0.00%
41500
52145
Lot Splits
330
410
410
60
920
300
300
300
-
0.00%
41500
52150
Signs
5,048
2,426
3,546
4,490
3,623
3,500
3,500
3,500
-
0.00%
41500
52155
Vacation of Easement
375
625
500
750
125
500
500
500
-
0.00%
41500
52260
Comp Plan Amendment
-
-
500
500
-
500
500
500
-
0.00%
41500
52270
Temporary Structure
-
200
200
200
100
250
250
250
-
41500
52275
Interim Use
-
1,050
2,100
1,400
350
1,000
1,000
1,000
-
License &Permits
8,3686,636
7,781
7,400
6,543
6,850
6,850
6,850
-
0.00%
Intergovernmental Revenue
41600
53490
Other Grants
-
-
3,836
Intergovernmental Revenue
-
3,836
Charges For Services
8/24/2018
CITY OF ANDOVER
General Fund
Revenue Budget Worksheet -2019
Miscellaneous Revenue
41500 58100 Refunds & Reimbursements 88 - 577 - 4DIV/01
Miscellaneous Revenue 88 - - 577 - #DIV/01
Total 13,658 16,606 13,868 14,851 15,270 11,700 11,700 11,700 - 0.00%
41600 - Engineering
License & Permits
Charges For Services
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested*
Change(-)
Account Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
$ %
41500
54105
Plat Fees
1,350
3,350
2,000
2,150
2,550
1,000
1,000
1,000
- 0.00%
41500
54130
Meeting Notification Signs
300
390
420
180
360
350
350
350
- 0.00%
41500
54280
Flood / Zone Search Letter
25
100
150
50
100
-
-
-
- #DIV/01
41500
54290
Planning Department Fees
3,527
6,130
3,517
4,494
1,881
3,500
3,500
3,500
- 0.00%
- 0.00%
41600
Charges For Services
5,202
9,970
6,087
6,874
4,891
4,850
4,850
4,850
- 0.00%
Miscellaneous Revenue
41500 58100 Refunds & Reimbursements 88 - 577 - 4DIV/01
Miscellaneous Revenue 88 - - 577 - #DIV/01
Total 13,658 16,606 13,868 14,851 15,270 11,700 11,700 11,700 - 0.00%
41600 - Engineering
8/24/2018
License & Permits
Charges For Services
41600 52250
Curb Cut
50 100 50
150
100 - - -
- #DIV/01
41600 52265
Fencing/Retaining Wall
1,650 2,100 2,250
2,250
2,220 1,750 1,750 1,750
- 0.00%
1,141
License & Permits
1,700 2,200 2,300
2,400
2,320 1,750 1,750 1,750
- 0.00%
---`
Intergovernmental Revenue
Site Plan Review - Trees
1,170
520
455
U141600 53490
Other Grants
-
6,062
2,227
- #DIV/Oi.
41600
Intergovernmental Revenue
- -
6,062
2,227
- #DIV/0!
8/24/2018
Charges For Services
41600
54180
Escrow Inspection Fee
2,000
1,100
900
1,141
1,850
750
750
750
- 0.00%
41600
54185
Site Plan Review - Trees
1,170
520
455
715
-
-
-
-
- #DIV/01
41600
54200
Engineer Fees - PW Director
29,301
31,207
27,772
23,479
19,288
22,000
20,000
22,000
- 0.00%
41600
54205
Engineer Fees - Asst PW Diree
14,332
18,346
10,658
10,654
6,781
7,500
7,000
7,500
- 0.00%
41600
54210
Engineer Fees - Asst Engineer
104,075
96,597
85,157
87,821
83,228
80,000
78,000
80,000
- 0.00%
41600
54215
Engineer Fees - Tech IV
283,144
252,665
168,632
205,751
208,320
200,000
192,000
200,000
- 0.00%
41600
54220
Engineer Fees - Natural Res Te
3,303
1,414
1,138
2,025
2,043
2,000
2,000
2,000
- 0.00%
41600
54225
Engineer Fees - Secretary
10,080
11,375
11,391
10,395
11,812
10,000
10,000
10,000
- 0.00%
41600
54230
Engineer Fees - Intent
7,536
3,264
5,261
4,147
-
4,000
4,000
4,000
- 0.00%
41600
54235
Engineer Fees - Mileage
5,070
4,081
3,361
3,525
2,360
3,000
3,000
3,000
- 0.00%
41600
54295
Grading Inspection Fee
3,747
1,844
2,943
3,663
5,503
2,000
2,000
2,000
- 0.00%
41600
54305
Administrative Fees
100
-
100
400
100
-
-
-
- #DIV/01
41600
54335
Bid Plans
570
490
1,550
890
750
750
750
- 0.00%
Charges For Services
463,858
422,983
318,258
355,266
342,175
332,000
319,500
332,000
- 0.00%
Miscellaneous Revenue
41600
58100
Refunds & Reimbursements
1,200
100
801
- #DIV/01
Miscellaneous Revenue
1,200
100
801
- #DIV/0!
Total
466,758
425,283
320,558
363,728
347,523
333,750
321,250
333,750
- 0.00%
41975 - Sunshine Park Concessions
8/24/2018
CITY OF ANDOVER
General Fund
Revenue Budget. Worksheet - 2019
Actual Actual Actual Actual Actual Budget* Estimate Requested* Change(*)
Account Number Description 2013 2014 2015 2016 2017 2018 2018 2019 $ %
Charges For Services
42200
41975
55540
Concessions
47,460
51,208
43,318
43,361
2,000
2,000
2,000
- 0.00%
-
#DN/01
Burning Pennit
940
Charges For Services
47,460
51,208
43,318
43,361
1,100
1,100
- 0.00%
-
#DIV/01
5,492
2,082
Total
47,460
51,208
43,318
43,361
3,100
- 0.00%
-
#DIV/01
47985
-Andover St N Concessions
42200
53410
State Fire Aid
153,555
151,491
165,332
167,844
Charges For Services
165,000
165,000
165,000
- 0.00%
42200
53490
Other Grants
17,340
35,034
39,592
41985
55540
Concessions
16264
14,453
-
-
Intergovernmental Revenue
170,895
186,525
-
#DIV/Oi.
185,607
171,000
Charges For Services
16,264
14,453
-
-
Charges For Services
-
#DIV/01
Total
16,264
14,453
-
Plan Check Fees
2,540
705
262
1,375
-
#DIV/0!
1,000
42100
-Police Protection
42200
54120
Reports
165
180
20
20
40
-
-
-
- #DIV/01
Intergovernmental Revenue
54169
Inspection Fee
450
600
200
450
300
300
300
300
42100
53370
State Police Aid
124,800
126,880
131,040
133,120
135,200
135,200
135,200
135,200
-
0.00%
42100
53840
School District Liaison
86,524
88,254
90,020
91,820
93,656
95,529
95,529
97,440
1,911
2.00%
58100
Refunds & Reimbursements
Intergovernmental Revenue
211,324215,134
3,132
221,060
224,940
228,856
230,729
230,729
232,640
1,911
0.83%
Donations
150
Total
211,324
215,134
221,060
224,940
228,856
230,729
230,729
232,640
1,911
0.83%
1,911
42200 - Fire Protection
4,132
1,424
2,557
500
500
500
- g 4/2018
License & Permits
42200
52160
Fire Permit
4,552
1,262
887
2,340
2,933
2,000
2,000
2,000
- 0.00%
42200
52165
Burning Pennit
940
820
941
1,360
1,140
1,100
1,100
1,100
- 0.00%
License &Permits
5,492
2,082
1,828
3,700
4,073
3,100
3,100
3,100
- 0.00%
Intergovernmental Revenue
42200
53410
State Fire Aid
153,555
151,491
165,332
167,844
167,893
165,000
165,000
165,000
- 0.00%
42200
53490
Other Grants
17,340
35,034
39,592
21,300
17,714
6,000
6,000
6,000
- 0.00%
Intergovernmental Revenue
170,895
186,525
204,924
189,144
185,607
171,000
171,000
171,000
- 0.00%
Charges For Services
42200
54110
Plan Check Fees
2,540
705
262
1,375
1,773
1,000
1,000
1,000
- 0.00%
42200
54120
Reports
165
180
20
20
40
-
-
-
- #DIV/01
42200
54169
Inspection Fee
450
600
200
450
300
300
300
300
- 0.00%
Charges For Services
3,155
1,485
482
1,845
2,113
1,300
1,300
1,300
- 0.00%
Miscellaneous Revenue
42200
58100
Refunds & Reimbursements
1,761
1,144
3,132
1,324
1,007
500
500
500
- 0.00%
42200
58125
Donations
150
1,000
100
1,550
- #DIV/0!
Miscellaneous Revenue
1,911
1,144
4,132
1,424
2,557
500
500
500
- g 4/2018
CITY OF ANDOVER
General Fund
Revenue Budget Worksheet - 2019
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested* Change (*)
Account Number Description 2013
2014
2015
2016
2017
2018
2018
2019 $ %
900
6,450
1,350
7,650
8,500
8,500
Total 181,453
191,236
211,366
196,113
194,350
175,900
175,900
175,900 - 0.00%
5,250
6,900
-
-
-
-
42300
52175
42300 -Protective Inspection
9,525
6,750
5,950
4,820
6,254
5,000
Total 602,518 394,482 520,310 735,827 597,760 403,750 469,750 403,750 - 0.00%
42500 -Animal Control
License & Permits
License & Permits
42300
52170
Rental Licenses -Multi
7,350
900
6,450
1,350
7,650
8,500
8,500
8,500
- 0.00%
42300
52171
Rental Licenses- Single
11,900
6,900
7,950
5,250
6,900
-
-
-
-
42300
52175
Contractor
9,525
6,750
5,950
4,820
6,254
5,000
5,000
5,000
- 0.00%
42300
52180
Tree Trimmers
1,150
500
1,250
1,050
1,050
750
750
750
- 0.00%
42300
52185
Building
274,313
180,453
238,113
339,183
281,528
180,000
210,000
180,000
- 0.000/0
42300
52190
Heating
45,062
36,589
37,334
62,647
49,023
36,000
43,000
36,000
- 0.00%
42300
52195
Plumbing
42,447
21,324
27,229
48,022
35,950
21,000
25,000
21,000
- 0.00%
42300
52200
Septic Systems
3,400
2,575
3,875
3,665
3,075
2,500
2,500
2,500
- 0.00%
42300
52205
Septic Pumping
9,870
9,810
17,610
9,780
11,205
10,000
10,000
10,000
- 0.00%
42300
52215
Sanitary Sewer
2,025
2,950
4,350
7,725
6,450
4,000
4,000
4,000
- 0.00%
42300
52217
Water Permit Fee
-
-
-
8,400
6,225
5,000
5,000
5,000
- 0.00%
42300
52220
Certificate of Occupancy
1,030
10
150
-
-
-
-
-
- IIDIV/0!
42300
52225
Gas Fireplace
7,500
5,550
8,099
6,840
6,973
5,000
5,000
5,000
- 0.00%
-'42300
52230
Electric Permits
55,131
35,698
41,369
61,901
52,933
43,000
43,000
43,000
- 0.00%
License & Permits
470,703
310,009
399,729
560,633
475,216
320,750
361,750
320,750
- 0.00%
Charges For Services
42300
54110
Plan Check Fees
124,953
78,865
115,121
172,299
120,953
80,000
105,000
80,000
- 0.00%
42300
54135
Sewer Administration
1,215
15
-
15
-
-
-
-
- #DIV/0!
42300
54170
Reinspection Fee
5,114
5,018
5,013
2,313
708
3,000
3,000
3,000
- 0.00%
42300
54325
Building Department Fee
533
575
447
477
393
- #DIV/01
Charges For Services
131,815
84,473
120,581
175,104
122,054
83,000
108,000
83,000
- 0.00%
Miscellaneous Revenue
42300
58100
Refunds & Reimbursements
90
490
-
Miscellaneous Revenue
90
490
_
Total 602,518 394,482 520,310 735,827 597,760 403,750 469,750 403,750 - 0.00%
42500 -Animal Control
License & Permits
42500 52235 Dog Kennel
500
325
125
100
275
50
300
50
- 0.00%
42500 52240 Dog License
3,162
2,688
3,553
3,180
3,342
2,500
3,000
2,500
- 0.00%
License & Permits
3,662
3,013
3,678
3,280
3,617
2,550
3,300
2,550
- 0.00%
Total
3,662
3,013
3,678
3,280
3,617
2,550
3,300
2,550
- 0.00%
43100 - Streets & Hi hways
8/24/2018
CITY OF ANDOVER
General Fund
Revenue Budget Worksheet - 2019
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested*1
Chane(")
Account Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
$
%
Intergovernmental Revenue
43100
53401
State Highway Aid - Maintenat
208,227
214,474
220,908
227,535
234,361
241,392
241,392
248,364
6,972
2.89%
Intergovernmental Revenue
208,227
214,474
220,908
227,535
234,361
241,392
241,392
248,364
6,972
2.89%
Charges For Services
43100
54245
Street Department Fees
-
551
-
9DIV/0!
Charges For Services
-
551
-
#DIV/01
Special Assessments
43100
57300
Spec Assess - Interest&Penal
57
169
70
110
446
-
-
-
-
#DIV/01
43100
57400
Spec Assess - Certified Bit
1,436
4,855
5,631
2,907
3,683
3,500
3,500
3,500
-
0.00%
Special Assessments
1,493
5,024
5,701
3,017
4,129
3,500
3,500
3,500
-
0.00%
Miscellaneous Revenue
43100
58100
Refunds & Reimbursements
1,874
391
569
719
5,481
_
Miscellaneous Revenue
1,874
391
569
719
5,481
-
J
Total
211,594
220,440
227,178
231,271
243,971
244,892
244,892
251,864
6,972
2.85%
43300 -Street Signs
Charges For Services
43300
54190
Sale of Strect Signs
14,713
6,251
12,645
9,703
8,164
4,500
4,500
4,500
-
0.00%
Charges For Services
14,713
6,251
12,645
9,703
8,164
4,500
4,500
4,500
-
0.00%
Miscellaneous Revenue
43300
58100
Refunds & Reimbursements
1,922
3,277
779
1,039
1,825
500
500
500
-
Miscellaneous Revenue
1,922
3,277
779
1,039
1,825
500
500
500
-
Total
16,635
9,528
13,424
10,742
9,989
5,000
5,000
5,000
-
0.00%
43600 -Street Lights - Billed
Charges For Services
43600
55410
Street Lights - User Fee
233,723
228,780
231,778
232,466
235,255
238,000
238,000
200,000
(38,000)
-15.9700%
43600
55440
Street Lights - Penalties
260
-
-
#DIV/01
Charges For Services
233,983
228,780
231,778
232,466
235,255
238,000
238,000
200,000
(38,000)
-15.97%
Special Assessments
43600
57300
Spec Assess - Interest & Penal
38
120
23
138
333
-
-
-
-
#DIV/01
43600
57400
Spec Assess - Certified Bil
2,323
4,099
8,922
12,121
12,780
10,000-
#DIV/Oi.
Special Assessments
2,361
4,219
8,945
12,259
13,113
10,000
-
#DIV/01
Total
236,344
232,999
240,723
244,725
248,368
238,000
248,000
200,000
(38,000)
-15.97%
8/24/2018
CITY OF ANDOVER
General Fund
Revenue Budget Worksheet - 2019
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested*1
Change(*)
Account Number
Description
2013
2014
•2015
2016
2017
2018
2018
2019
S
%
45000 -Parks & Recreation
Intergovernmental Revenue
45000
53420
State DNR
-
#DIV/01
Intergovernmental Revenue
-
-
#DIV/01
Charges For Services
45000
54160
Tournament Fees
2,615
575
-
#DIV/0!
Charges For Services
2,615
575
-
#DIV/0!
Miscellaneous Revenue
45000
58100
Refunds & Reimbursements
692
740
1,026
38,336
10,895
500
500
500
-
0.00%
45000
58105
Rent
1,210
1,102
375
151
2
500
500
500
-
0.00%
Miscellaneous Revenue
1,902
1,842
1,401
38,487
10,897
1,000
1,000
1,000
-
0.00%
Total
4,517
2,417
1,401
38,487
10,897
1,000
1,000
1,000
-
0.00%
46000 - Recycling
Intergovernmental Revenue
46000
53360
SCORE Reimbursement
108,286
71,265
69,514
72,718
125,407
113,060
113,060
123,911
10,851
9.60%
46000
53890
Misc Grants
23,071
Intergovernmental Revenue
108,286
71,265
92,585
72,718
125,407
113,060
113,060
123,911
10,851
9.60%
Charges For Services
46000
54150
Recycling Fees
42,544
41,440
33,382
42,768
43,062
45,000
45,000
45,000
-
0.00%
Charges For Services
42,544
41,440
33,382
42,768
43,062
45,000
45,000
45,000
-
0.00%
Miscellaneous Revenue
46000
58100
Refunds & Reimbursements
100
-
Miscellaneous Revenue
100
-
Total
150,830
112,705
125,967
115,586
168,469
158,060
158,060
168,911
10,851
6.87%
49100 - Unallocated
General Property Tax
49100
51100
Property Tax - Current
6,003,532
6,194,041
6,293,733
7,040,377
7,129,257
8,643,256
8,643,256
8,984,986
341,730
3.95%
49100
51110
Property Tax - Delinquent
114,837
72,773
59,108
66,152
48,051
70,000
70,000
70,000
-
0.00%
49100
51300
Fiscal Disparities
1,239,279
1,196,777
1,274,273
1,096,956
1,145,300
-
-
-
-
#DIV/01
49100
51400
Penalties & Interest on Taxes
18,636
12,704
7,601
14,283
10,026
8,000
8,000
8,000
-
0.00%
General Property Tax
7,376,284
7,476295
7,634,715
8217,768
8,332,634
8,721,256
8,721256
9,062,986
341,730
3.92/
Intergovernmental Revenue
49100
53310
Local Government Aid
-
-
-
-
-
-
-
-
-
#DIV/01
49100
53340
PERA Aid
10,093
10,093
10,093
10,093
10,093
10,093
10,093
10,093
-
0.00%
8/24/2018
CITY OF ANDOVER
General Fund
Revenue Budget Worksheet -2019
8/24/2018
Actual
Actual
Actual
Actual
Actual
Budget*
Estimate
Requested*1
Change(*)
Account Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
8
%
49100
53380
Market Value Homestead Cred
1,246
-
-
3,461
3,545
-
-
-
-
#DIV/Oi.
49100
53490
Other Grants
Intergovernmental Revenue
11,339
10,093
10,093
13,554
13,638
10,093
10,093
10,093
-
0.00%
Investment Income
49100
56910
Interest Earned
84,772
120,011
63,528
70,249
86,194
75,000
75,000
75,000
-
0.000/0
49100
56920
Valuation Adjustment
(101,868)
24,865
181
(1,869)
(21,443)
-
#DIV/01
Investment Income
(17,096)
144,876
63,709
68,380
64,751
75,000
75,000
75,000
-
0.00%
Miscellaneous Revenue
49100
58100
Refunds & Reimbursements
-
-
125
-
-
-
-
-
-
#DIV/01
49100
58105
Rent
59,456
62,687
65,702
69,163
69,939
65,000
65,000
65,000
-
0.00%
49100
58140
Maps, etc
42
213
53
19
25
-
#DIV/01
Miscellaneous Revenue
59,498
62,900
65,880
69,182
69,964
65,000
65,000
65,000
-
0.00%
Other Financing Sources
49100
59100
Operating Transfers In
196,930
196,930
196,930
196,930
196,930
178,558
178,558
188,008
9,450
5.29%
Other Financing Sources
196,930
196,930
196,930
196,930
196,930
178,558
178,558
188,008
9,450
5.29%
N
Total
7,626,955
7,891,094
7,971 327
8,565,814
8,677,917
9,049,907
9,049,907
9,401,087
351,180
3.88%
CD
Grand Total
]0,162,469
10,123,306
10,155,767
11,038,569
11,031,550
11,085,238
11,148,663
11,415,152
329,914
2.98%
General Fund Summary
51000
General Property Tax
7,376,284
7,476,295
7,634,715
8,217,768
8,332,634
8,721,256
8,721,256
9,062,986
341,730
3.92%
52000
License & Permits
536,707
364,430
452,616
625,906
546,378
377,900
427,750
384,900
7,000
1.85%
53000
Intergovernmental Revenue
710,071
697,491
749,570
733,953
793,932
766,274
766,274
786,008
19,734
2.58%
54000
Charges For Services
1,122,460
998,150
804,684
912,220
843,022
746,700
759,950
708,700
(38,000)
-5.09%
56000
Fines
96,130
94,375
99,304
88,600
75,287
90,250
75,075
75,250
(15,000)
-16.62%
56900
Investment Income
(17,096)
144,876
63,709
68,380
64,751
75,000
75,000
75,000
-
0.00%
57000
Special Assessments
3,854
9,243
14,646
15,276
17,242
3,500
13,500
3,500
-
0.00%
58000
Miscellaneous Revenue
137,129
141,516
139,593
179,536
161,374
125,800
131,300
130,800
5,000
3.97%
59000
Other Financing Sources
196,930
196,930
196,930
196,930
196,930
178,558
178,558
188,008
9,450
5.29%
10,162,469
]0,123,306
10,155,767
11,038 569
11,031,550
11,085,238
11,148,663
11,415,152
329,914
2.98%
8/24/2018
CITY OF ANDOVER
General Fund - Expenditure Budget Summary Totals - By Department
Budget Year 2019
PUBLICSAFETF
Actual
Actual
Actual
Actual
Actual
Budgets
Estimate
Requested"
Change (�)
N Police Protection
2013
2014
2015
2016
2017
2018
2018
2019
$
%
GENERAL GOVERNMENT
1,126,979
1,264,018
1,165,223
1,285,417
1,353,209
1,423,914
1,423,914
1,474,623
50,709
3.56%
Mayor and Council
$ 83,595
$ 84,650
$ 85,060
$ 86,989
$ 84,136
$ 91,298
$ 91,298
$ 93,361
2,063
2.26%
Administration
147,503
169,218
172,296
187,876
187,514
203,833
203,833
216,567
12,734
.6.25%
Newsletter
17,677
20,974
21,042
22,731
25,287
26,000
26,000
26,800
800
3.08%
Human Resources
17,907
18,038
15,908
13,404
15,520
28,431
28,156
28,797
366
1.29%
Attorney
173,244
177,427
180,313
184,990
188,644
191,360
191,360
197,041
5,681
2.97%
City Clerk
108,312
128,861
134,775
148,338
147,450
155,608
155,608
164,293
8,685
5.58%
Elections
11,352
41,508
14,497
64,433
17,852
59,781
59,781
65,713
5,932
9.92%
Finance
215,215
230,639
240,319
252,563
258,883
278,660
278,660
291,912
13,252
4.76%
Assessing
144,561
145,051
146,315
146,473
147,915
154,000
150,000
154,000
0
0.00%
Information Services
135,982
146,984
131,744
151,387
149,512
180,597
180,597
188,090
7,493
4.15%
Planning &Zoning
349,489
387,308
406,045
414,141
398,780
438,827
438,827
460,749
21,922
5.000%
Engineering
452,788
460,872
464,843
511,074
511,183
553,765
553,765
578,729
24,964
4,51%
Facility Management
451,257
470,397
498,813
408,250
509,547
648,519
678,519
661.640
13.121
2.02%
PUBLICSAFETF
N Police Protection
2,740,899
2,818,132
2,918,308
2,936,467
2,962,551
3,053,526
3,053,526
3,183,610
130,084
4.26%
Fire Protection
1,126,979
1,264,018
1,165,223
1,285,417
1,353,209
1,423,914
1,423,914
1,474,623
50,709
3.56%
Protective inspection
423,495
390,908
391,951
424,247
443,712
462,164
462,164
481,374
19,210
4.16%
Emergency Management
13,930
21,836
24,352
17,495
16,320
32,502
32,502
29,220
(3,282)
-10.10%
Animal Control
6,037
4,026
3,498
3,700
2,544
5,950
5,950
5,950
0
0.00%
Total Public Safety
4,311,340
4,498,920
4,503,332
4,667,326
4,778,336
4,978,056
4,978,056
5,174,777
196,721
3.95%
PUBLIC WORKS
Streets and Highways
572,753
600,313
629,724
686,086
597,963
659,943
659,943
705,150
45,207
6.85%
Snow and lce Removal
630,799
637,154
442,078
468,173
449,881
562,706
562,706
588,372
25,666
4.56%
Street Signs
162,861
187,935
204,495
167,282
214,540
219,418
219,418
228,431
9,013
4.11%
Traffic Signals
26,241
34,901
30,170
27,919
36,151
37,000
37,000
39,500
2,500
6.76%
Street Lighting
31,702
32,646
30,664
37,089
27,735
40,400
40,400
40,400
0
0.00%
Street Lights - Billed
210,331
203,148
201,500
200,509
144,451
220,500
173,000
180,500
(40,000)
-18.14%
Park & Recreation
946,545
1,009,373
1,151,314
1,247,501
1,207,360
1,297,395
1,318,395
1,353,310
55,915
4.31%
Natural Resource Preservatiot
-
-
-
7,255
6,503
11,574
15,074
14,131
2,557
22.09%
Recycling
178,110
113,902
128,036
124,860
169,956
157,216
157,216
16$911
11.695
7.44%
OTHER 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 50,000 70.99%
Total Other 210,510 81,185 256,720 283,077 764,875 70,428 30,000 120,428 50,000 70.99%
GRAND TOTAL $ 9,590,074 S 9,881,404 S 10,090,003 $ 10,509,726 $ 11,039,974 $ 11,265,315 S 113227,612 $ 11,741,602 476,287 4.23%
CITY OF ANDOVER
Budget Worksheet -2019
General Fund
Cerzval Fund Rpl(ap
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries -Regular
2,655,718
2,803,831
2,773,604
2,952,184
2,961,024
3,458,929
3,458,929
3,579,693
60120
Salaries- Volunteer Fire Fighters
223,204
282,019
221,470
247,392
303,471
318,258
318,258
341,100
60130
Salaries -Election Judges
286
2],]30
-
44,771
-
-
-
60140
Salaries - Council/Commission
47,830
48,080
47,500
47,070
45,]90
48,700
48,700
48,700
60210
FICA
158,863
170,958
163,946
181,313
179,191
216,664
216,664
224,566
60220
Medicare
40,976
42,936
41,797
46,701
45,964
54,933
54,933
56,949
60310
Health Insurance
325,420
357,706
363,908
398,765
418,192
480,440
480,440
546,200
60320
Dental insurance
16,458
16,633
17,025
17,343
16,897
21,680
21,680
21,450
60330
Lek Insurance
1,187
1,051
955
865
826
900
900
900
60340
Long -Tenn Disability
6,819
6,794
5,839
6,243
6,466
8,742
8,742
9,044
60410
P)18A
195,780
205,411
214,884
235,297
235,298
284,587
284,587
297,093
60420
Nationavide Retirement
3,222
6,244
7,187
7,590
7,722
2,000
2,000
2,000
60520
Workers Comp
101,810
109,425
113,008
111,729
152,719
174,636
174,636
179,629
60540
Relief Association
203,555
206,491
220,332
222,844
222,893
220,000
220,000
220,000
60990
Iater-City Labor Allocation
-
-
-
(351,550)
(351,550)
(365,342)
Salaries&Benefits
3,981,128
4,285,309
4,191,455
4,520,107
4,596453
4,938919
4,938,919
5,161,982
Departmental
61005
Supplies - Gerard
18,425
21,485
26,428
26,078
26,741
31,450
31,300
33,500
61010
Supplies -Printed Forms
682
353
665
333
564
1,000
1,000
1,000
61015
Supplies - Training
-
-
089
2,035
8,537
4,000
4,000
6,000
61020
Supplies -Operating
117,986
136,373
88,789
99,034
88,421
108,840
108,840
108,140
61025
Supplies - Clearing
3,471
3,211
4,207
4,074
5,805
10,100
10,100
10,100
61030
Supplies - Signs
20,394
31,955
29,658
9,706
40,098
37,500
37,500
40,000
61060
Supplies- Fre Preveation/Educatic
-
-
1,270
1,027
2,609
4,500
4,500
4,500
61105
R& M Supplies- General
24,411
22,311
21,866
24,471
17,200
23,000
23,000
31,000
61120
R& M Supplies - Building
17,331
10,358
8,998
8,771
9,663
27,500
27,500
22,500
61125
R& M Supplies - Streets
214,062
180,705
130,270
140,294
154,955
165,000
165,000
180,000
61130
R& M Supplies - Landscape
25,326
41,006
43,670
38,103
31,207
40,000
40,000
40,000
61205
Small &Expend - Small Tools
11,034
10,410
22,780
17,099
14,271
21,200
21,200
25,200
61210
Small&Expend - Office Equipm
2,780
3,547
2,795
3,929
7,300
7,000
7,000
7,000
61220
Software
1,048
7,079
839
6,023
2,405
5,200
5,200
5,200
61225
Technology Upgrades
9,608
21,618
4,613
8,404
13,695
13,000
13,000
13,000
61245
Items for Resale
36,285
35,335
24,789
22,484
--
-
61305
Uniforms
42
35,000
35,000
40,000
61310
Meals/Lodging
4,949
6,371
6,605
5,148
10,419
13,420
13,420
14,920
61315
Continuing Education
35,000
31,623
27,489
24,472
31,017
39,755
39,780
46,655
61320
Atmuel Dues/Licenses
41,679
41,793
43,580
44,149
44,121
63,484
63,684
64,793
61325
Subscriptions/Publications
2,962
2,927
1,388
2,804
2,833
2,479
2,479
2,479
61405
Postage
16,084
19,550
20,409
22,506
22,644
28,910
28,610
29,210
61410
Transportation/Mileage
9,063
8,047
7,102
8,210
9,250
11,085
11,035
11,885
Departmental
614,201
656,818
575,178
5]1,168
581 197
693,423
693,148
737,082
Operating
62005
Electric
331,333
323,302
334,837
329,983
281,947
371,550
324,050
332,050
62010
Water& Sewer Service
58,631
37,357
57,287
48,666
50,356
65,500
65,500
65,500
62015
Natural Gas
51,270
65,102
48,268
31,943
38,532
70,950
70,950
70,950
62020
Refuse Collection
20,461
20,823
22,233
26,421
30,598
26,500
26,500
34,800
62025
Storm Water Utility Charge
4,995
4,006
7,011
5,925
6,220
7,050
7,050
7,050
62030
Telephone
48,819
41,685
45,455
45,393
43,423
71,050
71,050
63,900
62100
insurance
139,731
139,731
144,012
143,923
143,923
144,303
144,303
144,303
62200
Rentals
37,719
30,786
28,833
37,641
29,236
48,000
48,000
50,500
62205
Central Equipment Services
505,300
505,300
520,766
520,460
504,866
504,866
504,866
504,866
62300
Equipment Maintenance Contract
32,006
36,804
42,427
42,399
48,732
57,940
57,940
60,040
62305
Software Maintenance Contracts
44,977
38,811
47,586
65,472
66,390
90,500
90,500
96,550
Operating
1,2]5 242
1,243,707
1,298,715
1,298 226
1,244,223
1,458,209
1,410 709
1,430,509
Professional Services
63005
Professional Services
232,859
225,490
220,879
224,002
232,994
255,600
255,100
257,600
63010
Contractual Services
2,928,519
3,044,033
3,157,668
3,176,621
3,238,555
3,344,976
3,350,976
3,476,360
63015
Attorney
173,2!4
177,427
180,313
184,990
188,644
191,360
191,360
197,041
63025
Publishing
4,941
5,395
11,298
13,098
10,398
14,600
14,600
15,600
63030
Printing
10,877
11,726
10,922
12,009
12,290
13,450
13,450
14,950
63100
R& M LaborGeneral36,933
55,479
41,644
23,036
15,674
54,300
54,300
52,000
63105
R& M LaborBuilding63,497
90,419
127,645
67,528
70,774
103,950
133,950
129,950
63110
R& M labor - Streets
-
1,404
400
-
2,000
2,000
4,000
63215
Recording Fee
1,766
690
819
460
544
600
600
600
63300
Improvements - Streets
1,630
3,419
13,983
7,790
8,146
13,000
13,000
13,00
63900
Misceflaneous
42,678
44,459
32,702
21,237
4,822
40,600
18,000
40,600
63905
Cmaingen,
33,045
37,033
25,378
12,253
10,350
40,328
22,500
90,328
Professional Services
3,529 989
3,695 570
3,824,655
3,743 424
3,793,191
4,074 764
4,069,836
4,292,029
Capital Outlay
65200
Building
54,514
-
-
-
-
-
_
65300
Improvements
-
-
-
126,801
74,910
100,000
115,000
120,000
65600
Equipment
Capital Outlay
54,514
-
-
126,801
74,910
100,000
115,000
120,000
Other Financing Uses
67101
Operating Transfers Out
135,000
200,000
250,000
750,000
Other Financing Uses
135,000
200,000
250,Oo0
750,000
Total
9,590,074
9,891,404
10,090,003
105W.Y26
11,039974
11,265,315
11,227,612
11,741,602
22
C= OF ANDOVER
Budget Worksheet - 2019
Function: General Government
General GovernmentRollup
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries -Regular
946,978
1,026,717
1,052,692
1,132,287
1,186,505
1,803,417
1,803,417
1,870,678
60130
Salaries - Election Judges
286
27,730
-
44,771
-
-
60140
Salaries - Council/Commission
44,170
44,440
43,780
43,660
42,450
45,100
45,100
45,100
60210
FICA
57,006
61,217
63,059
69,856
71,237
112,289
112,289
116,152
60220
Medicare
14,531
14,396
14,872
16,606
16,763
26,262
26,262
27,166
60310
Health Insurance
123,141
133,053
135,822
156,400
163,586
234,980
234,980
275,200
60320
Dental Insurance
5,131
5,392
6,309
6,417
5,956
10,298
10,298
9,900
60330
Life Insurance
183
175
155
156
169
420
420
420
60340
Long -Terra Disability
2,596
2,433
2,206
2,379
2,593
4,592
4,592
4,754
60410
PERA
67,812
73,312
78,120
85,661
89,474
134,856
134,856
140,093
60420
Nationwide Retirement
1,000
1,282
1,293
1,387
1,440
2,000
2,000
2,000
60520
Workers Comp
35,644
36,952
38,292
29,649
43,417
63,577
63,577
65,822
60990
Inter -City Labor Allocation
-
-
-
-
(669,672)
(669,672)
(701,8 93)
Salaries & Benefits
1,298,478
1,427,099
1,436,600
1,589,229
1,623,590
1,768,119
1,768 119
1,855,392
Departmental
61005
Supplies -General
13,090
15,182
17,162
15,214
13,566
20,000
19,850
19,000
61020
Supplies -Operating
(146)
(759)
1,994
(382)
856
6,790
6,790
6,790
61025
Supplies -Cleaning
3,216
2,456
3,858
3,288
4,097
7,100
7,100
7,100
61120
R & M Supplies - Building
17,331
10,358
8,998
8,771
9,663
27,500
27,500
22,500
61205
Small&Expend - Small Tools
7,526
5,066
8,532
4,009
2,455
6,200
6,200
6,200
61210
Small & Expend - Office Equipe
2,780
3,547
2,795
3,929
7,300
7,000
7,000
7,000
61220
Software
1,048
409
839
863
1,644
1,200
1,200
1,200
61225
Technology Upgrades
9,608
24,618
4,613
8,404
13,695
13,000
13,000
13,000
61245
Items for Resale
36,285
35,335
24,789
22,484
-
61310
Meals/Lodging
2,717
3,264
3,759
3,292
3,327
5,570
5,570
5,970
61315
Continuing Education
4,452
7,349
3,465
5,137
4,661
12,755
12,780
14,155
61320
Annual Dues/Licenses
36,512
37,221
38,540
37,573
35,401
50,774
50,974
50,883
61325
Subscriptions/Publications
839
750
912
1,084
514
979
979
979
61405
Postage
10,225
16,285
16,442
17,529
17,446
22,410
22,110
23,210
61410
Transportation/Mileage
5,444
5,255
5,419
5,675
5,093
7,310
7,260
8,110
Departmental
150,927
166,336
142,117
136,870
119,718
188,588
188,313
186,097
Operating
62005
Electric
65,019
60,534
70,233
64,583
69,392
79,750
79,750
79,750
62010
Water& Sewer Service
24,783
15,275
20,730
18,387
16,017
27,500
27,500
27,500
62015
Natural Gas
50,884
64,478
47,877
31,589
38,164
69,750
69,750
69,750
62020
Refuse Collection
6,323
10,442
10,129
12,851
12,472
13,800
13,800
14,300
62025
Storm Water Utility Charge
4,077
3,267
5,731
4,839
5,081
5,850
5,850
5,850
62030
Telephone
40,898
29,665
32,298
30,949
29,658
55,550
55,550
46,300
62100
Insurance
76,076
76,076
78,447
78,358
78,358
78,358
78,358
78,358
62200
Rentals
15,219
14,863
7,442
9,965
11,107
14,750
14,750
14,750
62205
Central Equipment Services
16,429
16,429
16,922
16,922
16,414
16,414
16,414
16,414
62300
Equipment Maintenance Contrac
11,062
15,899
22,748
22,561
28,520
30,940
30,940
32,940
62305
Software Maintenance Contracts
39,338
34,831
40,480
46,737
43,664
53,600
53,600
59,050
Operating
350,108
341,759
353,037
337,741
348,847
446,262
446,262
444,962
Professional Services
63005
Professional Services
184,642
184,686
183,635
183,963
185,773
202,400
198,400
203,900
63010
Contractual Services
70,802
77,377
71,726
74,838
88,968
80,450
80,450
80,600
63015
Attorney
173,244
177,427
180,313
184,990
188,644
191,360
191,360
197,041
63025
Publishing
3,371
3,799
3,615
2,922
2,778
4,100
4,100
4,100
63030
Printing
10,877
11,726
10,922
12,009
12,290
12,950
12,950
12,950
63100
R & M Labor -General
957
302
181
1,686
1,400
1,400
1,600
63105
R& M Labor -Building
63,497
90,419
127,645
67,528
70,774
103,950
133,950
129,950
63215
Recording Fee
1,766
690
819
460
544
600
600
600
63900
Miscellaneous
213
307
1,360
413
297
10,500
10,500
10,500
Professional Services
509,369
546,733
580,216
528,809
550,068
607,710
633,710
641,241
Capital Outlay
65600
Equipment
_
_
Capital Outlay
_
-
Total 2,308 882
2,481,927
2,511,970
2,592,649
2,642,223
3,010 679
3,036,404
3,127,692
23
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government City Council -41100
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number _ Description 2013 2014 2015 2016 2017 2018 2018 2019
24 04/2018
Salaries & Benefits
60140
Salaries - Council/Commission
39,770
39,710
39,770
41,090
39,500
39,500
39,500
39,500
60210
FICA
-
2,465
2,461
2,465
2,547
2,448
2,449
2,449
2,449
60220
Medicare
576
576
576
596
573
574
574
574
60410
PERA
1,232
1,232
712
743
712
2,402
2,402
2,965
Salaries & Benefits
44,043
43,979
43,523
44,976
43,233
44,925
44,925
45,488
Departmental
61005
Supplies - General
191
778
436
443
230
400
400
400
61310
Meals/Lodging
1,223
1,600
1,945
1,412
1,481
1,900
1,900
1,900
61315
Continuing Education
260
1,030
675
690
-
1,800
1,800
3,000
61320
Annual Dues / Licenses
26,243
26,363
26,755
27,044
28,468
28,294
28,294
28,294
61410
Transportation/Mileage
555
391
848
1,327
286
1,200
1,200
1,500
Departmental
28,472
30,162
30,659
30,916
30,465
33,594
33,594
35,094
Operating
62030
Telephone
878
767
604
876
876
1,000
1,000
1,000
62100
Insurance
1,727
1,727
1,868
1,779
1,779
1,779
1,779
1,779
Operating2,605
2,494
2,472
2,655
2,655
2,779
2,779
2,779
Professional Services
63005
Professional Services
8,475
8,015
8,406
8,442
7,783
10,000
10,000
10,000
63025
Publishing
_
_
Professional Services
8,475
8,015
8,406
8,442
7,783
10,000
10,000
10,000
Total
83,595
84,650
85,060
86,989
84,136
91,298
91,298
93,361
24 04/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government Administration - 47200
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
25 8/24/2018
Salaries & Benefits
60110
Salaries -Regular
96,940
113,485
115,547
128,172
127,743
206,198
206,198
212,818
60210
FICA
5,261
6,099
6,228
6,854
7,038
12,784
12,784
13,195
60220
Medicare
1,314
1,503
1,572
1,815
1,746
- 2,990
2,990
3,086
60310
Health Insurance
7,889
10,746
11,048
11,893
11,894
14,500
14,500
17,400
60320
Dental Insurance
322
401
410
434
422
542
542
550
60330
Life Insurance
9
11
10
10
10
40
40
40
60340
Long -Term Disability
175
225
196
208
202
536
536
554
60410
PERA
7,052
8,110
8,644
9,945
9,582
15,465
15,465
15,962
60420
Nationwide Retirement
1,000
1,282
1,293
1,387
1,440
2,000
2,000
2,000
60520
Workers Comp
3,814
4,031
4,168
3,323
4,674
7,423
7,423
7,662
60990
Inter -City Labor Allocation
-
-
-
(85,813)
(85,813)
(83,868)
Salaries &Benefits123,776
145,893
149,116
164,041
164,751
176,665
176,665
189,399
Departmental
61005
Supplies- General
1,653
1,913
1,742
1,091
1,997
1,800
1,800
1,800
61310
Meals / Lodging
772
646
782
746
607
1,000
1,000
1,000
61315
Continuing Education
1,057
1,213
1,150
1,865
645
2,200
2,200
2,200
61320
Annual Dues Licenses
769
288
212
513
659
1,850
1,850
1,850
61325
Subscriptions Publications
392
204
220
547
-
61405
Postage
1,035
829
675
448
469
1,100
1,100
1,100
61410
Transportation/Mileage
1,817
1,812
1,800
1,805
1,835
2,000
2,000
2,000
Departmental
7,495
6,905
6,581
7,015
6,212
9,950
9,950
9,950
Operating
62030
Telephone
936
1,049
845
1,066
833
1,500
1,500
1,500
62100
Insurance
15,260
15,260
15,718
15,718
15,718
15,718
15,718
15,718
62300
Equipment Maintenance Contra
36
36
36
36
Operating
16,232
16,345
16,599
16,820
16,551
17,218
17,218
17,218
Professional Services
63005
Professional Services
-
75
_
-
-
63015
Attorney
_
_
_
-
Professional Services
-
75
_
Total
147,503
169,218
172,296
187,876
187,514
203,833
203,833
216,567
25 8/24/2018
CITY OF ANDOVER
Budget Worksheet -2019
Function: General Government Newsletter -41210
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
Departmental
61405 Postage
6,800
10,120
10,120
11,775
12,997
14,000
14,000
14,800
Departmental
6,800
10,120
10,12011,775
12,997
14,000
14,000
14,800
Professional Services
63030 Printing
10,877
10,854
10,922
10,956
12,290
12,000
12,000
12,000
Professional Services
10,877
10,854
10,922
10,956
12,290
12,000
12,000
12,000
Total
17,677
20,974
21,042
22,731
25,287
26,000
26,000
26,800
26 8/24/2018
Function: General Government
Account
Number Description
CITY OF ANDOVER
Budget Worksheet - 2019
Actual Actual Actual Actual Actual
2013 2014 2015 2016 2017
Human Resources - 41230
Budget Estimate Requested
2018 2018 2019
27
8/24/2018
Salaries & Benefits
60110
Salaries - Regular
6,652
2,367
2,277
3,409
3,474
105,920
105,920
108,941
60210
FICA
126
135
130
204
204
6,567
6,567
6,754
60220
Medicare
29
31
30
48
48
1,536
1,536
1,580
60310
Health Insurance
346
413
445
505
618
14,500
14,500
17,400
60320
Dental Insurance
11
12
16
18
23
542
542
550
60330
Life Insurance
1
I
I
I
1
60340
Long -Term Disability
7
8
7
9
10
20
275
20
275
20
283
60410
PERA
159
171
170
260
260
7,944
7,944
8,171
60520
Workers Comp
2,355
2,390
2,450
89
127
3,813
3,813
3,922
60990
Inter -City Labor Allocation
-
-
-
-
(136,340)
(136,340)
(142,628)
Salaries & Benefits
9,686
5,528
5,526
4,543
4,765
4,777
4,777
4,993
Departmental
61005
Supplies - General
452
1,241
331
773
659
900
750
900
61310
Meals/Lodging
356
370
408
329
409
450
450
450
61315
Continuing Education
360
512
445
674
1,396
975
1,000
975
61320
Annual Dues Licenses
529
844
1,164
1,004
1,063
800
1,000
800
61325
Subscriptions / Publications
417
437
437
479
479
479
479
479
61405
Postage
(57)
49
28
29
38
300
300
61410
Transportation/Mileage
308
367
486
54
279
400
350
400
Departmental
2,365
3,820
3,299
3,342
4,323
4,304
4,029
4,304
Operating
62305
Software Maintenance Contract, ---i,5
ig
3,924
3,645
3,735
3,923
4,100
4,100
4,250
Operating
3,519
3,924
3,645
3,735
3,923
4,100
4,100
4,250
Professional Services
63005
Professional Services
2,124
3,481
2,053
1,098
1,903
4,250
4,250
4,250
63025
Publishing
-
978
25
273
309
500
500
500
63900
Miscellaneous
213
307
1,360
413
297
10,500
10,500
10,500
Professional Services
2,337
4,766
3,438
1,784
2,509
15,250
15,250
15,250
Total
17,907
18,038
15,908
13,404
15,520
28,431
28,156
28,797
27
8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government
Account Actual Actual Actual Actual Actual Budget
Number _ Description 2013 2014 2015 2016 2017 2018
Professional Services
63015 Attorney
Professional Services
Total
Attorney - 41240
Estimate Requested
2018 2019
173,244
177,427
180,313
184,990
188,644
191,360
191,360
197,041
173,244
177,427
180,313
184,990
188,644
191,360
191,360
197,041
173,244
177,427
180,313
184,990
188,644
191,360
191,360
197,041
28
8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government
City Clerk - 41300
Account
Number
Description
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
60210
Salaries -Regular
FICA
61,979
79,396
83,651
89,791
89,797
140,852
140,852
151,933
60220
Medicare
3,966
927
4,615
4,911
5,466
5,292
6,414
6,414
6,795
60310
Health Insurance
7,107
1,079
7,982
1,148
8,541
1,278
1,238
1,500
1,500
1,589
60320
Dental Insurance
288
289
559
14,584
494
12,830
14,500
14,500
17,400
60330
Life Insurance
12
12
10
11
432
11
542
542
550
60340
Long -Term Disability
113
119
106
127
132
40
269
40
269
40
60410
60520
PERA
Workers Comp
4,977
1,654
5,719
6,257
6,813
6,737
7,759
7,759
285
8,220
60990
Inter -City Labor Allocation
-
2,107
2,244
2,467
3,582
3,725
3,725
3,946
Salaries &Benefits
81,023
-
101,318
-
107,427
121,031
120,051
(48,180)
127,421
(48,180)
127,421
(54,652)
136,106
Departmental
61005
Supplies -General
258
313
232
152
325
600
600
61310
Meals/Lodging
297
277
230
298
297
350
350
600
61315
Continuing Education
-
350
61320
Annual Dues/Licenses
430
-
560
-
470
470
200
240
200
500
200
200
61405
Postage
118
424
439
469
293
160
500
160
500
160
61410
Transportation/Mileage
95
160
87
91
67
300
Departmental
1,198
1,734
1,458
1,480
1,422
2,110
300
2,110
300
2,110
Operating
62030
Telephone
890
689
(5)
-
62100
62305
Insurance
Software Maintenance Contract
24,929
200
24,929
25,677
25,677
25,677
25,677
25,677
25,677
Operating
26,019
150
25,768
150
25,822
150
25,827
I50
25,827
200
25,877
200
25,877
200
25,877
Professional Services
63025
Publishing
72
41
68
-
150
63030
Printing
-
-
63215
Recording Fee
_
-
_
-
-
200
200
200
Professional Services72
41
68
-
150
200
200
200
Total
108,312
128,861
134,775
148,338
147,450
155,608
155,608
164,293
29
8/24/2018
Function: General Government
Account
Number Description
CITY OF ANDOVER
Budget Worksheet - 2019
Actual Actual Actual Actual
2013 2014 2015 2016
Elections - 41310
Actual Budget Estimate Requested
2017 2018 2018 2019
30 8/24/2018
Salaries & Benefits
60110
Salaries - Regular
4,927
5,685
5,423
7,965
8,077
60130
Salaries - Election Judges
286
27,730
-
44,771
-
60210
FICA
67
325
314
477
474
_
60220
Medicare
_ 1,207
76
74
112
Ill
_
60310
Health Insurance
49
1,439
1,375
1,555
1,436
_
60320
Dental Insurance
1
53
46
54
47
60330
Life Insurance
13
2
1
I
1
60340
Long -Term Disability
354
15
12
17
IS
_
60410
PERA
-
410
406
612
602
-
60990
Inter -City Labor Allocation
-
-
Salaries &Benefits
6,904
35,735
-
7,651
55,564
10,763
49,931
49,931
49,931
55,713
49,931
55,713
Departmental
61005
Supplies - Genera]
-
52
96
259
-
_
61020
supplies -Operating
-
53
-
41
-
840
840
840
61405
61410
Postage
Transportation / Mileage
-
-
-
32
-
483
-
1,000
1,000
1,000
Departmental
137
96
99
882
-
160
160
160
2,000
2,000
2,000
Professional Services
63010
Contractual Services
4,448
4,764
6,750
6,934
7,089
7,100
7,100
7,250
63030
Printing
-
872
-
1,053
-
750
750
750
Professional Services
4,448
5,636
6,750
7,987
7,089
7,850
7,850
8,000
Total
11,352
41,508
14,497
64,433
17,852
59,781
59,781
65,713
30 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government Finance - 41400
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
31 8/24/2018
Salaries & Benefits
60110
Salaries - Regular
128,362
135,962
143,214
152,791
156,617
259,325
259,325
267,097
60210
FICA
7,465
7,429
7,823
8,999
8,993
16,077
16,077
16,560
60220
Medicare
1,658
1,734
1,830
2,105
2,103
3,760
3,760
3,873
60310
Health Insurance
18,563
21,320
21,894
22,769
23,037
36,500
36,500
43,800
60320
Dental Insurance
679
764
913
947
934
1,626
1,626
1,650
60330
Life Insurance
27
27
23
24
23
60
60
60
60340
Long -Term Disability
346
373
330
366
371
675
675
694
60410
PERA
9,257
9,784
10,702
11,840
11,742
19,450
19,450
20,033
60520
Workers Comp
5,348
5,427
5,569
3,945
5,731
9,336
9,336
9,615
60990
Inter -City Labor Allocation
-
-
(125,695)
(125,695)
(131,716)
Salaries & Benefits
171,705
182,820
192,298
203,786
209,551
221,114
221,114
231,666
Departmental
61005
Supplies - General
1,619
2,634
3,032
2,891
1,492
3,500
3,500
3,500
61220
Software
180
169
169
169
344
200
200
200
61310
Meals / Lodging
-
-
-
-
-
250
250
250
61315
Continuing Education
-
825
40
-
-
750
750
750
61320
Annual Dues/Licenses
370
495
675
575
370
750
750
750
61405
Postage
(362)
1,824
1,839
1,916
1,735
2,250
2,250
2,250
61410
Transportation / Mileage
228
230
184
174
129
400
400
400
Departmental
2,035
6,177
5,939
5,725
4,070
8,100
8,100
8,100
Operating
62030
Telephone
240
590
717
713
769
1,000
1,000
1,000
62100
Insurance
190
190
196
196
196
196
196
196
62305
Software Maintenance Contract
17,929
17,762
18,583
19,048
20,000
20,500
20,500
22,000
Operating
18,359
18,542
19,496
19,957
20,965
21,696
21,696
23,196
Professional Services
63005
Professional Services
22,631
22,583
22,035
22,506
23,772
26,650
26,650
27,650
63025
Publishing
485
517
551
589
525
800
800
800
63100
R & M Labor -General
-
-
-
-
300
300
500
Professional Services
23,116
23,100
22,586
23,095
24,297
27,750
27,750
28,950
Total
215,215
230,639
240,319
252,563
258,883
278,660
278,660
291,912
31 8/24/2018
CITY OF ANDOVER
Budget Worksheet -2019
Function: General Government
Assessing - 41410
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number Description
2013
2014
2015
2016
2017
2018
2018
2019
Professional Services
63005 Professional Services
144,561
145,051
146,315
146,473
147,915
154,000
150,000
154,000
Professional Services
144,561
145,051
146,315
146,473
147,915
154,000
150,000
154,000
Total
144,561
145,051
146,315
146,473
147,915
154,000
150,000
154,000
32 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government Information Services - 41420
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
33 8/24/2018
Salaries & Benefits
60110
Salaries -Regular
70,719
74,293
77,838
82,406
83,996
94,969
94,969
97,679
60210
FICA
4,036
4,567
4,802
5,277
5,198
5,888
5,888
6,056
60220
Medicare
944
1,068
1,123
1,234
1,216
1,377
1,377
1,416
60310
Health Insurance
11,092
6,451
6,594
6,696
6,888
7,500
7,500
9,000
60320
Dental Insurance
453
447
421
435
435
542
542
550
60330
Life Insurance
13
13
11
11
11
20
20
20
60340
Long -Term Disability
186
192
174
203
207
247
247
254
60410
PERA
5,089
5,348
5,818
6,392
6,297
7,123
7,123
7,326
60520
Workers Comp
1,845
2,020
2,132
2,134
3,074
3,419
3,419
3,516
60990
Inter -City Labor Allocation
-
-
-
(10,308)
(10,308)
(10,697)
Salaries & Benefits
94,377
94,399
98,913
104,788
107,322
110,777
110,777
115,120
Departmental
61005
Supplies- General
2,571
1,570
2,787
3,978
3,003
4,300
4,300
4,300
61020
Supplies -Operating
(2,142)
(2,289)
(2,116)
(2,999)
(2,414)
-
-
-
61210
Small & Expend - Office Equipi
2,780
3,547
2,795
3,929
7,300
7,000
7,000
7,000
61225
Technology Upgrades
9,608
24,618
4,613
8,404
13,695
13,000
13,000
13,000
61310
Meals / Lodging
-
-
-
16
-
-
_
-
61315
Continuing Education
110
149
-
-
-
2,000
2,000
2,000
61320
Annual Dues / Licenses
5,895
4,932
6,602
4,073
1,891
14,970
14,970
14,970
61405
Postage
82
62
83
131
68
200
200
200
61410
Transportation/Mileage
411
265
136
236
219
150
150
250
Departmental
19,315
32,854
14,900
17,768
23,762
41,620
41,620
41,720
Operating
62030
Telephone
1,128
880
1,083
1,479
1,254
1,200
1,200
1,450
62200
Rentals
6,888
6,692
-
2,584
3,101
4,000
4,000
4,000
62305
Software Maintenance Contracn12,173
10,284
15,723
21,424
12,589
21,000
21,000
23,300
Operating
20,189
17,856
16,806
25,487
16,944
26,200
26,200
28,750
Professional Services
63005
Professional Services
2,101
1,875
1,125
3,094
1,484
1,500
1,500
2,000
63100
R & M Labor - General
-
-
250
500
500
500
Professional Services
2,101
1,875
1,125
3,344
1,484
2,000
2,000
2,500
Total
135,982
146,984
131,744
151,387
149,512
180,597
180,597
188,090
33 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government Planning & Zoning - 41500
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
34 8/24/2018
Salaries & Benefits
60110
Salaries -Regular
242,808
270,842
283,989
293,168
283,554
299,842
299,842
313,500
60140
Salaries - Council/Commission
4,400
4,730
4,010
2,570
2,950
5,600
5,600
5,600
60210
FICA
14,009
15,462
16,367
17,617
16,423
18,938
18,938
19,784
60220
Medicare
3,276
3,616
3,828
4,120
3,841
4,429
4,429
4,627
60310
Health Insurance
38,307
44,070
47,385
47,956
40,045
45,480
45,480
47,800
60320
Dental Insurance
1,749
1,748
1,957
1,939
1,523
2,168
2,168
1,650
60330
Life Insurance
51
50
48
47
49
80
80
80
60340
Long -Term Disability
637
677
661
653
688
780
780
815
60410
PERA
17,438
19,374
21,250
21,599
21,181
22,488
22,488
23,512
60520
Workers Comp
6,974
6,997
7,348
7,846
10,376
10,794
10,794
11,286
60990
Inter -City Labor Allocation
-
-
-
-
3,780
3,780
7,538
Salaries &Benefiu
329,649
367,566
386,843
397,515
380,630
414,379
414,379
436,192
Departmental
61005
Supplies - General
1,678
2,330
1,773
1,486
2,340
3,000
3,000
2,000
61020
Supplies - Operating
-
61
252
287
564
-
61310
Meals / Lodging
-
15
14
-
277
820
820
1,220
61315
Continuing Education
295
135
60
83
885
1,330
1,330
1,530
61320
Annual Dues/Licenses
760
940
720
1,485
879
1,610
1,610
1,719
61405
Postage
1,874
2,469
1,895
1,409
1,186
2,000
2,000
2,000
61410
Transportation / Mileage
-
179
400
400
800
Departmental
4,607
5,950
4,714
4,750
6,310
9,160
9,160
9,269
Operating
62030
Telephone
1,364
1,511
1,182
1,407
1,177
1,500
1,500
1,500
62100
Insurance
305
305
314
314
314
314
314
314
62200
Rentals
1,094
1,327
1,200
1,100
1,001
1,500
1,500
1,500
62205
Central Equipment Services
3,978
3,978
4,097
4,097
3,974
3,974
3,974
3,974
62305
Software Maintenance Contract.
314
250
250
250
250
300
300
300
Operating7,055
7,371
7,043
7,168
6,716
7,588
7,588
7,588
Professional Services
63005
Professional Services
4,071
3,606
3,701
2,350
2,916
4,000
4,000
4,000
63025
Publishing
2,801
2,263
2,971
1,898
1,794
2,800
2,800
2,800
63100
R & M Labor - General
-
-
-
-
-
300
300
300
63215
Recording Fee
1,306
552
773
460
414
600
600
600
Professional Services
8,178
6,421
7,445
4,708
5,124
7,700
7,700
7,700
Total
349,489
387,308
406,045
414,141
398,780
438,827
438,827
460,749
34 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government Engineering - 41600
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
35 8/24/2018
Salaries & Benefits
60110
Salaries -Regular
316,530
323,270
326,861
360,773
357,895
620,622
620,622
638,528
60210
FICA
18,499
18,823
19,175
21,565
20,834
38,479
38,479
39,588
60220
Medicare
4,340
4,409
4,493
5,099
4,873
8,999
8,999
9,258
60310
Health Insurance
38,658
39,087
37,278
49,720
51,136
87,500
87,500
105,000
60320
Dental Insurance
1,628
1,676
1,963
2,087
2,089
3,794
3,794
3,850
60330
Life Insurance
57
58
50
51
51
140
140
140
60340
Long -Term Disability
774
817
716
794
792
1,613
1,613
1,661
60410
PERA
22,345
22,853
23,926
27,377
26,826
46,548
46,548
47,890
60520
Workers Comp
13,654
13,980
14,381
9,412
13,096
22,342
22,342
22,988
60990
Inter -City Labor Allocation
-
-
-
(322,645)
(322,645)
(337,047)
Salaries & Benefits
416,485
424,973
428,843
476,878
477,592
507,392
507,392
531,856
Departmental
61005
Supplies- General
4,668
4,351
6,733
4,141
3,520
5,500
5,500
5,500
61205
Small & Expend - Small Tools
181
1,086
771
329
1,531
2,200
2,200
2,200
61220
Software
868
240
670
694
1,300
1,000
1,000
1,000
61310
Meals/Lodging
69
356
380
491
256
800
800
800
61315
Continuing Education
2,370
3,485
1,095
1,825
1,535
3,500
3,500
3,500
61320
Annual Does Licenses
1,053
1,833
1,479
1,946
1,686
2,000
2,000
2,000
61325
Subscriptions Publications
30
109
255
58
35
500
500
500
61405
Postage
735
508
1,363
869
660
1,400
1,400
1,400
61410
Transportation/Mileage
2,030
1,998
1,878
1,889
2,099
2,300
2,300
2,300
Departmental
12,004
13,966
14,624
12,242
12,622
19,200
19,200
19,200
Operating
62030
Telephone
4,076
5,233
4,843
5,304
5,020
6,100
6,100
6,600
62100
Insurance
323
323
333
333
333
333
333
333
62200
Rentals
1,094
1,327
1,200
1,200
1,001
1,500
1,500
1,500
62205
Central Equipment Services
12,451
12,451
12,825
12,825
12,440
12,440
12,440
12,440
62305
Software Maintenance Contract
5,203
2,461
2,129
2,130
2,045
4,500
4,500
4,500
Operating
23,147
21,795
21,330
21,792
20,839
24,873
24,873
25,373
Professional Services
63005
Professional Services
679
-
-
-
-
2,000
2,000
2,000
63025
Publishing
13
-
-
162
-
_
63100
R & M Labor - General
-
300
300
300
63215,
Recording Fees
460
138
46
130
Professional Services
1,152
138
46162
130
2,300
2,300
2,300
Total
452,788
460,872
464,843
511,074
511,183
553,765
553,765
578,729
35 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government Faciltiy Mgmt Rollup - 41900
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number _ Description 2013 2014 2015 2016 2017 2018 2018 2019
36 8/24/2018
Salaries & Benefits
60110
Salaries -Regular
18,061
21,417
13,892
13,812
-75,352
75,689
75,689
80,182
60210
FICA
1,112
1,301
844
850
4,333
4,693
4,693
4,971
60220
Medicare
260
304
198
199
1,014
1,097
1,097
1,163
60310
Health Insurance
1,130
1,545
1,262
722
15,702
14,500
14,500
17,400
60320
Dental Insurance
-
2
24
9
51
542
542
550
60330
Life Insurance
-
I
1
-
12
20
20
20
60340
Long -Term Disability
4
7
4
2
176
197
197
208
60410
PERA
263
311
235
80
5,535
5,677
5,677
6,014
60520
Workers Comp
-
-
-
433
2,757
2,725
2,725
2,887
60990
Inter -City Labor Allocation
-
-
-
5,598
5,598
(4,536)
Salaries & Benefits
20,830
24,888
16,460
16,107
104,932
110,738
110,738
108,859
Departmental
61005
Supplies - General
-
-
-
-
-
_
-
61020
Supplies - Operating
1,996
1,416
3,858
2,289
2,706
5,950
5,950
-
5,950
61025
Supplies- Cleaning
3,216
2,456
3,858
3,288
4,097
7,100
7,100
7,100
61120
R & M Supplies - Building
17,331
10,358
8,998
8,771
9,663
27,500
27,500
22,500
61205
Small & Expend - Small Tools
7,345
3,980
7,761
3,680
924
4,000
4,000
4,000
61245
Items for Resale
36,285
35,335
24,789
22,484
-
-
-
-
61320
Annual Dues / Licenses
463
966
463
463
145
-
Departmental
66,63654,511
49,727
40,975
17,535
44,550
44,550
39,550
Operating
62005
Electric
65,019
60,534
70,233
64,583
69,392
79,750
79,750
79,750
62010
Water & Sewer Service
24,783
15,275
20,730
18,387
16,017
27,500
27,500
27,500
62015
Natural Gas
50,884
64,478
47,877
31,589
38,164
69,750
69,750
69,750
62020
Refuse Collection
6,323
10,442
10,129
12,851
12,472
13,800
13,800
14,300
62025
Storm Water Utility Charge
4,077
3,267
5,731
4,839
5,081
5,850
5,850
5,850
62030
Telephone
31,386
18,946
23,029
20,104
19,729
43,250
43,250
33,250
62100
Insurance
33,342
33,342
34,341
34,341
34,341
34,341
34,341
34,341
62200
Rentals
6,143
5,517
5,042
5,081
6,004
7,750
7,750
7,750
62300
Equipment Maintenance Contra.
11,026
15,863
22,712
22,525
28,520
30,940
30,940
32,940
62305
Software Support Contract
-
-
-
4,707
3,000
3,000
4,500
Operating
232,983
227,664239,824
214,300
234,427
315,931
315,931
309,931
Professional Services
63010
Contractual Services
66,354
72,613
64,976
67,904
81,879
73,350
73,350
73,350
63100
R & M Labor - General
957
302
181
1,436
-
-
63105
R & M Labor - Building
63,497
90,419
127,645
67,52870,774
103,950
133,950
129,950
Professional Services
130,808
163,334
192,802
136,868
152,653
177,300
207,300
203,300
Capital Outlay
65600
Equipment
_
_
_
Capital Outlay
Total
451,257
470,397
498,813
408,250
509,547
648,519
678,519
661,640
451,257
470,397
498,813
408,250
509,547
648,519
678,519
661,640
36 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government City Hall - 41910
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
37 8/24/2018
Salaries & Benefits
60110
Salaries - Regular
-
-
-
-
25,115
75,689
75,689
80,182
60210
FICA
-
-
-
-
1,444
4,693
4,693
4,971
60220
Medicare
-
-
-
-
338
1,097
1,097
1,163
60310
Health Insurance
-
-
-
-
7,258
14,500
14,500
17,400
60320
Dental Insurance
-
-
-
-
17
542
542
550
60330
Life Insurance
-
-
-
-
4
20
20
20
60340
Long -Term Disability
-
-
-
-
59
197
197
208
60410
PERA
-
-
-
-
1,845
5,677
5,677
6,014
60520
Workers Comp
-
-
-
-
2,757
2,725
2,725
2,887
60990
Inter -City Labor Allocation
-
-
-
-
(68,231)
68,231)
(77,108
Salaries &Benefits
-
-
-
38,837
36,909
36,909
36,287
Departmental
61020
Supplies -Operating
112
522
763
316
789
2,100
2,100
2,100
61025
Supplies - Cleaning
1,696
933
1,686
972
1,624
1,500
1,500
1,500
61120
R & M Supplies - Building
954
601
281
515
2,572
5,730
5,730
5,730
61205
Small & Expend - Small Tools
2,254
-
945
-
80
2,000
2,000
2,000
Departmental
5,016
2,056
3,675
1,803
5,065
11,330
11,330
11,330
Operating
62005
Electric
20,360
19,555
19,321
19,552
19,023
24,250
24,250
24,250
62010
Water&Sewer Service
3,062
1,817
3,045
2,445
2,546
3,750
3,750
3,750
62015
Natural Gas
5,565
6,899
4,585
3,595
4,341
9,000
9,000
9,000
62020
Refuse Collection
858
2,150
1,917
2,013
2,078
2,500
2,500
2,500
62025
Storm Water Utility Charge
821
693
1,200
1,018
1,069
1,200
1,200
1,200
62030
Telephone
12,416
6,357
8,016
7,130
7,407
16,000
16,000
12,500
62100
Insurance
14,179
14,179
14,604
14,604
14,604
14,604
14,604
14,604
62200
Rentals
1,363
1,394
1,488
1,540
1,718
2,750
2,750
2,750
62300
Equipment Maintenance Contra
2,443
5,032
6,198
5,683
7,071
6,870
6,870
7,310
62305
Software Support Contract
-
-
-
1,409
1,000
1,000
1,500
Operating
61,067
58,076
60,374
57,580
61,266
81,924
81,924
79,364
Professional Services
63010
Contractual Services
24,180
24,686
23,585
24,066
29,888
26,800
26,800
26,800
63105
R & M Labor- Building
14,538
22,857
25,730
9,918
27,831
23,000
33,000
45,500
Professional Services
38,718
47,543
49,315
33,984
57,719
49,800
59,800
72,300
Total
104,801
107,675
113,364
93,367
162,887
179,963
189,963
199,281
37 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government Fire Stations - 41920
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
38 8/24/2018
Salaries & Benefits
60110
Salaries -Regular
-
-
-
-
25,115
-,444
60210
FICA
_
-
_
1
-
60220
Medicare
_-
60310
Health Insurance
-
-
-
-
338
_
60320
Dental Insurance
-
-
-
-
3,945
60330
Life insurance
_
_ -
_
-
-
17-
_
-
60340
Long -Term Disability
-
_
-
_
_
4
_
60410
PERA
-
-
58
_-
60520
Workers Comp
-
-
-
-
-
1,845
-
-
-
60990
Inter -City Labor Allocation
-
Salaries &Benefits
-
-
-
36,919
36,919
36,286
-
-
32,766
36,919
36,919
36,286
Departmental
61020
Supplies -Operating
30
48
30
138
233
300
300
300
61025
61120
Supplies - Cleaning
R & M Supplies - Building
532
1,787
208
957
833
603
1,200
1,200
1,200
Departmental2,349
.442
698
1,179
2,166
2,700
3,671
4,082
4,9187,750
6,250
6,250
6,250
7,750
7,750
Operating
62005
62010
Electric
Water & Sewer Service
21,861
5,166
21,294
3,325
21,445
21,333
22,585
24,000
24,000
24,000
62015
Natural Gas
14,601
19,629
4,656
12,205
3,937
9,269
3,448
10,724
6,000
20,000
6,000
20,000
6,000
62020
Refuse Collection
1,257
3,917
3,957
4,119
4,487
4,500
4,500
20,000
5,000
62025
Storm Water Utility Charge
92
76
132
112
118
I50
62030
62100
Telephone
Insurance
10,971
7,513
8,764
7,625
7,742
16,500
150
16,500
150
13,000
62300
Equipment Maintenance Contra,
10,450
4,873
10,450
5,664
10,764
9,566
10,764
6,532
10,764
10,706
10,764
10,764
10,764
62305
Software Support Contract
-
-
12,850
12,850
13,450
Operating
69,271
71,868
-
71,489
-
63,691
1,409
71,983
1,000
95,764
1,000
95,764
1,500
93,864
Professional Services
63010
63105
Contractual Services
R & M Labor - Building
21,085
16,608
19,805
19,638
20,126
26,006
20,500
20,500
20,500
Professional Services
37,693
33,407
53,212
27,340
46,978
26,992
47,118
28,968
34,000
44,000
37,500
54,974
54,500
64,500
58,000
Total
109,313
125,778
120,633
114,480
164,641
194,933
204,933
195,900
38 8/24/2018
39 8/24/2018
CITY OF ANDOVER
Budget Worksheet
- 2019
Function: General Government
Public Works Building - 41930
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries -Regular
-
-
-
-
25,122
-
-
-
60210
FICA
-
-
-
-
1,445
-
-
-
60220
Medicare
-
-
-
-
338
-
-
-
60310
Health Insurance
-
-
-
-
3,979
-
-
-
60320
Dental Insurance
-
-
-
-
17
-
-
-
60330
Life Insurance
-
-
-
-
4
60340
Long -Term Disability
-
-
-
-
59
-
-
-
60410
PERA
-
-
-
-
1,845
-
-
-
60520
Workers Comp
-
-
-
-
-
-
-
-
60990
Inter -City Labor Allocation
-
-
-
-
-
36,910
36,910
36,286
Salaries &Benefits
-
-
-
32,809
36,910
36,910
36,286
Departmental
61020
Supplies - Operating
603
643
895
1,130
693
1,800
1,800
1,800
61025
Supplies -Cleaning
988
1,315
1,215
1,213
1,870
2,400
2,400
2,400
61120
R & M Supplies - Building
12,667
7,863
7,006
3,932
1,324
12,000
12,000
7,000
61205
Small & Expend - Small Tools
5,091
3,980
6,816
3,680
844
2,000
2,000
2,000
Departmental
19,349
13,801
15,932
9,955
4,731
18,200
18,200
13,200
Operating
62005
Electric
22,582
19,406
29,212
23,466
27,538
31,000
31,000
31,000
62010
Water & Sewer Service
15,302
9,328
11,738
10,946
8,884
16,000
16,000
16,000
62015
Natural Gas
26,012
31,835
27,257
15,632
19,029
34,000
34,000
34,000
62020
Refuse Collection
4,208
4,269
4,255
6,719
5,907
6,500
6,500
6,500
62025
Storm Water Utility Charge
3,164
2,498
4,399
3,709
3,894
4,500
4,500
4,500
62030
Telephone
6,679
3,938
5,290
4,324
3,368
9,500
9,500
6,500
62100
Insurance
6,273
6,273
6,461
6,461
6,461
6,461
6,461
6,461
62200
Rentals
4,780
4,123
3,554
3,541
4,286
5,000
5,000
5,000
62300
Equipment Maintenance Contract
1,900
4,967
6,728
10,090
7,989
8,800
8,800
9,370
62305
Software Support Contract
-
-
-
-
1,889
1,000
1,000
1,500
Operating
90,900
86,637
98,894
84,888
89,245
122,761
122,761
120,831
Professional Services
63010
Contractual Services
19,793
25,414
19,600
20,099
24,343
21,950
21,950
21,950
63105
R & M Labor - Building
30,902
25,607
71,667
25,699
13,306
30,000
40,000
35,000
Professional Services
50,695
51,02191,267
45,798
37,649
51,950
61,950
56,950
Total
160,944
151,459
206,093
140,641
164,434
229,821
239,821
227,267
39 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government
Equipment Building - 41950
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Operating
62015
Natural Gas
1,376
1,774
1,218
1,020
1,257
2,250
2,250
2,250
62100
Insurance
308
308
317
317
317
317
317
317
62300
Equipment Maintenance Contra.
690
-
Operating
2,374
2082,
1,535
1,337
1,574
2,567
2,567
2,567
Professional Services
63105
R & M Labor - Building
505.
-
1,250
1,250
1,250
Professional Services
505
-
-
1,250
1,250
1,250
Total
2,879
2,082
1,535
1,337
1,574
3,817
3,817
3,817
40 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: General Government
City Hall Garage - 41960
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Departmental
61120
R & M Supplies - Building
-
-
-
74
350
350
350
Departmental
-
-
-
74
350
350
350
Operating
62005
Electric
216
279
255
232
246
500
500
500
62100
Insurance
509
509
524
524
524
524
524
524
Operating
725
788
779
756
770
1,024
1,024
1,024
Professional Services
63105
R & M Labor - Building
-
750
750
750
Professional Services
-
-
-
750
750
750
Total
725
788
779
756
844
2,124
2,124
2,124
8/24/2018
41
CITY OF ANDOVER
Budget Worksheet -2019
Function: General Government
Sunshine Park Building - 41970
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Departmental
61020
Supplies - Operating
545
113
607
419
991
1,000
1,000
1,000
61025
Supplies - Cleaning
-
-
-
135
-
1,000
1,000
1,000
61120
R & M Supplies - Building
1,281
1,244
50
-
848
1,020
1,020
1,020
Departmental
1,826
1,357
657
554
1,839
3,020
3,020
3,020
Operating
62010
Water &Sewer Service
1,253
805
1,291
1,059
1,139
1,750
1,750
1,750
62015
Natural Gas
1,489
2,045
1,056
734
1,102
2,000
2,000
2,000
62020
Refuse Collection
-
53
-
-
-
300
300
300
62030
Telephone
385
343
240
251
356
500
500
500
62100
Insurance
541
541
557
557
557
557
557
557
62300
Equipment Maintenance Contra.
560
-
608
620
620
680
Operating
4,228
3,787
3,144
2,601
3,762
5,727
5,727
5,787
Professional Services
63010
Contractual Services
122
1,580
740
1,458
755
2,000
2,000
2,000
63105
R & M Labor - Building
539
7,252
2,154
3,293
-
10,000
10,000
5,000
Professional Services
661
8,832
2,894
4,751
755
12,000
12,000
7,000
Total
6,715
13,976
6,695
7,906
6,356
20,747
20,747
15,807
42 8/24/2018
CITY OF ANDOVER
Budget Worksheet -2019
Function: General Government
Sunshine Park Concessions - 41975
Account
Actual
Actual
Actual
Actual
Actual
Budget Estimate Requested
Number
Description
2013
2014
2015
2016
2017
2018 2018 2019
Salaries & Benefits
60110
Salaries - Regular
11,955
15,417
13,812
13,812
-
- - -
60210
FICA
736
936
840
850
-
- - -
60220
Medicare
172
219
197
199
-
- - -
60310
Health Insurance
812
1,154
1,042
722
520
- - -
60320
Dental Insurance
-
2
23
9
-
- - -
60330
Life Insurance
-
1
1
-
-
- - -
60340
Long -Tenn Disability
3
5
4
2
-
- - -
60410
PERA
165
213
229
80
-
- - -
60520
Workers Comp
-
-
-
433
-
- - -
60990
Inter -City Labor Allocation
-
-
- -
Salaries&Benefits
13,843
17,947
16,148
16,107
520
- -
Departrnental
61020
Supplies - Operating
537
90
1,563
16
-
- - -
61245
Items for Resale
28,252
27,774
24,789
22,484
-
- - -
61320
Annual Dues / Licenses
393
558
408
463
145
- -
Departmental
29,182
28,422
26,760
22,963
145
-
Operating
62030
Telephone
385
343
240
251
147
- - -
62300
Equipment Maintenance Contra
-
200
220
220
230
Operating
385
543
460
471
377
- -
Professional Services
63100
R & M Labor - General
835
302
181
1,436
-
-
professional Services
835
302
181
1,436
-
-
Capital Outlay
65600
Equipment
Capital Outlay
-
Total
44,245
47,214
43,549
40,977
1,042
-
8/24/2018
43
CITY OF ANDOVER
Budget Worksheet - 2019
Function:
General Government
Andover St NBldg - 41980
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Departmental
61020
Supplies - Operating
169
-
-
270
-
750
750
750
61025
Supplies -Cleaning
-
-
-
135
-
750
750
750
61120
R & M Supplies - Building
-
417
650
900
900
900
Departmental
169
-
417
405
650
2,400
2,400
2,400
Operating
62015
Natural Gas
1,354
1,640
1,115
966
1,261
1,750
1,750
1,750
62020
Refuse Collection
-
-
-
-
-
-
_
-
62030
Telephone
550
452
479
523
709
750
750
750
62100
Insurance
541
541
557
557
557
557
557
557
62300
Equipment Maintenance Contra.
560
-
-
1,138
1,000
1,000
1,250
Operating
3,005
2,633
2,151
2,046
3,665
4,057
4,057
4,307
Professional Services
63010
Contractual Services
1,174
1,128
1,413
2,155
887
2,100
2,100
2,100
63105
R & M Labor - Building
271
-
754
1,626
476
3,000
3,000
3,000
Professional Services
1,445
1,128
2,167
3,781
1,363
5,100
5,100
5,100
Total
4,619
3,761
4,735
6,232
5,678
11,557
11,557
11,807
CITY OF ANDOVER
Budget Worksheet - 2019
Function:
General Government
Andover St N Concessions - 41985
Account
Actual
Actual
Actual Actual
Actual Budget Estimate Requested
Number
Description
2013
2014
2015 2016
2017 2018 2018 2019
Salaries & Benefits
60110
Salaries -Regular
6,106
6,000
80 -
- - - -
60210
FICA
376
365
4 -
- - - -
60220
Medicare
88
85
1 -
- - - -
60310
Health Insurance
318
391
220 -
- - - -
60320
Dental Insurance
-
-
1 -
- - - -
60330
Life Insurance
-
-
- -
- - - -
60340
Long -Term Disability
I
2
- -
- - - -
60410
PERA
98
98
6 -
- - - -
60520
Workers Comp
-
-
- -
_ _ _ _
60990
Inter -City Labor Allocation
-
-
-
Salaries & Benefits
6,987
6,941
312
- -
Departmental
61020
Supplies - Operating
-
-
- -
- - - -
61245
Items for Resale
8,033
7,561
- -
- - - -
61320
Annual Dues / Licenses
70
408
55 -
- - -
Departmental
8,103
7,969
55
- -
Operating
62020
Refuse Collection
-
-
62030
Telephone
Operating
Professional Services
63100
R & M Labor - General
122
-
-
-
Professional Services
122
-
-
- -
Total
15,212
14,910
367
-
45
CITY OF ANDOVER
Budget Worksheet -2019
Function: General Government
Prairie Knoll Park Bldg - 41990
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Departmental
61025
Supplies - Cleaning
-
-
-
-
-
250
250
250
61120
R & M Supplies - Building
642
208
65
1,624
113
1,250
1,250
1,250
Departmental
642
208
65
1,624
113
1,500
1,500
1,500
Operating
62015
Natural Gas
487
656
441
373
450
750
750
750
62020
Refuse Collection
-
53
-
-
-
-
-
-
62100
Insurance
541
541
557
557
557
557
557
557
62300
Equipment Maintenance Contra.
-
-
-
778
800
800
880
Operating
1,028
1,250
998
930
1,785
2,107
2,107
2,187
Professional Services
63105
R & M Labor - Building
134
1,296
-
193
1,950
1,950
1,950
Professional Services
134
1,296
-
-
193
1,950
1,950
1,950
Total
1,804
2,754
1,063
2,554
2,091
5,557
5,557
5,637
46
47
CITY OF ANDOVER
Budget Worksheet
-2019
Function: Public Safety
Public
Safety Rollup
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries - Regular
536,608
543,474
501,518
561,884
578,044
571,652
571,652
593,649
60120
Salaries- Volunteer Fire Fighter
223,204
282,019
221,470
247,392
303,471
318,258
318,258
341,100
60210
FICA
32,704
35,809
28,233
34,369
36,697
36,951
36,951
39,042
60220
Medicare
10,264
11,246
9,930
12,041
12,536
12,904
12,904
13,555
60310
Health Insurance
49,156
57,332
57,513
66,628
68,871
73,500
73,500
83,200
60320
Dental Insurance
3,163
2,918
2,675
2,889
2,937
3,252
3,252
3,300
60330
Life Insurance
749
616
578
501
447
140
140
140
60340
Long -Term Disability
1,305
1,335
1,097
1,209
1,218
1,487
1,487
1,545
60410
PERA
46,949
45,968
52,199
61,069
60,573
68,445
68,445
73,349
60420
Nationwide Retirement
2,222
4,962
5,894
6,203
6,282
-
-
-
60520
Workers Comp
41,914
46,636
47,858
49,297
65,520
72,037
72,037
73,651
60540
Relief Association
203,555
206,491
220,332
222,844
222,893
220,000
220,000
220,000
60990
Inter -City Labor Allocation
-
-
-
27,677
27,677
28,659
Salaries & Benefits
1,151,793
1,238,806
1,149,297
1,266,326
1,359,489
1,406,303
1,406,303
1,471,190
Departmental
61005
Supplies - General
2,303
3,014
6,188
8,030
9,364
10,200
10,200
12,100
61010
Supplies -Printed Forms
682
353
665
333
564
1,000
1,000
1,000
61015
Supplies - Training
-
-
1,089
2,035
8,537
4,000
4,000
6,000
61020
Supplies -Operating
59,643
86,583
27,639
48,052
29,530
37,050
37,050
29,850
61060
Supplies- Fire Prevention/Educ
-
-
1,270
1,027
2,609
4,500
4,500
4,500
61205
Small&Expend - Small Tools
-
1,056
5,671
7,536
5,769
6,000
6,000
9,000
61305
Uniforms
1,621
17,761
55,879
52,014
37,442
35,000
35,000
40,000
61310
Meals/Lodging
2,232
2,606
2,490
1,534
7,022
7,000
71000
8,000
61315
Continuing Education
28,763
21,524
21,784
16,805
23,898
23,000
23,000
28,000
61320
Annual Dues / Licenses
4,240
3,674
3,706
2,585
3,161
5,000
5,000
5,000
61325
Subscriptions Publications
1,581
1,755
56
1,345
1,604
1,500
1,500
1,500
61405
Postage
1,916
1,385
1,852
1,353
1,361
2,300
2,300
1,800
61410
Transportation/Mileage
3,338
2,025
1,438
2,019
4,109
3,000
3,000
3,000
Departmental
106,319
141,736
129,727
144,668
134,970
139,550
139,550
149,750
Operating
62005
Electric
769
724
720
720
720
800
800
800
62030
Telephone
2,776
4,113
4,253
5,848
4,668
6,000
6,000
6,600
62100
Insurance
25,365
25,365
26,126
26,126
26,126
26,506
26,506
26,506
62200
Rentals
5,637
4,900
4,799
5,011
4,908
7,250
7,250
7,250
62205
Central Equipment Services
189,292
189,292
195,277
194,971
189,121
189,121
189,121
189,121
62300
Equipment Maintenance Contn
11,004
10,855
9,381
9,457
9,551
13,500
13,500
13,600
62305
Software Maintenance Contract
3,039
2,880
6,006
17,635
19,074
34,400
34,400
35,000
Operating
237,882
238,129
246,562
259,768
254,168
277,577
277,577
278,877
Professional Services
63005
Professional Services
45,673
35,961
34,212
37,772
42,943
47,100
47,100
47,600
63010
Continental Services
2,753,253
2,832,132
2,930,048
2,951,466
2,984,162
3,087,026
3,087,026
3,208,860
63025
Publishing
67
754
186
349
-
500
500
1,500
63030
Printing
-
-
-
-
-
500
500
2,000
63100
R&MLabor -General
16,353
11,402
13,300
6,977
2,604
19,500
19,500
15,000
Professional Services
2,815,346
2,880,249
2,977,746
2,996,564
3,029,709
3,154,626
3,154,626
3,274,960
Total
4,311,340
4,498,920
4,503,332
4,667,326
4,778,336
4,978,056
4,978,056
5,174,777
47
CITY OF ANDOVER
Budget Worksheet -2019
Function: Public Safety Police Protection - 42100
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
Professional Services
63010 Contractual Services 2,740,899 2,818,132 2,918,308 2,936,467 2,962,551 3,053,526 3,053,526 3,183,610
Professional Services 2,740,8992,818,132 2,918,308 2,936,467 2,962,551 3,053,526 3,053,526 3,183,610
Total 2,740,899 2,818,132 2,918,308 2,936,467 1,962,551 3,053,526 3,053,5263,183,610
48 8/24/2018
49 8/24/2018
CITY OF ANDOVER
Budget Worksheet
- 2019
Function: Public Safety
Fire Protection - 42200
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries -Regular
261,878
291,520
247,984
293,715
296,358
293,926
293,926
305,024
60120
Salaries- Volunteer Fire Fightei
223,204
282,019
221,470
247,392
303,471
318,258
318,258
341,100
60210
FICA
17,466
20,882
12,992
17,680
19,664
19,732
19,732
21,147
60220
Medicare
6,700
7,755
6,365
8,138
8,553
8,876
8,876
9,369
60310
Health Insurance
19,270
24,886
27,658
31,620
32,449
36,500
36,500
38,800
60320
Dental Insurance
1,363
1,137
1,037
1,046
1,044
1,084
1,084
1,100
60330
Life Insurance
697
564
543
467
412
60
60
60
60340
Long -Term Disability
652
694
595
674
665
765
765
793
60410
PERA
30,854
33,034
39,124
46,976
46,720
47,616
47,616
51,702
60520
Workers Comp
35,381
40,240
41,239
42,396
55,208
62,038
62,038
63,260
60540
Relief Association
203,555
206,491
220,332
222,844
222,893
220,000
220,000
220,000
60990
Inter -City Labor Allocation
-
-
-
21,435
21,435
22,294
Salaries & Benefits
801,020
909,222
819,339
912,948
987,437
1,030,290
1,030,290
1,074,649
Departmental
61005
Supplies - General
444
122
2,663
6,336
6,712
6,500
6,500
7,500
61015
Supplies -Training
-
-
1,089
2,035
8,537
4,000
4,000
6,000
61020
Supplies -Operating
58,191
84,466
26,550
47,058
28,595
34,300
34,300
27,600
61060
Supplies - Fire Prevention/Fduc
-
-
1,270
1,027
2,609
4,500
4,500
4,500
61205
Small & Expend - Small Tools
-
1,056
5,671
7,536
5,769
6,000
6,000
9,000
61305
Uniforms
1,621
17,761
55,879
52,014
37,442
35,000
35,000
40,000
61310
Meals/Lodging
2,232
2,278
2,258
968
5,851
6,000
6,000
7,000
61315
Continuing Education
25,493
19,431
19,053
13,040
21,837
15,000
15,000
20,000
61320
Annual Dues/ Licenses
4,030
3,574
3,606
2,485
2,771
3,500
3,500
3,500
61325
Subscriptions/Publications
1,581
1,755
56
1,345
1,604
1,500
1,500
1,500
61405
Postage
286
258
105
136
263
550
550
550
61410
Transportation / Mileage
2,635
1,313
561
1,014
2,759
2,000
2,000
2,000
Departmental
96,513
132,014
118,761
134,994
124,749
118,850
118,850
129,150
Operating
62030
Telephone
1,664
2,874
2,971
2,387
2,342
3,000
3,000
3,600
62100
Insurance
22,932
22,932
23,620
23,620
23,620
24,000
24,000
24,000
62200
Rentals
1,806
1,390
1,416
1,805
1,959
2,500
2,500
2,500
62205
Central Equipment Services
176,233
176,233
181,520
181,520
176,074
176,074
176,074
176,074
62300
Equipment Maintenance Contra
4,303
4,205
3,019
3,095
3,225
6,500
6,500
6,600
62305
Software Maintenance Contract
2,532
12,700
13,604
28,700
28,700
29,300
Operating
206,938
207,634
215,078
225,127
220,824
240,774
240,774
242,074
Professional Services
63005
Professional Services
-
1,357
-
-
-
3,500
3,500
4,000
63010
Contactual Services
6,789
10,589
9,306
11,677
19,567
28,500
28,500
20,250
63025
Publishing
-
40
-
45
-
-
-
1,000
63030
Printing
-
-
-
-
-
500
500
2,000
63100
R & M Labor- General
15,719
3,162
2,739
626
632
1,500
1,500
1,500
Professional Services
22,508
15,148
12,045
12,348
20,199
34,000
34,000
28,750
Total
1,126,979
L264,018
1,165,223
1,285,417
1,353,209
1,423,914
1,423,914
1,474,623
49 8/24/2018
50 8/24/2018
CITY OF ANDOVER
Budget Worksheet -2019
Function: Public Safety
Protective Inspection - 42300
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries - Regular
270,215
247,713
249,072
263,469
276,758
277,726
277,726
288,625
60210
FICA
14,965
14,679
14,980
16,401
16,742
17,219
17,219
17,895
60220
Medicare
3,500
3,433
3,504
3,836
3,915
4,028
4,028
4,186
60310
Health Insurance
29,463
31,767
29,161
34,306
35,698
37,000
37,000
44,400
60320
Dental Insurance
1,773
1,756
1,612
1,817
1,867
2,168
2,168
2,200
60330
Life Insurance
51
51
34
33
34
80
80
8o
60340
Long -Term Disability
640
629
492
524
541
722
722
752
60410
PERA
15,890
12,643
12,729
13,732
13,485
20,829
20,829
21,647
60420
Nationwide Retirement
2,099
4,962
5,894
6,203
6,282
-
-
-
60520
Workers Comp
6,533
6,396
6,619
6,901
10,312
9,999
9,999
10,391
60990
Inter -City Labor Allocation
-
-
-
-
(576)
(576)
(771)
Salaries & Benefits
345,129
324,029
324,097
347,222
365,634
369,195
369,195
389,405
Departmental
61005
Supplies - General
1,859
2,458
3,525
1,694
2,652
3,700
3,700
3,700
61010
Supplies - Printed Forms
682
353
665
333
564
1,000
1,000
1,000
61020
Supplies - Operating
1,358
2,015
771
899
585
2,600
2,600
2,100
61310
Meals / Lodging
-
328
232
566
1,171
1,000
1,000
1,000
61315
Continuing Education
3,270
2,093
2,731
3,680
2,061
5,500
5,500
5,500
61320
Annual Dues/Licenses
210
100
100
100
390
1,500
1,500
1,500
61405
Postage
1,630
1,127
1,747
1,217
1,098
1,750
1,750
1,250
61410
Transportation/Mileage
703
712
877
1,005
1,350
1,000
1,000
1,000
Departmental
9,712
9,186
10,648
9,494
9,871
18,050
18,050
17,050
Operating
62030
Telephone
1,112
1,239
1,282
3,461
2,326
3,000
3,000
3,000
62100
Insurance
1,575
1,575
1,622
1,622
1,622
1,622
1,622
1,622
62200
Rentals
3,831
3,510
3,383
3,206
2,949
4,750
4,750
4,750
62205
Central Equipment Services
13,059
13,059
13,757
13,451
13,047
13,047
13,047
13,047
62300
Equipment Maintenance Contra.
676
625
36
36
-
-
-
-
62305
Software Maintenance Contract:
2,839
2,730
3,324
4,785
5,320
5,500
5,500
5,500
Operating
23,092
22,738
23,404
26,561
25,264
27,919
27,919
27,919
Professional Services
63005
Professional Services
45,495
34,241
33,616
37,639
42,943
43,000
43,000
43,000
63025
Publishing
67
714
186
304
-
500
500
500
63100
R & M Labor - General
-
-
-
3,027
-
3,500
3,500
3,500
Professional Services
45,562
34,955
33,802
40,970
42,943
47,000
47,000
47,000
Total
423,495
390,908
391,951
424,247
443,712
462,164
462,164
481,374
50 8/24/2018
51 8/24/2018
CITY OF ANDOVER
Budget Worksheet-2019
Function: Public Safety
Emergency Mgmt - 42400
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries- Regular
4,515
4,241
4,462
4,700
4,928
-
-
-
60210
FICA
273
248
261
288
291
-
-
-
60220
Medicare
64
58
61
67
68
-
-
-
60310
Health Insurance
423
679
694
702
724
-
-
-
60320
Dental Insurance
27
25
26
26
26
-
-
-
60330
Life Insurance
1
1
1
1
1
-
-
-
60340
Long-Term Disability
13
12
10
11
12
-
-
-
60410
PERA
205
291
346
361
368
-
-
-
60420
Nationwide Retirement
123
-
-
-
-
-
_
-
60990
Inter-City Labor Allocation
-
-
-
-
6,818
6,818
7,136
Salaries & Benefits
5,644
5,555
5,861
6,156
6,418
6,818
6,818
7,136
Departmental
61005
Supplies - General
-
434
-
-
-
-
-
900
61315
Continuing Education
-
-
-
85
2,500
2,500
2,500
Departmental
-
434
-
85
-
2,500
2,500
3,400
Operating
62005
Electric
769
724
720
720
720
800
800
800
62100
Insurance
858
858
884
884
884
884
884
884
62300
Equipment Maintenance Contra,
6,025
6,025
6,326
6,326
6,326
7,000
7,000
7,000
Operating
7,652
7,607
7,930
7,930
7,930
8,684
8,684
8,684
Professional Services
63100
R & M Labor-General
634
8,240
10,561
3,324
1,972
14,500
14,500
10,000
Professional Services
634
8,240
10,561
3,324
1,972
14,500
14,500
10,000
Total
13,930
21,836
24,352
17,495L
6,320
32,502
32,502
29,220
51 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: Public Safety
Animal Control - 42500
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Departmental
61010
Supplies - Printed Forms
-
-
-
-
-
-
-
-
61020
Supplies - Operating
94
102
318
95
350
150
150
150
Departmental
94
102
318
95
350
150
150
150
Operating
62305
Software Maintenance Contract
200
150
150
150
150
200
200
200
Operating
200
150
150
150
150
200
200
200
Professional Services
63005
Professional Services
178
363
596
133
-
600
600
600
63010
Contractual Services
5,565
3,411
2,434
3,322
2,044
5,000
5,000
5,000
Professional Services
5,743
3,774
3,030
3,455
2,044
5,600
5,600
5,600
Total
6,037
4,026
3,4983,700
2,544
5,950
5,950
5,950
52 8/24/2018
Capital Outlay
65200 Building
65300 Improvements
65600 Equipment
Capital Outlay
Total
54,514
- - - 126,801
74,910
100,000
115,000
CITY OF ANDO VER
54,514 - - 126,801
74,910
100,000
115,000
120,000
2,759,342 2,819,372 2,817,981 2,966,674
2,854,540
3,206,152
Budget Worksheet
- 2019
Function: Public Works
Public Works Rollup
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries -Regular
1,172,132
1,233,640
1,219,394
1,258,013
1,196,475
1,083,860
1,083,860
1,115,366
60140
Salaries - Council/Commissior
3,660
3,640
3,720
3,410
3,340
3,600
3,600
3,600
60210
FICA
69,153
73,932
72,654
77,088
71,257
67,424
67,424
69,372
60220
Medicare
16,181
17,294
16,995
18,054
16,665
15,767
15,767
16,228
60310
Health Insurance
153,123
167,321
170,573
175,737
185,735
171,960
171,960
187,800
60320
Dental Insurance
8,164
8,323
8,041
8,037
8,004
8,130
8,130
8,250
60330
Life Insurance
255
260
222
208
210
340
340
340
60340
Long -Tenn Disability
2,918
3,026
2,536
2,655
2,655
2,663
2,663
2,745
60410
PERA
81,019
86,131
84,565
88,567
85,251
81,286
81,286
83,651
60520
Workers Comp
24,252
25,837
26,858
32,783
43,782
39,022
39,022
40,156
60990
Inter -City Labor Allocation
-
-
290,445
290,445
307,892
Salaries & Benefits
1,530,857
1,619,404
1,605,558
1,664,552
1,613,374
1,764,497
1,764,497
1,835,400
Departmental
61005
Supplies -General
3,032
3,289
3,078
2,834
3,811
1,250
1,250
2,400
61020
Supplies - Operating
58,489
50,549
59,156
51,364
58,035
65,000
65,000
71,500
61025
Supplies -Cleaning
255
755
349
786
1,708
3,000
3,000
3,000
61030
Supplies - Signs
20,394
31,955
29,658
9,706
40,098
37,500
37,500
40,000
61105
R & M Supplies -General
24,411
22,311
21,866
24,471
17,200
23,000
23,000
31,000
61125
R & M Supplies - Streets
214,062
180,705
130,270
140,294
154,955
165,000
165,000
180,000
61130
R & M Supplies -Landscape
25,326
41,006
43,670
38,103
31,207
40,000
40,000
40,000
61205
Small & Expend- Small Tools
3,508
4,288
8,577
5,554
6,047
9,000
9,000
10,000
61220
Software
-
6,670
-
5,160
761
4,000
4,000
4,000
61310
Meals/Lodging
-
501
356
322
70
850
850
950
61315
Continuing Education
1,785
2,750
2,240
2,530
2,458
4,000
4,000
4,500
61320
Annual Dues/Licenses
927
898
1,334
3,991
5,559
7,710
7,710
8,910
61325
Subscriptions/Publications
542
422
420
375
715
-
-
-
61405
Postage
3,943
1,880,
2,115
3,624
3,837
4,200
4,200
4,200
61410
Transportation/Mileage
281
767
245
516
48
775
775
775
Departmental
356,955
348,746
303,334
289,630
326,509
365,285
365,285
401,235
Operating
62005
Electric
265,545
262,044
263,884
264,680
211,835
291,000
243,500
251,500
62015
Natural Gas
386
624
391
354
368
1,200
1,200
1,200
62010
Water &Sewer Service
33,848
22,082
36,557
30,279
34,339
38,000
38,000
38,000
62020
Refuse Collection
14,138
10,381
12,104
13,570
18,126
12,700
12,700
20,500
62025
Storm Water Utility Charge
918
739
1,280
1,086
1,139
1,200
1,200
1,200
62030
Telephone
5,145
7,907
8,904
8,596
9,097
9,500
9,500
11,000
62100
Insurance
38,290
38,290
39,439
39,439
39,439
39,439
39,439
39,439
62200
Rentals
16,863
11,023
16,592
22,665
13,221
26,000
26,000
28,500
62205
Central Equipment Services
299,579
299,579
308,567
308,567
299,331
299,331
299,331
299,331
62300
Equipment Maintenance Contra
9,940
10,050
10,298
10,381
10,661
13,500
13,500
13,500
62305
Software Maintenance Contract:
2,600
1,100
1,100
1,100
3,652
2,500
2,500
2,500
Operating
687,252
663,819
699,116
700,717
641,208
734,370
686,870
706,670
Professional Services
63005
Professional Services
2,544
4,843
3,032
2,267
4,278
6,100
9,600
6,100
63010
Contractual Services
104,464
134,524
155,894
150,317
165,425
177,500
183,500
186,900
63025
Publishing
1,503
842
7,497
9,827
7,620
10,000
10,000
10,000
63100
R & M Labor - General
19,623
43,775
28,163
14,373
13,070
33,400
33,400
35,400
63110
R & M Labor -Streets
-
-
1,404
400
2,000
2,000
4,000
63300
Improvements -Streets
1,630
3,419
13,983
7,790
8,146
13,000
13,000
13,000
Professional Services
129,764
187,403
209,973
184,974
198,539
242,000
251,500
255,400
Capital Outlay
65200 Building
65300 Improvements
65600 Equipment
Capital Outlay
Total
54,514
- - - 126,801
74,910
100,000
115,000
120,000
54,514 - - 126,801
74,910
100,000
115,000
120,000
2,759,342 2,819,372 2,817,981 2,966,674
2,854,540
3,206,152
3,183,152
3,318,705
53
CITY OF ANDOVER
Budget Worksheet -2019
Function: Public Works
Streets & Highways - 43100
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries - Regular
311,083
324,516
345,169
371,380
291,834
447,689
447,689
465,697
60210
FICA
18,973
19,149
20,896
22,430
17,567
27,757
27,757
28,872
60220
Medicare
4,439
4,479
4,888
5,252
4,108
6,491
6,491
6,754
60310
Health Insurance
43,336
43,073
48,116
45,263
51,127
74,980
74,980
83,200
60320
Dental Insurance
2,511
2,420
2,545
2,666
2,445
3,794
3,794
3,850
60330
Life Insurance
73
71
66
62
60
140
140
140
60340
Long -Tenn Disability
821
810
752
805
707
1,112
1,112
1,159
60410
PERA
22,098
22,367
25,177
25,990
21,568
33,576
33,576
34,927
60520
Workers Comp
10,796
10,836
11,357
10,324
10,679
16,118
16,118
16,766
60990
later -City Labor Allocation
-
-
-
-
(161,353)
(161,353)16(
9,604)
Salaries & Benefits
414,130
427,721
458,966
484,172
400,095
450,304
450,304
471,761
Departmental
61005
Supplies -General
1,439
1,775
2,215
2,188
2,642
850
850
2,000
61020
Supplies - Operating
19,990
18,838
20,557
23,772
24,764
20,000
20,000
22,000
61125
R & M Supplies - Streets
39,131
40,767
30,279
41,538
36,942
40,000
40,000
50,000
61205
Small & Expend - Small Tools
1,887
3,381
2,966
3,446
2,725
4,000
4,000
4,000
61310
Meals/Lodging
-
17
-
222
15
100
100
200
61315
Continuing Education
1,150
925
320
1,135
520
1,500
1,500
2,000
61320
Annual Dues/Licenses
220
182
535
1,115
2,194
2,000
2,000
2,500
61405
Postage
229
86
129
81
79
500
500
500
61410
Transportation / Mileage
-
-
-
-
100
100
100
Departmental
64,046
65,971
57,001
73,497
69,881
69,050
69,050
83,300
Operating
62030
Telephone
2,428
3,624
3,812
3,570
3,406
4,000
4,000
4,000
62100
Insurance
20,992
20,992
21,622
21,622
21,622
21,622
21,622
21,622
62200
Rentals
2,036
-
561
10,053
3,700
10,000
10,000
12,500
62205
Central Equipment Services
57,919
57,919
59,657
59,657
57,867
57,867
57,867
57,867
Operating
83,375
82,535
85,652
94,902
86,595
93,489
93,489
95,989
Professional Services
63005
Professional Services
-
598
-
-
-
100
100
100
63010
Contractual Services
9,572
20,069
12,718
25,325
33,246
32,000
32,000
37,000
63110
R & M Labor - Streets
-
-
1,404
400
-
2,000
2,000
4,000
63300
Improvements- Streets
1,630
3,419
13,983
7,790
8,146
13,000
13,000
13,000
Professional Services
11,202
24,086
28,105
33,515
41,392
47,100
47,100
54,100
Total
572,753
600,313
629,724
686,086
597,963
659,943
659,943
705,150
54 8/24/2018
55 8/24/2018
CITY OF ANDOVER
Budget Worksheet
- 2019
Function: Public Works
Snow &
Ice - 43200
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries - Regular
230,598
255,148
134,381
148,108
122,247
-
-
-
60210
FICA
12,552
16,123
7,679
9,484
7,429
-
-
-
60220
Medicare
2,938
3,771
1,797
2,225
1,738
-
-
-
60310
Health Insurance
24,112
30,238
17,430
18,412
19,081
-
-
-
60320
Dental Insurance
1,383
1,704
872
826
753
-
-
-
60330
Life Insurance
44
54
24
22
20
-
-
-
60340
Long -Term Disability
501
612
288
284
263
-
-
-
60410
PERA
15,257
19,540
9,631
11,712
9,387
-
-
-
60520
Workers Comp
-
-
-
2,989
4,473
-
-
-
60990
Inter -City Labor Allocation
-
-
-
-
265,675
265,675
280,641
Salaries & Benefits
287,385
327,190
172,102
194,062
165,391
265,675
265,675
280,641
Departmental
61005
Supplies -General
132
188
113
102
151
-
-
61020
Supplies - Operating
2,790
2,100
22
2,929
272
4,500
4,500
4,500
61105
R & M Supplies - General
12,007
12,662
11,090
11,968
9,622
10,000
10,000
15,000
61125
R & M Supplies - Streets
174,931
139,938
99,991
98,756
118,013
125,000
125,000
130,000
61320
Annual Dues / Licenses
150
175
303
2,444
2,786
3,600
3,600
4,300
61325
Subscriptions / Publications
455
422
420
375
715
Departmental
190,465
155,485
111,939
116,574
131,559
143,100
143,100
153,800
Operating
62100
Insurance
3,877
3,877
3,993
3,993
3,993
3,993
3,993
3,993
62205
Central Equipment Services
149,072
149,072
153,544
153,544
148,938
148,938
148,938
148,938
Operating
152,949
152,949
157,537
157,537
152,931
152,931
152,931
152,931
Professional Services
63100
R & M General
-
1,530
500
-
-
1,000
1,000
1,000
Professional Services
-
1,530
500
-
-
1,000
1,000
1,000
Total
630,799
637,154
442,078
468,173
449,881
2,70616
2,706
588,372
55 8/24/2018
Capital Outlay
65600 Equipment
Capital Outlay
Total
162,861 187,935 204,495 167,282 214,540 219,418 219,418 228,431
56 8/24/2018
CITY OF ANDOVER
Budget Worksheet -2019
Function: Public Works
Street Signs - 43300
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries - Regular
95,532
100,726
124,450
109,354
119,918
62,433
62,433
64,214
60210
FICA
5,777
5,943
7,391
6,806
7,302
3,871
3,871
3,981
60220
Medicare
1,353
1,391
1,729
1,598
1,708
905
905
931
60310
Health Insurance
9,439
9,805
11,752
11,181
11,893
7,500
7,500
9,000
60320
Dental Insurance
660
635
737
698
748
542
542
550
60330
Life Insurance
19
19
20
18
19
20
20
20
60340
Long -Term Disability
242
243
249
248
264
162
162
167
60410
PERA
6,564
6,744
8,128
8,061
8,393
4,682
4,682
4,816
60520
Workers Comp
1,356
1,402
1,437
2,812
4,388
2,248
2,248
2,312
60990
Inter -City Labor Allocation
-
-
-
-
75,377
75,377
78,262
Salaries &Benefits
120,942
126,908
155,893
140,776
154,633
157,740
157,740
164,253
Departmental
61005
Supplies- General
990
130
-
-
48
100
100
100
61020
Supplies- Operating
4,571
7,712
3,481
1,836
3,957
5,000
5,000
5,000
61030
Supplies - Signs
20,394
31,955
29,658
9,706
40,098
37,500
37,500
40,000
61105
R & M Supplies - General
991
92
857
593
1,016
1,000
1,000
1,000
61220
Software
-
6,670
-
-
-
-
-
-
61310
Meals / Lodging
-
227
287
49
-
500
500
500
61315
Continuing Education
150
420
-
-
200
500
500
500
61320
Annual Dues / Licenses
75
174
158
158
79
710
710
710
61325
Subscriptions / Publications
87
-
-
-
-
-
-
-
61410
Transportation / Mileage
-
-
50
50
50
Departmental
27,258
47,380
34,441
12,342
45,398
45,360
45,360
47,860
Operating
62030
Telephone
240
726
885
888
866
500
500
500
62100
Insurance
228
228
235
235
235
235
235
235
62205
Central Equipment Services
11,593
11,593
11,941
11,941
11,583
11,583
11,583
11,583
62305
Software Maintenance Contract
2,600
1,100
1,100
1,100
1,825
2,500
2,500
2,500
Operating
14,661
13,647
14,161
14,164
14,509
14,818
14,818
14,818
Professional Services
63100
R & M Labor - General
-
-
-
-
1,500
1,500
1,500
Professional Services
-
-
-
-
1,500
1,500
1,500
Capital Outlay
65600 Equipment
Capital Outlay
Total
162,861 187,935 204,495 167,282 214,540 219,418 219,418 228,431
56 8/24/2018
Function: Public Works
Account
Number Description
CITY OF ANDOVER
Budget Worksheet - 2019
Actual Actual Actual Actual Actual
2013 2014 2015 2016 2017
Traffic Signals - 43400
Budget Estimate Requested
2018 2018 2019
Operating
62005 Electric
9,765
10,249
11,086
11,684
12,184
13,500
13,500
14,000
62300 Equipment Maintenance Contra
9,940
10,050
10,298
10,381
10,661
13,500
13,500
13,500
Operating
19,705
20,299
21,384
22,065
22,845
27,000
27,000
27,500
Professional Services
63100 R & M Labor - General
6,536
14,602
8,786
5,854
13,306
10,000
10,000
12,000
Professional Services
6,536
14,602
8,786
5,854
13,306
10,000
10,000
12,000
Total
26,241
34,901
30,170
27,919
36,151
37,000
37,000
39,500
57
8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: Public Works
Street Lighting - 43500
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Operating
62005
Electric
31,702
32,646
30,664
37,089
27,596
40,000
40,000
40,000
Operating
31,702
32,646
30,664
37,089
27,596
40,000
40,000
40,000
Professional Services
63100
R & M Labor - General
-
139
400
400
400
Professional Services
139
400
400
400
Total
31,702
32,646
30,664
37,089
27,735
40,400
40,400
40,400
58 8/24/2018
CITY OF ANDOVER
Budget Worksheet- 2019
Function: Public Works
Street Lights Billed - 43600
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Operating
-
62005
Electric
181,812
177,455
177,595
175,529
119,441
187,500
140,000
147,500
Operating
181,812
177,455
177,595
175,529
119,441
187,500
140,000
147,500
Professional Services
63010
Contractual Services
28,519
25,693
23,905
24,980
25,010
33,000
33,000
33,000
Professional Services
28,519
25,693
23,905
24,980
25,010
33,000
33,000
33,000
Total
210,331
203,148
201,500
200,509
144,451
220,500
173,000
180,500
59 8/24/2018
60 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: Public Works
Parks & Recreation - 45000
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries - Regular
472,900
509,919
575,563
590,583
603,077
550,109
550,109
560,519
60140
Salaries - Council / Commission
3,660
3,640
3,720
3,410
3,340
3,600
3,600
3,600
60210
FICA
28,151
30,190
34,332
35,976
35,632
34,331
34,331
34,973
60220
Medicare
6,586
7,062
8,030
8,420
8,333
8,028
8,028
8,181
60310
Health Insurance
68,325
78,017
91,626
99,766
100,541
89,480
89,480
95,600
60320
Dental Insurance
3,059
3,188
3,775
3,742
3,876
3,794
3,794
3,850
60330
Life Insurance
103
105
108
103
106
160
160
160
60340
Long -Term Disability
1,183
1,246
1,207
1,287
1,361
1,328
1,328
1,354
60410
PERA
32,622
34,360
40,390
41,619
41,951
41,256
41,256
42,038
60520
Workers Comp
10,838
12,319
12,746
15,636
22,068
19,805
19,805
20,180
60990
Inter -City Labor Allocation
-
-
-
-
-
71,323
71,323
76,774
Salaries & Benefits
627,427
680,046
771,497
800,542
820,285
823,214
823,214
847,229
Departmental
61005
Supplies - General
377
799
631
423
661
-
-
-
61020
Supplies -Operating
29,919
19,133
32,733
21,651
28,049
32,500
32,500
37,000
61025
Supplies -Cleaning
255
755
349
786
1,708
3,000
3,000
3,000
61105
R & M Supplies -General
11,413
9,557
9,919
11,910
6,562
12,000
12,000
15,000
61130
R & M Supplies -Landscape
25,326
41,006
43,670
37,103
30,033
37,500
37,500
37,500
61205
Small & Expend- Small Tools
1,621
907
5,611
2,108
3,322
5,000
5,000
6,000
61220
Software
-
-
-
5,160
761
4,000
4,000
4,000
61310
Meals / Lodging
-
-
-
-
40
100
100
100
61315
Continuing Education
200
1,405
1,880
1,100
1,738
2,000
2,000
2,000
61320
Annual Dues/Licenses
262
182
188
239
350
400
400
400
61405
Postage
246
148
172
125
133
700
700
700
61410
Transportation / Mileage
-
112
245
36
48
200
200
200
Departmental
69,619
74,004
95,398
80,641
73,405
97,400
97,400
105,900
Operating
62005
Electric
42,266
41,280
44,070
39,893
52,140
50,000
50,000
50,000
62010
Water &'Sewer Service
33,848
22,082
36,557
30,279
34,339
38,000
38,000
38,000
62015
Natural Cas
386
624
391
354
368
1,200
1,200
1,200
62020
Refuse Collection
11,891
8,218
10,213
10,128
9,774
10,500
10,500
10,500
62025
Storm Water Utility Charge
918
739
1,280
1,086
1,139
1,200
1,200
1,200
62030
Telephone
2,477
3,557
4,207
4,138
4,825
5,000
5,000
6,500
62100
Insurance
13,193
13,193
13,589
13,589
13,589
13,589
13,589
13,589
62200
Rentals
14,827
11,023
16,031
12,612
9,521
16,000
16,000
16,000
62205
Central Equipment Services
80,334
80,334
82,744
82,744
79,292
79,292
79,292
79,292
62305
Software Maintenance Contract
1,827
Operating
200,140
181,050
209,082
194,823
206,814
214,781
214,781
216,281
Professional Services
63005
Professional Services
2,544
4,245
3,032
2,267
3,018
4,000
4,000
4,000
63010
Contractual Services
33,728
45,217
53,428
33,908
29,303
38,000
44,000
39,900
63100
R & M Labor -General
13,087
24,811
18,877
8,519
(375)
20,000
20,000
20,000
Professional Services
49,359
74,273
75,337
44,694
31,946
62,000
68,000
63,900
Capital Outlay
65300
Improvements
-
-
126,801
74,910
100,000
115,000
120,000
Capital Outlay
-
-126,801
74,910
100,000
115,000
120,000
Total
946,545
1,009,373
1,151,314
1,247,501
1,207,360
1,297,395
1,318,395
1,353,310
60 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: Public Works
Natural Resource Preservation - 45500
Account
Actual Actual
Actual Actual
Actual
Budget
Estimate
Requested
Number
Description 2013 2014
2015 2016
2017
2018
2018
2019
Salaries & Benefits
60110
Salaries - Regular - _
_ _
-
-
_
-
60210
FICA _ _
_
60220
Medicare - _
_
60310
Health Insurance - -
- 50
5
60320
Dental Insurance
60330
Life Insurance - _
_
60340
Long -Term Disability - -
_
60410
PERA - _
-
60520
Workers Comp _ _
_ _
_
-
_
-
60990
Inter -City Labor Allocation -
- -
-
1,604
1,604
1,661
Salaries & Benefits - -
- 50
5
1,604
1,604
1,661
Departmental
61020
Supplies - Operating - -
_ _
_
_
_
_
61105
R & M Supplies - General - _
_ _
_
_
-
_
61130
R & M Supplies - Landscape -
- 1,000
1,174
2,500
2,500
2,500
Departmental - -
- 1,000
1,174
2,500
2,500
2,500
Operating
62200
Rentals
62205
Central Equipment Services -
-
970
970
970
-
970
Operating - -
-
970
970
970
970
Professional Services
63005
Professional Services - -
- -
1,260
2,000
5,500
2,000
63010
Contractual Services - -
- 6,205
3,094
4,500
4,500
7,000
63100
R & M Labor - General
Professional Services - -
- 6,205
4,354
6,500
10,000
9,000
Total - -
- 73255
6,503
11,574
15,074
14,131
61
CITY OF ANDOVER
Budget Worksheet - 2019
Function: Public Works Recycling - 46000
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
62 8/24/2018
Salaries & Benefits
60110
Salaries - Regular
62,019
43,331
39,831
38,588
59,399
23,629
23,629
24,936
60210
FICA
3,700
2,527
2,356
2,392
3,327
1,465
1,465
1,546
60220
Medicare
865
591
551
559
778
343
343
362
60310
Health Insurance
7,911
6,188
1,649
1,065
3,088
-
-
-
60320
Dental Insurance
551
376
112
105
182
-
-
_
60330
Life Insurance
16
11
4
3
5
20
20
20
60340
Long -Term Disability
171
115
40
31
60
61
61
65
60410
PERA
4,478
3,120
1,239
1,185
3,952
1,772
1,772
1,870
60520
Workers Comp
1,262
1,280
1,318
1,022
2,174
851
851
898
60990
Inter -City Labor Allocation
-
-
-
-
37,819
37,819
40,158
Salaries & Benefits
80,973
57,539
47,100
44,950
72,965
65,960
65,960
69,855
Departmental
61005
Supplies- General
94
397
119
121
309
300
300
300
61020
Supplies - Operating
1,219
2,766
2,363
1,176
993
3,000
3,000
3,000
61310
Meals / Lodging
-
257
69
51
15
150
I50
150
61315
Continuing Education
285
-
40
295
-
-
-
_
61320
Annual Dues / Licenses
220
185
150
35
150
1,000
1,000
1,000
61405
Postage
3,468
1,646
1,814
3,418
3,625
3,000
3,000
3,000
61410
Transportation / Mileage
281
655
-
480
425
425
425
Departmental
5,567
5,906
4,555
5,576
5,092
7,875
7,875
7,875
Operating
62005
Electric
-
414
469
485
474
-
_
-
62020
Refuse Collection
2,247
2,163
1,891
3,442
8,352
2,200
2,200
10,000
62205
Central Equipment Services
661
661
681
681
681
681
681
681
Operating _
2,908
3,238
3,041
4,608
9,507
2,881
2,881
10,681
Professional Services
63010
Contractual Services
32,645
43,545
65,843
59,899
74,772
70,000
70,000
70,000
63025
Publishing
1,503
842
7,497
9,827
7,620
10,000
10,000
10,000
63100
R & M Labor - General
-
2,832
-
500
500
500
Professional Services
34,148
47,219
73,340
69,726
82,392
80,500
80,500
80,500
Capital Outlay
65200
Building
54,514
-
-
_
-
-
_
-
65300
Improvements
-
Capital Outlay
54,514
_
_
_
Total
178,110
113,902
128,036
124,860
169,956
157,216
157,216
168,911
62 8/24/2018
CITY OF ANDOVER
Budget Worksheet - 2019
Function: Other
Other Rollup
Account
Actual
Actual
Actual
Actual
Actual
Budget
Estimate
Requested
Number
Description
2013
2014
2015
2016
2017
2018
2018
2019
Professional Services
63900
Miscellaneous
42,465
44,152
31,342
20,824
4,525
30,100
7,500
30,100
63905
Contingency
33,045
37,033
25,378
12,253
10,350
40,328
22,500
90,328
Professional Services
75,510
81,185
56,720
33,077
14,875
70,428
30,000
120,428
Other Financing Uses
67101
Operating Transfers Out
135,000
-
200,000
250,000
750,000
Other Financing Uses
135,000
200,000
250,000
750,000
Total
210,510
81,185
256,720
283,077
764,875
70,428
30,000
120,428
63
CITY OF ANDOVER
Budget Worksheet - 2019
Function: Other Unallocated -49100
Account Actual Actual Actual Actual Actual Budget Estimate Requested
Number Description 2013 2014 2015 2016 2017 2018 2018 2019
Professional Services
63900 Miscellaneous
42,465
44,152
31,342
20,824
4,525
30,100
7,500
30,100
63905 Contingency
33,045
37,033
25,378
12,253
10,350
40,328
22,500
90,328
Professional Services
75,510
81,I85
56,720
33,077
14,875
70,428
30,000
120,428
Other Financing Uses
67101 Operating Transfers Out
135,000
200,000
250,000
750,000
-
-
Other Financing Uses
135,000
200,000
250,000
750,000
-
-
-
Total
210,510
81,185
256,720
283,077
_164,875L
0,428
30,000
120,428
64 M4/2018
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.CI.ANDOVER.MN.US
TO:
FROM:
SUBJECT:
DATE:
Mayor and Councilmembers
Jim Dickinson, City Administrator
Preview 2019 Preliminary Tax Levy
August 28, 2018
0
INTRODUCTION
Each year the City Council is required by state law to approve a preliminary budget and submit a
preliminary levy certification to Anoka County Property Records and Taxation Division. Legislation
requires the certification to take place by September 30th.
DISCUSSION
Below is a sample message that will be updated after the August 28th Council workshop 2019 Budget
Proposal discussion. This memo and attachments are assuming a 5.53 % gross levy increase that will
be presented at the August 28th Council workshop and is subiect to change
The 2019 Preliminary Levy certification would be the outcome of the numerous budget workshops held
with the Council over the summer. The Preliminary 2019 Budget proposes a total property tax levy of
$13,103,487: $8,945,970 (68.27%) operational levy, $2,115,729 (16.15%) debt service levy, and
$2,041,788 (15.58%) capital/watershed levy.
The 2019 Proposed Property Tax Levy is estimated to increase the current City tax rate by 2.76%. That
rate will be applied to the City's growing tax base and will reflect a 5.53% 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, 2018.
BUDGETIMPACT
This is the first step in establishing the City of Andover property tax levy for 2019.
ACTION REQUESTED
The Andover City Council is requested to receive a brief presentation, discuss and provide direction to staff
on what type of presentation is desired at the September 18th City Council meeting when staff anticipates
requesting the 2019 Preliminary Tax Levy to be set by the City Council.
submitted,
Attachments: Resolution Adopting the Proposed 2019 Property Tax Levy
CITY OF ANDOVER
COUNTY OF ANOKA
STATE OF MINNESOTA
RES. NO.
A RESOLUTION ADOPTING THE CITY OF ANDOVER 2019 PROPOSED PROPERTY TAX LEVY TO BE
CERTIFIED TO THE COUNTY AUDITOR.
WHEREAS, the preparation and adoption of operating budgets is recognized as sound financial practice; and
WHEREAS, the City of Andover receives significant financial support from its residents through the payment
of property taxes; and
WHEREAS, the City of Andover has the responsibility to appropriately and efficiently manage the public's
funds; and
WHEREAS, Minnesota State Law requires the City to certify to the County Auditor a proposed tax levy prior
to September 30, 2018.
NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Andover hereby adopts the
proposed 2019 property tax levy totaling $13,103,487 as listed on Attachment A.
Adopted by the City of Andover this 18th day of September 2018.
ATTEST:
Michelle Harmer — Deputy City Clerk
CITY OF ANDOVER
Julie Trude - Mayor
STATE OF MINNESOTA)
COUNTY OF ANOKA )
CITY OF ANDOVER )
I, the undersigned, being the duly qualified and acting City Clerk of the City of Andover, Minnesota, do hereby
certify that I have carefully compared the attached Resolution No. adopting the 2019 Proposed
Property Tax Levy with the original record thereof preserved in my office, and have found the same to be true
and correct transcript of the whole thereof.
IN TESTIMONY WHEREOF, I have hereunto subscribed my hand this 18th day of September 2018.
Michelle Hartner — Deputy City Clerk
CITY OF ANDOVER MINNESOTA Attachment A
2019 Proposed Property Tax Levy
Proposed
2019
Levy
General Fund Levy
General Operations $ 8,845,970
Park Repair/Replacement Items 100,000
Total General Fund 8,945,970
Debt Service Funds Levy
2010A G.O. Open Space Referendum Bonds
183,989
2012C Taxable G.O. Abatement Bonds
969,378
2014A G.O. Equipment Certificate
294,525
2016A G.O. Equipment Certificate
142,837
2019 Capital Improvements Bonds
525,000
Total Debt Service 2,115,729
Other Levies
Capital Projects Levy
Capital Equipment/Project
275,000
Capital Equipment Purchases
_
Facility Maintenance Reserve
355,000
Parks Projects
15,000
Road & Bridge
1,254,788
Pedestrian Trail Maintenance
102,000
Lower Rum River Watershed
40,000
Total Other
2,041,788
Gross City Levy
$ 13,103,487
?C I T Y 0 F
CN D6 06 VVE9
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: July 2018 General Fund Budget Progress Report
DATE: August 28, 2018
INTRODUCTION
The City of Andover 2018 General Fund Budget contains total revenues of $11,085,238 and total
expenditures of $11,319,815; 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 2018
reflecting year to date actual through July 2018. The attachment provided is to assist discussion
in reviewing 2018 progress; other documents may be distributed at the meeting
The following represents Administration's directives and departmental expectations in place for
2018:
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 from staff.
mitted,
CITY OF ANDOVER
General Fund Budget Summary Totals
Budget Year 2018
2017 2018
REVENUES Budget July YTD %Bud Final Budget July YTD %Bud
General Property Tax
$ 8,420,354
$ 4,364,254
52%
$ 8,332,634
$ 8,721,256
S 4,671,673
54%
Licenses and Permits
367,705
330,224
90%
544,568
377,900
313,502
83%
Intergovernmental
766,150
337,699
44%
793,931
766,274
350,848
46%
Charges for Services
773,950
463,067
60%
787,042
746,700
423,336
57%
Fines
100,750
39,959
40%
75,287
90,250
37,311
41%
Investment Income
75,000
19,980
27%
64,751
75,000
12,138
16%
Miscellaneous
124,300
115,020
93%
179,789
129,300
98,222
76%
Transfers In
196,930
196,930
100%
196,930
178,558
178,558
100%
Total Revenues
$ 10,825139
$ 5,867,133
54%
$ 10,974,932
$ 11,085,238
$ 6,085,58$
55%
2017 1 2018
EXPENDITURES Budget July YTD % Bud Final Budget July YTD % Bud
GENERAL GOVERNMENT
2,962,551
1,422,522
446,688
24,847
5,950
2,221,913
723,848
260,501
12,051
1,124
75%
51%
58%
49%
19%
2,962,551
1,353,209
443,712
16,320
2,544
3,053,526
1,423,914
462,164
32,502
5,950
1,526,763
722,761
250,102
12,884
1,103
50%
51%
54%
40%
19%
Mayor and Council
$ 89,991 $
61,106
68% $
84,136
$ 91,298
$ 61,599
67%
Administration
199,541
112,503
56%
187,514
203,833
115,047
56%
Newsletter
26,000
13,953
54%
25,287
26,000
12,425
48%
Human Resources
27,913
14,081
50%
15,520
28,431
12,932
45%
Attorney
191,360
94,416
49%
188,644
191,360
94,028
49%
City Clerk
148,599
89,314
60%
147,450
155,608
90,951
58%
Elections
63,881
13,288
21%
17,852
59,781
14,216
24%
Finance
268,129
171,794
64%
258,883
278,660
174,753
63%
Assessing
150,000
145,367
97%
147,914
154,000
146,403
95%
Information Services
180,722
90,239
50%
149,513
180,597
91,036
50%
Planning & Zoning
462,212
227,973
49%
398,780
438,827
240,971
55%
Engineering
535,715
302,450
56%
511,183
553,765
309,178
56%
Facility Management
681,733
268,555
39%
509,547
678,519
269,336
40%
Total General Gov
3,025,796
1,605,039
53%
2,642,223
3,040,679
1,632,875
54%
PUBLICSAFETY
Police Protection
Fire Protection
Protective Inspection
Civil Defense
Animal Control
2,962,551
1,422,522
446,688
24,847
5,950
2,221,913
723,848
260,501
12,051
1,124
75%
51%
58%
49%
19%
2,962,551
1,353,209
443,712
16,320
2,544
3,053,526
1,423,914
462,164
32,502
5,950
1,526,763
722,761
250,102
12,884
1,103
50%
51%
54%
40%
19%
Total Public Safety
4,862 558
3,219,437
66%
4,778,336
4,978,056
2 513 613
50
PUBLIC WORKS
38,600
0%
38,600
8,500
22%
Streets and Highways
614,668
351,134
57%
597,964
659,943
364,903
55%
Snow and Ice Removal
547,777
291,034
53%
449,881
562,706
445,724
79%
Street Signs
215,244
115,665
54%
214,540
219,418
120,184
55%
Traffic Signals
37,000
12,973
35%
36,152
37,000
12,834
35%
Street Lighting
38,400
13,565
35%
27,735
40,400
16,405
41%
Street Lights - Billed
217,500
71,263
33%
144,451
220,500
69,499
32%
Park & Recreation
1,275,530
698,022
55%
1,207,359
1,318,395
684,229
52%
Natural Resource Preservation
12,697
884
0%
6,503
15,074
2,320
15%
Recycling
122,221
89,177
53%
169,956
157,216
104,743
67%
OTHER
Miscellaneous
31,728
14,850
47%
764,875
31,828
3,115
10%
Youth Services
38,600
0%
38,600
8,500
22%
Total Other
70,328
14,850
21%
764,875
70,428
11,615
16%
Total Expenditures $
11,039,719
$ 6,483,043
59%
$ 11,039,975
S 11,319,815
$ 5,978,944
53%
NET INCREASE (DECREASE) $
(214,580)
S (615,910)
$ (65,043)
S (234,577)
$ 106,644
AN T
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: July 2018 City Investment Reports
DATE: August 28, 2018
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 July 2018 the July 2018 Investment
Detail Report, and the July 2018 Money Market Funds Report. These attachments are
intended to provide a status report on the July 2018 investments.
ACTION REQUESTED
Informational, for Council review. Staff will provide a brief presentation and answer questions.
submitted,
Attachments
Investment Maturities - July 2018
Deposits
Total cash and investments
Credit
Investment Type
Rating
Fair
Less Than
Money market funds
N/A
MN Municipal Money
Value
Market Fund (4M)
N/A
Premier Banks Money
10
Market Fund
N/A
Certificates of deposit
FDIC
Local governments
A/A 1 /A2
1,019,606
AAI/AA2/AA3
AAA
State governments
A/Al/A2
275,990
AAI/AA2/AA3
AAA
U.S. agencies
AAA
FNMA REMIC
N/A
U.S. agencies
N/A
Total investments
222,084
Deposits
Total cash and investments
Investment Maturities (in Years)
Fair
Less Than
More Than
Value
1
1-5
6-10
10
$ 3,233,615
$ 3,233,615
$
$
$
1,019,606
1,019,606
275,990
275,990
-
12,370,935
8,078,014
4,292,921
-
_
443,632
120,762
222,084
100,786
-
5,338,474
1,618,622
2,633,477
983,597
102,778
4,593,904
854,609
2,959,510
779,785
-
200,180
-
200,180
1,056,142
284,839
771,302
-
-
585,371
125,139
460,232
-
-
11,382,632
3,234,388
7,996,154
152,090
6
6
197,871
197,871
-
-
-
$ 40,698,357
$ 19,043,460
$ 19,535,860
$ 2,016,258
$ 102,778
620,780
$ 41,319,137
July 2018 Investment Detail
Description
Cusip
Number
Credit
RatinglF
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Date
Acquired
Coupon
Date
Maturity 1
Due Date
Israel Discount Bank of NY
Pacific Western Bank _
BMO Harris Bk _
Cathay Bank
ZB NA _
Beal Bk _ _
BNY Mellon
465076JU2
19977
24045
_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
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
1.450%
1.450%
1.400%
1.500%
244,975.50
244,975.50
244,941.20
244,906.90
244,916.70
244,892.20
maturity08/09!17
none
08/09/18
08/09/18
69506YFT1
_05581WST3
149159LR4
maturity
maturity
maturity
maturity
maturity
maturity
maturity
08109/17
none
none
none
none
none
none
_ 16571
18503_
2270
57833
7946
_33648 _
10/20/17
12/07/17
12/07/17
12/13/17
08/20/18
09/07/18
09/07/18
CD
98878BLCO
_CD
_CD
CD
245,000.00
245,000.00
245,000.00
245,000.00
1.500%
1.500%
1.550%
1.450%
07370W5B8
09/12/18
05584CBA3
244,906.90
244,728.05
12/12/17
09112118
10117118
Bank India New York _
06279H4M2
CD
10/19/17
none
CD F & M Bank
30246AFM5
9963
CD
245,000.00
245,000.00
245,000.00
1.350%
244,664.35
maturity
10/20117
none
10/19/18
New York Community Bank
Amex Centurion Bk _
1 Year CD - Premier Bank
1 Year CD- Premier Bank Rochester
1 Year CD - Premier Bank MN _
BMW Bank of North America
Safra National Bk _
TCF National Bank
Beak Bank SSB _
Bank Hapoalim, BM of NY_
Bank Baroda New York
Berkshire Bk Pittsfield MA
Customers Bank
Banner Bank _
First Foundation Bk _ _
Ally Bank Midvale Utah
Barclays Bank _
Synchrony Bank _
JP Morgan Chase Bank NA
Fanners & Merchants Banc
BankUniled A Savings
Mcuntain_0_ne Bank _
PrivateBank & Trust Co _ _
Goldman Sachs Bank USA__
Oneida County NY
649447RD3
02587DU63
16022
CD
245,000.00
245,000.00
245,000.00
1.600%
244,789.30
maturity
12122/17
none
10122118
CD
245,000.00
245,000.00
245,000.00
245,000.00
1.550%
244,710.90
maturity
08/03/17
02/08/18
none
none
11/08/18
1091003210
2055214401
3041574901
_27471
21714
_33202
CD
CD
245,000.00
245,000.00
245,000.00
1.500%
245,000.00
maturity
12/16/17
12/16/17
12/16/18
12116/18
12/16/18
01/22/19
02/27/19
02/28/19
04/10119
04/18/19
04/23119
04/24119
05/21/19
05/23/19
05/28/19
07101119
07/02/19
07/11/19
07/15/19
07/17/19
07/18/19
07/18/19
07122/19
245,000.00
245,000.00
245,000.00
245,000.00
1.500%
1.500%
245,000.00
245,000.00
maturity
maturity
CD
245,000.00
12/16/17
none
07/22/16
05580ADR2
78658Q2Q5
87227BX76
_33204
35141
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
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
247,000.00
247,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
1.600%
1.950%
244,470.80
244,767.25
244,693.75
semi-annual
maturity
01/22/16
26876
28330
CD
02/28/18
none
CD
CD
CD
CD
CD
CD
CD
1.900%
2.000%
2.100%
maturity
maturity
maturity
maturity
maturity
semi-annual
semi-annual
semi-annual
semi-annual
02128118
04/11/18
04/20/18
04/23/18
04/24/18
02/21/18
02/23/18
02/28/18
none
none
none
none
none
08121118
08123/18
08/28/18
12/30/16
07370XDZ4
06251AT42
06062RC42
084601NP4
23204HFAl
32574
33686
33681
23621
34444
28489
_5_8647
57803 _
57203
244,710.90
244,857.90
244,752.55
244,571.25
244,541.85
244,333.60
244,500.20
242,432.40
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
245,000.00
247,000.00
247,000.00
2.050%
1.950%
2.000%
1.850%
06652XFP5
32026UFSO
02006LF32
06740KHB6
87164WBT4
48125Y5L4
308IONBGO
066519FX2
62452ACG3
CD
CD
2.000%
245,000.00
247,000.00
247,000.00
1.200%
06/30/16
CD
CD
2.050%
246,244.18
246,152.79
242,160.45
semi-annual
semi-annual
quarterly
07/03/14
07/11/14
01/02115
01/11/15
10/15/16
2.050%
_27314
628 _
1895
58979
90253
CD
245,000.00
245,000.00
245,000.00
1.100%
07/15/16
CD
245,000.00
245,000.00
245,000.00
2.300%
2.300%
2.250%
2.000%
244,840.75
244,830.95
244,713.35
246,066.34
245,965.07
semi-annual
maturity
maturity
semi-annual
semi-annual
semi-annual
07/17/18
01/17/19
none
CD
245,000.00
245,000.00
247,000.00
247,000.00
245,000.00
245,000.00
247,000.00
247,000.00
245,000.00
245,000.00
247,000.00
247,000.00
07/18/18
CD
07/18/18
07/21114
none
01/21/15
74267GUQB
38147JU59
33306
CD
_
33124
CD
2.050%
07/23/14
01/23/15
07/23/19
6824543R2
-At _
A2
local
22,877.60
22,877.60
20,000.00
100,000.00
6.250%
20,506.40
100,256.00
08/16110
none
D4/15/19
Junction City Kansas
481502F72
local
101,558.00
101,558.00
5.500%
semiannual
05/28/08
03/01/09
09/01/18
Farmington MN
311297W84
AA
local
102,787.00
102,787.00
100,000.00
2.000%
100,296.00
semi-annual
07/06/16
none
02/01/19
_ _ _
Rice Cnty MN
762698GK8
AA
local
45,466.80
45,466.80
40,000.00
140,000.00
4.400%
4.302%
40,316.80
semi-annual
semi-annual
03/07/12
none
02/01/19
08/01/18
04/01/19
12/01/18
Indiana St Bond Bank _ _
Ramsey MN _
Minneapolis MN
454624540
AA+
AA+
local
146,123.60
158.677.85
111,898.00
146,123.60
158,677.85
140,000.00
12130/16
none
751813PB6
local
local
145,0_00.00
100,000.00
4.500%
145,224.75
semi-annual
02/16/12
04/01116
60374YS73
_
111,898.00
3.250%1
100,323.00
semi-annual
06/05/12
12/01/11
Orange Beach ALA _ _
Cedar Rapids IA
68406PHF1
150528RM1
_ _AAt
AAI
AA
local
241,689.60
241,689.60
240,000.00
200,000.00
4.400%
242,018.40
semi-annual
08/05/10
02/01/11
12/01/13
02/01/19
06101/19
kcal
217,672.00
217,672.00
3.000%
200,634.00
semi-annual
06/11/13
8,078,013.83 CD
Description
Cusip
Number
Credit
RCredit
ling
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Date
Acquired
Coupon
Date
Maturity/
Due Date
Multnomah CntyOR Sch Dist IJ
Sioux City IA _ _
Waterloo IA
Kane McHenry Cook & De Kalb Zero Cpn
Brownsville TX ISD Zero Coupon
King Cnty WA
Minnetonka MN ISD #276
Palm Beach Cnty FLA _
Tenn Val Auth Cpn Strip Zero Cpn
625517JMD
829458FC7
AA1 _
AA2
AA2_
local
local
local
local
local
local
local
local
local
250,000.00
156,100.50
50,559.50
157,328.00
250,000.00
156,100.50
50,559.50
157,32_8.00
229,640.00
224,634.00
37,433.20
87,444.75
262,890.00
250,000.00
155,000.00
50,000.00
200,000.00
250,000.00
200,000.00
35,000.00
75,000.00
300,000.00
200,000.00
1.450%
2.000%
247,555.00
154,265.30
semi-annual
08/10/17
12/15/17
06/15/19
06101119
06/01/19
12/01/18
serol-annual
semi-annual
maturity
maturity
semi-annual
semi-annual
12/22/16
none
12/01/13
none
none
none
none
none
none
941647PA1
2.000%
3.980%
3.100%
5.898%
49,746.50
06/27113
07/16/12
484080MB9 _
116421E46
49474E3L5
604195RA7
696497TR7
88059EWZ3
AA3
AAA
AAA
AAA
AAA
AAA
198,242.00
249,750.00
201,144.00
35,047.95
229,640.00
06/26/13
03/27/12
12/22/11
07/06/11
12/27/13
08/15/18
12/01/18
02/01/19
06/01/19
06115/19
10101118
05/01/19
224,634.00
37,433.20
87,444.75
262,890.00
76,203.00
semi-annual
maturity
292,464.00
Washington State
939758DL9
AA
state
state
205,804.00
84,864.00
205,804.00
4.500%
200,362.00
semi-annual
01/24/12
04/01/12
Colorado St Hs_g_&_Fin Auth
Georgia State
Texas State _
Fed Farm Credit Bank
Fed Farm Credit Bank
Fed Home Ln Bank
Gov[ Nall Mtg Assn
Fed Farm Credit Bank _
Fed Farm Credit Bank _
Fed Nall Mtg Assn
Fed Farm Credit Bank
Fed Farm Credit Bank _
Fed Farm Credit Bank
Fed Home Ln Bank
Fed Nall Mtg Assn
Fed Home Ln Mtg Corp
Fed Nat] Mtg Assn
Fed Nag Mtg Assn Remic _
FICO Strip Cpn13 Zero Coupon
FICO Strip Cpn Zero Coupon
Sallie Mae Bank
First Federal Svgs Bk
Victory Bank _
CommerceWesl Bank N/A
Umpqua Bk Roseburg Ore
Third Federal Sav & Loan__ _
Celtic Bank
Steams Bank NA _
Jefferson Bk & Tr Co
196479A82
AA2
84,864.00
26,742.50
85,000.00
25,000.00
100,000.00
1.875%
84,477.25
semi-annual
01126/18
none
373384RQ1
AAA
state
26,742.50
2.970%
2.894%
25,032.25
100,107.00
semi-annual
02/08/12
none
10/01/18
882722,151
AAA
state
103,089.00
103,089.00
semi-annual
08/10111
04/01/12
10/01/18
08/01/18
09/24/18
11/02/18
11/14/18
31331Y4S6
3133EGK87
AAA_
AAA
US
114,000.00
199,462.00
249,862.50
448,245.00
114,000.00
100,000.00
5.050%
100,000.00
semi-annual
09/11113
none _
none
199,462.00
249,862.50
448,245.00
249,870.00
199,711.60
199,300.00
99,587.00
251,285.00
199,654.80
250,470.00
200,000.00
297,417.00
299,700.00
5.77
200,000.00
250,000.00_
450,000.00
250,000.00
200,000.00
200,000.00
100,000.00
250,000.00
200,000.00
250,000.00
200,000.00
300,000.00
300,000.00
5.65
1.020%
199,690.00
semi-annual
_semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
monthly
maturity
03/30/17
3130ACR89
AAA
AAA
_US
US
US
1.375%
1.060%
249,540.00_
448,632.00
249,092.50
11/03/17
08/21/17
05/02/18
none
3136GiLU1
3133EHQF3
3133EG3X1
3136GOY70
3133EC5NO
3133EDTU6
3133EHLZ4
3133782M2
3136G1FYO
AAA
US
US
US
US
US
_ US
US
US
US
US
US
249,870.00
199,711.60
199,300.00
99,587.00
251,285.00
199,654.80
250,470.00
200,000.00
297,417.00
1.350%
07/07/17
06/16/17
10/30/12
01/07113
07/07117
06/16/17
07/07/17
06/22/17
12/14/17
07/19/17
07/30/03
12129114
04/17115
08/09/17
01/21/16
01/07/18
07/17/17
01/30/13
03/04/13
03/04115
09/06/17
09/08112
none
10/15/16
10/26/16
none
none
none
01/07/19
01/17/19
01130/19
03/04/19
03/04/19
03/06/19
03/08/19
03/13/19
04/15119
04126/19
08125118
12/27/18
02/01/19
AAA
AAA
_ AAA
AAA
1.250%
1.080%
1.250%
1.700%
1.270%
1.500%
1.375%
1.125%
199,062.00
198,816.00
99,365.00
249,075.00
198,740.00
248,855.00
198,794.00
297,420.00
297,306.00
AAA _
AAA
AAA
AAA
3137EADZ9
3135GOK28
_AAA
299,700.00
1.250%
4.500%
31393EAL3
204,187.50
5.64
99,024.00
31771C2G9
31358BAA6
US
93,140.00
93,140.00
100,000.00
US
CD
94,480.00
94,480.00
245,000.00
249,000.00
100,000.00
245,000.00
249,000.00
247,000.00
245,000.00
245,000.00
98,847.00
14,514,249.57
maturity
semi-annual
monthly
1.700%
1.500%
58177
243,248.25
247,924.32
245,685.96
244,421.80
08109119
08/21/19
09124/19
10/25/19
10/28/19
11/25/19
12/20/19
12/26/19
04/10/20
79545OB95
245,000.00
02/09/18
02/21/16
03/24115
10/25/18
32021YCH4
92644LAB8_
_
29690
_
CD
249.000.00
247,000.00
58615
CD
247,000.00
245,000.00
245,000.00
128,000.00
2.000%
semi-annual
09124114
04/25/18
57176
CO
245,000.00
245,000.00
128,000.00
247,000.00
2.300%
2.350%
semi-annual
_20084TKXO
9D421MBZ5
17266
CD
244,559.00
semi-annual
04127/18
10127/18
88413QAWB
30012
CD
128,000.00
2.000%
127,274.24
semi-annual
11/24/14
05124115
15118RJMO
57056
CD
247,000.00
247,000.00
247,000.00
2.050%
245,940.37
semi-annual
12/20/13
06120/14
857894PB9
472376AD4
10988
CD
247,000.00
247,000.00
1.000%
245,429.08
semi-annual
12/26/14
06/26/15
1071
CD
245,000.00
245,000.00
245,000.00
2.450%
244,086.15
semi-annual
04/11/18
10111/18
CitiBankNA
17312QJ34
7213
CD
245,000.00
245,000.00
245,000.00
2.550%
244,478.15
semi-annual
04/11/18
10/11/18
04/13/20
Discover Bk Greenwood Del
254673NR3
5649
CD
245,000.00
245,000.00
245,000.00
2.500%
244,274.80
semi-annual
04/11/18
10/11/18
04/13/20
2,593,993.10 local
409,978.50 state
3,432,264.14 US
Less Than 1 Year
Description
Cusip
Number
Credit
Rating/F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Date
Acquired
Coupon
Date
Maturity)
Due Date
Iberia Bank _
Citizens Alliance Bank
Morgan Stanley Bank NA _
Morgan Stanley Pdvate Bank
MUFG Union Bank NA _
Enerbank USA
NBT Bank Norwich _ _
Elbow Lake MN
Kaufman TX _ _
Steams Co MN _
Minneapolis MN
Hampton VA
Middleton Wl
45083AJL7
17318LAP9
61747M3Q2
61760AMT3
624786CY3
29266NA31
628779FT2
284281 KC5
486206KR5
28100
CD
245,000.00
249,000.00
245,000.00
249,000.00
245,000.00
245,000.00
245,000.00
249,000.00
245,000.00
170,045.70
245,000.00
249,000.00
245,000.00
245,000.00
245,000.00
249,000.00
245,000.00
165,000.00
60,000.00
250,000.00
250,000.00
2.600%
2.000%
2.750%
2.750%
2.600%
2.100%
2.700%
2.750%
3.000%
244,686.40
246,649.44
244,879.95
244,877.50
244,157.20
245,740.59
244,608.00
163,610.70
58,473.00
semi-annual
monthly
07/12/18
06/27/14
01/11/19
07127/14
04/13/20
CD
06/26/20
07/13/20
07/13/20
07/17/20
07/20120
07120120
12/01/19
02/15/23
06/01/20
12/01/19
04/01/20
09/01/20
_1402
32992
CD
245,000.00
semi-annual
07/12/18
01/12/19
34221
22826
57293
7230
A _
_ A3
AA+
CD
245,000.00
245,000.00
249,000.00
245,000.00
170,045.70
semi-annual
semi-annual
monthly
semi-annual
semi-annual
semi-annual
07/12/18
07/17/18
_07/14/18
01/17/19
08/18/14
01/18/19
CD
CD
07/18114
07118/18
CD
local
12108/14
06/28/16
04/17/13
none
02/15117
none
local
61,821.00
61,821.00
857896MH4
60374YS81
local
276,875.00
276,875.00
278,632.50
4.500%
250,357.50
252,392.50
semi-annual
_
AA1
local
278,632.50
3.500%
semi-annual
0226/13
none
none
none
none
4095582J1
_ AA1 _
AA1
local
local
100,836.00
100,836.00
100,000.00
2.209%
98,980.00
semi-annual
0120/16
02/24/15
596782RX2
106,979.00
106,979.00
100,000.00
250,000.00
3.750%
3.002%
2.450%
100,088.00
semi-annual
semi-annual
Bristol VA_
Des Moines IA Area Cmnty Col
Minneapolis MN _
Western Lake Superior MN
Portsmouth VA
Brunswick Cnty _
Fon Du Lac Cnty, WI _ _
Adams & Arapahoe Cntys CO
Alexandria MN ISD#206
Moorhead MN _ _
Whitewater Wis
West Bend Wl
WPalm Beach FL
Norwalk Conn _ _
Greensboro NC
Mounds View MN ISD #621
Rothsay MN ISD #850
Saint Paul MN Port Auth _ _
Woodbury MN _
Dallas TX Indpl Sch Dist _
Saint Paul MN Port Auth
Tenn Valley Auth Zero Cpn _
Salt Lake County UT
110331NT8
_
AA1
local
251,562.50
251,562.50
250,927.50
49,254.00
07/05/18
10/01/20
2500971-121
_ AA1 _
local
50,606.00
50,606.00
50,000.00
semi-annual
11/10/14
12/01/14
06/01121
60374YG68
958522WU4
73723RSL8
117061VH1
344442KK3
005482W83
0151311-06
6161412R7
966204KA6
951428BNO
955116BE7
668844DS9
395460V21
620637V70
AA1 _
AQ
AA2
AA2
local
local
local
110,419.00
100,000.00
286,268.00
108,967.10
259,715.00
117,817.50
279,760.50
108,820.00
109,541.00
97,805.00
101,245.00
122,464.80
110,419.00
100,000.00
100,000.00
4.700%
101,076.00
100,530.00
293,265.40
107,077.30
250,587.50
116,582.40
266,843.70
101,304.00
104,216.00
95,792.00
94,203.00
120,135.60
362,743.20
246,422.50
199,081.35
197,400.00
115,244.95
semi-annual
10131/11
08/16/11
_ none
_04/01/12
02101/14
none
none
none
none
none
none
none
10/01/16
08/01/11
03101/23
10/01/19
02/01/20
05/0120
03101121
12/01/21
02/01/23
02/01/20
12/01/20
04/01/22
10101/22
08/01/19
10/01/19
02/01/20
02/01/20
02/01120
02/01/20
02/15/20
03/01/20
05/01/20
06/15/20
100,000.00
286,268.00
106,967.10
259,715.00
117,817.50
279,760.50
108,820.00
109,541.00
97,805.00
101,245.00
122,464.80
366,832.80
3.150%
2.400%
1.740%
3.250%
3.930%
3.000%
3.800%
4.850%
1.900%
2.264%
4.050%
3.263%
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
semiannual
semi-annual
semi-annual
295,000.00
110,000.00
250,000.00
115,000.00
270,000.00
100.000.00
100,000.00
100,000.00
100,000.00
120,000.00
360,000.00
250,000.00
195,000.00
200,000.00
115,000.00
07/17/13
08/21/15
03/10/17
07/12/18
01/21/15
11/14/11
06/09/11
01/11/18
07105/16
08104110
local
_
AA2
AA2 _
AA2
AA3
AA3
AA3
AA3
AAA
local
local
local
local
local
local
local
local
local
_local
local
local
local
_
AAA
366,832.80
246,875.00
208,640.2_5
201,806.00
123,037.35
07/15/11
none
AAA
246,875.00
208,640.25
201,806.00
1.900%
3.000%
2.000%
3250%
05/16/18
none
none
_08/01/17
none
778731AZ2
AAA
AAA_
AAA _
AAA
AAA
AAA
semi-annual
07/06/16
1222/16
1222/11
793028WS6
semi-annual
_
97913PCQ7
123,037.35
semi-annual
235308QK2
_local
local
local
local
116,900.00
79,756.80
263,970.00
368,212.50
116,900.00
100,000.00
80,000.00
300,000.00
375,000.00
4.450%
2.000%
1.800%
102,641.00
78,504.80
284,994.00
367,477.50
semi-annual
semi-annual
04/16/12
08/15/11
09101117
none
_06115/13
793067CC1
79,756.80
01/10117
88059EHD9
263,970.00
maturity
03111/13
05/18/18
795676QL2
AAA
368,212.50
semi-annual
Tenn Val Auth Cpn Strip Zero Cpn _
McAllen TX Dev Corp
Indianapolis Ind _ _
Greenway_ MN ISD #31
AAA
local
88,133.00
88,133.00
100,000.00
94,412.00
maturity
03/18/13
none
07/15/20
08/15/20
01115121
03/15121
08101/21
10/01/21
_88059EMX9
579086AW9
_ AAA
_AAA
AAA
local
local
local
175,000.00
175,000.00
175,000.00
1.400%
169,657.25
semi-annual
07/26/16
02/15/17
45528UGF2
251,507.50
251,507.50
250,000.00
2.219%
5.000%
245,910.00
25,242.50
semi-annual
07/11/17
07/15/13
39678LDF6
27,593.50
27,593.50
25,000.00
semi-annual
07/09/13
none
Baltimore CntyMID _
New York St Mtge Ally
05914FME7
AAA
AAA
local
51,290.00
51,290.00
50,000.00
2.097%
48,767.00
semi-annual
08/31/16
none
64988RHGO
local
100,000.00
100,000.00
100,000.00
2.375%
96,878.00
semi-annual
1027/15
04/01116
_
Columbus OH
199492CS6
AAA
local
39,956.40
39,956.40
40,000.00
Z.133%
38,624.40
semi-annual
02120175
none
12/01121
4,292,921.20 CD
Description
Cusip
Number
Credit
RatinglF
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
-
Date
Acquired
Coupon
Date
Maturity/
Due Date
OulagamieCntyWI
Connecticut State
MassachusegsState
Florida Sl Hurricane _
Minnesota Sl Colleges & Univ
Florida St Dept Environmental
Tennessee State
Virginia State _
Kentucky St Hsg Corp
68990OB98
20772JON5
57582P2T6
34074GDH4
60414FPJ3
3416OWUAO
880541003
928109XD4
AAA
Al
AAI
AA3
AA3
AA3
AAA
AAA_
AAA--
local
170,000.00
214,964.00
170,000.00
170,000.00
200,000.00
200,000.00
270,000.00
100,000.00
200,000.00
45,000.00
20,000.00
200,000.00
2.350%
165,374.30
200,180.00
semi-annual
11/07117
05/01118
02/15/14
11/01/14
07/01/13
10/01/15
07/01/10
02/01112
none
none
11/01/22
214,954.00
3.517%
2.090%
2.995%
2.000%
6.206%
3.178%
4.100%
2.780%
semi-annual
05/27116
12/17114
11110115
08/15/21
05/01120
07/01120
10101120
_stale
state
state
state
state
state
state
state
199,744.00
199,744.00
279,439.80
197,670.00
semi-annual
279,439.80
100,000.00
217,800.00
48,218.85
22,126.00
269,889.30
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
100,000.00
217,800.00
48,218.85
22,126.00
98,035.00
205,708.00
45,345.60
20,242.20
196,912.00
02/26/15
08/30/10
08/30/16
07/01/22
08/01120
06/01/21
07/01/21
02/07/12
03/29117
49130TSHO
203,458.00
203,458.00
semi-annual
Georgia State
373384208_
AAA
state
204,444.00
204,444.00
200,000.00
2.780%
197,732.00
semi-annual
12/13/16
none
02/01/23
_ _
Fed Home Ln Mtg Corp _ _
Fed Home Ln Mtg Corp Med Term Note _
Fed Home Ln Bank _
Fed Farm Credit Bank
Fed Farm Credit Bank _
Fed Home Ln Bank
RFCSP Strip Principal Zero Coupon
Fed Nall Mtg Assn _ _
Fed Farm Credit Bank
Fed Home Ln Mtg Corp Zero Cpn
Fed Farm Credit Bank
Fed Home Ln Bank
Fed Home Ln Mfg Corp _ _
Fed Home Ln Bank
Fed Home Ln Bank
Fed Home Ln Mill Corp Med _Tenn Note
Fed Farm Credit Bank
Fed Home Ln Mlg Corp
Fed Farm Credit Bank
Fed Nag Mtg Assn_
Fed Home Ln Bank
Fed Home Ln Bank
Fed Farm Credit Bank
Fed Home Ln Bank
Fed Nall Mtg Assn _
Fed Farm Credit Bank
Fed Home Ln Bank
3137FADK2
_3134G96U6
313383VN8
AAA
US
249,035.00
249,035.00
250,000.00
1.250%
247,032.50
semi-annual
07/07117
02/01/13
08/01/19
_
AAA
US
200,000.00
200,000.00
200,000.00
1.050%
196,918.00
quarterly
08123116
11/23/16
08/23/19
AAA
AAA
US
301,065.00
297,300.00
301,065.00
297,300.00
300,000.00
2.000%
298,281.00
semi-annual
12107117
none
09113/19
3133EGVJ1
US
300,000.00
1.160_%
1.550%
294,90_6.00
semi-annual
12/08/17
none
09/26119
_3130ACLSI
313OA8NRO
76116FAA5
3135GOJ95
3133EGBKO
31340OBV4
3133EGFR1
313381ND3
3137EAEE5
AAA
US
248,227.50
248,227.50
250,000.00
247,047.50
semi-annual
semi-annual
maturity
semi-annual
semi-annual
maturity
seml-annual
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
01104/18
04110/18
07/22/15
02/09/18
05/25/16
11/02/15
11/03/17
03123118
12/07117
07122115
07112/18
10127/17
04/11/18
10/11/16
none
10128/16
11125/16
none
none
none
07/17/17
08/10/15
11/28/18
04/27/18
11/02118
10/11/19
10/11/19
10/15/19
10/28/19
11/25/19
11/29/19
12116119
01109/20
01/17/20
02110/20
05/28/20
10/27/20
11/02/20
11/17/20
12121120
12128/20
01129/21
02/08/21
03/16/21
05/25121
06122/21
07/16121
07/27/21
11/15/21
AAA
US
US
294,603.00
294,603.00
185,568.00
98,570.00
199,600.00
950,527.00
223,031.25
147,300.00
297,912.00
99,500.00
300,114.00
200,000.00
300,000.00
200,000.00
1.125%
294,720.00
_
AAA
AAA
AAA _
AAA _
AAA
AAA
AAA
AAA
AAA
185,568.00
98,570.00
199,600.00
950,527.00
223,031.25
193,672.00
US
100,000.00
200,000.00
1,000,000.00
225,000.00
150,000.00
300,000.00
100,000.00
300,000.00
200,000.00
250,000.00
1.350%
1.300%
1.330%
1.450%
1.500%
1.500%
2.625%
1.500%
2.680%
98,297.00
196,490.00
964,070.00
220,511.25
147,381.00
295,365.00
98,257.00
299,673.00
197,110.00
298,674.00
US
US
US
US
US
US
US
US
US
147,300.00
297,912.00
99,500.00
313OA3XL3
3130AECJ7
3134GBS78
300,114.00
AAA
AAA
200,000.00
3133EJMX4
3137EAEK1
3133EJPW3
299,475.00
299,475.00
semi-annual
semi-annual
07/12/18
12/07/17
_
AAA _
AAA
US
299,193.00
299,193.00
300,000.00
1.875%
294,141.00
05/17/18
US
299,769.00
200,000.00
296,718.75
299,769.00
300,000.00
200,000.00
300,000.00
2.700%
1.850%
2.250%
299,259.00
194,294.00
295,608.00
semi-annual
05/21118
06/21118
06/28117
07/29/18
08/08/18
3136G4JM6
_
AAA
AAA
US
200,000.00
296,718.75
297,516.00
semi-annual
12128116
07/10118
3130ADG48
3130ADME9
3133EHCN1_
313OA82B8
US
semi-annual
semi-annual
semi-annual
_
AAA
AAA
AAA
_
US
297,516.00
300,000.00
2.375%
296,619.00
07112118
07110/18
295.215.00
295,215.00
300,000.00
300,000.00
300,000.00
300,000.00
2.140%
293,970.00
09/16/17
US
US
294,030.00
300,249.00
294,030.00
300,249.00
300,000.00
1.000%
2.750%
293,571.00
299,304.00
semi-annual
07/17/18
none
313500035
AAA
semi-annual
07/12/18
12122/18
3133EJUN7
AAA
US
300,000.00
2.860%
1.000%
298,881.00
semi-annual
07/16118
01/16/19
313OA8SR5
_ AAA
AAA
_ US
US
244,531.25
244,53125
250,000.00
244,055.00
semi-annual
07/10118
none
_
Fed Farm Credit Bank
3133EJPD5
299,700.00
299,700.00
300,000.00
2.870%
298,788.00
semi-annual
07/12118
11/15/18
_
Fed Home Ln Mtg Corp Med Term Note
3134GSPB5
_
AAA
US
300,000.00
300,000.00
300,000.00
2.500%
299,259.00
semi-annual
07/02118
12/28/18
06/28/22
_
19,535,860.40
Itasca County Minn
465452GP9
A
local
105,024.00
105,024.00
100,000.00
5.550%1
100,786.00
semi-annual
07/12/11
none
02/01/28
Chaska MN
161663653
AA
local
94,191.30
94,191.30
90,000.00
x.000°h
91,206.00
semi-annual
09108/14
none
02101/24
5,815,070.85 local
1,431,714.10 state
7,996,154.25 US
1- 5 Years
Description
Cusip
Number
Credit
Rating/F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Date
Acquired
Coupon
Date
Maturity/
Due Date
Mitchell SD Sch Dist#17-2
Minneapolis MN
Ann Arbor Ml __
Duluth MN
WIII County lL Cm my Zero Coupon _
Hawkins Cnty TN
Savage Minn _
Lake City Minn ISD #813
Tennessee Valley AuthSer E _ _ _ _
Milaca MlnnlSD#912
606687EHO
60374YG76
035438CF5
AA
AAi
_ AA1
_ AA2
AA2_
_ AA3
AAA
local
local
116,702.00
72,201.35
116,702.00
72,201.35
100,000.00
65,000.00
250,000.00
30,000.00
500,000.00
100,000.00
200,000.00
100,000.00
6.000%
4.800%
102,810.00
65,734.50
255,190.00
28,625.70
338,995.00
101,036.00
203,828.00
102,027.00
122,732.00
101,198.00
250,000.00
semi-annual
semi-annual
12120/11
12/09/14
06/15/19
06/15/24
03/01124
none
05/01/19
08/01113
local
local
local
_local
local
local
262,025.00
29,767.20
159,000.00
111,480.00
198,018.00
103,933.00
262,025.00
5.750%
2.625%
4.800%
4.800%
5.000%
6.750%
semi-annual
12127/17
12/05/12
08/25/09
03/13/12
06/17/10
05/11111
03/19/09
05101127
02/01/25
11/01/27
05/01124
02/01124
02/01/25
11/01/25
2_64438ZL9
969078OM9
29,767.20
semi-annual
maturity
semi-annual
semi-annual
159,000.00
111,480.00
198,018.00
103,933.00
none
none
02/01/11
none
none
420218PU
80465PAN4
508084DW7
AAA
semi-annual
semi-annual
semi-annual
maturity
880591CJ9
AAA
local
121,500.00
121,500.00
100,000.00
598699NT9
AAA_
local
local
_ 106,941.00
250,000.00
106,941.00
100,000.00
_5_.650%
07122/11
02/06/08
none
02101/27
_
Ice Deposit- National Sports Center
none
250,000.00
250,000.00
none
01101/26
_
Fed Home Ln Bank
3130A8W33
AAA
US
39,000.00
39,000.00
40,000.00
2.100%
36,941.20
semi-annual
07/27117
08/22/17
08122/25
Fed Farm Credit Bank
31331VLCB
_
AAA
US
106,030.45
106,030.45
100,000.00
5.250%
115,149.00
semi-annual
02/26/10
none
04/21/28
_
Van Buren Mich Public Schools
-
_
2,016,258.40
920729HD5
AA1
local
102,750.00
102,750.00
100,000.00
6.430%
102,778.00
102,778.00
semi-annual
—
07/17/09
11101/09
05/01/29
--
36,169,146.37
1,864,168.20 local
152,090.20 US
6 -10 Years
102,778.00 local
10* Years
INVESTMENT SCHEDULE - Money Market Funds
July 31, 2018
Description
Current Market
Value
YTD Interest
Wells Fargo
t Wells Fargo Government Money Market Fund
$3,233,614.961
$14,571.24
4M
I 14M
1,012,611.83
8,014.00
4m PLUS"
1 14M Plus
6,994.19
60.15
Premier Bank
I Premier Bank Money Market
1 275,989.891
400.42
Grand Total Money Market Funds 1 $4,529,210.87 1 $23,045.81
Updated: 811312018