5.3. ERMUSR 11-15-2016 4,. h
Elk Riv
.Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
Elk River Municipal Utilities Commission Theresa Slominski—Finance and Office Manager
John Dietz, Chair
Allan Nadeau, Vice-Chair
Daryl Thompson, Trustee
MEETING DATE: AGENDA ITEM NUMBER:
November 15, 2016 5.3
SUBJECT:
2016 Third Quarter Delinquent Items
BACKGROUND:
Third quarter delinquent items are presented for your review. We have previously reported on
four different categories of delinquents as follows:
• Assessments are delays in collecting the money owed and is assessed to the property
taxes in the fall. Please note this number will only be presented in the 4th quarter.
• Collections amounts are those we send to the collection agency to try and collect after
we have exhausted all our internal collection efforts. We receive 70% of amounts
collected after the agency receives their split.
• Revenue Recapture (RR) is the program through the state where funds are collected
from individuals' tax refunds and remitted to us, with the balance (if any) remitted to
the individual. It presents an opportunity to collect funds rather than splitting with a
collection agency or having to write them off completely.
• Write Offs are amounts removed from the books with no further collection efforts
being extended.
DISCUSSION:
The attached report shows those dollars submitted to the collection agency (A), those submitted
to revenue recapture (R), and those submitted to both the collection agency and revenue
recapture (B).
I also have for review the color-coded recap comparisons with last year, identifying the
categories and the running totals, and graphs. Since we are assessing items at this time, there are
only the services of Electric and Franchise fees included in this third quarter listing. All other
services are assessable and are being submitted accordingly. Items presented in previous
quarters that are assessable and have not been collected are removed from RR and the collections
agencies and assessed instead.
yr POWERED 8r
/\ Page 1 of 2 NATURE
PowerReliabl8 POWERED To SERVE
112
Amounts submitted for the quarter just to Collection Agencies (A)total $3,819.34. The amount
submitted to Revenue Recapture and also submitted to the Collection Agencies (B) total
$10,896.75. (When looking at the first quarter of 2015, we were not able to extract a report from
our software conversion in February and there are no collection agency dollars presented.)
We have collected $32,356.81 from RR in 2016. This is over 100% of those dollars submitted
but we are also collecting for prior year submissions. (Of note, included in the $32,356.81
collected is $10,500 for a commercial account in Otsego that we wrote off in 2015 for
$42,219.73. This is probably the only amount we will ever collect on this account.)
The third quarter totals for(A) and (B) are $14,716.09. To break these totals down by provider,
it is $13,669.51 for Electric, $1,035.24 for Franchise Fees, and $11.34 for Storm Water.
The amount for third quarter Write-Offs is $659.16.
Our budgeted amount for collections and write-offs are $105,000, or .27% uncollectible accounts
per revenue dollar. According to APPA's most recent published standard ratios (2013), the
industry standard is between.18% and .37%. Our totals, excluding RR, for the year are below
the national average, at.067% (and .086% including RR).
ACTION REQUESTED:
Staff recommends that the Elk River Municipal Utilities Commission accept this delinquent
amounts listing for the third quarter of 2016.
ATTACHMENTS:
• Delinquent items submitted to Collection Agencies and Revenue Recapture
• Color-coded recap Delinquent Items Comparisons
POMEHE0 i
Page 2 of 2 NATURE
Reliable Public
Power Provider P o WERE o To S ERVE
113
Elk River Municipal Utilities
Q2 Accounts placed at Rev Recap, Collection Agency, or Both
By Agency
Agency Account Sery Addr !i_Irr ;I el _fr,1i t it AR
A 3312 18489 TWIN LAKES RD 1ERUE $ 3,164.64
A 3312 18489 TWIN LAKES RD 6CTYF $ 152.06
A 30139 204 LOWELL AVE 1ERUE $ 169.87
A 30139 204 LOWELL AVE 6CTYF $ 15.85
A 32467 220 1/2 XENIA AVE UP 1ERUE $ 294.52
A 32467 220 1/2 XENIA AVE UP 6CTYF $ 22.40
AGENCY $ 3,819.34
B 16712 19445 DODGE ST 1ERUE $ 374.47
B 16712 19445 DODGE ST 6CTYF $ 14.78
B 18813 313 JACKSON AVE APT 2 1ERUE $ 159.05
B 18813 313 JACKSON AVE APT 2 6CTYF $ 28.82
B 18813 313 JACKSON AVE APT 2 7CTYS $ 11.34
B 22086 1001 SCHOOL ST APT 303 1ERUE $ 420.64
B 22086 1001 SCHOOL ST APT 303 6CTYF $ 17.97
B 25129 300 EVANS AVE APT 403 1ERUE $ 45.89
B 25129 300 EVANS AVE APT 403 6CTYF $ 11.93
B 26442 11574 211TH AVE 1ERUE $ 278.29
B 26442 11574 211TH AVE 6CTYF $ 17.27
B 26500 1227 SCHOOL ST APT 211 1ERUE $ 115.13
B 26500 1227 SCHOOL ST APT 211 6CTYF $ 11.57
B 27570 19390 HOLT ST 1ERUE $ 165.37
B 27570 19390 HOLT ST 6CTYF $ 16.53
B 28085 1227 SCHOOL ST APT 105 1ERUE $ 175.33
B 28085 1227 SCHOOL ST APT 105 6CTYF $ 34.88
B 28969 631 AUBURN PL APT 301 1ERUE $ 76.53
B 28969 631 AUBURN PL APT 301 6CTYF $ 18.15
B 30190 12285 RUSH CIR 1ERUE $ 650.42
B 30190 12285 RUSH CIR 6CTYF $ 16.37
B 30202 1001 SCHOOL ST APT 205 1ERUE $ 76.74
B 30202 1001 SCHOOL ST APT 205 6CTYF $ 16.73
B 30525 17159 NIXON CIR 1ERUE $ 293.47
B 30525 17159 NIXON CIR 6CTYF $ 11.76
B 30706 1001 SCHOOL ST APT 100 1ERUE $ 143.15
B 30706 1001 SCHOOL ST APT 100 6CTYF $ 16.90
B 30731 631 AUBURN PL APT 104 1ERUE $ 145.99
B 30731 631 AUBURN PL APT 104 6CTYF $ 22.77
B 31070 380 3RD ST APT 103 1ERUE $ 167.23
B 31070 380 3RD ST APT 103 6CTYF $ 29.36
B 31219 87 6 1/2 ST 1ERUE $ 107.91
B 31219 87 6 1/2 ST 6CTYF $ 23.14
B 31377 631 AUBURN PL APT 102 1ERUE $ 259.95
B 31377 631 AUBURN PL APT 102 6CTYF $ 29.36
114
B 31474 13154 192 1/2 LN 1ERUE $ 230.85
B 31474 13154 192 1/2 LN 6CTYF $ 23.48
B 31604 227 MORTON AVE 1ERUE $ 108.21
B 31604 227 MORTON AVE 6CTYF $ 14.24
B 31791 18450 ROBINSON ST 1ERUE $ 168.26
B 31881 11981 191 1/2 AVE APT 201 1ERUE $ 166.23
B 31881 11981 191 1/2 AVE APT 201 6CTYF $ 11.40
B 32019 12671 MEADOWVALE RD STE D 1ERUE $ 82.42
B 32056 12671 MEADOWVALE RD STE E 1ERUE $ 1,083.17
B 32056 12671 MEADOWVALE RD STE E 6CTYF $ 146.95
B 32344 10079 179TH LN 1ERUE $ 414.38
B 32344 10079 179TH LN 6CTYF $ 11.74
B 32496 1227 SCHOOL ST APT 101 1ERUE $ 144.26
B 32496 1227 SCHOOL ST APT 101 6CTYF $ 26.81
B 32562 814 PROCTOR AVE APT 1B 1ERUE $ 97.03
B 32562 814 PROCTOR AVE APT 1B 6CTYF $ 29.54
B 32585 18776 CLEVELAND ST 1ERUE $ 794.44
B 32585 18776 CLEVELAND ST 6CTYF $ 35.56
B 32610 18569 ULYSSES ST 1ERUE $ 517.10
B 32610 18569 ULYSSES ST 6CTYF $ 22.78
B 32647 1414 5TH ST 1ERUE $ 108.46
B 32647 1414 5TH ST 6CTYF $ 7.83
B 32796 14514 CO RD 30 HOUSE 1ERUE $ 352.87
B 33160 18594 GARY ST APT 11 1ERUE $ 124.97
B 33160 18594 GARY ST APT 11 6CTYF $ 23.66
B 33298 1105 LIONS PARK DR APT 325 1ERUE $ 38.93
B 33298 1105 LIONS PARK DR APT 325 6CTYF $ 5.16
B 33303 18594 GARY ST APT 16 1ERUE $ 16.38
B 33303 18594 GARY ST APT 16 6CTYF $ 11.74
B 33360 561 AUBURN PL 1ERUE $ 50.53
B 33360 561 AUBURN PL 6CTYF $ 18.33
B 33869 10653 172ND AVE 214 1ERUE $ 141.27
B 33869 10653 172ND AVE 214 6CTYF $ 11.03
B 34001 10835 181ST LN 1ERUE $ 381.63
B 34001 10835 181ST LN 6CTYF $ 28.82
B 34085 10472 172ND LANE 1ERUE $ 503.66
B 34085 10472 172ND LANE 6CTYF $ 23.48
B 34478 11755 191 1/2 AVE APT 106 1ERUE $ 303.05
B 34478 11755 191 1/2 AVE APT 106 6CTYF $ 23.83
B 34491 18520 ROBINSON ST#7 1ERUE $ 65.28
B 34521 701 AUBURN PL 1ERUE $ 92.70
B 34521 701 AUBURN PL 6CTYF $ 13.70
B 34610 10180 PARRISH AVE NE TRAILER H 1ERUE $ 364.41
B 34848 631 AUBURN PL APT 102 1ERUE $ 34.43
B 34848 631 AUBURN PL APT 102 6CTYF $ 16.56
BOTH $ 10,896.75
r$ 14,716.09 TOTAL I
115
V)
0
0
0
z
cc
j:p v
00 c a
h v
m ¢ '
ro
no u
m a m c w
O fill
O N 4-
v z
■ 1
'ti O O O^ V
�N O W C
TO N fr1 1.11
N 112 11111:ICIIIII:III2®I
~ _ -Di'
_ ra
° I
0 o r
ut y '' d
g. �
r,-,- r m N d1 m
°, c
oN w v d CU
C
t a w c g
Q I L
Q dN'
1FIi :CC -,
I-
00 o cc
Clo v
r
N.
Ns: !; : :
IcEI ri g j
N = to t0 la aM1
a LO LO 09 M
ra
u iD o Lo crl C _ [
ti NCcc
NN
i i d
c (O 1cu
> C. V
v
= 0 I
� I c c Nv 0 i
O ; u
i
iitiii
I ig ,g PO 1 , 1 ,
o v v m ry ,
E —
O
U m m m m
H I� 15H
al
+• Y 0 0 0 0
COC > I- } }
N 0
= 0 -Ci Y
Q
C 0 a
N i Vo o=
0 LL ,0 H