Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE OCTOBER 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; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Tom Madley, Sr. Accountant/CCS; Laura Damico, Sr. Accountant/CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE OCTOBER 2008 DATE: September 19, 2008 This is the time of year when we project the required levels for all our adjustment clauses based on the forward price curve and our FY 08/09 budget projections. Natural Gas markets remain high historically, but have been moderating somewhat recently. Therefore, we are recommending that we decrease our Natural Gas Purchased Gas Adjustments (PGA) by 15C/therm and decrease our LP PGA by 6C/gallon. We will closely monitor our actual gas supply costs and propose changes if we see the near-term costs begin to rise. This recommendation is also more in line with the actions of the other utilities in the region. We are also recommending an increase in our Energy Conservation Adjustment (ECA) by 2C/therm or gallon, but we are not recommending any changes in our Environmental Imposition Adjustment (EIA) nor our Weather Normalization Adjustment (WNA) clauses at this time. The net effect of these recommended changes is a 13C/therm decrease (-6.1 %) in our typical Residential Natural Gas customer's rate and a 4C/gallon (-1.2%) 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 October 1, 2008: Natural Gas Firm Standard Rate Schedule PGA ....... $1.27 pertherm (down 15C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $1.19 per therm (down 15 C/therm) Propane (LP) Gas Rate Schedule PGA .................... $2.26 per gallon (down 6C/gallon) Energy Conservation Adjustment (ECA) ............... $0.14 per therm or gallon (up 2C) Environmental Imposition Adjustment (EIA) ......... $0.00 per therm or gallon (no change) Weather Normalization Adjustment (WNA) .......... $0.00 per therm or gallon (no change) William B. Horne II, City Manager Page 2 September 19, 2008 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru August and projections thru Period 13 of this 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. Attachment #5 shows our projections for ECA and EIA requirements. Attachments #6 and #7 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #8 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 43% lower than electric for Natural Gas and competitive for LP. It should be pointed out that Progress Energy Florida has announced that they are seeking a 31 % increase in rates to be implemented January 1 st 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 17.6% higher than last Fall vs. the 31 % that they are proposing. It is our plan to use the above-proposed adjustments for billings through September 30, 2009, 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 October 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments , I A d 9;;, . Ii; . 'D l' ! --- pprove: / f ,{...0,)~t.AI\.~ f) .~i:.L-tA..,> _[1. William B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRA TES\Gas Adjustments for October 2008.doc CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 NATURAL GAS PURCHASEDGAS ADJUSTMENT(PGA-NGI Attachment #1 Page 1 of 3 Monthly Cumulative NG PGA Budg~ Reservat~<l.~_____._~_ Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm Month C ~-"r_g~s__~__ Charges Expense Expenses Expenses Billed (Shortag~) (Shortage) Firm/Contr Prior Year! $ 45,593.93 Oct-D7 [$ 2,995,90..7.81 :-$ 986,429.0.7 $ $ 31,242.98 '$ 4,0.13,579.86 ' $ 2,30.6,584.81 '$ (1,70.6,995.0.5) $ (1,661,40.1.12) 1.0.8/1.0.0. Nov-D7 :$ 162,347.55..1.___ 1,119,20.2.77 $ _8,30.7.0.1 '$ 41,10.4.95 $ 1,330.,962.28 $ 1,542,587.20. '$ 211,624.92 $ (1,449,776.20.) 1.0.8/1.0.0. Dec-D7 $ 15D,733~.L______. 1,40.2,134.0.3 LL_ 7,248.88 $ 56,275.23 $ 1,616,391.69 $ 1,986,985.55 $ 370.,593.86 $ (1,0.79,182.34) 1.0.8/1.0.0. _Jan-DB:_--$ 134,27?12. .1.___..__.____. 1 ,70.5,922:<17 $ 5,395.91 $ 40.,794.65 $ 1 ,886,385.20. . $ 1 ,931,339.18 '$ 44,953.98 $ (1,0.34,.228.36) : 1.0.8/1.0.0. _feb-D8 ~_L_:1_5.<1.239D $ ___..J.....6..2Q. 686. 97 _..~. 5,171.14 : $ 39,591.14 $ 1,820.,373.15 ...L...b.! 0.4,653.65 i$ 284,280..50. $ (749,947.86) 1.0.8/1.0.0. ------~_._--- Mar-D8 $ 166,0.4112 $ 1,588,366.40. $ 3,749.74 $ 40.,457.54 $ 1,798,614.80. $ 1,910.,479.0.0. '$ 111,864.20. $ (638,0.83.66) 1;0510:97 -----_._._-~ _!\er -D8___..t.__1.o8,154.4 7..1__.__~____ 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.0.5/0..97 May-D8 $ ._ 82,238.6Q_ $ 1,747,270..88 $ 3,312.29 $ 46,777.80. .$ 1,879,599.57 $ 1,853,0.54.0.5 $ (26,545.52) $ (689,0.0.2.89) L18/1'.1D Jun-D8 _...1_ 79,6~~.1<1...~____.____. 1,60.3,199.36 $ 3,445.0.1 $ 73,0.92.95 $ 1,759,382.56 $ 1,813,218.20. . $ 53,835.64 $ (635,167.26) 1':31/1:23 Jul-D8 $ ___zg,&}8.90, $ ..,-.------- 1,628,991.95. $ 3,175.84 $ 39,0.96.14 $ 1,750.,882.83 $ 1,849,718.30. $ 98,835.4 7 $ (536,331.79) 1149/1.41 Aug-D8 $ 69,598.Q}_l_ _____________~ 155.66.._ $ 2,681.66 $ 67,0.16.19 $ 1,617,451.54 $ 1,785,383.26 $ 167,931.72 $ (368,40.0..0.6) 1,4211;34 Sep-D8 $ 82,DDD-,-D.Q._L_ ...........1...5_0.0.-'.00.0.0.0. $ 1,842.0.0. $ 40.,0.0.0..0.0. $ 1,623,842.0.0. $ 1,869,30.0..0.0. $ 245,458.0.0. $ (122,942.0.6) 1.42/1.34 -----..- Per13 $ 160.,764.95 $ $ $ 5 .$ 160.,764.95 $ $ (160.,764.95) $ (283,70.7.0.1) Total YTD $ 4,426,446.29 ..$__~______.______~___._ 18,20.2,233.17 $ 47,519.89 $ 550.,792.25 $ 23,226,991.60. $ 22,897,690..66 $ (329,30.0..94) . (1) i Includes annual charge for Admin of $648,160. + Annual CCS chg of $959,620. + Dividend $1,276,40.0. + FYQ&/()? PG6.\~i[~oKo!j28,2yi~51-+ WNAS135:64 =-.. '-$-2:912,59315' Note: Billed includes Deferred Revs!e~(;()tp..of~_913.s285.39 ~_~_.. (2) ___ Net RC = . $ 1 ,353,Q~8..:11___n PROPANE (LPI GAS PURCHASED GAS ADJUSTMENT (PGA-LPl ..J3udg.El.t..._ Month Prior Year Oct-D7 Nov-D7 Dec-D7 Jan-D8 Feb-D8 Mar-D8 Apr-D8 May-D8 Jun-D8 Jul-.o8 Aug-D8 _ Sep-D8_ Per13 Total YTD (5) Commodity adjustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Rate NG Proportion = 97.78% x Total ECA Transfer = $ 17D,878.5~_ + Transfer of WNA to PGA = $ (10.,113.58) Gallons Sold Monthly WACOG ________~_'nte~e_sL_____g()mmodity Total LP Fuel Total LP PGA ____E~ens~..__ nf.I1-".r:.I!.~...~ __~-"{lElnse!;_______!3illed 3~,522..!l._$______ _.____________ 33,0.56.8 $ 38,4~?,D__l_ 58,~78.:.<I....~_.... 53,D23.9._~_______._ 44,360..6 $ 56,0.0.3.9 $ 39,0.23.6 $ 28,774..2 $ 29,347.8~_ 25,1~1.D . $_________ 37,0.0.0..0. $ .1.38433.._$ 188.92 $ 1.5330.9 $ _____ 937.0.2. $ 1.60.329 . $ 854.16 $ 1.65887 . $ 763.79$ 1.64212 $ 640..93 $ 1.64377 : $ 525.0.4 . $ 1.62757 $ 437.0.6 , $ 1.71081 . $ 323.56 : $ 1.77663 $ 252.16 $ 1.87869 $ 20.1.0.1 i $ 1.87639L__!6191 $ 1.880.0.0. $ 99.99 $ 5,385.55 $ 479,0.0.0..0. . $ ______________.__ 1.67:1.14 $ 'Cost Center Expenses CCS Chg -l-__AdminChg + Dividend FY 0.6/0.7 Write off PGA & WNA Fuel --- PC AnyWhere($159)~f10Iding Tank Restoration ($13,20.9.60.) LP Yard Vaporization LP PGA Event fuel cost . DepreCiation_Of LE_ Tanks Suburban Software Systems Suburban Software Systems License Welle Fargo Insurance invoice #637545 59,559.61 $ 50.,679.0.5 $ 61,70.5.82 $ 96,676.29 $ 87,0.71.61 $ 72,918.62 . $ 91,150..27 $ 66,761.97 $ 51,121.11 : $ 55,135.42 . $ 47,136.79 '$ 69,560..0.0. $ 4 $ 80.0.,476.55 $ 88,530..0.0. 1,136.69 15,0.0.0..0.0. 13,368.60. 4,843.93 . 5,826.10. 34,414.23 1,250..0.0. 569.70. 3,787.50. 219,475.28 51,616.0.7 62,559.98 97,440..0.8 87,712.54 73,443.66 91,587.32 67,085.53 51,373.27 55,336.43 47,298.70. 69,659.99 3,879.63 978,468.48 $ S S $ $ $ $ $ $ ,$ . $ $ ,$ '$ 69,856.53 $ 68,188.12 $ 80.,633.0.3 $ 122,0.12.14 $ 110.,891.59 $ 91,0.39.92 . $ 114,285.55 , $ 81,365.43 $ 61,60.4.37 $ 63,157.13 ' $ 59,681.0.4 $ 84,123.20. $ $ $ ~L_____ 1,0.0.6,838.0.5 Monthly Overage (Shortag~J . (1<19,618.75) 16,572.0.5 18,0.73.0.5 24,572.0.6 23,179.0.5 17,596.26 22,698.23 14,279.90. 10.,231.10. 7,820..70. 12,382.34 14,463.21 (3,879.63) 28,369.57 $ $ $ $ $ $ '$ $ $ $ $ $ $ S Cumulative '(TD Overage (Shortage) (37,784.74) (187,40.3.49) (170.,831.44) (152,758.39) (128,186.33) (10.5,0.0.7.28) (87,411.0.2) (64,712.79) . (50.,432.89) . (40.,20.1.79) (32,381.0.9) (19,998.75) (5,535.54) ..... (9,415.17) LP PGA Therm/Gal. 1.75/1.91 1.9112,0.9 1.91/2.0.9 1.91/2.0.9 1.91/2.0.9 1:87/2,0.4 1.87/2.0.4 1..921.?JO 1.97/2;15 1.97/2.15 2.21/2,42 2.12/2.32 - - (4)_. Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate LP Proportion - 2.22% x Total ECA Transfer - $_____.J,~79.63_ . + Total Cost Cntr Exp. $ 168,726.75 $ Proj. Adders 175,0.0.0..0.0. $ Allow for 6,273.25 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 ENE;RGY cONSgRVATIONADJUSTMENT (ECA) Budget Month Prior Year Oct-07 Nov-07 Dec-07 Jan-08 ------~- Feb-~L~43,992.3~. Promo$75,046,Adv $180, Employ Costs$68,766 _Mar-08 _~_,cl~J99.60 Promo$27,988,Adv $1,590, Employ Costs$56,222 Apr-08._ $ 87,873.23 ,Promo$39, 190,Adv $3,310, Employ Costs$45,373 !0ay-08 $ 359,240.59 Promo$20,447,Adv $1,953, Employ Costs$55,692 Jun-08 $ 70,347.34 :promo$38,463,Adv $2,270, Employ_ Costs$29,614 Jul-08 $ 81,239.18 Promo$33,906,Adv$1 ,375, Empc;osts$45,958.18 Aug-08 $ 71 ,013.~1L Promo$2S,34S,Adv $3,595, Employ Costs$42,073 Sep-08 : $ 90,000.00 Per13 Total YTD $ 1,560,329.28 Cost Center Expenses , Notes/Exceptionallterns $ $ $ $ --~-- $ .$ :$ :$ $ $ $ $ Interest Expense 1,032.85 ' 904.37 511.37 1 $ $ $ $ $ $ $ 2 $ .-- _____J $ $ $ 6 $ $ $ 318,454.23' Promo$36,720,Adv $0, Employ Costs$57, 160 $ 95,913.73 Promo$26,790,Adv $1,730, Employ Costs$67,394 $ 76,495.95 ,Promo$23,405,Adv $1 ,025, Employ Costs$22,066 $ .---.!9,9~91Q._: Promo$24,930,Adv $230, Employ Costs$54,800 695.28 822.12 782.22 788.73 5,536.93 ----.----- (1) ,Includesannual ch<lrg.eforhdrnin Chg of $3il,?~0.:_~g~chg of $69,670 + Dividend of $111 ,680+ FY 06/07 Write off of $4,464.66 = . $ 224,574.66 (2)' FY 07 108 ~_O.'{'J~i~e_ Off adjustment = ___~.~_.___.__._._____.$ 281,148.85 (3) Netg,C.~=_,j,__1 ,054,605.77 ENVIRONMENTAL IMPOSITION ADJUSTMENT (ErA) __ Budget Month Prior Year .. Oct-07 ,$ Nov-07 $ Dec-07 $ Jan-08 $ Feb-08 ,$ Mar-08 $ Apr-08 $ .. May-08 $ Jun-08 $ Jul-08 $ Aug-08 $ Sep-08 $ Per 13 $ Total YTD $ Cost Center ---""---.--,--..--..--- ....- .-..-..---.-.-.--..- EXpenses Notes/Exceptionallterns 14,182.79 1,427.00 2,909.~Q__ 4,529.35 1,427.00 2,799.00 1,427.00 8,742.93 6,299.19 23,060.45 4,282.92 10,000.00 Total ECA Expenses 318,454.23 : $ 96,946.58 $ 77,400.32 . $ .___~Q.,'E.!:()L; $ 143,992.35 $ 85,799.60 $ 87,873.23 $ 359,240.59 ; $ 71,042.62 : $ 82,061.30 $ 71,795.60 $ 90,788.73 $ - $ 1,565,866.21 $ Total ECA Billed 111,884.77 : $ 122,642.60 $ 156.000.42 $ 188,214.03 $ 184,801.05 $ 141,996.29 $ 135,572.31 $ 70,010.94 $ 45,674.19 $ 90,040.34 . $ _ 70,495.11 $ 73,776.00 $ 174,758.16 $ 1,565,866.21 $ Monthly Over<lg.~___. (Shortage) , ---- $ (206,569.46)' $ 25,696.02 . $ 78,600.10 $ 107,742.96 $ 40,808.70 $ 56, 196.69.~ 47.699.08 $ (289,229.65): $ (25,368.43)' $ 7,979.04 $ (1,300.49)' $ (17,012.73) $ 174,758.16 $ Attachment #1 Page 2 of 3 Curnulative YTD Overage · (Shortage) (206,569.46) (180,873.44) (1Q.?,P333)' 5,469.63 _.__46,278.33 1 02,475.02 150,174.10 . (139,055.55) (164,423.98) (156,444.94) (157,745.43) ._ (174,758.16) - . : ECA NGlTherrn LP/Gal. 0.18/0.18 0.18/0.18 0.18/0.18 0.18/0.18 0.18/0.18 0:15/0;15 . .... 0.15/0.15 g.09/0,09 ....... . ~;0710.0T .............. 0;15/0:15 ,'0; 12/0}12 0.12/0.12 (6) -- Transfer of ECA Collected in PGA @ 1/2 of the ECA Rate (up'toECA Annual Shortfall) -'---~.' Note: Maximum amoun,t whiS;h ca!l__be transferre.ci--':'-~=--T- 695,554.03 ___ _______n____ ------- - -------------- -- __u_.___. Monthly Cumulative EIA -- -.----.--- ~ Total EIA Total EIA Overage YTD Overage NG/Therm Expenses Billed (Shortage) (Shortage) LP/Gal. -. -_.._-_.-----'----~, $ 113,277.52 14,182.79, $ (0.21) $ (14,183.00) $ 99,094.52 0.0010.00 1,427.00 $ 95,999.86 $ 94,572.86 $ 193,6}J7.38 0.0010.00 2,909.70 $ (0.03) $ (2,909.73). $ 190,757.65 0.0010.00 4,529.35 $ (0.76) $ (4,530.11) $ 186,227.54 0.0010.00 1,427.00 $ (0.39)' $ (1,427.39) $ 184,800.15 0.0010.00 2,799.00 $ (2.48) $ (2,801.48) $ 181,998.67 0.0010.00 1,427.00 $ 0.03 $ (1,426.97) $ 180,571.70 0.00/0.00 .- 8,742.93 $ - $ (8,742.93) $ 171,828.77 0.00/0.00 -.---- 6,299.19 $ - $ (6,299.19) $ 165,529.58 0.00/0.00 23,060.45 . $ (0.47), $ (23,060.92) $ 142,468.66 0.00/0.00 4,282.92 $ - s (4,282.fl.~.L $ 138,185.74 0.00/0.00 10,000.00 $ - $ !lQ.SJOO.OO) . $ 128,185.74 0.00/0.00 - $ - $ - $ 128,185.74 81,087.33 $ 95,995.55 $ 1~,908.22 -- Interest Expense $ $ $ :$ .$ $ '$ ___.1___ $ .______. ______.__J..______ _______ _._n _ ______..1._ $ $ $ 81,087.33 (1) . Includes annual charges for Admin Charge $10,300 + FY 06/07 write off of $184.79 = (2)j Bilied includes $96,000 of MGP Insurance Claim Recovery Net CCE-, $ . : 70,602.54 ----~----------.. . 1 2 $ 10,484.79 $ $ $ $ $ .$ $ $ .$ .$ $ $ $ $ CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Budget Month Prior Year Oct-07 Nov-07 , Dec-07 Jan-08 Feb-08 Mar-08 . Apr-68".------~.-~==~==~__ ~i~Q~____ Jun-08 Jul-08 Aug-08 . Sep-08 Per13 Total YTD -,- Total of All Additional Expenses Recovered Thru Adjust.menJJ::J<lLJ.ses = $ 3,597,528.20' WEATHER NORMALIZATION (WNA) Budg.!!!. Month ~El.\L_I3~____ Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 _Sep-08 _.m_n_ Per13 Total YTD Interest "------------.-.... _. n_________n_ . _....______!:-.f'.. Gallo~______I:..x.Jl..e_~_e Total All Expenses ,$ 4,565,692.16 ; $ 1,480,951.92 ' 1,759,261.69 · 2,068,825.70 ' 2,053,505.04 1,960,657.06 : 2,149,648.73 2,314,668.62 1,888,097.64 1,911,341.00 ' 1,740,828.76 . 1,794,290.72 164,644.58 25,852,413.63 i $ $ Total Recovery Billed 2,488,325.90 1,829,417.78 2,223,618.97 2,241,564.59 2,400,345.90 2,143,512.73 2,194,245.35 2,004,430.42 1,920,496.76 2,002,915.30 1,915,559.41 2,027,199.20 174,758.16 25,566,390.47 Monthly Overage (ShortagElL , $ $ $ (2,077,366.26) $ $ 348,465.86 $ $ 464,357.28 $ $ 172,738.89 $ $ 346,840.86 $ . $ 182,855.67 $ . $ 44,596.62 $ i $ (3) 0,238.20) $ . $ 32,399.12 ! $ $ 91,574.30 . $ $ 174,730.65 $ . $ 232,908.48 $ $ 10,113.58' $ $ (286,023.16) -, '---__________ . __n____ _ ,., ...,.. __.!<1011tl1lY.__. .__.______.____.___.___..Q.verag_~ . Rate!Gal~_____.__NG..Jherms _~~Therm ____~h_o..rtag.E!L__ 36,522.8' $ __.____n_______ .________nn _._n_____~056.L$______ 38,487.0 . $ 58,278.4 $ 53,023.9 $ 44,360.6 . $ 56,003.9 : $ 39,023.6 i $ 28,774.2 ' $ 29,347.8 $ 25,121.0' $ nmn____.__n____ 37,000.0 . $ ____'479,000.0 --------- (1 ) Transfer of WNA FYE balance to NG PGA 1-,~MiOJ__ 1,612,140.2 1,920,988.7 2,051,577.7. 2,148,022.9 1,972,879.1 2,007,186.6 . 1,749,356.1 1,562,509.3 i 1,437,905.8 1,432,784.8 1,500,000.0 . 0.03 0.03 0.03 0.03 0.03 . 20,791,791.4 ~_n______ $ $ (9.80) $ _____L...__ (0.16) $ $ (2.21) $ $ 0.28) $ _n__ . $ (0.79) $ ____~Q? $ 59,755.25. $ 0.03 $ 61,946.79 ' $ 0.03 $ 53,666.69 $ 0.03 i $ 47,757.94 . $ O.Q~ 44,004.52 $ . $ 370.63 . $ _____J.____.J. S $ S Attachment #1 Page 3 of 3 Cumulative YTD Overage (Shortage) 121,086.71 (1,956,279.55) (:1,607,813.69) (1,143,456.41) _\970,717.52) I (623,876.66) (441,020.99) (396,424.37) (706,662.56) (674,263.45) (582,689.15) (407,958.50) (175,050.03) , (164,936.45) Cumulative YTD Overage (Shortage) (257,374.00) (257,383.80) (257,383.96) (257,386.17) (257,387.45) . (257,388.24) (197,632.99) (135,686.20) (82,019.51 ) (34,261.57) 9,742.95 10,113.58 10,113.58 Total NG/Therm-Firm LP/Gallon 1.26/2.09 12612:27 1.26/2.27 1.26/2.27 1.26/2.27 1..20/2[19 1.2012.19 1;27/2;19. .....1;38/2;22 1G64f2.30 L5412;54 tG54/2A4 WNA NG/Therm LP/Gallon 0.00/0.00 0.00/0.00 0.00/0.00 0.00/0.00 0.00/0.00 0:03/0.03 0.03/0.03 0.03/0.03 0.03/0.03 0.03/0.03 OtOOIO.OO 0.00/0.00 Last U dated:09/16/2008 CGS Natural Gas Cost Actual/Projections FY09 l~- c J~' as of 9/1 0/2008 Ocl-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 J"I-09 AU9-09 Sep-09 r- Contract Capacity Capacily Relinquishment I I Contract Excess Purchased Sold Gas Sold Gas Purchased % Sold Gas WACOG FTS-1 FTS-2 No-Notice Capacity Volume Cost I Gas Aclual Pro"ected Gas losl vs. Proiected Purchased 1 170,438 41,788 15,500 52,226 30,000 $ 12,000.00 160,000 149,000 100.00% 0.0% 5 8.46 i 306,570 53.430 22,500 147,000 30,000 $ 6,000.00 213,000 167,000 5 8.47 316,789 55,211 31,000 143,000 50,000 5 10,000.00 229,000 I 213,000 5 8.60 316,789 55,211 46,500 141,000 50,000 5 7,500.00 231,000 , 229,000 , i 5 8.63 286,132 49,868 42,000 121,000 50,000 $ 7,500.00 215,000 I 231.000 , i$ 8.72 316,789 55,211 31,000, 172,000 50,000 $ 7,500.00 200,000 215,000 $ 8.58 216,570 53,430 22,500' 92,000 50,000 5 15,000.00 178,000 I 200,000 $ 8.35 i t- 41,788 12,400' 27,000 30,000 $ 12,000.00 159,000 I 178,000 ' 5 8.15 I ~~~H'''' 139,560 40,440 10,500 27,000 30,000 $ 12,000.00 153,000 I 159,000 S 8.21 _ 144,212 41,788 10,850 33,000 30,000 5 12,000.00 153,000 153,000 1$ 8.26 144,212 41,788 10,850 33,000 30,000 5 12,000.00 153,000 I 153,000 '5 8.59 __ 139.560 40,440' 10.500 24,000 30,000 5 12,000.00 156,000 153,000 $ 8.66 Total 2,641.833 570,393 266,100 1,012,226 (460,000) (5125,500.00) 2,200,000 o 2,200,000 100.00% 0.0% 58.49 Oel-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 i Reservation ctlarges i FTS-1 FTS-1 FTS-2 I FGU Load Load Total I I , FTS-1 ~ FTS-2 No-Notice charges Usage Charge Usage Charge Total Montr,ly Fuel Cost Management fee Factor Factor Billing ! , (phase II) I NNTS (ohase ill (ohase 111\- Commodity charaes Adiuslments (Fuel Relention\ Per Month wi Relinoulsh wlo Relinouish (FGU+Peo les\ 1 (ahase 1111 , i 1$ 69.112.61 5 32,134.97 ' $ 767.25 5 2,364.24 $ 417.88 $ 1,262,79998 5 $ 43,708.63 $ 8,000.00 87.8%: 75.4% $ 1,352,814.81 I ~ ,,,,,,,, , 41,087.67 $ 1,113.75 5 3,191.40 $ 534.30 $ 1 ,643,672.19 $ 5 56,876.28 S 10,650.00 64.5%; 59.2% $ 1,804,187.75 $ 128,457.94 5 42,457.26 $ 1,534.50 S 3,475.78 $ 552.11 $ 1.806,056.96 5 $ 62,509.97 5 11,450.00 71.1%1 61.6% $ 1,968,506.66 $ 128,457.94 5 42,457.26 S 2,301.75 5 3,515.78 $ 552.11 $ 1 828,101.40 $ 5 63,275.22 S 11,550.00 71.7% 62.1% 5 1,993,818.35 $ 116,02653 $ 38,348.49 5 2,079.00 5 3,302.64 $ 498.68 $ 1,725,623.13 $ i5 59,737,01 $ 10,750.00 75.2%1 64.0% 5 1,874,577 .15 $ _. 128,457.94 5 42457.26 5 1,534.50 S 2,895.78 $ 552.11 $ 1,550,576.13 $ '5 53,659.49 S 10,000.00 62.1% 53.8% 5 1,715,525.83 $ 87.819.14 5 41 087.67 $ 1,113.75 $ 2,491.40 $ 534.30 $ 1,371,750.91 $ S 47,469.28 5 8,900.00 80.9%1 65.9% 5 1,486,771.47 $ _ 58,477.97 5 32,134.97 5 613.80 5 2,344.24 $ 417.88 $ 1216,939.36 $ $ 42,106.65 $ 7,950.00 101.9% 85.5% 5 1,296,166.10 $ 56,591.58 5 31,098.36 5 519.75 5 2,251.20 $ 404.40 $ 1,180,001.43 $ S 40,832.25 5 7,650.00 102.0% 85.0% 5 1,256,211.12 ~__ 58,477.97 5 32,134.97 5 537,08 $ 2,224.24 $ 417.88 $ 1,184,707.15 $ 5 40,997.43 $ 7,650.00 98.1% 82.3% 5 1,263,857.17 5 58,477.97 $ 32,134.97 $ 537.08 5 2,224.24 $ 417.88 5 1,234,603.63 5 5 42,743.80 5 7,650.00 . 98.1% 82.3% $ 1,313,753.65 $_ ..___5.6~59158~_ 31,098.36 5 .. 519.75 $ 2,31120 5 404.40 5 1,275,446,76 5 5 44,163.39 5 7,80000 104.0% 86.7% $ 1,351,656.45 Tol<11 51,071,263.28 5438.632.22 513,171.95 532,592.14 55,703.93 $17,280,279.03 $ 5598,079.40 5110,000.00 84.8% 72.0% 518,67l ,846.48 Total Projected DTH WACaO Totai Reservation Total Commodit Cost Purchased 1 5t 6 Montlls 5892,600.75 5 9,816,829.79 510,709,430.54 1,248,000 $8.581 I 2nd 6 Months $504,966.70 7,463,449.24 57,968,415.94 952,000 $8.370 I TOTAL 51,397,567.45 17,280,279.03 $18,677,846.48 2,200,000 $8.49 Propane Weighted Average Cost of Gas (WACOG) FY 2007-08 lq- ~ c J:i!~!.~ --rr---r-r-;:?--~-~- f~ j 1>, (... 9/15/2008 Sea.3 Propane Cost Shipping Cost Total Cost 09/30/07 -.---------.- ,10/10/07 ,Sea-3 ,4007-0778 _ ,92222, 92380 10/15/07 ~a~____~_O()7-079.6.___ 92336, 92286 ----;- ! 10/31/07 i MONTHLY INVENTQRY ADJUSTMENT ,10/31/07 END OF MONTH ____ _.__.______.~_.__,._________.______ _______M___ lYQ!j/O!___ Sea-3___..!0Q,7-0_861 _________~__9,7~___ 1.65996 $ ~11/13/07 __Sea:3 4007-0889 __________________:J'7.1~,,: 1,66011' $ ,11/30~L_MONTHL~-"'-ENT()_~,'t'ADJUSTMENT 318 '$ 11/30/07 END OF MONTH ' ------.----.------,------- 12/18/07 Sea-3 4007 -1005 -_.__.--_._----,-~.,_._.- 12/31/07 MONTHLY INVENTORY ADJUSTMENT 12/31/07 END O-F MON-TH------~--- ------- 01/24/08 'Sea-3 4008-0072 -----_.".---~.- :01/28/08 Sea-3___4()OB-OOB8 ! 0 1/31/08_",ONTH L1'l~\IE tfl'OR Y "OJ US TMENT :01/31/08 END OF MONTH ______L__________.-!__ :02/08/08 Sea-3 4008-0108 ------.---- 02/12/08 Sea-3 4008-0127 ..----..-..------.-- - --- -- . 02/29/08 MONTHLY INVENTORY ADJUSTMENT -- ----------------.~.----- 02/29/08 END OF MONTH ---- 03/12/08 Sea-3 4008-0208 ------- 03/31/08 MONTHLY INVENTORY ADJUSTMENT O~~/~_1/0~_____ E-ND~-_OF M~~_!_~_ .-"..-----.-~~~~'=_~~[-~ ..--- ------..-------- 04/09/08 Sea-3 4008-0288 ---- --- ----."-------...-.-------- ------ 04/30/08 MONTHLY INVENTORY ADJUSTMENT --.-..- -- ---.------_...---------_.._-.--- ----- 04/30/08 END OF MONTH ~--- 05/01/08 Sea-3 4008-0366 -- ...._-------. --------~--.._-- 05/31/08 MONTHLY INVENTORY ADJUSTMENT ,05/31/08 END OF MONTH - ---.---------- ,06/10/08 4008-0460 --------'...---------.- '06/30/08 MONTHLY INVENTORY ADJUSTMENT _._._-_._------.-_.,,-~.- 06/30/08 END OF MONTH 07/15/08 S-~-~3--= 400s:.0547 . __-=-=====-- '07/31/08 "f'rior -""-",11th Adjustment _______~__~ 07/31/08 MONTHLY INVENTORY ADJUSTMENT '07/31/08 END OF MONTH .----------.----... 08/13/08 Sea-3 4008-0615 .------.. 08/31/08 MONTHLY INVENTORY ADJUSTMENT ____w__. .____._._____.____..________... -----.--------.------~- 08/31/08 END OF MONTH 19,835 ' ___18,963 :_ 280 49,342 . 860 - ____j,.,_____.,:,c__ . 39,671 10,000 945 ' FYTD Totals _20,1QZ_ 19,140 371 48,316 296 48,504 243 38,894 1,084 . 47,702 1,028 29,669 : 18,800 185 _i 579 : $ 48,685.65 37,199 1.30879 19,835,0 $ 77,663.51 57,034 1.36171 38,798.0: $ 105,367,42 75,997 1.38647 : $ 105,592.84: 76,277_ 1.38433 i $ 51,144.22' 36,945 39,332 1.38433 48,542.0' $ 67,318.86 46,689 1.44186 85,914,0 : $ 129,360,67' 84,061 1.53889 $ 129,360.67 84,379_ 1.53309 m.___~~i $ 70,732.21 46,137 38,242 _ 1.533~ 1,279,76: $ 82,909,68! 135,256.0' $ 153,641,89 95,479 1.60917 $ 817.82 : $ 154,459,71, 96,339 1.60329 __~_ _~__i__ i $ 90,611.75 56,516 39,B23 1.60329 1,027.31 $ 68,339,87, 174,927.0 $ 158,951,62 96,187 1.65253 258,96 $ 17,226,66' 184,927,0 $ 176,178.28 106,187 1.65913 $ 1,539.32' $ 177,717,60' 107,132' 1.65887 I~" j $ 76,551.67 46,147 60,985 1.65887 520.68 $ 32,701,33 205,034.0' $ 109,253.00 66,254 1.64900 495.65 $ 31,128.65 224,174,0 : $ 140,381.65 85,394 1.64393 $ .. ..............454.76. . . ,1. 140,~__.e5,765 : 1.64212 _~_j_._~----"'____L__i-'-_____mLL~5,3?~.21_ ...33,723 52,042 1.64212 I8~12552 _~__ 1,296.42_~____~421,94__~3_.490~(J _$ 134,I99..!~ ____ 82,039 __ 1.64311 540.70 . $ ________-~--~Cl:ICJ.--_----..-- L 135,33~,8.5_ __J3~c~35 1.64377 __~_________________:______,_ ,t 53,473.50 ___ 32,531 49,804 1.64377 1.61382 ~_ ___Z6,95499_~___1,3:21~~,S._28_'~?6,62___:3.2..0.99~_'O__l.1:J.1...'7.~()'.11..____ _8~,035 ___ 1.62584 2.20280 ,$ 535.28 $ __ ,_$ 535.28______1.....:1]2,285,40______.81 ,278 . 1,62757 __.__"..____.___~_~_______'___~_m___ ; $ 41_,210.00 ____ 25,320 55,958 1.62757 1.78877 $ 68,492.33 $ 1,080,02 $ 69,572,3.5_____ 359,888'-O"_.L1_~0_"I82,35 64,214 1.72521 0.85815 $ 930,23: $ $ 930,23~~--,~~~-_- 65,298 1.71081 ___________~"'__~______m .__.:J...._52,6~~_ 30,BOO 34,498 1.71081 1.84633: $ 86,698,39. $ 1,375,19 $ 88,073,58__~07,590.0 $ 140,766_28.____78,502 __ 1.7931~ 0.51445 . $ 528,85 . $ $ 528,85___~_.1.._1.i.1.2f)_5.c43 79,530 1.77663 ___~__LL_~~~:63 51,562 27,968 1.77663 59,775.60 437,259,0 $1_5],_382.23___ 81,231 1.86360 1,010.93 $ 152,393,16 81,231 1.87605 1,302,09 $ 153,695,25' 81,810 1.87869 ,",_ ' $ , 95,397.76 50,779 . 31,031 1.87869 531.82 $ 34,980.94 456,059.0 $ 130,378,70 69,579 1.87382 $ 525,47 ____.J...J:J.9c904, 17 ____,,~9]64__ ___~, 1.87639 .m_____~.~~..~__~25!_.()1___ 46,556 23,208 __ 1.8763~_ YearEnd Totals 1,46095 , $ 1 ,46095 ~.! 0.80507 : $ 503.33 : $ 481.20: $ '$ 28,977,86 27,703.91 225,42 ! 28,474,53 ' $ ?7,22V';' $ ~$ I 1 250.31 I $ 965.87 ! $ $ 16,174.641 62,041,81 : 15,924,33 $ 61,075,94 $, : $ 1,68031 ' $ 0.95095 : $ 81,629.92 . $ 817.82 $ 1.72267 : $ 1.72267 ' $ 1.62891 : $ 67,312.56 $ 16,967,70 $" 1 ,539.32 : $ I ! ..~-~-_._. 1.62637: $ 32,180,65 $ 1.62637 ,...L~~]3,00 .1__, 1.22577 $ 454.76 $ 1,64380 : $ 1,82669 ' $ 2.01475 $ N/A : $ 2.24886 I $ ! 58,916.70 $ 1,010.93, $ 1,302.09 : $ 858.90 . $ . $ $ 1.86069 ~_~4,449,12 J.___ 2.84038 $ 525,47 $ --~- ---r----- ----..-----.----.------...-.-----.-.. -------- --_.~----_._----~.._---------- - 456,059 . 1.70661 ----765,058 -$----12;"2--~----____na;31~---~ Propane FY 2009 Projections ,,-............- -. """ A "(') v~ ct~ IV} 6tJ I ~y ~~~-'-'._._"---- I~,- 2. pi z 9/15/2008 Delivered Delivered Delivered Cost Total Tank EOM Tank EOM Tank Projected NYMEX CGS Cost Gallons Cost of Inventory Gallons Withdrawl Gallons Cost WACOG Aug-08 46,556 $ 87,357.00 1.88 Sep-08 1.70 1.82 40,000 $ 72,800.00 $ 160,157.00 86,556 40,000 46,556 $ 86,143.88 1.85 Oct-08 1.62 1.76 40,000 $ 70,200.00 $ 156,343.88 86,556 40,000 46,556 $ 84,092.90 1.81 Nov-08 1.62 1.76 50,000 $ 87,750.00 $ 171,842.90 96,556 50,000 46,556 $ 82,856.77 1.78 Dec-08 1.64 1.78 60,000 $ 106,500.00 $ 189,356.77 106,556 60,000 46,556 $ 82,732.96 1.78 Jan-09 1.65 1.79 50,000 $ 89,250.00 $ 171,982.96 96,556 50,000 46,556 $ 82,924.30 1.78 Feb-09 1.60 1.74 50,000 $ 86,750.00 $ 169,674.30 96,556 50,000 46,556 $ 81,811.14 1.76 Mar-09 1.60 1.74 40,000 $ 69,400.00 $ 151,211.14 86,556 40,000 46,556 $ 81,332.16 1.75 Apr-09 1.60 1.73 40,000 $ 69,000.00 $ 150,332.16 86,556 40,000 46,556 $ 80,859.37 1.74 May-09 1.60 1.73 30,000 $ 51,750.00 $ 132,609.37 76,556 30,000 46,556 $ 80,643.74 1.73 Jun-09 1.60 1.73 30,000 $ 51,750.00 $ 132,393.74 76,556 30,000 46,556 $ 80,512.60 1.73 Jul-09 1.60 1.73 20,000 $ 34,500.00 $ 115,012.60 66,556 20,000 46,556 $ 80,451.45 1.73 Aug-09 1.60 1.73 30,000 $ 51,750.00 $ 132,201.45 76,556 30,000 46,556 $ 80,395.67 1.73 Sep-09 1.60 1.73 40,000 $ 69,000.00 $ 149,395.67 86,556 40,000 46,556 $ 80,355.66 1.73 CSW:09/16/200B ATTACHMENT #4 Page 1 of 2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/2008 - 09/30/2009 I. 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) I I. Calculation of the Required Natural Gas PGA WACOG for FY 08/09 A. Therm Sales Projection for 10/1/08 - 9/30/09 = B. Projected NG Reservation Cost 10/1/08 - 9/30/09 = $ Projected NG Commodity Cost 10/1/08 - 9/30/09 = $ Budgeted Other Supply Related Expenses = $ Total Recovery Needed for FY 08/09 only = $ 100% of Under Recovery of FYTD PGA thru 9/08 = $ Total Annualized Recovery Needed for FY 08/09 = $ C. Required Weighted Average Recovery CostfTherm = $ $0.080 22,000,000 1,500,000 17,500,000 4,500,000 23,500,000 300,000 23,800,000 1.082 Currently overall PGA Recovery is: Therefore, Contract PGA needs to bE $ Which makes Standard PGA: $ 96.8% of Contract Rate 1.12 1.20 D. Projected NG PGA Annual Revenue = III. Proposed Natural Gas PGA Billing Factors for 10/01/08 - 09/30/0S A. Proposed Standard Rate PGA Billing Factor B. Less Non-Standard Differential for Reservation Cost $ C. Proposed Non-Standard PGA Billing Factor IV. Proposed LP Gas Billing Factors for 10/01/08 - 09/30/09 $ (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.78/gallon. U:IMy DocumentslEXCELIGASRATESIFY OB-091[PGA for FY OB-09.xlsjPGACALC Pinellas NG PGA = Pasco NG PGA = Total NG PGA = $ 20,678,173 $ 3,121,827 $ 23,800,000 PGA Only ECA in PGA Total PGA $ 1.20 $ 0.07 $ 1.27 (0.08) $ $ (0.08) $ 1.12 $ 0.07 $ 1.19 PGA Only* ECA in PGA Total PGA 2.19 $ 0.07 $ 2.26 CSW:09!16/200B 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 Therms Contract Therms Standard Therms Standard Charqes 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 Oct 2007 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% S 162,347.55 S 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% S 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% S 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% S 154,923.90 $ 0.158 $ 0.093 Mar 2008 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.4 7 $ 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 Jul2008 1,437,906 403,799 28.1% 455,939 31.7% 859,738 59.8% 578,168 40.2% $ 79,618.90 S 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% S 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. U:\My Documents\EXCEL\GASRATES\FY 08-09\{PGA for FY 08-09.xls]PGACALC CSW:09/16/2008 ATTACHMENT #5 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 10101/2008 - 9/30/2009 I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 08/09: Projected ECA Requirements for FY 08/09 only = $ 1,500,000 Projected Administrative & CCS Charges to ECA for FY 08/09 = $ 600,000 Projected Current FYE 07/08 (Over) Under Recovery of ECA = $ Total Annualized ECA Recovery Needed during FY 08/09 = $ 2,100,000 Less Projected ECA Recovery within PGA @ $0.07/Therm or Gal = $ (700,000) Total ECA Recovery Needed from Standard Rate Customers = $ 1,400,000 Projected Therm Sales for FY 08/09 Applicable to ECA Recovery = 10,210,000 (Natural Gas @ 44% Standard = 9,680,000 therms & LP @ 100% Standard = 530,000 gal. or 10,210,000 Total Applicable Therms) Computed ECA Recovery Factor Necessary = $ 0.1371 Propose Rounding ECA Recovery Rate to $ 0.140 # Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 2,129,400 II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 08/09: Round Proposed EIA Recovery Rate to $ 100,000 $ (100,000) $ $ $ $ Budgeted EIA Requirements for FY 08/09 only = Projected Current FYE 07/08 (Over) Under Recovery of EIA = Total Annualized EIA Recovery Needed during FY 08/09 = Therefore, EIA needs to be for FY 08/09 = Annual ECA Revenue Projection @ Proposed Recovery Rate = U:\My Documents\EXCEL\GASRATES\FY 08-09\[ECA & EIA for FY 08-09.xls]Sheet1 CSW:09/16/2008 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Enerqv CharqelTherm Non-Fuel Energy Charge Energy ConseNation 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 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR OCTOBER 1, 2008 - SEPTEMBER 30, 2009 BASED ON APPROVED GAS ADJUSTMENT FACTORS ~ SMF MMF LMF Firm Natural Gas Rate Schedules SGS MGS LGS RAC 0- 18,000- 17,999 99,999 $20.00 ($30.00) 100,000 & up $30.00 $75.00 ($50.00) ($125.00) $0.470 $0.410 0.140 0.140 0.000 0.000 0.000 0.000 $0.610 $0.550 1.270 1.270 $1.880 $1.820 $0.350 $0.490 $1.760 $20.00 ($3000) $30.00 $75.00 ($50.00) ($125.00) NA(1- 3 Units) $8.00 ($12.00) if not prevo billed $0.200 0.140 0.000 0.000 $0.340 1.270 $1.610 GAC NA(O- 149 tons) $20.00 ($30.00) if not prevo billed $0.150 0.140 0.140 LAC NA (150 tons & +) $30.00 ($50.00) if not prevo billed $0.100 0.140 0.000 0.000 $0.240 1.270 $1.510 $8.00 $20.00 @ $30.00 @ ($12.00) ($30.00) ($50.00) @ premise @ premise @ premise 0.000 0.000 ~ SL w/M& Reliqht NA NA $20.00 ($30.00) $0.200 0.000 $0.340 1.270 $1.610 $20.00 ($30.00) + FAC Interr. NG Rate NGV ~---.lL NA NA 100,000 Non-Resl. & up $20.00 $8 Res/$20 GS ($30.00) ($12 Res/$30 GS) if not prevo billed $0.300 0.140 0.140 NA(1 - 3 Units) NA(4 + Units) NA (4 + Units) NA(4 + Units) 0.000 0.000 0.000 0.000 $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.140 0.140 0.140 0.140 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 $0.720 $0.720 $0.720 $0.720 1.270 1.270 1.270 1.270 $1.990 $1.990 $1.990 $1.990 $8.00 $20.00 $30.00 $75.00 ($12.00) ($30.00) ($50.00) ($125.00) $0.290 1.270 1.270 0.000 $0.440 1.270 $1710 $0.100 $0.240 $1.510 $20.00 $8 Res/$20 GS ($3000) ($12 Res/$30 GS) + FAC S 1.821 $ 1.821 $ 1.821 $ 1.821 $ 1.720 $ 1.665 S 1.610 S 1.473 $ 1.427 $ 1.382 $ 1.473 $ 1.565 $ $ 1.930 $ 1.930 $ 1.930 $ 1.930 $ 1.823 $ 1.765 $ 1.707 $ 1.562 $ 1.513 $ 1.465 $ 1.562 $ 1.659 $ $1.560 Change from 1/2006 Therm Rate $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ (0.270) $ % Change from 1/2006 Therm Rate -11.9% -11.9% -11.9% -11.9% -12.6% -12.9% -13.3% -14.4% -14.8% -15.2% -14.4% -13.6% Utility Tax Note: Fuel Rate per Therm 10/01/1973 Non-Utility Taxable Fuel/Therm $0.069 $0.069 $0.069 $0.069 $1.201 $1.201 $1.201 $1.201 BTU FACTOR = THERMS/100 CUBIC FEET (CCFl Firm SeNice Rates Interruptible SeNice Rates $0.069 $0.069 $0.069 $1.201 1.052 10/2008 11/2008 12/2008 01/2009 02/2009 03/2009 04/2009 1.032 $1.201 $1.201 $0.069 $1.201 $0.069 $1.201 OS/2009 06/2009 $0.069 $1.201 $0.069 $1.201 $0.069 $1.201 07/2009 08/2009 09/2009 @ premise + FAC $50.00 $150.00 ($75.00) ($250.00) 0.140 0.000 0.000 1.270 $50.00 ($75.00) + FAC $0.470 $0.280 0.140 NA 0.000 NA 0.000 0.000 $0.610 $0.280 1.270 1.190 $1.880 $1.470 $150.00 ($250.00) + Non-Fuel Therm Rate for 250 therms X # Days in Mo. 1.382 $ 1.720 $ 1.345 1.465 $ 1.823 $ 1.426 (0.270) $ (0.270) $ (0.270) -15.2% -12.6% -15.5% $0.069 $1.201 $0.069 $0.055 $1.201 $1.135 Attachment #6 Contract NG Rate ~ NA By Contract By Contract NA NA 0.000 Contract + $0.000 Plus 1.190 $1.190 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms $ (0.270) -18.5% $0.069 $1.121 CSW:09/16/2008 Attachment #7 Page 1 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/1 00 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR OCTOBER 1, 2008 - SEPTEMBER 30,2009 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 Enerqy Charqes/Gallon: prevo billed @ premise Non-Fuel Energy Charge IGallon $1.600 $1600 $0.800 $0.200 $0.150 $0100 $0.390 Set By Contract Energy Conservation Adj.lGallon 0.140 0.140 0.140 0.140 0.140 0.140 0.140 NA Environm'llmposition Adj. IGallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0000 0.000 0.000 0000 0.000 0000 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 2.260 2.260 2.260 2.260 2.260 2.260 2.260 2.260 Total Energy Charges/Gallon $4.000 $4.000 $3.200 $2.600 $2.550 $2.500 $2.790 $2.260 + Contract NFE Customer Charge + Minimum Monthly Bill $800 $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 10101/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable Fuel/Therm $2.099 $2.099 $2.099 $2.099 $2.099 $2.099 $2.099 $2.099 Change from 8/2008 Gallon Rate $ (0.140) $ (0.140) $(0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.160) % Change from 8/2008 Gallon Rate -3.4% -3.4% -4.2% -5.1% -5.2% -5.3% -4.8% -6.6% CSW:09/16/2008 Attachment #7 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 OCTOBER 1,2008 - SEPTEMBER 30,2009 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 Enerqy Charqes/Gallon: Non-Fuel Energy Charge/Gallon $ 1.500 $ 1.300 $ 0.900 $ 0.800 $ 1.300 $ 0.800 $ 0.200 S 0.150 $ 0.390 Set By Contract Energy Conservation Adj.lGallon 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 0.140 NA Environm'l Imposition Adj.lGallon NA Weather Normalization Adj.lGallon 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 AdjustmenUGallon 2.260 2.260 2.260 2.260 2.260 2.260 2.260 2.260 2.260 2.260 Total Energy Charges/Gallon $ 3.900 $ 3.700 $ 3.300 $ 3.200 $ 3.700 $ 3.200 $ 2.600 $ 2.550 $ 2.790 $ 2.260 + Contract NFE Note' Nn 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 $ 2.099 $ 2.099 $ 2.099 $ 2.099 $ 2.099 $ 2.099 $ 2.099 $ 2.099 $ 2.099 $ 2.099 Change from 8/2008 Gallon Rate $ (0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.140) $ (0.160) % Change from 8/2008 Gallon Rate -3.5% -3.6% -4.1% -4.2% -3.6% -4.2% -5.1 % -5.2% -4.8% -6.6% I I II ! Residential Rate History By Components Clearwater Gas System I I I J. I [ . . ComponentslTherm I ECA 1 EIAWNA .1 ! i ! . 1 $ 0.1401 $ $ $ 1.270 $ I I I i I 1 I ! Note: This is Progress Energy's residential rate in 8/2008 for usage >1,000 KWH. I I i I I I I I- I I I i I .1 to Residential LP Will Call (BRWCLP). eSW:09/16/200B L Total Rate Month I NGltl1errTl!LP/qallon* Oet-08 $ 1.990 1$ 3.300 Nov-08 Dee-08 Jan-09! Feb-09 i Mar-09 j\pr-09 May~09 Jun-09 Jul-09 AUg~09 Sep-09 FY 08/09 Avg. I $ 1.990 1$ 3.300 I 2008 Avg. NA i NA ! : $ 0.140 I $ NA i i $ NA: NA (ncr. Above $ 0.150 $ 0.310 Last Year Same Month 8% 10% (ncr. Based $ 3.00 6.78 on 20 Therms 7% 9% I E:.qu iva.1el1! Cents/KWH 6.8 12.3 for Gas vs. FPC Rate 12.0 12.0 (Residential).. I i I $ (0.040)1 $ -22%1 I I 1$ I NAi GasCheaper by 30/01 .__ un ... ....._ ......__J_____I .. . . . Note: Added $1 per month to Monthly Customer Charge for NG & LP effective 4/1/2005 Nom,,- uJ-1 * Based on Bulk LP (BRLP3) which is a licable for customers usin -43% I Attachment #8 I Page 1 of 2 I contractl PGA PGA I LP PGA/qallon 1. 190 $ 2.260 I I $ 1.270 I $ NA I 1.190 1$ NA I 0.1901$ 1- -. ! 2.260 NA 0.350 1801 i I [ 19%1 18% [ I .. .....Total Rate NG/therrn ILP/Qallon* mi.. . ... Oet-041 $ .710 $ 2.030 Nov-041$ 1.710$ 2.030 Dee-04! $ 1.750 $ 2.090 Jan-05[S 1.750 $ 2.090 Feb-051$ 1.830 $ 2.150 Mar-05: $ .860 $ 2.180 Apr~OSI $ 1.860 $ 2.280 May~OS $ 1.790 $ 2.190 Jun-OS $ 1.790 $ 2.190 Jul-OS $ 1.790 $ 2.190 Aug~05$ . . 1.820 $2~220 I Sep~05$ 1.970$-. 2.360 T FY 04/05 Avg. 1$ 1.803 1 $ 2.162 I 2004 Avg. I $ 1.652 1 $ 1.968 i CSW:08/19/2008 Month I Oct-OS $ Nov_OS$U Dee-OS $ Jan-06 $ Feb-06 $ Mar-06 $ .",.._....-.,-".-,---",-- Apr-06 $ May~()~ $ Jun-06 $ Jul-06 $ Aug-06 $ Sep-06$ FY 05/06 Avg. 1 $ 2005 Avg. 1 $ Oet-06 $ Nov-06 $ Dee-06 $ Jan-07 $ Feb-07 $ Mar-07 $ .t\pr-07 $ May-07 $ Jun=6i$- ...-----.---..-.------ Jul-07 $ . .Aug~()7$ Sep-07, $ FY 06/07 Avg. I $ 2006 Avg. I $ oct-oil $ ~~~~bjl i J~_~'-9'_$r$ Feb-08 $ Mar-08 $ .t\pr~08 $ May-08 $ Jun-08 $ Jul-08 $ ALJg~08 $ Sep-08 $ FY 07/08 Avg. I $ 2007 Avg. $ 2.190 $ ------------ ------- 2.190 $ 2.260 $ __.. ,__.___..__.____ __ n____ 2.260 $ ."., ,.. '" 2.220 $ .,,_.__.___m___'____",_. 2.220 $ ..2.1101$ .----. , - 1.960 $ 1 .920 $ ------- ----- 1.910 $ H~~...lln 2.080 I $ 1.925 I $ 1.940 $ 1.940 $ 1.940 $ 1.940 $ 1.940 $ J:~1bl~ 1.940 $ 1.920 $ 1.840 $ 1.840 $ 1.S90rs 1.918 1 $ 2.012 1 $ i 1.840 i $ 1.840 fs J___:8~-q_'_'_1 ~ _1:8~() i $ n~.~4QIJ 1. ~1()H 1.810 1$ 1.880 $ L~90 J$_ 2.250 I $ 2.120 1$ 2.120 ! $ 1.932 1$ 1.893 I $ I I I I I I I Residential Rate History By Components Clearwater Gas System I .1 I.. 1 1 , ,. . ComponentslTherm ! ! ECA I EIA IWNA t . .. 1 $ 0:100 I $ 1$ $1.030 '$ . $ 0.100 $ . $ $ 1.030 $ . $ 0.100 $ i $ $ 1.070 $ $ 0.100 $ 1 $ $ 1070 $ $ 0.130 $ 1 $ 0.010 $ 1.110 $ $ 0.130 $ 0.020 1$ 0.020 $ 1.110, $ $ 0.130 $ 0.020 i $ 0.020 $ 1.110 $ $ 0.130 $ 0.020 ! $ $ 1.060 $ $ 0.130 $ 0.020 $ $ 1.060 $ $ 0.130 $ 0.020 $ $ 1.060 $ $ 0.140 $ 0.020 $ $ 1.080 $ $ 0.140 $ 0.020 $ $1.230 $ $ 0.122 1$ 0.012 $ 0.004 1$ 1.085 1 $ $ 0.123 1 $ $ I $ 0.949 1 $ 1 $ 01201 $ 0.020 $ $ 1.470 $ $ 0.120 i $ 0.020 $ $ 1.470 $ $ 0.120 $ 0.020 $ $ 1.S40 $ $ 0.120 $ 0.020 $ $ 1.S40 $ $ 0.160 $ 0.010 $ 1$1.4'101$ $ 0.160 $ 0.010 $ 1$ 1.470 ! $ $ 0.170 $ 0.010 $ I $1.35QJ$ $ 00..117800.......1. .$$.. 00..00.1100 $ $ 1.200 1 $ $ $ 1 $U 50 [$ $ 0.200 1$ 0.010 $ i $ 1120[ $ 0.200 1$0.010 $ [$ 1.070 1 $ 0.266 I $ 0.01 $ 1-$1.0761$ 1 $ 0.160 1 $ 0.013 1 $ I $ 1.327 1 $ I $ 0.127 1 $ 0.017 1 $ 0.004 I $ 1.198 1 $ $ 0.180.1 $ 0.010 I $ $ 1.170 $ $ 0.180 $ 0.010 i $ $ 1.170 $ ~ ~~~~f~ ~:~~~ Ii ~ ~:~;~ ~ $ 0.180 I $ 0.010 I $ $ 1.170 $ .~ b~~~nli 0~10lfo.b30 iU~b I.~ $ 0.180 [$ -$O:()30 $1.1S0 1$ $ 0.180 I $ $ 0.030 $1.130 i $ $ 0.180 I $ $ $1.0801$ $ 0180 [$ ( n$1.080J$ $ 0.180 I $ $ $ 1.130 I $ $ 0.180 $ 0.005 1 $ 0.008 1 $ 1.145 I $ 1 $ 0.175 $ 0.011 1 $ 1 $ 1.246 I $ 1 1 0.180 $ $ i $ 1.0801$ 0.180 $ $ Ii $ 1.080 I $ 0.180 $ $ $ 1.080 $ 0180 $ $ 1 $1:080 I $ 0.180 $ $ 1 $ 1.080 1$ ~ ~;~ ~~~:~;~Iu ~~:~;~I ~ 0.090 $ $ 0.030..1 $ 1.180 $ 0.070 $ $ 0.030 $ 1.310 $ $ $ 0.030 I $ 1490 $ $ $ 1$1.420$ $ $ I $ 1.420 I $ 1 $ 0.146 I $ $ 0.013 1 $ 1.193 I $ I $ 0.180 I $ 0.003 1 $ 0.008 1 $ 1.123 I $ PGA u... . I 2.530 I 2.530 r .u _ .nul 2.490 , 2.4961 2.4601 2.460 2.320 2.360 2.420 2.500 2.600 2.600 2.480 1 2.278 1 I 2.600 2.600 2.600 2:60.0...........11 2.600 2.6001 2.600'. 2.740 2.990 2.990 }99Q IU 2.990 1 2.742 j 2.501 I 1 2.990 i ~:~;bul 3.170 I 3..1...70...1 3.120 3. ,.1.. 20.....1'. 3.120 3.150.1 3.230 3.440 .3.340ul 3.183 i 2.869 I Contract PC;A 0.960 $ 0.960 $ 1.000 $ 1.000 $ 1.040 $ 1.040 $ 1.040 $ 0.990 $ ..., b:~~~ I ~ l'~~~ I ~. 1.015 j $ 0.879 j $ .-,., j---- 1.390 I $ .... ., 1.390 i $ 1.460 I $ 1.460 I. $ 1.390 I $ 1.390 $ 1.270 $ 1 .120 $ 1.070 $ 1.040 $ 0.990 $ 0.990 $ 1.2471$ 1.125 I $ I 1:0901 $ 1.090 $ 1.090 $ 1.090 $ 1 .090 $ 1 .090 $ 1.070 $ 1.070 $ .OSO $ 1.000 $ 1.000 $ 1.0S0 $ 1.065 1 $ 1.166 1 $ I 1.000 I $ 1.000 $ 1 .000 $ 1.000 $ 1.000 $ 0:970 I $ 0.970 1 $ 1 .1 00 ! $ 1.230 $ 1.410 $ 1.340 $ 1.340 $ 1.113 $ 1.043 1 $ I Attachment #8 I Page 2 of 2 LP PGA/Qallon 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 .4S0 1.390 1.390 1.240 1,280 1.330 1.390 1 .490 1.490 1.407 1.256 1.510 1.S10 1.510 1.S10 1.S10 1.S10 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.1S0 2.420 2.320 2.124 1.779