Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMU 12-12-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING OCTOBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 Water OCTOBER YTD BUDGET BUDGET Bud Var% OCTOBER 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 GAIN ON DISPOSITION OF PROPER 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% 155,108 1,665,664 1,240,487 1,397,043 34 142,148 1,474,373 191,290 13 120,320 921,369 742,913 850,022 24 102,652 809,411 111,957 14 46,155 390,386 244,737 256,349 60 46,623 287,099 103,287 36 321,584 2,977,420 2,228,138 2,503,414 34 291,424 2,570,884 406,535 16 321,584 2,977,420 2,228,138 2,503,414 34 291,424 2,570,884 406,535 16 321,584 2,977,420 2,228,138 2,503,414 34 291,424 2,570,884 406,535 16 5,629 36,073 29,166 35,000 24 (2,973) (41,514) 77,588 187 0 543 1,250 1,500 (57) 0 592 (49) (8) 5,629 36,616 30,416 36,500 20 (2,973) (40,922) 77,538 189 2,564 20,094 23,333 28,000 (14) 3,172 22,548 (2,453) (11) 2,564 20,094 23,333 28,000 (14) 3,172 22,548 (2,453) (11) 43,905 185,810 375,000 450,000 (50) 45,390 1,297,321 (1,111,510) (86) 4,021 15,515 33,333 40,000 (53) 2,168 52,741 (37,225) (71) 6,750 21,555 23,333 28,000 (8) 5,351 14,413 7,141 50 54,676 222,881 431,666 518,000 (48) 52,909 1,364,475 (1,141,593) (84) 60 100 41 50 138 0 110 (10) (9) 0 2,940 0 0 0 0 0 2,940 0 0 258 416 500 (38) 0 287 (28) (10) 1,330 12,543 11,250 13,500 11 975 11,254 1,288 11 0 0 0 65,000 0 0 0 0 0 0 0 0 296,984 0 24,248 237,656 (237,656) (100) 1,390 15,841 11,708 376,034 35 25,223 249,309 (233,467) (94) 64,259 295,434 497,125 958,534 (41) 78,332 1,595,410 (1,299,975) (81) 64,259 295,434 497,125 958,534 (41) 78,332 1,595,410 (1,299,975) (81) 93 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING OCTOBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water OCTOBER YTD BUDGET BUDGET Bud Var%o OCTOBER YTD VARIANCE Actual Var% Total Revenue 385,844 3,272,855 2,725,263 3,461,948 20 369,756 4,166,295 (893,439) (21) Expenses Production Expense MTCE OF STRUCTURES 11,358 89,489 75,000 90,000 19 20,224 89,444 44 0 Total For Production Expense: 11,358 89,489 75,000 90,000 19 20,224 89,444 44 0 Pumping Expense SUPERVISION 6,187 52,794 57,500 69,000 (8) 6,307 54,118 (1,323) (2) ELECTRIC & GAS UTILITIES 18,780 266,660 240,000 288,000 11 19,455 237,906 28,754 12 SAMPLING 1,695 13,057 12,500 15,000 4 1,274 11,685 1,371 12 CHEMICAL FEED 1,923 42,201 41,666 50,000 1 8,165 33,503 8,697 26 MTCE OF ELECTRIC PUMPING EQ 0 0 0 0 0 0 46 (46) (100) MTCE OF WELLS 8,315 124,867 137,500 165,000 (9) 8,311 132,256 (7,388) (6) SCADA - PUMPING 317 2,871 13,333 16,000 (78) 287 9,323 (6,452) (69) Total For Pumping Expense: 37,220 502,453 502,500 603,000 0 43,803 478,839 23,613 5 Distribution Expense MTCE OF WATER MAINS 9,242 135,765 100,000 120,000 36 7,786 73,382 62,383 85 LOCATE WATER LINES 1,088 7,878 14,375 17,250 (45) 1,215 10,378 (2,500) (24) MTCE OF WATER SERVICES 0 240 0 0 0 0 897 (656) (73) WATER METER SERVICE 3,366 27,768 55,000 66,000 (50) 5,100 64,055 (36,287) (57) BACKFLOW DEVICE INSPECTION 1,503 16,871 14,200 16,000 19 48 10,765 6,106 57 MTCE OF CUSTOMERS SERVICE 2,661 25,231 25,416 30,500 (1) 2,323 23,591 1,639 7 WATER MAPPING 577 11,716 10,416 12,500 12 395 9,319 2,397 26 MTCE OF WATER HYDRANTS - PU 1,309 12,548 15,833 19,000 (21) 1,655 16,347 (3,798) (23) MTCE OF WATER HYDRANTS - PR 57 3,665 4,166 5,000 (12) 300 4,120 (455) (11) WATER CLOTHING/PPE 286 9,142 7,500 9,000 22 216 7,514 1,627 22 WAGES WATER 647 5,921 6,083 7,300 (3) 1,005 7,177 (1,255) (17) TRANSPORTATION EXPENSE 2,569 14,093 13,750 16,500 2 1,089 13,856 236 2 WATER PERMIT 0 15,752 18,600 18,600 (15) 0 18,370 (2,617) (14) Total For Distribution Expense: 23,308 286,595 285,341 337,650 0 21,138 259,776 26,818 10 Depreciation & Amortization DEPRECIATION 97,539 976,185 988,141 1,202,937 (1) 91,956 921,121 55,063 6 Total For Depreciation & Amortization: 97,539 976,185 988,141 1,202,937 (1) 91,956 921,121 55,063 6 Interest Expense INTEREST EXPENSE - BONDS 3,466 36,066 36,066 43,000 0 3,666 39,037 (2,971) (8) AMORTIZATION OF DEBT DISCOU (554) (5,542) (5,542) (6,651) 0 (554) (5,542) 0 0 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING OCTOBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water OCTOBER YTD BUDGET BUDGET Bud Var%o OCTOBER YTD VARIANCE Actual Var%o Total For Interest Expense: 2,912 30,524 30,524 36,349 0 3,112 33,495 (2,971) (9) Other Operating Expense LOSS ON DISPOSITION OF PROP (C 0 0 0 500 0 0 0 0 0 DAM MAINTENANCE EXPENSE 168 1,876 1,458 1,750 29 244 1,430 446 31 OTHER INTEREST EXPENSE 0 94 95 95 0 94 1,033 (938) (91) INTEREST EXPENSE - METER DEP 105 1,048 104 125 908 4 44 1,004 2,282 Total For Other Operating Expense: 273 3,019 1,657 2,470 82 343 2,507 511 20 Customer Accounts Expense METER READING EXPENSE 225 1,845 2,083 2,500 (11) 214 2,029 (183) (9) MISC CUSTOMER ACCOUNTS EXP 8,680 73,162 68,016 81,620 8 7,194 65,401 7,760 12 BAD DEBT EXPENSE & RECOVER 0 (28) 208 250 (113) 0 28 (56) (200) Total For Customer Accounts Expense: 8,906 74,979 70,308 84,370 7 7,409 67,458 7,520 11 Administrative Expense SALARIES OFFICE & COMMISSION 20,299 193,391 223,750 268,500 (14) 20,925 195,262 (1,871) (1) TEMPORARY STAFFING 0 0 833 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,415 21,220 21,250 25,500 0 1,278 12,011 9,208 77 ELECTRIC & WATER CONSUMPTI 586 6,254 6,666 8,000 (6) 486 5,442 811 15 BANK FEES 35 384 520 625 (26) 34 410 (26) (7) LEGAL FEES 269 3,731 7,500 9,000 (50) 732 5,974 (2,243) (38) AUDITING FEES 405 4,844 3,858 4,630 26 375 3,758 1,086 29 INSURANCE 3,616 44,673 30,000 36,000 49 2,934 27,761 16,912 61 UTILITY SHARE - DEFERRED COM 1,297 18,737 25,416 30,500 (26) 638 17,813 924 5 UTILITY SHARE - MEDICAL/DENT 14,395 174,527 186,636 215,000 (6) 16,531 189,637 (15,110) (8) UTILITY SHARE - PERA 4,299 44,231 45,000 54,000 (2) 4,537 44,538 (307) (1) UTILITY SHARE - FICA 4,151 42,787 43,333 52,000 (1) 4,401 42,849 (61) 0 EMPLOYEE SICK PAY 2,129 22,806 22,500 27,000 1 2,482 21,605 1,201 6 EMPLOYEE HOLIDAY PAY 0 17,362 16,800 30,800 3 0 11,954 5,407 45 EMPLOYEE VACATION & PTO PA 2,992 41,114 37,454 44,000 10 3,123 38,614 2,499 6 UPMIC DISTRIBUTION 0 10,967 13,551 18,069 (19) 0 9,904 1,063 11 WELLHEAD PROTECTION 0 6,861 10,000 10,000 (31) 0 4,724 2,137 45 LONGEVITY PAY 0 2,581 3,106 3,106 (17) 0 310 2,271 733 CONSULTING FEES 490 8,516 29,166 35,000 (71) 472 19,882 (11,366) (57) TELEPHONE 676 6,997 7,916 9,500 (12) 923 7,227 (229) (3) ADVERTISING 418 3,822 5,416 6,500 (29) 114 2,693 1,129 42 DUES & SUBSCRIPTIONS - FEES 1,201 54,994 61,000 78,320 (10) (29) 57,922 (2,927) (5) 95 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING OCTOBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 Water OCTOBER YTD BUDGET BUDGET Bud Var%o OCTOBER SCHOOLS & MEETINGS 7,431 32,825 53,087 63,705 (38) 3,667 MTCE OF GENERAL PLANT & OFFI 250 2,506 1,583 1,900 58 152 Total For Administrative Expense: 66,363 766,141 856,348 1,032,655 (11) 63,784 General Expense CIP REBATES - RESIDENTIAL 0 1,185 8,750 10,500 (86) 0 CIP REBATES - COMMERCIAL 0 0 416 500 (100) 0 CIP - MARKETING 0 966 416 500 132 0 CIP - LABOR 0 1,288 3,916 4,700 (67) 407 ENVIRONMENTAL COMPLIANCE 61 1,264 1,833 2,200 (31) 53 MISC GENERAL EXPENSE 0 (24) 208 250 (112) 0 Total For General Expense: 61 4,681 15,541 18,650 (70) 461 Total Expenses(before Operating Transfers) Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl Total Operating Transfer Total For Total Operating Transfer: Net Income Profit(Loss) 247,943 2,734,068 2,825,363 3,408,081 2022 YTD 2022 v. 2023 YTD VARIANCE Actual Var% 34,514 (1,689) (5) 1,523 983 65 756,339 9,801 1 834 0 613 3,760 1,481 0 6,690 (3) 252,234 2,615,675 351 0 353 (2,471) (217) (24) (2,009) 118,393 42 0 58 (66) (15) 0 (30) 9 0 0 1,250 1,500 (100) 539 539 (539) (100) 0 0 1,250 1,500 (100) 539 539 (539) (100) 137,901 538,786 (101,349) 52,367 632 116,982 1,550,080 (1,011,293) (65)