HomeMy WebLinkAboutPACKET Utilities Committee 2005-10-20.3-*eA,-£ - A LE AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8 a.m. Thursday, October 20,2005 Preparation date: 10/12/05 *Revision date: ACTION ITEMS Light & Power Department 1. Replacement of Light & Power one-ton flatbed/utility truck • Request approval of budgeted item Water Department No action items REPORTS Light and Power 1. Light & Power Financial Report Water 1. Water Department Financial Report 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 DATE: Oct 10, 2005 TO: Bill Linnane / Bob Goehring FROM: Dave Mahany SUBJECT: Budgeted Light & Power Small Dump Truck Replacement (#93323) Background: The 2005 Light & Power Department budget includes $60,000 for the replacement of Truck #93323, a 1985 Ford F-350 - 4x4 small dump truck, 20 years old with 62,300 miles (Replacement Type 9: 50,000- 60,000 miles or 10 years). This truck is equipped with a dump bed and Tommy Lift used for transporting heavy transformers, misc. Light & Power equipment and job site clean up. Cost/Budget: Bids received: • Spradley Barr Ford - Fort Collins, CO 2006 Ford F-550 - w/dump body - Tommy Lift & winch w/Layton Equipment body $48,417 Trade-in: Truck #93323 - 1985 Ford F-3504x4 w/dump body - Tommy Lift....... - $4,000 Bid Price: $ 44,417 • Spradley Barr Ford - Fort Collins, CO 2006 Ford F-550 - w/dump body - Tommy Lift & winch w/MacDonald Equipment/Maxey body $58,181 Trade-in: Truck #93323 - 1985 Ford F-350 4x4 w/dump body - Tommy Lift...... - $4,000 Bid Price: $54,181 • Phil Long Ford - Colorado Springs, CO 2006 Ford F-550 - w/dump body - Tommy Lift & winch w/MacDonald Equipment/Maxey body $58,124 Trade-in: Truck#93323 - 1985 Ford F-3504x4 w/dump body - Tommy Lift....... - $3,625 Bid Price: $ 54,489 • Valley Ford - Longmont Co NO BID • Garnsey Wheeler- Greeley, CO....................................................................................NOBID Budget: $60,000 Cost: $44,417 Action: Staff recommends trading in Truck #93323 and purchasing a new 2006 F-550 - 4x4 w/Dump Body - Tommy Lift & winch from Spradley Barr Ford at a cost of $44,417.00. DM/lb 1-1
5 4 & 22 , ae 4 A R*g 2:222 @ >1 N M- rt %Z m 0 0 000 22 0 C 0 091-v vo O 1 0 0% 8 3: 32 - 0 0 ·* 0 8 O.Eik_ ti g 389 . & 3532 M 2 0 2 1 05* o 6@ r i .a mot@ ; 1 = 7 9 0. 5 AZU 82 4 Uoe SEP SEP VARIANCE Per kWh Per kWh YTD % $10,902,9~ 2,726,556 $125,358 $2,127,146 $2,127,146 100% %54 94£' I 000'[ 0000.0 000 00 %02 864'65 566'EOE 00!/UOS NOG %64 £8L'E9D L I VEZO' I (01,I'Ed) *86'H %ZL 560'8L9 £68'8£6 (898'OL) 858'OL %59 855'648'9 860'68*'OI 9§L0'0 800-0 (0£92*Z) EOZ'6*L 69§'IOS %8t,I- Z80'*69 (LEf'69*) (126'60I) IL9'*6 £65'*OZ l#UOUI JOJ uowsod {Iseo u! 32Uet¤ %0L I 8ZZ' IZ8'3$ 60L'L59'1$ 9Et/5I$ LZE'IES'ES I6L'508'3$ 00uquq puni (0!qusn) poppisoI[m SmpuR MONTH TO DATE YEAR TO DATE 298,778 318,072 (19,294) 0.0326 0.0321 4,610,000 3,314,570 Distribution and Maintenance 117,780 138,618 (20,838) 0.0129 0.0140 1,608,745 1,044,650 mer Billing and Accounts 44,199 54,424 (10,225) 0.0048 0.0055 651,596 443,824 Z6L'E*8 ZS¢09£'I EI IO'O ZMO (£91'EL) I I'ZII 8£8'8£ Iel@UOD pUB uone.Ils! % ISI'St,9'5 E6L'EEZ'8 6290'0 90 £9'[ZI) I E'[29 5ZL'66* osuodxEI jougualuyew pue uo!181@d~ Beginning net assets (assets - liabilities) $10,500,396 ($402,542) $10,237,501 $10,237,501 677,344 745,871 68,527 0.0740 0.0753 9,331,199 7,137,842 628'565 (LED'694) (186'9LI) OIS'LE Z6L'*OZ (IBHduo olojoq soinlipuodxo (En'86) V/N 090'L9 I98'99 (661) sjoinos 10[110 01 polejoIIH/POA!0001 4500 2004 2005 2005 29,017 31,142 2,125 688,462 706,361 777,013 70,652 10,019,661 Beginning unrestricted (usable) fund balance 2,601,1 JOAO SOnUOAOIJO XOUO!0901)/SS@OXED Ielolqns LIGHT AND POWER FUND PARISON peration and Maintenance Expense
TOWN OF ESTES PARK LIGHT AND POWER TRENDS Type Summary Date September-05 12 - month moving average Total % Total % of Avg Avg Avg # of accts KWH Growth Revenues Total Rev Rev/KWH KWH/Cust Rev/Cust Residential 7,256 3,759,156 0.8% $320,997 41% $0.0857 518 $44.24 Residential Demand 425 796,657 -0.7% $65,311 8% $0.0846 1,875 $153.73 Res Energy / Time of Day 221 384,736 -0.2% $21,359 3% $0.0572 1,749 $97.00 Res Basic Energy 10 13,408 2.7% $1,079 0% $0.0811 1,361 $109.10 Gen Serv Small 1,519 2,033,594 1.0% $173,767 22% $0.0855 1,338 $114.27 Gen Serv Large 88 2,767,032 0.8% $165,392 21% $0.0599 31,476 $1,882.64 GSL - Comml - Time of Day 1 10,435 1.9% $639 0% $0.0570 10,435 $639.43 GSS - Comml - Energy TOD 12 17,401 1.4% $1,064 0% $0.0613 1,455 $88.41 Municipal 61 250,257 -0.9% $18,716 2% $0.0747 4,142 $309.81 Outdoor Area Lighting 16 0 $186 0% N/A 0 $11.52 Wind Power 100 0 $2,090 0% N/A 0 $21.03 RMNP - Administrative 2 812 -13.4% $36 0% N/A 406 $17.92 RMNP - Small Admin 19 68,731 -0.4% $2,984 0% $0.0436 3,617 $157.07 RMNP - Large Admin 6 61,300 0.7% $2,305 0% $0.0381 10,217 $384.12 avg $775,927 100% annual revenues at this pace: $9,311,120 budget $9,393,999 projected over/under: ($82,879)
C CO 83 C 0 -5 22 CO J > 0 a 6b - 6b 6& -12> 4 66 4 2 8 600. 8 88 O 4 - - 0 3 3~ .-I. WK - between SenueAe] pa efoJ - (000'00*$) Variance between budgeted and projected revenues ($200,000) (000'009$) ¢ %00 ($100,000) -
& .0 0 am *fie 40%0 .... M 5 O 0.4 C~ en * O 8+EZZ m t- 00 M * U e.€9000 0-M en Go N N la M 1-eNNT-Ow 08 4 b 71 %§5§§*§ A. O 0000000 N 0000000 000 00 Z 0 .2 % 00 0 WO 0 N - Z UC. 21 2, - E ~ fi ~<% 8 4 - U 9 2 0 & 8 z ~ i ¤ 0 <0 ~ 2 0 = O m 40 19,41 ,Mil,22= i E { 9 2 6 .8 U 9 2 & 00 CO 0 i E 4-2 -2 3 1 i 3. 1 1 = F P e #0 U U *4 U O 3 5 g 3 - C. 2 #i I 0 gzu ag k = m 8- 60 0 0 + O W SEP VARIANCE Per Gal YTD YTD % ginning unr sable) fund balance 2,776,750 2,856,208 $79,459 $2,703,523 $2,703,523 100% 25,380 (25,380) 239,984 74% Other 3,984 1,196 (2 78 ) 57,270 68% 252,299 260,583 2,112,909 75% %ZL €Cd::11 42,320 64,771 (2,~1} 0 576,734 479 858 83% %00I I9t80£ I9Z'80£ IEI'69Z 646'HZ 00!Alos moa %69 LIL'59 0€9'+6 (8+L'6) 8*L'6 %99 IH'690'Z 96L'I€I'€ ZI90'0 II#00 (t€L'STZ) LZO'909 I60'9L£ %90I t'69'OZF'Z$ ILE'BLE'1$ (ZLD'OEIS) +65'0Z52$ L90'I 59'Z$ Bouvieq pmY (@Iqusn) pojoulsalun B MONTH TO DATE YEAR TO DATE 2005 of Budget ginning net assets t s - liabilities) $17,678,690 $18,024,386 $17,800,963 $ 17,800,963 214,287 259,387 45,100 0.0049 8 1,721,316 (8,648) 94,339 21 25,603 (25,582) 0 133,900 102 77% 9 +ES ZZI OH'+6I 00 '0 (080'90 9§I'ZZ 9L0'9 34,233 40,443 461,314 330 570 Ig EZE 596'8*5 (Z06'LI) 89¢Ok 9§'ZZ IFJOUOD pIle UOBBJUS! IL'69£'I Et+'5 I6'I (SZZ'88) Iti,'€6T 9Itd0I @suadxa 001]eumule}q pue uonaI@d0 /Got LE8'5ZE 29¢EI 8 (IBL'LID LOL'£EI 9Z6'5I 89£'£5 (ZGI'~ZO (159'IZZ) Rk¢§*£) (Z6L'EZI) (L61'9£2) V/N (IZL'II) 0£8'6 (I68'I) sollnos 101110 01 Poluoo[IU/POA!0001 4582) %99 (616'181) (Ed I'§ZE) (I £6'600 (t,I9'GEE) (£89'5ZI) 1*Ao sonuokolio Kou@!0!yop/ss@oxED Ielolq S WATER FUND
TOWN OF ESTES PARK WATER DEPARTMENT TRENDS Type Summary Date September-05 12 - month moving average Total % Total % of Avg Avg Avg # of accts Gal Growth Revenues Tot Revs Rev/Gal Gal/Cust Rev/Cust Urban Residential 2,568 11,771,946 3.3% $67,360 36% $0.011 4,586 $26.23 Urban Commercial 671 14,044,314 3.2% $48,963 27% $0.004 20,767 $72.38 Rural Residential 1,264 4,529,878 2.6% $48,686 26% $0.011 3,581 $38.51 Rural Commercial 94 1,832,166 -1.6% $10,699 6% $0.006 19,440 $113.64 Bulk Water 963,401 0.3% $8,898 5% $0.010 avg: $184,606 100% annual revenues at this pace: $2,215,277 budget $2,422,919 projected over/under: ($207,642)
1.0 0 LO 0 - 10 JO 0 ~ LO =0 C U.) (0 0 4 Variance between forecasted and budgeted revenues ($150,000)-- - Variance between forecasted and budgeted revenues -AON -des $0 ($50,000) - - ($100,000) (000,001$) (000'091$) (000'00£$) 1 1 (000'09£$)
MONTHLY PEAK DEMAND 26,500 - 24,500 22,500 ~ -0-2003 -0-2004 20,500 ---2005 18,500 16,500 14,500 12,500- 1 1 + + 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES 7 12,000 L- -11 T -7 6 a -g - m 4 hi 10,000 - # *- 4- 4 4 € .111 It} 11 7 0- 0- i{ 0% 4% -33 -Mi -11 \4 -1 -4 111 111 2 33 04 » *8 A il. 111 P E * 9 4% . 9 44 0 4 8,000 - 3%- ji- 33- 01- 2- 44- ,- 0_ ~_ 02003 tedh 2% 111 4 .4 m 2004 4 fi R % a A A *. $ 3 ~ a 2005 ** 01 0 55* P A & ~ 0 5 #_ 6 6,000 - tt-- 03%- 0- 9" 4- 61- ft- 04-- 5:1-- r~- 0 F ** St , 01 02 0% 64*8 *4 94 22 5% 0 0% 4,000 - A- *1- %*- 0*- 4- 3%- ft- A- fl- f- 0- f- 0 fit 34 94 111 111 44 /1 2* 44 51 *4 *i 4 11 111 *% A 4.4 %* 11 11 1 2,000 *1{ + 44 , *Rt , Sit , 4-3 , 4* , 3~, i /,h., 4.*, 4 , 4 , 4 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 Monthly MWH SYSTEM KW 9***aa\\\\\\\\\\\\\\\ 71:114
YTD ENERGY PURCHASES 120,000 .1.- -7 0 4, .li 100,000 7.-6- 41 It, Igs 0 0 % 80,000 .4- 4 0- 35 ~ 02003 92* 4 / 0.88% YTD 2005 VS 1 131 33 3 j % m 2004 %181 Mt 9 11 11 60,000 - 2004 *-- Ma- 4 - ~- 3-- * - 4 2 40,000 Imil -ill--Ill--~~~~11 1~ [~ ~I 0- 01 5- 4 .4 1 20,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD POWER COST vs. BUDGET ($1,000) ABUDGET ¤ACTUAL 5,000 4,500 4,000 70. ~ 3,500 All 3,000 -1 2 5% 2,500 "%@ % 2,000 1,500 1,000 500 «i 114'111 1 3 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 800 b 4 W - 7* e I. w X. *2 /4 4 7 4% 1% M - I 0 -* 7 5 /4 3 700 --- *B--5* -rt 73 3 3 5 1 T O 2003 A / ->. 1" 42 14 "4 -* 4% 7% i 02004 ti <4 15 42 -*5 -0* et :* -4 f f %:4 2% :9 *4 {2 +4 6* -> 600 - 4- li- 4 4 *5 ,6 ;2% 1% 52 4 m 2005 41 &* 14 1> iN 85 k¥ te > 9 *- S X 3 & 4 si £ I S.12 Z 500 - Ii- ft- $4- 4%- 15- 21- 31_ $1-~-- ti_ 1- - 03 %* 1 <A :* )% 5% 1: if 51 43 i %4 'A aw I 44 42 R# 40 25 04 4 '¥ &4 1, 1¢ R# 5& ti ,4 2% i , 6 300 ?*, 1-3, 1%., }2, is, lii , 1%-, 41 , k.2 , f , 6 i , 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 9.56% 2005 YTD VS 2004 6,000 I. r -t-74% ft f j 5,000 :4 4 4. 4 14 3 ' CZZ]2003 4,000 1 - 4 1,4 - ~ ~ - ~ 7% 4 : F 4 1 5 r='712004 -Al f * 3,000 -31 i~ - 1 - .1 1 - 5 ' 7--{ 1 0~ 2005 :f : <r 2,000 61- 4~ - 4 - ·49- ·41.1- .4 3-7 54* 4 2% E » A .1-1.-Budget h. 1% 4 .4 - 4 0 :1- ) _ i - .1- 4 4 T 1 1 1 1 1 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 4%0¥*#944 I.•e•.6.•A'47,•43*4,411.F•4,4,•e,F,¢4942'47·.
YTD September-05 Year-end Projected Water Rights Surplus With Actual Up To Date Monthly Use (AFt.) ill Ql (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 0) 125 (2) (3) 12 (4) 63 CBT 1211 @ 70%= 1090 0 122 (5) 968 TOTAL 1790 625 134 1031 Note 1: Ordered 200 of 300 Town owned Windy Gap Units ** Note 2: January YTD Projected use of WG = Glacier Creek projected use (994 af) multiplied by the Augmentation Plan YTD depletetion factor (0.102) * = 101 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 Released on 8/2/05 MacGregor Mountain Lodge 1 AF WG Units Released on 8/2/05 Continental Water Bank 8 AF WG Units Released on 8/2/05 Rod's Roads 2 AF WG Units Released on 8/2/05 12 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 2[1!X if ordered by April 1. Ordered all 242.2 af on 3/30/05 YTD September-05 Year-end Projected Water Use With Actual Up To Date Monthly Use (AFt.) 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.) (AFt.) (A.Ft.) (A.Ft.) (AFt.) (AFt.) 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 98 0 0 0 May 109 23 0.12 3 106 3 0 0 June 81 97 0.17 16 61 20 0 0 July 62 177 0.13 23 22 40 0 0 Aug 27 160 0.11 18 8 20 0 0 9-~t 0 178 0.10 18 1 0 0 0 4 0 114 0.08 9 0 0 0 TO-TAL 593 994** 101 488 125 0 0 September, YTD Projected Year-end Depletion Factor: 101/994 = 10.2% *
10/6/2005 Water Sales by Month ($) 350,000 300,000 7- 250,000 7 - 4-- 200,000 - 7- ¤2003 tt'* ¤2004 -7 / / *,, 150,000 -1, -7 ---- 02005 0,%-C - I I - 4 * , 1 4 S '' * 100,000 - 151- - , * 4 * 4 , 4 , I I 50,000 - *,** I,,, * 4, I O-3 -41: <1 <1 1 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 - - 92003 - - M2004 -7 - 1,500 M 2005 - --- - Budget / 1,000 - 4.71% 2005 YTD VS 2004 - - 'r- - 500 --- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 A\\\Unt Ii//\\\waxwl x\##A#lbr~ liixitiwaxtri»<i» wa\\1