Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JULY 1, 2004
? .i 1 I .. CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet RECEIVED JUL 01 2004 TO: FROM: William B. Horne II, City Manager Chuck Warrington, Managing Director e;yJ ')FFiC!Al RECORDS AND Li:GISLAiiVE SRVCS DEPT 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 JUL V 1, 2004 DATE: June 29, 2004 Regrettably, world energy prices are still elevated, necessitating our request to increase our Natural Gas and Propane (LP) supply prices somewhat. We are recommending an increase of 5C/therm in our Natural Gas and 50/gallon in our LP Purchased Gas Adjustments (PGA). Additionally, we are falling behind in our Energy Conservation Adjustment (ECA) collections based on the continuing high level of construction activity. Therefore, we are recommending an increase of 30/therm or gallon in our ECA. We not recommending any additional changes in our other adjustment clauses at this time. The net effect of these recommended changes is an increase in our typical Residential Natural Gas rate of 80/therm (up 4.97%) and 80/gallon (up 4.19%) in our typical Residential LP rate. The proposed NG therm rate is still (11 %) below the winter of 2001 when rates spiked historically, but the LP rate is actually +4.7% above that prior peak. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after July 1, 2004: Natural Gas Firm Standard Rate Schedule PGA ....... $0.960 per therm (up 5.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.890 per therm (up 5.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $1.040 per gallon (up 5.0C/gallon) = $1.137 per therm equivalent (up 5.5C/therm equivalent) Energy Conservation Adjustment (ECA) ............... $0.150 per therm (up 3.0C/therm) & $0.150 per gallon of LP (up 3.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/-/02v3 (j~ ) y William B. Horne II, City Mclager Page 2 I June 29, 2004 .. Attachment #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru May and projections thru the end of the fiscal year. These show that we are currently ($2.2 Million) behind on our collections and are attempting to recover about 25% of this by the end of the fiscal year. It is important to our overall financials for FY 03/04 that we bring this closer to balance by our Fiscal Year End, and our recommended recovery factors are based on this. Attachments #2 and #3 show our current annual projections for Natural Gas supply costs and LP historical FYTD costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Finally, Attachment #6 shows the history of our Residential rates and the adjustments back to October 2000. I should point out that the overall effect is that our typical Residential customer rates are still 35 % lower than electric for Natural Gas and 16 % lower for LP. It is our plan to use the above-proposed adjustments for billings through September 30, 2004, 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 July 1 st billings. If you have any questions on this, please call me. CSW /csw Attachmen~ Approved: .:-8. ~ -:rr: illiam B. Horne II, City Manager U:\My Documents\Word\GASRATES\FY 03-04\Gas Adjustments for July 2004.doc I:. .. CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Page 1 of 3 NATURAL GAS PURCHASED GAS ADJUSTMENT fPGA-NG) Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatefThenn Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) Firm/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-Q4 $ 153,880.25 $ 1,215,188.49 $ 10,284.21 $ 30,276,00 $ 1,409,628,95 $ 1,598,489,98 $ 188,861,03 $(1,867,981.56) .890/.820 May-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 $ 78,000.00 $ 970,000.00 $ 8,000.00 $ 25,000.00 $ 1,081,000,00 $ 1,190,112,00 $ 109,112.00 $ (1,589,465.58) .910/.840 Jul-04 $ 80,000.00 $ 900,000.00 $ 7,000.00 $ 25,000,00 $ 1,012,000,00 $ 1,220,012,00 $ 208,012,00 $ (1,381,453.58) .960/.8..... Aug-04 $ 80,000,00 $ 900,000.00 $ 6,000.00 $ 25,000,00 $ 1,011,000.00 $ 1,228,200,00 $ 217,200.00 $(1,164,253.58) .960/.890 Sep-04 $ 81,000.00 $ 900,000.00 $ 5,000,00 $ 25,000.00 $ 1,011,000.00 $ 1,228,200,00 $ 217,200.00 $ (947,053,58) .960/.890 Period 13 9 762,776,55 - $ (762,776.55 $(1,709,830.13 Total YTD $ 2,881,132.50 $ 12,517,161.58 $123,131.45 $ 347,508,33 16,631,710,41 16,741,486.45 109,776,04 (1 ) Includes annual charae for Admin and CCS cho of $1.429.480 (9) = Transfer of ECA Collected in PGA~ 1/2 ofthe ECA Rate (NG Proportion) (1 ) FY 02/03 WNA write off of $226,33, PGA of $16,179.26 PROPAN ILpT GAsPITRCHA ADJUSTMENT fPGA-LP\ Month Iv Cumulative LP PGA Budget Gallons Monthlv Interest Commodity Total LP Fuel Total LP PGA Overaae YTD Overage Thenn/Gal. Month Sold WACOG Expense Charges Expenses Billed (Shortaae) (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 $ 521.22 $ 20,954.89 $ 21,476.11 $ 29,636,36 $ 8,160,25 $ (89,619.05) 1.017/.930 Dee-03 61,823,0 $ 0,66842 $ 480,42 $ 41,323.73 $ 41,804.15 $ 57,503,58 $ 15,699.43 $ (73,919,62) 1.017/.930 Jan-04 57,240,8 $ 0,71719 $ 401,92 $ 41,052.53 $ 41,454,45 $ 55,699,62 $ 14,245.17 $ (59,674,45) 1.082/.990 Feb-04 51,762.0 $ 0.73727 $ 330.70 $ 38,162.57 $ 38,493,27 $ 51,176.51 $ 12,683.24 $ (46,991.21) 1.082/.990 Mar-04 48,115,8 $ 0,82014 $ 267,28 $ 39,461,69 2 $ 45,118.67 $ 47,726,66 $ 2,607.99 $ (44,383.22) 1.082/,990 Apr-04 53,064,5 $ 0,72907 $ 227,29 $ 38,687,74 3 $ 39,790,55 $ 52,537.48 $ 12,746.93 $ (31,636.29) 1,082/.9...... May-04 39,427,7 $ 0.73793 $ 159,18 $ 29,094.88 4 $ 29,454.06 $ 39,033,29 $ 9,579,23 $ (22,057,06) 1.082/.990 Jun-04 43,000,0 $ 0.74000 $ 100,00 $ 31,820,00 $ 31,920,00 $ 42,570,00 $ 10,650.00 $ (11,407,06) 1.082/,990 Jul-04 41,000,0 $ 0,75000 $ - $ 30,750.00 $ 30,750,00 $ 42,640,00 $ 11,890.00 $ 482.94 1,137/1.040 Aug-04 33,000,0 $ 0,76000 $ - $ 25,080.00 $ 25,080.00 $ 34,320,00 $ 9,240.00 $ 9,722,94 1.137/1.040 Sep-Q4 33,000,0 $ 0,76000 $ - $ 25,080,00 $ 25,080,00 $ 34,320,00 $ 9,240.00 $ 18,962,94 1,137/1.040 Period 13 9 $ 19,558,37 $ - $ (19,558,37) $ (595,43) Total YTD 527,427,3 $ 0,72685 $ 2,626.35 $ 383,360,01 $ 491,959.94 $ 519,031,72 $ 27,071.78 Cost Center Exoenses CCS Chg & Admin $ 62,000,00 1 (9) = Transfer of ECA Collected in PGA @ 1/2 of ECA Rate (lP Prop.) FY 02/03 Write off PGA $ 1,650.99 1 Fuel $ 15,000,00 1 Cost Center Exoenses (continued) PC Anywhere & Suburban $ 1,299,00 1 2004 FPGA Annual Convention Soons $ 200,00 4 LP Yard Vaporization $ 4,044,58 2 Total $ 86,415.21 LP PGA Event Fuel Cost $ 1,345,12 2 FY04 Write off $875,52 $ 875,52 3 J.' .' Attachment #1 Pace 2 of 3 ENERGY CONSERVATION ADJUSTMENT IECA\ Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGfThenn Month Expenses Notes/Exceptionalltems Expense Expenses Billed (Shortaae) (Shortaae) LP/Gal. Prior Year $ - Oct-03 $ 685,229,77 Promo$28,789,Adv $0, Employ Cosls$62,117 $ - 1 $ 685,229,77 $ 60,398.24 $ (624,831,53 $ (624,831,53 ,100/,100 Nov-03 $ 69,454,73 Promo$19,911,Adv $1,820, Employ Cosls$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 Cosls$43,004 $ 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 Costs$64,S81 $ 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 Cosls$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 Promo$34,S72,Adv $3,170, Employ Cosls$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$58,OS6,Adv $720, Employ Cosls$47,200 $ 2,757.93 $ 106,733.49 $ 108,997.43 $ 2,263.94 $ (549,322.80) .120/,120 May-04 $ 119,514,48 Promo$71.062,Adv $2.229, Employ Costs$46,223 $ 2,746.61 $ 122,261.09 $ 91,654,76 $ (30,606.33) $ (579,929.13) .120/.120 Jun-04 $ 140,000,00 $ 2,800,00 $ 142,800.00 $ 79,783.20 $ (63,016.80) $ (642,945.93) .120/.120 Jul-04 $ 140,000.00 $ 2,900,00 $ 142,900.00 $ 96,453.00 $ (46,447,00) $ (689,392.93) .150/,1~ Aug-04 $ 140,000.00 $ 3,000.00 $ 143,000,00 $ 96,579.00 $ (46,421.00) $ (735,813,93) ,150/.150 Sep-04 $ 140,000,00 $ 3,100.00 $ 143,100.00 $ 96,579.00 $ (46,521.00) $ (782,334.93) ,150/.150 Period 13 9 782,334.93 $ 782,334.93 $ - Total YTD $ 1,937,525.14 $ 32,531.01 1,970,056,15 1,970,056.15 - (1) Includes annual charge for Admin and CCS chg 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 charaes of $428,461.86 Note: Maximum amount which can be collected herE $ 2,556,480.28 (2) Adjustment to FY 03 Write-off of $19,912,40 ENVIRONMENTAL IMPOSITION ADJUSTMENT 'EIA\ Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overaae YTD Overage NGlTherm Month ExDenses NoteslExceDtionalltems 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 Dee-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 .000/,Oac..... 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 $ 10,000,00 $ . $ 10,000,00 $ - $ (10,000.00) $ 72,796.22 .0001.000 Jul-04 $ 10,000,00 $ - $ 10,000.00 $ - $ (10,000.00) $ 62,796.22 .000/.000 Aug-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000.00) $ 52,796.22 .000/.000 Sep-04 $ 10,000,00 $ - $ 10,000.00 $ - $ (10,000,00) $ 42,796.22 .000/,000 Period 13 $ - - $ - $ 42,796.22 Total YTD $ 133,552,79 $ - $ 133,552,79 $ - $ (133,552,79) (1 ) Includes annual charQes for Admin Charge $10,000 + FY 02/03 Write-off of $3,12 Attachment #1 Page 3 of 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage NGrrhenn-Finn 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,719,74 $ 1,166,549.31 $ 145,829.57 $ (3,512,211.26) ,950/1.03 Dee-03 $ 1,433,173,70 $ 1,648,810,19 $ 215,636,49 $(3,296,574,76) .950/1.03 Jan-04 $ 1,734,846,24 $ 2,014,119.37 $ 279,273,13 $ (3,017,301.63) 1,010/1,110 Feb-04 $ 1,795,573,29 $ 1,920,403,02 $ 124,829.73 $(2,892,471.90) 1.01011.110 Mar-04 $ 1,597,265,14 $ 1,924,185.13 $ 326,919,99 $(2,565,551.92) 1.010/1.110 Apr-04 $ 1,559,905,40 $ 1,760,024,89 $ 200,119.49 $(2,365,432.42) 1.01011.110 May-04 $ 1,354,606.67 $ 1,502,271.55 $ 147,664,88 $(2,217,767.54) 1.010/1.110 Jun-04 $ 1,265,720.00 $ 1,312,465,20 $ 46,745,20 $(2,171,022.34) 1.01011,110 Jul-04 $ 1,195,650,00 $ 1,359,105,00 $ 163,455,00 $(2,007,567,34) 1.010/1, -u,g. Aug-04 $ 1,189,080.00 $ 1,359,099,00 $ 170,019.00 $(1,837,548.34) 1.010/1.110 Sep-04 $ 1,189,180.00 $ 1,359,099.00 $ 169,919.00 $(1,667,629.34) 1.010/1,110 Period 13 $ 782,334,93 $ 782,334.93 $ - $(1 667,629.34) Total YTD $ 19,227,279.29 $ 19,230,574,32 $ 3,295.03 (1) Includes Admin. & CCS Charges of $1,664,500 + Write-off Charges of $20,901.65 + Fuel of $15,000 + Service Order Chao es of $428,461,86 + Other $159.00 = $2,129,022.51 Total WEATHER NORMALIZATION tWNA\ Monthly Cumulative WNA Budget Interest Overage YTD Overage NGrrhenn Month LP Gallons Expense Rate/Gallon NG Thenns Raterrhenn (Shortage) (Shortage) LP/Gal 8eg, 8al, $ - Oct-03 34,127.3 $ - $ - 1 1,429,952,1 - $ - $ - ,000/,000 Nov-03 31,866.2 $ - $ - 1,484,615.3 - $ - $ - .000/,000 Dee-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) ,OOOI,O~ Mar-04 48,115,8 $ - $ - 2,264,971,0 - $ (0,02) $ (1.24) .0001.000 Apr-04 53,064.5 $ - $ - 2,104,433.0 - $ - $ (1.24) .0001.000 May-04 39,427,7 $ . $ - 1,782,103,0 - $ - $ (1.24) .000/.000 Jun-04 43,000.0 $ - $ - 1,540,000.0 - $ - $ (1.24) .000/.000 Jul-04 41,000,0 $ - $ - 1,490,000.0 - $ - $ (1.24) ,0001.000 Aug-Q4 33,000.0 $ - $ - 1,500,000,0 - $ - $ (1.24) .0001.000 Sep-04 33,000,0 $ . $ - 1,500,000.0 - $ - $ (1.24) ,000/.000 Period 13 $ (1.24) Total YTD 527,427,3 . - 21,702,836.4 $ - $ (1,24) U:\Mv Doeuments\EXCEL\GASRATES\FY 03-04\fAdjustment Clause Recoverv for FY 03-04,xlslNov Recoverv CSW:Updated 06/28/04 I Propane Weighted Average Cost of Gas (WACOG) FY 2003-04 AT1BCHf1IfelJr #3 I : 6/28/2004 comoanJ Gallons Propane Propane ShIppIng Total FYTD Cost of Tank Tank WACOG Dale InvoIce # Delivered Rate Cost Cost Cost Gallons Inventarv Inventorv Wlthdrawl 09/30102 $ 29,135.22 44,337 0.65713 10/15/03 5ea-3 4003-0747 38.223 0,62972 $ 23 303,42 S 766,18 $ 24 069,60 38.223,0 I S 53204,62 82,560 0,64444 10/31/03 Inv ad ustment 361 I - S 1$ 38,223,0 I S 53 204,82 82.941 0,64148 10/31103 End of month c' $ 29.273,21 45,634 37,307 0.64148 11/06103 Suburban 110991 2,247 0,70300 $ 1 579,43 N/A $ 1 579,43 40.469,7 $ 30,852,64 47.881 0,64436 11/18103 5ub1Jrban 450366 2.400 0,72800 $ 1 742,40 NlA $ 1,742,40 42 869,7 $ 32.595,04 50.281 0,64826 11/20103 Sea-3 4003-0835 36,628 0,86641 $ 24 967,98 S 774,29 . $ 25.742,27 81.497,7 S 58 337,31 68 909 0,65615 11/20/03 Sea-3 4003-0855 9.600 0,68641 S 8205,15 S 192,43 $ 6,397,58 91097,7 1$ 64 734,89 98 509 0,65715 11/30103 inv adjustment 60 1,38533 S $ 83,12 91 097,7 $ 64818,01 98 569 0,65759 11/30103 End of month S 39,419.17 59945 38,624 0.65759 12/18/03 Sea-3 14003-0919 I 47,186 0,67562 S 30933,73 I $ 945,84 $ 31.879,57 I 138283,7 $ 71298,74 107131 0,66553 12/17/03 Suburben 427601/011341 2288 0,75800 $ 1 734,23 I $ $ 1.734,23 I 140,571,6 $ 73032,97 109419 0,66746 12/26103 S08-3 14003-0944 I 9397 0.67561 $ 6 160,39 I S 188,36 $ 6.348,75 I 149 968,6 S 79381,72 118816 0,66811 12/31/03 inv adjustment I 96 1,05625 $ 101.40 1$ 1$ 101,401 149968,6 S 79463,12 118912 0,66842 12/31/03 End of month S 37,415,99 55977 62.935 0.66842 01/19104 5ea-3 4004-0059 . 56.602 I O,m81 S 42.747.48 I $ 1 149,40 I $ 43896,68 206 770,6 $ 81,312,67 112779 0,72100 01/27/04 Suburban 134692 2165 I 0,93000 $ 2 013,06 I NlA 1$ 2013,08 208 935,2 $ 83.325,95 114943 0,72493 01/31/04 Inv adiustment ~ - $ 138,56 208,935,2 I $ 63464,51 116.486 0.71652 01/31104 Prior mo adjustment 77.89 $ 77,69 206 935,2 $ 63 542,40 116486 0,71719 01/31104 End of month $ 41 619,95 58,032 58,454 0.71719 02/11/04 Suburban 2 160 0,83600 I $ 1 605.43 NlA $ 1 805,43 I 211094,6 $ 43.425,38 60,192 0,72145 02/20/04 Sea-3 4004-0137 9420 0,84640 I $ 7781,58 I $ 191,51 $ 7 973,09 220 514,8 $ 51.396,47 69612 0,73836 02124/04 Sea-3 4004-0158 9.611 0.64840 I $ 7 939,36 I $ 195.39 $ 8,134,75 230.125,6 S 59.533,22 79 223 0,75147 02129/04 iov adjustment 1.525 1$ - 1$ $ 230,125,8 $ 59.533,22 60 746 0,73727 02/29/04 End of month $ 23,763,67 32232 46,518 0.73727 03105/04 Sea-3 4004-0178 19.603 0.68340 S 16 916,80 $ 400.40 $ 17,317,20 249.726,6 S 41.060,67 51835 0,79253 03110104 Suburban 133017 2171 0,83000 $ 1601,60 N/A $ 1,801,60 251,699,4 $ 42.662,47 54.0OS 0,79404 03/17104 Suburban 133342 2216 0,63600 $ 1.852,66 N/A $ 1,852,66 254 115,5 $ 44.735,13 56 222 0,79569 03119/04 508-3 4004-0203 18649 0,66339 $ 16266,12 $ 364,99 $ 16651,11 272 964,5 $ 61 386,24 75.071 0,81771 03131104 Inv adjustment 159 1,96421 312,31 $ - $ 312,31 272 964,5 $ 61 698,55 75.230 0,82014 03131104 End of month $ 20 083.95 24,489 50,741 0.82014 04/05/04 Sea.3 4004-0254 19.007 I 0,69329 $ 12 789,24 I S 368,21 I $ 13 177,45 291.971,5 $ 33 261,40 43 496 0,76471 04/15104 Sea-3 4004-0272 188391 0.69320 12 676,20 I S 383,01 I $ 13059,21 310.810,5 IS 46,320,61 62 335 0,74310 04/21/04 508-3 4004-0289 19.405 I 0,69330 13057,04 $ 396,36 $ 13 453,40 330,215,5 $ 59 774,01 81740 0,73127 04130104 Inv adjustment 473 I 0,34820 164,70 $ $ 164,70 330215,5 S 59 938,71 82213 0,72907 04130104 End of month $ 22.111,63 30,329 51884 0.72907 05/05/04 Sea-3 4004-0328 19.619 0.73830 $ 14 083,89 S 400,72 $ 14.484,61 349.834,5 $ 36.596,24 49,948 0,73269 05105104 Suburban 133389 2199 0,79630 $ 1 750,75 N/A $ 1.750,75 352.033,1 S 38.346,99 52,146 0,73538 05/15104 Sea-3 4004-0346 26 854 0,73830 $ 20713,42 S 589,35 $ 21,302,77 360,667,1 $ 59 649,76 61,000 0,73642 05/17/04 5ea-3 4004-0387 10,006 0,73830 7183,01 $ 204,37 $ 7 397,38 390893,1 $ 67.037,14 91006 0.73662 05129104 Sea-3 4004-0386 19,316 0,73629 $ 13.866,36 I $ 394,52 S 14,260.90 410.209,1 $ 81 298,04 110,322 0.73692 05131104 iov adlustment - $ 410,72 410.209,1 $ 61.706,76 110727 0,73793 05131/04 End of month , S 54115,38 73,334 37,393 0.73793 06101104 ad.usl 4004-0388 1,64 $ 1,84 410209,1 $ 54 117,22 73 334 0,73795 1 1 I FYTD Totals 390 893 0,71387 $ 278721,36 I $ 7 424,33 I $ 279 045.80 -Jj,t..\a- ;5~-3 t:l~.JGr~ t"r,~ - 3bl-~/UY\. ;:,e- 6n'- ~~II~ LPWacog04 ... CSW:06/25/04 Attachment #5 Page 1 of 2 BTU Factor: 2.714 Gallonsl1 00 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2,483 Thermsl100 cubic feet (CCF) METERED PROPANE (lP) RATE BilliNG FACTORS Therm Factor: 0.915 Therms/Gallon FOR JULY 1, 2004 - SEPTEMBER 30, 2004 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MUL TI-FAMIL Y LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPS 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) Monthly Customer Charge $7.00 $15,00 $7,00 $15,00 $20,00 $7,00 Res!. or $30.00 Set By Contract $15,00 GS if not Non-Fuel Enerav Charae./Gallon: prey, 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 Q..QQQ ~ Q.QQQ 0,000 0.000 Q.QQQ 0.000 0.000 Total Non-Fuel Chargee/Gallon $1.750 $1.750 $0,950 $0,350 $0.300 $0.250 $0,540 By Contract + $0,000 Purchased Gas Adjustment/Gallon 1,040 1,040 1,040 1,040 .1.MQ .1.MQ 1M2 1.040 Total Energy Charges/Gallon $2,790 $2,790 $1,990 $1,390 $1.340 $1,290 $1,580 $1.040 + Contract NFE Minimum Monthly Bill $7,00 $15.00 $7.00 $15.00 $20,00 Any Applicable $30,00 Customer Charge + Customer Charge Non-Fuel Energy Cha.. + Any Applicable for the Contracted Facility Charges # of Gallons/Mo, Utilitv Tax Note: Fuel Rate per Therm 10/01n3 0,161 0.161 0,161 0.161 0,161 0,161 0,161 0.161 Non-Utility Taxable FuelfTherm $0,879 $0,879 $0,879 $0.879 $0,879 $0,879 $0,879 $0.879 Change from 01/01 Gallon Rate $ 0,289 $ 0.289 NA $ 0,089 $ 0.089 $ 0.089 $ 0,089 $ 0.040 % Change from 01/01 Gallon Rate 11.6% 11.6% NA 6,8% 7.1% 7,4% 6,0% 4,0% .. CSW:06/25/04 Attachment #5- 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 JULY 1, 2004 - SEPTEMBER 30, 2004 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 BCLP2 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 Eneroy 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,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.000 Total Non-Fuel Charges/Gallon $ 1.650 $ 1.450 $ 0.950 $ 0.850 $ 0.950 $ 0.850 $ 0.350 $ 0.300 Set By Contract + 0.000 Purchased Gas Adjustment/Gallon 1,040 1,040 1,040 1.040 1.040 1.040 1,040 1,040 1,040 - Total Energy Charges/Gallon $ 2.690 $ 2.490 $ 1.990 $ 1.890 $ 1.990 $ 1.890 $ 1.390 $ 1.340 1.040 + Contract NFE Note: No Monthly Minimum Bill Utilitv Tax Note: Fuel Rate per Therm 10/01173 0,161 0,161 0,161 0,161 0,161 0,161 0,161 0,161 0,161 Non-Utility Taxable Fuelfrherm 0,879 0,879 0,879 0,879 0,879 0,879 0.879 0,879 0.879 Change from 01/01 Gallon Rate $ 0,289 $ 0,239 $ 0,189 $ 0.189 $ 0,189 $ 0,189 $ 0.089 $ 0,089 $ 0,040 % Change from 01/01 Gallon Rate 12,0% 10,6% 10,5% 11,1% 10,5% 10,5% 6.8% 7,1% 4,0% 1 tii CSW:06I25104 I I I I I I 'II I Attachment #6 I I I I I I I I I I I Residential Rate History By Components Clearwater Gas System I I I Total Rate ComnnnenhlTherm Contract LP Month NGltherm LPlaallon ~CA EIA WNA PGA PGA PGAlnallon 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-01 $ 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-O 1 $ 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-O 1 $ 1,390 $ 1,445 $ 0,180 $ - $ - $ 0,630 $ 0,545 $ 0,580 Sep..01 3; 1,340 3; 1.433 $ 0,200 $ - $ - $ 0.560 1. 0,540 3; 0,550 FY Average $ 1.551 $ 1.649 $ 0.131 $ - $ - $ 0.840 $ 0.758 $ 0.829 2000 Avg. $ 1.222 $ 1.584 $ 0.103 $ 0.003 $ 0.010 $ 0.527 . $ 0.431 $ 0.779 Oct-01 $ 1,340 $ 1.380 $ 0,140 $ - $ - $ 0,620 $ 0,540 $ 0,550 NoY-Ol $ 1,340 $ 1,380 $ 0,140 $ - $ - $ 0,620 $ 0,540 $ 0,550 Dec-O 1 $ 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 Sep..02 ~ 1,360 $ 1,690 S 0,160 S - S 0,040 1. 0,580 ~ 0,500 S 0,690 FY Average 1.352 1.488 0.155 - 0.027 0.690 0.610 0.669 2001 Avg. $ 1.li4lI , 1.N6 $ 0.138 $ - $ - $ 0.831 '0.761 , 0.768 Oct-02 $ 1,300 $ 1,640 $ 0,100 $ - $ - $ 0,620 $ 0,550 $ 0,740 NoY-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 $ l,nO $ 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 Sep..03 s 1,560 $ 1,900 1. 0,160 ~ S - ~O,~O 1. 0,750 $ 0,940 FY Average 1.4n 1.817 0.138 - - D.768 0.683 0.878 2002 Avg. $ 1.342 1$ 1.653 , u.146 , - $ 0.027 , 0.6110 , 0.513 , 0.617 Oct-03 $ 1,530 $ 1,830 $ 0,100 $ - $ - $ 0,850 $ 0.780 $ 0,930 NoY-03 $ 1,530 $ 1,830 $ 0,100 $ - $ - $ 0,850 $ 0,780 $ 0,930 Dec-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 $ - $ . $ 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 S~04 FY Average 1.586 1.894 0.117 - - 0.889 0.819 0.977 2003 Avg. , 1.534 $ 1.864 I $ 0.138 1$ - 1$ - $ 0.8111 ~ 0.741 $ 0.926 Incr. Above $ 0.130 $ 0.090 $ (0.010) $ - $ - $ 0.140 $ 0.140 $ 0.100 Last Year Same Month 8% 6% -6% NA NA 17% 19% 11% Incr. Based $ 2.60 $ 1.97 on 20 Therms 7% 4.2% Equivalent CentsIKWH 5.8 7.4 for Gas ys. FPC Rate 8.9 8.9 (Residential) Gas Cheaper bv -35% -16%