Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1g ERMUSR 11-8-2022
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% Revenue Operating Revenue Elk River ELECT SALES - ELK RIVER RESID 1,510,291 10,503,372 10,554,848 13,522,234 0 1,387,195 10,163,462 339,909 3 ELECT SALES - ELK RIVER NON-D 347,726 2,492,463 2,471,870 3,228,252 1 311,551 2,320,460 172,002 7 ELECT SALES - ELK RIVER DEMA 2,235,458 15,127,173 14,751,918 19,635,954 3 1,906,307 14,229,242 897,931 6 Total For Elk River: 4,093,476 28,123,009 27,778,637 36,386,442 1 3,605,054 26,713,165 1,409,844 5 Otsego ELECT SALES - OTSEGO RESIDEN 175,506 1,110,718 1,072,913 1,367,785 4 149,723 1,017,699 93,019 9 ELECT SALES - OTSEGO NON-DEM 61,572 375,165 325,247 423,970 15 54,459 336,935 38,229 11 ELECT SALES - OTSEGO DEMAND 160,241 1,047,142 853,286 1,123,576 23 122,921 942,479 104,663 11 Total For Otsego: 397,320 2,533,026 2,251,448 2,915,332 13 327,105 2,297,114 235,912 10 Rural Big Lake ELECT SALES - BIG LAKE RESIDE 21,562 151,268 162,186 206,219 (7) 20,136 147,993 3,274 2 ELECT SALES - BIG LAKE NON -DE 949 3,797 3,593 4,208 6 866 3,815 (18) 0 Total For Rural Big Lake: 22,511 155,066 165,780 210,427 (6) 21,003 151,809 3,256 2 Dayton ELECT SALES - DAYTON RESIDEN 23,746 161,300 168,427 213,485 (4) 22,032 154,998 6,302 4 ELECT SALES - DAYTON NON -DE 4,399 30,424 28,464 36,963 7 4,335 29,435 989 3 Total For Dayton: 28,145 191,724 196,892 250,448 (3) 26,367 184,433 7,291 4 Public St & Hwy Lighting ELECT SALES - SEC LTS 21,688 193,584 187,499 250,000 3 21,192 188,601 4,983 3 Total For Public St & Hwy Lighting: 21,688 193,584 187,499 250,000 3 21,192 188,601 4,983 3 Other Electric Sales SUB -STATION CREDIT 400 3,600 3,600 4,800 0 400 3,600 0 0 RATE INCREASE (71,207) 1,419,642 0 0 0 0 0 1,419,642 0 Total For Other Electric Sales: (70,807) 1,423,242 3,600 4,800 39,435 400 3,600 1,419,642 39,435 Total Operating Revenue 4,492,336 32,619,656 30,583,858 40,017,450 7 4,001,123 29,538,725 3,080,930 10 Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME (57,823) (181,139) 60,000 80,000 (402) 7,992 49,987 (231,126) (462) Total For Interest/Dividend Income: (57,823) (181,139) 60,000 80,000 (402) 7,992 49,987 (231,126) (462) Customer Penalties CUSTOMER DELINQUENT PENALT 29,257 212,982 170,909 235,000 25 0 0 212,982 0 Total For Customer Penalties: 29,257 212,982 170,909 235,000 25 0 0 212,982 0 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% LFG Project LFG PROJECT 90,387 760,382 752,400 836,000 1 86,392 775,604 (15,222) (2) Total For LFG Project: 90,387 760,382 752,400 836,000 1 86,392 775,604 (15,222) (2) Connection Fees DISCONNECT & RECONNECT CHA 9,325 152,995 160,000 220,000 (4) 20,725 203,000 (50,005) (25) Total For Connection Fees: 9,325 152,995 160,000 220,000 (4) 20,725 203,000 (50,005) (25) Misc Revenue MISC ELEC REVENUE - TEMP CHG 1,540 4,380 1,500 2,000 192 650 2,462 1,917 78 STREET LIGHT 0 6,425 15,000 20,000 (57) 0 51,590 (45,165) (88) TRANSMISSION INVESTMENTS 60,068 473,609 450,000 600,000 5 54,070 395,120 78,488 20 MISC NON -UTILITY 8,656 119,704 67,500 90,000 77 6,755 79,594 40,109 50 GAIN ON DISPOSITION OF PROPER 10,788 33,538 0 0 0 0 0 33,538 0 CONTRIBUTIONS FROM CUSTOME 13,684 271,868 131,249 175,000 107 56,018 365,363 (93,494) (26) Total For Misc Revenue: 94,737 909,525 665,250 887,000 37 117,493 894,130 15,394 2 Total Other Revenue 165,884 1,854,745 1,808,559 2,258,000 3 232,603 1,922,722 (67,976) (4) Total For Total Other Revenue: 165,884 1,854,745 1,808,559 2,258,000 3 232,603 1,922,722 (67,976) (4) Total Revenue 4,658,220 34,474,401 32,392,417 42,275,450 6 4,233,727 31,461,448 3,012,953 10 Expenses Purchased Power PURCHASED POWER 3,086,039 24,875,107 21,437,870 27,017,920 16 2,437,905 21,219,513 3,655,594 17 Total For Purchased Power: 3,086,039 24,875,107 21,437,870 27,017,920 16 2,437,905 21,219,513 3,655,594 17 Operating & Mtce Expense OPERATING SUPERVISION 14,247 96,871 107,250 143,000 (10) 10,007 82,849 14,022 17 DIESEL OIL FUEL 106 1,839 7,499 10,000 (75) 912 4,561 (2,721) (60) NATURAL GAS 236 12,457 10,800 17,500 15 1,416 18,437 (5,980) (32) ELECTRIC & WATER CONSUMPTI 2,020 24,215 21,700 30,000 12 1,754 19,781 4,433 22 PLANT SUPPLIES & OTHER EXPEN 1,307 5,343 9,749 13,000 (45) 1,396 9,884 (4,540) (46) MISC POWER GENERATION EXPE 299 3,607 6,000 8,000 (40) 467 5,703 (2,096) (37) MAINTENANCE OF STRUCTURE - 879 11,028 11,250 15,000 (2) 1,347 8,434 2,594 31 MTCE OF PLANT ENGINES/GENER 494 10,243 18,749 25,000 (45) 607 22,215 (11,971) (54) MTCE OF PLANT/LAND IMPROVE 220 13,954 22,250 30,000 (37) 1,297 16,557 (2,603) (16) Total For Operating & Mtce Expense: 19,812 179,561 215,249 291,500 (17) 19,206 188,426 (8,864) (5) Landfill Gas 59 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% LANDFILL GAS PLANT PURCHASE 14,412 123,294 136,614 151,794 (10) 14,068 130,254 (6,959) (5) LANDFILL GAS PLANT OPERATIO 41,518 354,116 373,668 415,187 (5) 43,229 389,349 (35,233) (9) LANDFILL GAS PLANT ADMINIST 223 2,262 22,995 25,550 (90) 232 4,274 (2,012) (47) LANDFILL GAS PLANT INSURANC 1,948 15,586 17,955 19,950 (13) 1,623 14,518 1,068 7 LANDFILL GAS PLANT MTCE 140 1,135 585 650 94 117 2,453 (1,317) (54) Total For Landfill Gas: 58,243 496,395 551,817 613,131 (10) 59,271 540,849 (44,453) (8) Transmission Expense TRANSMISSION MTCE AND EXPE 5,431 49,497 50,024 66,700 (1) 6,564 48,320 1,176 2 Total For Transmission Expense: 5,431 49,497 50,024 66,700 (1) 6,564 48,320 1,176 2 Distribution Expense REMOVE EXISTING SERVICE & M 0 194 1,874 2,500 (90) 0 397 (202) (51) SCADA EXPENSE 5,012 32,021 33,000 44,000 (3) 5,079 31,709 311 1 TRANSFORMER EXPENSE OH & U 920 9,033 9,749 13,000 (7) 954 7,924 1,108 14 MTCE OF SIGNAL SYSTEMS 0 1,815 1,500 2,000 21 120 954 860 90 METER EXPENSE - REMOVE & RE 0 582 749 1,000 (22) 639 1,163 (581) (50) TEMP SERVICE - INSTALL & REM 907 3,197 1,500 2,000 113 653 1,722 1,474 86 M1SC DISTRIBUTION EXPENSE 25,854 224,492 209,999 280,000 7 19,437 209,247 15,244 7 INTERCONNECTION CARRYING C 0 0 1,811 2,416 (100) 0 0 0 0 Total For Distribution Expense: 32,695 271,336 260,186 346,916 4 26,884 253,119 18,216 7 Maintenance Expense MTCE OF STRUCTURES 2,382 19,743 22,500 30,000 (12) 2,008 18,951 792 4 MTCE OF SUBSTATIONS 4,753 34,421 19,500 26,000 77 0 11,684 22,737 195 MTCE OF SUBSTATION EQUIPME 989 31,905 51,750 69,000 (38) 11,271 59,026 (27,121) (46) MTCE OF OH LINES/TREE TRIM 1,785 112,048 180,000 225,000 (38) 732 57,763 54,285 94 MTCE OF OH LINES/STANDBY 2,866 25,593 27,000 36,000 (5) 3,097 27,409 (1,815) (7) MTCE OF OH PRIMARY 13,757 146,267 127,500 170,000 15 7,876 113,675 32,592 29 MTCE OF URD PRIMARY 21,614 159,101 123,750 165,000 29 12,632 136,503 22,598 17 LOCATE ELECTRIC LINES 9,130 76,097 78,824 105,100 (3) 10,450 80,155 (4,058) (5) LOCATE FIBER LINES 114 619 749 1,000 (17) 0 269 350 130 MTCE OF LINE TRANSFORMERS 2,645 23,880 45,000 60,000 (47) (1,210) 44,895 (21,015) (47) MTCE OF STREET LIGHTING 3,729 37,946 33,750 45,000 12 (307) 10,578 27,367 259 MTCE OF SECURITY LIGHTING 453 13,825 7,499 10,000 84 892 8,775 5,049 58 MTCE OF METERS 5,286 62,026 60,000 80,000 3 6,362 47,768 14,258 30 VOLTAGE COMPLAINTS 412 5,536 7,499 10,000 (26) 399 7,049 (1,513) (21) SALARIES TRANSMISSION & DIST 2,527 21,032 22,500 30,000 (7) 2,366 19,624 1,407 7 60 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% ELECTRIC MAPPING 5,266 67,539 67,500 90,000 0 7,325 60,563 6,976 12 MTCE OF OH SECONDARY 3,441 16,085 18,749 25,000 (14) 3,615 16,568 (482) (3) MTCE OF URD SECONDARY 6,513 48,856 37,500 50,000 30 6,515 37,093 11,763 32 TRANSPORTATION EXPENSE 28,612 216,143 180,000 240,000 20 9,284 179,682 36,460 20 Total For Maintenance Expense: 116,282 1,118,673 1,111,574 1,467,100 1 83,312 938,039 180,633 19 Depreciation & Amortization DEPRECIATION 194,061 1,747,494 1,750,954 2,436,698 0 191,522 1,713,349 34,144 2 AMORTIZATION 55,677 501,101 501,101 668,135 0 55,677 501,101 0 0 Total For Depreciation & Amortization: 249,738 2,248,595 2,252,055 3,104,833 0 247,200 2,214,451 34,144 2 Interest Expense INTEREST EXPENSE - BONDS 74,413 683,835 683,835 906,275 0 79,906 578,775 105,060 18 INTEREST EXPENSE - DEFEASED 0 0 0 0 0 0 (276) 276 100 AMORTIZATION OF DEBT DISCOU (4,988) (45,800) (45,574) (60,765) 0 (5,892) (43,632) (2,167) (5) Total For Interest Expense: 69,424 638,035 638,261 845,509 0 74,014 534,866 103,168 19 Other Operating Expense EV CHARGING EXPENSE 1,311 5,128 3,179 4,240 61 332 3,000 2,128 71 LOSS ON DISPOSITION OF PROP (C 0 0 9,375 12,500 (100) 0 45,213 (45,213) (100) OTHER DONATIONS 1,938 3,483 2,250 3,000 55 125 918 2,565 279 MUTUAL AID 8,994 19,627 0 0 0 0 6,860 12,766 186 PENSION EXPENSE 0 0 0 45,000 0 0 0 0 0 OPEB EXPENSE 0 0 0 0 0 0 (208,273) 208,273 100 OTHER INTEREST EXPENSE 378 3,754 0 0 0 730 (3,170) 6,924 218 INTEREST EXPENSE - METER DEP 168 1,490 1,500 2,000 (1) 74 663 827 125 Total For Other Operating Expense: 12,790 33,483 16,305 66,740 105 1,261 (154,788) 188,272 122 Customer Accounts Expense METER READING EXPENSE 4,519 36,429 31,574 42,100 15 3,670 33,163 3,266 10 DISCONNECT/RECONNECT EXPEN 3,858 19,898 12,075 16,100 65 2,376 12,971 6,927 53 MISC CUSTOMER ACCOUNTS EXP 30,717 225,480 204,000 272,000 11 24,036 200,500 24,980 12 BAD DEBT EXPENSE & RECOVER 456 7,502 15,000 20,000 (50) 531 4,981 2,521 51 Total For Customer Accounts Expense: 39,551 289,311 262,650 350,200 10 30,615 251,615 37,695 15 Administrative Expense SALARIES OFFICE & COMMISSION 69,743 598,289 645,000 860,000 (7) 67,691 603,996 (5,706) (1) SALARIES COVID-19 0 0 0 0 0 0 21,040 (21,040) (100) TEMPORARY STAFFING 0 0 2,999 4,000 (100) 0 0 0 0 OFFICE SUPPLIES 4,755 53,094 80,250 107,000 (34) 4,631 52,836 257 0 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% ELECTRIC & WATER CONSUMPTI 2,460 19,824 21,750 29,000 (9) 2,007 19,097 727 4 BANK FEES 125 1,439 1,874 2,500 (23) 161 1,702 (262) (15) LEGAL FEES 4,812 24,341 24,000 32,000 1 1,952 17,389 6,952 40 AUDITING FEES 1,503 13,529 13,529 18,040 0 1,413 12,719 810 6 INSURANCE 14,472 134,858 137,163 182,884 (2) 13,066 117,839 17,019 14 UTILITY SHARE - DEFERRED COM 7,457 96,584 92,625 123,500 4 5,669 87,944 8,639 10 UTILITY SHARE - MEDICAL/DENT 60,594 658,575 664,250 847,000 (1) 52,936 598,672 59,903 10 UTILITY SHARE- PERA 24,829 208,284 209,999 280,000 (1) 22,324 197,604 10,680 5 UTILITY SHARE - FICA 23,718 201,629 198,749 265,000 1 21,417 190,180 11,449 6 EMPLOYEE SICK PAY 13,036 113,035 99,768 133,025 13 12,059 95,602 17,432 18 EMPLOYEE HOLIDAY PAY 14,494 67,014 80,176 146,991 (16) 13,008 76,147 (9,133) (12) EMPLOYEE VACATION & PTO PA 27,951 200,102 179,328 231,961 12 16,013 170,111 29,991 18 UPMIC DISTRIBUTION 27,213 49,029 45,000 60,000 9 16,448 42,540 6,489 15 LONGEVITY PAY 0 2,790 0 0 0 0 0 2,790 0 CONSULTING FEES 0 54,690 41,249 55,000 33 1,984 28,896 25,793 89 TELEPHONE 2,846 26,829 23,474 31,300 14 2,843 22,878 3,951 17 ADVERTISING 768 10,830 9,749 13,000 11 1,360 9,844 986 10 DUES & SUBSCRIPTIONS - FEES 13,614 93,477 97,773 130,365 (4) 10,975 197,722 (104,245) (53) SCHOOLS & MEETINGS 20,791 142,114 155,600 224,212 (9) 13,139 84,071 58,043 69 MTCE OF GENERAL PLANT & OFFI 609 5,485 5,625 7,500 (2) 596 5,368 116 2 Total For Administrative Expense: 335,799 2,775,850 2,829,940 3,784,278 (2) 281,700 2,654,207 121,642 5 General Expense CIP REBATES - RESIDENTIAL 3,795 39,757 43,430 57,907 (8) 3,406 32,546 7,211 22 CIP REBATES - COMMERCIAL 13,424 92,607 174,150 232,200 (47) 30,774 75,332 17,275 23 CIP - ADMINISTRATION 424 7,140 63,975 85,301 (89) 424 4,144 2,996 72 CIP - MARKETING 1,355 22,741 35,250 47,000 (35) 1,029 22,474 267 1 CIP - LABOR 14,095 113,162 75,384 100,512 50 11,655 109,673 3,489 3 CIP REBATES - LOW INCOME 0 4,185 13,875 18,500 (70) 0 6,635 (2,450) (37) CIP - LOW INCOME LABOR 817 7,742 7,312 9,750 6 747 7,869 (127) (2) ENVIRONMENTAL COMPLIANCE 2,909 24,009 24,012 34,000 0 3,096 24,902 (893) (4) MISC GENERAL EXPENSE (73) 75 1,874 2,500 (96) 16 5,924 (5,849) (99) Total For General Expense: 36,748 311,421 439,264 587,670 (29) 51,151 289,502 21,919 8 Total Expenses(before Operating Transfers) 4,062,559 33,287,270 30,065,201 38,542,498 11 3,319,089 28,978,125 4,309,145 15 Operating Transfer 62 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R 164,440 1,159,519 1,111,145 1,455,457 4 144,872 1,074,550 84,969 8 Total For Operating Transfer/Other Funds: 164,440 1,159,519 1,111,145 1,455,457 4 144,872 1,074,550 84,969 8 Utilities & Labor Donated UTILITIES & LABOR DONATED TO 18,940 170,738 172,500 230,000 (1) 18,967 166,902 3,836 2 Total For Utilities & Labor Donated: 18,940 170,738 172,500 230,000 (1) 18,967 166,902 3,836 2 Total Operating Transfer Total For Total Operating Transfer: 183,381 1,330,258 1,283,645 1,685,457 4 163,839 1,241,452 88,805 7 Net Income Profit(Loss) 412,280 (143,127) 1,043,570 2,047,494 (114) 750,798 (1,384,996) (112) 1,241,869 a