Loading...
GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2012Y9`1 � CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet ���� � i���� �EC � �`� �.�,1� TO: William B. Horne II, City Manager ,�� ,�^� �u kr�F,,, � , �.d� �4i.e�iA 4+v,4..? . , � �s ,. FROM: Chuck Warrington, Managing Director ��g:.:�,' �� ��t: �. i�' Pj , y�'-' a V B�4 i.�: w�i lv..-J . � COPIES: Rod Irwin, Assistant City Manager;�osemarie Call, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. AccountandCGS; Laura Damico, Sr. Accountant/CCS; Lynne Priester, Cust. Serv. Coord./CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE JANUARY l, 2012 DATE: December 23, 2011 Natural Gas Supply Prices have been fairly stabile this winter; therefore, we do not need to change our Natural Gas PGA this month. However, LP supply prices ha�e climbed and are at all time highs; therefore, we are recommending that we increase our LP PGA by 22¢/gallon for January. We also recommend that we continue our Contract LP PGA at 30¢ below our Standard LP PGA. We are not recommending any changes in our Energy Conservation Adjustment (ECA), our Regulatory Imposition Adjustment (RIA), nor our Usage & Inflation Adjustrnent (UTA) for January. The net effect of these recommended changes for January is no change in our typical Residential Natural Gas customer's rate but an increase in our typical Residential LP customer's rate of 22¢/gallon (+6.0°/a). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after January 1, 2012: Natural Gas Firm Standard Rate Schedule PGA ...... Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ....... Propane (LP) Gas Standard Rate Schedule PGA $0.87 per therm (no change) ....... $0.79 per therm (no change) ............ $2.68 per gallon (up 22¢/gallon) Propane (LP) Gas Contract Rate Schedule PGA ............ Energy Conservation Adjustment (ECA) .................. Regulatory Imposition Adjustment (EIA) ....................... $2.38 per gallon (up 22¢/gallon) $0.13 per therm or gallon (no change) $0.02 per therm or gallon (no change) Usage & Inflation Adjustment (WNA) - Residential ............ $0.06 per therm or gallon (no change) - Commercial .........$0.08 per therm or gallon (no change) William B. Horne II, City Manager December 23, 2011 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru November. 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 Paae #2 of this analvsis shows that, over the nast 10 vears, our residential natural �as rates have risen iust 6.0% as comnared to a 53% increase for Pro�ress Energv Florida's residential rates. That's an average annual increase of 0.6%/vear for natural gas vs. 5.3%/year for electric --- a remarkable difference! I should point out that the overall effect is that our tvnical Residential customer rates are still approximatelv 59% lower than electric for Natural Gas. This is a very attractive competitive position vs. electric rates. And, this spread should increase as we understand that Progress Energy rates will increase in January. 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 January 1St billings. If you have any questions on this, please call me. CSW/csw Attachments ,r� Approved: �/;r�.t, '��k�z.-c�..y � • '�''�'-��--�. William B. Horne II, City Manager U:WIy DocumentsWISOFFICEIWINWORD\GASRATES\Gas Adjustments for January 2012.docx CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 1 of 4 rvrai urw� uNa rurct:rtH�tu l9AJ AUJU51 MtNI IPGA-NG) -- __ __-- --_ . _ --- - -__ -- - -_ _ -.. _. __ -__ -- _ �_ - Monthly Cumulative NG PGA -- -- --- --- -- Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm _ __ . - ___ _ __ --- __- __ -_ _ : , -- _ Month Charges _ Charges � Expense Expenses Expenses Billed ; (Shortage) (Shortage) Firm/Contr - --- Prior Year _ - - _ --- -- --- . _ _ _ _ _ _ _ Oct 11 $ 4,651 131.01 822 886.34 $__ 92 26 �$_ 39,448 03 ' 1 $ 5 513 557.64 �$ 1,253,222.79 �$ (4,260,334.85) $(4,278,787.28) 0.82/0.74 Nov-11 �$ 175157.39 830572.12 $ 21,393.94 $_ 39,12723 � $ 1 066,25068 1,403,233.01 �$ 336,982.33 $(3,941,804.95) 0.87/0.79 Dec-11 $ 185 000.00 1,000,000.00 '$ 19,709.02 $_ 50,000.00 � $_ 1,254,709 02 � 1,552,850.63 '$ 298,141.61 $(3,643,663.34), 0.87/0.79 -- __ --- - -- Jan 12 $ 185 000.00 1,075,000.00 , $ 18,218 32 . $ _ 50,000 00 $ __ 1,328,218.32 !~ 1,961,934.94 ' $ 633,716.62 ' $ _ (3,009,946J2) 0.87/OJ9 - -,- - Feb-12 �$ 165,000.00 1,025,000.00 ,$ 15,049 73 $ 50,000 00 �$ 1,255,049 73 � 1 803,310 41-! $ 548,260.68' $(2,461,686.04) 0.87/0.79 Mar-12� $ 185,000.00 975,000.00 $ 12,308 43 ! $ 50,000.00 'T , $ 1,222,308.43 ' 1 728,172.48 :� $ _505,864.05 $ (1,955,821.99)_ 0.87/OJ9 - - -� --- ----- --- - --- - -- --- -- - ---- - - - -- ------ -- _ Apr-12_ $ 125,000.00 875,000.00 I$ 9,779 11 $ 50,000 00 $ 1,059,779 11 ' 1,519,456 00 !$ 459,676.89 '$ (1,496,145.11)� 0.87/0.79 Mav-12 $ 80.000.00 825 000 00 i$ 7 480 73 '$ 50 000 00 ' �$ 962 480 73 1 335 785 49 �$ 373 304 76 !$ (1 122 840 34)� 0 87/0 79 Jul-12 aug-12 3eo-12 $ 80,000.00 - - - --- ' ' ' - ' �--- ' . , . _ . , , . _ . . -� - 785,000.00 j$ 5,614 20 '$ 50,000 00 '� I$ 920,614.20 � 1,252,298 90 '$ 331 684.70 $ (791,155.65). 0.87/0.79 - - - - - - � +- ---- - - -- - _ 785,000.00 $ 3,955 78 � $ 50,000.00 ' , $ 918,955 78 ! 1,235,601 58 , $ 316,645.80 � $ (474,509.85) 0.87/0.79 - - --- - - - -- -- _ 785,000.00 $ 2,372 55 I$ 50,000.00 � $ 917,372 55 : 1,235,601 58 ;$ 318,229.03 ;$ (156,280.82)i 0.87/0.79 - - -.. --- - - -- - -- - - - - - -- - 785,000.00 �$ 781 40 '� $ 50,00O.00T' $_ 915,781.40� ___ 1,235,601 58 $ 319 820.17 $ 163,539.36 0.87/0.79 _ _ _-- --- - - _ -!-- - _ -- --- _ 5 $ 390,816.69 � -- - $ (390 816.69) $ (227,277.33)' . Total YTD $ 6,462,105.09 $ 10,568,458.46 $ 116,755 47 $ 578,575.26 $ 17,725,894.28 !$ 17,517,069 38_'_ $ (208 824 _90) __ - . _ ---- ---- _ _ -- ----- - - - - -___ _ _(1)_Includes Annual Admin Charge of $708,720 + CCS chg of $1,052 690 + Dividend $1,300,720 ' + FY 10/11 PGA write off of $27,099.40 + WNA $304.10 - --- __ ---- - _._ - --__ __ -- - -____ _: _. __ __ __ __ ---- __ _ -- -- - --- _ _ _ ___-__ _-____ _ ___ _ _ _ _ _ _ -----__ _ ___ __ ' + Add'I Dividend based on FY11 Net Profit $1 452,850 68 = $ 4,542,384.18 - - - --- - - _ - --- - - - _ _- -- _ _ _ __ (5) Commodity ad�ustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Rate j _. _ __ __ - _ - -- - -- - - _ _ --- --- -- -- - -- -- _ _. _ _ - --- - - -- NG Proportion 97.9% x Total ECA Transfer = $ 390,816.69 i Net RC = $ 1,919,720.91 --- - _ ; _- _- --- - -_ _ --- - - . _ _--- -; ------__ - -- _ _ _ __ _ ( _ _-- ---- -- - _.._ - ---- -- -- - - --- - -•_- - -- - _ __ _ _ _ _ _ _ _ -- -- -- - - _ -- - -- PROPANE ILP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) f , - --- - - -- --- -- � -- -- --- - - --- _ - ------- � Mon[hiy - Cumulative LP PGA - --- - -- -- -- - _ --- _ _------ ----- ---- --- ----- _ -- -- � - Budget Y_ _ Gallons __ ___ _ Monthl�___ __ _�__ Interest ,____Commodity _�_Total LP Fuel :_ Total LP PGA _ Overage _ YTD Overage Therm/Gal. Month ' Sold WACOG __Expense_�_ Charges _ _ Expenses .__ _ Billed _ (Shortage) (Shortage) - � _ -- --- � -- -- - - - - Pnor Year Oct 11 34,240.2 $ __ _ --- 1 80693 $ 223.73 $-- 61,869.64 - -- - - $---(44 746_O6)_ . -i --- - - --- ---- --- - - --- --- -- _ _---- ` 53,198.89 ~ .. ---- - - --� -- - -� 2.24/2.46 -. - 1 $_ 300,093 75 $_ 83,495 97 $ (216 597 78 $ (261 343.84 _ - _ - -- --- - -- - __________ � 54,505 61 ' 72,604 41 I$ 18 098.80 $ (243 245.04 ', 2.24/2.46 Nov 11 29,551.0 $ 1.80024 ,$ 1,306.72 _._. __ �_ _ __. - �-- Dec 11 40,000.0 $ 1.78000 ! - ___L -- --_-• - - - --_ ,-$--- 1,216_23 -_ 71,200 00 �• _-_ 72,416 23 � �38,664.76 $ 45,536.00 $ (172,216.16> 2.24/2.46 Jan 12 � 52,000.0 $ 1.77000 $ 1,088.76 _ 92,040.00 93,128 76 ' � - -- ( ) 2.45/2.68 Feb-12 ' 43,000.0 �$ 1J6000 $ 861.08 , 75,680.00 � 76,541.08 �_ 114,665 09 ._$ 38 124.01 $ (134,092.15), 2.45l2.68 - __ _- _ _ ____ -- - - - --- _--- Mar 12 � 38,000.0 $ 1.78000 $_ 670.46 67,640.00 � __ 68,310_46 i_ _ 101,331.94 I$ 33 021 48 $ (101,070.67) 2.45/2.68 _ -- _ --- --- Apr 12 _: 34,000.0 $ 1 79000 $ 505.35 60,860.00� 61,365.35 90,665.42 �$ 29,300.07 $ (71,770.60) 2.45/2.68 y -- . - _ _ _ - -- - - _ _ . _- --, - - -- . . _ .- -- --- - -- - . _ - - � - -- - Ma -12 32,000.0 $ 1.79000 $ 358.85 57,280 00 57,638.85 85,332 16 ,$ 27 693 31 $ (44 077.29), 2.45/2.68 _ _ -- - -...- -- - - Jun-12 30,000.0 $ 1.79000 $ 220.39 53,700 00 53,920.39 79,998.90 $ 26,078.52 $ (17,998.78) 2.45/2.68 - - --- . _ _ _- -_ - --- _:- - - - - � - - - - -- -._ __ - Jul 12 28 000.0 $ 1 78000 $ 89.99 49,840 00 49,929 99 74,665 64 I$ 24 735 65 I$ 6,736.87 2.45/2.68 --- _ _ _ -- - - _ __ _ - ---- �• - - ---- -: ---- - - --- -•- -- --- - - , Au -12 _ 28 000.0 $ 1J8000 $ (33_68 '_ 49,840.00 49,806 32 ' 74,665.64 $ 24,859.33 $ 31,596.19 2.45/2.68 - - - - _ - - g - - --- --- -- --� . ____ _- . _ - P13 ---- � - - __- ---- - __ _ _ - -- � - - _ ._ ----- --4 ,_____ _- 76,382.82 �_ --- -�-$ -�76 382.82)`$ 56,859.82 � 2.45l2.68 Se -12-- __ 28 000.0 $ 1.77000 $_ (157.98)._ 49,560.00 49,402_02 74,665 64 ;$ 25 263.62 $-- (19 523.00) Total YTD _ 416,791.2 : $ _ __ __ _ _ _ __ _ 1.78197 I $ 6,349.90 $ 742,708.54 '� $ _ 1,063,441.63 � $ 1,088,664.69 ! $ 25,223.06 _--* -- -- _ _--- - - ------ � - �--�- ---- ___ _- & , FY 10l11 Write off PGA & WNA Fuel_ -- ---- --- -- - -- - _ . _...._ Donations to events 'LP Yard Vaporization/loss due ti LP PGA Event fuel cost meter -- - -- -- - ------ -- --- --- -- ,Suburban Software Systems _ _ _. . --- ---- - - - , _ __ _ .Depreciation of LP tanks_ _ -- __ . _ - - --- ---__. . __.___ Suburban Software Systems license _ _ _ . __ _ ------- � - -- - ------ ----- --- .. _ _ Contribution to garage LP trk up grade ___ _ ___ LP Holding Tank Restoration - --- - �- --- - � �-- - - - ------- � - -------- � - --- ----- � $ 188.462.27 1 ' _ . _--- _.._ ___ . - ------ __ ----�- -------- ---- �- _- -----�- $ - 1 --------- .-- --- , _. _- ._-_ _ -- -- ' - -- __ _--+--- ------ _� _ __- ----. ___ ----- -i-$ --- 15,000.00 � , , _. _ _ $ � r- - -- �, - - ' (4)'. Adjustment from FYE transfer of ECA m PGA @ 1/2 of the __$ __ _ 104 61 ' 1 _ -- -- -- - ECA Rate -_ �__ _ _ `$ 19 26 1___ '_ LP Proportion = 2.1 % x Total ECA Transfer = $ 8,383.20 - - _- -- ---------- ---- _ __ $ _ __ - 1 _ _ + Additional_Projected Costs Needed = � $ 67,999.62 _ ..___ _ � $ 34,414.23 _ 1 - -- _ _. ..___- ------ ------------ $ � . _ _ __ - - --- --_ _ __ .. _ .___._ _.__._-- .____ _ __ _ _�_ __ _ _ _ -- -. . _ _ _ _ _ _ _ $ - _ _ ' _ _ _ � . _ _- -- - -- - ---- --- - _ -:--- ---- ---- - -- $ - Proj. Ann. Costs Add'I. Proj. Costs _-- ._ _ _ __ - -- -- --- _ _ _ ._- --- -_ $ 238,000.38 $ 306,000.00 ' $ 67,999.62 I CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 2 of 4 � - - - _ _ _ - - __ __ _ _ ---__ _ _ - -,__ .__ _ __ _ _ _ _ ____ _ _ --- ------ _ - _ _ __ _ , ENERGY CONSERVATION ADJUSTMENT 1ECA) _ _ _ _ _ _ _ ---- _ _ ,_ - --- -._ _ ___ _ _ -- -_ _ , _ _ ._ _. _ __-- - ----- -_ - _ __ _ _ __ _. __,_ ____ ___ , Monthly , Cumulative ECA - ---- --- .- _ -- --- — --- __ � _ ---- -_ _ _ _ -- _ . _ __ - - ---------- -- _ Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NG/Therm - ---- � . .-- -- - _-- -- -- -- --- - - -- -- , -- Month , Expenses �Notes/Exceptional Items Expense CNG Station _ Expenses _ Billed (Shortage)__ (Shortage) LP/GaL _ - ----- - Prior Year --- - -- - -- -- , --- � -- _ - - _ - - _ $ _ , OCt 11 ,' $ 575,681.13 Promo$54,767,Adv$O,Em Io Costs569,e19 $ - $ 2,534.54 1 $ 578,215.67 ! $ 100,694.45 � $ (477521.22)� $ (477,521.22). 0.13/0.13 ' — — --- --- P Y_ � - -- - -- --- — - — --- - — -- + — - _ Nov-11 $ 89,882.26 !Promo$24,249,Adv $5,000, Employ Costs$61,073 $ 2,387.61 .$ r 439.25 92,709 12 ' 138,769.26 �$ 46,060.14 $ (431,461.08) 0.13/0.13 i --- --- -- - -- -- ---- -- ----- -- _ _- - -- Dec-11 $ 100,000.00 $ 2,157.31 '. 102,157 31 ' 135,732.95 r$ 33,575.64 �$ (397,885.43) 0.13(0.13 __ Jan 12 � $ 150 000.00 , - - - - - - — -- I $__ _ 1,989.43 ; � - - 151,989 43 ; --- 171,595.02 . $ _ 19,605.60 � $ (378,279.84). 0.13/0.13 Feb 12 ' $ 100000.00 - --- - -- -- $-_ 1,891.40 --- 101,891.40 .. 157,378.78' $ _ 55,487.38 $ (322,792.45)� 0.13/0.13 j _._ _ -- -- -- --- -- - -- - - Mar-12 '$ 100,000.00 $ 1,613.96 101,613 96 � 150,592.14 �$ 48,978.17 '$ (273,814.28); 0.13/0.13 � Apr-12 � � 100,000.00 . - -- - -- .. - $ _ 1,369.07 - - - - 101,369.07 - - --132,446.78 ': $ 31,077.71 $ (242,736.57) 0.13/0.13 _ _ - -_. _ - --- - - _. , _ - - --- ----------- May-12 $ 100 000.00 $ 1,213.68 101,213 68 ' 116,587.46 �$ 15,373.78 $ (227,362.79) 0.13J0.13 _ _ - __ _ - -_ _ _ _ - _ _ -- - -- --- - Jun-12 $ 100,000.00 $ 1,136.81 101,136 81 109,300 74 '$ 8,163.93 $ (219,198.86) 0.13/0.13 Jul-12 $ 100,000.00 $ 1,095.99 101,095 99 107,729.10 '� $ 6,633.10 �$ (212,565.75) 0.13/0.13 Aug-12 _ $ 100,000.00 . ___ - _ . $ - 1,062.83 - 101_062.83 - 107,729.10 $ __ 6,666.27 $ (205,899.48 ' 0.13/0.13 � Sep-12 $ 100 000.00 $ 1,029.50 101,029.50 107,729.10 $ 6,699.60 $ (199,199.88) 0.13/0.13 -- -- _ __ __ - - ----- ---- ---__ __ - . _ _ _ , _ P13 $ 200,000.00 Pay down oi NGV Station Costs 200,000.00 399,199.88 $ 199,199.88 $ - Total YTD $ 1,915,563.39 $ 16,947.59 $ 2,973J9 , $ 1,935,484.77 ' $ 1,935,484.77 $ - _- _--- -- - --- - — -- -- --- --- --- ' --- -- - - - ----- ----- - - - - ---- -- - - . _. _ _ (1)�Includes Annuai Admin Charge_of $46,450 +_CCS chg of $55,930 + Dividend $69 090 _ (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 = �$ 768,142.44 _ .. __:_ ._ ------ - ---- - - -- -__- ------ --- -- _ _. _ , _ _ + Add'I Dividend based on FY11 Net Profit $77,170.68 = �$ 451,095.15 � , --- ----- - _ __ _ ._ _ -------- ___ _. ------- -- -- ----- :_--- i -- --- _ - - - - -- - -- _- - - -- - _ - - -- _ _ _ - - - - - - --- -- - - -- .- - - - - __ _ _ __. Net CCE 1 284 389.62 _ _ _ _, _ . -- - ---- -- _ ----- -- - -_ -- -- -- -- _---- +- _ _--- __�__ _ _ _----- - - --_- _- __ _ _ . _ _ _ . - 1 -_ _ _. _ ._ __ __ __ _ _ . _ _ _- - - -_. _._ _ _ _ _ _ _ � � - - . __ -- - _ _ _ _ ___._ _ _ _ _ _ ___ _ _ -- - REGULATORY IMPOSITION ADJUSTMENT (RIA) _. _ (EIA) . _ __ _ _ _ _ _ _. (O�) _ _ _ . ___ _ _ . _ _.__ _ _ . _ _ � _ _ _ Budget Environmental Regulatory Interest Total RIA Total RIA Overage YTD Overage NG/Therm _ _ __- ___ ___ __- - -- ._ ---- - - - __ - Month Expenses Notes/Exceptional Items Expenses __ Expense _ _ Expenses . Billed , (Shortage) __ (Shortage) LPlGat. - - --- -- - - - Pnor Year , , _$ - $ (161 500J0) -- - - - _ _. __ - --- -- --- - - - Oct-11 $ 12,390.53 $ 807 50 � 1 $___ 13,198 03 _ 19,520.29 $ __6 322.26 $ 155 178.44) 0.02/0.02 --- -- - __ - --- - - - � - - - __ - Nov-11 $. r1,324.00 $__ 775.89 2,099.89 21,322.53�$ 19 222.64 $ (135,955.81), 0.02/0.02 _ ___--- -_.-- Dec 11 -- $ 10,000.00. .. _- .. - $ 679J8� _ 10,679.78 . 22,505.30 ; $ 11 825.52 � $ (124,130.29) _ 0.02/0.02 -- -- --- - - -- -- - _-- --- - , Jan-12 ' $ 10,000.00' < $ _ 620 65 !___ _.___ 10,620 65 ; 28,451_43 ' $ _ 17 830 78 $ (106,299.50) 0.02/OA2 - - - - -- — - Feb-12 $ 1_0,000.00 - , - $ 531.50 .__ _ _ 10,531 50 _ 26,094.30 ; $ 15 562 80 $ (90,736.70) 0.02/0.02 - - --- -- --- --- - -- -- --- --- -- Mar-12 ;$ 10,00q.00. _ $ 453.68 '.___ . _ -_10,453.68 ',, _- . _24,969 04 ! $ 14 515.35 $ _ (76,221.35), _ 0.02/0.02 -- -- - _--- --- � - . : .----- .- ._--- ___ . _- --� - -- - -- -- _ _-- - - — __Apr 12_ $ 10,OOOAO.` ; $_ 381 11 ' 10,381.11 , 21,960.43 , $ 11,579.33 $ (64,642.03)'. 0.02/0.02 -May-12 $ . 10,000.00: _ __ _-- --- _ _ ° , $_ _ .__323 21- _- _ -- 10,323 21 -_ -_- 19,330 87 ': $ __ _ 9 007.66 $ (55,634.37), 0.02/0.02 Jun-12 '$ 10,000:00 . _ _ $_ 278.17 __ _ 10,278_17-,_- .. -18,122_69_'� $ 7 844.52' $ (47,789.85)' 0.02/0.02 -- - Jul 12 $ 10,000.00 - - $ 238 95 10,238.95 17,862.10 $ -- 7,623.15 �$ .(40,166.70) 0.02/0.02 _ _ - - --- --- � - --- -- Aug 12_ $ 10,000.00 ;- $_ 200 83 � 10,200.83 17,862.10 ;$ 7 661.27 �$ (32,505.44), 0.02/0.02 _�. -- -- -- _- Sep-12_`$ 10,000.00 . ' $ 162.53:__ ___ 10,16253._ 17,86210 � $ 7699.57 � $ (24,805.87) 0.02/0.02 _ _ __ - --__ _ _.- . __ _ _- P13 __ _ _ _ $ - _ - - $ -- _ $ 24,805.87 ; . _ _ _ . $ _ -_-_ _._ _ _ _-- --- .:_ $ - $ (24,805.87) _ __ - - -- ----- --- ____ _ _. . Total YTD $ 113,714.53 $- - $ 5,453.81 : 119,168.34 255,863.17 '$ 136,694.83 . _ _ _ _ __ _. _. _._ - _ ,_ . _ _ - _ _ _- - _: _ _ ___ _ _ _ _ (1) includes annual charges for Admin Charge $10,450 FY 10/11 Write off of $616.53 _ _ __ __ . ___ __ . __ __ _ - __ _ _ __ _ . _ CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 3 of 4 � USAGE AND INFLATION ADJUSTMENT NIA) ' __ _ --- - _ __ __ -- -- -- - --- -- -- -- - -. _ - __ - -- -- Commercial I _. _ ,_ Monthiy __ t Cumulative UTA -- -- --- --- �---- - -_ :_ ___- _ --- - --- - --- -- _ _ - - Budget, __ i Interest : , Overage YTD Overage NG/Therm - -- --- .--- - , - - Month LP Gallons Expense Rate/Gallon � a NG Therms Rate/Therm �_(Shortage) _� _(Shortage) LP/Gal - � _- - __- ----- - - - --- �- --- . Beg BaL ; __ ' $ - $ (644,952.53), - - -- -- - - - _ _ _ --- ---� ---- -_ - - -- - - - --- }_ _ _ � ---f - - 0.05/0.05 Oct-11 ' 5,770 0;$ 3,224 76 0 05 748,591.5 0.05 $ 37 689.96 $ (607,262.57) Dec_11 ; _- _ J . __-_ _--- 8,000 0 ' $__ 2,829 88 i _ -0 08 'Y _ 950,000 0�---- 0.08 '-$ .76 640.00 $ . (489,335.81jI 0.05/0.05 __ � 0.08/0.08 _ Feb 12 _ _ _ -_ ----- -_ _ - 8,500.0 � $ - - 2,022.88 - _ _ _ 0.08 . _ `- - 950,000.0 ' - -_ --- 0.08 'w- ---- ---� --- - -- 0.08/0.08 Jan 12 __ __ _ - . -.. . . 9,500.0 $ 2,446.68 . . . 0.08 1 050,000 0 . 0 08 $ 84 760.00 $ (404 575.81). - 0.08/0.08 - - _. __ _ $ 76,680.00 $ (327,895.81) Mar-12 7,500.0 $ 1,639.48 0.08 950,OOOA ' 0.08 '$ 76,600.00 '$ (251,295.81) 0.08/0.08 - -_ _ Apr 12__ -- -.. 7,000 0$ 1 256.48 0.08 . 925,000 0._ 0.08 �$ 74,560.00 �$ (176,735.81) 0.08/0.08 _Ma -12 . . - - _. _ 6,500.0 $ _ 883.68 ___ __ 0.08 ' . . 725,OOOA -. 0.08 $ 58,520.00 � $ (118,215.81) . 0.08/0.08 Y_ , _ Jun-12 _ _ _ 6,500 0 ' $ 591.08 . _ 0.08 700,000.0 0.08 !, $ 56,520.00 ! $ (61,695.81) 0.08/0.08 --- Jul-12 5,500 0;$___ 308.48 0.08 '� 650,OOOA 0.08 :$ 52,440.00 $ (9,255.81); 0.08/0.08 - ---- _ _ __ -- Aug 12 _ 5,500 0$ 46 28 0.08 � 650,000 0 0.08 `$ __ 52,440.00 $ 43,184.19 0.08/0.08 _ Sep-12 - - - - - - _ - - .- -- 5,500 0 ; $ ----- - - - 0 08 ', - --- 65Q000 0 - 0.08 $ 52,440.00 ' $ 95,624.19 0.08/0.08 -__ -- --- - ___ Per 13 ---__ , -- ,-- Total YTD- _-_- --- -- - - -- 81,665.2 � 18,285.99 _ __ ,_ . ___ _9,766,620.4i_- $ 740,576.72 - ... - - - ,_ - - - -- -- USAGE AND INFLATION ADJUSTMENT (UTA) ' ` - -- -- - -- - -- _ . ---- - _ � Residential . - -- - - ', ' Monthly _ . Cumulative UTA --- - __ - - -- - - -- _ _ - -- -- _- -- - -- - __ _ Budget _ _ _- -__-- - . _ _. . ._ .---- - . _ Interest ' . _ Overage__- YTD Overage NG/Therm - -- --- -- - --- •-- - - _ _ _ --.- . _ Month LP Gallons Expense , Rate/Gallon NG Therms Rate/Therm (Shortage) __ (Shortage) LP/Gal _ - _ _ _ -____ ___-- -._ _. _._ ) Beg. BaL_. _ � ___ _ _ _._ _ $ - $ (180,801.96 _ __ _- - -- - -__ -- - -- ___ _ _ _ _ Oct-11 28,470.2 $ 904.01 0 02 194,083.1 0.02 �$ 4,445.18 $ (176,356.78) 0.02/0.02 . Nov 11 23,628 7 $ - - 881 78 � OA2 _ _ 219,872.8 . - 0.02 . $ q,872.59 $ (171,484.19) 0.02/0.02 __ -- - - - - --_ - - - . -._ _ --- - -- _ -- - - -- --- - Dec-11 35 000 0$ 857.42 0 06 400,000 0 0 06, $ 26,089.60 $ (145 394.59) 0.06/0.06 Jan 12 40,OOOA '$ 726.97 0.06 600,000.0 0.06' $ 38 384J0 �$ (107,736.86), 0.06/0.06 Feb 12 � . . 30,000 0 $ - 538.68 . . - 0 06 '� . 450,000 0 -- . 0.06. $ - 28,788.53 $ (79,487.01) 0.06/0.06 -_ - - . --- -. - -_ -----� --- _ ._ -- T_ _ _--- _ _ -- ;_-_ _ �- . _ _ 0.06/0.06 - Mar-12 30,000 0$ 397 44 0.06 350,000 0 0.06 $ _ 22,790.92 $ (57 093.53),_ Apr_12- __-____--. --- - - -.- __ _ _ 25,OOOA $ 28547�___- __ 006 _. -- 300,000.0__ 0.06 $ 1949223 $ (37,886.77) 0.06/0.06 -- -- -� ----- - Ma -12_ _--_-- - __-- 20,000 0 ; $___--- 189.43� - - . - 0.06_4_ 225,000.0 ; _ 0.06! $ 14 694.14 � $ (23 382A6) 0.06/0.06 JuI 12 -- ---_ 20,0000 $_-- _ 51 52 --_- _--- 0.06 4- 175,0000 ;- --- - 006 -- - . !_ - _ _ -�- _ -� $ 13,194.74 $ (10304.23)� 0.06/0.06 _ _.-- -'- -- -- -- � 11 695.34 1$ - 1 339_59 0.06/0.06 - --- _ ----- -�-- --- - _ �._---- -1--- --- � Aun 12 _ 20,000.0 !$ 1(6 70) 0.06 �; 17�5,000 0� 0 06� _--g- _----------__ ' $ _11,695.34 $ 13,041.63 0.06/0.06 _ Sep-12__ _ _ 20,000.0 $_ (65 21) _ __ 0.06�___ _ 175,000.0 % 0.06! $ _ _ 11 695.34 $ 24 802.18 0.06/0.06 ___------ --_____ ___.__-- --- ------ _ Per 13 -- -- , - - ----- ----- __._ . _- __ . _ . _ -_. _ _ _ ___ ' - - =--- ----- -_ _.-_ $ Totai YTD 312,098 9 ; _--_- 4,877.73 --___- _ _•-_- ___ _3,463,955.9 $ 207,838.66 , . . CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 4 of 4 � I - - � --- -- - ----- �--- -- --_— - -- -- _ . _ _- TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES Both PGAs + ECA + RIA+UTA) _ _______- --_ _ --- --- , -- --- -- --- - - - -_ -- _ _ _ _ Monthly Cumulative Total Resl - --- _ _ _. _ --- -- -- - -- --- --- -_ ____ - -- -- � _ Budget _ - - -- . . . _ . - _ _ . - Total All _ . __Total Recovery_, _ Overa e ---- YTD Overage NG/Thm (Firm) _ __ _ _ __ 9 - - --- -- _ . _ Month Expenses _ _Billed _ . _(Shortage)_ _ ' (Shortage) LP/Gal (Resl) Prior Year _ _ __ _ __ _ __ _._ _ _ _ _ ._ _ __ --- . $ $ --(1,050,453.68). . Oct-11 . . _ _ - . . . $ 6 405 065 10 ' $ 1 499,068 64 . $ (4,905 996.46)' $ (5,956,450.14) 0.97/2.39 . Nov-11 . _ _ . . - . . _1,215,565.30 $ 1,682,088.56 � $ 466,523.26' $ (5,489,926.87) 1.02/2.39 Dec-11 _ _ _ ___ ___ _- -- ___ ___-- --_ __ __. _ ___. 1,439,962.33 -$--1,911,727.59� $ - 471,765.25 �_$-(5,018,161.62) 1.06/2.43 - Jan-12 � __ _ _ _-- _ _--- _ _ _ __ . _.____ . .._ __ ___ _ _.__ _---- 1,587,130.81 $ 2,423,790.86 I $ 836,660.05 ! $ i4,181,501.57) 1.06/2.65 - __ �--- --- �- - -' - - ----- ~--- -- -- Feb 12 ' 1,446,575 27 $ 2,208,917.11 'Y$ 760,341.84 �$ (3,421 159.73) 1.06/2.65 Mar 12 1,404,723.45 $ 2,104,456.51 '; $ 699 733_06 �$ (2,721,426.67) 1.06/2.65 - - _ _ __ _. - — ---- - -_ . _._ . .__ - ._ . _ _- -- - -- - - - - ---- ------ - - - _Apr-12_: _ __ __ _ __.___ --__ . ___ _ _- _ _._ __.____ __--------�-- ------ ---,- '-----1,234,436.59 $ 1,858,580.86 : $ 624144.28 .$ (2,097,282.39) 1.06/2.65 --- - -- - - � r-- - May-12-'- __ _ _ . _ _ . ___--- --- --- ------ -- -- .------ ---- ;---__ -- ---- _:__ !-_._1 132,729 58 ! $_ 1 630,250.12 ' $ 497 520.54 $ (1,599 761.86) 1.06/2.65 Jun-12 _ - °-- -- -- i_- - --- - ._ __ 1 086,657 56_ - -- -- --- � _ _ _ _ __ _ �; $ _ 1,529,435.97 ' $ __ 442 778.41 $ (1,156 983.45) 1.06/2.65 __Jul-12 _ _ _ _ _ _ __--- -_ ____ { ___ ___ ____ _ 1,080,58072''; $_ 1,499,993.76' $ 419413.04 � $_ (737570.41) 1.06/2.65 . Aug-12_.._ __. __. __ _ . _ _ _...---____ ____ _ _ -- _ __ ! __ --- ,___- -- . .---____ _______1,078,482.11 $ 1,499�993 76 ; $ 421 511.65 $ -_(316,058_76) 1.06/2.65 -- --�--- ----- ----__ _ _ _ __Sep-�z-: _-_ ____. _ _ _ _ -- --.---- ---- _ ____ _.-- _---- _._ _� -- -:_-------1,076,310 24; $ 1,499,993.76 ' $ 423,683.52 $ 107,624.76 1.06/2.65 - __ _______ __._ __. - -- . . ---- — -- -+----- -- ---�-------- --. _ Per 13 667,199.51 ;$ 399,199.88 i$ (267,999.62)! $ (160,374.86) Total YTD' _ __ _ __ _ , _ ___ __ ___ _ _. __. _ --___ __--------- - ---- .----__ _;_ _ -- 20,855,418.57 21,745,497.38 ' $ 890,078.82 : _ _ _ _ _ -- _ -- _ - _ _ . _ __ _ _ _ __ __ _--- - � -_ Last Updated 12/22/2011 oct-11 Nov-71 Dec-11 Jan-12 Feb-72 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Tolal Oct•1 Nov-1 Dec-1 Jan-1 Feb-1 Mar-t Apr-1 May-1 Jun-1 Jul-1 Aug-t Sep-t Total $1,240,076.42 $409,827.38 /4 u 1'�f�i'YlLti1%' �'2. CGS Naturai Gas Cost Actual/Projections FY12 asor iznsizoi� 2,641,833 570,393 266,100 1,077,271 (423,340) ($153,895.68) 2,134,955 158,002 2,089,000 100.00 % 102.6% $5.59 $10,351.29 $33,006.87 $1,992.81 $10,565,887.28 $ (135,661.44) $300,205.52 $126,440.00 63.5% 70.1°h $11,936,295.70 Totai Projected DTH WACOG Total Reservation Total Commodit Cost Purchased 1st6 Months $ 1,034,904.45 $ 5,925,096.58 $6,786,154.37 1,221,355 $5.556 2nd 6 Months $ 625 350.63 $ 4 640.790J0 a5 150,141.33 9t3 600 $5.637 TOTAL $1,660,255.08 $ 10,565,887.28 $11,936,295.70 2,134,955 $5.59 �l�ulm�� �3 Propane Weighted Average Cost of Gas (WACOG) �� 12/19/2011 FY 2011-12 .._--- -�- Invoice Gallons Propane Propane Shipping Total FYTD Cost of Tank Tank WqCOG Date Com an Sea-3 L&L Shi in Delivered Rate Cost Cost Cost Gallons Invento Invento Withdrawl �09130/10 >. YearEndTotais °.-< S 38,291.86 21,259 1.80121 10/03/11 Tar a 11044187 8,799 1.84064 $ 14,672.34 $ 1,523.48 $ 16,195.82 8,799.0 $ 54,487.66 30,056 1.81275 10/03/11 iTar a 11043981 8,999 1.64064 $ 15,005.84 $ 1,558.11 $ 16,563.95 17,798.0 $ 71,051.63 39,057 1.819181 j10/06/11 �Tar a 11044632 I 9,899 , 1.77997 $ 15,912.65 $ 1,707.32 $ 17,619.97 27,697.0 $ 88,671.60 48,956 1.81125 10/23/11 Tar a 11048067 ' 9,999 1.78335 $ 16,123.39 $ 1,708.32 $ 17,831.71 37,696.0 $ 106,503.31 58,955 1.80652 10/31/10 MONTHLY INVENTORY ADJUSTMENT 85 2.09176 $ 177.80 $ - $ 177.80 $ 106,681.11 59,040 i 1.80693 10/31/10 END OF MONTH S 41,870.17 23,172 � 35,868 1.80693 11/01/11 Tar a 11049494 9,200 1.76564 $ 14,651.00 �$ 1,592.90 I$ 16,243.90 9,200.0 I$ 58,114.07 32,372 1.79520 11/03l11 Tar a 11049839 17,399 1.74317 $ 27,316.93 $ 3,012.50 $ 30,329.43 26,599.0 $ 88,443.50 49,771 1.77701 !11/05{11 Tar a 11050340 17,400 1.73814 $ 27,231.00 $ 3,012.67 $ 30,243.67 43,999.0 $ 118,687.17 i 67,171 1.76694 11/30/11 'MONTHLYINVENTORYADJUSTMENT 1,653 3.15339 $ 5,202.99 $ 9.56 $ 5,212.55 $ 123,899.72 � 68,824 1.80024 11/30/11 END OF MONTH - S 60,606.88 33,666 35,158 1.80024 i FYTD Totals 81,695 1.77524 130,913 S 14,124.86 S 145 028.45 Delivered Delivered Month CGS Cost Gallons Projections Delivered Cost Total EOM Tank EOM Tank Cost of Inventorv Gallons Gallons Cost Now11 Dec-11 $ 1.75 45,000 $ 78,750.00 ~$ 202,649.72 1�13,824 Jan-12 $ 1.75 40,000 $ 70,000.00 $ 192,532.72 108,824 Feb-12 $ 1.75 50,000 $ 87,500.00 $ 209,264.24 118,824 _ Mar-12 $ 1.80 50,000 $ 90,000.00 $ 211,207.86 118,824 Apr-12 $ 1.80 40,000 $ 72,000.00 $ 194,333.61 108,824 _ _ _ May-12 $ 1.80 30,000 $ 54,000.00 $ 176,903.19 98,824 Jun-12 $ 1.80 20,000 $ 36,000.00 $ 159,200.69 88,824 Jul-12 $ 1.75 20,000 $ 35,000.00 $ 158,354.37 88,824 Aug-12 $ 1.75 20,000 $ 35,000.00 $ 157,698.61 88,824 Sep-12 $ 1.75 30,000 $ 52,500.00 $ 174,690.50 98,824 68,824 $123,899.72 68,824 $122,532.72 68,824 $121,764.24 68,824 $121,207.86 68,824 $122,333.61 68,824 $122,903.19 68,824 $123,200.69 68,824 $123,354.37 68,824 $122,698.61 68,824 $122,190.50 68,824 ' $121,659.71 Projected W� 1.80 1.78 1.77 1.76 1.78 1.79 1.79 1.79 1.78 1.78 1.77 CSW:12/23/2011 CLEARWATER GAS SYSTEM Attachment #4 NATURAL GAS RATE BILLING FACTORS FOR DECEMBER 1, 2011 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Puel Enerav CharnelTherm 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 of with 6.0% Franchise Change from 1l2006 Therm Rate % Change from t/2006 Therm Rate Utilitv Tax Note: Fuel Rate per Therm 10/Ot/1973 Non-Utility Taxable Fuel/Therm Firm Natural Gas Rate Schedules RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SLw/M& NGV (Closed 1/09) Reliaht (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.02 0.02 0.02 0.02 0.02 0.02 0.02 NA NA NA NA NA NA 0.06 0.06 0.06 0.06 0.08 0.08 0.08 NA NA NA NA NA NA $0.69 $0.69 $0.69 $0.69 $0.69 $0.63 $0.57 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.79 1.56 1.56 1.56 1.56 1.56 1.50 1.44 1.07 1.02 0.97 1.07 1.22 0.79 + 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) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($760.00) ($18.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) @ premise @ premise @ premise + FAC + FAC + FAC $ 1.43 $ 1.43 $ 1.43 $ 1.43 $ 1.43 $ 1.37 $ 1.32 $ 0.98 $ 0.93 $ 0.89 $ 0.98 $ 1.12 $ $ 1.51 $ 1.51 $ 1.51 $ 1.51 $ 1.51 $ 1.45 $ 1.40 $ 7.04 $ 0.99 $ 0.94 $ 1.04 $ 1.18 $ $ (0.70) $ (0.70) $ (0.70) $ (0.70) $ (0.59) $ (0.59) $ (0.59) $ (0.81) $ (0.81) $ (0.81) $ (0.81) $ (0.76) $ -31.0% -31.0% -31.0% -31.0% -27.4% -28.2% -29.1% -43.1% -44.3% -45.5% -43.1% -38.4% $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.801 $0.801 $0.801 50.801 $0.801 $0.801 $0.801 $0.801 $0.801 $0.801 $0.801 $0.801 Interr. NG Rate NSS IS (Non•Resl) NA 100,000 & up $50.00 $250.00 ($75.00) $400.00 Contract NG Rate CNS NA By Contract (By Contrect) $0.46 $0.28 By Contract NA NA NA NA NA NA NA NA NA $0.46 $0.28 By Contract 0.87 0.79 0.79 1.33 1.07 0.79 + Non-Fuel $50.00 $250.00 Customer ($75.00) $400.00 Charge + + FqC + Non-Fuei Therm Non-Fuei Therm Rate for Contract Rate for Contract # of Therms # of Therms 0.72 $ 1.22 $ 0.98 0.77 $ 1.29 $ 1.04 (0.99) $ (0.82) $ (0.67) -55.6% -38.1% -36.5% $0.069 $0.069 $0.055 $0.721 $0.801 $0.735 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) 10/2011 11/2011 12/2011 01/2012 02/2012 03/2012 04/2012 05/2012 06/2012 07/2012 08/2012 09/2012 FY 11/12 Averaae Firm Service Rates 1.035 1.036 1.036 1.036 1.036 Interruptible Service Rates 1.015 1.016 1.016 1.016 1.016 $ (0.67) -45.9% $0.069 $0.721 CSW:12/23/2011 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 JANUARY 1, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMI�Y LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP (Non-Resl.Only) (Non-Resl.Oniy) 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 Enerctv Charqes/Gailon: 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.02 0.02 0.02 0.02 0.02 NA NA NA Usage & Inflation Adj. (UTA)/Gallon 0.06 0.06 0.06 0.08 0.08 NA NA NA Total Non-Fuel Charges (NF)IGaI. $2.11 $2.11 $1.11 $0.53 $0.48 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal 2.68 2.68 2.68 2.68 2.68 Set Bv Contract 2.68 2.38 Total Energy Charges/Gallon $4.79 $4.79 $3.79 $3.21 $3.16 Contract NFE $3.68 Contract NFE + + Contract PGA �2.380 Customer Charge Customer Charge + Minimum Monthly Bili $10.00 $25.00 $10.00 $25.00 $40.00 Any Applicable $50.00 Non-Fuel Energy Chg. UtiliN Tax Note: Fuel Rate per Gallon 10/01/1973 0.161 Non-Utility Taxable Fuel/Gallon 52.519 Change from 8/2008 Gallon Rate $ 0.65 % Change from 8/2008 Gallon Rate 15.7% 0.161 $2.519 $ 0.65 15.7% 0.161 $2.519 $ 0.45 13.5% 0.161 $2.519 $ 0.47 17.2% 0.161 $2.519 $ 0.47 17.5% Customer Charge + Any Applicabie Facility Charges 0.161 0.161 Contract PGA - 0.161 $2.519 NA $ 0.75 NA 25.6% for the Contracted # of Galions/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:12/23/2011 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 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 Gallon Range 0- 60 60.1 - 120 120.1 - 300 > 300 or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annual Customer Charge $ 210.00 $ 180.00 $ 90.00 $ 75.00 Non-Fuel Charpes (NF)/Gallon: Non-Fuel Energy Charge (NFE)/Gai. $ 1.80 $ 1.60 $ 1.00 $ 0.90 Energy Conservation Adj. (ECA)/Gal. $ 0.13 $ 0.13 0.13 0.13 Regulatory imposition Adj. (RIA)/Gal. $ 0.02 $ 0.02 0.02 0.02 Usage & I�flation Adj. (UTA)/Gallon 0.06 0.06 0.06 0.06 Totai Non•Fuel Charges (NF)IGaI. S 2.01 S 1.81 $ 1.21 S 1.11 Purchased Gas Adj. (PGA)/Galion $ 2.66 $ 2.68 $ 2.68 $ 2.68 Total Energy Charges/Gallon S 4.69 S 4.49 S 3.89 S 3.79 Note: No Monthiy Minimum Bill Utilitv Tax Note: Attachment #5 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR JANUARY 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 0.02 0.02 0.06 0.06 S 1.81 S 1.11 $ 2.68 $ 2.68 S 4.49 S 3.79 COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) BCLP1 BCLP2 0 - 2,500 > 2,500 Customers in this Customers in this Range of Usage Range of Usage $ 90.00 $ 90.00 $ 0.25 $ 0.20 0.13 0.13 0.02 0.02 0.08 0.08 S 0.48 � 0.43 $ 2.68 $ 2.68 5 3.16 S 3.11 BULK STANDBY/ GENERATOR LPSB (Closedfor New Residental Applications) $ 420.00 $ 1.00 NA NA NA E 1.00 $ 2.68 E 3.68 Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ Non-Utility Taxable FuellGallon $ 2.519 $ 2.519 $ 2.519 $ 2.519 $ 2.519 $ 2.519 $ 2.519 $ 2.519 $ Change from 8/2008 Gallon Rate $ 0.650 $ 0.650 $ 0.45 $ 0.45 $ 0.65 $ 0.45 $ 0.42 $ 0.42 $ % Change from 8/2008 Gailon Rate 16.1% 16.9% 13.1°/ 13.5°/a 16.9°/a 13.5% 15.3% 15.6% CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract Set By Contract NA NA NA Set By Contract 2.38 Cotract NFE + 2.380 0.161 $ 0.161 2.519 Contract PGA - 0.161 0.75 NA 25.6% NA • csw:tzrza2oii ; ; . .:. . .l . I .. . i ' .I _ . � . _.. i AttachmeM#6 __ _ ._... . . . . i . . i . .. .. . ._. . , � . . . ... 1 .. . I � i i � j Page 1 of 3 . .. .. i ...- -- -' __ _. ._.... ._ _.__.. ... ... ._.... ._.__. _..... . _ . ..._ . . ._--- �----_. Residential Rate History By Components __ __ __ _ _ _ __ _ _ _ - _ _ Clearwater Gas System .._ . _ _ _ , _ __ _ , � � � � � Total �Rate � � i � , � Adiustments/Thertn � Contract LP . . I 1-� _ ... I _.. i .... OE 40 f � IA/RIA# I $ NA/UTA Resl# � $A-Comll# ± �C _ : P ,�A { PC�A/aallon_ Month NGttherm LP/aallon' � � J� � P A I . _ . _Y. .. _. __ I __ _. - Od-08� $_ 1 990 $ 3 300 I i� $ $ 1 270 $ 1.190 $ 2 260 _ � Jan-09 $ � 1750. i, $ 2 290 .. ' . $ 0.140 i $ . __ � $ i $ _ 1 $ 1 270 � $ 1.190 �$ 2 260 _. Nov-0 i '--- � -- _ __ _ Feb-09 $ 1 J50 I$ 2 290 I $ 0.140 I$ - 1 S __ '__ 1$ -. I$ 1 220 $ 1.140 $ 1 730 Dec-081 $ 1.940 � $ 2 770' _. _ J # t } �$ 0.090 T 5 - $ -_ � S - $ 1 1 ao $ 1.100 $ � 1 200 j - - - + - -- L - -- $ 0.090 t $ __- f $ --- -'-$ --- � $ 1 180�$ 1.100 $ 1 200 � Mar 09� $ 1.580 J$ 2270 � ---� $ 0.070 i 5 - I g - I$ - �$ 1 030 i$ 0.9�$ 1200 Apf-091 $ 1 410 1 $ 2.200 f -_ . � -- $ 0.040 i $ - $ _.t $ $ 0 890' $ 0 810 � $ .. May-09 � $ 1.410 i $ 2.200 _� ._. � _.. .. . � $ 0.040 t $_ . t $ . .. .. � $ � _� f $ 0.890 � $ 0 810 t $ - - -- - -�- - - ... _ __. _. ._ _. . . Jul-09 $ 1.350 i $ 2 330 � � .. . { .. .. $ 0.040 � $ .. - $ - __.! $ . -_ i $ 0 890 � $ 0 810�$ - - �-- - - ---- -- . .. Seo-09 $ 1 390 I�� $ 2.650 I - � � � _ 1 $ 0.040 ; $ . .- � $ - $ - $ 0 830 T $ 0 750 $ .. � - i - i s a.-oao $ � s -.$ - 1$ o s3o s o�so f s - - , - a - _ 1 � s o.o�o � s o.oio i s - 1 s - i s o sso } s o.iso � s Oct-09 $� 1390 I $ 2670 Nov-09 $ 1 390 �_$ 2 670 Dec-09 $ 1 390 f$ 2 750 Jan-10 $� 1 390 �$ 2 750 Feb 10j $ 1.480 1$ 2.810 . Mar-10 $ 1.520� $ 2880 Apr-10 $ 1.520 �$ 2 680_ May-10 $ 1.490 I � $ 2.850 _ Jun-10 $ 1 460 i.$ 2950_ Jul-10 $ 1.430 I S 2 990 Aug-10 $ 1.390 �$ 3 090 _ � _ . __ � ._._ .. . $ 0070; $ 0.010 I $ - I $ -. $ 0070:$ 0.010�$ � - � $ - - I$0.070.$ 0.010�$ - I$ - ___ ". i _. . g 0070 � $ 0.010� $ __ ._� $ �. --- --. 1 .... _ _. } ..... t$0.1101$ 0.010 $ -...�$ - ---I { �$0..110 $ 0.010 $ � - _.T$ ' $ 0.110 $ 0.010 $ .... _- i $ - � } � $ 0.090 � $ 0.030 $ - i $ - .. _. � .. t . . $ 0.090 I $ 0.030 $ � - _ r $ - __.� .. .. _ . _. �$ 0.090i$ 0.030i$ - i$ - � i$ 0.090i$ 0.030i$ - __�$ - -- -- - . - ... _ ._. i i a n nan i¢ n nan 1 a . � R _ 1,160 1.160 � $ 0 830 I$ 0 750 $ 1 590 $ 0 830 �$ 0 750 $ 1 590 $ 0 830 �$ 0 750 $ 1 670 $ 0.6301 $ 0750 $ � 1 670 $ 0 880 �$ 0 800 r$ 1 690 $ 0 920 1$ 0.840 I$ 1 760 $ 0 920 1$ 0.840 �$ _ 1 760 $ 0.860 I S _ 0780 F$ 1.830 $ 0.830 'i $ � 0750 I $ . .. . 1.870 0.790 I$ 0.710 I$ 1.970 � � I � j � I _ { � I I _ ._ _ - - - oa-io $ i.a� i s s.o2 l 1 ; s o.�o s o02 s_ - $ - � s oe� � s o.�s s i so I , - - .. Nov-10i $ 1 47J $ 3 02 � { ... $ 0.10 $ 0 02 $ ... $ - $ 0 87 $ 0 79 $ ..... 1 90 7$ 1 47 I.�$ 302., . .. I j$ 0.10 �$ 0.02 $ ... �$ -� $ 087Y $ 0.79� $ 1 90 - - � -- - ..�� Mar11�1 $ 1.54 $ 333� _ ... i .$ 0.10,$ 0.02 $ 0.021$ 0.03�$ 092�$ 084 $ ... 2.19 Feb-11j $ 1 55 S 3 37 I I a$ 0.13 j$ 0.03 $ 0 02 I$ 0.05l $ 0 89 j$ 0.81 t$ 2.19 I$ 155i�$ 337..4 �� $ 0.13i$ 0.03 $ 0.02Ir$ 0.05I$ 0891$ 081 $ 219 ...Apr-11�$ 1.46�$ 328 .-. .... �. ... '$ 0.10�$ 004 $ 0.02I$ O.OSj$ 0.82�$ 0.74�$ � 212 ... May-11 �$ 1 45 !$ 3 35.1 ... f �$ 0.12 i$ 0.02 i$ �... 0.02 $ 0.05 1$ 0.81 �$ 0 73 �$ . 2.19 Jul-11 $ 1.45 $ 3.35 � � � $ 0.12 $ 0.02 $ 0.02 $ 0.05 �$ 0.81 I$ 0.73 i$ 2.19 Jun-11 i $ 1 45 'I $ 3 35-� �--. � . .�. . . . • $ �0.12 � $ . 0 02 i $ . . . 0 02 $ 0.05 S 0.81 � $ 073 $ 2.19 1 1 � - - . Aug-11 �$_ 1 42.. i. $ 3 46._ I .-.. i I � S 0.12 i$ 0 02 I$ 0 02 $ 0.05 i$ 0 78 I$ 070 $ 2 30 .....-Seo-11 5 1.42 '� S 3.461 .... I ..... i. . f$ -o.iz 1$ o.oz � s...... 0.02 s o.os I s o.�a I s o:�o s�-- -- 2.-30 Oct-11 I $ 1 47 �1. g 3.67 �• . . . , --. i . . I $ �.0.13 $ 0 02 i $ . . . 0 02 � $ 0.05 j $ 0.82 $ 074 � $ ...._ 2.46 ` -- - ' I . ..� . _ .... �$ 0.13i$ ..002I$ 006��$ _0.08�5 087I$ 0.79f $ 2.46 { _ I$ 0.13�$ 002 $ 002 $ O.O5i$ 087 __ ._. ....,._ .. . ._. . _ .. . _- .. g 0:79�$ 2.46 �$ .0.13�$ 002 $ 006�$ 0.08I$ 0.87�$ 0791$ �-- 2.68 3 63 1 I ov-1 _ $ 3 89 � � i ... �Jan-12I 5. 1 56. �I, _ . , __. I ._ .. I . � .. � .. _... _.. � _. J . .._ .. j _._ _.. -- Apr-12 _ { . I t - __ .... l. . i . . _. __ --- Mar-121 . � � _ � 1 - . } . _ � _ Feb-121 ' i II . I __ i _ _ . i May12�__ � ..L ..-- i ___. . i � ... . . .._ . _._. � . _ ._.; . . ___ .... . . . , . _._ ._. Jun 12 � i � I � -- -- -_ _ � - Jul 12f __ . � f � i r � _ - _ ___ i , i - : . ♦ ' _. __ a f AuB-�2J _ _ � .. . . .. . .. . .. i ? i .._ Sep-121 . _�.. ... . . I - - , � ; . . i . {. .. .. . i � � . . I ._. ___ =V 11H2 Ava. � S 1.528 I S 3.705 I I �, I S 0.130 i S 0.020 I E 0.040 I E 0.065 I S 0.858 I S 0.778 ! S 2.515 Incc Above i S 0.02 I S 0.56 . _. ... . . . $ � 0.03 . ... . . , . .... ._ � . . . . . i . , . � i i 1 ... _.� ---$ __ . . � . . _ .. . . .. � � n% � ; so%' S i E o.oa � S o.os, S lo.os�f 5 fo.os►; E _ o.ae � i , _ i � ' � . * �e��' -s�i -s�j _ zz� .j _ � . _ _ _ _ � � Incr. Based S 0.40 �:. .. _+ - �. � . . ., i 0% 200 k I . , ... . . . Same Month 1 k _ � _- � - �� ' � -�- i - -- .. . i -- f... _ . . . .. � � . _ IS 12.24� I I ' .. 18%r .... i I i .. L -. . _. _. on 20 Thertns � . ' �! 14.5 --_ ._. .. _ i ..__ T . _ .__ i ... _ i . . ... ._. _ t _. __ ... _ . . ♦ .. . . _ . I . . .. . � .. . . . _ _ _ j � T • � J 1 . _ . _ � Cents/'KWH I 5.31 _ . � . � _ : ; , for Gas I � � i i i � � . . __ _ . � . _. � _ _._ . _ �� � I g Ener ys residential rate for usa e>1,000 KWH in Dea 2011, but we understand d will.go up �n Jan,_ J � vs. FPC Rate �.. 12.9 ; 12.9 i Note: This is Pro ress g g (Residential) I ;. . _.. _I .. _ . _ . _ ... . I .._ _ ... . j . .. . . ... - - • -- .._. ._. . .. .. . :.. . _ r _.. .. . .. .. , .. . , ... . , _ . _ . .. . . .. . . . :.. . . .. . i . , : . , , . . .. __. Gas Cheaper . .... ;. .J . ____ � _. .. . , . ... . . . � .. . ; . .. . . . . _. _ __. • - -- i . . .. . . i _. . . . .. ._ , ._ .. .... by. _. i . -59% 13%' � _. . . . .. . _ ... 1 . . . .. ._ r . _- . . _ . __ . _ . . . . . _. _. � I i � -? I ' Notes: 1 . ,. ' . . . . . . . . . ' . . _ j _ . .. . ; . . _ _ . _. . _. ` Based on Bulk LP (BRLP3) which is apphcable for customers using 120.1 - 300 gallonstyear & equal to Residential LP Will Call (BRWCLP) , . _ _. _ - - _ _ ___ k New rates implemented 1/1/2009, w�th foi�owing chan�es: � I i I . T , .... ___ . _ . . ... I- RS NG Customer Charge increased $2 from $8 to 510/month & NFE rate droped 10 cents to 48 cents/therm (CC +$t/Mo in 4/tYL005). I- BRLP3 LP Customer Char�e increased $18 from 572 to $90/year, and NFE rate reised 10 cent to $1.00/gailon (CC +12/Yr. In 4/1/2005). : _ __ -- - � � i l- 9 g se initiallY l ! _ EiQ man�red�t oR'A'8 WNA chan ed � UTA,. but no additions to new,components, of the __ .. I_. I .__ r _._. , ._. CSW:8/28/2011 _ _ Attachment #6 Page2of3 Competitive Historv of NG vs. Electric Rates Month-Year NG Therm Cost September 2001 $ 1.34 $ September 2002 $ 1.36 $ September 2003 $ 1.56 $ September 2004 $ 1.69 $ September 2005 $ 1.97 $ September 2006 $ 1.89 $ September 2007 $ 1.86 $ September 2008 $ 2.12 $ September 2009 $ 1.39 $ September 2010 $ 1.39 $ September 2011 $ 1.42 $ $ Increase over Last 10 Years $ 0.08 $ % Increase over Last 10 Years 6.0% 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.053 $ 0.01 $ 16.4% 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.129 0.04 53% Avg. Annual Inc. Over Last 9 Yrs. 0.6% 1.6% 5.3% NG vs. Electric -46% -37% -37% -35% -31 % -46% -47% -40% -64% $5% -59% csw:�v2si2o�� i ! I ! �,Hnacnmeni �o __ _. __ 1 i --- _. .._._. -. � ;_ _ � _. _ . i ; _ ; . - g __ _ _ _ ,f Pa e-- o __3 $ ; �_ � I I __ _ - - -- _� _ � � - _ _ -1 __ l _ _ --- 1 _ _� _ _ _ __ _ _ _ _ __ _ _ �_ Annual Average CGS Residential Rates - ___ , _T_ _._, _-- - - _ , -- ---1 _ --1 -- - __ _ --- _ _ � ___ i-- ---- - !- _ Calender Year ; ; Fiscal Year � - i-- Year � NGITherm ' LP/Gallon * I �Year � NG/Therm � LP/Gallon *�___ -- _ . _ _ . _ _- 1995 I NA , NA 4 I FY 95/96 ;$ 0.880 �$ 1.199 !* -- _ _ - - -- - - - _ . - - -- 1996 -�___ 0.915 I$ 1.239 �" -, FY 96/97 I$ 1.019 i$ 1 370 ,* -- - _ � _ - - __ _ � . _--,-- } i -- i __ a - -- -- _ * $ 1 318 I" _ $ 1 049 $ 1.380 "` FY 97/98 $ 1.054 ' __ __ ___--- -_ _--- 1998 $ 1 032 $ 1 288 ,_ FY 98/99 I$ 1.052 $ 1 269 �" - - -- - _ __ - --- - 1999 $ 1 073 t$ 1.311 � FY 99/00 i$ 1.152 '� $ 1 504 � __ _ __- _ ---- i2000 �$ 1 222 $ 1 584 ' FY 00/01 $ 1 551 $ 1 649 --- - 2001 �$_ 1 549 $ 1 586 i I FY 01 /02 i$ 1.352 j$ 1 488 -- - _.- . _ _ _ 1 . - --- __ 2002 I$ 1.342 $ 1.553 FY 02/03 ;$ 1.477 J� $ 1 817 � --- - _ -----� _ _ _------�__ _ � _ _ - -- - 2003 $ 1.534 �$ 1.864 ; LFY 03/04 '$_ 1.603 �$ 1.913 ; - _- - � - - -- r- _ 2004 �$ 1 652 '$. 1.968 I_ a FY 04/05 ;$ 1.803 1$ 2 162 �__ 2005 _ I$ 1.925 i$ _ 2 278 ; -i FY 05/06 ,$ 2.080 �$ 2 480 ___ _ __. __ _ _ _- --_ 2006 1$ 2 012 T$ 2_501 I FY 06/07 �$ 1.918 �$ 2 742 2007 }$ . 1 893 $ 2.869 t FY 07/08 �$ 1.932 �$ 3 183 -- _ - -- 2008 �$ 1.965 $ 3.186 _� FY 08/09 i$ 1.610 �$ 2 524 __ ---- _ 2009 I$ 1.464 $ 2.418 FY 09/10 Y$ 1.437 �$ 2 865 I -. 2010 _ � - � __ -_. - � _ _ __ f . $ 3.282 f _ _ _ _ _. 2011 $ 1.487 : $ 3.438 ; ' �$ 1.457 $ 2.946 FY 10/11 $ 1.475 ' � _ _ _ � __ l _ � � - Average I$ 1.473 �$ 2.088 $ 1.462 ,$ 2 048 �_ _ - I j _ _ , _ _ I. _ i I �I ; 1_ _. : _, I _ ,_ _ _}_ . . ; _ � _-_ � i_ -_ 1 _ _ � ,_ _ . , _ , _ _ __ I_ _ i Notes: __ 1 __ � � ____I _ . ! ' _ -- * Based on the Residential Metered Propane schedule which was clolsed for i ---- -- - - -- - - ---- - --_._ _-- ---- -! -- 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 i_ _ __------- _ _ _---- _ __ __ _.� -__ 120.1 - 300 qallons/vear & is equal to Residential LP Will Call �