Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MARCH 1, 2002
" I ~ CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet FEB t ;eont: .r i;; ~ ' ,..leNT TO: FROM: William B. Horne II, City Manager Chuck Warrington, Managing Director ~ COPIES: 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 SUBJECT: GAS ADJUSTMENTS EFFECTIVE MARCH 1, 2002 DATE: February 14, 2002 Natural and Propane (LP) Gas supply prices have dropped somewhat. Therefore, we are recommending a decrease of 2(: in our Natural Gas Purchased Gas Adjustments (PGA) for March. As you know, we are experiencing an extremely mild winter this year thus far resulting in a shortfall in Heating Degree Days of 19.2% thru January. Even if the rest of the winter is normal, this will likely place us at least 15% 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 of an estimated $350,000 for the fiscal year. Therefore, we are recommending implementing an additional 2 (: per therm and gallon WNA beginning in March 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. This is a good time to implement this increase as it will offset the PGA decrease such that our typical customer will see no change in their total therm rate. 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 March 1, 2002: Natural Gas Firm Standard Rate Schedule PGA ....... $0.580 per therm (down 2.0(:/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.500 per therm (down 2.0(:/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.520 per gallon (no change) = $0.568 per therm equivalent (no change) Energy Conservation Adjustment (ECA) ............... $0.160 per therm (no change) and $0.160 per gallon of LP (up 1.0(:/gal.) 2/~I(}2-62 / ) , / ( 'william B. Horne II, City Mlnager Page 2 I February 14, 2002 Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) and $0.000 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... $0.040 per therm (up 2.0C/therm) & $0.040 per gallon of LP (up 2.0C/gal.) Attachment #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru January and projections thru September. These show that we are about $1.3 Million behind FYTD, but are projecting recovering all but about $200,000 of this shortfall by the end of the fiscal year. It is important to our overall financials that we get this close to balance by Fiscal Year End. Attachments #2a and #2b show our current annual projections for Natural Gas supply costs and LP historical FYTD costs, respectively. Attachment # 3 shows our estimation of the NFE shortfall due to weather and the basis for the WNA. 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 (25% lower for LP). This means that our average customer will likely see an overall savings on their typical March bill of $22/month below last March based on 42 therms/month, which is our average monthly residential customer consumption for March. It is our plan to use the above-proposed adjustments for billings through September 30, 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 March 1 st billings. If you have any questions on this, please call me. CSW /csw AttaChmen~s Approved: ... ~~- ::It IlIiam B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for March 2002.doc " '.. CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Paae 1 of 3 . NATURAL GAS PURCHASED GAS ADJUSTMENT tPGA-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) Firm/Contr Prior 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 Oec-01 $ 150,491.50 $ 645,540.93 $ 19,922.17 $ 815,954.60 $ 938,759.42 $ 122,804.82 $ (388,227.97) .6201.540 Jan-02 $ 148,246.82 $ 924,456.09 $ 35,803.41 $ 1,108,506.32 $ 1,120,002.40 $ 11,496.08 $ (376,731.89) .6001.520 Feb-02 $ 150,000.00 $ 900,000.00 $ 25,000.00 $ 1,075,000.00 $ 1,076,000.00 $ 1,000.00 $ (375,731.89) .600/.520 Mar-02 $ 150,000.00 $ 850,000.00 $ 25,000.00 $ 1,025,000.00 $ 1,034,800.00 $ 9,800.00 $ (365,931.89) .580/.500 Apr-02 $ 115,000.00 $ 725,000.00 $ 25,000.00 $ 865,000.00 $ 983,060.00 $ 118,060.00 $ (247,871.89) .580/.500 May-02 $ 80,000.00 $ 600,000.00 $ 25,000.00 $ 705,000.00 $ 827,840.00 $ 122,840.00 $ (125,031.89) .5801.500 Jun-02 $ 75,000.00 $ 575,000.00 $ 25,000.00 $ 675,000.00 $ 801,970.00 $ 126,970.00 $ 1,938.11 .5807.500 Jul-02 $ 75,000.00 $ 550,000.00 $ 25,000.00 $ 650,000.00 $ 776,100.00 $ 126,100.00 $ 128,038.11 .580/.500 Aug-02 $ 75,000.00 $ 550,000.00 $ 25,000.00 $ 650,000.00 $ 776,100.00 $ 126,100.00 $ 254,138.11 .580/.500 Sep-02 $ 75,000.00 $ 550,000.00 $ 25,000.00 $ 650,000.00 $ 776,100.00 $ 126,100.00 $ 380,238.11 .580/.500 Oct-02 $ - $ - $ 380,238.11 .580/.500 Total YTO $ 2,609,848.93 $ 8,155,803.79 $ - $ 298,273.36 $ 11,063,926.08 $ 10,760,915.50 $ (303,010.58) , (1) Includes annual charge for Admin and CCS chg of 1,298,000 (2) PROPANE tLP) 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 $ 34,659.23 Oct-01 34,975.7 $ 0.49971 $ 17,477.71 1 $ 100,171.71 $ 19,387.00 $ (80,784.71) $ (46,125.48) .601/.550 Nov-01 35,695.7 $ 0.49308 $ 17,600.84 $ 17,600.84 $ 19,631.99 $ 2,031.15 $ (44,094.32) .601/.550 Dec-O 1 45,501.4 $ 0.45150 $ 20,543.88 $ 20,543.88 $ 24,793.51 $ 4,249.63 $ (39,844.69) .601/.550 Jan-02 57,661.3 $ 0.43897 $ 25,311.58 $ 25,311.58 $ 30,560.76 $ 5,249.18 $ (34,595.52) .568/.520 Feb-02 57,000.0 $ 0.44000 $ 25,080.00 $ 25,080.00 $ 29,640.00 $ 4,560.00 $ (30,035.52) .56~0 Mar-02 56,000.0 $ 0.44000 $ 24,640.00 $ 24,640.00 $ 29,120.00 $ 4,480.00 $ (25,555.52) .568/.520 Apr-02 53,000.0 $ 0.44000 $ 23,320.00 $ 23,320.00 $ 27,560.00 $ 4,240.00 $ (21,315.52) .568/.520 May-02 48,000.0 $ 0.44000 $ 21,120.00 $ 21,120.00 $ 24,960.00 $ 3,840.00 $ (17,475.52) .568/.520 Jun-02 45,000.0 $ 0.44000 $ 19,800.00 $ 19,800.00 $ 23,400.00 $ 3,600.00 $ (13,875.52) .568/.520 Jul-02 42,000.0 $ 0.44000 $ 18,480.00 $ 18,480.00 $ 21,840.00 $ 3,360.00 $ (10,515.52) .568/.520 Aug-02 42,000.0 $ 0.44000 $ 18,480.00 $ 18,480.00 $ 21,840.00 $ 3,360.00 $ (7,155.52) .568/.520 Sep-02 42,000.0 $ 0.44000 $ 18,480.00 $ 18,480.00 $ 21,840.00 $ 3,360.00 $ (3,795.52) .5681.520 Total YTO 558,834.1 $ 0.44796 $ - 250,334.01 $ 333,028.01 $ 294,573.26 $ (38,454.75) Cost Center Expenses CCS Chg & Admin 67,090.00 1 Fuel 10,000.00 1 Coachman Park LP System 5,604.00 1 Total 82,694.00 ~no -- 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 Notes/Exceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $(1,068,572.38) Oct-01 $ 114,374.97 Promo $18,689.00, Empl 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,236.84,Emp 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 $ 48,338.15 Promo $36,006.68,Emp Costs $12,331.47 $ 5,311.15 $ 53,649.30 $ 113,633.54 $ 59,984.24 $(1,002,246.66) .1401.130 Jan-02 $ 255,461.71 Promo$240,582.26,Emp Costs $14,879.45 $ 5,011.23 $ 260,472.94 $ 174,095.48 $ (86,377.46) $(1,088,624.12) .1601.150 Feb-02 $ 175,000.00 $ 5,500.00 $ 180,500.00 $ 148,104.00 $ (32,396.00) $(1,121,020.12) .1601.150 Mar-02 $ 60,000.00 $ 5,300.00 $ 65,300.00 $ 151,321.60 $ 86,021.60 $(1,034,998.52) .1601.160 Apr-02 $ 60,000.00 $ 5,100.00 $ 65,100.00 $ 143,740.80 $ 78,640.80 $ (956,357.72) .1601.160 May-02 $ 60,000.00 $ 4,900.00 $ 64,900.00 $ 121,292.80 $ 56,392.80 $ (899,964.92) .16~0 Jun-02 $ 60,000.00 $ 4,700.00 $ 64,700.00 $ 117,392.00 $ 52,692.00 $ (847,272.92) .1601.160 Jul-02 $ 60,000.00 $ 4,500.00 $ 64,500.00 $ 113,491.20 $ 48,991.20 $ (798,281.72) .1601.160 Aug-02 $ 60,000.00 $ 4,300.00 $ 64,300.00 $ 113,491.20 $ 49,191.20 $ (749,090.52) .1601.160 Sep-02 $ 60,000.00 $ 4,100.00 $ 64,100.00 $ 113,491.20 $ 49,391.20 $ (699,699.32) .1601.160 Total YTD $ 1,071,885.57 $ 59,578.58 $ - $ 1,131,464.15 $ 1,500,337.21 $ 368,873.06 (1 ) Includes annual charge for Admin and CCS chg of 79,930.00 ENVIRONMENTAL IMPOSITION ADJUSTMENT CEIA) 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 $ - $ - $ 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 $ 417.00 $ - $ 417.00 $ - $ (417.00) $ 229,618.28 .0001.000 Jan-02 $ 910.07 $ - $ 910.07 $ - $ (910.07) $ 228,708.21 .06~ Feb-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 213,708.21 .0001.000 Mar-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 198,708.21 .0001.000 Apr-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 183,708.21 .0001.000 May-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 168,708.21 .0001.000 Jun-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 153,708.21 .0001.000 Jul-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 138,708.21 .0001.000 Aug-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 123,708.21 .0001.000 Sep-02 $ 15,000.00 $ - $ 15,000.00 $ - $ (15,000.00) $ 108,708.21 .0001.000 Sep-02 $ - $ - $ 108,708.21 Total YTD $ 136,588.81 $ - $ 136,588.81 $ 1.54 $ (136,587.27) 1)lncludes annual charges for Admin Charge 10,000 U:lwindowslmsofficelexcellgasf20( sheet recovery) Attachment #1 Paae 3 of 3- . 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 Prior Year $ - $ - $ - $ (105,368.98) Oct-01 $ 2,176,618.00 $ 862,117.66 $ (1,314,500.34) $(1,419,869.32) .760/.680 Nov-01 $ 984,823.35 $ 1,017,369.94 $ 32,546.59 $(1,387,322.73) .760/.680 Dec-01 $ 890,564.78 $ 1,077,186.47 $ 186,621.69 $(1,200,701.04) .7601.680 Jan-02 $ 1,395,200.91 $ 1,324,658.64 $ (70,542.27) $(1,271,243.31) .780/.690 Feb-02 $ 1,295,580.00 $ 1,253,744.00 $ (41,836.00) $(1,313,079.31) .7801.690 Mar-02 $ 1,129,940.00 $ 1,215,241.60 $ 85,301.60 $(1,227,777.71) .780/.720 Apr-02 $ 968,420.00 $ 1,154,360.80 $ 185,940.80 $(1,041,836.91 ) .7801.720 May-02 $ 806,020.00 $ 974,092.80 $ 168,072.80 $ (873,764.11) .780/.720 Jun-02 $ 774,500.00 $ 942,762.00 $ 168,262.00 $ (705,502.11) .78~0 Jul-:02 $ 747,980.00 $ 911,431.20 $ 163,451.20 $ (542,050.91) .780/.720 Aug-02 $ 747,780.00 $ 911,431.20 $ 163,651.20 $ (378,399.71) .7801.720 Sep-02 $ 747,580.00 $ 911,431.20 $ 163,851.20 $ (214,548.51) .780/.720 Total YTD $ 12,665,007.04 $ 12,555,827.51 $ (109,179.53) Note: Total all Admin & CCS Transfer Charges Collected thru Adjustment Clauses = $1,455,020 included in October. WEATHER NORMALIZATION (WNA) Total WNA Cumulative WNA Budget Interest Monthly YTD Overage NGlTherm Month LP Recovery Expense Rate/Gallon NG Recovery RatelTherm Recovery (Shortage) LP/Gal Beg. Ba!. $ - $ (350,000.00) Oct-01 $ - $ (350,000.00) Nov-01 $ - $ (350,000.00) Dec-01 $ - $ (350,000.00) Jan-02 824.27 $ 1,750.00 $ 0.014 40,192.99 $ 0.020 $ 42,767.26 $ (307,232.74) .0201.020 Feb-02 1,140.00 $ 1,400.00 $ 0.020 40,000.00 $ 0.020 $ 42,540.00 $ (264,692.74) .02~ Mar-02 2,240.00 $ 1,100.00 $ 0.040 80,000.00 $ 0.040 $ 83,340.00 $ (181,352.74) .0401.040 Apr-02 2,120.00 $ 800.00 $ 0.040 76,000.00 $ 0.040 $ 78,920.00 $ (102,432.74) .0401. 040 May-02 1,920.00 $ 500.00 $ 0.040 64,000.00 $ 0.040 $ 66,420.00 $ (36,012.74) .0401.040 Jun-02 1,800.00 $ 200.00 $ 0.040 62,000.00 $ 0.040 $ 64,000.00 $ 27,987.26 .0401.040 Jul-02 - $ - - $ - $ - $ 27,987.26 Aug-02 - $ - - $ - $ - $ 27,987.26 Sep-02 - $ - - $ - $ - $ 27,987.26 Sep-02 $ 27,987.26 Total YTD 10,044.3 5,750.00 362,193.0 $ 377,987.26 U:\my documents\EXCEL\GASRATES\FY 01-02\[Adjustment Clause Recovery for FY 01-02.xls]Recovery CSW: Updated 02/14/02 Pa J1-1-flltd,.~ /- ft;:< q CLEARWATER FY01-ll2 PURCHASED GAS COST PROJECTIONS AS OF Based on Actual OTH's Sold FTS.l Contract Capacity FTS.2 Contract Capacity Capacity RelinquIshments 2/13/2002 FTS.l Available Capacity FTS-2 Available Capacity Contract NNTS Per Month ProJected Sold Per Month 0;' of Purchased Gas lost Sold Gas (PGA revenues) -- Purchased Gas Sold Gas Oct'()l Nov'()l Dec'()l Jan'()2 Feb'()2 Mar'()2 Apr'()2 May'()2 Jun'()2 Jul'()2 Aug'()2 Sep.()2 lohase III /chasa 1111 170,438 41,788 $ 25,880.46 54,213 0 15,500 158,013 138,603 165,000 -2.69% $ 757,106.13 306,570 53 430 $ /8,439.64 191175 0 22,500 188,825 162,270 195,000 -0.35% $ 893,077.55 318789 55211 $ 10,108.57 188,251 0 31,000 183,749 169 424 223.000 -11.50% $ 938,759.42 318 789 55,211 $ 13060.90 149485 0 46 SOO 222,535 204,878 220.000 $ 1,120,002.40 286,132 49,888 $ 743.40 117,000 0 42,000 219.000 219.000 316,789 55211 $ 11,151.00 166,000 0 31000 206 000 206,000 216,570 53,430 $ 11,151.00 99,000 0 22,SOO 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 41788 $ 14.868.00 35,000 0 10,650 151,000 151,000 139.560 40,440 $ 11,151.00 29 000 0 10,500 151,000 151,000 Total 2,641,833 570,393 ($132,989.02) FTS.l Reservation charges FTS-l Usage Charge FTS-l No-Notice charges FTS-2 Reservation charges 1,122,104 o 286,100 2,090,122 875,175 2,160,000 .5.09% 3,708,945.50 FTS-2 Usage Charge FGU Management fee Per Month Total Billing From FGU + Infinite: WACOG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Total Commodity charges Monthly Adjustments Fuel Cost (Fuel Relenlion) Oct'()l Nov-01 Dec'()l Jan'()2 Feb'()2 Mar'()2 Apr'()2 May'()2 Jun'()2 Jul'()2 Aug'()2 Sep.()2 {chase fI\ (phase II) NNTS (phase III) (Phase 1111 $ 63,351.80 $ 3 953.88 $ 914.50 $ 31 028.49 $ 991.27 $ 848110.18 $ 1147.12 $ 15,609.25 $ 4,917.08 $ 4,54 $ 5.65 74.46% $717,524.51 $ 113,952.06 $ 3,946.59 $ 1,327.50 $ 39,686.77 $ 1,385.93 $ 768,028.37 $ 147.52 $ 18,399.54 $ 5,752.76 $ 5,43 $ 5.56 46.90% $918535.06 $ 117 ,750.47 $ 4,255.58 $ 1,829.00 $ 41,046.83 $ 1 479.8~ $ 767 801.84 $ 28.04 $ 18,635.83 $ 6,409.69 $ 5.00 $ 6.10 49.39% $918,119.37 $ 117,497.04 $ 5,331.85 $ 2,743.50 $ 40,944.28 $ 1,546.59 $ 883,416.76 $ 104.30 $ 20,750.36 $ 7,872.83 $ 4.55 $ 59.82% $1,011,559.28 $ 106,355,26 $ 5.846.00 $ 2,478.00 $ 38,139.05 $ 542.62 $ 853 725.40 $ $ 18.799,35 $ 8,435.08 $ 4,57 $ 65.18% $999,954.31 $ 117.750.47 $ 4,799.52 $ 1,829.00 $ 42.225.37 $ 807.34 $ 814,272.76 $ $ 17,941.44 $ 7,789.11 $ 4,68 $ 55.38% $_.60 $ 80,499.07 $ 2.048.29 $ 1.327.50 $ 40,863.28 $ 1.605.22 $ 694,984.88 $ $ 18,363.99 $ 6,334.20 $ 4.72 $ 63.33% $806.523.71 $ 53.603.60 $ 2.619.50 $ 731.60 $ 31.098.63 .$ 948.53 $ 575,262.53 $ $ 13,502.32 $ 5,708.09 $ 4.17 $ 84.41% $654,935.01 $ 51 ,874.45 $ 2,428.38 $ 619.50 $ 30.021.66 $ 1.054.81 $ 554,214.60 $ $ 13,010.00 $ 5,464.20 $ 4.14 $ 83.89% $625,579.42 $ 53,603.60 $ 3.010.90 $ 640.15 $ 31.959.46 $ 743.83 $ 559,789.65 $ $ 13,137.41 $ 5,453.09 $ 4,20 $ 81.18% $634,470.16 $ 53,603.60 $ 3,600.58 $ 640.15 $ 31.959.46 $ 743.83 $ 519,879.22 $ $ 12.158.42 $ 6,417.50 $ 3.92 $ 81.18% $591,214.43 $ 51,874.45 $ 3,847.49 $ 619.50 $ 30.928.51 $ 719.83 $ 515,041.58 $ $ 12,039.76 $ 6,417.50 $ 3,89 $ 77.22% $587,313.05 $981,715.88 $46,088.33 $15,699.90 $429.881.58 INote: 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 $12,569.62 $8,134,327.99 $78.86 $190,345.68 $76,791.13 $4.511 68.53% $9.428,654.91 Average Total Projected DTH WACOG Total Reservation Total Commodl Cost Purchased 1 st 6 Months $813,445.22 $4,715,173.91 $5,528,619.13 1,156,122 $4.774 2nd 6 Months $480,863.12 $3,419,172.68 $3,900,035.78 832 000 $4.185 TOTAL $1,294,308.34 $6,134,346.57 $9,428,854.91 2,090,122 $4.51 Purchased Wacog FY01 Budget 2078 PO amount 9,426,654.91 over budget . 1 I IJ I- J- ,;tv/I f"Y't e-rI j- :jJ.:: ;2. b - Propane Inventory and Weighted Cost of Gas (WACOG) LP Supplied by: 2/13/2002 Sea-3 of Florida Suburban Propane comDanvl Gallons Propane Propane Shipping Total FYTD Cost of Tank Tank WACO( Date Invoice # Delivered Rate Cost Cost Cost Gallons Inventorv Inventorv Withdrawl I I I 09/30/01 I $ 30,590.81 61,145 0.5003C 10/16/01 Sea-3 4001-1102 28,622.0 0.50442 $ 13,897.98 $ 539.50 $ 14,437.48 28,622.0 $ 45,028.29 89,767 0.50161 10/28/01 Resources 200110-5420 9,100.0 0.48510 $ 4,414.39 $ - $ 4,414.39 37 722.0 $ 49.442.68 98,867 0.5000C 10/31/01 inv adiustment 75.0 37,797.0 $ 49,442.68 98,942 0.49971 ,10/31/01 End of month $ 30,123.33 60,281 38,661 0.49971 i11/09/01 Resourcesl200111-5516 - Insurance premium adjustment - cap costs $ 1,845.00 37,797.0 $ 31,968.33 60,281 0.5303 111/19/01 Resourcesl200111-5597 27,008 0.44923 $ 12132.87 Ilnteorated $ 12,132;87 64,805.0 $ 44,101.20 87,289 0.5052 i11/30/01 Resourcesl200112-5683 8,999 0.39168 $ 3,524.69 Ilntoorated $ 3,524.69 73.804.0 $ 47,625.89 96,288 0.4946 l.11/30/01 inv adiustment 300 74,104.0 $ 47,625.89 96,588 0.4930 ~] 1/30/01 End of month $ 27,543.70 55,860 40,728 0.4930 12/20/01 Sea-3 4001-1289 27,672 0.41545 $ 10,984.95 $ 511.46 $ 11 496.41 101 776.0 $ 39040.11 83,532 0.4673 : 12/23/01 Resource. 200112-5942 18,400 0.40909 $ 7,527.27 Intellrated $ 7527.27 120176.0 $ 46,567.38 101,932 0.45685 , 12/24/01 Resources 200112-5948 9,200 0.40890 $ 3,761.88 Inteorated $ 3,761.88 129 376.0 $ 50,329.26 111,132 0.45288 12/26/01 Suburban 882710 1,201 0.47300 $ 568.26 N/A $ 568.26 130,577.4 $ 50,897.52 112,334 0.45309 i 12/31/01 inv adjustment 400 - $ - $ - $ . 130,977.4 $ 50,897.52 112,734 0.45148 '12/31/01 inv adiustment 131 - $ - $ - $ - 130,974.4 $ 50,897.52 112731 0.45150 12/31/01 End of month $ 27,356.06 60,590 52,141 0.45150 01/03/02 Suburban 298907 2,336 0.49100 $ 1 146.83 N/A $ 1,146.83 133310.1 $ 28 502.89 62 926 0.45296 01/09/02 Suburban 882711 1958 0.49100 $ 961.43 N/A $ 961.43 135,268.2 $ 29 464.32 64,884 0.45411 01/10/02 Resources 200201-6212 18,105 0.39740 $ 7,194.93 Inteorated $ 7,194.93 153 373.2 $ 36,659.25 82 989 0.44174 01/16/02 Suburban 882713 2,011 0.49100 $ 987.25 N/A $ 987.25 155 383.9 $ 37,646.50 84,999 0.44290 01/21/02 Sea-3 4002-0068 9,135 0.45127 $ 3,955.18 $ 167.17 $ 4,122.35 164 518.9 $ 41,768.85 94134 0.44372 01/23/02 Resource, 200202-6404 9,500 0.39190 $ 3,723.05 Intellrated $ 3,723.05 174,018.9 $ 45,491.90 103,634 0.43897 01/31/02 End of month $ 18,848.88 42,939 60,695 0.43897 102/01/02 Resource. 200202-6405 18,200 0.39240 $ 7,141.68 Inteorated $ 7,141.68 192218.9 $ 25,990.56 61,139 0.42510 ! , r . I .IFYTD Totals 174,019 0.44733 $ 74780.96 $ 1.218.13 $ 77 844.09 . , . I I CSW:OI/14/02 Attachment #3 CALCULATION OF WEATHER NORMALIZATION ADJUSTMENT Deficit from October 1. 2001 - March 31. 2002 Actual Heating Degree Days FYTD thru 1/02 10 Year Average lIDOs for Oct - Jan 236 292 80.8% Therefore, Shortfall = 19.2% Thereby exceeding the 10% threshhold for WNA application Projected Shortfall in Natural Gas Thenn Projected Shortfall in LP Gas Gallons Total Projected Shortfall in NFE Billings for FY 01/02 Plus Estimated Impact of Capped Rates Total Projected Shortfall Needed for WNA Recovery for FY 01/02 Less Projected WNA Recovery thru February 2002 WNA Recovery Needed for March 1, 2002 - June 30, 2002 580,000 16,000 @ @ $ 0.58 $ 0.75 $ 336,400 $ 12,000 $ 348,400 1,600 $ 350,000 (83,000) $ 267,000 Proiected Usae:e for Period of NG Therms LP Gallons Total Therms & Gallons March 1,2002 - June 30, 2002 7,000,000 200,000 7,200,000 Required WNA Recovery Rate $ 267,000 $ 0.0371 7,200,000 Round to $0.040 Per Therm U :\My Documents\EXCEL\GASRA TES\FY 0 1-02\(WNA Recovery Beginning 3-I-02.xls ]Sbeell CSW:02/14/02 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 01/01 Therm Rate % Change from 01/01 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 March 1, 2002 - SEPTEMBER 30,2002 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.160 0.160 0.160 0.160 0.000 0.000 0.000 0.000 0.040 0.040 0.040 0.040 $0.780 $0.780 $0.780 $0.780 0.580 0.580 0.580 0.580 $1.360 $1.360 $1.360 $1.360 $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.160 0.000 0.040 $0.550 0.580 $1.130 $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 $15.00 $0.200 $0.980 $15.00 +FAC ~ SL w/M& NGV Reliaht NA NA NA $15.00 $7 Resl.! $15 GS if not prevo billed $0.300 $0.100 0.160 0.160 0.160 Interr. NG Rate NSS -'L NA 100,000 &up $25.00 $100.00 $0.470 $0.280 0.160 0.160 0.160 0.000 0.000 0.000 0.000 0.000 NA 0.160 NA 0.000 0.000 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 $D.400 $0.350 $0.300 $0.400 $0.500 $0.300 $0.670 $0.320 0.580 0.580 $0.980 $0.930 $0.880 0.580 0.580 0.580 0.580 0.580 0.500 $1.250 $0.820 $7.00 @ $15.00 @ $15.00 @ premise premise premise $0.069 $0.069 $0.069 $0.069 $0.511 $0.511 $0.511 $0.511 04/02 05/02 06/02 $0.470 $0.410 $1.080 $0.880 $15.00 $7 Resl.! +FAC $15GS@ premise +FAC $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 0.160 0.160 $ (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.511 $0.511 $0.511 $0.511 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) Firm Service Rates Interruptible Service Rates 10/01 11/01 12/01 01/02 1.059 1.056 1.048 1.052 0.000 0.000 0.040 0.040 $0.670 $0.610 0.580 0.580 $1.250 $1.190 $0.069 $0.511 07/02 $0.069 $0.069 $0.069 $0.055 $0.511 $0.511 $0.511 08/02 09/02 $0.445 Attachment #4 Contract NG Rate ~ NA By Contract - By Contract NA NA 0.040 Contract + $0.040 Plus 0.500 $0.540 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms ~, $ (0.570) -51.4% $0.069 $0.431 1.039 1.036 1.028 1.031 $15.00 $20.00 $0.069 $0.069 $0.511 $0.511 02102 03/02 1.061 1.062 1.040 1.041 Change from 01/01 Gallon Rate % Change from 01/01 Gallon Rate $ (0.381) -15.2% $ (0.381) -15.2% $ (0.381) -29.3% $ (0.381) -30.5% $ (0.381) -31.7% $ (0.381) -25.6% $ (0.440) -44.0% CSW:02/14/02 Attachment #5 Page 2 of2 , - BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM i .. BTU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE (lP) RATE BilliNG FACTORS Therm Factor: 0.915 Therms/Gallon FOR MARCH 1, 2002 - SEPTEMBER 30,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 - 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 Energy 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.lGallon 0.160 0.160 0.160 0.160 0.160 0.160 0.160 0.160 0.160 0.160 0.160 0.160 NA Environm'llmposition Adj.lGallon - - - - - - - - - - - - NA Weather Normalization Adj.lGallon 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 - Total Non-Fuel Charges/Gallon $ 1.500 $ 1.350 $ 0.900 $ 0.800 $ 0.900 $ 0.800 $ 0.800 $ 0.700 $ 0.700 $ 0.700 $ 0.400 $ 0.350 Set By Contract + 0.040 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 $ 2.020 $ 1.870 $ 1.420 $ 1.320 $ 1.420 $ 1.320 $ 1.320 $ 1.220 $ 1.220 $ 1.220 $ 0.920 $ 0.870 0.560 + 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.381) $ (0.381) $ (0.381) $ (0.381) $ (0.381) $ (0.381) $ (0.381 ) $ (0.381) $ (0.381) $ (0.381 ) $ (0.381) $ (0.381 ) $ (0.440) % Change from 01/01 Gallon Rate -15.9% -16.9% -21.2% -22.4% -21.2% -22.4% -22.4% -23.8% -23.8% -23.8% -29.3% -30.5% -44.0% ~--