Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.2 ERMUSR 05-08-2018
,,/ Elk River Municipal Utilities UTILITIES COMMISSION MEETING TO: FROM: ERMU Commission Theresa Slominski -Finance & Office Manager MEETING DATE: AGENDA ITEM NUMBER: May 8, 2018 5.2 SUBJECT: 2018 First Quarter Delinquent Items ACTION REQUESTED: Approve the 2018 First Quarter Delinquent Items Submitted BACKGROUND: First 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. This includes RR items that have met the six year limit and removed from the state program. DISCUSSION: The attached report listing 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). This quarter we only have items submitted to revenue recapture (R) in the listing. I also have for review the color-coded recap comparisons with last year, identifying the categories and the running totals. 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. Page 1 of 2 75 Amounts submitted for the quarter to Revenue Recapture (R) are $9,644.99. (Note that assessable items are also included here as mentioned above.) We have seen an increase in items we are attempting to collect with the additional customer base we have acquired. Regarding the RR program, we have collected $11,723.43 from RR in 2018 so far from prior year submissions.Notably, over the seven years we have been with RR,we have collected $179,207.87! This quarter, we have also needed to remove $3,093.97 for accounts meeting the six year maximum to be retained with the state RR program, as noted below with the write-off amounts. This program has been very beneficial for us. The first quarter totals of delinquent items are $9,644.49. To break these totals down by provider, it is $8,012.36 for Electric, $278.49 for Water, $424.26 for Sewer, $313.89 for Trash, $491.20 for Franchise Fees, and $124.79 for Storm Water. The amount for first quarter Write-Offs is $3,383.61, which includes credits due to collections on amounts previously written off of($436.17), and small balances of$4.93,bankruptcies of $546.69, $3,093.97 for amounts removed from RR meeting the six year limit of being with the state program, and $174.19 determined uncollectible. 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 (2015),the industry standard is between .17% and .37%. Interestingly,the Northern/Central Plains average is .09%. Our totals for the year so far are below the national average, at.0083%. ATTACHMENTS: • 2018 First Quarter Delinquent Items Comparisons • 2018 First Quarter Delinquent Items Submitted Page 2 of 2 76 ol— z m @ m q@qq }& co 8. /o . . .M. , $ t § k \\ 22 NP ela § a» @ , 0, f el a „ ' . ! § z ) { ) 0y .MEM 11 } © ^ 1-- .12 III. - \ , , , z I ; 2 § ` w w _ w , Lill . ) $ $ 888888 . 8 00 ° ° § § f \ § " }\ \ \ \ 4 « & § § tea ; 6 / / \ j\ \ } \ {: ! ! I ` - \ UUUU . • . . . . ( E ; I ` to( 8E \ co co til Ln VI ft, \ / a }g ® A . . . . . ) . IIIII ( vj� § / j / j 2 $ q ( ( a ! Agency Account Sery Addr Provider Total AR R 474 10078 154TH AVE 1ERUE $ 418.06 R 474 10078 154TH AVE 6CTYF $ 21.00 R 474 10078 154TH AVE 4CTYT $ 39.46 R 474 10078 154TH AVE 7CTYS $ 8.40 R 940 19101 JACKSON AVE NW 1ERUE $ 215.51 R 940 19101 JACKSON AVE NW 4CTYT $ 1.96 R 940 19101 JACKSON AVE NW 6CTYF $ 11.22 R 940 19101 JACKSON AVE NW 7CTYS $ 4.00 R 4028 19073 PASCAL ST 1ERUE $ 27.07 R 4028 19073 PASCAL ST 6CTYF $ 3.92 R 4028 19073 PASCAL ST 7CTYS $ 0.18 R 4867 1414 MAIN ST NW 1ERUE $ 26.66 R 4867 1414 MAIN ST NW 2ERUW $ 13.29 R 4867 1414 MAIN ST NW 3CTYS $ 23.40 R 4867 1414 MAIN ST NW 6CTYF $ 8.01 R 4867 1414 MAIN ST NW 7CTYS $ 6.00 R 20098 751 FREEPORT AVE 1ERUE $ 344.98 R 20098 751 FREEPORT AVE 6CTYF $ 28.47 R 23677 12158 197TH CT 1ERUE $ 518.86 R 23677 12158 197TH CT 4CTYT $ 39.17 R 23677 12158 197TH CT 6CTYF $ 25.09 R 23677 12158 197TH CT 7CTYS $ 10.60 R 24004 18573 TYLER DR 1ERUE $ 292.35 R 24004 18573 TYLER DR 2ERUW $ 53.19 R 24004 18573 TYLER DR 3CTYS $ 85.64 R 24004 18573 TYLER DR 6CTYF $ 17.44 R 24004 18573 TYLER DR 7CTYS $ 9.60 R 28621 634 QUINN AVE 2ERUW $ 46.85 R 28621 634 QUINN AVE 3CTYS $ 99.90 R 28621 634 QUINN AVE 4CTYT $ 24.84 R 28621 634 QUINN AVE 6CTYF $ 17.44 R 28621 634 QUINN AVE 7CTYS $ 9.60 R 29779 11755 191 1/2 AVE APT 105 1ERUE $ 218.75 R 29779 11755 191 1/2 AVE APT 105 6CTYF $ 17.79 R 29872 17170 POLK ST 1ERUE $ 381.75 R 29872 17170 POLK ST 6CTYF $ 23.67 R 31040 1109 SCHOOL ST APT 17 1ERUE $ 112.43 R 31040 1109 SCHOOL ST APT 17 6CTYF $ 17.08 R 31592 12221 191ST AVE 3CTYS $ 85.64 R 31592 12221 191ST AVE 6CTYF $ 16.02 R 31592 12221 191ST AVE 7CTYS $ 7.99 R 31863 300 JACKSON AVE APT 304 1ERUE $ 166.63 R 31863 300 JACKSON AVE APT 304 6CTYF $ 15.13 R 33623 17250 TWIN LAKES RD 109 1ERUE $ 71.57 R 33623 17250 TWIN LAKES RD 109 6CTYF $ 17.62 R 34111 17250 TWIN LAKES RD 315 1ERUE $ 366.69 78 R 34111 17250 TWIN LAKES RD 315 6CTYF $ 18.50 R 34125 20295 TWIN LAKES RD- FARM HOMI 1ERUE $ 276.35 R 34125 20295 TWIN LAKES RD- FARM HOMI 4CTYT $ 15.51 R 34125 20295 TWIN LAKES RD- FARM HOMI6CTYF $ 18.53 R 34125 20295 TWIN LAKES RD- FARM HOMI 7CTYS $ 6.40 R 34685 11884 192ND AVE 1ERUE $ 221.53 R 34685 11884 192ND AVE 4CTYT $ 1.45 R 34685 11884 192ND AVE 6CTYF $ 9.50 R 34685 11884 192ND AVE 7CTYS $ 4.20 R 35346 631 WASHINGTON CT 1ERUE $ 110.98 R 35346 631 WASHINGTON CT 2ERUW $ 10.04 R 35346 631 WASHINGTON CT 3CTYS $ 13.38 R 35346 631 WASHINGTON CT 6CTYF $ 4.99 R 35346 631 WASHINGTON CT 7CTYS $ 3.00 R 33555 17182 MONROE ST 1ERUE $ 214.39 R 33555 17182 MONROE ST 4CTYT $ 35.67 R 33555 17182 MONROE ST 6CTYF $ 25.27 R 33555 17182 MONROE ST 7CTYS $ 10.50 R 35656 10078 154TH AVE-GARAGE 1ERUE $ 70.33 R 35662 9619 HWY 10 1ERUE $ 1,685.14 R 35662 9619 HWY 10 6CTYF $ 91.73 R 35937 17250 TWIN LAKES RD 213 1ERUE $ 130.88 R 35937 17250 TWIN LAKES RD 213 6CTYF $ 16.90 R 36123 18600 GARY ST APT 28 1ERUE $ 65.36 R 36123 18600 GARY ST APT 28 6CTYF $ 10.86 R 36192 1111 4TH ST DOWNSTAIRS 1ERUE $ 115.87 R 36192 1111 4TH ST DOWNSTAIRS 7CTYS $ 15.02 R 36518 633 MAIN ST APT 417 1ERUE $ 319.84 R 36518 633 MAIN ST APT 417 6CTYF $ 17.61 R 37391 103 6TH ST B 1ERUE $ 448.99 R 37391 103 6TH ST B 2ERUW $ 112.31 R 37391 103 6TH ST B 3CTYS $ 70.59 R 37391 103 6TH STB 6CTYF $ 16.11 R 37391 103 6TH STB 7CTYS $ 9.60 R 37454 14322 190TH AVE 1ERUE $ 56.22 R 37454 14322 190TH AVE 6CTYF $ 5.53 R 37454 14322 190TH AVE 7CTYS $ 2.00 R 37538 19044 BALDWIN ST 1ERUE $ 251.96 R 37538 19044 BALDWIN ST 2ERUW $ 42.81 R 37538 19044 BALDWIN ST 3CTYS $ 45.71 R 37538 19044 BALDWIN ST 4CTYT $ 62.18 R 37538 19044 BALDWIN ST 6CTYF $ 15.77 R 37538 19044 BALDWIN ST 7CTYS $ 9.30 R 37542 20295 TWIN LAKES RD-GUEST HOM 1ERUE $ 883.21 R 37542 20295 TWIN LAKES RD-GUEST HOM4CTYT $ 93.65 R 37542 20295 TWIN LAKES RD-GUEST HOM 7CTYS $ 8.40 $ 9,644.99 TOTAL 79