5.5. ERMUSR 10-11-2011ElkRiver = ,
Municipal Utilities
13069 Orono Parkway • P.O. Box 430
Elk River, MN 55330-0430
UTILITIES CONIMISSION MEETING
eew€sEO ®~
~A~u~~
P p W E R E D T O S E R V E
Phone: 763.441.2020
Fax: 763.441.8099
TO: FROM:
Elk River Municipal Utilities Commission Theresa Slominski -Finance and Office
John Dietz -Chair Manager
Daryl Thompson -Vice Chair
Al Nadeau -Trustee
MEETING DATE: AGENDA ITEM NUMBER:
October 11, 2011 5.5
SUBJECT:
Review and Consider 3'~ Quarter Write-Offs
BACKGROUND:
Third quarter write-offs are presented for your review. These amounts cover items through
August 2011 and total $13,016.59. This amount is comprised of $4,768.22 in accounts sent to a
collection agency for further collection efforts, and $95.04 that are written off with no further
collection efforts. There is also $8,153.33 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 $4,707.48.
(Additionally, we have filed $5,968.59 with the Revenue Recapture program that will hopefully
be collected as individuals file their taxes.)
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.
Our total write-offs for first, second, and third quarter are $55,271.36. (Last year's total of write-
offs for the three quarters was $89,757.97.) 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 second quarter of 2011.
ATTACHMENTS:
3rd Quarter Write-Offs Listing
w
0
a
0
0
U
N
~I
N u7 ~ O lCl ~ W N N CO I~ O ~ O) ~ W
C N (O N O N LL) O (O l0 d' f~ O O
~
~ ~
N O O ~!' 1~ V V r V O r` W C O M
E ~O N
N (D o~ 'V ~ (O N O~ O O O O V
N fA _
fA V~ f9 ~ fA 69 fA ~- 69 fA EA 69
N N (A fA fA EA
N
N
N
Q
U N N N L N N N N N N N N ~ ~~ ~
~
~
(0
~ l0
N
l0
N
~ .
.
N
N N ~
N > N > ~ N > > > >
N
Q
vi a
Q w w
m O > ai ~ Q a ¢ ¢ ~
W to ~ W ~ Z ~ ZQ' Z ~ ii
Q~ F = } Z Z ~ ro rn w m
w F H
N ONj M ~ a0 ~ O ~ V O O M
fn r u'> ~ V ll') ~n ~ ~n
O C' ~ W (O oc00 ~ O W f~ ~
M O
M M M M M I~ M M O M 'Q
~ ~ ~ ~ ~ O) N ~ ~ ~ ~
° O
~ ~ 0 ~ ~
a w U O
w
'~' ~Z Z Z Z Z ~ dwZ ¢Z aZ ¢ Z }YZ
m O~ ~ ~ ~ ~ ~~ LLF-~ QZ~ ~~ Z~ w ~ QQ~
~ Q o_ Q~ ~~ Z Z ~O~
-ap D_' J w ~ J Z (~ d' ~ W ~ Z Q ~ d' O_
QZO XZ k- QQ Zh W ~ Qw Z W -~~ ~O O~ Z W W
d
~ '(pO~ W XJK JX W O~~ Q=O UO~ US~Q OZ W O W Z ~aO YQJ
'~ u~~iz~cC mvo0 z0~ w~~ >wz ~~U ~w~ mw~ woo p~z pco~
r, mQrnJ O~~z W'~J UQ,i°~ Qv0 SwZ Q°F- w°J am} 20~ OMa
Z(n~ W D'~Q WNW ¢NN ~ir~ U~Y (n~(n ~]MW ~~~ F-Vd -~~~
O y~ _
N Y O O (D t0 W (O V' ~ ~ N N
(O VI ~ ~ OD O V l0 N (O ~ ~
N ~ O m ~ M M 7 V c0 ~ d) N
~ U N N N N N
w
0
N
N
m
a
O
m
0
U
N
O
U I
f /~ ~ O ~ ~ O O~ V O A V l I') N O W N N O l I'
C A N CO to V CO N ~ 00 (O W O (O M ~~ I~
N ~ N (O WIC ~N I~ OM O W~ MI~V
E o n v M
`- ao co
~ `- ao ao co o rn e» ~!J V M
en ss e» » v> ea ea en ~ u> » » »
d
w
Q
.U N Y1 a/ d N N N N
~ ~
~ ~ ~
y ~~ N
Z 3~ is m m 3 m .
.
3~ N
m .
.
3~ .
.
m .
.
m m 3 m m
< i ~ ~ ~~ ~~ H n~ ~ >
~ ~~h
n n~ ~ c >F
-
N
W
W
F
¢ > a ~ ~ ¢ ~ >
O Z ~
~
~ (~ ~ J ~-
m ~ ~'
~ m
Z
Q Q m 2 Z Q Z J
~~ d ~ h Q > Q Q
rn >
~
U d F- Q o ~ N oo ~ ~
~ ~ M
~ ~ (O N O V O O N
(n N ~ u7 r O ~ ~ r ~ ~ W
O
M O
M T
O O
M O
M V
(O O
M O
M O
M O
M O
M
M
u7 M
u7 M
~n M
~n M
~ W
7 M
i[1 M
pp in M
~n M
~ M
~n
In ~ ~ N ~ N ~ O u] ~ In ~
w
~ N
F- Z
O
N W W W a Z
r ~
a
m ~z ZQZ W JZ Z Z ~~- z ZZZ Q Z O Z Ur MZ
v~W~ ~~~ ~U~ ~ ~ O
~~ z~ OWE U ~ ~
~ Zp~
v~> W¢ z~ U
w U
w~ Q
zr z ¢> w~ w
¢> m
¢~¢
0 ~~
a0 Oo
Q> >
~~- zz
x~ ¢~'
~~ ~-'
~_ mN
~~ mU
WY w¢
= wF-
az
~
a 5
z
~4~wW OUW mow ~=W Wow C=7~ UAW ~rnw yOw c7
Q~W ZOW
u~
C _
'
w~
'
QCL Q
~>_
'
W V
Wz>
N~ ~
~J
>_
'
~~>
w
' a
a>
w
.->
~
QU>
H
'
iY, N~ u7 d
EO~Y Q
~vY CC NC7 ~
~°Y Z°Y
N J
~°a (n (D Q
~°Y 0 d
QmY N~
W coY CL
U~Y
' N 2
FcoY
`~ f0 Q M J
zz~w ~ J
mmw ¢ N
~~nm ~ J
¢~w ~yJ Q
j J
~~w ~ ,~ O
mMa ~ J
Yew .- J
~~w H~ J
cn~w ~
N J
w.-w ~~ J
mew
0
N N O N W ~ ~ ~ ~ M
~
w
0
M
m
a
O
C
O
V
N
O
U
O
:`
a
c
ice,
O
N
N
N M O
C~(O
N O M
ER EA
N
N
N
!A
N
Q
U
Z 3 ~
m
incn~
l0 O u7 O O COOK O~ V OOJ (ONCD M
C~ O I~ O O N M'7 OM COON NMN V
i0 N ~ Ln O O N N ~ O) M (O O (O I~ M
N W V O N ~"' O r M M N V V M N E A O
fA E9 00 fA CA ~ ER 64 EA EA (fl fA EA 69 fA fA
fA EA fA
N N N N N N N N N y
~m m m m ~ ~mm pia
~ ~ L ~ ~ L L
~ m m ~ m m m
~~~ ~~~ ~
~ w ~_ ~
m?> Q U v~i w W d U U
N> = Z W' Q F- ~ Z W =
F- r O w N ~ H
~ m ~ N O F W H ~ ~ N N
Z O O O N l(') CO O ~ ¢ ~ (O
N m O ~ W N ~ CO (O W
U
J
(p w O aD ~ O V d' O O M O
M D' V V CO M M M N O M M M
u~ ~ ~ ~ co ~ u'~ ~ W ~ u~ co ~
u~ F ~ ~ ^ ~ u~ ~ u~ p ~ ~ ~ ~
Z
~ a
x cn ~ w z
w W z x o ~
N z °~>z ~z ~cnz z z Mz w z z z z z
zQ zx W W Q~ ~
Q W Z O W W
Q~z C7_~ Qz~ 2'O xo mo mw QZCn (n<y zr Z~
'CZO Z JZO 0]O W 2(n J ~Nd' jx ~~" ~ W'U Z mod' ~~ Q ~ 2
~w}d j?Q ~~~ ~2j ai~> ¢¢~ Q~~ UmQ 2X> w2Q yN>
~m0~ ~~Z a~OZ W O'O ~N~ W rn~ Ypw Zo.~~ pmt >~Q ~~~
N (n o x ~~ Z J N O H M O W O J W N O U~ ~ ~ ~ F- W O Y H M J w N Y
Z J v U rG N rG ~ .- U ~] ~ J ~ ~ W -~ ~ d' > N CL -~ V Cn x O_ W (n d' ~ 2 '- W
I~ M ~ u7 I~ O) 00 N (O V oD
~ ~ ~ ~ N ~ C'O O ~ N N N
U N N N N N
w
0
m
m
n.
O
m
.~
c
0
U
N
O
U
NOOM (D W p ~ pN0
- I~
~fJ CO
m (D
O OO
00O W ISO
mNN
C rLL~r N NOD M ~ V O
. 0 M
MONO I~
~ V a0
O O O~ ~ NOS N d' N X6
9 a
O~N
N (fl fA fA M- EA fA fA ~ fA fA EA EA fA EA fA
N ~ ~
U1 ~
1/1
N
V~~ L t N Ul L N N~ L L L L OJ ~ N a y
mm
~
3 m ~m m m ram m m ~ m mm
i
a
ia
~ (n ~ F ~ U ~ F- F- f- F- (n ~i In ~ N
(n (n
f- h-
U
~ ~ ~
o
w p w u
i W ~_ p
? w > w Q ~- W Q O U ~
N
m
O
¢
O
cn
O
F-
w C
7
~ N K = ~ = ~ ~ Y O Z
-p ~ Z H Z F-- W
J Z N Z Z 2
~ ~ ~
~~
V N I~ M
~ a0 r W N
~ M N
~ m ~ ~ N ` OJ c0 M
N M ~ O ~ O O ~ ~ ~ O
U ~
O M O O N (O N O O M ~-
M M M O N M ~ M M M
M M M M V
~n ~n ~n ~n ~n ~n v> ~n ~n co u7
~n Y ~ ~ u~ ~n ~n ~n u~ ~n ~n v>
_ ~
U o
~ W N Z ~ Y
¢ W _ Z >
~ ~ W <"~ Z Z O> Z Z Z m> Z
Z ~ ~ ~ ~ m ~ w ~ ~ Q ~ ~ ~ ~ U ¢ ~ Z ~ ~ } Z ~
-oOz Zwz~ ¢w z~ w z~ ¢F- w~ U ~>
¢F~ cn¢F ¢¢ 00 Uiy ~ _~ C~>z ~_~ W OJ J~ w=Z
~ c¢p ¢ W w' otS u~'~~ f?~ tnOO U` ¢w W 2~ ~,Z¢ 2 W W Z~p ~~O
a `°o°~o OHO o`°> ~~> ~~Q z~w =~~ ~sw~ ~0¢ w~¢ ~Mw
a~J~ W p=Y ¢~w' dc0 f1 f-~Z =O~ Z~~ 2~¢ ZdJ O~n¢ CflMZ
r. Ew°U ¢MU ZrnY O~Y U Z d vO Zm~ U~J ~°C7 ~coJ ~°M~
~p2 ~~ 2pO OOJ d'r_J W p- ~ ~= W N- Ov O- N-
Z(n ~O UN d' d' ~ W d~ W m ~~ U M(n ~~N "'~~U Ql ~~] 0]u'~ ~ ¢.-d
O pp M r_ O M ~ O O M
N ~ O V W r- M W O I~ O N
O O O ~ f0
N ~ N N ~ M M M M M V V ~
6J U N N N N N N N N N N N
w
0
m
~.
^~
l
L
0
C N (O N I~ 7
p I~ M in CO M
U
~ ~ ~
O O
nj Vi N~
U F»
N ~ O~ rln l~ ~ O O M~ M
C M o D N ~ i f 1 N V V O N M r'
NOD MM m000 I~ r O ~ r O
E M M t9 M ~ d' i!1 N I~ Hi N
N efl fA fR ~ EA fA fA ER H3
N
N
N
N
~ U U U U U
U U U _
~ ~ ~ r U
N
~
~ v t/1
~ N U N
N f
6 U
~ U~
N
N
N f~
l9 U
N
tp
~ f0
~ f0
~~ N
w `
~r ~
w ~ _
~
wcn~ w F- w
m ~ m
W
W p
O
}
a a ~
_ O ~
F ai
W O
w ~
W W
Q ~ ~ Z
Z
u, Q ~ ~ D O ~ O
~_
~
¢
Q
Z
Q
H Z
~
¢ F-
Y
H
~ J ~ Y ~ Y ~ W Y Z (n
~
¢ rn > J ~ a ~ rn ~ ~ ¢ m
~ ~' a m a " a >
a~
'U M ~ ¢
~ r LL') N ~ O
(p
2 I~ tU
to
O O
O M
M O
O
aD tfJ
m O
O
r N
W
N ~ W ~ W ~ N O
U ~ O m m ~ O
00 O O O I~ O O r O O O
O ~ M M N M M U O M M M
M V M M ~ M M W M M M M
u7 M ~ ~ M to l!7 ~ IA ~ M M
In ~ LL~ N LL~ tf7 M O ~ ~ N Lf~
= Z Y
O ~ O ~
O~ ~
N z ~z ~z ~z z ~z z ~°¢z ~z ~~z z
a~ ~ m~ z ~ z~ ~ z~ ~ O~ z~ m~ z ~
~`~ ~ w xo ~ Nom= ~ ~~ ~ az ~z
¢cnr w ~o ~v roc? wU ~ wF wc~ ~O ~w
~ ~ ¢w w-_ w~ ¢ w~_ w w~_
M
E¢wg ¢o~o¢ OroY Z~Y (~~~ Z~Y ZmY OHO Z~Y ~~Y ¢~Y
!0 d' ~- W ~ J ¢ J e-J ~JN ¢ ~J ¢OJ O W ~-J ¢ W J ~~+7 J
zmNN ~~m ~cDw ~~w ~M> ~~w oaw ~~~ ~~w ~.-w ~mw
oN ~~ m v o v v rn m ~
O ~ O O .-- V tU O M N V N V
~ U N N N ~ r M ~ ~ ~ ~ O
o ~
a p}
V
~ ~ ~ ~
O '~ °'
~ ~ o
~ ~
crno ~ _~
O M O ~
~ O
~ M ON OD 1~
_ ~ V3 ~ ~
O ~
U
~ o m `c Mo aom vv ~ u~
~ O I~ W 61 I~ Nor r~ O M
N O (O 1~ V V' 1~ (O ~ d' V N ~
O ~ Q~ N N a0 f0 (O O
N fA V3 fR (A ~ N N fA N fA ffl EA
N fA fA fff fA fA
N
y
N
Q
N U ` C C
U '~ ~ L ~ ~ ~ ~ ~ ~ ~ L ~ L L L
' N U f/1 f/1 (J N
~~ti m m ~~m ~m a~i~mm ~ mm m ~ m
<nw~ ~ ~- wcn~ <n~ wcn~t`- w fir`- F= w ~-
~ ~
r
a o N
'c Q ~ cu
~ U a w
Y W p F- ¢ Z Q
N Q F Q ~ ~ ~ Z J ~
-`O fn W F Z W ~ (n ~ Z O Y
QO Qz ~' ~ _ ¢ 00 ~ U a
N OU O F
N - _ _
J
O N ~ W c0 1~ M N
U~ O of r C (O ~ N
O (O M ~ ~ O M V O
N ~ W - ~ D) W V CO ~ O O ~
UJ ~ N M
M
M
F
a
,n _
d' .- ~ p O M O O O O aD M
Q O ~ (O M O M M M O M O
M M M M M M M M M V M
J (O F ~ ~ to to ~ ~ ~ ~ ~ ~
Q In a In to to In In In 41 4] ~ ~
~ Q
W
Q r ~ ~
w ~ ~ w ~ w
z~ ~~ z~~ N~ ~ W~~ ~a~ zz ~z QWZ ~Zz
wz F-- ~z ~~~ z~ Uzi O~~
~ ~z ~w a ~ m wQ inv rn~ Wit- W~
Z U
aUZ ~w z¢ ~w z Wp a¢ az O= ~r~ ~~
c(n- J W 2 ~> Y W JZ W (n C1Q UH otSUO ~Y
a ~;QO W~U W~> U= Wow W~> w;w ~~O ~~~ vow ZWw
' N Q~ Q ~ W ~ Q V Q 2 m~ N d' ~ W~ S W W N d' ~ Z O W (n
NU Ko(~ 2i COY UNO >-vY U_vY aoY ~mU >rnY FaOZ (nrn~
M ~ Q N F W M (n Q V J J ~ Z Q r J O J J ~p J Q M F- Q O J Q V Q u a
Z~.-(n ~~O J~ W QNQ ~N W ~~ W UN W m~0 O~ W dN~ ~~~
o
N ~~ m V tN0 N I~ ~ N N W
M N l0 ~ O V V I~ 4'1 N ~ V cD
m ' U o ~- r ~ (O (D ~ N N N N
.._.
0
m
d
o~
O
N
N
Q~
~
~
¢
v
ON
Y1 U O N ~
~
~ r
~ ~
~
C V ~ O
O
`
U V N
N ~ O ~
O ~
U
m
c
a~
E
N
!/1
N
N
N
Q
N` C ~ C ~ C
U'
U U U N U U U
N N N
_ N N N
~
cnw w .
w~ w w w
m
v
M
L
y
A
F-
~~~~
• Y
~y ~~
Yp
1
tf> I~ ~U N O
end I~ ~O
I~ N M d O
V M NEAN
fA fA (A fA
o
O ~
N ~
fA
W
M
O
N
fR
vo
o~ v
of ai of
m ~ F»
» f»
C
~ ~ f0 N N ~ (0 to
wcn~r~ cn~~
w
O
O ~
N
~
Z
N O d
> a a w
¢ ¢ ¢ >
Q
N ~ ~ ~
W W
> H
~ ~
w J
~O J
O ~ ¢ ~. O
~ ~ ~ ~ z ¢ ~
>
jai
U ~ a
W ~ a
Z o
o
m
~n m
'n
v
~ O
(n ~ O M
N CO
M ~ ~
W
Q
W
M
0
N
H
a
¢
0
Y
Q
a
z
O
J
u]
0
U _U
~ L ~
N ~ N
w F- w
~
a
a ~
w
Q ~
J ~
d
¢ ~
Z
~ z w
w
~
X }
m F
~ N
Q ~ O
O
co o co
7 N ~
~ N
O O O M O ~ O O
~ M W O M O M M
O M OD M M O M M
~ ~A V tU u] ~ ~ ~
to 47 N «) Z 47 ~ ~ ~ tU
O z
N J (O >
N Z d Z ~ Z U F Z ~ Z ~ Z a Z
a> ~~ Q~ ~ ~~ a~ ~ z~ Q~
Z Z f- Z W Z Q U
_~acn 00 ~z ~ > >~ cnz~ 1~~
C k-U JO W QOM ZQ QQw ~ JO W ~Z W
~ZMQ 2lU> zU` ~ O~~ wC~> JQW mz>_ OOQ>_
z~M~ w°w Ojai C=3~O ~°•°-w O`Om ~'rw ¢ ~w
0 ~ pOj ~ V (O N Q~
N~ ~ O N N r r
U N N N N N N N N
O cD ~
M
~ N
M M
U7
~ ~ ~
~
Q ~
~ W Z
~
Z
J Q ? U
Oz K
O~w 07
O~
Qm>
r 7 JZ~
W ~Q a¢O
QJw
U
~ z
O~ J
~~n W U M J
~co~ r r F
F-~O
I~ V ~
~
N ~
N ~l]
N
0
m
m
of l
~~~~
O N
U ~
N ~
O
U ~
f/1 M
C M
CN th
C ~
N r
N dp
N 69
Ul
Ul
Q
N
U
2
N
N
r
-`o
a
U
N
N
N
N
U
V
Q
C
n
m
M E
m
z
0
N
~ ~
N ~
rn U