Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1997
,. -. ~ I , CLEARWATER GAS SYSTEM Interoffice Co"espondence Sheet TO: Betty Deptula, City Manager FROM: Chuck Warrington, Gas System Managing Director COPIES: Kathy Rice, Deputy City Manager; Cyndie Goudeau, City Clerk; Margie Simmons, Finance Director; John Scott, Asst. Director Finance/UCS; Tom Madley, Senior Accountant/UCS; Karen Miles, Accounting Manager; CGS Management Team SUBJECT: GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1997 DATE: March 22, 1997 After experiencing the highest run-up this winter in gas supply pnclng since the supply shortages of the 1970s, we are seeing some continuing relief for the third month in pricing forecasts for both natural and propane (LP) gas. This means that we can now significantly lower our Purchased Gas Adjustment (PGA) gas supply prices for our customers. Attachment #1 shows our current projections of the effect of lowering our Natural Gas PGA factors by another 5C per therm (after lowering it by 5C per therm over the past 2 months) which would equate to another 10.4% PGA decrease for our firm natural gas customers. Attachment #1 also shows our current projections of the effect of lowering our Propane (LP) Gas PGA by another 13C per gallon (after lowering it by 1 2 (: per gallon over the past 2 months) which would equate to another 17.8% PGA decrease for our LP customers. These rates are still about 10% higher than historical levels which we hope to return to within the next year. We do not propose to make any changes in our Environmental Imposition Adjustment (EIA) clause rate at this time as our costs are running reasonably in line with our earlier projections. We are though recommending a 1 C per therm decrease in our Energy Conservation Adjustment (ECA) clause rate as we are now running positive on this recovery. Ai (.." ,.\ , I / .., ' '. J (..'/ /,'" I. , ~~ 1 I Betty Deptula, City Manager Page 2 March 22, 1997 Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after April 1, 1997: Natural Gas Firm Standard Rate Schedule PGA ....... $0.430 per therm (down 5C) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.310 per therm (down 5.7C) Propane (LP) Gas Rate Schedule PGA .................... $0.600 per gallon (down 13C) = $0.656 per therm equivalent (down 14.2C) Energy Conservation Adjustment (ECA) ............... $0.030 per therm (down 1 C) = $0.027 per gallon of LP Environmental Imposition Adjustment (EIA) ......... $0.015 per therm (no change) = $0.014 per gallon of LP Weather Normalization Adjustment (WNA) .......... Not Applicable at this time Attachment #2 shows our derivation of the Natural Gas PGA adjustment and the difference between the Standard and Non-Standard PGA rates. Attachment #3 shows the history of Propane (LP) prices for the fiscal year. Finally, Attachments #4 and #5 show the impact of these PGA and ECA rate decreases on our overall natural gas and LP rates, respectively. It is our plan to use the above proposed adjustments for billings through September 30, 1997, 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. We will also continue to provide you with a summary of our adjustment status as a part of our monthly financial statements. ) I Betty Deptula, City Manager Page 3 March 22, 1997 Finally, I would remind you that the winter has thusfar been very mild which will likely result in poorer than projected Non-Fuel Energy Revenues and earnings. This will likely kick in the Weather Normalization Adjustment (WNA), if our Heating Degree Days fall 10% short of the 10 year average. We will be able to confirm this as early as late April; therefore, we will likely recommend an implementation of this adjustment for the May - September (or maybe December) billing cycles so that we can spread the effect of this over 5 - 8 months to lessen the rate impact. My very rough estimate of the impact of this is about $200,000 which would require a WNA of about 3 - 4C per thermo Hopefully we can offset this by slightly lowering the PGA rates (as MGAF is working diligently to reduce our commodity and reservation costs for the summer) and potentially by a slight reduction in the ECA and/or EIA adjustment rates. Betty, I would appreciate your approval of these revised PGA rates so that we can get this information to UCS 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 /cw Attachments Approved: a-~ Be~ep ~~, City Manager - CSW:03/22197 I I I -, '.1 f2 . CLEARWATER GAS SYSTEM . SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS I I I , NA ruRAL GAS PURCHASED GAS ADJUSTMENT fPGA-NG) Monthly : Cunvnulative NG PGA Budget Reservation Convnodlty Cost Center Total NG Fuel Total NG PGA Overage I YTD Overage RatelTherm Month Charges Charges Expenses Expenses Billed (Shortage) i (Shortage) Firm/Contr Prior Year - $ - $ - :$ (172,741.06) Oct-96 $ 124,594.00 $ 233,422.38 $10,369.95 $ 368,386.33 $ 384,494.16 $ 16,107.83 ' $ (156,633.23) .380/.267 Nov-96 $ 170,385.78 $ 290,744.88 16,079.30 $ 477,209.96 $ 443,000.55 $ (34,209.41 r $ (190,842.64) .390/.277 Dec-96 $ 179,288.40 $ 457,290.06 8,285.59 $ 644,864.05 $ 532,745.16 $(112,118.89)i $ (302,961.53) .390/.277 Jan-97 $ 179,551.86 $ 727,198.21 4,853.98 $ 911,604.05 $ 920,292.04 $ 8,687.99 I $ (294,273.54) .530/.417 Feb-97 $ 162,141.51 $ 628,500.10 30,720.03 $ 821,361.64 $ 790,952.42 $ (30,409.22) J $ (324,682.76) .500/.387 Mar-97 $ 202,500.00 $ 575,000.00 10,000.00 $ 787,500.00 $ 792,720.00 $ 5,220.00 . S (319,462.76) .480/.367 Apr-97 $ 196,000.00 $ 425,000.00 10,000.00 $ 631,000.00 $ 615,330.00 $ (15,670.00) S (335,132.76) .430/.310 May-97 $ 105,000.00 $ 350,000.00 10,000.00 $ 465,000.00 $ 532,125.00 $ 67,125.00 $ (268,007.76) .430/.310 Jun-97 $ 102,000.00 $ 300,000.00 10,000.00 $ 412,000.00 $ 503,100.00 $ 91,100.00 . $ (176,907.76) .430/.310 Jul-97 $ 105,000.00 $ 280,000.00 10,000.00 $ 395,000.00 $ 477,945.00 $ 82,945.00 i $ (93,962.76) .430/.310 Aug-97 $ 105,000.00 $ 275,000.00 10,000.00 $ 390,000.00 $ 476,010.00 $ 86,010.00 ! $ (7,952.76) .430/.310 ~ L 102.000.00 L275.oo0.00 10,000.00 $ 387,000.00 $ 485.685.00 L 98 685 00 i $ 90.732.24 .430/.310 TotalYTD $1,733,461.55 $ 4,817,155.63 140,308.85 $ 6,690,926.03 $ 6,954,399.33 $ 263,473.30 : I PROPANE flP) GAS PURCHASED GAS ADJUSTMENT fPGA-lPl 1 , Monthly j Cummulative LP PGA Budget Gallons Monthly Commodity Total lP Fuel Total lP PGA Overage T YTD Overage Therm/Gal. Month Sold WACOG Charges Expenses Billed (Shortage) i (Shortage) Prior Year $ - $ - $ - $ - i$ 2,006.34 Adj 5,877.00 $ 0.55237 $ 3,246.28 $ 3,246.28 $ (3,246.28) I $ (1,239.93) Oct-96 17,476.60 $ 0.54895 $ 9,593.78 $ 9,593.78 $ 9,274.51 $ (319.27)1 $ (1,559.20) .579/.530 Nov-96 21,163.00 $ 0.58190 $ 12,314.75 $ 12,314.75 $ 11,644.94 $ (669.81)1 $ (1,909.74) .601/.550 Dec-96 27,404.20 $ 0.63562 $ 17,418.66 $ 17,418.66 $ 17,166.20 $ (252.46) I $ (2,162.20) .689/.630 Jan-97 40,363.30 $ 0.76304 $ 30,798.81 $ 30,798.81 $ 32,680.85 $ 1,882.04 $ (280.16) .929/.850 Feb-97 24,124.30 $ 0.72293 $ 17,440.18 $ 17,440.18 $ 17,091.64 $ (348.54) $ (628.70) .831/.760 Mar-97 31,000.00 $ 0.62888 $ 19,495.28 $ 19,495.28 $ 21,498.50 $ 2,003.22 S 1,374.52 .798/.730 Apr-97 32,000.00 $ 0.60000 $ 19,200.00 $ 19,200.00 $ 18,240.00 $ (960.00) $ 414.52 .656/.600 May-97 31,000.00 $ 0.56000 $ 17,360.00 $ 17,360.00 $ 17,670.00 $ 310.00 $ 724.52 .656/.600 Jun-97 31,000.00 $ 0.56000 $ 17,360.00 $ 17,360.00 $ 17,670.00 $ 310.00 $ 1,034.52 .656/.600 Jul-97 31,000.00 $ 0.56000 $ 17,360.00 $ 17,360.00 $ 17,670.00 $ 310.00 $ 1,344.52 .656/.600 Aug-97 31,000.00 $ 0.56000 $ 17,360.00 $ 17,360.00 $ 17,670.00 $ 310.00 $ 1,654.52 .656/.600 ~ 34 000.00 L-~ L 19.040.00 L 19.040.00 S 19.38000 ~~ S 1 994 52 .656/.600 Total YTD 351,531.40 $ 0.61087 $ 214,741.46 $ 214,741.46 $ 217,656.64 $ 2,915.18 ENERGY CONSERVATION ADJUSTMENT (ECAl Monthly Cummulative ECA Budget Cost Center Total ECA Total ECA Overage YTD Overage NGlTherm Month Expenses NoteslExceptionalltems Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - 1$ (77,801.10) Oct-96 $ 32,700.60 ParHomesAdv 21<. Incentives 22 $ 32,700.60 $ 31,561.27 $ (1,139.33) $ (78,940.43) .040/.037 Nov-96 $ 21,839.00 Promotion 17K $ 21,839.00 $ 35,099.12 $ 13,260.12 i $ (65,680.31 ) .040/.037 Dec-96 $ 17,412.40 Advertising 4.3K, Promotion 11.4 $ 17,412.40 $ 44,334.95 $ 26,922.55 S (38,757.76) .040/.037 Jan-97 $ 18,350.00 Advertising 6.3K, Promotion 10K $ 18,350.00 $ 57,220.68 $ 38,870.68 ; S 112.92 .040/.037 Feb-97 $ 21,600.53 Promotion 15.8K $ 21,600.53 $ 49,787.09 $ 28,186.56 I $ 28,299.48 .040/.037 Mar-97 $ 25,000.00 $ 25,000.00 $ 52,174.22 $ 27,174.22 i S 55,473.70 .040/.037 Apr-97 $ 25,000.00 $ 25,000.00 $ 34,004.88 $ 9,004.88 i $ 64,478.58 .0301.027 May-97 $ 25,000.00 $ 25,000.00 $ 29,470.67 $ 4,470.67 ! S 68,949.25 .030/.027 Jun-97 $ 25,000.00 $ 25,000.00 $ 27,895.67 $ 2,895.67 1 S 71,844.91 .030/.027 Jul-97 $ 25,000.00 $ 25,000.00 $ 26,530.67 . $ 1,530.67 : $ 73,375.58 .0301.027 Aug-97 $ 25.000.00 $ 25,000.00 $ 26,425.67 ! $ 1,425.67 $ 74,801.24 .0301.027 ~ L25 00000 I L 25.000.00 $ 27.008.31 L2.008.31 S 76 809.55 .0301.027 Total YTD $ 286.902.53 $ 286,902.53 $ 441,513.18 $ 154,610.65 . I , , Page 1 chudcu JexceVgasratesJrecovery .xls .. . j I .. I : A~' j!4 D...... 2 nf 2 i ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) I Monthly Cummulative EIA Budget Cost Center Total EIA Total EIA Overage YTD Overage NGlThenn Month Expenses NotasJExceptlonalltems Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - S - $ - S (98,133.59) Oct-96 $ - $ - $ 7,887.65 S 7,887.65 $ (90,245.94) .010/.009 Nov-96 $ 31,785.68 Lega19.7K, Env clean up 22K $ 31,785.68 $ 8,771.39 $ (23,014.29) $ (113,260.23) .010/.009 Dec-96 $ 29,035.90 Env enslt 8K,legaI2.7K,appraisal $ 29,035.90 $ 11,079.32 S (17,956.58) $ (131,216.81) .010/.009 Jan-97 $ 9,552.92 Legal fees 9.5K $ 9,552.92 S 14,299.14 $ 4,746.22 $ (126,470.59) .010/.009 Feb-97 $ 1,290.75 $ 1,290.75 $ 18,672.71 $ 17,381.96 $ (109,088.63) .015/.014 Mar-97 $ 7,500.00 $ 7,500.00 $ 19,565.33 S 12,065.33 $ (97,023.30) .015/.014 Apr-97 $ 7,500.00 S 7,500.00 S 17,002.44 S 9,502.44 $ (87,520.86) .015/.014 May-97 $ 7,500.00 $ 7,500.00 S 14,735.33 $ 7,235.33 $ (80,285.53) .0151.014 Jun-97 $ 7,500.00 $ 7,500.00 $ 13,947.83 $ 6,447.83 $ (73,837.69) .015/.014 Jul-97 $ 7,500.00 $ 7,500.00 $ 13,265.33 $ 5,765.33 $ (68,072.36) . .015/.014 Aug-97 $ 7,500.00 $ 7,500.00 $ 13,212.83 $ 5,712.83 $ (62,359.53) .015/.014 ~ S 7.500.00 L- 7.500.00 $ 13.504.16 L6.004.16 L (56.355.37) .015/.014 Total YTOI $ 124,165.25 $ 124,165.25 $ 165,943.47 $ 41,778.22 I TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAa + ECA + EIA) Monthly Cummulative Total Budget Total All Total Recovery Overage YTD Overage All Thenn Month Expenses Billed (Shortage) (Shortage) NGILP Prior Year $ - $ - $ - $ (346,669.41) Adj $ 3,246.28 $ - $ (3,246.28) $ (349,915.69) Oct-96 $ 410,680.71 $ 423,943.08 $ 13,262.37 $ (336,653.32) .430/.629 Nov-96 $ 543,149.39 $ 498,516.00 $ (44,633.39) $ (381,286.71 ) .440/.651 Dec-96 $ 708,731.01 $ 605,325.63 $(103,405.38) $ (484,692.08) .4401.739 Jan-97 $ 970,305.78 $ 1,024,492.71 $ 54,186.93 $ (430,505.15) .580/.979 Feb-97 $ 861,693.10 S 876,503.86 $ 14,810.76 $ (415,694.39) .555/.886 Mar-97 $ 839,495.28 $ 885,958.05 $ 46,462.77 $ (369,231.62) 0.515/.853 Apr-97 $ 682,700.00 $ 684,577.32 $ 1,877.32 $ (367,354.30) .4751.701 May-97 $ 514,860.00 $ 594,001.00 $ 79,141.00 $ (288,213.30) .475/.701 Jun-97 $ 461,860.00 $ 562,613.50 $ 100,753.50 $ (187,459.81 ) .475/.701 Jul-97 $ 444,860.00 $ 535,411.00 $ 90,551.00 $ (96,908.81) .475/.701 Aug-97 $ 439,860.00 S 533,318.50 $ 93,458.50 $ (3,450.31 ) .475/.701 ~ L 438.540.00 S 545 577.47 I.. 107.037.47 $ 103587.15 .475/.701 Total YTD $ 7,316,735.27 $ 7,770,238.11 $ 453,502.84 Page 2 chuck:u:/exceVgasrates/recovery .xls CSW:03/22/97 I I ATTACHMENT #2 Page 1 of 2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 04/01/97 - 09/30/97 I. Calculation of the Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible & Contract lNon-Standard) Rate Schedule PGA for the semi-annual period of 10/1/96 - 3131/97 A. Reservation Charges for the Most Recent 12 Months (2/96 - 1197) = $1,570,746.5 7(See Page 2 for Detail) B. Standard Rate Schedule Therm Usage for the Most Recent 12 Months (See Page 2 for Detail) 2/96 - 1/97 Total Therm Usage 2/96 - 1/97 Non-Standard Usage 2/96 - 1/97 Standard Usage 17,297,368 (4.171.6951 13,125,673 100.0% ~ 75.9% C. PGA Billing Differential Applicable for Interruptible & Contract Rate Schedules for 4/01/97 -9/30/97 A C $1.570.746.57 13,125,673 $0.120 II. Calculation of the Required Natural Gas PGA WACOG for FY 96/97 A. Therm Sales Projection for 10/1/96 - 9/30/97 = 17,310,000 B. Projected NG Reservation Cost 10/1/96 - 9/30/97 = $ Projected NG Commodity Cost 10/1/96 - 9/30/97 = $ Budgeted Other Supply Related Expenses = $ Total Recoyery Needed for FY 96/97 only = $ Under Recovery from FY 95/96 = $ Total Annualized Recovery Needed for FY 96/97 = $ 1,710,000 4,820,000 120.000 6,650,000 173.000 6,823,000 C. Required Weighted Average Recovery Cost/Therm = $ 0.394 70.0% Standard = ~ Non-Standard = 100.0% 12,117,000 Therms @ 5.193.000 Therms @ 17,310,000 Therms $ $ WACOG 0.430 0.310 Recoverv $ 5,210,310 $ 1.611.545 $ 6,821,855 $ 6,644,875 $ 176,980 $ 6,821,856 D. Projected NG PGA Annual Revenue = Pinellas NG PGA = Pasco NG PGA = Total NG PGA = III. Required Natural Gas PGA Billing Factors for 4/1/97 - 9/30/97 A. Required Standard Rate PGA Billing Factor for the Summer Period $0.430 B. Less Non-Standard Differential for Reservation Cost ($0.1201 C. Required Non-Standard PGA Billing Factor for the Summer Period $0.310 u: Ichuck \excel\gasrates\pg 82n96 7. xis I I ATTACHMENT '2 Page 2 of 2 a.EARWATER GAS IYSTEM ANAl. VIII OF ITANOARO VI. _"TANOARD THERMI . RESERVATION CHARGES FOR 2/1/98 - 1/31197 IubtouI Subtotal Nit Not Chargo Per 8IIIng TouI lntorNptlbl. % Controc:t % Non-S~ '" Non- S_rd '" R...,.,.tkJn Standard M9.mI1 IbIm!I IIwmJ lnt-..nJDtlble IbIuDI ~ IIIIonI lSIDIIIuI I!IIunI I1IDlIIrlI QIImu IIIIlm Fob 1996 2.119.870 308.624 14.6% 53.913 2.5% 362.537 17.1% 1.757.333 82.9% $ 160.615.00 $ 0.091 Mar 1998 1.811.600 288.558 15.9% 46.908 2.6% 335.468 18.5% 1.47S.134 81.5% . 169.019.00 $ 0.115 Apt 1995 1.742.874 297.899 17.1% 47.489 2.7% 345.388 19.8% 1.397.488 80.2% $ 163.759.00 $ 0.117 May 1996 1.496.389 274.839 18.4% 41.243 2.8% 318.082 21.1% 1. 1 80.307 78.9% $ 77.511.00 $ 0.066 Jun 1996 1.2S3.385 258.270 20.4% 56.680 4.5% 314.950 24.9% 94S.435 75.1% $ 87.625.39 $ 0.092 JuI 1996 1.024.296 239.811 23.4% 45.243 4.4% 285.054 27.8% 739.242 72.2% . 86.438.92 $ 0.117 Aug 1996 1.007.425 251.751 25.0% 48.053 4.8% 299.804 29.8% 707.821 70.2% $ 89.087.22 $ 0.128 Sop 1996 1.081.440 252. I 34 23.3% 55.485 5.1" 307.819 28.4% 773.821 71.8% . 82.871.00 . 0.107 Oet 1 996 1.110.957 24S. I 03 22.2% 84.875 7.6% 330.978 29.8% 779.979 70.2% . 124.594.00 . 0.160 Nay 1998 1.25S.163 277 .301 22.0% 115.853 9.2% 393. I 54 31.2" 885.009 68.8" $ 170.385.78 $ 0.197 Cee 1996 1.491.781 267.437 17.9" 132.341 8.9" 399.778 26.S% 1.092.003 73.2" $ 179.288.40 $ 0.164 Jan 1997 1.889. I 88 293.955 15.6% 186.930 9.9" 480.885 25.5% 1.408.303 74.5% $ 179.551.86 $ 0.127 Total 8/95-7/96 17.297.388 3.25S.SI2 18.1% 915.013 5.3% 4.171.S95 24.1% 13.125.S73 75.9% . 1.570.748.57 0.120 For Comoarlson S/95 . 7/96 17 .273.820 3.090.826 17.9% 4S0.237 2.8% 3.571.063 20.7% 13.702.757 79.3% 1.543.778.53 0.113 Chongo 23.548 186.858 0.9% 434.778 2.5'" 600.832 3.4% 1577.0841 -3.4% 21.988.04 0.007 ,q r r A c fun F tV ;- - ,=) PROPANE INVENTORY AND WEIGHTEO COST OF GAS (WACOGI PREPAREO BY TERRY NEENAN I .... -- - -..------ DATE I 03/17197 --.------ --.--.. - ---._--- ------ ---.- ---.- -- ... -- ..-.--------,. .__.___.____h -- LP luppHld by FlrrIHQ"-"_,_~ li44- 1 4 1 II Alk 10' !'lorC. .. -.-------- ---".-. -------- ----~._- .---- Dill Contrlct Endl 9/30/97 ---~-- -- --- - INYENTORY TANK COST OF GALLONS OElIVERED DElIYEREO TOTAL NEW DATE WITHDRAW INVENT. WACOG INYENT DeliVERED PRICE INVOICE GALLONS WACOG 9/30/96 20,897 43,857 $ 0.54895 $ 24,075.30 $ $ 43.S57 $ 0.54895 10/29/96 53.125 $ 0.57104 $ 30,336.76 9,266 $ 0.67560 $ 6.261.46 53,125 $0.57104 - 10130/96 1991) 52.134 $ 0.58190 $ 30,336.76 $ $ 53,125 $0.58190 1111196 29.216 22,918 $ 0.58190 $ 13,335.98 $ $ 53,125 $0.58190 11/1196 32.224 $ 0.60896 $ 19.623.12 9,306 $ 0.67560 $ 6.287.13 62,431 $0.60896 11/1196 41,582 $ 0.62396 $ 25,945.38 9,358 $ 0.67560 $ 6,322.26 71,789 $0.62396 1112/96 50.926 $ 0.63343 $ 32.258.19 9,344 $ 0.67560 $ 6.312.81 81,133 $0.63343 11/30/96 (1751 50,751 $ 0.63582 $ 32,258.19 $ - . 81.133 $0.63562 11/30/96 36,509 14,242 $ 0.63562 . 9,052.60 $ . 81,133 $0.63562 12/02/98 23,443 $0.68467 $ 16,060.78 9,201 $ 0.76060 $ 6,998.26 90.334 '0.68467 12/03/96 32,636 $0.71461 $ 23,317.98 9,192 $ 0.79060 . 7,267.20 99,526 $0.71451 12/08/96 41,903 $0.73687 $ 30,878.96 9,288 $ 0.8168 $ 7,668.98 108,794 $0.73687 12/23/96 61,019 $0.74994 . 38,261.39 9,116 $ 0.8166 $ 7,384.43 117,910 $0.74994 --- 12/23/9S 60,211 to.75920 $ 45,712.43 9,192 $ 0.8158 $ 7,461.04 127,102 $0.75920 12/30/96 (1761 60,035 $0.76304 $46,808.96 $ . 127,102 $0.76304 12/31198 42,118 17 ,917 $0.76304 $ 13,671.39 $ - $ 127,102 $0.76304 01/02/97 27,047 $0.76222 $ 20,816.67 9.130 $ 0.78060 $ 6,944.28 136,232 $0.76222 01/08/97 36,363 $0.75412 $ 27,414.63 9,306 $ 0.73060 $ 8,798.98 t 45,638 $0.75412 01/19/97 45,640 $0.74578 $ 34,037.19 9,287 $ 0.71310 $ 8,622.68 164,826 $0.74678 01/21197 64,062 $0.73601 $ 39,790.26 8,422 $ 0.88310 $ 6,753.07 163,247 $0.73601 01/22/97 63,463 $0.72817 $ 46,212.08 9,401 $ 0.68310 $ 6,421.82 172,648 $0.72817 01/22/97 72,841 $0,72248 $ 62,481.57 9,178 $ 0.68310 $ 8,269.49 181,826 $0.72248 01/31/97 (451 72,596 $0.72293 $52.481.67 $ $ 181.826 $0.72293 01/31/97 42722 29,874 $0,72293 $ 21,596.81 - $ $ 181,826 $0.72293 02/14/97 39,071 $0.68236 $ 26,680.68 9,197 $ 0.65060 $ 5,063.87 191,023 $0.68236 02/18/97 48.198 $0.65742 $ 31,684.90 9,125 $ 0.65060 $ 6,024.23 200.148 $0.65742 02/19/97 67,321 $0.64041 $ 36,709.13 9,125 $ 0.65060 $ 5,024.23 209,273 $0.84041 02/19/97 66,532 $0.62798 $ 41,780.71 9,211 $ 0.55060 . 5,071.58 218,484 $0.62798 02/28/97 (951 66,437 $0.62888 $41,780.71 218,484 $0.82888 02/28/97 34.422 32,016 $0.62888 $ 20,133,59 $ $ 218,484 $0.82888 03/11/97 41,273 $0.61132 $ 26,231.06 9,268 $ 0.65060 $ 5,097.45 227,742 $0.61132 03" 1/97 60,646 $0.60018 $ 30,336.76 9,273 . 0.55080 $ 6,106.71 237,016 $0.60018 03"3/97 59,833 $0.59249 $ 36,460.18 9,287 $ 0.56060 $ 6,113.42 246.302 $0.59249 _. -- Total GaUrlO" Mil" Inv. Oal. Total Oallon. ..-------.-- ~-'"- -_...._,_._~---- WlttHJrawn 204.402 72,641 Delivered 202,445 . 136.154.26 ------ Pounds nor Gal 4.23 Ma x Pounds 95 307,271.43 11.1661 $ 0.66611 ._- -.---. 1:\INCOCA TOA\lPWACOO,XLI - _J CSW:03/22/97 Applicable Annual The,m Range or Other Rate Determinant Monthly Customer Cha'ge Non-fuel Enerav Chara.lTharm Non.Fuel Energy Cha'ge Energy Consorvation Adj. IECAI EnvirolJmelJtal ImpositiolJ Adj. IEIAI Weather Normalization Adj. IWNA) Tote' NOIJ-Fuel ElJergy Cherge Purchased Gas Adjustment IPGA) Tote' Ene'gy ChergelTherm Minimum Monthly Bill Compere. to lP/Genon Rete of with 6.0% Franchise Chenge from 9/96 Therm Rete Utllltv T IX !'lQa; Fuel Rate per TI1erm 10/01/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR APRIL I. 1997 - SEPTEMBER 30.1997 BASED ON APPROVED GAS AD.lUSTMENT FACTORS ----BL ....&ME- -M.ML ..J.ML $6.00 $15.00 NA (1. NA (4 + NA (4 + NA (4 + 3 Units' Unils) Unlta) Units) $60.00 $0.530 $0.630 0.030 $20.00 $0.530 $0.530 0.030 0.030 0.030 0.015 0.015 0.015 0.015 Q.llQQ Q.llQQ Q.llQQ g.Qllll aO.575 aO.575 '0.675 $0.675 al.005 '1.006 M.3.Q M.3.Q M.3.Q M.3.Q '1.00S '1.006 $6.00 $15.00 UO.OO $60.00 Firm Natural Ga. Rate Schedul.. ~ ~ ....LGI.... ....IIAl<.... ....liAk... $15.00 o - 18,OOQ. 17,999 99.999 UO.OO $0.470 0.030 0.015 g.Qllll '0.616 M.3.Q '0.9411 '15.00 $0.410 0.030 0.015 Q.llQQ $0.455 M.3.Q 'O.BBS $20.00 100,000 &. up $50.00 '0.350 '0.395 '0.B25 $50.00 a 0.055 a 0.105 0.920 $ 0.920 . 0.920 . 0.920 . 0.B85 . 0.810 . 0.7115 0.975 a 0.975 1 0.975 $ 0.976 $ 0.917 $ 0.85B . O.BOO 0.155 . 0.205 . 0.045 . 0.035 a 0.025 $0.069 $0.069 $0.069 $0.089 $0.361 $0.361 $0.361 $0.381 nu..H!,CTOR ~ THERMS/l00 CU81C FEET ICCF) Firm Service Rates Interruptihle Service Rates .lllmi 1.068 1.047 1.1lH .uLH $0.069 $0.361 QJ.lU $0.069 $0.361 llZlIZ 1.077 1.074 '0.069 $0.361 Q1l3Z NA (1. 3 Unital $6.00 II not p,ev. billed $0.200 0.030 0.015 Q.llQQ $0.245 M.3.Q '0.175 NA (0 - NA (150 149 tOlJa' tona &. +1 ~ $15.00 if not p,ev. billed $0.150 0.030 0.015 g.Qllll $0.195 M.3.Q '0.826 $15.00 II 1J0t p,ev. billed $0.100 0.030 0.030 $0.069 $0.361 lWll1 0.015 0.Q15 JL SL w/MIo JiGJL IiIIIgb1 NA NA NA $15.00 $0.200 $0.245 '0.S75 $15.00 + FAC $0.069 $0.361 llZlllZ $15.00 $6 Resl./ $15 GS if not prev. billed $0.300 $0.100 0.030 0.030 0.030 1m..... ttii.IIIlI JJ&L. ---.IL- $25.00 NA 100,000 &. up $100.00 $0.470 0.030 0.015 Q.llQQ $0.515 M.3.Q $0.280 NA NA -& '0.280 '0.945 aO.590 lUlll $25.00 $100.00 + FAC + Non-FueI Therm R.ot. fOf 250 thermo X , Oays in Mo. 0.618 0.655 0.709 0.752 0.626 $ 0.885 0.558 $ 0.917 0.045 . 0.057 0.540 0.572 $0.055 $0.255 ATTACHMENT .4 ConIrect I!Ili...Ilm ~ - NA By COlJtract By Contract NA NA -& By Contrect lUlll '0.310 + Non-Fuel Customer Cllarge + Non- Fuel Thenn Ret. IOf COlJtrect , of Therms _. . 0.037 $0.069 $0.241 1.067 1.063 1.077 1.046 1.042 1.056 1.056 1.063 Q.llQQ QJlllll '0.145 M.3.Q M.3.Q $8.00 0 $15.00 0 $15.00 0 premia. premise preml.. '0.575 0.S1B . 0.572 . 0.528 0.665 $ 0.606 $ 0.558 0.015 0.015 0.015 QJlllll QJlllll QJlllll $0.345 $0.145 M.3.Q lMJQ lMJQ '0.775 aO.575 $15.00 $6 Res!./ +FAC $15GSO premise + FAC 0.005 . 0.005 . 0.005 a 0.005 a 0.005 $ 0.005 $0.069 $0.361 ~ 1.072 1.051 $0.069 $0.361 ~ $0.069 $0.069 10.361 $0.361 2lI1.lU llmz $0.069 $0.361 CSW:03/22/97 BTU Facto,: BTU Factor: Therm Factor: .z..1.ll ZAa3. QJill. Gallons/l00 cubic feet (CCFI Therms/100 cubic feet (CCF) Therms/Gallon CLEARWATER GAS SYSTEM PROPANE (LP) RATE BILLING FACTORS FOR APRIL 1, 1997 - SEPTEMBER 30,1997 BASED ON APPROVED GAS ADJUSTMENT FACTORS ATTACHMENT '5 Contract LP Syc. - RLP MLP GLP LLP LPV LPS CLP Appl. Annual Gallon (Therm) Range NA NA o - 2.499 Gallons 2,500 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (0-2,2B7 Therms) (2,288 Therms & Up) Monthly Custome, Charge $6.00 $16.00 $15.00 $20.00 $6.00 Resl. or $25.00 Set By Contract $15.00 GS if not Non-Fuel Enerov Char\Je: prevo billed @ premise Non-Fuel Energy Charge IGallon $0.700 $0.700 $0.390 $0.320 $0.100 $0.390 By Contract /Therm $0.765 $0.765 $0.426 $0.350 $0.109 $0.426 By Contr. Energy Conservation Adj. IGallon 0.027 0.027 0.027 0.027 0.027 0.027 NA {ECAI /Therm 0.030 0.030 0.030 0.030 0.030 0.030 NA Environm'l ImpMition Adj. IGallon 0.014 0.014 0.014 0.Q14 0.Q14 0.014 NA (EIA) /Therm 0.Q15 0.Q15 0.Q15 0.015 0.Q15 0.015 NA Weather No,malization Adj./Gallon Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ ~ (WNA) /Therm Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q...QQQ Q.QQQ ---1:!IA Total Non-Fuel Charge/Gallon $0.741 $0.741 $0.431 $0.361 $0.141 $0.431 By Contract ITherm $0.810 $0.810 $0.471 $0.395 $0.154 $0.471 By Cntr. '.-' Pu,chascd Gas Adjustment/Gallon Q&QQ 2...6.QQ Q&QQ Q&QQ 2...6.QQ 2...6.QQ 2...6.QQ (PGA) /Therm ~ ~ ~ ~ ~ ~ Q..W Total Energy Charges IGallon $1.341 $1.341 $1.031 $0.961 $0.741 $1.031 $0.600 /Tharm $1.466 $1.466 $1.127 $1.051 $0.810 $1.127 + NF $0.656 + NF Minimum Monthly Bill $6.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. Change from 9/96 IGallon Rate $ 0.078 $ 0.378 $ 0.068 $ 0.058 $ 0.028 $ 0.068 $ 0.060 ITherm Rate $ 0.086 $ 0.413 $ 0.074 $ 0.064 $ 0.031 $ 0.074 $ 0.066 Note: Utiliy Tax is billed on total LP bill.