Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.2 ERMUSR 11-10-2020
UTILITIES COMMISSION MEETING TO:FROM: ERMU Commission Melissa Karpinski –Finance Manager MEETING DATE: AGENDA ITEM NUMBER: November 10, 2020 5.2 SUBJECT: 2021 Annual Business Plan: Rates and Review, Stakeholder Communication Plan ACTION REQUESTED: None DISCUSSION: In preparation for budget approval in December, staff continues to work through the 2021 budget process. Based on the 0% wholesale power rate increase and projected expense increases and capital expenditures, a preliminary balanced budget and rates have been drafted. Attached is the following information for your review. Additional budget detail is available upon request. Please contact staff for additional information. 1.Electric Department Expense Budget – The 2021 forecast for electric expenses are a .6% increase over the current year budget. Wholesale power costs make up 67% of the operating budget. Most notable increases are for administrative expense due to the addition of an HR person, and expenses related to bonding for the new field services building. The budgeted Payment in Lieu of Taxes (PILOT) amount for 2021 is $1.6 million. The PILOT is comprised of $1.37 million with the 4% of Elk River City’s sales calculation, and $230,000in donated utilities and labor. At this time there is a 0%rate increaseproposed. 2.Water Department Expense Budget – The 2021 forecast for water expenses are a .3% reductionover the current year budget. Most notable increases are for administrative expense due tothe wellhead protection plan amendment, the addition of an HR person, and expenses related to bonding for the new field services building. At this time there is a 0% rate increase proposed. Staff would like to discuss with the commission the communication plan to customers for the 2021 rates, etc. ______________________________________________________________________________ Page 1 of 2 59 ATTACHMENTS: Proposed Summary of 2021 Budgets Proposed 2021 Electric Revenue and Expense Budget Proposed 2021 Water Revenue and Expense Budget Proposed 2021 Electric Capital Budget Proposed 2021 Water Capital Budget Proposed 2021 Administration and Technical Services Capital Budgets Proposed 2021 Conservation Improvement Program Budget Summary ______________________________________________________________________________ Page 2 of 2 60 ELK RIVER MUNICIPAL UTILITIES SUMMARY OF YEAR 2021 BUDGETS ELECTRICBUDGETSUMMARY2021 ELECTRICREVENUE$39,820,488 ELECTRICEXPENDITURES(38,321,494) ELECTRICNETFORCAPITAL1,498,9943.76%1,109,893110%annualavgdebtsvc2.79% DEBTRETIREMENT(953,000) PROMISSORYNOTETOCOUNTY(206,616) NETLESSDEBTPRINCIPALPMTS339,378 CAPITALEQUIPMENT/CONSTRUCTION(17,329,595) FUNDFROMRESERVES1,000,000*FieldServicesBuildingsiteprep FUNDFROMRESERVES884,185*TerritoryAcquisitionAreas1&2,3&4,5&6LossofRevenue BONDING12,231,000 NET(2,875,032) DEPRECIATION3,105,509 NETTORESERVES230,478*Notethatthisisseparatefromabovefundingofdrawonreserves WATERBUDGETSUMMARY2021 WATERREVENUE$2,778,731 WATEREXPENDITURES(3,092,412) WATERNETFORCAPITAL(313,680)11.29% DEBTRETIREMENT(282,000) NETLESSDEBTPRINCIPALPMTS(595,680) CAPITALEQUIPMENT/CONSTRUCTION(2,157,790) FUNDFROMRESERVES500,000*WaterMainConstruction(Capital) BONDING1,359,000 NET(894,470) DEPRECIATION1,215,839 NETTORESERVES321,369*Notethatthisisseparatefromabovefundingofdrawonreserves Ϋ/ǒƩƩĻƓƷƌǤͲƷğƩŭĻƷƩĻƭĻƩǝĻƭğƩĻƒĻƷ͵ 61 ELKRIVERMUNICIPALUTILITIES ELKRIVER,MINNESOTA 2021ELECTRICBUDGET 2021Annual2020Annual2019Annual BudgetBudgetActual Electric Revenue OperatingRevenue ElkRiver 440.4411ELECTSALESELKRIVERRESIDENTIAL12,599,98511,827,24411,622,469 440.4412ELECTSALESELKRIVERNONDEMAND3,009,9623,142,8803,012,436 440.4413ELECTSALESELKRIVERDEMAND18,759,26418,863,09918,622,414 TotalforElkRiver:34,369,21033,833,22333,257,319 Otsego 440.4416ELECTSALESOTSEGORESIDENTIAL1,274,4991,196,3361,164,319 440.4417ELECTSALESOTSEGONONDEMAND395,302412,758395,770 440.4418ELECTSALESOTSEGODEMAND1,075,4521,099,8841,076,600 TotalforOtsego:2,745,2532,708,9782,636,689 RuralBigLake 440.4421ELECTSALESBIGLAKERESIDENTIAL192,155180,370176,484 440.4422ELECTSALESBIGLAKENONDEMAND3,924 4,0973,708 TotalforRuralBigLake:196,078184,467180,192 Dayton 440.4431ELECTSALESDAYTONRESIDENTIAL198,925186,725180,895 440.4432ELECTSALESDAYTONNONDEMAND34,46435,98634,798 TotalforDayton:233,389222,711215,693 PublicSt&HwyLighting 440.4414ELECTSALESSECLTS244,000225,195226,649 TotalforPublicSt&HwyLighting:244,000225,195226,649 OtherElectricSales 440.455SUBSTATIONCREDIT4,8004,8004,800 TotalforOtherElectricSales:4,8004,8004,800 TotalforOperatingRevenue:37,792,73037,179,37436,521,342 OtherOperatingRevenue Interest/DividendIncome 460.4691INTEREST&DIVIDENDINCOME70,000100,000159,014 TotalforInterest/DividendIncome:70,000100,000159,014 CustomerPenalties 470.4701CUSTOMERDELINQUENTPENALTIES210,000254,552 TotalforCustomerPenalties:210,000254,552 LFGProject 470.4721LFGPROJECT1,186,3071,166,7421,102,835 TotalforLFGProject:1,186,3071,166,7421,102,835 ConnectionFees 470.4702DISCONNECT&RECONNECTCHARGE145,000150,000194,295 TotalforConnectionFees:145,000150,000194,295 MiscRevenue 470.4703MISCELECREVENUETEMPCHG500600 470.4704STREETLIGHT5,0005,00021,599 470.4715TRANSMISSIONINVESTMENTS460,951300,000422,221BudgetestimateprovidedbyCMPAS 470.4722MISCNONUTILITY60,00050,000114,433 470.4723GAINONDISPOSITIONOFPROPERTY15,000 470.4739PERAPENSIONREVENUE5,717 470.475RENTALPROPERTYINCOME8,08025,662 470.477CONTRIBUTIONSFROMCUSTOMERS100,00075,000125,764 470.478CONTRIBUTIONSFROMGRANTS10,000 TotalforMiscRevenue:626,451438,080740,996 TotalOtherRevenue TotalforTotalOtherRevenue:2,027,758 2,064,8222,451,692 TotalRevenue 39,820,48839,244,19638,973,0341.5% Expenses PurchasedPower 540.5551PURCHASEDPOWER25,546,48025,507,84924,851,301 TotalforPurchasedPower:25,546,48025,507,84924,851,301 Operating&MtceExpense 540.5461OPERATINGSUPERVISION121,000109,513103,807 540.5471DIESELOILFUEL15,00017,00014,455 540.5472NATURALGAS27,00027,00024,994 540.5483ELECTRIC&WATERCONSUMPTIONPLANT33,00033,00031,289 540.5484PLANTSUPPLIES&OTHEREXPENSE10,0007,0008,368 540.5491MISCPOWERGENERATIONEXPENSE7,0007,0005,841 540.5521MAINTENANCEOFSTRUCTUREPLANT19,00019,00030,631 TENGINES/GENERATORS20,00032,00019,825 540.5531MTCEOFPLAN 540.5541MTCEOFPLANT/LANDIMPROVEMENT30,00030,00044,209 TotalforOperating&MtceExpense:282,000281,513283,419 LandfillGas 550.505LANDFILLGASPLANTPURCHASEDGAS182,000180,000172,286Percontract 550.5051LANDFILLGASPLANTOPERATIONS&MTCE518,725511,277529,311 550.5052LANDFILLGASPLANTADMINISTATION57,00035,00017,450Ctybonus,utilitiesandattyfees(increasedfrom$5kto$15K) 550.5053LANDFILLGASPLANTINSURANCE20,00025,00017,160 550.5054LANDFILLGASPLANTMTCE5,0001,172Roofrepair TotalforLandfillGas:782,725751,277737,379 62 ELKRIVERMUNICIPALUTILITIES ELKRIVER,MINNESOTA 2021ELECTRICBUDGET 2021Annual2020Annual2019Annual BudgetBudgetActual Electric TransmissionExpense 560.562TRANSMISSIONMTCEANDEXPENSE49,00039,00039,331 TotalforTransmissionExpense:49,00039,00039,331 DistributionExpense 580.5801REMOVEEXISTINGSERVICE&METERS2,0001,6002,080 580.5821SCADAEXPENSE42,80042,03239,704 580.5831TRANSFORMEREXPENSEOH&URD16,00020,00010,794 580.5851MTCEOFSIGNALSYSTEMS2,0002,000310 580.5861METEREXPENSEREMOVE&RESET1,0001,2006,388 580.5871TEMPSERVICEINSTALL&REMOVE2,0001,200894 580.5881MISCDISTRIBUTIONEXPENSE275,000312,968241,739 580.589INTERCONNECTIONCARRYINGCHARGE2,4162,4164,832 TotalforDistributionExpense:343,216383,416306,741 MaintenanceExpense 590.5911MTCEOFSTRUCTURES27,50021,5005,036 590.5921MTCEOFSUBSTATIONS28,00028,00025,431 590.5922MTCEOFSUBSTATIONEQUIPMENT27,00030,00026,181 590.5931MTCEOFOHLINES/TREETRIM150,000171,000106,712 590.5932MTCEOFOHLINES/STANDBY32,00031,00029,072 590.5933MTCEOFOHPRIMARY140,000140,000125,153 590.5941MTCEOFURDPRIMARY135,000130,000132,921 590.5943LOCATEELECTRICLINES97,00095,00090,191 590.5944LOCATEFIBERLINES1,0001,000373 590.5951MTCEOFLINETRANSFORMERS45,00051,00042,184 590.5961MTCEOFSTREETLIGHTING45,00045,00041,748 590.5962MTCEOFSECURITYLIGHTING10,00012,0008,431 590.5971MTCEOFMETERS85,000107,00076,866 590.5972VOLTAGECOMPLAINTS10,00010,0009,087 590.5981SALARIESTRANSMISSION&DISTRIBUTION43,00045,61739,247 590.5985ELECTRICMAPPING100,000115,00091,744 590.5991MTCEOFOHSECONDARY20,00020,00016,540 590.5992MTCEOFURDSECONDARY41,00041,00033,347 590.5995TRANSPORTATIONEXPENSE225,000225,000219,760 TotalforMaintenanceExpense:1,261,5001,319,1171,120,024 Depreciation&Amortization 595.8031DEPRECIATION2,437,3742,362,5432,188,122Add'lduetoLFGPlantEngines 595.8032AMORTIZATION668,135668,135668,135 TotalforDepreciation&Amortization:3,105,5093,030,6782,856,257 InterestExpense 596.8071INTERESTEXPENSEBONDS622,859657,782694,630 596.8075INTERESTEXPENSEDEFEASEDBONDS(3,317)(3,317)(3,316) 597.8281AMORTIZATIONOFDEBTDISCOUNT(48,152)(48,152)(48,151) TotalforInterestExpense:571,390606,313643,163 OtherOperatingExpense 597.8165EVCHARGINGEXPENSE4,6504,8774,528 597.8213LOSSONDISPOSITIONOFPROP(CAPITAL)12,50012,63017,049 597.8263OTHERDONATIONS3,0004,1042,856 597.8265MUTUALAID29,577 597.8302PENSIONEXPENSE82,00060,000150,775 597.8303OPEBEXPENSE45,0003,00092,537Usedaverage 597.8341INTERESTEXPENSEMETERDEPOSITS13,00023,82822,754 597.84RENTALPROPERTYEXPENSE9,00010,179 TotalforOtherOperatingExpense:160,150117,439330,255 CustomerAccountsExpense 900.9021METERREADINGEXPENSE34,00029,29927,298 900.903DISCONNECT/RECONNECTEXPENSE15,00015,22614,521 900.9051MISCCUSTOMERACCOUNTSEXPENSEUTILITY275,000279,000264,303 900.9061BADDEBTEXPENSE&RECOVERY20,00015,00011,828 TotalforCustomerAccountsExpense:344,000338,525317,950 AdministrativeExpense 920.9201SALARIESOFFICE&COMMISSION762,000755,000697,446HRposition 920.9202SALARIESCOVID19 920.9205TEMPORARYSTAFFING4,0004,000 920.9211OFFICESUPPLIES165,000197,57086,045 920.9212ELECTRIC&WATERCONSUMPTIONOFFICE31,00030,58728,799 920.9213BANKFEES2,6403,0002,251 920.9221LEGALFEES32,00027,50026,786 920.9231AUDITINGFEES18,00017,36016,720 920.9241INSURANCE175,000175,000162,843 926UTILITYSHAREDEFERREDCOMP115,000103,00089,001 920. 920.9261UTILITYSHAREMEDICAL/DENTAL/DISABIL780,000780,000714,622 920.9262UTILITYSHAREPERA262,440255,000241,529 920.9263UTILITYSHAREFICA245,000241,500227,281 920.9264EMPLOYEESICKPAY127,000120,983131,695 920.9265EMPLOYEEHOLIDAYPAY138,500131,643131,797 920.9266EMPLOYEEVACATION&PTOPAY230,000224,957222,218 920.9267UPMICDISTRIBUTION60,00065,00051,685 eldServicesBldgand169Project 920.9291CONSULTINGFEES72,20030,00019,655BondingandAdditionalConsultingServicesforFi 920.9301TELEPHONE31,00023,50022,519 920.9302ADVERTISING15,00015,00016,686 63 ELKRIVERMUNICIPALUTILITIES ELKRIVER,MINNESOTA 2021ELECTRICBUDGET 2021Annual2020Annual2019Annual BudgetBudgetActual Electric 920.9303DUES&SUBSCRIPTIONSFEES219,463162,80097,465Bonding 920.9305SCHOOLS&MEETINGS193,811270,360154,238MMUASafetyLabor&EverydayLeadershipTraining 920.9321MTCEOFGENERALPLANT&OFFICEHEATING9,0005,8417,155 TotalforAdministrativeExpense:3,688,0553,639,6013,148,436 GeneralExpense 920.9269CIPREBATESRESIDENTIAL67,05075,62535,640 920.927CIPREBATESCOMMERCIAL222,200210,200112,422 920.9271CIPADMINISTRATION81,6687206,606 920.9272CIPMARKETING46,00043,40017,229 920.9273CIPLABOR100,083135,338150,344 920.9274CIPREBATESLOWINCOME15,5005,0008,405 920.9275CIPLOWINCOMELABOR15,5004,5009,661 920.9281ENVIRONMENTALCOMPLIANCE32,20030,56429,188 920.9306MISCGENERALEXPENSE2,5004,800708 TotalforGeneralExpense:582,701510,147370,203 TotalExpenses(beforeOperatingTransfers)36,716,72636,524,87535,004,459 OperatingTransfer OperatingTransfer/OtherFunds 597.8262TRANSFERTOCITYELKRIVERREVENUE1,374,768 1,365,0001,157,444 TotalforOperatingTransfer/OtherFunds:1,374,7681,365,0001,157,444 Utilities&LaborDonated 597.8261UTILITIES&LABORDONATEDTOCITY230,000220,000210,790 TotalforUtilities&LaborDonated:230,000220,000210,790 TotalOperatingTransfer TotalforTotalOperatingTransfer:1,604,7681,585,0001,368,234 NetIncomeProfit(Loss)1,498,9941,134,3212,600,341 64 ELKRIVERMUNICIPALUTILITIES ELKRIVER,MINNESOTA 2021WATERBUDGET 2021Annual 2020Annual2019Annual Budget WaterBudgetActual Revenue OperatingRevenue WaterSales 610.6101WaterSalesResidential1,256,7461,242,9621,224,743 610.6102WaterSalesCommercial800,700801,362804,624 610.6103WaterSalesIrrigation242,304.33240,785.28205,855.28 TotalforWaterSales:2,299,7512,285,1092,235,222 TotalOperatingRevenue 2,299,7512,285,1092,235,222 TotalforTotalOperatingRevenue:2,299,7512,285,1092,235,222 OtherOperatingRevenue Interest/DividendIncome 460.4691Interest&DividendIncome38,00038,00038,097 460.4692OtherInterest/MiscRevenue1,0001,0001,088 TotalforInterest/DividendIncome:39,00039,00039,185 CustomerPenalties 620.6301CustomerPenalties15,00017,865 TotalforCustomerPenalties:15,00017,865 ConnectionFees 620.6401Water/Access/ConnectionsFees110,000200,000428,662 620.6402CustomerConnectionFees30,00020,00035,888 620.6407BulkWaterSales/HydrantRental14,0005,00014,695 TotalforConnectionFees:154,000225,000479,245 MiscRevenue 470.4722MiscNonUtility 470.4739PeraPensionRevenue973 470.475RentalPropertyIncome2,0006,416 620.626TransferInFromCity25,000 620.6403MiscellaneousRevenue449 620.6323GainOnDispositionOfProperty 620.6404HydrantMaintenanceProgram11,50011,76012,984 620.6406WaterTowerLease274,480235,713227,050 TotalforMiscRevenue:285,980274,473247,871 TotalOtherRevenue 478,980.36553,473.00784,164.93 TotalforTotalOtherRevenue:478,980.36553,473.00784,164.93 TotalRevenue 2,778,7312,838,5823,019,387 Expenses ProductionExpense 700.7021MTCEOFSTRUCTURES61,20060,00057,354Securityupgrade TotalforProductionExpense:61,20060,00057,354 PumpingExpense 710.7101SUPERVISION63,00055,00049,455 710.7181ELECTRIC&GASUTILITIES240,000230,000229,100 710.7182SAMPLING15,00018,00013,681 710.7183CHEMICALFEED28,00028,00018,435 710.722MTCEOFWELLS175,000186,124144,649 710.723SCADAPUMPING10,00010,0003,767 TotalforPumpingExpense:531,000527,124459,087 DistributionExpense 730.7301MTCEOFWATERMAINS85,00087,22069,733 730.7309LOCATEWATERLINES16,00016,00015,704 730.7312WATERMETERSERVICE45,00045,14341,578 730.7316BACKFLOWDEVICEINSPECTION15,00011,782338devicesandsoftwareexpense 730.7321MTCEOFCUSTOMERSSERVICE25,00027,80522,143 730.7325WATERMAPPING12,00016,00012,404 730.7331MTCEOFWATERHYDRANTSPUBLIC20,00025,00018,159 730.7332MTCEOFWATERHYDRANTSPRIVATE7,0009,0002,897 730.7341WATERCLOTHING/PPE10,0009,0007,823 730.7391WAGESWATER7,5007,0006,121 730.7395TRANSPORTATIONEXPENSE15,00015,00011,073 730.7399WATERPERMIT15,00015,00013,733 TotalforDistributionExpense:272,500283,951221,368 65 ELKRIVERMUNICIPALUTILITIES ELKRIVER,MINNESOTA 2021WATERBUDGET 2021Annual 2020Annual2019Annual Budget WaterBudgetActual Depreciation&Amortization 595.8031DEPRECIATION1,181,3131,215,8391,147,148 TotalforDepreciation&Amortization:1,181,3131,215,8391,147,148 InterestExpense 596.8071INTERESTEXPENSEBONDS14,28824,34533,767 596.8075INTERESTEXPENSEDEFEASEDBONDS(829)(829)(829) TotalforInterestExpense:13,45923,51632,938 OtherOperatingExpense 597.8213LOSSONDISPOSITIONOFPROP(CAPITAL) 597.8264DAMMAINTENANCEEXPENSE1,0008931,442 597.8302PENSIONEXPENSE20,5005,000(17,722)Usedaverage 597.8303OPEBEXPENSE20,0003,00024,663Usedaverage 597.8341INTERESTEXPENSEMETERDEPOSITS500758730 597.84RENTALPROPERTYEXPENSE2,1252,544 TotalforOtherOperatinExpense:42,00011,77611,657 CustomerAccountsExpense 900.9021METERREADINGEXPENSE2,5001,7611,334 900.9051MISCCUSTOMERACCOUNTSEXPENSEUTILITY65,00065,10060,465 900.9061BADDEBTEXPENSE&RECOVERY1,0001,000 TotalforCustomerAccountsExpense:68,50067,86161,799 AdministrativeExpense 920.9201SALARIESOFFICE&COMMISSION211,000212,000197,084HRposition 920.9202SALARIESCOVID19 920.9205TEMPORARYSTAFFING1,0001,000 920.9211OFFICESUPPLIES41,25054,16218,533 920.9212ELECTRIC&WATERCONSUMPTIONOFFICE8,0007,3537,199 920.9213BANKFEES700800542 920.9221LEGALFEES8,0005,5266,264 920.9231AUDITINGFEES4,5004,3404,180 920.9241INSURANCE26,00024,00023,391 920.926UTILITYSHAREDEFERREDCOMP20,00022,00014,612 920.9261UTILITYSHAREMEDICAL/DENTAL/DISABIL208,500208,455174,917 920.9262UTILITYSHAREPERA46,00048,95341,109 920.9263UTILITYSHAREFICA45,00043,99038,523 920.9264EMPLOYEESICKPAY30,00030,00026,370 920.9265EMPLOYEEHOLIDAYPAY28,00028,27522,245 920.9266EMPLOYEEVACATION&PTOPAY40,00037,00035,614 920.9267UPMICDISTRIBUTION10,50011,0007,421 920.9268WELLHEADPROTECTION20,000Wellheadprotectionplanamendment 920.9291CONSULTINGFEES13,50034,0004,662Bonding 920.9301TELEPHONE6,0005,5005,487 920.9302ADVERTISING7,0007,0006,575 920.9303DUES&SUBSCRIPTIONSFEES80,32852,00043,975Bonding 920.9305SCHOOLS&MEETINGS49,31257,87119,352MMUASafetyLabor&EverydayLeadershipTraining 920.9321MTCEOFGENERALPLANT&OFFICEHEATING2,700 1,8891,788 TotalforAdministrativeExpense:907,290897,114699,843 GeneralExpense 920.9269CIPREBATESRESIDENTIAL4,5004,6054,005 920.927CIPREBATESCOMMERCIAL500 920.9272CIPMARKETING500477210 920.9273CIPLABOR4,7004,4894,226 920.9281ENVIRONMENTALCOMPLIANCE2,2001,003934 920.9306MISCGENERALEXPENSE1,2501,1501,216 TotalforGeneralExpense:13,65011,72410,591 TotalExpenses(beforeOperatingTransfers) 3,090,9123,098,9062,701,785 OperatingTransfer Utilities&LaborDonated 597.8261WATER&LABORDONATEDTOCITY1,5001,6301,583 TotalOperatingTransfer TotalforTotalOperatingTransfer:1,5001,6301,583 NetIncomeProfit(Loss)(313,680)(261,953)316,019 66 ElkRiverMunicipalUtilitiesBusinessPlan/Budget 2021ElectricDepartmentCapitalBudget CapitalConstructionProjectsNonRecurringNormalDistribution,Feeders,andSubstations CostDescription $100,000185thAverebuild $75,000OtsegoStreetLights $75,000Highway10projectfromXeniatoJackson $500,000Highway169redefine $100,000CtyRd13TylertoLineAvew/Roundabout $50,000CtyRd33 $140,000RDFPlant $500,000PowerPlantSubstationRelocationReserves $500,000FieldServicesSitePrep(relocatingfeeders)Reserves $200,000Rebuildfeeder73frompowerplanttoHwy10 $100,000CountyRd35FeedertoWaco Subtotal2,340,000$ CapitalConstructionProjectsRecurring CostDescription $200,000TransformersandMeters $350,000NewDevelopmentDistributionInstallation $50,000StreetLighting $50,000OngoingOHEquipReplacement(Poles,Switches,CutOuts) $100,000OngoingURDEquipReplacement(Switches,JBoxes,FusePads) $500TerritoryAcquisitionLossofRevenuepayment(1991contract) $884,185TerritoryAcquisitionLossofRevenuepayment(2015contractArea1&2,3&4,5&6,7&8)Reserves Subtotal1,634,685$ CapitalEquipmentNeeds CostDescription $45,000PickupTrucksTruck#28 $275,000ReplaceDiggerTruckVehicle#10 $300,000ReplaceBoreRigVehicle#56 $60,000MiniSkid $46,160ElectricshareofAdministration $397,750ElectricShareofTechnicalServices Subtotal1,123,910$ $12,231,000 FieldServicesBuilding TotalCapital17,329,595$ ElectricNoteworthyNonRecurringExpenses CostDescription $4,000RepaintTrailer $LaptopComputers,Ipads,Software,Accessories $7,800ElectricshareofAdministration $9,500ElectricshareofTechnicalServices Total21,300$ 67 ElkRiverMunicipalUtilitiesBusinessPlan/Budget 2021WaterDepartmentCapitalBudget WaterCapitalConstructionNeeds CostDescription $30,000Well#6RoofReplacement $40,000Well#8Rehab $100,000FacilityRepair $20,000MeadowvaleBoosterStation $15,000Placeholderforundeterminedprojects $60,000SCADAupgrades $20,000Highway169Redefine $500,000WaterMainConstruction(Capital)Reserves Subtotal785,000$ CapitalEquipmentNeeds CostDescription $Trucks $11,540WatershareofAdministration $2,250WaterShareofTechnicalServices Subtotal $13,790 $1,359,000 FieldServicesBuilding TotalCapital2,157,790$ WaterNoteworthyNonRecurringExpenses CostDescription $3,000Computers $10,000Meters/ERT $1,950WatershareofAdministration $500WatershareofTechnicalServices Total$15,450 68 ElkRiverMunicipalUtilitiesBusinessPlan/Budget 2021AdministrationandTechnicalServicesDepartmentsCapitalBudgets AdministrationCapitalEquipmentNeeds CostDescription $17,000OfficeFurniture $20,000NetworkSwitch(Citymaincore) $5,000NetworkSwitches(ERMU) $8,200NISCLinuxUpgrade $5,000DomainController $2,500Endorser Subtotal$57,700 AdministrationNoteworthyNonRecurringExpenses CostDescription $9,750Computer,Software,Accessories,Scanners,PrintersUpgrades Subtotal9,750$ TotalAdministration$67,450 TechnicalServicesCapitalEquipmentNeeds CostDescription $45,000ESRIBoltOnSoftware Currentlydesignatedasemergency $DieselEnginesEmissionRetrofit350,000$standby,retrofitonholduntilfurthernotice $DieselPlanttorunonNaturalgas.20,00$0Deferreduntilfuturedate $25,000upgradetanksperinspectionissues$25,000Deferreduntil2021orlater $15,000RepairExhaustEngine#3 $5,000RebuildEngine#3 $5,000VOLT/VARImplementation $25,000FiberExtension169toSub $20,000FiberExtensionWacoSub $50,000SubstationMeterandSCADAEquipment $210,000LFGRebuildEngine#2,#3,#4percontract $MeterTestingEquipment $Trucks Subtotal$400,000 TechnicalServicesNoteworthyNonRecurringExpenses CostDescription $10,000Computers,Software,AccessoriesUpgrades Subtotal10,00$0 TotalTechnicalServices410,00$0 TotalCapitalItems$457,700 TotalNonRecuringExpenses19,75$0 69 2021CIPOperatingBudget RequiredSpendingandSavingsGoals TotalSpendingRequirement1.5%ofGOR$547,350.00 LowIncome.2%ofResidentialGOR$26,134.00 MinimumConservationSpendingRequirement$273,675.00 MaximumLoadManagementSpendingRequirement273,675.00$ EnergySavingsGoal(kWh)LineLoss7.6%Subtracted5,005,684 TotalCIPBudget2021 DirectLabor$70,158 General&Administration$45,425 Advertising$46,500 Equipment$12,000 Contract(Includes$32,000MNPUCAssessment)$81,668 Total$255,751 ERMURebates$292,250 TotalallExpensesandRebates$548,001 TotalEstimatedkWhSavings5,006,099 TotalOperatingCIPBudgetNoRebatesOnlyDirectCosts DirectLabor$70,158 Advertising$46,500 Equipment$12,000 Contract(Includes$32,000MNPUCAssessment)$81,668 TotalERMUOperatingExpenses$210,326 TotalRebateBudget ERMUSelfFunded$292,250 TotalRequestedBudget DirectLabor$70,158 Advertising$46,500 Equipment$12,000 Contract(Includes$25,000MNPUCAssessment)$81,668 ERMUSelfFundedRebates$292,250 TotalRequested2021Budget*$502,576 *NoGeneralandAdministrativeIncluded 70