Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1g ERMUSR 06-13-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 Electric APRIL YTD BUDGET BUDGET Bud Var% APRIL 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% 927,062 4,240,327 4,203,362 14,039,146 1 1,041,621 4,116,581 123,746 3 260,037 1,135,589 1,046,077 3,461,850 9 259,990 1,003,692 131,896 13 1,368,518 5,368,908 5,525,480 20,243,229 (3) 1,459,469 5,541,603 (172,695) (3) 44,927 297,602 427,863 1,285,399 (30) 0 0 297,602 0 14,014 88,305 119,329 340,814 (26) 0 0 88,305 0 95,683 541,385 856,100 2,670,887 (37) 0 0 541,385 0 2,710,244 11,672,119 12,178,212 42,041,326 (4) 2,761,081 10,661,877 1,010,241 9 100,899 453,705 407,230 1,420,072 11 108,839 418,433 35,271 8 31,608 132,203 120,408 454,649 10 36,926 130,790 1,412 1 96,891 404,786 328,597 1,180,452 23 105,106 389,350 15,436 4 4,795 31,159 41,445 129,685 (25) 0 0 31,159 0 1,730 10,322 13,743 44,260 (25) 0 0 10,322 0 6,842 40,482 49,768 156,538 (19) 0 0 40,482 0 242,768 1,072,659 961,193 3,385,657 12 250,872 938,574 134,085 14 14,225 64,415 67,738 214,102 (5) 16,211 62,921 1,493 2 163 661 613 4,513 8 172 636 24 4 700 4,545 6,893 19,622 (34) 0 0 4,545 0 4 25 70 420 (64) 0 0 25 0 15,092 69,648 75,316 238,658 (8) 16,383 63,558 6,089 10 14,560 66,290 69,296 221,646 (4) 16,211 65,554 735 1 2,700 11,431 11,918 39,638 (4) 3,202 11,948 (517) (4) 690 4,551 7,050 20,286 (35) 0 0 4,551 0 127 783 1,359 3,900 (42) 0 0 783 0 18,079 83,056 89,624 285,471 (7) 19,413 77,503 5,553 7 21,555 86,262 86,666 260,000 0 21,501 85,768 493 1 21,555 86,262 86,666 260,000 0 21,501 85,768 493 1 400 1,600 1,600 4,800 0 400 1,600 0 0 0 0 153 0 0 0 231,000 656,841 (656,841) (100) ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric APRIL YTD BUDGET BUDGET Bud Var%o APRIL YTD VARIANCE Actual Var% Total For Other Electric Sales: 400 1,600 1,600 4,800 0 231,400 658,441 (656,841) (100) Total Operating Revenue 3,008,140 12,985,346 13,392,613 46,215,912 (3) 3,300,652 12,485,723 499,622 4 Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME Total For Interest/Dividend Income: Customer Penalties CUSTOMER DELINQUENT PENALT Total For Customer Penalties: LFG Project LFG PROJECT Total For LFG Project: Connection Fees DISCONNECT & RECONNECT CHA Total For Connection Fees: Misc Revenue MISC ELEC REVENUE - TEMP CHG STREET LIGHT TRANSMISSION INVESTMENTS MISC NON -UTILITY GAIN ON DISPOSITION OF PROPER CONTRIBUTIONS FROM CUSTOMS Total For Misc Revenue: Total Other Revenue Total For Total Other Revenue: Total Revenue Expenses Purchased Power PURCHASED POWER ENERGY ADJUSTMENT CLAUSE Total For Purchased Power: Operating & Mtce Expense 14,597 32,498 16,666 50,000 95 (28,456) (116,946) 149,444 128 14,597 32,498 16,666 50,000 95 (28,456) (116,946) 149,444 128 21,481 95,359 83,333 250,000 14 21,384 65,758 29,600 45 21,481 95,359 83,333 250,000 14 21,384 65,758 29,600 45 0 0 0 0 0 59,739 298,291 (298,291) (100) 0 0 0 0 0 59,739 298,291 (298,291) (100) 10,020 34,153 73,333 220,000 (53) 15,365 51,030 (16,876) (33) 10,020 34,153 73,333 220,000 (53) 15,365 51,030 (16,876) (33) 440 3,259 666 2,000 389 0 670 2,589 386 0 0 5,000 20,000 (100) 0 125 (125) (100) 43,540 198,170 216,410 649,231 (8) 37,211 174,655 23,514 13 17,714 55,064 30,000 90,000 84 8,869 37,906 17,157 45 0 0 0 0 0 0 22,750 (22,750) (100) 62,528 80,555 58,333 175,000 38 122,036 122,036 (41,480) (34) 124,223 337,050 310,410 936,231 9 168,116 358,143 (21,093) (6) 170,322 499,061 483,743 1,456,231 3 236,148 656,277 (157,216) (24) 170,322 499,061 483,743 1,456,231 3 236,148 656,277 (157,216) (24) 3,178,462 13,484,407 13,876,356 (3) 13,142,001 3 47,672,143 3,536,801 342,406 1,563,950 6,484,895 6,896,762 24,207,981 (6) 2,101,422 9,063,835 (2,578,939) (28) 446,222 2,222,852 2,780,382 8,558,044 (20) 0 0 2,222,852 0 2,010,172 8,707,748 9,677,145 32,766,025 (10) 2,101,422 9,063,835 (356,087) (4) 154 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric APRIL YTD BUDGET BUDGET Bud Var%o APRIL YTD VARIANCE Actual Var% OPERATING SUPERVISION 8,520 40,144 45,666 137,000 (12) 8,758 36,093 4,051 11 DIESEL OIL FUEL 729 3,406 3,333 10,000 2 76 1,322 2,083 157 NATURAL GAS 1,490 20,137 12,500 25,000 61 1,778 11,150 8,987 81 ELECTRIC & WATER CONSUMPTI 4,405 24,210 15,000 34,000 61 2,632 14,343 9,867 69 PLANT SUPPLIES & OTHER EXPEN 4,766 18,676 4,333 13,000 331 169 1,476 17,199 1,164 MISC POWER GENERATION EXPE 911 2,783 2,666 8,000 4 590 2,072 711 34 MAINTENANCE OF STRUCTURE - 549 8,128 6,666 20,000 22 1,708 6,536 1,592 24 MTCE OF PLANT ENGINES/GENER 1,601 11,859 13,000 39,000 (9) 804 4,958 6,901 139 MTCE OF PLANT/LAND IMPROVE 636 20,092 19,000 35,000 6 3,402 11,627 8,465 73 Total For Operating & Mtce Expense: 23,611 149,440 122,166 321,000 22 19,923 89,580 59,859 67 Landfill Gas LANDFILL GAS PLANT PURCHASE 0 0 0 0 0 13,243 48,683 (48,683) (100) LANDFILL GAS PLANT OPERATIO 0 0 0 0 0 41,518 166,074 (166,074) (100) LANDFILL GAS PLANT ADMINIST 0 0 0 0 0 184 855 (855) (100) LANDFILL GAS PLANT INSURANC 0 0 0 0 0 1,623 6,494 (6,494) (100) LANDFILL GAS PLANT MTCE 0 0 0 0 0 140 434 (434) (100) Total For Landfill Gas: 0 0 0 0 0 56,710 222,543 (222,543) (100) Transmission Expense TRANSMISSION MTCE AND EXPE 5,536 20,205 23,333 70,000 (13) 4,254 23,027 (2,821) (12) Total For Transmission Expense: 5,536 20,205 23,333 70,000 (13) 4,254 23,027 (2,821) (12) Distribution Expense REMOVE EXISTING SERVICE & M 0 542 350 1,050 55 194 194 347 178 SCADA EXPENSE 2,905 14,083 14,666 44,000 (4) 2,788 13,367 715 5 TRANSFORMER EXPENSE OH & U 1,275 6,114 5,000 15,000 22 963 3,817 2,296 60 MTCE OF SIGNAL SYSTEMS 0 609 666 2,000 (9) 0 154 454 293 METER EXPENSE - REMOVE & RE 0 100 500 1,500 (80) 0 275 (174) (63) TEMP SERVICE - INSTALL & REM 651 4,134 1,166 3,500 254 373 560 3,573 637 MISC DISTRIBUTION EXPENSE 26,131 159,236 100,000 300,000 59 31,994 126,075 33,161 26 INTERCONNECTION CARRYING C 0 0 0 2,416 0 0 0 0 0 Total For Distribution Expense: 30,964 184,820 122,350 369,466 51 36,313 144,445 40,375 28 Maintenance Expense MTCE OF STRUCTURES 946 12,733 15,333 46,000 (17) 2,129 8,147 4,586 56 MTCE OF SUBSTATIONS 2,996 16,205 11,666 35,000 39 6,528 7,003 9,201 131 MTCE OF SUBSTATION EQUIPME 7,090 14,399 25,666 77,000 (44) 4,825 22,541 (8,141) (36) MTCE OF OH LINES/TREE TRIM 30,221 166,134 175,000 225,000 (5) 13,447 106,665 59,469 56 155 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric APRIL YTD BUDGET BUDGET Bud Var%o APRIL YTD VARIANCE Actual Var% MTCE OF OH LINES/STANDBY 2,982 11,783 13,333 40,000 (12) 2,830 11,294 489 4 MTCE OF OH PRIMARY 14,318 54,273 56,666 170,000 (4) 14,968 43,695 10,577 24 MTCE OF URD PRIMARY 15,060 43,228 56,666 170,000 (24) 10,254 51,724 (8,496) (16) LOCATE ELECTRIC LINES 8,989 19,798 35,333 106,000 (44) 10,790 24,290 (4,492) (18) LOCATE FIBER LINES 0 33 333 1,000 (90) 48 179 (145) (81) MTCE OF LINE TRANSFORMERS 737 3,640 20,000 60,000 (82) 3,830 9,515 (5,874) (62) MTCE OF STREET LIGHTING 3,054 9,626 15,000 45,000 (36) 888 6,924 2,701 39 MTCE OF SECURITY LIGHTING 2,780 7,104 5,000 15,000 42 1,146 4,862 2,241 46 MTCE OF METERS 4,024 19,638 28,333 85,000 (31) 7,144 27,645 (8,007) (29) VOLTAGE COMPLAINTS 505 3,692 3,333 10,000 11 1,109 2,397 1,294 54 SALARIES TRANSMISSION & DIST 2,001 9,301 10,166 30,500 (9) 2,399 9,089 211 2 ELECTRIC MAPPING 12,744 67,022 31,666 95,000 112 5,962 40,012 27,010 68 MTCE OF OH SECONDARY 2,088 6,452 8,333 25,000 (23) 598 4,335 2,116 49 MTCE OF URD SECONDARY 2,943 13,112 20,000 60,000 (34) 5,528 14,719 (1,607) (11) TRANSPORTATION EXPENSE 23,122 117,899 81,666 245,000 44 28,400 109,783 8,116 7 Total For Maintenance Expense: 136,607 596,080 613,500 1,540,500 (3) 122,832 504,826 91,253 18 Depreciation & Amortization DEPRECIATION 208,332 833,979 837,404 2,552,700 0 194,616 777,364 56,615 7 AMORTIZATION 55,677 222,711 222,712 668,136 0 55,677 222,711 0 0 Total For Depreciation & Amortization: 264,010 1,056,691 1,060,116 3,220,836 0 250,294 1,000,076 56,615 6 Interest Expense INTEREST EXPENSE - BONDS 73,213 294,052 294,052 870,695 0 75,850 307,458 (13,406) (4) AMORTIZATION OF DEBT DISCOU (4,988) (19,954) (19,954) (59,863) 0 (4,988) (20,857) 903 4 Total For Interest Expense: 68,224 274,098 274,098 810,832 0 70,862 286,600 (12,502) (4) Other Operating Expense EV CHARGING EXPENSE 187 394 2,577 7,731 (85) 421 1,729 (1,335) (77) LOSS ON DISPOSITION OF PROP (C 0 0 0 15,500 0 0 0 0 0 OTHER DONATIONS 0 0 1,000 3,000 (100) 291 (9) 9 100 PENSION EXPENSE 0 0 0 45,000 0 0 0 0 0 OTHER INTEREST EXPENSE 0 378 378 378 0 378 1,864 (1,486) (80) INTEREST EXPENSE - METER DEP 3,970 15,700 833 2,500 1,785 166 657 15,042 2,290 Total For Other Operating Expense: 4,157 16,472 4,788 74,109 244 1,257 4,241 12,230 288 Customer Accounts Expense METER READING EXPENSE 3,319 12,433 15,666 47,000 (21) 4,631 15,476 (3,042) (20) DISCONNECT/RECONNECT EXPEN 1,353 5,473 7,333 22,000 (25) 1,746 6,125 (652) (11) 156 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric APRIL YTD BUDGET BUDGET Bud Var%o APRIL YTD VARIANCE Actual Var% MISC CUSTOMER ACCOUNTS EXP 31,180 111,414 104,166 312,500 7 26,998 96,170 15,244 16 BAD DEBT EXPENSE & RECOVER 2,478 4,292 6,666 20,000 (36) 1,385 2,639 1,653 63 Total For Customer Accounts Expense: 38,332 133,613 133,833 401,500 0 34,761 120,411 13,201 11 Administrative Expense SALARIES OFFICE & COMMISSION 63,316 268,991 316,666 950,000 (15) 65,591 251,496 17,494 7 TEMPORARY STAFFING 0 0 1,333 4,000 (100) 0 0 0 0 OFFICE SUPPLIES 9,007 47,003 35,666 107,000 32 5,548 24,620 22,383 91 ELECTRIC & WATER CONSUMPTI 2,187 8,935 9,666 29,000 (8) 1,678 7,051 1,883 27 BANK FEES 130 590 833 2,500 (29) 131 662 (71) (11) LEGAL FEES 960 8,068 13,333 40,000 (39) 2,077 8,549 (480) (6) AUDITING FEES 2,583 7,453 6,173 18,520 21 1,503 6,013 1,440 24 INSURANCE 21,996 71,065 62,000 186,000 15 15,825 55,614 15,451 28 UTILITY SHARE - DEFERRED COM 10,103 61,510 41,333 124,000 49 12,617 57,448 4,062 7 UTILITY SHARE - MEDICAUDENT 59,133 360,643 370,131 858,481 (3) 58,052 347,471 13,171 4 UTILITY SHARE - PERA 26,619 96,634 96,000 288,000 1 26,351 89,429 7,205 8 UTILITY SHARE - FICA 25,790 92,834 93,333 280,000 (1) 25,165 85,743 7,090 8 EMPLOYEE SICK PAY 9,503 66,367 50,000 150,000 33 13,171 60,553 5,814 10 EMPLOYEE HOLIDAY PAY 0 43,372 42,954 157,500 1 0 25,174 18,197 72 EMPLOYEE VACATION & PTO PA 18,674 110,998 98,000 250,000 13 25,567 95,726 15,272 16 UPMIC DISTRIBUTION (1,704) 18,817 22,753 91,015 (17) 0 10,576 8,240 78 LONGEVITY PAY 0 1,923 1,924 16,369 0 0 0 1,923 0 CONSULTING FEES 0 0 26,666 80,000 (100) 10,455 36,852 (36,852) (100) TELEPHONE 3,107 12,883 13,666 41,000 (6) 2,961 11,483 1,400 12 ADVERTISING 1,023 4,873 5,000 15,000 (3) 1,760 5,163 (289) (6) DUES & SUBSCRIPTIONS - FEES 9,504 38,844 57,558 172,675 (33) 10,119 39,456 (611) (2) SCHOOLS & MEETINGS 31,168 74,592 103,500 259,925 (28) 16,352 69,770 4,822 7 MTCE OF GENERAL PLANT & OFFI 1,002 4,010 2,533 7,600 58 609 2,437 1,573 65 Total For Administrative Expense: 294,108 1,400,417 1,471,028 4,128,585 (5) 295,539 1,291,294 109,122 8 General Expense CIP REBATES - RESIDENTIAL 3,105 13,320 33,390 100,170 (60) 2,720 16,227 (2,907) (18) CIP REBATES - COMMERCIAL 5,106 32,499 63,194 189,583 (49) 0 10,683 21,816 204 CIP - ADMINISTRATION 528 4,187 6,566 19,700 (36) 424 1,738 2,448 141 CIP - MARKETING 5,421 14,538 10,013 30,039 45 2,154 8,069 6,469 80 CIP - LABOR 10,622 47,764 59,503 178,511 (20) 12,589 47,094 670 1 CIP REBATES - LOW INCOME 0 4,270 6,000 18,000 (29) 0 4,185 85 2 157 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING APRIL 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Electric APRIL YTD BUDGET BUDGET Bud Var%o APRIL YTD VARIANCE Actual Var%o CIP - LOW INCOME LABOR 810 3,464 3,295 9,887 5 947 3,674 (209) (6) ENVIRONMENTAL COMPLIANCE 33 7,758 11,406 34,219 (32) 2,595 10,094 (2,336) (23) MISC GENERAL EXPENSE 332 6,179 833 2,500 642 36 (5) 6,185 103,100 Total For General Expense: 25,960 133,982 194,203 582,609 (31) 21,468 101,761 32,221 32 Total Expenses(before Operating Transfers) 2,901,685 12,673,570 13,696,562 44,285,462 (7) 3,015,639 12,852,644 (179,074) (1) Operating Transfer Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R 114,366 502,268 487,128 1,681,653 3 119,357 455,063 47,204 10 Total For Operating Transfer/Other Funds: 114,366 502,268 487,128 1,681,653 3 119,357 455,063 47,204 10 Utilities & Labor Donated UTILITIES & LABOR DONATED TO 47,341 105,468 80,000 240,000 32 18,411 75,222 30,246 40 Total For Utilities & Labor Donated: 47,341 105,468 80,000 240,000 32 18,411 75,222 30,246 40 Total Operating Transfer Total For Total Operating Transfer: 161,707 607,737 567,128 1,921,653 7 137,769 530,286 77,451 15 Net Income Profit(Loss) 115,069 203,100 (387,333) 1,465,028 152 (240,929) 444,029 184 383,392 158