5.4 ERMUSR 11-09-2005 16
Elk River -�-�
Municipal Utilities
13069 Orono Parkway phone: 763.441.2020
Elk River,MN 55330
Fax.763 441.8099
October 19, 2005
' To: Elk River Municipal Utilities Commission
Jerry Takle
John Dietz
' Jim Tralle
From: Bryan Adams
' Subject: 2006 Proposed Budget
' Attached is the proposed 2006 Elk River Municipal Utilities budget. We have spent the past
number of months reviewing components of this budget. This proposed budget reflects the
111) following changes from your initial review.
Water
a) Increase WAC fee from $1750 to $2000.
See attached sheet for analysis of WAC fees.
Electric
a) Minor tinkering with the expense budget to reflect proper addition.
b) Added revised income & expenses for the 41h engine at the landfill
c) Revised capital budget to reflect 1 Target feeder.
d) Increased cost of the 3 feeders in Otsego from $375,000 to $400,000.
e) This winter we are required to extend a feeder through the gravel mines
' on Co Rd 33 & Proctor to allow for Co Rd 33 construction next spring-
$70,000 item was added.
I) The wholesale electric is still preliminary. GRE was just notified by
BNSF Railroad that their coal transportation rate will double. This is a
' $600,000 hit for GRE. Our portion is approximately $108,000.
It is unknown at this time how GRE will cover this expense.
g) The retail rates remain unchanged from previously presented. The finalized
budget will recover only the increased cost from the wholesale rate
increase.
' Staff recommends adoption of this 2006 utility budget with the understanding that the retail
• electric rate increase only captures the cost increase from the wholesale rate increase.
I
4
I
I
I
I
ELK RIVER MUNICIPAL UTILITIES
I
I ANNUAL BUDGET
FOR
N 2006
I
I
1
1 TABLE OF CONTENTS
SUMMARY
Electric and Water 1
CAPITAL BUDGET 2-3
1 CAPITAL PROJECTIONS 4
TRAINING/TRAVEL 5
ELECTRIC
Summary with Comparisons 6
' Working Budget 7-10
WATER
Summary with Comparisons 11
Working Budget 12-14
APPENDIX
Electric Income Projections 15
Water Income Projections 16-17
' Conservation Improvement Programs Budget 18
Personnel Projections 19
I
ELK RIVER MUNICIPAL UTILITIES
NO SUMMARY OF YEAR 2006
BUDGETS
I
IELECTRIC BUDGET SUMMARY 2006
IELECTRIC REVENUE $ 17,258,503
ELECTRIC EXPENDITURES 16,161,982
IELECTRIC NET FOR CAPITAL 1,096,521
DEBT RETIREMENT 245,000
IPROMISSORY NOTE TO COUNTY 157,152
GROSS 694,369
CAPITAL EQUIPMENT/CONSTRUCTION 5,027,000
IBONDING 3,500,000
NET (832,631)
PpDEPRECIATION 1,520,000
NET TO RESERVES 687,369
I
IWATER BUDGET SUMMARY 2006
WATER REVENUE 1,610,754
IWATER EXPENDITURES 2,067,663
WATER NET FOR CAPITAL (456,909)
IWATER FEES GENERATED (FOR EXISTING& 475,000
FUTURE BOND PMTS)
IDEBT RETIREMENT 410,000
GROSS (391,909)
ICAPITAL PROJECTS FROM CASH 461,500
16 NET (853,409)
DEPRECIATION 750,000
INET TO RESERVES (103,409)
I
BUDGET SUMMARYSheet1(6)
I
111111
Elk River Municipal Utilities
2006 Electric Distribution Capital Projects
I
Equipment Needs Delay to Next
I
Year
$30,000 Replace Brush Chipper (17 Years Old)
I $180,000 Replace Digger Derrick Line Truck (10 Years Old)
$6,000 Replace T10 Trailer with T14 Trailer (14 Years Old)
$40,000 Tooling for 1000 KCMIL Conductor(Target Feeder)
I $5,000 Replace Tires
$5,000 Replace Ropes, Slings & Chains
$4,000 Replace Fiberglass Hotstick Tools
I $8,000 Replace Hand Tools
$10,000 Unknown
I $288,000
I
Normal Distribution Construction, Substations & Feeders
OD $200,000 Continue new feeder to west Industrial Park
$50,000 Start Extending feeder up Co Rd 1
$70,000 Relocate lines under HW 101 @Co Rd 39 & 42
I $50,000 Rebuild Otsego Trailer Park due to HW 101 construction
$80,000 Rebuild Area 16
$90,000 Rebuild Area 21 between Proctor & Co Rd 1
I $50,000 Rebuild Area 17
$35,000 Start Rebuilding OH Line on Co Rd 40
$550,000 Upsize West Bank#1 Transformer
I $250,000 Construct Otsego Substation
$400,000 Construct 2 new feeders and bury existing feeder from Otsego Substation
$850,000 Construct Station 14 Substation 2nd Bay
I $930,000 Construct 2 "Target" Feeders
$100,000 Purchase land @ Waco & Co Rd 35
$70,000 Feeder through Gravel Mine Co Rd 33 & Proctor
I $3,773,000 Total
I New Developments
Park Place
Hillside
IDEagle Marsh
4th Engine/Generator @ Landfill $650,000 which will be funded by Sherburne Cc
I
2
I
Ill
Elk River Municipal Utilities
2006 Water Distribution & Electronic Technologies Capital Projects
IWater Department Capital Projects
I1. $30,000 Paint or remove Jackson St Water Tower (Delay)
2. $80,000 Loop water main on Co Rd 30 for Target expansion
I3. $75,000 Loop water main at 175 Av to improve Johnson St Water Tower
4. $20,000 Pull, Inspect and repair Well #4
1 5. $18,000 Pull, Inspect and repair Well #6
6. $120,000 Continue ASR study for well #2
I7. $9,000 Purchase and install Oil-less air compressors for wells 4,5,6,7
8. $42,000 Purchase Portable Vac-Tron Valve Exerciser
1 9. $40,000 Purchase another portable 250 KW generator (Delay)
10. $30,000 Purchase and install automatic switchgear to operate generators
Ito peak shave electric load.
11. $12,000 Loop dead end main at Guarding Angles (Delay)
11. 12. $3,000 Electrically inspect all well & treatment plants for potential
failures.
1 13. $10,000 Pick-up truck for summer help. (Additional to Fire Truck)
14. $15,000 Miscellaneous Repairs
$422,000
i
Electronic Technologies Department Capital Projects
I1. $5,000 New Computer for Meter shop
2. $2,500 Tent for Meter shop
1 3. $60,000 Pick-up for new supervisor& locator/CAD operator
4. $30,000 Computer& Software for 2 new employees
110 $97,500 Total
I
I
3
1 '- NM 111111 NS all NM NEI 1111 all S MN 111111 EN 11111 111111 Erin 11111
Elk River Municipal Utilities Ten Year Caitp al Projec Projections
20031 2004 2005 2006 2007! 20081 2009] 2010 20111 2012 201311 2014 20151 2016
Electric Dept I — —
System Demand_ 40500t 42930 45506 48236 511301 54198 569081 59753 62741; 65878 69172 72631 _ 76262
Substation Capacity 50800 50800 50800! 83000 830001 83000 830001 8300.01 83000 83000 98000, 96000960001 98000
Bucket Truck _110000
' 140000 1400001 14000.0 280000 !_
f _
Digger Truck 1180001 170000 _ I 1 70000
1450001 155000
� 600001 -_
Dump Truck/Additional Truck 35000 1
Pick Up Truck 25000 _ 26800 75000 30000 7500_0__ 30.0_00 30000' 30000 f 300_00_ 90.0001 300001 t
Cable Plow/Back Hoe 70000 _1 50000 16.0000 !
Chipper/Trailer/Fork Truck 33000 40000 36000 36000 30000' 40000 _40000!
Other Equipment 400001 43000 300001 72000 35000, 350001 350001 35000' 35000 35000 350001 35000 350001___
Breakers&Feeders @ Substations 155000 1000000 260000 1580000 560011 1034000 50000_ 800000 0 5000001 500000 _500000 5000001
Substation Additions 55000, 15000 _ 1750000 800000 I 1000000
Diesel Engine Repair 2.50001 25.000 250001 25000 300001 30000 40000 40000, 40000.1- 40000 40000' 400001 40.000,
Normal toryADistnbution Constr 830.0001 3605001 300000 350000 300000
AEC Territory Acquisition 836000 400000500000 5000001
ry � -- I --- -1 -- ��-- --- � 300.000 G —_ 30.0000 300000 _—
375000 445000 315000 440000 450000' 450000 4000001 400000 400000'!
570000 290000 550000 110000 300000 3000001 300000 300000'
New Development Installation(net) i 320000' 320000 320000 333000 333000, 33300013500007 1
3500001 350000' 350000
Transformers&Meters 1 200000 2.00000 200000 200.000! 250.000, 250000 2500001 25000.0.1 2_50_0.00 250000;' 250000 25000_01
Warehouse or Garage 15000 _400000' i j
SCADA!CAD Seal Coat 10000, 30000 30 0— 30000 37000 100000 100000 40000 40000, -- 40000
_ 1 37000 40000140000 400001 40000
of 50 -- — 1 I --- - 0 10000 — —
Electric Technologies 30000; 7000 5000 37500 10000, 50001 50001 15000 10000 10000 10000 150001 15000;
Total Cash Requirements 2624000 2585300 2011000, 4998500 22350001 2564000 2190000 32700001 1635000! 2305000] 21700001 32150001 20700001
Water Dept — 1 — 1 ! ! I I
Maximum Daily Demand 5200000, 5564000 5640000 5800000 6090000 639450011 6714225 70499361 74024331 7772555 8161182' 85692427—89977041
Pumping Capacity ' _ 6480000 7920000 7920000, 79200001 9440000, 9440000 108800001 10880000! 108800001 12280000 122800001 12280000' 12.2800001 - _—
WaterMainImprovements 300000 25000 1250001 155000 3.25000; 100000 3000001 250000 500001 100000 3000001 20000' 2500001
New Water Tower 1 17000001 _
I _ —
Paint Water Towers 7000 130000 300001 250000 _ _ 2500001 _
New Well&Filter Plant 9000001 1 4000007 400000 12000001 � _ 800000
Trucks&Generators _ 60000-1 26800 15000 82000 280001 28000'1 _ 70000' 600001
Control Upgrades I 90000 1500001 1 42000 70001 7000; 7000 7000 70001 7000 7000. 70001 7000,
Pull Well&ASR 15000 78000 158000 80000 _ 20000 200001 20000 20000 20000 20000' 200001 20000!
SCADA �1 50000 ! _ T 100001 _
GIS ; 25000 27000' 1 , 1 1
Miscellaneous — _I 15000 50001_ 15000! 50001 50001 50001 50001! 5000 7000 7000 70001 70001
Total Cash Requirements I 13570001_306800, 3800001 452000 4750001 3820001 7320001 682000! 18100001 1340001 18640001 1140001 2840001_
— — — ! L- -- - - i
Administration _ I , �_
Computer Upgrade 15000', 35000 150001 15000 150_001 15000! _ 150001, 25000 150001 15_000 150001 150001 20000 -
Copy Machine,Fax Folder 100001 _ 45000 _ 35000 20000 I 25000' 15000
Postage Machine 3.000, i 1 ` _ 5000 1 I 6000'1 I_
_ 6000 60001 — 6000 6000! - +
Office Furniture 1 1000', 12000 60001 6000 60001 3000
Telephone System L
' _-_ I 35000 _—
AdministrationBldg _ � 15000001, 1 1 1
Meter Reading I — — 1 1
System 20.00 _ 2000 2000 1 35000 �
Total Cash Requirements 1530000 80000 150001 53000 29000 26000 21000 1210-00 21000 210001 52000 46000 23000
Total Utility Cash Requirements 1 55110001 29721001 24060001 5503500 27390001 2972000 2943000! 40730001 3466000 24600001 4086000! 3375000i 23770001
tenyearfor2
I
ELK RIVER MUNCIPAL UTILITIES
TRAINING AND TRAVEL BUDGET FOR 2005
/11111
ELECTRIC 2005 2006
I MMUA Urd Hot Line School 3 people $
1,650.00 1,755 00
MMUA Overhead Hot Line School 2 people 1,100.00 1,170.00
MMUA Underground School 3 people 1,650 00 1,755.00
I MMUA Locator Workshop 1 person 450.00 585.00
MMUA Staking Workshop 1 person 450.00 585 00
MMUA Transformer School 2 people 900 00 1,170.00
I MMUA Diesel Workshop 2 people 1,000.00 1,170.00
MMUA Meter Repair Workshop 3 people 1,500.00 1,755.00
MMUA Substation Workshop 2 people 1,000 00 1,170 00
I CAD Workshops 1 person 750.00
1st Line Supervision 1 person 2,000.00 2,100 00
Apprenticeship 3 people 2,000.00 2,100.00
Unknown 3,000 00 3,000 00
I
16,700 00 19,065.00
WATER
IWater Operators License Seminar 4 people 1,500 00 1,755 00
MN Section AWWA or MRW 3 people 500 00 575.00
IUnknown 2 people 1,000.00 1,000 00
3,000.00 3,330 00
ADMINISTRATION
APPA Education Institute - Financial 1,500 00 2,090.00
I MMUA Annual Summer Meeting 1 staff/ 1 commissioner 1,500 00 1,600 00
MMUA Fall Meeting 1 staff/ 1 commissioner 750 00 800 00
MMUA Legislative Round-up 1 staff/ 1 commissioner 500.00 550.00
APPA Legislative Round-up 1 staff/ 1 commissioner 2,500 00 2,750 00
IAPPA Annual Meeting 1 staff/ 1 commissioner 2,500 00 2,750.00
or Engineering/Operator Workshop
MMUA Superintendent Conference 1 person 1,000 00 1,100 00
IUnknown 2,000.00 2,000.00
12,250.00 13,640 00
ISAFETY TRAINING
MMUA Safety Program 18,500 00 18,800.00
I MMUA Monthly Safety Meetings 37,000.00 40,000 00
55,500 00 58,800 00
IEDUCATION 2,000.00 2,000.00
16 89,450.00 96,835.00
I
I Page 1
5
I2005 SUMMARY BUDGET WITH 2004
COMPARISONS
le ELECTRIC 2004 2005 2006
ACTUAL BUDGET BUDGET
IUNIT SALES -KWH 165,595,414 180,087,092 191,031,000
REVENUE
OPERATING REVENUE
I ELK RIVER 11,476,520 12,420,517 13,480,385.00
ELK RIVER CITY DONATED 120,687 108,102 140,585.00
OTSEGO 908,947 969,981 1,033,471.00
RURAL BIG LAKE 201,721 246,732 234,833.00
I
DAYTON 145,383 147,611 167,819.00
PUBLIC ST& HWY LIGHTING 170,801 174,678 180,000
I TOTAL OPERATING REVENUE 13,024,059 14,067,621 15,237,093
CIP 15,000
RATE INCREASE 201,000 253,000
3,024,059 14,283,621 15,490,093
Ii
OTHER OPERATING REVENUE
INTEREST/DIVIDEND INCOME 25,704 5,000 10,500
CUSTOMER PENALTIES 118,915 115,212 136,000
I CONNECTIONS 617,320 350,000 350,000
MISCELLANEOUS REVENUE 71,958 59,909 213,750
GENERATION CREDIT 231,854 343,992 277,160
LANDFILL GAS PROJECT 701,371 700,000 781,000
I TOTAL OTHER REVENUE 1,767,122 1,574,113 1,768,410
REVENUE TOTAL 14,791,181 15,857,734 17,258,503
EXPENSE
Pi OPERATING & MTCE PURCHASED POWER 8,563,298 9,512,763 10,246,000
LFG FUEL 141,783 89,009 126,000
OTHER OPERATING & MTCE 313,232 239,985 220,900
LFG 241,363 258,000 318,620
I DISTRIBUTION 142,265 187,000 163,100
MAINTENANCE 551,771 607,726 708,430
DEPRECIATION 1,427,091 1,130,000 1,520,000
I INTEREST 87,545 109,522 200,000
OTHER OPERATING & MTCE 8,225 32,132 134,120
SERVICES TO THE CITY 294,698 295,000 322,500
CUSTOMER ACCOUNTS 121,136 126,000 152,000
I
ADMINISTRATIVE &GENERAL 1,446,173 1,443,413 1,643,312
TOTAL (BEFORE OPERATING TRANSFER 13,338,580 14,030,550 15,754,982
I TOTAL REVENUES 14,791,181 15,857,734 17,258,503
TOTAL EXPENSES 13,338,580 14,030,550 15,754,982
OPERATING TRANSFER TO CITY 340,564 371,857 407,000
1 NET INCOME PROFIT(LOSS) 1,112,037 1,455,327 1,096,521
111
ill10
IElectric3 yr comparison budgets
wiii _ AT GET_
ACCOUNT# D RIPTION 2000 2001 200.2 in En MIN MIN IIIIII IIIIII all
2003 I Y 2003 ' 2004 200.4 2005 2 _
61-0440-4411 E.R RESIDENTIAL
ACTUAL 2 6 ,234
ACTUAL ACTUAL I ACTUAL BUDGET I BUDGET ACTUAL BUDGET ESTIMATED BUDGET
i 3,157,284 3,572,011 4,028,374 j 3,900,647 4,160,603 4,526,547 4,942,279 5283,157
61-0440-4416 OTSEGO RESIDENTIAL 504,698 j 492,690 582,183 1 607,479 561,981 ' 634,816 633,901 684,696 739,857
61-0440-4421 B L.RESIDENTIAL 161,239 170,330 181,835 186,228 199,067 1 197,100 194,657 239,741 _ 227,194
61-0440-4431 DAYTON RESIDENTIAL 102,125 108,412 110,294 119,116 105,060 ' 126,963123,160 126,831 143,746
TOTAL RESIDENTIAL 3,631,296 3,928,716 4,446,323 4,941,197 4,766,755 5,119,482 I_ 5,478,265 5,993,547 j 6,393.954
61-0440-4415 E R.CITY DONATED 73,900 69,346 ' 74,904 69,934 71,224 , 72,000 120,687 108,102 140,585
61-0440-4412 E.R NON-DEMAND _1,088,190 1,058,702 , 1,119,547 1,211,657 1,257,,6022 1 1,2744,973 1,275,230 1,407,359 1,401,185
61-0440-4417 OTSEGO NON DEMAND 82,484 91,075 71,008 105,337 123,907 12.4,920 r 141,065 146,188 _ 1.54,998
61-0440-4422 B.L NON-DEMAND 2,815 4,366 - 5,018 5,322 4,290 4,408 5,332 5,217 5,859- -
61-0440-4432 DAYTON NON-DEMAND 14,535 ' 12,197 14,975 15,606 14,332 1 14,573 ' 17,915
16,600 19,685
TO TAL NON-DEMAND 1,261,924 1,235,686. 1,285,453 1,407,856r
I 1,471,355' 1,490,874 1,560,229 1,683,466 1,722,312
61-0440-4413 E.R.DEMAND 3,946,153 4,244,754 4,840,934
-5,313,368 5,185,928 5,531,366 5,648,049 6,043,797 6,768,443
61-0440-4418 OTSEGO DEMAND 17,336 4,178 16,069 121,392 L 17,090 123,640 133,176 130,000 I 130,000
- -- - - -- 11j
61-0440-4423 B L.DEMAND - 1 - - j
61-0440-4433 DAYTON DEMAND 5,534 82 5,203,018 5,655,006 717 95
-
TOTAL DEMAND 3,963,489 4,254,466 4,857,085 5,434,760 5,781,943 6,173,797 6,898,443
61-0440-4414 E.R.SECURITY LTS 21,673 23,003 23,124 24,9271 25,681 24,714 2.6,694 27,082 27,600
61-0440-4419 OTSEGO SECURITY LTS 8,511 8,433 8,850 8,972 5,757 9,039 805 9,097 8,616
61-0440-4424 B L SECURITY LTS 1,797 1,753 1,545 1,781 ! 1,476 1,805 1,7.32 i 1,774 1,780
TOTAL SECURITY LTS 36,120 37,252 37,554 39,827 36,952; 39,620 32,821 4,180
2 80 T 42,381
61-0440-4434 DAYTON SECURITY LTS 4,139 4,063 4,035 ! 4,148 4,038
42,384
61-0440-4441 PUBLIC ST/HWY LIGHTING 143,439 146,558 156,863 , 167,212 158,988161,090 170,801 174,678 180,000
TOTAL SALES 9,036,268 9,602,678 10,783,278 2,108,458 11,637,068 12,466,072 13,024,059 14,067,621 15,237,093
REVENUE INCREASE FOR CIP 32,500 1 15,000
! 13,024,059
RATE INCREASE 639,000' 201,000 253,000
TOTAL SALES WITH CIP/RATE INCREASE
' • '� -- - ---- 13,137,572 ---- 14,183,621 15,490,093
61-0440-4511 SERVICE CHARGE 13,690 12,506
61-0440-4550 SUB-STATION CREDIT 11,132 6,000 7,465 6,000 4,000
61-0440-4551 GENERATION CREDIT T 334,050 1 337,838 341,578 339,151 341,550 , _ 341,880 285,795 343,992 345,048
---61-0440-4553 FUEL COST ADJUSTMENT
61-0440-4553 PCA or RATE ADJ (-_ . (31,050) (71,176)' (71,888)
61-0440-4552 DISPERSED GENERATION I (16,537) (27,728) (35,100) 58,116)' (57,760) (61,406) {
61-0460-4691 INTEREST INCOME 95,256 95,128 76,637 54,707 18,126 I 9,000 25,704 5,0001 10,500
61-0470-4700 SECURITY REVENUE 22,374 46,888 36,609 38,728 -_ 42,085 42,085 38,720 42,085 125,000
- ----- ,- - - - -
61-0470-4701 CUST DEL PENALTIES 71,916 92,686 100,684 100,759 100,328 102,732 118,910 115,212 136,000
61-0470-4702 CONNECTIONS 459,195 519,811 57676,769 562,505 250,000 300,000 574,156 355
0,000 � 350,000
61-0470-4703 MISC/TEMP CHG _ 4,534 940 950 500 2,000 2,000 1,200 2,000 4,000
61-0470-4704 STREET LIGHTS _ 87,075 66,000 18,600 20,000 ' 20,000 ' 49,903 20,000 25,000
6-
61-0470-4711 MERCH JOBBING/CONTRA
61-0470-4715 NON-UTILITY OPERATIONS 1,780 4,321 26,852 2,500 1 2,500 T 2,500 1,000
61-0470-4721 ILFG 44,922 _ 706,405 650,244 1 656,696 701,371 700,000 781,000
61-0470-4722 MISC NON-UTILITY 8,967 8,952 55,778 64,382 ' 7,5004 49,400? 35,228 58,000 58,000
61-0470-4723 GAIN ON DISP OF PROP
61-0470-4724 SALES OF MERCH (204)' 1,690 6,646 (116) 500 1 500 (756) 500} 750
TOTAL OTHER 995,021 I 1,180,107 1,298,323 1,838,635 1,403,783 1,475,033 1,776,290 1,574,113 1,768,410
TOTAL REVENUE 10,031,2891 10,782,785 12,081,601 13,829,488 1 13,040,851 14,612,605 14,800,349 15,857,734 17,258,503
-
1 BUDGET COMPARISON 1 200610/18/05
um marl me am EN am me GET_
ow um um am Ns au iir am
WITH NI I
ACCOUNT# DESCRIPTION 2000 2001 2002 2003 2003 2004 I 2004 2005 I 2006
ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET , ACTUAL BUDGET ESTIMATED BUDGET
OPERATING/MTCE
61-0540-5461 OPERATING SUPERVISION 33,466 _ 35,280 28,898 35,618 30,617 38,640 __ 40,191 42,680 71,650
61-0540-5462 INT COMBUST SALARIES 237 5,627 6,102 6,285 6,285 , _
61-0540-5471 DIESEL OIL FUEL _6,464 8,376 15,000 15,000 778 15,000_ 25,000
61-0540-5472 NATURAL GAS 1,599 _ 3,029 2,825 4,495 3,800 3,800 5,842 _ _ 3,800 11,700
61-0540-5481 LUBE OIL 142 1,300 1,300 1,300 1,3.00
61-0540-5482 CHEMICALS
61-0540-5483 STATION PWRNVTR PLANT 19,502950 28,689 19,778 28,385 2.4,600 30,021 29,056 30,020 32,000
61-0540-5484 PLANT SUPPLIES 9,000 1 20,000 29,375 25,000 I _ 2.6,750
61-0540-5491 MISC OTHER GEN EXP 13,688 10,373 8,611 12,235 10,800 10,800 11,715 10,800 5,000
61-0540-5521 ,MTCE STRUCTURE PLANT 31,804 26,255 17,994 36,028 15,750 17,900 19,940 17,900 18,500
61-0540-5531 MTCE ENGINES/GEN 35,3861 39,236 I 54,280 33,429 45,000 ' 45,000 _ 17,759 45,000- 25,000
61-0540-5541 MTCE PLANT/LAND IMP 767 86 1,477 2.1,487 1,500 4,000 1 3,824 4,000 4,000
PURCHASED POWER I
GENERATION CREDIT
61-0540-5551 POWER PURCHASED 5,497,606 ' 6,035,913-7 6,8.49,629 7,664,354 7,464,865 8,747,862 8,563,298 9,512,763 10,246,000
61-0540-5552 LFG PURCHASED GAS 122,567 89,878 141,783 89,009 1.26,000
61-0540-5561 PLANT STANDBY
61-0550-5051 LANDFILL GAS O&M _ _ 33,844 232,308 _ 233,822 219,178 258,000 28.3,000
61-0550-5052 LFG ADMIN 611 5,365 11) 6,100 _ 4,620
61-0550-5053 LFG INSURANCE I 16,820 17,100 16,000
61-0540-5054 LFG MTCE 15,000 15,000
6 34 - I 9- 0
TOTAL 5,648,262 6,188,372' 6,997,657 8,221,256 7,628,334 9,264,308 9,104,924 10,084,757 10,911,520
DIST
[
N
61-0580-5801 REMOVE EXISBTI GO SERV 755 143 197 _ 542 1 600 600
1,350 600 2,000
61-0580-5831 TRANSFORMER OH/URD 5,775 9,625 9,332 6,282 8,000 8,000 9,449 8,000 12,000
61-0580-5851 MTCE SIGNAL SYSTEMS 1,014 1,026 478 483 2,010 2,010 1,903 3,000 3,000
61-0580-5861 METER EXPENSE 10,797 8,399 10,430 23,399_ 10,900 40,000 10,330 40,000 11,600
61-0580-5871 TEMP SERVICES 3,525 1,893 1,073 671 ' 5,400 5,400 _ 2,734 5,400 _ 4,500
61-0580-5881 MISC DIST 86,617 114,461 130,248 135,433 117,841 130,000 124,700 130,000 130,000
TOTAL 108,48300 135,547 151,758 166,810 144,751 186,010 150,465 187,000 163,100
MAINTENANCE - -
61-0590-5911 MTCE STRUCTURES 684 225 1,729 96,238 I 1,600 1,600 241 1,600 1,000
61-0590-5921 MTGE SUB-STATIONS 22,339 16,958 16,110 27,1501 18,900 26,000 25,534 26,000 26,000
61-0590-5922 MTCE SUB-STATION EQUIP 245 1,781 320 6,714 I 3,400 • 3,400 894 3,400 _ 3,400
61-0590-5931 MTCE OH/TREE TRIM 132,927 161,440 167,176 87,719 85,000 1 89,000 174,708 100,000 175,000
61-0590-5932 MTCE OF OH/STANDBY 18,546 15,000 I 21,000 25,593 4 26,074 26,750
61-0590-5933 MTCE OF OVERHEAD 58,837 I_ 70,000 71,000 33,595 56,000 57,680
61-0590-5941 MTCE URD 61,264 61,968 59,278 ! 62,691 r64,500 64,500 104,193 64,500 90,000
61-0590-5951 MTCE LINE TRANSFORMER 5,788 I 4,980 8,572 13,637f 5,890 16,000 7,499 16,000 I 15,000
61-0590-5961 (MTCE ST LIGHTING 13,900 19,184 28,561 33,053 20,000 20,000 37,805 32,300 I 30,000
61-0590-5962 MICE SECURITY LTG 5,144 1,812 3,993 3,232 5,695 5,695 6,427 5,695 3,500
61-0590-5971 MICE METERS 13,636 20,728 29,709 46,751 _ 34,176- 38,500 48,469 42,500 50,000
61-0590-5972 VOLTAGE COMPLAINTS 5,648 2,568 3,572 _ 2,297 _ 4,990 4,990 6,180 I 4,990 5,000
61-0590-5981 SALARIES T&D 17,501 18,451 18,703 19,363 _ 19,500 20,780 21,982 22,990 38,000
61-0590-5991 MTCEOH/2NDRY 9,21.7 14,7.03 16,6.26 12,756 18,500 , 18,500 13,147_ 18,500 15,000
I
61-0590-5992 MTCE URD ELECT SERV 40,796 I 49,615 51,255 ' 42,884 42,100 ' 42,100 38,351 I 42,100 42,100
61-0590-5995 TRANSPORTATION EXP 103,717 99,138 � 109,676 130,373 145,077 145,077 119,803 145,077
130,000
TOTAL 432,806 473,551 515,280 662,242 554,328 588,142 664,421 607,726 --- 708,430
II -! I
}- `
n- BUDGET COMPARISON 2 200610/18105
MINI
no
-eEli MI MIN Ell IIIII AT 1• ,GET- es owENmu mu _ r
I WITH N V
- -- - -
_ACCOUNT#1f DESCRIPTION 2000 2001 1
1 2002 2003 2003 2004 2004 i 2005 2006
ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST BUDGET ACTUAL BUDGET ESTIMATED BUDGET
OTHER EXPENSE
61-0595-8031 DEPRECIATION 812,124 902,4071 969,914 1,067,063 970,000 T 1,130,000 I 1,427,091 1,130,000 1,520,000
61-0596-8071 INT/BONDS LONG TERM 5,910 4,319 i 13,040 47,653 54,511 21,453 I 87,545 109,522 200,000
--
61-0597-8161 COST/EXP MERCH JOBBING (606)
606)
61-0597-8172 SECURITY EXPENSE _ 150001 r 15000 125000
61-0597-8213 LOSS ON DISP OF PROP 15,419 6,068 _ 8,958 1 14,523 10,000 1 337 10,000 1,000
61-0597-8231 COST OF MERCH SOLD I 30,052
61-0597-8261 ELECT/LABOR DONATED 220,950 227,266 1 188,372 265,234 280,200 290,000294,698 295,000 322,500
61-0597-826.2 TRANSFER TO CITY 230,914 252,497 1 289,264 317,918 302,1.45 329,750 I 34.0,564 371,857 407,000
61-0597-8281 (AMORTIZATION/DEBT DISC 341 114
11,530 4,070 7,000 7,00.0 ' 7,888 7,000 8,000_
61-0597-8311 OTHER INT EXP
61-0597-8263 OTHER DONATIONS 6,448 I 5,325
113 132 132 0 I 132 120
61-0597-8399 OPERATING TRANSFERS __
61-0597-8341 }INT PD ON METER DEPOSIT 6,831 5,235
t 4,902 -
t I 1,613,988 1,803,335 2.188.1757 ---- 1.938.511
I
TOTAL -- 1,298,937 1,402,626; 1,486,094 1,716,460
- - -- ---- ---- - - - -- -- - -- -2.583.620
CUSTOMER ACCOUNTS EXP j _
61-0900-9021 METER READING i 38,971 I 47,228 52,513 54,053 . 52,795 58,000 61,446 58,000 _ 60,000
61-0900-9030 COLLECTING 14,853 24,629 28,349 24,364 1 17,000 22,500 22,203 24,000 26,000
61-0900-9041 NSF
61-0900-9051 MISC CUST EXP 10,566 11,429 6,912 20,761 1 16,800 24,000 14,351 24,000 42,000
61-0900-9061 WRITE-OFFS 4,185 3,519 5,805 20,079 ; 12,000 12,000 1 23,136 20,000 1 24,000
TOTAL 68,575 86,805 93,579 119,257 98,595 116,500 121,136 126,000 --- 152,000
ADMINISTRATIVE/GENERAL EXPENSE
61-0920-9201 SALARIES/ADMIN 226,040 230,768 238,757 279,063 255,693 271,105 1 293,406 320,000 322,000
32,806 - 6
61-0920-9213 BANK CHARGES 4,598 3,882 1 4,451 _ 4,620 4,00065,500
5,100 , 5,2818 1
_ 49,674 i 63,261 60,000
61-0920-9211 OFFICE SUPPLIES/EXP 34,398 56,651 I 49,354 35,650
61-0920-9212 LT/WATEROFFICD 4,303 3,210 3,994 6,341 3,900 �_ 5,100 6,468 5,100 : 7,000_
5,838 ' 6,000
61-0920-9221 LEGAL FEES 10,412 4,398 1 4,351 4,779 8,000 8,000 5,713 8,000 5,000
61-0920-9231 AUDITING 8,250 ' 6,600 7,683 1 10,128 7,200 9,000 11,318 12,000 13,000
61-0920-9241 INSURANCE 53,081 108,762 100,203 114,309 108,986 109,980 137,282 119,800 128,750
61-0920-9261 UTIL SH INSURANCES 172,128 176,198 198,397 174,175 192,000 195,000 165,072 195,500 246,225
61-0920-9262 IUTIL SH PERA 61,262 59,055 79,375 72,188 ' 78,770 78,162 83,019 86,700 167,500
61-0920-9263 UTIL SH ICA 109,136
110,000
133,238
61-0920-9264 SICK PAY38,829 29,286 46,950 53,968 38,900 38,900 49,281 40,000 _ 41,725
61-0920-9266-VACATION/HOLIDAY PAY 128,732 128,806 138,555 158,503 124,000 129,000 198,332 135,000 155,000
61-0920-9268 MISCELLANEOUS 11,999 ' (1) 10,000 10,000
61-0920-9269 CONSERVATION/IMP/PROG 62,644 116,781 113,430 146,000 162,349 146,000 120,000
61-0920-9281 ENVIRONMENTAL COMP 10,607 I 19,763 ! 25,157 31,998 I 12,500 12,500 14,602 12,500 12,500
61-0920-9291 CONSULTING 38,006+I 19,828 16,868 33,0961_ 16,400 30,000 22,227 30,000 60,000
61-0920-9292 LFG GAS PROJECT 6,659 17,980 ' 499,906 34,000
61-0920-9301 TELEPHONE 11,357 1 11,400 13,585 12,649 12,916 13,300 10,105 13,300 12,750
61-0920-9302 ADVERTISING 18,123 L 18,787 9,614 14,282 21,000 21,000 16,461 21,000 t 17,500
61-0920-9303 DUES/SUBSC/FEES _ 20,101 ' 29,507 29,055 28,199 I 28,000_ 28,000 22,699 _ 28,000 35,000
61-0920-9304 TRAVEL 266 25 286 572 - 4,000 4,000 958 4,000 6,000_
61-0920-9305 SCHOOLS/MEETINGS 58,223 57,451 64,115 67,175 68,400 68,400 73,070 69,450 73,400
1 - -- --
MISC 2,544 , 7,200 7,200 113 7,200 1,200
61-0920-9321 IMTCE GEN PLALNT/OFF H e 45 1,002,458 1, 0,5643 1,361,4891 544,025 j 4,025 18,806 4,025 4,025
TOTAL1 ---- 1,719,776 -_-- 1,342,754 1,468,959 1,443,413 I-- ----- 1,643,312
TOTAL EXPENSE f 8,544,923 6,556,780 9,142,949 12,247,514 11,759,772 13,301,049 13,698,079 14,387,4077 16,161,982
1 I I
-
I {
1
;
BUL1C2E I GOMPAHISUN 3 2U0610/16/0S
.-0
Iif
MNI Ij,O OD iiiil
' 1
(7 N to 1O1 p
p N O1
r .-
03
O o
MI N
F
co
W— 1 ,
1
T-t II —I— _ —
d n n
I !
r,10BIWN �
,
0L o Mwd 1 1 1 1 ! !
N Im 10171 r1 1 j
CO ; l
J M OIN
'Q O OOIN1
1 O OCfO
O F- �lij r 1 1
N IQ r1'r 1
I I
-- -- - - �-1 _—�{ -�
w co o in
c� N
o D �'el'7 1 . I
N m a}Mlr 1
w r r
IN O � I
in n1n I
m n o
IIW Oin inO'�I�
OrN 1
N M r I
W � m I 1
C7 I I ' -
co n
J d .n Of 1
_ Q Oilf� I d
N M N d 00I
1
U
Q - — : - - — I—I
d n I
4
O �n d 1
J CO CO O
IIT 0
O O-1 C73 d to
N Q O r
I 1
_1 1 I
I y
in,rn m•
1
CO to N t
JnMd t—
N o O cn .-- 1 1 , 1 j
I < I r- I I — - —I 1- 4 - 1 i
00 N CO I
J NIOI IM 1 H '
I °
N o Coo0or I I
1
lii 1 I 1 1 , 1 , I
o
Cr
I
1
� o
1 -
U
ti
N
W
fil• ly
21Z fD--- -- - - — o
U WWN 11 I m
W
X O 1 1 I 1
wjv
U -I -1
WQ Q LL 1
J 1 F,o 1
W �I� a, I 1 1 i I ' 1 l 1 1 I.()
I2005 SUMMARY BUDGET WITH 2004
COMPARISONS
Ill WATER 2004 2005 2006
ACTUAL BUDGET BUDGET
IUNIT SALES -GALLONS 642,019 726,000,000 684,241,000
REVENUE
OPERATING REVENUE
I WATER SALES 1,167,954 1,443,534 1,538,804
WAC FEES 839,911 421,200 475,000
METER/CONNECTIONS 86,842 50,000 50,000
TOTAL OPERATING REVENUE 2,094,707 1,914,734 2,063,804
I OTHER OF DAYTON
INTEREST/DIVIDENT/MISC INCOME 31,024 15,000 12,600
CUSTOMER PENALTIES 7,897 7,800 9,350
ITOTAL OPERATING REVENUE 38,921 22,800 21,950
REVENUE TOTAL 2,133,628 1,937,534 2,085,754
I EXPENSE
PUMPING 282,227 258,818 367,950
DISTRIBUTION 177,557 142,400 177,850
DEPRECIATION 720,044 600,000 750,000
I INTEREST 256,207 306,917 245,000
OTHER OPERATING& MTCE 26,046 20,092 16,762
CUSTOMER ACCOUNTS 39,812 40,744 45,675
I ADMINISTRATIVE/GENERAL 314,824 280,134 435,426
TOTAL EXPENSE 1,816,717 1,649,105 2,038,663
TOTAL REVENUES 2,133,628 1,937,534 2,085,754
0 TOTAL EXPENSES 1,816,717 1,649,105 2,038,663
OPERATING TRANSFER(99 BOND) 33,897 30,868 29,000
I
NET INCOME PROFIT(LOSS) 283,014 257,561 18,091
I
I
I
I
1110.
IWater3 yr comparison budgets
1 1
MIN
_ AT r•• ,GET_
ACCOUNT# DL'SCRIPTION 2000 2001 2002 W2003� Y 2003 2004 : 2004 2005 I ei,
ACTUAL ACTUAL ACTUAL ACTUAL 1 BUDGET BUDGET 1 ACTUAL BUDGET I ESTIMATED BUDGET
I
62-0460-4691 INTEREST INCOME 79,975 55,149 _ 114,955 22,079 12,000 12,000 31,024 12,000 ' 12,600
62-0460-4692 OTHER INT/MISC ' _ 3,000 3,000 4000 3,0001 -
62-0610-6101 WATER SALES 755,462 550,035 834,562 1,047,561 1,020,000 r 1,137,369 1,167,955 ! 1,443,534 I _ 1,538,804
62-0610-6171 UNMETERED SALES 70 - -
62-0620-6300 SERV DONATED BY CITY_1
62-0620-6301 CUSTOMER PENALTIES 6,702 5,055 I 8,303 6,347 7,200 7,600 _ 7,897 7,800 I 9,350
62-0620-6401 WAC FEES 501,519 477,083 397,425 666,231 , 300,000 360,000 1 839,911 421,200 _ 475,000
62-0620-6402 MISC CONNECTION FEES 23,176 26,076 ' 41,870 I _ 84,2.03 32,960 42,500 92,832 1 50,000 50,000_
62-0620-6403 MISC REVENUES 46 36,815
6
62-0620-6405 CONTRIBUTIONS DEVELOPERS 1,372,160 I -- 1,495,953
TOTAL REVENUES 1,366,880 1,113,468 1,433,930 1,829,421 1,562,469 , 3,639,571 1,937,534 1 2,085,754
HI 1
- j f
I
-- - ----- -- ----- ---
__ 1
- I
BUDGET COMPARISON 5 200610/18/05
J
mu
gm
_e AT GE/11.1 all IIla all Sill IIIIII _ d all
WI
ACCOUNT#- DESCRIPTION 2000 i 2001 2002 2003 -r 2003 2004 101:14- 2005 i 2006
ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET I ACTUAL BUDGET ESTIMATED BUDGET
i
62-0597-8260 L OPERATING TRANSFER 23,893 28,361 20,000 30,468 33,897 30,868 _- 29,000
(99 BOND) _
MTCE373 907 19 244 5 950 10 000 }
62-0700-7021CEO STRUCTURES , 29,342
---- ` - - 10,000 10,300
25,950 40,468 63,239 40,868 39,300
-- ------ 1- - - -- - --- --- --- -- - -,--
PUMPING 21
62-0710-7101 SUPERVISION 19,199 13,723 I 21,581 21,410 21,732 21,990 22,662 24,418 50,000
62-0710-7181 SUPPLIES/EXPENSE 128,512 13.7,540 191,310 183,951 152,504 152,504 174,079 185,500 _ 191,000
62-0710-7201 MTCE PLUMPING EQUIP 44.2 4,109 3,230 1,274 _ 4,500 4,500 4,149 4,500 6,950
-- -- - - 21,400 - - - - -- --- -
62-0710-7220 MICE OF WELLS 43,819 19,546 42,752 204,893 81,337 . 44,400 120,000
33,400 33,400
TOTAL -- 191,972 --- 174,918 258,873 - 411,527 212,136 -_ --- 282,227 258,8181 367,950
- --- - ----- -
DISTRIBUTION
62-0730-7301 MTCE WATER MAINS 14,255 8,453 9,351 31,937 `` 12,700 13,400 26,135 19,000 22,000
62-0730-7311 MTCE WATER SERVICES -1 38,499 30,838 44,185 39,727 37,000 50,000 40,786 50,000 40,000
E -4 - - J 20,250 • 20,250 36,009 28,500 62-0730-7321 MTCE CUSTOMER SERVICE__ 23,024 13,588 8,006 13,638 40,000
62-0730-7331 MTCE WATER HYDRANTS 3,787 f 5,992 5,257 4,117 7,500
62-0730-7341 MTCE WATER EXPENSE 3,256 389 1,550 1 1,550 156 1,550 1,550
62-0730-7391 WAGES -1 8,021 5,489 9,459 8,564 12,701 1 12,814 9,065 12,800 19,600
62-0730-7395 TRANSPORTATION 7,720? 7,346 18,512 24,791 14,020 15,110 20,938 16,500 41,200
62-0730-7399 GENERAL( EXP/PERMITS 5,077 3,194 ! 3,547 476 6,000 6,000 •_ 5,746 6,000 6,000
TOTAL ---_ 103,639 75,2891 _ 98,319 123,251 112,271 127,174 148,217 --- 142,400 ---- - - --- 177,850
62-0745-7451 DEPRECIATION 185,266 194,614 , 292,559 585,354 260,000 ' 310,000 720,044 600,000 750,000
62-0748-7481 INT ON BONDS/LONG TERM 131,158 42,971 263,391 268,835 360,335 213,336 256,207 276,049 245,00.0
62-0750-7568 AMORTIZATION 03 ! 1708 3467 0
62-0750-7563 AMORTIZATION 93 1,298 865 1,298 1,298 1,298 1,298 5,653 I _- -
62-0750-7564 AMORTIZATION 94 1,793_ 1,195 1,593 1,593 1,764 1,764 1.2,225 -
62-0750-7565 AMORTIZATION 97 1,441 960 1,741 1,741 1,318 1,318 1,741 1,850 1,742
62-0750-7566 AMORTIZATION 98 1,101 734 1,163 1,163 1,670 1,670 1,163 1,210 1,164
62-0750-7567 AMORTIZATION 2001 3,556 3,556 2,113 3,556 3,565 3,556
TOTAL 322,056 241,340 565,302 I 863,539� 626,385 531,499� 1,002,297 886,141 1,001,462
62-0740-7431 (METER READING 10,931 8,139 13,635 15,633 13,568_+ _ 15,934 23,513 22,643 24,175
62-0900-9030 COLLECTION EXP 752 936 2,847 6,638 2,891 I 5,898 6,555 I 7,066 5,000
62-0900-9051 MISC CUSTOMER EXP 5,631 4,641 7,101 I 10,748 5,810 9,835 9,745 9,835 14,000
62-0900-9061 WRITE-OFFS 0 1200 1,200 1,200 2,500
TOTAL 17,314 13,716 23,583 33,020 23,469 32,867 39,813 40,744 45,675
----H- +- I- -
BUDGET COMPARISON 6 200610/18/05
C-)3
ma
MEI EM MIN .1.1 ...
...
_e AT GE1� _ ir
W!TN Y
I
ACCOUNT# DESCRIPTION 2000 2001 2002 2003 2003 2004 2004 _ 2005 2006 _
YR TO DATE ACTUAL ACTUAL ACTUAL BUDGET BUDGET ] ACTUAL BUDGET ESTIMATED BUDGET
ADMINISTRATIVE/GENERAL EXPENSE _
62-0920-9201 SALARIES/ADMINS 12,570 8,881 14,398 16,933 22,995 22,9927,930 24,990.00 68,000.00
62-0920-9211 OFFICE SUPPLIES/EXP 6,143 � 6,321 14,511 16,315 14,103 16,218 22,826 21,000 29,000
------ ----
_ 1,070 3,4281 780 2,980 2,156 2,980 3,500__
62-0920-9222 LEGAL FEES 825 1,253 _
62-0920-9212L CONSUMP OFFIG 227 242
62-0920-9213 BANK CHARGES I 913 1-- 1,280 2,200 2,939 1,590 1,640 1,565 1,660 2,980
2,091 2,487 2,500 2,500 44 ' 2,500 2,500
62-0920-9231 AUDIT 2,750 _ 2,200 2,561 3,376 3,000 3,300 4,398 5,200 5,200
62-0920-9241 INSURANCE 16,808 16,500 14,756 39,330 16,800 24,000 28,232 24,000 25,000
62-0920-9251 WATER UTIL CONT r
-I-
62-0920-9261 UTIL SH INSURANCE 9,849 14,127 28,605 40,405; 20,100 26,320 54,027 58,068 71,408
62-0920-9262 UTIL SH PERA 3,4051 1,370 4,917 19,500 5,366 19,096 27,673 27,136 ! 52,250
1 - - - -- _
62-0920-9263 UTIL SH FICA 9,009 8,267 25,522 19,735 13,041 17,644 36,927 28,600 1 34,913
62-0920-9264 SICK PAY 6,236 2,853 7,838 _9,868 3,800 3,800 7,471 I 4,000 12,575-
62-0920-9267 VAC/HOLIDAY PAY 13,621 9,971 16,297 18,258 12,500 13,100 40,326 13,900 37,000
62-0920-9269 CONSERVATION IMP PROGRAM 20,000 15,000
62-0920-9292 CONSULTING � 19,873 i 8,858 ' 9,948 23,332 12,000 i 12,000 18,318 ; 12,000 10,000
62-0920-9301 TELEPHONE 703 i 1,456 3,831 ' 4,380 2,650 I 3,500 1 3,374 3,500 4,400
62-0920-9302 ADVERTISING 4,852 1 3,887 5,798 5,327 , 5,000 5,000 5,613 5,000 5,750
62-0920-9303 DUES/SUBSCRIPTIONS 4,145 I 5,172 10,595 5,892 5,500 5,500 10,604 6,500 31,000
62-0920-9304 TRAVEL 7 1,320 1,320 1,320 200 1,300 1,200
62-0920-9305 SCHOOLS/MEETINGS 4,330 9,336 11,447 9,376 11,600 11,600 15,070 14,7501 20,250
62-0920-9307 MISC GENERAL 189 1,033 1,838 6,695 1,050 1,050 2,482 1,050 2,000
62-0920-9321 MTCE GEN PLANT/OFF HTC 25 990 491 14,241 1,000 1,000 5,590 2,000 1,500
1,127,017 261,818 ----156,695 194,563 I- 314,824 280,134 435,42575
TOTAL EXPENSE 751,834 609,260 -
TOTAL 116,480 103,997
- � 1,712,399 1,136,906 1,138,965 � 1,850,617 1,649,105 2,067,663
-- 5
WATER I -- - � -- --
TOTAL REVENUES 1,366,879 1,113,466 1,189,471 1,372,160 1,562,469 3,639,571 1,937,534 2,085,754
TOTAL EXPENSES 767,335 557,852 684,597 1,156,906 1,138,965 1,850,617 1,649,105 2,067,663
423,504-i - --
PROFIT(LOSS) _ 599,544 555,614 - 504,874 215,254 , 1,7788,955 288,429 _ 18,091
--t
1
______
L-- -
FI ---- - I
DUO ET COMPARISON I 7 I 200010'1(/06
-C-
1 II llli ! II l 1 ! IIllII ; I il ' III II1 i
IiI ; l
11
I11
1I � 1 s j —
Ij
1
r t
mr lI'b
1111 O YI (Y
ola1 ;,
:;‘,31;:,18,3
l0I1 ,
:OiO - } r I Io j
SIO NmI Iom0 ' ,o el-0,--0-H-,
2 c6,,,,,,,'=, IO
Or.
cv
NiYn ln mm n
o ! Jiiiiiill
t 1i
m n YNO n•NIo'N ml 4,...'eI- 0 ^ m00
lIiSl
I
_;: ;
.om 0.0 OA al' " vCV CV
o.- " ol � ffn!nM lmo rorynlmINm iNmlooNmm,ovNon_f o�� onn' O c r el mN O1o ,lowao n:0 N
mf-.- OIn _ H
0,01n10 O 1=10 Nno 0N C1,N10,0 O n O
O'0 O o'WI0, lm1m nY oI0:0 m e0 N mm' co!ho,,,, niviO ,e,=f ry=ml� lOp'Im ryIO p vm 1vI n.m m . ppmNONzrymp ..-_-1,4,-.1-,
rnIry
n p.lmO,�^on
0mpn'MO. mO rOv, 'm nry N 04
2N_lc— O
lN p
—� I.1 1 N QN N Q l n es
I l I
- H 1Qa=lf�ar•Io II' rII ^,I Ir l II! 1I: ff;::::
-'1�f_I,
--1 IlO-ln Y _I 1 It1O—vN)l-Ii-IrI{Ij II II(�I3---�__N-{!I I-__1 '• _'p�-rrIn 1 i l--111Ipt I H
lIII1 IlI
l�'I!T1II•I I IIII I
l0
Ji—' —* r-�� l I II- 1-_-_,
¢
Q
!f
-_-
t---4-
�\ --.I
m o 010 lo" 'm'.-n I ((o IO;m
'1
e'
o
4No o ppNoNo-No glnm=nomD 'Or mle'n! O,m0o10' m !Oe 0,qD nO O oO mlm.--T• rm,m OOIm m,-,•,-,•c0 N m Nr mo0,0 O m O,N 1c61•-
lo 0 cr mmp Ico �' co O m m
o Np ^Ne
NalNl ! HO n m:;;::;: :
I inj�_ :: ::
LI 1-
- PoioNn io m m r loq W./ QIn lmnl- Im!.- nIo o m m m' Iml"10
O NHm o� •-o 0 O OIn mm a NYmN n,m Inal nPomll mo m:,-,1'.4::2 moo mlornlv 51 � I Il^m' o ."r,,,4 N,
�Nj pNo mnlQrnm nl
N -1 lcub 8121
N __ IN r �, nm
Li
�SIlIINmllIln ,- 0F:Iole
pI�IfioO 10 m Po 01co N p'1a•min00 0 N0110ilm n :01101,ml in Q I0n 0,0 o- Q0
LI Y" O' O'n1 vv, .N
N
- ~I t' m.-pO 'm O N
lo � nmm
omnbolo) al
IN,
" 0m m n vIN cn Irn 01
D miQN �m
=N" mn�m;°i
_ `
N mNom pr
l � Nm pN OmeNin Q
LU ^iS � - I �_ I - -I 1I � 1 }
Ao o mI-� oo� Vn}^ mi __O ml o o eplomlo01:N m mp'm;mrrylmo m m ^ 0 00N INIoI l,. N'�,ef10otooDoo o ml E olnIn, 13Ion� ron 0Toron1" o^'aoTatNryroL'Imlo 71-ti o 0,0100 :^ -IQnoQInNI-1m Io'mI oIm o
Ico
114__'n� ry> nH iWt?< rn uclA NI, 1pI �nnm
1 jm-rlON
n O OIO I 0 nf v0 oImIm1mmQln Cu ,- � ial ! IS
N � Nm
It
I '�'Oe to eOIHI` n mlpelNIe0 �
; In i il
HI �
I - ill In
14-
OoIpi
al
N•Y 0OIN' Nin YmN0ry onul OIO Rg Ntmo aND c., Pon m 0 1-;1,1,1.0 O peleO 1Cn Nit-O peln OIn; n� Oo0 �e m mOo OIv.POpOof O 0,.,-,.10 00 m m mot
Nlpf ,n O p,O l^m mn IpOI ! m W wIcaI
j 1
U 113In nI•-31 lN!l IN p m N m nNIIlll t I ' N'nI.. N ! 1NrnID! IQI � v
{ I'Yl --4 1miW O nOO pe{ 0 O m mm0 CO tOICN N mnmmenlnpm0�p n n.i N OOO ONIomipl NIoI^ N
n NIo omI Io I-N OY OIp ..,11010m;-.,1f.,21,2
MoN t HI-! IDOi INU 0 ID'omD^, Im Y �p.- DINIm' nn.orNTm m m,ii
in onnpm : IoI IminOW = o 'N No 1 n r,emoN- nlm N Im I In�IeylN m 'm :! ^
1-'- 1,W °i -6
O_ I
1^ f SrI ,i — I II
!01-.----: OhIIoI nmm pm 101Ocol.-
olmnln o1 `r� no°r�Np�ONI on 1 2131 nl Q
Y n NloIo 0 e0 Iolo -- m m & v'
m O.- mo o n o II1Ncu IoI , m m ImmryI romO.-1N'ON O'co'NIp,0Ourm•N0n- n Nm I0I0rQ Y1W
OI 0O'"-. nIom 0 0^IN10,v o,Yn N
0 I .-in-o. IO cn n-2 0
r02
o 217 IN! N nnIn
I l I I
-" ISI lp o�00' i -
1 m 00 Ipl Trn N1I^ 1 IN
m u)IN m 0 N1pM 0'0 N Y 10 0nO0N o o ^w
I ! 4OO ,2,1'1%'
,0
iOOimO 01 IQ Nlmim nOrOoI7O Nnpp l0moNpm uO
- 1 O O10p O v , lp Im O In
m 010 2'01v^Im t otm 'Pol -m N m n Nim mmI NT NnO INLLGp NI" 0,,, N ,mm m
ONn co In N^ ItlO N m OoO m N n Y m TTOIO I'N�nIiN m Im ION pi"
N= m len � Y
I .I I n1 . TI .NO"OI O
^ �I
IIIN!
�NIt II ° 1lI _ l
O1iD,OmO m 0 N 818'.'-'O nimoYYYT - 1
O0
rymoIm II
~IoIO' i,,,, .7-.i,
I0 •IIOmOo UNoo0m0' S^
I 1l ..,N10.,10 .10 Nm o N Y a r ^ ON p .- oN nm mmO0'O N o .- lPol0 0,O NN = 01 01. Om'igw Oo evlv 1NmtO'm o 0H0pon0 w Q! n
' o m ^r uN N. !'1 nVI�m1m� •-01
O I ' ^ ' 1 N
-tiO�lozN Pon`f l _.oImonlmm -
Iola moles�.nIm m o Po o Ie^' 1E1,4 m
<,1010"0l nV o n YN pQ Y O mm`.2.1:-T0'O N Q mMINO N NIom 0 �Y Olmr,m _0 ontm0 O opmm ^ Irym olo m nl _mom 0 O 1N NInono o10 n 0 0Inv , n` ton
onDud; v coe ! ^ rnI� ImQNN I�Nl p fl In ^I _t HI I
^ I — ^
�000 m Tm I} l`'nOe �
CNI
t I
'41;g1:1.4.11-),
Y m10i�11�nY'nm O'pe N fm -II
T O1O Nol of oi I m YIm o0eVVOO mOm
r n.m - 'e .mmIIIDry '�nIN OTIO N pp �m OQ m. o m1pIniO Nn m' �ImO It tnr-m 1N nI.-O� � m'p -1N' rDIOpe
ry CI CO VI 1� mU ObNn Oo1pe '‘3,2!P N OmmNm 1HNnnOlep7lSmlmHTN
^ c. _ ---1,_-1
Iyl
~4I t1 IIl -,I lt-
I � al l a !n l 1 I I I orI� Iaww
, o Zvim O I o I I aW ml I j
ji U � U' IZ
Q. wm
. P
_1N_1w _¢!o_ lmIr.
�w¢ILL -1-I i_� I Im I
ipIU am1m
m m =' IO111 _Um i (l-,r -miLL
aaw= QI II ww to W , zIz I 1I 1WO a zai)rOmr<I Zrz_IW `IzI,w'� br0Oo1 o z xO TZWILL z 20 Z oZ U 1wmz 21120,0w z�4 'wl > w worwlw�-Im_ alafIOO aw2I F- ziw ¢pa�Irlwg <' a a. JImnw .-w<ai-Ha wU OzIo
OmIww Ovwa a U!0 Umr 0 O W i-,z r w1_,E.J < lN w ,I . wNw�Ia w¢ol., m0313.01i-1uaI> p aa s
U ,Lu Z w wzw aI1 WU pu a < If m '2 2�'wz z w>o zz ox alpm ol¢la w iwlOify p aww a oILLLLa w ILL! ,0_,,.Mi00ales,¢aOw1-O XI�]�LLKr �wtro'u"IpO 0to rarm wiz I0IL-, OUIa,U
VjiFCf-
12 � lWIz ,mi
Irla >iw o m¢ w
O i .Ulm 'Or-i r,QNjlo NN 1In�\ m,01 Qnl ,Zm, Nq
Nmv,mmN1lm0 NNNN %NNnnnnn mmPn p1nn n Yo Q Y o o Q y, Nm m um
15
...
NM 11111.� NM ME E N 1 NE -IC
Sh
A I B I C I D ! El F -IG I HIIIJI K I L I M I N I 0 I P I 0 R
1
2 Rev 9-1-05
3 6 1 295 1 405 1 623 1 82 6 5 1 95 2.15 2 2 2 25 2 3 2 35 2 4 2.45
4 1500 1750 2000 2250
5 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
6 Description
7 Pumping Units 706804 651253 786500 796725 824610 849348 883322 927488 964588 1003171 1043298 1085030 1128431 4%-5%
8 Sales Units 632590 642019 676390 685183 709164 747426 759657 797640 819900 852696 886803 922275 959167 85%of Col 7
9 ff Meters 3321 3696 3876 4056 4236 4416 4596 4776 4956 5136 5316 5496 5676 180/Year
10 WAC Units 444 560 260 238 238 238 230 220 220 215 215 200 200
11 Operations
12 Revenue
13 Revenue from Sales $1,047,560 $1,167,954 $1,376,853 $1,539,065 $1,699,239 $1,787,889 $1,977,711 $2,113,296 $2,217,302 $2,347,768 $2,484,596 $2,628,109 $2,778,646 Rate+3%
14 WAC Revenue $666,231 $839,911 $455,000 $476,000 $476,000 $476,000 $460,000 $495,000 $495,000 $483,750 $483,750 $450,000 $450,000
15 Other Revenue $115,629 $135,754 $72,800 $71,000 $72,065 $73,146 $74,243 $75,357 $76,487 $77,634 $78,799 $79,981 $81,181 1 5%
16 Total Revenue $1,829,420 $2,143,619 $1,904,653 $2,086,065 $2,247,304 $2,337,035 $2,511,954 $2,683,652 $2,788,789 $2,909,152 $3,047,145 $3,158,090 $3,309,827
17
18 Expense
19 Water Production $19,244 $29,341 $10,000 $10,282 $10,801 $11,555 $11,920 $12,704 $13,254 $13,991 $14,769 $15,590 $16,457 1 5%
20 Water Pumping $411,527 $282,227 $258,818 $367,950 $396,061 $434,127 $458,881 $501,098 $535,685 $579,397 $626,676 $677,812 $733,122 4%
21 Water Distribution $123,250 $148,216 $142,400 $177,850 $183,186 $188,681 $194,341 $200,172 $206,177 $212,362 $218,733 $225,295 $232,054 3%
22 Meter Reading $15,633 $23,512 $22,643 $24,175 $17,791 $21,197 $22,061 $22,925 $23,789 $27,734 $28,706 $29,678 $30,650 Step
23 Depreciation $585,354 $720,044 $600,000 $750,000 $787,500 $826,875 $868,219 $911,630 $957,211 $1,005,072 $1,055,325 $1,108,092 $1,163,496 Step
24 Interest Expense $356,701 $256,207 $256,683 $244,908 $231,729 $217,923 $228,269 $228,269 $289,767 $268,182 $244,842 $219,703 $199,537 Study Sheet
25 Other Operating(1999 P&I) $37,710 $33,897 $29,648 $28,808 $27,958 $32,088 $30,988 $29,875 $28,750 $27,600 $31,425 P&I 1999 Bond
26 Other Operating $26,046 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
27 Customer Expenses $17,389 $16,300 $29,413 $21,861 $22,517 $23,192 $23,888 $24,605 $25,343 $26,103 $26,886 $27,693 $28,524 3%
28 Administrative&General $262,636 $314,824 $280,134 $435,426 $465,906 $498,519 $533,416 $570,755 $610,707 $653,457 $699,199 $748,143 $800,513 7 00%
29 Total Expense $1,829,444 $1,850,614 $1,629,739 $2,061,259 $2,143,449 $2,254,158 $2,371,982 $2,502,031 $2,690,684 $2,813,898 $2,946,562 $3,052,007 $3,204,353
30 Gross Margin(Operation) -$24 $293,005 $274,914 $24,806 $103,855 $82,878 $139,972 $181,622 $98,105 $95,254 $100,583 $106,083 $105,474
31
32 Operation Funded CP $457,500 $364,667 $383,750 $345,250 $462,250 $388,500 $337,250 $312,250 $115,250 $139,250 $667,000 $125,500 $297,750
33 Net Margin -$457,524 -$71,662 -$108,836 -$320,444 -$358,395 -$305,622 -$197,278 -$130,628 -$17,145 -$43,996 -$566,417 -$19,417 -$192,276
34
35 Capital Projects w Bonds
36
37 Revenue
38 Bond Revenue $1,300,000 $0 $0 $0 $0 $0 $800,000 $0 $1,500,000 $0 $0 $0 $0
39
40
41 Expense
42 Bond Payments Prin $280,000 $218,750 $388,750 $410,000 $425,000 $395,000 $421,250 $468,100 $489,880 $548,499 $578,486 $597,411 $302,781 Study Sheet
43 Capital Outlay Expenses $1,209,212 $471,182 $0 $120,000 $20,000 $0 $400,000 $400,000 $1,700,000 $0 $1,200,000 $0 $0
44 Total Expense $1,489,212 $689,932 $388,750 $530,000 $445,000 $395,000 $821,250 $868,100 $2,189,880 $548,499 $1,778,486 $597,411 $302,781
45 Gross Bond Margin -$189,212 -$689,932 -$388,750 -$530,000 -$445,000 -$395,000 -$21,250 -$868,100 -$689,880 -$548,499 -$1,778,486 -$597,411 -$302,781
46
47
48 Inventory &Acc Payable Adi $12,030 -$23,489
49 Deprecation $186,000 $585,354 $720,044 $600,000 $750,000 $787,500 $826,875 $868,219 $911,630 $957,211 $1,005,072 $1,055,325 $1,108,092 $1,163,496 23
50 Reserve Account $806,157 $916,157 $1,026,157 $1,136,157 $1,246,157 $1,356,157 $1,466,157 $1,576,157 $1,686,157 $1,796,157 $1,906,157 $2,016,157 $2,126,157$120k/year
51 Bond Account $998,472 $823,433 $815,847 $605,402 $479,507 $495,760 $1,035,450 $838,351 $978,538 $1,281,114 -$118,464 $262,800 $821,238 51-49
52 Total Cash Balance $4,966,312 $1,804,629 $1,739,590 $1,842,004 $1,741,559 $1,725,664 $1,851,917 $2,501,607 $2,414,508 $2,664,695 $3,077,271 $1,787,693 $2,278,957 $2,947,395 51+32+44+47+48
SpringstadBcaWater Page 1
Mil MI milli' 11011 IIIII MIII I= NM IIIIII i =I IIIII MIN IIIIII IIIM MINI .... d. ....
A I B 1 C I D 1 E 1 F I G I Srdet2 I l I J I K I L 1 M I N I D I P
1 Elk River Municipal Utilities
2 Capital&Bond Revenue/Expenditures
32003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
4 Capital Outlay
5 Watermain Improvements 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 New Water Tower 159,212 0 0 0 0 0 0 1,700,000 0 0 0 0
7 New Well&Filter Plant 650,000 400,000 120,000 20,000 0 400.000 400,000 0 0 1,200.000 0 1.200,000
8 Land Acquisition 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 Engineering 0 0 0 0 0 0 0 0 0 0 0 0 0
10 Administration Bldg 400,000 0 0 0 0
11 Total Capital Outlay 1,209,212 400,000 0 120,000 20,000 0 400.000 400,000 1,700,000 0 1,200,000 0 0 1,200.000
12
13 Bond Issuance
14 Watermain Improvements 0 0 0 0 0 0 0 0 0 0 0 0 0
15 New Water Tower 0 0 0 0 0 0 0 0 0 0 0 0
16 New Well&Filter Plant 900,000 0 0 800,000 0 1,500,000 0 0 0 0
17 Land Acquisition 0 0 0 0 0 0 0 0 0 0 0 0 0
18 Engineering 0 0 0 0 0 0 0 0 0 0 0 0
19 Administration Bldg 400,000
20 Net Bond Proceeds 1,300,000 0 0 0 0 0 800,000 0 1,500,000 0 0 0 0 0
21 Discount&Costs of Issuance 52,000 0 0 0 0 0 32,000 0 60,000 0 0 0 0 0
22 Total Bond Size Admin&2003 0 0 0 0 0 832,000 0 1,560,000 0 0 0 0 0
23
24 Term(years) 20 15 15 15 15 15 15 15 15 15 15 15 15 15
25 Average Annual Rate 0 05 0 05 0 05 0 05 0 05 0 05 0 05 0 05 0 05 0 05 0 05 0 05 0 05
26 Annual Debt Service 0 0 0 0 0 0 80,157 0 150,294 0 0 0 0 0
27
28 Debt Service
29 1993 Water Revenue Bonds 107,315 0 0
30 1994 Water Revenue Bonds 106565 0 0
31 1997 Water Revenue Bonds 42,135 40,525 43,880 41,960 0 0 0 0 0
32 1998 Water Revenue Bonds 76,000 76,000 76,000 76,000 76,000 76.000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000
33 1999 Water Revenue Bonds 4 All Expensed - ► 0 1
34
35 2001 Water Revenue Bonds 294.000 294,000 294,000 294.000 294,000 294,000 294,000 294,000 294,000 294,000 294,000 294.000 294,000 294.000
36 Administration Bldg 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000
37 2003 Water Revenue Bonds 252,000 252,000 252,000 252,000 252.000 252,000 252,000 252,000 252,000 252,000 252,000 252,000
38 2005 Water Revenue Bonds 0 0 0 0 0 0 0 0 0 0 0 0 0
39 2006 Water Revenue Bonds 0 0 0 0 0 0 0 0 0 0 0 0
40 2009 Water Revenue Bonds 0 0 0 0 0 0 0 80,157 80,157 80,157 80.157 80.157 80,157 80,157
41 2010 Water Revenue Bonds 0 0 0 0 0 0 0 0 0
42 2011 Water Revenue Bonds 150,294 150,294 150.294 150,294 150.294
43 2013 Water Revenue Bonds 0 0
44 2014 Water Revenue Bonds
45 Total Debt Service 626,015 445,525 700,880 698 960 657,000 657,000 657,000 737,157 737,157 887,451 887,451 887,451 887,452 887,451
46
47 Maintenance&Repair(Operations'
48 Watermain Improvements 300,000 25,000 125,000 155,000 325,000 100,000 300,000 250,000 50,000 100,000 300,000 20,000 250,000 20,000
49 Paint Water Towers 130 000 30,000 250000 250.000
50 Trucks&Generators 60,000 26,800 15,000 82,000 28,000 0 0 0 28,000 0 70,000 60,000 0 60 000
51 Control Upgrades 90,000 150,000 42,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000
52 Remove Water Towers
53 Eastern Area
54 SCADA&GIS 75,000 27,000
55 Miscellaneous 15,000 5 000 15,000 5,000 5,000 5,000 5.000 5,000 7,000 7.000 7,000 15,000 15,000
56 Pull Well 15,000 78.000 38,000 60.000 20,000 20.000 20,000 20,000 20,000 20,000 20,000 20.000 20,000
57 Total Maintenance&Repair 450,000 306,800 380,000 332,000 455,000 382,000 332,000 282,000 110,000 134,000 654,000 114,000 292,000 122,000
58
59 Administration
60 Capital Protects Administratii 30,000 80,000 15,000 53,000 29,000 26,000 21,000 121,000 21,000 21,000 52,000 46,000 23,000
SON gstadBcaWMleter Share of Adm (25%) 7,500 20,000 3,750 13,250 7,250 P4600 5,250 30,250 5,250 5,250 13,000 11,500 5,750
IMO MIN�_ _ _ _ _ _ - _ .. _ .. _ .. _ i . ..
2006 CONSERVATION IMPROVEME PROGRAM (CIP) BUDGET
EXISTING PROGRAMS GOAL DIR LBR G & A ADVERT REBATE EQUIP $ CONTR $ SUBTOTAL LGRE $ ERMU $
ETS Wtr Htg 10 (2) I 4001 601 600– 0, 9601 0 2020 0 2020
ETS Space Htg 2 (0) 2001 60 600, 0' 01 0 860 _ 0 860
Dual Fuel Htg 10 (0) 40 120 600 01 0 0, 1120 ti 1120
Cycled AC 120(104) 5001 _2600 1500 0 12600 144001 316001 12000 19600
AC Rebates 60 (47) 1800 490 400, 18000 0 0' 20690j 12000' _ 8690
ASHP Rebates 5 (1) 400 1001 9001 20001 0 OF 34001 1000 2400
GSHP Rebates 2 (2) 200 301 9001 1600P 0 01 27301 400! 2330
Clothes Washer Rebates 75(96) 500 500' 3001 7500;0 0 8800, 18751, 6925
Dishwasher Rebates 75 (80) 500 3001 300, 375010 0 48501 1875, 2975
_
Refrigerator Rebates i 90 (91) 1 500L 300 300; 4500_ 01 0 56001 45001 1100_
Dehumidifier Rebates 20 (18) 2001 100 3001 6001 0'', Pi 1200 5001 700
Water Htr Rebates 5 (3) I 100 100 3001 250' 0! 0 750 01 750
AC Tune-Ups 120(113) 1 7501 500 1500 9000 01 0 11750 01 11750
AC Tree 150(150) 50001 5001 1000 0 18000 01 24500' 0; 24500
Load Control Audits 20 2000' 010 Ol 0 0' 20001 01 2000
Habitat For Humanity/Tri-Cap 1 (0) 5001 501 0f 01 5000 0 55501 01 5550
CFL Rebates 1200 (1091 100 7201 1500 01 6000, 0 8320 12001 7120
Commercial Audits 1 (0) 3001 100 200, 0 0 3000 3600 0_1 3600
1
Comm Lighting Rebates 2 (3) 700' 401 2001 65000, 0 0 65940 65000 940
Comm Motor Rebates 1 (0) 3001 30 2001 2500 0 01 30301 0 3030
Comm HVAC Rebates 0(0) 1 0' 0' 0 01 01 0n— 0 01 0
Comm Consultations 15(14) 1575 0 0 0' 01 01 1575 0 1575
Subtotals 1 1 16925! 6700 _ 11600 114700 425601 174001 209885 100350 109535
Adj subtotal with GRE maximum allocation ' 90,750 119,135
NEW PROGRAMS , i ! j
Display Artwork ______Al 0 0' 01 0, 0 0' 0 0 0
Energy House III 01 0i 0 0; 01 _0l 01 0, 01 0
Totals With New Programs 1 16925 6700 11600 114700 425601 17400' _ 209885' 90,750', 119135
1
Notes: 1.The number in parantheses under goals is 2005 actual as of 9/20/05. 1 1 1
2. All rebates for existing programs remain the same as 2005 except, 10 current transfer switches were added as an incentive
for ETS water heaters (+$960), clothes washer rebates were reduced from$150 to$100 (-$3,750)and AC Tune-Ups were
increased from$65 to$75(+$1,200). 1 1
3. Direct Labor includes my time (plus Mike P and Adam F time when load controls are involved) ;
. I have assumed purchase costs for trees for our AC Tree Program remains @$120 ea. Budget constraints do not allow for
1 an increase to 200 trees in 2006. 1 1 I 1
1_5.The Load Control Audit Program uses staff to audit load controls each year. However, all load controls were audited in 2005,
so only routine repair is included in 2006. _ _ 1 1
6.The amounts listed in the GRE reimbursement column includes the$50,000 rebate for Elk River East School. In addition to
that$50,000, GRE has allocated an additional$15,000 for other commercial rebates and$25,750 for residential rebates for
a total of$90,750. In order to meet our commitment ERMU should budget$120,000 in addition to the GRE allocation.
7 Total CIP spending required is 1.5%of gross electric sales =2005 sales X 1.5%or$13,900,000 X .015=$208,500
070
NS —•— 1 M 1 I NM N OM N
She
L
1 __ Personnel Projections j
2004 2005 2006 2007 20081 20091 20101 2011 2012 2013 2014 2015 2016
Electric --
Retirements __] _ G Sundeen M Price 4
--i --
-- — --
Metering Tech(Labor) New Hire I New Hiram
Metering(Security) _ 1 I 1
Laborti _ _ New Hire ire New Hire _
Part Time Summer Help 2 2 2 3 3 3' 31 3_I 3 3 3 31 3
Linepersons New Hire 'I I 1 _ 1
CAD Technician(Staking) 5 FTE New Hire 1New Hire _ - New Hiram
Security Sale&Install New Hire _+
Supervisor-Metering,Generation,Locating I New Hire i 1
i
4- I — 1
Water — j } 1 —�
Retirements D Berg jR Cline I
Operator New Hire .5 FTE _ New Hire 1 I New Hire New Hire
Labor 1 [New Hire
Part Time Summer Help 1'— 2 33 3 3 31 31 31 3 3 3 3 3
Administration I
'
Retirements B Belanger { 1 B Adams 41
V Schmidt
L 1
Sec/Clerk I — — +— F-- 1r 1
-~,-
Customer Service r HelpNew Hire 1 New Hire I 1 i'New Hire1 New Hire lNew Hirer 11 1
Maternity --
i
Contract 8VS ectal Venders 3 Mo — + --
P --- 1 -
Safety Manager (MMUA) — —
Dispatch (GRE) t
Meter Reading (Pat McGrady) __ —
Computer Support (Sarstoga) __ _ _
Substation Maintenance (GRE) _ ! — — I 1
Customer Services —
Underground Const Contractors
1 --
Engineering Consultants , 1 1 _ '
Mechanic- City contracted I 1 1 I rt
PersonProj Page 1
I
Ile
I10-19-05
Elk River Municipal Utilities
I
Justification of WAC Fees
A typical water well & treatment plant initial construction costs are approximately
I $1,250,000. At a 15 year term, 4% interest, annual payments are $108,000 or
total principal and interest payments of 15 years x $108,000 = $1,621,800
I
The last water tower constructed was 1.5 million gallons at an approximate cost of
$1,500,000. At a 15 year term, 4 % interest, annual payments are $130,000 or
total principal and interest payments of 15 years x $130,000 = $1,950,000
IAt the time of this water peak, we had 3991 meters on the system.
IA typical well will produce 1,200,000 million gal. of water in 20 hours of pumping
In 2005 our peak day was 5,638,000 gal. for 3991 water meters or 5,638,000/3,991 =
I1413 gal. per meter. One well has enough capacity to serve approximately
1,200,000 gal/1413 gal/meter= 850 meters
Water well and treatment plant cost per meter is approximately $1,621,800/850 meters =
$1908/meter
IIn regard to determine how many meters a water tower can support, there are many
different criteria for determining and sizing water towers. The most pertinent for this
I application is the total storage = average daily consumption. Elk River's average day is
approximately 1,800,000 gal/3991 meters =451 gal /meter. Our last water tower of
1,500,000 gal can support 1500000/451 gal = 3326 meters.
IWater tower cost per meter is approximately $1,950,000/3326 meters = $586/ meter.
I If the WAC fee is to pay for the initial cost of the wells, treatment plants and water
towers, and if a WAC unit is equivalent to 1 per meter, one could justify a WCA fee of
$1908 + $586 = $2494/WAC unit.. Due to the residential—commercial mix, 1 meter is
I approximately equivalent to 1.2 WAC units. Therefore the cost per WAC unit is more in
the $2494/1.2 =$2078 range.