Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 02-14-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER 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 PERA PENSION REVENUE CONTRIBUTIONS FROM GRANTS TRANSFER IN FROM CITY MISCELLANEOUS REVENUE HYDRANT MAINTENANCE PROGR CONTRIBUTIONS FROM DEVELOP WATER TOWER LEASE Total For Misc Revenue: Total Other Revenue 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 93,189 1,660,446 1,359,866 1,359,866 22 89,804 1,764,627 (104,180) (6) 55,403 926,107 842,024 842,024 10 50,538 925,451 656 0 1,563 300,720 243,025 243,025 24 1,521 359,060 (58,339) (16) 150,156 2,887,275 2,444,916 2,444,916 18 141,864 3,049,139 (161,864) (5) 150,156 2,887,275 2,444,916 2,444,916 18 141,864 3,049,139 (161,864) (5) 150,156 2,887,275 2,444,916 2,444,916 18 141,864 3,049,139 (161,864) (5) 8,986 (30,591) 35,000 35,000 (187) 870 24,676 (55,268) (224) 543 1,136 1,000 1,000 14 629 1,310 (174) (13) 9,529 (29,455) 36,000 36,000 (182) 1,500 25,987 (55,442) (213) 1,022 26,194 18,000 18,000 46 0 0 26,194 0 1,022 26,194 18,000 18,000 46 0 0 26,194 0 14,400 1,547,929 430,000 430,000 260 35,320 548,947 998,982 182 (371) 55,912 35,000 35,000 60 2,811 42,709 13,202 31 3,465 18,220 15,000 15,000 21 12,022 28,810 (10,590) (37) 17,494 1,622,062 480,000 480,000 238 50,154 620,467 1,001,594 161 40 150 0 0 0 0 31 119 384 0 0 0 0 0 910 910 (910) (100) 0 0 0 0 0 3,288 3,288 (3,288) (100) 0 0 0 0 0 195,245 195,245 (195,245) (100) 0 1,019 0 0 0 0 1,141 (121) (11) 1,397 13,627 13,000 13,000 5 2,454 13,209 417 3 676,553 676,553 65,000 65,000 941 552,919 552,919 123,633 22 24,248 286,153 286,153 286,153 0 23,364 275,727 10,425 4 702,239 977,503 364,153 364,153 168 778,182 1,042,472 (64,968) (6) 730,286 2,596,304 898,153 898,153 189 829,837 1,688,927 907,377 54 79 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% Total For Total Other Revenue: 730,286 2,596,304 898,153 898,153 189 829,837 1,688,927 907,377 54 Total Revenue 880,442 5,483,580 3,343,069 3,343,069 64 971,701 4,738,067 745,513 16 Expenses Production Expense MTCE OF STRUCTURES 16,832 114,397 75,000 75,000 53 6,552 173,376 (58,979) (34) Total For Production Expense: 16,832 114,397 75,000 75,000 53 6,552 173,376 (58,979) (34) Pumping Expense SUPERVISION 6,141 66,134 66,000 66,000 0 4,794 57,004 9,129 16 ELECTRIC & GAS UTILITIES 20,204 281,124 270,000 270,000 4 18,905 263,078 18,045 7 SAMPLING 608 13,093 15,000 15,000 (13) 1,969 14,339 (1,246) (9) CHEMICAL FEED 3,151 32,349 36,000 36,000 (10) 2,230 36,273 (3,924) (11) MTCE OF ELECTRIC PUMPING EQ 0 46 0 0 0 20 182 (135) (75) MTCE OF WELLS 20,073 160,129 160,000 160,000 0 11,755 125,418 34,711 28 SCADA - PUMPING 575 13,807 16,000 16,000 (14) 195 5,140 8,666 169 Total For Pumping Expense: 50,754 566,684 563,000 563,000 1 39,871 501,437 65,246 13 Distribution Expense MTCE OF WATER MAINS 1,232 79,580 120,000 120,000 (34) 125,773 226,593 (147,012) (65) LOCATE WATER LINES 150 11,045 17,000 17,000 (35) 714 16,132 (5,086) (32) MTCE OF WATER SERVICES 0 897 0 0 0 29 61 835 1,348 WATER METER SERVICE 3,173 72,990 55,000 55,000 33 4,745 60,844 12,146 20 BACKFLOW DEVICE INSPECTION 0 10,765 15,000 15,000 (28) 889 9,055 1,710 19 MTCE OF CUSTOMERS SERVICE 2,404 28,317 30,500 30,500 (7) 2,258 28,116 200 1 WATER MAPPING 1,654 12,236 12,500 12,500 (2) 397 8,732 3,503 40 MTCE OF WATER HYDRANTS - PU 4,098 21,980 18,000 18,000 22 725 13,517 8,462 63 MTCE OF WATER HYDRANTS - PR 650 5,104 5,000 5,000 2 0 5,093 10 0 WATER CLOTHING/PPE 29 7,616 7,000 7,000 9 275 13,542 (5,925) (44) WAGES WATER 1,081 9,340 9,500 9,500 (2) 439 6,138 3,202 52 TRANSPORTATION EXPENSE 595 15,190 15,000 15,000 1 437 10,198 4,992 49 WATER PERMIT 0 18,370 18,600 18,600 (1) 0 14,875 3,494 23 Total For Distribution Expense: 15,069 293,436 323,100 323,100 (9) 136,687 412,901 (119,464) (29) Depreciation & Amortization DEPRECIATION 97,991 1,111,069 1,199,123 1,199,123 (7) 92,376 1,139,801 (28,731) (3) Total For Depreciation & Amortization: 97,991 1,111,069 1,199,123 1,199,123 (7) 92,376 1,139,801 (28,731) (3) Interest Expense 80 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% INTEREST EXPENSE - BONDS 3,666 46,371 46,371 46,371 0 5,037 36,296 10,074 28 INTEREST EXPENSE - DEFEASED 0 0 0 0 0 0 (69) 69 100 AMORTIZATION OF DEBT DISCOU (554) (6,650) (6,651) (6,651) 0 (554) (3,325) (3,325) 100 Total For Interest Expense: 3,112 39,720 39,720 39,720 0 4,483 32,902 6,818 21 Other Operating Expense LOSS ON DISPOSITION OF PROP (C 9,150 9,150 0 0 0 662 662 8,487 1,282 DAM MAINTENANCE EXPENSE 71 1,555 1,750 1,750 (11) 0 (393) 1,948 495 PENSION EXPENSE 0 0 0 0 0 18,645 18,645 (18,645) (100) OPEB EXPENSE 0 0 0 0 0 0 (44,525) 44,525 100 OTHER INTEREST EXPENSE 94 1,222 0 0 0 182 (244) 1,466 599 INTEREST EXPENSE - METER DEP 4 53 100 100 (47) 2 26 26 96 Total For Other Operating Expense: 9,320 11,980 1,850 1,850 548 19,492 (25,830) 37,810 146 Customer Accounts Expense METER READING EXPENSE 152 2,347 2,500 2,500 (6) 175 2,326 20 1 MISC CUSTOMER ACCOUNTS EXP 6,698 78,909 71,200 71,200 11 5,760 69,886 9,023 13 BAD DEBT EXPENSE & RECOVER 0 28 500 500 (94) 0 0 28 0 Total For Customer Accounts Expense: 6,851 81,285 74,200 74,200 10 5,935 72,212 9,072 13 Administrative Expense SALARIES OFFICE & COMMISSION 19,458 234,315 235,000 235,000 0 12,398 224,435 9,880 4 SALARIES COVID-19 0 0 0 0 0 0 1,791 (1,791) (100) TEMPORARY STAFFING 0 0 1,000 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,107 14,648 23,700 23,700 (38) 554 23,716 (9,068) (38) ELECTRIC & WATER CONSUMPTI 957 7,397 8,000 8,000 (8) 465 6,160 1,237 20 BANK FEES 31 516 700 700 (26) 80 607 (91) (15) LEGAL FEES 404 6,629 8,000 8,000 (17) 399 5,080 1,549 30 AUDITING FEES 375 4,509 4,510 4,510 0 353 4,240 269 6 INSURANCE 256 30,952 27,000 27,000 15 (1,379) 22,128 8,823 40 UTILITY SHARE - DEFERRED COM 890 19,528 28,000 28,000 (30) 1,042 17,722 1,806 10 UTILITY SHARE - MEDICAL/DENT 17,388 223,594 217,000 217,000 3 13,871 189,669 33,925 18 UTILITY SHARE- PERA 4,609 53,758 51,000 51,000 5 4,237 49,360 4,397 9 UTILITY SHARE - FICA 4,589 51,807 49,000 49,000 6 4,074 47,321 4,486 9 EMPLOYEE SICK PAY 1,774 25,591 30,000 30,000 (15) 3,369 26,235 (643) (2) EMPLOYEE HOLIDAY PAY 5,155 24,827 28,000 28,000 (11) 6,717 28,139 (3,311) (12) EMPLOYEE VACATION & PTO PA 3,582 46,185 41,000 41,000 13 3,099 41,535 4,650 11 UPMIC DISTRIBUTION 3,857 13,761 11,000 11,000 25 3,265 11,275 2,486 22 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% WELLHEAD PROTECTION 0 4,724 20,000 20,000 (76) 1,439 3,790 933 25 LONGEVITY PAY 310 620 0 0 0 0 0 620 0 CONSULTING FEES 172 20,055 20,000 20,000 0 17,673 43,887 (23,832) (54) BOND ISSUANCE COSTS 0 0 0 0 0 (3) 0 0 0 TELEPHONE 760 8,770 6,800 6,800 29 677 7,365 1,404 19 ADVERTISING 102 2,933 5,000 5,000 (41) 145 3,791 (858) (23) DUES & SUBSCRIPTIONS - FEES 1,201 75,179 73,615 73,615 2 1,955 106,965 (31,785) (30) SCHOOLS & MEETINGS 2,077 41,804 55,025 55,025 (24) 44 24,356 17,448 72 MTCE OF GENERAL PLANT & OFFI 152 1,828 1,900 1,900 (4) 187 1,828 0 0 Total For Administrative Expense: 69,212 913,942 945,251 945,251 (3) 74,668 891,406 22,536 3 General Expense CIP REBATES - RESIDENTIAL 0 834 4,500 4,500 (81) 65 5,279 (4,445) (84) CIP REBATES - COMMERCIAL 0 0 500 500 (100) 0 0 0 0 CIP - MARKETING 0 613 500 500 23 0 121 491 402 CIP - LABOR 365 4,502 4,700 4,700 (4) 364 4,430 72 2 ENVIRONMENTAL COMPLIANCE 50 1,578 2,200 2,200 (28) 48 952 625 66 M1SC GENERAL EXPENSE 0 0 250 250 (100) (3) 805 (805) (100) Total For General Expense: 415 7,529 12,650 12,650 (40) 474 11,590 (4,060) (35) Total Expenses(before Operating Transfers) 269,561 3,140,045 3,233,895 3,233,895 (3) 380,542 3,209,798 (69,752) (2) Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 539 1,500 1,500 (64) 0 1,258 (719) (57) Total Operating Transfer Total For Total Operating Transfer: 0 539 1,500 1,500 (64) 0 1,258 (719) (57) Net Income Profit(Loss) 610,880 2,342,995 107,673 107,673 2,076 815,985 53 591,158 1,527,010