HomeMy WebLinkAbout2020 CIP
2020 2024 Capital Improvement Plan
1685 Crosstown Blvd NW, Andover, MN 55304
Phone: 763.755.5100 Fax: 763.755.8923
www.andovermn.gov
This page left blank intentionally.
CITY OF ANDOVER
2020 2024 Capital Improvement Plan
Table of Contents
Introduction
2020 2024 Capital Improvement Plan Message ........................................................................................................ 1
CIP Project Development & Process Authorization Schedule ..................................................................................... 4
Graph 2020 Expenditures By Department ................................................................................................................ 6
Graph 2020 CIP Expenditures By Year .................................................................................................................... 6
Five Year Summary of Expenditures By Department .................................................................................................. 7
Five Year Summary of Revenue By Source ................................................................................................................ 8
Five Year Summary of Projects By Department & Revenue Source ........................................................................... 9
Improvements
Five Year Summary of Expenditures By Department Improvements ....................................................................... 15
Five Year Summary of Revenue By Source Improvements ..................................................................................... 16
Five Year Summary of Projects By Department & Revenue Source Improvements ................................................ 17
Improvement Projects By Department
Community Center ................................................................................................................................................ 21
Emergency Management ...................................................................................................................................... 33
Engineering ........................................................................................................................................................... 36
Facility Management ............................................................................................................................................ 51
Finance .................................................................................................................................................................. 67
Parks & Recreation Operations .......................................................................................................................... 68
Parks & Recreation Projects .............................................................................................................................. 80
Sanitary Sewer ...................................................................................................................................................... 87
Storm Sewer .......................................................................................................................................................... 89
Streets / Highways ................................................................................................................................................ 90
Water..................................................................................................................................................................... 114
Equipment
Year Summary of Expenditures By Department Equipment .................................................................................... 119
Five Year Summary of Revenue By Source Equipment ........................................................................................... 120
Five Year Summary of Projects By Department & Revenue Source Equipment ..................................................... 121
Equipment By Department
Central Equipment ................................................................................................................................................ 124
Community Center ................................................................................................................................................ 125
Engineering ........................................................................................................................................................... 129
Fire Department .................................................................................................................................................... 131
Information Technology ....................................................................................................................................... 139
Parks & Recreation Operations .......................................................................................................................... 141
Sanitary Sewer ...................................................................................................................................................... 148
Storm Sewer .......................................................................................................................................................... 149
Streets / Highways ................................................................................................................................................ 150
Appendix
Road & Bridge Fund Projected Fund Balance ............................................................................................................. 161
Park Improvement Fund Projected Fund Balance ........................................................................................................ 162
Trail Fund Projected Fund Balance .............................................................................................................................. 163
Capital Equipment Reserve Projected Fund Balance ................................................................................................... 164
Building Fund Projected Fund Balance ....................................................................................................................... 165
Water System Financial Projections ............................................................................................................................ 166
Sewer System Financial Projections ............................................................................................................................ 168
Storm Sewer System Financial Projections ................................................................................................................. 170
This page left blank intentionally.
1685 CROSSTOWN BOULEVARD N.W. ANDOVER, MINNESOTA 55304 (763) 755-5100
FAX (763) 755-8923 WWW.CI.ANDOVER.MN.US
TO:Mayor and Council Members
FROM:Jim Dickinson, City Administrator
SUBJECT:20202024Capital Improvement Plan
DATE:October15,2019
INTRODUCTION
Improvement Plan for years 2020through 2024
worked diligently to produce a document that was both practical, substantive in addressing needed capital
y changing
suburban landscape.
CAPITAL IMPROVEMENT PLAN GOALS
A CKNOWLEDGE AND C OMMUNICATE
PUBLIC I NFRASTRUCTURE PRIORITIES AND DYNAMICS
E NSURE A PPROPRIATE R ESPONSES
TO CHANGING INFRASTRUCTURE NEEDS AND DEMANDS
D EVELOP A F INANCIAL A SSESSMENT OF C APITAL R ESOURCES
AVAILABLE TO MEET FUTURE CAPITAL PROJECTPLANNING NEEDS
I NSTITUTE A S TRATEGIC V ISION
PREDICATED ON MAINTAINING A HIGH QUALITYSERVICE INFRASTRUCTURE CAPABLE OF
MEETING THE NEEDS OFOUR CITIZENS FOR TODAY AND TOMORROW
needs through careful long-term capital planning and balanced public investment in supporting physical
infrastructure. To ensure that this commitment is both meaningful and achievable, appropriate capital
improvement factors were given significant consideration in developing a CIP that addresses community
priorities over the next five (5) years. The CIP will also provide a planning foundation for future needs
assessments to ensure the City is appropriately responding to the critical infrastructure needs necessary for
sustainable future growth. The CIP represents a beginning in terms of producing a comprehensive planning
response to address changing capital needs by developing a project schedule that will lead to timely and
cost-effective project completions.
1
DISCUSSION
The 2020-2024CIP has been prepared as a strategic planning tool to assist the City Council in identifying
proposed capital improvement projects over the next five years. With the inclusion of preliminary financing
sources, appropriate background information citing needs and projected cost estimates, this document will
provide Council with the needed information to begin the process for planning improvements that meet the
identify the critical components of the City's infrastructure, yet maintain flexibility in determining project
timeframes, project scope and possible funding sources. The 2020-2024CIP continues the emphasis of
future capital expenditures.
A critical step in the plan adoption process is the collaborative nature of plan review that involves the
leadership of the City Council, the input of appointed Commissions and staff, and most importantly,
affected residents of the community. Consequently, the strategic value of this plan lies in the
acknowledgement of future needs by the governing body and the effective communication of those needs
to the general public during project development stages. Likewise, the availability and preliminary
designation of fiscal resources to serve both current and future needs is critical to the achievement of plan
outcomes that meet with Council approval. Following the approval of the plan, feasibility studies are
performed, affected constituenciesare notified to formally disseminate and receive public feedback on
proposed project plans. This process culminates with the City Council considering all relevant information
and making a final decision on whether to proceed with the proposed capital improvement.
The public process that supports the advancement of these projects from inception to completion is
engendered in the CIP project development and authorization schedule. Formalizing the steps in the CIP
project advancement process serves a number of purposes and ensures that the Council and public are kept
well informed regarding project purposes and desired outcomes, estimated project costs, funding sources,
progress and final status. It should be emphasized that projects will require approval in various stages of
project development by the City Council in accordance with approved policies.
The objectives of the 2020-2024Capital Improvement Plan are to present a comprehensive capital
improvement program that communicates efforts:
to ensure that community priorities are reflected in the capital investment plans of
each City department;
to provide a consolidated financial picture of anticipated expenditures and outline
recommended funding strategies to underwrite anticipated capital improvements;
to document and communicate capital improvement processes for City projects
that will ensure consistency, a full appreciation of both the costs and benefits of
proposed capital investments, and raises the level of public understanding
to provide information on the fiscal impacts of capital investment plans on total
City finances; and
to effectively plan for public improvements that support community needs in the
areas of private development infrastructure, transportation, public safety, parks
and recreation, utilities, and commercial/industrial growth through fiscally
responsible economic development initiatives.
Accordingly, this document attempts to recognize known or perceived capital improvement needs, but as
with any plan recognizes that social, economic and political considerations will by necessity determine final
project outcomes. The major categories of expenditures that are identified within the CIP include, but are
not limited to:
2
1.New Public Facilities Planning
2.Street Construction, Maintenance and Reconstruction
3.Utility Construction, Maintenance and Reconstruction
4.Construction, Maintenance and Upgrade of Parks, Playgrounds and Trails
5.Capital Improvements to Existing Facilities
6.Private development infrastructure
7.Capital equipment and vehicle planning needs (Equipment purchases to be determined through
normal budgetary process)
The City Council, consequently, accepts this document with the provision that capital improvement
planning is subject to the dynamics of community growth, political leadership and acknowledges that other
unanticipated needs may take precedence over plannedprojects.
RECOMMENDATION
The 2020-2024Capital Improvement Plan is the product of collaborative planning efforts by City staff,
Park and Recreation Commission, Community Center Advisory Commissionand the City Council. Projects
have been introduced bacurrent
Comprehensive Plan, 2) the natural cycle of deterioration and decay evident in all physically constructed
and engineered improvements in the more established areas of the community and 3) capital deficiencies
or infrastructure issues brought to the City's attention through a variety of sources.
Capital expenditures identified within the CIP are the best estimates available, and once the CIP is adopted,
will be reviewed and confirmed through individual feasibility reports where appropriate. I am appreciative
of the commitment, good judgment and expertise that each department has contributed to the capital
improvement planning process.
Respectfully submitted,
Jim Dickinson
City Administrator
3
CIP PROJECT DEVELOPMENT AND
PROCESS AUTHORIZATION SCHEDULE
The following process is a Council/staff guideline for authorizing public improvement projects. As this process is
controlled by State Statute and other influencing environmental factors, it is subject to change and should be
viewed as a guide to assist the Council and public in understanding the public improvement process used by City
staff. A separate Council meeting would facilitate each step in the process, and accomplishment of respective
activities.As a result, the process time frame is a significant
and complete approved Council ordered projects within budget and on time.
1.Council Approval of Annual CIP Projects by City Resolution will authorize the following outcomes:
a)Staff and/or Consultant preparation of project feasibility studies
b)Staff preparation of detailed financial review of project funding sources
c)Neighborhood Meeting may be held prior to Feasibility Study subject to need and type of project.
TIME FRAME: October-November of each preceding year.
2.Presentation of Feasibility Study
a)Feasibility Study Components:
1)Review of Project Engineering and Construction Estimates
2)Total Project Costs (All related project costs, i.e. land, soft costs)
3)Project Financial Plan/Fiscal Implications (Engineering/Finance)
4)Authorization to develop a Preliminary Assessment Roll, if any, for the Public Hearing. (Engineering)
d Setting Date for
1)Notices mailed to affected Residents per statute requirements no less than 10 days before Public
Hearing. (Engineering)
2)Public Hearing Notice is published. Two publications one week apart, with the second publication no
less than three days before the hearing. (Engineering/City Clerk)
TIME FRAME: February-March-April-May of current year.
3.Neighborhood Meeting City staffwill hold neighborhood project meetings, when appropriate, to review and
present Project Feasibility Studies, answer questions and meet with affected property owners. These meetings
will include a question and answer component designed specifically to bring awareness to the property owner,
public improvements in the affected area.
TIME FRAME: Following the presentation of the Feasibility Study to Council, but prior to the holding of a
Public Hearing by Council.
4.Council holds a Public Hearing when appropriate for following purposes:
a)Presentation of Project (Engineering Department)
b)Presentation of Preliminary Special Assessment Rolls and Financing Implications (Engineering/Finance
Department)
c)Council to hear Affected Resident Input
d)
4
Council may ORDER THE IMPROVEMENT after the public
hearing is closed or at a subsequent Council Meeting within 6 monthsof the public hearing date.
(Statutory Requirement -Council Resolution ordering project must be approved on 4/5 Council vote if it
is Council initiated project with assessments).
If Council decides to reject the project as presented, a Council vote should be taken to officially determine
the final status of the project.
TIME FRAME: April-May-June of current year
5.Plans and Specifications are presented to Council for approval. (Engineering Department)
a)A Council Resolution is drafted authorizing the following:
1)Accepting and Approving Project Plans and Specifications
2)Authorizing the Advertisement for Project Bids. Bids are developed and invitation to Bid is processed.
Bid opening date is no less than 3 weeks after publication. (Engineering)
3)Authorize staff to pursue an appropriate funding mechanism to underwrite project costs
TIME FRAME: May-June of each year
6.Council Acceptance of Project Bids and Awarding of Contracts would authorize the following outcomes:
a)A Counci
b)Initiation of Project Construction and work (Engineering)
TIME FRAME: April-May-June-July of current year.
7.Project Completion
a)Council Acceptance of Project
b)Final Presentation and Review of Project Costs versus Project Budget by Finance Department.
c)
d at this same meeting. (Engineering/Finance)
TIME FRAME: Upon completion of project.
8.If Special Assessments would finance a portion of the projects costs, Council Holds a Special Assessment
Hearing to review the following:
a)Affected Property owners would be officially notified per statute no less than two weeks prior to Special
Assessment Hearing. (Clerk/Engineering)
b)Public Notice is published no less than two weeks prior to Special Hearing per statute (Clerk/Engineering)
c)Staff prepares a proposed roll and Council Approves Final Assessment Roll (Engineering/Finance)
d)Council consideration of Assessment Appeals and Requested Deferrals filed prior to hearing or during
the hearing.
e)Meets M.S. Chapter 429 statutory requirements
at this meeting.
TIME FRAME: October/November of current year depending on finalization of project and status of
completion.
5
6
Capital Plan
Central Equipment45,00045,000
Community Center553,112172,00046,0001,330,000
2,101,112
Emergency Management65,00050,00040,00040,00040,000
235,000
Engineering774,000586,0001,738,000765,0001,206,000
5,069,000
Facility Management457,000195,000275,000440,00074,000
1,441,000
Finance225,000225,000
Fire644,000225,000646,00071,00072,0001,658,000
Information Technology22,00022,000
Park & Rec - Operations405,000188,000305,000135,000135,000
1,168,000
Park & Rec - Projects195,000185,00015,000125,00015,000
535,000
Sanitary Sewer90,0003,500,000
3,590,000
Storm Sewer62,00065,000318,00070,00070,000585,000
Streets / Highways3,617,0003,987,0006,032,0005,833,0004,074,00023,543,000
Water150,0002,790,00055,0002,995,000
7,034,1128,713,0009,415,0008,864,0009,186,00043,212,112
7
Capital Plan
Assessments654,500671,000911,500590,5001,999,5004,827,000
Capital Equipment Reserve337,634374,00086,000226,00086,000
1,109,634
Comm Ctr Operations157,000172,00046,0001,330,0001,705,000
Construction Seal Coat Fund10,00010,00010,00010,00010,000
50,000
Donations90,00090,000
Equipment Bond1,264,000570,0001,375,000440,000252,0003,901,000
Facility Maintenance Reserve681,478189,000275,000410,00074,000
1,629,478
G.O. Bond750,000750,000
General Fund155,000485,000160,000210,000221,000
1,231,000
Grant193,550900,0001,093,550
Municipal State Aid Funds555,000285,000792,5002,112,500526,5004,271,500
Park Dedication Funds204,000185,00015,00015,00015,000
434,000
Road & Bridge Funds2,195,5002,757,0003,689,0002,046,0002,807,00013,494,500
Sewer Revenue Bonds2,250,000
2,250,000
Sewer Trunk Fund125,000125,000125,000130,000135,000640,000
Storm Sewer Fund62,00065,00068,00070,00070,000
335,000
Trail Funds124,4501,052,000259,000675,0002,110,450
Water Fund25,0001,330,00055,0001,410,000
Water Trunk Fund200,0001,495,00060,00060,00065,000
1,880,000
7,034,1128,713,0009,415,0008,864,0009,186,000
43,212,112
8
Capital Plan
Replacement - Service Truck #371221-48800-0145,000
45,000
Capital Equipment Reserve45,00045,000
45,00045,000
Replacement- Sinks/Fixtures120-44000-0115,00015,000
Comm Ctr Operations15,00015,000
Refacing Rink Boards120-44300-0130,00030,000
Comm Ctr Operations30,00030,000
Refrigeration Equipment Conversion120-44300-02323,478
323,478
Comm Ctr Operations50,00050,000
Facility Maintenance Reserve273,478273,478
Fieldhouse Floor Repair120-44400-01184,634184,634
Capital Equipment Reserve134,634134,634
Comm Ctr Operations50,00050,000
Replacement - Floor Scrubber121-44000-0115,00015,000
Comm Ctr Operations15,00015,000
Remodel Old Proshop Area121-44000-0220,00020,000
Comm Ctr Operations20,00020,000
Replacement - Kaivac Cleaning System121-44000-036,000
6,000
Comm Ctr Operations6,0006,000
Exterior Caulking121-44000-0450,00050,000
Comm Ctr Operations50,00050,000
Replacement - Lobby Furniture121-44000-0525,00025,000
Comm Ctr Operations25,00025,000
Repaint Field House Ceiling121-44200-0150,000
50,000
Comm Ctr Operations50,00050,000
Refinish wooden benches121-44300-016,0006,000
Comm Ctr Operations6,0006,000
Concrete Floor Sealant122-44000-0136,000
36,000
Comm Ctr Operations36,00036,000
Replacement - Electric Edger122-44300-0210,000
10,000
Comm Ctr Operations10,00010,000
Carpet - Office/Fieldhouse Foyer123-44000-0115,00015,000
Comm Ctr Operations15,00015,000
Replacement - Roof123-44000-021,300,0001,300,000
Comm Ctr Operations1,300,0001,300,000
Replacement - Zamboni Battery Pack123-44300-0115,000
15,000
Comm Ctr Operations15,00015,000
553,112172,00046,0001,330,0002,101,112
9
Emergency Operations Center Improvement120-42400-0110,00010,00020,000
Capital Equipment Reserve10,00010,00020,000
New - Emergency Siren Additions120-42400-0255,000
55,000
Capital Equipment Reserve55,00055,000
Replacement - Emergency Sirens121-42400-0140,00040,00040,00040,000
160,000
Capital Equipment Reserve40,00040,00040,00040,000160,000
65,00050,00040,00040,00040,000235,000
New Development Projects120-41600-01175,000180,000185,000190,000200,000
930,000
Sewer Trunk Fund125,000125,000125,000130,000135,000640,000
Water Trunk Fund50,00055,00060,00060,00065,000290,000
Pedestrian Trail Maintenance120-41600-0263,00066,00069,00072,00075,000
345,000
Road & Bridge Funds63,00066,00069,00072,00075,000345,000
Pedestrian/Park Trail Reconstruction120-41600-0370,000320,000370,000220,000230,000
1,210,000
Capital Equipment Reserve70,00070,000
General Fund320,00050,00060,000430,000
Road & Bridge Funds370,000170,000170,000710,000
Pedestrian Curb Ramp Replacements120-41600-0419,00020,00022,00024,00026,000
111,000
Road & Bridge Funds19,00020,00022,00024,00026,000111,000
Replacement - 3/4 Ton Truck #12220-41600-0530,00030,000
Equipment Bond30,00030,000
New Pedestrian Trail and Sidewalk Segments120-41600-06405,000722,000259,000675,000
2,061,000
Grant193,550193,550
Park Dedication Funds99,00099,000
Trail Funds112,450722,000259,000675,0001,768,450
Railroad Underpass Trail120-41600-0712,000330,000
342,000
Trail Funds12,000330,000342,000
Replacement - Pick Up Truck #6222-41600-0140,000
40,000
Equipment Bond40,00040,000
774,000586,0001,738,000765,0001,206,0005,069,000
Annual Parking Lot Maintenance/Replacement120-41900-01250,00039,000230,000150,00044,000713,000
Facility Maintenance Reserve250,00039,000230,000150,00044,000713,000
Surface Seal all Brick Structures120-41900-0285,00085,000
Comm Ctr Operations12,00012,000
Facility Maintenance Reserve48,00048,000
Water Fund25,00025,000
Replacement - Furnace/Condenser PW220-41900-036,0006,000
General Fund6,0006,000
Replacement - Furnace/Condenser Coil PW220-41900-046,000
6,000
General Fund6,0006,000
Fencing Around Public Yard120-41900-06110,000110,000
Facility Maintenance Reserve110,000110,000
Replacement - Tube Heaters PW121-41900-0180,00080,000
Facility Maintenance Reserve80,00080,000
Replacement - Air Handling Unit/Condenser FS #1121-41900-026,000
6,000
General Fund6,0006,000
Replacement - Tube Heaters FS #1121-41900-0325,00025,000
Facility Maintenance Reserve25,00025,000
New - Diesel Exhaust Capturing System FS #1121-41900-0445,000
45,000
Facility Maintenance Reserve45,00045,000
10
Replacement - Roof Top Package Unit PW222-41900-0145,00045,000
Facility Maintenance Reserve45,00045,000
Replacement - Emergency Generator FS #1123-41900-0150,000
50,000
Facility Maintenance Reserve50,00050,000
Replacement - Emergency Generator FS #2123-41900-0235,000
35,000
Facility Maintenance Reserve35,00035,000
Replacement - Emergency Generator FS #3123-41900-0350,00050,000
Facility Maintenance Reserve50,00050,000
Replacement - Make Up Air Unit /Exhaust Fan PW23-41900-041125,000125,000
Facility Maintenance Reserve125,000125,000
Building A - Seal Floor123-41900-0530,000
30,000
Capital Equipment Reserve30,00030,000
Replacement - Carpet / Tile124-41900-0130,00030,000
Facility Maintenance Reserve30,00030,000
1,441,000
457,000195,000275,000440,00074,000
Financial / Payroll System Upgrade / Replacement121-41400-01225,000225,000
Capital Equipment Reserve225,000225,000
225,000225,000
Replacement - Turnout Gear120-42200-0123,00024,00025,00025,00026,000
123,000
General Fund23,00024,00025,00025,00026,000123,000
Replacement - Engine 21 #4884120-42200-02510,000
510,000
Equipment Bond510,000510,000
Replacement - (2) SCBA Compressors St 2 & 3120-42200-0365,00065,000130,000
Equipment Bond65,00065,000130,000
Replacement - 800 MHz radios220-42200-0446,00046,00046,00046,00046,000
230,000
Capital Equipment Reserve46,00046,00046,00046,00046,000230,000
Replacement - Grass Utility Vehicle (UTV) #4813121-42200-0145,000
45,000
Equipment Bond45,00045,000
Replacement - Thermal Imaging Cameras121-42200-0245,00045,000
Equipment Bond45,00045,000
Replacement - Engine 31 #4800122-42200-01475,000
475,000
Equipment Bond475,000475,000
Replacement - Rescue 31 #4818122-42200-02100,000
100,000
Equipment Bond100,000100,000
644,000225,000646,00071,00072,0001,658,000
Windows Server 2019 DataCenter Licenses220-41420-0112,000
12,000
Capital Equipment Reserve12,00012,000
Aruba Switch Upgrade120-41420-0210,00010,000
Capital Equipment Reserve10,00010,000
22,00022,000
Replace/Repair Play Structures - Various Parks120-45000-01100,000100,000100,000100,000100,000
500,000
General Fund100,000100,000100,000100,000100,000500,000
Replace/Repair Major Park Projects - Various Parks120-45000-0220,00035,00035,00035,00035,000
160,000
11
General Fund20,00035,00035,00035,00035,000160,000
Replacement - Water Tanker #161120-45000-03175,000175,000
Equipment Bond175,000175,000
New - Large Capacity Mower120-45000-04110,000
110,000
Equipment Bond110,000110,000
Replacement - Cushman Field Dresser #547121-45000-0127,000
27,000
Equipment Bond27,00027,000
Replacement - Trailer #T-555121-45000-0218,00018,000
Equipment Bond18,00018,000
New - Turbine Tow-Behind Blower121-45000-038,000
8,000
Capital Equipment Reserve8,0008,000
Replacement - Large Capacity Mower #585122-45000-01120,000
120,000
Equipment Bond120,000120,000
Replacement - Tractor #515122-45000-0250,00050,000
Equipment Bond50,00050,000
1,168,000
405,000188,000305,000135,000135,000
Annual Miscellaneous Park Projects120-45001-0115,00015,00015,00015,00015,00075,000
Park Dedication Funds15,00015,00015,00015,00015,00075,000
Andover Station North East Ball Field Lighting120-45001-02180,000
180,000
Donations90,00090,000
Park Dedication Funds90,00090,000
Prairie Knoll North Parking Lot Impr120-45001-03170,000170,000
Park Dedication Funds170,000170,000
Dalske Preserve Boardwalk23-45001-011110,000
110,000
Capital Equipment Reserve110,000110,000
195,000185,00015,000125,00015,000535,000
Lift Station Improvements120-48200-0190,000
90,000
Assessments90,00090,000
Rural Reserve Trunk Sanitary Sewer125-48200-013,500,0003,500,000
Assessments1,250,0001,250,000
Sewer Revenue Bonds2,250,0002,250,000
3,590,000
90,0003,500,000
Storm Sewer Improvements120-48300-0162,00065,00068,00070,00070,000
335,000
Storm Sewer Fund62,00065,00068,00070,00070,000335,000
Replacement - Elgin Street Sweeper #169122-48300-01250,000250,000
Equipment Bond250,000250,000
62,00065,000318,00070,00070,000585,000
Annual Street Seal Coat Project120-43100-01200,000210,000220,000230,000240,0001,100,000
Road & Bridge Funds200,000210,000220,000230,000240,0001,100,000
Annual Street Crack Seal Project120-43100-02170,000180,000190,000200,000210,000950,000
Construction Seal Coat Fund10,00010,00010,00010,00010,00050,000
Road & Bridge Funds160,000170,000180,000190,000200,000900,000
Annual Pavement Markings120-43100-0360,00062,00065,00068,00072,000327,000
Road & Bridge Funds60,00062,00065,00068,00072,000327,000
12
Annual Curb Replacement120-43100-0456,00058,00060,00062,00065,000301,000
Road & Bridge Funds56,00058,00060,00062,00065,000301,000
Municipal State Aid Routes / New & Reconstruct120-43100-05580,000510,0001,400,000630,000
3,120,000
Assessments25,00017,500187,500103,500333,500
Municipal State Aid Funds555,000492,5001,212,500526,5002,786,500
Annual Street Reconstruction120-43100-061,226,0001,401,0002,575,000610,0001,581,0007,393,000
Assessments307,000351,000644,000153,000396,0001,851,000
Road & Bridge Funds919,0001,050,0001,931,000457,0001,185,0005,542,000
Intersection Upgrades120-43100-07285,000300,0001,800,000
2,385,000
Grant900,000900,000
Municipal State Aid Funds285,000300,000900,0001,485,000
Gravel Road Improvements120-43100-0821,00021,00022,00023,00024,000111,000
Road & Bridge Funds21,00021,00022,00023,00024,000111,000
Replacement - Front End Loader #124120-43100-09275,000
275,000
Equipment Bond275,000275,000
Replacement - One Ton Truck w/ Plow #133120-43100-1080,00080,000
Equipment Bond80,00080,000
Street Overlays120-43100-11920,0001,200,0001,000,0001,000,0001,000,000
5,120,000
Assessments232,500300,000250,000250,000250,0001,282,500
Road & Bridge Funds687,500900,000750,000750,000750,0003,837,500
New - Slide-In Hotbox120-43100-1219,00019,000
Equipment Bond19,00019,000
Pedestrian Crossing220-43100-1310,000200,000210,000
Road & Bridge Funds10,000200,000210,000
New - Dump Truck w/ Snow removal121-43100-01240,000
240,000
Equipment Bond240,000240,000
New - One Ton Truck w/ Snow removal121-43100-0270,00070,000
Equipment Bond70,00070,000
Replacement - Bobcat S185 #120121-43100-0360,000
60,000
Equipment Bond60,00060,000
New - Dump truck w/ Snow removal122-43100-01240,000240,000
Equipment Bond240,000240,000
Replacement - Backhoe Loader #80122-43100-02100,000100,000
Equipment Bond100,000100,000
Pedestrian Tunnel Under Crosstown Blvd.122-43100-03750,000
750,000
G.O. Bond750,000750,000
Replacement - Dump Truck w/ Snow removal #20023-43100-011240,000
240,000
Equipment Bond240,000240,000
Replacement - Aerial bucket truck #00-13923-43100-021200,000200,000
Equipment Bond200,000200,000
Replacement - Dump Truck w/ Snow removal #201124-43100-01252,000
252,000
Equipment Bond252,000252,000
3,617,0003,987,0006,032,0005,833,0004,074,00023,543,000
Recondition & Paint Water Tower #2120-48100-01150,0001,000,000
1,150,000
Water Trunk Fund150,0001,000,0001,150,000
Rehabilitation of Wells121-48100-0130,00055,00085,000
Water Fund30,00055,00085,000
Water Main Improvements121-48100-02460,000460,000
Assessments20,00020,000
Water Trunk Fund440,000440,000
Water Meter Reading System AMI/AMR221-48100-031,300,0001,300,000
Water Fund1,300,0001,300,000
13
150,0002,790,00055,0002,995,000
7,034,1128,713,0009,415,0008,864,0009,186,00043,212,112
14
Capital Plan
Community Center553,112151,00036,0001,315,0002,055,112
Emergency Management65,00050,00040,00040,00040,000
235,000
Engineering744,000586,0001,698,000765,0001,206,000
4,999,000
Facility Management457,000195,000275,000440,00074,000
1,441,000
Finance225,000
225,000
Park & Rec - Operations120,000135,000135,000135,000135,000660,000
Park & Rec - Projects195,000185,00015,000125,00015,000535,000
Sanitary Sewer3,500,0003,500,000
Storm Sewer62,00065,00068,00070,00070,000
335,000
Streets / Highways3,243,0003,617,0005,692,0005,393,0003,822,000
21,767,000
Water150,0002,790,00055,000
2,995,000
5,589,1127,999,0007,959,0008,338,0008,862,000
38,747,112
15
Capital Plan
Assessments564,500671,000911,500590,5001,999,5004,737,000
Capital Equipment Reserve269,634275,00040,000180,00040,000
804,634
Comm Ctr Operations157,000151,00036,0001,315,0001,659,000
Construction Seal Coat Fund10,00010,00010,00010,00010,000
50,000
Donations90,00090,000
Facility Maintenance Reserve681,478189,000275,000410,00074,0001,629,478
G.O. Bond750,000
750,000
General Fund132,000461,000135,000185,000195,0001,108,000
Grant193,550900,000
1,093,550
Municipal State Aid Funds555,000285,000792,5002,112,500526,5004,271,500
Park Dedication Funds204,000185,00015,00015,00015,000434,000
Road & Bridge Funds2,195,5002,757,0003,689,0002,046,0002,807,000
13,494,500
Sewer Revenue Bonds2,250,0002,250,000
Sewer Trunk Fund125,000125,000125,000130,000135,000
640,000
Storm Sewer Fund62,00065,00068,00070,00070,000335,000
Trail Funds124,4501,052,000259,000675,000
2,110,450
Water Fund25,0001,330,00055,0001,410,000
Water Trunk Fund200,0001,495,00060,00060,00065,0001,880,000
5,589,1127,999,0007,959,0008,338,0008,862,00038,747,112
16
Capital Plan
Replacement- Sinks/Fixtures120-44000-0115,000
15,000
Comm Ctr Operations15,00015,000
Refacing Rink Boards120-44300-0130,00030,000
Comm Ctr Operations30,00030,000
Refrigeration Equipment Conversion120-44300-02323,478323,478
Comm Ctr Operations50,00050,000
Facility Maintenance Reserve273,478273,478
Fieldhouse Floor Repair120-44400-01184,634184,634
Capital Equipment Reserve134,634134,634
Comm Ctr Operations50,00050,000
Remodel Old Proshop Area121-44000-0220,000
20,000
Comm Ctr Operations20,00020,000
Exterior Caulking121-44000-0450,00050,000
Comm Ctr Operations50,00050,000
Replacement - Lobby Furniture121-44000-0525,000
25,000
Comm Ctr Operations25,00025,000
Repaint Field House Ceiling121-44200-0150,00050,000
Comm Ctr Operations50,00050,000
Refinish wooden benches121-44300-016,0006,000
Comm Ctr Operations6,0006,000
Concrete Floor Sealant122-44000-0136,000
36,000
Comm Ctr Operations36,00036,000
Carpet - Office/Fieldhouse Foyer123-44000-0115,000
15,000
Comm Ctr Operations15,00015,000
Replacement - Roof123-44000-021,300,0001,300,000
Comm Ctr Operations1,300,0001,300,000
553,112151,00036,0001,315,0002,055,112
Emergency Operations Center Improvement120-42400-0110,00010,000
20,000
Capital Equipment Reserve10,00010,00020,000
New - Emergency Siren Additions120-42400-0255,000
55,000
Capital Equipment Reserve55,00055,000
Replacement - Emergency Sirens121-42400-0140,00040,00040,00040,000160,000
Capital Equipment Reserve40,00040,00040,00040,000160,000
65,00050,00040,00040,00040,000235,000
New Development Projects120-41600-01175,000180,000185,000190,000200,000930,000
Sewer Trunk Fund125,000125,000125,000130,000135,000640,000
Water Trunk Fund50,00055,00060,00060,00065,000290,000
Pedestrian Trail Maintenance120-41600-0263,00066,00069,00072,00075,000
345,000
17
Road & Bridge Funds63,00066,00069,00072,00075,000345,000
Pedestrian/Park Trail Reconstruction120-41600-0370,000320,000370,000220,000230,0001,210,000
Capital Equipment Reserve70,00070,000
General Fund320,00050,00060,000430,000
Road & Bridge Funds370,000170,000170,000710,000
Pedestrian Curb Ramp Replacements120-41600-0419,00020,00022,00024,00026,000111,000
Road & Bridge Funds19,00020,00022,00024,00026,000111,000
New Pedestrian Trail and Sidewalk Segments120-41600-06405,000722,000259,000675,000
2,061,000
Grant193,550193,550
Park Dedication Funds99,00099,000
Trail Funds112,450722,000259,000675,0001,768,450
Railroad Underpass Trail120-41600-0712,000330,000342,000
Trail Funds12,000330,000342,000
744,000586,0001,698,000765,0001,206,0004,999,000
Annual Parking Lot Maintenance/Replacement120-41900-01250,00039,000230,000150,00044,000
713,000
Facility Maintenance Reserve250,00039,000230,000150,00044,000713,000
Surface Seal all Brick Structures120-41900-0285,000
85,000
Comm Ctr Operations12,00012,000
Facility Maintenance Reserve48,00048,000
Water Fund25,00025,000
Replacement - Furnace/Condenser PW220-41900-036,000
6,000
General Fund6,0006,000
Replacement - Furnace/Condenser Coil PW220-41900-046,0006,000
General Fund6,0006,000
Fencing Around Public Yard120-41900-06110,000
110,000
Facility Maintenance Reserve110,000110,000
Replacement - Tube Heaters PW121-41900-0180,000
80,000
Facility Maintenance Reserve80,00080,000
Replacement - Air Handling Unit/Condenser FS #1121-41900-026,0006,000
General Fund6,0006,000
Replacement - Tube Heaters FS #1121-41900-0325,000
25,000
Facility Maintenance Reserve25,00025,000
New - Diesel Exhaust Capturing System FS #1121-41900-0445,00045,000
Facility Maintenance Reserve45,00045,000
Replacement - Roof Top Package Unit PW222-41900-0145,00045,000
Facility Maintenance Reserve45,00045,000
Replacement - Emergency Generator FS #1123-41900-0150,000
50,000
Facility Maintenance Reserve50,00050,000
Replacement - Emergency Generator FS #2123-41900-0235,000
35,000
Facility Maintenance Reserve35,00035,000
Replacement - Emergency Generator FS #3123-41900-0350,00050,000
Facility Maintenance Reserve50,00050,000
Replacement - Make Up Air Unit /Exhaust Fan PW23-41900-041125,000
125,000
Facility Maintenance Reserve125,000125,000
Building A - Seal Floor123-41900-0530,00030,000
Capital Equipment Reserve30,00030,000
Replacement - Carpet / Tile124-41900-0130,000
30,000
Facility Maintenance Reserve30,00030,000
1,441,000
457,000195,000275,000440,00074,000
18
Financial / Payroll System Upgrade / Replacement121-41400-01225,000225,000
Capital Equipment Reserve225,000225,000
225,000225,000
Replace/Repair Play Structures - Various Parks120-45000-01100,000100,000100,000100,000100,000500,000
General Fund100,000100,000100,000100,000100,000500,000
Replace/Repair Major Park Projects - Various Parks120-45000-0220,00035,00035,00035,00035,000
160,000
General Fund20,00035,00035,00035,00035,000160,000
660,000
120,000135,000135,000135,000135,000
Annual Miscellaneous Park Projects120-45001-0115,00015,00015,00015,00015,000
75,000
Park Dedication Funds15,00015,00015,00015,00015,00075,000
Andover Station North East Ball Field Lighting120-45001-02180,000180,000
Donations90,00090,000
Park Dedication Funds90,00090,000
Prairie Knoll North Parking Lot Impr120-45001-03170,000
170,000
Park Dedication Funds170,000170,000
Dalske Preserve Boardwalk23-45001-011110,000110,000
Capital Equipment Reserve110,000110,000
195,000185,00015,000125,00015,000535,000
Rural Reserve Trunk Sanitary Sewer125-48200-013,500,0003,500,000
Assessments1,250,0001,250,000
Sewer Revenue Bonds2,250,0002,250,000
3,500,000
3,500,000
Storm Sewer Improvements120-48300-0162,00065,00068,00070,00070,000
335,000
Storm Sewer Fund62,00065,00068,00070,00070,000335,000
335,000
62,00065,00068,00070,00070,000
Annual Street Seal Coat Project120-43100-01200,000210,000220,000230,000240,000
1,100,000
Road & Bridge Funds200,000210,000220,000230,000240,0001,100,000
Annual Street Crack Seal Project120-43100-02170,000180,000190,000200,000210,000950,000
Construction Seal Coat Fund10,00010,00010,00010,00010,00050,000
Road & Bridge Funds160,000170,000180,000190,000200,000900,000
Annual Pavement Markings120-43100-0360,00062,00065,00068,00072,000
327,000
Road & Bridge Funds60,00062,00065,00068,00072,000327,000
Annual Curb Replacement120-43100-0456,00058,00060,00062,00065,000301,000
Road & Bridge Funds56,00058,00060,00062,00065,000301,000
Municipal State Aid Routes / New & Reconstruct120-43100-05580,000510,0001,400,000630,000
3,120,000
Assessments25,00017,500187,500103,500333,500
Municipal State Aid Funds555,000492,5001,212,500526,5002,786,500
Annual Street Reconstruction120-43100-061,226,0001,401,0002,575,000610,0001,581,0007,393,000
Assessments307,000351,000644,000153,000396,0001,851,000
Road & Bridge Funds919,0001,050,0001,931,000457,0001,185,0005,542,000
Intersection Upgrades120-43100-07285,000300,0001,800,000
2,385,000
19
Grant900,000900,000
Municipal State Aid Funds285,000300,000900,0001,485,000
Gravel Road Improvements120-43100-0821,00021,00022,00023,00024,000
111,000
Road & Bridge Funds21,00021,00022,00023,00024,000111,000
Street Overlays120-43100-11920,0001,200,0001,000,0001,000,0001,000,000
5,120,000
Assessments232,500300,000250,000250,000250,0001,282,500
Road & Bridge Funds687,500900,000750,000750,000750,0003,837,500
Pedestrian Crossing220-43100-1310,000200,000
210,000
Road & Bridge Funds10,000200,000210,000
Pedestrian Tunnel Under Crosstown Blvd.122-43100-03750,000
750,000
G.O. Bond750,000750,000
3,243,0003,617,0005,692,0005,393,0003,822,00021,767,000
Recondition & Paint Water Tower #2120-48100-01150,0001,000,000
1,150,000
Water Trunk Fund150,0001,000,0001,150,000
Rehabilitation of Wells121-48100-0130,00055,00085,000
Water Fund30,00055,00085,000
Water Main Improvements121-48100-02460,000
460,000
Assessments20,00020,000
Water Trunk Fund440,000440,000
Water Meter Reading System AMI/AMR221-48100-031,300,0001,300,000
Water Fund1,300,0001,300,000
150,0002,790,00055,0002,995,000
5,589,1127,999,0007,959,0008,338,0008,862,00038,747,112
20
thru
15,00015,000
15,00015,000
15,00015,000
15,00015,000
21
thru
30,00030,000
30,00030,000
30,00030,000
30,00030,000
22
thru
323,478323,478
323,478323,478
50,00050,000
273,478273,478
323,478323,478
23
thru
184,634184,634
184,634184,634
134,634134,634
50,00050,000
184,634184,634
24
thru
20,00020,000
20,00020,000
20,00020,000
20,00020,000
25
thru
50,00050,000
50,00050,000
50,00050,000
50,00050,000
26
thru
25,00025,000
25,00025,000
25,00025,000
25,00025,000
27
thru
50,00050,000
50,00050,000
50,00050,000
50,00050,000
28
thru
6,0006,000
6,0006,000
6,0006,000
6,0006,000
29
thru
36,00036,000
36,00036,000
36,00036,000
36,00036,000
30
thru
15,00015,000
15,00015,000
15,00015,000
15,00015,000
31
thru
1,300,0001,300,000
1,300,0001,300,000
1,300,0001,300,000
1,300,0001,300,000
32
thru
10,00010,00020,000
10,00010,00020,000
10,00010,00020,000
10,00010,00020,000
33
thru
55,00055,000
55,00055,000
55,00055,000
55,00055,000
34
thru
40,00040,00040,00040,000160,000
40,00040,00040,00040,000160,000
40,00040,00040,00040,000160,000
40,00040,00040,00040,000160,000
35
thru
175,000180,000185,000190,000200,000930,000
175,000180,000185,000190,000200,000930,000
125,000125,000125,000130,000135,000640,000
50,00055,00060,00060,00065,000290,000
175,000180,000185,000190,000200,000930,000
36
thru
63,00066,00069,00072,00075,000345,000
63,00066,00069,00072,00075,000345,000
63,00066,00069,00072,00075,000345,000
63,00066,00069,00072,00075,000345,000
37
thru
70,000320,000370,000220,000230,0001,210,000
70,000320,000370,000220,000230,0001,210,000
70,00070,000
320,00050,00060,000430,000
370,000170,000170,000710,000
70,000320,000370,000220,000230,0001,210,000
38
Capital Improvement Plan
39
Capital Improvement Plan
40
Capital Improvement Plan
41
thru
19,00020,00022,00024,00026,000111,000
19,00020,00022,00024,00026,000111,000
19,00020,00022,00024,00026,000111,000
19,00020,00022,00024,00026,000111,000
42
thru
405,000722,000259,000675,0002,061,000
405,000722,000259,000675,0002,061,000
193,550193,550
99,00099,000
112,450722,000259,000675,0001,768,450
405,000722,000259,000675,0002,061,000
43
Capital Improvement Plan
44
Capital Improvement Plan
45
Capital Improvement Plan
46
Capital Improvement Plan
47
Capital Improvement Plan
48
thru
12,00012,000
330,000330,000
12,000330,000342,000
12,000330,000342,000
12,000330,000342,000
49
Capital Improvement Plan
50
thru
250,00039,000230,000150,00044,000713,000
250,00039,000230,000150,00044,000713,000
250,00039,000230,000150,00044,000713,000
250,00039,000230,000150,00044,000713,000
51
thru
85,00085,000
85,00085,000
12,00012,000
48,00048,000
25,00025,000
85,00085,000
52
thru
6,0006,000
6,0006,000
6,0006,000
6,0006,000
53
thru
6,0006,000
6,0006,000
6,0006,000
6,0006,000
54
thru
110,000110,000
110,000110,000
110,000110,000
110,000110,000
55
thru
80,00080,000
80,00080,000
80,00080,000
80,00080,000
56
thru
6,0006,000
6,0006,000
6,0006,000
6,0006,000
57
thru
25,00025,000
25,00025,000
25,00025,000
25,00025,000
58
thru
45,00045,000
45,00045,000
45,00045,000
45,00045,000
59
thru
45,00045,000
45,00045,000
45,00045,000
45,00045,000
60
thru
50,00050,000
50,00050,000
50,00050,000
50,00050,000
61
thru
35,00035,000
35,00035,000
35,00035,000
35,00035,000
62
thru
50,00050,000
50,00050,000
50,00050,000
50,00050,000
63
thru
125,000125,000
125,000125,000
125,000125,000
125,000125,000
64
thru
30,00030,000
30,00030,000
30,00030,000
30,00030,000
65
thru
30,00030,000
30,00030,000
30,00030,000
30,00030,000
66
thru
225,000225,000
225,000225,000
225,000225,000
225,000225,000
67
thru
100,000100,000100,000100,000100,000500,000
100,000100,000100,000100,000100,000500,000
100,000100,000100,000100,000100,000500,000
100,000100,000100,000100,000100,000500,000
68
Capital Improvement Plan
69
Capital Improvement Plan
70
Capital Improvement Plan
71
Capital Improvement Plan
72
Capital Improvement Plan
73
Capital Improvement Plan
74
Capital Improvement Plan
75
Capital Improvement Plan
76
Capital Improvement Plan
77
Capital Improvement Plan
78
thru
20,00035,00035,00035,00035,000160,000
20,00035,00035,00035,00035,000160,000
20,00035,00035,00035,00035,000160,000
20,00035,00035,00035,00035,000160,000
79
thru
15,00015,00015,00015,00015,00075,000
15,00015,00015,00015,00015,00075,000
15,00015,00015,00015,00015,00075,000
15,00015,00015,00015,00015,00075,000
80
thru
180,000180,000
180,000180,000
90,00090,000
90,00090,000
180,000180,000
81
Capital Improvement Plan
82
thru
170,000170,000
170,000170,000
170,000170,000
170,000170,000
83
Capital Improvement Plan
84
thru
110,000110,000
110,000110,000
110,000110,000
110,000110,000
85
Capital Improvement Plan
86
thru
3,500,0003,500,000
3,500,0003,500,000
1,250,0001,250,000
2,250,0002,250,000
3,500,0003,500,000
87
Capital Improvement Plan
88
thru
62,00065,00068,00070,00070,000335,000
62,00065,00068,00070,00070,000335,000
62,00065,00068,00070,00070,000335,000
62,00065,00068,00070,00070,000335,000
89
thru
200,000210,000220,000230,000240,0001,100,000
200,000210,000220,000230,000240,0001,100,000
200,000210,000220,000230,000240,0001,100,000
200,000210,000220,000230,000240,0001,100,000
90
thru
170,000180,000190,000200,000210,000950,000
170,000180,000190,000200,000210,000950,000
10,00010,00010,00010,00010,00050,000
160,000170,000180,000190,000200,000900,000
170,000180,000190,000200,000210,000950,000
91
thru
60,00062,00065,00068,00072,000327,000
60,00062,00065,00068,00072,000327,000
60,00062,00065,00068,00072,000327,000
60,00062,00065,00068,00072,000327,000
92
thru
56,00058,00060,00062,00065,000301,000
56,00058,00060,00062,00065,000301,000
56,00058,00060,00062,00065,000301,000
56,00058,00060,00062,00065,000301,000
93
thru
580,000510,0001,400,000630,0003,120,000
580,000510,0001,400,000630,0003,120,000
25,00017,500187,500103,500333,500
555,000492,5001,212,500526,5002,786,500
580,000510,0001,400,000630,0003,120,000
94
Capital Improvement Plan
95
Capital Improvement Plan
96
Capital Improvement Plan
97
Capital Improvement Plan
98
thru
1,226,0001,401,0002,575,000610,0001,581,0007,393,000
1,226,0001,401,0002,575,000610,0001,581,0007,393,000
307,000351,000644,000153,000396,0001,851,000
919,0001,050,0001,931,000457,0001,185,0005,542,000
1,226,0001,401,0002,575,000610,0001,581,0007,393,000
99
Capital Improvement Plan
100
Capital Improvement Plan
101
Capital Improvement Plan
102
Capital Improvement Plan
103
Capital Improvement Plan
104
thru
285,000300,0001,800,0002,385,000
285,000300,0001,800,0002,385,000
900,000900,000
285,000300,000900,0001,485,000
285,000300,0001,800,0002,385,000
105
Capital Improvement Plan
106
thru
21,00021,00022,00023,00024,000111,000
21,00021,00022,00023,00024,000111,000
21,00021,00022,00023,00024,000111,000
21,00021,00022,00023,00024,000111,000
107
thru
920,0001,200,0001,000,0001,000,0001,000,0005,120,000
920,0001,200,0001,000,0001,000,0001,000,0005,120,000
232,500300,000250,000250,000250,0001,282,500
687,500900,000750,000750,000750,0003,837,500
920,0001,200,0001,000,0001,000,0001,000,0005,120,000
108
Capital Improvement Plan
109
Capital Improvement Plan
110
thru
10,00010,000
200,000200,000
10,000200,000210,000
10,000200,000210,000
10,000200,000210,000
111
thru
750,000750,000
750,000750,000
750,000750,000
750,000750,000
112
Capital Improvement Plan
113
thru
150,000150,000
1,000,0001,000,000
150,0001,000,0001,150,000
150,0001,000,0001,150,000
150,0001,000,0001,150,000
114
thru
30,00055,00085,000
30,00055,00085,000
30,00055,00085,000
30,00055,00085,000
115
thru
460,000460,000
460,000460,000
20,00020,000
440,000440,000
460,000460,000
116
Capital Improvement Plan
117
thru
1,300,0001,300,000
1,300,0001,300,000
1,300,0001,300,000
1,300,0001,300,000
118
Capital Plan
Central Equipment45,00045,000
Community Center21,00010,00015,000
46,000
Engineering30,00040,000
70,000
Fire644,000225,000646,00071,00072,000
1,658,000
Information Technology22,000
22,000
Park & Rec - Operations285,00053,000170,000508,000
Sanitary Sewer90,00090,000
Storm Sewer250,000250,000
Streets / Highways374,000370,000340,000440,000252,000
1,776,000
1,445,000714,0001,456,000526,000324,0004,465,000
119
Capital Plan
Assessments90,00090,000
Capital Equipment Reserve68,00099,00046,00046,00046,000
305,000
Comm Ctr Operations21,00010,00015,00046,000
Equipment Bond1,264,000570,0001,375,000440,000252,000
3,901,000
General Fund23,00024,00025,00025,00026,000123,000
1,445,000714,0001,456,000526,000324,000
4,465,000
120
Capital Plan
Replacement - Service Truck #371221-48800-0145,000
45,000
Capital Equipment Reserve45,00045,000
45,00045,000
Replacement - Floor Scrubber121-44000-0115,00015,000
Comm Ctr Operations15,00015,000
Replacement - Kaivac Cleaning System121-44000-036,0006,000
Comm Ctr Operations6,0006,000
Replacement - Electric Edger122-44300-0210,000
10,000
Comm Ctr Operations10,00010,000
Replacement - Zamboni Battery Pack123-44300-0115,00015,000
Comm Ctr Operations15,00015,000
21,00010,00015,00046,000
Replacement - 3/4 Ton Truck #12220-41600-0530,00030,000
Equipment Bond30,00030,000
Replacement - Pick Up Truck #6222-41600-0140,000
40,000
Equipment Bond40,00040,000
70,000
30,00040,000
Replacement - Turnout Gear120-42200-0123,00024,00025,00025,00026,000
123,000
General Fund23,00024,00025,00025,00026,000123,000
Replacement - Engine 21 #4884120-42200-02510,000510,000
Equipment Bond510,000510,000
Replacement - (2) SCBA Compressors St 2 & 3120-42200-0365,00065,000130,000
Equipment Bond65,00065,000130,000
Replacement - 800 MHz radios220-42200-0446,00046,00046,00046,00046,000
230,000
Capital Equipment Reserve46,00046,00046,00046,00046,000230,000
Replacement - Grass Utility Vehicle (UTV) #4813121-42200-0145,00045,000
Equipment Bond45,00045,000
Replacement - Thermal Imaging Cameras121-42200-0245,00045,000
Equipment Bond45,00045,000
Replacement - Engine 31 #4800122-42200-01475,000
475,000
Equipment Bond475,000475,000
Replacement - Rescue 31 #4818122-42200-02100,000100,000
Equipment Bond100,000100,000
644,000225,000646,00071,00072,0001,658,000
121
Windows Server 2019 DataCenter Licenses220-41420-0112,00012,000
Capital Equipment Reserve12,00012,000
Aruba Switch Upgrade120-41420-0210,000
10,000
Capital Equipment Reserve10,00010,000
22,00022,000
Replacement - Water Tanker #161120-45000-03175,000
175,000
Equipment Bond175,000175,000
New - Large Capacity Mower120-45000-04110,000
110,000
Equipment Bond110,000110,000
Replacement - Cushman Field Dresser #547121-45000-0127,00027,000
Equipment Bond27,00027,000
Replacement - Trailer #T-555121-45000-0218,000
18,000
Equipment Bond18,00018,000
New - Turbine Tow-Behind Blower121-45000-038,0008,000
Capital Equipment Reserve8,0008,000
Replacement - Large Capacity Mower #585122-45000-01120,000
120,000
Equipment Bond120,000120,000
Replacement - Tractor #515122-45000-0250,000
50,000
Equipment Bond50,00050,000
285,00053,000170,000508,000
Lift Station Improvements120-48200-0190,000
90,000
Assessments90,00090,000
90,00090,000
Replacement - Elgin Street Sweeper #169122-48300-01250,000
250,000
Equipment Bond250,000250,000
250,000250,000
Replacement - Front End Loader #124120-43100-09275,000275,000
Equipment Bond275,000275,000
Replacement - One Ton Truck w/ Plow #133120-43100-1080,000
80,000
Equipment Bond80,00080,000
New - Slide-In Hotbox120-43100-1219,000
19,000
Equipment Bond19,00019,000
New - Dump Truck w/ Snow removal121-43100-01240,000240,000
Equipment Bond240,000240,000
New - One Ton Truck w/ Snow removal121-43100-0270,00070,000
Equipment Bond70,00070,000
Replacement - Bobcat S185 #120121-43100-0360,000
60,000
Equipment Bond60,00060,000
New - Dump truck w/ Snow removal122-43100-01240,000240,000
Equipment Bond240,000240,000
Replacement - Backhoe Loader #80122-43100-02100,000
100,000
Equipment Bond100,000100,000
122
Replacement - Dump Truck w/ Snow removal #20023-43100-011240,000240,000
Equipment Bond240,000240,000
Replacement - Aerial bucket truck #00-13923-43100-021200,000
200,000
Equipment Bond200,000200,000
Replacement - Dump Truck w/ Snow removal #201124-43100-01252,000
252,000
Equipment Bond252,000252,000
374,000370,000340,000440,000252,0001,776,000
4,465,000
1,445,000714,0001,456,000526,000324,000
123
thru
45,00045,000
45,00045,000
45,00045,000
45,00045,000
124
thru
15,00015,000
15,00015,000
15,00015,000
15,00015,000
125
thru
6,0006,000
6,0006,000
6,0006,000
6,0006,000
126
thru
10,00010,000
10,00010,000
10,00010,000
10,00010,000
127
thru
15,00015,000
15,00015,000
15,00015,000
15,00015,000
128
thru
30,00030,000
30,00030,000
30,00030,000
30,00030,000
129
thru
40,00040,000
40,00040,000
40,00040,000
40,00040,000
130
thru
23,00024,00025,00025,00026,000123,000
23,00024,00025,00025,00026,000123,000
23,00024,00025,00025,00026,000123,000
23,00024,00025,00025,00026,000123,000
131
thru
510,000510,000
510,000510,000
510,000510,000
510,000510,000
132
thru
65,00065,000130,000
65,00065,000130,000
65,00065,000130,000
65,00065,000130,000
133
thru
46,00046,00046,00046,00046,000230,000
46,00046,00046,00046,00046,000230,000
46,00046,00046,00046,00046,000230,000
46,00046,00046,00046,00046,000230,000
134
thru
45,00045,000
45,00045,000
45,00045,000
45,00045,000
135
thru
45,00045,000
45,00045,000
45,00045,000
45,00045,000
136
thru
475,000475,000
475,000475,000
475,000475,000
475,000475,000
137
thru
100,000100,000
100,000100,000
100,000100,000
100,000100,000
138
thru
12,00012,000
12,00012,000
12,00012,000
12,00012,000
139
thru
10,00010,000
10,00010,000
10,00010,000
10,00010,000
140
thru
175,000175,000
175,000175,000
175,000175,000
175,000175,000
141
thru
110,000110,000
110,000110,000
110,000110,000
110,000110,000
142
thru
27,00027,000
27,00027,000
27,00027,000
27,00027,000
143
thru
18,00018,000
18,00018,000
18,00018,000
18,00018,000
144
thru
8,0008,000
8,0008,000
8,0008,000
8,0008,000
145
thru
120,000120,000
120,000120,000
120,000120,000
120,000120,000
146
thru
50,00050,000
50,00050,000
50,00050,000
50,00050,000
147
thru
90,00090,000
90,00090,000
90,00090,000
90,00090,000
148
thru
250,000250,000
250,000250,000
250,000250,000
250,000250,000
149
thru
275,000275,000
275,000275,000
275,000275,000
275,000275,000
150
thru
80,00080,000
80,00080,000
80,00080,000
80,00080,000
151
thru
19,00019,000
19,00019,000
19,00019,000
19,00019,000
152
thru
240,000240,000
240,000240,000
240,000240,000
240,000240,000
153
thru
70,00070,000
70,00070,000
70,00070,000
70,00070,000
154
thru
60,00060,000
60,00060,000
60,00060,000
60,00060,000
155
thru
240,000240,000
240,000240,000
240,000240,000
240,000240,000
156
thru
100,000100,000
100,000100,000
100,000100,000
100,000100,000
157
thru
240,000240,000
240,000240,000
240,000240,000
240,000240,000
158
thru
200,000200,000
200,000200,000
200,000200,000
200,000200,000
159
thru
252,000252,000
252,000252,000
252,000252,000
252,000252,000
160
CITY OF ANDOVER
Road & Bridge Funds - Rollup
Projected Fund Balance
Estimate
201920202021202220232024TOTALS
Projected Sources of Revenue
Est. Annual MSA Construction Allocation$ 1,212,563$ 1,212,563$ 1,180,572$ 810,000$ 1,647,117$ 1,212,563$ 7,275,378
Est. Annual Maintenance Allocation404,188404,188404,188404,188404,188404,1882,425,128
General Fund Commitment(248,634)(256,093)(263,776)(271,689)(279,840)(288,235)(1,608,267)
Available MSA Maintenance155,554148,095140,412132,499124,348115,953816,861
Total MSA Available for other Commitments1,368,1171,360,6581,320,984942,4991,771,4651,328,5161,368,117
Federal / State Funds----900,000-900,000
Assessments*539,000564,500651,000911,500590,000749,5004,005,500
LGA - Local Government Aid-------
Tax Levy1,356,7881,391,5091,417,7581,441,5721,465,8631,490,6398,564,129
Total Revenues Available3,263,9053,316,6673,389,7423,295,5714,727,3283,568,65514,837,746
Projected Commitments
MSA - New & Reconstruct Routes2,270,000580,000-510,0001,400,000630,0005,390,000
MSA - Intersection Upgrades--285,000300,0001,800,000-2,385,000
R & B - Pavement Markings45,00060,00062,00065,00068,00072,000372,000
R & B - Curb Replacement54,00056,00058,00060,00062,00065,000355,000
R & B - New & Reconstruct Routes1,163,0001,226,0001,401,0002,575,000610,0001,581,0008,556,000
R & B - Seal Coating260,000200,000210,000220,000230,000240,0001,360,000
R & B - Crack Sealing248,000160,000170,000180,000190,000200,0001,148,000
R & B - Gravel Road Improvements20,00021,00021,00022,00023,00024,000131,000
R & B - Pedestrian Crossing-10,000200,000---210,000
R & B - Overlays-920,0001,200,0001,000,0001,000,0001,000,0005,120,000
Pedestrian Trail Reconstruction---370,000170,000170,000710,000
Pedestrian Trail Curb Ramp Replacements18,00019,00020,00022,00024,00026,000129,000
Pedestrian Trail Maintenance60,00063,00066,00069,00072,00075,000405,000
Total Commitments4,138,0003,315,0003,693,0005,393,0005,649,0004,083,00026,271,000
Revenues Over (Under) Expenditures(874,095)1,667(303,258)(2,097,429)(921,672)(514,345)
Fund Balance as of December 31, 20186,603,576
Fund Balance Brought Forward5,729,4815,731,1485,427,8903,330,4612,408,789
Ending Fund Balance$ 5,729,481$ 5,731,148$ 5,427,890$ 3,330,461$ 2,408,789$ 1,894,444
* Assuming collected in same year
161
CITY OF ANDOVER
Park Improvement Fund
Projected Fund Balance
Estimate
201920202021202220232024TOTALS
Projected Sources of Revenue
Park Dedication Fee - Residential Units4040252525
Park Dedication Fee - Residential ($3,415/unit)$ 222,925$ 136,600$ 136,600$ 85,375$ 85,375$ 85,375$ 752,250
less: Contribution to Comm Ctr Expan (50%)-(111,463)(68,300)(68,300)(42,688)(42,688)(333,439)
Donation / Contribution - Kelsey Round Lake Park76,000----76,000
Donation / Contribution - Lights at ASN-90,000----90,000
Capital Projects Levy - Park Improvements15,00015,00015,00015,00015,00015,00090,000
Total Revenues Available237,925206,13783,30032,07557,68757,687674,811
Projected Commitments
Irrigation Project - Small40,00040,000
Kelsey Round Lake Park - Trail Expansion175,000175,000
Andover Station North east field lighting180,000180,000
Prairie Knoll Park - Pave north parking lot170,000170,000
Annual Miscellaneous Projects15,00015,00015,00015,00015,00015,00090,000
Total Commitments55,000370,000185,00015,00015,00015,000655,000
Revenues Over (Under) Expenditures182,925(163,863)(101,700)17,07542,68742,687
Fund Balance as of December 31, 2018158,707
Fund Balance Brought Forward341,632177,76976,06993,144135,831
Ending Fund Balance **$ 341,632$ 177,769$ 76,069$ 93,144$ 135,831$ 178,518
**Target - $50,000 to create a contingency for any project overages.
Dedicated Funds Available for:
Rose Park - tower rental fee$ 22,553
Chesterton Commons Park - Donation1,076
$ 23,629
162
CITY OF ANDOVER
Trail Fund
Projected Fund Balance
Estimate
201920202021202220232024TOTALS
Projected Sources of Revenue
Trail Fee $807 per unit
platted units4040252525
Trail Fee - $870$ 57,500$ 34,800$ 34,800$ 21,750$ 21,750$ 21,750$ 192,350
Grant-117,550----117,550
Operating Transfer In-------
Total Revenues Available57,500152,35034,80021,75021,75021,750309,900
Projected Commitments
Railroad Underpass Trail115,80012,000330,000457,800
8' Boardwalk along Crosstown Blvd 465,000465,000
10' Bituminous Trail Connection - Andover Station North230,000230,000
8' Bituminous Trail along Crosstown Blvd -
Xeon St to railroad tracks168,000168,000
Railroad tracks to 157th Ave304,000304,000
157th Ave to 159th Ave250,000250,000
8' Bituminous Trail along Station Parkway -
Thrush St to Partridge Cir74,00074,000
Partridge Cir to Hanson Blvd185,000185,000
8' Bituminous Trail along Verdin St -675,000675,000
161st Ave to 163rd Lane
Total Commitments580,800242,000-1,052,000259,000675,000$ 2,808,800
Revenues Over (Under) Expenditures(523,300)(89,650)34,800(1,030,250)(237,250)(653,250)
Fund Balance as of December 31, 2018509,126
Fund Balance Brought Forward(14,174)(103,824)(69,024)(1,099,274)(1,336,524)
Ending Fund Balance *$ (14,174)$ (103,824)$ (69,024)$ (1,099,274)$ (1,336,524)$ (1,989,774)
*Target - 10% of current years commitments to create a contingency for any project overages.
** It is anticipated that all projects will not be fully expended by the end of the year, and future projects will be contingent on additional revenues.
163
CITY OF ANDOVER
Capital Equipment Reserve Fund
Projected Fund Balance
Estimate
201920202021202220232024TOTALS
Projected Sources of Revenue
Capital Projects Levy$ 275,000$ 275,000$ 275,000$ 275,000$ 275,000$ 275,000$ 1,650,000
Donations / Contributions-------
Operating Transfers In - Cent Eq--45,000---45,000
Operating Transfers In - Storm Water EF23,50023,50023,50023,50023,500-117,500
Operating Transfers In - CC Expan Reimb157,839-----157,839
Total Revenues Available456,339298,500343,500298,500298,500275,0001,970,339
Projected Commitments
Annual Parking Lot Maintenance35,00035,000
Replacement - Emergency Sirens40,00040,00040,00040,000160,000
Emergency Operations Center Improvements7,50010,00010,00027,500
Replacement - Election Voting Booths25,00025,000
Building A - Seal Floor25,00030,00055,000
Memorial - Veterans Memorial10,00010,000
Replacement - Small Extended Cab Truck #835,00035,000
New - Emergency Siren Additions55,00055,000110,000
New - Sign Message Board18,00018,000
Community Center Fieldhouse Floor Repair134,634134,634
Windows Server 2019 DataCenter Licenses12,00012,000
Aruba Switch Upgrade10,00010,000
Hills of Bunker West Park Trail Recon70,00070,000
Replacement - 800 MHz Radios46,00046,00046,00046,00046,000230,000
Replacement - Service Truck #37145,00045,000
Financial / Payroll System Upgrade / Replacement225,000225,000
New - Buffalo Turbine Tow-Behind Blower8,0008,000
Dalske Preserve Boardwalk110,000110,000
Pine Hills North Parking Lot134,488134,488
Natural Disaster Reserve350,000350,000
QCTV - Council Chambers85,26485,264
Total Commitments780,252337,634374,00086,000226,00086,000$ 1,889,886
Revenues Over (Under) Expenditures(323,913)(39,134)(30,500)212,50072,500189,000
Fund Balance as of December 31, 20181,386,664
Fund Balance Brought Forward1,062,7511,023,617993,1171,205,6171,278,117
Ending Fund Balance $ 1,062,751$ 1,023,617$ 993,117$ 1,205,617$ 1,278,117$ 1,467,117
164
CITY OF ANDOVER
Building Fund
Projected Fund Balance
Estimate
201920202021202220232024TOTALS
Projected Sources of Revenue
Facility Maintenance Reserve Levy$ 355,000$ 355,000$ 355,000$ 355,000$ 355,000$ 355,000$ 2,130,000
Miscellaneous Revenues-------
Operating Transfers In-------
Total Revenues Available355,000355,000355,000355,000355,000355,0002,130,000
Projected Commitments
Replacement - Tube Heaters FS #225,00025,000
Replacement - Roof PW40,00040,000
Replacement - Skylights CH20,00020,000
Replacement - Make Up Air Units FS #130,00030,000
Demo Pole Barn6,8006,800
Annual Parking Lot Maintenance39,00044,00083,000
Replacement - PW Parking Lot / Fuel Island Removal250,000250,000
Surface Seal all Brick Structures48,00048,000
Fence Around PW Yard110,000110,000
Comm Ctr Refrigeration Equipment Conversion273,478273,478
Replacement - Tube Heaters PW80,00080,000
Replacement - Tube Heaters FS #125,00025,000
New - Diesel Exhaust Capturing System45,00045,000
Replacement - Ch Parking Lot / Garage Driveway230,000230,000
Replacement - Roof Top Package Unit PW45,00045,000
Replacement - FS #2 Parking Lot150,000150,000
Replacement - Emergency Generator FS #150,00050,000
Replacement - Emergency Generator FS #235,00035,000
Replacement - Emergency Generator FS #350,00050,000
Replacement - Make Up Air Units / Exhaust Fan PW125,000125,000
Replacement - Carpet/Tile30,00030,000
Andover Station Outlet E - landscaping improvements25,00025,000
Total Commitments146,800681,478189,000275,000410,00074,000$ 1,776,278
Revenues Over (Under) Expenditures208,200(326,478)166,00080,000(55,000)281,000
Fund Balance as of December 31, 2018244,859
Fund Balance Brought Forward453,059126,581292,581372,581317,581
Ending Fund Balance $ 453,059$ 126,581$ 292,581$ 372,581$ 317,581$ 598,581
165
CITY OF ANDOVER
Water System Financial Projections
ActualEstimateForecast
Year20142015201620172018201920202021202220232024
Inflation Factor3.0%3.0%3.0%3.0%3.0%3.0%
Ave. Use (gal per user per qtr)31,70834,03031,49032,77336,26033,00033,00033,00033,00033,00033,000
Acres Added 555 55
New Connections 101010 1010
New Customers 353535 3535
Residential Accounts6,2666,3346,4256,5146,564
Commercial/Institutional Accts145147154 149161
Total Accounts6,4116,4816,5796,6636,7256,750 6,7856,8206,855 6,8906,925
1.09%1.51%1.28%0.93%0.37%
Rates
Base Rate$12.19$12.50$13.13$13.33$13.67$14.01$14.15$14.51$14.87$15.24$15.62
Use Rate$1.96$1.98$2.12$2.18$2.26$2.34$2.37$2.46$2.54$2.63$2.72
Connection Charge$4,131$4,296$4,647$4,833$5,026$5,227$5,332$5,545$5,767$5,997$6,237
Area Charge$3,786$3,937$4,258$4,428$4,605$4,789$4,885$5,080$5,284$5,495$5,715
Base Rate0.0%2.5%5.0%1.5%2.6%2.5%1.0%2.5%2.5%2.5%2.5%
Use Rate0.0%1.0%7.1%2.8%3.7%3.5%1.5%3.5%3.5%3.5%3.5%
Connection Charge0.0%4.0%8.2%4.0%4.0%4.0%2.0%4.0%4.0%4.0%4.0%
Area Charge0.0%4.0%8.2%4.0%4.0%4.0%2.0%4.0%4.0%4.0%4.0%
ActualEstimateForecast
Enterprise Fund - Water Operations
20142015201620172018201920202021202220232024
Cash flows from operating activities:
Receipts from customers and users $2,178,391$2,741,777$2,536,035$2,555,019$3,167,024$2,534,341$2,616,769$2,718,466$2,824,074$2,933,743$3,047,627
Payment to suppliers (745,176)(825,038)(897,109)(811,931)(830,244)(1,022,540)(1,020,140)(1,050,744)(1,082,267)(1,114,735)(1,148,177)
Payment to employees (408,441)(408,276)(478,808)(440,973)(480,749)(503,007)(542,747)(559,029)(575,800)(593,074)(610,867)
Net from operating activities 1,024,7741,508,4631,160,1181,302,1151,856,0311,008,7941,053,8821,108,6931,166,0081,225,9341,288,584
Cash flows from noncapital financing activities:
Intergovernmental revenue --2,681 - -- - - - - -
Transfers in 20,73758,24985,09654,228114,85058,11059,74088,00813,60514,14914,715
Transfers out - Replacement Reserve--- - -(300,000)(300,000)(300,000)(300,000)(300,000)(300,000)
Transfers out - PW Expansion--- - -(157,683)(22,650)(22,650)(22,650)(22,650)(22,650)
Transfers out (150,250)(150,250)(150,250)(150,250)(90,700)(95,226)(93,975)(95,611)(97,684)(99,598)(73,834)
Net from noncapital financing activities (129,513)(92,001)(62,473)(96,022)24,150(494,799)(356,885)(330,253)(406,729)(408,099)(381,769)
Cash flows from capital and related financing activities:
Acquisition of capital assets -(2,863)(1,500)(14,244)(54,264)(70,000) -(1,300,000) - - -
Payment on debt(828,807)(831,486)(831,992)(4,734,403)(776,843)(781,980)(786,500)(780,492)(784,042)(782,152)(86,806)
Receipt of bonds--4,006,006 - -- - - - - -
Proceeds from the sale of capital assets--7676,635-- - - - - -
Net from capital and related financing activities (828,807)(834,349)3,173,281(4,742,012)(831,107)(851,980)(786,500)(2,080,492)(784,042)(782,152)(86,806)
Cash flows from investing activities:
Investment income 44,57623,91329,60130,30855,85230,00030,00015,00015,00015,00015,000
Net increase in cash and cash equivalents 111,030606,0264,300,527(3,505,611)1,104,926(307,985)(59,503)(1,287,052)(9,764)50,683835,009
Cash and cash equivalents - January 1 2,143,4392,254,4692,860,4957,161,0223,655,4114,760,3374,452,3524,392,8493,105,7973,096,0333,146,716
Cash and cash equivalents - December 31 $2,254,469$2,860,495$7,161,022$3,655,411$4,760,337$4,452,352$4,392,849$3,105,797$3,096,033$3,146,716$3,981,725
166
CITY OF ANDOVER
Water System Financial Projections
ActualEstimateForecast
Capital Projects Fund - Water Trunk
20142015201620172018201920202021202220232024
Revenues
Connection Charges$487,928$309,873$282,536$322,249$341,371$502,903$53,316$55,448$57,666$59,973$62,372
Area Charges--- - --24,42525,40226,41827,47528,574
Interest71,23635,03437,68039,85962,66425,00025,00025,00025,00025,00025,000
Special Assessment37,27442,342448,039409,286166,43596,15050,00050,00050,00050,00050,000
Replacement Reserve--- - -300,000300,000300,000300,000300,000300,000
Xfer In--- - -- - - - - -
Total596,438387,249768,255771,394570,470924,053452,741455,850459,084462,448465,946
Expenses
Debt Service--- - -- - - - - -
Capital Outlay183,920112,150650,516103,515289,691995,000200,0001,495,00060,00060,00065,000
Xfer Out20,73758,24985,09654,228114,85058,11059,74088,00813,60514,14914,715
Total204,657170,399735,612157,743404,5411,053,110259,7401,583,00873,60574,14979,715
Net Increase (Decrease) in Fund Balance391,781216,85032,643613,651165,929(129,057)193,001(1,127,158)385,479388,299386,231
Fund Balance - January 12,245,9322,637,7132,854,5632,887,2063,500,8573,666,7863,537,7293,730,7302,603,5722,989,0513,377,350
Fund Balance - December 31$2,637,713$2,854,563$2,887,206$3,500,857$3,666,786$3,537,729$3,730,730$2,603,572$2,989,051$3,377,350$3,763,581
Capital Projects
Wells
Rehab Wells50,00030,00055,000
Trunk
New Development Projects45,00050,00055,00060,00060,00065,000
Water Main Improvements750,000440,000
Water Tower #2 Recondition & Repaint150,0001,000,000
Plant
Equipment70,000
Automated Meter Reading System1,300,000
Total$-$-$-$ - $-$915,000$200,000$2,825,000$60,000$115,000$65,000
Funded by Operations$-$-$-$ - $-$120,000$ -$1,330,000$ -$55,000$ -
Funded by Infrastructure/Trunk--- - -795,000200,0001,495,00060,00060,00065,000
Funded by debt--- - -- - - - - -
Total$-$-$-$ - $-$915,000$200,000$2,825,000$60,000$115,000$65,000
Debt
Rate5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%
Term101010 101010 101515 1515
AADS$-$-$-$ - $-$-$ -$ -$ -$ -$ -
Cumulative DS$-$-$-$ - $-$-$ -$ -$ -$ -$ -
Current DS$828,806$831,487$833,101$4,734,403$776,843$781,980$786,500$780,492$784,042$782,152$86,806
167
CITY OF ANDOVER
Sanitary Sewer System Financial Projections
ActualForecast
Estimate
Year20142015201620172018201920202021202220232024
Inflation Factor3.0%3.0%3.0%3.0%3.0%3.0%
Acres Added555555
New Connections101010101010
New Customers353535353535
Residential Accounts7,1777,2387,3317,4197,474-
Commercial SACs1,4991,5171,5611,5921,847-
Total Accounts8,6768,7558,8929,0119,3219,3509,3859,4209,4559,4909,525
#DIV/0!0.91%1.56%1.34%3.44%0.31%
Rates
Base Rate$59.37$59.37$59.37$61.15$61.15$61.15$61.15$62.98$64.87$66.82$68.82
Connection Charge$435$435$435$452$452$452$452$470$489$508$529
Area Charge$1,613$1,613$1,613$1,678$1,678$1,678$1,678$1,745$1,815$1,888$1,963
Base Rate0.0%0.0%3.0%0.0%0.0%0.0%3.0%3.0%3.0%3.0%
Connection/Area0.0%0.0%3.9%0.0%0.0%0.0%4.0%4.0%4.0%4.0%
Area Charge0.0%0.0%4.0%0.0%0.0%0.0%4.0%4.0%4.0%4.0%
ActualEstimateForecast
Enterprise Fund - Sanitary Sewer Operations
20142015201620172018201920202021202220232024
Cash flows from operating activities:
Receipts from customers and users $ 1,938,680$ 2,244,730$ 2,131,393$ 2,151,936$ 2,437,302$ 2,234,910$ 2,295,571$ 2,373,256$ 2,453,536$
2,536,497$ 2,622,227
Payment to suppliers (1,156,406)(1,185,024)(1,306,202)(1,336,251)(1,272,939)(1,469,928)(1,521,558)(1,567,205)(1,614,221)(1,662,648)(1,712,527)
Payment to employees (295,075)(320,710)(303,820)(304,918)(335,110)(379,000)(406,517)(418,713)(431,274)(444,212)(457,538)
Net from operating activities 487,199738,996521,371510,767829,253385,982367,496387,339408,041429,637452,162
Cash flows from noncapital financing activities:
Transfers out - Replacement Reserve(400,000)(400,000)(400,000)(400,000)(400,000)(400,000)(400,000)(400,000)(400,000)(400,000)(400,000)
Transfers out - PW Expansion-----(157,683)(22,650)(22,650)(22,650)(22,650)(22,650)
Transfers out (46,680)(46,680)(46,680)(46,680)(70,012)(73,957)(77,123)(79,437)(81,820)(84,274)(86,803)
Net from noncapital financing activities (446,680)(446,680)(446,680)(446,680)(470,012)(631,640)(499,773)(502,087)(504,470)(506,924)(509,453)
Cash flows from capital and related financing activities:
Acquisition of capital assets -(81,749)-(227,221)(9,864)------
Proceeds from the sale of capital assets--1,42520,710-------
Net from capital and related financing activities -(81,749)1,425(206,511)(9,864)------
Cash flows from investing activities:
Investment income 68,42331,30632,18129,28545,58330,00030,00030,00030,00030,00030,000
Net increase in cash and cash equivalents 108,942241,873108,297(113,139)394,960(215,658)(102,277)(84,748)(66,429)(47,287)(27,291)
Cash and cash equivalents - January 1 2,674,4552,783,3973,025,2703,133,5673,020,4283,415,3883,199,7303,097,4533,012,7052,946,2762,898,989
Cash and cash equivalents - December 31 $ 2,783,397$ 3,025,270$ 3,133,567$ 3,020,428$ 3,415,388$ 3,199,730$ 3,097,453$ 3,012,705$ 2,946,276$
2,898,989$ 2,871,699
168
CITY OF ANDOVER
Sanitary Sewer System Financial Projections
ActualEstimateForecast
Capital Projects Fund - Sewer Trunk20142015201620172018201920202021202220232024
Revenues
Connection Charges$ 188,898$ 96,094$ 163,162$ 90,442$ 103,618$ 197,920$ 4,520$ 4,701$ 4,889$
5,084$ 5,288
Area Charges------8,3908,7269,0759,4389,815
Interest156,45475,97887,36683,110127,53350,00050,00050,00050,00050,00050,000
Special Assessment13,21927,19528,13831,32974,23320,00020,00020,00020,00020,00020,000
Replacement Reserve400,000400,000400,000400,000400,000400,000400,000400,000400,000400,000400,000
Other---7,500------3,500,000
Total758,571599,267678,666612,381705,384667,920482,910483,426483,963484,5223,985,103
Expenses
Debt Service-----------
Capital Outlay134,94359,130205,935270,363241,5671,135,000215,000125,000125,000130,0003,635,000
Total134,94359,130205,935270,363241,5671,135,000215,000125,000125,000130,0003,635,000
Net Increase (Decrease) in Fund Balance623,628540,137472,731342,018463,817(467,080)267,910358,426358,963354,522350,103
Fund Balance - January 14,918,1655,541,7936,081,9306,554,6616,896,6797,360,4966,893,4167,161,3267,519,7527,878,7168,233,238
Fund Balance - December 31$ 5,541,793$ 6,081,930$ 6,554,661$ 6,896,679$ 7,360,496$ 6,893,416$ 7,161,326$ 7,519,752$ 7,878,716$ 8,233,238$
8,583,341
Capital Projects
Infrastructure
New Development Projects$ 120,000$ 125,000125,000125,000130,000135,000
Aztec Estates Lift Station Upgrade90,000
Yellow Pine Lift Station700,000
Coon Creek Trunk Bypass225,000
Rural Reserve Trunk Sanitary Sewer3,500,000
Equipment-
Total$ -$ -$ -$ -$ -$ 1,045,000$ 215,000$ 125,000$ 125,000$ 130,000$
3,635,000
Funded by Operations$ -$ -$ -$ -$ -$ -$ -$ -$ -$
-$ -
Funded by Infrastructure/Trunk-----1,045,000215,000125,000125,000130,000135,000
Funded by debt----------3,500,000
Total$ -$ -$ -$ -$ -$ 1,045,000$ 215,000$ 125,000$ 125,000$ 130,000$
3,635,000
Debt
Rate5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%
Term1010101010101010101010
AADS$ -$ -$ -$ -$ -$ -$ -$ -$ -$
-$ -
Cumulative DS$ -$ -$ -$ -$ -$ -$ -$ -$ -$
-$ -
Current DS$ -$ -$ -$ -$ -$ -$ -$ -$ -$
-$ -
169
CITY OF ANDOVER
Storm Sewer System Financial Projections
ActualForecast
Estimate
Year20142015201620172018201920202021202220232024
Inflation Factor3.0%3.0%3.0%3.0%3.0%
New Customers3535353535
Residential - Urban / Rural (units)9,6979,7499,8679,9389,95910,02510,06010,09510,13010,16510,200
Multiple Dwelling (acres)232235220220222222222222222222222
Comm / Industrial (acres)412409443478478414414414414414414
Schools / Churches (acres)282282282312312282282282282282282
Rates (Qtrly)
Residential - Urban / Rural - per unit$ 8.49$ 8.91$ 9.36$ 9.82$ 10.31$ 10.83$ 11.37$ 11.94$
12.54$ 13.16$ 13.82
Multiple Dwelling - per acre$ 18.69$ 19.62$ 20.61$ 21.64$ 22.72$ 23.86$ 25.05$ 26.31$
27.62$ 29.00$ 30.45
Comm / Industrial - per acre$ 36.07$ 37.87$ 39.76$ 41.75$ 43.84$ 46.03$ 48.33$ 50.75$
53.29$ 55.95$ 58.75
Schools / Churches - per acre$ 16.97$ 17.82$ 18.71$ 19.65$ 20.63$ 21.66$ 22.74$ 23.88$
25.07$ 26.33$ 27.64
Residential - Urban / Rural - per unit5.0%4.9%5.1%4.9%5.0%5.0%5.0%5.0%5.0%5.0%5.0%
Multiple Dwelling - per acre5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%
Comm / Industrial - per acre5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%
Schools / Churches - per acre5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%
ActualEstimateForecast
Enterprise Fund - Storm Sewer Operations20132014201520162018201920202021202220232024
Cash flows from operating activities:
Receipts from customers and users $ 376,260$ 462,208$ 451,961$ 469,707$ 546,457$ 529,693$ 556,251$ 585,652$ 616,602$
649,182$ 683,480
Payment to suppliers (412,240)(155,178)(108,000)(156,064)(116,329)(229,096)(231,938)(238,896)(246,063)(253,445)(261,048)
Payment to employees (192,958)(212,555)(208,740)(264,334)(227,914)(239,232)(257,821)(265,556)(273,522)(281,728)(290,180)
Net from operating activities (228,938)94,475135,22149,309202,21461,36566,49281,20097,016114,010132,252
Cash flows from noncapital financing activities:
Transfers out ----(41,346)(108,168)(43,090)(43,678)(69,283)(46,407)(47,049)
Cash flows from capital and related financing activities:
Acquisition of capital assets -(2,863)--(9,864)------
Proceeds from the sale of capital assets---5,510-------
Net from capital and related financing activities -(2,863)-5,510(9,864)------
Cash flows from investing activities:
Investment income 2,9707082,0802,6035,5111,0001,0001,0001,0001,0001,000
Net increase in cash and cash equivalents (225,968)92,320137,30157,422156,515(45,803)24,40238,52228,73368,60386,203
Cash and cash equivalents - January 1 251,68125,713118,033255,334312,756469,271423,468447,869486,391515,124583,726
Cash and cash equivalents - December 31 $ 25,713$ 118,033$ 255,334$ 312,756$ 469,271$ 423,468$ 447,869$ 486,391$ 515,124$
583,726$ 669,929
Capital Projects
Infrastructure
Storm Sewer Improvements$ 60,000$ 62,000$ 65,000$ 68,000$ 70,000$ 70,000
Equipment-----
Total$ -$ -$ -$ -$ -$ 60,000$ 62,000$ 65,000$ 68,000$ 70,000$
70,000
Funded by Operations$ -$ -$ -$ -$ -$ 60,000$ 62,000$ 65,000$ 68,000$
70,000$ 70,000
Funded by Infrastructure/Trunk-----------
Funded by debt-----------
Total$ -$ -$ -$ -$ -$ 60,000$ 62,000$ 65,000$ 68,000$ 70,000$
70,000
170