HomeMy WebLinkAbout2012 10-15 CCP Joint Work Session with Financial Commission AGENDA
CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION
October 15, 2012
6:30 p.m.
City Hall—City Council Chambers
I. Call to Order
11. Introduction and Overview—City Manager/Director of Finance
111. Public Works Utilities Division
a. Water Utilities
b. Sanitary Sewer Utilities
c. Storm Sewer Utilities
d. Street Light Operations
IV. Recycling Operations
V. Next Meeting—October 29, 2012
VI. Miscellaneous
VII. Adjournment
i
I
2013 Brooklyn Center Department Budget Narrative by Fund
Department Name: Public Works Utilities Division
Department/Division Mission:
The mission of the Brooklyn Center Public Works Department-Utilities Division for the residents,
business owners and visitors of the city is to responsibly provide for the maintenance and operations of
the drinking water, sanitary sewer, stormwater management, and lighting systems in a quality, cost
effective manner.
Department/Division Description:
The Public Works Department is comprised of five divisions, including: Administration/Engineering;
Street Maintenance; Park Maintenance; Public Utilities (water, sanitary sewer, storm sewer, street
lighting); and Central Garage. The Public Works Department also administers the capital asset
management for the City's public buildings and facilities. The Utilities division provides for the
operation, maintenance and management of City's drinking water system, sanitary sewer collection and
conveyance system, stormsewer collection and management system, and street light system.
Staffing Levels
Positions FTEs 2012 2013 2014
• Supervisor of Utilities 1 1 1
• Engineering Technician 3 (distributed 1/3 over 1 1 1
49141, 49251 and 49411)
• Maintenance II (4-49141, 2-49251, 2-49411) 8 8 8
• Part Time/Summer Temporary Employees (3- 5 6 6
49141, 2-49251) (1 new in 2013, 49411)
Strategic Functions/Division(s):
• Water Utility (49141)
o We provide for the distribution of the City's potable water to customers. This division includes
the operations, administration and utility billing for the utility. The division is managed by the
Public Works Director, except for the utility billing component which is managed by the Fiscal
Services Department. The City has approximately 121 miles of water main, over 1,300 water
valves, and almost 1,000 fire hydrants providing service to over 7,000 metered single-family
residential connections and approximately 1,600 metered apartments/townhouses/commercial/
industrial customers. Water is supplied from nine municipal wells. Also included in this division
is the maintenance of meters, locating water mains and services, testing of the municipal water
supply throughout the system as required,preventative maintenance, and emergency repairs to
the City's distribution system and its appurtenances. The utility billing operation prepares and
sends out utility bills, receives meter readings and makes estimated readings, and administers
collections and assessment for non-payment.
• Sanitary Sewer Utility (49251)
o We provide for the collection and conveyance of wastewater through a system of mains and lift
stations. Sewage is treated by the Metropolitan Council Environmental Services, whose fees
account for approximately 75% of this fund's expenditures. This division is managed by the
Public Works Director, except for the utility billing component, which is managed by the Fiscal
and Support Services Department. The City has approximately 106 miles of sanitary sewer
ranging in size from 8" to 24" in diameter, and just under 9,000 service connections. Included in
this division is the routine and preventative maintenance of the City's collection system and its
appurtenances, monitoring of inflow and infiltration, television inspection of the interiors of
mains, and customer service such as providing sewer locations. This activity involves the
operation and maintenance of the City's ten wastewater lift stations, which includes buildings,
equipment, and property.
® Storm Sewer Utility (49411)
o We provide for the collection and management of stormwater throughout the city in compliance
with State and Federal regulatory requirements. The Storm Drainage Utility operates and
maintains approximately 84 miles of storm sewers and just under 100 storm water management
ponds or treatment devices. The Storm Drainage Utility also provides for street sweeping
operations and the City's participation in two joint powers Watershed Commissions, which
provide for regional planning, surface water quality monitoring, and Wetlands Conservation Act
compliance
• Streetlight Utility (49571)
o We provide for electrical service, maintenance, repair, and replacement of lights owned by the
City. The City owns approximately 71 ornamental lights, primarily in the Earle Brown
commercial area, 85 ornamental lights on Brooklyn Boulevard, 40 ornamental lights along
Xerxes Avenue, 72 ornamental lights along Bass Lake Rd and 57th Avenue and leases
approximately 915 lights from Excel Energy. Another 97 lights owned by the City are located on
traffic signal systems. The Street Light Utility also provides for electrical and maintenance fees
paid to Xcel Energy for street lights owned by Xcel Energy.
Annual Goal and Strategies:
1. Meet or exceed safe drink-in water standards of the State
g of Minnesota and manage storm
water runoff in an efficient and environmentally sensitive manner.
a. Manage and enforce the City's Wellhead Protection Plan goals.
b. Implement Best Management Practices (BMPs) that support the City's and Watershed's
impaired waters Total Maximum Daily Load (TMDL) plans.
C. By 2015, update the City's Wellhead Protection Plan and Local Water Management Plan.
2. Initiate improved, streamlined management strategies and techniques by use of refined
methods and technologies.
a. Develop and initiate process flow charting for the utility department.
Annual Goal Performance Measures:
I
1. Results/Effectiveness Measures
• Number of private wells sealed
• Annual Consumer Confidence Report results
2. Efficiency Measure
• Cost per drinking water sample
3. Productivity Measure
• Miles of annual street sweeping performed per sweeper
Capital Outlay and Other Initiatives with Significant Budget Impact
• 2013 Purchase a hydro-seeding machine/applicator for erosion control purposes ($13,000).
• 2013-14 Capital Improvement Projects—See CIP section of Budget.
0
0
i W
a
a �
CD
I
E 3
O E
M
o °o °o
o vi o
v o n
N N
V N
o J J cli N N M
� I
r0 r N O
M~ c�
N m C
O O O O O
m m O
O N
!z M 'v N O � O
N O NO
J V N N
d
l
N O V O O tD O toO N O r top
p O O O O O r M M 00 O m O O M O O M
N Oi T N N aO}� r t� r
q • i N q N N N N
d« v
E Q i
a
Vl
o
m o 0 O a N n o
N
d p 16 16 11:
(fl
N u!
O O O O O O O O O M M M
M p O < O
O O I� Cl F fV O I� O O cC o
o m I
�
m M 0 V tD O I� M o O m t0 Ip h N Y
l O
lo
I� N V tp vl V 1 1� O N N
c0 q • M
o (O
o N r N A O N
ryQE
oMO
"' N Q� I�t0
16 16 N Q b n
N � O N Q 0 0 O N r V M O r O
h N
r
O N
O j CO i M t0 � N • T N O N
N a E
�n I
m
w
I w w w w
7 Z Q > w W
z W W N a N F ~ (n M OJ W O
a i0 > > w w 0 w w w w ww a w w w w w a >
O¢ K N w N Q LL W w w w w z m w z w o w w Q > j W w a w
a Q rQ- F¢- z w (n C9 t- w w w w w F O 0 N O ❑ O z W N O O LL w w
(7 Z Z w w N N z N w w Fw- N N ¢ w a w, 2 J j 7 F}- m K w m m 0 O O w d W
> ? o x oaLL w ¢ � °mzz w
ay > > w, ow ¢ v o w N w c w °w w w w w z ~ o J �}- o z w °w N z z z g ¢
w rwC > > ¢ ¢ K N w y Q Q Q Q a to w w K O to w Q N F F Q X of of w z i uJ vl w ¢ w
LL a O O y a K N J `n 2 2 w U w LL J 7 = LL LL N Q Z u. �. w W '� d
W 0 0 0 Q W Y Q 2 Q J J d' R O W Q: O w W O Q Q Z p p N
¢ w o o w w w w w w K = w cOi� y w h w H F ff z z 3 w Z f a a O = LL z O x x > > O w cw7 w
LL w a s x z a a ¢ ¢ w O w O w ¢ a ¢ Q ¢ Q ¢ w w o N P w w Q > ¢ >
W ? ? m m ? u o u € 3 LL 3 3 m c a 3 o o u 0 w w m ❑ 0 0 � s 3 0 3 0
Zn co Z
i
o o d v o d 3 N
E o�
tea' o°c h �o a
m �K aEi
EE 3 N
UP o w
q J d N U J d I
��U 3am E =
E
Zo
° —' ° ° m E d c
16 E w
E'w E
_ Um° U� c iw a E
0 0 0 0 0 0 0 o o o o ro o o.o 0 0 0 0 0 0 o o 0 0 c0
0 0 0 0 0 0 0 o O o 0
m N 1 o N N O O YI pr OM N O N o O O O O O O o
P P !� _
P N d 1� N N P P tP0 10 r N c5 A 1 m a
r d O M r
V
J J
d
N N m O o m
R O O
O O O 0 0 0 0 0 0 O
0 0 0
J
N m
O
O O O O
O O O O O O O O O O O O X 0 0 O 0 0
(V I m O I O O N 6 O
OD O Q cs
r O p O
O T V O
b N N P i P
M�� N O tp �O �- r, a � •- � � �
� J V
N V°
d D7
b O O O pP j m c M 0 m O O O O M r N N N O
Ili O C m P
O 14 P P
N N 0 O r N
I O N O N O N N N A N N N
N m
� ti
N r r
d Q
o.
d
N
o 0 0 0 0 0 0 0 0 0 0 0 0 0 0
N N y
o of r r P y n 00 0 0 0 0 0 O O O O O C C O
N N
V m c 00
c-
NIL WJ
am w oro °a vri a °o m° cvi co v 1.
N M
m m p 0 c M M r O 0 m m N m O
J �
O �
NQE
¢ i
i
o m
� n r
o r v> uri `m m °oo m r °o n
16 j
m m t°n r P N �
N N N N N m N N N N m V crY 0 Of vrl
J J i7 V OI
0
NQE
a I
J
t-
w z z Z z y
w ¢ ¢ Z o o 0 W H
o m w N o z z a a a a o m
¢ _ O_ m �n y z z a.
O :5 z z Q za O O w a m w U) N
Z Z m m
w w OZ Z 0 m K o O O O N
(n V) w H 1- U LL LL Z Z Z W W W U Z W W J W LL CL d
CC o a a '¢ Z Z z zoo g z z zzz ' W z a w w w w a a Q ¢ y r
LL m m a w w O u u m m w w w o 0 0 w w K m a S w > > W F W z z
w 2E W Z z O ¢ Q o w w w a U v } m 0 0 N w j w � m a m J O (7 C7 `a Q a N
F 1 ¢ z a a 0 S z z¢ 0 0 0 K K K a ¢ N w ¢ N C7 N s z z u a >
W W W w w Q <UQ U w w F- K K a a d Y w w O O w N O_ W W = U H LL ~Q
> 2 2 K ¢ w > > W W W LL' K LL' D! W O ~ LL LL O W LL Z W W O W Z ¢ ¢ F-
3 3 3 o o a LL u ? ? > > z 3 3 3 a'a o oo a o o b v o o m m a w m IL
w
O 00 O N N N'ON N M M
N N N N N M
N b t� O ip 1p �p [° (° b [O tD t° t0 b tD cD 10 cD b � � cN° N IND tN0 tND tND � N b tN0 � (ND (NO � tN0
I _
�O
En
a d°
¢ E g E ¢c ca rtO yZ H -
O FF N v `O LL O y
° ❑ ° N N
° c N TO
m T'��°a - EM cn d m > O
j._ ''.d d U �- ❑ oar�� o s = ° ';.
C N - N O v
CO)O N N N d N N IL
gi
_
ca_ m ¢ - ° v E O
- QO M moo w
m m
w n is N n U ° m o
j°o o° °o o °o o°
O 0 0 0 O N O o o O h O b O N
a 0 O O N 0 R
o J a
N O J
y I11
w I
O 0 o O> O i101 O O V M N O N O o O
M W A O of
.-
J
N m C
I
O O O 0 0 0 O O o 0 o O
O O N N
y O O N O i0 N CD O N N N N N
Nr O fl I
J J
O m
of
a0 m �O O 0 0 N O O O O
N c0 r 0 O
Q o 0 r Oi M N O h V N m O O O
C'i n lzt N b N N N r O
N N r I N
a J
u
mQ
c
N
0
0 0. 0 6 0
0 0 6
O O ill OOil N i0
O N N O N N
T N c N 6 N [O aG
O V
N LL QJ
0 o N r
N O h W R N O 6
O r (� cJ O 6 6 N "'..
V N OI �D N N t
N V r N N
O
N°E
¢a
i
h N V O 1O N O N C7 N N O O tR M
n r � o 2 e m N m IR
i
O
N a0 N 'Y r N V h O M M C
O
N Q¢
� i I
N
i
F
LL. F Z N
w = _ W m U
Ww a 1 w w w W N y U U
Z Ja a ❑ w w w z U U U O w
c7 O z
j w ° z z z N t- ¢ F
I0 N y Z W 2 W Z N N W % w U U z N W w Z Z W
w zz � � � � � 5 W � o z z zzNQOO >
¢ ¢ ¢ N a a o ro j z zz a o Q a T t~¢- ¢
w 2i E O 0 0 f, w 0 O O w 0 U U X z
O a 0 ° w w ¢ z W N u w o w O ° Z Z w o o z
W to N N N (7 U
W ¢ Q 0.0 J J O. d F = ¢ w LL LL W f 0 w > W ¢ ¢ 0
F W w 2 ?.Z 2P ❑ U w w w w W W O F- O O w w W
N ¢ ¢ w w
I (9 f0 t0 b [p ip t0 �p �O f0 t0 t0 tD (O 10 1p (O Ip '';
o
R = �o =
m
U.D c �°m m V=Ins E O_ lq;r
¢�°c c5 E av
H — tQ" m m m3 'm'
'c o.'E E
Q d N Z Q
ci
d aso E`mH rno �o - am
°
O °_a a
C
m
j Z
W of icy
W c w
H c d m m
>, v c l y a
5 nc m— i.d In
KH � zi» �Q 0�mm
00 0 0 00 00 G
p o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o W o
O O N o O O O 1.N V c N o N O O O O m M
d ( .- - tp V - O �- •- - N IMO M
d�
N V
Sm �
� f
I
j e e o o 0 0 I I I o 0 0 o a
d O M O O O o 0 0 O c O O N m
9 �
N� �
O O o 0 0 1. 1. 0 0 0 0 0 0 0 0 0
M O o 0 0 O O C O N
r O M � M c O O O O m ro M V
d V
N Vm i
d
� I
j
p N N I"? N M N N iD 001 m h O N N N O
N M ll m M
N M a N
m m j N m m u1
°u
E¢
c
d
N
0 0 0 0 0 0 0 0 0 0 0 0 O o 0 0 0
o o o C o 0 0 0 0 0 0o m o o v
N
O ID
o C O
NLL.m
j
I
r �n v mr m In o p o o.M oo
O N M O b N N O r
N V aC N: N V tO N O1 N N O M° r O
N
M M moi N h r V r o o r Oo N N N O r °p .
M M r V1 td m 0 N m
N M
O ,
HQE ..;
Q I
i
I
a
c
ul
I
i
w
U,
Z
O O
U,.Z z Q w w F v
Z' O N j } > O W
¢ O Z y N U U
U U N W 0 Z W N I-
Z U O W Q y 0 Z_ > >
Q W U W z 4 w
7 N K Q N W W > W Q Z >M y W 2 Z N
K Of O U W W
w p 0 m N m w F K j N O Z Z O.¢
O �? N U c7 t7 Q ��' W z Z U m G w w z pz U a > w N rn K � Q ',..
¢Q ¢Q g Z � m N
(¢ w w F r f- W wa = K W � w H f a. in m Ei w K K w p ¢ ¢
K W (9 Y W Q ¢ W 1- f LL u
O, > > Z Z_ 2 Z p 0 N j N O K J J 7 p R `� S a 6 S LL Z Z (7
w p o w Q ¢ w t- f- h- r 0 J Q O w W �- Z W W O O O
Q Q a a s C7 a Z ? W (9 m U O
N I o O O N h r N
�(D t0 (O IO tp t0 t0 t0 IO ID t0 (D t0 IO "..
m Z m N
m a E
c 3m `°' `"
mLm..
E °-' M m a m m E
m m N N
a
° o N Y R P
d-g
m om ' o$ E m o y M
a y m o
tm' c rn= o E E'c o o No
r E Em c o
N O O O O 6 N h N Oi pi P P O t7 0 ''..
Cl! m °o °o P Lq m r m o
� �- 1� O ^ N
N Vm
m
D!
O N O ll� m o N r r O V m
N �- r
N o°
m c j
I
I
°o
°o 00 00 °o
I m v°� H ° ° °o tO v n iy r r 0 0 cs
r N
O O O Ili C5
r d 01! M �- N r` � N A m m 1� t• i�1 V
j o P � N N M N 0
N O N O r N O O K r O O O 0 0 O
� �..
N m OMI m m m r
A N N
a
a
°
N I
o O o 0 0 0 0 0 0 0
G t� N O C I O O] O
OPi V N O_ O IR N H N N N
N N VI O C t` m V _ p 15 op
w m
t
[D h N rIR I M OC� h ip O r O O
n n f` N r N r N m pi O Oi OI O O
V O N N O N VI N
O r � ^ N !- t` N o
O
nQ E
Q
M Om 1� P P o N m
r r O m M M O O T N 1� P P O V N
OG � �
Oi N O P
"I
N N O cz P V M O N N CF 1� 10 tp N N N
O
U
I
a
w
N
w W
N w z w u a
w > in w zQ Z W w w w of ai w w
O Q LL LL O N w w N W U W K . 7 0 W W U U
}
W w w Z U w N Q = j W Z m W W = W N W X X W w
N m O N 0 W ¢ ¢ o S U K U J `W S S U W W M, W W fW N z
W W W (� N S S W W N K F'' W O O O a d F FN- HS ep U ~
Z X
wo U_ ¢ Z.a LL O > > W t� N N w Z F- ¢ UQQ J N.w O O Z O W W O O w W m Z
w a N O m O O Z Z W K R Z Z Z U U U O F
in (n U X m F- K W W �, z W W C7 Q W Q Q z O y w O O ar U U w W m a
U U O N U w O= a w OU W IL m W M = ro W -QQ ..a W d W w W x ¢ Q w g c27 :c W W U
W W W H to O O 2 W W Z W W W U O ¢ CL Z Z Q K N N F W w Z K R' R� >O d
W w w Z Q N N U h r F=- w X W W W W O Z ¢ W ¢ Q N W W d 2 = 2 2 0. 2
O O W W K U U Q w U C7 ¢ O C w 0 0 0 0 Ow 0
N N M M CN'I m m O My P P V ' ` tM0 m [D fy0 f� r m 0 0 1` P °Oi eOJ m QI fI V P
!C � tP0 tPD taO � cPD tPD tP0 P (P9 � cP0 � (PO cP0 P N cPD s! tPD P P � (PO � tP0 P P � P N N m tp m
m m m m m m cm m m v'
I o
m �
� m
II n
m
E
IIS
E
U
i
I o 0
i O O n h
{ p {p
m N r O
N CO
I
J
O O
t h M I
N
N
N O J
d m
6
❑ O O N O 6 m b
0
a J
u
a
y I
i
i I
I O 0 0 0 0> O C Cl
N Iq N r N r
N
N 4 J
m ".
I
O O Obi u7 V M V
N N O
c J J
O
a
j
N N �
O V
p ? N N -I N
O �
NQE
a
y I
I
I
i
I
I
I
u W m y N
Oa j2E Q z z z z
a
IN O w = X X X
w w w w X
z H w ¢ F Z U 2 O ww Q Q
f
o �0 0 70 =O Z W W W 0 > 7 > > Ul N
a w E.❑ z ❑ Q W W ~ �' w w
Q Q Q Q O.W W Z V1 N ❑Z Z Z Z
H F- 1_ �- p r H w W w W
a a d a z = z = > m m a a > >
Q Q Q Q O F- o H a w w X X w w
? U U U U m O m O a ❑ ❑ w w K o:
O O D O N O
S. S 0 0
� O � N N cD cNp tp N �O V O
City of Brooklyn Center A Finance Utility with Rate Changes Only
Water Fund Calsh Flow Analysis
Rate Increase 3.00% 4.00% 4.00% 8.009/. 9.00% 12.00% 15.00% 15.00% 15.00% 15.00% (8.00%) (8.00%) (8.00%) (8.00%) (8.00%)
Rate/1,000 gallons 1.29 1.34 1.40 1.51 , 1.65 1.85 2.12 244 2.81 3.23 2.97 2.73 2.51 2.31 2.13
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Pr(
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues
Water Service $ 1,974,100 $ 1,929,058 $ 1,948,067 $ 2,204,706 - S 2,368,682 $ 2,652,924 $ 3,050,862 S 3,508,492 $ 4,034,766 $ 4,639,980 S 4,268,782 $ 3,927,279 $ 3,613,097 $ 3,324,049 $ 3,058,125 $ 2
Bond Proceeds $ - $ 1,719,422 $ - $. - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $
Misc.Operating $ 2,596 $ 1,057 $ 42,598 $ - $ 3,700 $ 7,400 $ 11,100 $ 14,800 $ 18,500 $ 22,200 S 25,900 $ 29,600 $ 33,300 $ 37,000 $ 40,700 $
Misc.Non-operating S 50,442 $ 34,519 $ 16,923 S 12,000 $ 81,331 S 64,429 S 47,107 $ 44,493 $ 32,327 $ 5,620 $ 36,633 $ 63,487 $ 80,582 $ 128,899 $ 171,929 $
Total Revenues $ 2,027,136 $ 3,684,056 $ 2,007,588 $ 2,216,708 - $ 2,453,713 $ 2,724,753 $ 3,109,070 $ 3,567,785 $ 4,085,593 $ 4,667,801 $ 4,331,315 $ 4,020,366 $ 3,726,979 $ 3,489,948 $ 3,270,754 S 3
Expenditures
Personal Services S 421,975 $ 485,939 S 478,658 S 478,177 $ 494,914 S 502,193 $ 517,259 S 532,777 S 548,760 $ 565,223 $ 582,179 S 599,645 $ 617,634 $ 636,163 $ 655,248 $
Supplies 5 161,552 S 148,599 $ 140,575 S 175,650 $ 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 $ 200,746 $ 206,768 $ 212,971 $ 219,360 S 225,941 $ 232,719 $
Services $ 2,258,839 S 504,585 $ 595,610 $ 678,023 ! $ 694,740 $ 656,419 S 682,676 $ 709,983 S 738,382 $ 767,917 $ 798,634 $ 630,579 $ 863,803 $ 898,355 S 934,289 S
Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 S 791,831 S 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884 $ 918,281 $
New Interest
Debt Service Interest&Fees $ S 94,701 S 63,141 $ 63,928 S 62,185 $ 60,185 $ 57,571 S 54,575 $ 51,031 $ 46,910 S 42,347 $ 37,354 S 31,867 $ 23,903 S 19,495 $
Total Expenditures $ 3,438,546 $ 1,784,486 $ 1,862,584 $ 2,086,336 $ 2,196,139 S 2,132,451 $ 2,194,893 $ 2,259,075 $ 2,324,903 $ 2,392,423 $ 2,461,846 $ 2,533,265 $ 2,606,697 $ 2,680,246 S 2,760,033 S 2
less:Non-Cash Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 S 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $. 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884 $ 918,281 S
New Principal
plus:Debt Service Principal $ - $ 105,000 $ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 $ 112,750 S 116,250 $ 116,250 S 120,000 $ 123,750 $ 131,250 $ 135,000 $
plus:Transfers $ - $ 53,262 $ - $ - $ - $ - S - $ - $ - $ - $ - S - $ - $ - $ - $
plus:Cash Capital Outlay $ 437,423 $ 975,158 $ 1,127,897 $ - $ 1,420,000 $ 1,800,000 S 1,650,000 $ 2,378,000 $ 3,330,000 $ 1,937,000 $ 1,690,000 S 1,650,000 $ 260,000 $ 140,000 $ 300,000 $ 1
Total Cash Requirement S 3,279,789 S 2,208,982 5 2,510,881 $ 1,497,028 : S 3,017,109 $ 3,302,157 S 3,196,216 S 3,973,306 $ 4,975,822 $ 3,634,046 S 3,436,179 $ 3,450,549 $ 2,116,414 S 2,055,612 $ 2,276,751 $
Beginning Cash Balance S 2,068,255 $ 1,147,687 S 2,546,948 S 1,991,361 S 2,711,041 S 2,147,645 S 1,570,241 $ 1,483.095 $ 1,077,573 S 187,344 S 1,221,099 $ 2,116,235 $ 2,685,052 $ 4,296,617 $ 5,730,953 $ E
Changes in Assets/Liabilities $ 332,083 $ (75,813) $ (52,294) $ - - $ - $ - $ - $ - $ - $ - $ - $ - S - S - S - $
Cash Received $ 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 - $ 2,453,713 $ 2,724,753 S 3,109,070 $ 3,567,785 S 4,085,593 $ 4,667,801 S 4,331,315 $ 4,020,366 S 3,726,979 S 3,489,948 S 3,270,754 $
Cash Spent S 3,279,789 $ 2,208,982 $ 2,510,881 $ 1,497,028 S 3,017,109 $ 3,302,157 $ 3,196,216 $ 3,973,306 $ 4,975,822 $ 3,634,046 $ 3,436,179 $ 3,450,549 $ 2,116,414 S 2,055,612 $ 2,276,751 S
Ending Cash Balance $ 1,147,687 $ 2,546 948 $ 1,991,361 $ 2 711 041 $ 2,147,645 $ 11,670,241 $ 1,483 095 $ 1,077,673 $ 187,344 $ 1,221,099 $ 2,116,235 S 2,686 052 $ 4,296,617 S 5,730 953 $ 6,724,956 S E
Cash Reserve Target(step) $ 1,000,000 S 1,200,000 $ 1,200,000 $ 1,300,000 $ 1,300,000 S 1,300,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 S 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 S 1
Cash Reserve Target(5%fyr) S 1,050,000 S 1,102,500 S 1,157,625 $ 1,215,506 $ 1,276,282 $ 1,340,096 $ 1,407,100 $ 1,477,455 $ 1,551,328 $ 1,628,895 $ 1,710,339 S 1,795,856 $ 1,885,649 $ 1,979,932 $ 2,078,928 $
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items
Revenues
Rate increases would be as indicated each year and based on a stable customer base and stable consumption
Expenditures
Personnel Costs increase at a rate of 3%per year
Supplies increase at a rate of 3% perannum.
Services increase at a rate of 4%per year
Depreciation increases at a rate of approximately 2.5%per annum.
City of Brooklyn Center Finance by Adjusting Rates and Using Minimal Debt
Water Fund Calsh Flow Analysis
Rate Increase 3.00% 4.00% 4.00% 8.00% 9.00% 9.00% 9.00% 9,00% 9.:00% 9.00% 0.00% 0.00% 0.00% 0.00% (3.00%)
Rate/1,000 gallons 1.29 1.34 1.40 1.51 1.65 1.80 1.96 2.13 2.33 2.54 2.54 2.54 2.54 2.54 2.46
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Prr.
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues
Water Service $ 1,974,100 $ 1,929,058 $ 1,948,067 S 2,204,708 S 2,368,682 $ 2,581,863 $ 2,814,231 $ 3,067,512 $ 3,343,588 S 3,644,511 $ 3,644,511 S 3,644,511 $ 3,644,511 $ 3,644,511 $ 3,535,176 S
Bond Proceeds $ - S 1,719,422 $ - $ - $ - $ - $ - # '000: S - S - S - S - S - $ - $
Misc.Operating $ 2,596 $ 1,057 $ 42,598 $ - $ 3,700 $ 7,400 $ 11,100 $ 14,800 $ 18,500 S 22,200 $ 25,900 $ - 29,600 $ 33,300 S 37,000 $ 40,700 $
Misc.Non-operating S 50,442 $ 34,519 S 16,923 $ 12,040 $ 81,331 $ 64,429 $ 44,975 $ 35,198 S 9,524 $ 6,398 $ 1,787 $. 3,220 S 1,556 $ 19,517 $ 68,880 $
'otal Revenues S 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 $ 2,453,713 S 2,653,693 $ 2,870,307 $ 3,117,510 $ 4,871,612 $ 3,673,109 $ 3,672,198 $ 3,677,331 $ 3,679,367 S 3,701,028 S 3,644,756 $
Expenditures
Personal Services $ 421,975 $ 485,939 $ 478,658 $ 478,177 S 494,914 $ 502,193 S 517,259 S 532,777 $ 548,760 $ 565,223 $ 582,179 $ 599,645 $ 617,634 $ 636,163. $ 655,248 $
Supplies $ 161,552 $ 148,599 $ 140,575 $ 175,650 $ 244,020 $ 178,360 S 183,711 S 189,222 $ 194,899 $ 200,746 $ 206,768 $ 212,971 $ 219,360 S 225,941 5 232,719 $
Services S 2,258,839 $ 504,585 S 595,610 $ 678,023 $ 694,740 $ 656,419 S 682,676 S 709,983 $ 738,382 S 767,917 $ 798,634 $ 830,579 $ 863,803 $ 898,355 $ 934,289 $
Depreciation S 596,180 $ 550,662 S 584,600 $ 690,558 $ 700,280 $ 735,294 $ 753,676 S 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884 S 918,281 $
New Interest S 42,750 S 38,250 $ 32,250 S 14,250
Debt Service Interest&Fees $ $ 94,701 $ 63,141 $ 63,928 $ 62,185 S 60,185 $ 57,571 $ 54,575 S 51,031 S 46,910 S 42,347 S 37,354 S 31,867 $ 23,903 $ 19,495 S
Total Expenditures $ 3,438,546 S 1,784,486 $ 1,862,584 $ 2,086,336 $ 2,196,139 S 2,132,451 S 2,194,893 $ 2,259,075 S 2,324,903 S 2,435,173 S 2,500,096 $ 2,565,515 S 2,620,947 $ 2,680,246 $ 2,760,033 S 2
less:Non-Cash Depreciation $ 596,180 $ 550,662 S 584,600 $ 690,558 $ 700,280 $ 735,294 S 753,676 $ 772,518 S 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884 $ 918,281 S
New Principal $ 150,000 $ 150,000 $ 250,000 $ 950,000
plus:Debt Service Principal $ - $ 105,000 $ 101,250 S 101,250 S 105,000 $ 105,000 $ 108,759 $ 112,750 $ 116,250 $ 116,250 $ 120,000 $ 123,750 S 131,250 S 135,000 $
plus:Transfers S - $ 53,262 $ - $ - $ - S - $ - $ - $ - $ - $ - $ - $ - $ - $ - $
plus:Cash Capital Outlay $ 437,423 S 975,158 $ 1,127,897 S $ 1,420,000 $ 1,800,000 $ 1,650,000 $ 2,378,000 $ 3,330,000 S 1,937,000 $ 1,690,000 $ 1,650,000 $ 260,000 S 140,000 S 300,000 $ 1
Total Cash Requirement S 3,279,789 S 2,208,982 $ 2,510,881 S 1,497,028 $ 3,017,109 S 3,302,157 $ 3,196,216 S 3,973,306 $ 4,975,822 S 3,826,796 $ 3,624,429 $ 3,732,799 S 3,080,664 S 2,055,612 S 2,276,751 S
Beginning Cash Balance S 2,068,255 $ 1,147,687 $ 2,546,948 S 1,991,361 $ 2,711,041 S 2,147,645 S 1,499,181 S 1,173,271 $ 317,475 $ 213,265 S 59,578 S 107,348 $ 51,880 $ 650,583 $ 2,296,000 S
Changes in Assets/Liabilities $ 332,083 S (75,813) $ (52,294) $ - $ - $ - $ - S - S - $ - $ - $ - S - $ - $ - $
Cash Received $ 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 $ 2,453,713 $ 2,653,693 $ 2,870,307 $ 3,117,510 S 4,871,612 $ 3,673,109 S 3,672,198 S 3,677,331 S 3,679,367 $ 3,701,028 $ 3,644,756 S
Cash Spent $ 3,279,789 $ 2,208,982 $ 2,510,881 S 1,497,028 $ 3,017,109 $ 3,302,157 $ 3,196,216 $ 3,973,306 $ 4,975,822 $ 3,826,796 $ 3,624,429 $ 3,732,799 $ 3,080,664 $ 2,055,612 $ 2,276,751 S
Ending Cash Balance $ 1,147,687 $ 2,546,948 $ 1,991,361 5 2,711,041 $ 2 147 695 5 1 499,181 $ 1,173,271 $ 317,475 $ 213,265 $ 59,578 $ 107,348 $ 51,880 $ 650,583 $ 2,296,000 $ 3 664,004 $
Cash Reserve Target(step) $ 1,000,000 $ 1,200,000 S 1,200,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 S 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $. 1,400,000 $ 1,500,000 $ 1,500,000 S 1,500,000 S 1,500,000 S 1
Cash Reserve Target(S%Iyr) $ 1,050,000 $ 1,102,500 S 1,157,625 $ 1,215,506 $ 1,276,282 S 1,340,096 S 1,407,100 $ 1,477,455 S 1,551,328 $ 1,628,895 $ 1,710,339 $ 1,795,856 S 1,885,649 $ 1,979,932 S 2,078,928 $
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items
Revenues
Rate increases would be as indicated each year and based on a stable customer base and stable consumption
Expenditures
Personnel Costs increase at a rate of 3%per year
Supplies increase at a rate of 3% perannum.
Services increase at a rate of 4%per year
Depreciation increases at a rate of approximately 2.5%per annum.
1 City of Brooklyn Center Finance by Issuing Debt and Stabilizing Rates
Water Fund Calsh Flow Analysis
Rate Increase 3.00% 4.00% 4.00% 6.00% 7.00% 7.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 0.00% 0.00% 0.00%
Rate/1,000 gallons 1.29 1.34 1.40 1.51 1.62 1.73 1.83 1.95 2.06 2.19 2.32 2.46 2.46 2.46 2.46
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Pr(
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues
Water Service $ 1,974,100 $ 1,929,058 $ 1,948,067 $ 2,204,708 $ 2,359,038 $ 2,524,170 S 2,675,620 $ 2,836,158 $ 3,006,327 S 3,186,707 $ 3,377,909 S 3,580,584 $ 3,580,584 $ 3,580,584 $ 3,580,584 $ 3
Bond Proceeds $ - $ 1,719,422 S - $ - $ - $ - $ - $ 3,330,000 $ - $ - $ - $ - $ - $ - $
Misc.Operating S 2,596 $ 1,057 $ 42,598 $ - $ 3,700 $ 7,400 $ 11,100 S 14,800 $ 18,500 $ 22,200 $ 25,900 $ 29,600 $ 33,300 $ 37,000 5 40,700 $
Misc.Non-operating $ 50,442 $ 34,519 $ 16,923 $ 12,000 $ 81,331 $ 64,140 $ 42,947 $ 28,950 $ 3,852 $ 37,403 S. 15,386 S 4,717 S 287 $ 27,532 S 51,182 $
Total Revenues $ 2,027,138 $ 3,684,056 $ 2,007,588 S 2,216,708 $ 2,444,069 $ 2,595,710 $ 2,729,667 $ 2,879,9D8 S 6,350,975 $ 3,246,309 S 3,419,195 $ 3,614,901 $ 3,613,597 $ 3,645,115 S 3,672,466 $ 3
Expenditures
Personal Services S 421,975 $ 485,939 $ 478,658 $ 478,177 - $ 494,914 $ 502,193 $ 517,259 $ 532,777 $ 548,760 $ 565,223 $ 582,179 $ 599,645 $ 617,634 $ 636,163 $ 655,248 S
Supplies S 161,552 $ 148,599 $ 140,575 $ 175,650 S 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 $ 200,746 $ 206,768 $ 212,971 $ 219,360 S 225,941 $ 232,719 S
Services $ 2,258,839 $ 504,585 $ 595,610 S 678,023 $ 694,740 $ 656,419 $ 682,676 S 709,983 $ 738,382 $ 767,917 S 798,634 $ 830,579 $ 863,803 S 898,355 $ 934,289 $
Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 $ 735,294 S 753,676 S 772,518 S 791,831 $ 811,627 S 831,918 $ 852,716 S 874,034 $ 895,884 $ 918,281 $
New Interest $ 96,150 $ 88,650 $ 81,150 $ 69,900 $ 51,150 $ 28,650 $
Debt Service Interest&Fees S S 94,701 $ 63,141 $ 63,928 ty $ 62,185 $ 60,185 S 57,571 $ 54,575 $ 51,031 S 46,910 $ 42,347 $ 37,354 $ 31,867 $ 23,903 $ 19,495 $
Total Expenditures $ 3,438,546 $ 1,784,486 $ 1,862,584 S 2,086,336 1 $ 2,196,139 5 2,132,451 $ 2,194,893 $ 2,259,075 $ 2,324,903 $ 2,488,573 $ 2,550,496 $ 2,614,415 $ 2,676,597 $ 2,731,396 $ 2,788,683 $ 2
I
less:Non-Cash Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884 $ 918,281 $
New Principal $ 250,000 $ 250,000 $ 250,000 S 500,000 $ 750,000 S 750,000 $
plus:Debt Service Principal $ - $ 105,OOO $ 101,250 it 50 S 105,000 $ 105,000 $ 108,750 $ 112,750 S 116,250 S 116,250 $ 120,000 $ 123,750 $ 131,250 $ 135,000 $
plus:Transfers $ - $ 53,262 $ - $ - $ - $ - $ - $ - S - $ - $ - $ - $ - $ - $
plus:Cash Capital Outlay $ 437,423 $ 975,158 $ 1,127,897 S - 00 $ 1,800,000 S 1,650,000 S 2,378,000 $ 3,330,000 $ 1,937,000 S 1,690,000 $ 1,650,000 S 260,000 $ 140,000 $ 300,000 $ 1
Total Cash Requirement $ 3,279,789 5 2,208,982 $ 2,510,881 $ 1,497,028 09 $ 3,302,157 S 3,196,216 S 3,973,306 S 4,975,822 $ 3,980,196 $ 3,774,829 $ 3,781,699 $ 2,686,314 $ 2,856,762 $ 3,055,401 S 4
Beginning Cash Balance S 2.068,255 $ 1,147,687 S 2,546,948 $ 1,991,361 41 $ 2,138,001 S 1,431,554 S 965,005 $ (128,394) $ 1,246,759 S 512,873 $ 157,240 $ (9,558) S 917,724 S 1,706,078 $ 2
Changes in Assets/Liabilities $ 332,083 $ (75,813) $ (52,294) $ - $ - S - $ - $ - $ - 5 - $ - S - S - $ - $
Cash Received S 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 69 $ 2,595,710 $ 2,729,667 $ 2,879,908 $ 6,350,975 $ 3,246,309 $ 3,419,195 $ 3,614,901 S 3,613,597 $ 3,645,115 $ 3,672,466 $
Cash Spent $ 3,279,789 $ 2,208,982 S 2,510,881 $ 1,497,028 09 $ 3,302,157 $ 3,196,216 $ 3,973,306 $ 4,975,822 $ 3,980,196 $ 3,774,829 S 3,781,699 $ 2,686,314 S 2,856,762 $ 3,055,401 $
Ending Cash Balance $ 1,147,687 $ 2,546,948 $ 1,991,361 $ 2,711 041 T_5, 2,138,001 5 1,431,554 $ 966,005 $ 128,394 $ 1,246,769 $ 512,873 $ 157,240 $ 9,558 $ 917,724 S 1,706 078 $ 2,323 143 $ 1
Cash Reserve Target(step) $ 1,000,000 $ 1,200,000 $ 1,200,000 S 1,300,000 $ 1,300000 S 1,300,000 S 1,,400000 S 1400,000 S 1,400,000 $ 1,400,000 S 1400,000 $ 1,500000 $ 1,500,000 S 1,500,000 S 1,500,000 S 1
Cash Reserve Target(5%1yr) $ 1,050,000 $ 1,102,500 $ 1,157,625 $ 1,215,506 $ 1276,282 S 1,340,096 $ 1407,100 $ 1,477,455 $ 1,551,328 $ 1628895 S 1,710,339 $ 1,795,856
$ 1,885,649 $ 1,979,932 $ 2,078,928 S
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items
Revenues
Rate increases would be as indicated each year and based on a stable customer base and stable consumption
Expenditures
Personnel Costs increase at a rate of 3%per year
Supplies increase at a rate of 31/6 perannum.
Services increase at a rate of 4%per year
Depreciation increases at a rate of approximately 2.5%per annum.
3r City of Brooklyn Center ® Shift Water Tower Painting Forward Five Years
Water Fund Calsh Flow Analysis
Rate Increase 3.00% 4.00% 4.00% 8.00% 7.00% 7.00% 7.00% 7.00% 7.00% 600% 4.00% 0.00% 0.009/1 0.00% 0.00%
Ratel1,000 gallons 129 1.34 1.40 1.51 1.62 1.73 1.85 1.98 2.12 2.25 2.34 2.34 2.34 2.34 2.34
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Prc
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues
Water Service $ 1,974,100 S 1,929,056 S 1,948,067 $ 2,204,708 $ 2,368,682 $ 2,534,490 $ 2,711,904 S 2,901,737 $ 3,104,859 $ 3,291,150 S 3,422,796 $ 3,422,796 S 3,422,796 S 3,422,796 $ 3,422,796 $ 3
Bond Proceeds $ - S 1,719,422 $ - $ - S - $ - $ - $ - $ - $ - $ - S - S - $ - $
Misc.Operating $ 2,596 $ 11057 S 42,598 S - S 3,700 $ 7,400 S 11,100 $ 14,800 $ 18,500 $ 22,200 $ 25,900 $ 29,600 S 33,300 S 37,000 $ 40,700 $
Misc.Non-operating $ 50,442 $ 34,519 $ 16,923 S 12,000 $ 81,331 $ 64,429 S 43,554 $ 30,664 $ 34,021 S 10,368 $ 18,068 $ 18,986 $ 19,611 $ 26,250 S 38,263 S
Total Revenues $ 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 $ 2,453,713 S 2,606,319 $ 2,766,558 $ 2,947,202 $ 3,157,380 $ 3,323,719 $ 3,466,765 S 3,471,382 S 3,475,707 $ 3,486,046 S 3,501,759 S 3
Expenditures
Personal Services $ 421,975 $ 485,939 $ 478,658 S 478,177 $ 494,914 $ 502,193 $ 517,259 S 532,777 $ 548,760 S 565,223 $ 582,179 S 599,645 $ 617,634 $ 636,163 $ 655,248 $
Supplies $ 161,552 $ 148,599 $ 140,575 $ 175,650 l $ 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 S 200,746 S 206,768 $ 212,971 S 219,360 $ 225,941 $ 232,719 $
Services $ 2,258,839 $ 504,585 $ 595,610 $ 678,023 $ 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 $ 767,917 $ 798,634 $ 830,579 $ 863,803 $ 898,355 $ 934,289 $
Depreciation $ 596,180 S 550,662 $ 584,600 $ 690,558 $ 700,280 $ 735,294 S 753,676 $ 772,518 $ 791,831 $ 811,627 S 631,918 $ 852,716 $ 874,034 S 895,884 $ 918,281 S
New Interest
Debt Service Interest&Fees S $ 94,701 S 63,141 S 63,928 S 62,185 S 60,185 $ 57,571 $ 54,575 S 51,031 $ 46,910 $ 42,347 S 37,354 S 31,867 $ 23,903 S 19,495 S
Total Expenditures $ 3,438,546 $ 1,784,486 $ 1,862,584 $ 2,086,336 $ 2,196,139 $ 2,132,451 $ 2,194,893 S 2,259,075 $ 2,324,903 $ 2,392,423 $ 2,461,846 $ 2,533,265 $ 2,606,697 $ 2,680,246 S 2,760,033 $ 2
less:Non-Cash Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884 $ 918,281 $
New Principal
plus:Debt Service Principal S - $ 105,000 $ 101,250 $ 1D1,250 $ 105,000 $ 105,000 $ 108,750 $ 112,750 $ 116,250 $ 116,250 $ 120,000 $ 123,750 $ 131,250 $ 135,000 $
plus:Transfers $ - S 53,262 S - $ - $ - $ - $ - 5 - $ - $ - $ - $ - S - $ - $ - $
plus:Cash Capital Outlay $ 437,423 S 975,158 S 1,127,897 S - S 1,420,000 S 1,800,000 $ 1,650,000 $ 1,690,000 $. 1,650,000 S 1,398,000 S 1,170,000 S 867,000 S 1
Total Cash Requirement $ 3,279,789 $ 2,208,982 $ 2,510,881 $ 1,497,028 S 3,017,109 S 3,302,157 $ 3,196,216 $ 3,436,179 $ 3,450.549 S 3,254,414 S 3,085,612 $ 2,843,751 $
Beginning Cash Balance $ 2,068,255 S 1,147,687 S 2,546,948 $ 1,991,361 S 2,111,041 $ 2,147,645 $ 1,451,807 $ 1,022,149 $ 1,134,045. S 345,603 $ 602,276 S. 632,862 $ - 653,695 $ 874,988 S 1,275,423 $ 1
Changes in Assets/Liabilities S 332,083 $ (75,813) S (52,294) $ - $ - $ - $ - $ - $ - S - $ - $ - $ - $ - $ - S
Cash Received S 2,027,138 $ 3,684,056 $ 2,007,588 S 2,216,708 $ 2,453,713 $ 2,606,319 $ 2,766,558 $ 2,947,202 S 3,157,380 $ 3,323,719 S 3,466,765 $ 3,471,382 $ 3,475,707 $ 3,486,046 $ 3,501,759 $
Cash Spent $ 3,279,789 $ 2,208,982 $ 2,510,881 $ 1,497,028 $ 3,017,109 S 3,302,157 $ 3,196,216 $ 2,835,306 $ 3,945,822 $ 3,067,046 S 3,436,179 $ 3,450,549 $ 3,254,414 $ 3,085,612 $ 2,843,751 S
Ending Cash Balance $ 1,147,687 $ 2,546,948 $ 1,991,361 $ 2,711 041 -.. $ 2,147,645 S 1,451,807 $ 1,022 149 $ 1,134,046 $ 345,603 $ 602,276 $ 632,862 S 653,696 5 874,988 $ 1,275 423 $ 1,933 431 $ 1
Cash Reserve Target(step) $ 1,000,000 $ 1,200,000 $ 1,200,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,500,000 $ 1,500,000 S 1,500,000 S 1,500,000 S 1
Cash Reserve Target(5%!yr) $ 1,050,000 S 1,102,500 S 1,157,625 $ 1,215,506 $ 1,276,282 S 1,340,096 S 1,407,100 S 1,477,455 $ 1,551,328 $ 1,628,895 $ 1,710,339 $ 1,795,856 S 1,885,649 $ 1,979,932 S 2,078,928 $
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items
Revenues
Rate increases would be as indicated each year and based on a stable customer base and stable consumption
Expenditures _
Personnel Costs increase at a rate of 31/6 per year
Supplies increase at a rate of 3% perannum.
Services increase at a rate of 41/.per year
Depreciation increases at a rate of approximately 2_5%per annum_
N
LD ry) m r4 0
Goomm
to LI)
C ^ m lzr
(1) N 06 GIONFAID
rf�
CL
0
L) tLo
tjo L)
-1 c
(1) E
O
In
'a 0
< 0- (u
cF 1p Izi• m 0 0
4 r1l N
O W C)
M u N rr�
ru
M Lt)
u co
cr >. >
0
u -0 (3) (1) 0
(3) cu
C Q) Ln C) 4
cq 'Zt -I
m -0 —4
u
Ln
to li 00
Lq
N
-1 r-4 00 0
06 I-i
Ln Ln
rq Lr)
U
V)
C
c i6
.2 E
u E
Z E E
X
E
0
u m >
t0 V1 N Ln (N ro
00
0
Ln
0
41
Ln
c
a- 0 E
U u
ro
a,
Ld
>
0
U (U
w ro
a) w
0) E >1 c 0
Ln
m m m
Ln 0
cr cr-I E u
m 00
—i r-4 m
C) 0 0 0
N N
h fY
N (�
l� CV
f I
! �r
J
L1
�+ CV
O
N
rq
N �
O
N
�+ m
N
O
tt N
q! O
N
rq
v
N
o
O O lr
� m
Q 0 fl
O
W t
o
rq
O
N
r-I
O
N
A;
LO
O
N
d'
O
N
m
O
N
O O O O O O O O
u1 O O u'1 O Ur O
m m N N r-I ri O O
suolleg pp`Z aad s.ielloa
Dom 0g 0 g � n000 m AA M0 -�A7 0 0000 ov 3 3 N 0 c nw
M m m 0 m 6) m 0 < < S S n 6 T m z 'Dp D '�➢ " * � z * Z N N N N m = ,ZZj m m frail m 0 0 N fyll
A .Z7 mw A N N Z Z p A O z z O T 1 m m m z m m D m m m O m m (1 Z7 C1 n A A m A O m
c c C N O O z D D 0, A �1 m x ;0 r r D p D T m D D 47 G) Z^�
3 3 fzj Z z m m y m N ti m z z � D N N T D A O m 1 c m ti m D D D D N m N A 'i D D 0 0 D O c
m 0 0 < V �7 T D D D p N flo W x N N 0 A r r 0 ;1 r z Z z Z m < m O m N N m m T 1.
T N N T D -� z Z Z A A m N z O Z < m m In m N m 0 () D N N ,T Z7 m m
m m O A -i m D n n m_ m_ o 'T z 1 m 1
000
O N z m ;o m m < < r
-zi { 5 D D -i A z Z 0 A m -C { C C C C C Z N Z N N z Z m
O 3 D 7� A T T S m T W N (/! N z m < N N N 3 < z Z �7
O o m p N V) N O C � m D c < z z A z m m m m m w N m m z z m m D 0T
z z N N m m O O D N m O T z O o N m m m m N m m v~i r m A
Z z U < Q m m A xl m 3 N m N z z z z -i m m A
N N { N V c) O N m m T A m m m m -i N m m m A D O
A A 0 m O N N z -zi ON D N m m Z 6
D D m m N < N N D Z C C N
n n N m m z m m
m m N
N
I
c
3�a
41
N iN A W A N O O N N O A
j0na
N � �
N N
A A fn A A N
W W O O 0 0 0 N
W T o
!J
H J J
N
N Al D 3
G V
m J d A
m W J m m N W W
(P O b N Np i
A N
O O J O� O O� O 0 0 0 0 O O N
c a N
a�o
A °
VJ N A A A O w G
W
N ip
0 0 O O
0 0 o O O O O
Co
A O
. n
A A A FO P d W
WW
b W
o a o a e e o o o
A
Wa N
c c o
a
O A D N w
A pApff A .r 4
W A A A
0 0 0 0 0 O O O o O
n
3
3
m
m
o_
N
m ,ZD1 n c c y m O A A m O p m A m D a W-i c m o 0 47 m O 0 m 0 m to m O a v
3 Z z m -i a v m T x V O T m m O O O W N T m m m n p
D = of 'a0 r Dr O O D D D fxn D D .Z{ m O m x m m C'1 (7 O n N A A �7 U C m -i 1 p D
to m O A A A cn 1 z ,:.i D < Cl = m m O (� m O O m m m D D m m m y C)
m Z D N tJl Z Z7 N Z Z A A Z Z A 3 3 U O
A O c 0 p p O 3 v v y m 2 z c O c c D m c n D N co W n n D m m m O
0 -4 N C V y D D D D D C Z Q' 4! V� 'aO n V V -ap fA m A 0 O M a Zi -Zi O
3 = z p = z m -{ c c S r to x m o o o m n n
N m m z y (n y (n N y n 9 v fm/! (An frail N m Z N < < v v m m Z 2I
Z 3 A � C C -{ r r r a O n 0 m m m �l n -1
? Z m v -a D 9 v m -1 m m z D z m m m m z z N 0 A._A m o
Z N O A D a � Z a a ;U m N f/� D N m y D C t� (n z Ol N C
47 m A m C r - r Rl D N c a 1 V J .m C C r
A A 0 3 umi w c N u> W a A m m O O z m 1 ti Z z n 0
c 'v O A p Z Z c O z y o-
m .So v z o 0 v o'S D m -i m m cx...
w m m m m m m z
Z Z p 'o to ti Z N
I
N I
C
Q
3 n c
o�+
O
I
3no
�C+
H N j A J N A N m 0 N O O O A W
O V N ~
O
D •UNi N > O A W N pp11 W � N N N 00 W � � lD J J -+ N
O W �O O tD l0 �D V A N A W A A W W t0 O N' W N
aj m O
O r v i O N N
io A In O Vi W (n -+ to No 00 �1 A N:-� w A A to - � -t°o w I ••
O O 0 0 O O O
O O O O O O 0 0 0 0 O O O O N Ol W J N
O 0 0 0 O O O 0 0 0 0 O O O O O O O O O O O j
Vl
O
a
n3
a m
(n W W tppG O [D O N N + N O W N
W O A A O A W W N W
W
O A A A W A A O W W W 7
A
A
j W
. ((//�� C� � N O A + _ Co N N N OWi j '•d
o o A O O 0 0 O O O 0 0 + J m m J N o l
0 0 0 O O O O O O N P ? A
O O O O 0 0 0 0 0 O °0 0 0 O °O 0 0 0 0 0 0 0 O 0 0 O o 0 0
O p PO O O + W O O O O O O O O 0 0 O W W W W N N W
N tl� 0 0 N
W O O O O W O O W W A W
A V O V O O O + N O V
0 o e o o a a o e o a a e o 0 0 0 o a a e e o o e o e o 0
03.-
c
N
0-
0
Ui O O
O
N O o p 0 0 0 O O:O O 0 0 0 0 0 N f 0 0 0 o N 0 0 O O J
0 0 0 O 0 0 0 O N 6 O O O O O
N � O
j
o z
N S5 Er n r m
3 n m m
N N N O
N w °
O
Oi
m m m rn m m m m m m rn m W m m rn w m m rn
I
A A A W W 0 W W W W W W W W W N W W W W W W W
O C tD tp 0 0 0 Ill O 0 0 " w w w NO IV N N � O O °
W N 0 0 O O 00i N O N O O O W N J
(7 mr m O O C c m Z Z V (,) S v D D r -1
3 p D Z rte-, m to
A? N D 'D c'�?•�' D� O -i -A i .n Aw ?D m m
0 O a
O D O O N tii O
A
P l A A W
G) O O O m O m m O m m m z AY m z D z< mz D O A N
Ow < -1 < N fmn D 1 c c O D m z ZD ? m r
Z m to rn A O z { � rm z z 3 y O -ODI A A Am
D O Z C) c) r �' < < <
w "{ W < < m Z m c -Di > D ? m m m '.
rn m n m < Z Z m w W W n O
m m m m Z O O
< !� N c D
m 0 � m
m
z
O I
m
I
I
I
.wi W W
fAII A N j 0 000 W ' ' o W Ou
OJ A A O D7 N W N N FO J
O N 1NG INp N N O ON O N 00 W O p 0 O O N tp
N N 3 n p
� C�
O O IWO two 0 A A j� »—
O O O O V J N N J W O O O O m iD cAp O
w
� �O
w w w j o m N
J UI V 0 lT N _ A w
O O N A O UVi (JJ� O O N U0i O O
O 0 0 0 O O O O
I
a
cDi 3
ou
�v
O W N N O T O> W N!
i A
mp
a N
N N i d s O
O N W
J W w Iwlt N A W N V I �
w A
0
O N N O O N N Cn N V J b A ¢
N O
I
A
mnw
O N N O O W c0 A O O A O J 0 ~
A
W A
N N n c o
O N A
W N lJ W W 00 O 0 v ~6
o P p w o
o 0 0 0 0 0 0 0 0 0 0
3d op o) 0 N� o ^ tnm
m
x � °
N O N A 0 =ry NL U
� J
NO N V 0 -
V d ? O G) N m 0 0
U
A A A J A J A A A A m 0 OAi P A A A A A W W N N N N A D A A AO A
O
O O O m O p D -i -+ 41 O m ➢ 0 O A A m O O O C 3 p O y A �l O A 7J O
-� X m m A m D Z p m m m m X c c 0 O O m
2 2 x V v (n D D z m O K z z v m m, mm x x m w m m z N N z z x V v x
MX m m m A �7 m z z m -� -A1 Xp17 D p m m m z p n rn m m N -i --� m D D m !
A �I A y n n m m D m N D D n ,l1 n O �7 A to r m go m < < > D D A A A A
y n n N Di D A A m n v A i m r P D D m X 0 z D C m O M x A N m p p° m
GAi 0 0 C)O m Z z , D D z O O � D A z D O m Izn Z -{ 'yyi m0 o m m ! � � r v D D
m O O z z = z z p m g G D -Zi m W w vI m C c 0 N m 0 z z A
c v v o 0 0 m T ,u m m m D = to 0 c i» N N m z z N O -Zi m m
to m m N m m 0 = S K c A O i p D D .,I rn N m p D
A V v m En Q) D m m c z m < D D m r m z O N N < < 1
G I^ m m m z c.c N 'i m GAi N.N m �' W O m m m m DO
m m m m M m � . N m n Or N N W a0i
m m z m m z m
n
z 1 m A m
m
m
i
I
i N
I
i
3>O .�
p pppp G o
N O UOi (li N OWi v 0 0 0 0 N
3 n c
o
A A A A NJ+ V m O N ' uNi VNi A J N
A iD 4I J O� 1p N (J
W W W UoNi CO j J J N + r V7 N
V O V J A O W A A A O A
O o o
N N W A W O o 0 0 O
O
O O
i
N
J J J N
N o � OO 0 0 o N N A A WO
W W ut O N N N A O N O N V J W
O O O O O O o 0 0 0 O O O O O
0 0 O O O 0 0 O
N
m
O
3
n 3
»Q
J J J N O� UNi N N °N1 A O A A A W p
A O A A O O A OOi W N A O J W W 0 0 O O O O O W
7l
I �°
caN
yco
J ONO m JW OO j N m N N tNii N N N »w W
O O O J v 0 0 0 O O W W O O
O 0 0 O O O O O O O O 0 0 0 0 0 0 O
O
O
A ~6 W
W WW N N O N W OWO O A. A W N ° I
( W°
ca
ac,
J J J d tO N A 0 0 0 O O O O N N O
0 0 O 0 0 0 O O o 0 O O
O o O O 0 0 O
x W C O y N D
a °c
o
d m N d
F o 2�a N 7 y
- ° 0 d — N
C ° x
n3 n
iz
m 4] w
Ul
i
N m 0 0 O o
;O
7J �1 m m O O O W O m C7 O A C1 z OI
m m
m m m m W - < m z m z m m V p A S
c c o o �' m GZi A z A v D D D A < A
N m C C < G O m m m Z 0 0 0 D m _
D D A 7J f1 Cl m m n -Ci -C1 O m 3D11
p O N tmii m m Z A > D r D Z [7 m
D D D n
M m m m O J r j < j C j m
i m z O
v -u V I A O Qo
m m m m m N m
z z z z > m
M mm m Im m < Dp
N Vl N 0 N
i
P
I
I
N
D
O �
N wI m
N N
N N V
O
N O J N N N
N C C
01
V O N
A N A N W
� O
O O O O HI
I
i
I
i OJ
0 W N W N N bi 10 N N
00 O O O O O O 000 i
O O O O O 0 0 O 0 0
IN
I
N N Ci 3
w�
W N iD O N
W O � W ONO A O
A ? to
N
i
,ZI
�a N
o A o 0
N N ao
A Ogo I
N
0 0 0 of
I
N N N
i N ICI
N y W
V tJ� IJ A
� I
N w W C p
a m
�N A
A t0 A �D fwli O O O J � ry ',
J J O O
J p P A
CD
0
3 n c
�C O
a? �
I
3 o N
f a 3
a �
� m 3
Cn
O
c
City Brooklyn Center
z'"
Sanitary Sewer Fund Cash Flow Analysis
Rate Increase 1.00% 1.00% 3.00% 3.00% 4.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5:00% 0.00% 0.00% 0.00•% 0.00%
Monthly Residential Fee $ 21.08 $ 21.29 $ 21.93 $ 22.59 $ 23.49 $ 24.66 $ 25.90 $ 27.19 $ 28.55 $ 29.98 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Pr
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues
Sewer Charges $ 3,315,597 $ 3,320,205 $ 3,372,185 $ 3,480,278 $ 3,619,489 $ 3,800,464 $ 3,990,487 $ 4,190,011 S 4,399,512 S 4,619,487 S 4,85,462 $ 4,850,462 S 4,850,462 $ 4,850,462 $ 4,850,462 $
Bond Proceeds $ - $ 573,141 S - $ - $ - $ - $ - S - $ - 5 - $ - S - $ - $ - S - $
Misc.Operating $ - $ 1,168 $ 122,737 $ - $ - $ - $ - $ - $ - $ - $ - S - $ - S - $ - $
Misc.Non-operating $ 26,045 $ 6,287 $ 14,793 $ 12,000 $ 5,000 $ 5,000 S 3,560 $ 2,043 S 1,468 $ 2,215 $ 3,142 $ 3,066 $ 2,468 $ 2,356 $ 6,769 $
Total Revenues $ 3,341,642 S 3,900,801 $ 3,509,715 $ 3,492,278 $ 3,624,489 $ 3,805,464 $ 3,994,047 $ 4,192,054 $ 4,398,044 $ 4,617,272 $ 4,847,319 $ 4,847,396 S 4,847,994 $ 4,852,817 $ 4,857,230 $
Expenditures
Personal Services $ 161,746 $ 191,382 $ 179,791 S 195,532 $ 197,115 $ 200,349 $ 208,363 S 216,697 $ 225,365 S 234,380 $ 243,755 $ 253,505 $ 263,646 $ 274,191 $ 285,159 $
Supplies $ 8,606 $ 13,829 $ 11,592 $ 35,450 $ 63,540 S 27,465 $ 28,289 $ 29,138 S 30,012 $ 30,912 $ 31,839 $ 32,795 $ 33,778 $ 34,792 $ 35,836 $
Services $ 3,005,243 $ 2,454,867 S 2,48,603 S 2,312,825 S 2,501,518 S 2,585,847 $ 2,663,422 $ 2,743,325 $ 2,825,625 $ 2,910,394 $ 2,997,705 $ 3,087,637 $ 3,180,266 $ 3,275,674 $ 3,373,944 S
Depreciation $ 550,108 $ 584,169 $ 604,837 $ 677,763 $ 728,770 S 801,647 $ 825,696 $ 850,467 $ 875,981 $ 902,261 $ 929,329 $ 957,208 $ 985,925 $ 1,015,502 $ 1,045,968 S
Debt Service Interest 8 Fees $ $ 31,567 $ 21,046 $ 21,310 $ 17,834 S 16,615 S 14,706 S 13,447 $ 12,716 $ 10,806 S 9,913 $ 8,963 $ 6,910 $ 4,957 S 3,575 S
Total Expenditures $ 3,725,703 $ 3,275,814 S 3,297,869 S 3,242,880 $ 3,508,777 $ 3,631,923 $ 3,740,477 $ 3,853,074 $ 3,969,699 S 4,088,752 $ 4,212,542 $ 4,340,108 $ 4,470,524 $ 4,605,116 $ 4,744,481 $
less:Non-Cash Depreciation $ 550,108 $ 584,169 $ 604,837 $ 677,763 $ 728,770 S 801,647 $ 825,696 $ 850,467 $ 875,981 $ 902,261 $ 929,329 S 957,208 $ 985,925 $ 1,015,502 $ 1,045,968 $
plus:Debt Service Principal $ - $ - $ 33,750 $ 33,750 $ 35,000 S 37,500 S 38,750 $ 40,000 $ 41,250 $ 42,500 $ 45,000 $ 45,000 $ 47,500 S 50,000 $ 50,000 $
plus:Transfers $ - $ 16,292 $ - $ - $ - $ - S - $ - $ - $ - $ - $ - $ - $ - $ - S
plus:Cash Capital Outlay $ 428,648 $ 1,089,773 S 1,644,339 $ 50,000 $ 1,330,000 $ 1,540,000 S 1,420,000 $ 2,027,000 $ 1,450,000 S 1,620,000 S 1,500,000 $ 1,270,000 S 110,000 $ 110,000 $ 200,000 $
Total Cash Requirement $ 3,604,243 $ 3,797,710 $ 4,371,121 $ 2,648,867 $ 4,145,007 $ 4,407,776 $ 4,373,530 $ 5,069,607 $ 4,584,968 $ 4,848,992 $ 4,828,213 $ 4,697,900 S 3,642,100 $ 3,749,614 $ 3,948,514 $
Beginning Cash Balance S 2,191,302 S 1,972,466 S 2,076,043 $ 1,169,534 $ 2,012,945 $ 1,492,427 $ 890,115 S 510,632 $ (366,922) $ (553,846) S (785,566) S (766,460) $ (616,963) $ 588,931 $ 1,692,134 S
Changes in Assets/Liabilities $ 43,765 $ 486 S (45,103) S - $ - $ - $ - $ - $ - $ - $ - $ - $ - S - $ - S
Cash Received $ 3,341,642 $ 3,900,801 S 3,509,715 S 3,492,278 $ 3,624,489 $ 3,805,464 $ 3,994,047 $ 4,192,054 S 4,398,044 $ 4,617,272 $ 4,847,319 $ 4,847,396 S 4,847,994 S 4,852,817 S 4,857,230 S
Cash Spent $ 3,604,243 $ 3,797,710 $ 4,371,121 $ 2,648,867 $ 4,145,007 S 4,407,776 S 4,373,530 $ 5,069,607 S 4,584,968 S 4,848,992 $ 4,828,213 $ 4,697,900 S 3,642,100 $ 3,749,614 S 3,948,514 $
Ending Cash Balance S 1,972,466 $ 2,076,043 $ 1,169,634 $ 2,012946 $ 192.427 $ 890 115 $ 510 632 5 (366,922) $ (663,846) $ (785,566) $ (766,460) $ (616,963) $ 588,931 $ 1,692 134 $ 2,600,851 $
Cash Reserve Target $ 950,000 $ 950,000 S 950,000 S 950,000 $ 950,000 $ 950,000 S 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 S 950,000 $ 950,000 $ 950,000 $ 950,000 $
Cash Reserve Target(3%lyr) S 950,000 $ 978,500 $ 1,007,855 $ 1,036,091 $ 1,069,233 $ 1,101,310 $ 1,134,350 S 1,168,380 $ 1,203,432 $ 1,239,535 S 1,276,721 $ 1,315,022 S 1,354,473 S 1,395,107 $ 1,436,960 $
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items.
Revenues
Rate increases would be as indicated per year and are based on a stable customer base with stable usage.
Expenditures
Personnel costs increase at a rate of 41%per year
Supplies increase at a rate of 3%per year.
Serices increase at a rate of 3%per year
Depreciation increases at a rate of 3%per year
Capital outlay is from the 2013 CIP
2013 Utility Rates&Cash Flows
O
O
E �
d
j 3 r
€ 1
E I
0
U
E
°o
O N N
a O M
o r r m
o �a
v D]
K
o e ay e e e
c a m
"mS
S
0
o 6 M O
a I ° m
IR
y
y o
a j
G m
K
I
I
< O V V r 8 T N
} i N N N
6 M O A T
a 3 ,
vQ
a
mET
000' °o
O r N N
O M M
m N
I
v m rn N vri itri o ° m r b .r-
T
0 0 I_ O H r N r
C •-
« E
N m m n
w a o m
-
a
N �
I
z
Z
O F NO y W W
F w w Z W U U
Q� 7 = Z W Z Z
W Z Z a Z (all F F O W C¢i' R'
W W (n ❑ ❑ W O W
O V Q ❑ W W W O F O W W W W Z Z d W W W W d } (7 N O
Q F- W ❑ _ ❑ _ ❑ }}7 N U U U N O Z Z Z Z
F ZQ ❑ ❑ O a a W w U C7 F CL W W w W ❑ W �' F K K O O LL } w W_ O O a O
= K ¢ Q a w W W Z Z W F Z °_ d' w = w F H m vi m m U' C7 w a w F m
W W w W z z z K rwn N Q U W N °° O W O O H Z w w 0 z ❑w K w z z Q W H N vai a W W O z
W a > > a G Q W W 0 to W O W > W N Z Z z 2 U J � � 3 L o x oa 47 a Q a � � ❑ ❑ W > � U
f/J C7 0RU''' C9 O o a a N R N K (n O J J 4 J w 7 O fn N !y U Z ❑ ❑ d h O
O S ~ W = S S w w W W w W W S W Z U U U U a W d' K OW F O ❑ = W W W W W W W W W W U U
y a H H N H z w O (� fn UJ N W a 0 0 0 a a a W W F !- W W a > a a Q W r H U
o o 0 0 ? U o n ❑ d 3 N m U z o o 3 0 3 n o o a -
m o o M o m o o S o N LL
C N N O ry
a a e o v a v v a v v v v a v o v v c
o�
0
N
Q U O O j co
N U d
� c v
oc
U
m o a°
Z 2 av v m F m d af
` N O t d
C N M N
N N `3
E 01 m w
N C 9 m N V R
w EN E Qc°v eNn ei
0 0 0 0 a o o o o 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0
O i
C h r b O O O `(al H Y1 ro Mn O O O N O �tOI N Obi A '
p O m O
� r 1n
N N
y W r �-
O>j
N �m
1 0 b r r M N N o O O O N o 0 16 O m m 0
M O 1p M O o C V m 0 0 0 0 O N � Nm 14 6
N m C
16 16 6 6 O O
C 0 N 0 O 0 00 N N 0 o yy N N o O O N O ci O m O M O O 6
N n N N N h N O
00
yO1'
N O
m 3
N
rl: I
l
O N N O N N
n r t� N N o
v °v o o co 1n m gym' in vO1i v c°n 1N+1 r °
y A N I
a�
E�
m¢
a
a
m
0o Oo °o Oo 0 00
°o 00
16 n 0
0 0 o c o 0 0 0 0 0 0 '
1 N O O w O
c N
O
V1 1� m m h N h N a0 0 0 h
N—�
NIL m
O M M N
a a 0 r
Y1 N O O1 N O A O IV
115 1.; 1� n N
N N N
OV O N r 1� � OI ap
N N m m ' .- r 1+i M b c
� �O
NaE
a
I
O O r F 433i m or0 t00 100 N N O Nro O lr0 O r O O
h N Y1
YI r O O L<l O lM O
V m m M N ^ M ! N N O M
h cN]
O m
o i
Q
a
0
N
I
F
N N Z W
z m m W W
O J W = _ F L N
rn N F W Q d V- f Z a a W
z z U a a o Q w U
D u O O m zp O w �'w m W w a w w w W W !
Q m c�
w U U U U z W'
K K O ~ Z Z Z W W W W Z W W w a Q d a W O Z z K K K O
U LL U a Z z w w w cQi rn
0 Q w w w w w w d a r '� '- 1- w F w °� g W m v> m Z O z0 m
m m 0 0 0 w w K U -1 W N N F z z z m m t- ° U ¢ ¢ Q z
Z Z a W W O 0 U m J a LL a a p O c9 Q Qa Q Q a a J J M j Z Z Z Q Q a
w W U U !n u� !� U W > > W 2 E U 2 0 0 0 O O O D U X
w Z Z d fL a' Z Z tll � Z N N FZ- h N1 w M � d U O 0 W W Q z W On w N w O z Z W
W W w Q W w W W m O W W F K LL K W M f/1 (� 41 U` U J
O O Q W J J U' W w w Q W
F" 1n N 0 0 0 K K LL O Q U u. z W w p¢. = d p¢, Z o Q Q a a U U 0 O O O m w -
w W Q W W O F LL w W 2 a F W F- W W J 7 U a' j K W' a' O O O .
K U ? z 3 d a O m N o 0 C9 O O M K O K w 2E 0 N N M Q Q
ON N N � m 0 0 0 N N � M O V O OV Oml T O 0 0 N N N N
i O i0 N N �0 O tp O L� l0 t0 1D � co t0 t0 � i0 t0 1p t0 (O b 1D (O t0 c0 10 t0 10
E ch
Q o c m H m E N
- 07
(6
a rn 3 -
rn
E a� o° ma
p
=r m n m
u 6)W °
w H o c a
2- _
p= m E m
o O o o o b oo o o oo oo a oo oo o o'. o o o
6 6 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 cs 6 0 0
N O N r
N O O M
cli t O
_ O_ O
O m O O N r 1(O] N to N ,
d m
��(0 V ' O c•1 V N N V V
J
N w_
I
O O -o 1. O 1. O 0 0 0 O O pp
h N O ° t O N n r V V
h N O N M O r n
v a 14 In L' m In m
J V
N Q J
y Q)
i
I
r O O n m O H O O
O O Oi Oi ^ P
F O N N N N V N O m m Ol O f0 (h m M A O16 f O V O
T n r N N Of a O O P r iD O m O� OI V V
E u n
u
vQ
a
fA
0 0 0 0 0 0 0 0 0
o
In in N ° oo °o a v a
o C �
c m Is o b
N
O N
14 N F r r r O mn O O m O m N ro 0 I O N N n nV] r Oi b O N O O 10 N N m CI
N
N V' W
OJ
¢Q
I
M O O O -R N N O O N N
N O V N V < m "'.
e N N f� n N O O O r O G b fV N V r n O
N m m O O O O
rz
N O mN b V
O A j N N N
O
i
i
a
J
w
w y
w Z
y Z d
W W Z
O U w y y W y
U Z Z j y y w w w w W w y W
O Q Z F y W w twi w w y p f.'! w w' y > > O W
Q ¢ y F U U OW N Z y w U` a ¢ > y m W W = fwn ) W w ''..
z z a a r w w y Z z - p = Q u v w z o t=- Uo a a w 0
0 0 F F W y w w a F y LW U x W w y w p o p x x F
O O w O O m w Z Z U W J U 7 0 VI y fn w Z F ¢ �. O W O Z O Z 2 O
K K FO-- z z Q Q a W W d W w w w m O 2 Z d IL � K w < 0 Q 3 LL y uai N w O O � U OR
o w o F z z z Q 2Q zQ' ¢ v > > w w x v v aKJ y "�� LL = v v a
Z Z Q W W Z Z Z w W O W Q ¢ LL y w w y U U w W W U O Q g F ? W F Z Z W K K W W
Q Q C7 > > Z N y x d a 0 W y w y y x S x w W R R Z Z � O Z y Q ¢
w w w O O K w F w w 0 0 F F F D X W W w W 0 )-- w of w y W W x F
? ? O w w y N N O O 0 0 LL w w U U Q y 0 2 F F- Q O O w O ',..
0 O
O° � � i
O
V V �) N � N O N N N M M V V
0
E N
m
IL
T
S
d
E
o
U
i
a
U _
0 0
N �
O O O
O O�
4 b
d 0 N N V
N Qm
°
K
N M M O N
mm �v w c n
M
N m C
O �
M N
v r O O O n
c�ma
n M o
�-
mm
m -i
r M ni r
ma
c
M
0 6 o O
N N
V O It N
N tL m
O m
N N N N
O O �
N¢E
¢
N Of V
O A
c a
r]=O M
N Q
U)
W 0 N
u W W N
a° zN UV } w. m0 00
W w w Z a_ U w W w W
N w
m e6
f Q Y } > } T Z U H OS' W 1x1 w W
0:.� x z ro z F F � F a a w z U U w w z z
N.= x z p 0 0 0 z w W w Q � z.H w w
U O W W ¢ J J 2 W w W w W 0 �
a: rt > z a ¢ a ¢ a m m u m z z z z
W W W d F a- m w m w Z r r W W w W
T = x a a a a a z x z = > m m a m > >
¢ ¢ ¢ ¢ O r O r ¢ w w x x w w
O O O w ? d o U O m o m o a O O w w CY R'
cO m
City of Brooklyn Center
Z5,7
Storm Sewer Fund Cash Flow Analysis
Rate Increase 3.00% 1.00% 1.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Per Residential Lot 14.19 14.34 14.48 14.48 14.48 14.48 14.48 14.48 14.48 14.48 14.48 14.48 14.48 14.48 14.48
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues
Storm Sewer Fees $ 1,577,679 $ 1,575,529 $ 1,587,721 $ 1,597,370 - $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370
Misc. Operating $ - $ - $ 33,383 $ - $ - $ - $ - $ - $ - $ _ $ - $ _ $ _ $ _ $ _
Misc. Non-operating $ 26,255 $ 4,901 $ 23,080 $ 18,000 $ 10,000 $ 10,000 $ 12,492 $ 12,409 $ 12,166 $ 11,957 $ 9,100 $ 8,382 $ 7,125 $ 10,126 $ 13,036
Total Revenues $ 1,603,934 $ 1,580,430 $ 1,644,184 $ 1,615,370 $ 1,607,370 $ 1,607,370 $ 1,609,862 $ 1,609,779 $ 1,609,536 $ 1,609,327 $ 1,606,470 $ 1,605,752 $ 1,604,495 $ 1,607,496 $ 1,610,406
Expenditures
Personal Services $ 66,003 $ 126,349 $ 169,543 $ 168,270 $ 186,205 $ 189,258 $ 198,721 $ 208,657 $ 219,090 $ 230,044 $ 241,546 $ 253,624 $ 266,305 $ 279,620 $ 293,601
Supplies $ 10,351 $ 4,371 $ 6,110 $ 28,800 $ 29,540 $ 29,915 $ 30,812 $ 31,737 $ 32,689 $ 33,670 $ 34,680 $ 35,720 $ 36,792 $ 37,895 $ 39,032
Services $ 343,296 $ 327,562 $ 260,632 $ 282,565 $ 311,609 $ 301,888 $ 310,945 $ 320,273 $ 329,881 $ 339,778 $ 349,971 $ 360,470 $ 371,284 $ 382,423 $ 393,895
Depreciation $ 858,450 $ 866,647 $ 939,433 $ 1,056,862 $ 1,101,744 $ 1,175,000 $ 1,210,250 $ 1,246,558 $ 1,283,954 $ 1,322,473 $ 1,362,147 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011
Debt Service Interest&Fees $ - $ - $ - $ - $ - $ - $ - $ - $ $ $ $ $ $ $
Total Expenditures $ 1,278,100 $ 1,324,929 $ 1,375,718 $ 1,536,497 $ 1,629,098 $ 1,696,061 $ 1,750,728 $ 1,807,224 $ 1,865,614 $ 1,925,964 $ 1,988,344 $ 2,052,825 $ 2,077,392 $ 2,102,950 $ 2,129,540
less:Non-Cash Depreciation $ 858,450 $ 866,647 $ 939,433 $ 1,056,862 $ 1,101,744 $ 1,175,000 $ 1,210,250 $ 1,246,558 $ 1,283,954 $ 1,322,473 $ 1,362,147 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011
plus:Cash Transfer to GF $ 100,000 $ 100,000 $ - $ - $ - $ - $ - $ _ $ _ $ _ $ _ $ _ $ _ $ - $ _
plus: Debt Service Principal $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ _ $ _ $ _ $ _
plus:Transfers $ - $ $ - $ - $ $ - $ - $ _ $ _ $ _ $ _ $ _ $ _ $ $ _
plus: Cash Capital Outlay $ 1,015,061 $ 581,239 $ 975,744 $ 560,000 $ 1,148,000 $ 1,296,000 $ 1,090,000 $ 1,110,000 $ 1,080,000 $ 1,720,000 $ 1,160,000 $ 1,270,000 $ 180,000 $ 180,000 $ 140,000
Total Cash Requirement $ 1,534,711 $ 1,139,521 $ 1,412,029 $ 1,039,635 $ 1,675,354 $ 1,817,061 $ 1,630,478 $ 1,670,667 $ 1,661,660 $ 2,323,491 $ 1,786,197 $ 1,919,814 $ 854,381 $ 879,938 $ 866,529
Beginning Cash Balance $ 1,929,535 $ 2,143,141 $ 2,666,111 $ 2,824,851 i $ 3,400,586 $ 3,332,602 $ 3,122,911 $ 3,102,295 $ 3,041,407 $ 2,989,283 $ 2,275,118 $ 2,095,392 $ 1,781,329 $ 2,531,444 $ 3,259,001
Changes in Assets/Liabilitles $ 144,383 $ 82,061 $ (73,415) $ - $ - $ - $ - $ - $ _ $ - $ _ $ _ $ _ $ _ $ _
Cash Received $ 1,603,934 $ 1,580,430 $ 1,644,184 $ 1,615,370 $ 1,607,370 $ 1,607,370 $ 1,609,862 $ 1,609,779 $ 1,609,536 $ 1,609,327 $ 1,606,470 $ 1,605,752 $ 1,604,495 $ 1,607,496 $ 1,610,406
Cash Spent $ 1,534,711 $ 1,139,521 $ 1,412,029 $ 1,039,635 $ 1,675,354 $ 1,817,061 $ 1,63Q478 $ 1,670,667 $ (1,661,660) $ 2,323,491 $ 1,786,197 $ 1,919,814 $ 854,381 $ 879,938 $ 866,529
Ending Cash Balance $ 2,143,141 $ 2,666,111 $ 2,824,851 $ 3 400,588 $ 3,332,602 $ 3,122,911 $ 3,102,295 $ 3,041,407 $ 2,989,283 $ 2,275 118 $ 2,095 392 $ 1,781,329 $ 2,531,444 $ 3,259,001 $ 4,002 878
Cash Reserve Target $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation with no provisions made for changes in balance sheet terns that may
affect cash balances.
Revenues
Rate increase reflect additions to the gross income based on ordinance charges
Expenditures
Personnel Costs increase at a rate of 5%per year.
Supplies and Services increase at a rate of 3%per year.
Capital outlay is from the 2013 CIP
2013 Utility Rates&Cash Flows
M
o O
r= �
r m
o m
E _ d v
o
U i z
o m n z
�N n
U m°
`
mc
v a°i
w o 0
O O 6 IS 6 6 6 6 0 0
V N N N N N
M t b N N N
I
N N O rp
O n N T
v m i N N M n �
(D c
°o o °o °o ° °0o
cl; o. o 6 0 0 ci
n N N Iq N N
m No r r N N ry
NSW ,
i
i
N N N O 0 0 O 0 0
Q j ' 0 0 6 6 4 o [m0 p 0 O o o cd N N O o N O O O
a ,
Ea
a
N I
°o °o °o °o
c 16 16 o 6 6 6 0 0
M N N N
O
m
N N
m N N m y cl e} m O
O r
° n m
E
a
m n m b b r N
vi v 6 i 4 °o o o ° 6 6 ,ri 16 Id
m
ry Q E I
a
a
N
I
F O N W W Z Z
? W W W W W W
Z
Z (a9 Q O G O Z Z p O w n- j U
p a
12 W w ~ 7 O J 7 U , 7 N N w U U N W, W a O a lJJ W- N
a w Q lwi. w W W W W w Z O w N ] (n ~ W J 7 CL W N O U_ U U_
M w a - z v~i W w w W z > F J (w ? j o W W Q a a 0 o z J z > > >
O w W, J w z W W
M W W W W Z 0 0 0 0 F H F- H o W W U U m 7 z z j N v� a Q
0 N N a 0 0 w w W W W x x x z w W W z z a } d a Q Q a a J at z z z
cn to w o w > Z z Z z vl U—' C7 U_' O X W M Q a . vl w a a a f s 0 0 U 0 0 0
a a r n w ¢ a a a w H J p z z > > > w 9
f N d J J 7 y LL W W b a W N c5 ^0 O O O N y a Z V1 U1 f�
W C a Y a W W W W W W W W a O z z W W Z z w p W W fL W J J w J C9 W w W w
N a d ~ S Z F N N N W a a Q W W F f W W U a U LL S d a a a d pa, U U 0 0 0
cn ? U O f E a 3 rn N U C7 0' W o o W o 0 a O rc W2� ¢ ¢ a a a
N o O O Orni T O N rn O r o � , O� NO o
0 0 O O M � M m - O V m OI O
u w m .. . . . b m m . . o
I m III
�R °
d N
�a�
c9 c z
o
ac>o
m U c c t N
a M m o
0
y (O O 0 0 0 0 0 O o O O O O O Q O O O 0 O N O 0 1 0 0 G 1 M
6 6 l O m 0
N N N O o m M M 001
°m �
a
o >
N vm
K
I
e -g a e
° °o °O o °o 0o a Li
r n m o o r
M m Op 0 0 O O o M M iri N N N N
N[D C
O 0 0 O 0 0 O O 6 0 O O O
O O O O O C O O O O M
e n
M M M ni n n n c
cc
16 L'i d
i
VM1 It O O
❑ � b r r m m M M N N < < ` O CI M tp � O O
ar i
E u
d¢ i
a
N j
0 0 0 0 0 0
0 c; a o a o o.
O O o
0 o O o m o
� i°(J N O O O O N N N N M
m r
r I
I� f• f` I (V N n
I� N N a c n° r°
<m O M M M O
Id M
NQE
¢
m C V V V O O O N N N N N N r
b � T Of N N 00 N ON m b N T ON
O O N N N N m m Q H H N n m m
0 < <
O '
NQE
a
U)
U)
w
LL
U N U K W W W W N N
Q W Z Z > N N W W F" N N LL Z Z
H U_ U_
O O t' J N U O tl N U CL K W W O d LL >
WQ Q V N N Z W W N N W X X
U Z W > � W W Q Q' F = S Z Z In W W W W
N N W d C U Q W W Z N O W 0 H 0 LL a �
p L N Q O O U ❑ i>-- W W rd F N U U U4 W W W U ❑ W W O U w W N } Y }
< t"' W Q a O ❑ ¢1 > > N R Z Z wU' -f LL Z Z �, w Q Q ZO =O W Z Q F Q
U U X 0 2 K Q ¢ J W W LL K F d `� W W Z d pW, z (n N LL U U Q Q W 7 j
W Z Z W F O O (� (7 U' Z Q ZQ U O! W W oC S U U W W f- Q W W Q G W G U U W O O D
Q rL W U N y F F F K F H a S K K N K K K fL K Z tF- U V) W W Z ft d' K �' >O a H Q uj
y >4 W Q Q Z Z Z Z 7 O J J J j 2 d a (� M y = M S U Q ¢ d m m S S x x a a a
O O O IL W' ae tY K W N !- 1- O F W W O F I- F O N K K W W X F- /- F- I- n- Q ¢ Q
? ? W O O O Q F 1- ❑ ❑ w 0 0 0 0 U U U
I N N N 0 N N .- O � O Om N 01 O O N N �N} V O yyI I� aNO ° p h Oai Oyaf O O p T m N M O O O
cMO t0 t0 10 . . . (MO HMO . . b m m m tap . ta0 1aO taD taD a tad ta0 fO N � (�O �C t�0 tD � tP0 10 tN9 tN0 l� (�O tm0 t�D
M
O
M �
N
c0
CL
E
U
0
v e
m
N >>
P[0
K i
� e
d N N
J
N m
O N
v r
0 0 0
N
mm I '
K
I
< N I
N N
O m
o
N
B N
d a
d
N I
N N pl O
N L m
O M
N N
C c °>
rQE )
¢ i
N m a
m m
m
v
H
o > > M
0
NQE
¢
N
9 u N N n N
o¢ N N N N
z z Z Z
W w W W
a a d a
> w w w w
J N N ❑ z
F W W Z Z
Fz z z
z z z z
n a a > >
U w w w
0 0
m co m v a
City Brooklyn Center
Street Light Utility Fund Rate Analysis
Rate Increase 2.00% 3.00% 3.00% 25.26% 2a18% 10,00% 3.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.0091. 0.00%
Quarterly Rate per Dwelling U 3.73 3.84 3.95 4.95 5.95 6.55 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected F
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues
Street Light Fee $ 253,754 $ 258,535 $ 272,510 $ 334,626 $ 402,369 $ 442,369 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $
Misc.Operating $ - $ - $ 18,378 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $
Misc. Non-operating $ 1,067 $ 416 $ 6,913 $ 1,000 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $
Total Revenues $ 254,821 $ 258,951 $ 297,801 $ 335,626 $ 402,869 $ 442,869 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $
Expenditures
Personal Services $ - $ - $ - $ - $ - $ - $ $ - $ - $ $ - $ - $ - $ - $ - $
Supplies $ 839 $ 466 $ 749 $ 2,560 $ 2,780 $ 2,500 $ 2,575 $ 2,652 $ 2,732 $ 2,814 $ 2,898 $ 2,985 $ 3,075 $ 3,167 $ 3,262 $
Services $ 213,615 $ 207,719 $ 203,616 $ 221,380 $ 226,733 $ 236,893 $ 242,815 $ 248,886 $ 255,108 $ 261,486 $ 268,023 $ 274,723 $ 281,591 $ 288,631 $ 295,847 $
Depreciation $ 5,566 $ 5,567 $ 28,370 $ 32,000 $ 33,600 $ 36,900 $ 37,638 $ 313,391 $ 39,159 $ 39,942 $ 40,741 $ 41,555 $ 42,387 $ 43,234 $ 44,099 $
Debt Service or Transfer $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
- - - - - - - - - - - - - - -
Total Expenditures $ 220,020 $ 213,752 $ 232,735 $ 255,940 $ 263,113 $ 276,293 $ 283,028 $ 289,929 $ 296,998 $ 304,241 $ 311,661 $ 319,264 $ 327,053 $ 335,032 $ 343,208 $
Capital Outlay/Transfers $ $ 92,835 $ 125,442 $ 232,000 _ $ 110,000 $ 60,000 $ 215,000 $ 260,000 $ 317,000 $ 130,000 $ 90,000 $ 170,000 $ 15,000 $ 60,000 $ 170,000 $
Total Cash Requirement $ 220,020 $ 306,587 $ 358,177 $ 487,940 $ 373,113 $ 336,293 $ 498,028 $ 549,929 $ 613,998 $ 434,241 $ 401,661 $ 489,264 $ 342,053 $ 395,032 $ 513,208 $
Beginning Cash Balance $ 72,996 $ 117,678 $ 76,729 $ 10,808 $ (109,506) $ (46,150) $ 97,326 $ 93,076 $ 37,678 $ (81,022) $ (19,181) $ 76,038 $ 84,470 $ 240.,944 $ 345,286 $
Changes in Assets/Liabilities $ 4,315 $ 1,120 $ (33,915) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $
Revenues $ 254,821 $ 258,951 $ 297,801 $ 335,626 $ 402,869 $ 442,869 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $
Expenditures $ (220,020) $ (306,587) $ (358,177) $ (487,940) $ (373,113) $ (336,293) $ (498,028) $ (549,929) $ (613,998) $ (434,241) $ (401,661) $ (489,264) $ (342,053) $ (395,032) $ (513,208) $
Depreciation Add-Back $ 5,566 $ 5,567 $ 28,370 $ 32,000 $ 33,600 $ 36,900 $ 37,638 $ 38,391 $ 39,159 $ 39,942 $ 40,741 $ 41,555 $ 42,387 $ 43,234 $ 44,099 $
Ending Cash Balance $ 117,678 $ 76,729 $ 10,808 $ 109,506 $ 46,150 $ 97,326 $ 93,076 $ 37,678 $ 81,022 $ 19,181 $ 76,038 $ 84,470 $ 240,944 $ 345,286 $ 332,317 $
Cash Reserve Target $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $
Assumptions:
Cash basis
All assumptions are predicted on Cash Basis presentation with no provisions made for changes in balance sheet
items that may occur from year to year.
Revenues
Rate increases are based on customer count of 8,415 residential customers and 538 others.
Expenditures
Supplies and Services increase at a total rate of 3%per annum.
Depreciation increases at a rate of approximately 2%per annum.
Capital outlay is from the 2013 CIP
N
O
U)
m
€ t
C
d _
0
U
I
E
` _ N
� rn
a° a°
o °o
m m A o a e
c a
N m=
a li
o �a
m
K
p o e cmi N o o N o 0 0
1- y n1 N b N h
> m
y n e r r n m
EQ
a
N
0 o O ti
m m.
N N
N p N
N LL m
y R M O O O O O M M
R N Cl i N O O N O fV
N > r N
E
u E
N r r ° e a
v
NQE
a im'
o z z
W W
_ ¢ N y z a ? U U
n u O W W W W Z Z W W w 7 7 O O K
O¢ W ~ 7 7 7 7 W U U a O W > W N 0 Z Z
LL W W W W W LL y 7 7 N 7 � w to U U U w ¢ ¢ N
U C7 W W W W p w 0 0 W f7 0 Z > > >
C7 z K W K Z U 7 z Z w K K a a Y
Z N > D 7 0 7 Y W O 7 W W U U W N w J�Ll °b otl `Y. N U J
000 �O—., 0 0 �
¢ (� W O W O W �— , l LL W 2' Z Z d a a LL J ~ Z Z Z F- H W ¢ ¢ ❑ ❑ M
�2 W O ❑W > Z Z Z Z M '� C7 0 U' d eE ¢ ¢ U N d K a a 2 0 o ❑ 0 0 0 Q ¢ x F- F Z Z ¢ W W
U N a N LL a J a J J 7 Z Z J O p W LL 7 7 N Z N N OU O W W Q fn M N O Z Z w a ¢O. O O (7 ¢ K
u W U W W U U U U ¢ w > T } LL j W W W W U U V J J LL 1 LL lwi lwi f > Z Z H Z Z w
W r W K S N N N y Z U U U LL S 2 > > ¢ LL LL Z Q ¢ d a U O O O N > ¢ ¢ ¢ Z Z Z Z O 7
? o f a 3 tt o o rc o r~ii o o N v7i y ¢ a a a a °u rte- a s ate. z
O N '
1 m 0 0 N m O n n n h N O O P O . . N N . . N m 0 O . N N M n
co �o co . ao m �o m m e
N
� O
Is N
— d 3
E a m m
U
d N d
� EcO1Z �
-
w m x x 3 0
❑=w `
O Y y Z m
m m c m
°o °o
0 6 o io 00 0
O>
N p m
U
U N M O m N N m
fO c
O
O m
O O N
cli � o 0 n
d
Cl Cl IG 001 O
N H �R
a� i •- N N °'
u
Q
o, I
y I
i
o 0 0 0
i M 1D � N N CI M a
M fV N ap b Cl
N OD
N LL m
O O D C1
V y
O [p Oi Oi
N M V
ra iA N
11 V
N
O ! N N
rQE
N N i0 t0 N M
O
NQE
Q
I
a
p i
y �
i
I I
i
W
LL
Iri le
y
W Z
U
j y
W y y y
0) W W w W
d V W W H y y
O¢ W LL W W 7 =
LL y O w �
W w W Z W Z W Z Z
W W
N y d d d d
Z W U m w w O O w y W W w W
w U U w W W ❑ O
W Z Z > Z Z N 0
N ❑
W Z Q y y L ? ¢ Q
¢ W O X X 2e d'
x ¢ Q F F y y
O D U w W w w U V w w
U > > y w LL O O > >
N W W W W W Z Z Z W W W W W W
C9 m m x S x . ¢ Q x x d d > >
� N N w W w K
N N y Ny V V t� r r N m 0 0 0 0
�
t0 f0 tD O (p 10 O V
I
too
c � O 1- O Cl) N N (N r N h c)
It O d' (O � d' d- N IT It N O t�
p Cn aa) M O ' co M ' ' LO ' LO LO ' M LO ' M O
~_ O Lr Ln L6 Ln Ln M U5 L!) M O I It
M O O M M co Cl) M M M co
•O N `.
0-
64 64 69 H-T 64 64 69 64 64 64 69-60- 61) 69 6-k 6S 69 64 6S
c � O tt V' LO a) O t- It G N O
pp 0 M O M O O M (0 LO M (0 N O
O It O ' e- ' (O t� ' � W O
' It t- ' LO
(vj () O LO Lt) Lr ' LLB LI7 M Lf) Ln M O
O O M M N N N N co N M I'
'p N M co M co M M Cl)
d
63 69 64 69 64 EA 64 64 64 69 69 69 63 63 69 64 64 60- 64
N a ® O- LO N 00 N N 00 LO O
C) O 4) M O oc ' N ' N M ' M C\! ' 00 O
Lr)M O O O Ldp ' N O O M LO N 0
•O N Cl) co M M co co Cl)
69 64 63 69 64 64 69 63 64 69 69 64 64 64 WA 6} 63 69 69
c a M O O LO 'mot 0) 0) O 6 00 O
p (O O O LLB - (.0 (0 M O O N O
p 00 'I O It O O O O V O ' M O
(vj U � M M I) 0 V If O O O O O O - 0 m O -
N M co M co M co M co M M Cl)M L
tl 63646469 w 64646464 w 0%64 w w w w61),64 w 0)
C
c 00 a d' O O L() LC) L() 00 't L(j r O U
p O O O LO tl- N N M O N M O >
p M � M M O i M O ' ' M M - ' � O U
M O N LC) t` t` OD ' M v t` 00 .*r O O
0-0 O O O O O O O It Of
O N Cl) co N N N M N C:
OL
w 69 E3 64 64 64 w 64 64 64 69 64 64 69 69 69 64 69 64 N
° � C
o r f� M M M N M 00 O =
p0 00 N 0) ' G) ' ' LO ' � ' OO r- ' � LO ' M O E
C O N O N O N M N O M 4 O O N N N N m 00 00 00 00 co N
4)
69 69 64 69 64 64 69 64 64 64 64 64 69 64 w 69 64 64 64
CO
(B
o M (0 O O - W N O N O U
O N N co p N h w O
' '
a)o0 @ M O
N
7 00 O 'ct m M`-'O I+ O U
U O r O 00 00 00 O c0 d'
(A Q N N N N N N N N N
N 64 64 64 69 64 69 69 69 69 69 69 69 64 64 69 64 64 69 64 C N
c N t- e-- 00 O co .= 00 O 0
L = p LO LO 0 0 M 00 M t` LO 00 Cl) O O a) O
(D Q CO N O O ' O ' N ' ' M ' M c, N O M ' CA O - O_ E
C 0) ((j O M M 00 00 00 co 00 OA O o N
0) U O co 00 r t- r 00 t- o
U Q N N N N N N N N a) ce)
Ln -
>.. 64 64 69 69 64 69 69 69 69 69 64 69 69 64 64 64 ER 69 64 Q
Y 0 _
O LL \ N O LLB ti 00 M V(O W t� O
0 �, N d' (O m LO L() LO M y LC) M O N O N
m O p r- N O M ' M ' O ' ' O ' O M N M O Cl) O m O T
M r 'LO (0 (o ti (fl V' o M i -fl
9, CUT1 U N N N N N N N .rN. (n a
Q
U [L 64 64 69 64 64 w 64 64 64 64 64 64 64 64 61} 64 69 E4 64 c N
O @
a
U U N
Q
Q1? C L6 Y Q) ++ a) N
v E L6 U V 0) (n N
U) � m
d N 7 m a f4 (0 c N
N O N to 'V 0) Q m 0) C U) N Z
U) (D a) c a c ? c a m LL @ Q (n c s g aa) a
N LL O O 3 (n O •U O 7 L U c a) O 0) O ,fn 7 0 a) N
L T y O N > ±+ Z a (n O'- O V W �, to E = (6 w
U L C Q- O O rn O •L6 O R c Ln C .- (0 0) C. N E U) N
c m OZof c c .� U U) w U c a> ,a� @
0)
0 > (j (3 �p 0) U) Q.- � � � c C N N � � C O z 'n O fa L U
a+ > U (n C. Q O_ •fl-++ •� ft5 > Q as N N o N C. Q In 0)
m o wacnC000 UH a) -C U QUQ w (n v �
2013-14 Joint Budget Meeting
October 15, 2012
Responsibly provide for the maintenance and
operations of the following in a quality, cost
effective manner:
120 miles of city streets
•
520 acres of parks and other natural areas
•
67 miles of trails and sidewalks
•
Municipal-owned buildings and grounds
•
Storm drains and treatment facilities
•
All aspects of water and sewer operations
•
Public Works Department is responsible for:
1.Engineering
2.Street Maintenance
3.Park Maintenance
4.Public Utilities (water, sanitary sewer, storm
sewer and street lighting)
5.Central Garage
6.Building Capital Maintenance Projects
2
2013-14 BC PW Utilities Budget, 10/15/12
3
2013-14 BC PW Utilities Budget, 10/15/12
Utilities
Water Utility: 1.3 billion gal/yr
supplied to customers from 9
wells, 3 water towers
Sanitary Sewer Utility:
Conveyance of 850 million
gal/yr of wastewater
Storm Drainage Utility:
Maintain approx. 85 miles of
drainage pipes, 30+ ponds,
storm sewer structures
Street Light Utility: Coordinate
operation of 1300 street lights
4
2013-14 BC PW Utilities Budget, 10/15/12
1.Meet or exceed safe drinking water standards
of the State of Minnesota and manage storm
water runoff in an efficient and
environmentally sensitive manner.
2.Initiate improved, streamlined management
strategies and techniques by use of refined
methods and technologies.
5
2013-14 BC PW Utilities Budget, 10/15/12
6
2013-14 BC PW Utilities Budget, 10/15/12
Continue annual well rehabilitation
Replace Supervisory Control and
Data Acquisition (SCADA) computers
and software
Implementation of 2013 Capital
Improvements Projects
Develop certain Standard Operating
Procedures where needed
Wellhead Protection Plan update
Local Water Resources Plan update
7
2013-14 BC PW Utilities Budget, 10/15/12
8
2013-14 BC PW Utilities Budget, 10/15/12
Monday, 15 October 2012
A
Finance Utility with Rate Changes Only
Rate Increase8.00%9.00%12.00%15.00%15.00%15.00%15.00% (8.00%) (8.00%) (8.00%) (8.00%)
Rate/1,000 gallons 1.51 1.65 1.85 2.12 2.44 2.81 3.23 2.97 2.73
2.51 2.31
BudgetProposedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
20122013201420152016201720182019202020212022
Revenues
Water Service$ 2,204,708$ 2,368,682$ 2,652,924$ 3,050,862$ 3,508,492$ 4,034,766$ 4,639,980$ 4,268,782$ 3,927,279$ 3,613,097$ 3,324,049
Bond Proceeds$ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Misc. Operating$ - $ 3,700$ 7,400$ 11,100$ 14,800$ 18,500$ 22,200$ 25,900$ 29,600$ 33,300$
37,000
Misc. Non-operating$ 12,000$ 81,331$ 64,429$ 47,107$ 44,493$ 32,327$ 5,620$ 36,633$ 63,487$ 80,582$
128,899
Total Revenues$ 2,216,708$ 2,453,713$ 2,724,753$ 3,109,070$ 3,567,785$ 4,085,593$ 4,667,801$ 4,331,315$ 4,020,366$ 3,726,979$ 3,489,948
Expenditures
Personal Services$ 478,177 $ 494,914 $ 502,193 $ 517,259 $ 532,777 $ 548,760 $ 565,223 $ 582,179 $ 599,645 $ 617,634 $
636,163
Supplies$ 175,650 $ 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 $ 200,746 $ 206,768 $ 212,971 $ 219,360 $ 225,941
Services$ 678,023 $ 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 $ 767,917 $ 798,634 $ 830,579 $ 863,803 $ 898,355
Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884
New Interest
Debt Service Interest & Fees$ 63,928$ 62,185$ 60,185$ 57,571$ 54,575$ 51,031$ 46,910$ 42,347$ 37,354$
31,867$ 23,903
Total Expenditures$ 2,086,336$ 2,196,139$ 2,132,451$ 2,194,893$ 2,259,075$ 2,324,903$ 2,392,423$ 2,461,846$ 2,533,265$ 2,606,697$ 2,680,246
less: Non-Cash Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034
$ 895,884
New Principal
plus: Debt Service Principal$ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 $ 112,750 $ 116,250 $ 116,250 $ 120,000 $ 123,750
$ 131,250
plus: Transfers$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
plus: Cash Capital Outlay$ - $ 1,420,000$ 1,800,000$ 1,650,000$ 2,378,000$ 3,330,000$ 1,937,000$ 1,690,000$ 1,650,000$ 260,000 $
140,000
Total Cash Requirement$ 1,497,028$ 3,017,109$ 3,302,157$ 3,196,216$ 3,973,306$ 4,975,822$ 3,634,046$ 3,436,179$ 3,450,549$ 2,116,414$ 2,055,612
Beginning Cash Balance$ 1,991,361$ 2,711,041$ 2,147,645$ 1,570,241$ 1,483,095$ 1,077,573$ 187,344 $ 1,221,099$ 2,116,235$ 2,686,052$ 4,296,617
Changes in Assets/Liabilities$ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ -
Cash Received$ 2,216,708$ 2,453,713$ 2,724,753$ 3,109,070$ 3,567,785$ 4,085,593$ 4,667,801$ 4,331,315$ 4,020,366$ 3,726,979$ 3,489,948
Cash Spent$ (1,497,028)$ (3,017,109)$ (3,302,157)$ (3,196,216)$ (3,973,306)$ (4,975,822)$ (3,634,046)$ (3,436,179)$ (3,450,549)$ (2,116,414)$ (2,055,612)
Ending Cash Balance$ 2,711,041$ 2,147,645$ 1,570,241$ 1,483,095$ 1,077,573$ 187,344 $ 1,221,099$ 2,116,235$ 2,686,052$ 4,296,617$ 5,730,953
B
Finance by Adjusting Rates and Using Minimal Debt
Rate Increase8.00%9.00%9.00%9.00%9.00%9.00%9.00%0.00%0.00%0.00%0.00%
Rate/1,000 gallons 1.51 1.65 1.80 1.96 2.13 2.33 2.54 2.54 2.54
2.54 2.54
BudgetProposedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
20122013201420152016201720182019202020212022
Revenues
Water Service$ 2,204,708$ 2,368,682$ 2,581,863$ 2,814,231$ 3,067,512$ 3,343,588$ 3,644,511$ 3,644,511$ 3,644,511$ 3,644,511$ 3,644,511
Bond Proceeds$ - $ - $ - $ - $ 1,500,000$ - $ - $ - $ - $ -
Misc. Operating$ - $ 3,700$ 7,400$ 11,100$ 14,800$ 18,500$ 22,200$ 25,900$ 29,600$ 33,300$
37,000
Misc. Non-operating$ 12,000$ 81,331$ 64,429$ 44,975$ 35,198$ 9,524$ 6,398$ 1,787$ 3,220$ 1,556$
19,517
Total Revenues$ 2,216,708$ 2,453,713$ 2,653,693$ 2,870,307$ 3,117,510$ 4,871,612$ 3,673,109$ 3,672,198$ 3,677,331$ 3,679,367$ 3,701,028
Expenditures
Personal Services$ 478,177 $ 494,914 $ 502,193 $ 517,259 $ 532,777 $ 548,760 $ 565,223 $ 582,179 $ 599,645 $ 617,634 $
636,163
Supplies$ 175,650 $ 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 $ 200,746 $ 206,768 $ 212,971 $ 219,360 $ 225,941
Services$ 678,023 $ 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 $ 767,917 $ 798,634 $ 830,579 $ 863,803 $ 898,355
Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884
New Interest$ 42,750$ 38,250$ 32,250$ 14,250
Debt Service Interest & Fees$ 63,928$ 62,185$ 60,185$ 57,571$ 54,575$ 51,031$ 46,910$ 42,347$ 37,354$
31,867$ 23,903
Total Expenditures$ 2,086,336$ 2,196,139$ 2,132,451$ 2,194,893$ 2,259,075$ 2,324,903$ 2,435,173$ 2,500,096$ 2,565,515$ 2,620,947$ 2,680,246
less: Non-Cash Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034
$ 895,884
New Principal$ 150,000 $ 150,000 $ 250,000 $ 950,000
plus: Debt Service Principal$ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 $ 112,750 $ 116,250 $ 116,250 $ 120,000 $ 123,750
$ 131,250
plus: Transfers$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
plus: Cash Capital Outlay$ - $ 1,420,000$ 1,800,000$ 1,650,000$ 2,378,000$ 3,330,000$ 1,937,000$ 1,690,000$ 1,650,000$ 260,000 $
140,000
Total Cash Requirement$ 1,497,028$ 3,017,109$ 3,302,157$ 3,196,216$ 3,973,306$ 4,975,822$ 3,826,796$ 3,624,429$ 3,732,799$ 3,080,664$ 2,055,612
Beginning Cash Balance$ 1,991,361$ 2,711,041$ 2,147,645$ 1,499,181$ 1,173,271$ 317,475 $ 213,265 $ 59,578$ 107,348 $ 51,880$
650,583
Changes in Assets/Liabilities$ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ -
Cash Received$ 2,216,708$ 2,453,713$ 2,653,693$ 2,870,307$ 3,117,510$ 4,871,612$ 3,673,109$ 3,672,198$ 3,677,331$ 3,679,367$ 3,701,028
Cash Spent$ (1,497,028)$ (3,017,109)$ (3,302,157)$ (3,196,216)$ (3,973,306)$ (4,975,822)$ (3,826,796)$ (3,624,429)$ (3,732,799)$ (3,080,664)$ (2,055,612)
Ending Cash Balance$ 2,711,041$ 2,147,645$ 1,499,181$ 1,173,271$ 317,475 $ 213,265 $ 59,578$ 107,348 $ 51,880$ 650,583 $ 2,296,000
C
Finance by Issuing Debt and Stabilizing Rates
Rate Increase8.00%7.00%7.00%6.00%6.00%6.00%6.00%6.00%6.00%0.00%0.00%
Rate/1,000 gallons 1.51 1.62 1.73 1.83 1.95 2.06 2.19 2.32 2.46
2.46 2.46
BudgetProposedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
20122013201420152016201720182019202020212022
Revenues
Water Service$ 2,204,708$ 2,359,038$ 2,524,170$ 2,675,620$ 2,836,158$ 3,006,327$ 3,186,707$ 3,377,909$ 3,580,584$ 3,580,584$ 3,580,584
Bond Proceeds$ - $ - $ - $ - $ 3,330,000$ - $ - $ - $ - $ -
Misc. Operating$ - $ 3,700$ 7,400$ 11,100$ 14,800$ 18,500$ 22,200$ 25,900$ 29,600$ 33,300$
37,000
Misc. Non-operating$ 12,000$ 81,331$ 64,140$ 42,947$ 28,950$ (3,852)$ 37,403$ 15,386$ 4,717$ (287)$
27,532
Total Revenues$ 2,216,708$ 2,444,069$ 2,595,710$ 2,729,667$ 2,879,908$ 6,350,975$ 3,246,309$ 3,419,195$ 3,614,901$ 3,613,597$ 3,645,115
Expenditures
Personal Services$ 478,177 $ 494,914 $ 502,193 $ 517,259 $ 532,777 $ 548,760 $ 565,223 $ 582,179 $ 599,645 $ 617,634 $
636,163
Supplies$ 175,650 $ 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 $ 200,746 $ 206,768 $ 212,971 $ 219,360 $ 225,941
Services$ 678,023 $ 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 $ 767,917 $ 798,634 $ 830,579 $ 863,803 $ 898,355
Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884
New Interest$ 96,150$ 88,650$ 81,150$ 69,900$ 51,150
Debt Service Interest & Fees$ 63,928$ 62,185$ 60,185$ 57,571$ 54,575$ 51,031$ 46,910$ 42,347$ 37,354$
31,867$ 23,903
Total Expenditures$ 2,086,336$ 2,196,139$ 2,132,451$ 2,194,893$ 2,259,075$ 2,324,903$ 2,488,573$ 2,550,496$ 2,614,415$ 2,676,597$ 2,731,396
less: Non-Cash Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034
$ 895,884
New Principal$ 250,000 $ 250,000 $ 250,000 $ 500,000 $ 750,000
plus: Debt Service Principal$ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 $ 112,750 $ 116,250 $ 116,250 $ 120,000 $ 123,750
$ 131,250
plus: Transfers$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
plus: Cash Capital Outlay$ - $ 1,420,000$ 1,800,000$ 1,650,000$ 2,378,000$ 3,330,000$ 1,937,000$ 1,690,000$ 1,650,000$ 260,000 $
140,000
Total Cash Requirement$ 1,497,028$ 3,017,109$ 3,302,157$ 3,196,216$ 3,973,306$ 4,975,822$ 3,980,196$ 3,774,829$ 3,781,699$ 2,686,314$ 2,856,762
Beginning Cash Balance$ 1,991,361$ 2,711,041$ 2,138,001$ 1,431,554$ 965,005 $ (128,394) $ 1,246,759$ 512,873 $ 157,240 $ (9,558)$
917,724
Changes in Assets/Liabilities$ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ -
Cash Received$ 2,216,708$ 2,444,069$ 2,595,710$ 2,729,667$ 2,879,908$ 6,350,975$ 3,246,309$ 3,419,195$ 3,614,901$ 3,613,597$ 3,645,115
Cash Spent$ (1,497,028)$ (3,017,109)$ (3,302,157)$ (3,196,216)$ (3,973,306)$ (4,975,822)$ (3,980,196)$ (3,774,829)$ (3,781,699)$ (2,686,314)$ (2,856,762)
Ending Cash Balance$ 2,711,041$ 2,138,001$ 1,431,554$ 965,005 $ (128,394) $ 1,246,759$ 512,873 $ 157,240 $ (9,558)$ 917,724 $
1,706,078
D
Shift Water Tower Painting Forward Five Years
Rate Increase8.00%7.00%7.00%7.00%7.00%7.00%6.00%4.00%0.00%0.00%0.00%
Rate/1,000 gallons 1.51 1.62 1.73 1.85 1.98 2.12 2.25 2.34 2.34
2.34 2.34
BudgetProposedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
20122013201420152016201720182019202020212022
Revenues
Water Service$ 2,204,708$ 2,368,682$ 2,534,490$ 2,711,904$ 2,901,737$ 3,104,859$ 3,291,150$ 3,422,796$ 3,422,796$ 3,422,796$ 3,422,796
Bond Proceeds$ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Misc. Operating$ - $ 3,700$ 7,400$ 11,100$ 14,800$ 18,500$ 22,200$ 25,900$ 29,600$ 33,300$
37,000
Misc. Non-operating$ 12,000$ 81,331$ 64,429$ 43,554$ 30,664$ 34,021$ 10,368$ 18,068$ 18,986$ 19,611$
26,250
Total Revenues$ 2,216,708$ 2,453,713$ 2,606,319$ 2,766,558$ 2,947,202$ 3,157,380$ 3,323,719$ 3,466,765$ 3,471,382$ 3,475,707$ 3,486,046
Expenditures
Personal Services$ 478,177 $ 494,914 $ 502,193 $ 517,259 $ 532,777 $ 548,760 $ 565,223 $ 582,179 $ 599,645 $ 617,634 $
636,163
Supplies$ 175,650 $ 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 $ 200,746 $ 206,768 $ 212,971 $ 219,360 $ 225,941
Services$ 678,023 $ 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 $ 767,917 $ 798,634 $ 830,579 $ 863,803 $ 898,355
Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884
New Interest
Debt Service Interest & Fees$ 63,928$ 62,185$ 60,185$ 57,571$ 54,575$ 51,031$ 46,910$ 42,347$ 37,354$
31,867$ 23,903
Total Expenditures$ 2,086,336$ 2,196,139$ 2,132,451$ 2,194,893$ 2,259,075$ 2,324,903$ 2,392,423$ 2,461,846$ 2,533,265$ 2,606,697$ 2,680,246
less: Non-Cash Depreciation$ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034
$ 895,884
New Principal
plus: Debt Service Principal$ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 $ 112,750 $ 116,250 $ 116,250 $ 120,000 $ 123,750
$ 131,250
plus: Transfers$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
plus: Cash Capital Outlay$ - $ 1,420,000$ 1,800,000$ 1,650,000$ 1,240,000$ 2,300,000$ 1,370,000$ 1,690,000$ 1,650,000$ 1,398,000$
1,170,000
Total Cash Requirement$ 1,497,028$ 3,017,109$ 3,302,157$ 3,196,216$ 2,835,306$ 3,945,822$ 3,067,046$ 3,436,179$ 3,450,549$ 3,254,414$ 3,085,612
Beginning Cash Balance$ 1,991,361$ 2,711,041$ 2,147,645$ 1,451,807$ 1,022,149$ 1,134,045$ 345,603 $ 602,276 $ 632,862 $ 653,695 $
874,988
Changes in Assets/Liabilities$ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ -
Cash Received$ 2,216,708$ 2,453,713$ 2,606,319$ 2,766,558$ 2,947,202$ 3,157,380$ 3,323,719$ 3,466,765$ 3,471,382$ 3,475,707$ 3,486,046
Cash Spent$ (1,497,028)$ (3,017,109)$ (3,302,157)$ (3,196,216)$ (2,835,306)$ (3,945,822)$ (3,067,046)$ (3,436,179)$ (3,450,549)$ (3,254,414)$ (3,085,612)
Ending Cash Balance$ 2,711,041$ 2,147,645$ 1,451,807$ 1,022,149$ 1,134,045$ 345,603 $ 602,276 $ 632,862 $ 653,695 $ 874,988 $ 1,275,423
ABCD
Current CIP PlanCurrent CIP Plan
Current CIP Planfinanced withfinanced withAdjusted CIP Plan
financed solely withcombination rate adjustlower rate increases andposponing tower painting
rate adjustmentsand minimal debtand more debt financingand financing with rates
2013 Rate1.651.651.621.62
2027 Rate1.522.182.462.34
Maximum Rate3.232.542.462.34
Total 15 year Cost *$ 2,425.68$ 2,458.80$ 2,403.36$
2,347.92
2027 Cash Reserve$ 5,305,629.00$ 5,125,351.00$ 4,223,912.00$ 3,768,454.00
* (18,000 gallons/quarter at stated rate)Maximum difference$ 1.85 per quarter
$ 7.40 per year
$ 111.00 over 15 years
Water Rates per 1,000 Gallons
3.50
3.00
2.50
Dollars per 1,00 gallons
2.00
1.50
1.00
0.50
0.00
201320142015201620172018201820202021202220232024202520262027
ABCD
Rate Increase3.00%4.00%5.00%5.00%5.00%5.00%5.00%5.00%0.00%0.00%
Monthly Residential Fee$ 22.59$ 23.49$ 24.66$ 25.90$ 27.19$ 28.55$ 29.98$ 31.48$ 31.48$
31.48
BudgetProposedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
2012201320142015201620172018201920202021
Revenues
Sewer Charges$ 3,480,278$ 3,619,489$ 3,800,464$ 3,990,487$ 4,190,011$ 4,399,512$ 4,619,487$ 4,850,462$ 4,850,462$ 4,850,462
Bond Proceeds$ - $ - $ - $ - $ - $ - $ - $ - $ - $
-
Misc. Operating$ - $ - $ - $ - $ - $ - $ - $ - $ - $
-
Misc. Non-operating$ 12,000$ 5,000$ 5,000$ 3,560$ 2,043$ (1,468)$ (2,215)$ (3,142)$ (3,066)$
(2,468)
Total Revenues$ 3,492,278$ 3,624,489$ 3,805,464$ 3,994,047$ 4,192,054$ 4,398,044$ 4,617,272$ 4,847,319$ 4,847,396$ 4,847,994
Expenditures
Personal Services$ 195,532 $ 197,115 $ 200,349 $ 208,363 $ 216,697 $ 225,365 $ 234,380 $ 243,755 $ 253,505 $ 263,646
Supplies$ 35,450$ 63,540$ 27,465$ 28,289$ 29,138$ 30,012$ 30,912$ 31,839$ 32,795$ 33,778
Services$ 2,312,825$ 2,501,518$ 2,585,847$ 2,663,422$ 2,743,325$ 2,825,625$ 2,910,394$ 2,997,705$ 3,087,637$ 3,180,266
Depreciation$ 677,763 $ 728,770 $ 801,647 $ 825,696 $ 850,467 $ 875,981 $ 902,261 $ 929,329 $ 957,208 $ 985,925
Debt Service Interest & Fees$ 21,310$ 17,834$ 16,615$ 14,706$ 13,447$ 12,716$ 10,806$ 9,913$ 8,963$
6,910
Total Expenditures$ 3,242,880$ 3,508,777$ 3,631,923$ 3,740,477$ 3,853,074$ 3,969,699$ 4,088,752$ 4,212,542$ 4,340,108$ 4,470,524
less: Non-Cash Depreciation$ 677,763 $ 728,770 $ 801,647 $ 825,696 $ 850,467 $ 875,981 $ 902,261 $ 929,329 $ 957,208 $
985,925
plus: Debt Service Principal$ 33,750$ 35,000$ 37,500$ 38,750$ 40,000$ 41,250$ 42,500$ 45,000$ 45,000$
47,500
plus: Transfers$ - $ - $ - $ - $ - $ - $ - $ - $ - $
-
plus: Cash Capital Outlay$ 50,000$ 1,330,000$ 1,540,000$ 1,420,000$ 2,027,000$ 1,450,000$ 1,620,000$ 1,500,000$ 1,270,000$ 110,000
Total Cash Requirement$ 2,648,867$ 4,145,007$ 4,407,776$ 4,373,530$ 5,069,607$ 4,584,968$ 4,848,992$ 4,828,213$ 4,697,900$ 3,642,100
Beginning Cash Balance$ 1,169,534$ 2,012,945$ 1,492,427$ 890,115 $ 510,632 $ (366,922) $ (553,846) $ (785,566) $ (766,460) $
(616,963)
Changes in Assets/Liabilities$ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
Cash Received$ 3,492,278$ 3,624,489$ 3,805,464$ 3,994,047$ 4,192,054$ 4,398,044$ 4,617,272$ 4,847,319$ 4,847,396$ 4,847,994
Cash Spent$ (2,648,867)$ (4,145,007)$ (4,407,776)$ (4,373,530)$ (5,069,607)$ (4,584,968)$ (4,848,992)$ (4,828,213)$ (4,697,900)$ (3,642,100)
Ending Cash Balance$ 2,012,945$ 1,492,427$ 890,115 $ 510,632 $ (366,922) $ (553,846) $ (785,566) $ (766,460) $ (616,963) $
588,931
Cash Reserve Target$ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000
Cash Reserve Target (3%/yr)$ 1,038,091$ 1,069,233$ 1,101,310$ 1,134,350$ 1,168,380$ 1,203,432$ 1,239,535$ 1,276,721$ 1,315,022$ 1,354,473
Rate Increase0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Per Residential Lot14.4814.4814.4814.4814.4814.4814.4814.4814.4814.4814.48
BudgetProposedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjectedProjected
20122013201420152016201720182019202020212022
Revenues
Storm Sewer Fees$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370$ 1,597,370
Misc. Operating$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
Misc. Non-operating$ 18,000$ 10,000$ 10,000$ 12,492$ 12,409$ 12,166$ 11,957$ 9,100$ 8,382$ 7,125$
10,126
Total Revenues$ 1,615,370$ 1,607,370$ 1,607,370$ 1,609,862$ 1,609,779$ 1,609,536$ 1,609,327$ 1,606,470$ 1,605,752$ 1,604,495$ 1,607,496
Expenditures
Personal Services$ 168,270 $ 186,205 $ 189,258 $ 198,721 $ 208,657 $ 219,090 $ 230,044 $ 241,546 $ 253,624 $ 266,305 $
279,620
Supplies$ 28,800$ 29,540$ 29,915$ 30,812$ 31,737$ 32,689$ 33,670$ 34,680$ 35,720$ 36,792$ 37,895
Services$ 282,565 $ 311,609 $ 301,888 $ 310,945 $ 320,273 $ 329,881 $ 339,778 $ 349,971 $ 360,470 $ 371,284 $ 382,423
Depreciation$ 1,056,862$ 1,101,744$ 1,175,000$ 1,210,250$ 1,246,558$ 1,283,954$ 1,322,473$ 1,362,147$ 1,403,011$ 1,403,011$ 1,403,011
Debt Service Interest & Fees$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
Total Expenditures$ 1,536,497$ 1,629,098$ 1,696,061$ 1,750,728$ 1,807,224$ 1,865,614$ 1,925,964$ 1,988,344$ 2,052,825$ 2,077,392$ 2,102,950
less: Non-Cash Depreciation$ 1,056,862$ 1,101,744$ 1,175,000$ 1,210,250$ 1,246,558$ 1,283,954$ 1,322,473$ 1,362,147$ 1,403,011$ 1,403,011$
1,403,011
plus: Cash Transfer to GF$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
plus: Debt Service Principal$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
plus: Transfers$ - $ - $ - $ - $ - $ - $ - $ - $ - $
- $ -
plus: Cash Capital Outlay$ 560,000 $ 1,148,000$ 1,296,000$ 1,090,000$ 1,110,000$ 1,080,000$ 1,720,000$ 1,160,000$ 1,270,000$ 180,000 $
180,000
Total Cash Requirement$ 1,039,635$ 1,675,354$ 1,817,061$ 1,630,478$ 1,670,667$ 1,661,660$ 2,323,491$ 1,786,197$ 1,919,814$ 854,381 $ 879,938
Beginning Cash Balance$ 2,824,851$ 3,400,586$ 3,332,602$ 3,122,911$ 3,102,295$ 3,041,407$ 2,989,283$ 2,275,118$ 2,095,392$ 1,781,329$ 2,531,444
Changes in Assets/Liabilities$ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ -
Cash Received$ 1,615,370$ 1,607,370$ 1,607,370$ 1,609,862$ 1,609,779$ 1,609,536$ 1,609,327$ 1,606,470$ 1,605,752$ 1,604,495$ 1,607,496
Cash Spent$ (1,039,635)$ (1,675,354)$ (1,817,061)$ (1,630,478)$ (1,670,667)$ (1,661,660)$ (2,323,491)$ (1,786,197)$ (1,919,814)$ (854,381) $ (879,938)
Ending Cash Balance$ 3,400,586$ 3,332,602$ 3,122,911$ 3,102,295$ 3,041,407$ 2,989,283$ 2,275,118$ 2,095,392$ 1,781,329$ 2,531,444$ 3,259,001
Rate Increase2.00%3.00%3.00%25.26%20.18%10.00%3.00%0.00%0.00%0.00%0.00%
Quarterly Rate per Dwelling Unit3.733.843.954.955.956.556.746.746.746.746.74
ActualActualActualBudgetProposedProjectedProjectedProjectedProjectedProjectedProjected
20092010201120122013201420152016201720182019
Revenues
Street Light Fee$ 253,754$ 258,535$ 272,510$ 334,626$ 402,369$ 442,369$ 455,640$ 455,640$ 455,640$ 455,640$ 455,640
Misc. Operating$ -$ -$ 18,378$ -$ -$ -$ -$ -$ -$ -$ -
Misc. Non-operating$ 1,067$ 416 $ 6,913$ 1,000$ 500 $ 500 $ 500 $ 500 $ 500 $
500 $ 500
Total Revenues$ 254,821$ 258,951$ 297,801$ 335,626$ 402,869$ 442,869$ 456,140$ 456,140$ 456,140$ 456,140$ 456,140
Expenditures
Personal Services$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
Supplies$ 839 $ 466 $ 749 $ 2,560$ 2,780$ 2,500$ 2,575$ 2,652$ 2,732$ 2,814$
2,898
Services$ 213,615$ 207,719$ 203,616$ 221,380$ 226,733$ 236,893$ 242,815$ 248,886$ 255,108$ 261,486$ 268,023
Depreciation$ 5,566$ 5,567$ 28,370$ 32,000$ 33,600$ 36,900$ 37,638$ 38,391$ 39,159$ 39,942$ 40,741
Debt Service or Transfer$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
-
Total Expenditures$ 220,020$ 213,752$ 232,735$ 255,940$ 263,113$ 276,293$ 283,028$ 289,929$ 296,998$ 304,241$ 311,661
Capital Outlay/Transfers$ -$ 92,835$ 125,442$ 232,000$ 110,000$ 60,000$ 215,000$ 260,000$ 317,000$ 130,000$ 90,000
Total Cash Requirement$ 220,020$ 306,587$ 358,177$ 487,940$ 373,113$ 336,293$ 498,028$ 549,929$ 613,998$ 434,241$ 401,661
Beginning Cash Balance$ 72,996$ 117,678$ 76,729$ 10,808$ (109,506)$ (46,150)$ 97,326$ 93,076$ 37,678$ (81,022)$ (19,181)
Changes in Assets/Liabilities$ 4,315$ 1,120$ (33,915)$ -$ -$ -$ -$ -$ -$ -$
-
Revenues$ 254,821$ 258,951$ 297,801$ 335,626$ 402,869$ 442,869$ 456,140$ 456,140$ 456,140$ 456,140$ 456,140
Expenditures$ (220,020)$ (306,587)$ (358,177)$ (487,940)$ (373,113)$ (336,293)$ (498,028)$ (549,929)$ (613,998)$ (434,241)$ (401,661)
Depreciation Add-Back$ 5,566$ 5,567$ 28,370$ 32,000$ 33,600$ 36,900$ 37,638$ 38,391$ 39,159$ 39,942$
40,741
Ending Cash Balance$ 117,678$ 76,729$ 10,808$ (109,506)$ (46,150)$ 97,326$ 93,076$ 37,678$ (81,022)$ (19,181)$ 76,038
Rate Increase3.00%6.00%2.00%0.00%3.00%3.00%3.00%3.00%3.00%
Quarterly Residential Rate7.808.278.438.438.688.949.219.499.77
ActualActualActualBudgetProposedProjectedProjectedProjectedProjected
200920102011201220132014201520162017
Revenues
Recycling Fee$ 267,316$ 283,057$ 278,893$ 289,927$ 302,394$ 311,466$ 320,810 $ 330,434$ 340,347
Misc. Operating$ -$ -$ 11,126 $ -$ 5,000$ 5,000$ 5,000$ 5,000$ 5,000
Misc. Non-operating$ 25$ 1 $ 20$ -$ -$ -$ - $ -$ -
Total Revenues$ 267,341$ 283,058$ 290,039$ 289,927$ 307,394$ 316,466$ 325,810 $ 335,434$ 345,347
Expenditures
Personal Services$ -$ -$ -$ -$ -$ -$ - $ -$ -
Supplies$ 61$ 90$ -$ -$ 150$ 155 $ 159$ 164 $ 169
Services$ 275,997$ 278,291$ 284,441$ 286,503$ 297,975$ 306,914$ 316,122 $ 325,605$ 335,373
Depreciation$ -$ -$ -$ -$ -$ -$ - $ -$ -
Debt Service$ -$ -$ -$ -$ -$ -$ - $ -$ -
Total Expenditures$ 276,058$ 278,381$ 284,441$ 286,503$ 298,125$ 307,069$ 316,281 $ 325,769$ 335,542
Capital Outlay/Transfers$ -$ -$ -$ -$ -$ -$ - $ -$ -
Total Cash Requirement$ 276,058$ 278,381$ 284,441$ 286,503$ 298,125$ 307,069$ 316,281 $ 325,769$ 335,542
Beginning Cash Balance$ (4,354)$ (14,337) $ (9,938)$ (7,762)$ (4,338)$ 4,931$ 14,328$ 23,857$ 33,522
Changes in Assets/Liabilities$ (1,266)$ (278)$ (3,422)$ -$ -$ -$ - $ -$ -
Revenues$ 267,341$ 283,058$ 290,039$ 289,927$ 307,394$ 316,466$ 325,810 $ 335,434$ 345,347
Expenditures$ (276,058)$ (278,381)$ (284,441)$ (286,503)$ (298,125)$ (307,069)$ (316,281) $ (325,769)$ (335,542)
Depreciation Add-Back$ -$ -$ -$ -$ -$ -$ - $ -$ -
Ending Cash Balance$ (14,337) $ (9,938)$ (7,762)$ (4,338)$ 4,931$ 14,328$ 23,857$ 33,522$ 43,327
Cash Reserve Target$ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000$ 40,000$ 40,000$ 40,000
Water Rate: 7.00% to 9.00%
Sanitary Sewer Rate:4.00%
Storm Sewer Rate:0.00%
Street Light Rate:20.18%
($ 1.00/quarter)
Recycling Rate:3.00%
Single Family Residential Quarterly Bill
7.00% Water9.00% Water
201220132013
Water (18,000 gallons)$ 28.90$ 30.92$ 31.50
Sanitary Sewer$ 67.76$ 71.16$ 71.16
Storm Sewer$ 14.48$ 14.48$ 14.48
Street Lights$ 4.95$ 5.95$ 5.95
Recycling$ 8.43$ 8.68$ 8.68
TOTAL per quarter$ 124.52$ 131.19$ 131.77
TOTAL per month$ 41.51$ 43.73$ 43.92
Increase per Month $$ 2.12$ 2.31
Increase per Month %5.10%5.56%
18,000 Gallons of Water per Quarter in 2011
$90.00
$84.46
$78.12
$80.00
$75.42
$68.35
$70.00
$60.00
$54.71
$48.60
$50.00
$37.60
$40.00
$31.92
$30.00
$26.74
$23.68
$20.00
$10.00
$-
White BearBrooklynFridleyShoreviewRichfieldMaplewodRosevilleCrystalGolden ValleyNew Hope
LakeCenter
18,000 Gallons of Sanitary Sewer per Quarter in 2011
$90.00
$78.14
$80.00
$75.66
$68.40
$70.00
$66.60
$66.03
$65.79
$62.00
$60.00
$50.00
$46.75
$46.20
$40.00
$34.07
$30.00
$20.00
$10.00
$-
FridleyCrystalRosevilleGolden ValleyBrooklynMaplewodRichfieldWhite BearShoreviewNew Hope
CenterLake
Residential Lot Stormwater per Quarter for 2011
$25.00
$22.00
$20.00
$18.90
$15.97
$14.48
$15.00
$10.96
$9.90
$10.00
$6.75
$5.71
$5.00
$3.63
$-
FridleyMaplewodRosevilleCrystalRichfieldBrooklyn CenterShoreviewNew HopeGolden Valley
Residential Street Light Charge per quarter for 2011
$8.00
$7.29
$7.00
$6.00
$6.00
$5.00
$4.20
$3.95
$4.00
$3.15
$3.00
$2.00
$1.00
$-
New HopeBrooklyn CenterCrystalGolden ValleyShoreview
Residential Recycling Rate per Quarter for 2011
$12.00
$10.65 $10.65
$10.00
$8.43
$8.00
$8.00
$7.04
$6.66
$6.00
$6.00
$4.00
$2.00
$-
RosevilleMaplewodFridleyGolden ValleyBrooklyn CenterNew HopeCrystal