Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MARCH 1, 2005
~ t CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet RECEIVED MAR G 2 2005 y~ ~ O:FICIAL RECORDS AND LEGISLATIVE SRVCS DEPT TO: William B. Horne II, City Manager FROM: Chuck Warrington, Managing Director ~ COPIES: Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Tom Madley, Sr. AccountantlCCS; Laura Damico, Sr. Accountant/CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE MARCH 1, 2005 DATE: February 28, 2005 Natural and LP gas supply prices are still historically high and volatile, but they have not changed overall much in the last month. Therefore, we are not recommending any changes in our Natural Gas Purchased Gas Adjustments (PGA) nor in our Propane (LP) PGA. We are also not recommending any change in our Energy Conservation Adjustment (ECA) this month. But, the weather has continued to be warmer than normal FYTD such that we are recommending an increase in our Weather Normalization Adjustment (WNA) to 2Cltherm or gallon at this time, which we expect to require thru May. The final timing of the WNA discontinuance will depend on the weather for the remainder of the winter. Also, the environmental work resulting from the impact of the Manufactured Gas Plant on the Myrtle Avenue job requires that we again start collecting an Environmental Imposition Adjustment (EIA) of 2Cltherm or gallon at this time. The net effect of these recommended changes is an increase in our typical Residential Natural Gas customer's rate of 3(:/therm (up 1.6%) and an increase in our typical Residential LP customer's rate of 3(:/gallon (up 1.4%). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after March 1, 2005: Natural Gas Firm Standard Rate Schedule PGA ....... $1.11 per therm (no change) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $1.04 per therm (no change) Propane (LP) Gas Rate Schedule PGA .................... $1.21 per gallon (no change) Energy Conservation Adjustment (ECA) ............... $0.1 3 per therm (no change) & $0.13 per gallon of LP (no change) Environmental Imposition Adjustment (EIA) ......... $0.02 per therm (up 2Cltherm) and $0.02 per gallon of LP (up 2C/gallon) Weather Normalization Adjustment (WNA) .......... $0.02 per therm (up 1 Cltherm) & $0.02 per gallon of LP (up 1 C/gallon) William B. Horne II, City Manager Page 2 February 28, 2005 Attachment #1 shows the FY 04/05 FYTD status of our Adjustment Recovery Clause balances with actuals thru January and projections through FYE Period 13. These show that we are nearly $2.7 Million behind in our recovery clauses as of January and are projecting to catch up on this by the end of the fiscal year. It is important to our overall financials for FY 04/05 that we bring this into balance by the Fiscal Year End, and our recommended recovery factors are based on recovering the current deficit. Attachments #2 and #3 show our current annual projections for Natural Gas supply costs and LP supply costs, respectively. Attachment #4 shows our methodology for calculating our proposed WNA. 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 still 32% lower than electric for Natural Gas and 14% lower for LP. This was impacted by a fairly significant increase in Progress Energy rates in January also due to their supply cost increases and another increase is expected in the Spring due to their hurricane losses last year. Therefore, we still remain very competitive as compared to electric rates. It is our plan to use the above-proposed adjustments for billings through September 30, 2005, 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 Icsw Attachments Approved: 4f@~A. ~-1J; iIIiam B. orne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for March 2005.doc .', . ... CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLEC110NS Attachment #1 Page 1 013 NATURAL GAS PURCHASE D GAS ADJUSTMENT 'PGA-NGI . Monthly Cumulative NG PGA Budget Reservation CommoditY Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelTherm Month Charges Charges Expense Exoenses Expenses Billed (Shortage) (Shortaael FirmlContr Prior Year - $ (1,421,784.77) Oct-04 $ 1,536,383.57 $ 793,365.40 $ 7,108.92 $ 29,328.60 1 $ 2,366,186.49 $ 1,246,718.85 $ (1,119,467.64) $ (2,541,252.41 ) 1.030/0.960 Nov-04 $ 159,200.82 $ 931,453.07 $ 12,706.26 $ 40,281.64 $ 1,143,641.79 $ 1,335,164.55 $ 191,522.76 $ (2,349,729.66) 1.030/0.960 Dec-04 $ 417,954.32 $ 1,358,955.88 $ 11,748.65 $ 65,796.23 2 $ 1,854,455.08 $ 1,783,139.67 $ (71,315.41 $ (2,421,045.06) Jan-05 $ 162,332.23 $ 1,715,682.35 $ 12,105.23 $ 35,730.56 $ 1,925,850.37 $ 2,199,049.30 $ 273,198.93 $ l2,147,846.13}l 1.07011.000 Feb-05 $ 150,000.00 $ 1,800,000.00 $ 10,739.23 $ 50,000.00 $ 2,010,739.23 $ 2,262,520.00 $ 251,780.77 $ (1,896,065.36 Mar-05 $ 166,000.00 $ 1,700,000.00 $ 9,480.33 $ 50,000.00 $ 1,925,480.33 $ 2,341,560.00 $ 416,079.67 $ (1,479,985.69) 1.110/1.040 I ADr-05 $ 114,000.00 $ . 1,500,000.00 $ 7,399.93 $ 50,000.00 $ 1,671,399.93 $ 2,163,720.00 $ 492,320.07 $ 1987,665.62)I 1.110/1.040 I Mav-05 $ 80,000.00 $ 1,300,000.00 $ 4,938.33 $ 50,000.00 $ 1,434,938.33 $ 1,808,040.00 $ 373,101.67 $ (614,563.94) 1.110/1.040 I Jun-05 $ 80,000.00 $ 1,100,000.00 $ 3,072.82 $ 50,000.00 $ 1,233,072.82 $ 1,608,540.00 $ 375,467.18 $ (239,096.76) Jul-05 $ 80,000.00 $ 1,000,000.00 $ 1,195.48 $ 50,000.00 $ 1,131,195.48 $ 1,579,470.00 l 448,274.52 $ 209,177.75 1.09011.020 Aug-05 $ 80,000.00 $ 1,000,000.00 $ (1,045.89) $ 50,000.00 $ 1,128,954.11 $ 1,579,470.00 $ 450,515.89 $ 659,693.64 1.090/1.020 SeD:.o5 $ 80,000.00 $ 1,000,000.00 $ l3,298.47l $ 50,000.00 $ 1,126,701.53 $ 1,579,470.00 $ 452,768.47 $ 1,112,462.11 1.09011.020 Per 13 3 $ 624,148.60 $ - $ (624,148.60) $ 488,313.51 Total YTD $ 3,105,870.94 $ 15,199,456.70 $ 76,150.82 $ 571,137.03 $ 18,952,615.49 $ 21,486,862.37 $ 2,534,246.88 - 1 Includes annual charae for Admin and CCS chg of $1,416,520 1 FY 03104 PGA write off of $34,763.12 (3) Commodity adjustment from FYE transfer of ECA Collected in PGA @ 1/2 of the ECA Rate 1 Lawn Service for gate station $2,000 NG Proportion = 97.5% x Total ECA Transfer + a WNA vear-end adjustment $ 624,148.60 2 $250,500 PGA Share of additional dividends; $3,961.10 PGP Investment PROPANE ILPI GAS PURC .(ASEO r.ll.as .Lpl MonthlY Cumulative LP PGA Budaet Gallons MonthlY Interest CommociiiY Total LP Fuel Total LP PGA Overage YTD OVeralle ThermlGal. Month Sold WACOG Expense Charaes ExDena.. Billed (Shortaael (Shortage) Prior Year $ (18,965.55 Oct-Q4 35,801.0 $ 0.78959 $ 94.83 $ 28,268.11 1 $ 123,602.10 $ 40,072.69 $ (83,529.41) $ l102,494.96) 1.235/1.130 Nov-Q4 30,276.2 $ 0.99760 $ 512.47 $ 30,203.54 2 $ 30,716.01 $ 34,230.15 $ 3,514.14 $ 98,980.82) 1.235/1.130 Dec-04 53,947.3 $ 0.99485 $ 494.90 $ 53,669.47 $ 54,164.37 $ 63,371.72 $ 9,207.35 $ 89,773.47) Jan-05 60,496.4 $ 0.93995 $ 448.87 $ 56,863.59 $ 57,312.46 $ 71,900.98 $ 14,588.52 $ 75,184.95) 1.30111.190 Feb-05 56,000.0 $ 0.92000 $ 375.00 $ 51,520.00 $ 51,895.00 $ 67,421.20 $ 15,526.20 $ 59,658.75) Mar-05 62,000.0 $ 0.90000 $ 300.00 $ 55,800.00 $ 56,100.00 $ 74,644.90 $ 18,544.90 $ 41,113.85)1 1.322/1.210 I Apr-05 55,000.0 $ 0.88000 $ 200.00 $ 48,400.00 $ 48,600.00 $ 66,217.25 $ 17,617.25 $ (23,496.60) I 1.322/1.210 May-05 45,000.0 $ 0.88000 $ 100.00 $ 39,600.00 $ 39,700.00 $ 54,177.75 $ 14,477.75 $ (9,018.85) 1 1.322/1.210 Jun-05 40,000.0 $ 0.87000 $ 50.00 $ 34,800.00 $ 34,850.00 $ 45,770.00 $ 10,920.00 $ 1,901.15 Jul-05 38,000.0 $ 0.87000 $ - $ 33,060.00 $ 33,060.00 $ 43,481.50 $ 10,421.50 $ 12,322.65 1.257/1.150 Aug-05 37,000.0 $ 0.87000 $ - $ 32,190.00 $ 32,190.00 $ 42,337.25 $ 10,147.25 $ 22,469.90 1.257/1 .150 Sep-05 37,000.0 $ 0.87000 $ - $ 32,190.00 $ 32,190.00 $ 42,337.25 $ 10,147.25 $ 32,617.15 1.257/1.150 Per13 $ 16,003.81 $ - $ l16,003.81) $ 16,613.34 Total YTD 550,520.9 $ 0.90199 $ 2,576.07 $ 496,564.71 $ 610,383.75 $ 645,962.64 $ 51,582.70 Cost CenterEXOenses CCS Cho & Admin 75,140.00 1 l6 Adjustment from FYE transfer of ECA in PGA @ 1/2 of the ECA Rate FY 03/04 Write off PGA 162.72 1 LP ProDortion -2.5% x Total ECA Transfer = . $ 16,003.81 Fuel 15,000.00 1 PC Anywhere & Suburban 159.00 1 LP Yard VaDorization 551.54 1 LP PGA Event fuel cost 225.90 1 Lawn Service for Gate Station 4,000.00 1 95,239.16 ." CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECnONS Attachment #1 Page 2 of 3 ENERGY CONSERVATION ADJUSTMENTfECAT " Monthlv Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGlThenn Month ExDenses Notes/ExceDilonalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year - $ (60,545.53) Oct-04 $ 477,891.88 Promo$35,303,Adv $2,613, Employ Costs$56,177 $ 302.73 1 $ 478,194.61 $ 60,298.14 $ (417,896.47) $ (478,442.00) 0.10010.100 Nov-04 $ 92,648.16 Promo$42,610,Adv $1,126, Employ Costs$48,912 $ 2,392.21 $ 95,040.37 $ 62,982.30 $ (32,058.071 $ (510,500.071 0.100/0.100 Dec-04 $ 116,617 .29 Promo$44,537,Adv $474, Employ Costs$57,016 $ 2,552.50 2 $ 119,169.79 $ 88,377 .60 $ (30,792.19) $ (541,292.26) 0.100/0.100 Jan-05 $ 106,856.30 Promo$49,295,Adv $3,785, Employ Costs$53,776 $ 2,706.46 $ 109,562.76 $ 115,486.79 $ 5,924.03 $ 535,368.23) 0.100/0.100 Feb-05 $ 100,000.00 $ 2,676.84 $ 102,676.84 $ 143,340.60 $ 40,663.76 $ 494,704.47) Mar-05 $ 100,000.00 $ 2,473.52 $ 102,473.52 $ 148,595.20 $ 46,121.68 $ 448,582.79) 0.130/0.130 Aor-05 $ 100,000.00 $ 2,242.91 $ 102,242.91 $ 137,169.50 $ 34,926.59 $ 413,656.21) 0.130/0.130 Mav-05 $ 100,000.00 $ 2,068.28 $ 102,068.28 $ 114,562.50 $ 12,494.22 $ 401,161.99) 0.130/0.130 Jun-05 $ 100,000.00 $ 2,005.81 $ 102,005.81 $ 103,870.00 $ 1,864.19 $ 399,297.80) 0.130/0.130 JuI-05 $ 100,000.00 $ 1,996.49 $ 101,996.49 $ 101,914.80 $ (81.69 $ 399,379.49) 0.130/0.130 Aua-05 $ 100,000.00 $ 1,996.90 $ 101,996.90 $ 101,853.70 $ (143.20) $ 399,522.68) 0.130/0.130 SeD-05 $ 100,000.00 $ 1,997.61 $ 101,997.61 $ 101,853.70 $ (143.911 $ 399,666.60) 0.130/0.130 Per 13 4 $ 640,152.42 $ 640,152.42 $ 240,485.82 Total YTD $ 1,594,013.63 $ 25,412.27 $ 1,619,425.90 $ 1,920,457.25 $ (339,121.07) (11 Includes annual charge for Admin and CCS chg of $87,920 (41 = Transfer of ECA Collected In PGA @ 1/2 of the ECA Rate (up to ECA Annual Shortfall) FY 03/04 Write off of $4,093.38, FY 04 SO 323,585.86 Note: Maximum amount which can be transferred = $ 640,152.42 (21 $14,600 ECA share of addldltional dividends E~RnNMENTAI IMPosn ON ADJ--.-mTMENTIEIA\ MonthlY Cumulative EIA Budaet Coat Center Interest Total EIA Total EIA Overaae YTD Overaae NGlThenn Month Expenses NoteslExceDtiOnalltems Expense Expenses Billed (Shortage) (Shortaaef LP/Gal. Prior Year $ 81,546.11 Oct-04 $ 10,492.37 $ - $ 10,492.37 $ - $ (10,492.371 $ 71,053.74 0.000/0.000 Nov-04 $ 250.00 $ - $ 250.00 $ - $ (250.00) $ 70,803.74 0.000/0.000 Dec-04 $ 3,058.00 $ - $ 3,058.00 $ - $ (3,058.001 $ 67,745.74 0.000/0.000 Jan-05 $ 2,379.00 $ - $ 2,379.00 $ - $ (2,379.00) $ 65,366.74 0.000/0.000 Feb-05 $ 9,000.00 $ - $ 9,000.00 $ - $ (9.000.00) $ 56,366.74 0.000/0.000 Mar-05 $ 200,000.00 $ - $ 200,000.00 $ 19,456.00 $ (180,544.00) $ (124,177.26) ADr-05 $ 9,000.00 $ - $ 9,000.00 $ 17,960.00 $ 8,960.00 $ (115,217.26) 0.020/0.020 May-05 $ 10,000.00 $ - $ 10,000.00 $ 15,000.00 $ 5,000.00 $ (110,217.26 0.020/0.020 Jun-05 $ 10,000.00 $ - $ 10,000.00 $ 13,600.00 $ 3,600.00 $ (106,617.26) 0.020/0.020 Jul-05 $ 10,000.00 $ - $ 10,000.00 $ 13,344.00 $ 3,344.00 $ (103,273.26) 0.020/0.020 Aua-05 $ 10,000.00 $ - $ 10,000.00 $ 13,336.00 $ 3,336.00 $ (99,937.26) 0.020/0.020 SeD-05 $ 10,000.00 $ - ". $ 10,000.00 $ 13,336.00 $ 3,336.00 $ (96,601.26) 0.020/0.020 Per 13 $ - $ - $ - $ - $ (96,601.26) Total YTD $ 284,179.37 $ - $ 284,179.37 $ 106,032.00 $ (178,147.37) " 1)lncludes annual charges for Admin Charae $10,000 " ..' CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTlONS Attachment #1 Page 3 of 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES IBoth PGAs + ECA + EIAl Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage NGlTherm-Flrm Month Expenses Billed (Shortage) (Shortage) LP/Gallon Prior Year - - $ - $ (1,419,749.74) Oct-04 $ 2,978,475.57 $ 1,347,089.68 $ (1,631,385.89) $ (3,051,135.63) 1.130/1.230 Nov-Q4 1,269,648.17 1,432,377.00 $ 162,728.83 $ (2,888,406.80) 1.130/1.230 Dec-04 2,030,847.24 1,934,888.99 $ (95,958.25) $ (2,984,365.05 Jan-Q5 2,095,104.59 2,386,437.07 $ 291,332.48 $ 2."3'O32.5~_ Feb-05 2,174,311.07 2,473,281.80 $ 298,970.73 $ 2,394,061.84) Mar-Q5 2,284,053.85 2,584,256.10 $ 300,202.25 $ 2,093,859.59) Apr-05 1,831,242.84 2,385,066.75 $ 553,823.91 $ 1,540,035.68) 1.280/1.380 May-Q5 1,586,706.61 1,991,780.25 $ 405,073.64 $ 1,134,962.04) 1.280/1.380 I Jun-Q5 1,379,928.63 1,771,780.00 $ 391,851.37 $ (743,110.6 Jul-05 1,276,251.97 1,738,210.30 $ 461,958.33 $ (281,152.34) 1.24011.300 Aug-Q5 1,273,141.01 1,736,996.95 $ 463,855.94 $ 182,703.60 1.240/1.300 Sep-Q5 1,270,889.15 1,736,996.95 $ 466,107.80 $ 648,811.40 1.240/1.300 Per 13 Total YTD $ 21,450,600.70 $ 23,519,161.84 $ 2,068,561.14 WEATHER NnDM41174T1n N IWNAl Monthly Cumulative WNA Budget Interest Overage YTD Overage NGlThenn Month LP Gallona Expense Rate/Gallon NG Thenna RatelThenn (Shortage) (Shortage) LP/Gallon Bell.Bal. $ - $ 145,967.00 Oct-04 35,801.0 $ - - 1 1,448,171 - $ - $ 145,967.00 0.00010.000 Nov-04 30,276.2 $ - - 1,555,679 - $ - $ 145,967.00 0.000/0.000 Dec-04 53,947.3 $ - - 1,966,706 - $ - $ 145,967.00 0.000/0.000 Jan-Q5 60,496.4 $ - - 2,382,900 - $ - $ 145,967.00 0.000/0.000 Feb-05 56,000.0 $ - 0.01 2,290,000 0.01 $ 23,460.00 $ 122,507.00 Mar-05 62,000.0 $ - 0.02 2,370,000 0.02 $ 48,640.00 $ 73,867.00 Apr-Q5 55,000.0 $ - 0.02 2,190,000 0.02 $ 44,900.00 $ 28,967.00 0.020/0.020 May-05 45,000.0 $ - 0.02 1,830,000 0.02 $ 37.500.00 $ 8,533.00) 0.020/0.020 Jun-05 40,000.0 $ - - 1,660,000 - $ - $ 8,533.00) 0.00010.000 Jul-Q5 38,000.0 $ - - 1,630,000 - $ - $ 8,533.00) 0.000/0.000 Aug-05 37,000.0 $ - - 1,630,000 - $ - $ 8,533.00) 0.000/0.000 Sep-05 37,000.0 $ - - 1,630,000 - $ - $ 8,533.00) 0.000/0.000 Per 13 $ 8,533.00) Total YTD 550,520.9 - 22,583,456 $ 154,500.00 Last Updated:02l28105 CGS Natural Gas Cost ActuallProJectlons FY05 !JTrAC#-lJlf]€-JJJ ~2- ao of 111912006 Oct..4 Nov004 DBCo04 Jan-05 Feb-05 Mar~5 Apr-05 May-05 Jun-05 Jul-05 Aug~5 Sep-05 Contract Capacity Contract ~1 Capeclly RalInqulshment P_haoed Sold 0.. == Purch8sed %~= WACOG FTS.l FTS-2 NOoN_ Volume Cost Gu Actu" G.. lasl vs,P d Pu-"'" l1UAHI 41 788 l:uoO 1,4ll8 $ 1 ~~278.84 158,215 144.811 180 000 1.87% 10.5% T 5.74 :auLII1U1 MA2II 22.liU0 111,153 12.872 1 .09 171""'7 155.11l1l1 199 000 .10.46% 71.2% - S 7.51 318711 51.211 31.000 134.161 11-9&1 $ 2A115.01 237 JI3!I 116.871 238,000 82.8% $ 7.81 318 789 55211 46 500 143 000 20 000 I 000.00 229 000 229 000 $ 7.92 286 132 49AAA 42.000 99 000 20.000 I 000.00 231000 237 000 $ 8.10 318 789 55211 31 000 153000 2000 1 000.00 219 000 219 000 7.85 218570 53430 22.500 87 000 30 000 12~()(]0.00 183 000 183 000 7.34 144 712 41188 12~4lIlI 20 000 31 000 12400,00 186 000 166 000 6.86 139 560 40 440 10 500 11 30 000 12000.00 1631 ij~1 6.65 144.212 41 788 . 10850 ~ 0 31000 S HI 163 6.86 144212 41788 10850 2~ 0 31000 1 .00 183. 0 8.68 139 560 40 440 10 .. 4 1 000 186 6.86 Tol8l 2,841,133 570,383 2""00 850,825 (300,3011 ($82,831.841 2.1",301 487,0" 2,215,OGO ~.75% IU% $1.24 ReaervatIon charg.. Load Load Talal FTS-1 FTS-2 Na-Nollce ~ Total M8Ngemenllee FBCIor FBCIor BiIl1ng heo.1I .....11I NNTS Per Month wi RelI uIsh wlo RsUn Ish GU 703.85 31 34.10 87.25 17.5'1'0 101 7Z 111182.74 40 702.17 . 1113.75 51.3% 48.5% 1 9 1.10 122122.11 58.74 $ 1534.110 '7.1% 83.7% $1 .20 122 829.03 42 082.55 2 1.77 85.1% 81.6% 1 14128. 110761.70 38 010.04 2079.02 75.0% 70.5% 1918 .08 122829.03 42082.55 1534.51 2.2% 589 1720017 7 83834.25 40 725.04 1113.78 78.3% 87.8% 1 343 927 55 824.47 31 883.42 613.80 107.1% 89.2% $1 105204.25 54 023.68 3D 835.56 519.75 10B.7 90.6 1 B4 319.78 55 824.47 31 863.42 537.06 $ 105.2% 87.6% 1 086 19.62 55624.47 31 683.42 537.06 $ $ 106.2% 88.7% 106621.2 54 023.66 30 835.56 519.75 $ 105.8% 0.0% 1 099 324.9 Total $1,021,383.51 $434,751.37 $13.172.02 $93.516.06 $15.912.72 $14,9811.086.66 $ 17,203.30 $440.616.20 $127,005.61 114.7% 6...% $16,361,213.48 Total Ptajectecl DTH WACOG Total Commodl Cost PwchaHd 1016 Mantlls $ .,674,255." $9.560,187.65 1,2Sl1,301 2nd 6 Month. 1003 TOTAL $1,377.124..0 14.....0..... $11,386,213.48 2,2'1,301 $7.24 Budgot 2076 $ 12, 100,000.00 PO amount S 4,266.213.48 over budget S 2,000,000 Other PGA co.. ~" A<:+f/J\e.,J i ktJ t Propane Weighted Average Cost of Gas (WACOG) FY 2003-04 1/2512005 :_1 I Gd_ I Pra...... I Propane I Shipping I ~':.':: G: I cast of Tank Tank WA~OG Data C Invoice" D........d Rata Cost Cast InvenlDrv Inve"'ON WIthdraw! I 0lII3tIIlI4 $ 311.862.24 41,.05 34 101 0.83388 I I I I r I lC1f12J04 s-3 I _749 I 38 958 I 0.94928 I S 36 153.88 T S 825.29 1 s 38 979.18 381168.0 I S 75.941.42 85 581 0.88640 111I31104 Inv~ I 3441 0.94727 I S 325.8& I s . S 325.88 I 38.956.0 1 s 78 187.28 15 905 0.88664 10131104 a_ I NfA N1A I S /R337.3ml NfA Is ... 337.3011 38.958.0 I s &7 829.98 15 905 0.78959 111I31104 End ar_th $ 39 578.80 sa. 123 35.712 0.71859 , 111O!11l14 S...3 14004-0814 I I 1$ 8.337.31 T Is 8 337.31 38956.0 I S 47 914,21 . 50 123 0.95592 111/1l1104 S...3 14004-0846 I 38 783 I 1.05835 I s 40196.071& 1121.511 I s 41 ""4.83 77 719.0 I S 88 938.94 881188 1.00059 111J30104 inv adlustmenl I 2118 I . Is .1& . Is . 77.718.0 I S 88 938.94 19152 0.98760 r 11130104 End of month $ 48..4113.1. 41 595 .., !IlI7 0.99768 12/13104 Sa..3 14004-0924 I 381185 I 0.911788 I S 37.5110.85 ri 1124.119 I s 3lI~15.74 77 719.0 I S 84 899.53 85 490 0.99309 112/15104 Suburban I 1329451 2.217 I 1.04420 I S 2.:114.7I1T NfA $ 7.:114.78 781135.8 I S &7.214.32 87 707 0.98438 , 12120104 Sea-3 14004-0948 I 19661 I 0.98781 I S 19.001.77 ~ 415.58 I S 19417.311 99 5911.8 I S 108 831.88 107368 0.99314 12/31104 Inv adlustment I 2311 1.78939 I S 413.35 I s _ Is 413.35 99 586.11 I S 107 045.03 107 599 0.99485 12/31104 End of manth 411.044.41 4I.2lI3 59._ 0.ll9485 I I I 1 1 I I I ul I FYTD TataI. 13l1.0&71 0.99174 I S 13599l1.58 I t: , -.31 I 8 1-".11 Propane FY 2005 Projections Current Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 Jul-05 Aug-05 Se -05 NYMEX CGS Cost Gal Delivered $ 0.995 48,293 $ 0.860 60,000 0.750 $ 0.860 60,000 0.735 $ 0.845 50,000 0.730 $ 0.830 30,000 0.730 $ 0.830 30,000 0.730 $ 0.830 30,000 0.730 $ 0.830 30,000 0.738 $ 0.838 30,000 0.740 $ 0.840 40,000 Inventory Cost $ 48,044.48 51,600.00 $ 51,600.00 $ 42,250.00 $ 24,900.00 $ 24,900.00 $ 24,900.00 $ 24,900.00 $ 25,125.00 $ 33,600.00 Projected WACOG 0.920 0.899 0.886 0.880 0.874 0.870 0.866 0.864 0.862 .. Attachment #4 CSW:02128/05 CALCULATION OF WEATHER NORMALIZATION ADJUSTMENT Deficit from October 1. 2004 - February 28. 2005 Proiected Heatine: Dee:ree Davs FYTD thru 2/28/05 10 Year Average HODs for Oct - Feb 330 461 71.6% Therefore, Shortfall = 28.4% Thereby exceeding the 10% threshhold for WNA application Projected Shortfall in Natural Gas Thenns 330,000 @ $ 0.416 $ 137,207 Projected Shortfall in LP Gas Gallons 14,600 @ $ 0.600 $ 8,760 Total Projected Shortfall in NFE Billings for FY 04/05 = $ 145,967 Projected WNA Recovery for February 2005 1,917,810 @ $0.01 = $ (19,178) Remaining Shortfall in NFE Billings for FY 04/05 $ 126,789 Proiected Usal!e for Period of NG Therms LP Gallons Total Therms & Gallons March 1,2005 - June 30, 2005 · 8,050,000 202,000 Less Fixed Rate Contract Rates = 10% = Therms & Gallons to Collect on = 8,252,000 (825,200) 7,426,800 Required WNA Recovery Rate $ 126,789 7,426,800 $ 0.0171 Round to $0.020 Per Therm or Gallon * Note: Actually plan to bill @ this rate until WNA is fully recovered for FY 04/05 or until a change is approved. C:\Docwnents and Settings\cbuck.woningtonILocal Settings\TempoI1ll}' Internet Files\OLKlB\[WNA Recovery Beginning 3-I-05.xb]Sheetl CSW:02/28/05 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel EnemY CharaelTherm 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 Compares to LP/Gallon Rate of with 6.0% Franchise Change from 10/03 Therm Rate % Change from 10/03 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/01/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR MARCH 1, 2005 - SEPTEMBER 30,2005 BASED ON APPROVED GAS ADJUSTMENT FACTORS ----BL SMF ..MMf.... .J.ME.... NA (1 - NA (4 + NA (4 + NA (4 + 3 Units) Units) Units) Units) $7.00 $15.00 $20.00 $50.00 $0.580 $0.580 $0.580 $0.580 0.130 0.130 0.130 0.130 Firm Natural Gas Rate Schedules SGS MGS .J.gL RAC ~ LAC 0- 18,000- 100,000 17,999 99,999 & up $15.00 $20.00 $50.00 NA(1- NA(O- NA(150 3 Units) 149 tons) tons & +) $7.00 if $15.00 if $20.00 if not prevo not prevo not prevo billed billed billed $0.200 $0.150 $0.100 $15.00 $0.200 -Ab.. SL wlM& NGV Reliaht NA NA NA $15.00 $7 Resl.l $15 GS if not prev. billed $0.300 $0.100 0.130 0.130 0.130 lnterr. ~ ~ ---1L NA 100,000 &up $30.00 $100.00 $0.470 $0.280 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 NA 0.130 NA $0.470 $0.410 $0.350 0.130 0.130 2J!2Q. ~ 0.020 0.020 0.020 0 020 ~ ~ ~ 0.020 0.020 0.020 Q.22Q. 0.020 0.020 $0.750 $0.750 $0.750 $0.750 $0.640 $0.580 $0.520 $0.370 $0.320 $0.270 $0.370 $0.470 $0.270 $0.640 $0.300 0.130 0.130 0.130 0.130 $1.860 $1.860 1 110 1J.1l!. 1J.1Q 1J.1l!. 1. 110 1. 11 0 1J.1Q 1J.1Q 1J.1Q 1. 11 0 1J.1l!. 1J.1Q 1J.1l!. 1.11 0 1.040 $1.750 $1.340 $1.860 $1.860 $7.00 $15.00 $20.00 $50.00 $1.750 $1.690 $1.630 $1.480 $1.430 $1.380 $1.480 $15.00 +FAC $1.580 $1.380 $15.00 $7 Resl.l +FAC $15GS@ premise +FAC $30.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.702 $ 1.702 $ 1.702 $ 1.702 $ 1.601 $ 1.546 $ 1.491 $ 1.354 $ 1.308 $ 1.263 $ 1.354 $ 1.446 $ 1.263 $ 1.601 $ 1.226 $ 1.804 $ 1.804 $ 1.804 $ 1.804 $ 1.697 $ 1.639 $ 1.581 $ 1.435 $ 1.387 $ 1.338 $ 1.435 $ 1.532 $ 1.338 $ 1.697 $ 1.300 $15.00 $20.00 $50.00 $7.00@ $15.00@ $20.00 @ premise premise premise $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.330 $ 0.280 21.6% 21.6% 21.6% 21.6% 23.2% 24.3% 25.4% 28.7% 30.0% 31.4% 28.7% 26.4% 31.4% 23.2% 26.4% $0.069 $0.069 $0.069 $0.069 $1.041 $1.041 $1.041 $1.041 BTU FACTOR = THERMS/100CUBIC FEET (CCFI Firm Service Rates Interruptible Service Rates 10/04 11/04 12/04 01/05 1.054 1.057 1.056 1.051 1.034 1.036 1.036 1.030 $0.069 $0.069 $0.069 $1.041 $1.041 $1.041 02/05 03/05 04/05 1.053 1.053 1.032 1.032 $0.069 $0.069 $0.069 $1.041 $1.041 $1.041 05/05 06/05 07105 $0.069 $1.041 $0.069 $0.069 $1.041 $1.041 08/05 09/05 $0.069 $0.055 $1.041 $0.985 Attachment #5 Contract ~ ~ NA By Contract By Contract NA NA 0.020 Contract + $0.020 Plus ~ $1.060 + Non-Fuel Customer Charge + Non-Fuel T Rate for Cc # of Therm $ 0.280 35.9% $0.069 $0.971 ~ . ... CSW:02/28/0S 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, 2005 - SEPTEMBER 30, 2005 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" COMMERCIAL 'WILL CALL" CONTRACT ''WILL CALL" (Rate Class is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Level) BRLP1 BRLP2 BRLP3 BRLP4 WRLP BCLP1 ~ CLP Applicable Annual Gallon Range 0-60 60.1 -120 120.1 - 300 > 300 1st 300 > 300 o - 2,500 > 2,500 Any or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS For Add'l. Annual Customers in this Customers in this Contract Customers Who Gallons Used Range of Usage Range of Usage Request Bulk Delivery Annual Customer Charge $ 96.00 $ 72.00 $ 60.00 $ 48.00 $ 48.00 NA $ 60.00 $ 60.00 Set by contract Non-Fuel Enerav Charaes/Gallon: Non-Fuel Energy Charge/Gallon $ 1.500 $ 1.300 $ 0.800 $ 0.700 $ 0.800 $ 0.700 $ 0.200 $ 0.150 Set By Contract Energy Conservation Adj.lGallon 0.130 0.130 0.130 0.130 0.130 0.130 0.130 0.130 NA Environm'llmposition Adj.lGallon 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 NA Weather Normalization Adj./Gallon 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 Total Non-Fuel Charges/Gallon $ 1.670 $ 1.470 $ 0.970 $ 0.870 $ 0.970 $ 0.870 $ 0.370 $ 0.320 Set By Contract + 0.020 Purchased Gas Adjustment/Gallon 1.210 1.210 1.210 1.210 1.210 1.210 1.210 1.210 1l1Q Total Energy Charges/Gallon $ 2.880 $ 2.680 $ 2.180 $ 2.080 $ 2.180 $ 2.080 $ 1.580 $ 1.530 1.230 + Contract NFE Note: No Monthly Minimum Bill Utilitv Tax Note: Fuel Rate per Therm 10/01/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm 1.049 1.049 1.049 1.049 1.049 1.049 1.049 1.049 1.049 Change from 10103 Gallon Rate $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.540 $ 0.490 % Change from 10/03 Gallon Rate 23.1% 25.2% 32.9% 35.1% 32.9% 35.1% 51.9% 54.5% 66.2% CSW:02l28105 I I I I I Attachment #7 I I I I I Page 1 of 2 . Residential Rate History By Components Clearwater Gas System I I Total Rate ComoonentslTherm Contract LP Month NG/therm LP/aallon * ECA EIA WNA PGA PGA PGAlaallon 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 Jan-05 $ 1.750 $ 2.090 $ 0.100 $ - $ - $ 1.070 $ 1.000 $ 1.190 Feb-05 $ 1.830 $ 2.150 $ 0.130 $ - $ 0.010 $1.110 $ 1.040 $ 1.210 Mar-05 $ 1.860 $ 2.180 $ 0.130 $ 0.020 $ 0.020 $1.110 $ 1.040 $ 1.210 Apr-05 May-05 Jun-05 Jul-05 Aug-05 Sep-05 FY 04105 Avg. $ 1.768 $ 2.095 S 0.110 S 0.003 S 0.005 $ 1.070 $ 1.000 $ 1.177 2004 Avg. $ 1.652 $ 1.968 S 0.123 S - S - $ 0.949 $ 0.879 $ 1.046 Incr. Above $ 0.270 $ 0.270 $ 0.010 $ 0.020 $ 0.020 $ 0.220 $ 0.220 $ 0.220 Last Year Same Month 17% 14% 8% NA NA 25% 27% 22% Incr. Based $ 12.15 $ 13.28 on 45 Therms 15% 13% Equivalent Cents/KWH 6.3 8.1 for Gas vs. FPC Rate 9.4 9.4 (Residential) -- Gas Cheaper .-- bv -32% -14% '" ~ Notes: * Based on Bulk LP(BRLP3 which is aDDlicable for customers usina 120.1 - 300 aallons/vear & equal to Residential LP Will Call (BRWCLP). CSW:11129104 I I I I T I Attachment #7 I I I I I I I I Page 2 of 2 Residential Rate History By Components Clearwater Gas System Total Rate Com....nen...lTherm Contract LP Month NGltherm LPhlallon * ECA EIA WNA PGA PGA PGAlaallon Oct-OO $ 1.290 $ 1.601 $ 0.110 $ - $ - $ 0.600 $ 0.510 $ 0.800 Nov-OO $ 1.320 $ 1.651 $ 0.110 $ - $ - $ 0.630 $ 0.540 $ 0.850 Dee-OO $ 1.430 $ 1.651 $ 0.110 $ - $ - $ 0.740 $ 0.650 $ 0.850 Jan-O 1 $ 1.890 $ 1.801 $ 0.110 $ - $ - $ 1.200 $ 1.110 $ 1.000 Feb-01 $ 1.890 $ 1.901 $ 0.110 $ - $ - $ 1.200 $ 1.110 $ 1.100 Mar -01 $ 1.890 $ 1.901 $ 0.110 $ - $ - $ 1.200 $ 1.110 $ 1.100 Apr-01 $ 1.670 $ 1.691 $ 0.110 $ - $ - $ 0.980 $ 0.895 $ 0.890 May-01 $ 1.580 $ 1.620 $ 0.120 $ - $ - $ 0.880 $ 0.795 $ 0.810 Jun-01 $ 1.500 $ 1.578 $ 0.140 $ - $ - $ 0.780 $ 0.695 $ 0.750 Jul-01 $ 1.420 $ 1.516 $ 0.160 $ - $ - $ 0.680 $ 0.595 $ 0.670 Aug-01 $ 1.390 $ 1.445 $ 0.180 $ - $ - $ 0.630 $ 0.545 $ 0.580 SeD-01 $ 1.340 $ 1.433 S 0.200 S - S - !I: 0.560 S 0.540 S 0.550 FY Average $ 1.551 $ 1.649 $ 0.131 $ - $ - $ 0.840 $ 0.758 $ 0.829 2000 Avg. $ 1.222 $ "-.584 $ 0.103 $ 0.003 $ 0.010 $ 0.527 $ 0.431 $ 0.779 Oct-O 1 $ 1.340 $ 1.380 $ 0.140 $ - $ - $ 0.620 $ 0.540 $ 0.550 Nov-01 $ 1.340 $ 1.380 $ 0.140 $ - $ - $ 0.620 $ 0.540 $ 0.550 Dec-01 $ 1.340 $ 1.380 $ 0.140 $ - $ - $ 0.620 $ 0.540 $ 0.550 Jan-02 $ 1.360 $ 1.390 $ 0.160 $ - $ 0.020 $ 0.600 $ 0.520 $ 0.520 Feb-02 $ 1.360 $ 1.390 $ 0.160 $ - $ 0.020 $ 0.600 $ 0.520 $ 0.520 Mar-02 $ 1.360 $ 1.420 $ 0.160 $ - $ 0.040 $ 0.580 $ 0.500 $ 0.520 Apr-02 $ 1.360 $ 1.420 $ 0.160 $ - $ 0.040 $ 0.580 $ 0.500 $ 0.520 May-02 $ 1.340 $ 1.550 $ 0.160 $ - $ 0.040 $ 0.560 $ 0.480 $ 0.550 Jun-02 $ 1.340 $ 1.550 $ 0.160 $ - $ 0.040 $ 0.560 $ 0.480 $ 0.550 Jul-02 $ 1.360 $ 1.620 $ 0.160 $ - $ 0.040 $ 0.580 $ 0.500 $ 0.620 Aug-02 $ 1.360 $ 1.690 $ 0.160 $ - $ 0.040 $ 0.580 $ 0.500 $ 0.690 SeD-02 $ 1.360 $ 1.690 $ 0.160 L.-: $ 0.040 $ 0.580 $ 0.500 $ 0.690 FY Average 1.352 1.488 0.155 - 0.027 0.590 0.510 0.569 2001 Avg. $ 1.549 $- 1.58T S 0.138 $ - $ - $ 0.831 S 0.751 S- 0.758 Oct-02 $ 1.300 $ 1.640 $ 0.100 $ - $ - $ 0.620 $ 0.550 $ 0.740 Nov-02 $ 1.300 $ 1.640 $ 0.100 $ - $ - $ 0.620 $ 0.550 $ 0.740 Dec-02 $ 1.300 $ 1.640 $ 0.100 $ - $ - $ 0.620 $ 0.550 $ 0.740 Jan-03 $ 1.420 $ 1.770 $ 0.120 $ - $ - $ 0.720 $ 0.650 $ 0.850 Feb-03 $ 1.480 $ 1.810 $ 0.120 $ - $ - $ 0.780 $ 0.650 $ 0.890 Mar-03 $ 1.560 $ 1.900 $ 0.160 $ - $ - $ 0.820 $ 0.750 $ 0.940 Apr-03 $ 1.560 $ 1.900 $ 0.160 $ - $ - $ 0.820 $ 0.750 $ 0.940 May-03 $ 1.560 $ 1.900 $ 0.160 $ - $ - $ 0.820 $ 0.750 $ 0.940 Jun-03 $ 1.560 $ 1.900 $ 0.160 $ - $ - $ 0.820 $ 0.750 $ 0.940 Jul-03 $ 1.560 $ 1.900 $ 0.160 $ - $ - $ 0.820 $ 0.750 $ 0.940 Aug-03 $ 1.560 $ 1.900 $ 0.160 $ - $ - $ 0.820 $ 0.750 $ 0.940 SeD-03 S 1.560 $ 1.900 $ 0.160 L.-: L..: $ 0.820 $ 0.750 $ 0.940 FY Average 1.477 1.817 0.138 - - 0.758 0.683 0.878 2002 Avg. $ 1.342 S 1.553 S 0.145 S - $ 0.027 5 0.590 $ 0.513 $ 0.617 Oct-03 $ 1.530 $ 1.830 $ 0.100 $ - $ - $ 0.850 $ 0.780 $ 0.930 Nov-03 $ 1.530 $ 1.830 $ 0.100 $ - $ - $ 0.850 $ 0.780 $ 0.930 Dee-03 $ 1.530 $ 1.830 $ 0.100 $ - $ - $ 0.850 $ 0.780 $ 0.930 Jan-04 $ 1.590 $ 1.910 $ 0.120 $ - $ - $ 0.890 $ 0.820 $ 0.990 Feb-04 $ 1.590 $ 1.910 $ 0.120 $ - $ - $ 0.890 $ 0.820 $ 0.990 Mar-04 $ 1.590 $ 1.910 $ 0.120 $ - S - $ 0.890 $ 0.820 $ 0.990 Apr-04 $ 1.590 $ 1.910 $ 0.120 $ - $ - $ 0.890 $ 0.820 $ 0.990 May-04 $ 1.610 $ 1.910 $ 0.120 $ - $ - $ 0.910 $ 0.840 $ 0.990 Jun-04 $ 1.610 $ 1.910 $ 0.120 $ - $ - $ 0.910 $ 0.840 $ 0.990 Jul-04 $ 1.690 $ 1.990 $ 0.150 $ - $ - $ 0.960 $ 0.890 $ 1.040 Aug-04 $ 1.690 $ 1.990 $ 0.150 $ - $ - $ 0.960 $ 0.890 $ 1.040 8eD-04 $ 1.690 $ 2.030 $ 0.150 L.-: L..: $ 0.960 $ 0.890 $ 1.080 FY Average 1.603 1.913 0.123 - - 0.901 0.831 0.991 2003 Avg. S 1.534 S 1.864 $ 0.138 ~ - $ - ~ 0.816 $ 0.741 $ 0.926 Notes: * Based on Bulk LP (BRLP3 which is aPDlicable for customers usina 120.1 - 300 aallons/ year & eQual to Residential LP Will Calf7BRWCLP),