The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2007-10-18-- l 4 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, Elktober 18, 2007 Preparation date: Elktober 10, 2007 *Revision date: Elktober 16, 2007 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Net Metering a. Request acceptance of Net Metering Policy 2. Secondary Wire Trailer a. Request permission to purchase Water Department 1. Reimbursement Resolution: Mary's Lake Water Treatment Facility Upgrade a. Request approval to use bond proceeds to reimburse Water Fund Balance for facility upgrades 2. Big Thompson WTF Metal SCADA Sampling Building a. Request approval to purchase 3. Bureau Area Water Main Replacement a. Request approval of the design engineering IT Department No items REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports *2. Prospect Mountain Water Company - verbal report from Bob Goehring Â£[ No reports Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. T . AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, Elktober 18, 2007 Preparation date: Elktober 10,2007 *Revision date: Elktober 16,2007 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Net Metering a. Request acceptance of Net Metering Policy 2. Secondary Wire Trailer a. Request permission to purchase Water Department 1. Reimbursement Resolution: Mary's Lake Water Treatment Facility Upgrade a. Request approval to use bond proceeds to reimburse Water Fund Balance for facility upgrades 2. Big Thompson WTF Metal SCADA Sampling Building a. Request approval to purchase 3. Bureau Area Water Main Replacement a. Request approval of the design engineering IT Department No items REPORTS: Liaht and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports *2. Prospect Mountain Water Company - verbal report from Bob Goehring 1-I No reports Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. hp Laserjet 3015 40 b HP LASERJET FAX invent Oct-17-2007 10:45AM Fax Call Report Job Date Time Type Identification Duration Pages Result 934 10/17/2007 10:42:21AM Send 5869561 0:34 1 OK 935 10/17/2007 10:43:01AM Send 5869532 0:33 1 OK 936 10/17/2007 10:43:39AM Send 5861691 0:39 1 OK 937 10/17/2007 10:44:23AM Send 6353677 0:34 1 OK 938 10/17/2007 10:45:02AM Send 5771590 0:42 1 OK . AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, Elktober 18, 2007 Preparation date: Elktober 10, 2007 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Net Metering a. Request acceptance of Net Metering Policy 2. Secondary Wire Trailer a. Request permission to purchase Water Department 1. Reimbursement Resolution: Mary's Lake Water Treatment Facility Upgrade a. Request approval to use bond proceeds to reimburse Water Fund Balance for facility upgrades 2. Big Thompson WTF Metal SCADA Sampling Building a. Request approval to purchase 3. Bureau Area Water Main Replacement a. Request approval of the design engineering IT Department No items REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports II No reports Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. . 1 6- 9 hp Laserjet 3015 HP LASERJET FAX invent Oct-16-2007 10:53AM Fax Call Report Job Date Time Type Identification Duration Pages Result 926 10/16/2007 10:50:23AM Send 5869561 0:34 1 OK 927 10/16/2007 10:51:02AM Send 5869532 0:33 1 OK 928 10/16/2007 10:51:40AM Send 5861691 0:38 1 OK 929 10/16/2007 10:52:24AM Send 6353677 0:32 1 OK 930 10/16/2007 10:53:01AM Send 5771590 0:41 1 OK AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, Elktober 18, 2007 Preparation date: Elktober 10,2007 ACTION ITEMS PUBLIC COMMENT Light and Power Department 1. Net Metering a. Request acceptance of Net Metering Policy 2. $15,000 Budgeted Secondary Wire Trailer, account # 502-6501-560.26-43 a. Request permission to purchase Water Department 1. Mary's Lake Water Treatment Facility Expansion / Treatment Modification: Reimbursement Resolution, account # 503-7000-580.32-22 a. Request approval to use bond proceeds to reimburse Water Fund Balance for Mary's Lake Water Plant Expansion / Treatment Upgrades 2. Metal SCADA Sampling Building: Remove Big Thompson WTF, account # 503-6300-540.25-02 a. Request approval to purchase metal 8 x 14' building from US Chemical Storage at a cost of $22,422.00 3. Bureau Area Replacement, account # 503-7000-580.35-54 a. Request approval of the design engineering IT Department No items REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Water Financial Reports II No reports Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. hp LaserJet 3015 HP LASERJET FAX invent Oct-15-2007 3:34PM Fax Call Report Job Date Time Type Identification Duration Pages Result 919 10/15/2007 3:30:47PM Send 5869561 0:37 1 OK 920 10/15/2007 3:31:29PM Send 5869532 0:35 1 OK 921 10/15/2007 3:32:09PM Send 5861691 0:41 1 OK 922 10/15/2007 3:32:55PM Send 6353677 0:33 1 OK 923 10/15/2007 3:33:35PM Send 5771590 0:42 1 OK TOWN of ESTES PARK Utilities Deparlment ESTES PARK INTER-OFFICE MEMORANDUM COLORADO DATE: October 10,2007 TO: Utilities Committee FROM: Mike Mangelsen SUBJECT: Net Metering BACKGROUND In November of 2004, Colorado voters passed Amendment 37, a renewable energy requirement. The initiative requires Colorado utilities with 40,000 or more customers to generate or purchase 10 percent of their electricity f rom renewable sources by 2015. The initiative establishes a standard rebate offer for solar electric generation equipment and a state-wide net metering system. Because it has less than 40,000 customers, the Town of Estes Park Light and Power Department is not subiect to the requirements of Amendment 37. However, due to social pressure and concerns about global warming and climate change, the Light and Power Department has been approached by several citizens requesting that the Town provide a net metering rate. In the spirit of cooperation, the Light and Power Department has worked through the Intergovernmental Agreement (IGA) with the City of Loveland to develop a cost neutral net metering rate. See attached documentation. When used in conjunction with on-site renewable generation (i.e. solar or wind), this type of rate allows the customer/generator to sell back to the utility any excess generation. BUDGET N/A RECOMMENDATION Staff recommends implementing the cost neutral net metering rate. Residential and commercial customers on this rate will buy energy at the retail rate from the utility. Customers will be able to sell any excess energy back to the utility at the established renewable generation rates: RESIDENTIAL COMMERCIAL Base Charge $4.36 $7.91 kWh charge from utility $0.0863 $0.0857 kWh buyback paid lo customer $0.0220 $0.0200 1 - Net Metering 91 Revenue Comparison of Net Metering Rate Estes Park RESIDENTIAL average residential customer average usage solar production revenue (kWh) per kW (kWh) $47.51 500 112 RENEWABLE NORMAL BILL - RENEWABLE BILL - Off the grid BENEFIT - Rate 1 equivalent difference Excess Total Base Charge $4.36 $4.36 Generation Generation kWh charge $0.0863 $0.0863 (kWh) kWh buyback $0.0220 Z 0 56 0 .5 kW $42.66 $42.68 $0.02 0 112 Â£ 1 kW $37.83 $37.84 $0.02 36 224 G 2 kW $30.48 $31.29 $0.80 125 336 2 3 kW $26.54 $29.30 $2.76 226 448 g 4 kW $23.37 $28.35 $4.98 331 560 cn 5 kW $20.45 $27.75 $7.29 COMMERCIAL average residential customer average usage solar production revenue (kWh) per kW (kWh) $120.17 1372 112 RENEWABLE NORMAL BILL - RENEWABLE BILL - Off the grid BENEFIT - Rate 1 equivalent difference Excess Total Base Charge $7.91 $7.91 Generation Generation kWh charge $0.0857 $0.0857 (kWh) kWh buyback $0.0200 0 56 .5 kW $120.74 $120.74 $0.00 0 112 1 kW $115.94 $115.94 $0.00 0 224 % 2 kW $106.34 $106.34 $0.00 0 336 w 3 kW $96.74 $96.74 $0.00 6 448 ~ 4 kW $87.53 $87.65 $0.12 62 560 ~ 5 kW $81.61 $82.85 $1.24 138 672 E 6 kW $77.00 $79.76 $2.76 228 784 g 7 kW $73.31 $77.87 $4.56 322 896 0 8 kW $69.89 $76.33 $6.44 420 1008 9 kW $66.73 $75.13 $8.40 521 1120 10 kW $63.77 $74.19 $10.42 2 - Net Metering Net Rate Avoided Cost Determination of Avoided Cost Credit Power Supply Cost for Estes Park per Customer Residential Coincident Coincident Power Potential Demand Demand Supply Benefit Avoided Charge Factor Cost Granted Cost Demand $11.71 1.11 12.998 20.0% $2.60 Energy 8.250 100.0% $8.25 Total Avoided Costs 21.25 10.85 kWh Sales per Cust 500 Avoided Costs $0.022 Commercial Demand $11.71 2.724 31.898 20.0% $6.38 Energy 22.638 100.0% $22.64 Total Avoided Costs $54.54 $29.02 kWh Sales per Cum 1,372 Avoided Costs $0.021 Energy charge is $0.0165 per kWh preparded by dk 9/19/2007 3 - Net Metering LO ++ # - 01 ' . CO . 01 . P = C\1 0 .~ .. 1- . 4 0 . m . N 4 Net Meter 2 -+-Avg Res Load ~ -I- 1 kW 2 kW E 1.500 -- 3 kW 01 6L BL LL 9L GL *L EL EL LL OL 6 8 2 9 9 Estes Park Avg Day Res Solar Usage Aeo JoinoH 3.000 2.500 000 L 2.000 - - â€¢ 000'0 TOWN of ESTES PARK Â® ESTES PARK Public Works Department COLORADO INTER-OFFICE MEMORANDUM DATE: October 5,2007 TO: Utilities Committee FROM: Dave Mahany / Bob Goehring SUBJECT: Secondary Wire Trailer Background: The Light & Power Department budget includes $15,000 for a new secondary wire trailer. The trailer would be use for transporting secondary power wire to the job site. The trailer has a turret to better align the wire reel when un-spooling wire in tight areas. CosUBudget: Cost: Sauber Manufacting Company - Virgil, IL. 2007 Sauber Model #1519 Turret Wire Trailer $14,439 Freight $ 1,250 Bid Price $ 15,689 Sherman & Reilly Inc. -Chattanooga, TN. 2007 Sherman & Reilly Model TRT-172-6K-T Turret Wire Trailer / f.o.b. factory Bid Price $18,500 Henry & Wright Corporation, - Cleveland OH. 2007 Henry & Wright Model # Single Turret Wire Trailer ................. NO RESPONSE Budget: $15,000 (Acct # 502-6501-560-26-43 / p. 348). Additional $689 can be taken from account # 502-7001-580-34-42. $260,000 was budgeted in this account for a Light and Power bucket truck that ended up costing only $211,451. Cost: $15,689 Action: Staff recommends: Purchasing the Secondary Turret Wire Trailer from Sauber Manufacturing Company, Virgil IL. for the cost of $15,689. 1 - Secondary Wire Trailer ' TOWN of ESTES PARK Utilities and Public Works Departments ESTES PARK COLORADO INTER-OFFICE MEMORANDUM DATE: Elktober 12, 2007 TO: Utilities Committee FROM: Bob Goehring SUBJECT: Reimbursement Resolution: Mary's Lake Water Treatment Facility Upgrade Background The Town hired HDR Engineering to do the design for Phase 1 Mary's Lake Water Treatment expansion and upgrade. The design will be used to change the filtration system from rapid sand to membrane type filters. This modification will also increase the filter yield from 2 MGD to 4 MGD. HDR will spec and bid the membranes to determine what manufacturer's membrane will be used for the project. This is necessary for the design of the proposed modifications to the Water Plant as each manufacture requires slightly different piping and electrical configurations. Cost estimated for the membranes is $1,200,000. In Elktober HDR will bid this equipment. The Water Department will be required to prepay 10% or approximately $120,000 to start the manufacturing process and to provide shop drawings to HDR. The remainder will be due in January of 2008. ($1,080,000.) These funds will initially come from the 2007 and 2008 Water Department Budgets, but will ultimately be paid from the Bond proceeds issued in May of 2008. The Reimbursement Resolution is necessary to maintain the Tax Exempt status of the Bonds. Budget Account # 503-7000-530-32-22. Cost estimate for membranes: $1,200,000. Recommendation Staff recommends doing the Reimbursement Resolution at the October 23 Town Board Meeting to maintain Tax Exempt status of the Bonds. 1- Reimbursement Resolution . RESOLUTION NO. A RESOLUTION OF THE BOARD OF TRUSTEES OF THE TOWN OF ESTES PARK, ACTING BY AND TRHOUGH ITS WATER ACTIVITY ENTERPRISE, DECLARING ITS OFFICIAL INTENT TO REIMBURSE THE TOWN WITH THE PROCEEDS OF A FUTURE BORROWING FOR CERTAIN CAPITAL EXPENDITURES TO BE UNDERTAKEN BY THE TOWN; IDENTIFYING SAID CAPITAL EXPENDITURES AND THE FUNDS TO BE USED FOR SUCH PAYMENT; AND PROVIDING CERTAIN OTHER MATTERS IN CONNECTION THEREWITH. WHEREAS, the Town of Estes Park, Acting By and Through its Water Activity Enterprise (the "Town"), in the County of Larimer and State of Colorado (the "State"), is a political subdivision duly organized and existing pursuant to the constitution and laws of the State; and WHEREAS, the Board of Directors of the District (the "Board") is governing body of the Town; and WHEREAS, the Board has determined that it is in the best interest of the Town to make certain capital expenditures on the Project which generally consists of the upgrading and expansion of the Town's existing Mary's lake Water Treatment Facility (collectively, the "Project"); and WHEREAS, the Board has been in contact with the Colorado Water Resources and Power Development Authority with regard to the availability of a loan from said entity; and WHEREAS, the Board currently intends and reasonably expects to participate in a borrowing to finance such capital expenditures, including an amount which is currently estimated not to exceed $5,500,000 (the "Financed Amount"), to reimburse the Town for the portion of such capital expenditures incurred or to be incurred subsequent to a period commencing sixty (60) days prior to the date hereof, and ending prior to the later of eighteen (18) months of the date of such capital expenditures or the placing in service of the Project (but in no event more than three (3) years after the date of the original expenditure of such moneys); and WHEREAS, the Board hereby desires to declare its official intent, pursuant to 26 C.F.R. Â§ 1.150-2, to reimburse the Town for such capital expenditures with the proceeds of the Town's future taxable or tax-exempt borrowing. NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF TRUSTEES OF THE TOWN OF ESTES PARK, COLORADO, that: 2 - Reimbursement Resolution Section 1. Declaration of Official Intent. The Town presently intends and reasonably expects to finance all or a portion of the Project with legally available funds. Section 2. Dates of Capital Expenditures. A\\ of the capital expenditures covered by this Resolution were or will be made on and after the date which is sixty (60) days prior to the effective date of this Resolution. Section 3. Issuance of Bonds or Notes. The Town presently intends and reasonably expects to participate in a borrowing within eighteen (18) months of the date of the expenditures of moneys on the Project or the date upon which the Project is placed in service, whichever is later (but in no event more than three (3) years after the date of the original expenditure of such moneys), and to allocate from said borrowing an amount not to exceed the Financed Amount to reimburse the Town for its expenditures in connection with the Project. Section 4. Confirmation of Prior Acts. A\\ prior acts and doings of the officials, agents and employees of the Town which are in conformity with the purpose and intent of this Resolution, and in furtherance of the Project, shall be and the same hereby are in all respects ratified, approved and confirmed. Section 5. Effective Date of Resolution. This Resolution shall take effect immediately upon its passage. PASSED AND ADOPTED at a regular meeting this day of 2007. TOWN OF ESTES PARK, COLORADO By John Baudek, Mayor ATTEST: Town Clerk 3 - Reimbursement Resolution Water Department Inter-Office Memorandum ESTES 1"21 PARK COLORADO To: Bob Goehring From: Jeff Boles Date: 9/27/2007 Re: Big Thompson WTF Sampling Building Background: Budgeted in 2007 was to remove two abandoned buildings from the Big Thompson Water Treatment Facility and install a metal security building for access, SCADA monitoring and sampling of the existing water storage tank on site. Building Quotes requested and received for complete, electrical wired, 8ftx14ft metal building: United Steel - No quote returned US Chemical Storage LLC - 8 ft x 14 ft Metal Building $17,846.00 Freight $4,576.00 Total $22,422.00 (includes 12 year factory warranty) Safety Storage Inc. - 8 ftx 14ft Metal Building $26,619.00 Freight $2,634.00 Total $29,253.00 (includes [12 factory warranty) Budget: 2007 Budget Account - 503-6300-540-25-02 Budgeted Total for Demolition/Building Installation $98,000.00 Demolition Project Total $37,842.00 SCADA Building Purchase/Installation $22,422.00 Total used from account 503-6300-540-25-02 $60,264.00 Recommended Action: Staff Recommends the purchase of metal 8ftx 14ft building from US Chemical Storage LLC at a cost of $22,422.00. 1 - Big Thompson WTF Water Department Inter-Office Memorandum ESTES|128| PARK COLORADO TO: Utilities Committee From: Jeff Boles and Bob Goehring Date: 10/10/2007 Re: Bureau Area Water Main Replacement Replacement Project Background: Previous staff discussions had taken place with Estes Park Sanitation about working in conjunction with them to replace and relocate the existing utilities within the Bureau of Reclamation area. Both utilities share a common trench that routes through backyards of the properties in this subdivision. In the July 2006 Utilities Committee Meeting the Replacement Project within the Bureau of Reclamation was discussed and recommended for implementation through a 6-8 year phased program at approximately $150,000 annually. Request for Proposals were sent for the Engineering Design of the entire project and provide construction drawings, specifications and bid documents that can be used annually for each phase. Engineering Design requests were sent to the following firms: ROK-Ebilineering Lic_-Total $118,333) Includes: Complete project design, construction and bid documents. Hydraulic modeling for base demand plus fire flow conditions. Task Hours included: 822 $95,210 Sub-Consultants: includes: Surveying, Geotechnical, Potholing $23,100 Landmark_Engineering - - No pâ‚¬oposal returned Nolte_*Â®ociates_lijocTotal - $293726 Includes: Overali System Evaluation Plan, design and con~ruction documents only for Phase 1. Task Hours included: 332 $38,406 Sub-Consultants: includes: Potholing $1,320 RG Consultifig Engineers - Total $34,475 Includes. Complete project design, construction and bid documents. Task Hours included: 430 $33,485 Sub-Consultants: Includes: Potholing $990 Budget: 2007 Budget Account - 503-7000-580-35-54 $200,000 Funds from this budget account have been used for completion of the 2006 Hill Streets, and moved as additional funds available for the meter account. Portion for 2006 Hill Streets Project $36,913 Moved to Meter Account $40,000 Commitment total account 503-7000-580-35-54 $76,913 Recommended Action: Staff recommends accepting proposal for design by RG Consulting Engineers at a cost of $34,475. 1 - Bureau Water Main // 11 A -1 4 U) CD C X w f - E & 2 Â£ 0 1 f Â«--1 1 -1 0 -6 Â£ = 6 1 + 1 /-/ q C CD E P<ZE ~ 1 â‚¬ P Â£ .% 1-r' 3 I Cl = 8 . S . L ' Z E ..%-4/ ~8 a C ~11 1.-------f 1 .1 O .iq 9 #Mi i l i Â·Â·--- rl , 1 r 4 0 1- 21- 1 . /.. /. 4 N \ i' 4 .=. 1 1-ki P )'Lo ' 21 11 ~ /2 1 mA / 25 0 1 /4 ,/ V V 4 1 15/ 0 /-9/ , 21' L7===a' ME /1. f /, / \tk /// t/Pr m'- r./i#. 0 ter: 1 e .1. .--4 / \SA 4//>/= ) adr /\ I luv r-- \ ...49-1 Ok f N / 4 ''/- ' \4 .'-C.â‚¬6 Â¢ N 0 (9 IiI 2 - z z , * r. i -=/- Ul U.1 S - . M. 4 U al<Â£4 / /*40 y/AN >Al--1 -1 :,If~ Â£ C Ill / \ 111 \1 / lA / / /-1 Â· ,~- 42 -62 2 1 9 - --- 0 72"-7 - 1 \43// l- 1 4 /4, --11 5 --'/ n /A'.l 1\67=' 0 75 4 1 1- u \ 4 \\4/ /,7=:43,23 - Â« r'-1 2-2-7 ~ ~'~~â„¢7rmN~7,+~ - -/1-21 Â¤, 4 ~On 1 - ---1.90 CE--2-hte'A L -4:, 1 L.01 L--1 - | 1 - m-â€ž - U 1-' U I 1- , , 74-3 F f 1 --71 - 1 E--f 1-4 \- -1 L: 'n__~ -9/ f ' ~ Â· 1 1 ' i i 1 1 D i 1/f//_ a-1 ,-[1-flo - - 11 n C-1 1 1 r 11 1 1.- / L FRIE e- 'iMÂ©h-[ a 1Â»24*442241 J A 77'hjw, n A 41 - -Baci-taH A . - 2 - Bureau 1 Town of Estes Park Water Department Pavement Structures + FIREHYD sezis pue suo!Wool Jo ealuejen pue,UMOUM jsaq, S! Pal u seld uo! - 133:I 09Â£,9 = OBSOdOkld SV .1.~W339-Idakl =IO 1333 86:'9 = 030Â¥-Idall 01 3dld 1333 0002 = SaNFI 3OIAÂ¥3S eouekeAuooie681 Finance, Light & Power, Water Departments Memo To: Utility Committee Town Administrator Repola From: Steve McFarland, Finance Officer Date: September 18,2007 Subject: Utility committee report Background Attached the following documents for the Committee's perusal: â€¢ Charts and graphs for/through September 2007 â€¢ Financial statements for/through September 2007. Body Light & Power The cash flow comparison page (right column) shows that revenues (77%) are exceeding the pace of the calendar (75%), and that aggregate expenses are under the calendar pace (total 0&M % = 71%; total expenditures = 65%). Revenues per kWh are up compared to 2006 (.086 vs .084). Expenses are elevated compared to 2006 mostly due to the large PRPA expenditure in September. Charts The green/red chart is positive (green), meaning that generally revenues are trending upwards. This is also reflected in the "L&P Revenue Progress" chart (note the red bar increase from May - this makes 5 months in a row - although September was virtually flat - and is now forecasted to exceed the annual budget). The new charts also reflect progress. The "Actual L&P revenues over/beyond budget" chart shows that compared to budget (ratio of actual to budget), we are ahead of where we were at this time last year. This is portrayed in bar chart form on the next graph. Comment from two months ago: "Revenues vs. budget really "took off' in September last year - it will be interesting to see ifthat trend recurs." So far, 2007 trends are very similar to 2006. September did not increase at the same pace as in 2006, but we are still further ahead of budget than we were at this time last year. Water Revenues are quite a bit ahead of calendar pace (93% vs 75%), largely on the strength of the non water-sales categories. Revenues per gallon have also increased over 2006. Interestingly, 'rrotal Gallons Used" has decreased 3% from 2006 (Conservation? More precipitation? Temperature variation?). Overall expenses are quite low (61%). Customer billing is at 82% of budget primarily due to meter purchases of $130,000 vs. budget-to-date of $83,000. The annual line item for meters was $125,000, so we have adjusted for this item in the budget process. The green/red data page is mostly green, which means that the general direction for water sales is "up': As can be seen on the "water revenue progress" graph, projected revenues are still well in excess of budget, and we are in fact at a Mhigh water" point for the year. The last two graphs show that while revenues are on pace to exceed budget, they are now forecasted to do so at a slightly lesser pace than they did in 2006. In fact, the "Actual water revenues over/beyond budget" graph shows that we are almost exactly at the same ratio of actuals vs budgeted revenues as we were last year. SEPTEMBER COMMENT I will start giving the committee a verbal update on the large capital projects on a monthly basis. Conclusion Both utilities look very strong financially. Action steps requested - None. 2 â€¢ Page MONTHLY PEAK DEMAND 25500 23500 - -- 21500 -0-2005 - - -1$-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 F 54 12,000 - 4 -- - - 1 -rt 10,000 --~ ~~~4 - FEF-- 7-- 5 - -05---0-4.- 7% P %4 $ i d-<,y 71 4- FF H 0 f - 8% 1 1 -31 41 -2 g *i *i ji bi %3 09 02005 8,000 2 -% 1 4 4 -8 -09 -8 0.1 -M 8 04 11 29-5~- 02006 0 2007 0% 0 ,/ k. 43 09 C #g 44 44 5. 4 A *t 0% 0 0< 04 6,000 - - 9 -01 -01 -8 -11 -03 -01 -94 -02 -04-93-09~- *4 04 09 4% 32 6% #* 04 4,000 ~ _-~ _.~i _fl _~ _~f _j{: _~f _4 -jii -4-R- 0% 23 2 5% 0 04 4 9 4 9, 0, h 03 39 03 3% % 40 #24 0/ 01 44 44 2,000 _ ** , 43 1 4% 1 {ff- , %2 t ME i #.M ~ 4.* ~ *;. *,M. 1 %0; , $.# Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 Monthly MWH SYSTEM KW 72*~~*Â« YTD ENERGY PURCHASES 140,000 120,000 - 100,000- - 2.04% YTD 2007 VS 2006 80,000 12005 0 2006 60,000 - - I 2007 40,000 - 20,000 ~ ~~ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD POWER COST vs. BUDGET ($1,000) MBUDGET Â¤ACTUAL 5,000 4,500 90 - A M 4,000 72 :.2 2 4 3 m % 3,500 2 a 'reÂ¥% 3,000 2 -4 M --- 941-- 2,500 K - Â§:i -E %> 52 - - 4 2,000 tr 1 -0 ----- 9 M 2% 3 % 1,500 3r -Â¢ - ~ -- 4 *X A ... BF 4% 28 1,000 - 11 *1 0 4 *1 -E -m-%6- - 88 43 13 #1 $ 84 - "M 44 500 --Ar -I 1*1 1--illi-4 A M M ESâ‚¬ * 2% 41 :0 4 -M- :81 F:Â·.:1 r.:_ 24 Rk Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 YTD MWH Purchased ELECTRIC SALES BY MONTH ($1,000) 1,200 - - 1,100 - T- 1,000 -- f -- 900 - -= 3 -- --- T -- -r f. 4 - 02005 4% 1 f C. I. - Â·Â·Â· 7 1 : 3 02007 3 3 3% 5 0 1 I~ i tt * 1 _ 3 111 _ l it _ i E - 1 f - 111 - 1 $ 600 --5 1 -13 -: 7 -1 . - : A - , '* 1 2 1 4* .Â·4+ 9 ./0 le "ll l.l & ..9 + I . I. I :26 .1 t. I 0 4 4 0 - i I P. 2 4 1 . 4 4* 500--20 -ti -51 -tÂ·. -:i .. - 1 1 24 /4 ; 'Z 2 41 4 49 29 i 3 . .1 3; 1 i': I .4 $ 4 52 4 1. . t *.5 400 -52 -4 -4 1 -0 -25 -el --9 -i It -3* -: { --- A---- ~~ qi i, A Â£ . 7 4. .2 2 i i ~h >t 45 Lk ?4 :/ tl >E M. . q. 1 9 300 -fi : ~.4,; 12'101Â¢.1:7 6-2 1 1.* 1 :,f , 21; i *1 1 14-23 lii i Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR TO DATE ELECTRIC SALES ($1,000) 12,000 - 4.66% 2007 YTD VS 2006 10,303,317 10,000 - ' -. ..0. 2005 8,000 -- - --- ~ 2006 y ' 6,000 - - 02007 , 44 ,/ . e - Budget 4,000 - . DE ~ C : : 1 - ~ - = .Â· i & 24 :* 31: 01: -1 -,2 --*= --1 HIpt -fit-/-1---~-~- 2,000 .% IL ~) 't 4 ' :11 - ..13 -- ./. -7. I.'r -0 o _ 1711 N 1 5 1 3% f: 3 11 3 ' 1 1 .: , 0 -: i Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 8 YEAR TO DATE SALES MONTHLY SALES I ./~4 I < : I 32 112 iffif fiE Â£ 0 Â§ E 1--Ch hÂ©t--â€¢r,At- Me 08 6 . 2 * 0 K m f 4 R i B- n . <*R ** 00 #% E.3-E 2220 REF *5~ 2 2 -- % 9%* 332883 0,-10040,6 - 000 doodd 3%% ood gm* /1 2~ Q M 4 0 R & 0 3 5-~5* ag 0 VV 108 0 25Â§ 01 9. M h 00 00 flzz 222 U N 2 1 2 Ul * 3 73 8 0. 059 5 f i -M - I i = 2 W 56 gi .0.Â¤0<0 m' R 2 =.0 9 NE g = 2 7.2 &05 9 E 2 BR 220 m M 1- 60 0 %LI 0Lf'Of Ott'00Â£ 00'0 I 00'0 089't 0Lt'09 0Â§1'59 20!Alos iqaa MONTH TO DATE YEAR TO DATE BUDGET vs. YTD %0Â£ Â£96'Â£017 LEI '8ZE' I too 0 Â§00*0 ELI'OS Â£96'E0* 9EI'MD 65E'E 66Z'6I 859'ZE Â· le)!deo %8L 65L'+9L 399'*L6 800'0 LOO'O (E.L.801) 65L'*9L 9I0'959 (EL) â‚¬5CEL I 81'EL tne S.Igstle.1 Bu! 191@d~ 5,241,517 3,195,309 $3,195,309 $3,195,309 100% 324,945 1,03~,098 (707,153) 3,318,866 3 64 (445,375) 0.035 0. 4,785,000 ,764,241 bution and M ' tenance 134,59 27,928 1,098,216 1, 04 21,312 1,076,90 Total O&M Expenses 598,357 1,269,4 (671,06 ) 5,580,066 6,229, (649,391 10: 8,786,013 6,229,464 %99 999'8Â»'L En'68Â£' I I 8L00 EL0'0 (885'EOL) 999'8*17'L 89E'5*L'9 (ZWL'L99) 8L6'I 9Â£'I 961't,69 soinlipuadx3 11401 8*5'0*9 V/N 8,5,0,9 8,5,0,9 0 (0*5'16) (0*9'16) 0 SOiinOS 101[10 01 PNBOOI[B~p@A!0001 tise) 56*'LEVI (051 ..9) 898'IIÂ£ 56â‚¬LEVI LZ9'SEI'I (9Z6'Â£6L) (EIL'809) FIGBI tpUOIU 101 uouisod tiseo u! @Sueqj '08'229'*$ 651'IWE$ '08'ZÂ£9'*$ +08'3Â£9'M eoueleq puni (alqesn) pajouls@Jun Su!PuEI L*6'96L (091Â»9) (089'8ZE) Â£176'96L Â£19'5ZI' I (98Â£'ZOL) (ELI'LIS) Â£13'581 (161!de) alopq sain,!puodxa VAR VAR Per kWh Per kWh r Billing and Accounts 61,691 100'6% 10,711 416,033 (63,747) 0.00~ stration and General 77,129 (2,555) 746,951 (161,588) 0.008 3) 7,525,738 7,876,320 350,5 345,257 604) 7,870,995 8,2 LIGHT AND POWER FUND COMPARISON 1@AO SOnUOA@130 kou@!OUOp/SSOOXH) Imolqns TOWN OF ESTES PARK LIGHT AND POWER TRENDS Type Summary Date September-07 12 - month moving average Total % Total % of Avg Avg Avg # of accts KWH Growth Revenues Total Rev % Cum Rev/KWH KWH/Cust Rev/Cust Residential 7.498 4,003,503 -0.2% $372,500 43% 43% $0.0934 534 $49.68 Gen Serv Small 1.625 2,119.971 0.2% $193,040 22% 66% $0.0911 1,304 $118.73 Gen Serv Large 93 2.822,606 0.4% $172.232 20% 86% $0.0611 30,339 $1.851.69 Residential Demand 381 719,222 -0.2% $63,727 7% 93% $0.0908 1,883 $166.74 Res Energy / Time of Day 245 412,211 -0.2% $26.372 3% 96% $0.0660 1,680 $107.46 Municipal 62 258,087 0.8% $20.407 2% 99% $0.0792 4,227 $334.06 RMNP- Small Admin 21 67,811 0.2% $3.122 0% 99% $0.0461 3,193 $147.02 RMNP - Large Admin 6 62,299 -0.1% $2.740 0% 99% $0.0444 10,383 $456.61 Res Basic Energy 19 24,831 0.9% $2.176 0% 100% $0.0886 1.307 $114.36 Wind Power 107 0 0.0% $1,625 0% 99% N/A WA N/A GSS - Comml - Energy TOD 13 17,444 -0.3% $1,220 0% 100% $0.0706 1,342 $93.86 GSL-Comml -Time of Day 1 10.880 2.8% $775 0% 100% $0.0722 0 $0.00 Outdoor Area Lighting 16 0 0.0% $234 0% 100% WA N/A N/A Res Time of Day 0 0 #DIV/0! $0 0% 100% #DIV/0! #DIV/0! #DIV/0! RMNP - Administrative 2 795 -2.6% $43 0% 100% N/A N/A N/A 10,090 avg $860,213 100% annual revenues at this pace: $10,322,560 budget: $10,208,573 projected over/under: | $113.987 | 11 j-JIJ-~-Jill -4-.1-4.-#.-4-- 9 5 _1 1_1 L&P Revenue Progress $10,500,000 $10,100,000 - m Budgeted Revenues $9,900,000 -- â€¢ Re~~enues at Current 04 %24 $10,400,000 $10,300,000 - $10,200,000 -- - $10,000,000 - - 000'008'6$ - 000'002'6$ - 000'009'6$ - 000'009'6$ ~ 63 442*y*%4ft~ 9. O Budget ienjov li ZOOZ 9002 Annual L&P Budget v Projected Actuals, through September 2006/2007 $10,400,000 - $10,300,000 $10,200,000 $10,100,000 $10,000,000 000'006'6$ 000'008'69 000'002'6$ 000'009'6$ 000'009'6$ 000'00*'6$ 6- .g % 900Z - ZOOZ - oea AON Actual L&P revenues over/beyond Budget 3.00% 2.00% 1.00% %00'0 %00 L - %00 Z- - %OOP 10/15/2007 Water Sales by Month ($) 350,000 300,000 --0. - 250,000 --- 71-J 7 3 j t' , % -7 200,000 / / Â¤2005 ,t,t 1 ,7 02006 02007 150,000 -~ -17 1 -r ~~ | ~| ~~ 't I tr // /1 t- 1 I V. / ./ El 51 : , ft 100,000 / /i /5 F=!/1/ ,t, 552 5 0, fi 5 / /1 5 Bri #i / / 4 4/ 51 / 4 7 , 1 50,000 / /i / 4 4 $ 0 4,5 1 1 / t 1 1 , 1 4 : : 8 1 I , 1 Li -4 1- -11-8 4- 4 4 3- -4. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Water Sales Year-To-Date ($1,000) 3,000 $2,816,572, 2,500 - ------- ----- ------------- 02005 - T - 2,000 -----Â·- -- M2006 ~2007 1,500 _ _ _ _ _~ - Budget _ ____ _ /1 9 4.44% 2007 YTD VS 2006 3 /1 4 1,000 ---7rl- -37 1 4 ~ 1 ) f 500 1 A el k 1-1 4 4 4 (1 4 11 ., 4 --e 0 LL- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 '111--11-ead ~ tÂ«\>aaÂ»Â«i. 63â€žXVNXÂ©00Â«NX<%36>63 t<Â©o........".>6>63>ax~,>06\.*.#m"~><~xvÂ©<vvv~ 2 1% i 22222 2= 2= f f f f 22 22 j f 0 -0 5 0 -ggcm 3222&02 87 g -- In 'A C\01- ==2R=Â¤K AS!*RZ I .1 0 01 % 0 -F >â€¢ M 3 ff ti gi j :f Â£Â¢3%9 6 W Â¤1.-1-NA r.1 = "00000 \00\\000 Eqclvel, 253 g EMBEE #EM r MOO 19 1- O 4 4 4 Â§88Â§ 838838 000000 code 0006Â©06 00-or- 0 gggg Â§88 8 odded de= d MQâ€¢rleÂ© 23EA ~Der-O 23 Ken 01 %2*~ 16 .1 rn B CH~000 0 M 0 v cr, 01 - eL b O 9 1 - 5 5 &28R E o M ~ 1 M r M M n M 0 - el 520000. "hooNÂ©- M Q 0 â€¢n rn 'A rn , 00 en ,-1 ,0 V # W =07 T O 1,1 00 en er; _ %% 4404 N St *RERit Ot-â€¢AeW DEGIZAO C,flt--'l\O #422% 1 0, c .1 0 @â‚¬ 0 1-:2 9-3gi /%3 ~ 01 1 00 r. E CE 2 %19 *69'6EI'E Â£6Â£'BEG'E LEO 900'0 (8*0'96) 469'6Â£ I'Z 9 6/9'60 9Â£9'Et,5 sam)!ptiodxg Fol GEE'811 EOL'Â£64 000 0 000 0 (E[Z'5,) SEE'81 I (66000 I It'89 ZIO'BE re}!deo )6Z'69 I80'00[ 000 0 000 0 (598'LI) *61'68 (805'1) POL'OI 96I'6 tno siolsuluj Builmgd~ MONTH-TO-DATE ONTH TO DATE YEAR TO DATE YEAR TO DATE 2006 2~ 2006 2007 2007 of 1 01 0If'90Â£ 100*0 1000 (tâ‚¬8'E) 0 It'90Â£ (L[t'R) COE'BLE 88L'69Z 03/Alas tqaa Lt,8'909 (541'585) BL 9'06 1 Lts'509 69E'flt 69' t I (9[L'+91) (Z609Â£1) (Ieudeo woJoq smnitpuodxo 906'801 V/N (906'801) 906'80I 0 /6E'I (16E'I) 0 saamos 104,0 01 paiuootle/po/Moooi qsro GL'fIL (g!.685) *8*'66E EL't,IL 69E'Â§ It 59E'01 (LZO'991) (260(41) tpUOUI 10.1 uo!1! sod lisED u! 0; Ut?q) 96'I!02$ LfO'ZIL'Z$ 96'110'+S 96'110'*$ ooucieq puty (0{qusn) poloulsgiRIn fimpuE[ VAR VAR Per Gal Per Gal Budget Beginning unrestricted (usable) fund balance 4,177,972 3,297,192 $3,297,192 $3.297,192 1 Source of Supply 27,924 (1. 09) 137,307 12 ,648 14,659 146,531 lion 34,871 10, ,830 37 ,245 41,648 299,519 49, 1,889,490 1,973.375 83,885 .00 0.006 100'0 sjunooov pue Nu,II'S 19 80'0 600 0 (L!1'60 99'6Z97 1 0+9'512 asuadxg Joueuolu,EIN pue uo!)1313do Imol C 58Â£'t,5 @ouuu@wiu IN puu uoun P an Development Tap Fees 7 16,874 (6. ) 134,295 147,525 13,230 er rights Tap Fees 5 49,627 (18, 6) 302,300 422,869 120,569 18,773 (6. 9 ) 133,830 01, 67,942 384,793 18 4 2,459,915 2 45, 285,626 CASH FLOW COMPARISON Operation and Maintenance Expense LOAO SanUOAOi.;0 KOUO!01.jop/ssooxE[) le}olqns WATER FUND Administration and General 2007 vs. 2006 Revenues Expenditures | Svil 6ES ] :lopun/LOAO poloofold ELS'SVE'Â£$ :*Spnq 0 1E'LES'ES :ooed s!41 w SanUOAO.I lenUUE %001 fit' 1 IES SAU 600'0$ %00! %9 9L1't 1$ %Â§L- ROE'toG' 1 101Em linS ZE*801$ 516'51 El 00% %t6 %5 Z10'01$ %5.5- SL9'8Lt' 1 Z6 le!<)10URLIOj le.In*I WL' I ti 9/f' E 2 10 0$ %68 %91 lÂ£9't'99; %95 960'905'f 8 017 1 le!1UopISON lulnÂ·M Â§L'OLS 6*X'L 1 t()0.()S %Â£9 %97 Elt'495$ %6'1 Â£66'1706'l I 6LL [u!010URUO~) Ilegn NO'62% *59' f LOC)'0% %LE %LE ()00Â¢Lt %9'0- IL9Â»CE 1 069'E [Enuop!SOM ueqin lEno/Aoll lEno/leD [E{)/AOM UInj SAO}[ 101 SonUOA@k[ 417Â¥~019 109 SloOE JO # SAV SAV SAV Jo % JO % [1!101 % 18101. 38810AE SUMOUI IRUOUI -ZI LO-loqulaides olea Kimuums adki SCINEnil 1Na]Al.LMVdna Ma.LVM Nliyd S31$3 210 NAAO.L fia -<0 --'.1-1-J,6 - <04, === = = -<34 <0., Water Revenue Progress $2,500,000 $2,300,000 - 0 Budgeted Revenues jllernj le SenlleAeal â€¢ - 000'000$ 00 %04 4 $2,450,000 - $2,400,000 - $2,350,000 - $2,250,000 - - 000'09 L'1$ - 000'OOLIES - 000'090'1$ - 000'000'1$ f~~ ~- Â«i*~~Â·i --- -:*:rz.gw<. : IN"ilia. Annual Water Budget v Projected Actuals through September 2006/2007 O Budget lenlovl I ZOOZ 9001 $2,600,000 $2,500,000 $2,400,000 $2,300,000 000'001'1$ 000'OOL'1$ 000'000'ZE 000'006' LS 2 /3 C) 00 > 0 Â® C 00 > 00 6- m A CO a < L- co -2006 ZOOE - Dea AoN 100 des Bnv Inf un J qed uer 16.00% 14.00% 12.00% 10.00% %00.8 %009 %00.4 %00-Z 9000 0 . ELKTOBER 2007 UTILITIES COMMITTEE NOTE: The following reports are not included in this packet: Water 2. Prospect Mountain Water Company - verbal report from Bob Goehring