Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 01-10-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 Water NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER Revenue Operating Revenue Water Sales WATER SALES RESIDENTIAL WATER SALES COMMERCIAL WATER SALES IRRIGATION Total For Water Sales: Total Operating Revenue Total For Total Operating Revenue: Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME OTHER INTEREST/MISC REVENUE Total For Interest/Dividend Income: Customer Penalties CUSTOMER PENALTIES Total For Customer Penalties: Connection Fees WATER/ACCESS/CONNECTION FE CUSTOMER CONNECTION FEES BULK WATER SALES/HYDRANT R Total For Connection Fees: Misc Revenue MISC NON -UTILITY MISCELLANEOUS REVENUE HYDRANT MAINTENANCE PROGR CONTRIBUTIONS FROM DEVELOP WATER TOWER LEASE Total For Misc Revenue: Total Other Revenue Total For Total Other Revenue: 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 92,883 1,567,257 1,287,663 1,359,866 22 88,687 1,674,822 (107,565) (6) 61,292 870,704 802,116 842,024 9 58,540 874,913 (4,209) 0 12,058 299,157 241,717 243,025 24 8,281 357,539 (58,381) (16) 166,234 2,737,119 2,331,497 2,444,916 17 155,509 2,907,275 (170,156) (6) 166,234 2,737,119 2,331,497 2,444,916 17 155,509 2,907,275 (170,156) (6) 166,234 2,737,119 2,331,497 2,444,916 17 155,509 2,907,275 (170,156) (6) 1,937 (39,577) 32,083 35,000 (223) 1,094 23,805 (63,383) (266) 0 592 916 1,000 (35) 0 681 (88) (13) 1,937 (38,984) 33,000 36,000 (218) 1,094 24,487 (63,471) (259) 2,623 25,171 16,360 18,000 54 0 0 25,171 0 2,623 25,171 16,360 18,000 54 0 0 25,171 0 236,208 1,533,529 394,166 430,000 289 38,852 513,627 1,019,902 199 3,542 56,283 32,083 35,000 75 3,092 39,897 16,385 41 341 14,754 13,750 15,000 7 6,355 16,787 (2,033) (12) 240,092 1,604,567 440,000 480,000 265 48,300 570,312 1,034,254 181 0 110 0 0 0 0 31 79 255 732 1,019 0 0 0 258 1,141 (121) (11) 975 12,229 11,916 13,000 3 975 10,755 1,474 14 0 0 59,583 65,000 (100) 0 0 0 0 24,248 261,904 261,901 286,153 0 23,364 252,362 9,542 4 25,955 275,264 333,401 364,153 (17) 24,598 264,290 10,974 4 270,608 1,866,018 822,761 898,153 127 73,992 859,090 1,006,928 117 270,608 1,866,018 822,761 898,153 127 73,992 859,090 1,006,928 117 Total Revenue 436,842 4,603,138 3,154,259 3,343,069 46 229,502 3,766,365 836,772 22 83 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% Expenses Production Expense MTCE OF STRUCTURES 8,119 97,564 68,750 75,000 42 5,737 166,824 (69,259) (42) Total For Production Expense: 8,119 97,564 68,750 75,000 42 5,737 166,824 (69,259) (42) Pumping Expense SUPERVISION 5,875 59,993 60,500 66,000 (1) 4,650 52,210 7,782 15 ELECTRIC & GAS UTILITIES 23,013 260,919 247,500 270,000 5 19,393 244,173 16,745 7 SAMPLING 799 12,485 13,750 15,000 (9) 1,083 12,370 114 1 CHEMICAL FEED (4,305) 29,198 33,000 36,000 (12) 1,434 34,042 (4,844) (14) MTCE OF ELECTRIC PUMPING EQ 0 46 0 0 0 0 161 (115) (71) MTCE OF WELLS 7,799 140,055 146,666 160,000 (5) 7,987 113,662 26,392 23 SCADA - PUMPING 3,908 13,232 14,666 16,000 (10) 185 4,944 8,287 168 Total For Pumping Expense: 37,089 515,929 516,083 563,000 0 34,734 461,566 54,363 12 Distribution Expense MTCE OF WATER MAINS 4,965 78,347 110,000 120,000 (29) 8,161 100,819 (22,472) (22) LOCATE WATER LINES 516 10,895 15,583 17,000 (30) 1,020 15,417 (4,522) (29) MTCE OF WATER SERVICES 0 897 0 0 0 32 32 865 2,706 WATER METER SERVICE 5,761 69,816 50,416 55,000 38 4,545 56,098 13,718 24 BACKFLOW DEVICE INSPECTION 0 10,765 14,200 15,000 (24) 889 8,165 2,599 32 MTCE OF CUSTOMERS SERVICE 2,321 25,913 27,958 30,500 (7) 2,209 25,857 55 0 WATER MAPPING 1,262 10,581 11,458 12,500 (8) 720 8,335 2,246 27 MTCE OF WATER HYDRANTS - PU 1,535 17,882 16,500 18,000 8 1,087 12,792 5,090 40 MTCE OF WATER HYDRANTS - PR 333 4,454 4,583 5,000 (3) 1,957 5,093 (639) (13) WATER CLOTHING/PPE 73 7,587 6,416 7,000 18 1,239 13,266 (5,678) (43) WAGES WATER 1,082 8,259 8,708 9,500 (5) 467 5,698 2,561 45 TRANSPORTATION EXPENSE 739 14,595 13,750 15,000 6 980 9,761 4,834 50 WATER PERMIT 0 18,370 18,600 18,600 (1) 0 14,875 3,494 23 Total For Distribution Expense: 18,590 278,366 298,175 323,100 (7) 23,311 276,213 2,153 1 Depreciation & Amortization DEPRECIATION 91,956 1,013,078 1,070,478 1,199,123 (5) 91,950 1,047,425 (34,346) (3) Total For Depreciation & Amortization: 91,956 1,013,078 1,070,478 1,199,123 (5) 91,950 1,047,425 (34,346) (3) Interest Expense INTEREST EXPENSE - BONDS 3,666 42,704 42,704 46,371 0 5,037 31,258 11,445 37 INTEREST EXPENSE - DEFEASED 0 0 0 0 0 0 (69) 69 100 AMORTIZATION OF DEBT DISCOU (554) (6,096) (6,096) (6,651) 0 (554) (2,771) (3,325) (120) 84 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% Total For Interest Expense: 3,112 36,607 36,607 39,720 0 4,483 28,418 8,189 29 Other Operating Expense DAM MAINTENANCE EXPENSE 53 1,483 1,604 1,750 (7) 17 (393) 1,877 477 OPEB EXPENSE 0 0 0 0 0 0 (44,525) 44,525 100 OTHER INTEREST EXPENSE 94 1,127 0 0 0 182 (427) 1,554 364 INTEREST EXPENSE - METER DEP 4 48 91 100 (47) 2 24 24 104 Total For Other Operating Expense: 152 2,659 1,695 1,850 57 202 (45,322) 47,982 106 Customer Accounts Expense METER READING EXPENSE 164 2,194 2,291 2,500 (4) 213 2,151 43 2 MISC CUSTOMER ACCOUNTS EXP 6,809 72,211 65,266 71,200 11 5,873 64,126 8,085 13 BAD DEBT EXPENSE & RECOVER 0 28 458 500 (94) 0 0 28 0 Total For Customer Accounts Expense: 6,974 74,433 68,016 74,200 9 6,087 66,277 8,156 12 Administrative Expense SALARIES OFFICE & COMMISSION 19,595 214,857 215,416 235,000 0 17,995 212,036 2,820 1 SALARIES COVID-19 0 0 0 0 0 0 1,791 (1,791) (100) TEMPORARY STAFFING 0 0 916 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,528 13,540 21,725 23,700 (38) 1,281 23,162 (9,621) (42) ELECTRIC & WATER CONSUMPTI 997 6,440 7,333 8,000 (12) 432 5,695 745 13 BANK FEES 74 484 641 700 (24) 44 527 (42) (8) LEGAL FEES 250 6,225 7,333 8,000 (15) 379 4,680 1,544 33 AUDITING FEES 375 4,134 4,134 4,510 0 353 3,886 247 6 INSURANCE 2,934 30,696 24,750 27,000 24 2,217 23,508 7,188 31 UTILITY SHARE - DEFERRED COM 825 18,638 25,666 28,000 (27) 1,141 16,680 1,958 12 UTILITY SHARE - MEDICAL/DENT 16,568 206,206 201,015 217,000 3 13,893 175,798 30,407 17 UTILITY SHARE- PERA 4,611 49,149 46,750 51,000 5 4,320 45,123 4,025 9 UTILITY SHARE - FICA 4,368 47,218 44,916 49,000 5 4,055 43,246 3,971 9 EMPLOYEE SICK PAY 2,211 23,817 27,500 30,000 (13) 2,507 22,865 951 4 EMPLOYEE HOLIDAY PAY 7,717 19,672 22,909 28,000 (14) 7,113 21,422 (1,749) (8) EMPLOYEE VACATION & PTO PA 3,988 42,603 38,000 41,000 12 3,468 38,436 4,167 11 UPMIC DISTRIBUTION 0 9,904 8,250 11,000 20 0 8,010 1,893 24 WELLHEAD PROTECTION 0 4,724 20,000 20,000 (76) 462 2,350 2,373 101 LONGEVITY PAY 0 310 0 0 0 0 0 310 0 CONSULTING FEES 0 19,882 18,333 20,000 8 6,914 26,213 (6,331) (24) BOND ISSUANCE COSTS 0 0 0 0 0 3 3 (3) (100) TELEPHONE 782 8,009 6,233 6,800 29 695 6,688 1,321 20 85 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% ADVERTISING 138 2,831 4,583 5,000 (38) 296 3,646 (815) (22) DUES & SUBSCRIPTIONS - FEES 16,055 73,977 71,515 73,615 3 14,578 105,009 (31,031) (30) SCHOOLS & MEETINGS 5,212 39,727 50,440 55,025 (21) 1,451 24,311 15,415 63 MTCE OF GENERAL PLANT & OFFI 152 1,676 1,741 1,900 (4) 149 1,640 35 2 Total For Administrative Expense: 88,389 844,729 870,105 945,251 (3) 83,758 816,737 27,991 3 General Expense CIP REBATES - RESIDENTIAL 0 834 4,125 4,500 (80) 350 5,214 (4,380) (84) CIP REBATES - COMMERCIAL 0 0 458 500 (100) 0 0 0 0 CIP - MARKETING 0 613 458 500 34 0 121 491 402 CIP - LABOR 375 4,136 4,308 4,700 (4) 350 4,065 71 2 ENVIRONMENTAL COMPLIANCE 46 1,528 2,016 2,200 (24) 46 903 624 69 MISC GENERAL EXPENSE 0 0 229 250 (100) 0 809 (809) (100) Total For General Expense: 422 7,113 11,595 12,650 (39) 746 11,115 (4,002) (36) Total Expenses(before Operating Transfers) 254,808 2,870,483 2,941,507 3,233,895 (2) 251,012 2,829,255 41,228 1 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 539 1,375 1,500 (61) 0 1,258 (719) (57) Total Operating Transfer Total For Total Operating Transfer: 0 539 1,375 1,500 (61) 0 1,258 (719) (57) Net Income Profit(Loss) 182,034 1,732,114 211,376 107,673 719 796,263 85 (21,510) 935,851