Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1g ERMUSR 02-14-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 DECEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER ELECT SALES - ELK RIVER RESID ELECT SALES - ELK RIVER NON-D ELECT SALES - ELK RIVER DEMA Total For Elk River: ELECT SALES - OTSEGO RESIDEN ELECT SALES - OTSEGO NON-DEM ELECT SALES - OTSEGO DEMAND Total For Otsego: Rural Big Lake ELECT SALES - BIG LAKE RESIDE ELECT SALES - BIG LAKE NON -DE Total For Rural Big Lake: Dayton ELECT SALES - DAYTON RESIDEN ELECT SALES - DAYTON NON -DE Total For Dayton: Public St & Hwy Lighting ELECT SALES - SEC LTS Total For Public St & Hwy Lighting: Other Electric Sales SUB -STATION CREDIT RATEINCREASE Total For Other Electric Sales: Total Operating Revenue Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME Total For Interest/Dividend Income: Customer Penalties CUSTOMER DELINQUENT PENALT Total For Customer Penalties: 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 1,272,307 13,749,299 13,522,234 13,522,234 2 1,112,629 13,020,814 728,484 6 297,759 3,321,584 3,228,252 3,228,252 3 253,958 3,030,512 291,072 10 1,601,543 20,302,300 19,635,954 19,635,954 3 1,483,100 18,940,232 1,362,067 7 3,171,609 37,373,184 36,386,442 36,386,442 3 2,849,687 34,991,559 2,381,625 7 132,630 1,459,139 1,367,785 1,367,785 7 107,332 1,297,397 161,741 12 39,784 493,846 423,970 423,970 16 34,576 439,205 54,641 12 130,219 1,398,702 1,123,576 1,123,576 24 106,857 1,241,021 157,680 13 302,634 3,351,688 2,915,332 2,915,332 15 248,766 2,977,624 374,064 13 18,919 198,877 206,219 206,219 (4) 16,248 188,172 10,704 6 186 4,681 4,208 4,208 11 175 4,468 212 5 19,105 203,558 210,427 210,427 (3) 16,423 192,641 10,916 6 19,058 209,677 213,485 213,485 (2) 16,297 196,462 13,214 7 3,328 39,738 36,963 36,963 8 3,184 38,223 1,515 4 22,386 249,416 250,448 250,448 0 19,481 234,686 14,729 6 21,728 258,671 250,000 250,000 3 21,214 252,069 6,601 3 21,728 258,671 250,000 250,000 3 21,214 252,069 6,601 3 400 4,800 4,800 4,800 0 400 4,800 0 0 (225,719) 895,668 0 0 0 211,397 773,546 122,122 16 (225,319) 900,468 4,800 4,800 18,660 211,797 778,346 122,122 16 3,312,145 42,336,987 40,017,450 40,017,450 6 39,426,927 2,910,059 7 3,367,370 33,153 (159,502) 80,000 80,000 (299) (69) 52,514 (212,016) (404) 33,153 (159,502) 80,000 80,000 (299) (69) 52,514 (212,016) (404) 17,992 284,452 235,000 235,000 21 0 0 284,452 0 17,992 284,452 235,000 235,000 21 0 0 284,452 0 73 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 Electric DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% LFG Project LFG PROJECT 0 935,004 836,000 836,000 12 77,209 1,019,096 (84,092) (8) Total For LFG Project: 0 935,004 836,000 836,000 12 77,209 1,019,096 (84,092) (8) Connection Fees DISCONNECT & RECONNECT CHA 38,575 243,087 220,000 220,000 10 28,525 263,330 (20,242) (8) Total For Connection Fees: 38,575 243,087 220,000 220,000 10 28,525 263,330 (20,242) (8) Misc Revenue MISC ELEC REVENUE - TEMP CHG 660 5,630 2,000 2,000 182 150 2,612 3,017 116 STREET LIGHT 10,800 23,525 20,000 20,000 18 0 51,590 (28,065) (54) TRANSMISSION INVESTMENTS 93,882 697,070 600,000 600,000 16 53,647 525,384 171,685 33 MISC NON -UTILITY 6,632 187,014 90,000 90,000 108 6,601 102,899 84,115 82 GAIN ON DISPOSITION OF PROPER 0 78,538 0 0 0 0 0 78,538 0 PERA PENSION REVENUE 0 0 0 0 0 4,869 4,869 (4,869) (100) CONTRIBUTIONS FROM CUSTOME 2,319 298,934 175,000 175,000 71 12,885 385,316 (86,381) (22) Total For Mise Revenue: 114,293 1,290,712 887,000 887,000 46 78,154 1,072,671 218,040 20 Total Other Revenue 204,013 2,593,754 2,258,000 2,258,000 15 183,818 2,407,612 186,141 8 Total For Total Other Revenue: 204,013 2,593,754 2,258,000 2,258,000 15 183,818 2,407,612 186,141 8 Total Revenue 3,516,159 42,275,450 44,930,741 42,275,450 6 3,551,189 41,834,539 3,096,201 7 Expenses Purchased Power PURCHASED POWER 2,325,351 31,544,604 27,017,920 27,017,920 17 2,338,094 28,169,145 3,375,458 12 Total For Purchased Power: 2,325,351 31,544,604 27,017,920 27,017,920 17 2,338,094 28,169,145 3,375,458 12 Operating & Mtce Expense OPERATING SUPERVISION 13,805 138,044 143,000 143,000 (3) 8,516 108,275 29,769 27 DIESEL OIL FUEL 729 2,980 10,000 10,000 (70) 851 7,222 (4,242) (59) NATURAL GAS 4,807 20,631 17,500 17,500 18 3,193 23,963 (3,331) (14) ELECTRIC & WATER CONSUMPTI 3,376 32,884 30,000 30,000 10 3,746 28,591 4,293 15 PLANT SUPPLIES & OTHER EXPEN 938 13,912 13,000 13,000 7 1,314 11,401 2,511 22 MISC POWER GENERATION EXPE 911 5,079 8,000 8,000 (37) 207 6,281 (1,202) (19) MAINTENANCE OF STRUCTURE - 1,908 20,294 15,000 15,000 35 1,330 11,633 8,661 74 MTCE OF PLANT ENGINES/GENER 514 11,756 25,000 25,000 (53) 851 37,825 (26,068) (69) MTCE OF PLANT/LAND IMPROVE 9,061 28,086 30,000 30,000 (6) 7,218 24,715 3,371 14 Total For Operating & Mtee Expense: 36,053 273,670 291,500 291,500 (6) 27,230 259,909 13,761 5 74 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 Electric DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% Landfill Gas LANDFILL GAS PLANT PURCHASE 0 136,879 151,794 151,794 (10) 14,892 172,348 (35,469) (21) LANDFILL GAS PLANT OPERATIO (49,546) 346,088 415,187 415,187 (17) 67,223 543,031 (196,943) (36) LANDFILL GAS PLANT ADMINIST 18,798 25,847 25,550 25,550 1 269 5,188 20,659 398 LANDFILL GAS PLANT 1NSURANC (33) 17,501 19,950 19,950 (12) 1,623 19,389 (1,887) (10) LANDFILL GAS PLANT MTCE 140 1,576 650 650 142 55 2,763 (1,187) (43) Total For Landfill Gas: (30,641) 527,893 613,131 613,131 (14) 84,065 742,722 (214,828) (29) Transmission Expense TRANSMISSION MTCE AND EXPE 5,148 63,952 66,700 66,700 (4) 6,110 67,470 (3,518) (5) Total For Transmission Expense: 5,148 63,952 66,700 66,700 (4) 6,110 67,470 (3,518) (5) Distribution Expense REMOVE EXISTING SERVICE & M 104 599 2,500 2,500 (76) 0 397 201 51 SCADA EXPENSE 5,062 42,498 44,000 44,000 (3) 4,991 42,351 146 0 TRANSFORMER EXPENSE OH & U 1,567 13,243 13,000 13,000 2 925 16,107 (2,863) (18) MTCE OF SIGNAL SYSTEMS 57 1,872 2,000 2,000 (6) 395 1,350 522 39 METER EXPENSE- REMOVE & RE 0 582 1,000 1,000 (42) 142 1,495 (912) (61) TEMP SERVICE - INSTALL & REM 419 3,718 2,000 2,000 86 94 2,586 1,132 44 MISC DISTRIBUTION EXPENSE 28,762 321,667 280,000 280,000 15 11,811 243,531 78,136 32 INTERCONNECTION CARRYING C 2,416 2,416 2,416 2,416 0 2,416 2,416 0 0 Total For Distribution Expense: 38,389 386,598 346,916 346,916 11 20,776 310,235 76,363 25 Maintenance Expense MTCE OF STRUCTURES 5,334 30,934 30,000 30,000 3 1,903 25,034 5,899 24 MTCE OF SUBSTATIONS 3,844 60,276 26,000 26,000 132 338 12,180 48,095 395 MTCE OF SUBSTATION EQUIPME 942 42,073 69,000 69,000 (39) 5,222 72,011 (29,937) (42) MTCE OF OH LINES/TREE TRIM 28,060 145,876 225,000 225,000 (35) 1,597 59,360 86,516 146 MTCE OF OH LINES/STANDBY 2,940 33,623 36,000 36,000 (7) 2,676 36,674 (3,051) (8) MTCE OF OH PRIMARY 14,732 190,502 170,000 170,000 12 7,288 152,255 38,246 25 MTCE OF URD PRIMARY 9,816 201,178 165,000 165,000 22 7,535 176,888 24,290 14 LOCATE ELECTRIC LINES 3,354 95,624 105,100 105,100 (9) 5,766 102,561 (6,936) (7) LOCATE FIBER LINES 65 880 1,000 1,000 (12) 0 308 571 185 MTCE OF LINE TRANSFORMERS 5,383 43,183 60,000 60,000 (28) 604 51,790 (8,607) (17) MTCE OF STREET LIGHTING 14,633 66,957 45,000 45,000 49 9,995 24,711 42,245 171 MTCE OF SECURITY LIGHTING 280 21,799 10,000 10,000 118 1,697 13,815 7,984 58 MTCE OF METERS 5,242 77,069 80,000 80,000 (4) 5,025 64,016 13,052 20 VOLTAGE COMPLAINTS 1,763 9,130 10,000 10,000 (9) 142 7,420 1,710 23 75 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 Electric DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% SALARIES TRANSMISSION & DIST 2,388 28,316 30,000 30,000 (6) 2,181 25,935 2,381 9 ELECTRIC MAPPING 17,704 97,145 90,000 90,000 8 8,233 79,158 17,986 23 MTCE OF OH SECONDARY 1,603 21,753 25,000 25,000 (13) 866 19,784 1,968 10 MTCE OF URD SECONDARY 2,229 57,283 50,000 50,000 15 1,899 47,085 10,198 22 TRANSPORTATION EXPENSE 29,895 287,676 240,000 240,000 20 16,741 221,526 66,149 30 Total For Maintenance Expense: 150,218 1,511,286 1,467,100 1,467,100 3 79,716 1,192,521 318,765 27 Depreciation & Amortization DEPRECIATION 209,248 2,364,532 2,436,698 2,436,698 (3) 191,645 2,289,550 74,982 3 AMORTIZATION 55,677 668,135 668,135 668,135 0 55,677 668,135 0 0 Total For Depreciation & Amortization: 264,926 3,032,667 3,104,833 3,104,833 (2) 247,323 2,957,685 74,982 3 Interest Expense INTEREST EXPENSE - BONDS 74,413 907,074 906,275 906,275 0 79,906 818,495 88,579 11 INTEREST EXPENSE - DEFEASED 0 0 0 0 0 0 (276) 276 100 AMORTIZATION OF DEBT DISCOU (4,988) (60,765) (60,765) (60,765) 0 (5,892) (61,309) 543 1 Total For Interest Expense: 69,424 846,308 845,509 845,509 0 74,014 756,909 89,399 12 Other Operating Expense EV CHARGING EXPENSE 411 6,552 4,240 4,240 55 343 4,010 2,541 63 LOSS ON DISPOSITION OF PROP (C 36,600 36,600 12,500 12,500 193 0 45,213 (8,613) (19) OTHER DONATIONS 209 3,891 3,000 3,000 30 258 1,177 2,714 231 DAM MAINTENANCE EXPENSE 0 29 0 0 0 0 0 29 0 MUTUAL AID 3,717 40,408 0 0 0 0 6,860 33,547 489 PENSION EXPENSE 0 0 45,000 45,000 (100) (283,382) (283,382) 283,382 100 OPEB EXPENSE 0 0 0 0 0 0 (208,273) 208,273 100 OTHER INTEREST EXPENSE 378 4,888 0 0 0 730 (980) 5,868 598 INTEREST EXPENSE - METER DEP 168 1,995 2,000 2,000 0 76 890 1,105 124 Total For Other Operating Expense: 41,485 94,365 66,740 66,740 41 (281,973) (434,484) 528,849 122 Customer Accounts Expense METER READING EXPENSE 5,434 49,300 42,100 42,100 17 3,406 44,749 4,551 10 DISCONNECT/RECONNECT EXPEN 1,595 23,546 16,100 16,100 46 1,905 17,106 6,440 38 MISC CUSTOMER ACCOUNTS EXP 23,962 305,794 272,000 272,000 12 22,134 269,231 36,562 14 BAD DEBT EXPENSE & RECOVER (17) 12,993 20,000 20,000 (35) (116) 6,672 6,320 95 Total For Customer Accounts Expense: 30,976 391,634 350,200 350,200 12 27,331 337,759 53,874 16 Administrative Expense SALARIES OFFICE & COMMISSION SALARIES COVID-19 64,436 804,086 860,000 860,000 0 0 0 0 76 (7) 40,728 773,608 30,478 4 0 0 21,040 (21,040) (100) Electric 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 DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% TEMPORARY STAFFING 0 0 4,000 4,000 (100) 0 0 0 0 OFFICE SUPPLIES 5,543 70,262 107,000 107,000 (34) 9,457 74,004 (3,742) (5) ELECTRIC & WATER CONSUMPTI 5,368 32,694 29,000 29,000 13 1,860 24,641 8,052 33 BANK FEES 124 2,002 2,500 2,500 (20) 322 2,380 (377) (16) LEGAL FEES 1,616 26,705 32,000 32,000 (17) 1,692 22,855 3,850 17 AUDITING FEES 1,503 18,039 18,040 18,040 0 1,413 16,960 1,079 6 INSURANCE 5,006 170,663 182,884 182,884 (7) 8,063 152,429 18,234 12 UTILITY SHARE - DEFERRED COM 5,290 112,637 123,500 123,500 (9) 3,720 102,611 10,025 10 UTILITY SHARE - MEDICAUDENT 67,447 859,409 847,000 847,000 1 52,948 759,627 99,781 13 UTILITY SHARE - PERA 24,566 280,969 280,000 280,000 0 22,389 263,991 16,978 6 UTILITY SHARE - FICA 24,238 272,892 265,000 265,000 3 21,901 253,522 19,370 8 EMPLOYEE SICK PAY 7,354 143,224 133,025 133,025 8 13,771 140,780 2,444 2 EMPLOYEE HOLIDAY PAY 28,538 139,307 146,991 146,991 (5) 37,664 152,302 (12,994) (9) EMPLOYEE VACATION & PTO PA 18,820 256,901 231,961 231,961 11 16,545 226,253 30,648 14 UPMIC DISTRIBUTION 18,323 67,353 60,000 60,000 12 16,124 58,665 8,688 15 LONGEVITY PAY 1,240 4,030 0 0 0 0 0 4,030 0 CONSULTING FEES 150 54,841 55,000 55,000 0 44,382 79,398 (24,557) (31) TELEPHONE 3,277 37,510 31,300 31,300 20 2,729 31,253 6,256 20 ADVERTISING 408 12,246 13,000 13,000 (6) 580 13,860 (1,614) (12) DUES & SUBSCRIPTIONS - FEES 9,974 123,151 130,365 130,365 (6) 13,761 230,896 (107,745) (47) SCHOOLS & MEETINGS 16,999 192,986 224,212 224,212 (14) 5,202 118,020 74,966 64 MTCE OF GENERAL PLANT & OFFI 609 7,313 7,500 7,500 (2) 751 7,313 0 0 Total For Administrative Expense: 310,838 3,689,229 3,784,278 3,784,278 (3) 316,011 3,526,417 162,812 5 General Expense CIP REBATES - RESIDENTIAL CIP REBATES - COMMERCIAL CIP - ADMINISTRATION CIP - MARKETING CIP - LABOR CIP REBATES - LOW INCOME CIP - LOW INCOME LABOR ENVIRONMENTAL COMPLIANCE M1SC GENERAL EXPENSE Total For General Expense: Total Expenses(before Operating Transfers) 4,545 60,641 57,907 57,907 5 7,746 49,218 11,422 23 1,525 109,100 232,200 232,200 (53) 21,952 104,250 4,850 5 424 8,415 85,301 85,301 (90) 424 5,418 2,997 55 1,296 29,024 47,000 47,000 (38) 2,454 27,462 1,561 6 13,349 153,297 100,512 100,512 53 10,375 143,124 10,173 7 0 4,185 18,500 18,500 (77) 12,000 18,635 (14,450) (78) 851 10,399 9,750 9,750 7 839 10,474 (74) (1) 2,673 31,920 34,000 34,000 (6) 2,456 32,269 (348) (1) (21) (1,226) 2,500 2,500 (149) (238) 5,574 (6,800) (122) 24,644 405,758 587,670 587,670 (31) 58,012 396,426 9,332 2 77 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 Electric DECEMBER YTD BUDGET BUDGET Bud Var% DECEMBER YTD VARIANCE Actual Var% 3,266,815 42,767,971 38,542,498 38,542,498 11 2,996,712 38,282,718 4,485,252 12 Operating Transfer Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R 127,567 1,531,632 1,455,457 1,455,457 5 114,684 1,407,734 123,898 9 Total For Operating Transfer/Other Funds: 127,567 1,531,632 1,455,457 1,455,457 5 114,684 1,407,734 123,898 9 Utilities & Labor Donated UTILITIES & LABOR DONATED TO 19,563 231,860 230,000 230,000 1 19,268 224,814 7,046 3 Total For Utilities & Labor Donated: 19,563 231,860 230,000 230,000 1 19,268 224,814 7,046 3 Total Operating Transfer Total For Total Operating Transfer: 147,130 1,763,493 1,685,457 1,685,457 5 133,952 1,632,548 130,945 8 Net Income Profit(Loss) 102,213 399,276 2,047,494 2,047,494 (80) 420,524 1,919,272 (1,519,995) (79)