5.2. EERMUSR 05-14-2019 //
Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
ERMU Commission Theresa Slominski — Finance and Office Manager
MEETING DATE: AGENDA ITEM NUMBER:
May 14, 2019 5.2
SUBJECT:
2019 First Quarter Delinquent Items
ACTION REQUESTED:
Approve the 2019 First Quarter Delinquent Items Submitted.
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.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:
I have for review the color-coded recap comparisons with last year, identifying the categories
and amounts for each quarter and the running totals. Regarding the first quarter 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 shown in blue is $0.00 as there has been no
activity yet for this year.
• There were no amounts submitted only to Collection Agencies this year and so the 2019
amount shown in green is $0.00. (Please note that amounts submitted to Revenue
Recapture were also submitted to Collection Agencies.)
Page 1 of 2
382
• The amounts submitted to Revenue Recapture are decreased from the prior year. The
2019 RR amount shown in purple is $2,911.46. (Please note these amounts were also
submitted to a Collection Agency.)
• The amounts for Write Offs are also decreased from the prior year and are shown in
orange at$2,856.42.
The attached report listing shows those dollars submitted to both the Collection Agency and RR.
The fourth quarter totals are $2,911.61. To break these totals down by provider, it is$2,459.01
for Electric, $218.99 for Franchise Fees, $30.09 for Water, $43.43 for Sewer, $119.97 for Trash,
and $40.12 for Storm Water.
The amount for fourth quarter Write-Offs is$2,856.42 which includes: small balances of$22.66,
bankruptcies of$2,014.47, deceased parties of$95.10, and amounts removed from RR meeting
the six year limit with the state program of$724.19. A big impact to the Write-Offs is result of
removing 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$724.19 from RR this year. However, we have collected
so far this year through RR $10,447.26. The biggest impact to the Write-Offs' amount this
quarter are bankruptcies.
Our budgeted amount for collections and write-offs are $25,605 or .0006% 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 are below the national average, at .0003%.
ATTACHMENTS:
• 2019 First Quarter Delinquent Items Comparison
• 2019 First Quarter Delinquent Items Submitted
Page 2 of 2
383
•
Delinquent Items Comparisons
2019 2018 2019 2018 2019 2018 2019 2018 2019 2018
Quarter Assessments Assessments Collection Agency Collection Agency Revenue Recapture Revenue Recapture Write-Offs Write-Offs Totals Totals
First - - 2,911.46 9,644.99 2,856.42 3,383.61 5,767.88 13,028.60
Ym Total - - - - 2,911.46 9,644.99 2,85642 3,383.61
Second • 6,945.51 1,933.72 - I 8,879.23I
YID Total - - - - 2,911.46 16,590.50 2,856.42 5,317.33
Third - 6,233.11 5,047.62 - I 11,233.73
YID Total - - - - 2,91146 22,823.61 2,856.42 10,364.95
Fourth 10,301.48 10,292.97 3,206.46 - 23,800.91
YID Total - 10,301.48 - - 2,911.46 33,116.58 2,856.42 13,571.41 5,767.88 56,989.47 GRAND TOTALS
Less RR 2,911.46 33,116.58
Less Assessments - 10,301.48
Totals excluding RR&Assessments 2,856.42 13 571.41
0.013116%
2019 2018
Delinquent Items Comparisons Delinquent Items Comparisons
12,000.00 12,000.00
10,000.00 10,000.00
8,000.00 S.Collection Agency 8,00030 . •Collection Agency
6,OODpO s Revenue Recapture 6,000.00imi •Revenue Recapture
4,WOA0 ■Write-Offs 4'000A0 . �$.I •Wrte Offs
•Assessments II Mill -.. •Assessments
lU
2,000.00 2,O .OD ■
Ell all all •
1st Oct 2nd Qtr 3rd Qtr 4th Qtr 1st Qtr 2nd Ott 3rd Qtr 4th Qtr
384
Sery Addr Provider Total AR
18164 CONCORD CIR 1ERUE $ 12.77
18164 CONCORD CIR 2ERUW $ 10.25
18164 CONCORD CIR 3CTYS $ 16.92
18164 CONCORD CIR 6CTYF $ 7.65
18164 CONCORD CIR 7CTYS $ 6.62
10029 PARRISH AVE NE 1ERUE $ 280.50
280 EVANS AVE APT 107 1ERUE $ 31.08
280 EVANS AVE APT 107 6CTYF $ 9.96
17226 QUINCY ST 1ERUE $ 19.27
17226 QUINCY ST 6CTYF $ 18.14
17226 QUINCY ST 7CTYS $ 9.03
631 AUBURN PL APT 103 1ERUE $ 27.34
631 AUBURN PL APT 103 6CTYF $ 8.54
543 5TH ST APT 6 1ERUE $ 136.24
543 5TH ST APT 6 6CTYF $ 17.61
379 BALDWIN AVE APT 107 1ERUE $ 94.09
379 BALDWIN AVE APT 107 6CTYF $ 14.57
631 AUBURN PL APT 307 1ERUE $ 153.25
631 AUBURN PL APT 307 6CTYF $ 22.39
633 MAIN ST APT 302 1ERUE $ 189.55
633 MAIN ST APT 302 6CTYF $ 21.89
8385 PARKVIEW AVE NE 1ERUE $ 30.14
805 FREEPORT AVE 1ERUE $ 525.86
805 FREEPORT AVE 6CTYF $ 22.60
17250 TWIN LAKES RD 110 1ERUE $ 25.27
17250 TWIN LAKES RD 110 6CTYF $ 13.16
17250 TWIN LAKES RD 307 1ERUE $ 83.86
17250 TWIN LAKES RD 307 6CTYF $ 12.28
1414 5TH ST NW 1ERUE $ 215.66
1414 5TH ST NW 2ERUW $ 19.84
1414 5TH ST NW 3CTYS $ 26.51
1414 5TH ST NW 4CTYT $ 17.93
1414 5TH ST NW 6CTYF $ 8.20
1414 5TH ST NW 7CTYS $ 6.62
20295 TWIN LAKES RD-GUEST HOME 1ERUE $ 212.16
20295 TWIN LAKES RD-GUEST HOME 4CTYT $ 38.59
20295 TWIN LAKES RD-GUEST HOME 7CTYS $ 6.72
11755 191 1/2 AVE APT 302 1ERUE $ 222.95
11755 191 1/2 AVE APT 302W 6CTYF $ 25.27
21372 HY 169 1ERUE $ 156.34
21372 HWY 169 4CTYT $ 30.92
21372 HWY 169 6CTYF $ 10.10
21372 HWY 169 7CTYS $ 6.72
17151 NIXON ST 1ERUE $ 42.68
17151 NIXON ST 4CTYT $ 32.53
17151 NIXON ST 6CTYF $ 6.63
17151 NIXON ST 7CTYS $ 4.41
$ 2,911.61 TOTAL
385