Loading...
5.1h ERMUSR 08-09-2022ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETWater Revenue Operating Revenue Water Sales WATER SALES RESIDENTIAL 184,887 627,331175,581 531,879599,011 13 (5)1,359,866 (28,319) WATER SALES COMMERCIAL 78,402 309,66488,842 319,894328,518 3 6842,024 18,853 WATER SALES IRRIGATION 45,374 79,07124,148 43,37336,135 (17)(54)243,025 (42,936) 288,571 963,665 895,147 308,664 1,016,0688 (5)Total For Water Sales:2,444,916 (52,402) Total Operating Revenue 308,664 1,016,068288,571 895,147963,665 8 (5)2,444,916 (52,402) 288,571 963,665 895,147 308,664 1,016,0688 (5)Total For Total Operating Revenue:2,444,916 (52,402) Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME 3,187 12,240(3,391)17,500(30,388)(274)(348)35,000 (42,629) OTHER INTEREST/MISC REVENUE 0 004990(100)01,000 0 (3,391)(30,388)18,000 3,187 12,240(269)(348)Total For Interest/Dividend Income:36,000 (42,629) Customer Penalties CUSTOMER PENALTIES 0 01,019 8,1805,009 (39)018,000 5,009 1,019 5,009 8,180 0 0(39)0Total For Customer Penalties:18,000 5,009 Connection Fees WATER/ACCESS/CONNECTION FE 49,100 287,636135,990 214,999770,356 258 168430,000 482,719 CUSTOMER CONNECTION FEES 3,885 17,8119,142 17,50034,532 97 9435,000 16,720 BULK WATER SALES/HYDRANT R 2,665 3,1391147,5001,736 (77)(45)15,000 (1,402) 145,246 806,625 240,000 55,650 308,587236 161Total For Connection Fees:480,000 498,037 Misc Revenue MISC NON-UTILITY 0 000250 0025 MISCELLANEOUS REVENUE 0 53328702870 (46)0 (245) HYDRANT MAINTENANCE PROGR 974 5,8809806,4996,214 (4)613,000 333 CONTRIBUTIONS FROM DEVELOP 0 0032,5000 (100)065,000 0 WATER TOWER LEASE 23,061 136,19423,934 141,340141,342 0 4286,153 5,147 25,202 147,869 180,340 24,036 142,609(18)4Total For Misc Revenue:364,153 5,260 Total Other Revenue 82,874 463,437168,078 446,520929,116 108 100898,153 465,678 168,078 929,116 446,520 82,874 463,437108 100Total For Total Other Revenue:898,153 465,678 391,538 1,479,505456,649 1,341,668 Total Revenue 1,892,781 41 283,343,069 413,276 72 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETWater Expenses Production Expense MTCE OF STRUCTURES 6,611 134,6905,882 37,50045,761 22 (66)75,000 (88,929) 5,882 45,761 37,500 6,611 134,69022 (66)Total For Production Expense:75,000 (88,929) Pumping Expense SUPERVISION 5,411 28,7744,951 33,00030,056 (9)466,000 1,281 ELECTRIC & GAS UTILITIES 32,253 135,38428,529 135,000130,857 (3)(3)270,000 (4,526) SAMPLING 887 5,9151,542 7,5007,320 (2)2415,000 1,404 CHEMICAL FEED 5,777 15,3245,301 18,00013,766 (24)(10)36,000 (1,558) MTCE OF ELECTRIC PUMPING EQ 0 3600460 2409 MTCE OF WELLS 9,237 71,338(1,504)79,99990,776 13 27160,000 19,437 SCADA - PUMPING 1,540 3,0902597,9994,798 (40)5516,000 1,708 39,079 277,621 281,499 55,108 259,864(1)7Total For Pumping Expense:563,000 17,756 Distribution Expense MTCE OF WATER MAINS 8,393 40,4056,039 60,00030,288 (50)(25)120,000 (10,116) LOCATE WATER LINES 1,420 8,0121,270 8,5004,441 (48)(45)17,000 (3,570) MTCE OF WATER SERVICES 0 024903260 00326 WATER METER SERVICE 10,617 23,8159,952 27,49947,203 72 9855,000 23,387 BACKFLOW DEVICE INSPECTION 843 4,2341,876 6,6006,804 3 6115,000 2,569 MTCE OF CUSTOMERS SERVICE 2,297 13,6232,319 15,25013,693 (10)130,500 70 WATER MAPPING 3,600 6,5065146,2502,045 (67)(69)12,500 (4,460) MTCE OF WATER HYDRANTS - PU 4,194 6,5924,047 9,0007,224 (20)1018,000 632 MTCE OF WATER HYDRANTS - PR 32 326862,500988 (60)2,9885,000 956 WATER CLOTHING/PPE 1,089 9,5783063,4995,315 52 (45)7,000 (4,263) WAGES WATER 581 3,2216004,7503,058 (36)(5)9,500 (163) TRANSPORTATION EXPENSE 1,157 5,0071,390 7,5007,171 (4)4315,000 2,164 WATER PERMIT 0 14,875018,60018,370 (1)2318,600 3,494 29,254 146,933 169,950 34,228 135,906(14)8Total For Distribution Expense:323,100 11,026 Depreciation & Amortization DEPRECIATION 95,319 576,35491,788 566,070553,746 (2)(4)1,199,123 (22,608) 91,788 553,746 566,070 95,319 576,354(2)(4)Total For Depreciation & Amortization:1,199,123 (22,608) Interest Expense INTEREST EXPENSE - BONDS 821 7,2663,833 24,20424,204 0 23346,371 16,938 INTEREST EXPENSE - DEFEASED 0 (345)0 00 0 1000345 AMORTIZATION OF DEBT DISCOU 0 0(554)(3,325)(3,325)0 0(6,651)(3,325) 73 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETWater 3,279 20,879 20,879 821 6,9200 202Total For Interest Expense:39,720 13,958 Other Operating Expense DAM MAINTENANCE EXPENSE 0 (667)53 874964 10 2451,750 1,631 OPEB EXPENSE (44,525)(44,525)0 00 0 100044,525 OTHER INTEREST EXPENSE 0 09406550 00655 INTEREST EXPENSE - METER DEP 2 1344926(46)10810013 152 1,645 924 (44,523)(45,179)78 104Total For Other Operating Expense:1,850 46,825 Customer Accounts Expense METER READING EXPENSE 232 1,1232071,2491,194 (4)62,500 70 MISC CUSTOMER ACCOUNTS EXP 5,778 34,1346,067 35,59936,584 3 771,200 2,449 BAD DEBT EXPENSE & RECOVER 0 002500(100)05000 6,275 37,778 37,099 6,010 35,2572 7Total For Customer Accounts Expense:74,200 2,520 Administrative Expense SALARIES OFFICE & COMMISSION 20,270 116,51220,075 117,499113,193 (4)(3)235,000 (3,318) SALARIES COVID-19 0 1,7910000 (100)0 (1,791) TEMPORARY STAFFING 0 004990(100)01,000 0 OFFICE SUPPLIES 1,046 13,5061,461 11,8507,166 (40)(47)23,700 (6,340) ELECTRIC & WATER CONSUMPTI 553 3,0156374,0002,981 (25)(1)8,000 (33) BANK FEES 62 30732349245(30)(20)700 (62) LEGAL FEES 501 2,7496814,0004,063 2 488,000 1,313 AUDITING FEES 375 2,2503752,2542,254 0 04,510 4 INSURANCE 2,130 12,7804,982 13,50016,071 19 2627,000 3,290 UTILITY SHARE - DEFERRED COM 1,365 9,6611,583 13,99913,835 (1)4328,000 4,173 UTILITY SHARE - MEDICAL/DENT 12,769 103,74517,153 121,090124,325 3 20217,000 20,580 UTILITY SHARE - PERA 4,060 23,8914,386 25,50026,093 2 951,000 2,202 UTILITY SHARE - FICA 3,904 23,0234,213 24,49924,984 2 949,000 1,961 EMPLOYEE SICK PAY 1,626 10,0222,068 15,00012,531 (16)2530,000 2,508 EMPLOYEE HOLIDAY PAY 0 9,415010,1816,851 (33)(27)28,000 (2,563) EMPLOYEE VACATION & PTO PA 5,023 22,3712,895 23,00023,677 3 641,000 1,305 UPMIC DISTRIBUTION 2,992 4,8642,344 5,5004,544 (17)(7)11,000 (319) WELLHEAD PROTECTION 0 0020,0004,724 (76)020,000 4,724 CONSULTING FEES 9,344 19,2994,823 10,00016,924 69 (12)20,000 (2,374) TELEPHONE 692 3,2017273,4004,178 23 316,800 977 ADVERTISING 179 2,1644152,5001,803 (28)(17)5,000 (360) DUES & SUBSCRIPTIONS - FEES 28,150 70,9925,757 36,00040,189 12 (43)73,615 (30,803)74 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETWater SCHOOLS & MEETINGS 732 12,6171,071 27,51219,961 (27)5855,025 7,344 MTCE OF GENERAL PLANT & OFFI 149 894152949914(4)21,900 19 75,840 471,517 493,090 95,929 469,077(4)1Total For Administrative Expense:945,251 2,439 General Expense CIP REBATES - RESIDENTIAL 774 1,6691492,250434 (81)(74)4,500 (1,235) CIP REBATES - COMMERCIAL 0 002500(100)05000 CIP - MARKETING 121 12184250613145 402500491 CIP - LABOR 403 2,2473752,3502,284 (3)24,700 37 ENVIRONMENTAL COMPLIANCE 53 673461,0991,284 17 912,200 610 MISC GENERAL EXPENSE 0 80901240(100)(100)250 (809) 655 4,616 6,325 1,352 5,522(27)(16)Total For General Expense:12,650 (905) Total Expenses(before Operating Transfers) 250,858 1,578,415252,206 1,613,3391,560,499 (3)(1)3,233,895 (17,915) Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO CI 0 9507500(100)(100)1,500 (95) Total Operating Transfer 0 0 750 0 95(100)(100)Total For Total Operating Transfer:1,500 (95) 140,680 (99,005)204,443 (272,420) Net Income Profit(Loss)332,282 222 436107,673 431,287 75