Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1g ERMUSR 01-10-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% Revenue Operating Revenue Elk River ELECT SALES - ELK RIVER RESID 908,389 12,476,992 12,366,759 13,522,234 1 811,711 11,908,185 568,806 5 ELECT SALES - ELK RIVER NON-D 235,120 3,023,825 2,957,723 3,228,252 2 205,499 2,776,554 247,271 9 ELECT SALES - ELK RIVER DEMA 1,730,784 18,700,756 18,098,376 19,635,954 3 1,520,594 17,457,132 1,243,624 7 Total For Elk River: 2,874,294 34,201,574 33,422,859 36,386,442 2 2,537,806 32,141,871 2,059,703 6 Otsego ELECT SALES - OTSEGO RESIDEN 96,692 1,326,509 1,254,629 1,367,785 6 79,409 1,190,065 136,443 11 ELECT SALES - OTSEGO NON-DEM 33,207 454,061 390,593 423,970 16 28,890 404,629 49,432 12 ELECT SALES - OTSEGO DEMAND 97,638 1,268,482 1,026,830 1,123,576 24 90,506 1,134,163 134,319 12 Total For Otsego: 227,538 3,049,053 2,672,054 2,915,332 14 198,806 2,728,857 320,196 12 Rural Big Lake ELECT SALES - BIG LAKE RESIDE 13,399 179,958 188,412 206,219 (4) 11,417 171,924 8,033 5 ELECT SALES - BIG LAKE NON -DE 196 4,495 4,043 4,208 11 187 4,293 201 5 Total For Rural Big Lake: 13,595 184,453 192,456 210,427 (4) 11,605 176,218 8,235 5 Dayton ELECT SALES - DAYTON RESIDEN 13,478 190,619 195,775 213,485 (3) 11,658 180,165 10,453 6 ELECT SALES - DAYTON NON -DE 2,692 36,409 33,884 36,963 7 2,524 35,039 1,370 4 Total For Dayton: 16,171 227,029 229,660 250,448 (1) 14,182 215,204 11,824 5 Public St & Hwy Lighting ELECT SALES - SEC LTS 21,686 236,942 229,166 250,000 3 21,136 230,854 6,087 3 Total For Public St & Hwy Lighting: 21,686 236,942 229,166 250,000 3 21,136 230,854 6,087 3 Other Electric Sales SUB -STATION CREDIT 400 4,400 4,400 4,800 0 400 4,400 0 0 RATE INCREASE (186,540) 1,121,387 0 0 0 562,149 562,149 559,238 99 Total For Other Electric Sales: (186,140) 1,125,787 4,400 4,800 25,486 562,549 566,549 559,238 99 Total Operating Revenue 2,967,145 39,024,841 36,750,596 40,017,450 6 3,346,086 36,059,556 2,965,284 8 Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME 4,054 (192,655) 73,333 80,000 (363) (1,879) 52,583 (245,239) (466) Total For Interest/Dividend Income: 4,054 (192,655) 73,333 80,000 (363) (1,879) 52,583 (245,239) (466) Customer Penalties CUSTOMER DELINQUENT PENALT 28,684 266,460 213,636 235,000 25 0 0 266,460 0 Total For Customer Penalties: 28,684 266,460 213,636 235,000 25 0 0 266,460 0 77 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% LFG Project LFG PROJECT 85,151 935,004 836,000 836,000 12 84,632 941,887 (6,883) (1) Total For LFG Project: 85,151 935,004 836,000 836,000 12 84,632 941,887 (6,883) (1) Connection Fees DISCONNECT & RECONNECT CHA 26,050 204,512 200,000 220,000 2 15,830 234,805 (30,292) (13) Total For Connection Fees: 26,050 204,512 200,000 220,000 2 15,830 234,805 (30,292) (13) Misc Revenue MISC ELEC REVENUE - TEMP CHG 0 4,970 1,833 2,000 171 0 2,462 2,507 102 STREET LIGHT 6,300 12,725 15,000 20,000 (15) 0 51,590 (38,865) (75) TRANSMISSION INVESTMENTS 81,553 603,188 550,000 600,000 10 49,162 471,736 131,451 28 MISC NON -UTILITY 5,918 180,382 82,500 90,000 119 7,990 96,297 84,084 87 GAIN ON DISPOSITION OF PROPER 0 78,538 0 0 0 0 0 78,538 0 CONTRIBUTIONS FROM CUSTOME 16,648 296,615 160,416 175,000 85 7,067 372,430 (75,815) (20) Total For Misc Revenue: 110,420 1,176,418 809,750 887,000 45 64,219 994,517 181,901 18 Total Other Revenue 254,360 2,389,740 2,132,719 2,258,000 12 162,803 2,223,793 165,946 7 Total For Total Other Revenue: 254,360 2,389,740 2,132,719 2,258,000 12 162,803 2,223,793 165,946 7 Total Revenue 3,221,506 41,414,581 38,883,316 42,275,450 7 3,508,889 38,283,350 3,131,231 8 Expenses Purchased Power PURCHASED POWER 2,131,934 29,219,252 25,229,145 27,017,920 16 2,217,566 25,831,051 3,388,201 13 Total For Purchased Power: 2,131,934 29,219,252 25,229,145 27,017,920 16 2,217,566 25,831,051 3,388,201 13 Operating & Mtce Expense OPERATING SUPERVISION 13,898 124,239 131,083 143,000 (5) 8,716 99,758 24,480 25 DIESEL OIL FUEL 364 2,250 9,166 10,000 (75) 1,011 6,371 (4,120) (65) NATURAL GAS 2,462 15,823 14,300 17,500 11 1,801 20,769 (4,946) (24) ELECTRIC & WATER CONSUMPTI 3,398 29,508 26,500 30,000 11 3,255 24,845 4,663 19 PLANT SUPPLIES & OTHER EXPEN 4,487 12,974 11,916 13,000 9 165 10,086 2,887 29 MISC POWER GENERATION EXPE 388 4,167 7,333 8,000 (43) 96 6,073 (1,906) (31) MAINTENANCE OF STRUCTURE - 6,804 18,385 13,750 15,000 34 868 10,302 8,083 78 MTCE OF PLANT ENGINES/GENER 469 11,242 22,916 25,000 (51) 14,074 36,973 (25,730) (70) MTCE OF PLANT/LAND IMPROVE 4,872 19,024 25,000 30,000 (24) 448 17,496 1,527 9 Total For Operating & Mtce Expense: 37,146 237,616 261,966 291,500 (9) 30,439 232,678 4,938 2 Landfill Gas 78 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% LANDFILL GAS PLANT PURCHASE 0 136,879 151,794 151,794 (10) 12,811 157,455 (20,576) (13) LANDFILL GAS PLANT OPERATIO 0 395,634 415,187 415,187 (5) 43,229 475,807 (80,172) (17) LANDFILL GAS PLANT ADMINIST 4,617 7,049 25,550 25,550 (72) 366 4,918 2,130 43 LANDFILL GAS PLANT INSURANC 0 17,535 19,950 19,950 (12) 1,623 17,765 (230) (1) LANDFILL GAS PLANT MTCE 140 1,436 650 650 121 137 2,708 (1,272) (47) Total For Landfill Gas: 4,758 558,534 613,131 613,131 (9) 58,169 658,656 (100,121) (15) Transmission Expense TRANSMISSION MTCE AND EXPE 4,773 58,804 61,141 66,700 (4) 8,339 61,360 (2,556) (4) Total For Transmission Expense: 4,773 58,804 61,141 66,700 (4) 8,339 61,360 (2,556) (4) Distribution Expense REMOVE EXISTING SERVICE & M 299 494 2,291 2,500 (78) 0 397 96 24 SCADA EXPENSE 2,713 37,436 40,333 44,000 (7) 2,677 37,360 75 0 TRANSFORMER EXPENSE OH & U 1,004 11,676 11,916 13,000 (2) 6,527 15,181 (3,505) (23) MTCE OF SIGNAL SYSTEMS 0 1,815 1,833 2,000 (1) 0 954 860 90 METER EXPENSE - REMOVE & RE 0 582 916 1,000 (37) 189 1,353 (770) (57) TEMP SERVICE - INSTALL & REM 0 3,298 1,833 2,000 80 704 2,491 807 32 M1SC DISTRIBUTION EXPENSE 43,231 292,905 256,666 280,000 14 9,651 231,719 61,185 26 INTERCONNECTION CARRYING C 0 0 2,214 2,416 (100) 0 0 0 0 Total For Distribution Expense: 47,249 348,208 318,006 346,916 9 19,750 289,458 58,750 20 Maintenance Expense MTCE OF STRUCTURES 3,649 25,599 27,500 30,000 (7) 2,008 23,130 2,468 11 MTCE OF SUBSTATIONS 18,068 56,431 23,833 26,000 137 157 11,842 44,589 377 MTCE OF SUBSTATION EQUIPME 2,876 41,131 63,250 69,000 (35) 1,044 66,789 (25,658) (38) MTCE OF OH LINES/TREE TRIM 4,433 117,815 200,000 225,000 (41) 0 57,763 60,052 104 MTCE OF OH LINES/STANDBY 2,153 30,682 33,000 36,000 (7) 3,607 33,998 (3,315) (10) MTCE OF OH PRIMARY 10,575 175,770 155,833 170,000 13 14,101 144,966 30,803 21 MTCE OF URD PRIMARY 18,147 191,361 151,250 165,000 27 15,411 169,353 22,008 13 LOCATE ELECTRIC LINES 6,962 92,269 96,341 105,100 (4) 8,195 96,794 (4,525) (5) LOCATE FIBER LINES 32 815 916 1,000 (11) 31 308 506 164 MTCE OF LINE TRANSFORMERS 903 37,800 55,000 60,000 (31) 2,892 51,185 (13,385) (26) MTCE OF STREET LIGHTING 11,264 52,324 41,250 45,000 27 2,433 14,716 37,608 256 MTCE OF SECURITY LIGHTING 1,442 21,518 9,166 10,000 135 1,357 12,117 9,400 78 MTCE OF METERS 3,711 71,827 73,333 80,000 (2) 6,223 58,991 12,835 22 VOLTAGE COMPLAINTS 924 7,367 9,166 10,000 (20) 228 7,278 89 1 SALARIES TRANSMISSION & DIST 2,414 25,928 27,500 30,000 (6) 2,160 23,754 2,174 9 79 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% ELECTRIC MAPPING 6,435 79,440 82,500 90,000 (4) 4,842 70,924 8,515 12 MTCE OF OH SECONDARY 2,352 20,150 22,916 25,000 (12) 1,194 18,917 1,232 7 MTCE OF URD SECONDARY 1,608 55,054 45,833 50,000 20 4,671 45,186 9,868 22 TRANSPORTATION EXPENSE 24,799 257,780 220,000 240,000 17 10,190 204,784 52,995 26 Total For Maintenance Expense: 122,756 1,361,068 1,338,591 1,467,100 2 80,752 1,112,805 248,263 22 Depreciation & Amortization DEPRECIATION 177,310 2,155,283 2,203,766 2,436,698 (2) 191,843 2,097,904 57,378 3 AMORTIZATION 55,677 612,457 612,457 668,135 0 55,677 612,457 0 0 Total For Depreciation & Amortization: 232,988 2,767,741 2,816,223 3,104,833 (2) 247,521 2,710,362 57,378 2 Interest Expense INTEREST EXPENSE - BONDS 74,413 832,661 832,661 906,275 0 79,906 738,588 94,073 13 INTEREST EXPENSE - DEFEASED 0 0 0 0 0 0 (276) 276 100 AMORTIZATION OF DEBT DISCOU (4,988) (55,777) (55,702) (60,765) 0 (5,892) (55,417) (360) (1) Total For Interest Expense: 69,424 776,884 776,959 845,509 0 74,014 682,895 93,989 14 Other Operating Expense EV CHARGING EXPENSE 507 6,141 3,886 4,240 58 329 3,667 2,473 67 LOSS ON DISPOSITION OF PROP (C 0 0 11,458 12,500 (100) 0 45,213 (45,213) (100) OTHER DONATIONS 0 3,681 2,750 3,000 34 0 918 2,763 301 DAM MAINTENANCE EXPENSE 0 29 0 0 0 0 0 29 0 MUTUAL AID 0 36,690 0 0 0 0 6,860 29,829 435 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 4,510 0 0 0 730 (1,710) 6,220 364 INTEREST EXPENSE - METER DEP 168 1,826 1,833 2,000 0 75 813 1,012 124 Total For Other Operating Expense: 1,053 52,879 19,928 66,740 165 1,135 (152,510) 205,390 135 Customer Accounts Expense METER READING EXPENSE 3,278 43,866 38,591 42,100 14 4,038 41,342 2,523 6 DISCONNECT/RECONNECT EXPEN 1,893 21,950 14,758 16,100 49 765 15,200 6,750 44 MISC CUSTOMER ACCOUNTS EXP 28,608 281,831 249,333 272,000 13 22,610 247,097 34,734 14 BAD DEBT EXPENSE & RECOVER 83 13,010 18,333 20,000 (29) 870 6,788 6,221 92 Total For Customer Accounts Expense: 33,863 360,658 321,016 350,200 12 28,284 310,428 50,230 16 Administrative Expense SALARIES OFFICE & COMMISSION 69,505 739,650 788,333 860,000 (6) 61,847 732,879 6,770 1 SALARIES COVID-19 0 0 0 0 0 0 21,040 (21,040) (100) TEMPORARY STAFFING 0 0 3,666 4,000 (100) 0 0 0 0 Electric ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER YTD VARIANCE Actual Var% OFFICE SUPPLIES 6,222 64,718 98,083 107,000 (34) 4,551 64,547 171 0 ELECTRIC & WATER CONSUMPTI 5,555 27,326 26,583 29,000 3 1,731 22,781 4,545 20 BANK FEES 296 1,877 2,291 2,500 (18) 177 2,057 (180) (9) LEGAL FEES (3,590) 25,088 29,333 32,000 (14) 1,766 21,162 3,926 19 AUDITING FEES 1,503 16,536 16,536 18,040 0 1,413 15,546 990 6 INSURANCE 16,373 165,656 167,643 182,884 (1) 13,262 144,365 21,291 15 UTILITY SHARE - DEFERRED COM 5,762 107,347 113,208 123,500 (5) 4,523 98,891 8,456 9 UTILITY SHARE - MEDICAUDENT 66,277 791,962 786,083 847,000 1 53,343 706,679 85,282 12 UTILITY SHARE - PERA 24,211 256,403 256,666 280,000 0 22,077 241,602 14,800 6 UTILITY SHARE - FICA 23,480 248,654 242,916 265,000 2 20,864 231,620 17,033 7 EMPLOYEE SICK PAY 10,966 135,870 121,939 133,025 11 15,604 127,009 8,861 7 EMPLOYEE HOLIDAY PAY 43,754 110,768 120,265 146,991 (8) 38,490 114,637 (3,869) (3) EMPLOYEE VACATION & PTO PA 19,628 238,081 214,410 231,961 11 15,511 209,707 28,373 14 UPM1C DISTRIBUTION 0 49,029 45,000 60,000 9 0 42,540 6,489 15 LONGEVITY PAY 0 2,790 0 0 0 0 0 2,790 0 CONSULTING FEES 0 54,690 50,416 55,000 8 4,269 35,015 19,674 56 TELEPHONE 3,416 34,232 28,691 31,300 19 2,823 28,524 5,708 20 ADVERTISING 552 11,838 11,916 13,000 (1) 1,396 13,280 (1,442) (11) DUES & SUBSCRIPTIONS - FEES 15,274 113,177 119,501 130,365 (5) 9,798 217,135 (103,957) (48) SCHOOLS & MEETINGS 14,292 175,986 202,000 224,212 (13) 6,267 112,818 63,168 56 MTCE OF GENERAL PLANT & OFFI 609 6,704 6,875 7,500 (2) 596 6,561 142 2 Total For Administrative Expense: 324,092 3,378,391 3,452,363 3,784,278 (2) 280,316 3,210,406 167,985 5 General Expense CIP REBATES - RESIDENTIAL CIP REBATES - COMMERCIAL CIP - ADMINISTRATION CIP - MARKETING CIP - LABOR CIP REBATES - LOW INCOME CIP - LOW INCOME LABOR ENVIRONMENTAL COMPLIANCE MISC GENERAL EXPENSE Total For General Expense: Total Expenses(before Operating Transfers) 7,730 56,096 53,081 57,907 6 5,396 41,471 14,624 35 0 107,575 212,850 232,200 (49) 6,965 82,297 25,278 31 425 7,991 78,192 85,301 (90) 424 4,993 2,997 60 1,452 27,727 43,083 47,000 (36) 1,216 25,007 2,720 11 12,845 139,948 92,136 100,512 52 11,043 132,748 7,200 5 0 4,185 16,958 18,500 (75) 0 6,635 (2,450) (37) 861 9,547 8,937 9,750 7 845 9,634 (86) (1) 2,617 29,247 30,670 34,000 (5) 2,454 29,813 (565) (2) 1 (1,205) 2,291 2,500 (153) (115) 5,812 (7,017) (121) 25,934 381,114 538,201 587,670 (29) 28,231 338,414 42,700 13 3,035,974 39,501,155 35,746,675 38,542,498 11 3,074,521 35,286,006 4,215,149 12 81 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING NOVEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 Electric NOVEMBER YTD BUDGET BUDGET Bud Var% NOVEMBER Operating Transfer Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R Total For Operating Transfer/Other Funds: Utilities & Labor Donated UTILITIES & LABOR DONATED TO Total For Utilities & Labor Donated: Total Operating Transfer Total For Total Operating Transfer: Net Income Profit(Loss) 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 115,673 1,404,065 1,336,914 1,455,457 5 102,192 1,293,050 111,015 9 115,673 1,404,065 1,336,914 1,455,457 5 102,192 1,293,050 111,015 9 21,041 212,297 210,833 230,000 1 19,463 205,546 6,751 3 21,041 212,297 210,833 230,000 1 19,463 205,546 6,751 3 136,715 1,616,362 1,547,747 1,685,457 4 121,656 1,498,596 117,766 8 48,816 297,063 1,588,893 2,047,494 (81) 312,712 1,498,748 (1,201,684) (80)