5.1d ERMUSR 09-12-2023Variance Item
043766
(1)(1)(4)(4)(13)(0)
1016(1)111120(4)14(7)47(8)30(10)16(12)1021(14)1195
(30)(6)(23)
142(3)116(11)
(100)(2)(100)(5)(100)(9)
Var%
2023 Actual
729
(248)
(8,169)
12,28515,18026,92889,52566,62164,53858,80496,75722,74034,33583,67627,245
(30,854)(20,415)(98,314)
283,188933,693190,855633,148125,969110,921620,541
(576,999)(300,545)(159,305)(379,941)
1,984,972
(1,362,660)
YTD2022 v.
2022
4,009(134,271)5,24738,4772,10919,550
92,775576,99939,419379,941
2022
JULYYTDVARIANCE
4,800132,8471,365,460
BUDGET
ANNUAL
Bud Var%
2023 YTD
0000810,83270,862499,186
(679)(0)260,00021,495150,259
56
1,66801,540,500122,332888,2399,18611,681,653147,531847,553
YTD 2023
2,8008,09634,19442274,109
2023
YTDBudget
BUDGETVariance
ELK RIVER, MINNESOTA
FOR PERIOD ENDING JULY 2023
ELK RIVER MUNICIPAL UTILITIES
2,800
2023
000000000000
400
5,25038,22940,833(2,604)(6)70,000
19,959123,859131,469(7,610)(6)238,65819,276111,57526,029152,294157,669(5,375)(3)285,47124,235137,11421,555150,988151,66722,52856,58429,16727,4179450,00023,187162,806145,83316,97212250,00020,088135,87
715,10072,941128,333(55,392)(43)220,00016,575103,79590,103741,995544,468197,52736936,231131,291652,46917,451207,191187,91719,27410321,00018,479140,57027,360278,996214,11364,88430369,46617,689214,4586
8,225478,772478,77217,29642,29033,849250,770234,20816,5627401,50036,330216,43525,076221,306339,855(118,550)(35)582,60928,463229,47417,643159,462140,00019,46214240,00019,513132,21756,082(29,247)(403,1
02)373,855931,465,028(67,467)(649,788)
366,9552,064,8541,809,819255,034143,385,657335,5551,781,666150,9191,034,325847,801186,524221,456,231264,7381,334,870112,441947,043945,375262,4851,844,5331,855,203(10,670)(1)3,220,836250,4941,747,7762
72,5262,278,5252,443,633(165,108)(7)4,128,585265,8342,152,556158,087931,229922,043175,7291,090,6911,062,04328,64831,921,653167,044979,770
3,934,75722,343,85223,051,072(707,220)(3)42,041,3263,670,76520,358,8814,369,65424,838,64725,304,497(465,850)(2)46,215,9124,204,17423,904,9544,520,57325,872,97226,152,298(279,326)(1)47,672,1434,468,91
225,239,8243,446,80418,223,87418,745,352(521,478)(3)32,766,0253,512,07618,383,1794,288,76224,811,52825,493,357(681,829)(3)44,285,4624,369,33424,909,842
2023
STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION
JULYYTD
YTD Budget and PYTD variance is due to less than average connection fees in 2023.YTD Budget variance is mainly due to a conservative budgeted amount for contribution from customers.YTD
Budget variance is due to an even budget spread for misc distribution expense. PYTD variance is mainly due to increased labor (inventory, tool repair, maintenance of rubber goods,
electrical apparatus maintenance/repair, and grounds testing/maintenance) expense in 2023. YTD Budget variance is mainly due to increased interest rate on deposits and timing issue
of budgeted amount for loss on disposition of property.PYTD variance is mainly due to increased credit card fees/charges and bad debt expense due to 6 year statute of limitation.YTD
Budget variance is mainly due to less rebate dollars spent than budgeted.PYTD variance due to Furniture & Things energy audit expense of $29K.
ItemVariance of +/- $25,000 and +/- 15%(1)PYTD variance is mainly due to increased usage (4%) and PCA revenue in 2023. (2)PYTD variance is due to accrual of PCA revenue in 2022 (See
Rate Increase on Detailed Statement). (3)Budget variance is due to conservative budgeted amount. PYTD variance is due to the change in Fair Market Value of Investments. (4)PYTD variance
is due to not charging customer penalties in January 2022.(5)PYTD variance is due to the LFG Project coming to an end in 2022.(6)(7)(8)PYTD variance is mainly due to increased labor
for snow removal, additional supplies and increased electric and natural gas expense for new field services building in 2023. (9)PYTD variance is due to the LFG Project coming to an
end in 2022.(10)(11)(12)(13)(14)
ElectricRevenueOperating Revenue Elk River Otsego Rural Big Lake Dayton Public St & Hwy Lighting Other Electric Sales
Total Operating RevenueOther Operating Revenue Interest/Dividend Income Customer Penalties LFG Project Connection Fees Misc Revenue
Total Other Revenue Total RevenueExpenses Purchased Power Operating & Mtce Expense Landfill Gas Transmission
Expense Distribution Expense Maintenance Expense Depreciation & Amortization Interest Expense Other Operating Expense Customer
Accounts Expense Administrative Expense General Expense Total Expenses(before Operating Transfers)Operating Transfer Operating Transfer/Other
Funds Utilities & Labor Donated Total Operating Transfer Net Income Profit(Loss)