Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2000
I 1 RE:CEIVE . SEP 14 2000 CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet TO: Bill Horne, Interim City Manager p) FROM: Chuck Warrington, Managing Director, SBS COPIES: Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2000 DATE: September 13, 2000 This is the time of year when we forecast our fuel and other adjustment clause pricing for the new fiscal year. The good news is that Weather Normalization has essentially played out, and we are recommending you approve discontinuing this adjustment and transferring the residual balance into Natural Gas PGA. The less than good news is that Natural Gas fuel prices have remained at historic peak levels and Propane (LP) Gas fuel prices have remained higher than normal and are beginning to rise. The result, based on our forecasts for pricing through the next year, requires us to recommend an increase in our Firm Purchased Gas Adjustment (PGA) of 5.5C per therm for natural gas and an increase our LP PGA of 5.0C per gallon. We are also recommending a reduction in our Energy Conservation Adjustment (ECA) of 1 C per therm, and are recommending continuing to not collect on our Environmental Imposition Adjustment (ECA) as it remains in an over collected position due to the insurance claim reimbursements. The overall result is an increase in our typical residential customer's natural gas rate of 1.5C per therm from September's rate and an increase in our typical residential LP customer's rate of 1.4C per gallon. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after October 1, 2000: Natural Gas Firm Standard Rate Schedule PGA ....... $0.600 per therm (up 5.5C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.510 per therm (up 6.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.800 per gallon (up 5.0C/gallon) = $0.874 per therm equivalent (up 5.4C/therm) J 1'-) ():2~O I / :\ II ) ~i11 Horne, Interim City Managlr Page 2 1 September 11, 2000 Energy Conservation Adjustment (ECA) ............... $0.110 per therm (down 1.0C/therm) = $0.101 per gallon of LP (down 0.9C/gallon) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) = $0.000 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... $0.000 per therm (down 3.0C/therm) = $0.000 per gallon of LP (down 2.7 C/gallon) Attachment #1 shows the CGS Summary of Rate Adjustment Clause Collections, which we are projecting to be in surplus by fiscal year end by a total of $60,679. This is $46,070 better than the beginning balance in 10/1/99, which positively impacts our bottom line financials. Please note that this includes the Manufactured Gas Plant insurance claim recoveries. The projected balance without the surplus in the Environmental Imposition Adjustment (EIA) bucket is really ($401,824), which is another factor holding our recovery clauses high. Attachment #2 shows our PGA Calculations. You will note that we are recommending your approval of a 9.0C/therm differential between the Firm (Standard) Rate PGA and the Natural Gas Interruptible & Contract (Non-Standard) Rate Schedule PGA. Attachment #3 shows our calculations for the requirements for the ECA and EIA Adjustments. Attachment #4 shows our FY 00/01 Natural Gas Purchased Gas Supply Cost Projections. Attachment #5 shows our FY 00/01 fiscal year-to-date history of LP Gas supply costs and current LP supply costs. Finally, Attachments #6 and #7 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. It is our plan to use the above-proposed adjustments for billings through March 31, 2001, 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 October 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for October 2000.doc CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS PaQe 1 of 3 I 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 Rate/Therm Month Charges Charges Expen~e Expenses Expenses Billed (Shortage) (Shortage) Firm/Contr Prior Year (1 ) $ - $ 21,587.34 Oct-99 $ 100,449.03 $ 314,814.63 $ 29,518.69 $ 444,782.35 $ 462,757.77 $ 17,975.42 $ 39,562.76 .415/.310 Nov-99 $ 157,602.47 $ 379,330.86 $ 274,667.64 (2) $ 811,600.97 $ 528,442.35 $(283,158.62) $ (243,595.86) .415/.310 Dec-99 $ 163,854.55 $ 463,206.88 $ 1,217.98 $ 9,057.56 $ 637,336.97 $ 631,372.39 $ (5,964.58) $ (249,560.44) .415/.310 Jan-OO $ 164,417.53 $ 605,949.94 $ 1,247.80 $ 26,581.70 $ 798,196.97 $ 777,955.55 $ (20,241.42) $ (269,801.86) .415/.310 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,702.75) .415/.310 Mar-OO $ 150,707.16 $ 490,203.49 $ 1,173.51 $ 126,795.45 (4) $ 768,879.61 $ 778,119.76 $ 9,240.15 $ (225,462.60) .415/.310 Apr-OO $ 1.16,187.65 $ 319,486.33 $ 1,127.31 $ (1,280.75) $ 435,520.54 $ 656,367.84 $ 220,847.30 $ (4,615.31) .435/.340 May-OO $ 66,674.31 $ 460,622.69 $ 23.08 $ 90,051.38 (5) $ 617,371.46 $ 581,408.02 $ (35,963.44) $ (40,578.75) .435/.340 Jun-OO $ 65,176.11 $ 498,929.54 $ 202.89 $ 45,889.62 $ 610,198.16 $ 649,639.56 $ 39,441.40 $ (1,137.35) .545/.450 Jut-OO $ 66,880.96 $ 607,101.30 $ 5.69 $ 22,704.33 $ 696,692.28 $ 625,209.49 $ (71,482.79) $ (72,620.14) .545/.lIti@ot Aug-OO $ 67,000.00 $ 605,000.00 $ 400.00 $ 25,000.00 $ 697,400.00 $ 684,922.50 $ (12,477.50) $ (85,097.64) .545/.450 Sep-OO $ 67,000.00 $ 605,000.00 $ 500.00 $ 25,000.00 $ 697,500.00 $ 684,922.50 $ (12,577.50) $ (97,675.14) .545/.450 Total YTD $1,330,701.11 $ 5,891,138.20 $ 7,247.28 $ 766,767.43 $ 7,995,854.02 $ 7,876,591.54 $( 119,262.48) (1) Includes WNA shortage of ($8,213.82) (4) Employee retirement costs $73,408, $16,000 gate station engineering (2) Includes annual CCS charge of $186,200 & annual Adm fee of $63,800 (5) CCS $70,000 (3) Odorizers, FMNGA dues,CCS, PGA adj, etc. I 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) Prior Year $ - $ - $ - $ - $ (15,979.51) Oct-99 28,306.7 $ 0.54016 $ 79.90 $ 15,290.15 1 $ 24,880.04 $ 14,968.76 $ (9,911.28) $ (25,890.79) .601/.55 Nov-99 32,549.3 $ 0.58372 $ 129.45 $ 18,999.68 $ 19,129.13 $ 17,901.56 $ (1,227.57) $ (27,118.37) .601/.55 Dec-99 40,667.6 $ 0.61168 $ 135.59 $ 24,875.56 $ 25,011.15 $ 22,366.65 $ (2,644.50) $ (29,762.87) .601/.55 Jan-OO 48,585.6 $ 0.58896 $ 148.81 $ 28,614.97 $ 28,763.79 $ 26,401.66 $ (2,362.13) $ (32,124.99) .601/.55 Feb-OO 54,638.0 $ 0.61172 $ 160.62 $ 33,423.16 2 $ 42,883.78 $ 46,655.43 $ 3,771.65 $ (28,353.34) .962~ Mar-OO 51,547.4 $ 0.76722 $ 141.77 $ 39,548.20 $ 39,689.96 $ 43,347.35 $ 3,657.39 $ (24,695.96) .962/.88 Apr-OO 43,444.6 $ 0.70396 $ 123.48 $ 30,583.26 3 $ 31,846.74 $ 33,832.74 $ 1,986.00 $ (22,709.96) .842/.77 May-OO 52,084.5 $ 0.65062 $ 113.55 $ 33,887.22 $ 34,000.77 $ 40,114.05 $ 6,113.28 $ ( 16,596.68) .842/.77 Jun-OO 37,090.1 $ 0.65318 $ 82.98 $ 24,226.51 $ 24,309.49 $ 28,197.03 $ 3,887.54 $ (12,709.14) .820/.75 Jut-OO 22,771.8 $ 0.67869 $ 63.55 $ 15,454.99 $ 15,518.54 $ 16,894.68 $ 1,376.14 $ (11,333.00) .820/.75 Aug-OO 36,000.0 $ 0.68000 $ 60.00 $ 24,480.00 $ 24,540.00 $ 27,000.00 $ 2,460.00 $ (8,873.00) .820/.75 Sep-OO 36,000.0 $ 0.68000 $ 50.00 $ 24,480.00 $ 24,530.00 $ 27,000.00 $ 2,470.00 $ (6,403.00) .820/.75 Total YTD 483,685.6 $ 0.64890 $ 1,289.71 313,863.69 $ 335,103.40 $ 344,679.91 $ 9,576.51 i Cost Center Expenses CCS Chg Adj at per 5 fm 6,100 8,370.00 1 Software support 1140 (12x95) 1,140.00 1 Admin fee & Fuel 9,000.00 2 Analog phone line for software 300.00 2 Suburban maint agmt 1,140.00 3 18,510.00 . ra!:jc U :lwindowslmsofficelexcellgasf20( sheet recovery) Attachment #1 PaQe 2 of 3 . ENERGY CONSERVATION ADJUSTMENT CECA) Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGlTherm Month Expenses NoteslExceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ (444,687.83) Oct-99 $ 27,901.00 $17,813 appl ECA, Float $2,500 $ 2,223.44 $ 30,124.44 $ 37,828.97 $ 7,704.53 $ (436,983.30) .0601.055 Nov-99 $ 61,755.73 CCS Chg, Admin Chg,$17607Appl $ 2,184.92 $ 63,940.65 $ 44,379.97 $ (19,560.68) $ (456,543.98) .0601.055 Dec-99 $ 19,981.38 $12,911.02 Promo Exp $ 2,282.72 $ 22,264.10 $ 57,134.47 $ 34,870.37 $ (421,673.61 ) .0601.055 Jan-OO $ 50,423.18 $41,165.53 Promo Exp $ 2,108.37 $ 52,531.55 $ 70,746.23 $ 18,214.68 $ (403,458.92) .0601.055 Feb-OO $ 167,921.66 $132,349.27Conv&Bill AlowFY99$23000Promo $ 2,017.29 $ 169,938.95 $ 71,333.84 $ (98,605.11) $ (502,064.04) .0601.055 Mar-OO $ 40,440.81 $31,880 Promo Exp $ 2,510.32 $ 42,951.13 $ 65,090.92 $ 22,139.79 $ (479,924.25) .0601.055 Apr-OO $ 30,919.31 Promo $27,103.5 $ 2,399.62 $ 33,318.93 $ 98,929.37 $ 65,610.44 $ (414,313.81) .1201.110 May-OO $ 39,238.42 Promo 9,238.42 CCS $30,000 $ 2,071.57 $ 41,309.99 $ 88,265.39 $ 46,955.40 $ (367,358.41) .1201.110 Jun-OO $ 105,879.97 Promo$45,058.04;Sal$53, 186.71 ;Adv$2700 $ 1,836.79 $ 107,716.76 $ 76,178.69 $ (31,538.07) $ (398,896.48) .1201.110 Jul-OO $ 34,000.09 Promo$25,438.52, Employ Costs$6660.12Adv $ 1,994.48 $ 35,994.57 $ 71,472.29 $ 35,477.72 $ (363,418.76) . 120/:TTCJ"" Aug-OO $ 45,000.00 $ 1,800.00 $ 46,800.00 $ 77,036.40 $ 30,236.40 $ (333,182.36) .1201.110 Sep-OO $ 45,000.00 $ 1,600.00 $ 46,600.00 $ 77,036.40 $ 30,436.40 $ (302,745.96) .1201.110 Total YTD $ 668,461.55 $25,029.52 $ 693,491.07 $ 835,432.94 $ 141,941.87 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. Prior Year $ - $ - $ - $ 332,330.64 .0101.009 Oct-99 $ 85.00 $ - $ 85.00 $ 6,303.53 $ 6,218.53 $ 338,549.17 .0101.009 Nov-99 $ 6,400.00 Admin Chg $ - $ 6,400.00 $ 7,396.52 $ 996.52 $ 339,545.69 .0101.009 Dec-99 $ 984.95 $ - $ 984.95 $ 9,522.13 $ 8,537.18 $ 348,082.87 .0101.009 Jan-OO $ 13,482.10 Environ Consultant $ - $ 13,482.10 $ 11,778.14 $ (1,703.96) $ 346,378.91 .0101.009 Feb-OO $ 1,090.05 $ - $ 1,090.05 $ 11,887.25 $ 10,797.20 $ 357,176.11 .0101.009 Mar-OO $ 36.00 $ - $ 36.00 $ 10,851.38 $ 10,815.38 $ 367,991.49 .0101.'lJ'lJ9 Apr-OO $ 2,790.00 CCS Share Chg $ - $ 2,790.00 $ 992.27 $ (1,797.73) $ 366,193.76 .0001.000 May-OO $ 6,877.99 Environ Consultant $ - $ 6,877.99 $ (213.59) $ (7,091.58) $ 359,102.18 .0001.000 Jun-OO $ 2,084.62 $ - $ 2,084.62 $ (56.56) $ (2,141.18) $ 356,961.00 .0001.000 Jul-OO $ 794.81 $ - $ 794.81 $ (21.51 ) $ (816.32) $ 356,144.68 .0001.000 Aug-OO $ 5,000.00 $ - $ 5,000.00 $ - $ (5,000.00) $ 351,144.68 .0001.000 Sep-OO $ 5,000.00 $ 5,000.00 $ - $ (5,000.00) $ 346,144.68 .0001.000 Sep-99 $ 5,000.00 $ 5,000.00 $ - $ (5,000.00) $ 341,144.68 .0001.000 Total YTD $ 49,625.52 $ - $ 49,625.52 $ 58,439.56 $ 8,814.04 r-age ~ U :\windowslmsoffice\excel\gasf20( sheet recovery) Attachment #1 PaQe 3 of3 . TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage All Therm Month Expenses Billed (Shortage) (Shortage) NG/LP Prior Year $ - $ - $ - $ (106,749.36) Oct-99 $ 499,871.83 $ 521,859.03 $ 21,987.20 $ (84,762.16) .485/.671 Nov-99 .. $ 901,070.75 $ 598,120.40 $(302,950.35) $ (387,712.51) .485/.671 Dec-99 $ 685,597.17 $ 720,395.64 $ 34,798.47 $ (352,914.04) .4851. 671 Jan-OO $ 892,974.41 $ 886,881.58 $ (6,092.83) $ (359,006.87) .4851. 671 Feb-OO $ 994,287.48 $ 945,350.33 $ (48,937.15) $ (407,944.02) .485/1.032 Mar-OO $ 851,556.71 $ 897,409.41 $ 45,852.70 $ (362,091.32) .485/1.032 Apr-OO $ 503,476.21 $ 790,122.22 $ 286,646.01 $ (75,445.32) .555/.962 May-OO $ 699,560.21 $ 709,573.87 $ 10,013.66 $ (65,431.66) .555/.iii-' Jun-OO $ 744,309.03 $ 753,958.72 $ 9,649.69 $ (55,781.97) .665/.940 Jul-OO $ 749,000.20 $ 713,554.95 $ (35,445.25) $ (91,227.22) .665/.940 Aug-OO $ 773,740.00 $ 788,958.90 $ 15,218.90 $ (76,008.32) .6651.940 Sep-OO $ 773,630.00 $ 788,958.90 $ 15,328.90 $ (60,679.42) .6651.940 Total YTD $ 9,069,074.01 $ 9,115,143.95 $ 46,069.94 WEATHER NORMALIZATION (WNA) Monthly Cumulative WNA Budget Interest ..... . Overage YTDOverage NGlTherm Month LP Gallons Expense Rate/Gallon NG Therms RatelTherm (Shortage) (Shortage) LP/Gal Beg. Ba!. $ 149,800.00 May-OO $ 749.00 $ (749.00) $ 150,549.00 Jun-OO 37,090.0 $ 752.75 $ 0.010 1,379,583.9 $ 0.030 $ 40,818.45 $ 109,730.55 .027/.030 Jul-OO 22,771.8 $ 548.65 $ 0.026 1,355,481.7 $ 0.030 $ 40,775.59 $ 68,954.96 .027/.030 Aug-OO 36,000.0 $ 400.00 $ 0.027 1,390,000.0 $ 0.030 $ 42,272.00 $ 26,682.96 .027/.030 Sep-OO 36,000.0 $ 200.00 $ 0.027 1,390,000.0 $ 0.030 $ 42,472.00 $ (15,789.04) .027/.~ Total YTD 131,861.8 2,650.40 5,515,065.6 $ 166,338.04 CSW:08/23/00 age U :\windowslmsoffice\excel\gasf20( sheet recovery) CSW:09/11100 I I ATTACHMENT #2 Page 1 of2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/00 - 03/31/01 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 00101 A. Therm Sales Projection for 10/1100 - 9130101 ~ B. Projected NG Reservation Cost 10/1/00 - 9130101 = $ Projected NG Commodity Cost 10/1/00 - 9/30101 = $ Budgeted Other Supply Related Expenses = $ Total Recovery Needed for FY 00101 only = $ Projected Under Recovery of FYTD PGA thru 9/00= $ Total Annualized Recovery Needed for FY 00/01 = $ C. Required Weighted Average Recovery CostfTherm = $ 45.0% Standard = 9,090,000 Therms @ 55.0% Non-Standard = 11,110,000 Therms @ 100.0% 20,200,000 Therms D. Projected NG PGA Annual Revenue = III. Required Natural Gas PGA Billing Factors for 10101/00 - 3131/01 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 = $0.090 Recovery $ 5,454,000 $ 5,666,100 $ 11,120,100 $ 10,324,357 $ 795,743 $ 11,120,100 $ 0.600 20,200,000 1,340,000 9,100,000 580,000 11,020,000 100,000 11,120,000 0.550 $ $ WACOG 0.600 0.510 = $ (0.090) = Pinellas NG PGA = Pasco NG PGA = Total NG PGA = $ 0.510 C:IDocuments and SettingslcwamnglDeskloplNew BriefcaseIMy DocumentslEXCELIGASRATES\(PGA for 1s1 HeW of FY 00-01.xls]Analysis of Standard VS. Non-St ATTACHMENT #2 Page 2 of 2 CSW:09/11100 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON-STANDARD THERMS & RESERVATION CHARGES FOR 09/01/99 - 07/31/00 --'" Subtotal Subtotal Net Net Charge Per Charge Per Billing Total Interruptible % Contract % Non-Standard % Non- Standard % Reservation Standard Non-Interruptible Month Therms Therms Interruptible Therms Contract Therms Standard Therms Standard CharQes Therm Therm 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 Dec 1999 1,735,679 304,560 17.5% 504,621 29.1% 809,181 46.6% 926,498 53.4% $ 163,854.55 $ 0.177 $ 0.114 Jan 2000 2,149,865 429,283 20.0% 570,405 26.5% 999,688 46.5% 1,150,177 53.5% $ 164,417.53 $ 0.143 $ 0.096 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 Mar 2000 1,993,267 377,863 19.0% 545,690 27.4% 923,553 46.3% 1,069,714 53.7% $ 150,707.16 $ 0.141 $ 0.093 Apr2000 1,730,907 368,908 21.3% 497,783 28.8% 866,691 50.1% 864,216 49.9% $ 116,187.65 $ 0.134 $ 0.085 May 2000 1,556,268 355,618 22.9% 490,079 31.5% 845,697 54.3% 710,571 45.7% $ 66,674.31 $ 0.094 $ 0.056 Jun 2000 1,379,584 336,040 24.4% 434,574 31.5% 770,614 55.9% 608,970 44.1% $ 65,176.11 $ 0.107 $ 0.062 Jul2000 1,355,482 353,110 26.1% 417,745 30.8% 770,855 56.9% 584,627 43.1% $ 66,880.96 $ 0.114 $ 0.067 Total 8/99-7/00 19,301,711 4,198,235 21.8% 5,542,465 28.7% 9,740,700 50.5% 9,561,011 49.5% $ 1,332,700.05 $ 0.139 $ 0.088 # - For Comparison 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 Change 84,911 (7,353) -0.1% 346,571 1.7% 339,218 1.5% (254,307) -1.5% $ (74,051.47) $ (0.004) $ (0.005) Note: # It is recommended that the "Charge Per Non-Interruptible Therm" differential be rounded to the nearest 0.5 ,cent or $0.090 for the next semi-annual cycle. C:\Documents and Settings\cwarring\Desktop\New Briefcase\My Oocuments\EXCEL\GASRATES\[PGA for 1st Half of FY 00-01.xls}Analysis of Standard VS. Non-St I I CSW:09/11/00 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/00 - 3/31/01 I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 00101 Budgeted ECA Requirements for FY 00101 only = $ 740,000 Projected Current FYTO 9/00 (Over) Under Recovery of ECA = $ 300,000 Total Annualized ECA Recovery Needed during FY 00/01 = $ 1,040,000 Projected Therm Sales for FYOOI01 Applicable to ECA Recovery = 9,341,625 (Natural Gas @ 45% Standard = 9,090,000 therms & LP @ 50% Standard = 275,000 gal. or 9,341,625 Total Applicable Therms) Computed ECA Recovery Factor Necessary = $ 0.1113 Propose Rounding ECA Recovery Rate to $ 0.110 # Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 1,027,579 II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 00/01 Budgeted EIA Requirements for FY 00/01 only = $ 100,000 Projected Current FYTO 9/00 (Over) Under Recovery of EIA = $ (340,000) Total Annualized EIA Recovery Needed during FY 99/00 = $ (240,000) We are over-recovered in ECA & project to stay over-recovered for the FY 00/01 period. Therefore, EIA needs to be = $ Round Proposed EIA Recovery Rate to $ Annual ECA Revenue Projection @ Proposed Recovery Rate = $ C:IDocuments and Settings\cwamngIDesktoplNew BriefcaseIMy DocumentslEXCELIGASRATES\(ECA & EIA for 1st Half of FY OO-01.xls]Sheet1 ATTACHMENT #3 CLEARWATER FY99/00 PURCHASED GAS COST PROJECTIONS AS OF Based on Actual DTH's Sold Phase II Conltact Capaclly Per Month Equivalent Relinquished Capaclly Per Month Dollars Conltact NNTS Per Month Phase III Conltact Capaclly Per Month Phase II Available Capaclly Per Month Phase III Available Capaclly Per Month IIr/4C# m "E-;Jr #; f-. 9/7/00 Purchased Per Month Projected Sold Per Month Sold Gas (PGA revenues) ..... % of Purchased Gas lost Sold Per Month Oct.(lO Nov..oo Dec-lJO Jan-lJl Feb-lJl Mar-lJl Apr-lJl May-lJl Jun-lJl Jul-lJl Aug-lJl Sep-lJl 232376 41 788 $ (5 629.50) 114164 0 15500 160 000 100.00% 306570 53 430 $ (5.629.50) 170,000 0 22 500 190 000 316789 55211 $ (3 753.00) 172 000 0 31000 200 000 316789 55211 $ (11 259.00) 142000 0 46 500 230 000 286 132 49 868 $ (5,629.50) 146000 0 42 000 190 000 316789 55211 $ (5 629.50) 192 000 0 31000 180000 306 570 53 430 $ (33 777.00) 190 000 0 22 500 170,000 144 212 41 788 $ (3 753.00) 41000 0 12400 145 000 139 560 40 440 $ (22 518.00) 48 000 0 10500 132 000 144 212 41 788 $ (23268.60 55 000 0 10850 131 000 144212 41,788 $ (23 268.60) 46 000 0 10850 140 000 139560 40 440 $ (22 518.00) 35 000 0 12000 145000 Total 2,793,771 570,393 ($166,633.20) 1,351,164 Total Reservation Phase II Volumes Per Month Projected Transp. Phase II Volumes Per Month Projected NNTS Phase II Volumes Per Month Total Reservation Phose III Volume. Per Month Projected Trensp. Phase III Volumes Per Month Total Commodity Cost Per Month Adjustments Per Month 267,600 2,013,000 o 100.00% $ Fuel Cost (Fuel Retention) FGU Management fee Per Month Total Billing From FGU + Infinite WACOG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Oct-lJO Nov-lJO Dec-lJO Jan-lJl Feb-lJl Mar-lJl Apr-lJl May-lJl Jun-lJl Jul-lJl Aug-lJl Sep-lJl $ 87210.71 $ 5024.01 $ 914.50 $ 32 109.90 $ 1 065.59 $ 772 052.63 $ $ 22 035.78 $ 6,153.75 $ 5.54 $ 58.36%. ' 886,658.24 $ 115055.72 $ 5 804.23 $ 1 327.50 $ 41055.61 $ 1 362.47 $ 930664.33 $ $ 26569.14 $ 7537.50 $ 5.70 $ 52.78% $1,082,473.66 $ 118890.91 $ 6 153.53 $ 1 829.00 $ 42 424.13 $ 1 407.88 $ 998310.66 $ $ 28 509.50 $ 7953.75 $ 5.79 $ 53.76% $1,157,701,71 $ 118,890.91 $ 7428.53 $ 2 743.50 $ 42424.13 $ 1 407.88 $ 1 142007.37 $ $ 32 595.71 $ 9,303.75 $ 5.63 $ 61,83% $1,294,806.92 $ 107.385.34 $ 5955.61 $ 2478.00 I $ 38318.57 $ 1 271,63 $ 894 430.35 $ $ 25504.10 $ 7,605.00 $ 5.46 $ 56.55% $1,036,982.76 $ 118890.91 $ 5 303.53 $ 1 829.00 $ 42,424.13 $ 1 407.88 $ 800 705.74 $ $ 22814.07 $ 7053.75 $ 5.32 $ 48.39% $958,220.28 $ 115055.72 $ 4954.23 $ 1 327.50 $ 41055.61 $ 1 362.47 $ 717.193.79 $ $ 20413.10 $ 6637.50 $ 4.95 $ 47.22% $840855.63 $ 54 122.76 $ 4,386.51 $ 731.60 $ 32,109.90 $ 1 065.59 $ 597370.50 $ $ 16993.14 $ 5 478.75 $ 4.69 $ - 77.96% $_,76 $ 52376.87 $ 3 891.30 $ 619.50 $ 31,074.10 $ 1 031.22 $ 541.295.58 $ $ 15 396.56 $ 4,927.50 $ 4.57 $ 73.33% $602,848,04 $ 54 122.76 $ 3791,51 $ 640.15 $ 32 109.90 $ 1 065.59 $ 535,862.87 $ $ 15 243.02 $ 4 848.75 $ 4.58 $ 75.27% $599,467.09 $ 54 122.76 $ 4,174.01 $ 640.15 $ 32,109.90 $ 1 065.59 $ 572 985.25 $ $ 16,297.89 $ 5,253.75 $ 4.55 $ 77.96% $636,589.46 $ 52376.87 $ 4443.80 $ 708.00 $ 31,074.10 $ 1031.22 $ 591 265.79 $ $ 16814.27 $ 5512.50 $ 4.50 $ ---. 77.22% $652,.906,75 $1.048.502.26 $61.310.80 $15,788.40 $438,289.98 $14,545.02 $9.094.144.85 $0.00 I 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 Total Reservation $878,672.49 Total Commodi $5,538,171.08 1 st 6 Months 2nd 6 Months $457274.95 $3,555,973.77 TOTAL $1,335,947.44 $9,094,144.85 Budget 2078 F:\5UPPLY\WACOG 2001.1(15 $259,186.28 $78,266.25 $5,181 63.39'k $10,430,092.29 Average T alai Projected DTH WACOG Cost Sold $6,416,843.57 #DIV/O! $4,013248.72 #DIV/O! $10,430,092.29 #DIV/O! Sold Wacog FYOO 10.500,000.00 PO amount 69,907.71 under bUdget I I It Tr It c:..N f'i~,j i#-.5 PROPANE INVENTORY ANO WEIGHTEO COST OF GAS ACOG PREPARED BY BRIAN LANGILLE DATE 09/11/00 LP supplied by FerrellRas a, Texaco Date Contract Ends 10/31/00 Ferrell as J. Scott Hedge 644-1416 Texaco Joe Gump 888.920-0572 Invoice INVENTORY TANK COST OF GALLONS OELlVERED DELIVERED TOTAL NEW Number DATE WITHDRAW INVENT. WACOG INVENT DELIVERED PRJCE INVOICE GALLONS WACOG 09/30/99 27166 26 492 $0.64016 $ 14309.98 $ $ $ 0.54016 196471 10/14/99 36.002 $0.56255 $20253.06 9510 $ 0.62493 $ 5943.08 9510 $0.56255 196472 10/14/99 45 293 $0.57535 $ 26 059.28 9291 $ 0.62493 $ 5 806.22 18801 $0.57535 196478 10/18/99 54 498 $0.56372 $ 31811.77 9205 $ 0.62493 $ 5752.48 28 006 $0.58372 Month end 10131/99 30719 23 779 $0.58372 IS 13880.36 $0.68372 196533 11/3199 33 008 $0.59816 $ 19.743.91 9229 $ 0.63534 $ 5 863.55 37 235 $0.59816 196534 11/3/99 42 3a9 $0.60633 $ 25 853.21 9301 $ 0.63534 $ 5 909.30 46 536 $0.60633 196562 11/11/99 51557 $0.60939 $ 31 367.00 9248 $ 0.61784 $ 5713.78 55 784 $0.60939 196563 11/11/99 60715 $0.50982 $ 37025.18 9158 $ 0.61784 $ 5658.18 64 942 $0.60982 196564 11/12/99 89918 $0.61087 $ 42 709.92 9201 $ 0.61784 $ 5684.75 74143 $0.61067 196565 11/12199 79 112 $0.61168 $ 48391.58 9196 $ 0.61784 $ 5681.86 83 339 $0.61168 Month end 11130199 46041 34071 $0.61158 1$ 20840.70 $0.61168 88899 1212199 43 074 $0.60314 $ 25979.64 9.003 $ 0.56877 $ 5 138.94 92 342 $0.60314 88899 1212198 52374 0.59739 $ 31 287.50 9300 $ 0.56877 $ 5307.86 101642 $0.59739 90303 12116199 61875 $0.59214 $ 36 638.62 9501 $ 0.56127 $ 5,351.13 111,143 $0.59214 90303 12116/99 70 875 $0.58848 $ 41 708.55 9.000 $ 0.56127 $ 5.069.93 120143 $0.58848 91472 12/22/99 80 376 $0.58875 $ 47321.46 9,501 $ 0.58877 $ 5612.90 129644 $0.58875 91472 12/22/99 89 877 $0.58896 $ 52934.36 9501 $ a.ssen $ 5812.90 139145 $0.58896 Month end 12131/99 61612 38 265 $0.68896 $ 22 636.73 $0.68896 92156 01/02100 47 266 $0.59359 $ 28.056. n 9001 $ 0.61127 $ 5 520.04 148146 $0.59359 92218 01/03/00 56 268 $0.59674 $ 33 577.42 9002 $ 0.61127 $ 5520.65 157148 $0.59674 94160 01/16100 65 769 $0.60273 $ 39641.12 9501 $ 0.63827 $ 6 063.70 166649 $0.60273 94160 01/16100 74770 $0.60702 $ 45 386.69 9001 $ 0.63627 $ 5745.57 175650 $0.60702 94440 01/18/00 83771 $0.61172 $ 51 244.27 9001 $ 0.64877 $ 5857.58 184651 $0.61172 Month end 01131/00 60 690 33181 $0.61172 $ 20 297.43 SO.61172 96949 02/07/00 42182 $0.66913 $ 28 225.24 9001 $ 0.87877 $ 7927.81 193652 $0.66913 3365 02/04/00 51625 .~ 36 378.70 8443 $ 0.86344 $ 8 153.46 203 095 $0.70467 1614 02/07/00 61121 44 577.93 9.496 $ 0.86344 $ 8.199.23 212591 $0.72934 98317 02/14/00 70124 52 732.57 9003 $ 0.90377 $ 8 154.64 221 594 $0.75199 3498 02122/00 79 629 60559.37 8505 $ 0.82344 $ 7 826.80 231 099 $ll:'f6052 3499 02/22/00 89125 $0.76722 $ 88 378.75 9496 $ 0.82344 $ 7819.39 240 595 $0.76722 Month end 02/29/00 63 219 36 906 $0.76722 $ 27647.91 SO.76722 03/07/00 35 906 $0.77894 $ 21 NlA N/A 420.60 240 595 $0.77894 03/09/00 35 906 $0.77954 $ 27 NlA N/A $ 21.54 240 595 $0.77954 1717 03/13/00 45221 $0.77571 $ 35 9315 $ 0.76094 $ 7 088.16 249910 $0.77571 1722 03114/00 54 588 $0.76802 $ 41 9367 $ 0.73094 $ I 259 277 $0.76802 11798 03119/00 64 088 $0.74842 $ 47964.73 9500 $ 0.63377 $ 268 777 $0.74842 11933 03120/00 73 287 $0.73428 $ 53813.18 9,199 $ 0.63377 $ 277 976 $0.73428 12470 03/28/00 82 387 $0.71761 $ 59121.33 9100 0.58127 $ 287 076 $0.71761 12470 03126100 91887 $0.70371 $ 64 682.00 9500 0.58127 $ 296 576 $0.70371 03/26100 91687 $0.70396 $ 64 684.73 NlA N/A $ 22.73 296 576 $0.70396 Month end 03/31/00 47 489 44 399 $0.70396 I S 31 255.04 $0.70396 13749 04/01100 44 399 11 31277.77 NlA N/A $ 22.73 296 576 $0.70447 Suburban 04/12/00 44422 31 292.13 23.4 $ 0.61360 $ 14.36 296 599 $0.70442 14721 04/21/00 62 426 41 938.53 16004 0.58377 $ 10 548.40 314603 $0.67021 14721 04/23/00 60 627 18201 0,56377. $ 10681.40 332 804 $0.65114 Suburban 04/26/00 62 587 1940 $ 0.62900 $ 1 220.26 334 744 $0.65062 Month end 04/30/00 36,427 47140 30 670.42 $0.66062 511~5/31 67 662 44 087.14 20 522 0.65377 $ 13416.72 365 287 $0.65158 16503 05/30/00 67 862 44109.15 N/A WA $ 22.01 355 267 $0.65190 16502 05/30100 67 682 44 196.77 N/A N/A $ 86.62 355 267 $0.65318 Month end 05/31/00 38719 28 943 18 906.23 $0.66318 17507 06/11100 46 945 31 250.45 18002 0.68377 $ 12 345.23 373 269 $0.66568 17795 06114/00 55 947 $0.66972 $ 37468.76 9002 0.68877 $ 6218.31 382 271 $0.66972 17849 06116100 64 947 $0.67263 $ 43 685.69 9000 0.68877 $ 8216.93 391271 $0.67263 882604 06/02/00 66 720 $0.67360 $ 44 942.25 1772.3 $ 0.70900 $ 1 256.56 393 043 $0.67360 882607 06/07/00 68 457 $0.87468 $ 46 186.09 1737.2 $ 0.71600 $ 1 243.84 394 780 $0.67466 882608 06/09100 70 407 $0.67582 $ 47582.43 1950.2 $ 0.71600 $ 1 396.34 396 730 $0.67582 882605 06/09100 70 459 $0.67585 $ 47619.95 62.4 $ 0.71600 $ 37.52 396 783 $0.67585 16600 06/11/00 70 459 11 47 684.58 NlA NlA $ 84.81 $0.67677 882608 06/14/00 72 260 48891.24 1800.7 I $ 0.70600 $ 1271.29 398 583 $0.87660 882609 06/19/00 74337 50357.75 2 077.2 $ 0.70600 $ 1 466.60 400661 $0.67742 882610 06/21/00 76371 51 747.04 2034.1 $ 0.68300 $ 1 399.29 402,695 $0.67757 882672 06/22100 77 937 52816.56 1585.9 $ 0.68300 $ 1069.51 404 261 $0.67768 882611 06128100 79 890 54 179.67 1952.9 $ 0.69800 $ 1363.12 406214 $0.67818 882612 06/28/00 82 030 55673.46 2140.1 $ 0.69800 $ 1 493.79 408 354 II Month end 06/30/00 27 620 64610 36 996.94 SO. 882614 07/03/00 56 489 $0.67937 $ 38 377.14 1978.8 0.69800 $ 1381.20 410332 :0.66066 882615 07/0s/00 58 746 $0.68066 $ 39986.10 2256.6 0.71300 $ 1 608.96 412589 882616 07/10100 60 508 $0.68134 $ 41 226.69 1762.2 0.70400 $ 1 240.59 414351 $0.68134 882617 07112/00 62 279 $0.68170 $ 42465.90 1771.2 0.69400 $ 1229.21 416122 $0.68170 882616 07113/00 64 207 $0.68207 $ 43 793.45 1927.3 0.69400 $ 1 337.55 416050 $0.68207 682619 07118/00 66.189 $0.68243 $ it 1982.1 0.69400 $ 1 375.58 420 032 $0.68243 882620 07/20/00 68261 $0.68278 $ .99 2072 0.69400 $ 1 437.97 422 104 $0.68278 982622 07/26/00 70 367 $0.68312 $ .55 2106 0.69400 $ , 461.56 424210 $0.68312 882623 07/27/00 72411 $0.68342 $ .09 2044 0.69400 $ 1418.54 426 254 $0.68342 Month end 07/31/00 26 652 46 769 .68342 $ $0.68342 22032 08121/00 84 759 $0.67433 S 43 668.64 18000 0.648705 $ 11 712.70 444.254 $0.67433 882624 08/02100 87120 $0.67502 $ 45307.39 2361.3 $ 0.69400 $ 1638,74 446615 $0.67502 882626 08110100 69431 $0.67565 $ 46 911.58 2311.5 $ 0.69400 $ 1.604.18 448 927 $0.67565 882626 08114/00 71681 $0.87622 $ 48 458.70 2229.3 $ 0.69400 $ 1547.13 451156 $0.67622 682627 08116/00 73.394 $0.67664 $ 49861.47 1733.1 $ 0.69400 $ 1 202.77 452 689 $0.67664 882628 09117/00 76201 $0.67783 $ 50973.35 1807 $ 0.72600 $ 1311.88 454 696 $0.67783 561170 08130/00 77414 &$ 52653.09 2213.1 $ 0.75900 $ 1,679.74 456 909 $0.68015 882630 08/31100 79 470 $ 54 223.64 2055.7 $ 0.76400 $ 1 670.55 458 965 $0.68232 Month end 08131/00 26 843 63 627 $ $ 36 690.46 $0.68232 882631 09106100 55 536 $0. $ 38 085.15 1908.9 0.78300 $ 1 494.67 460874 $0.68578 Total GaRons Max Inv. Gal; Total Gaaon. Withdrawn 431 830 91987 Delivered 460874 $ 307 109.21 Pounds Der Gal 3.696 Max Pounds 99 339.614.35 , 0.66636 WACOG (FYOO) CSW:09/13/00 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Enel'QV CharaelTherm 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 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR OCTOBER 1, 2000 - MARCH 31, 2001 BASED ON APPROVED GAS ADJUSTMENT FACTORS ~ SMF MMF LMF NA (1 - NA (4 + NA (4 + NA (4 + 3 Units) Units) Units) Units) $7.00 $15.00 $20.00 $50.00 Firm Natural Gas Rate Schedules SGS MGS LGS RAC GAC LAC o - 18,000- 17,999 99,999 $15.00 $20.00 100,000 &up $50.00 $0.350 $1.060 $50.00 NA (1 - NA (0 - NA (150 3 Units) 149 tons) tons & +) $7.00 if $15.00 if $15.00 if not prevo not prevo not prevo billed billed billed $0.200 $0.150 $0.100 ~ SL w/M& NGV Rellaht NA NA NA $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.110 0.110 0.110 0.110 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA 0.110 NA $0.470 $0.410 0.110 0.110 0.110 0.110 $0.200 0.110 0.110 0.110 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.110 0.110 $0.690 $0.690 $0.690 $0.690 $0.580 $0.520 $0.460 $0.310 $0.260 $0.210 $0.310 $0.410 $0.210 $0.580 $0.280 $1.290 $1.290 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.600 0.510 $1.180 $0.790 $1.290 $1.290 $7.00 $15.00 $20.00 $50.00 $0.580 $0.580 $0.580 $0.580 $1.180 $1.120 $0.910 $0.860 $0.810 $0.910 $1.010 $0.810 $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.180 $ 1.180 $ 1.180 $ 1.180 $ 1.080 $ 1.025 $ 0.970 $ 0.833 $ 0.787 $ 0.741 $ 0.833 $ 0.924 $ 0.741 $ 1.080 $ 0.723 $ 1.251 $ 1.251 $ 1.251 $ 1.251 $ 1.144 $ 1.086 $ 1.028 $ 0.883 $ 0.834 $ 0.786 $ 0.883 $ 0.980 $ 0.786 $ 1.144 $ 0.766 $0.069 $0.069 $0.069 $0.069 $0.531 $0.531 $0.531 $0.531 BTU FACTOR = THERMS/100 CUBIC FEET ICCF) 10/00 11/00 12/00 01/01 1.049 1.028 $15.00 $20.00 $7.00@ $15.00@ $15.00@ premise premise premise $15.00 +FAC $15.00 $7 Resl./ +FAC $15GS@ premise + FAC Change from 10/99 Therm Rate $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.225 $ 0.200 % Change from 10/99 Therm Rate 21.1% 21.1% 21.1% 21.1% 23.6% 25.1% 26.9% 32.8% 35.4% 38.5% 32.8% 28.7% 38.5% 23.6% 33.9% Utility Tax Note: Fuel Rate per Therm 10/01/73 Non-Utility Taxable FuellTherm Firm Service Rates Interruptible Service Rates $0.069 $0.069 $0.531 $0.531 02101 03/01 $0.069 $0.531 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.055 $0.531, $0.531 $0.531 $0.531 08/01 09/01 $0.455 Attachment #6 Contract NG Rate ~ NA By Contract By - Contract NA NA 0.000 Contract + $0.000 Plus 0.510 $0.510 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms -. $ 0.200 64.5% $0.069 $0.441 $0.531 $0.531 $0.531 04/01 05/01 06/01 07/01 CSW:09/13/00 Attachment #7 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 (NEW CUST. EFF. 3/8/99) Therm Factor: 0.915 Therms/Gallon FOR OCTOBER 1, 2000 - MARCH 31,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 Enemv Charaes/Gallon: prey. billed @ 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.101 0.101 0.101 0.101 0.101 0.101 NA Environm'llmposition Adj. IGallon 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Total Non-Fuel Charges/Gallon $1.501 $1.501 $0.301 $0.251 $0.201 $0.491 By Contract + $0.000 Purchased Gas AdjustmenUGallon 0.800 0.800 0.800 0.800 0.800 0.800 0.800 Total Energy Charges/Gallon $2.301 $2.301 $1.101 $1.051 $1.001 $1.291 $0.800 + 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.639 $0.639 $0.639 $0.639 $0.639 $0.639 $0.639 Change from 10/99 Gallon Rate % Change from 10/99 Gallon Rate $ 0.287 14.3% $ 0.287 14.3% $ 0.287 35.3% $ 0.287 37.6% $ 0.287 40.2% $ 0.287 28.6% $ 0.250 45.5% , . CSW:09/13/00 Attachment #7 Page 2 of 2 STU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM STU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR OCTOBER 1, 2000 - MARCH 31, 2000 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 0-200 > 200 o - 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 - 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 Chal'lles/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.lGallon 0.101 0.101 0.101 0.101 0.101 0.101 0.101 0.101 0.101 0.101 0.101 0.101 NA Environm'llmposition Adj.lGallon - - - - - - - - - - - - NA Weather Normalization Adj.lGallon - - - - - - - - - - - - 0.000 - - - - Total Non-Fuel Charges/Gallon $ 1.401 $ 1.251 $ 0.801 $ 0.701 $ 0.801 $ 0.701 $ 0.701 $ 0.601 $ 0.601 $ 0.601 $ 0.301 $ 0.251 Set By Contract + 0.000 Purchased Gas Adjustment/Gallon 0.800 0.800 0.800 0.800 0.800 0.800 0.800 0.800 0.800 0.800 0.800 0.800 0.800 - - - - Total Energy Charges/Gallon $ 2.201 $ 2.051 $ 1.601 $ 1.501 $ 1.601 $ 1.501 $ 1.501 $ 1.401 $ 1.401 $ 1.401 $ 1.101 $ 1.051 0.800 + Contract NFE -, Note: No Monthly Minimum Bill Utilltv Tax Note: Fuel Rate per Therm 10/01173 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.639 0.639 0.639 0.639 0.639 0.639 0.639 0.639 0.639 0.639 0.639 0.639 0.639 , Change from 10/99 Gallon Rate $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.287 $ 0.250 % Change from 10/99 Gallon Rate 15.00/0 16.3% 21.8% 23.6% 21.8% 23.6% 23.6% 25.8% 25.8% 25.8% 35.3% 37.6% 45.5% ------- ---~---- .