5.2. ERMUSR 08-09-2016 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:
August 9, 2016 5.2
SUBJECT:
2016 Second Quarter Delinquent Items
BACKGROUND:
Second 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 4rh 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.
• 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), and those
submitted to revenue recapture (R).
I also have for review the color-coded recap comparisons with last year, identifying the
categories with running totals, and graphs. There are no amounts listed for assessments as the
process for assessments culminates in the last quarter from information previously submitted to
other collection services and if not collected, removed and assessed. 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.
I. r ® IEREI $ r
Page 1 of 2 NATURE
Reliable
1eProvider'
P
POWERED T O S ERV E
61
Amounts submitted for the quarter to Collection Agencies (A)total $2,411.07. (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.)
Amounts submitted for the quarter to Revenue Recapture (R) are $8,785.97. Note that
assessable items are also included here as mentioned above. We have collected $27,379.56 from
RR in 2016, over 100%of those dollars submitted since we are also collecting for prior year
submissions. (Of note, included in the $27,379.56 collected is $10,500 for a commercial account
in Otsego that we wrote off in 2015 for$42,219.73. This is probably the only amount we will
ever collect on this account.)
The second quarter totals for(A) and(R) are $11,197.04. To break these totals down by
provider, it is $9,191.19 for Electric, $321.72 for Water, $496.60 for Sewer, $359.65 for Trash,
$682.66 for Franchise Fees, and $145.22 for Storm Water.
The amount for second quarter Write-Offs is ($338.07), a credit due to collections on amounts
previously written off, which is very typical in the second quarter.
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 RR, for the year are below
the national average, at.007% (and .047% including RR).
ACTION REQUESTED:
Staff recommends that the Elk River Municipal Utilities Commission accept this delinquent
amounts listing for the second quarter of 2016.
ATTACHMENTS:
• Delinquent items submitted to Collection Agencies and Revenue Recapture
• Color-coded recap Delinquent Items Comparisons
rOVI & EI ® r
Page 2 of 2 NATURE
Reliable Public
Power Provider POWERED T O SERV E
62
Elk River Municipal Utilities
Q2 Accounts placed at Rev Recap, Collection Agency or Both
By Agency
Agency Account Sery Addr Provider Total AR
A 7652 21268 YORK ST 1ERUE $ 208.26
A 7652 21268 YORK ST 4CTYT $ 10.75
A 7652 21268 YORK ST 6CTYF $ 5.87
A 7652 21268 YORK ST 7CTYS $ 4.20
A 23610 17173 POLK DR 1ERUE $ 394.98
A 23610 17173 POLK DR 4CTYT $ 49.43
A 23610 17173 POLK DR 6CTYF $ 14.95
A 23610 17173 POLK DR 7CTYS $ 12.60
A 29379 17163 MONROE DR 1ERUE $ 217.28
A 29379 17163 MONROE DR 4CTYT $ 10.46
A 29379 17163 MONROE DR 6CTYF $ 11.76
A 29379 17163 MONROE DR 7CTYS $ 6.40
A 31289 10713 193RD AVE 1ERUE $ 331.24
A 31289 10713 193RD AVE 4CTYT $ 32.00
A 31289 10713 193RD AVE 6CTYF $ 21.01
A 31289 10713 193RD AVE 7CTYS $ 6.40
A 31628 217 1ST ST 2ERUW $ 15.08
A 31628 217 1ST ST 3CTYS $ 72.78
A 31628 217 1ST ST 4CTYT $ 43.63
A 31628 217 1ST ST 6CTYF $ 26.51
A 31628 217 1ST ST 7CTYS $ 12.90
A 32766 12671 MEADOWVALE RD STE 0 1ERUE $ 242.23
A 32766 12671 MEADOWVALE RD STE 0 6CTYF $ 88.17
A 33861 10653 172ND AVE 208 1ERUE $ 254.61
A 33861 10653 172ND AVE 208 6CTYF $ 21.15
A 33915 17155 QUINCY ST 203 1ERUE $ 90.16
A 33915 17155 QUINCY ST 203 6CTYF $ 21.14
A 33995 15420 89TH ST 1ERUE $ 185.12
AGENCY $ 2,411.07
R 19453 300 JACKSON AVE APT 320 1ERUE $ 57.25
R 19453 300 JACKSON AVE APT 320 6CTYF $ 11.21
R 22204 12572 224TH CT 1ERUE $ 295.45
R 22204 12572 224TH CT 4CTYT $ 58.39
R 22204 12572 224TH CT 6CTYF $ 26.34
R 22204 12572 224TH CT 7CTYS $ 8.60
R 24370 325 EVANS AVE APT 201 1ERUE $ 40.82
R 25306 380 3RD ST APT 201 1ERUE $ 233.29
R 25306 380 3RD ST APT 201 6CTYF $ 11.74
R 28580 13480 181ST CIR 1ERUE $ 217.86
R 28580 13480 181ST CIR 6CTYF $ 17.30
R 28580 13480 181ST CIR 7CTYS $ 6.12
C:\Users\tslominski\AppData\Local\Microsoft\Windows\Temporary Internet
Files\Content.Outlook\A3QCWQZ4\Bad Debt April-June 2016.xlsx
63
Elk River Municipal Utilities
Q2 Accounts placed at Rev Recap, Collection Agency or Both
By Agency
Agency Account Sery Addr Provider Total AR
R 28655 18920 ALBANY ST 1ERUE $ 1,003.62
R 28655 18920 ALBANY ST 2ERUW $ 108.37
R 28655 18920 ALBANY ST 3CTYS $ 191.10
R 28655 18920 ALBANY ST 4CTYT $ 47.04
R 28655 18920 ALBANY ST 6CTYF $ 29.35
R 28655 18920 ALBANY ST 7CTYS $ 16.50
R 29135 379 BALDWIN AVE APT 202 1ERUE $ 242.96
R 29135 379 BALDWIN AVE APT 202 6CTYF $ 21.83
R 29139 232 2ND ST 1ERUE $ 27.39
R 29139 232 2ND ST 2ERUW $ 48.87
R 29139 232 2ND ST 3CTYS $ 41.58
R 29139 232 2ND ST 4CTYT $ 32.98
R 29139 232 2ND ST 6CTYF $ 17.61
R 29139 232 2ND ST 7CTYS $ 9.90
R 29291 11755 191 1/2 AVE APT 305 1ERUE $ 26.86
R 29291 11755 191 1/2 AVE APT 305 6CTYF $ 13.53
R 29939 11884 192ND AVE 1ERUE $ 869.51
R 29939 11884 192ND AVE 4CTYT $ 15.50
R 29939 11884 192ND AVE 6CTYF $ 15.50
R 29939 11884 192ND AVE 7CTYS $ 6.40
R 30035 633 MAIN ST APT 107 1ERUE $ 193.37
R 30035 633 MAIN ST APT 107 6CTYF $ 17.61
R 30223 1227 SCHOOL ST APT 316 1ERUE $ 96.27
R 30223 1227 SCHOOL ST APT 316 6CTYF $ 17.61
R 30438 11755 191 1/2 AVE APT 304 1ERUE $ 452.36
R 30438 11755 191 1/2 AVE APT 304 6CTYF $ 11.74
R 30641 10990 178TH AVE 1ERUE $ 278.62
R 30641 10990 178TH AVE 6CTYF $ 39.31
R 31072 413 3RD ST 1ERUE $ 935.38
R 31072 413 3RD ST 2ERUW $ 84.71
R 31072 413 3RD ST 3CTYS $ 94.08
R 31072 413 3RD ST 4CTYT $ 36.22
R 31072 413 3RD ST 6CTYF $ 19.17
R 31072 413 3RD ST 7CTYS $ 9.60
R 31497 814 PROCTOR AVE APT 3G 1ERUE $ 77.43
R 31497 814 PROCTOR AVE APT 3G 6CTYF $ 11.40
R 31520 536 AUBURN PL APT A 1ERUE $ 405.63
R 31520 536 AUBURN PL APT A 2ERUW $ 64.69
R 31520 536 AUBURN PL APT A 3CTYS $ 48.54
R 31520 536 AUBURN PL APT A 6CTYF $ 11.74
R 31520 536 AUBURN PL APT A 7CTYS $ 29.60
R 31597 814 PROCTOR AVE APT 2F 1ERUE $ 80.83
C:\Users\tslominski\AppData\Local\Microsoft\Windows\Temporary Internet
Files\Content.Outlook\A3QCWQZ4\Bad Debt April-June 2016.xlsx
64
Elk River Municipal Utilities
Q2 Accounts placed at Rev Recap, Collection Agency or Both
By Agency
Agency Account Sery Addr Provider Total AR
R 31597 814 PROCTOR AVE APT 2F 6CTYF $ 10.86
R 31619 151 5TH ST APT 326 1ERUE $ 191.43
R 31619 151 5TH ST APT 326 6CTYF $ 16.17
R 31824 18521 DAYTON ST 1ERUE $ 69.29
R 31892 11755 191 1/2 AVE APT 106 1ERUE $ 441.15
R 31892 11755 191 1/2 AVE APT 106 6CTYF $ 26.88
R 31901 11966 192ND AVE 1ERUE $ 267.94
R 31901 11966 192ND AVE 4CTYT $ 18.89
R 31901 11966 192ND AVE 6CTYF $ 11.00
R 31901 11966 192ND AVE 7CTYS $ 6.40
R 31903 1105 LIONS PARK DR APT 324 1ERUE $ 67.41
R 31903 1105 LIONS PARK DR APT 324 6CTYF $ 16.73
R 32276 18520 ROBINSON ST#7 1ERUE $ 60.62
R 32351 11981 191 1/2 AVE APT 108 1ERUE $ 214.62
R 32351 11981 191 1/2 AVE APT 108 6CTYF $ 32.21
R 32480 10078 179TH LN 1ERUE $ 2.14
R 32480 10078 179TH LN 3CTYS $ 48.52
R 32480 10078 179TH LN 4CTYT $ 4.36
R 32480 10078 179TH LN 6CTYF $ 7.43
R 32480 10078 179TH LN 7CTYS $ 9.60
R 33169 1179 SCHOOL ST APT 3 1ERUE $ 98.13
R 33169 1179 SCHOOL ST APT 3 6CTYF $ 30.43
R 34024 1227 SCHOOL ST APT 102 1ERUE $ 120.24
R 34024 1227 SCHOOL ST APT 102 6CTYF $ 17.61
R 34119 631 AUBURN PL APT 206 1ERUE $ 161.18
R 34119 631 AUBURN PL APT 206 6CTYF $ 9.79
R 34365 1001 SCHOOL ST APT 309 1ERUE $ 38.26
REV RECAP $ 8,785.97
$ 11,197.04 TOTAL I
C:\Users\tslominski\AppData\Local\Microsoft\Windows\Temporary Internet
Files\Content.Outlook\A3QCWQZ4\Bad Debt April-June 2016.xlsx
65