Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 04-11-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 Water FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY 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: Total Revenue 2022 YTD 2022 v. 2023 YTD VARIANCE Actual Var% 94,370 180,035 138,172 1,397,043 30 81,915 164,223 15,811 10 58,377 105,515 82,598 850,022 28 44,806 89,992 15,522 17 1,597 3,161 2,618 256,349 21 1,566 3,071 89 3 154,345 288,711 223,388 2,503,414 29 128,288 257,287 31,424 12 154,345 288,711 223,388 2,503,414 29 128,288 257,287 31,424 12 154,345 288,711 223,388 2,503,414 29 128,288 257,287 31,424 12 798 4,125 5,833 35,000 (29) (5,598) (9,390) 13,515 144 0 0 250 1,500 (100) 0 0 0 0 798 4,125 6,083 36,500 (32) (5,598) (9,390) 13,515 144 1,025 2,774 4,666 28,000 (41) 942 942 1,831 194 1,025 2,774 4,666 28,000 (41) 942 942 1,831 194 3,600 14,400 75,000 450,000 (81) 65,821 90,477 (76,077) (84) 322 1,288 6,666 40,000 (81) 5,958 8,533 (7,244) (85) 8,844 8,844 4,666 28,000 90 0 89 8,755 9,728 12,766 24,532 86,333 518,000 (72) 71,779 99,099 (74,566) (75) 0 0 8 50 (100) 0 0 0 0 258 258 83 500 212 0 0 258 0 1,881 2,856 2,250 13,500 27 1,316 2,294 561 24 0 0 0 65,000 0 0 0 0 0 0 0 0 296,984 0 23,481 46,963 (46,963) (100) 2,140 3,115 2,341 376,034 33 24,798 49,258 (46,143) (94) 16,731 34,547 99,425 958,534 (65) 91,922 139,910 (105,362) (75) 16,731 34,547 99,425 958,534 (65) 91,922 139,910 (105,362) (75) 171,077 323,258 322,813 3,461,948 0 220,210 397,197 (73,938) (19) 176 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% Expenses Production Expense MTCE OF STRUCTURES 9,134 19,733 15,000 90,000 32 8,925 16,928 2,804 17 Total For Production Expense: 9,134 19,733 15,000 90,000 32 8,925 16,928 2,804 17 Pumping Expense SUPERVISION 5,238 10,849 11,500 69,000 (6) 4,823 9,801 1,047 11 ELECTRIC & GAS UTILITIES 20,673 44,952 48,000 288,000 (6) 19,977 40,029 4,923 12 SAMPLING 888 2,544 2,500 15,000 2 941 1,628 915 56 CHEMICAL FEED 982 3,423 8,333 50,000 (59) 2,595 3,072 350 11 MTCE OF ELECTRIC PUMPING EQ 0 0 0 0 0 96 96 (96) (100) MTCE OF WELLS 18,334 31,352 27,500 165,000 14 25,345 39,455 (8,103) (21) SCADA - PUMPING 277 568 2,666 16,000 (79) 3,248 3,448 (2,880) (84) Total For Pumping Expense: 46,394 93,691 100,500 603,000 (7) 57,026 97,533 (3,841) (4) Distribution Expense MTCE OF WATER MAINS 3,969 24,673 20,000 120,000 23 2,756 4,757 19,915 419 LOCATE WATER LINES 85 171 2,875 17,250 (94) 157 191 (20) (10) MTCE OF WATER SERVICES 147 147 0 0 0 40 40 107 270 WATER METER SERVICE 725 1,737 11,000 66,000 (84) 7,149 11,584 (9,846) (85) BACKFLOW DEVICE INSPECTION 1,157 3,294 1,800 16,000 83 889 1,802 1,491 83 MTCE OF CUSTOMERS SERVICE 2,565 5,017 5,083 30,500 (1) 2,051 4,468 548 12 WATER MAPPING 1,135 1,578 2,083 12,500 (24) 0 171 1,406 823 MTCE OF WATER HYDRANTS - PU 29 992 3,166 19,000 (69) 385 931 60 6 MTCE OF WATER HYDRANTS - PR (313) (73) 833 5,000 (109) 0 254 (327) (129) WATER CLOTHING/PPE 0 31 1,500 9,000 (98) 566 598 (567) (95) WAGES WATER 576 1,198 1,216 7,300 (1) 486 971 227 23 TRANSPORTATION EXPENSE 306 1,364 2,750 16,500 (50) 549 1,626 (262) (16) WATER PERMIT 0 15,407 18,600 18,600 (17) 18,025 18,025 (2,617) (15) Total For Distribution Expense: 10,385 55,542 70,908 337,650 (22) 33,058 45,424 10,117 22 Depreciation & Amortization DEPRECIATION 97,379 194,747 194,796 1,202,937 0 92,795 185,293 9,454 5 Total For Depreciation & Amortization: 97,379 194,747 194,796 1,202,937 0 92,795 185,293 9,454 5 Interest Expense INTEREST EXPENSE - BONDS 3,666 7,333 7,333 43,000 0 3,833 8,871 (1,537) (17) AMORTIZATION OF DEBT DISCOU (554) (1,108) (1,108) (6,651) 0 (554) (1,108) 0 0 Total For Interest Expense: 3,112 6,224 6,224 36,349 0 3,279 7,762 (1,537) (20) Other Operating Expense 177 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% LOSS ON DISPOSITION OF PROP (C 0 0 0 500 0 0 0 0 0 DAM MAINTENANCE EXPENSE 0 55 291 1,750 (81) 0 0 55 0 OTHER INTEREST EXPENSE 0 94 95 95 0 94 277 (182) (66) INTEREST EXPENSE - METER DEP 104 209 20 125 900 4 8 200 2,233 Total For Other Operating Expense: 104 359 407 2,470 (12) 98 285 73 26 Customer Accounts Expense METER READING EXPENSE 159 307 416 2,500 (26) 135 324 (16) (5) MISC CUSTOMER ACCOUNTS EXP 6,810 13,999 13,603 81,620 3 6,007 11,841 2,158 18 BAD DEBT EXPENSE & RECOVER 0 0 41 250 (100) 0 0 0 0 Total For Customer Accounts Expense: 6,970 14,306 14,061 84,370 2 6,143 12,165 2,141 18 Administrative Expense SALARIES OFFICE & COMMISSION 17,944 37,441 44,750 268,500 (16) 17,788 34,861 2,579 7 TEMPORARY STAFFING 0 0 166 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,789 3,589 4,250 25,500 (16) 1,068 2,025 1,563 77 ELECTRIC & WATER CONSUMPTI 975 2,120 1,333 8,000 59 446 894 1,226 137 BANK FEES 51 86 104 625 (17) 57 101 (15) (16) LEGAL FEES 325 915 1,500 9,000 (39) 674 1,106 (190) (17) AUDITING FEES 405 811 771 4,630 5 375 751 60 8 INSURANCE 3,016 6,032 6,000 36,000 1 2,217 4,435 1,596 36 UTILITY SHARE - DEFERRED COM 2,179 5,060 5,083 30,500 0 2,218 4,911 148 3 UTILITY SHARE - MEDICAL/DENT 13,678 59,752 73,181 215,000 (18) 15,596 59,364 387 1 UTILITY SHARE - PERA 4,078 8,604 9,000 54,000 (4) 3,846 7,742 861 11 UTILITY SHARE - FICA 3,860 8,189 8,666 52,000 (6) 3,649 7,359 829 11 EMPLOYEE SICK PAY 2,015 6,859 4,500 27,000 52 2,024 4,558 2,300 50 EMPLOYEE HOLIDAY PAY 2,841 7,076 8,400 30,800 (16) 2,483 4,301 2,774 64 EMPLOYEE VACATION & PTO PA 3,403 12,472 11,272 44,000 11 3,110 10,618 1,854 17 UPMIC DISTRIBUTION 0 0 0 18,069 0 0 0 0 0 WELLHEAD PROTECTION 0 0 0 10,000 0 514 2,764 (2,764) (100) LONGEVITY PAY 0 0 0 3,106 0 0 0 0 0 CONSULTING FEES 4,070 4,070 5,833 35,000 (30) 2,533 4,214 (144) (3) TELEPHONE 633 1,429 1,583 9,500 (10) 679 1,372 56 4 ADVERTISING 318 638 1,083 6,500 (41) 170 468 169 36 DUES & SUBSCRIPTIONS - FEES 15,747 17,029 18,000 78,320 (5) 15,292 16,889 139 1 SCHOOLS & MEETINGS 3,546 5,301 10,617 63,705 (50) 2,362 4,772 528 11 MTCE OF GENERAL PLANT & OFFI 250 501 316 1,900 58 152 304 196 64 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% Total For Administrative Expense: 81,131 187,981 216,414 1,032,655 (13) 77,262 173,821 14,159 8 General Expense CIP REBATES - RESIDENTIAL 0 45 1,750 10,500 (97) 0 110 (65) (59) CIP REBATES - COMMERCIAL 0 0 83 500 (100) 0 0 0 0 CIP - MARKETING 588 588 83 500 608 0 0 588 0 CIP - LABOR 388 797 783 4,700 2 346 687 110 16 ENVIRONMENTAL COMPLIANCE 51 105 366 2,200 (71) 48 98 7 8 MISC GENERAL EXPENSE 0 (2) 41 250 (107) 0 0 (2) 0 Total For General Expense: 1,027 1,533 3,108 18,650 (51) 394 895 638 71 Total Expenses(before Operating Transfers) 255,641 574,121 621,421 3,408,081 (8) 278,984 540,111 34,010 6 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 0 250 1,500 (100) 0 0 0 0 Total Operating Transfer Total For Total Operating Transfer: 0 0 250 1,500 (100) 0 0 0 0 Net Income Profit(Loss) (84,564) (250,862) (298,857) 52,367 16 (58,774) (142,914) (107,948) (76) 179