5.4. ERMUSR 04-12-2011Elk River ^-~
Municipal Utilities
13069 Orono Parkway • P.O. Box 430
Elk River, MN 55330-0430
UTILITIES COMMISSION MEETING
v~
~~
Phone: 763.441.2020
Fax: 763.441.8099
TO: FROM:
Elk River Municipal Utilities Commission Theresa Slominski -Finance Director
John Dietz, Chair
Daryl Thompson, Vice Chair
Allan Nadeau, Trustee
MEETING DATE: AGENDA ITEM NUMBER:
A ril 12, 2011 5.4
SUBJECT:
First uarter Write-offs
BACKGROUND:
First quarter write-offs are presented for your review. These amounts cover items since from
October 2010 through March 2011 and total $19,664.08. This amount is comprised of
$16,040.81 in accounts sent to a collection agency for further collection efforts, and $221.18 that
are written off with no further collection efforts. There is also $3,402.09 that will be assessed
this fall for the assessable services of water, sewer, and trash.
DISCUSSION:
The amounts for electric services that we have been unable to collect on are $15,055.47.
As noted before, there is a $50 minimum limit for assessment and when amounts fall below that,
there is no recourse but collection. Therefore, there are some assessable services of water, sewer,
and trash that appear in the collection write-off column.
Excluding the assessable amounts, this would result in less than 1/2% (.23%) of total sales for
projections of 2011 bad debt expense. Our budgeted amount is $100,000 or .35%.
ACTION REQUESTED:
Staff recommends that the Elk River Municipal Utilities Commission accept this write-off listing
for the first quarter of 201 1.
o
m
o
v o
C cO (p (D I~ of O N M O>
O O 1~ m O r O m O 7
Q U O ~ ~ N r f~ c") O O
N I~ 00 N ftT O 00 a
~ ~ to ~ (~ N ~ to
U
-
-" U ~
1 C N O N O O O m O C] O f~
N
O
O ~fl '7
V V
f~
V
V CO (O O r
N O
E ~ N N (D of V ~[l CO (O ~ I~ O M
~ ~ es, ~ » ~ rs> ~ 69 ~ tfr e»
,~ 't' v3 u~ u>
U
Z N
3 N N N
3 N N
3~ N
3 N
3 N F L
"~ L
~ ~' N N
~ 3
v
v N N L
~
~
a~ m ~~
a~ ~ ~ ~~
?~ ~ ~° m
~ ~ m 3
m ca ~
- u> cn cn~r- cn~ cn m
vi ~
w<n~r- w~ ~
wv~~ w w ~
~
`
r cn
f w
w
O
a~
~ 0
N
F-
~
~
~
v~i Q
Q
aNi d ~
¢ J ? ~ U ~
W H ~
W H ~ W H S ^
' y
_O w W (n (n J >
? (n F ~ ~'
~ ~ ~ ~ Q ~ O o~ ~ ~
~ ° U`
N ~
~
ry
~
~
O
~ ~ M (D u7
~ V
`~ W Q~ O ~
O ~
U7 .- ~ ~ ~ N ~
O O O N N N I~ O O O O
M O c`") m O O w M c") c+J N
M t'7 M M c7 O O M N M
In lfJ ~ In lP ~ Ql U7 z In In In
~, _, _, _. Q _, Ln
J
Z
O w
O
N ~ Z Z Z Z Z Z N f- Z ~ Z ~ Z
41 ~ ~ ~ ~ Q ~ O ~ Z ~ Q ~ ~ lwi d ~ ~ ~
W
QZO ZF- QJ Z~ ? # ~~ w= ? Z~ Z w~~_
cOw xW (n ?~ ~(nZ i~0 zQ ~C_J zH ~~= Y O~ W
¢ mcQn~w ¢ _'~ -'xw O~~ ¢=w w~C7 ~= w``~ aaZ~ Yrn~ O~¢
~Qw> ~>> O» >~W w~0 ~coZ c~~w O~> wQm mX> ~a0
u,z~~ ~w~v0 z0~ w~~ jwz w~0 z~z og~ ~wv~ om~ who
m¢~~ O„'~,~z ~~Y ,~O>!ro~_ ¢~O ¢r=>} O°v>z ~~~ ¢~~ QOY amw
Z UJ W ~ .- Q W N W 4 N N ~ 1~ ~ -~ N> ~ > w W m a d O d W J N
O
N ~ (D ~ N of m
~ CD ~(l of ~ O N O N
'- ~> Q .- N ~ Q~ V O V N (p O~
r~ U m m N N N ~ ~ v ~ i a~
0
N
N
Q1
m
a
w
w
N
~ v
co
co
O O co N
~ rn ~ ~
_ ~ ~ _
m ~ N C M c~ m
Of~ O ro _ ~O Q~ M cD
V O N OJ N O N OJ M O O
Q O M
-_ M fA f9
~ ~
V M
f~ (D
N
N M N
~ to
O to EA fA EA fJi 69
U
N N O r O ~ Q~~
~ ~ V f~ O O
N ~ Or
01 N ~
O V
O ~O>
O O
Ul ~
N ~ ~ ~ eA EA to
N
N
N
Q
N V U U U U U U U
~
U
Z m i ~ ~
m
i ~
i a
a ~ ~ v ~ iv i m
a m ~ m a
i v 3 m
cnwcn~F- wu~~ ~ w~ w~ ~ w w w wcn~F-
C7
a
w Q w w
~w > ~
o J
a > r- z z z >
~> Q Q O J J J Q
~ Q F- = Z O = D ~ ~ ~
D Z (n ~ ~ N (n (n 4'
Q Z m ~ m m V
of N
m N of
Ql ~
U O Q ~ ~
th O ~ V V O
O
~~ N
~ c0
~ N
~ Q~ W
O
O OJ
O D)
O r
O
U7
of cD M O N d' M O M
of f~ M M m M O M O r
f~ M <{ M O O M M M M
m u~ u~ ~n ~n t~ u~ u~ u~ in
.., ... .., O _, _, -. _. _, O _
~ <`~ (n Z
W W Z d w ~ ~ O
_ tt
~ ~ ~ ~ Q Z ~ ~ ~ ~ ~ Q ~ ~ ~ H ~ Z ~ ~ ~ ~ w ~
~a'~ ~o ~ z o oz ~ Oz v' Z
Q Q w O w w 0~ ~> ~ O z~ Z Z J Z ~ z G
~ ~Q~w >Ow >QO OQ wz ¢Y OJ QF-- w~ mwz
'~ ~~wOw OKU zv~~ Q>> ~ Jz w~¢ Q°,~ ~r°> >C~ Q=0
pj N ~> ~~- Z~ Z m w d' W .-
`E°=wZ Qo~ Qo0 W ~°~ QmO Oow ~c~'oO ~oY Q,°nOz Sow
~ ZU~Y cn .-v~ =~U mM W ~~~ ~Na J(pQ mew zcDQ ~vd
0
N ~ Q~ N O N V' (p Ql N (p (D
(D C N (p M I~ V N
~ V ~ O N (D f~ r O r
ch U~ ~ ~ ~ ~ ~ ~ m m rn
0
M
41
m
N
Q
p
>N
C r M ~ .- r- O a0 of O N r ~ I~ O ~ O
O W N N in (p O W cD ~ <f O M V ~ ~ c0
U N N (p O M V N O N M O V OJ N O
O O M M W ~ d' W M ~ Q> of r (p V N (D O
-_ N fA fn t9 EA fA V fA kA (A fA ~ V ffT H3 N fA
O K3 EA fH en ~
U
u~ r co c- O
C ~ ~ N ~p
QI N
E M M
V
O r nj
~
O cH ~
N
Q
U U
N N L U
`
N U
`
N
t U
~ U
~ ~'
V U
~~ U U
U N
~ N
~
U N
U
~
U N
N U
U
U
~ ~ L
f0
N
~H Q~ t0 UI
~ N ~ (>D N U N N N N ~ >N t0 _N N
UJW(n W (n
~ W (n>H~ W W cn W (n>H W W
N
Q
~ o r
v O
~ o ~
a `~' a
z W ¢ o a w
-~ > W
,n ~ Z Z Q > F- W W Q >
~ a > a ¢
~~ ~ = p z ¢ a Q z z_
~ ~ W H ~ ~ ~ F- Z Y
~ U cn cn O o
Z °m r, °' a m ~ ~ ~ C m
N ro N M .r- u~ O N f~ ~ m
Cn r (D ~ ~ ~ (`~ ~ ~ O M
V N N O O O O ~ N
~ O M M M M M M O O ~
ul f ~ ~~'J ~ ~ N ~ ~ M M
,.. '~'..,' ... .., _, _, _, _. _. c0 tD
~ W
Q ~ ~ ~ M Z
i ad ~~ a ~ a
~O z ~¢z rYZ ~z ¢z ~z -~ z z z cn z O¢z
-~`oa ~ o~~ ~O~ ww~ >~ og ~ ~ ~ ~ wM~ w~~
-off ¢ H d W> Za ~ W ~> YF- mZ
a Q o~ -~ Z Z m y 0^ O O z Q Q Q ij ~ J w Q Q w>
Q mJV~ ~Q YQa o~w OUw W ~w as~w O~ j mUp ~Zw
~~oa z~J asUZ ~.-> ~~> }~> a~~ ~~~ Jac ¢~>
rov E~ m w m ~^ Q c0 ~ O m K j d W UMW ~ r ~ ro W ~ W X ~ O~
~aa00 Z`n M u~Y vY ¢01' N~ vm ~ W Y
~ Z~ d W ~ c`~o ~ O M d Z ~ w W o w ~~ W d~ OZ m° Q ~ v Q Y~ W
0
N ~~ v N m rn
m v m r`ri °o o ~ °
O N ~ N N M r} ~p ~p r
M U oN N N N N N N N N N
N N N N N N N N
0
m
a
O M ~ N
d M N ~ ~
N Ql
.. ~ p aj
~ ~ _ ~
7 ~
C
o r V
vro N
m N m m M N N N u7
o ~n v ~N ro ~r
U
~ V O
~ ~ r
°m
m
v
° v
rn ~
~ ~ ° ~ ira v ~
U ~ v> v
i w ~
`" ~n o
c ~
N
`
°
E M
~ ~
~ ~
a~
a
U U U U U U U U U U U
Z v ~ L
u~ ~
~ L
~ ~
v
~
v
v L
~ 3 °' ~
v
u 3 m
m
°
' m m ~ m ~ v v ~ m co v v
c
n
iw
w~
w
r`
w
w
w
w ~~
wcn~~
w ~
wcn~
w
O
M V
~ ° 0 0
j ~ ° h- ~
> a
Q
a
w
Q
W
> Q ~ >
Q w w N
F-
cn o
~ >
Q
Z >
Q
N Z J
Z Q U ~ N ~ N Z Q H
~ ~ Z cn U a O ~ ~ ~
Q~ Z S Q w m m m m O =
d a H
O
~
Z ~ ~
U m W ~ N V ~ Q
Z ~ o
r
~ M
N ~
M ~
of in
(D r m
O r u~
(D M
V ~
UJ M N M .- r ~ r ~ ~ ~
r O
M O
M
~- O UJ
~ O O Q~
O O~
O O
M
M
lf) M
Y7 M
lP M
In M
In
to
,.. M
~
_, ~
~
_, M
~
_, M
~
__ M
to
Z
O ~ _.
LL
O O N W W O
(n >
>
> Z
Z ~
F- Z (n #
Z Z Z
W Z W
Z Z
Z
Z Z ~ Q
W J Z Z
~ Z
Z
N ~
W ~ ~ d ~ W Z ~ W > ~ ~ ~ W ~ ~ Y ~ Z ~ ~
~ _
> U ~- Q p ~ w Q
H }
Z >
< ~ U
ZZ O
~ U
W
Q W ~ ~(n ~ j ~O
W Z W J
Q~ Q
LL } W'_(n
w d W
U QZ
~ O
~
Q
~
cnpz
w
0
~Z
w
W O
~
W
=Q>
p K
~O
w w
w~
~ m
ml-
~~
UJ
e d
}
a ~
~ ~ ~
Q O W
co ~ Q ~
} W a~
>
~ Z
aQ ~
Q w
Z W 0
`yf
w w
~ Z
~ w
~ W
w ~
_
~ W d > F- > X U
> Q
Q ZY QY ~
-~
~ E S~Z 2MY Z W ~ ~~d Q~~ ~m(n ~N~ QoZ LLQ-,~Q ~(na W o W
of (0 (~ V~ U N J Q M J S~ Q W S J ~ O
Z Q ~ J Z ~ _Z Q N U ~~ C7 ~
M J
Z Q ~- LL N N W LL M W O rn~ J r W >
~ LL> J W _
~ V~ ~~ m (n r m _
Q ~ W
O
~
`-
~
QJ
r
O
OJ
tt)
N
V
~
~
N
r
ro
r
(O
M
M
N
M
M
~
U
N
N O
M
N o
M v
M r
M r
M o~
M m
M m
M o
~
~
N N N N N N N N N
w
a
v
m
a
wo ~ o
O '~ v
v ~
._
~ ~
~ ~
C
O cD
c0 N
1 I~ N O r u7 N N V' ~fJ N ~p
0 cD V O O f~ N (O V .- I~
U
~ M P T O ~ .- M r m ~ r ~
~ _ _
M N N Hj FA r N (O M• ffT ff) EH (A
O 69 E/i Ni to
U
~ ov> Mo ~nwM ~
c vco vco ~nvrn m
E
m ~
~~ ~o °omv r
~
N ev Fn ~N .-~~ v~
~ ~ e» ~ e»
d
Q
d V U U U U U U U
N v L U U N ~ N U L ` N N L ~- U) N L ~- L ~.
v N N ~ N (6 U
01 (0 Ul ~ U
~ N (0 ~ (0 ( ~ (
cnw
w
cn~~
wF-~
rn Q
j
w
~H N
p
~ 0 t0
N
~ N N ~
u~ wu~
~ wcn
~- w f- w
N
0
M
M
a w
Q w w w > w
~ Q Q > Z
~n cn Q Q _
V
~} F- 2 ^ S J 2 S ~
~~ In ~ Z W H O y- ~ S
Q Q Z rn° rn Q ~ w ~ rn F-
O > ~ o o rn
m Q
U O
O ~ M
c0 m N
N u7
~ Z M (p O
Z
~~ ro r N O I
O O ~ O ~
c
0
fn ~ ~ m Q M ~ ~
~ ~ ~ M ~ ~-
0
M 0
M
M
~ M
~
>
z
°
N
~ Z Z
z a ~ ~
~ O d
Q(n (n W
ZZ
Q z~
~
= O ~ ~
fog- W ~
~
W W
~ ~>~> W
Wz>
m mU`n~ ZN~
~
~ ~ Q ~ J
~ Z ~ Y
Z Z
W ~~ W
0
N
~ ~
N
V
~n M
~
_
M U N N
~ cND ~ Z ~ v
t`")
~ M
~ N
V
_ W M
Ur ~ C
~
. _, _,
_
Z
W
z
~
z
~
aO-
O ~ ~ w
a z
~ ~
U
~
m
w
Q ~ ~ J
W ~
U=
~ a
~~ U
w
°
~cn
~~~ N W ~ O m N W w
U O Y
Q _> U X U_ O W ~ X> J Q
Q
~M~' zOt-- J~Q ~O~ ~
J
~~ J Q ~ p ~° ~ g ~ Y =~ 0
Y A W N a m ¢7 M d F- d W U cO J
N
O V
~ u7
~ M
M ~
~
V
N V
N M N N
N
0 0 ~
M
u~ M
in M
~n
~
Z ~
W
W = ~
Q Z
~ ~ Z
~ ~ W° Z
W
Z
Z J
W
J W
~ Z
Z ~ ~ J Q w
Z = ~ _ ~ ~
d~~ Y~~ 0]Q
Yu~~ ~ cO ~ ~o~ W
~~Y ~°MY ~~U`
~ N W Y~ W Q ~' ~
V cD
~ V
~
N
M V
~ N
~
-~
0
m
a
/ \
O ° °
°~
m ~~N
ri rn m
~ N <n ~
e»
~ m
O M
VN V
O~
c0
(p v
m ~ u~
U
O
(D f~
~
N
O
N M
~ W
UI ~ v> O ~ <{ o
4 _
.- ~ to y~ ~ ~
U
r» ~
N ~ N O
C ~ ~ ~
N O M O
E N (p N
N fA ({3 69
N
N
N
N
Q
N
U U U U
` U
` U U V U
~'
~' U
~ 3 ~' m ~ °~ v v v v v v ~ ~ °' °'
~
cn ~ ~ ~
wcn~ `°
~ a~ ~
w~ ~
w v ~
w a~ v m ~ v ~ ~
w w w w in wcn~
w
w
O
~
w c,
c-
~ U o w
a a `D F- w ~ a
a ~ ~ ~ a
w
a
p
~ Q w Q
u
,
°' ~ p ~ ~ a
Q cn v ~ ~
F
-° ~ w
~ O
O O
O
~ ~
O p
z > U S
O ~ ~ ~-
v Q N ~ U V p = ~ V Q rn
V~ V O (n f/J ~
M U O O w
~ M
~ c0
N ~ m
O
O
u7
N
O
M
~
N O
(n r ~ of O ~ ~ ~ N
~ .-
M
OJ
~ •
-
O O O M M ~ ~ ~ M N
M M _ ~
M M Q VW (O ~ ~ ~ V ~ O
OJ ~ ~ ~ V (D ~ ~ w O u7 ~O O
O ~_, _. _, _. _, _, _ _ rn
N O - W -
~ ~n U N H
2 Q Z o ~ Z w Q
~ O u _o ~ ~ w ~
vi ~ Z Z Z J w ~ Y ik Z~ p
m p w ~ ~ ~ p ~ ~ ~ ~ Z ~ z ~ ~ O > z w ~ ~ Q ~ ~ ~
J
Qua w~ c~i~ w~ mw f-Q xj ~tn ~ g~ z~
c~~ Cw ~~_' w0 O~ wp-w' oQ zm ~~ z~O O=w
Q ~~ rn w U i~ ~° a g w~ ~? F w w> p ~ Q~ ~ Q Q a O~ w Q j w
~~~> ~~> ~~w ~zQ rQw ~ ~ ~~„~ o~~ m~Q ~QU ~aZ
~ ~QmY ~~Y Z~Z ~o~ U~~ Q~m YOU Uo= Z°~Z mMZ ~~na
m ~ Qm~ O< zoz OcD r,v~
z~~w a w QOM a~i ~~m mco¢ ~~m Gv> Q~~ mo~~ ~~~
0
~ ~~ M LO O O M m ~
Q> O O (D O M O OOi ~
]~ ~ ~ 0 O V ~ N N CO
M U O ~ ~ `- r N OJ M
0
m
a
M
v-
w
a
v
0
N
m
C
a
a
~
p ~
47 !^~.
N c- V N
~
~ f ~ I ~ N
~ ~ r .-
69 V1
C N
O I~ c h N V.-
N ifl N (") O N O V N O C p N O N
N u7 ~ I~ ^ O O N O N
U O
O m ~M M ~(O~
~ V V O ~ MO ^
~ N N~tf1M M
~ N N ~ M ~ ~ M
O
U EA t~ to to fA tH
c ^
~ ~
E ~
w ~
N
N
N
N
a
U ` C
~ ~ L
L
L U U U U U U U
` ~ t0
y N N
(D (9 t0 N ~ c0 N N
N N N N Q~ ~ N N
(n W W (n ~ H H F W cn ~j W _
W~ W _
W~ W V7 ~ W
Z ~
~
O O
~
~
#
N
~ M
F-
o
W
w Q ~ U ° a a a
> z z ~ w '" ~ a
z V ~ ~ ~ ~ a
¢ a O a
` O ~ o O ~ z ~ ~ z m z
o
~ ^ m ~ ~ g ~
a Y
~ W X
~
Z
_
~
~
U ~ Z ~ ~
N m
Q ~ o o ~ o a
~ a Z
O ~ ~ ~ N V m ~'1 a
O O
O p
j
O O m ~ N O ^ Qi
O
W
O O
M
~ O
V
H
a
a
~
Z
~ ~ ~
(~ -
Z
~ Z
w
a ~ O
m U
Q Q Z
YY w Q
Y
a
S O ~
w
~N~~ aaz
~
p
W
E w o~ Z
v
Q D
N -, ~ ~ ~ ~ ~
z~ N a~=
N
V m
O
j V
m C)
U N
M O O c0 O O O O C
O M N M M th M M M.
1~ N O ~' M M M [`l C:
~ _. _, __
O
O N O
V # M
~ o
Z ~ Z Z Z Z Np Z ~ Z a Z Z M
~ Z ~ ~ ~ } ~ ~~ ~ w g w w g Z u g ~ a~
~ U m ~ > > cn S
J
~v OZ ~o ~p~OU O~ UN mz C~~ Zn.
~N ~o~ zN ~~a Y(n~ ~~-~ a~~ ~~~ ~~~
~Xa W Z> ~X -aims ~z j am> U~ j ~-N j am>
wm~ O`ol'Y Qm0 O°OZ Z~~ cn~n~ Um~ w~~ cnQ~
OOa K~~ >O~ UFO `„ J ~^~ ~^Y ~rnY u)~Y
-,a~ a w maw z~U ~~w Yew cn~w ~°~w wow
if1 O M O ^
~ ~ O M ~ ~ CO O 6>
(O ~ O .- Q V ~ cD
M V V O
N N N N N N N N N
0
m
0
y~
N
N
EA
C ~n
O 1~
U ~
N ~
N
O ~
U
C
N
E
N
N
N
N
Q
N U
U_ C
Z u
N ~
(n W
N
V-
4-
Q ~
~ ~
> N
a
w
Na
~ N_
~ ~
~ r
Q m
N
U ~
r
N .-
~ ~
O
M
M
U]
O
a. N
W H
Nib 4 Z
N ~_
~ S
-O U Q
Q ~
N
c U ~ ~
Q - ~
~ ~wrn~
v ~ ~ ~
m Q ~ ~
Z C9 .- w
0
N ~ M
N ~
J
c~ U N
O
O
e>
rn
O
N
O
V
M
K3