Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1g ERMUSR 05-09-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 Electric MARCH YTD BUDGET BUDGET Bud Var% MARCH Revenue Operating Revenue Elk River 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: Otsego 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 2022 YTD 2022 v. 2023 YTD VARIANCE Actual Var% 1,013,930 3,313,265 3,139,782 14,039,146 6 996,396 3,074,960 238,305 8 286,864 875,551 775,107 3,461,850 13 248,328 743,702 131,849 18 1,327,013 4,000,389 4,070,256 20,243,229 (2) 1,370,969 4,082,134 (81,744) (2) 98,913 252,675 320,071 1,285,399 (21) 0 0 252,675 0 31,126 74,291 87,759 340,814 (15) 0 0 74,291 0 189,280 445,701 637,679 2,670,887 (30) 0 0 445,701 0 2,947,128 8,961,874 9,030,657 42,041,326 (1) 2,615,693 7,900,796 1,061,078 13 106,586 352,806 301,304 1,420,072 17 101,976 309,594 43,212 14 31,500 100,594 86,413 454,649 16 32,752 93,863 6,731 7 95,819 307,894 239,891 1,180,452 28 96,197 284,244 23,650 8 10,108 26,363 30,710 129,685 (14) 0 0 26,363 0 3,411 8,591 9,782 44,260 (12) 0 0 8,591 0 13,273 33,640 36,500 156,538 (8) 0 0 33,640 0 260,699 829,891 704,603 3,385,657 18 230,926 687,701 142,189 21 14,748 50,190 50,286 214,102 0 15,422 46,710 3,480 7 163 497 447 4,513 11 155 464 33 7 1,439 3,845 5,125 19,622 (25) 0 0 3,845 0 8 20 50 420 (59) 0 0 20 0 16,360 54,555 55,909 238,658 (2) 15,578 47,174 7,380 16 15,542 51,730 52,159 221,646 (1) 16,430 49,343 2,387 5 2,734 8,730 8,723 39,638 0 2,971 8,746 (15) 0 1,470 3,861 5,312 20,286 (27) 0 0 3,861 0 257 655 987 3,900 (34) 0 0 655 0 20,004 64,977 67,184 285,471 (3) 19,401 58,089 6,888 12 21,261 64,707 65,000 260,000 0 21,491 64,267 439 1 21,261 64,707 65,000 260,000 0 21,491 64,267 439 1 400 1,200 1,200 4,800 0 400 1,200 0 0 0 0 72 0 0 0 353,450 425,841 (425,841) (100) ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var% Total For Other Electric Sales: 400 1,200 1,200 4,800 0 353,850 427,041 (425,841) (100) Total Operating Revenue 3,265,853 9,977,206 9,924,554 46,215,912 1 3,256,941 9,185,070 792,135 9 Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME 9,434 17,900 12,500 50,000 43 (45,493) (88,489) 106,390 120 Total For Interest/Dividend Income: 9,434 17,900 12,500 50,000 43 (45,493) (88,489) 106,390 120 Customer Penalties CUSTOMER DELINQUENT PENALT 25,220 73,877 62,499 250,000 18 23,492 44,374 29,503 66 Total For Customer Penalties: 25,220 73,877 62,499 250,000 18 23,492 44,374 29,503 66 LFG Project LFG PROJECT 0 0 0 0 0 65,294 238,552 (238,552) (100) Total For LFG Project: 0 0 0 0 0 65,294 238,552 (238,552) (100) Connection Fees DISCONNECT & RECONNECT CHA 7,832 24,133 54,999 220,000 (56) 7,580 35,665 (11,531) (32) Total For Connection Fees: 7,832 24,133 54,999 220,000 (56) 7,580 35,665 (11,531) (32) Misc Revenue MISC ELEC REVENUE - TEMP CHG 1,749 2,819 500 2,000 464 370 670 2,149 321 STREET LIGHT 0 0 5,000 20,000 (100) 0 125 (125) (100) TRANSMISSION INVESTMENTS 47,947 154,630 162,307 649,231 (5) 43,940 137,444 17,185 13 MISC NON -UTILITY 14,036 37,349 22,500 90,000 66 8,792 29,037 8,312 29 GAIN ON DISPOSITION OF PROPER 0 0 0 0 0 22,750 22,750 (22,750) (100) CONTRIBUTIONS FROM CUSTOME 18,027 18,027 43,749 175,000 (59) 0 0 18,027 0 Total For Misc Revenue: 81,760 212,826 234,057 936,231 (9) 75,852 190,027 22,799 12 Total Other Revenue 124,247 328,738 364,057 1,456,231 (10) 126,725 420,129 (91,390) (22) Total For Total Other Revenue: 124,247 328,738 364,057 1,456,231 (10) 126,725 420,129 (91,390) (22) Total Revenue 3,390,100 10,288,611 0 7 10,305,944 47,672,143 3,383,667 9,605,200 700,744 Expenses Purchased Power PURCHASED POWER 1,641,590 4,920,944 5,169,400 24,207,981 (5) 2,299,042 6,962,413 (2,041,468) (29) ENERGY ADJUSTMENT CLAUSE 690,265 1,776,630 2,069,471 8,558,044 (14) 0 0 1,776,630 0 Total For Purchased Power: 2,331,855 6,697,575 7,238,871 32,766,025 (7) 2,299,042 6,962,413 (264,837) (4) Operating & Mtce Expense 73 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var%o OPERATING SUPERVISION 11,662 31,624 34,250 137,000 (8) 9,252 27,335 4,289 16 DIESEL OIL FUEL 813 2,676 2,499 10,000 7 76 1,246 1,429 115 NATURAL GAS 6,051 18,647 10,500 25,000 78 2,175 9,371 9,276 99 ELECTRIC & WATER CONSUMPTI 12,469 19,804 12,300 34,000 61 3,247 11,710 8,094 69 PLANT SUPPLIES & OTHER EXPEN 6,878 13,909 3,249 13,000 328 299 1,306 12,602 964 MISC POWER GENERATION EXPE 810 1,871 2,000 8,000 (6) 571 1,481 390 26 MAINTENANCE OF STRUCTURE - 3,500 7,579 5,000 20,000 52 2,906 4,827 2,752 57 MTCE OF PLANT ENGINES/GENER 4,906 10,258 9,750 39,000 5 2,792 4,153 6,104 147 MTCE OF PLANT/LAND IMPROVE 5,141 19,456 16,000 35,000 22 1,276 8,224 11,231 137 Total For Operating & Mtce Expense: 52,233 125,828 95,550 321,000 32 22,599 69,657 56,171 81 Landfill Gas LANDFILL GAS PLANT PURCHASE 0 0 0 0 0 10,224 35,440 (35,440) (100) LANDFILL GAS PLANT OPERATIO 0 0 0 0 0 41,518 124,556 (124,556) (100) LANDFILL GAS PLANT ADMINIST 0 0 0 0 0 246 671 (671) (100) LANDFILL GAS PLANT INSURANC 0 0 0 0 0 1,623 4,871 (4,871) (100) LANDFILL GAS PLANT MTCE 0 0 0 0 0 168 294 (294) (100) Total For Landfill Gas: 0 0 0 0 0 53,782 165,833 (165,833) (100) Transmission Expense TRANSMISSION MTCE AND EXPE 5,361 14,669 17,499 70,000 (16) 5,348 18,772 (4,103) (22) Total For Transmission Expense: 5,361 14,669 17,499 70,000 (16) 5,348 18,772 (4,103) (22) Distribution Expense REMOVE EXISTING SERVICE & M 542 542 262 1,050 106 0 0 542 0 SCADA EXPENSE 5,556 11,177 11,000 44,000 2 5,135 10,579 598 6 TRANSFORMER EXPENSE OH & U 1,332 4,838 3,750 15,000 29 845 2,854 1,984 70 MTCE OF SIGNAL SYSTEMS 270 609 500 2,000 22 57 154 454 293 METER EXPENSE - REMOVE & RE 100 100 375 1,500 (73) 81 275 (174) (63) TEMP SERVICE - INSTALL & REM 3,390 3,483 875 3,500 298 0 186 3,296 1,763 MISC DISTRIBUTION EXPENSE 71,639 133,104 75,000 300,000 77 41,158 94,080 39,023 41 INTERCONNECTION CARRYING C 0 0 0 2,416 0 0 0 0 0 Total For Distribution Expense: 82,831 153,856 91,762 369,466 68 47,277 108,131 45,725 42 Maintenance Expense MTCE OF STRUCTURES 3,952 11,787 11,499 46,000 2 2,092 6,017 5,769 96 MTCE OF SUBSTATIONS 3,532 13,208 8,750 35,000 51 346 475 12,733 2,681 MTCE OF SUBSTATION EQUIPME 3,077 7,308 19,250 77,000 (62) 7,239 17,715 (10,407) (59) MTCE OF OH LINES/TREE TRIM 59,440 135,913 150,000 225,000 (9) 64,068 93,218 42,695 46 74 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var% MTCE OF OH LINES/STANDBY 2,889 8,800 9,999 40,000 (12) 2,752 8,464 336 4 MTCE OF OH PRIMARY 22,112 39,955 42,500 170,000 (6) 9,906 28,727 11,228 39 MTCE OF URD PRIMARY 12,708 28,167 42,500 170,000 (34) 20,615 41,469 (13,302) (32) LOCATE ELECTRIC LINES 8,329 10,808 26,499 106,000 (59) 7,841 13,500 (2,691) (20) LOCATE FIBER LINES 0 33 249 1,000 (86) 0 130 (96) (74) MTCE OF LINE TRANSFORMERS 886 2,903 15,000 60,000 (81) 2,733 5,684 (2,781) (49) MTCE OF STREET LIGHTING 5,239 6,571 11,250 45,000 (42) 2,506 6,035 535 9 MTCE OF SECURITY LIGHTING 1,867 4,323 3,750 15,000 15 1,667 3,716 607 16 MTCE OF METERS 5,061 15,614 21,249 85,000 (27) 5,883 20,501 (4,886) (24) VOLTAGE COMPLAINTS 439 3,186 2,499 10,000 27 280 1,287 1,898 147 SALARIES TRANSMISSION & DIST 2,713 7,299 7,625 30,500 (4) 2,209 6,689 609 9 ELECTRIC MAPPING 17,294 54,277 23,750 95,000 129 7,827 34,049 20,228 59 MTCE OF OH SECONDARY 1,057 4,364 6,249 25,000 (30) 845 3,736 627 17 MTCE OF URD SECONDARY 5,406 10,169 15,000 60,000 (32) 2,861 9,191 978 11 TRANSPORTATION EXPENSE 44,819 94,777 61,250 245,000 55 29,227 81,382 13,395 16 Total For Maintenance Expense: 200,829 459,473 478,875 1,540,500 (4) 170,907 381,994 77,479 20 Depreciation & Amortization DEPRECIATION 208,101 625,647 628,053 2,552,700 0 194,293 582,748 42,899 7 AMORTIZATION 55,677 167,033 167,034 668,136 0 55,677 167,033 0 0 Total For Depreciation & Amortization: 263,778 792,681 795,087 3,220,836 0 249,971 749,781 42,899 6 Interest Expense INTEREST EXPENSE - BONDS 73,213 220,839 220,839 870,695 0 75,850 231,607 (10,768) (5) AMORTIZATION OF DEBT DISCOU (4,988) (14,965) (14,965) (59,863) 0 (4,988) (15,869) 903 6 Total For Interest Expense: 68,224 205,873 205,873 810,832 0 70,862 215,738 (9,864) (5) Other Operating Expense EV CHARGING EXPENSE (424) 206 1,932 7,731 (89) 413 1,308 (1,101) (84) LOSS ON DISPOSITION OF PROP (C 0 0 0 15,500 0 0 0 0 0 OTHER DONATIONS 0 0 750 3,000 (100) (667) (301) 301 100 PENSION EXPENSE 0 0 0 45,000 0 0 0 0 0 OTHER INTEREST EXPENSE 0 378 378 378 0 378 1,486 (1,108) (75) INTEREST EXPENSE - METER DEP 3,913 11,729 624 2,500 1,777 165 491 11,238 2,289 Total For Other Operating Expense: 3,489 12,314 3,685 74,109 234 289 2,984 9,330 313 Customer Accounts Expense METER READING EXPENSE 3,198 9,114 11,750 47,000 (22) 4,152 10,845 (1,731) (16) DISCONNECT/RECONNECT EXPEN 1,542 4,119 5,499 22,000 (25) 1,888 4,378 (259) (6) 75 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var% MISC CUSTOMER ACCOUNTS EXP 27,579 80,233 78,125 312,500 3 23,380 69,171 11,062 16 BAD DEBT EXPENSE & RECOVER 1,693 1,813 5,000 20,000 (64) 159 1,253 559 45 Total For Customer Accounts Expense: 34,014 95,281 100,375 401,500 (5) 29,579 85,649 9,631 11 Administrative Expense SALARIES OFFICE & COMMISSION 76,000 205,674 237,500 950,000 (13) 66,573 185,905 19,769 11 TEMPORARY STAFFING 0 0 999 4,000 (100) 0 0 0 0 OFFICE SUPPLIES 10,141 37,996 26,750 107,000 42 9,948 19,071 18,925 99 ELECTRIC & WATER CONSUMPTI (4,646) 6,747 7,250 29,000 (7) 1,794 5,372 1,374 26 BANK FEES 141 460 624 2,500 (26) 164 530 (69) (13) LEGAL FEES 3,445 7,108 9,999 40,000 (29) 2,046 6,472 636 10 AUDITING FEES 1,623 4,869 4,629 18,520 5 1,503 4,509 360 8 INSURANCE 16,356 49,069 46,500 186,000 6 13,262 39,788 9,280 23 UTILITY SHARE - DEFERRED COM 16,877 51,406 30,999 124,000 66 11,726 44,830 6,576 15 UTILITY SHARE - MEDICAUDENT 59,564 301,509 309,087 858,481 (2) 60,605 289,419 12,090 4 UTILITY SHARE - PERA 24,976 70,015 72,000 288,000 (3) 23,433 63,078 6,937 11 UTILITY SHARE - FICA 23,934 67,044 69,999 280,000 (4) 22,680 60,578 6,466 11 EMPLOYEE SICK PAY 14,357 56,864 37,500 150,000 52 14,732 47,382 9,482 20 EMPLOYEE HOLIDAY PAY 0 43,372 42,954 157,500 1 0 25,174 18,197 72 EMPLOYEE VACATION & PTO PA 28,574 92,324 79,000 250,000 17 13,258 70,159 22,165 32 UPMIC DISTRIBUTION 20,521 20,521 22,753 91,015 (10) 10,576 10,576 9,944 94 LONGEVITY PAY 1,923 1,923 1,924 16,369 0 0 0 1,923 0 CONSULTING FEES 0 0 20,000 80,000 (100) 13,318 26,397 (26,397) (100) TELEPHONE 3,445 9,776 10,250 41,000 (5) 2,992 8,521 1,254 15 ADVERTISING 1,296 3,849 3,750 15,000 3 1,241 3,403 446 13 DUES & SUBSCRIPTIONS - FEES 10,005 29,339 43,168 172,675 (32) 11,587 29,336 3 0 SCHOOLS & MEETINGS 22,236 43,423 78,500 259,925 (45) 27,196 53,417 (9,994) (19) MTCE OF GENERAL PLANT & OFFI 1,002 3,008 1,899 7,600 58 609 1,828 1,179 65 Total For Administrative Expense: 331,779 1,106,308 1,158,043 4,128,585 (4) 309,252 995,755 110,553 11 General Expense CIP REBATES - RESIDENTIAL 3,265 10,215 25,042 100,170 (59) 3,777 13,507 (3,292) (24) CIP REBATES - COMMERCIAL 6,000 27,393 47,395 189,583 (42) 6,050 10,683 16,710 156 CIP - ADMINISTRATION 2,086 3,658 4,925 19,700 (26) 424 1,313 2,344 178 CIP - MARKETING 3,141 9,117 7,509 30,039 21 3,322 5,914 3,202 54 CIP - LABOR 13,343 37,142 44,627 178,511 (17) 12,870 34,504 2,637 8 CIP REBATES - LOW INCOME 4,270 4,270 4,500 18,000 (5) 0 4,185 85 2 76 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MARCH 2O23 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric MARCH YTD BUDGET BUDGET Bud Var%o MARCH YTD VARIANCE Actual Var% CIP - LOW INCOME LABOR 1,016 2,654 2,471 9,887 7 1,042 2,726 (72) (3) ENVIRONMENTAL COMPLIANCE 2,570 7,725 8,554 34,219 (10) 2,502 7,499 225 3 MISC GENERAL EXPENSE 20 5,847 624 2,500 836 (37) (41) 5,888 14,021 Total For General Expense: 35,714 108,022 145,652 582,609 (26) 29,952 80,292 27,729 35 Total Expenses(before Operating Transfers) 3,410,113 9,771,884 10,331,276 44,285,462 (5) 3,288,865 9,837,004 (65,120) (1) Operating Transfer Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R 124,155 387,902 361,226 1,681,653 7 111,024 335,705 52,196 16 Total For Operating Transfer/Other Funds: 124,155 387,902 361,226 1,681,653 7 111,024 335,705 52,196 16 Utilities & Labor Donated UTILITIES & LABOR DONATED TO 18,480 58,127 60,000 240,000 (3) 19,362 56,811 1,316 2 Total For Utilities & Labor Donated: 18,480 58,127 60,000 240,000 (3) 19,362 56,811 1,316 2 Total Operating Transfer Total For Total Operating Transfer: 142,635 446,029 421,226 1,921,653 6 130,386 392,517 53,512 14 Net Income Profit(Loss) (162,648) 88,030 (463,890) 1,465,028 119 712,352 114 (35,584) (624,321) 77