The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2005-05-19\llc_h/6- r, AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8 a.m. Thursday, May 19, 2005 Preparation date: 5/12/05 *Revision date: ACTION ITEMS Light & Power Department 1. L&P Budgeted Boom/Crane Truck â€¢ Request to purchase truck REPORTS Light and Power 1. Light & Power Department Financial Data 2. New Fiber Optic Trunk Line 3. Miscellaneous Water 1. Water Department Financial Data 2. Prospect Mountain Water Company 3. Backflow Prevention Program 4. Accountable Water 5. Water Rights 6. Miscellaneous 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 Inter-Office Memorandum May 2,2005 TO: Bill Linnane and Bob Goehring FROM: Dave Mahany SUBJECT: Budgeted Light & Power Derrick Truck Replacement (93330) Background: The 2005 Light & Power Department budget includes $200,000 for the replacement of Truck 93330, a 1986 International 1954 Series - 4x2 Truck, 19 years old with 7,751 hrs / 40,000 miles. This truck is equipped with a Pole Derrick/Boom Aerial Device used for installation of utility poles and transformers. Cost/Budget: Cost: â€¢ Altec Industries - Denver, CO / Dixon, CA 2005 International 7400 - 4x4 w/Altec DM Series Aerial Derrick ................................. $193,727 Trade-in: Equipment #93330 1986 International 1954 Series w/Telelect Commander 4042 Aerial 6,000 Bid Price: $187,727 â€¢ Terex Utilities - Denver, CO / Seattle, WA 2005 International 7400 - 4x4 w/Telelect 4047 Series Aerial Derrick "Did not meet all specifications" $?05,250 Trade-in: Equipment #93330 1986 International 1954 Series w/Telelect Commander 4042 Aerial 3,500 Bid Price: $201,750 â€¢ Versalift Utilities - Colorado Springs, CO / Waco, TX Discontinued Manufacturing of smaller Derricks (April 2005) NO BID Budget: $200,000.00 Action: Staff recommends: Trading-in Truck 93330 and purchasing a new 2005 International 7400 - 4x4 w/Altec DM Series Aerial Pole Derrick from Altec Industries for a cost of $187,727. DM/lb 1-1 Electric Financials April Best Guess 5/18/2005 LIGHT AND POWER FUND 2005 vs. 2004 MONTH-TO-DATE CASH FLOW COMPARISON APRIL APRIL Per kWh Per kWh 2004 2005 Difference 2004 2005 Revenues Utility Sales 713,518 852,310 $ 138,792 0.073539 0.077672 Other 34,365 8,351 (26,014) Total Revenues 747,883 860,661 $ 112,778 0.077081 0.078433 Expenditures Operation and Maintenance Expense Source of Supply $ 324,832 $ 359,580 $ 34,748 0.033479 0.032769 Distribution and Maintenance 180,798 121,425 (59,373) 0.018634 0.011066 Customer Billing and Accounts 59,965 60,581 616 0.006180 0.005521 Administration and General 112,908 119,964 7,056 0.011637 0.010932 Transfer to Vehicle Fund 4,240 - (4,240) Total Operation and Maintenance Expense $ 682,743 $ 661,550 $ (21,193) 0.070367 0.060288 Debt Service 25,170 59,497 34,327 Capital 15 295,446 295,431 Transfers to General Fund and Museum 72,322 80,969 8,647 0.007454 0.007379 Total Expenditures $ 780,250 $ 1,097,462 $ 317,212 0.080417 0.100013 Total Surplus (Deficiency) $ (32,367) $ (236,801) $ (204,434) Note 1) colored numbers notes: Dist/Maint: Meters; Debt sen, not booked yet Capital: Optics Line R L&P 1 Electric Financials April Best Guess 5/18/2005 LIGHT AND POWER FUND 2005 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON YTD YTD APRIL APRIL Per kWh Per kWh 2004 2005 Difference 2004 2005 Revenues Utility Sales $ 3,064,074 $ 3,382,663 $ 318,589 0.070671 0.076169 Other 75,902 51,974 $ (23,928) Total Revenues $ 3,139,976 $ 3,434,637 $ 294,661 0.072421 0.077339 Expenditures Operation and Maintenance Expense Source of Supply $ 1,520,769 $ 1,622,427 $ 101,658 0.035075 0.036533 Distribution and Maintenance 477,703 473,429 (4,274) 0.011018 0.010660 Customer Billing and Accounts 232,502 225,602 (6,900) 0.005362 0.005080 Administration and General 388,017 415,187 27,170 0.008949 0.009349 Transfer to Vehicle Fund 16,961 - (16,961) Total O+M $ 2,635,952 $ 2,736,645 $ 100,693 0.060796 0.061622 Debt Service 100,682 59,497 Gil,185) Capital 36,111 301,573 265,462 Transfers Gen + Museum 289,288 321,352 32,064 0.006672 0.007236 Total Expenditures $ 3,395,510 $ 3,419,067 $ 23,557 0.078315 0.076988 Total Surplus (Deficiency) $ 103,863 $ 15,570 $ (88,293) R L&P 2 Electric Financials April Best Guess 5/18/2005 LIGHT AND POWER FUND 2005 TOTAL BUDGET VS. ACTUAL YTD CASH FLOW ANALYSIS YTD Budget APRIL YTD % of Target 2005 2005 Budget % Revenues Utility Sales $ 9,331,199 $ 3,382,663 36% 36% Other 688,462 51,974 8% 8% Total Revenues $ 10,019,661 $ 3,434,637 34% 36% Expenditures Operation and Maintenance Expense Source of Supply $ 4,610,000 $ 1,622,427 35% 36% Distribution and Maintenance 1,571,865 473,429 30% 33% Customer Billing and Accounts 651,596 225,602 35% 33% Administration and General 1,343,234 415,187 31% 33% Transfer to Vehicle Fund 52,400 0% 33% Total Operation and Maintenance Expense $ 8,229,095 $ 2,736,645 33% 35% Debt Service 303,995 59,497 20% 33% Transfers to General Fund 886,493 321,352 36% 33% Capital 1,022,417 301,573 29% 33% Total expenditures $ 10,442,000 $ 3,419,067 33% 34% Note 1) Charge for Services and Source of Supply target % based on historical data. R L&P 3 MONTHLY PEAK DEMAND 26,000 - 24,000 1 ~ -0-2003 22,000 -0-2004 -4â€¢-2005 i 20,000 2 TZ:,5 r/\ 18,000 UA /0--rL 16,000 14,000- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES JI' 12,000 L 4 0 + 1 _ T -7 3 5% 2% 4 5 5 10,000 - #il-_ 04- -* 4 T 0- 3.- - .4 -4 %1 34$-1 IJ2 - -y m -7 -5 3 0 A 3% 31 34 0 3 K 030% 94404$ $ 3 0*** 02003 8,000 - ft- ti- 34- 0- 4.- 1- - 1-- 4- 4.- 4- 0 24 54 0 lili '11 3j%j Â¤ 2004 3% 4Â§ 4 3% 3 * 4 lil!,1iI 1,1 1,1 4 /4 94 2.i ** 0 % 5 0 9 3 * 02005 6,000 - /1- 011- %9- 44- 0- 3- i-%- 3- 0- 6- j- 4 2 21 11 4, % 4 11, 11 1,1 if '11 5 i #:I W.35$94#00 >X. 4,000 - a 4.14 4-3 5 5 4 0 3-L 1- 1- A- A- % e#-4-0-3 4 9 0494#30 1 4 30 4 0 4 5 @ 8 0 2 *t fs 2% 3*#**&03 2,000 0 1 44,41, 32: 1 4.1 4 1 4 1 ~ 1 3-1 4 1 5 1 4 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 p \49*******a NÂ»Â»\*NON\\\\\\Â»\1 XE "0 YTD ENERGY PURCHASES 120,000 -7- - f I4 100,000 -4 $ - 1 1 4, 4 I't' 11 lili 80,000 '1. '11 111- lip .11-- t.- 39 4 02003 1.09% YTD 2005 VS 4 4 '4 4 5 m 2004 60,000 -- 2004 444 1- .1 1. 11 1. $ 2%90 40,000 ~. i--1-1 ~~ - ~ 4 - %- 0- 1- 2 - f 20,000 1 OLa 0- 0 111 111 11- 111 11 41 4. 1 0 '1. It- 1 1 1 1 1 1 1 1 1 1 1 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD POWER COST vs. BUDGET ($1,000) m BUDGET Â¤ACTUAL 5,000 4,500 4,000 ..r i 3,500 , m 3,000 : E 2,500 : mi 2,000 Â¥ 1,500 1,000 500 m % Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 YTD MWH Purchased ELECTRIC SALES BY MONTH ($1,000) 1,000 900 i 800 4 N # -kÂ° ft h i - 4 . i I. I W Â£ U 7 7â‚¬ f - 02003 19 4 - -1. A its , 4 45 2 - -1= S D B k ma â‚¬* 44 :ek - 1--LI- 1-3 -5 m 2004 600 - Â§4- >#- 3 2-15- 2- 4--- 1% - 0 2005 I. .' 1, * a , R e- 12 $ r Â·fe . i ** 4, 5 0 f $ 0 1 * Â¢ft:1 4 4 4 1 4 q 400 - *%- p- h- Ur- f.- 2- h- 1- A- B- 9 4% it /4 ME $ 300 43Â¢ ' R t U l # 1 2 1 1 1 M i I , i , i 1 10 .e ..: ~A M M + Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR TO DATE ELECTRIC SALES ($1,000) 10,000 9,331,199 9,000 8,000 . 7,000 10.40% 2005 YTD - 1 - - VS 2004 6,000 5,000 - - 02003 T 4,000 -4- 4- - i. 4 - -4 4 8 2004 3,000 â‚¬â‚¬ 4 4 .-- 4- - 4 A I ~2005 -: if i : 4 - 2,000 i. 1 4 4 1 1 4 1 rti- 2;- 4 _ 1 : 4 + 1,000 , 4 -- 4 -- 4 -- 4 - .. - V - u -- [114 11 9 2 4 1 i 4 .4 .2 .1 - - 0 F 1 1 1 1 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 8 YEAR TO DATE SALES MONTHLY SALES 44%421 WEE<ELEERâ€¢flÂ¢RECKâ‚¬â‚¬444~ 1 < ' -Â£. ': 4, . ' F 4 9 9 X W -4 -Â·â‚¬ V Â· ELECTRIC REVENUES vs BUDGET ($1,000) m Budget OActual 10,000 9,000 8,000 7,000 1 1 553= 6,000 441 - -21. ifi E a 5,000 - 44 4,000 3,000 ..: =Mi -22 -11 lilif 2,000 44 8 A # 0 01 m Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 9 Water Financials april best guess 5/18/2005 WATER FUND 2005 vs. 2004 MONTH-TO-DATE CASH FLOW COMPARISON APRIL APRIL Per Gallon Per Gallon 2004 2005 Difference 2004 2005 Revenues Water Sales $ 149,646 $ 149,097 $ (9,624) 0.00598 0.00679 Plant Development Tap Fees 37,084 15,992 26,864 Water Rights Tap Fees 90,680 31,320 78,698 Other 1,958 1,175 (763) Total Revenues $ 279,368 $ 197,584 $ 95,174 0.00688 0.00959 Expenditures Operation and Maintenance Expense Source of Supply $-$ - $ 1,243 0.00051 0.00049 Purification 46,622 36,700 (1,444) 0.00080 0.00065 Distribution and Maintenance 56,974 60,433 2,320 0.00119 0.00114 Customer Billing and Accounts 11,006 9,637 (2,888) 0.00030 0.00016 Administration and General 49,064 45,949 (12,593) 0.00192 0.00124 Transfer to Vehicle Fund 1,167 - 29 Total Operation and Maintenance Expense $ 164,832 $ 152,719 $ (13,333) 0.00475 0.00373 Debt Service 24,492 - 1,197 Capital 22,074 15,346 - Transfer to General Fund 6,199 5,851 491 0.00026 0.00024 Total Expenditures $ 217,596 $ 173,916 $ (11,645) 0.00602 0.00492 Monthly Surplus (Deficiency) $ 61,771 $ 23,668 $ 106,820 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. RW1 Water Financials april best guess 5/18/2005 WATER FUND 2005 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON YTD YTD APRIL APRIL Per Gallon Per Gallon 2004 2005 Difference 2004 2005 Revenues Water Sales $ 570,659 $ 580,630 $ 9,971 0.00646751 0.00654828 Plant Development Tap Fees 54,254 94,339 40,086 Water Rights Tap Fees 139,500 239,983 100,483 Other 18,926 15,595 (3,331) Total Revenues $ 783,338 $ 930,547 $ 147,209 0.00887789 0.01049461 Expenditures Operation and Maintenance Expense Source of Supply $ 98,057 $ 77,347 $ (20,710) 0.00111132 0.00087231 Purification 140,280 115,021 (25,259) 0.00158985 0.00129719 Distribution and Maintenance 170,033 203,079 33,046 0.00192705 0.0022903 Customer Billing and Accounts 58,149 38,580 (19,569) 0.00065903 0.0004351 Administration and General 208,363 155,220 (53,143) 0.00236146 0.00175055 Transfer to Vehicle Fund 4,667 - (4,667) Total Operation and Maintenance Expense 679,548 589,247 $ (90,301) 0.00770159 0.00664546 Debt Service 97,966 39,130 (58,836) Capital 39,739 83,338 43,599 Transfer to General Fund 24,796 22,275 (2,521) 0.00028102 0.00025122 Total Expenditures $ 842,049 $ 733,990 $ (108,059) 0.00954328 0.00827786 Annual Surplus (Deficiency) $ (58,710) $ 196,557 $ 255,267 Note 1 Colored numbers Source: NCWCD invoices Purification: chemicals;Admin:Tank Eng. Dist: 20% YTD; Cust Acc't: 20% YTD RW2 Water Financials april best guess 5/18/2005 WATER FUND 2005 TOTAL BUDGET VS. ACTUAL YTD CASH FLOW ANALYSIS YTD Budget APRIL YTD % of Target 2005 2005 Budget % Revenues Water Sales $ 2,097,000 $ 580,630 28% 25% Plant Development Tap Fees 298,882 94,339 32% 25% Water Rights Tap Fees 325,919 239,983 74% 25% Other 84,843 15,595 18% 25% Total Revenues $ 2,806,644 $ 930,547 33% 25% Expenditures Operation and Maintenance Expense Source of Supply $ 133,900 $ 77,347 58% 33% Purification 461,314 115,021 25% 25% Distribution and Maintenance 576,734 203,079 35% 25% Customer Billing and Accounts 194,540 38,580 20% 25% Administration and General 519,145 155,220 30% 25% Transfer to Vehicle Fund 14,350 - 0% 25% Total Operation and Maintenance Expense $ 1,899,983 $ 589,247 31% 27% Debt Service 308,261 39,130 13% 25% Capital 256,900 83,338 32% 25% Transfer to General Fund 80,280 22,275 28% 25% Total Expenditures $ 2,545,424 $ 733,990 29% 26% 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 5/17/2005 Water Sales by Month ($) 300,000 250,000 - 200,000 - Â¤2003 150,000 --. --- ---- -b,-3 -0 7- Â¤2005 13 5- 8 . I 50,000 - . El- I 5- / 5 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Water Sales Year-To-Date ($1,000) 2,500 $2,097,000 - 2,000 - M2003 - - I2004 1,500 M 2005 ----- -Budget - 1,000-- 1.66% 2005 YTD VS 2004 --- - - -:-- - 500 - o rrIA rm 3 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 4/\\\\\\1 Acct. per Mo. 1997 1998 1999 2000 2001 2002 2003 2004 Running Running Running Running Running Running Running Running 12 Mo. Ave. 12 Mo. Ave. 12 Mo. Ave. 12 Mo. Av, 12 Mo. Av,12 Mo. Avel2 Mo. Av, 12 Mo. Av, 72 77 83 82 85 83 82 88 72 74 83 82 86 83 82 88 74 75 83 82 85 83 83 87 74 76 84 82 85 82 82 89 75 77 83 82 85 82 83 90 75 76 85 82 86 83 87 90 75 78 86 82 86 81 85 89 79 78 85 83 88 86 89 90 72 78 84 83 85 82 86 88 73 80 85 87 86 89 85 88 77 75 78 84 84 83 86 88 68 76 87 84 84 82 87 89 WR-4 YTD April-05 Year-end Projected Water Rights Surplus With Actual Up To Date Monthly Use (A.Ft.) Â£11 m (21 01 (21 actual projected projected projected projected water rights water rights water rights water rights water rights owned available use lease surplus (A.Ft.) (A.Ft.) (A.Ft.) (A.Ft.) (A.Ft.) (C2-C3-C4=C5) USA 500 500 500 0 0 WG 300 200 (1) 125 (2) (3) 10 (4) 65 CBT 1211 @ 70%= 1090 (6) (7) 160 122 (5) 808 TOTAL 1790 785 132 873 Note 1: Ordered 200 of 300 Town owned Windy Gap Units Note 2: January YTD Projected use of WG = Glacier Creek projected use (1167 af) ** multiplied by the Augmentation Plan YTD depletetion factor (0.107) * = 125 af. Note 3: Projected 2005 use is based on conservatively high water use in 2002 plus 5% = Glacier Creek 1106 af Note 4: Glacier View 1 AF WG Units MacGregor Mountain Lodge 1 AF WG Units Continental Water Bank 8 AF WG Units 10 AF Note 5: RedSchool Districts Lease 75 AF CBT Units Greg White / Client 22 AF CBT Units Miscellaneous 25 AF CBT Units 122 AF Note 6: NCWCD: Quota set at 70% at the April Meeting, 847.7 af available Note 7: 242.2 af of CBT Carryover available onlv if ordered by April 1. Ordered all 242.2 af on 3/30/05 YTD April-05 Year-end Projected Water Use With Actual Up To Date Monthly Use (A.Ft.) Depleted Estimate Estimate Depletion Estimate USA WG CBT CBT Actual Actual factor Actual Actual Actual Actual Actual Marys Glacier Glacier Glacier (Replacement) (Carryover) (A.Ft.) (A.Ft.) (A.Ft.) (A.Ft.) (A.Ft.) (A.Ft.) (A.Ft.) 2004 Oct 0.08 18 Nov 0 92 0.06 6 0 0 0 0 Dec 0 94 0.06 6 2 0 0 0 2005 Jan 34 59 0.06 4 12 22 0 0 Feb 88 0 0.06 0 85 3 0 0 March 94 0 0.06 0 94 0 0 0 April 98 0 0.07 0 92 0 0 0 May 114 71 0.12 9 72 5 35 0 June 74 140 0.17 24 0 18 57 0 July 62 218 0.13 28 0 17 45 0 Aug 47 212 0.11 23 0 25 22 0 Sept 0 167 0.10 17 0 0 0 0 Oct 0 114 0.08 9 0 0 0 TOTAL 610 1167 ** 125 357 107 160 0 April, YTD Projected Year-end Depletion Factor: 125/1167 = 10.7% * 4 4 -CU LOO CON KNANNAN NLOONI.000000000 r'Â¥0640;No#00409)4 5218 6 2 7- .r- 1 OB E 0000000000000 0000000000000 0 5 0 4- Noo 0 000 000 00 ni 9 2 0 0 0000000000000 0000000000000 .-. 0 N (5 - U. Loodoodooddoo tri 0 6 :0 2Z 00000(90000000- 0000Â©000000000 2 0 ~~~ ado~adadoadd~ 86< 000000000000 0000000000000000000 00 0 2 34Â· 000â„¢4#444444 m 0 W (\1 N C\1 C\1 C\1 C\1 (\1 C\1 0000000000000 $3/e2t% dooNNoodoodo 4 000000000000000 al N (4 91- (D (\1 N cocoale0o000- 6, c\!010'KNO 0000000 coâ€¢rotâ„¢dooodood N 9- C\1 3 1,1111'CO Â£0000 : 00 0006 W W co co 01) CD co co m co cO co 1009(091-00000000 h *-0 10 0 LO 00000000(9 u. Soci ui ui ce 00000000 cri S- i 6 * * Z <= N O-(9 00000000 O-CDC)00000000 6â„¢40006000000 co .g 6 00)0)1.0 91'C)-C\1 0000 C\I C\lor)000 .r- C\1 N - NOOOO00 10 4- 09 4- 06 44Ndadd#N cri W W g CO CD (D OOoOOG)10 C\la) 000 If) 0000000Â® W O *ceâ„¢000040.-0 u; IL LL It- 1111 4 <<<< Â·r- Â·r- (0 C\1 1.- C) C) CU 00001 (06) CDC\1 0 OM(00000 LO NU) CU O .i â‚¬ EZ*gg*doodecdociN K No0OO00 9- 9- LO O 0 N t 32 32 32 32 32 32 32 32 aR aq B & (D W Â© (O 0 h C\1 A CD,- 32 CO - 0 soo - * 91- in LO LO in LO Ir, LO LO 89 P a9 9259 6 w 99 - 1% g O 2 O - 2 >Â· A Le W a S 0 r.a)coa-cOB-3 Ja) O OZO-iu-6<5-17<01- (siom Factor Native Native 1 st Use Native Actual 1 st Use Release Release Release (1) (3) (5) (13) Release M ) (Towns) (Oth rs) 5.60 AF for amount owed to R , leaving 0.12 credit Of Depletion WG Out Of Depletion Native 2nd use Cred t speobl S,pold JO# peseele] dv g -:IV 091 L * ) Jel'!IN sluuea 41!M peleu!0000 86pol u!ejunOIN JO TEMPORARY SUBNfE~o~ATER SUPPLY PLAN Month Depletion Estimated Estimated Estimated Actual YT[) Re~uired Depletion Release th (Tbl./p (T 1 ~Tbl.7pg122 (3)/(1.0-(1)) (6)/(1.0-(1)) Ac-Ft A Ac-Ft Ac-Ft A 7.58 4.12 9.65 5.30 8.84 8.84 8.84 8.84 8.84 TOWN OF ESTES PARK Lt. 98 *0/20/0 L peseeleJ - ) indicates credit to river 0/OOL Muee JeleM lelue