Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 02-13-2024
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% 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/IvIISC 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 TRANSFER IN FROM CITY GAIN ON DISPOSITION OF PROPER MISCELLANEOUS REVENUE HYDRANT MAINTENANCE PROGR CONTRIBUTIONS FROM DEVELOP WATER TOWER LEASE LEASE INTEREST REVENUE Total For Misc Revenue: Total Other Revenue 87,842 1,854,122 1,397,043 1,397,043 33 93,189 1,660,446 193,675 12 52,088 1,048,578 850,022 850,022 23 55,403 926,107 122,470 13 2,622 402,446 256,349 256,349 57 1,563 300,720 101,725 34 142,553 3,305,147 2,503,414 2,503,414 32 150,156 2,887,275 417,871 14 142,553 3,305,147 2,503,414 2,503,414 32 150,156 2,887,275 417,871 14 142,553 3,305,147 2,503,414 2,503,414 32 150,156 2,887,275 417,871 14 13,183 57,359 35,000 35,000 64 8,986 (30,591) 87,951 288 18,000 253,340 450,000 450,000 1,836 24,478 40,000 40,000 5,514 31,255 28,000 28,000 25,350 309,074 518,000 518,000 0 120 50 50 0 0 0 0 88,372 88,372 0 0 0 2,940 0 0 0 258 500 500 975 14,493 13,500 13,500 0 0 65,000 65,000 0 0 296,984 296,984 0 0 0 0 89,347 106,184 376,034 376,034 109 (44) 14400 1547,929 (1294588) (39) 862 57,145 (32,666) 12 3,465 18,220 13,035 (40) 18,727 1,623,295 (1,314,220) 140 40 150 (30) 0 3178 3178 (3178) 0 0 0 88,372 0 0 0 2,940 (48) 0 1019 (761) 7 1,397 13,627 865 (100) 940305 940305 (940305) (100) 65,526 327,431 (327,431) 0 78,451 78,451 (78,451) (72) 1,088,898 1,364,163 (1,257,978) (84) (57) 72 (81) (20) (100) 0 0 (75) 6 (100) (100) (100) (92) ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% Total For Total Other Revenue: Total Revenue Expenses Production Expense MTCE OF STRUCTURES Total For Production Expense: Pumping Expense SUPERVISION ELECTRIC & GAS UTILITIES SAMPLING CHEMICAL FEED MTCE OF ELECTRIC PUMPING EQ MTCE OF WELLS SCADA - PUMPING Total For Pumping Expense: Distribution Expense MTCE OF WATER MAINS LOCATE WATER LINES MTCE OF WATER SERVICES WATER METER SERVICE BACKFLOW DEVICE INSPECTION MTCE OF CUSTOMERS SERVICE WATER MAPPING MTCE OF WATER HYDRANTS - PU MTCE OF WATER HYDRANTS - PR WATER CLOTHING/PPE WAGES WATER TRANSPORTATION EXPENSE WATER PERMIT Total For Distribution Expense: Depreciation & Amortization DEPRECIATION Total For Depreciation & Amortization: 129,386 496,823 958,534 958,534 (48) 1,118,178 2,984,197 (2,487,374) (83) 271,939 3,801,970 3,461,948 3,461,948 10 1,268,334 5,871,472 (2,069,502) (35) 9,176 104,828 90,000 90,000 16 16,832 114,397 (9,568) (8) 9,176 104,828 90,000 90,000 16 16,832 114,397 (9,568) (8) 4,860 63,017 69,000 69,000 (9) 6,141 66,134 (3,116) (5) 18,661 300,994 288,000 288,000 5 20,204 281,124 19,870 7 1,086 17,430 15,000 15,000 16 608 13,093 4,337 33 3,525 46,426 50,000 50,000 (7) 3,151 32,349 14,076 44 0 0 0 0 0 0 46 (46) (100) (2,868) 131,604 165,000 165,000 (20) 20,073 160,129 (28,524) (18) 422 3,576 16,000 16,000 (78) 575 13,807 (10,230) (74) 25,687 563,051 603,000 603,000 (7) 50,754 566,684 (3,632) (1) 2,308 144,453 120,000 120,000 20 13,141 91,488 52,964 58 441 8,898 17,250 17,250 (48) 150 11,045 (2,147) (19) 0 240 0 0 0 0 897 (656) (73) 235 28,604 66,000 66,000 (57) 3,173 72,990 (44,386) (61) 1,123 19,146 16,000 16,000 20 0 10,765 8,380 78 2,586 30,328 30,500 30,500 (1) 2,404 28,317 2,011 7 2,015 17,752 12,500 12,500 42 1,654 12,236 5,515 45 2,990 16,331 19,000 19,000 (14) 4,098 21,980 (5,649) (26) 0 3,665 5,000 5,000 (27) 650 5,104 (1,439) (28) 224 10,352 9,000 9,000 15 29 7,616 2,736 36 526 7,030 7,300 7,300 (4) 1,081 9,340 (2,310) (25) 462 15,781 16,500 16,500 (4) 832 15,427 354 2 0 15,752 18,600 18,600 (15) 0 18,370 (2,617) (14) 12,914 318,337 337,650 337,650 (6) 27,215 305,582 12,755 4 98,879 1,172,659 1,202,937 1,202,937 (3) 104,278 1,117,356 55,302 5 98,879 1,172,659 1,202,937 1,202,937 (3) 104,278 1,117,356 55,302 5 110 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% Interest Expense INTEREST EXPENSE - BONDS 3,466 43,000 43,000 43,000 0 3,666 46,371 (3,371) (7) AMORTIZATION OF DEBT DISCOU (554) (6,650) (6,651) (6,651) 0 (554) (6,650) 0 0 Total For Interest Expense: 2,912 36,349 36,349 36,349 0 3,112 39,720 (3,371) (8) Other Operating Expense LOSS ON DISPOSITION OFPROP (C 0 0 500 500 (100) 9,150 9,150 (9,150) (100) DAM MAINTENANCE EXPENSE 0 1,876 1,750 1,750 7 71 1,555 321 21 PENSION EXPENSE 0 0 0 0 0 68,974 68,974 (68,974) (100) OTHER INTEREST EXPENSE 0 94 95 95 0 94 1,222 (1,127) (92) INTEREST EXPENSE - METER DEP 107 1,262 125 125 910 4 53 1,209 2,283 Total For Other Operating Expense: 107 3,233 2,470 2,470 31 78,294 80,954 (77,720) (96) Customer Accounts Expense METER READING EXPENSE 200 2,238 2,500 2,500 (10) 152 2,347 (108) (5) MISC CUSTOMER ACCOUNTS EXP 7,650 86,414 81,620 81,620 6 6,698 78,909 7,504 10 BAD DEBT EXPENSE & RECOVER 0 (28) 250 250 (111) 0 28 (56) (200) Total For Customer Accounts Expense: 7,850 88,624 84,370 84,370 5 6,851 81,285 7,339 9 Administrative Expense SALARIES OFFICE & COMMISSION 16,848 228,436 268,500 268,500 (15) 19,759 234,617 (6,180) (3) TEMPORARY STAFFING 0 0 1,000 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,135 24,243 25,500 25,500 (5) 1,324 14,865 9,377 63 ELECTRIC & WATER CONSUMPTI 506 7,220 8,000 8,000 (10) 2,139 8,579 (1,359) (16) BANK FEES 72 484 625 625 (23) 31 516 (31) (6) LEGAL FEES 136 4,375 9,000 9,000 (51) 1,114 7,339 (2,963) (40) AUDITING FEES 405 5,655 4,630 4,630 22 375 4,509 1,146 25 INSURANCE 2,991 51,107 36,000 36,000 42 256 30,952 20,154 65 UTILITY SHARE - DEFERRED COM 1,371 21,515 30,500 30,500 (29) 890 19,528 1,986 10 UTILITY SHARE-MEDICAL/DENT 14,111 202,874 215,000 215,000 (6) 3,383 209,590 (6,716) (3) UTILITY SHARE - PERA 4,231 52,775 54,000 54,000 (2) 4,609 53,758 (983) (2) UTILITY SHARE - FICA 4,077 50,873 52,000 52,000 (2) 4,589 51,807 (934) (2) EMPLOYEE SICK PAY 2,511 27,023 27,000 27,000 0 1,853 25,671 1,352 5 EMPLOYEE HOLIDAY PAY 5,423 30,911 30,800 30,800 0 5,155 24,827 6,083 25 EMPLOYEE VACATION & PTO PA 3,667 48,487 44,000 44,000 10 3,582 46,185 2,301 5 UPMIC DISTRIBUTION 5,440 16,408 18,069 18,069 (9) 3,857 13,761 2,646 19 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) 310 620 1,961 316 111 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING DECEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% CONSULTING FEES 1,260 10,266 35,000 35,000 (71) 172 20,055 (9,789) (49) TELEPHONE 728 8,393 9,500 9,500 (12) 891 8,900 (507) (6) ADVERTISING 138 4,116 6,500 6,500 (37) 102 2,933 1,183 40 DUES & SUBSCRIPTIONS - FEES 3,818 73,689 78,320 78,320 (6) 1,564 75,541 (1,852) (2) SCHOOLS & MEETINGS 671 36,361 63,705 63,705 (43) 2,091 41,818 (5,456) (13) MTCE OF GENERAL PLANT & OFFI 250 3,008 1,900 1,900 58 1,244 2,920 87 3 Total For Administrative Expense: 69,797 917,671 1,032,655 1,032,655 (11) 59,297 904,027 13,644 2 General Expense CIP REBATES - RESIDENTIAL 0 1,185 10,500 10,500 (89) 0 834 351 42 CIP REBATES - COMMERCIAL 0 0 500 500 (100) 0 0 0 0 CIP - MARKETING 0 966 500 500 93 0 613 353 58 CIP - LABOR 0 1,288 4,700 4,700 (73) 365 4,502 (3,213) (71) ENVIRONMENTAL COMPLIANCE 47 1,364 2,200 2,200 (38) 50 1,578 (214) (14) MISC GENERAL EXPENSE (644) (669) 250 250 (368) 0 0 (669) 0 Total For General Expense: (597) 4,136 18,650 18,650 (78) 415 7,528 (3,392) (45) Total Expenses(before Operating Transfers) 226,729 3,208,891 3,408,081 3,408,081 (6) 347,052 3,217,536 (8,644) 0 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO CI 0 0 1,500 1,500 (100) 0 539 (539) (100) Total Operating Transfer Total For Total Operating Transfer: 0 0 1,500 1,500 (100) 0 539 (539) (100) Net IncomeProfit(Loss) 45,210 593,078 52,367 52,367 1,033 921,282 2,653,396 (2,060,318) (78) 11N