Loading...
GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2011TO: FROM: COPIES: CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet William B. Horne II, City Manager Chuck Warrington, Managing Director RECEIVED JUL 252011 O:71CIAL RECORDS ANC; LEGISLATIVE SK CS DEPT Rod Irwin, Assistant City Manager; Rosemarie Call, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/CCS; Lynne Priester, Cust. Serv. Coord. /CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2011 DATE: July 21, 2011 World Natural Gas supply markets have stabilized and actually lowered slightly for Natural Gas, though LP supply prices remain elevated and continue to rise. Plus, Florida Gas Pipeline has settled their rate increase at a lower level than they had requested; therefore, we received a refund of the higher rates that they had been authorized to charge during the rate case. Therefore, we are recommending a decrease in our Natural Gas Purchased Gas Adjustment (PGA) clause of another 30/therm but an increase of 11 ¢ /gallon in our LP PGA in May. We are also recommending that we continue our Contract LP PGA at 30¢ below our Standard LP PGA. We are not recommending any change in our Energy Conservation Adjustment (ECA), our Regulatory Imposition Adjustment (RIA), nor our Usage & Inflation Adjustment (UIA) in August. The net effect of these recommended changes is a decrease in our typical Residential Natural Gas customer's rate of 3¢ /therm ( -2.1 %) but an increase in our typical Residential LP customer's rate of 11¢ /gallon ( +3.3 %). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after August 1, 2011: Natural Gas Firm Standard Rate Schedule PGA Natural Gas Interruptible and Contract (Non - Standard) Rate Schedule PGA Propane (LP) Gas Standard Rate Schedule PGA Propane (LP) Gas Contract Rate Schedule PGA Energy Conservation Adjustment (ECA) Regulatory Imposition Adjustment (ETA) Usage & Inflation Adjustment (WNA) - Residential - Commercial $0.7$ per therm (down 3¢ /therm) $0.70 per therm (down 3¢ /therm) $2.30 per gallon (up 11 ¢ /gallon) $2.00 per gallon (up 11 ¢ /gallon) $0.12 per therm or gallon (no change) $0.02 per therm or gallon (no change) $0.02 per therm or gallon (no change) $0.05 per therm or gallon (no change) William B. Horne II, City Manager July 21, 2011. Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru June. Our objective is to be close to at balance by FY ending. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #6 shows our rate history over the past 6+ years and shows our relationship to current electric prices. Please note that page #2 of this analysis shows that over the past 9 nears our residential natural gas rates have risen just 3.7% as compared to a 62% increase for Progress Energy Florida residential rates. That's an average annual increase of 0.4% /year for natural gas vs. 6.9% /year for electric - -- a remarkable difference! I should point out that the overall effect is that our typical Residential customer rates are now approximately 62% lower than electric for Natural Gas and LP is now about break even with electric. This follows Progress Energy Florida obtaining FPSC approval for a substantial increase in their rates in the past year. These competitive positions vs. electric are a result of their increases, while we have been steadily decreasing rates due to falling NG supply prices. 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 August 1st billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: WI Liam B. Home II, City Manager U:\My Documents \MSOFFICE\WINWORD \GASRATES \Gas Adjustments for August 2011.doc CLEARWATER GAS SYSTEM Page 1 of 4 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NG) 1 I • , ! 1 • . 1 Monthly i Cumulative NG PGA . , Budget Reservation Commodity = Interest Cost Center ' ,' Total NG Fuel . Total NG PGA 1 Overage : YTD Overage RatelThern Billed (Shortage) ' (Shortage) : FlrmlContr Prior Year I • Month Charges , Charges ! Expense Expenses , ! Expenses Oct-10 $ 3,214,594.56 ' 854995461 I $ 52,033.70 ' 1 1 $ 4,121,623.72 _; $ Nov-10 $ 211,726.13 823,199.40 , $ 14,18546 ,,_ $ 47,215.65 ; $ 1,096,326.64 Dec-10 , $ 75,857.24 1,117270.13 , $ 12,93444 ' $ 46,337.34 : $ 1,252,399.15 Jan-11 $ 195,081.12 ] 1,714,656.60 1 $ 10,908.36 ; $ 49,440.92 I ' $ 1,970,087.00 ; Feb-11 $ 193,849.51 1,168,251.02 1- $ 9,555.31 1 $ 42,087.45 ; I $ 1413,743.29 L Mar-11 ; $ 218,053.83 924,788.51 ; $ 7,228.71 : $ 41,379.15 ; $ 1,191,450.20 Apr-11 $ 131,411.26 1,114,428.22 . $ 4,574.51 $ 50,623.95 , $ 1,301,037.94 May-11 $ (202,302.01)i 831,760.97 ', $ 3,337.85 $ 38,566.24 ! 2 1 $ 671,363.05 Jun-11 : $ 89,954.19 ' 653,452.42 I $ 625.76 1 $ 39498.661 1 $ 783,531.03 i Jul-11 ' $ 83,000,00 ; 850,000.00 i $ - ._i$ 45,000.00 1 $ 978,000.00 Aug-11 ' $ 83,000.00 : 850,000.00 1 $ - I $ 45,000.00 : $ 978,000.0C- Sep-11 $ 83,000.00 850,000.00 I $ - 1 $ 45,000.00 ; ;1 $ i--- 978,000.00 Per13 ; $ - i $ - I : 5 ; $ 686,991.18 Total YTD! $ 4,377,225.83 ' $ 11,752,802.73 ' $ 63,350.39 ; $ 542,183.06 ! $ 17,422,553.20 I $ 1,233,004.63 $ 1,346,532.03 fs 1,657,614.95 j $ 2,240,697.13 $ 1,879,062.93 • $ 1 ,722 ,289 .4Cri $ 1,548,370.44 j $ 1,213,781.86 I $ 1,205,938.82 ; $ 1,134,081.21! $ 1,092,078.201 $ 1,092,078.20 tr$ $ 17,365,529.90 $ (1) Includes Annual Admin chg of $718,350 + CCS chg of $1,040,810 + Dividend $1,300,720, •+ FY 09/10 PGA write off of $26,580.04 + WNA $0 = $ 3,086,460.04 (2);FGT Rate Case Refund = $ (297,056.86) Net RC =: $ 1,587,822.65 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) $ 51,526.29 (2,888,619.09). $ (2,837,092.80) 0.87/0.79 250,205.39 1$ (2,586,887.41) 0.8710.79 405,215.80 ' $ (2,181,671.61). 0.87/0.79 270,610.13 $ (1,911,061.48) 0.9210.84 465,319.64 ; $ (1,445,741.84) 0.89/0.81 530,839.29 i $ (914,902.55). 0.89/0.81 247,332.50 $ (667,570.05) 0.82/0.74 542,418.81 $ (125,151.24) 0.81/0.73 422,407.79 $ 297,256.56 • 0.81/0.73 156,081.21 $ 453,337.77 ! 0.81/0.73 114,078.20 $ 567,415.97 0.78/0,70 114,078.20 $ 681,494.17 0.78/0.70 (686,991.18); $ (5,497.01) (57,023.30)1 • (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 = $ 686,991.1 + OPEB Liability (Accrued sick & vacation) TBD 1 Monthly Cumulative LP PGA Budget Gallons : Monthy Interest Commodity , Total LP FUGI Total LP PGA Overage : YTD Overage - Therm/Gal. • Month Sold WACOG Expense . Charges ' •H Expenses I Billed (Shortage) (Shortage) Oct-10 • 47,360.94 . 1 T $ $ 12,382.31 . Prior Year, . 33,366.4 $ 1.41942 , : $ 255,675.68 $ 63,737.10 $ (191,938.58)1 $ (179,556.27). 1.73/1.90 Nov-10 ; 32,634.7 ! $ 1.51533 • $ 897.78 ; 49,452.34 i 50,350.12 : 62,008.50 :, $ 11,658.38 1 $ (167,897.89)! 1.73/1.90 Dec-10 f 41,735.5 : $ 1.62230 $ 839.49 : 67,707.50 ; : 68,546.99 i 79,308.70 $ 10,761.71 ' $ (157,136.18): 1.73/1.90 Jan-11 50,401.2 $ 1.71763 • $ 785.68 I 86,570.61 ! 87,356.29 r 108,116.53 i $ 20,760.24 $ (136,375.94) 2.00/2.19 ; (119 ,• 2.00/2.19 Feb-11 35,247.5 $ 1.67582 1 $ 681.88 ; 59,068.47 59,750.35 77,07322 $ 17,322.87 j $ 053.07) Mar-11 • 38,198.6 ; $ 1.68222 . $ 595.27 64,258.45 ; 64,853.71 83,700.29 1 $ 18,846.58 ' $ (100,206.49); 2.00/2.19 Apr-11 33 652,1 $ 1.64195 421.53 $ 501.03 ; 55,255.07 55,756.10 I 71,655.86 ; $ 15,899.76 $ (84,306.73) 1.94/2.12 , ; ; ' May-11 24,249.3 ' $ 1.71220 ; $ 41,519.65 ; 41,941.19 ; 52,835.75 : $ 10,894.56 $ (73,412.16) 2.00/2.19 , Jun-11 • 31,261.2 $ 1.74541 I $ 367.06 : 54,563.61 • i , 54,930.67 68,379.39 ' $ 13,448.72 I $ (59,96345) 2.00/2.19 Jul-11 • 26,000.0 ; $ 1.76000 i $ 299.82 . 45,760.00 I 46,059.82 ; 56,827.18 1 $ 10,767.37 ; $ (49,196.08); 2.00/2.19 Aug-11 26,000.0 ! $ 1.78000 1 $ 245.98 46,280.00 T 46,525.98 . 59,681.52 : $ 13,155.54 • $ (36,040.54) 2.10/2.30 Sep-11 26,000.0 ; $ 1.76000 : $ 180.201 45,760.00 ' , 45,940.20 1 59,681.52 $ 13,741.31 i $ (22,299.23) 2.10/2.30 P13 . 4 • 26,421.54 I I $ (26,421.54) ' $ (48,720.77). 1.66411 ; $ 5,815.72 ; $ 663,556.63 ; $ 904,108.63 1 $ 843,005.56 ' $ (61,103.08): • . . $ 126,110.00 - 1 ; 1— Total YTD 398,746.5 $ Cost Center Expenses GCS Chg, Admin & Dividend .; • ;FY 09/10 Write off PGA & WNA I $ 927.12 ; 1 1 • . I . Fuel ' $ 15,000.00 1 :Donations to events . $ 25,946.43 • 1 : • .- LP Yard Vaporization/loss due to malfunctioning meter i $ 1,090.44 1 ' 1 (4)j Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate LP PGA Event fuel cost I $ 4,826.52 , 1 • , LP Proportion = 2.1% x Total ECA Transfer = • ' $ 14,736.21 . Suburban Software Systems i : 1 • + Additional Projected Costs Needed = • $ 1i,685.2( • ;Depreciation of LP tanks $ 34,414.23 • 1 • . LP Holding Tank Restoration • 7 1 : Proj. for Year ! Additional Needed $ 208,314.74 1 ' $ 220,000.00 $ 11,685 26 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 Page 2 of 4 ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NG1Therm Month Expenses Notes /Exceptional items E Expense Expenses Billed (Shortage} (Shortage) LPlGaI. Prior Year' 1 t - i ' $ - Oct-10 . $ 476, 228.43 ; PromoS30 ,927,Adv SUS, Employ Costs$70,342 . $ - 476,228.43'. $ 90,941.19 $ (385,287.24){ $ (385,287.24) 0.10/0.10 Nov -10 92,923.28 1Promo$31,868,Adv $8,821, Employ Costs$52,234 : $ 1,926.44 94,849.72 1 96,056.46 $ 1,206.74 • $ (384,080.50) 0.10!0.10 Dec -10 • $ 96,505.54 •Promo$41,511,Adv $1,529, Employ Costs$53,466 � $ 1,920.40 ; I 98,425.94 [ 136,544.02 $ 38,118.08: $ (345,962.42)' 0.10!0.10 Jan -11 $ 154,706.38 ,Promo$94,138,Adv$255, EmployCosts$60,313 f $ 1,729.81 —i 156,436.19 180,846.64i $ 24,410.45 $ [321,551.97]; 0.10/0.10 Feb -11 ; $ 83,774.72 1Promo$27,328,Adv $0. Employ Cosls$56,447 $ 1,607.76 i i fi 85,382.48 { 192,024.24. $ 106,641.76 i $ (214,910.21) 0.13/0.13 Mar -11 $ 101,633.03 IPromo$42,838,Adv $990, Employ Costs$57,605 $ 1,074.55 I 102,707.58 1 175,303.02 i $ 72,595.44! $ (142,314.77)' 0.13/0.13 Apr -11 $ 89,292.43 .Promo$27,556,Adv $273, Employ Costs$61,463 • $ 711.57 I. May -11 $ 103,872.51 •Promo$47,867,Adv $623, Employ Cosls$55,3B3 i $ 528.02 Jun -11 i $ 85,872.18 Promo$41,432,Adv $6513 Employ Casls$43,790 i $ 469.01 Jul -11 ' $ 140,000.00 : ■ $ 345.45 Aug -11 $ 140,000.00 $ 482.49: ! Sep -11 - $ 690,000.00 i Includes $550K for NGV funding $ 620.221 P13 Total YTD $ 2,254,808.50 $ 11,415.72 (1) • Includes Annual Admin Chg of $47,080 + CCS chg of $55,300 + Dividend of $69,090 = + FY 09/10 Write off of $2,643.99 + $200,000 SNEP = $ 374,113.99 90,004.00 I 126,715.66 - $ 36,711.66 i $ (105,603.12) 0.1010.10 104,400.53 116,200.87 i $ 11,800.34 1 $ (93,802.77) 0.12/0.12 86,341.19 I 111,054.96' $ 24,713.77: $ (69,089.00); 0.12/0.12 1 140,345.45 112,936.57 j $ (27,408.88)' $ (96,497.88); 0.12/0.12 140,482.49) 112,936.57 ; $ (27,545.92) $ (124,043.81); 0.12!0.12 690,620.221 112,936.57 $ (577,683.65) $ (701,72746) 0.12/0.12 701,727.46 $ 701,727.46 ' $ 2,266,224.22 $ 2,266,224.22 `. $ - • REGULATORY IMPOSITION ADJUSTMENT (RIA} (EIA) Budget Environmental Month Expenses N otes/Exceptional item s_ Prior Year Oct -10 $ 23,385.97 Nov -10 $ 3,306.00 Dec -10 $ 423,438.00 Jan-11 $ (18,235.18) Feb-11 $ 1,491.00 Mar -11 $ (18,248.96) A-pr -11 $ 1,491.00 May-11 $ 9,550.74 Jun-11 $ (11,094.27) Jul -11 $ (15,000.00) Aug -11 $ (15,000.00) Sep -11 $ (15,000.00) P13 - Net CCE = ! 1,880,694.51 1 (6) = Transfer of ECA Collected in PGA (c} 1/2 of the ECA Rate (up to ECA Annual Shortfall) Note: Maximum amount which can be transferred = $ 782,248.38 (ORA) , Regulatory Interest Total EIA . Total RIA Overage YTO Overage NGlTherm Expenses Expense Expenses Billed (Shortage) (Shortage) LP /Gal. $ - ' $ 82,519.09 • - 0 $ - 1 $ 23,385.97 18,238.59 $ (5,147.38). $ 77,371.71 0.02/0.02 0 $ - 3,306.00 19,210.43 • $ 15,904.43 $ 93,276.14 0.02/0.02 0 $ - ' 2 423,438.00 27,308.20 • $ (396,129.80)i $ (302,853.66)''• 0.02/0.02 0 $ 1,514.27 1 (16,720.91) - 36,168.15: $ 52,889.06: $ (249,964.60)- 0.02/0.02 - - 0 $ 1,249.82 ' 2,740.82 - 44,276.28 '. $ 41,535.46 $ (208,429.14) 0.03/0.03 __ 0 $ 1,042.15 • (17,206.81): 40,451.44 ' $ 57,658.25 • $ (150,770.89), 0.03/0.03 - 594.40 $ 753.85 i 2,839.25 50,560.14 $ 47,720.89 • $ (103,050.00) 0.04/0.04 939.20 $ 515.25 I i 11,005.19 ; 19,454.18 ' $ 8,448.99 ! $ (94,601.01) 0.02/0.02 $ 473.01 : (10,621.26)_ 18,509.53 i $ 29,130.79: $ (65,470.22)L__ 0.0210.02 5,000.00. $ - (10,000.00) 18,829.98 ' $ 28,829.98 $ (36,640.23) 0.0210.02 5,000.00 $ - (10,000.00) ! 18,829.98 ' $ 28,829.98 ' $ (7,810.25) • 0.02/0.02 - 5,000.00 $ i (10,000.00); 18,829.98 ; $ 28,829.98 . $ 21,019.74 • 0.02/0.02 - I$ - •$ 21,019.74 • Total YTD $ 370,084.30 (1) EIA includes Annual Adrnin Charges of $10,330 $ $ - $ 21,019.74 16,533.60 $ 5,548.35 392,16625 ; 330,666.89: $ (61,499.35) + FY 09/10 Write off of $316.50 = (2) EIA Includes Arcadis PO for remediation costs for MGP = 10,646.50 421,440.00 Net CCE = : $ (45,468.60) • CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 Page 3of4 USAGE AND INFLATION ADJUSTMENT NIA] Commercial Budget Month Beg. Bal. Oct -10 Nov -10 Dec-10 Jan -11 Feb-11 Mar -11 Apr -11 i .. May -11 Jun -11 Jul -11 Aug -11 Sep-11 Per 13 Total YTD. -1- ! 1 Months • Cumulative UTA Interest Overag! YTD Overage • NG/Therm LP Gallons! Expense Rate /Gallon 1 r 1 NG Therms 1 Rate /Therm (Shortage) J (Shortage) LP/Gal ' $ (348,1 59.74): 5,979.4 1 $ 669,076.70 - $ - • $ _(348,159.74 }1 0.00/0.00 6,667.5 1$ - : - 711,822.20 1 - $ - i $ (348,159.74)1 0.00/0.00 7,985.8 $ - - 930,224.90 1 - 1$ 1.41 1 $ 048,158.33) 0.00/0.00 9,583.3: $ 1,740.79 i 0.03• 1,101,753.80 8,477.7 1 $ 1,575.63_1 0.05: 1 967,797.20 • 7,506: $ 1,332.78 1 0.05 944,889.30 , _ 0.05: $ 47,584.78 $ (218,972.20) 0.05/0.05 7,104.2 , $ 1,094.86 , 0.05 928,791.00 0.05 $ 46,768.59 $ (172,203.61) ' 0.05/0.05 6,099.2 ; $ 861.02 ; 0.05 . 726,200.40 ' 0.05 : $ 36,593.09 ! $ (135,610.52): 0.0510.05 6,807.4 $ 678.05 1 0.05 ' 699,134.40 0.05 1 $ 35,270.65 ' $ (100,339.87) 0.0510.05 6,800.0 ; $ 501.70 0.05 I 1 700,000.00 0.05 1 $ 35,340.00 ; $ (64,999.87) 0.05/0.05 6,800.0 ! $ 325.00 : 0.05 700,000.00 0.05 • $ 35,340.00 $ (29,659.87)• 0.0510.05 • 6,800.0' $ 148.30 ' 0.05 • ' 7.00,000.00 . 0.05 $ 35,340.00 � • $ 5,680.13 0.05/0.05 $ 5,680,13 • 0.03 ! 33,031.50 $ (315,126.83)- 0.03/0.03 0.05 $ 48,569.85 $ (266,556.98) 0.05/0.05 USAGE AND INFLATION ADJUSTMENT (UTA) Residential Budget Month Beg. Bal. Oct -10 Nov -10 Dec -10 Jan -11 Feb -11 Mar -11 Apr -11 May -11 Jun -11 Jul -11 Aug -11 Sep -11 Per 13 Total YTD 86,610.9 = 8,258.14 9,799,689.90'. $ 353,839.87 Monthly Cumulative UTA Interest i Overage YTD Overage NG/Therm LP /Gal LP Gallons{ Expense :Rate/Gallon NG Therms Rate/Therm (Shortage) (Shortage) 1 $ (48,628.37) 27,387.0 $ 188,329.90 ; - . $ - ' $ (48,628.37) 0.00/0.00 25,967.2 , $ - _ 217,344.30 - $ $ (48,628.37): 0.0010.00 33,749.7 1 $ - 394,504.90 - $ - $ (48,628.37) 0.00/0.00 40,817.9 • $ 243.14. 0.02 657,516.60 ; 0.02 $ 13,838.39 ; $ (35,033.12) 0.02/0.02 26,769.8 $ 175.17 0.02 477,935.30 1 0.02 • $ 10,101.88 . $ (25,106.41) 0.02/0.02 30,692.2 ` $ 125.53 0.02: i 366,050.80: 0.02 $ 7,937.60 $ (17,294.34); 0.0210.02 26,547.9 i $ 86.47 ' 0.02 303,719.80 0.02 $ 6,606.67 • $ (10,774.14)' 0.02/0.02 17,895.1 • $ 53.87 • 0.02 219,279.70 0.02 ! $ 4,750.69 I $ (6,077.32) 0.0210.02 24,366.9. $ 30.39 0.02. 195,715.70 1 0.02 1 $ 4,408.43 ' $ (1,699.28) 0.02/0.02 25,000.0 : $ 8.50 0.02 r 200,000.00 ' 0.02 , $ 4,500.00 ; $ 2,792.23 ! 0.02!0.02 25,000.0 1 $ 0.02 , • 200,000.00 0.02 $ 4,500.00 I $ 7,292.23 `1 0.02/0.02 25,000.0 1 $ 0.02 : - 200,000.00 0.02 , $ 4,500.00. $ 11,792.23 0.02/0.02 • $ 11,792.23 329,193.7 723.06 - 3,620,397.00 . $ 61,143.66 . CLEARWATER GAS SYSTEM Page 4 of 4 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2010/2011 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA +UTA) Budget Month Prior Year Oct -10 Nov -10 ; Dec -10 Jan -11 Feb-11 Mar -11 Apr -11 May -11 Jun -11 Jut -11 Aug:11 Sep -11 Per 13 • Total YTD: Monthly Cumulative Total Resl Total All i Total Recovery i Overage i YTD Overage NG /Thm (Flrr Expenses Billed 1 (Shortage) (Shortageh • LP/Gal (Res! - $ - • $ (250,360.42) $ 4,876,913.80 $ 1,405,921.51 $ (3,470,992.29). $ (3,721,352.71)• 0.99/2.02 $ 1,244,832.48 $ 1,523,807.42 $ 278,974.94 ' $ (3,442,377.77); 0.99/2.02 1,842,810.08 - $ 1,900,777.28: $ 57,967.20: $ (3,384,410.57) 0.99/2.02 2,199,142.51: $ 2,612,698.34. $ 413,555.83 ; $ (2,970,854.73) 1.06/2.33 1,563,367.74 i $ 2,251,108.40 1 $ 687,740.66 $ (2,283,114.07) 1.0712.37 1,343,263.00 f $ 2,077,266.62 $ 734,003.62 $ (1,549,110.45) 1.07/2.37 1,450,818.63 i $ 1,850,677.36, $ 399,858.73 $ (1,149,251.72) 0.98/2.28 $ 829,624.841 $ 1,443,616.44 $ 613,991.60 $ (535,260.12) 0.9712,35 $ 914,890.07 $ 1,443,561.78 $ 528,671.71 ! $ (6,588.40) 0.97/2.35 $ 1,154,915.46: $ 1,362,514.95 • $ 207,599.49 $ 201,011.08 . 0.97/2.35 $ 1,155,333.47 i $ 1,323,366.27 r$ 168,032.80 $ 369,043.89 0.94/2.46 1,704,708.72 ! $ 1,323,366.27: $ (381,342.45) $ (12,298.57)! 0.94/2.46 713,412.72 i $ 701,727.46 ; $ (11,685.26) $ (23,983.83): 20,994,033.50: 21,220,410.10 $ 226,376.59 1 Last Updated 07!20!20' Oct -10 Nov -10 Dec -10 Jan -11 Feb -11 Mar -11 Apr -11 May -11 Jun -11 Jul -11 Aug -11 Sep -11 CGS Natural Gas Cost ActuallProjections FYI1 as 0r 11'101,J i r Contract Capacity Contract No -Notice Excess Capacity Capacity Relinquishment Purchased Gas Sold Gas Actual Sold Gas Projected Purchased Gas lost % Sold Gas vs. Projected WACOG Purchased FTS -1 FTS -2 Volume Cost 170,436 41,788 15,500 54,136 (8,912) $ (2,056.78) 156,090 146,267 154,000 -2.71% 965% $ 6.31 906,570 53,430 22,500 183,366 40,646) $ (5,661.33) 176,632 162,381 154,000 - 11.60% 105.4% $ 6.49 316,789 55,211 31,000 111,293 57,371) $ (149,321.03) 260,707 197,472 186,000 2.59% 106.2% 5 5.54 316,789 55,211 46,500 128,186 (54,576) $ (30,772.95) 243,814 253 946 229,000 9.36% 110.9% $ 6.35 286,132 49,868 42,000 138,219 (44,948) $ (10,147.71) 197,781 220,996 227,000 •2.56% 97.4% $ 6.44 346,789 55,211 31,000 173,505 (59,839) $ (7,124.44) 198,495 202,883 207,000 1.24% 98.0% $ 6.12 216,750 53,430 22,500 110,776 (51,801) $ (9,511.41) 159,402 196,034 186,000 2.21% 105.4% $ 6.87 144,212 41,766 12,400 29,106 (11,166) $ (3,445.30) 156,892 155,879 161,000 $ 3,161.42 96.8% 5 4.18 139,560 40,440 10,500 32,195 (17,138) $ (5,019.86) 147,805 147,000 147,000 408.45 $ 3,026.87 $ 6.08 144.212 41,788 10,850 38,500 (40,000) $ (16,000.00) 147,500 146,000 146,000 $ 422.07 $ 6.37 144,212 41,788 10,850 36,500 (40,000) $ (16,000.00) 147,500 146,000 146,000 $ 30524.68 $ 5 6.37 139,560 40,440 10.500 30,000 (40,000) $ (16,000.00) 150,000 146.000 146.000 "5 65,509.46 $ 29,056.14 $ 6.43 Total 2,642,013 Oct -10 Nov -10 Dec -10 Jan -11 Feb -11 Mar -11 Apr-i1 May -11 Jun -11 Jul -11 Aug -11 Sep -11 570,393 266,100 1,067,788 (466,397) (5271,260.61) 2,144,618 2,122,860 2,009,000 0.53% 102.0% 56.12 Reservation FTS -1 (phase It) charges FTS-2 (phase 111) FTS-1 No- Notice charges NNTS FTS -1 Usage Charge (phase 0) FTS-2 Usage Charge (phase 01) Total Commodity charges Monody Adjustments Fuel Cost (Fuel Retenlion) FGU Management fee Per Month Load Factor w! Relinquish Load Factor wlo Relinquish Total Billing (FGU +Peoples) $ 98,070.03 $ 31,445.47 $ 675.80 $ 5594.10 $ 1,051.52 $ 669,064.32 $ 3,378.19 5 25,898.05 $ 10,211.00 77.8% 74.5% 5 997,198.84 $ 176,400.38 $ 40,206.08 $ 981.00 $ 5,346.08 $ 1,346.44 5 933,992.87 $ 2,763.53 $ 28,086.35 $ 11,913.00 55.3% 49.1% $ 1,145,719.60 $ 182,280.39 5 41,646.28 $ 1,351.60 $ 8,488.50 $ 1,391.32 $ 1,368,998.56 $ 27 334.42 $ 39,867.54 $ 14,295.00 82.9% 70.1% 5 1,444,855.89 5 162,280.39 $ 41,546.2.8 $ 2,027.40 5 6,061.85 $ 1,391.92 $ 1,353506.83 $ 24,248.00 $ 38,244.03 5 15,657.00 76.8% 65.5% $ 1,548,989.95 $ 164,640.35 $ 37,525.87 $ 1,831.20 $ 6,482.86 $ 1,256.67 $ 1,079,665.45 5 26,190.06 $ 31,004.56 $ 14,295.00 68.0% 58.9% $ 1,273,534.96 $ 182,280.39 $ 41,548.26 $ 1,351.60 $ 6,141.13 $ 1,391.32 $ 996,186.22 5 253.68 5 29,968.49 $ 13,614.00 63.6% 53.4% $ 1,214,240.05 $ 101,657.96 $ 38,369.46 $ 875.25 $ 2,969.06 $ 496.90 $ 963,697.07 $ 382.10 5 29,235.17 $ 11,913.00 73.0% 595% $ 1,095,108.33 $ 67,693.11 $ 30,024.68 $ 482.36 $ 3,161.42 $ 368.63 5 633,460.54 $ (369,825.24) $ 28,690.62 $ 10,551.00 69.7% 84.4% $ 655,171.39 $ 65.509.46 5 29,056.14 $ 408.45 $ 3,026.87 $ 306.34 5 886,099.54 $ (75,034.31), $ 27,345.06 5 9,326.00 90.8% 82.1% $ 897,957.38 5 67,693.11 $ 30,024.68 $ 422.07 5 2,667.83 5 309.23 $ 857,765.72 5 - $ 24,798.26 $ 8,760.00 101.0% 79.3% $ 939,905.57 5 67,693.11 $ 30524.68 $ 422.07 $ 2.667,63 $ 309.23 5 857,765.72 $ - $ 24,798.26 $ 8,760.00 101.0% 79.31/4 5 939,905.57 "5 65,509.46 $ 29,056.14 5 406.45 $ 2,753.54. 5 299.26 $ 086,204.13 $ - 5 25,479.34. 5 8,880.00 107.1% 83.3% $ 965,178.19 Total 51,421,708.15 $420,391.84 511,237.24 $56,871.06 59,938.18 511566,828.97 $ (360,308.77) 1st 6 Months 2nd 6 Months TOTAL Total Reservation Total Commodity 5353,415.73 Total Projected Cost 5138,175.00 DTH Purchased 62.2% WACOG $ 1,227,986.59 $ 6,601,836.25 67524,530.60 1,235,519 56.171 5 625,350.64 5 5,084,992.72 55,493,226.43 909,090 56.043 51,853,337.23 5 11.686,826.97 513,117,765.03 2,144,618 $6.12 69.9% 513,117,765.03 Propane Weighted Average Cost of Gas (WACOG) 7/15)2011 FY 2009-10 r 4 1L'1€-Afr-- ('3 Date Invoice Company Sea-3 1 LSL Shipping 09/30/10 • - • • • • 10/15/10 Sea -3 4010.0405 10/18110 Sea-3 4010-0413 i_.___ -- 10131110 ,MONTHLY INVENTORY ADJUSTMENT 10/31/10 !END OF MONTH I 11116110 1Sea -3 14010.0440 11/30/10 _ _ _ MONTHLY INVENTOR Y ADJUSTMENT 11130!10 _ END OF MONTH I • - i 12/21111 Sea -3 !4010 -0474 12117/11 '04100464 {- -� -. -. 12/31/10 MONTHLY INVENTORY ADJUSTMENT Gallons Delivered Propane I Propane Rata Cost Shipping Cost i Gans invent°} 'Tank Inventory , Tank I WACOG Withdraw! 28,911 Year Erid.Tctnld - .� S 48,519.16 1 34,763 i 1.39571 1.43197 $ 40,669.50 $ 730.64 5 S 89.9}8.90 j 63,574 - - 1.41218 41,399.74 28 911.0 9,000 : 1.43197 S _ 12,660.30 $ 227.45 $ 12,887.75 37,911.01 $ 102,606.65 I 72,674 1 1.41463 482 2.14199 3 1 032.44 $ - $ 1,032.44 $ 103,839.09 i 73,156 1.41942 . . 1 $ 52,810.94 l _ _ 37,206 1 35,950 1.41942 48.299 1.58224 $ 75,187.05] $ 1,233.56 S 76,420.71 86,210.0 15 129,231.65 ; 85,505 ! 1.51139 243 2.90140 $ 705.04 $ - S 705.04 i $ 129,936.69 j 85,746 ' _ 1.51533 $ 77,963.53 I 51,463 `, 34,285 1.51533 29,942 1.81242 1 $ 53,497.37 9 770.18 0 54,267.55 116,152.0 $ 132,251.08 1 61,405 1 1.62461 9,949 1.58239 $ 15,487.61 5 255.57 $ 15,743,10 126,101.01 5 147,994.26 i 91,354 1 1.62001 180 2.78333 6 501.00 $ - $ 501.00 I5 148,495.261 91.534 I 1.62230 12/31/10 END OF MONTH - ..1 $ 74,020.51 i 45,627 ; 45,907 1.62230 01118!71 Sea3 4011 -0004 8,500 1 1.81270 $ 15,186.95 1 221.00 $ 15,407.95 134,601.0 � $ 89,428.46 f 54,127 I 1.65220 01124111„ Sea-3 14011.0009 _ 38,739 1 5 69,214.97 3 1,011.24 5 70,226.21 173,340.0 C 5 159,654.67 1 92,856 1.71919 01731111 MONTHLY INVENTORY ADJUSTMENT 613 4 1.48042 5 907.50 $ - 9 907.50 `r 5 160,562.17 93,479 1 1.71763 ! 01/31/11 END OF MiONTH J -T ' _ - '{ $ 75,567.05 f 43,995: 69,484 1.71763 x02123111 Tema 1_ 46.953 1.62258 9 74,944.71 1 1,240.31 1 76,185.02 220,293.0 S 151,752.07 TI 90,948 I. 1.66856 1 02128111 MONTHLY INVENTORY ADJUSTMENT 390 3.36905 $ 1,313.93 5 - S 1,313.93 _ 3 $ 153,066.001 91,338 1 1.67582 102!28111 _END OF MONTH L - - _ - - - - 5 100,103.40 i 59,734 1 31,604 1.67582 I 03131111 MONTHLY INVENTORY ADJUSTMENT 215 S $ - $ 744.06 $ 100,847.48 ' 59,949 = 1.68222 03131/11 END OF MONTH L .� $ 34,233.20 20,359 4' 34,599 1.68222 j 04108/11 Tama _ _ _ I}018650 9,208 1.58714 $ 14,364.48 $ _ 249.95 5 14,8}4.43 4,208.0 $ 49,847.63 29,558 _ _ 1.65260 04/06/11 Tama ij _ _ 110191 }D{ 9,744 1,60475 9 15,371.16 $ 265.57 5 15 6, 36.67 18,952.0 S 64.484.30 1 39,302 j 1 .64074 04106(11 Tame I 110197791 9,749 1.60475 3 15,379.05 5 265.64 S 15,644.69 28,696.0 - 1 80,128.99 i 49,051 ! 1.63359 04(07(11 Tama _ i__ _110205791 9743 7.63524 $ 15,637.91 S 265.47 5 }5,902.98 38,445.0 ~ $ 96,03}.47 58,794 = 1.63336 '04130171 'MONTHLY INVENTORY RY ADJUSTMENT 362 3.03724 5 1,099.48 5 - 1 $ 1,099.48 $ 97,131.45 59,156 1 1.64195 104!30195 END OF MONTH i ` - - . , .. - ; - - - .• . , - - $ 42,231.07 1 25,720 33,436 1.64195 !05109111 Tema e - _ 190242341 9,632 1.76177 5 16,493.18 $ 928.55 S 77,321.73 48,277.0 $ 59.552.80 35.552 1.67509 7 05/10/11 _ Taro 11024430 9,702 1.78077 5 _ 16,517.56 $ 817.59 $ 17,335.25 57,979 ,0'_3 78,088.05 ! 45.254 1.69903 105713151 Tame _ -T - . 110280107 8,915 1.76677 $ 14,999.49 S 751.28 $ 15,750.75 66,694.0 $ 92,838.60 54,769 1.71018 05716111 , Tarps I _ 110251271 9,016 1.77927 $ - -- 15 285.51 $ 759.84 5 16,045.45 75,9120 f 107664.25 63, 767 1 .72004 f_ 105/31111 MONTHLY INVENTORY ADJUSTMENT 805 1,41853 $ 1,141.92 3 - $ 1,14}.42 S 109,826.57 63,992 1.71625 '05131111 END OF MONTH - - 1 $ 67,381.63 v 39,261 1 24,731 1.71625 06(17111 i 1ar9e ...110278521 !06109111 Targa 1 106/30/11 MONTHLY INVENTORY ADJUSTMENT !06130(11 END OF MONTH 3.46084 744.08 07907111 !Tama _ 110317491 1.07/08111 tg JJ'Taa 11032016.1 • j +I FYTD Totals 1 8,612 1.77832 5 14,936.34 5 734.18 5 15,670.52 84,724.0 1 1 83,052.15 1 48,073 1.72763 8,379 1.80050 9 14,390.94 S 695.43 ' $ 15,086.37 93,103.0 1 5 98,138.52] 56,452 i 1.73844 355 2.85397 $ 1,013.16 S - 5 1,013.16 15 99,151.68 1 56,8071 1.74541 - . 1 $ 47,805.12 1 27,369 I 29,418 1.74541 17,792 1.72641 3 29,979.51 1 5 736.64 i $ 30,716.35 110,895.0 ' S 78,521.47. 45,181 1.73793 9,067 1.70750 S 15,461.91 i 5 15,481.91 119,962.0 !i 5 94,003.38 1 54,248 1 1.73285 313.610 1.66542 $ 510,967.46 $ 11,323.57 S 522291.03 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Jun -11 Jul -11 $ Aug -11 $ Sep -11 $ Oct -11 $ Nov -11 $ Dec -11 $ Jan -12 $ 1.77 1.80 1.75 1.75 1.75 1.75 1.75 30,000 20,000 30,000 30,000 40,000 40,000 50,000 $ 53,100.00 $ 36, 000.00 $ 52,500.00 $ 52, 500.00 $ 70, 000.00 $ 70,000.00 $ 87, 500.00 $ 100,905.12 $ 84,157.14 $ 101,139.56 $ 100,769.03 $ 118, 092.19 $ 117, 996.37 $ 135,457.42 57,389 47,389 57,389 57,389 67,389 67,389 77,389 27,389 $47,805.12 27,389 $48,157.14 27,389 $48,639.56 27,389 $48,269.03 27,389 $48,092.19 27,389 $47,996.37 27,389 $47,957.42 27,389 $47,940.19 1.75 1.76 1.78 1.76 1.76 1.75 1.75 1.75 C S W:0712112011 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Energy CharnelTherm Non -Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIA) Usage & Inflation Adj. (UIA) Total Non -Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy Charge/ Therm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP /Gallon Rate of with 6.0% Franchise Change from 1/2006 Therm Rale % Change from 1 /2006 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/0111973 Non - Utility Taxable Fuel/Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR AUGUST 1, 2011 - SEPTEMBER 30, 2011 BASED ON APPROVED GAS ADJUSTMENT FACTORS Interr. Firm Natural Gas Rate Schedules NG Rate RS SMF MMF LMF SGS MOS LGS RAC GAC LAC SL SL wIM& NGV NSS IS (Closed 1109) Relight (Non -Rest) (Non -Rest) NA (1 - NA (4 + NA (4 + NA (4 + 0 - 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA NA 100,000 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up $10.00 525.00 540.00 $95.00 $25.00 $40.00 $95.00 510.00 $25.00 (510.00) ($40.00) (570.00) (5160.00) ($40.00) (570.00) (5160.00) (518.00) ($40.00) if not prey. if not prey. billed billed $40.00 ($70.00) if not prey. billed $20.00 520.00 By Contract 550.00 5250.00 (530.00) ($30.00) (By Contract) ($75.00) 5400.00 Attachment 44 Contract NG Rate CNS NA By Contract (By Contract) $0.48 $0.48 $0.48 $0.48 $0.46 $0.40 $0.34 50.20 $0.15 $0.10 $0.20 $0.35 By Contract 50.46 $0.28 By Contract 0.12 0.12 0.12 0.12 0.12 0.12 0.12 NA NA NA 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 NA NA NA 0.02 Q02 0.02 Q s 0.05 0.05 0.05 NA NA NA NA NA NA NA NA NA $0.64 $0.64 $0.64 $0.64 $0.65 $0.59 50.53 $0.20 50.15 $0.10 50.20 $0.35 By Contract $0.46 $0.28 By Contract 018 0.78 2 0.78 921 0.78 0.78 0.78 0.78 078 0.78 0.78 0.70 0.78 0.70 0.70 1.42 1.42 1.42 1.42 1.43 1.37 1.31 0.98 0.93 0.86 0.98 1.13 0.70 1.24 0.98 0.70 + Non -Fuel + Non -Fuel $10.00 $25.00 $40.00 595.00 $25.00 $40.00 595.00 510.00 $25.00 540.00 $20.00 520.00 By Contract 550.00 5250.00 Customer ($16.00) (540.00) (570.00) ($160.00) (540.00) (570.00) (5160.00) ($18.00) (540.00) (570.00) ($30.00) (530.00) (8y Contract) ($75.00) 5400.00 Charge + premise © premise CCU premise + FAC + FAC + FAC + FAC + Non -Fuel Therm Non -Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms $ 1.30 $ 1.30 $ 1.30 $ 1.30 $ 1.31 $ 1.25 $ 1.20 $ 0.90 $ 0.85 $ $ 1.38 $ 1.38 $ 1.38 $ 1.38 $ 1.39 $ 1.33 $ 1.27 $ 0.95 $ 0.90 $ $ (0.84) $ (0.84) $ (0.84) $ (0.84) $ (0.72) $ (0.72) 5 (0.72) $ (0.90) $ (0.90) $ -37.2% -37.2% - 37.2% - 37.2% -33.5% - 34.4 % -35.5% -47.9% -49.2% 0.81 $ 0.90 $ 1.03 $ 0.64 $ 1.13 $ 0.90 0.85 $ 0.95 $ 1.10 $ 0.68 $ 1.20 $ 0.95 (0.90) $ (0.90) $ (0.85) $ (1.08) $ (0.91) $ (0.76) - 60.7% -42.3% -43.7% - 50.6% -47.9% - 42.9°% $0.069 50.069 50.069 $0.069 50.069 $0.069 $0.069 50.069 50.069 $0.069 S0.069 $0.069 $0.711 $0.711 $0.711 $0.711 50.711 $0.711 $0.711 50.711 50.711 $0.711 $0.711 $0.711 50.069 50.069 50.055 50.631 $0.711 50.645 BTU FACTOR = THERMS /100 CUBIC FEET (CCF) 10/2010 11/2010 1212010 01/2011 02/2011 03/2011 04/2011 05/2011 06/2011 07/2011 0812011 09/2011 FY 10111 Average Firm Service Rates 1.040 1.038 1.038 1.040 1.037 1.037 1.037 1.036 1.036 1.036 1.035 Interruptible Service Rates 1.019 1.018 1.018 1.020 1.017 1.017 1.017 1.016 1.015 1.015 1.015 $ (0.76) - 52.1% 50.069 50.631 CSW:07/21/201 1 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms /100 cubic feet (CCF) 0.915 Therms /Gallon CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR AUGUST 1, 2011 - SEPTEMBER 30, 2011 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #5 Page 1 of 2 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) Monthly Customer Charge $10.00 $25.00 $10.00 $25.00 $40.00 $40.00 $50.00 Set By Contract For Each Meter Non -Fuel Energy Charges/Gallon: Non -Fuel Energy Charge (NFE) /Gallor $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract $1.00 Set By Contract Energy Conservation Adj.(ECA)IGallor 0.12 0.12 0.12 0.12 0.12 NA NA NA Regulatory lmposltion Adj.(RIA)/Gallof 0.02 0.02 0.02 0.02 0.02 NA NA NA Usage & Inflation Adj. (UTA)/Gallon 0.02 0.022 0.02 0.05 0.05 NA NA NA Total Non -Fuel Charges (NF)1Gal. $2.06 $2.06 $1.06 $0.49 $0.44 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA) /Gal 2.30 2.30 2.30 2.30 2.30 Set By Contract 2.30 2.00 Total Energy Charges/Gallon $4.36 $4.36 $3.36 $2.79 $2.74 Contract NFE $3.30 Contract NFE + + Contract PGA 32.000 Customer Charge Customer Charge + Minimum Monthly Bill $10.00 $25.00 $10.00 $25.00 $40.00 Any Applicable $50.00 Non -Fuel Energy Chg. Customer Charge for the Contracted + Any Applicable # of Gallons /Mo. Facility Charges Utility Tax Note: Fuel Rate per Gallon 10101/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non - Utility Taxable Fuel /Gallon $2.139 $2.139 $2.139 $2.139 32.139 Contract PGA - 0.161 $2.139 Contract PGA - 0.161 Change from 8/2008 Gallon Rate $ 0.22 $ 0.22 $ 0.02 $ 0.05 $ 0.05 NA $ 0.37 NA % Change from 812008 Gallon Rate 5.3% 5.3% 0.6% 1.8% 1.9% NA 12.6% NA CSW:0712112011 BTU Factor: BTU Factor: Therm Factor: Applicable Annual Galion Range or Other Rate Determinant Annual Customer Charge $ Non -Fuel Charges iNFl /Galion: Non -Fuel Energy Charge (NFE)/Gal. $ Energy Conservation Adj. (ECA)(Gal. $ Regulatory Imposition Adj. (RIA) /Gal. $ Usage & Inflation Adj. (UTA)/Gallon Total Non -Fuel Charges (NF)fGal. $ 2.714 2.483 0.915 Gallons/100 cubic feet (CCF) Therms/100 cubic feet (CCF) Therms /Gallon STANDARD RESIDENTIAL BULK LP SERVICE {Rate Class is Based on Annual LP Gallon Usage Level) BRLP1 BRLP2 BRLP3 BRLP4 0 -60 60.1 - 120 1 -3 UNITS 1 -3 UNITS 120.1 - 300 1-3 UNITS 90.00 $ 1.00 $ 0.12 0.02 0.02 210.00 $ 160.00 $ 1.80 $ 0.12 $ 0.02 $ 0.020 1.60 $ 0.12 0.02 0.020 > 300 1 -3 UNITS 75.00 0.90 0.12 0.02 0.02 Attachment #5 Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR AUGUST 1, 2011 - SEPTEMBER 30, 2011 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.12 0.12 0.02 0.02 0.02 0.02 1.96 $ 1.76 $ 1.16 $ 2.30 $ 2.30 $ 4.26 $ 4.06 $ 3.46 $ Purchased Gas Adj. (PGA) /Gallon $ 2.30 $ Total Energy Charges /Gallon $ Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 Non - Utility Taxable FuellGalion $ 0.161 $ 0.161 $ 0.161 $ $ 2.139 $ 2.139 $ 2.139 $ Change from 8/2008 Gallon Rate $ % Change from 8!2008 Gallon Rate 0.220 $ 0.220 $ 0.02 $ 5.4% 5.7% 0.6% 1.06 2.30 3.36 $ 1.76 $ $ 2.30 $ $ 4.06 $ COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) BCLP1 BCLP2 0 - 2,500 Customers in this Range of Usage $ 90.00 1.06 $ 2.30 $ 3.36 $ 0.161 $ 0.161 $ 0.161 $ 2.139 $ 2.139 $ 2.139 $ 0.02 $ 0.22 $ 0.02 $ 0.6% 5.7% 0.6% > 2,500 Customers in this Range of Usage $ 90.00 0,25 $ 0.12 0.02 0.05 0.44 $ 2.30 $ 2.74 $ 0.161 $ 2.139 $ 0.0% 0.20 0.12 0.02 0.05 BULK STANDBY! GENERATOR LPSB (Closed for New Residental Applications) $ 420.00 0.39 $ 2.30 $ 2.69 $ 1.00 NA NA NA 1.00 2.30 3.30 0.161 $ CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract Set By Contract NA NA NA Set By Contract 2.00 Cotract NFE + 2.000 0.161 2.139 Contract PGA - 0.161 0.37 12.6% NA NA CSw:07/21n011 Residential Rate History Y B Com one _._.... P n s Clearwater Gas System .. . e Rate. Adjustments/Therm Mont VG/therm !LP/gallon " E A EIA/RIA# 41 WNA/UTA ResI # 4 UTA- CQmll# Oct -08 $ 1.990: 3.300 $ 0.140 ': $ $ Nov -08 $ 1.990 ' $ 3.300 r $ 0.140 i $ $ $ 2.770 $ 0.140 : $ - $ Jan -09 $ 1.750 $ 2 -290 # $ 0.090 , $ $ Feb-09 $ 1.750 1 $ 2.290 $ 0.090 $ r_09_..$.. 1.580 $ 2.270 - - -- -- - - -- - -. _......- - $ 0.070... $ Mar-09 $ 1.580 $ 2.200 _..._ _... . _.. Apr- 09 0.040 $ -. -_ May-09 $ 2.200 ... Jun -09 $ 1.4101$ 2.200 $ 0.040 $ y._ .... Jul -09 $ 1.350 ; $ 2.330 $ 0.0.40 $ Sep -091 $ 1.390 , $ 2.650 90 _........._.1.. _ $ 0,040 :.$ 9_ $ 0.070 ! $ FY 08/09 Avg. $ 1.610 $ 2.524 2008 Avg. $ 1.965 I $ 3.186 Oct-09L $ 1.390 $ 2.670 Nov-091 $ 1.390 $ 2.6 50 __ -- 1.390 Y Dec-09 $ $ 2.750 Jan -10 $ 1.390 $ 2.7 -- 50 Feb-10 $ 1.480 $ 2.810 M r $ 1.520 $ 2.880 Mar-10 $ 1.520 $ Apr-10 8sD 2.850 ay -10 $ $ - -- 1.490 ' Jun-10 $ 1.460 $ Aug-.101 Jul-10 ..$ .... 1 99 $ 2. .390 $..._ 3.09 --_ Sep -101 $ 1.390 $ 3.090 FY 09/10 Avg. I $ 1.437 I $ 2.865 2009 Av $ 1.464 ' $ 2.41 B Attachment #6 Page 1 of 3 Contract LP PGA I PGA I PGA/gaUI40 . $ .... - $ 1.270: $ 1.190 ..._... 0 1 $ 2.260 $ $ 1.270 I $ 1.190 ' $ 2.260 _ - $ - $ 1.220 !i $ 1.140 $ 1.730 - $ - $ 1.180 ; $ 1.100 $ 1.200 $ $ 1.180 I $ 1.100 $ 1.200 - --..5 1.200 $ 0.950 $ 1.200 $ - $ 0.890 $ 0.810 $ 1.16 ..._ _ 1 16_ $ 0.890 $ 0.810 $ 1.160 $ 0.830' $ 0.750 $ 1.290 $ 0.890 $ 0.810 $ 1 _2290 3 0.830 ; $ 0.750 J $ 1.450 ■ $ 0.830 $ 0.750 ! $ 1.570 0.010 $0.0781 $ 0.001;$ $ 0.136 $ - $ 70 : $ 0.010 $ $ ._. 0 ... $ 0.00 70 $ 0.010 ' $ $ 0.070;$ 0.010 $ $ 0.070:$ 0.010,$ $ 0 0 _ i 0.01 $ D $ 0.110 $ 0.010'',$ $ 0.110' $ 0.010 $ $ 0.090 $ 0.030 $ $ 0.090 $ 0.030 $ $ 0.090$ 0.030$ $ 0.090 $ 0.030 • $ $ 0.090 $ 0.030 $ - I $ - I $ 1.026 $ 0.946 0.013: $ 9 I Oct -10 $ 1.47 t $ 3.02 Nov -10 $ 1.47 $ 3.02 i Dec -100 $ 1.47 $ 3.02 $ 3.33 Feb-11 $ 1,55 Mar-11 $ 1.55 L $ ... 3.37 .. A -11 $ 1. 6 .............. 8. Apr -11 $ 1.46 $ 3.28 , y $........1.45_.. _$ ..... 3.35 i. Jun -11 $ 1.45 _5 3.35 Jul- 71 $ 1.45 $ 3.3 .3- 5' Aug_11 $ 1.42 $ 3.46+ Sep -111 FY 10/11 Avg. I $ 1.480 2010 Avg. I $ 1.457 $ 3.265 I $0.0881 $ 0.0181$ - I$ $ 0.061 I $ 0.003 i $ $ 0.101$ 0.02_$ 3 0.101$ 0.02 $ $ 0.10 1 $ 0.02 $ 1$ 0.10 I $ 0.02 $ $ 0.131 $ 0:03 �$ $ 0.13 3 0.03 $ $ 0.10!$ 0.04 $ $ 0.12 13 0.02 $ $ 0.12 $ 0.02 $ $ 0.12 3... 0.02 LS T$ 0.12$ 0.021$ $ 1.470 - I $ 1.237 $ 1.157 $ 2.138 1...__. - $ 0.830 $ 0.830 $ - 0.750 $ $ 0_830 $ 0.750 1 $ - $ 0.830 $ 0.750 $ $ 0.8- 0.800 $ $ 0.920 $ 0.840 $ - $ 0.920 $ 0.840 $ $ 0.890 $ 0.810 I $ . ... i $ $ 0.830 $ 0.750 - $0.7901$ 0.710,$ - $0.7901$ 0.7101$ 1,590 1.590 1.670 1.670 1.690 1.760 1.760 1.730 1.830 1.870 1.970 1.970 - 5 0.850 $ 0.770 1 $ 1.758 - I $ - I $ 0.920 I $ 0.840 I $ 1.353 f a$ $ -. 0.87 $ 0_79 $ 1 90 $ ' $ 0.87 $ 0.79 1 . = $ 1;91) 0.02 $.......... 0.03 1 $ 0.92 $ 0 74 $ ._......... 2 _19 $ 0.87 $ 0. 84 $ 2.19 0.02 0.02 3 $ 0.05 $ 0.82 , $ 0.74 $ - -- 0.02 $ 05 1- $ 2.19 89 $ 0.81 $ 2.19 0.0 2.12 0.02 $ ....... 0,05 .... $ 0:81. ' $ ... 0.73 $.... 2._. .119 9 .05 -- r 0.73 $ _ 219 0.02 $ 0_.05 $.. 0:81 I 0..- _ 2. 0.02 $ 0.05 $ _0.81 $ 19 0.02 , $ 0.05 $ 0.78 $ 0.70 1 $ 2.30 $ 2.946 $0.1131 $ 0.0241$ $ 0.096! $ 0.0211$ 0.015 1 $ 0.035 $ 0.849 I $ 0.769 I $ 2.115 - I $ - $ 0.860 I. $ 0.780 $ 1.829 Same Above Month $ ... 0 2% .$ ...-.. 74- Last Year 1 ...... - - -- 12% ncr on 20 Therms 0 $ 8. ased $.._._ 0 2 .39 - - .09 Equivalent,.. ---- . .......... ... Cents/KWH 4.8 12.9 for Gas vs. FPC Rate (Residential) Gas Cheaper by Notes;.._ .._..... :. . " Based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & equal to Residential LP Will Call (BRWCLP)_ # New rates implemented 1/1/2009, with following changes_ _ R5 NG Customer Charge increased $2 from $8 to $10 /month & NFE rate droped 10 cents to 48 cents/therm (CC +$1 /Mo. - in 4/1/2005) BRLP3 LP Customer Charge increased $18 from $72 to $90 /year, and NFE rate ra ised 10 cent to $1.00 /gallon (CC +12/yr. In 4/1/2005). a ge W g tinst ..e o . l- ...... _ _ .. additions to new com se initially, c an ed to RIA & WNA than ed to UTA, but no nents of the UTA implemented 1/1/2011 0.02 1 $ 0.05 $ (0.01) $ (0.01) $ 0.33 17% 12.9 12.9 Note: This is Progress Ene rg y's resid ential rate for usage X1,000 KWH, CSW:9/29/2009 Attachment #6 Page 2 of 3 Competitive History of NG vs. Electric Rates Month -Year September 2001 September 2002 September 2003 September 2004 September 2005 September 2006 September 2007 September 2008 September 2009 September 2010 NG Therm $ $ $ $ Increase over Last 9 Years $ % Increase over Last 9 Years Avg. Annual Inc. Over Last 9 Yrs. Cost 1.34 1.36 1.56 1.69 1.97 1.89 1.86 2.12 1.39 1.39 NG Equivalent KWH Cost $ 0.046 0.05 $ 3.7% 0.4% 0.046 0.053 0.058 0.067 0.065 0.063 0.072 0.047 0.047 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.00 $ 3.7% 0.4% 0.05 62% 6.9% NG vs. Electric - 46% - 37% - 37% -35% - 31% - 46% - 47% - 40% - 64% - 65% Csw:12/20/2010 Attachment #6 Page 3 of 3 Annual .. A vera ge CG S Resid ential Rates Calender Year Fiscal Year Year NG/Therm L LP /Gallon * Year NG/Therm LP /Gallon * 1995 NA NA L FY 95/96 $ 0.880 $ 1.199 1* 1996 1.049 $ 1.288 * $ 0.915 i $ 1.239 * FY 96/97 $ 1.019 $ 1.370 * 1997 - -- - -- - - - - -- -- -._... . ._... 1.318 * 98 19 ............ 1.032 $ 1.288 * FY 98/99 . $ 1.052 $ 1.269 $ :....._........ * 1999 1.073 $ 1.311 FY 99/00 $ 1.152 $ _.. _.__.._.... 1.504 2000 $ 1.222 $ 1.584 FY 00/01 1 $ 1.551 ' $ 1.649 200 1.... $ 1.549 $ 1.586 FY 01/02 $ 1.352 $ 1.488 2002 342_.__. -- ................. �- 1.553..... FY 02/03 1 $ 1.477 $ 1.817 2003 $ 1.._ .. _ - -.... ......._.. 1. _..- - -- -- - - - -._ ... _._534 34 $ 1.864 FY 03/04 $ 1.603 $ 1.913 2004 $ 1.652 $ 1.968 FY 04/05 $ 1.803 $ 2.162 2005 $ .............1.925 $ FY 05/06 $ 2.080 2.480 2006 $ 2.012 , $ 2.501 FY 06/07 $ 1.918 $ 2.742 2 007 $ 1 _._ -- ...._._._ .....--- .-893 r $ FY 07/08 $ 1.932 1 $ 3.183 2008 $ 1.965 $ 3.186 FY 08/09 $ 1.610 $ 2.524 2009 $ 1.464 $ 2.418 FY 09/10 _ $ 1.437 1 $ 2.865 2010 $ 1.457 $ 2.946 FY ._. Y 10/11 Average $ 1.472 $ 1.998 $ 1.461 $ 1.966 Notes: Based on the Residential Metered Propane schedule which was closed .... - - - -- - - - - -- -- p for new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond for customers using based on Bulk LP (BRLP3) which is applicable 120.1 - 300 gallons /year & is equal to Residential LP Will Cali