5.4. ERMUSR 05-10-2005Ji
Elk River -~-~
Municipal Utilities
13069 Orono Parkway
Elk River, MN 55330
May 2, 2005
To: Elk River Municipal Utilities Commission
Jerry Takle
John Dietz
Jim Tralle
From: Br}pan Adams
Subject: Cash Flow Projections
phone: 763.441.2020
Fax: 763.941.8099
At last months' commission meeting, our auditors presented the results of their annual
utility audit. One of their comments was that staff continue the cash flow studies which
project future revenues and expenses to ensure we have adequate financial resources to
carry on business. Attached for your review are the updated Springstad cash flow studies
for both the electric and water departments. These studies are updated twice annually,
once after the audit and again during the budgeting process.
The result of this study is consistent with past studies, that being; our cash reserve
continues to rise with time for both departments. The trend is in the right direction. If
this trend is correct, we will be able to start funding from cash reserves for some of our
larger projects instead of bonding.
One trend we need to look at more closely is the rate of increase of the general and
administrative area. Both the electric and water departments are increasing faster than
the other areas.
~ W
Q
h
o ~, m v Q
U m a a
M N a v o m o o
~ Q M
~ M O
L a~
~ M (0 Q
N T Q
Q~ Q Q
O
j
Q c ~ O ~ ~ ~ N yN~ ~ ~ ^ ~ ~ ~ ~
In m mr N ~ UJ ~ N' ~ r ~ +
~ ina cn ~~~
N ~ O Q t0 O (O O a~
r In h 0 O) O I(7 M (O U'7 Q O c0 (O (O Q~ Q~
In m 6) h N 01 Q r N D) r
h N O N O O O
m ~n M ffl lI~ O O
~n O c0 h r cp
to rn u~ r m
O ~ `O N N 1~ O M
m O Q
'
O r N 4) M m Q O m~ Q
M m~ O M N m m h M
m h I~ O N O
M m Q m O N
m N Q r O r
~O M f0 O m
d )
N M O l(
Q m r M O~ M m N M Oi
f
A 1~ M M r 0 m N N Q
r r m EA fA
N M fH m~ r~
fl ~_ ~ fA (
fA
M m
N M fA fA fA ~ Q Q r m O
r N ~ Q
EA fA (fl E9 fA EA fA EA ffl fA fA
N Q 0 0 m 0 m O m In h M O m N 0 Q) I~ r m h O h O 0 0 0 O N h N m
O O I~ O O m 0 h
N m Q N m 0 0 m h r 0 h Q7 m N h r
0 O Q m (D O M h M Q M
m N O N E9 O fA
~ LL"1 m O 0
O 0 m In M m
O O r h m
O N O h 1f7 O1 0 N
M~ N m N N m m M h m m
m
M U ~- O ~L1 Q to ~ ~
m m m Q
0 0~
r r h Q ~ m r m
N O Q
]
N M 1(') EA ~- (A fA N m
m m N a n
M r Q ~(1
In _
O Q m
1f1 ~ O m m
N fA fA rj 69 M ~ EA fA N EA fA fA ffl V3 fA ~ N ~ M
(A fA EA fA fA fA fA fA
M ifl _m _mO mOm
O O 01 0 N tn Nmmm U'1 Q t(')~A00
N m Q m O N N m m h 0
M N OU7 O OO
M O m fA 0 0 O O 1nhM0
O N 1(1 I~
O
r N O O M N m O m
M M M - O m
m~ m O M M h M m Q m N m
m M 0 m to m m h r Q)
0 m O r O O
O h m 0 0 O
0 O M r O r
0 M m ~ h
Z M O Q
~~ 1n Q m ~ M m N In _m M M N
O fA 1n mO fA fA fAN Q)
to 01 (O h 0 0
Q m LL'1 N 0
h O 1n O
h O m O m
N V3 fA ~ fA fA ~ fA (H N fA fA EA M r _ _ ~ ~ N
fA M EA Efl (H EA fA fA EA EA
N N N m~ O m m m N Q Q N ~ O Q 1~ '- N O In O 0 0 0 O N 1~ M O
O
O h 1~ M r m O ~
m m N Q O m h r M M h m O m h M
O O Q r h O Q m O r h N
M N N O V3 N Vf
I~ N m h In
h ll') h M In r
h O r m 0
~ N Q O M m 0 1~
- M
Q Q U] m p h to N h m m h
m h
0 Q
M m N
h ~ m N M
In m
~ M M to m r m
Q
O .
N
r r Q Q r N
) N
m
0 fAQ E9O fAfflEAQ
Q N
I
m fAQ Q h
Q f~ O m Q M
Q O h mm
nl fA m N FA 69 r fA fH N fA fA Vi V3 ffl _- _ ~ M
EA fA Efl EA EA fA EA fA
m
r Q m 0 O O M
In O W N 01 0 M M Q M M D) r N 0 In ~ Q)
N M m M m r a) ~ N N m
M to O 1!1 O O O
m V7 M ffl O O O
O O r h m M
O r 1n N m
r O
N M Q D) N r O Q
m Q m 0 ~f/ m O N O h N N h M r m
~ Q I~ O M h Q m In M M U1
N O N m ~(7 O
T M M N O ~
N N N r O r
N h m m 0
J ~~ V1 Q Q
r N V Q Q h_ N N N M In
m fA Q fA 01 N fA fA fA Q m
M h m~ In O
Q fA M Q i~ ~
r ~ In m l(1 Q
~ rn m rn m
N fA EA N fA EA fN EA fA N (A fA fA ~ N N ~ r ~ N
!A 69 E9 fA EA fA fA fA
NOO Mrm~n NOQ NrtnOmNmmrn
m N m O OO
O OO O O Ohmm
_
m O
O m h M Q O m
m r h N N N _
N m m N M m h m O O
l n O u' J O m m h m~ 0 m
I n _
Q 1n EA O O
O N M ~ O O
~ O M In 1~ M
~ m r Q m
r N N O Q Q ~(j O M Q m In N r Q Q) Q Q m
m N In N O N O N N r m Q) ~
`.L r~ O h Q _
r O m N M N ~ M N m In m M M O M M h m Q
r r Q
N fA E9 h {p Q ({~ p~ N fA fA FA Q
N GH (A EA (fl EA N
N Q Q Q m
Vi N3 k9 Vi N
~ N O) ~(J m Q
~ r ~ M
EH fA EA fA fA fA ffl fA
m Q) h O m In N O h a0 m~ N r Q> I~ m N N m LL"1 M O M O 0 0 0 O m h rn m
O
`- O M O M m N m
O N In N O N r h Q 1~ h m ~ Q m 0 0 M
Q ~ O N O N~ Ol m r r Q
m M In m fA l1l 69
m N M N U]
N 111 ~ In M
N N r m m
N ~~ Q M ~ ~ In M In O N m M O M M m
' m m h~ r- ~ ~ m m m N
~ O m m r Q
~ Q r I~ m N m U
1 M r M 01
i(J EAM fAmNlA fA fAM m
r Q 1n m N
M EAN Q N
Q N m m O h
Q m Q M1~
r
fA FA N f9 M EA to m N f9 fA H3 EA EA ff3 ~ N M
FA EA M EA fA fA
to m
h O
O O 01 _m O Q O O
Q O Q N O m
In Q Q N r O O lI7 h lfl Q h lf7 M m O O M
0 M h o D) h M m M Q 0
N M Q m r m tfI
O N r O N
1~
1n M O I~ O 0 0
M O m V3 O M
m In m O 0
O
O O N 1~ h Q
O I~ U1 O m
O m r M Q
r N h m Q p~ O a) _
m N M In ~ m N M N N O h m~ In t[l U7 m m 0 m
~ m N N M
m Q m r Q m N N h M M h
M H3 M fA m N Efl fA fA M m
O 0 O 01
M M M m
M m N 1n m M
M m M m 0
r
E9 M N fH fA EA fA fA N fA M fA EA FA fA r r M
(fl f9 EA (A fA EA
In h N m m 0 h 0 l(1 N m m N O m O Q O In h O M O O O p O O I~ O h
~ O
O m N M Q O N
In m N N I~ O O Q h M I~ m O m~ O O~
h O~ O
h ~C1 m 01 m N
h h
m m N m O O O
m N M O 0 0 O
0 O O m O N
O In r M Q
N m In Q M O h _
_
Q h f~ In h N h
0 ~ h N h Q O ll') O 1n U] h m O) I(')
_ ~~ Q N M
h Q r _
O r~ m m N M Q
M EA M ~- EA I~ N EA fA fA M m
m r 0 O N O
M Q r h Q h N
r N m Q~ 0
Q h N M m
~ EA M N EA fA V3 fA b9 ~ V3 fA ~ fA (fl EA ~ (A FA ~ ~ N
fA ffl ffl EA fA fA fA
I~ O m h O m 0 0 0 0 N m r N N 0 I~ W O N O m h O h O 0 0 0 0 O h N 01
' M O
r h o Q m to Q r 0 0
N Q O N r 0 0 r In N h M O m 0 0 m O
r 1~ M m O O M m O N O h
N M O M E~ O fA
m to M O O
0 O O In m M
0 O r r M
U` r N ~ D1 Q O O N
~~ O N M N _O M m h O M m _N O In
~ m Q •- N m N M N Q)
m M Q O
m m O ~ 0
~ 0 O m r h
r ~ M ~ Q
m Q r
EA N3 fA N r fp h N fA EA EA M
N EA fA fA fA fA m
~ N Q
fA EA fA EA Q
EJ3 Q h r N M
fA fA ~ ~ N
(A EA fA fA EA E9
~ M O M
O N U"1 O h m m 0 I~ 0 0
0 0 I~ m r 0 0 I~ O m O M O m m M Q
O O Q O Q Q M In
O N O m O 0 0
~ 1n M fA U] fA 0
U] O O h M N
~ O U7 Q O
~ m h O
r r O ll') M N N O m
h In N O O m Q (O O O m Q r
1n O m N N O m 0 m O r
m Q) h m h
l(1 M h m h
m h O r m 0
m O m m M
W m^ In to h m r~ Q N O h N N m Q M m Q m m m O N h O
Q
> Q Q fA
~ (A O EA N r (fl m N fA EA N
_' fH fA fA fA fA m
~ M M FA M
fA fA fH M
fA M m O m m
fA E9 ~ FA r
~ fA 69 f9 EA 69
1n Q M O m O Q r Q N Q i~ h m 0 Q
m h m Q M h N O O N N N m Q I~ M O
O O
Q O In rn m In In
N O m U'1 m m h _
Q N r Q O O~ Q O N
m M N N In O N m 0 M m
m O m m (ff 1n m
O m m !~ r M
Q) M m Q ll') M m
m Q O r Q In
W N
r N M h 0~
~~ m M M M O N m M O m M m _m Q
Q N m Q N N to M N O
In M Q m r
O m h I~ 0)
m Q~ M O m M m
m N N
M
r m r fA N fA h N fA EA fA M m N M~ N Q m N
m fA h 01 m h
V3 M nj (A M EA EA fA r EA fA fA fA fA EA ~ EA ffl fA r
fA (A fA fA
N O M Q~ r Q O O O Q 1~ O M Q O O) m Q Q O Q O O N N N O Q h N O
m 0 0
N l[') O O N Q m M N
m U7 M Q In N m N Q N In M In O m M
Q N to N m M I~ h M m Q
Q N O N O O a
fA In M O O N r
N ~ M N In h N
N O M r Q m
r N
r (D N M h m In Q) O ~ M N to m I~ h N O1 h h O O D) D7 01 N~ m m Q
~ h~ Q m r N N m m M m
9
A
fl N In M O m O m m m 0 Q) O
O (O
fA 69 m fA Q r (~
N M f
(
N
~ EA fA EA (A fA m
r V Q M N N
fA ~ fA ~ Q
r EA In m T m
fA M fA EA r
(A EA fA fA fA EA (fl
m O N
O
M
U ~
~
~
Q
o Q
6
9
a m o m ~, a
c '~ a m
c
N ~
%
v rn ~
w c
d U
w c
w
m u
'
c r w a ~ ~
m y E>>
c > ~ c~ ~ c E S a w
~' m m
'
'S
>
C ~
d c ~ .O j ~
i
~O1
~ N ~ Q o `~
= r
c
i v
? ~ ~ ~ O ° a a
i -
o ~ ~ a o
u
'~
-•
10 ~
O) W (0 i
c d v E
~ d ~f = v
O
~
p~ C N C N N N U1 ~
01 d~~ N N jp d d Ul
~
% C> T
~ ~~ W N W O
~
X ~
N
Q
V A
m
acs `w~ ~ c ~~~ K ~aa
~.~ NOO E!~ w ~ :°. ~~ ~a w o v °'QU
m U ae
U `m
~
m E m m mm Q v d v m `
~ Q
~
t o
~
~ ~
a
i
~ Q G
Q L ~ a
E
v t L
m m m v }9 m
- i
c a c
0
d R '.4 c }3
o v$ v
i
d~ m
y v
Gatq 7t ~i OK~~s v
o x
~ a
E- W ~~~~~ ~OOUQ o
F a
w o x o m
t7 OZ U Km wmU o
F > w m o 0
~ ~O~ml-
a
r N M Q ~(7 m h m m 0 r N M Q 11") m h m 01 O r N M Q to m h m rn O N M Q U] m h m ~ O ~ N M Q ~(] m h m O) O N
r N N N N N N N N N N M M M M M M M M M M Q Q Q Q Q Q Q Q Q Q In U7 In
m
a
m
0
m
m
'V
0
0
W
~n 0 0 0 0 0 0$ 0 0 0 0 0 0 0 0 0 ~~ o ~ o Q o --__
o o ~ o °o °0 0 °o °o °o °o S °0 0 °o n
~ ~ N n mc~niis ~ °o ~ r~i~ ~.n
_ N N <p ~
0 0 0 0 0 0 0 0 O O O o O O O O Y'S O O O O O S O O O 00 pp 8
(V O O O O O p O O O O O O LL)
Z r ~ M 1[7 h O O r th O V (p ~-
N N {p N (D N ~ V ~
th O O O O O O 0 0 0 0 0 O O O In ~ O O 0 0 0 0 0 0 O O O O
o' ~ S ~- 00 O O O O O O O O O O O O O O
V N N ~ O~ 0 0 S O S O O'
~ O N r Q) l'1 Y7 4") d N r r r N~ ~ ~
~ N N O (7 O
N O O O O O 0 0 0 0 O O O 1n O O 0 0 0 0 0 0 0 0 0 0 0 0 S ~ O Q S O O O N
~ ~ ~ O O O O O
r ~ M uN'] 17 N ~ ^ 0 1C N N
N N f0
N O p 0 0 0 O O O O O 0 0 0 ~ Q O O O O O pO S 00 0 0 0 0 $ O O O O O O 0 0
O O O O O O O O O O O O N
O O
Y ^ O r N M N ~ O N r ~C) O S N ~tJ
0 o co 0 0 0 00 °0 op $ po 0 0 0 0 0 0 0 0 0 0
O O O S O O O O O O O O S O N
~ 0 O O _
N O~ W n ~ S yNj ~ O ~ S O N O'
N N (p ~ N M ~ (")
0 0 0 0 0 0 0 0 0 0 0 0 ~n o 0 0 0o g$$ o 0 0 0 S o 0 0 0 0 0 0
0 0 0 0 o u~
_ O ~ O ~ R 11~ N ~ O O O C O N
O r W C7 N O O r iC O `N N O
N N N (O
O O 0 0 O 0 0 0 0 0 0 0 0 ~O u7 O O pQ 0 0 0 0 0 0 0 O
07 ~ p O S O S O O O O O O O S O
p O O O 0 0 0 O
O r E S N ~ O~ i~ tCi O N c0
N N N f0 N N N S N
O O O O O O 0 0 0 0 0 O O 1n kJ r O O 0 0 0 0 O
r S S S S 0 °o ~ o ~ S o °o o S o 0 0 0 0 0 o N
~ O O O O O a0 W O (O ? 1n N n
O O O O O N N r r O) (+1 ~ O O N r to O O N r
N r r r r r N N (p N ~ C
0 0 0 0 O O O O O O O O 1n ~ O O O 0 0 0 0 0 0 0 O
'- O (G O O 00 00 S O O O O O S O O.
(p O
m 0 O O O O O O O O LL")
LL 00 v~ rnr~iu~i rn o r ~~non ~ rn
N N N (p
O o 0 0 O 0 o O O O O O ~ II'J O O O a 0 0 0 0 0 0 0 O
.- O W O d O O O O 0 0 0 0 0 0 0 O N
W O O c`') tD C O N N ~ O O O 0 0 0 0 O r
O v r~ m fh N O ~ O~ ti ui w 0 ~ M
N N N r N~ ~ N r ao
M
0 00 0 0 00 000 in ono u~,oa pa OOOO u-,
~ S S ~ O 'N 00 0 0 N O 0 0 O O O O O O'
pp O OO OOO O O O W O O O O a00 O O
~ N .p V n Off (`09 ~ N N~ r ~ ~ 0 S N
O O V ~p
N MM
O N O O O O N 0 0 0 0 0 0 (") O O O ~ O u7 O O O O O O In
0 0 0 oSSo No (o co 0 o O o0 0 0 0
~ N O O N O O O O O O ~ y'~ ~ O O p O O O O 00 10
(~ Q Q) O O W O O O N N r c0 N fD d' O O O O
y `-' ~ N 0 0 O O O N e() O O V r N N O S O ~ O r
N N (D V N O V f") C f0
y ~ .~' (")
•' a d O
N V~ y y y y y y y y N y N N y y
- ax c a a a a a a a a a a a a a y
~ W y y ? pG pC pC pC oC pC pC p~ pC pC pC oC oC pC C y ~ o
LLNJ $~~ C C C N m m m m m m m m m m m m m m ~ y ~
O. c t ~ m ~ m 0) _ d d d d N d d N d d d d d d l~ ~ C N
7 7 7 7 7 7 7 7 7 7 7 7 7
•V ~ > ~ 'O > ~ a O C C C C C C O C C C C C C C G d d~ 0 j T
•C N O N m O d CO y d d d d d d~ d d d d d d d d > d y 0 d
N C d C > > > > > > > > > > > > > O
m ~ 43r o c 3r c w CI O 3'~ d~"
7 O Q O d d d d d d d d d d~ N d d O d a $ .y.
a tFU_~ 4 ~~li~ ~ U 2~~Q:2 ~ pK~~K2~~~ ~ ~F- c m d (4 y d o~
~ o c ,8 y m m c ot3 ~ m m .~ d ~ afOi C7 o K d d
W m N_ O''C in T d_ O":. N o~ d d ~ d d d d d~~ d d~ d d~ d C d (' ~~ y •O ~`p
~ N N ~~ A d y l0 A A l0 m N A lC i0 A W l0 !0 l0 !C d ~ A ~ ~~ C .~ L
m ~~~~' c ~5 d a`ti~~i~ c ~ d o ~ 2 ~~~~~ ~ ~~~~~~~~~ v ~ ~ ~eyC o iQ E¢p m °~ d ~~
A m s 3 c ~a a 0 V 3 3 c 'm ~ v ~ d A ~' r~ y r ao rn ~~ c~ u-~ cc rn o ~ M c 'Z v6 d~ o °? cdi ~ ~' c m
y Q l0 ~J 7 O) O) 01 O Q) O O O pp O _ C t y Q O
(V U j ~S Z Z J W Q f0 ~0 ~ Z Z J W O ~~ ` SC~ V OJ O) O) O) W N Q N N N N N N ON N~ V N O d (Q (~ N ~ W
7 ~ a Q d '` C~ a H U~ W (~ ~~ 10 U
O A N C CCp N d ~ d ~ C
V ~ O m .~ ~ N (l/ ~ ~ ~ C v
Q •- A c _ m E 7 c -
U ~ m ~ F H a' ~ ~ ~? ~ o '.9
_- ~
O
d
~
0
00 _
fJ
0
0
0
0
0
0
0
0 _
O O
O O M I I) O y 0 0 0 0
Q.
~
'
u
7
O O M N Q M ~ M I[7 1t7 f0
Q
~ U
N
_
___
_
_ O ~
r
O O
C7
S
S ~ ~
N
N
S p
I(7
O
N
Q ~^ p
S N
GO (O
1~ O
O p
(O N
a0 C M
O
Q Q
N M
M O
a0 e Q O M o O 1~ W
O O)
Q n
a
OM
M
O
O A
m
O
M
O
U7
O
^
^ 01
Q^
O
^_
M
t~
~
O
M
N
N
0I
O (0
O N
Q M
a0 O
O In
N N
O r
ap O
^ M
~
O
Q1 h
OJ
N
O
O N
Q ^
~- lC)
N Y'i
N i~
O H
M M
M 1 O
(7
Q O
I~ O
W
~ O O
~ O Ql
D)
r ~
M M
Q 1~
N r
1~ W
M I()
O N
O R
O (O
~ (V
n V f0
O O
r 1~
^ N
O Q f~
O 117
n ~ ~
~ 1 ~
h
N M N ~-- ~ M 1~ M M r ^ N Q M N N O) O Q) N LL"1 O N tT 01 r N O) N
m
N N N 115 N c`7
N - ^ Q ~
1
a ~0
0 O
M 0
O 0
O ~ h
pp IC)
~7 0
O 0
1C) 0
O
N M
'7 ~ Q
O O
O Q I~ O~ IL'f 1~ N 1~
O (O N
m a O 1~ 0 0 f0 o In p> O N O
^ M
O
O
O ~
0
Q
V
O
N
O
^
IL O
A N
O a~
N M
1!1 M
^ 1(J
^ (O
N N
O ((pp
Q (
N
(O In
m
O pp
V O
O O
IC) O
O O
h O
N
M 47
^ Q
O) Sj
O N
n
Q
Z
1 Q
~
M ~-
^ In
N
N O
N
.- r
O ~
N
N aD
O 1
(O O
(1
M
Q
M ~
fD
1~ O
o7
^ ID
(O O of
LL5
O n Q
01
M M
(D
N M
M
N M
O
Of O
O
4 Q)
a0 N
~ 1n
D) O
h N
(~7 ((pp
Q Q) R M
N 1!1
~ N
0 Q
M m
N O O
0 O
n ~
N N
N N
~
N m
N ~ N
N v ^
t+)
N ? ) ^ Q
N ^
N
N O p 0
1 (
0 ^ Q ~
1
f Q O
17 O
0 M
M
1~ 0
O
O 0
O
O ~
~ N
T IA
h
^ 0
0
O 0
Y7
IL7 0
O
O
N
^ (O
~ ~ N
~~77
~ Q O
pp
O In
(O
Q
N pppp
Q
N ^
a0 Na
y
N 0
7
Q 0
1(7 0
~1
Q
a0
I
7 1~
O)
n D)
O o
(O 1n
O W
N O
O O
O O
O ~ c
p ~ r
Q) O
O M
O
~
l'J
~
1
O
~
O
^
115
N
117
N
I~
O
01
f0
YJ
(0 1
O
17
Q
In
1n
O
N
M
O N
O O
~
a0
LL'i
1n
1~
N
Q
t0
~
O I
O a
n
0 ^
c0
a0
O
45 [
O
O
1[)
t0 (O
115
f0 M
~ W
Q Q
I") 0
O
M 0
In
I(7 0
O
M I~
t0 Q
f0 0
Q
Q O
W
N 0
a0 0
IA
N O N ^ O r c0 M M 1~ ~ ~ O M N N N O .- O ^ M r O N ^ M O) Q o0 Q N Y7 ~
t D
N N N Q N N ^ M a
f M O
N O
0 M
~7
Q O
O
O O
O
O ~
~
N
O
O 0
O
O 0
IA
l 0
O
N
m ~ cD
p1 N 0
O 0
1~ Q
W
M a0
h u7 a
f 0
0 IA
O
N 01
I[1 O
I~ N
~ o
N C
O O
h N
1~ 0
O 0
N O
c0 o
r e0
r a0 07
O W
O V
n
N
J D
O
O
Q
O
^
N
N
N
1!')
N
^ O
1~
O
0
(p
^ ^
O
op
M
O
N
M Il
Q
M O
O
In
1~ E
O
a0
r- M
c7
O
Q Q U
O (O
0 c0
M O
V
a0
M ^
~
N N
N
N
N O
1~
N
a0 O
O1
1~ I~ t
a0 I
a 0
~
()
0 N
n
1~
^ I~
(h
It') M
O
1~
^ Q
O
N
O
N t0
N O
O
O
1(J ^
(D
O O
Q O
1n
O
0 1~
If)
^ O
t0
In N
IN O
01 O
It7
M m
~
N ~
r 1
N 0
M
p
N
N
N
v
N
M
N
N 1
N y7 r N ^ M
~ V'
}
1 ~ O
N O
M O
O O
O ~ Q
M X
O 0
O 0
N 0
O
N Q
pp ~ N O N M 1~ ^ N D ) N N Q) e0 O o m ~ O O V' o ~- r O
O W O
!
T M
^
O
O O
O1
r
O
O
O
O
^
Q 0 0
Q O O
O Q
D) (O
O
V
01 O
117 f N
D 1n
a0 01
^ O
117 CO
Ln
~ f0
N O
O N
O O
O It1
r t0
M N
Q1
~ Q
N h
O
Y M
M O
^ 1!1 1(1 r N
0 O
M O O O cp p1
n p (p cp (p
01 V pp
t
1n r V ~p It•j
O O n
O
N c '1 N r ~ N (
7 t
v '
) ~ 1~ ~ R O 1~ (`
') N N n ~ ~ ~ O M ~
- ~ ~ onp ^ O ~ yNj N ~0 ~
. ^v
N O) N N N m ^ N ~
I1
a 7 O
M O
0 M
M
o0 O
O
O O
O
C
~ O
c0
M M
t0
1~ O
O
C O
1A
If) p
8
N
^ Q
h
N ~-
~
f0 O
O
O Q
N
Q) M
1~
IfJ 1~
M
M M
t0
N 1n
Q
c0 O
N
M ~
aD Q
If7
1~ N
f0 N
1~
O N
N e
1~ C
p O
O~ Q
o~ O
O O
1(1 N
Q) =
cD M
f0 Q)
N ~
~
N O
~
O
~
O
a
Q
0
Oi
1(1
N
N
O
N
^ ~
n
O
r
W
N
~
1
M
O
f1
M
Q
M
117
M
t~
O
a0
D)
Q
47 Q
O
~ Q
11')
1~
M
(+1
M
N
^
1~
N
Lb
a0
O
O
O
O
aD
Q
M
QQ N
O
O tD
I[1 O
O
O O
M
r Q
c0
M O
O
N 1~
O
m O
N t~
W N
~
O N
M
N
N
M
~
O
Y
N
N O
N
v ^
Q) ^
(V N i~ O O ^ Ol
^ Q
~ _ tf, N ^ 00
(y 1~
^
N p
.1
N
<
~
Q co
O
) M
M
I[1 0
O
O 0
O
O ~
~ rn
M
IA r
Q)
N o
O
O o
1n
O o
O
O
N
- M
M A~rn+1
Q V o
C ^
~ M
C In
r
0 coa
~ o Q
M N
~ lc
N (Qp n
n o N
~ In
N o
O 0
n 0
N 0
N QQ °~
O o
O m'
~
O
O
r
0
~ '
~
C ~-
1 ~ ^ 47 N (
') O ' ^
O O i N N 0 t
11 O
7
Q O
M O
O 01
Q) O M
O O O
n 1
N (O
O
N O1
M M <
01 0 O
0 fh
117 (D N
N (V
M (O
f0 (O c0 Q
M O In
^
a~ (O O 1~ ~ ~
~ ~
O
N
C
J
N
^
p
Q
N
M
M
h
^
1~
Y7
M
N
N
f~
(0
I
~
^
ap
10
- N O) ~ y7
~T N M ~
c
N 0 ~ c0 ^ n ^ N M
0
N 0
O
M 0
O 0
O ~
~ o
a0 c%l
1~ o
O o
In g
N r
n ~rn
O Q) o
O m
01 rn
I~ co o
O M
t0 Q
O
fp
N oa
N r
^ o
c0 o
f~ ~ ~ o
0 o
0 o
0 io
N e
M o
IA Q
N mo m n
~
M M N O O Q) ^ Q O LL7 O ^ M Q r O Q M 1C1 M 1(1 a 0 W N ^ ^ N ~- m O O I(1 (O ^ M ~ f~ O N
=
O
I M
~ (T In
N N
N r
O ~
W op
O O
M
Q O
N O
a0 O
1~ O N
O O
(O O
N
O M
O
Q) fM C
O ( 7
O
~
~ m N
O Ep
O (p pp
M p
M p
O ~
~
a0 r
01 Oj
O ~ N O
N
Q
N
'-
~
N
N
v
M
M
f~
r
Q)
n
O
M
N
N
(D
In
^ I
~
'-
r
O
_
N
^
M
Q)
N
Y7
M N W N
00
N
~ (O .-. O M
0 0 0 0 ~ Q M O 0 0 N X0 0 Q 1~ N 0 01 ~ IA O W O M o O '7 0 0 0 O Y7
~
O 1A
M M
Of O
0 O
0 117
O M r
N O
O O
~ O
O N
'- 1~ Q1 O
Q M O
0 r
0 O
Q I[1
f0 O
0 M 11
f0 N 7 01 ^
.- 00 O
f0 O
.- o~
u7 O
a0 1()
11) O
O N
1~ O
O O
1~ O
O O
O O
~ (D
~ V
r
(~ O
N W 117
N
N 1()
N
'- n
O r
O
r m
a) O
O
M
Q
M O
1~ O
c0
- M
Cp
N O a0
Q
fp Q
N (O
Q) M
f0 I()
Q Q
M Q a0
M N
Q
N 1~
Q W
M (0 N
(O Q)
N O
N f0
o7 Q) In
Q
Q O
N ~ (
~ 0 O
1
N O
7 ~ Q M r f0 Il7 ^ 1 ~ '- O ^ M ^ M t0 u7 N
~ IL r O .- <O N N
I ~ O
1(7
a0 0
0 o
0 fOD
c O
t'
' O O O ~ M O m 47 Q O Q m O O eD .- (p o C O c0 0 0 O e ~ O O
~
M
tt7
O
O O
O 0
O c
O
LL7 O 1()
1(1 O
O N
^ W
~-_ O M O
Q O O M
a0 I~
(O r
O 0
O 01(
M O 7O
) M ^
^
O
N n
01 m
II'1 O
O O h
O N O
O O
Y7 0
of 0
1[1 O
O O
N 0
Q) 0 n
11] V
~
ly O
O
O
) ~O 117
N
N 1A
N
~- r
O
~
O Q O
Q) 11
M
7 Q
M O
O O
a0
M O a0 h
a0 In
O h
O
O IA
M O
O a0 O
M N
M p
Q O
M
QQ O)
O (O O
O 11~~ 1~
V N Q)
Q) O
N D)
O If'1 O ~ 00 1001 ~
N
C)
r
^
117
D) M
N
r
(0
I()
^ 1
~ ^
O
Q
O
(O
N^
^
01
lO
O N r
O
~ In fD ~ ~ In N
N
Q O
) 1(1
M 0
O 0
O ~ O O N O N m 00 1!7 0 10 0 N O O O M In f~ o O o0 0 0 " o O m 00 7
O
M
N
O
O O N
~ t0 $
C m
01 O
O N
^ Q
1~ Q1 n O
Q N O N
1~ O
O N
1~ O
O N 0
Y7 O 0 O
O O
N
Q O
01 M
N D)
M 117
N m O
O In
N O
u7 r
N O
O
C' O O ~
O M N
N
w C r
O
O c7 KJ
N
N N
N r N
0
N
M
4 O ~1..'71
5 Q O
O O
N N
O O M M
0 IA
O f~
N 1~
O O
M Q7 a
O O 0 t0
N a0
M M
V c0
O M Oj (p Q
(O N ((j ^
^ Q
Q Ip p
M ~j
Cp ~~
e
}
N ^ 0 M M r .- O h M N ^ f0 ~ ~ ( 0 ^ Q Q Q N O N ~
~ F
~ Q 117 m ^ C ry ~ N
Q
V O
N
c0
o0 (O
U7
^ O
O
O M pQ
~ V
RQQ O
N O
O
- 00 r
fD
Q O
O
V' Q1
Q ~ 1~ r
01 t0
~ O
1~ Q
~p
N
O O
Q M M
M Q
o0 a0
117 m
i~ O
I~ o
1~ C
O O (0
u7 op O
O O
O 10
f0 o
I~ f0
I~
Q)
p O r ~
O Q N
Q
' O
n .
~ M N It7 c0 Q Q O 1A N ~-_ ^ Q1 O N Q O N Q c0 O N O 47 O Q N
O ~
Q O
N u
m
N 1 1~ Q
N
M O
LL')
N O
O M
) r Q
h
N
Q
M 1
O
f~ pp
V
Q O
0
a0 O M 1n
(D IA
O 1C) M M
(O O
N Q
Ip
f0 f~
N
Q 1~ M
aD I~
N N
N o7
fD Ln
Q) N
O r O
6 O N
f0 N N
0 117
^ of
O) ID N
IC) 1~
N
Cp ~
N ~ (
p
C
V ~ ^ (O ^ Q fD J f aD Q LL7 N
__ ~ N eG ^ M N N
[r7 O
N pQ
C O
O In
u07 y°j Q
N ~ 1(
t~ 1
O
^ h
'R Q
~rj W
~ ~ Q Q
In 47 a0
M . Q Ip
< O
O Q
N ~
^ M Q
of Q
1A f 1~
N
' N O
a0
tr Q)
O N
N f~
fD o
O T
(O p
O O
O N
O o
Q O
01 Q ~ O ~
O) ~
:
f9
()
g
O
(0
n
f`
O
O
N
N
cD
M
N
n O
O O
0I
N
tD
1[
Q)
M
1 M
.
f0
O
f~
O
M
N
~
N
a0
Q
O Q 11'>
10 u5
O
O
(O
(O
N
f0
N
(D
I~
N O
_
tT
^
n
^
~h
~Q7
tC
N
N
G;
(G
O
O
CC
^
O
~
O
Q
to
N
N
i~
~
of
^
a0
O
^
N
O
O ~
4
' V
yOj N O
N
O
O ~
M O M
1~ N ^ f0 10 (0 ^ f`7
^ f~
N n
N ~
- N l
f1 Q
_
^ O ~
~
Z
O C ' U
C
N ~ w
`n ZO
F- p
? Q
~ ~
p m
(L W
U
W
a ~ ~ [0 W C~ > U U
H µw
~ - p F- - -- -- ta w J ~ ~ U ~ = Q
z a G~
~ ~
ww yr w
wLL ~
U ~ z o
Z Z a
~~ ~
Q R ~ Q U
Uwm
p
~
Qd J
~
~
~ =
W
~
~ W W
wu_
~~ Z (q
O W
w C~Z
zO
2QF Z
O
F U
w
'
~
K
w w~
~Z Z
O
F
H
~ O
F
a O
m ~
U
' ~
~
w K
a
~ Z
o
-
W
~
~~
-o~
~
L
a
O O
~
~ Z
W
~~ ett
} O
F
Q O
F-
~ U
O
~ QU 2
~ ~
a
U~
R' ~
Z ~ W~ W W ~ 2~
W~ U W
Z ~ O
~ ~ Z
W ~2
U
~ ~ O
~ U
w W
W W
LL
J O
~ W
~
Q F
~ w>Z ~Y
~Q m
~ Z
~ W F
w W Z V
~ 2 a' W ZZ, W> w W W a U
~ p W
~ ~ ~ V1 LLj ~ U >
~LLj Z ~z F ~2 Q
w
~ W ~
U' Z ~ 00 a W~
O
' QO w ~ ~ O X
~
c
LL ~ ~ ~ ~~ ~ ~ p 0 ~ a ~ GcG c 10C~ c7 ~ o ~~ ~ ~ ~ o v~tn F-
Y _ # UCJ R
w ~U C~ ~ O F W ~
~ ~ p _O U ~ F- (7 O o m 0] FJ J U ~ Zo - O ~ p
Q ~U ~
^ N M Q v1 1 0 f ~ W Q1 O^ N M Q Y7 ( O I ~ a D 01
^ O
N N M
N N N Q 1
N 15 1
N 0 1
N ~
N O W
N N O
M
c5 N
M M
M Q
M 47 1
M 0 1
M ~
M a0
M Q)
M O N M
Q Q R (
47 p
Q o
r
Q p
Q Q1 O
Q tC) 1
1 N M Q 1 ~ f 0 1~ a0 m
5 ~ 4 5 1 17 I L7 LL 7 117 1n O
W
H
J
N
7
a
a
U
2
R'
W
J
Y
J
W
Elk River
Municipal
13069 Orono Parkway
Elk River, MN 55330
U
May 2, 2005
itie s
To: Elk River Municipal Utilities Commission
Jerry Takle
John Dietz
Jim Tralle
From: Bryan Adams
Subject: Highway 101 and CSAH 39 & 42
phone: 763.441.2020
Fax: 763.441.8099
During last years budgeting process, we discussed the upcoming highway intersection
construction in Otsego. The intersections are Highway 101 at CSAH 39 and 42. With
recent meetings with the developer of Otsego's Waterfront East (east side of Highway
101 at the intersection of CSAH 39) construction will start this spring. Also, another
development to the southwest of this intersection will start construction this fall.
Attached is a newspaper article addressing this development.
There are two issues that need to be addressed. They are the relocation of existing
electric lines for construction of these two highway intersections. The second issue is
constructing an electrical distribution system to serve the long term growth in Otsego.
Attached is a letter to MNDOT with a marked up aerial map reflecting part of a solution.
We serve all of the land east of Parrish Avenue to the Mississippi River. When this area
is built up, our electrical load will increase by 12 to 15 M.W. assuming typical
commercial development, 15 M.W. is 3 electrical feeders at a minimum. There is one
feeder now feeding this area. We have an agreement with Wright Hennepin Electric to
utilize the Otsego substation. We are also proposing to MNDOT another feeder from
Station 14 (Great River Energy) south along Highway 101. The latter may be difficult to
build due to crossing the Mississippi River, crossing the Highway 10/169 cloverleaf, and
crossing the railroad. Currently staff is pursuing both the Otsego substation option and
another feeder from Station 14 paralleling Highway 169/101. Ultimately, both will need
to happen. The question is which option is more economical to do first.
For your information, 2005 budget contains a $100,000 to relocate electrical lines for the
MNDOT construction and $500,000 in 2007-2008 time frame for another feeder.