Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE AUGUEST 2008
~ ~\il: r r'1~/< r: ~.' . .L "', ),.",1, 1. ,C~ t~_., CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet JUL 21 2008 TO: FROM: William B. Horne II, City Manager . \ Chuck Warrington, Managing Director ~ ~~~/CiAL RECORDS Ai\jD LEGISLATIVE SRVCS Depr COPIES: Rod Irwin, Assistant City Manager;, 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 AUGUST 2008 DATE: July 16, 2008 The Propane (LP) supply market again spiked upward to even higher historically levels, but the Natural Gas supply market has settled downward over the past month. Hence, we are recommending an decrease in our Natural Gas Purchased Gas Adjustments (PGA) of 7C/therm but an increase in our LP PGA of 27C/gallon in August. 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 3C/therm or gallon decrease in our Energy Conservation Adjustment (ECA). We are not recommending any change in our Environmental Imposition Adjustment (EIA) at this time. Finally, we are recommending discontinuing our Weather Nor'malization Adjustment (WNA) clause in August, which will reduce customers' bills by 3C/therm or gallon. We recommend your final approval of a WNA recovery level of $257,374 (see analysis on Attachment #4). The net effect of these recommended changes is a net decrease in our typical Residential Natural Gas customer's rate of 13C/therm (down 5.8%) but a net increase in our typical Residential Propane (LP) Gas customer's rate of 21 C/gallon (up 6.5%). This is a historical peak price for LP, but is still 6.2% 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 August 1, 2008: I Natural Gas Firm Standard Rate Schedule PGA ....... $1.42 per therm (down 7 C /therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $1.34 per therm (down 7C/therm) Propane (LP) Gas Rate Schedule PGA .................... $2.42 per gallon (up 27C/gallon) Energy Conservation Adjustment (ECA) ............... $0.12 per therm or gallon (down 3C) Environmental Imposition Adjustment (EIA) ......... $0.00 per therm or gallon (no change) Weather Normalization Adjustment (WNA) .......... $0.00 per therm or gallon (down 3C) William B. Horne II, City Manager Page 2 ,. July 14, 2008 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru June and projections thru Period 13 of this fiscal year. These show that we are projecting being very close to in balance with on our collections to where we began the FYE, which is important to our fiscal condition. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachment #4 shows our calculation of the WNA. 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 3 + years and shows our relationship to electric prices. I should point out that the overall effect is that our tvpical Residential customer rates will now be 38% lower than electric for Natural Gas and LP will be close to 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 August 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments m. - - APpro~e~ ~ ~---;If ~ William B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for August 2008.doc 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-NG\ , i ! i , ! i ! I , , Monthly Cumulative NG PGA , I Budget Reservation Commodity Interest I Cost Center ! Total NG Fuel Total NG PGA Overage YTD Overage I RatelTherm , Month ,-:- Charges Charges Expense , Expenses I I Expenses Billed (Shortage) I (Shortage) , Firm/Contr Prior Year' , I - I I , $ 45,593.93 Oct-07 1$ 2,995,907.81 I $ 986,429.07 $ - $ 31,242.98 1 $ 4,013,579.86 $ 2,306,584.81 ! $ TI ,706,995.05)! $ (1,661,401.12 : 1.08/1.00 Nov-07 ,$ 162,347.55 ! $ 1,119,202.77 I $ 8,307.01 ! $ 41,104.95 i$ 1,330,962.28 ! $ 1,542,587.20 1$ 211,624.92 I $ (1,449,776.20) 1.08/1.00 Dec-07 1$ 150,733.55 I $ 1,402,134.03 ! $ 7,248.88 $ 56,275.23 i$ 1,616,391.69 ' $ 1,986,985.55 I $ 370,593.86 : $ (1,079,182.34 . 1.08/1.00 Jan-08 i$ 134,272.17 $ 1,705,922.47 I $ 5,395.91 $ 40,794.65 I '$ 1,886,385.20 $ 1,931,339.18 ! $ 44,953.98 I $ 11,034,228.36 ' 1.08/1.00 Feb-08 $ 154,923.90 I $ 1,620,686.97 $ 5,171.14 $ 39,591.14 I $ 1,820,373.15 $ 2,104,653.65 I $ 284,280.50 I $ (749,947.86 1.08/1.00 Mar-08 i$ 166,041.12 I $ 1,588,366.40 $ 3,749.74 $ 40,457.54 I $ 1,798,614.80 $ 1,910,479.001$ 111,864.20 $ 638,083.66 ,aj9~l.(h~'/' ':. " Aor-08 I $ 108,354.47 i $ 1,821,873.61 $ 3,190.42 $ 35,342.68 $ 1,968,761.18 $ 1,944,387.46 i $ 124,373.72) $ 002,457.38 '1. Mav-08 I $ 82,238.60 ! $ 1,747,270.88 $ 3,312.29 I $ 46,777.80 ,$ 1,879,599.57 ' $ 1,853,054.05 : $ 126,545.52) $ 689,002.89): ,I. I Jun-08 :$ 79,645.24 : $ 1,603,199.36 $ 3,445.01 ! $ 73,092.95 $ 1,759,382.56 i $ 1,813,218.20 I $ 53,835.64 $ 635,167.26),', Jul-08 I $ 82,000.00 I $ 1,600,000.00 , $ 3,175.84 I $ 40,000.00 I $ 1,725,175.84 I $ 2,059,583.43 I $ 334,407.59 $ 300, 759.67) ~'?"< Aug-08 1$ 82,000.00 I $ 1,600,000.00 : $ 1,503.80 I $ 40,000.00 I , ,$ 1,723,503.80 T $ 1,957,334.601$ 233,830.81 ! $ (66,928.86) f,n. Seo-08 i $ 82,000.00 ! $ 1,600,000.00 i $ 334.64 I $ 40,000.00 I i$ 1,722,334.64 ! $ 1,957,334.60 . $ 234,999.96 i $ 168,071.10 I 1.42if.34 Per 13 I $ 152,132.01 ; $ - $ - 1$ - . 5 '$ 152,132.01 T $ - i$ 1152,132.01), $ 15,939.09 : Total YTD, $ 4,432,596.42 I $ 18,395,085.56 $ 44,834.68 I $ 524,679.92 i '$ 23,397,196.58 i $ 23,367,541.74 T $ 129,654.84) ! 1 (1): Includes annual charae for Admin of $648,160 + Annual CCS chg of $959,620 + Dividend $1,276,400 ! , 1+ FY 06/07 PGA write off of $28,277.51 + VVNA $135.64- $ 2,912,593.15 I , : I Note: Billed includes Deferred Revs re-cQ!!Q of $982,285.39 i , (2) I (5) i Commodity adiustment from FYE transfer of ECA Collected in PGA @ 1/2 of th~ ECA Rate NetRC=' $ 1,367,871.26 : I I NG Proportion = 97.78% x Total ECA Transfer = 1$ 163,980.44 I + Transfer of WNA to PGA = i$ (11,848.43 PROPANE ILPT GAS PURCHASED GAS ADJUSTMENT IPGA-LP\ : ! , I I , Monthlv Cumulative . LP PGA Budaet i Gallons Monthlv I Interest Commodity Total LP Fuel , Total LP PGA Overaae . YTD Overage Therm/Gal. Month i Sold WACOG Expense I Charges I Expenses Billed (Shortage) (Shortage) Prior Year' i I I I $ (37,784.74) I Oct-07 36,522.8 $ 1.38433 I $ 188.92 . $ 50,559.61 i 1 .$ 204,085.71 I $ 69,856.53 $ (134,229.18) I $ (172,013.92) I 1.75/1.91 Nov-07 33,056.8 ~ 1.53309 , $ 860.07 . $ 50,679.05 i 1$ 51,539.12 I $ 68,188.12 $ 16,649.00 i $ (155,364.92) : t.9JI?,Q9 . ,.... Dec-07 38,487.0 i $ 1.60329 ! $ 776.82 I $ 61,705.82 I $ 62,482.65 I $ 80,633.03 ! $ 18,150.38 , $ (137,214.54)1 1.91/2.09 Jan-08 , 58,278.4 ! $ -------- 1.65887 , $ 686.07 I $ 96,676.29 i i$ 97,362.36 I $ 122,012.14 : $ 24,649.78 , $ 1112,564.76)' , 1.91/2.09 Feb-08 53,023.9 $ 1.64212 ! $ 562.82 I $ 87,071.61 I $ 87.634.431$ 110,891.59 ! $ 23,257.16 I $ (89,307.60) , 1.91/2.09 Mar-08 44,360.6 $ 1.64377 ' $ 446.54 i $ 72,918.62 : 1$ 73,365.16 I $ 91,039.92 ; $ 17,674.76 . $ (71,632.84) 1:,~~'/'l.~;P4 .. Aor-08 I 56,003.9 $ 1.62757 . $ 358.161 $ 91,150.27 I i$ 91,508.43 i $ 114,285.55 I $ 22,777.12 : $ (48,855.72) i 1.87/2.04 May-08 39,023.6 $ ------ 1.71081 : $ 244.28 I $ 66,761.97 I $ 67,006.24 I $ 81,365.43 . $ 14,359.19 i $ (34,496.54) Jun-08 28,774.2 $ 1.77663 i $ 172.48 I $ 51,121.11 ' ,$ 51,293.59 i $ 61,604.37': $ 10,310.78 : $ (24,185.76) ," 5 Jul-08 37,000.0 $ 1.91000 i $ 120.93 . $ 70,670.00 i 1$ 70,790.93 I $ 79,445.52 I $ 8,654.59 I $ (15,531.17) 1.97/2.15 Aua-08 37,000.0 $ -------------- 2.06000 : $ 77.66 i $ 76,220.00 i . i$ 76,297.66 $ 89.422.40 ! $ 13,124.74 I $ (2,406.43) '. 2.2114.42 Seo-08 37,000.0 $ 2.09000 , $ 12.03 , $ 77,330.00 ' '$ 77,342.03 : $ 89,422.40 i $ 12,080.37 · $ 9,673.94 I 2.21/2.42 Per13 4 $ 10,385.84 : $ - : $ (10,385.84)! $ (711.90) Total YTD' 498,531.2 $ 1.71075 i $ 4,506.79 I $ 852,864.34 I i$ 1,021,094.15 $ 1,058,166.99 . $ 37,072.84 ' : Cost Center Exoenses , : , I CCS Chg + Admin Chg + Dividend 1$ 88,530.00 1 (2) FY 06/07 Write off PGA & WNA , 1,136.69: 1 ' . . : Fuel , 15,000.00 i 1 ' T PC Anywhere 159.00 1 LP Yard Vaporization 2,696.05 1 (4) Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate LP PGA Event fuel cost , 5,794.01 ~ 1 LP Proportion = 2.22% x Total ECA Transfer = '$ 3,723.02 : Depreciation of LP Tanks 34,414.23 1 + ....------4----____. --------------,---._-------------+------- I Suburban Software Systems 1,250.00 , 1 .1 ; Suburban Software Systems License 569.70 -- 1 Total Cost Cntr Exp Proj. Adders . Allow for Welle Fargo Insurance invoice_#637545 3,787.50 , 1 $ 153,337.18 $ 160,000.00 $ 6,662.82 . CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 Attachment #1 Page 2 of 3 ENERGY CONSERVATION ADJUSTMENT IECAI , , : I , . I Monthly Cumulative ! ECA , --+-- Budget ; Cost Center Interest , Total ECA I Total ECA Overage YTD Overage NGlTherm Month · i i IShortage) (Shortage) LP/Gal, Expenses : Notes/Exceptionalltems Expense , Expenses Billed , Prior Year' i I . ; , - , '$ - Oct-07 I $ 318,454.23 IPromo$36,720,Adv $0, Employ Costs$57,160 i$ - . ] 1 '$ 318,454.23 : $ 111,884.77 : $ (206,569.46 I $ (206,569.46) : 0.18/0.18 Nov-07 i $ 95,913.73 iPromo$26,790,Adv $1,730, Employ Costs$67,394 i$ 1,032.85 , ;$ 96,946.58 I $ 122,642.60 i $ 25,696.02 . $ (180,873.44) I 0.18/0.18 Dec-07 $ 76,495.95 I Promo$23,405,Adv $1,025, Employ Costs$22,066 $ 904.37 . , ]$ 77,400.32 I $ 156,000.42 . $ 78,600.10 ! $ (102,273.33) I 0.18/0.18 Jan-08 '$ 79,959.70 I Promo$24,930,Adv $230, Employ Costs$54,800 $ 511.37 I $ 80,471.07 i $ 188,214.03 , $ 107,742.96 ! $ 5,469.63 . 0.18/0.18 Feb-08 ! $ 143,992.35 i Promo$75,046,Adv $180, Employ Costs$68,766 $ - i i$ 143,992.35 . $ 184,801.05 ! $ 40,808.70 ! $ 46,278.33 I 0.18/0.18 Mar-08 '$ 85,799.60 I Promo$27,988,Adv $1,590, Employ Costs$56,222 i $ - I ] 1$ 85,799.60 ! $ 141,996.29 I $ 56,196.69 i $ 102 ,4 75.02?;Q~':P!'Q;15 Apr-08 .$ 87,873.23 IPromo$39,190,Adv $3,310, Employ Costs$45,373 1$ - I 1$ 87,873.23 i $ 135,572.31 ' $ 47,699.08 $ 1~'1741O~~~!~. May-08 i$ 359,240.59 'Promo$20,447,Adv $1,953, Employ Costs$55,692 ,$ - . 2 ,$ 359,240.59 I $ 70,010.94 ! $ (289,229.65) $ (139,055.55) Jun-08 i$ 70,347.34 i Promo$38,463,Adv $2,270, Employ Costs$29,614 ,$ 695.28 i ! i$ 71,042.62 I $ 45,674.19 i $ 125,368.43) $ (164,423.98) Jul-08 '$ 90,000.00 i 1$ - : I 1$ 90,000.00 I $ 102,584.82 ! $ 12,584.82 I $ (151,839.16) Aug-08 i$ 90,000.00 1$ - I 1$ 90,000.00 I $ 82,067.85 , $ (7,932.15)' $ (159,771.31 ) Sep-08 ! $ 90,000.00 ! n- - i$ 90,000.00 i $ 82,067.85 ! $ 17,932.15) $ (167,703.46)[ n U111? Per13 I I 6 I $ - ,$ 167,703.46 I $ 167,703.46 i $ - i Total YTD. $ 1,588,076.72 ' i$ 3,143.86 , I 1$ 1,591,220.58 I $ 1,591,220.58 ' $ - I I I ! . , : i , 11) I Includes annual charge for Admin Chg of $38,760 + CCS cha of $69,670 I (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 , ; I Note: Maximum amount which can be transferred = '$ 711,758.56 : (2) I FY 07/08 SO Write Off adjustment = 1$ 281,148.85 I I I I I (3) I i i i I , , I I , , . I I I i Net CCE= $ 1,082,353.21 I i I , : I i , I I I ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) i , ---t--- : i Monthly Cumulative EIA Budget Cost Center Interest i Total EIA Total EIA Overage YTD Overage NGlTherm Month Expenses Notes/Exeeptionalltems Expense i Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year] I . i , .$ 113,277.52 i Oct-07 '$ 14,182.79 .$ - 1 :$ 14,182.79 ' $ (0.21)' $ (14,183.00) i $ 9.9,094.52 , 0.00/0.00 Nov-07 :$ 1,427.00 -~--- ,$ i 2 $ 1,427.00 I $ 95,999.86 I $ 94,572.86 ' $ 193,667.38 i 0.00/0.00 - ! Dee-07 '$ 2,909.70 : 1$ - I i$ 2,909.70 i $ 10.03); $ (2,909.73): $ 190,757.65 ' 0.00/0.00 Jan-08 I $ 4,529.35 , $ - $ 4,529.35 I $ (0.76)1 $ (4,530.11) $ 186,227.54 , 0.00/0.00 Feb-08 i $ 1,427.00 i$ - I $ 1,427.00 ; $ (0.39) i $ (1,427.39); $ 184,800.15 I 0.00/0.00 Mar-08 i$ 2,799.00 '$ - i ,$ 2,799.00 I $ (2.48): $ (2,801.48) $ 181,998.67 i 0.00/0.00 Apr-08 $ 1,427.00 I :$ - i $ 1,427.00 . $ 0.03 i $ (1,426.97) i $ 180,571.70 , 0.00/0.00 Mav-08 i $ 8,742.93 I $ I $ 8,742.93 I $ (0.18)1 $ (8,743.11)1 $ 171,828.59 ! 0.00/0.00 -- - Jun-08 ; $ 6,299.19 . ,$ - , ! $ 6,299.19 1$ - $ (6,299.19) $ 165,529.40 0.00/0.00 Jul-08 $ 10,000.00 ,$ - $ 10,000.00 . $ - ,$ (10,000.00), $ 155,529.40 . 0.00/0.00 Aug-08 1$ 10,000.00 ' $ - . $ 10,000.00 i $ - i $ (10,000.00)! $ 145,529.40 . 0.00/0.00 Sep-08 ! $ 10,000.00 i .$ - $ 10,000.00 i $ - ,$ (10,000.00) $ 135,529.40 I 0.00/0.00 Per13 $ - $ - , $ - $ - '$ . - $ 135,529.40 ' Total YTDI $ 73,743.96 ' $ - $ 73,743.96 $ 95,995.84 . $ 22,251.88 I __ (1): Includes annual charges for Admin Charge $10,300 $ 10,484.79 . :+ FY 06/07 write off of $184.79 = .'.- (2) Billed includes $96,000 of MGP insurance Claim Recovery -----------~------ , --------.. ------- Net GGE= : $ 63,259.17 i . ~- CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 Attachment #1 Page 3 of 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA\ : ! I ! I i i i i Monthly i Cumulative . Total BudQet i i , Total All Total Recoverv ! OveraQe I YTD Overage NGlTherm-Flrm Month i , I Expenses Billed ! (Shortage) I (Shortage) , LP/Gallon i Prior Year: I , , - i - '$ - 1$ 121,086.71 Oet-07 I i . $ 4,550,302.59 I $ 2,488,325.90 i $ (2,061,976.69) i $ (1,940,889.96) , 1.26/2.09 Nov-07 I 1,460,674.97 I 1,629,417.76 I $ 346,542.61 I $ (1,592,347.17) 1,2f3/.?27 Dee-07 I , 2,223,618.97 I $ 464,434.62 i $ (1,127,912.56) i 1.26/2.27 I 1,759,164.35 Jan-08 I 2,066,747.96 i 2,241,564.59. $ 172,616.61 '$ (955,095.95) · 1.26/2.27 Feb-06 . , i 2,053,426.93 i 2,400,345.90 i $ 346,916.97 i $ (606,176.96) i 1.26/2.27 Mar-06 I i 1,960,576.56 I 2,143,512.73 . $ 162,934.17 i $ (425,242.61)' 1~?OI2;19, Apr-06 I ! 2,149,569.64 ! 2,194,245.35 i $ 44,675.51 i $ (3M'$7T~I~ci MaY-06 I I I 2,314,569.33 i 2,004,430.24 i $ (310,159.09)1 $ (690,726.39) ..19.. Jun-06 , , I 1,666,017 .96 ' 1,920,496.761 $ 32,476.60 i $ (656,247.59) ',~ Jul-06 i I 1,695,966.77 i 2,241,613.76 I $ 345,647.00 : $ (312,600.60) . Aug-06 I ! 1,899,601.45 2,126,624.65 I $ 229,023.40 . $ (63,577 .20),,, ........., Sep-06 1,699,676.66 i 2,126,624.65; $ 229,146.16 I $ 145,570.96 . 1.54/2.54 Per13 i 162,517.85 167,703.46 ! $ 5,165.61 '$ 150,756.59 , Total YTD i I : '$ 26,083,255.27 I $ 26,112,925.15 ! $ 29,669.66 : i I . , ! I I i , , Total of All Additional Exoenses Recovered Thru Adjustment Clauses = '$ 3,5e2,136.63 I ! I I , i , I . , i I , WEATHER NORMALIZATION (WNA) I , ! , I i , I Monthly Cumulative WNA BUdget .-. Interest Overage YTD OveraQe i - NGlTherm Month LP Gallons' Expense I Rate/Gallon I NG Therms . RatelTherm I (Shortage) (Shortage) i LP/Gallon Beg. Bal. , :$ - 1$ (257,374.00) , Oct-07 , 36,522.6 ! $ - I - I 1,396,440.2 - $ (9.60l $ (257,363.60) I 0.00/0.00 Nov-07 I 33,056.8 , $ - - . 1,612,140.2 - '$ (0.16)1 $ (257,363.96) , 0.00/0.00 Dee-07 36,467.0 i $ - i - 1,920,966.7 - $ (2.21), $ (257,366.17) 0.00/0.00 Jan-Q6 56,276.4 i $ - - ! 2,051,577.7 - ,$ (1.26)i $ (257,367.45) ; 0.00/0.00 Feb-06 I I 53,023.9 I $ - ! - I I 2,146,022.9 i - .$ (0.79) I $ (257,366.24) i 0.00/0.00 Mar-06 44,360.6 I $ - I 0.03 i i 1,972,679.1 0.03 i $ 59,755.25 i $ (197,632.99) K .().;!l~IQ;()3 Apr-06 56,003.9 ; $ - 0.03 ! 2,007,166.6 . 0.03 ! $ 61,946.79 1 $ (135,666.20) : 0.03/0.03 May-06 39,023.6 : $ - i 0.03 ' 1,749,356.1 , 0.031$ 53,666.69 I. $ (62,019.51) I 0.03/0.03 Jun-06 I 26,774.2 I $ - i 0.03 ! 1,562,509.3 i 0.03 i $ 47,757.94 i $ (34,261.57) ! 0.03/0.03 Jul-06 -----; 37,000.0 $ - I 0.03 i : 1,500,000.0 , 0.03' $ 46,110.00 i $ 11,846.43 i 0.03/0.03 Aug-06 37,000.0 i $ - , - i 1,500,000.0 I - i$ - :$ 11,848.43 Q.Q(){Q.OO . .... Sep-08 37,000.0 I $ - I - 1,500,000.0 i - '$ - '$ 11,846.43 0.00/0.00 Per 13 ! I . 1 i$ (11,848.43\ i $ - , Total YTD 498,531.2 ' - . 20,921,100.8 : '$ 269,222.43 ! . I I , . i I (1). Transfer of WNA FYE balance to NG PGA ---- , Last Uodated:07/14/2008 ,4 r r II-t://f~ /It 2- - CGS Natural Gas Cost Actual/Projections FY08 as 01 7/14/2008 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 J un-08 Jul-08 Aug-08 Sep-08 Contract Capacity Contract Excess Capacity Relinquishment Purchased Sold Gas Sold Gas Purchased % Sold Gas WACOG FTS-1 FTS-2 No-Notice Caoacltv Volume Cost Gas Actual Prolected Gas lost vs. Prolected Purchased 170,438 41,788 15500 56,435 (33,179 $ (18700.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,3% $ 8.11 316,789 55 211 31 000 188 003 102 009 $ 21716.15 183,997 202,589 257,000 -5.80% 78.8'1. $ 7.62 316,789 55,211 46 500 142 806 88,873 $ 38,944.83 229 194 194,668 237,000 6.28% 82.1% $ 7.92 296 351 51649 43 500 146419 48,587 $ 7117.76 201,581 214802 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 216570 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 $ 8988.14 157,710 174936 170,000 0.93% 102.9% $ 10.04 139560 40,440 10500 43,349 26914 $ 8,564.45 136,651 158,251 155,000 100.8% $ 11.75 144212 41788 10850 31081 31000 $ 12400.00 154 919 154000 $ 11.66 144212 41788 10850 31000 31 000 $ 112400.00 155 000 155 000 . ~ 11.37 139560 40 440 10500 25 000 21 000 $ 8 400.00 155000 155 000 $ 11.44 Total 2,652,052 572,174 267,600 1,114,323 (523,418) ($169,474.18) 2,109,903 1,642,111 2,280,000 0.39% 91.7% $9.47 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jut-08 Aug-08 Sep-08 Reservation charges FTS-l FTS.l FTS-2 FGU Load Load Total FTS-l FTS-2 No-Notice charges Usage Charge Usage Charge Total Monthly Fuel Cost Management fee Factor Factor Billing Inhase 1/\ Inhase 1111 NNTS lotiase III" lohase 1I1l' Commodltv charaes Adiustments IFuel Retentlonl Per Month wi Relinoulsh wlo Relinouish IFGU+Peonlesl $ 69112.61 $ 32134.97 $ 767.25 $ 3,255.76 $ 878.20 $ 1,030,360.03 $ 3,091.69 $ 29,673.49 $ 7,047.00 87.0% 73.4% $ 1,120,861.03 $ 124.314.14 $ 41087.67 $ 1,113.75 $ 3,893.76 $ 112.20 $ 1 380 878.25 $ 1,947.52 $ 39.681.45 $ 8;114.00 57.5% 53.4% $ 1,559,275.42 $ 128,457.94 $ 42457.26 $ 1,534.50 $ 4,169.25 $ 90.09 $ 1 238,689.51 $ 2,991.49 $ 36,562.44 $ 10,250.00 68.1% 49.5% $ 1,401,585.75 $ 128457.94 $ 42.457.26 $ 2301.75 $ 5,429.79 $ 87.82 $ 1,666,243.22 $ 5,132.96 $ 53,026.55 $ 10,677.00 81.0% 61.6% $ 1,815,591.71 $ 120170.33 $ 39 718.08 $ 2 153.25 $ 4,572.90 $ 88.67 $ 1,532,239.85 $ 3,213.19 $ 44,246.46 $ 9,396.00 67.3% 57.9% $ 1,709,868.09 $ 128457.94 $ 42,457.26 $ 1 534.50 $ 4,680.09 $ 94.79 $ 1 773,490.94 $ 874.29 $ 51,118.03 $ 9,609.00 64.1% 56.4% $ 1,956 105.28 $ 87819.14 $ 41087.67 $ 1113.75 $ 2,011.31 $ 1594.26 $ 1,762,308.53 $ 3,284.98 $ 55,252.14 $ 8,328.00 81.5% 65.9% $ 1,888,732.53 $ 58,477.97 $ 32 134.97 $ 613.80 $ 2,156.65 $ 1294.43 $ 1 486 264.71 $ (4,507.101 $ 54,557.18 $ 7,260.00 94.6% 84.8% $ 1,583,423.87 $ 56,591.58 $ 31,098.36 $ 519.75 $ 1,947.67 $ 1285.70 $ 1,510,977.25 $ 3,092.36 $ 56,000.97 $ 6,534.00 89.3% 75.9% $ 1,606,292.80 $ 57 035.85 $ 32 134.97 $ 537.08 $ 5 778.92 $ 1002.91 $ 1717217.27 $ - $ 55 263.83 $ 6 930.00 99.9% 83.3% $ 1 806 591.22 $ 57 035.85 $ 32134.97 $ 537.08 $ 5 830.42 $ 1002.91 $ 1 685 685.59 $ $ 54 235.26 $ 6 975.00 100.0% 83.3% $ 1 762 993.48 $ 55 195.98 Is 31 098.36 $ 519.75 $ 5 899.84 $ 970.56 $ 1 695 198.63 $ - $ 54 543.23 $ 6.975.00 97.5% 86.1%1 $ 1 773612.72 Total $1,071,127.26 $440,001.80 $13,246.20 $49,626.36 $3,153.75 $18,479,551.77 $ 12,694.98 $584,161.02 $98,095.00 82.3% 69.3% $19,984,933.89 Total Projected DTH WACOG Total Reservation Total Commodl Cost Purchased 1 st 6 Months $941,385.48 $ 8,621,901.80 $9,563,287.28 1,172,792 $8.154 2nd 6 Months $563,996.64 $ 9,857,649.97 $10,421,646.61 937,111 $11.121 TOTAL $1,505,382.12 18,479,551.77 $19,984,933.89 2,109,903 $9.47 Propane Weighted Average Cost of Gas rNACOG} FY 2007-08 ArrI'J-cHl11e.,u r- #"J 7/14/2008 ~ comoanvl Invoice I Gallons I Propane I Propane I Shipping I Total T FYTD T Cost of Tank Tank WACOG Date Sea-3 . f L&L Shloolno Delivered Rate Cost Cost Cost Gallons Invento'" Inventorv Wlthdrawl I I I I T T T .. 09/30/07 o. $ 48,685.65 I 37,199 1.30879 10/10107 Sea-3 14007-0778 192222, 92380 I 19,8351 1.46095 I $ 28,474.53 I $ 503.33 I $ 28,977.86 I 19,835.0 I $ 77,663.51 57,034 1.36171 10/15107 Sea-3 4007-0796 92336, 92286 1 18,963 I 1.46095 1$ 27,222.71 I $ 481.20 I $ 27,703.91 I 38,798.0 I $ 105,367.42 75,997 1.38647 10/31/07 MONTHLY INVENTORY ADJUSTMENT I 280 I 0.80507 I $ 225.42 I $ - 1$ 225.42 I T$ 105,592.84 76,277 1.38433 10131/07 END OF MONTH $ 51.144.22 36,945 39.332 1.38433 11109/07 Sea-3 14007-0861 I i 9,7441 1.65996 I $ 15,924.33 I $ 250.31 I $ 16,174.64 I 48,542.0 I $ 67,318.86 46,689 I 1.44186 : 11/13/07 Sea-3 14007-0889 I I 37,372 I 1.66011 I $ 61 075.94 I $ 965.87 I $ 62,041.811 85,914.0 T $ 129,360.67 i 84,061 1.53889 11/30107 MONTHLY INVENTORY ADJUSTMENT 1 3181 - 1$ - 1$ - 1$ - i 1$ 129,360.67 84 379 , 1.53309 11130107 END OF MONTH $ 70,732.21 46,137 38,242 1.53309 I 12/18107 Sea-3 14007-1005 I I 49,342 I 1.68031 I $ 81,629.92 I $ 1,279.76 I $ 82,909.68 I 135,256.0 I $ 153,641.89 95,479 ! 1.60917 ' 12/31107 MONTHLY INVENTORY ADJUSTMENT I 860 I 0.95095 I $ 817.82 I $ - 1$ 817.82 I 1$ 154,459.71 96,339 I 1.60329 : 12/31107 END OF MONTH $ 90,611.75 56,516 I 39,823 1.60329 i 01/24108 Sea-3 14008-0072 , I 39,671 I 1.72267 I $ 67,312.56 I $ 1,027.31 I $ 68,339.87 I 174,927.0 I $ 156,951.62 96,187 1.65253 i 01/28/08 Sea-3 4008-0088 I 10,000 I 1.72267 I $ 16,967.70 i $ 256.96 I $ 17,226.661 184,927.0 T $ 176,178.28 106,187 1.65913 . 01/31/08 MONTHLY INVENTORY ADJUSTMENT I 9451 1.62891 I $ 1,539.32 I $ - 1$ 1,539.32 I i$ 177,717.60 107,132 ! 1.65887 01/31/08 END OF MONTH $ 76.551.67 48.147 60,985 1.65887 02I08I08 Sea-3 14008-0108 I I 20,1071 1.62637 I $ 32180.65 I $ 520.68 I $ 32.701.331 205,034.0 r $ 109,253.00 I 66,254 1.64900 02/12/08 Saa-3 14008-0127 I I 19,1401 1.62637 I $ 30,633.00 I $ 495.65 I $ 31,128.65 I 224,174.0 I $ 140,381.65 85,394 1.64393 ! 02/29108 MONTHLY INVENTORY ADJUSTMENT I 371 1.22577 I $ 454.76 1 $ - 1$ 454.76 1 1$ 140,836.41 85,765 1.64212 02129108 END OF MONTH $ 55,377.21 33,723 52,042 1.64212 03/12108 Sea-3 14008-0208 I I 48,31~ I 1.64380 I $ 78,125.52 1 $ 1,296.42 I $ 79421.94 I 272 490.0 I $ 134,799.15 82,039 1.64311 03131108 MONTHLY INVENTORY ADJUSTMENT I 296 1.82669 I $ 540.70 I $ - 1$ 540.70 I 1$ 135 339.85 i 82 335 1.64377 03/31108 END OF MONTH $ 53,473.50 32,531 49,804 1.64377 04/09108 Sea-3 14008-0288 I I 48,5041 1.61382 I $ 76,954.99 I $ 1321.63 I $ 78,276.621 320,994.0 T $ 131.750.12 81,035 1.62584 04130108 MONTHLY INVENTORY ADJUSTMENT I 243 2.20280 I $ 535.28 I $ - 1$ 535.28 I 1$ 132 285.40 81,278 1.62757 . 04I30I08 END OF MONTH $ 41,210.00 : 25,320 55,958 1.62757 I ~. -1sea-3 14008-0386 I I 38,8941 1.78877 , $ 68,492.33 I $ 1,080.02 I $ 69,572.35 I 359,888.0 I $ 110,782.35 ! 64,214 1.72521 05131108 MONTHLY INVENTORY ADJUSTMENT I 1,084 0.85815 I $ 930.23 I $ - 1$ 930.231 T$ 111,712.58 i 65,298 1.71081 ! . 05131108 END OF MONTH $ 52.693.00 ! 30,800 34.498 1.71081 ! 06110108 14008-0460 i ! 47,7021 1.84633 I $ 86,698.39 I $ 1,375.19 I $ 88,073.56 I 407,590.0 I $ 140,766.58 I 78 502 1.79316 ! 06130108 MONTHLY INVENTORY ADJUSTMENT I 1,028 0.51445 I $ 528.85 I $ - 1$ 528.851 T$ 141,295.43 I 79,530 1. 77663 06/30/08 END OF MONTH $ 91,606.63 i 51.562 27,968 1.77663 . I I I I I I I I ! I ! I I I I I I ! , I FYTD Totals I i 360,972 I 0.60628 I 214327 I $ 3 480.47 I 218,851 I I Projections Delivered Delivered Delivered Cost Tank EOM Tank Projected NYMEX CGS Cost Gallons Cost of Inventory Withdrawl Inventory WACOG Jun-08 $ 91,606.63 n 51,562 1.78 Jul-08 1.88 2.00 30,000 $ 60,000.00 $ 98,307.71 30,000 51,562 1.91 Aug-08 1.98 2.10 40,000 $ 84,000.00 $ 106,044.02 40,000 51,562 2.06 Sep-08 1.98 2.10 40,000 $ 84,000.00 $ 107,778.77 40,000 51,562 2.09 Oct-08 1.99 2.13 40,000 $ 85,000.00 $ 109,167.76 40,000 51,562 2.12 Nov-08 1.99 2.13 50,000 $106,250.00 $ 109,557.09 50,000 51,562 2.12 Dec-08 1.99 2.13 60,000 $127,500.00 $ 109,571.24 60,000 51,562 2.13 CSW:07/14/2008 Attachment #4 CALCULATION OF WEATHER NORMALIZATION ADJUSTMENT Proiected Deficit for FY 2007/2008 Proiected Heating Degree Davs FYE 2007/2008 = 10 Year Average HDDs for Year thru FY 2006/2007 317 499 63.5% Therefore, Shortfall = 36.5% Thereby exceeding the 10% threshhold for WNA application Projected Shortfall in Natural Gas Therms Projected Shortfall in LP Gas Gallons Total Projected Shortfall in NFE Billings for FY 2007/2008 637,000 15,088 @ @ $ 0.388 $ 0.684 $ $ $ 247,054 10,319 257,374 Proiected Usal!e for Period of NG Therms LP Gallons Total Therms & Gallons March 1, 2008 - July 31, 2008 * 8,800,000 200,000 Less Projected Fixed Rate Contract Rates = 10% = Projected Therms & Gallons to Collect on = 9,000,000 (900,000) 8,100,000 Required WNA Recovery Rate $ 257,374 8,100,000 $0.0318 Round to $0.030 Per Therm or Gallon * Note: Actually plan to bill @ this rate March 1 - July 31,2008, when we project full recovery of WNA. U:\My DocumentslEXCELIGASRA TESIFY 07-08\[WNA Recovery Beginning 3-1-2008.xls]Sheetl CSW:07/15/2008 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) Environmental Imposition Adj. (EIA) Weather Nonnalization Adj. (WNA) 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 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR AUGUST 1, 2008 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS --RL SMF MMF NA (1 - NA (4 + NA (4 + 3 Units) Units) Units) LMF NA(4+ Units) Firm Natural Gas Rate Schedules SGS MGS LGS RAC 0- 18,000- 100,000 17,999 99,999 & up $20.00 $30.00 $75.00 ($30.00) ($50.00) ($125.00) $0.470 $0.410 0.120 0.120 0.000 0.000 0.000 0.000 $0.590 $0.530 1.420 1.420 $2.010 $1.950 $0.350 $0.470 1.420 $1.890 $20.00 $30.00 $75.00 ($30.00) ($50.00) ($125.00) NA(l- 3 Units) $8.00 ($12.00) if not prevo billed $0.200 0.120 0.000 0.000 $0.320 $1.740 0.120 0,000 0.000 1.420 GAC NA(O- 149 tons) $20.00 ($30.00) if not prevo billed $0.150 0.120 0.000 0.000 $0.270 1.420 $1.690 LAC NA(150 tons & +) $30.00 ($50.00) if not prevo billed ~ SL wlM& Reliaht NA NA $20.00 ($30.00) Interr. NG Rate NGV NSS---1L NA NA 100,000 Non-Res!. & up $20.00 $8 Res/$20 GS ($30.00) ($12 Res/$30 GS) if not prevo billed $0.100 $0.200 $0.300 0.120 0.120 0.120 0.000 0.000 0.000 $0.220 $0.320 $0.420 0.000 0.000 0.000 $1.640 1.420 1.420 1.420 $1.840 $8.00 $20.00 @ $30.00 @ ($12.00) ($30.00) ($50.00) @ premise @ premise @ premise $1.740 $20.00 ($30.00) + FAC $50.00 $150.00 ($75,00) ($250.00) $0.100 $0.470 $0.280 0.120 0,120 NA 0.000 0.000 NA $0.220 $0.590 $0.280 0.000 0.000 0.000 $1.640 1.420 1.420 1.340 $1.620 $20.00 $8 Res/$20 GS ($30.00) ($12 Res/$30 GS) + FAC $ 1.940 $ 1.940 $ 1.940 $ 1.940 $ 1.839 $ 1.784 $ 1.729 $ 1.592 $ 1.546 $ 1.501 $ 1.592 $ 1.684 $ $ 2.056 $ 2.056 $ 2.056 $ 2.056 $ 1.949 $ 1.891 $ 1.833 $ 1.688 $ 1.639 $ 1.591 $ 1.688 $ 1.785 $ $0.069 $0.069 $0.069 $0.069 $1.351 $1.351 $1.351 $1.351 BTU FACTOR = THERMS/100 CUBIC FEET rCCF) $8.00 $20.00 $30.00 $75.00 ($12.00) ($30.00) ($50.00) ($125.00) $0.580 $0.580 $0.580 $0.580 0.120 0.120 0.120 0.120 0.000 0.000 0.000 0.000 QJ1QQ ~ 2.QQQ 0.000 $0.700 $0.700 $0.700 $0.700 1.420 1.420 1.420 1.420 $~lW $~lW $~lW $~lW $8.00 $20.00 $30.00 $75.00 ($12.00) ($30.00) ($50.00) ($125.00) $0.069 $0.069 $1.351 $1.351 $0.069 $1.351 1.053 1.048 10/2007 11/2007 12/2007 01/2008 02/2008 03/2008 04/2008 1.048 1.053 1.049 1.033 1.033 1.029 1.027 Change from 10/2004 Thenn Rate $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ 0.410 $ % Change from 10/2004 Therm Rate 24.0% 24.0% 24.0% 24.0% 25.6% 26.6% 27.7% 30.8% 32.0% 33.3% 30.8% 28.7% Utility Tax Note: Fuel Rate per Therm 10/01/1973 Non-Utility Taxable FuellTherm Firm Service Rates Interruptible Service Rates 1.047 1.049 1.027 1.028 1.027 $0.069 $1.351 $0.069 $1.351 $0.069 $1.351 $0.069 $0.069 $1.351 $1.351 OS/2008 06/2008 07/2008 08/2008 09/2008 1.049 1.028 1.049 1.029 1.050 1.030 1.051 1.030 @ premise + FAC $2.010 $50.00 $150.00 ($75.00) ($250.00) + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. 1.501 $ 1.839 $ 1.482 1.591 $ 1.949 $ 1.571 0.410 $ 0.410 $ 0.380 33.3% 25.6% 30.6% $0.069 $0.069 $0.055 $1.351 $1.351 $1.285 Attachment #5 Contract NG Rate ~ NA By Contract By Contract NA NA 0.000 Contract + $0.000 Plus 1.340 $1.340 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms $ 0.380 39.6% $0.069 $1.271 CSW:07/14/2008 Attachment #f3 Page 1 of 2 BTU Factor: 2.714 Gallons/l00 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/l00 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR AUGUST 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 o - 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 Res!. or $50.00 Set By Contract $20.00 GS if not Non-Fuel EnerQV CharQes/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.120 0.120 0.120 0.120 0.120 0.120 0.120 NA Environm'llmposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Total Non-Fuel Charges/Gallon $1.720 $1.720 $0.920 $0.320 $0.270 $0.220 $0.510 By Contract + $0.000 Purchased Gas AdjustmenUGallon 2.420 2.420 2.420 2.420 2.420 2.420 2.420 2.420 Total Energy Charges/Gallon $4.140 $4.140 $3.340 $2.740 $2.690 $2.640 $2.930 $2.420 + 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 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 Non-Utility Taxable FuellTherm $2.259 $2.259 $2.259 $2.259 $2.259 $2.259 $2.259 $2.259 Change from 10/2004 Gallon Rate $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.290 % Change from 10/2004 Gallon Rate 46.3% 46.3% 64.5% 91.6% 94.9% 98.5% 80.9% 114.2% CSW:07/14/2008 Attachment #6 Page 1 of2 BTU Factor: UH 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 AUGUST 1, 2008 - SEPTEMBER 3D, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MUL TI-FAMIL Y LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBVGENERATOR 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 Custom~r Charge $8.00 $20.00 $8.00 $20.00 $30.00 $8.00 Res!. or $50.00 Set By Contract $20.00 GS if not Non-Fuel Enerav Charaes/Gallon: prevo billed @ premise Non-Fuel Energy Charge IGallon $1.600 $1.600 $0.800 $0.200 $0.150 $0.100 $0.390 Set By Contract Energy Conservation Adj.lGallon 0.120 0.120 0.120 0.120 0.120 0.120 0.120 NA Environm'llmposition Adj. IGallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Total Non-Fuel Charges/Gallon $1.720 $1.720 $0.920 $0.320 $0.270 $0.220 $0.510 By Contract + $0.000 Purchased Gas AdjustmenVGallon 2.420 2.420 2.420 2.420 2.420 2.420 2.420 2.420 Total Energy'Charges/Gallon $4.140 $4.140 $3.340 $2.740 $2.690 $2.640 $2.930 $2.420 + 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/0111973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm $2.259 $2.259 $2.259 $2.259 $2.259 $2.259 $2.259 $2.259 Change from 10/2004 Gallon Rate $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.310 $ 1.290 % Change from 10/2004 Gallon Rate 46.3% 46.3% 64.5% 91.6% 94.9% 98.5% 80.9% 114.2% J J j .L 1 I j Re~ ide~!~a.IJ~!!e.I:I~~!olY_~}'nc:;om P~!1~l1ts Clearwater Gas System Un..un .~=~I.... I I .. .. .... ._ ComDonentsIThenn.. Contract ... .~...5!8~. .~u~ n _.... - .:.: $0.100 $ .....$_... .tt:()3Q. $__O'llElO $ ~~':':o~iO() $. $ $ 1.030 $ 0.960 .~ .:.:. ..: - j~~~~: ~ : f..:{{~l ~F}~~~ ~ -- ..... $ 0.130 I $. $ 0.010 $ 1.110 $ 1.040 $ .. ..... - n - nJ~~~~ ~.~:~~~. ~~~g {Em II~~ ~ .... 1...- .. t $ ()J30pO.();!() ..$.. .~.-... _$...!,Q.6(). _$_O,~O .$ ~.n ..... -. --. tg:.~~J:~]~g.t :_H~~ :tJ:: ~ -. -I :g:}:.}g:g~g l: ~H~~ ~.Hk~ ~ $ 0.122 $ 0.012 $ 0.004 $1.085 $ 1.015 $ $ 0.123 $ $. $ 0.949 $ 0.879 $ . ..... $ 0.120$ 0.(J;!0$U:.4'7Cl... $__1.~9() ._. $.0:120 $ 0.020.$... $ 1.470 $ 1.390 _ ..n jn_Q}~O$o.oio ~.. :$.L~ TTfso . .! 0.-1.:1.0$.0:020 .$ n .n. $ 1.540 $ 1.460 ...__ $ 0.160$Jl,Qiif $ .$1:470 $1.390 ._ .. $nO.160 $ 0.010 $ ........... n[L4~~ f:T311(J: TO,17][$~0:;Ql~ }._:... U3~Q..LJ,;!r.0 .$0,120 !.(J,Ol.<>..$_~ $ 1.200 $ 1.120 $ O.lBO $ 0.010 $ ..$1.150 .$...1.070 n_-:~_..$-C:l.:2Oif .$0.010.~':': .:..~:.. n.12(l $ ..1:040 _. ___ .1.Q,2~ $_0.01.0 $_ :.. :fiO!Q _~'-nQ.,!l.90. $ 0.200 $ 0.010 $. $ 1.070 $ 0.990 $ 0.160 $ 0.013 $. $1.327 $ 1.247 $ 0.127 $ 0.017 $ 0.004 $ 1.198 $ 1.125 CSW:07/1412..008 I I. ..L I I j. I. Total Rate . .....M.2!!!!!. NG/thenn LP/aallon. 1-.-.--- __.Q~~Q4 ~ ___.!~!_:t9 ~,~-~:!!~9._ Nov-04 $.1.7,,!,Q $ 2.030 . m Dec.04 .$ ....1~~0 J:::i.O@' _Jan~Oi ~.1J~~ $ ..2.090 Feb-05 ~._1..-!1~ $ 2.150 Mar-05 $ 1.860 $ 2.180 . ._~r:Q~ ) _:TB60 .L:z;i!lQ May-05 $1.790 $2.190 ,..n._~~Jui~ft+~:g {~jl~} ..... ...n_~uiCQ5$ __1'1l:!.Q.. L.2.220 ........... Sep-05 $ 1.970 $ 2.300 FY 04105 Ava. I $ 1.803 $ 2.162 2004 Avg. '$ 1.652 $ 1.968 .. ... .n .._..nQct~O~.!.. 2.190 _L ..1:.5.:30 _ -e .._ NO\i:Q5 _$. .2.:1llCl~. _2...53Cl.f-. ... .._ Dee-05 $ 2.260 $ 2.490 .-..- -"_. Jan~9~ -~~ ---- -2~2"66- -S--- -2.490 Feb-06 $ n..2.i20 f..2.460 _... Mar.06.$-.Ti2-6 $-2.460 - _..-_~1~ fJ~~~ f]~ Jun-06 $ 1.920 $ 2.420 u..-."JUj:"oe TDi10 T.. 2.500 -- --- ~~~.: P..~9.:l!S _L=(~ . L.-2,~QO_ ... n_ _ Sep-06 $ 1.860 $ 2.600 FY 05/06 Ava. $ 2.080 $ 2.480 2005 Ava. $ 1.925 $ 2.278 .-. . ....-- -..- - .. ...... .... + ...... .._- ... --. __Oclil.!i$_.l.~ $ 2.600 ....._~~~~ ~+~*~~'-:I;l~:: .._ _.J~n~Qt I~L94.Q .L.~6QO_'-. . .~ - - ._. ... ... .F~~:0'71-~ . ~'lliQ. $ 2.800 ... _. .0_ Mar-07 $ 1.940 $...."2.600 .:_:.:t.P~ =f:..l.!j"fLT=I:~. .. ..u.n ..-.-- _.nJII'~7 .$ l~~__n40n __ ._on _.__ ~ L.J.,920 L..1JJO ... . __ Imn_.Jul-Q7 ~__ ~~$_.1,99(J.I.n ,__ .._ . ._.~uiCQ7 1 _"1JI~~_ L 2.990_ Sep.()7 $ 1.B90 $ 2.990 FY 06/07 AV!l. $ 1.918 $ 2.742 I 2006 Avo. $ 2.012 $ 2.501 I -- -- -_. S 0.180 --,----.--- $-O:''[W ..u_. nfo.lea - --'-- $-6-.-180 u___ .-. -$ O~80 --- $0.180 ------ $ o~86 _=: l]l.lilQ: _. .. $_.9...180 $ 0.180 ---. $0.1-80 .._nn $0.180 $ 0.180 $ 0.175 --...- .- .-- I -OCt.07L_i84.Q: c:~,~+u .-f.~ .-__ :un Nov-:Q7 $_ .1.840.L_}.170 ._ __ _ u.:~~;J } +~-t---N~ 1-.- Feb-08 $ 1.840 $---- 3~1iO "---- .- t-- --- . -:~~j~Lf: ~::~~FIff~.=.-onn~u._ ....M.ay.:!l~ Ll.cBllCJ..~.~!.20 .0_ ..._-!i!.n::<JB $.......1,9..llCl..$~,15(J_ ....... ...}~I:()~ !.. ....2.2~Q.. L._~2~Q. m ..~B ..L.._.2.,!.2CJ.. L..3~44() _ _ __ _ un Sep-08 FY 07/08 Ava. $ 1.915 $ 3.168 2008 AV!l. '$ 1.893 $ 2.869 .= u~= . t.9~ 18Q $ O.lBO -- . $0.180 -- -f-0.180 t- ~---- .~~~-~~- - n- _u~ 119 -- - -~(),!~- non .0_ $. O~!~Q __$(),l!9.Q $ 0.070 =_~ .. _= ~. O:1!iQ. _ n_._ $. (J,! 2<1. - I mOO __.. .... ..___ __ _._ ... $. $ 1.170 $ 1.090 $ $. --.:: s-Ii7() ~=.1."090=.$ ...:: $. :n. $ 1.170 $ 1.090 $_ $ .$1.170 $-1".090 $_ n$ .... _ TUJo. r.[@O $ .r:: . $.1.17(). .$._1-,-090$ $ 0.030 $ 1.150 $ 1.070 $. I"(),()~~ $.l.l~+LI.O!C) $. $ClcQ.39 . c.!.1.1~_ L_1..0~_ $ lm..$.1~~0 L1:!l.QO _$_ $___ . ..$_!,O~~ ~_n1,()00 ~ $. $ 1.130 $ 1.050 $ $ 0.008 $1.145 $ 1.065 $ $ $ 1.246 $ 1.166 $ $ 0.010 n:010 $o:Oio [Q,O!Q $ 0.010 $ 0~16 $-.- $n.. $. .- $ . $ . $ . $ 0.005 $ 0.011 $ . ..... $ -~. ...Sn 1.0BO f.j,o(JO$ $ . $".:.:- :Eil.89 $ 1.000 $ $ - $. $1.080 $l~()o T ~.. .:- I:~==J~~ 1@ { $. $ 0.030 $ 1.050 $ 0.970 $ I:.: .. j}l:g]iL ffosc) .f.. CJ.,s.70 J t.:...!..0...Cl..~.$.1.1BQ. ~.1.100$ .t: :H~~H~}~~ .tll~~ f-t ~.. $.~_!.1.,4:!.Q....$ ..1:340$ ...-... . $ 0.148 $. $ 0.014 $1.173 $ 1.093 $ $ 0.180 $ 0.003 $ 0.008 $ 1.123 $ 1.043 $ .- .. .. Incr:.. Above u $ Last Year salii~Moril~ 15% .. ... - ... .. ...... .... . $ (0.060) $ 0.280 ~. 0.,450 15:%. InE-,_~jse(j~n$ _. 5~~ T _ 9.84 ~n.2.o Th'<>r1Tls ..13.'k n 1{% ... E~le"!.. Cents/KWH foi.Gas_:: ... . 7.2 12.8 -33% .. . ... .... t --- ...- .-. ...... -.. ..--. -....m iys. "PC Rat8 t 11.7,.. 11.7 Note: Thi~s Progress Energy's-residential rate in 112008 for usage >l.OOO~. (R~~i(le~al) .... I .:. . n - 1 -] -. 1- - T 1 . ! . <c.. a,u", -- I I I I j :~~_-"~i:~~:~Z,,,.;:,~&~~.d<,~i ' . ...i... . ~::;."" :lc'-,,~~! ~...l":..~~~"t-~tJ'oo..~'::!~~,pl'mRWo[~ I Attachment #7 ..... .bE PGA/aallon 1.130 1.130 1,190 1.190 1.210 1.210 1.210 1.140 1,140 1.140 1.160 1.240 1.174 1.046 ~. .~ $ ~ $ $ $ $ $. $- $ $... $ $ 1.490 1.490 1.450 1.450 1.390 1.390 1.240 1.2BO 1.,330 1.3110 1.490 1.490 1.407 1.256 Hl0 1.510 1.510 ):5.19 1.510 1.510 ... 1.All.0 ..16:30 ..1,880_ 1.910 1.910 1.910 1.649 1.415 .1..91<l 2.090 2.090 nZ,OllO 2.090 2.040 2:040 2.100 2.150 2.150 - '2'~420- 2.106 1.779 0.510 27% .. u. ....