The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2006-03-164 If AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE 8 a.m. Thursday, March 16, 2006 Preparation date: 3/9/06 *Revision date: ACTION ITEMS Light & Power Department 1. Finance Department Invoice Machine â€¢ Request to purchase budgeted item Water Department No action items REPORTS Light and Power 1. Light & Power Financial Reports Water 1. Water Department Financial Reports Note: The Utilities Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared. hp LaserJet 3015 -0 f HP LASERJET FAX invent Mar-14-2006 9:45AM Fax Call Report Job Date Time Type Identification Duration Pages Result 307 3/14/2006 9:40:29AM Send 5869561 0:37 1 OK 308 3/14/2006 9:41:11AM Send 5869532 0:47 1 OK 309 3/14/2006 9:42:03AM Send 5861691 0:52 1 OK 310 3/14/2006 9:43:01AM Send 6353677 1:00 1 OK 311 3/14/2006 9:44:06AM Send 5771590 0:56 1 OK 9, K Finance/Light & Power Memo To: Utilities Committee, Town Administrator Repola From: Steve McFarland, Finance Officer Date: 3/14/2006 Re: Replacement of folding/inserting machine Background: The Neopost SI 72 Folding/Inserting machine (aka "Elvira") was purchased in 2000. Its primary purpose was/is to provide reliable folding and inserting of the electric and water bills, at the rate of approximately 10,000 per month. Of late, "Elvira" has developed problems associated with the normal wear and tear of having produced 500-600,000 folds/inserts. The problems are manifested through mutilated documents and frequent jams and breakdowns. Elvira is obsolete, and parts are not easy to come by. When Elvira breaks down, a Neopost representative has to travel to Estes, diagnose the problem, and try to locate parts. This jeopardizes the timeliness and efficiency of our billing cycle. Budget We have two direct quotes to replace Elvira, and a third "outside the box" option. The funds are available in the Light and Power Fund under line item # 502-7001- 580.33-33 (Data Processing Equipment). Under this line item, there is a subcategory entitled "clicl<2gov", which is an on-line payment software. We are not going to be purchasing click2gov; therefore. funding for this item can be had from said source ($20,235 available). 1. Pitnev Bowes Dl-400 Fast Pac Inserting System. Cycle speed: 3,500 pieces per hour. Cost: $7,193 (50% discount from retail). Maintenance contract: $1,263/yr. No trade in allowance, so we would keep Elvira as a backup unit. Brochures available. Machine provided on Tuesday (March 14, 2006) to do sample "run". 2. Complete mailing solutions - Neopost S168 EZ Mailer 3. Cycle speed: 2,750 pieces per hour. Cost: $11,470. Maintenance contract: $1,695/yr. Trade in allowance: 1 yr free maintenance. 1 4 -1 , a. Price reduced to $9,402 in March 3,2006, re-bid. 3. Outsourcing. We have entertained bids to outsource the entire billing process. The average cost of this endeavor would be approximately $17,000. At this time, we are not prepared to advise outsourcing. It is an alternative that could prove beneficial in the future, and as such, should probably be re- considered during future budget processes. Action: Staff requests permission to purchase a Pitney Bowes Dl -400 Fast Pac inserting System at the cost listed above. â€¢ Page 2 MARCH LIGHT & POWER FINANCIAL REPORTS MONTHLY PEAK DEMAND 26,500 - 24,500 22,500 ~ -0-200 ---2005 20,500 ~ -0- 2006 18,500 16,500 14,500 12,500 - , + , t Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES 12,000 -* d% A #rE '7- fl 0% 4 10,000 -A 91 - - 2 Y r PA /5 2 43 55.4 2 f Â¢ N 43 04 2 41 4 94 2 4% 2 /4 4 & 4 F :4 m 41 Â£ i A 4 8 2004 8,000 -%4 -5 i 4 <> 4 9% *3 4% 4 4% 2322 33 , ~li 82005 4% 2 4 3 34 3-4 A 02006 6,000 -35:4 -40 4% 2 011 88 4.% 0 1 66 R 3% 0. I %3 #4 . it 7,1 ; 3Â§ *2 4 04 0* 14 $4 93 /3 3% 54-0 3% 41 # ': 52 4% 4,000 -53 -34 k---fe V'- - 4% 34 4# Ft *4 4% 4% m #" 0" gaR %" m A 3.4 %" 31% 9& 42 .0 22 0% M =4 3=4 2- 9% 2,000 Â¢Â§ ,42 , 4, , 3:g 1431 16% r 3% 111 1%4 1 , 1 5-3 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 47$2582$6 2Â»99221 E#+CÂ«Â«<Crf'Fr,;WIC<FCÂ«Ft 1444*lit<((Â«22*Â«44 %3323.33333333*li ~~AÂ«Â«Â«##PA~~A~Â«Â«Â«Â«<icit~4% \~N\\\\\\\\\\N Â»Ne>NÂ« Â»\\\\\NA\\\Â»***21 b b \Â»3033 AA"&,BM,0,~iri \NININ.N.NÂ« 449.Â¢1414"Yn!1+1~T ..+A' 40*mÂ·- ~9438'4Â·'iÂ·Â£464 *~86:181'' P~ ~ â€¢ t YTD ENERGY PURCHASES 120,000 100,000 . 43 O 3 * % E 7 43 # 9 80,000 - 4.54% YTD 2006 VS 4 ICL 'rA / w m 2004 2005 .r- 1 -. 8. 4 21 1- / + 1 r- 1 -4. # @13 E @20 m 2005 60,000 02006 Â»1 4-2 0 1 20 42 PE U 52 40,000 . 111 37 0 2 5% 5* 40 8. a %1: 0 3% 64: 20,000 521Â§ 4% diji $0! 43 f Ill 3-1 ME #ii 04 P : 4: A mi 4,: 2 %3, m m *1. %mi 1 i I I I I i I I I Jan YTD POWER COST vs. BUDGET ($1,000) MBUDGET Â¤ACTUAL 5,000 4,500 2 4,000 F m W** 3,500 q%%3 3,000 2,500 7 2,000 1,500 - 4 2%44 1,000 - 500 - / * lili Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 YTD MWH Purchased 1922*litttartual< ELECTRIC SALES BY MONTH ($1,000) 1,200 1,100 1,000-- 900 --=. - -t r 8 2 - â€ž 02004 800 -Â§5 -4 Â·v .* ~C M 2005 9 -D F :/ 9 700 -ti -43 2 Sâ€¢ .... 0 $ ... ': .Ak ,~ '4 j /, 1 - 02006 KE lit :U 9 2 1% (F 7. E 600 -54 -lit " 14 42 32 21: ?2 0 e . , 4 G 3 3 . CE 1% e 53 RE k> &i f } 5 4 IF{ : fi k. 13 53 39 59 500 -24 4 -22 1 X â‚¬ 44 4 *i< 3& -4 93 3 6 9 * f =u + c it- S I Â·f* 0. ~6 I 6 4 -*2 15% 3 3% 23 2,4 14 y 4 {* te j * 1 & 400 -f W -2 9 14 4. 61 2: S I . I . 4 2& em (A }F 'i: at .2 8 Â¢ 4 f* 1- r .4 tt 300 4 1 , 32 , 41 , *13 , 30 , 42 , ,Â£ , C * , fÂ¥ , 432 , 6-2 , 3% , Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR TO DATE ELECTRIC SALES ($1,000) 10,000 10,138,000 9,000 - 17.46% 2006 YTD 1 8,000 VS 2005 7,000-- CZE]2004 - ff- 6,000-- r=m 2005 - 5,000-- 0 2006 51 : : 23~ 3, 3% 5, 7lk /li Â· 1 .,U 7 , 4,000 -- -Budget -Il- I 1 /- VE 5; Ji ...1 J -, 4. .1 / â€¢ j Â¥ I d le J qi ./. 3,000 4, F -- J. - - < 0 i 1 2 I , 1 4 10 .4, / n I / / 41 1 ' 01 7 1 4 %4 4: 4 %PC 1, 1,000 -24, .1 < 1 -4 9 , 4 Â¥ 'i ~/ I. .0, .1 '<1'11 il :/ * 4 1 .4 3 1 3 /0.1 O PHI I, Of 52 1 0 3, 4 ..4 lili /~ P4 44 /1 Illl111I1l Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 8 YEAR TO DATE SALES MONTHLY SALES Mi,NOIS>Â·629 IE Â· ....<1 51: .< : 444:lf.1:, %%' th' ./.'. 'l l . TOWN OF ESTES PARK LIGHT AND POWER TRENDS Type Summary Date February-06 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,289 3,789,013 0.2% $334,059 42% $0.0885 519 $45.78 Residential Demand 415 772,744 -0.1% $65,675 8% $0.0885 1,868 $158.73 Res Energy / Time of Day 225 396,661 1.4% $23,307 3% $0.0603 1,755 $103.13 Res Basic Energy 11 16,048 3.0% $1,318 0% $0.0832 1,428 $117.30 Res Time of Day 5 5,859 33.1% $167 0% #DIV/0! #DIV/0! #DIV/0! Gen Serv Small 1,551 2,033,867 -0.1% $177,775 22% $0.0875 1,311 $114.62 Gen Serv Large 90 2,773,160 0.1% $168,045 21% $0.0608 30,813 $1,868.42 GSL - Comml - Time of Day 1 10,455 0.6% $722 0% $0.0682 10,455 $722.30 GSS-Comml-Energy TOD 13 17,114 -1.1% $1,120 0% $0.0659 1,326 $86.72 Municipal 61 251,848 0.0% $19,273 2% $0.0765 4,130 $316.04 Outdoor Area Lighting 16 0 $200 0% N/A 0 $12.49 Wind Power 173 0 $2,090 0% N/A 0 $19.55 RMNP - Administrative 2 862 0.0% $39 0% NA 431 $19.66 RMNP - Small Admin 19 65,638 -1.0% $2,956 0% $0.0451 3,455 $155.60 RMNP - Large Admin 6 63,202 1.2% $2,526 0% $0.0403 10,534 $421.00 avg $799,274 100% annual revenues at this pace: $9,591,293 budget $9,741,005 projected over/under: I ($149,712) C CO (D 01) Â¤) a) 90-AoN - 90-des - 90-Inf - go-Xel/\1 - go-Jevy 0/1 - 90-uer -90-AON -90-des - 90-Inf - go-Xevy - 90-JeIN go-uer ($300,000) nce between SenueAeJ palo (000,00*$) Variance between budgeted and projected revenues 2006 $0 ($100,000) ($200,000) (000'009$) (000'009$) (000'002$) - FEBRUARY LIGHT & POWER FINANCIAL REPORTS MONTHLY PEAK DEMAND 26,500 - 24,500 22,500 ~tl -0- 2004 -*-2005 20,500 ~ ~ ~ -0-2006 18,500 16,500 14,500 12,500- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec MONTHLY ENERGY PURCHASES 12,000 -~N- 44 - 0 - 4% 45 N 73. 10,000 -#t ~4 3 1 34 I -- 7 - I / f 021 0 3% 36 2 3 0 7- 1 r /,731 1 02 & 04 ~ I 4 4 X /n *R 04 5% :i /3 8,000 -04 34 4.0 1 4 2 0 8 4 02004 #-2 4 94 6 27 i; 22 E A U /-4 n 2-9 0 2005 /1 33 01 Mt 2% A i..' 3 *f m , 9% 4 2 it 1 i 1 -04 43% 24 11 - C, 02006 4 5 4 33 14 % .44 5% 44 6,000 - , ' . I 4 86% 04 Â» / 09 *4 34: 83 2 2 2 1 41 53 43 :. 4 5% Ff MEI A /1. 4,000 - 1 2 51 3% ~ 4% 355 ~ 0 81: 4.34 i >1 01 0% 3:{ 31 'i 0% Rk *3 4# 52 4% 9% 4./ I 3. . 44 9* 32 43; 2 3.% 6% 46& ..4 *li %% 49 2,000 4, ' 0% 1 *31- 1 92Â¢ t â‚¬: 1 2% 1 4-2- '43% 12 , 32 1 2 14 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 6 ?514<4 i<**NottE{*t 44#tks \NON<1 kuitiâ‚¬ b\\\\\NARAWWM\Na\\\AANK \/ t t 'Fj :11 j W-#*Â¢49*I'ly' NA:/1+(Ut#*. NX\\\<22,# 2\ Â«\\\\ ix ujibxdi \2*,NÂ©0~:~ 3999% 44\ Â»1 **a\\\Â»Noa Â» Ne**Â»N<***\ \ \ H \06Â¢A Â» \\ YTD ENERGY PURCHASES 120,000 7 d:S /: 100,000 4* 9* r - -/. r 44 4 N #M 2% g 4 4 80,000 - 3.86% YTD 2006 VS llÂ®% el C A 2004 2 ZE 4-:: / 2 :$22 2005 60,000 it MN 0 4 0 m2005 252*E 02006 48 0. 40,000 - 94-*-- 20,000 #a~ #1. # f *8: d: 92 i fli 3 5% 584 23: 44 4-3- 413 k : 44_ â‚¬4 Jan YTD POWER COST vs. BUDGET ($1,000) BBUDGET Â¤ACTUAL 5,000 4,500 4,000 W r 4 3,500 r 1 3,000 tr 2,500 2,000 : 3 1,500 & 0% 1,000 500 ER. 4 6 * 8. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec R L&P 7 -t:Wilam~ mmimmli |**Si2248*28KfS?28 YTD MWH Purchased *Nuff 222"4222Â¢1*fÂ¢ffÂ¢ MARCH WATER FINANCIAL REPORTS 3/13/2006 Water Sales by Month ($) 350,000 300,000 250,000 - 7 5 5 -5 -5 200,000 h -4 7- V Â¤2004 11/ I / / 02005 ** I 150,000 - ' 4 ''' 1, I 100,000 - ~ 416 / /55 0 1 *'' * I 50,000 - *'' 4 *,1 I O 4 3 5,1-,- 5 - 71 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Water Sales Year-To-Date ($1,000) 2,500 $2,128,000 2,000 -5 / 7, '' , M 2005 / 3 4 1,500 M2006 -- 1, 11 -Budget , 1,000-- 8.93% 2006 YTD VS 2005 - A- 6- 3- : 55% , ,1 f 1 '' 500 - '- 4- 5- - 1-- 5- , . rtil [i[1 l I , 1, I '' Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 L\\\\\\\\\\\\\\\\\\\\\\\\\\\ ml-L"': ./\\\\\\\\\\\\\\\\\\\\\\\ 1.11\\% MÂ»xx\'1 TOWN OF ESTES PARK WATER DEPARTMENT TRENDS Type Summary Date February-06 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,577 12,566,542 -0.4% $70,985 37% $0.006 4,877 $27.54 Urban Commercial 698 13,220,495 -0.2% $49,346 26% $0.004 18,964 $70.75 Rural Residential 1,272 4,511,979 -0.5% $49,617 26% $0.012 3,549 $39.02 Rural Commercial 96 1,852,731 -0.5% $10,959 6% $0.006 19,406 $114.62 Bulk Water 945,085 -1.8% $9,515 5% $0.012 avg: $190,422 100% annual revenues at this pace: $2,285,060 budget $2,137,800 projected over/under: I $147,260 0- <92 (447 L (50 -6 \ -0 < - Mo,t e N - 40.*4 \- - 91- > 441 6, - 40 < 01 1 04Â©4 0000000000 0000000000 00-4 O 0-0.0.0 000-0- 5000 0 00 0 0 + 00 0 91- N O 00 0 4- N 9- r- 1- 1- p- 64646468 64 64 64 6464 10 A CO - /9 1- CO N 0 4- m tO O CD - CD 1.0 09 N Al N to 0 m N CD 01 01 CO. 01 n (1 41 N. Q Q (N. 00. N. * O 0 4- - CD (9 00 00 09 0 00 N CO Lo LD N te M A r N M to CO 4- â‚¬4 64 64 64 64 64 64 69 â‚¬4 64 10 10 10 10 1.0 10 LO 1.0 10 1.0 10 ID CD CD CO (O 0 (D Â© CO <0 (D CO Â© 99999 999990000000099999 %32*21 ~ lfA33*4~&4#4 *f#83&; Variance between forecasted and budgeted revenues - Water -Variance between forecasted ~ and budgeted revenues ~2006 | $31,291 FEBRUARY WATER FINANCIAL REPORTS .. 2/10/2006 Water Sales by Month ($) 350,000 300,000 250,000 7 7 # 1 *** ** 200,000 Â¤2004 , t- 1 , / / 02005 5 5 150,000 - Â¤2006 I,, 01* I ,,,, t , 4 + ***,, * 1 4 4 50,000 **,** ''*** 1 10 ** O , E _.1_ h. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Water Sales Year-To-Date ($1,000) 2,500 $2,128,000 2,000 -5 M2004 M 2005 -/ 7 3 3 1,500 M2006 -7535 -Budget g 3- 0 1,000 - 9.23% 2006 YTD VS 2005 1- I 7 1 1 , 1 , 1 - U-- / 500 0 rÂ·01 IM 1 11 '' 4 , '13111*1- , 1 13 Il- 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RW5 All\N\\I/\Ill\. *....2....L...2#.'w ...1.....L