Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2004
t I I :;. CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet RECEIVED SEP 15 2004 TO: FROM: William B. Horne II, City Manager Chuck Warrington, Managing Director ~ OFPr-j .~L ~ ,:,,;;::-,1-, . ReCORDS ANa LEI..:110LATlVE SRVCS DEPr COPIES: Garry Brumback, 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 OCTOBER 1, 2004 DATE: September 13, 2004 It is that time of year when we fully review our adjustment clauses and make new projections for the upcoming fiscal year. Natural and LP gas supply prices are still historically high and continue to increase somewhat. Therefore, we are recommending an increase of 70/therm in our Natural Gas Purchased Gas Adjustments (PGA) and an increase in our Propane (LP) PGA of SO/gallon. We are also recommending an Energy Conservation Adjustment (ECA) of 100 per therm and gallon, which is a reduction of 50. We are recommending that we continue to not collect any Weather Normalization Adjustment (WNA) due to last winter's weather nor Environmental Imposition Adjustment (EIA) as our balance for this is still positive. The net effect of these recommended changes is an increase in our typical Residential Natural Gas customer's rate of 2(:/therm (up 1.2%) but no change 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 October 1, 2004: Natural Gas Firm Standard Rate Schedule PGA ....... $1.030 per therm (up 7.00/therm) Natural Gas Interruptible and Contract -\- (Non-Standard) Rate Schedule PGA ............. $0.960 per therm (up 7.00/therm) Propane (LP) Gas Rate Schedule PGA .................... $1.130 per gallon (up 5.00/gallon) Energy Conservation Adjustment (ECA) ..............: $0.100 per therm (down 5.00/therm) & $0.100 per gallon of LP (down 5.00/gal.) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) and $0.000 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... $0.000 per therm (no change) & $0.000 per gallon of LP (no change) /2 I ~.. ( () 2 ' OJI _.' ( I William B. Horne II, City Manager Page 2 I September 13,2004 Attachment #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru August and projections thru Period 1 3. These show that we are projecting being about $ 1 .60 Million behind by the end of the fiscal year. It is important to our overall financials for FY 04/05 that we bring this closer to balance by next Fiscal Year End, and our recommended recovery factors are based on recovering about 40% of this. Attachments #2 and #3 show our current annual projections for Natural Gas supply costs and LP historical FYTD costs, respectively. Attachment #4 shows our methodology for calculating our proposed PGA, and Attachment #5 shows our methodology for calculating our proposed ECA and EIA. Attachments #6 and #7 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #8 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 34% lower than electric for Natural Gas and 15% lower for LP. It is our plan to use the above-proposed adjustments for billings through March 31, 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 October 1 st billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: ~ ~"'Jr iIIiam B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for October 2004.doc . .. CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Page 1 of 3 , NATURAL GAS PURCHASE '1 GAS ADJUSTMENT IPGA-NG) MonthlY Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelThenn Month Charges Charges Expense Expenses EXpenses Billed (Shortage) (Shortage) Finn/Contr Prior Year $ 1,819,606.17) Oct-03 $ 1,559,299.48 $ 711,235.99 $ 9,098.03 $ 28,076.77 1 $ 2,307,710,27 $ 1,029,841.27 $(1,277,869.00 $ 3,097,475.17) .850/.780 Nov-03 $ 147,692.22 $ 737,964.17 $ 15,487.38 $ 25,048.97 $ 926,192.74 $ 1,074,868,29 $ 148,675.55 $ 2,948,799.62) ,850/,780 Dee-03 $ 158,575.65 $ 1,084,120.86 $ 14,744,00 $ 45,547.30 $ 1,302,987,81 $ 1,493,501,94 $ 190,514.13 $(2,758,285.49) .850/.780 Jan-04 $ 161,503.19 $ 1,384,925.45 $ 13,791.43 $ 34,544.03 $ 1,594,764,10 $ 1,818,976.71 $ 224,212.61 $(2,534,072.88 .890/.820 Feb-04 $ 150,738.91 $ 1,361,424.84 $ 12,670.36 $ 24,298.45 $ 1,549,132.56 $ 1,739,980.14 $ 190,847.58 $(2,343,225.30) .890/.820 Mar-04 $ 160,335.03 $ 1,267,140.63 $ 11,716.13 $ 22,146,12 $ 1,461,337.91 $ 1,747,720.62 $ 286,382.71 $(2,056,842.59) .890/.820 Apr-04 $ 153,880.25 $ 1,215,188.49 $ 10,284.21 $ 30,276.00 3 $ 1,409,628,95 $ 1,598,489.98 $ 188,861.03 $ 1,867,981.56) .890/.820 Mav-04 $ 70,107.77 $ 1,085,161,15 $ 9,339.91 $ 37,570.69 $ 1,202,179.52 $ 1,371,583.50 $ 169,403.98 $(1,698,577.58) .910/.840 Jun-04 $ 67,107.09 $ 980,085.69 $ 8,492.89 $ 38,275.17 $ 1,093,960.84 $ 1,209,348.70 $ 115,387.86 $(1,583,189.72) .910/,840 Jul-04 $ 69,885.55 $ 896,954.02 $ 7,915.95 $ 26,062,36 $ 1,000,817.88 $ 1,167,720.29 $ 166,902.41 $(1,416,287.31) .960/.~ Aua-04 $ 69,527.20 $ 863,223.82 $ 7,081.44 $ 31,071.70 $ 970,904,16 $ 1,115,891.32 $ 144,987.16 $ (1,271,300.15) .960/.890 Se0-04 $ 70,000.00 $ 875,000.00 $ 6,300.00 $ 30,000.00 $ 981,300.00 $ 1,201,500.00 $ 220,200.00 $(1,051,100.15) .960/.890 Period 13 9 598311.34 - $ (598,311.34\ $(1,649,411.49\ TotalYTD $ 2,838,652.34 $ 12,462,425.11 $ 126,921.73 $ 372,917.56 $ 16,399,228.08 $ 16,569,422.76 $ 170,194.68 (1) Includes annual ch arae for Admin and CCS chg of $1,429,480 (2) FY 03/04 Write off of $46,144.23 (1) FY 02/03 WNA wri e off of $226.33, PGA of $16,179.26 (9) = Transfer of ECA Collected in PGA @ 1/2 of the ECA Rate (NG Proportion) PROPANE ILP\ GAS PURC. lASED GA ~ ENT IPGA-LP\ Monthly Cumulative LP PGA Budget Gallons Monthly Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage Thenn/Gal. Month Sold WACOG Expense Charaes Expenses Billed (Shortage) (Shortage) Prior Year $ (27,667.21) Oct-03 34,127,3 $ 0.64148 $ 138.34 $ 21,891.98 1 $ 101,980.31 $ 31,868.22 $ (70,112.09) $ (97,779.30) 1.017/.930 Nov-03 31,866.2 $ 0.65759 $ 584.76 $ 20,954.89 $ 21,539,65 $ 29,636.36 $ 8,096.71 $ (89,682.59) 1.017/.930 Dec-03 61,823.0 $ 0.66842 $ 544.28 $ 41,323.73 $ 41,868,01 $ 57,503.58 $ 15,635.57 $ (74,047.02) 1.017/.930 Jan-04 57,240.8 $ 0.71719 $ 466.10 $ 41,052.53 $ 41,518.63 $ 55,699.62 $ 14,180.99 $ (59,866.03) 1.0821.990 Feb-04 51,762.0 $ 0,73727 $ 395.19 $ 38,162.57 $ 38,557.76 $ 51,176.51 $ 12,618.75 $ 47,247.28) 1.082/.990 Mar-04 48,115,8 $ 0.82014 $ 332.10 $ 39,461,69 2 $ 46,276.90 $ 47,726.66 $ 1,449.76 $ 45,797.52) 1.082/.990 Apr-04 53,064.5 $ 0.72907 $ 292.44 $ 38,687.74 3 $ 39,855.70 $ 52,537.48 $ 12,681.78 $ 33,115.74) 1.0821.~ May-04 39,427.7 $ 0.73793 $ 224.65 $ 29,094.88 4 $ 29,519.53 $ 39,033,29 $ 9,513.76 $ (23,601.98) 1,082/.990 Jun-04 34,340.0 $ 0.75117 $ 176.08 $ 25,795.18 $ 25,971.26 $ 33,996.21 $ 8,024.95 $ (15,577.03\ 1.082/.990 Jul-04 30,764.4 $ 0.75956 $ 135.96 $ 23,367.41 $ 23,503,37 $ 31,562.61 $ 8,059.24 $ (7,517.79) 1.137/1.040 Aug-Q4 28,537.3 $ 0,79949 $ 95.66 $ 22,815.29 5 $ 34,525.25 $ 29,697.78 $ (4,827.47) $ (12,345.25) 1.13711.040 Sep-04 33,000,0 $ 0.76000 $ - $ 25,080.00 $ 25,080.00 $ 35,640,00 $ 10,560.00 $ (1,785.25) 1,180/1.080 Period 13 9 $ 15,341.32 $ - $ (15,341.32\ $ (17,126.57\ Total YTD 504,069.0 $ 0.72944 $ 3,385,56 $ 367,687.88 $ 485,537.68 $ 496,078.32 $ 10,540.64 Cost Center ExDenses CCS Chg & Admin $ 62,000.00 1 (9) = Transfer of ECA Collected in PGA tm 1/2 of ECA Rate (LP Prop,) FY 02/03 Write off PGA $ 1,650.99 1 Fuel $ 15,000.00 1 Cost Center Expenses (continued) PC Anywhere & Suburban $ 1,299.00 1 2004 FPGA Annual Convention Span! $ 200.00 4 LP Yard Vaporization $ 4,965.76 2 Uparade storage plant & repairs on LF $ 11,614,30 5 LP PGA Event Fuel Cost $ 1,517.35 2 Total $ 99,122.92 Y04 Write off $875,52 $ 875.52 3 .' " , Attachment #1 . Paae 2 013 ENERGY CONSERVATION DJUSTMENT-'ECA \ MonthlY Cumulative ECA Budget Cost Cenwr Interest Total ECA Total ECA Overage YTD Overage NGfTherm Month Expenses Notes/Exceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - Oct-03 $ 685,229,77 Promo$28,789.Adv $0, Employ Costs$B2,l17 $ - 1 $ 685,229.77 $ 60,398.24 $ (624,831.53) $ 624,831.53) .100/.100 Nov-03 $ 69,454,73 romo$19,911 ,Adv $1.620, Employ Costs$47,923 $ 3,124.16 $ 72,578.89 $ 62,044.66 $ (10,534.23 $ 635,365.76) ,100/.100 Dee-03 $ 76,740,91 Promo$32,277,Adv $1,460, Employ Costs$43,OO4 $ 3,176.83 $ 79,917,74 $ 97,804.67 $ 17,886.93 $ 617,478.83) .100/.100 Jan-04 $ 95,068.30 Promo$28,179,Adv $1,328, Employ Cos\s$B4,561 $ 3,087.39 $ 98,155,69 $ 139,443.04 $ 41,287.35 $ (576,191.48) .120/,120 Feb-04 $ 141,600,16 Promo$72,187,Adv $1,893, Employ C0sts$47.608 $ 2,880.96 2 $ 144,481.12 $ 129,246.37 $ (15,234.75 $ {591 ,426.23) .120/.120 Mar-04 $ 85,941,23 Prom0$34.572,Adv $3,170, Employ Costs$48.199 $ 2,957.13 $ 88,898.36 $ 128,737.85 $ 39,839,49 $ (551,586.74) .120/.120 Apr-04 $ 103,975.56 Prom0$56.056,Adv $720, Employ Costs$47,2oo $ 2,757.93 $ 106,733.49 $ 108,997.43 $ 2,263.94 $ (549,322.80) .120/.120 May-04 $ 119,514,48 Oromo$71,062,Adv $2,229. Employ Cosls$46,223 $ 2,746.61 $ 122,261.09 $ 91,654,76 $ (30,606.33) $ 579,929,13) .120/.120 Jun-04 $ 93,192.27 Promo$47,887,Adv $712, Employ Cosls$44.491 $ 2,899.65 3 $ 96,091.92 $ 79,730.29 $ (16,361.63 $ 596,290.76) .120/.120 Jul-04 $ 97,95 .73 'Promo$34,892,Adv $2,535, Employ Costs$B0.532 $ 2,981.45 $ 100,940.18 $ 90,229.47 $ (10,710.71) $ 607,001.47) .150/. f 5D..... AUQ-04 $ 75,29 .09 Promo$29.713,Adv $1,281, Employ Cosls$44,211 $ 3,035.01 $ 78,334.10 $ 79,353,66 $ 1,019.56 $ (605,981.91) .150/.150 SeD-04 $ 100,00 .00 $ 3,100.00 $ 103,100.00 $ 95,429.25 $ (7,670.75) $ (613,652.66) .150/.150 Period 13 9 613,652.66 $ 613,652.66 $ - Total YTD $ 1,743,975.23 $ 32,747.12 $ 1,776,722,35 $ 1,776,722.35 - (1) Includes annLlal ch arae for Admin and CCS cha of $163,020 + FY 02103 Write-off of $2,841.95 (9) = Transfer of ECA Collected in PGA @ 1/2 of the ECA Rate (up to ECA Annual Shortfall) + Service Order ch Braes of $428,461.86 Note: Maximum amount which can be collected hen: $ 2,543,709.04 (2) Adjustment to FY I 3 Write-off of $19,912.40 (3) Install Range Hooc I @ Sales Office $102.17 ENVIRONMENTAL IMPtlSIT ON ADJU~TMI=NT tEIA\ I Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptlonalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ 176,349,01 Oct-03 $ 14,303.84 $ - 1 $ 14,303.84 $ - $ (14,303.84) $ 162,045.17 .000/.000 Nov-03 $ 472.00 $ - $ 472.00 $ - $ (472.00) $ 161,573.17 .000/.000 Dec-03 $ 8,464,00 $ - $ 8,464.00 $ - $ (8,464.00) $ 153,109,17 .000/.000 Jan-04 $ 472,00 $ - $ 472.00 $ - $ (472.00) $ 152,637.17 .000/.000 Feb-04 $ 63,466,34 $ - $ 63,466.34 $ - $ (63,466.34) $ 89,170.83 .0001 :wHL Mar-04 $ 1,910.20 $ - $ 1,910.20 $ - $ (1,910.20) $ 87,260.63 .000/.000 Apr-04 $ 3,752.41 $ - $ 3,752.41 $ - $ (3,752.41) $ 83,508.22 .000/.000 Mav-04 $ 712.00 $ - $ 712.00 $ - $ (712.00) $ 82,796.22 .000/.000 Jun-04 $ 3,908.95 $ - $ 3,908,95 $ - $ (3,908.95) $ 78,887.27 .000/.000 Jul-04 $ 336.50 $ - $ 336.50 $ - $ (336.50) $ 78,550,77 .000/.000 Aug-04 $ 1,669.42 $ - $ 1,669.42 $ - $ (1,669.42) $ 76,881.35 .000/.000 Sep-04 $ 10,000.00 $ - $ 10,000.00 $ - $ (10,000.00) $ 66,881.35 ,000/.000 Period 13 $ - - $ - $ 66,881.35 TotalYTD $ 109,467,66 $ - $ 109,467.66 $ - $ (109,467.66) (1) Includes annual ch rges for Admin Charge $10,000 + FY 02103 Write-off of $3,12 . - " ; Attachment #1 Page 3 013 , TOTAL ALL COST REctWE Y ADJUSTMENT CIAU~ES (Both PGAs + ECA + EIA) ! Monthlv Cumulative Total Budget ! Total All Total Recoverv Overaae YTD Overage NGlTherm-Firm Month Expenses Billed (Shortage) Shortage) LP/Gallon Prior Year $( 1,670,924,37\ Oct-03 1 $ 3,109,224.19 $ 1,122,107.73 $ (1,987,116.46) $( 3,658,040.83) .950/1.03 Nov-03 $ 1,020,783,28 $ 1,166,549.31 $ 145,766.03 $(3,512,274.80) .95011.03 Dee-03 $ 1,433,237.56 $ 1,648,810.19 $ 215,572.63 $(3,296,702,16) .950/1,03 Jan-04 $ 1,734,910.42 $ 2,014,119.37 $ 279,208.95 $(3,017,493.21) 1.010/1,110 Feb-04 $ 1 ,795,637.78 $ 1,920,403.02 $ 124,765.24 $(2,892,727.97) 1.010/1.110 Mar-04 , $ 1,598,423.37 $ 1,924,185.13 $ 325,761.76 $ (2,566,966.22) 1.010/1.110 Apr-04 $ 1,559,970.55 $ 1,760,024.89 $ 200,054.34 $(2,366.911.87) 1.010/1.110 May-04 $ 1,354,672.14 $ 1,502,271.55 $ 147,599.41 $(2.219,312.46) 1.010/1.110 Jun-04 $ 1,219,932.97 $ 1,323,075.20 $ 103,142.23 $(2,116,170.23) 1.010/1.110 Jul-04 $ 1,125,597.93 $ 1,289,512.37 $ 163,914.44 $(1,952,255.79) 1.010/1.1..1.0_ Aua-04 $ 1,085,432.93 $ 1 ,224,942.76 $ 139,509.83 $(1.812,745.96) 1.010/1.110 Sep-04 $ 1,119,480.00 $ 1,332,569.25 $ 213,089.25 $(1,599,656.71) 1.010/1.110 Period 13 $ 613 652.66 $ 613,652.66 $ - $(1,599,656.71 Total YTD $ 18,nO,955.76 $ 18,842,223.43 $ 71,267.66 ! (1) Includes Adn in. & CCS Charges of $1,694,500 + Write-offCharaes of $67,921.40 + LP Fuel of $15,000 + Service Order Charges 01$448,374.26 + LP Vaporization of $4,965.76 + Upgrades to LP of WEATHER NORMALIZJ TIO I7WNA\ Monthly Cumulative WNA Budget Interest Overage YTD Overage NGlTherm Month LP Gallons ExDense Rate/Gallon NG Therms RatelTherm (Shortage) (Shortage) LP/Gal Beg. Bal. $ - Oct-03 34,127,3 $ - $ - 1 1,429,952.1 . $ - $ - .000/.000 Nov-03 31,866.2 $ - $ - 1,484,615.3 - $ - $ - .000/.000 Dec-03 61,823.0 $ - $ - 2,007,739.0 - $ (0.80\ $ (0.80) .000/.000 Jan-04 57,240.8 $ - $ . 2,337,912.0 - $ (0.42) $ (1 .22) .000/,000 Feb-04 51,762.0 $ - $ - 2,261,111,0 - $ - $ (1 .22) .000/.000 Mar-04 48,115.8 $ - $ - 2,264,971.0 - $ (0.02) $ (1.24) .000/.00tT Apr-04 53,064.5 $ - $ - 2,104,433.0 - $ - $ (1.24) .000/.000 May-04 39,427.7 $ - $ - 1,782,103.0 - $ - $ (1.24) .000/.000 Jun-04 34,340.0 $ - $ - 1,573.411,0 - $ - $ (1.24) .0001.000 Jul-04 30,764.4 $ - $ . 1,461,339.0 - $ - $ (1.24) .000/.000 Aug-04 28,537.3 $ - $ - 1,407,554.0 . $ (0.32) $ (1.56) .000/.000 Sep-04 33,000.0 $ - $ - 1,500,000.0 - $ - $ (1.56) .000/.000 Period 13 $ (1.56\ Total YTD 504,069.0 - . - 21,615,140.4 $ - $ (1.56) U:\Mv Documents\EXCE \GA 5RATES\FY 03-04\fAdiustment Clause Recoverv for FY 03-04.xlslNov Recovery CSW:Uodated 09/12/04 T.... ~TTltcO m~,.J J - -- CGS Natural Gu Coat aool Actual/ProjectIons FY05 Con inlet Cl puIty Co_ Exc... C""acIty ReUnqulshmenl Purchased Sold Gas Sold Gas Purchasad % Sold Gas WACOG 1'T8.1 FTlW N~ CIIDacltv Volume Coat Gas Actual Pmlectad Gas losl VB. ProJeclad Purchased 1 ,438 41788 15500 52,/26 2480 IS 14,601,00 160,000 160 000 100,00% 0,0% 6,25 570 53 430 22.51lll 161000 40000 '5 4.000,00 199 000 199 000 7,37 316789 55.211 31000 134 000 :20.000 I 5 2000,00 238 000 236 000 7,47 31 789 55 11 46 500 143000 20.000 $ 1 000,00 229 000 229 000 7,59 2~ 132 49 868 42 000 99 000 20 000 $ 1 000,00 2371100 237 000 . 7,52 1 7811 55211 31000 153.000 20 000 1 000,00 219000 219000 7,51 21 57 53 430 22 500 87 000 30 000 12000,00 183 000 183 000 6,80 1 12 41788 12.400 20000 1000 12400,00 188 000 188000 6,45 1 f 40 440 10500 17 000 30 000 12000,00 163,000 163 000 6,44 1 41788 10850 23000 1000 12.400,00 163 000 163 000 6.45 1 12 41788 10850 23 000 31000 12400,00 163,000 163 000 6,45 1 560 40 440 10600 15.000 24 000 9,IlIlO,OO 1110,000 165 000 6,45 I 2,841 833 170,313 288,1~ 127.221 (321,100) (SI4,401.oo) 2,285.000 0 2,218,000 1~.00% 0,0% $UI R_ _n :l\argMfTS.2 f1'So1 FT8-1 fTS.2 FGU Loed Loed Total f'TS.1 No-NotIce charges Usage Charge Usaga Charge TDIaI Monthly Fuel Cost Managemenl fee Factor Factor BOling I_Ill l!lhas8 11I1 NNTS IDhasa 111- I",,"sa 1111- Commodllv. Adluslmsl,ts IFueI RetentIonI Per Month wi ReDnaulsh w/o Rellnouish IFGul S 6597 ,55 31851,311 767,26 49R4,QC 906,lIU ~ 915,3 73 ,4',4, 75,4% 5999 290,20 So 1186 ,25 40 725,04 1113,76 6113,94 1159,43 So 1309 917,95 - 38 631,69 10 945,00 62,2% 55,3% 1 488,430,01 IE 1226 ,03 42 082,56 1534,51 7611,64 1198,08 So 1 614 150,03 - 47618,71 13,090,00 67,6% 64,0 1 77ll,;596,l1 $ 1226 ,03 42 082,55 301,77 7.299,13 1198,08 $ 1 572 736,75 46411,94 12595,00 65,1% 61,6% 1 738.750,09 IE 11076 ,70 36 010,04 2 079,02 7659,54 1082.13 1 631 962.88 - 48 157,39 13035,00 75,0% 70,5% 1 781.813.62 $ 1226 ,03 42 082,55 1534,51 6879,13 1198,08 1 480 478,09 43 679,26 12045,00 62,2% 58,9% 1 645 724,17 83.B:l ,25 40 725,04 1113,76 5441,94 1 169,43 1 130,592,34 33.307,98 10085,00 76,3% 67,8% 1 244 265,40 5582 .47 31 663.42 613,80 5216,90 908,80 993 976,38 29 262,08 9 130,00 107,1% 89,2% 1 089 876,06 54,02 ,88 30 835,56 519,75 5 147,52 877,56 976 266,62 26 740,56 6 985,00 108,7% 90,6% 1 049 647,61 5682 ,47 31 863,42 537,08 50 ,90 908,80 975 887,23 - 28 723,94 6965,00 105,2'1/, 87,6% 1051512,19 5582 ,47 31 863.42 537,08 5 090,90 908,80 975687,23 - 28 123,94 8.985,00 105.2% 86.7% 1 051 512,19 540 ,68 30 835,56 519,75 5231,52 877.55 988461,38 29 099,32 9075,00 105,8% 0,0% 1 064 24 ,38 $1,822,65 .58 5434,820.51 $13,172.05 $72,147.88 $12,377.50 $14,185,214.10 $ . $428,271.43 $125,&75.00 85.5% 67.6% $15,941,4&0.04 TDIaI Projected OTH WACOG Total Resel1/8llon TDIaI Commodllv Coat Pu_d ls16 Montho ..88,882.50 $ 8,524,541.70 $9,410,404.20 1,282,000 $7,340 - 2nd & Months $4110.382.84 S &,040,673.20 $& 531.055.84 1 003,000 $8,512 TOTAL $1,37&,245.15 $ 14,565,214.90 $15,941,460.04 2,285,000 $6.98 Budget 2078 $ 12,100,000,00 PO amount $ 3,841,460,04 over budget $ 2.000,000 O1her PGA costs - ""2. 8/1712004 -- Oct-03 Nov-03 Dec-03 Jan-04 Feb-D4 Mar-04 Apr-04 May-04 Jun-04 JuI-04 Aug-04 5ep-04 Ocl~ Nov~ 0ec-03 Jan-04 Fab-04 Mar-04 Apr-04 May-04 Jun-04 Ju~04 Aug-04 Sep-04 - Total , , f J I Propane FY 2005 Projections I ATThCII-/f)urr~3 f~ ) 01- 'Z.. NYMEX CGS Cost Gal Delivered Inventory Cost Current 0.75956 58,227 $ 44,226.90 Aug-04 $ 0.785 $ 0.895 9,500 $ 8,497.75 Se -04 $ 0.879 $ 0.989 35,000 $ 34,615.00 Aug-Sept Avg. Oct-04 $ 0.880 $ 0.990 37,000 $ 36,630.00 Nov-04 $ 0.880 $ 0.990 55,000 $ 54,450.00 Dec-04 $ 0.883 $ 0.993 63,000 $ 62,527.50 Jan-05 $ 0.883 $ 0.993 56,000 $ 55,580.00 Feb-05 $ 0.835 $ 0.945 62,000 $ 58,590.00 Mar-05 $ 0.785 $ 0.895 55,000 $ 49,225.00 Apr-05 $ 0.738 $ 0.848 45,000 $ 38,137.50 May-05 $ 0.725 $ 0.835 40,000 $ 33,400.00 Jun-05 $ 0.725 $ 0.835 38,000 $ 31,730.00 Jul-05 $ 0.725 $ 0.835 37.000 $ 30,895.00 Aug-05 $ 0.725 $ 0.835 37,000 $ 30,895.00 Se -05 $ 0.725 $ 0.835 40,000 $ 33,400.00 FY04-05 Total I Propane Weighted Average Cost of Gas (WACOG) FY 2003-04 I flH-~~~ .3 -I~ 1. 0/1 8/1712004 Gallons Propane Propane Shipping Total FYTD Cost 01 Tank Tank WACOG Dale Comoam Invoice /I Delivered Rate Cost Cost Cost Gallons Inventorv Inventorv Wlthdrawl 09/30102 .. $ 29,135.22 44,337 0.65713 I 10/15/03 Sea-3 4003-0747 38 223 I O,629n $ 23 303,42 I $ 766,18 $ 24 069,60 38 223,0 $ 53 204,82 62 560 0,64444 10/31103 inv adjustment 381 I - $ - $ 38223,0 ' $ 53 204,62 62 941 0,64148 10/31103 End 01 month $ 29,273.21 45,634 37,307 0.64148 11/06103 Suburban 110991 2247 0,70300 $ 1 579,43 NlA $ 1 579,43 40469,7 $ 30.852,64 47881 0,64436 11/18/03 Suburban 450386 2,400 O,n600 $ 1 742,40 NlA $ 1 742,40 42889,7 '$ 32 595,04 50,261 0,64826 11/20103 Sea-3 4003-0635 38 628 0,88641 $ 24967,98 $ n4,29 I $ 25,742,27 81497,7 , $ 58 337,31 88 909 0,65615 11/20/03 Sea-3 4003-0855 9,600 0,88641 $ 6205,15 $ 192,43 $ 6.397,58 91 097,7 $ 84 734,89 98 509 0,65715 11/30103 Inv adlustment 60 1,38533 $ $ 83,12 91 097,7 $ 64818,01 98 569 0,65759 11/30/03 End of month $ 39419.17 59,945 38,624 0.65759 12/18/03 Sea-3 4003-0919 47186 0,87562 $ 30 933,73 $ 945,84 1$ 31 879,57 138263,7 ' $ 71298,74 107131 0,66553 12/17/03 Suburban 427601101134 2288 0,75800 ' $ 1 734,23 $ 1$ 1 734,23 140571,6 I $ 73.032,97 109.419 0,66746 12/28/03 Sea-3 4003-0944 9397 0,67561 $ 6 160,39 $ 188,38 $ 6 348,75 149966.6 $ 79381,n 118616 0,66811 12/31/03 Inv adjustment 98 1.05625 $ 101,40 $ $ 101,40 149966,6 $ 79,463,12 118912 0,66842 12/31/03 End of month $ 37415.99 559n 62,935 0.66842 01/19/04 Sea-3 14004-0059 I 56 802 I O,m61 $ 42747,48 $ 1149,40 $ 43 896,88 206 770,6 $ 81 312,87 112779 0,72100 01/27/04 Suburban 134692 I 2165 I 0,93000 1$ 2013,08 NlA $ 2013,08 208 935,2 $ 83 325,95 114943 0,72493 01/31/04 lovad"ustment ~$ $ 138,56 I 208 935,2 $ 83,464,51 116.486 0,71652 01/31104 Prior mo adlustment 2 160 0,63600 $ 1 605,43 I :A 7789 $ 77691 208.935,2 $ 63 542,40 116486 0,71719 01/31/04 End of month $ 41,819,95 58,032 58,454 0.71719 02/11/04 Suburban I $ 1 805,43 211094,8 S 43 425,36 60192 0,72145 02120/04 Sea-3 14004-0137 9420 0,64640 $ 7.781,58 $ 191,51 Is 7 973,09 220,514,8 S 51.398.47 69612 0,73836 02124/04 Sea-3 14004-0156 9611 I 0,84640 $ 7 939,36 $ 195,39 $ 6134,75 230 125,8 $ 59533,22 79 223 0,75147 02129/04 Inv adlustment 1.5251 - 1$ $ $ 230 125,8 $ 59 533,22 60 746 0,73727 02/29/04 End 01 month $ 23 763.67 32,232 48,516 0.73727 03105/04 Sea-3 4004-0178 19603 O,B8340 S 16916,60 $ 400,40 $ 17 317,20 249.n6,8 $ 41 060,87 51635 0,79253 03110104 Suburban 133017 2171 0,63000 $ 1601,60 NlA $ 1,601,60 251 699,4 $ 42,862,47 54 005 0,79404 03117104 Suburban 133342 2.216 0,63800 $ 1 852,66 N/A $ 1 852,86 254115,5 S 44735,13 56 222 0,79569 03/19104 Sea-3 4004-0203 18,849 0,86339 $ 16268,12 384,99 S 18.651,11 2n 984,5 $ 61 386,24 75071 0,81771 03/31/04 Inv adlustment 159 1,96421 S 312,31 - S 312,31 2n 964,5 S 61 698,55 75 230 0,82014 ' 03131/04 End of month $ 20,083,95 24 48. 50,741 0.82014 04/05/04 Sea-3 4004-0254 19,007 I 0,69329 I $ 12789,24 388,21 $ 131n,45 291 971,5 $ 33 261,40 43 496 0,76471 04/15104 Sea-3 4004-02n 18639 I 0,69320 I $ 12676,20 $ 383,01 I $ 13.059,21 310.610,5 $ 46.320,61 62 335 0,74310 04/21/04 Sea-3 4004-0269 194051 0,69330 I $ 13057,04 $ 396,38 $ 13453,40 330,215,5 $ 59 n4,Ol 81740 0,73127 04/30104 inv a<ljustment 473 I 0,34820 I $ 184,70 S 1$ 184,70 330215,5 $ 59938,71 82213 0,72907 04/30104 End of month $ 22,111.63 30 329 51664 0.72907 05105104 Sea-3 4004-0328 19619 0,73630 $ 14 083,89 4OO,n $ 14484,61 349634,5 S 36.596,24 49 948 0.73269 05105104 Suburban 133369 2199 0,79630 1750,75 NlA $ 1 750,75 352033,1 $ 38 346,99 52148 0,73538 05115104 Sea-3 4004-0346 28.854 0,73830 $ 20713,42 $ 589,35 $ 21 302,n 360 687,1 $ 59 849,76 61000 0,73642 05117/04 Sea-3 4004-0367 10,006 0,73830 7.183,01 $ 204,37 $ 7 387,38 390 693,1 $ 67037,14 91006 0,73662 05129104 Sea-3 4004-0388 19316 0,73829 13 868,38 S 394,52 $ 14260,90 410209,1 $ 61298,04 110322 0,73692 05131104 Invadlustment ~$ $ 410,72 410209,1 $ 61 708,76 110n7 0,73793 05131104 End of month $ 54,115.38 73,334 37,393 0.73793 06/01104 ad usl 4004-0366 $ 1,84 I $ 1,84 410209,1 $ 54 117,22 73 334 0,73795 06117104 Suburban 133369 1 552 0,65630 S 1 329,23 NlA 1$ 1 329,23 411761,4 $ 55 446,45 74 666 0,74041 06/24104 Sea-3 4004-0451 19710 0,79359 $ 15.239,18 $ 402,57 I $ 15,841,75 431 471,4 $ 71 088,20 94 596 0,75149 06/30104 Inv adluatment 211 0,60848 $ 128,39 S 1$ 126,39 431 471,4 S 71 216,59 94 807 0,75117 06130104 End 01 month $ 43,354.90 57 716 37,091 0.75117 07/22/04 Sea-3 4004-0527 29 043 O,n619 21 045,92 $ 595,97 $ 22 542,89 480 514,4 I $ 65,897,79 86759 0,75955 07/31104 Inv adjustment 219 0,76384 167,28 $ 1$ 167,28 460 514,4 I $ 66 065,07 88 978 0,75956 07/31104 End of month $ 44,227.05 . 58,227 28751 8.75956 I [ I FYTD Totals 390 893 0.71367 $ 276 721.36 $ 7 424.33 $ 279 045,80 LPWacog04 CSW:09l12/04 I I ATTACHMENT #4 Page 1 of2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/04 - 03/31/05 I. Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible & Contract (Non-Standard) Rate Schedule PGA (See attached Page 2) II. Calculation ofthe Required Natural Gas PGA WACOG for FY 04105 A. Therm Sales Projection for 10/1/04 - 9130/05 = B. Projected NG ReselVation Cost 10/1/04 - 9130/05 = $ Projected NG Commodity Cost 10/1/04 - 9130105 = $ Budgeted Other Supply Related Expenses = $ Total Recovery Needed for FY 03/04 only = $ 40% of Under Recovery of FYTD PGA thru 9/04 = $ Total Annualized Recovery Needed for FY 01/02 = $ C. Required Weighted Average Recovery CosVTherm =$ Currently overall PGA Recovery is: Therefore, Contract PGA needs to bE $ Which makes Standard PGA: $ = $0.070 22,700,000 1,380,000 14,570,000 2,000,000 17,950,000 700,000 18,650,000 0.822 90% of Contract Rate 0.91 0.98 D. Projected NG PGA Annual Revenue = III. Proposed Natural Gas PGA Billing Factors for 10/01/04 - 03/31/0E A. Proposed Standard Rate PGA Billing Factor $ B. Less Non-Standard Differential for ReselVation Cost $ C. Proposed Non-Standard PGA Billing Factor IV. Proposed LP Gas Billing Factors for 10/01/04 - 03/31/05 (Assumes current LP market conditions persist) Note: Includes 1 cents/gallon catch-up to recoup $5,600 under-recovery from 560,000 gallons over the year & 16 cents/gallon to recoup the $87,000 of Admin & CCS projected charges. Base est. was $0.91/gallon. Pinellas NG PGA = Pasco NG PGA = Total NG PGA = $ 16,806,352 $ 1,843,648 $ 18,650,000 $ PGA Onlv ECA in PGA Total PGA 0.98 $ 0.05 $ 1.03 (0.07) $ $ (0.07) 0.91 $ 0.05 $ 0.96 PGA On Iv. ECA in PGA Total PGA 1.08 $ 0.05 $ 1.13 $ U:\MY uocumems\EJ<.CELlGA:sAATE6\1'Y 04-05\tPGA for 1st Half of Fy U'HI:),xlslP""""'-(. CSW:09I12J04 ATTACHMENT #4 Page 2 of2 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON-8TANDARD THERMS & RESERVATION CHARGES FOR 08/01/03 - 07/31/04 - Subtotal Subtotal Net Net Charge Per Charge Per Billing Interruptible % Contract % Non-8tandard % Non- Standard % Reservation Standard Non-Interruptible Month Therms InterruDtible Ib!!:!!!! Contract Therms Standard Therms Standard Charaes Therm Therm Aug 2003 342,156 24.3% 500,485 35.5% 842,641 59.8% 565,444 40.2% $ 65,779.02 $ 0.116 $ 0.062 Sap 2003 341,455 23.6% 512,237 35.4% 853,692 59.1% 591,671 40.9% $ 67,642.17 $ 0.114 $ 0.061 Oct 2003 351,501 24.6% 508,807 35.6% 860,308 60.2% 569,644 39.8% $ 83,413.89 $ 0.146 $ 0.077 Nov 2003 361,860 24.4% 525,915 35.4% 887,775 59.8% 596,840 40.2% $ 147,692.22 $ 0.247 $ 0.132 Dee 2003 365,192 18.2% 715,269 35.6% 1,080,461 53.8% 927,278 46.2% $ 158,575.65 $ 0.171 $ 0.097 Jan 2004 410,576 17.6% 804,769 34.4% 1,215,345 52.0% 1,122,567 48.0% $ 161,503.19 $ 0.144 $ 0.084 Feb 2004 440,184 19.5% 758,814 33.6% 1,198,998 53.0% 1,062,113 47.0% $ 150,738.91 $ 0.142 $ 0,083 Mar 2004 415,959 18.4% 813,138 35.9% 1,229,097 54.3% 1,035,874 45.7% $ 160,335.03 $ 0.155 $ 0.087 Apr2004 441,442 21.0% 794,233 37.7% 1,235,675 58.7% 868,757 41.3% $ 107,736.02 $ 0.124 $ 0.065 May 2004 400,014 22.4% 648,304 36.4% 1,048,318 58.8% 733,786 41.2% $ 70,107.77 $ 0,096 $ 0.051 Jun 2004 369,074 23,5% 566,313 36.0% 935,387 59.4% 638,024 40.6% $ 67,107.09 $ 0.105 $ 0.056 Jul2004 352,822 24.1% 528,359 36.2% 881,181 60.3% 580,158 39.7% $ 69;885.55 $ 0.120 $ 0.063 Total 8/03-7/04 1,56 ,034 4,592,235 21.3% 7,676,643 35.6% 12,268,878 56.9% 9,292,156 43.1% $ 1,310,516.51 $ 0.141 $ 0.0772 # % of Total I 1 0.0% 21.3% 35.6% 56.9% 43.10/. For I _I, i Comoarison : ! Total 9/02-8/03 jO,.' ,94' 4,374,916 20,9% 7,015,063 33.5% 11,389,979 54.5% 9,521,964 45.5% $ 1,283,792.63 $ 0.135 $ 0.0776 % ofT otal 1 0.0% 20.9% 33.5% 54,5% 45.5% Change I 0.4% 661,580 2.1% 878,899 2.4% (229,808) -2.4% $ 26,723.88 $ 0.006 $ (O.OOO) 64 ,091 217,319 % Change 3.1% 5.0% 9.4% 7.7% -2.4% 2.1% I Note: # It is recom~end d that the "Charge Per Non-Interruptible Therm" differential be rounded to the next lowest penny or $0.070 for the next semi-annual cycle. U:\My Document.sIEXCELIGASRATESIFY 04-05~PGA for 1st Half of FY 04-05.x1s)PGACALC I I CSW:08/18/04 ATTACHMENT #5 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/03 - 3/31/04 I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 04/05 Projected ECA Requirements for FY 04/05 only = $ 1,400,000 Projected Administrative & CCS Charges to ECA for FY 04/05 = $ 200,000 Projected Current FYTD 03/04 (Over) Under Recovery of ECA = $ Total Annualized ECA Recovery Needed during FY 04/05 = $ 1,600,000 Less Projected ECA Recovery within PGA @ $0.05ITherm or Gal = $ (600,000) Total ECA Recovery Needed from Standard Rate Customers = $ 1,000,000 Projected Therm Sales for FY 04/05 Applicable to ECA Recovery = 10,200,000 (Natural Gas @ 43% Standard = 9,670,000 therms & LP @ 95% Standard = 530,000 gal. or 10,200,000 Total Applicable Therms) Computed ECA Recovery Factor Necessary = $ 0.0980 Propose Rounding ECA Recovery Rate to $ 0.100 # Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 1,620,000 II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 04/05 Budgeted EIA Requirements for FY 04/05 only = Projected Current FYTD 03/04 (Over) Under Recovery of EIA = Total Annualized EIA Recovery Needed during FY 02103 = $ 100,000 $ (60,000) $ 40,000 We are over-recovered in ECA & project to stay over-recovered for at least the 1st 1/2 of FY 04/05. Therefore, EIA needs to be for 1st 1/2 of FY 04/05 = $ Round Proposed EIA Recovery Rate to $ Annual ECA Revenue Projection @ Proposed Recovery Rate = $ U:\My DocumentsIEXCELIGASRATES\FY 04-05\[ECA & EIA for 1st Half of FY 04-05,xls]Sheet1 CSW:09113/04 Applicable Annual Therm ~nge or Other Rate Determina!)t Monthly Customer Charge Non-Fuel En Non-Fuel Energy Charge Energy Conservation Adj, (-=CA) Environmental Imposition Aflj, {E I Weather Normalization Adj,: ! Purchased Gas Adjustmen~ {P I Total Energy ChargelThel/m , Minimum Monthly Bill Compares to LP/Gallon Ra~ of with 6.0% Franch~se I Change from 10/03 Therm ~ate % Change from 10/03 Therr Rat Utilitv Tax Note: Fuel Rate per Therm 10/01Q3 I Non-Utility Taxable FueVTh~nn i I BTU FACTOR = THERMS/ 00 Firm Service Rates Interruptible Service Rates CLEARWATER GAS SYSTEM NATURAL GAS RATE BilLING FACTORS FOR OCTOBER 1, 2004 - MARCH 31, 2005 BASED ON APPROVED GAS ADJUSTMENT FACTORS -----BL SMF ...MME... ....bME... NA {1 - NA {4 + NA {4 + NA (4 + 3 Units) Units) Units) Units) $0,580 0,100 0,000 .Q..QQQ $0,680 ~ $1,710 $7.00 $7.00 $15.00 $20,00 $0,580 0,000 $0.680 ~ $1.710 $20,00 $50,00 $0,580 0,100 0,100 Firm Natural Gas Rate Schedules ...!QL ~ .JJiL ~ ~ LAC 0- 18,000- 100,000 17,999 99,999 & up $15,00 $0.470 0,100 0.000 0.000 $0,570 .1..QM $1,600 $15.00 $20,00 $0.410 0,100 0,000 0.000 $0.510 ~ $1,540 $20,00 NA {1 - NA {O - NA (150 3 Units) 149 tons) tons & +) $50,00 $7.00 if $15.00 if $20.00 if $15,00 not prey, not prev, not prey, billed billed billed $0,350 $0.200 $0,150 $0.100 $0,200 0.100 0,100 0,100 0.100 0,100 0.000 0,000 0,000 0,000 0.000 0.000 ~ 0.000 0,000 0.000 $0.450 $0,300 $0.250 $0,200 $0,300 ~~~1.m~ $1,480 $1.330 $1,280 $1.230 $1,330 $50,00 $7,00 @ $15,00 @ $20,00 @ $15,00 premise premise premise + FAC -.II... SL w/M& NGV Reliaht NA NA NA $15,00 $7 Resl./ $15 GS if not prey, billed $0,300 $0,100 0,100 0.100 0.000 0,000 0.000 0,000 $0.400 $0,200 ~ 1,030 $1,430 $1,230 $15,00 $7 Resl./ +FAC $15GS@ premise +FAC Interr. ~ ~ --1L.. NA 100,000 &up $30.00 $100,00 $0,470 $0.280 0.100 NA 0,000 NA Q.QM 0,000 $0,570 $0.280 ~ 0,960 $1.600 $1,240 $30.00 $100,00 + FAC + Non-Fuel Thenn Rate for 250 therms X # Days in Mo. $ 1,565 $ 1.565 $ 1,565 $ 1,565 $ 1,464 $ 1,409 $ 1,354 $ 1,217 $ 1,171 $ 1.125 $ 1.217 $ 1,308 $ 1.125 $ 1,464 $ 1.135 $ 1.659 $ 1,659 $ 1,659 $ 1,659 $ 1,552 $ 1,494 $ 1,435 $ 1,290 $ 1.241 $ 1,193 $ 1.290 $ 1,387 $ 1,193 $ 1,552 $ 1.203 $0.580 0,100 0,000 0.000 $0,680 1.030 $1,710 $15,00 0.000 0,000 $ 0,180 $ 0,180 $ 0,180 $ 0,180 $ 0,180 $ 0,180 $ 0,180 $ 0,180 $ 0.180 $ 0,180 $ 0,180 $ 0,180 $ 0,180 $ 0.180 $ 0,180 11.8% 11.8% 11,8% 11,8% 12,7% 13,2% 13,8% 15,7% 16,4% 17,1% 15,7% 14.4% 17,1% 12,7% 17,0% 0.000 $0,680 ~ $1.710 $50,00 $0,069 $0,069 $0,069 $0.069 $0,961 $0,961 $0,961 $0,961 1.054 10/04 11/04 1,034 ~ 21m $0,069 $0,069 $0,961 $0.961 02105 03/05 $0.069 $0,069 $0,069 $0,069 $0,069 $0.961 $0,961 $0,961 $0.961 $0,961 04/05 05/05 06/05 07/05 08/05 $0,069 $0,069 $0.069 $0.055 $0,961 $0,961 $0,961 09/05 $0.905 Attachment ##6 Contract NG Rate ~ NA By Contract C.ct NA NA 0,000 Contract + $0.000 Plus 0,960 $0.960 + Non-Fuel Customer Charge + Non-Fuel T Rate for Cc # of Therm $ftO 23.1% $0,069 $0,891 C5W:08118/04 i i i Attachment #7 ~ t'o""'oo """'... (CC') Page 1 of2 BTU Factor: CLEARWATER GAS SYSTEM BTU Factor: 2.4 3 enns/100 cubic feet (CCF) METERED PROPANE (lP) RATE BilliNG FACTORS Thenn Factor: 0.9 henns/Gallon FOR OCTOBER 1, 2004 - MARCH 31, 2005 BASED ON APPROVED GAS ADJUSTMENT FACTORS , I RESIDENTIAL MUL TI-FAMIL Y LOOP RESL SMALL COML. LARGE COML. VEHICLE STANDBY CONTRACT MTRD , I i MRLP MMLP LRLP MGLP MLLP LPV LPS CLP Applicable Annual GaIlO~ Ran.e NA NA NA o - 2,500 >2,501 NA NA NA or Other Rate Detenni ant I (1 - 3 Units) (4 + Units) (1 - 3 Units) Monthly Customer Cha",ie ! $7.00 $15.00 $7,00 $15,00 ' $20.00 $7.00 Resl. or $30.00 Set By Contract ~G .1I0n: $15.00 GS if not Non-Fuel Enerav ChaR prevo billed @ -- premise Non-Fuel Energy ChargE IGal on $1.600 $1.600 $0.800 $0.200 $0.150 $0.100 $0.390 Set By Contract ...... CoMeMdloo AdJ.;t 0.100 0,100 0.100 0.100 0.100 0.100 0.100 NA E........' ,- i /G. "" 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Nonnalization J.lG lion Q.QQQ 0.000 Q.QQQ Q.QQQ Q.QQQ Q.QQQ 0,000 0.000 Total N........ C"+'+ $1,700 $1.700 $0,900 $0.300 $0.250 $0.200 $0.490 By Contract + $0.000 Pu....... G.. Adj"~J"" l...llQ l...llQ 1.130 1.130 l...llQ 1.130 l...llQ 1,130 Total Energy Chargesl1allO I $2.830 $2.830 $2.030 $1.430 $1,380 $1.330 $1.620 $1.130 + Contract NFE Minimum Monthly Bill I $7.00 $15,00 $7.00 $15.00 $20,00 Any Applicable $30.00 Customer Charge + I I Customer Charge Non-Fuel Energy ~, i I + Any Applicable for the Contracted Facility Charges # of Gallons/Mo. Utilitv Tax Note: I I Fuel Rate per Thenn 10/~1n31 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Noo-Utinty Tox"'. 't $0,969 $0.969 $0.969 $0.969 $0,969 $0,969 $0.969 $0.969 I I Change from 10/03 Gall n Ra $ 0.390 $ 0.390 $ 0,390 $ 0,390 $ 0.390 $ 0.390 $ 0.390 $ 0.390 % Change from 10/03 G , lion *ate 16.0% 16,0% 23.8% 37.5% 39.4% 41,5% 31.7% 52.7% i i CSW:08/18/04 Attachment #7 Page 2 of2 BTU Factor: BTU Factor: Therm Factor: 2.714 2.483 0.915 Gallons/100 cubic feet (CCF) Therms/100 cubic feet (CCF) Therms/Gallon CLEARWATER GAS SYSTEM BULK PROPANE (lP) RATE BilliNG FACTORS FOR OCTOBER 1, 2004 - MARCH 31, 2005 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) ~ BRLP2 BRLP3 BRLP4 RESIDENTIAL "WILL CALL" COMMERCIAL "WILL CALL" CONTRACT ''WILL CALL" (Based on Annual Usage Level) WRLP BCLP1 BCLP2 CLP Applicable Annual Gallo Ran e or Other Rate Detennin nt 0-60 1-3 UNITS 60.1 -120 1-3 UNITS 120,1 - 300 1-3 UNITS > 300 1-3 UNITS 1 st 300 1-3 UNITS > 300 0 - 2,500 > 2,500 For Add'l. Annual Customers in this Customers in this Gallons Used Range of Usage Range of Usage NA $ 60,00 $ 60.00 Any Contract Customers-el\'o Request Bulk Delivery Set by contract $ 1.500 $ 1.300 $ 0.800 $ 0.700 $ 0.800 $ 0.700 $ 0.200 $ 0.150 Set By Contract 0.100 0.100 0.100 0,100 0,100 0.100 0.100 0.100 NA Environm'llmposition Ad .IGal on NA Weather Normalization pG lion 0.000 Total Non-Fuel Charg $ 1.600 $ 1.400 $ 0.900 $ 0.800 $ 0.900 $ 0.800 $ 0.300 $ 0.250 Set By Contract + 0.000 Purchased Gas Adjus ntl allon 1,130 1.130 1.130 1.130 1.130 1,130 1.130 1.130 1.130 -, $ 2.730 $ 2.530 $ 2.030 $ 1.930 $ 2.030 $ 1.930 $ 1.430 $ 1.380 1.130 + Contract NFE Note: No Monthly Minim m B II Utilitv Tax Note: i ! i Fuel Rate per Therm 101 1/731 0,161 0.161 0.161 0.161 0,161 0.161 0,161 0.161 0.161 I I Non-Utility Taxable Fue he~ 0.969 0,969 0,969 0.969 0.969 0,969 0.969 0,969 0.969 Change from 10/03 Gallo Rat $ 0.390 $ 0.390 $ 0.390 $ 0.390 $ 0.390 $ 0,390 $ 0.390 $ 0.390 $ 0.390 % Change from 10/03 G lion ate 16.7% 18.2% 23,8% 25.3% 23.8% 25,3% 37,5% 39.4% 52.7% I I , I ! , I $ 96.00 $ 72.00 $ 60.00 $ 48.00 $ 48.00 .~ 1 I CSW:09/13104 I I I Attachment #8 I I I I Page 1 of2 . Residential Rate History By Components Clearwater Gas System I I I Total Rate COlllPonentsrrhenn Contract LP Month NGlthenn LP/aallon * ECA EIA WNA PGA PGA PGAlaallon Oct-Q4 $ 1,710 $ 2.030 $ 0.100 $- $ - $ 1.030 $ 0.960 $ 1.130 Nov-Q4 Dec-04 Jan-Q5 Feb-05 Mar-05 Apr -05 May-05 Jun-05 Jul"05 Aug-05 Sep-05 FY 04105 Avg. $ 1.710 $ 2.030 $ 0.100 $ - $ - $ 1.030 $ 0.960 $ 1.130 2004 Avg. Incr. Above $ 0.180 $ 0.200 $ - $ - $ - $ 0.180 $ 0.180 $ 0.200 Last Year Same Month 12% 11% 0% NA NA 21% 23% 22% Incr. Based $ 3.60 $ 4.37 on 20 Therms 10% 10% Equivalent Cents/KWH 5.8 7.6 for Gas vs. FPC Rate 8.9 8.9 (Residential) Gas Cheaper by -34% -15% -- -- -- -- H'_-'__. __. _..n, _..._ _ . n __ - -- Notes: * Based on Bulk LP (BRLP3 which is applicable for customers using 120.1 - 300 aallons/year & equal to Residential LP Will Call (BRWCLP).