Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2002
TO: FROM: COPIES: SUBJECT: DATE: J i CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet \) E' C )) 5 lnn'r _" ,', ..' !..... \J "JHB, William B. Horne II, City Manager Chuck Warrington, Managing Director ~ Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Tom Madley, Sr. Accountant/CCS; Laura Damico, Sr. Accountant/CCS GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2002 December 20, 2001 Natural and Propane (LP) Gas supply prices have stabilized and dropped somewhat. Therefore, we are recommending a decrease of 2 C in our Natural Gas Purchased Gas Adjustments (PGA) and a decrease of 3C in our Propane (LP) PGA in January. At the same time, we are falling behind on our Energy Conservation Adjustment (ECA) collections; therefore, we are proposing an offsetting increase in our ECA of 2 C per therm and gallon, respectively, for January. As you know, we are experiencing an extremely mild winter this year thus far resulting in a shortfall in Heating Degree Days of 95% thru November, and we project this YTD shortfall to be 60-70% by the end of December. Even if the rest of the winter is normal, this will likely place us at least 20-25% below normal for the year, which triggers our Weather Normalization Clause (WNA) set at (10%). This represents a projected FYTD Non-Fuel Energy (NFE) shortfall FYTD through December of about $125,000. Therefore, we are recommending implementing a 2C per therm and gallon WNA beginning in January so that we can recover this shortfall during the peak usage months closest to when the shortfall was created. This will hopefully avoid even higher WNAs later in the year. We will, of course, true this WNA shortfall up as the winter develops, so as to properly collect only the actual final NFE shortfall. We are not recommending changes to any of our other Adjustment clauses at this time. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after January 1, 2002: Natural Gas Firm Standard Rate Schedule PGA ....... $0.600 per therm (down 2.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.520 per therm (down 2.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.520 per gallon (down 3.0C/gallon) = $0.568 per therm equivalent (down 3.3C/therm) Energy Conservation Adjustment (ECA) ............... $0.160 per therm (up 2.0C/therm) = $0.150 per gallon of LP (up 2.0C/gallon) /,/ j'r,..-; /. .',.. ~~/ "'~ (} r2 William B. Horne II, City M1ager Page 2 I December 20, 2001 Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) = $0.000 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... $0.020 per therm (up 2.0C/therm) = $0.020 per gallon of LP (up 2.0C/gallon) Attachment #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru November and projections thru January. These show that we are about $1.2 Million behind FYTD, but are projecting gaining about $100,000 per month on this shortfall, and this should accelerate in the summer months when our Natural Gas Reservation Charges decline. It is important to our overall financials that we get this back in balance by Fiscal Year End. Attachments #2 and #3 show our current annual projections for Natural Gas supply costs and LP historical FYTD costs, respectively. Attachment #2 shows the basis for our 2C per therm proposed reduction in NG PGA, in that we are now projecting an annual fuel cost/therm 2C below that which was forecasted for our October rates. Attachment #3 shows the drop in LP supply pricing justifying our 3C pr gallon decrease recommendation. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. I should point out that the overall continued impact of this on our Residential customers is a 28% reduction from our peak winter rates last year (27% lower for LP). This means that our average customer will likely see an overall savings on their typical January bill of $24/month below last January ($20 lower for LP) based on 45 therms/month, which is our average monthly residential customer consumption for January. It is our plan to use the above-proposed adjustments for billings through March 31, 2002, 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. Bill, 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 January 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments t? U:\My Oocuments\MSOFFICE\WINWORO\GASRATES\Gas Adjustments for January 2002.doc CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS PaQe 1 of 3 . NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NG) Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelTherm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) FirmlContr rior Year $ - $ 683,248.69 Oct-01 $ 1,332,459.05 $ 595,311.70 $ 18,794.47 1 $ 1,946,565.22 $ 757,106.13 $ (1,189,459.09) $ (506,210.40) .620/.540 Nov-01 $ 183,651.56 690,495.07 $ 23,753.31 $ 897,899.94 $ 893,077.55 $ (4,822.39) $ (511,032.79) .620/.540 Dec-01 $ 160,000.00 $ 750,000.00 $ 25,000.00 $ 935,000.00 $. 979,200.00 $ 44,200.00 $ (466,832.79) .620/.540 Jan-02 $ 160,000.00 $ 840,000.00 $ 25,000.00 $ 1,025,000.00 $ 1,056,400.00 $ 31,400.00 $ (435,432.79) .600/.520 Feb-02 $ - $ - $ (435,432.79) Mar-02 $ - $ - $ (435,432.79) Apr-02 $ - $ - $ (435,432.79) May-02 $ - $ - $ (435,432.79) Jun-02 $ $ - $ (435,432.79) .... - Jul-02 $ - $ - $ (435,432.79) Aug-02 $ - $ - $ (435,432.79) Sep-02 $ - $ - $ (435,432.79) Oct-02 $ - $ - $ (435,432.79) otal YT[ $ 1,836,110.61 $ 2,875,806.77 $ - $ 92,547.78 $ 4,804,465.16 $ 3,685,783.68 $ (1,118,681.48) (1) Includes annual charge for Admin and CCS chg of 1,298,000 (2) PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) Monthly Cumulative LP PGA Budget Gallons Monthly Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) rior Year $ 34,659.23 Oct-01 34,975.7 $ 0.49971 $ 17,477.71 1 $ 94,567.71 $ 19,387.00 $ (75,180.71) $ (40,521.48) .601/.550 Nov-01 35,695.7 $ 0.49308 $ 17,600.84 $ 17,600.84 $ 19,631.99 $ 2,031.15 $ (38,490.32) .601/.550 Dec-01 40,000.0 $ 0.46000 $ 18,400.00 $ 18,400.00 $ 22,000.00 $ 3,600.00 $ (34,890.32) .601/.550 Jan-02 50,000.0 $ 0.46000 $ 23,000.00 $ 23,000.00 $ 26,000.00 $ 3,000.00 $ (31,890.32) .568/.520 Feb-02 $ $ $ $ (31,890.32) - - - - Mar-02 $ - $ - $ - $ (31,890.32) Apr-02 $ - $ - $ - $ (31,890.32) May-02 $ - $ - $ - $ (31,890.32) Jun-02 $ - $ - $ - $ (31,890.32) Jul-02 $ - $ - $ - $ (31,890.32) Aug-02 $ - $ - $ - $ (31,890.32) Sep-02 $ - $ - $ - $ (31,890.32) otal YTD #DIV/O! $ - 76,478.54 $ 153,568.54 $ 87,018.99 $ (66,549.55) Cost Center Expenses CCS Chg & Admin 67,090.00 1 Fuel 10,000.00 1 77,090.00 Pa e 1 Attachment #1 Paae 2 of 3 - ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. rior Year $ - $ - $(1,068,572.38) Oct-01 $ 114,374.97 Promo$18,689,Employ CostS$15,755.97 $ 5,342.86 1 $ 119,717.83 $ 85,623.40 $ (34,094.43) $(1,102,666.81) .1401.130 Nov-01 $ 58,710.74 Promo$46,235.84,Employ Costs$12,474.90 $ 5,513.33 $ 64,224.07 $ 104,659.99 $ 40,435.92 $(1,062,230.90) .1401.130 Dec-O 1 $ 60,000.00 $ 5,500.00 $ 65,500.00 $ 112,300.00 $ 46,800.00 $(1,015,430.90) .1401.130 Jan-02 $ 60,000.00 $ 5,400.00 $ 65,400.00 $ 144,300.00 $ 78,900.00 $ (936,530.90) .1601.150 Feb-02 $ - $ - $ (936,530.90) Mar-02 $ - $ - $ (936,530.90) Apr-02 $ - $ - $ (936,530.90) May-02 $ - $ - $ (936,530.90) ~ Jun-02 $ - $ - $ (936,530.90) Jul-02 $ - $ - $ (936,530.90) Aug-02 $ - $ - $ (936,530.90) Sep-02 $ - $ - $ (936,530.90) otal YT[ $ 293,085.71 $ 21,756.20 $ - $ 314,841.91 $ 446,883.39 $ 132,041.48 (1) Includes annual charge for Admin and CCS chg of 79,930.00 ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. rior Year $ - $ - $ 245,295.48 Oct-01 $ 10,163.24 $ - 1 $ 10,163.24 $ 1.13 $ (10,162.11) $ 235,133.37 .0001.000 Nov-01 $ 5,098.50 $ - $ 5,098.50 $ 0.41 $ (5,098.09) $ 230,035.28 .0001.000 Dec-01 $ 5,000.00 $ - $ 5,000.00 $ - $ (5,000.00) $ 225,035.28 .0001. 000 Jan-02 $ 5,000.00 $ - $ 5,000.00 $ - $ (5,000.00) $ 220,035.28 .00aL..l:lC.0 Feb-02 $ - $ - $ - $ 220,035.28 Mar-02 $ - $ - $ - $ 220,035.28 Apr-02 $ - $ - $ - $ 220,035.28 May-02 $ - $ - $ - $ 220,035.28 Jun-02 $ - $ - $ - $ 220,035.28 Jul-02 $ - $ - $ - $ 220,035.28 Aug-02 $ - $ - $ - $ 220,035.28 Sep-02 $ - $ - $ - $ 220,035.28 Sep~OO $ - $ - $ 220,035.28 otal YT[ $ 25,261.74 $ - $ 25,261.74 $ 1.54 $ (25,260.20) 1)lncludes annual charges for Admin Charge 10,000 . Page 2 U:\windows\m Attachment #.1 PaQe 3 of3 .. TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA + WNA) Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage NGlTherm Month Expenses Billed (Shortage) (Shortage) , LP/Gal rior Year $ - $ - $ - $ (105,368.98) Oct-01 $ 2,171,014.00 $ 862,117.66 $ (1,308,896.34) $(1,414,265.32) .760/.680 Nov-01 $ 984,823.35 $. 1,017,369.94 $ 32,546.59 $(1,381,718.73) .7601.680 Dec-01 $ 1,023,900.00 $ 1,113,500.00 $ 89,600.00 $(1,292,118.73) .760/.680 Jan-02 $ 1,118,400.00 $ 1,226,700.00 $ 108,300.00 $(1,183,818.73) .780/.690 Feb-02 $ - $ - $ - $(1,183,818.73) Mar-02 $ - $ - $ - $(1,183,818.73) Apr-02 $ - $ - $ - $(1,183,818.73) May-02 $ $ $ $(1,183,818.73) - - - - Jun-02 $ - $ - $ - $(1,183,818.73) Jul-02 $ - $ - $ - $(1,183,818.73) Aug-02 $ - $ - $ - $(1,183,818.73) Sep-02 $ - $ - $ - $(1,183,818.73) otal YTD $ 5,298,137.35 $ 4,219,687.60 $ (1,078,449.75) Note: Total all Admin & CCS Transfer Charges Collected thru Adjustment Clauses = $1,455,020 included in October. WEATHER NORMALIZATION (WNA) Monthly Cumulative WNA Budget Interest Overage YTD Overage NGlTherm Month LP Gallons Expense Rate/Gallon NG Therms RatelTherm (Shortage) (Shortage) LP/Gal Beg. Ba!. $ - $ (125,000.00) Oct-01 $ - $ (125,000.00) Nov-01 $ - $ (125,000.00) Dec-01 $ - $ (125,000.00) Jan-02 50,000.0 $ 0.020 1,900,000.0 $ 0.020 $ 39,000.00 $ (86,000.00) .0207.020 Feb-02 $ (86,000.00) Mar-02 $ - $ (86,000.00) Apr-02 $ - $ (86,000.00) May-02 $ - $ (86,000.00) Jun-02 $ - $ (86,000.00) Jul-02 $ - $ (86,000.00) Aug-02 $ - $ (86,000.00) Sep-02 $ - $ (86,000.00) Sep-01 $ (86,000.00) otal YTD 50,000.0 - 1,900,000.0 $ 39,000.00 U:\My Documents\EXCEL\GASRATES\FY 01-02\[Adjustment Clause Recovery for FY 01-02.xls]Recovery CSW: Updated 12/20/01 Pa e3 It Trfl-GJ-I-(Y11&;\!1 j:i; 2- CLEARWATER FY01.02 PURCHASED GAS COST PROJECTIONS AS OF Based on Actual DTH's Sold 12/19/2001 FTS.l Contract Capacity FTS.2 Contract Capacity Capacity Relinquishments FTS-l Available Capacity FTS.2 Available Capacity Contract NNT5 Per Month Purchased Gas Sold Gas Projected 50ld Per Month % of Purchased Gas lost Sold Gas (PGA revenues) -- Total lohase III lohase 1111 170,438 41788 $ 25,880.46 54213 0 15500 158,013 165,000 100.00% 306,570 53 430 $ 16 439.64 191175 0 22 500 168,925 195.000 306,570 53,430 $ /1,115.10 137,000 0 30.000 223,000 223.000 316,789 55,211 $ 371.70 152,000 0 48,500 220,000 220,000 286,132 49,868 $ /743.40 117,000 0 42,000 219.000 219,000 316.789 55,211 $ 11,151.00 166,000 0 31,000 206,000 206,000 216,570 53,430 $ 11,151.00 99,000 0 22,500 171,000 171,000 144,212 41,788 $ 5.761.35 29.000 0 12.400 157.000 157,000 139,560 40,440 $ 11,151.00 29,000 0 10.500 151,000 151,000 144,212 41,788 $ 11,522.70 35,000 0 10,850 151.000 151,000 144.212 41.788 $ 14,868.00 35,000 0 10,850 151,000 151,000 139,560 40.440 $ 11.151.00 29,000 0 10,500 151.000 151,000 2,631,614 568,812 ($111,308.35) 1,073,388 o 285,100 2,128,838 2,160,000 100.00% $ OcHll Nov.ol Dec.ol Jan.o2 Feb.o2 Mar.o2 Apr.o2 May.o2 Jun-Q2 Jul.o2 Aug.o2 Sep.o2 FTS-l Reservation charges FT5.1 Usage Charge FTS-l No-Notice charges FTS-2 Reservation charges FTS.2 Usage Charge Total Commodity charges Monthly Adjustments Fuel Cost (Fuel Retention) FGU Management fee Per Month WACoG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Total Billing :From FGU + Infinite: Oct.ol Nov.ol Dec.ol Jan.o2 Feb.o2 M.,.o2 Apr.o2 May.o2 Jun.o2 Jul.o2 Aug.oZ Sep.o2 (ohase III (nhase III NNTS (nhase IIIl (nhase 111\ $ 63 351.80 $ 3,953.68 $ 914.50 $ 31,028.49 $ 991.27 $ 848;110.18 $ /147.12 $ 15,609.25 $ 4,917.08 $ 4.54 $ 74.46% $717,524.51 $ 113,952.06 $ 3 946.59 $ 1.327.50 $ 39,888.77 $ 1 385.93 $ 788,028.37 $ 147.52 $ 18,399.54 $ 5,752.76 $ 5.43 $ 46.90% $916,535.06 $ 113,952.07 $ 5.136.83 $ 1.770,00 $ 40,863.26 $ 951.05 $ 1,008,188.16 $ - $ 23.782.27 $ 8.544.20 $ 5.22 $ 61.94% $1,163,658,39 $ 117,750.47 $ 4,943.76 $ 2.743.50 $ 42,225.37 $ 982,76 $ 993,191.48 $ $ 21,946.53 $ 8.384.11 $ 5,25 $ 59.14% $1,155.539.12 $ 106,355.26 $ 5,846.00 $ 2,478.00 $ 38.139.05 $ 542.62 $ 990,538.83 $ $ 21.877.65 $ 8.435.08 $ 5.19 $ 65.18% $1.136,767.74 $ 117.750.47 $ 4,799.52 $ 1,829.00 $ 42,225,37 $ 807.34 $ 901,135.16 $ - $ 19.895.84 $ 7.789.11 $ 5.11 $ 55.38% .$.Wl5J.,789.00 $ 80 499.07 $ 2.046.29 $ 1,327.50 $ 40.863.28 $ 1,605.22 $ 746.747.83 $ - $ 17.606.30 $ 6,334.20 $ 5.02 $ 63.33% . $656,266,66 $ 53,603.60 $ 2,819.50 $ 731.60 $ 31.098.63 $ 948.53 $ 616.125,75 $ - $ 14,483.04 $ 5,708.09 $ 4.43 $ 84.41% $695,798.23 $ 51,874.45 $ 2,428.38 $ 619.50 $ 30,021.66 $ 1,054.81 $ 592,530,78 $ $ 13,929,58 $ 5,454.20 $ 4.40 $ 83.89% $663,895.39 $ 53,603.60 $ 3,010.90 $ 640.15 $ 31,959,46 $ 743.83 $ 592,804.17 $ $ 13,929.76 $ 5,453.09 $ 4.42 $ 81.18% $667,484.69 $ 53,603.60 $ 3,800.58 $ 640.15 $ 31,959.46 $ 743.83 $ 518.179.53 $ $ 12,067.62 $ 6,417.50 $ 3.89 $ 81.18% $587,514,74 $ 51,874,45 $ 3,847.49 $ 619,50 $ 30.928.51 $ 719.83 $ 516,202.44 $ - $ 12.067.62 $ 6,417.50 $ 3.90 $ 77.22% $588,473.91 $978.170.91 $46,581.51 $15,640.90 $430,979.30 $11,477.01 $8,889,782.68 $0.40 $205,595.01 $79,636,92 $4,797 69.52% $10,203,267.43 Average Total ProJected DTH WACOG Total Reservation Total Com modi Cost Purchased 1 st 6 Months $832,621.65 $5,309,192.17 $6,141,813.82 1,194,838 $5.140 2nd 6 Months $480,863.12 $3,580,590.50 54,061,453.61 932,000 $4.358 TOTAL $1,313,484.76 $8,889,782.87 $10,203,287.43 2,126,838 $4.80 Purchased Waco9-FY01 Budget 2078 PO amount '10.203,267.43 over budget (Note: Volumes are based on historical usage and expected weather. FGT transportation and fuel rates are based on actual approved gas tariff rates. These numbers represent a best look forward based on current data. I F:\SUPPL Y\WACOG 2002.xls I I 11 rr/Jc/fmtf-t.vi J:F~5 Propane Inventory and Weighted Cost of Gas (WACOG) 12/20/2001 LP Supplied by: Sea-3 of Florida Suburban Propane 9/30/01 0.50030 Date Tank Withdrawl WACOG 38,661 0.50161 0.50009 0.49971 0.49971 0.53032 0.50523 0.49462 0.49308 0.49308 CSW: 12/20101 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Enerav CharqelTherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Environmental Imposition Adj. (EIA) Weather Normalization Adj. (WNA) Total Non-Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelTherm Minimum Monthly Bill Compares to LP/Gallon Rate of with 6.0% Franchise Change from 01/01 Therm Rate % Change from 01/01 Therm Rate Utility Tax Note: Fuel Rate per Therm 10101/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JANUARY 1, 2002 - MARCH 31, 2002 BASED ON APPROVED GAS ADJUSTMENT FACTORS ~ SMF MMF LMF NA (1. NA (4 + 3 Units) Units) NA (4 + NA (4 + Units) Units) $7.00 $15.00 $20.00 $50.00 $0.580 $0.580 $0.580 $0.580 0.160 0.160 0.160 0.160 Firm Natural Gas Rate Schedules SGS MGS LGS RAC GAC LAC. ~ SL w/M& NGV Rellaht 0- 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA 17,999 99,999 & up 3 Units) 149 tons) tons & +) $15.00 $20.00 $50.00 $0.470 $0.410 $0.350 0.160 0.160 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.020 0.020 0.020 0.020 0.020 0.020 0.020 $0.760 $0.760 $0.760 $0.760 $0.650 $0.590 $0.530 $1.360 $1.360 0.600 0.600 0.600 0.600 0.600 0.600 0.600 $1.130 $1.360 $1.360 $7.00 $15.00 $20.00 $50.00 $1.250 $1.190 $7.00 if $15.00 if $15.00 if not prevo not prevo not prevo billed billed billed $0.200 $0.150 $0.100 $15.00 $15.00 $7 Resl.! $15 GS if not prev. billed $0.300 $0.100 Interr. NG Rate NSS ---1L NA 100,000 &up $25.00 $100.00 $0.470 $0.280 0.160 0.160 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA 0.160 NA $0.200 0.160 0.160 0.160 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 $0.380 $0.330 $0.280 $0.380 $0.480 $0.280 $0.650 $0.300 $0.980 $0.880 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.520 $1.250 $0.820 $0.930 $7.00 @ $15.00 @ $15.00 @ premise premise premise $15.00 +FAC $15.00 $20.00 $50.00 0.160 0.160 $0.980 $1.080 $0.880 $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.244 $ 1.244 $ 1.244 $ 1.244 $ 1.144 $ 1.089 $ 1.034 $ 0.897 $ 0.851 $ 0.805 $ 0.897 $ 0.988 $ 0.805 $ 1.144 $ 0.750 $ 1.319 $ 1.319 $ 1.319 $ 1.319 $ 1.212 $ 1.154 $ 1.096 $ 0.951 $ 0.902 $ 0.854 $ 0.951 $ 1.047 $ 0.854 $ 1.212 $ 0.795 $15.00 $7 Resl.! + FAC $15 GS @ premise + FAC $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.530) $ (0.570) -28.0% -28.0% -28.0% -28.0% -29.8% -30.8% -31.9% -35.1% -36.2% -37.6% -35.1% -32.9% -37.6% -29.8% -41.0% $0.069 $0.069 $0.069 $0.069 $0.531 $0.531 $0.531 $0.531 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) Firm Service Rates Interruptible Service Rates 10/01 11/01 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.055 $0.531 $0.531 $0.531 08/02 09/02 $0.465 Attachment #4 Contract NG Rate ~ NA By Contract -, By Contract NA NA 0.020 Contract + $0.020 Plus 0.520 $0.540 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms - $ (0.570) -51.4% $0.069 $0.451 12/01 01/02 1.059 1.056 1.048 1.052 1.039 1.036 1.028 1.031 $0.531 $0.531 $0.531 02/02 03/02 $0.531 $0.531 $0.531 $0.531 04/02 05/02 06/02 07/02 CSW: 12/20101 Attachment #5 Page 1 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) METERED PROPANE (lP) RATE BilLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR JANUARY 1, 2002 . MARCH 31, 2002 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 Resl. or $25.00 Set By Contract $15.00 GS if not Non-Fuel EnerQV CharQes/Gallon: prevo billed @ c:;;.. premise Non-Fuel Energy Charge IGallon $1.400 $1.400 $0.200 $0.150 $0.100 $0.390 Set By Contract Energy Conservation Adj.lGallon 0.150 0.150 0.150 0.150 0.150 0.150 NA Environm'llmposition Adj. IGallon 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0.020 0.020 0.020 0.020 0.020 0.020 0.020 Total Non-Fuel Charges/Gallon $1.570 $1.570 $0.370 $0.320 $0.270 $0.560 By Contract + $0.020 Purchased Gas AdjustmenVGallon 0.520 0.520 0.520 0.520 0.520 0.520 0.520 Total Energy Charges/Gallon $2.090 $2.090 $0.890 $0.840 $0.790 $1.080 $0.540 + 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 10101/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm $0.359 $0.359 $0.359 $0.359 $0.359 $0.359 $0.359 Change from 01/01 Gallon Rate % Change from 01/01 Gallon Rate $ (0.411) -16.4% $ (0.411) -16.4% $ (0.411) -31.6% $ (0.411) -32.9% $ (0.411) -34.2% $ (0.411) -27.6% $ (0.460) -46.0% CSW:12/20/01 . Attachment #5 Page 2 of 2. BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon CLEARWATER GAS SYSTEM BULK PROPANE (lP) RATE BilliNG FACTORS FOR JANUARY 1, 2002. MARCH 31, 2002 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL LP SERVICE WILL CALL SPLASH - PREPAID COMMERCIAL CONTRACT BRLP1 BRLP2 BRLP3 BRLP4 BRWCLP BRWCLP BRSPLP1 BRSPLP1 BRSPLP2 BRSPLP2 BCLP1 BCLP2 CLP Applicable Annual Gallon Range 0-60 60.1 -120 120.1 - 300 > 300 0-300 > 300 o -200 > 200 0-400 >400 o - 2500 > 2500 NA or Other Rate Determinant -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 -=:;or Annual Customer Charge $ 84.00 $ 60.00 $ 48.00 $ 36.00 $ 36.00 NA $ 36.00 NA $ 36.00 NA $ 60.00 $ 60.00 Set by contract Non-Fuel Enerav Charaes/Gallon: Non-Fuel Energy Charge/Gallon $ 1.300 $ 1.150 $ 0.700 $ 0.600 $ 0.700 $ 0.600 $ 0.600 $ 0.500 $ 0.500 $ 0.500 $ 0.200 $ 0.150 Set By Contract Energy Conservation Adj./Gallon 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 NA Environm'llmposition Adj./Gallon NA Weather Normalization Adj./Gallon 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 Total Non-Fuel Charges/Gallon $ 1.470 $ 1.320 $ 0.870 $ 0.770 $ 0.870 $ 0.770 $ 0.770 $ 0.670 $ 0.670 $ 0.670 $ 0.370 $ 0.320 Set By Contract + 0.020 Purchased Gas AdjustmenUGallon 0.520 0.520 0.520 0.520 0.520 0.520 0.520 0.520 0.520 0.520 0.520 0.520 0.520 __ Total Energy Charges/Gallon $ 1.990 $ 1.840 $ 1.390 $ 1.290 $ 1.390 $ 1.290 $ 1.290 $ 1.190 $ 1.190 $ 1.190 $ 0.890 $ 0.840 0.540 + Contract NFE Note: No Monthly Minimum Bill Utility 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 FuellTherm 0.359 0.359 0.359 0.359 0.359 0.359 0.359 0.359 0.359 0.359 0.359 0.359 0.359 Change from 01/01 Gallon Rate $(0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.411) $ (0.460) % Chan e - 0 - 0 - 0 -32.9% -46.0%