Loading...
HomeMy WebLinkAboutPACKET Utilities Committee 2005-03-10, TOWN of ESTES PARK Inter-Office Memorandum March 4,2004 TO: Utilities Committee Ok./ FROM: Bill Linnane SUBJECT: Request to Vacate Utility Easement Stephen R. Carl, property owner Lot 3A, Amended Plat of Lots 2&3 of the Dill Subdivision (commonly known as 2205 Arapaho Road) Background: Please refer to the attachments. Stephen R. Carl, owner of Lot 3A, Amended Plat of Lots 2&3 of the Dill Subdivision (commonly known as 2205 Arapaho Road), is requesting vacation of a utility easement The utilities were placed in another location and the original platted easement is no longer required by the utilities listed on the attached sign-off sheet. Cost/Budget N/A Action: Staff recommends approval. BL/lb Attachments 1-1 4 vick/ 6 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8 a.m. Thursday, March 10, 2005 Preparation date: 3/4/05 *Revision date: 3/7/05 ACTION ITEMS Light & Power Department 1. Request to Vacate Easement • Stephen R. Carl, property owner Lot 3A, Amended Plat of Lots 2&3 ofthe Dill Subdivision (commonly known as 2205 Arapaho Road) Water Department: No action items. REPORTS Light and Power 1. Light & Power Department financial data 2. Misc. Water 1. Water Department financial data 2. Misc. Note: The Utilities Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared. Town of Estes Park Community Development Memo TO: Members of the Utilities Committee From: Dave Shirk, Planner 11 Date: 3/9/2005 Re: Easement Vacation This is a request by Linda McCreery on N 1, n 1/1 .cer, , I. behalf of Stephen Carl to vacate a ,§2 --- platted utility easement that crosses 3%~ *27 h :Pl€=7 -__~--ff<ALL E B r.,cv I / through Lot 3A of the Dill Subdivision. & .L 'i The applicant has chosen to utilize the ri i B: 1 1 .f fy.f\\- --- .Ch '' 1 Easement Vacation process rather 1 ' t 1 'j ,/ - ..'C.... I: $ than formally amending the plat. r.r + \37.....Vacate / The applicant has submitted signatures *4 0 1 41>Retain 5\ .... ' ' 'I, / from all relevant utility providers § LL-- SAT,$. MA I r:\ 1/ i K. agreeing to vacate this easement, ,@0 ~ t!-i----=330-me -- LOT 34 ~fl , e which is not in use. There are ~ ILI... <-Lit, 1.1 1,~D ity·, perimeter utility easements ranging & 41-//n, . ...... from 10 to 20 feet in width; these are to - 4*** Hwy 7 --4.3 , ==-- 1 remain in place. The property owner wishes to vacate the easement to allow greater flexibility in the placement of their house. Based on the foregoing, Staff finds: 1. All utility providers have agreed in writing to vacate the easement. 2. Adequate easements will be retained. Therefore, Staff recommends this request be granted CONDITIONAL TO retention of all perimeter utility easements. 1 6 Electric Financials.xls 1/12/2005 LIGHT AND POWER FUND 2003 VS. 2004 MONTH-TO-DATE CASH FLOW COMPARISON DECEMBER DECEMBER Per kWh Per kWh 2003 2004 Difference 2003 2004 Revenues Utility Sales $ 694,267 $ 775,435 $ 81,168 0.067687 0.073174 Other 110,993 5,849 (105,143) Total Revenues $ 805,260 $ 781,285 $ (23,975) 0.078508 0.073726 Expenditures Operation and Maintenance Expense Source of Supply $ 410,003 $ 469,319 $ 59,316 0.039973 0.044287 Distribution and Maintenance 147,710 79,947 (67,763) 0.014401 0.007544 Customer Billing and Accounts 44,413 42,384 (2,029) 0.004330 0.004000 Administration and General 118,676 45,805 (72,871) ~_0.011570 0.004322 Transfer to Vehicle Fund 2,617 4,240 1,624 F11 & 41- , +Te-- 4- Total Operation and Maintenance Expense $ 723,419 $ 641,696 $ (81,723) 0.070529 0.060554 Debt Service 24,917 25,170 254 ~~ Capital 57,915 39,291 (18,624) 1 ./ >i' Transfers to General Fund and Museum 59,573 72,322 12,749 0.005808 ~~~~~ 0.006825 Total Expenditures $ 865,823 $ 778,479 $ (87,344) ...--- 1.- , Total Surplus (Deficiency) $ (60,563) $ 2,805 $ 63,368 .3 ~ 416„C~ ....™)LA._(~~.~c 3 £ 1 .21 1 0 f 9-uG.t.. rrd.. Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. Mwk ~0257061 10597124 504 n L , IIi 41[L R L&P 1 Electric Financials.xls 1/12/2005 11 LIGHT AND POWER FUND 2003 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON Dec. Dec. Per kWh Per kWh 2003 2004 Difference 2003 2004 Revenues Utility Sales $ 7,944,245 $ 8,688,408 $ 744,164 0.067399 0.072551 Other 598,327 325,675 (272,652) Total Revenues 8,542,572 $ 9,014,083 $ f 471,54; 0.072475 0.075270 Expenditures Operation and Maintenance Expense Source of Supply $ 4,076,494 $ 4,285,939 $ 209,445 0.034585 0.035789 Distribution and Maintenance 1,389,256 1,410,615 21,359 0.011786 0.011779 Customer Billing and Accounts 585,491 611,955 26,465 0.004967 0.005110 Administration and General 1,095,244 1,034,500 (60,745) 0.009292 0.008638 Transfer to Vehicle Fund 31,400 50,883 19,483 Total Operation and Maintenance Expense $ 7,177,885 $ 7,393,892 $ 216,008 0.060897 0.061741 Debt Service 299,000 302,045 3,045 2 11L f Capital 645,696 282,355 (363,341) 11 lilli ' Transfers to General Fund and Museum 714,872 867,863 152,991 0.006065 0.007247 Total Expenditures $ 8,837,453 $ 8,846,155 $ 8,702 Total Surplus (Deficiency) $ (294,881) $ 167,928 $ 462,809 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. 1/11 L R L&P 2 Electric Financials.xls 3/3/2005 LIGHT AND POWER FUND 2003 VS. 2004 MONTH-TO-DATE CASH FLOW COMPARISON DECEMBER DECEMBER Per kWh Per kWh 2003 2004 Difference 2003 2004 Revenues Utility Sales $ 694,267 $ 775,435 $ 81,168 0.067687 0.073174 Other 110,993 5,849 (105,143) Total Revenues $ 805,260 $ 781,285 $ (23,975) 0.078508 0.073726 Expenditures Operation and Maintenance Expense Source of Supply $ 410,003 $ 469,319 $ 59,316 0.039973 0.044287 Distribution and Maintenance 147,710 79,947 (67,763) 0.014401 0.007544 Customer Billing and Accounts 44,413 42,384 (2,029) 0.004330 0.004000 Administration and General 118,676 45,805 (72,871) 0.011570 0.004322 Transfer to Vehicle Fund 2,617 4,240 1,624 Total Operation and Maintenance Expense $ 723,419 $ 641,696 $ (81,723) 0.070529 0.060554 Debt Service 24,917 25,170 254 Capital 57,915 39,291 (18,624) Transfers to General Fund and Museum 59,573 72,322 12,749 0.005808 0.006825 Total Expenditures $ 865,823 $ 778,479 $ (87,344) 0.084412 0.073461 Total Surplus (Deficiency) $ (60,563) $ 2,805 $ 63,368 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. 10,257,061 10,597,124 10257061 10597124 R L&P 1 Electric Financials.xls 3/3/2005 LIGHT AND POWER FUND 2003 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON Dec. Dec. Per kWh Per kWh 2003 2004 Difference 2003 2004 Revenues Utility Sales $ 7,944,245 $ 8,688,408 $ 744,164 0.067399 0.072551 Other 598,327 325,675 (272,652) Total Revenues 8,542,572 $ 9,014,083 $ 471,512 0.072475 0.075270 Expenditures Operation and Maintenance Expense Source of Supply $ 4,076,494 $ 4,285,939 $ 209,445 0.034585 0.035789 Distribution and Maintenance 1,389,256 1,410,615 21,359 0.011786 0.011779 Customer Billing and Accounts 585,491 611,955 26,465 0.004967 0.005110 Administration and General 1,095,244 1,034,500 (60,745) 0.009292 0.008638 Transfer to Vehicle Fund 31,400 50,883 19,483 Total Operation and Maintenance Expense $ 7,177,885 $ 7,393,892 $ 216,008 0.060897 0.061741 Debt Service 299,000 302,045 3,045 Capital 645,696 282,355 (363,341) Transfers to General Fund and Museum 714,872 867,863 152,991 0.006065 0.007247 Total Expenditures $ 8,837,453 $ 8,846,155 $ 8,702 0.074976 0.073868 Total Surplus (Deficiency) $ (294,881) $ 167,928 $ 462,809 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. R L&P 2 Electric Financials.xls 3/3/2005 LIGHT AND POWER FUND 2004 TOTAL BUDGET VS. ACTUAL YTD CASH FLOW ANALYSIS YTD Budget December YTD % of Target 2004 2004 Budget % Revenues Utility Sales $ 8,868,949 $ 8,688,408 98% 100% Other 391,835 325,675 83% 100% Total Revenues $ 9,260,784 $ 9,014,083 97% 100% Expenditures Operation and Maintenance Expense Source of Supply $ 4,440,000 $ 4,285,939 97% 100% Distribution and Maintenance 1,580,649 1,410,615 89% 100% Customer Billing and Accounts 713,137 611,955 86% 100% Administration and General 1,206,092 1,034,500 86% 100% Transfer to Vehicle Fund 50,883 i 50,883 100% 100% Total Operation and Maintenance Expense $ 7,990,761 $ 7,393,892 93% 100% Debt Service 302,045 302,045 100% 100% Transfers to General Fund and Museum 867,863 867,863 100% 100% Capital 735,254 282,355 38% 100% Total expenditures $ 9,895,923 $ 8,846,155 89% 100% Note 1) Charge for Services and Source of Supply target % based on historical data. R L&P 3 I . I , . I . r --- Il I & :,9 b : , + 0*04 9 ... . I : 4 -,6 1 ~ 1, ¥ - A . 1 4 ..1 · 6 , a ' I •*tk~ *'£'1 .4 .' 6 1 MIWI *a I. (* % 7% , , a. 4 - -- ' 0-L - I . h I ... ... . 9-1. *- ..... 1 4 .4 3.1 34 M '0 :rIL , D , 4 14 b . s I trifi e A $ & I. /4,9 8 ~%. 'k ; A J.. 1 1 4 l« 4 4, 4 ., i. _4 0 1. Z . 5. .,lib . ¥ 1 9 I I . I k 1 I .4/. 7 4 $ R.. .- q. 1 .... 74 4 . * 4 - 4.- 4. 4 £ „ I *lik. . .% 4 , 4. - 01.1 - .... 4 * I I # '' . 4 5 & A. * 4. . 4 9 1 . ••4 - 1 :p..0 - . , 1 '4 1£ 4 ST~Nt, 43 , # , I h 1 4 v . . 6 e . / I h * *. . 4 1. 4.- < Z P . 11 ' t. 4 + #* , 46 F ./ I --- I I r. . I 4. 4 %<AW# 1 A . 1 I k . 1 8:0 ' $ .- & 1, 1 -* r 4 41 J. : , -1 Ul UU .* f ic . .... 'r 1 r. g : * I. 09' S . j W 04 31%~- I . - LL D- *~ rY Nili# :,i - *ft ft . 1.0 + Lc< , 01:LU t ( ./. 5 •3 * 0 0 0 1 7-\ „% 3 N N. +1 SIt " , 6 4 . i . I ./ ¢00 .U¢L L " . 1 :61 3 : 1 \- oc . l . 01 . I 1,9 .l 1 1 1 .4, V# $. 44 9 - . . - Fll 0' 94 lA / G. C., . 4 I € . 6. 1 ¥ 4. 4, A 4 4 I I 4 6 11 & 4 . . *.le . ,-4 - %- i t ..6 4 f :' £1 .- W 10 : ----4* * .,·- D. - ...4 4. - 46 1. I 4% .1 1 .L © 1. 4 + 4 22% '1* . 1 0 1 . g. , I : 4 .... 99 4-* 31' - + i t. 3. th k. , 0 i 1 , , . 4 . t >1 # f . -' 16.1 . 4 - .'A 4 4, 0 I * 4 4 2 6 3 h 2 - , i. €.> , k. 6 , t /3 441 * 1 12, I A .': 1 , f' c W - . . - I :'/ 3 . . - , 1 0 . 6 * 47) /0 0 0 O' 0 0 0080 2, , 0 O 4 .6 0. , 0 N - 0 CO : 4 (04 9. + 4 OV'. Al'* N .- Allt .1 =4 ...11* , 4 . . MM V\IEUSAS - A 1 r. . '. 4. 4, .1 f T * 4. U . *9 . * 4 . 0"* 4 .,54 e 4 Loadh99.xls 3/3/2005 bea .or, dm 8'4' ) q02 9-d181 hi 26000. p 4 1 aft·44~ ...7 111'*4.=~ 2 4,- *~ 1 1 4/',4~ a 1%1~3; ~.. .Fyi i 6 . 504.3 -2,9,- 1 *iAmmrAWaimillimillillilillillillilillimf~ifmfI#FIFfi~:2 t- Et-*Uj..~~~~~~„„~~~~~~ it I <E.13#/Illill'll'll'll'll'll'll'll'll'll'll//1 .'171~ 1 1 1 ... AW#Im~INWNWA<VAM\ 4 ' I tl li,~MI'lilill//././... •- Fi/""//""""""""""""/ r ki@$1111***§*a*****1111***m~ . -a~ ip X20·0099»/vt«OV:AX««« 9....©A«X\>000.'000<:099*90:<......44'OV*»»AK"'.":,44««««vAL\««004>00*e•»02191 WWA:>Ul 1%~ % HMIN *14;uoIN Loadh99.xls 3/3/2005 8000 -- - - - · 02003 fooz m 9001 M 1 100 6nv unr XeIN Jel/\1 MONTHLY ENERGY PURCHASES 2-691 hi 12000 - 10000 - - 0009 000* 0001 r-r ' co 94- 1.0 , 4 '. -: 441 42 2 2 . 1, I . 0 00 . E I # 6 I 40 m 1 . A* .If w + . 4 4. 3 . 4 4 .4 6 . .1 1 .Al -. *i' kk*~i~:A,Immi#F:44:Kdres*KiHHIMAwaw :@.. .U 1 1.1 .r ' 3¢~t , 4.1 91 , . ·* r * 1.1 1 4&* ' z 1, 41 4 + + . C j e. > e 7* ~Mfiwimi#ji#,1#,#id~Imim4mRmim#HdmmmMI~*wq¥ 4 1 A 1.1 - 4 - V - 4 . I , S .116. . ... a, .: 4. i. '. .9 # . I . 12 :. bl I. : ..1 4.1 4 ..€ , f .4 , 15 . * I . r" I. t. 0 ':.4 1 .,4 ... : .1 44 4 6 .1 1 ..1.. '0-4.9 Ammfal.IMI~Immimmfm#AF##Ami#m<#IV ' 2 £ j : ~; r *4, 1 . 4 3 . f .1 4 1- *4 - 44 )44 .6 , i , I /' . 4 P.,1 4 . , * 1 , temi~evt~~.1 ' £ 1. . 26 1, 4 4. 7 ..A 4 - -, t 110 % . 1 , F ./ .'. 1 1*~32~4~ 2.3 1 'U.14 4 + 44 . *. I. ¥ I :. .42 , 1 $ 1 *tz i . .. 4 42 -* I 11, '4 1 0 M 4 . 1,», il,K , r 5> 611 4 t. 1 .'· .4, .t 1 0 4 6. .2 4 . 4 . . . Icl 2 01' i, lilli. 7 -1« .4% I, 1 9,4 >t , A# p r 4 k 9, 1 4 ./ - I 4. #2 1 - 2 Z I r 4 5 41 4 3 U.1 * 4 4 .1 4 '. ./ I t t. € 1. 4 *04 . 4 141 , 4 1 - 1 .4 I L .6- 1 c.4 , : 1 r Vrl"i~~Hil~l~iliHillill~lif ..2 1 .'' : 11 ' %'Ck '.F hik k .4 $ "4 5/ il I. I - t. .-1 , r I -, , ..3 1 v t -3 4%'.1'b . -* I . fa V '* 4 4 4,~ 0 -. 46 1 .4 i * 4, ' +A % 4 f~#04#4<%2 ¥1 h , 5 . 1 - . P? 1.£§ :- J 4 A .4 . . 1 . , a /4 I '1 34, 1 . 0 8 1 · I 1- 0 - f $ 4 L (N 7-- . 1,4 6 *. A /4 . 11''. , a & 9 4 4 9 , r ./ I. .1 3, e . .1¥ „ ' 1 .! ~ ce . 1-,4 . 4.,~4% / 1• i . 1 i . 7 . * , + 1 4 . A . . 1 8 1, 0 k . 1 . 0. t. 4 . 0 -22-~ .8 . b .0 O ; 6 0 0 . 0. V CD xt- 1%, Chi 4 4.. 4. + 1 + pes*422'Id HAAW 01*. 4/.-90 1 0 7 . 4. . . . P r 1*:. , ,. 11 + 4 ' F. 4 + f % 1 .. 2 .6 120000 1.00000 - 4 - 44 4 . LO .,r 4 . , . 40 7*: pr x *· 1 1 , 4 4 ¥ .a 4 ' + 1 1, .4 k I. « . #7 4 +, 104: . * * -·irt., .1*de*0**00(:**HNSOONNH%%1&441'·i,0*·4~060ieeeoeee ¤ I . 0 t ty' 4 ./. 1 1 .4*.2 * 1 .1144 . . .4 . 9 r, 2,6 h. 1 4.. 1 I 4 3: N + f i ¥1 1 . 1 4 4 . -- -- , t# , D .1 , , 7 4 k . ... 4 ' $··4 1 1. . 1 ... ..% A 4- + 3 1 1 A j , t . 49 . = 1... ' t"er•f 1~-t• *~ ~ 4 ~· 3082%'t:' 4·j'·det ·; .2, · '·144.-Wl•'•>**77*771,7,1 4 4 L , '. 4/, 4. r ] 1..9 k .4 / , % - k. 40 4 1. ** 4 . ./ r . [b trif / c .f/ ·•r• A • rip /. A f• ..i.13•Lf/-/14#6/6/L 1- U,- ,·,|IW• 4, ·,•"a . , 1 ' 3%9*" f-,*,V'*vvwt·.4 444,f¥6¢944'' ..1,1.1.91.-0,1111. 0 :,<.4 11 * .. i 40 ... 1 3 , 49 i ti . 4&: .0 14 4 · . ' * 4 .44 - I · ¥ 4. 1. tnt- VT* 7 9 1 1.414 4' "'t •'-·,12*Cot;*@17XN?0701= heelp,,-, 1,5, 1 € 1.1 , € I 1 1 • - 1 0 k *4 1 . . 1-4. 1 1 1 .eal 4 64.0. .V'614. t. A..f . 4 . A. 4 4 IWN , ·-• 9 4 " ·- ~ f™ -• i . **• 4"4#. 1 »00¢NNic le:'K 1 41 . 1 . . 7. . r + + I h ... 4, 44 0 i - 16 8 1 v, ~ k 1 --4~401 d '11 ' <:G . 1 - . ¢ 4. • 'i :y' I. | C 4 + /0 13*42 I , -2.- :-, 1, 4 V '4 - 1 16 4 & 0 L I . . I h 1 .. . * 1-4 0. -- 9 1, r %2 - 4- .4 .1.1 ---/1-1 .l LL 4. 4 I 1 .. 4 ./ .1 1 ¢ , X, 449. *Mt, f t 12 * 1 X & 41 - I . .1 . 0 - 1%. 5 ~ , 84 * . 'g &1 4 8-' i 0 8 - 0 *O O ' *L I. 1, 8 8% g d d hw W 6 CO I h (D LO •· (9+ 0 -a · 7. 1 1% - 1,4 -r- 44* 4 ($) SitIVS AlHJ.NOIN' ..4 . F tr , W > 6- . 1 + I. 0 r , 41 *~ f 41 , L . 2003 1004 AON des, unr der *./ 900,000+ ' -0 _ . 06b 00 ...7.lilill •t j d, D , ., ~,4 i # A e. t 4 0 1 1 10, r.%. WI 4 i.€ 6 ... I 0 0 0 »40 0 O 03,3 £:.1 - I. 1. 8 .N 61 4 Im *, / ' 1 4. f . . n U @ .9Mt/Ne . . , '2 - # 1,©~· 10»~>24><>~>6>6~>2·,»~>.>,>~>~><.·<>~x>.:x,x,. w * 4. 4 , ro ' - , 9 4 . I 4 L. . 1 - 9 7.. 1 * *4- E + . , ¢4 . 4,0 # 1, 0 4,1 - f / 4 € . 1, r 4 1 . 1. . - 0 13»333.3.36392%42.33.<491«34%~19~34'}2~2·1~2»13.3133»4«2431 -1 1 I & + .. , * * 4 4 9 1, ... N >f.. £ 1 . L # .•46 41 713 r,% ¢ t 2 . # * i:'~:'06<,OX«.:.,~<~i~:.r::.i:. 942·,12:.~~::r€«'·,tx:~,0¢Of<~€263><X ®·* i 1 , ' 1 ..~'41 .- 4 f 4 + 416 4 11 44 1, Jk 0-1 1' >',Im~A€ . : k I .m:F,v, ' t , 4' 7* 1~ . 4 * 4 7 4 ~ 1,4 4 1' r W 4 . 1 '. £ 'Vt. 1 4 9- 1 41.- .:r 41 ' t. . r . /$ 1,* A . 4 • I ' 11 'll Ill I ./ , 4 [>1·»33:'A>~50¢4»»0·06>~>31363~34·,>3633»»·~,4 3 4.. . 4 .1 . 1 , <,.1 t. 04 - 44. 1 * e .4 * ..2 ' , . t.• * 4 . [~<'<><4<'19<70<~<>00««\X'«<3>1X9<322#3:f fo~ ·i ·· • 1 4 , e 1 , t.. 1. 1 * 10 + Al.1 4 *3 . r-,44 . A,4 '* i * C , .10 - i + I '.C C r- t:. t. . a. 4 . . \.\ 20© I : : 4.. 4 Xb X X X,\,>49%49 ib 1 - 1 cr af L 9. , -2- . 0 - . . i i 2 1 ~ 1 2 - €1.-1 1 . 1/. ''- 4 ' 0 0' * ,M .. **YM* j 4 .a 10 ' 4 4 ..: € I , 1.4 f i 4 ; , - „ & 14,1 e. . . v. I ., 4 . ,#f:. . f# 1 , - .4 i - A r k . 0, - 411 4 ~ i - 44 . 'lk 4 ' t . 56%, i 0 - 4 0 1/ 1 1 . I .... . 7 4.- /4 . 4 4 22 1/ 7 4 ¢ 0 1 ILL L .2 ~ ... ..r· .4- A t. * .4 - *. 4 - F=Ziancit/,1 ...A , A , 1% - E - - . 1-1--1--- b.~ 14 - . I.,4.%4.~ 4. >- ../0 , ......14, I r I. LL . . 1 4,0 i 4 .4 - / 0. . t,4 8 2 .R , . , CO 4 4. 311 .* 1> '. j- 4., 12 .4 t - ~ =L 1 ,4 =65% - 1 d > 1. 1 -194 .- 4 . * $ 7,4 0'4' 1 2 -r, 49'.r. ~ *00.3.6- 1 {0~ 4 8- . .1 + 1 . 4 9. 4 ./ 6 b 'o» O-0 .O * 0 4 6 *, 8 . 8 4 .8 lit 24 84 4 8 4 4 4 25 * . 4 cr• d 0 ... 0 Vol 8 . ca O 0 0 O 0 5 O 0, 0 + 10- ca. , el 0 . I 1 4: ' p..\Apx\\»2«X»a\A.. 4 k~ t - I L f 1 b y- ... 1.1.. - - ,%@ - + . I. O . *co - A I <6 4)1 1 .. N 3, .1.4 *K 4 / 94 7, 1 ' ($193-IVS 3190 01 8¥31 I . 9 . I . .. 1 0 *' * ' 1- 41~ 0 .1 V . 9 ·i;m *i 'I .# 'l/ , ' 6 -0 . r .- ./.--- I.--i--'---Il.--.-#..* SALEHIST.XLS 3/3/2005 4 deS 4 Ve J v' Jew EAR TO DATE.EL LES 0 L-d91 hi 10,0*000' . 000 000'E 000'boo' L 3/3/2005 .. 0 2005 Year-to-Date t Electric Revenues *s Budget & 1 '. . . 4 2 4 + I I ' 1*0,000,000* 4 - .. I . a th I . I . , F.t ' 8,000,000 41 . . < - f 4 .. 6,000,000 61- - ' - 0 Budget . -./ M' * ' 4 f 4,000,000 .7 ~- -Il--- '-Ill- B I Actual - ... * -' 1 Q. . 2,000,000 Mu -7 t. j.. 'Q & I It'11 1. , , 1 1 1 r .0 6- 6. A C IA-= .CD Cl *< > , KO .. t 0 0 (0 a (0 1 -=; 1, al - 0 0) 11 1 < 03 O Z G . . . 4 . u.-. ~.4m ./. 1. I. D , D I 2005 Year-to-bate 1% 4 4 : #B . * PRPA Invoices vs: Budget ---- C I . - 2 34* . I 'pe 1 ...... 2 ··le 5,400,000 · 04 . ..... 4,000,009 - ... 1 - .. 1, D : . - 1 1,1 ,~ t 3,000,000. .A i ~ t £ Budget 16 ':- 2,000,000 - I Actual 1,000,000 * · 1 e , 0 1 '1~1 1. T £0 72 16 21,4. it,11 VC 1 -31.' *1 Cl l .M ' R.1-O . 7 u. SY <a€ ° <2628 R L&P-11 0 4 , Water Financials.xls 1/12/2005 WATER FUND 2003 VS. 2004 MONTH-TO-DATE CASH FLOW COMPARISON DECEMBER DECEMBER Per Gallon Per Gallon 2003 2004 Difference 2003 2004 Revenues Water Sales $ 142,776 $ 152,319 $ 9,544 0.00659 0.00612 Plant Development Tap Fees 21083 2,392 (20,691) Water Rights Tap Fees 62,600 7,020 (55,580) Other 6,795 1,853 (4,942) Total Revenues $ 235,254 $ 163,585 $ (71,669) 0.01086 0.00657 Expenditures Operation and Maintenance Expense Source of Supply $ 9,899 $ -$ (9,899) 0.00046 0.00000 Purification 39,910 22,688 (17,222) 0.00184 0.00091 Distribution and Maintenance 61,810 42,607 (19,203) 0.00285 0.00171 Customer Billing and Accounts 21,735 5,922 (15,813) 0.00100 0.00024 Administration and General 7,990 24,304 16,314 0.00037 0.00098 Transfer to Vehicle Fund 396 1,167 771 {j-E Total Operation and Maintenance Expense $ 141,739 $ 96,687 $ (45,052) 0.00654 0.00388 Debt Service 25,348 24,492 (857) Capital 20,021 - (20,021) Transfer to General Fund 6,199 6,199 0.00000 0.00025 Total Expenditures $ 187,108 $ 127,378 $ (59,731) ~ 2' 6 7 +Olu Monthly Surplus (Deficiency) $ 48,145 $ 36,207 $ (11,938) L.w#-/ 1 9 7-,4, Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. tiA' t~ :I,L RW1 Water Financials.xls 1/12/2005 WATER FUND 2003 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON YTD YTD December December Per Gallon Per Gallon 2003 2004 Difference 2003 2004 Revenues Water Sales $ 2,071,219 $ 2,162,614 $ 91,394 0.005258 0.005460 Plant Development Tap Fees 274,802 128,722 (146,081) Water Rights Tap Fees 416,905 325,688 (91,218) Other 158,328 66,028 (92,300) Total Revenues $ 2,921,255 $ 2,683,051 $ (238,204) 0.007416 0.006774 Expenditures Operation and Maintenance Expense Source of Supply $ 110,516 $ 125,698 $ 15,182 0.000281 0.000317 Purification 401,733 430,329 28,596 0.001020 0.001086 Distribution and Maintenance 486,478 554,524 68,046 0.001235 0.001400 Customer Billing and Accounts 203,483 195,420 (8,063) 0.000517 0.000493 Administration and General 541,497 533,107 (8,390) 0.001375 0.001346 Transfer to Vehicle Fund 4,750 14,000 9,250 Total Operation and Maintenance Expense $ 1,748,457 $ 1,853,078 $ 104,621 0.004439 0.004678 Debt Service 304,176 293,898 (10,278) Capital 1,129,612 413,622 (715,990) Transfer to General Fund 74,387 74,387 0.000000 0.000188 Total Expenditures $ 3,182,246 $ 2,634,985 $ (547,261) Annual Surplus (Deficiency) ' $ (260,990) $ 48,066 $ 309,056 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. RW2 Water Financials.xls 3/3/2005 WATER FUND 2003 VS. 2004 MONTH-TO-DATE CASH FLOW COMPARISON DECEMBER DECEMBER Per Gallon Per Gallon 2003 2004 Difference 2003 2004 Revenues Water Sales $ 142,776 $ 152,319 $ 9,544 0.00659 0.00612 Plant Development Tap Fees 23,083 2,392 (20,691) Water Rights Tap Fees 62,600 7,020 (55,580) Other 6,795 1,853 (4,942) Total Revenues $ 235,254 $ 163,585 $ (71,669) 0.01086 0.00657 Expenditures Operation and Maintenance Expense Source of Supply $ 9,899 $ -$ (9,899) 0.00046 0.00000 Purification 39,910 22,688 (17,222) 0.00184 0.00091 Distribution and Maintenance 61,810 42,607 (19,203) 0.00285 0.00171 Custorner Billing and Accounts 21,735 5,922 (15,813) 0.00100 0.00024 Administration and General 7,990 24,304 16,314 0.00037 0.00098 Transfer to Vehicle Fund 396 1,167 771 Total Operation and Maintenance Expense $ 141,739 $ 96,687 $ (45,052) 0.00654 0.00388 Debt Service 25,348 24,492 (857) Capital 20,021 - (20,021) Transfer to General Fund 6,199 6,199 0.00000 0.00025 Total Expenditures $ 187,108 $ 127,378 $ (59,731) 0.00864 0.00512 Monthly Surplus (Deficiency) $ 48,145 $ 36,207 $ (11,938) Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. RW1 Water Financials.xls 3/3/2005 WATER FUND 2003 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON YTD YTD December December Per Gallon Per Gallon 2003 2004 Difference 2003 2004 Revenues Water Sales $ 2,071,219 $ 2,162,614 $ 91,394 0.005258 0.005460 Plant Development Tap Fees 274,802 128,722 (146,081) Water Rights Tap Fees 416,905 325,688 (91,218) Other 158,328 66,028 (92,300) Total Revenues $ 2,921,255 $ 2,683,051 $ (238,204) 0.007416 0.006774 Expenditures Operation and Maintenance Expense Source of Supply $ 110,516 $ 125,698 $ 15,182 0.000281 0.000317 Purification 401,733 430,329 , 28,596 0.001020 0.001086 Distribution and Maintenance 486,478 554,524 68,046 0.001235 0.001400 Customer Billing and Accounts 203,483 195,420 (8,063) 0.000517 0.000493 Administration and General 541,497 533,107 (8,390) 0.001375 0.001346 Transfer to Vehicle Fund 4,750 14,000 9,250 Total Operation and Maintenance Expense $ 1,748,457 $ 1,853,078 $ 104,621 0.004439 0.004678 Debt Service 304,176 293,898 (10,278) Capital 1,129,612 413,622 (715,990) Transfer to General Fund 74,387 74,387 0.000000 0.000188 Total Expenditures $ 3,182,246 $ 2,634,985 $ (547,261) 0.008078 0.006652 Annual Surplus (Deficiency) $ (260,990) $ 48,066 $ 309,056 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. RW2 Water Financials.xls 3/3/2005 WATER FUND 2004 TOTAL BUDGET VS. ACTUAL YTD CASH FLOW ANALYSIS YTD Budget December YTD % of Target 2004 2004 Budget % Revenues Water Sales $ 2,047,000 $ 2,162,614 106% 100% Plant Development Tap Fees 200,000 128,722 64% 100% Water Rights Tap Fees 300,000 325,688 109% 100% Other 100,842 66,028 65% 100% Total Revenues $ 2,647,842 $ 2,683,051 101% 100% Expenditures Operation and Maintenance Expense Source of Supply $ 130,000 $ 125,698 97% 100% Purification 411,825 430,329 104% 100% Distribution and Maintenance 499,592 554,524 111% 100% Customer Billing and Accounts 219,647 195,420 89% 100% Administration and General 640,874 533,107 83% 100% Transfer to Vehicle Fund 14,000 14,000 100% 100% Total Operation and Maintenance Expense $ 1,915,938 $ 1,853,078 97% 100% Debt Service 293,898 293,898 100% 100% Capital 1,166,020 413,622 35% 100% Transfer to General Fund 74,387 74,387 100% 100% Total Expenditures $ 3,450,243 $ 2,634,985 76% 100% 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. RW3 , I '' 1 , ¥ ( 1 , - 7. 4 i .11 E 12 , 1. ' :- 1 I. r r. e . I 4 4. 6 . . I 5,1 4- • 1. I I . 1- i . 1, .- 1 1 , ... . .1 . 1 4. 2 1 1 - I • 4 I P ' 9 6 . . 1 :. I . g k V I . 5 £ 4 1 6. 427* , 4,7.- ' ' 2 - F a I. 4,1 . ........ I i I - r . */ 4-6- I . - $ W . / 61 4 . t 'I / k. . ... I . .................................................. I : b . . 1 I ¢ 1 NQQ***WOON*NON©*NNY 1 , 0 / .......................................... 1 Sales.xls 3/3/2005 ¤2003 f001O - - 000'091. 900Z 0 oea AON 100 deS 6nv Inf unr XeIN Jdv Jel/\1 qe=1 uer Water Sales by Month 9Mhl - 000'00 L 300,000 250,000 - 000'09 200,000 1 1 R 8 i 0 3/3/2005 Water Sales Year-To-Date #2,097,000~ 02003 CZZ]2004 9002 3 136pne - )0 0C - m )0 . 1 2 ~11* 1 0(