Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1g ERMUSR 08-09-2022
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETElectric Revenue Operating Revenue Elk River ELECT SALES - ELK RIVER RESID 1,039,839 5,854,6101,181,676 6,080,0666,167,526 1 513,522,234 312,916 ELECT SALES - ELK RIVER NON-D 235,491 1,393,483290,540 1,484,4081,523,070 3 93,228,252 129,586 ELECT SALES - ELK RIVER DEMA 1,704,446 8,670,4501,910,154 8,988,9388,997,518 0 419,635,954 327,067 3,382,371 16,688,115 16,553,413 2,979,776 15,918,5451 5Total For Elk River:36,386,442 769,570 Otsego ELECT SALES - OTSEGO RESIDEN 86,565 562,429118,322 592,942625,301 5 111,367,785 62,872 ELECT SALES - OTSEGO NON-DEM 34,798 176,89948,511 170,763210,532 23 19423,970 33,633 ELECT SALES - OTSEGO DEMAND 101,951 559,755131,409 506,782610,275 20 91,123,576 50,520 298,243 1,446,110 1,270,488 223,315 1,299,08414 11Total For Otsego:2,915,332 147,026 Rural Big Lake ELECT SALES - BIG LAKE RESIDE 12,336 85,52615,668 93,72891,009 (3)6206,219 5,483 ELECT SALES - BIG LAKE NON-DE 504 1,3444921,2661,288 2 (4)4,208 (56) 16,160 92,298 94,994 12,841 86,871(3)6Total For Rural Big Lake:210,427 5,427 Dayton ELECT SALES - DAYTON RESIDEN 12,537 87,58416,158 95,17394,616 (1)8213,485 7,032 ELECT SALES - DAYTON NON-DE 2,867 16,9203,589 16,36218,262 12 836,963 1,342 19,747 112,879 111,535 15,404 104,5041 8Total For Dayton:250,448 8,374 Public St & Hwy Lighting ELECT SALES - SEC LTS 20,927 125,59021,496 124,999128,764 3 3250,000 3,173 21,496 128,764 124,999 20,927 125,5903 3Total For Public St & Hwy Lighting:250,000 3,173 Other Electric Sales SUB-STATION CREDIT 400 2,4004002,4002,400 0 04,800 0 RATE INCREASE 0 0308,369 01,230,212 0 001,230,212 308,769 1,232,612 2,400 400 2,40051,259 51,259Total For Other Electric Sales:4,800 1,230,212 Total Operating Revenue 3,252,666 17,536,9964,046,789 18,157,83219,700,780 8 1240,017,450 2,163,784 Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME 7,086 35,479(16,178)40,000(138,279)(446)(490)80,000 (173,758) (16,178)(138,279)40,000 7,086 35,479(446)(490)Total For Interest/Dividend Income:80,000 (173,758) Customer Penalties CUSTOMER DELINQUENT PENALT 0 030,877 106,818115,789 8 0235,000 115,789 30,877 115,789 106,818 0 08 0Total For Customer Penalties:235,000 115,78966 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETElectric LFG Project LFG PROJECT 87,481 507,76799,232 501,600484,224 (3)(5)836,000 (23,543) 99,232 484,224 501,600 87,481 507,767(3)(5)Total For LFG Project:836,000 (23,543) Connection Fees DISCONNECT & RECONNECT CHA 9,250 120,20021,000 104,00087,220 (16)(27)220,000 (32,980) 21,000 87,220 104,000 9,250 120,200(16)(27)Total For Connection Fees:220,000 (32,980) Misc Revenue MISC ELEC REVENUE - TEMP CHG 0 1,8128801,0002,840 184 572,000 1,027 STREET LIGHT 0 37,800010,000125 (99)(100)20,000 (37,675) TRANSMISSION INVESTMENTS 59,009 223,46566,661 300,000281,725 (6)26600,000 58,260 MISC NON-UTILITY 15,613 44,48329,807 45,00074,675 66 6890,000 30,192 GAIN ON DISPOSITION OF PROPER 0 00022,750 0 0022,750 CONTRIBUTIONS FROM CUSTOME 42,961 188,5288,717 87,499139,061 59 (26)175,000 (49,467) 106,066 521,178 443,500 117,584 496,09018 5Total For Misc Revenue:887,000 25,087 Total Other Revenue 221,402 1,159,536240,998 1,195,9181,070,132 (11)(8)2,258,000 (89,404) 240,998 1,070,132 1,195,918 221,402 1,159,536(11)(8)Total For Total Other Revenue:2,258,000 (89,404) 3,474,068 18,696,5334,287,787 19,353,750 Total Revenue 20,770,912 7 1142,275,450 2,074,379 Expenses Purchased Power PURCHASED POWER 2,908,386 12,683,5083,429,170 12,431,18114,871,102 20 1727,017,920 2,187,594 3,429,170 14,871,102 12,431,181 2,908,386 12,683,50820 17Total For Purchased Power:27,017,920 2,187,594 Operating & Mtce Expense OPERATING SUPERVISION 9,685 55,56910,381 71,50056,387 (21)1143,000 818 DIESEL OIL FUEL 0 2,022764,9991,474 (70)(27)10,000 (547) NATURAL GAS 630 14,1722229,10011,772 29 (17)17,500 (2,400) ELECTRIC & WATER CONSUMPTI 2,084 13,7731,724 15,80018,334 16 3330,000 4,561 PLANT SUPPLIES & OTHER EXPEN 184 7,77616,4993,726 (43)(52)13,000 (4,050) MISC POWER GENERATION EXPE 311 4,6742944,0002,503 (37)(46)8,000 (2,170) MAINTENANCE OF STRUCTURE -632 5,3101,031 7,5008,076 8 5215,000 2,766 MTCE OF PLANT ENGINES/GENER 12,892 20,12378712,4996,325 (49)(69)25,000 (13,798) MTCE OF PLANT/LAND IMPROVE 1,087 14,25258218,12513,490 (26)(5)30,000 (762) 15,101 122,091 150,024 27,509 137,674(19)(11)Total For Operating & Mtce Expense:291,500 (15,583) Landfill Gas 67 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETElectric LANDFILL GAS PLANT PURCHASE 14,926 85,96514,775 91,07679,277 (13)(8)151,794 (6,688) LANDFILL GAS PLANT OPERATIO 43,229 259,66241,518 249,112249,112 0 (4)415,187 (10,550) LANDFILL GAS PLANT ADMINIST 208 3,58222215,3301,675 (89)(53)25,550 (1,906) LANDFILL GAS PLANT INSURANC 1,607 9,6461,623 11,9709,742 (19)119,950 95 LANDFILL GAS PLANT MTCE 117 2,09914039071483 (66)650 (1,384) 58,280 340,522 367,878 60,088 360,956(7)(6)Total For Landfill Gas:613,131 (20,434) Transmission Expense TRANSMISSION MTCE AND EXPE 6,406 29,5185,645 33,34933,230 0 1366,700 3,712 5,645 33,230 33,349 6,406 29,5180 13Total For Transmission Expense:66,700 3,712 Distribution Expense REMOVE EXISTING SERVICE & M 0 9001,249194 (84)1142,500 103 SCADA EXPENSE 5,011 21,1465,129 22,00021,320 (3)144,000 173 TRANSFORMER EXPENSE OH & U 918 5,2119506,4996,193 (5)1913,000 982 MTCE OF SIGNAL SYSTEMS 58 3104691,0001,416 42 3572,000 1,106 METER EXPENSE - REMOVE & RE 218 21897499372(25)711,000 154 TEMP SERVICE - INSTALL & REM (542)6704541,0001,910 91 1852,000 1,240 MISC DISTRIBUTION EXPENSE 14,146 157,93416,631 139,999165,361 18 5280,000 7,426 INTERCONNECTION CARRYING C 0 001,2070 (100)02,416 0 23,732 196,769 173,457 19,809 185,58213 6Total For Distribution Expense:346,916 11,186 Maintenance Expense MTCE OF STRUCTURES 2,493 12,5952,178 15,00012,496 (17)(1)30,000 (98) MTCE OF SUBSTATIONS 190 4,0515,676 13,00018,511 42 35726,000 14,459 MTCE OF SUBSTATION EQUIPME 8,629 34,5641,045 34,50026,922 (22)(22)69,000 (7,641) MTCE OF OH LINES/TREE TRIM 0 56,9071,837 177,000109,392 (38)92225,000 52,485 MTCE OF OH LINES/STANDBY 2,582 17,4562,269 18,00016,883 (6)(3)36,000 (572) MTCE OF OH PRIMARY 12,790 77,34113,839 85,00081,619 (4)6170,000 4,277 MTCE OF URD PRIMARY 4,614 87,36516,437 82,50096,686 17 11165,000 9,320 LOCATE ELECTRIC LINES 11,435 48,90612,624 52,54946,670 (11)(5)105,100 (2,235) LOCATE FIBER LINES 0 190130499375(25)971,000 185 MTCE OF LINE TRANSFORMERS 2,197 40,42471430,00013,609 (55)(66)60,000 (26,815) MTCE OF STREET LIGHTING 3,357 10,37315,045 22,50026,237 17 15345,000 15,864 MTCE OF SECURITY LIGHTING 705 3,9922,099 4,9997,692 54 9310,000 3,700 MTCE OF METERS 4,894 27,98510,053 40,00044,055 10 5780,000 16,070 VOLTAGE COMPLAINTS 1,242 3,6559974,9993,584 (28)(2)10,000 (71) SALARIES TRANSMISSION & DIST 2,230 13,1212,448 15,00013,931 (7)630,000 80968 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETElectric ELECTRIC MAPPING 4,290 40,8588,603 45,00053,825 20 3290,000 12,966 MTCE OF OH SECONDARY 2,713 8,9933,321 12,4999,368 (25)425,000 375 MTCE OF URD SECONDARY 5,719 22,42714,603 25,00033,982 36 5250,000 11,554 TRANSPORTATION EXPENSE 13,078 137,15623,764 120,000150,062 25 9240,000 12,905 137,691 765,906 798,049 83,166 648,367(4)18Total For Maintenance Expense:1,467,100 117,538 Depreciation & Amortization DEPRECIATION 190,994 1,139,085193,125 1,162,8801,163,214 0 22,436,698 24,128 AMORTIZATION 55,677 334,06755,677 334,067334,067 0 0668,135 0 248,803 1,497,281 1,496,947 246,671 1,473,1530 2Total For Depreciation & Amortization:3,104,833 24,128 Interest Expense INTEREST EXPENSE - BONDS 80,677 343,07275,850 459,159459,159 0 34906,275 116,086 INTEREST EXPENSE - DEFEASED 0 (1,381)0 00 0 10001,381 AMORTIZATION OF DEBT DISCOU (5,892)(25,955)(4,988)(30,382)(30,834)(1)(19)(60,765)(4,879) 70,862 428,324 428,776 74,785 315,7350 36Total For Interest Expense:845,509 112,589 Other Operating Expense EV CHARGING EXPENSE 300 2,0425942,1192,735 29 344,240 692 LOSS ON DISPOSITION OF PROP (C 3,102 45,21306,2500 (100)(100)12,500 (45,213) OTHER DONATIONS 0 04721,500463 (69)03,000 463 MUTUAL AID 0 01,876 010,632 0 0010,632 PENSION EXPENSE 0 00000 045,000 0 OPEB EXPENSE (208,273)(208,273)0 00 0 100 0 208,273 OTHER INTEREST EXPENSE 0 037802,620 0 002,620 INTEREST EXPENSE - METER DEP 73 4411661,000989 (1)1242,000 548 3,487 17,441 10,870 (204,796)(160,576)60 111Total For Other Operating Expense:66,740 178,017 Customer Accounts Expense METER READING EXPENSE 4,216 20,5243,992 21,04923,819 13 1642,100 3,294 DISCONNECT/RECONNECT EXPEN 1,983 7,9092,633 8,05010,750 34 3616,100 2,840 MISC CUSTOMER ACCOUNTS EXP 22,105 132,10723,435 136,000142,081 4 8272,000 9,974 BAD DEBT EXPENSE & RECOVER 318 2,67267010,0003,454 (65)2920,000 781 30,732 180,105 175,100 28,623 163,2143 10Total For Customer Accounts Expense:350,200 16,891 Administrative Expense SALARIES OFFICE & COMMISSION 70,783 404,54969,468 430,000388,741 (10)(4)860,000 (15,808) SALARIES COVID-19 0 21,0400000 (100)0 (21,040) TEMPORARY STAFFING 0 001,9990 (100)04,000 0 OFFICE SUPPLIES 3,727 40,3127,153 53,50037,373 (30)(7)107,000 (2,939) 69 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETElectric ELECTRIC & WATER CONSUMPTI 2,212 12,0602,551 14,50011,926 (18)(1)29,000 (134) BANK FEES 190 1,1501301,249940 (25)(18)2,500 (209) LEGAL FEES 2,105 12,6372,726 16,00016,440 3 3032,000 3,802 AUDITING FEES 1,500 9,0001,503 9,0199,019 0 018,040 19 INSURANCE 13,106 78,63922,563 91,44291,440 0 16182,884 12,801 UTILITY SHARE - DEFERRED COM 7,290 69,3888,328 61,75075,370 22 9123,500 5,982 UTILITY SHARE - MEDICAL/DENT 53,496 439,05868,347 481,500478,722 (1)9847,000 39,664 UTILITY SHARE - PERA 22,449 129,44322,997 139,999135,783 (3)5280,000 6,340 UTILITY SHARE - FICA 21,519 124,65422,716 132,499131,293 (1)5265,000 6,638 EMPLOYEE SICK PAY 9,505 64,8388,355 66,51277,690 17 20133,025 12,851 EMPLOYEE HOLIDAY PAY 0 50,134053,45138,934 (27)(22)146,991 (11,200) EMPLOYEE VACATION & PTO PA 15,625 122,50417,851 126,705131,273 4 7231,961 8,768 UPMIC DISTRIBUTION 16,386 26,09111,239 30,00021,815 (27)(16)60,000 (4,276) LONGEVITY PAY 0 01,550 01,550 0 001,550 CONSULTING FEES 2,600 23,21213,082 27,49954,198 97 13355,000 30,986 TELEPHONE 2,625 14,3733,098 15,64917,523 12 2231,300 3,149 ADVERTISING 716 7,1441,885 6,4997,729 19 813,000 584 DUES & SUBSCRIPTIONS - FEES 9,551 166,5679,681 65,18259,314 (9)(64)130,365 (107,252) SCHOOLS & MEETINGS 5,523 54,7556,604 111,50095,983 (14)75224,212 41,227 MTCE OF GENERAL PLANT & OFFI 596 3,5796093,7503,656 (2)27,500 77 302,445 1,886,721 1,940,213 261,511 1,875,136(3)1Total For Administrative Expense:3,784,278 11,585 General Expense CIP REBATES - RESIDENTIAL 3,320 17,8594,755 28,95324,352 (16)3657,907 6,493 CIP REBATES - COMMERCIAL 0 11,29850,443 116,10061,126 (47)441232,200 49,828 CIP - ADMINISTRATION 464 2,86942442,6502,587 (94)(10)85,301 (282) CIP - MARKETING 4,236 17,7475,209 23,50014,243 (39)(20)47,000 (3,504) CIP - LABOR 12,830 74,27613,305 50,25673,745 47 (1)100,512 (531) CIP REBATES - LOW INCOME 865 6,63509,2504,185 (55)(37)18,500 (2,450) CIP - LOW INCOME LABOR 952 5,4357674,8755,330 9 (2)9,750 (104) ENVIRONMENTAL COMPLIANCE 2,820 15,6202,596 15,28915,289 0 (2)34,000 (330) MISC GENERAL EXPENSE 217 5,912651,249150 (88)(97)2,500 (5,761) 77,567 201,011 292,124 25,707 157,655(31)28Total For General Expense:587,670 43,355 Total Expenses(before Operating Transfers) 3,537,870 17,869,9264,403,522 18,297,97420,540,508 12 1538,542,498 2,670,582 Operating Transfer 70 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING JUNE 2022 2022 JUNE 2021 JUNE 2022 YTD 2021 YTD 2022 YTD BUDGET 2022 YTD Bud Var% 2021 v. 2022 Actual Var% YTD VARIANCE 2022 ANNUAL BUDGETElectric Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R 119,859 640,757135,995 662,136700,021 6 91,455,457 59,264 135,995 700,021 662,136 119,859 640,7576 9Total For Operating Transfer/Other Funds:1,455,457 59,264 Utilities & Labor Donated UTILITIES & LABOR DONATED TO 19,070 111,0447,876 115,000112,704 (2)1230,000 1,659 7,876 112,704 115,000 19,070 111,044(2)1Total For Utilities & Labor Donated:230,000 1,659 Total Operating Transfer 143,871 812,725 777,136 138,929 751,8015 8Total For Total Operating Transfer:1,685,457 60,924 (202,730)74,805(259,606)278,639 Net Income Profit(Loss)(582,321)(309)(878)2,047,494 (657,127) 71