5.7. ERMUSR 10-08-2013 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:
October 8, 2013 5.7
SUBJECT:
Third Quarter Delinquent Items
BACKGROUND:
Third quarter delinquent items are presented for your review. The attached report has four
columns: Assessments, Collections, Revenue Recapture (RR), and Write Offs.
• Assessments are delays in collecting the money owed and is assessed to the property
taxes in the fall. (This number will grow each quarter delinquents are presented and
once they are submitted to the County, they no longer appear on the report.)
• Collections amounts are those we send to the collection agency to try and collect after
we have exhausted all our internal collection efforts.
• Revenue Recapture 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 resorting to a
collection agency or having to write them off completely. (This number is the
remaining aggregate amount of all funds submitted through this process since
inception.)
• Write Offs are amounts removed from the books with no further collection efforts
being extended.
DISCUSSION:
These amounts cover items through June 15th 2013, as those amounts would be greater than
ninety days out. If we have notice of bankruptcies or deaths through Sept 6th, those would also
be included in these amounts.
The amounts of$4,597.81 will be assessed this fall for the assessable services of water, sewer,
and trash. Pending electric assessments, these amounts could increase.
f 3 NATURE
Reliable Public
POWERED Power Provider T o S E R V E
59
$1,655.55 are accounts sent to a collection agency for further collection efforts, and $755.14 are
written off with no further collection efforts. (Both of these amounts will only appear on this
quarterly report.)
I have also presented the color-coded recap comparisons with last year, identifying the various
categories and the running totals. When comparing the far right columns for 2012 and 2013, we
have fewer delinquent items this year-to-date compared to last year-to-date. One item to note is
that we submitted a large amount last year to RR on some older accounts, and that was not
recurring this year. Also, this year we have collected more than we have submitted through RR -
a very good thing.
Our budgeted amount for collections and write-offs are $105,000 or .32% Uncollectible
Accounts per Revenue Dollar. If we were to project our write-offs for the year based on the first
three quarters, we would be well below this number. According to APPA's most recent
published standard ratios (2011), the industry standard is between .19%and .36%.
Per State Statute 13.685 for Utility Billing Data, the attached report is not public information and
has been excluded from the public copy and final copy storage of commission meeting
information, and the names have also been omitted.
ACTION REQUESTED:
Staff recommends that the Elk River Municipal Utilities Commission accept this delinquent
amounts listing for the third quarter of 2013.
wa Poutoto BI
1�►f 3 NATURE
Reliable Public P O W E R E D T o S E R V E
Power Provider
60
AL
2
LD
A2 =0. Lri
u ! ((\ rrio~ . (\\ \ .
gg; \ \\\ § § \ / ) \ " ( \
; \ � (( \ \ ( oi ni \ ( \
!; ! ! ; ; ; ! » -
; { AAA # } ( & }} \ CO
r ! ! ; § ! ! § w , 4
ul :E: a55 s§ ! !
; ! L.
. X\\\ m 1 L403.-4 \ (\
}
; AA AAA
, § \ §\ ( ( \ \ [ ^ 1 (
, (\\ \ \ \ \ . �
!
To ru re To 73
} g . � C 1 : � C ! ��
V6/013.9:53:03 AM Write-Offs Page 1 of 15
Cult» Sericie Address Serce Assessments COitedion Rev Rec WrteOfi
6016 18361 ROBINSON ST Electric $254.16
9624 814 PROCTOR AVE APT 15 Electric $249.31
18800 10978178TH AVE Electric $394.18
Misc $20.00
20721 8329 PARKVIEW AVE NE Electric $234.54
21265 11931 191 1 i2 AVE APT 208 Electric $177.68
23200 10939 178TH AVE Electric $181.84
24178 241 MAIN ST APT 4 Electric $180.62
25214 11763 194TH AVE Electric $108.22
25519 379 BALDWIN AVE APT 207 Electric 596.66
Misc $20.00
24963 1001 SCHOOL ST APT 111 Electric $232.22
405 11297192ND AVE Electric $194.18
62
9;612013 953:05 AM Wrife•Offs Page 2at 15
C Seri'cie Address Service Assessments Collechon Rev Rec Write011
S672 706 QUINN AVE Electric $1,257.88
22142 20687 QUINCY ST Electric $14827
23457 1175 SCHOOL ST APT 3 Electric $9320
23494 5435TH ST ARTS Elect is $124.94
24166 11248 193RD AVE Electric $109.06
24368 345 EVANS AVE APT 302 Electric $374.95
24427 103 6TH ST B Electric $112.81
Sewer 66.03
Water $4.35
Misc $20.00
24485 1001 SCHOOL ST APT 112 Rectde $234.80
24493 631 AUBURN PL APT 102 Electric $208.99
25160 11978 191 1.2 AVE APT 206 Electric $269.00
25492 1105 LIONS PARK DR APT 112 Electric $159.11
63
916/2013 9:53:05 AM Write•Offs Page 3 of 15
Cast# Smelt Address Sereice Assessmenls Collection Rev Flee Wr011
25502 1115 SCHOOL ST APT 13 Electric $33.41
25654 1227 SCHOOL ST APT 105 Electric $56.43
25775 379 BALDWIN AVE APT G1 Electric $234.64
25803 10970 178TH AVE Electric $246.88
26054 17978 GARY ST Electric $349.37
Trash $3.91
26097 300 3RD ST APT 201 Electric $79.11
26176 10970178TH AVE Electric 898.66
6228 1:r:6 MACON ST Electric $1,74130
Mac $18.78
14890 617 PROCTOR AVE Electric $1,218.51
Misc $20.00
22111 13374 HWY 10 Electric $3,178.33
23716 11104187TH AVE Electric $418.51
64
9161013 AM Wtit€-Offs Page4af15
Cust4 ServcieAddress Service Assessments Collection Rev Ret WWnteOff
26362 847 FREEPORT AVE APT 102 Electric $160.02
26622 627 JEFFERSON IN Electric $178.40
24988 623 JEFFERSON LN Electric $698.50
Misc $20.00
20678 18996 LINCOLN ST Electric 51,047.50
Misc $40.00
4241 59 6112 ST Electric $237.85
21311 18074 VANCE CIR Electric $463A0
Misc $20.00
21583 379 BALOW IN AVE APT G6 Electric $145.16
Misc $12.61
22747 15620 93RD CIR NE Electric $276.24
23981 18600 GARY ST APT 27 Electric 66438
24416 18600 GARY ST APT 26 Electric $137.90
24853 I 337 BALDWIN AVE APT 110 Electric $25577
Misc S20.00
65
9(6/20139:5305AM Write•Ois Page 5of 15
C Servcie Address Service Assessments Collection Rev Rec WriteOff
25256 11058 190TH AVE Electric 5770.12
Misc $40.00
25664 814 PROCTOR AVE APT 21 Electric $408.32
25819 103 6TH ST B Electric $324.98
Misc $40.00
26300 10939 178TH AVE Electric $97.89
26689 18520 ROBINSON ST 6 Electric $42.71
21332 19599 TIPTON ST Aectric $248,72
24532 1001 SCHOOL ST APT 210 Electric $169.99
25543 10168 PARRISH AVE NE Electric $162.77
537 18514 OLSON ST Electric $23641
5554 18551 DAYTON ST Electric $486.65
Misc $246.20
18392 10919181ST LN Electric $13135
66
91620139:53:05 AM Wnte•Of s Page6of 15
•Cust;t Servcie Address Service Assessments Collection Rev Rec WriteOff
18700 379 BALDWIN AVE APT 105 Electric $177.52
20096 11931 191 112 AVE APT 107 Electric $74.61
20632 11940 191 112 AVE APT 102 Electric $97.89
21540 11355 207TH AVE Electric $206A5
21579 151 5TH ST APT 107 Electric $143.28
Misc $0.05
21809 10969 185TH AVE Electric $274.36
24085 1001 SCHOOL ST APT 110 Electric $247.15
24169 385 EVANS AVE APT 304 Electric $158.95
24876 22130 QUINN ST Electric $615.16
25295 1105 LIONS PARK DR APT 303 Electric $168.80
25459 543 5TH ST APT 4 Electric $177.53
67
916 013 9:53:05 AM Wr e•Offs Page l of 15
Gusty Selvcie Address Smite Assessments Gollection Rev Ree WneOff
25465 11055187TH AVE Electric $155.62
25677 23 3RD ST APT 205 Electric $184.71
25876 1115 SCHOOL ST APT 11 Electric $12756
261% 18555 TROTT BROOK PKWY Electric $420.73
Mist $42,00
26351 340 3RD ST APT 305 Electric $159.99
26675 11755 191 112 AVE APT 304 Electric $204.65
27383 337 BALDWIN AVE APT 209 Electric i $48.74
22235 236 2ND ST Electric $347.23
Sewer $56.54
Water 649.25
Trash $23.79
24943 365 EVANS AVE APT 104 Electric $61.63
27400 103 6TH ST B Electric $185.08
Sewer $22.43
Water $113.05
25790 18983 YORK ST STE B Electrc $960.55
Misc 540.14
68
96.2013 9:5105 AM Write-Offs Page 8 of 15
Cush Sete Address Service Assessments Collection Rev Rec WriteO(<
25704 942 MAN ST APT 01 Electric $147A8
- Misc $9.74
25192 345 EVANS AVE APT 304 Etectr„ $90.10
10811 8742 PARELL AVE NE Electric $197.25
Misc $20.00
24863 18869 ALBANY ST Electric $215.53
Misc $30.05
24351 11349 219TH AVE Electric $268.96
Trash $4.31
14257 10729 185TH CIR Electric $896.45
Sewer $45.63
Water $42.35
Trash $2.66
18060 18594 GARY ST APT 2 Electric $112.95
24113 379 BALDWIN AVE APT GO Electric $5628
24193 379 BALDWIN AVE APT 1® Electric $207,79
Misc $0.11
24937 1227 SCHOOL ST APT 302 Electric $164.43
25616 633 MAIN ST APT 419 Electric $240.61
69
91213 9;53:05 AM Write-Offs Page 9 of 15
Cues Sentcie Address Service Assessments Collection Rev Rec WateOf
25656 1001 SCHOOL ST APT 115 Electric $206.96
26152 16600 GARY ST APT 24 Electric $174,11
27635 12233 191ST AVE Electric $246.13
Sewer $59.13
Wafer $58.45
26951 627 JEFFERSON LN Electric $46.85
Sewer $37.24
Water $44.85
Trash $23.79
7656 21128 YORK ST Trash $33.86
20666 18071 LINCOLN C1R Sewer $90.10
Water $93.30
Trash $45.75
23916 151 5TH ST APT 324 Electric $72.58
25396 1001 SCHOOL ST APT 217 Electric $245.40
Misc $20.00
4868 807 FREEPORT AVE Electric $182.68
22611 11951 191 112 AVE APT 202 Electric $220.65
Misc $0,31
22960 18037 VANCE CIR Electric $38.91
70
912013 95345 AM Write.Olis Page 10 al 15
Gust* SeNcie Address Service Assessments Calledion Rev Rec Wtlleaif
23038 17954 MACON ST Fleceric $676.61
Trash $75,11
26737 11770 213TH AVE Electric $61.42
Trash $25.95
28208 10372 180TH AVE Electric $179.13
Sewer $46.67
Water $130.64
Trash $86.01
Misc $20,00
25335 18776 CLEVELAND ST Electric $1$0108
27526 340 3RD ST APT 301 Electric $38.f
17239 14725 93RD ST NE Electric 585.80
1:: 1726 7TH ST Electric $179.23
Sewer $47.25
Water $26,70
Trash $11.90
6446 18366 SMITH CT Electric $164.92
Sewer $19.40
Water $12.48
19192 530 AUBURN PL APT F Electric $188.55
Sewer $75.66
Water $3750
•
21483 847 FREEPORT AVE APT 206 Electric $189.56
71
91612013 9:5105 AM Write,Offs Page 11 of 15
Cust* Selvcie Address Ser Ace Assessments Collection Rev Rec WrieOtf
22855 805 SCHOOL ST APT 2 Electric $191.93
23197 13861 186TH IN Sewer $65.00
Water $8115
Trash $24.46
Misc $20.00
24274 11755 191 112 AVE APT 303 Electric . $428.62
Misc $20.00
25352 ' 13340181STLN Electric $17.04
Sewer $60.82
Water $43.70
Trash $28.82
262217 1001 SCHOOL ST APT 208 Electric $134.40
26749 1109 SCHOOL ST APT 31 Electric $416.76
Misc 520.00
26811 1179 SCHOOL ST APT 3 Electric $363.82
Misc $20.03
26894 13224 181ST LN Electric $229.96
Sewer $5111
Water $97.15
Trash $53.55
Misc $20.00
28157 565 AUBURN PL Electric $360.07
Sewer $65.25
Water $41.85
Trash $33.06
Misc $20.00
2$292 337 BALDWIN AVE'APT 201 Electric $51.61
72
9142013 9:53:05 AM Write-Offs Page 12 of 15
Cust# Servcie Address Service Assessments Collection Rev Rec WnIeO11
22707 11884192ND AVE Electric $607.67
Trash $1430
26885 11755191172 AVE APT 301 Efecfrie 5335,44
Misc 540.00
28132 379 BALDWIN AVE APT 205 E1eciric $313.12
27364 1001 SCHOOL ST APT 101 Electric $33.58
27872 19064 DODGE ST Electric $905.16
Sewer $134.30
Wafer $127.15
Trash $161.76
28442 18569 ULYSSES ST Electric $59.39
Sewer $40.78
Water $15.60
27575 11796 191ST AVE Sewer $150.27
Water $206.44
Trash $129.71
Misc $36.28
28283 715AUBURNPL Sewer $4.54
Water $37.60
i Trash $74.05
27117 11928 192ND AVE Electric $756.28
Trash $47.60
23978 12095 HIGHLAND RD Electrc �$6 11
Trash •91 x,'
28277 942 MAIN ST APT 100 Electric $68.98
73
X20139.57:42 AM Wflt2.Offs Page 13 of 15
Cust;t Servcie Address Service Assessments Collection Rev Rec WtileOff
8350 11796 191ST AVE GARAGE Electric $68.55
Ct
27794 18001 SUNRISE CIR Electric $25298
Trash $43.92
15978 631 AUBURN FL APT 201 Electric 547,38
24372 325 EVANS AVE APT 203 Electric $114.88
25849 385 HOLT AVE APT 306 Electric $5.69
5233 15570182ND AVE Electric $433.46
8548 19497 ZUMBRO ST Electric S435.71
Sewer $78.33
Water $65.71
Trash 557.80
Misc $57.51
13834 18042 VANCE CIR Electric $92.95
21433 10948 185TH CIR Electric $38616
Sewer $83.80
Water $105.27
21611 1790 TIPTON CIR Electric $325.34
Sewer $48.50
Water $154.67
Trash $87.84
Misc $20.00
74
9g2013 9i3:06 A!d Wflte.Of#S Page 14 of 15
Cush Serve*Address Service Assessments Collection Rev Rec WriTe011
18051 10898 187TH AVE Electric -54949
Sewer Z7.M3S643
Water 1.2.07611149
19455 300 JACKSON AVE APT 206 Electric $150.84
23692 23 3RD ST APT 201 Electric $52.58
2020D 271 ELK HILLS DR Electric 5232.56
Trash $33.07
24017 942 MAIN ST APT G1 Electric $259.67
24386 15728 94TH ST NE Electric $554.76
27548 544 AUBURN PL APT H Sewer $2.30
Water $38.60
Misc $17.74
26995 1001 SCHOOL ST APT 109 Electric $652.48
Misc $40.00
24864 18856 ALBANY ST Electric $183.80
Sew $27.70
Water $24.65
Trash $1.33
27957 515 SCHOOL ST Electric $100.13
Sewer $87.68
Water $68.63
Trash $4577
25291 1001 SCHOOL ST APT 108 Electric $354.18
75
91612013 9:56:16 AM Mite-Offs Page 15 of 15
Custtr
Spade Address Service Assessments Collection Rev Rec WrlteOf
28257 1227 SCHOOL ST APT 210 Electric $154.79
27831 514 JEFFERSON 111 Electric $28.29
Sewer $5641
Water $45.14
Trash $8.59
27224 11981 191 112 AVE APT 202 Electric 546.28
26722 753 FREEPORT AVE ElectrIc $187.59
26222 1105 LIONS PARK DR APT 226 Electric $218.75
24638 14251 184TH AVE NW Electric $7.94
Sewer $47.25
24932 1111 SCHOOL ST APT 32 Electric $32.83
54,649.02 $11696:64$421225.68 $755.14
ar 5g1,8111655.55
•
76