The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2005-01-13U / CK UE AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE January 13, 2005, 8:00 a.m. Preparation date: 1/7/05 *Revision date: ACTION ITEMS Light & Power Department 1. Platte River Power Authority Medicine Bow Wind Farm â€¢ Request approval of a 10-year/annual power-use commitment for new turbine - Budgeted item (Presentation by John Bleem, Customer Services Manager, Platte River Power Authority) 2. Finance Department Copier Replacement . Budgeted item - Request to proceed with price solicitation Water Department: No action items. X 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 Office Memorandum To: Bill Linnane From: Richard E. Matzke 6-'16/0.A I)ate: January 12, 2005 Re: Platte River Medicine Bow Wind Farm Request to Participate in New Turbine BACKGROUND: In December 1999, the Town Board approved a twenty-year commitment to purchase one-quarter ofthe output of one wind turbine at Platte River's Medicine Bow Plant. This commitment was expected to equal approximately 40,000 kWh per month at $0.024 per kWh (in addition to wholesale cost) or $11,520 annually. In July 2000, the Town Board agreed to purchase 100 blocks (one block equals 100 kWhper month) ofthe Town's total wind energy purchases for use by the Municipal Building. Subsequently, the Town Board through the budget process for 2003 authorized providing 100% of the Municipal Building's electrical use from wind energy. In March 2003 the Municipal Building was placed on the Town's new wind energy surcharge. At the same time, the Town requested from Platte River a short-term energy purchase of an additional 41,000 kWH per month over and above the original 40,000 (estimated) kWh per month commitment. The short-term wind energy requests have been supplied through wind energy purchases by Platte River from other utilities. All wind energy purchases by the Town have been billed at $0.024 per kWh over and above the prevailing wholesale rate. Our current request for short-term wind energy expires March 31, 2005. Platte River is now installing a new wind turbine (Clipper) at the Medicine Bow Plant to serve additional wind energy requirements for the City of Fort Collins. All Platte River members have been offered the opportunity to participate, but Fort Collins is prepared to purchase the total output of the Clipper Turbine. This opportunity would allow Estes Park to transition the short-term wind energy purchases to an ongoing participation in the Clipper Project at the same price of $0.024 per kWh above wholesale. BUDGET/COST: The 2005 budget includes funding of $25,000 for wind energy purchases. The proposed purchase of 41,000 kWh per month from the Clipper project will have no impact in the 2005/2006 budget years. RECOMMENDATION: Staff recommends participation in the Clipper Turbine at Medicine Bow in the amount of 41,000 kWh per month at a cost of $0.024 per kWh for a ten-year period. This participation can be accomplished through a series of ten one-year agreements renewable annually. REM 1-1 Wind Energy: It's a breeze! / 1 - I . 0 - Â·Â·-, 0' 5 Â£ - VES,/5- Â·Â·,t .4 R> Another view of the Medicine Bow turbines. i./.Ii 'h' 1 4 -I.'-Ill'll'll, 43' 22 i 4Â¥ ~ I lu'V- i . 1 - di , C.23,4~. 0 041 : ....4 - 1---m----=-Il IL--- ..,- j _I-*.* :- Members of a tour group are dwarfed by the blades of a ... 1 , , turbine before they are liffed into place. Vt . 1 0 Piatte River Â· Power 4 . C. 44' . 1 Authority was ' and is a 9 ' 4 - pioneer in providing wind energy L 4, 1 1 3-. . to its ABOVE: PRPA promotes its wind energy .. program through this bookmark, 6 custorners. RIGHT: A tour group stands at the base . ...~ '' .Â»fle/.. ./ ..' -,~I' / .%2 -5. '-Â·* fil of one of the Vestas units. i or> 1.1.11- >m -0 B I LU 06 WIND ENERGY Estes Park - Light & Power Board SOOZ Aienuer lnÂ¥ 8 3MOd '1 Out ine . Existing Wind Products (Estes Park) . A New Option . Questions / Discussion LU 2 UÂ·46 t ..F ./: fri UnÂ»44 Â·ftÂ·. 427-F 4 NE BOW PLANT 1sj !3 alqeMDUUM lon Pold . . - . 0 - .. - ./ 'i'////~ke + 4.Fr. tl~ 11,2/969/'lle,/di::illillilitlimme .kE:191:115 4 I -11 14Â»..7. ' -- y, : 044)1Â·9%4'Â·p . ./.- I 1 hâ€¢ -I m /571,9, ~---~-=~~~~~~~~ i. --*I...IMIN.../I'll......Ill...................r.......,I......I-'-....3 4 . . . . . - 111 111 1,0 1 3 3 1 1 0 8 0 Kansas, 1 .%12 0Â· 2 2 Cok)rado â‚¬ 2 2 0 Sz 49 W L -12 12 Nebraska P > 0 0 13 -6 C Wyoming 09 *-6 2 . U' â€¢4 4-4 0 Use * 04 2 0,9 P * 3 Efo):-3 m 4, R. .9 0-/ 1-5 01 3 0% i LL :- -f! i %0 >,6 If. g0 Colorado Nav M, .â€¢t ..7 Utah , irizo 5 1 a -i.t : ' t.7 # '.1 44 . Wyoming c > ...1'iM- ./.+'. 1 - 0 #tr- ,>LM Waho .1/,0 9 1 r .. --1 11.2 0/4 1 *ZE:~viul&~ fil ~le bras ka Mec icine Bo Wind Droject S"SUCY ewoqel)10 1 151 71< , Ul .61 1 f BIO , ro O 11 2, O.0 N 0 > 02 11 . M -3 1-U 1-1 -7 . 031 10 2- - a, ---- 0 , 7 2 1- 91\ le,!1./. . 5. = \ --- 1 19 .-,te, a %- 0- =0 4 Â¥ Will au!qjnl auo Jo %SE <E ho Ul c 92 4- 0/ Vi X CL )4 25 23 1 U) 1 1 'J 1-0 IN I< 1 CD 1-0 I ro IR 1 CD ICE E-----I < #3 Mec icine Bow Proc uct a6ue40*3 Abial.13 P Energy WAPA System uo!1213U .. . . 0 4 . 1 1 4- ... 1-1. . . 3 ----~ , .at*~â€¢11...'/-1/< ~ - #-'*. lt.~ .-I. - 6- I t .e -, ' 1 ..in 1 - . :Â· t> ~~''ll//Tr /1/ 1 aL +T, *11 Â· 8 42~.â€¢ . .//JI.... 44/kp . ..6. 1 1 y k-Lk i k:r*4.-~ 1. . S 10 2~e- , a 0 0 %.80 (V .. 4 10 475 th 11 5 4. 0 52 Z. 2 2 850 & 1000 82 1000 O- 4, 00/ 55 2 0 %,07 el 3100 Â©08 - 3001 37 5 SOOu Ar- Purchase Site: . Stateline Project - 3 ap.loq 8 0/VAA UJ !21 >palo 1003 . AM - pafold "1. M. OZZZ E Q 0 L 2 c 92 4 - 2 X R :41 1 O U 1 00 1 ro U 1.- â€¢W C 09 1 U W iE u S * b.1 10 0 I CD 1-1- >0 0. .W 15 :cts U, 1~, â‚¬1, 1 â€¢W (A 1 > Ul 1 01 C L O I L g (10) Ill 1- -0 C < 20 Ca) Purclased Energy Procuct PRPA Oul /48)1000'I~ 01 401 ew . * MEDICINE BOW CLIPPER WIND TURBINE MaN alqeMauekl pnpoid 4 A a - .FÂ· ,%. Clipper (Medicine Bow) â€¢ Single 2.5 MW turbine â€¢ Developed with NREL â€¢ Owned by Clipper 33Uapadxa puui + leak Or â€¢ 9003 1IJ.Ie]N u! au!1-UOâ€¢ sluguoduuoi 'S'a 3600I â€¢ pulluoo asmI:und ieak-OI â€¢ le,01 1294?~PI 000'005'L- â€¢ 31.Ied Â§019 01 II?,131 000'3617 â€¢ V . 1 C \ r --Â» I .- < -:2 ~ u '~- L 1!4,4 â€¢, Â· -.,..4 C ipper (Mec icine Bow) "Next generation" wind turbine â€¢ 2.5 MW vs. 0.66 MW ~hhase 11 â€¢ 90 meter tower (vs. 50 meter) â€¢ Unique gearbox design â€¢ Variable speed technology uo!:le)01 lili aselld I < E - ~ ia 4 - d vi X R :22 0- 2,+ OU 1 00 1 ' 00 1 CD 1 41 J 'J If) : 22 1 CD 175 <E 1 B IC B & ~2 .0 1 > 1 0, c 0 .W 0 LO a â€¢W m (A 92 1 231 0 f----- I .L (0 LU Â© ~ ~ 4 ria 2 C 1, 0 N < a' 222 -1 ~ R (1 ..... C ipper (Mec icine Bow) 86ueuox3 Energy Vdkld su:P: saisj Seselwr~~1 ie - r IA.*. O 1-0 O LO O I - Al -i- 8 2 o g 8 8 0 190 0 0 0 0 0 NA/PI/$) um!1Uall[ 70910ua puIAA laddul aselpind MOg paIN Wind Product Premiums Same price as other products to Estes Park 000.0 . A new product is available . Supports a new turbine / technology . Replaces short-term purchases with a long-term renewable energy supply (sieaA-0 I) Alillqels aoud sepiAO.Id . sionpoid luanno se uumwaid alues . QUESTIONS? TOWN OF ESTES PARK Office Memorandum To: Bill Linnane From: Richard E. Matzke72&94 I)ate: January 12, 2005 Re: Finance Department Copier Replacement Request to Solicit Quotations BACKGROUND: Attached is a memorandum from Lorraine McCown providing the background information for the proposed copier replacement. The Finance Department is one of the highest volume users of copy equipment and the existing machine is at the end of its useful life. BUDGET/COST: The 2005 budget includes $15,000 for this purchase. Preliminary research by the Finance Department indicates this funding is adequate. RECOMMENDATION: Staffrequests authorization to proceed with solicitation of quotations and return to the Utilities Committee with a recommendation for purchase. REM 2-1 FINANCE NEEDS A COPIER The Finance Dept needs a new copier. We have survived on other Dept's hand me downs and now our machine is obsolete and repairs impossible. See attached copy of Minolta memorandum. The last time the repairman was here in November he did manage to fix it and guaranteed it through the end of 2004. We were down for a two week period while he was trying to find a part. We currently have the discard from Administration and I can honestly say that in the 16 years I have been in Finance we have never had a new machine. I would like to have approval to go out for bid and buy a machine as long as we meet the $15,000 cap that we were approved for in the 2005 budget. The amount of paperwork that Finance turns out is phenomenal. We would like a machine that is connected to the network so we can print from our PCs right to the copier. We also need a machine that can duplex, punch holes and staple. Currently, I have to use the Administration copier to duplex and produce the monthly statements. This job alone consists of 2,000 copies. This is inconvenient for that Dept as well as myself. We need a large capacity paper drawer, extra memory so I can print 500 page documents for the statement, an extra display that will work for Amy, a drawer that can be designated for utility deposit paper, one that can copy on disconnect notice heavier paper and the list goes on. We are currently using anywhere from 5,000 to 7,000 copies a month on our machine and would expect that number to rise to possibly 15,000 if we channel all our print jobs to a copier. We have been told that it costs approximately 10-15 cents a page to use a printer and 1 7-2 cents a page to use a copier. This is a large savings. We have been looking at machines and believe that we can find one that will more than meet our needs and fall within the $15,000 budgeted. I have spoken to the Fire Dept about their machine, called Harmony at the request of the Minolta repairman about the machine he would recommend, Laurie in L&P, and Betty Kildsdonk at the Museum. I am confident that we have our needs well defined and are ready to go to bid. I understand we need three bids. If approved, we will do our research and hopefully make the correct decision. Thank you for your time. J l , -bL.LaÂ£..u.j ,-F KONICA MINOLTA Bulletin SOLUTIONS & TECHNICAL SERVICES DIVISION Bulletin Number 1792 Date: 09/13/04 To: All Konica Minolta Dealers From: Service Support Subject: FINAL PRODUCT SUPPORT PUB: 018 SUPERSEDES BULLETIN DATED 02126103 The products listed below have either reached their final support date or will be in the near future. Also indicated is a final support date. If no date is shown, the product expired prior to 1999. Konica Minolta Corporation will discontinue supplying parts, pc drums, toner and starter on these products. Any item that backorders for these products will be canceled. The essentials of imaging Legacy Minolta Obsolete Models Model Obsolete Model Model Obsolete Model Date Code Date Code A-11 09/99 1204 EP2100/3120 Color U 01/03- 1248500 A-15 01/04 1227217 EP2120 12/01 1067 A-17 EP2121 12/01 1067366 AD-1 01/04 1249 EP2121D 12/01 1067366 AD-2 10/04 1281 EP2130 08/04 1132 AF-1 (PCW Autofeed) 09/99 4956 EP2130PRO 07/04 1132366 AF-15 10/04 122 EP2131 07/04 1132366 AF-2 10/04 1278 EP2150 12101 1066 AFR-1 01/04 1261 EP2151 1201 1066366 AFR-2 10/04 1262 EP2151D 12/01 1066366 AFR-3 10/04 1279 EP2152 08/04 1133 AFR-4 10/04 4416 - EP2152PRO 08/04 1133366 AFR-5 10/04 1284 EP270 09/99 1038 AFR-6 10/04 4434 EP270 Color Unit 03/00 1235 AFT-1 10/04 1365 EP300 09/99 0722 C-1500 09/99 1207613 EP300RE 09/99 1024 C-1500 A 09/99 1219 EP3050 12/04 1135 C-1500 C 09/99 1221 EP310 09/99 0721 C-2000 03/00 1230 EP3120 12/02 1057 C-2000 A 09/99 1225 EP3150 12/02 1057363 C-2000 M 09/99 1348 EP3170 12/02 1065 C-201 01/04 1257 EP3170 UPT 07/04 1288 C-202 10/04 1263 EP3190D 12/02 1080-64 C-203 12/01 1258 EP320 09/99 0723 C-204 10/04 1280 EP350 09/99 1030 C-204C 05/04 0914612 EP350 Color Unit 03/00 1222 C-205 10/04 4418 EP350Z 09/99 1028 C-221 4422400 EP370 09/99 1044 C-401 10/04 4404 EP370 Color Unit 09/99 1247 C-500 3 03/00 1231 EP370 Duplex Unit 09/99 1245 C-500 3A 09/99 1226 EP370Z 09/99 1045 Cabinet 10/04 0931375 EP370Z Duplexer 09/99 1245 CF80 12/02 1131 EP370Z DuplexinaUn 09/99 1245 1 -Fi n c. r, c N CR-1 09/99 4953 IEP4050 12/04 1134 1 ' C,u Trent- CR-2 09/99 4953613 EP410 Color Unit 09/00 1239 to pi e.-EL D-101 12/01 1267 EP410/415Z COLOR 03/00 1239 D-11 12/01 1208 EP410Z 03/00 1036 E-1 12/01 4424612 EP415/425Z Duplexin 09/99 1243 E-15 09/99 1244 EP415Z 09/99 1043 EP1080 04/04 1139 EP4210 12/02 1080 EP2050 08/04 1136 EP4230 12/01 1054 EP2100 12/02 1050 EP4233 05/04 1079 Page 1 of 3 Monday, September 13, 2004 r 1 Model Obsolete Model Model Obsolete Model Date Code Date Code EP425 09/99 1049 EW401 09/99 4924 EP425 Color Unit 03/00 1248400 EW501 09/99 4911 EP425Z 03/00 1049 F-11 09/99 1203 EP4300 12/02 1053 . FIERY 200I 08/04 4446 EP4300/4301 Color U 01/03 1248600 FN-1 12/02 1253613 EP4301 12/02 1053361 KY-1 09/99 4952 EP4320 12/01 1077 KY-2 09/99 4952613 EP4321 12/01 1077316 MC-1 12/01 1256 EP450 09/99 1023 MC-2 12/01 4412 EP450Z 09/99 1021 MF1000 12/01 0951 EP470 Color Unit 03/00 1232 MF150 09/99 4949 EP470Z 09/99 1033 MF151 06/02 4242 EP470Z Duplexing C 09/99 1238 MF161 12/01 4215 EP490 09/99 1046 MF170 03/00 4234 EP490 Color Unit 03/00 1248100 MF1700 11/04 4257 EP490Z 09/99 1046 MF180 09/99 4204 EP50 09/99 1035 MF1800 12/04 4272 EP50 Color Unit 12/01 1233 MF181 09/99 4209 EP520 09/99 0725 MF1900 12/04 4259 EP530 09/99 1025 MF210 12/01 4224 EP530R 09/99 0726 MF250 09/99 4940 EP530R1I 09/99 0726 MF2500 09/02 4241011 EP5320 12/02 1078 MF251 09/99 4927 EP5400 12/01 1052 MF261 12/01 4947 EP5401 12/01 1052316 MF3000 12/01 4231 EP5420 12/02 1076 MF3300 12/01 4241 EP550Z 09/99 1029 MF351 08/04 4256 EP570Z 03/00 1032 MF360 09/99 4209 EP570Z Color Unit 03/00 1246 MF3600 10/02 4261 EP6000 09/04 1075 MF361 09/99 4206 EP650Z 09/99 1022 MF380 12101 4225 EP710 09/99 0707 MF751 09/99 4921 EP8010 08/04 1145 MF761 09/99 4203 EP850 09/99 1041 MF771 09/99 4922 EP8600 12/02 1051 MF781 09/99 4939 EP8601 12/02 1051366 MF851 12/01 4218 EP8602 10/02 1129 MR-1 12/02 4422300 EP8603 10/02 1140 MTP-101 EP870 09/99 1031 MTP-102 09/99 EP870 Color Unit 09/99 1240 PCW-1 09/99 4902 EP9720 02/02 1130 PCW-2 09/99 4923 EP9760 12/02 1074 PCW-3 09/99 4915 EW201 09/99 4910 PPF1000 12/01 0951 EW251 09/99 4931 PT-1 09/99 0268 EW251 F 09/99 4925 PT-2 09/99 4960 Page 2 of 3 Monday, September 13,2004 Model Obsolete Model Model Obsolete Model Date Code Date Code R-17 RDH-1 12/02 1255612 S-10 Il 09/99 1205 S-10 Ill 09/99 1217 S-10 V 09/99 1205 S-10 VI 10/02 1228 S-10 VII 09/99 1237 S-10 Vlll 09/99 1241 S-101 01/04 1250 S-103 10/04 1290 S-2011 09/99 1206 S-20111 01/04 1229013 S-20 IV 09/99 1242 S-20 V 09/99 1224 S-20 VI 01/04 1236 S-201 01/04 1251 S-202 10/04 1265 S-203 10/04 1282 S-203C 10/04 1282652 S-204 10/04 4435 S-205 08/04 4429617 S20111 08/04 1229 SS-205 12/02 4422100 Stacker 09/04 0904 T-301 01/04 1259 T-302 10/04 1264 T-303 10/04 Â· 4419 T-311 08/04 1285 Page 3 of 3 Monday, September 13, 2004 Electric Financials.xls 1/12/2005 LIGHT AND POWER FOND 2003 VS. 2004 MONTH-TO-DATE CASH FLOW COMPARISON DECEMBER DECEMBER 2003 2004 Difference Revenues Utility Sales $ 694,267 $ 775,435 $ 81,168 Other 110,993 5,849 (105,143) Total Revenues $ 805,260 $ 781,285 $ (23,975) Expenditures Operation and Maintenance Expense Source of Supply $ 410,003 $ 469,319 $ 59,316 Distribution and Maintenance 147,710 79,947 (67,763) Customer Billing and Accounts 44,413 42,384 (2,029) Administration and General 118,676 45,805 (72,871) Transfer to Vehicle Fund 2,617 '4,240 1,624 Total Operation and Maintenance Expense $ 723,419 $ 641,696 $ (81,723) 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 Total Expenditures $ 865,823 $ 778,479 $ (87,344) Total Surplus (Deficiency) $ (60,563) $ 2,805 $ 63,368 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. R L&P 1 Electric Financials.xls 1/12/2005 LIGHT AND POWER FUND 2003 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON Dec. Dec. 2003 2004 Difference Revenues Utility Sales $ 7,944,245 $ 8,688,408 $ 744,164 Other 598,327 325,675 (272,652) Total Revenues 8,542,572 $ 9,014,083 $ 471,512 Expenditures Operation and Maintenance Expense Source of Supply $ 4,076,494 $ 4,285,939 $ 209,445 Distribution and Maintenance 1,389,256 1,410,615 21,359 Customer Billing and Accounts 585,491 611,955 26,465 Administration and General 1,095,244 1,034,500 (60,745) Transfer to Vehicle Fund 31,400 50,883 19,483 Total Operation and Maintenance Expense $ 7,177,885 $ 7,393,892 $ 216,008 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 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. R L&P 2 Electric Financials.xls 1/12/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 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 4 Â¥ 1 4 .1 1 , 4 1 0 4. 0% R. 1 4, r 1 0 1 . J r , 1 % t. Â£ S 14 I . 16 '0 4 Z I * 4 . t; *â€¢4 4 1 I . 4 1 *' 9 A A. i 1, ... L,f 4 I i 1. j *41 .;l =1,1. . 14.- * 4 4. $ . I /1 4 . * 21 4 04 0 , 1 t, )5 3.\ 4'r 1'. t 44 1 1 * C , C 3 % . ... & ... -0 .1 . 19 n. Al I. I . I . I '11 1 + 60 â€¢A A . M.@ 4*. 1 Â¥,1 2, , .- % *40*1- 1 4 0 4 %3- . . m. '. a . . it . 4, ** - O.4 I . 1 Â¥ 4 . I '. 1 .- . 4 Af 1 I.R. 1 :. 4 * . â‚¬C 6 63 4 7 0. 2, ~00 . 44 1 1% AAM *31SAS i Â£ . y * 30 ..' 46W jdV , Â¢ qe deS : 000* L. 20000 - - 1 %***8**888%22$9888$**888%***@S@8888@8888%%.it@jâ‚¬%88@888%814%8888*f)<Rt#PetS)*19& 1%8**Â§8%8*i**%68**9966%8*9**8%69**6$**3***%8*S9999%88***:** 1 1 ' 4.1.11:. 88?0~Â§46980*d#Wj#49::Ki#*YWRAWArrf#(WN/H/4///////Wh~ $$7*9%%$%$**5***Â§4%**&&4*%*%*Â§*Â§Â§Â§*sss*sm 3 , 1 44/3 @****%*9$8*0*%8888**@*Eje@%*f, (23%8%8~ U : 19**%*RE*Â§***%8%*****%18*X \ waâ€ž O c 1**6Â§8Â§*%8**Â§%28****Â§**BRAW#APS***36 t 1 1 2,44 9--9- 1%~8~:i:Mi#NO>)888*888*~ 0 FS#A~i**~*8**%*S*%8%68%*08%*%6$$33$***SS.'4â€ž,P Ji 1 '6 m ..1 -1 , 1%4%*$8%***%***%8*%*%*R**%83*$***3$8% 3 1 '0, 41~ 04171 13:'bakicisc##~fi~,rgic~~44#Ziâ€žVVY/:i,1â€ž*100â€ž, â€žâ€žFitrill~~Fr la ~ 88$888%88888*%%8888$8888888888888*8888**%%****59%*k >, ~ *SNS**Â§*Â§?*****$$$9***Â§**69*$6***Sk co i 1 11. 1 1*%****92.#,rl.,4,...f~%6..#C.~4(~*000Â§4%**e*Â§8 Y - 1.Jit,Flf='lit *$*8888&**8%88*8**8888*888*28****8%88888$888**8~ 1&*****%*%8%*%**SES*BiSMS*$Â§*%8Â§8*Â§*Â§8*%*%2 I.-Ilt-f,il"lillill:lillill ili~~ v *: Ug}'m 1 - --1 I HAAMI *14 luoIN Loadh99.xls 1/11/2005 8000 -- -- 02002 Â£001 0 *001 0 08G deS qe=1 MONTHLY ENERGY PURCHASES 2-d'91 hi 12000- - 10000-- --0009 0001 . I â€¢ N 09 1 9 -*000 4 , O 0 0 M N N Â¢ 3 4 I *116 10 Q ~ 0 0 0 . .. 4. .4- + 1 1 1 1 : t' ' Ae ,- I....#MSMEM.........:.:..................'SEM........EBBMe................dil............... 1 - 1&%**SM**:3****8%%8*Â§$Â§8**SMS*$8**%8%$Â§$**$*Â§8%8*SMS***:**S 1 Z. - -4 -I 1 Â¥. * *3 , 1 - .A. 4,4 * . 4 - 5 -41 t~*WIV~%12*EXIC~I<&qÂ£~i~69&96#165*#AI,- 331 . 0 0 N M 00 0-* 1 . ..- . 6 CO . 9 1 - 1 . , - 1 Ill , :14 1 64.41~ 58 1 % I 1 -0. 31 . 9 - 4 3 1 b. , 1 4 1 ........ â€¢~ ~)~~>~~~ E-REi-Â»>RRNRRx:>Â·50-'i.xgififfiffoRRÂ¥*E:r.:4 1 ' 9Â§23$$$$*RB****R*%8%8**********SM# 1 *41 4 1 F *7 ... 1 1 0 44, 1 . 4 0 0 4 4. . ~ 1 ,tu: Egr * a . '9 , . 'Â§Â§2Â§*2Â§~ 231 . , *- 1- 4 ' 17. Â¥ 1 :L 4 3 1 - 4 'ek r . 0 Â¥ .//0 y 4, I Ji . i., Â·41 , fime"K'*KÂ«<tÂ«<4*AAKVS***A~**4*Ag'*0 ... 1" F . Â£7 0 * 1 'EeEâ‚¬Eâ‚¬eEâ‚¬â‚¬â‚¬e202*Eâ‚¬eENEEâ‚¬â‚¬Â·Xâ‚¬ -I % ' litfUMUFF<%66/UfffkffiCIVe&66# @ - 1- . I /1 2 1 . 4 h 'I' I .k ..1 , , i .di?lt / 1 i 't. , . m i.1 03 1 i 1 . 4 t - i '.1 . 1 ./ . 1i NÂ©NÂ©**NÂ©NÂ©Â»Ne . 42 k -* -, * . I. 1 .. 1 ... L. I L. I D. ' imil- 29 % 4 tiA L 1 + 1 U.-f i I * . I I -,f , + .,111'my. C - (10 I -). ,+ , i 1 .% I : 4 P 1 0. Ag # 1 1 + 'CD ' e E 2 I k . i, f - 1 1 I t , C3) 1 91 4 Y 4 - 1 a : a .rk !~ . li *R 0 { r 1 i paselptnd HMW 01* 14 it 1 ' '{ 1 1 1 i 4 46 1 0 r r .- -' 4-t---- -.-1 1 - Loadh99.xls 1/11/2005 0?a - ENERGYPTUR 120000,- 8-d91 M 10000 -, j.* 00009 -' -0000f - 70000& , CO A, 0 0 $ 4 1 . . (N 36 Vl~/6/4 1 1 . . . . . ... ............ .......... . ... .... . .:1 * 1* * *liig.............2................ E- 0 1 1 i /.4 4 1 -~ .... W . - . / 0 .1 0 , 4 .4 1 . 4 ....... ... . ... .1 i * . , I. . .............................:1 ~ 1,@'9,24099;M~MI~// 67 ,O 0 - 4 ., 1. a I - 1 . . . 1 . . ....â€ž . . I . . .- .* 1% , . , 14 % I. Â»>Â»AkÂ»Â»>Â»Â»Â»iÂ»#4444444 821 1-++.++++4.+0+0++++++00.+0.++00+0: 4 1 . ' I . . i . Â¥ 1 ' r p@,2-,m@,migtm;Â«Â«Â«93,4 . 'i L 11. . , I . * A. 1 % I & ' 1 k * *:1;emmemÂ»$4444$44444//4*4 - ........ r 4, 1 , 5/2.4 .... ...'t ' 20 . . 4 1116 ...0 6 Â¥ 1 . t ....++++.++++++.+++++.: r.f . ...................... .4-0 4 42 Wk" *. , .41 & ul.- - It. 1 V. 4. p 'ti Mi~%%*AWiPhaMAPe~02292~;pe#~01 ....'............: C & ca . I 4 b 1 \4 0 1. 1 . 1 hiÂ¢. ., . . ~:::4'+ + '' + .4 ''' '+ ....4. FF' + F. ': *A.* I.T.... ? 5 1.- ~ 2 19;MA~**m*,1Â»Â»Â»49'UÂ« 5 i . 00 1 HUI 44 .6 .. h. 1 $ , %' 44 -1 1 -r- I.- 1- ....... ' T T i............***â€¢.â€¢â€¢.â€¢.â€¢â€¢â€¢â€¢â€¢â€¢â€¢...Â· 6- I. 9 F ' '* 1 'Fg~Ardrir.troadrifydrdri#*Â»0Â»* Â·~ 2, , 3.0 ' .p 6.'., t .i V . ../ . I & L ............................... F........... 4640.......AAAmmrÂ«EÂ· *'; 4. L ' 19~0~Ma~2~~4~&~~m ' I I ./ . 1 4. . ... ......................... .- I . . .........................Â·Â· .r# 2 4 /: I......Â·I.Iri,24**m@Ummm@00@U.$...: .F 1. U- **S . 9 1 ir, 1 ?16 I 0 r............................................ i * 1 / ' fr#*PR'YAFF/%*WAQ./ARIN<%%4NVI.V~< 4 4 1 Y Â¥ 1 9 1 . 1 1 ] 4 Â¥ 4 + 9. , 61 24 0 Or *- O . 0 8.8 C 1. 0 .8 0 0 0 O W O 6. 0 0, .; 0, 0- 0 + Et 0. 0. 0.. 0 N o 4 0 :2 24 , # *i 1 .r. I ($) SE~pVS A-IHINOW . -2-* , 1 1 ..4 1 Â¥ 4 4. -1 4 --4- - m. - . SALEHIST.XLS 1/10/2005 02002 Â«*001 ' des %6nv 6-d'81 hi & l.. . 0. 42.'. 12 2] 00 t. .5- -0 1. 6 I- 1 1 '.9 1 . (DI (1) . . /. ./ - . * I. *~ F 1,1 . 1, r, N M 91, ..0 ' :22 .r lee 00 20 *00,0Â©Â© 000 Boo g g 8 43 $ 00 90 00 0 4. 1 * kÂ»NÂ«~Â«r<'~Â«Â«FA< 4 At N co 02 Â»06Â¢Â»<94 + ~Â® 1, .L- r , ; .It .. 1, I + + 0- -61 @ F +11 D ./ In - . * txÂ»NXÂ»<Â»f\Â» rÂ».Â»9Â«Â»Â»0<Â»FÂ«NXÂ»Â»~.@ *-1 - :1 . . 2 1 Â·Â· L . -t A - 24, 1-,V,Vt';,uMLâ€ž-4.6*p-*75-2';.:-27*-*-,-d-d-4.,-4-#-dVWVd-d' ' 2* 4*..3 , 1 V ~ 1 * .* *. 1 . - 5 ' , 1 4 1. -I.-1-1.-------I...1.---/*----4 ?4 ' -3 *5:~.h.#.4Â«<1<1,~:,Atfp~:,~:bpyf/IXAAE*Ar.492.ghfbq<~f -/4 -' *1" - .t 4 f. 4 1.41 4 - Â£ 0 *. reesses $ ... . tÂ«\Â»pÂ»Â»Â»1Â»rk\N\22Â»kÂ» 3 2, P -1 4 L p 1. , 14 h , 4- 1: 6 - ----1-- 4 2 L ~lit>Â»Â©Â©24Â«Â»P#.4:#.41.1w:#.1,6r~2ho<Â»* 4 . * 1 A 5 114' . 10.O ./ =61 -flb/ * I & f: 6 i *rE-64#SA~STS'revned-eeee>rife,16 \1'Â«'60660Â©Â«,Â«.~.~.,~,~Â©, iii LU 00 * 8 .8 1 O. 1- 00 3 , . . * .1 + m -4 1 . . ~i, . 1- .~ * 1Â·eweeavE-Evees-6-ses-<re: 1 4 txÂ»<Â»fÂ»:fÂ»Nxv<Â«Â«'Â· .~ r . ) 1, < 1 ..4 4 . . 1 t * I i . IFT=*,7,7â€ž#&72-q,6.4-<r)-4- * I - P. , I ./6 6- B } Ar. ti 1, 4 4 . 0,1 4,4 r. e * . 19* .r 20 e : t -1 '* i : 'u/ E *.1 1~=Vt~EVPSVed t A Wr# + IPPX# 8 * . i<VfÂ»il:, GG = , 3,1 1 - *i>., , f. 4 , 3 1* . 11, * K Â· Â¢ *I R â€¢ Â¥ .4 .: . \000<%,0.,0,< ,,Â® # 1 1, 4 , 1 0 4 1 1 -I 4 X' 1 . 0 - .PÂ»1 1 4 , 1, . te . I . 4 - 9 . M) A ..o 0 . h CD . 0 . - r ~. ~ LU - e . 4% I \ 0 - 0 10- b Â¥ ./ O Ci *g 0 - 4 CD 0 Oâ€¢ t '-. -140 . <D $ td, 7) 4 4 / â€¢0* 'b . 1 n - 4 <It I . , m 1-3~3-WS-#,er,,& it- *O - 0 i ($) Sal,/9 31VCI 01 BÂ¥@IA Â©4 .Â· 6 t'*.0 ..it 2 4.. . 0 0 4 4 44, 1 1 0 1 0 M * . SALEHIST.XLS 1/10/2005 9.37% 2004 YTD * des: #inr unr 1 ubr OL-d91 hi TOWN YEAR TO DA E ~8,653,694 0,000,Pod' ' - 9,000,000 -,=,- - ,000,000 7,000,000 QÂ· 000'0002 * '.000'000'Z -Â¥--1-- QOO'000' L Water Financials.xls 1/12/2005 WATER FUND 2003 VS. 2004 MONTH-TO-DATE CASH FLOW COMPARISON DECEMBER DECEMBER 2003 2004 Difference Revenues Water Sales $ 142,776 $ 152,319 $ 9,544 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) Expenditures Operation and Maintenance Expense Source of Supply $ 9,899 $ -$ (9,899) Purification 39,910 22,688 (17,222) Distribution and Maintenance 61,810 42,607 (19,203) Customer Billing and Accounts 21,735 5,922 (15,813) Administration and General 7,990 24,304 16,314 Transfer to Vehicle Fund 396 1,167 771 Total Operation and Maintenance Expense $ 141,739 $ 96,687 $ (45,052) Debt Service 25,348 24,492 (857) Capital 20,021 - (20,021) Transfer to General Fund 6,199 6,199 Total Expenditures $ 187,108 $ 127,378 $ (59,731) 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 1/12/2005 WATER FUND 2003 VS. 2004 YEAR-TO-DATE CASH FLOW COMPARISON YTD YTD December December 2003 2004 Difference Revenues Water Sales $ 2,071,219 $ 2,162,614 $ 91,394 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) Expenditures Operation and Maintenance Expense Source of Supply $ 110,516 $ 125,698 $ 15,182 Purification 401,733 430,329 28,596 Distribution and Maintenance 486,478 554,524 68,046 Customer Billing and Accounts 203,483 195,420 (8,063) Administration and General 541,497 533,107 (8,390) Transfer to Vehicle Fund 4,750 14,000 9,250 Total Operation and Maintenance Expense $ 1,748,457 $ 1,853,078 $ 104,621 Debt Service 304,176 293,898 (10,278) Capital 1,129,612 413,622 (715,990) Transfer to General Fund 74,387 74,387 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 1/12/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% l 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 1 â‚¬ NN74*eebeeekÂ»xm 9,1,1,11,1,0#: 111 11, I 1 S - I. r Â«40/'ll./.Illilltilltill'dilld'i N#"111'#00#1/ 011# 1/0/6 1 - *7Â«*Â©Ne*eeeÂ©N*Â¢000Â©eeÂ« 13 '4##/%/1/#// // /#//##/#//2/5/#* 0 t At",0,""'4".4.4.4,4"4'"41,4,4""4",4,4",4"4,49<0 1 I ' KNoÂ»NeÂ©ee,p'"0"'j'"Â©4NeÂ©Â©04'N'"'.4.0 hÂ»*XMXÂ«MooxÂ«*eÂ©eeÂ©Â©0000 _ p........................................ 4 11 .. . 341111#11,1,1111110111*11,1,6 . 9 * 'T'Xe~NeÂ»Â»N.XX'. - ' AN,2-11-1111---'*r . f 4I V ................... .. *Â»Â»eaill/'Â»0Â©00/Ii i # I NxÂ©Â©Â©ONÂ©Â©4Â»XÂ«XeÂ»Â» 41,0,10#12#,21#11#24 ANieeÂ©eeÂ©NeeeÂ¢4"Ne Â»N#*'*"t#'*#ff##*25#* : 0 1 1 i / Sales.xls 1/11/2005 02002 Â£0010 - ' *001 0 oaa AON deS Bng nr unr XeIN Jdv Jel/\1 qe:1 uer Water Sales by Month 9Mhl 300,000 250,000 -Â·-- -- -- 000'00 L -- 000'09 200,000 + ~L~ ~~~ ~ ' -- - - ~*~xÂ«UÂ»Â»Â»rEÂ»Â»Â»0â€¢Â»Â»Â»Â»Â»Â» '140## 0 #g//// f #ff # #/#11### /# f *fi##/f f f f * N<Â«Â«Â«NXÂ»X\\Â»Ne<>axÂ»Â»XÂ»6Â»â€¢XÂ»XÂ» 1 ~Â»plÂ»xÂ»Â»Â»Â»xÂ»x veÂ¢4>0060 NI Illilli lilli lIllIlll1lIlllil01l. 1 1- 1 - ' 43/Â»li'ON<Â»Â»IÂ¢OXE e. 1, * 4 KNOÂ¢Â©00NNeÂ©eN<>NÂ«Â»Â»N~ 4,3â€ž,Â»Â»Â»Â» 44 4,1,1,0,1,11*01*11# 4 1=. ~ ~ ~ I#-ri'*Ir#'I L.1 ' 1 - , hÂ»x: /:0 ....3 W . . 9""""6 N 1 1 4 V.'.il, 1 * , 0 1 I. ./ y,ff. F r 4. oe Cl AON 100 aeS unV Inf unr Ael/\1 Jdv .lel/\1 qe=1 uer |000'/170'7%| ~2002 02003 ~2004 Budget