Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MAY 2010
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet RECEIVED FROM: William B. Home II, City Manager Chuck Warrington, Managing Director rJ; Rod Irwin, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. AccountantlCGS; Tom Mad ley, Sr. AccountantlCCS; Laura Damico, Sr. AccountantlCCS APR 3 0 2010 OFFICiAl RECORDS AND lEGISLATIVE SRVCS DEPT TO: COPIES: SUBJECT: GAS ADJUSTMENTS EFFECTIVE MAY 2010 DATE: April 28, 2010 World Gas supply markets have been fairly stable and have actually lowered a little as the winter peak demand season passes. Therefore, we are recommending that we decrease our Natural Gas Purchased Gas Adjustments (PGA) by 3~ltherm, and we are recommending that we decrease our LP PGA by 3~/gallon in May. We are also recommending a decrease in our Energy Conservation Adjustment (ECA) of 2~ltherm or gallon and an offsetting increase in our Regulatory Imposition Adjustment (RIA) 2~ltherm or gallon. This is because ECA recovery has been running ahead, but we expect some draws against our EIA portion of our RIA as we begin to assess the long-term handling of our Manufactured Gas Plant. We are not recommending any change in our Usage & Inflation Adjustment (UIA) at this time. The overall effect of these recommended changes is a 3~thenn (-2.0%) decrease in our typical Residential Natural Gas customer's rate and a 3~gallon (-1.0%) decrease 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 May 1, 2010: Natural Gas Firm Standard Rate Schedule PGA ....... $0.89 per therm (down 3~/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.81 per therm (down 3~/therm) Propane (LP) Gas Rate Schedule PGA .................... $1.73 per gallon (down 3~/gallon) Energy Conservation Adjustment (ECA) ............... $0.09 per therm or gallon (down 2~) Regulatory Imposition Adjustment (EIA) ................. $0.03 per therm or gallon (up 2~) Usage & Inflation Adjustment (WNA) ........ ...... ...... $0.00 per therm or gallon (no change) William B. Horne II, City Manager Page 2 April 28, 2010 Attachment #1 shows the current and projected status of our adjustment clauses. As of the end of March, we are overall under collected by about $960,000, which is rapidly dropping. The adjustment rates are designed to bring us back closer into balance by FYE, which is important to our financials. 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 5+ years and shows our relationship to current electric prices. Please note that the last paae of this analysis shows that over the past 8 years our residential natural aas rates have risen iust 3.7% as compared to a 57% increase for Proaress Eneray Florida residential rates. Thafs an averaae annual increase of 0.5%/year for natural aas vs. 7.1%/year for electric - a remarkable difference! I should point out that the overall effect is that our typical Residential customer rates are now approximately 63% lower than electric for Natural Gas and LP is now about 22% lower than electric. It should be pointed out that Progress Energy Florida recently secured FPSC approval of a small rate increase, which is reflected in these numbers. These competitive positions vs. electric are a result of their sizable increases over the past year, while we our rates have overall declined & been much more stable. Additionally, TECO Peoples Gas received approval to increase their natural gas rates, so we are now below their pricing for a typical residential customer. We will continue to track these balances monthly, make ongoing 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 May 1 st billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: 'A:d~{)~ ~. lam B. Home II, City Manager If': U:\My DocumentsIMSOFFICE\WINWORD\GASRATES\Gas Adjustments for May 2010.doc CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2009/2010 Attachment #1 Page1 of 3 NATURAL GAS PURCHASED GAS ADJUSTMENT IPGA.NGI I Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage I RatelTherm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) : Flrm/Contr Prior Year - i $ 1,978,810.09 Oct-09 $ 4,104,827.48 1,030,025.41 $ $ 83,493.04 1 $ 5,218,345.93 $ 1,162,846.59 i $ (4,055,499.34 $ 2,076,689.25) 0.83/0.75 -- - Nov-09 $ 153,592.66 659,954.32 $ 10,383.45 $ 46,068.52 $ 869,998.95 1,216,208.71 i $ 346,209.76 $ 1,730,479.49 0.83/0.75 Dec-09 $ 166,336.49 1,198,709.12 $ 8,652.40 $ 44,477.68 $ 1,418,175.69 1,510,448.11 i $ 92,272.42 $ 1,638,207.06 0.83/0.75 ---- Jan-10 $ 128,486.03 1,690,948.47 $ 8,191.04 $ 44,064.59 $ 1,871,690.13 1,982,380.17 I $ 110,690.04 $ 1,527,517.02 0.83/0.75 Feb-10 $ 142,905.76 1,728,219.13 $ 7,637.59 $ 38,883.79 $ 1,917,646.27 2,013,543.84 $ 95,897.57 $ 1,431,619.44 0.88/0.80 Mar-10 $ 163,401.94 1,527,134.13 $ 7,158.10 $ 48,654.83 $ 1,746,349.00 2,182,096.21 $ 435,747.21 $ 995,872.23 0.92/0.84 Apr-10 $ 185,000.00 1,200,000.00 $ 4,979.36 $ 45,000.00 ,$ 1,434,979.36 1,733,952.19 $ 298,972.82 $ 696,899.4111 0.92/0.84 MaY-10 $ 120,000.00 1,100,000.00 $ 3,484.50 $ 45,000.00 !$ 1,268,484.50 1,513,127.82 $ 244,643.32 $ 452,256.09 0.89/0.81 Jun-10 i$ 120,000.00 1,000,000.00 $ 2,261.28 $ 45,000.00 '$ 1,167,261.28 1,366,138.26 $ 198,876.98 $ 253,379.1111 0.89/0.81 Jul-10 $ 120,000.00 900,000.00 $ 1,266.90 $ 45,000.00 $ 1,066,266.90 1,305,613.15 $ 239,346.25 $ (14,032.86) 1 0.89/0.81 Aug-10 $ 120,000.00 900,000.00 $ - $ 45,000.00 $ 1,065,000.00 1,305,613.15 $ 240,613.15 $ 226,580.29 I 0.89/0.81 Sep-10 $ 120,000.00 900,000.00 $ - $ 45,000.00 $ 1,065,000.00 1,305,613.15 $ 240,613.15 $ 467,193.43 I 0.89/0.81 Per13 $ 461,292.59 $ - 5 $ 461,292.59 $ (461,292.59 $ 5,900.85 I Total YTD $ 6,105,842.95 $ 13,834,990.58 $ 54,014.60 $ 575,642.45 $ 20,570,490.57 $ 18,597,581.33 $ (1,972,909.24 (1 Incl. Annual Admin chg of $737,700 + Annual CCS cha of $1 ,025,280 + Dividend of $2,221 ,865.79 + FY 08/09 PGA write off of $49,598.99 + WNA $198.01 = $ 4,034,642.79 (5) Commodity adiustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Rate NG Proportion = 96.5% x Total ECA Transfer - $ 461,292.59 + Transfer of WNA to PGA = ! $ - Net RC = 1,609,907.57 , i , PROPANE ILP\ GAS PURCHASED GAS ADJUSTMENT IPGA.LPI I MOmmy ~umu alive LP PGA Budget Gallons Monthly Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) Prior Year $ (15,808.82 Oct-09 28,689.9 $ 1.02359 $ 79.04 $ 29,366.69 1 $ 163,185.43 $ 45,540.29 $ (117,645.14) $ (133,453.96 I 1.45/1.59 Nov-09 29,048.5 $ 1.10325 $ 667.27 32,047.76 32,715.03 46,187.58 $ 13,4 72.55 $ (119,981.41 ! 1.45/1.59 - Dec-09 42,355.2 $ 1.17046 $ 599.91 49,575.07 50,174.97 70,088.19 $ 19,913.22 $ (100,068.19 1.53/1.67 Jan-10 59,420.7 $ 1.33797 $ 500.34 79,503.11 80,003.45 99,489.31 $ 19,485.86 $ (80,582.34) I 1.53/1.67 Feb-10 42,940.5 $ 1.42201 $ 402.91 61,061.82 61,464.73 72,534.43 $ 11,069.70 $ (69,512.64 1.55/1.69 Mar-10 - 46,996.0 $ 1 .40506 $ 347.56 I 66,032.20 66,379.76 82,210.07 : $ (53,682.33 1.61/1.76 15,830.31 $ Apr-10 43,000.0 $ 1.33000 $ 268.41 57,190.00 I 57,458.41 75,493.78 ' $ 18,035.36 $ (35,646.97 I 1.61/1.76 May-10 I 41,000.0 $ 1.28000 $ 178.23 52,480.00 52,658.23 ' 70,755.46 i $ 18,097.23 $ (17,549.74 1.58/1.73 Jun-10 31,000.0 $ 1.29000 $ 87.75 39,990.00 40,077.75 53,498.03 $ 13,420.28 $ (4,129.45 1.58/1.73 Jul-10 29,000.0 $ 1.30000 $ 20.65 37,700.00 37,720.65 50,046.55 $ 12,325.90 $ 8,196.45 1.58/1 .73 ----- Aug-10 29,000.0 $ 1.30000 $ 37,700.00 37,700.00 50,046.55 $ 12,346.55 $ 20,542.99 1.58/1.73 -- - Seo-10 29,000.0 $ 1.31000 $ - 37,990.00 37,990.00 50,046.55 $ 12,056.55 $ 32,599.54 1.58/1.73 P13 16,260.3 4 32,991.13 $ (32,991.13) $ (391.59) --_._~-~ Total YTD 467,711.1 $ 1.24144 $ 3,152.08 $ 580,636.65 1$ 750,519.55 $ 765,936.78 $ 15,417.23 Cost Center Expenses CCS Chg, Admin & Dividend 1$ 72,128.53 1 FY 08/09 Write off PGA & WNA 1,576.50 1 , i Fuel 15,000.00 1 I i Donations to events 7,529.00 1 LP Yard Vaporizationlloss due to malfunctionintl meter 815.91 1 (4) Adiustment from FYE transfer of ECA in PGA ~of the ECA Rate ----.- LP PGA Event fuel cost 2,275.52 1 LP Proportion = 3.5% x Total ECA Transfer = 1$ 16,730.82 I Suburban Software Systems 1 + Additional Projected Costs Needed = !$ 16,260.31 , Depreciation of LP tanks 34,414.23 1 LP Holding Tank Restoration Proj. for Year Additional Needed Total Cost Center Expenses $ 133,739.69 $ 150,000.00 $ 16,260.31 I i I CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2009/2010 Attachment #1 Page2 of 3 ENERGY CONSERVATION ADJUSTMENT IECA\ I ! Monthlv Cumulative ECA Budget Cost Center Interest Total ECA TotalECA Overage YTD Overage I NGlTherm Month Expenses Notes/ExceDtlonalltems Ex Dense EXDenses Billed /Shortaael /Shortaael LP/Gal. Prior Year - $ . Oct-09 $ 157,315.60 Promo$16,838,Adv $900, Employ Costs$70,739 $ . 1 $ 157,315.60 $ 60,122.81 $ 197,192.79) $ 197,192,79) 0.07/0.07 Nov-09 $ 72,271.71 Promo$16,717.Adv $3,178, Employ Costs$S2,377 1$ 485.96 72,757.67 62,136.27 $ (10,621.40) $ (107,814.19) 0.07/0.07 Dec-09 $ 108,452.39 Promo$63, 186,Adv $1,661, Employ Costs$43,60S $ 539.07 108,991.46 I 57,531.05 $ 151,460.41) $ (159,274.60\ 0.07/0.07 Jan-10 $ 64,891.19 $ 796.37 65,687.56 I - 120,998.60 $ 55,311,04 $ (103,963.57) 0.07/0.07 Promo$16,733,Adv $2,154, Employ Costs$46,004 Feb-10 $ 114,075.65 Promo$68,S14.Adv $0, Employ Costs$4S,562 $ 519.82 114,595.47 173,661.50 $ 59,066,03 $ 144,897.54) 0.11/0.11 Mar-10 $ 93,939.92 Promo$26,230,Adv $300, Employ Costs$6S,943 $ 224.49 94,164.41 190,326.50 $ 96,162.09 $ 51,264.56 I 0.11/0.11 Apr-10 $ 100,000.00 $ 256.32 , 99,743.68 132,019.66 $ 32,275.99 $ 83,540.54 I 0.11/0.11 May-10 $ 100,000.00 $ 417.70 2 1 99,582.30 97,557.65 $ (2,024.65 $ 81,515.89 0.09/0.09 Jun-10 $ 100,000.00 $ 407.58 99,592.42 87,752.86 $ (11,839.56 $ 69,676.33 I 0.09/0.09 Jul-10 $ 100,000.00 $ 348.38 99,651.62 83,830.94 $ (15,820.68 $ 53,855.65 I 0.09/0.09 Aua-10 $ 100,000.00 $ 269.28 99,730.72 83,830.94 $ (15,899.78 $ 37,955.87 0.09/0.09 Sep-10 $ 600,000.00 Incl. $SooK Recovery for NGV Station in FY 09-10 $ 189.78 599,810.22 83,830.94 $ (515,979.28 $ (478,023.4f\ 0.09/0.09 P13 6 - 478,023.41 $ 478,023.41 $ - Total YTD $ 1,710,946.46 $ 676.67 $ 1,711,623.13 $ 1,711,623.13 $ - (1 ) Includes Annual Admin Charae of $10,620 + CCS chg of $54,470 + Dividend $143.53 (6) = Transfer of ECA Collected in PGA <<l 1/2 of the ECA Rate (up to ECA Annual Shortfall) + FY 08/09 Write off of $3,515.06 = $ 68,748.59 Note: Maximum amount which can be transferred = $ 855,811.56 I Net CCE= $ 1,642,197.87 I I I ENVIRONMENTAL IMPO~ITION ADJUSTMENT IEIA\ ! I I I Monthlv ! Cumulative EIA Budget Cost Center I ntereat I Total EIA Total EIA Overage : YTD Overaae NG/Therm Month Expenses Notes/ExceDtlonalltema Expense I Expenses Billed /Shortage) (Shortage) ! LP/Gal. Prior Year - $ - $ 112,236.56) i Oct-09 $ 11,862.40 $ 61.18 1 $ 11,923.58 8,584.38 $ (3,339.20) $ (15,575.76\ 0.01/0.01 Nov-09 $ 1,544.50 $ 77.88 1,622.38 8,875.87 $ 7,253.49 $ (8,322.27) 0.01/0.01 Dec-09 $ 1,377.00 $ 41.61 1,418.61 12,210.44 $ 10,791.83 $ 2,469.56 0.01/0.01 Jan-10 $ 1,377.00 $ - 1,377.00 I 17,289.71 $ 15,912.71 $ 18,382.27 0.0110.01 Feb-10 $ 1,542.00 $ I 1,542.00 - 15,852.24 $ 14,310.24 $ 32,692.51 0.01/0.01 - Mar-10 $ 8,497.50 '$ - 8,497.50 17,303.41 1 $ 8,805.91 $ 41 ,498.42 0.01/0.01 Apr-10 $ 10,000.00 $ - 10,000.00 12,698.61 $ 2,698.61 $ 44,197.02 0.01/0.01 May-10 $ 10,000.00 $ - 10,000.00 34,407.27 $ 24,407.27 $ 68,604.29 0.03/0.03 Jun-10 $ 10,000.00 $ - 10,000.00 30,949.25 $ 20,949.25 $ 89,553.54 0.03/0.03 Jul-10 $ 10,000.00 $ - I 10,000.00 29,566.04 $ 19,566.04 $ 109,119.58 0.03/0.03 Aua-10 $ 10,000.00 $ - 10,000.00 29,566.04 $ 19,566.04 $ 128,685.63 0.03/0.03 Sep-10 $ 60,000.00 Incl. $50K Recovef';"for MGP RAP Study $ - 60,000.00 29,566.04 $ (30,433.96) $ 98,251.67 0.03/0.03 P13 - i $ - $ 98,251.67 I Total YTD $ 136,200.40 $ 180.67 136,381.07 246,869.30 $ 110,488.23 -- _.--- (1) Includes Annual Admin Charaes = $ 10,180.00 FY 08/09 Write off of $0 I , Net CCE=, $ 126,020.40 I , I i CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2009/2010 Attachment #1 Page3 of 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES {Both PGAs + ECA + EIA I Monthlv Cumulative Total Budget Total All Total Recovery Overage YTD Overage NG/TH (Firm) Month Expenses Billed (Shortage) (Shortaael NG/LP Prior Year ! - - $ - $ 1,950,764.71 Oct-09 I $ 5,550,770.54 $ 1,277,094.07 1 $ (4,273,676.47) $ (2,322,911.76) I 0.91/1.67 Nov-09 I 977,094.03 1,333,408.43 $ 356,314.40 $ (1,966,597.36)1 0.91/1.67 j--- I Dec-09 1,578,760.73 1,650,277. 79 $ 71,517.06 $ (1,895,080.30) 0.91/1.75 Jan-10 I 2,018,758.14 2,220,157.79 $ 201,399.65 $ (1,693,680.66) 1 0.91/1.75 Feb-10 i 2,095,248.47 2,275,592.01 $ 180,343.54 $ (1,513,337.11 1.00/1.81 Mar-10 I 1,915,390.67 2,471,936.19 $ 556,545.52 $ (956,791.59 1.04/1.88 Apr-10 ! 1 1,602,181.45 1,954,164.23 $ 351,982.78 $ (604,808.8111 1.04/1.88 May-10 i I , 1,430,725.03 1,715,848.19 $ 285,123.17 $ (319,685.64 1.01/1.85 i Jun-10 1,316,931.45 1,538,338.40 $ 221,406.95 $ (98,278.69 1.01/1.85 Jul-10 1,213,639.16 1,469,056.68 $ 255,417.52 $ 157,138.83 1.01/1.85 .- Aug-10 1,212,430.72 1,469,056.68 $ 256,625.96 $ 413,764.78 1.01/1.85 5ep-10 1,762,800.22 1,469,056.68 $ (293,743.54\ $ 120,021.24 1.01/1.85 Per13 I 494,283.72 478,023.41 I $ (16,260.31 I $ 103.760.93 1.01/1.85 Total YTDi 23,169,014.33 21,322,010.55 I $ (1,847,003.78) I Total of All Additional Expenses Recovered Thru Adiustment Clauses = $ 4,247,311.07 WEATHER NORMALIZATION lWNAl MonthlY Cumulative WNA Budaet Interest Overage i YTO Overage NGlTherm Month LP Gallons Expense Rate/Gallon NG Therms RatelTherm (Shortaae) (Shortaae) LP/Gal Beg. Ba!. $ - I. $ - Oct-09 , 28,689.9 $ - - 1,450,921.70 - $ - 1$ - I 0.00/0.00 Nov-09 29,048.5 $ - - 1,510,750.50 - :$ - $ - 0.00/0.00 Dec-09 42,355.2 ! $ 1,874,118.80 ,$ $ r-- . - - - - --+-u 0.00/0.00 Jan-10 59,420.7 $ - - 2,424,224.20 - $ - 1$ - 0.00/0.00 Feb-10 42,940.5 $ $ .- - - 2,355,782.10 - - $ - 0.00/0.00 Mar-10 46,996.0 $ - - 2,455,313.10 ! - $ (0.03) $ (0.03 i 0.00/0.00 Apr-10 43,000.0 $ , 1,940,000.00 I '$ $ (0.03 0.00/0.00 .. - - I - - May-10 41,000.0 $ 1,750,000.00 i $ $ (0.03 0.00/0.00 n - - - - Jun-10 31,000.0 $ - - I 1,580,000.00 - $ - $ (0.03 0.00/0.00 Jul-10 29,000.0 $ - I - 1,510,000.00 I - $ - $ (0.03 0.00/0.00 Aug-10 , 29,000.0 $ - I - 1,510,000.00 I - $ - $ (0.03 0.00/0.00 5ep-10 : 29,000.0 $ - - 1,510,000.00 i - $ - $ to.03 0.00/0.00 Per13 : ! $ 0.03 I Total YTD 451,450.8 - 21,871,110.40 $ to.03) ! Last Updated:04/28/201 0 I ! I I I II- rrlk.l{j(J fUJr tJ;. L CGS Natural Gas Cost Actual/Projections FY10 as of 4/19/2010 Oct-09 Noy.o9 Oec-09 Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Contract Capacity Contract Excess Capacity Relinquishment Purchased Sold Gas Sold Gas Purchased % Sold Gas WACOG FTS-1 FTS-2 No-Notice CaDacltv Volume Cost Gas Actual Pro'ected Gas lost YS. Pro'ected Purchased 170,438 41,788 16,600 69,771 48,892 1$ 31,830.14 162,466 144,806 147,000 0.91',4 98.6% 1$ 8.19 306,670 63 430 22,600 186,012 49,880 1$ 12,922.90 174,988 161 076 163,000 -7.10% 92.7% $ 6.43 316,789 66,211 3,100 166,479 21,001 $ 8,113.21 206,621 187,412 204,000 -17.38% 91.9% $ 6.84 316,789 66,211 46 600 98,604 22,289 $ 44 730.92 273,396 242,422 252,000 13.83% $ 7.24 288,132 49,888 42,000 84,393 21,638 $ 13,648.28 261,607 236,678 230,000 2.41',4 $ 8,78 318,789 66211 31 000 134 884 38,883 $ 9047.78 237 138 246 631 224.000 $ 8,23 216,570 53.430 22,500 92.487 30.000 $ 12000.00) 177,513 194.000 $ 6.87 144,212 41.788 12.400 26.000 20.000 $ '8.000.00 160,000 175.000 $ 6.80 139,560 40.440 10.500 27.500 40,000 $ 20.000.00 152,500 158.000 $ 6.84 144,212 41.788 10.850 33.500 40.000 $ 20.000.00) 152,500 151.000 $ 6.62 144,212 41.788 10.850 33.500 40.000 $ 20000.00) 152,500 151.000 $ 6.62 139,560 40.440 10,500 25.000 40.000 $ 20.000.00 155,000 151.000 $ 6.53 Total 2,641,833 570,393 238,200 966,110 (408,063) ($218,193.19) 2,246,116 1,206,823 2,200,000 .0.29% 94.4% $6.69 Oct-09 NoY-09 Oec.o9 Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Reservation charges FTS-1 FTS-1 FTS-2 FGU Load Load Total FTS-1 FTS-2 No-Notice charges US;:'~~;eh~~ge Usage Charge Total Monthly Fuel Cost Management fee Factor Factor Billing (ohase III (ohase 11I\ NNTS lohase 1111- Commoditv charoes Adjustments IFuel Retention) Per Month wi Relinauish wla Relinauish (FGU+PeoDles\ $ 89,112.81 1$ 32 134.97 15 78.26 5 2,222.49 5 15 852 897.88 $ 6,888.33 5 28,932.14 rT 10,454.00 92.2',4 71.8% 5 843,963.14 $ 124,314.14 1$ 41,087.87 1$ 1,113.76 $ 2,844.91 $ 1.28 $ 968,318.92 $ 3,883.45 5 24,987.09 $ 12,038.00 68.4% 48.8% $ 1,124,894.30 $ 128467.94 $ 42 467.26 $ 1 634.60 $ 3 070.80 $ $ 1 220 406.98 $ 9088.74 $ 32.968.18 $ 13 306.00 68.8% 66.6% $ 1412928.60 $ 128,467.94 $ 42,467.28 $ 2,301.76 $ 4,131.34 $ 89.03 $ 1,819,410.00 $ 22,132.88 $ 48,810.36 $ 14,672.00 78.2% 73.6% $ 1,979,323.11 $ 118,028.63 $ 38,348.49 $ 2,079.00 $ 3,091.96 $ (622.99 $ 1 480,881.63 $ 13,042,30 $ 40,682.64 $ 12,988.00 80.0% 74.9% $ 1,706,766,88 $ 128,467.94 $ 42,467.28 '5 1,634.80 $ 2,713.70 $ t873.67 $ 1,288,622.41 $ 3,689.89 $ 34,912.39 $ 12,871.00 70.7% 83.7',4 $ 1,478,836.93 $ 124,614.38 $ 40.206.08 $ 1,113.75 $ 3,768.67 $ 189.15 $ 1,036.211.92 $ $ 35,367.40 $ 9.520.70 74.0% 65,7% $ 1.220,286.07 $ 82,979.58 $ 31.445.47 $ 613.80 $ 3,602.58 $ 147.94 $ 956.357.06 $ $ 32,647.52 $ 8.595.83 96.4% 86.0% $ 1087.395.91 $ 80,302.82 $ 30.431.10 $ 519.75 $ 3,427.36 $ 143.16 $ 933,914.61 $ $ 31.893.09 $ 8.215.00 108.9% 84.7% $ 1.043.168.29 $ 82,979.58 $ 31.445.47 $ 537.08 $ 3,385.57 $ 147.94 $ 896.180.71 $ $ 30.585.00 $ 8.215.00 104.5% 82.0% $ 1.009.142.85 $ 82,979.58 $ 31.445.47 $ 537.08 $ 3,385.57 $ 147.94 $ 896,180.71 $ $ 30.585.00 $ 8,215.00 104.5% 82.0% $ 1.009.142.84 $ 80.302.82 $ 30.431.10 $ 519.75 $ 3,520.36 $ 143.16 $ 908.870.83 $ $ 31.013.09 $ 8,378.21 110.7% 86.1% $ 1012,124.51 Total $1,228,985.88 $434,347.60 $13,171.96 $38,965.12 ($347.57) $13,205,942.33 $ 57,363.17 $403,251.79 $127,167.74 86.3% 72.9% $15,025,549.13 Total Projected DTH WACOG Total Reservation Total Commod; Cast Purchased 1 st 6 Months $1,066,062.18 $ 7,578,226.48 $8,644,288.66 1,296,103 $6.669 2nd 6 Months $753 544.62 $ 5627715.85 $6381 260.47 950013 $6.717 TOTAL $1,819,606.80 $ 13,205,942.33 $15,025,549.13 2,246,116 $6.69 Propane Weighted Average Cost of Gas (WACOG) FY 2009-10 A-rrl'rcH-~r #3 4/6/201 0 comoaJ Invoice I Gallons I Propane I Propane I Shipping I Total I FYTD I Cost of Tank Tank WACOG Date Sea-3 T L&L Shlnnlna Delivered Rate Cost Cost Cost Gallons InventoN Inventorv Wlthdrawl I I I I I I I I I 09/30/09 $ 41,529.82 42,607 0.97472 10/14/09 Sea-3 14009-0613 I 1 37,009 I 1.07699 I $ 38,955.67 I $ 902.59 I $ 39,858.26 T 37,009.0 T $ 81,388.08 79,616 1.02226 10/31/09 MONTHLY INVENTORY ADJUSTMENT I 571 I 1.20989 I $ 690.85 I $ - 1$ 690.85 T T$ 82,078.93 80,187 1.02359 10/31/09 END OF MONTH $ 48,445.68 47,329 32,858 1.02359 11/06/09 Sea-3 14009-0666 1 I 28,358 I 1.23146 I $ 34,216.76 1 $ 704.85 1 $ 34,921.61 I 65,367.0 I $ 83,367.29 75,687 1.10147 11/30/09 MONTHLY INVENTORY ADJUSTMENT I 498 I 1.37345 I $ 683.98 I $ - 1$ 683.98 I 1$ 84,051.27 76,185 1.10325 11/30/09 END OF MONTH $ 48,047.74 43,551 32,634 1.10325 12/13/09 Sea-3 14009-0747 I I 9,400 I 1.25016 I $ 11,517.821$ 233.65 1 $ 11,751.47 I 74,767.0 1 $ 59,799.21 52,951 1.12933 12/17/09 Sea-3 14009-0765 I I 28,5931 1.25016 I $ 35,035.00 1 $ 710.70 I $ 35,745.70 1 103,360.0 I $ 95,544.91 81,544 1.17170 12/31/09 MONTHLY INVENTORY ADJUSTMENT I 538 0.98243 I $ 528.55 I $ - 1$ 528.55 I 113,262.0 ~: 96,073.46 82,082 1.17046 12/31/09 END OF MONTH 41,191.90 35,193 46,889 1.17046 01/06/10 Sea-3 14010-0005 I 1 9,902/ 1.45356 I $ 14,146.99 I $ 246.12 I $ 14,393.111 55,585.01 45,095 1.23262 01111/1 0 Sea-3 14010-0029 I 1 46'6~4'''' I , 66,681.72 I $ 1,165.86 I $ 67,847.58 I 159,935.0 1 $ 123,432.59 91 ,768 1.34505 01/31/10 MONTHLY INVENTORY ADJUSTMENT I 608 0.26990 I $ 164.10 I $ - 1$ 164.10 I 1$ 123,596.69 92,376 1.33797 01/31/10 END OF MONTH $ 46,257.77 34,573 57,803 1.33797 02/11/10 Sea-3 14010-0102 1 I 38,Q47 1.47796 I $ 55,286.10 1 $ 945.70 I $ 56,231.80 I 197,982.0-r $ 102,489.57 72,620 1.41131 02/17/10 Sea-3 14010-0121 I I 9,9041 1.47796 I $ 14,391.50 I $ 246.17 I $ 14,637.67 I 207,886.01 $ 117,127.24 82,524 1.41931 02/28/10 MONTHLY INVENTORY ADJUSTMENT I 138 3.03717 I $ 419.13 I $ -1$ 419.131 1$ 117,546.37 82,662 1.42201 02/28/10 END OF MONTH $ 57,190.49 40,218 42,444 1.42201 03/12/10 Sea-3 14010-0181 I 1 19,990 I 1.39777 I $ 27,438.27 I $ 503.10 $ 27,941.37 I 227,876.0 1 $ 85,131.86 60,208 1.41396 03/15/10 Sea-3 14010-0199 I I 28,5021 1.39780 I $ 39,121.85 I $ 718.31 I $ 39,840.16 1 256,378.0 I $ 124,972.02 88,710 1.40877 03/31/10 MONTHLY INVENTORY ADJUSTMENT I 329 0.40559 I $ 133.44 I $ - 1$ 133.44 I 1$ 125,105.46 89,039 1 .40506 03/31/10 END OF MONTH $ 55,908.89 39,791 49,248 1.40506 I 1 I I I 1 I 1 1 FYTD Totals I I I 207 886 1.32470 I 270.232 I $ 1.607.44 I 275.3871 I EOM Tank EOM Tank Projected Month Gallons Cost WACOG Mar-10 40,218 $ 57,190.49 1.42 Apr-10 1.11 40,000 49,400.00 $ 106,590.49 . 80,218 40,000 40,218 $ 53,440.08 1.33 May-10 1.10 30,000 36,750.'00'" $'90,190:08 . 70,218 30,000 40,218 $ 51,657.19 1.28 Jun-10 1.18 30,000 39,150.00 $ . 9q,8()7.19 70,218 30,000 40,218 $ 52,010.65 1.29 ,,~ ""_"_'.'__H"W"'___ Jul-10 1.18 30,000 39,150.00 $ 91,160.65 70,218 30,000 40,218 $ 52,213.09 1.30 Aug-10 1.18 20,000 26,100.00 $ 78,313.09 60,218 20,000 40,218 $ 52,303.23 1.30 Sep-10 1.20 20,000 26,500.00 $ 78,803.23 60,218 20,000 . 40,218 $ 52,630.58 1.31 Oct-10 1.20 40,000 53,800.00 $ 106,430.58 80,218 40,000 40,218 $ 53,359.91 1.33 CSW:04/28/2010 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Enerav CharaelTherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIA) Usage & Inflation Adj. (UIA) Total Non-Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelTherm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP/Gallon Rate of with 6.0% Franchise ---.BL SMF ...MM.E... NA (1 - NA (4 + NA (4 + 3 Units) Units) Units) CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR MAY 1, 2010 - SEPTEMBER 30, 2010 BASED ON APPROVED GAS ADJUSTMENT FACTORS LMF NA(4+ Units) $10.00 $25.00 $40.00 $95.00 ($15.00) ($40.00) ($70.00) ($160.00) $0.48 0.09 0.03 0.00 $0.60 0.89 1.49 $0.48 0.09 0.03 0.00 $0.60 $0.60 $0.48 0.09 $0.48 0.89 1.49 0.03 0.00 0.00 $0.60 Firm Natural Gas Rate Schedules SGS MGS LGS ~ (Closed 1/09) 0- 18,000- 100,000 NA (1 - 17,999 99,999 & up 3 Units) $25.00 $40.00 $95.00 ($40.00) ($70.00) ($160.00) $0.46 $0.40 0.09 0.03 0.89 1.41 $25.00 $40.00 $95.00 ($40.00) ($70.00) ($160.00) $10.00 ($15.00) if not prevo billed $0.34 0.09 0.03 0.00 $0.46 0.89 1.35 $0.20 NA $0.20 0.89 1.09 GAC NA(O- 149 tons) $25.00 ($40.00) if not prevo billed NA NA $0.15 NA $0.15 ll",llli 1.04 LAC NA (150 tons & +) $40.00 ($70.00) if not prevo billed $0.10 NA NA NA $0.10 $10.00 $25.00 $40.00 ($15.00) ($40.00) ($70.00) @premise @ premise @premise $ 1.36 $ 1.36 $ 1.36 $ 1.36 $ 1.35 $ 1.29 $ 1.24 $ $ 1.45 $ 1.45 $ 1.45 $ 1.45 $ 1.43 $ 1.37 $ 1.31 $ 1.00 $ 0.95 $ 1.06 $ 1.01 $ ~ SL w/M& Rellaht NA NA $20.00 ($30.00) NA NA ll",llli 0.99 $20.00 ($30.00) + FAC $20.00 ($30.00) $0.20 ~ (Non-Resl) NA By Contract (By Contract) NA $0.35 By Contract NA NA NA NA $0.20 NA NA $0.35 By Contract NA NA 0.89 1.09 1.24 0.89 0.89 $20.00 ($30.00) + FAC 0.91 $ 1.00 $ 1.13 $ 0.96 $ 1.06 $ 1.20 $ Change from 1/2006 Therm Rate $ (0.77) $ (0.77) $ (0.77) $ (0.77) $ (0.66) $ (0.68) $ (0.68) $ (0.79) $ (0.79) $ (0.79) $ (0.79) $ (0.74) $ % Change from 1/2006 Therm Rate -34.1% -34.1% -34.1% -34.1% -31.6% -32.5% -33.5% -42.0% -43.2% -44.4% -42.0% -37.4% Utility Tax Note: Fuel Rate per Therm 10/01/1973 Non-Utility Taxable FuellTherm 0.89 1.49 $10.00 $25.00 $40.00 $95.00 ($15.00) ($40.00) ($70.00) ($160.00) $0.069 $0.069 $0.069 $0.069 $0.821 $0.821 $0.821 $0.821 BTU FACTOR = THERMS/100 CUBIC FEET ICCFI Firm Service Rates Interruptible Service Rates 0.09 0.09 $0.069 $0.821 1.045 1.043 10/2009 11/2009 12/2009 01/2010 02/2010 03/2010 04/2010 1.025 1.022 1.043 1.022 1.045 1.025 0.03 0.03 0.00 0.00 $0.52 $0.58 0.89 0.89 1.47 1.49 $0.069 $0.069 $0.821 $0.821 1.043 1.042 1.023 1.022 $0.069 $0.821 $0.069 $0.821 $0.069 $0.069 $0.821 $0.821 $0.069 $0.821 0.89 + Non-Fuel By Contract (By Contract) + FAC Interr. NG Rate NSS ~ (Non-Resl) NA 100,000 & up $50.00 $250.00 ($75.00) $400.00 $0.46 $0.28 NA NA NA NA NA NA $0.28 $0.46 0.89 0.81 1.35 1.09 $50.00 $250.00 ($75.00) $400.00 + FAC + Non-Fuel Therm Rate for Contract # ofTherms 0.81 $ 1.24 $ 1.00 0.86 $ 1.31 $ 1.06 (0.89) $ (0.80) $ (0.65) -50.0% -37.2% -37.4% $0.069 $0.069 $0.055 $0.821 $0.821 $0.755 1.041 OS/2010 06/2010 07/2010 08/2010 09/2010 FY 09/10 Averaae 1.043 1.021 1.041 1.021 1.023 Attachment #4 Contract NG Rate ~ NA By Contract (By Contract) By Contract NA NA NA By Contract 0.81 0.81 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms $ (0.65) -44.5% $0.069 $0.741 CSW:04/28/2010 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 MAY 1, 2010 - SEPTEMBER 30, 2010 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 (Non-Res!. Only) (Non-Res!. Only) 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 New Res!. Applications) Monthly Customer Charge $10.00 $25.00 $10.00 $25.00 $40.00 $40.00 $50.00 Set By Contract For Each Meter Non-Fuel Enerav Charaes/Gallon: Non-Fuel Energy Charge (NFE)/Gallol $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract $1.00 Set By Contract Energy Conservation Adj.(ECA)/Gallol 0.09 0.09 0.09 0.09 0.09 NA NA NA Regulatory Imposition Adj.(RIA)/Gallor 0.03 0.03 0.03 0.03 0.03 NA NA NA Usage & Inflation Adj. (UIA)/Gallon 0.00 0.00 0.00 0.00 0.00 NA NA NA Total Non-Fuel Charges (NF)/Gal. $2.02 $2.02 $1.02 $0.42 $0.37 Set By Contract $1.00 By Contract + NA Purchased Gas Adjustment(PGA)/Gal 1.73 1.n. 1.73 1.73 1.73 1.73 1.n. 1.73 Total Energy Charges/Gallon $3.75 $3.75 $2.75 $2.15 $2.10 $1.73 $2.73 $1.73 + Contract NFE + Contract NFE Customer Charge Customer Charge + Minimum Monthly Bill $10.00 $25.00 $10.00 $25.00 $40.00 Any Applicable $50.00 Non-Fuel Energy Chg. Customer Charge for the Contracted + Any Applicable # of Gallons/Mo. Facility Charges Utilltv 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 FuelfTherm $1.569 $1.569 $1.569 $1.569 $1.569 $1.569 $1.569 $1.569 Change from 8/2008 Gallon Rate $ (0.39) $ (0.39) $ (0.59) $ (0.59) $ (0.59) $ (0.91) $ (0.20) $ (0.69) % Change from 8/2008 Gallon Rate -9.4% -9.4% -17.7% -21.5% -21.9% -34.5% -6.8% -28.5% CSW:04/28/2010 Attachment #5 Page 2 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR MAY 1, 2010 - SEPTEMBER 30,2010 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" COMMERCIAL BULK LP SERVICE BULK STANDBY/ 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" ~ BRLP2 ~ BRLP4 WRLP1 WRLP2 BCLP1 BCLP2 LPSB CLP (Closed for Applicable Annual Gallon Range 0-60 60.1-120 120.1-300 > 300 0- 120 > 120 o - 2,500 > 2,500 New Residental 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 Applications) Customers Who Range of Usage Range of Usage Requests Bulk Del. Annual Customer Charge $ 210.00 $ 180.00 $ 90.00 $ 75.00 $ 150.00 $ 75.00 $ 90.00 $ 90.00 $ 420.00 Set by contract Non-Fuel Charaes (NFl/Gallon: Non-Fuel Energy Charge (NFE)/Gal. $ 1.800 $ 1.600 $ 1.00 $ 0.90 $ 1.60 $ 0.90 $ 0.25 $ 0.20 $ 1.00 Set By Contract Energy Conservation Adj. (ECA)/Gal 0.090 0.090 0.09 0.09 0.09 0.09 0.09 0.09 NA NA Regulatory Imposition Adj. (RIA)/Gal. 0.030 0.030 0.03 0.03 0.03 0.03 0.03 0.03 NA NA Usage & Inflation Adj. (UIA)/Gallon NA NA Total Non-Fuel Charges (NF)/Gal. $ 1.920 $ 1.720 $ 1.12 $ 1.02 $ 1.72 $ 1.02 $ 0.37 $ 0.32 $ 1.00 Set By Contract Purchased Gas Adj. (PGA)/Gallon 1.730 1.730 $ 1.73 $ 1.73 $ 1.73 $ 1.73 $ 1.73 $ 1.73 $ 1.73 1.73 Total Energy Charges/Gallon $ 3.650 $ 3.450 $ 2.85 $ 2.75 $ 3.45 $ 2.75 $ 2.10 $ 2.05 $ 2.73 1.73 + Contract NFE Note: No Monthly Minimum Bill Utllltv 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.569 $ 1.569 $ 1.569 $ 1.569 $ 1.569 $ 1.569 $ 1.569 $ 1.569 $ 1.569 $ 1.569 Change from 8/2008 Gallon Rate $ (0.390) $ (0.390) $ (0.59) $ (0.59) $ (0.39) $ (0.59) $ (0.64) $ (0.64) $ (0.20) $ (0.69) % Change from 8/2008 Gallon Rate -9.7% -10.2% -17.2% -17.7% -10.2% -17.7% -23.4% -23.8% -6.8% -28.5% ~S=::==1-0-t=--=I~==i==I=~_==i=~~==~=~1-- ..-=J_____-___----mL--~i==- --=t__~_=~--~ j Atta:ahg:e{~~ _____~~~~_i~e_l"ltiaL~~_t_~~l:Iist~ry By Componel"l!~_m__.__~_______m ._______ Clearwater Gas System T- __ -~_r~____ I _ I I ----T _-=r-_-=-_-=-= Total Rate _j I AdiustmentslTherm COI1~ LP Month NGnhenn LP/~lIon' ..... -=~+ ~ ~~=t$O~: :''''":'" ~u~r~:$ 1~: $ -P<w~~: 1_ Oct-oa $ 1.990 $ 3.300 I-----m _m__________ _ ____ _____.___ Nov_Q8 $ 1.990 $ 3.300 ____ .... $ 0.140 $ - $ - $ 1_270 $ 1.190 $ 2.260 ~m__ Dec-08 -$ 1.940 $ 2.770_ ______ ____~n_____ _ _~ O'!~mL.....-=-- $ - $ 1.220 $---1:140$m------1:730- ____ Jan-Q9 $ 1.750 $ 2.290 #_____ ____ nnn _ $ 0.090 $ - $ - $ 1.180 $ 1.100 $ 1.200 Feb-09 $ 1.750 $ 2.290 ______~m___ ______ $ 0.090 $ - $ _:__ $ 1.180 $ 1.100 $ 1.200 _ _____~ar-Q9 $ 1.580 $ 2.270 ___ ____~m~'--___________ J--.2.:.070 $ - $_ .. :____ $ 1.030 $ 0.950 $ 1.200 Apr_Q9 $ 1.410 $ 2.200 $ 0.040 $ - $ - $ 0.890 $ 0.810 $ 1.160 May-09 $ 1.410 $ 2.200 ______Jn~Q4Jl_ $ - $ - $ 0~89(f -$-0.810$---- 1.160 Jun_Q9 $ 1.410 $ 2.200________ __ $ 0.040 $ - $ - _$ 0.890 $ 0.810 _~m____L~ Jul_Q9 $ 1.350 $ 2.330 __ _~J?:Q4.Q $ - $ - $ 0.830 $ 0.750 $ 1.290 AUQ_Q9$ 1.350 $ 2.490 _ . __ ~_ _ ____ $ 0.040 $ - $ - $ 0.830 $ 0.750 $ 1.450 Sep-09 $ 1.390 $ 2.650 $ 0.070 $ 0.010 $ - $ 0.830 $ 0.750 $ 1.570 FY 08/09 Avg. $ 1.610 $ 2.524 I $ 0.078 $ 0.001 $ - $1.026 $ 0.946 S 1.470 2008 Avg. I $ 1.965 $ 3.186 I $ 0.136 $ - $ 0.013 $1.237 $ 1.157 $ 2.138 _mn Oct-OS $ 1.390 $ 2.670 _____m_ _________ $ 0.070 $ 0.010 $ - $ 0.830-$ 0.750 $ -1.590 Nov_Q9 $ 1.390 $ 2.670 $ 0.070 $ 0.010 $ - $ 0.830 $ 0.750 $ 1~ Dec_Q9 $ 1.390 $ 2.750 u_ Hm_ __ _$ 0.070 $ 0.010 $ - $ 0.830 $ 0.750 $ 1.670 Jan-10 $ 1.390 $ 2.750 $ 0.070 $ 0.010 $ - $ 0.830 $ 0.750 $ 1.670 Feb-10 $ 1.480 $ 2.810 ____ $ 0.110 $ 0.010 $ - $ 0.880 $ 0.800 $ 1.6~ ____~ Mar:!Ol__1,520_ $ 2.880 __m__ $ 0.110 ~m_.Jl_.Q:lO f--~m - $ 0.920 $ 0.840 $ 1.760 Apr-10 $ 1.520 $ 2.880 __m__ _____ _____~ $ 0.110 $ 0.010 $ - $ 0.9~O_ LO.84_0__~_ ___1.760 Mav-10 $ 1.490 $ 2.850 _~ $ 0.0~~_Q,Q30 L___ - $ 0.890 $ 0.810 $ 1~~ Jun-10 Jul-10 Aug-10 Sep-10 FY 09/10 AVQ. $ 1.446 $ 2.783 2009 Avg. $ 1.464 $ 2.418 1----- --I----~_.- .--.- $ 0.088 $ 0.013 $ $ 0.061 $ 0.003 $ $ 0.866 I $ 0.786 $ $ 0.920 $ 0.840 $ 1.683 1.353 --.----- .--.---- . -.-.------1-----. Incr. Above Last Year Same Month $ 0.080 $ 0.650 6% 30% 1.60 $ 14.21 6% 30% 5.1 10.6 13.6 13.6 $ 0.050 $ 0.030 $ $ -~--- $ $ -- 0.570 125% NA NA 0% 0% 49% Incr. Based $ on 20 Therms _._. -- -- _____.._____mm _. Equivalent Cents/KWH for Gas . m___ ___ .__ __ ._m. -f-------- __ __________~~_____~~_~!~ential Rate History By Components_________ _____~____ Clearwater Gas System $ ~ $ $ $ Feb-05 $ 1.830 $ 2.1501==--_=~=_ ==.~_:___=__ _ $ 0.130 $ - $ 0.010 $1:1JQ 1_J.<:)10 $ Mar-Q5 $ 1.860 $ -1:J_~O_~_Q:~1.Q_ _~_Q.Q~Q $ 0.020 $ 1.110 $ 1.040 $ Apr-05 $ 1.860 $ 2.280 j_ . . _ __ _ __ . ____.~ 0.130 $ 0.020 $Q.Q20 $ 1.110 $ 1.040 $ May-OS $ 1.790 $ 2.~~~_.____ _ $ 0.130 $ 0.020_ $_ - $ 1.060 $ 0.990 $ Jun-05 $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ Jul-Q5 $ 1.790 $ 2.190-----+- $ 0.130 $ 0.020 -"$----:.- $ 1.060 $ 0.990 $ --Aug-Q5 $ 1.820 $ 2.220 -- ------ $ 0.140 $ 0.020 $ -.~ $ 1.080 $ 1.010 $ Sep-05 $ 1.970 $---2:300 l---- $ 0.140 $ 0.020 $ - $ 1.230 $ 1.160 $ FY 04/05 Avg. $ 1.803 $ 2.162 $ 0.122 $ 0.012 $ 0.004 $1.085 $ 1.015 $ 2004 Avg. $ 1.652 $ 1.968 I 1$ 0.123 $ - $ - $ 0.949 $ 0.879 $ CSW:08I19/2008 Oct-Q5 $ Nov-Q5 $ Dec-Q5 $ Jan-Q6 $ Feb-06 $ Mar-Q6 $ -------ADr.:06 $ May-Q6 $ Jun-Q6 $ Jul-Q6 $ Au.a.-Q6 $ --------sep-06 $ FY 05106 Avg. $ 2005 Avg. $ Oct-Q6 $ Nov-Q6 $ Dec-Q6 $ Jan-Q7 $ Feb-07 $ Mar-Q7 $ Apr-Q7 $ May-Q7 $ _.__-",un-QIJ.- Jul-Q7 $ Aug-Q7 $ Sep-07 $ FY 06/07 Avg. $ 2006 Avg. $ j____-_~=~= I Atta::g:~n~~ 2.190 $ 2.190 $ 2.260 $ 2.260 $ 2.220 $ 2.220 $ 2.110 $ 1.960 $ 1.920 $ 1.910 $ 1.860 $ 1.860 $ 2.080 $ 1.925 $ .- -- u_ ..-.-.... .-.______. ._.._________ --.n---f-c--....-..-- $ _ $ _____.~__ _________ .~_..Q,J~J.-0.020 $ 1.470 $ 0.120 $ 0.020 $ - ___ _$ 1.470 $ $ 0.120 $ 0.020 $ - $ 1.540 $ $ 0.120 $ 0.020 $ - $ 1.540 $ ___...___ .. _ __ _.. .$_().16Q+~_Q,_Q1Q__L_-=-__l1.470 $ $ 0.160 $ 0.010 $ - $ 1.470 $ $ 0.170 $ 0.010 $ ~---- $ 1.350 $ $ 0.170 $ 0.010 $ - $ 1.200 $ $ 0.180 $ 0.010 $ - $ 1.150 $ $ 0.200 $ 0.010 $_~ $ 1.120 $ __________ _________ _$ 0.200 $ 0.010 $ - $ 1.070 $ $ 0.200 $ 0.010 $ - $ 1.070 $ $ 0.160 $ 0.013 $ - $ 1.327 $ $ 0.127 $ 0.017 $ 0.004 $ 1.198 $ 1.390 $ 1.390 $ 1.460 $ 1.460 $ 1.390 $ 1.390 $ 1.270 $ 1.120 $ 1.070 $ 1.040 $ 0.990 $ 0.990 $ 1.247 $ 1.125 $ 2.530 2.530 2.490 2.490 2.460 ~- " -------- 2.460 2.320 2.360 . -- -- 2.420 2.500 2.600 I----~ 2.600 2.480 2.278 ------ -- 1.940 $ 2.600 1.940 $ 2.600 f-----:= .---- 1.940 $ 2.600 1.940 $ 2.600 1.940 $ 2.600 1.940 $ 2.600 1.940 $ 2.600 ------ - 1.~~_ 2.742. 1.920 $ 2.990 1.840 $ 2.990 1.840 $ 2.990 1.890 $ 2.990 1.918 $ 2.742 2.012 $ 2.501 LQ.~Q.. __LO.Ol.O+~ .- $ 0.180 $ 0.010 $ - $ 0.180 $ 0.010 $ - $ 0.180 $ 0.010 $ - -fO.180 $ 0.010 $ - $ 0.180 $ 0.010 $ - $ 0.180 $ - $ 0.030 $ 0.180 $ - ~0.030 $ 0.180 $ - $ 0.030 $ 0.180 $ - $- _1.Q,1?.<!.. ~ - $- $ 0.180 $ - $- $ 0.180 $ 0.005 $ 0.008 $ 0.175 $ 0.011 $ - $ 1.170 $ 1.090 $ $ 1.170 $ 1.090 $ $ 1.170 $ 1.090 $ $ 1.170 $ 1.090 $ $ 1.170 -!-1.090 $ $ 1.170 $ 1.090 $ $ 1.150 $ 1.070 $ $ 1.150$-1.070 $ $ 1.130 $ 1.050 $ $ 1.080 $ 1.000 $ $ 1.080 $ 1.000 $ $ 1.130 $ 1.050 $ $1.145 $ 1.065 $ $ 1.246 $ 1.166 $ ..- --..-- -- ---- Oct-Q7 $ 1.840 $ 2.990 f------- $ 0.180 $ - $ - $ 1.080 Nov-Q7 $ 1.840 ~~..:!!Q _________ ._t..Q:~Q. ..$_____ __ $ - $ 1.080 Dec-Q7 $ 1.840 $ 3.170 $ 0.180 $ - $ - $ 1.080 --- Jan-OS $ 1.840 $ 3. {7cf r - ---- __~ f-.-~ 0.18Q $ - $ - $ 1.080 ~:~~~}--+:i~t-ttiOf__ _-=-:~----- n__ i ~:~~~ i : : 0.~30 i ~:~~~ Apr-Q8 $ 1.810 $ 3.1.2.0_ ______ _____1--_____ ~50 $ - $ 0.030 $ 1.050 Mav-Q8 $ 1.880 $ 3.120 $ 0.090 $ - $ 0.030 $ 1.180 J~~~~ i ~:;;~ i ;:~~~ ..... n.t .u__--- i ~:~~~ r-~- i ~:~;~ i ~:;~ Aua-08 $ 2.120 $ 3.440.. --~------ ---- $ 0.120 $ - -- $ - $ 1.420 Sep-08 $ 2.120 $ 3.340lu - _u___ $ 0.120 $ _ -$_-- $ 1.420 FY 07/08 Ava. $ 1.932 $ 3.183 I I $ 0.146 I $ - $ 0.013 $1.193 2007 Avg. $ 1.893 $ 2.869 I $ 0.180 $ 0.003 $ 0.008 $ 1.123 --.- . I I . L _______ I I ---'------___.____ f-- ____ Note: Customer Charae increased bv $21month for both NG & LP on 4/1/2005 $ 1.000 $ $ 1.000 $ $ 1.000 $ $_1.000 $ $ 1.000 $ $ 0.970 $ $ 0.970 $ $ 1.100 $ $ 1.230 $ $ 1.410 $ $ 1.340 $ l 1.340 $ $ 1.113 $ $ 1.043 $ .-..-----...-...... -- LP PGAlaallon 1.130 1._~ 1.1~Q. 1.190 1.210 1.210 1.210 1.140 1.11Q. 1:~ 1.160 1.240 1.174 1.046 1.490 1.490 1.450 1.450 1.390 1.390 1.21Q. 1.280 1.330 1.390 1.490 1.490 1.407 1.256 1.510 1.:~ 1.510 1.510 1.510 1.510 1.490 1.630 1.880 .- 1.910 1.910 1.910 1.649 1.415 1.910 2.090 2.090 2.090 2.090 2.040 2.040 2.100 2.150 2.150 2.420 2.320 2.124 1.779 CSW:9/29/2009 Competitive History of NG vs. Electric Rates NG Equivalent Progress Energy NGvs. Month-Year NG Thenn Cost KWH Cost KWH Cost Electric September 2001 $ 1.34 $ 0.046 $ 0.084 -46% September 2002 $ 1.36 $ 0.046 $ 0.074 -37% September 2003 $ 1.56 $ 0.053 $ 0.084 -37% September 2004 $ 1.69 $ 0.058 $ 0.089 -35% September 2005 $ 1.97 $ 0.067 $ 0.097 -31% September 2006 $ 1.89 $ 0.065 $ 0.119 -46% September 2007 $ 1.86 $ 0.063 $ 0.120 -47% September 2008 $ 2.12 $ 0.072 $ 0.120 -40% September 2009 $ 1.39 $ 0.047 $ 0.132 -64% $ Increase over Last 8 Years $ 0.05 $ 0.00 $ 0.05 % Increase over Last 8 Years 3.7% 3.7% 57% Avg. Annual Inc. 0.5% 0.5% 7.1% Over Last 8 Yrs.