5.2. ERMUSR 05-10-2016 Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
Elk River Municipal Utilities Commission Theresa Slominski—Finance and Office
John Dietz, Chair Manager
Allan Nadeau, Vice-Chair
Daryl Thompson, Trustee
MEETING DATE: AGENDA ITEM NUMBER:
May 10, 2016 5.1
SUBJECT:
2016 First Quarter Delinquent Items
BACKGROUND:
First 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 both the collection agency and revenue recapture(B), and those submitted to revenue
recapture (R).
I also have for review the color-coded recap comparisons with last year, identifying the
categories and the running totals. There are no amounts listed for assessments as the process for
assessments culminates in the last quarter from information previously submitted to other
collection services and if not collected, removed and assessed. Currently, all services—so even
those assessable services of sewer, water, and trash—are submitted with the amounts at RR in
POWERED IV
3 Page 1 of 2 NATURE
Reliable Public
Power Provider POWERED To SERVE
123
the hopes that they will be collected. Items not collected by assessment time are removed from
RR and assessed instead.
Amounts submitted for the quarter to Collection Agencies (A) total $1,560.08. (When
comparing to the first quarter of 2015, we were not able to extract a report from our software
conversion in February and so only RR was utilized in that first quarter and there are no
collection agency dollars presented.) Amounts submitted to RR and the Collection Agency are
not included here, they are included in the RR amounts.
Amounts submitted for the quarter to Revenue Recapture (R) are $6,646.36, including $2,089.58
also submitted to the collection agency. (As mentioned above, for those funds submitted to both
resources, as we collect from either resource we remove the dollars at the second resource.)Note
that assessable items are also included here as mentioned above. We have collected $21,830.32
from RR in 2016, over 100% of those dollars submitted since we are also collecting for prior
year submissions. (Of note, included in the $21,830.32 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 first quarter totals for(A), (B), and(R) are $8,206.44. To break these totals down by
provider, it is $6,560.35 for Electric, $257.75 for Water, $518.05 for Sewer, $260.12 for Trash,
$506.97 for Franchise Fees, and $103.20 for Storm Water.
The amount for fourth quarter Write-Offs is ($927.42), a credit due to collections on amounts
previously written off, which is very typical in the first quarter.
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.002% (and .019% including RR).
ACTION REQUESTED:
Staff recommends that the Elk River Municipal Utilities Commission accept this delinquent
amounts listing for the first quarter of 2016.
ATTACHMENTS:
• Delinquent items submitted to Collection Agencies and Revenue Recapture
• Color-coded recap Delinquent Items Comparisons
P-
OWERED BY
Rif
�j Page 2 of 2AURE
Reliable Public
Power Provider P OWERED To S ER VE
124
Delinquent Items Listing- First Quarter 2016
Agency Account Sery Addr Provider Total AR
A 31637 11266 192ND AVE 1ERUE 203.46
A 3750 16420 DAYTON AVE 1ERUE 98.86
A 17300 11798 HIGHLAND RD APT 3 1ERUE 128.85
A 27443 17195 POLK CT 1ERUE 286.75
A 29054 17138 MONROE ST 1ERUE 30.38
A 29380 10429 172ND LN 1ERUE 4.91
A 30682 10617 172ND LN 1ERUE 36.41
A 33656 17147 MONROE CT 1ERUE 28.42
A 33660 10908 171ST AVE UNIT A 1ERUE 502.14
A 31637 11266 192ND AVE 2ERUW 40.44
A 32583 10173 176TH AVE 2ERUW 6.18
A 31637 11266 192ND AVE 3CTYS 24.26
A 32583 10173 176TH AVE 3CTYS 16.18
A 31637 11266 192ND AVE 4CTYT 0.98
A 27443 17195 POLK CT 4CTYT 66.43
A 29054 17138 MONROE ST 4CTYT 1.94
A 29380 10429 172ND LN 4CTYT 11.14
A 31637 11266 192ND AVE 6CTYF 5.87
A 17300 11798 HIGHLAND RD APT 3 6CTYF 5.87
A 27443 17195 POLK CT 6CTYF 9.08
A 33660 10908 171ST AVE UNIT A 6CTYF 17.63
A 31637 11266 192ND AVE 7CTYS 6.30
A 27443 17195 POLK CT 7CTYS 10.40
A 29054 17138 MONROE ST 7CTYS 4.00
A 29380 10429 172ND LN 7CTYS 6.20
A 30682 10617 172ND LN 7CTYS 4.00
A 32583 10173 176TH AVE 7CTYS 3.00
Collection Agency Total 1,560.08
B 12766 18402 SMITH ST 1ERUE 28.85
B 17260 538 TIPTON AVE 1ERUE 43.73
B 20323 340 3RD ST APT 105 1ERUE 281.80
B 27685 9911 PARRISH AVE NE 1ERUE 319.33
B 30457 379 BALDWIN AVE APT 104 1ERUE 135.00
B 30473 1860 MEADOWVALE RD APT 4 1ERUE 157.60
B 30712 1179 SCHOOL ST APT 1 1ERUE 149.96
B 31608 633 MAIN ST APT 320 1ERUE 87.73
B 32578 12950 MEADOWVALE RD 1ERUE 209.85
B 467 11847 190TH AVE 1ERUE 229.94
B 12766 18402 SMITH ST 2ERUW 22.77
B 32578 12950 MEADOWVALE RD 2ERUW 40.61
B 467 11847 190TH AVE 2ERUW 44.74
B 12766 18402 SMITH ST 3CTYS 52.92
125
B 27749 18679 QUEEN CIR 3CTYS 37.80
B 32578 12950 MEADOWVALE RD 3CTYS 24.26
B 467 11847 190TH AVE 3CTYS 28.37
B 12766 18402 SMITH ST 4CTYT 13.08
B 32578 12950 MEADOWVALE RD 4CTYT 0.98
B 467 11847 190TH AVE 4CTYT 23.27
B 12766 18402 SMITH ST 6CTYF 5.87
B 17260 538 TIPTON AVE 6CTYF 11.40
B 20323 340 3RD ST APT 105 6CTYF 11.74
B 30457 379 BALDWIN AVE APT 104 6CTYF 28.29
B 30473 1860 MEADOWVALE RD APT 4 6CTYF 16.74
B 30712 1179 SCHOOL ST APT 1 6CTYF 17.62
B 31608 633 MAIN ST APT 320 6CTYF 17.61
B 32578 12950 MEADOWVALE RD 6CTYF 5.87
B 467 11847 190TH AVE 6CTYF 16.65
B 12766 18402 SMITH ST 7CTYS 6.30
B 27749 18679 QUEEN CIR 7CTYS 3.00
B 32578 12950 MEADOWVALE RD 7CTYS 6.30
B 467 11847 190TH AVE 7CTYS 9.60
Both Collection Agency and Reveue Recapture Total 2,089.58
R 30462 340 3RD ST APT 104 1ERUE 27.99
R 30491 814 PROCTOR AVE APT 1A 1ERUE 121.15
R 29001 13488 182ND AVE 1ERUE 149.85
R 31041 1115 SCHOOL ST APT 26 1ERUE 115.32
R 21968 20943 FRESNO ST 1ERUE 168.07
R 28219 1001 SCHOOL ST APT 202 1ERUE 63.06
R 29788 300 JACKSON AVE APT 221 1ERUE 36.36
R 30353 223 2ND ST 1ERUE 452.49
R 30615 847 FREEPORT AVE APT 207 1ERUE 300.99
R 30666 21101 OLSON CIR 1ERUE 296.31
R 30739 380 3RD ST APT 301 1ERUE 48.07
R 31513 375 EVANS AVE APT 203 1ERUE 27.71
R 31594 1001 SCHOOL ST APT 105 1ERUE 393.90
R 32986 10180 PARRISH AVE NE TRAILER H 1ERUE 84.01
R 33387 380 3RD ST APT 202 1ERUE 704.68
R 18550 385 HOLT AVE APT 207 1ERUE 60.89
R 23770 12968 196TH LN 1ERUE 230.95
R 33175 633 MAIN ST APT 312 1ERUE 314.58
R 29001 13488 182ND AVE 2ERUW 50.30
R 23770 12968 196TH LN 2ERUW 52.71
R 24787 18594 TYLER ST 3CTYS 39.84
R 29001 13488 182ND AVE 3CTYS 90.30
I R 23770 12968 196TH LN 3CTYS 204.12
R 29001 13488 182ND AVE 4CTYT 48.32
R 21968 20943 FRESNO ST 4CTYT 22.15
126
R 30666 21101 OLSON CIR 4CTYT 0.68
R 23770 12968 196TH LN 4CTYT 71.15
R 30462 340 3RD ST APT 104 6CTYF 7.35
R 24787 18594 TYLER ST 6CTYF 11.76
R 30491 814 PROCTOR AVE APT 1A 6CTYF 28.64
R 29001 13488 182ND AVE 6CTYF 23.67
R 31041 1115 SCHOOL ST APT 26 6CTYF 16.90
R 21968 20943 FRESNO ST 6CTYF 5.87
R 28219 1001 SCHOOL ST APT 202 6CTYF 17.61
R 29788 300 JACKSON AVE APT 221 6CTYF 17.61
R 30353 223 2ND ST 6CTYF 29.71
R 30615 847 FREEPORT AVE APT 207 6CTYF 34.88
R 30666 21101 OLSON CIR 6CTYF 5.87
R 30739 380 3RD ST APT 301 6CTYF 17.08
R 31513 375 EVANS AVE APT 203 6CTYF 6.41
R 31594 1001 SCHOOL ST APT 105 6CTYF 26.51
R 33387 380 3RD ST APT 202 6CTYF 23.69
R 18550 385 HOLT AVE APT 207 6CTYF 16.55
R 23770 12968 196TH LN 6CTYF 23.48
R 33175 633 MAIN ST APT 312 6CTYF 23.14
R 24787 18594 TYLER ST 7CTYS 6.60
R 29001 13488 182ND AVE 7CTYS 12.90
R 21968 20943 FRESNO ST 7CTYS 4.20
R 30666 21101 OLSON CIR 7CTYS 4.20
R 23770 12968 196TH LN 7CTYS 16.20
Revenue Recapture Total 4,556.78
8,206.44 Total I
A Collection Agency 1,560.08
B Both Collection Agency and Reveue Recapture 2,089.58
R Revenue Recapture 4,556.78
8,206.44 Total
127
in
J
Q
I-
0
I-
0 0
Z
Q
L9
0o LO In In h In In N
h V Cr co In m a, N
h O ✓ a,O O Ii N co
In H N co co , m a .-I 00 N
- v o .-1 In m In La .-1
o Oh O N N r.i. -I 00 Ni
N r .H .ti N IO O In N N
ti
La N N 0, L
0 O o m LO
o •
N a a, Ln N
h h V m
m N N Ln LO
o h h In
r
0 0 m m N V In m
00 0o a Ni .( m In v
.-i - m - N o .-i N
N N mN In C N .1
r V V 00 m CO In h m
Lc, O ' •-i N M' 01
o v
N a, C
0= N
Ir Q E
N N N N N J J Q
o V r{ V• V V ,c0
•
N N N h N N cc
N N N N N C
_ Ol a, O, Ol a1 00
C
Ol
U
X
rj O1
O
H
v`� 0 co La uo co 411 m CO Ln
01 a, N N 00n M Ia1 N
Cr Cr m CO LO In In .( r
a m m In N o In O, In
CO
V, aJ .-1 .-1 N O. m N tll
O
N ,
n
C
N
N
C
La La La LD ID z
0 • • •
v m m m m m
N
LO LD La LD Ln
U LO LO La ID Ln
v
K
0!
n
C
0l
>
v
cc
CO CO In CO In m
>. 'Cr Cr to a, h h
C N N 6 ,, .I m
41 M OO N Ln CO O
OD Ln Q N N N h
.ti C
oO
N ,
_N
O
U
QD
1 O >, O O o• O• O
0 0 O O O
C Lc, ID LO Ln LO
lU In In In
m
Q f-1 .-i ,-i' .-1 .--I
C
O
c
o v
co O
a u
E
O
U io — m a
E H H 48 H 1—
a, O o O O
C CO
CO D
D O -0 L
cr
C O t