Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE APRIL 1, 2000
TO: FROM: COPIES: SUBJECT: DATE: 1 ) CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet Mike Roberto, City Manager . \ Chuck Warrington, Gas System Managing Director ~ Bill Horne, Assistant City Manager; Cyndie Goudeau, City Clerk; SBS Management Team; Janet Dorrough, Sr. Accountant/CGS; Tom Madley, Sr. Systems Analyst; Laura Damico, Sr. Accountant/CCS GAS ADJUSTMENTS EFFECTIVE APRIL 1, 2000 March 29,2000 It is that time of year when we re-compute our rate adjustment factors for the 2nd half of the fiscal year. The weather conditions across the Country this Fall/Winter are still unfavorable but have subsided slightly allowing us to recommend a drop in our Purchased Gas Adjustment rates. We are substantially under-recovered in our Energy Conservation Adjustment clause requiring us to increase these for the remainder of the year. We are recommending cutting our Environmental Imposition Adjustment for now as we are over- recovered in total and our costs have been substantially recovered for the year. We are not recommending the activation of the Weather Normalization Adjustment based on recorded weather to date. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after April 1, 2000: Natural Gas Firm Standard Rate Schedule PGA ....... $0.435 per therm (down 1.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.340 per therm (no change) Propane (LP) Gas Rate Schedule PGA .................... $0.770 per gallon (down 11.0C/gallon) = $0.842 per therm equivalent (down 12.0C/therm) Energy Conservation Adjustment (ECA) ............... $0.120 per therm (up 6.0C/therm) = $0.110 per gallon of LP (up 5.5C/gallon) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (down 1.0C/therm) = $0.000 per gallon of LP (down 0.9C/gallon) Weather Normalization Adjustment (WNA) .......... $0.000 per therm (no change) = $0.000 per gallon of LP (no change) 21-102 -( / iU ) ) 1 Mike Roberto, City Manager Page 2 March 29, 2000 Please note that the $1. 135/therm residential natural gas rate is an historic high. This is 4.0C/therm higher than our current rate and 2.5C/therm higher than our previous high of $1 .11 O/therm in January 1997. This is a direct result of the historically high energy supply rates nationally as seen most notably at the local gas stations. LP gas rates have subsided this month but are still at historic high levels relatively. Additionally, we are requesting that the Closed Metered Propane rates be extended beyond the April 15t cut-off date for those few LP customers who requested a transfer to a bulk delivery rate by the March 315t deadline but have not been converted yet due to workload. We anticipate that this transition will be completed within 30 days. Attachment #1 shows our Natural and Propane gas supply history, which our PGA rates are based on. Attachment #2 shows how the Natural Gas PGA and the non-standard differential are calculated. Attachment #3 shows our computation of the ECA. Attachment #4 shows the current status of the Adjustment clause balances. Please note that we are currently under-recovered by ($406,945), but this includes the positive EIA balance of $357,176. Therefore, PGA and ECA are under-recovered by ($764,121), which is a key factor bolstering our rates and is impacting negatively on our CGS Net Income. Page #3 shows that our current year recoveries have impacted our Net Income by ($300,195) fiscal year-to-date thru February. These adjustment clause recovery factors are designed to remedy this by year-end. It is our plan to use the above-proposed adjustments for billings through September 30, 2000, unless there is a significant change in our forecasts or we project an over/under recovery in excess of the thresholds as prescribed in our rate ordinance. We will continue to track these balances monthly, make monthly projections of these factors based on market conditions, and let you know if any of these get significantly out of balance. Mike, I would appreciate your approval of these revised adjustment rates so that we can get this information to CCS in order to make the appropriate adjustments in the billing formulas in time for the April 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments .1 Approved: Mike Roberto, City Manager U:\My Documents\MsOFFICE\WINWORD\GAsRATEs\Gas Adjustments for April 2000.doc t CLEARWATER FY99100 PURCHASED GAS COST PROJECTIONS AS OF Baled on Ac:tuIl DTH'. Sold 3/22/00 ;;rrlKH~N' -/ "";f'- I .1- L -- C-.ct c.paclly p.,- EquIY...... ReIInqulahed C......1Iy .... - Dollan P..... IN Conlnct Capeclly .... - _II A.I...bIe Clpoclly Per_ P..... III A.llllb1e C_1Iy .... - eo_ NNTS Per _ ProjIclH Sold p., Month 'IloLOIlof Purc~ 0.. Pul'C~ P.,- Sold Pit Month PGA_ CoIIIc:lMl - Oct... New'" Ole... .lIIMIO FIIMIO ....... Apr-tO ..,... Jun.OO JuI-tO Aug'" SIp-tO 231 376 41788 $ 125211.68) 119,274 0 15,500 154,890 131 685 1)4 000 4.20'Ilo11 .2,717.77 306,570 53 430 $ (763.26) 175,289 0 22.soo 184,711 ,'''_ 156,000 6.03'1lo1 $ 521.....1.35 316.789 55 211 S 174,_ 0 31.000 197,936 173,568 185.000 "'61'1lo $ 631,371.3' 316789 55211 $ (163.79) 146 602 0 46.soo 225,398 214.,.7 204,000 6.77'1lo $ m,HI.55 209 351 5164' $ (8,700.00) 58,445 0 43,500 202,555 210131 197.000 II '15"73.81 316789 55211 S 16,200.001 181,000 0 31,000 191,000 197,000 191 000 306 570 53 430 S (8 400.001 190.000 0 22,500 170.000 191,000 1 70,000 144212 41,788 S (23,268,601 35.000 0 12,400 151.000 170 000 151.000 1)9 560 40 440 S 122,518.001 36.000 0 10,500 144,000 151000 144 000 144212 41 788 S (23 268,601 47,000 0 10850 139,000 144.000 1)9,000 144212 41 788 S 123,268.601 47.000 0 10850 1)9,000 1)9.000 1)9.000 1)9 560 40 440 S 122,518.001 40,000 0 12.000 140.000 139 000 140.000 Tal.1 2,716,990 5n,174 ($164.280.5]) T.... R_ """.. IIIIolumu .... Month PtojIcl8d Tl"II1op. Ph... II Volumes Pet Month Projected NNTS Pha.. II VoIumH Pet_ T.... ReIetv-. """.. III Volumes .... Month 1,249,674 269,100 2,039,490 2,009,760 2.10'llo $ ],216.001.'7 Projecled Tllnlp. """..III VoIumH Pet Month Total Commodity Coal Pet Month C.C.PIlOll Fee Pet Month WACOG Pun:l1IIed Pet Month WACOG SoIcl Per Month load FIClOI SoIcl Gal T.... Biling (From PACE) Adjullmenls Pet Month Fuel Cost (Fuel Ratention) 0ct4I New'" Dee'" "."... FIIMIO ....... Apr-4lO "'.00 Jun'" JuI-tO Aug-GO SIp-tO $ .7 443.09 $ 5 366.68 $ '77.76 S 31,57].75 $ 1,108.05 $ ]87,906.49 $ 7.... $ 8,858.73 $ 2,710.58 $ ].13 $ ].41 ....0]'Ilo $ 485,507,ll S 115 362.29 $ 6,599.5] $ 1,]54.75 $ 41648.69 $ 1,074.72 $ "'5382.02 $ 159....) $ 12,434.13 $ ],231.44 $ ].49 $ ].42 41.22'1lo $ 64].920.50 $ 119207.70 $ 1,812.54 $ 1,609.17 $ 4],036.97 $ 4,662.31 $ 558,"6.87 $ 12.842.13) $ 14,98].19 $ ] 46]." $ ].65 $ ].,] 46.66'1lo $ 722,990.55 $ 111""".91 $ ",923.43 $ Un.26 S 4Z,9".76 $ ],144.82 $ 575,756.09 $ (19.]]) $ 14342.08 $ ],944.47 $ ].28 $ ].62 57.79'1lo S 740,.J72.17 $ 110.646.33 S 5 ]24.05 S 2,596.26 $ 40,208.75 $ 2,099.13 $ 5G6,456.62 $ (0.88) $ 15,475.02 $ 3.....71 S ].21 S . 8O.51'1lo $ 651.178.20 $ 118890.91 $ 5 893.24 $ 1 829.00 S 42 981.76 S 1,452.05 S 475037.24 $ 5 1).501.70 $ 3.342,50 5 3.31 $ 51.)4'1. 5 632,538.92 $ 115,055,72 S 5,059.14 S 1.)27,50 S 41,595,26 S 1.405.21 S 446.315.14 S S 12.660.39 S 2,975.00 S 3.51 S 47.22'1. S ~89361 S 54 122.76 S 4 739.80 $ 731.60 S 32,531.96 5 1.099.02 S 408.012.53 $ $ 11,576.20 5 2642.50 $ 3.1) S 81.18'1. $ 472,110.25 5 52 376.87 S 4494.50 $ 619.50 5 31.482.54 5 1,()('3.57 S 392.090.75 $ 5 11.125.67 $ 2,520.00 $ 3.15 S 80.00'1. 5 454,051,("1 5 54.122.76 5 4,219.00 5 640.15 5 32,531.96 5 1.099.02 $ 381,463.17 $ 5 10,826.64 S 2,432.50 5 3.20 $ 74.7)'1. 5 445,48944 $ 54,122.76 S 4.219.00 5 640,15 S 32,531.96 $ 1,099.02 S 384.326.29 5 5 10,909.76 $ 2,432.50 5 3.23 $ 74.73'1. 5 448.3525', S 52 376.87 $ 4,320.90 5 708.00 S 31.482.54 $ 1.()('3.57 S 387.834.66 S $ 11.009.18 5 2 450.00 5 3.21 $ 0.00'1. 5 449.884'.' $1,052,618.98 556.971.82 $ 15.726.80 5445.587.89 'N",e: Vol~ ate bHed on hlt.arical usqe iftd npected we~her. Fer IrarnpOf1.alion and fUl"1 r.let Me lwted on <<tu.1 ~ '" ,...ill,...... T~ numben represenl a besr Jook forward based on current dala. I f:\SUm'l'\WACOG1OOO.." S20.370.52 $5,389.697.86 152.914.34) $147.702.70 U5,691.08 5U06 56.95'1. S6,142,109.1l Average T 0111 P,ojKled DTH WACOG T 01,.1 Rnen~tion Tol~1 C Cost Sold 'S1 6 Mon'h. $88],894.08 52.9'12.613.57 $],876,507.66 1.075.760 53.604 2nd 6 Mon,h. $465,759.06 52,400,042.52 52,865,801.58 934,000 $3.068 TOTAL $ 1.349,65].14 $5,]92,656.09 ~~ 2.009,760 $3.35 Sold Wacog FYOO 8udgel 2078 $ 6,534,550.00 PO amounl 207,759.23 0\11' budget ..- ) I IfTr~-r IFI f' ~~ .L "p L I PROPANE INVENTORY ANO WElGH~D COST OF GAS (WACOG) I r--- PREPARED BY BRIAN LANGILLE ! ~ DA~ 03121100 i I + LP euppllecl by F......'gu & Te,,_ I -~ , 'D~ Contrac:t Ends 1C11311OO Ferrel1gas J. Scoll Hedge 544-1416 --_.. I Texaco : Joe Gump 881-920-"572 ! I I , , , i I , , I : Involee INVENTORY TANK COST OF GAlLONS DElIVERED DElIVERED TOTAL NEW , Number DA~ WITHDRAW INVENT. WACOG INVENT OElIVERED PRICE INVOICE GALLONS WACOG I 09130I99 27,1. 21.412 so.I4018 . 14,309.. - I I - I 0,54016 I Ferren, 196471 10/1<1199 36.002 $0.56255 $20,253.06 9,510 I 062493 I 5,94308 9,510 $0.56255 Ferrelli 196472 10/14/99 45.293 $0.57535 I 26,059.28 9,291 I o 62493 I 5,80622 18,801 $0,57535 Ferrel~ 196478 10/18/99 54.498 $0.58372 I 31.811.77 9,205 I 062493 I 5,75248 28,006 $0 58372 Month end 1 Cll31/11 30,719 23,779 SO.58372 . 13,180.31 10.58372 Ferrelli 196533 1 1/3/99 33,008 $0.59816 I 19,743.91 9,229 I 0.63534 I 5,&6355 37,235 SO.59816 Ferre., 196534 11/3/99 42,309 $0.60633 I 25.653.21 9,301 I 063534 I 5.90930 46,536 10.60633 Ferrell' 196562 11'11/99 51,557 SO.60839 I 31,36700 9,248 I 061784 I 5.713.78 55,784 SO 60839 Ferrell 196563 11111/99 80.715 $0.60982 I 37,025.18 9.158 I 061784 I 5,658 18 64,942 10.60982 Ferre/l' 196564 1 1/12199 69,916 SO 61087 $ 42,70992 9,201 I 061784 $ 5.6&4.75 74,143 SO.61 087 Ferrell, 196565 11112199 79,112 $061168 $ 48.391.58 9,196 I 061784 I 5.681.66 83,339 $0,61168 ! Month end 111301II 45,041 34,071 SO.811 II . 20,140.70 SO.61168 T.. , 88899 12J2199 43,074 $0.60314 $ 25.97964 9,003 I 0.56877 I 5,138.94 92,342 10.60314 Te. ; 88899 12J2199 52,374 SO 59739 $ 31,287.50 9,300 I 0.56877 I 5,30786 101,642 $0.59739 Tex 90303 12/16/99 61,875 $0.59214 $ 36.63862 9,501 I 056127 I 5,35113 111,143 $0.59214 Tex 90303 12/16/99 70,875 1O.S8848 I 41,708.55 9,000 $ 056127 I 5,069 93 120,143 $0.58848 Tex : 91472 12/22199 80,376 SO. 58875 $ 47.321.46 9,501 I 0.58877 I 5,61290 129.644 $0.58875 Te. , 91472 12/22199 89,877 $0.58896 I 52.934.36 9.501 $ 0.58877 $ 5,61290 139,145 SO 58896 Month end 12/31/11 51,812 3e,m $0.51111 . 22,536.73 SO.58816 Te. , 92156 01102JOO 47,266 $0 59359 $ 28,056.77 9,001 I 061127 I 5.520.04 148,146 SO.59359 Te. I 92218 01m31OO 56,268 SO.59674 $ 33,577.42 9.002 $ 0.61127 $ 5,52065 157,148 SO.59674 Tex ; 94160 01116/00 65,769 $0.60273 I 39,641.12 9,501 I 063627 I 6,06370 166,649 SO.60273 Te. ' 94160 01'16/00 74,770 SO 60702 $ 45,386.69 9,001 $ 063627 I 5,745 57 175,650 SO 60702 Te. 94440 01116100 83,771 $0.61172 $ 51.24427 9,001 I 064877 I 5,85758 184,651 SO 61 172 Month end 01/31JOO 50,590 33,111 $0.81172 . 20,217.43 SO.61172 T.. 96949 02/07/00 42,182 $0.66913 $ 28.225.24 9,001 $ 0.87877 S 7,927.81 193,652 $0.66913 FerreN' 336S 02J04/00 51.625 SO. 70467 $ 36,378.70 9,443 S 0.86344 $ 8.15348 203,095 SO 70467 Ferrell, 1614 O2J(f1/oo 61.121 SO.72934 $ 44.577.93 9.496 S o 86344 $ 8,199.23 212,591 SO.72934 Tex ' 98317 02114/00 70,124 SO.75199 $ 52,732.57 9,003 $ 090377 S 8,15464 221,594 $0.75199 Ferrell' 3498 021221OO 79,629 SO.76052 $ 60,559.37 9,505 I o 82344 S 7,826.80 231,099 SO.76052 Ferrell, 3499 021221OO 89,125 1II.781Zl $ 68,378.75 9,496 S 082344 S 7,81939 2410.595 SO. 76722 Month end 0212910O 53,218 35,906 r SO.78722' $ 27.541.91 SO.76722 ~ 03J07/110 35,906 S 27,96851 N1A N1A S 420.60 240,595 SO.77894 Te. u.. 031091OO 35,906 SO 77954 S 27,99005 N1A N1A S 21.54 240,595 SO. 77954 Ferrell 1717 03113/00 45,221 SO. 77571 $ 35.07821 9,315 S 0.76094 S 7,088 16 249,910 SO.77571 Ferrell 1722 03114/00 54,588 $0.76602 $ 41,924.92 9,367 $ 073094 $ 6,84671 259,277 SO,76802 1-1' e. ' 11798 03119/00 64,088 $0.74842 $ 47.964.73 9,500 I 0.63377 S 6,039 11 268,777 SO 74842 Tex ! 11933 03120/0O 73,217 SO. 73428 . 53.813.18 9,199 S 0.63377 S 5,848.45 277,976 SO.73428 , , . 1------' Total Gaftons M.. Inv. G.I. Tolal Gallons I WdI1chwn 231.181 .,177 Delivwed 217.918 S 187.160.80 , POLnds per Gal 3.696 Mea POLnds 99 332.18539 CSW:03!29!OO I PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 04/01/00 . 09/30/00 I ATTACHMENT #2 Page 1 of 2 I. Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible & Contract (Non.Standard) Rate Schedule PGA (See attached Page 2) II. Calculation of the Required Natural Gas PGA WACOG for FY 99/00 A. Therm Sales Projection for 1011/99 . 9/30/00 = B. Projected NG Reservation Cost 10/1/99 . 9/30/00 = $ Projected NG Commodity Cost 10/1/99 . 9/30/00 = $ Budgeted Other Supply Related Expenses = $ Total Recovery Needed for FY 99/00 only = $ Under Recovery of FYTD PGA thru 2/00= $ Total Annualized Recovery Needed for FY 99/00 = $ C. Required Weighted Average Recovery CostlTherm = $ 50.0% Standard = 50.00/-. Non.Standard = 100.0% 9,750,000 Therms @ 9,750,000 Therms @ 19,500,000 Therms D. Projected NG PGA Annual Revenue = III. Required Natural Gas PGA Billing Factors for 4/01/00.9/30/00 A. Required Standard Rate PGA Billing Factor for the Year B. Less Non.Standard Differential for Reservation Cost C. Required Non.Standard PGA Billing Factor = 19,500,000 1,350,000 5.400,000 570,000 7,320,000 235,000 7,555,000 0.387 $ $ ~ 0.435 0.340 Pinellas NG PGA = Pasco NG PGA = Total NG PGA = $0.095 = = Recovery $ 4,241,250 $ 3,315,000 $ 7,556,250 $ 6,913,237 $ 643,013 $ 7,556,250 $ $ 0.435 (0.095) $ 0.340 u:! chuck\e.c:el\sasrates\Psal q978..ls ATTACHMENT #2 Page 2 of 2 CSW:03/29/00 CLEARWATER GAS SYSTEM ANALYSIS Of STANDARD VS. NON-STANDARD THERMS & RESERVATION CHARGES fOR 3/1/99 - 2/28/00 -- Subtotal Subtotal Net Net Charge Per Charge Per Billing Total Interruptible " Contract " Non-Standard " Non- Standard " Reservation Standard Non-Interruptible M!ntb IIwmI IIwmI Interruptible IIwmI ~ IIwmi Standard III.mnI Standard ~ IIlm1 IIwm Mar 1999 1,941,026 365,444 IS.8% 491,288 25.3% 856,732 44.1% 1,084,294 55.9% $ 160,427.88 $ 0.148 $ 0.102 Aprl999 1,825,968 404,535 22.2% 446,785 24.5% 851,320 46.6% 974,648 53.4% $ 151,917.32 $ 0.156 $ 0.107 May 1999 1,512,748 354,709 23.4% 393,367 26.0% 748,076 49.5% 764,672 50.5% $ 85,694.71 $ 0.112 $ 0.074 Jun 1999 1,371,689 346,471 25.3% 355,371 25.9% 701,842 51.2% 669,847 48.8% $ 70,585.89 $ 0.105 $ 0.069 Jul 1999 1,279,166 327,733 25.6% 352,489 27,6% 680,222 53.2% 59S,944 46.8% $ 71,052.26 $ 0.119 $ 0.075 Aug 1999 1,252,452 309,288 24.7% 359,139 28.7% 668,427 53.4% 584,025 46.6% $ 64,447.49 $ 0.110 $ 0.068 Sep 1999 1,246,162 322,159 25.9% 352,833 28.3% 674,992 54.2% 571,170 45.8% $ 71,551.45 $ 0.125 $ 0.077 Oct 1999 1,316,848 312,916 23.8% 383,996 29.2% 696,912 52.9% 619,936 47.1% $ 100,449.03 $ 0.162 $ 0.100 Nov 1999 1,483,889 334,344 22.5% 429,635 29.0% 763,979 51.5% 719,910 48.5% $ 157,602.47 $ 0.219 $ 0.137 Oec 1999 1,735,679 304,560 17,5% 504,621 29.1% 809,181 46.6% 926,498 53.4% $ 164,073.68 $ 0.177 $ 0.115 Jan 2000 2,149,865 429,283 20.0% 570,405 26.5% 999,688 46.5% 1,150,177 53.5% $ 164,198.00 $ 0,143 $ 0.095 Feb 2000 2,101,308 394,146 18.8% 555,965 26,5% 950,111 45.2% 1,151,197 54.8% $ 144,751.34 $ 0.126 $ 0.085 Total 3/99-2/00 19,216,800 4,205.588 21.9% 5,195,894 27.0% 9,401,482 48.9% 9,815,318 51.1% $ 1,406.751.52 $ 0.143 $ 0.094 # for Comparison ~ TotaI9/98,S/99 17,933,041 4,111,960 22.9% 4,572,917 25.5% 8,063,911 45.0% 9,869,130 55.0% $ 1,452,274.71 $ 0.147 $ 0.105 Change 1,283,759 93.628 -1.0% 622.977 1.5% 1,337,571 4.0% (53,812) -4.0% $ (45,523.19) $ (0.004) $ (0.011) Note: # It is recommended that the 'Charge Per Non.lnterruptible Therm' differential be rounded to the nearest 0.5 cent or $0.095 for this semi.annual cycle. I I CSW:03/29/00 ATTACHMENT #3 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 4/01/00 - 9/30/00 I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 99/00 Budgeted ECA Requirements for FY 99/00 only = $ 668,000 Current FYTD 2/00 (Over) Under Recovery of ECA = $ 502,000 Total Annualized ECA Recovery Needed during FY 99/00 = $ 1,170,000 Projected Therm Sales for FY99/00 Applicable to ECA Recovery = 9,980,000 (Natural Gas @ 50% Standard = 9,750,000 therms & LP @ 50% Standard = 250,000 gal. or 9,980,000 Total Applicable Therms) Computed ECA Recovery Factor Necessary = $ 0.1172 Propose Rounding ECA Recovery Rate to $ 0.120 # Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 1,197,600 II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 99/00 Budgeted EIA Requirements for FY 99/00 only = Current FYTD 2/00 (Over) Under Recovery of EIA = Total Annualized EIA Recovery Needed during FY 99/00 = $ 100,000 $ (357,000) $ (257,000) We are over-recovered in ECA & project to stay over-recovered for the FY 98/99 period. Therefore, EIA needs to be = $ Round Proposed EIA Recovery Rate to $ Annual ECA Revenue Projection @ Proposed Recovery Rate = $ u:/chuck\excel\gasrates\eca1 h978.xls to Arrlk.lht1~,:- ~,... . CLEARWATER GAS SYSTEM . SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS [ . ~IGAS~GAS ! i Monthly Cumulative NG'PGA Budget ReservatIon Commodltv Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm Month Charges Charaes Expense Expenses EXPenses Billed (Shortaae) (Shortaae) i FlrmlContr Prior Vear 111 $ - $ 21,587.34 ; oct-99 $ 100,449.03 S 314,814.63 $ 29,518.69 $ 444,782.35 $ 462,757.77 $ 17,975.42 $ 39,562.76 NOV-99 $ 157,602.47 $ 379,330.86 $ 274,667.64 (2) $ 811,600.97 $ 528,442.35 $ (283,158.62 $ 243,595.86 : Dee-99 $ 164,073.68 $ 463,206.88 $ 1,217.98 $ 9,057.58 $ 637,556.10 $ 631.372.39 $ (6,183.71 $ 249,779.57 . Jan-OO $ 164,198.00 $ 605,949.94 $ 1,248.90 $ 26,581.70 $ 797,978.54 $ 777,955.55 $ (20,022.99 $ 269,802.56 Feb-OO $ 144.751.34 $ 541,492.54 $ 1 ,349.01 $ 92,781.81 (3) $ 780,374.70 $ 815,473.81 $ 35.099.11 $ 234,703.45 Mar-OO $ - $ - $ 234.703.45 ! ADr-OO $ - $ . $ 234,703.45 Mav-OO $ - $ - $ 234,703.45 Jun-OO $ - $ - $ 234,703.45 Jul-OO $ - $ - $ 234,703.45 I -- Aua-OO $ - $ - $ 234.703.45 ' Sep-OO $ - $ - $ 234,703.45 ~ Total YTD S 731,074.52 S 2,304,794.85 $ 3,815.89 $ 432,607.40 $ 3,472,292.66 $ 3,216,001.87 $ (256,290.79 I 1) Indudes WNA shortaae of (58.213.82) 2) Includes annual CCS charae of $186,200 & annual Adm fee of $63,800 , 3) Odorizers, FMNGA dues,CCS PGA ad] , AlC maint.. etc. , I I I I ! II D\ ftA!Ii D\ i Monthly Cumulative I LP PGA Budget Oanons MonthlY Interest Commodltv Total LP Fuel Total LP PGA Overage YTD Overage I ThermlGal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) Prior Year $ - $ - $ - $ - $ 15,979.51 . Oct.99 28.306.7 $ 0.54016 $ 79.90 $ 15,290.15 $ 24,880.04 $ 14,968.76 $ 9,911.28 $ 25,890.79 i Nov-99 32,549.3 $ 0.58372 $ 129.45 $ 18,999.68 $ 19,129.13 $ 17,901.56 $ 1,227.57 $ 27,118.37 Dec-99 40,667.6 $ 0.61168 $ 135.59 $ 24,875.56 $ 25,011.15 $ 22,366.65 $ 2,644.50 $ 29,762.87 Jan-OO 48,585.6 $ 0.58896 $ 148.81 $ 28,614.97 $ 28,763.79 $ 26,401.66 $ 2,362.13 $ 32,124.99 Feb-OO 54,638.0 $ 0.61172 $ 160.62 $ 33,423.16 $ 41 ,883.78 $ 46,655.43 $ 4,771.65 $ 27,353.35 ' Mar-OCl $ - $ - $ - $ 27,353.35 . -... Apr-OO $ - $ - $ - $ (27,353.35 : May-OO $ - $ - $ - $ (27,353.35 Jun-OO $ - $ - $ - $ 27,353.35 . Jul-OO $ - $ - $ - $ 27,353.35 I Aua-OO $ - $ - $ - $ 27,353.35 SelMlO $ - $ - $ - $ 27,353.35 ! Total YTD 204,747.20 $ 0.59197 $ 654.38 121,203.51 $ 139,667.90 $ 128,294.06 $ (11,373.84 I Cost Center Exoenses I . , . . . CCS Cha Adl at oar 5 fm 6,100 8,370.00 Software support 1140 (12x95) 1,140.00 I Admin fee & Fuel 8,000.00 Analog phone line for software 300.00 - 17,510.00 , A 1."I;AI Monthly I Cumulative 'I ECA Budget Coat Center Intel'Ht Total ECA TotalECA Overage YTD Overage . NGrrherm Month. Expense. Not8l1Exceptlon.lltem. Expense Expenses Billed (Shortage) (Shortage) I,PIGat Prior Year $ - $ - i$ 444,687.83 Qct-99 $ 27,901.00 $17.813 app/ ECA, Floal $2.500 $ 2,223.44 $ 30,124.44 $ 37,828.97 $ 7,704.53 $ 436,983.30 Nov-99 61 755.73 ees Cha, Admin Chg,$17607ADD1 $ 2,184.92 $ 63,940.65 $ 44,379.97 $ (19.560,68) $ 456.543.98 Oec-99 19.981.38 112911.02 Promo EXD $ 2282.72 $ 22,284.10 $ 57.134.47 $ 34.870.37 $ 421.673.61 ".now ............ ,.. I promo ICXP 1 2,108.37 $ 52,531.55 $ 70,746.23 $ 18,214.68 $ 403,458.92 Feb-OO 167.921.66 $132,349.27Conv&BIII A1owFY99$23000Prom $ 2,017.29 $ 169,938.95 $ 71,333.84 $ (98.605.11 ) $ 502.064.04 . Mar-OO $ - $ - $ 502.064.04 i Apr:.oo $ - $ - $ 502,064.04 May-OO $ - $ - $ 502.064.04 i Jun-OO $ - $ - $ 502.064.04 ' Jul-OO $ - $ - $ 502,064.04 Aug-OO $ - $ - $ 502,064.04 . Sep.OO $ - $ - $ 502.064.04 . TotalYTD $ 327,982.95 $ 10.816.74 $ 338,799.69 $ 281.423.48 $ (57,376.21 ) - ~ ....n. ~ : Monthly Cumulative I EIA Budget Cost Center Intel'Ht Total EIA Total EIA Overage YTD Overage : NGlTherm Month Expenaes Notes/Exceptlonallterna Expen.e Expenses Billed (Shortage) , (Shortage) LP/Gat , I Prior Year $ - $ - $ - .$ 332.330.64 Oct-99 $ 85.00 $ - $ 85.00 $ 6,303.53 $ 6.218.53 $ 338.549.17 ! Nov-99 $ 6.~.00 Admin Chg $ - $ 6,400.00 $ 7,396.52 $ 996.52 $ 339.545.69 I Dec-99 $ 984.95 $ - $ 984.95 $ 9,522.13 $ 8,537.18 $ 348,082.87 j Jan-OO $ 13,482.10 Environ Consultant $ - $ 13,482.10 $ 11,778.14 $ (1.703.96) $ 346.378.91 i Feb-QO $ 1.090.05 $ - $ 1,090.05 $ 11,887.25 $ 10,797.20 $ 357,176.11 i ! Mar-OO $ - $ - $ - $ - $ 357.176.11 Aor:.oo $ - $ . $ - $ - $ 357.176.11 May-oO $ - $ - $ - $ - $ 357,176.11 Jun-OO $ - $ - $ - $ - $ 357,176.11 I Jul-OO $ - $ - $ - $ - $ 357.176.11 , -, Aua-QO $ - $ - $ - $ - $ 357.176.11 I Sep-O() $ - $ - $ - $ 357,176.11 : Sep-99 $ - $ - $ - $ 357,176.11 i TotalYTD $ 22,042.10 $ - $ 22.042.10 $ 46,887.57 $ 24,845.47 : , I I , . - . AffAc.f'hIt..Ni" ... t. Page 2 ,4-T1~m€,J, 4 _/RNh PnA. + I=r.A +I=IA\ . Monthly Cumulative Total Budget Total All Total Recovery Overaae YTD Overaae ' All Thenn Month ExDenses Billed (Shortaae) . . (Shortaae) NGILP Prior Year $ - $ - $ - $ 1106,749.36 . Oct-99 $ 499,871.83 $ 521,859.03 $ 21,987.20 ' $ (84,762.16 ! Nov-99 $ 901,070.75 $ 598,120.40 $ (302,950.35) $ 387,712.5111 Dec-99 $ 685.816.30 $ 720,395.64 $ 34,579.34 $ 353,133.17 · Jen-OO $ 892,755.98 $ 886,681.58 $ u(5,874.40) $ 359,007.57 , Feb-OO $ 993,287.49 $ 945.350.33 $ (47,937.16) $ 406,944.73 ! Mar..QO S - $ - S - $ 406,944.73 ADr..QO $ - $ - $ - $ 406,944.73 ! Mav..QO $ - $ - $ - $ 406,944.73 : Jun-OO $ - $ - S - S 406,944.73 i Jul-OO $ - $ - S - $ 406.944.73) Aua-OO $ - $ - $ - $ 406,944.73 Sep.()O $ - $ - ;a,oo" $ 406,944.73 i TotalYTD $ 3,972,802.35 $ 3,672,606.98 rs (300,195.37) ''-- - -- , Monthly Cumulative WNA Budaet Interest Overage YTD Overaae i NGlThenn Month LP Gallons Exoense Rate/Gallon NG Therms RatelThenn (Shortage) (Shortaae) I LP/Gal IBaa. Bal. $ - I Oct-99 $ - $ - Nov-99 $ - $ - Deo-99 $ - $ - I Jan-OO $ - $ - , Feb-OO $ - 1 Mar-OO $ - .$ - Aor-OO $ - $ - I May-OO $ - $ - : Jun-OO $ - $ - Jul-OO $ - ,$ - Aug-()() $ - $ - SelH)O $ - -, Total YTD - - - S - I .. I , Page 3 U :\windowslmsofficelexcel\gas19( sheet recovery) CSW:03/29/00 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Enenrv Chanre/Therm Non.Fuel EnerllY Charge EnerllY Conservation Adj, (ECA) Environmental Imposition Adj. (EIA) Weather Normalization Adj. (WNA) Total Non-Fuel Enercy Charge Purchased Gas Adjustment (PGA) Total Energy Charge/Therm Minimum Monthly Bill Compares to LP/Gallon Rate of with 6,0% Franchise Change from 9/99 Therm Rate Utility Taz Note: Fuel Rate per Therm 10/0117 3 Non.Utility Taxable Fuel/Therm --BL NA (1. 3 Units) $0.580 0.120 ..Il4L NA (4 + Units) $7.00 $15,00 ....MML NA (4 + Units) $20,00 $0.580 0.120 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR APRIL I, 2000 - SEPTEMBER 30. 2000 BASED ON APPROVED GAS ADJUSTMENT FACTORS .JJ4E... NA(4 + Units) $50,00 $0.580 0.000 0,000 0.000 0.000 0.120 $0.580 0.120 Q.QQQ Q.QQQ QJlOO QJlOO $0.700 $0.700 $0.700 $0.700 $1.135 o..u5 o..u5 o..u5 o..u5 $1.135 $7,00 $1.135 $15,00 $1.135 $20,00 $50.00 Firm Natural G.. Rate Schedul.. ..BL J.MlL ..JJ1L ~ $15.00 O. 18,000. 100,000 NA (1 . NA (0 . 17,999 99,999 & up 3 Units) 149 tons) ~ $20.00 $0,470 $0,410 $50,00 $0,350 $0.470 $0.905 $50.00 $7.00 if $15.00 if not prey. not prey, billed billed $0.200 0.120 0.120 $0,150 0.120 0.000 QJlOO $0,270 M3.5 $0.705 ~ NA (150 tons & +) $15.00 if not prey. billed $0.100 0.120 0.000 Q.QQQ $0.220 o..u5 $0,655 $7.00 @ $15,00 @ $15.00 @ premise premise premise $15.00 $0.200 QJlOO $0.320 M3.5 $0.755 $15.00 + FAC -1.L... SL w/M& flml&b1 NA NA ~ Interr. lilLBISI ..JIW.... ---1I- NA $25.00 NA 100,000 & up $100.00 $0.470 0.120 0.000 Q.QQQ $0.590 o..u5 $0,280 NA NA Q.QQQ $0.280 l2.MQ $1.025 $0.620 $25.00 $100.00 + FAC + Non.Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.039 $ 1.039 $ 1.039 $ 1.039 $ 0.938 $ 0.883 $ 0.828 $ 0,691 $ 0,645 $ 0.599 $ 0.691 $ 0,782 $ 0.599 $ 0,938 $ 0.567 $ 1.101 $ 1.101 $ 1.101 $ 1.101 $ 0.994 $ 0,936 $ 0.878 $ 0.732 $ 0.684 $ 0.635 $ 0.732 $ 0,829 $ 0,635 $ 0.994 $ 0.601 $ 0,055 $ 0.055 $ 0,055 $ 0,055 $ 0.055 $ 0.055 $ 0.055 $ 0.055 $ 0,055 $ 0,055 $ 0.055 $ 0,055 $ 0.055 $ 0.055 $ 0.020 $0.069 $0.069 $0.069 $0,069 $0.366 $0.366 $0,366 $0,366 BTU FACTOR = THERMS/l00 CUBIC FEET teen Firm Service Rates Interruptible Service Rates 1.052 .1QL9.2 .llL9.9 .lZL22 lULQl2 1.047 1.031 1.049 1.029 1.051 1.031 1. 026 0,120 0,120 0.000 0.000 Q.QQQ Q.QQQ $0.590 $0.530 o..u5 M3.5 $1.025 $0.965 $15.00 $20.00 $0.069 $0.069 $0,366 $0.366 QZLQQ QJLQQ 1.049 1.049 1. 028 1. 028 $0.069 $0,366 lMLQQ 1.047 1.027 0,000 0,000 QJlOO Q.QQQ $0.320 o..u5 o..u5 $0.755 $0.069 $0.366 Q5LQQ $0.069 $0.366 Q2LQQ $0,069 $0.366 QZLQ.Q $0.069 $0,366 llaLQQ $15.00 $7 Resl.l $15 GS if not prev. billed $0,300 $0.100 0,120 0.120 0.120 0.000 0.000 0.000 QJlOO Q.QQQ $0.420 $0.220 M3.5 o..u5 $0.855 $0,655 $15.00 $7 Resl.l + FAC $15 GS @ premise + FAC $0.069 $0.069 $0,366 $0,366 Q9LQQ $0069 $0.366 $0,055 $0.285 ATTACHMENT !IlI5 Contract lilLBISI -'HL NA By Contract- By Contract NA NA Q.QQQ Contract + $0.000 Plus l2.MQ $0.340 + Non.Fuel Customer Charge + Non.Fuel Therm Rate for Contract # of Therms -\ $ 0.020 $0,069 $0.271 CSW:03/29/00 ATTACHMENT #6 Page 1 of 3 BTU Factor: 2.ZH Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: ~ Therms/100 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS (NEW CUST. EFF. 3/8/99) Therm Factor: ~ Therms/Gallon FOR APRIL 1, 2000 - SEPTEMBER 30, 2000 BASED ON APPROVED GAS ADJUSTMENT FACTORS Contract LP Svc. RLP MLP GLP LLP LPV LPS CLP Applicable Annual Gallon Range NA NA o - 2,500 Gallons 2,501 Gallons & Up NA NA NA or Other Rate Determinant (1 . 3 Units) (4 + Units) ~ - Monthly Customer Charge $7,00 $15,00 $15.00 $20.00 $7.00 Res!. or $25.00 Set By Contract $15.00 GS if not Non-Fuel Enern CharJel/Gallon: prevo billed @ premise Non-Fuel Energy Charge /Gallon $1.400 $1.400 $0.200 $0.150 $0.100 $0.390 Set By Contract Energy Conservation Adj./Gallon 0.110 0.110 0.110 0.110 0.110 0.110 NA Environm'llmposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj./Gallon Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ MOO Total Non-Fuel Charges/Gallon $1.510 $1.510 $0.310 $0,260 $0.210 $0.500 By Contract + $0.000 Purchased Gas Adjustment/Gallon Q,llQ Q,llQ Q,llQ Q,llQ Q,llQ Q,llQ Q.llQ Total Energy Charges/Gallon $2.280 $2,280 $1.080 $1.030 $0.980 $1.270 $0.770 ~\ + Contract NF . Minimum Monthly Bill $7.00 $15.00 $15.00 $20.00 Any Applicable $25.00 Customer Charge + Customer Charge Non.Fuel Energy Chg. + Any Applicable for the Contracted Facility Charges # of Gallons/Mo. Utilitv Tax Note: Fuel Rate per Therm 10/01/73 0.161 0.161 0.161 0,161 0.161 0.161 0,161 , , CSW:03/29/00 ATTACHMENT #6 Page 2 of 3 BTU Factor: 2.lH Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: ~ Therms/100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: ~ Therms/Gallon FOR APRIL 1, 2000. SEPTEMBER 30, 2000 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARDRESIDENnALLPSER~CE WILL CALL SPLASH - PREPAID COMMERCIAL CONTRACT Il.BLf1 II8In II81n ~ IIBr&I.f IIBr&I.f IlIW!Lf1 IlIW!Lf1 El8lleIn El8lleIn ~ GIn kLf -- Appltc.ble Annuel Gdxl R8Ilge 0-60 60.1-120 120.1 - 300 > 300 0-300 > 300 0-200 >200 0-400 >400 o - 2500 > 2500 NA or Other Rille Delennln8nt 1-3 UNITS 1-3 UNITS 1.3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annu8I CUllom... Cherge S 84.00 S 60.00 S 48.00 S 36.00 S 36.00 NA S 36.00 NA S 36.00 NA S 60.00 $ 60.00 Sel by cont,ect Non-FueI En"",,, ~IIIGeIIGn' Non-Fuel Energy Ch8rgeIGallon S 1.300 S 1150 S 0,700 S 0.800 S 0.700 $ 0,600 $ 0.600 $ 0.500 S 0.500 S 0.500 S 0.200 S 0.150 Set By Contrect Energy Con_Ion Adj.lGal1on 0.110 0.110 0.110 0.110 0.110 0.110 0.110 0110 0.110 0.110 0.110 0.110 NA Environm'llmposnlon Adj.lGaIIon - - - - - - - - - NA Weather Normalization Adj.1G811on - - - - - Q.QQQ - - ToteI Non-Fuel ChargnlGellon S 1.410 S 1.280 S 0.110 S 0.710 S 0.110 $ 0.710 $ 0.710 $ 0.110 S 0.110 $ 0.110 S 0.310 $ 0.280 Set By Contract + 0.000 PurchaHd Gal AdjullmenVGal10n 0.770 0.770 ~ 0.770 0.770 ~ 0.770 0.770 0.770 0.770 0.770 0.770 Q.Wl Total Enargy ChargulGaUon S 2.110 $ 2.030 S 1.580 S 1.410 S 1.180 $ 1.480 S 1.480 S 1.380 $ 1.380 $ 1.380 S 1.080 $ 1.030 0.770 + Contract NFE -, Note: No Monthly Minimum Bill Utilltv Tax Note: Fuel Rate per Therm 10/01/73 0.161 0.161 0,161 0.161 0.161 0,161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non.Utility Taxable Fuel/Therm 0.609 0.609 0.609 0.609 0.609 0.609 0.609 0.609 0.609 0.609 0.609 0.609 0.609 CSW:03/29/00 BTU Factor: BTU Factor: Therm Factor: .2.l.H Gallons/100 cubic feet (CCF) 2A83 Therms/100 cubic feet (CCF) Q..2l5 Therms/GaUon CLEARWATER GAS SYSTEM CLOSED METERED PROPANE (lP) RATE BilLING FACTORS (THRU 3/31/2000) FOR APRil 1, 2000 . FINAL ACCOUNT CONVERSION * BASED ON APPROVED GAS ADJUSTMENT FACTORS (* This Rate is Only Applicable for Customer Conversion Requests Stili in Process by CGS) ATTACHMENT #6 Page 3 of 3 Contract lP Svc. RlP.C MlP.C GlP.C llP.C lPV-C lPS.C ClP.C Applicable Annual Gallon Range NA NA o . 2,499 Gallons 2,500 Gallons & Up NA NA NA or Other Rate Determinant (1 . 3 Units) (4 + Units) Monthly Customer Charge $7.00 $15.00 $15.00 $20.00 $7.00 Resl. or $25.00 Set By Contract $15.00 GS if not - Non-Fuel EnerI,Y Chartes/Gallon: prevo billed @ premise Non.Fuel Energy Charge /Gallon $0.750 $0.750 $0.390 $0.320 $0.100 $0,390 Set By Contract Energy Conservation Adj. /Gallon 0.110 0.110 0.110 0.110 0.110 0.110 NA Environm'llmposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q,QQQ Total Non-Fuel Charges/Gallon $0.860 SO,860 $0.500 $0.430 $0.210 $0.500 Set By Contract + $0.000 Purchased Gas Adjustment/Gallon Q.ZZQ Q.ZZQ Q.ZZQ QllQ Q.llQ Q.llQ Q.llQ Total Energy Charges/Gallon $1.630 $1.630 $1.270 $1.200 $0,980 $1.270 $0.770 + Contract NFE - Minimum Monthly Bill $7.00 $15.00 $15.00 $20,00 Any Applicable $25.00 Customer Charge + Customer Charge Non.Fuel Energy Chg. + Any Applicable for the Contracted Facility Charges # of Gallons/Mo. Utility Tax Note: Fuel Rate per Therm 10/01/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non.Utility Taxable Fuel/Therm $0.609 $0,609 $0.609 $0.609 $0.609 $0.609 $0.609