5.1. ERMUSR 10-12-2010Elk River -~--
1VlunicipalUtilities
13069 Orono Parkway • P.O. Box 430
Elk River, MN 55330-0430
UTILITIES COMMISSION MEETING
Phone: 7(,3.
Fax: ?63.4
Tu: FROM: I
Elk River Municipal Utilities Commission Troy Adams, P.E. - Director of Operations
John Dietz, Chair
Jerry Gumphrey, Vice Chair
Daryl Thom son, Trustee
MEETING DATE: AGENDA ITEM NUMBER:
October 12, 2010 5.1
(SUBJECT:
2011
and CIP
BACKGROUND:
In preparation for submittal in November, staff continues to work through the 2011 budget
process.
llISCUSSION:
Electric Department Expense Budget
"The wholesale power costs makes up approximately 73.9% of operating revenue. Great River
Energy is still in the process of finalizing their 2011 wholesale power rates. Through
discussions, the preliminary numbers indicate a wholesale power cost increase of 4%. This is
a very preliminary number as GRE is going through an extensive process of budget cuts to be
able to achieve this number. The final board approval of wholesale power rates from GRE
may be delayed this year due to the budget cutting process. This may delay finalization of
2011 ERMU rates and budget. It is projected that the GRE rates will be approved in early
December.
So far this year, electric sales reflect approximately a 4% growth for residential, 4% growth
for small commercial, and a 1.5% reduction for industrial (excluding data centers). Looking
at the recent trends in energy usage and weather normalizing, the 2011 budget reflects mostly
a static change in consumption for these groups. Connections are also expected to remain
stagnant. The overall approach for this year's budget was to control costs and pass on the
wholesale power cost rate increases.
Here are some of the early assumptions used to develop the 2011 electric department expense
budget:
Total forecasted electric sales (kWh) = 5.3 L%
(Residential = 0%, Commercial = 0%, Industrial = -1%, Data Centers = 26.69%)
Connect fees = $50,000
Connect unit fee = $1400/residential lot
Preliminary Electric Wholesale Rate Increase = 4%
Preliminary Electric Retail Rate Increases
Residential =+4.6% (blended increase for a typical customer)
Commercial = +2.5% (blended increase in for a typical customer)
Industrial/Data Centers = 0% change in demand charge and an energy cost increase from
$0.0545 to $0.0575 ($/kWh)
Attached is the electric department expense budget for Commission review.
Water Department Expense Budget
The water expense budget has fewer urilmowns at this point that the electric. The water rate
analysis conducted in spring of 2010 established a cash flow plan that results in the rates
remain unchanged for 201 1. Also determined during the analysis was that the water
connection charge will increase from $2500 to $3000. The 2011 forecast for water sales is
slightly down and the connections are slightly up. There is also the addition of the revenue
from the water tower antenna space leases. Again in 2011 the water department has budgeted
for summer help. In addition, the water department has budgeted for the addition of 1 full
time employee to replace the 1 full time employee that left during 2009.
Attached is the water department expense budget for Commission review.
Conservation Improvement Program (CIP) Budget
The state had mandated a change in CIP effective 2010 that now requires there to be 1.5%
energy reduction instead of spending 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. The state has still not given the
mandate any "teeth" to enforce or penalize. However, as Energy City, we need to make the
best effort to meet the target.
We have received disappointing news from Great River Energy that the Conservation
Improvement Program rebates that ERMU passes on to our customer may be eliminated. The
2011 expense budget reflects the worst case scenario of GRE's program being completely
eliminated and ERMU realizing the full cost of $310,000. Project Conserve continues to be
very important to this program and a large part of ERMU meeting the State's required energy
reduction.
Attached is the proposed 2010 CIP budget for commission review.
ACTION REQUESTED:
No action required at this time.
2011
ESTIMATED BUDGET
wlru ulcrnev
ACCOUNT # ~~ DESCRIPTION 2009 2009 2010 ~ 2,011
BUDGET ~I ACTUAL BUDGET BUDGET
61-0440-4411 _E.R.RESIDENTIAL 7,212,345.00 I ],242,923 ' 7,54],268.48 $26,825,914
61-0440-4416 IOTSEGO RESIDENTIAL
___ 886,045.00 ', 894,631 ~ 928,730.03
61-04403421 IB.LRESIDENTIAL
-__- _'
252858.001
. _
256,289
--
265,752.2011
~ _
F1-0440-443.1 ,DAVTON RESIDENTIAL ~
170,405.00 I --
173,817 T
179,030.65 I __
/TOTAL RESIDENTIAL 8,466,1541 6,56]659'" 9,8207611 26,825,910
1403415 ER.CITV DONATED
-: 160,000
_. 171,109 160,000 '
'E RR NOD 1,846121 00 1 ]42,918 1
684
106.19 -
fii-0460--4417
- _ OTSEGO NON DEMAND 292 388 00 _
276,945 ,
,
266 ]28.30
61-0440-4422 ~B.L..NON-DEMAND 7,425.00 7,982 6,77340
61-0440-44.32 DAYTON NON-DEMAND 25,757.00 ', 25,323 23,496.82
_ ITDTAL NON-DEMAND 2.350.1731 2.222.2]8 2,f4f.IDS'
6t-04404413 IER.DEMAND _ 10921311.00' 10,716498 ~ 1 1,551,824.58
61-0440-4418 'IOTSEGO DEMAND 11
- _ _ 696 fi20.00 776 94] 736 837 OS
61-0440-4423 IB.L.DEMAND 1 .._- _ ___ _ _
61-0440-4433 DAYTON DEMAND
YOTAL DEMAND 11,fi3&572 itABJ.005' 12.268,fifi2
6t-Oa40-a41a E,R.SECURITY LTS 33,270.00 ', 31,2591 32,000.00
61-04404419 OTSEGO SECURITV LTS _ 10,108.00 ' _
9586 ' 10,000.00 'i
61 04x0 4424 B L SECURITV LTS
-_ 7,984.00 '~, 1,857 1 2,000.00 !,
_ _
6b04403434 DAYTON SECURITY LTS _._ _
5,282.00. _
5,077 I __
5,000.00 ~ _ ___
TOTAL SECURITV LTS _ 06,008 47760 '', J9,000'
fit-04404441 PUBLIC ST HWV LIGHTING 242,000 245,242' 250000
_/TOTAL PU9LIC ST/IiWYLIGHTING 242,999 245.2G2 250,000
TOTAL _SA_ES 22.741,8991 22,57640J, 2J.64fl548 ''. 26.825.914
REVENUE INCREASE FOR CIP I 1
RATE INCREASE ' ~ ''. "~. -
TOTAL SALES WITH CIP/RATE INCRE,-
- __. _
__.
- - - 22,741,699 22,5]6,40.1 ~-- _-
2J.649,519 - -
28,625,910
I
. _.
__ t."
i
. _-_
_~_
~
6t-0440 4511 /SERVICE CHARGE
61-0440-4550_~SUB-STATION CREDIT __ L 11,600 12,068 14014 14,000
61-0640-4551 GENERATION CREDIT 3
50
,000 '. -_._
349,954 350
000 350 000
61-04403552 'DISPERSED GENERATION _
_
_ 224,511 I
( )
189,601
( ) _
,
(226,711) (2245
61-0460-4553
PCA or RATE ADJ -
I
61-0440-4553 FUEL COST ADJUSTMENT
61-0440-4555 AIC CREDIT __
____ '_ ~ ~--
_ -
44,000)
61-0460-4691 INTEREST INCOME _ d5,000 '~. 87,8fi01 _
60,000 ~ 75,000
fit-04]0-4700 SECURITV REVENUE 210 000 __ 254,]73 I~ 240 000.1 _ _ 260,000
ALTIE3 7
~~ 209064 195000
1 216,000
6t-047037021CONNECTIONS
_ _ __ ___ -
p
0000
~ . __
_. 78_208JI
50,000 I
_-
50
000
61-04703703 ~. MISC/TEMP CHG
5,000 '
500 _
2500 _
_
2,500
,.,
-04703704 STREETLIGHTS _ _
20,000 '~ _
5,400 _
- _ _
-
_
4703711 MERCH JOBBING/CONTRA
~
.~
_
f-
_._
_
' _ _
J4703715 NON-UTILITY OPERATIONS
'~ _ 1,000. _
(439) _ _
1,00
61_0470-4 _ R GENERATION-PKNG PL_N
T ' __
_
61-04703721 _,1lFG _ _ 1 000,000 1,009,682 1,021,841 1,038,251
61-0470-0722 '~. MISC NON-UTILITV_ 40,000 32,298 40000 10,000
61-0470-4723 (GAIN ON DISP OF PROP
61-0470-4726 'SALES OF MERCH _ _
- --
- y. _ _
-
- _. (1.982),_ _ _ _ _
-
_ _ ___-
61-04]0-4760 'TRANSFER IN FROM CITY
- - --
- -
- _ --
TOTAL OTHER 1,878.089 ~. 1,847,785 ' 1,74),644 ~ f,)48,240
TOTAL REVENUE 24,619,988 24,424,188 ', 25,397,1921 28,5]4,155
'1 Pnor PenoG atll-autln - - __--- --
zo11
ESTIMATED BUDGET
WITH HISTORY
AccouNT# DESCRIPTION
_ _ 2009
_- 2009 2010
_ 2,011
BUDGET ''~ ACTUAL BUDGET BUDGET
OPERATING/MTCE '
1540 5461 _OPERATING SUPERVISION - 4],000 1- 62.831 ' 60,900 - 64 543
il540-5462 INT COMBUST SALARIES
_.
61-0540 5471 DIESEL OIL FUEL
_ 25,000 _
- 8,221 -__
25,000 '
25,000
61-0540 5472 NATURAL GAS 30 000 ' 18,319. 30,000 I 30,000
LUKE OIL __
610540-5481 I
~ _ 3,250 3250 ~ - 3,250
61-0540-5482
ICHEMICALS
_
61-0540-5483~STATION PWRNVTR PLANT 60,000 ! 44,467
_ 45,000 I 47,511
61-0540-5484 PLANT SUPPLIES
~
40,000 -
. 9,526 -_.
15,000'
10,000
61-0540-5491
', MISC OTHER GEN EXP 5,000 ', 5,991 5,000 5,000
61-0540-5521 MTCE STRUCTURE PLANT
__. 25,000 30,617 ' 30,000 20,000
fii-0540-5531 (MTCE ENGINESIGEN
._- _
30,000
_ _
1
10,329',
-25,000 _
20,000
61-0540-5541 iMTCE PLANT/LAND IMP ''
10,000
__ _
_.
- 9,755 '
10,000
_
10,000
,PURCHASED POWER
__.__ 16,0)9,256 . ifi. ifi1,d00 p.026,2]1 ', 20,119,102
_ GENERATION CREDIT --
61-0540-5551 POWER PURCHASED
16079,258
1
ifi 161,444 ~I
1]026271 I
-- 20
119
102
61-0540 5552 LFG PURCHASED GAS ~ I -
I ,
,
I
61-0540-5561 PLANT STANDBV _
61-0550-5050 ,LFG PURCHASED GAS _ _ _154 000 1! 156,682 177,348 I, 157,648
61-0550-5051. 1LANDFILL GAS OBM 440,000 482,212 390,000 ' 485000
61-0550-5052 ILFG ADMIN
_ 1,000 , 12,0001 1,000 15,250
LFG INSURANCE
_
22,000
.. I -~
10,456 i
_.
~~ 10,916
11,000
61 0550-5054
_._ __LFG MTCE 17,000 10,000 ' 2,500
_ _ TOTAL _ 15,988,508 1]022,9491 fT,860.685 ' Tf,O25.BOd
-
DISTRIBUTION
61-0580-5801 IiREMOVE EXISTING SERV _,_ __ 2,]50 626 1,000 1 000
61-0580-5831 '.TRANSFORMER OHIURD _ _ 13,000 76,163 20,000 2
2,000
61-0580-5851 MTCE SIGNAL SVS_TEMS _ _ 1,500 '. ]83 ', _ 1,000 i __
_
10,000
61=0580-5861 METER EXPENSE _ _ 12,000 I 1169fi 1 _
12,000 13,000
RVICES
E 5 000 5,000
- -
61-0580 5881 M
SC D S
-_ --- 147 000 771,100 '
163,000 I
150,000
_ TOTAL_ 151,250 ~, 200, )fiJ 202.000 201,000
MAINTENANCE
-
fit-0590 5911 (MTCE STRUCTURES
_ _ 11,000 4,240 2,500 ~ 2,500
_ -._
61-0590 5921 (MTCE SUB-STATIONS
_-.. _- _.
25,000
-
35,753
_ _
,_
40,000 _
40,000
61 -059059221MTCE SUB-STATION EQUIP 5,000 }I _ 57841
..
- 5,0001
-_ 10,000
'f-05905931!MTCE OH/TREE TRIM
_.
__ 200,000
___ 89$55 '
I 150,0001 700,000
,
)590-5932 MTCE OF OH/STANDBV _ 35,000 -_
I 36,230 40,000 30,000
.-0590-59331MTCE OF OVERHEAD _' _ 120,000 _
]6,039 _
110,000 _
75,000
61-0590 5941 1 MTCE URD 185 000 96,225 '. 135000 ', 75,000
61-05905943 (LOCATE URD PRIMARY f
~
3,094` -
: .-_-_
21,000
61-0590-5951~MTCE LINE TRANSFORMERS'' _
- 43,000 1 255491 _
400001 _
15000
61-0590-5961 (MTCE ST LIGHTING _ _ 35,000 27,110! 45000 _
35000
61-0590-59fi2 MTCE SECURITY LTG _ ~
7,100
7,704
I
10,000 _
10 000
61-0590-5971 ' __
MTCE METERS
1
60,000
_ _ _
_
61,888
_
-- _
60,000 ~,
-_ _
63,000
61-0590-5972
VOLTAGE COMPLAINTS 9,000'
_ .. 6,805 7,500 8,000
61-0590-5981 _
SALARIES T&D '. 35,000 29,307 35,000 35,000
6t-0590-5985 ELECTRIC MAPPING __
. __
2,357 ' ___.
20,000
61-0590-5991 'MTCE OH/2NDRY '1 12,000 8,455
. _ _
10,000: 10,000
61-0590-59921MTCEU~RV I 70,000 _
_
53,636 _
50,000 I~ _
50,000
61-0590-5993 LOCATE URD SECONDARY
___ ~
- ___
3,049 _ 18,000
-
fi_i-0590-5995 TRANSPORTATION EXP 175000 -
120,460 155,0001 155000
J TOTAL 1,027 f00 593,2401 595.000' ]]2.500
OTHER EXPENSE T
_ _
61-05958031'DEPRECIATION 'i
2060,000
2,126,7941 _
2,125,0001, -
2,340000
61-059680]1 ~
__
INTIBONDS LONG TERM _._ ____
307,058 ---
299,452 _ 292,098 ii 272,764
I
-
61-0597 8161 COST/EXP MERCH JOBBING ~
I _ _ _ _.-
_-
61-0597-8172_SECURITY EXPENSE ___ _.
190,0001
777,736' _ _
220,000
220,000
61-0597 8213 LOSS ON DISP OF PROP 1,000 i _ 32,173 I 18 000
61-059] 8231 I COST OF MERCH S_O_ LD _ _ _
_ '
61-059] 8261 jELECTILABOR DONATED '. 400,000 _ _ 428 508 440,000 1, 445,000
61-05978262 'TRANSFER TO CITY _
I 611,000 _..
585,141'. _
624,4561 ]14,456
61 -05978263.OTHER DONATIONS_ _-_
_ _ _. 11000 'i (4253) _
2,500 _
2,500
61-0597-8281,AMORTIZATION/DEBT DISC 9,200 'I _ 11,169 11170 '~. 2,278
61-0597-8311 OTHERINT EXP - _
~ _ _
_
61-0597-fi341 11NT PD ON METER DEPOSITS( ___ 2,000 '
- - 7,263f
~ 1,8.00 8,000
61-0597-8399 iOPERATING TRANSFERS ' '~
_ _ TOTAL
1 J,59f,2581 J.66J.98J! 3J1>024 '. 4.022,998
_ _
CUSTOMER ACCOUNTS EXP
T
I
'
61-0900-9021 METER READING
60000
95,450 ~ _
__
70,000 _
- 40,250
61-0900-9030 'COLLECTING DISC/RECONN. __ 32,000 _
30,803
_ 310001 17,250
1-09009041 'NSF _ _
12,000 _ (555)
0 2,5001 1,000
09009051.
- ~MISC CUST EXP ]500 ~
60,345 ]4,6671 75,000
I-0900 9061 I W RITE OFFS I
~
65,000
~ _
18 90,000 100,000
roiAL _ _ zaa,ooo l 6&ss 288.16) 233500
I
2011
ESTIMATED BUDGET
wire ulsrnav
___- _.. _.
ACCOUNT # 1 DESCRIPTION ~.
_- - __
_- - __. - ___}__ I
_
2009 '
.
~.
2009
_
_I..
2010
__ _--
_.______
2,077
_
-
' BUDGET ~ r
ACTUAL BUDGET ~' BUDGET
_ _ ADMINISTRATIVE/GENERAL EXPENSE
I
X920-9201 (SALARIES/ADMIN
__ _
337,909 ! _
351,782 _ _ _
3
48,000
'
382,084
_
320-9205 TEM~AFFING _ -
5,000 ! _. _
.
_
_
],680
] 680
J920 9211 (OFFICE SUPPLIES/EXP
5] 500
]3 363
64 000 sa sa2
E
r - - ~
_- -
1
~
_
_--
_ 13,703
GES
3
B . 5172._
- _ 5250 4,370
6
~ 92G 922
1
EGAL FEES
_
_-_- -- _
12500
--
- 43939 26250-. 30,000
61-0920-9231 AUDITING
_
20000
~ _
16,741 _
22,050 -
- _
- -29,540
61-09209241 ,INSURANCE
- - 162660 129.164 131,600. 144,932
61=0920-92601UTIL SHARE DEF GOMP 40,050 _ 37401 42,]20 60,139
fit-0920-9261 iUTIL SH INSURANCES
-- 328,324
- 349,4571 368,087' 377,000
61-0920 9262 '.,UTIL SH PERA ~' _
116,663
-~ ~
129,746 ' 131,000-- -139,629
___
_ ___.
61-0920-9263 'UTIL SH FICA __
_
141,818 __- - -
140,985 ', 146 000 '~, 144,382
61-0920 9264_ SICK PAV - _. _ 70,000 54,144 I~ _ _ _ _ 74,66] ', 44 652
61-0920-9266 VACATIONlHOLIDAV PAY 170,000 176 412 ', 208,000 I 156,683
61-0920-9268 ,MISCELLANEOUS _ 10,000
_
- _ (120 _ 7,500 ~, 1 000
61-0920-9269 CONSERVATION/IMPIPROG _
- _
116,580
- 104,653 "~ 144,320 I 310,000
61-0920-9281 ENVIRONMENTAL COMP 20,444
~ 14,005 25,000 '~. 24,119
61-0920-9291 CONSULTING 39000 ~, 5,182 10,000 10,000
61-0920-9292 LFG GAS PROJECT
--- _-
--
939
_
_ - _
61-0920-9301 TELEPHONE
-
.__ _-_._. _. 19,000 '
_-- _
14,180 ~
17,067
. ---
13,918
~
61-09209302
I
_.I _- ~_.
__ _
1, 12
. .:. _-...
12,110 __
_ 4.442
__
6L0920-9303 ''~DUESISUBSC/FEES 40,0001 M1,3861 139,582 ', 209,936
6i-0920-9304 'TRAVEL 5,000. 341 '~ 3,000 ~, - 2,120
61-0920-9305 SCHOOLS/MEETINGS I
_- 86,118 101,944 I 86,488 ' 105,000
61-0920-9306 MISC GENERAL 2,000 6,977) 2,000 5,000
61-0920-9321 MTCE GEN PLANT/OFF HEAT I 20,000 3,354 20,000 5,000
_ TOTAL I f,86C,5<B 1,90G,BBI 2.882.2961 2.2J6.OJf
TOTAL EXPENSE
_. __ - _.__ '
- 23,896,862 23,854,893 ~ 25,009,772
_ I.
-
. _ 28,531,873
..
__
~ I .
__
- _- _._ - T.
ELECTRIC . __ _-_
2009 _ -_
2009 .
2010 _..
2,011
BUDGET ACTUAL '. BUDGET '~ BUDGET
TOTAL REVENUES __ _ _ _ _' 24,619,988 24,424,788 25,397,192 '_ 28,574,155
TOT/LL EXPENSES
- _ -- --~ - 23,898,662 23,854,6931 __25,009,172
~ 28,537,873
PROFR (LOSS) 723,326 569,495 ~. 388,020 42,281
2871
ESTIMATED BUDGET
WITH HISTORY
AOGOUNTp DESCRIPTION 2009 2009 _
~ 2070 2,011
BUDGET ACTUAL BUDGET BUDGET
62-0460 4691 .INTEREST INCOME 25 000 14
1
043 25,000 - 32,500
°'-0460 4692. OTHER INT/MISC _ .
. 2,000 2 000
1610 6101 ,WATER SALES 2,000,000 '. 2,182,110 2,000,000 1,926,000
J610-6171 I UNMETERED SALES 1,000
62-0620-6300 SERV DONATED BV CITY
62-Ofi20 6301 CUSTOMER PENALTIES 20 000 ''. 24,319 ', 20,000 '. -
20,000
62-0620-6401 WAC FEES _
- 200,000 ~ 56,480 " 25,500 ~. _
27,500
62-0620-6402 I MISC CONNECTION FEES
' 55,000 26,898 ' 4,500 'I 5,300
62-0620-64031, MISC REVENUES __ 2,500 3,801 2,500 2,5
00
62-0620-64051CONTRIBUTIONS DEVELOPEF
_ -.. - _ _
'' _
~ _
1 .
62-0620-6406 !,WATER TOWER LEASE' .
_ _ _
_ _ __ -
78,000
_ TOTAL REVENUES___ 2,302,5001, 2,434,657 I 2,079,500 2,094,800
~
_._ _ _
__. ___
_ 1, Prior Period Atllustment ~
- _ _ _
j
- __-._ ._
I~ I_.
_I _ __ _"._
_.
A__C_COUNT# _ DE5Cl2lPTTON - - 2D0~1~ - 20U~~, 2Dj~ ', 2,On~1
' BUDGET ACTUAL BUDGET BUDGET
fit-0597 8260 !_ OPERATING TRANSFER ~
-
~ 20,000 '. 20,000 ~ 20,000
25,000
_ _ __ _. (99 BON0)_ _._
_. ___. 20,000 20,000 20.000 25,000
MAINTENANCE
_
62-0700-7021 MTCE OF STRUCTURES _ ~ _ _
- 9,000
15,331
9,000
11,000
_
62_0700-7022 (TOWER 8 GROUNDS INSPECT _
8,500 2,312 5,000 ~ _
7,000
TOTAL 32500 ~, J76d3' ]0,000 a3,00o
_._
PUMPING
_
62-0710-7101 '.SUPERVISION
28,000
14,631 _ _
21,500
21,500
-
62-0710-7181 .SUPPLIES/EXPENSE
_ _ -_ -
775,000 ~
__
221,657
187,000,
215,000
62-0710-7182 'SAMPLING _
_
7,000 i
5794
- 70001 _
_-
7,500
62-0710-7183 (CHEMICAL FEED
_ _ -._ ..
45,000 ~
-_ 37,658 ! _
68,000 Ii _
50,000
62-0710 7201 MTCE PUMPING EQUIP 10,000 I _
8,075 1~ _
OS 00 _ __
12,000
62-0710 7220 ,MTCE OF WELLS 135,000 68,879 _
105,000 32,000
62-0710-]225 GENERATION __
_... - 1,500. 80. 1,500 1,500
_.. TTOTAL _._. __
__ _
601,500'
358,7261 3)S.OPo 1 339.500
' DISTRIBUTION
'
. -0730-7301
"MTCE WATER MAINS
=_-..T_ '
-._
_
33,000 _
25,443 ~ _
50,000 _
30,000
62-0730-7302 'WATER VALVE REPAIR _
4,100.
1,856
8,000 _
3,500
62-0730-7309 LOCATE WATER SERVICES ~
729 j 8500 8,500
62-0730-7310 LOCATE WATER MAIN _ ___ _ _
72
_ 3,500 '~ 3,500
_
62-0730-7311 MTCE WATER SERVICES '
50,000 !
_
28,574 '1
38 000
. __
44,000
62-0730-7312 (WATER METER SERVICE -_
7,000 9,325 ' _
7,000 15,000
62-07304315 ~INSTALLB MTC IRRIG MTRSJ _ _ 5,186 5,000' 5,000
62-0730-7321 MTCE CUSTOMER SERVICE I
45,000
48,045 _
17,500 .
20,500
62-0730-7322 ~ WATER SERVICE INSPECTIOI 500 _
137 500 500
62-0730-73251WATER MAPPING ' ' 1,919 '~ _
9,500 _ _ _
6,000
62-07304331 1MTCE WATER HYDRANTS __ 20,000 3,725 15,000 ~ 15,000
62 0730 7341 _, MTCE WATER EXPENSE _ 5,000 13 043 11 000_1 11,000
62 0730 7391 WAGES __', 10,500 6 600 1 10 500 I 10,500
62-0730 7395 TRANSPORTATION
_.
- i 40,000 _
10,318 13 000 ! 13,000
_
62-0730-7399 (GENERAL EXPIP_ERMIT_S
-- 14,0002 __
14,475 ! _ _
16,000 ~ _
14,000
TOTAL 229,100 1B9.da6 213,0001 200,000
OTHER EXPENSE I '
_
0'2-0745 745110EPRECIATION 950,000 1 956,993 990,000 ~1, 1,019,700
62-0748-7481 'INT ON BONDSILONG TERM 280,911,__ 274,958 266639 131,139
62-0750-7563 'AMORTIZATION 93
'
62-0750-7564
AMORTIZATION 94
62-075045fi5 (AMORTIZATION 97 _ - ~
62-0750-7566 iAMORT, IZATIOry g8
~ _
-- 1 _
62-07504567, AMORTIZATION 2001 _ ~ 3,556 ''..
62-0750 7568 AMORTIZATION 2003 _
2 667. _
2,6fi]
2,667 1
2,66]
62-0750 75fi9 'AMORTIZATION 2008 Ref 1 4 719 1 _
8,096 1, 6,719 ~ 4,719
TOTAL 1,238.29) 1,268.270' 1,263,825 '. f, 158.225
_ .CUSTOMER ACCTS EXP 1
62-07407431 METER READING
20,000
29818
300001 10,800
_
62-0900 9030 COLLECTION EXP _
J
~
7 000 _
_
3 220 '
4 500 ~
I`
6 000
62-0900 90511 MISC
EXP 25,000 24 115 '
20 333 20,333
62-0900 9061 I WRITE-0FFS _ _ 4 150 4 252 I _
5 000 1 5,000
TOTAL '~
' 58,150 61,x05 59,833' d2 tJ3
. 1
_. _
_ _ _ ___ _ _- _--T 1
..- _.
~_ T-.. I T 1 _ __
xo11
ESTIMATED BUDGET
wiTU uicmnv
ACCOUNTA DESCRIPTION 2009 2009 ~~ 2010 ~' _
- 2,011
BUDGET ACTUAL BUDGET
~. BUDGET
_'~ ADMIN/GEN EXPENSE
~ '~
'920-9201 (SALARIES/ADMINS _
110,000 119,154
~ 92000 ~ 94,]60
320-9205 'TEMPORARY STAFFING _ 1,000
- 50 1,920 1920
oc09209211 -0FFICE SUPPLIES/EXP 17,000, 26,669' 1],000 23,000
62-0920=9212 LT/WATER CONSUMP OFFICE( 4,000 1 5,553 ', 3,700 3,700
62-0920-9213 BANK CHARGES 15001 1,724 _
1000 1,000
62-0920-9222 I LEGAL FEES _ 2,000 r
- __
10,596 '~, _ _
5,000 15,000
62-0920-9231 (AUDIT _.-_ _,._ _
5,000 1 5,580 4,200 ~ 4,200
62-0920-9241 INSURANCE 45000 ~ 29,824 35000' 35000
62-0.920-9251 WATER UTIL CONT _
62-09209260 UTILITY SHARE DEF COMP
- 15500
- 13,199 11,330 71,330
62-0920 9261 UTIL SH INSURANCE 104,261 101,080 - - 82,189 96,189
62-U92U 9262 UTIL SH PER_A ib 055 '. 15 495 _
18,000 _
- 20,000
62-0920 9263 UTIL SH FICA 25,300 _
18 b45 _
22,000 22,000
62-0920 9264 'SICK PAV _ 22,000 ' 18,049 17,333 19 333
fit-092096]'\'AC/HOLIDAY PAV 60000 _
58,8]1 52,000 59,000
62-0920-9268 WELLHEAD PROTECTION PROGRAM 8,500
62-0920 9269 ',CONSERVATION IMP PROGRII
-- _ 15,000 i 1,670 8,000 10
000
_
CONSULTING ~,
Ir
6,000 '.
9,061 I __:..
20 000 ' ,
-_ _
20,000
62-0920 9301 (TELEPHONE 6,600 4,671 3,483 3,483
62-0920-9302 ADVERTISING_ _ 5,000 '~, 2901 890 890
62-0920-9303DUES/SUBSCRIPTIONS I _
_ 35,000 i_ _
_
36,572 - _
_
37,0001 37,000
62-0920 9304 VEL
r _ 2 500 I _ - ' 2,000 1. _ 2,000
fit-09209305 SCHO
OL$/MEETINGS 26000 19191 20
fi21 15
000
fit-09209307-IMISC GENERAL _
2000 `_
93~ ,
_
500 _
,
- 500
62-0920-9321 MTCE GEN PLANT/OFF HTG__
7,000 '. _
1,118 {_
1.6501 1,650
-_- TOTAL _ -__
_ 5J5.I16.OH' dW.i6H.2H d56.812 CO 505.e55
,'TOTAL E%PENSE __ 2 A98,263 1 2,368,707 2,402,480 2,288 313
WATER -_. _.._ ~. __ ~
~ -. ~ -__
TOTAL REVENUES _ _ _
2302,500 _ i~ 2,079,500 ~ 2,094,800
TOTAL EXPENSES
__. _ _ 2 498,263 ' 2,360,707 __
_
2,40 42 BO 2,268,313
PROFIT LOSS 195763 fi5944 322980 193513
00~no0000
O L^-N O,t~')NI
MIS.-.Oi~n
'_N
I
C p0~00
O) '~
b, IW 0000
OO
I I Ib N~ 0000
O Y1
~ ~O
` 10
0
r
u1 00
NOS
r~V
N t° 0.00
NIOO
NiVb
A 00II,,~
i OI~
i '
~ ~
Sl I I '.
I i ~
;
I ~ li I M I I I I
00~=
O C
N ~
I ' ~
,
-_J
W~OIOOOIOOO~O
~ ~ I
7 I
J o~h~~'~ °o
Q .O E N O tO N
~ 100 O
I
~
~ ~° ~°n
I W I W O O~O~
II
~o+O °0 °o~
O N
~ O OAO
~°I~°n
I+IIII N ~
I
°
C] ~ OOO
I
° olg
I~ t9 0 ~O
°n~°o °
(° i O~ b I,~~
°fo ~ ~ I'. ~ '~-
~ I ~.i
wl'I I I II I I I I
of Imo; ~~~ ~' ~~ ~ L _,-
~ I I I ~I
i
0 !M A NI Of
m ~ Ibi ~ i
N .
I I
~ - O i~•-
'. b
1 ~ ~Q
N N ~b ~ h
'
NI t
I
~
m I
', i I '. i
N I I '. I I
1~ J
_ O:ONO~000 OO
~ {L J
OIO~O .L.
O~OOO O~0 1
0 00O ~O IO IIO
01 1 J JI_ ~ I__~i~ I III _~_
~~
Z ~ I i I ~~
I 0
~O .,
I ~ ~ S 0
~ ~ I. I ~ h I
I
N ~
W :
y ~~ ~ ~. I
i I
U
O, O N O i O ~i O O O
~~ ~,
,
I O~ O O
!
O O O O
~
O O O
I
I
O O ~ O
~ I I
O O O
O !
i
I~ i ~' I C I
w:.
T I -' I J ~. __ I ~~ ~ I
l
a N~ ~
I
W ~
OO 000`000
~
I
000
I p
0.0010
~~~ I p
Oj
0000
~ I
0
J
0 0
~I i
1000
~ 00
001
~ O
I
~ I j~ ~ I t i
~
9 ~
~~~ ~~. _ I I
f
~~.
~ ~°-~ $
~!
Q CD Im
W ' ~I
0010~0~0 ~S O
fON CI
-,
~ t9 OI S°
~
p~~p~
10~ O
(O
lO S I
IW
~O OI°~O.
OD
N
N ~ I
OO ~S ~°
N ;o
O
b
O S 3!
r
N f0
OOO
N o o
b~M
;O O ~O
O
O !
~ I
I
OOO ~
o I I
V
N ', ~ I ~ III i I III
Ji ~. .JIFF I-.~i ~ 7 ~__L -- Iii
~
I
O I
Q
, ~ I
i
' I ~N
~ Ni I
N
M N N
~ I
I
I
a
M-r
<
a ~
oooooooo
of ~~mlo
o~oo
o!, o
I ~ ~
ooo'O O
o~ o o
,o~oO
. o ~n
$
oolo
u~o
~o•.o o
iu~., is
I I '
lo I
II I~. ' I li
M ' i~
- __{ ~ ~_~
~ I
~ I
W
O~
d'
V C f7
S S ~p~
m O i~ S III N~ M~ O 00 0
~
h:
00 O ~ 1°
r
O' ~ h
N O~ i~ ill ~
l
O S b
~
O
~
o° ~~
~
~
m O f00
~ ~
!7 N
I~
O i 0 N
Ii
I ~
I
~~ ~ ~ I I
i p I I I I
O
~ ~ _ ~ i -
!f
-
c
i.
_
-~
~ ' o .
~ I
~ IC I h
I
~`" _
~ i JI~ ~... ~ r _. ~I ~ t.~
i
~
Z
C
O
Q.
' ^
'.' 0
O
Oi N
AoN.......mv ~
N ^
~O~o~CY~~
p.-. aD l~h Ol 00
^O
~N O i
YfDf
`-'~~~
^
ap~V
A
~PN ~ ~ N
~N ~
N
r"`-' b~p
p~)i°r'ON
N
~
O
~
_
~00
Ov~ I
V
~
UI
O°iro
00^
'
N
~c :,.
^
g
~
~N N
W M
I
i
ON
+ t ~.
I, I
I E I I I I II
_
im I~ I ~ I
m i I
m
v
mtO
~ _ 0 _ ~
~ .
. O
~M ~
1 I 1
3 ~
W Q
O
~
~~ ~ lON^. eD^
W `-'~M.. m
0..~.. aDY~N~O
~ ~~~I W ~
l <J
0~-I
~~t+I
~'IN _
O
~~ O
O r
~ $ ~ ~ a0
i
r ~
; ~
~ ~
~.
~'
~ ^_^IN
N~~
M.
~ ~
_
~
N
I,
I 1
I
~' I I I
i III ~ ~~ ~ I I I' ~ I ~ ~ I
m _J I
~
~
~ ~
~ ~ o~'~~m ~'r ~noo
~~-~ - °o~o .n .°°ol~S°o
~ M,ah ~~tO N
l- °
- N
~~ ~~~`O'~
~ o°o
c
~ I a
~ I
~ ~ ~ '
~-ol~._~ ~ ..~' ~,' ~ ~ ~ _i ~__
+
r
~
~ ~I
I
~° m ~ ~
I° '~ I
~ ! m
T
j~ i
C
~ i iZi - ~ ~
' ~ I I
~ I ~~ I I~ ~~
I
~
Ir
~
`° I ° L
L C O ~ ~
~ p
O K
~ .m+ ~~
3 I I i I
I
I
a c I
myl ml~~
x.. ~9 m $
z~8
m a3 =9a'
a ~
c c
2~~
o
. c
@~m
tl- E2
~ m I I
I I !II li
I VI
1 1
Z
' F $=m~U~q~~mt
°
7
a a' a' g m ~`C
x p
~ Qeg
~ m 0~ A mie
C m O ~
e
J U
Sac
~ x U ~y m
U co
3 U ~ i '~ I
i~
K _
9
~ w m m a a ys 3
mmulxxx L
I-°avUmw~H E ..
::t~~
mmm m
o~ U rc
"r-mm-~
UU
?LL m E E
o9iE E
3 E
E E E E
EEE m
~
E a LL
E~U
~ ~"~
a• ~
O I
~ ! I I
~
' '
'
.W wOvIaaC7UO rc'o S o
ala ~a-U m
0
K UU o
UU bo3
UU 3
f
UZw a:
U a~ I ~ I II I ~,.~ j
' I
I i
Ij'0 0 0 OV 0'0 1 0 0 0 O,.O O O, O~~O 0 0 0 0 0 0 10 O I00 O 00 O In
m. N OIt~ ¢]'N m N b O O i0 b (O 0
O
OIr I O ~
to
' L
r Oi 1~ N ~O Im D r (O O IN
N
N',.M m M T '.~ m1~ '~ O] 'O
rn
L
'
~ IQ N
N
,,
O 00000 001000100 OOO OOIOA OOA
MN
~ A ONTO hMrM0
O
0
0
OO rN O - - ~ ~--- -
N ~
~ ,
I
m1
i
0
f0 r Nlp)~.~- r Ib I 41~N I
V YI RIN
10b
~
I~D O
m
L C
II
r
Ncp N ~, YI
O W
I ~
0 0 0 0 O~O 0 0 0 01
I ~
0000110010000000~
00000
r ~
_
~ ~
~ - L
pp r
'I
'
0
m
WI
~ , ,
~ ,~
i
rp
°~y
R' I ! I I I ~, I I I o1 el~~^1~ ro.
0
I_ O NII N~O N0 0 N l0~ IO ~I W
Ila- oOO ~ rn Nn °o °o °..°n°lo °o it oplo° 0100 0 0 0 o1~°n°o °o ° °o~N n,1 I'~I mlu lglq - ', '
10 ~°n nl°'rn l`„^ Iln '°' 1pN O~~~vl'invu~l mN ~, V ~mlc •ao
N '' ~b N Im I DJ ~W O •~~-„ N
~ ~ 1 I SIN IN O ~ ~ X VL '.
N I '1 ' IyIy ~ di '.D.. N IylN ' Nwp
O O N0 Oi00 O 001,0 OOO ~O OO OO,O 000'00000- j11 - I TY Lm
F ~ a '. I ~ I II nI 1 °o 1 °o i°n IN : $ mi~ c ~~IC '' --
W.. '~21 w 1 ~ ~ I o ~ v~ .m ¢~ N m Eml~ ~
~~~ ~ 11 I II I Il I ~~ ~ I Ilcj o a~lan~w I. 1 1
X11 oo`oo!o oroooo~-oToooooooo ~o o'o~ooo~o o~~ __'- I E' I~ ImL _ _
'.~ a o I I Oo I i IV,. Cm~EN ml~1 71
m ~ $ u°Di I~ ~ ~ ICI ~ $' it I ~ I I O r°N° ~ I I ; ~ ~ ° ~ I o l "' L I W I I ~~
.-. -J 4 ~-I_. L__ T -_. I N a m. mlE ~~~al~ I II
I a W ~, 11 ~ i ' ui ~ '. ~' q l.~ E I u o t It7 ~,
~W O OIOTOIO!O OO 010 O O O10!O O O O OO O O OHO O O O OI I ~~ L OI N 1010
V, 'F 1 00 ~o o' oo I I I o00 o~ o~ 0 1 ~ IE~3u~c~~y 111- --
o o ~n o1 ~n of o 0 0 0 0 o I ~ I
im 1 m Rio co uo I~Im II li°n c~ °m ~ M In n' 'm v°o °-~ m ~1 ~ I
W I ~_ I. o I I ~1. ~ m'° m m'~I OI I I
~ '~loio00;0'010 00~0~0 0 0 010 010 0'0 o•oliO~o 0l~o oio ~l ~~~ai ~~~m N'o911-I - ~~i --
010 010 0 0 OII o o IO1o,., o to 0 0 0 0.~o I~ clZ ~ r "L' o I
~i ;~ 1N N fO,M M 11 O1 tO M~ N i0 N IN N N N' t01. N, O ~ ',.C O a O. I '.
'O N w
~I Q I I II ~I 1'I I I V I I I 'I '',in 111 ~I P. v~Ixli@vI; i
WII
AIL
WI
all
~-
ZI,
O'
a
wI
Z I 11
U
r
N~ -
~O IIN O ~O,N <
~ f0 ~D .-.
1--...- __- -1111'
1 !
1 ~, I1
111111!;
!MIND M
II 'I~~o°'~ !.
I ~ I
~ I II;'i
1
'm ~I
M MIIpM'' I I' II
I
!@
i I ', ''~,. I, O
!a`
1 I ;.
I=
m 1111
m
I$
Ic
c
g
m
0
ol.. __ ~.
~. °' I 1
L `i I
~I p~~~. ~ ~ ~~
n T~ '
Ig:W 1
u U, li
cl~l 1, 1 I.
col 1
~'= Il 1
!s°I' 1 1 1