Loading...
HomeMy WebLinkAboutPACKET Utilities Committee 2003-05-08AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE May 8,2003 8:00 A.M. Preparation date: 5/2/03 *Revision date: 5/6/03 (reports format only) ACTION ITEMS Light and Power Department 1. Old Light and Power Building/new concrete slab for transformer inventory - Request to construct 2. 2002 Big Thompson and Baldpate Primary Line Replacement Project - Request approval of a bid quantity line length Change Order Water Department No action items REPORTS Refer to the Reports Summary Memo at the beginning of the Reports Section of the Packet. The Summary follows the same order as the agenda. Light and Power Department * • Light and Power Financial Report • New Light and Power Department Crew Chief • Channel 39 • Future Stanley Heights easement vacation request • Christmas Decorations/Lights Project update • 3Com Corporation grant application • Platte River Power Authority 1) Proposed rate increase 2) Fiber optic line discussion • Misc. projects update Water Department* • Monthly Financial Report • Water Rights • Misc. projects update Note: The Utilities Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared. Message Page 1 of 1 Vickie O'Connor From: Laurie Button Sent: Wednesday, May 07, 2003 10:34 AM To: Vickie O'Connor Subject: FW: Business license for High Peak Just FYI ... -----Original Message----- From: Bill Linnane Sent: Wednesday, May 07, 2003 10:31 AM To: Laurie Button Cc: Vickie O'Connor; Bob Goehring; Todd Steichen Subject: RE: Business license for High Peak Yes, I will make it a condition. -----Original Message----- From: Laurie Button Sent: Wednesday, May 07, 2003 10:29 AM To: Bill Linnane Subject: Business license Hi Bill! RE the L&P concrete slab for transformer storage ... The contact person with High Peak Concrete is Mike Miller. He is aware of the fact that he does not have a business license and needs to purchase one. Vickie asked if it might be possible to make the license purchase a contingency of the bid approval when that item comes up for consideration. 5/7/2003 TOWN of ESTES PARK Inter-Office Memorandum June 13, 2000 TO: Bill Linnane / Utilities Committee FROM: Bob Goehring 4 +0* h. SUBJECT: 30 feet by 60 feet concrete transformer pad Background: Refer to the location map on page 2 for the following discussion. The Light and Power Department has budgeted $11,000 for parking lot paving at 640 Elm Rd (old L&P shop). We would like to build a concrete pad for our inventory of transformers on the west side of the old building between the building and Elm Road. The transformers are currently being stored on the South edge of the lot between the L&P building and the bone yard. Most of this parking lot is on old landfill and these heavy transformers are taking their toll on the asphalt The proposed site for this transformer pad is on undisturbed soil and won't settle. We will re budget for asphalt repair in 2005. (continued on page 2) Cost/Budget Todd J. Steichen solicited bids from 2 local contractors: BID Mountain Concrete 10,730.00 High Peak Concrete 9985.00 BUDGET $11,000.00 Recommendation: Staff recommends hiring High Peak Concrete for $9,985.00 to build the transformer pad. 1-1 . I - 1 14\ - i Llp 1 SHOP 1 L 4- BAO ELM R 0 ~ It N€Wi 43 1 . i N...1 ,\ -bc,%\-- L ~~__jii.Ok}:stoMite atea * : 1-··--- -I.-I. 5 D Rd < 31 4-4 f.............%01 \ 4 · 1-2 TOWN OF ESTES PARK Office Memorandum To: The Honorable Mayor Baudek and Board of Trustees From: Richard E. Matzket~.2/0- I)ate: May 6,2003 Re: Baldpate and Big Thompson Three Phase Projects Project Close Out BACKGROUND: The Town contracted with Hamlin Electric in February 2002 to construct the Big Thompson and Baldpate to Big Owl Three Phase projects at a bid price of $758,936. Projects are shown on pp. 2-6 and 2-7. The contract is based on the unit costs bid by Hamlin Electric and the bid schedule for the projects provided by Electrical Systems Consultants (ESC), the design engineer for the projects. Change order request #1 was approved in November 2002 to pay for changes to the Baldpate to Big Owl project performed at the request of staff. A purchase order was not issued in 2002 to reflect the approved change order amount. Subsequent to approval of the November change order, an engineering error was discovered in the bid documents. The bid specifications called for the removal of 22,039 ft of #2 conductor when in reality 88,156 feet were removed. The bid schedule amount includes the total length of the project in feet, however the existing line had four wires per foot (three phase wires and one neutral wire). This resulted in a $15,852 difference between the amended contract and the actual invoice. The revised total cost for the Baldpate to Big Owl Three Phase project is $362,242. (Continued on next page) BUDGET/COST: Contract to date 779,321 Change Request #2 48,287 Final Contract 827,608 2002 Payment 746,885 Contract Balance 80,723 Carryover from 2002 14,102 2003 Budget impact $66,621 The 2003 budget does not include this difference of $66,621. The additional amount of $66,621 can be funded from 2003 overhead capital projects out of the conductor upgrade program ($32,621) and deferral of the MacGregor Ranch underground project ($34,000). RECOMMENDATION: The Utilities Department request authorization to increase the final contract amount for the Big Thompson Three Phase and Baldpate to Big Owl Three Phase projects by $48,287 to $827,608 and pay the final invoice upon completion of all work. REM 2-1 . BACKGROUND (Continued) Change Order Request #2 During the construction ofthe Big Thompson Three Phase project, several field changes were requested by Light and Power Staff to allow the project to conform to Town requirements and the National Electrical Safety Code. These changes were required to provide proper ground clearance and mechanical strength. There were also changes made to accommodate the wishes ofthe property owners. The changes requested include additional poles and wire, taller poles, new transformer installations, and additional down guy and anchor assemblies. The total value of the changes requested on the Big Thompson Three Phase project is $32,435. Discussion of Delay A walk through ofthe Big Thompson project was conducted in late December with Light and Power staff, Hamlin Electric, ESC, and QWEST. A punch list of clean up work was developed as well as a list of work requested by QWEST. The nature of the work requested by QWEST was to provide additional vertical separation between telephone and electric facilities on joint use poles. At the January Light and Power Committee Meeting, staff reported that a final change request was anticipated from Hamlin Electric which might include work requested by QWEST. We have received assurance from ESC that the work requested by QWEST is not necessary for the project to conform to the National Electrical Safety Code or good engineering practice. To date we have received no commitment from QWEST to reimburse the Town for any work done on their behalf. Therefore department staff have requested Hamlin Electric to complete the clean up items on the punch list and omit items requested by QWEST. The revised total cost for the Big Thompson Three Phase project is $465,365. Proiect Summary Baldpate Big Thompson Original Bid 326,005 432,930 Requested Changes *20,385 **32,435 Engineering Error **15,852 Project Total $362,242 $465,365 * Previously approved $20,385 * * This request $48,287 - 2-2 . RECORD OF PROCEEDINGS Town of Estes Park, Larimer County, Colorado, February 14, 2002 Minutes of a Regular meeting of the LIGHT AND POWER COMMITTEE of the Town of Estes Park, Larimer County, Colorado. Meeting held in the Municipal Building in said Town of Estes Park on the 14th day of February, 2002. Committee: Chairman Jeffrey-Clark, Trustees Habecker and Newsom Attending: All Also Attending: Town Administrator Widmer, Light & Power Director Matzke, Museum Director Kilsdonk, Assistant to the Director 1 Mangelsen, and Clerk O'Connor Absent: None Chairman Jeffrey-Clark called the meeting to order at 8:00 a.m. (11 BALDPATE-BIG OWL THREE-PHASE UPGRADE and (2) BIG THOMPSON THREE-PHASE CONVERSION - REQUEST APPROVAL TO AWARD CONSTRUCTION CONTRACT. Both of these projects were recommended in the Long Range Plan performed by Electrical Systems Consultants (ESC) and adopted by the Town Board in 1996. These projects were also included in the Town's resolution of intent to reimburse itself from proceeds of the sale of electric revenue bonds. The Baldpate to Big Owl project was included in the 2001 Budget at a level of $650,000. The Big Thompson Three Phase Conversion Project was budgeted in 2002 in amount is $390,000. Staff received two qualified bids for the projects, and the lowest combined bid is $758,935.65 by Hamlin Electric. Light and Power will furnish the material for these projects. The combination of the construction contract and material costs should be within the total budget amount for these projects. ($1,040,000). The projects will begin in March, and the completion date of the Big Thompson Project is anticipated by Memorial Day weekend. Following discussion, the Committee recommends that the construction contract for the Baldpate to Big Owl Three Phase Upgrade and the Big Thompson Three Phase Conversion project be awarded to Hamlin Electric at a cost of $758,935.65. Award of these contracts will require an amendment to the 2002 Budget to include the funding for the Baldpate to Big Owl Project ($650,000) that was not expended in 2001. 2-3 RECORD OF PROCEEDINGS Light & Power Committee - November 14, 2002 - Page 3 BALDPATE TO BIG OWL THREE PHASE UPGRADE CHANGE ORDER REQUEST - APPROVAL. The Town contracted with Hamlin Electric Company in February 2002 to construct the Big Thompson Three Phase and Baldpate to Big Owl Three Phase Projects at a cost of $758,935.65. During the course of construction, several field changes were made at staff's direction that added costs to the project. Hamlin Electric submitted an adjusted invoice in the amount of $20,385.00 for the changes. The 2002 budget includes $1,040,000 for the Big Thompson Three Phase and Baldpate to Big Owl Three Phase Projects and sufficient funds are available to cover this additional expense and remain within budget. The Committee recommends approval of the change order request from Hamlin Electric Company for $20,385 as presented. DECORATIVE STREETLIGHT REPLACEMENT PROGRAM - FIXTURE RECOMMENDATION. Light & Power Secretary Button presented the voting results from the Bond Park Decorative Lighting project that concluded November 8~11. The Streetlight Committee recommended the following specifications for the new light fixtures: Town Commons-style fixture with clear lens, 10-ft. fluted tapered steel pole, smooth gloss finish, color-corrected metal halide, 3000° K, 80+ CRI, and horizontal cut-off. Bernie Holein/Streetlight Committee explained the light source choices that were presented during the demonstration and addressed maintenance, aesthetic, environmental, and technical issues. The Committee recommends approval of the light specifications presented above. Chairman Jeffrey-Clark commended staff and volunteers that participated on the Streetlight Committee for their efforts during this project. POLICY AND PROCEDURE MANUAL UPDATE - SPECIAL METER READS - APPROVAL. Director Matzke presented a proposal by Sr. Meter Specialist O'Connor regarding special meter reads. The Dept. currently performs approximately 1300 special meter reads per year (65 personnel hours per month). These reads are performed at the customer's request and are provided free of charge. Listed below are fees charged by neighboring utilities to provide special reads: Move-in Move-out Fort Collins $15.65 No charge Longmont 12.00 No charge Loveland 12.00 $6.00 2-4 RECORD OF PROCEEDINGS Light and Power Committee - January 9,2003 - Page 5 BIG THOMPSON THREE-PHASE CONVERSION PROJECT - CHANGE ORDER PRESENTATION FOR INFORMATIONAL PURPOSES. The Department is in the process of closing-out the Big Thompson Three-Phase Project. A punch list of work required to complete the project has been developed and staff expects to have a cost estimate from Hamlin Electric within the week. Qwest is requesting many items and they should be held responsible for funding same. The original contract amount for this project (and Baldpate-Big Owl Three-Phase Project) was $758,936. A previous change order request for the Baldpate-Big Owl Project was approved in November, 2002, thus the contract was amended to $779,321 for both projects. The 2002 Budget amount for both projects was $1,040,000. Upon receiving an agreeable proposal from Hamlin, staff will proceed with completion of the project. If a commitment from Qwest is obtained, the Department would hire Hamlin and bill Qwest-all within limitations of the budget. 2-5 NOI.LVOI=iIBA 31YJS 00VM0100'NWVd S31S3 :S:=:213&7.'= 900#dVIN. 1 HONI 3No : 1N[iIIAIL}IVdaa M)AA-Od GNV IHD Il .ilil:...m. bL ... >1008 d¥01 0 31V0S >INVd 63193 30 NAA.01 ..WW?nld r L a... g FS§ ~ g §12~Ag REE < ~1 gaggy:1 -§%¥8 j 8 & 1 1! !!! :h J m i R h -LI ' 8 'Ti Ill lill 60®me i© 0 -1 WR h \ j :All ! 8 .b <D 3 1 ///5/ 'D ri5'~0911jn«---7#,al)(/- 9 V./, 4&-- i \10 -1. 82 iN 2: A E5 11 N ¢14 * M 1 84 £ O 48 8 M 0 0< 240 -Ba -ty r mN© gm eu!40e'1111 ..qok¢ u,~,d /d09:2 - 966 k'Et A.le,uqed :Pe#Old 6.,p,lied-selm \SON1MVMO\:0 ~ UV3DHO BALD PATE in] 9 2 /4-f--h ~-1. 70, '3 9 LONG'S PEAK 4 6 ate to Bi 2 Owl Three Mfly'N*l Al¥£3'Ntl MUM'Nel Al¥£@'Nfl NOU.VOUni3A 3TVJS OGYNO103'MMYd 923.63 900 #dM HONI 310 : 1N)]All>1¥d:la )13[MOd ONV iHDIE[ Um))ll*/10/Ill >1008 dVIN 0 NNVd 53193 dO N.AA.01 t.=& 37VJS 25 : *f : -1 * i:Z:M:=3 :52 ? 21 2 iR 1 H !!! 1 19¥ d 8 N 8 2 98 W 9 1 lili AMI 80®ee'©0 3= %\.11.1. U Es 2 ·-· 8l r:/ / MSO¥ ¥ - m · b- oc ' 1 C. 3/ m 05* 31 =*k-, - '017 41 5 g -#LI,ir~ L /9* ·1~00 1/ 4/0 STR. 7 8 36 j wi &15 7 'l " 111 3 1 no g & r - .4 ?§ UU' 0 4 Ilyk / F 40 h noe 3% \ / \9- 5 1 . 41-1-17 1 3 -Un * r 0 - O . 402 0 2 Nt O Z G I m e ; 0 ' L a <1 W 3/ m 811 / W W 4 01 j <61, mm eu!408WN &,ROM WO,d Ndet:Z - 966t'Et k!en,qed :penold 5,~p-4,ed-seise \SONIMV80\:0 ~ T6N,R72W ,Rnw LEi-'~ T5N,R72W flitl oseqd OLLL UOSOUIOqi eig 9170 74 k[SOV 0/I osetid OSENd 6 ms 0 5 IUI g'Z 11@AUOj not T6N,R72W T5N,R72W ./Mers Sli. s Public Works Director's Report Summary REPORTS Light and Power Department - Light & Power Monthly Financial Report - New Light & Power Crew Chief - Channel 39 - Future Stanley Heights Easement Vacation Request - Christmas Decorations/Lights Project Update - 3Com Corporation Grant Application CEs-Zby - Platte River Power Authority 1. Proposed Rate Increase 2. Fiber Optic Line Discussion - Future Stanley Heights Easement - Misc. Projects Update Water Department - Water Monthly Financial Report - Water Rights - Misc. Projects Update 8 a.m. Thursday, May 8,2003 Town Board Room Public Works Director's Report Summary Date: May 8,2003 V94£5245/ TO: The Utilities Committee *4LK,$ From: Bill Linnane LIGHT AND POWER DEPARTMENT • FINANCIAL REPORT -LIGHT AND POWER The light and Power YTD figures reflect the current economic conditions. The attached YTD revenue charts track closely to the following table. A slight discrepancy exists (1.2% table/ 1.8% chart) due to accounting report changes. Expenses are tracking well. Capital expenses are down from last year. The budget-based target net figures are relatively close. REVENUE - UTILITY SALES: DIFFERENCE Actual April 2002 $ 612,617 Actual April 2003 $ 614,281 $ 1,664 Actual YTD April 2002 2,730,249 Actual YTD April 2003 2,762,863 32,614 Target - 2003 2,886,800 Actual YTD April 2003 2,762,863 (123,981) TOTAL EXPENDITURES: DIFFERENCE Actual April 2002 $ 758,133 Actual April 2003 $ 632,067 $ (126,066) Actual YTD April 2002 3,060,410 Actual YTD April 2003 2,828,000 (232,409) Target -2003 3,167,738 Actual YTD April 2003 2,828,000 (339,738) • NEW LIGHT AND POWER CREW CHIEF A selection team consisting of Mike Mangelsen, Todd Steichen, Bob Goehring, Dave Mahany and Tim Rische interviewed three in-house candidates and unanimously chose John McDougall as the new Light and Power Crew Chief. The Department congratulates John and thanks the team for its efforts. • CHANNEL 39 At the April Utilities Committee meeting we reported on a letter from Charter Communications requesting that the Town delay any decision on the Channel 39 RFP Project until their corporate office could review it. The letter expressed concerns over issues such as 1 . advertising fees. The Committee agreed to delay action for 30 days. A meeting between Charter, Greg White, Richard Matzke and Bill Linnane is scheduled for Tuesday, May 13th to discuss Charter's concerns. • FUTURE STANLEY HEIGHTS EASEMENT VACAT[ON REQUEST The January Light and Power Committee reviewed a private service line undergrounding project adjacent to Devils Gulch Road. The project originated from a request submitted by Mr. and Mrs. George Gibbs, owners of Lot 12 Stanley Heights Subdivision. They asked that the Town pay for undergrounding the private electrical service line serving their property. The existing overhead line cuts the comer of their lot to serve an adjacent property owner and there is no written easement. The line dates back to 1967, therefore there is a prescriptive-use right associated with the line. Staff bid the project and T.A. Enterprises submitted a bid of $4,979.50. The project and bid were presented at the January 2003 Light and Power Committee meeting. The bid award was denied and the project cancelled due to the fact that Light and Power Department policy requires property owners to pay for private service line projects. An adjacent property owner had granted an easement to the Light and Power Department to facilitate the undergrounding of the private service line for Mr. and Mrs. Gibbs. Now that the project has been cancelled, the private property owner is requesting an easement vacation. The proposed vacation will be an action item on the June Utilities Committee agenda. Mr. and Mrs. Gibbs have informed Staff that they will attend the meeting and speak against the easement vacation request. I expect that they will again ask for the Town to fund the undergrounding project. • CHRISTMAS DECORATION PROJECT Requests for Proposals have been solicited for the annual Christmas Decoration Project. Those bids were due Wednesday, May 76. The attached map shows the locations of the various displays and lights. Notice that: 1) The Santa Claus display traditionally mounted on the Knoll-Willows property has been eliminated for the year 2003, as per the Knoll-Willows Master Plan recommendation; 2) The Davis Hill Christ figure is not shown. Staff hesitates to install the figure this year due to its deteriorated condition and subsequent safety issues; 3) The display featuring the Wise Men (on the hillside across the river from Barlow Plaza) is also in poor condition and again, Staff is reluctant to install for the same reasons mentioned earlier. It, too, will be in storage this year. The Light and Power Department budgeted $10,000 for repair of the displays, but the maintenance required may cost substantially more. Staff has been attempting to contact qualified individuals who do restorative work on displays of this nature. To date, there has been no interest. Due to the nostalgic nature and sensitivity felt toward the Buell Porter holiday decorations, we may want to form a Christmas Decoration Team to decide the fate of the old displays. We will continue to update you. 2 • 3COM CORPORAT[ON GRANT APPLICATION Richard Matzke submitted the attached application to 3Com Corporation for a grant of $100,000 to be used for the purchase of 3Com digital equipment such as remote meter-reading equipment police car computer terminals, etc. These grants will be awarded in May. • PRPA PROPOSED RATE INCREASES The PRPA Staff and Board have proposed a 4.3% increase in 2004 and a 4.3% increase in 2005. The new rates would go into effect the first of January each year. This rate increase was recommended over several other alternative rates. This rate study was based upon various financial parameters, such as a 1.50% debt service coverage ratio and a minimum of $6 million net revenue per year. These parameters were necessary to maintain PRPA's excellent financial status and bond rating. The rate increases will be passed on to our customers when PRPA actually implements them; this is anticipated to be January 2004 and January 2005. The rate increase to Estes Park customers will be approximately one-half of the PRPA rate increase. This will be in addition to the rate structure recently adopted by the Town. • PRPA/TOWN FIBER OPTIC LINE DISCUSSIONS Rich Widmer initiated discussions with Brian Moeck, PRPA General Manager, concerning a future fiber optic line from Estes Park to the Loveland area. These discussions are in the preliminary stages and substantial costs would be involved. • LIGHT AND POWER MISC. PROTECTS - Todd Steichen, Line Superintendent to report at the meeting 1) We are currently advertising for a Lineman II[ position to fill the vacancy created by Todd Steichen's promotion to Line Superintendent. 2) The Light and Power Department's portion of the Marys Lake Pump Project is complete. 3) The 4th Street/6th Street/Hwy. 36 Streetlight Project will be completed by mid-June. 4) The 2003 Decorative Streetlight Replacement Project is underway. The new Performance Park, Confluence Park, and East Riverside Drive lights will be installed by the end of June. The streetlights scheduled to be installed along the west end of West Elkhorn (approximately 50) will be put in place this fall. 5) The Riverside Drive Underground Project required a late-night circuit switch on Thursday, May 2. The commercial businesses along East Elkhorn, as well as the rest of the town, experienced no power interruptions. The Light and Power Department has completed its portion of this project. 6) The painting portion of the Hwy. 34/36 Traffic Signal Project has been finished. Two concrete bases remain to be poured. The project will be complete next week. 3 7) An outage is scheduled for Thursday, May 8th extending from Mall Road, five miles down the Big Thompson Canyon/Hwy. 34 to the end of our service area. The local newspapers and radio station were given notice, as well as the affected customers. WATER DEPARTMENT • FINANCIAL REPORT - WATER I think that the drought as well as the economy, are reflected in the Water Fund YTD figures. Revenue from customer-use sales is down approximately 7%. The year's franchise fee, housing schedules, capital project engineering and meter inventory represent the difference when compared to last year. Otherwise, the comparison is relatively even. The budget target net figures are good. REVENUE - WATER SALES (Water use billing only): DIFFERENCE Actual April 2002 $ 117,257 Actual April 2003 $ 99,238 $ (18,019) Actual YTD April 2002 549,612 Actual YTD April 2003 509,938 (39,674) Target -2003 545,760 Actual YTD April 2003 509,938 (35,822) TOTAL EXPENDITURES: DIFERENCE Actual YTD April 2002 $ 888,512 Actual YTD April 2003 $ 995,667 $ 107,155 Actual April 2002 175,349 Actual April 2003 183,573 7,432 Target - 2003 1,220,449 Actual YTD April 2003 995,667 (224,782) • WATER RIGHTS The attached projected 2003 water rights usage table has been updated. We are now projecting 305 Ac. FT. of unused water rights. Greg White is contacting various companies to discuss the leasing of Town water. A few parties have shown an interest in leasing a 200 Ac. FT. White will contact them to attempt to negotiate a lease. A buffer of 105 Ac. FT. would still be available to the Town for unknown conditions. • WATER DEPARTMENT MISC. PROJECTS 1) The Marys Lake Pump Project is scheduled to be complete by the end of May. The work remaining is electrical and control-related. 2) Ken Zigler retired last week and we are advertising for a Water Plant Operator to fill the vacancy. We are also advertising for a Cross Connection Control Specialist (Backflow Prevention Specialist) as budgeted. 4 . LIGHT AND POWER FUND 2002 VS. 2003 MONTH CASH FLOW COMPARISON APRIL APRIL 2002 2003 Difference Revenues Utility Sales $ 612,617 $ 614,281 $ 1,664 Other 12,323 33,369 21,046 Total Revenues $ 624,940 $ 647,650 $ 22,710 Expenditures Operation and Maintenance Expense Source of Supply $ 308,915 $ 314,475 $ 5,560 Distribution and Maintenance 90,167 84,093 (6,074) Customer Billing and Accounts 43,879 40,437 (3,442) Administration and General 69,835 90,595 20,760 Transfer to Vehicle Fund 368 2,617 2,249 Total Operation and Maintenance Expense $ 513,164 $ 532,217 $ 19,053 Debt Service 25,145 24,917 (228) Transfers to General Fund and Museum 61,396 65,661 4,264 Capital 158,428 9,273 (149,155) Total Expenditures $ 758,133 $ 632,067 $ (126,066) Surplus (Deficiency) $ (133,193) $ 15,583 $ 148,776 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. R L&P 1 LIGHT AND POWER FUND 2002 VS. 2003 YTD CASH FLOW COMPARISON YTD YTD April April 2002 2003 Difference Revenues Utility Sales 2,730,249 2,762,863 $ 32,614 Other 68,459 86,987 18,528 Total Revenues 2,798,708 2,849,850 51,142 Expenditures Operation and Maintenance Expense Source of Supply 1,438,921 1,404,778 $ (34,143) Distribution and Maintenance 363,328 364,899 1,571 Customer Billing and Accounts 193,883 210,510 16,627 Administration and General 361,811 338,322 (23,489) Transfer to Vehicle Fund 1,472 10,467 8,994 Total Operation and Maintenance Expense 2,359,415 2,328,976 (30,440) Debt Service 100,578 99,667 (912) Transfers to General Fund and Museum 241,419 262,643 21,224 Capital 358,997 136,715 (222,282) Total Expenditures 3,060,410 2,828,000 . (232,409) Surplus (Deficiency) (261,702) 21,850 283,551 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. R L&P 2 LIGHT AND POWER FUND 2003 TOTAL BUDGET VS. ACTUAL YTD CASH FLOW ANALYSIS YTD Budget April YTD % of Target 2003 2003 Budget % Revenues - Utility Sales $ 8,019,012 $ 2,762,863 34% 36% Other 378,180 86,987 1 23% 33% Total Revenues 8,397,192 2,849,850 34% 3696 Expenditures Operation and Maintenance Expense Source of Supply $ 4,219,944 $ 1,404,778 33% 35% Distribution and Maintenance 1,153,430 364,899 32% 33% Customer Billing and Accounts 862,685 210,510 24% 33% Administration and General 1,187,438 338,322 28% 3396 Transfer to Vehicle Fund 31,400 10,467 3396 33% Total Operation and Maintenance Expense 7,454,897 2,328,976 3196 3396i Debt Service 299,000 99,667 3396 3396 Transfers to General Fund and Museum 787,930 262,643 3396 33% Capital 1,057,380 136,715 13% 33% Total expenditures 9,599,207 2,828,001 29% 33% Note 1) Charge for Services target % based on previous years data. Note 2) . Source of supply Target 96 based on previous years PRPA invoices. Note 3) Transfer and debt service are annual amounts accrued on a monthly basis. R L&P 3 S. GUNNISON , FORT MORGAN LOVELAND LONGMONT FORT COLLINS HOLYOKE COLORADO SPRINGS CENTER 1 • j ASPEN POUDRE VALLEY ELECTRIC ASSOCIATION HAXTUN HOLY CROSS ELECTRIC ASSOCIATION GLENWOOD SPRINGS 1 ESTES PARK . *H e .330* AQUILA NETWORKS WHITE RIVER ELECTRIC ASSOCIATION HIGHLINE ELECTRIC ASSOCIATION FOUNTAIN INTERMOUNTAIN REA YAMPA VALLEY ELECTRIC ASSOCIATION o ESTES PARK 2004 (WITH RIDER) LAS ANIMAS XCEL ENERGY -1 . 1-l h. b . 1, FLEMING LAMAR Y-W ELECTRIC ASSOCIATION | GRANADA $ LYONS 1 HOLLY 1 tj WRAY UNITED POWER INC GUNNISON COUNTY ELECTRIC ASSN 1 SPRINGFIELD 1.-1 1 OAK CREEK YUMA FREDERICK _ MOUNTAIN PARKS ELECTRIC j LA JUNTA GRAND VALLEY RURAL POWER [ T BURLINGTON DELTA TRINIDAD k ~_ RATON KC ELECTRIC ASSOCIATION EMPIRE ELECTRIC ASSOCIATION DELTA-MONTROSE ELECTRIC ASSN IMOUNTAIN VIEW ELECTRIC ASSOCIATION SAN MIGUEL POWER ASSOCIATION MORGAN COUNTY REA SAN LUIS VALLEY REA SOUTHEAST COLORADO POWER ASSOCIATION r ~ JULESBURG O 0 0 H -z 00-1_1<mu) LLOCI hOO F R I SOURCES CAMU INDEPENDENT SURVEY MUNICIPAL INVESTOR OWNED ESTES PARK FOR RURAL ELECTRICS, MUNICIPALS AND INVESTOR OWNED Ul - $70 - $60 - $30 - 02$ - OL$ .., 1 ~ - 11 0$ $50 - $40 - =j . k .. . 4. b '' • 6 4 * *e I 1 . + p..4 4 ' Ar:.') IN, , 4 , . ti .0 ' . V. . 7 4 I \ 6 6 · L ¥ e . 1, 4 6 4% 43 \ '0. ''i I •91 1'. . 4. , 1 4 , I , 4 r. -P I . b. , 1 41, 44 -, t:X, j I. S & r' , 1 + I b. / 6 . .4 + 4 , 1 9.0. ~ I 1 L Z· 9 b * S . . 1. * 12.' , 4- * .4 ..4 40 . 11 1 4 . .4 4 + , IL . 1 .... . $ , - Wl 4 ' * 4 01 1 4 , ..1 , + .1 142 I h I A % 4. t , ' A 0 2 - $-4,.'47 4 4 . 4 0 t..4 I ,- , 4 4 I 0 1 I i '. 4 . . 1- , I. 1, d i . e. 4 r . 1 0 . d * 4.17\ 9 1 1 . Z ft .4 * 4 5 $ ** 16 . 4 f 6.< '4 h 5 1-* 4< ,-LUL . O-00 k |p / 6 . i i : I,, .4 · - L J+L I ..k e ILl 41. . , 4 D « 24 4.,F . 1.f ~ C. * 2 51 7+ 4 , , ... =,~L . rf'q I A 1 4 ", O, . 1, .4~04 1 - .- 1 '* r f 64 1 , 4, 1 0- 01,13 4 ' 4 7 ~ r , .1 \'. . 5 8 8 r. 4 - '1%'*\2 \ ZU) .4 .· 1 o o o '' L i ,4 ' *kf 4 :,it. ic.. NCNIC\1 . + 4 *I f $* 4 0 •- 1- 4 J. * 1/ * i'¥ ' 4 ..4 1 A . \ 1 f . - 4, 4 0 - ·4% 1 4 4 I . 4 <4 4 I .1 * $ 40 . -A .+ 1 L 1 , :k , 4.A . & L 1 4. -6. i ..1 1 i 1..' . ./ r w " 1 '' $ . I'. 4 . 'll' 6- 1 I ' ' I /00 41. I F I ' .,4 11 1. ,P A -. t. 16 ... 4, 1 ...2'. . ie. . ,#. ..I . , 6.1 1 1 t. 4 / a I 1 4 2. ¥ 4 If 1 .50 h 15+ · ' 44 ky I e 1 :4.4 - ¥. .¢ . /.. , .4 .46 . 1 ' 0 * 4 I , 41 1 4 4 O 0 , O- O 0 t» O 0 go 0 8 + 0 00 1, i . r * 4., 52 7 9 6 --¥ a. f fk . 2, 4, &,r t . . 9 1 k O .. O . .¥ C . AAM IN31SAS . ¥ 4 , 41 -Ali, i 4 4:f 1. I 1 ff .' .47 . . i . f.9 . " 44 i f #/ 4 -1~~ $ * 3 4 Loadh99.xls 5/5/2003 des ' ,441 e FESTE EL-d91 hi PUR¢ 23000 - 20000 « 00* P I. . I.-- - O N M -- 1000 CD CD 0 ' 10_ f-/Ir N (N N . i - 64 V ¢080 - 4 - 1 1 -4 1~8§:*9**3******SS***%*%8**%*%8**i***%8S*8%8%8%8**§83*% (/ . T.J: - + 1 1*8**Sm*****§82%***sm*MeNS**ME*Sis# 4,- U 13~.1--0 1 t 13$$$*%8*****S%8*93$%8$6$*3§*%8*SMSMS*88*%8*sk ' 1 18**§698*$$*9**%8%893§$$$%*3%8%8§*§8SMS***9:*RE 1 M I - #MW#AirFWa#AW#hmlzEMALSW/WFAr/WhN,AWAFRMr&* leSSMS*%**%89%8%**%8$$*%8%89*§8%***99%8*Rk 8? 1*%8%8*%83%*§*%8**8*9$98*$66$%8$$§9*66$:**8%8*$8$ ' 1 1 - 230636600*302j2*a52*232355~228,45522+Abas~aeR*85**99**5*55*5*995*995%3 IMS*%*48*§99&**8*es****%8*%*is*S*SMS**§ : 1 F«** A. -~ ~ ~-' ~* * >4*0*<,4*¢•C,i~*,O%*ix#*¢444«K<·C: ~ ~ ~ ~ ~ ~ <4<42**%>kXX ~ ' l Si**8**%8%$8*%8*%8%68**$*BRiS*$***%89$s*$*§*Mas***a ' 111 - 1 + 19*§*%**%*%8*sis**8********8*%8%8%8%8*%***R> 7 Ika€**&«§6**&§&*ae*8§&**&**a*&§$1***&~ · Ill 1 1 1 ;~ *~"-1 -1-4 *IL .111 3-~ : :4- ~ : 1 1.1 1 - - - -el --* - *4 3 4 *:/51*44F~#44/1#' 20:ir, ' J..lf t~U,J~, If'l /3 7 ' T . 6 9'4- 6496:, &. 6.- 1. ·- '- - Loadh99.xls 5/5/2003 El·-d91 hi 6 . 4 4, E 0 .. A * 11 . 4 i .04, I . # ' : ..t, '34 ' . p ts. . , 4 *f' ,. t'' . L.* 16 . 116. 1 -4 4% , -1 ... r f , 4 , 91 b I ./ *I k - . 1 .'* i .A 1 J * * r 7-, e -311 ..4. t , 1 - 4- a il*%~8%*Nem*2***%*Nem*NS******Ne*NS** 4 1 . N $ . *- 9% $ 1 t. . ..6 * $ 4 4 137 ll, 0 i * 0 .4.' . » 1%*~***8*§84**%**%*~88§**Be***$ 4*, 1 J€ ¥ 1. - . 0, f #.4, 1 \ .. 04 . 6 8 -74'#00.4.r.ARb:„~4.0/.'ir.*0%~~.~EGE. 0#ri#,~0 0.4.0.0/..~0*..4.44:46*0:00#46.. tMI 11 4' ' r . ¥ ' C . /4 . * @SRMS***%*%*Mt#,00'440/0/0/4/tikk./.00*,0.*000*40./.4/04/04/40#4% I I .1 * ' .1 4 f .r 44 1 4 4 N , .2 . - A .= 114 4 * 1 . 79.4 1 6 4 W I *4 . t....,4 4 12 P 1. .1 1 f I*S*%**%8*S48*%8%83%8*%*%8*$$88%8* 2 . fi . 6 iR I . ¢ 91 -y k p I >7.3 /4 4 € - ' r ' N, $ / , .\1 2 1- ... 1 1 4 1 . A *. E k 1 * h 4 „ 6. . I 1, 1 TY I . P i . *421 . . .' ' '· + I. $ : f 4.t .....1.1...11.-111- 1 - 6 ¥ 4 Z f .. . .2. 69: youxawme=<€€€€·vAL:: 67GFOX·X:Y·'·~·I / a 4, , c 1%***sis**Ris****BAS*,-~F r. Ar p '*h.4 . 8 r 4 + I . 1 Mettteke**%42*% 9 c G '2 ' O 4 1 91 - I . , A . 4 I *Il ' . 4 ''..=ill. $ , 1 4 + .... <114 29 - 40 1 • # • 1 9 , 4 - 11 - .. 'F 1 $. i + N . 1. , 4 1 5, r I * A. 4 Al.4 , . . ...4 * -6 I. . . c- / 2 £ of * i O' O, €* 4 .04,6 -4 8 4 R $ 4 0 + I. O 0 r - '1 ** + ¥ 9 M l 8888&#A#,88*j„,i„,r#bmes*wem. & 1 ' i / 3 . . .A¥. 1 :,'. f 1*1 2. peseqo.Ind'HAAIN 01* 1 .:t * I- 11 f *af . , O 40$ .. . r. '. + 4 * 4.4/ . 1 Loadh99.xls 5/5/2003 02001 Cooz m %6~9-0 Mr-r . i.. .. 9*6 £911¥ .¥ YEAR-TO DATE ENERGY PUR H *L-d91 23 t. 1001 SA A 100000. ' -. 4 * 10 80000 *00002 . , ' r. 01 ¢9 4 . ..0 0 0 - IL a .0 2 2. .4 4,4 . t.el ). . . - , I 7, f 0 -r-,4 - 1- -- . $ I r U 111 W - 1 . A * *64 $ I. . 1 4 v . 9 1 I 14 * 4, . 4 1 4 .1 " 0. 1 I. 1 . ... I. 4/ I k# • /,4 . 4 · 1. 0 16, 4!6 0. 4 , . , 14*4711,76JM-NAr#TM-MHI,at'4··2·4 6, m k m 4~A;Ma'4'2 2 1 I . 11 -* 1.. . .4 . 9 7.. 2 :3. 4 , - 1 f 2 4 , , G £ i ' 1. 0< 1< 4 '' ~ %¥ 1 AL: .1 .% I -. i » $ . .. . L i, . I - 11 ./.2,/ . C . I ==,4 - -7 - -- . 1°L . R. . 70 46 2 -% ,~ .36 - 6 .- 1, 8 t .PRV#APQ'0QW#*pu*FRAPA%~A*OR Al . 3 3 t ' ** i. N, L . 1 i ., I * 4 4 14~•A~,Pip;291,4410*30@,0000000gl@% .0, e 1* , ,~ ./ .0, A 14,1 . 4 6 .k . 4 m 1% . *> I e.14 41. , & 44. * 1*PAPP0~~#.AMWMAAWBAA< 74, - '*· . ..411 U. I 4 44 A a,Z 6-:47: j. . . t I Y.lt vi' ' ~ . 4-0 5-1. 0,-i . t. ,4 ..4. 1 14 + -All»,»2»A VII 4 4 4 * 1% 1 ~ Aff<%4$%%/<%944**~rid 4%2 1 +94* I , -2 1 . % 4 . 1 1, 4 - . 4 .' 4 I t. 1 P........................: 4 . + .65 ..... t. 4 4,46 . -,»1"5454&'j'bbiC##AA#N#,A*ha l .. 'A 0 1 - 14. V .,1 1 . ., '¢ 4 +I 'C il + r------. .................................................1 'b + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 I. ............................. 6- I ... ''642*9,.%Nwe0g,N'*,m*,2*42~2~21* 4 + .I 1 1 . ¥¥ t 6. 4 1 16, .1 1 .1 1+ + + + + + + + + + 1 + + + + + + I + + + + + + + + + + + + + + +: I ........................... 1 1 . , ....lili.........................i '04 4 ./ )1%*tgrall»@IQ'j<PA*P~rigurirAY,22021290@,aN uAl• t .- . 4 9. . . 4 91 . 1. -1 P < ... I . S F +.+++.++++.+.+.+++...++++..+++++.++ . . . . 1 . . . . .... .'....i... .. 6 I . .... ... I •1~419;i<:44467674/MARB##9464444?0796/69960061 *1 9 ' 1 1 ,]. -/ i .o' 4.6 % I 4 0 4 04 48 0 8 0 0 Ci ·O' O 0- 1 - !6 6 4 2 i 4 • 1 j- 1 1 . 880 25 25- . Ch O%,4 0 S. 0 0 10.4 I 1 , J --,- ($) S*IVS *1H1NOW, , ~ . t.-1 # 11 1 '1 d ' 1 t' .4 , 4* SALEHIST.XLS 5/6/2003 O N QF'ESTES ARK •ELEC~RIC SALES B MONTH Gl.-d91 hi unt ' , . ega i ... uer* '0®too . ... 46 6 r . . 4. * 6 1 1 / 1 : 0- 4 A I - (\1 (9 0 . 1 0 0 0 1.2--4 11 I . - - V /**n '0 ... 51 2 8 + .,2 '5. -0 4 . 21,1~ 4 r 71¢ § 1 . 15,441»; 0-· 3, 1«934»«969«» u w '1*1, I. 1 --,1 9,/4 1 :, 1 1 . 0 1 0 -1 · t.- '1:If, . 1 + - 1.1, 2 - L •44 $ Li 1 4~ 41 $1 *p . I, 1 1·x»91»9xxx»»<9««««4«9»60««x . L. „ 1 ./ 4 . 4 0: 4 4 . 4 . r f ,~ . A, ,1 4 1/, : 162«44·4«42«9··«»««vvf.iq %/Cti: -·4 :t , I ,%. 1 1 * 1 4 14 0 4, 4 =r ,< C ..1. 1,1 +4 4, i V *. 1 ~Wh...2/ I J:43 :~ 4 * ' 4 6 0 k«xtt<«««A<,CY*YX'fig~:~k:~:42:~,4' bk 4 b. ~ he ~ 1 P 1 , I. I - I I 2 * . * .1 I 4 1 ' 2 +IAK),Attgripprptprprprprk» :m U.1 I . 6 - 4~ 1 , A 7 -4 + I •r a -- 6. . - 4 4 >. . 9 4.6, 1 7 - *44.7 * - 0 -' .1 -. **4@ 0 * IXVX»xf*«*r'fr~ryr14Arfrfkvxv» 4 *,0. 4 1 C .\- t . - ' 1 1.- I #b 4 1 UfrO 4 + -2-1/ *.1. $(rjf~ 4 0 IF , 4. toi' - 0 '1. I 1, LU I 0 "t · -#4cY«««Nx>«4«4«Yx* , O- i ,r 4 %'. . 1 00, . t ,4 f i 0 '61. . 4 + . Z -4 1 . . $ 11 , t>%* 4, 1 •.5 • 1\\60«»6660«·«t« Pro 4 , 4. ' 4 - .6 1, 44.1 ..4 $ f . / 4 - 4 . S - $ -t * » i.f '' 22~. .0 4 9, O 8 - 1 12™7 102 I " 4*- ~. 29, 4.49 41 1, I I , 4 Ivy,reeere©* L ¥ 4. , 0 1,: 4 - 1 1 0, EPPErp\Nkly . 2, $ S .1 1 4 At . 4 I h . .* . h + * ** <. *si-ree#*::- . . * 1 . 4 1. 4 4 ky..2.2. P. 7-0 2. t. ./ I 1 r *4 . . * . .. I 1 4 4 . 1, 1 %1 0 . > r F .1, • 0 4 , 1 + 1: 4 6 1 . 1 0 0 . rn . O • 2 1 O 4. 4. 0. .0 al ~ ·04 , + CE * O. O 0 O/ C) ' Ci' + * 0. 0 0 )81 * ...1 r. Of 9 ' 0441# ·.. ..• 1, 24 , 22 3< 2 _ <64 , :~ 7 '-' + ' ./ I »' iNS 9 i ($)fia:.* alva 01 M¥,A ur ...t .e 6 1* 4/ A 4 + 4 * 2 I. A . 4. . . 4 J 0 . 9 21, SALEHIST.XLS 5/6/2003 5 a ~ pN.. ,!!Ploo , ' des, Un f 4 f.. ' ,YE R TO DATEELE 9Pd91 H 5,000,®0,- 0» · ·- - dbo'000'* ' - '-- z -'000'000' L 000*01 4=, 006'000'Z 5/6/2003 . 9/ I --4 4 I 2003 Year-to-Date . . Electric Revenues vs Budget- . 4 9 4 47 1 ¥ . . 9,000,000 . / i. . . 4 8,090,000 *t ' 7,000,000 .- r .*. 7- . - ~- - * 6,000,*000 , - " · 5 * 5,000,000 .6 - - - - -r- - E Budget 1'11 - 4,000&000 ' · . - - - - -- - -* I Actual 3,000,000 · -- - - ---- 6 i' I . . 1 2,000,000 · - 11~ -2.- -= _ 1,0.00,002 -fil- J .. W 1 L, I 1 -01 . 1 1 16.1 1 1 1 M .* C ,.3, 0-4 0. U .5 > g ·c; ir·i < a'g .-, 4 35 0 3 0 I I 2003 Year-to-Date .. PRPA Invoices vs: Budget 1 1 4 I • 5 e. 4,500;000 ~ ' ~ ·- 0 I. I. . , * 4,000,000 - 4 3,500,000 . " 9 - . .4. t, 1 . 3,000,000 , - 2,500:BOO ' - - - - -- 0 Budget 4 !3' 1-{ 2,000;00011 t - - - - -- - -4 •Actual 1,500,000. f,000,000 · 111,1 . 4 4 5:00,000 ---~- . 0 LIt , 1 1 1 , I t M & 25 .c g tik' a W (D , W 1.3 = 3 0 0 -)11-J<knn '<U) Z R L&P-17 Por I)ate: April 4,2003 To: Mike Mangelsen - Head of Light and Power Department EP From: Frank and Jeoffrey Schageman Subject: Rescind "granted utility easement" We wish to rescind the utility easement that we granted to the Light and Power Department in 2002. This easement was intended to accommodate the underground placement ofthe overhead electrical lines on the north side ofour property but now that this project is not going to materialize, we wish to have it reversed. The granted easement was solely given based on the needs and benefits of such a project. We wish to have something in writing from the Light and Power Department stating that the utility easement has been cleared from the county records. Thank you. 4, / Frank W. SchagemAn 6*/'Jed;irey'f. S¢Hageman - 2215 Briar Park Drive V Houstons TX 77042 RL&P4-1 :671 - - A Ar¢.5, /1-7T, h LLI I. 12-40 -DEV/L-6 41 01-£,0- RIL- M „-1 GIBBS 1--0---- X Ld 1- LOT 12 D 0 Lf) A -1 CU 2519205012 \ k €- *SAA_. V.Ad.Anod Me&,0,617--a~*4 1 J By SCHAGEMAN , i IN A oer,+ 441£ LOT 9 £ff_~ 2519205009 Jl /0 i t_ocAr„,4 1- / lil)~ RLaP4-2 1 /,S'l·-4,2 En42»,eJ·r-- ,/AkA-no.j [3 r, ·r:.1. iAN J -' A. CA Ay 04 -b L 19205011 1 RECORD OF PROCEEDINGS Light and Power Committee - January 9,2003 - Page 4 TRENCHING CONTRACT - APPROVAL. Two small underground projects (Stanley Heights relocation of approximately 450' of overhead single-phase primary underground and the Dry Gulch relocation of approximately 570' of existing direct-bury primary line and conduit installation) were bid with the following results: TA Enterprises $ 9,238 Duell Excavating $17,680 Director Matzke explained the unusual circumstances of the Stanley Heights relocation where a customer paid for underground service (perhaps in the 1960's). The customer believes that the Town constructed an overhead line across the property owner's site to serve a neighbor. 4 Discussion followed on precedence-setting policy, with the Committee recommending / the request for the Stanley Heights portion of this project be denied at this time, proceeding with the Dry Gulch portion in the amount of $4,979.50. REPORTS. Platte River Power Authority. No report at this time. Financial Report. The Committee reviewed the November Income Statement and associated graphs. Discussion followed on the delay between financial reporting and the Committee meeting schedule, with Finance Officer Brandjord and Light and Power Director Matzke working on improving the financial reporting method or moving the Committee meeting to accommodate the financial report. Project Updates. Personnel: two employees retired in December - Ron Hersh and Ed Dragon. Todd Steichen has been named Interim Line Supt. and Rick Emerson was named Interim Crew Chief. The Line Supt. position has been advertised nationally, however, in-house employees may apply as well. A final selection should be made by the end of March, and a former joumeyman lineman has been re-hired and he will begin work January 20th. Administrator Widmer noted that the line crew is moving forward with a positive attitude, and workspace improvements are being made. The decorative light replacements have been ordered, and a savings of approximately $400/fixture has been established. The first installation scheduled at Performance Park (15), and Chairman Jeffrey-Clark suggested a ribbon- cutting event be scheduled honoring the Team's efforts on this project. The Electric Rate hearing is scheduled 1/14/03, and staff has received a limited number of telephone calls. Approximately 25-50 emergency beacon lights have been sold thus far. There being no further business, Chairman Jeffrey-Clark adjourned the meeting at 9:34 a.m. Vickie O'Connor, CMC, Town Clerk RL&P4-3 . - pgu TOWN OF ESTES PARK '\44 I *>* -1-4 . 9. Py:41 6. '. ., »-334 7. 4.41 »4 4 .24<p. 37 1~8 ><:1«ilttRAY- -- - - 01, V.Ni.l t\Z /-~«21 91*. L./'457 ~%91.,·=, _3.-·/·9·A,<e*'%7¥9~-' -r F'l'r 7...9/4/A,% , ' February 18, 20~\ Mr. & Mrs. George Gibbs 1240 Devils Gulch Road Estes Park CO 80517 Subj ect: 1240 Devils Gulch Road Service Line Burial Request Dear Mr. and Mrs. Gibbs: On January 14, 2003, the Town Board considered your request that the Town pay to bury the overhead service line that crosses the southwest corner of your Plpperty. Based on a recommendation from Staff and the Light and Power Committee, the Town Board denied your request. It is the Town' s policy that overhead service lines shall not be buried at Town expense, Thank you for your patience in this matter. Sincerely, TOWN OF ESTES PARK Public Works Department Bill Linnane Director DS/mjs CC: Rich Widmer Richard Matzke Bob Goehring RL&P4-4 http:#wvvw. estesnet.corn (970) 586-5331 o RO. BOX 1200 -° 170/-'AAC GREGOR AVENUE ° ESTES PARK, CO 80517 & FAX <970) 586-2216 i _ : i a- "- , V . 4 J//7 - Li ~.-1 , P.dat . . et P f r .* T 11: - 6 - I . f i .4 .. a . -4,/74 1.. 4 €, U 4 C i 0'* L . l~4 J D 6,4 fac 0 - 00-1/442 hi* * .. 4.,44,*.* .9. 4 1 . .ble .-1, '9=& =4 1.-7 . pr 1- 5 4 , /0/4 3, . r - I--tlri /-1..Ful. I. . ., - t< . ..1. . , I t ¥ I. ' i .1,1 :722 1, ¥ , . 1 - 4its;rt¢Daf:68GW843, Grants, loans target digital divide **ibet:Iye.*U*c, lebratedfon 32· Grams16~EFinge--digital-digiae~ a broadband 16an if no other eligible *#FEMB£65*theitthbiRd?fd(Met.6:1 ?49%4~'AidAP~,1~4~3~4£~:b~*14 (4~~~:,~i.,~-I ~~coaiQoGn~7o~raa~eo2oiIE ~ applicant is already offering or has committed to offer broadband services -{MlieE#**Altittbft-stifdtioh)*10 / grants to help bridge the digital divide to the eligible rural community. F,:&*OOM4~./&c;*3*·i·-1· 4-:.-v·'.=tA43-4%47.1.'::·t.:3' / U w 90*adol#Actf*U by improving school systems or gov- ~ fit '#MAN,ew,teie o P- *'2 4·142. - ' ''·1 1 eminent services. Since 1999, the / fiC~*rit#porid@%0}09 AA <4 -1 · i':r'6*r•,~3;'·1'47/ 2-9011**teldb-rifibgisoalt:~ 3€om Urban Challenge Awards *h=El.£237 Wifi3Ff;&31#li*#91· program has issued about 40 grants 4;r... 4 '.1 4.4..: r I worth $4 million. 42 A~/~7--5 44,5.,26:k *9*4*4~*Ii dY*--· «17 Applications are due April 21. V it ~029,1989.-T~,6*40,0» theWeb www.3com.com/solutions/ ~~ea*Rl!§*gDO't en_US/government/programs/ S {3~0¥A€** ·033PP%*81'1044, urbanchallenge_contact.html to Fien-*st*i***+4114424·6.,4.41-i"'1 1 download an application. gr.tie';hied>Statesfot. Afftench»*$14·' \~~£ 51'I-ye: oans for rural br and The U S Department ofAgriculture ./ ~3~44.+4'.42'r ·v:*¥**2*CAF*146ff Rural Utilities Service has loans avail- C##*~eatedfofficials:·atet ent-Outb:ot'lt able for the deployment of broadband - I€*t@*t*ENEQ*%44· Internet service to underserved com- munities. Underserved communities 990 y *9' vrA,k,*71.42 Applications are due July 31 for ittofttainioof(0*15kcl#aboir bt - 7~?8·, are defined by the RUS as having funding from the national reserve. For in!~ fewer than 20,000 residents. Eligible more information, visit the Rural Emtnititutton,farid,thlitib-%tild€lit** applicants include cooperative, non. Broadband Coalition Web site at 3.21*mab~» #0*, 2 ~WL·'14<,24·. 1 www.ruralbroadbandcoalition.net or ' ¥al)Dottfibse#Ofindin#iddeumdlits;i, profit, limited dividend or mutual as- r·*·20'*' ,aae'*---" as %4,1-4pi¥. sociations, limited liability companies, contact RBC by telephone at Indian tribes and tribal organizations, (703) 477-4705 or by e-mail to 45.,09:19»'6: 'P. -y'*'54%:17 and commercial organizations. State or info@ruralbroadbandcoalition.net. • 211411&~8195%1%1059**4 local governments will be eligible for *difools*®@tiate.:44,%WisU r·-40-0 nt , 0 0/ h V./Lro -WI . 2 6 0-0-I %*hthfa»ib*yi120&401 1 07,~4 0 MA...4 : a.,44, 4- L-:l•-k. tip *gygl *92&6:t~~~.,0.~~~:,2,I':,.~.~I~:,I.6 ::-.~~ Educational offerings- UMN&@fre-ast<*>Yallek.*.1%%*fi Colorado Firewise Communities **§¥1637§92%fFE&41&4*jifu Continued#om page 3 3~t:toit#fa*lidl~%0,**0-,W# Community fire preparedness Worbhop· 'The people who really :tr#Abi#i *Agvt·:2-6.:--2· :,A. '2, 4„IM: t···4#,¢4§1~31, The Firewise program on commu- influence how safe we are from fire ZE**84359286810-rtul.36..·2-:94,> aren't the firefighters," he said. "We're 43?Ay(.149¥42~588-2 c:<1'-·' -:.: ··~·1...: nity fire preparedness will be held an important part of the Job, but today %.4&-df*Riliilik*t8hl,4 -f 7....... April 9-11 at the Doubletree Hotel in 1: 2 .0 with these big, intense fires - the kind 4%&?918}j9454%74*42£-·," - -1 :·.4 .' ».. Durango. Nearly 40 federal agencies, A¥ we're generating in our state too easily 1.4.mfo- 'rrib¢iA'fatihhiid©visit the-: ..rJ . . - ,- -,6..1.-e :. ... ... ~ J. i national organizations and private - fire protection really begins with the -~,bj·t·~?;149' 41€y r#/ 1.-· companies sponsor the national work- * e~rat.w.WW;libettuay:orget.:\*e.' homeowner, and the people who 'W . shop. Workshop organizers encourage design, build and landscape our com- 44,2-le- t€ ...9-1 ·.- elected offcials builders developers 1 , , ' munities. That's who we need at the le'l,35,69. 97•,i -·iM ofi~ 9014-#42237'I' 4*: -'4* landscapers, insurance agents, real discussion table, particularly as we're estate agents and planners to attend in facing another fre season in drought ---11,1-4241 - 1 aty ti to emergency responders, conditions." 'in<.-,6,-e~ r·-444*.6 suc s firefighters and Red Cross To learn more about Firewise and workers. the workshop, visit the Web at Durango Fire & Rescue Authority www.firewise. org or contact Noonan at Deputy Chief Dan Noonan is (970) 247-3332 or by e-mail to Geographic Coordinator fbr the noonandj@ci.durango.co.us. • 4 RLaP6-1 Feb. 14,2003 Town of Estes Park, Colorado 3COM Urban Challenge Program [Ilke timlk/9 f fuL] / Es 'P~ 2003 Grant Application RL&P6-2 3Com Corporation Urban Challenge Program 3Com Corporation, in partnership with The U.S. Conference of Mayors, is pleased to invite you to participate in the 3Com® Urban Challenge Program, which has awarded over $4 million in grants providing equipment, training and consulting to U.S. cities. The program is designed to help cities and school districts utilize technology to improve education curriculum and public-sector communications systems. Each grant is in the form of $100K worth of 3Com networking equipment and services. To participate in the program, please complete and submit the following application to: Larry Geller 3Com Urban Challenge 3Com Corporation 5500 Great America Parkway Santa Clara, California 95052 Mail Stop is 10310 You can submit your application, and e-mail questions, to: larry_geller@3com.com Application Deadline: April 21st, 2003 3Com Corporation Urban Challenge Program Application Form Visit our World Wide Web site at www.3com.com/urbanchallenqe to learn how other cities and school districts have developed pervasive communications strategies to enhance educational curriculum and help reinvent governmental processes. Applications for the year 2003 3Com Urban Challenge Program are now being accepted and can be sent to: Larrv Geller@3com.corn, or 5500 Great America Parkway Santa Clara, California 95052-8145 Mail Stop 10310 Name of City/Public Organization: Town of Estes Park Address: P.O. Box 1200 City Estes Park State CO Zip 80517 Key Contact: Richard Matzke Title: Senior Electrical Engineer Phone: (970) 577-3582 Fax: (970) 586-6909 E-mail:rmatzke@estes.ora Alternative Phone (970) 577-3800 Current Project Title/Initiative (if applicable): Brief Project Description/Statement: Improve and extend Town of Estes Park's Network infrastructure bv expanding gigabit fiber/copper Ethernet backbone. Upgrade reliability and capacity of existing network connections between facilities and departments bv conversion from copper to fiber. Extend network connections to remote facilities using wireless bridges. Proiect will improve flow of information (GIS mapping) citv services, emergency services, electric and water utilities) between departments and ultimately to citizens' of the Town of Estes Park. RL&P6-3 Note: 3Com's Urban Challenge Grants provide for the purchase of 3Com hardware, software, and/or professional services: 4 $100,000 in Products & Services O Other (Explain below) How did you learn about this program? Colorado Municipal League Newsletter I certify that the information set forth in this application is correct and presented in good faith. -i drgz=r Authorized Signature Date 4/18/2003 Senior Electrical Engineer Town of Estes Park Title Organization DESCRIPTION OF YOUR COMMITMENT 1. List below any public-sector and information infrastructure policy initiatives/projects that are currently underway or have been proposed. 2. List below key education priorities for your administration/organization. 3. Provide an example(s) of how these commitments will make a difference in your schools. 4. Provide a short explanation of how computer networking technology can improve education in your schools. 5. Describe how 3Com's donation can help you move forward. List the names and titles of the members of your community who you feel would be key stakeholders in a project in your city 1. Remote/automated reading of electric and water meters (underway), Computer terminals in police patrol cars (underway) Network connection to remote museum facility (proposed) Online iob applications, building permit applications (proposed) online access to Town GIS mapping information (proposed) Online access to utility account and billing information (proposed) 2. Promote citizen awareness of Town responsibilities and services. Improved access to Town products and services. 3. By followina through on these commitments, the Town can provide faster response to requests for information and can furnish information around the clock. 4. Expanding and enhancing our existing network will allow us to provide readv access to information, product, and services at all Town facilities and speed response time to citizens and customers. 5. The 3COM grant will allow us to leverage our existing investment in fiber infrastructure, networking equipment, and computers to create a network with superior capacity and reliability. Stakeholders Betty Kilsdonk, Museum Director Tom Pickering, Director of Business Development Joanne Thompson, Senior Center Director Bob Goehring, Utilities Superintendent Cherie Bartram, Police Communications Supervisor Lowell Richardson, Police Chief Scott Dorman, Fire Chief RL&P6-4 SUPPLEMENTALINFORMATION To strengthen your application, you may submit additional information addressing the following issues: C] DESCRIPTION OF SCHOOL/COMMUNITY: team. Who will be involved in the Describe your school environment and project's implementation? How do you the broader community, including propose to reach out to the larger demographic and socioeconomic community, both within and outside of characteristics of the population to be your organization, to involve them in reached. this initiative? Describe what stakeholders will be involved in the El EXISTING USE OF TECHNOLOGY: Explain project. the extent to which networking technology is currently being used in 0 LOCAL SUPPORT: Describe how your your organization or community to project will be locally supported. Include support public infrastructure or student any commitments of support, as well as learning. any key people in the community who are not officially part of your team but What infrastructure is currently in who will be involved in ensuring project place? success. What technology-related training is currently available? What is your team's vision for how interactive technology, including online services, can most effectively support innovative teaching, learning, and community development? What impediments will make it difficult to implement this vision? U PROJECT DESCRIPTION: Describe the concept for which your team seeks support, including goals and desired outcomes. If the project involves collaboration among schools or other organizations, describe what entities will be involved and how the effort will be organized and managed. 0 IMPLEMENTATION PLAN: Describe the plan for implementing the proposed project, including timelines and specific activities to be conducted by your SUPPLEMENTAL INFORMATION Description of Community: The Town of Estes Park, CO has a population of 5,413 within the corporate limits of six square miles and provides a full range of municipal services. The Town owns an electric utility, which provides service to a 281 square mile area and 9,272 customers. The Town also owns a water utility, which provides service to an 8 square mile area and 4,380 customers. Existing Use of Technology: The Town has a web site www. estesnet.com which is used to provide information about Town departments services, job openings, calendar of events, etc. The Town also has an intranet web site which is used to provide information to employees and share information between departments. The Town is a partner with Platte River Power Authority in a 13-mile fiber optic loop which has been installed surrounding the Town limits. The loop connects several Town-owned facilities (Municipal Building, Light and Power and Public Works Shops, Museum/Senior Center, Fairgrounds, and two electrical substations) with each other and with the Platte River system located in Loveland, Longmont, and Fort Collins, Colorado. The fiber optic system carries network traffic between facilities, Supervisory Control and Data Acquisition (SCADA) traffic between the Town's electrical substations and the Platte River Operations Center, the Town's Municipal Building, the Light and Power shop, and Larimer County Sheriff's Department traffic for the Computer-Aided-Dispatch terminals in the Town's 911 call center. The fiber optic system is used to provide internet service to the Town and Estes Park Public Library. Our vision is to provide online Utility account information to our customers, online GIS mapping information, online building permits, and online job applications. These goals are implemented as time and funding allow, so personnel availability and cost are certainly impediments. Project Description: Replace main 8 port gigabit switch with 24 port switch in Municipal Building. Upgrade various department switches to extend gigabit backbone and increase port availability. Replace copper CAT5 cables connecting buildings with multimode fiber and convert to gigabit connections. Extend network service to Historic Fall River Hydro Museum using wireless bridges. Expand use of wireless access points. Project will be coordinated with Platte River Power Authority to accommodate increased network traffic on our fiber optic loop. Implementation Plan: Project will commence second half of 2003 and extend through the year end 2004. Project will be coordinated by the Town's Light and Power Department with guidance form the Town's Technical Advisory Team RL&P6-5 PROPOSED GRANT REQUESTS If you are already underway on a specific IT communications project in your city and need further support from the 3Com Corporation Urban Challenge Program, please outline your needs below in as much detail as possible. Description Timeline Cost* Network Consultants/ Professional Services Hardware (switches, 1000 BaseT Switches 2003/2004 30,000 hubs, routers, remote 1000BaseSX Switches 2003/2004 40,000 access, etc.) 10/100BaseT Switches 2003/2004 10,000 Wireless Lan Bridges 2003/2004 7,500 Wireless Access Point 2003/2004 12,500 Network Management Software Other TOTAL 100,000 *3Com's Urban Challenge Grants provide for the purchase of 3Com hardware, software, and/or professional services: To learn more about 3Com products and services, visit our World Wide Web site at www.3com.com. 3Com Corporation is publicly traded on Nasdaq under the symbol COMS. Copyright © 2000 3Com Corporation. All rights reserved. 3Com, the 3Com logo, and NBX are registered trademarks of 3Com Corporation. NetPrep is a trademark of 3Com Corporation. All other company and product names may be trademarks of their respective companies. All specifications are subject to change without notice. 3COM CORPORATIO N 5400 Bayfront Plaza P.O. Box 58145 Santa Clara, CA 95052-8145 Phone: 1 800 NET 3Com Or 1 408 326 5000 Fax: 1 408 326 5001 1 RL•P6-6 0 1 B 0 03 C 0 .C E* -1 0 IP-»72: 4 4 LL 4--4 - 2 9 ..4 . a 111 R €.'4. /:4~ : Al 4-r- .' 1 -,/1 4 /' r h (01& r- *NO - CO Lfi h f. bl. cocomco f 6 3 91 0 1,44 *9% %*fz, .2 2. CID 0 0 4, bij q>U,u~(D C b m a 9 <4 O 2 6, a> 2 = 64 - 1- COC 0 0 0 -~ 01 0%- - = 1 0 i) 26(4(5 4¢t# 2 t 32 32 3~ -2-2 ..©C)ce .-4*. 44 1#14 9 Y. ~ ~~Mrahe $/M~h Loveland * L 9E ELSE 289£ *f.EE 00'9 L f90 L 99-ZE EL.LE ZEZE 92*E 699 L 90' L L 69 LE LE ZE 2*ZE 88*E 999L OL'LL ZOZE 9 LZE 99.Ve tg.9 L 20' L L PRPA System Rate Owner Cities Average Rate I-Adi'IM PLATTE RIVER POWER AUTHORITY MEMORANDUM Myly */ t, ..€ ~ · ; . ~' ; « -". ....2 u .2 1.·fi · Date: March 19,2003 £ e eft 1 $ C·d' TO: Board of Directors ft.Ra_ 0 0, r' f L€M S 0-~·1. e-m.2 a F 4. brm<. il· ,«C t.lf From: Robert Abiecunas 0 *604 07;r .:pel« ii!3,·O,1 9 ~&50--04 <4-,£<.0 Subject: Updated Financial Forecast and Wholesale Rate Projection 67 7"« At the August and September 2002 Board meetings, the updated Strategic Financial Plan (SFP) was reviewed and approved and staff was directed to provide the Board an updated financial forecast and wholesale rate projection in early 2003. Since the September Board weetin&?2 new Ave-year rail agreement has been negotiated and signed with Burlington Northerkke Series FF Bonds and GE) available cash were used to refund and cash defease the rema~ing Series CC and Series BB bonds, a revised future outage plan was developed for Rawhide, anthurplus power sales agreements with € pther~entities have been actively negotiated~ii'addit~on.01*AILA,.recentlyjnformed its customers that - ~ (.5.Llf;js.nxlel®.992&2gnifigptr=gnuubnQfalla.and*ill.need-to-ha~tan.additional rate increase in -090:AL futlES· Asa result the forecasti~dulies an estimated <15%_rate increase from WAPA, for SLIP power, effective October 1, 2003. Inaddition to the above chang€!8De management team has reviewed all key assumptions (e.g., load forecast interest rates, surplus sales, capacity factors, operating and maintenance escalation factors, fuel costs, etc.) and incorporated any changes into the current forecast. _~ Based on meeting #le SFf/criteria, the current Base Case projects rate increases in 2004 and 2005 of 3.60%-4£12-0' 8.01% respectivelyllf.a~w SFP criteria had not been adopted in September 2002, rate increases of 1.72% z....„, and 8.35% would still be projected. The following table highlights the projected Base Case rate increases, net income, annual cash flows, total year-end funds (cash), debt outstanding, cash/debt ratio and debt coverage. ipt o f Base Case - Without Xcel Contract Extension (Model Calculated Increases) 20041 ,2005- u 2006 2007 2008 Totarh Rate Increase .>'473.6846,17,1(8.01%'· - -'. O.00%-~ 21 :0.00%09,50.00% l~11.90%) Net Income $ 6,000 $ 6,000 $ 16,867 $ 11,528 $ 13,125 $ 53,520' Annual Cash Flow $ 3,797 $ (19,805) $ 12,291 $ (12,620) $ (4,614) $ R;(20,951) Total Funds $ 224,919 $ 205,115 $ 217,405 $ 204,785 $ 200,171 Debt Outstanding $ 359,005 $ 344,095 $ 325,310 $ 306,585 $ 285,040 Cash/Debt Ratio 63% 60% 67% 67% 70% Debt Coverage 1.62 1.52 1.82 1.63 1.71 The table highlights that although the minimum annual net income and debt coverage targets of $6.0 million and 1.50x are met each year, total cash reserves are projected to be depleted by $20.9 million over the five-year period. Under the Base Case, no further rate increases are projected through 2008. Without the Base Case rate increases, total cash reserves are projected to be depleted by $87.1 million and net losses are forecast in three out of the next five years RL&P7-2 Memorandum ~ Board of Directors March 19, 2003 Page Three cio Other assumptions that could have a signifilant impact on the financial and rate forecast are; our ability to lease surplus traps,4ssion capacity>-replacelpent power cost during outage;ilw load control /+ 31 area expenses>water costdik@w security expenses and'*#heral price escalation. Our goal will be to prudently manage all of these variables as well as possible, but the reality is that some of these variables will be subject to market conditions. /(..D i.~1 ~~&.Ue (. 4, As a result of market volatility in the key forecast assumptions and since an extension of the Xcel contract is not completed at this time, additional rate alternativeahave been developed for the Board's consideration. The following is a brief summary of each alternative, followed by a financial table that highlights the projected wholesale rate increase, net income, annual cash flow, total funds available, debt outstanding, cash/debt ratio and debt coverage. • Alternative 1 -- As in the Base Case, this alternative assumes the Xcelcontract is not extendAL However, this alternative assumes that in lieu of implementing a larger rate increase in 2005 (as in the Base Case), smaller rate increases of 5.40% are implemented in 2004 and 2005. Under this alternative, net income would exceed our minimum target of $6.0 million in 2004, but is forecasted to be approximately $760,000 under the target in 2005. The minimum debt coverage target would be achieved in ali years and cash flows .under this case would provide a reasonable alternative to the Base Case. Alternative 1- Without Xcel Contract Extension (Split Increase) 2004-1 2005 2006 2007 2008 yotal>~ Rate Increase ¢5.40%9:r. r 75.40%tO o.00%0:I t.*... "too% O.00% C 11.09% ) Net Income $ ~7790* $ ~5,240' $ 15,980 $ 10,556 $ 12,064 $ ~54,448-~ Annual Cash Flow $ 5,706 $ (20,565) $ 11,403 $ (13,592) $ (5,674) $ (22,722) Total Funds $ 226,828 $ 206,263 $ 217,666 $ 204,074 $ 198,399 Debt Outstanding $ 359,005 $ 344,095 $ 325,310 $ 306,585 $ 285,040 Cash/Debt Ratio 63% 60% 67% 67% 70% Debt Coverage 1.68 1.50 1.80 1.60 1.68 • Alternative Base Case A -- All assumptions are the same for this Alternative Base Case A as in the Base Case, except that this case fis@umes the Xcel contract is extended. Under this case, the financial model calculates that a rate increase of 1.85% in 2004 and 7.71% in 2005 would be required to meet all SIT financial criteria. Alternative Base Case A - With Xcel Contract Extension (Mode] Calculated Increases) 2994-1 2904 2006 2007 2008 Totath Rate Increase f ;1.839 t. ¢1 7.71~6 .... 0.00%· f. 0.00% '4·,-- 0,00% l 9.709§) Net Income $ 46'C-- . -UL) $ 16,140 $ 10,342 $ 10,707 $ 49,184 Annual Cash Flow $ 3,798 $ (19,805) $ 11,562 $ (13,806) $ (7,032) $ (25,283) Total Funds $ 224,919 $ 205,115 $ 216,678 $ 202,872 $ 195,840 Debt Outstanding $ 359,005 $ 344,095 $ 325,310 $ 306,585 $ 285,040 Cash/Debt Ratio 63% 60% 67% 66% 69% Debt Coverage 1.62 1.52 1.80 1.60 1.64 RL&P7-3 118'lill"/Al'IMI g :0 29= NO mr-,0.=h 00 Idle 844,4 9 2 =42 = 1 10 $ rl %01 01 -4-1 rn= ges: 499 *2.% 2 ~-22 as EMN 9 6 d MU* - ---*S'n * m - * %8- . - . 4.- -2 0 0 5 al Ki E 6 4 4 9 533 - - 422*42 22 R ¤2A*A 5%-g; S .6,¢ S=-4 . M 2 M . t.9 jO ' 0 - LO h -1 R A. 5 9 - F to 0 E te¥ Emm@E, fRi R rs =SE{glig - -- .9 e, 3 w, ¥-1 A - 61 'D ., 0 . ma . & §#ER-% A..4 in N -2 0 CO 0 55 2/5 *55 Am: 20 - .6 55 9 ' 4 m -Nrn IN 22.-0* . m .. co 22 N rn 5§80 0&29- RE - m u- r In 00 - t.r' 0 glep ZQI r!' O - 42 01 3 2$2044 53R Res -- 2=== 9 = ,d Re.R 0, rh u-) N -ror•,~U;M ...4 {Nrn R C. . 4* M t ,n - 4. 80: 3;921810= =W= Ngk mz M.@* m*§ 002000@ J m N N N N - UN-Ato M + - A 00 0 -7 r-4 - U' U. R 222225 223 di,i A In N N N h IN O, W 1* 10 -Nrn *m -T . g .0 ul h Op. N h 5:02 MED RE 9. 08 S.q RN. R- 01 0 Ln o C. M 0 - O r N L.n - U, 0 61 1/1 - O, - O% 5553%6 2-5 dig -- m R .-1 *7,7.-m¥ = 0; - M E -r Z? . --&2*M Tkw $%# 49 :g g R ~@ 0 $*Sts: h m 35~1Rt 5&2 283 N /1 i.#4 CO - 2 0 N rn S 59 '0 ~~2-2~ 2£ WM . . . . . 4.» 40 ,/0 - I 0 aqi,50 Rii em; 39 0. EN 24-sm 9,22== - m m 3. X N; N N %*IN 525*im- 2 m 51.* 5 - . ...th///4* M & 5322 02EE C, 5% E iw26 198 51'/El, ~8= 82 U &9 ~ 0-0 LE 225 23 28 Q' WE *81 851 ~%5 ~NE BEE * 2 Ii, 5 6 ~ f 5 2 v 8 g!$~ CDM,n 2 m 2 9 3 O r .W M E 8 2 2 ) 3/3 3 1 /28 a 2 2 .5,216 -O k O .0 &3&& - 00 66% 10 52 15/i 1 '3 3 3 M:R= w- - IeiNg 1£218 E NES E ME @ 5* SM E 31*EN 31=42808 2183'01 #2% 22&< 024 2*2** 96 0- LU LU LLI 20021 Revis~03 ~ ~ 2004 2005 2007 2008 ~ (DI9't,) I6Z'ZI MA'E EZE'E 09/0, l £5/Lk 15/54 Li~fis 64/IS 64/55 oneM 4nbil 01 1 Sales to Municipali $97,934 $102,3 $109 $123,673 $128 $133,256 $138,04 £95 /0£9 DS / L.9 6Zg / DZ9 009 891, / 955 LIk / 86+ Sales for Resale & 21,583 P, ul...6:J Total Revenues $ 131,524 $ 138,956 $ 138,383 $ 145,754 $ 150,409 $ 154,839 $ 157,037 $2,634 50)'LIZ Ouipums912(~1~ $32,076 Base Case - Without Xcel Contract Extension (000's) e a ions and M 36,650 L~9'LI D-Ld¥'IN E'ISE Electric Operating Revenues 'rE 8Sve Jed @meA *pew 41; 14 525Uap epnpU! saoueteq ievols.!H (0 elea Electric Op ating Expenses g §5 mls.& re, 0 mr•-12Zg9 Dne 8%,1 gE 68 1 ci 'fs m Eg :gmervi 4--tRI rol. ~0. 0, 4- ' ID rn I I AER 55554* 3@41 82* . ~22~%2 h m 2.34 2= $ g RE,E Ln Lin 0- an f g ID 0 gge&:21 5.§2 -- 9 & - m. g€%*:A 0 - ~ *9 * ER**23 fia 52% E e In J - e . t. ..· .. -1 - 28 89*C In $ k g O Ln O .4 N 12;52 &@ 10 Nt ' 00 ARE** 42* . ... 4'M 02 Mae-' -M 0.'N O Z /0 2.-Mih U W . O~MIAN 8% 9 Z:R ~8 8 m gg 9*22=12 .04. ~ g .4 S K. 10 -1 ' 0, -M gig h 0 1 CL 52&211 255 ime. -- ; 0 Ri - rn 4,Nrn in 8 6! R' -rorr,~-M -- 2.N' W 0. . 5§93 8 4. R E- W 0 10 . 14 N ..90 E E - rn III - ./ 5 Wi O, h rn ** 6**diA, Sa . C. . 0.. 4. - er e. * . 16- 0 .0 0=00= ING & WAIgn M 5 92 52& 33 5&/§ m N N h c'N-Mt 00 0, ' 4 U N A- CE d 4 rri N 00 :21 :AN 22332? dia 9/2 MN m . 0.44 --8 §@m*§% •ew === 020 mi S = 55 -- A-~- ~-0;--M N 0 93=229 9-2 223 Ln N . mosce j 0 22&2%2 Emm 33 8 ER t G .0 td W d % 00 U, /4 22&122 3#2 23~ $ CO - h . M *- 4-*- sle gl@:RE. AR'519:,2 Ang MA E :I M .RN . 81 0, In f- 00- f r.1 'E ts . 40 8 3%5 Q532*j& 22*2 00% ~ -- M XI tr' g WA A rn m .7.2.-cou, .. 0 g -eli w 0 .- 5 m z .CE 3 · X UNNE I 03 Mlg 22 ell £ * 22~~ 33- /0 1 528 6 2 i 1 1 - iE -5 1 ** 1 -2 23 *-ES gogg gaa 2 E Ji 0 2 il airil#li 1; 2 8 1% -2 -2 56 9 1 1 -~ g * 15 5 W 0 1052= 6 92:99 28055<G %53 - 19 -#E lii al~i·/ ~Ai ~Hili j 3 36# 2 25 2 3 3 3 8 5 3 3 S tif mr E g # f# 3 5 1 9 5 1% E Bm e ... O. O- U.1 11.1 U.1 thz<'-000 | 20 2001 2003 2004 2005 2006 2008 ZE'9Z £95 / 0£9 OEL / EES (JaquiM/JaullunS) ledpiunw-Pu 1,61'E 09/04 EG/LD 05/05 $89, $97,934 $10 $111,882 $127 $1 2 296 $1 ,0 $ 151,314 $ 131,524 $ 138,956 $ 144,863 $ 149,483 $ 153,879 $ 1 ZZ'6€ ZZ'6£ 2'69 - I€'5£ ased Powe $17,046 Alternative 1 - Without Xcel Contract Extension (000's) . Revised 1 1 P, uject.d 8Z8'9ZZ $ 53 199 $ 5 9-Ldqyll Zoo'D 994 $ ic Operating Revenues 7£ 058 Jid anieA 13*letti Jle, U! 5@6Uelp @pnpl# Sateleq le,#0*!H (1) 60!Puewln eneral and 5**& m:RAO, R **3 8 hawk ZE /50.25.5 532 532 ma glz~ - fri r© u€ tr¢ ._2 22292. 4 M g - agn N .. . 4. - 0 4,9- --O/.* m-N m..A RE R f M R Ry,G 2 R E ?8 25 - 2/22*5 222 222 rn - t.0 co 00 Un - -- ;8§RK] - -0-1 A ~ ~frg .. . . + 0- .- te .- r.,24-0 68%1 °@8 >2:GE Wg Mi2 2063/- h a 'h r! 3 ~i 22=~ ~jviut =-=--D- R:§ A & 0 64 $41<r -- --dN- 6 2 -6, 10 - S Mir, 7 , ·t ----- m E O Ch BAR; 8 2 6-Syl 0 2 un M ™ >R 00 -&-7 6,9--N + E *%*20 35/ RAE 39 *'2 * 121 - r,4 ~d- 5 034 930 255=gd .. ..4 - 52~- --AM In § - . . - 0- -* h . u-} 4- 14 N gRz Aq g t. 1 g 3 R 5§%2 § -2 §0 WA Res# 082 .-,0 -- 87 -7 . L C- 1 4 *1 3 :i gi N m 4- 0 f Bi Z 22 5XX,$A #am 6 NA 2 --- 0 . U m . 00=000 - as SC'.8 Cqq Re §0 0 iRRMEN 411 23= :836 2'RM ~Su0 .813 FA 335=,d =~' 225 -- - 10 W. M ..... 4% 3*953. 9- A Wn N - 525 055 55 e.„R R--8 §0%85% Ur, 0, u-' - N rn 19 - r¢ S .- ch ,n Ln m * 0** MY 0 14 - M 4# 4- 0 4* 0 CDON©p Ii; m & %83 E 'S:* *613:5*9 les;m g:** 2%9 12 02 .stets 2 5 Z- 3 2 M 2222 22 2 -2 g-SS A N g . :4 * -A M - =:-4-,4 rr.69 :8 W 5 ANIONO m 1-1 w O/. 80 1 RE &3a Olen GRE mgoagm RER 55R. -- .*§ C- S [k 35: rri ... W g>RN w 555*sid a <2 - * 0 # 4* 4* -* i M E E 2 8.1 2 & m 5*E& 5 ~ 49 = 2 2 - D 3 2 45 41 0 - m m ~- 2- % 26 82& PXHi Eg -% 41 fi & 21 & 2 il Sm IZES 25! 81/ 31% .260 2 6 -8~RF Icmz 16 2 8,0 b 25 i ati Wi 99 18 CSO - ..1- 2 5 2 2 1 138* 2/ 1 8 5 E- 2 2, 60 m li € i~ 11 6 NI 11 11 1 # m & 3 && i o h * 2 2 3 8 2 NE 32 E 95 1 411 8 2&3M 2:e Mee 34,6#DS; - ¥ c 8% 4 /2-3; 92 9.0* 3 ;5 W O§92 932 .emve 92££& m2260~z Eaz 0 a. u) ma-k- acax<< 66 01/22080 65/ID Ls/E £5/LD IS* 05/05 $89,426 $93,06 $121,242 $125,939 $130,636 $135,333 LOCOT DE'01 I¢52 2000 2001 2004 2005 2006 2007 DS / 09 6ZS / t,Z9 6# 6ED / 999 Alternative Base Case A - With Xcel Contract Extension (000's) $17,046 $36,850 $ 138,077 $ 15 ,31 $ 131,524 $ 138, $ 138,645 $ 14 37 $ 150 $ 2002 | ®03 I 9-Ldl'nI Historical 95'KE c Operating Revenues 'TE gsVE> Ed enje, *>pew al u., sa,ap apr,put sax,eleq jeouois?H (I) enues Other Data r 1 ir b \ I i! 4 C..' f . $ E 42 / 1.2 L. 04I· 1>' Ab \ -..a. ... t 5.1 4 r /i 3 1 3 4 1/ o i -Y 'If 'I ·-Il 1 4 041,1 2 1 44 . 6 & 4';'~ r ' l·~ r' t, !Ig 3-I:, 4. % '4 £4% c 1 1 9, 0% \\1 K 4 Nal #··.* '-1 ' ·u i.. 4 3. Re ., ·i·: I.% 4( ·_ . ' U 1 E . '9 ., . 7 -; ·T·. 4 3 .JOI 4 · 6 4 , ~~ ; 74 ", 8 · -. i .7 1 H .A 5 1 4 , r e a J 1-"m .·-.. .:- *t:-f~ .-./ 4 1 3 £ 71 P 1 4 . 30 /0 ~i 8:82 m 'r' oer, O 3;;02 g&. 0 < ~ *M--;r It G ~3 4 £ 4 1 95 01 4 E-& E ID m ~*2*wN 11,4 \ l: S % r.1 a o rl f ,0 M *;Sm SM:*55 222 222 - -7 r-UP P. A h . r., f ,O j rN .. .L --k h EM m R & G vu i .Dice ERS R %- mi 9i il Fi 11 Zi Hi 3 11 2 - ,0 J 1 22 ~cR- •-~ / 4 \ iX h M.iin''R d R Or. m R & 04 3 2 3 3 0 : u -m = - "*.3.t .-1 t. th- ·A + 4* 4 0. ta. i< . \ / 1 041 - 4- 1-0 00 - Ch 2 4 r.% 0 - E & N A / 1 _ .1~ # ~ ~ N tr, Ch -4 1 .~ 14~ ¢9 9 ;; ~ M 'D O 1,0 0 l.0 4- 0 01.1/ 1-rn= Ct- '·. -rkj~p ENE- 2 4% 01.-, e ST·Ul NN_2- / I ,+ 1 p S #N / . 9 UnES€Ci 2- g 2 - A / 4 VA 1 8 1 .**4** 4 -3 j w ol. 31'0:jee .01™ u.1 r., 9 ' N * m O & V .. 4> 1 0.6& : L r Z i o r. a V. r" S 0 0, 0 45 In >R $ 9 $ 5512 m : R C: 0 , ; A M \ 9,9}ga·,0 ·1€.1 9 m m 91.2 \31 1 8 5 5 % S C - \C/ 9, '•· CJm -11. rn - 4 1---- 02 55-5&04 222 -· c-w ------------------- g 111 40.03.t. - . .. + v.' +5 5 42 %# 9% 4 1* .6 5 RE=:Sy. lie EWERIB 5 *ma@& 28 2; 1.46 35 ai,3%*AM Z. B m co 5 1 79 1 ,|2 # 0 5 r N v . 3 J 0-R € 4111> € :,: 3-1$ 2 47, * u Zi -~1 N Cro L- 3. 03 00.j/1 - .- i m '1 0 -m4n -- 0' 1 e.. i / 1 I .. th - *222:80 9 Negismu SE; ;egm @m 2 m &58 01 r- int lit -4.72,1 t S --S 325 - 1- 00 -MN 0 21*N Len,9 ,(,0 - m rn m - 0. . 0 CA -=0 §0 $*.43 *lia &*3@ma ZON * 08 RK , m 6 4 6- f i g m -In- 0114. 6* am 01 19 -- N 7 0. 4. CON©O raig=ZE 1,n 2 5 N N",0- A-/01.111 0Nln . 09 -1 xr E *91 *22222 9/2 ima Mr= : A 2 -7 er a or •n 0, m N 0, Lr- to --19 .. L. or* 91™ :2 0 82aA S le m ==2 Lr, go A O In - RO"*30 114 &25 35 , anc•Ln 14 - 8 :9 R A N N A F O,nowd; 5 6 -- . r. *. i i U. 0 E = *RE *i - tz 10 14 3 m f 21911 .E - 122& i al 9 0 ES 8 :Pf e, m it 11 ji E &~ Ul /2.2- + Wd= e 55: .@%5 C.1 92 2,bve 12 0 *50 1 NE# %5§ 2%,e E*8 2 2-2 2 e :*SE V 2 2 ~ 2 i 5 & 5 4 0 2 g %@S =*ru . Z m £ . =22 : 123 2 1 2 6 6 6 0 (A - 2200 Z - - L9S / OLS 945 / L.9 25 894 1 855 0Et, / EEG *6#'E OCT'£ eg,6 2000 2002 2003 2004 2007 $ 33,285 $ 35,347 $ %00 8£ GZ 985'ZOZ $89,426 $102,30 $120,233 $124,891 24,642 $ 138,077 $ 151, $ 131,524 $ 138,956 $ $ 149,533 $ 5 Alternative lA - With Xcel Contract Historical I Revised | I SI'SE RL&P7-7 86'SE ELDE Electric Operating Revenues T E GSVE) ;ad DINBA *pew 114 ul s@6uap @pnpU! Siateleq lewaiS#H (T) ons and Maintenance ce Coverage ased Power Bulooll suoillppv le;!deD Reti A:linba oi lqao Annual Cash Flow Ouipu(I) 3%722 =t Net Rev /121 1 .... 142*44* Updated Financial Forecast and Wholesale Rate Projection i ...SLWIG+f,~0*"0 uwk#,9,1.·*Kv· **MAL'Me.*AN·M Board of Directors March 27,2003 I, l - i I,'%'*t~hdRI¥~ Presentation Outline • Recent Activities • Current Situation • Rate Options • Schedule • Questions and Discussion -A 1 RL&P7-8 'P- ./.~• Recent Activities e August 2002 SFP reviewed with Board • September 2002 Board approved new SFP • October 2002 Load forecast updated • October 2002 Rail agreement signed • December 2002 FY 2003 Budget approved • January 2003 Series FF Bonds priced • Feb-Mar 2003 Financial forecast updated • March 2003 WAPA rate information • March 2003 Surplus sales negotiations t' 21,.a-j:JZ 7 - 4i~kENTAJAWap.¤*w,ma.I,.BN.im-m.*.-.-*-~ Average Rate to Cities 1983 - 2003 - WMwh 40 2.3% Below 1983 1 ~-1,1-1-1-1-1-1-1--~ 1~-1-1--1-1-1-1- 1- ~-1-1 EE*E.&EE§§2 p- N N N 2 RL&P7-9 1983 1984 1989 1991 - Cooz ~1 -TI~ 9 +11 Z :I' lit21?Drm' del'LAMS ..4 •,2 -1 9 11 r -4 Historical Summer Peak MW Annual Peak Demand 580 - 540 - 1983 -2003 / 148% Load Growth 500 - (333 MW) 460 - 4.0 r 340 300-~ 260 - 220 *-.v - - 180 J I , i I I , I I . I . i i . . I I I 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 | Foricast I 44* *:+ 7'fil+-emE*71323*27<99442ff- ic,- I »4U Lift*fR)4:fl~:364jf.34,3~7<-·2is'f''ii's·+4.jit,9€j~~ i.6 7- : . p'i- _--gj*-2,/04*074)-93.25'-ED*'1:.z·:·.'·4»3..#.r~949'frp*¥.2~4.-i':*UTS 1 Total Capital Additions $ Millions $396.8M Capital Additions from 1983 to 2003 90 80 1- $219.8M - 70 60 \\\ =~m ==. m,=,=immalml n m.~ E el 19 . . 10 F- m o g gg&2*m~gmmg m~:m & RL&P7-10 3 1984 00oz 100Z 200< Cooz 1 „ :,1,'-' :57,4*„4.4.p·:~F*3'13%4i~'F:**1:* Revenues Vs. Expenditures $ Millions :500 J Historical ) 4- Projected - 1 BO Ah /Mia >£1. 170 1C0., 140· , 120 ·T: 100 - r. ,. ~ . ·- V. , - 1 1 -7- .. ...D- . - -1- i . 1' ..i--biA #p. <&'44#76/ *('1*... , 3&-.-·~~' - 60 50 ====== 0 90 22:220 2.22 IC>perating Expenses CODebt Service Itgn Capital Additions - Revenues- No Rate Increase Net Income - 1 . $ Millions 50· C Historical > f- Projected -* 40 30- 20 10 >4. 0 1.•·lilli,• 1 -10 INNEiNE#EEMENE".EME -0» Base with no rate increase 4 RL&P7-11 1990 1991 1992- -6661. -&002 · I ¥00, 1 -500: f §00 900/ - LOOZ 800Z * ···r.e ·. ' '24 'r,3,4.f'*,EN·tf-'tPc- Debt Service Coverage $ Millions 3.0 · 70 2002 Debt Service Coverage = Revenues - Expenses = 1.71 Debt Service / -60 - SO ----- - 40 - 30 - 20 - 10 0 1 0% 0 0 0 1 0 0 E.i m %0 :E 1% 1 0 Dibt Service -*-Ba- with no rate increase Rate Increase Options ~ r LE Without Xcel Contract Extension Base Case - Alternative 1 With Xcel Contract Extension Alternative Base Case A Alternative lA 5 RL&P7-12 Financial Forecast Risks • Surplus sales (price and quantity) • Load forecast • Interest rates • Rawhide and Craig capacity factors • WAPA purchased power rates • Natural gas prices • Unrealized investment holding losses Without Xcel Contract Extension 4 .pt~p 3.·< \:3:.·3'it,;ir'~i~i'.·~.4Ytif~%32&#~ ~~ Base Case (Model Calculated Increases) 2004 2005 2006 2007 2008 Total Rate Increase 3.60% 8.01% 0.00% 0.00% 0.00% 11.90% Net Income $ 6,000 $ 6,000 $ 16,867 $ 11,528 $ 13,125 $ 53,520 Annual Cash Flow $ 3,797 $ (19,805) $ 12,291 $ (12,620) $ el,614) $ (20,951) Total Funds $ 224,919 $ 205,115 $ 217,405 $ 204,785 $ 200,171 Debt Outstanding $ 359,005 $ 344,095 $ 325,310 $ 306,585 $ 285,040 Cash/Debt Ratio 63% 60% 67% 67% 70% Debt Coverage 1.62 1.52 1.82 1.63 1.71 1 6 RL&P7-13 Without Xcel Contract Extension Alternative 1 (Split Increase) 2004 2005 2006 2007 2008 Total Rate Increase 5.40% 5.4096 0.00% 0.00% 0.00% 11.09% Net Income $ 7,909 $ 5,240 $ 15,980 $ 10,556 $ 12,064 $ 51,748 Annual Cash Flow $ 5,706 $ (20,565) $ 11,403 $ (13,592) $ (5,674) $ (22,722) Total Funds $ 226,828 $ 206,263 $ 217,666 $ 204,074 $ 198,399 Debt Outstanding $ 359,005 $ 344,095 $ 325,310 $ 306,585 $ 285,040 Cash/Debt Ratio 63% 60% 67% 67% 70% Debt Coverage 1.68 1.50 1.80 1.60 1.68 A - With Xcel Contract Extension , -4 7 .4...1 4., :4:-- .7......iA£~??T.-·'~b.*5*9%71if··, Alternative Base Case A (Model Calculated Increases) 2004 2005 2006 2007 2008 Total Rate Incnease 1.85% 7.71% 0.00% 0.00% 0.00% 9.70% Net Income $ 6,000 $ 6,000 $ 16,140 $ 10,342 $ 10,707 $ 49,189 Annual Cash Flow $ 3,798 $ (19,805) $ 11,562 $ (13,806) $ (7,032) $ (25,283) Total Funds $ 224,919 $ 205,115 $ 216,678 $ 202,872 $ 195,840 Debt Outstanding $ 359,005 $ 344,095 $ 325,310 $ 306,585 $ 285,040 Cash/Debt Ratio 63% 60% 67% 66% 69% Debt Coverage 1.62 1.52 1.80 1.60 1.64 7 RL&P7-14 g- t...4 -w-,- -8-~Re<P /4,1.71 'f.*AJ FF}---nA (FIC. \A 27.:ir Mfy.'i. 9,1.*„sm,--- With Xcel Contract Extension 1.:6#ilt-04471836" P, I Alternative lA (Split Increase) 7 /1., 2*TWag 2004 2005 2006 2007 2008 Total A,<ri€dir#JE 7 Rate Increase 4.30% 4.30% 0.00% 0.00% 0.00% 8.78% 1 A R 1¥i'€~ Net Income $ 8,602 $ 5,169 $ 15,159 $ 9,266 $ 9,533 $ 47,729 i 9-1 6 Q.€69: Annual Cash Flow $ 6,400 $ (20,636) $ 10,581 $ (14,882) $ (8,205) $ (26,742) Total Funds $ 227,521 $ 206,886 $ 217,467 $ 202,586 $ 194,379 Debt Outstanding $ 359,005 $ 344,095 $ 325,310 $ 306,585 $ 285,040 Cash/Debt Ratio 63% 60% 67% 66% 68% Debt Coverage 1.70 1.50 1.77 1.57 1.61 1 1 -9 213.9*9~ 2 4;-*184#////////////////////////////t Rate Alternative Summary di,limill:/ill,lilmill":~2/1/8/1//1/irie'~pl~~t'ilil/~1 (Projected Rate Increases) 2004 2005 2006 2007 2008 Total Without Xcel Extension Base 3.60% 8.01% - - - 11.90% Alternative 1 5.40% 5.40% - - - 11.09% With Xcel Extension Alternative Base A 1.85% 7.71% - - - 9.70% Alternative lA 4.30% 4.30% --- 8.78% WAPA Sales 2004-2005 3.90% 3.90% --- 7.95% A 8 RL&P7-15 *N (1) Formula for determining the purchased power rider: Purchased Power Rider = (New PRPA rate cost - Current PRPA cost) kWh sales Current PRPA cost = The most recent twelve months' cost of power purchased from PRPA by the Town, estimated using the rates effective January 1, 2002. kWh sales = The electric kWh sales to the Town's customers for the same twelve-month period as the current PRPA cost. New PRPA cost = The calculated cost of power, assuming the power purchased for the same twelve-month period as used for the current PRPA costs and the proposed PRPA rates. (2) The purchased power rider shall be calculated to the nearest one-hundredth of a mill ($0.00001) per kWh. (3) The electric rate schedules with demand rates may have the purchased power rider spread between the energy and the-demand rates. The demand portion shall be set as $/kW. (Ord. 21-91 §1(part), 1991; Ord. 19-93 §1(part), 1993) Outdoor area lighting (a) Applicability. The rates set forth in this Section shall be applicable in Estes Park service territory. (b) Availability. This schedule is available to any customer for the lighting of private outdoor areas, where such service can be provided directly from existing ~ secondary distribution lines of the Light & Power Department. (c) Monthly rate. 20¤3 2QQ& Per lighting fixture $6.32 $7.61 (d) Payment. The above rate is net. Bills for electric service are due and payable within ten (10) days subsequent to mailing or delivery of the bill. (e) Purchased power rider. This schedule is subject to the conditions set forth on the purchased power rider. RT.aP7-16 25 . WATER FUND 2002 VS. 2003 MONTH CASH FLOW COMPARISON APRIL APRIL 2002 2003 Difference Revenues Water Sales $ 117,257 $ 99,238 $ (18,019) Plant Development Tap Fees 14,360 28,358 $ 13,998 Water Rights Tap Fees 19,680 36,580 $ 16,900 Other 6,677 6,197 $ (480) Total Revenues $ 157,974 $ 170,373 $ 12,399 Expenditures Operation and Maintenance Expense Source of Supply 0 0 0 Purification 32,835 27,836 $ (4,999) Distribution and Maintenance 34,628 60,943 $ 26,315 Customer Billing and Accounts 6,183 17,101 $ 10,918 Administration and General 27,320 51,553 $ 24,233 Transfer to Vehicle Fund 417 792 (41D Total Operation and Maintenance Expense $ 101,383 $ 158,225 $ 56,050 Debt Service 25,564 25,348 (216) Capital 48,402 0 (48,402) Total Expenditures $ 175,349 $ 183,573 $ 7,432 Annual Surplus (Deficiency) $ (17,375) $ (13,200) $ 4,967 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. Note 2) 2003 Distribution: $27,000 meters charged to account. Historically charged to capital. Note 3) 2003 Administration: $23,000 Franchise fee difference compared to 2002. WATER FUND 2002 VS. 2003 YTD CASH FLOW COMPARISON YTD YTD April April 2002 2003 Difference Revenues Water Sales $ 549,612 $ 509,938 $ (39,674) Plant Development Tap Fees 56,300 118,241 61,941 Water Rights Tap Fees 66,332 135,805 69,473 Other 28,620 57,458 28,838 Total Revenues $ 700,864 $ 821,442 $ 120,578 Expenditures Operation and Maintenance Expense Source of Supply 75,958 75,619 (339) Purification 87,944 125,104 37,160 Distribution and Maintenance 124,306 166,310 42,004 Customer Billing and Accounts 30,993 39,819 8,826 Administration and General 153,319 224,995 71,676 Transfer to Vehicle Fund 1,667 3,167 1,500 Total Operation and Maintenance Expense 474,187 635,014 , 160,827 Debt Service 102,257 101,392 (865) Capital 312,068 259,261 (52,807) Total Expenditures $ 888,512 $ 995,667 $ 107,155 Annual Surplus (Deficiency) $ (187,648) $ (174,225) $ 13,423 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. Note 2) 2003 0+M: Housing $31,000; engineering $28,000; April Franchise fee $23,000; Meters $26,000 WATER FUND 2003 TOTAL BUDGET VS. ACTUAL YTD CASH FLOW ANALYSIS YTD Budget April YTD % of Target 2003 2003 Budget % Revenues Water Sales $ 2,183,040 $ 509,938 23% 2596 Plant Development Tap Fees 175,000 118,241 68% 2596 Water Rights Tap Fees 330,000 135,805 41% 2596 Other 100,013 57,458 57% 25% Total Revenues 2,788,053 821,442 29% 25% Expenditures Operation and Maintenance Expense Source of Supply $ 125,000 $ 75,619 60% 70% Purification 398,351 125,104 31% 33% Distribution and Maintenance 561,408 166,310 30% 3396 Customer Billing and Accounts 248,686 39,819 16% 33% Administration and General 782,075 224,995 29% 33% Transfer to Vehicle Fund 9,500 3,167 33% 33% Total Operation and Maintenance Expense $ 2,125,020 $ 635,014 3096 33% Debt Service 304,176 101,392 33% 3396 Capital 1,269,135 259,261 20% 33% Total Expenditures $ 3,698,331 $ 995,667 27% 33% Note 1) Charge for Services target based on previous years data. Note 2) Source of Supply target based on previous years NCWCD invoices. Note 3) All other targets based on % of Year complete. 2003 WATER USE PROJECTIONS Actual (rt) Actual (rt) Actual(rt) and and Depletion Est. (left) Est. (left) Est. (left) factor Depleted USA WG CBT Marys Glacier Glacier Glacier (AF) (AF) (AF) (AF) (AF) (AF) 2002 Nov 2 95 0.06 i g i Q Dec 27 12 0·06 1 87 1 2 2003 Jan 97 9 0.06 9 97 2 2 Feb 87 9 0.06 2 87 2 9 March 62 22 0.06 2 62 2Q April Q M 0.07 6260 I - May 0 159 0.12 19 0 19 0 June 79 146 0.17 25 79 25 0 July 42 229 0.13 30 42 30 0 Aug 7 222 0.11 24 7 24 0 Sept 0 175 0.1 18 0 18 0 - Oct 0 121 0.08 10 0 10 0 TOTAL 461 1273 139 461 141 0 2003 WATER RIGHTS 2003 2003 2003 2003 projected projected leased projected Water acre-feet acre-feet water acre-feet Rights available used (minus) unused USA 500 500 461 39 WG 300 200 (Note 1) 141 59 CBT Units 1207 348 (Note 2) 0 141 207 (Note 4) CBT carryover 110 0 0 (Note 3) TOTAL 1158 602 305 Note 1 ordered 200 AF of 300 owned Note 2 40% quota minus W.G. Collateral water(1207*.4)-(200-66 carryover prepay water) = 348 Note 3 Carryover water not available after April. Must use USA water first. Note 4 School Lease 135 AF Prospect Mtn Water 4 AF Glacier View Subd 1 AF B of R 1 aAF 141 AF R W2