Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1g ERMUSR 04-11-2023
Electric Revenue Operating Revenue Elk River Otsego ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 FEBRUARY YTD BUDGET BUDGET BudVar% FEBRUARY ELECT SALES - ELK RIVER RESID ELECT SALES - ELK RIVER NON-D ELECT SALES - ELK RIVER DEMA PCA SALES REVENUE- ELK RIVE PCA SALES REVENUE - ELK RIVE PCA SALES REVENUE - ELK RIVE Total For Elk River: ELECT SALES - OTSEGO RESIDEN ELECT SALES - OTSEGO NON-DEM ELECT SALES - OTSEGO DEMAND PCA SALES REVENUE - OTSEGO R PCA SALES REVENUE - OTSEGO N PCA SALES REVENUE - OTSEGO D Total For Otsego: Rural Big Lake ELECT SALES - BIG LAKE RESIDE ELECT SALES - BIG LAKE NON -DE PCA SALES REVENUE - BIG LAKE PCA SALES REVENUE - BIG LAKE Total For Rural Big Lake: Dayton ELECT SALES - DAYTON RESIDEN ELECT SALES - DAYTON NON -DE PCA SALES REVENUE - DAYTON R PCA SALES REVENUE - DAYTON Total For Dayton: Public St & Hwy Lighting ELECT SALES - SEC LTS Total For Public St & Hwy Lighting: Other Electric Sales SUB -STATION CREDIT RATE INCREASE 1,229,836 315,395 1,383,186 96,231 27,077 157,452 3,209,179 135,325 39,042 117,233 10,425 3,408 13,424 318,858 19,419 180 1,536 8 21,144 20,081 3,371 1,545 263 25,261 21,723 21,723 2,299,334 588,687 2,673,376 153,762 43,165 256,421 6,014,746 246,219 69,094 212,075 16,255 5,180 20,367 569,192 35,442 334 2,406 12 38,195 36,187 5,995 2,390 398 44,972 43,446 43,446 2,122,381 516,292 2,703,276 217,678 58,620 408,718 6,026,969 202,058 56,260 158,704 20,722 6,387 24,222 468,355 33,682 297 3,454 33 37,468 34,791 5,760 3,566 654 44,772 43,333 43,333 400 800 800 0 0 170 0 14,039,146 3,461,850 20,243,229 1,285,399 340,814 2,670,887 42,041,326 1,420,072 454,649 1,180,452 129,685 44,260 156,538 3,385,657 214,102 4,513 19,622 420 238,658 221,646 39,638 20,286 3,900 285,471 260,000 260,000 4,800 0 8 14 (29) (26) (37) 0 22 23 34 (22) (19) (16) 22 5 12 (30) (62) 2 4 4 (33) (39) 0 0 0 0 0 2022 YTD 1,050,961 2,078,563 253,959 495,373 1,374,571 2,711,165 0 0 0 0 0 0 2,679,491 5,285,102 105,665 207,617 31,945 61,110 96,342 188,047 0 0 0 0 0 0 233,953 456,775 16,007 31,287 155 308 0 0 0 0 16,163 31,596 16,853 32,912 2,973 5,774 0 0 0 0 19,827 38,687 21,474 42,776 21,474 42,776 400 800 72,390 72,390 YTD 2022 v. 2023 VARIANCE Actual Var% 220,770 93,313 (37,789) 153,762 43,165 256,421 729,643 38,602 7,983 24,028 16,255 5,180 20,367 112,416 4,154 25 2,406 12 6,599 3,274 220 2,390 398 6,284 670 670 0 (72,390) ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% Total For Other Electric Sales: 400 800 800 4,800 0 72,790 73,190 (72,390) (99) Total Operating Revenue 3,596,567 6,711,353 6,621,698 46,215,912 1 3,043,701 5,928,129 783,223 13 Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME (966) 8,466 8,333 50,000 2 (24,977) (42,996) 51,462 120 Total For Interest/Dividend Income: (966) 8,466 8,333 50,000 2 (24,977) (42,996) 51,462 120 Customer Penalties CUSTOMER DELINQUENT PENALT 26,784 48,657 41,666 250,000 17 20,881 20,881 27,776 133 Total For Customer Penalties: 26,784 48,657 41,666 250,000 17 20,881 20,881 27,776 133 LFG Project LFG PROJECT 0 0 0 0 0 80,865 173,258 (173,258) (100) Total For LFG Project: 0 0 0 0 0 80,865 173,258 (173,258) (100) Connection Fees DISCONNECT & RECONNECT CHA 10,026 16,301 36,666 220,000 (56) 15,635 28,085 (11,783) (42) Total For Connection Fees: 10,026 16,301 36,666 220,000 (56) 15,635 28,085 (11,783) (42) Misc Revenue MISC ELEC REVENUE - TEMP CHG 0 1,070 333 2,000 221 0 300 770 257 STREET LIGHT 0 0 0 20,000 0 125 125 (125) (100) TRANSMISSION INVESTMENTS 49,982 106,682 108,205 649,231 (1) 45,090 93,504 13,177 14 MISC NON -UTILITY 13,772 23,313 15,000 90,000 55 12,943 20,245 3,068 15 CONTRIBUTIONS FROM CUSTOME 0 0 29,166 175,000 (100) 0 0 0 0 Total For Misc Revenue: 63,754 131,066 152,705 936,231 (14) 58,158 114,174 16,891 15 Total Other Revenue 99,598 204,491 239,371 1,456,231 (15) 150,563 293,403 (88,911) (30) Total For Total Other Revenue: 99,598 204,491 239,371 1,456,231 (15) 150,563 293,403 (88,911) (30) Total Revenue 6,861,070 3,696,165 6,915,844 47,672,143 1 3,194,264 6,221,532 694,312 11 Expenses Purchased Power PURCHASED POWER 1,583,719 3,279,354 3,434,236 24,207,981 (5) 2,304,997 4,663,371 (1,384,016) (30) ENERGY ADJUSTMENT CLAUSE 566,550 1,086,364 1,358,054 8,558,044 (20) 0 0 1,086,364 0 Total For Purchased Power: 2,150,269 4,365,719 4,792,291 32,766,025 (9) 2,304,997 4,663,371 (297,651) (6) Operating & Mtce Expense OPERATING SUPERVISION 9,551 19,962 22,833 137,000 (13) 9,201 18,082 1,879 10 171 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% DIESEL OIL FUEL 1,360 1,862 1,666 10,000 12 288 1,170 691 59 NATURAL GAS 5,863 12,596 8,000 25,000 57 3,548 7,195 5,401 75 ELECTRIC& WATER CONSUMPTI 3,040 7,335 8,800 34,000 (17) 4,119 8,462 (1,127) (13) PLANT SUPPLIES & OTHER EXPEN 688 7,031 2,166 13,000 224 127 1,007 6,024 598 MISC POWER GENERATION EXPE 417 1,061 1,333 8,000 (20) 400 909 151 17 MAINTENANCE OF STRUCTURE- 1,117 4,078 3,333 20,000 22 687 1,920 2,158 112 MTCE OF PLANT ENGINES/GENER 3,633 5,351 6,500 39,000 (18) 1,023 1,360 3,990 293 MTCE OF PLANT/LAND IMPROVE 4,188 14,314 13,000 35,000 10 2,271 6,948 7,366 106 Total For Operating & Mtce Expense: 29,861 73,594 67,633 321,000 9 21,669 47,057 26,537 56 Landfill Gas LANDFILL GAS PLANT PURCHASE 0 0 0 0 0 11,366 25,215 (25,215) (100) LANDFILL GAS PLANT OPERATIO 0 0 0 0 0 41,518 83,037 (83,037) (100) LANDFILL GAS PLANT ADMINIST 0 0 0 0 0 194 424 (424) (100) LANDFILL GAS PLANT 1NSURANC 0 0 0 0 0 1,623 3,247 (3,247) (100) LANDFILL GAS PLANT MTCE 0 0 0 0 0 62 125 (125) (100) Total For Landfill Gas: 0 0 0 0 0 54,766 112,050 (112,050) (100) Transmission Expense TRANSMISSION MTCE AND EXPE 4,190 9,308 11,666 70,000 (20) 5,172 13,424 (4,116) (31) Total For Transmission Expense: 4,190 9,308 11,666 70,000 (20) 5,172 13,424 (4,116) (31) Distribution Expense REMOVE EXISTING SERVICE & M 0 0 175 1,050 (100) 0 0 0 0 SCADA EXPENSE 2,747 5,621 7,333 44,000 (23) 2,789 5,444 177 3 TRANSFORMER EXPENSE OH & U 2,428 3,506 2,500 15,000 40 919 2,008 1,497 75 MTCE OF SIGNAL SYSTEMS 338 338 333 2,000 2 97 97 241 249 METER EXPENSE - REMOVE & RE 0 0 250 1,500 (100) 194 194 (194) (100) TEMP SERVICE - INSTALL & REM 93 93 583 3,500 (84) 0 186 (93) (50) MISC DISTRIBUTION EXPENSE 32,979 61,465 50,000 300,000 23 25,213 52,922 8,543 16 INTERCONNECTION CARRYING C 0 0 0 2,416 0 0 0 0 0 Total For Distribution Expense: 38,586 71,025 61,175 369,466 16 29,213 60,853 10,171 17 Maintenance Expense MTCE OF STRUCTURES 6,764 7,835 7,666 46,000 2 1,962 3,925 3,909 100 MTCE OF SUBSTATIONS 2,973 9,676 5,833 35,000 66 128 128 9,547 7,401 MTCE OF SUBSTATION EQUIPME 2,632 4,231 12,833 77,000 (67) 6,545 10,476 (6,244) (60) MTCE OF OH LINES/TREE TRIM 34,248 76,473 100,000 225,000 (24) 8,541 29,149 47,324 162 MTCE OF OH LINES/STANDBY 3,177 5,911 6,666 40,000 (11) 2,608 5,711 200 4 172 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% MTCE OF OH PRIMARY 7,656 17,843 28,333 170,000 (37) 10,082 18,820 (977) (5) MTCE OF URD PRIMARY 6,865 15,458 28,333 170,000 (45) 14,087 20,854 (5,396) (26) LOCATE ELECTRIC LINES 1,063 2,479 17,666 106,000 (86) 3,196 5,659 (3,179) (56) LOCATE FIBER LINES 33 33 166 1,000 (80) 0 130 (96) (74) MTCE OF LINE TRANSFORMERS 661 2,016 10,000 60,000 (80) 1,862 2,951 (934) (32) MTCE OF STREET LIGHTING (3,528) 1,331 7,500 45,000 (82) (3,922) 3,529 (2,197) (62) MTCE OF SECURITY LIGHTING 781 2,456 2,500 15,000 (2) 995 2,048 407 20 MTCE OF METERS 3,864 10,552 14,166 85,000 (26) 6,849 14,617 (4,064) (28) VOLTAGE COMPLAINTS 1,455 2,747 1,666 10,000 65 93 1,007 1,739 173 SALARIES TRANSMISSION & DIST 2,187 4,585 5,083 30,500 (10) 2,310 4,479 105 2 ELECTRIC MAPPING 17,573 36,982 15,833 95,000 134 11,994 26,222 10,760 41 MTCE OF OH SECONDARY 1,224 3,306 4,166 25,000 (21) 2,011 2,890 415 14 MTCE OF URD SECONDARY 1,010 4,763 10,000 60,000 (52) 3,427 6,329 (1,566) (25) TRANSPORTATION EXPENSE 28,684 49,958 40,833 245,000 22 20,203 52,154 (2,196) (4) Total For Maintenance Expense: 119,330 258,644 319,250 1,540,500 (19) 92,978 211,086 47,557 23 Depreciation & Amortization DEPRECIATION 208,195 417,546 418,702 2,552,700 0 194,423 388,455 29,091 7 AMORTIZATION 55,677 111,355 111,356 668,136 0 55,677 111,355 0 0 Total For Depreciation & Amortization: 263,873 528,902 530,058 3,220,836 0 250,101 499,810 29,091 6 Interest Expense INTEREST EXPENSE - BONDS 73,213 147,626 147,626 870,695 0 75,850 155,757 (8,131) (5) AMORTIZATION OF DEBT DISCOU (4,988) (9,977) (9,977) (59,863) 0 (4,988) (10,880) 903 8 Total For Interest Expense: 68,224 137,649 137,649 810,832 0 70,862 144,876 (7,227) (5) Other Operating Expense EV CHARGING EXPENSE 342 631 1,288 7,731 (51) 351 895 (263) (29) LOSS ON DISPOSITION OF PROP (C 0 0 0 15,500 0 0 0 0 0 OTHER DONATIONS 0 0 500 3,000 (100) 97 366 (366) (100) PENSION EXPENSE 0 0 0 45,000 0 0 0 0 0 OTHER INTEREST EXPENSE 0 378 378 378 0 378 1,108 (730) (66) INTEREST EXPENSE - METER DEP 3,912 7,815 416 2,500 1,774 163 325 7,489 2,297 Total For Other Operating Expense: 4,255 8,824 2,583 74,109 242 990 2,694 6,129 227 Customer Accounts Expense METER READING EXPENSE 3,068 5,915 7,833 47,000 (24) 2,856 6,693 (777) (12) DISCONNECT/RECONNECT EXPEN 1,313 2,577 3,666 22,000 (30) 1,452 2,490 86 3 MISC CUSTOMER ACCOUNTS EXP 24,937 52,654 52,083 312,500 1 23,134 45,791 6,862 15 173 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% BAD DEBT EXPENSE & RECOVER 31 119 3,333 20,000 (96) 848 1,094 (974) (89) Total For Customer Accounts Expense: 29,351 61,266 66,916 401,500 (8) 28,292 56,070 5,196 9 Administrative Expense SALARIES OFFICE & COMMISSION 62,269 129,674 158,333 950,000 (18) 60,647 119,331 10,342 9 TEMPORARY STAFFING 0 0 666 4,000 (100) 0 0 0 0 OFFICE SUPPLIES 17,047 27,855 17,833 107,000 56 5,137 9,122 18,732 205 ELECTRIC & WATER CONSUMPTI 5,199 11,394 4,833 29,000 136 1,785 3,578 7,815 218 BANK FEES 182 319 416 2,500 (24) 191 366 (47) (13) LEGAL FEES 1,302 3,662 6,666 40,000 (45) 2,696 4,426 (763) (17) AUDITING FEES 1,623 3,246 3,086 18,520 5 1,503 3,006 240 8 INSURANCE 16,356 32,712 31,000 186,000 6 13,262 26,525 6,186 23 UTILITY SHARE - DEFERRED COM 14,362 34,528 20,666 124,000 67 14,844 33,103 1,425 4 UTILITY SHARE- MEDICAL/DENT 52,706 241,945 248,043 858,481 (2) 57,767 228,814 13,131 6 UTILITY SHARE - PERA 21,509 45,039 48,000 288,000 (6) 19,404 39,644 5,394 14 UTILITY SHARE - FICA 20,531 43,109 46,666 280,000 (8) 18,486 37,897 5,212 14 EMPLOYEE SICK PAY 12,019 42,506 25,000 150,000 70 10,709 32,649 9,856 30 EMPLOYEE HOLIDAY PAY 13,835 43,372 42,954 157,500 1 12,259 25,174 18,197 72 EMPLOYEE VACATION & PTO PA 19,634 63,749 60,000 250,000 6 20,899 56,900 6,848 12 UPMIC DISTRIBUTION 0 0 0 91,015 0 0 0 0 0 LONGEVITY PAY 0 0 0 16,369 0 0 0 0 0 CONSULTING FEES 0 0 13,333 80,000 (100) 6,355 13,079 (13,079) (100) TELEPHONE 2,836 6,331 6,833 41,000 (7) 2,783 5,529 802 15 ADVERTISING 1,272 2,553 2,500 15,000 2 682 2,161 392 18 DUES & SUBSCRIPTIONS - FEES 9,449 19,334 28,779 172,675 (33) 9,063 17,748 1,585 9 SCHOOLS & MEETINGS 15,636 21,186 46,500 259,925 (54) 11,017 26,221 (5,034) (19) MTCE OF GENERAL PLANT & OFFI 1,002 2,005 1,266 7,600 58 609 1,218 786 64 Total For Administrative Expense: 288,777 774,528 813,380 4,128,585 (5) 270,107 686,502 88,025 13 General Expense CIP REBATES - RESIDENTIAL 4,395 6,950 16,695 100,170 (58) 3,691 9,730 (2,780) (29) CIP REBATES - COMMERCIAL 10,413 21,393 31,597 189,583 (32) 0 4,633 16,760 362 CIP - ADMINISTRATION 1,069 1,572 3,283 19,700 (52) 424 889 683 77 CIP - MARKETING 1,394 5,975 5,006 30,039 19 806 2,591 3,383 131 CIP - LABOR 11,510 23,798 29,751 178,511 (20) 11,247 21,634 2,164 10 CIP REBATES - LOW INCOME 0 0 3,000 18,000 (100) 0 4,185 (4,185) (100) CIP - LOW INCOME LABOR 815 1,637 1,647 9,887 (1) 856 1,684 (46) (3) 174 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING FEBRUARY 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric FEBRUARY YTD BUDGET BUDGET Bud Var% FEBRUARY YTD VARIANCE Actual Var% ENVIRONMENTAL COMPLIANCE 2,576 5,154 5,703 34,219 (10) 2,497 4,996 158 3 MISC GENERAL EXPENSE 0 5,826 416 2,500 1,297 (2) (4) 5,830 145,775 Total For General Expense: 32,174 72,308 97,101 582,609 (26) 19,521 50,340 21,968 44 Total Expenses(before Operating Transfers) 3,028,896 6,361,771 6,899,705 44,285,462 (8) 3,148,673 6,548,139 (186,367) (3) Operating Transfer Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R 138,519 263,747 241,078 1,681,653 9 113,832 224,681 39,065 17 Total For Operating Transfer/Other Funds: 138,519 263,747 241,078 1,681,653 9 113,832 224,681 39,065 17 Utilities & Labor Donated UTILITIES & LABOR DONATED TO 19,233 39,646 40,000 240,000 (1) 18,629 37,448 2,198 6 Total For Utilities & Labor Donated: 19,233 39,646 40,000 240,000 (1) 18,629 37,448 2,198 6 Total Operating Transfer Total For Total Operating Transfer: 157,753 303,393 281,078 1,921,653 8 132,462 262,130 41,263 16 Net Income Profit(Loss) 509,515 250,679 (319,713) 1,465,028 178 839,416 143 (86,871) (588,737) 175