Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2004
1 I CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet RECEIVED JAN . 2 2003 TO: FROM: _ COPIES: William B. Horne II, City Manager \ Chuck Warrington, Managing Director t/~ 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 OFFICIAL RECORD LEGISLATIVE SRVCSS::'~ SUBJECT: DATE: GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2004 December 30, 2003 Regrettably, world energy prices are on an upswing again, necessitating our request to increase our Natural and Propane (LP) Gas supply prices somewhat. We are recommending an increase of 4C/therm in our Natural Gas Purchased Gas Adjustments (PGA) and an increase in our LP PGA of 6C/gallon in January. We are also recommending a slight increase in our Energy Conservation Adjustment (ECA) of 2 C per therm and gallon in order to keep up with the continuing builders market. We are recommending that we continue to not collect any 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 rate of 6C/therm (up 3.9%) and an increase in our typical Residential lP rate of 8C/gallon (up 4.4%). The proposed NG therm rate is still 16% below the winter of 2001 when rates spiked historically, but the lP rate is about the same as this peak. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after January 1, 2004: Natural Gas Firm Standard Rate Schedule PGA ....... $0.890 per therm (up 4.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.820 per therm (up 4.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.990 per gallon (up 6.0C/gallon) = $1.082 per therm equivalent (up 6.5C/therm) Energy Conservation Adjustment (ECA) ............... $0.120 per therm (up 2.0C/therm) & $0.120 per gallon of LP (up 2.0C/gal.) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) and $0.000 per gallon of LP (no change) (f:) 21 /Oc;)'.. William B. Horne II, City ~nager Page 2 I December 3', 2003 Weather Normalization Adjustment (WNA) .......... $0.000 per therm (no change) & $0.000 per gallon of LP (no change) Attachment #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru November and projections thru the end of the fiscal year. These show that we are currently $3.1 Million behind on our collections and are attempting to recover about 75% 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 tvpical Residential customer rates are still 41 % lower than electric for Natural Gas and 23% lower for LP. This is based on the rate increase that Progress Energy just got approved from the Florida Public Service Commission for January, as they are experiencing similar fuel supply increases. It is our plan to use the above-proposed adjustments for billings through March 31, 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 January 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments /7~ {0- - Willr~~,.R.-H"6rne , City Manager ..."",.,'" ,......,o~- U:\My Documents\Word\GASRATES\FY 03-04\Gas Adjustments for January 2004odoc CLEARWA TER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Page 1 of 3 I . NA TURA~ GAS PURCHASED GAS ADJUSTMENT (PGA-NG) . . Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Raterrherm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) FirmlContr Prior Year . $(1,819,606,17) Oct-03 $ 1,529,299.48 $ 711,235,99 $ 9,098,03 $ 28,076,77 1 $ 2,277,710,27 $ 1,029,841,27 $(1,247,869,00) $(3,067,475,17) ,8501,780 Nov-03 $ 147,692,22 $ 737,964,17 $ 15,337,38 $ 25,048,97 $ 926,042,74 $ 1,074,868,29 $ 148,825,55 $(2,918,649,62) ,8501,780 Dec-03 $ 160,000,00 $ 1,200,000,00 $ 15,000,00 $ 30,000,00 $ 1,405,000,00 $ 1,529,580,00 $ 124,580,00 $(2,794,069,62) ,8501,780 Jan-04 $ 161,000,00 $ 1,400,000,00 $ 14,000,00 $ 30,000,00 $ 1,605,000,00 $ 1,881,080,00 $ 276,080,00 $(2,517,989,62) ,8901,820 Feb-04 $ 145,000,00 $ 1,400,000.00 $ 12,000,00 $ 30,000,00 $ 1,587,000,00 $ 1,827,985,00 $ 240,985,00 $(2,277,004,62) ,8901.820 Mar-04 $ 157,000,00 $ 1,300,000,00 $ 10,000,00 $ 30,000,00 $ 1,497,000,00 $ 1,714,210.00 $ 217,210.00 $(2,059,794,62) ,890/,820 Apr-04 $ 120,000,00 $ 1,000,000,00 $ 9,000,00 $ 30,000,00 $ 1,159,000,00 $ 1,509,415,00 $ 350,415,00 $(1,709,379,62) ,8901,820 May-04 $ 79,000,00 $ 850,000,00 $ 8,000,00 $ 30,000,00 $ 967,000,00 $ 1,243,940,00 $ 276,940,00 $(1,432,439,62) ,890/,820 Jun-Q4 $ 66,000,00 $ 750,000.00 $ 6,000,00 $ 30,000,00 $ 852,000,00 $ 1,168,090,00 $ 316,090,00 $(1,116,349,62) ,8901,8!\!"<< Jul-04 $ 68,000,00 $ 700,000,00 $ 4,000,00 $ 30,000,00 $ 802,000,00 $ 1,130,165,00 $ 328,165,00 $ (788,184,62) ,890/,820 Aug-04 $ 68,000,00 $ 700,000,00 $ 2,000,00 $ 30,000,00 $ 800,000,00 $ 1,137,750,00 $ 337,750,00 $ (450,434,62) ,8901,820 Sep-04 $ 70,000,00 $ 700,000,00 $ - $ 30,000,00 $ 800,000,00 $ 1,137,750.00 $ 337,750,00 $ (112,684,62) ,890/.820 Period 13 9 703,015,94 - $ (703,015,94) $ (815,700,56) Total YTD $ 2,770,991,70 $ 11,449,200,16 $104,435.41 $ 353,125.74 15,380,768,95 16,384,674.56 1,003,905,61 (1 ) Includes annual charge for Admin and CCS chg of $1 ,429,480 (9) - Transfer of ECA Collected in PGA ~ 1/2 of the ECA Rate (NG Proportion) (1 ) FY 02/03 WNA write off of $226,33, PGA of $16, 179,26 PROPANE ILPI GAS PURCHASED GAS ADJUSTMENT IPGA-LP) Monthly Cumulative LP PGA ------ Budget Gallons Monthly Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage ThennlGal. Month Sold --- WACOG Expense Charges Expenses Billed (Shortage) (Shortage) Prior Year $ (27,667,21) Oct-03 34,127,3 $ 0,64148 $ 138,34 $ 21,891,98 1 $ 130,840,31 $ 31,868,22 $ (98,972,09) $ (126,639,30) 1,017/,930 Nov-03 31,866,2 $ 0,65759 $ 633,20 $ 20,954,89 $ 21,588,09 $ 29,636,36 $ 8,048,27 $ (118,591.03) 1,017/.930 Dec-03 72,000,0 $ 0,68000 $ 600,00 $ 48,960.00 $ 49,560,00 $ 66,960,00 $ 17,400.00 $ (101,191.03) 1,017/,930 Jan-04 73,000,0 $ 0,80000 $ 600.00 $ 58,400,00 $ 59,000,00 $ 72,270,00 $ 13,270,00 $ (87,921,03) 1,082/.990 Feb-04 60,000,0 $ 0,75000 $ 600,00 $ 45,000,00 $ 45,600,00 $ 59,400,00 $ 13,800,00 $ (74,121,03) 1,082/,ggrr Mar-04 60,000,0 $ 0.75000 $ 600,00 $ 45,000,00 $ 45,600.00 $ 59,400,00 $ 13,800,00 $ (60,321,03) 1.082/,990 Apr-04 53,000,0 $ 0,75000 $ 600,00 $ 39,750,00 $ 40,350,00 $ 52,470,00 $ 12,120.00 $ (48,201,03) 1,082/,990 May-04 47,000,0 $ 0,75000 $ 600,00 $ 35,250,00 $ 35,850,00 $ 46,530,00 $ 10,680,00 $ (37,521,03) 1,082/,990 Jun-04 43,000,0 $ 0,75000 $ 600.00 $ 32,250,00 $ 32,850,00 $ 42,570,00 $ 9,720,00 $ (27,801,03) 1,082/.990 Jul-04 41,000,0 $ 0,75000 $ 600.00 $ 30,750,00 $ 31,350,00 $ 40,590,00 $ 9,240,00 $ (18,561,03) 1,082/,990 Aug-04 33,000,0 $ 0.75000 $ 600,00 $ 24,750.00 $ 25,350,00 $ 32,670,00 $ 7,320,00 $ (11,241,03) 1,082/.990 Sep-04 33,000,0 $ 0,75000 $ 600,00 $ 24,750,00 $ 25,350,00 $ 32,670.00 $ 7,320,00 $ (3,921,03) 1,082/,990 Period 13 9 $ 18,026,05 $ - $ (18,026,05 $ (21,947,08) T ota! YTD 580,993,5 $ 0,73616 $ 6,771,53 $ 427,706,87 # $ 561,314,45 $ 567,034,58 $ 5,720,13 Cost Center Expenses CCS Chg & Admin $ 92,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 PC Anywhere $ 159,00 1 Total $ 108,809,99 Attachment #1 I I Page 2 of 3 ENERGY CONSERVATION ADJUSTMENT tECA) , Monthly Cumulative - ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptional Items Expense - Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - Oct-03 $ 256,767,91 Promo$28,789,Adv $0, Employ Costs$62,117 $ - 1 $ 256,767,91 $ 60,398,24 $ (196,369,67) $ (196,369,67) ,100/,100 NoY-03 $ 69,454.73 Promo$19,911 ,Adv $1,620, Employ Costs$47,923 $ 981,85 $ 70,436,58 $ 62,044,66 $ (8,391.92) $ (204,761,59) ,100/.100 Dec-03 $ 125,000,00 $ 3,000.00 $ 128,000.00 $ 89,872,00 $ (38,128,00) $ (242,889,59) ,100/,100 Jan-04 $ 180,000,00 Includes $40K for Phillies $ 3,000.00 $ 183,000,00 $ 125,607,60 $ (57,392.40) $ (300,281,99) ,120/,120 Feb-04 $ 140,000,00 $ 3,000.00 $ 143,000,00 $ 121,524,00 $ (21,476,00) $ (321,757,99) ,120/,120 Mar-04 $ 140,000,00 $ 3,000,00 $ 143,000,00 $ 114,144.00 $ (28,856,00 $ (350,613.99) .120/,120 Apr-04 $ 140,000,00 $ 3,000.00 $ 143,000,00 $ 100,515.60 $ (42,484,40 $ (393,098.39) ,1201.120 May-04 $ 140,000,00 $ 3,000.00 $ 143,000,00 $ 83,000.40 $ (59,999,60) $ (453,097,99) .120/,120 Jun-04 $ 140,000,00 $ 3,000,00 $ 143,000,00 $ 77,883,60 $ (65,116,40) $ (518,214,39) .120/,120 Jul-04 $ 140,000,00 --- $ 3,000,00 $ 143,000,00 $ 75,325,20 $ (67,674,80) $ (585,889,19) ,120/,1>>- Aug-04 $ 140,000,00 $ 3,000,00 $ 143,000.00 $ 75,423,60 $ (67,576.40 $ (653,465,59) ,120/.120 Sep-04 $ 140,000,00 $ 3,000,00 $ 143,000,00 $ 75,423.60 $ (67,576.40 $ (721,041.99) ,1201,120 Period 13 9 721,041.99 $ 721,041.99 $ - Total YTD $ 1,751,222,64 $ 30,981,85 1,782,204.49 1,782,204.49 - (1) Includes annual charge for Admin and CCS chg of $163,020 + FY 02103 Write-off of $2,841,95 1(9) = Transfer of ECA Collected in PGA ~ ~ 1/2 of the ECA Rate (up to ECA Annual Shortfall) - - ENVIRONMENTAL IMPOSITION ADJUSTMENT tElA) Monthly Cumulative EIA BUdget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptional Items 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 NoY-03 $ 472,00 $ - $ 472.00 $ - $ (472,00 $ 161,573,17 .000/,000 Dec-03 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00 $ 151,573,17 .0001,000 Jan-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00) $ 141,573,17 .0001.000 Feb-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00) $ 131,573,17 ,OOO/,O~ Mar-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00) $ 121,573,17 ,000/,000 Apr-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00) $ 111,573,17 .0001.000 May-04 $ 10,000,00 $ - $ 10,000.00 $ - $ (10,000,00 $ 101,573,17 .000/,000 Jun-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00) $ 91,573.17 ,000/,000 Jul-04 $ 10,000,00 $ - $ 10,000.00 $ - $ (10,000,00) $ 81,573,17 ,000/,000 Aug-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00) $ 71,573,17 ,000/.000 Sep-04 $ 10,000,00 $ - $ 10,000,00 $ - $ (10,000,00) $ 61,573,17 ,000/,000 Period 13 $ - - $ - $ 61,573,17 Total YTD $ 114,775,84 $ - $ 114,775,84 $ - $ (114,775,84) -- (1 ) Includes annual charges 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 NGlTherm-Firm Month Expenses Billed (Shortage) (Shortage) LP/Gallon Prior Year $(1,670,924.37) Oet-03 1 $ 2,679,622,33 $ 1,122,107,73 $(1,557,514,60) $(3,228,438,97) ,950/1.03 Nov-03 $ 1,018,539.41 $ 1,166,549,31 $ 148,009,90 $(3,080,429,06) ,950/1,03 Dee-03 $ 1,592,560,00 $ 1,686,412,00 $ 93,852,00 $(2,986,577.06) ,950/1,03 Jan-04 $ 1,857,000,00 $ 2,078,957,60 $ 221,957,60 $(2,764,619.46) 1,010/1,110 Feb-04 $ 1,785,600,00 $ 2,008,909,00 $ 223,309,00 $(2,541,310.46) 1,010/1,110 Mar-04 $ 1,695,600,00 $ 1,887,754,00 $ 192,154,00 $(2,349,156.46) 1,010/1,110 Apr-04 $ 1,352,350,00 $ 1,662,400,60 $ 310,050,60 $(2,039,105.86) 1,010/1,110 May-04 $ 1,155,850.00 $ 1,373,470.40 $ 217,620.40 $(1,821,485.46) 1,010/1,110 Jun-04 $ 1,037,850,00 $ 1,288,543,60 $ 250,693,60 $(1,570,791.86) 1,010/1~ Jul-04 $ 986,350,00 $ 1,246,080,20 $ 259,730,20 $(1,311,061,66) 1,01011.110 Aug-04 $ 978,350.00 $ 1,245,843,60 $ 267,493,60 $(1,043,568,06) 1,010/1.110 Sep-04 $ 978,350,00 $ 1,245,843,60 $ 267,493,60 $ (776,074.46) 1,010/1.110 Period 13 $ 721,041,99 $ 721,041.99 $ - $ (776,074,46) Total YTD $ 17,839,063,72 $ 18,733,913,63 $ 894,849.91 (1 ) Includes Admin, & CCS Charges of $1,694,500 + Write-off Charges of $20,901,65 + Fuel of $15,000 + Other $159,00 - $1,730,560,65 Total .-- -. WEATHER NORMALIZATION fWNA) Monthly Cumulative WNA --=--0---- .-.--------- . Interest Overage YTD Overage NGlTherm Budget Month LP Gallons Expense Rate/Gallon NG Therms RatelTherm (ShortaQe) (Shortage) LP/Gal Beg, Ba!. $ - Oet-03 . 34,127,3 $ $ 1 1,429,952,1 $ $ ,000/,000 - - - - - Nov-03 31,866,2 $ - $ - 1,484,615,3 - $ - $ - ,000/,000 Dee-03 72,000,0 $ - $ - 2,120,000,0 - $ - $ - ,000/,000 Jan-04 73,000,0 $ - $ - 2,480,000,0 - $ - $ - ,OOO/,(ijioIc Feb-04 60,000,0 $ - $ - 2,410,000,0 - $ - $ - ,000/,000 Mar-04 60,000,0 $ - $ - 2,260,000,0 - $ - $ - ,000/,000 Apr-04 53,000,0 $ - $ - 1,990,000,0 - $ - $ - ,000/.000 May-04 47,000,0 $ - $ - 1,640,000,0 - $ - $ - ,000/,000 Jun-04 43,000,0 $ - $ - 1,540,000,0 - $ - $ - .000/,000 Jul-04 41,000,0 $ - $ - 1,490,000,0 - $ - $ - ,000/,000 Aug-04 33,000,0 $ - $ - 1,500,000,0 - $ - $ - ,000/,000 Sep-04 33,000,0 $ - $ - 1,500,000,0 - $ - $ - ,000/,000 Period 13 $ - Total YTO 580,993,5 - - 21,844,567.4 $ - $ - U:\My Ooeuments\EXCEL\GASRATES\FY 03-04\[Adjustment Clause Recovery for FY 03-04,xls]Nov Recovery CSW:Updated 12/29/03 /iTTlI-c/J171e"Jr -If L CGS Natural Gas Cost as of 12/18/2003 Actual/Projections FY04 Contract Capacity Contract Excess Capacity Relinquishment Purchased Sold Gas Sold Gas Purchased % Sold Gas WACOG FTS-1 FTS-2 No~Notice Caoacitv Volume Cost Gas Actual Proiected Gas lost vs, Proiected Purchased 170,438 41,7BB 15,500 56,435 (29,097) $ 11,B61,B2 155,791 142,995 146,000 4.70% 97.9% $ 5,3B 306,570 53,430 22,500 lB7,B23 160,B55 $ -(7,231,12 172,177 148.462 170,000 $ 5,9B 316.789 55,211 31,000 124,000 115,000\ $ (1,50000) 248,000 202,000 $ 6,57 3Hi.7B~) 55.2'11 46,500 131,000 15,0001 $ (1,500,00) 241,000 248,000 $ 6.72 286,132 ~1,B.R68 42,000 110,000 (15,000 $ /1,500,00 226,000 241,000 $ 6,55 316,789 :15]11 ~~ 1,000 173,000 (30,000) $ 14,500,00) 199,000 226,000 $ 6,47 2.16.570 b3,4:30 22,500 106,000 120,000) $ /3,000,00 164,000 199,000 $ 5.99 144,212 41.ralJ 12.400 32,000 (15,500' $ 17.750,00 154.000 164,000 $ 5,59 139,~i60 4(),~40 10.500 31,000 '36 000) $ 18,000,00 149,000 154,000 $ 5.35 144,212 < 1.781l 10,D50 36,000 37,200 $ (18,60000 150,000 149 000 $ 4.98 144.212 41.1813 10.BGO 36,000 37,200 $ 18,60000 150,000 150,000 $ 4,82 '1;:i9,GGO 40,440 10.500 34,000 27,(00) $ 113,500,001 146,000 150,000 $ 5,20 Oct-03 Nov-03 Dec-O~:t Jan~04 Feb-04 rvlar-04 l\pr-04 MsV..04 .Jun-()4 .JUI-O/, J\uq-04 Sop,IH Total 2,641,B33 570,393 266,100 1,057,25B (337,B52) ($107,542,94) 2,154,96B 291,457 2,199,000 4,70% $ O,9B $5,92 Reservation charges FTS-1 FTS-1 FTS-2 FGU Load Load Total FTS-1 FTS-2 N04Notice charges Usage Charge US(~~:~h~l~ge Total Monthly Fuel Cost Management fee Factor Factor Billing (ohase 11\ (ohase 111\ NNTS Ihhase 11\- Commoditv charnes Ad'ustments (Fuel Relention' Per Month wI Relinnuish wlo Relinauish IFGl1\ $ 63,113,19 $ 31.237,2B $ 914,50 $ 5,6B4,90 $ 524,5B $ 754,422,43 $ 136,91 $ 20,962,62 $ 7,991,57 85,1% 73.4% $837,B36,32 $ 113,522,B7 $ 39,906,17 $ 1,327,50 $ 6,455,42 $ 393,79 $ B81,641,07 $ 1,292,97 $ 24,093,22 $ 10,369,76 57,6% 47.8% $1,029,333,29 $ 117,.197.fH $ ,12,181.20 $ 1,iJ?900 $ 13,154,97 $ 1 396.134 $ 1,470,243,19 $ $ 41,274.42 $ 14,88000 69.5% 66.7% $1,630,250.43 $ 11"(.49"1.04 ~ 42,181,20 ~ 2:14350 $ '1,858137 $ 1,396,134 $ 1,458,584,45 $ $ 40.930.00 $ 14.460.00 67.5% 64,(.I'~'o $1,619,506,19 S 1U{j.12EJ.3G S 38,009, b $ 2,47800 $ '1,45038 $ 1,261,66 $ 1,335,472,07 $ $ 37,450.27 $ 13,560,00 70.4% 67.3%1 $1,480,675,59 ,- 117.'1~)7.0;1 S ,IL,181.20 $ '1.820.00 $ 6.082.27 .' 1,396,84 < '1.130,814.74 $ $ 31,678.66 $ 11,940.00 58.2% 53.5% $1,287,82198 , . S 30,3:?5.R 1 S '10,820.52 S 1,327.:10 ~: 4,67711 $ 1.351.78 $ 1362,295.18 $ $ 25,280,29 $ 9,84000 65.6% 60.7'% $981.76901 $ 53,4/38.23 ,- 31 ,g:~f.j.O~~ $ i:l160 $ 4.746,57 $ 1,057.24 $ 781,808.44 $ $ 22.890,44 $ 9,240,011 90.3,};) 82.8% $aSO,2114,31 ~ $ ~J'l. 702.80 :1 30,8D6,16 $ G19.S0 $ 4,592,09 $ '1.023,13 $ '132,218.62 $ $ 21.417.40 $ 8,940,00 103.5% 82.B% $797,497.09 S 53, :1B8.23 $ :J 1,92803 $ 640.15 $ 4,577.37 $ 1,057.24 $ 678,638,21 $ $ 19,837,61 $ 8,000,00 100.8% 80.fl% $747,092,03 $ 53,48~'~.~:i $ 31,92G.03 $ 64CJ.15 $ 4.577.:)7 $ 1,057.24 S 656,11656 $ $ 19,131,90 $ 9,000,00 100.8'% 78.5%.. S723,570.98 $ j1.7(j;?,80 $ 30,1196.16 $ G19.50 $ 4,634,39 $ 1,023.13 $ 689,,>41,54 $ $ 20,134,02 $ 9,00000 95.4% O,Ol}i, $759.320.00 Oct-03 Nov.03 Oec-03 Jan-04 r:eb-Q.+ rv'i;;;r-04 Apr.04 FvL'W-.04 Jun-O<1 Ju!-O,,1 t\ljq-W~ 5ep-04 Total $979,569,65 $434,177.15 $15,699,90 $69,491,72 $12,940,30 $11.432,796,51 $ 1,429,8B $325,080,91 $12B,221,33 80.4% 63,2% $12,754,B77.81 Total Projected DTH WACOG Total Reservation Total Commodit Cost Purchased 1st 6 Months $B54,245,B5 $ 7,031,177,95 $7,885,423,BO 1.241,96B $6,349 2nd 6 Months $467,B35.45 4,401,61B,56 $4,B69,454,Ol 913,000 $5,333 TOTAL $1,322,OB1,30 11,432,796,51 $12,754,877,B1 2,154,96B $5,92 Budget 2078 9,8911,1100,00 PO amount 2,864,877.81 over budget 1,924,160 Other PGA costs -- - I .4 T Ir I) ci-tI}H~~t0T-tF.3 comoanv/ Gallons Propane Propane Shipping Total FYTD Cost of Tank Tank WACOG Date Invoice # Delivered Rate Cost Cost Cost Gallons Inventorv Inventorv Withdrawl I I 09/30/02 $ 29,135,22 44,337 0,65713 I 10/15/03 Sea-3 T 4003-0747 38,223 0,62972 $ 23,303.42 $ 766.18 $ 24,069.60 38,223,0 $ 53,204,82 82,560 0,64444 10/31/03 invadiustment 381 - $ $ 38,2230 $ 53,204,82 82,941 0,64148 10/31/03 End of month '.,' .' :"F' :'~.'" -, ~<-'r , $ 29,273,21 45,634 37,307 0.64148 11/06/03 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/18/03 Suburban 450386 2,400 0.72600 $ 1,742.40 N/A $ 1,742.40 42,869,7 $ 32,595.04 50,281 0,64826 11/20/03 Sea-3 4003-0835 38,628 0.66641 $ 24,967,98 $ 774.29 $ 25,742,27 81,497,7 $ 58,337.31 88,909 0,65615 11/20/03 Sea-3 4003-0855 9,600 0,66641 $ 6,205,15 $ 192,43 $ 6,397,58 91,097.7 $ 64,734,89 98,509 0,65715 11/30/03 invadiustment 60 1,38533 ""$ $ 83.12 91,097,7 $ 64,818,01 98,569 0,65759 11/30/03 End of month ...,..i"'-:'... :'Li.. $ 39,419,17 59,945 38,624 0,65759 FYTD 10tals 91,098 0,65440 $ 57,798,38 $ 1 732,90 $ 59,614,40 p..... O,~ U..:t:~ S ..{;.,,, ."",- C> ~)(- L /' 5.jd"~ I : ~ ]) Gc- t.f 1-/ rJI"""'- ..J ~ [j a q.. / ?~d/~ ~h 7; tj- /~JIVy,. CSW: 12/30/03 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel EnerQV CharQelTherm 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 01101 Therm Rate % Change from 01/01 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/01/73 Non-Utility Taxable FuellTherm ~ NA(1 - 3 Units) $7,00 $0,580 0,120 ~ MMF NA(4+ Units) $15,00 $0,580 0,120 NA(4+ Units) $20,00 $0,580 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JANUARY 1, 2004 - MARCH 31, 2004 BASED ON APPROVED GAS ADJUSTMENT FACTORS ~ NA(4+ Units) $50,00 $0,580 0,120 0,120 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 $0,700 $0,700 $0,700 $0,700 $1,590 0,890 0,890 0,890 0,890 $1,590 $7,00 $1,590 $15,00 $1,590 $20,00 $50,00 Firm Natural Gas Rate Schedules SGS MGS ~ RAC ~ o - 18,000- 17,999 99,999 $15,00 $20,00 100,000 & up $50,00 $0,350 0,120 0,000 0,000 $0.4 70 0,890 $1,360 $50,00 NA (1 - NA (0 - 3 Units) 149 tons) $7,00 if $15,00 if not prey, not prey, billed billed $0,200 $0,150 ~ NA(150 tons & +) $20,00 if not prey, billed $0,100 0,120 $15,00 $0,200 ~ SL w/M& ReliQht NA NA NGV NA $30,00 $0,470 0,000 0,000 0,000 0,000 0,000 $15,00 $7 Resl.! $15 GS if not prey, billed $0,300 $0,100 0,120 0,120 0,120 0,000 0,000 0,000 0,000 0,000 $0,220 $0,320 $0,420 $0,220 $0,590 $1,110 0,890 0,890 0,890 0,890 0,890 $1.480 $1,100 0,820 $7,00 @ $15,00 @ $20,00 @ premise premise premise $1,210 $15,00 +FAC $1,310 $1,110 $15,00 $7 Resl./ + FAC $15 GS@ premise + FAC Interr. NG Rate ~ ----1L NA 100,000 & up $100,00 $0,280 0,120 NA NA 0,000 $0,280 $30,00 $100,00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo, $0,069 $0,821 $ 1,455 $ 1.455 $ 1.455 $ 1,455 $ 1,354 $ 1,299 $ 1,244 $ 1,107 $ 1,061 $ 1,016 $ 1,107 $ 1,199 $ 1,016 $ 1,354 $ 1,007 $ 1,542 $ 1,542 $ 1,542 $ 1,542 $ 1,435 $ 1,377 $ 1,319 $ 1,174 $ 1,125 $ 1.077 $ 1,174 $ 1,271 $ 1,077 $ 1,435 $ 1,067 11/03 1,061 1,040 12/03 1,060 1,039 $0,069 $0,069 $0,069 $0,069 $0,821 $0,821 $0,821 $0,821 01/04 1,053 1,033 $0,470 $0,410 0,120 0,120 0,120 0,120 $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,300) $ (0,290) -15,9% -15,9% -15,9% -15,9% -16,9% -17,4% -18,1% -19,9% -20,5% -21,3% -19,9% -18,6% -21,3% -16,9% -20,9% BTU FACTOR = THERMS/100 CUBIC FEET rCCF) Firm Service Rates Interruptible Service Rates 10/03 1,066 1,045 0,000 0,000 0,000 0,000 $0,590 $0,530 0,890 0,890 $1,480 $1,420 $15,00 $20,00 $0,069 $0,069 $0,821 $0,821 02/04 03/04 $0,069 $0,821 04/04 0,000 0,000 0,000 0,000 $0,320 $0,270 0,890 0,890 $1,210 $1,160 $0,069 $0,069 $0,821 $0,821 05/04 06/04 $0,069 $0,821 07/04 $0,069 $0,821 08/04 $0,069 $0,069 $0,821 $0,821 09/04 $0,055 $0,765 Attachment #4 Contract NG Rate ~ NA By Contract - By Contract NA NA 0,000 Contract + $0,000 Plus 0,820 $0,820 + Non-Fuel Customer Charge + Non-Fuel T Rate for Cc # of Therm - $ (0,290) -26,1% $0,069 $0,751 CSW: 12/30/03 Attachment #5 Page 1 of2 BTU Factor: 2,714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0,915 Therms/Gallon FOR JANUARY 1, 2004 . MARCH 31, 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 EnerQY Charaes/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,120 0,120 0,120 0.120 0.120 0,120 0,120 NA Environm'llmposition Adj, /Gallon 0.000 0,000 0,000 0,000 0,000 0,000 0,000 NA Weather Normalization Adj.lGallon 0,000 0,000 0.000 0,000 0,000 0,000 0,000 0,000 Total Non-Fuel Charges/Gallon $1,720 $1.720 $0,920 $0,320 $0,270 $0,220 $0,510 By Contract + $0,000 Purchased Gas AdjustmenUGallon 0,990 0,990 0,990 0,990 0,990 ~ 0,990 0,990 Total Energy Charges/Gallon $2,710 $2,710 $1,910 $1,310 $1,260 $1,210 $1,500 $0,990 + 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 Chg, + Any Applicable for the Contracted Facility Charges # of Gallons/Mo, Utility Tax Note: Fuel Rate per Therm 10/01173 0,161 0,161 0,161 0,161 0,161 0,161 0,161 0,161 Non-Utility Taxable FuelfTherm $0,829 $0,829 $0,829 $0,829 $0,829 $0,829 $0,829 $0,829 Change from 01/01 Gallon Rate $ 0,209 $ 0,209 NA $ 0,009 $ 0,009 $ 0,009 $ 0,009 $ (0,010) % Change from 01/01 Gallon Rate 8.4% 8.4% NA 0,7% 0,7% 0,7% 0,6% -1,0% ,. .. CSW: 12/30/03 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 JANUARY 1, 2004 - MARCH 31, 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 ill 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'!. 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,120 0,120 0,120 0,120 0.120 0,120 0.120 0,120 NA Environm'/Imposition Adj.lGallon - - - - - - - - NA Weather Normalization Adj.lGallon - - - - - - - - 0,000 Total Non-Fuel Charges/Gallon $ 1.620 $ 1.420 $ 0.920 $ 0.820 $ 0.920 $ 0.820 $ 0.320 $ 0.270 Set By Contract + 0.000 - Purchased Gas Adjustment/Gallon 0,990 0,990 0,990 0,990 0,990 0,990 0,990 0,990 0,990 Total Energy Charges/Gallon $ 2.610 $ 2.410 $ 1.910 $ 1.810 $ 1.910 $ 1.810 $ 1.310 $ 1.260 0.990 + Contract NFE Note: No Monthly Minimum Bill UtilitvTax 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 0,829 0,829 0,829 0,829 0,829 0,829 0,829 0,829 0,829 Change from 01/01 Gallon Rate $ 0,209 $ 0,159 $ 0,109 $ 0,109 $ 0,109 $ 0,109 $ 0.009 $ 0,009 $ (0,010) % Change from 01/01 Gallon Rate 8,7% 7,1% 6,1% 6.4% 6,1% 6,1% 0,7% 0,7% -1,0% ~ I CSW: 12/30/03 1 .-- 1 T T Attachment #6 I I I T I T T r Residential Rate History By Components Clearwater Gas System I I I Total Rate ComnonentslThenn Contract LP Month NG/therm LP/aallon ECA EIA WNA PGA PGA PGAlnallon Oel-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-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-O 1 $ 1,390 $ 1.445 $ 0,180 $ - $ - $ 0,630 $ 0,545 $ 0,580 Sep-O 1 ' !I: 1,340 ~ 1.433 T 0,200 'I: - I - $ 0,560 $ 0,540 $ 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 Nov-01 $ 1,340 $ 1,380 $ 0,140 $ - $ - $ 0,620 $ 0,540 $ 0,550 Dee-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 Seo-02 ~ 1,360 !I: 1,690 $ 0,160 S- - $ 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 Ava. $ 1.549 $ 1.586 $ 0.138 $ - $ - T 0.831 $ 0.751 $ 0.758 Oel-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 Dee-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 Mav: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 Seo:o3 $ 1,560 S 1,900 T 0,160 ~ - $- - $- 0,820 T 0,750 S 0,940 FY Average 1.477 1.817 0.138 - - 0.758 0.683 0.878 2002 Ava. $ 1.342 $ 1.553 $ 0.145 $ - $ 0.027 $ 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 F eb-04 Mar-04 Apr-04 Mav-04 Jun-04 Jul-04 Aug-04 S~04 FY Averaae 1.545 1.850 0.105 - - 0.860 0.790 0.945 2002 Avg. Incr. Above $ 0.170 $ 0.140 $ - $ - $ - $ 0.170 $ 0.170 $ 0.140 Last Year Same Month 12% 8% 0% NA NA 24% 26% 16% Incr, Based $ 7.65 $ 6.89 r on 45 Therms 11% 7% , Equivalent Cents/KWH 5.2 6.8 for Gas vs. FPC Rate 8.9 8.9 (Residential! Gas Cheaper iW -41% -23%