The URL can be used to link to this page

5.1 ERMUSR 05-10-2016Elk River'4. 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: May 10, 2016 5.1 SUBJECT: 2016 First Quarter Delinquent Items 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 4`h 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), 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 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 IM Reliable _Pbic Power Provider Page 1 of 2 123 P I I I R E I II NATURE P oWEREn To SERVE the hopes that they will be collected. Items not collected by assessment time are removed from RR and assessed instead. Amounts submitted for the quarter to Collection Agencies (A) total $1,560.08. (When comparing to the first quarter of 2015, we were not able to extract a report from our software conversion in February and so only RR was utilized in that first quarter and there are no collection agency dollars presented.) Amounts submitted to RR and the Collection Agency are not included here, they are included in the RR amounts. Amounts submitted for the quarter to Revenue Recapture (R) are $6,646.36, including $2,089.58 also submitted to the collection agency. (As mentioned above, for those funds submitted to both resources, as we collect from either resource we remove the dollars at the second resource.) Note that assessable items are also included here as mentioned above. We have collected $21,830.32 from RR in 2016, over 100% of those dollars submitted since we are also collecting for prior year submissions. (Of note, included in the $21,830.32 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 first quarter totals for (A), (B), and (R) are $8,206.44. To break these totals down by provider, it is $6,560.35 for Electric, $257.75 for Water, $518.05 for Sewer, $260.12 for Trash, $506.97 for Franchise Fees, and $103.20 for Storm Water. The amount for fourth quarter Write -Offs is ($927.42), a credit due to collections on amounts previously written off, which is very typical in the first 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 .002% (and .019% including RR). ACTION REQUESTED: Staff recommends that the Elk River Municipal Utilities Commission accept this delinquent amounts listing for the first quarter of 2016. ATTACHMENTS: Delinquent items submitted to Collection Agencies and Revenue Recapture Color -coded recap Delinquent Items Comparisons �3. Reliable Public Power Provider Page 2 of 2 124 prP_0gWpEERRg�EOer I V/'� I VRppCIG P o W ER EO To SERVE Delinquent Items Listing - First Quarter 2016 Agency Account Sery Add Provider Total AR A 31637 11266 192ND AVE 1ERUE 203.46 A 3750 16420 DAYTON AVE 1ERUE 98.86 A 17300 11798 HIGHLAND RD APT 3 1ERUE 128.85 A 27443 17195 POLK CT 1ERUE 286.75 A 29054 17138 MONROE ST 1ERUE 30.38 A 29380 10429 172ND LN 1ERUE 4.91 A 30682 10617 172ND LN 1ERUE 36.41 A 33656 17147 MONROE CT 1ERUE 28.42 A 33660 10908 171ST AVE UNIT A 1ERUE 502.14 A 31637 11266 192ND AVE 2ERUW 40.44 A 32583 10173 176TH AVE 2ERUW 6.18 A 31637 11266 192ND AVE 3CTYS 24.26 A 32583 10173 176TH AVE 3CTYS 16.18 A 31637 11266 192ND AVE 4CTYT 0.98 A 27443 17195 POLK CT 4CTYT 66.43 A 29054 17138 MONROE ST 4CTYT 1.94 A 29380 10429 172ND LN 4CTYT 11.14 A 31637 11266 192ND AVE 6CTYF 5.87 A 17300 11798 HIGHLAND RD APT 3 6CTYF 5.87 A 27443 17195 POLK CT 6CTYF 9.08 A 33660 10908 171ST AVE UNIT A 6CTYF 17.63 A 31637 11266 192ND AVE 7CTYS 6.30 A 27443 17195 POLK CT 7CTYS 10.40 A 29054 17138 MONROE ST 7CTYS 4.00 A 29380 10429 172ND LN 7CTYS 6.20 A 30682 10617 172ND LN 7CTYS 4.00 A 32583 10173 176TH AVE 7CTYS 3.00 Collection Agency Total 1,560.08 B 12766 18402 SMITH ST 1ERUE 28.85 B 17260 538TIPTONAVE 1ERUE 43.73 B 20323 340 3RD ST APT 105 1ERUE 281.80 B 27685 9911 PARRISH AVE NE 1ERUE 319.33 B 30457 379 BALDWIN AVE APT 104 1ERUE 135.00 B 30473 1860 MEADOWVALE RD APT 4 1ERUE 157.60 B 30712 1179 SCHOOL ST APT 1 1ERUE 149.96 B 31608 633 MAIN ST APT 320 1ERUE 87.73 B 32578 12950 MEADOWVALE RD 1ERUE 209.85 B 467 11847 190TH AVE 1ERUE 229.94 B 12766 18402 SMITH ST 2ERUW 22.77 B 32578 12950 MEADOWVALE RD 2ERUW 40.61 B 467 11847 190TH AVE 2ERUW 44.74 B 12766 18402 SMITH ST 3CTYS 52.92 125 B 27749 18679 QUEEN CIR 3CTYS 37.80 B 32578 12950 MEADOWVALE RD 3CTYS 24.26 B 467 11847 190TH AVE 3CTYS 28.37 B 12766 18402 SMITH ST 4CTYT 13.08 B 32578 12950 MEADOWVALE RD 4CTYT 0.98 B 467 11847 190TH AVE 4CTYT 23.27 B 12766 18402 SMITH ST 6CTYF 5.87 B 17260 538 TIPTON AVE 6CTYF 11.40 B 20323 340 3RD ST APT 105 6CTYF 11.74 B 30457 379 BALDWIN AVE APT 104 6CTYF 28.29 B 30473 1860 MEADOWVALE RD APT 4 6CTYF 16.74 B 30712 1179 SCHOOL ST APT 1 6CTYF 17.62 B 31608 633 MAIN ST APT 320 6CTYF 17.61 B 32578 12950 MEADOWVALE RD 6CTYF 5.87 B 467 11847 190TH AVE 6CTYF 16.65 B 12766 18402 SMITH ST 7CTYS 6.30 B 27749 18679 QUEEN CIR 7CTYS 3.00 B 32578 12950 MEADOWVALE RD 7CTYS 6.30 B 467 11847 190TH AVE 7CTYS 9.60 Both Collection Agency and Reveue Recapture Total 2,089.58 R 30462 340 3RD ST APT 104 1ERUE 27.99 R 30491 814 PROCTOR AVE APT 1A 1ERUE 121.15 R 29001 13488 182ND AVE 1ERUE 149.85 R 31041 1115 SCHOOL ST APT 26 1ERUE 115.32 R 21968 20943 FRESNO ST 1ERUE 168.07 R 28219 1001 SCHOOL ST APT 202 IERUE 63.06 R 29788 300 JACKSON AVE APT 221 1ERUE 36.36 R 30353 223 2ND ST 1ERUE 452.49 R 30615 847 FREEPORT AVE APT 207 1ERUE 300.99 R 30666 21101OLSON CIR 1ERUE 296.31 R 30739 380 3RD ST APT 301 1ERUE 48.07 R 31513 375 EVANS AVE APT 203 1ERUE 27.71 R 31594 1001 SCHOOL ST APT 105 1ERUE 393.90 R 32986 10180 PARRISH AVE NE TRAILER H 1ERUE 84.01 R 33387 380 3RD ST APT 202 1ERUE 704.68 R 18550 385 HOLT AVE APT 207 1ERUE 60.89 R 23770 12968 196TH LN 1ERUE 230.95 R 33175 633 MAIN ST APT 312 1ERUE 314.58 R 29001 13488182ND AVE 2ERUW 50.30 R 23770 12968 196TH LN 2ERUW 52.71 R 24787 18594 TYLER ST 3CTYS 39.84 R 29001 13488 182ND AVE 3CTYS 90.30 R 23770 12968 196TH LN 3CTYS 204.12 R 29001 13488 182ND AVE 4CTYT 48.32 R 21968 20943 FRESNO ST 4CTYT 22.15 126 R 30666 21101 OLSON CIR 4CTYT 0.68 R 23770 12968 196TH LN 4CTYT 71.15 R 30462 340 3RD ST APT 104 6CTYF 7.35 R 24787 18594 TYLER ST 6CTYF 11.76 R 30491 814 PROCTOR AVE APT 1A 6CTYF 28.64 R 29001 13488 182ND AVE 6CTYF 23.67 R 31041 1115 SCHOOL ST APT 26 6CTYF 16.90 R 21968 20943 FRESNO ST 6CTYF 5.87 R 28219 1001 SCHOOL ST APT 202 6CTYF 17.61 R 29788 300 JACKSON AVE APT 221 6CTYF 17.61 R 30353 223 2ND ST 6CTYF 29.71 R 30615 847 FREEPORT AVE APT 207 6CTYF 34.88 R 30666 21101 OLSON CIR 6CTYF 5.87 R 30739 380 3RD ST APT 301 6CTYF 17.08 R 31513 375 EVANS AVE APT 203 6CTYF 6.41 R 31594 1001 SCHOOL ST APT 105 6CTYF 26.51 R 33387 380 3RD ST APT 202 6CTYF 23.69 R 18550 385 HOLT AVE APT 207 6CTYF 16.55 R 23770 12968 196TH LN 6CTYF 23.48 R 33175 633 MAIN ST APT 312 6CTYF 23.14 R 24787 18594 TYLER ST 7CTYS 6.60 R 29001 13488 182ND AVE 7CTYS 12.90 R 21968 20943 FRESNO ST 7CTYS 4.20 R 30666 21101 OLSON CIR 7CTYS 4.20 R 23770 12968 196TH LN 7CTYS 16.20 Revenue Recapture Total 4,556.78 8,206.44 Total A Collection Agency 1,560.08 B Both Collection Agency and Reveue Recapture 2,089.58 R Revenue Recapture 4,556.78 8,206.44 Total 127 co N I