5.2 ERMUSR 05-09-2017 �/
Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
ERMU Commission Theresa Slominski - Finance & Office Manager
MEETING DATE: AGENDA ITEM NUMBER:
May 9, 2017 5.2
SUBJECT:
2017 First Quarter Delinquent Items
ACTION REQUESTED:
Approve the 2017 First Quarter Delinquent Amounts Listing.
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 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). For the first quarter we only have Revenue Recapture (R) items.
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.
Amounts submitted for the quarter to Revenue Recapture (R) are $5,739.46. Note that assessable
items are also included here as mentioned above. We have collected $14,911.43 from RR in
2017 so far from prior year submissions.
Page 1 of 2
11P
The first quarter totals are $5,739.46. To break these totals down by provider, it is $4,951.40 for
Electric, $186.52 for Trash, $547.94 for Franchise Fees, and $53.60 for Storm Water.
The amount for first quarter Write-Offs is ($18.07), which includes credits due to collections on
amounts previously written off of($233.25), and small balances of$55.74 and bankruptcies of
$159.44.
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 for the year so far are below the national
average, at .000146%.
ATTACHMENTS:
• 2017 First Quarter Delinquent Items Comparisons
• 2017 First Quarter Delinquent Items Submitted
Page 2 of 2
120
I
N
J
Q
0
0
0
z
Q
(7 N
HTo 3
co - 41 00 it)N 00N a-1 t0N N N Q
CO N CO00m Ci N N N N C
ON O r O V7 C71. ai dN N O j O
H r1 .-I N N m ei t'j C N
ij _
uz 3
•
N m m ,. N to • ■
ON 1 N N 0 ( � � ..1-
y1 N N m .-1
N N N i
1- ra z
0.E v
0
N N n rn to m to m ,
kp k_
a o V m o m .-i
h N 00 vi ai to m N p E k ,
,,., Nrn N m N S' 3 d o4'g. N Oa+ m
O v m Ni" N
NY
O N c
N y 01 C cu
cc °C' tib.
Q N C
N
N t�/1 '01
1 •i
N 0 41
J y ,.
0
N
n r r r 0.
� CC
0 O O O
N N N N N CO »M tc l:S., a.
M ti
6
U O O O coo O O ' O
j X N
HO O O O O O O O
N N N O N N N O O
N N -9- 00 `6 N ". N
O - - -
H
41 m m N N Nal mm O N N 00 00N m
to v-
O co lD N N LD Cr, N to C\
CO N LU N N N N c�-I N
1a
Nu to l0 W l() .21
tD - N
ti OJ c-1 H N c-I m N
z
o v R
D n
c v o
> Q v
✓ c
d C
w
El v •1," a - N N o a',
N 0 al N Q1 al Ci U C
Q m mm m m I ■
to N r N N N
u N N vi N c
al 0
0l 0
L 0
m r
> 0 a
E
0
U
W CO I", Ln V rn ti O
,,,
uoo O .-I mV LDti 0
O O c.titi .a2I O .n� W O C
N vm
4.,
.-i .-+ N m m ai -
- c c
No 0cu
7 d
✓ S i c
O c N
U
Cl
N
- d
.
N
V O O O O O 0
C O O O O O � O
v p 88888 O
O O O O O 0
N O
U Lr, O O O O p
O
u m m m
E O O O O
N H H H H
tx v0 0 0 0
C o
7
C0
- L
C CO a t
•c ` `,i) i
LE tH LL
O
R 32043 11114TH ST DOWNSTAIRS 1ERUE $91.30
R 32043 11114TH ST DOWNSTAIRS 4CTYT $29.55
R 32043 11114TH ST DOWNSTAIRS 7CTYS $8.60
R 32382 316 JACKSON AVE NW #316 1ERUE $41.11
R 32382 316 JACKSON AVE NW #316 6CTYF $88.17
R 32429 18600 GARY ST APT 28 1ERUE $87.90
R 32429 18600 GARY ST APT 28 6CTYF $20.29
R 33415 300 JACKSON AVE APT 306 1ERUE $109.53
R 33415 300 JACKSON AVE APT 306 6CTYF $17.08
R 33996 1227 SCHOOL ST APT 303 1ERUE $18.36
R 33996 1227 SCHOOL ST APT 303 6CTYF $11.21
R 34107 814 PROCTOR AVE APT 2E 1ERUE $190.98
R 34107 814 PROCTOR AVE APT 2E 6CTYF $28.64
R 34191 16110 JARVIS ST 1ERUE $296.70
R 34191 16110 JARVIS ST 4CTYT $22.70
R 34191 16110 JARVIS ST 6CTYF $7.49
R 34191 16110 JARVIS ST 7CTYS $6.40
R 34220 19529 BOSTON ST 1ERUE $128.35
R 34220 19529 BOSTON ST 6CTYF $17.62
R 34289 380 3RD ST APT 305 1ERUE $196.64
R 34289 380 3RD ST APT 305 6CTYF $36.14
R 34724 10432 172ND LN NW 1ERUE $261.05
R 34724 10432 172ND LN NW 6CTYF $10.30
R 34724 10432 172ND LN NW 7CTYS $6.40
R 34772 11755 191 1/2 AVE APT 101 1ERUE $71.91
R 34772 11755 191 1/2 AVE APT 101 6CTYF $10.86
R 35180 17250 TWIN LAKES RD 204 1ERUE $17.70
R 35180 17250 TWIN LAKES RD 204 6CTYF $23.49
R 35436 300 JACKSON AVE APT 222 1ERUE $150.16
R 35436 300 JACKSON AVE APT 222 6CTYF $18.59
R 35747 315 JACKSON AVE APT 202 1ERUE $55.50
R 35747 315 JACKSON AVE APT 202 6CTYF $10.65
R 35855 7468 QUIGLEY AVE NE 1ERUE $48.60
R 36007 10653 172ND AVE 302 1ERUE $35.18
R 36007 10653 172ND AVE 302 6CTYF $8.62
$5,739.46 Total
12:1