Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JULY 2008
i"" ~' l / ~~ '~.. "" '-i'_~' CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet JUL 02 2008 TO: FROM: William B. Horne II, City Manager . \ Chuck Warrington, Managing Director fJItY OF;: : RECORDS p.!\jD LEGi:;jj! SRVCS DEPT COPIES: Rod Irwin, 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 JULY 2008 DATE: June 30, 2008 The Propane (LP) supply market has stabilized somewhat over the past month albeit at a historically high level, but the Natural Gas supply market has continued to climb significantly over the past several months due to world energy prices. Hence, we are recommending an increase in our Natural Gas Purchased Gas Adjustments (PGA) of 18(:/therm but no change in our LP PGA at this time. We will continue to closely monitor our actual gas supply costs and propose additional changes if we see the costs change substantially. We are also recommending a 8(:/therm or gallon increase in our Energy Conservation Adjustment (ECA) in order to collect most of the costs of this by FYE. We are not recommending any change in our Environmental Imposition Adjustment (EIA) nor our Weather Normalization Adjustment (WNA) clauses at this time. The net effect of these recommended changes is a net increase in our typical Residential Natural Gas customer's rate of 26(:/therm (up 13.1 %) and a net increase in our typical Residential Propane (LP) Gas customer's rate of 8(:/gallon (up 2.5%). This is a historical peak price for LP, but is still marginally below the peak price for Natural Gas, which occurred in Dec 2005 - January 2006. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after July 1, 2008: Natural Gas Firm Standard Rate Schedule PGA ....... $1.49 per therm (up 18(:/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $1.41 per therm (up 18(:/therm) Propane (LP) Gas Rate Schedule PGA .................... $2.15 per gallon (no change) Energy Conservation Adjustment (ECA) ............... $0.15 per therm or gallon (up 80) Environmental Imposition Adjustment (EIA) ......... $0.00 per therm or gallon (no change) \M b bJ r fAd" t t (\MbJJl) . eat er orma Iza Ion JUS men .. .. .......... $0.03 per therm or gallon (no change) William B. Horne II, City Manager Page 2 June 30, 2008 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru May and projections thru Period 13 of this fiscal year. These show that we are projecting being very close to in balance on our collections by FYE, which is important to our fiscal condition. 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 will now be 35% lower than electric for Natural Gas and lP will be close to even with electric. Therefore, we remain in a very 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 July 1 st billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: ~;~ ~-:::a.. William B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRA~ES\Gas Adjustments for July 200B.~~______ CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 Attachment #1 Page 1 of 3 NATURAL GAS PURCHASED GAS ADJUSTMENT IPGA-NGI Monthly Cumulative NG P~A Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelT erm Month Chames Charaes Expense Expenses EXPenses Billed (Shortage) (Shortaae) FirmlClontr Prior Year - $ 45,593.93 Oct-07 $ 2,995,907.81 $ 986,429.07 $ - $ 31.242.98 1 $ 4,013,579.86 $ 2.306.584.81 $ 11,706.995.05 $ 11,661,401.12) 1.08/1.00 Nov.07 $ 162347,55 $ 111e202,77 $ 8307,01 $ 41 104.95 $ 1,330.962.28 $ 1,542,587.20 $ 211,624.92 $ (1,449.776.20 1.08/1.00 Dee-07 $ 150.733.55 $ 1,402,134.03 $ 1,248.88 S 58,275.23 -I 1,81B)91.B9 f '1.08a.o~5:M S 3"70,59UB S (1.079,182.341 1.08/1.00 Jan-08 $ 134,272.17 $ 1,705,922.47 $ 5,395.91 $ 40,794.65 $ 1,886.385.20 $ 1,931,339.18 $ 44,953.98 $ (1,034,228.36) 1.08/1.00 Feb-08 $ 154,923.90 $ 1,620.686.97 $ 5,171.14 $ 39.591.14 $ 1.820.373.15 $ 2,104.653.65 $ 284.280.50 $ 749.947.86) 1.08/1.00 Mar-08 $ 166,041.12 $ 1,588.386.40 $ 3.749.74 $ 40,457.54 S 1.798.814.80 $ 1.910,479.00 $ 111.864.20 $ 838,083.66 " Apr-08 $ 108,354.47 $ 1.821,873.61 $ 3,190.42 $ 35,342.68 $ 1,968,761.18 $ 1,944.387.46 $ 124.373.72) $ 662.45738_ May-08 $ 82,238.60 $ 1.747,270.88 $ 3,312.29 $ 46,777.80 $ 1,879,599.57 $ 1,853,054.05 $ 126,545.52) $ 689,002.89 Jun-08 $ 82.000.00 $ 1,720,000.00 $ 3,445.01 $ 40.000.00 $ 1,845,445.01 $ 1,863,777.07 $ 18.332.06 $ 670,670.84 Jul-08 $ 82.000.00 $ 1,720,000.00 $ 3,353.35 $ 40.000.00 $ 1,845.353.35 $ 2,067,604.78 $ 222,251.42 $ (448,419.42 Aug-08 $ 82,000.00 $ 1,720.000.00 $ 2,242.10 $ 40,000.00 $ 1.844,242.10 $ 2.067.604.78 $ 223,362.68 $ (225,056.74 1.49/ .41 Sep-08 $ 82,000.00 $ 1.720,000.00 $ 1,125.28 $ 40,000.00 $ 1,843.125.28 $ 2,067,604.78 $ 224,479.49 $ (577.25 1.49/ .41 Per 13 $ 123,914.09 $ - $ - $ - 5 $ 123,914.09 $ - $ 1123,914.09) $ (124,491.33 Total YTD $ 4,406,733.26 $ 18,871,886.20 $ 46,541.13 $ 491,586.97 $ 23,816,747.56 $ 23.646,662.30 $ (170.085.26 '~ (1 Includes annual charae for Admin of $648,160 + Annual CCS ehc of $959,620 + Dividend $1,276,400 + FY 06/07 PGA write off of $28.277.51 + WNA $135.64 = $ 2,912,593.15 I Note: Billed includes Deferred Revs re-COUD of $982.285.39 (2) Net RC = $ 1,370,226.02 PROPANE ILPI GAS PURCHASED GAS ADJUSTMENT tPGA.LP) Budget Month Prior Year Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-Q8 Sep-08 Per 13 Total YTD Gallons Monthlv Sold WACOG 36,522.8 $ 1.38433 $ 33,056.8 $ 1.53309 $ 38,487.0 $ 1.60329 $ 58.278.4 $ 1.65887 $ 53,023.9 $ 1.64212 $ 44,360.6 $ 1.64377 $ 56,003.9 $ 1.62757 $ 39.023.6 $ 1.71081 $ 42,000.0 $ 1.79000 $ 37,000.0 $ 1.84000 $ 37,000.0 $ 1.88000 $ 37,000.0 $ 1.90000 $ 511,757.0 $ 1.68174 $ Cost Center Exoenses CCS Chg + Admin Chg + Dividend FY 06/07 Write off PGA & WNA Fuel PC Anywhere LP Yard Vaporization LP PGA Event fuel cost Depreciation of LP Tanks Suburban Software Systems Suburban Software Systems License Contribution to garage LP trk upgrade Interest Expense 188.92 $ 839.05 $ 755.70 $ 664.85 $ 541.49 $ 425.10 $ 336.62 $ 222.62 $ 150.72 $ 76.30 $ 19.71 $ (29.76 $ 4,191.33 $ $ (5) Commodity adjustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Ratl NG Proportion = 97.78% x Total ECA Transfer = $ 135, 41.58 + Transfer of WNA to PGA = $ (11. 27.49) Commodltv Charges 50.559.61 1 $ 50.679.05 $ 61.705.82 $ 96,676.29 $ 87.071.61 $ 72,918.62 $ 91,150.27 $ 66.761.97 $ 75,180.00 $ 68,080.00 $ 69,560.00 $ 70.300.00 $ 4 $ 860,643.23 $ 88.530.00 1 1,136.69 1 15,000.00 1 159.00 1 2,280.32 1 5,794.01 1 34,414.23 1 1,250.00 1 569.70 1 1 Monthlv Cumulative LP P A Total LP Fuel Total LP PGA Overage YTD Overage Therm Gal. Expenses Billed (Shortage) (Shortage) $ 137784.74 199.882.48 $ 69,856.53 $ 1130,025.95) $ 167.810.89 1.75/1.91 51,518.10 $ 68,188.12 $ 16,670.02 $ 151,140.67 .. ME 62,461.53 $ 80,633.03 $ 18.171.50 $ 132,969.17 1.91/2.09"'''' 97,341.14 $ 122,012.14 $ 24,671.00 $ 108,298.17) 1.9112.09 87,613.10 $ 110,891.59 $ 23,278.49 $ 85.019.67\ 1.911~:09 73,343.72 $ 91.039.92 $ 17,696.20 $ 67323.47 " '1f-i# 91 ,486.88 $ 114,285.55 $ 22,798.67 $ ..:524."!iIiiiIl 66.984.59 $ 81,365.43 $ 14,380.84 $ 30,143.97) 75,330.72 $ 90,214.04 $ 14,883.32 $ 15,260.65) 68,156.30 $ 79.474.27 $ 11,317.97 $ (3,942.68) 1.97/ .15 69,579.71 $ 79.474.27 $ 9,894.56 $ 5,951.89 1.97/ .15 70,270.24 $ 79,474.27 $ 9,204.03 $ 15,155.92 1.97t: .15 13,934.31 $ - $ 113,934.31) $ 1,221.61 1,027.902.82 $ 1,066.909.18 $ 39,006.35 I (2\ I I (4) Adjustment from FYE transfer of ECA in PGA tal 1/2 of the ECA Rate LP Proportion = 2.22% x Total ECA Transfer = $ 3, 68.26 + . Total Cost Cntr Exp Proj. Adders Allow for $ 149,133.95 $ 160,000.00 $ 10,866.05 I CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 Attachment #1 Page 2 of 3 ENERGY CONSERVATION ADJUSTMENT tECAI Monthlv Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overaae YTD Overage NGlTherm Month Expenses Notes/Exceptional Items Ex Dense EXDenses BlIIed (Shortaael (Shortage) LP/Gal. Prior Year . $ . Oct-07 $ 318,454.23 Promo$36,720,Adv $0, Employ Costs$57,160 $ - 1 $ 318,454.23 $ 111,884.77 $ (206,569.46 $ (206,569.46 0.18/0.18 Nov-07 $ 95,913.73 Promo$26,790,Adv $1,730, Employ Costs$67,394 $ 1,032.85 $ 96,946.58 $ 122,642.60 $ 25,696.02 $ (180,873.44) 0.181 .18 Dee-07 $ 76,495.95 Promo$23,405,Adv $1,025, Employ Costs$22,066 $ 904.31 $ 77,400.32 $ 156,000.42 $ 78,600.10 $ (102,273.33) 0.18/ .18 Jan-08 $ 79,959.70 Promo$24,930,Adv $230, Employ Costs$54,SOO $ 511.37 $ 80,471.07 $ 188,214.03 $ 107,742.96 $ 5,469.63 0.181 .18 Feb-08 $ 143,992.35 Promo$75,046,Adv $1S0, Employ Costs$6S,766 $ - $ 143,992.35 $ 184,801.05 $ 40,808.70 $ 46,278.33 0.18/ .18 Mar-08 $ 85,799.60 Promo$27,988,Adv $1,590, Employ COItaS58,222 $ - $ 85,799.60 $ 141,996.29 $ 56,196.69 $ 102,475.02 ,"MY' < '--^:r,:i;.AC Apr-08 $ 87,873.23 Promo$39, 190,Adv $3,310, Employ Cosls$45,373 $ - $ 87,873.23 $ 135,572.31 $ 47,699.08 $ 150,174,'._ May-08 $ 359,240.59 Promo$20,447,Adv $1,953, Employ Costs$55,692 $ - 2 $ 359,240.59 $ 70,010.94 $ (289,229.65 $ 139,055.55 Jun-08 $ 90,000.00 $ - $ 90,000.00 $ 50,072.40 $ (39,927.60) $ 178,983.15 Jul-08 $ 90,000.00 $ - $ 90,000.00 $ 103,591.10 $ 13,591.10 $ 165,392.04 Aug-08 $ 90,000.00 $ - $ 90,000.00 $ 103,591.10 $ 13,591.10 $ 151,800.94 0.151 .15 Sep-08 $ 90,000.00 $ - $ 90,000.00 $ 103,591.10 $ 13,591.10 $ 138,209.84 0.15/0.15 Per 13 6 $ - $ 138,209.84 $ 138,209.84 $ - Total YTD $ 1,607,729.38 $ 2,448.58 $ 1,610,177.96 $ 1,610,177.96 $ - (1) Includes annual charae for Admin Chg of $38,760 + CCS cha of $69,670 (6) = Transfer of ECA Collected in PGA l8l 1/2 of the ECA Rate IUD to ECA Annual Shortfall) + Dividend of $111 ,680+ FY 06/07 Write off of $4,464.66 = $ 224,574.66 Note: Maximum amount which can be transferred = $ 735,984.06 (2) FY 07/08 SO Write Off adiustment- $ 281,148.85 (3) Net CCE= $ 1,102,005.87 -- ENVIRONMENTAL IMPOSITION ADJUSTMENT tElA) MonttiiV Cumulative EI Budget Cost Center Interest Total EIA Total EIA Overaae YTD Overaae NGfTI 'erm Month Expenses Notes/Exceptional Items Expense Expenses BlIIed /Shortaae) (Shortaae) LP/C al. Prior Year $ 113,277.52 Oct-07 $ 14,182.79 $ - 1 $ 14,182.79 $ (0.21\ $ (14,183.00) $ 99,094.52 0.00/ .00 Nov-07 $ 1,427.00 $ - 2 $ 1,427.00 $ 95,999.86 $ 94,572.66 $ 193,667.38 0.00/ .00 Dee-07 $ 2,909.70 $ - $ 2,909.70 $ (0.03) $ 2,909.73 $ 190,757.65 0.00/ .00 Jan-08 $ 4,529.35 $ - $ 4,529.35 $ (0.76) $ 4,530.11 $ 186,227.54 0.001 .00 Feb-08 $ 1,427.00 $ - $ 1,427.00 $ (0.39 $ 1,427.39 $ 184,800.15 0.00/ .00 Mar-08 $ 2,799.00 $ - $ 2,799.00 $ (2.48 $ 2,801.48 $ 181,998.67 0.00/ .00 Apr-08 $ 1,427.00 $ - $ 1,427.00 $ 0.03 $ 1,426.97 $ 180,571.70 0.00/ .00 May-08 $ 8,742.93 $ - $ 8,742.93 $ (0.18 $ 8,743.11 $ 171,828.59 0.00/ .00 Jun-08 $ 10,000.00 $ - $ 10,000.00 $ - $ 10,000.00 $ 161,828.59 0.00/ .00 Jul-08 $ 10,000.00 $ - $ 10,000.00 $ - $ 10,000.00) $ 151,828.59 0.00/ .00 Aug-08 $ 10,000.00 $ - $ 10,000.00 $ - $ 10,000.00) $ 141,828.59 0.001 .00 Sep-08 $ 10,000.00 $ - $ 10,000.00 $ - $ 10,000.00) $ 131,828.59 0.00/1ll.00 Per13 $ - $ - $ - $ - $ - $ 131,828.59 Total YTD $ 77,444.77 $ - $ 77,444.77 $ 95,995.84 $ 18,551.07 (1 ) Includes annual charaes for Admin Charge $10,300 + FY 06/07 write off 01$184.79 = $ 10,484.79 (2) Billed includes $96,000 of MGP Insurance Claim Recovery I I Net CCE= $ 66,959.98 : I CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJU~I~NT CLAUSE cOU..ECrlONS FOR FY 07/08 Attachment '1 Page 3 013 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES /Both PGAs + ECA + EIA\ MonthlY Cumulative Total Budget -.. . Total All Total Recovery Overaae YTD Overage NGlTherm-Firm Month Emenses Billed (Shortage) (Shortage) LPIGallon Prior Year - - $ - $ 121,086.71 Oct-07 $ 4,546,099.36 $ 2,488,325.90 $ (2,057,773.46\ $ (1,936,686.75) 1.26/2.09 Nov-07 1,480,853.96 1,82!l'!417.78 $ 348,563.82 $ (1,588,122.93 Dec-07 1 759.163.23 2,223,618.97 $ 464,455.74 $ 11,123,667.19 1.2612.27 Jan-08 2,088,728.76 2.241,5&4.59 S 172,837.84 S (950,829.35 1.2812.27 Feb-08 2,053,405.60 2,400,345.90 $ 348,940.30 $ (603,889.05 1.26/2.27 Mar-08 1,960,557.12 2,143,512.73 $ 182,955.61 $ 420,933.45 Apr-08 2,149,548.29 2,194.245.35 $ 44.697.06 $ 376,236.39 ill May-OS '. 2,314,587.88 2,004,430.24 S (310,137.44 . eee 373.82 Jun-08 2,020,775.73 2,004,063.52 $ (16,712.22 $ 703,086.04 Jul-08 2.013,509.66 2,250,670.15 $ 237,160.50 $ 465,925.55 Aua-08 2,013,821.81 2,250,670.15 $ 236,848.34 $ 229,077.20 1.6412.30 Sep-08 2,013,395.52 2,250,670.15 $ 237,274.63 $ 8,197.43 1.6412.30 Per 13 137848.40 138,209.84 $ 361.44 $ 8,558.87 Total YTD $ 26,532,273.12 $ 26,419,745.28 $ /112,527.84 Total of All Additional Expenses Recovered ThN Adlu.tment CI.~. · $ 3,577,935.40 I I ~THERNORMAUZAnO MonthlY Cumulative WNA Budaet Interest Overaae YTD OVerage NGlTherm Month LP Gallons ExDense Rate/GIllon NG Therm. RatelTherm /ShortaHl 'Shortaae\ LP/Gallon Bea. Bal. $ - $ 257,997.00 Oct-07 . 36,522.8 $ - - 1,396,440.2 - $ 9.80 $ 258,006.80 0.0010.00 Nov-07 33.DS6.8 $ - - 1,612,140.2 - $ 0.16 $ 258 006.96 0.00/0.00 Dec-07 38.487.0 '.1' -- 1,920,988.7 -~',l"., . 2.21 j 258009.17 0.00/0.00 - . . Jiln.08 58,278,4 S . . 2.05U77.7 . . 1.28 . 288,010.48 0.00/0.00 Feb-08 53,023.9 $ - - 2,148,022.9 . $ 0.79 $ 258,011.24) 0.00/0.00 Mar-08 44,360.6 $ - 0.03 1,972,879.1 0.03 $ 59.755.25 $ 198,255.99 Apr-08 56,003.9 $ - 0.03 2.007,186.6 0.03 $ 61,946.79 $ 136,309.20 0.0310.03 May-08 39,023.6 $ - 0.03 . 1,749,356.1 0.03 $ 53,666.69 $ (82,642.51 0.0310.03 Jun-08 42,000.0 $ - 0.03 1,550,000.0 0.03 $ 47,760.00 $ (34,882.51 0.03/0.03 Jul-08 37,000.0 $ . 0.03 . 1,500,000.0 0.03 $ 46,110.00 $ 11,227.49 . 0.03/0.03 Aug-08 37,000.0 $ - . 1,500,000.0 - $ - $ 11,227.49, Sep-08 37,000.0 $ - - 1,500,000.0 - $ - $ 11,227.49 0.00/0.00 Per 13 1 $ (11.227.49\ $ - TotalYTD 511,757.0 - 20,908,591.5 $ 269,224.49 (1) Transfer of WNA FYE balance to NG PGA Last Uodated:06/30/2008 If rr /Jell fYJ U'./ I " 2- ..--'.,_...""......,._.,-_.~- - CGS Natural Gas Cost ActuaUProjectlons FYOS as of 6/27/2008 Contract Capacity Contract I Excess Capacity RelInquishment PurdIlIsed Sold Gas Sold Gas Purchaeed % Sold Gas WACOG 1'TS-1 I FTS-2 No-NCIlIc8 CaoacllY Volume Cost Gas Actual PraIect8d 0.. Ioet vs. ProIectlId Purchased 170A311 41 7.. 11.1001 RAJI III 178 $ 111700.1 111,781 138.144 172 000 03.41% 81.2% S 7.1 306,570 13 430 22.1001 117 131 2530 $ 141".01 182.381 161,214 220 000 -1.32% 73.3% $ 8.1 316.789 15.211 31 0001 188 003 1102.009 $ 21 718.1& 113 897 202.589 257 000 -5.80"" 78.8% $ 7.6 318 788 11.211 "-IIIlI1 142.808 88 873 $ Ijj~13 228 184 1....8.. 237 000 8.28% 82.1%$ 7.8 286,351 51.141 .u. 001 14&.418 4858 S ~117.78 201,581 214.802 225.000 2.13% 95.5% $ 8.4 318 7.. 11.211 31 Alool 182, 132 "-183 $ 1i:iiiI," 20t III 187218 201.000 4,38% 88.2% $ 9.3 216,570 53 430 22. SOOI 82 170 5171 $ 21166.08 177.830 200 718 178 000 1.63% 112.1% $ 10.6~ 144.212 41 788 12. ADOI 28 290 18241 $ 8.....14 157 710 174.831 170.000 102.9% S 10.04 139 560 40 440 105001 23 803 ~OOO 12000.nn 156 197 155000 $ 11.41; 144 212 41 788 10 ILJ;I]I 32 000 310M 12400.0 154 000 154 000 !l 11.811 144 212 41 788 108501 31 000 31 000 12 400.00 155 000 155 000 !l 12.0~ 139 560 40 440 105001 25 000 1000 18 400.00 155 000 155 000 $ 12.1~ Oct-ll7 Nov,Cl7 Dee.07 Jan-ll8 Feb-08 Mar-ll8 Apr-ll8 May-ll8 Jun-ll8 JuI-08 Aug.08 Sep-08 Total 2,128,530 2,280.000 0.33% 90.5% i $"~ 1 ,485,810 1,095.696 (528,504) ($172,909.73) 572, 174 257,680 2,652.052 Oct-07 Nov-ll7 Dec-07 Jan-08 Feb-08 Mar-08 Apr-ll8 May-08 Jun-08 Jul-08 Aug..08 Sep-08 i Reservation chalges FTS-1 FTS-1 FTS.2 FGU Load Load Total FTS-1 FTS-2 No-NotIce charges Usage Charge Usage Charge Total Monthly Fuel Cost Menagementfefl Factor Factor Billing ; IOOase III lahase 1111 NNTS Inhase III ~ Inhase 11I1- Comm AdJustments /Fuel Retenlion\ Per Month wi Rellnnulah wlo ReIInauish /FGU+Peoales\ $ ".112.11 . 32.13"-87 $ 787.21 . UI1.78 . 171.20 $ 1,030.310,113 . 3,081," . 28,873.41 . 701'7.00 17.0% 71.4% . 1,120 "'.~ $ 124,314.14 . 41,087.87 $ 1.113.75 $ 3,893.78 I 112.20 I 1.380.871.2& I 1 847.52 $ 38,681.4& S 8.114.00 57.5% 13.4% $ 1,559,27U I 12l1.4117.84 S G.457.28 $ 1 134.50 I 4.169.25 $ 90.09 $ 1,238.689.51 $ 2,991.49 $ 38.582.44 I 10210.00 88.1% 49.6% I 1,401 585.7 I 128,457.94 $ 42,417.28 $ 2,301.75 $ !l.429.78 I 87.82 $ 1,866,243.22 I &.132.86 I 13,026.55 I 10677.00 81.0% 61.6% $ 1 815.591.7 $ 12O.170.1lI . .at 711.08 $ 2.153.25 $ 4,672.90 I 88.67 I 1-1i32.239.85 $ /3.213.19 I 44,248.46 $ 9.311.00 67.3% 57.'% I 1 709 88B. $ 128,457.84 $ 42.487.28 $ 1 130...0 $ 4880.08 . ....79 I 1 773,490.94 $ 874.29 $ 51 118.03 $ 8101.00 84.1% 56.4% I 1.956.1011: $ 87,818.14 $ 41087.87 $ 1113.75 $ 2.011.31 $ TS84.26 $ 1,762,306.53 $ 3.284.96 $ 55,252.14 $ 8.328.00 81.5% 65.9% $ 1 888.732.11 $ 51477.87 $ 32.134.87 $ 813.80 $ 2,151.65 I 12lI4.43 $ 1.488.2ii:71 $ /4,507.10 $ 54,557.18 I 7.280.00 ....6% 84.8% $ 1 513,423.8 55 185.98 31098.36 518.75 5 899.84 $ 970.56 s 1 698 095.47 S - $ 54 637.38 $ 6 975.00 104.1% 86.8% s 1 788 578. 57 035.85 32 134.97 537.08 5 778.92 s 1 002.91 $ 1 751 915.34 $ - S 56.391.51 $ 6 930.00 99.4% 82.8% s 1 829 223 57 035.85 32 134.97 537.08 5 830.42 S 1 002.91 $ 1 792 062.85 ~ - $ 57 692.52 $ 8 975.00 100.0% 83.3% S 1 869 370.7 55 195.98 31 088.36 519.75 5 899.84 !l 970.56 ~ 1 803 312.32 $ - S 51 056.93 S 6 975.00 97.5% 86.1% $ 1 881 726.4 $1,069,731." $440,001.80 $13,248.20 $53,578.54 $4,410.01 $18,'15,859.02 $ 9,102.82 $8BO,898.07 $98,538.00 83.5% 70.2% $20,404,343.9: Total Total Projecl8d DTH WACOG ToIlIl Reservation Total Commod Cost Purchaeed lsl B Months $841,385.46 S 8.121,901.80 $9.583,287.2. 1,172,712 $8.154 2nd 6 Months $547,089.43 $ 10,213,957.22 $tO 841,058.65 91 737 $11.343 TOTAL $t,488,484.91 $ 18,'15,859.02 $20,404,343.93 2,128.530 $9.59 Propane Weighted Average Cost of Gas (WACOG) FY 2007-08 /J-rr19v# m~N r 1t.3 6/27/2008 =-..._---=;:.:~--""~.~~;~ comoanvl Invoice Gallons Propane Propane Shipping Total FYTD Cost of Tank Tank WACOG Date Sea-3 " l&L Shlnnlno Delivered Rate Cost Cost Cost Gallons Invento'" Inventorv WIthdraw! I 09130107 $ 48,686.65 37,188 1.30879 10/10107 Sea-3 4007-On8 192222 92380 I 19,835 1.46095 1 $ 28474.53 I $ 503.33 I $ 28,9n.86 19,835.0 I $ n,883.51 57 034 1.36171 10/15107 Sea-3 4007-0796 92336 92286 I 18,963 1.46095 I $ 27,222.71 I S 481.20 I $ 27703.91 38 798.0 I $ 105 367.42 75 997 1.38647 10f31107 MONTHLY INVENTORY ADJUSTMENT I 280 0.805071. 225,42 I . . I. 225.42 I S 105 592.84 762n 1.38433 10fJ1J07 END OF MONTH $ 51,144.22 36,945 39,332 1.38433 11109107 Sea-3 14007-0861 I 1 9744 1.65996 I $ 15924.33 I $ 250.31 I $ 16174.64 48 542.0 1 S 67318.86 46689 1.44186 11/13107 Sea-3 4007-0889 T 1 37,372 1.66011 T $ 61 075.94 1 $ 965.87 I $ 62 041.81 85 914.0 $ 129360.67 64061 1.53889 11f30107 MONTHLY INVENTORY ADJUSTMENT I 318 . I s . I. . Is . I S 12938o.e'7 84 379 1.53309 11/30107 END OF MONTH $ 70,732.21 46,137 38,242 1.53309 12/18J07 Sea-3 14007.1005 I I 49 342 1.68031 Is 81,629.92 I S 1279.76 I S 82,909.68 135 256.0 I $ 153 641.89 85 479 1.80917 12/31107 MONTHLY INVENTORY ADJUSTMENT I 880 0.85085 1 S 817.82 I $ - I S 817.82 I $ 154 459.71 96 339 1.60329 12/31107 END OF MONTH S 80,611.75 68,518 38,823 1.60329 01/24108 Saa-3 4008-0072 T 1 39,671 1.72267 I $ 67 312.56 1 S 1 027.31 1 $ 68 339.87 174,927.0 1 $ 158,951.62 96,187 1.65253 01/28106 Sea-3 4OO6-OOlI6 1 10000 1.72267 I $ 16967.70 I S 258.96 I $ 17226.66 184,927.0 t $ 176,178.28 106,187 1.65913 01/31108 MONTHLY INVENTORY ADJUSTMENT I 945 1.82891 T $ 1 539.32 1 $ - I $ 1 539.32 I $ 1n 717.60 107132 1.65887 01/31108 END OF MONTH $ 76,811.87 46,147 60,885 1.65887 02I08J08 Sea-3 4008-0108 I 1 20 107 1.62637 1 $ 32 180.65 I $ 520.68 I S 32 701.33 205 034.0 I $ 109 253.00 66254 1.64900 02112108 Sea-3 4008-0127 T I 19,140 1.62637 T $ 30 833.00 I $ 495.65 $ 31 128.65 224 174.0 I $ 140381.85 85 394 1.64393 02/29J08 MONTHLY INVENTORY AOJUSTMENT I 371 1.225n I $ 454.78 I $ . 1$ 454.76 I $ 140 836.41 85785 1.64212 02/29108 ENO OF MONTH S 55,3n .21 33,723 52,042 1.64212 03112108 Sea-3 4008-0208 1 I 48,316 1.64380 I $ 78125.52 I $ 1.296.42 I $ 79,421.94 I 272490.0 I $ 134 799.15 82 039 1.64311 03I311C8 MONTHLY INVENTORY ADJUSTMENT I 296 1.828611 I $ 540.70 I $ . 1 $ 540.70 I $ 135 339,85 82 335 1.64377 03131108 END OF MONTH $ 53,47UO 32,531 49,104 1.643n 04I09I0lI Sea-3 4008-0288 I I 48,504 1.613821 $ 78 964.99 I $ 1321.83 I $ 78 276.82 320994.0 I $ 131750.12 81 035 1.82584 04I30IC8 MONTHLY INVENTORY ADJUSTMENT l 243 2.20280 I $ 535281$ - IS 535.28 I $ 132 285.40 81278 1.62757 04I30Ill8 !ND OP MONTH $ 41,210.00 25320 55,HI 1.62757 05101108 Sea-3 4008-0368 I I 38.894 1.788n I $ 88 492.33 I . 1 080.02 I $ llll 572,35 358888.0 I. 110782.35 84.214 1.72521 05131108 MONTHLY INVENTORY ADJUSTMENT I 1084 0.85815 [ $ 930.23 $ . IS 930.23 1 $ 111712.58 85298 1.71081 05131108 END OF MONTH $ 52,.'3.00 30,800 34,488 1.71081 06/1 0108 FYTD Totals 380 872 0.80828 214.327 $ 3460A7 218 851 ~. 'u Projections -. . -----.'..--T.-------1 Delivered I ~!iVer~ - \- -- C~ of I Pr~~ i CGS Cost Gal~ _ ___ t ,_ _~QfY WACOG j 30800 ! $ 52693.00, 1.71 ! .--.-~-----....t..-..-..-----...,.-....-,........-..-... t. . -.. . ..--.- - I 1.84 47702 ! $ 87771.68 I 1.79 ! __h_____~~~A~ "_'^"_,~_~~--~~--_+-~-.,--,-..~.~,~--~'" ___1-~_.._.._____ 30,00() -tj---- 59, 7OQ.OO -t__....___1&tJ _.._JJJ7 L_____ 40,000 1 $ __..I~800.00 1-__._188J I .. i .. I; 1. ~!tl ..______..4Q....QQQ__~..~--...I~l?OO. 00- L__.._1-~ j ... 2,f:!..~_L __..__..!Q,OOO 1 $ 80,600.OQ.-L_______1-92_i 2_02 I 50000 i $ 100 750.00 ; 1.94 ! 2:02--j- ..~-~~_.~~@J~I?9~:99"l....I~~-J 1.72 ____~.~~__A_.'_'~'w~ 1.87 ._,-~-~--"-^.~~, 1_85 l..~-..J:~ ,Qf!:Q!l.. 1.88 i..J:~~-Q~ __.___ _1:~; I.R~::Q{JL___J,~J CSW:06/30/2008 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Enel'Qv Chal'QelThenn 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 ChargelThenn Minimum Monthly BRI (For Central Pasco Territory) Compares to LP/Gallon Rate of with 6.0% Franchise CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JULY 1, 2008 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS ---M.. SMF ....MME... ...bML Finn Natu'ral Gas Rate Schedules ~ MGS LGS ~ GAC 0- 18,000- 17,999 99,999 100.000 & up NA(1- NA(O- 3 Units) 149 tons) $8.00 ($12.00) if not prevo billed $0.200 0.030 $0.380 $1.870 $20.00 ($30.00) if not prevo billed $0.150 0.150 0.150 LAC NA (150 tons & +) $30.00 ($50.00) if not prevo billed $20.00 ($30.00) -!b... SL w/M& Rellaht NA NA Interr. NG Rate ~ ..ML-1L NA NA 100,000 Non-Resl. & up $20.00 $8 Resl$20 GS ($30.00) ($12 Res/$30 GS) if not prevo billed $0.100 $0.200 $0.300 0.150 0.150 0.150 0.000 0.000 0.000 0.030 .Q,MQ 0.030 $0.280 $0.380 $0.480 $1.770 .w2 1.!m j.g2 11.870 $8.00 520.00 CD 130.00 CD ($12.00) ($30.00) ($50.00) @ premise @ premise @ premise 0.000 0.000 $1.170 520.00 ($30.00) + FAC $50.00 $150.00 ($75.00) ($250.00) $0.100 $0.470 $0.280 0.150 0.150 NA 0.000 0.000 NA 0.030 0.030 0.030 $0.280 $0.650 $0.310 $1.770 $20.00 $8 Real$20 GS ($30.00) ($12 Rell$30 GS) +FAC $ 2.059 $ 2.059 $ 2.059 $ 2.059 $ 1.958 $ 1.903 $ 1.848 $ 1.711 $ 1.665 $ 1.620 $ 1.711 $ 1.803 $ $ 2.182 $ 2.182 $ 2.182 $ 2.182 $ 2.076 $ 2.017 $ 1.959 $ 1.814 $ 1.765 $ 1.717 $ 1.814 $ 1.911 $ $0.069 $0.069 $0.069 $0.069 $1.421 $1.421 $1.421 $1.421 1.053 1.053 1.049 NA(1- NA(4+ 3 Units) Units) NA(4+ Units) NA(4+ Units) $20.00 $30.00 $75.00 ($30.00) ($50.00) ($125.00) $0.470 $0.410 $0.350 0.150 0.150 0.150 0.000 0.000 0.000 0.030 0.030 0.030 $0.650 $0.590 $0.530 1.490 1.490 ~ $2.140 $2.080 $2.020 0.030 $0.330 Ma2 ~ Change from 10/2004 Therm Rate $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ % Change from 1012004 Therm Rate 31.6% 31.6% 31.6% 31.6% 33.8% 35.1% 36.5% 40.6% 42.2% 43.9% 40.6% 37.8% Utilitv Tax Note: Fuel Rate per Therm 10/01/1973 Non-Utility Taxable FuellTherm $8.00 $20.00 $30.00 $75.00 ($12.00) ($30.00) ($50.00) ($125.00) $0.580 $0.580 $0.580 $0.580 ~1~ 0.1~ ~1~ ~1~ 0.000 0.000 0.000 0.000 0.030 0.030 0.030 0.030 $0.760 $0.760 $0.760 $0.760 1.490 1.490 1.480 1.490 $2.250 $2.250 $2.250 $2.250 $8.00 $20.00 $30.00 575.00 ($12.00) ($30.00) ($50.00) ($125.00) $20.00 $30.00 $75.00 ($30.00) ($50.00) ($125.00) $0.069 $0.069 $0.069 $1.421 $1.421 $1.421 BTU FACTOR = THERMS/100 CUBIC FEET rCCFI 10/2007 11/2007 1212007 01/2008 0212008 03/2008 04/2008 Firm Service Retes Interruptible Service Rates 1.033 1.029 1.033 1.048 1.047 1.049 1.027 1.027 1.028 $0.069 $1.421 $1.820 $0.069 $1.421 $0.069 $1.421 $0.069 $1.421 $0.069 $1.421 1.048 OS/2008 06/2008 07/2008 08/2008 09/2008 1.027 1.049 1.028 1.049 1.029 1.050 1.030 @ premise + FAC 1.490 1.490 ~ $2.140 $1.720 $50.00 $150.00 ($75.00) ($250.00) + FAC + Non-Fuel Therm Rate for 250 therms X # Days In Mo. 1.620 $ 1.958 $ 1.574 1.717 $ 2.076 $ 1.668 0.540 $ 0.540 $ 0.480 43.9% 33.8% 38.7% $0.055 $0.069 $0.069 $1.355 $1.421 $1.421 Attachment #4 Contract NG Rate ~ NA By Contract By Contract NA NA 0.030 Contract + $0.030 Plus 1.410 $1.440 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms $ 0.480 50.0% $0.069 $1.341 CSW:06/30/2008 Attachment #5 Page 1 of2 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 JULY 1, 2008 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MUL TI-FAMIL Y LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP 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 Resl. Application) Monthly Customer Charge $8.00 $20.00 $8.00 $20.00 $30.00 $8.00 Resl. or $50.00 Set By Contract $20.00 GS if not Non-Fuel Enerav Charaes/Gallon: prevo 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.lGallon 0.150 0.150 0.150 0.150 0.150 0.150 0.150 NA Environm'llmposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon Q..QM 0.030 0.030 0030 ~ 0030 0.030 QmQ Total Non-Fuel Charges/Gallon $1.780 $1.780 $0.980 $0.380 $0.330 $0.280 $0.570 By Contract + $0.030 Purchased Gas Adjustment/Gallon 2.150 1...lli. 2.150 2.150 2.150 2.150 2.150 2.150 Total Energy Charges/Gallon $3.930 $3.930 $3.130 $2.530 $2.480 $2.430 $2.720 $2.180 + 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 Utllitv Tax Note: Fuel Rate per Therm 10/0111973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuelfTherm $1.989 $1.989 $1.989 $1.989 $1.989 $1.989 $1.989 $1.989 Change from 10/2004 Gallon Rate $ 1.100 $ 1.100 $ 1.100 $ 1.100 $ 1.100 $ 1.100 $ 1.100 $ 1.050 % Change from 10/2004 Gallon Rate 38.9% 38.9% 54.2% 76.9% 79.7% 82.7% 67.9% 92.9% CSW:06/30/2008 Attachment >>~ Page 2 of2 BTU Factor: 2.714 Gallonsl100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Thermsl100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 ThermslGallon FOR JULY 1, 2008 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" COMMERCIAL "WILL CALL n BULK STANDBYI CONTRACT BULK (Rate Class is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Level) (Based on Annual Usage Level) GENERATOR "WILL CALL" BRLP1 BRLP2 !B!.U BRLP4 WRLP1 WRLP2 BCLP1 ~ beD CLP Applicable Annual Gallon Range 0-60 60.1 - 120 120.1 - 300 > 300 0-120 > 120 o . 2,500 > 2,500 (Closed for Resl Any Contract or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Customers In this Customers in this Application CUstomers Who Range of Usage Range of Usage Request Bulk Del. Annual Customer Charge $ 180.00 $ 144.00 $ 72.00 $ 60.00 $ 120.00 $ 60.00 $ 72.00 $ 72.00 $ 360.00 Set by contract Non-Fuel Enerav Charaes/Gallon: Non-Fuel Energy Charge/Gallon $ 1.500 $ 1.300 $ 0.900 $ 0.800 $ 1.300 $ 0.800 $ 0.200 $ 0.150 $ 0.390 Set By Contract Energy Conservation Adj.lGallon 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 NA Environm'llmposition Adj.lGallon NA Weather Normalization Adj.lGallon 0.030 0.030 0.030 0.030 0.030 0.030 0.030 0.030 0.030 ~ Total Non-Fuel Chargn/Gallon $ 1.680 $ 1.480 $ 1.080 $ 0.880 $ 1.480 $ 0.980 $ 0.380 $ 0.330 $ 0.570 Set By Contract + 0.030 purchaled Gal AdJultment/Gallon 2.180 2.160 2.180 2.180 2.160 2.160 2.160 2.1'0 2.150 ~ Total Energy CharsealGaUon $ 3.830 . 3.830 $ 3.230 . 3.130 $ 3.830 $ 3.130 $ 2.530 $ 2.480 $ 2.720 $ 2.180 + Contract NFE Note: No Monthly Minimum Bill Utilitv 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 $ 0.161 $ 0.161 Non-Utility Taxable FuellTherm $ 1.989 $ 1.989 $ 1.989 $ 1.989 $ 1.989 $ 1.989 $ 1.989 $ 1.989 $ 1.989 $ 1.989 Change from 1012004 Gallon Rate $ 1.100 $ 1.100 $ 1.200 $ 1.200 $ 1.600 $ 1.200 $ 1.100 $ 1.100 $ 1.100 $ 1.050 % ChilflUB frem 10120lW Gilllen RIt@ 40.:1% 4U% 1111.1% SU% 18.8% 62,2% 76.i% 7&.7% 87,&% 112.9% CSW:06I3D120D8 I I I I I I I 1 r I I Attachment tI6 Residential Rate History By Components Clearwater Gas Svstem I I I -1 Total Rate I Com.....nenls/fherm Contract LP Month NGllherm lP/aallon' ECA EtA WNA PGA PGA PGA/aallon Oct-04 $ 1.710 I 2.030 10..100 $ - $ - $ 1.030 $ 0.960 $ 1.130 Nov-04 $ 1.710 I 2.030 I 0..100 $ - $ - $ 1.030 $ 0.960 $ 1.130 Dec-04 $ 1.750 $ 2.090 $ 0..100 $ - $ - $ 1.070 $ 1.000 $ 1.190 Jan-05 $ 1.750 $ 2.090 $ 0..100 $ - $ - $ 1.070 $ 1.000 $ 1.190 Feb-05 $ 1.830 $ 2.150 $ 0..130 $ - $ 0.010 I 1.110 $ 1.040 $ 1.210 Mar-05 $ 1.860 $ 2.180 $ 0..130 $ 0.020 $ 0.020 $ 1.110 $ 1.040 $ 1.210 ADr-05 $ 1.860 $ 2.280 $ 0..130 $ 0.020 I 0.020 $ 1.110 $ 1.040 $ 1.210 Mav-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-OS $ 1.790 $ 2.190 $ 0..130 $ 0.020 $ - $ 1.060 $ 0.990 $ 1.140 Aua-OS $ 1.820 $ 2.220 $ 0..140 $ 0.020 $ - $ 1.080 $ 1.010 $ 1.160 SeD-05 $ 1.970 $ 2.300 $ 0..140 $ 0.020 $ - $1.230 $ 1.160 $ 1.240 FY 04105 A VII. I 1.803 I 2.162 S 11..122 10.012 I 0.004 51.085 $ 1.015 I 1.174 2004 Ava. $ 1.652 $ 1.968 S 11..123 S - I - S 0.949 I 0.879 I 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 S 0..120 S 0.020 $ - $ 1.540 $ 1.460 $ 1.450 Jan-06 $ 2.260 $ 2.490 $ 0..120 $ 0.020 $ - $ 1.540 $ 1.460 $ 1.450 Feb-06 $ 2.220 $ 2.460 $ 0..160 $ 0.010 $ $1.470 $ 1.390 $ 1.390 Mar-06 $ 2.220 $ 2.460 $ 0..160 $0.010 $ - $ 1.470 $ 1.390 $ 1.390 ADr-06 $ 2.110 $ 2.320 $ 0..170 $0.010 $ - $ 1.350 $ 1.270 $ 1.240 Mev-06 $ 1.960 $ 2.360 $ 0..170 $ 0.010 $ - $1.200 $ 1.120 $ 1.280 Jun-06 $ 1.920 $ 2.420 $ 0..160 $0.010 $ $1.150 $ 1.070 $ 1.330 Jul-06 $ 1.910 $ 2.500 $ 0..200 $0.010 $ - $ 1.120 $ 1.040 $ 1.390 Aua-06 $ 1.860 $ 2.600 $ 0..200 $ 0.010 $ - $ 1.070 $ 0.990 $ 1.490 SeD-a6 $ 1.860 $ 2.600 $ 0..200 $ 0.010 $ - $ 1.070 $ 0.990 $ 1.490 FY 05106 A vg. I 2.080 S 2.480 S 11.160 $0.013 I - T 1.327 5 1.247 I 1.407 2005 Avg. I 1.925 I 2.278 $ 11..127 10.017 S 0.004 I 1.198 I 1.125 I 1.256 Oct-06 $ 1.940 $ 2.600 $ 0..180 $ 0.010 $ $ 1.170 $ 1.090 $ 1.510 Nov-06 $ 1.940 $ 2.600 $ 0..180 10.010 $ - $ 1.170 $ 1.090 $ 1.51.0 Dec-06 $ 1.940 $ 2.600 $ 0..160 $0.010 $ $ 1.170 $ 1.090 $ 1.510 Jan-07 $ 1.940 $ 2.600 $ 0..160 10.010 $ - $ 1.170 $ 1.090 $ 1.510 F eb-07 $ 1.940 $ 2.600 $ 0..160 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Mar-07 $ 1.940 $ 2.600 $ 0..160 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Apr-07 $ 1.940 $ 2.600 $ 0.160 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.490 May-07 $ 1.940 $ 2.740 I 0.180 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.630 Jun-07 $ 1.920 $ 2.990 I 0..160 I - I 0.030 11.130 $ 1.050 $ 1.880 Jul-07 $ 1.840 $ 2.990 $ 0.160 $ - $ - $ 1.080 I 1.000 $ 1.910 Aua-07 $ 1.840 $ 2.990 $ 0..180 I - $ - $ 1.080 $ 1.000 $ 1.910 SeD-07 $ 1.890 $ 2.990 $ 0.160 $ - $ - $ 1.130 $ 1.050 $ 1.910 FY 06/07 Avg. I 1.918 S 2.742 S 11..180 S 0.005 I 0.008 S 1.145 S 1.055 I 1.649 2006 Ava. $ 2.012 S 2.501 S 11..175 I 0.011 I . $ 1.245 I 1.166 I 1.415 Oct-07 $ 1.840 $ 2.990 $ 11..180 $ - $ - 11.080 $ 1.000 $ 1.910 Nov-07 $ 1.840 $ 3.170 $ 11..180 $ - $ - $ 1.080 $ 1.000 $ 2.090 Dee-07 $ 1.840 I 3.170 I 0..180 I - $ - $ 1.080 $ 1.000 $ 2.090 Jan-08 $ 1.840 $ 3.170 $ 8.160 $ - $ - $ 1.080 $ 1.000 $ 2.090 Feb-08 $ 1.840 $ 3.170 $ 11..160 $ - $ - $ 1.080 $ 1.000 $ 2.090 Mar-06 $ 1.810 I 3.120 S 8.150 $ - $ 0.030 $ 1.050 $ 0.970 $ 2.040 APr-08 $ 1.810 I 3.120 S 8.150 $ - $ 0.030 $ 1.050 $ 0.970 $ 2.040 Mev-08 $ 1.860 $ 3.120 S ..090 $ - $ 0.030 $ 1.180 $ 1.100 $ 2.100 Jun-08 $ 1.990 $ 3.150 $ 0..070 $ $ 0.030 $ 1.310 $ 1.230 $ 2.150 Jul-08 $ 2.250 $ 3.230 S ..150 S - $ 0.030 $ 1.490 $ 1.410 $ 2.150 Aua-08 SeD-08 FY 07/08 Ava. S 1.894 S 3.141 : S 11..151 $ - S 0.015 $ 1.148 $ 1.068 I ~Cl75 2007 Avg. $ 1.893 S 2.869 I 11..180 S 0.003 S 0.008 $ 1.123 $ 1.043 $ 'l':Tr9 Incr. Above $ 0.410 I 0.240 $ '11..0301 $ - I 0.030 $ OA10 $ 0.410 I 1.240 last Year Same Month 22% 8% -17% NA NA 38% 41% 13% Incr. Based $ 8.20 $ 5.25 on 20 Therms 18% 7% Equivalent CentsIKWH 7.7 12.0 for Gas vs. FPC Rate 11.7 11.7 Note: This Is Proaress Energy's resldenlIIIl rate In 1/2008 for usaae >1.000 KWH. ResldenUal) I Gas Cheaper bv -35% 3% Nole: Added $1 Der month to Monthlv Customer Charae for NG & LP effective 4/112005 I I I Notes: I I . Based on Bulk LP IBRLP3 which is aD' icable for customers usinn 120.1 - 300 nalbn"^'ear & ....ual to ResidentialLP Will Call1BRWCLP .