5.3. ERMUSR 02-12-2019 Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
ERMU Commission Theresa Slominski—Finance and Office Manager
MEETING DATE: AGENDA ITEM NUMBER:
February 12, 2019 5.3
SUBJECT:
2018 Fourth Quarter Delinquent Items
ACTION REQUESTED:
Approve the 2018 fourth quarter delinquent items.
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 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 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 2018 shown in blue is$10,301.48. The categories
of Electric, Water, Sewer and Franchise assessable charges were increased over the
prior year, while Trash and Stormwater assessable charges decreased.
• There were no amounts submitted only to Collection Agencies this year and so the 2018
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
62
• The amounts submitted to Revenue Recapture were very comparable to the prior year,
although amounts submitted in each quarter were varied. The 2018 RR amount shown
in purple is$33,116.58.
• Write Offs are considerably higher in 2018 and are shown in orange at $13,571.41. The
biggest impact to the Write-Offs increase over the prior year is a 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$12,234.22 from RR this year. However, that still
leaves us$3,189.35 ahead with the$15,423.57 we have collected so far this year
through RR.
The attached report listing shows those dollars submitted to both the Collection Agency and RR.
The fourth quarter totals are $10,292.97. To break these totals down by provider, it is
$9,354.30 for Electric, $540.51 for Franchise Fees, $214.66 for Water, $104.12 for Sewer,
$19.83 for Trash, and $59.55 for Storm Water. We have seen an increase in items we are
attempting to collect with the additional customer base we have acquired.
The amount for fourth quarter Write-Offs is$3,206.46 which includes: small balances of$2.88,
bankruptcies of$62.12, deceased parties of$196.59, uncollectible amounts from collection
agency of$25.00, and amounts removed from RR meeting the six year limit with the state
program of$2,919.87.
Our budgeted amount for collections and write-offs are $105,000, or .27% uncollectible
accounts per revenue dollar. According to the American Public Power Association'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 .035%.
ATTACHMENTS:
• 2018 Fourth Quarter Delinquent Items Comparison
• 2018 Fourth Quarter Delinquent Items Submitted
Page 2 of 2
63
Delinquent Items Comparisons
2018 2017 2018 2017 2018 2017 2018 2017 2018 2017
Quarter 7 Assessments Assessments Collection Agency Collection Agency Revenue Recapture Revenue Recapture Write-Offs Write-Offs Totals Totals
First - - 9,644.99 5,739.46 3,383.61 (18.07) 13,028.60 5,721.39
YTD Total - - - - 9,644.99 5,739.46 3,383.61 (18 07)
Second ,. - 730.50 6,945.51 8,617.58 1,933.72 358.05 8,879.23 I 9,706.13 I
YTD Total - - - 730.50 16,590.50 14,357.04 5,317.33 339.98
Third - 6,233.11 8,319.80 5,047.62 (34.28) 11,280.73 8,285.52I
YTD Total - - .Ak ]30.50 22,823.61 22,676.84 10,364.95 305.]0
Fourth 10,301.48 8,352.84,'c.:" 180.40 10,292.97 10,344.56 3,206.46 2,272.12 23,800.91 21,149.92
YTD Total 10,301,48 8,352.84 . 910.90 33,116.58 33,021.40 13,571.41 2,577.82 56989.47 44,862.96 GRAND TOTALS
Less RR 33,116.58 33,021.40
Less Assessments 10,301.48 3,352.84
Totals excluding RR&Assessments 13,571.41 3,488.72
0.013116%
2018 2017
Delinquent Items Comparisons Delinquent Items Comparisons
12,000.00 .__..____.__._ __..____....__.— 12,000.00
10,000.00 10,000.00
8,030.00 •Collection Agency 8,000'00 •Collection Agency
6,000.00 wn Revenue Recapture 6,000.00 •Revenue Recapture
4,003.00 , ■Write-Offs 4,000.00 •Wrne OHs
204000 ,. ■Assessments 2,000.00 ■Assessments
1st Qtr 2nd CM 03r 4th Qtr 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
(2,000.00) (2,000.00)
64
Sery Addr Total AR
11812 HIGHLAND RD 380.12
19454 LANDER ST 672.66
13278 181ST LN 46.6
345 EVANS AVE APT 303 323.95
1001 SCHOOL ST APT 310 85.23
813 FREEPORT AVE 165.5
14340 183RD AVE 89.43
17123 NIXON ST 467.02
11951 191 1/2 AVE APT 205 184.4
13383 179TH CIR 143.95
300 JACKSON AVE APT 215 175.77
11478 190TH LN 49.25
919 PROCTOR AVE 41.19
18730 ROBINSON ST DOWN 86.11
14061 185TH AVE 812.21
1105 LIONS PARK DR APT 321 163.44
10653 172ND AVE 201 514.75
10653 172ND AVE 314 390.25
633 MAIN ST APT 107 411.36
805 SCHOOL ST APT 10 76.45
17168 NIXON CIR 106.73
17250 TWIN LAKES RD 404 157.56
385 EVANS AVE APT 206 200.44
10713 188TH AVE NW 166.25
10251 H WY 10 E 834.56
11951 191 1/2 AVE APT 202 37.81
16110 JARVIS ST 590.71
10461 172ND LN 101.38
385 EVANS AVE APT 201 229.47
300 JACKSON AVE APT 313 47.39
17151 NIXON ST 280.36
1860 MEADOWVALE RD APT 2 104.53
1001 SCHOOL ST APT 107 449.33
759 FREEPORT AVE 60.96
19043 BALDWIN ST 114.4
1227 SCHOOL ST APT 105 120.16
1105 LIONS PARK DR APT 318 151.75
300 JACKSON AVE APT 213 81.37
631 AUBURN PL APT 104 51.6
10841 181ST LN 109.21
18450 ROBINSON ST 194.57
1109 SCHOOL ST APT 34 145.91
1111 4TH ST DOWNSTAIRS 55.45
1227 SCHOOL ST APT 103 250.28
13278 181ST LN 227.09
345 EVANS AVE APT 304 97.21
633 MAIN ST APT 310 46.85
TOTAL 10,292.97
65