The URL can be used to link to this page

GAS ADJUSTMENTS EFFECTIVE DECEMBER 1, 2011�� f'::: T0: FROM: COPIES: SUBJECT: DATE: CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet �+�� t.,t :,�r,; S'.g ,,i „�'. 9 � William B. Horne II, City Manager Chuck Warrington, Managing Director �� Rod Irwin, Assistant City Manager; Rosemarie Call, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. AccountandCGS; Laura Damico, Sr. Accountant/CCS; Lynne Priester, Cust. Serv. Coord./CCS GAS ADJUSTMENTS EFFECTIVE DECEMBER 1, 2011 November 23, 2011 Gas Supply Prices have stabilized somewhat for the winter; therefore, we do not need to implement our planned increase this month. 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) nor our Regulatory Imposition Adjustment (RIA) for December. However, this is the time of year when we reassess our Usage & Inflation Adjustment (UTA). Attachment #4 shows this analysis. Inflation was 5.056% from September 2009 — 2011. And, usage per customer was stable for Residential but was down for Commercial. Therefore, we are recommending that we implement a 6¢/therm or gallon UTA for Residential customers and a 8¢/therm or gallon UTA for Commercial and Industrial standard rate customers. The net effect of these recommended changes for December is an increase in our typical Residential Natural Gas customer's rate of 4¢/therm (+2.6%) and an increase in our typical Residential LP customer's rate of 4¢/gallon (+1.1%). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after December 1, 2011: 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 ......... Energy Conservation Adjustment (ECA) .................... Regulatory Imposition Adjustment (EIA) ..................... .. $0.87 per therm (no change) $0.79 per therm (no change) .... $2.46 per gallon (no change) .... $2.16 per gallon (no change) $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 ar gallon (up 4¢/therm) - Commercial .........$0.08 per therm or gallon (up 3¢/therm) William B. Horne II, City Manager November 23, 2011 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru September. 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. Attachment #4 shows our calculation of our Usage & Inflation Adjustment (L1IA) clause. Attachments #5 and #6 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectiveiy. Attachment #7, 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 Pro�ress Ener�v Florida's residential rates. That's an average annual increase of 0.6%/vear for natural �as vs. 5.3%/vear for electric --- a remarkable difference! I should point out even with this month's increase, the overall effect is that our typical Residential customer rates are still approximatelv 59% lower than electric for Natural Gas. This is a very attractive competitive position vs. electric rates. 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 December lst billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: G��,txx.c.�-�. �- i�'—.L William B. Horne II, City Manager U:WIy DocumentsVNSOFFICE\WINWORD\GASRATES\Gas Adjustments for October 2011.doc CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 ------------ -- ------- - -- --- - -- --- - _ ____ ----- ---- - - -- - • -- --- ------ - Budget ;_ Reservation _Commodity_ ___ Interest Cost Center Total NG Fuel �__Total_NG PGA _ _ _ - - - -- --- - --- _ ___ _ ------ - -- ------- ---- - - -- --- Month ' Charges Charges __ Expense Expenses _ Expenses Billed Page 1 of 4 ------- -__ _ Cumulative ' NG PGA -- - - . -- - __ �TD Overage Rate/Therm �Shortage►„ .__ Firm/Contr_ PrOct 10ar $ 3,214,594.56' - 854,995.46 $ 52,033.70 1 $--- 4,121,623.72 $ 1,233,004.63 I�------ $- 51,52629 - --- � - ---- _ - - - --- � - ------- ---- - - - -- --- --- J ' $ (2,888,619.09)' $ _ (2,837,092 80), 0.87/0.79 --' - - Nov-10 , $ 211,726.13 -- - - - - . _ 823,199.40 $ 14,185.46T$ --- 47,215.65 ! $ 1,096,326.64 ' --1,346,532.03 ' $ 250,205.39 ', $ _ (2,586,88741)'T-_0 87/0.79 -- - - ---------�------ --- -- r- - - - -- ------ -- _. _- __------<- _ 1-$ 75 857 24 . __`_ ._ -___` _-- 1,117,270.13 ' $ - 10,908 36 : $ _ ___49,440 92 $ 1,970,087.00 '__2,240,697.13 $ 2�70,610.83 I $__(1,981,061 _48) 0.87/0.79 Dec 10 ' _ _ _ _ __ _ _ Jan 11 195 081 12 I 1,714,656.60 . � 0.92/0.84 Feb-11 ! $ 193,849.51 ', 1,168,251.02 � $ 9,555.31 r$ 42,087.45� �; $ 1,413,743.29 ;_ 1,879,062.93 ' $ 465,319.64 ; $ _ (1,445,741.84) 0.89/0.81 Mar-11 � $ 218,053.83 i ------------- --- 924,788.51 �' $ 7,228.71 j $ ' 41,379.15�; I $ _ 1,191,450.20 ', - 1,722,289.49 I $ 530,839.29�, $ _ (914,902.551i 0.89/0.81 Apr-11 ! $ 131.411.26 � � 1,114,428.22 ' $ 4,574.51 � $ 50,623.95 '. J $ 1,301,037.94 i 1,548,370.44 � $ 247,332.50 : $ (667,570.05) 0.82/0.74 Jun-11 I $ 89,954.19 i_ _ Jul-11 ! $ 96,275.54 ''. -___- --Aug-11 ,`$_ 91,405.24 Y --_ - - -- - - -a-- Sep-11 $ 93 831.41 - �-- _ ---- Per13 : $ - F $ Total YTD'i $ 4,409 738.02 ', $ _ (1); Includes Annual Admin chg of ; + FY 09/10 PGA write off of $2f _ -- - -- - ------ (2),FGT Rate Case Refund = - ------- -+--- --- Net RC =' $ 1.620 334.84 Month i Prior Year. Oct-10 ' Nov 10 � Dec 10 � Jan 11 _ Feb-11 _Mar 11 _ Aor-11 Jun-11 Jul-11 Aug-11 Sep-11 --P13 Total YT Sold 32 634.7 ! $ ___ -- -- 41 735.5 $ __50 401.2 ' $ _ - - ---35,247.5 � $ 38,198.6 ',� $ 33,652.1 $ i�il 04+WNA$0= 831,760.97 ' $ 3,337.85 $ 38,566.24 ! 2 : $ 671,36305 1,213,781.86 '�$ 542,418.81 ' $ _(125,151.24) 0.81/OJ3 761,703.08 $ _-- - '''' $ 37,925.36� $ 895,903.98 II 1,123 970.89 I$ 228,066.91 J$--525,323.47Y 0 81/0.73 653,452.42_ $ 625.76 $ 39,498.66 t_�$ _ 783,531.03 1,205 93_8.82 $ 422,407.79 $_297,256.56 �, --- --- _ _ 0.81 /0.73 833,493.97 I $ __ - _'�__ 37,986.03 i ; $ 962,885.24 ; __ 1,116,677.30 I $ 153,792.06 ! $ _ 679,115.53 0.78/0.70 - F � �- ' ' T _� $ ___ 766,989 70 ; 0.78/OJO --- �--- ' - -- _ _ _ 893,024.15 '$ $ 56,624.87 � I$ 1,043,480.43 1 131 354.60 I$ 87,874.17 ' ' S $ 749,668.60 , I $ (749,668.60)! $ ___ 17,32L09 _ _ 691,023.93 , $ 63,350.39 $ _-539,719.32 ;`-- _$ -__17,453,500.27 i $_ 17,419,295.07 ', $_ (34,205.20) _-_--- - ' - - -- $1,040,810 + Dividend $1,300,720, ' ' ! - ----- - - ---- ---- �_..- ---- - -- t-- ---- .- . ___ _ ------ $ 3,086,460.04 ' - - . - - ---�- -- - -- --- --_._' _ : _ _ _ _- -- - _- _ _-- __ - -- _ _- - - - - _ �� .__�297�056_86).-- -- -_ -- -- - -- -- -=- -1 - --- - - -- -- ___(5) Commodity adjustment from FYE transfer of ECA Coilected in PGA @ 1!2 of the ECA Rate ---- -- _-------- - -- - -- --- --- -- --- --- --- __ -- I NG Proportion = 97.9% x Total ECA Transfer = $ 749,668.60 - ----..._---- - .____ _- - _ _-- --- - -_ .__ _. _-- �+ OPEB Liabilit Accrued sick 8 vacation TBD _ _--- - - ------ - -'�----- y � - _- ! - -------- •- --- - -_ --- ----- i ------- - - --- i- - --- Nfonthl-_ �- - �mulative P PGA Y I ry --� �-- ' g - ---- --- --- --- Monthl �� Interest ' Commodi ; Totai LP Fuel Total LP PGA Overa e YTD Overage _ Therm/GaL -- - +---- ' '- - - WACOG __ ___ __ Ex�ense ' Charges Ex enses Billed __!__ Shorta e �Shortage) ._ _ _ - --- - -- ' - , -- _ p - ( 9 ) -, _-:._$ __ 12,382 31 -_- - ----- _--- --- - -- -- 1.41942 i ' $ _47,360.94� 1 $_ _ 257,809.93 ! $ _ 63,737.10 I $ (194,072.83)i_$_ (181,690 52) __ 1.73/1.90 -- -- - ---- -�: 49,452 34 50,360 79'� 62 008.50 I$ i 11,647J1 $ (170,042 81) __ 1.73/1.90 -- --- -- 1.62230 $ 850.21 ' - -- - --� . 4 �T 68,557 72 ; 79 308.70 �$ 10,750.98 $__(159,291.82) 1.73/1.90 ___ ___ _---- I $ -- 796.46�- - 86,570.61 l ---- --- _ 67,707 50 1.71763 87,367.07 108 116.53 $' 20,749.46�$ (138,542.37) 2.00/2.19 __ ----- -- -- -----T --- - �- ------ ---t---- ---- _ _ ---- - - -- --- -___ _- 1.67582 $ 692.71 59,068.47 ; 59,761.18 , 77,073.22 I$ 17,312.04 $ (121,230.32) 2.00/2.19 1.68222 $ 606.15 _--- 64,258 45� - --- 64,864 60 i _83,700.29_�$ _18,835.69 ' $ _ (102,394 63)!- .. _ - - - --- _ _ __ ___ _ _ _ _ _____ _. 2.00/2.19 -- -- 1.64195 ' $ 511.97 ' S5,255.07 ' 55,767.04 71,655.86 , $ 15_888.82 $ __ (86,505_81) 1.94/2.12 -- . _. ----� --- -- __--- • ---.. ___-_ -___ __-_ _ _ _---- 1.71220 $ 432.53 41,519.65 41,952.18 52,835.75 $ 10,883.57� $ (75,622.24) 2.00/2.19 31,261.2 ' $ 1.74541 $_-_ -- 378.11 54,563.61 ' 54,941.72 ' 68,379.39 $__- 13,437.67 ' $___-_(62,184.58). ___2.00/2.19 23 276 5_: $ __ _ _ - 1 78113 ; $-_ _ 310_92 .__ 41,458 47 __ _ 41,769.40__ -_. 50,941.11__$_-- -9,171 71 I $ _ _ (53,012.86)! 2.00/2.19 -- - ---- 22,024.4 ', $__ _ 1.79413 ', $ 265.06 , 39,514 64 _ _ 39,779.70 i 50,149.71 $ 10,370.01 $ _ _ (42,642.85) 2.10/2.30 --•-- ----------------- - --._.._ _ --- --- -- -- -----, 27,129.9 ! $ 1.80121 I $ 213.21 48,866.65 49,079.86 � 63,129.27 , $ 14,049.41 $ (28,59344)� _2.10/2.30 , -- - -- - --- � ----- --- ----- , ------- ; ------- --4-� --- - 16�631.75 `-- ---- - $ _�16,631.75)' $ i45,225.19)' _ .3 CCS Chg, Admin 8� Dividend FY 09/10 Write off PGA 8 W Fuel - ---- --_-- Donations to events 1.66743 LP PGA Event fuel cost ___ _____ 9. meter __ _- -- ------ _ ---- - --- __ _ ar a onzation oss ue to ma unctionin -- - -- - ------- -------- -- -- Suburban Software Systems __ _ ___-- --- -- __ _: ___ -- ---- _ _--- ----... __..____ _ - Depreciation of LP tanks __ . _ - - -- _ . _ -- _ __ . _ LP Holdi�g Tank Restoration , _.__ ! $ 655,596.39 __ i $ 888,642.93 i $ 831,035.43 $ , 57,( 607.50); __ ____ __ � __ _ - ------ - ---- ; , , �-_ '� __ - . ----- ^ - --- j $ 126,110.00 1 : - - -- --- -- -- -- -- -- - --- - --- -- --- � � ,--- -- �--- ---- 1 --- -- - $ - - 15,000.00 '�-�--�------- ; ---_ � f_ +- -- - -+------ --- - - - - - ---� ---- -- _ . _ � $ 25,946.43_�1 __; -- - - --- -- --- ---- -- -- -- - � r$ 3,200.03 , 1�- (4), Adjustment from FYE transfer of ECA in PGA � 1/2 of the ECA Rate -- - -- -- -- -�--- - - -- --- -- ,_ _.. .$ __ _4,851 18 ._ 1_ � LP Proportion = 2.1 % x Total ECA Transfer = $ 16 080.74 _ �- - - --- - - - -- - - _- 1 + Additional Projected Costs Needed $ 551.01 . _ - - ---- --- -- -- - . _._ __ _ _ $ 34,414 23 1 . _ _ -_ __- - _. -.__ . _ _ � 1� Proj. for Year � Additional Needed . _.-- -----------------__ -- . .__ - _ _ _ _ $ 210,448.99 1 $ 211,000.00 $ 551.01 CLEARWATER GAS SYSTEM Page 2 of 4 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 ENERGY CONSERVATION ADJUSTMENT (ECA Z_...._- - _ _ -- ------ _--- ----- --- _-------- ------- -_.. _---------- - --- - -•-- -- - - - - ` __ __ .___ __ _ _ __ _ _ Monthl r�_ Cumulative ECA _- ---- -- - - - �-- �--- - -•--- --- — - - Budget_ _ Cost Center Interest Total ECA Total ECA Overage YTD Overage ,_ NG/Therm ; --r- --- - --- --- - - - ------ ' -----__ �— � ----- _ Month Expenses ! Notes/Exceptional Items __ _ __ i Expense ; Expenses Billed I (Shortage�_ �__ (Shorta��_ i_ LP/Gal. ---_ _ - _ _ Prior Year, ' , ---- _ $ _ OCt-10 $ 476,228.43 PromoS30,927,Adv $845. Em lo Costs570,342 � $ - _ __ ___ _ 1 � $ 476,228.43 ' $ 90,941.19 --_- -.,-- `-, -� —P Y - �-�---.---_ ' $ (385,287.2� $ _ (385,287.24) - _0 10/0.10 -- Nov-10 ', 92,923.28 iPromoffi31,868,Adv $8,821, Employ Costs$52,234 I$ 1,926.44 ' 94,849.72 I 96,056.46 !$ 1,206.74 $__ �384,080.50) 0 10/0.10 Dec-10 i$ 96,505.54 ipromoS41,511,Adv 51,529, Employ CostsS53,4s6 ;$ 1,920.40 '� 98,425.94 ' 136,544.02 $ 38,118.08 '$ (345,962.42) I 0 10/0.10 - -- - -- - Jan-11 I$ 154,706.38;PromoS94,138,AdvS255,EmployCostsS60,313 I$ 1,729.81 I 156,436.19 180,846.64 ;$ 24,410.45 '$ (321,551.97)', 0.10/0.10 •-- - - -- -- - - - - — ___ _ _ 192,024.24 ! $__ 106,641.76 ; $ 214,910.21 0.13/0,13 �— ---- ' --- P Y — --- —___, ----- — ----�-- --� Feb 11 $ 83,774.72 PromoS27,328,Adv So, Emplo CostsS56,447 I$ 1,607.76 ' 85,382.48 ' Mar-11 ' $ 101 ,633.03 Promo$42,838,Adv $990, Em lo CostsS57,805 � $ 1,074.55 ''- ____ _ __ _ � _ _ 102,707.58 ' _ 175,303.02 ! $ 72,595.44 ' $ _ (142,314.77); 0.13/0.13 - --- - - -- — - - - - -_ - - -- _Aef 11 $ _ 89,292.43_.PromoS27,556,Adv 5273, Employ CostsS61,463 _ $ __711.57 _ _ _ ;_ _ _ 90,004.00 '_ 126,715.66 ' $ 36,711.66�$ __(105,603.12) 0.10/0,10 May-11 _ $ 103,872.51 ',PromoS47,867,AdvS623,EmployCostsS55,383 $ _ 528.02 _ _ _ ___ _ 104,400.53 116,200.87 $ 11,800.34 , $ ___ (93,802_77) 0.12/0,12 _ ----- -- - ----- ----- -- --- ------------ ------ -, Jun-11 $ 85,872.18 'Promo$41,432,Adv $650, Employ Costs$43,790 $ 469.01 86,341 19 111,054.96 ; $ 24,713.77 ' $ _ (69,089.00) _0.12/0.12 _ _ - -- - - - ------- - ---- _-- - --- ---------- - ------ --- --_ _ -- --- --- - - - -----�------- --� Jul-11 $ 264,904.13 PromoS30,890,Adv $O, Employ Costs$43,103 $ 345.45 2 265,249.58 102,295.42 i$ (162,954.16) $ (232,043.16) _ 0.12/0.12 _ - --- - - - -- -- ---- - ---- - - _ _ - -- _ _ ____---- - - - - --- - --.. - -- ---- - - - Aug 11 _ $ 108,878.43 ,PromoS60,785 Adv $o_Empioy Costs$48,os3 _ $ 1,160.22� _ _ _ 110,038.65 _ _ _ 100,828.74 I $__ _ (9,209.91) $_ _ (241,253.07) __ _0.12/0.12 ----- - --- --- _ _-- Sep 11 _, $_ 82,823.43 Promo$36,246,Adv $O, Empioy Costs$46,577 $ 1,206.27 84,029.70 109,533.42 '$ 25,503.72 $ (215 749.34) _ 0.12/0.12 __ . - ---�---------- -- ------------- --_------ �----------- ---------- ---- ---- --__ _-- __. P13 $ 550,000.00 Jndudes $550K for NGV funding 550,000.00 765,749.34 $ 215,749.34 $ - -- -- - --- - _ _- --- - --- Total YTD $ 2,291,414.49 $ 12,679.49 $ 2,304,093.98_ $_2,304,093.98 $ _ _ _ - - - - __ ---- -- _-- ---- - -----_ _ _- -- -- _--�------ - -- , - - - --- --_ - ----- ----- - 1------- ---'------ - ' - ---- - -- ---� - - ---- _ _ --- _ _ -- __(1)'Indudes Annual Admin Chg of $47,080 + CCS chg of $55,300 + Dividend of $69,090 = __ i(6) ` Transfer of ECA Collected in PGA @ 1/2 of the ECA Rate (up to ECA Annual Shortfall) + FY 09/10 Write off of $2,643.99 +$200,000 SNEP = $ 374,113.99 Note: Maximum amount which can be transferred = $ 769,172.32 - -- - -- ------ -- ---- - --- -- (2) FY10 SO write off adjustment = , 93,406.67 _ -- -------- -- ---- -- -- -- -�---- ----- - - -- --- -_ - -- _�FY11 SO write off adjustment = _�_ 97,504.35 'I _____. ___ , ____ ______ _ __ _ --- - - - � - ---- -_ -.. --- ------ _ _ _ ____ Net CCE _ ' 1 ____ _ _ _ _- -- - -- (EIA) _ {ORA) __ - _ _ _ - _ _-- -_ ___ Budget Environmental Regulatory -- _ _. Month Expenses Notes/Exceptionalltems Expenses -- ---__ -- _ _ _ _ Prior Year _- - _ _ Oct-10 $ 23,385.97 . . - 0 $ _ _ -- - _ _ __ -_ Nov-10 $ ° 3,306.00 -0 $ ,, - ---- - - _ -- - - __ _ _ _ ------- -- - Dec-10 - $ . ;423,438.00 ` 0 $ Jan-11 $ � �t'i8�235:18)---- --- --- --- -- - - 0 $ Feb-11 $ �� 49'� � `---- --- ------ ,,�,�� 0 $ Mar-11 $ ,_ .FC1$:�=48;96)` -- - - ��"��,_� 0 $ $ Jun-11 Jul-11 --- - - -- __ - - ------- ---- - - -- - --- - - --- - -- Interest Total EIA Total RIA Overage _ _ YTD Overage NG/Therm - - � -- - ___ ____ ._ _ --- - -- _ _ ?xpense _ Expenses _ _ Billed _ _ �Shortage) _ (Shortage) _ LP/Gal. $ _ $ 82,519.09 _ -- - - -- .- -- - -- - -1 $ _ 23,385.97 - 18,238.59 $ (5,147.38) $-- - 77,371.71 0.02/0.02 - - __ ---- - - _ _ - 3,306.00 19,210.43 j$ 15,904.43 $ 93,276.14 ', 0.02/0.02 -------------,---- --- -----------_._- - ..__ _ ---- _ --- 2---_ 423,438.00�- _ 27,308.20 ! $ (396,129.80)' $_- (302,853.66)--__0.02/0.02 1,514.27 , (16,720.91)' 36,168.15 $ 52,889.06' $ _(249,964.�, 0.02/0.02 1,24982 �_ _ 2,740.82 ! 44,276.28� $ 41,535.46 . $__ (208,429.14) 0.03/0.03 __ 1,042 15 � �_ _(17,206.81): 40,451.44 ' $ _ 57,658.25.: $__(150,770.89�, 0.03/0.03 753.85 2,839.25 50,560.14 I$ 47,720.89 $ (103,050.00) 0.04/0.04 _ 515.25 _ 11,005.19 I __ 19,454.18 :$ ___ 8,448.99 I$ (94,601.01) 0.02/0.02 - - --- - - - 473.01 ` (10,621.26)i 18,509.53 ' $ 29,130.79 I $ _ __ (65,470_22)._ 0.02/0.02 -i- -- - -- �- --- - _ _ _ 327.35 i _ (8,378.33) _ _ 17,048.78 $ 25,427.11 $ _ _ (40,043.11)! 0 02/0.02 - -- --- -- - - - - Aug-11 ;-� t �;.{g.1x00 ,- --_ -- : ��' - ' $ 200 22 i 1,691.22 ' 16,794.99 $ 15,103.77 $ (24,939.33) _- 0 02/0.02 — �`° �----- � --� --�- -- -- � - - � --- --- _Sep-11 �$ (24;�71:94}!:_ ;��i$i'.01 : $_ 124.70 (23,450_23)--_ 18,255.67 I. $ 41,705.90 $ _--_ 16,766.57 . 0.02/0.02 ---------.. _ - --- ---- x - ------ -- - ---- -+- - ---- - P13 Y,�� "'� :" ' _ , $ ------r$ 16�766.57 - — -- ' -- - ------ -- _ _ _ _----- -; _ - - "^' '��; $ ! $ - ' $ - 16,766.57 ' Total YTD $ 383,497:68 - -- --- - - - - --- - $ 2,330.61 $ 6,200.61 392,028.90 326,276.38 . $ - (65,752.52) _ ----- _ - -- --- _ _ --__ _ -- -- - .. __ __ - - -_.-- _ - - __ - - ____ _ _ _ _ __ - . _ _ _ _ __ --_ (1) EIA Includes Annual Admin Charges of $10,330 __._ _ . _ --- - . -- _ _. _ _ -- - - --- ... ____. - _ _ _ _ ___ -- - - ---- - _ + FY 09/10 Write off of $316.50 = $ 10,646.50 _ _ __ ___ --- --- __ ___ _ . __------- _ _ _ . _ . __ . _ _�_ __. - ___ • - _ _ _ (2) EIA Includes Arcadis PO for remediation costs for MGP = $ 421,440.00 i -- -: _ _---- ------ ,-------- - -- ----------Net CCE _ '~$ (46.258.211 i _._----- --- '-- -- -------- ---- -...- ---- - --- - -- --- - � ------ ---_ _ __ _ Commercial _ Budget_:--_-- - _ Month ----� _ _ -- ---- -- Beg. Bal. -- ----�----- Oct-10 - ------ - -- Nov-10 ; -- ---- __ - _ Dec 10 ' - -- ---- - - ._ __ Jan-11 -- - _ ___ - -- _ Feb 11 --_ __- _ _ Mar-11 ---. _. _- --- --- Apr-11 -- ---- --- May-11 � Jun-11 _ - -- - - _ J u1-11 Aug-11 -- -- ---- Sep-11 � - -- -_ ----- Per 13 ---- -- ___ __ __ __-- Total YTD CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 Page 3 of 4 - - - ------- - --�-- - ----- ----- - -- --- - - - ENT UTA --- --- - ( ) - --...-- ----- --_ ___ - --_� --- -- -- -- - ___ _._- -_---_- -__- __ Monthl��_ Cumulative UTA _ ---� ---- --- ---- _ ---------- - - _ _-- --- - -- -�--- - - - - --- ___ _ _ Interest Overage __ _ YTD Overage _ _ NGITherm LP Gallons Expense Rate/Gallon J NG Therms , Rate/Therm � (Shortage) __ (Shortage) __LPIGaI _ --- -_ ___--- ----- -- - - -- ---- -- -- - - --- __ _- ----- - -- _ $ -__�348,15974) - _ - -- 5,979.4 $ - _ - .-- 689,076.70 ' . - -- -- $ -�_ -'� $ (348,159.74) _0_00/0 00 -- - - --- ---- �- --- --- --- - - ------ ------ - -- - - 6,667.5 ; $ _--- - _ -- 711,822.20 '; - I $ _-__- $ -- (348,159_74 -_0.00/0.00 -__ _ - - ----- ) - - -- _ - -- --- �- 7,985.8 $ - - 930,224.90 i - -- ----- __ _------- Q _ ', $ 1.41 ' $ �48,158.33)I_ OAO/0.00 - - -T-- ----------- - - 9,583.3 ', $ 1,740.79 I 0.03µ 1,101,753.80 ' 0.03 ' 33,031.50 ,$_ (315,126.83) 0.03/0.03 _ _ 8,477.7 - -- - __---___.__------ - ___-- - -- _ $ 1,575.63 ' 0.05 ; 967,797.20 �_ 0.05 ; $ 48,569.85 ,' $ __ (266,556.98) 0.05/0.05 - --- --- - - 7,506.4 $ � 1,332J8 0.05 ' 944,889.30 , 0.05 $ 47,584J8 '; $ _ (218,972.20)'_ _ 0.05/0.05 --- --- - _ -------- � ------ ; --- _^ - -�r - � - �- - - 7,104.2 i$ 1.094.86 � 0.05 ; i 928,791.00 � 0.05 I$ 46,768.59 $ 172,203.61) _ 0:05/0.05 --- -- --- ----- - -1--- __ __ _ 6,099.2 '� $ 861.02 � 0.05 ' _ 726,200.40 OA5 , $ 36,593.09 ' $ _ (135,610.52) I 0.05/0.05 _ --- -- 6,807.4 '' $ 678.05 ' 0.05 � 699,134.40 0.05 $ 35,270.65 $ (100,339.87)' 0 05/0.05 � 5,51 $ 336.18 i 0.05 ', 651,167.70 I' 0.05 'I $ 33,102.92 '$___(67,236.95L 0.05/0 05 _ _ ____ ___ __ 4,380.0 __ -+---- �---I- -+-- - ___ _ _ , � 32,823.81 $' (34,413.14)' 0 05/0 05 _ _ _ ___ 5,254.5 ', $ __ 172.07�- 0.05 __ 707,574.50 _ _ 0.05 ' $ 35,630.26 ' $_ __ 1,217.12 __ 0 05/0.05 - , - - -- $ 1,217.12 � - -_-- - - --- --- - - -- --___------ - - --- _ . _ .. 81,362.7 8,293.09 ' 9,716,188.00 ! $ 349,376.86 -----� -- - � - -__ -----•- ---- - - -------- -- Monthly _._ Cumulative_ UTA - ---- -- - --- ------ -- �- - -- ---- -- - - - - - Budget __ Interest _____ __� Overage_ _ YTD Overage ' NG/Therm _- � _ _------------- -----------..--- Month ' ' LP Gallons Expense Rate/Gallon � NG Therms ~ Rate/Therm (Shortage) _(Shortag��_ LP/Gal -- ---------•--- ----- _ -�- + - - -- ----------- -- - - - Beg. BaL ' $ __ -(48,628.37)-_- -�-------- - ---- ----- .. --- -- �- -- - --_ - - - -- - >---- - ---- - - - Oct-10 ' _27,387.0 $ - - , 188,329.90 , - ! $ --_ " $_ _--(48,628.37);_ 0.00/0.00 - ----- ---}-- ------ ------------ - -- --- --- ----- - --�---.-.-- Nov-10 ' _ _ - -- - 25,967.2 $ - ; - ' ! 217,344.30 - ! $ - $ _____-(48,628.37) 0 00/0.00 - ------------ ---- _ _ ` ----- _ �- . - - _---__ - ------- - ---_ Deo-10 _ __. �__. _ . -- - - 33,749.7 $ 394,504.90 ' $ $ - -- (48,628.37)_ 0 00/0.00 _ Jan=11 -- - _--- - - __- - 40,817.9 $ 243.14 0.02 657,516.60 ._ 0.02 ! $ _-13,838.39 $ - - (35,033.12).__-0 02/0.02 ---- Feb-11 , 26,769.8 $ 175.17 0.02 � � 477,935.30 !, 0.02 !$ 10,101.88 $ �106.41), 0 02/0 02 -- - - - --- -- , -- t------ , -- __ _ Mar-11 � ' 30,692.2 '$ 125.53 0.02 I 366,0 0 0.02 $ 7,937.60 $ (17,294.34)r 0 02/OA2 ----- --- - - - - -- -- -- - - -- Apr-11 ._ 26,547.9 I$_ 86.47 ' 0.02 ' 303,719.80 0.02 ;$ 6,606.67 '$ (10,774.14)' 0 02/OA2 : _ _- ` - - -- ; --�---- - 0.02 -- ---- - -- --- - -- _ _ _ OA2 $ -- 4,750.69 I $ (6,077.32 0 02/0 02 ;-- _ __. ---- �---- Ma 11 _ '- -- - - - - - 17,895.1 $ --- 53.87 ` - -- 0.02 --- - `--- ^ 219,279 70 ? $ 4,408.43 $ (1,699.28) 0 02/0 02 Jun 11 . 24,366.9 $_ 30.39 0.02 195,715 70 ` _ � _�____ Jul 11 17,913.9 '$ 8.50 ' 0.02 172,537 20 0.02 :$ 3,811.37 $ 2,103.60 0.02/0.02 - --- -- -.._ _ _ _. Aug 11 16,482.7 $ - 0.02 167,427 40 0 02 !$ 3,670.40 $ 5,774.00 0 02/0.02 _._ _ _ _ - - _ - - - -- _ _ .. _- -. -- -- - -- --t- -- � -- - - Sep 11 _ 21,802.0 $ - 0.02 _ 178,128 00 0 02 �$ 4,005.62 $ __ 9,779.62 0 02/0.02 -- --- -___ - _ _ . _.. ___ _ _ -- - -- --- - - -- -- - - -- --� -- - Per 13 - - - - - $ 9,779.62 _--- ---- --- . - --- ------- - - ------ �-- - --_ _ Total YTD 310 392.3 723.06 3,538,489 60 ' $ 59,131.05 _ ------------------------ � --- _. . Budget_,_ __- -___ -- _ Month --- -- - -- _. Prior Year' - --- - --- -- --- Oct-10 ; - - � -- -_ _ - ---- Nov-10 _ ._.._.._:- -- -_ ------- __ . Dec-10 - -- - _ __ Jan-11 Feb-11 - -- ` --- Mar-11� � Aor-11 - --------- Jun-11 Jul-11 Per 13 Total YTD CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 ; , , Page 4 of 4 ENT CLAUSES IBoth PGAs + ECA + RIA+UTA�_ �-- -- � - - - -- -- — - -- , _. _ ..- ----- -- t -- - -- -- --- --T— -- -- ; _ ' Monthly � Cumulative � Totai Resl - ---- - -_. --- � -- t_..- --------- -- ---- --- , Total All ' Total Recovery_ __ Overage__ YTD Overage . NGIThm (Firm) . _ _ _ _ ____ _-- --- --- -- ----- Expenses , Billed _ _� (Shortage)__ . (Shortage) , _ LP/Gal (Resl) _ _ __ _ . _ __ _ - -- - __ _ - , $---- � $__ ..__i250�360.42) � --- -- -__ --- -- _ __----- _ _ $ ___ _ 4 879,048 05 ',' $_- 1,405,921.51 ! $ (3,473,126.54): $_ (3 723,486.96);. _ 0.99/2.02 - _ _ . _ _ . --- --- - - -- _ , $ 1 244,843 15 '$ 1,523 807.42 !$ 278,964.27 $ (3,444,522.69) 0.99/2.02 --- - - . _ _ _ - - - —�-- - - _ _$-_-_ 1,842,820.81 ', $ 1,900,777.28 : $ -- 57,956.47 $ _-(3,386,56621)_ 0.99/2.02 --- - -- -- - — ; $ 2,199,153 28 $ 2,612,698.34 � $ 413,545.06 $ _(2,973,021.16) 1.06/2.33 ---- -- - - -- $ 1,563,378.57 � $ 2,251,108.40 ! $ 687,729.83 � $ (2,285,291.32) 1.07/2.37 ---- - -- --- - -�I $ 1,343,273.88 �I $ 2,077,266.62 I $ 733,992.74 '_$ (1,551,298.59)', 1.07/2.37 ' __ �I $ 1,450,829.57 � $ 1,850,677.36 $ 399,847.79 I $ _ (1,151,450.80)_ 0.98/2.28 ', __ __ _ '• $ 829,635.84 i $ 1,443,616.44 $ 613,980.60 � $ (537,470.20j 0.97/2.35 � i$__914,901.12 �$ 1,443,561.78 i$ 528,660.66 $ (8,809 53). 0.97/2.35 ----- ;--_. -- -- -- ___ ~$ 1,195,054.8 $ 1,331,170.49 �$ 136,115.67 $_ 127,306.141 0.97/2.35 __ ' ____ I$ 1,114,730.99' $ 1,320,944.95 �$ 206,213.96 I$ _ 333,520.10 0.94/2.46 $ 1,153,311 82 $ 1,361,908.84 j$ 208,597.02 $ 542,11712 0.94/2.46 —..---- -- — ._ _ - -- - — -� - ---- --__ ---- ---__ . _ _ __ _i $ 1,316,300.35 $ 765,749.34 � (550,551.01) $ (8,433.89) _ ___ 21,047,282.24 ' 21,289,208.77 ; $ 241,926.53 ' --- •--_ ----- _ ___ . __ , _ _ ___ _ __ _ _ __ __ __- -- _ ._ _- ' --- Last Uodated 10/28/2011 � Tr,��T �z- CGS Natural Gas Cost Actual/Projections FY12 as of 11/5I2011 Total 2,641,833 570,393 266,100 1,078,312 (423,340) ($151,884.40) 2,133,914 158,002 2,089,000 100.00% 102.6% $6.02 Total $1,240,076.41 $409,827.37 $10,351.29 $36,110.44 $3,243.07 $11,396,680.32 $ (67,658.39) $324,427.97 $t25,797.00 83.4% 70.0% $12,837,075.50 Total Projecled DTH WACOG Total Reservation Total Commodit Cost Purchased 1st6Months $ 1,034,904.44 3 6,453,012.92 57,384,057.47 1,220,314 E6.051 2nd 6 Months $ 625 350.63 $ 4 943 667.40 $5 453 016.03 913 600 55.969 TOTAL $1,660,255.08 $ 11,396,680.32 $12,837,075.50 2,133,914 $6.02 Propane Weighted Average Cost of Gas (WACOG) ��/!/�" % �' � 11/5/2011 FY 2011-12 Delivered Delivered Delivered Month CGS Cost Gallons Cost Oct-11 � Nov-11 $ 1.80 Dec-11 $ 1.90 Jan-12 $ 1.95 Feb-12 $ 1.85 Mar-12'� $ 1.80 Apr-12 $ 1.75 May-12 $ 1,75 Jun-12 $ 1.75 J u1-12 $ 1.75 Aug-12 $ 1.75 Sep-12 $ 1.75 Projections Cost of Invento 40,000 $ 72,000.00 $ 50,000 $ 95,000.00 $ Total EOM Tank ' EOM Tank Projected Gallons Gallons Cost WACOG 113,870.17 63,172 136,768.50 73,172 50,000 $ 97,500.00 $ 140,811.64 73,172 50,000 $ 92,500.00 $ 137,092.02 73,172 40,000 $ 72,000.00 $ 115,414.10 63,172 ' . 30,000 $ 52,500.00 $ 94,834.82 53,172 20,000 $ 35,000.00 $ 76,328.38 43,172 20,000 $ 35,000.00 $ 75,968.25 43,172 20,000 $ 35,000.00 $ 75,774.95 43,172 30,000 $ 52,500.00 $ 93,171.20 53,172 30,000 $ 52,500.00 $ 93,103.38 53,172 23,172 $ 41,870.17 23,172 $ 41,768.50 23,172 $ 43,311.64 23,172 $ 44,592.02 23,172 - $ 43,414.10 23,172 $ 42,334.82 _ _ 23,172 $ 41,328.38 _ 23,172 ' $ 40,968.25 - 23,172 ' $ 40,774.95 23,172 $ 40,671.20 23,172 $ 40,603.38 23,172 $ 40,573.83 1.81 1.80 1.87 1.92 1.87 1.83 1.78 1.77 1.76 1.76 1.75 1.75 csw:ii/zz/zoii A7'fACHMENT #4 CALCULATION OF USAGE & INFLATION ADIUSTMENT (UTA) FOR FY 2010/2011 For Billinss Be�in�ing December 1. 2011 Usaee Adiustment Calculations: 1. Residential Sin¢le-Familv Natural Gas Use/Customer: Average Number of Total FY 30/11 Therms Used FY 30/11 Customers Therm Usaee Per Customer 15,508 3,197,051 206.2 Threshhold for application of UTA per Rate Ordinance = Less Than 204 Therefore, no Residential Single Family Usage Adjustment is recommended Applicable FY 10/11 No�-Fuel Revenues = $ 4,125,197.43 2. Commercial (Non-Interruptiblel Natural Gas Use/Customer: Average Number of Total FY 10/11 Therms Used FY 10/11 Customers Therm Usa¢e Per Customer 2,107 12,508,540 5936.7 Threshhold for application of UTA per Rate Ordinance = Less Than 6,307 Shortfall as % of Applicable FY 10/11 Non-Fuel Revenues = -5.87% Applicable FY 10/11 Non-Fuel Revenues = $ 6,571,714.99 Authorized Commercial Usage Recovery for FY 10/li = $ 385,885.26 Inflation Adiustment Calculations: U. S. Dept. of Labor CPI-U for September 2009 = 215.969 U. 5. Dept. of Labor CPI-U for September 2011= 226.889 CPI-U Inflatoio� Increase Applicable to FY 10/il Revenues = 5.056% Authorized UTA Recoverv for FY 2010/2011: 1. Residential Single-family Recovery for FY 2010/2011 Usage Portion = $ - Inflation Portion = $ 208,581.58 Subtotal = $ 208,581.58 Less Proj. Over Rec. in FY 20110/2011 = $ (18,000.00) Total = $ 190,581.58 Projected Therms & Gallons to Recover on for 12/1/2011- 9/30/2012 = 3,390,000 Projected Residential UTA Recovery Required = $ 0.06 2. Commercial (Non-Interruptible) Recovery for FY 2010/2011 Usage Portion = $ 385,885.26 Inflatio� Portion = $ 332,284.39 Subtotal = $ 718,169.65 Less Proj. Over Rec. in FY 20110/2011= $ (72,000.00) Total = $ 646,169.65 Projected Therms & Gallons to Recover on for 12/1/2011- 9/30/2012 = 8,380,000 Projected Reside�tial UTA Recovery Requi�ed = $ 0.08 CS W:11 /23/2011 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Enerpv CharaelTherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIA) Usage & Inflation Adj. (UTA) Total Non•Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy Charge/Therm Minimum Monthfy Bill (For Central Pasco Territory) Compares to LP/Gailon Rate of with 6.0% Franchise Change from 1/2006 Therm Rate % 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 DECEMBER 1, 2011 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural Gas Rate Schedules _ 2�S SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL w/M& 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 8y 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.4B $0.48 $0.48 $0.48 $0.46 $0.40 $0.34 S0.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_0� 0.06 0.08 0.08 0.08 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 Q 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 525.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) @ 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 $ 1.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% -282% -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 $0.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 Attachment #5 Contract N Rate CNS NA By Contract (By Contracq $0.46 $028 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 + + FAC + Non-Fuel Therm Non-Fuel Therm Rate for Contract Rate for Contrect # 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% -38.5% $0.069 $0.069 $0.055 $0.721 $0.801 $0.735 BTU FACTOR = THERMS/100 CUBIC FEET (CCF1 10/2011 11/2011 12/2011 O1/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 Interruptible Service Rates 1.015 1.016 1.016 1.016 $ (0.67) -45.9% $0.069 $0.721 CSW:11/23/2011 Attachment #6 Page 1 of 2 BTU Factor: 2.714 Gailons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubicfeet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gailon FOR DECEMBER 1, 2011 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBYIGENERATOR 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 Resi. 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 Ener�tv Charqes/Gallon: Non-Fuel Energy Charge (NFE)/Galloi $1.90 Energy Conservation Adj.(ECA)/Gallo� 0.13 Regulatory Imposition Adj.(RIA)/Galior 0.02 Usage & Inflation Adj. (UTA)/Gallon 0.06 Total Non-Fuel Charges (NF)IGaI. $2.11 Purchased Gas Adjustment(PGA)/Gal 2.46 Total Energy Charges/Gallon $4.57 Minimum Monthly Bill $10.00 Utilitv Tax Note: Fuel Rate per Gailon 10/01/1973 0.161 Non-Utility Taxable Fuei/Gaflon $2.299 Change from 8/2008 Gallon Rate $ 0.43 °/a Change from 8/2008 Gallon Rate 10.4% $1.90 0.13 0.02 0.06 $2.11 2.46 $4.57 $25.00 0.161 $2.299 $ 0.43 10.4% $0.90 0.13 0.02 0.06 $1.11 2.46 $3.57 $10.00 0.161 $2.299 $ 0.23 6.9% $0.30 0.13 0.02 0.08 $0.53 2.46 $2.99 $25.00 0.161 $2.299 $ 0.25 9.1 % $0.25 0.13 0.02 0.08 $0.48 2.46 $2.94 $40.00 0.161 $2.299 $ 0.25 9.3% Set By Contract $1.00 NA NA NA NA NA NA Set By Contract $1.00 Set Bv Contract 2.46 Contract NFE $3.46 + Contract PGA Customer Charge Any Appiicable $50.00 Customer Charge + Any Applicable Faciiity Charges 0.161 0.161 Contract PGA - 0.161 $2.299 NA $ 0.53 NA 18.1 % Set By Contract NA NA NA Set By Contract 2.16 Contract NFE + $2.160 Customer Charge + Non-Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:11 /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 Levei) BRLP1 BRLP2 BRLP3 BRLP4 Applicabie 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 (NFl/Gallon: Non-Fuel Energy Charge (NFE)/Gal. $ 1.80 S 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)/Gatlon 0.06 0.06 0.06 0.06 Total Non-Fuel Charges (NF)/Gal. S 2.01 S 1.81 a 1.21 5 1.11 Purchased Gas Adj. (PGA)/Gallon $ 2.46 $ 2.46 $ 2.46 $ 2.46 Total Energy Charges/Gallon $ 4.47 S 4.27 $ 3.67 S 3.57 Note: No Monthly Minimum Bill Utilitv Tax Note: Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 Non-Utility Taxable Fuel/Gallon $ 2.299 $ 2.299 $ 2.299 $ 2.299 Change from 8/2008 Gallon Rate $ 0.430 $ 0.430 $ 0.23 $ 0.23 % Change from 8/2008 Gallon Rate 10.6% 11.2% 6.7% 6.9% Attachment #6 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR DECEMBER 1, 2011 - 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 E 1.81 S 1.11 $ 2.46 $ 2.46 3 4.27 S 3.57 COMMERCIAL BULK LP SERVICE (Based on Annuai 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 S 0.43 $ 2.46 $ 2.46 S 2.sa S 2.ss BULK STANDBY/ GENERATOR LPSB (Closed for New Residental Applications) $ 420.00 $ 1.00 NA NA NA S 1.00 $ 2.46 S 3.46 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ $ 2.299 $ 2.299 $ 2.299 $ 2.299 $ $ 0.43 $ 0.23 $ 0.20 $ 0.20 $ 11.2% 6.9% 7.3% 7.4% 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.16 Cotract NFE + 2.160 0.161 $ 0.161 2.299 Contract PGA - 0.161 0.53 NA 18.1% NA ` ..1 _ . �... . .'',I - --_. __ + _._.__ , ... .. ...... � .___ I .. _. 1 .-__ F_. . , Attachment#7 __ .. ...I .. ....i . I , .. .._ ,- .. ...-_ i Page�of3 CSW:N272o17 � i I Residential Rate History By Components � _. _____ _ _ _ _ - ___ __ _ _ _ __ Clearwater Gas Svstem _ 1 . _� ___ i ; , -i ' � _ {I � . � _ � __ � � Total Rate .�f i � Ad'ustments(fherm Contract 1 4P �� . 1 . . EIAlRIA# , WNA/UTA-Resl# �11A-Comll#� P�,A P�,A 1 PGA%aallon OG-08 $_1 990 , $ 3.300 � ' . .. i ECA ; ; _ _ _ . } ; . . . .-- i - __ s o:�ao i$ - s - $ - j s i.2�o �$ i iso I s z.zeo Mooth NGttherm LP/aallon' � .. -_-__. Nov-08 _ $ 1.990 $ 3_300 - -. I � $ 0.140 �_$.. - $ - $ - � $ 1.270 i $ 1.190 � $ 2 260 . � .__ _. .. - - - .__ . ... --- _ Dec-08 $__ 1 940_ _$ 2770 1 $ 0.140 I$ �$ . $ - T$ 1220 �$ 1.140 $ 1J30 Jan-09 $ 1750 $ 2290 # 1 � $ 0_090 $_- $ -_- $ __ f $ 1.160 1 $ 1.100 $ _ 1.200 ---- - - i _ feb-09 $ 1 750 $ 2 290 i ... � � � $ 0.090 � $ .. . $ - $ - fi$ 1 180 � $ 1 100 $ - .. 1200 Mar-09 $ 1 580 _$ 2 270 � l I t$ 0.070 $ - 4$ $ -�$ 1 030 $ 0 950 $ 1.200 _ _ Apr-09 $_ 1 410 $ 2.200 � ` $ 0.040 $ - $ - _. $ _ $ 0 890 $ 0 810 $ 1.160 - - -- May-09 $._ 1 410 $ 2.200 I � ... $ . . .. $ _ 0.040 $ $ . - I $ - 1 $ 0 890 $ 0 810 � $ t .160 _Jun-09 $_ 1 410 $ 2.200 � I � $ 0.040 $ $ - � $ - � $ 0 890 $ 0 810 $ _ 1.160 _. Jul-09 $ _ 1 350 $ 2 330 � � $ 0.040 S $ ---. - . $ - $ 0 830 $ 0 750 $ 1290 _ Au�-09 $ 1 350 $ 2.490 .. f I . . }$ 0.040 $ . . .- $ - $ - $ 0 830 $ 0 750 $ 1.450 seo-os s- ,.aso s 2.ssoi 1 -- ;-. i s o.o�o � s o.-o,o s- _� s =�$ o.eao s o.iso s__,.s�o _ -- - . __. _ . __ _ . , ---- - - Oct-09 $ 1 390 $ 2 670 $ 0.070 �$ 0.010 I$ - $ - $ 0 830 $ 0.750 $ 1.590 � _ -- - - - - - � Nov-09 $ 1 390 $ 2 670 � T i � $ 0.070 $ 0.010 I $ � - $ - $ 0 830 $ 0.750 $ t .590 Dec-0� $ 1 390 $ 2.750 7 . r i $ 0.070 $ 0.010 $ - �$ - $ 0 830 $ 0.750 $ 1 670 _ -- - -- ___ _ _ _ _. _ Jan 10 $ 1 390 $ 2.750 7 �i T $ 0.070 $ 0.010 $ - $ - $ 0 830 $ 0 750�$ 1 670 ___ _ --- -- -- -- Feb 10 $ 1 480 $ 2.810 � � $ 0.110 $ 0.010 $ � - _ � $ - $ 0 880 $ 0.800 I $ � 1 690 .. Mar 10 $ 1 520 $ 2.880 � j ... t $ 0.110 $ 0.010 $ -.. - . � $ -- $ 0.920 $ 0840 � $ 1J60 . Apr 10 $ 1 520 $ 2.880 .� I � $ 0.110 �$ 0.010 $� $ - $ 0 920 $ 0 840 I$ 1 J60 May 10 $ 7 490 $ 2.850 ... - J -.. j .. . $ �0.09� $ 0.030 $ - � $ - $ 0.890 � $ 0 810 $ � 1730 __ ._ � -- � - -. . . _ _. ._ ._- _ . Jun 10 $ 1 460 $ 2.950 � __ � � � $ 0.090 $ 0.030 � $ - $ - $ 0 860 $ 0780 $ 1.830 __ ._- - �- - � -- - - --- --. . . . _.._ .. _ Jul 10 $ 1.430_ $ 2.990 I __ I $ 0,090 i$ 0:030 $__ - $ -_ $ 0.830 $ 0.750 S 1.870 - - _ Aug 10 $ 1.390 $ 3 090 .__ J $ 0_090 $ 0.030 $ $ $ 0790 $ 0710 $ 1 970 SeP-10 $ 1.390 $ 3.090.r . I � $ 0.090 $ 0.030 $ $ - $ 0790 $ 0.710� $ 1.970 FY 09/10 Avg. I S 1.437 I f 2.865 I I I S 0.088 � S 0.018 j S - f - I f 0.850 S 0.770 I S 1 J58 - -- Oct 10 $ 1 47 $ 3 02 , $ 0.10 $ 0 02 $ . $ - $ 0 87 $ 0.79 $ 1 90 - -- - Nov 101 $ 1 47 $ 302 I 1 $ 0.10 $ 0.02 �$ ... $ - $ 0_87 $ 0J9 $ 1.90 Dec 10� $ 1 47 $ 3.027 � $ 0.10 $ 0.02 I$ - 8 - S 0.87 $ 0.79 $ 1.90 -Jan 11 �$ 1 54 $ 3 33 � _ $ 0.10 $ 0 02 1$ 0 02 $ 0.03 $ 0 92 $ 0,84 $ 2 19 Feb 11 i$ 1 55 I $ 3 37 � � � $ 0.13 $ . 0 03 i$ 0 02 $ 0.05 $ 0.89 $ 0.81 $ 2.19 Mar-11 � $ 1.55 � $ 3 37. 1 _ .. 1 .. . $ 0.13 $ 0.03 � $ � � 0.02 $ 0.05 $ 0.89 $ 0_81 $ 2.19 . . P.pr-11 � $ 1.46 � $ 3 28.J . � . $ 0.10 $ 0.04 $ 0.02 $ 0.05 $ 0 82 $ OJ4 1 $ 2 12 May- t t,_$ 1 4 5 �$ 3 3 5f � �, �$ 0. 1 2 $ 0 0 2 I S 0. 0 2 $ 0. 0 5 $ 0 8 1 $ 07 3 �$ 2 1 9 - �- -- - � - - - -._ .. _. _ _. . Jun-11 �$ t 45 $ 3.35 I � I $ 0.12 $ 0 02 I S 0.02 $ 0.05 $ 0 81 $ 073 }$ 2 19 -- _ _ . _ - - Jul 11 j. _$ 1 45 $ 3 35 � $ 0.12 $ 0 02 I S_. 0.02 $ 0.05 $ 0.81 $ 073 �$ � 2 19 _ ._ .. . . - - �- _.. _ Aug 11 I, $_ 1 42 $ 3 46 � . .. i ... - � . .. $ 0.12 $ 0.02 f $ 0.02 $ 0.05 $ OJS $ 0.70 $ 2.30 - - - _._ _._. _ __- -- - - -- - --- .. Sep-11 �$ 1.42 $ 3.46 � $ 0.12 $ 0.02 ;$ 0.02 $ 0.05 $ 078 7$ OJO $ 2.30 �+�y. I� � I� �'w I iI I a � o i a � i a l a I a �.00v � a v.iav � a �.oco . I . . I ' ' I . . �_ .. _.� _._ � .___ { _ _ t .. __ { .. 1 .. __ _ Od-11 $ 1.47 $ 3,63 4 � �$ 0.13 $ 0 02 �$ 0.02 $ 0_OS �$ 0 82 �$ 0_74 $ 2.46 __ Nov-11 $ 1.52 $ 3.63 � �-- � ... I$_ 0_13 $. ..002 1 s o.oz s o.os $ o ei r$ o.�s� s-_. - 2.ds- _ Dec 11 f$ 1 56 $ 367 _. � � �$ o.�s s�0.02 ' s � o.os j s o,oe �$ o.s� $ o;is j s� � z:qs Mar-12 � � � ( � � I _ � _ Jan 12 � I _ _ � _ , � _ _ --7 I _ j _ _ _. � I I � - r � - � � � �_ 1 - � � . _ � Aa�-�z i I _ - -. _i , . � _ Ma -12f � { I I Jun 12I _.� _ _ . , � ; � . Jul-12J ��, , - _ - - Aug 12�._ _ . _ � -_. -t _._ _ _. { _ .... . � -- - - � i � - -- t -. _ , _ � -_ _ . . . . 1 i _ . _ 1 Incr.Above I E 0.09 S 0.65 I .. f 5 0.03 S - E._.. _ 0.06 = .0.08 5 - i S _- � S 0.56 Last Year {I 1 � I I � SameMonth 1..._ 6% 22%I I I 30%( .... O�L NAi NA' 0%i ...0%� 29% - !... ... . . . .1 _ , - i ... � 1 . l � ... . _-- I .. __ � _ . Incr Based � S 1.80 S 14.2_1 . _ _ _. � I __ : _-- -- � � � � on 20 Thertns 6°G 24%I i � _._. . . _.. .._ _ , _ i � . Equivalent �a � -- _ � _ . . I _.. , . _ _ i .._ Cents/KWH j ._.. 5.3 73.7 i .. . . � . . . . . I . . --. _ _ _. _ .. ._ , .. _ . ___ I . . __ . .. _ .... .. For Gas I � t � : j j. i __ t vs. FPC Rate 1 12.9 12.9 Note: This is Progress Energy's residential rate for usage >1,000 KWH � (Residential). . . . ....� _.� ! . � ... 1 ... � _ � _... ._. � -__ � _ _ r .._.. _ .. - _ . . I _. . � .._ � __. . � �- _ _ .__. '� . .. f. --- _ � . . . i .... . . .. . . � . Gas Chea r � I ' I j by . �_. -59°/.� .7k ... ._ ,� .. .�. � .._. i ... . . ._ . _._ , .. . .. ..... I - � -- -� _ t .__ . . .. . _ _ . - � . --- � ---- . _. Notes: l-- --_..- -- ' I___ 1 1 � _ � _ __ _ . � _ _ . _.__ _ . _ ' Based on Bulk LP (BRlP3) which is applicable for wstomers usin� 120.1 - 300 gallons/year & equal to ResidenUal LP Will Call (BRWCLP) i k NewratesimplementedlM/2009 withfollowin�changes __ I i � j .. i i i _. __ _ __.._- - -. . _ _ . . _ i .. �- RS NG Customer Char�e inaeased $2 from $8 to $10/month & NFE rate droped 10 cents to 48 cents/therm (CC +$1/Mo. in 4/1/2005). __ _� _ . __ __ _ __ i - BRLP3 LP Customer Charge increased $18 from $72 to $90/year, and.NFE rate re�sed 10 cent to $1.00lgallon (CC +12/`!r. In 4/1/2005). ! _ j- 9 -. � -- ' r - I Y, i __ � .. _ : __ - U A molemented �A ��WNA chan ed jo UTA, but no addrtions to new components of these iniliall I � CSW:8/28/2011 Attachment #7 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.06i $ 0.065 $ 0.063 $ 0.072 $ 0.047 $ 0.047 $ 0.053 $ 0.01 $ 16.4% 1.6% 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 C�i�9 53% 5.3% NG vs. Electric -46% -37% -37% -35% -31 % -46% -47% -40% -64% -65% -59% CSW:8/28/2011 ; ; � �Attachment #7 , __ _ � i j _ _ _ __ _ _ _ _ _ _ __ ; _. �_. � - � � _ ___ � 9 _. , a e o I , , � _ _ . __ _ --- _ __ _ _ , _ , - - __ _ _ ,' __ i__ r _ .! _ _ ._- _ __ _ . : __ � __ 1__ l-= _ __ _ _ -- Annual Average CGS Residential Rates __- --. ,___ --- -- ;- --- --- - ' ----- -- - I 1.._ -_ _�_ _ + - - - _. -- Calender Year I ; Fiscal Year ; Year � NG/Therm ' LP/Gallon" �Year NGITherm I LP/Gallon'` ! 1995 '$ 0 915 $__ 1. 39 i* -1FY 96/97 $ 1�.089 �$ 1.390 �* __ 1996 � j * 1997 i$ 1.049 $ 1.380 * � FY 97/98 1$ 1.054 $ .-1 318 i* _ ___ __ _ _-- _ _ _ 1 9 9 8 t$ 1 0 3 2 $ 1. 2 8 8 *.� F Y 9 8/ 9 9 rl$ 1. 0 5 2 $ 1. 2 6 9 j* - __ 1999 i$ 1 073 $ 1.311 � I FY 99/00 I$ 1.152 $ 1.504 1 _ ___. — -- � 4 _ -- ! . -- 2000 �$ 1 222 $ 1 584 i ; FY 00/01 $ 1.551 $ 1.649 � _ _ ___- -- _. -- __ __ -- 2001 I$ 1 549 $ 1 586 'FY01/02 1$_ 1.352� $ 1.488 1 __ _ i .. _ ' FY 02/03 $ _ 1.477 1 $ _1 817 I__ _ - _ - 2002 $ 1342 $ 1.553 � 2003 $ 1 534 $� 1.864 1 1 FY 03/04 $ 1.603 $ 1 913 � _. � - 2005 _�$ _ 1 925_ $ 2.278 � i FY 05/06 �$ 2.080 _I $ 2.480 ' 2004 � _1 - 2006 1$ _ 2 012 $ 2_501 T ; FY 06/07 �$ 1.918 $ 2 742 ; i ._ -- - _ j � - -- - ._ _ ; 2007 �$ 1 893 $ 2.869 I FY 07/08 $ 1.932 $ 3.183 2009 i$ 1 464 $ 2.488 I FY 09/1�0- $-- 1.437� �$ -2.865 iI . _ _--_ a ; �-_- _ �_ ___ ;_ _ �--___ _a� ____� �_ 2010 _$ 1 457 $ 2.946 FY 10/11 $ 1.475 $ 3 282 I _ { ____ -- --- __ __ ' � $ 1.462 I $ 2.048 , _ Average � $ _ 1.472 $--_ 1.998 ; � 1 _ _ �_ . I i , ' . � _ _ _ __ I . i __ i � . _ . -- ---- _ . � � __ _- _- . - ! -- -- I t � __ . t . _ . . �__ _._ _�___ r___. ... . . N Ba ed on the Residential Metered Propan I ' - - I __ ,_- - - � e schedule which was closed for __ -- --- ---- -- new customers effective March 8 1999. For 1999 & FY 99/00 and beyond � _-- __ ---- — __ - - — _ -- based on Bulk LP (BRLP3) which is applicable for cus#omers usin 1 ' _ _ _-- -- - - - - _ _ _--- -- 9 __ 120.1 - 300 allons/ ear & is equal to Residential LP Will Call � !