5.2 ERMUSR 2-11-2020UTILITIES COMMISSION MEETING
TO: FROM:
ERMU Commission Melissa Karpinski Finance Manager
MEETING DATE: AGENDA ITEM NUMBER:
February 11, 2020 5.2
SUBJECT:
2019 Fourth Quarter Delinquent Items
ACTION REQUESTED:
Approve the 2019 fourth quarter delinquent items submitted.
BACKGROUND:
Fourth 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 are assessed to the
Ʒŷ
property taxes in the fall. tƌĻğƭĻ ƓƚƷĻ Ʒŷźƭ ƓǒƒĬĻƩ Ǟźƌƌ ƚƓƌǤ ĬĻ ƦƩĻƭĻƓƷĻķ źƓ ƷŷĻ Ѝ
ƨǒğƩƷĻƩ͵
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
to the individual. It presents an opportunity to collect funds rather than splitting
with a collection agency or having to write them off completely. There is a six-year
limit for keeping items on RR and if uncollected at this time, amounts are removed
and written off.
Write Offs are amounts removed from the books with no further collection efforts
being extended.
DISCUSSION:
We have for review comparisons with last year which identify the categories and amounts for
each quarter and the running totals. Regarding the year end totals:
The amounts listed for assessments culminate in the fourth quarter and include items
previously submitted to other collection services, and if not collected, are removed and
assessed. The assessment amount for 2019 is $4,743.53. All categories assessed
decreased compared to the prior year.
The amounts submitted ƚƓƌǤ to Collection Agencies for 2019 is $85.77. (Please note that
amounts submitted to Revenue Recapture were also submitted to Collection Agencies.)
The amounts submitted to Revenue Recapture were less than the prior year. The 2019
RR amount is $23,637.92. We have collected a total of $21,733.92 from RR in 2019.
______________________________________________________________________________
Page 1 of 2
79
Write Offs for 2019 of $11,995.65 are comparable to prior year. The biggest impact to
the Write-Offs is due to the removal of items from the RR program due to a six-year
limit mandated by the state. We have had to remove, and write-off, a total of $7,856.86
from RR this year. However, that still leaves us $13,877.06 ahead with the $21,733.92
we have collected this year through RR.
The attached report listing shows those dollars submitted to both the Collection Agency and RR.
The fourth quarter totals are $5,708.23. To break these totals down by provider, it is $5,050.27
for Electric, $446.96 for Franchise Fees, $115.90 for Sewer, $46.85 for Water, $26.33 for Trash,
and $21.92 for Storm Water.
The amount for fourth quarter Write-Offs is $3,833.53 which includes: small balances of
$109.71, and amounts removed from RR meeting the six-year limit with the state program of
$3,723.82.
Our allowance for doubtful accounts (a reserve for bad debt/write-offs) is $25,605 or .06%
uncollectible accounts per revenue dollar. According to the American Public Power
Associationent published standard ratios (2017), the industry standard is between
.17% and .40%. Interestingly, the Northern/Central Plains average is .18%. Our totals for the
year are below the national average, at .029%.
ATTACHMENTS:
2019 Fourth Quarter Delinquent Items Comparison
2019 Fourth Quarter Delinquent Items Submitted
______________________________________________________________________________
Page 2 of 2
80
Delinquent Items Comparisons
Rev
Collection Revenue Recap/Coll Rev Recap
YearQuarterAssessmentsAgencyRecaptureAgenWrite-OffsPmts
20171 - - 5,739.46 5,739.46 (18.07) 12,149.77
20172 - 730.50 8,617.58 9,348.08 358.05 6,595.05
20173 - - 8,319.80 8,319.80 (34.28) 5,308.24
20174 8,352.84 180.40 10,344.56 10,524.96 2,272.12 1,472.34
20181 - - 9,644.99 9,644.99 3,383.61 9,374.71
20182 - - 6,945.51 6,945.51 1,933.72 3,293.10
20183 - - 6,233.11 6,233.11 5,047.62 1,496.85
20184 10,301.48 - 10,292.97 10,292.97 3,206.46 1,258.91
20191 - - 2,911.46 2,911.46 2,444.35 10,447.26
20192 - 85.77 8,267.42 8,353.19 3,755.56 8,258.66
20193 - - 6,750.81 6,750.81 1,962.21 1,855.27
20194 4,743.53 - 5,708.23 5,708.23 3,833.53 1,172.73
Quarterly Write-Offs by Year
6,000
5,000
4,000
Quarter
1
3,000
2
3
2,000
4
1,000
0
201720182019
Quarterly Amts Submitted for
Collection by Year
12,000
10,000
Quarter
8,000
1
6,000
2
3
4,000
4
2,000
0
201720182019
81
Rev Recap to Write-Off Comparison
35,000
30,000
25,000
20,000
15,000
10,000
5,000
0
201720182019
Values
Total Submitted to RRTotal RR Pmts
Total Write-Offs
Total Write-OffsTotal Assessments
14,00014,000
12,00012,000
10,000
10,000
8,000
8,0002017
2017
2018
2018
6,000
6,000
2019
2019
4,000
4,000
2,000
2,000
0
0
201720182019
201720182019
Year
Year
82
Serv AddrTotal AR
9121 PARK AVE 163.77
703 AUBURN PL 65.49
703 AUBURN PL 8.00
703 AUBURN PL 17.08
703 AUBURN PL 3.20
631 AUBURN PL APT 105 93.43
631 AUBURN PL APT 105 17.73
300 JACKSON AVE APT 202 123.82
300 JACKSON AVE APT 202 21.67
1227 SCHOOL ST APT 313 232.61
1227 SCHOOL ST APT 313 17.73
18333 ROOSEVELT CIR 48.33
18333 ROOSEVELT CIR 5.57
18333 ROOSEVELT CIR 61.75
18333 ROOSEVELT CIR 6.44
18333 ROOSEVELT CIR 2.20
18600 GARY ST APT 29 50.89
18600 GARY ST APT 29 17.19
17250 TWIN LAKES RD 202 145.09
17250 TWIN LAKES RD 202 12.03
10653 172ND AVE 210 230.15
10653 172ND AVE 210 22.58
337 BALDWIN AVE APT 209 209.62
337 BALDWIN AVE APT 209 16.83
1105 LIONS PARK DR APT 106 25.37
1105 LIONS PARK DR APT 106 19.16
21580 MEADOWVALE RD 650.73
21580 MEADOWVALE RD 15.76
21580 MEADOWVALE RD 2.20
814 PROCTOR AVE APT 1G 111.05
814 PROCTOR AVE APT 1G 11.09
373 GATES AVE 246.52
373 GATES AVE 24.67
373 GATES AVE 39.90
373 GATES AVE 26.33
373 GATES AVE 21.69
373 GATES AVE 6.72
942 MAIN ST APT 100 259.53
942 MAIN ST APT 100 21.67
530 JACKSON AVE 198.89
530 JACKSON AVE 8.61
530 JACKSON AVE 14.25
530 JACKSON AVE 21.67
530 JACKSON AVE 3.20
9149 PAGE AVE NE 262.04
300 EVANS AVE APT 301 85.44
300 EVANS AVE APT 301 11.82
17250 TWIN LAKES RD 105 87.05
17250 TWIN LAKES RD 105 25.25
17250 TWIN LAKES RD 114 228.55
17250 TWIN LAKES RD 114 13.26
21372 HWY 169 556.52
21372 HWY 169 18.08
21372 HWY 169 2.20
241 MAIN ST APT 1 167.31
241 MAIN ST APT 1 16.85
1105 LIONS PARK DR APT 120 259.27
1105 LIONS PARK DR APT 120 23.10
1001 SCHOOL ST APT 205 43.58
1001 SCHOOL ST APT 205 19.35
1001 SCHOOL ST APT 307 193.62
1001 SCHOOL ST APT 307 17.17
631 AUBURN PL APT 106 26.31
631 AUBURN PL APT 106 5.81
20410 SMITH ST NW 85.92
20410 SMITH ST NW 9.85
20410 SMITH ST NW 2.20
725 6TH ST APT 302 117.34
725 6TH ST APT 302 12.80
18594 GARY ST APT 1 82.03
18594 GARY ST APT 1 13.30
TOTAL 5,708.23
83