5.2 ERMUSR 02-14-2017 Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
Elk River Municipal Utilities Commission Theresa Slominski—Finance and Office
John Dietz, Chair Manager
Allan Nadeau, Vice-Chair
Daryl Thompson, Trustee
MEETING DATE: AGENDA ITEM NUMBER:
February 14, 2017 5.2
SUBJECT:
2016 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.
• 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.
• 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 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 four
categories and the running totals. The amounts listed for assessments of$14,762.86 were those
presented and approved by the commission in November 2016. 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.
POWERED BY
Page 1 of 2 NATURE
110.
Reliable Public
Power Provider POWERED To SERVE
127
Amounts submitted for the quarter to the collection agency (A) are $9,317.61. There is a large
dollar amount of$8,832.86 for a business that left town with a balance owing. (When looking at
the first quarter of 2015, we were not able to extract a report from our software conversion in
February and there are no collection agency dollars presented.) The amount submitted to
Revenue Recapture and also submitted to the Collection Agencies (B)total $13,147.28.
The fourth quarter totals for(A) and(B) are $22,464.89. To break these totals down by provider,
it is $21,089.82 for Electric, $189.19 for Water, $179.70 for Sewer, $34.66 for Trash, $927.42
for Franchise Fees, and $44.10 for Storm Water.
The amount for fourth quarter Write-Offs is $3,513.66, with a year-to-date total of$2,907.33
(including a$1,265.49 reduction due to collections on amounts previously written off.)
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, excluding and including RR, for the
year are below the national average, at.013%excluding RR and .15% including RR.
ACTION REQUESTED:
Staff recommends that the Elk River Municipal Utilities Commission accept this delinquent
amounts listing for the fourth quarter of 2016.
ATTACHMENTS:
• Color-Coded Recap Delinquent Items Comparisons for 2015/2016
• Fourth Quarter 2016—Delinquent Amounts Listing
vPOWERED OY
Page 2 of 2 NATURE
Reliable Public
Power Provider P OWERE0 To SERVE
128
Lb
a
F-
0
0z
a
m
0 v
N R¢ 0 Lb m O1bN w m
r< o o o vi aN L
N o W nminLbc
z
y 00 in -
NNOn O N NNi0N
O j O
N N N 1p O �n N N .'
,H i.Y) 0 a
a 1 3
0 N 0^1 N veli N m W In N ®-
NN 01 00 vl 00 rl l0 N N C
N CO M o d' O- N N 0
I. O
le_1v1 Ol Ol d' n 8
2 Lb Lb N0 M (0 L
a II v
E
Q
O om m , a `
CO 00 V N - Ol v1 C . N (7
ti r-I Ol e-� N O e-i N
0E ,
N
v o� m �n
„n O v c-i
Elk River Municipal Utilities
Q4 Accounts placed at Rev Recap, Collection Agency, or Both
By Agency
Agency Account Sery Addr Provider Total AR
A 3154 9694 PARKINGTON AVE 1ERUE $ 484.75
A 9487 19232 EVANS ST 1ERUE $ 8,291.25
A 9487 19232 EVANS ST 6CTYF $ 241.88
A 11071 19238 EVANS ST 1ERUE $ 299.73
AGENCY $ 9,317.61
B 10161 8390 PARKINGTON AVE NE 1ERUE $ 444.92
B 6584 15673 94TH ST NE 1ERUE $ 259.74
B 17103 300 3RD ST APT 302 1ERUE $ 154.80
B 17103 300 3RD ST APT 302 6CTYF $ 22.42
B 21622 18030 VANCE CIR 1ERUE $ 53.87
B 21622 18030 VANCE CIR 6CTYF $ 7.30
B 22171 761 FREEPORT AVE 1ERUE $ 312.37
B 22171 761 FREEPORT AVE 6CTYF $ 17.62
B 24007 10910 181ST LN 1ERUE $ 333.91
B 24007 10910 181ST LN 6CTYF $ 24.74
B 24286 345 EVANS AVE APT 104 1ERUE $ 124.09
B 24286 345 EVANS AVE APT 104 6CTYF $ 11.40
B 26248 280 EVANS AVE APT 204 1ERUE $ 205.61
B 26248 280 EVANS AVE APT 204 6CTYF $ 12.46
B 26664 1819 MEADOWVALE RD 1ERUE $ 957.42
B 26664 1819 MEADOWVALE RD 2ERUW $ 51.92
B 26664 1819 MEADOWVALE RD 3CTYS $ 63.65
B 26664 1819 MEADOWVALE RD 4CTYT $ 2.91
B 26664 1819 MEADOWVALE RD 6CTYF $ 23.49
B 26664 1819 MEADOWVALE RD 7CTYS $ 6.30
B 28138 340 3RD ST APT 302 1ERUE $ 300.78
B 28138 340 3RD ST APT 302 6CTYF $ 17.80
B 29574 1115 SCHOOL ST APT 14 1ERUE $ 88.94
B 29574 1115 SCHOOL ST APT 14 6CTYF $ 29.71
B 29658 18086 MACON ST 1ERUE $ 614.04
B 29658 18086 MACON ST 2ERUW $ 52.22
B 29658 18086 MACON ST 3CTYS $ 45.47
B 29658 18086 MACON ST 4CTYT $ 16.00
B 29658 18086 MACON ST 6CTYF $ 18.87
B 29658 18086 MACON ST 7CTYS $ 6.30
B 31211 373 GATES AVE 1ERUE $ 28.25
B 31211 373 GATES AVE 2ERUW $ 13.52
B 31211 373 GATES AVE 3CTYS $ 30.31
B 31211 373 GATES AVE 6CTYF $ 17.97
B 31211 373 GATES AVE 7CTYS $ 3.00
130
B 31360 1227 SCHOOL ST APT 208 1ERUE $ 142.74
B 31360 1227 SCHOOL ST APT 208 6CTYF $ 16.90
B 31889 631 AUBURN PL APT 306 1ERUE $ 186.56
B 31889 631 AUBURN PL APT 306 6CTYF $ 22.42
B 31983 1227 SCHOOL ST APT 103 1ERUE $ 227.18
B 31983 1227 SCHOOL ST APT 103 6CTYF $ 22.42
B 32312 1001 SCHOOL ST APT 314 1ERUE $ 363.68
B 32312 1001 SCHOOL ST APT 314 6CTYF $ 24.74
B 32403 10077 179TH LN 1ERUE $ 228.93
B 32403 10077 179TH LN 3CTYS $ 12.99
B 32403 10077 179TH LN 6CTYF $ 11.40
B 32403 10077 179TH LN 7CTYS $ 3.00
B 32640 17116 MONROE DR 1ERUE $ 547.26
B 32640 17116 MONROE DR 6CTYF $ 20.29
B 32640 17116 MONROE DR 7CTYS $ 2.00
B 32723 17170 POLK CIR 1ERUE $ 365.14
B 32723 17170 POLK CIR 6CTYF $ 19.22
B 32723 17170 POLK CIR 7CTYS $ 2.00
B 32727 13428 182ND AVE 1ERUE $ 12.02
B 32727 13428 182ND AVE 2ERUW $ 20.65
B 32727 13428 182ND AVE 3CTYS $ 27.28
B 32727 13428 182ND AVE 4CTYT $ 14.77
B 32727 13428 182ND AVE 6CTYF $ 15.13
B 32727 13428 182ND AVE 7CTYS $ 6.30
B 32864 18600 GARY ST APT 21 1ERUE $ 96.21
B 32864 18600 GARY ST APT 21 6CTYF $ 21.70
B 32897 515 SCHOOL ST 1ERUE $ 353.72
B 32975 942 MAIN ST APT 200 1ERUE $ 158.60
B 32975 942 MAIN ST APT 200 6CTYF $ 18.87
B 33002 1105 LIONS PARK DR APT 204 1ERUE $ 64.97
B 33002 1105 LIONS PARK DR APT 204 6CTYF $ 11.40
B 33138 14732 CO RD 30 1ERUE $ 573.62
B 33346 8763 PARRISH AVE NE 1ERUE $ 449.21
B 33379 814 PROCTOR AVE APT 3A 1ERUE $ 328.18
B 33379 814 PROCTOR AVE APT 3A 6CTYF $ 22.77
B 33704 17250 TWIN LAKES RD 405 1ERUE $ 82.49
B 33704 17250 TWIN LAKES RD 405 6CTYF $ 17.44
B 33865 10653 172ND AVE 211 1ERUE $ 140.86
B 33865 10653 172ND AVE 211 6CTYF $ 16.90
B 33872 10653 172ND AVE 302 1ERUE $ 404.22
B 33872 10653 172ND AVE 302 6CTYF $ 24.91
B 34015 1227 SCHOOL ST APT 213 1ERUE $ 214.62
B 34015 1227 SCHOOL ST APT 213 6CTYF $ 30.61
B 34028 10617 172ND LANE 1ERUE $ 605.59
B 34028 10617 172ND LANE 6CTYF $ 18.51
B 34028 10617 172ND LANE 7CTYS $ 2.00
B 34139 17250 TWIN LAKES RD 303 1ERUE $ 137.68
131
B 34139 17250 TWIN LAKES RD 303 6CTYF $ 24.02
B 34276 8312 PARKVIEW AVE NE 1ERUE $ 421.48
B 34334 17934 VANCE CIR 1ERUE $ 227.55
B 34334 17934 VANCE CIR 6CTYF $ 16.90
B 34446 1001 SCHOOL ST APT 203 1ERUE $ 229.99
B 34446 1001 SCHOOL ST APT 203 6CTYF $ 11.03
B 34488 11948 190TH CIR 1ERUE $ 355.15
B 34488 11948 190TH CIR 2ERUW $ 49.44
B 34488 11948 190TH CIR 6CTYF $ 13.90
B 34488 11948 190TH CIR 7CTYS $ 3.00
B 34753 300 3RD ST APT 104 1ERUE $ 31.47
B 34753 300 3RD ST APT 104 6CTYF $ 11.21
B 34788 543 5TH ST APT 4 1ERUE $ 56.88
B 34788 543 5TH ST APT 4 6CTYF $ 24.38
B 34833 1214 6TH ST 1ERUE $ 45.55
B 34833 1214 6TH ST 2ERUW $ 1.44
B 34833 1214 6TH ST 6CTYF $ 0.89
B 34833 1214 6TH ST 7CTYS $ 3.00
B 34957 11948 192ND AVE 1ERUE $ 365.84
B 34957 11948 192ND AVE 4CTYT $ 0.98
B 34957 11948 192ND AVE 6CTYF $ 22.77
B 34957 11948 192ND AVE 7CTYS $ 4.20
B 35106 11755 191 1/2 AVE APT 205 1ERUE $ 550.75
B 35106 11755 191 1/2 AVE APT 205 6CTYF $ 18.33
B 35201 12387 196TH CIR 1ERUE $ 167.21
B 35201 12387 196TH CIR 6CTYF $ 2.70
B 35201 12387 196TH CIR 7CTYS $ 3.00
BOTH $ 13,147.28
$ 22,464.89 Total
132