The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2006-06-15I- 4 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8 a.m. Thursday, June 15, 2006 Preparation date: 06/12/06 ACTION ITEMS PUBLIC COMMENT Light & Power Department l . RFP approval for 2006 Town of Estes Park Financial Plan Water Department No action items REPORTS Light and Power 1. Light & Power Financial Reports Water 1. Water Financial Reports Note: The Utilities Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared. I 4 hp LaserJet 3015 42 * HP LASERJET FAX invent Jun-12-2006 3:01PM Fax Call Report Job Date Time Type Identification Duration Pages Result 859 6/12/2006 2:57:03PM Send 5869561 0:38 1 OK 860 6/12/2006 2:57:46PM Send 5869532 0:48 1 OK 861 6/12/2006 2:58:39PM Send 5861691 0:52 1 OK 862 6/12/2006 2:59:36PM Send 6353677 0:49 1 OK 863 6/12/2006 3:00:30PM Send 5771590 0:56 1 OK Town of E*tes Park ' 1 r -- - -1 - .-- - -lill- To: Public Works Committee From: Steve McFarland CC: Date: June 14, 2006 Re: Response to May 31, 2006, 2006 Town ofEstes Park Financial Plan - Request for Scope of Services Background On May 31, 2006, The Town requested a Scope of Services for a Financial Plan for the General, Community Reinvestment, Light & Power, and Water Funds. The Plan would serve as a follow-up/companion piece to the Black & Veatch report that was incorporated in the 2005 Goal Team #2 Master Plan. The RFP (see attached) was specifically targeted to the following three entities, with the following responses: 1. Black & Veatch - declined (via letter) opportunity to propose. 2. Red Oak Consulting - John Gallagher was the consultant with Black & Veatch who chaired the previous study. He now works for Red Oak. Total project cost is $78,300, and was compartmentalized into 4 sections (page 1 - 9): a. Water Fund Financial Plan - $14,500 b. Water Systems Facility Review - $39,800 c. Light & Power Financial Plan - $14,500 d. General/CRF Plan - $9,500 3. HDR-Submitted bid. Total project costis: $56,260 a. Water Fund Financial Plan - $7,485 b. Water Systems Facility Review - $29,960 1 - 1 1 U.al 4 4 c. Light & Power Financial Plan - $8,935 d. General/CRF Plan - $5,760 The budget source for funding is in the process of being clarified. The L&P (502- 6501-560.22-89) and Water Fund (503-6500-560.22-89) line items signified as "Utility Financial Studies" do not have funds budgeted in 2006. However, the accounts 502-6501-560.22-02 and 503-6500-560.22-02 labeled as "Engineering" DO have $75,000 and $60,000 budgeted respectively for the Mary's Lake Substation Master Plan, under which is a subcategory labeled "Financial Plan Update". Timing is of the essence in this project due to the need to integrate the work product into the 2007-08 budget process. However, without exact feedback as to what accounts are expected to provide funding, I am uncomfortable recommending moving ahead with the project. Jeff Boles believes that the "Engineering" line item is earmarked for this project. When Bob Goehring returns on Monday June 19th, I would like to email/inform the committee with further information. Action None at this time. This report is informational only. â€¢ Page 2 I ' May 31, 2006 Sarah Clark HDR Engineering 303 East 17th Avenue Suite 700 Denver, CO 80203-1256 Subject: 2006 Town of Estes Park Financial Plan Request for Scope of Services Dear Sarah: We are requesting a Scope of Services for financial consultation. The following Town of Estes Park budgeted funds shall be included in the Scope of Services as separate expense line items: General and Community Reinvestment Funds (tax- based funds) and the Light and Power and Water Funds (enterprise funds). Each fund will be paying for its own financial report. A Performance Bond may be required. Proposals will not be judged on costs alone. The Town reserves the right to reject any or all proposals. The Financial Plan should include, at a minimum, the following: 1) The plan for all funds should be in the same format as the Water Department Financial Plans. The plan shall be in a working Excel workbook that has at least one sheet for each fund, links all funds, and has a summary sheet for a total financial picture. The time period for the plan will be from 2003 to 2012. 2) The plan should review in detail: a) Projected revenue in tax based funds. b) The projected revenue and proposed increases rate in enterprise funds. c) Any projected Platte River Power Authority wholesale electric rate increase for Light and Power fund. d) Capital improvement plans for all funds through 2012. . '4 3) Water Department Additional Review: a) Water treatment facilities ability to meet upcoming State Health Department and EPA regulations. b) Review of the proposed 2008 water treatment facilities upgrade. c) Review of the 1985 Mclaughlin Water System Master Plan. The final Scope of Services product should include the following: â€¢ A working Excel report spread sheet for financial forecasting of all funds. â€¢ A field for entering percentage growth rates used for revenue prediction. â€¢ Options for capital improvement funding for each fund. â€¢ Bonding requirements. â€¢ Industry standard for fund balance targets, each fund. â€¢ Project utility rate increases if any and detailed rational explanation. â€¢ Water Treatment Plant Overview Report, including recommendations for upgrades with cost estimates for budgeting purposes. â€¢ Two"On Site" Financial Plan Presentations to Town Board and/or Committee. In order to help with the mid-year budget process, we will need a final draft report by September 1, 2006. If you encounter problems with the timeframe outlined in this request or have any further questions, please call Steve McFarland (Finance) at 970-577-3560 or Jeff Boles (Water) 970-577-3608. Please submit your Scope of Services by 5:00 p.m. Monday, June 12, 2006 to: Steve McFarland, Finance Department The Town of Estes Park P.O. Box 1200 Estes Park, CO 80517 Sincerely, TOWN OF ESTES PARK Finance Department Steve McFarland 970-577-3560 Jeff Boles 970-577-3608 Director of Finance Water Superintendent m. trif.; g.:'<2:53 0-:lati -:': f . 41'-1,%42. 4..':-~: t. ...'.' -' Â·I. . ''â‚¬I ~ .i '' {:I.:~~Â· t , 2~Town Tof, Estes.Park, : ~Â· ~ I :Â· â€¢ 74 t-fy, :. .0-1 f. -<:.2. 2.â€¢6 Â» - :Â·3 ': ..,:;:. t' i.,41 4. 4 ..:iÂ· . -':. 1 -t . , -L ..0+1 --'?. .~' ... C ..i Project'Approaghh 1 Â·Â· 4 64' 4,-46* 9 1â€ž'A.- -.Â¥ :ar, ,)%f# FEE ESTIMATE Â»'*]M#?1Â».1*.2~ Red Oak proposes to perform the specified scope of services outlined in the 247924/)460*4.'400 "~:*KÂ· ~;47-*4 Request for Proposal at an estimated cost of $78,300. This estimate is F/bak#Aw/4**4,0,341#PS, broken down into the following general task areas: 85 . -44Â¢rpe,%9* Â·:if,:. Ji# 4,12.1,4,3, *229. General Task Area Hours Estimate Water Fund Financial Plan 80 $14,500 Water System Facilities Review 220 39,800 Light and Power Fund Financial Plan 80 14,500 (9Rit~Â·21& ~'Nk#t~44*4.#WA*4 General Fund and CRF Financial Plan 50 9,500 1 A Total 430 $78,300 *4%4~52,64*~5..7%.4*295 ...4 P.,4 u ,-1 4429:. I :<Th#'43#40/ 01* ' . 14 4:â€¢91**A>.u '. ~ i Cd?':4 91.913 , - >* iÂ· A 4.â‚¬1 49*3~9449- .. Â£ ~ 44 2 44& ,1f r:;.. Â¥Il'.1-2> 42% *rtf> 35 - LAY:**Cfft. 9. i ,?>14* *32*4&019.3-31 9 .4 - 7. 12" - 1% I $4 1 14 -4 44 .'PR 6 Â§4+.4 P'*/12"I. J.t.41/.4< 4, Fle: 4:1'/ tgretf 4ys:>Ir,ty:#@4~''Al '4,Â¢11.t. 1244 #90 M#75+41 %141:/ Atift.WA#d#$74221 *.A.,~ ff.t--:f-~6,3. 6 22 i . .,Â¢1 -,7,4, ?ie 0 ~494*yl* .- E~ 43-ika.42' ir ed.,311â€¢* E 301 . â€¢rÂ»t#113* I IÂ· 1$-It t./ t#24,3~3314 ili,~#24 2~. w*43.tt *24*&44.kt/*'I:749%,e,Â·.s...,sv*"/'I.â€¢â€¢ 4 -,-=-Â· . -7/7.91-J . 660+Ft# #rt,1.4.fkfii (#+ 11 f 9.1...4Â© 200(i Town of Estes Park Financial Plan -~-c:â‚¬,i~-<'.5::3142*f' <~'<:6Â·1.!43~42*77~2:7~1*J-3773.0Â·97~393.rf.7~7%.737.37:273*.T~U~ Cost Proposal Estimated Project Fees Based upon the estimated labor needed to conduct the Town's study, HI)R has developed a fee estimate for the Town's project. 1 . Estimated Project Fees Gdneral/' "" d: Water -= ' Light/ Comm. Total .. Power Rein. Tail<: ~ Task 1.1: Initial Project Meeting , $490 .$490 $490 $1,470: ~~ Task 1.22 Data Request ':'Â· 145 145 .140 430 3,000.'7 3,500 i 2,400 8,900 Taik 1.3:'Financial Plan/Revenue Requirements Task-1.4: Rate/Tax Analysis'-I .Â· t 1,500 Â· 2,000 830 : 4,330 Task 1.5: Public Presentations.(2) 1,250 ~ ' 1,700 800 -3,750 Task 1.6: Written Report ~- . 1,100 1,100 1,100 . 3 , 3,300 Tadk 1.7: Computer Models (included above} . .. .N/C Â·. m . NIC Subtotal Rate Study> $7,485 ' $8,935 .~$5,760 ,;. $22,180 Task 2.1: Review Existing Reports, Drawings, Other Information 3,740 _ -3,740 Task 2.2: Evaluate Raw and Finished.Water Quality L 1,625 5 Â·1,625 ~ Task 2.3: Review SDWA Regulations ahd Water Quality Impadts - 1,230 : .:-Â·~~ ~~' . 1,230 Â· Task'2.4:-Evaluate Existing Treatment Plants 2 9 9,790 ' t '.1 ,. Task 2.5: Prepare Preliminary 'Report _ s 6 Â·Â·Â·Â·5 .7- . 9 6,510 Â·Â· - c 06,510 Task 2.6: Conduct WTP Evaluation Workshop Â·-0 ~,~Â·Â·~'~ -3,575..Â·n. . . H, 7 3,575 Task 2.7: Prepare Final Report- '; . . i 0 3,4902 ..t'' *490 1; i e , Â·-' Â·Â· . 3 .,-Subtotal' Treatment Plant Evaluation E $29,960 ,$29,960 Experlies: : 1 *1. ' .,. 4.Travel/Hotel/Meals f ' 4., $2,060 j,..2.Misc (phone, fax) 'Â· ~ f: 4 280 Technology Charge :t .1Â· 1,780 D Total Expenses , ~-&I ,- $4,120 ~ GRAND TOTAL ESTIMATED FEES ' $56,260 HDR is willing to negotiate a final scope of services and fees for this project. The total estimated fees for this project are $56,260. A *Ab.EmuNddWbiat. w 9' Â·e't' ~ trif K,1,2;4.~:~i.: ab Â· ~ Â·Â· ~ Â· Â·wÂ· Â·Â·Â·Â·.:Â£~2i,2Â¢ZA.â€¢St:2*Â£ 12-NS;.'1*Â·~31..;.t.% - Lb- ---zi~.-a.2&06425 22' VirAM ** 01/06/06, 15:55:50 BUDGET PREPARATION WORKSHEET FOR FISCAL YEAR 2006 2004 2005 2005 Year 2006 Actuals Budget End Estimate 'Approved Budget gff'"NUMBER ACCOUNT DESCRIPTION --------- -------- ------------ --------------- i ~Â£EMPLOYER BENEFITS 63,365 73,488 73,488 44,246 W INSURANCE PREMIUMS 6 ~1-560.21-01 PROPERTY 2,306 17,454 17,454 15,067 49 65Â»560.21-02 LIABILITY 9,984 111 111 5,308 4, 65 i-560.21-41 WORKER' S COMPENSATION 3,323 2,714 2,714 2,845 2,2 ----------0 ------------ ------------ --------------- .t.. NSURANCE PREMIUMS 15,613 20,279 20,279 23,220 PROF. SERVICES/FEES 0 560.22-01 AUDITING 8,500 10,500 10,500 10,500 560.22-02 ENGINEERING 0 14,000 14,000 75,000 Â» TEXT TEXT AMT fÂ·Â·t J'RATE INCREASE ASSISTANCE ( CONSULTANT,PUB,PRINT) 14,000 -------------- 4 14,000 f TEXT TEXT AMT. :,MARYS LAKE SUBSTATION MASTER PLAN .-' 75,000 1 A) TOWN CIRCUITS MODELING UPDATE 41 B) SUBSTATION PRELIM - DESIGN AND -COST ESTIMATE i . C) FINANCIAL PLAN UPDATE > -------------- 75,000 '* '4-560..Â·22-07 RECORDING FEES 28 150 150 150 pti 5#0.22-08 LEGAL 1,492 + 2,000 2,000 2,000 -166.22-09 INFO TECHNOLOGY SERVICES 0 48,274 48,274 46,830 *EXT TEXT AMT 75. INFO TECHNOLOGY SERVICES (15.517%) 48,274 -------------- 48,274 v Afl. , . Pe 9* TEXT AMT *FO TECHNOLOGY SERVICES (15.517%) 46,830 iff , 1-r, -------------- . j *. 46,830 ...Uk. ' Dr 14. -4. 71'.iÂ· 281 .~ .*.P,Â·*frit.. ~Â·~Â·Â·Â·43Â·er 4 24 Â»Â·5 ' 4. <â€¢Â·4 8 Â·PREPARED 01/06/06, 15:55:50 BUDGET'PREPARATION WORKSHEET FOR FISCAL YEAR 2006 2004 2005 2005 Year ' 2006 Actuals Budget End Estimate Approved Budget ACCOUNT NUMBER ACCOUNT DESCRIPTION --------- -------- ------------ --------------- PO ROLLOVER-PO #18269 CORNERSTONE 674 PO ROLLOVER-PO #18712 CORNERSTONE 29,136 -------------- 59,810 LEVEL TEXT TEXT AMT 6REQ IDSE (STAGE 2 DISINFECTION BY-PRODUCTS RULE) 10,000 HILL STREETS - DES/CM , 25,000 SCADA SOFTWARE UPGRADE - MOTOROLA PROGRAMMING 42,000 MARYS LAKE WATER PLANT MASTER PLAN 4/0-60, -000'...0 A. PLANT CAP/SYSTEM ANALYSIS/NEW EPA REGS REPORT B. PRELIMINARY DESIGN AND COST ESTIMATE . C.' FINANCIAL PLAN UPDATE L ..Â·-/ -------------- 137,000 503-6500-560.22-07 RECORDINGÂ·FEES 21 200 200 100 503-6500-560.22-08 LEGAL 6,340 10,000 10,000 10,000 503-6500-560.22-09 INFO TECHNOLOGY SERVICES 0 21,455 21,455 20,813 LEVEL TEXT TEXT AMT 5EOY INFO TECHNOLOGY SERVICES (6.897%) 21,455 -------------- 21,455 LEVELÂ· TEXT TEXT AMT 6REQ INFO TECHNOLOGY SERVICES (6.897%) 20,813 -------------- 20,813 503-6500-560.22-10 BANK SERVICE 1,050 1,000 1,000 1,000 503-6500-560.22-8~UTILITY FINANCIAL STUDIES.-2> 14,218 0 0 503-6500-560.22-98 OTHER 1,082 500 500 500 --------------- ** PROF. SERVICES/FEES 38,707 98,465 98,465 174,913 PUBLISHING 503-6500-560.23-01 PUBLICATION FEES 0 3,000 3,000 3,000 --------------- ** PUBLISHING 0 3,000 3,000 3,000 r unu runa Fund MONTHLY PEAK DEMAND 25500 - 23500 21500 -0-2004 ---2005 0 19500 -0-2006 17500 -..lir 15500 13500 11500- ' ' ' ' ' + ' ' ' Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES 7}i 12,000 --3, /% 93 7- 7 43 7 g- 10,000 --3* 4 ,PL F ,32 N #1 7 - 74 44 4, #% /5 4 M 94 3â‚¬ 2 ./ ffii ga Â» A 55 4 4 i 1% ft %12 .:0 Â¤2004 8,000 -0% i - 31 A 01 A 8 %% 0% :r M 2 -R i M E % 02005 43 0% 0 0% 05 9 0 2 02006 tt 04 2* 1 0% .' 6,000 --0~ -0:4 -/c- - --Â·04 41$ 3~ 4;* ft #u H &4 0 -* A P * 93 A A 3% 041 Win 0 ## 0% 0 ve 43 %7 * /3 0% 4% 2 6% 42 al U #Ea 9% 22 *4 0*i 4,000 --04 --%.t - -02 -%3 -5% 24 94 43 2% 01 3% %51 0% g &* da Vt *Â§ %.:F 4* A *f 21 U *ti Â¢ 4.4 / I 0% 03 *3 04 1 51* aÂ« U %1 *4 4,5,8,% ~baa,u,A,E,2 2,000- 'Â» 1 -/ I. 1 I I Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 Monthly MWH SYSTEM KW ~ <Er<(Â«Â«Â«Â«r,tit~ Ni NÂ»xÂ©>00**Nt htÂ« '*N'Â¢**X-633Â·33*Â»Â«1 61.1,#Ulf...H *EEkii*Â£*i j i Fi i i FE**6Â£86*Â£*Â£11*04 1 3 +UN./.1/:U:/1/1/Ii://17: 1 4= YTD ENERGY PURCHASES 120,000 100,000 80,000 - 1.00% YTD 2006 VS PiE i 2 2005 ~ 0 2004 13:El 415: 7 41, 60,000 '4111 RIM * E 32 N 02006 40,000 4-3 gra: SE 2 - / 'ME*M 11 #3 0% 4%<i 4 * / m 7: LA 41 20,000 4 & 4 2 44 8 5 63 MUM 99 *3 52'E 82: 2Â® 2% A * 1% 7 SM mÂ© 3/ 01 5% ZZL Â«01: 43:- e 1 1 1 1 1 1 I I Jan YTD POWER COST vs. BUDGET ($1,000) BBUDGET Â¤ACTUAL 5,000 4,500 W 4,000 1 2 3,500 W** 3,000 Ei%E 2,500 m%"% EmIlIE 2,000 1,500 1,000 5 5 & L 500 g--~ ffl~1 ~ ~ : %-i-% "ii%% %%%% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 'Alutu;~.. L. le~EggE:g< YTD MWH Purchased t:***t*%&41%244%%Â©t ELECTRIC SALES BY MONTH ($1,000) 1,200 1,100 1,000 - 900 --- - E 800 -6 * -3 - b 31 0 2004 4 a -5 -1 M 2005 02006 ty 4, $$ 24 24 4% 1% 6% fl ti it 11 11 I I 600 -B -14 -U -}4 -}5 1,0 t.f '.1 04 'Pl 95 &% . F t 3 --- %4 %14-it th Ga 400 -22 -$3 -BE -<4 -25 15 hy ,Â¥ 23 *A ty <: /3 4% 18 *4 05 19 54 1 + . .2 1 3 % 1 4.3 . ilt , 45 1 .h , G , ;5 1 L 1 300 4-2* 1 , :2 1 Â·.* 4,1- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR TO DATE ELECTRIC SALES ($1,000) 10,000 10,138,000 9,000 4 17.65% 2006 YTD 8,000 VS 2005 -F 7,000 - C 2004 - - 7- 6,000 - GEE] 2005 ..4 5,000 -- 02006 V , '*TJ. v 1, 4,000 - -Budget -~- -33 Y 5 1 3 - th 4% 4, 0 Â·i j - ./ J Â·,4 ./0 /1 r 3,000 ; - 4 6- : M Â£ 4 - . r., 2,000 . : - 44 - .Â¢ - < 6 - - -Ii--I- 'I. - M I 1. 14 . 3 I ./' i 1,000 -5,7<7- 8 - 2 -111 - -4 .4 ' A .- .4 â€¢ . 4 E , j , / 4 0 14.1 1 1 ..M i, 1 4 1. 1./.1 J f 1 1 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 8 YEAR TO DATE SALES MONTHLY SALES Â· <hfte d 444*' 3 , &14 i.... k. i i i < < ' 1 1 1 I I I 4, I ./ I I ./ I 1 - 1 1. 4, 41 4 4 41.- h. 4/ 41. I 'tr' ' 'i I I I I. I .. . .... . /. / ' 2 222 ficiEE Â£ B it 1 011 8 ugu 1 er; M rn * rn - Â§28 - 0 85 4R 88888:2 * 0 M 00 0 5 Â©Â©dood rel O Q-Mole- 0 ,-1-000%0 0 5 0 000 Â©00000 el odd 0000Â©0 %* 6 06 h C'-- r. -- %00 e 00 en O-,â€¢-n 44-S -2 61 =r 42 O %O - 00 XM ..0- 04 1 C. r-- 't r- M -2 255 C'*50 0 -43%-CD =E& M C Q /.1 0*%22Â°Â° O 1 61 â‚¬-1- % M 0~04 O N % 8 f 5 5.0 0 2 2 17 il . 8 & iNg 31 1 @ggEN 00 2'Bib: .Eup *E NE *b 5-2.au< @3*m f i i ~ 1 i 3 0007 22 2 1 3& 2 U MONTH TO DATE YEAR TO DATE BUDGET vs. YTD % of yr> $10,811,188 $10,811, 88 e) fund balance 3,197,668 $2,748,086 $2,748,086 $2,748,086 731,568 730, 6 4,114,231 4,413,410 2 179 . 77 0.079 9,741,0 4,413,41~ ance 132,583 10 ,4 606,;13 574,051 31,962 ?:3:Z 1,;:19: General 47,734 81 462,3 37,785 1,2 2~ ~Total O&M Expenses 543,7~0 542,19 3,280,3 7 3,1 110,841 8,236,4U 3,169,536 OSI'59 00Â£'50Â£ 100*0 100'0 8/Â£'f 061'59 00!Ales lq@CI t89'69â‚¬ L09'686 L00*0 900'0 (L88'*0 +89'69Â£ L6L'*Eâ‚¬ 60L'I I t,[5'12 EZZ'EE 906'5LE â‚¬EI'6E6 L00'0 900*0 (Egg'tg) 906'SLÂ£ Â£5Â£'IZE (DL'59) Etâ‚¬'59 0 ino slojsuall Nutielodo 9Lt'0L6'E SICOLf'OI ILO'O *Â£00 6+L'SZ 9LZ'0L6'Â£ 920'966'E (10675) *54'6I9 Â£56'9Â£5 sam)!puodxa 1401 Â£8 I'909 (Lt,9'1Â£Â£) 68Z'EtE Â£81'909 t68'ag (OLCLS) 890'09 1 RZE'LfZ (imideo Biopq samupuadxo ZBI'Of V/N ZQI'02 TRI'0Â£ 0 5ZL'9Z dEL'92 0 S 00.InOS 10410 01 pole<OZIBROA!0001 4SE) 59Â£'9â‚¬9 (Lt'9' I Â£Â£) ILVELE 59â‚¬49Â£9 *68'/93 (5,5'09) Â£8L'981 8ZE'L*Z iliuoui foJ uo! 1!sod tise< ui @SUEt[) Ig.'tsâ‚¬'â‚¬$ 6Â£~'91*'ES 1 9'nE'ES , 5*'t78Â£'Â£$ aoueleq pury (aiqusn) poioulsalun Butpus! VAR VAR Per kWh Per kWh Bu 92,713 5 ,0 0.003 397,863 824,281 78 ,51 0.082 10,138,868 2,0~ 1,935,951 1,914,7 7 21,154 (709) 49,738 4 20,649 313,524 311,45 AND POWER FUND LOW COMPARISON JOAO Sentlegl JO Kou@!0!Jop/SS@OXH) lelojqns 1 1>h - 00 - 00. I - do 13 I I 000 1 1.li- db m Budgeted 2006 Revenues ' it~p~~es at L&P Revenue Progress 4, .2,06 4, $9,800,000 $9,750,000 $9,700,000 - $9,650,000 - - 000'009'6$ -- 000'099'6$ - 000'009'6$ TOWN OF ESTES PARK LIGHT AND POWER TRENDS Type Summary Date May-06 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,320 3,810,720 -0.1% $339,075 42% 42% $0.0893 520 $46.26 Gen Serv Small 1,566 2,024,883 -0.2% $178,110 22% 64% $0.0881 1,294 $113.79 Gen Serv Large 91 2,785,995 0.0% $169,567 21% 85% $0.0611 30,554 $1,860.54 Residential Demand 410 756,968 -1.6% $65,633 8% 93% $0.0900 1,857 $160.93 Res Energy / Time of Day 228 401,709 -0.8% $24,026 3% 96% $0.0612 1,750 $104.71 Municipal 61 247,281 -2.1% $19,042 2% 99% $0.0770 4,065 $313.03 RMNP - Small Admin 19 63,720 -1.8% $2,883 0% 99% $0.0453 3,354 $151.75 RMNP - Large Admin 6 63,690 -1.1% $2,591 0% 99% $0.0411 10,615 $431.86 Wind Power 98 0 #DIV/0! $2,080 0% 100% N/A 0 $21.24 Res Basic Energy 12 17,159 4.6% $1,431 0% 100% $0.0842 1,397 $116.50 GSS - Comml - Energy TOD 13 17,712 0.7% $1,163 0% 100% $0.0662 1,344 $88.31 GSL - Comml - Time of Day 1 10,560 0.8% $739 0% 100% $0.0708 10,560 $738.89 Outdoor Area Lighting 16 0 #DIV/0! $205 0% 100% N/A 0 $12.88 Res Time of Day 5 7,432 -8.3% $209 0% 100% #DIV/0! #DIV/0! #DIV/0! RMNP - Administrative 2 671 -22.1% $33 0% 100% 14/A 336 $16.34 9,849 avg $806,787 100% annual revenues at this pace: $9,681,448 budget: $9,741,005 projected over/under: | ($59,557)| 6/9/2006 Water Sales by Month ($) 350,000 300,000 250,000 -1 -7 7 , , */* ,t, 200,000 - , Â¤2004 , 4 * I Â¤2005 - 75 5 5 5 150,000 ----F Â¤2006 ****, 100,000 - :- - 4*.*'** 4*'*** *** 5%55 50,000 - *t.* I * S *te/**9 5 / / 5 V or, , - .--/- ~- - -1< Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Water Sales Year-To-Date ($1,000) 2,500 $2,128,000 2,000 -5 I2004 -5 ~5 M 2005 '' 1,500 92006 - Budget / ~0 , {55 1,000 - 5.79% 2006 YTD VS 2005 -1, I / 63<5 ''4'' , 500 jmn im 1 --3--~- ~- --5- , , , 11 * 5 5 % 6 5 3 % 3 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 1.1-1."...... *\\\\\\\ \\ : 122 : : 0 0 0 0 2//Eig, 0 819 8 en-t-1-tr, 00Â¢Â·le-+MeN bri--00 2 * 2.4 &8 W@2 8 >â€¢Mt-*B ;%% deg M 30 f* Â§*ZOO **Â§ Re 2002 ER:Re BEEM* M -Ne-1-610 %88 888888 Â§ 000 000060 0 ded 000000 MQ-- 55552 0 Atg=g 2250-i- 66** CSnC 8% E-7-6-2-8. 9%5MRO 222!2* gÂ©22 ;NM M- -MN 2% 1-04Â·0000 0 C\Â¢100061 BER 0 55.*20 0% = E ~9% et m n mZR tSEC ER Â©*RagÂ©Â°0 0 I- Wl mq M g 2 :R R EKM I. 002 5 02:GR o o o 1 01 1 9,1 q -- 00-00 4Â· M Q.Â§ 1.11 2 a =1 2 b :fi:878 d %0E Lt9'6Z 60['Â£6 000*0 000 0 (ZLE'L) L*9'6E GLE'Et (89Â£'9) 89Â£,9 1110 S.10Jsuell Nullui*to %62 880'0I6 EZE'SEI'Â£ 600'0 800'0 (Mt'Â£0 880'016 *09'998 (6ZE'El) 04'9" II9'ZEI Salilipuadva Fol Â£ 998'Efs 9201Â£'Z 800'0 L000 (95L'LI D 998'En Oil'SEL (L65'VE) 54'OL I 198'gEl ostiodx3 00UEUMmew pue uonulgdo ielol %I 1 88Â£'EE 9L5'Â£0[ 000-0 [DE'g 88L'EE I E 1'6Â£ 0 00!Al@Slq@(1 /61 LRCE CIO'LD 000'0 !00'0 I0Â£'9L L8L'E 880'08 9EL'LZ (986'0â‚¬) (ogz'E) 1 12'689 (*Â£8'EOP) L6L'59* 112'689 Et'itt *Z9'OLI 666'681 SLE'61 (imideo a.Jopq sam,!puadx@ MONTH-TO-DATE MONTH TO DATE YEAR TO DATE YEAR TO DATE 150,467 167,718 17,251 59,175 0.007 0.007 790,272 Plant Development Tap Fees 53,819 0.001 0.002 223,6 8 1 77,347 110,562 163,208 203,318 ution and Maintenance 254,500 270,444 825'18 88L'98 9/9'9t sturiojov puu Sull!!8 J t,10'LLI LL! 687'Â£81 6IZ'8Z [Flouao puu uo!181,SHnul "8'915 VEN (ti 8'fI 9) *IS'519 0 (566'LID 566'LI< 0 Sal.nOS 10410 01 polejOI[BROA! 0001 4&83 5Â£0'501'I (*â‚¬8'[Ot) 119'186 5Â£0'Got'I t'Et''EZZ 619'889 f66'LOL GLÂ£'6 I 41UOU! JOJ uoilisod tiseo tn 32umlo ZZO'888'Â£$ Â£51'6LZ'ZS zzo'888'[$ Ezo'888'Â£$ potteleq punJ (@Iqusn) poiouisanm iulpu3 Beginning net assets (assets - liabilities) $17,810,44 Beginning unrestricted (usable) fund balance 3,180,029 $2,682,987 $2,682,987 Total Revenues 183,853 1,09 2,734,3 9 1, VAR VAR Per Gal Per G 2005 200 rights Tap Fees 89,160 1 CASH FLOW COMPARISON Operation and Maintenance Expense JOAO SOnUOAOI JO KOU@!Ouop~SSON,3) Ielo,qns WATER FUND 2006 vs. 2005 Revenues Expenditures TOWN OF ESTES PARK WATER DEPARTMENT TRENDS Type Summary Date Mar06 12 - month moving average Total % Total % of % of Avg Avg Avg # of accts Gal Growth Revenues Tot Revs Cum Rev/Gal Gal/(Just Rev/Cust Urban Residential 2,593 12,635,774 0.9% $71,877 37% 37% $0.006 4,883 $27.74 Urban Commercial 711 13,126,223 0.2% $49,442 26% 63% $0.004 18,636 $70.03 Rural Residential 1,279 4,540,528 0.8% $50,492 26% 89% $0.012 3,557 $39.51 Rural Commercial 99 1,814,754 -0.6% $10,914 6% 95% $0.007 18,765 $112.36 Bulk Water 975,375 0.4% $9,976 5% 100% $0.012 avg: $192,701 100% annual revenues at this pace: $2,312,409 budget $2,137,800 projected over/under: | $174,609 I . 1 00 do 1 1 CA l 4 1 1 1 1 161.1 V., - - - - Ch. Â£ Budgeted 2006 SenueAe le Sen UeAdel~ g~ j -- Water Revenue Progress 04606 f *42