Loading...
GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 2012�, :�� ��z;� � TO: FROM: COPIES: SUBJECT: DATE: CLEARWATER GAS SYSTEM Intero�ce Correspondence Sheet William B. Horne II, City Manager Chuck Warringt n, Managing Director Rod Irwin, Assis anager; Rosemarie Call, City Clerk; � CGS & CCS Man gement Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. AccountandCCS; Lynne Priester, Cust. Serv. Coord./CCS GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 2012 January 27, 2012 Gas Supply Prices have been dropping this winter; therefore, we are recommending a reduction in our Natural Gas PGA of 3¢/therm and a reduction in our LP PGA of 8¢/gallon for February. We also recommend that we continue our Contract LP PGA at 30¢ below our Standard LP PGA. We aze not recommending any changes in our Energy Conservation Adjustment (ECA), our Regulatory Imposition Adjustment (RIA), nor our Usage & Inflation Adjustment (UTA) for February. The net effect of these recommended changes for February is a reduction in our typical Residential Natural Gas customer's rate of 3¢/therm (-1.9%) and a reduction in our typical Residential LP customer's rate of 8¢/gallon (-2.1%). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after February 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 Propane (LP) Gas Contract Rate Schedule PGA ...... $0.84 per therm (down 3¢/therm) ..... $0.76 per therm (down 3¢/therm) Energy Conservation Adjustment (ECA) ............................ Regulatory Imposition Adjustment (EIA) ....................... $2.60 per gallon (down 8¢/�allon) ... $2.30 per gallon (down 8¢/gatlon) $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 January 27, 2012 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru December. 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 qast 10 _years, our residential natural �as rates have risen iust 6 0% as comaared to a 53% increase for Progress Ener�v Florida's residential rates. That's an avera�e annual increase of 0 6%/vear for natural �as vs. 5.3%/vear for electric --- a remarkable difference� I should point out that the overall effect is that our tvnical Residential customer rates are now approximatelv 61% lower than electric for Natural Gas. This is a very attractive competitive position vs. electric rates and got even better this month as Progress Energy's rates increased 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 February lst billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: � ,' r; iam B. Horne II, City Manager U:UAy DocumentsWISOFFICE\WINWORD\GASRATES\Gas Adjustments for February 2012.docac CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 _ _ _ _ _ ___ - __ _.._ _ __ _- -- Budget_ Reservation Commodity _______ _! Interest Cost Center _ ____. . _ _ -- --- --- ----- ---- Month ' Charges Charges __ , Expense Expenses __ _ _ - __ _ _-- -- -- - -- _ _- Prior Year _ _ ---_- - _ _- Oct-11. $ 4,549,558.33 . - .- - 822,886.34 � $ 92.26 ' $ 39,448.03 -- --- _ -- --- Nov-11 $ 175 157 39 ._ 830,572.12 $_ _ 20,886 07 ;$_ 39,127.23 . ___ _ --- ------ Dec-11 $ 177 586.31 903,149.48 $ 19,198.62 '$ 44,582.28 __ - _ _--- - Jan-12 $ 185,000.00 950,000.00 ' $ --__ _ - ---- -•--- Feb-12 $ 165 000.00 925,000.00 $ _ _ _ - --- -- - Mar-12 $ 185,000.00 � 925,000.00 $ _ -- - _ _ -- - ---� -- Apr-12 . $ 125 000.00 875,000.00 $ _ _ __-- -- May-12 $ 80,000.00 ' 825,000.00 , $ - _ _ - __ - Jun-12 $ 80 000 00 785,000.00 '$__ _- -_ __. _---- Jul-12 $ 80,000.00 � 785,000.00 , $ - - � - - - -- -- . _ . - - ---_- -- _- _ _--- - _ Aug-12 $ 80,000.00 785,000.00 $__ - -- - �- - - - Sep-12„ $ 80 000.00 785,000.00 $ - - --- -- -- _ ----- --- Per13 $ 283,081.69 - Total YTD $ 6,245,383.72 $ 10,196,607.94 ' $ (1) Includes Annual Admin Charge of $708,720 + CCS chg of $1,052,690 t + FY 10/11 PGA write off of $27,099.40 + WNA $304.10 16,826.42 ' $ _ 50,000.00 I 13,043.98 I�$ __ 50,000.00 '. 10,119.63 ', $ 50,000.00 J', 7,642.73 $ __ 50,000.00�'; 5,609.18 ' $ 50,000.00 _..___ 3,975.50 ', $ 50,000.00 ' 2,535.96 � $ 50,000.00 ' _ 1,169.67 � $ 50,000.00 ' (203.44)'� $ 50,000.00 � 100,896.59 , $ 573,157.54 Dividend $1,300,720 Total NG Fuel !__ Total NG PGA Expenses T_ Billed __ 5.411.984.96 i $ 1.253.222.7 $ 1,144,516.69 $ 1,201,826.42 $ 1,153,043.98 $ 1.170.119.63 $ 960,609.18 $ 918.975.50 4.158J62.171 1,618,956.68 ' $-_-_ 474,439.99 ', $ 1,958,314.02 ' $ 756,487.59 '� $ 1,737,913.89 �$ - 584,869.91 ', $ 1,665,500.81 � $ 495,381.18 � $ 1,464,353.37 �$__ 406,710.64 � $ 1,287,343.62 I $ 326,734.45 � $ 1.206.884.65 T$ 287.909.14 � $ 916,169.67 1,190,792.85 $ 274,623.18 $ 914,796.56 ' 1,190,792.85 $ 275,996.29 $ 283,081.69T - - �$ --(283,081.69)' $ 116,045.79 '$ 17,168 101.39 '$ 52 055.61 Attachment #1 Page 1 of 4 --- -- ._ _ _- -- - Cumulative NG PGA - ------ - YTD Overage Rate/Therm --- - .__ _- -----.__ (Shortage) Firm/Contr 4,177,214.60) 0.82/0.74 3,839,724.41) 0.87/0.79 3,365,284.42):_ _ 087/0.79 2,608,796.82)' 0.87/0.79 2,023,926.92) 0.84/0.76 1,528,545J4),_ 0.84/0.76 ` - --- - - 1,121,835.10) _ 0 84/0.76 - - -- (795,100.65) , 0.84/0.76 ---------_ -- - (507,191_51): __ __0 84/0.76 (233,934.61) 0.84/0.76 40,688.57 0 84/0.76 - -- � -- - - 316,684.86 0.84/0.76 ' - --- . _ 33,603.18 -- -- - . .� , + Add'I Dividend based on FY11 Net Profit $1,351,278 = $ 4,440,811.50 ' ', _ __ --- - - _ - -- _ __- � --- - -_ _ -- ---- - -- --- ---- ---- --- --- ---- - -- _`(5) : Commodity adJustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Rate _ __ _ - ___ _ __ _ _. _ NG Proportion = 97.9% x Total ECA Transfer = $ 283,081.69 _ _ _ _ _ _ _ _ _------- _. __.__. . . ._ _ ___ _ ------ -- - ---- - -- - --- - --_ _ -____-- --- . _ . _ _ _ Net RC = $ 1,521,490.53 ' '' -- _ - -- --- - - --- -- --_ :_.- ---- --- + --- ---- _.._ _ -- -_ _ PROPANE ILP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) ; , _ _ _ . _ . _ --- - - ---- r- --- -`- -Nfon�ily - ' �mulaiive � - LP PGA . � __ _ __ -- --- - _ -_ _ -- - ----- _ ---- -+--- --- --- - *- - --� . -- -- - - - - Budget ._ Galions _ _ Monthly _ _,_ _ Interest i Commodtty __: _ __Total LP Fuel _ Total LP PGA__. _Overage . YTD Overage Therm/GaL Month Soid WACOG Expense , Charges ', _ _ Expenses __ '�_ _Billed Y _ (Shortage) __ _ (Shortage)_ . -- - --- - _ - _ _ Prior Yeaf . . . ' ' -- -----,-- $ (44,746.06) _ . _. - - , -- -- -- -- ---- - --- t _- - -- -- -- .Oct-11 . 34,240.2 $ - --1.80693_; $__ _ _-22373_' $_ 61,869.64' 1 ' $ _ 295,745.48' $ 83,495.97 $ (212,249.51)�$ (256,995.57) 2.24l2.46 - - --- -- - - - -- --- - - -- - - _- -- Nov-11 29,551.0 $ 1.80024 $_ 1,28498 __ 53,198.89 _ 54,483.87 __ 72604_41t$ 18120.54 $ (238,875.03) 2.24/2.46 Dec-11 36,513.7 �$ 1 76919 $_ 1,194.38 64,599.67 � 65,794.05 89,690.65 !$ _23,896.60 $ (214,978.43) 2.24/2.46 - - � - - - --- --- --- Jan-12 52,000.0 $ 1J1000 $ 1,074 89 88,920.00 89,994.89 ____ 138,827.70 $ 48,832.81 $ (166,145.62) 2.45/2.68 . - - --- - -- --- - - --- - - Feb-12 43,000.0 $ _ 1 66000 $ 830 73 71,380_00 ,_ 72,210.73 111 372 97 $ 39 162.24 $_(126,983.38) 2.38/2.60 -- . _ _ . ----- - --- ---. Mar-12 38,000.0 $ 1.65000 $ 634.92 62,700.00 63,334.92 98,422.62 '$ 35,087J1 $ (91,895.68) 2.38/2.60 Apr-12 34,000.0 $ 1.65000 $ 459 48 ___ 56,100 00 � 56,559.48 � 88 062 35 '� $ 31 502.87 $ (60 392.81)� 2 38/2.60 May-12_ 32,OOOA $ . 1 63000 $ . _ 301.96 52,160 00 . _ - 52,461.96 ' - _ 82,88221 � $ 30,420.24 $ (29,972.57), 2 38/2.60 - -- -- --- --- _ _ - Jun-12 30,000.0 $ 1 60000 _$ __ _149.86 __ 48,000.00 '� ' 48,149.86 ' 77,702.07 I$ 29,552.21 $ (420.36) 2 38/2.60 _ _ --- -- ---- -- -- -- - -- Jul-12 28,000.0 $ 1.58000 $ 2.10 44,240.00 ' 44,242.10 ', 72,521.93 !: $ 28,279.83 �$ 27,859.47 ^ 2.38/2.60 Aug-12 28 000:0 $ - __ 1.57000 $ _ (139.30)� 43,960.00 ' , __. . 43,820.70 ' __ - -72,521.93 � $ 28,701.23 $ 56,560.70 . 2 38/2.60 - - -- -- . - . -- - ' � 43,957.20 I 72,521.93 ', $ __ 28,564.74 � $ 85,125.44 2.38/2.60 P13 ---- _._ ._ Sep-12 _. 28,000.0 $ __ _ _ _ 1 58000 -$-_- -___(282.80) 44,240.00 _ 4 82,420.13 ' ; $ (82,420.13j $ 2,705.31 Total YTD 413,304.9 $ 1.67278 $ 5,734.93 'i $ 691,368.21 ', _ _ - - --- - _ _ __ - --- ---- - --------- ----�--- Cost Center Expenses _ . _ _ . - - _ � ___ _ _ - - -�---- CCS Chg, Admin & Dividend $ 184,114.00 1 _ _ _ -- 'FY 10/11 Write off PGA 8� WNA - _ . __. ___ �_$ -- ------ _ 1 _ . ._ ___ _ ----- - --__ _ --- __ �-- -- --_ Fuel $ 15,000.00 1 _ _ __.. _.--- -- --- -__ __._-- --------�-- ----- ---- Donations to events $ - ' 1 ___. _.- ---- _-- _ - ----- _ __ _._ _ __ _- - -- LP Yard Vaporization/loss due to malfunctioning meter �$ 104.61 � 1 --- -- - ----- _ _ --__-__--- ----- -------�--- �LP PGA Event fuel cost '$ 19.26 '' 1 _ --- _-- -- --- _ __ - _ _- - Suburban Software Systems � $ - � 1 -- ---- - _ _ _ __ _ _ --_ - ----._ Depreciation of LP tanks $ 34,414 23 1 _ __ _ __ _ . _ -- ---- - ,- Suburban Software Systems license , $ - 1 - - --- -- _ _ _--- -- -- --- Contribution to garage LP trk up grade $ ______1 LP Holding Tank Restoration $ - _ __ --- -- -- _ . $ 233.652.11 i - _--- --_ _ ---- --- -----� __ __._ _ ___ , _ --_._ , _ ._ . _ __ - _. _ _ --- ----�--------------- - ---- - ----- - �- _ _ _____ _(4) � Adjustment from FYE transfer of ECA in PGA 1/2 of the ECA Rate _ @ -- - --- __ LP Froportion = 2.1 % x Total ECA Transfer = I$ 6,072.23 ----- -- -__ _ '+ Additional Projected Costs Needed = '$ 76,347.89 --- ------ - .._ __ ___ , _ � Proj. Ann. Costs Add'I. Proj. Costs � - --- - - - - - - . . I I ' $ 310,000.00 ' $ 76,347.89 !. CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Attachment #1 Page 2 of 4 __ _ ._ _ __ - ---- --. __ __-- �- --- __-- -- _ ! _ ' ! Monthl _ _ Cumulative ECA -- - -- _ ___ ____ --- - - -- -----� �-- -•-_ -Y - --- ---- -- - Budget Cost Center Interest ' Total ECA i Total ECA Overage _ YTD Overage _ NG/Therm -- - . -- --- - --- ------- ---------- ----� - -- --- - - Month Expenses _ NoteslExceptional Items I Expense ; ;,CNG Station .: ' Expenses _ �_ Billed _ __ _ (Shortage) _ ` _(Shortage) _ LP/Gal. - --_ _ __ __ _-- --- - . _ _ PnorYear�� =~`:fi: . ,` .:: ;_ � $ - - -- - -- __ _ - -- _ _._.. --- -- - �----- - ----• - -- - --- -- - --- Oct-11 $ 570,285.44 PromoS5a,767,Adv$o EmployCosts$s9,e19 _ $ __ � ` 2�53454. 1 ; $ 572,819.98 ; $ 100,694.45_�$__(472,125.53): $ (472,125_53)_ _013/0.13 - --- ---- ------- -- Nov-11 $ 89,882.26 Promo$24,249,Adv $5,000, Emp�oy CostsS61,o73 $_ 2,360 63 $", _.^43g 2�; 92,682.14 i___ 138,769.26 i_$ _ 46,087.12 $_(426,038.41)_ _ 0 13/0.13 Dec-11 $ 90,222.82 PromoS3z,sz5,Adv S3oo, Employ Costs$5s,998 _ $ _ 2,130 19 $ � , =1;4�0 6�,; � 93,823.64 ,_ _ 165,173.14 '� $ 71,349.50 ' $ (354,688.91 0 13/0.13 -- -- - ----- _- - _ __ _ _. _ -- -- °; . .--- -- --- --+ $ 29,197.20 ' $ (325.491.71) 0 13/0.13 Jan-12 $ 150 000 00 _ $_ 1,773 44 151,773 44_ _ 180 970 64 --- - -- _- _ _ - _ Feb-12 $ 100 000.00 _ $_ 1,627 46 101,627 46 165 977.65 '� $ 64,350.19 $_ (261,141.52 0 13/0.13 __ _ --_ __ _- --- _ � --- - _ Mar-12 $ 100,000.00 $__ _ _1,305.71 ";�; ;' ' 101,305_71 ',�___158,820.20 t $ 57,514.49 . $ (203,627.03) _ 0.13/0.13 -- - - - Apr-12 ] $ 100 000 00 $ 1,018 14 ' ` , ', 101,018.14 !__ _ 139,683.42 ; $ _ 38,665.28 $ (164,961J5): 0.13/0.13 - - - - . _--- - - - - --- May-12_. $ 100 000.00 .._ . � $ _ _824.81 ` = ` ' 100,824.81 ; 122,957.57 , $ _ 22,132.76 , $__ (142,828.99)�--0 13/0_13 _ - -- -- Jun-12 $ 100 000 00 -. . �$ __ _ 714.14 ' ; i, ' 100,714.14 ;�__ 115,272.72 $ 14,558.58 $ __ (128,270.41). ---__0 13/0.13 _ _- __ -- -- Jul-12 $ 100 000 00 $_ _ 641.35 : I 100,641.35 ! 113,615.21 $ 12,973.85 $ (115,296.56)'__ 0 13l0.13 -- - --- ----- -- _ - _ Aug-12 $ 100 000.00 $__ 576.48 100,576.48 ', 113,615.21 �$ _13,038J2_$ _(102,257.84)._ 0 13l0.13 -- _ - �-- ---- -- -- - - - - -- Sep-12 $ 100000.00 $___ 51L29 " ' : ___ 100,511.29 ; 113,615.21_ $ __13,103_92; $_ __ (89,153.92)_ 013/0.13 -- _ _ __ _ -- -- -- - .-- - --__ _ _ P13 $ 200,000.00 PaydownofNGVStationCosts 200,000.00 ; 289,153.92 $ 89,153.92 $ - Total YTD $ 1,900,390.52 $ 13,483.64 ' $__ 4,444.42 ' _ _'. $ 1,918,318.58 ! _$ 1,918,318.58 I $ - -- ___ _---- - _ _ _ _ --- - - -- - -- --- --- -- --- -T ----- -- _--- --- ___ ----- - _ (1) Includes Annual 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 = $ 814,582.33 � --- ------ -- --- .+Add'I Dividend based on FY11 Net Profit $71,775.- - - $ 445,699.47 �--- -----�- ---- -- - - - � - _ . -- - ; I . __ _ __ __ __ _ _- -- - - - _ _ _ _-----:-_ - ------- ---- ,. -- - - --- __ --- -._ . - _ - - _ I _ . __ _ _ _ - -- - _ ____ :_ __ __ _ _--- ----- --- ----------- __ - _ _ - --_ _ I ___ _ _ __ _ -- - _ _ __ _ _-------- - - �- - -- -- . __ _ ___ _. --- _ _ Net CCE - 1,272,619.11 ---- - � - - -_- - __._ _. - -- . _. ___ -- -- - - - ---- -- ----- -- - -- __ _--- - __ . _ _ _ . _ _ _ _.. -- _ __ _ --- _ _ __ _ , REGULATORY IMPOSITION ADJUSTMENT (RIA1 (EIA) .. .__ - (ORA __ _.. ____ .___ � -- -_ . _ _-- _ _ - . -- -- - -- - - --- --- ---- --- -- - . Budget_ Environmental _ Regulatory `_ _ Interest _, : _Total RIA __ _ Total RIA ___ Overage_ _ YTD Overage NGITherm _ -- -- _ _ _ Month Expenses Notes/Exceptional ltems _ __ Expenses `__ _ Expense _ Expenses __ Billed (Shortage) (Shortage) LP/Gal. __ -- - --. . -- . _ _ _ _ PriorYear - $ - $ (161,500.70) ---- - - -- --- --- - ---- - - - ---- 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 $ 1,324.00 - $ ___775.89 •___--_-2,099.89 ; 21,322.53 , $ 19222.64 $___(135,955.81) _._0.02/0.02 Dec-11 $ 3,140:90 - . - , - $_ 679.78 ii 3,820.68 '�- 24 412.10 $ 20 591.42 Y$ (115,364.38) 0 02/0.02 Jan-12 $ 10,OOO.QO' . _ ' $ 576.82 _ . 10,576 82 ! - - 28 253.27 � $ 17,676.45 $ (97,687.94) 0 02/0.02 ------- ---- _ _ _ -. - - - -- Feb-12 $ 10,000.00 $ 488.44 10,488.44 � 25 912.55 $ 15 424.11 $ 82,263_83) 0.02/0.02 i ( Mar-12 $ 10,000.00 -- . $ - -- 411.32 T- � - - 10,411.32 ! - --- 24,795.12 . $ 14,383.80 $ (67,880.02) 0.02/0.02 I _ _ --- --- --- --.. . --_ ---- --- -- -- _ Apr-12 $ 10,000:00 $ _ _ 339.40 10,339 40 _ _ _ 21 _807 48 . $ 11 468.08 _ $ (56 411_95) � OA2/0.02 I May-12 $ 90,000.00 $ 282.06: 10,282.06 _ 19,196.22 $ 8,914.16 $ (47,49778) 002/OA2 i _ ----- --- - Jun-12 $ 10,000.00 . . $- __237.49 ;_ 10,237.49 17 996.46 $ 7,758.97 $__ (39 738.81) 0 02/0.02 _ _ - -- ---- - - -- _ -- - - Jul-12 $ 10.00Oi00' $_ _ 198:69 ' 10,198.69 r_ 17 737.69 $ 7 538.99 .$__ _(32 199.82) 0 02/OA2 - -- --- __ __ _ _- Aug-12 $ 10,000:00 ` $ 161.00 10,161.00 , 17,737.69 � $ _ _7 576.69 $ (24,623.13) _ 0 02/0.02 _ _-- - -- ------ _- -, __ - - - ---- -- - - Sep-12 $ 10,000.00 -$ 123.12 10,123.12 17,737.69 $_ 7,614.57 $ (17,008.56) _ 0 02/0.02 P13 _ _ _ ;-$-- _ _--_ -__ -- . ____ _--- -----$ _ _ $.._ 17,008.56 � _ _ ' $ --- �- - �---- $ -------- -- $- - __ (17.008.56 -- - - -- - ) _ _ _ Total YTD $ 106,855.43 $ $ 5,081 51 . 111,936 94,_ 256,429 09 $ _ 144 492.14 ' _ _ . . ___ -_ --- --- -- - - -- -- --- - _ _ _ . - - - -- -- _- - -- _- -- _ -- -- --- ____ - _-_ _ - - _ _ _. _ . _ I (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 - _ _.._. _-- - - _ -- -- --- ---- --- - ---- ---- -- _ .; Commercial --_ � . ----; Monthly_ _ Cumulative y _ __ UTA_ �. -- - _ -- - -- ----- --- --- --- - Budget _ Interest , ' r Overage YTD Overage �_ NG/Therm j; _ ____ _ - _ -- � _-- -------- -- --� --+- -- - -- - Month LP Gallonsi Expense__ Rate/Gallon NG Therms � RateRherm _(Shortage)_ ; (Shortage) LP/Gal ? - -- -----� -- -- -I Be . Bal. __ __. _ -- --------- -___ --- '----- -:- $ - $ (644,952.53),-- , Oct-11 5,770 0$ 3,224.76 0.05 748,591.5 ' . _ _ - _ -- - -- --- _ --- - --- - - -! _ __ . __. _ . _-_-- - __ __ ___ ------------. __..,-- -------__._.. 0.05 I $ 34,465.20 $ (610,487.33)' 0.05/0.05 ; Nov-11 5,895.2 '$ 3,052.44 0.05 ' 818,028.9 I 0.05 $ 38,234.32 $ (572,253.01} 0.05/0.05 _ _ __ --- _ _ _ _ ------ --- - -_ -- ------ �: . Dec-11 - 7,631 7 ', $ _ 2,861.27 ', 0.08 ,Y 1 946,953.4 ; 0.08 , $ 65,040.78 $ - (507,212.22) 0.08/0.08 ', -- ---- ---- -- -- ---- --- ---- Jan-12 8,000 0�$ 2,536 O6 ' 0 08 ' 1,000,000 0 0.08 $ 74,188.80 $ (433,023.42) 0 08/0.08 Feb-12 . . - - - - . 7,500 0 $ 2,165 12 0 08 � - - 950,000 0 ----- 0.08 $ - 70,472.00 $ (362,551.42) 0 08/0.08 Mar-12 .. 7,500 0$_ _ 1,812 76 0 08 '- ---- - 950,000.0 '- � _. --- - -- <-- _ __ -_. . _ _ --- --- - - - 0.08_� $_ 70,472.00 $ (292,079.42). _ _ 0 08/0.08 : --- ---- - _ -�_ _- - --- - -- - --- - �� _- Apr-12_ . - 7,000.0 $ _ 1,460.40 - - ---__- 0_OS___ __ . _925,000.0 ! 0.08 ' $ 68,595.20 ; $ __-(223,484.22). _ 0 08/0.08 s; __ _ -_ _ _ - -- --- ------ _ . _ May-12 _ . _ _ _ _ _ ____ _ _ 6,500.0 $ _ 1,117.42 _ _- 0.08 :_ -__-- 725,000.0 - --_-- 0.08 _ $ 53,838.40 ''�$_ (169,645_82). _ _ 0 08/0.08 � --- . Jun-12 6,500.0 '$ __ 848.23 0.08 !__ 700,000.0 0.08 $ 51,998.40 $ (117,647.42) 0 08/0.08 � __ _ - Jul-12 _ . . --5,500.0--$-_-__ 588.24 _ ___ 0.08 - -- 650,000.0 , - -0.08 $ 48,244.80 ' $ (69,402.62). 0 08/0.08 ; Aug-12 5,500 0$ __ 347 01 ` 0.08 650,000 0' 0.08 $ 48,244.80 $ _(21,157.82) 0 OS/0.08 - _ _ ; - Sep-12 5,500 0$_ 0.08 ' 650,000 0� 0.08 $ 48,244.80 $ 27,086.98 0 OS/0.08 � _ _ _ --- � - - Per 13 ,-- __ - --- - Total YTD . 78,796.9 -- 20,013J0 '^ � 9,713,573.8 : - . . - . � $ 672,039.51 i __ --------- - --- -- ----- � _.__- ------ --------._ _ _ _--- ____- .__ _ _ (1) December Overage is reduced by $8,293.09, which was the FY 10/11 interest that was erroneously left out of the adjustment calculation _ ---- , _ _ - - _ ___- - - - - _ _---_ _-_ _---- ---_:.---� ---- -'-- -- ---- --- ---- _ -- � - .. _ __ . _ _ _ USAGE AND INFLATION ADJUSTMENT (UTA) _ _-- _ _ _ --- - - -- - _ ---- . -- ---- -- - --_ _- - --- - ---- __ _ _ __ Residentfal Monthly ___ Cumulative UTA I _ _- -- - __ _ _ . -- -- -- --- - _ _ --- --- -_ -- ----- --- _ _ . Budget Interest , , Overage _ _YTD Overage NG/Therm � _. _ --- - - ---- --- _ _ _ ---�- -- ---- - - --- _ _ - --- - - -- Month LP Gallons __ _Expense __ _Rate/Gallon__ _ NG Therms _ __`Rate/Therm (Shortage)_ (Shortage) LP/Gal -- _.. Beg. Bai.__ _ _ _ - _ ----_ _ $ $- �180,801.96) - - - - ---- _ _ _ _-- _,----- _ -- -- Oct-11 -. . 28,470.2 $-_ -_ -904.01 0.02 ' 194,083.1 0.02 $ 3,541.17 $ (177,260.79) -- 0.02/0.02 ---- Nov-11 . . 23,628J -$ __ _ 886 30 0.02 . --- -219,872.8 ._ _ . - 0.02 $ - - 3,986.29 ' $ (173,274.50)'- - 0.02/0.02 _ _ -�-- - Dec-11 27,524.4 $ 866.37 ' 0.06 � 1^ 288,762.0 0.06� $ 17,259.34 �$ (156,015.17) 0.06/0.06 - -- _ __-----_. -- _ ----- -, __ _._ Jan-12 40 OOOA $ 780.08 _ 0 06 , 550,OOOA 0.06 $ 32 568.00 $_(124 227.24) 0.06/0.06 -- Feb-12 30,000 0$_ 621 14 ,_ 0.06 450,OOOA 0.06 $ 26,496.00 $ (98 352.38) 0.06/0.06 _ - -- - -�- - - - -- -- . .- Mar-12 30,000 0$_ _ 491.76 0.06 �I . 375,000.0 0.06 $ 22,599.00 $ (76 245.14) __0.06/0.06 Apr-12 . . . . .25,000.0 � $ 381.23 . _ 0.06 ' _. 300,000.0 ___. --- . 0.06� $ 18,330.00 $ . (58,296.37) 0.06/0.06 . - _ ---- -- __ - - -- -- - --__-- May-12 . . 20,000 0 $ _ 291 48 - 0_O6_._- -____ _- 225,000.0 `_ 0.06� $ __ 13,965.00 $ (44 622.85) __0 06/0.06 Jun-12 20,OOOA $ 223.11 ' 0 06 : 175,000.0 ' 0.06 $ 11,232.00 $ (33 613.96) 0.06/0.06 --- -- - -- -- --- - ---- . _ _--- . .. -- - - -- - _ - --- Jul-12 20,000.0 $ 168.07 _ _ 0 O6 ' . 175,OOOA , 0.06' $ __ _11,349.00 $ (22,433.03) 0.06/0.06 _ - ___ __ Aug-12 20,000 0.$_ 112 17 0.06 , 175,OOOA 0.06! $ 11,466.00 $ (11,079.20) 0.06/0.06 - __ - -- __ -- ------- -, _-- --- -__ . --- ----- - _ Sep-12 20,OOOA $_ __ 55 40 ____ 0.06 __ _ 175,OOOA _ 0.06 $ 11,583.00 $ 448.41 0.06/0.06 _ -- _ ._ - -- � _ _ _ --- -- - _------ • -- - -_ _ . __ _ Per 13 $ - Total YTD _ _ _ _ 304,623.3 _------5,781.11 "_ _- _ - -,_---, 3�302,717.9 ' ------ - ---- _ _ _ ' ', $ 184,374.79 . _ _ _ _ _- --- . - ---- --__ _ -�-- -- - ----- ---- ----' - -- . - - � _ (1) December Overage is reduced by $723.06, which was the FY 10/11 interest that was erroneously left out of the adjustment calculation. - - _ _ CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 � � . _. _. ___ .__ .___ ---- --- ----- B ud get _ _ _. __ _ -_- -- -- --_ _- Month _ . _- - - ---- -- - ------ Prior Year Oct-11 _ _ _ _ _ � __ — ------ Nov-11 - -- _ __ _ _ - - _ _ _ . _ ___ - Dec-11 _ . _ ___ Jan-12 _ _- _ -- - _. __ _ _ -_ - _ _. Feb-12 .Mar-12 _ _ _ _ __ _ _. _ _ . -_ _ - - _ ___ AP�-12 _ _ __ __ _ _ _ . May-12 _ - - __ . _ --- Jun-12 _. _ ._ _ _ . _ - Jul-12 _ _ __ _ _ Aug-12 . __ _ -- - - Sep-12 _ _. . Per 13 _ _ - - __. Total YTD _� . _ _ _ . _ Attachment #1 � Page 4 of 4 i _} ' _ --- _---__- __ _ _ I Cumulative � Total Resl ' - -- �— �--- � --- j � ota� Hn i oiai rtecover� ,� vverac�e_ _, _YTD Ove�age NG/Thm (Firm) .� ---. ----- -- — -�--- Expenses ` Billed __ (Shortag�_�_ (Shortage) �LP/Gal (Resl) ; - ,� "' - ' --- $ -- $ i1,050�453_68) _ __ ' - _ -- ---- J ' $ 6,293,748.46 I. $ 1,494,939.87 ' $ (4,798,808.59)T$_ (5,849,262.27)_ 0.99l2.63 ; _-- -- --�-- -- 1,215,008.71 ~$ _ _1,678,149.82 $ _ 463,141.11 ' $ (5,386,121.16) 1.04/2.63 ` _-- ___ .- _.. 1,307,955.06 ', $ 1,980,532.69 ' $ 672,577.63� $ (4,713,543.53) 1.08/2.67 � ------ ____._ �.._ . - -------- — �- 1,457,487J2 i$ 2,413,122.42 $ 955,634.70 �$ (3,757,908.83) 1.08/2.89 i - _ _ .- - 1,340,156.86 '� $ 2,138,145.06 � $ _797 988.20 ' $_(2,959,920_63) 1.05/2.81 ! �_._ __ __ _ �-- --- --- -- . ^_ _ 1,347,476.10 j_$ 2,040,609.75_ $ 693,133.66 $(2,266,786.97):_ 1.0512.81 j r--- - - _ ----- - 1,227,401.37 I$ _ 1,800,831.81 _f $ 573,430.44 $_ (1,693,356.53) 1 05/2.81 � �--- - ------ - -- - ---. _., -- - -. 1,125,586.91 I $ _1,580,183.03 , $ _454,596.12 $ (1,238,760_41) _1.05/2.81 'r 1,079,148.34 ' $ 1,481,086.30 ' $__ 401,937.96 , $_ (836,822.46) _ 1 05/2.81 � _ __ -- -----� -- -- -- 1,073,374.41 ', $ 1,454 261.48 �$ 380,887.07 $ (455,935.39) 1 05/2.81 ' - ---- - 1,071,187.04 i$ 1,454 378.48 �$ _383,191.44 $_(72,743_95) 1.05/2.81 � � 1,069,443.55 $ 1,454 495.48 � $ 385,051.92 $ _ __ 312,307_97 1.05l2.81 � - r- ----------- ------ . _ _ _ 565,501.81 , $ 289,153.92 ' $ (276,347.89) $ 35,960.08 � - - ' 20,173,476.34 ! 21,259,890.11 $ 1,086 413.76 { -- -�---- ---- ---- _ . : --- - . --- � -- -- --- - . . _ .._. : ----_--- ,- -_ -- -- _ _ _ � -- - ------ _. _-- - --- --�-- ---- -- - - - _ _ - __ ; Last Updated 01/27/2012i � i ; 1 zl n� � � ����� T �� CGS Natural Gas Cost Actual/Projections FY12 85 of ,,, 2,20, 2 Total 2,641,833 570,393 266,100 1,112,090 (585,687) ($159,885.13) 2,100,136 522,432 2,089,000 -0.16% 105.8% $5.47 Total $1,240,076A2 $409,827.37 $1q35729 $28,731J9 $734.27 $10,192,186.69 $ (195,967.67) $290.331.01 $126,504.00 85.9% Total Projected DTH WACOG Total Reservation Total Commodit Cost Purchased 1st6Months $ 1,034,904.45 $ 5,679,540.32 56,473,194.54 1,186,536 $5.456 2nd 6 Months $ 625 350.63 $ 4 512 646.37 $5 021,997.00 913 600 $5.497 TOTAL $1,660,255.08 $ 10,192,186.69 $11,495,191.55 2,100,136 $5.47 69.3% $11,495,191.55 . Propane Weighted Average Cost of Gas (WACOG) �� r� C����� �� 1/12/2012 FY 2011-12 Projections Delivered Delivered Delivered Cost Total Month CGS Cost Gallons Cost of Inventory Gallons Dec-11 Jan-12 $ 1.63 36,000 $ 58,680.00 $ 135,898.00 79,646 Feb-12 $ 1.60 40,000 $ 64,000.00 $ 138,472.09 83,646 Mar-12 $ 1.65 50,000 $ 82,500.00 $ 154,753.94 93,646 Apr-12 $ 1.65 50,000 $ 82,500.00 $ 154,626.84 93,646 May-12 $ 1.60 40,000 $ 64,000.00 $ 136,067.61 83,646 Jun-12 $ 1.55 30,000 $ 46,500.00 $ 117,499.29 73,646 ' Jul-12 $ 1.55 20,000 $ 31,000.00 $ 100,635.47 63,646 Aug-12 $ 1.55 20,000 $ 31,000.00 $ 100,011.97 63,646 ' Sep-12 $ 1.60 20,000 $ 32,000.00 $ 100,584.40 63,646 Oct-12 $ 1.60 30,000 $ 48,000.00 $ 116,976.94 73,646 EOM Tank EOM Tank Projected Gallons Cost WACOG 43,646 43,646 43,646 43,646 43,646 43,646 43,646 43,646 43,646 43,646 43,646 $ $ $ $ $ $ $ $ $ $ $ 77,218.00 74,472.09 72,253.94 72,126.84 72,067.61 70,999.29 69,635.47 69,011.97 68,584.40 68,976.94 69,325.91 1.77 1.71 1.66 1.65 1.65 1.63 1.60 1.58 1.57 1.58 1.59 CSW:Ot/27/2012 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Enerav CharstelTherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIA) Usage 8 Inflation Adj. (UTA) Total Non-Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelTherm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP/Gallon Rate of with 6.0°/ Franchise Change from 1/2006 Therm Rate °/ Change from 1/2006 Therm Rate Utilitv Tax Note: Fuel Rafe per Therm 10/01/1973 Non-Utility Taxable Fuel/Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR FEBRUARY 1, 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/M8 NGV (Closed 1/09) Rellaht (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 8 up 3 Units) 149 tons) tons 8+) $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 bilied $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 30.69 $0.69 $0.69 $0.69 $0.63 $0.57 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.76 1.53 1.53 1.53 1.53 1.53 1.47 1.41 1.04 0.99 0.94 1.04 1,19 0.76 + Non-Fuel $10.00 525.00 340.00 $95.00 $25.00 $40.00 $95.00 $10.00 $25.00 $40.00 $20.00 $20.00 By Contract (518.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) @ premise @ premise @ premise + FAC + FAC + FAC $ 1.40 $ 1.40 $ 1.40 $ 1.40 $ 1.40 $ 1.35 $ 1.29 $ 0.95 $ 0.91 $ 0.86 $ 0.95 $ 1.09 $ $ 1.48 $ 1.48 $ 1.48 $ 1.48 $ 1.48 $ 1.43 $ 1.37 $ 1.01 $ 0.96 $ 0.91 $ 1.01 $ 1.15 $ $ (0.73) $ (0.73) $ (0.73) $ (0.73) $ (0.62) 3 (0.62) $ (0.62) $ (0.84) $ (0.84) $ (0.84) $ (0.84) $ (0.79) $ -32.3°/a -32.3% -32.3°/a -32.3% -28.8% -29.7% -30.5% -44.7% -45.9% -47.2% -44.7% -39.9% $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.771 $0.771 �0.771 $0.771 �0.771 �^0.771 $0.771 $0.771 $0.771 $0.771 $0.771 $0.771 Interr. NG Rate NSS �S (Non•Resl) NA 100,000 & 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 Contract NA NA NA NA NA NA NA NA NA $0.46 $0.28 By Contract 0.84 0.76 0.76 1.30 1.04 0.76 + Non-Fue� $50.00 $250.00 Customer ($75.00) $400.00 Charge + + FAC + Non-Fuel Therm Non-Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms 0.70 $ 1.19 $ 0.95 0.74 $ 1.26 $ 1.01 (1.02) $ (0.85) $ (0.70) -57.3% -39.5% -40.2% $0.069 $0.069 $0.055 $0.691 $0.771 �0.705 BTU FACTOR = THERMS1100 CUBIC FEET ICCF) 10/2011 11/2011 12/2011 01/2012 02/2012 03/2012 04/2012 05/2012 06/2012 07/2012 OS/2012 09/2012 FY 11/12 Averaqe Firm Service Rates 1.035 1.036 1.036 1.036 1.035 1.036 Interruptible Service Rates 1.015 1.016 1.016 1.016 1.015 1.016 $ (0.70j -47.9% $0.069 $0.691 CSW:01/27/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 FEBRUARY 1, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMILY LOOP RESL. SMALL COML. �ARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP (Non-Resl.Only) (Non-Resl.Only) Applicable Annual Galion 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 Enerav Charqes/Gallon: Non-Fuel Energy Charge (NFE)/Gal�oi $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract $1.00 Set By Contract Energy Conservation Adj.(ECA)/Galloi 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 R Inflation Adj. (UTA)/Gallon 0.06 0.06 0.06 0.08 0.08 NA NA NA Total Non-Fuel Charges (NF)/Gal. 52.11 $2.11 $1.11 $0.53 $0.48 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal 2.60 2.60 2.60 2.60 2.60 Set Bv Contract 2.60 2.30 Total Energy ChargeslGallon $4.71 $4.71 $3.71 53.13 $3.08 Contract NFE $3.60 Contract NFE + + Contract PGA 52.300 I 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 Gallon 10/01l1973 0.161 Non-Utility Taxable Fuel/Gallon $2.439 Change from S/2008 Gallon Rate $ 0.57 % Change from 8/2008 Gallon Rate 13.8% 0.161 $2.439 $ 0.57 13.8% 0.161 $2.439 $ 0.37 11.1% 0.161 �2.439 $ 0.39 14.2% 0.161 $2.439 $ 0.39 14.5% Customer Charge + Any Applicable Facility Charges 0.161 0.161 Contract PGA - 0.161 $2.439 NA $ 0.67 NA 22.9% for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW :01 /27/2012 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 Charqes (NF11Gallon: Non-Fuel Energy Charge (NFE)/Gal. $ 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 & Inflation Adj. (UTA)/Gallon 0.06 0.06 0.06 0.06 Total Non-Fuel Charges (NF)/Gal. S 2.01 S 1.81 S 1.21 a 1.11 ' Purchased Gas Adj. (PGA)/Gallon $ 2.60 $ 2.60 $ 2.60 $ 2.60 Total Energy Charges/Gallon 5 4.61 5 4.41 S 3.81 � 3.71 Note: No Monthly Minimum Bill Utilitv Tax Note: Fuei Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 Non-Utility Taxable Fuel/Gallon $ 2.439 $ 2.439 $ 2.439 $ 2.439 Change from 8/2008 Gallon Rate $ 0.570 $ 0.570 $ 0.37 $ 0.37 % Change from 8/2008 Gallon Rate 14.1% 14.8% 10.8% 11.1°/ Attachment #5 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR FEBRUARY 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 t-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.60 $ 2.60 I S 4.41 E 3.71 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.73 I 0.02 0.02 0.08 0.08 S 0.48 S 0.43 $ 2.60 $ 2.60 E 3.08 S 3.03 BULK STANDBY/ GENERATOR LP B (Closedfor New Residental Applications) $ 420.00 $ 1.00 NA NA NA a �.00 $ 2.60 S 3.60 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ $ 2.439 $ 2.439 $ 2.439 $ 2.439 $ $ 0.57 $ 0.37 $ 0.34 $ 0.34 $ 14.8% 11.1% 12.4% 12.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.30 Cotract NFE + 2.300 0.161 $ 0.161 2.439 Contract PGA - 0.161 0.67 NA 22.9% NA csw:o�rzmoiz ' ; ... . . . i.. .. . _ . . . �� � � �; ., �,' Attachment #6 . .. . .. !.. .. . �.. . . . .. .. . ;. .. . . . . . ,. .. .. .. .. ... .... . ..Pagelof3 _ Residential Rate History By Components _. _ _ _ _ Clearwater Gas Svstem , , _ , , , , , � nth� �NGftherm , Rate .. ! , Adjustments/Thertn Conhact � LP � Total Mo ' P/ allon •, { ECA EIA/RIA# ; WNA/UTA-Resi# I UTA-Comil# � P�,A . PGA i PGA/aallon � Oct-08 $ 1.990 1' $ 3 300 i ... . -. ' .. .. � $ 0.140 '�: .$ - $ .. . . � $ . .. j $ t270 $ 1.190 � $ 2 260.. . Nov-08 $ 1 990 I$ 3 300 . � - - - $ 1 270 .$ 1.190 $ 2 260 . $ 0.140 $ $ $ � .. Dec-08 $ 1 940 $ 2 770 � .... . .. 1 . .. . $ 0.140 � $ $ $ I $ 1220 $ 1.140 I $ � 1 730 .. Jan-091 $ 1 750.�$ 2290 I # ._._. � .... , . $ 0.090 i $... . . _ $ ..-... , $ .. - � $ 1.180 i $ 1.100 . $ 1 200� Feb-091 $ t]50 �$ 2 290 T $ 0.090 $ $ $ $ 1.180 i$ 1.100 �$ 1200 Mar-09� $ 1 580 ;$ 2.270 f I$ 0.070 $ $ {$ $ 1.030 $ 0.950 $ 1.200 . _ � i . Apr-09J $ 1.410 �$ 2200 ; � i �$ 0.040 I 5 - $ $ `$ 0 890 $ 0.810 I$ 1 160 .. . May-09 { $ 1.410 I $ 2 200 . _ . .. � _ . .. . $ 0.040 . $. . . - .: $ . . .. . - . $ . . 4 $ 0 890 $ 0.810 J $ . ... 1 160.. Jun-09 i $ 1 410 � $ 2 200 � _ � . . I $ 0.040 $ - $ - $ . . . i $ 0 890 � $ 0 810 I $ . .. 1 160 _ Ju�I-09 $ 1.350 1 $ 2 330_� .... � .._ .. . � $ 0.040 , $. . . $ . - . . $ - i $ 0.830 $ OJ50 � $ 1 290 P , � $ 0.040 i $ ; $ - $ - I $ 0 830 $ 0.750 $ 1 450 Se -09 �$ 1.390 i$ 2.650 I � II I$ 0.070 �$ 0.010 $ - ;$ - !$ 0.830 'i $ 0750 i$ 1.570 FY 08/09 Av .' S 1.610 � S 2.524 I I I S 0.078 I S 0.001 I S I S i S 1.026 I S 0.946 I 5 1.470 2008 Av . S 1.965 I S 3.186 I I I S 0.136 i, S I E 0.013 I E I S 1.237 I S 1•157 ! S 2.138 �� � Nov-09 $ 1.390 �� $ 2.670 i $ 0.070 $ 0.010 I _ . � . . . � $ 0.070 $ .. .0.010 . $ . . . - 1 $ - I $ 0.830 � $ 0.750 $ 1.590 � � l . S - t $ - � $ 0.830 $ 0750 � $ 1.590 ' -- Oct-09 $ 1.390 I$ 2.670 � � _ �Jan 0$ 1.390 S 27 0 i . J $ 0.070 $ 0.010 I: $ - I$ �$ 0.830 S 0.750 $ 1.670 1 f S 0.070 $ 0.010 I$ - �$ - �$ 0.830 I$ 0750 $ 1.670 . Feb-10 $ 1.480 $ 2.810 t . � . $ 0.110 � $ 0.010 � $ { $ - y $ 0.880 I $ 0.800 i $ 1 690 _ _ _ . - Mar-10 $ 1.520 � $ 2.880 � , + I $ 0.110 i $ 0.010 $ - ( $ - 1 $ 0.920 $ 0.840 i $ 1 760 Apr-10 $ 1520.. y j _s z sao � 4 s o.„o s o:o,o i$ -. �$ - 1$ o.szo ` s o:aao g ,.�so I j r ( � $ 0.090 $ 0.030 I $ ' $ - � $ 0.890 $ 0.810j $ 1 J30 . a,9-�ot s i.sso� '$ z sso f i l s o.oso s o.oso � s -_ � s - $ o.aso t s o.iso i s �.aso � {J$ 2 990 f � 1 $ 0.090 � $ 0.030 � $ - $ - $ 0.830 f $ 0750 $ 1.870 . ..f_$ 3090_� _._ __ i ___ I � $ 0.090 $ 0.030 � $ .. -.... I $ - ; $ 0790 $ 0710 � $ _�_ 1 970 - $e _-- - _ _ _- - -_ i - 10J $ 1.390 �$ 3.090 1 1 i$ 0.090 $ 0.030 1$ - 1$ �$ 0.790 i$ 0.710 1$ 1.970 FY 09N 0 Av . S 1.437 � f 2.865 I I I S 0.088 ! S 0.018 ; E I S I S 0.850 S 0.770 i 1.758 2009 Av . S 1.464 I S 2.418 s 0.061 ! S 0.003 I S i S I S 0.920 j 0.840 , f 1.353 Oct-10 $ 1.47 $ 3.02 $ 010 f ' I -- � _ � { i $ 0.02 : $ -_ _ 1 $ - i $ 0 87 $ 079 1$ _ 1.90. f - - . Nov-10 $ 1.47 �_ _$ 3 02 r � $ 0.10 $ � 0 02 $ - $ - $ 0 87 $ 0J9 } $ 1 90 , . _ _ Dec-10 ,$. 1.47 � $ 3.02 � . . � .. .� . $ 0.10 � $ 0 02 � $ . . . .- , $ - $ 0.87 $ 079 $ 1.90 Jan-11 $ 1.54 $ 3.33.. . J . . ... . � $ 0.10 . $.. . 0.02 I $ 0.02 $ 0.03 � $ 0.92 1 $ 0.84 I $ .... 2.19 Feb-11 l$ 1.55 1�$ 3.37 I � I$ 0.13 $ 0.03 '$ 0 02 �$ 0.05 I$ 0.89 �$ 0.81 �$ 2.19 Mar 11 �$_ 1.55 I.$ 3.37 � I :$ 0 13 $ 0 03 ,$ 0.02 �$ OAS $ 0.89 I$ 0.81 �$ 2.19 Apr-11 �$ 1 46 �$ 3.28 i i $ 0.10 �$ 0 04 I$ 0.02 $ 0.05 $ 0.82 �$ 0.74 I$ 2.12 May-11 $ 1.45 {$ 3.35 � I i $ 0.12 i$ 0 02 $ 0.02 $ 0.05 $ 0.81 $ 0J3 �$ 2.19 . ._. 9 I_$. 1 45..1 $ 3.35J ..... . . ...,. j . ... .. � $ 0 12 � $ 0 02 ` $ 0.02 � $ OA5 $ 0.81 � $ 0.73 � $ ... 2 19 $ 1.42 I$ 3.46 � �$ 0.12 I$ 0 02 j$ 0.02 i$ 0.05 �$ 0.78 �$ 073 {$ 2.19 Au -11 i$ � 45 �$ 3 35. I � $ 0 12 $ 0 02 ,$ 0.02 $ 0.05 $ 0.81 $e l_" j j __ _ $ 0.70 �$ 2 30 u- I$ 1.42 i$ 3.46 I ! I $ 0.12 I$ 0.02 !$ 0.02 $ 0.05 ;$ 078 ,$ 0.70 $ 2.30 FY 10/17 Av . S 1.475 S 3.282 I � I S 0.113 I S 0.023 j S 0.075 I S 0.036 I S 0.843 I E 0.763 , S 2.130 2010 Av . f 1.457 I S 2946 ; ; ( j 0.096 S 0.021 I 5 I S ! S 0.860 I 5 0.780 � S 7.829 . . . , � I __ � i ` _ ; . _ � , _ $ 0.05 � $ 0.82 i $ 0.74 i $ p q6 Oct-11 �$ 1 47 $ 3.63 � I I �$ 0 13 $ 0 02 $ 0.02 li Nov-11 i$ 1 52 I S 3.63 $ 0.13 $ 0 02 �$ 0 02 �$ 0.05 $ 0.87 1$ 0.79 $ 2 46 _ _ { _ Dec 11 �$ 1 56 ;$ 3.67 $ 0.13 $ 0.02 $ 0 O6 $ 0.08 $ 0.87 I$ 079 �$ 2.46 - . , . . . . Jan-12 $ 1 56 I. $ 3.89 � -. . $...0 13 i$ 0.02 �, $ 0 O6 $ 0.08 $ 0.87 $ 079 $ Z 68.. Mar-12 . t I � $ 0.13 $ 0.02 , $ 0.06 � $ 0.08 ; $ 0.84 � $ 076 . $ 2 60 Feb-12 $ 1 53 i $ 3.81 { ' � � _ . i I : . . . i Apr-12 , . I � .. .. ,. .... _ _. � . J ... .. I. . �, . . _. . . . . . . . May 12 ' . , r . i � _ . , i . ; ' i _ Jun-12 .. f. . .... .. _ .. .. . ... . . . . . . . . � . _ _ .... __ _. Jul-12. ... .. . , �... � . . � Se -12i_ j I i . ; � Aug 12 I i � _ � � � ' _ FY 11/12 Av - I, S 1.528 I S 3726 I I i I S 0.130 �, 5 0.020 ',� S 0.044 I S 0.068 I S 0.854 I S 0.774 : S 2.532 2011 Av . ! S 1.487 i S 3.438 � � E 0.121 I. E 0.023 I E 0.023 I j 0.051 I f 0.839 ' S 0.759 � S 2.270 -. ';,__. ... �S 0.44t ... �I ... ._..... .E. - :.S ..10.01)� .. .. . I .. . .� ,. I$ 0.41 Incc Above S (0.02) f S o.oa S o.03 S(o.os), S lo.os) Last Year Same Month.. 'i -1 %�, 13%� ... ... ;�... . . .�. . ' � 0%� 33%; 200k'�.. 60%�; -6%...�� -6%,i '19°� 00 20 Thertns ' E (0.4U1J E 9.62 � � . , -1kl 14h1 : � . .. � �. . . . �._.. ..�. . ..._.� ........ I ... . : . .. .�... � .. . . . . .. .. � �... . ,.. . .. . E4uivalent ' i , Cents/KWH . I 5.2t 14.21 ..... .�. . .. : . . i �t . . ,. ... .. . �. . . ..... for Gas ' ' (Residential ��� "� � � s is Progress Energy's residential rate for usage >1,000 ICWH in January 2012. � s. FPC Rat, i 13.2 ;I 13.2 I Note: Thi . . . . . . . _ . . . . ... . ,.. . . . . . i . . . ... . , . , . ... . . . . Gas Cheaper i . ��' .. , . _ . . .. I! � ��.. .. . . . : . � ��; ! . . . . bY �'� -61%,; .. �%. . , :., . .. . . . : . . . . . . . . :. . . ; . Notes: ; .: .. . . ..._ .. . . . ;. . .. . �: . : . : . . : .. : ; . � . . . * Based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & equal to Residential LP Will Call (BRWCLP) # New retes implemented 1/1/2009, wdh following changes: '� '� � � '�., �� I ',- RS NG Customer Charae increased $2 from $8 to $10/month & NFE rete droped 10 cents to 48 cents/therm (CC +g�/Mo. in 4/1/2005). �� ''��;- BRLP3 LP Customer Charge increased $18 from $72 to $90/year, and�NFE rate raised 10 cent to $1.00/gallon (CC +12/Yr. In 4/1/2005). �I �I.- EIA changed to RIA 8 WNA changed to UTA, but no additions to new components of these initially. � '��. �• UTA im lemented 1I1I2011 �' ' ' ' � �� - 0 csw:ai2sizoi � Attachment #6 Page 2 of 3 Competitive Historv 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.052 $ 0.01 $ 14.2% 1.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.132 0.05 57°/a 5.7% NG vs. Electric -46% -37% -37% -35% -31 % -46% -47% -40% -64% -65% -61 % � - csw:�ziz3i2oi� ' ' 'Attachment #6 _ . , _ _: : ; _ _. _ ' ': : I , Page 3 of 3 _ , . , , ._ , � , , ; _ . : _ _ ; _ _ _ tes __ , . Annual Average CGS Residential Ra � _- _ __ . __ : _ � _ __ _ Calender Year ! '; Fiscal Year � �_ _ Year I NG/Therm LP/Gallon *� Year ' NG/Therm � LP/Gallon *' � __ � � _ ____ i � * i } - . ,* 1996 �$ 0.915 I$ 1.239 � FY 96/97 �$ 1.019 ;$ 1.370 '` 1995 NA NA FY 95/96 $ 0.880 $ 1.199 � 1997 ,$ 1.049 $ 1.380 1 FY 97/98 ;$ 1.054 �$ 1.318 �" _ . ._ __ < . 1998 . � $ 1.032 $ 1.288 �'` � FY 98/99 , $ 1.052 � $ 1.269 , * 1999 i$ 1.073 I$ 1.311 , ' FY 99/00 ,$ 1.152 '$ 1.504 `. . __ . _ 2000 ,$ 1222 1$ 1.584 � � FY 00/01 ?$ 1.551 1$ 1.649 j _ _ __._ f __ � ' FY 01 /02 �$ 1.352 �$ 1.488 � ' _ � , . 2002 ,$ __ 1.342 $ 1.553 '', I FY 02/03 :$ 1.477 I$ 1 817 ' _ _ _- , _ � ,_ __ r $ 2003 $ 1.534 �$ 1.864 � FY 03/04 $ 1.603 f 1.913 � __ . i ' _ . _ _ I __ 2004 $ 1 652 $ 1.968 I FY 04/05 $ 1.803 �$ 2.162 C 2005 $ 1 925 �$ 2.278 � FY 05/06 :$ 2.080 I$ 2.480 -- - _ _ __ ._ _.. 2006 _ i$ 2.012 {$ 2.501 I_ i FY 06/07 ,$ 1.918 j$ 2 742 ; -- - : . _ . 2007 $ 1.893 �$ 2.869 t � FY 07/08 �$ 1.932 ,$ 3 183 _ 2008 $ 1.965 $ 3.186 j FY 08/09 $ 1.610 �$ 2 524 � _ 2009 '$ 1.464 $ 2.418 � J FY 09/10 `$ 1.437 $ 2.865 ,� .__ __ . 2010 $ 1.457 ;$ 3.438 1 I $ 1.475 $ 3.282 �, $ 2.946 . . _ , _ ' ' i � FY 10/11 2011 f $ 1.487 , . I _ T ? Average t $ 1.473 �f $ _ 2.088 � ', $ 1.462 '� $ 2.048 �_ . . , , , , __ � _ ;_ j ; � ', , ._ i_ _ _ � _ � ` ' � � ___ � __ � __ . _ _f � __ _ ' . i � ' Notes: ' ' � ' ' _, , , " Based on the Residential Metered Propane schedule which was closed for ', _ ___ _ __ _ _ _ __ . _ 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 gallons/year & is equal to Residential LP Will Call , 4 Clearwater Gas System �ive Greener r with �� APPLIANCE Fuel Use and Cost Comparison (Effective Rates for February 2012) _ ___ _ - __ _ _ _ ; ANNUAL ; NATURAL GAS ' PROPANE (LP) GAS ELECTRIC ! THERMS ' ' USED _.... ---- .. ._ __ _ __ . _ _._ _ __ _ _,__. ___. COOKING 45 $ 68.85 $187.20 $174.60 i WATER HEATING ; ' � --__ __ _ _ __- - ------- -----_. . _ .. _ _ -Gas Tank Style/Gas Tankless 170 / 100 $260.10 / $153.00 ' $707.20/$416. 00 $659.60 ; vs. Electric Tank Style � ' ________.. ___.^____.___._.. �_ __.._ ... ____ . __ _.._ _. . _ _._ __- - -.__ _ _ . ...__ _ _ ..__ ___ ' HEATING 150 $229.50 ; $624.00 � $582 00 ' --_ _._ _ -------- -__ ___ _ __ . ____.______�__ .___.. -- __ ; CLOTHES DRYING 50 $ 76 50 $208.00 $194.00 � ___ _._.. ________._ ___-- -. _ . __ _ . ____ _ ___ _ _ _ _ _____. _ . __ _ . __ TOTAL APPLIANCE $634.95/ $527.85 - $1,726.40/ ! $1,610.20 � USAGE — with tank/tankless � � � $1,435.20* � � __.._____.._ .------__ _ .___ _------, . _ __ _-.-----..____ __ _ _ _. { GAS SAVINGS VS. ELECTRICITY 61%u / 67% I1%oX �� *when usin tank[ess- LP �� : _ S �� ___.____ _._ _.._ _ _____ ---._. __. _ . _ _ � OUTDOOR RECREATION: _________�_.__. ___ ___._. _. ___ _ __ _ . _ _ _ __ _. __ _ • POOL HEATING* 375 $573.75 � $1,560.00 $1,455.00 ____ _..______ ________ _ _n_._ __._. _----. __ -- -- - ------ -_ _ _._. SPA/HOT TUB HEAT* 175 $267.75 $ 728.00 $ 679.00 ' ---- _ _ _ . _ . � *varies accordmg to pool stze, weather conditions, and temperature maintained _ _ __, ___ . All other figures are_annual average projections based upon_the followin� _ ...__.__.... .___........._. _._... _._ .._.... ..__.—_ ___......._.�_ b_.. . .....__. . . ..... . . . _... . ' 1. 1 therm = 100,000 BTUs of energy ' --__. . __ ___ �_ 2. Natural Gas $1.53 per therm _ _ _ _. _ _ _ 3. LP Gas per gallon (BRLP3) $3.81 per gallon or $4.16 per therm ' 4. Progress Energy per KWH $0.13226 Per KWH or $3.88 per therm (Based on>1000 KWH rate) _ _ _ _ _ _. _ _ _ . 1. Notes: The above analysis is based on February 2012 residential energy and fuel charges and does not include applicable taxes or franchise fees. 2. Current monthly customer charges are: Progress Energy $8.76, Peoples Gas $12.00-$20.00 (varies by rate class), Clearwater Gas System $10.00 and ' $18.00 in Central Pasco. L.P. customers are billed annually, $75-$210 (non-refundable) depending on program. 711 Maple Street • Clearwater, FL 33755 •(727) 562-4980 www.clearwatergas.com