5.3. ERMUSR 10-11-2011Elk River-
Municipal Utilities
13069 Orono Parkway • p.0. Box 430
Elk River, MN 55330-0430
PONEAEO BI
~~~V~~
p~•.r=oFn To Soave
Pho~e:763.4412020
Fax: 763.441.8099
UTILITIES COMMISSION MEETING
TO:
Elk River Municipal Utilities Commission
John Dietz -Chair
Daryl Thompson -Vice Chair
Al Nadeau -Trustee
MEETING DATE:
October 11 20] 1
SUBJECT:
2012 Expense and Conservation
FROM:
Troy Adams, P.E. -Utilities Director
AGENDA ITEM NUMBER:
5.3
BACKGROUND:
In preparation for submittal in November, staff continues to work through the 2012 budget
process.
DISCUSSION:
Electric Denartment Expense Budeet
Year to date, wholesale power costs makes up approximately 74% of operating revenue.
Ultimately, the wholesale rates set by Great River Energy have an enormous impact on
ERMU's rates. GRE is still in the process of finalizing their 2012 wholesale power rates.
Through discussions, the preliminary numbers indicate a wholesale power cost increase to
ERMU of 14%. This is a very preliminary number as GRE is looking to reduce this number.
The final GRE board approval of wholesale power rates may be delayed this year due to the
budget cutting process. This may delay finalization of 2012 ERMU rates and budget. It is
projected that the GRE rates will be approved in early December. Because of this, it is not
expected that ERMU will be able to make final budget approval until the December
Commission meeting.
Water Denartment Expense Budeet
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
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 2012 Electric Expense Budget
Proposed 2012 Water Expense Budget
Proposed 2012 Conservation Improvement Program Budget
2017
ESTIMATED BUDGET
ACCOUNT • DESCRIPTION 2008 2009 2010 2010 2011 2012
BUDGET ACTUAL BUDGET ACTUAL BUDGET BUDGET
61-04404411 E.R.RESIOENTWL 7.212,395.00 7.242,923 7,54>,266.4B ),948,224.00 ST 731,634
61-04403416 OTSEGO RESIDENTIAL 686,045.00 894,831 929,730.03 1,009,384.00 947,898
67-04404421 B.L.RESIDENTIAL 252,858.00 256,289 285,752.20 275908.00 289,046
fit-01404431 DAYTON RESIDENTIAL 770405.00 173877 779030.85 197845.00 187889
roraL RESwENruu e1es.1N a,4mesD e.-zo,Ter D.ar,13- Drxxi
fii-04404415 E.R.CITY DONATED 160000 171,109 160.000 177.487.00 178,220
61-04404H2 E.R.NON-DEMAND 1,846,121.00 1,742,818 1.881,106.19 2.005A03.00 1,901,313
61-0440-/417 GTEEGG NON DEMAND 292388.00 274,945 266,728.30 934,288.00 309067
61-04404422 B.L..NON-DEMAND 7,426.00 7982 6,773.40 8397.00 7582
61-04404432 DAYTON NON-DEMAND 25757.00 25,323 23198.82 27034.00 24561
TOTAL NON-OEMrWD 1,360/73 1111,11e f1i 105 1!52.681 2110,713
81-04404473 E.R.DEMAND 10,921,311.00 10,778.498 11,567,824.68 17,972,773.OD 73700381
81-04404418 OTSEGO DEMAND 686,620.00 778,967 736.837.05 798.989.00 885,018
81-04404423 B.L.DEMAND
81-04404433 DAYTON DEMAND
TOTAL DEMAND fI.e31.6n fI,ID3116 11,1H e61 13 n1.)92 f15e6,3--
87-04404414 E.R.SECURITY LTS 33,270.00 37259 32,000.00 31,328.00 32.000
81-04404479 OTSEGO SECURITY LTS 10,108.00 9688 10,000.00 10.131.00 10500
61-04403424 B.L.SECURITV LTS 1.984.00 1,857 2,000.00 1,880.00 2,000
6t-04404434 DAYTON SECURITY LTS 5282.00 5,077 5000.00 5086.00 5 0
TOTAL SEWRDYLTS Ie 000 12100 ID.000 Ie,106 60,000
67-04404461 PUBLIC ST/HWV LIGHTING 242000 245242 250000 253067.00 255000
RITALWBLIC STMWYIIGHTING N2,000 Nl,N3 380000 353061 355.000
TDTg6 yllE! 33 N1,1DO 33,+76,10] 33,e1D.51e 35,OSl.DIO 3e.H),IM
PROJEOTED SALES 1),0!0,10311
FATE INCREASEWRHWNOLESAIEPoWFA LOST fIOS% 3,]91,/eL33
10TAL SALES WFNCIPSUTEWCREr15E 121H,09 33,l16A03 N,Ne.N1 }S 05(,9(0 N.NbM !-lHAH
61-04403511
61-04404550 SERVICE CHARGE
SUBSTATION CREDIT
11.800
12,068
14014
14014.60 -
14,000
514,500.00
400
000
00
fit-04404551 GENERATION CREDIT 350.000 349,950 350,000 351,714.00 350,000 ,
.
$
61-04403552 DISPERSED GENERATION 224,577 789.601 228,777 192,195.00 224517 $ 294.272.00
61-04403553 PCA ar RATE ADJ
61-04403553 FUEL COST ADJUSTMENT
61-04404555 A/C CREDIT 44,000 E 10,000.00
61-04604691 INTEREST INCOME 45,000 87,880 80,000 88,915.97 75.000 $75,000.00
61-04704700 SECURITY REVENUE 210,000 254,773 240,000 258,846.82 280,000 5280,000.00
61-04704701 COST DEL PENALTIES 170,000 209,064 195,000 237,319.00 276,000 $235,000.00
7
0
00
61-04703702 CONNECTIONS 250,000 78,208 50,000 64761.00 50,000 .
$46.
5
61-04703703 MISClTEMP CHG 5,000 500 2500 50.00 2,500 $2,500.00
fit-04704704 STREETLIGHTS 20,000 5,400
61-04703771 MERCH JOBBING/CONTRA
439
1
000
010
00
50 -
60
000
000.00
$80
61-04704715 NON-UTILITY OPERATIONS 1,000 , .
, , ,
$7000
00
61-04704720 GRE GENERATION-PKNG PLNT 2,581.00 - .
61-04703727 LFG 1,000,000 1,009,682 1,021,841 7,003,341.00 1,038,251 $1,027,589.00
000
00
30
61-04704722 MISC NON-UTILITY 40,000 32.298 40,000 4,234.00 10,000 .
,
$
61-04704723 GAIN ON DISP OF PROP 670.00
61-04703724 SALES OF MERCH - 1,982 14.00
81-04703780 TRANSFER IN FROM CITY 53.741.00 -
e
wo
ele w>
1
TOTAL07HEF I,e7e oeD I,N>m6 n~2au I,D1-z7- g
I,e .
TOTAL REVENUE 24819988 24424188 25397182 28886 79 28 64718 7t 838378
D00. D.noa aal-wan
[Yll
ESTIMATED BUDGET
WRH HISTORY
ACCOUNT 7C DESCRIPTION 2009 2009 2010 2010 2011 2012
BUDGET ACTUAL BUDGET ACTUAL BUDGET BUDGET
OPERATING/MTCE
61.0540-5461 OPERATING SUPERVISION 47,000 62.831 60,900 66,386.00 64543 $72.000.00
61-0540-5462 INT COMBUST SALARIES
61-0540-5471 DIESEL OIL FUEL 25,000 8,221 25,000 10,400.75 25,000 $20,000.00
61-0540-5472 NATURAL GAS 30,000 18,379 30,000 17,171.89 30,000 $25,000.00
61-0540-5481 LURE OIL 3,250 3,250 3,250
67-0560-5482 CHEMICALS
61-0540-5183 STATION PWRANTR PLANT 60,000 44,167 45.000 45,474.12 47,511 $46,500.00
81-05405484 PLANT SUPPLIES /0,000 9,526 15,000 5,956.82 70,000 $7,000.00
61-0540-5491 MISC OTHER GEN EXP 5,000 5,991 5,000 7,028.16 5,000 $7.000.00
87-0540-5521 MTCE STRUCTURE PLANT 25,000 30,617 30,000 17124.82 20,000 $18,000.00
61-0540-5531 MTCE ENGINES/GEN 30,000 10,329 25000 12,931.32 20,000 $18,000.00
61-0540-5541 MTCE PLANTILAND IMP 10,000 9,755 10,000 18,198.18 10,000 $10.000.00
PURGNASEO POWER Ie,O]9,26e 16, 161,+N 1],016,3]1 fe,3>9366 19.]11,939
GENERA]IONCREOR
61-05405551 POW ER PURCHASED 16,079,256 iQ161,496 17,028,271 18.373,385.85 19.771,039 $22,859,699.82
81-05405552 LFG PURCHASED GAS
87-0560-5561 PLANT STANDBY
61-05505050 LFG PURCHASED GAS 754.000 156,882 177,348 759,229.48 i57,fi48 $156,587.00
81-0550-5057 LANDFILL GAS 08M 440,000 482,212 390,000 539,133.75 515848 5534,588.00
61-0550-5052 LFG ADMIN 1,000 12,000 1,000 72,143.75 15,250 $15,000.00
81-0550-5053 LFG INSURANCE 22,000 70,456 10,918 11,051.28 11,000 $11,000.00
61-0550-5054 LFG MTCE 17,000 10,000 2,412.50 2500 $10,000.00
Toro 1o,9ee.60e +>.o2z,ue nea.ees 19.z93.ox3 2o.TOe,uo v,e14a]s
DISTRIBUTION
81-0580-5801 REMOVE EXISTING SERV 2,750 626 1,000 624.98 1,000 $1,000.00
61-0580-5831 TRANSFORMER OH/URD 13,000 16.ifi3 20,000 24,255.70 22.000 $15,000.00
81-0580-5851 MTCE SIGNAL SYSTEMS 1,500 783 1,000 6/9.27 10,OOD $3,000.00
61-0580-5861 METER EXPENSE 12.000 11,896 72.000 12,378.87 73000 $14.000.00
61-0580-5871 TEMP SERVICES 5,000 397 5,000 340.53 5,D00 $1,000.00
81-0580-5881 MISC DIST 147.000 171,100 163,000 744.181.67 150.000 5150000.00
TOTAL 181,168 209.>63 202,000 102.01 391,040 101,000
MAINTENANCE
67-0590-5911 MTCE STRUCTURES 11,000 4,2/0 2,500 4,465.01 2,500 525,000.00
61-0590-5921 MTCE SUB-STATIONS 25,000 35,753 40.000 22.233.52 25,000 $25000.00
61-0590-5922 MTCE SUB-STATION EOUIP 5,000 5,786 5,000 7,739.58 10,000 $10,000.00
fii-0590-5937 MTCE OHlTREE TRIM 200,000 89,555 150,000 46,209.21 90,000 $90,000.00
61-0590-5932 MTCE OF OH/STANDBY 35,000 38,230 40,000 29,278.42 30,000 $30,000.00
61-0590-5933 MTCE OF OVERHEAD 120,000 76,039 110,000 83,949.76 60.000 $55,000.00
61-0590-5941 MTCE URD 185,000 98,225 135,000 56,461.27 00,000 $75,000.00
61-0590-5943 LOCATE URD PRIMARY 3,094 23,150.62 21,000 525,000.00
fii-0590-6951 MTCE LINE TRANSFORMERS 43,000 25.549 40,000 4,535.88 15,000 51D,000.00
61-0590-5961 MTCE ST LIGHTING 35,000 27,7 t0 15,000 18,631.07 35,000 535,000.00
fii-059D5982 MTCE SECURITY LTG 7,100 7,704 10,000 7,436.34 10,000 $5,000.00
61-05905971 MTCE METERS 60.000 67,888 60.OD0 65,250.66 fi3,000 $fi3,000.00
61-0590-5972 VOLTAGE COMPLAINTS 9.000 6,805 7,500 7,174.04 8,000 $8,000.00
67-0590-5981 SALARIES T8D 35,000 29,307 35,000 29,666.84 35,000 $35.000.00
61-0590-5985 ELECTRIC MAPPING 2,357 21.184.68 20,000 520.000.00
61-0590-5991 MTCE OH/2NDRY 12,000 B,/55 10,000 14.541.49 10,000 $15,000.00
61-0590-5992 MTCE URD ELECT SERV 70,000 53,836 50,000 27,831.31 25,000 $25,000.00
61-0590-5993 LOCATE URD SECONDARY 3,049 19,362.61 18,000 $18,000.00
61-0590-5995 TRANSPORTATION EXP 175,000 120,480 155,000 121,466.50 130000 $150.000.00
Toro. +,v2vao emR+o e9s,ooo fiae,vn en.5vv ]19000
OTHER EXPENSE
61-0585-8031 DEPRECIATION 2.Ofi0,000 2,128,794 2.125,000 2,062,942.41 2330,000 $2,300000.00
fit-0596-8071 INT/BONDS LONG TERM 307,058 299,452 292,098 272,897.12 272,764 $551,250.00
61-0597-8161 COST/EXP MERCH JOBBING
61-0597.8172 SECURITY EXPENSE 190,000 177736 220,000 189,373.90 220,000 $222.000.00
61-05975213 LOSS ON DISP OF PROP 1,000 32,173 12.179.00 i8,OD0 520.000.00
6t-05975231 COST OF MERCH SOLD 77.80174
61-0597-8267 ELECTAABOR DONATED 400,000 428,508 440,000 434,415.20 /45,000 $447,500.00
5
61-0597-8282 TRANSFER TO CITY 611,000 585,141 624,458 657,086.33 713,456 .00
$730,02
61-05975263 OTHER DONATIONS 11,000 4,253 2,500 21,589.13 2600 $2,500.00
61-0597-8281 AMORTIZATION/DEBT DISC 9,200 11,ifi9 11,170 8,818.93 2,276 $9,777.00
61-0597-8371 OTHER INT EXP
6 7-0 597534 7 INT PD ON METER DEPOSITS 2.000 7,263 1,800 586.03 8.000 $8,000.00
61-05975399 OPERATING TRANSFERS
TOTAL ],591,26e J,0099B3 3,]1],02+ 3,628,510 1,011,990 1.291,052
CUSTOMERACCOUNTS EXP
61-0900-9021 METER READING 60,000 95,450 70,000 59,288.97 40,250 $25,000.00
61-0900-9030 COLLECTING DISC/RECONN 32,000 30,803 31,000 27.775.94 17,250 512,000.00
61 A900-9041 NSF 12,000 555) 2,500 556.91 7.000 $1,000.00
61-0800-9051 MISC CUST EXP 75,000 60,345 74,667 ]0,895.01 100,000 $100.000.00
615900-90fi1 WRITE-OFFS 65,000 182,931 90,000 100,944.98 100,000 $100.000.00
TOTAL 2H,004 36!,915 28016] 258,288 258.500 2]0,000
zo1+
ESTIMATED BUDGET
WRH HISTORY
ACCOUNT# DESCRIPTION 2008 2009 2010 2010 2011 2012
BUDGET ACTUAL BUDGET ACTUAL BUDGET BUDGET
AD MINIS7RATIVEIGENERAL EXPE NSE
fii-0820-9201 SALARIES/ADMIN 337,909 351.782 348000 423,735.00 387,306 5427,615.84
61-0920-9205 TEMPORARY STAFFING 5,000 7.680 7880 50.00
81-0920-8211 OFFICE SUPPLIES/EXP 57,600 73,363 89,000 57,839.98 45,000 §71,298.97
fit-0820-9212 LT/WATER OFFICE 17,500 17,077 79,925 77,981.56 13,703 §13,898.98
81-09204213 SANK CHARGES 8,500 5,172 5,260 4,283.89 4,370 $4,082.26
81-0920.9221 LEGAL FEES 12,500 49,939 26,250 42,826.78 40,000 $38934.63
81-0920-9231 AUDITING 20,000 16,741 22,050 19,+20.00 29,540 $29,540.40
81-0920.9241 INSURANCE 162,810 129,184 131,800 137 882.71 142,118 5154,434.12
81-0820-9260 UTL SHARE DEF COMP 40,050 3],401 42,]20 3B 924.79 80.139 557 280.18
81-0920-8261 UTIL SH INSURANCES 328324 308.457 386,08] 380882.31 377,000 5316,438.80
61-0920-9262 UTIL SH PERA 118 663 129,146 131,000 110 564.21 139,829 $+37,445.07
81-0920-9263 UTIL SH FICA 141,818 140,985 148,000 110,089.33 144,382 $157,352.33
81-0920-9284 SICK PAV 70,000 54.144 74,867 99,713.98 44852 §97,439.77
61-09204286 VACATION4iOLIDAV PAY 1]0.000 176,412 208000 200482.59 156,883 $1]1,350.60
81-0920-9288 MISCELLANEOUS 10,000 120 7,5x0 1 a60 $0.00
81-0920.9289 CONSERVATION/IMP/PROG 116,580 104,653 141,320 167,582.96 142,378 $+85,000.00
61-0820-8281 ENVIRONMENTAL COMP 20,444 14,005 25,000 24,130.32 24,119 §31,864.05
81-0920-9291 CONSULTING 39,000 5182 10,000 1,345.41 5,000 $4,844.00
81-0920-9292 LFG GAS PROJECT 839 50.00
61-0920-9301 TELEPHONE 19,000 14,180 17,067 17,230.40 13,918 §17,219.89
61-09204302 ADVERTISING 20,000 1212 12,110 4,800.10 4,142 §2,841.95
61-0920-9303 DUES/SUBSC/FEES 40,000 141,386 139582 108900.27 209,938 $150,028.93
81-09204304 TRAVEL 5,000 341 3,000 1,821.63 2,120 59,666.23
81-09204305 SCHOOLSIMEETINGS 86,118 101.944 88,488 116.708.18 105,000 $105,000.00
61-0920-9306 MISC GENERAL 2,000 6,977 2,000 5,619.88 5,000 $273.22
61-0920-9321 MTCE GEN PLANT/OFF HEAT 20,000 3,354 20000 6834.17 5,000 55,150.00
TOTAL 1114,641 1804,184 2,012,288 ], 110,819 3,f /0315 411]400
TOTAL E%PENSE 23 896 862 29 854 693 25 009172 28113171 27 817 909 3t 28 826
7,693 249 7,738,785 8,146,863 8 570 12]
ELECTRIC 2009 2009 2010 2010 2011 2012
TOTAL REVEN
TOTAL EXPEN
UES
SES BUDGET
24,819,988
23,896,662 ACTUAL
24424188
Al 64693 BUDGET
253W 192
25,009,172 ACTUAL
28985 39
28,117171 BUDGET
28 61719
27,817903 BUDGET
71,899978
91229 28
PROFR- LOSS 723,326 589A95 988020 872,088 338,818 609 51
1.63% 3.23% 1.19% 1.29Y.
zot7
ESTIMATED BUDGET
WRH HISTORY
ACCOUNT% DESCRIPTION 2009 2009 2010 2010 2011 2012
BUDGET ACTUAL BUDGET ACTUAL BUDGET BUDGET
62-0460-0697 INTEREST INCOME 25,000 141,043 25,000 31,802 32,500 $28,000.00
62-0460-0692
62-0610.6101
62-0610-8171 OTHER INTIMISC
WATER SALES
UNMETERED SALES
2,000,000
2,182.110 2,000
2,000,000 1,735
1,876.363 2.000
1,828,000
1,000 51,000.00
51.830,370.00
62-08205260 TRANSFER IN FROM CITY 77,914
82-08205300 SERV DONATED BY CITY
62-08205301 CUSTOMER PENALTIES 20,000 24319 20,000 19,723 20,000 $17,000.00
62-06205401
62-0820-8402
62-08205403
62-08205405
62-06205406 WAC FEES
MLSC CONNECTION FEES
MIBC REVENUES
CONTRIBUTIONS DEVELOPERS
WATER TOW ER LEASE
TOTAL REVENUES 200,000
55,000
2,500
-
2302500 56,480
28,898
3,801
2434657 25,500
4.500
2,500
2079500 155,759
17,575
10,531
304,775
35033
2472010 27,500
5,300
2,500
78000
2094800 570,800.00
515,300.00
$2,000.00
$73,434.00
2737704
Prior Penotl Atl usbnent
ACCOUNT# DESCRIPTION 2009 2009 2010 2070 2017 2012
BUDGET ACTUAL BUDGET ACTUAL BUDGET BUDGET
fit-05975260 OPERATING TRANSFER 20,000 20000 20,000 25,000 25,000 $25,000.00
ty860N0) 38,000 Nl,ppO 20,000 35,000 36,000 26,000
MAINTENANCE
fit-0700-7021
62-0700-7022 MTCE OF STRUCTURES
TOWER 8 GROUNDS INSPECTION 9,000
(1,500 15,331
2.312 9,000
5000 7,230
705 11,000
7,000 $10,000.00
$1,400.00
rorAL 3)so0 n,ea 31,000 3zms u,ao0 36,100
PUMPING
62-0710-7101 SUPERVISION 28,000 74,831 21,500 8,368 21,500 $8,200.00
62-0770-7181
62-0770-7182
62-0710-7183 SUPPLIES/EXPENSE
SAMPLING
CHEMICAL FEED 175,000
7,000
45,000 221,657
5,794
37,858 187,000
7,000
48,000 222,885
6,074
47,520 215,000
7,500
50,000 $225,000.00
$4,700.00
523,000.00
62-0710-7201 MTCE PUMPING EQUIP 10,000 8,075 5,000 5,597 12.000 $2,800.00
62-0710-7220 MTCE OF WELLS 135,000 68,879 105,000 54,741 32.000 $71,325.00
62-0710-7225 GENERATION
TOTAL 1,500
101,500 80
35B,>J1 1500
])6,000
33B,Hp5 1500
338,600 50.00
336,036
DISTRIBUTION
82-0730-7301 MTCE WATER MAINS 33,000 26.443 50,000 32,371 30,000 $14,000.00
62-0730-7302 WATER VALVE REPAIR /,100 1,856 8000 3,543 3,500 $4,000.00
82-0730-7309
62-0730-7310 LOCATE WATER SERVICES
LOCATE WATER MAIN 729
72 0,500
3,500 5,730
1,364 8,500
3,500 $5,000.00
52,500.00
62-0730-7311
82-0730-7312 MTCE WATER SERVICES
WATER METER SERVICE 50,000
7,000 28,574
9,325 38,000
7,000 16,845
12,256 44,000
15.000 516,000.00
515,000.00
62-0730-7315 INSTALL 8 MTC IRRIG MTRS 5,186 5,000 2840 5,000 $5,000.00
62-0730-7321 MTCE CUSTOMER SERVICE 05,000 48,045 17,500 2],819 20,500 $15,000.00
62-0730-7322 WATER SERVICE INSPECTIONS 500 137 500 B6 500 $500.00
62-0730-7325 WATER MAPPING 1,979 9,500 2,379 8,000 §5,500.00
62-0730-7331 MTCE WATER HYDRANTS 20,000 3,725 15,000 6,482 15,000 515,000.00
62-0730-7341 MTCE WATER EXPENSE 5,000 13,043 11,000 10,798 11 000 $72000.00
82-0730-7391 WAGES 10,500 6,600 10500 4,183 10,500 $5,500.00
62-0730-7395 TRANSPORTATION 10.000 10,318 13,000 ~17,Ofi4 13000 $10,000.00
62-0]30-7399 GENERAL EXP/PERMITS 14.000 14,475 16000 13729 14,000 514,000.00
roTAL LIB, 100 1p8,11B 3/],000 151.196 z08,000 1]8,000
OTHER EXPENSE
62-0745-7151
62-0748-7401 I DEPRECIATION
NT ON BONDS/LONG TERM 950,000
200,911 956,993
274,958 990,000
288,439 955,323
143,361 1,019,700
131,139 $1,400,000.00
$116,632.50
62-0750-7563 AMORTIZATION 93
82-0750-7584 AMORTIZATION 94
82-0750-7585 AMORTIZATION 97
62-0750-7566 AMORTIZATION 98
62-0750-756] AMORTIZATION 2001 3,558 593
82-0750-7568
62-0750-7569 AMORTIZATION 2(103
AMORTIZATION 2008 Ret 2,667
4,719 2,667
8,096 2,887
4,719 9,710
7,431 2,887
4,779 $4,710.00
$7,131.00
825750-7581 2 010 GO BONDS AMORT DISCOUNT 602 -$3,272.00
rOrat f.33e,z8) f,2ae,3>a f.z63,ezs f,1 f0,91s 1,1se,z3s fs15.582
CUSTOMER ACCTS EXP
62.0740-7431
62-0900-9030 C
62-0900-9051
62-0900-9061 METER READING
OLLECTION EXP
MISC CUSTOMER EXP
WRITE-OFFS 20,000
7,000
25,000
d,750 29,818
3,220
24,715
4,252 30,000
4,500
20,333
5,000 17,597
6,760
20,648
i,fi79 10,800
8,000
25,000
5000 $7,000.00
$6.000.00
$25000.00
$5,000.00
TOTAL s6, 150 01,105 69,63) 18,681 16,606 13,000
N ONOPERATING REV&EXP
82-0790-7900 O PERATING TRANSFER FROM CITY _
62-0790-8267 W ATER 8 LABOR DONATED $500.00
500
tun
ESTIMATED BUDGET
WRH HISTORY
ACCOUNTA DESCRIPTION 2009 2009 2010 2070 2071 2072
BUDGET ACTUAL BUDGET ACTUAL BUDGET BUDGET
ADMIWGEN EXPENSE
82-0920-9201 SALARIES/ADMINS
62-0920-9205 TEMPORARY STAFFING 110,000
1,000 119154
50 92000
1.820 106,261 94,760
1,920 $84,878.39
$0.00
82-0920.9211 OFFICE SUPPLIES/EXP 17,000 26,669 17,000 25,579 23000 530.087.34
62-0920-9272 LTANATER CONSUMP OFFICE 4,000 5 553 3,700 4,495 3,700 53,489.75
62-0920-0213 BANK CHARGES 1,500 7,724 1,000 1077 7,000 $1,019.77
62-0920-9222 LEGAL FEES 2,000 10,598 5,000 8,789 75000 55,274.23
62-0920-9231 AUDIT 5.000 S,SBO 1,200 4,780 4,200 $7,385.70
62-0920-9241 INSURANCE 45,000 29824 35000 23,873 35000 $26,988.89
62-0920-9251 WATER UTIL CONT
62-0920-8260 UTILiTV SHARE DEF COMP
15,500
13,799
11 330
9,731
11,330 $0.00
$14 322.55
82-0920-9261 UTIL SH INSURANCE 104 281 101,060 82.189 93,981 96,189 579,859.20
62-0920-9262 UTIL SH PERA 18,055 15,495 18,000 13,089 20 000 $15,865.74
62-0920-9283 UTIL SH FICA 25,300 18,845 22,000 14.575 22.000 $17,142.15
82-0820-9269 SICK PAV 22,000 18,049 17,333 24,608 19,333 $14,315.52
82-0920-9267 VAC/HOLIDAY PAV 60,000 58,871 52000 50,942 59,000 $33,848.90
62-0920-9268 WELLHEAD PROTECTION PROGRAM 6,121 8,500 510,000.00
62-0920.9269 CONSERVATION IMP PROGRAM 15,000 1,670 8,000 3811 70,000 $10,000.00
62-0920-9293 CONSULTING 6.000 9,061 20,000 987 20,000 36,000.00
82-0820-9301 TELEPHONE 8,600 4,671 3,483 4,289 3,483 $4,300.00
62-0920-8302 ADVERTISING 5,000 290 890 475 890 5750.00
62-0820-9303 DUES/SUBSCRIPTIONS 35,000 36,572 37,000 30,989 37,000 $37,000.00
62-0820-9304 TRAVEL 2,500 2.000 2,000 $2.000.00
82-0920-9305 SCHOOLSIMEETINGS 26,000 19,191 20,627 13,949 15,000 515,000.00
62-0920-8307 MISC GENERAL 2.000 93 500 1,559 500 5500.00
82-0920-9321 MTCE GEN PLANT/OFF HTG 7000 1 718 1,650 1,459 i 850 1,650.00
TOTAL 635.110.00 181.180.38 955,88200 111,588 605,165 918,00)
TOTAL EXPENSE 2,490283 2,368,707 2,402,480 2,125,555 2292,980 2.197993
WATER
TOTAL REVENUES 2]02 00 2434,8$7 2,079500 2,472070 2,094800 2137704
TOTAL EXPENSES 2,498,283 2,368,707 2 02,480 2,125 555 2,282 980 2 697,99]
PROFR LOSS 195 763 BS 944 322 980 348 B 798180 ]fi0 289
S R
a ~~
m SA m~ ~ m ~g $~ m
~
d .=
N m n oi
m N r
C1 of
~- y
y 1(1 mm
r m
N
~
y
L
°
m
Y
R ~~ ~p °g 8 8 ~8 S
m ~8 ~ ~
$ $ ~8 $ $ 88 F ~$ $ $$ $ ~8
Q~'F N K w N g
YI ' Y
~
w ~ y
W
N ~ +
$ $
$ $
$ p
w $
$ '
~ $
$
m $
$
$ $ p
w
$
S $ p
N
$
$
$ N
C a $ ~ 1/I
w~
Wg Qq
25 $ g Q
S
~Ti~ t~
$ O
O
~
F
M
~
$
l
8p
y
$$
$
~
~
$
$
~v°~~ g
X O
N
O
$
$$
~~ w V
t9 N q
»
N y
~y
wM Y
w {
~~
y
ww w w t
O
Mw
C~~$
§
~ p
O Q
h
o p
O
~
P~
O
Q
r
$
$
H
~
$
$ p
G
~
m
o
$ p
$b
N O [
p ~
d ~
M d
N q
~
yN d
NN V
MwI ~
X d
N V
V
w~ ( ~
w N M mm
N
N $ $ r $
m $ $ $ $ $ p
w $ $ $ $ $ $ °w $ $ p
W $ $ $ $ p
w° w
S N
U
n Q
~$
a- o
$
$$
$$
$$a~
$$
$
$$
$
w
$n$
$
$
$$
j N M N
W
g $ ~
~ $ Q
O ~ b
OOO
S
S O ~
O
m $ p
w
~ ~
$ $
~ m N
bb
r
$ p
w $
a y ~ w w$
~ w ~
f
w a
M ry
~N
w w Ylw
Q
'
' S $$ ~ ~$ ~$ ~ $ $~ g°O $$ $
~$ ~ $ $~
~
a SA Ai A iRR $
$
"~
a$
N O1 ~yg 88
NW ° S8
N 8 S°o ~ $ $$~f jj8 $$ g gy°o ~ o° $ $°g
w y w 19w MM w N w y Nw iA
N
N ~S
g O
~~ `sues`~
M ~
m
N
g ~
t'~
g ~
NN
s $
ii
~SN
g
M
$
$ ~
~
$ $
(~
1 g yg~
'
~
$
$ g
Jq yl
M . w w w w N
m O NE tO
m m Nl I` Om O
CO OO mY]
m p 1~ N N ~ O~ 00 N O
m
q
u ~ nm `~ '° $ o o~ mo n
~
Y mo ~
N =
F
a
U P
O I~O
m O Hm m m OOa
m 00
$
N
=
' • 0 0~ O m ~m P
Y ~O N~ 00
~N mm O
a w
~$ mm
r NN m 000 000
m 0
O 00
O C m 0 O
O
vom
~~ N
R
0 ~Gl
J N
_
N J
i
^ d
x
° a
'
J
H
u v ~
m~
z
E
.~
N
~~
~
~ ~
-
a
°
s ~u m ~ E d
m
~ F
~~
;~~
5
~d
~
a
~ ~
zi
i _
'~9
im
'
~ .
x
3 ~ m a ~
~
6
O m
a` a" 3a
q ymo
dc) ~
_ -
au. CO
Hf pm
CN
"u n~m ~ 9$
dN~C ^
W ~~
x W
~ w{N
W
vi gCU
O
1~
O
O U ~ea°
O J U xE
m U-
e $
' 5 ~~
K ~
LL ~ O~ U'3 x FH°
C C U W U U
O U U
1' C
O U J LL
Q K d
O
m
m
K
m
m
O
a`
U
d
E
E
0
U
m
m
m
N
N
m
w
S
Q
ry L
W
V
m } d 6
w d~QU
N O g S a
m ^a~ad ,^_°u
N ~ S w C
w ~y¢~E
C ~ d G 3
~ mg 0
m K gCO Q ~ L
w m°1m°m
nma
o w =~3
- ~~$ n ~
r Yc~~m
$ o~~8a
m d C a d Z
$ osE~
yg ~~o~a
aA d ~HEL
N dde
~~~LLO
°~c°w
dd~FdO
a~¢¢~~°v
EN:~$@g
$ Ym~E~'u
0 " d =
d d
r Rmo33~z