HomeMy WebLinkAbout2004-174 CCRMember Kay Lasman introduced the following resolution and moved its
adoption:
RESOLUTION NO. 2004-174
RESOLUTION ADOPTING CAPITAL IMPROVEMENT PROGRAM
WHEREAS, the City Council of the City of Brooklyn Center annually adopts a five
year Capital Improvements Program; and
WHEREAS, the City Council has conducted a public hearing on the proposed
2005-2009 Capital Improvements Program; and
WHEREAS, attached hereto and incorporated herein by reference as Exhibit A is
the documentation for the said 2005-2009 Capital Improvements Program.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of
Brooklyn Center that the 2005-2009 Capital Improvements Program as set forth in Exhibit A to this
resolution be and hereby is adopted.
December 11, 2004 I%r a
T~te Mayor
ATTEST: W ✓vw~
City Clerk
The motion for the adoption of the foregoing resolution was duly seconded by member
Kathleen Carmody
and upon vote being taken thereon, the following voted in favor thereof:
Myrna Kragness, Kathleen Carmody, 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. 2004-174 EXHIBIT A
City of Broo Center
2005-2009 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 the City's goals for maintaining public infrastructure. 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 2005-2009 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.
CIP 2005-2009 OVERVIEW
The 2005-2009 CIP proposes capital expenditures totaling $27 million for basic improvements to the
City's streets, parks, 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 2005-2009.
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 portion 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.
RESOLUTION NO. 2004-174
EXHIBIT A
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 often
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
Storm Drainage Utility Capital Projects
Street Lighting Utility Capital Projects
1
SUBTOTAL
1PARKIMPROVEMENTS
I PUBLIC BUILDINGS
STREET IMPROVEMENTS
1TOTAL
2005 I
2006
2007 ,
2008 I
2009
$777,000
$723,600
$643,900
$737,900
$820,100
$705,800
$1,184,600
$642,100
$4,159,900
$769,800
$698,500 $466,600 $644,500 $1,053,800 $776,900
$53,500 $65,000 $80,400 $155,300 $75,000
$2,234,800 $2,439,800 $2,010,900 $3,106,900 $2,441,8001
$228,0001 $450,0001 $180,0001 $200,0001 $115,00011
$01 $01 $01 $01 $01
$2,882,0001 $3,299,6001 $2,218,3001 $3,625,3001 $1,889,900 1
$5,344,8001 $6,189,4001 $4,409,2001 $6,932,2001 $4,446,700
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 basic 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 is provided with each public utility budget
section and a five-year cash flow projection 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.
RESOLUTION NO. 2004-174
EXHIBIT A
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. Since 2003, all
funding required to finance neighborhood street projects is transferred to this fund and all costs associated
with these projects are 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 approximately
$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
TABLE 2 - Capital Improvement Program
Summary by Funding Source
Water Utility
Sanitary Sewer Utility
Storm Drainage Utility
Street Lighting Utility
Municipal State Aid
Street Construction Fund
Capital Projects Fund
Special Assessment Collections
Grants
TOTAL
2005 ( 2006 I 2007 I 2008 2009 I TOTAL
$777,000 $723,600 $643,900 $737,900 $820,100 $3,702,500
$705,800 $1,184,600 $642,100 $1,159,900 $769,800 $4,462,200
$698,500 $466,600 $644,500 $1,053,800 $776,900 $3,640,300
$53,500 $65,000 $80,400 $155,300 $75,000 $429,200
$705,000 $1,193,700 $438,600 $482,800 $53,000 $2,873,100
$1,089,700 $732,600 $811,000 $1,462,000 $1,052,300 $5,147,600
$228,000 $450,000 $180,000 $200,000 $115,000 $1,173,000
$1,052,300 $1,373,300 $968,700 $1,680,500 $784,600 $5,859,400
$35,000 $0 $0 $0 $0 $35,000
$5,344,8001 $6,189,4001 $4,409,2001 $6,932,2001 $4,446,7001 $27,322,300
Capital Improvement Program by Funding Source
Capital
Proj. Fund
4%
Strew, Const.
Fund
19%
Municipal Street
State Aid Light
11% utility
2%
Sanitary
Sewer
16%
titorm
Sewer
13%
Table 3 provides an overview of projects and funding sources for the 2005-2009 CIP. Annual breakdowns
for each project year are accompanied by a brief description of each project.
Special Water
Assessements 14%
21%
TABLE 3 - CAPITAL IMPROVE
MENT PROGRAM
2005-2009
CA
Revised 09-29-04
C)
r
Funding
Project
Description
Sources
Special
Street Construction
Capital Projects
Water Utility
Sewer Utility
Storm Sewer
Street Light
MSA
Grants Total Project CoilZ
Assessment
Fund
Fund
Utility
utility
~e o4
Collections
2005
Shingle Creek Parkway/ Summit Drive
Street improvement project
$
260,000
$
18,500
$
15,000
$
21,900
$
606,500
$
921, go"
Central Park Lighting
Repairs to existing field lighting
$ 108,000
$
108,
Twin Lake Avenue Reconstruction
Street improvement project
$
87,600
$
124,000
$
55,000
$
26,500
$
53,000
$
346,1
Palmer Lake Trail Reconstruction
Reconstruction of existing paved trail
$ 120,000
$
120,00
Freeway Blvd Bridge Repairs
Repairs to Bridge Deck and Superstructure
$
98,500
$ 35,000 $
133,50t r-
Lions Park South Improvement Project
Street improvement project
$
704.700
$
965.700
$
703.500
$
664.300
$
623.600
$
53.500
$
3.715,30(
Tota12405 $
1,052,300
$
1,089,700
$ 228,000
$
777,000
$
705,800
$
698,500
$
53,500
$
705,000
$ 35,000 $
5,344,800
2005
Dupont Avenue Improvement Project
Street improvement project
$
419,200
$
125,000
$
117,900
$
29,400
$
294,700
$
986,200
Humboldt Avenue Improvement Project
Street improvement project
$
219,400
$
109,700
$
56,800
$
438,700
$
824,600'
Lions Park North improvement Project
Neighborhood street project
$
537,400
$
732,600
$
488,900
$
461,600
$
437,200
$
65,000
$
2,722,700
Earle Brown Dr / South Shingle Ck Pkway
Street improvement project
$
197,300
$
460,300
$
657,600
Lift Station #9
Pump and forcemain replacements
$
219,400
$
• - ' 219,400
Lilt Station #2
Pump, FM, and Interceptor replacements
$
328,900
$
328,900
Central Storage Facility Building
Sall storage / park storage replacement
$ 450.000
$
450,000 .
Total 2006 $
1,373,300
$
732,600
$ 450,000
$
723,600
$
1,184,600
$
466,600
$
65,000
$ 1
,193,700
$
6,189,400
2007
Kylawn Park Building
Shelter building replacement
$ 180,000
$
180,000
Riverwood Improvement Project
Street Improvement project
$
639,800
$
811,000
$
622,000
$
587,300
$
622,600
$
80,400
$
3,363,100
Freeway Blvd Improvenrent Project
Street Irn, ant project
$
328.900
$
21.900
S
54.800
$
21.900
$
438.600
$
866.100 .
Total 2007 $
968,700
$
811,000
$ 160,000
$
643,900
$
642,100
$
644,500
$
80,400
$
438,600
$
4,409,200
2008
East River Improvement Project
Street improvement project
$
545,500
$
562,700
$
295,700
$
484,800
$
431,100
$
60,100
$
120,900
$
2,500,800
Maranatha Improvement Project
Neighborhood street project
$
750,100
$
899,300
$
422,400
$
655,300
$
604,000
$
95,200
$
3,426,300
Northway Drive knprov Project
Street improvement project
$
131,600
$
8,800
$
8,800
$
7,700
$
156,900
West Palmer Park Building
Shelter Building Replacement
$ 200,000
$
200,000 .
Xeres Avenue Improv Project
Street improvement project
$
253.300
$
11,000
$
11.000
$
11.000
$
361.900
$
648,200
Total 2008 $
1,680,500
$
1,462,000
$ 200,000
$
737,900
$
1,159,900
$
1,053,800
$
155,300
$
482,800
$
6,932,200.
2009 .
Twin Lake East Improvement Project
Neighborhood street project
$
784,600
$
1,052,300
$
820,100
$
769,800
$
776,900
$
75,000
$
53,000
$
4,331,700:
Northport Park Building
Shelter biding replacement
$ 75,000
$
75,000
Riverdale Park Building
Remove building and construct picnic
shelter
$ 40,000
$
40.000.
Total 2009 $
784,600
$
1,052,300
$ 115,000
$
820,100
$
769,800
$
776,900
$
75,000
$
53,000
$
4,446,700
H
RESOLUTION NO. 2004-174
EXHIBIT A
Project Year 2005
Shingle Creek Parkway/Summit Drive Improvement Project
Shingle Creek Parkway from I-694 to John Martin Drive and Summit Drive from Shingle Creek Parkway
to State Trunk Highway 100 are MSA roadways that have been placed in the CIP for reconstruction in
2005. Portions of these sections of roadway are in need of upgrade and reconstruction based on an
engineering evaluation of the roadway. Construction activities will include replacement of the existing
pavement and replacement of gutters and utilities on an as needed basis.
Lions Park South (Tangletown South) 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.
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.
Twin Lake Avenue Reconstruction
Twin Lake Avenue was originally scheduled for reconstruction with the southwest neighborhood project
in 2002. Reconstruction of Twin Lake Avenue was delayed due to environmental permit requirements
associated with the Joslyn site. Reconstruction of this street segment will include replacement of
watermain, and installation of curb & gutter, storm sewer and bituminous pavement.
Central Park Lighting
This improvement provides for the refurbishment and basic maintenance of the existing softball field
lighting systems. A master electrician will perform a comprehensive system review to determine the
extent of necessary repair work. Construction activity may be reduced if the existing light poles are in
stable condition.
Palmer Lake Trail Reconstruction
This improvement provides for the basic reconstruction of the mainline trail segment along the southern
half of Palmer Lake. Reconstruction will include the consolidation of parallel trail segments into one 10-ft
wide trail segment and minor grade adjustments for portions of the trail in severe flood-susceptible areas.
Trail segments in good condition within East Palmer Lake Park and the trail segment to the west of the
ball fields within East Palmer Lake Park will not be replaced with this project.
Evergreen Sidewalk Improvements
The Capital Improvements Program in previous years has included the installation of sidewalk along the
east side of Evergreen Park. This project has been delayed due to limited funding available in the Capital
Projects fund and the need to prioritize the maintenance of existing infrastructure. The feasibility of this
sidewalk addition will be re-evaluated in future years and funding becomes available.
RESOLUTION NO. 2004-174
Project Year 2006
EXHIBIT A
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.
Dupont Avenue Improvement Project
Dupont Avenue improvements from I-694 to 69`x' 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 67 h Avenue North to 69`h 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.
Lions Park North (Tangletown North) 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.
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.
Central Storage Facility
Improvements will include the erection of a new salt storage facility. This new facility will be constructed
of low-rise precast concrete panels to match the existing Public Works facility campus and the
surrounding commercial buildings. The existing salt storage building will become centralized storage
facility for park maintenance and park program equipment. Heavy-duty shelving will be installed to allow
for palletized storage. Construction activities will also include the construction of a small materials
storage area on city owned property on Camden Avenue. The new facility will include paving of the
surface area and fencing of the surrounding area. This area will be used to store aggregate, wood chips
and other stockpiled materials.
RESOLUTION NO. 2004-174
Project Year 2007
EXHIBIT A
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.
Kylawn Park Building
Construction activities will include the replacement of the existing shelter building. The new structure
will include picnic facilities, a unisex bathroom and a small storage/utility area. This new shelter will be
consistent with other destination park facilities.
1
RESOLUTION NO. 2004-174
Project Year 2008
EXHIBIT A
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.
West Palmer Park Building
Construction activities will include the replacement of the existing shelter building. The new structure
will include picnic facilities, a unisex bathroom and a small storage/utility area. This new shelter will be
consistent with other destination park facilities.
RESOLUTION NO. 2004-174 EXHIBIT A
Project Year 2009
Twin Lake East 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. This project is also
tentatively scheduled to include reconstruction of 5l't Avenue North at Brooklyn Boulevard.
Northport Park Building
Construction activities will include the replacement of the existing shelter building. The new structure
will include picnic facilities and some limited storage space and an integrated enclosure for a portable
restroom.
Riverdale Park Building
Construction activities will include the replacement of the existing shelter building with a picnic shelter.
1
RESOLUTION NO. 2004-174
I I
LVVJ
EXHIBIT A
2006
Miles % of Total
2007-
Completed to Date
54 50.5
2005 - 2010
26 24.3
2008
Under
2011-2018
27 25.2
2009
Stud
y
Totals
107 100.0
2010-
BROOXLYN
City
cmvm
of Brooklyn
Center
MA
i
r..q.crws
1
Neighborhood Improvement Program
RESOLUTION NO. 2004-174 EXHIBIT A
CAPITAL IMPROVEMENT PROGRAM 2005-2009
APPENDIX
1
RESOLUTION NO. 2004-174
City of Brooklyn Center
Water Utility Fund Rate Analysis
for the 2005 Budget Year
Rate Increase 2.80%
Revenues
Water Service
Misc. Operating
Misc. Non-operating
Total Revenues
Expenditures
Personal Services
Supplies
Services
Depreciation
Debt Service Interest & Fees
Total Expenditures
less: Non-Cash Depreciation
plus: Debt Service Principal
plus: Cash Capital Outlay
Total Cash Requirement
Cash Reserve Target
Beginning Cash Balance
Cash Received
Cash Spent
Ending Cash Balance
Cash above/(below) the
Cash Reserve Target
EXHIBIT A
3.00% 3.00% 3.00% 3.00%
Actual
Projected
Proposed
Projected
Projected
Projected
Projected
2003
2004
2005
2006
2007
2008
2009
$
1,332,093
$
1,222,712
$
1,256,948
$
1,294,656
$
1,333,496
$
1,373,501
$
1,414,706
$
198,465
$
228,800
$
273,410
$
238,200
$
241,900
$
245,600
$
249,300
$
46,751
$
10,000
$
5,000
$
10,000
$
10,000
$
10,000
$
10,000
$
1,577,309
$
1,461,512
$
1,535,358
$
1,542,856
$
1,585,396
$
1,629,101
$
1,674,006
$
349,556
$
352,318
$
379,748
$
394,938
$
410,735
$
427,165
$
444,251
$
116,272
$
170,250
$
169,490
$
174,575
$
179,812
$
185,206
$
190,762
$
402,865
$
359,795
$
512,749
$
528,131
$
543,975
$
560,295
$
577,104
$
648,115
$
578,000
$
610,000
$
630,000
$
650,000
$
670,000
$
670,000
$
3
$
$
$
$
$
$
$
1,516,811
$
1,460,363
$
1,671,987
$
1,727,644
$
1,784,523
$
1,842,666
$
1,882,117
$
648,115
$
578,000
$
610,000
$
630,000
$
650,000
$
670,000
$
670,000
$
0
$
0
$
0
$
0
$
0
$
0
$
0
$
430,824
$
685.900
$
835.500
$
723,600
$
643,900
$
737,900
$
820,100
$
1,299,520
$
1,568.263
$
1,897,487
$
1,821,244
$
1,778,423
$
1,910,566
$
2,032,217
$
1,000,000
$
1,000,000
$
1,000,000
$
1,000,000
$
1,000,000
$
1,000,000
$
1,000,000
$
1,541,308
$
1,890,755
$
1,784,004
$
1,421,875
$
1,143,487
$
950,460
$
668,996
$
1,577,309
$
1,461,512
$
1,535,358
$
1,542,856
$
1,585,396
$
1,629,101
$
1,674,006
$
(1,299,520)
$
(1,568,263)
$
(1,897,487)
$
(1,821,244)
$
(1,778,423)
$
(1,910,566)
$
(2,032,217)
$
1,819,097
$
1,784,004
$
1,421,875
$
1,143,487
$
950,460
$
668,996
$
310,784
$
819,097
$
784,004
$
421,875
$
143,487
$
(49,540)
$
(331,004)
$
(689,216)
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items
from year to year that may affect cash balances.
Revenues
Rate increases would be 2.8% in 2005 and 3.0% each year through 2009 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 2005 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
1
RESOLUTION NO. 2004-174
City to Brooklyn Center
Sanitary Sewer Utility Fund Rate Analysis
for the 2005 Budget Year
Rate increase
2.80% 2.80%
EXHIBIT A
2.80% 2.80% 2.80%
Actual
Projected
Proposed
Projected
Projected
Projected
Projected
2003
2004
2005
2006
2007
2008
2009
Revenues
Sewer Charges
$
2,863,138
$
2,804,760
$
2,883,293
$
2,964,025
$
3,047,018
$
3,132,335
$
3,220,040
Misc. Operating
$
17,029
$
0
$
0
$
12,000
$
12,000
$
12,000
$
12,000
Misc. Non-operating
$
77,354
$
10,000
$
5,000
$
6,000
$
7,000
$
8,000
$
8,000
Total Revenues
$
2,957,521
$
2,814,760
$
2,888,293
$
2,982,025
$
3,066,018
$
3,152,335
$
3,240,040
Expenditures
Personal Services
$
113,898
$
148,142
$
159,410
$
166,583
$
174,080
$
181,913
$
190,099
Supplies
$
7,640
$
17,315
$
16,510
$
17,005
$
17,515
$
18,041
$
18,582
Services
$
1,738,230
$
1,742,398
$
1,929,624
$
1,987,513
$
2,047,138
$
2,108,552
$
2,171,809
Depreciation
$
479,323
$
458,000
$
472,000
$
485,000
$
500,000
$
515,000
$
515,000
Debt Service Interest $ Fees
$
3
$
0
$
0
$
0
$
0
$
0
$
0
Total Expenditures
$
2,339,094
$
2,365,855
$
2,577,544
$
2,656,101
$
2,738,733
$
2,823,506
$
2,895,490
less: Non-Cash Depreciation
$
479,323
$
458,000
$
472,000
$
485,000
500,000
$
515,000.
$
515,000
plus: Debt Service Principal
$
0
$
0
$
0
$
0
0
$
0
$
0
plus: Cash Capital Outlay
$
505,206
$
639,500
$
705,800
$
1,184,600
$
642,100
$
1,159,900
$
769,800
Total Cash Requirement
$
2,364,977
$
2,547,355
$
2,811,344
$
3,355,701
$
2,880,833
$
3,468,406
$
3,150,290
Cash Reserve Target
$
950,000
$
950,000
$
950,000
$
950,000
$
950,000
$
950,000
$
950,000
Beginning Cash Balance
$
682,184
$
1,140,100
$
1,407,505
$
1,484,454
$
1,110,778
$
1,295,963
$
979,891
Cash Received
$
2,957,521
$
2,814,760
$
2,888,293
$
2,982,025
$
3,066,018
$
3,152,335
$
3,240,040
Cash Spent
$
(2,364,977)
$
(2,547,355)
$
(2,811,344)
$
(3,355,701)
$
(2,880,833)
$
(3,468,406)
$
(3,150,290)
Ending Cash Balance
$
1,274,728
$
1,407,505
$
1,484,454
$
1,110,778
$
1,295,963
$
979,891
$
1,069,641
Cash abovet(below) the
Cash Reserve Target $ 324,728 $ 457,505 $ 534,454 $ 160,778 $ 345,963 $ 29,891 $ 119,641
Assumptions:
Cash basis
Ali assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items.
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 2005 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
RESOLUTION NO. 2004-174
EXHIBIT A
City of Brooklyn Center
Storm Sewer Utility Fund Rate Analysis
for the 2005 Budget Year
Rate Increase 0.00% 0.00% 0.00% 0.00% 0.00%
Actual Projected Proposed Projected Projected Projected Projected
2003 2004 2005 2006 2007 2008 2009
Revenues
Storm Sewer Fees $ 1,266,791 $ 1,274,000 $ 1,274,000 $ 1,274,000 $ 1,274,000 $ 1,274,000 $ 1,274,000
Misc. Operating $ (2,279) $ - $ - $ - $ - $ - $ -
Misc. Non-operating $ 148,854 $ 10,000 $ 5,000 $ 6,000 $ 7,000 $ 8,000 $ 10,000
Total Revenues $ 1,413,366 $ 1,284,000 $ 1,279,000 $ 1,280,000 $ 1,281,000 $ 1,282,000 $ 1,284,000
Expenditures
Personal Services $ - $ 18,898 $ 78,201 $ 82,111 $ 86,217 $ 90,527 $ 95,054
Supplies $ 3,861 $ 20,900 $ 20,930 $ 21,558 $ 22,205 $ 22,871 $ 23,557
Services $ 191,661 $ 83,013 $ 188,748 $ 194,410 $ 200,243 $ 206,250 $ 212,438
Depreciation $ 513,608 $ 514,000 $ 523,000 $ 532,000 $ 541,000 $ 550,000 $ 550,000
Debt Service Interest & Fees $ 29,540 $ 18,250 $ 6,210 $ - $ - $ - $ -
Total Expenditures $ 738,670 $ 655,061 $ 817,089 $ 830,079 $ 849,664 $ 869,648 $ 881,048
less: Non-Cash Depreciation $ 513,608 $ 514,000 $ 523,000 $ 532,000 $ 541,000 $ 550,000 $ 550,000
plus: Debt Service Principal $ 210,000 $ 220,000 $ 230,000 $ - $ - $ - $ -
plus: Cash Capital Outlay $ 394,063 $ 601,200 $ 698,500 $ 466,600 $ 644,500 $ 1,053,800 $ 776,900
Total Cash Requirement $ 829,125 $ 962,261 $ 1,222,589 $ 764,679 $ 953,164 $ 1,373,448 $ 1,107,948
Cash Reserve Target $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000
Beginning Cash Balance $ 343,221 $ 914,076 $ 1,235,815 $ 1,292,226 $ 1,807,547 $ 2,135,383 $ 2,043,934
Cash Received $ 1,413,366 $ 1,284,000 $ 1,279,000 $ 1,280,000 $ 1,281,000 $ 1,282,000 $ 1,284,000
Cash Spent $ (829,125) $ (962,261) $ (1,222,589) $ (764,679) $ (953,164) $ (1,373,448) $ (1,107,948)
Ending Cash Balance $ 927,462 $ 1,235,815 $ 1,292,226 $ 1,807,547 $ 2,135,383 $ 2,043,934 $ 2,219,986
Cash above/(below) the
Cash Reserve Target $ 387,462 $ 695,815 $ 752,226 $ 1,267,547 $ 1,595,383 $ 1,503,934 $ 1,679,986
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation with no provisions made for changes in balance sheet items that may
affect cash balances.
Revenues
Rate increase: Assuming no increases fhrough 2009
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 2005 CIP and adjusted for estimated ENR Construction Index for each year in the five year period.
RESOLUTION NO. 2004-174
EXHIBIT A
City of Brooklyn Center
Street Light Utility Fund Rate Analysis
for
the 2005 Budget Year
Rate Increase
3.00%
7.50%
7.509/6
7.50%
7.50%
Actual
Projected
Proposed
Projected
Projected
Projected
Projected
2003
2004
2005
2006
2007
2008
2009
Revenues
Street Light Fee
$
200,224
$
207,465
$
212,000
$
227,900
$
244,993
$
263,367
$
283,119
Misc. Operating
$
5,426
$
-
$
-
$
-
$
-
$
-
$
-
Misc. Non-operating
$
3,669
$
5,000
$
1,500
$
3,000
$
3,500
$
4,000
$
4,000
Total Revenues
$
209,319
$
212,465
$
213,500
$
230,900
$
248,493
$
267,367
$
287,119
Expenditures
Personal Services
$
-
$
-
$
-
$
-
$
-
$
-
$
-
Supplies
$
824
$
2,900
$
2,900
$
2,987
$
3,077
$
3,169
$
3,264
Services
$
146,470
$
160,193
$
153,500
$
158,105
$
162,848
$
167,734
$
172,766
Depreciation
$
-
$
-
$
-
$
-
$
-
$
-
$
-
Debt Service
$
-
$
-
$
-
$
-
$
-
$
-
$
-
Total Expenditures
$
147,294
$
163,093
$
156,400
$
161,092
$
165,925
$
170,903
$
176,030
Capital Outlay
$
-
$
89,000
$
53,500
$
65,000
$
80,400
$
155,300
$
75,000
Total Cash Requirement
$
147,294
$
252,093
$
209,900
$
226,092
$
246,325
$
326,203
$
251,030
Cash Reserve Target
$
50,000
$
50,000
$
50,000
$
50,000
$
50,000
$
50,000
$
50,000
Beginning Cash Balance
$
30,361
$
92,386
$
52,758
$
56,358
$
61,166
$
63,334
$
4,498
Revenues
$
209,319
$
212,465
$
213,500
$
230,900
$
248,493
$
267,367
$
287,119
Expenditures
$
(147,294)
$
(252,093)
$
(209,900)
$
(226,092)
$
(246,325)
$
(326,203)
$
(251,030)
Depreciation Add-Back
$
-
$
-
$
-
$
-
$
-
$
-
$
-
Ending Cash Balance
$
92,386
$
52,758
$
56,358
$
61,166
$
63,334
$
4,498
$
40,588
Cash above/(below) the
Cash Reserve Target
$
42,386
$
2,758
$
6,358
$
11,166
$
13,334
$
(45,502)
$
(9,412)
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation.
Revenues
Rate increases would be 3.0% in 2005-and 7.5% per year for each fiscal year through 2009 based on customer base of 8,415 residential
customers and538 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 2005 C1P 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
if the City is to meet its reserve requirements in 2008 and 2009
RESOLUTION NO. 2004-174
City of Brooklyn Center
Capital Improvements Fund Cash Flows Analysis
for the 2005 Budget Year
EXHIBIT A
Actual
Budget
Proposed
Projected
Projected
Projected
Projected
2003
2004
2005
2006
2007
2008
2009
Revenues
Transfer in General Fund
$
125,000
$
100,000
$
0
$
0
$
0
$
0
$
0
Transfer in Liquor Fund
$
100,000
$
100,000
$
125,000
$
125,000
$
125,000
$
125,000
$
125,000
Debt Payment Golf Course
$
15,000
$
35,000
$
50,000
$
55,000
$
55,000
$
55,000
$
55,000
Misc Revenue
139,802
15,000
15,000
14,000
14,000
14,000
15,000
Total Revenues
$
379,802
$
250,000
$
190,000
$
194,000
$
194,000
$
194,000
$
195,000
Expenditures
Personal Services
$
748
$
0
$
0
$
0
$
0
$
0
$
0
Supplies
$
146
$
0
$
0
$
0
$
0
$
0
$
0
Services
$
206,369
$
68,000
$
0
$
0
$
0
$
0
$
0
Depreciation
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Debt Service
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Total Expenditures
$
207,263
$
68,000
$
0
$
0
$
0
$
0
$
0
Capital Outlay
$
328,650
$
368,200
$
228,000
$
450,000
$
180,000
$
200,000
$
115,000
Total Cash Requirement
$
535,913
$
436,200
$
228,000
$
450,000
$
180,000
$
200,000
$
115,000
Beginning Cash Balance
$
1,062,921
$
906,810
$
720,610
$
682,610
$
426,610
$
440,610
$
434,610
Revenues
$
379,802
$
250,000
$
190,000
$
194,000
$
194,000
$
194,000
$
195,000
Expenditures
$
(535,913)
$
.(4361200)
$
(228,000)
$
(450,000)
$
(180,000)
$
(200,000)
$
(115,000)
Depreciation Add-Back
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Ending Cash Balance
$
906,810
$
720,610
$
682,610
$
426,610
$
440,610
$
434,610
$
514,610
Assumptions:
Expenditures
Capital outlay is from the 2005 CIP and adjusted for estimated ENR Construction Index for each year in
the
five year period.
RESOLUTION NO. 2004-174 EXHIBIT A
City of Brooklyn Center
Street Reconstruction Fund Cash Flows Analysis
for the 2005 Budget Year
Actual
Budget
Proposed
Projected
Projected
Projected
Projected
2003
2004
2005
2006
2007
2008
2009
Revenues
Fund Transfer
$
1,300,000
$
650,000
$
668,200
$
686,910
$
706,143
$
725,915
$
746,241
Misc. Operating
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Misc. Non-operating
$
0
$
5,000
$
5,000
$
5,000
$
5,000
$
5,000
$
5,000
Total Revenues
$
1,300,000
$
655,000
$
673,200
$
691,910
$
711,143
$
730,915
$
751,241
Expenditures
Personal Services
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Supplies
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Services
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Depreciation
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Debt Service
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Total Expenditures
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Capital Outlay
$
0
$
696,400
$
837,835
$
719,363
$
816,175
$
1,508,250
$
1,508,250
Total Cash Requirement
$
0
$
696,400
$
837,835
$
719,363
$
816,175
$
1,508,250
$
1,508,250
Beginning Cash Balance
$
0
$
1,300,000
$
1,258,600
$
1,093,965
$
1,066,512
$
961,479
$
184,144
Revenues*
$
1,300,000
$
655,000
$
673,200
$
691,910
$
711,143
$
730,915
$
751,241
Expenditures
$
0
$
(696,400)
$
(837,835)
$
(719,363)
$
(816,175)
$
(1,508,250)
$
(1,508,250)
Depreciation Add-Back
$
0
$
0
$
0
$
0
$
0
$
0
$
0
Ending Cash Balance
$
1,300,000
$
1,258,600
$
1,093,965
$
1,066,512
$
961,479
$
184,144
$
(572,865)
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation.
Revenues
*2003 revenue represents transfers from infratructure Construction Fund as part of the fu
nd creation.
Expenditures
Capital outlay is from the 2004 CIP and adjusted for estimated ENR
Construction Index for each year in
the
five year period.