5.3 ERMUSR 11-14-2017 Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
ERMU Commission Theresa Slominski -Finance & Office Manager
MEETING DATE: AGENDA ITEM NUMBER:
November 14, 2017 5.3
SUBJECT:
2017 Third Quarter Delinquent Items
ACTION REQUESTED:
Approve the 2017 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 listing 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 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
the hopes that they will be collected. Items not collected by assessment time are removed from
RR and assessed instead.
The third quarter totals are $8,319.80. To break these totals down by provider, it is $7,448.50 for
Electric, $56.13 for Water, $111.28 for Sewer, $50.35 for Trash, $633.59 for Franchise Fees, and
$19.95 for Storm Water.
Page 1 of 2
77
Amounts submitted for the quarter to Revenue Recapture and the Collection Agency(B) are
$8,319.80.Note that assessable items are also included here as mentioned above.
The amount for third quarter Write-Offs is ($34.28). This quarter is a credit amount due to
receiving collections on amounts previously written off of($193.30), and small balances of
$38.02 and deceased parties of$121.00 being written off.
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 (2015),the
industry standard is between.17%and .37%. Interestingly,the Northern/Central Plains average
is .09%. Our totals for the year so far are below the national average, at.00021%.
ATTACHMENTS:
• 2017 Third Quarter Delinquent Items Comparisons
• 2017 Third Quarter Delinquent Items Submitted
Page 2 of 2
78
J
Q
0
O
Q
z
Q
K
N
I
Iniiiii Q Gl
N ro N W en Ii ;
o m ' Ln o
N N LD Ln LD .
y N O 00 m Q
N N N N O N
tLri m oo 'i d
E
0
N 0
0
4p E
0 0 O iNY try
,=
_ _ E +, 6 !
O v
N ._ .cN
EC
CU
vi Hgi N
m m m
o
~ WN a
OO Orn O pq
OY c E
OO OON oO OO 0O OO OO!.d�.g
0
'al
00000000
7q OqO 0 pVN .NO
o N O) l0 N ^'1 Ln to T
m m m m N O VJ
0 to tO L/1 N to rn
O to to m C W m
v `-‘5l0 W` ti O N
~O W
N 4J
c>,-
c y
v m
Q
� c 4
S' O
oti v 4 4 mn o m to uo c •y
NO c, to N N 0, D U Kv
a m m .-4 Ln ,.-1N ■ in
c, N N a m m 0
U Ln Lll )x .t W N V1
N c
C
N f0 L
v £ a
O
o� co N Ln a m o U
NLn 8
8E =NM a
52 4 m0-0' �o i N y M
Q r-1 .-1 N rrl th N ri —
o, oti Y
O O C
N EN
3 d
_, a 0
O C N
U
6J _
N . 0 O 0
O
Ln n Ln a
N G O O
m Om
FYI)
01 N N N
m
Q
C
vl O
- O O O O O O
O U O O O O O O O ' p
N O O O O O O O p
a o 0000000 0
.N-I O co' ,r V N N
O _�
U m CO m !,0,..too HHHa D O O
m
v =
c d -O _c
o v t
To e2 O LL to F- L2
Agency Account Sery Addr Provider Total AR
B 14040 10711 184TH AVE 1ERUE $ 337.16
B 17164 18160 ROOSEVELT ST 1ERUE $ 296.29
B 24028 12671 MEADOWVALE RD STE P 1ERUE $ 672.77
B 27331 18058 VANCE CIR 1ERUE $ 141.84
B 28731 753 FREEPORT AVE 1ERUE $ 131.84
B 29459 350 EVANS AVE APT 514 1ERUE $ 49.40
B 30553 1001 SCHOOL ST APT 116 1ERUE $ 86.87
B 31026 18600 GARY ST APT 31 1ERUE $ 39.68
B 31386 300 3RD ST APT 102 1ERUE $ 24.67
B 31786 633 MAIN ST APT 310 1ERUE $ 354.97
B 31868 18083 VANCE CIR 1ERUE $ 37.94
B 32032 1227 SCHOOL ST APT 108 1ERUE $ 236.36
B 32504 13400 ISLANDVIEW DR 1ERUE $ 178.18
B 32654 345 EVANS AVE APT 208 1ERUE $ 60.39
B 33106 17177 NIXON CIR 1ERUE $ 296.22
B 33432 11537 197TH AVE 1ERUE $ 825.55
B 33855 10653 172ND AVE 205 1ERUE $ 103.87
B 34135 1001 SCHOOL ST APT 212 1ERUE $ 277.42
B 34277 1105 LIONS PARK DR APT 112 1ERUE $ 104.95
B 34746 1860 MEADOWVALE RD APT 8 1ERUE $ 1,515.54
B 34905 1109 SCHOOL ST APT 14 1ERUE $ 122.59
B 35067 577 TIPTON AVE 1ERUE $ 313.18
B 35247 631 AUBURN PL APT 104 1ERUE $ 249.07
B 35255 1115 SCHOOL ST APT 12 1ERUE $ 134.61
B 35824 759 FREEPORT AVE 1ERUE $ 225.58
B 35994 1127 5TH ST 1ERUE $ 140.82
B 36125 18415 XERXES ST 1ERUE $ 87.49
B 36159 8304 PARKVIEW AVE NE 1ERUE $ 40.49
B 36167 11755 191 1/2 AVE APT 104 1ERUE $ 362.76 $ 7,448.50
B 14040 10711 184TH AVE 2ERUW $ 47.59
B 17164 18160 ROOSEVELT ST 2ERUW $ 8.54 $ 56.13
B 14040 10711 184TH AVE 3CTYS $ 88.98
B 17164 18160 ROOSEVELT ST 3CTYS $ 22.30 $ 111.28
B 14040 10711 184TH AVE 4CTYT $ 24.84
B 32504 13400 ISLANDVIEW DR 4CTYT $ 25.51 $ 50.35
B 14040 10711 184TH AVE 6CTYF $ 17.27
B 17164 18160 ROOSEVELT ST 6CTYF $ 6.95
B 24028 12671 MEADOWVALE RD STE P 6CTYF $ 114.00
B 27331 18058 VANCE CIR 6CTYF $ 29.01
B 28731 753 FREEPORT AVE 6CTYF $ 23.14
B 29459 350 EVANS AVE APT 514 6CTYF $ 11.21
B 30553 1001 SCHOOL ST APT 116 6CTYF $ 17.27
80
B 31026 18600 GARY ST APT 31 6CTYF $ 11.03
B 31386 300 3RD ST APT 102 6CTYF $ 5.70
B 31786 633 MAIN ST APT 310 6CTYF $ 16.90
B 31868 18083 VANCE CIR 6CTYF $ 17.08
B 32032 1227 SCHOOL ST APT 108 6CTYF $ 23.31
B 32504 13400 ISLANDVIEW DR 6CTYF $ 17.44
B 32654 345 EVANS AVE APT 208 6CTYF $ 5.16
B 33106 17177 NIXON CIR 6CTYF $ 22.24
B 33432 11537 197TH AVE 6CTYF $ 24.74
B 33855 10653 172ND AVE 205 6CTYF $ 18.69
B 34135 1001 SCHOOL ST APT 212 6CTYF $ 11.21
B 34277 1105 LIONS PARK DR APT 112 6CTYF $ 17.44
B 34746 1860 MEADOWVALE RD APT 8 6CTYF $ 50.44
B 34905 1109 SCHOOL ST APT 14 6CTYF $ 24.02
B 35067 577 TIPTON AVE 6CTYF $ 24.77
B 35247 631 AUBURN PL APT 104 6CTYF $ 14.24
B 35255 1115 SCHOOL ST APT 12 6CTYF $ 32.37
B 35824 759 FREEPORT AVE 6CTYF $ 23.67
B 35994 1127 5TH ST 6CTYF $ 11.21
B 36125 18415 XERXES ST 6CTYF $ 13.90
B 36167 11755 191 1/2 AVE APT 104 6CTYF $ 29.18 $ 633.59
B 14040 10711 184TH AVE 7CTYS $ 10.55
B 17164 18160 ROOSEVELT ST 7CTYS $ 3.00
B 32504 13400 ISLANDVIEW DR 7CTYS $ 6.40 $ 19.95
Total $ 8,319.80 $ 8,319.80
81