Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MARCH 2008
~ . , MAR 0 3 2008 CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet ..CORD en '!./ > TO: William B. Horne II, City Manager FROM: Chuck Warrington, Managing Director COPIES: Rod Irwin, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Tom Madley, Sr. Accountant/CCS; Laura Damico, Sr. Accountant/CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE MARCH 2008 DATE: February 27, 2008 Both Natural Gas and Propane (LP) markets remain high historically but are remaining somewhat stable at this time due to high storage levels and the lack of any major storm disruptions this year. Hence, we are recommending a reduction in our Natural Gas Purchased Gas Adjustments (PGA) of 3(:/therm and a reduction in our LP PGA of 5(:/gallon at this time. We will continue to closely monitor our actual gas supply costs and propose changes if we see the near-term costs change substantially. Our ECA rebates have been down this year due to the slowdown in the building industry and the economy as a whole; therefore, we are recommending a 3(:/therm or gallon reduction in our Energy Conservation Adjustment (ECA). We are not recommending any change in our Environmental Imposition Adjustment (EIA) at this time. We have had an unseasonably warm winter this year and project that the Heating Degree Days will fall 36% below normal this year, which exceeds the 10% threshold for implementation of our Weather Normalization Adjustment (WNA) clause at this time. We are recommending implementation of a WNA of 3(:/therm until we recover an estimated shortfall of $254,940. The net effect of these recommended changes is a reduction in our typical Residential Natural Gas customer's rate of 3c';/therm (down 1.6%) and a decrease of 5(:/gallon (down 1.6%) in our typical Residential LP customer's rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after March 1, 2008: Natural Gas Firm Standard Rate Schedule PGA ....... $1.05 per therm (down 3(:/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.97 per therm (down 3(:/therm) Propane (LP) Gas Rate Schedule PGA .................... $2.04 per gallon (up 5(:/gallon) Energy Conservation Adjustment (ECA) ............... $0.15 per therm or gallon (down 3(:) Environmental Imposition Adjustment (EIA) ......... $0.00 per therm or gallon (no change) Weather Normalization Adjustment (WNA) .......... $0.03 per therm or gallon (up 3(:) William B. Horne II, City Manager Page 2 February 27, 2008 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru January and projections thru Period 13 of this fiscal year. These show that we are projecting being ahead on our collections by about $250,000 by FYE, which is very close to how we started the year. This is important to our fiscal condition. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachment #4 shows our WNA calculations based on our Heating Degree Days projections. Attachments #5 and #6 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #7 shows our rate history over the past 3 + years and shows our relationship to electric prices. I should point out that the overall effect is that our typical Residential customer rates are now 47% lower than electric for Natural Gas and still 1 % lower for lP. Therefore, we remain in an extremely competitive position vs. electricity. It is our plan to use the above-proposed adjustments for billings through September 30, 2008, unless there is a significant change in our forecasts or we project a significant over/under recovery of our adjustment clauses. We will continue to track these balances monthly, 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 March 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments ~~~'7Zr William B. Horne II, City Manager Approved: U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for March 2008.doc CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 (5) Commodity adjustment from FYE transfer of ECA Collected in PGA@ 1/2 of the ECA Rate ~_ NG_Profli'rt~~_= 9~78% x Total ECA Transfer = $ 26,341.28 _ __ + Transfer of WNA to PGA = $ (20,056.55) - - ~ - Monthlv Cumulative LP PGA Commo~=--- Total LP Fuel Total LP PGA Overage YTO Overaae I Therm/Gal. Charges I EXl'ellses _ Billed (Shortage) (Shortage) I - I $ (37,784.74) 50,559.61 1 $ 192,749.88 $ 69,856.53 $ (122,893.35) $ (160,678.09) 50,679.05 $ 51,482.44 $ 68,188.12 $ 16,705.681$ (143,972.41) 61,705.82 $ 62,425.68 $ 80,633.03 $ 18,207.35 $ (125,765.07) 96,676.29 $ 97,305.11 $ 122,012.14 $ 24,707.03 $ (101,058.04) 94,050.00 $ 94,555.29 $ 118,907.30 $ 24,352.01 $ (76,706.03) 87,450.00 $ 87,833.53 $ 111,990.25 $ 24,156.72 $ (52,549.31) 74,880.00 I $ 75,142.75 $ 97,736.95 $ 22,594.20 I $ (29,955.10) 70,200.00 $ 70,349.78 $ 91,628.39 $ 21,278.61 $ (8,676.49) 65,520.00 $ 65,563.38 $ 85,519.83 $ 19,956.45 $ 11,279.96 57,720.00 $ 57,663.60 $ 75,338.90 $ 17,675.30 $ 28,955.26 57,720.00 I I $ 57,57522 , $ 75,338.90 $ 17.763.67_~L_46!718.93 57,720.00 i $ 57,486.41 $ 75,338.90 $ 17,852.49 I $ 64,571.43 4 I $ 181596.70 $ - $ (18,596.70)1 $ 45,974.72 $ 988,729.78 $ 1,072,489.24 $ 83,759.46 I NATURAL GAS PURCHASED GAS ADJUSTMENT IPGA-NGl Reservation Charaes Commodity Charges Interest Expense Cost Center Expenses Budget Month Prior Year Oct-07 K=_2'995~07.81- $ 986,429.07 $ - $ 31,242.98 1 Nov-07 $ 162,347.55 $ 1,119,202.77 $ 8,307.01 $ 41,104.95 Dec-07 $ 150,733.55 I $ 1,402,134.03 $ 7,248.88 $ 56,275.23 Jan-08 1$ 134,272.1L $ U05,922.47 $ 5,395.91 $ 40,794.65 Feb-08 :1 $145,00():9~0 J_~.___ 1,650,000.00 $ 5,171.14 $ 55,622.00 Mar-08 $ 159,000.00 $ 1,550,000.00 $ 4,747.75 $ 28,357.97 Apr-08 $ ___~~?IOOQ_.~_~_______.___ 1,500,000.00 $ . $ 28,913.33 ~y-08 $ 78,000.00 $ ______ 1,400,000.00 $ - $ 43,420.02 Jun-08 $ 78,000.00 $ _ 1,300,000.00 $ - $ 44,808.02 Jul-08 $ 78,000.00 $ 1,200,000.00 $ - $ 37,094.06 Aug-08 $ 78,000.00 $ ___ __ __ , 1,200,000.00 $ - 1$ 47,880.06 Sep-08 $ 78,000,00 $ 1,200,000,00 $ - $ 17,502.73 h' Per13 1$ 6,284.73 $ - $ - $ - 5 Total YTD! $ 4,258,545.81 $ _. 16,213,688.34 $ 30,870.69 $ 473,016.00 (1) Includes annual Charge_for A~f1lirl.of $648,160 + .Ann!:lal CCS chg of $959,620 + Dividend $1,276,400 + FY 06/07 PGA write off of $28,277.51 + WNA $135.64';' $ 2,912,593.15 Note: Billed'includeso'eferred-Revs re:couJJ of $982,285.39 (2)----=~~T-----:--- ~~_-=--==~-- Net RC = $ 1,339,667.93 r--- [ -.- I -. ----.----- PROPANEILPI GAS-PURCHASED GAS ADJUSTMENTIPGA-LPl ____..1____1____. Budget i Gallons _ Monthly ~~~~~=:.. S::5:8_=I[~---- ~~COG NOv-O'ft= 33,056.8 $ _ Dec-07 38,487.0 $ Jan-08 I '58)78.4 ~---- Feb-08 ' 57,000.0 I $ Mar-08 55,000.0 I $ Apr-08 48,000.0 $ May-08 45,000.0 $ _~_ 42,000.0 1$ ~ 37,000.0 1$ Aug-08 i 37,000.0 I. $ Sep-08 37,000.0 $ Per13 Total YTD 524,345.0 $ Cost Center Exoenses CCS Chg + Admin Cha + Dividend FY 06/07 Write off PGA & WNA Fuel PC Anywhere LP Yard Vaporization LP PGA Event fuel cost I Depreciation of LP Tanks Suburban Software Systems Suburban Software Systems License Contribution to garage LP trk upgrade Interest I Expense I I I 1.38433 I $ 1.53309i $ 1.60329 $ 1.65887 $ 1.65000 , $ 1.59000 $ 1.56000 $ 1.56000 $ 1.56000 $ 1.56000 $ 1.56000 i $ 1.56000 $ 188.92 $ 803.39 $ 719.86 $ 628.83 $ 505.29 $ 383.53 $ 262.75 $ 149.78 $ 43.38 $ (56.401 $ (144.78) $ (233.59) I $ 1.57316 $ 3,250.96 $ 824,880.77 $ 88,530.00 1 1,136.69 1 15,000.00 1 159.00 1 941.73 I 1 - I 1 34,414.23 1 1,250.00 1 569.70 1 1 Total NG PGA Billed Monthlv Overaae (Shortaae) Total NG Fuel Expenses - $ 4,013,579.86 $ $ 1,330,962.28 $ $ 1,616,391.69 $ $ 1,886,385.20 $ $ 1,855,793.14 $ $ 1,742,105.72 $ $ 1,643,913.33 $ $ 1,521,420.02 $ $ 1,422,808,02 $ $ 1,315,094.06 $ $ -- 1,325,880.06 $ I $ 1,295,502.73 $ 1$ 6,284.73 $ $ 20,976,120.84 $ I 2,306,584.81 $ (1,706,995.05) 1,542,587.20 $ 211,624.92 1,986,985.55 $ 370,593.86 1,931,339.18 $ 44,953.98 1,940,472.04 I $ 84,678.90 1,882,257.88 $ 140,152.16 1,788,144.98 $ 144,231.65 1,684,620.80 I $ 163,200.78 1,599,919.20 $ 177,111.18 1,458,749.86 $ 143,655.80 1,458,749.86 $ 132,869.80 1,458,749.86 $ 163,247.13 - I $ (6,284.73 21,039,161,21 $ 63,040.37 Attachment #1 Page 1 of 3 Cumulative YTO Overaae (Shortage) $ 45,593.93 $ (1,661,401.12) $ (1,449,776.20) $ (1,079,182.34) $ (1,034,228.36) $ (949,549.46 $ (809,397.30) $ (665,165.64) $ (501,964.86) $ (324,853.68) $ (181,197.89) $ (48,328.09) $ 114,919.03 $ 108,634.30 NG PGA RatelTherm FirmlContr 1.08/1.00 1.08/1.00 1.08/1.00 1.08/1.00 1.08/1.00 1.05/0.97 1.05/0.97 1.05/0.97 1.05/0.97 1.05/0.97 1.05/0.97 1.75/1.91 1 a1/') na 1.9112.09 1.91/2.09 1 <>.7/') nA 1.87/2.04 1.87/2.04 1.87/2.04 1.87/2.04 1.87/2.04 (2)1 I I I (4) Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate LP Proportion = 2.22% x Total ECA Transfer = $ 598.05 + Total Cost Cntr Exp $ 142,001.35 $ Proj. Adders 160,000.00 $ I Allow for 17,998.65 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 Budget Month Prior Year Oct-07 $ 318,454.23 Nov-07 $ 95,913.73 Dec-07 $ 76,495.95 Jan-08 $ 79,959.70 ~~-08 . $ 150,000.00 Mar-08 $ 125,000.00 I Apr-08 $ 125,000.00 May-08 $ 125,000.00 Jun-08 $ 125,000.00 Jul-08 $ 125,000.00 Aug-08 I $ 125,000.00 Sep-08 $ 125,000.00 Per13 I ~~tal YTD $ 1,595,8236==____ $ (1) Includes annual charge for Admin Chg of $38,760 + CCS chg of $69,670 + Dividend on111 ,680+ FY 06/07 Write off of $4,464.66 = - $ 224,574.66 ~;) 1_+____.___ -1--.___--. -=-:-- Net CCE= $ 1 ,371 '24~---___-~'. .- ENVIRONMENTAL IMPOSITioN ADJU-STMENfIEIAl ----- i Cost Center i Expenses 1 Notes/Exceptionalltems I 14,182.79 i 1,427.00 : 2,909.70 1 4,529.35 10,000.00 10,000.00 I 10,000.00 ! 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 ENERGY CONSERVATION ADJUSTMENT IECAl Cost Center I Expenses NoteslExceptionalltems Promo$36,720,Adv $0, Employ Costs$57,160 $ Promo$26,790,Adv $1,730, Employ Costs$67,394 $ Promo$23,405,Adv $1,025, Employ Costs$22,066 $ Promo$24,930,Adv $230, Employ Costs$54,800 $ $ 1$ 1$ $ $ $ $ $ Budget Month Prior Year Oct-07 $ Nov-07 $ Dec-07 $ Jan-08 $ Feb-08 $ Mar-08 $ Apr-08 I $ May-08 $ Jun-08 $ Jul-08 $ Aug-08 $ Sep-08 $ Per13 i $ Total YTD $ Net CeE= $ Monthly Cumulative ECA Total ECA Total ECA I Overaae VTe Overaae NGlTherm Expenses Billed (Shortage) (Shortage) LP/Gal. - $ - $ 318,454.23 $ 111,884.77 $ (206,569.46) $ (206,569.46) 0.18/0.18 $ 96,946.58 $ 122,642.60 $ 25,696.02 $ (180,873.44) 0.18/0.18 $ 77,400.32 $ 156,000.42 $ 78,600.10 $ (102,273.33) 0.18/0.18 $ 80,471.07 $ 188,214.03 $ 107,742.96 $ 5,469.63 0.18/0.18 $ 149,972.65 $ 165,303.38 I $ 15,330.72 $ 20,800.35 0.18/0.18 $ 124,896..00 $ 137,618.88 I $ 12,722.88 $ 33,523,23 , ';;J);ttifQ;j,$)<.; $ 124,832.38 $ 130,453.32 i $ 5,620.94 $ 39,144.17 0.15/0.15 $ 124,804.28 $ 122,885.96 I $ (1,918.32) $ 37,225.85 0.15/0.15 1$ 124,813.87 $ 116,657.95 $ (8,155.92) $ 29,069.92 0.15/0.15 $ 124,854.65 $ 106,277.94 $ (18,576.71) $ 10,493.21 0.15/0.15 $ 124,947.53 $ 106,277.94 $ (18,669.60) $ (8,176.39) 0.15/0.15 $ 125,040.88 $ 106,277.94 $ (18,762.95 $ (26,939.33) 0.15/0.15 $ - $ 26,939.33 $ 26,939.33 $ - $ 1,597,434.44 $ 1,597,434.44 I $ - Interest Expense 1,032.85 904.37 511.37 (27.35 (104.00) (167.62) (195.72) (186.13 _(~5.35) (52.47) 40.88 I 6 1,610.83 Attachment #1 Page 2 of 3 (6) = Transfer of ECA Collected in PGA@ 1/2 of the ECA Rate (up to ECA Annual Shortfall) Note: Maximum amount which can be transferred = $ 785,247.55 $ 1$ $ $ $ $ $ $ $ $ $ $ $ 1$ i t ---i-MonthlY Total EIA-~--Total EIA r--"O'verage Expenses I Billed" J (Shortage) i I 1 $ __.J.~,.182.79 I $ (0.21)1 $ 2 I $ 1,427.00 $ 95,999.86 $ $ 2,909.70 I $ (0.03) $ $ 4,529.35 $ (0.76) $ $ 10,000.00 $ - $ I $ 10,000.00 $ - $ $ 10,000.00 $ - $ 1$ 10,000.00 I $ - $ $ 10,000.00 $ - $ $ 10,000.00 $ - $ $ 10,000.00 $ - $ $ 10,000.00 ' $ - $ $ - $ - $ $ 103,048.84 $ 95,998.86 $ T --+ 1~-~ -~---=- L ! Interest I I 1 Expense i I i I I $ -(14,183.00); $ 94,572.86 $ 12,909.73) $ (4,530.11) $ (10,000.00) $ (10,000.00) $ (10,000.00) $ (10,00000) $ (10,000.00) $ (10,000.00) $ (10,000.00) $ (10,000.00) $ - $ (7,049.98) $ 10,484.79 I I Cumulative VTe Overage (Shortage) 113,277.52 99,094.52 193,667.38 190,757.65 186,227.54 176,227.54 166,227.54 156,227.54 146,227.54 136,227.54 126,227.54 116,227.54 106,227.54 106,227.54 EIA NGlTherm lP/Gal. 0.00/0.00 0.00/0.00 0.00/0.00 0.00/0.00 0.00/0.00 0.00/0.00 0.0010.00 0.00/0.00 0.00/0.00 0.0010.00 0.00/0.00 0.00/0.00 Attachment #1 Page 3 of 3 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 07/08 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIAl Total NGlTherm-Firm LP/Gallon Cumulative YTD Overage (Shortage) 121,086.71 (1,929,554.15) (1,580,954.66 (1,116,463.09) I (943,589.23) (829,227.60) (662,195.83) ,j (499,749.04 (327,187.96 (148,276.26) (15,521.88) 106,441.99 258,778.67 260,836.57 Monthlv Overage (Shortage) - $ - $ 2,488,325.90 $ (2,050.640.86 $ 1,829,417.78 $ 348,599.49 $ 2,223,618.97 $ 464,491.58 $ 2,241,564.59 $ 172,873.86 $ 2,224,682.72 $ 114,361.63 $ 2,131,867.01 $ 167,031.77 $ 2,016,335.25 I $ 162,446.79 $ 1,899,135.15 $ 172,561.07 $ 1,802,096.98 $ 178,911.70 $ 1,640,366.69 $ 132,754.38 I $ 1,640,366.69 $ 121,963.87 $ 1,640,366.69 $ 152,336.67 $ 26,939.33 $ 2,057.90 $ 23,805,083.75 $ 139,749.86 Total Recovery Billed Total All Expenses Budget Month Prior Year Oct 07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 ~1-08 Aug-08 Sep-08 Per13 Total YTDi t--:=~- I .,,-- ~____u__._m_ Total of All Additional Expenses Recovered Thru A(jjustment Clauses = I-.'.----l------ .., I -- WEATHER NORMALIZATiON iWNAl ~I- -=--1- , '-j--' I - I $ 4,538,966.76 $ 1,480,818.29 1,759,127.39 2,068,690.73 2,110,321.08 1,964,835.25 1,853,888.46 1,726,574.07 1,623,185.27 1,507,612.31 I 1,518,402.82 1,488,030.02 24,881.43 I I $ 23,665,333.90 $ --1- uU} __ ::=-:1 1 ?~/? nQ 1.26/2.27 1.26/2.27 1.26/2.27 '!l~~~~.t~!~...., 1.20/2.19 1.20/2.19 1.20/2.19 1.20/2.19 1.20/2.19 1.20/2.19 ..-.-'- ~~-l-. -- -:. L-__. .....L__....~.. f u_~ --- ~H =-=i.- - --- .L.-- II $ 3,289,653.95 WNA NGlTherm LP/Gallon Cumulative .]'TD Overage (Shortage) (254,940.00) (254,949.80) (254,949.96) (254,952.17\ (254,953.45) (254,953.45) (193.303.45) b (134,863.45) (79,813.45) (27,553.45) 20,056.55 20,056.55 -'_~:fu_'2 20,056.55 Monthly Overage (Shortage) -.--'-- --- . ..-- __ Interes..L... ---------- LP Gallons ~ense Rate/Gallon Budget Month I Beg. Ba!. L Oct-07 Nov-07 Dec-07 I ~~l I Feb-~~___.. Mar-08 I Apr-08 I May-08 Jun-08 I-Jul-08 Aug-08 Sep-08 I Per13 Total YTD I RatelTherm $ - $ - $ - $ - $ - $ 0.03 $ 0.03 $ 0.03 $ 0.03 $ 0.03 $ - i$ - $ $ $ NG Therms - i $ (9.80) $ (0.16) $ (2.21 $ (1.281 $ - $ 61,650.00 $ 58,440.00 $ 55,050.00 $ 52,260.00 I $ 47,610.00 I $ - 1 $ - I $ 720,056.551 i $ 274,996.55 I 0.00/0.00 0.00/0.00 0.00/0.00 0.00/0.00 0.00/0.00 i;.~~Q;M()iQ~i . 0.03/0.03 0.03/0.03 0.03/0.03 0.03/0.03 Q~gaiQ:(QP1':; 0.00/0.00 $ - - 1,396,440.2 $ - - 1,612;140.2 $ - - 1,920,988.7 $ - - 2,051,577. 7 $ - - 2,000,000.0 $ - 0.03 2,000,000.0 $ - 0.03 1,900,000.0 $ - 0.03 1,790,000.0 $ - 0.03 1.700,000.0 $ - 0.03 1,550,000.0 $ - - 1,550,000.0 $ - - I 1,550,000.0 I 1 I - I 21,021,146.8 36,522.8 33,056.8 38,487.0 58,278.4 57,000.0 55,000.0 48,000.0 45,000.0 42,000.0 37,000.0 37,000.0 37,000.0 524,345.0 I I I (1) Transfer of WNA FYE balance to NG PGA I Last Uodated:02/25/2008 /I rr /}CfJ/YI~"lr .i*"2- - CGS Natural Gas Cost Actual/ProJectloM FY08 as of 2127/2008 Con1ract Capacity Contract Exceu Capacltl Rellnquishmant Purchasad Sold Gas Sold Gas Purchasad .'" Sold Gas WACOG FTS-1 FTS-2 No-NotIce Caaacltv Volume Coat Gas Actual Prolactad Gas loat V&. Prolected Purchasad 170 438 41 788 1&,500 56 435 33179 $ 18700.17 155.791 139844 172 000 -3.48% 81.2% $ 7.15 308 570 53Aib 22500 167 539 25 305 $ 4 168.01 192,361 161 214 220,000 -5.32% 73.3% $ 8.02 318 789 SU11 31,000 188,003 102,009 S 21,716.1 183 997 202.589 257,000 -5.80% 78.8% $ 7.55 316 78. 0.211 46.500 142.806 881173 $ 38,944.83 229 194 194,888 237,000 82.1% $ 7.88 286 132 49 868 42000 109 032 30 000 S IHOO.OO 226 968 225 000 S 8.50 316 789 55 211 31 000 171 000 30 000 $ 9 000.00 201 000 201 000 S 8.85 216 570 53 430 22 500 91 000 30000 S 12000.00 179 000 179 000 ~ 8.30 144 212 41 788 12400 16000 31 000 ~ 12400.00 170 000 170 000 $ 8.09 139 560 40 44D 10500 25 000 30 000 $ 12 000.00 155 000 155 000 $ 8.11 144 '12 41788 10650 32 000 31 000 IS 12400.00 154 000 154 000 S 829 144 212 41 788 10650 31000 31 000 IS 12400.00 155 000 155 000 g:- 8.29 139 560 40 440 10500 25 000 21 000 Is 8400.0 155 000 155 000 S 8.30 0c:t-G7 Nov-G7 Dec-G7 Jan-08 Feb-08 Mar-G8 Apr.{)8 May-D8 Jun-D8 JuI-08 Aug-D8 Sep.{)8 Total 2,280,000 ....95% 78.9% $8.12 ($189,629.16) 2,157,311 ....111 266,100 1,014,811 (483,381) 2,641,833 570,393 RHervatlon charges FTS-1 FT8-1 FTS-2 FGU Load Load Total FT8-1 FTS-2 No-Notice charges Usage Charge Usaga Charge Total Monthly Fuel Coat Management fee Factor Factor Billing Inhasa III Inhaae 111\ NNTS lohase Ill" lohasa 1111- CommodHv cha....... Ad"""""'"'- IFuel Retention) Par Month wI Relinnuish wIo Relinowsh lFGU\ $ '9.112.61 $ 32.134.97 $ 767.25 $ 3,255.76 $ 878.20 $ 1 030 360.03 $ 3091.'9 $ 21.613.48 $ 7.047.00 87.0% 73.4% $1,113,674.69 $ 124314.14 $ 41 087.17 S 1,113.75 S 3 883.78 I $ 112.20 $ 1 380 878.25 $ 1,947.52 S 39.681.45 $ 8.114.00 57,5% 53.4% $1 543 225.80 $ 129 457.94 S 42 457.28 S 1 534.50 S 4189.25 $ 80.08 $ U3lL689.51 $ 2,991.46 S 36 562.44 S 10 250.00 88.1% 49.5% $1 389 423.06 S 128.457.94 $ 42.457.28 $ 2.301.75 S tl.428.79 $ 87.82 $ 1.666.243..22 $ 5.132.96 $ 53 028.55 $ 10.&77.00 81.0% 61.6% $1,800,515.34 $ 113165.21 38 346.49 2 079.00 9 019.30 1 196.83 1782 783.73 - S 57 132.48 S 10125.00 74.2% 67.6% 1 928 856.43 S 125290.05 42 457.26 1 534.50 7508.14 1 325.06 1 618 933.86 . $ 51 903.66 s 9 045.00 58.8% 54.0% 1 779 215.67 S 85 653.44 41 087.67 1 113.75 6 466.86 1 282.32 1 370 143.87 - $ 43 899.69 $ 8 055.00 74.6% 66.3% 1 485 998.72 s 57 035.65 32 134.97 613.80 6 602.92 1 002.91 1 298420.17 - S 41 592.34 7 850.00 109.7% 91.4% 1 375 804.79 $ 55 195.98 31 098.36 519.75 5 899.84 970.56 1181 658.58 - $ 37853.18 8 975.00 103.3% 86.1% 1 256 472.66 S 57 035.85 32 134.97 537.08 5 778.92 1 002.91 $ 1198861.08 - S 38417.25 6 930.00 99.4% 82.8% $1 276 168.97 $ 57 035.85 32 134.97 537.08 $ 5 830.42 1 002.91 S 1 206 987.91 - $ 38677.59 6 975.00 100.0% 83.3% ~1 284 295.81 S 55195.98 31 098.36 519.75 S 5 899.84 970.58 I 1208 687.00 - $ 38731.60 6 975.00 97.5% 86.1% 11287101.09 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr'{)8 Msy-o& Jun-08 Jul'{)8 Aug-08 Sep-D8 Total $1.055,850.82 $13,171.95 $89,754.81 $9,922.38 $16,182,627.21 $ $507,151.72 $"'818.00 71.3% $17,520,753.02 84.2% 13,163.66 $438,832.20 Total Projected DTH WACOG Total Rftervation Total Commod Cost Purchaaad 1 st 6 Monthe $837,042.38 $ 8,717,888.80 $9,554,810.99 1,189,311 $8.034 2nd 6 Months $501 083.43 $ 7484,758.61 $7,965.842.03 958,000 $8.229 TOTAL $1,338.125.81 $ 16,182,627.21 $17.520,753.02 2,157,311 $8.12 09/30/07 10/10/07 10/15/07 10/31/07 10/31/07 11/09/07 11/13/07 11/30/07 11/30/07 12/18/07 12/31/07 12/31/07 01/24/08 01/28/08 01/31/08 01/31/08 02/08/08 02/12/08 FYTD Totals Propane Weighted Average Cost of Gas 0NACOG) FY 2007-08 IJ Tr/Tcl.J./fSe"J r #-3 Date 48,685.65 37,199 77,663.51 57,034 105,367.42 75,997 105,592.84 76,277 51,144.22 36,945 67,318.86 46,689 129,360.67 84,061 129,360.67 84,379 70,732.21 46,137 153,641.89 95,479 154,459.71 96,339 90,611.75 56,516 1.72267 $ 158951.62 96,187 1.72267 $ 176,178.28 106,187 1.62891 $ 177, 717.60 107,132 76,551.67 46,147 1.62637 $ 32,180.65 $ 520.68 $ 32,701.33 205,034.0 109,253.00 66,254 20,107 19,140 224 174 0.97626 214 327 S 3 480.47 218 851 Projections Delivered Delivered Cost of Projected NYMEX CGS Cost Gallons Invento WACOG Jan-08 46 147 $ 76,551.67 1.66 Feb-08 1.50 1.63 40,000 $ 65 200.00 1.65 Mar-08 1.38 1.50 50 000 $ 75,000.00 1.59 Apr-08 1.35 1.47 40,000 $ 58,800.00 1.56 May-08 1.43 1.55 40,000 $ 62,000.00 1.56 Jun-08 1.43 1.55 30,000 $ 46,500.00 1.56 Jul-08 1.43 1.55 30,000 $ 46,500.00 1.56 Aug-08 1.43 1.55 40 000 $ 62,000.00 1.56 Sep-08 1.43 1.55 40,000 $ 62,000.00 1.56 2/27/2008 Tank Withdraw! WACOG 1.30879 1.36171 1.38647 1.38433 39,332 1.38433 1.44186 1.53889 1.53309 38,242 1.53309 1.60917 1.60329 39,823 1.60329 1.65253 1.65913 1.65887 60,985 1.65887 1.64900 CSW:02124/2008 Attachment #4 CALCULATION OF WEATHER NORMALIZATION ADJUSTMENT Proiected Deficit for FY 2007/2008 Proiected Heating Degree Davs FYE 2007/2008 = 10 Year Average HODs for Year thru FY 2006/2007 321 499 64.3% Therefore, Shortfall = 35.7% Thereby exceeding the 10% threshhold for WNA application Projected Shortfall in Natural Gas Thenns Projected Shortfall in LP Gas Gallons Total Projected Shortfall in NFE Billings for FY 200712008 630,000 15,500 @ @ $ 0.388 $ 0.684 $ $ $ 244,339 10,601 254,940 Proiected Usaee for Period of NG Therms LP Gallons Total Therms & Gallons March 1, 2008 - September 30, 2008 * 12,000,000 290,000 Less Projected Fixed Rate Contract Rates = 10% = Projected Therms & Gallons to Collect on = 12,290,000 (1,229,000) 11,061,000 Required WNA Recovery Rate $ 254,940 11,061,000 $ 0.0230 Round to $0.030 Per Therm or Gallon * Note: Actually plan to bill @ this rate until WNA is fully recovered for FY 2007/2008 or until a change is approved. U:\My DocumenulEXCELIGASRATESIFY 07-081[WNA Recovery Beginning 3-1-2008.xIs]Sheetl CSW:02l24/2008 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non-Fuel Enemy ChamelTherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Environmental Imposition Adj. (EIA) Weather Normalization Adj. (WNA) Total Non-Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelTherm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP/Gallon Rate of with 6.0% Franchise CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR MARCH 1,2008 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS ..-Bl... SMF MMF LMF Firm Natural Gas Rate Schedules ~ ~ LGS ..M!L ~ NA (1 - NA (4 + NA (4 + NA (4 + 3 Units) Units) Units) Units) o - 18,000- 100,000 17,999 99,999 & up NA(1- NA(O- 3 Units) 149 tons) $8.00 ($12.00) if not prey. bUled $0.200 $0.380 $1.430 $20.00 ($30.00) if not prey. billed $0.150 0.150 0.000 ~ lWQ LAC NA(150 tons & +) ~ SL wlM& Reliaht NA NA $0.330 1M2 1M2 Interr. NG Rate ~ ~-'L- NA NA 100,000 Non-Resl. & up $30.00 ($50.00) if not prey. billed $20.00 ($30.00) $20.00 $8 ResI$20 GS ($30.00) ($12 ResI$30 GS) if not prey. billed $0.100 $0.200 $0.300 0.150 0.150 0.150 0.150 $8.00 $20.00 $30.00 $75.00 ($12.00) ($30.00) ($50.00) ($125.00) $20.00 $30.00 $75.00 ($30.00) ($50.00) ($125.00) $1.380 0.000 0.000 0.000 0.000 0030 0 030 0.030 $0.280 $0.380 $0.480 WQ 1M2 WQ $1.330 $1.430 $1.530 $0.580 $0.580 $0.580 $0.580 $0.470 $0.410 $0.350 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.000 0.000 0.000 0.000 0.000 0.000 0.000 WQ 0 030 0.030 0 030 WQ 0.030 0.030 $0.760 $0.760 $0.760 $0.760 $0.650 $0.590 $0.530 WQ ~ WQ WQ 1M2 WQ 1.050 $1.810 $1.810 $1.810 $1.810 $1.700 $1.640 $1.580 $50.00 $150.00 ($75.00) ($250.00) $0.100 $0.470 $0.280 0.150 0.150 NA 0.000 0.000 NA ~ 0.030 ~ $0.280 $0.650 $0.310 $1.330 $8.00 $20.00 @ $30.00 @ $20.00 ($12.00) ($30.00) ($50.00) ($30.00) @ premise @premise @ premise + FAC $20.00 $8 ResI$20 GS ($30.00) ($12 Res/$30 GS) +FAC $ 1.656 $ 1.656 $ 1.656 $ 1.656 $ 1.556 $ 1.501 $ 1.446 $ 1.308 $ 1.263 $ 1.217 $ 1.308 $ 1.400 $ $ 1.756 $ 1.756 $ 1.756 $ 1.756 $ 1.649 $ 1.591 $ 1.532 $ 1.387 $ 1.338 $ 1.290 $ 1.387 $ 1.484 $ $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.981 $0.981 $0.981 $0.981 $0.981 $0.981 $0.981 BTU FACTOR = THERMS/1oo CUBIC FEET ICCFI 10/2007 11/2007 12/2007 01/2008 02/2008 03/2008 04/2008 $8.00 $20.00 $30.00 $75.00 ($12.00) ($30.00) ($50.00) ($125.00) $20.00 $30.00 $75.00 ($30.00) ($50.00) ($125.00) Change from 10/2004 Therm Rate $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ 0.100 $ % Change from 1012004 Therm Rate 5.8% 5.8% 5.8% 5.8% 6.3% 6.5% 6.8% 7.5% 7.8% 8.1% 7.5% 7.0% Utility Tax Note: Fuel Rate per Therm 10/01/1973 Non-Utility Taxable FueVTherm Firm Service Rates Interruptible Service Rates 1.053 1.053 1.049 1.048 1.047 1.049 1.033 1.033 1.029 1.027 1.027 1.028 $0.069 $0.981 $0.069 $0.981 $0.069 $0.069 $0.069 $0.981 $0.981 $0.981 OS/2008 06/2008 07/2008 08/2008 09/2008 @ premise +FAC WQ ~ 0970 $1.700 $1.280 $50.00 $150.00 ($75.00) ($250.00) + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. 1.217 $ 1.556 $ 1.171 1.290 $ 1.649 $ 1.241 0.100 $ 0.100 $ 0.040 8.1% 8.3% 3.2% $0.069 $0.069 $0.055 $0.981 $0.981 $0.915 Attachment #5 Contract tm.B!l! ....9!L NA By Contract By Contract NA NA ~ Contract + $0.030 Plus UZQ $1.000 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms $ 0.040 4.2% $0.069 $0.901 CSW:02l24/2008 Attachment #6 Page 1 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: ~ Therms/100 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR MARCH 1, 2008 - SEPTEMBER 30, 2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MUL TI-FAMIL Y LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP Applicable Annual Gallon Range NA NA NA o - 2,500 >2,501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (1 - 3 Units) (Closed for Resl. Application) Monthly Customer Charge $8.00 $20.00 $8.00 $20.00 $30.00 $8.00 Res!. or $50.00 Set By Contract $20.00 GS if not Non-Fuel Enerav Charaes/Gallon: prevo billed @ premise Non-Fuel Energy Charge /Gallon $1.600 $1.600 $0.800 $0.200 $0.150 $0.100 $0.390 Set By Contract Energy Conservation Adj.lGallon 0.150 0.150 0.150 0.150 0.150 0.150 0.150 NA Environm'llmposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0.030 0.030 QmQ. ~ 0.030 0.030 0030 QJm Total Non-Fuel Charges/Gallon $1.780 $1.780 $0.980 $0.380 $0.330 $0.280 $0.570 By Contract + $0.030 Purchased Gas Adjustment/Gallon 2.040 2.040 2040 2.040 2.040 2.040 ~ 2.040 Total Energy Charges/Gallon $3.820 $3.820 $3.020 $2.420 $2.370 $2.320 $2.610 $2.070 + Contract NFE Customer Charge + Minimum Monthly Bill $8.00 $20.00 $8.00 $20.00 $30.00 Any Applicable $50.00 Non-Fuel Energy Chg. Customer Charge for the Contracted + Any Applicable # of GallonsIMo. Facility Charges Utilitv Tax Note: Fuel Rate per Therm 10/01/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm $1.879 $1.879 $1.879 $1.879 $1.879 $1.879 $1.879 $1.879 Change from 10/2004 Gallon Rate $ 0.990 $ 0.990 $ 0.990 $ 0.990 $ 0.990 $ 0.990 $ 0.990 $ 0.940 % Change from 10/2004 Gallon Rate 35.0% 35.0% 48.8% 69.2% 71.7% 74.4% 61.1% 83.2% CSW:02/24/2008 Attachment #6 Page 2 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR MARCH 1, 2008 . SEPTEMBER 30,2008 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL ''WILL CALL" COMMERCIAL ''WILL CALL" BULK STANDBY/ CONTRACT BULK (Rate Class is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Level) (Based on Annual Usage Level) GENERATOR ''WILL CALL" ~ BRLP2 ~ BRLP4 WRLP1 WRLP2 ~ ~ beB CLP Applicable Annual Gallon Range 0-60 60.1 -120 120.1 - 300 > 300 0-120 > 120 o - 2,500 > 2.500 (Closed for Resl Any Contract or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Customers in this Customers in this Application Customers Who Range of Usage Range of Usage Request Bulk Del. Annual Customer Charge $ 180.00 $ 144.00 $ 72.00 $ 60.00 $ 120.00 $ 60.00 $ 72.00 $ 72.00 $ 360.00 Set by contract Non-Fuel Enerav CharanlGallon: Non-Fuel Energy Charge/Gallon $ 1.500 $ 1.300 $ 0.900 $ 0.800 $ 1.300 $ 0.800 $ 0.200 $ 0.150 $ 0.390 Set By Contract Energy Conservation Adj.lGallon 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 0.150 NA Environm'llmposition Adj.lGallon NA Weather Normalization Adj.lGallon 0.030 0.030 0.030 0.030 0.030 0.030 0.030 0.030 0.030 0.030 Total Non-Fuel Charges/Gallon $ 1.680 $ 1.480 $ 1.080 $ 0.980 $ 1.480 $ 0.980 $ 0.380 $ 0.330 $ 0.570 Set By Contract + 0.030 Purchased Gas Adjustment/Gallon 2.040 2.040 2.040 2.040 2.040 2.040 2.040 2.040 2.040 2.040 Total Energy Charges/Gallon $ 3.720 $ 3.520 $ 3.120 $ 3.020 $ 3.620 $ 3.020 $ 2.420 $ 2.370 $ 2.610 $ 2.070 + Contract NFE Note: No Monthly Minimum Bill Utilitv Tax Note: Fuel Rate per Therm 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 Non-Utility Taxable FuellTherm $ 1.879 $ 1.879 $ 1.879 $ 1.879 $ 1.879 $ 1.879 $ 1.879 $ 1.879 $ 1.879 $ 1.879 Change from 10/2004 Gallon Rate $ 0.990 $ 0.990 $ 1.090 $ 1.090 $ 1.490 $ 1.090 $ 0.990 $ 0.990 $ 0.990 $ 0.940 % Change from 1 012004 Gallon Rate 36.3% 39.1% 53.7% 56.5% 73.4% 56.5% 69.2% 71.7% 61.1% 83.2% CSW:1l2I24J200S I I I I I I I I I I Attachment 1fT Residential Rate History By Components Clearwater Gas System I I I I Total Rate I ComDOnenlslThenn Contract LP Month NGlthenn LP/aallon . ECA EIA WNA PGA PGA PGA/aallon Oct-04 $ 1.710 $ 2.030 $ 0.100 $ - $ - $ 1.030 $ 0.960 $ 1.130 Nov-04 $ 1.710 $ 2.030 $ 0.100 $ - $ - $ 1.030 $ 0.960 $ 1.130 Dec-04 $ 1.750 $ 2.090 $ 0.100 $ - $ - $1.070 $ 1.000 $ 1.190 JarHlS $ 1.750 $ 2.090 $ 0.100 $ - $ - $ 1.070 $ 1.000 $ 1.190 Feb-OS $ 1.830 $ 2.150 $ 0.130 $ - $ 0.010 $ 1.110 $ 1.040 $ 1.210 Mar-OS $ 1.860 $ 2.180 $ 0.130 $ 0.020 $ 0.020 $ 1.110 $ 1.040 $ 1.210 AIIr-OS $ 1.860 $ 2.280 $ 0.130 $ 0.020 $ 0.020 $ 1.110 $ 1.040 $ 1.210 May-OS $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ 1.140 Jun-05 $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.080 $ 0.990 $ 1.140 Jul-05 $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.080 $ 0.990 $ 1.140 Aug-05 $ 1.820 $ 2.220 $ 0.140 $ 0.020 $ - $ 1.080 $ 1.010 $ 1.160 Sep-05 $ 1.970 $ 2.300 $ 0.140 $ 0.020 $ - $1.230 $ 1.160 $ 1.240 FY 04/05 Ava. $ 1.803 $ 2.162 $ 0.122 S 0.012 $ 0.004 $ 1.085 $ 1.015 $ 1.174 2004 Avg. $ 1.652 S 1.968 S 0.123 i S - S - S 0.949 S 0.879 S 1.046 Oct-05 $ 2.190 $ 2.530 $ 0.120 $ 0.020 $ - $ 1.470 $ 1.390 $ 1.490 Nov-05 $ 2.190 $ 2.530 $ 0.120 $ 0.020 $ - $ 1.470 $ 1.390 $ 1.490 Dec-05 $ 2.280 $ 2.490 $ 0.120 $ 0.020 $ - $ 1.540 $ 1.460 $ 1.450 Jan-06 $ 2.280 $ 2.490 $ 0.120 $ 0.020 $ - $ 1.540 $ 1.460 $ 1.450 Feb-06 $ 2.220 $ 2.460 $ 0.160 $ 0.010 $ - $ 1.470 $ 1.390 $ 1.390 Mar-06 $ 2.220 $ 2.460 $ 0.160 $ 0.D10 $ - $ 1.470 $ 1.390 $ 1.390 Apr-06 $ 2.110 $ 2.320 $ 0.170 $ 0.010 $ - $1.350 $ 1.270 $ 1.240 May-06 $ 1.960 $ 2.360 $ 0.170 $0.010 $ - $1.200 $ 1.120 $ 1.2BO Jun-06 $ 1.920 $ 2.420 $ 0.160 $ 0.D10 $ - $ 1.150 $ 1.070 $ 1.330 Jul-06 $ 1.910 $ 2.500 S 0.200 $ 0.010 $ - $ 1.120 $ 1.040 $ 1.390 Aug-06 $ 1.B60 $ 2.600 $ 0.200 $ 0.010 S - $ 1.070 $ 0.990 $ 1.490 Sep-06 $ 1.860 $ 2.600 $ 0.200 $ 0.010 $ - $ 1.070 $ 0.990 $ 1.490 FY 05/06 Avg. S 2.080 S 2ABO S 0.160 S 0.013 $ - $1.327 S 1.247 $ 1.407 2005 Ava. $ 1.925 S 2.278 S 0.127 S 0.017 S 0.004 $ 1.198 $ 1.125 $ 1.256 Oct-06 $ 1.940 $ 2.600 $ 0.160 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Nov-06 $ 1.940 $ 2.600 $ 0.180 $0.010 $ - $ 1.170 $ 1.090 $ 1.510 Dee-06 $ 1.940 $ 2.600 $ 0.180 $0.010 $ - $ 1.170 $ 1.090 $ 1.510 Jan-07 $ 1.940 $ 2.600 $ 0.180 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Feb-07 $ 1.940 $ 2.600 $ O.lBO $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 Mar-07 $ 1.940 $ 2.600 $ O.lBO $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510 ADr-07 $ 1.940 $ 2.600 $ O.lBO $ - $ 0.030 $ 1.150 $ 1.070 $ 1.490 Mav-07 $ 1.940 $ 2.740 $ 0.180 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.630 Jun-07 $ 1.920 $ 2.990 $ 0.180 $ - $ 0.030 $1.130 $ 1.050 $ 1.BBO Jul-07 $ 1.840 $ 2.990 $ 0.180 $ - $ - $1.080 $ 1.000 $ 1.910 Aua-07 $ 1.840 $ 2.990 $ 0.180 $ - $ - $1.080 $ 1.000 $ 1.910 Seo-07 $ 1.890 $ 2.990 $ 0.180 $ - $ - $ 1.130 $ 1.050 $ 1.910 FY 06/07 Avg. $ 1.918 $ 2.742 S 0.180 $ 0.005 $ 0.008 $1.145 $ 1.065 $ 1.649 2006 Ava. is 2.012 S 2.501 S 0.175 $ 0.011 $ - $ 1.246 is 1.186 $ 1.415 Oct-07 $ 1.840 $ 2.990 S 0.180 S - $ - $ 1.080 $ 1.000 $ 1.910 Nov-07 $ 1.840 $ 3.170 $ 0.180 $ - $ - $ 1.080 $ 1.000 $ 2.090 Dec-07 $ 1.840 $ 3.170 $ 0.180 $ - $ - $ 1.0BO $ 1.000 $ 2.090 Jan-OB $ 1.840 $ 3.170 $ 0.180 $ - $ - $1.0BO $ 1.000 $ 2.090 Feb-08 $ 1.840 $ 3.170 $ 0.180 $ - $ - $1.080 $ 1.000 $ 2.090 Mar-08 $ 1.Bl0 $ 3.120 $ 0.150 $ - $ 0.030 $1.050 $ 0.970 $ 2.040 AIIr-08 Mav-OB Jun-OB Jul-OB AUll-OB Sell-OB FY 07/08 Avg. $ 1.835 $ 3.132 $ 0.175 S . S 0.005 $1.075 $ 0.995 $ 2.052 2007 Avg. Incr. Above $ 10.130 $ 0.520 $10.030 $10.010 $ 0.030 $10.120 $ 10.120 $ 0.530 Last Year Same Month .7% 20% .17% -100% NA .10% -11% 35% Incr. Based $ 15.85 $ 25.57 on 45 Thenn. -6% 19% Equivalent Cen\sIKWH 6.2 11.6 for Gas vs. FPC Rate 11.7 11.7 Note: This is Proaress Enerav's residential rate in 1/2008 for usaoe >1,000 KVVH. IIResldentlal) Gas CheaDer by -47% -1% Note: Added $1 oer month to Monthly Customer Charge for NG & LP effective 4/112005 I I I I I I Notes: I I I I . Based on Bulk LP IBRLP3 which is aDI licable for customers usina 120.1 - 300 allonslvear & eaualla Residential LP V\lill Call IBRWCLPI.