Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 06-04-2024
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 Water APRIL YTD BUDGET BUDGET Bud Var% APRIL 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% 87,310 361,153 323,023 1,595,403 12 84,052 349,687 11,466 3 52,769 216,385 191,975 923,908 13 50,826 208,921 7,463 4 2,977 8,086 5,566 268,691 45 1,834 6,590 1,496 23 143,057 585,625 520,566 2,788,003 12 136,713 565,199 20,426 4 143,057 585,625 520,566 2,788,003 12 136,713 565,199 20,426 4 143,057 585,625 520,566 2,788,003 12 136,713 565,199 20,426 4 1,051 19,046 13,333 40,000 43 4,879 13,012 6,033 46 0 0 500 1,500 (100) 0 0 0 0 1,051 19,046 13,833 41,500 38 4,879 13,012 6,033 46 925 6,537 8,333 25,000 (22) 938 4,960 1,577 32 925 6,537 8,333 25,000 (22) 938 4,960 1,577 32 28,800 155,030 66,666 200,000 133 22,110 51,300 103,730 202 2,487 9,337 10,000 30,000 (7) 1,099 3,735 5,602 150 0 10,852 8,333 25,000 30 (2,734) 6,341 4,511 71 31,287 175,220 85,000 255,000 106 20,475 61,376 113,843 185 0 20 16 50 18 0 20 0 0 0 0 0 230,000 0 0 0 0 0 0 0 166 500 (100) 0 258 (258) (100) 975 4,725 5,000 15,000 (5) 975 4,806 (80) (2) 0 0 0 65,000 0 0 0 0 0 0 0 0 308,236 0 0 0 0 0 975 4,745 5,183 618,786 (8) 975 5,084 (338) (7) 34,239 205,550 112,350 940,286 83 27,268 84,433 121,116 143 34,239 205,550 112,350 940,286 83 27,268 84,433 121,116 143 11 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water APRIL YTD BUDGET BUDGET Bud Var% APRIL YTD VARIANCE Actual Var% Total Revenue 177,297 791,175 632,916 3,728,289 25 163,982 649,633 141,542 22 Expenses Production Expense MTCE OF STRUCTURES 8,553 42,829 38,333 115,000 12 6,274 37,152 5,676 15 Total For Production Expense: 8,553 42,829 38,333 115,000 12 6,274 37,152 5,676 15 Pumping Expense SUPERVISION 6,270 23,014 22,500 67,500 2 5,444 21,000 2,014 10 ELECTRIC & GAS UTILITIES 19,838 74,442 111,723 335,171 (33) 20,497 86,473 (12,030) (14) SAMPLING 2,290 5,788 5,666 17,000 2 2,543 6,003 (214) (4) CHEMICAL FEED 3,465 9,172 17,666 53,000 (48) 790 6,030 3,142 52 MTCE OF WELLS 11,285 54,489 55,000 165,000 (1) 10,405 56,468 (1,978) (4) SCADA - PUMPING 15,286 16,140 2,666 8,000 505 295 1,103 15,037 1,362 Total For Pumping Expense: 58,437 183,048 215,223 645,671 (15) 39,977 177,078 5,970 3 Distribution Expense MTCE OF WATER MAINS 8,738 16,395 58,333 175,000 (72) 13,171 55,691 (39,295) (71) LOCATE WATER LINES 1,241 4,233 5,750 17,250 (26) 492 1,190 3,043 256 MTCE OF WATER SERVICES 0 0 166 500 (100) 0 184 (184) (100) WATER METER SERVICE 3,421 14,570 22,000 66,000 (34) 4,457 7,193 7,377 103 BACKFLOW DEVICE INSPECTION 1,402 5,522 5,044 20,000 9 1,123 5,701 (178) (3) MTCE OF CUSTOMERS SERVICE 2,641 10,847 11,000 33,000 (1) 2,395 9,877 970 10 WATER MAPPING 1,232 9,134 5,000 15,000 83 4,102 6,744 2,390 35 MTCE OF WATER HYDRANTS - PU 1,532 12,442 6,666 20,000 87 1,131 2,457 9,985 406 MTCE OF WATER HYDRANTS - PR 0 663 2,000 6,000 (67) 0 (73) 736 1,010 WATER CLOTHING/PPE 3,788 4,365 3,333 10,000 31 846 7,255 (2,889) (40) WAGES WATER 707 2,718 2,500 7,500 9 498 2,382 336 14 TRANSPORTATION EXPENSE 3,480 6,364 8,000 24,000 (20) 1,780 4,285 2,079 49 WATER PERMIT 0 26,255 28,000 28,000 (6) 0 15,752 10,502 67 Total For Distribution Expense: 28,186 113,516 157,794 422,250 (28) 29,988 118,642 (5,126) (4) Depreciation & Amortization DEPRECIATION 100,575 403,239 383,000 1,148,987 5 97,637 389,771 13,467 3 Total For Depreciation & Amortization: 100,575 403,239 383,000 1,148,987 5 97,637 389,771 13,467 3 Interest Expense INTEREST EXPENSE - BONDS 3,466 13,866 13,866 40,600 0 3,666 14,666 (799) (5) AMORTIZATION OF DEBT DTSCOU (554) (2,216) (2,217) (6,651) 0 (554) (2,216) 0 0 Total For Interest Expense: 2,912 11,649 11,649 33,949 0 3,112 12,449 (799) (6) ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water APRIL YTD BUDGET BUDGET Bud Var% APRIL 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 0 0 666 2,000 (100) 1,449 1,541 (1,541) (100) 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 120 483 433 1,300 12 104 419 64 15 Total For Other Operating Expense: 120 483 1,100 82,300 (56) 1,553 2,055 (1,571) (76) Customer Accounts Expense METER READING EXPENSE 171 653 833 2,500 (22) 172 645 7 1 MISC CUSTOMER ACCOUNTS EXP 7,066 28,690 29,666 89,000 (3) 7,973 28,943 (252) (1) BAD DEBT EXPENSE & RECOVER 0 0 83 250 (100) 0 0 0 0 Total For Customer Accounts Expense: 7,237 29,344 30,583 91,750 (4) 8,146 29,588 (244) (1) Administrative Expense SALARIES OFFICE & COMMISSION 23,384 87,223 95,000 285,000 (8) 17,744 77,077 10,145 13 TEMPORARY STAFFING 0 0 333 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,375 6,028 12,333 37,000 (51) 1,775 7,746 (1,718) (22) ELECTRIC & WATER CONSUMPTI 534 2,076 3,666 11,000 (43) 546 2,233 (157) (7) BANK FEES 104 221 200 600 11 32 153 67 44 LEGAL FEES 381 935 3,000 9,000 (69) 240 1,481 (546) (37) AUDITING FEES 756 1,986 2,000 6,000 (1) 1,191 2,409 (423) (18) INSURANCE 3,460 13,921 14,333 43,000 (3) 4,757 13,806 115 1 UTILITY SHARE - DEFERRED COM 2,141 9,509 7,000 21,000 36 2,087 10,228 (718) (7) UTILITY SHARE - MEDICAL/DENT 14,703 84,059 89,090 220,000 (6) 15,214 90,299 (6,240) (7) UTILITY SHARE - PERA 4,824 18,968 18,666 56,000 2 5,047 18,419 549 3 UTILITY SHARE - FICA 4,659 18,353 18,000 54,000 2 4,861 17,587 766 4 EMPLOYEE SICK PAY 2,016 8,983 9,666 29,000 (7) 1,723 11,727 (2,744) (23) EMPLOYEE HOLIDAY PAY 0 7,401 8,727 32,000 (15) 0 7,076 325 5 EMPLOYEE VACATION & PTO PA 3,479 23,109 20,000 52,000 16 3,053 20,151 2,957 15 UPMIC DISTRIBUTION 0 5,834 5,250 21,000 11 (540) 3,632 2,202 61 WELLHEAD PROTECTION 0 0 680 2,000 (100) 6,750 6,861 (6,861) (100) LONGEVITY PAY 0 0 0 837 0 0 101 (101) (100) CONSULTING FEES 2,207 6,682 15,300 45,900 (56) 1,400 5,610 1,072 19 TELEPHONE 648 2,775 3,000 9,000 (8) 719 2,934 (158) (5) ADVERTISING 392 1,322 1,666 5,000 (21) 740 1,703 (380) (22) DUES & SUBSCRIPTIONS -FEES 3,381 20,944 23,100 88,114 (9) 1,162 19,518 1,425 7 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water APRIL YTD BUDGET BUDGET Bud Var% APRIL YTD VARIANCE Actual Var% SCHOOLS & MEETINGS 2,513 13,363 23,575 61,072 (43) 1,669 10,895 2,467 23 MTCE OF GENERAL PLANT & OFFI 211 844 1,033 3,100 (18) 250 1,002 (158) (16) Total For Administrative Expense: 71,176 334,544 375,623 1,092,623 (11) 70,429 332,660 1,884 1 General Expense CIP REBATES - RESIDENTIAL 0 25 1,666 5,000 (99) 0 327 (302) (92) CIP REBATES - COMMERCIAL 0 0 166 500 (100) 0 0 0 0 CIP - MARKETING 728 728 666 2,000 9 0 588 140 24 CIP - LABOR 0 0 1,666 5,000 (100) 102 1,288 (1,288) (100) ENVIRONMENTAL COMPLIANCE 60 219 833 2,500 (74) 808 956 (736) (77) MISC GENERAL EXPENSE 0 0 83 250 (100) 0 (3) 3 100 Total For General Expense: 789 972 5,083 15,250 (81) 910 3,157 (2,184) (69) Total Expenses(before Operating Transfers) 277,990 1,119,628 1,218,390 3,647,781 (8) 258,030 1,102,556 17,072 2 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 0 500 1,500 (100) 0 0 0 0 Total Operating Transfer Total For Total Operating Transfer: 0 0 500 1,500 (100) 0 0 0 0 Net Income Profit(Loss) (100,693) (328,452) (585,974) 79,007 44 (94,048) (452,922) 124,469 27