The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2008-03-20AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, March 20,2008 Preparation date: March 17, 2008 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Light and Power Garage Doors a. Request to replace Water Department 1. Construction Management Side of Marys Lake Water Facility Improvements a. Request to award IT Department No action items REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports 2. Annual System Flushing 3. Colorado Big Thompson water rights (CBT Units) - Yield based on snow pack !I No reports Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. Cynthia Deats From: EP Administration [ir3045@estes.org] Sent: Monday, March 17, 2008 12:30 PM To: Cynthia Deats Subject: Job Done Notice(Send) ***************************** *** Job Done Notice(Send) *** ***************************** JOB NO. 0134 ST. TIME 03/17 11:25 PGS. 1 SEND DOCUMENT NAME TX/RX INCOMPLETE ----- TRANSACTION OK 5869561 KEPL 5869532 Trail Gazette 5861691 Channel 8 6353677 Reporter Herald 5771590 EP News ERROR ----- 1 Cynthia Deats From: EP Administration [ir3045@estes.org] Sent: Monday, March 17, 2008 9:22 AM To: Cynthia Deats Subject: Job Done Notice(Send) ***************************** *** Job Done Notice(Send) -*** ***************************** JOB NO. 0131 ST. TIME 03/17 08:10 PGS. 1 SEND DOCUMENT NAME TX/RX INCOMPLETE ----- TRANSACTION OK 5869561 KEPL 5869532 Trail Gazette 6353677 Reporter Herald 5771590 EP News ERROR 5861691 Channel 8 1 i 4 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, March 20,2008 Preparation date: March 14, 2008 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Light and Power Garage Doors a. Request to replace Water Department 1. Construction Management Side of Marys Lake Water Facility Improvements a. Request to award IT Department No action items REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports 2. Annual System Flushing 3. CBT Units - 60% Yield !I No reports Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. 03/17~2008 MON 08:21 FAX 9705862816 EP Administration @001 *************************** *** FAX MULTI TX REPORT *** *************************** JOB NO. 0131 PGS. 1 TX/RX INCOMPLETE ----- TRANSACTION OK 5869561 KEPL 5869532 Trail Gazette 6353677 Reporter Herald 5771590 EP News ERROR 5861691 Channel 8 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, March 20,2008 Preparation date: March 14, 2008 ACTION ITEMS PUBUC COMMENT Light and Power Department 1. Light and Power Garage Doors a. Request to replace Water Department 1. Construction Management Side of Marys Lake Water Facility Improvements a. Request to award IT Department No action items REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports 2. Annual System Flushing 3. CBT Units - 60% Yield i lI No reports KIntmÂ· Tha I Itilitime ran-,rnittaa rocanige *ho rir,ht *A A.neirlar r.+har i,orne nat mailoht= at tha firna *ho 03/17(2008 MON 08:21 iR3045 @001 ***************** *** TX REPORT *** ***************** JOB NO. 0131 ST. TIME 03/17 08:10 PGS. 1 SEND DOCUMENT NAME TX/RX INCOMPLETE ----- TRANSACTION OK 5869561 KEPL 5869532 Trail Gazette 6353677 Reporter Herald 5771590 EP News ERROR 5861691 Channel 8 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, March 20,2008 Preparation date: March 14, 2008 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Light and Power Garage Doors a. Request to replace Water Department 1. Construction Management Side of Marys Lake Water Facility Improvements a. Request to award IT Department No action items REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports 2. Annual System Flushing 3. CBT Units - 60% Yield I[ No reports TOWN of ESTES PARK Â® ESTES PARK Utilities Department COLORADO INTER-OFFICE MEMORANDUM DATE: March 3,2008 TO: IJtilities Committee FROM: Todd Steichen / Bob Goehring SUBJECT: (Garage Door Replacement) light & Power service building 615 on the West side of Elm Rd & old Light & Power service building 640 Elm Rd on the East side of Elm. Background: The (5) current garage doors on the service building at 615 Elm Rd. are 18 years old and in poor condition. Replacement parts & seals are no longer available for the current doors so the last several times repairs were needed the time frame for the repair work was long & retrofitting of parts was required. The R-value of the current doors is only approx. 6.5 and the U-factor is only approx. 1.5. These new doors have an R-value of 12.9 and a U-factor of.077. In laymen's terms the heat transfer is more than double. Twice as much heat is lost in an hour in the current doors compared to the proposed Heavy Duty Commercial Door The (5) current garage doors on the heated portion of the service building at 640 Elm Rd. are much older than the doors at 615 Elm Rd., these doors are in even worse condition with lesser R-values & U- factor ratings than the doors at 615 Elm Rd. Budget: (Account # 502-7001-580.32-22 / P.302 / Capital building remodeling.) Anderson Garage Doors - Fort Collins Co. 615 Elm Rd. (5) 12'x12' Wayne Dalton#TS-150 garage doors. (R-value 14.6 & Ufactor.076)...........$9,010.00 640 Elm Rd. (5) 12'x14' Same, less 25,000 operation springs. (R-value 14.6 & U-factor.076). ........ ...$9,220.00 Garage Door Service & Sales - Loveland Co. 615 Elm Rd. (5) 12'x12' Clopay#3652 garage doors. (R-value 12.9 & U-factor.077)...................Â·Â·Â·Â·$9,000.00 615 Elm Rd. (5) 12'x12' Clopay#3603 garage doors. (R-value 15.05 & U-factor .077)....Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·Â·$9,500.00 640 Elm Rd. (5) 12'x14' Same, less 25,000 operation springs. (R-value 12.9 & U-factor.077)Â· Â·Â·Â·Â·Â·Â·Â·Â·Â·$10,750.00 Front Range Raynor - Greeley Co. 615 Elm Rd. (5) 12'x12' TC-200 garage door. (R-value 10.0 no U-factor given)...... ..................... $11,925.00 640 Elm Rd. (5) 12'x14' S-24C garage doors. (R-value 10.0 no U-factor given). ......................... .$11,013.75 Action: With energy conservation in mind we feel it is important to purchase the highest quality most energy efficient garage doors for the best possible price. Therefore staff recommends approval to purchase all (10) garage doors for both Light & Power service buildings from Anderson Garage Doors, total cost $18,230.00 Water Department Inter-Office Memorandum ESTES 1!221 PARK COLORADO TO: Utilities Committee From: Jeff Boles/ Bob Goehring Date: 3/14/2008 Re: Construction Management - Mary's Lake WTP Expansion Project Background: HDR Engineering was awarded the contract for Design Engineering of the Mary's Lake WTP Plant Expansion including treatment upgrades to membrane filtration on August 24, 2007 ($377845). Construction Management for the project was to be negotiated closer to the construction bidding that would take place in 2008. (Attachments: Scope of Services and Fee Proposal) The proposed Construction Management contract for $363,446 would be 7.2% of a $5,000,000 project. $741,291 for both Design & CM = 14.8%. We budgeted 17.5% due to the complexity of the project. This is an excellent price to come in under 15% for this project. Budget: #503-6500-560-22-02 Budgeted - 2008 Funds $ 472,155 HDR Engineering Proposal for Construction Management $363,446 Recommended Action: Staff recommends entering a Contract with HDR Engineering for the Construction Management of the Mary's Lake WTP Expansion Project at a cost of $363,446. Exhibit A Scope of Work for Mary's Lake WTP Improvements - Engineers Services During Construction The Program The program consists of Engineers Services During Construction (ESDC) for the project hereinafter described as the Town of Estes Park Mary's Lake Water Treatment Plant (MLWTP) Improvements. The ESDC proposed are additional services to support the construction phase of the MLWTP Improvements project. Included in the program are construction contract initiation and management, review of submittals, observations during construction (part-time), coordination of installation and start-up of the temporary treatment system, start-up assistance for the designed improvements, preliminary and final punch-list development, and preparation of "as-recorded" drawings. ESDC will consist of the following major phases: 800 - Contractor Prequalification 900 - Construction Contract Initiation and Management 1000 - Office Assistance and Administration 1100 - Construction Observations (Part-time) 1200 - Temporary Treatment System Installation and Start-up 1300 - Facility Start-up and Testing 1400 - Development of Punch Lists 1500 - Preparation of"as-recorded" drawings The work tasks that will be required during the project phases are as follows: 800 - Prequalification of Contractors 801 - Develop prequalification criteria and documents Develop prequalification criteria and the documents required for submittal by contractors. Suggested criteria to be used for contractor prequalification include: 1) technical ability, capacity, experience, and skill; 2) past experience completing projects of similar size and complexity; 3) quality of work on previous projects; 4) references and recommendations from former clients; 5) financial capacity, sufficiency of resources, and bonding capacity; 6) organization and completeness of the statement o f qualifications; and 7) safety record. Final criteria used will be approved by the Town. 803 - Issue advertisement and prequalification bid package Place advertisements for bid prequalification and provide prequalification bid document packages as requested to contractors. Provide for submission of prequalification documents to HDR. 804 - Review submittals and recommend contractors Review contractor submittals with respect to prequalification criteria and make recommendation to Town regarding contractors qualified to bid. -1- 900 - Construction Contract Initiation and Management The purpose of this portion of the project is to assist the Town with construction contract initiation and management of the contract during the course of construction. The following tasks are included in our approach to this portion o f the project: 901 - Conduct Pre-Construction Meeting Designated personnel from the Town, Contractor and HDR staff will meet to discuss the construction contract requirements, and establish lines of communication. The final budget, baseline schedule, and intermediate milestone requirements for the construction contract will be reviewed. Meeting schedules will be established for weekly and monthly meetings. The information gathered will be recorded as meeting minutes and distributed to all key project team members. 902 - Monthly Construction Meetings HDR's construction project manager will facilitate monthly construction meetings. These meetings will focus on resolving any outstanding issues related to RFI's, change orders, submittals, updates to the record drawings, review of monthly pay applications, and the contractor's progress compared to the overall project schedule. Meeting minutes will be developed at the conclusion of each meeting and distributed to all key project team members. 903 - Develop Invoices and Monitor Budget Cost tracking on a weekly basis and monthly invoicing will be used to maintain cost control. Task Assumptions â€¢ The following construction milestone dates are assumed: o Construction will begin July 1, 2008 (HDR receives NTP) Contractor will have all design improvements constructed and operational by April 1,2009 Substantial Completion by May 1, 2009 Final Completion by July 1, 2009 (end of HDR's contract) â€¢ One (1) pre-construction and nine (9) monthly construction meetings will be required 1000 - Office Assistance and Administration This task will involve providing office assistance and administration to support the submittal review, RFI, and Change Order process. Specific tasks include: 1001 - Receive, Log, and Review Submittals Receive, log, and perform engineering reviews of all project required shop drawings, operation and maintenance (O&M) manuals, and administrative submittals required in the construction contract. The Project Tracker document control system will be used to manage the submittal process. Monthly status reports will be run from within the document control system and submittal status reports will be provided at each monthly construction meeting. 1002 - Coordination with Membrane Supplier Coordinate final shop drawings, shipping, delivery, and installation requirements with membrane supplier. 1003 - Receive, Log, and Respond to RFI's Receive, log, and respond to Requests for Information (RFI's) received during the course of construction. Utilize Project Tracker to manage the RFI process. Monthly status reports will be -2- - 00 0 run from within the document control system with updates provided at each monthly construction meeting. 1004 - Change Order Assistance Provide change order preparation assistance to the Town. 1005 - Coordination with SCADA programmer Coordinate programmer requirements with contractor, Town concerns, membrane supplier and membrane operations. 1006 - Coordination with Contractor Coordinate contractor work with respect to plant shut downs, BOR requirements, CDPHE requirements, and membrane supplier. 1007 - Review Pay Requests Receive and review monthly pay requests from contractor and membrane supplier. Task Assumptions â€¢ Task 901 - Estimate is based on sixty (60) submittals. Baseline schedule review will only be for compliance with the contract document requirements. Art analysis of the schedule logic is not included. â€¢ Task 902 - Estimate is based on three (3) shop drawing iterations (preliminary, 95%, and fina~ and two additional (2) site visits by PM (delivery and installation) â€¢ Task 903 - Estimate is based on fifteen (15) RFI's â€¢ Task 904 - Estimate is based on three (3) change orders 1000 - Construction Observation (Part-time) Provide on-site observations (part-time) during construction. Specific tasks include 1001 - Attend Weekly Construction Progress Meetings Attend regularly scheduled weekly construction progress meetings. 1002 - Perform Construction Observations Resident project representative (RPR) will observe contractor activities during construction. RPR will note variances from contract requirements (non-compliance reports) and develop daily reports, supplemented with photographs, detailing observations. Task Assumptions â€¢ Task 1001 - Estimate is based on thirty-six (36) weekly meetings. â€¢ Task 1002 - Estimate is based on sixteen (16) hours per week for thirty-six (36) weeks, with intermittent visits and assistance from design engineers. 1100 - Temporary Treatment System Installation and Start-up Assist with installation and start-up of the contractor provided temporary treatment system. Specific tasks include: 1101 - Coordinate Installation of the Temporary Treatment System Coordinate installation of the temporary treatment system. -3- - 1102 - Coordinate Temporary Treatment System Start-up and Operation Review contractors plan for all functional and performance testing and start-up activities. Witness and document start-up activities. Task Assumptions â€¢ Task 1101 - Estimate includes twenty-four (24) hours o f installation coordination assistance. â€¢ Task 1102 - Estimate includes twenty-four (24) hours of start-up and operation assistance. 1200 - Facility Start-up and Testing Once the contractor has reached a state of operational completion, assist the Town with Facility Start-up. Specific tasks include: 1201 - Confirm Readiness for Startup Establish requirements needed to make plant operational, including procedures to be followed and monitoring required. Conduct review of treatment systems and support facilities to verify all components are adequately completed for successful operation of the plant. 1202 - Coordinate and Witness Start-up and Testing Activities Review membrane supplier's and contractor's plan for all functional and performance testing and start-up activities. Witness and document start-up activities. Coordinate activities with CDPHE. Task Assumptions â€¢ Task 1202 - Estimate includes eighty (80) hours of start-up and testing assistance 1300 - Develop Punch Lists Once the contractor has reached a state of substantial completion, perform preliminary and final punch list inspections. Specific tasks include: 1301 - Preliminary Punch List Inspection Perform a preliminary punch list inspection. Prepare and distribute the preliminary punch list to the Town and contractor. 1302 - Final Punch List Inspection Perform the final punch list inspection. Prepare and distribute the final punch list to the Town and contractor. Task Assumptions â€¢ Task includes site visits for two inspections. 1400 - Prepare "As-Recorded" Drawings Modify the AutoCAD drawings to reflect the as-recorded conditions utilizing contractor supplied data. These AutoCAD files will be submitted to the City within 90 days of final acceptance of the project. -4- 1401 - Prepare "As-Recorded" Drawings HDR will prepare the as-recorded drawings on full size Mylar sheets. One full size hardcopy will be provided to the Town within 90 days of final acceptance of the project. The following items are not considered to be part of this contract: 1. Warranty period support 2. Development of an Operations and Maintenance manual -5- R * Fll 5588 : .tiall :ON ..' Aam m . 4 131 g 8 8: 2: - 65 N- -- 1 2% 11 31 ES 40, 69 69 + 6/ S g = 8 - 2 2 r 0 h * 0 *ME . 55583/8 1-- g--7 FE- .::-- 3-r- 0 h 64â‚¬860 *6464+*6964 i _. -0 64 + 64 64 68 64 . W -1 i 0 8 - 0 (0 . & 2 9 2 -1 0 01 el & : 2.1 .â€žCOâ€ž- O..N 02 00 . S ... i N. 2 2 . 5 1 02 . 2 0 2 0/ 0 2 00 .2 %95. Sz 02 osI 2.92 00 .2 12&9 .2 99 0Â·Â· 1 1 0 2 02 9. 00 00 1 02 .2 . a Sts@. 2 . 08 ola 9 - co 61 0 8 00 .8 .S &2 12 - ii 0 .. . .~ . -EW : & m . 0 8 CO .Ta ZE*i Â»92 - co lEi - W 01 co E co : co: , s g w : 1 w %!5 2 2 91'9 '. * / 01 Oil . 91 82/ 00 - te b. - 0 .a, 19 R g .2 0 % 1 ... 0 01 - to 9 2 co co 02 . 2 m .. C4 .. 000 = r co %.= ..1i 7%:3 1 7%595&!268 R!@:2 ce e C:~~ 1 -00 4, 0 00 E ..a 2- a . 4. , CD . - r â‚¬A .. to . â€¢ 6. I 2/Â£ S 0 0 . Egg & 0 - -:-0 - ... 81 : F H. 2 - .AZE Â£5 - B thi 1 +8 1 . . - irn//EMa: c.9 Emo 27â‚¬726*B : 8 3 -4 - -030&3~~ -*3 -~ - a. iI: Il 8,9 â€¢22 .- 01*111Â· (0 I C . Â® C C .<0(00Or ~@g# 888:888 9% EM Ag .55 ~~ r.c'].1.0.- Engineering Services During Construction Fee Estimate Mary's Lake Water Treatment Plant Improvements $133 $100 $4 81 _ $1,341 $0 $3,884 $1065 $274 $200 $15,071_ 12&83 1 - $5,~01 - $715_ ~ $6,375 . ~ L - - liblo - 86 $1,842 $7,354 $6,445 $12,439 Â£0â„¢ G "$ 9*9'9S ~ 8$ ~ LOZ'9$ a 06 L'Z$ 81. 1 01 1 eview i 52 76 80.*/ 01â€¢Ii DIâ€¢Ilw331,00148 WOH *la.ecle' 690'2$ Subtotal (Hours) $5 ~9 : l 4 L Subtotal (Hours uoye,ado pue dn-pets UlatsAS lu (SJIH) le,olqns 9 1 1~H~~S~~ (SJAOH) telojqns Walsks lueUJWail AJEJO se!;!A!. 10Â¥ Bullsal. pue drÂ·~~*7'ZAUDI~]N~i 2 SAnOH le,01 801 Develop Prequalification Criteria and Documents 802 Issue Adverstisement & Prequalification Bid Package 803 Review Submittals and Recommend Contractors voices and Monitor Budget Progress Meetings e-Construction Meeting nstruction Meetings SCUMAEJ~ , paplo~â€ž E~d L DSL u fl adsul 19!+1 qound Ajeuiuma, uoip d ul ts,1 40(1 d leu i %2 0 022 #22%40 2 3: 2 Â£ 0-MA,- 0 01 - 0100 8 g g â„¢ ./ Â¤E 0 099 6. 00-0 0 *RM- ... HER 2*En M rn &8 022* m ORR /2 - Ch E 8%88? 22Â©22 M *4% ..~.% 000 000 0 #AS 0 C c. h h SEE 4 4 00 0 0 -250 0 0 O 4-Â© 0 0 2 ~o-=u. 22- 2 91/12 00% -g@600<0 *90 5 805 : S 2, ==0 d E- LU O (IEL'5) V/N (I ZL'5) (IZL'5) 0 (HO'01) (=00 0 SjOlnOS 1@410 01 polgoOtteR@A!0Â°01 4%8) MONTH TO DATE YEAR TO DATE BUDGET vs. YTD Beginning unrestricted (usable) fund balance 11,275,195 10,904,931 $9,986,900 $10,904,931 1 tration and General 94,52 137,713 (4 ,1 215,96 251,199 35,239) .00 ~,~27 Total O&M Expenses 696,221 359,542 336,679 1,386,591 1,084,243 302,348 1,084,243 1 0 000'09L 000 0 0000 0 00!Alos *Pa 67.I'ZfI 690'180'L 00*0 0000 (631'DI) 6ZI'Et,I (621'241) 621'DI 181!deo LEL'681 06Â£'806 L00'0 L00'0 (6Lt'5) LEL'68 I 853'48 I (*01.,) 98'*6 I fL'06 ino sesuell SU!181@do 60 I '9 It' 1 6t,d'90Â£'8I 590 Z900 OPL'*9 I 60 I '9 If'I 6tS'OLS' I 9ft'061 915'966 E96'98L swn)!puadxE[ 18101 099'656 (8ZE'L*6'9) SIC*0* 099'6â‚¬6 3,6'fts St8'SIâ‚¬ 969'â‚¬L5 I Ly'LSZ (le,ideo @iopq somi,puodxo 6Â£6'Â£96 (81Â£'L*6'9) L66'86Â£ 6Â£6'Â£56 Et'6'tâ‚¬Â§ Â£08.50â‚¬ *L9'â‚¬9Â§ 1LB'LSE tpUOUI 101 UO! 1!Sod qse< u! 00ueqo OLB'8Â£831$ EL9'6â‚¬0'ES 0L8'8Â£8'11$ 698'SEA I $ @oueleq pury (aiqusn) poio!Â·Ils@Jun SurpuE! 1,008,230 1,115,675 107,445 2,047,314 184,734 10,8 0,627 1,044,833 1,170,212 125,379 2,105,791 E 11 b FEB FEB VAR YTD VAR Per kWh Per kWh 0.037 0.019 r Billing and Accounts 48,871 76,577 (2 ,7 6 80,396 108,325 C,922 0.003 2007 2008 2008 36,603 54,537 17,934 58,477 f Supply 449,250 449,250 rn:== ~~~~~~ and Maintenance 103,576 145,252 (4 ,676 LIGHT AND POWER FUND T COMPARISON JOAO Sanit@AN,jO bU@!Ouopfs@31Â¢3) letolqns itures TOWN OF ESTES PARK LIGHT AND POWER TRENDS Type Summary Date February-08 12 - month moving average Total % Total % of Avg Avg Avg # ofaccts KWH Growth Revenues Total Rev % Cum Rev/KWH KWH/Cust Rev/Cust r Residential 7,547 4,047.290 0.8% $383.112 44% 44% $().0949 536 $50.74 Gen Serv Small 1.640 2.146.823 0.7% $ 197,602 22% 66% $0.092 1 1.309 $120.47 Gen Serv Large 95 2.834.414 0.9% $ 174.520 20% 86% $0.0617 29.93 ] $ 1.843.22 r Residential Demand 372 690,193 -0.1% $65.116 7% 93% SO.0978 1.862 $175.69 r Res Energy / Time ofDay 248 410.137 0.8% $27.006 3% 96% $0.0678 1.649 $108.64 Municipal 63 244,482 -0.4% $19.729 2% 99% SO.0806 3,925 $316.83 RMNP - Small Admin 21 103,667 0.9% $3.179 0% 99% $0.0425 4.898 $149.63 RMNP - Large Admin 6 61,425 1.7% $2.787 0% 99% $0.0460 10.238 $464.52 r Res Basic Energy 21 28,261 5.2% $2.5()9 0% 100% So.0899 1.367 $121.32 Wind Power 113 0 0.0% $1,144 0% 99% N/A N/A N/A GSS - Comml- Energy TOD 13 18.055 3.6% $ 1.283 0% 100% $0.0720 1.389 $98.70 GSL - Comml - Time of Day 1 11.265 0.6% $832 0% 100% $0.0766 0 $0.00 Outdoor Area Lighting 16 0 0.0% $245 0% 100% N/A N/A N/A r Res Time of Day 0 0 #DIV/0! $0 0% 100% #DIV/0! #DIV/0! #DIWO! RMNP - Administrative 2 736 0.0% $41 0% 100% N/A N/A N/A 10.156 avg $879,106 100% annual revenues at this pace: $10,549,270 budget: $10,686,947 projected over/under: | ($137,6'mi C i00. 1 \ -2006 ZOOZ - %000 8002- oea AoN PO des nV JeIN qe:1 uer Actual L&P revenues over/beyond Budget 2.00% 1.00% %00' r %00'Z- Â· Â·-- - %OOP i ..: 4,~i.. /"759*6NE ~2 :Â·~'r .pe -Wti:7414*>*Â·1*:-ti- i 1 - i O Budget IActual 8001 ZOOE 900Z L&P Budget vs (Projected) Actuals $11,000,000 - -- $10,800,000 $10,600,000 $10,400,000 $10,200,000 000'000'OLS 000'008'6$ 000'009'6$ 000'00â‚¬6$ 000'00Z'6$ 000'000'6$ (%0 db 9074r t sb. 11& db r '6 4 1 L&P Revenue Progress 10,200,000 -- m Budgeted 9,800,000 - â€¢ R~~venues at Current + '699 + 11,000,000 - --- - --- - - ---- --- 10,800,000 10,600,000 -- 10,400,000 -- 10,000,000 -- -- 000'009'6 -- 000'00*'6 -- 000'001'6 - 000'000'6 MONTHLY PEAK DEMAND 25500 - 23500 - 21500 - --- -0-2006 - - - -*-2007 19500 -0- 2008 17500- - 15500 - 13500 - 11500 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES 14,000 - - 7 11' 12,000 9~ 10,000 --3~ -# 2- 3 1 - 72 33 /7 7 fir _#_31- 04 Â»0 1% 31-2 +4 92 A 0%14* 02006 06 03 03 4 0/ 42 #1 %4 9%14 04 0% 33 * 8,000 -H -4 -01-0 / /5 04 - -54-52-01-5Â¥-a- 82007 441 3, * 4-~-4 k ~.~~ ~% ~~~ ~J~ 3 O 2008 04 02 A Â» 4 3% 2 5-1 Â» 4 44 02 I 8 #f %4 1 " 4% 4% 5% 0 0% 03% 0-2 " 04 3 32 4% 4% 4 4000 --4 -4 4 4 2 4% 4 30 0- 8 8 d *13 29 94 01 %* 0, 01 $ mi ma %/ 0% ft #1 4/ m# 43 02 43 41 44 41%14 'll 14 1% 14,2 141%181% 2,000 - Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 Monthly MWH SYSTEM KW 4*<%099% N=k YTD ENERGY PURCHASES 140,000 - 120,000 100,000 -- 5.05% YTD 2008 VS - - - 2007 80,000 - - m 2006 O 2007 .r 60,000 - - â€¢ 2008 40,000 E--~ - - - 20,000 - Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD POWER COST vs. BUDGET ($1,000~ BBUDGET Â¤ACTUAL 6,000 - 5,000 - ':52 4,000 I .3 fc:: es iss 3,000 :51 :* m 2% d. 2,000 M 9 Q & W 4 A , m 101 e 2 7 1 1 ~ 1-1 i 1,000 - 9%13/3/1/*1% 4*4>20. M MI - m >9: A. &1 & 21 1 0 % 1% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 YTD MWH Purchased nnuuunu~ n~ unuuu n n n n~ nm%mmuu .H M ' n~ uum mun W mnummunnumm ***%85&969*692Â«292* ELECTRIC SALES BY MONTH ($1,000) 1,200 - 1,100 --- j ' 1,000 - . -3 I . 900 -- :4 -4 Â·r T T* N I. P: - 800 - . i e _ 1 4 -Tf -1 7 - r <3 :. â€¢2 .: t r A :4 3 1 4 :1 02006 H ,&* 5. 82007 1 s z Â·sâ€¢Â· < 1, 4 a . 4 -1 ..Â» 700 - H - 91 - 1 i __ 3 4 -731__ c f - ..2 + .9 + 3 ' 9 4 .1 4 5 1 1 2 : 444 .4 :S ' 24' O 2008 ..~ 4 41 47 30 41, 4 1 '1 .., :, 4 5 1 4 1 + r : 4 1 6.4 4 -,di- i 1 1 , 9 : 6 i '.2 11 ip i ./ 40 i . 4 t:. ..4 ~' : % i â‚¬ 3 . 3 Â° H , i 1% .4 :3 :S /2 .2 / M 'll 1 --- -ls B 61 3 1 /& 300 i * , '11 , . 6 1 i:.2 1 i 2 1 : E I i 1 1 .1-2 1 75 1 + 4 , '-:1 , it , Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR TO DATE ELECTRIC SALES ($1,000) 12,000 10,800,627 10,000 - - 9.03% 2008 YTD VS ' 2007 8,000- - 0 2006 r==12007 , 4 6,000 - 02008 - -9 - Budget - E A . IF ' #8 - 4,000 - 2,000 - S 5 - 4 3 . 1 â‚¬R '*1: :1, .ci, Â·Â·' 1 A 1.1 1 I. R 1 ... 1 . : I . 4 .1 0 1 lei I .' ': .f *L,: .Il , rE 3 2 - 0 '1- I I I I #_C I Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 8 YEAR TO DATE SALES MONTHLY SALES ' :. >.: .Â© 4% I:/~Â¥Â»I:/R:. 2%*,ge g Â£ 1 g &1 1Â£ $ cn oN * B $ er,rnâ€¢A-â€¢6 23 E - 0 2Â§1 g M 2 * E E 3%*0 0 g A..rES-% 22-44* cr~ . A**ga * EBO i E E , 9 CE-5(NM EW.ER E 5 0 5 ~ M A 2 2 - en 1 3Â§ Â§Â§Â§Â§2 8 2 9% % E fl M 6 /1 dodoo 000000 Â£ 3% s Â§83 2 -Â§Â§Â§*r- 00 CO 2 1 M cdood Oodoodo SES-Z --- 0 g 01:h....Cl 23=06 2% R =SC C ~,0 2Â§ 51 AostÂ®% :08&80:1 0 >â€¢ M '4 9 "1 41 --1 â‚¬1 00-909 0% 8 4-'2$0 02*@g 7 Â¢4 --- 2% Â§9 Inâ€¢ntr,tric,O O 0 Menot-OÂ© 5 0 M er, W CNN'00, 0 0 001Â·-lr, 1.1 11.01 h h a O M 82=g 00 0 0 ~1 011.01 - 8 8 ON â€¢ritr,-C,O C ty r m r h 1 a Y - M e 0 m Z #8 2 ali i "m R 50 -0 2 5 56 @256 5 e MI--*M ./ roW-- 0 14 - 0. 488 5 Z * DATE MONTH TO DATE YEAR TO DATE YEAR TO DATE 68,033 108,417 (40,384) 9,874 (34,049 .002 0.00 9,874 68% 45,027 (10,572) 1 679 13 EZ8'905 00' (*6Â£'Gil) 509 62*'0Â£Â£ (9Â£6'38 I) 688'18Â£ E56'86I asuadxa *ouniolutew pue uo!.lwodo imol I EZE'El IZE'66 0000 0000 (8[9) UCEl *85'ZI (too 8Â£9'9 ino siojsuan Su!*iado ILE'615 Elâ‚¬'100'6 210 0 800'0 (OEO'ZLI) ILE'6I 5 Itt'Lt'E (8 Â£ 1 '6Â£1) EGL'88Â£ 919'602 sam)!puodxa Inol i9L'g (tÂ·925) *9L'Â§ gort (gon) O SOOmOS 10410 01 pO,000UumOA!0001 qse) (6EC58) (Â£Lt'LBE) (612'58) tâ‚¬Z'ZOE (489'*91) (650*181) (GLE'9Z) mUOUI 101 uouisod qsgo u! 082143 (Â£00'16) (Â£80'&9) (LEZ'Â£62) (Â£00'16) ,[E'ZOE (6LE'Zil) (.5Â£'8L1) (GLE'91) (Imideo NOJOq sam}!puodxo 6 IE'9It'*$ 800'18â‚¬2$ 6IE'9It'*$ OZE'91*'*$ aouqeq punJ (@Iqusn) poppisolun Buipust VAR VAR Per Budget Beginning unrestricted (usable) fund balance 4,597,379 $3,155,091 $4,501 000*0 000'0 0 00/11@S 140(1 3 0000 0000 zoo'* 922 824 Zoo'* 9ZE SEE'* lul/deo (ZES (68L'6E) 001'55 s,unojoy pue Bu!!ile J (Lll (691'Et) 66'E9 FOU@ D pue uoilans!U!11!pv 136,043 (119 Total Revenues 183,240 2 (121,207) 161,397 171,909 10,512 326,267 Plant Development Tap Fees 48,070 tribution and Maintenance 110,247 (48,932) 27.635 Operation and Maintenance Expense CASH FLOW COMPARISON 10AO SanUOANJO XOUMOIUM)~Ssooxa) Immqns ER FUND Revenues Expenditures TOWN OF ESTES PARK WATER DEPARTMENT TRENDS Type Summary Date February-08 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,699 12.383,147 0.0% $80,235 37% 37% $0.007 4,593 $29.75 Urban Commercial 793 14,181,833 -1.3% $57,209 27% 64% $0.004 17,817 $71.93 Rural Residential 1,308 4,468,217 -0.4% $55,584 26% 90% $0.013 3,415 S42.48 Rural Commercial 92 1,638,247 0.8% $10.532 5% 95% $0.007 17.763 $114.25 Bulk Water 1,510,482 -0.7% $11,502 5% 100% avg: $215,060 100% annual revenues at this pace: $2,580,725 budget: $2,645,554 projected over/under: | ($64,829)1 \ \ 1 IL % - 2006 ZOOZ- %009 8001- ~ 080 AON 100 des 6nv inf unr *ev,1 Jdv Je'81 Actual Water revenues over/beyond Budget 16.00% - 14.00% 12.00% 10.00% 8.00% %00** %00'Z %00'0 %00-Z- - %00'17- i 1 I i -:69:24.....' .''26.1Â£25.2../.1,25.4, L ., 1 . i 1 - ./di/,I> i O Budget IActual 800Z ZOOZ 9001 Water Budget vs (Projected) Actual $3,000,000 - -Â·Â·Â· $2,900,000 $2,800,000 $2,700,000 $2,600,000 000'009'1$ 000'004'1$ 000'00Â£'1$ 000'ooz'Z$ 000'00 L'ZE 000'000*ZE db &014r 11& 1 Water Revenue Progress $2,600,000 - m Budgeted Revenues â€¢ Revenues at Current Goed - 000'00â‚¬1$ 04,609 4 $3,000,000 $2,900,000 $2,800,000 $2,700,000 $2,500,000 - - 000'000$ -- 000'001'3$ - 000'OOLIES - 000'000'3$ 3/11/2008 Water Sales by Month ($) 350,000 T 300,000 4, 5, r **, l/* /I* 250,000 '' ,1 , 200,000 Â¤2006 pjjj-f *,4, * 1 ,,,,, 02007 40 '' , 150,000--~- tr '. 1/ ' Â¤2008 -11/flf-0-j- 42 4 -3 04,/, 100,000 - , * 4/, 1 50,000 - , I , I , I I ' 4 1 1 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Water Sales Year-To-Date ($1,000) 3,500 3.276.554 3,000 - 02006 2,500 - -57 W 2007 0 2008 2,000 4-- - - Budget / 1,500 / 3.36% 2008 YTD VS 2007 ,# 1,000 / %- 3 500 0-- /-- L % ? L 7 j g I , omiml 4 , 1. 1, 4- i. i, Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 \\\\\\\\\\\\\Â»Â»Na\Â» â€¢. Water Department Inter-Office Memorandum ESTES 1122] PARK COLORADO TO: Laura Schmidt From: Cliff Tedder Date: 03/10/2008 Re: March Utilities Committee - 2008 Annual System Flushing The Water Department will be doing the annual system flushing over a two-week period starting Tuesday April 15~h thru Friday April 18~h and again on Tuesday April 22nd thru Friday April 25th. Scheduled areas are as follows: April 15, 2008 Spur 66 to Mary's Lake Road Moraine Ave (from Mary's Lake Road to River Rock Condominium's) High Drive Area Range View Elkhorn Club Estates Riverside Drive (from Mary's Lake Road to Prospect Park) April 16,2008 Fall River Road (from Elkhorn Club Estates to Fall River Estates) Riverside Drive (from Prospect Park to Moccasin) Moccasin & Cyteworth Area Hospital Area Stanley Circle Hwy 7 (west side from Conference Center to Lexington Lane) April 17,2008 Hwy 7 (west side from Lexington Lane to Pinewood Drive) Peak View Drive to Dekker Circle April 18,2008 Hwy 7 (east side from Dannel's Fire Station south to Whispering Pines Drive) School District Area Bureau Area Fish Creek Road Uplands April 22,2008 Downtown (North to Devils Gulch Road) Davis Hill Stanley Village Black Canyon Hills Water Department Inter-Office Memorandum ESTES IBE.1 PARK COLORADO April 23,2008 Hwy 34 (from Stanley Village east to Bellevue) Stanley Heights Reserve Ranch Meadows Lone Pine Area Grand Estates Dry Gulch Road, Good Samaritan Village April 24,2008 Carriage Hills (south of Whispering Pines Drive) Arapahoe Meadows Cherokee Drive Prospect Estates Centennial Hills Rockwood Estates April 25,2008 Thunder Mountain Subdivision Fall River Estates and Fish Hatchery Road Kiowa Subdivision , .. T, Snowpack and Streamflow Comparisons March 1st, 2008 Snow Water Content % of Average Colorado's Statewide Snowpack I 135% Upper Colorado River (1) 125% South Platte Tributaries 0 110% Snow-Water Content Comparisons (inches) March 1st, 2008 March 1 Comparative Snow-Water Content Snow-Water Content Watershed 2008 Average 1 % Avg 2007 2006 2005 2004 Blue River 14.1 10.6 133% 11.8 15.4 9.0 8.6 Upper Colorado River 11.0 9.8 112% 10.5 9.8 8.4 6.8 Willow Creek 10.0 7.7 130% 8.6 7.0 8.4 6.2 Fraser River 12.2 9.7 125% 10.5 12.1 8.7 8.0 Poudre River 11.9 10.3 115% 11.7 11.2 8.4 7.3 Big Thompson River 12.3 11.6 106% 13.1 11.0 9.9 8.8 St. Vrain River 8.0 7.6 106% 10.3 7.5 6.9 5.6 Boulder Creek 9.9 9.0 111% 12.6 10.2 8.0 6.4 Apr-Jul Maximum, Minimum and Most Probable Streamflow Forecasts (1000 afl Forecast Most Forecast Apr-Jul Most Prob Watershed Minimum Probable Maximum Average % Average Blue River 260 335 425 273 123% Upper Colorado River 162 231 299 217 106% Willow Creek 44 62 81 48 131% Fraser River 94 122 156 112 109% Poudre River 151 244 336 224 109% Big Thompson River 70 93 116 93 100% St. Vrain River 59 89 120 92 97% Boulder Creek 31 49 66 51 96% |South Platte Tributaries I 312 | 475 1 638 1 460 ~ Precipitation Totals Average | % Average Feb 0.21 0.34 62% Nov-Feb 1.81 1.82 99% (1) Includes the Colorado, Willow Creek, Fraser and Blue River Watersheds (2) Includes the Poudre, Big Thompson, Saint Vrain and Boulder Creek Watersheds 3/7/2008 - 1:22 PM