Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 06-13-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 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 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% 84,052 349,687 282,861 1,397,043 24 90,117 336,193 13,493 4 50,826 208,921 176,623 850,022 18 56,047 192,432 16,489 9 1,834 6,590 5,311 256,349 24 1,616 6,230 360 6 136,713 565,199 464,795 2,503,414 22 147,781 534,856 30,343 6 136,713 565,199 464,795 2,503,414 22 147,781 534,856 30,343 6 136,713 565,199 464,795 2,503,414 22 147,781 534,856 30,343 6 4,879 13,012 11,666 35,000 12 (6,427) (26,448) 39,460 149 0 0 500 1,500 (100) 0 0 0 0 4,879 13,012 12,166 36,500 7 (6,427) (26,448) 39,460 149 938 4,960 9,333 28,000 (47) 2,155 4,104 855 21 938 4,960 9,333 28,000 (47) 2,155 4,104 855 21 22,110 51,300 150,000 450,000 (66) 451,105 591,506 (540,206) (91) 1,099 3,735 13,333 40,000 (72) 8,552 21,729 (17,994) (83) (2,734) 6,341 9,333 28,000 (32) 0 89 6,251 6,946 20,475 61,376 172,666 518,000 (64) 459,657 613,325 (551,948) (90) 0 20 16 50 18 5 25 (5) (20) 0 258 166 500 55 0 0 258 0 975 4,806 4,500 13,500 7 980 4,253 552 13 0 0 0 65,000 0 0 0 0 0 0 0 0 296,984 0 23,481 93,926 (93,926) (100) 975 5,084 4,683 376,034 9 24,466 98,205 (93,120) (95) 27,268 84,433 198,850 958,534 (58) 479,851 689,186 (604,752) (88) 27,268 84,433 198,850 958,534 (58) 479,851 689,186 (604,752) (88) Total Revenue 163,982 649,633 663,645 3,461,948 (2) 627,632 1,224,043 (574,409) (47) 159 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water APRIL YTD BUDGET BUDGET Bud Var%o APRIL YTD VARIANCE Actual Var% Expenses Production Expense MTCE OF STRUCTURES 6,274 37,152 30,000 90,000 24 7,200 32,685 4,467 14 Total For Production Expense: 6,274 37,152 30,000 90,000 24 7,200 32,685 4,467 14 Pumping Expense SUPERVISION 5,444 21,000 23,000 69,000 (9) 4,517 19,927 1,072 5 ELECTRIC & GAS UTILITIES 20,497 86,473 96,000 288,000 (10) 16,439 75,671 10,801 14 SAMPLING 2,543 6,003 5,000 15,000 20 2,151 4,400 1,602 36 CHEMICAL FEED 790 6,030 16,666 50,000 (64) 477 5,264 765 15 MTCE OF ELECTRIC PUMPING EQ 0 0 0 0 0 0 96 (96) (100) MTCE OF WELLS 10,405 56,468 55,000 165,000 3 14,111 69,082 (12,614) (18) SCADA - PUMPING 295 1,103 5,333 16,000 (79) 186 3,862 (2,759) (71) Total For Pumping Expense: 39,977 177,078 201,000 603,000 (12) 37,883 178,305 (1,226) (1) Distribution Expense MTCE OF WATER MAINS 13,171 55,691 40,000 120,000 39 2,365 10,355 45,335 438 LOCATE WATER LINES 482 1,190 5,750 17,250 (79) 1,401 1,929 (739) (38) MTCE OF WATER SERVICES 0 184 0 0 0 0 40 144 362 WATER METER SERVICE 4,457 7,193 22,000 66,000 (67) 8,627 30,620 (23,426) (77) BACKFLOW DEVICE INSPECTION 1,123 5,701 3,600 16,000 58 889 3,581 2,119 59 MTCE OF CUSTOMERS SERVICE 2,395 9,877 10,166 30,500 (3) 2,250 9,043 834 9 WATER MAPPING 4,102 6,744 4,166 12,500 62 535 996 5,748 577 MTCE OF WATER HYDRANTS - PU 1,131 2,457 6,333 19,000 (61) 874 3,043 (585) (19) MTCE OF WATER HYDRANTS - PR 0 (73) 1,666 5,000 (104) 0 254 (327) (129) WATER CLOTHING/PPE 846 7,255 3,000 9,000 142 1,848 4,723 2,531 54 WAGES WATER 498 2,382 2,433 7,300 (2) 397 1,897 484 26 TRANSPORTATION EXPENSE 1,780 4,285 5,500 16,500 (22) 1,183 4,293 (7) 0 WATER PERMIT 0 15,752 18,600 18,600 (15) 345 18,370 (2,617) (14) Total For Distribution Expense: 29,988 118,642 123,216 337,650 (4) 20,718 89,148 29,493 33 Depreciation & Amortization DEPRECIATION 97,637 389,771 389,592 1,202,937 0 92,513 370,632 19,139 5 Total For Depreciation & Amortization: 97,637 389,771 389,592 1,202,937 0 92,513 370,632 19,139 5 Interest Expense INTEREST EXPENSE - BONDS 3,666 14,666 14,666 43,000 0 3,833 16,537 (1,871) (11) AMORTIZATION OF DEBT DISCOU (554) (2,216) (2,217) (6,651) 0 (554) (2,216) 0 0 Total For Interest Expense: 3,112 12,449 12,449 36,349 0 3,279 14,320 (1,871) (13) Other Operating Expense 160 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water APRIL YTD BUDGET BUDGET Bud Var% APRIL YTD VARIANCE Actual Var% LOSS ON DISPOSITION OF PROP (C 0 0 0 500 0 0 0 0 0 DAM MAINTENANCE EXPENSE 1,449 1,541 583 1,750 164 0 0 1,541 0 OTHER INTEREST EXPENSE 0 94 95 95 0 94 466 (371) (80) INTEREST EXPENSE - METER DEP 104 419 41 125 900 4 17 401 2,233 Total For Other Operating Expense: 1,553 2,055 720 2,470 185 98 483 1,571 325 Customer Accounts Expense METER READING EXPENSE 172 645 833 2,500 (23) 220 761 (115) (15) MISC CUSTOMER ACCOUNTS EXP 7,973 28,943 27,206 81,620 6 6,774 24,637 4,305 17 BAD DEBT EXPENSE & RECOVER 0 0 83 250 (100) 0 0 0 0 Total For Customer Accounts Expense: 8,146 29,588 28,123 84,370 5 6,995 25,399 4,189 16 Administrative Expense SALARIES OFFICE & COMMISSION 17,744 77,077 89,500 268,500 (14) 19,327 73,380 3,697 5 TEMPORARY STAFFING 0 0 333 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,775 7,746 8,500 25,500 (9) 953 4,117 3,629 88 ELECTRIC & WATER CONSUMPTI 546 2,233 2,666 8,000 (16) 419 1,762 470 27 BANK FEES 32 153 208 625 (26) 32 175 (21) (12) LEGAL FEES 240 1,481 3,000 9,000 (51) 519 2,137 (655) (31) AUDITING FEES 1,191 2,409 1,543 4,630 56 375 1,503 906 60 INSURANCE 4,757 13,806 12,000 36,000 15 2,217 8,870 4,935 56 UTILITY SHARE - DEFERRED COM 2,087 10,228 10,166 30,500 1 2,994 9,981 247 2 UTILITY SHARE - MEDICAUDENT 15,214 90,299 101,545 215,000 (11) 15,720 90,936 (636) (1) UTILITY SHARE - PERA 5,047 18,419 18,000 54,000 2 5,012 17,215 1,203 7 UTILITY SHARE - FICA 4,861 17,587 17,333 52,000 1 4,793 16,455 1,132 7 EMPLOYEE SICK PAY 1,723 11,727 9,000 27,000 30 2,633 8,665 3,061 35 EMPLOYEE HOLIDAY PAY 0 7,076 8,400 30,800 (16) 0 4,301 2,774 64 EMPLOYEE VACATION & PTO PA 3,053 20,151 17,818 44,000 13 4,253 17,487 2,663 15 UPMIC DISTRIBUTION (540) 3,632 4,517 18,069 (20) 0 2,200 1,431 65 WELLHEAD PROTECTION 6,750 6,861 0 10,000 0 471 4,724 2,137 45 LONGEVITY PAY 0 101 101 3,106 0 0 0 101 0 CONSULTING FEES 1,400 5,610 11,666 35,000 (52) 3,491 11,035 (5,425) (49) TELEPHONE 719 2,934 3,166 9,500 (7) 693 2,762 172 6 ADVERTISING 740 1,703 2,166 6,500 (21) 440 1,218 484 40 DUES & SUBSCRIPTIONS - FEES 1,162 19,518 22,000 78,320 (11) 1,262 19,586 (68) 0 SCHOOLS & MEETINGS 1,669 10,895 21,235 63,705 (49) 4,397 15,977 (5,081) (32) MTCE OF GENERAL PLANT & OFFI 250 1,002 633 1,900 58 152 609 393 65 161 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water APRIL YTD BUDGET BUDGET Bud Var%o APRIL YTD VARIANCE Actual Var% Total For Administrative Expense: 70,429 332,660 365,501 1,032,655 (9) 70,162 315,105 17,554 6 General Expense CIP REBATES - RESIDENTIAL 0 327 3,500 10,500 (91) 50 285 42 15 CIP REBATES - COMMERCIAL 0 0 166 500 (100) 0 0 0 0 CIP - MARKETING 0 588 166 500 252 0 529 58 11 CIP - LABOR 102 1,288 1,566 4,700 (18) 400 1,533 (244) (16) ENVIRONMENTAL COMPLIANCE 808 956 733 2,200 30 646 1,187 (231) (19) MISC GENERAL EXPENSE 0 (3) 83 250 (105) 0 0 (3) 0 Total For General Expense: 910 3,157 6,216 18,650 (49) 1,096 3,534 (377) (11) Total Expenses(before Operating Transfers) 258,030 1,102,556 1,156,820 3,408,081 (5) 239,948 1,029,616 72,940 7 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) (94,048) (452,922) (493,674) 52,367 8 (647,349) (333) 387,683 194,426 162