Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
PACKET Utilities Committee 2007-04-19
AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, April 19, 2007 Preparation date: April 11, 2007 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Vacation of Overhead Electric Easements a. 136 W. Elkhorn Avenue, Lot 35A, Hupps Addition b. 102,106 and 108 E. Elkhorn Avenue, Lots 1 thru 3, CJL Resubdivision 2. Tree Trimming of Overhead Power Lines a. Request approval of budgeted $75,000 Water Department 1. Realignment of 2006 Water Line Project a. Request of additional funds from 2007 Budget Administration 1. Town of Estes Park 1996 Comprehensive Plan Update - Randy Repola a. Request approval of Scope of Services and RFP's REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. .. 1 hp LaserJet 3015 49] HP LASERJET FAX invent Apr-16-2007 3:11PM Fax Call Report Job Date Time Type Identification Duration Pages Result 342 4/16/2007 3:05:14PM Send 5869561 0:39 1 OK 343 4/16/2007 3:05:58PM Send 5869532 0:50 1 OK 344 4/16/2007 3:06:53PM Send , 5861691 0:56 1 OK 345 4/16/2007 3:07:54PM Send 6353677 0:52 1 OK 346 4/16/2007 3:08:51PM Send 5771590 0:00 0 Busy 347 4/16/2007 3:10:26PM Send 5771590 0:59 1 OK TOWN OF ESTES PARK Community Development Department Memo TO: Public Utilities Committee From: Alison Chilcott, Planner 11 Date: April 13, 2007 Re: Vacation of Electric Utility Easements Lot 354 Replat of Lot 35 and Lot 36, Block 6, Hupps Addition 136 West Elkhorn Avenue Background. This is a request by the Estes Park Urban Renewal Authority to vacate overhead electric easements located on Lot 35A of the Replat of Lot 35 and 36, Block 6, Hupps Addition. The easements are shown on the replat. The Estes Park Urban Renewal Authority is removing the overhead lines and burying them underground as part of the river walk project. This application has been reviewed by the Public Works Department, which has stated that these easement vacations should be completed in conjunction with the new underground electric easement dedications. \1 11111111#111 1111 ~ 1 M LLA).<'AF&y-E Budget. None. .A..V t i hn--r . elm k -00\\ 1 \ 1 1 1 %.3 \ i ' - Action. .\6 5 4 k Staff recommends approval \ 6 i ·, of this easement vacation <& 0 1._~; 1 • s 3 9-2 } \9» request conditioned on <744# s' i 8157: 3- Irc- 1 \L . compliance with the Town of Estes Pat - -N.~--Liz~0-2------ ------22 comments in Mike 136 Wd©-_..-// ..-i*R;i*RE Elkhom Ave. - Mangelsen's memo to Bob g BUErM WS+A rERRACE --[-1 - F Goehring dated April 2 , -------i- .L_--- i si r--- -- 2007. --- , --- .Ck; I '28.00 1 - i m..tx,912!!t,apping.Departmenti mr ' 1 Memo To: Bob Goehring From: Mike Mangelsen Date: 04-02-07 Re: Wiest Plaza (Hupps), 136 West Elkhom Ave. Easement Vacation The Light and Power Department has reviewed the Utility Easement Vacation and Dedication for the above referenced property and has the following comments: 1.) The submittal states that this is a vacation of old overhead easements and dedication of new underground easements. However, the submitted plat fails to show the new underground easements. We need to have the new dedicated easements prior to vacation of the old. 1 4 f 1 -/.-- 2 1 UN 1 1 .1 311 'i: 1 lic , if 1 , 1111- 41 il- 1,1 9 4!f 1 1 11 0 *W lilli . 4 A i L®4 . b 1 - il J Fildli 241117 iii ; ks 1#1 i . 0 4 4!1%:;"4'illi,1111 ! 1-~ i iAN J , ,&, 1//,41 11 1 J 1, \AX §§ 1 A :8 1 113' i' li' 11,illi i' 118. PE .1 , R i " E-F- a §{ 3 11! il ]1 11]illi '~ 1%i k~~i i 11 gh] 1 3 11 #9- 11 7 h. i li q 91!991,1414111 1 4,Al 1 1 3 |j d=1 41 j 41 I . 11!i i; ill,41·i;iii* lili #i : 1112-1 j 4 N 1; ~ | iiI 11 / 1 dii h !11!!:!tii:t i li.: il .1, i ri ' AA il! lilli -1 - 11. 15 1 *34 64*, R 3 r \)-1 u 10 1 6 1 3•¥ 3NMOM . 41 Ll_ 4, 1 € 1 1|i l IL h 1!111 11 1% nIS * «~f & lihi H fi : WA 7 s - Lf 3 1 .Me.g 9 ' i.! \/ 1 lA¥ ]NIVBOW 3 w h b G N.. M af r OW 5-5. 1 9. 0 3 34 21 1 l.0 3 4 4 203 31 1% 3 8 01 1 .....1 W KE'.8, a .50.4..0 S r~ -4·9*·., 0. _I'' 11 , Nii 14·Li,VJ. / > -1 2 4/4 1 4 *i Q: LU , a. 1 1 4-3\.tic* If) ~ 0 0 :4 1 -- L -0- - * 5 11 \ il 4 :1 - , 7 7 k ti ,-0 41 Z k i SE LU F - .,1. ....- 1 . 101 - ./ r .EL·.1 3 .guil N O - N k 3 - A 4 2 1 * al 11 : ; .4,1, -Ut-1 AU„1~--01 -- 90*042# Ull111111lm®IlmIlllINT 0,/ 1 ler. .00- - LOT 35 & 36 91116 REPLAT OF 6, HUPPS ADDITION COUNTY F STATE OF COLORADO 4 TOWN-1Of· ESTES PARI< Community Development Department Memo TO: Public Utilities Committee From: Alison Chilcott, Planner 11 Date: April 13, 2007 Re: Vacation of Electric Utility Easements Lots 1, 2, and 3, CJL Resubdivision 102,106, and 108 East Elkhorn Avenue Background. This is a request by the Estes Park Urban Renewal Authority to vacate aerial power easements located on Lots 1, 2, and 3, CJL Resubdivision of Lots 20 and 21, Block 5, Second Amended Plat of the Town of Estes Park. The easements are shown on the CJL Resubdivision plat. The Estes Park Urban Renewal Authority is removing the overhead lines and burying them underground as part of the river walk project. This application has been reviewed by the Public Works Department, which has stated that these easement vacations should be completed in conjunction with the new underground electric easement dedications. Budget. 1 '.1 7 1 None. I I ! 1 - 1 ' 51 1,*w/ -*et libig.42\ b \ ti \ \ f 2-401>-1.~rk \B \ i *.4 4\\ Action. ¥¥ =Lr,nuttly IV I ---- Lots 1-3 CJL ' i.--* 100*1 1+-j ~ Staff recommends approval -7-1- ---1- , 0 -r--r- -------r--~0,1 1 -1* Resubdivision ,>51 " \\ ~j of this easement vacation ¢ 1 1& g r---- request conditioned on compliance with , /9 44 0.. comments in Mike -i -11-xz*4 1/4-4 ~ 041+~ 4,j'~ :6' 0,~11<$ Mangelsen's memo to Bob IRRACE f - .- Goehring dated April 4,2007. 8 -1=44 1 0 -1/4//h,1 fifil - -0- ,--14 IL#Ul·«_ Bl - 1 { . 1 - Memo To: Bob Goehring From: Mike Mangelsen Date: 04-03-07 .. Re: Wiest Plaza (CJL), CUL Subdivision, 102,106, and 108 E. Eli¢~om Ave The Light and Power Department has reviewed the application for Utility and Right- of-Way Easement Vacation for the above referenced property and has the following & comments: 1.) Our comments are basically the same for this as for Wiest Plaza (Hupps). We feel strongly that the easement vacations should be in conjunction with the new underground easement dedications. 1 I ; A a ,1. au., - 1 1115 1 *I h 3,1 111% I i 02<4 61 i 111 " .1491 V . CN '14 9 5,4 - 1<, 5, 1 :22 J v '91 LiA\~ I 4 31 i 10 1 2 N i b; 5 4 194$ i'/ P i 1. 0 . I~ iii w 13 1 01 /3 •in -OJ il j 5 1% 1 1.11 I J @ d ¢2 - 0 4 4 10 9 4 r. 1,1 4 0 4 0 8 i $4 4 m L 1 r. . 3313 114 , 43/1 9 1 .9 Ng- 8 9 1 1 -41 I. 5 11 1111 :# ii 1;Mil 5 -2 atii M i !11: i m i: 0 . 1 46 d .>3-V- i , W , Slil %%+ i. 1 ., $ i .'11, \ . 1% 3 i-1. 1. . 1 ./ - 7.--- 1. 1 . 4 t.r· 11/1 162 $ 5 3% ~110. --- .... -- -4 .2.14. ./ 94...IN \ \ 1 ./. -O. . I (9) 1% \ 5% * . AFT, . I \ . \ ' ia 1 64800#6#*49'A*kh . 0 1 1. 1 -3;,;A:;~,m9UM/. 3 -inN3Av - ./ 1.;i 11 ; : i 1%?ifi·~- 2 ANAAR*'41%) 3NJVUO '11 :4 ; g 0 2 9 8 02:31:nhil 90. r 4% \ 1%- -4 - .. \ \L ~~~ a~/;4;j 26;/U: a.ji,Qqt'Awal.. •024®®(De" • 1 12 , i 1---- i.1 60 39Vd Sh. JNI9N3 NaOH NVA 39890LS 8I:ZI L006/9Z/80 ELKHORN LOTS 20 AND 24 BLOCK 5 JL RESUBD/ViS/ON SECOND AMENDED PLAT , 10,v OF 47,/ WN OF ESTES PARK 1-141 .......... ArimiTITI 3 11*14 1 1 ¥2Mt.. --- - AVENUE ~0: 1...... VICINfTY MA , 1~JEE:~: c.*//1/1,0. ne .0" . TOWN of ESTES PARK Inter-Office Memorandum April 5,2007 TO: Bob Goehring FROM: Mike Mangelsen »f SUBJECT: Tree Trimming of Overhead Power Lines 2007 (the 2nd yr of a 2 yr contract) Background: The Light and Power Fund, page 328, contains $75,000 for the year 2007 for the purpose of trimming trees that lie in or near the overhead high voltage power lines. This is a continual process which benefits the system through increased reliability and safety. An RFP for this service was sent to (4) contractors in the spring of 2006. Each contractor submitted a bid for 800 hours of work (two-person crew). 1he results are as follows, including an hourly rate for each contractor (bid price divided by 800 hours). Cost/Budget: Cost: 1) Asplundh Tree Expert Year 2006: $58,608 Year 2007: $60,656 Hourly Rate: $75.82 2) Wrights Tree Service Year 2006: $74,056 Year: 2007: $75,280 Hourly Rate: $94.10 3) Foothills Tree Experts Year 2006: $142,400 Year 2007: $148,800 Hourly Rate: $186.00 4) Davey Tree Surgery Company- (NO BID) Budget: Acct # 502-6301-540-2532 $75,000 Action: Staff recommends contracting with "Asplundh Tree Expert" for a total not to exceed $75,000. (989 work hours) MM 1-1 Water Department Inter-Office Memorandum To: Bob Goehring From: Jeff Boles Date: 04/09/2007 Re: 2006 Water Line Project - Waterline Realignment Background: The construction bids were not received in time for Utilities Committee Meeting in December 2006 so the water line replacement project was approved at the Town Board Meeting January 9,2007. It was necessary for this project alignment to obtain 2 waterline easements for construction. Both landowners had previously agreed to the project alignment, granting of easements and were in favor of the project as proposed. The engineers waited until approval before starting the necessary easement paperwork and after the construction bids were approved and awarded one of the landowners decided against signing an easement for the project. Several discussions took place between the engineering firm, the landowner and Town staff but a solution and or compromise could not be reached. The project was then discussed between staff and the design engineer's for realignment to the road and road right-of-way as to not necessitate additional easements. This new alignment will be beneficial for future use and accessibility but will extend the quantities necessary to complete the project. The design engineers discussed the option with EZ Construction who was awarded the bid and they have agreed to maintain the existing unit prices and to the extended quantities. (Attached: New proposed waterline alignment, Construction quantities-pricing and blasting estimate) Budget: 2006 Design Engineering, Construction Management $6,253.00 2007 Design Engineering and Construction Management $2,500.00 Total Design Construction Management $8,753.00 2006 Original bid price: $122,811.00 2007 Additional quantity price: $38,152.00 Total blasting (estimate at 100% of project) $25,950.00 Total Project Construction Price: $186,913.00 2006 - Budget Account: 503-7000-580-35-54, Purchase Order issued ($150,000) for construction bid ' plus contingency of blasting and sewer line crossings. Budget Account: 503-6500-560-22-02, Purchase Order was issued ($6,253) for design and construction Management of the project. 2007 - Budget: Adequate funds are available to cover additional construction charges in the following accounts. Account 503-700-580-35-54 $36,913.00 for additional construction quantities. Account 503-6500-560-22-02 $2,500.00 for additional Design and Construction Management. Recommended Action: Proceed with E-Z Construction for the construction of the 2006 Waterline Project and retain additional funds from the 2007 budget in the amount of $36,913.00 for construction and $2,500.00 for Design and Construction Management. L-1 h - V Of «\\ e 8 0 0 2%* cy- 1, % (D i t, I T Tf' 1 ~ 11 1% m .E .G (D E C ASPEN AVE -2B ' 11 C , , :La L.1 5 .2 --- J E 0 1---------------1--- 1-44«83 -1 i 11 1 1 - 8 1 ~. _4-3 9--4 ~ 1 1 1 - [fii- 1 -4= 1 1 1 1 1 11 1 a i i r- 0!0 1 i 1 1 1 1 _rUL L__. EL - f ~ BIRCH'AVE E -3-j- 1 11/ 1 11 1 F--11'' U %'i - 2 i J //-1 L_L 11 1 '80- , 1.1 1 .8-4 1 L g< OIl //53 - L.. 2 1/ - 13: -¤ ai ( t 3AV 3NI8~In-100 1 %13 9 \» 443 1 1 i ,\ 4inch + FIREHYD Town of Estes Park Water Department u6!ie WIEZ'E~~~~~~ - Aseurloo e se juelupedeCI JeleAA Mied 01 el# Aq pep!Aoid S! dew s!41 ;„UAAOUy ;Seq„ Se S! uo! jel.UJOIU! ewp Jo eejueignO l=ANDERS AVE ~DEROSA DR on existing 4" main oueheAuoo lefiel JOI lou s! d 1 1./1 .1 1 L-/lu/,IL_LI\.LINU rAUtz. 10 2 . a 1 / 0 i¢&*.9 ,(,·*4*i , , 154- vs,·' 1* . *4 LAND SURVE¥* - 4 -- ' - ·'te. , SUBDIVISIONS - -I r- DEVELOPMENT PLANNING IMPROVEMENT PLATS STRUCTURAL ENGINEERING VAN HORN ENORIEERING AND SURVETI}10 SANITARY ENGINEERING MUNICIPAL ENGINEERING t f , April 17, 2007 Jeff Boles, Water Superintendent Town Of Estes Park P.O. Box 1200 Estes Park, CO 80517 Re: Additional Scope of Services for Country Club Waterline Project 06ar Jeff: Thank you again asking Van Hom Engineering & Surveying to provide the scope of service for the waterline relocation/upgrade project through a portion of Country Club Manor Subdivision in Estes Park, Our original estimate for the scope of service desciiptions you provided totaled $6,253.50. We have estjmated the additional cost of engineering design, construction staking and project management to be $2,500. Thib estimate was driven by me approximate onethird additional increase in overall length of the waterline. While much of the original alignment was designed to cut through residenual properties, the new alignment is more road-based and will require more mmgation methods (flow-fill, compaction, and repaving). We enjoy working with the water shop employees and providing the type of services needed. If we have over-estimated the hours required to complete the additional work, please know thatwe will only charge for work actually done. Please let me know if you have questions on any items. Thank you again, and do not hesitate to phone me With quesl /*4 b- / /' Lonni0 She0on < ,," Van Nomtngineering & Surveying V 1043·Fish Creek Road • Estes Park, Colorado 80517 • 970.586„9388 · Fax 970-686-8101 · E.mail: vhe@airbits.comcom . 0 fi 8B J M€ 2 + 888888 888 2222 28888888@8888 0 -- 2%*Egg 48$*38:1|Gi°id®%3;it©SME:do I- to MY-r-0- 07-47'hWetory -u'©-cohale•-1.00. 0' 4%447 9- M 2 N 4 4 O 1.0 9 r e m 0000 009© 88 2188.88888/92%888888%2 nl- ma,1, M w r i s e d N> 0- do; A Ad Lr; 4 4 W H LU 1.- - <00) f.) 0 .... 0> 0 0 01 43 I. CO N N M A 0 03 01 M - p 29 - M . 0 ~ 7'Vt f, ~~;*Lr~417 1•394 *0~6DQO 1/ 1 -- O go P - 10 4- U.1~ 00¢'3™N~·Co ¤~~-,VN¢,1-AN•-Cycer,1050-0,1,7 - r- M N % tij Z LL>- > 61. U. IL 5535*1M1~MM~*5551111 35 & -160.JUJ if b€ 2 2% 11 9 31 ·@ IE C *E= -82 8ff %*5 2~#t #22 €3:E g € 8 8 i 4 3 2.5 E = R g.* 8 2 8 -li - 44 2 2 ~ $ 5 3 .2 % > 1* % L 6. 1 R ~ !5 8 spl=- M#/2/1 e 8 49 222 % 2 20 - 'E N 3*2322 RE 222€ 41 12,2 8 <2 Nk ig, i~ 35%2113 3 eke===6 ENZE~%*~6F EF k 6 & AWLLIW ~~E~&§% 5&%8~fw©§43:11:fA#@22 §~ 5 m :,N>>~EN<$.&963.mm~(~O-00 W <17 D VJ UJ 'LU LL_ 2602033*6640£66--2.-me<WHED 00 Or= m 20 39ed ENIft¢AVOX3 2-3 0*9EELLEBE LE:DI L00Z/9 I/E0 € E. cavating CONTRACT ITEM QUANTI AMOUNT 00'912'ZL 00-Ze ties AS Fled ,,1, lielidsv„17 (310051 „We -0 6wpeAD) mueaAe,~ snoutulnl 00'ZZO't 00'Uo~ 1 NOUVZ11 DO 6»'99J & 39Vd 081¥101828 59 64 00-gs 1 06ed HILL STREET WATERUNE LOOPING PROJECT sfinid PLE@ ale-JOID:) pue guons@uool (Buns!39 01 }O8UU (183HS .1.XaN aBS) ON AND DEMOUTION 18OAA 1¥13 BID SHEET ¥909 .. 8228 88 00 e U 4 1~ 05-~ m< 0000 0000 7444 1- 2Q D /0 Nac'J,v r 3 OQOQ @ i 5 3 E-Z E..cavating »199lk ESTIMATED CONTRACT ITEM UNIT Q HILL STREET WATERUNE LOOPING PROJECT V3HV,gs:J~:.12M , 32 Z 2-4 uofto!149uol 35¥d S[Hl :1 39Vd WOM:I GIE] 191016]nS 83AOANZIVO -1OHLNOD 01=!BVE BID SHEET tus~ EU) UO]lon']su{K) Badger Drilling & Blasting, Co. 1901 Fish Creek Road Estes Park, Colorado 80517 970-586-2091 fax 970-586-5706 March 15, 2007 Agreement for Drilling and Blasting Services Hill Street Waterline Looping Project Test Drilling will be done @ $165.00/hour. Anticipate testing approximately 200 L.F./hour. Areas requiring blasting will be drilled and shot @ $14.00/L.F. pre-blast surveysof structures and vibration monitoring will be done by Matheson Mining Consultants, Inc. pre-blast surveys will cost $300.00/structure. Vibration monitoring will cost $650.00/event. Badger Drilling & Blasting will track and report the quantities of eath pay item and report to Van Horn Engineering for a payment requebt to the owner. Payment will be made in a lump sum at completion of blasting portion of proiect. Traffic control will be provided by others. Signing below constitutes understanding and acknowledgement of this agreement. Saut, 2>**h, 86,· Travis Kitchen Town of Estes Park Badger Drilling & Blasting Co. OWner 4 . d I LL bra€El- V\| AT€12_U N E Leo P//0 4 P€03 acT 0,OST- 657-/ MPfFE Fb€- PIE{ U,/ 6./4 t*~ 6Ljs-r (Al ·~ 7 EsT LFILL//44 4.9, ¢ 40 8. 1 9 6 r 4 , 58 = \41> - j ~ Ch C -- 22 4 +7'rt- U.,7.5'+A. 0 7- A'7621. *u. (03*~24;>ili) -E - ~16,9 ~ Ct ~ f ~k.,9.4 1 01*3 J 51-7 o 4 260 BLAST/m 69 : 7417& ~c,voi-9444/0 =40,960 Ass o M ED It X 4005ws whA '50' 1 9 x boo n &7013 \~ , B e AT i b Al ~ oN 1 7472,4 +4 4 ·* 1-50, 990 . Administration Memo TO: Utilities Committee From: Randy Repola ~. Date: April 16, 2007 Subject: Comprehensive Plan Update Scope of Service Background A current Town Board goal calls for an update of the 1996 Estes Valley Comprehensive Plan. To accomplish this goal, staffhas recommended that two sections of the Plan be updated. Those two sections (Chapter 3 and Appendix One) contain an economic profile of the Town and data on the economic and demographic characteristics of the community. Updates to these two sections will provide the Town with insight on local tends as reflected in the data. In addition, the update will include an estimation of the area population at build-out based upon trends in land use. The population estimate will also be useful in evaluating the capacity ofthe Town's electric and water utilities. Concurrent with the update, staff will provide a progress report on the actions taken since adoption o f the Plan in 1996. The report shall be based upon the steps recommended in chapter 7 of the Plan. The attached draft scope of work outlines the services that will be sought. Budget The 2007 budget contains $20,000 (account #101-1100-411.22-98) for this project. The request for proposals provides the option to exclude part of the project if cost exceeds budget. Action Staff requests approval o f the scope o f work and permission to request proposals from qualified consultants to perform an update of the Estes Valley Comprehensive plan. . I Request For Proposals: Estes Valley Comprehensive Plan Statistical Update The Town of Estes Park is requesting proposals for a statistical update of the Estes Valley Comprehensive Plan. The scope of this work is the update of all out-of-date statistics contained in Chapter Three: Economic Overview and Appendix One: Economic Profiles. The work will also entail a new build-out land use and population projection that is based on the underlying potential of the current zoning as constrained by the provisions of the Estes Valley Development Code. This build-out analysis should be performed in a GIS format that can be delivered to the Town for ongoing in-house maintenance (e.g. Community Viz or similar AreMap based approach). The proposals should provide separate cost and time frame estimates for each of the three elements of the update: Chapter Three, Appendix One, and the Build-out Analysis. Deliverables shall include the integration of this work into the original comp plan document in the form of an addendum to be provided in a digital format that matches the original document. This work will entail meetings with the Town's profe¢tmanager as needed to provide direction, but the work will not entail any publi0*trek~ter visioning process. The Town will provide all existing land use and zgning inforiAI*n at a parcel specific level in a digital shape file format (ArcMap). The TUn,will also provide all other relevant statistics that are generated and maintained by the Town. Acquisition ofrelevant statistics generated and held by third parti~*g r. the responsibility o f the consultant. ent Census and DOLA info) will be ,=h \\ Contact Community Development:Dife¢tor: Bob Joseph at 970-577-3725 -4 % (bioseph@estes.org). Proposals are: 4*the'first week ofJune, 2007 (Town of Estes Park, Community Developme#f*04*0*4200,170 MacGregor Ave, Estes Park, .,4,> Colorado 80517. The Town will consider acceptance of separate proposals for each of the three elements, or alternatively,yhky accept a single-source proposal for all elements. The Town reserves the option to proceed with only one or two of the three elements based on funding constraints. . . MONTHLY PEAK DEMAND 25500 23500 c - - - 21500 D -0- 2005 -*-2006 19500 -0-2007 17500 -- 15500 13500 11500 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES 14,000 jr.·. 12,000 * .,ly / te - - 71 41 10,000 -mi -~I -~ 9 1 w*Efj * :~ ~ 73 £ 41 4. 20% 4% 0~ 0, 0.& ~. 0~ B-; M#. 4.~ 02005 8,000 - ; -3% -41§ *.t 44 4% 41 03 4% 4% ma /. m 2006 >, 0% 0-2 3% pi *2 04 © 0 04 Mi: m 0, *2 O 2007 1% 4 % 03 % 4 0 / f ~0 ft ff %1 ~> i:t L ~f 3% %O 6,000 - , -01 -4 -4,_04 - 04 93 % %$ 41 0 ~ 4% 5 2% 4 1 45 02 0% 44 3 4 pi %; 6% *4 *A 42 * 0, 43 1 411 0: 3# 4, 24 02 %5 6 /: ~ 4,000 - 0% -01 » H 8 E h ji f # t k d 0 53 03 40 42 -¥ 0% 62 04 43 «2 *t 9-1 06 $1 42 1 2,000 4% , -13 , *1 4% '34 , 0 i 4% , 2.4 / 44 , 45 , 4_i , i Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 Monthly MWH SYSTEM KW »**4**22*4*3399* 1 IN*4411'll,W YTD ENERGY PURCHASES 140,000 120,000 - | 100,000 - 0 61% YTD 2007 VS 2006 ; 80,000 -- 1 - I - 1 2005 02006 : 60,000 -% -- - 1 2007 L : 40,000 ff ... 20,000 - n il-ill -1 A 2- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD POWER COST vs. BUDGET ($1,000~ BBUDGET ¤ACTUAL 5,000 4,500 4,000 jr 3,500 ..mel 22 9 ... 3,000 - "M Xk 2 31 2,500 - M m 0% I 15· 52 - 2,000 - 33% 9 1,500 ¥ & 4 M M 4 3% M m V * M 10 1§4 4 ; 1 k 1,000 - FRI 4,1 Rh A 0-4 4% M :33 1381 3§ S * + A :01 ra ..4 2 :.:4 >.4 4.. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 21 6?48*i·. 82878¤*9::> . . 4 ELECTRIC SALES BY MONTH ($1,000) 1,200 1,100 1,000- ---- 900 --- E ~ ---r- T - - 02005 -1 3 1 800 -- 0 - :2 -3 1 ~ T t. #. 82006 I I. 42 4 t; 24 91 it : 700 - -. 02007 24 75 1-4 79 .t . I t. 1 %· il 500 ---~-~ ~i-~i-~~-~1 _3~ 4~_2~ 't :75 1, 2, 1€ ..2 25 43 it@ tzi *2 23 ii 400 --f. c -- 1 4 - 1 { ~-... t.3 1 2* .' *j 91 A .4 14 4/ 300- ~i + *~ , $6 u 1,:2 , >?I I i:f~ , t:yi , Ii , il , ~:; i Fi , Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR TO DATE ELECTRIC SALES ($1,000) 12,000 6.92% 2007 YTD VS 2006 '10,39.,113 10,000 - ' C..0. 2005 8,000 - - -- -. , 9 EZZZ] 2006 7 /$ 1 6,000 - - 02007 . --/-=--- 9 :i - Budget ,% & I 4 > . / It .~. .J 4,000 -1 + ,~ 1..~ ~ 7 E -Al- 0:- :A··, iF 1 9 - 111 12• 4 S r. 1 6 /0 iG im ·'f i ' 't r '· J 4 3 2 .~~ , n. 1 2,000 1-711 -2 f ~> i- ~2 ~tlE- 3 - ti J~I # 29 5 , '>60 1 1%4 3: 7*Vi-·5 't ''4 '' f f ·· L ·,0. 1 1· 9 ~ 26 f, .~ 1 .. 4 f '· i 1 7 0 i :flul ' K.* ' < 1 -20 ' i. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 8 YEAR TO DATE SALES MONTHLY SALES . I 0 % Finance, Light & Power, Water Departments Memo To: Utility Committee Town Administrator Repola From: Steve McFarland, Finance Officer Date: April 13, 2007 Subject: Utility committee report Background Attached the following documents for the Committee's perusal: • Charts and graphs for March 2007 • Final financial statements for February 2007. • Financial statements for March 2007. With the above documents, we should now be caught up through March 2007. Body Light & Power The "charts and graphs" section of the L&P report is full of "green" and looks pretty good. Revenues are quickly approaching the budgeted level. I will forego discussion of the February financials and refer to March. YTD revenues per kWh are up from 2006. Expenses per kWh are also up slightly. Cash has increased $457,000 for the first quarter of 2007 vs. an increase of $360,339 for the first quarter of 2006. Of the $97,000 difference, $79,000 is due to not spending as much in capital in 2007. In that regard, much ofthe increase in cash position is simply a function oftime. When comparing to budget YTD, 25% ofthe year is complete. 28% ofrevenues have come in, while only 22% of anticipated expenditures have been incurred. In short, the year is running closely to 2006, and very much " according to Hoyle" vs. budget. r . Water The "charts and graphs" section of the water data continues to be outstanding. Revenues are already projected to exceed budget by $232,000. Year to date income for 2007 is trailing 2006 by $234,000. However, $190,000 is the result of an annual booking of tap fees in 2006 that was subsequently reversed. Actual water sales for 2007 are ahead of2006. Thought March 2007, expenses are at about 16%, and revenues are at 27% of budget. These percentages are both on the preferred side ofthe 25% ofthe completed calendar year (revenues higher, expenses lower). Conclusion Both utilities look very strong financially. Action steps requested - None. • Page 2 . 4 32 5.2 , 2= 22 ££/1 0 60 O -81 4 =2= MN¢N€N 0*-A A ==mo 232 # 54 2 W Ch *2*0 2 42 6 CO -- @5% §53§% * 000 00000 0 5% 02§§§* § 00 ©©ded d 50 0 e% 0 00 0 40 0 .0 0 0 1% 9% 1 W 0 0 h- %* t O M O R - 0 * b u .= 15 . ri53 3 : 2% 00" 4 £2 4 0 CO 0 . 6- 0= 3 Z U Beginning unrestricted (usable) fund balance 3,720,905 3,195,309 $3,195,309 $3,19 100% %LE 9£8'591 Z99'*L6 L00'0 900'0 (905'8£) 9£8'592 OEE'LZE (69L'9) BLS'18 608'fL ino s.9#suell Butielodo %ZE *8£'t'€5'Z EfL'68£'It 0L0'0 OLO 0 (LL.'99) *8£'t,£5'Z L06'L9*'Z (6ZL'56) 9£5'£96 L08'L98 senupuadxa imol -DATE MONTH TO DATE YEAR TO DATE BUDGET vs. YTD 2006 2006 2007 ofBu #DIV/0! 831,209 906,420 75,211 2,7 565 2,953,734 191,169 0.079 . 10,208,573 2,953,734 49,983 25,328 (24,655) 681 83,805 18,124 83,805 881,192 931,748 50,556 2,8 246 3,037,539 209,293 10,745,592 3,037,539 e of Supply 404,377 428,22 (23,852) 1,312,976 1,362,038 (49,062) 0 37 0.037 4,785,000 1,362,038 Total O&M Expenses 732,53 812,238 (79,703) 2,091,57 2,198,82 (107353) 8,786,013 2,198,828 2 0 0€00£ 00!Alos tqOG OEL'69 LEI 'SE€' I E000 t00 0 Z8Z'6L OZL'69 ZOO'6* I (LSZ'6) OZL'69 £9€09 191!deD 951'£05 (05 1'#9) 918'Ztl 991'£05 6EE'09E (FLI'Ff) (88L' IE) 58€'El (Imideo NOJaq somt'puodxa (6£14) V/N (61/'9:7) (6£ 1 '9*) 0 (16290 (16£'90 0 SONnOS 12410 01 poleOOZIER@A!0001 4580 910'L5* (051»9) LL9'96 910'Lft, 6€£'09£ (+96'18) (6LS'89) 98£'El tpUOUI 101 uo!1!sod qseo u! @Supq) dz£'259'€$ 691'/99.2$ dZE'199'€$ 9ZE'399'€$ eoueleq pury Corqusn) poioulsalun Butpua VAR VAR Per kWh Per kWh stribution and Maintenance 174,933 16 1 7,218 357,172 324,140 33,032 mer Billing and Accounts 519 7 (12,372) 169,401 15 287 17,114 Administration and General 144 (50,697) 252,026 36,363 (108,33 ) COMPARISON Operation and Maintenance Expense 1240 SOnUOAOJ.JO Kouglogop/ss@oxg) 1810:qns ~07HTs· 2006 Revenues Expenditures .. f . liE C gfg 0222-2 2 2 3- 2 --2 €9-01 RED•men O 0 88* O, Rge R 83*20 0 0 O * 3 kig f - N 22:CO g 11 11 M. gaw R = = M-W rn -- % *49 000 2@e dod 0-0 0 ©010© 0 1 00 N neloo.crl. 00 N C, 00 gran 2 §*0 * 0 '4 010- fl ~ ts ~ E Mi S:Rgg© 0 0 N Ir 00 4 c¢ floo t 0 42*B -. E% 4~.al *2-0 0 0-* EME B q W 0 m 4 *8 ~4 6 0 9 88 4 -9 F 2 0 0<Or U 505 5 g Zo w W 0 0 ~ VAR VAR Per kWh Per kWh Budg YTD % %6I 85081 E99'*L6 LOO 0 900 0 (LEL'IE) 852'481 IWER (198'El) IfL'06 6L8'LL %*I 6t,8'OL f' I DL'68£' I I 800 9900 ZSZ'6Z 6~'OLS' I 101'009' I EIO'LL Z96'98L 5L6'£98 MONTH TO DATE YEAR TO DATE BUDGET vs. YTD 230 142,876 1,931,356 2,047,314 115,958 10,2 573 2,047,314 8,786,013 1,386,591 146.*id (091't*9) 886'LB 1 It64*£5 £96'9*£ 919'09Z ILy'LSZ gdz'L (le,!deo mopq samlipuodxo (Ft'£'6) V/N (9£'6) (54£'6) 0 (I 50*t') (190'f) 0 S@OlnOS 10410 01 palwoolle/POA!0001 VSEJ Total Revenues ,044,833 173,603 1,947,054 2,105,790 158,736 10,7 592 2,1058~~3 965'535 (05 14.9) Et,9'8LI 965'5/5 £56'94£ 99§'9*E Ozy'Efz SEL qlUOUI JOJ uo!1!sod tiseo u! oflueto 506'OIL'£$ 651'195,1$ 506'02'5$ 506'OZL'£$ eouuieq puty gqesn) pmuls@/un Sulpu3 Beginning unrestricted (usable) fund balance 3,467,085 3,195,309 $3,195,309 $3,19 467,010 17,760 99 933,809 (25,210) 0.037 0.037 4,785,000 9 0+6'00£ 000*0 0000 0 LEI '8ZE' 1 000'0 f00'0 6EF'88 6£9'88 6£9'88 6£5'88 156,426 25,814 0.007 0.006 EE=ms 80,396 29,4 004 0.003 dministration and General 215,960 (57,640 000 6 .008 1 O&M Expenses 697,557 696,221 1 1,359,041 1,386,59 (27,54 0 =§=r 603 30,727 15,698 58,476 42,778 LIGHT AND POWER FUND ,OW COMPARISON ration and Maintenance Expense 1@AO Sonu,A@ljO KOUO!39@pfspoxa) 1810*Ins I . 0 4 TOWN OF ESTES PARK LIGHT AND POWER TRENDS Type Surnmary Date March-07 12 - month moving average Total % Total % Of Avg Avg Avg # ofaccts KWH Growth Revenues Total Rev % Cum Rev/KWH KWH/Cust Rev/Cust Residential 7.45 1 3,988.649 1.0% $363.348 43% 43% $0.09 12 535 $48.74 Gen Serv Small 1.603 2.090.112 0.8% $187,654 22% 65% $0.0899 1,304 $ 117.04 Gen Sen, Large 92 2.832.253 0.0% $173,864 21% 86% $0.0615 30,642 $1,881.22 Residential Demand 393 723,395 -0.5% $64,784 8% 93% $0,0948 1,852 $165.51 Res Energy / Time of Day 240 408,009 0.0% $25.506 3% 96% $0.0642 1,691 $105.75 Municipal 60 251,901 -0.5% $19,665 2% 99% $0.0781 4,239 $331.01 RMNP - Small Admin 20 64,940 1.3% $2,974 0% 99% $0.0459 3,206 $146.82 RMNP - Large Admin 6 63,499 -0.5% $2.708 0% 99% $0.0429 10,583 $451.26 Wind Power 10l 0 0.0% $2,141 0% 99% N/A N/A N/A Res Basic Energy 18 23.441 3.5% $2,022 0% 100% SO.0869 1,316 $113.28 GSS - Comm]-Energy TOD 13 18,058 -0.5% $1,229 0% 100% $0.0687 1,389 $94.57 GSL -Comml-Time of Day 1 10,825 0.3% $74() 0% 100% $0.0693 0 $0.00 Outdoor Area Lighting 16 0 0.0% $225 0% 100% N/A N/A N/A Res Time of Day 1 1,505 -50.4% $41 0% 100% #DIWO! #DIV/0! #DIV/0! RMNP - Administrative 2 495 0.0% $28 0% 100% N/A N/A N/A 10.017 avg $846,929 100% annual revenues at this pace: $10,163,147 budget: $10,208,573 projected over/under: | ($45,426)| . 4 1 1 ro 1 1 1 1 - 0 r <4 5.=r -, '"Ir i 1 -2-·-L,·L~ <b. 4 1 1 1 11111111 e 00 on non n An n <55 L&P Revenue Progress m Budgeted Revenues luerno le SenueAekl • eoed 0 /2,06 4< 4*ek„41 '' 1 J 0 . :Ekt : **::: i i ETEARRI P ~ M 61--- 4 2%t 315% ER**0% e Woolne 83*3 DO ** 3 54*53 22 1 0 th q N m A 3%223: 1-0 00 relt- 4 4 3% *RES §§§@8§8 €·4 .- eN 0000 00©0000 3§ *RE §§§§%§§ N 000 0000000 52# 25080 00-rn- gf% *sEEK - 8% =3280 -hent- M.M.:%.2 00=== 40=.92 1---COMO RERm o Otheel 22*g *-1-1 §3@ 0 E g <g 2 01 0, r.. 0028 0 000 D5 h €9 1 8- @85 3 2<g i 5% 5 3 8 20 -2 .2 2.~2 M.N am#j *Eao fi -. C U. =00 - U : Z 83 m 137 (137) 110,562 5,962 3 600 146,531 75,962 52% NTH-TO-DATE MONTH TO DATE YEAR TO DATE YEAR TO DATE unrestricted (usable) fund balance 3,467,313 3,297,192 $3,297,192 100° 144,327 158,317 13,990 24,494 0.008 0.008 484,584 902'SE 01*'90£ 0000 100 0 £85'5 gOE'SE 88L'££ £89'5 50/'83 88L'£[ 001AJOS }q@a (£98'*E) V/N £98't,E ([98'K) 0 1 fL'Z (HL'Z) 0 Soomos 10,110 0, poleoolieR@Al@Oal I[SU 3 9L9'L6I (Stl'gs) (51 ifEE) 9L9'L6I 16L'!Zt' 810'DI 1759'LE (+9*'GIl) liluOUJ JOJ uoilisod 4SBO U! 0%uni) 898'*64'ES LtO'Et L'ZS 898'+64'[$ 698'464'£$ eoueleq puiy *clesn) populs@Jun Buipua 9 I ft#'095 26£'835'E 6000 010'0 [9*'t/ fft'095 L06'+09 891'6+ Eoz'Elt ILE'Z9Z somlipuodxa imoi 6£9'ZEZ (941'58§) (En'681) 6£9'ZEZ 16L' IZ+ 69L'Ytl doE'OE (t·9*'911) (183!deo olopq sa~;; ~~~S 884 003'829'Z 8[6'62 .58'88. E6L'815 9 16'6Z LE#'89 1 It['88 I osuodxil ®OUEU@*Imp~[ pUE UOUE.lado imol 47,182 45,896 1,286 101,240 1 541,648 1 61 LEL'SI 180'001 000 0 000 0 (950'1) LEL'8I Z89'Ll (959) £51,9 L65'5 ino sioisuel: 2unwodo +9'*E ZOL'E6* 000'0 100'0 L66'6 8+9'*E 5,9,4£ yZE't'I 024'03 9,9'KE Im!deo VAR VAR Per 18,524 18,524 (84,106) 0.002 Total Revenues 243,508 1,026,698 2,983 63,596 6,708 155,560 1 110'SE Z9t'Z 58L'6! s,uno 60€9II L65'61 I IO'6E 47,603 47, 19,064 CASH FLOW COMPARISON JOAO SOn,IJAO[JO XOU@logop~SS@OX WATER FUND ''' 21 : 2 2 2 22 .23,££%2 £ f 2E ==g!=2 >.m '3 8% .6, O 0 1§ ~00 1 N m O 4 . 0 g 2 2 2. 5 3% E §§ 6% % %%%§§ 00©do 0000 £ 9% §§%§§ dodd 0000000 aTom 0 8% 1%-S- R *202 0 N-MO 9 *g- 2~ 2% 3842-g *100 O 0 ht-wor- 9 21 0©. 922*2 22 =! ~ rei-er, .0 FE° 0 V-1 - Sm E % 0 2 *0 0 16 0 @% 2282 8%5:301 0 0 re*MO .6 er) O t ~ 5%43 =4=-,= = i- 9 Z 0 2 1 it g = 1 9 1 2 .*ZE M·/ € tiN . 2 Ma 0:12 0 - CO<Ol- g I. 1 # i -- al Ul O %El 65'ZI 180'00I 0000 0000 (009) t'85'El 480'1! It KE*'9 5L*'9 ino sle.Jsual i Sunwodo %01 It'Z'Lf£ [6£'815'E 800'0 800*0 (SOL't') 1+Z'Lk 9ES'Zt,E (949'08) 5I9'60Z 696'8ZI sam}!puodxa le,01 NTH-TO-DATE MONTH TO DATE YEAR TO DATE YEAR TO DATE % ofyr> 17% Beginning unrestricted (usable) fund balance 3,297,192 3,297,192 $3,297,192 $3,297,192 100% 152,641 161,397 8,756 326,267 10,503 2,245,572 326,267 Plant Development Tap Fees (11,374) 070 (102,630) ,000 48,070 (5,792) (34,2 ) (237,632) 136,043 27,635 2,1 (558) ¤~ 5~ 19,088 68,033 (48,945) 110,562 75,825 34,737 .003 146,531 75,825 52 34,455 (13,949) 54,058 (8,177) .001 0.001 541,648 62,235 11 Z[ 501'86 95L 1*8 (6fS'ZI) go (LL6'92) 5IE'I9 jougumUl,Epy pue O!,nquis! I LS'IE 610'81£ (1 8'81) 89'39 El 624'0[£ 002'829'2 ' t'OEE 254'Off (654'9L) £96'861 osuodxa @OUEU@ltne;N pue uouendo In BEE'* COL'£6* 000*0 000 0 (BEE't) 8ZE'f (SEr,) 82'D In)!deD tit'ZOE GHTBA (20'5£0 t[Z'Zoz 95Z'LEg (ED'36) (SLOE) 00'99 (le,!deo alopq sam)!puadxo (ZII'ZE) V/N Eli'ZE (ZI VEr) 0 (La'961) L6*'961 0 Soolnos 10410 01 po,EJOIIER@A,00 21 4SEO ZE['OLI (ft]'985) (t[ 1190 EZI'OLI 992'LEG SLO'toi ZE l'OL I Lt0'99 41Uout JOJ uoilisod tiseo u! 012uell O tl £'L94'£$ L+O'ZIL'Z$ tiE'L9*'ES t 1 £'L94'£$ Doupleq pury (@Iqusn) polopisanm Nu!PUEI 0It'90E 000 0 000-0 Om/1 as lq@CI VAR Pe al 1 183,240 0, ) (330,317) 0.020 2 CASH FLOW COMPARISON 1@AO SanU@ANJO KOUNOUOPBSOOX)) le,Olqns WATER FUND Revenues . I .1 TOWN OF ESTES PARK WATER DEPARTMENT TRENDS Type Summary Date March-07 12 - month moving average Total % Total % of % of Avg Avg Avg # of accts Gal Growth Revenues Tot Revs Cum Rev/Gal Gal/Cust Rev/Cust Urban Residential 2,676 13.1 14,801 0.7% $76,722 37% 37% $0.006 4,910 $28.70 Urban Commercial 752 13,670,712 0.5% $52,327 25% 62% $0.004 18,303 $69.95 Rural Residential 1,302 4,721,445 0.3% $53,435 26% 88% $0.012 3,634 $41.08 Rural Commercial 97 1,940.429 0.5% $12.106 6% 94% $0.012 19,452 $122.6I Bulk Water 1,410,204 0.7% $11,895 6% 100% $0.009 avg: $206,485 100% annual revenues at this pace: $2,477,818 budget: $2,245,572 projected over/under: | $232.246 1 , . . 1 , to <22 1 1 42 11 1 / ing '2*.21--1. ~ 161 1 Ill lili - plk-a. 91---'*, 6 1 lili 1 1 <b. I Water Revenue Progress m Budgeted Revenues luenno le senueAaM •