Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE NOVEMBER 1, 2000
I I RECEIVED NOV 022000 CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet CITY CLERK DEPARTMENT TO: Bill Horne, Interim City Manager 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 NOVEMBER 1, 2000 DATE: October 30, 2000 Natural and Propane (LP) Gas supply prices remain at historic high levels and have continued to rise. The result, based on our forecasts for pricing through the end of the fiscal year, requires us to recommend an increase in our Purchased Gas Adjustment (PGA) of another 3.0C per therm for natural gas and an increase our Propane (LP) PGA of another 5.0C per gallon. We are not recommending the changing of our Energy Conservation Adjustment (ECA) nor our Environmental Imposition Adjustment (ECA) at this time. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after November 1, 2000: Natural Gas Firm Standard Rate Schedule PGA ....... $0.630 per therm (up 3.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.540 per therm (up 3.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.850 per gallon (up 5.0C/gallon) = $0.929 per therm equivalent (up 5.5C/therm) Energy Conservation Adjustment (ECA) ............... $0.110 per therm (no change) = $0.101 per gallon of LP (no change) 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 (no change) = $0.000 per gallon of LP (no change) :1/- /D:l-u/ 0 ) I Bill Horne, Interim City Manager Page 2 I October 30, 2000 Attachment #1 shows the CGS Summary of Rate Adjustment Clause Collections through FY 99/00 year-end, which is under-collected by a total of ($97,291). 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 ($451,997), and we project our natural gas PGA will under-recover another ($60,000) in October. This is another factor holding our recovery clauses high. Attachment #2 shows our PGA Calculations with new projections for the cost of Natural Gas supply gas. Attachment #3 shows our monthly FY 00/01 Natural Gas Purchased Gas Supply Cost Projections. Attachment #4 shows our FY 99/00 fiscal year-to-date history of LP Gas supply costs and current LP supply costs. Finally, Attachments #5 and #6 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 November 1 st billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: j5J1 ~ Bill Horne, Interim City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for November 2000.doc CLEARWATER GAS SYSTEM Attachment #1 . SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Page 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 RatelTherm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) FirmlContr 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 $ 116,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.74) .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-1'" Jul-OO $ 66,880.96 $ 607,101.30 $ 5.69 $ 22,704.33 $ 696,692.28 $ 625,209.49 $ (71,482.79) $ (72,620.13) .545/.450 Aug-OO $ 67,283.40 $ 563,628.85 $ 363.10 $ 22,034.48 $ .653,309.83 $ 597,486.34 $ (55,823.49) $ (128,443.63) .545/.450 Sep-OO $ 77,136.32 $ 595,677.48 $ 642.22 $ (28,857.63) $ 644,598.39 $ 623,810.51 $ (20,787.88) $ (149,231.50) .545/.450 Sep-OO Transfer from WNA $ - $ 11,258.19 $ 11,258.19 $ (137,973.31) Total YTD $1,341,120.83 $ 5,840,444.53 $ 7,352.59 $ 709,944.28 $ 7,898,862.23 $ 7,728,043.39 $(170,818.84) (1) Includes WNA shortage of ($8,213.82) (2) Includes annual CCS charge of $186,200 & annual Adm fee of $63,800 (3) Odorizers, FMNGA dues,CCS, PGA adj , etc. (4) Employee retirement costs $73,408, $16,000 gate station engineering (5) addl ccs charge PROPANE CLPl GAS PURCHASED GAS ADJUSTMENT CPGA-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/.5i.. 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,583.78 $ 46,655.43 $ 4,071.65 $ (28,053.35) .962/.88 Mar-OO I 51,547.4 $ 0.76722 $ 140.27 $ 39,548.20 $ 39,688.46 $ 43,347.35 $ 3,658.89 $ (24,394.46) .962/.88 Apr-OO 43,444.6 $ 0.70396 $ 121.97 $ 30,583.26 3 $ 30,705.23 $ 33,832.74 $ 3,127.51 $ (21,266.95) .842/.77 May-OO 52,084.5 $ 0.65062 $ 106.33 $ 33,887.22 $ 33,993.55 $ 40,114.05 $ 6,120.50 $ (15,146.46) .842/.77 Jun-OO 37,090.1 $ 0.65318 $ 75.73 $ 24,226.51 $ 24,302.24 $ 28,197.03 $ 3,894.79 $ (11,251.67) .8201.75 Jul-OO 22,771.8 $ 0.67869 $ 56.26 $ 15,454.99 $ 15,511.25 $ 16,894.68 $ 1,383.43 $ (9,868.24) ,8201.75 Aug-OO 33,818.5 $ 0.68232 $ 49.34 $ 23,075.04 $ 23,124.38 $ 25,179.14 $ 2,054.76 $ (7,813.48) .8201.75 Sep-OO 24,736.6 $ 0.71588 $ 39.07 $ 17,708.44 $ 17,747.50 $ 18,530.97 $ 783.47 $ (7,030.01) .7501.750 Total YTD 470,240.7 $ 0.65007 $ 1,243.36 305,687.17 $ 325,440.52 $ 334,390.02 $ 8,949.50 Cost Center Expenses CCS Chg Adj at per 5 fm 6,100 8,370.00 1 Analog phone line for software 300.00 2 Software support 1140 (12x95) 1,140.00 1 Suburban maint agmt 1,140.00 3 Admin fee & Fuel 9,000.00 2 9,732.96 age U :\windowslmsoffice\excellgasf20( sheet recovery) Attachment #1 Page 2 of 3 ENERGY CONSERVATION ADJUSTMENT fECAl 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. 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 $ 170,119.51 $134,277.12Conv&BiII AlowFY99$23000Promo $ 2,017.29 $ 172,136.80 $ 71,333.84 $(100,802.96) $ (504,261.89) .0601.055 Mar-OO $ 40,440.81 $31,880 Promo Exp $ 2,521.31 $ 42,962.12 $ 65,090.92 $ 22,128.80 $ (482,133.09) .0601.055 Apr-OO $ 30,919.31 Promo $27,103.5 $ 2,410.67 $ 33,329.98 $ 98,929.37 $ 65,599.39 $ (416,533.69) .1201.110__ May-OO $ 39,238.42 Promo 9,238.42 $ 2,082.67 $ 41,321.09 $ 88,265.39 $ 46,944.30 $ (369,589.39) .1201.110 Jun-OO $ 105,879.97 Promo$45,058.04,Employ Costs$53, 186.71 ,adv $ 1,847.95 $ 107,727.92 $ 76,178.69 $ (31,549.23) $ (401,138.62) .1201.110 Jul-OO $ 34,000.09 Promo$25,438.52,Employ Costs$6660.12,adv $ $ 2,005.69 $ 36,005.78 $ 71,472.29 $ 35,466.51 $ (365,672.11 ) .1201.110 Aug-OO $ 22,338.64 Promo$13429.00,Employ Costs$8909.64 $ 1,828.36 $ 24,167.00 $ 69,202.84 $ 45,035.84 $ (320,636.27) .1201.110 Sep-OO $ 41,115.64 Promo$3629.3,Employ Costs$7486.34 $ 1,603.18 $ 42,718.82 $ 69,099.14 $ 26,380.32 $ (294,255.95) .1201.110 Total YTD $ 644,113.68 $25,116.56 $ 669,230.24 $ 819,662.12 $ 150,431.88 - 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.0~ Mar-OO $ 36.00 $ - $ 36.00 $ 10,851.38 $ 10,815.38 $ 367,991.49 .0101.009 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 $ 1,212.89 $ - $ 1,212.89 $ 0.40 $ (1,212.49) $ 354,932.19 .0001.000 Sep-OO $ 197.86 $ - $ 197.86 $ (28.73) $ (226.59) $ 354,705.60 .0001.000 Sep-OO $ - $ - $ - $ 354,705.60 Total YTD $ 36,036.27 $ - $ 36,036.27 $ 58,411.23 $ 22,374.96 U:lwindowslmsofficelexcellgasf20( sheet recovery) Attachment #1 Page 3 of 3 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) .485/.671 Jan-OO $ 892,974.41 $ 886,881.58 $ (6,092.83) $ (359,006.87) .485/.671 Feb-OO $ 996,185.34 $ 945,350.33 $ (50,835.01) $ (409,841.88) .485/1.03:Z- Mar-OO $ 851,566.20 $ 897,409.41 $ 45,843.21 $ (363,998.66) .485/1.032 Apr-OO $ 502,345.75 $ 790,122.22 $ 287,776.47 $ (76,222.19) .555/.962 May-OO $ 699,564.09 $ 709,573.87 $ 10,009.78 $ (66,212.41) .555/.962 Jun-OO $ 744,312.94 $ 753,958.72 $ 9,645.78 $ (56,566.64) .665/.97 Jul-OO $ 749,004.12 $ 713,554.95 $ (35,449.17) $ (92,015.81) .665/.97 Aug-OO $ 701,814.10 $ 691,868.72 $ (9,945.38) $ (101,961.19) .665/.97 Sep-OO $ 705,262.57 $ 711,411.89 $ 6,149.32 $ (95,811.87) .665/.87 Total YTD $ 8,929,569.27 $ 8,940,506.76 $ 10,937.49 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!. $ - $ (149,800.00) Oct-99 $ - $ (149,800.00) Nov-99 $ - $ (149,800.00) - Dec-99 $ - $ (149,800.00) Jan-OO $ - $ (149,800.00) Feb-OO $ (149,800.00) Mar-OO $ - $ (149,800.00) Apr-OO $ - $ (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) .0301.027 - Jul-OO 22,771.8 $ 548.65 $ 0.026 1,355,481.7 $ 0.030 $ 40,775.59 $ (68,954.95) .0301.027 Aug-OO 33,818.5 $ 344.77 $ 0.027 1,274,600.4 $ 0.030 $ 38,822.43 $ (30,132.53) .0301.027 Sep-OO 24,736.6 $ 150.66 $ 0.027 1,357,860.8 $ 0.030 $ 41,390.71 $ 11,258.19 .030/.027 Sep-OO Trsf to PGA $ (11,258.19) $ (0.00) Total YTD 118,416.9 2,545.84 5,367,526.8 $ 161,058.19 U:\windows\msoffice\excel\gasf20( sheet recovery) I I ATTACHMENT #2 CSW: 1 0/30/00 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 11/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) = $0.090 II. Calculation of the Required Natural Gas PGA WACOG for FY 00101 A. Therm Sales Projection for 10/1/00 - 9130101 = 20,200,000 B. Projected NG Reservation Cost 10/1/00 - 9130101 = $ Projected NG Commodity Cost 10/1/00 - 9130101 = $ 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 = $ 1,350,000 9,350,000 580,000 11,280,000 200,000 11,480,000 C. Required Weighted Average Recovery Costffherm = $ 0.568 40.0% Standard = 8,080,000 Therms @ 60.0% Non-Standard = 12,120,000 Therms @ 100.0% 20,200,000 Therms $ $ WACOG 0.630 0.540 = Recovery $ 5,090,400 $ 6,544,800 $ 11,635,200 $ 10,812,725 $ 822,475 $ 11,635,200 = D. Projected NG PGA Annual Revenue = Pinellas NG PGA = Pasco NG PGA = Total NG PGA = III. Required Natural Gas PGA Billing Factors for 10101/00 - 3131101 A. Required Standard Rate PGA Billing Factor for the Year $ 0.630 B. Less Non-Standard Differential for Reservation Cost $ (0.090) C. Required Non-Standard PGA Billing Factor $ 0.540 C:IDocumenls and SellingslcwarringlDeskloplNew BriefcaseIMy DocumentslEXCEllGASRATESIFY ~1\[PGA for 1st HaW of FY OO..Q1 Rev for 11..Q0.xls]PGACAlC ,4rrfJ,Ctfm6!01 };Io 3 CLEARWATER FY99/00 PURCHASED GAS COST PROJECTIONS AS OF Based on Actual OTH's Sold 10/26/00 Phasoll Contract Capacity Por Month Equlvalont Rollnqulshed Capacity Per Month Dollars -.. Phaso III Contract Capacity Per Monlh Phaso II Available Capacity Per Month Phase III Available Capacity Per Month Contract NNTS Per Month Projected Sold Per Month % of Purchased Gas lost Purchased Por Monlh Sold Per Month Sold Gas (PGA rovonues) Ocl-oO Nov-oO Doc-oO Jan.Q1 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 232 376 41,788 $ (5 629.50) 118164 0 15,500 156000 138 000 100.00% 306570 53 430 $ (5 629.50) 171000 0 22 500 189000 156000 316789 55,211 $ (3 753.00) 156000 0 31000 216000 189,000 316789 55,211 $ (11,259.00) 171,000 0 46,500 201000 216,000 286 132 49,868 $ (5 629.501 114000 0 42,000 222 000 201 000 316789 55211 $ (5 629.501 182000 0 31,000 190 000 222000 306 570 53,430 $ (33 777.001 203 000 0 22,500 157000 190,000 144212 41,788 $ (3 753.001 46 000 0 12,400 140 000 157000 139 560 40 440 $ (22 518.00) 43 000 0 10,500 137,000 140,000 144,212 41 788 $ (23,268.60) 49 000 0 10.850 13 7 000 137,000 144212 41 788 $ (23 268.60) 49 000 0 10,850 13 7 000 137.000 139 560 40 440 $ (22 518.00) 36 000 0 12,000 144 000 13 7 000 Total 2,793,771 570,393 ($166,633.20) 1,338,164 o 267,600 2,026,000 100.00% $ Total Reservation Phase II Volumes Per Month Projected Transp. Phase II Volumes Per Month Projected NNTS Phase II Volumes Per Month Total Reservation Phase III Volumes Per Month Projected Transp. Phase III Volumes Per Month Total Commodity Cosl Per Month FGU Management fee Per Month WACOG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Total Billing :From FGU + Infinite Adjustments Per Month Fuel Cost (Fuel Retention) $ 87,210.71 $ 4,854.01 $ 914.50 $ 32 109.90 $ 1065.59 $ 847837.99 $ $ 24246.13 $ 5973.75 $ 6.17 $ 56.90% $ 962,443.60 $ 115,055.72 $ 5,761.73 $ 1,327.50 $ 41,055.61 $ 1352.47 $ 899911.56 $ $ 25 678.87 $ 7,492.50 $ 5.56 $ 52.50% $1,051,720.89 $ 118,890.91 $ 6 833.53 $ 1.829.00 $ 42 424.13 $ I 407.88 $ 1054648.10 $ $ 30 104.44 $ 8 673.75 $ 5.62 $ 58.05% $1,214,039.15 $ 118,890.91 $ 6,195.03 $ 2 743.50 $ 42 424.13 $ I 407.88 $ 981799.91 $ $ 28018.24 $ 7998.75 $ 5.64 $ 54.03% $ 1, 134.599.45 $ 107,385.34 $ 7,315.61 $ 2,478.00 $ 38.318.57 $ 1,271.63 $ 1 054382.79 $ $ 30066.54 $ 9045.00 $ 5.39 $ 66.07% $1,196,935.20 $ 118890.91 $ 5,728.53 $ 1,829.00 $ 42,424.13 $ 1,407.88 $ 857,990.93 $ $ 24451.77 $ 7503.75 $ 5.34 $ 51.08~. $1 015,505.48 $ 115,055.72 $ 4,401.73 $ 1.327.50 $ 41055.61 $ 1,362.47 $ 678387.70 $ $ 19,319.51 $ 6.052.50 $ 5.11 $ 43.61% $8.:-.13 $ 54,122.76 $ 4,174.01 $ 731.60 $ 32 109.90 $ 1,065.59 $ 594 027.39 $ $ 16.908.79 $ 5,253.75 $ 4.84 $ 75.27% $577,238.65 $ 52.376.87 $ 4 103.80 $ 619.50 $ 31,074.10 $ 1,031.22 $ 582 017.52 $ $ 16,566.10 $ 5152.50 $ 4.70 $ 76.11% $643,570.08 $ 54,122.76 $ 4 046.51 $ 640.15 $ 32,109.90 $ 1 065.59 $ 581,112.57 $ $ 16541.46 $ 5,118.75 $ 4.71 $ 73.66% $644,716.78 $ 54. I 22.76 $ 4,045.51 $ 640.15 $ 32109.90 $ 1,065.59 $ 579 355.30 $ $ 16,490.45 $ 5,118.75 $ 4.69 $ 77.42% $642,959.51 $ 52,376.87 $ 4,401.30 $ 708.00 $ 31.074.10 $ 1,031.22 $ 609.685.59 $ $ 17,351.57 $ 5,467.50 $ 4.66 $ 77.22% $671,326.55 Ocl-oO Nov-oO Dec-oO Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 $ I ,048,502.26 $61.863.30 $ I 5,788.40 $438,289.98 $14,545.02 $9,321,157.44 $0.00 $265,743.87 $78,851.25 $5.260 63.49% $10.657,104.88 Avera~e Total Projected DTH WACOC Total Reservation Total Commodit Cost Sold 1 5t 6 Months $878,672.49 $5,696,571.28 $6,575,243.77 0 #DIVIOI 2nd 6 Months $457274.95 $3,624,586.17 $4,081,861.11 0 #DIVlO! TOTAL $1,335,947.44 $9,321,157.44 $10,657,104.88 #D1V/O! Sold Wacog FYOO 8udget 2078 10,500.000.00 PO amount 157.104.88 over bUdget 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 F:\SUPPl Y\WACOG 2001.xls . I I A TTf1-cJ.JmfC;t0 r fb9- PROPANE INVENTORY AND WEIGHTED COST OF GAS (WACOG) PREPARED BY BRIAN LANGILLE DATE I 10/24100 I LP supplied by Suburban & Texaco Suburban Greg Cope (800) 457-940 Texaco Joe Gump 888-920-0572 Invoice INVENTORY TANK COST OF GALLONS DELIVERED DELIVERED TOTAL NEW Number DATE WITHDRAW INVENT. WACOG INVENT DELIVERED PRICE INVOICE GALLONS WACCG 09/30/00 28,532 53,324 $0.71588 $ 38 173.59 - $ - $ - $ 0.715 8 25164 10/1/00 62 428 $0.72389 $ 45,190.67 9,104 $ 0.76877 $ 7,017.08 9,104 $0.723f 882639 10/3/00 64 432 $0.72576 $ 46,761.57 2,004 $ 0.78400 $ 1 570.90 11,108 $0.725 882640 10/4/00 66,322 $0.72742 $ 48243.72 1,891 $ 0.78400 $ 1,482.15 12,998 $0.727~ 882641 10/6/00 67,999 $0.72881 $ 49,558.80 1,677 $ 0.78400 $ 1,315.08 14,676 $0.7288 882642 10/10/00 70,139 $0.73019 $ 51,214.85 2,140 $ 0.77400 $ 1,656.05 16,815 $0.7301 882643 10/11/00 72,523 $0.73163 $ 53,060.22 2,384 $ 0.77400 $ 1,845.37 19,199 $0.7316 882644 10/13/00 74,313 $0.73337 $ 54,499.22 1,790 $ 0.80400 $ 1 439.00 20,989 $0.7333 882645 10/17/00 76,471 $0.73565 $ 56,255.84 2,158 $ 0.81400 $ 1,756.61 23,147 $0.7356 '- T olal Gallons Max Inv. Gal. Tolal Gallons Withdrawn - - Delivered 23 147 $ 18 082.25 Pounds oer Gal 3.696 Max Pounds 99 - 0.78119 WACOG (FY01) CSW: 1 0/30/00 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Enerav 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 Change from 10/99 Therm Rate % Change from 10/99 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/01/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR NOVEMBER 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 $0.580 $0.580 $0.580 $0.580 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.690 $0.690 $0.690 $0.690 0.630 0.630 0.630 0.630 $1.320 $1.320 $1.320 $1.320 $7.00 $15.00 $20.00 $50.00 Firm Natural Gas Rate Schedules SGS MGS LGS RAC GAC LAC 0- 18,000- 17,999 99,999 $15.00 $20.00 100,000 &up $50.00 $0.350 0.110 0.110 0.000 0.000 0.000 NA(1- NA(O- 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 Reliaht 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.000 0.000 0.000 0.000 0.000 0.000 0.000 NA 0.110 NA $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.310 $0.260 $0.210 $0.310 $0.410 $0.210 $0.580 $0.280 $0.940 $0.840 0.630 0.630 0.630 0.630 0.630 0.630 0.630 0.540 $1.210 $0.820 $0.890 $7.00 @ $15.00 @ $15.00@ premise premise premise $0.069 $0.069 $0.069 $0.470 $0.410 0.000 0.000 0.000 0.110 0.110 $0.940 $1.040 $0.840 $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.208 $ 1.208 $ 1.208 $ 1.208 $ 1.107 $ 1.052 $ 0.997 $ 0.860 $ 0.814 $ 0.769 $ 0.860 $ 0.952 $ 0.769 $ 1.107 $ 0.750 $ 1.280 $ 1.280 $ 1.280 $ 1.280 $ 1.174 $ 1.115 $ 1.057 $ 0.912 $ 0.863 $ 0.815 $ 0.912 $ 1.009 $ 0.815 $ 1.174 $ 0.795 $0.580 $0.520 $0.460 $1.210 $1.150 0.630 0.630 0.630 $1.090 $15.00 $20.00 $50.00 $15.00 +FAC $15.00 $7 Resl./ +FAC $15GS@ premise + FAC $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.255 $ 0.230 23.9% 23.9% 23.9% 23.9% 26.7% 28.5% 30.5% 37.2% 40.2% 43.6% 37.2% 32.5% 43.6% 26.7% 39.0% $0.069 $0.069 $0.069 $0.069 $0.561 $0.561 $0.561 $0.561 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) Firm Service Rates Interruptible Service Rates 1 0/00 11/00 $0.069 $0.069 $0.561 $0.561 02/01 03/01 $0.069 $0.561 $0.561 $0.561 $0.561 $0.069 $0.069 $0.069 $0.069 $0.485 $0.561 $0.055 $0.561 $0.561 $0.561 08/01 09/01 Attachment #5 Contract NG Rate ~ NA By Contract - By Contract NA NA 0.000 Contract + $0.000 Plus 0.540 $0.540 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # ofTherms _J $ 0.230 74.2% $0.069 $0.471 12/00 01/01 1.049 1.050 1.028 1.030 04/01 05/01 06/01 07/01 CSW: 1 0/30100 Attachment #6 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 NOVEMBER 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 EnerQV CharQes/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 Adjustment/Gallon 0.850 0.850 0.850 0.850 0.850 0.850 0.850 Total Energy Charges/Gallon $2.351 $2.351 $1.151 $1.101 $1.051 $1.341 $0.850 + 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 10101173 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm $0.689 $0.689 $0.689 $0.689 $0.689 $0.689 $0.689 Change from 10/99 Gallon Rate % Change from 10/99 Gallon Rate $ 0.337 16.7% $ 0.337 16.7% $ 0.337 41.4% $ 0.337 44.1% $ 0.337 47.2% $ 0.337 33.6% $ 0.300 54.5% . ~ . CSW: 1 0/30100 Attachment #6 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 NOVEMBER 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 o - 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 - 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 Enerqy Charqes/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.850 0.850 0.850 0.850 0.850 0.850 0.850 0.850 0.850 0.850 0.850 0.850 0.850 - - - Total Energy Charges/Gallon $ 2.251 $ 2.101 $ 1.651 $ 1.551 $ 1.651 $ 1.551 $ 1.551 $ 1.451 $ 1.451 $ 1.461 $ 1.151 $ 1.101 0.850 - + Contract NFE Note: No Monthly Minimum Bill Utilitv 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.689 0.689 0.689 0.689 0.689 0.689 0.689 0.689 0.689 0.689 0.689 0.689 0.689 Change from 10/99 Gallon Rate $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.337 $ 0.300 % Change from 10/99 Gallon Rate 17.6% 19.1% 25.6% 27.8% 25.6% 27.8% 27.8% 30.3% 30.3% 30.3% 41.4% 44.1% 54.5%