The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2003-02-13't U I Cll i E AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE FEBRUARY 13, 2003 8:00 A.M. Preparation date: 2/7/03 *Revision date ACTION ITEMS LiEht and Power Dent 1. Light and Power 2003,5-Year Financial Plan Request approval of Black & Veatch Scope of Services Water Dept 2. Citizen request for second paid tap on single-family residential lot Request approval 3. Marys Lake Raw Water Pump Project Request approval of General and Subcontractor Costs of Construction - request to proceed REPORTS 1. Financial Report 2. Project Updates Note: The Utilities Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared. '1 . TOWN of ESTES PARK Inter-Office Memorandum February 10, 2003 TO: Utilities Committee f U - FROM: Bill LinnaneL>QUL Jf 0,01,â€¢ a....L SUBJECT: 2003 L&P Department - 5-Year Financial Plan Solicited Scope of Services from Black & Veatch (B&V) Background: John Gallagher, Vice-President of Black & Veatch, has been preparing 5-Year Financial Plans, Water Use Rate Studies and Tap Fee Studies for the Water Department since 1989. The Financial Plans, as well as the other studies, have been valuable tools that have benefited the Water Department A 5-Year Financial Plan would also benefit the management of the L&P Department Therefore, I have requested a Financial Plan Scope of Services from Mr. Gallagher. I have attached a copy of the request letter and the responding B&V Scope and Cost The proposed Financial Plan will help Staff delete future projected deficits and, in turn, increase the projected future years Fund Balance. The proposed Financial Plan will also assist Staff with revenue rate planning and the preparation and management of a 5-Year Capital Improvement Plan (CIP). (Continued on Page 2) Cost/Budget Budget $17,500 502-6501-560-22-98 (other professional services) Cost $ 9,800 Action: Staff requests and recommends approval of the B&V $9,800 Scope of Services. BL/mjs 1-1 1 . Background - Continued./Pom Page 1 As the attached letter of request mentions, the 5-Year Plan will be in a format easily adaptable to an anticipated 2004 Rate Study. The Financial Table formats will be the same as the Water Dept Financial Plan formats, which are very easy to understand and use. A draft of the Final Report will be submitted by August 1, 2003 and presented by B&V at the August 14th Utilities Committee meeting. A 5-Year CIP and future revenue rates will be recommended in this Report. 1-2 f 74* 7 . 1,1 i 1 11 17 Â·iÂ·. 11 qui 91-1 5-13789>191.f,>1;j il lj),â„¢f '~Â· 4' Â·1: i - 4 !~~ ~ ~k~ 1 Â·; 1 Â»Ri ,?-74:-i Jf' &:t .:.4 414* 2 3.P.ly jr ..yfE'i--Â»- ---2,1991Â· 9 40-t , tr /, -'.14Â»'Nitch\- ,-, Â·f.etif#%9%Wl?~~4.f. -130,-\ ~141?teÂ·,171 1 #-1% 2 9,. 9-4.1.. i...131.r Ad.WEAW#:~ IP, g $<9*'7;Â¥1~9:.4 jtiotr;.-1,'rt) itf?ff-t ~~-I I / 1 1 - 5 e, ' 44.5 L.'92574 *.&. ..5..1,0.1 -,2.- 11, '*#ft---- -1.-74,314*44 1-1-14)1; 91flft'. Cit,;44.1.99P**1*6%4Â·c-1 4%Mee /7 - . I ..1. 4. 1- -U/*. ---- CY- JEitpÂ·.Â·,r' Â·:i-vÂ·.'' ?r :* vt *e 1*,â€¢.f-:,pr,Â».Â·'- ..-2.I. ., ;--->,n -, .; ./34.*-*Irwrf--,1~,f~J ~-- ~= -1Â»- - .-9.: * *,0'-Â·'-Â·~',., -Â·'-- r.j~,,2-*'.*-.,+.-64--539~-0 ,Â·~ 1/ 7-41--I".,Ji~jâ‚¬Â«41,2.-3,1*f.*~~ ~~ -3--h\Â·- c~~-Â·c~.~.,Â· --ti ' 545Â·,iL.- -1 - ')5-2 *18:94 % ...fi,#fi6%8*u<FeÂ£14%~61:"*guar$M/i4#1#N~T~~,Ji: piw#A---1- ,;/*-->=-- ' ".tr&'538Â·l' /, /43:411, --41,99: ..'. f j' 2 \ February 7,2003 John Gallagher Black & Veatch 11900 East Cornell Avenue Suite 300 Aurora, CO 80014 Subject: 2003 Light and Power Financial Plan Update Request for Black & Veatch Scope of Services Dear John: As we discussed on the phone, the Light and Power Department has been combined with the Public Works Department under the direction of the Public Works Director position. As you know, Max Kiburz of M.E. Kiburz and Associates, the consultant that prepared the recent Light and Power Rate Study, is planning to retire this year. I am very interested in Black & Veatch assuming the financial consulting responsibilities of the Light and Power Department, similar to the financial responsibilities Black & Veatch has shared with the Water Department for the past 15 years. Therefore, I have enclosed: 1) A copy of the 2003/2004 Light and Power budget 2) The 2002 Light and Power rate study 3) Recent Light and Power Committee minutes and memos associated with the rate adoption process I think it is time to begin the financial consultation transition now. By March 1 st, would you please send me a Scope of Services for a 2003 Light and Power Department Financial Plan update which includes, at a minimum, the following: 1) The plan should be in the same format as the Water Department Financial Plans, I've included a copy of the Water Department Cash Flow Analysis form that I have become very familiar with. 1-3 i : t.:.,3:// 9-Â·/9\./9.4â‚¬Stes net, COM (970) 586-533-1 e RO. BOX 1.200 Â·o '" - -' -. 0 2-:- I- L./ D A../i.AL -1.-T v.,:uf-jR AVENUE -- EIrES 84.RK, CD 80517 : /Ay. (270) 5 8-6.-2.3 16 2) The plan should review the details ofthe recent rate study including: A. The proposed 6% increases for 2003,2004. B. The January 2004 projected Plane River Power Authority wholesale electric rate increase of4%. C. The projected $780,000 and $482,000 deficits in 2003 and 2004, D. The projected fund balances of $1,165,000 and $683,000 in 2003 and 2004. E. The rate study's recommended cash balance of25% gross revenue. 3) The plan should be easily retrofitted into a future 2004 rate study that would result in a Light and Power Department $0 deficit by the end of 2005; as well as a Black & Veatch recommended cash balance. The format of the plan and future rate studies is important to me. As I said earlier, the format should be similar to the Water Department Plan/Rate Study format. It should allow for an easy revision or update every two years (same as Water Department). By using the same format every year staff will become familiar with it and more readily use the plan as a finance tool. In order to help with the mid-year budget process, I will need a final draft report of the Financial Plan by August 1 St for presentation at the August 14~h Utilities Committee meeting. Thank you for your assistance, John. Sincerely, TOWN OF ESTES PARK Public Works Department Bill Linnane Director BL/lb Attachments CC: Rich Widmer Utilities Committee Bob Goehring Richard Matzke Todd Steichen Jeff Boles 1-4 BLACK & VEATC H 11900 East Cornell Avenue Black & Veatch Corporation Suite 300 Aurora, Colorado 80014 USA Tel: (303) 671-4200 Fax: (303 671-4285 February 4,2003 Mr. Bill Linnane Director of Public Works Town ofEstes Park P. O. Box 1200 Estes Park, CO 80517 Dear Mr. Linnane: In response to your January 31,2003 letter request (attached), Black & Veatch (Consultant) is pleased to submit this proposal to develop a financial plan for the electric utility for the Town of Estes Park, Colorado (Owner). The electric utility financial plan will be presented * in a format identical to that developed by Black & Veatch for the water utility financial plan. The plan will be the platform for the eventual electric rate study performed by Black and Veatch: Our proposal includes a scope of services, estimated fee and schedule. SCOPE OF SERVICES The Consultant proposes to perform the tasks below. In preparing our work plan, we have assumed Owner representatives will be available for interviews, data collection, progress meetings, will provide policy direction, and timely review comments on interim reports. Task 1 - Orientation Meeting Meet with Owner representatives at beginning of study to assure mutual understanding of study objectives, establish communication lines, discuss Owner policies affecting study and receive available financial, operating, and statistical data. 1-5 the imagine build companyâ„¢ Page 2 Mr. Bill Linnane January 7,2003 Task 2 -Utilily Billing Analysis Assist Owner representatives in preparation of analysis of electric accounts. The analysis summarizes accounts and demand and energy requirements by customer class for a recent 12-month period. Task 3 - Cash Flows Develop up to four cash flow scenarios for the study period 2003 through 2008. Proposed rate adjustments will be established in a sequential manner to meet operating requirements, Task 4 - Financial Plan Meeting Meet with Owner representatives to discuss preliminary financial plan findings. Alternative financial plan scenarios will be developed at the meeting, as necessary, and the financial plan will be Enalized. Task 5 - Draft Report Provide up to two editions of draft report summarizing study assumptions, procedures, findings, and recommendations. Task 6 -Final Report Upon receipt of Owner's comments on draft report, finalize study report and provide sufficient number of copies to Owner. Task 7 - Study Findings Presentation Attend one Utilities Committee meeting and one Town Board meeting to present study findings. ESTIMATED FEE We will perform the above scope of work for a lump sum of $9,800. This fee will be billed in monthly increments commensurate with the amount of work completed. The final invoice will be sent following completion of the study. This fee assumes that water rate and electric financial plan studies would be performed concurrently. Otherwise, the fee for the electric financial plan study may need to be increased. SUPPLEMENTAL SERVICES The fee estimate does not include services that are supplemental to the basic services proposed in Tasks 1 through 7. Supplemental services include attendance at additional meetings, preparation of entire utility billing analysis, developing more than four cash flow scenarios, providing more than two editions of the draft report, and other additional services. 1-6 .. Page 3 Mr. Bill Linnane January 7,2003 SCHEDULE The***final 5tudy repottÂ· wilf be submitted to* Owner represeittativeity August 1, 2003, The undersigned will present the final report to the Town' s Utilities Committee on August 14; 2003 and to the Town Board on August 26, 2003. We greatly appreciate this opportunity to submit this proposal. Please call me if you have any questions. Ifthis proposal is acceptable to you, please return one executed original agreement. Very truly yours, John A. Gallagher Vice President JAG: alh ACCEPTED BY TOWN OF ESTES PARK, COLORADO Name Title Date 1-7 Table 1-3 Estes Park, Colorado Capital Improvement Program Line Budget Projected Total 1 - -Ng. 2000 2QQ-1 2002 2Â®2 2QfM 2QQi 22Qg=RQQi $$$$$$$ Capital Equipment 1 Station Equipment 2,000 0 0 0 0 0 2,000 2 Safety Equipment 0 1,000 1,000 3,500 3,500 3,500 12,500 3 Furniture and Fixtures 1,000 4,000 1,000 1,000 1,000 1,000 9,000 4 Office Equipment 1,000 500 1,000 500 500 1,000 4,500 5 Data Processing Equipment 3,500 750 750 3,500 750 750 10,000 6 Communication Equipment 7,500 13,400 12,000 12,000 12,000 12,000 68,900 7 Laboratory Equipment 1,800 2,000 2,000 4,000 2,000 2,000 13,800 8 Shop Equipment 9,300 4,800 1,000 1.000 1,000 1,000 18,100 9 Purification Equipment 21,000 4,000 8,000 59,000 32,000 2,000 126,000 10 Tools 1,000 3,000 1,000 1,000 1.000 1,000 8,000 1 11 Building Remodeling 0 19,000 64,000 0 0 0 83,000 12 Distribution Meters 131,000 110,800 105,000 106,000 107,000 108,000 667,800 13 Vehicles 58,500 0 38,000 38,000 40,000 0 174,500 14 Total Capital Equipment 237,600 163,250 234,750 229,500 200,750 132,250 1,198,100 1 Waterline Projects Priority One Projects 15 Fall River 12" Corridor 180,000 0 0 0 0 0 180,000 16 Big Hom 12- 90,000 0 0 0 0 0 1 17 Wonderview 12" 235,000 00000 235,000 18 Fire Hydrants 20,000 20,000 20,000 20,000 20,000 20,000 120,000 19 Beaver Point to Ramshom Village 0 215,000 0000 215,000 20 MacGregor Ave Wesmonderview 0 48,000 0 0 0 0 48,000 21 Stanley Circle 2" 0 256,000 0000 256,C)OC) 1 22 MacGregor Ave East/Wonderview 0 0 217,500 0 0 0 217,500 23 Total Priority One Projects 525,000 539,000 237,500 20,000 20,000 20,000 1,361,500 Priority Two Projects 1 24 Country Club 2" 0 0 120,000 0 0 0 120,000 25 Evergreen 4' 0 0 208,000 0 0 0 208,000 26 Panorama Cirde 0 0 0 220,000 0 0 220,000 27 Devil's Gulch East-Phase One 0 0 0 0 160,000 0 160,000 28 Cummorrah Drive 0 0 0 0 80,000 0 80,000 29 Eagle Cliff 0 0 0 0 200,000 0 200,000 30 Spruce Drive 0 0 0 0 50,000 0 50,000 31 Webb Cottages 0 0 0 0 40,000 0 40,000 32 Hill Streets 0 0 0 0 0 500,000 500,000 33 Old Mocassin Drive 0 0 0 0 0 75,000 75,000 34 Juniper Lane 0 0 0 0 0 75,000 75,000 35 Total Priority Two Projects 0 0 328,000 220,000 530,000 650,000 1,728,000 Water System Master Plan 1 0 36 Backup Raw Water Pump 0 175,000 0 0 0 0 175,000 37 Fall River Tank #2 0 0 0 300,000 0 0 300,000 38 Total Water System Master Plan Projects 0 175,000 0 300,000 0 0 475,000 39 Total Waterline Projects 525,000 714,000 565,500 540,000 550,000 670,000 3,564,500 40 Total Capital Improvements Uninflated 762,600 877,300 800,300 769,500 750,800 802,300 4,762,800 41 Total Infiated Capital Improvement Program 762,600 903,600 849,000 840,900 845,000 930,100 5,131,200 1 1-8 Table 1-1 Estes Park, Colorado Operating Fund Cash Flow Analysis Line Budget Projected 2QQQ 2Â®1 2QQ2 2QQa 2QQQ 29/82 1 Beginning Balance 1,349,500 947,200 630,100 369,600 380,100 409,200 $$$$$$ Revenue Water Sales Revenue 2 Revenue from Existing Rates 1,831,300 1,886,200 1,942,800 2,001,100 2,061,100 2,123,000 Revenue from Indicated Increases Percent Months Increase Effective 3 2000 0.00% 12 0 0 0 0 0 0 4 2001 0.00% 12 0 0 0 0 0 1 5 2002 0.00% 12 0 0 0 0 6 2003 0.00% 12 00 7 2004 7.50% 12 154,600 159,200 8 2005 7.50% 12 171,200 Total Water Sales Revenue 1,831,300 1,886,200 1,942,800 2,001,100 2,215,700 2,453,400 9 10 Fire Protection - Gen Fund 132,200 132,200 132,200 132,200 132,200 132,200 11 Plant Development Tap Fees 180,000 180,000 180,000 180,000 180,000 180,000 12 Interest 45,900 31,500 20,000 15,000 12,700 10,200 1 Miscellaneous Revenue 13 Bulk Sales 12,200 12,200 12,200 12,200 12,200 12,200 14 Bulk Dispenser 4,300 4,300 4,300 4,300 4,300 4,300 15 Material Sales 2.500 2,500 2.500 2,500 2,500 2,500 16 Meter Sales 16,000 16,000 16,000 16,000 16,000 16,000 17 MisdOther 25,600 25,600 25,600 25,600 25,600 25,600 18 Nonoperating Revenue 100 100 100 100 100 100 19 Total Revenue 2,250,100 2,290,600 2,335,700 2,389,000 2,601,300 2,836,500 Revenue Requirements Operation and Maintenance 1 20 Source of Supply 117,000 120,500 124,100 127,800 131,800 135,800 21 Water Treatment 322,200 100,200 103,200 106,300 109,500 112,800 22 Distribution 435,400 448,600 462,200 476,100 490,500 505,300 23 Customer Accounts 102,300 104,700 107,800 111,000 114,300 117,600 24 Administrative & General 606,000 624,300 643,100 662,300 682,200 702,600 1 25 Total Operation and Maintenance 1,582,900 1,398,300 1,440,400 1,483,500 1,528,300 1,574,100 Debt Service 26 Existing 306,900 305,800 306,800 304,100 298,900 308,200 27 Proposed 0 0 0 0 0 0 28 Total Debt Service 306,900 305,800 306,800 304,100 298,900 308,200 29 Capital Improvements 762,600 903,600 849,000 840,900 845,000 930,100 30 Total Revenue Requirements 2,652,400 2,607,700 2,596,200 2,628,500 2,672,200 2,812,400 31 Annual Surplus (Deficit) (402,300) (317,100) (260,500) (239,500) (70.900) 24,100 32 Ending Balance Before Transfers 947,200 630,100 369,600 130,100 309,200 433,300 33 Transfer from (to) Water Rights Fund 0 0 0 250,000 100,000 0 34 Ending Balance After Transfers 947,200 630,100 369,600 380,100 409,200 433,300 35 Desired Balance (90 days of 0&M Expense) 390,000 345,000 355,000 365,000 375,000 390,000 36 Simple Debt Service Coverage 217% 292% 292% 298% 359% 410% 1 1-9 TOWN of ESTES PARK Inter-Office Memorandum January 10, 2003 TO: Utilities Committee EROM: Bill Linnane 4Â»-Cy-5,4 SUBJECT: Citizen Request to Buy a Second Water Tap for Portion of Lot 1, Summervilla Subdivision Background: The Water Department Policy and Procedure Manual allows only one tap per lot This Policy prevents the potential connection of two service lines which could result in a backflow cross connection situation. Mr. John Spooner, owner of the Summervilla lot (see attached Vicinity Map) is asking for a variance of the Policy and be allowed to purchase a second tap for his property. As he explains in his attached letter, he currently owns a water tap that services his home. He would like to build a barn that is separated by approximately 700 feet from his home and existing tap. He requests to be allowed to buy one additional tap to be connected to the existing water main located approximately 40 feetfrom the proposed barn site. This will save him considerable trenching and associated costs. Staff foresees virtually no potential for cross connection situations and categorizes his request as a "hardship" case. Also, Staff can monitor future construction on the site by use of the Town's GIS water maps and associated text layers. CostBudget N/A Action: Staff recommends approval of this "hardship" case request for a second paid tap on this lot BL/mjs 2-1 SUE AND JOHN SPOONER 527 HONDIUS CIRCLE ESTES PARK, CO 80517 Board of Trustees Town of Estes Park 170 MacGregor Ave. Estes Park, CO 80517 RE: Request for a Non-Accommodation Irrigation Tap Portion o f Lot 1, Summervilla Subdivision NE 1/4, of Sec. 35, T5N, R73W, 64 p.M. Sue and I own Lot 1, Summervilla Subdivision (see attached Vicinity Map). This lot has an area o f 7.28 acres and is zoned E-1 under the Estes Valley Development Code. This Zoning will allow the construction of a stable, which has been a dream of ours since we purchased the lot 16 years ago. We constructed our house about 6 years ago and now believe it is time to construct the stable (housing for two to three horses). Our current water supply comes onto the lot from the south. A careful study of locations on the lot for a stable suggest that the best place for it would be in the very northwest corner o f the lot in the vicinity o f Riverside Drive (see attached Site Drawing). Other locations were rejected because ofthe steep rocky slopes, lack of access or impact on adjoining neighbors. One of the planning issues is a water supply to the Stable for horse watering and irrigation requirements for the plantings we intend to put in around the stable. There are four alternatives to supply water. 1. Run an extension from the existing water line on the lot. The distance required would be about 685 feet through very rocky and steep terrain - in some portions o f the route through solid rock outcropping on the surface. A minimum estimate ofthe cost at $20 per foot is $13,700, although I believe it would be much higher because of the blasting required. There would also be a high environmental impact. 2. Run an above ground "summer" line. This would be very difficult to use in the winter, since it would need to be drained each time it is used. 3. Haul water on a regular basis. This would not require too much effort for the horses (5-10 gallons per horse per day), but would certainly preclude our adequately watering any plantings on the site. 2-2 4. Install about 40 feet of line from a new tap. Existing Town water lines are immediately adjacent to the stable site on the west and the north. This would require consideration from the Town since there is an existing residential tap serving the lot. We thus are requesting your permission for the installation of a new irrigation tap to serve this stable. We would be agreeable to the following conditions which you might want to impose. 1. There would never be any cross-connection between this line and other lines on the lot. 2. The line would be abandoned if it should ever cease to be used on a regular basis. 3. If Lot 1 should ever be subdivided, thus creating a separate lot served by this tap, the tap would be converted to a residential tap with the appropriate extra fees paid to bring it into compliance with the then existing Town water fee structure. Sue and IÂ· appreciate your consideration of this request. Sincerely yours, v John A. Spooner, P.E. 2-3 D-Z C IZ â‚¬ Z 199 1 1 t:%. <C l 4%*/ 1 w. 1 WEd . %>D \\ 0-EU) /L -- 1 -1Â« 92=4==â‚¬ i 1 5 12 6I Z9 OW II 1 \ 4 0 m 5 i a- 2 1 W 1 LLI 05 1~ 1 - /ass w wd I P O 1 "m M 0 -* I Ovoy Al] 1 3 dvM ALINIDIA 3-IVDS ON JZ:1 - ~ -~~--36 99 9-g b - gl - 0 h %20 ' r 1/ ,--/ ./. 4~ 1 1'11-1 0-1$,314~0--z- X.:\\1 r. -1 \\ t: 31-li ; A i A it 1 \1Â·H tÂ·/23- Â·if 4 t. i j w,2,7//2,/ 1 ' --- - :. 44<LLMI /1 192Â«4.~-Y-, " h \ \.h\ \ 4:./ 1, 1 t '- f - ) f/-11 f'.f- 7 14%11 f),/(4~23<ELÂ·>t lil:+1 1 41*ja) ..1)\11 1 1 1, f / \ f thÂ»\ 44\14<#4 t*N~l\*.i\\ 44Â« , \4<*Mk#---i <-r,*3 16r..aff.~ 11(( f Â«2 ...../ft'/1 ... .... \ I I r // / 1 , 1' / \ .1.~Â·. } 4Â· I Z.r/fl 4 Xekk?323:%Â©Sh.X ' 0 *iffÂ·Â¢%14\Al VI -Cli i# 04'--1/3â€ž ,{{C~<icil, t':.#,6+1/' 1 \'// 1-'St-// f.//fi i't //116-r 'i / It Il 1 i *6 44, I 1 ulk:A u 1 4 . 1, ~ \~__~1 4.1/ :i , r. 3 'EL i..}ti.'lilli 40 ,, i - \ - t : \9\ + ./.. ,, ,~~ . ~ al' .7 1; N,j,; 1 Â£ 4 / % 1 U ' I.~ 11, mÂ».4..- . -1/ ' , 1.. . lEA 1 ; 1 . #t 44 44 , . /\*.j j i , Illt i 1 14 ,1Â·i j / 1.9 , / -: 00,449 '1 , 11# ' t I\\ . 1 '' 4 - \1*\*ril,Irr' \ 444*f#~1)866:~~-341.Frfilhbk>*iÂ» 4, . ,9,.4:L:16 . ~~ Â« u~T 3 \ \ \\ r, ' it 1 %Â· 'Â·. IMU % 1 . I - 7/f."f//0 -j sÂ«-i<42#224132% , \t~ xuxi-Â», $ lt' 1 - ' * T N \\ ./ Ay,Â©,1 Â»%604 496.*---- \ I % \ . k 11 Â«I S + i ./- -1 \\F \ i \ 1414 \ -11Â»04 1 . 1 - ---- ; I I - <- -I.-/ / - -* + sâ‚¬H, 1 44 Â»nt:Al r.. \ 9Arib# 0 , 6 \.1- .L j , S?- 3 . . J h:\ 44 4. . - ... .er. -;- - :*-Â·<-X n-Â·.rl'-3-& -< i<zzi- -TLT- 7,21 1 - 444 . % ./\ -\ $./ . - I 1 . - N C\% ~ .af - \~= V .k- 0 /%34* 1 x $. I I C.,- ,â‚¬42/K - .H\\ 2 \ ,\ \9Â¢ 7 /~~ \ , . I j r 1-1, \- It> :: 0~ li) 13~<26~ \2>1 . *x.4.- \44 - \X , \ \4 1 Wk \\ // \ // 4 '. y \ V... 1 I h fc.Z<- <Wi-C dif \ \ 4, \ 1, 1 , I I 1/ t , \PIX'.I , I \ i -,1 7 \ 31 1.- \ 4 \lf- , r \ -4/ , : '1 \ . Â· 1 :#i.'J -- .* i .f' Â· -X-\ h\\ \\.. '.~...\ N\.. . 1 J : . .':.** #..- 1? 1,1. j h i 1 1 ../ , \-1-- +1 1 1 t.fl ' li ~ .1 .9 - .It N :;. 1 . '1\ \\.,4.%.\ 25( 1--4 f Li L 11.-Â»~ ,fl\\ 0 -Â·,1, ' TOWN of ESTES PARK Inter-Office Memorandum January 11, 2003 TO: Utilities Committee EROM: Bill Linnane (luR_ 09 1#-2 SUBJECT: Marys Lake Raw Water Pump Project Approval Request of Cornerstone Engineering Cost Proposal of $706,150 with Cornerstone Acting as General Contractor Background: Please refer to the attached sketches of the proposed project The project consists of: â€¢ A 30-foot deep, 12-foot diameter pump station located at the west bank of the Lake. ( Item #1 on the attached sketch) â€¢ 2 - 88-horsepower submersible pumps capable of 1,400 gpm (Item #1 on the attached sketch) â€¢ 320% 24 -inch diameter reinforced concrete pipe (RCP). It will be constructed to provide gravity flow and will result in a 30-foot deep trench along the proposed alignment (Item #2) â€¢ 1200 L.F. 12" D.I.P. connections from the pump station to the Marys Lake Plant existing raw water inlet pipe. (Item #'s 3 & 4) â€¢ Miscellaneous electric and SCADA control components necessary for remote operation of the pumps. Data from the Plant will be used to control the pump system. (Item #5) (Continued on Page 2) Cost/Budget 2003 Cost- $706,150 - refer to the attached General and Subcontractor/Cost Breakdown 2003 Budget- $180,000 Action: Staff requests approval of the $706,150 proposal from Cornerstone Engineering with Cornerstone acting as the General Contractor. 3-1 Background - (Continued.hom Page 1) The project will allow the Plant to generate potable water during periods when the CBT Tunnelis shut down for maintenance. This occurs occasionally (2-3 times) throughout the year. Also, the project will be very important to ensure a dependable water supply during drought years when the remote possibility exists that the Tunnel may become dry due to the lack of water in the CBT reservoir system located west of the divide. Since the Bureau of Reclamation had not been able to submit their preliminary review comments prior to the Town's 2002 Budget process, Cornerstone used a preliminary concept and design for our budget estimate. As a result $180,000 was submitted for the 2002 Budget The estimate is substantially lower than the proposed costs described in the next section. The review process resulted in rescheduling the project to 2003. The Bureau has been very accommodating and will drain the Lake the last two weeks of March so that we can construct the pump station and pipe. Construction will need to begin by the middle of February to accommodate this"March Lake drawdown window". In order to expedite the project it is recommended that Cornerstone be the General Contractor. They have solicited prices from contractors for all aspects of this project and the Cornerstone Cost proposal of $706,150 includes design/construction management fees, general contractor fees, construction sub-contractor costs, and all pump, electrical and SCADA material costs. The attached 2003 Capital Project Costs/Budget spread sheet shows that most of the 2003 Capital projects will be postponed in order to fund this project All of these postponed projects can wait to be re-budgeted and constructed in 2004. The spread sheet shows that proposed Year-To-Date Costs of $749,332 cim be funded by the $916,500 approved Capital/Engineering Budget Staff will keep continuous review of the Capital Costs shown on this sheet Any change orders will be presented to this Committee. BL/mjs Attachments 3-2 CORNERSTONE (9'70) 586-2458 437 South St. Vrain Estes Park, CO 80517 Fax (970) 586-2459 ENGINEERING & ~ SURVEYING, INC. E-mail: ces@charter.net February 10, 2003 Mr. Bill Linnane Director of Public Works Town of Estes Park P.O. Box 1200 Estes Park, CO 80517 RE: Mary's Lake Raw Water Pump Station Dear Bill: Cornerstone Engineering and Surveying, Inc. (CES) would like to thank you for the opportunity to submit the following cost proposal for the construction of the Mary's Lake Raw Water Pump Station: Project Overview The construction of the Mary's Lake Raw Water Pump Station would be per CES plans as approved by the Town of Estes Park. The major components included in the work are as follows: Â· 30 feet deep, 12 foot diameter wetwell set 22 feet below Mary's Lake high water elevation â€¢ 320 feet of 24 inch reinforced concrete pipe from the wetwell out into Mary's Lake â€¢ 1200 feet of 12 inch ductile iron pipe from the wetwell up to the Mary's Lake Water Treatment Plant 2,88 horsepower submersible pumps capable of 1400 gallons/minute with piping and configuration expandable to 2100 gallons/minute â€¢ Electric and control components including SCADA components for operation of the pump system Work also includes excavation, blasting, electrical power and assembly of the system 3-3 Page 2 Bill Linnane Mary's Lake Raw Water Pump Station February 10, 2003 A Special Use permit from the U.S. Bureau of Reclamation, Department of Interior (BOR) for the construction and operation of a wetwell and pipeline was approved and submitted to the Town of Estes Park, dated January 30,2003. The proposed work was tentatively scheduled for the spring of 2003. Finalization of the design was contingent on the BOR comments and approval of the proposed design. Upon approval from the BOR, the town was notified that Mary's Lake would be lowered to an elevation below 8018 feet (approximately 22 feet). The lake elevation of 8018 feet would be maintained for approximately two weeks. Construction of the wetwell and the raw water intake line can only be performed when the lake elevation is below 8018 feet. With an end of January Notice of Approval from the BOR, only two months were allowed for finalizing the plans, bidding the project and ordering materials prior to beginning construction. Items required for construction of the wetwell have a six to twelve week lead time for ordering. Critical items for construction are the inlet pipe, wetwell vault, slide gate and submersible pumps. During the final design process CES has been working with the individual product distributors in order to produce item specifications. With the specific items CES has also acquired bids from the suppliers. Construction The limited time frame prior to construction does not allow for bidding of the project. CES is requesting approval to perform as a general contractor for the construction of the project. CES has solicited bids from various material suppliers and subcontractors to develop a bid for the construction of the project. CES contractor fees are a 10% above construction cost. Attached is a breakdown of cost along with a list of subcontractors and material suppliers and a proposed schedule. CES's bid as a General Contractor for the construction of the Mary's Lake Raw Water Pump Station is $663,560.00. 3-4 Page 3 Bill Linnane Mary's Lake Raw Water Pump Station February 10, 2003 Project Funding CES Bid for construction $ 663,560.00 10% Contingency: A 10% contingency is recommended due to the limited construction time, unforseen obstacles which may be exposed below the lake surface, strict environmental and operational constraints imposed by the BOR. $ 66.356.00 Total Construction Budget $ 729,916.00 $ 59,100 was approved by the Town in November 2002 for final design ($ 35,400) and construction related engineering ($ 23,700). With CES performing as General Contractor, the construction related engineering is included in the CES bid for construction. Therefore, the $ 23,700 construction related engineering services can be utilized for the budget -$ 23.700.00 Total recommended funding for the 2003 construction of the Mary's Lake Raw Water Pump Station $ 706,216.00 If you have any questions, please do not hesitate to contact me. Sincerely, Cornerstone Ungineerine &_SuAeyingpinc> Michael SrTodil, P.E. Prin~*af ) /7 / )23* ProcK*gld, P.E. 4?rincipal 3-5 BID SUMMARY MARY'S LAKE RAW WATER PUMP STATION DIVISION COST DIVISION 1 - GENERAL CONDITIONS $32,764.00 DIVISION 2 - SITEWORK $347,355.00 DIVISION 3 - CONCRETE $66,540.00 DIVISION 4 - MASONRY $0.00 DIVISION 5 - METALS $0.00 DIVISION 6 - WOODS AND PLASTICS $0.00 DIVISION 7 - THERMAL AND MOISTURE PROTECTION $0.00 DIVISION 8 - DOORS AND WINDOWS $0.00 DIVISION 9 - FINISHES $0.00 DIVISION 10 - SPECIALTIES $0.00 DIVISION 11 - EQUIPMENT $75,363.00 DIVISION 12 - FURNISHINGS $0.00 DIVISION 13 - SPECIAL CONSTRUCTION None DIVISION 14 - CONVEYING SYSTEMS None DIVISION 15 - MECHANICAL $35,413.00 DIVISION 16 - ELECTRICAL $45,800.00 CONSTRUCTION COST $603,235.00 MARGIN @ 10% <Ge*.Con*raa-or 611.1, C.001& + CoAfrrJer, 0,1 irEE~ $60,325.00 TOTAL BID COST $663,560.00 3-6 . Schedule February 13, 2003 to March 23,2003: Immediately following verbal approval from the Utility Committee, CES would begin ordering materials and scheduling subcontractors March 24,2003 to April 13, 2003: Construction of the wetwell and raw water inlet pipe April 14, 2003 to May 16, 2003: Installation of wetwell pumps, electrical, SCADA System and 12" DIP supply line up to the Mary's Lake Water Treatment Plant May 17, 2003 to May 23, 2003: Demobilization, clean-up and revegetation 3-7 Mary's Lake Raw Water Pump System Cornerstone Engineering & Surveying, Inc. List of Subcontractors Sitework Kearney & Son's Excavating Inc. P.O. Box 3623 Estes Park, CO 80517 Blasting Yenter Companies 20300 West Highway 72 Arvada, CO 80007 Electrical Erie Electric 5363 Buffalo Road Erie, CO 80516 Town of Estes Park - Light and Power Mechanical Benson Construction 256 Foxtail Circle Golden, CO 80403 Crane Schmeeckle Bros. or Aspen Rock SCADA Integrated Telecommunication Systems 2775 Algonquin Road, Suite 330 Rolling Meadows, IL 60008 3-8 Mary's Lake Raw Water Pump System Cornerstone Engineering & Surveying, Inc. Material Suppliers Carder Concrete McLemore Pump Hydro Gate Water Work Sales 3-9 Mary's Lake Raw Water Pump System Cornerstone Engineering & Surveying, Inc. List of Subcontractors Sitework Kearney & Son's Excavating Inc. P.O. Box 3623 Estes Park, CO 80517 Blasting Yenter Companies 20300 West Highway 72 Arvada, CO 80007 Electrical Erie Electric 5363 Buffalo Road Erie, CO 80516 Town of Estes Park - Light and Power Mechanical Benson Construction 256 Foxtail Circle Golden, CO 80403 Crane Schmeeckle Bros. or Aspen Rock SCADA Integrated Telecommunication Systems 2775 Algonquin Road, Suite 330 Rolling Meadows, IL 60008 3-10 Mary's Lake Raw Water Pump System Cornerstone Engineering & Surveying, Inc. Material Suppliers Carder Concrete McLemore Pump Hydro Gate Water Work Sales 3-11 0 4'W 0 00 1 00 1.2 1 6 t i U 1 3 :f) fyi O WZ W 0. 3 %3 551/ZE'lilis#, IZE @* i 9 3 m -9 ~ 19" 6 Z %* V. 60 2 I Aw 2<0! ms 6 id u.qj 9 1 5 00/ m:5 ea= M %423,6/ w . Z -1 Pb:4625953%% GE 1\ e i IZE nom DOolgam 92 / > f-+ S J eme ~2 14%%h a z22 M2 1.41 4- J 39% , %Â§3 51Â§0 4igE 1 ecu- 4800 . dll. 1 *4 3 Tr; Es * a.j~Â°7Â©~t ~ r.1 %illÂ¢ r, / CD , /2 14/ b \ g'21. 46 / 00(ngzQT A. J ZLL M =32.Z# P -v 3,/ % 5] O + &0Idwi i \ IllillI j -/ - 13 4*WJOI Z r 4%2Â°FA j M /3. ':43 6 g E LL; .3 Â¥f#Gilk f )-71 4 C /I r -- 52 4 < c E EC) 1 / w( 2 f Z u) B E- 8**9 0 1 $â€¢ O Em= 2 -/f 9 , 2 /<5ED, -=~S=~~Z~~~ a,-7.- ~ ~ a. w J ~2 z - Zia.2 Z Â« %> 6 - a--2 -29Ef 2 '2 oE -Ii-- --- -- 2-0 - - 2 *<- -4lt= m = 3: *3 z == A 7+00_, M A D #19====1 4/ S 0 1 2,59 2 - -**7- a \ e 0 j ,)220 f - 1 5 -------- 2657 <C Â· -53 7 - - 9%00 -40; E= -G/ fEw -'1**W / 7- f - IMM/9*N .:0 < --i--- . ./ 0 4%< -e- 1:42 6 M.W SG E ~, 4% f L-r--- :7% 5,7 1 -----M*-- - U -* -4 0 .t----zz,v .-4- 1 / â„¢m.X , . -I I &8. - . Â·_â‚¬'OK . Ekyfl , -: ..c z.4 9= 29 eme ~/ WR '90- i - AVM3Alb10 OWERED GATE NOI1V1S dAnd 3>IV-1 5 ME!Â¥d S31S3 fo-go-zo alval ~ or 48 NMÂ¥210 9NllSIX Olhl10313 . 1IrI0NO~ 9 k g I 9 3 411 E 2w Al 01 P 3wif 0 4 MES r 5 36 I LL f ,,.r r . HIGH 4TER ELEVATION MARY'S LAKE ,028- d33 .1,2 NOI].ViS dIAInd 3>IV-I S,ANVW 31I30@d 13300Nd 3-lill 10]rONd 31111 133HS 1N]nO 1==f=oz=u.cussn=zwp 1200' SOdO@d KlÂ¥331 831VM ~'0 ~ dAnd WATER TREATM .1 . 2003 WATER SYSTEM CAPITAL RELATED PROJECTS YTD COSTS VERSUS BUDGET 1.)Water System/Capital (503-7000-580-35-54) Budget CosUPO Comments Budaeted Proiects Marys Lake Pump Project 180,000 706,150 2/13/03 uc C.0 Fall River Tank 500,000 postponed C.O. Meadow Lane Water Line 50,000 postponed C.O. Non-budgeted Proiects 2002 Loop C.O. 0 6,192 1/16/03 pwc Sub-total 730,000 712,342 2.)Enqineering (503-6500-560-22-02) Budaeted Proiects Fin. Plan/Rate Study 25,000 25,000 1/16/03 pwc C.O. Plant Expansion Master Plan 20,000 postponed C.O. Fall River TanldLine D/CM 116,500 postponed C.O. Marys Lake Pump D/C.M.(2002) 25,000 0 C.O. Non-budgeted Proiects Storm Water Discharge Report 0 11,990 1/16/03 pwc C.O. Sub-total 186,500 36,990 Total 916,500 749,332 3-14 Light & Power Fund December 31, 2002 Year end Financial Statement Estimated Income statement Difference FYE2002 2002 2002 Beginning Fund Balance $4,806,620 $4,806,620 evenues Charges for Services $ 7,462,498 $ 7,556,952 $ 94,454 Other 345,423 418,233 $ 72,810 otal Revenues $ 7,807,921 $ 7,975,185 $ 167,264 Expenditures Source of Supply $ 4,077,465 $ 4,032,642 $ (44,823) istribution 1,341,987 1,365,848 $ 23,861 Customer Accounts 629,068 551,084 $ (77,984) dministration/General 1,252,505 1,145,644 $ (106,861) terest 6,000 6,919 $ 919 Transfers 741,173 741,173 $ - ebt 301,735 301,735 $ - Total Current Expenses $ 8,349,933 $ 8,145,045 $ (204,888) Capital 2,323,701 1,631,778 $ (691,923) Total Expenditures $ 10,673,634 $ 9,776,823 $ (896,811) Increase (decrease) in Fund Balance ~ $ (2,865,713) $ (1,801,638) $ 1,064,075 Carryover 420,580 Increase (decrease) in $ (2,865,713) $ (2222,218) $ 643,495 Fund Balance inc carryover Ending Fund Balance inc carryover $2,584,402 3 Light & Power Fund Financial Statement For Months Ending January 31, 2003 & 2002 Year-To-Date (See Notes 1, 2) (See Notes 3,4) (See Note 5) 2003 2002 2003 Difference Budget YTD Yn) Beginning Fund Balance $ 3,004,982 $ 4,806,620 $ 3,004,982 Revenues Charges for Services $ 8,110,192 $ 752,539 $ 750,966 $ (1,573) Other 287,000 10,357 $ 4,867 $ (5,490) Total Revenues $ 8,397,192 $ 762,896 $ 755,833 $ (7,063) Expenditures Source of Supply $ 4,219,944 $ 389,365 $ 344,976 $ (44,389) Distribution 1,153,430 81,985 $ 101,083 $ 19,098 Custonier Accounts 707,465 62,662 $ 84,615 $ 21,953 Administration/General 1,187,438 98,531 $ 48,914 $ (49,617) Interest 735 $ 237 $ (498) Transfers 819,330 62,433 $ 70,538 $ 8,105 Debt 299,000 - $ -$- Total Current Expenses $ 8,386,607 $ 695,711 $ 650,363 $ (45,348) Capital 1,212,600 94,948 $ 3,577 $ (91,371) Total Expenditures $ 9,599,207 $ 790,659 $ 653,940 $ (136,719) Increase (decrease) in Fund Balance $ (1,202,015) $ (27,763) $ 101,893 $ 129,656 Ending Fund Balance $ 1,802,967 $ 4,778,857 $ 3,106,875 Notes: 1) The beginning 2003 fund balance of $3,004,982 represents the actual beginning fund balance prior to the "official" books close-out. 2) The beginning 2003 fund balance and the 2003 budget expenditures have been increased by the 2002 encumbrances carry-over. 3.) The 2002 transfer expense has been corrected by removing the EPURA loan 4.) The 2002 source of supply adjusted to reflect purchased power monthly bill 5.) The 2003 ytd transfer is an estimate 4 Light & Power Fund Actual YTD vs. Budget Comparison For Months Ending January 31, 2003 & 2002 Year-To-Date 2003 YTD 2003 2003 YTD Expense+ %Budget Budget Expense Encumbrance Spent Revenues Charges for Services $ 8,110,192 $ 750,966 0.00% Other 287,000 4,867 0.00% Total Revenues $ 8,397,192 $ 755,833 $ - 0.00% Expenditures Source of Supply $ 4,219,944 $ 344,976 0.00% Distribution 1,153,430 101,083 0.00% Customer Accounts 707,465 84,615 0.00% Administration/Geiteral 1,187,438 48,914 0.00% Interest - 237 #DIV/0 ! Transfers 819,330 70,538 0.00% Debt 299,000 - 0.00% Total Current Expenses $ 8,386,607 $ 650,363 $ - 0.00% Capital 1,212,600 3,577 0.00% Total Expenditures $ 9,599207 $ 653,940 $ - 0.00% 5 JIll ..1 . WATER FUND 2002 YEAR END CASH FLOW ANALYSIS BUDGET VS ACTUAL (Note: 1) Adj. Budget Actual Estimated Expend + Enc. Difference 2002 2002 2002 Beginning Fund Balance $ 5,154,697 $ 5,154,697 Revenues Charges for Services $ 2,576,881 $ 3,003,027 $ 426,146 Otlier 112,532 151,072 $ 38,540 Total Revenues $ 2,689,413 $ 3,154,099 $ 464,686 Expenditures Source of Supply $ 2,356,855 $ 2,348,334 $ (8,521) Distribution 342,111 488,613 $ 146,502 Customer Accounts 371,918 318,947 $ (52,971) Administration/General 118,742 104,341 $ (14,401) Interest 599,359 656,230 $ 56,871 Transfers 306,772 306,772 $ - Debt 4,750 5,000 $ 250 Total Current Expenses $ 4,100,507 $ 4,228,237 $ 127,730 Capital 1,420,794 1,416,623 $ (4,171) Total Expenditures $ 5,521,301 $ 5,644,860 $ 123,559 Increase (decrease) in Fund Balance $ (2,831,888) $ (2,490,761) $ 341,127 Increase (decrease) in $ (2,831,888) $ (2,490,761) $ 341,127 Fund Balance(inc carryover) ||Ending Fund Balance (Note 2) $ 2,322,809 $ 2,663,936 $ 341,127 Note 1: The figures in this column include $472,867 Encumbrances charged against 2002, prior to any carryover Note 2: $472,867 of encrumbrances against 2002 have been deducted from the Actual Ending Fund Balance A ' I . WATER FUND JANUARY 2002 VS JANUARY 2003 Year-To-Date Cash Flow Comparison 2003 2002 2003 Difference Budget YTD YTI) Revenues Charges for Services $ 2,688,040 $ 222,467 $ 234,444 $ 11,977 Other 100,013 8,795 8,030 (765) Total Revenues $ 2,788,053 $ 231,262 $ 242,474 $ 11,212 Expenditures Source of Supply $ 125,000 $ 11,521 $ 2,243 $ (9,278) Distribution 561,408 25,337 41,074 15,737 Customer Accounts 143,686 6,904 8,970 2,066 Purification 398,351 14,092 30,388 16,296 Administration/General 782,075 43,930 55,107 11,177 Transfers 304,176 - - Debt 9,500 - . Total Current Expenses $ 2,324,196 $ 101,784 $ 137,782 $ 35,998 Capital 1,374,135 218,315 $ - $ (218,315) Total Expenditures $ 3,698,331 $ 320,099 $ 137,782 $ (182,317) Increase (decrease) in Fund Balance $ (910,278) $ (88,837) $ 104,692 $ 193,529 L WATER FUND JAN. 2003 YID % OF BUDGET SPENT COMPARISON WITH % YEAR COMPLETED 2003 YTD Rev. or 2003 2003 Y'ID 2003 YTD Expend.+ Â°/oBudget %Year Budget Expense Encumbrance Encumbrance Spent Spent Revenues Charges for Services $ 2,688,040 $ 234,444 $ 234,444 8.72% 8% Utlier 100,013 8,030 8,030 8.03% 8% Total Revenues $ 2,788,053 $ 242,474 $ 242,474 8.70% 8% Expenditures Source of Supply $ 125,000 $ 2,243 $ 2,243 1.79% 8% Distribution 561,408 41,074 41,074 7.32% 8% C ustonier Accounts 143,686 8,970 8,970 6.24% 8% Administration/General 398,351 30,388 30,388 7.63% 8% Iriterest 782,075 55,107 55,107 7.05% 8% Transfers , 304,176 - 0 0,00% 8% Debt $ 9,500 $ - 0 0,00% 8% Total Current Expenses $ 2,324,196 $ 137,782 $ - $ 137,782 5.93% 8% Capital 1,212,600 3,577 0.00% 8% Total Expenditures $ 3,536,796 $ 141,359 $ -$ 137,782 3.90% 8% 4, 2003 Light and Power Fund Budget Administration, Engineering, Capital Expenses Budget vs. YTD Costs 2003 YTD Budget Costs Comments Administration Calibration of test boards 3,000 Tree trimming contract (cut from $165K in 2002) 0 Repaint Traffic Signal 12,000 Building/Facility maintenance Garage -exhaust system* 18,000 Chip Seal Parking Lot 615 Elm* 15,000 Pave Parking Lot 640 Elm* 11,000 Christmas Decoration Contract & Supplies 57,750 Repair Buell Porter Scenes 10,000 Meter Software 2,000 Software & Licenses 7,500 Replace PC** 3,500 New Laptop (Line)** 3,800 Replace Engineering Color Printer 3,000 Communication equipment Mobile radios (3/year) 3,600 Portable radios (3/year) 2,325 Vehicle chargers (3/year) 1,155 Professional Services Engineering 12,000 Professional Services Other 17,500 9,800 B+V Financial Plan 2/13/03 Utility Comm Subtotal 183,130 9,800 Caoital Fall River Picnic Shelter 7,500 Web Server*** 25,000 Network Server *** 17,500 Network Equipment (Cables, Routers, Switches) *** 25,000 Single phase RF ERT replacements (400) 32,000 Single phase RF ERT new (352) 28,100 KW/TOU meters (192) 72,000 Specialty meters 5,000 CCU ERT Concentrator (6) 6,900 15 kV PTs 3,600 15 kV CTs 6,000 Line Stringing Equipment 5,000 Portable Hydraulic Crimper 5,000 Grounds, Insulated Jumpers 6,000 Replace Backhoe* 80,000 Jackhammer Attachment* 25,000 Replace Polaris 6W ATV* 12,000 Replace Jeep Wrangler #34* 22,000 Capital Infrastructure Street lights 62,500 Poles/towers/fixtures 16,000 Overhead line improvements 32,000 Conductor Upgrade Program 50,000 Hwy 36-Community Dr. to Fourth St. Street Light Feed 30,000 MacGregor Ranch underground (1/3)* 34,000 Subtotal 608,100 0 Total 791,230 9,800 el ET: 1 1 1 1 11 0.31 1 1 1 1 oil 1 1 '11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 It 1 1 1 1 1 11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 /1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 e m e 5 UJ - E. 0 g .0 6 2J -2 1 1 0 14 8 48 9:%1 &3 5 M a., u & 2 .2 % 71 3 dEd:@ R 0 0 uict O< E for Services $7,442,803 $7,556,952 $7,342,229 19,696 19,696 98,669 93,923 78,948 223,554 scellaneous 251,500 319,589 215,471 TOTAL REVENUE 7,807,922 7,975,185 7,879,923 0017'EOE SEL'IOE SEL'IOE Â£86't+L 09L'989 I86't,6I'I L09'I Â£8'E Z*92Â£0'k 59*'LLO't Zt7L'6IZ'I 8178'99Â£'I 886'IfÂ£'I fI 8'961, t80'ISS L90'Â£Z9 sjunooov ia L06'650'I *179'9*I'I Â£05'ESE'I IEJouag/uolle.Ils 298'8 6I6'9 000'9 2002 2001 5I Â£'Â§99'L I Â£9'060'8 6Â£L'L6L'8 809-*IE (91717'5II) (LI8686) 'IV.LIdVO E[HOE[E[ SE[HfliI(INE[dXE[ 2IE[AO SHAN)All[ 10 (ADNE[OMEIG) SSECOXH REVENUES ----- --- 1, i (0% 0- %0 i 2 0 Ott) 1 i en hoc? 4 00 m ! 9 iD 2% 1 1 - E.7 : In 00 Mis 11 1 1 1 1 1 1 11 1 11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1500 5 1 1 00 U h i U ! - M ! 1 t.. Mi 1 9ic. .. 1 e Ch rt- 1 I i M i i 1 1 Al,4 1 1 1 1 1 11 11 1 1 1 1 1 : 1 1 1 1 It 1 1 1 It 0 00 0 0 CA e 1-2 i V tE e -2 042 5 0 +1 Ch 2Â§:22 2 8.10*Brn..14, U Al O a O:adRE TOTAL REVENU 8,397,192 755,832 762,897 BI~GET 2003 2002 917Â£'90Â£'I 5Z8'6LS L09'98Â£'8 61,17'Â£175) L00'9LI 985'0I EIVI,IdVO E[HOE[E[ SE['HALIGNE[cIXE[ PCHAO Â£Â£*290'I 0Â£Â£'6I8 399'39 5I9't,8 59*'LOL slunooov JOUU Â£5'86 f 6'8* Ef'LSI'I IEJOII@grtIOnellsfu!1II Â£80'IOI 0Â£17'Â£5;I'I $8,110,192 85,000 scellaneous 202,000 000'66Z 90!AJOS *Pa **6'6IZ'* REVENUES O (AONHIOInG) SSHOXH Light Power Year To Date Electric Operating Income $800,000 $600,000 - $400,000 1 - - 7- r- 5 4- 4- i I 2001 $200,000 -- 9 --r-- ~ -- - - 1 11 bM+49%* 12002 $0 - 1.1 911 1 -1 -1 1 1 1 311 1 4 - - - 2002 Budget A 1 ($200,000) C -0 6 L co NE ab~Ew a.6 >0 1 2 (D /1 0 0 ($400,000) --2 LL 2 < 2 -1 < CO v z-er --------------Ill--1- ($600,000) - Electric Capital $2,500,000 -------=-=-- $2,000,000 $1,500,000 -- I 12001 ~2002 $1,000,000 $500,~~~ r~ ~ , ~ / rl F~ -"[~ - = 2002 Budget $0 rel jriN jr-0 1 C -O - L >' c E Â¤) ag > ci 1222-21&112~ozoao 1 - .. Light Power Year To Date Purchased Power $5,000,000 $4,000,000 $3,000,000 ---7- 7- ~* 02001 7,2 $2,000,000 4 1- 4- i- j. 02002 Â« i fti ji - 9 Â¥ i i $1,000,000 4- 2.- i 10 3* 42 42 6, acc' 5 2 22% 8% <MuZO Customer Accounts $600,000 $500,000 a $400,000 _ --a i m -1 3 0 2001 $300,000 -3 1- 1- 1- t- ~ m 2002 $200,000 $100,000 - $0 N I ri *1[14 1-i j--:- pti d C n L L - a -5 > O â‚¬2222=â‚¬ CD < coo 2 o Administrative & General $1,400,000 $1,200,000 $1,000,000 -1-3- $800,000 -3 r-4 - * 02001 $600,000 gl rl_ 2 9 d f- ~- * m 2002 $400,000 4- 1- i- }- 31- $200,000 '-#-w ~ Â®[f-[1-1 L #_ 4- 0-- 1- 1- 1- 1 1 41 31 ..1 -2 1 -,1 1 i 9 4 k * 5 3 9 9-5 8 2 1Â£5<27 <CDOZO 2 Light Power Year To Date Electric Distribution Maintenance $1,600,000 $1,400,000 $1,200,000 1 - l---2 â‚¬ $1,000,000 - -0 4- ; 02001 $800,000 -- 7 -3 -17 *- L f $600,000 72002 $400,000 Ca - 6- 222<6â‚¬-'<wozo a RC E 2 2.6 8% 3 I. I ...1 .. 0 - 1 .Â¥ 1 - A. 1 'b . 14:J .1 , 13/ P - 1 1 1 . 1 . + .. * 4 $ 4. I ' !.~1 /1,7 . 6 \ t . Â¥ . . '' f 0 L . , I L .8 . 4 M. . . * 4 . . . a , 4 . 4 6 & O 9 , r- Al M 0 0 0 0 .. 1 RE g ' . 1 441 ~ ' 1. i f ..i .64. A , I 4 .R t. - f..r 0 4 4. . *I -44 Z 4. 4 '<C 1 4 \1 1 % F.~ , I . 3 ar 4 - 4 4 O- 0 t, .. * - -1 -e '4 4 .1 ' 'i .1 / g.. 1 5* 'r- *f A 1 0 : , U. O- . â€ž , b AÂ¥ 1 O1LLI . .* , NaIl* 1 V â€ž r I C *Z , %. Â¥ th f 4 - â€¢J *2 Â¢ 4 . 4&* 4-4 + 22.4 - 6.- 4 4 T & 2 6 $ 7 \+ . 1 10 ' . I : 40 - I - a . . . F tr .i: 4 . . 4 + I Â¥ , a I Â¢ i . 4 .1 i . 4 + %.4 1 I . * 1 ' . 2, 1Â¥ 1 . * 46 C . 1 m .. i J 4 LU CO LU Â¥ 1* k * 4 1 6- 1 4 ' I - . 1 4-> r * I. .,4 4 + ..' 1 6 // 1 Â· I . *. MS) WalSAS < .. 1 Y , 9 Â·Â· 1 , * i. e * . 4 . . Loadh99.xls 2/11/2003 bea N des , PURCHAS OWER -22000 '~ 0002 b 21000 *19000 ' J * 00091.6 - ,-2 2 - 0069 L A boot, t 23000 - - 0008 L 20000 - - - . ./ I I .. ISMNS**%$%*%*%*%**8**%8%8***%8**S***8**%68**$93$ f~.i 1%*Â§8*%**9*%8&*8983*98**9*$*8**%SM**8%* 2/ l- -al- SMS*S*SiS%8****$9***$6693%8Â§8%8*5**3Â§66$9%*9*99*K J l k**$$*Â§$*$*S*SNS*Â§8$693***$9**%*%*%8**%8*SNE m .1 i to &%MS**$*$Â§9%8*%8%8%8$9*S%*%8Â§6*SN?$&**%* kk*S*$$$8%66**%8%**SNSSBiSMS*8%8*8*3*33*83**SMS* ' 1 - 1 11%**33**3k**RRBRSmaaaeQka**Bate$$*81%8*. : /; Assfs*<~*AwawsEd<,ww~#AN~mwissarm.NA**%*8Â§*** ' 13***Â§**SMS**8%**%8%***%8**3%9%88*********** 7 F~9***~%**B//11.0$2...~////////////////~1#1#~///////////~~All/////0#//*%8** Â· 1 1 1 1 1 1 1 03 : - I. ' 11 11 1-4 M Loadh99.xls 2/11/2003 02000 2001 0 Â£002 B 11:1.1,1....;71'.r,1 V.1.13.1,1Â£11,1 4 9- i 0 - 4 . g * 4,1 r 1 15 I. + 4.1 . . .6 a. I il" 1 i L, .9 -* . I 4.1 .0,1 4, 1 . 1 . $> f..017/Allibmiff.Qggg.gkggwgg: 6 1 ./ - .t. , 1 4 . i . 4 t- ~ 23*94*~74'701,&*17,7/ilm 4 i Â· 4 4 * AS T A . I ~i,l 1 1 -Â· 1 i 1 7-19'PNQ,Â§.0000,0:49'*,W@%4* I Â·A t . 2 . * 4 h . EL, / . 1 9 19*%,00107/R/1ip)000002,22~22,2,2; P il .< .1 EZ I. 0.4 4% P. b Â£ . , .6 % B . , ' 114.#' t- â€¢ 1 Â¢ . 4 1,7,2@,Al,~;ap"704~92'Q,@.,1.6929@42% g . LU Â·.. &00. . 1 1 1 14*,Â·- p i *:Y J.* ... 1 Luu, 4 :k' 1*. 691 -'492'744977477*091* 6 ' N# /4 0 .1 -1 E E $ O 0 .t .ITA,9/4489;U.FiGM,96961,14%,AN .' 4 I, A [1 2 A 1.1-1 1 ' 14 * 1 .t, 31.- â€¢Â· UJ -1 1 4 . "Avam#*PAA'P*APO,Ar#/Arapa*fir#g'4,4 2 Â· iÂ¥ 1 B 1 ~ Â·p * 0#*,4 - 45 . 4 + 4. I , 1 ' A1%049u~9496=Triqifimigiq#Viqi"~~ 4.*'I~ / I. r % :1. - * 6 . . 1%,02'P,2,2,2,22@,,m,ALp+3&741*47'2AN,13144, 22-. 4 + iA#. 1, .......... . . . . Â¥ 1 ................... ................ I p. 9@%,~aN#97676%%06969169**f<IMMQu<%93491644444@, 4 ... 1 1 , 1 -< 1 / 4 1 . . f 81' * 8 50, .O 0, 6 O 0 6 8 8" . 1 i d' 0 O Â». O 0 ' / 0, 0 N 0 1>-9 (C) 1.0 3 94Â» e jÂ¥ 4 4 ($) 93-IVS A-IH.1.NOW t 1 1 4 0 + . * .1 k I I - - â€ž I - - .* .Mm~ - SALEHIST.XLS 2/11/2003 1002 8 Â£0030 .*. 100 des unr 900,009/ ' 800,000 -+- â€¢: F I 4 k I b 1 1 6 . r N Â¤) 2 â‚¬ .1 '1 ~ O 0 -Â¤ 1 . 0 /0 2 1 .0 1 . 1 .* , . La g m . 4 . - m 1 .V ' /1 AFFYÂ»<Â» . 1% 80 1 .32 1 - + . - C V * 4 1 A 4 . IMÂ¥# 1 ,~ 1,1 1 . Â¥2> I + I . -* 4 9 . 4 . f I $ 14 - *4 - hx-Â«:Xâ‚¬Â»Â«4Â»444*Â«4Â»Â«9Â»4~~49Â»66ftÂ« ~n. + 1 - -- 1.11 -21 . .'Â¢ . 4 *:1 I. Ir" .97...4. a * ,: 1Â«90<Â»60<Â»Â»CXÂ»:XxtrÂ«%0~<rÂ«NÂ».:f. g : .1 * ~~<Â»62Â«Â»<4~~<p14,Y,fYpIYYIYPYrVi ~1 ~ 4 143 . - 1 1 . I - I. 1 4 4 IrtÂ»xÂ»Â«4 < :~440<'xY'FY'xrprpr'f 410 4 /4 1 ' r t . 4 4 . C y b * I ./3 ..t t' ' ~Â«494'49994~Â«Â«X'949'94?'4* itg 1 . 1 1 41 1 , [A 4 t>, 574\NXÂ»Â«Â»0Â«960Â« -m + L ./ 4 x di 1 4 6 1 1 ' 9 . ? ., . . . '91 . pl 1, 6, ~KNO<A<~<A<Â»>00Â«\7 + 2- 1. . r . 1 I ** 0 L . 1. , I r h . . I k .4 . k ~~xÂ»Â»Â»4.9Â« Â· / '.. 1. 4 . ' lic) t' i . 64 - 4 % 144Â«Â»At,6 (DI 1 h . LL 1 I & 4 _ t} 4 Â¥1 * 0 Â¥ 4. r ~ 4 ? 1 21 ge: 4.r C. . A.4 4 4 ixÂ©â‚¬*., S . 1 D. 1 . I I ... 4. 1 1 4 4 . m . 1~4 '.1 k 0 0 . 8% , 8 0 * O 2 . a 0. 0 0 81 O + O 0 0- 0 0 O*. O -00 - - 6 0 0 0 0 0 8 0.0 8 . 00 0 0. 8090- 0 00- A (0- 1 CdÂ· le 04 - n ($) 931VS 3190 01 kIVBA. F. 4 , , M ... 1 - * A 4, I. . 1- 11 * * m h : 1, 4 SALEHIST.XLS 2/11/2003 4 â‚¬003[CEI ZOOZ SA - 4 ; dea Â·YEAR TO DATE ELEC RIC SALES OWN OF ESTES PARK ' ~8,019,011~ 9,000, 00 4 al.A Â£00Z%,io A . . ..W -Ill-- .-'....i..~ I . ~ 1%*2%*22~_ -r#$$$55$0*%*$0$:*:*Â» e * 1$0*%%:m*immimt<Whmamemh#$%W/41$#m*wMm~*$***mem** ~02 Â§ 1*40566&5WA~eVh&%64&$qwi*qa&WA~~V00~*~~4 441 1 1 1 - -- C . * IRÂ¥:*t::,%5%:2:56%55050500W%m&66$96$09%**RRf#$$5 v~/ 1 1 1 I 1 8 I556%***Rk;$***R;3~*3*RRSS~. 1 -4 NA 65 1%*SS.%%20**40*,- .. -:11%5552(00%:SS$$05&â‚¬*2**&%%22%22;Stee 1 1 1 G [*:0$000*mwomm ..2*22**RES**SS:* â€¢r- ~ ktttktetÂ¥*2**RR*Re::;*S*SS::Ss&1&**6**~*~**~;*~~*% Ud> - 64 L i -1 1 Vt 1 1 0 '%23$36:.:%&%#.>2.../..:)%22**S --OXS:*PARMA&*RPMÂ¥ a- 1 1;*60000#Gflo~~%%%**:%.IS:* 4 1 1 - 61/ , 1 12&%1RRAP#000$$*0$402**UP ' 1 - VA - 1%6 9 : t'$*03*050%*05*:5&15%b&%%~iSRER#RAT&&5*9554;:*:%%22*&* - \#2,22Â· rm,$50000$0005$06*0005<41<4:S:22%%%*SCR U6> 1:%4%%* Ve ; 15;05::5~52*Fak*Ret: Â¢ 1 O 00 0 0%1 2 g Lo to -g .I T- r ' 1 Sk:13~101SnOMENÂ· I CUSTGROW.xls 2/11/2003 ESTES PARK LIGHT AN ER DEPARTMENT ANNUAL CUSIOMER GROWTH 0 + 0 0 0 y