Loading...
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2011` �+''�, p),�,r. �;,y , °' � �� TO: FROM: COPIES: SUB.IECT: DATE: CLEARWATER GAS SYSTEM Infero�ce Correspondence Sheet i n��;s�e�,,�;€� � �, "T _, rai-�},� . , I��::j' ... _. _ . ....� � w 1��--� .._. „ f�C:T � � ZA1� ,�: ...,. . s�,:� ��. �;e::�::���,., h:�a� � ����u Williann B. Horne IT, City Manager r.��wyw;� -�`�-�w�p- �.� ��.:4_ ,��,.; � m;� � �.;,�, ��.A a Chuck Warrington, Mana�ing Director Rod Irwin, Assistan.t City Manager; Kosemarie Call, City Clerk; CGS & CCS Managernent Tea�nn.s; Janet Dorrough, Sr. AccountanUCGS; Lawra Damico, Sr. Accountatat/CCS; Lynne Priester, Cust. Serv. Coord./CCS GAS ADJUSTMENTS EFFECTIVE OCTOSER 1, 2011 September 29, 2Q11 This is the time of year when we reasses'�S our gas rates for the new fiscal year and znake projectians based on forecasted gas pz�ces and our ncw fiscal year budget. As a result, we are recommendin� an incrcase in our Natural Gas Purchased�l Gas Adjustment (PGA) of 4¢/thenm and an incxease of 16¢/gallon in our LP PGA in October. We are also recommending that we continue our Contract LP PGA at 3�¢ below our Sta�n.dard L� PGA. 1'lease note from Attachtnent #4 that our projections support a 14¢/therm increase in our NG PGA %r the new tiscal year; however, we are recoznmending your approval of implez�nenting this increase in three (3) steps: 4¢/therm in October, 5¢/thez�xi additional in November, and S¢/therm additional in December. We are also recommending an inc:rease of 1¢/therm or gallon in ou� Energy Conservatian Adjustment (ECA) in Octaber; however, we are not rECOmmending any change in our Regulatory Impositxon Adjustment. (RIA) nor our Usage & Inflation Adjushnent (UTA) at this time. The net effect of these recommended changes for October is an increase in our ty�icaX Residential Natura� Gas customex's rate of 5¢/therm (+3.5%) and an increase in our typical Residential LP customer's rate of 17¢/g�llon (+4.9%). Therefore, we aze recoxnmendin� your approval of the following rates to become effective for billings rendered on and after Octobex 1, 2011: I Natural Gas Firm Standaxd Rate Schedul� ,PGA ................. $0.82 per therm (up 4¢/thez-m) in Oct. �, $0.87 per therm (up 5¢/therm) iz� Nov. $0.92 per therm (up 5¢/therm) in Dec. Natural Gas Interruptible and Contract (Non-Standa�rd) Rate Schedule PGA .... ......... $0.74 per therm (up 4¢/thernr�) in Oct. $0.79 per therm (up 5¢/therm) in Nov. $0.84 per therm (up 5¢/thenm) in Dec. �'ropane (LF) Gas Standard Rate Schedule',PGA ............... Propane (LP) Gas Contract Rate Schedule PGA ............... $2.46 per �allan (up 16¢/�allon) $2.16 per gallon (up 16�/gallon) William B. Horne II, City Manager September 29, 2011 Page 2 Ener�y Conservation Adjustment (ECA) :........................... $p.13 per therm or gallon (up 1¢) Regulatory Imposition Adjustment (EIA) ' ....................... $OA2 per therm or gallon (no change) Usage & Inflation Adjustrnent (WNA) - Residential ............ $0.02 per therm or gallon (no change) - Cornmercial ...... ... $0.05 per therm ox gallon (no'change) Attachment #1 shows the status a�our Adjustment Recovery Clause balances with actuals thru August. Our objective is to be as close as practical to balance by FY ending. Attachments #2 ar�d #3 shaw our annual projections for Natural Gas and LP supply costs, respectively. Attachrn.ent #4 shaws our calculation of bux Purchased Gas Adjustment (PGA) clauses. Attachx�nent #5 shows our calculation of our Ener'gy Conservation Adjustrnent (ECA) and our Regulatory Impasition Adjushnent (RIA) clauses. Attachments #6 and #7 show the impact of these adjustmient clause char�ges on our overall Nahxral and LP Gas rates, respectively. Attachment #8, Page #1 shows our �nonthly rate history aver the past 3+ yeaxs, and Pages #2 and #3 of this show our 10 year relationship to electric prices and average residential rates, respectively this to a difference! over our vs. 5.3 's Please note that Pa e#2 of •al as cates have risen 'ust residential rates. That's an nr plaofrir ___ a ramar�lr�hlu I should point out �ven with this month's'�i increase, the overall effect is that our ical Residential customer rates are still a roximatel 61 % lower than electric for Natural Gas. This is a vezy attractive competitive position vs. electric rates. We will continu� to track these balances eiach month, make monthly projections of thes� factors based on market conditions, and let you know if 'I y of these get significantly aut of balance. Bill, I wauld appreciate your approval of ese revised adjustment xates so we can get this information to CCS in order to make the appropnate a� ustments in the billing formulas in time for the October 1 St billings. If you have any questions on this� please call me. i . CSW/csw '' Attachments Ap�roved: �il� ,LQ.ec�..,..--.�1 . _ � William S. Horne IT, City Manager U:WIy DocumentsVNSQFFICE\WINWORD\GASRATES\Gas Adjustments for Qctober 2011.doc CLEARWATER GAS SYSTEM ���G��^�r �' � S�MMARY O� RATE ADJUSTMENT CLAUSE COLLECTfONS FOR FY 2090/2011 Budget i Reser�ation __ __ _ Commodlty Month ; _ Cf�arges _ _ _ Charges_ _ __ + Prior Year i Oct-10 $ 3,214,594.56 ' ____ __ _ _ 854,995.4fi l�0�-14 i $ 211,726.13 823,199.40 , $ -------- — – - --- - -- _- Dec-16 ' $__ - 75,857.24i-----_ i,117,270.13 $ Jan-11 `$ 195,DSi.12 I __--- - -- - 1,714,656.60 $ - Feb-1'E i S _-.993,849.51 ' -- -------- 1,168,251.62 ; $ _ Mar-1'k ; $ 218,053.83 _ 924,788.5i ; $ Apr-i1 $ 931,419.26 : 1,1'f4,428.22 � $ May-19 ; � [202,3fl2.09}; --- 831,780.97 ` � J�n-1i j$ 89,954.39 i 653,452.42 j$ Jul-11 -' $- -96,275.54 - -------- 761,7fl3.08 � $ � ---- Aug_9 9 ; � 91,4D5.24 � - - _ ----- --- -833,4� Sep-93 ' $ _ 95,000.00 ; _--- -- _- 850,040.00 � $ - Per13 $ - $ - i Interest Cost Center Exnense � Exoenses ;$ 14,185.46 $ � z,asa.aa $ f0,9Q8.36 ' $ 9,555.31 $ 7,228.71 ; $ 4,574.51 ; $ 3,337.85 : $ fi25.7fi : $ �� $ � �� Takal YTD: $ 4,410,906.fi1 $ 19,647,999.78 I$ 63,350.39 �$ [1}; includes Annual Admin chg of $718,35Q + CCS chg of $1,d40,810 + Dividend $1,300,72i i+ FY 4911 D PGA write off af $2B,580.D4 + WNA $Q = ;$ 3,088,460.04 ' [2); FGT Rate Case Retund = j$ (297,056.86}; -- i --- � Net RC =; $ �,623,503.43 !- - - -- - ---- ' .__ -- - - - � -- -- I ----- - ..------ - ------- - - ----� 52,033.70: 1 '; 47,2i 5.65 46,337.34 i ; 49,44D.S2 a2,os�.ae ! 41,379.15 5Q,623.95 38,586.24 ; 2 � 39,498.66 ':. 37,925.36 ' 37,986.03 45,040.66 ; I 5 � 528,094.45 � i � i - , {5} � i i - - - --- ---- ----- - --- � - - -- - -� --- _ i Budget _ GaElons _ _ - _ _ _ _ Monthly _ ___ Interest ; Commodlty Nfonth : Sold _ WACOG Expense Chargas . � Prror Ye�-- = -- - - �- - - -- --- - --- ------ Oct-10 •: 33,366.4 � 1.41942 j :$ 47,3fi4.94 ! 1 -- _- -- -- -- - �-- No�-10 32,634.7 ;$ _ 9.51533 I$ 902.36 ! 49,452.34 - ---- - - - - --- -- Dec-10 41,735.5 i$ _ __ __ 1.62230 �$ 844.10 67,707.50 _ _ Jan-'E 1--- 50,401.2 j$-- -- -- 1.71763 ;$ 790.31 � 86,576.6'! i - --- -- --- - ----- - --� Feb-� 1 35,247.5 �$ 1.67582 !$ 68fi.53 ; 59,068.47 fViar-11 _ 38,198.6 � $__ _- -- -_ --_ 1.68222 ! $ _ 599.94 i fi4,258.45 ; Apr-11 _ 33,&52.1 j $ __- -- - 1.64195 = $ - _ _ 505.73 ' - 55,255.a7 May-i 1 ; 24,249.3 $ ---_- 1.71226 ; $ _ - - 42fi.26 : -- 41,519.65 Jun-11 i --- 31,261.2 ; � _ 1.74541 ! $ --371.81 : 54,5fi3.61 � J u1-11 T - -- 23,27fi.5 ; $ - --- 1.78113 ! $ 304.58 - 41,458.47 - --- -- --- -T ---� - - Aug-11 22,024.4 I S 1.79413 '$ 258.70 ' 39,514.64 ; - -- -- - --- — - 5ep-11 ' 26,000.0 � S �.75000 $ 246.81 : 46,540,00 ? --- -- -- - ----- - -------- .. .- - --- , - P93 � ? q Total YTD 392,047.4 I$ 1.fi6fi30 i$ 5,897.14 I$ 653,269.74 . - -- - + -- --- _ _ ;Cast Center Expenses � -�- E � E C � �age 1 of 4 � � Monthly _ Cumulatiue _ i__ NG PGA G Fuel � Tatal NG PGA O�eraga ! YTD average ; RatelTherm nses __7 BElfed I {Shorta�e I (5hortagey _ �.__FirmlContr i : �, $ 51,526.29 i-- 4,121,623 $ 1,233,004.$3 ' $ [2,888,619.09J� $ {2,837,092.SOJ' 0.8710.79--- 9 ,496,32$.641 1,346,532.03 ; $ 250,205.39 ' $ [2,586,887.41} � fl.8710.79 1,252,399.15 ; 'E,fi57,6#4,95 : $ 405,215.80 ; $ [2,'f81,671.61}; 0.8710.79 1,570,087.U0 2,246,697.i3 $ 270,610.13 ; $ [1,931,061.48} 0.9210.84 1,413,74329 9,$79,062.93 I$ 4fi5,319.84 '$ [1,445,741.84} 6.8910.89 1,191,450.2D 1,722,289.49 ' $ 530,839.28 $ (914,902.5b)! Q.8810.81 1,3fl1,037,94 1,548,37U.44 $ 247,332.5Q � $ {$67,57fl.05] 0.8210.74 871,363.05 1,2'i3,781.88 $ 542,4'{8.81 $ {125,151.24j 0.81I0.73 783.53t.63 ; 1,205,938.82 ,$ 422,467.79 $ 297,256.56 i 0.8110.73 98 j 1,123,970.89 $ 228,06fi.91 $ 525,3 32 47 fl.81l4.73 - 24 � 1, i 15,877.30 !$ f 53,792.0& i$-- -- 679,115.53 0.7814.70 00 ' 1,693,548.19 $ iO3,54$.99 !$ 782,663.72 ; 0.78I4.70 87 = - $ - [7&5,922.87]! $-_ 17,540.85 ; -- _- -_- $ 17,415,474.10 � $ 17,381,488.66 : $ {33,985.44}; � --- - � - -- - --- -- ---- - �mmaditya�ijustrcr�nCirom FYE trdnsfer of ECA Caltected in PGA @ 912 oF the ECA Rate NG Proporfion = 97.9% x Total ECA Transfer = �$ 785,122.87 -- ' ---- + OPEB Lia6ili Accrueci sick & �acation ; � TBD _'-T- . � - �--- -1- - -- � � - ---- � - � '- - ----....---- -- , -- ----- ' i i - -- ---�- ---- -----�;-- - - ------- -I--- ---- -- ----- ---- -------------- -- � - - � -- � -IN�hly - i - � �atf�e ' LP_PGA Total LP Fuel � Total LP PGA __ Overage __ _: YTO O�erage _ ThermlGal. __ Ex�senses _ _ _ Bilied _ __ tShortage} _ {Shorta9ej _ _ _ � ! � $ - _ 12,382.31- $ 258,592,� $ 63,737.90 I $ --(192,855,23}I $ {180,472.90J` 1.7311.90 39 _ _ 5fl,354.70 � 62,008.50 $ 19,653.80 ; $ {468,819.10j' 1.7311.90 -- 68,551.60 I 78,3D8.70 $_ 1D,757.10 ;$- (958,462.00j 1.7311.90 -- _- 87,360.92 : t08,116.53 � $ 20,755.61 ; $ (i37,306.39} 2.0012.19 --_- 59,755.00 j _ _ 77,073.22 ! $ -- 9 7,318.22 ! � (i 19,988.17}, 2.D012.19 64,85$.39f __-_ 83,740.29 $ 18,841.96 : $ ---[101,146.27]; 2.0412.19 55,7fi0.8� 71,855.86 ' $ 15,895.Ofi � $ {85,25'f.20] 1.9412.i2 41,945.91 -- 52,835J5 ; $ __ 10,889.84 ; $ - -- [74,369.36J 2.6012.19 _-- 54,935.42 � -68,379.39 � $ _ 13,443.97 ; $ -- (66,917.39); 2.0012.99 _ _ 41,763.06 ' - - 56,941.4 i •: $ 9,178A5 i $ (51,739.34)' 2.0012.19 _ 39,773,33 ' 56,149.71 , $ 1Q,376.38 ; $ (41,362.96j Z.1012.34 46,74fi.81 59,645.04 !$_ 12,858.23 �$ (28,464.74]: 2.1012.34 22,18Q.87 i - -- ----- - i $ {22,180.87]; $ {50 645.60}' - - -- $ _ 89Q579.11 ; $ 827,551.2D � $ ($3,627.91]� -- � -�-- -- - � �CCS Ch , Admin � D�vidend ; ' � -- - -------- � -- ------ --- $ 126,1?O.DO ! 1 i FY D9l1Q Write aff PGA & WNA - ' ' ----- I - --- - - -,-- -- - ' • 1729 2 --- ---------- -- -- -- ----- --- -- -�--- - -�-� -- � --- � ------ -- Fuel ---= �-- 15,OOD.00 1_� � -- - ; - - ---- -- - - -- - ---- ------ --- ---- - - -- Donations to events � $ 25,946.4� 1 - - ----- - I - -- --�- -- - - - - - - � -- ----- - =---- -- - ---- - ---- - � ------------ - ' - ----T--- J --- -- - - _ - - ----- --- - -- -- LP Yard Va onzafianlloss due to malfunctionin meter $ 1,982.41 1 -____.._.:_.___ _. __;_- --__P _____.___ ._ _____ _ 9 ______ ' (4)! Adjustment from FYE transfer oF ECA in PGA @ 112 of the ECA Rate �__-- ' - - - -- - -- ; LP PGA Event fuel cost ,_ ___ �$ 4,851.18 � 1 T __ __ ; LP Prvportion - 2.1°/o x Total ECA Transfer = �$ 16,412.24 - - --- <___----- -- -- - - - — - - i5uburban Software Systems ;_ _ _ _ _ _ ; , 1 ; , + Additional Projected Costs Needed = 5,768.63 - - -- -- - - ._:...-- ----- --- � --- -- - - - T- ! De reciation of LP tanks --- � --�--- --� 5 34,414.23 ; 1 - --- -- -- - --- - - - --- r -- -- ' LP Holding Tank Restoration � 1 Proj. for Year �. Additional Needed :.' � - -- - - - - ----- ----- -- - ' � - -- -- -- . .... --- ---- -.----- -- -- . -- ------- I ---- ' $ 209,231.37 ; 'E i $ 215,0OO.Ofl ; $ 5,768.63 '• i i -- ; -- - -i---- -- --- -- - I -�--- - � CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2d1012011 ; I I _Sudget ' Cost Center ; 9No�th _ Expenses � NoteslExce�t'�onal Items Prior Year Ocf-10 ,$ 476,228.43 !Promo530,927,Adv Se45, Employ CostsS70,342 • -+-- --- NOn-14 . 92,92328_iPmmo531,ese,Adv Se,629, Employ Costs$52,22 �ec-1❑ $ 96,505,54 Pramo541,517,Adv $1,529, Employ Costs$53pE Jan-11 :$ 154,706,3& �PromoE94,138,Adv $255, Emplay CaslsS60,373 Feb-11 '$ 83,774.72 jgromo;27,328,Adv $o, Employ Costs55fi.447 Mar-11 $ 10i,633A3 :PmmoS42.838,Adv 5990, Employ Cos[sS57,905 Apr-11 �$ 89,292.43 PromoE27,556,Adv $273, Emplay Cos[sS64,463 May-11 5 103,872.51 �PromoS47,867,Adv $623, Employ CostsS55,383 JUII-11 � $ 85,872.18 �PromoS4t,432,Adv $650, Employ CoslsS43,794 Ju1-11 � S 264,904.13 ;Promo530,896,Adv $6, Emplay CostsS43,7o3 Aug-'k 1 �� i 48,878.43 �Pmmo560,785Adv $0, Employ Costs346,093 Sep-11 �$ 65a,046.00 ;Includes 3559N far NGV funding Interest :v - : $ 1,92fi.44 ; $ 1,920.40 ` : $ 1,729.81 ° $ 1,607.76 = $ 1,074.55 � ; $ 711.57 ' � $ 528.fl2 ` $ 489.01 = � $ 345.45 ; $ 1,1fi0.22: : $ i,2os.2� : 1 Total ECA 94,849.72 98,425.94 5fi,436.19 85,382.48 02,707.58 90,004.U0 04,400.53 8fi,341.19 Total ECA ; Overage __ __ Billed j (Shorta ey - ;$ 96,941.19 $ (385,287.24} j $ 96,05fi.4fi $ 1,206.74 i $ 136,544.02 S 38,118.08 $ 186,846.fi4 I $ 24,41p.45 � $ 192,024.24 $ 106,fi41.76 � $ 175,303.D2 $ 72,595.44 ; $ 126,745.6fi , $ 36,7i1.66 ; $ 14$,20D.87 i $ .-_--- 11,840.34 � $ 191,054.96 : $ 24,713.77 . $ 102,295.42 � � _ (162,954.1 fi}' $ 16a,828.741 � (9,209.91 } � $ 1'ia.924.23 S f540.282.Q41 $ Page 2 of 4 Camulati�e ECA YFD Overage NGlTharm (Shortagej ° LP1Gal._ (385,287.24J Q.10l0.1f} {384,osn.say: o.�ao.�a {345,962.42); D.10f0.1Q {321,551.97]� 0.1010.10 (214,914.21) 0.1310.13 {142,314.77)' 0.1310.13 (105,603.12j - 0.1010.10 _ (93,802.77j 4.i21D.12 (fi9,089.DDj; Q.12l0.12. (232,043.16}: _0.1210.12 {241,253.07) : 4.1210.12 [781,535.10}--- 4_12l0.12 r� 3 - ' � ! V I�J�]J. I V � ! U I�JUJ. 1 4f i� � Total YT�': $_ 2,368,59t.06 '_ _� 12,&79.49 � �$ 2,321,270.55 �$ 2,321,270.55 I$----- i -_--- _ _ i- i _.. _— {1} i kncludes Annual Admin Chg of $47,68� + CCS chg of $55,3fl0 + Dividend of $89,090 = {6] = Transfer ot ECA Col�ected in PGA 112 of the ECA Rate [u to �CA Annual 5hortfatl] ;+ FY 09l10 Write off af $2,843.99 +$200,000 SNEP = �$ 374,113.99 . Note: Maximum amount vuhich can be transferred = $ 759,867.72 - - I . - -- _ -- - - (2}:FYTO 50"write oif adjusfinenf = ' 93,406.67 ; ; I. ' - �-----Y -- T --- - _ ___ :�Y11 SO write off adjustmenf = _ __ _ _ 97,504.35 ' i __ -� _ ; _ _ _ � _ _ _ =-- -- --- - - --- -- -- �-- - - - --- -- -- ..__. .. .---- - -- ---- _ _- __-- -- _- _ --- i _- _-_T r . _ ' _ __ _ _ _ __' _ ___- __ _ __-_- .___-."____-_-_. _- - �` _ --' I _-- �__--_ - - ____ ' _ _ _"_ .__.__ ' ______--_- _ ' - ! - __ _ __-__ _---_ _ -_ '_ __'_'---" �'"-" -__--_"-_ __-_- - i _ _ �__ "__"-_' __-_J _ ' _ ' � Net CCE _ � 1,743,5fifi.fl5 � _ _ - ---- - - - - - --- -- - - ---- -- --- --- -- - � - - - --- � - -- - � - -�- - i -- - � ' � - - - - --- - ---- --= - --- ' - - - - - -- - - ----- - - � -- - -- - - ----- - -- - � i — —=-- -- - --- - - - - - =---- --- -------- ----=--- ' - - - - -- - - - - ---- REGULATORY IMPOSITiON ADJUSTMENF�RIA�__ __ __ _ _ I ________ _ _. __ __ _._ .._ ___ . -: �. _ - — _ `(EIAf ` _" :.�-:-{DRA=P_:e_` -- - - - - - -- - - - --- -- < - -- - - - - • -- -- -- - Budget Enylronmental _ _ ''�:�i ` � �':�.` Interest _ Total EIA __ _ __ Total RlA � flverage YTO Overage _ NGI�'herm _ Month Expen$es_:' NoteslExceptlonalltems_ _ =-�E �ses`?>-; Expense Expenses __ __ B1ped (ShorEage} (5horta e_�__ LPlGaI._ Prior Year ' ��;.r= _= _ _ -- -- -- - --�;-` �-°�' - _ ' $ - ; $ 82,519.09 i - Oct-10 $ : ` �'�;3$�.37 = -: <=4F $ - 1 I $ 23,385.97 18,238.59 _ $ [5,147,38}; $ 77,371.71 4A210.02 �--=--, �- - Nov-14 $ �;30fi.00 _ _ __ � ���,:� ��-[� $ - 3,3a6.OD ^ 19,21Q.43 _ $ __ 15,904.43 $ 93,276.14 - 4.0210.02 Dec-14 . $ -- 423,438:60_ - - - -- - - :�=�e:y=: - _.�-:� $ --- - - - 2 -- - 423,438.a0 i -- 27,348.20 � {398,129.84} $ [302,853.fi6J ` 4.0210.02 ';�:q:- :.. _� .: Jan-11 $ {'18,235.,18} :�;4=� Y.�-.;,.p,;:_ _ $ 4,514.27 {96,720.81Ji_ 36,168.'E5 '- $ 52,889.06 I $ _ _ _ (249,964.fi4} 0.0210.02 Feb-i1 $ i,491.l�0 - - _--- - - - _���_'Q; $ 1,249.82 2,740.82 44,276.28 ; $ 41,535.46 ; $ (208,429.14J Q.03l0.63 ��-���>� _, _ � I_ Mar-i 1 $ {4$;�48,9$] - ------_ _— -- - _-� �"�0- S _ i,042.45 , {17,206.81 j I 40,451.44 ' $ 57,658.25 � $_ {150,770.89j' 0.0310.03 Apr 11 $ �;43T OIT � . _ � ^ � � $ 753.85 � I 2,839.25 : 56,5fia.14 : $ 47,72D.89 {103,054A0) D.0410.04 �- - - ---- --- -- ------- -; ��:�.,;. ,- - - - - --- ! Nlay-11 $ 9.350.74 -�. -'x�;,�3�20; $ 5'E5.25 � 11,405.99 � 99,454.'E8 �$ 8,448.98 {94,603.41j 0.a210.02 _ -�i��-: - ���33' -` 1�,621.2&} 98,509.53 � $ 29,130.78 , $ {65,47a,22 O.a2l4.fl2 ! Jun-11 $ {1 i,094:27 - ----- --- - .� --. -;: __ . . $ _ 4J3.a1 � - � ------ _ -- .:_•,.�,.-- - { -� }-- ---- - ----- � � Jul-'f 3 $ {8,705.68) --- - - " � � ---- -- •�: ._�.r- = $ 327.35 ; [8,378.33}� 17,048J8 $ . -25,427.i1 ; $ {40,643.11j'_-- 0.0210.fl2 . -.-_.-- --_:�� _'. `:"",i �.:.=.`_k'".: . _- _ '".__ ._. "' . _-_-_-_____ _- _ i Aug-'E1 $ 'E,491.a0 - _ - ---- - - -- --- s:.;_._'z�'=.��;-�_- $ -- --- 2Q0.22 i 1,691.22 16,794.89 $- - 15�1fl3.77 � $ {24,939.33j�-- 0_0210.fl2-- -- - 5ep-11 $ . {15;000.00}.- _ __ - _- - _- _- ';=:': -= 5;000=00 5 124.70 i � [9,875.30); 18,492.35 ; $ _ 28,367.66 ; $ 3,428.32 I 0.0210.02 P13 -, - - - fyix==��;e_ ,�_- i -t-- - --� � - _ i $ 3,428.32 i --- , _ - -=•--•- -� �: . _ _ .: -� _ �- i j - ' ; �w - � $ 3,428.32 ! . . :_ - �_ __�.__.-�-�_ ` -- ---__ _ ---- - - - , - ------ -� - - --- - - - Total YTD- $ 392;869.$2 _ _ _ _ _ _ _ _ _ _ __ _ __ $ fi;533.8D _ $_ _ _ _ fi,200.61 �_ ; 405,603.83 i 326,513.08 ':. � [79,080.77 ; --- - -- - � - -- - - - -- - ---- ; I ; I --, - ---- � - - - ----- (1}! EIA �ncEudes Annua! Admin Charges of $10,330 ` � � � - -- --- _--- — , � + - -' - -- -- - - - - - _;. _ . .. _ ;+ FY 09l10 Write oFf of $316.50 = !$ 10,846.50 � i ; � - - -2 � --- ------ ' - -- ------ -- - ' (}� E!A includes Arcadis PO for remediation costs for MGP = '$ 421,440.00 ! I --- - - --- -- - -- � --- ; - - I --I ------ - .. . - - - - - -- ------ ------Net CCE _ ! $ 32,fi83.28 ; --- -- ---- �-- C�EARWATER GAS SYSTEM SUMMARY �F RATE AD.iUSTMENT CLAUSE C�LLECTlONS FOR FY 20'i012011 -- ------ ------- -- - Interest - _ _ LP Gallons; Expense RatelGallon IBeg. Bal. ; i I. - - -- - -------- Oct-1D i �- - 5,979.4 i$ - � - --- - -- --- - - ----- ' -- Nav-3 0 i � 6,fi67.5 � $ _ _ _ _ - -- ----- - --- - -- - Oec-10 � - - I 7,985.8 $ - Jan-11 - - - -- --- -- -----9,583.3 $ 1,74U.79 - +- - � ------ ---- , Feb-i1 --- _- 8,477.7 $ 1,575.63 � M -ar 11 --- -- -- --- -- -- 7,506.4 $ 1,332.78 I I Apr-11 7,'�04.2 $ 1,094.8fi � i_May-11 - -- --- - - -- 8,699.2 , $ Sfi1.02 � Jun-11 i B,8D7.4 j$ 678.U5 �- -- --- ---- ' -- --- - Jul-11 j � --_-__- 4,380A ;$ 501.7D 'I _ _Au�-11 i i -- - 5,517.3 ' $ 336.18J- Sep-91 ; I 5,8fl0.Q : $ 172A7 ; Per 13 _ - '-- - Tofal YTD' -- - , _ ___ _ __-- - 89 ,7Q8.2 ; _8,293.09 4 i = - - -- I -- - �- ---- - ----- -- � - -- -- - - - ------- � USAGE AN� INFLATEON ADJUSTMENT �,UlA3_ _ __ ; Rssldentia! i _ Budget : lnterest Month ; - ---- -- --- - --_- -- - - LP Gaifons Ex�ense__ _RatelGallort - ' -- --- --- Beg. Bal. ' � -- ----------- -- -- -- 1----- -- - -- - Oct-10 ; 27,387.0 ! $ - - - - -- - - - - - - --- �-- --- -•--- Nov-1fl : � 25,9B7.2 : $ _ _ ----- ------�- --- ------ - - -- - = - Dec-10 -- 33,749.7 $ - ' Jan-i 9 - -- i --- - - - - 40,847.9 $ 243.94 j- Fe5-11 - - - � - -- - ----- - 26.7fi9.8 ! $ 175.17 -- Mar-11 ---- - - - - ---- --- -- ---- 36,632.2 ' $ --- - 125.5 - Apr-1 i --- -- - - - - _ --- - - - 26,547.9 � 85.47 � _ May-71T ---- --- --- - -- -------- 17,895.1 $ 53.87�; -- -- ------ --- -- ------ Jun-11 24,366.9 ; $ 3fl.39 i -- - - - --- - - -- - - Jul-11 : 17,913.9 I 5----_-_ 8.50 ' Aug-� 1 -,- - - - - - �- - -- - --- - ----1 fi,482.7 : g --------- - - -- -=- - ----------- - ' ----- - -- Sep-�1 ; - _-- - 17,aaa.o ; $ - - -- Per13 -- - - ----- Tota3 YTD j 305,590.3 ' 723.fl6 - --- --- ----- --- - - -- � I ; - - -- - - --- - - - -- ---- -- --- --- - - - - -------I ------- ---------_ I---- --- * i � - - -- ---- --- - _--... -- -- - -...__------- -- � - - -'.. -- --- = ----- -- -- - - ---- -----I - = -- - ----� _--- -- ----- --- - - - -- - ---- i -- -- - - -------�----- � -----�-- --- - I - _ �_ � � i i -- --- -- - -- - ---- - -- - �-- � - - � � -_i______-' - _- _ ____-_' ' ___ _-"_ _' _' _ -- " i ---- -- - - � - - --- . , - � -- --- --- -----__--- � I 0.03 a.os a.ae o.as 0.05 0.05 0.05 O.U5 O.U5 _�_ --- �- - �-- _ 0,02 ; - _ 0.02 � a.oz : o.az =- o.a2 ; - 0.02 0.02 U.02 -- 0.02 ; NG Therms __ ; RatelTharm � 889.076.70 : 1,141,753.86 967,797.20 : 944,889.30 928,?91.04 72fi,200.40 699,134.40 657,755.90 ! 651,167.70 i , Page 3 of 4 , --�- -- ------ - --_ - ---�--- ---- - - j Monthly CumuiaH�e 111A O�erage ' YTD O�erage NG!'Therrn � horta e{�j _� _ {Sfiortage) -_- , LPIGa3 -- -- ! $ [348,159J4}:- --- _ - - ' $ $ (348,159.74}I D,D410.00 $ - - $ (348,i59.74}j ❑.fl61D.00 - $ 1.41 i $ {348,'l58.33}': 4Aal0.OD 0.03 � 33,031.5fl i $ {315,126.83}; 4.0310.03 0.65 � $ 48,569.B5 � $ {266,556.98} 4.0514.Q5 0.05 � $ 47,58478 ; $ {298,972.20}; 4.4510.05 0.05 $ 46,768.58 ; $ {172,203.81}: 0.6514.05 4.05 I $ 36,593.Q3 ; $ {135,610.52}: O.Q514.05 0.05 j $ 35,27D.65 $ (100,339.87}; O.Q5f0.05 4.05 ; $ 33,102.92 ; $ {87,236.95} O.Q5I0.05 4.fl5 i $ 32,823.Si � $ [34,413.14j 0.05lD.05 0.05 I $ 33,280.OD $ {1,133.14)' 0.05I0.05 � $ {1,133.14) ---- ' - -- ; $ 347,U26.fi0 - -- -- i- --- -- - ' -= - --- --- = - - ' __�_ _ _� Monthly __: Cumalative UTA t _ _ _ _ _ _ _ � _ Overage YiD Overage NG1Therm � NG Therms __ _ RatelTherm � (5hortag� ! {Shortage} _ LP1Gal ------ - , - -- � - ---- � � $ �48,828.37] . - _ � _ 'E88,328.90 � -- - -- _' � $ -- ----- � $ - -4[ 8,&28_37J: 0.0010.00 -- 217,344.30 ` _ ; $ _ - � $ - - {48,628.37};_ - 0.00J0.60 -1-- - - -- -_-_ 394,544.90 ' __ - , $ - $ _ {48,fi28.37j' D.0010.00 657,59fi.66 : _ __ DA2 ;_$ 13,$38.39 $ _ _ (3b,033.12J � 6.0210.02 477,935.30 i 0.62 $ 14,1 D1.88 $ {25,1 fl6.41 J_ 0.62I0.02 36fi,050.8D ' 0.62 ; $ 7,937.66 :. $ �17,294.34}; _0.6210.02 r 303,719.80 � U.02 ;$___fi,606.67 $ (14,774,14}i 0.0210.02 ; 219,279.70 0.02 : S---. -- 4,75fl.69 f$ {6,fl77.32)' _ O,fl210.02 -- 195,715.70 0.02 ! $ __ 4,408.43 �$__- {9,699.28J; 0.021Q.a2- - -- i72,537,20 �fl.02 $ 3,811.37 j$ _- __ 2,903.60 ; 0.02Ifl.02 �_ 167,427.40 � ---- O.fl2 ; $ - -3,67d.40 ; $ 5,774.OD � d.02l0.02 _ 170,OOa.00 ' 0.02 '$ 3,740A0 i$ 9,514.00 ' O.d2l0.02 -- �--- -r $ 9,514.00 - - ----- 3,530,361.66 ' ! $ 58,865.43 ' - ; ----- � -- i---- i -- ---- - -- - - --- i --- --- � -- - -- - �- - - - � � -- - I- I - - - - --- { - -- -- I ' ---- -- - � -- --- -- - - �-- �- --F----- - - - - - - I - - --- -i --- i-- � � �--- '-�---- . . � _1-_------ - - ' CLEARWATER GAS SYSTEM Page 4 of 4 . SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION5 FOR FY 2010/2097 . � � TOTAL ALL C05T RECOVERY ADJUST�VIENT CLAU5ES iBoth PGAs + ECA + RIA+UTA�I ____ � i _ � i ! ! ! Nianthly___ ;_ Cumulati�e Total Resl =----- Budge it ; � Totai All ! TataE Recovery j Overage ! YTD Overage i NGlThm (Firmj Month _ I___ __ __ � Ex enses i _ BIRed (Shortagey ! =Shortage} ; LP1Gal (Resl} Prior Year i I ; - - ; $ - ; � {250,360.42 i Oct-10 -- - -- {---- — ----- - - � �,- ' -- ---- --- � - -- ---- - � $ 4,877,830.43 � $ 1,405,929.59 $ {3,471,908.92}` $ {3,722,269.34}i 4.9912.02_ �—� Nav-10 � _ .-- ; I � $ 1,244,837.06 i $ 1,523,8a7.42':- $ 278,970.36 ; $ {3,443,298.98j; 0.9912.02 -- - --- -- --__.. . - ------ - --- Dec-16 i__ -- - __- _ _- - --- - -- — -- - -- I � ; $ 1,842,814.fi9 ; $ i,900,777.28 ; $ 57,962.59 , $ {3,385,33fi.39}; 0.9912.02-- Jan-11 � - '- ;- - � $ 2,199,147,14 � $ 2,fi32,698.34 � $ 413,559.26 � $ (2,971,785.i8} '1.0612.33 = - ---'-- - ' ------- --- - � Feb-1'k : _ - :- - - - I. ! ' ' $ 1,563,372.39 � $ 2,251,t08.4fl I $ fi87,736A1 $ (2,284,D49.'E7] 1.6712.37 --- � ' Mar-'f1 : -- i -- i -T ; i $ 1,343,267.67 i $ 2,077,266.62 $ 733,998.95 $ [1,550,050.22)! 1.6712.37 ---- --.._--- --- ---1 -- - Apr-91 : ---�-- — — — i ___ _� � $ 1,450,823.33 $ 1,850,677.36 � $ 399,854.03_ $_ [1,?50,196.19} 0.98I2.28 - May-11 ---- - - �- - - -- ----4------- - i $ 825,629.56 $ 1,443,fi16.44 ; $ 613,985.88 $ {536,209.31} 0.97l2.35 Jun-91 --_- ------- -- - ----- i - --- - ---- ; ; $ 914,894.81 $ 1,443,561.78 ' $ 528,666.97 $ {7,542.35J 0.97l2.35 _ Jul-19 : - -_ _ -_�_ ---- ; $ 9,195,Q48.48 $ 1,331,170.49 = $ 935,122.01 $ -- 128,579.66 ; 0.97l2.35 Aug-19 '- _- ----- - - - ; $ i,1i4,724.fi2 $ 1,320,944.95 : $ 206,22fl.33 ; $ 334,799.98 0.9412.46 Sep-31 i - ------ -- -- � , $ 1,678,249.84 ; $ 1,319,629.84 : $ (358,fi20.03}i $_ {23,820.04};__ fl.9412.48 Per 13 ! -- -- ��$ 787,303.73 � $ 783,535.1Q ; $ 5,1fi8.fi3 � $ 29,588.87 - Total YTD° --�-- -- — — I I 21,041,943.75 29 262.795.51 ; $ 224,771.75� ' - - - - -- �-- - -- I � -- -- — — ' � - i ---� . i - - - ---- -- - =Ti------- - ---- -_-- - - � Last Updated 09129f201 i ocl-1 1 NoV-17 oeG�� Jan-72 Feb-12 Mar•12 Apr-12 May-12 Jun-12 JuJ-12 Aug-12 Sep-32 Total /� i I�G�fA�i�IJ� xt' Z CGS iVaturai Gas Cast ActuaUProjections FY12 asof 814Y104S 2,64f,833 57U,393 266,700 9,095,726 [430,�OOj [$154,004.00} 2,917,100 0 2,689,000 700.00% OD% $5.42 Total $1,240,076.41 Z409,827.37 S7fl,355.29 ;38,72274 $4,220,9i ;72,075,98220 S • $344,858.96 $124,980.00 83.0% 69.4 % $13,586,23727 Tota! Projec[ed �TH WACOG 7otal Reservation Tofal Commodi Cost Purchased �sl6Monlhs E 3,034,904.44 E fi,783,603.86 $7,760,SOB.33 '1,203,500 y6.94B 2nd fi Months S 625 350.63 E 5,3i6 37B.33 55,825,T2B.56 913,600 $6.3T7 � TOTAL � $7,fi60,255.07 $ 12,079,982.20 E93,5Bfi,237.27 2,t17,106 $6.42 Prapane FY 2012 Projections Delivered Delivered Deli�ered Cast Total Month CGS Cost Gal�ons Cost of #nver�to Galions Jui-11 == "-_`-_`���= � ��.�j= _-�`;�.-.=_':,,�, - - - _ - � . . � - _ _ � ;��.�� - -s �=� Aug-11 $ 1.80�~ �30,000 $ 54,D00.00 $'f 01,805.12 57,389 Sep-11 $ '1.80 30,OQ0 $ 54,00�.00 $ 102,586.fi7 57,389 Oct-� 1$ �.75 32,000 $ 56,0�0.�0 $ � 04,959.67 59,389 Nov-11 $ 'E .75 40,OQ0 $ 70,oaa.ao $ 1'E8,405.27 67,389 Dec-11 $ 1.75 52,0�0 $ 9�,000.40 $ 139,123.61 79,389 Jan-12� 1�5-- ��4�0 $ 7�,25a.00 $ '�23,247.29 7a,389 Feb-12 $ 1.75 38,000 $ 66,540.00 $ 114,45fi.64 65,389 Mar-12 $ �.75 34,000 $ 59,500.40 $ 107,441.59 fi1,389 Apr-92 $ 1.75 32,OQ0 $ 56,000.40 $ 103,935.59 59,389 May-12 $ 1.75 30,400 $ 52,500.00 $ 140,432.98 57,389 Jun-12 $ 9.75 28,000 $ 49,OOQ.00 $ 96,93'i.89 55,389 Juf-12 $ 1.75 28,040 $ 49,�a0.00 $ 96,931.28 55,389 Aug-12 $ 'E .75 2$,000 $ �9,QD�.00 $ 96,931.Q1 55,389 Sep-'! 2$ 1.75 30,4D0 $ 52,54�.00 $'� 00,430.88 57,389 814l20'! 1 � 1"T'J��M� � �'.3 UM I an Galions - �--- 27,389 27,389 27,389 27,3$9 27,389 27,389 27,389 27,389 27,389 27,389 27,389 27,389 27,389 27,389 �M Tank Pra�ectec Cas# WAC�G $ 47,805.12 $ 48,586.67 $ 48, 959.67 $ 48,405.27 $ 4$,123.fi1 $ 47,997.29 $ 47,956.64 $ 47, 941.59 $ 47,935.59 $ 47,932.98 $ 47,939 .89 $ 47, 931.28 $ 4i,931.Q1 $ 47,934.88 $ 47, 930.81 1.77 'f .i9 �.7i 1.i6 1.i5 '[ .75 9.i5 1.i5 1.i5 1.75 1.75 1.75 1.75 1.i5 ' csw:osrasizo�� ATTACHMENT #4 Page 1 of 2 PURGHASEb GAS A�JUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD QF 10/01/2011 - 09/30/2012 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) _ $0.080 II. Calculation of the Required Natural Gas PGA WACOG for FY 11/12 A. Therm Sales Projection for 10/1/11 - 9/30/12 = 20,830,000 B. Projected NG Reservatian Cost 10%1/11 - 9/30/12 =$ 1,650,000 Projected NG Commodity Cost 10/1111 - 9/30/12 = $ 12,000,000 Budgeted Other Supply Related Expenses = $ 3,600,000 Total Recovery Needed for FY 11/12 only = $ 17,250,000 Less ProjectedOver Recovery of FYTD PGA thru 9!1 $ (100,000) Total Annualized Recovery Needed for FY 11/12 = $ 17,150,Op0 G. Required Weighted Average Recovery Cost/Therm =$ 0.823 Currently overall PGA Recovery is: 96.0% of Firm Rate Therefore, Firm PGA needs to be: $ Q.86 Which makes Contract PGA: $ 0.78 D. Projected,NG PGA Annual Revenue = Pinellas NG PGA = $ 14,244,294 Pasco NG PGA = $ 2,905,7p6 7otal NG PGA = $ 17,150,000 III. Proposed Natural Gas PGA Billing Factors for 10/1/11 - 9/30/12 PGA On� ECA in PGA Tatal PGA A. Proposed Standard Rate PGA Billing Factor $ Q.86 $ 0.06 $ 0.92 B. Less Non-Standard Differential for Reservation Cost $_ (0.08) $ _� $ (0.08) � .— C. Proposed Non-Standard PGA Billing Factor $ 0.78 $ 0.06 $ 0.84 � PGA Onlv" ECA in PGA Total PGA IV. Proposed LP Gas Billing Factors for 10/1/11 - 9/30/12' $ 2.40 $ 0.06 $ 2.46 (Assumes current LP market canditions persist) Note: Includes 12 cents/gallon catch-up to recoup $50,000 projected under-recovery from 415,000 gallons over the year & 52 cents/gallon to recoup the $215,QD0 of Admin & CCS projected charges. Base est. was $1.761gallon. U:\My Documonts�EXCELIGASRATES\FY 11-'121[PGA for FY 11-12.xlsx]PGACALC C56V:69l29f2011 Billiog Month �ep 2010 Oct 201 D No� 201 a Dec 201Q Jan 26i1 Feb 2011 Mar 2011 A}�r 20'! 1 May 2011 Jun 201'I ,lul 204 t Aug 201'E iataf 9l76-8l17 °Io of Total Tota4 Therms 1,449,177 1,482,872 � ,579, 031 2,019, 503 2,539,460 2,209,980 2,028,829 1,950, 338 1, 558,794 1, 544,289 1,447,'f 29 1,470,960 21,25Q,162 100.0% ATTACHNlENT #4 Page 2 of 2 CLEARWATER GA5 SYSTEM ANALYSES OF STAN�Alt� VS. NdN-STANDARD THERMS & RESERVATION CHARGES FOR 08101120D9 - 67l31I2010 Subtotal Subtotal Het Net Charge Per Charge Per Interruptible 9�e Caotract 9'o NonStandard 9'o Non- 5tandard °/a Reservation 5tandard Non-interruptible Therms Interrupt9ble Therms Cvntract Therms Standard Therms Standard Charqes Therm Therm 413,162 - 29.�°Io-- 17$;438- 1-2:-7-%--59a;660- - 42:6°/0- --817,57-7- -58.0% $- 94�470.54 $ 0.115 $ -- 0.095 405,515 27.4°/0 199,74D 13.5°k 605,255 40.8% 877,417 59.2°/0 $ 128,134.52 $ 0.�46 $ 0.119 445,483 28.2°/u 204,353 12.9% 649,84$ 41.2% 929,�85 58.8% $ 211,726.13 $ 0.228 $ 4.187 429,436 2�.3°/a 265,258 13.1% 694,595 34.4% 1,324,868 65.$°/0 $ 75,857.24 $ 0.057 $ 0.048 463,018 18.2°/a 316,911 12,5°/a 779,929 30.7°/0 1,759,531 69.3°/0 $ 195,081.12 $ 0.111 $ 0.494 477,898 21.6% 286,159 12.9°k 764,057 34.6°r6 1,445,923 65.4% $ 193,849.51 $ 6.134 $ 0.132 442,538 21.8°/u 275,267 13.6°/0 7�7,805 35.4% 1,311,024 64.6°/a $ 2i8,053.83 $ D.166 $ 0.137 471,730 24.1% 256,056 13.1°/0 727,786 37.1% 1,232,552 62.9% $ i3�,419.26 $ 0.1D7 $ 0.088 408,787 28.2% 289,893 18.6°/0 698,680 44.8% 860,114 55.2°k $ {202,302.D1) $ (0.235) $ {0.976j 430,874 2?.9°/0 218,087 14.1% 648,961 42.4% 895,328 58.0°/0 $ 89,954.49 $ D.�QO � 0.081 447,210 30.9°/0 9fi9,25fi 11.7% 6i$,4fifi 42.6°/0 830,863 57.4°/0 $ 96,275.54 $ 0.116 $ 4.09$ 441,723 30.0°/0 290,127 14.3°/a fi5�,85Q 44.3% 8�9,110 55.7°/0 $ 91,405.24 $ 0.992 $ 0.089 5,277,384 24.8°Io 2,8$9,545 93.5°Ia 8,14$�930 38.3°/0 13,103,232 69.7°/0 $ i,323,fi17.�1 $ 8.101 $ 6.0829 # 24.8°/0 43.5°/0 38.3°Io 67.7°/n For Comparison Tota18l09-711Q 23,7fi0,45i 5,230,19� °/o of TotaE 10a.0°/o 24.0°/0 24.�°/n 3,010,202 13.8°/0 8,240,393 37.9Wo 13,520,058 62.1°/n $ 1,404,003.93 $ 6.104 $ 13.8°/a 37.9°/0 62. 3 °/o Change (5'f0,289} 47,193 D.B°/a {940,fi56j -U.3°Io (93,463] 0.5°/0 {416,82fi} -0.5°Iq $ {80,386.82] b (O.dD3] $ °Io Change -2.3°Io 0.9°Io -4.7°/a -1.i°Io -3.i% -5.7°/0 Nofe: # lt is recommended that the "Charge Per iVon-Interruptihke Therm" differentiai be rounded to the next 3owest penny or $0.08� for the FY i 11'f2 annua� cycle. 0.6849 �0.002�y U:hMy DocumentslEXCELIGASRATESIFY 11 �121[PGA :or FY 11 �12.xlsx]PGACALC CSW:09/29/2011 �NERGY CONS�RVATION ADJIJSTMENT (�CA) & REGULARORY IMP051TION ApJUSTMEN7 (RIA) CALCULATIONS FOR 7HE BILLIN.G PERIOD OF 1p/Q1/2011 - 9/30/2012 ATTACMMENT #5 I. Calculation of the Energy Conservation Adjustment (ECA) R�quired for FY 11/12: Pro�ected ECA Re uirements forIIFY 11/12 onl 1 q y = $ 2,OOO,p00 Projected Administrative & CCS �harges to ECA for FY 11/12 = $ 600,000 Proj�cted Current FYE 10/11 (Over) Under Recovery of ECA = $ - Total Annu�lized ECA Recovery Needed during FY 11/12 = $ 2,600,000 Less Projected ECA Recovery within PGA @$0.06/Therm or Gal = �g00,000) Total �CA Recovery Needed from Standard Rate Customers = $ 1,800,000 Projected Therm Sales for FY 11/12 Applicable to ECA Recovery = (Natural Gas @ 62% Standard =�,12,900,000 therms & I..I' @ 100% Standard = 415,000 gal. or 13,31''�5,000 Tatal Applicabl� Therms) Computed ECA Recovery Factar Necessary = 13,315,p00 $ 0.1352 Propose Rounding ECA Recovery Rate to $ 0.130 Annual ECA Revenu� Projection @ Proposed Recovery Rat� _ $ 2,530,95� � II. Calculation of the Regulatory Imposition Adjustment (RIA) Required for FY 11/12: The RIA is actually a combinationl of the Environmental Imposition Adjustment (EIA) and an adjustment factar for new regulatory impositions (ORA). Budgeted RIA Requirements'` foriFY 11/12 only = $ 240,000 Projected Current FYE 1�/11 (Ov�r) Under Recovery of RIA = $ - Total Annualized RIA Recovery Needed during FY 11/12 = $ 240,Op0 Therefore, RIA needs to be for FY 11/12 = Round Proposed RIA Recovery Rate to Annual RIA Revenue Projection @ Proposed Recovery Rate = ' Note: Budget based on $180,000 projected EIA requirements + $60,000 projected �RA requirements U:1My Documents\EXCEUGASRATES\FY 11-12\[ECA 8, RIA for FY 11-12.x15]Sheetl $ Q_Q18 � o.oz $ 266,3pp CSW:D9I29l20� � Applicable Annual Therm Range or Other Rate Determinant Monihiy Customer Charge [For Cen[ral Pasco Territory] Non-Fuei Enerpv GharaelFherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA] Regulatory Imposi[ion Adj. {RIA) Usage 8 Inflation Adj. (UTAj Total Non-Fue1 Energy Charge Purchased Gas Adjuslment (PGA] Total Energy ChargelFherm Minimum Mon[hiy Bil4 (For Centrai Pasw Terri[ory} Compares to LPlGaElan Rale o[ with 6.0°/o Franchise Change irom 1I2006 Therm Rate % Change from i12006 Therm Rate Utili[� Tax Note: Fuel Rate per Therm 1 0101 11 973 Non-Utilfry 7axa6Ee FueVTherm CLEARWATER GAS SYSTEM NATURAL GAS RAYE 8lLLING FACTORS FOR OCTOBER 1, 2011 - SEPTEMBER 3a, 2012 BASED OA1 APPI28VED GAS ADJUSTMENT FACTORS Flrm IVatural Gas Rata Schedules RS SMF MMF LMF SGS IViGS LGS RAC GAC LAC SL SL wIM& NGV tClosad 1109) Reiipht (Non-Reslj NA (1 - NA {4 + NA [4 + NA {4 + 6- i 8,Oa0- 1QD,000 NA {1 - NA [0 - NA (150 NA NA NA 3 Lfnits) Units} Unitsj Unifs] 17,999 99,999 8 up 3 Units} 949 tons] tons &+j $}O.DO $25.06 $40.00 $95.00 $25.00 $4D,00 $95.00 $10.D0 $25.OD $4D.00 S20.OQ $20.00 8y Contract {$18.DOJ {$40.00j ($70.00j ($180A0] (�40.00) [$7�.00J [$160.00} [$18.00) ($40.00J ($70.OQ] ($30.00J {$30.00j (By Contract} if not pre�. if not pre�. if not pre�. billed billed bi€led $0.48 $a.48 $0.48 $Q.48 $0.4G $0.40 $0.34 $0.20 $0.15 $O.iO $6.20 $0.35 By Contract D.13 0.13 D.13 O.i3 0.'E3 0.13 0.'13 NA NA fVA hfA NA NA 0.02 0.62 Q.D2 0.02 0.02 0.02 6.02 NA MA NA NA NA NA - 0.02 Q:02 0.02 0.62 0.05 D.OS O.U5 NA NA NA NA NA NA $0.65 $0.65 SU.65 $0.65 50.&6 $0.60 $0.54 $ff.20 $0.15 $fl.10 $0.20 $0.35 8y Contract 0.82 0.82 O.B2 D.82 � 0.82 O.H2 0�2 a.82 �82 D.82 Q.B2 � 1.47 7.47 1.47 7.47 f.48 1.42 1.3B 1.02 0.97 0.82 1.Q2 1.17 U.74 + Non-Fuel 51D.D0 $25.00 $40.U0 595.00 $25.00 $40.D0 $95,OQ $10.OD $25.Q0 $40.00 $20.00 $20.00 By Contract {$18.00) ($40.00) ($70.00J (S1fi0A0] [$40.Q0] {$70.00} ($160,Oaj ($18.00) ($40.00) {$70.00} ($30.00} [$30.06) [8y Contract) (� premise Q premise Q premise + FAC + FAC + FAC $ 1.35 $ 1.35 $ 1.35 $ f.35 $ 9.35 $ 1.30 $ 1.24 $ 0.93 $ 6.89 $ 0.84 $ 0.93 $ 1.Q7 5 $ 1.43 $ 1.43 $ 1.43 S 1.43 $ i.44 $ �.38 $ 1.32 $ 0.99 $ ff.94 $ D.89 $ 0.99 $ 1.13 $ 5 (Q79) $ [0.79j 5 (0.79j $ (U.78J $ {0.67] $ (Q67J 3 (Q.87) 5 (0.86) $ (0.86) $ [6.88} $ [0.86) $ {0.83} $ -35.0°k -35.095 -35.D°/o -35.0% -39.2°k 32.1 % -33.0% -45.7°/0 -47.0°/0 -48.3°/0 -45.7% -40.9% 5D.069 5D.D69 $0.068 $0.069 $0.069 $a.069 50.069 $0.069 $6.069 $0.069 $0.069 $D.069 $0.751 $0.751 50.751 $0.757 $0.751 $0.75t $0.751 $D.75t $U,757 $0.751 $0.755 $0.751 Interc. NG Rate N5S IS (Non-Resl} NA 100,009 & up $50.00 S25fl.00 [$75.00) $400.00 Attachment #6 Contract NG Rate CNS NA 8y Contrac! {8y Contrac[} $0.46 $0.28 By Contract NA NA NA NA NA NA !VA NA NA $D.46 $0.28 By Con[ract 0.82 D.74 0.74 1.28 t.02 074 + Non-Fuel $50.00 5250.00 Customer ($75.D0} $400.OD Charge + + FAC + Non-F�ek Therm Non-Fuel Therm Rate for Contract Rate 4or Contract # of Therms # of Therms a.68 $ 1.17 $ 0.93 o.�z $ �.2a $ a.ss ti.aaa s {o.a�� $ to.72� -58.4°/a -40.5% -41.4% $Q.069 $0.�69 $0.055 $fl.671 5�.751 $0.685 BTi3 FACTOR = TNERMS1700 CUBIC FEET tCCF1 1012011 1i12011 12I2011 61l2072 �212012 63l2012 0412012 0520t2 0812012 07I2012 a8120t2 09120�2 FY11lt2A�eraqe Firm Service Rates 1.035 1.D35 fnterruptible Service Ra[es �.015 �,p�� 5 (o.�z} -49.3°� Sfl.069 $0.67 f C5W:0 912 912 0 1 � Attachment #7 Page 1 of 2 BTU Factor: 2.714 GaHons11Q0 cubic feet (CCF} CLEARWATER GAS SYSTEM BTU Factor: 2.483 Thermsl9D0 cubic feet {CCFj METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 ThermslGalion FOR OCTOBER 1, 2011 - SEPFEMBER 3Q 2092 BASED OM APPROVE� GAS AOJt15ThRENT FACTOfiS RE5IDENTIAL MULTI-FAMiLY LOOP RESL. SMALL COIIRL. LARGE COML. VENiCLE SFAiV�BY1GENERATOR CONTRACT MTRa MFZLA MMLP LRLA 1NGLP MLLP LPV L�ShA CLP (Non-Resl, Only) (Non-Resl. Onlyj App4icable Annual Gaklon Range NA NA NA 0- 2,500 >2,5fl1 NA fVA PIA or Other Rate Determinant {1 - 3 Units) (4 + Units} (1 - 3 Units} (Closed for New Resl. Applicationsj Monthly Customer Charge $�a.aa $25.00 $10.00 $25.00 $4Q.00 $40.00 $50.00 Sef Sy Contract For Each iNeter Non-Fuel Enersav Char�eslGallon: Non-Fuel Energy Charge (NFE}IGallor $1.96 Energy Conservation Adj.[ECAjlGallor 0.13 RegWatory imposition Adj.[RIA}IGal9or OA2 iJsage 8 In#fation Adj. (UTA}lGallon a.02 Total Non-Fuei Charges (NF]IGaI. $2,07 Purchased GasAdjustment(PGAJlGaI 2.46 Total Energy ChargeslGailon �4.53 Nlinimum Monihly Bill �10.00 Utilitv Tax Note: Fuel Rate per Gallon 10/01/1973 0.'E61 Non-Utili#y Taxable FuellGafion $2299 Change from 8l2408 Galion Rate $ 6.39 °!o Change frorn Sl2Q08 GalEon Rate 9.4% $1.90 0.13 0.02 a.az $2.07 $6.80 0.13 O.Q2 0.02 $1.07 2.�C4 2.46 $4.53 $3.53 $25.00 $10.00 0.961 �2.299 $ D.39 9.4°h 4.161 $2.299 $ 0.19 5.7% $6.30 0.13 4.02 � $0,56 $Q25 Set By Cor�tract 0.13 NA 0.02 - - -NA a.o5 rva $0.45 5et By Contract 2.4& 2.46 $296 $2.9� $25.00 $40.04 Q.3fi1 $2.299 $ 0.22 8.0°% a.�s� �2.299 $ 0.22 8.2°/9 $1.Oa Set 8y Contract NA �fA NA NA NA l�fA $9.04 Set By Contract 5et Bv Contract 2.46 2.16 Contract NFE + Contract PGA Customer Charge Any Applicable Customer Charga + Any Applica6le Facifity Charges o.�s� Contract PGA - 0.361 NA � NA $3.46 �so.ao a.�s� $2.299 0.53 9 8.9 °/o Contract NFE + $2.t60 Customer Charge + Non-Fuef EnergyChg. for the Contracted # of GallonslMo. a.�s� Contract PGA - 0.167 PfA hfA CSW:0912912011 BTU Factor: BTU Factor: Therm Factor: 2.i14 Gallonsl100 cubic feet [CCF) 2.483 Therms110� cubic feek (CCF] 0.915 ThermslGallon STAHOAR4 RESiaENTIAL BULF( LP 5ERVECE (Rate Class is Based on Annual LP Gallon Usage Level] BRLP1 BRLP2 BRLP3 �RLP4 Applicable Annual GalPon Range 0- fi6 60.3 - 120 120.1 - 300 > 300 or Other Rate deterrninant 1-3 UNITS 1-3 UNITS 7-3 UNlTS 1-3 UMITS Annual Customer Charge $ 2ia.00 $ 180.00 $ 90.00 S 75.Q0 -- -- -- - Non-Fuel Charnes fNFSIGallon: Non-Fue! Enargy Charge [NFE}IGaI. $ 1.80 $ 1.6Q $ 1.4a $ 0.90 Energy Conser�ation Adj. {ECAjIGaI. 8 0.13 3 0.13 D.13 6.13 Regufatory Imposition Adj. (RIA]lGaL $ 0.02 $ 0.02 0.02 0.62 Usage & Inflation Adj. (U!A)1Gallon 0.020 0.020 D.02 0.02 Total Non-F�ei Charges (NF]1Gal, 5 1.97 S 1.77 ; 9.17 S 1.07 Purohased Gas Adj. [PGA}lGallon S 2.46 $ 246 $ 2.46 5 2.4fi Total Energy ChargeslGallon S 4.43 S 4.23 S 3.fi3 S 3.53 Plote: No Man{hly Minimum BiIE Utifit� Tax Note: Fuel Raie per Gallon 40I01I1973 $ 0.1fi7 $ 0.161 $ 0.167 $ 0.181 Non-Utifity Taxable �ueElGalion 5 2,299 $ 2.299 $ 2.299 $ 2.299 Change irom 812008 Gallon Rate 5 0.390 $ 0,390 $ 0.19 S 0.73 1 Change from 8l2008 Galfon Rate 9.7°/0 10.2°/0 5.5°Io 5.79' Attachment #7 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP] RATE BILLING FACTORS FOR OCT4BER 1, 2011 - SEPTEMSER 30, 2612 BASED OH[ APPROVED GAS ADJUSTMENT FACTORS RESIDENTIA! "WILL CALL" {Based on Annuai Usage Le�el] WRLP9 WRLP2 0-12D >120 1-3 UNITS i-3 UNITS $ 756.a0 $ 75.00 $ 1.6D 3 D.90 0.73 0.13 a.a2 o.az U.02 0.02 S 1.77 S 1.�7 $ 2.48 $ 2.4fi S 4.23 S 3.53 COMiUIERCIAL BULK LP SERVICE [Based on Annual Usage LevelJ BCLA1 BCLP2 0 - 2,50D � 2,5D6 � Customers in this Cusfomers in this Range oF Usaga Range of Usage $ 9Q.00 $ 90.Q0 i $ U.25 $ 0.20 0.13 0.73 a.a2 0.02 0.05 0.05 S o.as � o.ao $ 2.4& $ 2A6 ' S 2.9t S 2.as Bl1�K 5TANDBYI GENERATOR LPSS (Cfosed for Mew Residenfai Applications} $ 42fl.fl0 $ 1.00 NA NA � iVA s �.ao $ 2.46 5 3.46 $ 4.169 $ 0.181 $ 0.161 $ 0.761 $ S 2.299 S 2.299 $ 2.299 $ 2.299 $ $ D.39 $ 0.79 $ 0.47 $ 0.17 S 0 10.2°k 5.7°/ 82°Ia 6.3% CONTRACT BU�!( LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Sei by contract Set 8y Contract NA iVA NA Set By Contract 2.15 Cotraci N�E + 2.160 0.1&1 $ 0.167 2.299 Contract PGA - 0.�61 0.53 NA 18.1°/o NA • csw:aerzenoii __ _' I --......_. I . . ! .._ � A hm . _.... _. ... . i,.._ . .. , , . ... . .i. ._... .... .. I ttac ent Rf _. _.... I _. .. ___ - --- Residential �Rate Histo B Com onenl _ i Pa9e, ��� _ _. _ _ _ _ . rY _. Y p _ ts __.._ -- ---- � . __ . .C� _.. . . � __ ._ :- ---- ------ i ---..._. 7 Rare I --- --......._'...T, -... � l ----�_Go ........._.r...__.. . i- ------:..: _..._. _ _ .--._- ......,_ �.. ........__..__.. _ , .. ..... . ....._. _ I . � � -----.... .. �--- � Ad ust � . . .---- � ..._.. . - --... . � Montl� �..---- ... ..�. . . ... men erm Mrect i .............Lp .--.... � -`r--^^-�-�-.-. . . .. ._.-- ._.. _� �I .�.,._. WN IA-Resl# � ..__ � ---- �---- �-....._.._.. . .- � - ------ ---- ----- -- � - . .. . ... gi $ GRh9 O.$P..�,3=�_ �.. ...------ .... .. ...... Q�!�:- .,,.r. S�JA-Comll# � P�Q PGAloalls ! all �..-----....... .._.._..._-�. . ... ... . ...------.. . ��`-;.- ----.... ._. --..._._. _... . �,���_..�..._.._._.. ..__._._.....__..__. _ ,.._ I .. A/RIA# I .. ........... ...". _.. �.._,--- I _ I ... . . O , , _ � S 3.300 I�� � � -- �---------- _,. �. . .-------- ---- De A _..... I ............._...__ _ .,.__ ... - ......-..-Nov-0B g .�:.� ._�...._$ 2.770 . --... ...__._..._.__.. ��-�. . $ 0.140' $ S $ $ 1.270 $ 1.t4p�r$ 2260 Ja ----- $ 0.140 S $ $ $ 1.220 $ 1190 _ $ i $ $ 1.27D I $ - -1. 1 . . ....-------. ... _... . ..-- -----........-- --- - � -- - ' t � $ 2 260 Fab-091 S 1 940 ..._,.-. _. _ ' . .. -.....-- o-OB � $ 0.090 $ 1.730 , .. ----- - i -- o - ----.. ..------ � ----- 29 �$ 0.090 _' $ - $ - ' $ � 1BO I $ 1 100 $ 1200 _._ $ - ___._.... -- r-0s $_._i,5eo $ z ._..... -..- -----_- -- _._...._-. $ a.ara $ . i---....--- ,_$_..----- __rt__ ,..__._ ........-.-.:-- .._..- - ----s _,..1 �so $ z.zso # . . --- - --- -- --._ -..__ �_..... Ma � . ._. . - ------- -- ._..._.._---- ._ __.. . ---�F-.. � _._. _.. . .._ ...._..._.__-.. __180 $ 1.100 $ 1200 -- __ . -- _... .. .. 270 � -._ - - ---......-------- r-09� S 1.410 $_ 2200 ... ... - ------ --�---... I..... - - �-------- -$ ---- . . I $. __.....---- S 0.830 S 0.950 I S 1200 $ $ $ � ... _._. -_._. _.. -------- �-� - --------�� $ 0.040 I $ - �-$----..... ..... -. -� �$----- �$_0..90. ..$ 0.810 � $ 1.160 _ ---- $ D.D4D ± $ . ._.._._+ $.__.. . . . _ _ _ ........_. �----. . . . i ..---�-- . ..---- S ._.. . . ._. ..}-$ 0.8 0 $ p 81 � � $ 1.160 - --- JuI-09 $ 1.350 $ 2.330 - _._........ _ . + ----......810 �..$ . .__._7.160 a 2.290 . -�--� --- - � -- Au -09 $ 1.350 S 2� 00 -------.....-� ....._ f ------- �------.. -. � � ----- � ' ----- _ _... �50 � -.--.... ------ -..._ . � - 650 $ 0.040 S $ "---...I $ - S 0.830 $ D.. .._.... $ ---- 1290 _ I` -- -- Sen-09 $ 1.390 $... 2.�-- . . ._ _�. _. ... . --$ O.D40.: S _ $ , $ .. ..--I - - ..... . _ ---- ----..._ .4 � $ 0.750 � $ 1.4Sp � -�- -- -.-. . . . . .. . . . _._._..._. ._ . . ----- --- $ 0.070 ', S D.010 1 S ----- -' I S 0.830 S 0750 I S 1.570 FY 08l09 Av .§ 1.610 S 2.524 ' I I S 0.078 I S O.DOt $ i$ i$ 1.026 E 0.946 I S 7.470 2008 Av . $ 1.965 S 9.786 I S 0.136 S I S 0.013 � S I 3 1.237 I§ 1,157 I 5 2.138 --- ...�..ov-09 ------- _..---- ---._...-------I=..... .. � ....__. .$ O.tl70 I $ 0.01�0 �_ -._-.-- --.-..30 .-'.- - S_D.070 ! S 0.010 ; $ ... ._..----.-- $_.._.....--- � $.0.8 S 0.750, S 1.59 -------- -- - .._..._.. . 1 5 $--- ` �ec-09 1.390 S 2.750 ---- -- . ......... .. . _, I _ _ _ _ _ I ----- .--- Ocl-09 � -. .. �- ...---._ .. .. .._ . . . _ .. _ __ _ Jan-10 $ 1.3� S 2.8�.. -------.- .. r--- --- ---., 0.010 I S- ------- -- - -. - ----------.._.._�I --------- - ---- - ---.._..--- - OJ50 $ 1.670 _._. _ S 1_480_.$..... 2.810 ---..._.._...._.__.._ .. . ' _.- $_D,1�10 $ 0010 ..................--_$ .---- -50.880I$ .., _ 6�... ----Feb-10 �_.�._.� �...- --------..--- �.... . ..---....�i-------.... �-_0.010 $ _...----.... ____ FF -...._... � . -- �-------..._...._.. - ----- � �-- _ . � _. . .- -- ... ... .. . . .... I- ------_ - �-- 0.800 $ 1.690 - , Mar-10 _$ 1.520_. S 2.880 $ 0.110 $ .. _0,010 $ _ _ _ __ _ I S• S 0.92D $ -- ---------- r 1 D $ 1.520 � .. ._.- 0.840 $ 1.760 �_=_. ..�._`-- $ 2.880. $_0.110 $__ 0.010_ . $. I S S 0.920 S 0.840 ' $ ------176D - 2.850 , --- -- -.-.. .� � . - � I----_ $ 0.090 . $.. . 0_030_ ._$.----�--... . .. --- � �$ - ---_--.._..,. �$ ,0.890_ g --�-g . �.. . - - � l � _ ---- 1D $ 1730 -- _--- Jul-10 S , 430 S - - --- .. - ------- -..._ . ..... .............._._..-- - -------- ---- � ... $ O.D30 $�- . ........... ......... $ $ 0.860 $ OJ80 $ 1.830 S 390 $ --_-...�........ _._�..- A ..... 1 $ -..-- �--- n _ 9 --�-�-�--... . e9_10 $- . �...... _ _ _ 2.990 _._.__. -- ------ 0 0 8_. ._ __ S 8 D. 1.87D S O.D90 - •_ _... 790 $ 0.750 .$ --- - ------ - _ 7 $ $ 0.090 $ O.D30 $ i$ $ 0.7� $ 07 0 ��1.970 - --- - .. _ 1 _... 3.090 -------- ---.. . .., ...---- - -- -- --- u - 10 , 1.970 FY 09f70 Av . S 1.437 S 2.86b ' S O.D88 S 0.078 S S S 0.850 $ 0.770 $ 1.758 2009 Av , $ 1.464 S 2.418 S 0.061 S 0.003 S S 5 0.920 I S 0.840 y 1.353 Oc.t-..: $._..-1.47 $ 3.0 _----._...._.--I__..,. -.. _ ' - ----..._. . �--- ..................---.... 2 I - - `- $ 0.10 S 0.02 S $ " ------- -- -- -- - _...I ._ _ � ..._.. �..' � . � �.... ----- . ...- ---�. �..� ...--- ---------- -• --------- -. ._. . . . ... .._. __ f . - -�------ 1-$_._0-87 S_ 0.78 . S 1.90 ------ ._., - ..- -- . . ... --_---- ----.'�--._ ... ... .........-- --- . ... ...__ .. .._. . ------- . .... dan-11� $ 1.54 $ . .. -3.33 � , $ 0.10 $ -- --��0.02 S S $ 0.87 $ 0 79 j $-- 1 _90 10 _ -- - - D�c-1D S 1.47 $ __ $ 0.10_._$ _0_02_ � __ 0.02 $ 0.03 $ .. _._..._ 3-D2 ------ ....... ........_-. _ _S 0.10 $_ D.02 S S S �.. --- ------79 �-$ ----. . . 1.90 .... ---� eb-11 $ 1.55 $----3.37 ----- ...- --- --- � --_ _-_. ----- ---___-. ._ 0 89 $ 0.81. ..$... _._._.. . �r-11 S 1.55 $ 3.37 _ $ 0.10 � $ 0.041 $ 0.02 $ 0.05 $ 0 82 $ 0.74 $ - _ ' _.2.19 � . _-. _. 2 F -- - -- -.------ -- . .�._` _......----.- �__... '-_-------; ___ S 0.13 .5 0.03 S _ O.D2 $--- 0.05__S_ 0:89 S __0.81 $ 2-12 r- S 3.28 ....-----� ._...... _...--..... $ 0.12 S 0.02 i.$ .......... ...O.D2 $-----0.05 ... 0.61 ---D.73 $ 219 _._ ._ �----- _._...__ . ........ ..... - -- $ -- $. _. --- $.. . 2. 9 �Jul-„ $ 1 45 $ 3.35_ _..�-�^ ..,. � . --- --.... 0.05 $ 0.81 $ 073 I $ 2.19 .. = 45 _S 3.35 .._.._ ... -- ----.. -.._--�--�� t . .�,�� ..- --- ----�._ 0.81 $ 0 .... ----... ------i ---AU^1.1 $ ,�- S $-_---.... .. .- - ----....-- _...__ ------ $ 0.12 S 0.02 �.$ 0.02 $ 0.05 �.D78....$....--070..._$ 2.30 3.35 $ _ - - S P-11 $ 1.42 $ 3.46 ---------.. . -. ....� --------�---�----�... �S 0.12 I $ 0.02-�! $�-----... 0.02- $--�.OS $ OJB�� $ 070 $ � 2.30 � FY 10H1 Av . I$ 1.Ai5 S 3.282 a 0.773 f 0.023 S 0,016 § 0.038 S 0.843 $ 0.763 I S 2.130 2010 Avg. 3 �.as� i s z.�ae o.a9s i a o.02, � a s o.eso a o.�sa $ 1.829 ..... t -Ti -- --- �- ----- ...Od-11 S - 1.:47 _.$....... 3.63 .------ 0.13 � $ _ ._._.0.02 S _ 0.05 S_ 0.8,... . _ . ._..---... -------- ----- _...... ---.... $,_., � -----... --.. 4 � $ o.s2 $ z.4s ....... ..... .. Nav-11 �--- ... . ..._. _ --- ---- ,-- I . .._..----.....' i --- -- - ---....., -y . _ .. . .. ..----- .. � �. � � � _... .. --- ---. "...._ . .._. � _.._. ._ ,..--- - .. . Deati i..- -...- ...._.. .... ... ----- .. ---- --- -- ... .. �------�----- - � _�. - ------ - , ..._..-...__. ......-- -- Jan-12 . L..._- � . . ..-- ---- - ----.......�... _ ....--- - ------.... -- --- �� --- ...--.. ..� ----------'...------- .... . .... ....---------- . - I � .., . --_-..-._.. ------ --I - -. .. �- --....----- - I �-----...---- . .. ... _ .. -- --- --- �.. ... FBh-12 i -- -- --- -- - -- - .. .. _ _ _ Mar-12 �_.__._._._.�.,--------- - �- � _.. . I -- ----.... .....-- -�-----�--.. --- �--- - . � -__ • I -- ........... .... ... . - ----......---- ..- �-----....--- ._ � ..------ -.. - May , Z�-. . . .. --� - ----- . . � I -�- -- - �.. -..- � ._........ _.. _ � . .__.....----._.. _...- - - - ---Ju1-12 ---- ----�,. �-- .....T--.... ...��.... t .. . _. _._._ ---� �. . . .._ �.. ,�. T _.._.... ._.... -�- � --- - -- . .= _....._..-- --... � � ---� � ------- � ..-------- - --- �--� ���. .. _ .._.....-- -- .�. � � ...--- . t .. .. ,_. _. _. ,.-- ---- .- Se..._._..---- ------ ---------.._.. ----- {...----�-... - un- - -- - �`--- -- � . .._ . . .. . .._..------ Au _12 ------ �.... . .... � . --.. _...... - ------- .... ---- _. ..-�-------- .�.._ , ._.. .............._ _... -12i . ---_� . _ .. ----------....._... --------- --,.----- ' . .__........i---- --- _ ------._I...-- .. ...... ......._. _.. FY 71H2 Avg. 5 1.b70 y 3.630 ' a 0.130 S 0.020 S 0.020 3 0,050 0.87D 3 0.82a $ 2.460 2010 Avg. i Incc Abova S . .---- S -- p.61 --- --. .. _...._...._,..-, -- - .-- ---_' a-�=� �5----- $ --- ---0.02 a -- 0.05 I -- - _ j - �- -.. .. . -- -..._.. -�---Last Yea _ --� _ -- . � .. . . _-..-.... - --- I ' ---�-----..._ ......__.-�..,. ..__ -- �------ � ...... ... 0.56 ----r - i .-- � .... ... ----�,. ..... + � ----��__-'... NA a%I - 4���.. ........_.. � r5 S o.03 � -. � I _ % Same Mo _ - �- - _ ------ _, . . - -------- --1 i - .... _ nth ....... ..._._. _----- .. 29% ---- --- --- -- --... _ - --- - ' ---- r - __ �% r--- _....... --- on2DTherms $ 0%----- ............... ..�_---�--�-- ....--�•---� .....-._.......----.-_:...__..._. ....---._._... �-----..__I S 13.33 . . - --- -� ..--- -- - -. - --------- _ _. . -----. _._ .. .. .. .._... _....- _ . .. _. _... . _.. 22% � , � . . . . ...._ _._....._..- -- -......� .� � ---------------- - ..._..------�-------------i ' .. .........__._......_ ......... . . ....-._. � ........ _.._...---- ..... ...---- . . ....__....- i----------- .. _.... __. ..-------..... 9..._ _. .. . _..---'-- ---- � ' - . valent . _ ._. .._._._ .....---------. r----._ ....,.,j. . �� .. ._ ... . ....... ....... . .I .....-------- �.... � .. �---- . .. ... __._...._._... . . E w,._., _ ' _ , -- _._...._._ _ . - i � - ---..._..._ _.._._ .._ 13.5� .... ... . .......... .� � --- -.... ... .------- - .. .. _._... � ---_�-.._.._.... ,. .------ ................. �. ; . for Gas ---�-� . . .._..--- . .. _... .. .. ... - � --... _.. .. _ . : � � . --- -.... - �-I�,---... ._...�_.....------._... ...-_ �� �. .._.. _ .... _._._------- �- - _._ . ... .. . .___. , . - -I ----- --, .._.. ___'�2.9_ ....- Nole: 7his is Pro ress Ener....�'s residential rat I 1or usa e a7,oU0 KWH. � ���--,:' .. �.---..._f-.-.. .. .i. - ..� � �---���---....-. .. � s. FPC Ra�e... --------Y---------- ' ..._ I A..._.., , , -- _ _ _ .. .. ........- ...2.9 , .... ..._._.._. . .- --------- . . � .. . ----... i . ... . .---...... . _ ... .__ .. Residenti ) : . . i. ---�-----�- --��----- I � ��----�,. .........--� . ...__.. _... _. _.._,.. ......_...._._..- �----- i � . _.._ �. .. _. ... .._- .---I----- - - i - - -• � ...... .... . . .. . . . i . . . ._. .------ by --._....._. i. 6���. �_... ..._... ih--- �---- .,_...._ ...----,.. ......_....__� ;�..-----. . ... ....__..__ � - - - - --- eY -- ---- . -... _. .. _.... _ _ . --- .... ..... ...... . - - ---- .p - _ _... --. - -- --- ----�- _. ! -. - ' . .... .. .. ..� ----j- ---..._.-.._.. . _ - __ _ _ _ k _ _ _ - _ _ _ 6az Chea ......... ... . ... --=--- .. ... __. _ . _.._. -__ --. -. _ ! _....... . . _.. .-- - � B,%� .._�. _. . ._ . ._. .. _ . ..._.._.._ _._._. . . ---�-. � � .. .._. � ..._. �- ----..__ ........... ........ . No e5 . P .., in 12o I � # New�ralesBmklemen ed V1l2009,Iwith fol�ble forcustomers us' "� . ..-_._._�_._.._. _. Y . q..-._... . -...... - I_--. _-..--_. ' ........ .. . ... . . _- -- � �_ ; .. ._.._._'.�._..._.__.._. ! .... ---- -- -..... ---- I--_..--- . ....--- P) --._..... ..... .. .... .. _ I --.... from $8 � �.. � 1 - 300 allons/ ear 8._a_ual to Resid - -`_ ___..._.. ..... .. -.--._._.....__I . ... ._ .. . .. i .... .- ------� --- - RS NG Customer Char e � lo $10/m ential LP Will C_CC(_ -- ---- -- . � . _ ased ....._ 2.-. . BRWCL 8RLP3 �P Cuslomar Char E in�Bhan es: _ .. .. _ owin c $1B f .. . ��y.. . •... . ped ao ed 10 can8la $1 OOI rm� ( +$1/Mo. in 4l1/2005). . . . _ 1....... . �-..�..._. ---�-- m$7 to $90l ear and NFE r .-... ` ---...---.... � ... .-- ---. . ..._ .,,. _ �-. . -- --------� - . A-..__._ .... . ........ but no nth 8 NFE rate dro.. ... �. . ... .... . . ... ....... . . . . I- EIq Chan ed.to RIA & WNA chan ed to UTA, _ ..._.._ .._.-. _. .. _ ons lo new com on tE r A.., an (CC_+12/Yr. In 4Ml2DD5). .� _....- ---- - .... �d 52......---- - -- addi - ............._ .. _. _. .. . . . . . , o o ....___P f ents of th Ise initial(Y•_ ..... . � -. - --. --. .....I ... . l . ------- 8. ti. _ -----�..._... . �- UTA im lemented 1/1/2011 i j i , csw:aizsizoi � Attachment #8 Page 2 af 3 Com etitive Histo ofi NG vs. Electric Rates Month-Year NG Therm Cost 5eptember 2001 $ 1.34 $ September 2002 $ 1.36 $ September 2003 $ 1.56 $ September 2004 $ 1.69 $ September 2005 $ 1.97 $ September 2006 $ 1.89 $ September2007 $ 1,86 $ September 2008 $ 2.12 $ September 2009 $ 1.39 $ September 2010 $ 1.39 $ September 2011 $ 1.42 $ $ Increase over Last 10 Years $ Q.08 $ % Increase over Last 10 Years 6.0% Avg. Annual Inc. Over Last 9 Yrs. 0.6% NG Equivalent KWH Cost 0.046 $ 0.046 $ 0.053 $ , 0.058 $ �i 0.067 $ i 0.065 $ '�, 0.063 $ 0.072 $ 0.047 $ 0.047 $ 0.050 $ � � � '� 9.7% 1.0% Progress Energy KWH Cost 0.08�4 0.074 0.084 0.089 0.097 0.119 0.120 0.120 0.132 0.136 0.129 o.oa 53% 5.3°/a NG vs. Electric -46% -37% -37% -3�% -31 % -46% -47% -40% -64% -65% -61 % _.. csw:sizarzo� � _ i .. _ .. _ � : P_a --e �. O f_3 #S _ ...----. , i � _ . . i tta�chment --------.. _...---- � .. . ,_ - . --- - _. ----- . - - -------- � __ .._. . - .--.. _ ;. . __ . ------ - - -- --- . . - - -- ------ _... -- , - -._ __� �- -- _ _I.. . .__._ .. . ------ - - _._. � _ _ Annual Average CGS Residential Rates �-: -_--------_-_ � --_-_-- - _ --.- __� --�-- _ _------==1-- ---- _ -- , -- ---�-- -- _ -- --- Calender Year '� Fiscal Year Y 95 , - * -' 1�ear _ NG/Therm_ I LP/G,_,_, alla�,n _ Year NGITherm LP/Gallon * _ .. ' --1------ - ---- - - - . ... ........ � --,..^--._. .._.... ----- - _ ._... . —.. .....--- NA. � —_... ---..._._ NA_. *--I. FY. 95/96 _ I_$..... .. _..... 0_880 � � 1.199 I � - ------. .. -- --- - � �..239 * � FY 9fi/97 $ 1.019 . .�_..... _ _ _ � -370 I � -- 1996.. _.- --... . _... ---- - _ � * _ ---.. . ----- - ---- �. .. . 1997 ._ $ 1�.049 $---- - -- - 1.380 FY 97/98__ $ _ 1 _ 054 $ _.1.318 i 1999 $ 1.073_. . �. _ ............. _... *...._� -..... __-__ ' - ---.._... ------- ---------- ........ .. . _... _ �,� 1998 $ 1.032 1.288 FY 98/99 $ 1.052 $ 1.269 , --- -- _ 1 58a FY 0�/01 �$ 1.551 $ 1.6�14 '-- 2p ----- - --- .1.222 �. - -- ----,311 FY 99/00... �...----.. .1.15-.....- ---._.. . ---------.. . .I.._._. ----... ... _ � . _._.. .. 2 $ 1.50 ---- 2000 � .. . 1.549 � 1. -------..._.. ! 9..._I.._..--- --� $ .-..------._..._.. --- t 1.48$ � _^02 -- - . . ........_-- ------- -- - --- - - 20 -- -.......... $ .-1.342 $ _- 1,',553 ---- FY 02/03 I $ 1.477 ---$ - 1.817 - - 968 - -- --------- .._ $ .... 1.803 . ..._...---...._ -- ---- --.... - --- - 03 $-- 1.532 $ 1. I FY 04/05 $- -_ 1.6Q3 $ 1.913 2004 _..._.._.-$ ---- 1.65....._�....--_----�-$64 -- -----.. . . __ ------ .....- -- -- .---- -- $ 2.162 t - ----. . _. _ 2.080 _...._._.._. - .. ------- --- $ 2.480 i- ---- 2006 --- � . .... .....1.925 $ ... ._._.._.__ 2. 012 $ 2.508 FY 06/07 � - - ---- --T -. ... .. _ . . . ��. —_._._ . -..__._. Q$_....__� _.--1.932i--$ ... _3.183--�-.... 2007 __ $ 1$93 $ 2.;$69 FY 07/ --. _... $ 1.965 $ 3!186 FY 08/ --- -- ------. .. .. 1 _ _....._ 2008 „ 09 $ 1.610 $ 2.524 , 20�_..._------..f...._...�....__..__.._ - ------- 2.j946- ----FYOQ/11�---$-...._. 1_475---.$_.__.....�.3.282�-- 9 $ 1.464 $ ------ -- 0 $ 1.457 $ -- ----_ ..._..--- � --- .. . � —_ _ ............ .--- --.. . ........._..._...._. _._ _.._.._.. ._..--- ------...... _.... ... . . ...---- - -...... Avera e$ 1.47� $ 1.998 $ 1.462 $ 2.048 ---._._._.__._.._...... . .......:----- .. ... ........ . ...._.. . . ------... __..._. -.. ..... __ ...............---- ------- _ _ ------... .... ...... - ---=--------._.. —. , --- -------.. . .. ...... ..- - --- --- � . .. - - --......-- - __�..._.. . .. _ -- ........ ... ......__—...._.._ ... ._.._..._._.. _ ._..._ ----- ---t.. ------- .. ..... . . ........._�.. ... . - -- — � -- ___ _ _ _ _ __ � Notes_ _.. ._...-- ------ - - --_.. . . ------ --- - -- - . et .. d Propan -- ------ --- -... _ ---�—. . _— -.. . ._._ ___ __ e schedule which was closed for ""_ Based on the Residential M_ ere ---------__ _._. .._...-- -----------,........._99. For 1999_& FY 99/00 and b------ — _ ._._-�- --- eyand nEw_cus omers e ective arch 8, 19 _ based on0 gallons/year & s equallto Res dentia�LPuW�I Ca I us!ng� I 120,1 - 30 Bulk LP BRLP3 whichi _ __ _