2.4 ERMUSR 11-12-2019 Elk River
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
ERMU Commission Theresa Slominski—Administrations Director
MEETING DATE: AGENDA ITEM NUMBER:
November 12, 2019 2.4
SUBJECT:
2019 Third Quarter Delinquent Items
ACTION REQUESTED:
Approve the 2019 Third Quarter Delinquent Items Submitted
BACKGROUND:
Third 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 third quarter totals:
• The amounts listed for assessments culminate in the fourth quarter and include items
previously submitted to other collection services. If not collected, they 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.
• The amounts submitted only to Collection Agencies for 2019 are shown in green $0.00.
(Please note that amounts submitted to Revenue Recapture were also submitted to
Collection Agencies.)
Page 1 of 2
42
• The amounts submitted to Revenue Recapture are increased slightly from the prior year.
The 2019 RR amount shown in purple is $6,750.81. (Please note these amounts were
also submitted to a Collection Agency.)
• The amounts for Write Offs are decreased from the prior year and are shown in 0;;�n
ct S .
The attached report listing shows those dollars submitted to both the Collection Agency and RR.
The third quarter totals are $6,315.14 for Electric, and $435.67 for Franchise Fees.
The amount for third quarter Write-Offs is $1,962.21 which includes: small balances of$3.29,
deceased customer balances of$332.41, amounts removed from RR meeting the six year limit
with the state program of$2,168.89, bankruptcy reversals of$(352.74), and amounts collected
previously written off of$(189.64). A big impact to the Write-Offs is the result of removing
items from the RR program due to a six year limit mandated by the state. However, we have
collected $20,561.19 through RR so far this year.
Our budgeted amount for collections and write-offs is $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 .00029%.
ATTACHMENTS:
• 2019 Third Quarter Delinquent Items Comparison
• 2019 Third Quarter Delinquent Items Submitted
Page 2 of 2
43
§
Al
, c '
` ` i i g ; 4k
1 } \ k
7 '2 �z z§ §
: «
ri
§ !
iiiiME�
M .. . a
« § [ � 1
� a �
I . a
I2r
~ ^ \jiTi .\\ \\ ! �
, ; l.. e
z 8 8 8 g q 8 '
! \ § ° ( \ 1-
� }\ \ \\ \\ _ � & , �
. . . 3
01 { / §
\ • ) • •
® \ / } / - \ i \
§ii
§ (} {
0
\ . . . . / $
;
° 8 8 8 8 §
•) ;2ni g ! \ !
0 3 > > : i : ° ; !
i \ ( \ \ /
/ Cr \ / \
Agency Sery Addr Provider Total AR
B 9093 PAGE AVE 1ERUE $ 272.39
B 10936 181ST LN 1ERUE $ 140.53
B 280 EVANS AVE APT 104 1ERUE $ 68.03
B 1227 SCHOOL ST APT 315 1ERUE $ 44.20
B 15386 93RD ST NE 1ERUE $ 571.71
B 657 MAIN ST REAR APT DOWN 1ERUE $ 513.99
B 1105 LIONS PARK DR APT 105 1ERUE $ 46.28
B 18402 SMITH ST 1ERUE $ 642.17
B 10824 181ST LN 1ERUE $ 150.72
B 627 JEFFERSON LN 1ERUE $ 68.89
B 17837 TYLER DR 1ERUE $ 112.00
B 8763 PARRISH AVE NE 1ERUE $ 554.15
B 11938 192ND AVE 1ERUE $ 50.92
B 1001 SCHOOL ST APT 206 1ERUE $ 147.19
B 814 PROCTOR AVE APT 1E 1ERUE $ 26.96
B 1860 MEADOWVALE RD APT 7 1ERUE $ 287.51
B 1175 SCHOOL ST APT 5 1ERUE $ 61.84
B 365 BALDWIN AVE APT 101 1ERUE $ 315.84
B 9754 VIKING BLVD UPSTAIRS 1ERUE $ 298.36
B 1105 LIONS PARK DR APT 315 1ERUE $ 23.87
B 633 MAIN ST APT 415 1ERUE $ 145.20
B 21298 NAPLES ST 1ERUE $ 372.62
B 1860 MEADOWVALE RD APT 6 1ERUE $ 122.08
B 10653 172ND AVE 108 1ERUE $ 166.86
B 17163 MONROE DR 1ERUE $ 320.12
B 11798 HIGHLAND RD APT 5 1ERUE $ 127.87
B 1001 SCHOOL ST APT 111 1ERUE $ 108.17
B 337 BALDWIN AVE APT 307 1ERUE $ 206.27
B 17250 TWIN LAKES RD 315 1ERUE $ 17.58
B 814 PROCTOR AVE APT 3C 1ERUE $ 26.98
B 11755 191 1/2 AVE APT 304 1ERUE $ 154.25
B 1227 SCHOOL ST APT 301 1ERUE $ 53.37
B 925 ANGEL ST#106 1ERUE $ 96.22 $ 6,315.14
B 10936 181ST LN 6CTYF $ 20.06
B 280 EVANS AVE APT 104 6CTYF $ 16.12
B 1227 SCHOOL ST APT 315 6CTYF $ 6.44
B 657 MAIN ST REAR APT DOWN 6CTYF $ 16.37
B 1105 LIONS PARK DR APT 105 6CTYF $ 16.12
B 18402 SMITH ST 6CTYF $ 14.85
B 10824 181ST LN 6CTYF $ 16.12
B 627 JEFFERSON LN 6CTYF $ 18.07
B 17837 TYLER DR 6CTYF $ 13.43
B 11938 192ND AVE 6CTYF $ 3.76
B 1001 SCHOOL ST APT 206 6CTYF $ 10.74
B 814 PROCTOR AVE APT 1E 6CTYF $ 9.67
45
Agency Sery Addr Provider Total AR
B 1860 MEADOWVALE RD APT 7 6CTYF $ 14.31
B 1175 SCHOOL ST APT 5 6CTYF $ 16.83
B 365 BALDWIN AVE APT 101 6CTYF $ 19.18
B 9754 VIKING BLVD UPSTAIRS 6CTYF $ 21.67
B 1105 LIONS PARK DR APT 315 6CTYF $ 4.30
B 633 MAIN ST APT 415 6CTYF $ 19.16
B 21298 NAPLES ST 6CTYF $ 12.35
B 1860 MEADOWVALE RD APT 6 6CTYF $ 13.61
B 10653 172ND AVE 108 6CTYF $ 13.61
B 17163 MONROE DR 6CTYF $ 13.25
B 11798 HIGHLAND RD APT 5 6CTYF $ 14.15
B 1001 SCHOOL ST APT 111 6CTYF $ 16.12
B 337 BALDWIN AVE APT 307 6CTYF $ 20.23
B 17250 TWIN LAKES RD 315 6CTYF $ 23.64
B 814 PROCTOR AVE APT 3C 6CTYF $ 6.62
B 11755 191 1/2 AVE APT 304 6CTYF $ 17.73
B 1227 SCHOOL ST APT 301 6CTYF $ 5.01
B 925 ANGEL ST#106 6CTYF $ 22.15 $ 435.67
$ 6,750.81 TOTAL
46