Loading...
5.2b ERMUSR 11-8-2022ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA 2023 ELECTRIC BUDGET 2023 Annual 2022 Annual 2021 Annual Electric Budget Budget Actual Revenue Operating Revenue Elk River 440.4411 ELECT SALES - ELK RIVER RESIDENTIAL 14,039,146 13,522,235 13,020,814 440.4412 ELECT SALES - ELK RIVER NON -DEMAND 3,461,850 3,228,253 3,030,512 440.4413 ELECT SALES - ELK RIVER DEMAND 20,350,334 19,635,955 18,940,232 PCA SALES REVENUE - ELK RIVER 4,314,331 g/l account added 2023 Total for Elk River: 42,165,661 36,386,443 34,991,559 Otsego 440.4416 ELECT SALES- OTSEGO RESIDENTIAL 1,420,072 1,367,786 1,297,397 440.4417 ELECT SALES - OTSEGO NON -DEMAND 454,649 423,970 439,205 440.4418 ELECT SALES - OTSEGO DEMAND 1,191,146 1,123,576 1,241,021 PCA SALES REVENUE - OTSEGO 332,077 g/l account added 2023 Total for Otsego: 3,397,944 2,915,332 2,977,625 Rural Big Lake 440.4421 ELECT SALES - BIG LAKE RESIDENTIAL 214,102 206,219 188,172 440.4422 ELECT SALES - BIG LAKE NON -DEMAND 4,513 4,208 4,468 PCA SALES REVENUE - BIG LAKE 20,043 - - g/l account added 2023 Total for Rural Big Lake: 238,658 210,428 192,642 Dayton 440.4431 ELECT SALES - DAYTON RESIDENTIAL 221,646 213,485 196,462 440.4432 ELECT SALES - DAYTON NON -DEMAND 39,638 36,964 38,223 PCA SALES REVENUE - DAYTON 24,187 g/l account added 2023 Total for Dayton: 285,471 250,449 234,686 Public St & Hwy Lighting 440.4414 ELECT SALES - SEC LTS 260,000 250,000 252,069 Total for Public St & Hwy Lighting: 260,000 250,000 252,069 Other Electric Sales 440.455 SUB -STATION CREDIT 4,800 4,800 4,800 440.4554 RATE INCREASE 773,546 Total for Other Electric Sales: 4,800 4,800 778,346 Total for Operating Revenue: 46,352,534 40,017,451 39,426,927 Other Operating Revenue Interest/Dividend Income 460.4691 INTEREST& DIVIDEND INCOME 50,000 80,000 52,514 Total for Interest/Dividend Income: 50,000 80,000 52,514 Customer Penalties 470.4701 CUSTOMER DELINQUENT PENALTIES 250,000 235,000 Total for Customer Penalties: 250,000 235,000 - LFG Project 470.4721 LTG PROJECT 836,000 1,019,096 Total for LEG Project: - 836,000 1,019,097 Connection Fees 470.4702 DISCONNECT& RECONNECT CHARGE 220,000 220,000 263,330 Total for Connection Fees: 220,000 220,000 263,330 Misc Revenue 470.4703 MISC ELEC REVENUE - TEMP CHG 2,000 2,000 2,612 470.4704 STREET LIGHT 20,000 20,000 51,590 470.4715 TRANSMISSION INVESTMENTS 649,231 600,000 525,384 470.4722 MISC NON -UTILITY 90,000 90,000 102,899 470.4723 GAIN ON DISPOSITION OF PROPERTY - - - 470.4739 PERA PENSION REVENUE - - 4,869 470.477 CONTRIBUTIONS FROM CUSTOMERS 175,000 175,000 385,316 470.478 CONTRIBUTIONS FROM GRANTS Total for Misc Revenue: 936,231 887,000 1,072,671 Total Other Revenue Total for Total Other Revenue: 1,456,231 2,258,000 2,407,612 Total Revenue 47,808,765 42,275,451 41,834,539 13.1% Expenses Purchased Power 540.5551 PURCHASED POWER 24,683,798 27,017,920 28,169,145 ENERGY ADJUSTMENT CLAUSE 8,558,044 g/l account added 2023 Total for Purchased Power: 33,241,842 27,017,920 28,169,145 23.0% Operating & Mtce Expense 540.5461 OPERATING SUPERVISION 137,000 143,000 108,275 540.5471 DIESEL OIL FUEL 10,000 10,000 7,222 540.5472 NATURALGAS 25,000 17,500 23,963 540.5483 ELECTRIC & WATER CONSUMPTION - PLANT 34,000 30,000 28,591 540.5484 PLANT SUPPLIES & OTHER EXPENSE 13,000 13,000 11,401 540.5491 MISC POWER GENERATION EXPENSE 8,000 8,000 6,281 540.5521 MAINTENANCE OF STRUCTURE - PLANT 20,000 15,000 11,633 540.5531 MTCE OF PLANT ENGINES/GENERATORS 39,000 25,000 37,825 540.5541 MTCE OF PLANT/LAND IMPROVEMENT 35,000 30,000 24,715 Total for Operating & Mtce Expense: 321,000 291,500 259,909 Landfill Gas 550.505 LANDFILL GAS PLANT PURCHASED GAS - 151,794 172,348 Per contract ending 10/2022 550.5051 LANDFILL GAS PLANT OPERATIONS & MTCE - 415,187 543,031 550.5052 LANDFILL GAS PLANT ADMINISTATION - 25,550 5,188 71 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA 2023 ELECTRIC BUDGET 2023 Annual 2022 Annual 2021 Annual Electric Budget Budget Actual 550.5053 LANDFILL GAS PLANT INSURANCE - 19,950 19,389 550.5054 LANDFILL GAS PLANT MTCE 650 2,763 Total for Landfill Gas: - 613,131 742,722 Transmission Expense 560.562 TRANSMISSION MTCE AND EXPENSE 70,000 66,700 67,470 Total for Transmission Expense: 70,000 66,700 67,471 Distribution Expense 580.5801 REMOVE EXISTING SERVICE & METERS 1,050 2,500 397 580.5821 SCADA EXPENSE 44,000 44,000 42,351 580.5831 TRANSFORMER EXPENSE OH & URD 15,000 13,000 16,107 580.5851 MTCE OF SIGNAL SYSTEMS 2,000 2,000 1,350 580.5861 METER EXPENSE - REMOVE & RESET 1,500 1,000 1,495 580.5871 TEMP SERVICE - INSTALL & REMOVE 3,500 2,000 2,586 580.5881 MISC DISTRIBUTION EXPENSE 300,000 280,000 243,531 580.589 INTERCONNECTION CARRYING CHARGE 2,416 2,416 2,416 Total for Distribution Expense: 369,466 346,916 310,235 Maintenance Expense 590.5911 MTCE OF STRUCTURES 30,000 30,000 25,034 590.5921 MTCE OF SUBSTATIONS 35,000 26,000 12,180 590.5922 MTCE OF SUBSTATION EQUIPMENT 77,000 69,000 72,011 590.5931 MTCE OF OH LINES/TREE TRIM 225,000 225,000 59,360 $1401, contractors 590.5932 MTCE OF OH LINES/STANDBY 40,000 36,000 36,674 590.5933 MTCE OF OH PRIMARY 170,000 170,000 152,255 590.5941 MTCE OF URD PRIMARY 170,000 165,000 176,888 590.5943 LOCATE ELECTRIC LINES 106,000 105,100 102,561 590.5944 LOCATE FIBER LINES 1,000 1,000 308 590.5951 MTCE OF LINE TRANSFORMERS 60,000 60,000 51,790 590.5961 MTCE OF STREET LIGHTING 45,000 45,000 24,711 590.5962 MTCE OF SECURITY LIGHTING 15,000 10,000 13,815 590.5971 MTCE OF METERS 85,000 80,000 64,016 590.5972 VOLTAGE COMPLAINTS 10,000 10,000 7,420 590.5981 SALARIES TRANSMISSION & DISTRIBUTION 30,500 30,000 25,935 590.5985 ELECTRIC MAPPING 95,000 90,000 79,158 590.5991 MTCE OF OH SECONDARY 25,000 25,000 19,784 590.5992 MTCE OF URD SECONDARY 60,000 50,000 47,085 590.5995 TRANSPORTATION EXPENSE 245,000 240,000 221,526 Total for Maintenance Expense: 1,524,500 1,467,100 1,192,521 Depreciation & Amortization 595.8031 DEPRECIATION 2,552,700 2,436,698 2,289,550 595.8032 AMORTIZATION 668,136 668,135 668,135 Total for Depreciation & Amortization: 3,220,836 3,104,833 2,957,685 Interest Expense 596.8071 INTEREST EXPENSE - BONDS 870,695 906,275 818,495 596.8075 INTEREST EXPENSE - DEFEASED BONDS - - (276) 597.8281 AMORTIZATION OF DEBT DISCOUNT (59,863) (60,766) (61,039) Total for Interest Expense: 810,832 845,509 756,910 Other Operating Expense 597.8165 EV CHARGING EXPENSE 7,731 4,240 4,010 597.8213 LOSS ON DISPOSITION OF PROP (CAPITAL) 15,500 12,500 45,213 597.8263 OTHER DONATIONS 3,000 3,000 1,177 597.8265 MUTUALAID - - 6,860 597.8302 PENSION EXPENSE 45,000 45,000 (283,382) 597.8303 OPEB EXPENSE - - (208,273) 597.8311 OTHER INTEREST EXPENSE 378 - (980) 597.8341 INTEREST EXPENSE - METER DEPOSITS 2,500 2,000 890 Total for Other Operating Expense: 74,109 66,740 (434,484) Customer Accounts Expense 900.9021 METER READING EXPENSE 47,000 42,100 44,749 900.903 DISCONNECT/RECONNECT EXPENSE 22,000 16,100 17,106 900.9051 MISC CUSTOMER ACCOUNTS EXPENSE UTILITY 312,500 272,000 269,231 Customer satisfaction survey 900.9061 BAD DEBT EXPENSE & RECOVERY 20,000 20,000 6,672 Total for Customer Accounts Expense: 401,500 350,200 337,760 Administrative Expense 920.92015ALARIES OFFICE & COMMISSION 950,000 860,000 773,608 Admin Director 920.92025ALARIES COVID-19 - - 21,040 920.9205 TEMPORARY STAFFING 4,000 4,000 - 920.9211 OFFICE SUPPLIES 107,000 107,000 74,004 920.9212 ELECTRIC & WATER CONSUMPTION - OFFICE 29,000 29,000 24,641 920.9213 BANK FEES 2,500 2,500 2,380 920.9221 LEGAL FEES 40,000 32,000 22,855 920.9231 AUDITING FEES 18,520 18,040 16,960 920.9241 INSURANCE 186,000 182,884 152,429 920.926 UTILITY SHARE - DEFERRED COMP 124,000 123,500 102,611 920.9261 UTILITY SHARE - MEDICAL/DENTAL/DISABIL 858,481 847,000 759,627 920.9262 UTILITY SHARE - PERA 288,000 280,000 263,991 920.9263 UTILITY SHARE - FICA 280,000 265,000 253,522 920.9264 EMPLOYEE SICK PAY 150,000 133,025 140,780 920.9265 EMPLOYEE HOLIDAY PAY 157,500 146,991 152,302 920.9266 EMPLOYEE VACATION & PTO PAY 250,000 231,961 226,253 920.9267 UPMIC DISTRIBUTION 91,015 60,000 58,665 920.929 LONGEVITY PAY 17,609 - - 72 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA 2023 ELECTRIC BUDGET 2023 Annual 2022 Annual 2021 Annual Electric Budget Budget Actual 920.9291 CONSULTING FEES 80,000 55,000 79,398 Bonding 920.9301 TELEPHONE 41,000 31,300 31,253 920.9302 ADVERTISING 15,000 13,000 13,860 920.9303 DUES&SUBSCRIPTIONS - FEES 170,955 130,365 230,896 Bonding 920.9305 SCHOOLS & MEETINGS 257,505 224,212 118,020 920.9321 MTCE OF GENERAL PLANT & OFFICE HEATING 7,600 7,500 7,313 Total for Administrative Expense: 4,125,685 3,784,279 3,526,417 General Expense 920.9269 CIP REBATES - RESIDENTIAL 100,170 57,907 49,218 920.927 CIP REBATES - COMMERCIAL 189,583 232,200 104,250 920.9271 CIP-ADMINISTRATION 19,700 85,301 5,418 920.9272 CIP- MARKETING 30,039 47,000 27,462 920.9273 CIP - LABOR 178,511 100,512 143,124 920.9274 CIP REBATES- LOW INCOME 18,000 18,500 18,635 920.9275 CIP - LOW INCOME LABOR 9,887 9,750 10,474 920.9281 ENVIRONMENTAL COMPLIANCE 34,219 34,000 32,269 920.9306 MISC GENERAL EXPENSE 2,500 2,500 5,574 Total for General Expense: 582,609 587,670 396,426 Total Expenses (before Operating Transfers) 44,742,378 38,542,498 38,282,718 16% Operating Transfer Operating Transfer/Other Funds 597.8262 TRANSFER TO CITY ELK RIVER REVENUE 1,686,626 1,455,458 1,407,734 Total for Operating Transfer/Other Funds: 1,686,626 1,455,458 1,407,734 Utilities & Labor Donated 597.8261 UTILITIES & LABOR DONATED TO CITY 240,000 230,000 224,814 Total for Utilities & Labor Donated: 240,000 230,000 224,814 Total Operating Transfer Total for Total Operating Transfer: 1,926,626 1,685,458 1,632,548 Net Income Profit(Loss) 1,139,760 2,047,495 1,919,272 Total Expense Including Purchased Power 46,669,004 40,227,956 Budget Change Year over Year 16.0% Total Expense Less Purchased Power 13,427,163 13,210,035 Expense Budget Change Year over Year 1.6% 73