Loading...
GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2012t ^ �_, p: , T0: FROM CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet William B. Horne II, City Manager Chuck Warrington, Managing Director RECEI�/ED JUL 18 2012 O�FICI�0.1. REGDR6S �9� LEC�Sl�4TIVE SRVCS DEPT COPIES: Rod Irwin, Assistant City Manager; Rosemarie Call, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/CCS; Lynne Priester, Cust. Serv. CoordJCCS; Lindsey Bessette, Systems Analyst/CCS SUBJECT: DATE: GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2012 July 13, 2012 Gas supply prices have continued to drop this Spring; therefore, we are recommending a reduction in our Natural Gas PGA of 2¢/therm and a reduction in our LP PGA of 40¢/gallon for August. We also recommend that we continue our standazd Contract LP PGA at 30¢ below our Standard LP PGA. We are recommending an increase in our Residential Usage & Inflation Adjustment (LTIA) of 2¢/therm or gallon in August in order to reach close to balance by fiscal year end; however, we are not recommending any changes in our Energy Conservation Adjustment (ECA), our Regulatory Imposition Adjustment (RIA) nor our Commercial Usage & Inflation Adjustment (UTA) for August. The net effect of these recommended changes for August is no change in our typical Residential Natural Gas customer's rate and a reduction in our typical Residential LP customer's rate of 3$¢/gallon (-10.5%). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after August l, 2012: Natural Gas Firm Standard Rate Schedule PGA ................. Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ................... $0.76 per therm (down 2¢/therm) $0.68 per therm (down 2¢ltherm) Propane (I,P) Gas Standard Rate Schedule PGA ..................... $1.99 per gallon (down 40¢/gatlon) Propane (LP) Gas Contract Rate Schedule PGA ..................... $1.69 per gallon (down 40¢/gallon) Energy Conservation Adjustment (ECA) ............................ $0.13 per therm or gallon (no change) Regulatory Imposition Adjustment (EIA) ....................... $0.03 per therm or gallon (no change) Usage & Inflation Adjustment (WNA) - Residential ............ $0.08 per therm or gallon (up 2¢) - Commercial . . . . . . . . . $0.06 per therm or gal. (no change) William B. Horne II, City Manager July 13, 2012 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru June. Our objective is to be as close as practical to balance by FY ending. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #6, Page # 1 shows our monthly rate history over the past 3+ years, and Pages #2 and #3 of this show our 10 year relationship to electric prices and average residential rates, respectively. Please note that Pa�e #2 of this analvsis shows that, over the nast 10 vears, our residential natural gas rates have risen iust 6.0% as compared to a 53% increase for Progress Energv Florida's residential rates. That's an avera�e annual increase of 0.6%/vear for natural gas vs. 5.3%/vear for electric --- a remarkable difference! I should point out that the overall effect is that our tvpical Residential customer rates are now apnroximatelv 62% lower than electric for Natural Gas and 9% lower than electric for our tvnical LP Residential rates. This is a very attractive competitive position vs. electric rates. Note that Progress Energy's rates increased in January, while ours have been decreasing. We will continue to track these balances each month, make monthly projections of these factors based on market conditions, and let you know if any of these get significantly out of balance. Bill, I would appreciate your approval of these revised adjustment rates so we can get this information to CCS in order to make the appropriate adjustments in the billing formulas in time for the August l�` billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: .Urz.,�.�, f'��'W��- '' William B. Horne II, City Manager �. U:WIy DocumentsUASOFFICE\WINWORD\GASRATES\Gas Adjustments for August2012.docx CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 1 of 4 " NATURAL GAS PURCHASED GAS ADJUSTMENT�„PGA-NG) � ___ _;__� __.___ _ __ - _� Monthly � Cumulative _ NG PGA_ Budget , Reservation ! _ Commodity __ nterest _ i Cost Center� � Total NG Fuel^'i Total NG PGA _� Overa� !__YTD Overage _RatefTherm Month ! Charges " Charges Expense ; Expenses ; Expenses � Bilied _ __ (Shortage) (Shortage) _ Firm/Contr PriorYear'- -----+- ----'-- i � i � �' $ (18.452.43)! ------ Oct-11 $ 4,549,558.33 ' 822,886.34 $ 92. $ 39,448 03 ; 1 , $_5,411,984.96 ' $ 1,253,222.79 ! $ (4,158,762.17) $ ,214.60) 0.82/0.74 - - � . _ - - -- -- ' $ 19.198.62 $ 44,582 28 ! --! $ 1,144,516.69 I 1,618,956.68 �$ _337,49020 � $ (3,839,724.41) 0.87/0.79 : _ --- Jan-12 � $ 184,060.19 ! 986,867.23 $ 20,886.07 $ __39,127 23� _� $ _1,065,742.81 ;_ 1,403,233 01 Nov 11 ' $ 175,157.39i 830,572.12 � Dec-11 $ _1_77.586.31 ; ---- 903.149.48 � $ 474,439.99 ' $ (3,365,284.42) 0.87/0 79 -- --- - � --� --- '$ 16,826.42 $ 41,116.67 I I$ 1,228,870.51 1,827,203 00 $ 598,332.49 �$ (2,766,951.93), 0.87/0 79 Feb-12 '$ 175, 6 872.802.88 $ 13,834J6 $ _ 43,522.34 � �$ 1,106,086.35 i _ 1,629,009.96 i$ 522,923.61 '$ (2,244,028.32) 0.84/0.76 Mar-12 ' $ 173,027.27 �_ _ _ __ _ 864,297.97 ! $ 11,220.14 $ 46,389.01 ' ' $ 1,094,934.39 I 1,594,658.26 , $ 499.723.87 ; $ (1,744,304.45) 0.82/0J4 Apr-12 ', $ 130,330.73 i _ 821,676.86 �$ 8,721.52 �$ 36,922.19 i y$ 997,651.30 i 1,507,867.77 '� $ 510,216.471 $(1,234,087.98)! 0.82l0.74 May-12 $ 95,338.46 _ __ 651,381.87 �$ 6,170.44 $ 31,227.55 � ;$ 784,118.32 i 1,326,433.25 ,$ 542,314.93 :$ (691,773.0�_ 0.80/0.72 Jun-12 . $ 91,779.78 782,790.24 ! $ 3,458.87� 31,415.92 ! i $ 909,444.81 � 1,263,947.48 �' $ 354,502.67 ; $ _ (337',270.38) 0.78/0.70 Jui-12 -- ----- _--. $ __90,000.00 ;_ ___ ____ 750,000.00 ; $ 1,686.35 $ 40,000.00 i ; $ 881,686.35 � 1,101,347.20 ! $ 219,660.85 i $ (117,609.53)I OJ8/0.70 _Au�c-12 $ __ 90,000.00 ! _ ___ _ 750 000.00 � $ 588.05 j $ 40,000.00 j ` $ 880,588.05 � 1,073,107.53 I $ 192,519.49 $ __74,909.96 0.76/0.68 - i _ _ ! i � -- -- $ 193,107.5_3_�_ $ _268 017.49 0.76/0.68 Total YTD', $ 6,308,089.40 I$ 9,786,424.99 I, $ 102,683.51 ^ �$ (285,324.57)� $ (17 307.08) Sep 12 $ 90,000.00�__ 750,000.00 : $ _ - $ _ 40,000 00 . $ 880,000.00 � _ Per13 $ 285 324 57 � - ! ' -- _ __ � $ 473,751.22 ; $ 16,6i0,949.12 $ 16,672,09447 , $ 1,145.35_ -- - -- - - -- -r--� , __ _-_ __ _ _ (1j:�lncludes Annual Admin Charge of $708,720 + CCS chg of $1,052,690 + Dividend $1,300,720 ___ ' i + FY 10/11 PGA write off of $27,099.40 + WNA $304.10 i --t---- � ---- - -- - - ----- _.. __ _ _ � i 1 � 5�Commodit ad'ustment from FYE trans ---- ---; ----- -- - - - --- -._. ___ _ -- - _ -. �_ _ -- ' �-� � -' -i- -- -� - -- - _ + Add'I Dividend b - - _� y � fer of ECA Coilected in PGA � 1/2 of the ECA Rate -- �- --- --- ased on FY1- et ro it � �_ � _ -�__ .�-� NG Proportion = 97.9% x Total ECA Transfer = $ 285,324.57 --- -- - _ . . _ - --*- 1 T Avera e Annual PGA/Therm -' $0 782 ! Av Fuel Onl - $0.459 Net RC ,, $ 1,581.953.33 : -- -- --+-- - ------------�----- ---- ----- ---�- 9 - y -� -- ___._ - --_ ---------- -- --- --_ __._ . __ � -- -- - --- - --- - ---�- -- - Delta/Therm = $0.32 --- -- --- _ _ ASED GAS ADJUSTMENT (PGA-LPl ' W __ _ --- -- _ ------- - ------- --- _-- -�--N�on3F�I r� y Cumulaiive - LP PGA PROPANE (LP GAS PURCH -_- -- -- - -- - --�----�----+ - --- - -- - - Budc,�et� Gailons r__ __ Monthl r� ___ ____�_ Interest ; Commodfty ' ' Total LP Fuel __ Total LP PGA_� Overage YTD Overage_ . Therm/Gal. - - -- __ - -- - Month ' Sold WACOG ______�_ Expense Charges i Expenses _ B(Iled `_ (Shortage) ___ (Shorta�e) _ -+-- -r--- - , � , _ _ Prior Yeac - ---- ---_-- -__ ~-- _� _ , $ _ (44 746.06) Oct-11�' 34,240.2 $ __ _ __ 1.80693 $ 223.73 $ 61,869.64� 1 �- 310,165.95 $ 83,495.97 ' $ (226,669.98); $ (271 416.04) 2.69/2.46 .-- ---- --- - -- -- ---- { . _�-- 8 6.51 � 72.604.41 ' $ 18,048.44� $ (253,367.61) 2.69/2.46 Nov 11 29,551.0 $ 1.80024 1$ 1,357.08 ; 53,198.89 54,555 97 ! - �- -- - _. . Dec-11 36,513.7 $_ _ ._ ____ 1.76919 � $ _ 1,266.84 �__ 64,599 67 � _ ___ 65, 6 _ 89,690.65 � $ 23,824.14 $ (229,543.47) 2.69/2.46 Jan-12� 40,655.9 '$ 1.70188 ;$ 1,147.72�__ 69,191 46 ; 70,339 18 ~ 108,525.84 '$ 38,186.66 $ (191,356.81) 2.93/2.68 - -- --- ---- -- --- - Feb 12 � __ 36,770.7_'�$ _-_- -- - -_ -_ -_ -__- 1.59737_I $ 956J8 58,736.41 -T-59,693.20 -- 96,048.39 ' $ 36,355.19 $ (155,001.62) 2.84/2.60 -- -- - ----- --, - -- --- - �� --- - - - -: .- _ ------- �_ �-- -- ---- $ _40,382.74 $ (114,618.88) 2.84/2.60 APr-12 _ ___26,201.�1 ' $ _ . - _--_-1.51016 $ _ 573.09 ;_-_ 39,567.85 40,140.95 168,014.89 ', $ _ _27,873.94 $ (86,744.93)� 2.84/2.60 --- - - - May-12 ._ 25,881.0 $ ---_ ---- _ __---___ - - 1.39668 $ _ 433.72 : 36,147.48 ! 36,58120 65,777.46 $ 29,196.26 � $ (57,548.67) 2.77/2.53 _ _ _ _--- - -- - - � --- - ----� - - -- Jun-12 25,399.8 _. $ _ _ ___-_-_- __---- 1.21178 Y $ -__--287J4 ' _ 30,778 97 :-_� -- 31,0 6 - 61,188.70� $ 30,121.99 $ (27,426.69) 2.61/2:39 - - - - --� Jul-12 28,OOOA '�$ __ 1.21000 �$ ___ 137.13 ___ _ 33,880.00T_� __ 34,017 13 ! 66,669 72 $ 32,652.59 $ 5 225.90 ' 2.61/2.39 _ --- -- - - ----- --- - -- . --- --- 55,511 61 ,$ 22,191.61 $ 27 417.50 2.17/1.99 - ._ � 33,600.00 - ,--- - - - 55,511 61 � $ 21,911.61 � $ 49 329.11 . 2.17/1.99 g -- ' $ ---- _-- _t-- ._._. ---P13 _ _ , $ ------ _--- -- 4 ' 48.047.76 1.19000 $ _ ___ __ � _ _ __ _ -_- -- -- -- ,--- - - ---- _ _ Au 12 28 000.0 , - i-- g (48,047.76)'; $ 1,281.35 --- --' I 1.20000 $ _ 33,600 00 -- __ . Sep 12 _ _ 28 OOOA Total YTD' 379,188.3 $ ___ 1.52238 $ _---7.158_85 ; $ --577,269.22 !--4 $-_---880.548.41 ._$ _ 926,575 82 :_$_ _ 46 027.41 _ _ _ _ __ _ _ Cost Center Expenses ' -- � - - - ---- --- -- --- � --- --- -�- --- _ �CCS Ch�dmin 8 Dividend $ 184,114 00 1 -- --- � - _ _---- , -___ --- - - ---- --_- ___._ ---- , -- -- -- - _ - . _ _ . _ _ .- - _. _ _ --- FY 10/11 Write off PGA & WNA �$ - : 1' _ -- -�- ---- -- -- - ----- - ---- --- - - , +- -- ---- ___ --- _. _. �Donations to events $ 10,203 64 � 1�_ �Ad'ustment from F i ----�-- �- _ - --- --�- ----- - - � . . .-- - - -- _ Fuel _ � $ 15,000 00 ____ - - _ - -- - ' --- T� -- - � ( ) _ _ - -- YE transfer of ECA in PGA 1/2 of the ECA Rate a_ _� _ -� -- --- � - - - �- - �_�_ LP Pro�ortion = 2.1 % x Total ECA Transfer - $ 6,120.34 ----- LP Yard Va onzation/loss due to malfunctionin meter _ _ _ _ __ LP PGA Event fuel cost �$ 3,771.40 1 - --- -- -- -- -- -- . - ----- ---- - _ _ _... -- - ' + Additional Pro ' De reaation of� s $ __ 34,414.23 �1� ___ -±� __ ed Costs Needed = $ 41 927.42 _- �-- -- -- ____ - ' - -- -�--- ---- -- + - - - - - _ -- _ :8uburban Software Systems license - - -- $ ------ ---- � -^------ _ _ )ect-- -- - --. - - - _ _ -- --- P � _ _._ _: _ • --�- - -- -- - . _ _ �------- Contribution to ara e LP trk u_ rade ____ .$_______ __? � ------ 9 � - p 9 -- _.. T_ _-__ ----- �-------- --- --------� -- - _ __ __ ___. -- ! LP Holding Tank Restoration $ - ; Proj. Ann. Costs Add'I. Proj. Costs ;, _ _ ------ -..__- --_--•--- ---- - --- - ---'- - _ ____ . $ 248,072.58 I - $ - 290,000.00 � $ 41,927.42-'- -- -- - -- CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 2 of 4 ' — --- i � --;— -- � --- ENERGY CONSERVATION ADJUSTMENT (ECAI i � i ' ' ! ' --- ---- --; - - - Month� _ Cumulative - -- ECA - __ ------ - � Bud�et Cost Center ; Interest ; Total ECA i Total ECA Overage ___T YTD Overa e NG/Therm - - ' �_ s - Month Expenses Not lExceptional Items ' Expense ��" ��$�rti�n " Expenses ; Billed ! (Shortagej (Shorta�e) LP/Gal. --- -- --- � - --- -- ; - - `�;��,� - - - - ----- --- - - _ - $ . �,� ' 2.14 I 138 769.26 472,125.53 $ ' _ _ -- -- - Prior Year � � � _ - __ OCt 11y_$ 570,285.44 I Promo554,767,Adv a0, Employ CostsS69,819 � $ �' � 1 $ 572,819.98 ' $ 100,694.45 : $ _ ( ) $ _ (472,125.53) � 0.13/0 13 - - 4 ,_ �'� _ �_ -- - Nov 11 '$ 89,882 26 '.PromoS24,24s,Adv S5,000, Emplo Costs561,o73 '$ 2,360.63 � �, 92,68 , i$ 46,087.12 $ (426,038.41) 0.13/0 13 -- �-- } -- --- - - Dec11 '$ 90,22282'PromoS32,925,Adv3300,EmployCostsS56,998 J_$ _2,130.19 �, �� 6� 93,82364 ! 165,1 13 47 I$ 71,349.50 i$ (354,688.91) 0.13/013 -- - - - -- -_ �_ p y $ 1,773.44 �� �� r= :`�$;;;` 168,959.39 � 203,035.53 i$ 34,076.14 :$ (320,612.77)+ 0.13/0 13 Jan-12 �$ 164,412.37 PromoS102,771,Adv So, Em lo CostsS61,647 � , _ � h•--?--t- - -- -__ Feb-12 $ 135,098.18'PromoS7t,307,Adv5250,EmployCostsSS3,541 $ 1,603.06 � ,. ����_, 140,333.94 183,17176' $ 42,837.82 $ (277,774.96) 0.13/0.13 __ ._ . _--- ------- -- -_ _ .------- -�--- i !---�--- __ _. __ _ Mar-12 $ 135,745.90 PromoS50,233,Adv 5250, Employ Costs565,263 i$ 1,388.87 ��� �:� , 145,265.71 178,294.06 ;$ 33,028.35 $_(244,746.61) 0.13/0.13 _ Aer-12 � $ 98,946.97 PromoS49,740,Adv $1,734. Employ CostsS47,s7o �$ 1,223.73 ,�e ' 105,984.90 � 166,301.78 . $ 60,316.88 ,� $ (184,429.7� 0.13/0 13 May-12 119,913.50 ; Promo542,058,Adv 30, Employ CostsS77,e58 $ 922.15 „u I, 168,862.00 � 145,013.49 !$_(23,848.51) i$ (208,278.24)T 0.13/0.13 _ , , `, r - -- --*-- -- - Jun-12 � $ 163,652 ro46 moS116,496,Adva397,EmployCostsS46,760 ' $ 7,041.39 ��, . + � I 172,029.98 , 139,262.17 � $ (32,767.81)� $ (241,046.06),: 0.13/0.13 _ Jul-12 �� $ 100,000.00 � �$ 1,205.23 �:s = � 107,205.23 � 123,656.55 $ 16,451.32 $ (224,594.74) 0.13/0.13 Au� 12 '$ 100,000.00 � $ 1,122.97 r ,�� 107,122.97 � 123,656.55 $ 16,533.58� $_(208,061.16) 0.13/0 13 _ Sep-12 '$ 200,000.00 ;Pay down 5700,000 of NGV Statlon Costs $ 1,040.31 ��. i 207,040.31 � 123,656.55 '$ (83,383.76)! $ (291,444.92) 0.13/0 13 - - -- - P13 ' $ -- , ' _ Y. $ r , . �„�'°..t ! - i 291�444.92 ' $ 291.444.92 $ - -- -- -_ _ -- Total YTD $ 1,968,160.08 --_- __- ----- --_-__- ----_ $ 15,811.99 ! $ 98,158.14�� $ 2.082.130_21 i $ 2,082,130.21� $- --- _- -, ' 1' Includes Annual Admin Char e of $46,450 + CCS ch of $55,930 + Dividend $69,09 � - - --- __ _ ___ ___ _ _ _ _ _ ��, — � g � 0 (6) := Transfer of ECA Collected in PGA � 1/2 of the ECA Rate (up to ECA Annual Shortfall) - - ----- �+ FY 10/11 Write off of $2,454.47 +$200,000 SNEP � � Note: Maximum amount which can be transferred = $ 895,342.65 --- ---- - -t--- �— -- --� --- - --. . _ - ;+ Add'1 Dividend based on FY11 Net Profit $71 775 = $ 445,699.47 , _- ---•-- __-- �- ----- - --+- ---- ' ��__ _ I � _-- -------� -- -- - -------- _-+--- -'�-------- - -- --'*-- ' _ _ - -- _ -----+------ ---- - ' - -�- --�--------- ----- -- _ . _ _._,_. _ -___-- _ __ _ _ __. Net CCE _ � 1,636,430.74 -------�- --- - ------- --+------ -..__. ... -- - . ---- � - ---- ------- - :--- �--- ------_ __ _-_ ___ _-_ _ _ REGULATORY IMPOSITION ADJUSTMENT�RIA) ~ ___ _ .___ _. ___ _ - - - -- -� -- - - --- ; (EIA) "' � �ORAjA _ � -- ------- -- — - - * � �� --- — - --- -- Budget .,Environ,rl�enta) _._____ ____ ___` F:e�i�„8�o`ry� Interest ___ i Total RIA ___ Totai RIA � Overage __ YTD Overage NG/Therm Month Expanses . Notes/Exceptional Items__ � �if i1s�3�� � _Expense ___ ; _ Expenses �__ Billed _ � (Shortage) _ _ (Shortage) _ LP/Gal. --- . --- � Prior Year ��� -- ----- -- - --- --'� -� � � ��� — ---�---- ' *-$ ___. -- $ - i161 500_70) _ - --OCt-11 $ a 12�39053 - �� �f� $'� � i -!-_------ -- -- - - ---�- --- -- ----- ---- r ���� } � � $ --- 807.50 1 $ 13,198.03 19,520.29 ' $ 6 322.26 $ (155 178.44 0.02/0.02 Nov-11 $ �;3,��, 00`-- -_— --- --_----- � �'�� `�'��: $ 775.89 2,09989 _ 21,322.53 , $ 19,222.64 $ (135,955.81) 0.02/0.02 -- ` - - '�"'�'�"�,��� `' $ 679.78 �-'- 3,820.68 !----- 24,412.10 $ ----20,591.42� $ __ (115,364.38) 0.02/0.02 Dec-11 , � 3,;74u 9() . - ----- -- -- - =� ��.��'� �' - --�---- - - ---- - --- - - - - }�� �, _ Jan-12 $ 1,32q�40 _ -_ _-- __-_- _._ _ - _-- *� "�' $ 576.82 1,900.82 ! 31,235.92 $ 29,335.10 $ _ _(86,029.29) 0.02/0.02 Feb-12 $ 2;1�50Q,,_ �'��� � -- _- ---- __ --- --- _----'� s,.� � �x�'� $ _ ----t-- _�$ _ 25,55� $ (60�478.80) 0.02/0.02_ Mar-12 $ 1 •3 $ 00;!_ __ . -- -- � � ���� ��,��� $ -- 173.42 ',_- - 135,242.92rt1 25 577.61 $ 25,795.69 $ (34,683.12j 0.02/0 02 - - -- -- - � � � _ _ Apf-12 $ 105;d3� 29 -- - (2) � '" . . �. � -- ` $ (109,665.31)_ $ (144,348.42) 0.02/0 02 _ ____ __. ----- �" ���� �� — — - Ma -12 $ "�;���} 0� _ -___ -� �. � , � $ -- - 721 74 ':�_� 2.045 74 22,311 03 ; $ 20,265.29 , $ (124,083.13 � 0.02/0.02 _ ----- - __ .. . __-- tr ����� �, � �.; $ 469.07 -r-- -r--- 10�4 0 29.038.53 � ) JUI-12 $ �"I�,00� _ - - _.. _ __ _ _--, .. �, �:�, ------- --�--- �- --- ---- _ . .._-. _ - -- _Jun 12 � � 1�32� t� --- �, . ,� z- - ---ti- ---- �_- - - $ _30.268.53 $ (93,814.60) 0.03/0.03 � - . . � - t $ -18,569.46 $ _ (75,245.14) 0.03/0.03 _ _ --- -- . _ Au�-12 $ 10,.00Q OQ _ � F¢ � �� _ 0.03/0.03 - - --- -, _- -- - _- ,,� 4 � � �� {� $ . -- -376.23 - --- - - 10,376.23 -- . 29,038 53 f $ 18,662.30 $ (56,582.84) Sep-12 $ =�CI,Q00,�0 _ ____ _ _ _ ' �'° �� : $_ 282.91 , 10,282.91 , 29.038 53 ; $ 18,755.61 , $ ___(37,827.23). 0.03/0.03 . - -- _ _ _P13 _ ' , :��: ��.4���.`�°.�' $ - � - ' � � $ '� $ 37,827.23 � -.. ,; . --- --- -- --- - - --- �. ` �#, ,�'� $--- - �--- ------- +------- -+-$ --- $ _ (37 827.23) Total YTD„$ 159,38672 ; - --_ --- _-__ -. -- $ �.•.��Rr�0�1_$�� $ _ _6.216 32 ^--y-- 195.834 89 ;-__- 319,308 37 _$ -123,673.47 . - _____.-, - r- ,� -- -'r ----'-- -- - --- ----t- _-_ _ _ , , _ . _ _ _ _- -- - --- ---- --- 1)ncludes annual char es for Admin Char e$10,450 ! i _-. _.. ( ) �-------� -- ------- -�------ --- -- �--_ � . --- -- --- !FY 10/11 Write off of $616.53 --- -_--- -__--_-i - f .. --- _ __ --- - -Y-- - -- - - - 2 Safet Harbor Antiiquated Main Re lacement $30,034.21 '-- ~ ~ , ____ ___ _____ - ,- _�— p - _�.-_ . --- ---- - r- _ -- -- --- ---- _- - -- 'Also, $103,711.29 reversal of rior ear accrual i + CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 3 of 4 " USAGE AND INFLATION ADJUSTMENT�UTAI_ � � ' -- -� _- ' Coii�merClal�� � � _ _ ��� _ ! Monthly _� Cumulative_ UTA _ � :; �-- -- � �- - - Budget _ Interest � _ Overage __ YTD Overage NG/Therm Month __ __ T _ LP Gallons Expense �Rate/Galton l' NG Therms l Rate/Therm (Shorta9e) (Shortage) LP/Gal -- Beg Bal. :_ ' -- �-- -__ _- - --- ---- -�- Oct 11 5,770A : $ _ 3,224.76 . _ -- --- -- - --- --- Nov-11 5,895.2 $ 3,052.44. Dec-11 ----- ------ ------- 6 $ 2.861.27 Jan-12 � _ - - -- 7,713.4 ; $ 2,536.06 ' Feb-12 ---- --r - ---- 7,803J i $ 2,098J81 Mar-12 --- �--- ---- --- . - 7,254.0 ! $ 1,694.96 ' - �- ---- - -�-- ------- _--- -r- Apr-12 --- --- 7,359A j $ 1,290.87 ' ___ - May-12 _ �-- 5,004.0 ! $ 899.57 _ -- ---- --- Jun-12 ~ 6,689.9� $ __ 643.67 � -- -- --- �_ -------- ---- Jul 12 ' S.500.0 ; $ _ 394.35 ', ---- ..- --- - Aug-12 ' 5,500.0 ! $ 203 60 _ _ _ _ _ __- _ -- -- --------- ---- -- Sep_12_', ---- ------- - 5,500.0 , $ - , --Per 13 ' -- - � Total YTD' -- --- ' -_- ------- 77,620.9 ' ---18,900.33 � _ __ . .� - --__-�-- -- -- - --� (1)' December Overage is reduced �$8,293.09, which was the FY 10/11 interest that was -- -- - ----T- USAGE AND INFLATION ADJUSTMENT IUTA) ___________ ___ _ Resic�en�lal;, °� - � _. --- --- _- _ _.. . -- _--- �.__ .- ---- _Budget r_ ' Interest . ___ - -r---- --- - - Month LP Gallons ;__ Expense ' R - -. - . -�- - _._ �- 8eg Bal� --- _;----� - -- - -- Oct 11 28,470.2 , $ 904.01 -_ �- _ ___ .-- - --- --- --- Nov-11 _ 23.628.7 ' $ --- 886.30 - _- -- ----_ --- - Dec-11 27,524.4 . $_-_ 866.37 !, ---- --- _ ----- -- _ __-_ _ _ ---- - Jan-12 . . 32,310.3 ,-$ __- 780.08 'T -- -- _ _ ----- - ----- - --- �-- Feb-12 28,950.7 , $ __ 656.66 ' - - -, __ _ _ ._---- ---- _ - . -- - ---- ---- - Mar-12 32,110.4 ' $ 551.25 ' ---- �- -- -- --- - --qp�=� 2 � 18,817.8 $_ _ 454.91 ; _ _ __�_ -- --- -- ----�_ .. .--- -- May-12 20,839.0 $__ _374_00 __ __ _._ _ _ ---- -- - ___ --- Jun-12 - -- 18,685.5 $ ___- 303.55 ! . �. _ --- �- - - Jul-12 ----18,000.0 $ 238.13 '. _ --- -- -- -- .-- _-- --- -- ---- Aug-12 18.000.0 ' $ --175.55_!}-- -- __ -+- - _ _-- -- -- Sep-12_,__ 18.00OA �, $__ 91.41 ' -- -- ,- _ - --- --- -- --- -- Per 13 Total YTD- - ----' 285,337A __6,282.22-'- •_- -- --- ---- --- --- ----- --- (1) December Overage is reduced by $723.06, which was the FY 10/11 interest that was e _ - -_:.. - __ ___; __- ------ - ----- - ___ _- -i-------_____-------------- ',-____------- � -�- ' $ - I $ _ (644,952.53� -- ) 0 05 I 748,591.5 i 0 05 '$ 34,465.20 $ (610,487.33)' 0.05/0 05 0.05 � 818, 20 8 9 0.05 i$ 38,234.32 j$__ (572,253. ) 0.05/0.05 0.08 ` 1 946,953.4 { 0.08 �$ 65,040.78 �$ (507,212.22) 0.08/0.08 0.08 � 1,122,897.5� 0.08 '$ 87,455.32 '��$ (419.756.91)' _ 0.08/0.08 0.08 ; �- 1,025,942J ; 0.08 80,764.92 �$ (338,991.99)I _ 0.08/0.08 0.08 ! � 1,027,935.0 ' 0.08 ' $ 80,817.85 � $ (258,174.14) 0.08/0.08 -- ' - -i- -- - -- -- - _ 0.08 ' ' 987,423.4 � 0.08 ; $ _ _ 78,259.93 � $--_(179,914.21)'. 0.08/0.08 --- _ _ - �- 0.06 862,953.7 � 0.06 $ 51,180.66 I$ (128,733.55) 0.06/0.06 � - -- 0.06 ; ! 853,840.1�_ _ __ 0.06_; $ _ _ 49,863.01 $ _ (78,870.54), _ 0.06/0.06 0.06 ' -� 650,000.0 i 0.06 I $ ___38,150.10 ! $ (40,720.44) ___0.06/0.06 - --- -__ ___0.06 _ __ 650,0000 � _ 0.06' $ 38,150.10 $ (2,570.34) 0.06/006 - -----; --- ---- - - - - - -- 0.06 ; 650,000.0 I _ 0.06 .$ 38,150.10 $__ 35 579.76 0.06/0.06 - ----�-- i - -�---- . _ _ _ _ _ _ � � -- ---- --- ___ . ' 10,344,566.2 !, ! $ 680,532.29 ---_--------- ----+-- -- • -- ---� .--- -- __ _ --- ' -- -- -- --- --- -- -- - _ �usly left out of the adjustment calculation. ' - - - --------- � --- --- -- - _ _-- _ __ - _ - r - ---- r-- --- ---- -- - __ ____ . __ . Monthly__ _ Cumulative UTA ---- -- --- --- -- - - -- - - - Overage YTD Overa$e NG/Therm on � ; NG Therms _ � Rate/Therm � (Shortage) _ (Shortage) LP/Gal ----- --- 7---;---- ---�-$ - -•-$ - i180,801.96 ------ _ _- - - � _ 0.02 194,083 1, 0.02 !' $___ 3 541.17 $_ (177,260J9 0.02/OA2 --•-- -+---- -- ;T -- -- - - - - - - __ 0.02 219,872 8 0.02 ; $ _-_ -3.986.29 $ -- (173,274.50) 0.02/0.02 -- �-- --- - - - - 0.06 1 288,762.0 , 0.06 $_ 17,259.34 $__ (156,015_17) 0:06/0.06 _- ----�-------+-- - __. _. ----�-- - - - 0.06 . _ __ ___405,103.4 ' 0.06' $ _ 25,463.36 $__ (131,331 _88) _ 0.06/0.06 _. -- --- ---- 0.06 ': 344,333.4 j___ 0.06; $ 21,738.00 $ (110,250.54) 0.06/0.06 -. - _ . - --0.06 ! -� - -- 307,976.2 j -- 0.06: $ - 19,819.82 $ (90,981.97) 0.06/0.06 --- ----�- ------�-- --- -- - _-- _ __. 0 06 _,__ 265,924 0; 0.06 i$ _ 16,637.02 $_(74 799.86) 0.06/0.06 - - -- ----- __ _ 0 06 � 226,784 9, ___ 0.06 $ 14,46429 $ (60_709.57). 0.06/0.06 --- - ----- - ---- ----- - 0 O6 i ___ 209,797.4 ,_ __ 0.06 $ 13,38773 $ (47,625_39) 0.06/0.06 0.06 � 200,000.0 ; 0.06 $ 12,753.00 ' $ (35,110.51) : 0.06/0.06 ----�- - -- -; ---- --- -- --- 0.06 ; 200,OOOA ', 0 06; $ 17,004.00 $ _(18 282.07) 0.08/0.08 - -- --- -- - _ _ - --- 0 06 ; �__ __ 200,000.0 0.06' $ 17,004.00 $ (1,369.48) _ 0.08/0.08 - --- - --. __ __ __ ,$ - _ _- - --- , __ _ _ �___, 3,062,637.2 ! $ 183,058.02 --- -�--�-- - ------- . - ------- --- ----- -- - -- -- -- -- _ --- -- _ _ _. s� left out of the ad�ustment calculation. - -- __ -- i------_---__ __ _ _ ...--- - _�- _ Month '! ------- Prior Year; Oct-11—' -------? ---- - Nov-11 - -- --... _- --- — Dec-11 -------__ __ _ --- Jan-12 Feb 12 __-- - — -�- _ __ _ Mar-12 --- - � - --- --- Apr 12 _ _ May-12 Jun-12 _. _ _ _ _ ---- _ __ _ — --- Jul-12 ----- _ .------ - Au�-12 --- ____----- Sep_12 rt_ _ _ --Per 13 -- _- Total YTD' CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 4 of 4 ' — -�- ^ - — ___- --- --- -- - _ _ �_ , Monthly __ _ Cumulative Total Resl --- ---- - Total All ; Total Recove�l_ Overage �_ YTD Overage _NG/Thm (Ffrm) Expenses Billed __ I (Shortage) (Shortage) ` LP/Gal (Resl) _ - - ' $ - $ (1,050,453.68)! 6,308,168.93 ' $ 1,494,939.87 � $ (4,813,229.06}! $ (5,863,682.74) 0.99/2.63 1,215,080.82 '$ 1,678,149.82 i$ 463,069.00 '$__(5,400,613.74) 1.04/2.63 1,308,027.52 '; $ 1,980,532.69 r$___ 672,505.17 $_(4,728,108.57) 1.08/2.67 1,473,386.05 ;$ 2,282,918.97' $ 809,532.93 I$ (3,918,575.64) 1.08/2.89 1,311, 0944 8$ 2,038,908.66 i$ 727,414.58 I! $(3,191 161.06) 1.05/2.81 il 1.307,229.19 i$ 2.004,551.29 '$ 697,322.10 '$_ (2.493,838.97) 1.03/2.81 1,280,765.85 � $ 1,862,659.00 . $__ 581,893.15 ', $ (1,911,945.82)' 1.03/2.81 992,880.83 ' $ --1,625,180.18 � $ 632,299.35 ' $ - (1,279 646.47) 1.01/2.74 1,115,433.13 ! $ 1,559,862.04 '! $ 444,428.91 ' $ (835 217.56) 1.00/2.61 1,034,010.27 $_ 1,371,615.10 i$ _ 337,604.83� $ (497,612.73);, 1.00/2.61 1,031,786.40 ', $ 1,336,468.32 , $ 304,681.92� $ (192,930.81) 1.00/2.23 — - --,--_ 1,131,014.63 i$ 1,336,46 38 2$ 205,453.69 ;, $ 12,522.88 1.00/2.23 — -------- ----- - - 333.372.34 ; $ 291,444.92 I $ (41,927.42) $ (29 404.54) __-- �I 9,842,650.04 ' _ 20,863,699.18 ��$__ 1,021,049.14 . ,, � - -- __ � - _ _ - _ __. . Last Updated 07/13/2012 cJ # � � � �L ^ � � �.. N U � �_ c� � �� Za N U� � x � � S N � � � N � � 8 � � � N N � F � s m x m � U 3 $ o � � ,q a bR � � � � � � � � S � p � B r � w .. � � � � N � � � � � � w � � � iy � � � �'� O � r m � � 8 0 Propane Weighted Average Cost of Gas (WACOG) /� �i...�, G��� � �7/102012 FY 2011-12 �� ' Delivered Delivered Delivered Morith CGS Cost : Gallons Cost � . a� "` : e'� "�. r,�, � � s�„ �K� ,� r� ��r,�x,� �- �+ �5 Jun-12 � : �#���������^� , ��� �,�.�,�_ >;:. �� Jul-12 $ 1.05 - $ - Aug-12' $ 1.15 30,000 $ 34,500.00 Sep-12 $ 1.20 30,000 $ 36,000.00 Oct-12 $ 1.20 30,000 $ 36,000.00 Nov-12' $ 1.25 40,000 $ 50,000.00 Dec-12 $ 1.30 50,000 $ 65,000.00 Cost of Irrver� $ 85,660.65 $ 120,160.65 $ 120,359.48 $ 120,499.07 $ 134,597.08 $ 150,957.79 Total Gallons 70,690 100,690 100,690 100,690 110,690 120,690 EOM Tank Gallons 7� 70,690 70,690 70,690 70,690 70,690 70.690 EOM Tank $ 85,660.65 $ 85,660.65 $ 84,359.48 $ 84,499.07 $ 84,597.08 $ 85,957.79 $ 88,418.31 Projected W_ 1.21 1.21 1.19 1.20 1.20 1.22 1.25 CSW:07113/2012 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Enerpv Charae/Therm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIA) Usage & Inflation Adj. (UTA) Total Non-Fuei Energy Charge Purchased Gas Adjustment (PGA) Total Energy Charge/Therm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP/Gallon Rate ot with 6.0% Franchise Change from 1/2006 Therm Rate °h Change from 1/2006 Therm Rate Utllitv Tax Note: Fuel Rate per Therm 10/01/1973 Non-Utility Taxable Fuel/Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR AUGUST 7, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural Gas Rate Schedules RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL w/M3 NGV (Closed 1/09) Relinht (Non-Resl) NA (1 - NA (4 + NA (4 + NA (4 + 0- 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons &+) $10.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $10.00 $25.00 $40.00 $20.00 $20.00 By Contract ($18.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($18.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) if not prev. if not prev. if not prev. billed billed billed $0.48 $0.48 $0.48 $0.48 $0.46 $0.40 $0.34 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract 0.13 0.13 0.13 0.13 0.13 0.13 0.13 NA NA NA NA NA NA 0.03 0.03 0.03 0.03 0.03 0.03 0.03 NA NA NA NA NA NA 0.08 0.08 Q08 0.08 0.06 0.06 0.06 NA NA NA NA � NA $0.72 $0.72 $0.72 $0.72 $0.68 $0.62 $0.56 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract 0.76 0.76 0.76 0.76 0.76 0.76 0.�7C .76 0.76 0.76 0.76 0.76 0.68 1.48 1.48 1.48 1.48 1.44 1.38 1.32 0.96 0.91 0.86 0.96 1.11 0.68 + Non-Fuel $10.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $10.00 $25.00 $40.00 $20.00 $20.00 By Contract ($18.00) (540.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($18.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) @ premise @ premise @ premise + FAC + FAC + FAC $ 1.35 $ 1.35 $ 1.35 $ 1.35 $ 1.32 $ 1.26 $ 1.21 $ 0.88 $ 0.83 $ 0.79 $ 0.88 $ 1.02 $ $ 1.44 $ 1.44 $ 1.44 $ 1.44 $ 1.40 $ 1.34 $ 1.28 $ 0.93 $ 0.88 $ 0.83 $ 0.93 $ 1.08 $ $ (0.78) $ (0.78) $ (0.78) $ (0.78) $ (0.71) $ (0.71) $ (0.71) $ (0.92) $ (0.92) $ (0.92) $ (0.92) $ (0.87) $ -34.5% -34.5°k -34.5% -34.5% -33.0% -34.0% -35.0°k -48.9% -50.3% -51.7% -48.9% -43.9°k $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.691 $0.691 $0.697 $0.691 $0.691 $0.691 $0.691 $0.691 $0.697 $0.691 $0.691 $0.691 Interr. NG Rate NSS IS (Non-Resl) NA 100,000 6 up $50.00 $250.00 ($75.00) $400.00 Attachment #4 Contract NG Rate CNS NA By Contract (By Contract) $0.46 $0.28 By Co�tract NA NA NA NA NA NA NA NA NA $0.46 $0.28 By Contract 0.76 0.68 0.68 1.22 0.96 0.68 + Non-Fuel $50.00 $250.00 Customer ($75.00) $400.00 Charge + + FAC + Non-Fuel Therm Non-Fuel Therm Rate tor Contrect Rate for Contract # of Therms # of Therms 0.62 $ 1.12 $ 0.88 0.66 $ 1.18 $ 0.93 (1.10) $ (0.93) $ (0.78) -61.8% -43.3% -44.8% $0.069 $0.069 $0.055 $0.611 $0.697 $0.625 BTU FACTOR = THERMSH00 CUBIC FEET ICCF) 10/2011 11I2011 12/2011 01/2012 02I2072 03/2012 04/2012 05/2012 06/2012 07I2012 OB/2012 09I2012 FY 11/12 Averaae Firm Service Rates 1.035 1.036 1.036 1.036 1.035 1.035 1.035 1.034 1.039 1.034 1.036 1.036 Interruptible Service Rates 1.075 1.016 1.016 1.016 1.015 1.015 1.015 1.013 1.019 1.014 1.016 1.015 $ (0.78) -53.4% $0.069 $0.611 CSW:07113/2012 Attachment #5 Page 1 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR AUGUST 1, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMILY LOOP RESL. SMALI. COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP (Non-Resl.Only) (Non-Resl.Only) Applicable Annual Gallon Range NA NA NA 0- 2,500 >2,501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (1 - 3 Units) (Closed for New Resl. Applications) Monthly Customer Charge $10.00 $25.00 $10.00 $25.00 $40.00 $40.00 $50.00 Set By Contract For Each Meter Non-Fuel Enerqv CharsaeslGallon: Non-Fuel Energy Charge (NFE)/Galloi $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract �1.00 Set By Contract Energy Conservation Adj.(ECA)/Gallor 0.13 0.13 0.13 0.13 0.13 NA NA NA Regulatory Imposition Adj.(RIA)/Gallor 0.03 0.03 0.03 0.03 0.03 NA NA NA Usage & Inflation Adj. (UTA)/Gallon 0.08 0.08 0.08 0.06 0.06 NA NA NA Totai Non-Fuel Charges (NF)/Gal. $2.14 $2.14 $1.14 $0.52 $0.47 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal 1.99 1.99 1.99 1.99 1.99 Set Bv Contract 1.99 1.69 Total Energy ChargeslGallon $4.13 $4.13 $3.13 $2.51 $2.46 Contract NFE $2.99 Contract NFE + + Contract PGA $1.690 Customer Charge Customer Charge + Minimum Monthly Bill $10.00 $25.00 $10.00 $25.00 $40.00 Any Applicable $50.00 Non-Fuel Energy Chg. Utilitv Tax Note: Fuel Rate per Gailon 10/01/1973 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable Fuel/Gallon $1.829 $1.829 $1.829 $1.829 $1.829 Change from 8/2008 Gallon Rate $ (0.01) $ (0.01) $ (0.21) $ (0.23) $ (0.23) % Change from S/2008 Gallon Rate -0.2% -0.2% -6.3% -8.4% -8.6% Customer Charge + Any Applicable Facility Charges 0.161 0.161 Contract PGA - 0.161 $1.829 NA 5 0.06 NA 2.0% for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:07/13/2012 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallonsl100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLP1 BRlP2 BRLP3 BRLP4 Applicable Annual Gailon Range 0- 60 60.1 - 120 120.1 - 300 � 300 or Other Rate Determinant t-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annual Customer Charge $ 210.00 $ 180.00 $ 90.00 $ 75.00 Non-Fuel Charaes INF)IGallon: Non-Fuel Energy Charge (NFE)/Gal. $ 1.80 $ 1.60 $ 1.00 S 0.90 Energy Conservation Adj. (ECA)/Gal. $ 0.13 $ 0.13 0.13 0.13 Regulatory Imposition Adj. (RIA)/Gal. $ 0.03 $ 0.03 0.03 0.03 Usage & Inflation Adj. (UTA)/Gallon 0.08 0.08 0.08 0.08 Total Non-Fuel Charges (NF)IGaI. S 2.04 S 1•84 S 1.24 S 1.14 Purchased Gas Adj. (PGA)/Gallon $ 1.99 $ 1.99 $ 1.99 $ 1.99 Total Energy Charges/Gallon S 4.03 S 3.83 S 3.23 S 3.13 Note: No Monthly Minimum Biil Uti1iN Tax Note: Fuel Rate per Gallon t0101/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 Non-Utility Taxable Fuel/Gallon $ 1.829 $ 1.829 $ 1.829 $ 1.829 Change from 8/2008 Gallon Rate $ (0.010) $ (0.010) $ (0.21) $ (0.21) % Change from S/2008 Gallon Rate -0.2°/a -0.3% -6.1 % -6.3% Attachment #5 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR AUGUST 1, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTiAL "WILL CALL" (Based on Annual Usage Level) WRLP1 WRLP2 0-120 >120 1-3 UNITS 1-3 UNITS $ 150.00 $ 75.00 ' $ 1.60 $ 0.90 0.13 0.13 'I 0.03 0.03 0.08 0.08 I, E 1.84 E 1.14 I $ 1.99 $ 1.99 ! S 3.83 S 3.13 I, COMMERCIAL BULK LP SERVICE I, (Based on Annual Usage Level) ' BCLP1 BCLP2 I 0 - 2,500 > 2,500 Customers in this Customers in this I Range of Usage Range of Usage $ 90.00 $ 90.00 $ 0.25 $ 0.20 0.13 0.13 0.03 0.03 0.06 0.06 E 0.47 S 0.42 , $ 1.99 $ 1.99 E 2.46 S 2.41 BULK STANDBY/ GENERATOR LPSB (Closedfor New Residental Applications) $ 420.00 $ 1.00 NA NA NA E 1.00 $ 1.99 t 2.99 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ $ (o.o�� $ (0.2�) $ (o.2a� s (o.2e� $ -0.3% -6.3% -10.2% -10.4°h CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract Set By Contract NA NA NA Set By Contract 1.69 Cotract NFE + 1.690 0.161 $ 0.161 1.829 Contract PGA - 0.161 0.06 NA 2.0% NA csw:on�3rzo�z ; i ' ! Attachment #6 � _ .. _ � . � , _. .._ _ ._ . _.�_ ... ... . .._ , i .. � . . . . �... . ' Pagelof3 Residential Rate History By Components _ _ __ __ __ - _ __ . _ ___ Clearwater Gas Svstem _ , , _ , __ � � � i i _ __._ _ . _ . . _ _ __ i Total Rate � Ad'us� tments/Therm Contract �,,P T=�� �Monthr e� LPlaallon' 1 i � ECA, EIA/RIA# i WNANIA-ReslilTUlA-Comll# PC�A � P A PGAlaallon I - i � • • - * --- - -- _ __ __ ._ _ _.. .._ _ .. ____. __ - -_- __... .. . $ 0.140 i $ .. - � $ . -.. $ - $ 1270 $ 1.190 $ , 2260 1- -- �-- --- --- I f- -- . $ 0.140 I$ - � $ - $ _ - $ 1270 � $ 1.190 ' $ 2.260 - . Nov-081 $ 1 990 , 3.300 , I _ i- -. i I _ -. _ . Oct-OBl $ 1 990 $ 3 300 - $ _ Dec-08 $ 1 940 $ 2 770 I i i �$ 0.140 ,$ i$ - .$ $ 1.220 i$ 1.140 �$ 1 730 -- - � Jan-09 $ 1 750 $ 2 290 � # I � ' $ 0.090 $ $ - $ $ 1.180 � $ 1.100 $ 1 200 ._- - - - .. .- --. . ._ . - _ _ -- - Feb-0��$ 1 750 $ 2 2901 1 t i$ 0.090 �$ j$ _ 1$ +$ 1.180+I-$� 1 100 �$ 1.200 Mar-09 $ 7 580 � 2 270 I 1 �$ 0.070 !$ - i$ - '$ $ 1.030 I� 0.950 $ 1.200 - -- _ . A�r-09 $ 1410 $ 2.200i . . + �$0.040�$ r$ - 1$ . {$0.890�$ 0.810,$ 1.160 - - - � -- - - - May-09 $ 1 410 , $ 2.200 ' $ 0.040 + $ $ . $ - � $ 0 890 $ 0.810 ' $ 1 160 _ - -+ _ __ . . _. -- Jun-09 $ 1 410 1$ 2 200 � i . � i$ 0.040 �$ $ _ - i$ - j$ 0.890 �$ 0.810 �$ 1.160 _ -- - Jul-09 $ 1 350 I$ 2 330 � i I$ 0.040 ,$ - �$ - $ - �$ 0 830 $ 0750 $ 1 290 i t i _ � -- . _ f - t , . Se-09 $ 1 350 $ 2 490 _ i $ 0 040 $ _ . _ _ - I $ -. $ - C $ 0_630 ' $ 0.750 � $ _ 1.450 �$ 1.390 �$ 2.650 � I - � I$ 0.070 �$ 0.010 r$ $ +$ 0.830 f$ OJ50 I$ 1.570 Gv nnino e.,,, i e � a�n i e � s�e i i � c m m� i t n nm i t . i t . i s � n�a x o nas I s �_a�o - Oct-0�� $_ 1 390_ � $ 2.670 � � T . � $ 0,070 I $ .0,010 T $ - _ � $ - � $ 0 830 r $ 0.750 I $ 1 590 Nov-091 $ 1 390_ i$ 2 670 I 4 �}i I$ 0.070 1$ 0.010 �$ -+$ - I$ 0 830 {$ 0 750 j$ 1 590 . Dec-091 $ 1 390 $ 2 750 _ I I $ 0:070 $ 0,010 �$ - l$ - �$ 0.830 +$ 0 750 $ 1 670 Jan 10 $ 1 390 $ 2 750 T Y �$ 0 070 �$ 0.010 i$ - $ - �$ 0 630 $ 0 750 �$ 1 670 - - - -- - }- = - - � Feb-10 $ 1 480�$ 2 810 � J $ 0.170 y$_ 0.010 $_ - �$ -�$ 0.880 1$ 0.800 $ 1.690 ---- -_. - - -- Mar 10 $ 1 520 '$ 2 880 A 1 � $ 0.110 I$ D.010 f$ _ $ - $ 0 920 i$ 0.840� $ 1 760 - --�- -_ . AQr 10 $ 1 520 $ 2 880 j i s o i�a 1 s o.o�o T s -__ s - t s o szo � s o_eao s�. 1�so Ma 10 $_ 1 490� $_ 2.850 ' �$ 0_090 I$_ 0_030 I$ - $ - $ 0_890 f$ 0.810 $ 1 730 --- _ _ _ - Jun_10 $ 1.46�$ 2.950 j I $,0.090 � $ _ 0.030 � $ - $ - � $ 0.860� $ 0780 $ _ 1 830_ Jul-10� $ 1 430 $ 2.990 T{$_ 0.090 $ 0.030 $ ._ $ - $ 0 830 $ 0750 $ 1.870 Aug-10 $ 1.390 $ 3.090 $ 0.090 � $ 0.030 $ . � $ - $ 0 790 � $ 0.710 $ 1.970 --- - --_ - _ _ _ - ---- -- - S 10 $ 1.390 � $ 3.090 _ . - - - � 0.090 i $ 0.030 �$ - I $ - $ 0.790 � $ 0.710 i $ 1.970 Y 09H 0 Av . S 7.437 S 2.865 � � S 0.088 � S 0.018 S I S I S 0.850 I S 0.770 S 7.758 !009 Av . I S 7.464 f 2418 I I S 0.061 S 0.003 S S I S 0.920 ' S 0.840 I S 1.353 --- -- -._ . _ - � - � -- -_ __ � _ _ � -- -- Oct-10 $ 1 47 $ 3.02 � �$ 010 $ 0 02 �$ _ �j $ - � $ 0.87 $ 079 $ 1 90_ - - - _ - r -- $ - J $ = ±$ 0.87 $ 0,79 $ 1 90 - -- Nov 10 $ 1 47 $ 3.02 $ 010 �$ 0.02 _ - - - -- _ _ . _- Dec-10 $ 1 47 $ 3 02 $ _010 $ ,0.02 $ _ $ - $ 0 87 $ 0.79 $ 1 90 . _ _ _ Jan 11 $ 1 54 $ 3 33 � $_ 010 �$ 0.02 i$ 0 02 i$ 0.03 $ 0.92 $ 0.84 $ 2 19 __ Feb 111 $ 1 55 $ 3 37_ i $ 013 $ 0 03 �$ 0 02 $ 0.05 $ 0 89 $ 0.81 $ 2 19 _ r 11 � $ __ 1 46. $ 3.28 _ t}� $_,_0.10 $ _.0.04 $ 0.02 � $ OAS�$ 082 { $ 0,81 $ 219 M�ar 11� $ 1 55 _$ 3.37 $ 013 $ 0 03 $__ 0 02 $ 0.05 $ 0 89 $ 0.74 � $ 2 12 Ma� 11 $ 1.4 5 $ 3. 3 5 I _. I $ 0. 1 2 $ OA 2 $ 0. 0 2 �$ 0. 0 5 i$ 0. 8 1 !$ 07 3 $ 2 1 9 _- - - - - -- - - J u n 1 1 $ 1 4 5 $ 3. 3 5 r $ 0 1 2 I$ 0. 0 2 $ 0 0 2� $ 0. 0 5 j$ 0 8 1 �$ 07 3 $ 2 1 9_ _ -- _ _ � - Jul-11 $ 1 45 $ 3.35 $ 012 i$ 0.02 �$ 0 02 �$ 0.05 r$ 0.81 $ 0:73 $ 219, - -- - -- _ _ __ _ Aug-71 $ 1.42 $ _ 3.46 � �_ � _ $ 0 12 � $ ._0.02 � $ _. 0 02 I $ 0.05�$ 078 $ 0.70 $ 2 30 Se 11 �$ 1.42 $ 3.46 - I $ 0.12 $ 0.02 '$ 0.02 t$ 0.05 $ 078 �$ 070 -$ - 2.30 FY 10N7 Av . S 1.475 S 3.282 I 5 0.113 ; S OA23 � S 0.015 I S 0.036 S 0.843 S 0.763 � S 2.730 2010 Av . S 1.457 S 2.946 S 0.096 I f 0.021 � S S I S 0.860 j f 0.780 I S 1.829 - -- - -_._ 1 __ _ I � _ � _ � Od 11 �$ 1 47 $ 3 63� � � $ 013 $ 0.02 r$ 0 02 $ 0 OS $ 0 82 �$ 074 �$ 2 4G , -- - _ . - . - Nov 11 $ 1 52 $ 3 63 � � t$ 013 $ 0.02 $ 0 02 $ 0 OS $ 0 87 $ 0.79 $ 2 46 - - _ _ - -- Dec-11 �_$ 1 56_ S 3 67 � �$ OJ 3�$ 0.02 �$ 0 06 $ 0 OS i S 0.87 $ 0.79 $ 2 46_ _. _ _ - - - -_- Jan-12. . S 1 56 _$ 3 89 _ � $_0.7 3$ 0.02f $__ 0 06 $ 0 08 �$ 0.87 $ 0,79 $ __ 2 68_ _. Feb 12 $ 1 53 $_ _ 3 81 � I _ $ 013 $ 0 02 �$ 0 O6 $ 0 OS �$ 0 84 $ 0.76 �$ 2 60 __.. _ __ _ - -- -- Mar-12 $ 1 51 $ 3.81 � $ 013 $ OA2 $ 0.06 $ 0 08 $ 0.82 $ 074 I$ 2 60 - _ ._ _ _- - _. _- -_ __ __ Apr-12 $ 1 51 _ $ 3_81 __ _, $ _ 013 � $ _ OA2 ` $ 0.06 $ 0 08 i $ 0.82 $ 0.74 � $ 2 60 May 12 $ 1 49 $ 3 74 � $ 013 S 0 02 �$ 0 O6 $ 0 06t $ 0.80 $ 0.72 $ 2 53 ---- -- .... . . - � -- --- - ---- � . ___ L Jun 12 _$ 1 48 $ 3 61 � $_ 0'131$ 0.03 I$ 0 06 $ 0�$ 0.78 $ 070 $ 2 39 _ __ _ Jul 12 $ 1 48 $ 3 61 { 1 � $_0 13 j$ 0.03 i$ _ 0.06 �$ 0 06 �$ 0_78 $ 070 $ 2 39 --- Aug-12 $ 1.48 $ 3.23 1 j I $ 0.13 j$ 0.03 i$ _ 0.08 �$ 0 O6 $ 0.76 $ 0.68 ,$ 1.99 -- -- - - t } i _ _ _ _ i _ -- - - - __ ___ - ._ _ ier.Above i S 0.06 j (0.231� _ � E 0.01 � S 0.01 f S 0.06�5 001 � S(0.02�i S (0.02) S (0.31) - astYear � -- i .. . } - .. 1 -- -} -- 1 -- '� - 3%I �� -13% ame Month . .. . 4% 7% __._ 1 . ... .. _ 8%j . _ 50%I _. 300%1 � 20 �� .-3%61 .. _ , .. -. .. � .. _. � ? . _.. �. i � ... .. icr: Based s 'I.zo_ � s Is os) . I r i _ i. : _ I ; I - - n 20 Therms 4%$ -7i6 I I ' ; __ � + _. _ . - - - t t � - - 1 � - { - � ' � i r �l quivalent � i { } � I � 1 - �- - - � � � - - ents/KWH I 5.1, 12A � } -- __ _. . x Gas .� - I � . - � -- -.... i i t . __ � _ . J t � _ - - ' -- L _ � L - � i _, i . , s FPC Rate 13.2 y 13.2 { Note: This is Progress Energys residential rete for usage >1,000 KWH m January 2012. 1 a _ t _ -- - - -.. , . __ � - I i ResidenUal) j _ , _ --- • Y � l _ -s�� -9%� ; I _ } { , _ � __ { ' I ,as Chea i _ � , f } � . t -- -a -� --_ � _ _ . . _ t _ � , , __ �aes - � . � _ _ �__ . _1 _ __ _ : _ , . Based on Bulk LP (BRLP3� which is apphcable for customers using 120J 300 �allonslyear & equal to Residential LP Will Call (BRWCLP) , i - - _ . _. - __ _ � _ plemented 1%1/2009 with tollowin� chan�es _ i , _ .. _, � _ . _.. . . . . -� -_ . ew rates �mi RS NG Customer Charge increased $2 from $8 to $101mpnth & NFE rate droped 10 cents to 48 cents/therm (CC +$1/Mo. in 4/1/2005) . EIA changed to RIA & WNA chan�ed to UTA,_ but no additions to new components of these init�ally 9, ( �5, { , r �B ALP'3' PnC�^}�me'_n�" e incre_ased $18 from $72 to $90/ ear, and NFE rate raised 10 cent to S1 00/ aifon CC +12/Yc I^ 4/1/21 .__ 0 csw:si2aizo„ Attachment #6 Page 2 of 3 Competitive History of NG vs. Electric Rates Month-Year September 2001 September 2002 September 2003 September 2004 September 2005 September 2006 September 2007 September 2008 September 2009 September 2010 September 2011 NG Therm Cost $ 1.34 $ $ 1.36 $ $ 1.56 $ $ 1.69 $ $ 1.97 $ $ 1.89 $ $ 1.86 $ $ 2.12 $ $ 1.39 $ $ 1.39 $ $ 1.42 $ $ Increase over Last 10 Years $ % Increase over Last 10 Years Avg. Annual Inc. Over Last 9 Yrs. 0.08 $ 6.0% 0.6% NG Equivalent KWH Cost 0.046 $ 0.046 $ 0.053 $ 0.058 $ 0.067 $ 0.065 $ 0.063 $ 0.072 $ 0.047 $ 0.047 $ 0.051 $ 0.00 $ 10.4% 1.0% Progress Energy KWH Cost 0.084 0.074 0.084 0.089 0.097 0.119 0.120 0.120 0.132 0.136 0.132 0.05 57% 5.7% NG vs. Electric -46% -37% -37% -35% -31 % -46% -47% -40% -64% -65% -62% csw:i2izsi2o�� _ , _ � ' _ �Attachment#6 _ , __ _ _ i-----__ ----- - _ � �' ' ; Page 3 of 3 _; :, ._ , _ , � � � ; �I � � �+ � __ __ , . _ _ � _ � : � _ __ � � _ Annual Average CGS Residential Rates _ _ _ , _ _- _ _ _ - - ___ __ ___ , , ,, � � :' - -- - � _ _ -� -- Calender Year '� ' Fiscal Year Year � NGITherm ' LP/Gallon * 1 �Year_ _ 1 NGITherm � LP/Gallon * - -- - -_ _ 1995 '- NA NA � i FY 95/96 ;$ 0.880 ,$ 1.199 ;" - --- � _ _ _ , , _ __ r _ _ . 1996 j$ 0 915 $ 1.239 r* ; FY 96/97 $ 1.019 $ 1.370 * - __ _ _ 1997 1$ 1.049 �$ 1.380 " i FY 97/98 $ 1.054 ;$ 1.318 �" _ - _ ____ .. _ __ 1998 $. 1.032 �$ 1.288 " i FY 98/99 '$ 1.052 ;$ 1.269 j"` 1999 �$ 1.073 i$ _ 1 311 ' FY 99/00 1$ 1.152 �$ 1.504 ' - . _ f -- -- - - � --� --- - +� _ - ; - 2000 f$ 1.222 $ 1 584 FY 00/01 $ 1.551 $ 1.649 , __ 2001 $ 1 549 $ 1.586 �FY 01 /02 �$ 1.352 i$ 1.488 'i - -- -- - _ __ 2002 �$ 1 342 I$ 1.553 ; FY 02/03 i$ 1_ _477 �$ 1.817 A_ - -- - -- � 2003 $_ 1`534 �_$ 1.864 + � FY 03/04 1$ 1.603 �$ 1 913 I -- ---- � - - --- _ _ -- } - - -_ _ 2004 ;$ 1.652 I$ 1.968 I FY 04/05 ,$ 1.803 !$ 2 162 ; 2005 $ 1 925 $ 2.278 1 �FY 05/06 �$ 2.080 i$ 2 480 � 2006 -�$ 2 012 $. 2 501 � _(FY 06/07_ $ 1.932 I$ 3.183 � --- - --- -__ -- - --__ .._ _- � a 2007 __ $ 1 893 $ 2 869 FY 07/08 � 2008 $ 1.965 $ 3.186 1 FY 08/09 f$ 1.610 $ 2.524 __ --- - - --- r -- -- - -- -- - -- - --- � _--- }_-_: _-_- � - - -- � --- 2009 $ 1.464 $ 2.418 FY 09/10 $ 1.437 $ 2 865 � 2010 -- -- -�- ,$ 1.457 $_ __ __ 2_946 �_ � FY 10/11 f_ $ 1.475 1$ 3.282. � 2011 -. � $ 1.487 $ _ 3.438 .. -__1 _ - i -- - - - ----- _ , . � � ! Average j$ 1.473 $.. 2.088 -{ i$ 1.462 i$ 2.048 � __ I _ f _ _; _ , � _ _ ; � � ; _ _� t _ __ ; - � _ _ .__ _ _ + - _-- }---- -- i -- + . ! -_ __ :_ � I _ a ' -- _ _ _ _ _ ; Notes. I � I _ I --- - ' - _ _. . ' __._.1 . -.._ _-____L._.-.- ___. _- .L .___ 1 ._ . 1 .. . * Based on the Residential Metered Pro ane schedule which was closed for ------ ---------- - __-- ------- -p . _ ___ _--_ ------------ _ _ _.. ! __ _ new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond i --_ _ -- - --- -- -- -- --- -- - _ +_ _ based on Bulk LP (BRLP3) which is applicable for customers using � , _ -- - - _ _ 120.1 - 300 qallons/vear & is equal to Residential LP Will Call t ' }v.,.�Clearwater Gas System `Live Greener ; W�th�`a�� Fuet Use and Gost Comparison (Effective Rates for August 2012) APPLIANCE ' ANNUAL j NATURAL GAS , PROPANE (LP) GAS � THERMS � ; ; USED i i ___ __�__--. _-- ----.-_ __._____ � -___._ __. ________� ._ ___�__ -------______________._� COOKING _ � 45 ! $ 66.60 j $158.85 _ __ _ _ ; � .______.___ ______,.�_�___� __- _____. _ ___. _.__.--- -_. __ _ WATER HEATING _ �j ___ � .� _ ' ; -------- - ' -Gas Tank StylelGas Tankless � 170 / 100 � $251. 60 / $148. 00 * ! � Y $600. l 0/$353. 00 * �� vs. Electric Tank Style ___� , -_.� -_ _� ____ _. _----_ �______ HEATING � �� 150 j $222.00 _� _,_�_ $529.50 �� ELECTRIC ! i I �. $174.60 � ( $659.60 {� f ----- ' $582.00 i CLOTHES DRYING ! 50 � ! $176.50 $194.00 I _..__� --- , $ 74.00 __._� -__._ _ ______ _ __^� � TOTAL APPLIANCE � $614.20/ � $1,464.95/ �'� $1,610.20 � ,. USAGE-withtank/tankless � $510.60* _ _�___ ___$1,217.85* ! i --_ �_.�._ ---------s ---- _ ____ .____._ �_----- i i � � , ; -_��______'_�__�! ._�_v�__. _ ____ _ ____�.__ -- � ----- - ----__��.----- __ � __ ----. --__.�__J GAS S�AVINGS VS. � � 62% / 68°/a* � 9% / 24%� i � ELECTRICITY � � ' ( � - ------- ---...��___.�.-----».� ---�---_----- ------�________-_-______�� i ?*when usin tankless i*when usin tankless- LP � ' ____ �___ __ .� _ � S � __�.�..- g -� -------_ -__ �...___J OUTDOOR RECREATION: i _._._..-- - i_�.._..___.___--_______. ______.� ______�_.___...__._._.__._.� I POOL HEATING* _____�� _375_� �� _$555.00 __ �;_ $1,323.75 �__�__ _$1,455.00 ( SPA/HOT TUB HEAT*__� 175 � _ $259.00 � _ $ 617.75 ____� � $ 679.00 j *varies accordin�to�ool size, weather conditions, and tem erp ature maintained_ __ I ___"'"'_'"__""_'"'_" __"-_...� --'J � � ' i 1 __�.+._ �_...__....._.�_�i__..._..r._..w._.__..�_'"__""'"",_.....J...__..�.__._..._. �_�..��...__...,.v..._...._.........�.�.__._..__..._.._""""�"....�_ i All other figures are annual average_projections based upon the following: _____ _ � ---- ----- ---_�_ __.�----_..___ _.__.____ � 1. 1 therm = 100,000 BTUs of energy� � 2. Natural Gas _ _� $1.48 i ep r therm _�.�.. �_�____. �_� ��_� ___ ____ _... � � �.__.�.._.-.._�__ 3. LP Gas er allon BRLP3 I, $3.23 er allon or �$3.53 er therm � � P g ( ) ----- �_.�? g _ __________-�--_._._�_ _____.__._____________�__._____...___._...__________� 4. Progress Energy per KWH �$0.13226 � Per KWH or �$3.88 per therm ; j (Based on>1000 KWH rate� I � ' ' _ .._-__--_.-__--__--� , � -. _. _� ____ ___._--------- -----� __ ___ _ �-__.______ - 1. Notes: The above analysis is based on August 2012 residential energy and fuel charges and does not include ! applicable taxes or franchise fees. ' 2. Current monthly customer charges aze: j Progress Energy $8.76, Peoples Gas $12.00-$20.00 (varies by rate class), Clearwater Gas System $10.00 and i $18.00 in Central Pasco. L.P. customers are billed annually, $75-$210 (non-refundable) depending on program. j 711 Maple Street • Clearwater, FL 33755 •(727) 562-4980 www.cl earwaterg as.co m