Loading...
GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 2013CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet �I�O: Willian� F3. I��ornc II, City Vlanager , ..__.,.. _.. ___ FROM: Chuck Wan-inbrton, Managing Director ;� ,��r'� �� � COPIES: Rod Irwin, Assistant City Mana�er;Ylosen�arie Call, City C'1erk; CGS & CCS Ma�lagement Teams; ,Ianet D�rrou�h, Sr. Aca�untant/CGS; Laul-a Damico, Sr. Accountant/CCS; Lynne Priester, Cust. Serv. CoordJCCS; Lindsey Bessette, Systems Analyst/CCS SUB,JF,CT: DA"I'E GAS AllJLSTMFNTS EFFF,CTIVF. FEBRLTARY 1, 2013 Januaiy 22, 20li Gas supply prices have continued to be stable thi� this past Fall and have actually dropped a little int�.� thc Winter, thcrefore, we are recommending a 2¢/tllelm reduction in ou�r Natural C'�as PGA and � 7�/gallon reduction in our LP PGA for Pebruary. We recommend that we continue our standard Contract LP PUA at 30� below our Standard LP PGA, so this will be down as well. We have also evaluated the status of our Adjustment Clauses aiter 4 inonths into the fiscal vcar and are recommending the following chanbes in February: a reduction in our Ener�y Conservatio�n Adjustinent (FCA) oi� 1¢/tl�enn or gallon, an increase in our IZe�uIatory Imposition Adjustznent (RI�� ) of 3�/thenn or �allon, a�ld an increase in our Residential t�sage & Inflation Adjustmcnt (UTA) c;�f 3¢/therm or gallon. But, we are not recommending any change in our Commercial Usa��e & Inflatio�n Adjustment ( � IA) for February. The net effect of these recommended changes for February is an increase in our typic:3�f Residential Natural Gas customer's rate of 3¢/therm (+2,0%) but a decrease in our typic:��l Residential I,P customer's rate of 2¢/gallon (-0.6%). It should be noted that since we are not recommending that the Commercial UTA be changed, Con�mer-cial customers will see no increase i�i1 their NG bills and an even breatel• decrease in their LP bills. 1'herefore, we are recommending your approval of thc f�ollowing rates to become effective for billin<<s rendered on and after Februa�y 1, 201 �: Natural Uas Finn St��dard IZate Schedule PGA .. Natural Uas Intcrruptible and Contract (Non-Standard) Rate Schedule PUA ........ Propane (LP) Gas Standard Rate Schedule PGA _. I'ropane (LP) Gas C'ontract Rate Schedule PCiA .. Fnergy Consei-vation Adjustment (I?CA) ............................ IZegulatory Ilnposition Adjustinent (EIA) ....................... �0.71 per therm (down 2¢/ther���} �0.61 per thenn (down 2�/therm) $1.92 per gallon (down �¢i:;ailon) � 1.62 per gallon (down 7�!�allorl) $0.13 per thenn or ballon (down l�) �0.08 }�er thei�ll or gallon (up �¢) t�sa�e & Inilation Adjustment (�UTA) - Residential ............ �0.16 per- thern� or gallon (up 3¢) - Commercial .........50.06 per thcrm or <�allon (no chan�e) William B. Horne II, City vianager .Ianuary 22, 201:5 Pa�e 2 Attachment #1 shows the status of our Adjustmeni Kecovery Clause balances with actuals traru December. Our objective is to be as close as pr•actical to balance by f�Y endin��. Attachments #2 a>>�i #3 show our ailnual projections for Natural Gas and LP supply costs, respectively. Attachments `E� and #5 show the impact of these adjustment clause chanaes on our overall Natural and LP Uas rates_ respectively. Attachment #6, Pa�e #1 -#2 shows our monthly rate history over the past 3� years, and Pages #3 and #4 of this show our 11 year relationship to elcctric prices and avera�e resident�,al rates, respectively. P_lease note that Paae #3 of this ana(vsis shows that, over the past 11 vear�� our residential natural 6as rates have risen just 10 4% as comnared to a 57%, increase for ProQress Enerw Florida's residential rates That's an averaae annual increase of 0 9%/vear for natural aas vs. _5.2%/vear for electric --- a remarkable difference� I should point out that the overall effect is that our tvnical Residential customer rates are narr� approximately 58%, lower than electric for Natural Gas and 3% lower than electric for o4ir t_ypical LP Residential rates. This is a very attractive competitive position vs. electric rates. Note th;at ihis is even after Yrogress Enerby Florida's rates decreased this January. We will continuc to track these balances each month. make monthly projections of these factors base:d 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 infolmation to CCS in order to make the appropriate adjustments in the billii�g fornlulas in time for the I�ebruarS� 1'' billinbs. If�you have any questions on this, please call me. CS W/csw Attachments > € Approved: ,�. � > =::. — -�� ..t ;`� � . � . - — William F3. �I �orne IL City Manager � �-,-. � �---`'. U\�y DocumentslMSOFFICE\WINWORD\GASRATES�Gas Adjustments for February 2013.do;:x Month Prior Year Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr 13 _ _M�-13 Jun-13 Jul-13 Aug-13 Seo-13 �.�.�r►rtvvr� � crt I�HJ J T � i CIVI SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Reservation Charges $ 171,361.18 - ----___. - $ 190,000.00 --- ------_-- $ 175,000.00 $ 180,000.00 - - - --- -_ _- _ $ 130,000 00 - --- _� _ _ _ $ 85,000.00 - _._� _. - -- --- � 75,000.00 -- ------ ___ _ __-- � 75,000.00 - --------- ___ ----- - $ 75,000.00 _ _ $ 70.000.00 � Includes Annual Admin Charge of $723,4 + FY 11/12 PGA write off of �14,838.37 + + Add'I Dividend based on FY12 Net Prof RC = $ 1,497,577.72 Interest Cost Center Total NG Fuel Total NG PGA 817,943.56 $ 870,980.55 $ 1,050,000.00 $ _ --. __---- -- 1,025,000.00 � 950,000.00 $ 900 000.00 $ -- -- 825,000.00 $ 775,000.00 $ _ _ ___ .- 750, 000.00 _� -_ __ 750,000.00 $ 750,000.00 $ 1 + CCS Month Attachment #1 Page 1 of 4 Cumulative NG PGA YTD Overage Rate/Therm 18.81�$__ 41,917.09 1_ $ 4,098,111.76 $__ 1,110,918.98 $(2,987,192.78) $(2,990,954.12) __ 0.73/0.63 14,954.77 $ 55,226.46 �$ 1,106,484.70 1,354,578.34 '$ 248,093.64 $(2,742,860.48) 0.73/0.63 13,714.30 $__ 45,65941 � 1,170,081.82 1,465,401.61 $ 295,319.79 $(2,447,540.69) 0.73/0.63 12,237J0 � 45,000.00 S 1,297,237.70 1,845,715.48 $ 548,477.77 $(1,899,062.92) 0.73/0.63 9,495.31 $ 45,000.00 $ 1,254,495.31 1,679,987.50 $ 425,492.18 $(1,473,570.73) 0.71/0.61 7,367.85 $ 45,000.00 $ 1,182,367.85 1,591,923.64 $ 409,555.78 $(1,064,014.95) OJ1/0.61 ---- - - - 5 320.07 $ 45,000 00 $ 1,080,320.07 1,422,570.06 $ 342,249.98 $ (721,764.97)_ _0_71/0.61 - - - - --- ------ --- _ -- -- - --� _ .. _ _ 3,608.82 $ _ 45,000.00 _ �$ __958,608.82 _ 1,273,538.91 $ __ 314,930.08 5 _(406,834.89) _0.71/0.61 2,034.17 $ 45,000.00 $ 897,034.17 1,205,797.48 $ 308,763.30 $ (98,071.58) 0.71/0.61 - -- - ------- 490.36 $ 45,000.00 $ 870,490.36 1,131,281.90 $ 260,791.54 $ 162,719.96 0.71l0.61 __ ..- ----- _ - -- - ------ -- --------- -__ _-- ----- - $ 45,000.00 $ 870,000.00 1,131,281.90 $ 261,281.90 5 424,001.86 0.71/0.61 - - --------- - - - $ 45,000.00 $ 865,000.00 1,131,281.90 $ 266,281.90 $ 690,283.77 0.7V0.61 - - -- -- - ------- --- _- -- -- _-- - --- $ - 5 $ 724,761.89 - $ (724,761.89) $ (34,478.12) -- - ---- - _ _ _ _ __ 69,242.18 ' $ 547,802.96 __ $ 16,374,994.47_ $ 16,344,277.69 $ (30,716J8) __ 092,890 + Dividend $1,300,720 _ $ 3,132,338.68 - ----- ------- - - - -- _----- (5) Commodity adjustment from FYE transfer of ECA Collected in PGA @ 1/2 of the --- -. -- - ------- ----- - - ---------- NG Proportion = 97.9% x Total ECA Transfer = g -- ---------- ..-------- --- ---- - ---- -- ------___-_..--- -- - Average Annual PGA/Therm =__ _ $0.684 Avg Fuel Only= ____ $0_435 __ --__ _---- ------_ _ --- - __ _ _ - ------ Delta/Therm = $0.249 _ 724,761_ - - ___ -- _- - -_ _ _--_ _ _ -- ._ . _- -- . --- ---- ----- - . .. - -- ___ __ _ ..._ -- --- -- - AAOnfhly ---- . Cumu�five- ._._ -- LP PGA -- --- - _ __ __ --- --- ---_ - - --- -- - - -- -- - _. _ - _- - - - ----- _ _-- - -- - - --- -- --.. . Budget _ Gallons _ Monthly _ Interest _ Commodit�r __ _ Total LP Fuel _ Total LP PGA __ Overage ___ YTD Overage_ Therm/Gal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) -- _ _ - -- ------ __- --__ _---- - __ _---- ---- _-- - ------- -------.. __---. ------- Prior Year -- -- - . __ _ ..---- -- --- - ._ - - - - -- -�- - -- - � 22,242.30 --__ ---- -- ----°- --- . _ _-------- -- __-- __ __ Oct-12 - -- _ 37,262.4 $ - - -- - -- 1.21357 $_ ___---__ � 45,220.53 _ 1-_ $ -_224,382.87 $ __ 74,115.32 $ (150,267_55). S _-_(128,025.25) _2_17/1.99 ___ ------ - Nov 12 25,9764 S --� .- 1.22935 $_ - 640.13 ___ 31,934.09 ---_�-- 32,574.21 __ 51,785.89 $_ 19,211.68_ $ (108,813.57) 2.17/1.99 - - _.. _ --- - -- Dec 12 -- - 29,658.5 $ _- -__- 1.16901 _$ __-__544.07 __,_ 34,671.08 - -35,215.15 59,019.78 � 23,804.63 $ (85,008.95) 2.17/1 99 . Jan-13 40,000.0 $ 1.16000 $ 425.04 46,400.00 46,825.04 79,600.00 $ 32,774.96 $ (52,233.99) 2.17/1.99 - --- --- -_---- _ ------ - ---------- _- --- -- Feb-13 39,000.0 $ 1.16000 $ __ 261.17 45,240.00 __ 45,501.17 ` 74,880.00 $ 29,378_83 $_ (22,855.16) 2.10/1.92 -- -- - ---- -- -- - - -- - Mar-13 39,000.0 $ _ ____ ___ _____ __1.17000 $ _____ 114.28 _ _ 45,630.00 __ ____ 45,744.28 ____ 74,880.00 S ___29,135J2 $ 6280.56 2.10/1.92 - -. _.. - __- --- - - -- Apr-13__ 31,000.0 _$ ___ 1.20000 _$ _ (31_40) _ 37,200.00______ __ 37,168.60 _ __59,520.00 $ _ 22,351.40 $ _ 28,631.97 2.10/1.92 - - -_ _- - __ __ May-13 28,000.0 $__ __ _ _ _ _ _ 1.22000 $ _ _ (143.16) _ _ 34,160.00 __ __ _ 34,016.84 __ _ 53,760.00 $ _ 19,743.16 $ 48 375.13 2.10/1.92 -- -- --- -_ ____ Jun-13 28,000.0 $ 1.23000 _S _ __ (241_88) _ 34,440.00 _ _ 34,198_12 . _ _ 53,760.00__a 19,561.88 $ 67,937.00 2.10/1 92 --- - -------- __ __ _.. ----- ----- -- _ --- --__ ---- . __ _ Jul-13 27,500.0 $ __-- _-_ __ _ ______ 1.25000 __� _ -___ (339.69)-__-- _ - 34,375.00 _ ___-__ __ 34,035.31 -__ ___ 52,800.00 _ $ _18,764.69 _$ 86,701.69 2.10/1.92 - --- _- - --- - Au 13 27,500.0 $ _ 1.26000__ $ _ (433.51) _____ 34,650A0 _ _ 34,216.49 52,800.00 $ 18,583.51 $ 105 285.20 2.10/1 92 - g ---- ---- ___ __ _ _ _ _ - -- ------ - - - _ __ _ __-- ___ _ ____ Sep-13 __ 27,500.0 $ 1.27000 $ -_ 34,_925.00 _ 34,925.00 52,800 00 $ 17,875.00 3 123,160.20 2.10/1.92 - __ -- _----- _ _ - --- -- - - - --- .- -- __ _ _ P13 4 116,384.14 $ (116,384.14) $ 6,776.06 _ _ __ TotaIYTD 380,397.3 S 1 20623 S _ 795.05 $ 458,_845.70_ _ $ _ 755,187.23 $ 739,720_99 $ (15,466.24) ___._ - ___ - _ _ _ _ _ _ Cost Center Expenses _ _ _ - _ _ _ _ _ _ _ . -- _ _ __ _ _ _. __ CCS Chg, Admin & Dividend $ 128,520.00 1 -__ __ _ _ . -- ___ __ _ FY 11/12 Write off PGA & WNA $ 1,104.15 1 _ _ _ _ _ _ _ _ -- --- _ _ _ _ __ _ __.. _ _ _ __ _ ___ __ Fuel - _ -- - -__ _ __ _ _ �C 15,000.00 1 __ _ __ __ _. _- - -_ . _ - -- -_ _.._.__. __ --- - _- _ -----_ _ ---- - -__ _. _ - _- __ __ _ Donations to events $ - 1 __ ____ . _ _ ---- - -_ - --- __ _ _ .-- _---- _-- - - --- . -- -- _ --. _ _ _ ____ ---- ---- - - ---- __ -- LP Yard Vaporization/loss due to malfunctioning meter :$__ 108.97 _ 1 __ __(4)__Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate _ __ ___. _ _ _ ---- - ----- --- ------- ------_ - . _- --- - _ - - LP PGA Event fuel cost $ 14.99 1 LP Proportion _2.1 % x Total ECA Transfer = $ 15,546.48 __ __ -- -- --- - -- ------ - --- -. _. . _ _ � _ __-- --- _- _ __ _- -- Suburban Software Systems $ _ 1 +Additional Proiected Costs Needed = � ?On,A3?.66 � _ - _. _ --- - - - - . -- uepreciation oi LN tanKS _ $_ 34,414 23 1 -- - - _ --- ------ - -- _ . _. . --- - - -- - -- -- - _ - - _ _ _. -- __ _ _ _ Suburban Software Systems license S _ _ 1 _ _ -- __ _-- ------- -___ __ . _ Contribution to garage LP trk up grade $ - 1 ___ _ __.� .----- -- _ _ _ __ _ LP Holding Tank Restoration $ - Proj. Remaining Proj. Annual Total Month Prior Year Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 �+LCHRVYH 1 GK l7HJ �T, I CM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 2 of 4 - ---------- __ ----�.._-- - --- ------ ---------- -- — _.—_---------- ---- NSERVATION ADJUSTMENT (ECA) _---- ------ --_-- - ---- - -- ___ ___ _ _ ---- - _ _ ------ -- - ---_ ---- ------ ---- --- -- ----- - Monthly Cumulative ECA --__-_ ____ _--_ ___-----_____----- ----- ----_ __.-__----- -- -_------- ----- ----. -- - . Cost Center Interest___ ___ _____ ___ _ Total ECA Total ECA Overage YTD Overage NG/Therm - _ _----- ._ __ -- __ _ - -- -- --- -- -- --- ----- - - -- Expenses Notes/Exceptional items _ _ _ _Expense _ NGV Station _ _ Expenses __ Billed _�(Shortage) __ (Shortage) _ LP/Gal. - �v - -__--- --- ---- ----- -------__ ---._- _ __ ___ --- - -_ _-- -_.. -- ----- --- -- -- -- ----- $ _321,890.98 Promo$57,165,AdvS6,814,EmployCosts$80,392 $_ _ _ - S__ 23,98257 _ 1 _ $ 345,873.55_ $ __ 104,361.73 $ _(241,511.82) $ (241,511.82) 0.14/0.14 ___ -- --- --- -- -- � _ 100,841 34 PromoS3o,449,Adv$7,880,EmployCosts$62,512 $ _ 1,207_56_ $ _ ___15,241.48__ _, ___117,290.38__ _ 163,351.29 $ 46,060.91 $ (195,450.91)_ _ 0.14/0.14 - - ----- — ----- ----- $ 145,225.33 Promo$80,363,Adv $1,399, Employ Costs3s3,463 _ _ $ _ _977.25 $ _ _ _228,554.38 2 ___ 374,756.96 ___ 184,315.34 $ (190,441.62) $ (385,892.53) _ 0.14/0.14 ----- - -- --- -- ---- - - _ � 165,000.00 Incl.$45,OOOforPhillies $ 1,929.46 $ 30,000.00 196,929.46 209,216.26 $ 12,286.80 $ (373,605.73) 0.14/0.14 $ 12 $ _ 12 $ 12 $ 16 Sep-13_ $ 120,000 P13 $ Total YTD $ 1,787,957 --_ -------� -- - -•- - -------- 0 $ 1,868.03 $_ 30,000.00 __ 151,868.03 _ 181,922.60 S 30,054.57 $ (343,551.17) 0.13/0.13 -- --- ------- -- - O Incl.$50,OOOforTBP&other $ 1,717J6 $ 30,000.00 201,717J6 172,533.97 $ (29,183J8) $ (372,734.95) 0.13/0.13 --- ------ --- ------- ---- --- - — ---- ---- -- — ---- — __ p $ 1,863.67 $ 30,000.00 151,863.67 153,901.17 $ 2,037.50 $ (370,697.45) _ 0.13/0.13 - -- -------- -- -_ _ 0 $ _ 1,853.49 $___ 30,000.00 _ 151,853.49 137,796.08 � (14,057.41) $ _(384,754.86) ___ 0.13/0.13 -- ---- - — --__ p --- — - — - . - - -- $ 1,923.77 $ 30,000.00 ---- 151,923.77 130,574.06 $ ____ (21,349J2) $ __(406,104.58) __ 0.13/0.13 �� —..�-- _-__ -- - --- — - — --- . O Incl. 545,000 for7/4 Fireworks $ 2,030.52 $ 30,000.00 197,030.52 122,593.73 $ (74,436.79) $ (480,541.37) 0.13/0.13 -- ----- ----- ------- ---- - ._ - --- -- - - - -- p -- . . -- $ _ __ 2,402.71 $ 30,000.00 - ,_--152,402.71 `_ 122,593.73 $ (29,808.98) � _ (510,350.35) _ 0_13/0.13 ------- --_. -- - - . _ _- _---- - - - - -- - _ O Incl. $200,000 in Add'I. NGV Station Payoff_ __ _ _ _ $ _ _ _ 2,551_75 $ _ 230,000.00 3 352,551.75 122,593.73_ $ _ (229,958.02) __$ _ (740,308.37) 0.13/0.13 -- ----- - --- - - ---------- -- ----- - - -- ___ _ $ - - 740,308.37 $ 740,308.37 S - __-_ _ _ _ _ --- -- _ _ - - _. 5 _---- _. - S 20,325.98 $ 737,778.43 $ 2,546,062.06 $ 2,546,062.06 S - ---- - -- _ _ _ -__ ____ __ _. _ -- ------ --- ` -- - -- --- - --- --- --- - _- - �- ,-� . _------- - --. _ (1) Incl. Annual Admin Charge of $47,420 + CCS chg of $58 070 __ __ _ __ _(6) _Transfer of ECA Collected in PGA @ 1/2 of the ECA_Rate (up to_ECA Annual Shortfall) + Dividend $69,090 + FY 11/12 Write off of $2,939.86 Note: Maximum amount which can be transferred = S 902,876.85 - - . - + Add'I Dividend based on FY12 Net Profit $?? - - _ . . - - -- - -- _ - --- _ -- - -.. $ 177,519.86 __ __ _ _ ---- ----- --- ----- __- -- - -- - - - _ --- _ --- -- _ - --- _ _ _ ___ _ __ _ __ _ _ -_ - - -- -- ___(2) Added to CIP from Gas Reserves _ __ $ 200,000.00 -- -- - -- _- -- --- - - -_- - _-- (3) Planned added CIP from ECA $ 250,000.00 Net ECA CCE _ $ 2,368,542. Net NGV CCE _ $ 287,778.43 - - -- -- __ - __ - - ----- -_ - _ -- -- -- - - __ ___ ___ - _. .-- -- -- - - -- (EIA) (ORA) -- -- __.. -- --- ___ - -__ _- - -- _ _ _. _- _. ---- -- ------ _- --- - - - ___ -- - - Budget Environmental Regulatory_ __ Interest_ __ Total RIA_ __ Total RIA _ Overage _ YTD Overage _ NG/Therm --- --- -- -- - - --- -- - - -- _. - _.- Month _ Expenses _ Notes/Exceptional items __ _ _ _ _ _ Expenses Expense _ Expenses _ _ _ Billed __ (Shortage) _ _ (Shorta e LP/Gal. _ 9 ) - -- _---- - Prior Year - . $ - $ (471 404.32) ----- -- - - ____ _ _--- - - __ _- _ _ _- _-- -- - - -- - -- .__ - _-- -- - -- ----- -_ _ _ _- --- - _ _ Oct-12 $ 12,832 46_ _ a„qnnainRpl Pt 510,328.ss+addl P10-t2 �as,5se.55 93 916 90 $ _ 2,357 02 _1_ $_ 109 106.38 47,949 50 S__ (61,156.88) _$_ _(532,561.20) 0.05/0.05 -- -----------_ _- Nov-12 $ _ 1,512.00 ___ ___ _ __ $ 2,662.81 _ _ ___ _ 4,174.81-_ _ 58,402.09 $-- - 54,227.28- $_-__(478 333:92) _ 0 :05/0.05 _ __ __ - Dec-12 $ 1,512.00 AMR P1 $136,022.10. P2 $113 264.31, P3 S5_sea_� _255,166.65 $ _ _2,391.67_ ___ _ _259,070.32 65,874.04 S _ (193,196_28) �_ _(671,530_20) __ 0.05/0 05 __ __ _- _ _ _ ---- Jan-13 $ 10,000.00 _ 100,000_00_ $ _ _ 3,357.65 _ 113,357.65_ _ __ 80,606.47 _� __ (32,751.18) $ __ (704,281_38) 0.05/0.05 - -- - - _ _ _ _ _ _- - Feb-13 S 10,000.00 100,000.00 $ 3,521.41 __ _ _113,521.41 _____ 120,771.86 _$ _ __7,250.45 $_ (697,030.93) 0.08/0.08 -------- ------ ----- Mar-13 S 10,000.00 _ 100000.00 $___ 3,485.15 _ 113,485.15 ___ 114,53909 _S_ 1,053.94_$ (695,976.99)_ 0.08/0.08 --- -- --_ Apr 13 $ 10,000 00 100,000 00 $_ 3,479.88 _ 113,479.88 102,169 45 _$ (11,310.44) $ (707,287.43) 0.08/0.08 May-13 $ 10,000.00 100 000 00 � _ 3,536.44 _ 113,536.44 _ 91,477.85 $ (22,058.59) S (729,346.02) 0.08/0.08 -- - _ _ _ _ Jun-13 $ 10,000.00 _ 100,000_00 _ $ _ 3,646J3 _ 1_13,646.73 ^ 86,683_41 $_ (26,963.32)_ $__ (756 309 33) 0.08/0.08 --- --- _ _ _ -- - _ _ __ - ---__ Jul-13 $ _10,000.00 _ _ __ __ _ 100,000_00 $ _ _ 3,781.55_ _ __ _ 113,781.55�_ _ _ 81,385.56 $ _(32,395.98)_ $ (788,705.32) 0.08/0 08 _ __ . --- - - _ -- - --- - Aug-73 $ 10,000.00 _ ___ _ _ _100,000.00 $ ___ 3,943.53 113,943.53�__ 81,385.56__ $ (32,557.96)_ $ (821,263_28) __0.08/0.08 - ---- ._ _-- ____ __ _. _ _ __ _ Sep-13 � 10,000.00 _ _ _ _ _ _ _100,000.00_ $__ 4,106 32 _ __ 114 106.32 ___ 81,385.56__$ __ (32,720_75) $ (853 984.04) 0.08/0.08 --- _ -- _ _ P13 -- --- $ - - $ - S (853,984.04) . --- - . . __ TotaIYTD $ 105,856.46 __ $ 1,249,083.65_$ 40,27015 1,395,210.16 1,012,630.45 $ (382,579.72) - - --- ---- -- _ .- - ----__ _ __ _ _ - (1) Includes annual charges for Admin Charge $10 850 - - -_ _ _ _ _ _ _ _ __ _ - _ _ _ __ _ + FY 10/11 Write off of $470.46 _ _ _ _ _ _ _ __ _ _ _._ _ _ _ _ . __ ___ _ __ __.. __ __- _ __ __ _ . __ _ ._ __ __ . _. _ __ __ I.LCHKVVH I CK l7A' ,Y, I CM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 3 of 4 � USAGE AND INFLATION ADJUSTMENT (UTA1 _ _ -- - ----- --�- ------ ----- --- -- --- - Commercial Monthly Cumulative UTA ----- --------- --- - - -- ------- ---- -- - Budget Interest _�_ Overage YTD Overage NG/Therm � - -- - - - Month � LP Gailons Expense Rate/Gallon NG Therms !_ Rate/Therm (Shortage) _ (Shortage) __ LP/Gal Beg. Bal. __ _ _ $ - $ _(640,600.15) Oct-12 6,340.0 $ 3,203.00 0.06 739,856.8 0.06 $ 41,549.39 $ (599,050.76) 0.06/0.06 Nov-12 6,480.0 $ 2,995.25 0.06 898,980.6 0.06 $ 51,312,55 � (547,738.21)� 0.06/0.06 - -- - ---- -- Dec-12 7,648.5_ $____2,738.69 0.06 1 978,389.8 �___ 0.06 �_ 56,413.43 $ (491,324.78) 0.06/0.06 �--- --_----. ._ ----- - - - Jan-13� 7,700.0 � 2,456.62 0.06 1,200,000.0 0.06 $ 65,804.13 $ (425,520.65) 0.06/0.06 ----- Feb-13 7 800.0 $_ _ 2,127.60 0.06 1,100,000.0_ 0.06 $ 60,486.68 $ (365 033.97) 0.06/0.06 ---- - - - - -- ----- -- ------- Mar-13 - - - _. - ... . -- -- - - . 7 300.0 $ ___ 1,825.17_- -_-__ ____ 0.06__ __----1_200,000.0 _ 0.06 $ 66,412.98 $ (298,620.99) 0.06/0.06 - --------- _ _ Apr-13 7,300.0 $_ __ 1,493_10_ ___ _ 0.06 1,100,000.0 0.06 $ 61,092.92 $ (237,528.07) 0.06l0.06 - - -- _ - - - -- - -- - --- -- --- ------ -_-- May-13 6 500.0 $ 1,187.64 0.06 _ 1,000,000 0 0.06 $ 55,701.04 $ (181,827.03) 0.06/0.06 ---_ _ _ _ ---- - _ _ _ - - --- - -- -- ----------------- --- -- Jun-13 6,300.0 S 909.14 0.06 _ ___ 900,OOOA _ _ _ Oi06 _ $ _ 50,316.11 $ __ _(131,510.93) 0.06/0.06 _ _ ----- ---- - - -- ---- Jul-13 5,800.0 $__ 657.55 0.06 ___ 850,OOOA 0.06 $ 47,713.36 $ (83,797.56) 0.06/0.06 -- __ _ --- -- -- Aug-13 5,600.0 $ 418.99 0 06 850,000 0 0.06 $ 47,940.63 $ (35,856.94) 0.06/0.06 _ . _ _-.. . . _- _ _ --- ---- -- - __- ___- -- --- - -- --- Sep-13 5,300.0 S 179.28 __ 0 06 __ 850,000.0 __ 0.06 $ 48,163.37 $ 12 306.43 0.06/0.06 -- - --- -- - -- - ---- -- _-- -- --_ _- -------- --- --- --. _._ Per 13 _ _ - -- -- -- - Total YTD 80,068.5 20,192.05 11,667,227.2 v� 652,906.58 ---- --_ ---_ ____ _----------- -_- ----- - ----- ---- ----- . ------ - ----- - --- - - - _ - _ __ _ (1) Recalculated UTA factors in November & made�ustments in rates in December. Beginning balance changed from +$40,756.39 by a new FY 12 loss of ($681,356.54) _($640,600 15) net. This resulted in no needed change in the UTA Commercial factor. ------- -- -------____-- -- - ---- -----_____---- USAGE AND INFLATION ADJUSTMENT (UTA1 - -_ __ _ _ ------ - - - --- ----- ------ - - ------------------- Y ----- _ --._- ---- - Residential Monthi 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. ------ -_._- ___ ------------ ------_--- $ ------ �--_(436,285.83)--_ - ---- - ---- --- ---- -- --- -- --- - ---- - Oct-12 30,895.2 $_ ____2,181.43 0.08 181,655.6 0.08 $ 14,834.66 $ (421,451.17) 0.08/0.08 -- _ --- _ _----- -- ----- _--- --- - ---- -- -.- - ------ ------ - -- Nov-12 � - -- . - - - - - 19,485.6 $ __2,107.26 __ ____ _ _OA8 _ _ _ --- 242,145.0 ___ 0.08 $ 18,853.91 S (402,597.26) --. 0.08/0.08-- - --- ----- -_ -- -. _ --- --- - _ --- .__ _ _ ------- --- ------- - _ - - -- - Dec-12 21,966.5 $ 2,012.99 0.13 1 308,847.6 0.13 $ 40,836.57 S (361,760.69) 0.13/0.13 _ _ - -- _ ---- -- - - _ _- -- - -- ---- .___ _ _ _-- ----- - __ -- -- - --- - --- Jan-13 32 000.0 $ 1,808.80 0 13 430,000 0 0.13 S 52,700.97 $ (310 868.52) 0.13/0.13 --- - -- - - --- --- -� --- - --- Feb-13 30 000.0 $ 1 554.34 0.17 2 370,000.0 0.17 $ 56,531.33 $ (255,891.53) 0.16/0.16 _ - __ _ -- -- - ----- _ - - ----..._ -- _----- -_ _-- --- -- - -- - -- -- Mar-13 32,000.0 $ __ 1,279.46 0.17 330,OOOA ____ _ __ 017 $ _51,288_08 _$ (205,882.91) _ _ 0.16/0.16 -- --------- ---- -------- - ---- Apr-13 _ 25,000.0 $ _ 1,029.41 ___ _ 0 17 300,000.0 0.17 $ 46,165.20 S (160,747.13) 0.16/0.16 -- ----- _ _ _ _ ------- --- - ----- __ -- -- -- _- -- -- ---- -- _-- _May-13 __ 20,000.0 $ _ 803J4 0.17 250,OOOA 0.17 S 38,404.09 $ (123,146J7)_ _0.16/0.16 -- ---- -- - - -- --- - -.�. - -------- - - --- Jun-13 18,000.0 $ 615.73 __ _ __0.17 _ _ _ _ _230,000.0 0.17 $ 35,397.38 $ (88,365 12) _ 0.16/0.16 --- - -- - -- --- -�-- Jul-13 18,000.0 $ _ _ _ 441.83 __ _ _ _ 0.17 200,000.0 0 17 $ 31,214.87 $ (57,592.08) 0.16/0.16 . -- - - - - _. . --- - - -- __ --- - ____ _- --- - - ---- - Aug-13 _ 18,000.0 $_ __ 287.96 _ ______ 0 17 _ __ � 200,000.0 _ _ 0.17 $ 31,368.73 $ (26 511.31) 0.16/0.16 - --- --- -- ----- ------- -- -- - --------- ----� - - --___ Sep-13_ _ 18,000.0 $__ _ 132_56 _ 0.17 200,000 0 0.17 $ 31,524.14 $ 4,880.27 0.16/0.16 - ------ - _ __ ----- -- - - - -__ _.- - - - ------ ------ --------- ---------_ _ ---------- - Per 13 - - --- $ - -- - -- ______ ____ __ - _---_ ------ --__ _ ___._ __ Total YTD 283,347.3 14,255.50 3,242,648.2 $ 449,119.93 - --- - - - - - - ---- - ----- ----__ _ ___ __ _ ___ _ _- - - -- _ . _ __ --- ___ _ - - ---- ---- - -- - -- . -- -- -- ----- - _ __ - ---- - __ ___ __ _(1)_Recalculated UTA factors in November & made adjustments_in_rates in December. Beginning balance changed from ($5,400.88) by a new FY 12 loss of ($430,884.95) =_($436,285_83) net. This resulted in increasing the UTA Residential factor by $0.05 beginning in December. -- - - -- - --- ---- __ _-- - __ -- --- -_ _ _. _ _ (2) Reviewed the recovery rate in January & mcreased the UTA ResidenUal factor by an additional $0.04 begmning in February. _ _- - ___. __ ._ _ __ _ _ _ _ _. __ __ _ _ _ _ _. __ __ _ _ _ __ _ _ Prior Year Dec-12 Jan-13 -----_ -----_ __-- _ _ .____ Feb-13 _ ___.___ _ _. _ _-- Mar-13 ---- — _ _ . _ Apr-13 ---- — _ -- — _ _ . . May,13__ __ -- __ __ — — _ - Jun-13 Jul-13 — --- —_—_— _ _ _ __— __ A�g-13 -------- ---- Sep-13 ___ --- --- Per13 _—_--_— — _— Total YTD �►LCHr[YYH I GK l7HJ bTJ 1 tM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 -- __ _ LALJSES 18oth PGAs + ECA + RIA+UTA) Attachment #1 Page 4 of 4 Monthly Cumulative Total All Total Recovery Overage� YTD Overage _xpenses Billed (Shortage) _ (Shortage), - - $ - $ (1,529,809.34) 4,777,474.56 $ 1,393,729.58 $ (3,383,744.98) $ (4,913,554.32) 1,260,524.10 $ 1,698,284.07 $ 437,759.97 � (4,475,794.35) 1,839,124.26 $ 1,871,860.77 $ 32,736.51�$ (4,443,057.84) 1,658,615.29 $ 2,333,643.31 $ 675,028.02 � (3,768,029.81) 1,569,067.87 $ 2,174,579.96 $ 605,512.10 S (3,162,517.71) - 1,546,419.67 $ 2,071,57776 $ 525,158.09 $ (2,637,359.62) 1,385,35475 $ 1,845,41879 $ 460,064.04 S (2,177,295.58) -- -�— — ----- - -- ---- --_ _ �. 1,260,006.97 $ 1,650,677.97 $ 390,671.00 $ (1,786,624.58) - ---- 1,198,327.67 $ 1,562,528.44 $ 364,200.77 $ (1,422,423.81) 1,216,437.12 $ 1,466,989.43 $ 250,552.30 S (1,171,871.51) — -- -- 1,171,269.67 $ 1,467,370.55 $ 296,100.88 $ (875,770.63) 1,366,894.91 $ 1,467,74870 $ 100,853.79_$ _(774,916.84) 841.146.03 $ 740,308.37 $ (100.837.66) $ (875.754.50) Total Resl NG/Thm (Firm) __LP/Gal ___ 1.00/2.26 1.00/2.26 1.05/2.31 1.05/2.31 1.08/2.29 1.08/2.29 ----- _ -- _ 1.08/2.29 1.08/2.29 1.08/2.29 _ 1.08/2.29 — --- — 1.08/2.29 --- — __ --1.08/2,29 _ _ _ Last Updated 1/22/2013� � R E $ E R V A T I O N C 0 M M 0 D 1 T V ; r�s-i�neservauon7 � 50.4694 Volumc Gost Oct-12 170,M1J8 5 80,009.60 Nov-12 306,570 E 143,909.96 Decd2 316,789 5 148,70076 Jun-13 ...Ci.7A9 S `48'COJf �en-1} 206_J51 S '.39.iC7_76 �Jar-13 ?1(�7ff� 5 '�A87G0]8 /..nr'.3 :"GS.. 'C��.6E'.9c "fsv�13 tA4217. 5 "v7.G93-'�.' ., . . -39.560 5 ...,. �? �SB - ,:�I .� .M1�a.2'i 3 �?90.. .i:0..�� .,1 �. .. , . ... . . .�, ... Qi.�.- .. > J,.,.. . .a � J 2 s; 6 4a.6722t �i '.___ __. .- .. - ----.,. S0.•t6gq ris-z�neservauon� 50.7185 Valume Cost 41,788 f 90,024.68 53,A30 S 38,389.46 55,21'1 S 99.669.10 552�'I 5 39.FiG9,10 51 C;4�3 5 3'.1�f3.A1 .,..: t1 5 9 �.fi59.'r 53 430 5 38.399.45 � ; i�,ys s sa ozn r.r� ', ..�ntC _ .:.�'?:.,. �. 7 '3�5 . , . . _ . ,:., . ,„.<<.- , �� 1��: . , .c... � '�]4 S �'�i.l,,. E0.0389 Volume Gost 'I5,500 S 602.95 22,500 S 875.25 a,,000 a ,,zos.so 46,SOp c 1,80885 44500 S 1:59215 31.OGC� S .; 05.3C :25C0 ° � 5%525 2 noc a; nez ss . . , S �:8.a5 . J ..., . . ,�.1�'. .,.:.... ., ..".�I� . _.. .. . .__. __ _.._._. __.... .,.. �li, FTS-'I (Usege) i FTS-2 (Usagc) VoGic�,e Rale Cost � Volume Rate Ocb12l� 1M17,026 S 0.0259 E 1,807.97 35,756 E 0.0077 S Nov-12 752,60J S 0.0259 S 3,952.42 � 52,997 S 0.0077 S o��-�zl 162,789 s o.ozss 5 a,z�ss3 ss,z>> a o.00n s Jan-?3'� !t?27P.P s n.o;no S 5,783.67 5521! S 0.0150 5 �-etb-i3��, ".E3.351 S O,U300 5 5.500.53 51649 S 0.075u S '.1ar- i 3� 15a 78? ., O.C300 $ 4,643.67 55 211 S O.U150 5 !cr-?3 I34S7C ,< ^.C3QC S 4.037.10 53.430 5 O.C150 3 .�ay-t3 1��. „ .- 0.73��0 S A.086.36 ! 47.?88 . 0.0150 S ���.w�-t3 .......� 4 D�300 5 3]90_80> 4C440 .. 4_O15?, g I.13 1: .. ., i 1"� $ 3.7:+6 �C . 7-.2q C.n'� ,., c. i.3 ._ '3u"�. S 3./5�3E; ? 7.01�, 5 . . ., _ 5 ., 9.i 8C �'� , , n.^ ., . .. g Cost 275.92 408.08 425.12 828.17 77A.74 828.17 801.45 626.SJ 606.60 626.8� 5?6.62 506.6C CGS Natural Gas Summary MonMly ActuallProjectlons (FY19) Capa Vo�ume (27,633) : (1J9,227) : (114,091) : �zo,000i � rzo.00a> ; r4U.00:l� : �400�:1'r : �40.CC: � `. .,,.....C,�s . ._�.�DO�, . iii0.�i;f,0� . �SO...C�} _ city Relinquishment Ra10 0.2190 S 0.1282 S 0.1596 S Q�G00 .5 0,1000 5 ) ?(. ;!. o �,p �� c � ;r,e 0 50�0 �,c; ) �;..,:� Gost (4,737.61 (17,845.75 (.^.AOO.GQj r2 or,e oai ;P..L`OO.CG1 (�0!J00.CCj 20J000: [20.C�J'.CG; r,o� __.^�.,ADi TOTAL RESERVA710N Reservation COST Adjustments Total Rate 50.00 S 105,893.62 E0.5138 E0.00 S 165,922.92 50.6786 50.00 S 171,361.18 50.5931 5000 S ifi8,178.71 50.4722 50.00 3 . .90Si.'2 50.4�i35 SO.OG 5 IB?.5?5."r'G SQ500^< 50.00! g � 30.82,^.fi5 50.5195 so Cc� S +�,.zc� i.=, so sanz C.0^, � 4±74 J: >n g23G �C.CO 5 3.'��3�.oE .,�A98i ..^,:�0 5 ';'a- aQ4:'Ct ..t,.. .. _ .... . .,� •7�A:" q , 50.00 i 51.496.591.93 SC.523�J _'. __... .__-'_ _.. .. __. __ _....__. _ _- �'GU No Notice Gas Supply(FGU & Peoples) Managementfee Usaye Vo�ume Rate Cosf Fuel'/, 50.060 782,778 5 4.4J17 ; 807,953.04 3.03% E 9,593.00 f - 211,756 S M1.3281 S 916,492.60 J.03% S 11,578.00 S - 224,482 E 4.2486 S 95a,744.45 i J.03% S 1�,894.00 S - 252.506 S R.0293 $ 1,017,A22.94 � 3.03% 5 ?4.88CA0 S - 239,000 $ A.0596 3 970.2M10.00 3.u3'� 5 '4.100.G0 S - 213,000 $ ..2394 5 902,988.00 3.03% 5 12.600.00 S - �90.SOD S 4.3139 $ 821,800.00 3.OQ'/c S 112nU.00 � - 184500 $ M1.385'�. 5 791.510.�0 3.00°/ 'S ?O.obDqp . - 189.000 S 4.33�i6 3 733.OA8.00 _UC'/� > >O.�J�q.OD S - 169.000 S n.3633 5 73"t.399.G6 7 ��� u ;,^0 , 169,000 S 4.3633 < 73/.3P9.6C I .0 Sj � .. (i.OG ., 16�J OUO 5 4287b 5 72n SOA CO '�, .'�i � U.;^:;.Of ., - 'Cal� ' i_a � :i'�..>�.:��� ;i`�C9 5 '434'0= ;.369.'2 1C1'?o0993�. 3�?:c� 00� � .. . . ._. .. .. .-.__' . . .. . . .... _. ... . _._.. _.__ . . . ._.._. .._,_ . . ... _" ' _ _ .. 5"38 585.CC S _..__ _ .. ___. � . ___ SC.059� .___ _ . Oct-11 hoc-12 Dam12 F'rr.�13 . �..-+.3 q�;:-._ Iv1aY. � 3 „� n- t 3 iul-i3 Nug-13 SeF-'3 o?ni cosr Resr.rv 8 Co�•�.m I2l1Tf�. 9GB.A520d 5 1.10G,227.5'I S t,166,20J.08 E 1 :�?.05:..4i� $ �, L3S . 'C6.335.r0 S i-72.60�21 S E�6.FiFi:..33 5 Ff257A5.45 5 AY32tf[.fiA 5 ^.2ft.2A2.64 S c12.21i 35 S 5.32 5.22 5,20 �.8E5 4.9U 5. "<0 5.7`� 4.97 4.9r� 4.90 4 90 4.81 E 11,9'14,859.80 3 5.C3 � Total Total TotalProjected D7H WACOG Rescrvation Commodity Cost Purchased ^:slGMcn;hs S 888,241.30 $ 5.7627G178 5 6751.003.08 1.32291.2 55.103 2nd6Mon!hs 5 SG8,350.63 3 4,655,506.09 S 5,763.856J2 1.047,000 54.932 TOTALS S 1,A96,591.93 S 10,418,267.87 E 11,914,859.80 2,369,922 ascf ViZ9013 __.__ _.'_ __ .- _____ _...____. G11 . rar..1on'h COMMODITY Payntent Cashout Adius�o�ent COST 50.020 � E 3,655.6A �� S 35,750.08 S 2,770.36 S 862,565.4? S 4,112.00 S 3,636.72 S 72M1.77 S 9A0,904.59 5 d,360.00 5 70,677.20 5 7.524.90 $ 994,8A1.90 S 4 J6U.G0 S - S - 5 '�. 043.814'!F3 fi 4.iUC.00 S - c - S 99�3?52' ': 4'lOG.00 .. > - S 925.?.59.9� J 5 ?760.u0 ,I " - - S Bnt.E7�9.,5 .. 3.560.00 � S �� - S Bt0463'�B . S .,40.._0 ( .i - . - S �%50 8".-,: . , t;l, . .. j a _ . , n � , � .� - _., �n7�;'8 . . ,. .,. � ., - 5 '4i �.,r.�') �_ . .. .Sb0,08AA0 J.3�C_03 514�.'&.76i b! j :�, _ -4 �... ,� t', i �� 0 I J � -s.✓_ .,.' Y ` f �4.r�' . ` ���...... ���Ka,n:.r a Propa��e Weigh:ed Ave�aGe Cosz ct C:s iWA;;OG) �,.,. � FY20i2 i3 Shippino Totai � FVTD i�-����v<��ri ar�a i �s� an ppmo I Uelrveretl � Rate Cost Cost Cost � Gall�n� � - - . _. . .._. , _... _____.. . ...YearEnd �� ��� i091301'i2 _._- _.. .__..._.. _ ___ . _ _. .. . . ToW Is _ _ 9 _. _.. V ... _ . _. . . _ . __. _ _. . _..... _.. _ . . . _ � 8,2�C ' 237 5 S 8 f92AC 5 �<52 65 5 �1C/1�4/12 !Tar a �72 528Cj . .. i7.999 23898 5� � 9 2d.9� S •,'7654'. c . ... . g : _. i7;OS9q'..'__ �� 8.495 � ;23fl98 S 9..3C.19 � 5 .,�9?.5< 5 7/3 /:Z MONTHI.Y livVENTORY ADJUS7MENT 275 0.98p95 5 265 76 5 � 5 - . _.. �.__ _ ._ _._. ._ , _..._. ._. .. /3V72 END OF MONTH � ._ j � �-� -; � � - � �- __ . . . . . _. ._ . . _ . _. . . .. ; ,•/OS/12 �_zr^ya �, ;2 C922C�. �� 9.29y 1.25832 �. S ^,6G'.7 . 5 ',.G3<.�? S I1V06112 af^ya .._ _ ',2 C9GG5; .. ... 9.299 , !23832 S 9880.19 ! 5 16;�.51 � S �: .' . __._ . ..' ..� � . .. - . .. ._ . .... . ._ _ y .. �2 38:_ 8,999 �...Z8698'� 5 965250' S ;,570.35 � 5 /12 �ar^a 2 C9798'�, /7</'2� a a • . . _ _ 9 � i $ 9 11 49 I$ ' S7C it $ /3C/?2 END OF M INVENTORY ADJUSTMENT C4 ?.59443 5 15C S2 � 5 S 1130M2 �MONTHLY ONTH . _ . ._. ... � __ . ._ ..__ . _. __ _... , . � ...__. .__...__ _'_- V " 1 __ . j '2/03/'2 Targa _ 72 '3808 9.F ,.12?65 S 900' 26 ; 5 ' 6635^ S 12/06/'2 Ta� a 72714t74�� I ' ;.V4C75 S � 86„' 9H ; S ',7333J ..$. B. 9,859 � 1 4832 I i2717/'2 'arga � 72i165C1 � 8.875 !._S 767688;5 1.554A3 5 , TarQa_ ...12' 76891 _._. .:. 5.980 �. 1.060' 5: S 8 832 30 � S 1.747.97 � S 72/18/12 I '2/31/12 MONTHLY INVENTORY ADJUSTMEM1T 353 2.59232 S 915 09 ! 5 S , . _ _ -- _ _ � _� 1 12/31/12 END OF MONTH � ' ._. I .4 ... , ... '�..... _,.� ._. _ .. .._ _is .�.. ..5 Ot/'4/13 ITar a 73 03647 19,006 0.88e00 � S '680' 3C � j ' � I ! . ��. _.. �, . _ . _.. .___. . .__ __ . ' � 1.22998 . . _ 85712 �... ... . . . _.. 1 ..._ i ��'. _.... ., ...81.240 - . . ._ _, FYTDTotals -� , �� ; S 6.729.13 � Month Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Delivered CGS Cost � $ S � S $ $ $ � � � $ 1.10 1.15 120 125 125 125 1.30 1.30 1.30 1.30 1.30 1.30 Delivered Delivered Gallons Cost 40,000 40,000 50,000 40,000 30,000 30,000 20,000 20,000 20,000 30,000 30,000 30,000 44,000.00 46,000.00 60,000.00 50,000.00 37,500.00 37,500.00 26,000.00 26,000.00 26,000.00 39,000.00 39,000.00 39,000.00 Projections Cost of inventon $ 117,268.72 $ 117,583.76 S 131,776.07 $ 123,300.41 $ 112,765.66 � 113,762.47 � 102,936.60 S 104,035.39 S 104,868.38 S 118,499.86 $ 119,140.46 S 119,573.69 Tota I Galions 102,676 102,676 112,676 102,676 92;676 92,676 82,676 82,676 82,676 92,676 92,676 92,676 _. _ � 5 6'I.367 19 � 4a65 �� 82 C� S i�,50584 72 a 0<& 26 99.� 5 9,,BC6 "s2 .,53C'3� ,i4,65S� 5 OG,33645�� 289/6�� ..... S '04GOGi:�,..�. � � ; 5 56,7C5.34 �.�8 � 4"3,357.G 5 68 Gv6 G2 � 5 ., 53 296 0 S 79 97 �7 � 222 8. 61 296.0 S 9' 144 3:. FS 6� 7' ?95.0 5 0+,,825 �6 _. 54 ' � 5 �01..58C a8 , , __ � S 68,d07.37 � 665 5'� 8 J95.0 5 79,072 57 .. ^, 335 35 � ., 65L.0 S 69 407 E7 92J 3'�, � 99529.0 5 95,635'& �� 58 77� 'C5505.0 5 092?945. . 95C9� S '0+345< ._._ .� ..... S 73 268 72 ' 6 80' 3G ?. _ . � . . . . ... , . 99.916: . ...- .. �� - EOM Tank Gallons 62,676 62,676 62,676 62,676 62,676 62,676 62,676 62,676 62,676 62,676 62,676 62,676 62,676 EOM Tank Cost 73;268.72 71,583.76 71,776.07 73,300.41 75,265.66 76,262.47 76,936.60 78,035.39 78,868.38 79,499.86 80,140.46 80,573.69 80,866.68 „iT,�_ ;3 WACOG' 57.2za . .. .. . . 1.1979C 5 � t2c 1 20'32 7� a23 � ' ? iG . 85 922 1.2 i G32 a6,i97 .. . 121 �S � 46,726 � � 39,<77 '121357 56 v25 . . . . 2't100 . 6S 3zc . . . . . • 22346 . �t s7a . .. . . . -+ 2263? s , 323 . . . i 2220Fi '. e �sa . . - .1 22935 55 645 ' 28,'123 1.2293$ a5 4,. � .. . 1 2 i 379 � 7 ,,,,4 .. . . . � ' 920G as s�s 1 17;97 � 93 859 ? 16365 ' sa.2-a'. .... -. 116901 ��.. .62,676 31,536 1.16901 �� P rojected WACOG 1.17 1.14 1.15 1.17 1.20 1.22 1.23 1.25 1.26 1.27 1.28 1.29 1.29 C S W:1 /22/2013 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Centrai Pasco Territory) Non-Fuel Enerqy CharqelTherm 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 ChargelTherm Minimum Monthly Bili (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 Rate perTherm 10/01/1973 Non-Utility Taxable Fuel/Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR FEBRUARY 1, 2013 - SEPTEMBER 30, 2013 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural Gas Rate Schedules RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL w/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 &+) 510.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 (u�18.00) (540.00) (570.00) ($160.00) ($40.00) (570.00) (�160.00) ($18.00) ($40.00) ($70.00) ($30.00) (530,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.08 0.08 0.08 0.08 0.08 0.08 0.08 NA NA NA NA NA NA 0.16 0.16 0.16 0.16 0.06 0.06 0.06 NA NA NA NA NA NA $0.85 $0.85 $0.85 $0.85 $0.73 $0.67 $0.61 $020 $0.15 $0.10 $0.20 $0.35 By Contract 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.61 1.56 1.56 1.56 1.56 1.44 1.38 1.32 0.91 0.86 0.81 0.91 1.06 0.61 + Non-Fuel $10.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $10.00 $25.00 $40.00 $20.00 $20.00 By Contract ($18.00) (540.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($18.00) ($40.00) ($70.00) (�30.00) (530.00) (By Contract) @ premise @ premise @ premise + FAC + FAC + FAC $ 1.43 $ 1.43 $ 1.43 $ 1.43 $ 1.32 $ 1.26 $ 1.21 $ 0.83 $ 0.79 $ 0.74 $ 0.83 $ 0.97 5 S 1.51 $ 1.51 $ 1.51 $ 1.51 $ 1.40 3 1.34 $ 1.28 $ 0.88 $ 0.83 $ 0.79 $ 0.88 $ 1.03 $ $ �o.�o� $ �o.�o> S (o.�o� $ (o.�o� $ (o.��� $ (o.�i> $ (o.��> $ (o.s�> $ �o.s�> s �o.s�> $ (o.s�� $ (o.s2> $ -31.0°/a -31.0% -31.0% -31.0% -33.0% -34.0% -35.0% -51.6% -53.0% -54.5% -51.6% -46.5% $0.069 $0.069 $0.069 $0.069 $0.069 50.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.641 $0.641 $0.641 $0.641 �0.641 $0.641 $0.641 $0.641 $0.641 $0.641 $0.641 $0.641 Interr. NG Rate NSS I� (Non-Resl) NA 100:000 8 up $50.00 $250.00 ($75.00) $400.00 Attachment #4 Contract NG Rate CNS NA By Contract (By Contract) 50.46 $0.28 By Contract NA NA NA NA NA NA NA NA NA 50.46 50.28 By Contract 0.71 0.61 0.61 1.17 0.89 0.61 + Non-Fuel $50.00 $250.00 Customer ($75.00) $400.00 Charge + + FAC + Nor-Fuel Therm Non-Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms 0.56 $ 1.07 $ 0.81 0.59 $ 1.13 $ 0.86 (i.��� $ (o.sa> � (o.as> -65.7% -45.6% -48.9% $0.069 $0.069 $0.055 $0.541 �0.641 50.555 BTU FACTOR = THERMS/100 CUBIC FEET (CCFI 10/2012 11/2012 12/2012 01/2013 02/2013 03/2013 04/2013 OS/2013 06/2013 07/2013 08/2013 09/2013 FY12/13Averaqe Firm Service Rates 1.033 1.036 1.033 1.037 1.036 1.035 Interruptible Service Rates 1.013 1.015 1.013 1.016 1.016 1.015 � (o.as) -58.2% $0.069 $0.541 CSW ' l2?_/20� 3 Attachment dk5 ---Page 1 of � BTiJ Factor �:".!; Gaiions!1GC cubic feet ;CCF; CLEARWATER GAS SYSTEM r��u Fac;or ��e3 ��r�e�ms��oo cueic teet (c�F) METERED PROPANE (LP) RATE BILLING FACTORS 1 her.n Factor 0,915 ihemis/Gallon FOR FEBRUARY 1, 2013 - SEPTEMBER 30, 2013 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMILY LOOP RESL. SMALL COML. LARGE 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) Month!y Customer Charge S10.00 $25.00 $10.00 $25.00 $40.00 $40.00 $50.00 Set By ConVact For Each Meter Non-Fuel Enerqy CharqeslGallon: Non-Fuel Energy Charge (NFF)/Gallor S1 90 $1.90 $0,90 S0.30 50.25 Set By Contract �1.00 Set By Contract Energy Conservation Adj.(ECA)/Gallor 0.13 0 13 0.13 0? 3 0 13 NA NA NA Regulato�ry Iropos�tion Adj !RIA)/Ga9or 0.08 G 08 0 08 O.GB QG8 NA NA NA Usage & Inflation Adj ;UTA)IGallon 0�16. 0_16 0.16 0 06 0 06 NA NA NA Total Non•Fuel Charges (NF)IGaI. $2.27 52.27 $1.27 $0.57 �0.52 Set By Contract �1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal. 1,92 1_92 1._92 1.92 1.92 Set Bv Contract 1.92 1:62 Total Energy Charges/Gallon �4.19 �4.19 $3.19 $2.49 $2.44 Contract NFE $2.92 Contract NFE + + Contract PGA $1.620 Customer Charge Customer Charge � Minimum Monthly Biil S10.00 525.00 $10.00 $25.00 $40.00 Any Applicable $50.00 Non-Fuel Fnergy Chg Utility_Tax Note_ F;�^�. 12a!e per Gellor, ^Ol01!19�13 G'��61 0.161 O.161 0-161 0.i61 Non-Util�'y Taxable F�.iel/Ga;lon �1.759 S1 759 51,759 $1.759 51.759 CY�ange tom 8/2008 Gallon I�ate S 0 05 � 0.05 $(0.15) $(0.25) �(0.25) ?�c Ch�nge'rom II/2.008 Gallon Rate 1,2% 1.2°/o -4.5% -9.1% -9.3% Customer Charge + Any Applicable Faciliry Charges 0 16? 0.161 Contract PGA - 0.161 S i]59 NA � 10.01) NA -0.3% for the Contrac;ed # of Gallons/Mo 0.161 Coitac! PGA.. �:, 1g1 NF1 NA CSW.1 /?_2l7_G? 3 Attachinent �t5 Page 1 0! 2 f3TU Factor 2714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTUFactor. 2.483 Therms/100cubicfeet(CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR FEBRUARY 1, 2013 - SEPTEMBER 30, 2013 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP (Non-Resl.Only) (Non-Resl.Only) Applicable Annual Gallon Range NA NA NA 0- 2,500 >2.501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (1 - 3 Units) (Closed for New Resl. Applications) MontY?ly Customer Cna!ge S?0.00 525.00 $10.00 �7_5.00 $4C.00 $40.00 �50.00 Set Eiy Contract For Each Meter Non•Fuel Enerqy CharqeslGallon: Non-(=uei L�iergy Charge INFEl!Gallor $^_90 $1.90 SC 90 S0.30 50.25 Set 13y Contract S1 00 Set F3y Contract Fi�:ergy Corservatior Adj !FCA)/Gallor 0 13 0.13 0.13 0.13 0.13 NA NA NA I�eguia,ory Imposition Adj.(RIA)/Gallor 0.08 0.08 0.08 0.08 0.08 NA NA N� Usage & Infiaticn Adj. (UTA)/Gailon 0.16 0 16 0.16 0.06 0_06 NA NA NA Total Non•Fuel Charges (NF)/Gal. $2.?_7 52.27 $1.27 $0.57 $0.52 Set By Contract $1.00 Set By Contract P�.:rchased Gas Adjustment(PGA)/GaL 1 92 1,92 1,92 1_92 1; 92 Set By_Contract 1_92 1.62 Total Energy ChargeslGallon $4.19 $4 19 �3 19 $2,49 $7_.44 Contract NFE $7_.92 Contract NF6 + + Contract PGA �,1.6?_0 Customer Charge Customer Charge + Mirimum Monthly E3ill 510.00 �7_5 00 $10 00 �25.00 $40.00 Any Applicable S5Q00 Nor-Fuel Fnergy Chg Utilitv Tax Note: Fuel Rate oer Gallon 10/01/1973 0.161 0.161 0 161 0.161 0.161 Nai-U!iiity Taxab!e Fuel/Gallen $1.759 $1.759 $1.759 $1.759 $1.759 Change from 8/2C08 Gallon Rate S 0.05 S 0.05 $(0.15) $(0.?_5; $(0.25) % ChBnge from 8/7008 Gallon Rate 1.2% 1.2% -4.5% -9.1% -9.3% Customer Charge + Any Flppiicable Facility Charges 0.161 0.161 Contract PGA - 0.161 $1 J59 NA S (001) NA -0.3% for the Contracted it cf GallonsJMo 0.161 Contract PGA - G 1 GI NA NA . csw �izzr2ois A,ttachment #6 Page 1 of 4 Residential Rate History By Components Clearwater Gas System Total Rate Adiustments/Therm Contract Month NG/therm LP/qallon * ECA RIA# WNA/UTA-Resl# UTA-Comll# PGA PGA OCt-12 S 1.48 $ 3.26 S 0.14 S 0.05 S 0.08 S 0.06 S 0.73 S 0.63 S Nov-12 S 1.48 S 326 S 0.14 S 0.05 S 0.08 S 0.06 S 0 73 S 0.63 S Dec-12 S 1.53 S 3.31 S 0.14 S 0.05 S 0.13 S 0.06 S 0.73 S 0.63 S Jan-13 S 1.53 S 3.31 S 0.14 S 0.05 S 0.13 S 0.06 S 0.73 S 0.63 S Feb-13 S 1.56 S 3.29 S 0.13 S 0.08 S 0.16 S 0 06 S 0.71 S 0.61 S Mar-13 Apr-13 May-13 Jun-13 Jul-13' Aug-13 Sep-13 Incr. Above $ Last Year Same Month incr. Based � on 40 Therms Equivalent Cents/KWH for Gas vs. FPC Rate (Residential) Gas Cheaper by .516 5 3.286 5 0.138 $ 0.056 S 0.116 5 0.060 5 0.726 � 0.626 5 .501 $ 3.548 , � 0.133 $ 0.031 $ 0.073 $ 0.067 � OJ85 $ 0.700 ; 0.03 $ (0.52) 5 - 5 0.06 $ 0.10 5 (0.02) $ (0.13) $ (0.15) $ 2°/a -14% 0% 300% 167% -25°/a -15% -20% 1.20 5 (20.80) 2% -14% 5.3 12.3 12.7 -58% 12.7 Note: This is Progress Energy's residential rate for usage >1,000 KWH in January 2013. -3% LP PGA/aailon 1.99 i .99 1.99 1.99 1.92 (0.68) -26% ' Based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & equai tc Residential LP Will Call (BRWCLP). # New rates implemented 1/1/2009, with following changes - RS NG Customer Charge increased S2 from S8 to S10lmonth & NFE rate droped 10 cents to 48 cents/therm (CC +S1/Mo. in 4;1/2005). - BRLP3 LP Customer Charge increased S18 from S72 to S90/year, and NFE rate raised 10 cent to S� 00/gallon (CC +12/Yr. Ir 4/i/2005). - EIA changed to RIA & WNA changed to UTA, but no additions to new components of these initially. - UTA implemented 1/1/2011 csw osns�2oi2 Attachment #6 Page 2 of 4 Residential Rate History By Components Clearwater Gas Svstem Total Rate Adiustments/Therm Contract LP Month NG/therm LP/qallon ` ECA EIA/RIA# WNA/UTA-Resl# UTA-Comll# PGA PGA PGA/aalfon Oct-08 $ 1.990 S 3.300 $ 0. i 40 S - S - $ - S 1.27^u S 1.190 S 2.260 Nov-08 S 1.990 S 3.300 � 0.140 S - 5 - S - $ 1.270 S 1.190 S 2.260 Dec-08 S 1 940 S 2770 � 0.140 S - S - $ - S i.220 S 1.140 S 1.730 Jan-09 S 1.750 S 2290 # S 0.090 S - S - S - S i.180 S 1.100 S 120C Feb-09 S 1.750 S 2290 $ 0.090 S - S - S - S 1.?8C S 1.100 S 1.200 Mar-09 S 1.580 S 2270 � 0.070 S - � - S - S i.030 S 0.950 S 1.200 Apr-09 $ 1.410 S 2200 $ 0.040 S - S - $ - S 0.890 S 0.810 S 1.160 May-09 S 1.410 S 2200 $ 0.040 S - � - S - S 0.89C S 0.810 5 1.160 Jun-09 � 1.410 S 2.200 � 0.040 S - S - S - S 0.890 S 0.810 $ 1.160 Jul-09 � 1.350 S 2.330 $ 0.040 S - S - S - S C.830 S 0750 S 1.290 Aug-09 $ 1.350 S 2.490 $ 0.040 S - S - S - S 0.830 S 0.750 S 1.450 Sep-09 S 1.390 S 2.650 � 0.070 S 0.010 S - S - S 0.830 S 0.750 S 1.570 FY 08/09 Avg. $ 1.610 $ 2.524 � 0.078 $ 0.001 � - $ - $ 1.026 5 0.946 S 1.470 2008 Avg. $ 1.965 � 3.186 '$ 0.136 S - 5 0.013 $ - � 1.237 S 1.157 S 2.138 Oct-09 $ 1.390 S 2.670 $ 0.070 S 0.010 S - $ - S 0 830 S 0.750 S 1.590 Nov-09 $ 1.390 $ 2.670 $ 0.070 5 0.010 S - S - S 0.83C S 0.750 S 1.590 Dec-09 � 1.390 5 2.750 � 0.070 5 0.0 i 0 5 - a - S 0.83C S 0.750 S 1.670 Jan-10; S 1.390 S 2.750 $ 0.070 S 0 010 S - S - S 0.830 S 0.750 S 1.670 Feb-10 $ 1.480 � 2.810 $ 0.110 � 0.010 S - S - S 0.880 S 0.800 S 1.690 Mar-10 $ 1.520 S 2.880 $ 0.110 $ 0.010 S - � - S 0.920 S 0.840 S 1.760 Apr-10 � S 1.520 S 2.880 $ 0.110 S 0 010 S - � - S 0.920 S 0.840 S 1.760 May-10 � 1.490 S 2.850 $ 0.090 S 0.030 S - $ - S 0.890 � 0.810 S 1.730 Jun-10 $ 1.460 S 2.950 � 0.090 S 0.030 S - S - S C.86C S 0.780 S 1.830 Jul-10 5 1.430 S 2.990 $ 0.090 � 0.030 � - � - S 0.83G S 0.750 S 1.870 Aug-10' � 1.390 S 3.090 $ 0.090 � 0.030 S - S - S OJ9C S 0710 5 1.970 Sep-10' $ 1.390 S 3.090 $ 0.090 S 0.030 � - $ - � 0.790 5 0.710 5 1.970 FY 09110 Avg. I$ 1.437 S 2.865 $ 0.088 � 0.018 5 - $ - $ 0.850 5 0.770 5 1 J58 2009 Avg. $ 1.464 $ 2.418 $ 0.061 � 0.003 $ - $ - 5 0.92Q S 0.840 ' S 1.353 Oct-10 S 1.47 S 3.02 $ 0.10 S 0.02 S - � - S 0.87 S 0.79 S 1.90 Nov-10 S 1.47 S 3.02 , S 0.10 S 0.02 S - S - S �.87 S 0.79 � 1.90 Dec-10' S 1.47 S 3.02 � 0.10 5 OA2 S - � - S 0.87 S 0.79 $ 1.90 Jan-11 $ 1.54 S 3.33 � 0.10 S 0.02 S 0.02 S 0.03 S 0 92 S 0.84 $ 2.19 Feb-11 � 1.55 S 3.37 � 0.13 S 0.03 S 0.02 � 0.05 S 0 89 S 0.81 S 2.19 Mar-11 � 1.55 S 3.37 S 0.13 S C.03 $ 0.02 � 0.05 S C.89 S 0.81 S 2.19 Apr-11 � 1.46 S 3.28 S 0.10 S 0 04 S 0.02 � 0.05 S C.82 S 0.74 S 2.12 May-11 $ 1.45 S 3.35 S 0.12 S 0.02 S 0.02 S 0.05 S C.8? S 0.73 S 2.19 Jun-11 � 1.45 S 3.35 S 0.12 S 0.02 S 0.02 S 0.05 S 0 8' S 0.73 S 2.19 Jul-11 $ 1.45 $ 3.35 5 0.12 $ 0.02 S 0.02 � 0.05 S 0 8� S 0.73 5 2-19 Aug-11 $ 1.42 $ 3.4& $ 0.12 S 0.02 $ 0.02 � 0.05 S 0.78 S 0.70 S 2.30 Sep-11 � 1.42 S 3.46 5 0.12 S 0.02 S 0.02 $ 0.05 S Q78 S 0.70 S 2.30 FY 10/11 Avg. $ 1.475 $ 3.282 $ 0.113 S 0.023 5 0.015 $ 0.036 S 0.843 5 0.763 S 2.130 2010 Avg. $ 1.457 5 2.946 $ 0.096 S 0.021 � - $ - $ 0.860 5 0.780 $ 1.829 Oct-11 S 1.47 S 3.63 S C 13 S G 02 S 0.02 $ 0.05 S 0 82 S 0.74 S 2.46 Nov-11 S 1.52 S 3.63 S 0.13 S 0 02 S 0.02 S 0.05 $ �.87 S 0.79 S 2.46 Dec-11 $ t56 5 3.67 $ 0.13 S 0 02 S 0.06 $ 0.08 5 C.87 S 0.79 S 2.46 Jan-12 5 1.56 S 3.89 5 0.13 $ C 02 S 0.06 $ 0.08 S Q�7 S 0.79 S 2.68 Feb-12 � 1.53 5 3.81 � 0.13 S 0.02 S 0.06 $ 0.08 S 0.84 S 0.76 S 2.60 Mar-12 $ 1.51 S 3.81 � 0.13 S 0 02 S 0.06 $ C.08 S 0 82 S 0.74 S 2.60 Apr-12 $ 1.51 S 3.81 $ 0.13 S 0 02 S 0.06 $ 0.08 S 0.82 S 0.74 S 2.60 May-12 $ 1.49 S 3.74 S 0.13 � 0.02 � 0.06 � 0.06 � 0.80 S 0.72 S 2.53 Jun-12 $ 1.48 S 3 6 i 5 0.13 S 0 03 S 0.06 S 0.06 S 0.78 S CJC S 2.39 Jul-12 5 1.48 5 361 S 0.13 5 0.03 S 0.06 S 0.06 S 0.�8 S C70 S 2.39 Aug-12 $ 1.48 S 3.23 S 0.13 S C 03 S 0.08 S 0.06 S 0.7E S C 68 S 1.99 Sep-12 � 1.48 S 3.23 S 0.13 S 0 03 5 0.08 S 0.06 S 0.7E S 0.68 S 1.99 FY 11112 Avg. $ 1.506 $ 3.639 $ 0.130 5 OA23 5 0.057 $ 0.067 $ 0.816 5 0.736 S 2.429 2011 Avg. $ 1.487 $ 3.438 5 0.'121 $ OA23 G 0.023 $ 0.051 $ 0.839 5 0.759 S 2.270 CSW:9/25/2012 Attachment #6 Page 3 of 4 Competitive History of NG vs. Electric Rates Month-Year NG Therm Cost September 2001 � 1.34 S September 2002 � 1.36 S September 2003 � 1.56 S September 2004 � 1.69 $ September 2005 S 1.97 S September 2006 � 1.89 �a September 2007 � 1.86 S September 2008 S 2.12 S September 2009 $ 1.39 $ September 2010 � 1.39 �a September 2011 S 1.42 S September 2012 � 1.48 � S Increase over Last 11 Years S 0.14 � % Increase over Last 11 Years 10.4% Avg. Annual Inc. Over Last 11 Yrs. 0.9% NG Equivalent KWH Cost 0.046 � 0.046 S 0.053 � 0.058 S 0.067 S 0.065 � 0.063 S 0.072 S 0.047 S 0.047 S 0.048 S 0.051 � 0.005 � 10.4% 0.9% 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.132 � ��: 57% 5.2% NG vs. Electric -46 % -37% -37% -35% -31 % -46% -47% -40% -64% -65% -62 % -62 % ICSW:11/19/2C12 Year 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 '2010 2011 2012 Attachment #6 Page 4 of 4 , Annual Average CGS Residential Rates Calender Year NG/Therm LP/ NA S 0.915 S S 1.049 S � 1.032 S $ 1.073 S S 1.222 S a 1.549 S S 1.342 S �a 1.534 � �a 1.652 S � 1.925 S $ 2.012 $ $ 1.893 S � 1.965 S � 1.464 S S 1.457 S S 1.487 $ $ 1.501 a * NA 1.239 � 1.380 " 1.288 " 1.311 1.584 1. 586 1.553 1.864 1.968 2.278 2.501 2.869 3.186 2.418 2.946 3.438 3.548 Fiscal Year Year NG/Therm LPIGallon '` FY 95/96 S 0.880 S 1.199 " FY 96/97 S 1.019 S 1.370 � FY 97/98 S 1.054 S 1.318 " FY 98/99 S 1.052 S 1.269 * FY 99/00 S 1.152 � 1.504 FY 00/01 S 1.551 S 1.649 FY 01 /02 � 1.352 S 1.488 FY 02/03 �a 1.477 S 1.817 FY 03/04 � 1.603 � 1.913 FY 04/05 S 1.803 S 2.162 FY 05/06 S 2.080 S 2.480 FY 06/07 S 1.918 S 2.742 FY 07/08 S 1.932 S 3.183 FY 08/09 S 1.61 G S 2.524 FY 09/10 S 1.437 S 2.865 FY 10/11 $ 1.475 S 3.282 FY 11 /12 S 1.506 S 3.639 Average $ 1.475 $ 2.174 $ 1.465 $ 2.141 Notes: * Based on the Residential Metered Propane schedule which was ciosed for new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & is equal to Residentiai LP Will Cail Clearwater Gas Sysferr : ��ye �i1"EC'CEC�` t•�:th Fuel Use and Cost Comparison (Effeciive Rates for February 2013) APPLIANCE ANNUAL THERMS USED ' COOKINU ' 4� WATER ��EATING ' -Gas Tu�ik Style/Grrs Tankless ', 170 / 100 ��� vs. Electric Tinzk S1yle '� F�EA"I�INU ' 150 '� CLOTF�IES DRYING '���� 50 _ _ _ ! 7'O"I�AL AYYLIANCE ' ' USAGE - with tank/tankless ' NATURAL GAS S 70.20 PROPANE (LP) GAS $162.00 $265.20 / $156.00x '� �'612.00/$3�i0.00Y �234.00 �540.00 � 78.00 $180.00 �647.40/ S� 1,494.00/ ,�',538.20'� S 1.242.00'�` GAS SAVI\GS VS. ' S8% / 65%X 3`% / 19%` ' ELECTRICITY '�tirhen zr.sin,� lankless *ivl�e�� tr.sin� lunkless- LI' ' OU"TDOOR RL'CREATIOI�T: ' POOL HEA"I�ING* 37� 558�.00 ' �1,350.O0 SPA/HOT "I�i�B I IEAT* l 75 S27 �.00 S 6�0.00 *varies accordin�� to pool size, weather conditions, and temperature maintained '� All other fi�ures are annual average projections bascd upon the following: �� l. 1 therrl� = 100,000 BTUs of energy ' 2. Naiural Gas '��, $1.56 per thernl � ��� 3. LP (las per gallon (BRt,P3) '��. $3.29 pei- ��allon or �3.60 pei- therill ��� 4. Progress Energy per KWH ', $0.1267� Per KWI I or S�.71 per therm '(Based on > 1000 K W I�i rate) '� 1 2 ELECTFZJC �166.�;�� $630. ?'�I �5�6.50 $185.50 $1,�35�.6� �1,3912� � 649.25 Notes: "[�hc above analysis is based oi� Februar�� 201 � residential ener���v and fuel cha�-ges and docs not ii�;;lude applicable ta�es or francllise fees. Curreni monthly customer char�es are: Pro��ress l�;nergy 58.76, Peoples Gas 512.00-��'0.00 (varies by ratc class)_ C'learwatcr Ga� Svstem �10.00 and �18.00 in Central Pasco. L.P. customers are billcd annually, S75-S210 (non-refundable) depcnding on program. 711 Maple Street • Ciearwater, FL 33755 •(727) 562-4980 www.ciearwater as.com _______----g---