Loading...
GAS ADJUSTMENTS EFFECTIVE MAY 1, 2012CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet "I�O: William B. Horne II, City Manager � FROM: �Chuck Warrington, Managing Director �4�" 's P■. , MAY 0 2 2012 OFFICIAL ii�CORpS AND l�ui�lATiVE SRVCS DEPT COPIFS. Rod Irwin, Assistant City Manager; Rosemarie Call, City Clerk; GS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; aura Damico, Sr. AccountantlCCS; Lynne Priester, Cust. Serv. Coord./CCS; Lindsey Bessette, Systems Analyst/CCS SUBJECT: DATE GAS ADJUSTMENTS EFFECTIVE MAY 1, 2012 Apri125, 2012 Gas supply prices have continued to drop this Spring; therefore, we are recommending a reduction in our Natural Gas PGA of 2¢/therm and a reduction in our LP PGA of 7¢/gallon for May. We also recommend that we continue our Contract LP PGA at 30¢ below our Standard LP PGA. We are not recommending any changes in our Energy Conservation Adjustment (ECA), our Regulatory Imposition Adjustment (RIA). nor our Residential Usage & Inflation Adjustment (UTA) for May. However, we are recommending a reduction in our Commercial Usage & Inflation Adjustment (liIA) of 2¢/therm or gallon for May, as this clause is balancing itself slightly faster than anticipated. The net effect of this recommended change for May is a reduction in our typical Residential Natural Gas customer's rate of 2¢/therm (-1.3%) and a reduction in our typical Residential LP customer's rate of'7¢/gallon (-1.8%). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after May 1, 2012: �latural Gas Firm Standard Rate Schedule PGA ..... Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA Propane (LP) Gas Standard Rate Schedule PGA ...... $0.80 per therm (down 2¢ltherm) ........... $0.72 per therm (down 2¢/therm) ....... $2.53 per gallon (down 7¢/galton) Propane (LP) Uas Contract Rate Schedule PGA ..................... $2.23 per gallon (down 7¢/gallon) I�ner�y Conservation Adjustment (ECA) ............................ $0.13 per therm or gallon (no change) Regulatory Imposition Adjustment (EIA) ........ . . . ... ..... .... $0.02 per therm or gallon (no chan�e) Usabe & In�flation Adjustment (WNA) - Residential ....._...... $0.06 per therm or gallon (no change) - Commercial .........$0.06 per thenn or gaL (down 2¢/thern,) William B. Horne II, City Manager April 25, 2012 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru March. Our objective is to be as close as practical to balance by FY ending. Attachments #2 and #� show our annual projections for Natural Gas and LP supply eosts, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #6, Page #1 shows our monthly rate history over the past 3+ years, and Pages #2 and #3 of this show our 10 year relationship to electric prices and average residential rates, respectively. Please note that Pa�e #2 of this analvsis shows that, over the past 10 years, our residential natural gas rates have risen iust 6 0% as comnared to a 53% increase for Pro�ress Eneray Florida's residential rates. That's an avera�e annual increase of 0 6%/year for natural �as vs. 5.3%/vear for electric --- a remarkabte difference� I should point out that the overall effect is that our tvnical Residential customer rates are now approximatelv 62% lower than electric for Natural Gas. This is a very attractive competitive position vs. electric rates and got even better this month as Progress Energy's rates increased in January. We will continue to track these balances each month, make monthly projections of these factors based on market conditions, and let you know if any of these get significantly out of balance. Bill, I would appreciate your approval of these revised adjustment rates so we can get this information to CCS in order to make the appropriate adjustments in the billing formulas in time for the May 1 s` billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: � �����`—� � ` �` - `���'-�.�i,.. � s� -- — Wi liam B_ Horne II, City Manager U:WIy DocumentsUVISOFFICE\WINWORD\GASR,4TES\Gas Adjustments for May 2012.docx CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 1 of 4- , _ __ _ _ _ _ _ _ _ . Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelTherm _ _ _ _ Month Charges Charges Expense Expenses _ Expenses Billed (Shortage) (Shortage) Firm/Contr _ _ Prior Year - $ (18,452.43) Oct-11 � 4,549,558.33 822 886.34 $ 92.26 $ 39,448 03 1 $ 5,411,984.96 $ 1,253,222J9 $(4,158,762.17) $(4,177,214.60) 0.82/0.74 Nov-11 S 175,157.39 830,572.12 $ 20,886.07 $ 39,127.23 $ 1,065,742.81 1,403,233.01 $ 337,490.20 $(3,839,724.41) 0.87/0.79 _ Dec-�1 $ 177,586.31 903,149.48 $ 19,198.62 $ 44,582.28 $ 1,144,516.69 1,618,956.68 � 474,439.99 $(3,365,284.42) 0.87/0.79 Jan-12 $ 184,060.19 986,867.23 $ 16,826.42 $ 41,11667 $ 1,228,87051 1,827,203.00 $ 598,332.49 $(2,766,951.93) 0.87/0.79 Feb-12 $ 175,926.37 872,802.88 $ 13,834.76 $ 43,522 34 $ 1,106,086.35 1,629,009.96 $ 522,923.61 $(2,244,028.32) 0.84/0.76 Mar-12 $ 173,027.27 864,297.97 $ 11220.14 $ 46,389.01 $ 1,094,934.39 1,594,658.26 $ 499,723.87 $(1,744,304.45) 0.82/0.74 Apr-12 $ 125,000.00 825,000.00 $ 8 721.52 $ 45,000.00 $ 1,003,721.52 � 1,425,942.47 $ 422,220.95 $(1,322,083.51) 0.82/0.74 May-12 $ 90,000.00 750 000.00 $ 6 610.42 $_ 45,000.00 $ 891,610.42 1,223,000.78 $ 331,390.36 $ (990,693.15) 0.80/OJ2 Jun-12 $ 90,000.00 700 000.00 $ 4 953.47 $ 45,000.00 �$ 839 953.47 1,146,563.23 $ 306,609.76 $ (684,083.38) 0.80/0J2 Jul-12 S 9Q000.00 700 000.00 $ 3 420.42 $ 45 000.00 $ 838 420.42 1,131,275.72 $ 292,855.30 $ (391,228.08) 0.80/0.72 Aug-12 $ 90,000.00 700,000.00 $ 1956.14 $ 45,000.00 $ 836,956.14 1,131,275.72 $ 294,319.58 $ (96,908.51) 0.80/0.72 _ . __ Sep-12 $ 90,000.00 700,000.00 $ 484.54 $ 45,000.00 $ 835,484.54 1,131,275.72 $ 295,791.18 $ 198,882.67 0.80/0.72 Per13 $ 189,566.62 . - . . . 6 $. . 189 566.62 _ $ (189 566.62) $ 9,316.05 Total YTD $ 6,199,882.48 $ 9,655,576.02 $ 108,204.79 $ 524,185.56 $ 16,487,848.85 $ 16,515,617.33 $ 27,768.48 _ . _ __- -- - -_ _. . _ --. _. _ - __ _ _ __ . (1) Includes Annual Admin Charge of $708,720 + CCS chg of $1,052 690 + Dividend $1,300,720 _ _ ___._ _ _ _ . _ __ _ _ _ _ _ + FY 10/11 PGA write off of $27,099.40 + WNA $304.10 _ __ _ . _ _ _- _ _ . _ __ _ _ ___ _ _ _ + d Dividend based on FY11 Net Profit $1,351,278 = $ 4,440,811.50 _ _. _ __ __ _ _ __ _ _. ____ (5) Commodity adjustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Rate NG Proportion = 97.9% x Total ECA Transfer = $ 189,566.62 _ - ._ Net RC = 5 1,569,504.36 Average Annual PGA/Therm = $0.792 Avg Fuel Only = $0.463 _ . __ _ _ , _ _ _ Delta/Therm = $0.33 _ _ _ _._ �. _._ _. _ _ _ . PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) _ _ . _ _ _ _ _ . _ _ _ _ _ Monffily Cumulative LP PGA - Budget Gallons Monthly Interest Commodity Total LP Fuel Totai LP PGA Overage YTD Overage ThermlGal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) -_ _ . _ _ . _ Prior Year $ (44,746.06) Oct-11 34 240 2$ 1.80693 $ 223.73 $ 61,869.64 � 1 $ 309 923.54 $ 83,495.97 $ (226,427.57) $ (271,173.63) 2.24/2.46 Nov-11 29,551.0 $ 1.80024 $ 1355.87 53,198.89 54,554.76 72,604.41 $ 18,049.65 $ (253,123.99) 2.24/2.46 Dec-11 36,513.7 $ 176919 $ 1265.62 64,599.67 65,865.29 89,690.65 $ 23,825.36 $ (229,298.63) 2.24/2.46 Jan-12 40,655.9 $ 170188 $ 1,146.49 69,191.46 70,337.96 108,525.84 $ 38,187.88 $ (191,110.74) 2.45/2.68 Feb-12 36,7707 $ 1.59737 $ 955.55 58,736.41 59,691.97 96,048.39 $ 36,356.42 $ (154,754.32) 2.38/2.60 Mar-12 39,974.9 S 1.56045 $ 773.77 62,378.83 63,152 60 103,536.58 $ 40,383.98 $ (114,370.35) 2.38l2.60 _ _ . _ . _ _ . _ _ _ . Apr-12 34,000.0 � 1.49000 $ 571.85 50,660.00 51,23185 87,742.99 � 36,511.13 $ (77,859.21) 2.38/2.60 May-12 32,000.0 $ 1 47000 $ 389.30 47 040.00 47,429 30 80,358.28 $ 32,928.99 $ (44,930.22) 2.31/2.53 Jun-12 30.000.0 $ 1 48000 $ 224.65 44,400.00 + 44 624.65 75,335.89 $ 30,711.24 $ (14,218.99) 2.31/2.53 _ ___ __ _ _ _ Jul-12 28.000.0 $ 1.49000 $ 71.09 41720.00 41,791.09 70,313.50 $ 28,522.40 $ 14,303.42 2.31/2.53 - _ . _ _ Aug-12 28,000.0 $ 1.49000 $ (71.52) 41,720.00 ._ 41 648.48 70,313.50 $ 28,665.01 $ 42,968.43 2.31/2.53 -- - - Sep-12 28,000.0 $ 1.52000 $ (214.84) 42,560.00 42,345.16 70,313.50 $ 27,968.34 $ 70,936.77 2.31/2.53 P13 . _4 _ 70,236.12 ' . __ -$ (70 236 12). $ 700 65 Total YTD 397,706.4 $ 1.60439 $ 6,691.57 $ 638,074.92 $ 962,832.78 '$ 1,008,279.49 $ 45,446.71 _ ___ __ __ __ _____- ,___ Cost Center Expenses --__- ---__ _____ _- -----. _ _ _ ____ __ ___ _ . _ _ . _ CCS Chg, Admin & Dividend �$ 184,114.00 1 _ __ ____-- -____ :_- _ _ _ _ _ _ _ FY 10/11 Write off PGA & WNA _ _ . __ _ . $ __ ____ 1 _ _ _ _ __-- ___ ___ Fuel __ .. . _ __ . _ _. _ _ _ __. ._ _ _ _ _ _ _ . . $ 15 000 00 1 _ _ , _ _ _ _ _ __--- Donations to events � ___ _ _ . __ _ _ __ _ - - _ $ 10,203 64 1 __ _ _ - - _ _- - LP Yard Vaporization/loss due to malfunctioning meter $_ 341.45 1 (4), Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate LP PGA Event fuel cost $ 3,756.85+ 1 LP Proportion = 2.1 % x Total ECA Transfer = $ 4,066.29 _ _ -- - __ _ Suburban Software Systems $ - 1 +Additional Projected Costs Needed = $ 66,169.83 - ___ _ _ - - _ Depreciation of LP tanks $ 34,414.23 1 _ _ Suburban Software Systems license __ _ _ _ _ . $ __. _ _.__1_ _ _ _ _ _ _ . _ - - _ - _ _ __ __ _. __ - Contribution to garage LP trk up grade $ - 1 _ __ _ __ __ __ _ LP Hoiding Tank Restoration $ - Proj. Ann. Costs Add'I. Proj. Costs . _ _ __ $ 247,830.17 $ 314,000.00 $ 66,169.83 CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 2 of 4� ENERGY CONSERVATION ADJUSTMENT (ECA) � Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NG/Therrn Month Expenses Notes/Exceptional Items Expense CNG Station Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - __. Oct-11 $ 570,285.44 Promo$54,767,Adv $0, Employ Costs$69,819 $ - $ 2,534.54:: 1 $ 572,819.98 S 100,694.45 $ (472.125.53} $ (472,125.53) 0 13/0 13 _ . _ ,, _ __ _ _ . Nov-11 S 89,882.26 Promo$24,249,Adv$5,OOO,EmployCosis$61,073 $ 2,360.63 $ 439.25'" 92,682.14 138,769.26 S 46,087.12 S (426.038.41) 0.13/0.13 _ _ __ _ _ DeC-11 $ 90,222.82 Promo$32,925,Adv$300,EmployCosts$56,998 $ 2,130.19 $ 1,470.63 93,823.64 165,173.14 $ 71,349.50 $ (354,688.91) 0.13/013 ___ __ _ _ _ _ _ _ _ _ _ _ _ _ _ . Jan-12 � 164,412.37 Promo$102,771,Adv$O,EmployCosls$61,641 $ 1,773.44 $ 2,773.58 168,959.39 203,035.53 $ 34,076.14 $ (320,612.77) 0.13/0.13 _ _. __ _ _ _ _ _ ---- _. _ _ _ __ _ _ _ . _ Feb-12 $ 135,098.18 Promo$71,307,Adv $250, Employ Costs$63,541 $ 1,603.06 $ 3,632♦70 140,333.94 183,171.76 $ 42,837.82 $ (277,774.96) 0.13/0.13 _ ___ _ . ___ ---- ___ .__--- -- - - - _- --- - -_ _ _ M8f-12 $ 135,745.90 Promo$50,233,Adv$250,EmployCosts$85,263 $ 1,388.87 $ �$,1�30.94� 145,265.71 178,294.06 $ 33,028.35 $ (244,746.61) 0.13/0.13 APr-12 $ 100,000.00 . . -_ . . $ . - - 1,223.73 $ 4,000.00 . . . - 105,223J3 . . 151,612.89 !$ 46,389.16 $ .. (198,357.46) 0.13/0.13 May-12 S 100,000.00 :$ __ 991.79 $ 4,000.00 104,991 79 133,458 60 $ 28,466.81 $ (169,890.65) 0.13/0.13 Jun-12 $ 100,000.00 �$ 849.45 $ 4,000.00' ^ 104,849.45 125,117.43 $ 20,267.98 $ (149,622.67) 0.13/0.13 Jul-12 $ 100,000.00 . . $ - 748.11 $ 4,000;00 --T - 104,748.11 ^- 123,318.36 � $ 18,570.25 . $ (131,052.42) 0.13/0.13 Aug-12 $ 100,000.00 - . . � $ -. . -655.26 $ 4,000.00 - - . - - 104,655.26 + 123,318.36 $ 18,663.10 $ (112,389.33) 0.13/0.13 ____ __ -- -- - __ _ -- -._ - -- - -_ Sep-12 S 200,000.00 Pay down $100,000 of NGV Stalion Costs $ 561.95 $ 4,OD0.00 204,561.95 123,318.36 $ (81,243.59) $ (193,632.91) 0.13/0.13 P13 � . _ _ . 193,632.91__ $ 193,632.91 _ $ Total YTD � 1,885,646.97 $ 14,286.50 $ 42,981.64 $ 1,942,915.11 $ 1,942,915.11 $ - . _:_. _ _ _ _ (1) Includes Annual Admin Charge of 546,450 + CCS chg of $55,930 + Dividend $69,090 (6) = Transfer of ECA Collected in PGA @ 1/2 of the ECA Rate (up to ECA Annual ShoRfall) _ _ + FY 10/11 Write off of $2,454.47 + 3200,000 SNEP Note: Maximum amount which can be transferred = $ 874,641 10 +ndd'I Dividend based on FY11 Net Profit �71,775 = $ 445,699.47 . . _. _ _ _ _ _ _ __ __ . _ . _ ___ _ _ __ ._ _- . - - __ _ _ _ _. _ _ . Net CCE = 1,497,215.64 _ ___. _ _ _ __ _ ___ . �-- . --- _ _ _ _ _ _ _ __ REGULATORY IMPOSITION ADJUSTMENT (RIAI (EIA) . _ _ _ _ fo�) _ _ _ _ _ _ __ Budget Environmental Regulatory Interest Total RIA Total RIA Overage YTD Overage NG/Therm _ -_ _ ... _ _ _ _ Month Expenses Notes/Exceptionalltems Expenses Expense Expenses Billed (Shortage) (Shortage) LP/Gal. _ _ PriorYear - $ - $ (161,500.70) _. _ Oct 11 $ 12,390.53 - $ 807.50 1 $ 13,198.03 19,520.29 $ 6,322.26 $ (155,178.44) 0 02/0.02 Nov-11 $ 1,324.00 - $ 775.89 2.099.89 21,322.53 $ 19,222.64 � (135,955.81) 0.02/0.02 _ Dec-11 $ 3,140.90 - $ 679.78 3,820.68 24,412.10 S 2Q591.42 $ (115,364.38) 0.02/0.02 __ __ _ Jan-12 $ 1,324.00 - $ 576.82 1,900.82 31,235.92 $ 29,335.10 $ (86,029.29) 0.02/0.02 _ __ _ _ Feb-12 $ 2,195.00 - $ 430.15 2,625.15 28,175.63 S 25,550.48 $ (60,478.80) 0.02/0.02 . __ __ _ _ _ Mar-12 $ 1,329.00 . _ _ (2.36) $_ _ 302.39 __ 1,629.03 27,424.72 $ 25,795.69 � (34,683.12) 0.02/0.02 _ Apr-12 $ 10,000.00 $_ 17342 10,173.42 23,934.58 $ 13,76116 $ (20,921.95) 0.02/0.02 _ _- _ May-12 $ 10,000.00 $ _ 104.61 , 10104.61 21,068.63 $ 10,964.02 $ (9,957.94) 0.02/0.02 - � --- - -- _ __ Jun-12 $ 10;000.00 $ 49 79 10,049 79 _ 19,751.84 $ 9 702.05 $ (255.89) 0.02/0.02 __ - , _ _ --- __ ---- -• - Jul-12 $ 10;000.00 . $_-_ - 1 28 - 10,001.28 19,467.82 $ 9,466.54 $ 9,210.65 0.02/0.02 _ _ _ _ _ , - - . -- _ __ _ �— _- - --- - Aug-12 $ 10,000.00 $_ _(46 05) 9,953.95 . 19,467 82 $ 9,513.88 $ 18,724.53 0.02/0.02 . - -_ - __._ _._. _-- - Sep-12 $ 10,000.00 . . - $_-- ___ (93_62) _ 9,906.38 19,467.82 . $ 9,561.45 $ 28,285.97 0.02/0.02 P13 . _ _ _ - -- $ - --- --- - - . _._ $ _ $ 28,285.97 $ - - $ - $ 28,285.97 --- - - Total YTD $ 81,703.43 $ (2:36) $ . 3,761.96 . .- 85,463.03 _ 275,249 70 $ 189,786.67 .. . _ _ _ _ _ _ _ . __ _ _.. _ (1) Includes annual charges for Admin Charge $10,450 __ FY 10/11 Write off of 3616.53 CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 3 of 4" UJHUt HIVU IIVI'LHIIVIV HUJUJIIVItIV I IU�H) Commercfal __ _ _ _ _ _ Monthty _ 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. . _ . ___ _ _ __ _ _ . _ . _ _ -_ $ - $ (644,952.53). Oct-11 . . 5,770.0 $ - 3,224.76 . 0.05 • f 748,591.5 . .. 0.05 $ 34,465.20 $ (610,487.33) 0.05/0.05 Nov-11 . . 5,895.2 $ 3,052.44 " _ . . . 0.05 - - . - 818,028.9 . . 0.05 � $ 38,234.32 $ (572,253.01) 0.05/0.05 Dec-11 . . .. 7,631.7 $._ 2,861.27 0.08 1 946,953.4 0.08 $ 65,040.78 $ (507,212.22) 0.08/0.08 _ _ . _ _ ._ _._ __ ,_ _ - - . _ _ Jan-12 7,713.4 $ 2,536.06 0.08 1,122,897.5 0.08 � 87,455.32 $ (419,756.91) 0.08/0.08 _ _ __ _ _ _ _._ -- _ _ . _ . _ _ . _ Feb-12 7,803.7 $ 2,098.78 0.08 1,025,942J 0.08 $ 80,764.92 $ (338,991.99) 0.08i0.08 _ _ . _ _ __ . _ _ __ _ _ _ _ __ Mar-12 7,254.0 $ 1,694.96 0.08 1,027,935.0 0.08 � 80,817.85 $ (258,174.14) 0.08/0.08 _ _ _ _ __ Apr-12 7,000.0 $ 1,290.87 0.08 925,000.0 0.08 $ 72.696.00 $ (185.478.14) 0 08l0.08 __ _ . _ May-12 6,500.0 $ 927.39 0.08 725,000.0 0.08 $ 42,792,75 $ (142,685.39) 0.06/0.06 _ _ _ . _. ___._ _ Jun-12 6,500.0 $ 713.43 0.08 ' 700,000.0 0.08 $ 41,330.25 $ (101,355.14) 0.06/0.06 _ . __ _ . >._ __ _ Jul-12 5,500.0 $ 506J8 0.08 650,000.0 0.08 $ 38,346J5 S (63,008.39) 0.06/0.06 _ _ _ _ _. _ _ _ Aug-12 5,500.0 $ 315.04 0.08 650,000.0 0.08 $ 38,346.75 $ (24,661.64) 0.06/0.06 _ ___ _ _ _ _ _ _ _ _ . _ _ . _ _ Sep-12 5,500.0 $ - 0.08 650,000.0 0.08 $ 38,346.75 $ 13,685.11 0.06/0.06 _ _ _ . _ Per13 Total YTD 78,568.0 19,221.78 9,990,349.0 $ 658,637.64 _ _ _ . _ _ __ _ . _ _ _ _ __ _ _ _ _ - - _ _ . ___ _ _ _ (1) December Overage is reduced by $8,293.09, which was the FY 10/11 interest that was erroneously left out of the adjustment calculation. _ __ _ _ _ __ _ _ _ __ _ _ _ . . __ __ ___ _ _ _ - _ JSAGE AND INFLATION ADJUSTMENT (UTA) _ . _ _ _ _ --- - __ �esidential Monthly Cumulative UTA _ _ _ __ . _ . _ Budget Interest Overage YTD Overage NG/Therm _ . . - _ _. . _ _ -- _ _ _ _ - _ __ _ Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm (Shortage) (Shortage) LP/Gal _ . _ . __ _ _ ._ _ _. _ _ . 3eg. Bal. $ - $ (180,801.96) _ _ _ _ _ _ _ _ Oct-11 28,470.2 $ 904.01 0.02 194,083.1 0.02 $ 3,541.17 $ (177,260.79) 0.02/0.02 _ _ . _ _ _ _ _ _ _ Nov-11 23,628.7 $ 886.30 0.02 219,872.8 0.02 �u 3,986.29 � (173,274.50) 0.02l0.02 _ _. _ __. _ . Dec-? 1 27,524.4 $ 866.37 0.06 1 288,762.0 0.06 $ 17,259.34 $ (156,015.17) 0.06/0.06 _ _ _ _ _ _ _ _ Jan-12 32,310.3 S 780.08 0.06 405,103.4 0.06 $ 25,463.36 $ (131,331.88) 0.06/0.06 _ _ . _ . _ _ _ _ _ _ _ _ _ Feb-12 28,950.7 $ 656.66 0.06 344,333.4 0.06 $ 21,738.00 $ (110,250.54) 0.06/0.06 . __ _ _ _ _ _ _ _ Mar-12 32,110.4 $ 551.25 0.06 307,976.2 0.06 $ 19,819.82 $ (90,981.97) 0.06/0.06 . _ _ ___ _ __ _ _ ____ __ Apr-12 25,000.0 $ 454.91 0.06 300,000.0 0.06 $ 18,915.00 $ (72,521.88) 0.06/0.06 __ _ _. . __ .__._ May-12 20,000.0 $ 362.61 0.06 225,000.0 0.06 $ 14,259.00 $ (58,625.49) 0.06/0.06 _ _ _ _ . _ _ --_ .___ _ Jun-12 20,000.0 $ 293.13 0.06 175,000.0 0.06 $ 11,349.00 $ (47,569.62) 0.06/0.06 Jul-12 20,000.0 $ 237.85. . 0.06 . . 175,000.0 0.06 .$ 11,349.00 $ (36,458.46) 0.06/0.06 --- _ _ _ _ . _ _ __ _._ -- _ Aug-12 20,000.0 $ 182.29 0 06 175,000.0 0.06 $ 11,349.00 $ (25,291.76) 0.06/0.06 -- . _. _ _ _ Sep-12 20 000.0 $ 126 46 0 06 j_ 175,000.0 0.06 $ 11,349.00 $ (14,069.22) 0.06/0.06 _ _ __ - -___ _ - - -_ _. _ _ _ _ _ _ Per 13 . _ . _ - - - 7- $ -__-- - --- - _ fotal YTD 297,994J 6,301.92 2,985,130.9 $ 170,377.98 _ _ _ _ ___ ___ __._ _ ._ _ __ _ _ (1) December Overage is reduced by $723.06, which was the FY 10/11 interest that was erroneously left out of the adjustment calculation. __ _ _ _ _ _ _ _ _ _ _ __ _ _ _. _ __ _ _ _ ___ ___ . _ _ _ _ . . _ _ _ ___ _ _ . _ __ _ _ _ _ . __ _ _ _ _ __. __ _ _ . _ _ _ _ . _ _ _. . _ _ _ . -- _ _ _ _ _ . CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2011/2012 Page 4 of 4' _ _ . . _ _ _._ . _ TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA+UTA) ' . _ . . _- _ _ --- _ . _ _ _ Monthly Cumulative Total Resl Budget Total All Total Recovery Overage YTD Overage NG/Thm (Firm) • - � _ . - - _ __ Month ,_ _ Expenses Billed (Shortage) (Shortage) LP/Gal (Resl) _ __ ___ .- _ — -__ - _ ---- •- - - - __ PriorYear . . _ $ . $ (1,050,453.68) - ---- -- - Oct-11 _ _ __ _ _ _. - -_.._ _ -_ _ ..------ -._----- ___ ____ .._____ $ 6,307,926.52 $ 1,494,939.87 � $ (4,812,986.65) $ i5,863,440.33) 0.99/2.63 --___ --__ -- - _ _._ � __-- ----- _ - --- - _ _ Nov-11 , 1,215,079.60 $ 1,678,149.82 $ 463,070.22 $(5,400,370.12) 1.04/2.63 __ . . -__ _ _-- . _ . -- - ---- -- -_ _-- -- Deo-11 1,308,026 31 $ 1,980,532.69 $ 672,506.39 $(4,727,863.73) 1.08/2.67 _ _ __ __ . _ __ ------- .--- --- -- �- - __ -- - Jan-12 ... 1,473,384.82 $ 2,282,918.97 $ 809,534.15 $(3,918,329.58) 1.08/2.89 - . __.. . _ __ __ - -- _ _--- - -.. ( � Feb-12 .. .._. 1,311,492.85 $ 2,038,908.66 $ 727,415.81 S 3,190,913.77 1.05/2.81 . _. _ _... _. _ __ ____._ . . - -- _._ __ _ . Mar-12 1,307,227.96 $ 2,004,551.29 $ 697,323.33 $(2,493,590.44) 1.03/2.81 _ _ _ __ _._ __ -_ _ Apr-12 1,172,096.30 $ 1,780,843.92 $ 608,747.62 $(1,884,842.82) 1.03l2,81 _ _ __ _ _ May-12 1,055,426.11 $ 1,514,938.03 $ 459,511.92 $(1.425.330.90) 1.01/2.74 _ . Jun-12 1,000.483.91 $ 1.419,447.64 $ 418,963.72 $(1,006,367.18) 1 01/2.74 Jul-12 995,705.53 $ 1,394,071.15 $ 398,365.62 � (608.001.56) 1,01/2J4 Aug-12 993,711.17 $ 1,394,071.15 � 400,359.98 $ (207,641.58) 1.01/2 74 Sep-12 1 092,424.48 $ 1,394,071.15 $ 301,646.66 $ 94,005.09 1 01/2 74 Per 13 259,802J4 $ 193,632.91 $ (66,169.83) S 27,835.26 Totai YTD . 19,492,788.31 20,571,077.25 $ 1,078,288.94 _ -_ -___ . _ _ _ _ __ _ _ _ __ _ __ ._ _ . _ . __ _ - _ _ _ _ . _ _ __ _ _ _ ._ . _ _. _- ____ _ . __ _ ----- _ _ _ _ Last Updated 04/25/2012 /� �"`i"1�-�.. t� /Yl �� i°. _ �� .�.., -------•--___.-�-�. CGS Natural Gas Cost Actual/Projections FY12 as ot 4112/2012 �t�otal 2,652.052 572,174 267,600 1,087,771 (736,451) ($162,534.89) 2,136,455 1,150,181 2,089,000 3.34% 105.8 % $5.22 Ocb Nov Dec- Jan- Fob- Mar• Flpr- May- ,iur,- Jul- Aug- Sep- Tolal $1244,87322 $411,107.02 $10,409.64 $18,495.50 ($2,42728) $10.008,012.44 $ (323,063.70) $264,184.69 $133.371.00 89.8% E9.9 % $11,149,894.29 Total Projected DTH WACOG Total Reservation Toial Commodit Cost Purchased 1st6Months $ 1,041,039.25 $ 5,804,149.57 $6,436,68079 7,222,855 $5264 2nd 6 Months $ 625 350.63 $ 4 203,862.67 $4713,213.50 913,600 $5.159 TOTAL $1,666.389.88 $ 70,008,012A4 $11.149.89429 2,136,455 �5.22 Propane Weighted Average Cosl of Gas (WACOG) / + � ( �C'µ �'""'�'� � ^ �,,,3 4l12/2012 . FY 2011-12 Involce Gallons Propane Propane Shipping Total FYTD Cost of Tank Tank y�ACOG Datc Com an SeaJ lBLShI in Delivered Rate Cost Cost Cost Gallons Invento Invento Withdrawl 09/10/10 �! . .1- . .. � :�:YBef Epd TOt2U �.� � � � � � � S 98,291.86 , 21,259 1.60121 ��'. �__ � __ �- _-_ '� -" __- _ '__ __-__' � I 30058, 1.81275 � -- - _ 170A4187 8799 1.84064 � S 74,672.3� S 1.523.48 S 16,795.82 17,798.0 _ - �_-�_--... 10/03/11- �Tarya _'� 11043981 � 8,999 1.84084 y 15,005.84 . 5 1,558.11 I 5 16,563,g5 ��I 8,799.0 5 7�,051 63 '�___ 39,057 �, 1.81918 �. 0/03/11 Ta_r a _ 10/O6/11 'Targa_ �. .� 71044632�... j 9.899 1.77997 S 15912.65 5 1.70732 �. S 77.679.97 i 27.697A . 5 88,67160 A8956 _�� ���1 81125 �'. 10/23/11 Tar a 11048067 9.999 1]8335 S 16123.39 � _g � 1,708 32 I S V,831.71 37,696A �. E 106,503 31 � 5B 955 � 1 80G52 . -.� �-_-�_-�---�~-.._-.. __ . .._ -_.. 10/31/10 . MONTHLY INVENTORY ADJUSTMENT � 85 ��. 2.09176 � S 177.80 � 5 - S 177.80 ! S 106,681.11 � 59 040� 1 80693 11/03/11 7a�ga ^ 1/0 8 17,399 774317 $ 27 316.93 ' S 3�.012.50 ' S 30 329.43 � 64 295 0 870 17 23 172 i �� 35 868 � 1 80693 , _- _. --�- _- _. __ , 10/37/10 jEND OF MONTN ___�896.0 5 5$,11� 07 32 372 1 79520 � 11/05/11 Tar9a �__ ��71050340! 17.400 1.73814 S... 27,231.00.I. .. ... . .� � S 88,443 50 . 49 771 ' .. .. 1 77701 -.��. - � _ _ _ ' � �... 5 9,012 67 I 5 30.243.67 ; -- .. . . _ _ _ 4 ,695.0 S 118,68717+ 67 171 �_ 1.76694 17/30/11 'MONTHLYINVENTORYADJUSTMENT 1,653 3.15339 S 5,202,99 i. S 9.56 S 5,272.55 ! S 723,89972 I 68,824 � 1.80024 ��. ll/30/11 END OF MONTH � � � � �� � E 60,606.88 I 33,666± �5,158 � 1.80024 '� 12/02l11 7ar a � 11055207 � 9,000 174798 S 14,107.50 5 1,570.31 S 15,677.81 , 90,695.0 S 76,284.69 ��. 42,666 '� 1.78795 ��� 12/06/11 Tar a 11055719 18,001 1.74698 S 28,306.57 S 3,14079 S 31,447.36 108,696.0 S iW,732.05 60,667 1.77579 ��. 12/07/11 Tar a 11056067 � 9,000 1]4698 i S 14,152.50 S 1,570.31 . S 15,722.81 717,696.0 E 723,454.86 69,667 1.77207 ��� 12/12111 tiTarga_ i 11057240 ' 8,999 1.73698 S 14,060.94 S 1,570.74 S 15,631.08 126,695.0 5 139,085.94 ' 78.666 i _ 1.76806J -_ _ __- i2/37/11 �iMONTHLYINVENTORYADJUSTMENT 349 2.02430 S 706.48 b 706.48 5 139,792A2 79,015 1.76919 �� -_- 12/37l11 ENDOFMONTH � � � � ��� �� �� � � � S 77,218.00 43,646 J5,369 1.76919'I Oi/03i12 _�T�-f � 12060622i . �..9.204 �.� 1.64930 S� 13,598.91� S 1.58728 5 15.180.19 135,899.0 S 92,398.19'� 52.850'. 1.74831 ''.. 01/04!12 � Tar a 1 12061470 � 9,000 1.65614 S 13,365.00 E 1,54022 S 14,90522 744,899.0 5 107,303.41 61,850 1.73490 ��� 01/06i12 Tar acL_�_ 12062114 i 9,000 1.67864, E 19,027.50 � S 1,540.22 S 14,56772 153,899.0 5 127,671J3 � 70,850 1J2013 ��.. 01/10/12__�Targa 12062575� 9,000 7.57364' S 12,622.50 5 1,54022 S 14,162.72 162,899.0 S 136,033.65 i 79,850' 1J0362 �'� 01/31/12 'MONTHLY INVENTORY ADJUSTMENT 637 1.48392 E 94526 E 945.26 S 136,979J 1 -80,487 -�'- 1.70188 � 01/31/12 fEND OF MONTH � � � � � � � � � � � E 62,074.3T 96,474 ! 44,017 1.70188 ��, 02/O6l12 iTai ac�___ 120fi765y6: '� 9,400 �� 7.53064 i S 12,760.50 S 1.627.53 �' S 14,388.03 ' 772,299.0 S 76,462.35 �� 45,874 '�� 1.66679_ 02/07�12 ���,Targa 72067999 � 18,298 1.51686 � S 26,248.48 i 3 7,507.05 5 27,755.53 190,597.0 '� E 104,217.88 6M1 172 i 1.62404 _�._-- - 02/08!12 �Tarqa ' 120682621 � 9,000 1.51131 E 12,037.50 .: $ 1,Sfi4.29 8 /3,60179 199,597.0 ; S �11�,819.67�___ 73,172 �. 1.61017 '� 02/29;12-�MONTHLYINVENTORYADJUSTMENT '� 857 0.50434 �: S 432.22 ;$ 432.22'�� S 178,257.89 74,029 �. 1.5�J737 �' _-_-. _ 03/07112 Tar a ONTH � � � � . � � E 63,577A2 ]9,807 j 34 228 1.59737 �.. � 9. .. I 9.975 1.51032 S.... . 12,492.89 ' S 1,671.34 $__. . 13 904.14 : 208 996.0 S 77,481 16 ' 49 200�- _ 1 57482 �. �.- . .. . ._ .___�_ ._.. .... •.__. D3/08;12 �.Tar a ' 120739�16I �, � 5 1,667.08 S 74 15927 218,371.0 5 97,640.43 58,575 �� 1.56450 '� �3/12i12 'Tarqa 12074108 I 9,299 7.58532 S 19,088.35 E 1,653.56 $ 14,701.91 227,670.0 �� S 106,982.34 67,874 I ! 1.56735 . B3/13/12 �Targa ��i 12074361 � 9,299 1.56032 5 72,855.87 � E 7,653.56 S 14,509.43 236,969,0 5 120,897.77 '. 77,173 1.56650 � D3/31/12 IMONTHLYINVENTORYADJUSTMENT 418 0.44311 $ 185.22 5 185.22 5 721,07699 77591 � 1.56045 . . . ._. _ ...... _ ._..- _ -_.. _'___ . �__ _____ _. �. ._._ .. _ ^___ _.__-_ 03/31/12 END OF MONTH � � � . . .. ' . � . . . . � S 60,339.54 � 38.668 I J8.923 1.56045 � Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Mar-12 38,923 $ 60,339.54 1.55 Apr-12 $ 1.42 36,476 $ 51,795.92 $ 112,135.46 75,399 38,923 $ 57,887.35 1.49 May-12 $ 1.45 30,000 $ 43,500,00 $ 101,387.35 68,923 38,923 $ 57,256.65 1.47 Jun-12 $ 1.50 20,000 $ 30,000.00 $ 87,256.65 58,923 38,923 $ 57,639.47 1.48 Jul-12 $ 1.50 20,000 $ 30,000.00 $ 87,639.47 58,923 38,923 $ 57,892.35 1.49 Aug-12 $ 1.50 20,000 $ 30,000.00 $ 87,892.35 58,923 38,923 $ 58,059.40 1.49 Sep-12 $ 1.55 30,000 $ 46,500.00 $ 104,559.40 68,923 38,923 $ 59,048.00 1.52 Oct-12 $ 1.60 30,000 $ 48,000.00 $ 107,048.00 68,923 38,923 $ 60,453.40 1.55 Nov-12 $ 1.60 30,000 $ 48,000.00 $ 108,453.40 68,923 38,923 $ 61,247.07 1.57 Dec-12 $ 1.60 40,OOQ $ 64,000.00 $ 125,247.07 78,923 38,923 $ 61,768.96 1.59 CSW 04/25/2012 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge fFor Central Pasco Terri?ory) Non-Fuel Enerstv CharnelTherm Ncn-Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIAI Usage & Inflation Adj (UTA) Total Non-Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelTherm Minimum Monthly Bill (For Central Pasco Terrilory) Compares to LP/Gallon Rate of with 6.0'/ Franchise Change (rom 1!200E Therm Rate '�� Change from 1!2006 Therm Rate Utility Tax Note: Fuel Rate pe! Therm 10!01i1973 Non-Utili;y Taxable Fuel;Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR MAY 1, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural Gas Rate Schedules RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SLw/M8 NGV_ (Closed 1/09) Relipht (Non-Resl� NA (1 - NA (4 + NA (4 + NA ;4 + D- 18,000- 10Q000 NA (1 - NA (0 - NA (150 NA NA NA 3 Units) Units) Units) Units) 17.999 99,999 & up 3 Units) 149 tons) tons 8+) S10 00 $25.00 540.00 $95.00 $25.00 $40.00 595.00 510,00 $25.00 �40.00 520.00 $20.00 By Contract ($18.00) ($40.00) ($70.00) (5160.00) ($40.00) ($70.00) (5160.00) (518.00) ($40.00) ($70.00) (�30.00) ($30.00) (By Contract) if not prev. if not prev. if not prev. billed billed billed $0.48 $0.48 $0.48 50.48 $0.46 $0.40 $0.34 $0.20 $0.15 $0.10 $020 $0.35 By Contrect 0.13 0.13 0.13 0.13 0.13 0.13 0.13 NA NA NA NA NA NA 0.02 0.02 0.02 0.02 0.02 0.02 0.02 NA NA NA NA NA NA 0.06 0.06 0.06 0.06 0.06 0.06 0.06 NA NA NA NA NA NA S0.69 $0.69 $0.69 $0.69 $0.67 $0.61 $0.55 $0.20 $0.15 $0.10 $0.20 a0.35 By Contract 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0:72 1.49 1.49 1.49 1.49 1.47 1.41 1.35 1.00 0.95 0.90 1.00 1.15 0 72 + Non-Fuel $10.00 325.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) (570.00) (�160.00) ($40.00) ($70.00) (3160.00) ($18.00) ($40.00) (^�70.00) ($30.00) ($30.00) (By Contract) @ premise @ premise @ premise + FAC + FAC + FAC $ 1.36 $ 1.36 $ 1.36 $ 1.36 $ 1.35 $ 1.29 $ 1.24 $ 0.92 $ 0.87 $ 0.82 $ 0.92 $ 1.05 5 $ 145 $ 1.45 $ 1.45 $ 1.45 $ 1.43 $ 1.37 $ 1.31 $ 0.97 $ 0.92 $ 0.87 $ 0.97 $ 1.12 5 $ (0.77) $ (077) $ (OJ7) $ (0.77) $ (0.68) $ (0.68) $ (0.68) $ (0.88) $ (0.88) $ (0.88) $ (0.88) $ (0.83) � -34.1 % -34.1 % -34.1 % -34.1 % -31.6% -32.5% -33.5% -46.8% -48.1% -49.4% -46.8% -41.9% SOA69 $0.069 50.069 $0.069 50.069 50.069 $0.069 50.069 $0.069 $0.069 $0.069 50.069 5C]31 30731 50.731 $0]31 $OJ31 $0]31 $0J31 $C.731 5GJ31 50.731 �0.731 $OJ31 Interr. NG Rate NSS IS__. (Non-Resl) NA 100,OOG & up S5C.00 $25Q00 ($75.00) 540Q00 0 Attachment #4 Contract NG Rate _ CNS _ NA By Contract (By Contract) �0.46 S0 28 By Contract NA NA NA NA NA NA NA NA NA $0 46 50.28 By Contract 0.80 0.72 0.72 1.26 1.00 0 72 + Non-Fuel $50.00 $250.00 Customer ($75.00) $400.00 Charge + + FAC + Non-Fuel Therm Non-Fuel T'�ierm Rate for Contract Rate for Contract # of Therms # of Tnerms 0.66 3 1.15 $ 0.92 070 5 1.22 $ 0.97 (1.06) $ (0.89) S (OJ4) -59.6% -41.4% -42.5% S0 069 50.069 $Q055 $0.651 50 ?31 $0.665 BTU FACTOR = THERMSI100 CUBIC FEET C( CFl 10/2011 11/2011 12/2011 01/2012 02/2012 03/2012 04/2012 05i2012 06/2012 07/2012 0812012 09/2012 FY 11/12 Averaqe Firm Service Rates 1.035 1.036 1.036 1.036 1.035 1.035 1.035 1.034 1.035 interruptible Service Rates 1.015 1.016 1.016 1.016 1.015 1.015 1.015 1.013 1.015 S (0J4? 507% S0 069 SC 651 CSW C4/25/2012 Attachment #5 Page 1 of 2 BTU Factor: 2.714 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 MAY 1, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBYlGENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP (Non-Resi.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) Mcnthly Customer Charge $10.00 �25.00 $10.00 $25.00 $40.00 $40.00 $50.00 Set By Contract For Each Meter Non-Fuel Enerqv Charqes/Gallon: Non-Fuel Energy Charge (NFE)lGalloi 51.90 51.90 $0.90 S0.30 �0.25 Set By Contract S1.00 Set By Contract Energy Conservation Adj.(ECA)/Gallor 0.13 0.13 0.13 0.13 0.13 NA NA NA Regulatory Imposition Adj.(RIA)/Gallor 0.02 0.02 0.02 0.02 0.02 NA NA NA Usage & Inflation Adj. (UTA)/Gallon 0.06 0.06 0.06 0.06 0.06 NA NA NA Total Non-Fuel Charges (NF)IGaI. �2.11 $2.11 �1.11 $0.51 $0.46 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal 2.53 2.53 2.53 2.53 2.53 Set Bv Contract 2.53 2.23 Total Energy Charges/Gallon S4.6A S4.64 53.64 53 04 $2.99 Contract NFE 53.53 Contract NFE + + Contract PGA $2.230 Customer Charge C��stomer Charge + Minimum Monthly Bill 510.00 525.00 $10.00 $25.00 $40.00 Any Applicable 550.00 Non-Fuel Energy Chq. Utilitv Tax Note: Fuel Rate per Gallon 10/01/1973 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable Fuel/Gallon $2.369 $2.369 $2.369 $2.369 $2.369 Change from 8/2008 Gallon Rate $ 0.50 $ 0.50 $ 0.30 $ 0.30 $ 0.30 % Change from 8/2008 Gallon Rate 12.1% 12.1% 9.0% 10.9% 11.2% Customer Charge + Any Applicable Facility Charges 0.161 0.161 Contract PGA - 0.161 $2.369 NA $ 0.60 NA 20.5% for the Contracted # of Gallons/Mo 0.161 Contract PGA - 0.161 NA NA CSW:04/25/2012 BTU Factor: BTU Factor. Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLP1 BRLP2 BRLP3 BRLP4 Applicable Annual Gallon Range 0- 60 60.1 - 120 120.1 - 300 > 300 or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annua� Customer Charge � 210 00 $ 180.00 $ 90.00 $ 75.00 Non-Fuel Charqes (NF11Gallon: Non-Fuel Energy Charge (NFE)/Gal. $ 1.80 $ 1.60 $ 1.00 $ 0.90 Energy Conservation Adj. (ECA)/GaL $ 0.13 $ 0.13 0.13 0.13 Regulatory Imposition Adj. (RIA)/Gal. $ 0.02 $ 0.02 0.02 0.02 Usage & Inflation Adj. (UTA)/Gallon 0.06 0.06 0.06 0.06 Total Non-Fuel Charges (NF)/Gal. $ 2.01 $ 1.81 $ 1.21 $ 1.11 Purchased Gas Adj. (PGA)/Gailon $ 2.53 $ 2.53 $ 2.53 $ 2.53 Total Energy ChargeslGallon $ 4.54 $ 4.34 S 3.74 $ 3.64 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 Fuet/Gallon $ 2.369 $ 2.369 $ 2.369 $ 2.369 Change from B/2008 Gailon Rate $ 0.500 $ 0.500 5 0.30 $ 0.30 °� Change from 8!2008 Gallon Rate 12 4% 13 0% 8,7% 9.0% Attachment #5 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR MAY 1, 2012 - SEPTEMBER 30, 2012 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL "WILL CALL" (Based on Annual Usage Level) WRLP1 WRLP2 0 - 120 > 120 1-3 UNITS 1-3 UNITS $ 150.00 $ 75.00 $ 1.60 $ 0.90 0.13 0.13 I 0.02 OA2 0.06 0.06 $ 1.81 $ 1.11 $ 2.53 $ 2.53 $ 4.34 $ 3.64 COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) BCLP1 BCLP2 0 - 2,500 > 2.500 Cuslomers 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.06 0.06 $ 0.46 $ 0.41 $ 2.53 $ 2.53I, S 2.99 $ 2.94 $ 0.161 $ 0.161 $ $ 2.369 $ 2.369 $ $ 0.50 $ 0.30 $ 13.0% 9.0% 0.161 � 2.369 $ 0.25 $ 9.1 % BU�K STANDBY/ GENERATOR LPSB (Closedfor New Residental Applications) $ 420.00 $ 1.00 NA NA NA $ 1.00 5 2.53 $ 3.53 i 0.161 $ 2.369 $ 0.25 y 9.3% , CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Buik Del Set by contract Set By Contract NA NA NA Set By Contract 2.23 Cotract NFE + 2.230 0.161 $ 0.161 2 369 Contract PGA - 0.161 0.60 NA 20.5°/> NA CSW:O</25l2012 � � � . , Attachment #6 Page 1 of 3 Residential Rate History By Components Clearwater Gas Svstem Total Rate _ , . Adiustments/Thertn Contract LP Month. NG/therm �P/aallon_ �� ECA EIAIRIA# WNA/UTA-Resl# UTA-Comll# �: PGA PGA PGA/aalion Oct-08 i i.990 5 3.300 � . � S 0140 � 5 - 5 - S - $ 1270 � i 1.190 �$ 2260 Nov-OS S t99C $ 3.3CC $ 0.140 S - S - S - . S L270 $ 1.190 S 2260 Dec-OS � 1.940 5 2J7C . � 5 0.140 i - $ .. � S - � 5 t220 '�� S 1.140 ��� $ 1 J30 Jan-09 S 1]SO 5 229C # �.. $ 0.090 S - S - � - g 1.180 �� � 1.100 �$ 1200 Feb-09 �. $ 1750 5 2290 � '. S 0.090 $ - g - .� - : y 1.180 $ 1.100 : S 1200 Mar-09' $ 1.580 � S 2270 . � $ 0.07C � 5 - $ - $ - � y 1.030 : $ 0.950 �, $ 1200 Apr-09 $ 1.410 . $ 2200 - � $ 0.040 $ -� $ - � $ - � 0.890 � S 0.810 � 5 1.160 May-09: $ 1.410 S 220C . . .. � 0.040 � $ - S - �.. 3 - . $ 0.890 ��� S 0.810 :� $ 1.160 . Jun-09 5 1.4 i0 5 2200 -$ 0.040 S - � g - $ - �$ 0.890 �^� 0.810 5 1.160 Jul-09': $ 1.350 S 2.330 �. . � � $ 0.040 $ - $ - � � - � 0.830 � 5 0750 � 5 1.290 Aug-09 5 1.350 .. $ 2.49G . ' ; $ 0.040 $ - $ - �. � - ', $ 0.830 : $ 0750 ��� $ 1.450 Sep-09�I 5 i.390 � 5 2.650 � � ; $ 0.070 �. $ 0.010 $ - � y � $ 0.830 ; $ OJ50 ': $ 1.570 FY OS/09 Av .� S 1.610 S 2.524 � ' �� ��; $ 0.078 . 5 0.001 �.. $ - . 5 �. 5 1.026 '�. 5 0.946 ��, S 7.470 2008 Av9. '., $ 1.965 , § 3.186 '�. �� I $ 0.136 '. $ - �, 5 0.013 '� $ ', 8 1.237 �.� 5 1.157 ', $ 2.138 Oct-09: $ 1.390 �� S 2.670 ': ' � 3 0.070 ',� $ 0.010 � 5 - ; $ _ .� $ 0.830 ' $ 0750 ���, � t590 . .. Nov-09��� $ t.390 $ 2.670 ��� �. ' ' $ 0.070 $ 0.01C ' � - � $ - �. $ 0.830 ��, $ 0750 ' $ 1.590 Dec-09� $ 1.390 $ 2750 � � .� $ 0.070 $ 0.010 � S - � $ � $ 0.830 ' $ OJ50 ��i $ 1.670 . . Jan-10' $ 1.390 S 2750 : �� , . �. $ 0.070 , $ 0 010 �: $ - � $ -.. : $ 0.830 � � 0.750 � $ ' 1.670 .. Feb-101$ 1.480�$ 2.810��, : ' I$0.110;$ 0.010I$ -�$ -�,$0.880��$ 0.800�$ 1.690 . .. � $ 1.520 .� $ 2.880 � ��, � $ 0.110 � $ 0.010 ��� $ - $ � $ 0.920 �� $ 0.840 I $ 1.760 Mar-10' ' Apr 10' $ 1.520 $ 2.880 . . ',� $ 0.110 �� � 0.010 � $ . $ . . ' $ 0.920 � $ 0.840 I $� 1.760 . . May 10'� S 1.490 $ 2.850 . . . . ' $ 0 090 � $ 0 030 I $ - '.� $ - $ 0.890 � $ 0.810 '. $ . .1.730 Jun 10. 5 1.460 � S 2.950 � ' . . � $ 0 090 I $ 0 030 . $ . $ . . ," $ 0.860 ' $ 0780 � $ 1.830 Jul-10� $ 1.430 � $ 2.990 ' . . ' $ 0 090 ' $ 0.030 $ _ �. $ _ � $ 0.830 j $ 0750 '.., $ 1.870 � Sep-10; $ 1.390 I 5 3.090 .� ��.: � . .. ; $ 0.090 �� $ 0.030 � $ - ��.;.$ � $ 0.790 � $ 0.710 � $ 1.970 ' ' .$0.090'�,$ 0.030�$ - '�,� - i$0.790�$ 0.710i$ 1.970 FY 09/10 Av9• i, $ 1.437 I 5 2.865 '��, � ; b 0.088 �, $ 0.018 i S ; S '� $ 0.850 i; 0.770 '� g 1.758 2009 Av9. '�, $ 1.464 ', $ 2.418 : � ��; $ 0.061 ! S 0.003 ' $ _ ', ; - �; S 0.920 '., S 0.840 �', $ 1.353 . . . . Nov 10 �, �$ 1.47 ' S 3.02 :� � ��� ; $ 0.10 � $ 0 02 .� $ ..�� S - I $ 0.87 � $ 0 79 �.� $ � 1.90 . � ; � �..$ 0.10 5 002:$ .. ��$ - �$ 0.87 $ 079�$ 190 Dec-10� $ 1.47 . $ 3.02 � �. '�, , $ 0.10 $ 0.02 '�. $ - , $ - � $ 0.87 �. $. . .0.79 :� $ 1.90 .. Jan-11 , $ 1.Sa g 3.33 �.. ��. � �.. $.. 0.10 ' � OA2 � $ OA2 � $ 0.03 � $ 0_92 '' $ 0.&4 � $ 2.19 .. Mar-11 :� $ 1.55 $ 3.37 : � �� ��. $ 0.13 $ 0.03 : $ 0.02. i $ 0.05 � $ 0.89 � $ 0.81 , $ 2.19 APr-11 . $ 1 A6 � . . . . . . _ . . . . _. Feb-11 � $ L55 $ 3.37 �. . .. . $ 0.13 $ 0.03 . S 0.02 ; 5 0.05 � $ 0.89 � $ 0.81 �. $ 2.19 ' � '. . .. . .. _ . ... $ 328 � .. '�' � $ 0.12 � $ OA2 � $ OA2 '�. $ 005 . � 0.82 $ 0J4 : $ 2.12� _ $ 0.10 $ 004 . May-11 , � 1.45 S 3.35 �� � . . ` . . ' $ OA2 � $ 0.05 � $ 0.81 �' $ 073 I $ 2.19 .. . Jun-11 � $ 1 AS 5 3.35 ��' : ' ', $ 0.12 5 0.02 ' $ OA2 �. $ 0 O5 �' $ 0.81 ; $ 0.73 � $ 2.19 Aug 11 � $ 1.45 � S 3.35 � ��. . � .. . �. $ OA2 ��. $ 0.02 ��. $ 0 05 �'., $ 0.81 ; $ 0.73 � $ 2-19 � ' $ 1 A2 � 5 3.46 ' �� $ 0.02 ' $ 0.02 , $ 0 OS � $ 078 $ � 070 ' $ 2.30 S 0.113 4 �----- $ 0.02 �$ OA2 ���. $ 0 05 $ 078 $ 0 70 0 12 $ 012 Se 11 : $ 1.42 . 5 3.46 ' . � . � . $ 2.30 FY 10/11 Avg. ��, $ 1.475 . 5 3.282 � ' � !. � 0.023 �� S 0.015 .$ 0.036 ; S 0.843 '�. S 0.763 '.. $ 2.130 2010 Av . g t.as� 5 2.sae � 8 o.oss S o.021 , S -' S - S o.sso : S o.�so , S t.szs ...- Oct-11 : $ i.a7 � 3.63 �� . ' . .. ..�, ,� $ 0.13 S 0 02 � $ 0.02 $ � 0 OS , $ 0.82 $ 074 $ 2.46 Nov-11 I $ 1.52 S 3.63 � �:, .. . i .. . �.: $ 0.13 $ 0.02 � $ � 0.02 , $ 0.05 �. $ 0.87 '' $ 0J9 � $ 2.46.. .. �. �. �. .. �$ 0.13�5 002,$ 0.� $ 0.08 $ 0.67:$ 0.79�$ 2.46 Jan-12- $ 1.56 � $ 3.89 �: I 5 0.13 $ 0 02 $ 0.06 , ! S 0.08 $ 0.87 $ 0.79 :$ 2.68 ec 156 $ 3.67 � Feb-12.� S 1.53 5 3.81 �. � - S 0.13 .$ 0 02 I$ 0.06 �$ 0.08 '� S 0.84 ,$ 076 $ 2.60 � Mar-12��. $ t51 S 3.81 �� ; . . ` . . . . �. . i . .. .. - � . . _ . �, $ 0.13 . $ 0 02 � $ 0.06 .. $ D 08 $ 0.82 .. $ 074 , $ 2 60 . . Apr-12'.: $ i.51 $ 3.81 � .. � I. ! $ 0.13 3 0.02 ��.. $ . . 0_O6 � $ 008 � $ 0.82 � $ 074 , $ 2.60 . .. May 12I $ 1.49 � � 3J4 � .: . �. $ 0.13 � $ 0.02 '...5 . . 0.06 � $ 0 06 �, $ 0.80 , $ 072 ; $ .. 2.53 Jun-12'� � . . . ' . . . . . . . . . Jul-12' . . . : ' . : . '. . . . Aug-t21 . ' . ,, _ . . . . . . : . �; Sep-12' . , , FY 11/12 Avg. '. 5 1.519 � S 3.749 '. '� ; E 0.130 � 5 0.020 '... S OA50 �.. $ 0.070 �� 5 0.839 �� 5 OJ59 . 5 2.549 2011 Avg. '.. S 1.487 5 3.438 ' . . '. 5 0.121 : 5 OA23 :$ 0.023 �� $ 0.051 '�.. S 0.839 ; S 0.759 ��� $ 2.270 Incr. Above :$ 0.04 S 0.39 �. . ' �' $ 0.01 5 - 5 0.04 � 5 0.01 !� $(0.01 ��.��' S (0.01 ��.�- S 0.34 Last Year � - ' ' � � � . � � � Same�Month : 3% 12%, , � � � g°/,� 0%_ 200%. 20%' �-1k� -1%., 16� Incr. Based �. 5 0.80 5 8.52 � ' � � - � � � � � ' on 20 Therms 3 % 13 % ' � � � � ' � - � EquivaleM �� . . . �. . . : . .. . Cents/KWH 5.1 14.0 . . . . � . �. : : for Gas � � �. ' � � � � � � vs. FPC Rate 13.2 73.2 � Note: This is Progress Energy's residentiai rate for usage >1,000 KWH in January 2012. (Residentiaq - � � �. � �� - �. - Gas Cheaper � � � � � � � bY -62 % 5 % .� � . . . Notes: - � � . - �� - � ' Based on Bulk LP ;BRlP3; w^ich is aoolicabie for customers using i 20.1 - 30C gallonslyear & eaual to Residential LP Will Call (BRWCLP;. # New rates implementec '/'�l2009. wi;h followinG changes: � � � - RS NG Cus;cmer Cnarge increased �2 trom $8 to S10/month 8 NFE raie dropec 50 cenis to 48 cents/therm (CC +5 i/Mo. in 4l1I2005; - BRLP3 l.F Cusiomer Cnarge increased $18 ;rom 572 to $9Ctyear. and NFE rate raised 1C cent to S1.CC/gallon (CC + i2lVr. In 4!1/2005). - EIA changed :o RIA 8 WNA changed to UTA, but no additions to new componen;s o' these initialiy. � - UTA imo!emeruec V V20� 1 � � � - CSW:8/28/2011 Attachment #6 Page 2 of 3 Competitive Historv of NG vs Electric Rates Month-Year NG Therm Cost September 2001 $ 1.34 $ September 2002 $ 1.36 $ September 2003 $ 1.56 $ September 2004 $ 1.69 $ September 2005 $ 1.97 $ September 2006 $ 1.89 $ September 2007 $ 1.86 $ September 2008 $ 2.12 $ September 2009 $ 1.39 $ September 2010 $ 1.39 $ September 2011 $ 1.42 $ $ Increase over Last 10 Years $ 0.08 $ % Increase over Last 10 Years 6.0% Avg. Annual Inc. Over Last 9 Yrs. 0.6% NG Equivalent KWH Cost 0.046 $ 0.046 $ 0.053 $ 0.058 $ 0.067 $ 0.065 $ 0.063 $ 0.072 $ 0.047 $ 0.047 $ 0.051 $ 0.01 $ 11.2% 1.1% Progress Energy KWH Cost 0.084 0.074 0.084 0.089 0.097 0.119 0.120 0.120 0.132 0.136 0.132 0.05 57% 5.7% NG vs. Electric -46% -37% -37% -35% -31 % -46% -47% -40% -64% -65 % -62% � CSW:12/23/2011 Attachment #6 Page 3 of 3 Annual Average CGS Residential Rates Calender Year Fiscal Year Year NG/Therm LP/Gallon * ,Year NG/Therm LP/Gallon *' 1995 NA NA � FY 95/96 � 0. 880 $ 1.199 '* � 1996 $ 0.915 � 1.239 '` FY 96/97 $ 1.019 $ 1.370 * 1997 $ 1.049 $ 1.380 '" FY 97/98 $ 1.054 $ 1.318 '" 1998 $ 1.032 $ 1.288 *; FY 98/99 $ 1.052 $ 1.269 * 1999 $ 1.073 $ 1.311 : FY 99/00 �a 1.152 $ 1.504 ' 2000 :$ 1.222 $ 1.584 ; FY 00/01 $ 1.551 $ 1.649 i 2001 $ 1.549 $ 1.586 . � FY 01 /02 $ 1.352 $ 1.488 � 2002 ,$ 1.342 $ 1.553 , FY 02/03 $ 1.477 $ 1.817 '� 2003 $ 1.534 $ 1.864 `FY 03/04 $ 1.603 $ 1.913 ' 2004 i$ 1.652 $ 1.968 ' FY 04/05 $ 1.803 $ 2.162 ' 2005 $ 1.925 $ 2.278 ; FY 05/06 $ 2.080 $ 2.480 . 2006 : $ 2.012 $ 2.501 , � FY 06/07 ' $ 1.918 $ 2.742 ',' 2007 $ 1.893 , $ 2.869 , ; FY 07/08 ' $ 1.932 $ 3.183 ', 2008 ,$ 1.965 $ 3.186 i '; FY 08/09 $ 1.610 $ 2.524 ! 12009 $ 1.464 $ 2.418 ! FY 09/10 $ 1.437 $ 2.865 ; 2010 ;$ 1.457 $ 2.946 ; FY 10/11 $ 1.475 $ 3.282 ; '2011 i $ 1.487 $ 3.438 , ! ! , . , : Average $ 1.473 $ 2.088 � � $ 1.462 $ 2.048 �' : I Notes: _ ; Based on the Residential Metered Propan 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 customers using ' 120.1 - 300 gallons/year & is equal to Residential LP Will Call '�