Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE DECEMBER 2008
CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet TO: William B. Horne II, City Manager FROM: Chuck Warrington, Managing Director COPIES: Rod Irwin, Assistant City Manager; eyndie 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 DECEMBER 2008 DATE: November 18, 2008 The Gas markets still remain high historically, but have moderating significantly recently. Therefore, we are recommending that we decrease our Natural Gas Purchased Gas Adjustments (PGA) by 50/therm and decrease our LP PGA by 530/gallon. 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 a 50/therm decrease (-2.5%) in our typical Residential Natural Gas customer's rate and a 530/gallon (-16.1%) 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 December 1, 2008: Natural Gas Firm Standard Rate Schedule PGA ....... $1.22 per therm (down 50/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $1.14 per therm (down 50/therm) Propane (LP) Gas Rate Schedule PGA .................... $1.73 per gallon (down 530/gallon) Energy Conservation Adjustment (ECA) ............... $0.14 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) r William B. Horne II, -City Manager November 18, 2008 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru September and projections thru Period 13 of last fiscal year. These show that we are projecting being within $200,000 (0.8% of annual adjustment clause expenses) FYE, which is important to our overall financials. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachment #4 shows our projections for PGA requirements. Attachments #5 and #6 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #7 shows our rate history over the past 4+ years and shows our relationship to current electric prices. I should point out that the overall effect is that our typical Residential customer rates are now 45% lower than electric for Natural Gas and LP is now 14% lower than electric. It should be pointed out that Progress Energy Florida has announced that they have obtained FPSC approval for a 25% increase in rates to be implemented January 1" due principally to a huge increase in their Fuel Adjustment charges. So our competitive position vs. electric should continue to amplify. Additionally, TECO Peoples Gas has recently filed for a $25+ million increase in their natural gas rates. Of real interest is that Progress Energy Florida has said that a significant part of their need to increase rates is fuel supply cost and they have pointed to natural gas as a culprit. .Interestingly, our recommended PGA rate is only 13% higher than last Fall vs. the 25% that they are proposing. We will be implementing our new rates in January; therefore, we will be carefully assessing our status and making projections for the remainder of the year mid month in December for billing adjustment factors through September 30, 2009. 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 December 1 st billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: illiam B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for December 2008.doc CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 Page 1 of 3 NATURAL G AS PURCHASE D GAS ADJUSTMENT PGA-NG I i I Month/ Cumulative NG PGA Budget Reservation 1 Commodi Interest Cost Center 1 1 Total NG Fuel I Total NG PGA ! Overage 1 YTD Overage Rate/Therm Month ! Charges Charges Expense Expenses 1 I Expenses Billed (Shortage) (Shortage) Firm/Contr Prior Year: ! $ 45,593.9 Oct-07 $ 2,995,907.81 $ 986,429.07 $ - 1 $ 31,242.98 1 $ 4,013,579.86 $ 2,306,584.81.1 $ (1,706,995.05)1 $ (1,661,401.12 1.08/1.00 Nov-07 1 $ 162,347.55 $ 1,119,202.77 $ 8,307.01 1 $ . 41,104.95 1 $ 1,330,962.28 $ 1,542,587.20 $ 211,624.92 ! $ (1,449,776.20) 1.08/1.00 Dec-07 , $ 150,733.55 $ 1,402,134.03 $ 7,248.88 $ 56,275.23 ; $ 1,616,391.69 $ 1,986,985.55 $ 370,593.86 $ (1,079,182.34)1 1.08/1.00 Jan-08 $ 134,272 $ _ 1,705,922.47 $ 5,395.91 $ 40,794.65.E I $ 1,886,385.20 $ 1,931,339.18 $ 44,953.98 $ 1,034,228.36)1 1.08/1.00 Feb-08 ' $ 154,923.90 $ 1,620,686.97 $ 5,171.14 $ 39,591.14 i $ 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,366.40 $ 3,749.74 $ 40,457.54 $ 1,798,614.80 $ 1,910,479.00 $ 111,864.20 $ (638,083.66) 1.05/0.97 A r-08 $ 108,354.47 $ 1,821,873.61 $ 3,190.42 $ 35,342.68 $ 1,968,761.18 $ 1,944,387.46 $ (24,373.72): $ 662,457.38) 1.05/0.97 May-08 ! $ 82.238.60 $ 1,747,270.88 $ 3,312.29 1 $ 46,777.80 1 $ 1,879,599.57 $ 1,853,054.05 1 $ (26,545.52 $ 689,002.89) 1.18/1.10 Jun-08 $ 79,645.24 $ 1,603,199.36 $ 3,445.01 $ 73,092.95 i $ 1,759,382.56 $ 1,813,218.20 $ 53,835.64 $ 635,167.26) 1.31/1.23 Jul-08 $ 79,618.90 $ 1,628,991.95 $ 3,175.84 1 $ 39,096.14 ` $ 1,750,882.83 $ 1,849,718.30 $ 98,835.47 $ (536,331.79 1.49/1.41 Aug-08 $ 69,598.03 $ 1,478,155.66 $ 2,681.66 ` $ 67,016.19 I $ 1,617,451.54 $ 1,785,383.26 $ 167,931.72 $ (368,400.06 1.42/1.34 ; Sep-0 8 . $ 39,509.15 $ 1,205,329.98 $ 1,842.00 $ 67,007.00 $ 1,313,688.13 ; $ 1,703,354.44 ; $ 389,666.31 $ 21,266.25 1.42/1.34 Per 13 ' $ 145,718.55 $ - $ - $ - 5 $ 145,718.55 $ - 1 $ 145,718.55 $ (124,452.31 Total YTD' $ 4,368,909.04 $ 17,907,563.15 $ 47,519.89 $ 577,799.25 1 $ 22,901,791.34 $ 22,731,745.10 ' $ 170,046.24)i (1) Includes annual charge for Admin of $648,160 + Annual CCS chg of $959,620 + Dividend $1,276,400 + FY 06/07 PGA write off of $28,277.51 + WNA $135.64 = $ 2,912,593.15 Note: Billed includes Deferred Revs re-coup of $982,285.39 2 1 (5) Commodity adjustment from FYE transfer of ECA Collected in PGA @ 1 /2 of the ECA Rate Net RC = $ 1,310,597.34 I NG Proportion = 97.78% x Total ECA Transfer $ 155,831.80 1 + Transfer of WNA to PGA = • $ 10,113.25 'ROPANE LP GAS PURCHASED GAS ADJUSTMENT PGA-LP j 1 Monthly Cumulative LP PGA Budget Gallons Monthly I Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Ex ep nse Charges ! Expenses Billed 1 (Shortage) (Shortage) Prior Yearl 1 $ 37,784.74)1 Oct-07 1 36,522.8 1 $ 1.38433 $ 188.92 $ 50,559.61 1 1 $ 224,120.26 1 $ 69,856.53 ! $ _ (154 263.73) $ (192 048.47) 1.75/1.91 Nov-07 33,056.8 , $ 1.53309 $ 960.24 $ 50,679.05 ! $ 51,639.29 ! $ 68,188.12 $ 16,548.83 1 $ 175,499.64 1.91%2.09 Dec-07 38,487.0 $ _ 1.60329 $ 877.50. $ 61,705.82 ! $ 62,583.32: $ 80,633.03 $ 18,049.71 $ (157,449.93)1 1.91/2.09 Jan-08 58,278.4 $ 1.65887 $ 787.25 $ 96,676.29 $ 97,463.54 $ 122,012.14 ! $ 24,548.60 $ 132,901.33)1 1.91/2.09 Feb-08 ! 53,023.9 $ 1.64212 $ 664.51 $ 87,071.61 $ 87,736.11 $ 110,891.59 $ 23,155.48 $ 109,745.86)''; 1.91/2.09 Mar-08 44,360.6 $ 1.64377 $ 548.73 , $ 72,918.62 $ 73,467.35 $ 91,039.92 ! $ 17,572.57 ! $ (92,173.29 1.87/2,04 > A r-08 56,003.9 $ 1.62757 $ 460.87 $ 91,150.27 $ 91,611.13 $ 114,285.55 $ 22,674.42 $ (69,498.87)! 1.87/2.04 May-08 1 39,023.6 $ 1.71081 $ 347.49 ! $ 66,761.97 $ 67,109.46 ! $ 81,365.43 $ 14,255.97 ! $ (55,242.90) 1.92/2:10 Jun-08 28,774.2 $ 1.77663 $ 276.21 ! $ 51,121.11 1 1 $ 51,397.32 $ 61,604.37 $ 10,207.05 $ (45,035.85) 1.97/2.15 Jul-08 ! 29,347.8 $ 1.87869 $ 225.18 $ 55,135.42 ' I $ 55,360.60 $ 63,157.13 1 $ 7,796.53: $ (37,239.32), 1.97/2.15 Aug-08 25,121.0 $ 1.87639 $ 186.20 1 $ 47,136.79 1 1 $ 47,322.99 $ 59,681.04 1 $ 12,358.05 $ (24,881.27) 2.21/2.42 Sep-0 8 35,219.2 $ 1.85404 $ 124.41 I $ 65,297.81 ! $ 65,422.21 $ 82,100.78 $ 16,678.57 1 $ (8,202.70) 2.12/2.32 Per 13 ! 4 $ 3,538.01 $ - $ 3,538.01 ! $ 11,740.71): Total YTD 477,219.2 $ 1.66845 $ 5,647:51 $ 796,214.36 $ 978,771.60 $ 1,004,815.63 $ 26,044.03 Cost Center Expenses CCS Chg + Admin Chg + Dividend $ 88,530.00 1 (2 1 FY 06/07 Write off PGA & WNA 1,136.69 1 j ! Fuel 15,000.00 1 1 PC Anywhere ($159)&Holding Tank Restoration ($ 13,209.60) 1 13,368.60 1 1 j 1 LP Yard Vaporization & loss due to meter malfunction 9,336.27 1 1 ! (4) Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate LP PGA Event fuel cost 5,978.74 1 LP Proportion = 2.22% x Total ECA Trans fer = $ 3,538.01 Depreciation of LP Tanks 34,414.23 1 1 + Suburban Software Systems 1,250.00 1 i Suburban Software Systems License 569.70 I 1 ! Total Cost Cntr Exp Proj. Adders Allow for Welle Fargo Insurance invoice #637545 3,787.50 j 1 $ _ 173,371.73 1 $ 175,000.00 $ 1,628.27 CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 Page 2 of 3 N-RGY CONSERVATION ADJUSTMENT (ECA ^ Monthly Cumulative ECA Budget Cost Center ! Interest ! Total ECA Total ECA Overage j YTD Overage NG/Therm ! !Month I Expenses Notes/Exceptional Items Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ j Oct-07 $ 318,454.23 ,Promo$36,720,Adv$0,Employ Costs$57,160 $ - 1 $ 318,454.23 $ 111,884.77 $ (206,569.46y! $ 206,569.46) 0.18/0.18 Nov-07 $ 95,913.73 Promo$26,790,Adv$1,730, EmployCosts$67,394 $ 1,032.85 $ 96,946.58 $ 122,642.60 ! $ 25,696.02 ! $ (180,873.44 0.18/0.18 Dec-07 ! $ 76,495.95 ! Promo$23,405,Adv $1,025, Employ Costs$22,066 $ 904.37 $ 77,400.32 1 $ 156,000.42 ! $ 78,600.10 $ (102,273.33 0.18/0.18 Jan-08 $ 79,959.70 Promo$24,930,Adv $230, Employ Costs$54,800 $ _ 511.37 $ 80,471.07 $ 188,214.03 ! $ 107,742.96 $ 5,469.63 0.18/0.18 Feb-08 ! $ 43,9^2.35 Promo$75,046,Adv $180, Employ Costs$68,766 $ - $ 143,992.35 $ 184,801.051! $ 40,808.70 $ 46,278.33. 0.18/0.18 85,799.60',Promo$27,988,Adv$1,590,Employ Costs$56,222 1 Mar-08 ,$ $ $ 85,799.60 $ 141,996.29 $ 56,196.69 $ 102,475.02 0.1510.15 _ Apr-08 $ 87,873.23 Promo$39,190,Adv$3,310, EmployCosts$45,373 $ $ 87,873.23 $ 135,572.31 $ 47,699.08 $ 150,174.10 0.15/0.15 May-08 1 $ 359,240.59 I Promo$20,447,Adv $1,953, Employ Costs$55,692 $ - ! 2 $ 359,240.59 $ 70,010.94 $ (289,229.65 $ 139,055.55) 0.0910.09 Jun-08 $ 70,347.34 IPromo$38,463,Adv$2,270,Employ Costs$29,614 $ 695.28', $ 71,042.62 $ _ 45,674.19 $ (25,368.43)! $ (164,423.98) 0.07/0.07 81,239.18 Promo$33,906,Adv$1,375, EmpCosts$45,958.18 I Jul-08 1 $ $ 822.12 $ 82,061.30 $ 90,04034 $ 7,979.04 ! $ (156,444.94) 0.1510.15 _ f Aug-08 $ 71,013.38 !Promo$25,345,Adv$3,595, EmployCosts$42,073 $ 782.22 $ 71,795.60 $ 70,495.11 I, $ (1,300.49)1 $ 157,745.43) 0.1210.12 i Sep-08 $ 72,921.01 Promo$23,553,Adv$O,Employ Costs$49,368 $ 788.73 $ 73,709.74 $ 72,085.36 $ (1,624.38)1 $ (159,369.81) 1 0.1210.12 I Per 13 6 1 $ - $ 159,369.81 ! $ 159,369.81 1 $ iTotal YTDi $ 1,543,250.29 $ 5,536.93 ! $ 1,548,787.22 $ 1,548,787.22 $ - (1): Includes annual charge for Admin Ch of $38,760 + CCS chg of $69,670 (6) = Transfer of ECA Collected in PGA @ 1/2 of the ECA Rate (up 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 = $ 694,708.71 (2);FY 07/08 SO Write Off adjustment = $ 281,148.85 ! 3 ! I Net CCE= $ 1,037,526.78 T ENVIRONMENTAL IMPOSIT ION ADJUSTMENT (EIA) _ Monthly Cumulative EIA _Budget Cost Center 1 I Interest Total EIA Total EIA Overage YTD Overage NG/Therm Month ! Expenses Notes/Exceptional Items i Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year ' $ 113,277.52 Oct-07 $ 14,182.79 $ - 1! $ 14,182.79 ! $ 0.21 $ (14,183.00)! $ 99,094.52 0.00/0.00 Nov-07 $ 1,427.00 1 $ 2 $ 1,427.00 $ 95,999.86 $ 94,572.86 1 $ 193,667.38 0.00/0.00 Dec-07 $ 2,909.70 $ i $ 2,909.70 $ (0.03) $ (2,909.73) i $ 190,757.65 0.00/0.00 Jan-08 $ 4,529.35 $ - $ 4,529.35 $ 0.76 ! $ (4,530.11)1 $ 186,227.54 0.00/0.00 Feb-08 $ 1,427.00 ! $ $ 1,427.00 $ (0.39); $ 1,427.39)•:, $ 184,800.15 j 0.0010.00 Mar-OS $ 2,799.00 $ - $ 2,799.00 $ 2.48), $ (2,801.48); $ 181,998.67 0.00/0.00 Apr-08 1 $ 1,427.00 1 $ - $ 1,427.00 $ 0.03 $ (1,426.97)1 $ 180,571.70 0.0010.00 May-08 $ 8,742.93 1 ! $ - $ 81742.93 $ - $ (8,742.93)1 $ 171,828.77 ` 0.00/0.00 Jun-08 $ 6,299.19 $ $ 6,299.19 $ - $ (6,299.19 , $ 165,529.58 1 0.00/0.00 Jul-08 ! $ 23,060.45 $ ! $ 23,060.45 $ (0.47) $ 23,060.92) $ 142,468.66 ! 0.0010.00 Au 08 $ 4,282.92 $ - ! $ 4,282.92 $ - $ (4,282.92)! $ 138,185.74 0.0010.00 Sep-08 $ 11,463.89 $ $ 11,463.89 $ (0.33) $ (11,464.22 $ 126,721.52 ; 0.00/0.00 Per 13 ! $ $ $ $ $ - $ 126,721.52 Total YTD' $ 82,551.22 $ ! 1 $ 82,551.22 $ 95,995.22 $ 13,444.00 ! ! ! (1)Ilncludes annual charges for Admin Charge $10,300 + FY 06107 write off of $184.79 = $ 10,484.79 i 1 (2)! Bill-ad includes $96,000 of MGP Insurance Claim Recovery -- Net CCE= ! $ 72,066.43 ! CLEikRlf ATER, GAS SYSTEM Attachment #1 SUMMARY OF RATE CLAUSE COLLECTIONS FOR FY 07/08 Page 3 of 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cumulative Total Budget Total All Total Recove -age YTD Overage NGrTherm-Firrn Month Expenses Billed (Shortage (Shortage) LP/Gallon Prior Year 1 $ _ 1 $ 121,086.71 Oct-07 $ 4,570,337.14 $ 2,488,325.90 ! $ 2,082,011.24)$ (1,960,924.53)' 1.26/2.09 Nov-07 ! 1,480,975.14 1,829,417.78 $ 348,442.64 $ (1,612,481.90) 1;26/2:27 Dec-07 --- ---- 1,759,285.03 I - 2,223,618.97 $ 464,333.94 $ (1,148,147.95)' 1.26/2.27 Jan-08 I 2,068,849.16 - 2,241,564.59 j $ 172,715.43 r$ (975,432.52)1 1.26/2.27 Feb-08 2,053,528.62 2,400,345.90 $ 346,817.28 1 $ (628,615.24)': 1.26/2.27 Mar-O8 _ 1,960,680.75 2,143,512.73 ! $ 182,831.98 $ (445,783.26) 1.20/2.19 Apr- 8 2,149,672.54 •. 2,194,245.35 $ 44,572.81 $ (401,210.45) 1.2012.19 May-08 2,314,692.55 2,004,430.42 $ (310,262.13)! $ (711,472.58) 1.27/2.19 ` Jun-08 1,888,121.69 1,920,496.76 $ 32,375.07 $ (679,097.51) 13812.22 Jul-O8 j 1,911,365.17 j 2,002,915.30 $ 91,550.13 $ (587,547.39) 1.6412.30 Aug-O8 _ 1,740,853.05 1,915,559.41 $ 174,706.36 $ (412,841.03) 1,54!2,54 Sep-08 1,464,283.97 i 1,857,540.25 $ 393,256.28 ! $ (19,584.7 1.5412.44 Per 13 1 149,256.56 l 159,369.81 $ 10,113.25 $ 9,471.50)1 Total YTD I $ 25,511,901.38 $ 25,381,343.17 1 $ 130,558.21)1 1 I Total of All Additional Expenses Recovered Thru Adjustment Clauses = $ 3,602,173.18 WEATHER NORMALIZATION (WNA Monthly Cumulative WNA Budget Interest Overage YTD Overage NG/Therm _ Month LP Gallons i Expense (Rate/Gallon 1 NG Therms I Rate/Therm (Shortage) ?_ Shortage) LP/Gallon Beg. Bal. 1 -- - Oct-07 - -'- -- - -- -- - 36,522.8 - 1 $ - j 1,396,440.2 ---- --- $ $ -- - -_ _'' $ 9.80 $ (257,374.00)1, 257,383.80 - 0.0010.00 _ Nov-07 33,056.8 $ - 1,612,140.2 j ; $ (0.16)i $ (257,383.96) 0.00/0.00 Dec-07 38,487.0 $ - 1,920,988.7 ! $ (2.21) $ (257,386.17 0.00/0.00 Jan-O8 58,278.4 $ - 2,051,577.7 i - $ (1.28); $ (257,387.45)1 0.0010.00 Feb-08 53,023.9 - $ 148 022.9 2,148,022.9 $ (0.79 $ I 257 388.24). 0.00/0.00 Mar-O8 44,360.6 $ 0.03 1,972,879.1 0.03 1 $ 59,755.25 $ (197,632.99) 0.03/0.03 Apr-08 ! 56,003.9 $ - 0.03 !- 2,007,186.6 0.03 1 $ 61,946.79 $ (135,686.20)] 0.03/0.03 May-08 39,023.6 $ - 0.03 1,749,356.1 0.03 $ 53,666.69 $ (82,019.51) 0.03/0.03 Jun-08 28,774.2 $ - 0.03 1,562,509.3 0.03 $ 47,757.94 $ (34,261.57)1 0.03/0.03 Jul-08 29,347.8 $ - 0.03 1 1,437,905.8 1 0.03 ! $ 44,004.52 $ 9,742.95 0.03/0.03 Aug-08 Se -08 25,121.0 35,219.2 $ - $ - - 1,432,784.8 1,397,336.7 $ $ 370.63 $ 0.33 $ 10,113.58 10,113.25 ! 0.00/0.00 0.00/0.00 Per 13 1 1 $ 10,113.25 $ - Total YTD 477,219.2 - 20,689,128.1 $ 257,374.00 ' I I 1 ',Transfer of WNA FYE balance to NG PGA Last U dated:10/15/2008 CGS Natural Gas Cost Actual/Projections FY08 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Total as of 11/412008 Contract Capacity Contract Excess Capacity Relinquishment Purchased Sold Gas Sold Gas Purchased % Sold Gas WACOG FTS-1 FTS-2 No-Notice Capacity Volume Cost Gas Actual Pro ected Gas lost vs. Pro acted Purchased 170,438 41,788 15,500 56,435 33,179 $ 18 700.17 155,791 139,644 172,000 -3.48% 81.2% $ 7.19 306 570 53 430 22,500 167,639 25,305 $ 4,168.01 192,361 161,214 220,000 -5.32% 73.31A $ 8.11 , 316,789 , 55,211 31,000 188,003 102,009 $ 21716.15 183,997 202,689 257,000 5.80% 78.8% $ 7.62 316,789 65,211 46,500 142,806 (88,873) $ 38 944.83 229,194 194,668 237,000 6.28% 82.1% $ 7.92 296,351 $1,649 43,600 146,419 (48,587) $ 7117.76 201,581 214,802 225,000 2.13% 95.5% $ 8.48 316,789 . 55,211 31,000 162,132 44,593 $ 6,408.58 209,868 197,288 201,000 4.36% 98.2% $ 9.32 216,570 53,430 22,500 92,170 (51,717) $ 21 666.09 177,830 200,719 179,000 1.63% 112.1% $ 10.62 144,212 41 788 12,400 28,290 (19,241) $ (8,988.14 157,710 174,936 170,000 0.93% 102.9% $ 10.04 139,560 40 440 10,500 43,349 (26,914 ) $ 8,564.45 136,651 156,251 155,000 -5.23% 100.8% $ 11.75 144,212 41 788 10,850 39,532 44,835 $ 11,531.12 146,468 143,791 154,000 2.18% 93.4% $ 11.83 ,144,212 41 788 10,850 46,463 38,959 $ 21,551.99 139,537 143,278 155,000 -0.14% 92.4% $ 9.51 139,560 40,440 10,500 42,739 44,017 $ 701 1 137,261 139,734 155,000 90.2% $ 8.32 2,652,052 572,174 267,600 1,155,977 (568,029) ($218,132.08) 2,068,249 2,068,914 2,280,000 0.09% 91.8% $9.11 Reservation charges 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 Management fee Factor Factor Billing (phase II (phase 111 NNTS (phase Commodity charges Adjustments Fuel Retention Per Month w/ Relin ulsh w/o Rell uish FGU+Peo les Oct-07 $ 69 112.61 $ 32,134.97 $ 767.25 3,255.76 $ 878.20 $ 1,037,546.37 $ 3,091.69 $ 29 673.49 $ 7,047.00 87.0% 73.41/6 $ 1,120 861.03 Nov-07 $ 124 314.14 $ 41 087.67 $ 11113. 75 $ 3,893.76 $ 112.20 $ 1,396,927.87 $ 1,947.52 $ 39 681.45 $ 8,114.00 57.5% 53.4% $ 1,559,275.42 Dec-07 $ 128 457.94 $ 42 457.26 1 634.60 $ 4,169.25 $ 90.09 $ 1,250,852.20 $ 2,991.49 $ 36 562.44 $ 10,250.00 68.1% 49.5% $ 1 1,4011,585.75 Jan-08 $ 128 457.94 $ 42 457.26 $ 2,301.75 $ 5,429.79 $ 87.82 $ 1,681.319.59 $ 5,132.96 $ 53 026.55 $ 10,677.00 81.0% 61.6% $ 1,815,591.71 Feb-08 $ 120 170.33 $ 39,718.08 S 2153.25 $ 4,572.90 $ 88.67 $ 1,5S4,944.19 $ 3,213.19 $ 44,246.46 $ 9,396.00 67.3% 57.9% $ 1,709,868.09 Mar-08 $ 128 457.94 $ 42,457.26 $ 1,534.50 $ 4,680.09 $ 94.79 $ 1,790,064.16 $ 874.29 $ 51;118.03 $ 9,609.00 64.11% 56.4% $ 1,956,105.28 Apr-08 $ 87 819.14 $ 41 087.67 $ 1 1,1113.75 $ 2 ,0111.31 $ 594.26 $ 1 780 378.08 s 3,284.96 $ 55,252.14 $ 8,328.00 81.5% 65.9% $ 1,688,732.53 May-08 $ 58 477.97 $ 32,134.97 $ 613.80 $ 2,156.65 $ 294.43 $ 1,501,185.27 $ 4,507.10 $ 64 557.18 $ 7,260.00 94.6% 84.8% $ 1,583,423.87 Jun-08 $ 56,691 $ 31,098.36 $ 519.75 $ 1,947.67 $ 285.70 $ 1,526,647.56 $ 3,092.36 $ 56,000.97 $ 6,534.00 89.3% 75.9% $ 1,606,292.80 Jul-08 $ 58,477.97 $ 32134.97 $ 637.08 $ 11883.51 $ 272.60 $ 1,652,601.48 $ 17740.57 $ 63,779.14 $ 6,321.00 103.6% 78.7% $ 1,732,220.38 Au08 $ 58,477.97 $ 32134.97 $ 537.08 $ 1,931.50 $ 240.67 $ 1,257,414.00 $ 89,309.27 $ 39,820.99 $ 6,321.00 94.9% 75.0% $ 1,327,012.03 SOP-08 $ 56,591.58 $ 31098.36 $ 594.00 $ 1,545.24 $ 450.13 $ 1,102,662.22 $ 3,335.55 $ 40,208.94 $ 6,406.00 100.9% 76.3% $ 1,142,171.37 Total $1,075,407.11 $440,001.80 $13,320.46 $37,477.43 ($786.02) $17,532,542.97 $ 123,080.37 $563,927.77 $96,263.00 82.5% Total Projected DTH WACOG Total Reservation Total Commodity Cost Purchased 1st 6 Months $851,632.90 $ 8,711,654.38 $9,563,287.28 1,172,792 $8.154 2nd 6 Months $458,964.39 $ 8,820,888.59 - $9,279,852.98 895,456 - - - $10.363 TOTAL $1,310,597.29 $ 17,532,642.97 $18,843,140.26 2,068,249 $9.11 67.4% $18,843,140.26 Propane Weighted Average Cost of Gas (WACOG)11/17/2008 FY 2008-09 Invoice Gallons Propane Date Com an Sea-3 L&L Shipping Delivered Rate Propane Shipping Total FYTD Cost Cost Cost Gallons Cost of Invento Tank Tank WACOG Invento Withdraw/ I Year End 09130108 ` Totals - ,016.24 67 1.85404 36,146 10/15/08 ' - . - - -= _ - f -_ 359 1 1.64122 $ 9 675 30 3 33 65 81 008.95 49,359.0 Sea-3 4008-0751 4Q $ 148,025.19 85,505 1.73119 10131/08 _, MONTHLY INVENTORY ADJUSTMENT 467 3.01777 $ 1409.30 S 1,409.30 $ 149,434.49: 85,9721 1.73818 10/31108 END OF MONTH - I - L l $ 86,766.86 49,912 36,060 1.73818 --.__ ? -- -- - -- I FYTD Totals Delivered Delivered NYMEX CGS Cost Galions Projections ..............._--.1-1-1- ..._.._ . Delivered Cost of I Total Tank EOM Tank EOM Tank Projected 3allons Withdrawl Gallons Cost WACOG OCt-O$ ? ., .. 49,912 4 _x._. _86,755.85... 1 7 Nov-08 0.94: 1.08 29,053 $ 31,231.98 $ 117,987.83 78,965 40,000 38,965 $ 58,220.67 1.49 Dec-08 0 .75 0.89 50,000 $ 44,250 00 $ 102,470.67 881965 50,000 , 38,965 $ 44,880.23 Jan 09 0 .90 1.04 60,000 $ - 62,100 00 $ 106,980 23 98,965 60 00 00 38,965 $ 42,120.80 1.08 I . Feb-09 0 .95 1.09 50,000 $ 54,250.00 $ 96,370.80 88,965 50,000 „ 38,965 $ 42,208.60 1.08 _ Mar-09 0.90 1.04 50,000 $ 51,750.00 $ 93,958.60 88,965 50,000 38,965 $ 41,152.10 1.08 Apr-09 0.85 0.98 40,000 $ 39 000.00 $ 80,152.10 78,965 40.000 38_,965 $ 39,550.77 1.02 May 09 0.80 0.93 40,000 $ 37,000.00 $ 76,550 77 78,965 40,000 38,965 $ 37,773.71 0.97 Jun-09 0 80 0.93 30,000 $ 27,750.00 $ 65,523771 68,965 30.000 38,965 $ 37,020.68 0.95 Jul-09 0.80: 0.93 30,000 $ 27,750.00 $ 64,770.68 68,965 30.000 38,965 ........ $ 36,595.22 0.94 Aug-09 0.80 0.93 20,000 $ 18,500 00 $ 55,095 22 58,965 20,000 38,965 $ 36,407.79 0 93 _ ........... ... ..... Sep-09 0.80 0.93 30,000 $ 27,750 00 $ 64,157.79 68,965 30,000 38,965: $ 36,248.94 0.93 CSw:i 1/18120oe PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 12/0112008 - 09/3012009 1. Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible & Contract (Non-Standard) Rate Schedule PGA (See attached Page 2) _ $0.080 11. Calculation of the Required Natural Gas PGA WACOG for FY 08/09 A. Therm Sales Projection for 10/1/08 - 9/30/09 = 22,000,000 B. Projected NG Reservation Cost 10/1/08 - 9/30/09 = $ 1,400,000 Projected NG Commodity Cost 10/1/08 - 9/30/09 = $ 16,600,000 Budgeted Other Supply Related Expenses = $ 4,500,000 Total Recovery Needed for FY 08/09 only = $ 22,500,000 100% of Under Recovery of FYTD PGA thru 9/08 = $ 200,000 Total Annualized Recovery Needed for FY 08/09 = $ 22,700,000 C. Required Weighted Average Recovery Cost/Therm =$ 1.032 Currently overall PGA Recovery is: 96.8% of Contract Rate Therefore, Contract PGA needs to bE $ 1.07 Which makes Standard PGA: $ 1.15 ATTACHMENT #4 Page 1 of 2 D. Projected NG PGA Annual Revenue = Pinellas NG PGA = $ 19,718,173 Pasco NG PGA = $ 2,981,827 Total NG PGA = $ 22,700,000 III. Proposed Natural Gas PGA Billing Factors for 12/01/08 - 09/30/0£ PGA Only ECA in PGA Total PGA A. Proposed Standard Rate PGA Billing Factor $ 1.15 $ 0.07 $ 1.22 B. Less Non-Standard Differential for Reservation Cost $ (0.08) $ - $ (0.08) C. Proposed Non-Standard PGA Billing Factor $ 1.07 $ 0.07 $ 1.14 PGA Only ECA in PGA Total PGA IV. Proposed LP Gas Billing Factors for 12/01/08 - 09/30/09 $ 1.66 $ 0.07 $ 1.73 (Assumes current LP market conditions persist) Note: Includes 3 cents/gallon catch-up to recoup $15,000 projected under-recovery from 530,000 gallons over the year & 38 cents/gallon to recoup the $200,000 of Admin & CCS projected charges. Base est. was $1.25/gallon. UAMy Documents\EXCEUGASRATESTY 08-09gPGA for FY 08-09 - Revised for 12-2009.xis]PGACALC CSW:11f1en008 ATTACHMENT #4 Page 2 of 2 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON-STANDARD THERMS & RESERVATION CHARGES FOR 08/01/2007 - 07/31/2008 Subtotal Subtotal Net Net Charge Per Charge Per Billing Total Interruptible % Contract % Non-Standard % Non- Standard % Reservation Standard Non-Interruptible Month Therms Therms Interruptible Thenns Contract Therms Standard Therms Standard Charges Therm Therm Aug 2007 1,393,874 374,945 26.9% 460,041 33.0% 834,986 59.9% 558,888 40.1% $ 44,444.87 $ 0.080 $ 0.044 Sep 2007 1,456,743 389,277 26.7% 475,631 32.7% 864,908 59.4% 591,835 40.6% $ 65,969.41 $ 0.111 $ 0.062 002007 1,396,440 372,349 26.7% 434,544 31.1% 806,893 57.8% 589,547 42.2% $ 83,314.66 $ 0.141 $ 0.081 Nov 2007 1,612,140 436,555 27.1% 519,640 32.2% 956,195 59.3% 655,945 40.7% $ 162,347.55 $ 0.248 $ 0.138 Dec 2007 2,025,888 434,834 21.5% 750,015 37.0% 1,184,849 58.5% 841,039 41.5% $ 150,733.55 $ 0.179 $ 0.095 Jan 2008 1,946,679 402,833 20.7% 540,066 27.7% 942,899 48.4% 1,003,780 51.6% $ 134,272.17 $ 0.134 $ 0.087 Feb 2008 2,148,023 480,882 22.4% 685,819 31.9% 1,166,701 54.3% 981,322 45.7% $ 154,923.90 $ 0.158 $ 0.093 Mar2008 1,972,879 388,101 19.7% 677,895 34.4% 1,065,996 54.0% 906,883 46.0% $ 166,041.12 $ 0.183 $ 0.105 Apr2008 2,007,187 514,725 25.6% 639,284 31.8% 1,154,009 57.5% 853,178 42.5% $ 108,354.47 $ 0.127 $ 0.073 May 2008 1,749,356 444,089 25.4% 562,918 32.2% 1,007,007 57.6% 742,349 42.4% $ 82,238.60 $ 0.111 $ 0.063 Jun 2008 1,562,509 427,596 27.4% 508,939 32.6% 936,535 59.9% 625,974 40.1% $ 79,645.24 $ 0.127 $ 0.070 Ju12008 1,437,906 403,799 28.1% 455,939 31.7% 859,738 59.8% 578,168 40.2% $ 79,618.90 $ 0.138 $ 0.077 Total 8/07-7/08 20,709,624 5,069,985 24.5% 6,710,731 32.4% 11,780,716 56.9% 8,928,908 43.1% $ 1,311,904.44 $ 0.147 $ 0.0839 # % of Total 100.0% 24.5% 32.4% 56.9% 43.1% For Comparison Total 8/06-7/07 21,440,385 5,284,018 24.6% 7,314,129 34.1% 12,598,147 58.8% 8,842,238 41.2% $ 1,392,186.05 $ 0.157 $ 0.0862 % of Total 100.0% 24.6% 34.1% 58.8% 41.2% Change (730,761) (214,033) -0.2% (603,398) -1.7% (817,431) -1.9% 86,670 1.9% $ (80,281.61) $ (0.011) $ (0.0023) % Change -3.4% -4.1% -8.2% -6.5% 1.0% -5.8% Note: # It is recommended that the "Charge Per Non-Interruptible Therm" differential be rounded to the next lowest penny or $0.080 for the FY 08/09 annual cycle. UAMy DmumenlsEXCEUGASRATESTY 08-091PGA for FY 08-09 - Revised for 12-2009.xls]PGACALC CSW: 11/18/2008 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Energy Charne/Therm 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 Charge/Therm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP/Gallon Rate of with 6.0% Franchise Change from 1/2006 Therm Rate % Change from 1/2006 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/01/1973 Non-Utility Taxable Fuel/Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR DECEMBER 1, 2008 - DECEMBER 31, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS Intern Firm Natural Gas Rate Schedules NG Rate RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SLw/M& NGV NSS IS Reli ht 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 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) Non-Rest. & up $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 ($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) if not prev. if not prev. if not prev. if not prev. billed billed billed billed $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 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 NA 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 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 0.000 $0.720 $0.720 $0.720 $0.720 $0.610 $0.550 $0.490 $0.340 $0.290 $0.240 $0.340 $0.440 $0.240 $0.610 $0.280 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.220 1.140 $1.940 $1.940 $1.940 $1.940 $1.830 $1.770 $1.710 $1.560 $1.510 $1.460 $1.560 $1.660 $1.460 $1.830 $1.420 $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 ($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) @ premise @ premise @ premise + FAC + FAC + FAC + Non-Fuel @ premise Therm Rate for + FAC 250 therms X # Days in Mo. $ 1.775 $ 1.775 $ 1.775 $ 1.775 $ 1.674 $ 1.620 $ 1.565 $ 1.427 $ 1.382 $ 1.336 $ 1.427 $ 1.519 $ 1.336 $ 1.674 $ 1.299 $ 1.882 $ 1.882 $ 1.882 $ 1.882 $ 1.775 $ 1.717 $ 1.659 $ 1.513 $ 1.465 $ 1.416 $ 1.513 $ 1.610 $ 1.416 $ 1.775 $ 1.377 $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) $ (0.320) -14.2% -14.2% -14.2% -14.2% -14.9% -15.3% -15.8% -17.0% -17.5% -18.0% -17.0% -16.2% -18.0% -14.9% -18.4% $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 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.151 $1.085 BTU FACTOR = THERMS1100 CUBIC FEET (CCF) 10/2008 11/2008 12/2008 01/2009 02/2009 03/2009 0412009 05/2009 06/2009 07/2009 08/2009 0912009 Firm Service Rates 1.052 1.054 1.049 Interruptible Service Rates 1.032 1.034 1.028 Attachment #5 Contract NG Rate CNS NA By Contract By Contract NA NA 0.000 Contract + $0.000 Plus 1.140 $1.140 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms $ (0.320) -21.9% $0.069 $1.071 CSW:11 /18/2008 Attachment #6 Page 1 of 2 BTU Factor: 2.714 Gallons/ 100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/ 100 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR DECEMBER 1, 2008 - DECEMBER 31, 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 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 Res]. 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 Energy Charges/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.140 0.140 0.140 0.140 0.140 0.140 0.140 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.740 $1.740 $0.940 $0.340 $0.290 $0.240 $0.530 By Contract + $0.000 Purchased Gas Adjustment/Gallon 1.730 1.730 1.730 1.730 1.730 1.730 1.730 1.730 Total Energy Charges/Gallon $3.470 $3.470 $2.670 $2.070 $2.020 $1.970 $2.260 $1.730 + 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.569 $1.569 $1.569 $1.569 $1.569 $1.569 $1.569 $1.569 Change from 8/2008 Gallon Rate $ (0.670) $ (0.670) $(0.670) $ (0.670) $ (0.670) $ (0.670) $ (0.670) $ (0.690) % Change from 8/2008 Gallon Rate -16.2% -16.2% -20.1% -24.5% -24.9% -25.4% -22.9% -28.5% CSW:11 /18/2008 Attachment #6 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) BU LK PRO PANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR D ECEMBER 1, 2008 - DECEMBER 31, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" COMMERCIAL "WILL CALL" 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" BRLP1 BRLP2 BRLP3 BRLP4 WRLP1 WRLP2 BCLP1 BCLP2 LPSB CLP Applicable Annual Gallon Range 0-60 60.1 - 120 120.1 -300 > 300 0 - 120 > 120 0 - 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 Energy Charges/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./Gallon 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 NA Environm'l Imposition Adj./Gallon - - - - - - - - - NA Weather Normalization Adj./Gallon - - - - - - 0.000 Total Non-Fuel Charges/Gallon $ 1.640 $ 1.440 $ 1.040 $ 0.940 $ 1.440 $ 0.940 $ 0.340 $ 0.290 $ 0.530 Set By Contract + 0.000 Purchased Gas Adjustment/Gallon 1.730 1.730 1.730 1.730 1.730 1.730 1.730 1.730 1.730 1.730 Total Energy Charges/Gallon $ 3.370 $ 3.170 $ 2.770 $ 2.670 $ 3.170 $ 2.670 $ 2.070 $ 2.020 $ 2.260 $ 1.730 + Contract NFE Note: No Monthly Minimum Bill 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 $ 0.161 $ 0.161 Non-Utility Taxable Fuel/Therm $ 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.670) $ (0.670) $ (0.670) $ (0.670) $ (0.670) $ (0.670) $ (0.670) $ (0.670) $ (0.670) $ (0.690) % Change from 8/2008 Gallon Rate -16.6% -17.4% -19.5% -20.1% -17.4% -201% -24.5% -24.9% -22.9% -28.5% CSW.11/18/2008 Attachment #7 Page 1 of 2 Residential Rate History By Components Clearwa ter Gas System Total Rate Compone nts/Therm Contract LP Month NG/therm LP/-gallon * ECA EIA WNA PGA PGA PGA/gallon Oct 08 $ 1.990 $ 3.300 $ 0.140 $ - $ - $ 1.270 $ 1.190 $ 2.260 Nov-08 $ 1.990 $ 3.300 $ 0.140 $ - $ - $ 1.270 $ 1.190 $ 2.260 Dec-08 $ 1.940 $ 2.770 $ 0.140 $ - $ - $ 1.220 $ 1.140 $ 1.730 Jan-09 Feb-09 Mar-09 Apr-09 - May-09 Jun-09 _ $ _n, - - - - - - -------- Incr Above $ 0.10-0 $- -(0.400) --_ - -- $ (0 040) $ Last Year Same Month 55k -13% -22% NA Incr Based $ 3.00 $ (13.11) -- ---------- ------------ - - - on 30 Therms 7% -1 Equivalent Cents/KWH 6.6 10.3 for Gas vs. FPC Rate 12.0 12.0 Note: This is Progress Energy's residential rate in 8/2001 (Residential)- -- Gas Cheaper- ------ by -45% -14% Note_Adde- - per month to Monthly Customer Charge for_NG & LP effective 4/1/2005 Notes. _--- -?---- - - -- - -- --- --------?- ?- ---_-.__. * Based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & equal to Residential LP Will Call csW:08119i2008 I Attachment #7 l Page 2 of 2 -1 t - Residential Rate History B Components Clearwater Gas System Total Rate Corn onents/Therm Contract LP Month NG/therm LP/gallon * ECA EIA WNA PGA PGA PGA/gallon 66t-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 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 $ 1.110 $ 1.040 $ 1.210 Mar-05 $ 1.860 $ 2.180 $ 0.130 $ 0.020 $ 0.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 -- -- -- -- - --- -- - -- - -- - - --- __.----- . -- -- 1.14_0_ Jul-05 -0 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ Aug-05 $ 1.820 $ 2.220 $ 0.140 $ 0.020 $ - $ 1.080 $ 1.010 _ $- - 1.160 Sep-05 $ 1.970 $ 2.300 $ 0.140 $ 0.020 $ - $ 1.230 $ 1.160 $ 1.240 FY 04/05 Avg. $ 1.803 2.162 0.122 0.012 0.004 $ 1.085 1.015 1 $ 1.174 2004 Avg. 1.652 1 $ 1.968 $ 0.123 $ - $ - $ 0.949 $ 0.879 1 $ 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 $ l . 4 7 0 $ 1.390 $ 1.490 Dec-05 -$-----2.260 $ .490 $ 0.120 _ $ 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-0 6 $ 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 Apr-06 $ 2.110 $ 2.320 $ 0.170 $ 0.010 $ - $ 1.350 $ 1.270 $ 1.240 May-06 $ 1.960 $ 27360 $ 0.170 $ 0.010 $ - $ 1.200 $ 1.120 $ 1.280 Jun 06 $ 1.920 $ 2.420 $ 0.180 $ 0.010 $ - $ 1.150 $ 1.070 $ 1 330 Jul-06 $ 1.910 $ 2.500- - - - - - - $ _0 200_ $ 0.010 $- $ 1.120 $-- 1.040 $ - 1.390 - - Sep-06, $ 1.860- 2.600 $ --- 2.600 - ----- - - ---- ---- - - - $ 0. 200 $ 0.200 $ 0.0 10 $ 0.010 $ -- $ 1.070 $ 0.990 $ 1.490 FY 05/06 Avg. $ 2.080 $ 2.480 0.160 0.013 - 1.327 $ 1.247 7 $ 1.407 2005 Avg. $ 1.925 $ 2.278 0.127 $ 0.017 $ 0.004 1.198 $ 1.125 $ 1.256 Oct-06 .940 $ 1446- $ 2.600 -t-2.6-00 - $ 0.180 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Nov-06 $ 1.940 $ 2.600 $ 0.180 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Dec-06 $ 1.940 $ 2.600 _ _ ___ $ 0.180 $ 0.010 $ - $ 1.170 $ 1.090 $ 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 .940 $ 1.940- $ 2.600 -$- $ 0.180 $ 0.010 $ - 1.170 $l . 1 7 0 $ 1.090 $ 1.510 Apr-07 $ 1.940 $ 2.600 ----- ------ - $ 0180 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.490 7 May-0 1.940 $ $ 2.740 $ 6.180 $ - $ 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 Aug 07 $ 1.840 2.990 $ $ 0.180 $ - $ - $ 1.080 $ 1 000 $ 1.910 Sep-07 $ 1.890 - $ 2.990 -- -- - - - - - -- -$ 0.180 $ - $ $ 1.130 i $ 1.050 -$ _ - 1.910 FY 06/07 Avg. $ 1.918 2.742 $ 0.180 $ 0.005 0.008 $ 1.145 $ 1.065 1 $ 1.649 2006 Avg. $ 2.012 2.501 0.175 0.011 $ - $ 1.246 $ 1.166 $ 1.415 ct-07 O $ 1.840 $ 2.990 $ 0.180 $ - $ - $ 1.080 $ 1.000 $ 1.910 _ 1.840 $ -- 1176 $ 0.180 $ - $ - $ 1.080 $ 1.000 $ 2.090 Dec-07 $ 1.840 $ 3.170 $ 0.180 $ - $ $ 1.080 $ 1.000 $ 2.090 Jan-08 $ 1.840 $ 3.170 $ 0.180 $ - $ - $ 1.080 $ 1.000 $ 2.090 Feb-08 1.840 $ $ 3.170 $ 0.180 $ - $ - $ 1.080 $ 1.000 $ 2.090 Mar-08 _ $ 1.810 $ 3.120 $ 0.150 $ - $ 0.030 $ 1.050 $ 0.970 $ 2.040 Apr-08 $ 1.810 $ 3.120 $ 0.150 $ - $ 0.030 $ 1.050 $ 0.970 $ 2.04 , 0 May-08 $ 1.88 0 $ 3.120 $ 0.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 $ 0.150 $ - $ 0.030 $ 1.490 $ 1.410 $ 2.150 Aug-08 2.120 $ $ 3.440 $ 0.120 $ - _ $ -- - $ 1.420 $ 1.340 $ 2.420 Sep-08 - $ 2.120 $ 3.340 _ $ 0.120 $ - $ - $ 1.420 $ 1.340 $ 2.320 FY 07108 Avg. 1.932 3.183 0.146 - 0.013 1.193 1:113 - $ 2.124 2007 Avg. $ 1.893 $ 2.869 0.180 0.003 0.008 1.123 1.043 IT $ 1.779