5.3. ERMUSR 07-12-2011Elk 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.5099
TO: FROM:
Elk River Municipal Utilities Commission Theresa Slominski -Finance Director
John Dietz, Chair
Daryl Thompson, Vice Chair
Allan Nadeau, Trustee i
MEETING DATE: AGENDA ITEM NUMBER:
Jul 12, 2011 5.3
SUBJECT:
Second Quarter Write-offs
BACKGROUND:
Second quarter write-offs are presented for your review. These amounts cover items through
May 2011 and total $22,590.69. This amount is comprised of $13,383.25 in accounts sent to a
°, collection agency for further collection efforts, and $2,219.84 that are written off with no further
collection efforts. There is also $6,987.60 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 $12,981.84.
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 and second quarter are $42,254.77. (Last year's total of write-offs
for first and second quarter was $80,657.15.) Excluding the assessable amounts, this would result
in less than 1/2% (.32%) of total sales for projections of 201 I 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.
o
N
N
~ K
7
f0
a 4
V
~ O
O ~
N Q1
- N
~
C
O
U
N
O
UI
NCO
C .-N ~
tD ~ ~ V (O OJ~ ~ (D W f~ O
N.-~ N c0 N I~ .-N r OM V O
Eon v M mc~
~ o~ mc0 u~ o
V3 di 69 ~ kA to ~ e» (A (A Vi
Q
~ U
U Ql
~ N O) N N N ~ N ~ ~ N ~ U ~
3m 3m ~ 3m m a~ ~
cncn~ ~ ~ ~ ~~ cn~ ~ ink ~ w ~
O z
N ° rn
~ o
w ~
J H
w a a
w
~ J m ~ ~ Q
n
. J
~ O
` Q Z H H U 2 H D Q =
-
o f- Z 2 (n to W h ~ Q (n F-
C O
O ~ m S Z_ Q m Z ~ Q m
v~
a
~ ~
~
C >
N
co
~
o
w
rn
Z ~ a ro ° ~ M
a v
i ° o ~ o
N ~ f~ M N O V O _
N M
(n u~ ~n u~ ~ rn
O O O O V O O M O O
M O O M M (O M M O M M
M M M M M W M M I~ M M
~ ~ ~ ~ ~ ~ ~ O LL'1 ~ to ~
N
E" F-
~ w . w a z
w Q
N ~z z z '~''az z z a°- z ~~z z Q z Q z
~a>~ ~Q~ z~~ w ~ w~~ ~>~ z~ ~Q~ ~ LL ~ m~~
QQQ O° ~ ZZ Q F [YJ (n LL mU
o -`°~~w O~~ otS~y ~1=-> wZ> ~~~ U~ j ~rn~ OXQ h=-X>_ °~d>
O N~ l[) a' W N W Q a' Q W V~ Z N a' J (n J (n (O ~ w O a' J7 m a' w m~ ~~ a'
o ~OQM~ JQm QNC7 ~~ J wrn~ ~~p ~~Y QO'J pOa >O J ~rJ
zz~w m~¢ ~~nm ¢~w ~~w mMa Yew ~~w ~a~ wa w cn'-w
~ rn in cn ~ oo `r'
M u~ N O m M a ~ ~ O O V T
(p U N N N N N ~ ~ ~ N O O
0
M
?
N
~t ~
//^\\
~ m r ~ N O
O ~ O M~ O
~ ~ NO (00
I~ •-O m(D
O ~~fA lA
(fl eA
Vi
C ~p ~ f~ M O O
O O~ V M V [D O
U (p N M O 00 O
~~ O N O O N
- N N M N I~ (A
O M tfi to EH Ifs
UI
~n O NN O OJ OU7 MO OO
~ O (O M V ~~ I~ r O O N
N O N ~ V M I~ a M O r~
O O N m A V M f~ O M M
~ M V3 fA (fl fA fA to
~ ~ EA
N
N
N
Q
O
C
U
O
O L
O C
N N L
U) O C
N N C C ~
v N~
N O N Id N lD N ~ ~9 (D ~ f0 _N ~ l6 N N Ul ~ ~ N N N
~ ~ ~ _
Wcn~ cn~ wcn~ w w~ Wcn~~-~
cnw H ~
N
O
N W p N
- Z ~ ~
W W Q
J
~ H
U
~
Z ~
~ ~
~
w
Z ~
Q
U U
in W
~'
~ W Z O Q ~ Z w U
a
i
O Q p ~ F ~ Z Z
~ O Q C7
Q W Z O ~
Q p Q ~ ) m ~ J > O
"U a M m N ~ In ~ m V O
I~ M 6~ ~ O O Q> O ~
OJ O Q~ W N N O~ f~ N N
(n N ~ ~ ~ W ~ N M ~
d V O O O
M M M M M
~ N ~ ~ O
~ N ~ O ~
Z
z O
~ p a
p > ~
~N~ Z mZ O Z Z Ur c~+) Z
N W W~ ~ x ~ ~ Z p~
Z - O ~" W ~
Q~w za w¢ ~ w~
~ a~ J x ,~ a z
~~Q ~p ZO~'w ~~w }=w
rn N Q V W W S W ~~ O K H N K
~ ~xrn0 0~ UMY Om Fco
° ~aUmO Q ~O ~°N°J QOJ ~~Y
z~ ~ INK w w maw m w
0
N_ ~ ~
M ~ ~ m OOi M M
cD U ~ rn rn ~ .-
(O 00 ~ ~ O
M M M M M
O ~ ~ ~l O
~ ~ ~ ~ N
Y
W
J
z z z ¢ z ~z
~ ~ ~ ~ ~ Z ~
Hp F- m dU
W W~ W _J Z O}
WZ Z~ U Z ~I-J x U
ZOZ ~¢ w.-O W cn W Uzi
z~- ~ O~w ~~~ xsz= d ~w
a
mom w~a omz ~~~? zoo
_ J ~ Q m Y
(np2 G~~ QO d' ~F- K ~J
JaU ~~nm ~aa ~vcn m w
r O M 7 N
r W M m ~
O O m M
M M M M O
O
V
N
m
(9
a
O
C O M if1 O (D c0 O O
O O t~ O W ~fJ I~ m O N 61
b ~
~ i to
O O a V ~ V V M
- fA ~ to tH O~ to
O Vj ~ fA EA
U I `n in
~ ~ u~ o o ~ o m o
~ v ~ o o ~ 0 0 0
N to N O ~ ~ O O O
~ N O 0p ~ O N O
N Vi !!~ ~ ~ vi fA ~
U (A V3 (A d3
N
fA
f/1
Q
N U U U ~ U U U U
U
S N
` N 0
N
C ~~
C
C U
N
` N
N
`. `
N
N
~ N 19 ~ (6 f0 ~ N N (9 N ~ ~ N
N N U) Ql > N >
(n W F- W UJ ~ > W (n W W ~ > W I- > W (n ~i
N
r-
w
O
O V N
- O
j M V
~l ~ ~ F-
~ a a
cn w w ¢ w ¢ ~_ ~
vii Z Q ¢ j Q > U U W U
~ J 2 D Q ~ Q ~ ~ W Q
-o F- ~ ~ z ~ W F-
~ I Q> M N (n (n J Q u)
~U ~_ ~ Q W V W `n M ~ X ~
Z O O V O W O Q~ N u7 (D 01
N of a0 ~ O N N O
~ ~ r r N ~ M ~ N ~ N ~
U
J
J
W
O d' V O O 7 M ~ (~O O M r
N ~ O ~ ~ N N ~ (D N U'J ~
u7 ~ In In lI~ ~ ll') l!') UJ ~ In l17 I!'J ~
Z ~ Z
~ M F d
~ ~z °a>z z ¢z pz az Zz `ncnz z z z
m zg ~¢~ cn~~ ~~~ O~ a~ ~~ Z~~ >w~ w ~ z W~
z¢ zz z x
~¢> F= Oz ww z~ ~ =a ~cn ~¢ ~ OQ
ax¢ =acn ~J >> Oz~ z ~p~ ~?z ~-' pw ~J
c ~a~~ ~ZO ~Fw UU~ v~Oa O> m~a =~w ~~~ _~ mew
rn ~UcO> jZQ Z~> UQ j HUU~ ZHO ~~ W xs=~ ~~> QQ ~ ~w~
0
rn N Z ul ~ (n ~ W ~ M~ Q~ K (n rn Z Y U ~ Q v Z Q ~ Ur (n rn W' w 0 W W U Q
W J O m x
O ~OvJ ~rZ S'~J ZCOJ S~O ZOO -'NO d'MO wOJ W N O OHO
Z~~ W ~N~ U~ W QN W U ~U -~07 ~ ~-U 0]~ J ~~ W ~ ~ 2' d'~U
o ~ f~ ~ m ro m ~ u0"~ ~ ~ m N
M `~ V c0 I~ O V (O 7 O M ~ N
co U~ ~ ~ ~ co co ~ w m o~ rn
m
m
~~
~.
y
0
0
C r-
O I~ in
M O O
u7 O m
I~ N
O W
~ M
N O
r O
O
~ ~ O O N~ Nv ~ (~D O O
(/1 fn (~ N EA fA EA
O to tH V1 lfl
UI
cn
C OOr
N ~'7 O~
OM ~O W
(O mN
N N W T f~ ~ m M (p
N ~ (p f~
.- En to M M
En (fl N V V
(A t~ to
N ~
N
to
N
Q
N U U U
~
° U U U U
°' U U
~ U
~ v
~ v
~ U
v 3
?
~
m ca ~ v
~ v
~ v
m u 3
~ ~ is v
~ ~ 3
~
~ ~ m m U
N v
v
~
u~w w v
wcn~f-~ w w W wcn~ w wcn~~ ~ w
~ ~
•-- ~
o w
~
~ N
d ~
p
u~ ~
N N
~
> ~
O
~ ~
W
w ~
p w
Q f-
a G ~
~ p
~
Q Y
~ G w ~ F" ~
~ f- ~ w G cn
w ~ a O
w F-
w ~ ~ z o ~ ~
~
~w z
O ~ ~ j ~
°' ~
p p m a
~
U w •- W ~ O O Q O
Z m O O O O r ~ N r W
~ O N N ~ O W O m
(n N .-- r ~ M .- r ~ ~ r
F
J
Q
>
w
a z
M V V ~ O N V O OJ O p v
V V M U' M
~ ~
W N N O
W ~ M ~~
~
O
cn ~n
u~ ~n
~n ~
Z
w ~ O
Q ~ ~
~ ~
O u~ ~
v~ ~
v> ~
-
m ~n
~
H
~ ~
~
~ Z
Q U Q
~
} ~~ Y ~ ~ Z
00
~ z o
Mz ~wz ~ z w z ~
~ z z ~Wz
~JO~ jg ~Wg 00Q~ a> Q~ QZ~ Oj~ ~ ¢~~
z ~ ~ a
Q~ 2 Y~ W Q w ~ Z a Y W Z O J
~
. w=
cdl- z~ m J wo
p ~vwi
Y z~w aJCn cOi~~ rn~
W N
' Q~
U
, J
mz~- mY
z ~a
Q~ QK
~ww wZ
w~ ~mQ
~ ~~U
QMZ W Q
w~-J w
z`-w W ~
°°~w
~~
O
j w~z T~w O~~ ~
from w
>
~
~ UN~ ZOQ O~ ~0
o a
ia
c
EwcOw KNQ U°U ~croY Um= cfl
YcNDa Q~ W ~Nd pmY z
z°p
(Q F- O~ W N J O Q N J w ~ Q V d S ~ F- d N F- W O J W M Z
(n ~ U
Z F ~ ll] 1 N~ Z ~ W U' N Q ~ ~ Q -~ V~ In ~ (n S d W ^ N Q
O` Y
}
1% ~ O OJ ~ O O N V (D O
M N M M I~ ~ r r O .- ~ N
(p ~ O
U N O
N O
N ~
N ~
N ~
N ~
N N
N N
N N
N
0
v
m
a
0
c ~ w o co
O V N O m
U ~ O V O
O O OD ff3 M
- O
O !A - (fl
U iA
O N O M O O M O
O N M N V ~ ~ N
N O (D I~ M m N O I~
M N Ef3 m r- N N Vi
U (fi (9 lf~ fA EA EA
U
N
N
U
Q
N U U U
U ~~~ L ~ L ~ y~ L L
N t4 N N N N U to In
a~- a3i a~ ~ m ~ m
cnwcn~~ wF`-~ wcn~F F
w
Q
~ ~ U Z
a~ U N
W =
~ Z
~ N N
U M (O V
z cD ~ u~
N ~
O ~
N
M
~ r ~ r
M O O
M
~ M
~ M
~
v> ~ u~
Z
Q
F
'~ Z Z
~ Z
~ ~ } Z
~
~ ~ ~ Z
Qow wU
~ ~F-
~
z<n
~z~ Q~ z
ao
O 2 ~
~ w
Q } N~ J O
rn
v N NU
w~Q ~c02'
,n ~~W
o
E z
Y w
w
0
N
M
tD
V
N
00
N
O
_ O r N
(O U N N N
O
W
0
Z
N
_~
~'
d
rn
M
v
i»
v o 0
M CO ~
~ V N
M m M
<A K1 M
W ~
~ ~
V N
O (O
V~
fA
U
- U U
- U
-
` ~ ~
N N ~ f0 N N
w wcn~ w w
O
a
F
U
J
O
U
N
N
m
N
M
N
N
M
m
r
(A
U
L ~
m ~
~ w
N
fib
N
m
v
N
M
_ Q
F- O M
p, N
~
Q ~-
~ Q
Q
o ~ w z
Y j ~ >
W w
a Q ¢ ~ a
o
a z
x ~ o =
i Z ~ Z U rn
i
O ~ ~ ~ Q ~
J ¢ ~
f~
m (D
a N
m ,r, w ,~
rn o u'> .- v o
O (D I~ ~ O
~ ~ M r OJ ~
M (p O O O O W N
M M M M O O
~ N ~ N ~ N ~ ~
Y ~ ~ ~ u~ u~ u~ ~n vi
U_ o
W N
W U #
~ ~ ~
~wZ JZ m Z Z ~ Z W. Z Z >Z
pcn~ }mom ~ ~ O ~ wow ~ Q~
vNi¢~ ~o¢ ox = iQ O~ ~t-z Hwy
xsQ~ OX~ ~0,_°> wX> Q~ j ~~~ Y~~ Q~O
Q~U JN OJ Z~Y QmY ¢QQ]~Y OCOY JN~ ~~Z
UN~ Y~~ ~~ W ~d W Q~ W d~W YNN C~~~
V (D OJ ~ ~ M ~ r
Obi O O N V ~ ~ c0
N M M M M M M M
N N N N N N N N
0
m
o
ti
~ M
C N O OJ N V O ~ V 01
O O O N V (D O N O
U V O N O 7 f~ O N ~ O
N O N m efi ~ 6> N M O 1~
N to t0 r ~ ~ M
p to to EH to (A ~ M
UI
N ~f'i N O I~ W (O 00 ro1~0
~ ~ V O ~fJ m ~ ~ O 61 N N
moio ai ~ ~ mm ri~v
~
E u, o N V N t/i to o~ u7 N
~, ~ ~_ ua v> va e» e» ~ ~
N
N M
N
N
N U U U U U U _T U _
~~ L
U
~ ~
L
L L
` L ~ ~-
`
N N ~
J
~ L
~ N
tO ~ N e w N N y N N N~ ~ O ~~ N
N
N N N m N ~ _ _ ~ ~
mm~~ m w~ ~ w~~ wr w~ W w cn m w cn
i--
VN
i
N ~ N
O
O O
~ N
a
a ~ ~
¢ ~ Q U
~ m W m ~ j ~ z O
v
i w > z m
U
H
~'~
O
d'
O
~ J
O
~
V
z
z
W
J
~
O
Z
Z
~
Z
=
_
¢ } ~
°i j ~ Q
} S U ~ ~ U i
a
U r
N ~ U
t~ W
r OJ
V f~
M U
~ N
~ N
O
N m ON ~ ~ O O ~ ~
~
~ ~ M O
O O V W O ~ r O M M ~
M M M m N O ~- N M ~ O f~
M M V M M M O V M M M M
~n ~ O N O ~ .- ~ N M ~ to
In In 1n N In ~ ~ In In lfl u7 lP
a ~
m ¢ No w
z~ o N Y
z ~
~ M Z Z Z Z Z p j Z Z Y Z Q Z Z Y Z m~ z
m ~ ~ z ~ ~ ~ ~ ~ U ¢ ~ Z z ~ ¢ ~ w ~ ~ ? ~ ~ } Z ~
Dzv~i w ~m ¢~- w~ ~J >> WZ ~W
¢= 0 z Q d W' W~ ~ O a' Z U } Z ~- N J (n O Z ~¢
~ ~Q~~ Zo m~ ~¢Q mv~ ~~ ~U ~~ J= z= wiz
-.~(7¢w ~Z W W } W S~ F¢-~¢ =wW ¢OJ ~~ W Zo ~~ W USVO
~ EdO~ H_c_flY ~oMZ Zvi ~~Q wdJ ~oj ~~~ ~u~Q =o ~ mr~i z_
v
° ~z„nS WMJ woa W~~ OvJ K°o~ w°v~ z~Y ~`N°J ONO ~°M~
zcnMCn 1~ w ~~m ~~ni ~~U mom ~tDU ~.-w mu~~ ~ro z ¢~a
0
N O I~ N M r O O V O N M
o~ of ~ O r O V V cD N
_M N co m ~ rn m o M ~n u~ c0
~ M M M M M V V V a V V
(D U N N N N N N N N N N N
_..
0
v
m
w
o
~ m
Z
/ N
C i0 ~ M ~ M N m O O ~
O~ M (D c0 O m o7 (O Q> N
U M W O O (O N (O ~- '7 M M
U M N ap 01 O V O N M V N
= N fA M N (H M M M
O to ffl V3 (A M ~ M
U
N ~ ~ N ~~ r O
~ M N N ~fJ ~ N O
CO M M O m O r
M Eli eA M C O~
~ (fl (i1 to ER O
U
OJ ~
~
N
Q
N U U U U U U U V U U
Zu ~ v v v u~ v ~3v
m v u3~'~
~
~~
c
w a~
w a~
w m
w ~ a~~ m
w a~~
~ ~ ~~
m
~~
n w wf- wu~ w wcn
w
w
O
~
~ o
O
> M F d
° a Q o o ~
Q w a ~ W M ~
> ~
a Q
N Q N Q Q Q W' O Q
-o (n (/~ ~ f- 1- ~- F- W Z O
-O
Q Z Z ~
O (~ (~ ~
O (~ J
}
~
~
Q = 0 Q ~
N Q
U ~
Z W u7 ~ ~ (O ~ u7 ~ ~
N O 1~ M O f~ O ~ W
(n O M ~ ~ ~ ~ M ~ ~ (D
<t
M O
M O O O W
M O m V O
M M M M V M M
lf] Lf~ ~ l!J In L(I ~ ~ 47 ~
o O
O
Z
N Z
~
~ Z
r F.
Q Z
~
2~ Z
~
Z
~ ~
Z
~ W
~ N Z
O ~ ~
F' Z
~ ~
Q Z
~
~ Z
N G
O Z Z ~ D Z
-0 2 Zj ~ OZ ~ mF- W W Q~
Q C70 U Ocai _
wQ wa' wv~i wQ ~ ~ ~~
~ ~uwi m~~ ~~~ Z~~ ¢~~ Z=¢ a~~ aw W~
Z ~~ w
O '~
~ W O~
~'~~ } N W
JX 1 Q m W
~" ~ w~ W
-> > U~ W
Zm~ w~~
_~~ O w
HOB m
}Q W ~ (n
Q4' W' W
ljJ ~
m a Q Y
~
o E
(Q v~~
M O J
Y
W O J U~Y
J ~ J F--~Y
QQ M J ln
Y
~^ J m~
K~ ~oY
_~ J QmQ
W S J co
K O O UmY
Q ~ J
Z Z.-~ and W Q ~ W Y~ W -~~n W 0]N N U M W ~ ~~] W N~ ~ to W
a ~ V o V ~ ~ ~ ~ m M a
~ V V V V O V ~ ~ u7 ~
(O U N N N N N N N N N N