Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 05-09-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 Water MARCH YTD BUDGET BUDGET Bud Var% MARCH 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: 2022 YTD 2022 v. 2023 YTD VARIANCE Actual Var% 85,599 265,634 207,039 1,397,043 28 81,852 246,076 19,558 8 52,580 158,095 125,180 850,022 26 46,392 136,385 21,710 16 1,594 4,755 3,933 256,349 21 1,542 4,614 141 3 139,774 428,486 336,153 2,503,414 27 129,788 387,075 41,410 11 139,774 428,486 336,153 2,503,414 27 129,788 387,075 41,410 11 139,774 428,486 336,153 2,503,414 27 129,788 387,075 41,410 11 4,007 8,132 8,750 35,000 (7) (10,629) (20,020) 28,153 141 0 0 375 1,500 (100) 0 0 0 0 4,007 8,132 9,125 36,500 (11) (10,629) (20,020) 28,153 141 1,247 4,021 6,999 28,000 (43) 1,006 1,949 2,072 106 1,247 4,021 6,999 28,000 (43) 1,006 1,949 2,072 106 14,790 29,190 112,500 450,000 (74) 49,924 140,401 (111,211) (79) 1,347 2,635 9,999 40,000 (74) 4,644 13,177 (10,541) (80) 230 9,075 6,999 28,000 30 0 89 8,985 9,983 16,368 40,900 129,499 518,000 (68) 54,568 153,667 (112,767) (73) 20 20 12 50 54 20 20 0 0 0 258 125 500 107 0 0 258 0 974 3,831 3,375 13,500 14 978 3,273 557 17 0 0 0 65,000 0 0 0 0 0 0 0 0 296,984 0 23,481 70,445 (70,445) (100) 994 4,109 3,512 376,034 17 24,480 73,738 (69,628) (94) 22,617 57,165 149,137 958,534 (62) 69,425 209,335 (152,170) (73) 22,617 57,165 149,137 958,534 (62) 69,425 209,335 (152,170) (73) Total Revenue 162,392 485,651 485,290 3,461,948 0 199,213 596,410 (110,759) (19) 78 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var% Expenses Production Expense MTCE OF STRUCTURES 11,144 30,877 22,500 90,000 37 8,555 25,484 5,393 21 Total For Production Expense: 11,144 30,877 22,500 90,000 37 8,555 25,484 5,393 21 Pumping Expense SUPERVISION 4,706 15,555 17,250 69,000 (10) 5,608 15,409 145 1 ELECTRIC & GAS UTILITIES 21,022 65,975 72,000 288,000 (8) 19,202 59,231 6,743 11 SAMPLING 915 3,460 3,750 15,000 (8) 619 2,248 1,211 54 CHEMICAL FEED 1,816 5,239 12,500 50,000 (58) 1,715 4,787 452 9 MTCE OF ELECTRIC PUMPING EQ 0 0 0 0 0 0 96 (96) (100) MTCE OF WELLS 14,709 46,062 41,250 165,000 12 15,515 54,971 (8,908) (16) SCADA - PUMPING 239 808 3,999 16,000 (80) 227 3,676 (2,868) (78) Total For Pumping Expense: 43,409 137,101 150,750 603,000 (9) 42,888 140,421 (3,320) (2) Distribution Expense MTCE OF WATER MAINS 17,846 42,519 30,000 120,000 42 3,233 7,990 34,528 432 LOCATE WATER LINES 536 707 4,312 17,250 (84) 335 527 179 34 MTCE OF WATER SERVICES 36 184 0 0 0 0 40 144 362 WATER METER SERVICE 998 2,736 16,500 66,000 (83) 10,408 21,992 (19,256) (88) BACKFLOW DEVICE INSPECTION 1,283 4,578 2,700 16,000 70 889 2,692 1,886 70 MTCE OF CUSTOMERS SERVICE 2,465 7,482 7,625 30,500 (2) 2,323 6,792 690 10 WATER MAPPING 1,063 2,641 3,125 12,500 (15) 289 460 2,180 473 MTCE OF WATER HYDRANTS - PU 333 1,325 4,749 19,000 (72) 1,237 2,168 (843) (39) MTCE OF WATER HYDRANTS - PR 0 (73) 1,250 5,000 (106) 0 254 (327) (129) WATER CLOTHING/PPE 6,376 6,408 2,250 9,000 185 2,276 2,875 3,532 123 WAGES WATER 685 1,883 1,824 7,300 3 528 1,500 383 26 TRANSPORTATION EXPENSE 1,140 2,505 4,125 16,500 (39) 1,482 3,109 (603) (19) WATER PERMIT 345 15,752 18,600 18,600 (15) 0 18,025 (2,272) (13) Total For Distribution Expense: 33,111 88,653 97,062 337,650 (9) 23,005 68,430 20,222 30 Depreciation & Amortization DEPRECIATION 97,387 292,134 292,194 1,202,937 0 92,825 278,119 14,015 5 Total For Depreciation & Amortization: 97,387 292,134 292,194 1,202,937 0 92,825 278,119 14,015 5 Interest Expense INTEREST EXPENSE - BONDS 3,666 10,999 11,000 43,000 0 3,833 12,704 (1,704) (13) AMORTIZATION OF DEBT DISCOU (554) (1,662) (1,662) (6,651) 0 (554) (1,662) 0 0 Total For Interest Expense: 3,112 9,337 9,337 36,349 0 3,279 11,041 (1,704) (15) Other Operating Expense 79 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var%o LOSS ON DISPOSITION OF PROP (C 0 0 0 500 0 0 0 0 0 DAM MAINTENANCE EXPENSE 36 92 437 1,750 (79) 0 0 92 0 OTHER INTEREST EXPENSE 0 94 95 95 0 94 371 (277) (74) INTEREST EXPENSE - METER DEP 104 314 31 125 916 4 13 301 2,323 Total For Other Operating Expense: 141 501 563 2,470 (11) 98 384 116 30 Customer Accounts Expense METER READING EXPENSE 165 472 624 2,500 (24) 216 540 (67) (12) MISC CUSTOMER ACCOUNTS EXP 6,970 20,969 20,405 81,620 3 6,022 17,863 3,105 17 BAD DEBT EXPENSE & RECOVER 0 0 62 250 (100) 0 0 0 0 Total For Customer Accounts Expense: 7,135 21,442 21,092 84,370 2 6,238 18,403 3,038 17 Administrative Expense SALARIES OFFICE & COMMISSION 21,892 59,333 67,125 268,500 (12) 19,191 54,053 5,280 10 TEMPORARY STAFFING 0 0 249 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 2,382 5,971 6,375 25,500 (6) 1,138 3,164 2,807 89 ELECTRIC & WATER CONSUMPTI (433) 1,686 2,000 8,000 (16) 448 1,343 343 26 BANK FEES 35 121 156 625 (22) 41 142 (21) (15) LEGAL FEES 326 1,241 2,250 9,000 (45) 511 1,618 (376) (23) AUDITING FEES 405 1,217 1,157 4,630 5 375 1,127 90 8 INSURANCE 3,016 9,048 9,000 36,000 1 2,217 6,653 2,395 36 UTILITY SHARE - DEFERRED COM 3,080 8,141 7,625 30,500 7 2,075 6,987 1,153 17 UTILITY SHARE - MEDICAUDENT 15,332 75,084 87,363 215,000 (14) 15,850 75,215 (130) 0 UTILITY SHARE - PERA 4,767 13,371 13,500 54,000 (1) 4,460 12,203 1,168 10 UTILITY SHARE - FICA 4,536 12,725 12,999 52,000 (2) 4,301 11,661 1,064 9 EMPLOYEE SICK PAY 3,144 10,003 6,750 27,000 48 1,473 6,032 3,971 66 EMPLOYEE HOLIDAY PAY 0 7,076 8,400 30,800 (16) 0 4,301 2,774 64 EMPLOYEE VACATION & PTO PA 4,625 17,098 14,545 44,000 18 2,616 13,234 3,864 29 UPMIC DISTRIBUTION 4,172 4,172 4,517 18,069 (8) 2,200 2,200 1,972 90 WELLHEAD PROTECTION ill ill 0 10,000 0 1,488 4,252 (4,140) (97) LONGEVITY PAY 101 101 101 3,106 0 0 0 101 0 CONSULTING FEES 140 4,210 8,750 35,000 (52) 3,329 7,544 (3,334) (44) TELEPHONE 785 2,214 2,375 9,500 (7) 696 2,068 145 7 ADVERTISING 324 962 1,625 6,500 (41) 310 778 183 23 DUES & SUBSCRIPTIONS - FEES 1,326 18,356 20,000 78,320 (8) 1,434 18,324 32 0 SCHOOLS & MEETINGS 3,924 9,226 15,926 63,705 (42) 6,807 11,580 (2,354) (20) MTCE OF GENERAL PLANT & OFFI 250 752 474 1,900 58 152 457 294 65 a ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var% Total For Administrative Expense: 74,249 262,230 293,267 1,032,655 (11) 71,121 244,943 17,286 7 General Expense CIP REBATES - RESIDENTIAL 282 327 2,625 10,500 (88) 125 235 92 40 CIP REBATES - COMMERCIAL 0 0 125 500 (100) 0 0 0 0 CIP - MARKETING 0 588 125 500 370 529 529 58 11 CIP - LABOR 388 1,186 1,175 4,700 1 445 1,132 54 5 ENVIRONMENTAL COMPLIANCE 41 147 549 2,200 (73) 442 540 (393) (73) MISC GENERAL EXPENSE 0 (2) 62 250 (105) 0 0 (2) 0 Total For General Expense: 712 2,246 4,662 18,650 (52) 1,541 2,437 (190) (8) Total Expenses(before Operating Transfers) 270,404 844,525 891,429 3,408,081 (5) 249,555 789,667 54,858 7 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 0 375 1,500 (100) 0 0 0 0 Total Operating Transfer Total For Total Operating Transfer: 0 0 375 1,500 (100) 0 0 0 0 Net Income Profit(Loss) (108,011) (358,874) (406,514) 52,367 12 (165,617) (86) (50,342) (193,256)