Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.2h EMRUSR 07-09-2024
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 Water MAY YTD BUDGET BUDGET Bud Var% MAY 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 TRANSFER IN FROM CITY MISCELLANEOUS REVENUE HYDRANT MAINTENANCE PROGR CONTRIBUTIONS FROM DEVELOP WATER TOWER LEASE Total For Misc Revenue: Total Other Revenue Total For Total Other Revenue: 2023 YTD 2023 v. 2024 YTD VARIANCE Actual Var% 114,421 475,575 406,843 1,595,403 17 92,060 441,747 33,827 8 69,683 286,068 239,107 923,908 20 49,608 258,530 27,538 11 9,759 17,846 10,710 268,691 67 16,504 23,094 (5,247) (23) 193,865 779,491 656,660 2,788,003 19 158,172 723,372 56,118 8 193,865 779,491 656,660 2,788,003 19 158,172 723,372 56,118 8 193,865 779,491 656,660 2,788,003 19 158,172 723,372 56,118 8 6,875 25,921 16,666 40,000 56 1,090 14,102 11,818 84 0 0 625 1,500 (100) 0 0 0 0 6,875 25,921 17,291 41,500 50 1,090 14,102 11,818 84 2,254 8,792 10,416 25,000 (16) 1,188 6,148 2,644 43 2,254 8,792 10,416 25,000 (16) 1,188 6,148 2,644 43 10,800 165,830 83,333 200,000 99 31,835 83,135 82,694 99 855 10,193 12,500 30,000 (18) 703 4,438 5,754 130 84 10,936 10,416 25,000 5 0 6,341 4,595 72 11,740 186,960 106,250 255,000 76 32,539 93,916 93,044 99 0 20 20 50 (5) 0 20 0 0 0 0 0 230,000 0 0 0 0 0 0 0 208 500 (100) 0 258 (258) (100) 975 5,700 6,250 15,000 (9) 975 5,781 (80) (1) 0 0 0 65,000 0 0 0 0 0 0 0 0 308,236 0 0 0 0 0 975 5,720 6,479 618,786 (12) 975 6,059 (338) (6) 21,844 227,394 140,437 940,286 62 35,792 120,226 107,168 89 21,844 227,394 140,437 940,286 62 35,792 120,226 107,168 89 160 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% Total Revenue 215,710 1,006,886 797,098 3,728,289 26 193,965 843,599 163,286 19 Expenses Production Expense MTCE OF STRUCTURES 14,015 56,844 47,916 115,000 19 11,254 48,407 8,437 17 Total For Production Expense: 14,015 56,844 47,916 115,000 19 11,254 48,407 8,437 17 Pumping Expense SUPERVISION 5,968 28,982 28,125 67,500 3 5,888 26,888 2,094 8 ELECTRIC & GAS UTILITIES 22,843 97,285 139,654 335,171 (30) 36,778 123,251 (25,966) (21) SAMPLING 1,279 7,068 7,083 17,000 0 674 6,677 390 6 CHEMICAL FEED 3,924 13,096 22,083 53,000 (41) 6,815 12,846 250 2 MTCE OF WELLS 11,369 65,859 68,750 165,000 (4) 6,631 63,099 2,759 4 SCADA - PUMPING (12,162) 3,978 3,333 8,000 19 332 1,436 2,541 177 Total For Pumping Expense: 33,222 216,271 269,029 645,671 (20) 57,122 234,200 (17,929) (8) Distribution Expense MTCE OF WATER MAINS 16,885 33,281 72,916 175,000 (54) 19,878 75,569 (42,287) (56) LOCATE WATER LINES 1,260 5,493 7,187 17,250 (24) 1,269 2,459 3,034 123 MTCE OF WATER SERVICES 0 0 208 500 (100) 0 184 (184) (100) WATER METER SERVICE 4,341 18,912 27,500 66,000 (31) 953 8,147 10,764 132 BACKFLOW DEVICE INSPECTION 1,372 6,895 7,522 20,000 (8) 1,724 7,425 (529) (7) MTCE OF CUSTOMERS SERVICE 2,574 13,422 13,750 33,000 (2) 2,505 12,383 1,038 8 WATER MAPPING 1,891 11,026 6,250 15,000 76 1,156 7,900 3,126 40 MTCE OF WATER HYDRANTS -PU 2,257 14,699 9,333 20,000 76 2,113 4,570 10,128 222 MTCE OF WATER HYDRANTS - PR 888 1,552 2,500 6,000 (38) 99 26 1,525 5,652 WATER CLOTHING/PPE 4,274 8,640 4,166 10,000 107 28 7,283 1,357 19 WAGES WATER 555 3,274 3,125 7,500 5 622 3,005 269 9 TRANSPORTATION EXPENSE 1,146 7,510 10,000 24,000 (25) 1,530 5,815 1,695 29 WATER PERMIT 0 26,255 28,000 28,000 (6) 0 15,752 10,502 67 Total For Distribution Expense: 37,449 150,966 191,459 422,250 (21) 31,883 150,525 440 0 Depreciation & Amortization DEPRECIATION 100,650 503,890 478,750 1,148,987 5 97,652 487,424 16,465 3 Total For Depreciation & Amortization: 100,650 503,890 478,750 1,148,987 5 97,652 487,424 16,465 3 Interest Expense INTEREST EXPENSE - BONDS 3,466 17,333 17,333 40,600 0 3,666 19,333 (999) (5) AMORTIZATION OF DEBT DTSCOU (554) (2,771) (2,771) (6,651) 0 (554) (2,771) 0 0 Total For Interest Expense: 2,912 14,562 14,562 33,949 0 3,112 15,562 (999) (6) 161 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% Other Operating Expense LOSS ON DISPOSITION OF PROP (C 0 0 0 14,000 0 0 0 0 0 DAM MAINTENANCE EXPENSE 19 19 833 2,000 (98) 147 1,689 (1,669) (99) PENSION EXPENSE 0 0 0 65,000 0 0 0 0 0 OTHER INTEREST EXPENSE 0 0 0 0 0 0 94 (94) (100) INTEREST EXPENSE - METER DEP 60 543 541 1,300 0 104 524 19 4 Total For Other Operating Expense: 79 563 1,375 82,300 (59) 252 2,307 (1,744) (76) Customer Accounts Expense METER READING EXPENSE 581 1,234 1,041 2,500 19 209 855 379 44 MISC CUSTOMER ACCOUNTS EXP 8,026 36,717 37,083 89,000 (1) 6,924 35,867 850 2 BAD DEBT EXPENSE & RECOVER 0 0 104 250 (100) 0 0 0 0 Total For Customer Accounts Expense: 8,608 37,952 38,229 91,750 (1) 7,134 36,722 1,229 3 Administrative Expense SALARIES OFFICE & COMMISSION 22,194 109,418 118,750 285,000 (8) 20,387 97,464 11,953 12 TEMPORARY STAFFING 0 0 416 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,282 7,310 15,416 37,000 (53) 5,122 12,868 (5,558) (43) ELECTRIC & WATER CONSUMPTI 569 2,646 4,583 11,000 (42) 730 2,964 (318) (11) BANK FEES 62 284 250 600 14 39 193 90 47 LEGAL FEES 244 1,179 3,750 9,000 (69) 640 2,122 (942) (44) AUDITING FEES 410 2,396 2,500 6,000 (4) 405 2,915 (419) (15) INSURANCE 3,460 17,381 17,916 43,000 (3) 13,667 27,473 (10,092) (37) UTILITY SHARE - DEFERRED COM 1,775 11,285 8,750 21,000 29 1,756 11,985 (699) (6) UTILITY SHARE - MEDICAL/DENT 14,704 98,764 105,454 220,000 (6) 14,952 105,252 (6,488) (6) UTILITY SHARE - PERA 6,222 25,191 23,333 56,000 8 4,582 23,001 2,189 10 UTILITY SHARE - FICA 6,216 24,569 22,500 54,000 9 4,459 22,046 2,523 11 EMPLOYEE SICK PAY 1,873 10,856 12,083 29,000 (10) 1,399 13,126 (2,270) (17) EMPLOYEE HOLIDAY PAY 2,875 10,277 11,636 32,000 (12) 2,528 9,604 672 7 EMPLOYEE VACATION & PTO PA 3,941 27,050 24,000 52,000 13 3,071 23,223 3,827 16 UPMIC DISTRIBUTION 0 5,834 5,250 21,000 11 0 3,632 2,202 61 WELLHEAD PROTECTION 0 0 850 2,000 (100) 0 6,861 (6,861) (100) LONGEVITY PAY 420 420 420 837 0 0 101 318 316 CONSULTING FEES 1,314 7,996 19,125 45,900 (58) 273 5,883 2,112 36 TELEPHONE 649 3,425 3,750 9,000 (9) 685 3,620 (194) (5) ADVERTISING 404 1,726 2,083 5,000 (17) 563 2,266 (540) (24) DUES & SUBSCRIPTIONS - FEES 19,086 40,031 41,600 88,114 (4) 15,053 34,571 5,459 16 162 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% SCHOOLS & MEETINGS 1,672 15,036 26,675 61,072 (44) 955 11,851 3,185 27 MTCE OF GENERAL PLANT & OFFI 211 1,055 1,291 3,100 (18) 250 1,253 (198) (16) Total For Administrative Expense: 89,593 424,138 472,385 1,092,623 (10) 91,526 424,186 (47) 0 General Expense CIP REBATES - RESIDENTIAL 50 75 2,083 5,000 (96) 175 502 (427) (85) CIP REBATES - COMMERCIAL 0 0 208 500 (100) 0 0 0 0 CIP - MARKETING 212 941 833 2,000 13 0 588 353 60 CIP - LABOR 0 0 2,083 5,000 (100) 0 1,288 (1,288) (100) ENVIRONMENTAL COMPLIANCE 60 280 1,041 2,500 (73) 57 1,013 (733) (72) MISC GENERAL EXPENSE 0 0 104 250 (100) 0 (4) 4 100 Total For General Expense: 323 1,296 6,354 15,250 (80) 232 3,389 (2,092) (62) Total Expenses(before Operating Transfers) 286,855 1,406,484 1,520,062 3,647,781 (7) 300,169 1,402,726 3,758 0 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 0 625 1,500 (100) 0 0 0 0 Total Operating Transfer Total For Total Operating Transfer: 0 0 625 1,500 (100) 0 0 0 0 Net Income Profit(Loss) (71,145) (399,598) (723,588) 79,007 45 (106,203) (559,126) 159,528 29 163