Loading...
5.1h EMRUSR 09-10-2024ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JULY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 Water JULY YTD BUDGET BUDGET Bud Var% DULY 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% 145,272 763,018 813,733 1,595,403 (6) 292,414 1,019,953 (256,934) (25) 97,804 476,995 447,474 923,908 7 137,082 497,299 (20,304) (4) 41,408 91,656 88,651 268,691 3 94,476 169,723 (77,067) (46) 284,486 1,331,670 1,349,859 2,788,003 (1) 523,973 1,685,977 (354,306) (21) 284,486 1,331,670 1,349,859 2,788,003 (1) 523,973 1,685,977 (354,306) (21) 284,486 1,331,670 1,349,859 2,788,003 (1) 523,973 1,685,977 (354,306) (21) 17,381 52,517 23,333 40,000 125 7,138 23,494 29,022 124 0 0 875 1,500 (100) 543 543 (543) (100) 17,381 52,517 24,208 41,500 117 7,681 24,037 28,479 118 3,450 13,323 14,583 25,000 (9) 3,305 10,587 2,735 26 3,450 13,323 14,583 25,000 (9) 3,305 10,587 2,735 26 14,400 201,830 116,666 200,000 73 7,590 101,915 99,914 98 1,470 14,447 17,500 30,000 (17) 2,445 7,850 6,596 84 270 12,764 14,583 25,000 (12) 6,462 13,608 (844) (6) 16,141 229,042 148,750 255,000 54 16,498 123,375 105,666 86 0 20 29 50 (31) 0 20 0 0 0 0 0 230,000 0 0 0 0 0 195 716 291 500 146 0 258 458 177 975 7,650 8,750 15,000 (13) 2,506 9,262 (1,611) (17) 0 0 0 65,000 0 0 0 0 0 0 0 0 308,236 0 0 0 0 0 1,170 8,387 9,070 618,786 (8) 2,506 9,541 (1,153) (12) 38,145 303,270 196,612 940,286 54 29,991 167,542 135,728 81 38,145 303,270 196,612 940,286 54 29,991 167,542 135,728 81 72 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JULY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water JULY YTD BUDGET BUDGET Bud Var% DULY YTD VARIANCE Actual Var% Total Revenue 322,631 1,634,941 1,546,472 3,728,289 6 553,965 1,853,519 (218,578) (12) Expenses Production Expense MTCE OF STRUCTURES 13,178 77,988 67,083 115,000 16 6,824 62,317 15,670 25 Total For Production Expense: 13,178 77,988 67,083 115,000 16 6,824 62,317 15,670 25 Pumping Expense SUPERVISION 6,070 40,327 39,375 67,500 2 5,433 36,450 3,877 11 ELECTRIC & GAS UTILITIES 28,083 147,255 195,516 335,171 (25) 30,799 189,312 (42,057) (22) SAMPLING 5,667 13,775 9,916 17,000 39 2,163 9,605 4,169 43 CHEMICAL FEED 2,846 19,030 30,916 53,000 (38) 6,958 25,587 (6,556) (26) MTCE OF WELLS 32,272 111,454 96,250 165,000 16 24,234 94,379 17,075 18 SCADA - PUMPING 1,315 5,689 4,666 8,000 22 284 1,954 3,734 191 Total For Pumping Expense: 76,255 337,532 376,641 645,671 (10) 69,874 357,290 (19,757) (6) Distribution Expense MTCE OF WATER MAINS 10,364 48,245 102,083 175,000 (53) 16,438 107,621 (59,375) (55) LOCATE WATER LINES 1,353 8,148 10,062 17,250 (19) 1,096 4,691 3,457 74 MTCE OF WATER SERVICES 0 0 291 500 (100) 0 184 (184) (100) WATER METER SERVICE 17,490 38,469 38,500 66,000 0 3,836 16,690 21,779 130 BACKFLOW DEVICE INSPECTION 2,324 11,488 12,478 20,000 (8) 2,259 11,495 (7) 0 MTCE OF CUSTOMERS SERVICE 3,130 19,103 19,250 33,000 (1) 2,545 17,364 1,739 10 WATER MAPPING 468 12,607 8,750 15,000 44 354 9,318 3,299 35 MTCE OF WATER HYDRANTS - PU 993 19,273 11,666 20,000 57 765 7,911 10,362 131 MTCE OF WATER HYDRANTS - PR 570 4,192 3,500 6,000 20 617 3,338 853 26 WATER CLOTHING/PPE 115 9,212 5,833 10,000 58 28 7,648 1,564 20 WAGES WATER 606 4,436 4,375 7,500 1 603 4,060 376 9 TRANSPORTATION EXPENSE 1,672 12,820 14,000 24,000 (8) 1,754 8,400 4,419 53 WATER PERMIT 0 26,255 28,000 28,000 (6) 0 15,752 10,502 67 Total For Distribution Expense: 39,080 213,254 258,790 422,250 (18) 30,301 214,477 (1,222) (1) Depreciation & Amortization DEPRECIATION 101,013 706,575 670,250 1,148,987 5 97,625 682,702 23,872 3 Total For Depreciation & Amortization: 101,013 706,575 670,250 1,148,987 5 97,625 682,702 23,872 3 Interest Expense INTEREST EXPENSE - BONDS 3,466 24,266 24,266 40,600 0 3,666 25,666 (1,400) (5) AMORTIZATION OF DEBT DTSCOU (554) (3,879) (3,879) (6,651) 0 (554) (3,879) 0 0 Total For Interest Expense: 2,912 20,386 20,386 33,949 0 3,112 21,786 (1,400) (6) 73 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JULY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water JULY YTD BUDGET BUDGET Bud Var% DULY 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 177 1,166 2,000 (85) 0 1,689 (1,511) (90) 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 664 758 1,300 (12) 104 734 (69) (9) Total For Other Operating Expense: 60 841 1,925 82,300 (56) 104 2,517 (1,675) (67) Customer Accounts Expense METER READING EXPENSE 627 2,473 1,458 2,500 70 190 1,212 1,260 104 MISC CUSTOMER ACCOUNTS EXP 7,217 51,601 51,916 89,000 (1) 7,301 49,712 1,889 4 BAD DEBT EXPENSE & RECOVER 19 19 145 250 (87) 0 0 19 100 Total For Customer Accounts Expense: 7,865 54,094 53,520 91,750 1 7,491 50,925 3,169 6 Administrative Expense SALARIES OFFICE & COMMISSION 21,649 150,464 166,250 285,000 (9) 18,119 134,162 16,302 12 TEMPORARY STAFFING 0 0 583 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,447 11,832 21,583 37,000 (45) 1,890 16,569 (4,736) (29) ELECTRIC & WATER CONSUMPTI 731 3,985 6,416 11,000 (38) 647 4,317 (331) (8) BANK FEES 64 400 350 600 15 33 259 141 55 LEGAL FEES 701 2,539 5,250 9,000 (52) 783 3,074 (535) (17) AUDITING FEES 410 3,216 3,500 6,000 (8) 405 3,626 (410) (11) INSURANCE 3,555 24,397 25,083 43,000 (3) 3,247 34,392 (9,995) (29) UTILITY SHARE - DEFERRED COM 1,267 13,893 12,250 21,000 13 1,206 14,502 (608) (4) UTILITY SHARE - MEDICAL/DENT 14,693 128,162 138,181 220,000 (7) 12,032 132,259 (4,097) (3) UTILITY SHARE - PERA 4,882 34,396 32,666 56,000 5 4,072 31,096 3,300 11 UTILITY SHARE - FICA 5,057 34,043 31,500 54,000 8 3,917 30,115 3,927 13 EMPLOYEE SICK PAY 2,068 14,529 16,916 29,000 (14) 1,807 16,238 (1,708) (11) EMPLOYEE HOLIDAY PAY 2,874 16,028 14,545 32,000 10 2,530 14,662 1,366 9 EMPLOYEE VACATION & PTO PA 3,862 34,928 32,000 52,000 9 3,903 30,238 4,690 16 UPMIC DISTRIBUTION 0 9,752 10,500 21,000 (7) 0 6,284 3,468 55 WELLHEAD PROTECTION 0 0 1,190 2,000 (100) 0 6,861 (6,861) (100) LONGEVITY PAY 0 420 420 837 0 0 2,271 (1,851) (82) CONSULTING FEES 217 8,214 26,775 45,900 (69) 0 7,283 930 13 TELEPHONE 676 4,746 5,250 9,000 (10) 692 4,998 (252) (5) ADVERTISING 240 2,172 2,916 5,000 (26) 96 2,612 (439) (17) DUES & SUBSCRIPTIONS -FEES 1,229 43,069 45,600 88,114 (6) 1,322 37,641 5,428 14 74 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JULY 2024 2024 2024 2024 2024 YTD ANNUAL 2024 YTD 2023 2023 YTD 2023 v. 2024 Water JULY YTD BUDGET BUDGET Bud Var% DULY YTD VARIANCE Actual Var% SCHOOLS & MEETINGS (898) 21,494 30,375 61,072 (29) 1,005 14,602 6,891 47 MTCE OF GENERAL PLANT & OFFI 211 1,477 1,808 3,100 (18) 250 1,754 (277) (16) Total For Administrative Expense: 64,942 564,164 631,912 1,092,623 (11) 57,964 549,825 14,339 3 General Expense CIP REBATES - RESIDENTIAL 58 371 2,916 5,000 (87) 94 740 (369) (50) CIP REBATES - COMMERCIAL 0 0 291 500 (100) 0 0 0 0 CIP - MARKETING (160) 1,117 1,166 2,000 (4) 199 966 150 16 CIP - LABOR 0 0 2,916 5,000 (100) 0 1,288 (1,288) (100) ENVIRONMENTAL COMPLIANCE 60 393 1,458 2,500 (73) 52 1,106 (713) (64) MISC GENERAL EXPENSE 0 0 145 250 (100) 0 (24) 24 100 Total For General Expense: (41) 1,881 8,895 15,250 (79) 336 4,078 (2,197) (54) Total Expenses(before Operating Transfers) 305,266 1,976,720 2,089,406 3,647,781 (5) 273,635 1,945,921 30,799 2 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 0 875 1,500 (100) 0 0 0 0 Total Operating Transfer Total For Total Operating Transfer: 0 0 875 1,500 (100) 0 0 0 0 Net Income Profit(Loss) 17,365 (341,779) (543,809) 79,007 37 280,330 (92,401) (249,378) (270) 75