HomeMy WebLinkAbout2003-208 CCRMember Kay Lasman introduced the following resolution and moved its
adoption:
RESOLUTION NO. 2003-208
and
RESOLUTION ADOPTING CAPITAL IMPROVEMENT PROGRAM
WHEREAS, the Council annually adopts a five-year Capital Improvement Program;
WHEREAS, the Council has conducted a Public Hearing on the proposed 2004-2008
Capital Improvement Program; and
WHEREAS, attached hereto and incorporated herein by reference as Exhibit A is a
proposed Capital Improvement Program for the period 2004-2008.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of
Brooklyn Center that the 2004-2008 Capital Improvement Program as set forth in Exhibit A to this
resolution be and hereby is adopted.
December 8, 2003 VL'0~ A_4_e41W14"
Date d Mayor 4
ATTEST:
City Clerk
The motion for the adoption of the foregoing resolution was duly seconded by member
Diane Niesen
and upon vote being taken thereon, the following voted in favor thereof:
Myrna Kragness, Kay Lasman, Diane Niesen, and Bob Peppe;
and the following voted against the same: none;
whereupon said resolution was declared duly passed and adopted.
RESOLUTION NO. 2003-208
EXHIBIT A
City of Brooklyn Center
2004-2008 CAPITAL IMPROVEMENT PROGRAM
PROFILE
The Capital Improvement Program (CIP) is a planning document that presents a five-year overview of
scheduled capital projects that address many of the City's strategic goals. It includes a long-term
financing plan that allows the City to allocate funds for these projects based on assigned priorities. The
five-year horizon of the CIP provides the City with an opportunity to evaluate project priorities annually
and to adjust the timing, scope and cost of projects as new information becomes available. The
information contained in this plan represents the City's best estimate of improvement costs based on
present knowledge and expected conditions.
A capital improvement is defined as a major non-recurring expenditure related to the City's physical
facilities and grounds. The 2004-2008 CIP makes a concerted effort to distinguish between major
maintenance projects contained in the City's operating budgets and capital improvement projects financed
through the City's capital funds and proprietary funds. Typical expenditures include the cost of land
acquisition and the cost to construct roads, utilities, parks, or municipal structures.
The CIP is predicated on the goals and policies established by the City Council, including the general
development, redevelopment, and maintenance policies that are part of the City's Comprehensive Plan. A
primary objective of the CIP is to identify projects that further these goals and policies in a manner
consistent with funding opportunities and in coordination with other improvement projects.
The City's Comprehensive Plan identifies several general community goals that are advanced by projects
included in the 2004-2008 CIP. The major projects that support these goals focus on maintaining
neighborhoods and community redevelopment. These goals include:
• Carving out a unique and desirable niche in the Twin Cities that capitalizes on the City's physical
location, its highway and transit accessibility, its diversified mix of land uses, and its parks and
natural resources.
• Gaining an increased sense of unity and place by retrofitting the public elements of neighborhoods
and creating linkages that connect neighborhoods to mixed uses in the civic core and to other
attractive public spaces.
• Developing a positive public image.
CIP 2004-2008 OVERVIEW
The 2004-2008 CIP proposes capital expenditures totaling $24,292,700 for various improvements to the
City's parks, streets, and public utilities. The CIP begins with a series of tables and charts that provide an
overview of scheduled projects by function and estimated funding.
Types of CIP Projects
Table 1 and the accompanying chart summarize capital expenditures by functional area as defined below
for the five-year period of 2004-2008.
RESOLUTION NO. 2003-208
Public Utilities
The City operates five utility systems, four of which have projects included in the CIP -water, sanitary
sewer, storm drainage, and street lighting. Nearly 90 percent of the public utilities are constructed in
conjunction with street reconstruction projects. The remaining 10 percent of public utilities projects
include improvements to well houses, lift stations and interceptors and water quality studies that examine
storm water discharge and provide recommendations for related improvements.
Park Improvements
Park improvements include the construction of trails, shelters, and other facilities that enhance general
park appearance and increase park usage by providing recreational facilities that meet community needs.
Public Buildings
Construction of municipal buildings and major renovations to existing buildings are considered capital
improvements. Major capital expenditures to public buildings are not anticipated during this five-year
period.
Street Improvements
Street improvements include reconstruction of neighborhood streets with curb, gutter and sidewalks and
reconstruction of arterial and collector streets. As noted earlier, street improvements are almost always
accompanied by replacement of public utilities.
TABLE 1- Capital Improvement Program
Summary by Functional Area
PUBLIC UTILITY IMPROVEMENTS:
Water Utility Capital Projects
Sanitary Sewer Utility Capital Projects
2004 2005 2006
2007 2008
$685,900 $657,500 $676,200
$639,500 $620,800 $1,105,200
$601,800 $689,700
$600,100 $1,084,000
Storm Drainage Utility Capital Projects
$601,20
$582,800
$436,100
$602,400
$984,900
Street Lighting Utility Capital Projects
$85,
$86,500
$60,800
$75,100
$145,200
SUBTOTAL
$2,011,60
$1,947,600
$2,278,300
$1,879,400
$2,903,800
PARK IMPROVEMENTS
$368,2001
$235,7001
$322,8001
$102,5001
$200,0001
PUBLIC BUILDINGS
1 $ol
$0 1
$0 I
$0
$01
TECHNOLOGY/FIBER OPTIC
$68,000
$01
$01
$0
$0I
1 STREET IMPROVEMENTS
I $2,477,004
$1,833,8001
$2,469,100 1
$2,073,100
$3,388,1001
TOTAL
I $4,924,80
$4,017,100 1
$5,070,200 I
$4,055,000 1
$6,491,9001
RESOLUTION NO. 2003-208
CIP Funding Sources
Capital expenditures by funding source for the five-year period are shown in Table 2 and the
accompanying chart. Funding sources include:
Public Utility Funds
Customers are billed for services provided by the City's water, sanitary sewer, storm sewer, and street
lighting public utilities. Fees charged to customers are based on operating requirements and capital needs
to ensure that equipment and facilities are replaced to maintain utility services. Annually the City Council
evaluates the needs of each public utility system and establishes rates for each system to meet those needs.
A more detailed analysis of the fees and charges and a five-year cash flow projection is provided with
each public utility budget section and is included in the Appendix. Note that projected capital outlay
expenditures may include capital items from the operating budget not covered by the CIP.
Capital Projects Fund
This fund is comprised of transfers from the General Fund, repayment of debt from the Golf Course
operating fund, and transfers from liquor operations. Typically the City Council has directed these funds
towards municipal facilities such as parks, public buildings and other general purpose needs. The
projected five-year cash flow of the Capital Projects Fund is available as part of the fund's budget detail.
Special Assessment Collections
Properties benefiting from street improvements are assessed a portion of the project costs. Every year the
City Council establishes special assessment rates for projects occurring the following year to maintain the
relative proportion of special assessments to other funding sources.
Infrastructure Construction Fund
Prior to 2003, this fund was called the Special Assessment Construction Fund. Neighborhood projects
were funded in part from this fund based on transfers and accumulated fund balances. Beginning in 2003,
all funding required to finance neighborhood street projects is transferred to this fund and all costs
associated with these projects will be accounted for in the new fund. The projected five-year cash flow of
the Infrastructure Construction Fund is available as part of the fund's budget detail.
Municipal State Aid (MSA) Fund
State-shared gas taxes provide funding for street improvements and related costs for those roadways
identified as MSA streets. The City has 21 miles of roadway identified as MSA streets and is therefore
eligible to receive monies based on this designation. The annual amount available is slightly more than
$900,000 and provides for debt service, maintenance and construction activities within our MSA street
system. The projected five-year cash flow of the MSA Fund is available as part of the fund's budget
detail
RESOLUTION NO. 2003-208
TABLE 2 - Capital Improvement Program
Summary by Funding Source
1
2004 1 2005 1 2006 1 2007 1 2008 1 TOTAL
Water Utility
$685,900
$657,500
$676,200
$601,800
$689,700
$3,311,1001
Sanitary Sewer Utility
$639,500
$620,800
$1,105,200
$600,100
$1,084,000
$4,049,600
Storm Drainage Utility
$601,200
$582,800
$436,100
$602,400
$984,900
$3,207,400
Street Lighting Utility
$85,000
$86,500
$60,800
$75,100
$145,200
$452,600
Municipal State Aid
$791,800
$159,900
$685,400
$409,900
$451,200
$2,498,200
(Street Construction Fund
$689,000
$817,400
$684,700
$757,900
$1,366,400
$4,315,400
Capital Projects Fund
$436,200
$235,700
$322,800
$102,500
$200,000
$1,297,200
Special Assessment Collections
$959,900
$856,500
$1,099,000
$905,300
$1,570,500
$5,391,200
Grants
$36,300
$0
$0
$0
$0
$36,3001,
_
TOTAL
1 $4,894,800 1
$4,017,100 =
-
$5,070,200 1
$4,055,000 1
-
$6,491,900 ~
-
$24,559,000
Table 3 provides an overview of projects and funding sources for the 2003-2007 CIP. Annual breakdowns
for each project year are accompanied by a brief description of each project.
TABLE 3 • CAPITAL IMPROVEMENT PROGRAM 2004-2008
Revised 11-13-03
Project
2004
Grandview Park
Aggressive Skate Park
73rd Avenue
Northport Improvement Project
Shingle Creek Pkwy
Fiber Optic Connection
Freeway Blvd Bridge Repairs
Evergreen Park Sidewalks
Description Sources
Special Street Capital Projects Water Utility Sewer Utility Storm Sewer Streetlight MSA Grants
Assessment Construction Fund Utility Utility
Collections Fund
Athletic fields, lights, and playground
Skate Park Improvements
Humboldt to Palmer Lake
Neighborhood street project
Street improvement project
Communications connection to LOGIS
Repairs to Bridge Deck and Superstructure
Sidewalk construction
2005
Central Park Lighting
Earle Brown Improvement Project Street improvement project
Tangletown Improvement Project South Street improvement project
$ 73,400 $ 89,600
$ 614,900 $ 548,200
$ 271,600
$ 51,200
Total 2004 $ 959,900 $ 689,000 $
i
Total Project
Cost
338,200
$
338,200
30,000
$
63,300
$
59,800
$
57,200
$
343,300
$
612,300
$
569,400
$
523,500 $
85,000 $
348,400
$
3,301,700
$
10,300
$
10,300
$
20,500
$
358,700
$
671,400
68,000
$
68,000
$
84,700 $
36,300 $
121,000
$
51,200
436,200
$
685,900
$
639,500
$
601,200 $
85,000 $
791,800 $
36,300 $
4,924,800
$ 235,700 $ 235,700,
$ 111,900 $ 159,900 $ 271,800
$ 744,600 $ 817,400 $ 657,500 $ 620,800 $ 582,800 $ 86,500 $ 3,509.600
Tota12005 $ 856,500 $ 817,400 $ 235,700 $ 657,500 $ 620,800 $ 582,800 $ 86,500 $ 159,900 $ 4,017,100
2006
Garden City Park
Sheller bldg
$
92,200
Kylawn Park
Shelter bldg, trails and lights
$
194,700
Riverdale Park
Sheller bldg
$
35,900
Dupont Avenue Improvement Project
Street improvement project
$
391,800
$
116,800
$
110,200
$
27,500
$
275,400
Humboldt Avenue Improvement Project
Street improvement project
$
205,000
$
102,500
$
51,200
$
410,000
Tangletown Improvement Project North
Neighborhood street project
$
502,200
$
684,700
$
456,900
$
431,400
$
408,600
$
60,800
Lift Station #9
Pump and forcemain replacements
$
205,000
Lift Station #2
Pump, FM, and Interceptor replacem
ents
$
307,400
Total 2006 $ 1,099,000
$
684,700
$
322,800
$
676,200
$ 1,105,200
$
436,100
$
60,800
$
685,400
2007
West Palmer Lake Park
Shelter bldg
$
102,500
Riverwood Improvement Project
Street improvement project
$
597,900
$
757,900
$
-
$
581,300
$
548,900
$
581,900
$
75,100
Freeway Blvd Improvement Project
Street improvement project
$
307,400
$
20,500
$
51,200
$
20,500
$
409,900
Total 2007 $
905,300
$
757,900
$
102,500
$
601,800
$
600,100
$
602,400
$
75,100
$
409,900
2008
East River Improv Project
Street improvement project
$
509,800
$
525,900
$
276,400
$
453,100
$
402,900
$
56,200
$
113,000
Maranatha lmprov Project
Neighborhood street project
$
701,000
$
840,500
$
394,800
$
612,400
$
564,500
$
89,000
Northway Drive Improv Project
Street improvement project
$
123,000
$
8,200
$
8,200
$
7,200
Kylawn Park
Shelterbkig, lighting, and rink improvements
$
200,000
Xerxes Avenue Improv Project
Street improvement project
$
236,700
$
10,300
$
10,300
$
10,300
$
338,200
Total 2008 $ 1,570,500
$
1,366,400
$
200,000
$
689,700
$ 1,084,000
$
984,900
$
145,200
$
451,200
$ 92,200
$ 194,700
$ 35,900
$ 921,700
$ 768,700
$ 2,544,600
$ 205,000
$ 307,400
$ 5,070,200
$ 102,500
$ 3,143,000
$ 809,500
$ 4,055,000
$ 2,337,300
$ 3,202,200
$ 146,600
$ 200,000
$ 605,800
$ 6,491,900
9
C)
O
z
z
0
N
O
Q
W
I
N
O
00
.rA„
RESOLUTION NO. 2003-208
Project Year 2004
Grandview Park
Construction activities will include the installation of lighting systems for a combined football/soccer
field, a lighting system for the baseball field, and installation of an off-street trail section with lights.
These improvements will complete the planned site improvements constructed in cooperation with ISD
286.
Northport Improvement Project
This area has been identified as having multiple needs including street reconstruction, installation of curb
and gutter, replacement of aging water and sanitary sewer infrastructure and construction of storm
drainage improvements as needed.
Shingle Creek Parkway
Shingle Creek Parkway from I-694 to CR 10 is an MSA roadway that has been placed in the CIP for
reconstruction in 2004. This section of roadway is in need of upgrade and reconstruction based on an
engineering evaluation of the roadway. Construction activities will include replacement of the existing
pavement and concrete curb and replacement of gutters and utilities on an as needed basis.
Evergreen Park
This improvement will include an addition to the existing sidewalk system. The new sidewalk section
would run along the eastern boundary of the park adjacent to Camden Avenue, and would run from 70th to
72nd Avenue.
73rd Avenue Improvement Project
Construction activity on this project, which will be funded jointly with the City of Brooklyn Park, will
include street replacement, addition of curb and gutter and replacement of water and sanitary sewer as
necessary. The section of roadway to be improved runs from Humboldt Avenue on the east to Palmer
Lake and Penn Avenue North to the west.
Fiber Optic Connection
LOGIS has begun a 5-year project to work with member Cities to create a fiber infrastructure that will
manage the increasing demands for bandwidth on the City's internal and external applications, phone,
communication and video systems. Under current technology parameters, it is anticipated that fiber would
be a twenty-year plus solution. Brooklyn Center's link to LOGIS would be from Robbinsdale Public
Works building to Brooklyn Center City Hall. The cost for this link would be $98,000. Because LOGIS
and Hennepin County Library would benefit from this fiber infrastructure, the costs would be shared. The
cost to the City would $68,000.
Freeway Blvd Bridge Repairs
Substantial deterioration of the bridge deck has been noted during recent inspections. An engineering
analysis performed in 2003 identified the extent of repairs necessary to rehabilitate the bridge. The City is
in the process of applying for funding assistance from Mn/DOT.
RESOLUTION NO. 2003-208
Project Year 2005
Central Park
This improvement provides for the replacement of the existing softball field lighting systems.
Construction activity may be reduced if the light poles can be reused in the new system.
Earle Brown/Summit Improvement Project
This project includes improvements for Earle Brown Drive from Earle Brown Farm West to Summit
Drive and Summit Drive, an MSA street, from Shingle Creek Parkway to TH 100. Construction activities
will include complete pavement replacement, spot replacement of curb and gutter, and replacement of
water and sewer infrastructure as needed.
Tangletown Improvement Project-South
This area has been identified as having multiple needs including street reconstruction, installation of curb
and gutter, replacement of aging water and sanitary sewer infrastructure and construction of storm
drainage improvements as needed.
1
RESOLUTION NO. 2003-208
Project Year 2006
Garden City Park
Construction activity will include replacement of the existing shelter building with a new structure that
includes electric service, bathrooms and picnic facilities.
Kylawn Park
Construction activities will include the replacement of the existing shelter building with a new structure
that includes heat, electric service, bathrooms and picnic facilities, replacement of rink and trail lighting
systems and the overlay of existing trail segments. The new shelter building will be consistent with other
destination park facilities, and will be used as a warming house during the skating season.
Riverdale Park
Construction activity will include the replacement of the existing shelter building with a picnic shelter.
Dupont Avenue Improvement Project
Dupont Avenue improvements from I-694 to 69th Avenue North are part of the CIP as a project for 2006.
This MSA project includes replacement of curb and gutter, reconstruction of the roadway and replacement
of water and sewer infrastructure as needed.
Humboldt Avenue Improvement Project
Improvements on Humboldt Avenue from 67th Avenue North to 69th Avenue North have been included as
part of the CIP for 2006. Construction of this MSA project will include replacement of curb and gutter,
reconstruction of the roadway and replacement of water and sewer infrastructure as needed.
Tangletown Improvement Project-North
This area has been identified as having multiple needs including street reconstruction, installation of curb
and gutter, replacement of aging water and sanitary sewer infrastructure and construction of storm
drainage improvements as needed.
Lift Stations #9 and #2
These projects provide for pump replacement and replacement of the forcemain at Lift Stations #9 and #2
to ensure optimal performance and minimize the potential for system failure.
RESOLUTION NO. 2003-208
Project Year 2007
West Palmer Lake Park
Planned improvements include the replacement of the existing shelter building with a new structure that
includes heat, electric service, bathrooms and picnic facilities. This new shelter will be consistent with
other destination park facilities.
Riverwood Improvement Project
This is a neighborhood street improvement project that will include reconstruction of roads, installation of
curb and gutter and replacement of water and sewer utilities services as necessary.
Freeway Boulevard Project
Freeway Blvd is an MSA roadway that has been placed in the CIP as an identification item. The segment
of Freeway Boulevard that runs from Shingle Creek Parkway to Camden will be improved with
replacement of curb and gutter, reconstruction of the roadway and replacement of water and sewer
infrastructure as needed.
1
RESOLUTION NO. 20008
Project Year 2008
Kylawn Park
Planned improvements include the replacement of the existing shelter building with a new structure,
construction of new recreational facilities and installation of trail lighting.
East River Improvement Project
This is a neighborhood street improvement project that will include reconstruction of roads, installation of
curb and gutter and replacement of water and sewer utilities services as necessary.
Maranatha Improvement Project
This is a neighborhood street improvement project that will include reconstruction of roads, installation of
curb and gutter and replacement of water and sewer utilities services as necessary.
Northway Drive Improvement Project
This segment will be improved with replacement of curb and gutter, reconstruction of the roadway and
replacement of water and sewer infrastructure as needed.
Xerxes Avenue Improvement Project
Xerxes Avenue is an MSA roadway that has been placed in the CIP for scheduled reconstruction. The
segment that runs from Northway Drive to T.H. 100 will be improved with replacement of curb and
gutter, reconstruction of the roadway and replacement of water and sewer infrastructure as needed.
1
RESOLUTION NO. 2003-208
1
a ss » ss -cs ~ ~ sc sc ,s
34
IOCAISTFEET g
i
`
+ '1
TltC
~
353.
~1'
3C
ly~~r i;~,~
55
3
i~'
7
4
k
r < T ! to ~
yA~k«j'
ftcistchhh113yI1L4 ! I III*I
Year of Street Reconstruction
- - - Under Construction
Completed
2003
2004
'........._-a 20'0±~/
-,---,---,2005
2006
2007 Under Study
10102
X1'?BR Of City of Brooklyn Center
xLYN
Neighborhood Street Improvement Program
RESOLUTION NO. 2003-208
CAPITAL IMPROVEMENT PROGRAM 2004-2008
APPENDIX
1
RESOLUTION NO. 2003-208
Water Utility Fund
Revenues
Water Service
Misc. Operating
Misc. Non-operating
Total Revenues
Expenditures
Rate Analysis
2003 2004 2005 2006 2007 2008
$
1,262,500
$
1,297,500
$
1,333,800
$
1,371,200
$
1,409,600
$
1,449,100
$
225,100
$
228,800
$
234,500
$
238,200
$
241,900
$
245,600
$
30,000
$
10,000
$
10,000
$
10,000
$
10,000
$
10,000
$
1,517,600
$
1,536,300
$
1,578,300
$
1,619,400
$
1,661,500
$
1,704,700
Personal Services
$
328,477
$
352,318
$
369,934
$
388,431
$
407,852
$
428,245
Supplies
$
159,050
$
170,250
$
175,358
$
180,618
$
186,037
$
191,618
Services
$
425,555
$
438,322
$
451,471
$
465,015
$
478,966
$
493,335
Depreciation
$
588,100
$
578,000
$
610,000
$
630,000
$
650,000
$
670,000
Debt Service
$
0
$
$
$
$
$
Total Expenditures
$
1,501,182
$
1,538,890
$
1,606,763
$
1,664,064
$
1,722,855
$
1,783,197
Capital Outlay
$
667,550
$
685,900
$
673,938
$
710,433
$
648,073
$
761,300
Total Cash Requirement
$
2,168,732
$
2,224,790
$
2,280,700
$
2,374,497
$
2,370,928
$
2,544,497
Cash Reserve Target $ 11000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000
Beginning Cash Balance $ 1,541,308 $ 1,478,276 $ 1,367,786 $ 1,275,386 $ 1,150,289 $ 1,090,862
Revenues
$
1,517,600
$ 1,536,300
$
1,578,300
$
1,619,400
$
1,661,500
$
1,704,700
Expenditures
$
(2,168,732)
$ (2,224,790)
$
(2,280,700)
$
(2,374,497)
$
(2,370,928)
$
(2,544,497)
Depreciation Add-Back
$
588,100
$ 578,000
$
610,000
$
630,000
$
650,000
$
670,000
Ending Cash Balance
Additional sums necessary
$
1,478,276
$ 1,367,786
$
1,275,386
$
1,150,289
$
1,090,862
$
$
921,064
78,936
to meet Cash Reserve Target
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation.
Revenues
Rate increases would be 2.8% per year across the board and are based on 1.25 billion gallons billed per year.
Expenditures
Supplies and Services increase at a total rate of 3% annum.
Depreciation increases at a rate of approximately 3% per annum.
Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
Revised 11-12-03
RESOLUTION NO. 2003-208
Sewer Utility Fund
Revenues
Sewer Charges
Misc. Operating
Misc. Non-operating
Total Revenues
Expenditures
Personal Services
Supplies
Services
Depreciation
Debt Service
Total Expenditures
Capital Outlay
Total Cash Requirement
Cash Reserve Target
Beginning Cash Balance
Revenues
Expenditures
Depreciation Add-Back
Ending Cash Balance
Additional sums necessary
to meet Cash Reserve Target
Rate Analysis
2003 2004 2005 2006 2007 2008
$ 2,725,380 $ 2,801,700 $ 2,880,100 $ 2,960,800 $ 3,043,700 $ 3,128,900
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
$ 30,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000
$ 2,755,380 $ 2,811,700 $ 2,890,100 $ 2,970,800 $ 3,053,700 $ 3,138,900
$
120,263
$
148,142
$
155,549
$
163,327
$
171,493
$
180,068
$
20,100
$
17,315
$
17,834
$
18,369
$
18,921
$
19,488
$
1,865,647
$
1,742,398
$
1,794,670
$
1,848,510
$
1,903,965
$
1,961,084
$
432,100
$
458,000
$
470,000
$
485,000
$
500,000
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
2,438,110
$
2,365,855
$
2,438,053
$
2,515,206
$
2,594,379
$
2,160,640
$ 633,390 $ 639,500 $ 636,320 $ 1,161,151 $ 646,242 $ 1,196,533
$ 3,071,500 $ 3,005,355 $ 3,074,373 $ 3,676,357 $ 3,240,621 $ 3,357,173
$
950,000
$
950,000
$
950,000
$
950,000
$
950,000
$
950,000
$
682,184
$
798,164
$
1,062,509
$
1,348,236
$
1,127,679
$
1,440,758
$
2,755,380
$
2,811,700
$
2,890,100
$
2,970,800
$
3,053,700
$
3,138,900
$ (3,071,500)
$
(3,005,355)
$ (3,074,373)
$
(3,676,357)
$
(3,240,621)
$
(3,357,173)
$
432,100
$
458,000
$
470,000
$
485,000
$
500,000
$
0
$
798,164
$
1,062,509
$
1,348,236
$
1,127,679
$
1,440,758
$
1,222,485
$ 151,836
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation.
Revenues
Rate increases would be 2.8% per year across the board and are based on 1.323 billion gallons billed per year.
Expenditures
Supplies and Services increase at a total rate of 3% annum.
Depreciation increases at a rate of approximately 3% per annum.
Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
Revised 11-12-03
RESOLUTION NO
Storm Sewer Utility Fund
evenues
torm Sewer Fees
Misc. Operating
Misc. Non-operating
Total Revenues
Expenditures
Personal Services
Supplies
Services
Depreciation
Debt Service
Total Expenditures
2003-208
Rate Analysis
2003
2004
2005
2006
2007
2008
$
1,235,000
$
1,235,000
$
1,235,000
$
1,235,000
$
1,235,000
$
1,235,000
$
0'
$
0
$
0
$
0
$
0
$
0
$
10,000
$
10,000
$
10,000
$
10,000
$
10,000
$
10,000
$
1,245,000
$
1,245,000
$
1,245,000
$
1,245,000
$
1,245,000
$
1,245,000
$
0
$
18,898
$
19,843
$
20,835
$
21,877
$
22,971
$
20,500
$
20,900
$
21,527
$
22,173
$
22,838
$
23,523
$
236,848
$
83,013
$
85,503
$
88,068
$
90,711
$
93,432
$
326,600
$
514,000
$
523,000
$
532,000
$
541,000
$
550,000
$
239,540
$
238,250
$
236,210
$
0
$
0
$
0
$
823,488
$
875,061
$
886,083
$
663,076
$
676,425
$
689,926
Capital Outlay $ 410,785 $ 601,200 $ 597,370 $ 458,178 $ 648,719 $ 1,087,145
Total Cash Requirement $ 1,234,273 $ 1,476,261 $ 1,483,453 $ 1,121,254 $ 1,325,144 $ 1,777,071
Cash Reserve Target
$
540,000
$
540,000
$
540,000
$
540,000
$
540,000
$
540,000
Beginning Cash Balance
$
343,221
$
680,548
$
963,287
$
1,247,834
$
1,903,580
$
2,364,436
Revenues
$
1,245,000
$
1,245,000
$
1,245,000
$
1,245,000
$
1,245,000
$
1,245,000
Expenditures
$ (1,234,273)
$
(1,476,261)
$
(1,483,453)
$
(1,121,254)
$
(1,325,144)
$
(1,777,071)
Depreciation Add-Back
$
326,600
$
514,000
$
523,000
$
532,000
$
541,000
$
550,000
nding Cash Balance
F
$
680,548
$
963,287
$
1,247,834
$
1,903,580
$
2,364,436
$
2,382,365
dditional sums necessary
none
none
none
none
none
none
to meet Cash Reserve Target
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation.
Revenues
Rate increase: Assumed 0% for 2004. Expenditures will be re-evaluated for 2005 budget.
Expenditures
Supplies and Services increase at a total rate of 3% annum.
Depreciation increases at a rate of approximately 3% per annum.
Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
This analysis does not include future maintenance costs associated with new NPDES Phase II requirements from EPA
NPDES Phase II costs will be developed and incorporated into 2005 Rate Analysis
Revised 11-13-03
RESOLUTION NO. 2003-208
Street Light Utility Fund
Revenues
Street Light Fee
Misc. Operating
Misc. Non-operating
Total Revenues
Expenditures
Personal Services
Supplies
Services
Depreciation
Debt Service
Total Expenditures
Capital Outlay
Total Cash Requirement
Cash Reserve Target
Beginning Cash Balance
Revenues
Expenditures
Depreciation Add-Back
Ending Cash Balance
Additional sums necessary
to meet Cash Reserve Target
Rate Analysis
2003
2004
2005
2006
2007
2008
$
205,575
$
211,700
$
218,100
$
224,600
$
231,400
$
238,300
$
0
$
0
$
0
$
0
$
0
$
0
$
10,000
$
10,000
$
10,000
$
10,000
$
10,000
$
10,000
$
215,575
$
221,700
$
228,100
$
234,600
$
241,400
$
248,300
$
0
$
0
$
0
$
0
$
0
$
0
$
2,500
$
2,900
$
2,987
$
3,077
$
3,169
$
3,264
$
145,000
$
156,193
$
160,879
$
165,705
$
170,676
$
175,797
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
147,500
$
159,093
$
163,866
$
168,782
$
173,845
$
179,061
$
51,090
$
85,000
$
88,663
$
63,878
$
80,874
$
160,274
$
198,590
$
244,093
$
252,528
$
232,660
$
254,720
$
339,334
$ 50,000 $
50,000 $ 50,000 $ 50,000 $
50,000 $ 50,000
$
30,361
$
$
215,575
$
$
(198,590)
$
$
0
$
$
47,346
$
2,654
47,346
$
24,953
$
525
$
221,700
$
228,100
$
234,600
$
(244,093)
$
(252,528)
$
(232,660)
$
0
$
0
$
0
$
24,953
$
525
$
2,465
$
2,465 $ (10,855)
241,400 $ 248,300
(254,720) $ (339,334)
0 $ 0
-10,855 $ -101,889
25,047 $ 49,475 $ 47,535 $ 60,855 $ 151,889
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation.
Revenues
Rate increases would be 3.0% per year across the board based on customer base of 8,415 residential customers and
538 others. All other revenues would remain flat over the five year period.
Expenditures
Supplies and Services increase at a total rate of 3% annum.
Depreciation increases at a rate of approximately 3% per annum.
Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
Based on this analysis, a portion of the annual reconstruction project street light costs will need to be funded from other sources
Revised 11-13-03
RESOLUTION NO. 2003-208
1
Street Construction Fund
Revenues
Fund Transfer
Misc. Operating
Misc. Non-operating
Total Revenues
Expenditures
Personal Services
Supplies
Services
Depreciation
Debt Service
Total Expenditures
Capital Outlay
Total Cash Requirement
Beginning Cash Balance
Revenues"
Expenditures
Depreciation Add-Back
Ending Cash Balance
2003
2004
2005
2006
2007
2008
$
1,300,000
$
650,000
$
668,200
$
686,910
$
706,143
$
725,915
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
5,000
$
5,000
$
5,000
$
5,000
$
5,000
$
1,300,000
$
655,000
$
673,200
$
691,910
$
711,143
$
730,915
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
696,400
$
837,835
$
719,363
$
816,175
$
1,508,250
$
0
$
696,400
$
837,835
$
719,363
$
816,175
$
1,508,250
$
0
$
1,300,000
$
1,258,600
$
1,093,965
$
1,066,512
$
961,479
$
1,300,000
$
655,000
$
673,200
$
691,910
$
711,143
$
730,915
$
0
$
(696,400)
$
(837,835)
$
(719,363)
$
(816,175)
$
(1,508,250)
$
0
$
0
$
0
$
0
$
0
$
0
$
1,300,000
$
1,258,600
$
1,093,965
$
1,066,512
$
961,479
$
184,144
none
none
none
none
none
$
#REF!
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation.
Revenues
'2003 revenue represents transfers from Infratructure Construction Fund as part of the fund creation.
Expenditures
Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
Additional sums necessary
to meet Cash Reserve Target
Revised 11-13-03
RESOLUTION NO. 2003-208
Capital Projects Fund
2003
2004
2005
2006
2007
2008
Revenues
Transfer in General Fund
$
125,000
$
125,000
$
125,000
$
125,000
$
125,000
$
125,000
Transfer in Liquor Fund
$
100,000
$
100,000
$
100,000
$
100,000
$
100,000
$
100,000
Debt Payment Golf Course
$
15,000
$
35,000
$
50,000
$
55,000
$
55,000
$
55,000
Misc Revenue
9,500
9,000
12,000
11,500
18,000
15,000
Total Revenues
$
249,500
$
269,000
$
287,000
$
291,500
$
298,000
$
295,000
Expenditures
Personal Services
$
0
$
0
$
0
$
0
$
0
$
0
Supplies
$
0
$
0
$
0
$
0
$
0
$
0
Services
$
0
$
0
$
0
$
0
$
0
$
0
Depreciation
$
0
$
0
$
0
$
0
$
0
$
0
Debt Service
$
0
$
0
$
0
$
0
$
0
$
0
Total Expenditures
$
0
$
0
$
0
$
0
$
0
$
0
Capital Outlay
$
225,000
$
436,200
$
241,593
$
339,142
$
110,381
$
220,763
Total Cash Requirement
$
225,000
$
436,200
$
241,593
$
339,142
$
110,381
$
220,763
Beginning Cash Balance
$
443,492
$
467,992
$
300,792
$
346,200
$
298,558
$
486,176
Revenues
$
249,500
$
269,000
$
287,000
$
291,500
$
298,000
$
295,000
Expenditures
$
(225,000)
$
(436,200)
$
(241,593)
$
(339,142)
$
(110,381)
$
(220,763)
Depreciation Add-Back
$
0
$
0
$
0
$
0
$
0
$
0
Ending Cash Balance
$
467,992
$
300,792
$
346,200
$
298,558
$
486,176
$
560,414
Assumptions:
Expenditures
Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
Revised 11-13-03