Loading...
5.1 ERMUSR 07-12-2022��i Elk River � Municipal Utilities UTILITIES COMMISSION MEETING TO: FROM: ERMU Commission Melissa Karpinski — Finance Manager MEETING DATE: AGENDA ITEM NUMBER: July 12, 2022 5.1 SUBJECT: Financial Report — May 2022 ACTION REQUESTED: Receive the May 2022 Financial Report DISCUSSION: Please note that these are the preliminary unaudited financial statements. Electric May's electric kWh sales are up from the prior year, 1%. For further breakdown: • Residential usage is up 6% • Small Commercial usage is up 8% • Large Commercial usage is down 2% Electric Operating Revenues for May of $3,168,266 are more than prior year by 19%o and favorable to budget by 15%. May YTD is more than prior year by 10% and favorable to budget by 6%. The prior YTD variance and budget YTD variance is mainly due to Power Cost Adjustment (PCA) revenue. Other Revenues of $172,856 are less than the prior year by 14% and unfavorable to budget by 13%. Other Revenues YTD is less than the prior year by 12% and is unfavorable to budget by 16%. The main driver of prior YTD variance and budget YTD variance is Interest & Dividend Income. Overall, Total Revenues of $3,341,123 are more than the prior year by 17% and favorable to budget by 13%. YTD is more than the prior year by 8% and favorable to budget by 4%. Purchased Power of $2,378,096 is more than the prior year by 17% and is unfavorable to budget by 22%. YTD is more than prior year by 17% and is unfavorable to budget by 18%. YTD Energy Adjustment Clause (EAC) charge is $1,422,444 more than prior year and $1,552,510 more than budget. EAC charge is partially offset by PCA revenue. Administrative Expenses of $292,981 are less than the prior year by 17% and favorable to budget by 1%. YTD costs are less than the prior year by 2% and are favorable to budget by 4%. Page 1 of 3 63 The main driver of prior YTD variance is Dues & Subscriptions — Fees due to bonding expenses in 2021. General Expenses of $21,682 are less than prior year by 4% and are favorable to budget by 56%. YTD costs are less than the prior year by 6% and are favorable to budget by 49%. Total expenses YTD are 13% more than prior year and are unfavorable to budget by 10%. The main driver causing the prior YTD variance and budget YTD variance is Purchased Power. For May 2022, the Electric Department has a Net Loss of ($81,785) and YTD Net Loss of ($322,715). This is behind the budgeted monthly Net Loss of ($23,793) but is better than prior year monthly Net Loss of ($170,872). YTD is behind the budgeted YTD Net Profit of $484,568 and is less than the prior YTD Net Profit of $277,536. Water May gallons of water sold are down 26% from the prior year. For further breakdown: • Residential use is down 29% • Commercial use is down 22%o Water Operating Revenues for May of $140,237 are less than prior year by 22% and are unfavorable to budget by 8%. YTD is less than prior year by 5% but favorable to budget by 3%. Other Revenues of $71,851 are more than prior year by 10%o but unfavorable to budget by 4%. YTD is more than prior YTD by 100%o and favorable to budget by 105%. The main driver causing the prior YTD variance and budget YTD variance is Connection Fees. Overall, Total Revenues of $212,088 are less than prior year by 14% but more than prior YTD by 32%. YTD Total Revenues are favorable to budget by 40%. Total Expenses of $278,676 are more than prior year by 12% but less than the prior YTD by 1%. YTD is favorable to budget by 2%. For May 2022, the Water Department has a Net Loss of ($66,588) and YTD Net Profit of $127,838. This is behind the budgeted monthly Net Loss of ($39,146) and behind the prior year monthly Net Loss of ($3,393). YTD is ahead of the budgeted YTD Net Loss of ($313,427) and is ahead of the prior YTD Net Loss of ($239,686). ATTACH ME NTS: • Balance Sheet 05.2022 • Electric Balance Sheet 05.2022 • Water Balance Sheet 05.2022 • Summary Electric Statement of Revenues, Expenses and Changes in Net Position �������a • Summary Water Statement of Revenues, Expenses and Changes in Net Position 05.2022 Page 2 of 3 .� • Graphs Prior Year and YTD 2022 • Detailed Electric Statement of Revenues, Expenses and Changes in Net Position 05.2022 • Detailed Water Statement of Revenues, Expenses and Changes in Net Position 05.2022 Page 3 of 3 65 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA COMBINED BALANCE SHEET FOR PERIOD ENDING MAY 2022 ELECTRIC ASSETS CiJRRENT ASSETS CASH ACCOUNTS RECEIVABLE 1NVENTORIES PREPAID ITEMS CONSTRUCTION 1N PROGRESS TOTAL CiJRRENT ASSETS RESTRICTED ASSETS BOND RESERVE FiJND EMERGENCY RESERVE FiJND UNRESTRICTED RESERVE FiJND TOTAL RESTRICTED ASSETS FIXED ASSETS PRODUCTION LFG PROJECT 1'RANSM1SS10N DISTRIBUTION GENERAL FIXED ASSETS (COST) LESS ACCiJMiJI,ATED DEPRECIATION TOTAL FIXED ASSETS, NET INTANGIBLE ASSETS POWER AGENCY MEMBERSHIP BUY-1N LOSS OF REVENUE 1NTANGIBLE LESS ACCiJMiJI,ATED AMORTIZATION TOTAL 1NTANGIBLE ASSETS, NET O'1'Hh;R ASSN;'1'S ANll llN;N'N;RR�;ll OU'1'N'LOWS TOTAL ASSETS LIABILTTIES AND FUND EQUTTY CURR�;N'1' L1AJ31Ll'1'1h;S ACCOUNTSPAYABLE SALARIES AND BENEFITS PAYABLE DUE TO CITY llU�'1'O O'fHN;R r'UNllS NOTES PAYABLE-CiJRRENT PORTION BONDS PAYABLE-CiJRRENT PORTION UNEARNED REVENUE TOTAL CiJRRENT LIABILITIES LONG TERM LIABILITIES OPEB LIABILITY LFG PROJECT DUE TO COUNTY DUE TO CITY BONDS PAYABLE, LESS CiJRRENT PORTION PENSION LIABILITIES TOTAL LONG TERM LIABILITIES TOTAL LIABILTTIES DEFERRED INFLOWS OF RESOURCES FiJND EQUITY CAPITAL ACCOUNT CONST COST CON'1'R1J3U'1'N;ll CAYl'1'AL RETAINED EARNINGS NET INOONIE (LOgg) (THROUGH PREVIOUg MONTH) TOTAL FiJND EQUITY TOTAL LIABILTTIES & FUND EQUTTY 13,522,365 3,531,245 1,151,411 228,839 9,955,265 28,389,126 1,779,016 2,852,369 0 4,631,385 788,761 3,851,442 2,305,024 45,362,913 11,808,072 64,116,211 (34,606,925) 29,509,286 21,546,212 4,349,653 (2,448,678) 23,447,186 1,431,143 87,408,126 5,055,612 506,350 714,293 0 121,989 345,000 7,126 6,750,370 0 0 0 90,720 30,225,044 1,978,758 32,294,522 39,044,892 1,818,303 1,779,016 0 45,088,631 (322,715� 46,544,932 87,408,126 WATER 8,443,250 269,664 19,375 37,714 914,362 9,684,367 0 1,341,533 0 1,341,533 14,883,725 0 0 25,751,342 1,071,732 41,706,799 �21,452,102� 20,254,697 0 0 0 0 266,964 31,547,561 530,466 126,140 3,379 0 0 50,000 51,230 761,215 0 0 0 22,680 1,692,476 369,988 2,085,144 2,846,359 339,354 0 0 28,234,009 127,839 28,361,848 31,547,561 •• ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA ELECTRIC BALANCE SHEET ASSETS CiJRRENT ASSETS CASH ACCOUNTS RECEIVABLE 1NVENTORIES PREPAID ITEMS CONSTRUCTION 1N PROGRESS TOTAL CiJRRENT ASSETS RESTRICTED ASSETS BOND RESERVE FiJND EMERGENCY RESERVE FiJND TOTAL RESTRICTED ASSETS FIXED ASSETS PRODUCTION LFG PROJECT TRANSMISSION DISTRIBUTION Ci�N�RAL FIXED ASSETS �OOST� LESS ACCiJMiJI,ATED DEPRECIATION TOTAL FIXED ASSETS, NET INTANGIBLE ASSETS POWER AGENCY MEMBERSHIP BUY-1N LOSS OF REVENUE 1NTANGIBLE LESS ACCiJMiJI,ATED AMORTIZATION TOTAL 1NTANGIBLE ASSETS, NET OTHER ASSETS AND DEFERRED OUTFLOWS TOTAL ASSETS LIABILTTIES AND FUND EQUTTY CURRENT LIABILITIES ACCOUNTSPAYABLE SALARIES AND BENEFITS PAYABLE DUE TO CITY NOTES PAYABLE-CiJRRENT PORTION BONDS PAYABLE-CiJRRENT PORTION UNEARNED REVENUE TOTAL CiJRRENT LIABILITIES LONG TERM LIABILITIES DUE TO CITY J30NllS YAYAJ3LN;, LN;SS CURR�;N'1' YOR'1'lON YN;NSlON L1AJ31Ll'1'1h;S TOTAL LONG TERM LIABILITIES TOTAL LIABILTTIES DEFERRED INFLOWS OF RESOURCES FiJND EQUITY CAPITAL ACCOUNT CONST COST RETAINED EARNINGS NET INOONIE (LOgg) (THROUGH PREVIOUg MONTH) TOTAL FiJND EQUITY TOTAL LIABILTTIES & FUND EQUTTY May 31, 2022 13,522,365 3,531,245 1,151,411 228,839 9,955,265 28,389,126 1,779,016 2,852,369 4,631,385 788,761 3,851,442 2,305,024 45,362,913 11,808,072 64,116,211 (34,606,925) 29,509,286 21,546,212 4,349,653 (2,448,6'78) 23,447,186 1,431,143 87,408,126 5,055,612 506,350 714,293 121,989 345,000 7,126 6,750,370 90,720 30,225,044 1,978,758 32,294,522 39,044,892 1,818,303 1,779,016 45,088,631 (322,715� 46,544,932 87,408,126 Apri130, 2022 13,220,562 3,703,888 1,183,925 237,003 8,997,291 27,342,669 1,779,016 2,851,420 4,630,436 788,761 3,851,442 2,305,024 45,331,351 11,791,734 64,068,312 �34,414,201� 29,654,111 21,546,212 4,349,653 �2,393,000� 23,502,864 1,431,143 86,561,223 3,990,261 453,547 880,477 139,416 345,000 7,992 5,816,692 90,720 30,230,032 1,978,758 32,299,510 38,116,202 1,818,303 1,779,016 45,088,631 (240,930) 46,626,717 86,561,223 Current Month Change from Prior Month 301,803 (172,643) (32,514) (8,164) 957,974 1,046,457 0 949 949 0 0 0 31,561 16,338 47,899 (192,724) (144,825) 0 0 (55,678) (55,678) 0 846,904 1,065,351 52,804 (166,184) (17,427) 0 (866) 933,678 0 (4,989) 0 (4,989) 928,689 0 0 0 (81,786) (81,786) 846,904 67 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA WATER BALANCE SHEET ASSETS CiJRRENT ASSETS CASH ACCOUNTS RECEIVABLE 1NVENTORIES PREPAID ITEMS CONSTRUCTION 1N PROGRESS TOTAL CiJRRENT ASSETS RESTRICTED ASSETS EMERGENCY RESERVE FiJND TOTAL RESTRICTED ASSETS FIXED ASSETS PRODUCTION DISTRIBUTION GENERAL P'IXED AggETg �OOgT) LESS ACCiJMiJI,ATED DEPRECIATION TOTAL FIXED ASSETS, NET INTANGIBLE ASSETS OTHER ASSETS AND DEFERRED OUTFLOWS TOTAL ASSETS LIABILTTIES AND FUND EQUTTY CURRENT LIABILITIES ACCOUNTSPAYABLE SALARIES AND BENEFITS PAYABLE DUE TO CITY BONDS PAYABLE-CiJRRENT PORTION UNEARNED REVENUE TOTAL CiJRRENT LIABILITIES LONG TERM LIABILITIES DUE TO CITY BONDS PAYABLE, LESS CiJRRENT PORTION PENSION LIABILITIES TOTAL LONG TERM LIABILITIES TOTAL LIABILTTIES DEFERRED INFLOWS OF RESOURCES FiJND EQUITY RETAINED EARNINGS NET INOONIE (LOgg) (THROUGH PREVIOUg MONTH) TOTAL FiJND EQUITY TOTAL L1AB1L1TlES & FUND EQUlTY May 31, 2022 8,443,250 269,664 19,375 37,714 914,362 9,684,367 1,341,533 1,341,533 14,883,725 25,751,342 1,071,732 41,706,799 (21,452102) 20,254,697 266,964 31,547,561 530,466 126,140 3,379 50,000 51,230 761,215 22,680 1,692,476 369,988 2,085,144 2,846,359 339,354 28,234,009 127,839 28,361,848 31,547,561 Apri130, 2022 9,225,482 281,879 25,319 39,465 911,533 10,483,678 1,341,296 1,341,296 14,883,725 25,751,342 1,071,741 41,706,808 �21,360,776� 20,346,031 266,964 32,437,969 1,341,336 115,641 2,792 50,000 74,712 1,584,481 22,680 1,693,030 369,988 2,085,698 3,670,179 339,354 28,234,009 194,427 28,428,436 32,437,969 Current Month Change from Prior Month (782,231) (12,215) (5,944) (1,750) 2,829 (799,311) 237 237 0 0 (9) �9� (91,325) (91,334) 0 (890,408) (810,870) 10,499 587 0 (23,482) (823,266) 0 (554) 0 (554) (823,820) 0 0 (66,588) (66,588) (890,408) •: ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 Electric Revenue Operating Revenue Elk River Otsego Rural Big Lake Dayton Public St & Hwy Lighting Other Electric Sales Total Operating Revenue Other Operating Revenue Interest/Dividend Income Customer Penalties LFG Project Connection Fees Misc Revenue Total Other Revenue Total Revenue Expenses Purchased Power Operating & Mtce E;cpense Landfill Gas Transmission Expense Distribution E;cpense Maintenance Expense Depreciation & Amortization Interest Expense Other Operating E;cpense Customer Accounts E;cpense Administrative Expense General Expense Total Expenses(before Operating Transfers) Operating Transfer Operating Transfer/Other Funds Utilities & Labor ponated Total Operating Transfer Net Income Profit(Loss) 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 2021 YTD 2021 v. 2022 MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% 2,643,865 13,305,743 13,455,618 36,386,442 (1) 2,433,662 12,938,768 366,975 3 209,292 1,147,866 1,053,331 2,915,332 9 184,940 1,075,768 72,097 7 12,579 76,137 80,999 21Q427 (6) 11,300 74,029 2,107 3 15,628 93,131 95,139 25Q448 (2) 13,669 89,100 4,031 5 21,499 107,268 104,166 25Q000 3 2Q922 104,663 2,605 2 265,401 923,843 2,000 4,800 46,092 400 2,000 921,843 46,092 3,168,266 15,653,990 14,791,256 4Q017,450 6 2,664,896 14,284,329 1,369,660 10 (5,154) (122,101) 33,333 80,000 (46� 8,230 28,392 (150,493) (530) 19,153 84,911 85,454 235,000 (1) 0 0 84,911 0 86,700 384,991 418,000 836,000 (8) 77,981 420,285 (35,293) (8) is,i90 66,zzo s9,000 zzo,000 �z6� i9,�zs iio,9so �aa,�so� �ao� 56,967 415,111 366,250 887,000 13 96,141 378,505 36,605 10 172,856 829,133 992,037 2,258,000 (16) 202,079 938,134 (109,000) (12) 3,341,123 16,483,124 15,783,294 42,275,450 4 2,866,975 15,222,464 1,260,660 8 2,378,096 17,408 59,698 4,557 28,590 123,387 248,402 7Q 862 9, 711 28,961 292,981 21,682 3,284,341 11,441,932 106,989 282,241 27,585 173,036 628,214 1,248,478 357,462 13,953 149,372 1,584,276 123,443 16,136,985 9,715,439 128,216 306,565 27,791 144,548 693,541 1,248,666 357,989 9,058 145,916 1,643,546 243,387 14,664,667 27,017,920 18 291,500 (17) 613 131 (8) 66,700 (1) 346,916 20 1,467,100 (9) 3,104,833 0 845,509 0 66,740 54 35Q200 2 3 784 278 (4) 587 670 (49) 38,542,498 10 2,028,382 2Q192 59,507 4,770 2Q035 9Q071 246,806 47,756 389 26,469 354,472 22,530 2,921,383 9,775,121 110,165 300,867 23,111 165,772 565,201 1,226,481 240,950 44,220 134,591 1,613,625 131,947 14,332,055 1,666,810 17 (3 176� (3) �18 625� �6� 4,473 19 7,263 4 63,013 11 21,997 2 116,512 48 (30,267) (68) 14,781 11 (29 348) (2) �8 503� �6� 1,804,930 13 108,962 564,025 538,224 1,455,457 5 98,014 520,897 43,128 8 29,605 104,827 95,833 23Q000 9 18,449 91,973 12,853 14 138,567 668,853 634,058 1,685,457 5 116,464 612,871 55,982 9 (81,785) (322,715) 484,568 2,047,494 (167) (170,872) 277,536 (600,251) (216) �%� Water Revenue Operating Revenue Water Sales Total Operating Revenue Other Operating Revenue Interest/Dividend Income Customer Penalties Connection Fees Misc Revenue Total Other Revenue Total Revenue ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 2021 YTD 2021 v. 2022 MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% 14Q237 675,093 655,710 2,444,916 3 18Q391 707,403 (32,310) (5) 14Q237 675,093 655,710 2,444,916 3 18Q391 707,403 (32,310) (5) (548) (26,997) 15,000 36,000 (280) 2,340 9,053 (36,050) (398) �i ia� s,9s9 6,saa i s,000 �s9� o o s,9s9 0 48,053 661,378 200,000 48Q000 231 39,327 252,936 408,441 161 24,461 122,667 149,907 364,153 (18) 23,601 118,572 4,094 3 71,851 761,038 371,451 898,153 105 65,269 380,563 380,475 100 212,088 1,436,131 1,027,161 3,343,069 40 245,660 1,087,966 348,165 32 Expenses Production E;cpense Pumping Expense Distribution E;cpense Depreciation & Amortization Interest Expense Other Operating E;cpense Customer Accounts E;cpense Administrative Expense General Expense Total Expenses(before Operating Transfers) Operating Transfer Utilities & Labor ponated Total Operating Transfer Net Income Profit(Loss) 7,193 6Q236 28,530 91,325 3, 279 1,009 6,104 8Q571 426 z�s,6�6 39,879 238,542 117,678 461,958 17,600 1,493 31,503 395,676 3,960 1,308,293 31,250 234,583 144,125 471,811 17,599 770 30,916 403,635 5,270 1,339,963 75,000 28 563,000 2 323,100 (18) 1,199 123 (2) 39,720 0 1,850 94 74,200 2 945,251 (2) 12 650 (25) 3 233 895 (2) 5,503 41,156 19,577 95,564 1,051 2 5,754 79,670 773 249,054 izs,o�9 �ss,i99� �69� 204,756 33,786 17 101,678 16,000 16 481,035 (19 076� (4) 6,099 11,500 189 (655) 2,149 328 29,247 2,256 8 373,148 22,528 6 4 1 � �208� �5� i 32� ss� �i9 26a� Ci� 0 0 6zs i,soo �ioo� 0 9s �9s� �ioo� 0 0 6zs i,soo (ioo) 0 9s (9s) (ioo) (66,588) 127,838 (313,427) 107,673 141 (3,393) (239,686) 367,525 153 I(1] 80.0 75.0 70.0 65.0 � � 60.0 c � � 55.0 E d 0 50.0 45.0 40.0 35.0 ,��J�c� e��J�C1 ��tr P�i� �a� ��,c� �J�� PJ�JS'�' ���,p�t oG�o,p�t �e�,pet Ge�,p�t F 5�Q �o Q� Month _ .202 � f 2022 Elk River Municipal Utilities Monthly Energy Purchases 40,000 35,000 x � 30,000 c .N � 25,000 t � � � a 20,000 � ai � d c w 15,000 71 Elk River Municipal Utilities Monthly Electrical Demand ���� �a� ���• ��\ ��� J�� ��� J�� ��c ��c �ec ��� ,� e�� � P � P�� �e�c` o��.o ,e�` G�ct` F 5eQ �a Q� Month -�-202� f2022 Elk River Municipal Utilities Monthly Total Electric Load 40,000 35,000 x � � 30,000 c � R 0 J i 25,000 r ci N W 2�,��0 15,000 ������� ���m�� �m�Gr F� � a� �e �� J5� �t �t et e� Q'Q �S ,J � JO� �`'Q �,p'Q C�•� C�`� Q. ,�e o �e, �e, 5e� O �� Q� Month —�--202� �— 2022 Elk River Municipal Utilities Monthly Electric Sales $4,500,000 $4,000,000 $3,500,000 N i � $3,��0,0�� O 0 C �N $2,500,��� d R � $2,000,000 $1,500,000 $1,000,000 ,a��at� ���Jat� �a�o'� � 72 �c� a� J�� �J�� �5ti �e,t �et ��t ��t P � � P�� ���co O��.o Q,�� �G�� Month 5� � � _ .202� "��>2022 Elk River Municipal Utilities Monthly Residential, Commercial & Industrial Loads 25, 000 20,000 - '��� �,. __ � � ,� ----->�i -- .r� �. 15,000 - x � i� ;� �. � ���--- •� 10,000 - • i � � ��s.�.���---� i� o`�"��``�'���i...; J 5, 000 - .�,� ���..---� .��'. ��R'� ♦� ;�--���: - � � � � � � � �� �� � �Jac� �ac� �tor �i� ��� �.�� ���� �5'� ,p�t ��t ��t ��t ,� e�t � P � P�� �e�` o��.o �ect` G�c�` F �eQ �o Q� Month —t-2021 Residential t2022 Residential 2021 Commercial ��2022 Commercial —� -2021 Industrial —2022 lndustrial Elk River Municipal Utilities Monthly Residential, Commercial & Industrial Sales $2,500,000 � $2,000,000 � �i — �`a $1,500,000 — /' �', �v, — --- ---''..=— o �� - o 0 c � cyi $1,000,000 ���` � �` � �.� � ���y. �. ... .� . �� �`'----� �� � $500,000 �� � � $0 c� t� �r � a� ,�� �� 5� �et ,p�t �et ,oe,t �a�Ja e���� �a� P� � ,� ,� P��� ��� �'�o ��� ��� Q ��Q � �o Qe Month —t-2021 Residential t2022 Residential 2021 Commercial ��2022 Commercial —�K--2021 Industrial — —2022 Industrial 73 Elk River Municipal Utilities Monthly Water Pumpage R C9 c 0 � c d ai a E � a ��. i i 180.0 160.0 140.0 120.0 100.0 80.0 60.0 40.0 20.0 0.0 ��� ---- ___ �� i ' i �� �— � �� i � �— i •� ♦ ♦ � � .. �•. ,a�Jac� �� J�t� �a�Gr PQ�� ��� ,��e ,��� P �J��. �� �ec GQ �c e ��c e ��t t J �` �. � c� � ��� p �aJ oe� Month _ .202� ■ 2022 Elk River Municipal Utilities Peak Day Pumpage �. o 6.0 5.0 R C9 � 4.0 O � 3.0 .� R � 2.0 Y R N a �.o o. o t� t� �r t� a� �� �� 5� ��t ��t �et ��t �a�Ja ���Ja �ai P� � ,J ,J P��� '��� �'�o ��� ��'� � ��Q � �o Q� Month _ .202� f 2022 74 Elk River Municipal Utilities Monthly Water Sales 180 160 140 � 120 c 0 100 � 80 c � 60 R � 40 20 0 a /♦ i '' i,, = ��� �,; .. , __. ��"',' $600,000 � `� $500,000 —F � • ��. —t ' $400,000 i � � � � ♦ — a �� o � ��` $300,000 � . ,� ♦ d � � $200,000 v� ♦ . $100,000 ,' $0 a��at� ���mt� �a�r PQt� �a� ,J�e ,J�� ���5�. ����c G�o�ec e��ec e���,c � �e P eQ� p a� �o Month 5 � � rr�, 2021 MG �2022 MG -�--2021 $ f2022 $ 75 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 Electric MAY YTD BUDGET BUDGET Bud Var% MAY Revenue Operating Revenue Elk River ELECT SALES - ELK RIVER RESID ELECT SALES - ELK RIVER NON-D ELECT SALES - ELK RIVER DEMA Total For Elk River: Otsego ELECT SALES - OTSEGO RESIDEN ELECTSALES-OTSEGO NON-DEM ELECTSALES-OTSEGO DEMAND Total For Otsego: Rural Big Lake ELECT SALES - BIG LAKE RESIDE ELECTSALES-BIG LAKE NON-DE Total For Rural Big Lake: Dayton ELECTSALES-DAYTON RESIDEN ELECT SALES - DAYTON NON-DE Total For Dayton: Public St & Hwy Lighting ELECTSALES-SEC LTS Total For Public St & Hwy Lighting: Other Electric Sales SUB-STATION CREDIT RATEINCREASE Total For Other Electric Sales: Total Operating Revenue Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME Total For Interest/Dividend Income: Customer Penalties CUSTOMER DELINQUENT PENALT Total For Customer Penalties: 869,268 228, 837 1,545,759 2,643,865 8 8, 545 31,231 89,515 209,292 12,419 160 12,579 12,903 2, 724 15,628 21,499 21,499 400 265,001 265,401 3,168, 266 �5 154� �5 154� 19,153 19,153 4,985,850 1,232,529 7,087,363 13,305,743 506,979 162,021 478,865 1,147, 866 75,340 796 76,137 78,458 14,673 93,131 107,268 107,268 2,000 921,843 923,843 15,653,990 (122 101) (122 101) 84,911 84,911 5, OOQ 184 1,233,551 7,221,883 13,455,618 501,680 137,172 414,479 1,053,331 8Q208 790 8Q999 81,549 13,589 95,139 104,166 104,166 2,000 0 2,000 14,791,256 33,333 33,333 85,454 85,454 76 13,522,234 3,228,252 19,635,954 36,386,442 1,367,785 423,970 1,123,576 2,915,332 206,219 4,208 21 Q427 213,485 36,963 25Q448 25Q000 25Q000 4,800 0 4,800 4Q017,450 8Q000 8Q000 235,000 235,000 0 0 ��) (1) 1 18 16 9 (6) 1 (6) (4) 8 ��) 3 3 0 0 46,092 6 (466) (46� (1) (1) 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 776,436 4,814,771 203,980 1,157,992 1,453,245 6,966,004 2,433,662 12,938,768 74,387 475,863 25, 858 142,101 84,694 457,803 184,940 1,075,768 11,110 73,189 189 839 11,300 74,029 11,173 75,047 2,496 14,052 13,669 89,100 2Q922 104,663 2Q922 104,663 400 2,000 0 0 400 2,000 2,664,896 14,284,329 8,230 28,392 8,230 28,392 0 0 0 0 171,078 74,537 121,359 366,975 31,115 19,920 21,061 72,097 2,151 (43) 2,107 3,410 620 4,031 2,605 2,605 0 921,843 921,843 1,369,660 (150,493) (150,493) 84,911 84,911 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2 Electric MAY YTD BUDGET BUDGET Bud Var% LFG Project LFG PROJECT 86,700 384,991 418,000 836,000 (8) Total For LFG Project: 86,700 384,991 418,000 836,000 (8) Connection Fees DISCONNF,CT & RECONNF,CT CHA 15,190 66,220 89,000 22Q000 (26) Total For Connection Fees: 15,190 66,220 89,000 22Q000 (2� Misc Revenue MISC ELEC REVENUE - TEMP CHG 1,290 1,960 833 2,000 135 STREET LIGHT 0 125 5,000 2Q000 (98) TRANSMISSION INVESTMENTS 4Q408 215,064 25Q000 60Q000 (14) MISC NON-UTILITY 6,961 44,868 37,500 9Q000 20 GAIN ON DISPOSITION OF PROPER 0 22,750 0 0 0 CONTRIBUTIONS FROM CUSTOME 8,307 130,343 72,916 175,000 79 Total For Misc Revenue: 56,967 415,111 366,250 887,000 13 Total Other Revenue 172,856 829,133 992,037 2,258,000 (16) Total For Total Other Revenue: 172,856 829,133 992,037 2,258,000 (1� Total Revenue Expenses Purchased Power PURCHASED POWER Total For Purchased Power: Operating & Mtce Expense OPERATING SUPERVISION DIESEL OIL FUEL NATURAL GAS ELECTRIC & WATER CONSUMPTI PLANT SUPPLIES & OTHER EXPEN MISC POWER GENERATION EXPE MAINTENANCE OF STRUCTURE - MTCE OF PLANT ENGINES/GENER MTCE OF PLANT/LAND IMPROVE Total For Operating & Mtce Expense: Landfill Gas 3,341,123 16,483,124 15,783,294 42,275,450 2,378,096 2,378,096 9,912 76 399 2,266 2, 247 136 508 580 1,279 17,408 11,441,932 11,441,932 46,006 1,398 11,549 16,610 3,724 2,209 7,044 5,538 12,907 106,989 9,715,439 9,715,439 59,583 4,166 8,600 13,700 5,416 3,333 6,250 1 Q416 16,750 128,216 27,017,920 27,017,920 143,000 1 Q000 17,500 3Q000 13,000 8,000 15,000 25,000 3Q000 291,500 021 MAY 77,981 77,981 19,725 19,725 300 1Q800 35,306 4,409 0 45,325 96,141 202,079 202,079 2021 YTD 42Q285 42Q285 11 Q950 11 Q950 1,812 37,800 164,456 28,870 0 145,566 378,505 93 8,134 93 8,134 YTD 2021 v. 2022 VARIANCE Actual Var% (35,293) (8) (35,293) (8) (44,730) (40) (44,730) (40) 147 8 (37,675) (100) 50,607 31 15,998 55 22,750 0 (15,222) (10) 36,605 10 (109,000) (12) (109,000) (12) 4 2,866,975 15,222,464 1,260,660 8 18 18 (23) (66� 34 21 (31) (34) 13 (47) (23) (1 � 2,028,382 2,028,382 9,261 68 1,515 1,831 3,436 170 420 2,757 730 2Q192 9,775,121 9,775,121 45,884 2,022 13,541 11,689 7,592 4,362 4,677 7,231 13,164 11Q165 1,666,810 1,666,810 122 (623) (1,992) 4,920 (3 867) (2 153) 2,366 �1,692� (256� (3,176) 17 17 0 (31) (15) 42 (51) (49) 51 (23) (2) (3) I/� Electric ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 MAY YTD BUDGET BUDGET BudVar% MAY LANDFII,L GAS PLANT PURCHASE 15,818 64,501 75,897 151,794 (15) 14,344 LANDFII,L GAS PLANT OPERATIO 41,518 207,593 207,593 415,187 0 43,229 LANDFII,L GAS PLANT ADMINIST 597 1,453 12,775 25,550 (89) 208 LANDFII,L GAS PLANT INSURANC 1,623 8,118 9,975 19,950 (19) 1,607 LANDFII,L GAS PLANT MTCE 140 574 325 650 77 117 Total For Landfill Gas: 59,698 282,241 306,565 613,131 (8) 59,507 Transmission Expense TRANSMISSIONMTCEANDEXPE 4,557 27,585 27,791 66,700 (1) 4,770 Total For Transmission Expense: 4,557 27,585 27,791 66,700 (1) 4,770 Distribution E;cpense REMOVE EXISTING SERVICE & M SCADA EXPENSE TRANSFORMER EXPENSE OH & U MTCE OF SIGNAL SYSTEMS METER EXPENSE - REMO VE & RE TEMP SERVICE - INSTALL & REM MISC DISTRIBUTION EXPENSE INTERCONNECTION CARRYING C Total For Distribution Expense: Maintenance Expense MTCE OFSTRUCTURES MTCE OF SUBSTATIONS MTCE OF SUBSTATION EQUIPME MTCE OF OH LINES/TREE TRIM MTCE OF OH LINES/STANDBY MTCE OF OH PRIMARY MTCE OF URD PRIMARY LOCATEELECTRICLINES LOCATE FIBER LINES MTCE OF LINE TRANSFORMERS MTCE OF STREET LIGHTING MTCE OF SECURITY LIGHTING MTCE OF METERS VOLTAGE COMPLAINTS SALARIES TRANSMISSION & DIST 0 2, 823 1,426 792 0 894 22,654 0 28,590 2,171 5, 831 3,335 889 3,319 24,083 28,524 9,756 65 3,379 4,268 730 6,356 189 2,394 194 16,190 5,243 947 275 1,455 148,729 0 173,036 10,318 12,835 25,876 107,554 14,613 67,779 80,249 34,046 244 12,894 11,192 5,593 34,001 2,586 11,483 1,041 18,333 5,416 833 416 833 116,666 1,006 144,548 12,500 1Q833 28,750 176,000 15,000 7Q833 68,750 43,791 416 25,000 18,750 4,166 33,333 4,166 12,500 7$ 2,500 44,000 13,000 2,000 1,000 2,000 28Q000 2,416 346,916 3Q000 26,000 69,000 225,000 36,000 17Q000 165,000 105,100 1,000 6Q000 45,000 1 Q000 8Q000 1 Q000 3Q000 (81) (12) (3) 14 (34) 75 27 (100) 20 (17) 18 (10) (39) (3) (4) 17 �22� (41) (48) (40) 34 2 (38) �8) 90 2,752 789 0 0 0 16,402 0 2Q035 2,101 337 5,644 0 3,385 20,323 8,447 11,068 15 8,928 (4 685) 454 5,384 261 2,148 2021 YTD 71,039 216,433 3,374 8,038 1,981 30Q867 23,111 23,111 90 16,135 4,293 252 0 1,212 143,788 0 165,772 1Q101 3,861 25,934 56,907 14,874 64,550 82,751 37,470 190 38,227 7,015 3,286 23,090 2,413 1Q891 YTD 2021 v. 2022 VARIANCE Actual Var% (6,538) (9) (8,839) (4) (1,920) (57) 79 1 (1,406) (71) (18,625) (6) 4,473 4,473 19 19 103 55 950 695 275 243 4,941 0 7,263 216 8,973 (57) 50,647 �260� 3,228 (2 502) (3 423) 54 (25 333) 4,177 2,306 10,911 172 591 114 0 22 276 0 20 3 0 4 2 232 0 89 (2) 5 (3) (9) 29 (66) 60 70 47 7 5 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% ELECTRIC MAPPING 5,208 45,221 37,500 9Q000 21 4,461 36,568 8,652 24 MTCE OF OH SECONDARY 1,711 6,046 1 Q416 25,000 (42) 1,816 6,279 (233) (4) MTCE OF URD SECONDARY 4,658 19,378 2Q833 SQ000 (7) 2,829 16,708 2,670 16 TRANSPORTATIONEXPENSE 16,514 126,297 1OQ000 24Q000 26 17,148 124,077 2,220 2 Total For Maintenance Expense: 123,387 628,214 693,541 1,467,100 (9) 9Q071 565,201 63,013 11 Depreciation & Amortization DEPRECIATION 192,724 970,088 97Q277 2,436,698 0 191,128 948,091 21,997 2 AMORTIZATION 55,677 278,389 278,389 668,135 0 55,677 278,389 0 0 Total For Depreciation & Amortization: 248,402 1,248,478 1,248,666 3,104,833 0 246,806 1,226,481 21,997 2 Interest E;cpense INTERESTEXPENSE-BONDS 75,850 383,308 383,308 906,275 0 52,045 262,395 120,913 46 INTEREST EXPENSE - DEFEASED 0 0 0 0 0 (276) (1,381) 1,381 100 AMORTIZATION OF DEBT DISCOU (4,988) (25,846) (25,319) (6Q765) (2) (4,012) (2Q063) (5,783) (29) Total For Interest Expense: 7Q862 357,462 357,989 845,509 0 47,756 24Q950 116,512 48 Other Operating E;cpense EVCHARGINGEXPENSE 411 2,140 1,766 4,240 21 315 1,741 399 23 LOSSONDISPOSITIONOFPROP(C 0 0 5,208 12,500 (100) 0 42,1ll (42,111) (100) OTHER DONATIONS 0 (9) 1,250 3,000 (101) 0 0 (9) 0 MLJTUAL AID 8,756 8,756 0 0 0 0 0 8,756 0 PENSION EXPENSE 0 0 0 45,000 0 0 0 0 0 OTHER INTEREST EXPENSE 378 2,242 0 0 0 0 0 2,242 0 INTEREST EXPENSE - METER DEP 166 823 833 2,000 (1) 73 367 456 125 Total For Other Operating Expense: 9,711 13,953 9,058 66,740 54 389 44,220 (30,267) (68) Customer Accounts Expense METERREADINGEXPENSE 4,349 19,826 17,541 42,100 13 3,476 16,308 3,518 22 DISCONNF,CT/RECONNF,CTEXPEN 1,990 8,116 6,708 16,100 21 956 5,926 2,189 37 MISC CUSTOMER ACCOUNTS EXP 22,476 118,646 113,333 272,000 5 21,254 11 Q001 8,644 8 BAD DEBT EXPENSE & RECOVER 144 2,783 8,333 2Q000 (67) 782 2,354 429 18 Total For Customer Accounts Expense: 28,961 149,372 145,916 35Q200 2 26,469 134,591 14,781 11 Administrative E;cpense SALARIES OFFICE & COMMISSION 67,776 319,273 358,333 86Q000 (11) 64,676 333,766 (14,492) (4) SALARIES COVID-19 0 0 0 0 0 0 21,040 (21,040) (100) TEMPORARY STAFFING 0 0 1,666 4,000 (100) 0 0 0 0 OFFICE SUPPLIES 5,599 30,219 44,583 107,000 (32) 4,463 36,585 (6,365) (17) ELECTRIC & WATER CONSUMPTI 2,323 9,374 12,083 29,000 (22) 2,032 9,848 (473) (5) 79 Electric ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITIO] FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD MAY YTD BUDGET BUDGET Bud Var% BANK FEES 147 809 1,041 2,500 (22) LEGALFEES 5,164 13,714 13,333 32,000 3 AUDITING FEES 1,503 7,516 7,516 18,040 0 INSURANCE 13,262 68,877 76,201 182,884 (10) UTII,ITY SHARE - DEFERRED COM 9,593 67,041 51,458 123,500 30 UTII,ITY SHARE - MEDICAL/DENT 62,903 410,375 42Q583 847,000 (2) UTII,ITY SHARE - PERA 23,355 112,785 116,666 28Q000 (3) UTII,ITYSHARE-FICA 22,833 108,577 11Q416 265,000 (2) EMPLOYEE SICK PAY 8,781 69,334 55,427 133,025 25 EMPLOYEE HOLIDAY PAY 13,759 38,934 53,451 146,991 (27) EMPLOYEE VACATION & PTO PA 17,696 113,422 109,164 231,961 4 UPMIC DISTRIBUTION 0 10,576 15,000 6Q000 (29) CONSiILTINGFEES 4,264 41,116 22,916 55,000 79 TELEPHONE 2,941 14,424 13,041 31,300 11 ADVERTISING 680 5,843 5,416 13,000 8 DiTES & SUBSCRIPTIONS - FEES 1Q176 49,632 54,318 13Q365 (9) SCHOOLS & MEETINGS 19,608 89,378 97,800 224,212 (9) MTCE OF GENERAL PLANT & OFFI 609 3,047 3,125 7,500 (2) Total For Administrative Expense: 292,981 1,584,276 1,643,546 3,784,278 (4) General Expense CIP REBATES - RESIDENTIAL 3,370 19,597 24,127 57,907 (19) CIP REBATES - COMNIERCIAL 0 10,683 96,750 232,200 (89) CIP - ADMINISTRATION 424 2,163 35,542 85,301 (94) CIP - MARKETING 965 9,034 19,583 47,000 (54) CIP - LABOR 13,345 60,439 41,880 1OQ512 44 CIP REBATES - LOW INCOME 0 4,185 7,708 18,500 (46) CIP - LOW INCOME LABOR 888 4,562 4,062 9,750 12 ENVIRONMENTAL COMPLIANCE 2,598 12,693 12,691 34,000 0 MISC GENERAL EXPENSE 90 84 1,041 2,500 (92) Total For General Expense: 21,682 123,443 243,387 587,670 (49) Total Expenses(before Operating Transfers) 3,284,341 16,136,985 14,664,667 38,542,498 10 2021 MAY 186 1,620 1,500 13,106 8,455 56,967 21,033 2Q177 8,806 12,978 16,311 0 16,250 2,813 1,070 88,256 13,170 596 354,472 3,905 32 424 2,595 11,944 0 823 2,817 (12) 22,530 2021 YTD 960 1 Q532 7,500 65,532 62,098 385,561 106,994 103,135 55,333 SQ134 106,879 9,704 2Q612 11,747 6,427 157,015 49,232 2,982 1,613,625 14,539 11,298 2,404 13,511 61,446 5,770 4,482 12,799 5,694 131,947 2,921,383 14,332,055 YTD 2021 v. 2022 VARIANCE Actual Var% (150) (16) 3,181 30 16 0 3,344 5 4,943 8 24,813 6 5,791 5 5,442 5 14,001 25 (11,200) (22) 6,542 6 871 9 20,503 99 2,677 23 (584) (9) (107,382) (68) 40,146 82 64 2 (29,348) (2) 5,058 35 (615) (5) (241) (10) (4,476) (33) (1,006) (2) (1,585) (27) 79 2 (106) (1) (5 609) (99) (8,503) (6) 1,804,930 13 Operating Transfer Operating Transfer/Other Funds TRANSFER TO CITY ELK RIVER R 108,962 564,025 538,224 1,455,457 5 98,014 52Q897 43,128 8 $� ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Electric MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% Total For Operating Transfer/Other Funds: 108,962 564,025 538,224 1,455,457 5 98,014 52Q897 43,128 8 Utilities & Labor ponated UTII,ITIES & LABOR DONATED TO 29,605 104,827 95,833 23Q000 9 18,449 91,973 12,853 14 Total For Utilities & Labor ponated: 29,605 104,827 95,833 23Q000 9 18,449 91,973 12,853 14 Total Operating Transfer Total For Total Operating Transfer: 138,567 668,853 634,058 1,685,457 5 116,464 612,871 55,982 9 NetIncomeProfit(Loss) (81,785) (322,715) 484,568 2,047,494 (167) (170,872) 277,536 (600,251) (216) 81 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% Revenue Operating Revenue Water Sales WATER SALES RESIDENTIAL WATER SALES COMNIERCIAL WATER SALES IRRIGATION Total For Water Sales: Total Operating Revenue Total For Total Operating Revenue: Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME OTHER INTEREST/NIISC REVENUE Total For Interest/Dividend Income: Customer Penalties CUSTOMER PENALTIES Total For Customer Penalties: Connection Fees WATER/ACCESS/CONNF,CTION FE CUSTOMER CONNECTION FEES BULK WATER SALES/HYDRANT R Total For Connection Fees: Misc Revenue MISC NON-UTILITY MISCELLANF,OUS REVENUE HYDRANT MAINTENANCE PROGR CONTRIBUTIONS FROM DEVELOP WATER TOWER LEASE Total For Misc Revenue: Total Other Revenue Total For Total Other Revenue: Total Revenue 87,236 47, 243 5,756 14Q237 14Q237 14Q237 �548� 0 �548� �114� (114) 42, 860 3,659 1,533 48,053 0 0 980 0 23,481 24,461 71,851 71,851 212,088 423,429 239,676 11,987 675,093 675,093 675,093 (26�997) 0 (26�997) 3,989 3,989 634,366 25,389 1,622 661,378 25 0 5,233 0 117,408 122,667 761,038 761,038 1,436,131 391,715 251,611 12,383 655,710 655,710 655,710 14,583 416 15,000 6,544 6,544 179,166 14,583 6,250 20Q000 0 0 5,416 27,083 117,407 149,907 371,451 371,451 1,027,161 $2 1,359,866 842,024 243,025 2,444,916 2,444,916 2,444,916 35,000 1,000 36,000 18,000 18,000 43Q000 35,000 15,000 48Q000 0 0 13,000 65,000 286,153 364,153 898,153 898,153 3,343,069 8 (5) (3) 3 3 3 (285) (100) (280) (39) (39) 254 74 (74) 231 0 0 (3) (100) 0 (18) 105 105 40 104,953 50,320 25,117 180,391 180,391 180,391 2,340 0 2,340 0 0 37,916 998 412 39,327 0 0 975 0 22,626 23,601 65,269 65,269 245,660 442,444 231,262 33,696 707,403 707,403 707,403 9,053 0 9,053 0 0 238,536 13,926 473 252,936 0 533 4,905 0 113,133 118,572 38Q563 38Q563 1,087,966 (19,014) 8,414 (21,709) (32,310) (32,310) (32,310) (36,050) 0 (36,050) 3,989 3,989 395,829 11,462 1,149 408,441 25 (533) 327 0 4,275 4,094 380,475 380,475 348,165 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 Water MAY YTD BUDGET BUDGET Bud Var% MAY Expenses Production E;cpense MTCE OF STRUCTURES Total For Production Expense: Pumping Expense SUPERVISION ELECTRIC & GAS UTILITIES SAMPLING CHEMICALFEED MTCE OF ELECTRIC PUMPING EQ MTCE OF WELLS SCADA - PUMPING Total For Pumping Expense: Distribution E;cpense MTCE OF WATER MAINS LOCATE WATER LINES MTCE OF WATER SERVICES WATER METER SERVICE BACKFLOW DEVICE INSPECTION MTCE OF CUSTOMERS SERVICE WATER MAPPING MTCE OF WATER HYDRANTS - PU MTCE OF WATER HYDRANTS - PR WATER CLOTHING/PPE WAGES WATER TRANSPORTATION EXPENSE WATER PERMIT Total For Distribution Expense: Depreciation & Amortization DEPRECIATION Total For Depreciation & Amortization: Interest E;cpense INTEREST EXPENSE - BONDS INTEREST EXPENSE - DEFEASED AMORTIZATION OF DEBT DISCOU 7,193 7,193 5,177 26,656 1,377 3,200 (50) 23,197 676 6Q236 13,893 1,242 35 6,630 1,346 2,330 535 133 48 284 559 1,488 0 28,530 91,325 91,325 3,833 0 �554� 39,879 39,879 25,104 102,328 5,778 8,465 46 92,280 4,539 238,542 24,249 3,171 76 37,250 4,928 11,373 1,531 3,176 302 5,008 2,457 5,781 18,370 117,678 461,958 461,958 20,371 0 (2 771) 31,250 31,250 27,500 112,500 6,250 15,000 0 66,666 6,666 234,583 SQ000 7,083 0 22,916 4,900 12,708 5,208 7,500 2,083 2,916 3,958 6,250 18,600 144,125 471,811 471,811 20,371 0 (2,771) 83 75,000 75,000 66,000 27Q000 15,000 36,000 0 16Q000 16,000 563,000 12Q000 17,000 0 55,000 15,000 3Q500 12,500 18,000 5,000 7,000 9,500 15,000 18,600 323,100 1,199,123 1,199,123 46,371 0 (6, 651) 28 28 (9) (9) �8) ��� 0 38 (32) 2 (52) (55) 0 63 1 (10) (71) (58) (86) 72 (38) ��) (1) (18) �2� ��) 0 0 0 5,503 5,503 4,968 25,401 746 3,946 0 5,899 193 41,156 11,141 1,417 0 989 678 2,759 881 637 0 0 552 518 0 19,577 95,564 95,564 1,120 ��� 0 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 128,079 128,079 23,362 103,130 5,028 9,546 36 62,101 1,549 204,756 32,012 6,591 0 13,198 3,391 11,325 2,906 2,397 0 8,489 2,639 3,849 14,875 101,678 481,035 481,035 6,444 (345) 0 (88,199) (88,199) 1,742 (802) 749 (1,081) 9 30,179 2,989 33,786 (7 762) (3 420) 76 24,051 1,537 48 (1,374) 779 302 (3,480) (182) 1,932 3,494 16,000 (19 076� (19,076) 13,926 345 (2,771) Water ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 MAY YTD BUDGET BUDGET BudVar% MAY Total For Interest Expense: 3,279 17,600 17,599 39,720 0 1,051 Other Operating E;cpense DAM MAINTENANCE EXPENSE OTHER INTEREST EXPENSE INTEREST EXPENSE - METER DEP Total For Other Operating Expense: Customer Accounts Expense METER READING EXPENSE MISC CUSTOMER ACCOUNTS EXP BAD DEBT EXPENSE & RECO VER Total For Customer Accounts Expense: Administrative E;cpense SALARIES OFFICE & COMMISSION SALARIES COVID-19 TEMPORARY STAFFING OFFICE SUPPLIES ELECTRIC & WATER CONSUMPTI BANK FEES LEGAL FEES AUDITING FEES INSURANCE UTILITY SHARE - DEFERRED COM UTILITY SHARE - MEDICAL/DENT UTILITY SHARE - PERA UTII,ITY SHARE - FICA EMPLOYEE SICK PAY EMPLOYEE HOLIDAY PAY EMPLOYEE VACATION & PTO PA UPMIC DISTRIBUTION WELLHEAD PROTECTION CONSULTING FEES TELEPHONE ADVERTISING DUES & SUBSCRIPTIONS - FEES SCHOOLS & MEETINGS 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 6,099 11,500 189 9io 9io �z9 i,�so zs o �66�� i,s�� 94 560 0 0 0 0 0 560 4 22 41 100 (48) 2 11 10 1,009 1,493 770 1,850 94 2 (655) 2,149 225 5, 879 0 6,104 19,737 0 0 1,587 580 36 1,244 375 2,217 2, 271 16,235 4,492 4,315 1,796 2,550 3,293 0 0 1,066 688 170 14, 845 2,912 986 30,517 0 31,503 93,118 0 0 5,704 2,343 212 3,381 1,879 11,088 12,252 107,171 21,707 20,770 10,462 6,851 20,781 2,200 4,724 12,101 3,450 1,388 34,432 18,890 1,041 29,666 208 3Q916 97,916 0 416 9,875 3,333 291 3,333 1,879 11,250 11,666 105,105 21,250 2Q416 12,500 1Q181 2Q000 2,750 0 8,333 2,833 2,083 34,500 22,927 84 2,500 71,200 500 74,200 235,000 0 1,000 23,700 8,000 700 8,000 4,510 27,000 28,000 217,000 51,000 49,000 3Q000 28,000 41,000 11,000 2Q000 2Q000 6,800 5,000 73,615 55,025 (5) 3 (100) 2 (5) 0 (100) (42) (30) �2�� 1 0 (1) 5 2 2 2 (16) (33) 4 (20) 0 45 22 (33) 0 (18) 178 5,576 0 5,754 18,808 0 0 2,006 508 42 358 375 2,130 1,411 12,649 3,696 3,534 1,854 2,175 2,462 0 0 2,629 465 267 23,256 887 891 28,356 0 29,247 96,241 1,791 0 12,460 2,462 245 2,247 1,875 1 Q650 8,295 9Q975 19,830 19,119 8,395 9,415 17,347 1,872 0 9,954 2,508 1,985 42,841 11,885 95 2,160 0 2,256 (3 123) (1,791) 0 (6755) (118) (32) 1,133 4 437 3,956 16,195 1,877 1,651 2,066 (2 563) 3,433 327 4,724 2,146 941 (596� (8,409) 7,005 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENLJES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING MAY 2022 2022 2022 2022 2022 YTD ANNLJAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water MAY YTD BUDGET BUDGET Bud Var% MAY YTD VARIANCE Actual Var% MTCE OF GENERAL PLANT & OFFI 152 761 791 1,900 (4) 149 745 16 2 Total For Administrative Expense: 8Q571 395,676 403,635 945,251 (2) 79,670 373,148 22,528 6 General Expense CIP REBATES - RESIDENTIAL 0 285 1,875 4,500 (85) 369 894 (609) (68) CIP REBATES - COMIvIERCIAL 0 0 208 500 (100) 0 0 0 0 CIP - MARKETING 0 529 208 500 154 0 0 529 0 CIP - LABOR 375 1,908 1,958 4,700 (3) 355 1,844 64 4 ENVIRONMENTAL COMPLIANCE 50 1,237 916 2,200 35 48 620 616 99 MISC GENERAL EXPENSE 0 0 104 250 (100) 0 809 (809) (100) Total For General Expense: 426 3,960 5,270 12,650 (25) 773 4,169 (208) (5) Total Expenses(before Operating Transfers) 278,676 1,308,293 1,339,963 3,233,895 (2) 249,054 1,327,557 (19,264) (1) Operating Transfer Utilities & Labor ponated WATER & LABOR DONATED TO CI 0 0 625 1,500 (100) 0 95 (95) (100) Total Operating Transfer Total For Total Operating Transfer: 0 0 625 1,500 (100) 0 95 (95) (100) NetIncomeProfit(Loss) (66,588) 127,838 (313,427) 107,673 141 (3,393) (239,686) 367,525 153 �:�.7