5.1. ERMUSR 11-15-2011
Elk River:
Municipal U
13069 Orono Parkway • P.O. Box 430
Elk River, MN 55330-0430
UTILITIES COMMISSION MEETING
pONERER BI
~~~V~~
F C •,,• c a c D T O S E R V E
Phone: 763.441.2020
Fax: 763.441.8099
TO: FROM:
Elk River Municipal Utilities Commission Troy Adams, P.E. -Utilities Director
John Dietz -Chair
Daryl Thompson -Vice Chair
Al Nadeau -Trustee
MEETING DATE: AGENDA ITEM NUMBER:
November 15, 2011 5.1
SUBJECT:
Review 2012 Bud et
BACKGROUND:
In preparation for budget approval in December, staff continues to work through the 2012 budget
process.
DISCUSSION:
Electric Department Expense Budget
Yeaz to date, wholesale power costs makes up approximately 74% of operating revenue.
Ultimately, the wholesale rates set by Great River Energy (GRE) have an enormous impact on
ERMU's rates. The 2012 wholesale power rates have been finalized by the GRE board. As
the budget stands, their will need to be an increase of 9.12% in revenue recover the increases
associated with the whole sale power costs as applied to the forecasted power sales.
The forecast power sales for ERMU weather normalized result in a slight reduction in sales
for all classes with the exception of data centers. Through the budgeting process the 9.12%
required increase has been reduced to an approximate overall blended revenue increase of
8.33%. Tlvs increase in revenue would result in a net mazgin of less than 2% and a negligible
amount scheduled to net to reserves.
After the audit was received in 2011, there was unrestricted money designated as operating
cash for 2011. This balance could be designated to offset wholesale power cost adjustments
in 2012. This is a topic for discuss by the Commission.
Water Department Expense Budget
As noted in October, the water rate analysis conducted in spring of 2010 established a cash
flow plan that results in the rates remaining unchanged for 2012. The 2012 forecast for water
sales is slightly down and the connections are slightly up. There is also the continued revenue
from the recent water tower antenna space leases.
Conservation Improvement Program (CIPI Budget
As noted in October, the state had mandated a change in CIP effective 2010 that now requires
there to be 1.5% energy reduction instead of spending a 1.5% of revenue on energy reduction.
This requirement of 1.5% energy reduction is not capped at a specific cost and it complicates
the process because energy reduction now needs to be quantified. Project Conserve continues
to be very important program in achieving ERMU's State mandated energy reduction.
ACTION REQUESTED:
No action required at this time.
ATTACHMENTS:
• Proposed Summary of 2012 Budgets
• Proposed 2012 Electric Revenue and Expense Budget
• Proposed 2012 Water Revenue and Expense Budget
• Proposed 2012 Electric Capital Budget
• Proposed 2012 Administration and Technical Services Capital Budgets
• Proposed 2012 Water Capital Budgets
• Proposed 2012 Training and Travel Budget
• Proposed 2012 Conservation Improvement Program Budget
ELK RIVER MUNICIPAL UTILITIES
SUMMARY OF YEAR 2012
BUDGETS
ELECTRIC BUDGET SUMMARY 2012
ELECTRIC REVENUE $ 29,275,622
ELECTRIC EXPENDITURES 28,699,773
ELECTRIC NET FOR CAPITAL 575,849 1.97%
DEBT RETIREMENT 532,500
PROMISSORY NOTE TO COUNTY 183,444
LESS DEBT PRINCIPAL PMTS (140,095)
CAPITAL EQUIPMENT/CONSTRUCTION 2,039,000
BONDING
NET (2,179,095)
DEPRECIATION 2,210,000
NET TO RESERVES 30,905
WATER BUDGET SUMMARY 2012
WATER REVENUE $ 2,128,704
WATER EXPENDITURES 2,143,621
WATER NET FOR CAPITAL (14,917)
DEBT RETIREMENT 518,750
GROSS (533,667)
CAPITAL PROJECTS 303,200
BONDING
NET (836,867)
DEPRECIATION 1,050,000
NET TO RESERVES 213,133
BUDGET SUMMARY2012
zo12
ESTIMATED BUDGET
WITH HISTORY
ACCOUNT# DESCRIPTION 2009 2010 2011 2012
ACTUAL ACTUAL BUDGET BUDGET
fii-0440-0411 E.R.RESIDENTIAL ],242,923 7,948,224.00 $7,731,534
81-0440-0416 OTSEGO RESIDENTIAL 894,831 7,009,364.00 947,898
61-0440-0421 B.L.RESIDENTIAL 258,289 275,908.00 2fi9,046
61.0440-0431 DAYTON RESIDENTIAL 173,817 197645.00 167,889
TOTAL RESIDENTWL 8,66),838 8,131,138 8,138,38]
61-0440-0415 E.R.CITY DONATED 171,109 177,487.00 178,220
61-0440-4412 E.R.NON-DEMAND 1,742,918 2,005,403.00 1,901.313
fii-0440-0417 OTSEGO NON DEMAND 274,945 33428fi.00 309,057
81-0440-4422 B.L..NON-DEMAND 7,982 6,397.00 7,562
81-0440-4432 DAYTON NON-DEMAND 25323 27034.00 24,561
TOTAL NON-0EMANO 3.;13.3]8 8,558.68) I,dM,)13
6t-0440-0413 E.R.DEMAND 10,718,498 11,972,773.00 13,700,381
81-0440-0418 OTSEGO DEMAND 776,997 798,989.00 885,018
61-04403423 B.L.DEMAND
61-0440-0433 DAYTON DEMAND
TOTAL DEMAND H,d83,dd5 13,]H,>83 10,393,388
61-0440-0414 E.R.SECURITY LTS 31,259 31 328.00 32,000 $32,200.00
61-0440-0419 OTSEGO SECURITY LTS 9,586 10,131.00 10,500 $10,500.00
61-0440-0424 B.L.SECURITY LTS 1,857 1,660.00 2,000 51,900.00
61-04403434 DAYTON SECURITY LTS 5,077 5,086.00 5,500 55,200.00
TOTAL SECURITVLTS QJBO IB,105 SO,OBO dB,300
61-04403441 PUBLIC ST/HWY LIGHTING 245,242 253,067.00 255,000 $255000.00
TOTAL PUBUL $TMWYLIGHTING X5,303 033081 455,000 356,000
TOTAL SALE$ 33,5]0,103 36,068,880 3B,10]Q9 30d,B00
PROJECTED SALE S 38,330,668.18
RATE INLREA$E WRH WHOLESALEPoWER OOSTfl33% 1,5Bd,B1fl05
TOTAL SALESWIIHCWMATE INLRET$E 3;5)6,408 83036,X0 lB,Id;d)9 38,199,979
6t-04403511 SERVICE CHARGE
61-0440-0550 SUBSTATION CREDIT 12,068 14,014.60 14,000 $14,014.00
61-04403551 GENERATION CREDIT 349,854 351,714.00 350,000 5356,988.00
61-04403552 DIBPERSEO GENERATION 189,801 (192195.00 224,511 $ 1,019,846.00
61-04403553 PCA Dr RATE ADJ
61-04403553 FUEL COST ADJUSTMENT
61-04403555 AIC CREDIT 44,000 $ 40,000.00)
61-04603691 INTEREST INCOME 87,880 89,945.97 75,000 580,000.00
81-04]03700 SECURITY REVENUE 254,773 258,6/fi.82 260,000 $260,000.00
61-04]03701 CUST DEL PENALTIES 209,081 237,319.00 278,000 $245,000.00
81-04703702 CONNECTIONS 78,208 64,761.00 50,000 $46,750.00
61-04703703 MISC/TEMP CHG 500 50.00 2,500 $2,500.00
61-04703704 STREETLIGHTS 5,400
61-04]03711 MERCH JOBBING/CONTRA
61-0470-4715 NON-UTILITY OPERATIONS 439) 50,010.00 60,000 $60,000.00
61-04703720 GRE GENERATION-PKNG PLNT 2,581.00 57,000.00
61-04703721 LFG 1.009,682 1,003,341.00 1,038,251 $1,037,280.00
61-04703722 MISC NON-UTILITY 32,298 4,234.00 10,000 $26,000.00
61-0470-0723 GAIN ON DISP OF PROP 570.00
61-0470-0724 SALES OF MERCH 1,882 14.00
61-04703760 TRANSFER IN FROM CITY 53,]41.00
TOTAL OTNER
TOTAL REVENUE 1,Bd;]96
24 4168 1,918378
28985 J9 1,80;340
28254719 1.W5,Bd8
29275822
81bf 8afbtl e01' 3W #
201 f.
ESTIMATED BUDGET
WITH HISTORY
ACCOUNT# DESCRIPTION 2009 2010 2011 2012
ACTUAL ACTUAL BUDGET BUDGET
OPERATING/MTCE
f 5461 OPERATING SUPERVISION 62,831 66,388.00 64,543 $72,000.00
6. ~-5462 INT COMBUST SALARIES
_
61-0540-5471 DIESEL OIL FUEL ~
8,221
10,400.75
25,000
$20,000.00
61-0540-5472 NATURAL GAS 18,319 17,171.69 30,000 $25,000.00
61-0540-5481 LOBE OIL 3,250
61-0540-5482 CHEMICALS
61-0540-54(13 STATION PWRNJTR PLANT 44,46) 45,474.12 47,511 $46,500.00
61-0540-5464 PLANT SUPPLIES 9,526 5,95fi.62 10,000 $7,000.00
61-0540-5491 MISC OTHER GEN EXP 5,991 7,028.16 5,000 $7,000.00
61-0540-5521 MTCE STRUCTURE PLANT 30,617 17,124.82 20,000 $18,000.00
61-0540-5531 MTCE ENGINES/GEN 10,329 12,831.32 20,000 $18,000.00
61-0540-5541 MTCE PLANT/LAND IMP 9,755 18,198.18 10,000 $10,000.00
PURLHASEO PoWER 16, 181,/f/ 18,3)],385 18,JT1,03B
GENERATIONCREDIT
61-0540-5551 POW ER PURCHASED 16,161,444 18,373,385.85 19,771,039 $20,492,787.37
61-0540-5552 LFG PURCHASED GAS
61-0540-5561 PLANT STANDBY __
61-0550-5050 LFG PURCHASED GAS 156,682 154,224.48 157,648 $156,587.00
61-0550-5051 LANDFILL GAS 08M 982,212 539,133.75 515,848 $534,588.00
61-0550-5052 LFG ADMIN 12,000 12,143.75 15,250 $15,000.00
61-0550-5053 LFG INSURANCE 10,456 11,051.28 11,000 $11,000.00
61-0550-5054 LFG MTCE 2,412.50 2,500 $10000.00
TOTAL 1J,03L8/8 19,293,033 z0)OB,680 31,U3A93
DISTRIBUTION
61-0580-5601 REMOVE EXISTING SERV 626 fi24.98 1,000 $1,000.00
61-0580-5831 TRANSFORMER OH/URD 16,163 24,255.70 22,000 $15,000.00
61-0560-5851 MTCE SIGNAL SYSTEMS 783 649.27 10,000 $3,000.00
61-0580-5861 METER EXPENSE 11,696 12,378.(11 13,000 $14,000.00
61-0580-5871 TEMP SERVICES 397 340.53 5,000 $1,000.00
61-0560-5881 MISC DIST 171,100 144,181.47 150,000 $150,000.00
TOTAL 2G9. T83 183,131 30f,W0 iB/,000
MAINTENANCE
61-0590-5911 MTCE STRUCTURES 4,240 4,465.01 2,500 $25,000.00
61-0590-5921 MTCE SUB-STATIONS 35,753 22,233.52 25,000 $25,000.00
61-05905922 MTCE SUBSTATION EOUIP 5,784 7,139.56 10,000 $10,000.00
61-0590-5931 MTCE OHRREE TRIM 89,555 48,209.21 90,000 $90,000.00
61-0590b932 MTCE OF OH/STANDBY 36.230 29.278.42 30,000 $30,000.00
61-0590-5933 MTCE OF OVERHEAD 76,039 83,949.76 40,000 $55,000.00
6' 5941 MTCE URD 96,225 56,481.27 40,000 $75,000.00
6'. 1943 LOCATE URD PRIMARY 3,094 23,150.62 21,000 $25,000.00
67-~_..~-5951 MTCE LINE TRANSFORMERS 25,549 4,535.68 15,000 $10,000.00
61-0590-5961 MTCE ST LIGHTING 27.110 18,631.07 35,000 $35,000.00
61-0590-5962 MTCE SECURITY lTG 7,704 7,438.34 10,000 $5.000.00
61-0590-5971 MTCE METERS _
61,888 65,250.66 63,000 $63,000.00
61-0590-5972 VOLTAGE COMPLAINTS 6,805 7,174.04 8,000 $8,000.00
61-0590-5981 SALARIES TBD 29.307 29,666.84 35,000 $35,000.00
61-0590-5985 ELECTRIC MAPPING 2,357 21,184.68 20,000 $20,000.00
fit-0590-5991 MTCE OH/2NDRY 8,455 14,541.49 10,000 $15,000.00
61-0590-5992 MTCE URD ELECT SERV 53.fi36 27,831.31 25,000 $25,000.00
61-0590-5993 LOCATE URD SECONDARY 3,049 19,362.61 16,000 $18,000.00
61-0590-5995 TRANSPORTATION EXP 120,460 121,468.50 130,000 $150,000.00
TOTAL 593,300 80B,W1 83LS00 J10,000
OTHER EXPENSE
61-0595-8031 DEPRECWTION 2,126,794 2,062,942.41 2,330,000 $2,210.000.00
61-0596-8071 INT/BONDS LONG TERM 299,452 272.897.12 272,7fi4 $252,238.00
61-0597-8181 COST/EXP MERCH JOBBING
61-0597-8172 SECURITY EXPENSE 177,736 1(19,373.90 220,000 $222.000.00
61-0597-8213 LOSS ON DISP OF PROP 32,173 12,179.00 18,000 $20,000.00
61-0597-6231 COST OF MERCH SOLD 11,601.74
61-059]-8261 ELECT/LABOR DONATED 428,508 434.415.20. 445,000 $447,500.00
61-0597-8262 TRANSFER TO CITY 585,141 657,086.33 ~ 713,/56 $730,025.00
61-0597-8263 OTHER DONATIONS (4,253) 21,589.13 2,500 $2,500.00
61-0597-8281 AMORTIZATION/DEBT DISC 11,169 8,818.93 2,278 $9,777.00
fit-0597-8311 OTHER INT EXP
61-0597-8341 INT PD ON METER DEPOSITS 7,263 584.03 8,000 $8,000.00
61-0597-8399 OPERATING TRANSFERS
TOTAL 3.563,983 3,538,510 /,011,985 3,902,0/0
CUSTOMER ACCOUNTS EXP
61-0900-9021 METER READING 95,450 59,288.97 40,250 $25,000.00
61-0900-9030 COLLECTING DISC/RECONN 30,803 27.]15.94 17,250 $12,000.00
61-0900-9041 NSF (555) 558.91) 1,000 $1,000.00
61-0900-9051 MISC CUST EXP 60,345 70,895.01 100,000 $85,000.00
61-0900-9061 WRITE-OFFS 182,931 100,944.98 100,000 $100,000.00
ToraL 3ae,ws zsfi.zee 3sesoo zz3699
zorZ
ESTIMATED BUDGET
WRH HiSTORV
ACCOUNT# DESCRIPTION 2008 2010 2011 2012
ACTUAL ACTUAL BUDGET BUDGET
AD
61-0920-9201
61-0920-9205
6t-0920-9217
61-0920-9212 MINISTRATIVE/GENERAL EXPE
SALARIES/ADMIN
TEMPORARY STAFFING
OFFICE SUPPLIES/EXP
LTM/ATER OFFICE NSE
351,782
73,383
17,077
423,735.00
57,838.98
17,981.56
387,306
7,880
45,000
13,703
$426,845.90
$0.00
$71,298.87
$13,898.98
61-0920-9213
61-0920-9221
61-0920-9231 BANK CHARGES
LEGAL FEES
AUDITING 5,172
43,939
16,747 4,283.fi4
42,826.78
19,120.00 4,370
40,000
29,540 $4,082.2fi
$38,934.fi3
$12,052.00
61-0920-9247 INSURANCE 129,169 137,fi82.71 142,118 $154,434.12
61-0920-9260 UTIL SHARE DEF COMP 37,401 38,929.79 60,139 $57,290.18
81-0920-9281 UTIL SH INSURANCES 349,457 380,992.31 377,000 $374588.00
61-0920-9262 UTIL SH PERA 129,146 140,584.21 139,829 $137,445.07
81-0920-92fi3 UTIL SH FICA 140,985 140,068.33 144,382 $157,352.83
61-0820-9264 SICK PAY 54,144 93,713.88 40,652 $97,439.77
81-0920-9266 VACATION/HOLIDAY PAY 176,472 200,482.59 156,883 $171,350.60
61-0920-9288 MISCELLANEOUS 120 1,000 $0.00
81-0920-9269 CONSERVATION/IMP/PROD 104,653 167,582.86 742,378 $185,000.00
61-0920-9281 ENVIRONMENTAL COMP 14,005 24,130.32 24,119 $37,884.05
61-0920-9291 CONSULTING 5,182 1,345.41 5,000 $4,944.00
6t-0920-9292 LFG GAS PROJECT 939 $0.00
61-0920-9301 TELEPHONE 14,180 17,230.40 13,918 $17,219.69
61-0920-9302 ADVERTISING 1,212 4,800.10 4,442 $2811.95
fii-0920-9303 DUES/SUBSC/FEES 141,386 108,900.27 209,936 $150,029.93
61-0920-9304 TRAVEL 341 1,821.63 2,120 $9,058.23
ei-0920-9305 SCHOOLS/MEETINGS 101,944 118,708.18 105,000 $105,000.00
61-0920-9306 MISC GENERAL 8,977 5,fi19.66 5,000 $273.22
81-0920-9321 MTCE GEN PLANT/OFF HEAT 3,354 5,834.17 5.000 5,150.00
TOTAL 1,800,881 2,100,249 2,110,]16 1.228,2)0
TOTAL EXPENSE 23 864 893 2fi 113177 27 917 903 28 899 773
7,693,249 7,7J9,785 8 146 863 8,208,985
ELECTRIC 2008 2010 2011 2012
ACTUAL ACTUAL BUDGET BUDGET
TOTAL REVEN UES 2447A 188 28,885,239 28 54719 29 75822
TOTAL EXPEN SES 2J,8548BJ 28,713,171 27917903 28899773
PROFIT LOSS 588698 872,088 J36,816 575849
3.29X 1.19X 1.97Y.
xo1'L
ESTIMATED BUDGET
WRH HISTORY
ACCOUNT# DESCRIPTION 2009 _ 2010 2011 2012
ACTUAL ACTUAL BUDGET BUDGET
62-0460-0691 INTEREST INCOME 141,043 31,802 32,500 $29,000.00
62-ri6604692 OTHER INT/MISC 1,735 2,000 $1,000.00
6 6101 WATER SALES 2,182.110 1,8]6,383 1,926,000 $1,920,3]0.00
6. Si]t UNMETERED SALES 1,000
62-u„e0-6260 TRANSFER IN FROM CITY 17,914
62-0620-0300 SERV DONATED BV CITY
62-Ofi20-6301 CUSTOMER PENALTIES 24,319 19,723 20,000 $17,000.00
62-0820-6401 WAC FEES 56,480 155,]59 27,500 $70,600.00
62-06206402 MISC CONNECTION FEES 26,898 1],575 5,300 $15,300.00
62-0620-6403 MISC REVENUES 3,801 10,531 2,500 $2,000.00
62-Ofi20-6405 CONTRIBUTIONS DEVELOPERS 304,775
62-0620.6406 WATER TOW ER LEASE 35,833 78,000 $73,434.00
TOTAL REVENUES 2 4851 2 72010 2,084800 2128706
Prior Period Ad'uslmenl
ACCOUNT# DESCRIPTION 2009 2010 2011 2012
ACTUAL ACTUAL BUDGET BUDGET
62-0597-8260 OPERATING TRANSFER 20,000 25000 25,000 $25,000.00
ryB BOND) 30.000 36.W0 36,000 35.000
MAINTENANCE
62-0700-7021
MTCE OF STRUCTURES _
15,331
7,230
11,000
$10,000.00
62-0700-7022 TOWER 8 GROUNDS INSPECTION 2,312 745 7,000 $1,400.00
TOTAL 3),613 82,9)5 d],000 36,400
PUMPING
62-0710-7107 ___
SUPERVISION
14.631
8,368
21.500
$8,200.00
62-0710-7181 _ __
SUPPLIESIEXPENSE 221,65] 222,fi85 215,000 $225,000.00
62-0]10-7182 SAMPLING 5,794 6.074 7,500 $1,700.00
62-0710-7183 CHEMICAL FEED 37,658 41,520 50,000 $23,000.00
62-0710-7201 MTCE PUMPING EQUIP 8,075 5,597 12,000 $2,800.00
62-0710-]220 MTCE OF WELLS 68,879 54.741 32,000 $71,325.00
62-0710-7225 GENERATION 80 1,500 $0.00
TOTAL 368,]]0 3]8,983 338.600 336,035
DISTRIBUTION
62 '301 MTCE WATER NIAINS 25.443 32,371 30,000 $14,000.00
6~ !302 WATER VALVE REPAIR 1,856 3,543 3,500 $4,000.00
62-O,.vJ-7309 LOCATE WATER SERVICES ]29 5,730 8,500 $5,000.00
62-0730-7310 LOCATE WATER MAIN ]2 1,364 3,500 $2,500.00
62-0730-]311 MTCE WATER SERVICES 28,574 16,845 44,000 $16,000.00
62-0730-7312 WATER METER SERVICE ~ 9,325 _ 12.256 15,000 $15,000.00
62-0730-7315 INSTALL 8 MTC IRRIG MTRS 5,186 2,848 5,000 $5,000.00
62-0]30-]321 MTCE CUSTOMER SERVICE 18,045 27,819 20,500 $15,000.00
62-0]30-]322 WATER SERVICEINSPECTIONS 137 e6 500 $500.00
62-0]30-]325 WATER MAPPING 1,919 2.379 6,000 $5,500.00
62-0730-]331 MTCE WATER HYDRANTS 3,725 8,482 15,000 $15,000.00
62-0730-7341 MTCE WATER EXPENSE 13,043 10,796 11,000 _ $12.000.00
62-0730-7391 WAGES 6,600 4,183 10,500 $5,500.00
62-0730-7395 TRANSPORTATION 10,318 11,060 13,000 $10,000.00
62-0730-7399 GENERAL EXP/PERMITS 1/,475 13,729 14,000 $14,000.00
TOTAL 169.418 161,d8B 100,000 139,000
OTHER EXPENSE
62-0745-]451 DEPRECIATION 956,993 955,323 1,019,]00 $1,050,000.00
62-0748-7481 __
INT ON BONDS/LONG TERM 274,958 143,361 131,139 $116,632.50
62-0750-7563 AMORTIZATION 93
62-0750-7564 AMORTIZATION 94
62-0]50-]565 AMORTIZATION 97
62-0750-7566 AMORTIZATION 98
62-0]50-75fi] AMORTZATION 2001 3,556 593
62-0]50-7568 AMORTIZATION 2003 2,86] 4,710 2.667 $1,710.00
62-0750-]569 AMORTIZATION 2008 Ref 8,096 7,431 4,]19 $7,431.00
62-0750-]581 2010 GO BONDS AMORT DISCOUNT 602 $3,272.00
TOTAL 1,216,2)0 1,110,816 1,158,123 1,1]6,603
X CUSTOMER ACCTS EXP
62-0]40-]631 METER READING 29,818 17,597 10,800 $],OOD.00
62-0900-9030 COLLECTION EXP 3,220 6,760 6,000 $6,000.00
62-0900-9051 MISC CUSTOMER EXP 24,115 20,fi48 25,000 $25,000.00
62-0900-9061 WRITE-OFFS 4,252 16]9 5,000 $5000.00
ToraL - 61,aos meee 16,eao 43,000
NONOPERATING REVBEXP _
62-0790-7900 OPERATING TRANSFER FROM CITY
62-0790-8261 WATER 8 LABOR DONATED $500.00
soa
z91~L
ESTIMATED BUDGET
vertu uisTrev
ACCOUNTp DESCRIPTION 2009 2010 2011 2012
ACTUAL ACTUAL BUDGET BUDGET
ADMIN/GEN EXPENSE
62-0920-9201 SALARIES/ADMINS 119,154 108,281 94,760 $84,878.39
62-0920-9205 TEMPORARY STAFFING SO 1,920 $0.00
62-0920-8211 OFFICE SUPPLIES/EXP 26,669 25,574 23,000 $30067.34
62-0920-9212 LTMIATER CONSUMP OFFICE 5,553 4,495 3,700 $3,498.75
62-0920-9213 BANK CHARGES 1,724 7,071 1,000 $1,019.17
82-0920-9222 LEGAL FEES 10,59fi 8,789 15,000 $5,274.23
62-0920-9231 AUDIT 5,580 6,780 4,200 $3,073.00
62-0820-9241 INSURANCE 29,824 23,873 35,000 $28,368.89
82-0920-9251 WATER UTIL CONT $0.00
82-0820-9260 UTILITY SHARE DEF COMP 13,199 9,731 11,330 $14,322.55
62-0920-9261 UTIL SH INSURANCE 107,080 83,981 9fi 109 $78,059.20
62-0820-9262 UTIL SH PERA 15,495 13,088 20,000 $15,Bfi5.74
62-0920-9263 UTIL SH FICA 18,865 14,5]5 22,000 $17,142.16
fit-0920-9264 SICK PAV 18,049 24,408 19,333 $14,315.52
62-0920-92fi7 VACMOLIDAY PAV 58,871 50,942 59,000 $33,848.90
62-0920-9265 WELLHEAD PROTECTION PROGRAM 6,121 8,500 $10,000.00
62-0920-9269 CONSERVATION IMP PROGRAM 1,670 3,611 70,000 $10,000.00
62-0920-9293 CONSULTING 9,061 967 20,000 $5,000.00
82-0920-9301 TELEPHONE 4,677 4,299 3,083 §4,300.00
62-0920-9302 ADVERTISING 290 415 890 $750.00
62-0920-9303 DUESISUBSCRIPTIONS 36,5]2 30,889 3],000 537,000.00
62-0920-9306 TRAVEL 2,000 $2,000.00
62-0920-9305 SCHOOLS/MEETINGS 19,191 73,948 75,000 $15,000.00
82-0920&307 MISC GENERAL 93 1,559 500 §500.00
62-0820-8321 MTCE GEN PLANT/OFF HTG 1 118 1 459 1 fi50 $1 650.00
rota. sw,me.ve uaeea soe,~ss m,eee
TOTAL EXPENSE 2368,707 2.125,555 2292,980 2143,821
WATER
TOTAL REVEN UES 2434851 2,472,010 2084,800 2128704
TOTAL EXPEN SES 2,3fi9707 2,125555 2,292,980 2,143,821
PROFR LOSS 85944 348 a 198780 16917
Elk River Municipal Utilities
2012 Electric Department Capital Budget
Capital Construction Projects -Non-Recurring Normal Distribution, Feeders, and Substations
Priority Cost Description
5 $ 100,000 Rebuild O'Day, & O'Brian in Otsego West of Parish
7 $ - Rebuild Sandpiper Estates delayed 2013
6 $ 100,000 Rebuild Riverview Heights Front lot line
1 $ 100,000 Rebuild Irving 4,5,6 7 to front lot line & Presidential Estates
4 $ 75,000 Rebuild 6th & Quinn
2 $ 50,000 Convert Islandview to 7200
3 $ 150,000 Feeder 23 Convert to 7200
$ (26,000) Credit from Cooper Switchgear
$ 45,000 Insulation of storage building
Subtotal $ 594,000
Capital Construction Projects • Recurring
Cost Description
$ 175,000 Transformers and Meters
$ 130,000 New Development Distribution Installation
$ 50,000 Ongoing OH Equip Replacement (Poles, Switches, Cut-Outs)
$ 175,000 Ongoing URD Equip Replacement (Switches, J-Boxes, Fuse Pads)
$ 10,000 Street Lighting Replacement
$ 8,000 Territory Acquisition -compensation on future customers 10 yrs pmt
$ - Additional Feeders _ __
Subtotal $ 548,000
Capital Equipment Needs
Cost Description
$ 75,000 800MHz Mobile Radios (including Technical Services and Adminstration)
$ 10,000 800MHz Base Units
$ 2,400 Pagers (including Technical Services)
$ 5,800 Laptop Computers, Software, Accessories
$ 35,000 Replace Pickup Truck#13 with new F250
$ 35,000 Replace Pickup Truck#2 with new F250
$ - Replace Pickup Truck#22 with new F250 -delayed 2013
$ 175,000 Replace Bucket Truck #5 with new
$ - Replace Digger Derrick Truck #10 with new -delayed 2014
$ - Replace Dump Truck #16 with new -delayed 2015
$ 50,000 New Mini Excavator
$ 250,000 Substation SCADA
Subtotal $ 638,200
Total $ 1,780,200
Elk River Municipal Utilities
2012 Administration and Technical Services Departments Capital Budgets
Administration Capital Equipment Needs
Cost Description
$ 8,500 Computer, Software, Accessories -Upgrades
Subtotal $ 8,500
Administration Noteworthy Non-Recurring Expenses
Cost Description
4 $ 5,000 Website
2 $ 5,000 Phone Message Dialing System
3 $ 5,000 Scanner programming
1 $ 3,500 Vault
$ 2,000 Office Funriture New Chairs
Subtotal
Total $ 29,000
Technical Services Capital Equipment Needs
Cost Description
$ 9,500 Computers, Software, Accessories -Upgrades
$ 15,000 GPS Software and Device
$ 10,000 Power Quality Testing Equipment and Accessories (carried over from 2011)
$ 180,000 Diesel Engines Emission Retrofit ($100,000 carried over from 2011)
$ 35,000 Replace Pickup Truck#20 with new F250
Subtotal $ 249,500
Technical Services Noteworthy Non•Recurring Expenses
Cost Description
Subtotal $ -
Total $ 249,500
Elk River Municipal Utilities
2012 Water Department Capital Budget
Water Capital Construction Needs
Cost Description
$ - Water Main Construction (cycles every other year)
$ 60,000 Well 2 engineering costs
$ 10,000 Well 3 VFD upgrade (may qualify for CIP reimbursement)
$ 29,000 Well 6 Liquid Chlorine transition and roof replacement
$ 68,000 Meters/ERTs
$ 35,000 Jackson Water Tower
Subtotal $ 202,000
Water Noteworthy Non-Recurring Expenses
Cost Description
$ 15,000 Miscellaneous Repairs & Maintenance
$ 6,000 (4) Well Dehumidifiers
$ 5,OD0 Hydrants and Valves Maintenance
$ 24,000 Well 8 Cycled Pulling of Well
$ 5,400 Computers/GIS/SCADA
Subtotal $ 55,400
Capital Equipment Needs
Cost Description
$ 15,000 800MHz Mobile Radios (including Technical Services and Adminstration)
$ 2,500 800MHz Base Units
$ 1,600 Pagers (including Technical Services)
$ 7,000 Roof Well 5
Subtotal $ 26,100
Total $ 283,500
ELK RIVER MUNCIPAL UTILITIES
TRAINING AND TRAVEL BUDGET FOR 2012
Budget Budget Budget
ELECTRIC 2010 2011 2072
MMUA Overhead Hol Line School 3 people 2,874.50 2,910.00 2,910.00
MMUA Untlarground School 3 people 2,874.50 2,910.00 1,940.00
MMUA Transformer School 3peopla 2,250.00 2,310.00 2,310.00
MMUA Substation Workshop 2 people 2,205.00 2,340.00 2,340.00
1st Line Supervision 1 person 570.00 580.00 650.00
Apprenticeship 3peopla 2,800.00 2,750.00 4,100.00
MMUA Meter School 1 person 030.00
MMUA Lacelor Workshop 2 people 325.00
Regional Workshop 3 people 700.00
AdditionalTrsining 2,000.00 2,000.00 1,000.00
15,174.00 15, 800.00 17,305.00
WATER
Water Operators License Seminar 4 people 2,480.00 2,680.00 2,660.00
MN Section AWWA Or MRW 3peopla 1,785.00 1,920.00 1,920.00
1st Line Supervision t person 570.00 580.00 850.00
MMUA Meter School 1 person 830.00
Apprenticeship 1 person 250.00 250.00
Chamber Leadership Pmgram 1 person 350.00
Adtli0onal Training 7,000.00 1,000.00 500.00
5,835.00 6,410.00 7,380.00
TECHNICAL SERVICES
MMUA Locator Workshop 1 parson 680.50 720.00 335.00
MMUA Staking Workshop 1 person 680.50 720.00 720.00
MMUA Diesel Workshop 7 person 820.50 680.00 660.00
APPAIMMUA Meter Workshop 2 people 1,361.00 1,440.00 1,440.00
CAD Workshops 1 parson 2,252.00 1,200.00 1,200.00
Substation School 1 person 780.00
Power Limited Gasses 3 people 924.00 990.00 990.00
Power Quality training 1 person 400.00
Inhered Camera training 1 parson 485.00
Security classes 1 person 400.00
UMMA winter and summer mlg lperson 150.00
1st Line Supervision 1 person 570.00 580.00 850.00
Additional Training 1,000.00 7,000.00 1,000.00
6,086.50 7310.00 9,390.00
ADMINISTRATION
Financial 340.00 405.00 1,200.00
Engineering 4,125.00 2,505.00 2,500.00
MMUA Annual Summer Meeting 2 staff/ 1 wmm 2,870.00 2,755.00 2,800.00
MMUA Legleletive Rountl-up 400.00 400.00 400.00
APPA Legislative Rountl-up 1 staff/ 2 Comm 3,020.00 3,620.00 4,500.00
APPA Annual Meeting 1 staff/ 2 wmm 3,895.00 3,895.00 3,750.00
or Engineering/Operator Workshop
MMUA Supedntentlent Conference 670.00 690.00 750.00
PMUG 4 staff 2,400.00 2,580.00 2,600.00
Headng Test 600.00 650.00 850.00
GaalsNisioning 2,500.00
Customer Service 3,000.00 3,500.00
APPA Management 3,000.00 3,000.00
Chamber Leadership Program 1 person 350.00
Adtlitional Training 3750.00 3750.00 4000.00
27 870.00 29,550.00 30,000.00
SAFETY TRAINING
Safe Driver Training 1,985.00 2,065.00 2,100.00
MMUA Monthly Safely Meetings 27,050.00 27 050.00 24,000.00
29 015.00 29 715.00 26.100.00
EDUCATION 3,000.00 3,000.00 3,000.00
62,782.50 91,185.00 93,155.00
Apprenticeship has 3 intlividuals for 2012; 2 new lineworkers antl 1 current lineworker completing the third year of a four year program
Page 1
8 N 4'~I rNN NN 0 1~ m r < N O
.qi
n'.^.m.N Vi
n
a'
.5 ~O
Y
p
N
R G
N ~ 8
~ ~C6~'G
~ ~ 6S&~ ~$ ~8~ ^ ~~$ 8, $$~
F F
N p
N N p M p
N
p
p
N ~ MM
R ~ p
p
p
M WM p
p p y
~
p
MNMNAN
~~ p
N p p p
ANMN
~ p Q
MN p
M p
8N
$ p
N p p a
NNy
~$ ~ ~$
G ~ S~$~~~ ~ $~A~ 88
~ ~~ R 6~ $a8
~~ N g
$
~
A
$ A M M ~S4
ee
N ~N
66
~ SO $s
SS
B8
yyee
~~S
YIO^OO S
~
n N N H
'x
Q
3
S N
~
O p
y S
b
{ryy
M ^ y~ 1~
N
N
N q ~j y
N
N
N
N
M
N y~ y {
M
N r~
N
~
~ p
p
y
~
W {p
~
M
p
p
O M N
N ^
p
p
0 N M p
p
p
p
p
p
N N M N M M p
N p
p p p
N N M N p
p
N N p
N p
p
N W Q
p
M N p p p
M N N
O_
w
I
V
S a~
w ~ $$ .
w °~$ $$$$ A$° 8,R & $w 3 $ $$S
gg Q
0 3~~T g
i LS ~i $ 3iYi ~X oS~
~ m ~~w g
$ ~
~ S ro $ °
N ~' G M
a pN
W N
««N« {q
O
M
~ y
N p
S
X
~ N y
~~M~ {
~~ N p
p
NN^pSW
W
g
~ pp{
NNMN
w $
y
NS Q
D{ ~ pp pp
NN~
R y8~~ 88 5
S 88~8SS
i 8
A &$~S ~ $ S~
w ° S R AS
Ct
~
~»~ ~~ : ~~ ~~s S ~~s~ s s ~s ~ ~ ~ ~~
a3
bONm
p W 1p
1V (p ^ N W N 0
b 0 0 O
'
L y~
^
e O N m p ' q
r N ' M1 0 0~ O O p
N
~
~'N0 N Ol N ~ m npn 00
8
N 10
N
~
a
_
S O N 0
T 0
V
0 O N
<
O
O_
m O b
m
O O
OI
T
O
G
b
<
O O F O l'! m N~ 4 N p
T y
W O 0 O O W
W O ~~
• 00~ O O ~~C ~p
O Yf W~ 00
~NN^ O ~ ^O
~HNN
b ~ OOYl~
YY 00 Qp
G 8 [OO
G ~
a
C Cl
'~
3 ~"
~ M
WW N
~1 `
1 1 ~ N yF
ai
N c = °
~ ~ 6
~ ~ ~ ~ ~
; ~ ~ 2
•~ ~
~ U ~ ~
4
ry m
Z
i
~=°~
~
3w-
~ 'Q ~ g9
$$ ~$[$jj ~VV(x/~
N 6
~
m
3
zzx
~~
gm $
~e
~ ~~F.9/^(
p
m E
~
6
~w
S
Y~ C m p ~
p
00
U 5 LL
~
c~
¢' m~ N F!
~ W p
d
5 .
W g rj
Tu jy'
~US3~Y
~
~" U
EttSS
g
1~
A 00 IIC~
d0~ U wa m(7 $
U b~a'R' LL w LL ~
a_
~i
K
b
W
U
E
0
U
m
O
M
6
w
S
W
H
q~ L
N
N a
m = _
P LLL
w Na~ov
m ~°o,<
0
9 p
o mm~t~
x s$w '1}E
g@ E u
c°E 3
m ~~~~
R ~g'me~
wed=~~
nNj' ¢C 6iy~
w x~daq
p N 5 ~ ~ 6
m ~~ ~
M ~~m
''g5rc ~'
o acs a
~'~~~s
~66 L
3~LLo
C W
jCFF O
o ~ N
n Ygqq Om e
~tEWa
D O C A ~ ~
~ No33~i