Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE NOVEMBER 2007
111143 FROM: COPIES: CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet RECEIVED A ?JD William B. Horne II, City Manager Chuck Warrington, Mana ing Director Rod Irwin, Assistant anager; Cyndie Goudeau, City Clerk; CGS & CCS Management ams; Janet Dorrough, Sr. Accountant /CGS; Tom Madley, Sr. Accountant /CCS; Laura Damico, Sr. Accountant /CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE NOVEMBER 2007 DATE: October 29, 2007 Natural Gas markets remain high historically but are remaining somewhat stable at this time due to high storage levels and the lack of any major storm disruptions this year. Hence, we are recommending no change in our Natural Gas Purchased Gas Adjustments (PGA) at this time. However, LP supply prices are tracking substantially higher with world oil prices, which have climbed to record levels. Therefore, we are recommending that we increase our LP PGA by 180 /gallon at this time. We will continue to closely monitor our actual gas supply costs and propose changes if we see the near -term costs change substantially. We are not recommending any change in our Energy Conservation Adjustment (ECA), our Environmental Imposition Adjustment (EIA), nor our Weather Normalization Adjustment (WNA) clauses at this time. The net effect of these recommended changes is no change in our typical Residential Natural Gas customer's rate but an increase of 1 SO /gallon in our typical Residential LP customer's rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after November 1, 2007: Natural Gas Firm Standard Rate Schedule PGA ....... $1.08 per therm (no change) Natural Gas Interruptible and Contract (Non- Standard) Rate Schedule PGA ............. $1.00 per therm (no change) Propane (LP) Gas Rate Schedule PGA .................... $2.09 per gallon (up 180 /gallon) Energy Conservation Adjustment (ECA) ............... $0.18 per therm or gallon (no change) Environmental Imposition Adjustment (EIA) ......... $0.00 per therm or gallon (no change) Weather Normalization Adjustment (WNA) .......... $0.00 per therm or gallon (no change) William B. Horne II, City Manager October 29, 2007 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru September and projections thru Period 13 of this fiscal year. These show that we are projecting being ahead on our collections by $1.2 million by FYE vs. starting the year behind ($770,000). This is a significant improvement in our financial position and will require us to establish a deferred revenue account for NG PGA at FYE. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #6 shows our rate history over the past 3 + years and shows our relationship to electric prices. I should point out that the overall effect is that our typical Residential customer rates are now 47% lower than electric for Natural Gas and still 1 % lower for LP. The natural gas margins have increased since Progress Energy Florida implemented an increase in their Fuel Adjustment charges last January, but they have announced that they are filing for lower Fuel Adjustment charges beginning next January. In any event, we remain in an extremely competitive position vs. electricity. It is our plan to use the above - proposed adjustments for billings through September 30, 2008, unless there is a significant change in our forecasts or we project a significant over /under recovery of our adjustment clauses. 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 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: William B. Horne II, City Manager U: \My Documents \MSOFFICE \WINWORD \GASRATES \Gas Adjustments for November 2007.doc CLEARWATER GAS SYSTEM ZLIMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 06!07 Attachment #1 Page 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 Rate/Therm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shorts e) Firm /Contr Prior Year $ (421,440.26 Oct -06 $ 3,284,725.17 $ 765,716.91 $ 2,107.20 $ 34,185.02 1 $ 4,086,734.30 $ 1,481,373.67 $ (2,605,360.63) $ (3,026,800.89) 1.170/1.090 Nov -06 $ 162,318.00 $ 858,251.85 $ 15,134.00 $ 31,763.00 $ 1,067,466.85 $ 1,676,360.74 $ 608,893.89 $ (2,417,907.01 ) 1.170/1.090 Dec -06 $ 163,917.33 $ 1,310,363.58 $ 12,089.54 $ 46,681.68 $ 1,533,052.13 $ 2,011,296.88 $ 478,244.75 $ (1,939,662.25 ) 1.17011.090 Jan -07 $ 166,355.50 $ 1,184,532.16 $ 9,698.31 $ 39,909.10 $ 1,400,495.07 $ 2,232,997.02 $ 832,501.95 $ (1,107,160.30) 1.170/1.090 Feb -07 $ 141,731.87 $ 1,496,365.20 $ 5,535.80 $ 55,622.00 2 $ 1,699,254.87 $ 2,272,848.59 $ 573,593.72 $ (533,566.58) 1.170/1.090 Mar -07 $ 166,645.53 $ 1,620,961.42 $ 2,667.83 $ 28,357.97 $ 1,818,632.75 $ 2,268,724.93 $ 450,092.18 $ (83,474.41) 1.17011.090 Apr -07 $ 127,638.99 $ 1,488,334.61 $ 417.37 $ 28,913.33 $ 1,645,304.30 $ 2,018,862.40 $ 373,558.10 $ 290,083.69 w.;150t1;(37Q, May-07 $ 91,156.61 $ 1,322,787.95 $ - $ 43,420.02 $ 1,457,364.58 $ 1,773,353.76 $ 315,989.18 $ 606,072.87 1.15011.070 Jun -07 $ 85,906.00 $ 1,312,041.06 $ $ 44,808.02 $ 1,442,755.08 $ 1,701,025.98 $ 258,270.90 $ 864,343.77 11 X50, , Jul -07 $ 67,832.12 $ 1,121,779.33 $ $ 37,094.06 $ 1,226,705.51 $ 1,422,810.34 $ 196,104.83 $ 1,060,448.60 , _ f{78(#f Aug -07 $ 44,444.87 $ 1,020,995.95 $ $ 47,880.06 $ 1,111,320.88 $ 1,338,997.17 $ 225,676.29 $ 1,286,124.89 1.080/1.000 Sep -07 $ 65,969.41 $ 1,245,753.52 $ $ 17,502.73 $ 1,329,225.66 $ 1,433,046.54 $ 103,820.88 $ 1,389,945.77 F,1341t.a00•',? Per 13 $ 233,686.44 $ Is $ - 5 1 $ 233,686.44 $ - $ 233,686.44 $ 1,156,259.33 Total YTD $ 4,802,327.84 $ 14,747,883.54 $ 47,650.06 $ 456,136.99 $ 20,053,998.43 $ 21,631,698.02 $ 1,577,699.59 (1) Includes annual charge for Admin of $611,230 + Annual CCS chg of $932,110 + Dividend $1,623,160 + FY 05/06 PGA write off of $35,661.54 + WNA $5.35 = $ 3,202,166.89 2) Dresser Roots Meter Prover w /software = $ 17,885.50 (5) Commodity adjustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Rate Net RC = $ 1,348,589.01 NG Proportion = 97.78% x Total ECA Transfer = $ 273,060.81 + Transfer of WNA to PGA = $ 39,374.37) PROPANE 11.1311 GAS PURCHASED GAS ADJUSTMENT PGA -LP Commodity Monthly Cumulative LP PGA Bud et Gallons Monthly____ Interest Total LP Fuel Total LP PGA Overage YTD Overa a Therm /Gal. Month Sold WACOG Expense Charges Expenses Billed S_hortage)_ (Shortage) Prior Year $ (43,093.11) Oct -06 35,887.9 $ 1.16084 $ 215.47 $ 41,660.11 1 $ 227,250.23 $ 54,124.69 $ (173,125.54 ) $ (216,218.65) 1.382/1.510 Nov -06 35,568.5 $ 1.12353 $ 1,081.09 $ 39,962.28 $ 41,043.37 $ 53,801.26 $ 12,757.89 $ (203,460.76) 1.382/1.510 Dec -06 44,783.9 $ 1.40450 $ 1,017.30 $ 62,898.99 $ 63,916.29 $ 67,626.02 $ 3,709.73 $ (199,751.03) 1.382/1.510 Jan -07 26,254.0 $ 1.09610 $ 998.76 $ 28,777.01 2 $ 29,775.76 $ 47,456.18 $ 17,680.42 $ 182,070.61) 1.382/1.510 Feb -07 56,471.2 $ 1.08121 $ 91035 $ 61,057.23 $ 61,967.58 $ 85,249.73 $ 23,282.15 $ 158,788.46) 1.382/1.510 Mar -07 52,011.1 $ 1.09973 $ 793.94 $ 57,198.17 $ 57,992.11 $ 78,536.57 $ 20,544.46 $ (138,244.00) 1.382/1510 Apr -07 45,71 7.2 $ 1.17100 $ 691.22 $ 53,534.84 $ 54,226.06 $ 68,109.83 $ 13,883.77 $ 124,360,23) 't /1 496 - May -07 36,683.8 $ 1.23992 1 $ 621.80 $ 45,484.98 $ 46,106.78 $ 58,792.62 $ 12,685.84 $ (111,674.39) 1,.441 ti-3 Jun -07 37,775.1 $ 1.26269 $ 558.37 $ 47,698.24 $ 48,256.61 $ 69,359.92 $ 21,103.31 $ (90,571.08) 1y,,72t3!'t 880=; Jul -07 32,605.4 $ 1.23695 $ 452.86 $ 40,331.25 $ 40,784.10 $ 62,141.86 $ 21,357.76 $ (69,213.33 1,748/ .q%1, Aug -07 30,864 .5 $ 1.29904 $ 346.07 $ 40,094.22 $ 40,440.29 $ 58,793.94 $ 18,353.65 $ (150 859 67)1 1.748/1.910 Sep -07 32,893.2 $ 1.30879 $ 254.30 $ 43,050.29 $ 43,304.59 $ 62,599.09 $ 19,294.50 $ (31,565.17) 1.748/1.910 Per 13 4 $ 6,199.58 $ - $ 6,199.58 $ (37,764.75) Total YTD 467,515.8 $ 1.20156 $ 7,941.53 $ 561,747.60 $ 761,263.35 $ 766,591.71 $ 5,328.36 Cost Center Expenses CCS Chg + Admin Chg + Dividend $ 77,870.00 1 2) Note that 24,235.7 gallon credited fron prior years ($25,764.69 PGA) FY 05/06 Write off PGA & WNA 715.82 1 Fuel 15,000.00 1 PC Anywhere 159.00 1 LP Yard Vaporization 14,606.77 1 (4)1 Adjustment from FYE transfer of ECA in PGA @ 112 of the ECA Rate LP PGA Event fuel cost 3,004.13 1 LP Proportion = 2.22% x Total ECA Transfer = $ 6,199.58 Depreciation of LP Tanks 34,414.23 1 Suburban Software Systems 1,250.00 1 Suburban Software Systems License 569.70 1 1 Total Cost Cntr Ex Contribution to garage LP trk upgrade 37,785.00 1 $ 185,374.65 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 06/07 Attachment #1 Page 2 of 3 ENERGY CONSERVATION ADJUSTMENT (ECA)' Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NG/Therm Month Expenses Notes/Exceptlonal Items Expense Expenses Billed (Shortage) Shorts LP /Gal. Prior Year - $ 393,428.63 Oct -06 $ 327,250.81 Promo$21,025,Adv $1,000, Employ Costs$58,350 $ 1,967.14 1 $ 329,217.95 $ 106,012.58 $ 223,205.37 $ 616,634.00 0.180/0.180 Nov -06 $ 107,262.54 Promo$56,079,Adv $0, Employ Costs$51,184 $ 3,083.17 $ 110,345.71 $ 119,656.27 $ 9,310.56 $ 607,323.44 0.180/0.180 Dec -06 $ 92,495.50 Promo$21,742,Adv $0, Employ Costs$70,753 $ 3,036.62 $ 95,532.12 $ 154,437.79 $ 58,905.67 $ 548,417.77 0.180/0.180 Jan -07 $ 114,579.47 Promo$53,629,Adv $1,671, Employ Costs$55,102 $ 2,742.09 2 $ 117,321.56 $ 176,096.64 $ 58,775.08 $ (489,642.69 ) 0.18010.180 Feb-07 $ 111,944.62 Promo$57,166,Adv$1,043, Employ Costs$53,734 $ 2,448.21 $ 114,392.83 $ 192,482.65 $ 78,089.82 $ 411,552.8 0.180/0.180 Mar -07 $ 83,212.10 Promo$25, 998 ,Adv$1,200, Employ Costs$56,014 $ 2,057.76 $ 85,269.86 $ 186,148.68 $ 100,878.82 $ 310,674.06 0.180/0.180 Apr-07 $ 124,262.86 Promo$76,955,Adv $250, Employ Costs$47,058 $ 1,553.37 $ 125,816.23 $ 145,517.69 $ 19,701.46 $ 290,972.60 0.180/0.180 May-07 $ 95,505.89 Promo$52,915,Adv $0, Employ Costs$42,590 $ 1,454.86 $ 96,960.75 $ 132,653.03 $ 35,692.28 $ 255,280.32 0.180/0.180 Jun -07 $ 94,658.19 Promo$37,764,Adv $410, Employ Costs$56,484 $ 1,276.40 $ 95,934.59 $ 128,494.09 $ 32,559.50 $ 222,720.82 0.180/0.180 Jul -07 $ 74,004.98 Promo$30,898,Adv $145, Employ Costs$42,862 $ 1,113.60 $ 75,118.58 $ 110,832.03 $ 35,713.45 $ 187,007.38 0.180/0.180 Aug-07 $ 219,127.21 Promo$23,212,Adv $500, Employ Costs$51,085 $ 935.04 3 $ 220,062.25 $ 105,296.30 $ (114,765.95 ) $ 301,773.32 0.180/0.180 Se p-07 $ 86,608.78 Pmmo$43,703,Adv $0, Employ Costs$42,906 $ 1,508.87 $ 88,117.65 $ 110,630.58 $ 22,512.93 $ 279,260.39 0.180/0.180 Per 13 6 $ - $ 279 260.39 $ 279,260.39 $ - Total YTD $ 1,530,912.95 $ 23,177.14 $ 1,554,090.09 $ 1,947,518.72 $ 393,428.63 1 Includes annual charge for Admin Chg of $36,550 + COS chg of $67,670 (6 ) Transfer of ECA Collected in PGA @ 112 of the ECA Ra (up to ECA Annual Shortfall) + Dividend of $142,030 + FY 06/07 Write off of $2,626.07 = $ 248,876.07 Note: Maximum amount which can be transferred = $ 834,129.17 2 FY06 SO Write -off Adjustment ($299,663.81-$295,486.12) $ 4,177.69 3 FY07 SO Write -off Adjustment = $ 144,330.16 Net CCE= $ 1,133,529.03 ENVIRONMENTAL IMPOSITION ADJUSTMENT EIA Monthly Cumulative EIA Bud et Cost Center Interest Total EIA Total EIA Overage YTD Overage NG/Therm Month Expenses Notes/Exceptional Items Expense Expenses Billed (Shortage) (Shortage) LP /Gal. Prior Year $ 90,062.94 Oct-06 $ 11,257.23 $ - $ 11,257.23 $ 5,885.87 $ 5,371.36 $ 84,691.58 0.010/0.010 Nov -06 $ 972.00 $ - $ 972.00 $ 6,651.85 $ 5,679.85 $ 90,371.43 0.010/0.010 Dec-06 $ 1,252.00 $ - $ 1,252.00 $ 8,586.35 $ 7,334.35 $ 97,705.78 0.010/0.010 Jan -07 $ 972.00 $ - $ 972.00 $ 9199.63 $ 8,827.63 $ 106,533.41 0.010/0.010 Feb-07 $ 2,120.30 $ - $ 2,120.30 $ 10,699.92 $ 8,579.62 $ 115,113.03 0.010/0.010 Mar -07 $ 972.00 $ - $ 972.00 $ 10,345.50 $ 9,373.50 $ 124,486.53 0.010/0.010 Apr-07 $ 1,448.20 $ - $ 1,448.20 $ 408.19) $ 1,856.39 $ 122,630.14 May-07 $ 972.00 $ - $ 972.00 $ 2.92 $ 974.92) $ 121,655.22 0.000/0.000 Jun -07 $ 972.00 $ - $ 972.00 $ (2.31 ) $ 974.31) $ 120,680.91 0.000 /0.000 Jul -07 $ 1,168.00 $ - $ 1,168.00 $ (2.22 ) $ 1,170.22 $ 119,510.69 0.000 /0.000 Aug-07 $ 972.00 $ - $ 972.00 $ 7.10 $ (979.10 ) $ 118,531.59 0.000 /0.000 Sep -07 $ 2,060.00 $ - $ 2,060.00 $ 1.57 $ 2,061.57 $ 116,470.02 0.000 /0.000 Per 13 $ - $ $ - $ - $ 116,470.02 Total YTD $ 25,137.73 $ - $ 25,137.73 $ 51,544.81 $ 26,407.08 1 Includes annual charges for Admin Charge $10,000 + FY 05/06 write off of $285.23 = $ 10,285.23 Net CCE= $ 14,852.50 CLEARWATER GAS SYSTEM J iMMARY OF ROTE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 06107 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 NG/Therm -Firm Month Expenses Billed (Shortage) Shorta e) LP /Gallon Prior Year - $ - $ (767,899.06 Oct -06 $ 4,654,459.71 $ 1,647,396.81 $ (3,007,062.90 ) $ (3,774,961.96) 1.360/1.700 Nov -06 1,219,827.93 1,856,470.12 $ 636,642.19 $ (3,138,319.77) 1.360/1.700 Dec -06 1,693,752.53 2,241,947.04 $ 548,194.51 $ (2,590,125.27 ) 1.360/1.700 Jan -07 1,548,564.39 2,466,349.47 $ 917,785.08 $ (1,672,340.19) 1.360/1.700 Feb -07 1,877,735.58 2,561,280.89 $ 683,545.31 $ (988,794.89 ) 1.360/1.700 Mar -07 1,962,866.73 2,543,755.68 $ 580,888.95 $ 407,905.93 1.360/1.700 Apr-07 _ 1,826,794.79 2,232,081.73 $ 405,286.94 $ (2,619.00)3Cit67U.:. May -07 1,601,404.11 1,964,796.49 $ 363,392.38 $ 360,773.38) #iF Jun -07 1,587,918.28 1,898,877.68 $ 310,959.40 $ 671,732.78111#6; Jul -07 1,343,776.20 1,595,782.01 $ 252,005.81 $ 923,738.59 1.260/2.090 Aug -07 1,374,795.41 1,503,080.31 $ 128,284.90 $ 1,052,023.48 1.260/2.090 Sep- 7 1,462,707.90 1,606,274.64 $ 143,566.74 $ 1,195,590.23 1.260/2.090 Per 13 239,886.02 1 279,260.39 $ 39,374.37 $ 1,234,964.60 Total YTD $ 22,394,489.60 $ 24,397,353.26 $ 2,002,863.66 Total of All Additional Expenses Recovered Thru Adjustment Clauses = $ 3,665,506.54 WEATHER NORMALIZATION WNA Monthly Cumulative WNA Budget Interest Overage YTD Overage NG/Therm Month LP Gallons Expense --Rate/Gallon NG Therms Raterrherm Shortaa a (Shortage) LP /Gallon Beg. Bal. 1 $ - 1 $ (126,211.00) Oct -06 35,887.9 $ - - 1,480,887 $ - $ 126,211.00) 0.000 /0.000 Nov -06 35,568.5 $ - - 1,688,927 - $ - $ 126,211.00) 0.000 /0.000 Dec -06 44,783.9 $ - - 1,980,891 - $ - $ (126,211.00) 0.000 /0.000 Jan -07 26,254.0 $ - - 2,121,988 - $ (19.58) $ 126,230.58) 0.000 /0.000 Feb -07 56,471.2 $ 2,216,322 $ $ (126,230.58 ) 0.000 /0.000 Mar -07 52,011.1 $ 2,152,013 - $ $ (126,230.58) 0.000 /0.000 Apr-07 45,717.2 $ - 0.030 1,986,311 0.030 $ 60,200.75 $ 66,029.83) , , O.f130/413(1.; -' May -07 36,683.8 $ - 0.030 1,740,666 0.030 $ 53,369.39 $ (12,660.44)1 0.03010.030 Jun -07 37,775.1 $ - 0.030 1,686,514 0.030 $ 51,766.51 $ 39,106.07 0.030/0.030 Jul -07 32,605.4 $ - - 1,468,294 - $ 304.59 $ 39,410.66 Q,tOCtJQ11 0-,, Aug-07 30,864.5 $ - - 1,393,874 - $ (24.66 $ 39,386.00 0.000 /0.000 Sep-07 32,893.2 $ - - 1,456,742 $ (11.63) $ 39,374.37 0.000 10.000 Per 13 2 $ 39,374.37 $ - Total YTD 467,515.8 21,373,429 $ 165,585.37 1 Computed FNE Shortfall oased on 88 fewer HDDs than 10 year average. Target is to collect $126,211 net of Angelica & Metal Industries. (2) Transfer of WNA FYE balance to NG PGA Last Updated: 10/19/2007 Oct-07 Nov -07 Dec-07 Jan-08 Fell Mar -OB Apt -08 May-OS Jun-08 Jul 08 Aug -08 Sep-08 Total Oct -07 NOV -07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-O8 May-08 Jun-08 Jul-08 Aug-08 Sep -08 S L CGS Natural Gas Cost Actual/Projections FY08 as of 10/29/2007 Contract Capacity Contract No-Nodes Excess Ca CapaoftY Rellnqulshmeut Purchased Oes Sold Gas Actual Sold Gas Pro sated Purchased Gas lost % Sold Gas vs Pro acted WACOG Purchased FTS 1 F79 -2 Voi(30,0DD). Cost 1704311 41,788 15,500 40,228 $ 1,131,693.42 E 12,000.00 172,000 $ 7,740.00 172,000 81.0% $1,220,003.87 $ 7.09 306,570 53,430 22,500 140,000 $ 1282.32 $ 6,000.00 220,000 $ 48,531.99 220,000 66.7% 61.1% $ 7.61 316,789 55,211 31,000 115,000 $ 7,224.17 $ 10,000.00 257,000 $ 257,000 $ 8,796.87 79.8% $ 6.45 310,789 55,211 46,500 135,000 $ 2,301.75 $ 10,000.00 237,000 $ 1,920,80228 237,000 $ 61,578.08 $ 10,665.00 $ 8.78 288,132 49,868 42,000 111,000 $ 38,348A9 $ ,500.00 225,000 $ 1,196.83 225,000 $ $ 58,489.52 $ 8.76 316,789 55,211 31,000 171,000 125290.05 S 91000.00 201,000 $ 7,508.14 201,000 $ 1,618,933.86 $ $ 8.85 216,670 53,430 22,500 91,000 $ $ 12,000.00 179,000 $ 1,113.75 179200 3 1,2V-32 $ 1,370,143.87 $ 8.30 14 4212 41,788 12,400 10,000 (31.000) S 12,400.00 170,000 $ 32,134.97 170,000 S 6,602.92 $ 1,002.91 $ 8.09 139,660 40,440 10,500 25,000 30,0 $ 12,000.00 155,000 55,195.98 155,000 $ 519.75 $ 5,899.84 $ 8.11 144,212 41,788 10,850 32,000 1,000)1$ 12 400.00 154,000 S 154,000 3 32,134.97 $ 537.08 $ 829 144212 41,788 10,850 31,000 1,000 $ 12,400.00 155,000 $1,276,168.97 155,000 57.035.85 $ 32,134.97 $ 8.29 139,560 40,440 10,500 25;000 1,000 E (8,400.0011 155,000 83.3% 155,000 $ 55,195.98 $ 8.30 2,641,833 570,393 266,100 932,226 (394,000) ($124,100.00) 2,280,000 0 $280,000 100.00% ADIV/01 $8.05 Total $1,044,844.95 $438,632.19 $13,171.95 $84,876.83 $13,669.40 $16,976,745.84 $ $543,854.28 $99,831.87 85.9% Total Projected DTN WACOG tat 6 Months R�ervatlon charges FTS -1 FTS -2 base II (phase 111 FTS-1 No- Notice charges NNTS ITS -1 Usage Charge (phase 11 FTS-2 Usage Charge (phase III Total Commodity charges Monthly Ad uabnerds Fuel Cost (Fuel Retention FGU Management fee Per Month Load Factor w/ Relinquish Load Factor wlo Rel' uish Total Billing FGU $ 67,408.23 $ 32,134.97 $ 767.25 $ 6,705.92 $ 1002.91 $ 1,131,693.42 $ $ 36,166.15 $ 7,740.00 94.4% 81.0% $1,220,003.87 S 121,248.44 $ 41,087.87 S 1,113.76 $ 8,578.36 $ 1282.32 $ 1,517,452.67 $ $ 48,531.99 $ 9,900.00 66.7% 61.1% $1,674,902.52 $ 125,290.05 $ 42,457.26 $ 1,534.50 $ 7,224.17 $ 1325.05 $ 1498,586.05 $ $ 48,013.23 $ 8,796.87 79.8% 69.1% $1,667,867.86 $ 125,290.05 $ 42,457.26 $ 2,301.75 $ 9,362.14 $ 1,325.06 $ 1,920,80228 $ $ 61,578.08 $ 10,665.00 73.6% 63.7% $2,080,851.34 $ 113,165.21 $ 38,348A9 $ 2079.00 $ 9,019.30 $ 1,196.83 $ 1,824,518.65 $ $ 58,489.52 $ 10,125.00 73.6% 67.0% $1,970,611.35 $ 125290.05 $ 42,45726 S 1,534.50 $ 7,508.14 $ 1,325.06 $ 1,618,933.86 $ $ 51,903.66 $ 9.045.00 58.8% 54.0% $1,779,215.67 $ $5,653.44 T 41,087.67 $ 1,113.75 $ 6,488.86 3 1,2V-32 $ 1,370,143.87 $ 43,899.69 $ 8,055.00 74.6% 66.3% $1,485,998.72 $ 57,035.85 $ 32,134.97 $ 613.80 S 6,602.92 $ 1,002.91 $ 1,298,420.17 S $ 41,592.34 $ 7,650.00 109.7% 91.4% $1,375,804.79 $ 55,195.98 $ 31,098.36 $ 519.75 $ 5,899.84 $ 970.56 $ 1181,658.58 $ $ 37,853.18 $ 6,975.00 103.3% 86.1% $1,256,472.66 S 57,035.85 3 32,134.97 $ 537.08 $ 5,778.92 $ 1,002.91 S 1,198,861.08 $ $ 3841725 $ 6,930.00 99.4% 82.8% $1,276,168.97 $ 57.035.85 $ 32,134.97 $ 537.08 $ 5,830.42 $ 1,002.91 $ 1,206,987.91 $ $ 38,677.59 $ 6,975.00 100.0% 83.3% $1,284,295.81 $ 55,195.98 1 $ 31,098.36 $ 519.76.$ 5,899.84.$ 970.56.$ 1,208,687.00 $ $ 38,731.60 $ 6,975.00 97.5% 86.1% $1,287,101.09 Total $1,044,844.95 $438,632.19 $13,171.95 $84,876.83 $13,669.40 $16,976,745.84 $ $543,854.28 $99,831.87 85.9% Total Projected DTN WACOG tat 6 Months $871,465.66 $ 9,511,986.93 $10,383,46160 1,312,000 $7.914 2nd 6 Months $801,083.43 S 7,464,758.61 $7,965,842.03 968,000 $8229 TOTAL $1,372,549.09 $ 16,976,745.54 $18,349,264.63 2,280,000 $8.05 Aar 141,r 1pr"'- /409%' 74.3% $18,349,294.63 A i r *C#*jS j 7 3 Propane Weighted Average Cost of Gas (WACOG) 10/29/2007 FY 2006 -07 Projections Delivered Delivered Cost of ' Projected NYMEX CGS Cost Gallons Inventory WACOG Sep -07 Oct -07 Nov -07 . .._........ Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 May -08 .... ....... .... ... Jun -08 I Jul -08 Aug -08 Sep -08 Invoice Gallons Propane Propane Shipping Total FYTD Cost of Tank 1.65 WACOG Date Co an Seal L&L Shi n Delivered Rate Cost Cost cost Gallons Invento Invento 1.48 1.61 09!30108 $ 96,600.00 1.57 1.42 1.54 50,000 $ 77,000.00 1.57 1.35 1.47 91 457.13 75 480 1.56 1.21167 10/25106 Sea-3 40060864 1.55 39 239 1.06307 $ 40 789.54 $ 914.27 $ 41 713.61 39 239.0 $ 133 170.94 114 719 JWithdravA 1.16084 10/31/08 MONTHLY INVENTORY ADJUSTMENT $ 56,400.00 1.52 1.29 $ $ $ 1.51 $ 133 170.94 114 719 1.16084 10/31106 END OF MONTH 86 408.64 74 436 1.16084 Sea -3 4006944 83404 83472 29 213 1.04767 $ 29 924.92 $ 660.67 $ 30 605.59 6B 452.0 $ 117 014.23 103 649 1.12895 1125/08 Sea -3 4006968 1 83689 9 195 1.04767 S 9.419.08 $ 214.24 $ 9.633.32 77 647.0 $ 126 647.55 112,84 1.12232 .11/30/08 MONTHLY INVENTORY ADJUSTMENT 379 1.46189 $ 581.56 S $ 561.58 $ 127 209.11 113,223 1.12353 11/30106 END OF MONTH 81 269.22 72.334 40,889 1.12353 2/18108 Sea -3 40061014 64334 18.949 1.11327 IS 20 550.05 S 445.30 E 21 095.35 96 596.0 $ 102 364.57 91,283 1.12140 12/19/08 Sea -3 40061035 84404 18,951 1 1.11327 1 $ 20 652.23 $ 445.35 S 21 097.58 115 547.0 $ 123 462.15 110,234 1.12000 1223 /06 Sea-3 40061074 84537 9.744 1 1.11327 13 10 616.72 1 1084770 125 291.0 S 134 309.65 119,978 1.11945 12/31/08 INVENTORY ADJUSTMENT (24.7`15) 125 291.0 $ 134 309.85 95,263 1.40988 12/31106 MONTHLY INVENTORY ADJUSTMENT 375 1 0.03712 S 13.92 S $ 13.92 $ 134 323.77 95,638 1.40450 12131/06 END OF MONTH 74 567.50 63,106 42,532 1.40450 01/16/07 Sea-3 4007 -0047 85016'85118,85 28.635 1.06204 1 $ 29 742.32 1 E 888.12 S 30 411.44 153 926.0 $ 104 996.94 81.741 1 1.28453 01/31'07 INVENTORY ADJUSTMENT S (15,316.6e) 153 828.0 $ 89,6w.08 81,741 1.09715 01/31/07 MONTHLY INVENTORY ADJUSTMENT 78 $ Is $ 69882.06 81,819 1.09610 01/31 '07 1 END OF MONTH 33 749.04 30,790 51,029 1.09610 02'07 '07 Sea-3 4007 - 0108 85862, 65873 37,004 1.07287 S 38,8M.29 $ 854.80 S 38 693.09 190 930.0 $ 73 442.13 87,794 1.08331 0226/07 Sea -3 4007 -0158 0161 86306 86403 111,902 1.07277 S 19 638.96 S 438.52 1 $ 20 277.50 209 832.0 $ 93 719.63 86,696 1.08101 0228/07 MONTHLY INVENTORY ADJUSTMENT 197 1.16807 1 230.11 $ S 230.11 $ 93 949.74 06,893 1.08121 02128/07 ENO OF MONTH 30 025.27 27,770 59,123 1.08121 03/07/07 _ Sea-3 4007 -0218 88929 86650 48,852 1.10877 S 50 681.69 I $ 1,103.37 $ 51 9115.08 256 784.0 1 $ 61 990.33 1 74,722 1.09727 03%31/07 MONTHLY INVENTORY ADJUSTMENT 247 1.84215 $ 455.01 Is $ 82 445.34 74,969 1.09973 03/31/07 END OF MONTH 18 840.12 15,313 59.656 1.09973 04/03/07 Sea -3 4007 -0297 87653 87569 38 548 1.19645 $ 45 204.08 916.55 S 4B 120.83 295 332.0 $ 62 960.75 53,861 1.16895 1 0 4126/07 Sea-3 4007 -0348 882511 9,601 1.19845 11 258.80 228.28 S 11 467.06 304 933.0 $ 74 447.63 e3,462 1.17311 104/30/07 MONTHLY INVENTORY ADJUSTMENT 263 0.66209 $ 174.13 16 $ 174.13 $ 74 621.96 63,725 1.17100 X04/30107 F_ END OF MONTH 21925.62 18,724 46,001 1.17100 05/09/07_ Sea-3 4007 -0389 88621 28,775 1.27207 $ 35.916.091 $ 687.72 1 $ 36 603.81 333 708.0 $ 58 529.63 47,499 1.23223 05/111/07 Sea -3 4007 -0407 68668 9,502 1.27207 $ 11 860.11 1 S 227.10 1 S 12 087.21 343 210.0 $ 70 616.84 57,001 _ 1.23887 9_5/31/07 MONTHLY INVENTORY ADJUSTMENT 397 1.39139 $ 549.28 3.10 IS 552.38 71 169.22 57.398 1.23992 05/31/07 END OF MONTH 24 243.03 19,552 37.846 1.23992 06/05/07 Sae -3 4007 -0466 99427 89390 38,729 1.27807 $ 48 572.75 1 $ 925.62 $ 49 496.37 381 939.0 $ 73 741.40 511,281 1.26527 0660107 MONTHLY INVENTORY ADJUSTMENT 144 0.21687 $ 31.20 1 $ 31.20 $ 73 772.60 58,425 1.26269 06/30107 END OF MONTH 26 385.26 22,480 35,945 1.26269 07/06/07 Sea-3 4007 -0537 80198 9 399 1.28872 $ 11 681.28 1 $ 224.64 $ 11 905.92 391 338.0 S 40 291.18 31,879 1.26388 107/09 '07 Sea -3 4007 -0555 '90242 B8 90308 28,702 1.26837 $ 35 718.78 S 665.98 1 $ 38 404.76 420 040.0 $ 78 695.94 1.26601 07/31/07 MONTHLY INVENTORY ADJUSTMENT 1 423 0.12248 3 174.29 $ 174.29 $ 7e 870.23 _60.581 62,004 1.23976 07/31/07. END OF MONTH 39 695.48 31,212 30,792 1.23976 06115/07 Sea -3 4007 -0836 91024 91033 39,596 1.33267 $ 51 824.67 1 S 946.391 $ 52 771.08 459 6311.0 $ 91 466.54 70.810 1.29172 06/31107 MONTHLY INVENTORY ADJUSTMENT 1.153 1.74887 S 2.016.45 is 2,016.45 $ 93 482.99 71,963 1.29904 .08/31/07 END OF MONTH 41 962.98 32 303.0 39,660 1.29904 09/09/07 Sea-3 4007 -0666 81734 9,401 1.33357 $ 12 311.27 $ 225.62 $ 12 536.69 468 039.0 $ 54 499.87 41,704 1.30683 08110107 Sea -3 4007 -0704 91542 63 88 29,657 1.33357 $ 38 837.92 S 711.77 $ 38 549.69 488 896.0 $ 94 049.58 71,361 1.31794 8630107 MONTHLY INVENTORY ADJUSTMENT 499 $ $ $ 94 049.56 71,880 1.30879 109/30107 END OF MONTH $ 46 685.65 37,199 34,661 1.30879 FYTD Totals 459 638 1.12894 5 3 10800.00 5111802 Projections Delivered Delivered Cost of ' Projected NYMEX CGS Cost Gallons Inventory WACOG Sep -07 Oct -07 Nov -07 . .._........ Dec -07 Jan -08 Feb -08 Mar -08 Apr -08 May -08 .... ....... .... ... Jun -08 I Jul -08 Aug -08 Sep -08 +1941X Jlf V• 4. •w- .'. k.4 ALA A0A f14*A 37,199 $ 48,685.65 1.31 1.33 1.45 48,000 $ 69,600.00 1.39 1.52 1.65 50,000 $ 82, 500.00 1.49 1.53 1.66 50,000 $ 83,000.00 1.53 1.53 1.66 60,000 $ 99,600.00 1.56 1.48 1.61 60,000 $ 96,600.00 1.57 1.42 1.54 50,000 $ 77,000.00 1.57 1.35 1.47 40,000 $ 58,800.00 1.56 1.32 1.44 40,000 $ 57,600.00 1.55 1.30 1.42 30,000 $ 42,600.00 1.54 1.30 1.42 30,000 $ 42,600.00 1.53 1.29 1.41 40,000 $ 56,400.00 1.52 1.29 1.41 40,000 $ 56,400.00 1.51 +1941X Jlf V• 4. •w- .'. k.4 ALA A0A f14*A CSW:10/29/2007 CLEARWATER GAS SYSTEM Attachment #4 NATURAL GAS RATE BILLING FACTORS FOR OCTOBER 1, 2007 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS Intern. Contract Firm Natural Gas Rate Schedules NG Rate NG Rate RS SMF MMF LMF SGS M GN S_ LGS RAC CAC LAC SL SL w/M& NGV NSS IS CNS ell ht Applicable Annual Therm Range NA (1 - NA (4 + NA (4 + NA (4 + 0- 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA NA 100,000 NA or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons 8 +) Non -Rest. & up Monthly Customer Charge $8.00 $20.00 $30.00 $75.00 $20.00 $30.00 $75.00 $8.00 $20.00 $30.00 $20.00 $20.00 $8 Res/$20 GS $50.00 $150.00 By (For Central Pasco Territory) ($12.00) ($30.00) ($50.00) ($125.00) ($30.00) ($50.00) ($125:00) ($12.00) ($30.00) ($50.00) ($30.00) ($30.00) ($12 Res/$30 GS) ($75.00) ($250.00) Contract If not prev. if not prev. if not prev. N not prev. Non -Fuel Eneray Charae/Therm billed billed billed billed Non -Fuel Energy Charge $0.580 $0.580 $0.580 $0.580 $0.470 $0.410 $0.350 $0.200 $0.150 $0.100 $0.200 $0.300 $0.100 $0.470 $0.280 By Contract Energy Conservation Adj. (ECA) 0.180 0.180 0.180 0.180 0.180 0.180 0.180 0.180 0.180 0180 0.180 0.180 0.180 0.180 NA NA Environmental Imposition Adj. (EIA) 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 NA Weather Normalization Adj. (WNA) 0.000 0.000 0.000 0.000 0.000 0000 0.000 0.000 0.000 0.000 0.000 0 000 0.000 0.000 0.000 0.000 Contract + Total Non -Fuel Energy Charge $0.760 $0.760 $0.760 $0.760 $0.650 $0.590 $0.530 $0.380 $0.330 $0.280 $0.380 $0.480 $0.280 $0.650 $0.280 $0.000 Plus Purchased Gas Adjustment (PGA) 1.080 1080 1.080 1.080 1.080 1.080 1.080 1 080 1.080 1 080 1.080 1.080 1080 1.080 1.000 1.000 Total Energy Charge/Therm $1.840 $1.840 $1.840 $1.840 $1.730 $1.670 $1.610 $1.460 $1.410 $1.380 $1.460 $1.560 $1.360 $1.730 $1.280 $1.000 + Non -Fuel Minimum Monthly Bill $8.00 $20.00 $30.00 $75.00 $20.00 $30.00 $75.00 $8.00 $20.00 @ $30.00 C $20.00 $20.00 $8 Res/$20 GS $50.00 $150.00 Customer (For Central Pasco Territory) ($12.00) ($30.00) ($50.00) ($125.00) ($30.00) ($50.00) ($125.00) ($12.00) ($30.00) ($50.00) ($30.00) ($30.00) ($12 Res/$30 GS) ($75.00) ($250.00) Charge + Q premise @ premise Q premise + FAC + FAC + FAC + Non -Fuel Non -Fuel Therm @ premise Therm Rate for Rate for Contract + FAC 250 therms X # of Therms # Days in Mo. Compares to LP /Gallon Rate of $ 1.684 $ 1.684 $ 1.684 $ 1.684 $ 1.583 $ 1.528 $ 1.473 $ 1.336 $ 1.290 $ 1.244 $ 1.336 $ 1.427 $ 1.244 $ 1.583 $ 1.171 with 6.0% Franchise $ 1.785 $ 1.785 $ 1.785 $ 1.785 $ 1.678 $ 1.620 $ 1.562 $ 1.416 $ 1.368 $ 1.319 $ 1.416 $ 1.513 $ 1.319 $ 1.678 $ 1.241 Change from 10/2004 Therm Rate $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.130 $ 0.040 $ 0.040 %Change from 10/2004 Therm Rate 7.6% 7.6% 7.6% 7.6% 8.1% 8.4% 8.8% 9.8% 10.2% 10.6% 9.8% 9.1% 10.6% 8.1% 3.2% 4.2% Utility Tax Note: Fuel Rate per Therm 10/01/1973 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.055 $0.069 Non - Utility Taxable Fuel/Therm $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $1.011 $0.945 $0.931 BTU FACTOR .= THERMS 1100 CUBIC FEET fCCF) 10/2007 11/2007 1212007 01/2008 0212008 03/2008 0412008 05/2008 06/2008 07/2008 08/2008 09/2008 Firm Service Rates 1.053 1.053 Interruptible Service Rates 1.033 1.033 CSW:10/29/2007 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 NOVEMBER 1, 2007 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI - FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY /GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLIP Applicable Annual Gallon Range NA NA NA 0-2,500 >2,501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (1 - 3 Units) (Closed for Rest. Application) Monthly Customer Charge $8.00 $20.00 $8.00 $20.00 $30.00 $8.00 Rest. or $50.00 Set By Contract $20.00 GS if not Non -Fuel Eneray Cheraes/Gallon: prev. billed @ premise Non -Fuel Energy Charge /Gallon $1.600 $1.600 $0.800 $0.200 $0.150 $0.100 $0.390 Set By Contract Energy Conservation Adj. /Gallon 0.180 0.180 0.180 0.180 0.180 0.180 0.180 NA Environm'I Imposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj. /Gallon 0 000 0.000 0.000 0.000 0 000 0.000 0 000 0.000 Total Non -Fuel Charges/Gallon $1.780 $1.780 $0.980 $0.380 $0.330 $0.280 $0.570 By Contract + $0.000 Purchased Gas Adjustment/Gallon 2.090 2,090 2.090 2.090 219-0 2.090 2.090 2.090 Total Energy Charges/Gallon $3.870 $3.870 $3.070 $2.470 $2.420 $2.370 $2.660 $2.090 + Contract NFE Customer Charge + Minimum Monthly Bill $8.00 $20.00 $8.00 $20.00 $30.00 Any Applicable $50.00 Non -Fuel Energy Chg. Customer Charge for the Contracted + Any Applicable # of Gallons/Mo. Facility Charges Utility Tax Note: Fuel Rate per Therm 10/01/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non - Utility Taxable Fuel/Therm $1.929 $1.929 $1.929 $1.929 $1.929 $1.929 $1.929 $1.929 Change from 10/2004 Gallon Rate $ 1.040 $ 1.040 $ 1.040 $ 1.040 $ 1.040 $ 1.040 $ 1.040 $ 0.960 % Change from 10/2004 Gallon Rate 36.7% 36.7% 51.2% 72.7% 75.40/6 78.2% 64.2% 85.0% CSW:10/29/2007 BTU Factor: 2.714 Gallons /100 cubic feet (CCF) BTU Factor: 2.483 Therms /100 cubic feet (CCF) Therm Factor: 0.915 Therms/Gallon STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLP1 BRLP2 BRLP3 BRLP4 Applicable Annual Gallon Range 0-60 60.1 -120 120.1-300 > 300 or Other Rate Determinant 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS Annual Customer Charge $ 180.00 $ 144.00 $ 72.00 $ 60.00 Non -Fuel Enemw Chamea/Gallon: $ 360.00 Request Bulk Del. Set by contract $ 1.300 $ 0.800 Non -Fuel Energy Charge/Gallon $ 1.500 $ 1.300 $ 0.900 $ 0.800 Energy Conservation Adj. /Gallon 0.180 0.180 0.180 0.180 Environm'I Imposition Adj. /Gallon - - - - Weather Normalization Adj. /Gallon - - Total Non -Fuel Charges/Gallon $ 1.680 $ 1.480 $ 1.080 $ 0.980 Purchased Gas Adjustment/Gallon 2.090 2.090 2.090 2.090 Set By Contract + Total Energy Charges/Gallon $ 3.770 $ 3.570 $ 3.170 $ 3.070 Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Therm 10/01/1973 $ Non - Utility Taxable Fuel/Therm $ Change from 10/2004 Gallon Rate $ % Change from 10/2004 Gallon Rate Attachment #5 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR NOVEMBER 1, 2007 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL WILL CALL, COMMERCIAL WILL CALL" (Based on Annual Usage Level) BCLP1 SCIL BULK STANDBY / GENERATOR LPSB CONTRACT BULK "WILL CALL" CLP (Based on Annual Usage Level) WRLPI WRLP2 0-120 1 -3 UNITS > 120 1 -3 UNITS 0-2,500 Customers in this > 2,500 Customers in this (Closed for Resl Application Any Contract Customers Who $ 120.00 $ 60.00 Range of Usage $ 72.00 Range of Usage $ 72.00 $ 360.00 Request Bulk Del. Set by contract $ 1.300 $ 0.800 $ 0.200 $ 0.150 $ 0.390 Set By Contract 0.180 0.180 0.180 0.180 0.180 NA - - NA - - - 0.000 $ 1.480 $ 0.980 $ 0.380 $ 0.330 $ 0.670 Set By Contract + 2.090 2.090 2.090 2.090 2.090 0.000 2.090 $ 3.570 $ 3.070 $ 2.470 $ 2.420 $ 2.660 $ 2.090 + Contract NFE 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 1.929 $ 1.929 $ 1.929 $ 1.929 $ 1.929 $ 1.929 $ 1.929 $ 1.929 $ 1.929 $ 1.929 1.040 $ 38.1% 1.040 $ 41.1% 1.140 56.2% $ 1.140 59.1% $ 1.540 $ 75.9% 1.140 59.1% $ 1.040 72.7% $ 1.040 75.4% $ 1.040 $ 64.2% 0.960 85.0% caW:102912007 I I I I I I I I I I I Attachment #6 Residential Rate History By Components Clearwater Gas S stem Total Rate ComDone nts/Therm Contract LP Month NG emn LP allon • ECA EIA WNA PGA PGA PGA/ allon Oct-04 $ 1.710 $ 2.030 $ 0.100 $ $ - $ 1.030 $ 0.960 $ 1.130 Nov-04 $ 1.710 $ 2.030 $ 0.100 $ - $ - $ 1.030 $ 0.960 $ 1.130 Deo4)4 $ 1.750 $ 2.090 $ 0.100 $ - $ - $ 1.070 $ 1.000 $ 1.190 Jan-051 $ 1.750 $ 2.090 $ 0.100 $ $ - $ 1.070 $ 1.000 $ 1.190 Feb-05 $ 1.830 $ 2.150 $ 0.130 $ $ 0.010 $ 1.110 $ 1.040 $ 1.210 Mar-05 $ 1.8W $ 2.180 $ 0.130 $ 0.020 1110.020 $ 1.110 $ 1.040 $ 1.210 Apr-05 $ 1.860 $ 2.280 $ 0.130 $ 0.020 $ 0.020 $ 1.110 $ 1.040 $ 1.210 May-05 $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ 1.140 Jun-05 $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ 1,140 Jul-05 $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.080 $ 0.990 $ 1.140 Aug-05 $ 1.820 $ 2.220 $ 0.140 $ 0.020 $ - $ 1.080 $ 1.010 $ 1.160 S $ 1.970 $ 2.300 $ 0.140 $ 0.020 $ - $ 1.230 $ 1.160 $ 1.240 FY 04105 Avg. 1.803 $ 2.182 0.122 $0.012 $0.004 $1.085 1.015 1.174 2004 Avg. S 1.652 1.968 $ 0.129 $ 0.949 OJi79 T 1.046 Oct -05 $ 2.190 $ 2.530 $ 0.120 $ 0.020 $ - $ 1.470 $ 1.390 $ 1.490 Nov -05 $ 2.190 $ 2.530 $ 0.120 $ 0.020 $ - $ 1.470 $ 1.390 $ 1.490 Dec-05 $ 2.260 $ 2.490 $ 0.120 $ 0.020 $ - $ 1.540 $ 1.460 $ 1.450 Jan-06 $ 2.260 $ 2.490 $ 0.120 $ 0.020 $ $ 1540 $ 1.480 $ 1.450 Feb-06 $ 2.220 1 $ 2.460 $ 0.160 $ D.010 $ - $ 1.470 $ 1.390 $ 1.390 Mar-06 $ 2.2201 $ 2.460 $ 0.160 $ 0.010 $ $ 1.470 $ 1.390 $ 1.390 Apr-06 $ 2.1101 $ 2.320 $ 0.170 $ 0.010 $ S 1.350 $ 1270 $ 1.240 May-06 $ 1.9601 $ 2.360 $ 0.170 $ 0.010 $ $ 1.200 $ 1.120 $ 1.260 Jun408 $ 1.920 $ 2.420 $ 0.180 $ 0.010 $ $ 1.150 $ 1070 $ 1.330 Jul-08 $ 1.910 $ 2.500 $ 0.200 $ 0.010 $ - $ 1.120 $ 1.040 $ 1,390 NM-06 $ 1.860 $ 2.600 $ 0.200 $ 0.010 $ - $ 1.070 $ 0.990 $ 1.490 se $ 1.660 $ 2.6110 $ 0.200 $ 0.010 $ $ 1.070 $ 0.990 $ 1.490 FY 05108 Avg. r 2.080 2.480 $ 0.100 $0.013 $ $1.327 $ 1.247 S 1 A07 2005 Avg. T 2.278 0.127 To 0.004 $ 1.198 T 1.125 $ 1.256 Oct-06 $ 1.940 $ 2.600 $ 0.180 $ 0.010 $ - $ 1.170 $ 1.0901$ 1.510 Nov-08 $ 1.9401 $ 2.800 $ 0.180 $ 0.010 $ $ 1.170 $ 1.0901$ 1.510 Dec-06 $ 1.9401 $ 2.600 $ 0.180 $ 0.010 $ $ 1.170 $ 1.090 1 $ 1.510 Jan-07 $ 1.940 $ 2.600 $ 0.180 $ 0.010 $ $ 1.170 $ 1.090 $ 1.510 Feb-07 $ 1.940 $ 2.600 $ 0.180 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Mar -07 $ 1.940 $ 2.600 $ 0.180 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Apr-07 $ 1.940 $ 2.600 $ 0.180 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.490 May-07 $ 1.940 $ 2.740 $ 0.150 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.630 Jun-07 $ 1.920 $ 2.990 $ 0.180 $ - $ 0.030 $ 1.130 $ 1.050 $ 1.880 Jul-07 $ 1.840 $ 2.990 $ 0.180 $ - $ - $ 1.080 $ 1.000 $ 1.910 Au g-07 $ 1.840 $ 2.990 $ 0.160 $ - $ $ 1.080 $ 1.000 $ 1.910 Sep-07 $ 1.890 $ 2.990 $ 0.180 $ - $ 1$1.130 $ 1.050 $ 1.910 FY OW07 A . $ 1.918 2.742 $ 0.1 80 O.005 $0.008 $1.145 1.065 1.649 2006 Avg. T 2.012 T 2.501 $0.175 $0.011 1246 $ 1.188 $ 1 A15 Oct -07 $ 1.640 $ 2.990 $ 0.160 $ - $ $ 1.080 $ 1.000 $ 1.910 Nov -07 $ 1.840 $ 3.170 $ 0.180 $ - $ $ 1.080 $ 1.000 $ 2.090 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun -08 Jul -08 Aug-08 Sep-08 FY 07108 Avg. 1.840 3.080 $ 0.180 $ - 1.080 $ 1.000 2.000 2007 Avg. Incr. Above $ 0.100 $ 0.570 $ 0.010 $ - $(0-090) $ 0.090 $ 0.580 Last Year Same Month -5X 22% 0% -100% NA -9% -8% 38% Incr. Based $ 2.00 5 12AG on 20 Therms -4% 20% Equivalent CentW4(WH 6.3 11.8 for Gas vs. FPC Rate 12.0 12.0 Note: Thls Includes Promss En s increase in January 2007. Residential Gas Cheaper b Note: Added $1 per month to Monthly Customer Charge, for NG & LP eflec8ve 4/1/2005 Notes: ' Based on Bulk LP BRLP3 which is applicable for customers usina 120.1 - 300 nallonsIvear & equal to Residential LP Will Call BRWCLP .