5.2 ERMUSR 08-08-2017 Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
ERMU Commission Theresa Slominski -Finance & Office Manager
MEETING DATE: AGENDA ITEM NUMBER:
August 8, 2017 5.2
SUBJECT:
2017 Second Quarter Delinquent Items
ACTION REQUESTED:
Approve the 2017 Second Quarter Delinquent Amounts Listing.
BACKGROUND:
Second 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 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
the hopes that they will be collected. Items not collected by assessment time are removed from
RR and assessed instead.
The second quarter totals are $9,348.08. To break these totals down by provider, it is $7,924.23
for Electric, $226.88 for Water, $232.28 for Sewer, $204.01 for Trash, $691.90 for Franchise
Fees, and $68.78 for Storm Water.
Page 1 of 2
66
Amounts submitted for the quarter to Revenue Recapture (R)are $8,617.58.Note that assessable
items are also included here as mentioned above. The amounts submitted for the quarter to the
collection agency(A) are $730.50.
The amount for first quarter Write-Offs is 358.05, which includes credits due to collections on
amounts previously written off of($223.10), and small balances of$19.92 and bankruptcies or
deceased parties of$561.23.
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.00039%.
ATTACHMENTS:
• 2017 Second Quarter Delinquent Items Comparisons
• 2017 Second Quarter Delinquent Items Submitted
Page 2 of 2
67
a
0
O
0
z
Q
tfD v
n oQ
_ v
N � N 00 C �
O O •
O O
N ~ N . a6
u° c •3
^? r 2
N � � II
mini -
N O J m n n
o o O
_
V V O V E O
N N m D • • N N '."... 'O
ove
w 01 Ol m NlO y M
oIIII
N
Q II ! N G)
N - N tIl W Q
•• •� c0QN OW O OW O
a+
7.
vl m
,4,2 ‘.:! :7__'
torn f.0 ,
O c
v
.v
0 0 0 0 0 0 0 o
aa) 0 0 0 0 0 0 0 0
m 0 0 0 0 0 0 0 0
p r
i-
2
N m m to m CO
lD lD Ill N 02 to to s V
t Ql lD lD ..6 ,:,,-'i
I
al,(1 T
m
C
m
N ¢ C w
� C 1
O
c v
,Ny l0 i0 0� ct d QI «
v 7 C u O O W ._
N rn m N I� u z 3
a m m - , • ® •
m N N - m
v v 0. V N
v ,--I O
0) 0
N
C N
O
N
a4,
a
O
W W N vl V
L 0 0 0 .-1 N N a
C O o '-1 ti O E v
m �v m N Y m
Q N m —
i+
O O C
N
D a
CC
U = N
Q, -
N 0
O
O
v 'n
N Uc O OO
m m
N N -
Q
G
cO O O O O O O O O
O O O O O O O O ' O
N O O O O O O O O
O O O O O O O O
0 O O O O O O O O O
O. U 'C N O 00 t0 a N N
O
U CO CO CO CO
F H H F
a/ 0 0 0 0
CN
Eal O
Q L
C O t
0 ll In F- LL
Delinquent Items Submitted
Agency Sery Addr Provider Total AR
A 11753 198TH AVE 4CTYT $ 1.61
A 11753 198TH AVE 6CTYF $ 11.93
A 11753 198TH AVE 7CTYS $ 4.20
A 16501 HWY 10-SERVICE A 1ERUE $ 224.23
A 16501 HWY 10-SERVICE A 6CTYF $ 170.10
A 1001 SCHOOL ST APT 218 1ERUE $ 304.04
A 1001 SCHOOL ST APT 218 6CTYF $ 14.39 $ 730.50
R 10548 181ST LN 1ERUE $ 153.68
R 10548 181ST LN 2ERUW $ 10.48
R 10548 181ST LN 3CTYS $ 17.32
R 10548 181ST LN 6CTYF $ 7.13
R 10548 181ST LN 7CTYS $ 3.00
R 19379 CARSON CIR 1ERUE $ 258.71
R 19379 CARSON CIR 2ERUW $ 60.94
R 19379 CARSON CIR 3CTYS $ 41.82
R 19379 CARSON CIR 4CTYT $ 39.76
R 19379 CARSON CIR 6CTYF $ 25.44
R 19379 CARSON CIR 7CTYS $ 12.90
R 617 XENIA AVE APT 2 1ERUE $ 230.60
R 617 XENIA AVE APT 2 6CTYF $ 10.86
R 350 EVANS AVE APT 407 1ERUE $ 18.83
R 350 EVANS AVE APT 407 6CTYF $ 5.34
R 20410 SMITH ST 1ERUE $ 1,360.97
R 20410 SMITH ST 4CTYT $ 64.44
R 20410 SMITH ST 6CTYF $ 27.94
R 20410 SMITH ST 7CTYS $ 10.80
R 300 JACKSON AVE APT 319 1ERUE $ 25.70
R 300 JACKSON AVE APT 319 6CTYF $ 5.34
R 10301 175TH CT 1ERUE $ 49.37
R 10301 175TH CT 3CTYS $ 34.52
R 10301 175TH CT 6CTYF $ 9.26
R 10301 175TH CT 7CTYS $ 5.88
R 375 EVANS AVE APT 204 1ERUE $ 47.40
R 375 EVANS AVE APT 204 6CTYF $ 10.86
R 17981 NIXON CT 1ERUE $ 226.68
R 17981 NIXON CT 6CTYF $ 20.46
R 1109 SCHOOL ST APT 21 1ERUE $ 172.84
R 1109 SCHOOL ST APT 21 6CTYF $ 17.44
R 10876 181ST LN 1ERUE $ 94.26
R 10876 181ST LN 6CTYF $ 17.80
R 18580 DAYTON ST 1ERUE $ 125.17
R 13470 ISLANDVIEW DR 1ERUE $ 504.80
R 13470 ISLANDVIEW DR 4CTYT $ 18.42
R 13470 ISLANDVIEW DR 6CTYF $ 17.62
R 13470 ISLANDVIEW DR 7CTYS $ 6.40
69
Delinquent Items Submitted
R 20405 VANCE ST 1ERUE $ 164.16
R 20405 VANCE ST 4CTYT $ 24.16
R 20405 VANCE ST 6CTYF $ 16.73
R 20405 VANCE ST 7CTYS $ 6.40
R 815 UPLAND AVE 1ERUE $ 357.47
R 815 UPLAND AVE 2ERUW $ 38.55
R 815 UPLAND AVE 3CTYS $ 63.65
R 815 UPLAND AVE 4CTYT $ 16.00
R 815 UPLAND AVE 6CTYF $ 10.86
R 815 UPLAND AVE 7CTYS $ 6.30
R 379 BALDWIN AVE APT 203 1ERUE $ 92.98
R 379 BALDWIN AVE APT 203 6CTYF $ 21.83
R 380 3RD ST APT 302 1ERUE $ 117.64
R 380 3RD ST APT 302 6CTYF $ 29.54
R 1001 SCHOOL ST APT 206 1ERUE $ 195.21
R 1001 SCHOOL ST APT 206 6CTYF $ 13.89
R 11931 191 1/2 AVE APT 202 1ERUE $ 95.36
R 11931 191 1/2 AVE APT 202 6CTYF $ 27.40
R 1860 MEADOWVALE RD APT 6 1ERUE $ 531.79
R 1860 MEADOWVALE RD APT 6 6CTYF $ 19.50
R 340 3RD ST APT 206 1ERUE $ 113.23
R 340 3RD ST APT 206 6CTYF $ 24.31
R 1860 MEADOWVALE RD APT 7 1ERUE $ 380.24
R 1860 MEADOWVALE RD APT 7 6CTYF $ 15.67
R 7 3RD ST APT 4 1ERUE $ 13.93
R 7 3RD ST APT 4 6CTYF $ 17.96
R 805 SCHOOL ST APT 6 1ERUE $ 73.58
R 805 SCHOOL ST APT 6 6CTYF $ 17.00
R 18600 GARY ST APT 34 1ERUE $ 92.10
R 18600 GARY ST APT 34 6CTYF $ 11.21
R 300 JACKSON AVE APT 320 1ERUE $ 15.07
R 300 JACKSON AVE APT 320 6CTYF $ 18.87
R 232 2ND ST 1ERUE $ 41.29
R 232 2ND ST 2ERUW $ 116.91
R 232 2ND ST 3CTYS $ 74.97
R 232 2ND ST 4CTYT $ 39.62
R 232 2ND ST 6CTYF $ 21.35
R 232 2ND ST 7CTYS $ 12.90
R 1001 SCHOOL ST APT 308 1ERUE $ 434.85
R 1001 SCHOOL ST APT 308 6CTYF $ 21.89
R 14514 CO RD 30 HOUSE 1ERUE $ 1,099.05
R 365 EVANS AVE APT 203 1ERUE $ 147.06
R 365 EVANS AVE APT 203 6CTYF $ 16.73
R 1227 SCHOOL ST APT 212 1ERUE $ 161.94
R 1227 SCHOOL ST APT 212 6CTYF $ 15.25 $ 8,617.58
Total $ 9,348.08 $ 9,348.08
70