The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2007-03-154 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, March 15,2007 Preparation date: March 9,2007 ACTION ITEMS PUBLIC COMMENT Light and Power Department No action items Water Department 1. Replace Truck # 9033 a. Request approval to accept low bid 2. Replace Truck # 90311 a. Request approval to accept low bid 3. HDR Scope of Services for Population Projection a. Request to spend $14,808.00: $7,808.00 to be paid by Water, $7,000.00 to be paid by Comprehensive Plan Funds REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Annual System Flushing 2. Water Financial Reports Administration 1. Electronic Agenda & Supporting Documents Note: The Utilities Committee reserves the right to consider other items not available at the time the agenda was prepared. *> -L hp Laserlet 3015 140 . HP LASERJET FAX invent Mar-13-2007 8:32AM Fax Call Report Job Date Time Type Identification Duration Pages Result 163 3/13/2007 8:28:08AM Send 5869561 0:35 1 OK 164 3/13/2007 8:28:49AM Send 5869532 0:49 1 OK 165 3/13/2007 8:29:43AM Send 5861691 0:53 1 OK 166 3/13/2007 8:30:41AM Send 6353677 0:49 1 OK 167 3/13/2007 8:31:35AM Send 5771590 0:57 1 OK AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8:00 a.m. Thursday, March 15, 2007 Preparation date: March 9,2007 ACTION ITEMS PUBLIC COMMENT Light and Power Department No action items Water Department 1. Replace Truck # 9033 a. Request approval to accept low bid 2. Replace Truck # 90311 a. Request approval to accept low bid 3. HDR Scope of Services for Population Projection a. Request to spend $15,710: $8,000 to be paid by Water, remainder to be paid by Comprehensive Plan Funds REPORTS: Light and Power 1. Light and Power Financial Reports Water 1. Annual System Flushing 2. Water Financial Reports Administration 1. Electronic Agenda & Supporting Documents 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 Mar-12-2007 1:41PM Fax Call Report Job Date Time Type Identification Duration Pages Result 156 3/12/2007 1:37:16PM Send 5869561 0:35 1 OK 157 3/12/2007 1:37:58PM Send 5869532 0:47 1 OK 158 3/12/2007 1:38:50PM Send 5861691 0:54 1 OK 159 3/12/2007 1:39:50PM Send 6353677 0:49 1 OK 160 3/12/2007 1:40:44PM Send 5771590 0:57 1 OK I , TOWN of ESTES PARK Inter-Office Memorandum March 12, 2007 TO: Utilities Committee FROM: Bob Goehring / Dave MahÂ£my SUBJECT: Budgeted Water Department 1-Ton Truck Replacement (9033) (Acct # 503-7000-580-34-42 / p-403) Background: The 2007 Water Department budget includes $45,000.00 for the replacement of Vehicle 9033, 1974 Ford F-350 1-Ton Flatbed, 33 years old with 32,637 miles (Replacement Type 1, 80,000 - 90,000 miles or 10 years - this vehicle is NOT included in the vehicle replacement fund). Cost/Budget: Cost: â€¢ Spradley Barr Ford - Ft. Collins, Co. 2007 Ford F-350 4x4 w/utility body... ................................................. $44,896.77 Trade-In - 1974 Ford 1-ton Flatbed .. ... -$ 1,000.00 Bid Price $43,896.77 â€¢ Weld County Garage - Greeley Co. 2007 GMC K-3500 4x4 w/utility body.................... ......................... $46,408.00 Trade-In - 1974 Ford 1-ton Flatbed .. ... -$ 800.00 Bid Price $45,608.00 â€¢ Phil Long Ford - Colorado Springs, Co. 2007 Ford F-350 4x4 w/utility body. ..................$49,576.00 Trade-In - 1974 Ford 1-ton Flatbed . ,.. - $ 1,500.00 Bid Price $48,076.00 â€¢ Transwest GMC - Henderson, Co..........................................NO RESPONSE â€¢ King GMC - Loveland, Co. .... ........... .NO RESPONSE Budget: $45,000.00 (502-7000-580-34-42 / p-403) Cost: $44,896.77 Action: Staff recommends: The Special Events Dept would like to purchase the 1974 Flatbed from the Water Dept for the trade-in value of $1,000.00 - Staff recommends purchasing a new 2007 Ford F-350 4x4 w/utility body for a cost of $44,896.77 from Spradley Barr Ford, Ft. Collins, Co., transferring the trade in vehicle (9033) to the Special Events Dept with the $1,000.00 trade-in value being paid to the Water Dept. by Special Events.. TOWN of ESTES PARK Inter-Office Memorandum March 12, 2007 TO: Utilities Committee FROM: Bob Goehring / Dave Mahany SUBJECT: Budgeted Water Department Pickup Replacement (90311) (Acct # 503-7000-580-34-42 / p-403) Background: The 2007 Water Department budget includes $25,000.00 for the replacement of Vehicle 90311, 1997 Jeep Wrangler 4xt 10 years old with 71,178 miles (Replacement Type 1, 80,000 - 90,000 miles or 10 years - this vehicle is NOT included in the vehicle replacement fund). Cost/Budget: Cost: â€¢ Phil Long Ford - Colorado Springs, Co. 2007 Ford F-150 4x4 ..... ................. .$20,375.00 Trade-In - 1997 Jeep Wrangler 4x4. ... - $ 5,500.00 Bid Price $14,875.00 â€¢ Spradlev Barr Ford - Ft. Collins, Co. 2007 Ford F-150 4x4 ....................................................................... $19,991.00 Trade-In - 1997 Jeep Wrangler 4x4. - $ 5,000.00 Bid Price $14,991.00 â€¢ Weld County Garage - Greeley Co. 2007 GMC K-1500 4x4 ... $21,200.00 Trade-In - 1997 Jeep Wrangler 4x4.. ... -$ 5,000.00 Bid Price $16,200.00 â€¢ Transwest GMC - Henderson, Co.. NO RESPONSE â€¢ King GMC - Loveland, Co. ............NO RESPONSE Budget: $25,000.00 (502-7000-580-34-42 / p-403) Cost: $14,875.00 Action: Staff recommends: Trading the 1997 Jeep Wrangler 4x4 (90311) and purchasing a new 2007 Ford F-150 4x4 Pickup for a cost of $ 14,875.00 from Phil Long Ford, Colorado Springs, Co. MEMORANDUM Community Development To: Community Development Committee From: Bob Joseph Date: 3-12-07 Subject: HDR Scope of Services for Population Projections Background: The Estes Valley Comprehensive Plan provided an estimate in 1996 of the Valley's build out population. Ten years have passed and it would be worthwhile to revisit that projection to verify or adjust the numbers as needed to reflect current conditions. Staff would like to take this opportunity to perform this update in conjuction with the Water Demand projections that HDR will provide this spring. This will serve both as a Comprehensive Plan build-out update and as an important element in projection of future demands on the Town's water system. $20,000 is budgeted this year for work on the Comp Plan update (101-1100-411.22-98). A scope of work for a Population Projection study from HI)R expands the demand study area to include current and future land use. HDR will review the 1996 Comp. Plan. The engineer will use GIS and zoning information to establish current land use percentages for residential, commercial, and industrial use. HDR will develop a population projection for build out and review steep slope adjustment. HDR will summarize population projections in the form of an expected growth curve and explain how to interpret these results. The additional cost of this work is $14,808 Budget : $7,000 - Funded by Comprehensive Plan Funds 101-1100-411.22-98 $7,808 - Funded by Water Department 503-6500-560.22-02 $14,808 Total for HDR Population Projection Recommendation: Expand the HDR scope of services to include Comp Plan population update for a total $14,808. Finance, Light & Power, Water Departments Memo To: Utility Committee Town Administrator Repola From: Steve MeFarland, Finance Officer Date: March 15,2007 Subject: Utility committee report Background I apologize for not being able to be with the Committee during this meeting. However, I am attaching the following documents for the Committee's perusal: â€¢ Charts and graphs for February 2007 â€¢ Final financial statements for December 2006 (we reviewed draft December 2006 statements in a previous meeting). â€¢ Financial statements for January 2007. Statements for February and March 2007 will be reviewed in the April 2007 meeting. Body Light & Power The "charts and graphs" section of the L&P report is full of "green" and looks pretty good. Revenues are quickly approaching the budgeted level. With the exception of unforeseen audit adjustments, the December statement should be an accurate portrayal of the 2006 financial picture. 2006 was an excellent year by almost any measure. Revenues were up and expenses were down, both on a gross and per/kWh basis. Fund balance exceeded forecasts by - $780,000. Of this, $258,000 is in the form of rollovers, so fund balance is still approximately $500,000 better than was projected. January 2007 statements show gross revenues slightly down (2%) from 2006. However, revenues per kWh have improved. Expenses have also increased over January 2006, primarily due to exhibit and display removal costs of $20,000 in "Admin and General". This is presumably a function of timing. When comparing to budget YTD, 8% ofthe year is complete. Revenues are at 10%, and expenses are at 7-8%, we are right where we would expect to be at this point in the year. Water The "charts and graphs" section of the water data continues to be outstanding. Revenues are already projected to exceed budget by $218,000. With the 2006 financial information all but final, it is apparent that the Water fund had a truly outstanding year. Fund balance was forecasted at around $2,280,000 and came in at $3,270,000. Only about $175,000 of this was from rollover purchase orders. For January 2007, expenses are at about 5%, and revenues are at 12% of budget, through January. These percentages are both on the preferred side of the 8% of the completed calendar year (revenues higher, expenses lower). One area that I would draw your attention to is the revenue section. In January 2006, several journal entries were made involving 2005, thus elevating revenues. This was corrected/adjusted later in the year, but I did want to point this out so that the Committee didn't think that January 2007 water revenues were only halfof that of2006. Conclusion Both utilities look very strong financially. I have met with a couple of bonding entities. They have suggested that I begin the financial legwork on our projects no later than this summer, and I will keep you posted on progress in that regard. Action steps requested - None. â€¢Page 2 MONTHLY PEAK DEMAND 25500 23500 c 21500 -C}-2005] -~-2006 19500 -0-2007 ~ 17500 15500 13500 11500 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES 14,000 12,000 - - --7- 3 - -5 0. 10,000 # j f __ _____ _ _____ 34_ _ _- _ - % 0 * 3%%6017 9- 57 3 7 1 0 7 i ~ 0 2005 %034 et Â£ 4 2 #b 54 0% 4 : 0% / 8,000 $ 4 2% 44 -- 2% 0 -- 0 #ft- g ~ f- 1 02006 4 0. 04 3% *' #w ~ 5% 5 3: â‚¬ 3 4.2 0% 4. 3 4% 3 02007 1 3% #p 42 4 5% 0 0 0 0 0, 0 0: 0 / 4% 112,= ff ;11 i;t 3% 09 4 3 3 4,000 0 4Â£ 41 -- r %Â© $ 3 -9 P# E ~ 0% 1% 2 : 4 4 --_ 4 0 0 #4 4 0% 0% 40 4% E- 2 0- f & 0 1. 0% %1 2 5 4 3 4 1 8 / lili 'iiI 111 2 35 431 45 2% %* 2 4. 47 2, 4 2 000 * ~ 0 U- h U= ~~- I r Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 mmwifiCÂ« wdiff,1 44%4RRE *44#Bir#APNA YTD ENERGY PURCHASES E 120,000 100,000 4.26% YTD 2007 VS 2006 Â¢0 -- M 80,000 .2006 r 60,000 E E 0200~ = 11-11 1 1-G-I ~ 40,000 20,000 ~ ~ ~ ~ - Jan YTD POWER COST vs. BUDGET ($1,000) ~ E3BUDGET ~ ~ Â¤ACTUAL 5,000 4,500 4,000 M 3,500 -0 2 4 % 3,000 2,500 2,000 -- 1,500 - - -- 1,000 - _ 500 -r-, 61 I I A * m i Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 8*:*8**8**8*>: ELECTRIC SALES BY MONTH ($1,000) 1,200 1,100 -r 1,000 j - 900 -7 800 ~ - - 0 2005 .2006 700 Â· - I. . 02007 - . 1, 600 2 6 500 ~ 41 - E- H 4 . 1 4 m Fi _2 , 2 300 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR TO DATE ELECTRIC SALES ($1,000) 12,000 6.00% 2007 YTD VS 2006 ~10,303,317i 10,000 31 1 14 0 2005 8,000 - - C I~ -- I 2006 _,r 1 1 .'. 1 6,000 - 02007 1 1 'F_11 1 1 1 .11 11 - Budget 4,000 - 2,000 - - U Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 8 YEAR TO DATE SALES MONTHLY SALES TOWN OF ESTES PARK LIGHT AND POWER TRENDS Type Summary Date February-07 12 - month moving average Total % Total % of Avg Avg Avg # ofaccts KWH Growth Revenues Total Rev % Cum Rev/KWH KWH/Cust Rev/Cust Residential 7.436 3.947,720 1.8% $358,6~6 43% 43% $0.0910 511 $48.21 Gen Serv Small 1.598 2.074.016 1.0% $185Â»0 22% 65% $0.0897 1.298 $11('.31 Gen Serv Large 92 2.832.119 0.6% $174,275 21% 86% $0.0617 30.641 $ 1.>485.69 Residential Demand 394 727.325 1.1% 564.761 8% 93% 9 ).0944 1.853 $ 164.63 Res Energy / Time of Day 239 408.16>< 2.1% 125.296 3% 96% W.()638 1,7()7 $ 105.79 Municipal 60 253.()48 1.2% %19,710 2% 99% $(~0779 4.247 $33().81 RMNP - Small Admin 20 64,115 3.1% 12,912 0% 99% S().()458 3.214 $ 146.98 RMNP - Large Admin 6 63.795 0.2% $2.696 0% 99% $0.0426 10.632 $449.29 Wind Power 1(H) 0 0.0% 52.224 0% 99% N/A N/A N/A Res Basic Energy 1 8 22.639 6.8% $ 1.944 0% 100% 0.08(,6 1.337 $1 14.51 GSS - Comml - Energy TOD 13 18.147 2.5% $ 1,228 0% 100% $0.0683 1 396 $94.41 GSL -Comml -Time of Day 1 1().795 0.0% $737 0% 100% $0.0690 0 $0.00 Outdoor Area Lighting 16 0 0.0% $223 0% 100% N/A N/A N/A Res Time of Day 1 3.038 -32.50% $83 0% 100% #DIV/0! #DIV/0! #DIV/0! RMNP - Administrative 2 495 0.0% $28 0% 100% N/A N/A N/A 9,996 avg $840.661 100% annual revenues at this pace: $10,087,936 budget: $10,208,573 projected over/under: | ($120,6374 fla 11& ......... 4 42 0 4 L&P Revenue Progress 10,100,000 -- Â£ Budgeted Revenues luenno le SenlleAehl â€¢ - 000'006'6 10,500,000 10,400,000 10,300,000 10,200,000 --- 10,000,000 - - 000'008'6 -- 000'002'6 -- 000'009'6 000'009'6 2* 2 2 2 off 22 m -81 00 8 0"to re. wn M 0 E%t 0 0 58 0 %%% 0000 ,2 2 4 re, C 00â€¢.00 O 0 ER*-9 3*IN 0 0 0 rl tr. 0 v 0 0 E* ZE 0 0 0 5, C rl O 0 - 6- 2 6 * :5 0 0 3 U *23 a : m / al O&M Expenses 661,48 690,370 (28,88 ) 661,484 690,370 (28.886) 0.047 0.053 8,786,013 690,370 8% %0 046'00[ 000*0 000-0 0 20,Al @S lq@C[ %O LZ I 'BEE' I 000*0 000*0 0 191/duo %L 888'Â£8L Zt'L'68Â£'1 I 090'0 Ego*0 (aL'Lt) 888'EBL 9ZI'9EL (Z9L'Lt,) 888'ERL 9Zl'9Â£L soinlipuadÂ¥3 le]01 .000 0.000 0 #DIV/0! inning unrestricted (usable) fund balance 3,195,309 3,195,309 $3,195,309 $3,195,309 1 1,066,002 1,039,084 (26,918) 1,066,002 1,039,084 (26,918) 0.076 0.079 10,208,573 1,039.084 1 % Other 9,822 21,875 12, 9,822 21,875 12,053 0.001 0.002 537,019 21,875 Total Revenues 1,075,824 1,060,959 (I 4, 1,075,824 1,060,959 (14,865) 0.077 0.081 10,745,592 1,060,959 1 % Source of Supply 441,589 484,559 (42,970) 441,589 (42,970) 0.032 0.037 4,785,000 484,559 10 Distribution and Maintenance 60,141 52,850 7,291 60,141 0.004 1,595,754 52,850 Customer Billing and Accounts 67,922 31,525 36,397 67,922 0.002 678,784 31,525 Administration and General 121,436 (29,604) 91,832 1 1, 0.009 1,726,475 121,436 %01 815'Â£6 Z99'fL6 LOO'O 5000 (9L8'81) 81Â§26 Zt9'fL (9L 8'81) 8 I Â§' [6 Zf9'fL ino sioJSUell flutle.lod~ MONTH TO DATE YEAR TO DATE BUDGET vs. YTD ILO'LLE (05 1 't+9) (LZ9'Z9) ILO'LLZ 869'6EE (LZ9'29) ILO'LLZ 869'6Â£Â£ (191!{leo moloq sainitpuodx@ (56/'5) V/N (9609) (960Â§) 0 (96Cg) (965'5) O SJOinOS 10410 01 p.;EOO[lej/paAI303.1 4691 9LL'ILZ (051Â»9) (Z26'L9) 9LL'ILZ 869'6EE (EZ619) 9LL'ILE 869'6Â£Â£ liluoul Joj uolitsod qse, ut 08ueqo 580'Â£917'Â£$ 6Â§1'(92$ 980'Lgf'Â£$ 980'Â£9*'ES joueigq pung (Mqusn) poloinsatun Nuipua JAN VAR VAR Per kWh Per kWh Budg 2006 2006 2007 LIGHT AND POWER FUND COMPARISON Operation and Maintenance Expense 1OAO SOnUOAOI JO KOUQI,gap/SS@OX)) lelolqns Expenditures tti gfigic Â£ 6 0 \0 N Â£ 40 Â§% 00 < E g E 0000 1-nox}â€¢ArN 00 -5- 254 S: g E - a b .EM â‚¬ 5 00<0 u CC 0 - 4 2 E rs Ug Q - T 50 5.0 1%*U 36 â‚¬ ~ U inning unrestricted (usable) fund balance 2,941,422 $2,748,086 $2,748,086 $2,748,086 100% Other 309,546 231,813 (77.733) 824,973 684,850 (140,!23) 0.007 0.006 397,863 684,850 172% Total Revenues 1,138,901 1,128,160 (10,741) 10,209,792 10,658,542 448,750 0.085 0.086 10,138,868 10,658,542 105% %toi Z[9'IS6 EE ['6i6 800'0 L00'0 (869'*5) ZE9'156 tiO'Â£68 *69'Â£ IL9'08 99Z'*8 inO S.I@)SUE.Il Nuiieiad0 ONTH-TO-DATE MONTH TO DATE YEAR TO DATE BUDGET vs. YTD ng net assets (assets - liabilities) $10,811,188 $10,811,188 829,355 896,347 66,992 9,384,819 9,973,692 588,873 0.078 0.080 9,741,005 9,973,692 102% Source of Supply 513,274 467,388 45, 86 4,590,883 4,619,186 (28,303) 0.038 0.037 4,702,000 4,619.186 tribution and Maintenance 130,215 134,141 .926) 1,406,577 1.475,389 (68.812) 0.012 0.012 1,571,262 1,475,389 omer Billing and Accounts 77.167 59,037 604,246 579,955 24,291 0.00 0.005 674,571 579,955 148 1,796 3,488 (1,692) 0.0 3,300 3,488 10 Total O&M Expenses 881,324 774,603 106,7 1 7,826,487 7,779,049 47,438 0.0 8,236,475 7,779,049 9 062'ZOE 00Â£'50Â£ zoO-0 Â£00 0 SOL' 1 06Z'ZOE 966'EOE 010'E (010'0 0 58*'EE9 L09'686 500*0 500 0 (L Â£ I 'L) gyt'EZ9 8*Â£'919 9IZ'8 EZZ'fL 687'Â£8 9.Z6 99â‚¬999'6 515'0Lf'01 8Â£0'0 080 0 (Z65'ZI) 99â‚¬959'6 )98'99'6 Its'IZI Lyf'LZ6 810'6*0' 1 swnlipugdxj lelol dministration and General 160,520 113,73 1,222,985 1,101.031 121,954 0.0 0.009 1,285,342 1,101.031 980'ZOO' I (L*9'[Â£Â£) 891'9Â£* 980'ZOO' 1 BZ6'595 008'oil EL9'00Z EL8'68 (imideo mojoq salnitpu@dx@ (Â£98'*55) V/N (Â£98'*55) (Â£98'455) 0 tiE'/9 *12Â£5 0 Sooines 10410 01 pole,Olle/paA,000.1 4%83 EZZ'Ltf (Lt'9'!rE) (90L'81[) EZZ'Lft 8Z6' 999 *I 0't,91 L88' Â£9Z ELy'68 41uout loj uoilisod tise) ut @Bue40 60['561'[$ 687'9 1 t'ES 60Â£'Â§61'Â£$ 600Â§61'ES aotte~Eq punJ (@Iqusn) poiol.11*JUn NUIpU3 VAR VAR Per kWh Per kW Budget 2005 200 AND POWER FUND H FLOW COMPARISON ration and Maintenance Expense .IJAO SOnUOAN jO KOUOIOyap/SS001,3) Imolqns Revenues Water Department - ESTES PARK Inter-Office Memorandum -TWATER To: Bob Goehring From: Jeff Boles Date: 02/28/2007 Re: March Utilities Committee - Annual System Flushing The Water Department will be doing the annual system flushing over a two-week period starting Tuesday April 17th thru Friday April 20th and again on Tuesday April 24th thru Friday April 270. Scheduled areas are as follows: April 17,2007 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 18,2007 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 19,2007 Hwy 7 (west side from Lexington Lane to Pinewood Drive) Peak View Drive to Dekker Circle April 20,2007 Hwy 7 (east side from Dannel's Fire Station south to Whispering Pines Drive) School District Area Bureau Area Fish Creek Road Uplands April 24,2007 Downtown (North to Devils Gulch Road) Davis Hill Stanley Village Black Canyon Hills 1 Water Department t90) ESTES PARK ' Inter-Office Memorandum --MATER April 25,2007 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 26,2007 Carriage Hills (south of Whispering Pines Drive) Arapahoe Meadows Cherokee Drive Prospect Estates Centennial Hills Rockwood Estates April 27,2007 Thunder Mountain Subdivision Fall River Estates and Fish Hatchery Road Kiowa Subdivision 2 3/9/2007 Water Sales by Month ($) 350,000 300,000 t - 250,000 F #F 3 3 -0 200,000 7 449 ~Â¤2005 4 4 ~~3 -5 0' 02006 ..3 ~ 4 4 4 4 4 -5 02007 150,000 -~ 11 1 1 4 4 1 -t Ii'I//4 4 5 /, 1, 1, 1, t, /1 ///V 100,000 / 1 4, /46%4445 ,t t , 50,000 , I , , /4////4 1 , I I , ,,, 1/.,4 ittt '' '' / 1 / 1 0 1- , * -1 1- I 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 0 2005 - 2,000 i B 2006 - 7 CZZZ] 2007 ..14 1,500 --- -. -Budget .4 3.33% 2007 YTD VS 2006 1,000 f E: 500 4354> / 4 4 2 4 3 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 ...xÂ«>N Â»il....L>il, FriNNX.XNXV<.*....:...:...'.::.N......>~6>08"#06...>t 100Â«X'<%60Â¢40Â¢36Â»6:v.::: 836>069%9 /0Â»6Â»>axÂ»00Â«Â»ix\\Be.vÂ«Â»axÂ«xÂ»x 4...1.30<04#33-060>0,4 TOWN OF ESTES PARK WATER DEPARTMENT TRENDS Type Surnmary Date February-07 12 - month moving average Total % Total % of % of Avg Avg Avg # of accts Gal Growth Revenues Tot Revs Cum Rev/Gal Gal/Cust Rev/Cust Urban Residential 2.669 13,028 488 0.4% $76,133 37% 37% $().(H)6 4,8>45 $28.54 Urban Commercial 746 13.599.473 2.0% $51.965 25% 62% $0.004 18,270 S(,9.77 Rural Residential 1.3()() 4.7 07g0N 0.5% 553,26{) 26% 88% $0.012 3,626 $4().99 Rural Commercial 98 1,931,409 -0.3% $12,074 6% 94% $().()12 19.294 $121.72 Bulk Water 1.401,034 1.3% $11,887 6% 100% $0.010 avg: $205,319 100% annual revenues at this pace: $2,463,829 budget $2,245,572 projected over/under: ~ S]IN,257 | <bÂ» <O - fo 13 fo Water Revenue Progress $2,300,000 - m Budgeted Revenues $2,200,000 - â€¢ Re~enues at Current O, 02,06 4, $2,500,000 $2,450,000 - . $2,400,000 -- $2,350,000 - $2,250,000 - - - I - - I - - I - I -- 000'09 L'ES -- 000'00171$ - - 000'090'1$ - 000'000'1$ S*Â£ E emizE 22:frati 2 2 2 i tr, M Y M W O M 0 0 W 1 ERS E. 623-04 2222*Â°2 0 0 22&25 3 %*E~* Ner,-1 '17 Â£Â§ 24*ER -542*Â° 0-5-0-Ms E.*MER EE*0 /1 3% I Â§Â§ 6 1 %88.Â§Â§Â§Â§ /B/ 6.(N 00000 0000000 U 38 Â§Â§Â§5%8 000Â©00 0 B% 22*0 0 0 r. 2&25 Ne-1-/ 0 0 O, 00 16 r-*r- Â» el -Â¢9--5 5Â§Â° M N --fl 'O -20 0 0 5 N M W M - *22 # er, - Rm *1500 0 0 S:X I. RE BMERE 8::5:30 0 0 tr,enWCh 4%44<5 Mig --fl W 1 0 8 e .. 0 4 0 EO a i /2 1% =fi : 8 -C 2 2 U - litfh J 5%6 Â§ 0.*05 .1.â€¢00<0'- 8 gp I - 9 3 3 4/ 5 ~ 2-8 3 6 & 8 8 a M MONTH TO DATE YEAR TO DATE YEAR TO DATE 051'9 180'001 0000 5ZE 091'9 gL*'9 5ZE 051'9 GL*'9 ino sialsuati Buile,odo 919'LEI E6Â£'8ZS'E 900-0 (Â£59'8) 939'LEI 696'8ZI (L59'8) 9Z9'LEI 696'8ZI salmipuad (6*E'fE) V/N 64Â£'tâ‚¬ (6*EW) 0 64Â£'fE (6*E'*O 0 soamos 10410 0, polootiEN@A!0391 4 0 693'46! (5.1'586) (LKY' 190 69Z'*61 908'99 9 (LK' 19Â£) 652'f61 908'599 41uoux ioJ uo!)!sod qsuo u! @Bumi j i A'164'Â£$ LtO'ZIL.'2$ 1517'16*'ES 1517'16+'ES @OUBIeq pury (olqesn) polou,solun Bu!pUSI 0It'90E 0000 0000 0 809'BZZ (9*1'989) (861'LZE) 809'833 908'555 (861'LEE) 809'822 908'555 (Imideo wojoq samu VAR VAR Per Bud 3,297,192 3,297,192 $3,297,192 19,088 11,295 793 11,295 0.001 146,53 1 OOZ'St9'Z (E86'8) 9Lt,'lEi 46*'ZEI (286'8) Lt, 1 1 f6*'Et I asuadxiI @ouuuallnew pue uouniodo le, EOL'E6* 0000 0 0 #L'l OLS':91 ZE SaIRS latem E (d 141,~35 (2903,~~) 0- (Z5â‚¬2) 8EE'*E (291 03uguoluie]N UE UO (909'OI) 909'01) (g,) UO!111'Slu (7,274) 20Â» 80 (7.274) gl} 0.0 OW COMPARISON JOAO SOnUOAOJ JO '[Ou@!ouop/SS@OXED I . 6.5 % 6 55 IM Â£14/25%% i 2% 32 0 0\ Ch h e ) re - *E --- 0 8 1 6 5 g -rn-roC, b LESâ„¢g r. -- -0 *RER 0 6 â‚¬4 ==gER *@EN 50 4 8.Â§Â§*R Â§530%0 A-ggix %**E* meN fri h -<~0â‚¬9/ M 01 3Â§ %%Â§Â§Â§Â§Â§ a 6 .1 00000 0060000 0 Â£ 3Â§ %%%Â§%Â§Â§ Odded 00Â©0000 ----20 O,2=22 199.m %b5S* - Â§*E@EÂ° M g g f g 22*CEÂ° =Meer RMN 9,5,5 8 00 0 r-04 N C %- C U E crl 0 0 Emm* 4 * * 2 - M NE g 00 0 M f E -g E 1 00 U UJ b 0 .2 -* 3 -g 20 M -2 ~ f 1 1 &2 2 1 i 7 6 66 0 0 11 Me 2/22 -3-8â‚¬2 , 3 A ~8% g @2,5 5 â€ž=*250<01- Â¢ .t : Eeg K gES &Â°r O 031#1 11 0 1 B R .0 -a Kia 10.Z 2 0 mm =2 ,- W O nook- MONTH TO DATE YEAR TO DATE YEAR TO DATE WL'00Â£ 9LS'EOE 1000 9Lt'L BL'OOE 19Z'80[ 26Â£'2 (ZU'Z) 0 138,055 10 666'680'Z 9ZE'01Â£'Z (Z62'953) 666'680'Z LOL'EE8'I 811'25 009'+91 8 18'91 Z osuodxa @ouuu@lutew puE uo! LZL'9[ I 210'LEK 0000 100*0 161'89Â£ LZL'9Â£I 6I6't'05 6Lf'5Z 199'05 Ifl'9L 1 598'901 60Â£'L6 000 0 000*0 (L66'9) 598'901 898'66 9ZL'El 06['9 9II'OZ 9Lâ‚¬'*Â£9'Z EZZ'8Â£ 1 '[ 900'0 LOO 0 6LE'Zt I 9LE't,[9'Z GgL'91,L'Z 51 2'46 098'8!Z SLO'EI[ L09'L65 (4Â£8'Eot) 04'IZI L09'L69 L9L'6Lt (1Â£6'6LE) 6EI'101 OLO'IBE (14!deo w amj,puodxo (912'91) V/N giGi (SIE'51) 0 (861'5) 861'g 60 OmOS 104,0 01 polwoolIENDA!0001 4seo E6Â£'ESS (.8.Lot) 529'901 16Â£'285 L9L'gL+ (EEL'tLE) LEE'901 OLO'18Â£ 41uout ioJ uoilisod tiseo m ONUEIi j 6LE'59Z'Â£$ Â£91'6LE'ES 6LE'59Z'[$ 08['59Z'Â£$ gouÂ·eleq pung (Mqusn) poiouiso~m Zu!pu3 VAR VAR Per BM:% $17,810,446 DieN Zlance 3, $2,682,987 $2,682,987 151,099 178,514 27,415 2,253,491 2,457,189 203,6 8 lopment Tap Fees 135,4 27,47 182,301 (45 ) 74, f 476~ 3,2 713 165,326 69~d45 522 3,231,983 388,422 ~ ,84~ 427,167 n and Maintenance 61,8~9 173 73 9 0, 806'ZE %2 slunooov pue un!!8 01 Z80'ZE iluoug{) pu~ uoil 53,252 37, 1 15 COMPARISON JOAO SOnUOA,1 Jo ~OU@!01#3 FUND Town Clerk's Office Memo To: Utilities Committee From: Jackie Williamson aL-3 Date: 3/13/2007 Re: Electronic Agenda and Supporting Documents Background The Clerk's office has established a new link on the Town's website that will provide the current month's Committee agenda with a link to each of the supporting documents. This ultimately makes the agenda and all department memos available to the public prior to the Committee meeting. The intent is to make Town operations as transparent as possible. This is a trial and if successful the Clerk's office would like to proceed with the other Committees. Schedule - The agenda would be posted on the website on Monday afternoon as it is currently; however, on Wednesday afternoon the supporting documents would be linked to the agenda once the Committee packets have been delivered to the mailboxes. Budget N/A