5.2. ERMUSR 01-10-2012Elk River
Municipal Utilities
13069 Orono Parkway • P.O. Box 430
Elk River, MN 55330-0430
UTILITIES COMMISSION MEETING
Phone: 763.441.2020
Fax: 763.441.8099
TO: FROM:
Elk River Municipal Utilities Commission Theresa Slominski -Finance Director
John Dietz, Chair
Daryl Thompson, Trustee
MEETING DATE: AGENDA ITEM NUMBER:
Janua 10, 2012 5,2
SUBJECT:
Review and Consider Fourth uarter Write-offs
BACKGROUND:
Fourth quarter write-offs are presented for your review. These amounts cover items since the last write-
_. offs (which were through 9/30/2011) and total $22,411.98. The breakdown is $3,150.74 in accounts sent
to a collection agency for further collection efforts, and $782.65 that are written off with no further
collection efforts, $18,263.35 submitted to the Revenue Recapture process (new this summer) and
$215.24 will be assessed next year. Additionally, there is $3,204.66 that is being written off in med-alert
accounts.
DISCUSSION:
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 that appear in the
collection write-off column. There are also some bankruptcies noted.
The med-alert accounts that are being written off are the final result of a long process to properly bill and
collect on these customers. To review the process, we started on a program with the County to place
med-alert units in individuals' homes that were paid for through insurance. Originally the County billed
us for these units and also paid the insurance companies. After a few years, the County removed
themselves from the billing and told us to bill the insurances directly. This proved to be a very big
challenge, and one we were unprepared for. After trying unsuccessfully to bill 100% through the
insurance companies' various mandated means and insurance code, we recruited Advantage Billing to do
this billing for us on a per contract basis. Advantage Billing has been a great resource for us to handle
and secure recovery on the insurance billings, and will definitely help with future billings. However,
even they were unable to collect on some of the billings because of the time lapse from when the account
was firs[ billed through our system to when we turned the accounts over to them.
The collection efforts put in place this year have resulted in smaller write-offs for 2011. With [he above
mentioned write-offs the year-to-date total for 2011 would be $80,888 (write-offs for 2010 were
$116,246.81.) This is less than 1/2% (.003) of total sales. Also, throughout the year we have collected
approximately $8,300 on accounts previously written off.
ACTION REQUESTED:
Staff recommends that the Elk River Municipal Utilities Commission accept this write-off listing for the
fourth quarter of 201 1.
0
o
U
N
N
C- O O)
U ~
j ~ O
O ffl
U
~ w
d
N
N
L ~'
~ Q
Q~ V U
~ N
a mw
3
W CO N M ~
aD O O M m M
~ O M if)
M ~ ~ 0
1 V 47 ~
N M N N N V fA
fA fA fA EA fA fA
M fD
~
m
fA ~
U U U U U U U U U
L C C C
U U U U U U U U U
N d N UI N N N _N _N
W w w w w w w w w
0
a~
.=
.`
F-
~ ;
~ ¢
w
~
F O
N ~ Q Z
~ z ~ W
Q
O
m O
~ U c~ ~ x
Z ~ O M
N r O r
O a0
(n N ltd 00
w
a
(7
f-
O
U
Z
O
U
O
N
N
N
W
W
Z
W
¢
Y
K
¢
d
v
N
N
m
m
a
¢
W
O
F-
U
O
a
v
CO
z
O
J
O
W
ro
N
F
d
r
O
O
0
O
r
N
U
N
w
U
w
U
Z
a0
0
W
M O OM N 0 O O O ~ M O
M M M M M M M M M I~ M
LL~ ~ N Ln In to In In ~ ~ ~
~ ~n ~n W ~ ~ ~ ~ ~ ~ ~ ~
J ~
~ ¢
W Q Z
RZ
N Z Z ~yJZ W HZ Z pZ Z ~Z Z ~Z ~~-Z
N ~ ~ ~ ~ Z ~ ~ ~ J ~ ~ ¢ ~ W ~ F ~ ~ ~
~ ¢¢ W ~¢ H O ¢ ~ W ~ N O W J O O ~ Z
¢ C 2 c p 1 Y 2 a Z 2 c 0 W_ Z J J O Z = Z O Z¢
v 'N~~W U2 x~W YO UR'~w °OKQ LLww WZZ zrW ~~¢ ~a W
`" d~~K m~¢ Qz~ t7~~ ~~~ woY Oaa Z~~ ~m~ =00 z70
E J m Y W ON ~ Q N J ~' ~¢ J O J W~ OZ O p p W~ x ~ O J W p O O~ Z
m J O J
z~aw -~.-¢ <nmw U~o maw o~¢ wmm --~~v i=-~w m.-r ~~¢
o _
N _ O W
~ ~ ~ aD c0 M O) V (O V O
N~ ~ ~p O N d' N f~ r O
U~ v v ~ cMO ~ m rn ~ ~ ~
r ~
s ~
V ~ ~ ~ ~'
I
O ~
~ N
1 ~ ~~
~!
~
~ p
(Op
p
O O
M O O
O
~ N O N N ~ ~
~ V O
~ N~ M N ~ M69
~ » ea f» ~
C N N N
O ~ M N
U r W O
p7 N O ~
M _ V
O ~ EA fA
U
N
C
N
N
N
U)
f/1
N
U U U U U V U U U U U U
Z U U U U N U U U U U
N U
N U U
N
N
O N N N N._ N N N N _
W .
W~
(n W W W W~ W W W W W
N
G
N N
°
M
~ a o a
~ ¢ ^
N¢ ? O z ¢ ~ a U w ¢ ¢
N H F- ~ ~ W Z U ~ N 2
=
-O ~ ~ Z
-
O m O
~ O ~ O rn ~
m'- ~ ~ U ~ ~ ~ _
' V O
r t0
m O
~ V
cv ~
~ ~ ¢ V
~ V
°' 1~
~ W
m
Z
W
~ O OD
O ~
W O
O) I~ ~
~ M
O m
`
~
~
~ r ~
~ ~ fD T O O I~ N M O
r ~ (p M ~- M M M
O M M M 1~ M V V M
~ ~ ~O ~ ~ ~O LL~ N t0 O to ~
O ~ ~ N ~ ~ ~ ~ ~ M ~ M ~ N
z d
d d ~ M ¢
W ~ z
¢~ ?M~ = g z>~ w ~ Ova Z~ ~~ ~~ ~~~ o?~
~zW ~zx ~z ~¢ z za > ~ za z~ ~~
t ¢W KJ YJO J2~ ~~Z mFY ~zO FHA WOE Z~ f-~O ~~~
v z=~~ j(=0 ~~~ zOa ~Ng «sNw gn°'> ~>_ °°~?w z~w¢ W a>
NW ^ J U¢O W _~~d QN~ O~Q ~~~ W O0_'. ZQ' J a' ~Q J~OZ O M ~
__ ZON¢ ~ d'Z ~Q V ¢ W ~S ~(OJ ¢OU }~J X00 =d' ~ ¢ off? UOJ
Y~~ ~'-U NFU ~~n~ }~ W W M2 (n.--L~ ->rn~ Z~ W
7
V
n ~ N M N I~ M V N 7 N N O
(D O M I~ r O O W ~O O
V O ~ ~ ~ ~ ~ O ~ ~ O ~ ~
U
m
w
0
M
N
N
a
N
O
i
w
.`
~
I
~
~ O
d)
~
1N
M ,~
O o
N v
O
U M ~ ~ p (D
~ O r
W
~ ~ d: ~ W N
~ N ~ M ~
M ~ ~
> N M ~_ M Vi ~ ~
C
O
U
I
d
O
U
N
C
41
E
N
N
N
N
¢
`
`
`
.` U
.y U
'C
U ` ` `
Z ~ a> ~ a> N ~ W
~~ ~ N _
W cG W W W W W W
(n W W W
M
O M O O
w N N
z
r
r O
~ F d
w
¢
~
Q a
¢
j Q ~ w w
¢ Q > ~ ~ p ~ _
O ¢ Q
a w ¢ O J rn
m ~ O w
m x O
Y ~ ~ ~ } ~ m ~
v~ K
~ g ~
~ d ~ U 0+ c00 r r ~ rn
U (O O M N r c
>
M ~ N a7 ^ O
O N Q) ~ ~ W a0 ~ ~ r r
U) M
~ O W r
r
M
O O O V M M O O M
N
~ M N ~ ~ ~ ~ ~ ~ O ~ ~
N ~
~ ~ O
F M ~
d N W M
N~ z >az v~gz w z az zz z ~
~ V ~ ~w~ z~ wF~ ~z~ Oz~ O~~ Kz~ w0~ Zw
a Z W_> ZO ~~ WO mZ~ d'J ~J W (!Jw KQ
¢Y~ ¢m F¢ O= w0 z~ ~J~ WO a=> ~=J U=O
Q cW?~ ¢~ t=7?~ w~~ ?~w ~pU oQQ~a ?~w <°~'~ ~~~ z~w
c~i ~YS>_ ZOO ZM2 ~~~ =U~ Y~nw XoZ ~~~ ~~Y arm ~~Z
~U~~ wm(n m"'Y QrnY dNY ZOO Jw? =NJ W u Q NJ Q(OOK
~- m K o ~ Q O U Q o J ~ m J Q N J ~ ~ ~~ U~ w Y v 0 ¢ ~ Q Z v d
ZWcow Jd0 cn~w mew ~.-w mN~
o
in ~ OMD N O ~ 00 ~ M (NO N N N
~ ~I W O ` N N N N. N N N N
U r N N
r
s
o
m
U ~
N O V OJ !~ O ~ ~ N O W O N
~ O I S O (p O N
O1 V (O ~ M u~
~
O N
~
K ~ ~ ~ ~ ~ ~ EA EA f9
N EA
N- efl ~
C
O
U
I
N
O
U
w
C
N
E
N
N
N
fA
Q
U .U U U U U U U U U U U
U U U U U U U U U
( U ~
N N N J U
~ _ _N N N N N N .~? N .N N
vow w w w w W W w w~ w~ _
w
N
N
O
QJ ~ M F 7 N u')
C
-
-
Q O
a
N
~
F
a F
a
~ F
a H
~
N ¢ ~ Q w a
M W
rn J
~p ~
J d
Q Q
p J Q
a J ~' ~ U J
O O O ¢ z O
O O O ~
Q ~ _ ~ ~ = ~ z ~
~~
Z ,~ U
cn F-
~
m U ~ ~ ~
a j
w N U
cn
~
N .n
O _
O ~ tU o
Ln N
(/7 r u7 ~- r r ~ ~ ~ N
~ W M
O O M O O O r N r m
N (O I~ r O
M M M M M M M M M M
N N ~ ~ to _ N M ~ N u7 u7
W
K
Q W ~ ~ ~ W ~
=z O ~ ~
m Zz ~z y zWZ ~~z ~QZ o oz c=i> z ~ z z
~z~~ ~z~ oz O~~ ~z~ Yw~ ~ ~ w~ ~ ~ O ~ z ~
w C7 =
Q ¢ z ~ ¢ z ~~ ~~ Q~ ~ N ~° ~ O H z m W Z u~i
v O~w =~w Oxcn ¢Op mew z.-w ~wUU ~zw ~QO wa0 ~w
z r- ~ O o m O F-- p= ~- w
N E Q~ Y (n N Y S p y W~~ Q p Y ~ r Y ~ V OJ Q to Z ~~ Z_ ~~ _Z J a Q
`- f 0 S p p J J n J Q O J Q ~ F ~ O J O ~ J ~~ ~ Q~ p p O O O H W O E O (OO ( J
Z(n .-W W ~ W 2~ W Zro0 ~.-W C7~ W ~~fn F ~~ JcOd -~Md SNCII
0
N
~ ~I N m ~ ~ V t(7 f~ O V M m
N M M t0 I~ 00 W ~ m O O O
N ~ M M M M M M M M ~ ~ ~
.. ^~ ^~ N N N N N
0
o
a ~
NI O
~ r
d MN
GI
O
d
O
U
c
E
m
w
d
N
ul
Q
N U
U 'C
In W
N
Q
+~+
Q
v
N
O
N
r
c9
a
N Q
N
V ~
¢?
N Q
U~
N V
mrn
~
~ ~ V N
M O
r ~ M
~ (p t3~ O O ~ O
000 ~ O ~ N
00 r
~ ~ ~ E9 ~ ~
fA ~
U
U U U
U U U U
U U N d
a~ ~ - -
N
W
a
F-
a
Q
z
V
N
~ U
~ ~ ~ N
W W W ~
~p r
_
N N
~ ~ a
Q
w
~ ~
N
O O ~
U rn
U
m m ~
r
N N
W W W W
O
r
0
fA
V
U
N
W
V
O Q
F
Q
o
~
Q
fn
Z
J
~
Q
r
-
~
~_
~
~
O
N O
N
r
¢
~
J
O
_
m
p
O O
M
F
¢
`~
J
O
=
m
N
` r
~
Q
w
~
O
O
a
V
~
a
O
a0
FA
U
U
N
W
F
a
F-
m
J
O
O
2
U
r
~ O rn O Z M M
rn o v ,~
r~ r '"> m
m ~ ~ ~ ~ in ~ ~ ~ ~ ~ umi
~ ~ ~ ~ ~ ~ ~
O r m > ~
~ N ~ M K
~ ~ ~ Z J Z ~ w Z Q Z d Z
N O ~ ~ ~ Z ~ Q ~ ~ ~ ~ Z ~ W ~ ~ Z ~ ~ Q 2 Z ~ Q ~
QO W Y -~J -WiJ W Q ~OZ W S ~W Q~ SZ UO
c~?~ QO ¢_ ~O~ Q~ Y~Q ~~-~ Qm 2Z v~0 Z~w
mH~W Jm ar zcz.» }~~ ~°~ Qc~i>> ~cQ7a oW~ ~x¢ ~cvi>?
~W U m. W ~ W Qom- W W ~w =rCC Qco~ ZUQ wF-W Q ~
~a~Z 7p~ ~ur7ZQJ HNY ~a~~ }~~ ~~pJ QMZ ~~H ~M7 Q.r-J
Z~N~ ~~~ UN W Z~ W QN~ KNN -NNW (/J~O QM(n W ~m (n~W
r r 0 O O ~ N (+') N ~ ~
tp N N V ~ ~ ~ ~ V N
U N N N N N _ N N N N N
0
of
N M W ~
O ~
O ~ ~ O u] O (O
~ N W OD
a0
» M
n O
m N
m V
V Op
M dp
e0 O O (p
N fA
M
f9
69 N (O
~
N
~
~
N W (A
~ fA
C
O
~
~
~ ~ M
~
O M
U fy ~
.n
C
U1
Ul
N
d
f/1
U1
Q
U ~ 'C 'C ~ 'C ' ' U
U U U U U C
U C
U ~
U L
U C
U U U
~ U1 _N N N N N N N N N .N N
(n W W W W W W _
W W W _
W~ W
UI
~
O
O N
~ U
N Mo _
N
a V
~
a
¢ M
~
N
~-
Q a ¢ o Q a
Z w ~
~~ W ~ ~ ¢ > ci
N ~ ~ Q N Q ~
O Z Q J R
_ 2
~-- O
O
m
F-
~ °' j °' w O o ° O ~ O
~
~ o w ~ ~ a m M rn v a
o
0 n
~' ~n rn o
O
~
rn
O
o
~
n
(n M ~- M 07 M
M ~ ~ ~
~ aD M tU O N O n
O M M V O ~ M M ~ O O O
N in u~ ~n Z
N tU tfJ In ~ ~ ~ ~ 47 N M ~ U7 u7
a ~ m
p H o ~ O
~ (n Z F- J
~~~ Z > Z Z Q Z Z Z Q Z W> J Z Z ~ Z
a~ l 1 J~ O ~ ~~ 0 ~ W~ U~ W~ Z Q~ ~ W~ ~ Z Z~
a 2~ 2~ Z Z ~ O Z ~ Z Q W
Q U m H F F ~ H ~ W Z Y Q ~ ~ W (n ~ 1
~ fnZ~ Z(nZ F(n Q~ Ja Y~ aZ QH ~~ W Q KQ
v w ~ O ~ ~ ~ J J ~ ai ¢ O a ~ r w_ Q ~ ~ ~ ~ ~ w 2 _~> ¢ ~ ~ U ~ ~
N 2QU' W J~W Q>> o~SZ~ ANY ~ZJ H~>_ ~OxZ Z~F UFO Qao~
_ N20Z JN~ ~ ~~ Zp(~ JNg W p-~ ^m~' ~SO~ >~ W OJ V ~' ~ M0'
mQo? 2~j~ =~Z QNpZ O°n'~ OnviQ ~rni~ ~rNi~ FW-~m Q~~ w~~
~ ZZ~~ (nNN ~~Q C~MJ -,gym ~co~ mMw O~2 cn~¢ a.-w o~w
0
N
~ ~ V N ~ V W M ~ p tom') O n
~ co co <o n n ro v co
N ~ ~ ^ ~ ~ N N N N N ~ ~ ~
N N N
o O O s..
~ ~ ~~
o
~ d N ~
2 j ~ M
N
~ N r ~ ~ (00 O ~
O
~ O N
O O
I
~ O W ~ ~ m
C m
~ ~
I
U M
N ~
O ~
U
v
m '~'
c
~
E ~
N
N
N
fn
Q
N
U
`
`
C
~ U
~ U
C U
C
L
U
_U 'C
U `
_
U d N N N V U
N N U
N U
~ W
~
N
d
~
W
W
W~
W
W
F- W
(n W W W w
N
O
~ o
~
~ M
M ~ .
-
N N
a ¢ a v~ ¢ ~ w
Q W N Q M W (n
Z Z
~
(n w
¢ ~ r ~ r ¢ J
N Z_ ¢ p ¢ Z Z ~ Z
~ O
= v ~ cn ~ ~ o
~ p z `° ~
Q rn ~ p U ~ - ~ Q N Z
N~
.
M Q
m ~
M ~ ~ m W
W ~ ap N
Z O O
r O N
r O
M 01
M r
r N
V ~
Qf M
O
(n O r t
+] ~
a0 O O N N
M M M ~ uMi v Z co
~ N ~ 1t7 ~ (fl ~ ~
O
Q
W F- >
N ~ W>~ W~ W N~ Z~' Q~ F- Y
ZZW Wln
Q W ~~ Q O d Z Z W U Z m W
~ Z Z m Y
Q ~= J Z_ W Q U O
Q cJaQ ~`Y ~~d' S~~ Yc~o~ JJ~ aS' ~O
N ~~~ W ~O.O m¢a' O~K OC02 ~Qd W'7 d'
prn~ pN~ ~mY >OY ~oY °~ ~'°r'W
W .~ QoJ W O ~~O
ZSNN Q`r°O QM W OM W a.~ W m~Z
o rn
N N V O ~ ~ M
N ~ 1fl ~ N N N N N
UIN N
Z
0 o O M ~
~ yMj N
F- ~ ,~ w ~ u~
~ ~
U ~ Z ~ Z
Q ~ J ~ J Z~ Z Z~
OW
w> HZ W O v»
F ~Q
Z= W ~ (=jSQ ~SZ
a>f ~ W ~~ W ~~~ dpO
=~C7 =~U' 0_rriO Y~~
(n ~ m (n ~ m m N~ d
m
M
~ ~
N N ~ r
D
O ~ ~ O M
N O ~ M ~
9 N O M
L ~ ~ tH ~
CIO OHO ~ ~m~
Nm ~aMD V rf~
~ `- M~ N O r OMN
Odi ~ ~M~
~~ ~~~ to (A f9
fR
V~
C
O ~ ~
N a~0 ~
p yVy EA
U
N ~p
C O to
W
~ ~
to ~ Vj
U)
N
N
y
Q
~~ ~ v C C C C C
U U ?~ ~ U
ZU ~m m ~~m aUi~ ~ a~~i.N m d m ~ ~
cnw cn~ ~ wv~~ w~ w w~ F- w wcn~ w
w
G
J
N o
OJ N
O
> ~ a
u~i ~ ~ W a w
N~ Z Z U ~ Q l~ F- W Q
~~ ~~ ~ 2 ~ U Q W Z
v F Jp ~ ~ R ~ J J (~ F-
~~ m j oo O ~ ~ o Z _~ p
O ~f) 00 ~ d > ~
Z~ ~ ~ O ~ ~ N W w C~O m
N ~IJ m O ~ O O Orn0 ~ V O M
N M M
m
O
M
M
O O OM a M M O O M O ~ O
~ O uM, Q aD M M M (~] M
~ N u7 p tN'J N ~ N ~ ~ ~ N
> ~ Ln a. ~ ~ N Ln
w J Z W
~ p ~ pmp o
O O
Nz z z Zz g~~ z zz wiz ~?z NZ ~~ Q~
~~~~ N ~ cnF-~ QC~W w ~ H~ >z~ Qw~ a~ ?FZ z
_ cn z ~ w
¢~¢ ~~ wz xa ~ zw ~> ~~ Ow OW U¢
x Q ~ ~~ o z W~ 0 0 LL Q ¢~ cn > ~~ W O
a °°cxnw ZOz Qm~ x~o y~~ Wz~ oa~~ ~w~ Z~rt =~Q o~~
z~Z> mQa ~¢> °~OUZ wx> ~~> ZN> pWp~ x¢j w~a j~j
,-. E~~ Y Q o Q Quo- Y ~ M ~ U m Y ~~ y ~~ y Q v Z ~~ y Q~ W FQ m y
z~row ~°vU m°'w UFO ~°w ai~w o~w ¢~~ O'v.,w w°pw Yc+Miw
y
O ~ M
`- ~ a0 O O N ~ m (O m ~ n ~
v Iii M V (O (D ~ O M M ~ ~
N N N N N
o ~„
~ ~ M
O
~ I ~
a ~
N
N N O O
~ ~ M
I ~ M
fA fA N
~ ~ ~
C
O
U
I
N
O
U
N
M
V ~ O
1~ O
.
.
C
N V ~ O ~
~N fp
~
N
N
N
N
IA
Q
N N
l ~ W In 2i
(n W (n ~ W F-
N
i
N
..+ _
~ F
~ W
Q Q
~ W F Z
d
O ~
F- 0 2
~ ~ ~ } ~ W ~
>
~ _ ~ ~
N Q
~ CO
r
U ~ ~ ~
Z V
N ~ O
O N
~
~ 0
W O
(n V
O
M OD O ~ ~ t7
O M M M ~ N
~ ~ ~ ~ O ~
W
r
M
M
N
N
ro
V
r
O
r
th
N
N
N
~ 'n ~ Y
(~
= Z
~ W
~ ~ Z m Z
J ~ ~ ~ ~ ~ Q ~ ~ U ~
'O J Z W ~ Z
W J
~ ¢0_? ~~Z ~2'o K~ W Q~ QF a'
Q c(LS W SQ ~~~ 6UZ Hv W drn W
v maU` c~oY U~~ m2> "W O otSX> °~~>
iii ~,8~~ ~~~ Y~~ JOB W mY ~oY
~U°~ ~`N°~ aN~ WSO Flaw o°w
m K ~ ~ ~ W ~
ZW oo F-NN ~~
M O
N ~ M V ~ ~ Q~
r ~ ~ ~ ~ ~ ~ ~
r UIN N N N N N
~ "'.~Y V d'
ri
~
v M ~ V
o S+J +75
a~
.
~ t0
~o O
n
,~
, . ~
t v
M ~
C ~ Oy'
„j~~.~TV ~~ N ~ ~~ i, ~
L' ~x
C
Y _
L
~ d
u u z z r r r z m r
L
". a
W
3 G-
a +'d'
u
N ~~ C
O
6 'p. ~.,
a' ' ~ •'~
c
Z
~
o
F- p V
W ~ ~
:
LG H C
C
L
Y
d_ ~
• ~
u
00 c
w
C
w
u~ a Q -p ~ C
v O
C N Y
~
V C ~ U ~ Y d
j -.6 Y w
lD M M 0p Lf1 O1 M O
N .-~ O O N ~N M V
,~ 0 0 0 0 .~'.
O O
,
H N.
m -.',.. ~ :.. .
O O Q
~-
Q VI Vf
A
d
~ ~ A
N C Oq
> > C
~ 9
Q Q m
d
u
~ C
A
N ~
7 m
Q C
a
ti
u
Q
;, ; a
.:
~D
,x. to
N
N .
,
',. IA 'i W
0
N
V
N
VT
CO
ei
N
VT
W
N
N
N
(/T
~
~ N
~ r., M N
~ d;, a
~
~
^
i IX
01
' N
~
N ,, p § M
N N
N