Loading...
GAS ADJUSTMENTS EFFECTIVE JULY 1, 2001 ) I CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet RECErVED JUN 2 5 2001 TO: FROM: William B. Horne II, Interim City Manager \ Chuck Warrington, Managing Director, SBS DJ)NJ CITY CLERK DEPARTMENT COPIES: Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE JULY 1, 2001 DATE: June 25, 2001 Natural and Propane (LP) Gas supply prices have continued to fall, despite the fact that they remain at historic high seasonal levels. Most forecasters see them falling a little more into summer, but remaining at nearly double the historic rates for the next few years. Therefore, we are recommendina an additional 13% reduction in our Natural Gas Purchased Gas Adjustment (PGA) and an additional 11 % reduction in our Propane (LP) PGA in July. We believe that we are at about the bottom of the fuel cost curve for the summer. We are recommending a decrease in our Natural Gas PGA of 10.0C per therm and a decrease in our LP PGA of 8.0C per gallon. We are also recommending an increase in our Energy Conservation Adjustment of 2.0C per thermo We are not recommending changes to any of our other Adjustment clauses at this time. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after June 1, 2001: Natural Gas Firm Standard Rate Schedule PGA ....... $0.680 per therm (down 10.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.595 per therm (down 10.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.670 per gallon (down 8.0C/gallon) = $0.732 per therm equivalent (down 8.8C/therm) Energy Conservation Adjustment (ECA) ............... $0.160 per therm (up 2.0C/therm) = $0.146 per gallon of LP (up 1.8C/gallon) $0.000 per therm (no change) =$0.000 per gallon of LP (no change) $0.000 per therm (no change) $0.000 per gallon of LP (no change) Environmental Imposition Adjustment (EIA) ......... Weather Normalization Adjustment (WNA) .......... 2/-/0:2 '0,::/ G ~) . William B. Horne II, Interirrlcity Manager Page 2 I June 25, 2001 Attachments #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru May and projections for the remainder of the fiscal year. These show that 0 ur Natural Gas PGA is positive by over $260,000. You will also note that our overall shortfall for all Adjustment Clauses is currently about ($180,000), and we are projecting overcoming this in total by the end of June. This is important to our overall financials, as this has negatively impacted us FYTD. Thus, it is important that we recover this deficit by fiscal year end. 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. I should point out that the overall impact of this on our Residential customers is a 25% reduction from our peak winter rates (20% lower for LP), but this is still an 11 % increase in their therm rate above last July for natural gas (4% lower for LP). This means that our average customer will likely pay an overall bill of $3.63/month higher this year ($1.94 lower for LP) based on 25 therms/month, which is our average monthly residential customer consumption. Most all of this is as a result of the nearly 100% increase in fuel supply costs that we and the nation are experiencing. It should be noted that we pass our gas supply costs directly along to our customers with no mark-up. It is our plan to use the above-proposed adjustments for billings through September 30, 2001, unless there is a significant change in our forecasts or we project an over/under recovery in excess of the thresholds as prescribed in our rate ordinance. 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 that 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 Attachments Approved: dJ~':i. Ak!4.a-"1I" William B. Horne II, Interim City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for July 2001.doc CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS - IT---~-~'- i NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA.NG) ! -------T-~-- f3Udget t- Rese-n,ation t-------n ~-- Commodity -I~ Interest ! Cost Center (2) Month -t~chargeS---t----- . Charges I Expense lExpenses 'PriorYea~-----+-- . --r-- Oct-OO I $ -834,888.83 $~------ . 673,430.371 $ 758.54 $ 14,229.04 (1) - Nov=OO 1$ 151,759.51 $--~---~---------'-~- 815,334.89 ' $ 4,841.87 $ 12,133.08 I-- Dec-OO 1$ 160,913:04 $--------~.--- 1,274,692.54 $ 5,488.72 $ 15,526.84 I I-------'--C~_---=-_ ______.__~ Jan-01 $ 160,406.07 $ 2,153,259.49 $ 6,222.23 $ 15,767.57 Feb-01 $ 145,835.14 $---------- 2,128,738.39 $ 4,777.59 $ 20,324.55 -.. ".."------ Mar-01 $ 158,346.66 $ 1,290,216.23 $ 4,084.52 $ 34,890.00 --------.----------- Apr-01 $ 151,668.91 $ 910,013.55 $ 2,474.77 $ 16,772.27 May-01 $ 70,055.61 $ _____ 918,278.97 $ - $ 22,038.49 Jun-01 $ 60,000.00 $ 700,000.00 $ - I $ 25,000.00 JU@1;,:Di,$"so,PO().<>Pl<; ...,.... . '._.0 .;~.7~;999.:qQ;'$ ':;, '1';W~~.~I~g:< Aug-01 I $ 60,000.00 1$-_______675,000.001 $ _ - $ 25,000.00 Sep-01 I $ 70,000.00 I $ 700,000.00 $ - $ 25,000.00 ~~;D ~'083'873.*==-=-- =---------------12,913,96~~43 ! $ 28,648.25 $ 251,681.84 --- -(11 1nciudes annual chargeforAdmin -and CCS chgof $7f7;520 --- - - (2) Cost Center Expenses incl. 100% of Langille's & 9% of Warrington's I ~onth__ _~~ ______. ._. ____ WACOG ~ Expense I Charges Prior Year , Oct-OO 29,981.51 $-~------ 0.74032 ' $ 42.55 '$ 22,195.90 Nov-OO, 26,242.3 I $ 0.74479 $ 151.63 $ 19,545.00 o-ec=OO-:+f=' 63,591.01 $_ 0.76062 $ 142.25 $ 48,368.59 Jan-01 58,901.0 $ 0.88607 $ 114.79 $ 52,190.41 ..-- Feb-01 f-- 54,493.2 $ 0.84295 $ 96.78 $ 45,935.04 Mar-01, 44,779.5 $ 0.75200 $ 41.03 $ 33,674.18 Apr-01! 39,104.6 $ 0.74405 $ - $ 29,095.78 ~=01i~612.5 i{- 0.68094 I $ - $ 31,740.32 ~-01....J............ .~~'P.PO"O..I,$.g..?~OOOJ ..$ - .,1..$ 31,200.00 "Iul-01 I 44.f)QO,0.$ .,.....".. ",..,.,..... ...9.~~p.Q;.~......;............,,..;,;$.;;~I\I~9il~'.;y, ~~~~~~ :~:~~~! ~~::~~~~ K-- . ~ 'T: ... ~~::~~:~~ Total YTD 537,705.6 $- 0.73227 ~589.03 , 393,745.22 Cost Center Expenses I ~-- i 1--_ I ___~~S Chg Adj at per 5 fm 6,100 __ .. ____1____ Software support 1140 (12x95) -~t-----*~~~~f~~i~:ru~------ $ $ 1$ 1$ 9,000.00 (1) 1,140.00 (1) 10,000.00 I (1) I 1,004.84 rTf)l age I Attachment #1 I i Paqe 1 of 3 I i I . ~===~~~nthly--t- cumul::T:G-;GA -- Total NG PGA __ .. Overage YTD Overage i Rate/The!_'!1.. Billed __ _J.~,!ortage) (Shortage) l~m/Contr_ ______ $ (151,708.91)1 706,640.96 $ (816,665.82) $ (968,374.73)! .6001.510 854,699.34 $ (129,370.01) $ (1 ,097,744.75i! .6301.537 1,309,920.12 $ (146,701.02) $(1,244,445.77) .7401.650 2,624,583.77 $ 288,928.41 $ (955,517.36) 1.200/1.110 2,438,289.22 $ 138,613.55 $ (816,903.81) 1.200/1.110 1,809,487.89 I $ 321,950.48 $ (494,953.33) 1.200/1.110 1,657,081.16 $ 576,151.66 $ 81,198.33 .980/.895 1,189,850.14 $ 179,477.07 $ 260,675.40 I .880~ 1~g;:?:.~~~i,~~.,...,..~6~.,?60.:pO .,.....,~._...~~,~:,~,~~;~"p..I............r~.~~:~.?~,..... .. ':;~iR~iliiitj~j;;1;I!lji;:t;i'j8~9::gg;;:?~;V;:F!liliiiflBijf;t'11I11J!i~;JC 880,600.00 $ 120,600.00 i $ 766,635.40 I .6801.595 880,600.00 $ 85,600.00 I $ 852,235.40 .6801.595 $ - I $ 852,235.40 I _~ $ 16,282,112_60 $ 1,003,944~__ F--~==- ... =h -I-~==-= --------+-----r-~--- ----+ Monthly I Cumulative i LP PGA Overage r YTO Overage Therm/Gal. - (Shortage) i (Shortage) $ (8,509.46) $ (21,817.47) $ (30,326.93) $ 1,877.84 $ (28,449.09) $ 5,491.04 $ (22,958.05) $ 3,602.91 $ (19,355.14) $ 11,148.27 $ (8,206.87) $ 15,465.50 $ 7,258.62 $ 8,821.75 1$ 16,080.38 $ 7,612.22 I $ 23,692.60 $ ;4,8PP'~'~:i'I.~i"':.: .:~:~:.~9,:~.~O)r) H$lh~~9.tj;r'lll' · '~~\1f'''j'Rll.\ii;!:; $ 1 ,680.00 I $ 31,432.60 'r $ 1 ,680:o6T $ 33,112.60 $ 41,622.06 I ! Total NG Fuel Expenses $ - $ 1,523,306.78 $ $ 984,069.35 $ $ 1,456,621.14 $ $ 2,335,655.36 $ $ 2,299,675.67 $ $ 1,487,537.41 $ $ 1,080,929.50 $ $ 1,010,373.07 $ $ 785,000.00 $ ::';'3;:,'. ..;'.'{~~9~911111pj::.~fi' $ 760,000.00 $ $ 795,000.00 $ $ - $ 15,278,168.29 , =f ---+ Total LP Fuel Expenses (1) $ $ 1$ $ $ $ $ $ $ i~.*N $ $ $ 45,323.29 $ 19,696.63 $ 48,510.84 $ 52,305.20 $ 46,031.82 $ 33,715.21 $ 29,095.78 $ 31,740.32 $ 31,200.00 $ ..,~~i~~~~gli1lr~'i:ii;::.. 26,460.00 $ 26,460.00 $ 417,419.09 $ Total LP PGA Billed 23,505.82 21,574.47 54,001.88 55,908.11 57,180.09 49,180.71 37,917.53 39,352.54 36,000.00 .~~~~:,~:~~ 28,140.00 28,140.00 459,041.15 .874/.800__ .929L8.5Q - .9291.850 1.093/1.000 1.202/1.100 1.202/1.100 .9731.890 .885/.810 .8201.750 ::lt~~;~'(J .732/.670 .732/.670 Analog phone line for software I $ Suburban maint agmt ----__LL LP Truck Lettering 1 I $ Total I ! $ 300.00 1(1) 1,140.00 1(1) 500.00 1(1) 23,084.84 I -~ U :lwindowslmsofficelexcellgasf20( sheet recovery) =---==--~=-~ -===-=i=-=-====----=__ -"------j =--:-+! i . ~I ,Atla::.':;e,"~~: ENERGY CONSERVATION1ADJUSTMENT IECA! ______=--=-1 __ ' _ 1----- ------i t I --- 1---- ! Monthly-- Cumulative I ECA BUdget-host Cente;:- +-~-:---------- -- -- ---------Interest--+__=_ --~tal ECA Total ECAT- Overage - YTD OveraQe1 NGlTherm-- Month Expenses Notes/Exceptionalltems (3) EXpen!!...__~ J__Expenses Billed ____I (Shortage) I (Shortage) (2)-T-- LP/Gal._-= Prior Year} unadjusted I $ ~ $ _ I $ (727,253.37) Oct-OO -, $ 471,136.93 Pro;;:;;$7,425,Advetising$1~200EmploYCostS$17,43393 ---$- 3,636.27 - (1)' $ 474,773.20 $ 68,477.76 i $ .1406,295.44) $(1,133,548.81) .1101.101- Nov-OO $ 17,475.08 Promo$6,407,Advetising$750Employ Costs$15,240.88 $ 5,667.74 $ 23,142.82 $ 79,861.41 U 56,718.59 $ (1 ,076,830.22) I .1101.101 Dec-OO 1 $ 84,846.24 Promo$75,339.72 & Balance Empl. Costs 1$ 5,384.15 $ 90,230.39 $ 112,136.94 $ 21,906.55 $(1,054,923.67) .1101.101 Jan-01 l_L 36,334.34 Promo$24,884.19 & Balance Empl. Costs $ 5,274.62 ' _ $ 41,608.96 $ 158,201.38 $ 116,592.42 $ (938,331.25) _1101.101 Feb-01 LL 48,825.84 Promo$38,727.43 & Balance Empl. Costs $ 4,691.66 $ 53,517.50 $ 135,968.60 $ 82,451.10 $ (855,880.15) .1101.101 Mar-01-1!.__29,023~ Promo$14,119.77 & Balance Empl. Costs $ 4,279.40 $ 33,302.56 $ 94,773.90 $ 61,471.34 $ (794,408.81) .1101.101 Apr-01 1$ 54,061.64 Promo$15,873.95 & Balance Empl. Costs $ 3,972.04 $ 58,033.68 $ 104,501.27 $ 46,467.59 $ (747,941.22) .1101.101 May-01: $ 68,313.89 Promo$54,461.86 & Balance Empl. Costs $ 3,739.71 $ 72,053.60 $ 88,443.95 $ 16,390.35 $ (731,550.87) .120,:-~ Jun~01 i.... $...,. 50,000.00, $ 3,700.00 $ 53,700.00 $ 99,719.42 $ 46,019.42 $ (685,531.44) .1401.128 J!JI:,q1"~. ...-.?O,OO(),qo . .. .'/'; .' .. ......_",y , Aug-01] $ 50,000.00! Sep-011 $ 50,000.00 r-__________ Total YTD ! $1,010,017.12 r _______ ~"! L_______ (1) 'Includes annual charges for Admin & CCS of $450,000 (2) I Prior Year Cummulative balance adjusted by $308,286 for FY 99/00 Sales Cost 4====- I-- 1$124,712 Conversion Cost losses = $432,998 Total ~-=-- ---t~ ENVIRONMENTAL IM~ON ADJUSTMENT (EIAl---- _=+-- ----=+-- i ! I-----~----t._------------ Budget , Cost Center I Month i_Expenses -iNOtes7Excepti~niITitems- Prior Year i i Oct-OO I $ 60,192.83 Nov-OO : $ 933.74 Dee-OO i $ 483.90 Jan-01 1$----467:001 Feb-01 I $ 4,472.951--~------ Mar-011 i- $ - 15,536.80 lErivironmental Consultant Apr-01 ,$ 3,704.92 I May-01 I $ - ~ -- . J.~~.:g1.;...._I,.~......,2,~OO'.0_9;1. ."...,;JtlHM;,....$. ..- 4.1500.00 _ .".'. ..._,--'---, Aug-01 i $ 2,500.00 : Sep-01 j $ 2,500.00 r- Sep-OO L i-- Total YTD I $ --95,792. 14i= ! (1) i Includes annual admin & CCS charges of $60,000 :-=-=i~==-~=------ ------ -t $ 3,300.00 $ 3,100.00 $ 50,245.59 $ 53,300.00 $ $ 53,100.00 $ $ 1,060,262.71 $ 110,471.42 $ 57,171.42 $ (571,388.59) 110,471.42 $ 57,371.42 $ (514,017.17) 1,273,498.91 $ 213,236.20 .1601.146 .1601.146 J. c-- (3) Employee Costs includes 100% of McCulley's payroll & benefits - Approx. $65K annually. -~ -- .-- Interest __ Expense ,'::'c,_,;:; _::-{)~>h;; y.~,:;,~ $ $ $ $ $ $ $ $ $ ;$\' 'ft.- - $ (1) $ --~- $ $ $ 1$ 1$ $ .-..;......,j,;~;.l;l~i~I!!!ll.;f.l!. $ $ $ -- ):-:tklr;>/S'::\ ;:--;?EPfifLNit)" -I r-- $ age --f-----------.------- Total EIA Expenses 60,192.83 $ 933.74 $ 483.90 $ 467.00 $ 4,472.95 $ 15,536.80 $ 3,704.92 $ - $ 2,500.00 $ i~IP9;~9N;Ij~::.ii,1 2,500.00 $ 2,500.00 $ 95,792.14 $ :-;)j>~,r.:( :-:-W>}F7 I I Moothly - Como'ame I Overage YTD Overage I (Shortage) I (Shortage) $ - I $ 354,705.60 (1.27) $ (60,194.10) $ 294,511.50 0.08 $ (933.66) $ 293,577.84 $ (483.90) $ 293,093.94 (69.70) $ (536.70) $ 292,557.24 $ (4,472.95) $ 288,084.29 $ (15,542.79) $ 272,541.50 $ (3,704.77) $ 268,836.73 $ (0.54) $ 268,836.19 $ .(2,500.00)1$266,336.19 b'?!ZK~;i'm~,i .....i.;~~i90~;~r.~;:jI1;lg~~1~.f~i~i.I' $ (2,500.00) $ 261,336.19 I $ (2,500.00) $ 258,836.19 i $ - $ 258,836.19 i (77.27) $ (95,869.41) i Total EIA Billed (5.99) 0.15 (0.54) == I i r- I I i , ---r-- I I I U: Iwindowslmsofficelexcellgasf20( sheet recovery) -- EIA -.-- NGlTherm LP/Gal. .0001.000 .0001.000 .OOO~ .0001_000 --- .0001.000 .0001.000 .0001.000 .0001.000 .0001.000 '..!.i~'~~~~I.....' .0001.000 .0001.000 ~---~-----~---.TI . --t----+! 1 - I : i IAttachment #1. !-----t _ . i '. _~_I____I. I ___ : _ Pa~e 3 o~~ TOTAL ALL, COST RECOVERY ADJUSTMENT CLA.USE. S (Both PGAs + ECA + EIA) ~.- - --i1=-- -- =t _ __ I I I - _ ! 1 r-.-t-- --+--+-- f Monthly i Cumulative I Total ~U:n;~t -- : ----~=~~i--- ---~--~-=-.-----==-~------F-~_ ---4------'- EX~:~~~1I(3) -I TotaIB~I~:;very i -~~:::~:~~ ~~~;;~r~ -~~~~~~~m= ~riorYe;-4____~__ . T ~_ $ - $ - =r- - i $ (532,766.14)1 ___ Oct-OO i. . =+='. . .. . ------t--- (1) $ 2,103,596.10 $ 798,623.27 I $(1,304,972_83)! $(1,837,738.97)1 .7101.984 Nov-OO i ----L $ 1,027,842.55 $ 956,135.30 I $ (71,707.25)1 $(1,909,446.22) .740/1.039 ~OO ].=-...-=~ f.-=~-===-~----=--=---+-. - $ 1,595,846.27 $ 1,476,058.94 $ (119,787.33)1 $ (2,029,233.55) i .850/1.039 Jan-01 i ____~____________+__----- _ $ 2,430,036.52 $ 2,838,623.56 $ 408,587.04 $(1,620,646.50) 1.310/1.203 -- Feb-01 I --- i ~l~=== $ 2,403,697.94 $ 2,631,437.91 $ 227,739.97 I $(1,392,906.54) 1.310/1.312 Mar-01 I ~.~-.-=-.-=t-.. -=--==:.-=--==-------------t--=~~=+___ $ 1,570,091.98 $ 1,953,436.51 1$ 383,344.53 $(1,009.562.01) 1.310/1.312 Apr-01,i--____ ---------- r I $ 1,171,763.88 $ 1,799,500.11 $ 627,736.231 $ (381,825.78) 1.090/1.083 May-01 i ____u__ I I $ 1,114,166.99 $ 1,317,646.09 $ 203,479.10 i $ (178,346.67) 1.000}111!1MJ5 Jun~01....J....... .... ... ...... ...)). .._. ..... ..... ........ ...... j ....................."J. ...~_ '. ...I......~~?~:~g~:g~,~..1.:18?,~?~..~~..$.. . 3..1....~:g.!.~.~~Lt . .1~~,?~3;..??...,....;~~91;~~.~..~ ~~~1~f"'cc_~=J_ .. ",,,g( ----~i:~ C~(. "", ,.' f '::r ~"r=~:=~ =ta~-==r.~~-~=~-=-t - I J $ 16,851,642.22 $ 18,014,575.39 $ 1,162,933.16 (1) Ii "ct. a""",' oh",ge fo, Adm'" & ees ""g of $1,246,520; he""" Octobe, mO"lh~ ,hortage w.. ",all, 1$58,452.83) -+.. _ _n --J - - t. ___ (2) I Prior Year Cummulative balance adjusted by $432,998 in ECA for Sales & Conversion Costs. -t-- __+-__ ______ 1---- (3)tpGA-NG & ECA Personnel Costs = Approx. $120,000 annually. I _~_._____I--_I--. 1 Nole f' olal of above 'T,acts = APP':'. $1,800,000 a"" "' II, . -f'- -- - .....~ .-~-:- ~ --:- -t-::- _+_.:::... ____ WEATHER NORMALIZATION (WNA) -1-_ ~1~t t;--~:k -~---- - . --=G=- ~~~~J~::" -~ NGThenns - RaWThe,m -~, ~$ (E::~t~~i::.ie I N~~:7" Nov-OO I i ~ _ $ _ _ Dec-OO I i I. $ _ $ _ Jan-01 I - --j--- ~! $ _ $ _! Feb-01 I $ _ --l--- I Mar-01 I $ _ : $ _, Apr-01 i _ $ _ I $ _ May-01 I, $ _ $ _ $ _ Jun-01 I ----r----- $ _ $ _ $ _ I ~.J.~~.-t 1$ - $ - $ - I Aug-01 I __ -.-L--~ $ _ $ _ Sep-01 I - I $ _-=--1 i $ _ $ _ Sep-01 1----- I --r-- i $ _ Total YTD I I _ _ _ I $ _ l--- i . __ _+=__ 1 i , ! ---+---- i I i --~-_r_----------- i I ---~_t_ ~ I --.l. -t I =1_______ Last Updated: 06/21/01 Page 3 U :lwindowslmsofficelexcellgasf20( sheet recovery) 4 r T Ik:,-Irm€1J r JJ- L ,,--,_._,,"-" ....---.....-....~.."."......--~~ CLEARWATER FYOO-Ol PURCHASED GAS COST PROJECTIONS AS OF B.1sed on Aaual DTH's Sold FTS-l Contract Capadty FTS-2 Contract Capadty Capadty Relinquishments 612012001 FTS-l AvaiJable Capacity m-2 Available Capacity Contract NNTS Per Month Projected Sold Per Month % of Purchased Sold Gas Gas lOll (PGA revenues) Purchased Gas Sold Gas -- Oct-OO Nov-oo Dec-OO )an-o 1 Feb-Ol Mar-Ol Apr-o 1 Hay-Ol )un-ol )ul-Ol Aug-o 1 Sep-o 1 (phase /I) (phase /Ill 232 376 41.788 $ 8 725.73 117,803 0 15,500 156,361 137,584 138000 -0.93% $ 706,640.96 306 570 53.430 $ 5.679.32 177,117 0 22,500 182,883 157.808 156 000 -8.29% $ 854,699.34 316789 55.211 $ 2,231.00 142,637 0 31,000 229.363 198.050 189000 -6.82% $ 1,309,920.12 316,789 55,211 $ 2,313.27 109,062 0 46,500 262,938 245,010 216000 11.77% $ 2.624.583.77 286 132 49,868 $ 1 137.17 159,220 0 42,000 176,780 231,985 201 000 1.09% $ 2,438,289.82 316.789 55.211 $ 3458.18 170.229 0 21,000 201.771 174,851 222 000 $ 1,809 487.89 306 570 53.430 $ 4 725.77 192,742 0 22,500 167,258 190.000 190 000 144,212 41788 $ (15 292.58 36,386 0 23 250 149,614 157000 157000 139560 40440 $ 27580.50 43 000 0 10500 137 000 140 000 140 000 144212 41788 $ 28 499.85 49 000 0 10 850 137000 1 37 000 137000 144212 41788 $ 28 499.85 49 000 0 10850 137000 137 000 137000 139 560 40 440 $ 17829.00 36 000 0 12000 144 000 137 000 137 000 Total 2.793,771 570,393 ($145,972.22) FTS-l Reservation charges FT5-1 Usage Charge m.l No-Nodce charges FTS-2 ReseIVatlon charges 1.282,196 o 268,450 2.081,968 2.043.288 0.06% $ 9,743,621.90 FTS-2 Usage Charge FGU Management ree Per Month Total Billing From FGU + Infinite WACOG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Total Commodity charges Monthly Adjustments Fuel Cost (Fuel Retendon) Oct-OO Nov-oo Dec-oO )an-o 1 Feb-Ol Har-o 1 Apr-o 1 May-o 1 Jun-ol Jul-Ol Aug-ol Sep-Ol (nhase III I nhase III NNTS (nhase IIIl (nhase IIIl $ 87.210.71 $ 3,559.00 $ 914.50 $ 32,109.90 $ 2,445.07 $ 782,037.13 $ - $ 24,175.79 $ 5.112.10 $ 5.75 $ 5.47 57.01% $ 899,405.96 $ 115.055.72 $ 1,041.07 $ 1,327.50 $ 41.055.61 $ 1,621.31 $ 969,701.64 $ 137.40 $ 26,091.53 $ 6.065.18 $ 6.11 $ 7.16 50.80% $1,121,463.15 $ 1 18,890.91 $ 2,642.15 $ 1.829.00 $ 42,424.11 $ 5.247.77 $ 1.922,501.91 $ (71.8ll $ 40.714.95 $ 6 916.03 $ 9.08 $ 11.44 61.66% $2,081,414.97 $ 117.750.47 $ 6,159.17 $ 2,743.50 $ 42,225.17 $ 3,454.95 $ 2.441.057.67 $ 158.87 $ 51,507.81 $ 7,887.88 $ 9.89 $ 9.27 70.68% $2,601.461.71 $ 106,155.26 $ 6,149.71 $ 2,478.00 $ 18,119.05 $ 929.76 $ 1,500,768.02 $ (15,092.87 $ 14,291.11 $ 6,115.91 $ 9.31 $ 10.24 52.61% $1.~.16 $ 11 7,750.47 $ 6,110.78 $ 1.829.00 $ 42,225.37 $ 1,181.16 $ 995,559.07 $ (175.75 $ 22.520.41 $ 6.316.89 $ 5.72 $ 54.24% $1,151,905.73 $ 111.952.07 $ 1,877.56 $ 1,579.15 $ 40,863.26 $ 1,605.22 $ 892,881.92 $ - $ 20,471.50 $ 5,607.07 $ 6.24 $ 46.46% $1,044,100.98 $ 51,601.60 $ 2,517.51 $ 711.60 $ 11,098.63 $ 948.72 $ 728.211.21 $ (85.64 $ $ 5,096.82 $ 5.34 $ 80.44% $798,152.48 $ 52 376.87 $ 4 586.60 $ 619.50 $ 31074.10 $ 1,233.42 $ 651 275.77 $ $ 1855\.75 $ 4 580.00 $ 5.17 $ 76.11% $707.765.74 $ 54122.76 $ 4,522.57 $ 640.15 $ 32 109.90 $ 1 274.53 $ 646 997.69 $ $ 18 429.09 $ 4 550.00 $ 5.15 $ 73.66% $705,370.66 $ 54122.76 $ 4 522.57 $ 640.15 $ 32 109.90 $ 1 274.53 $ 658712.81 $ $ 18 769.20 $ 4 550.00 $ 5.23 $ - 77.42% $717085.77 $ 52,376.87 $ 4919.10 $ 708.00 $ 31 074.10 $ 1,233.42 $ 681 873.B1 $ $ 19 422_29 $ 4 860.00 $ 5.20 $ - 77.22% $748203.78 $1,043,568.48 $50.628.01 $16,040.25 $436,509.32 I Note: Volumes are based on historical usage and expected weather. FGT transportation and fuel rates are based on actual approved gas tariff rates. These numbers represent a best look forward based on current data. I F:\SUPPL Y\WACOG lOOI.xls $24,652.07 $12,871,582.69 ($14.931.80) $296,965.68 $68,058.08 $6.834 64.860,1> $14,227,336.11 Average Total Projected DTH WACOG T Olal Reservation Total Commodity Cost Purchased 1st 6 Months $888,769.81 $8,617,486.89 $9,506,256.70 1,210,096 $7.856 2nd 6 Mnnths $461,176.02 $4,259,703.18 $4,721,079.40 871,872 $5.415 TOTAL $1.150,145.81 $12.877,190.27 $14,227,336.11 2.081,968 $6.83 Purchased Wacog FY01 Budget 207B 10,500,000.00 PO amount 3,727,336.11 over budget I Propane Inventory and Weighted Cost of Gas (WACOG) 612012OO1 f+:rr/kif-f/J 6\.J /- j:i. 3 I '---'--- ...-- .... LP Supplied by: Sea-3 of Florida Suburban Propane Gallons Propane Propane Shipping Total FYTD Costo! Tank Tank WACOG Oate Company Invoice t# Oellllered Rate Cost Cost Cost Gallons 'nllentorv I"ventarv Withdrawl 09/30/00 $ 38,173.59 53,324 28,532 0.71588 10/01/00 Tex 25164 9,104.0 0.76677 $ 7017.08 $ 7017.06 9.104.0 $ 45.190.67 62 428 0.72388 10103/00 5 882639 2.003.7 0.78400 $ 1,570.90 $ 1.570.90 11107.7 $ 46,761.57 64,432 0.72575 10/04/00 5 882640 1.890.5 0.78400 $ 1,482.15 $ 1,482.15 12.998.2 $ 48.243.72 66,322 0.72741 10106100 5 882641 1.677.4 0.78400 $ 1,315.08 $ 1.315.08 14.675.6 $ 49,558.81 68,000 0.72881 10110100 5 882642 2.139.6 0.77400 $ 1,656.05 $ 1.656.05 16.815.2 $ 51 214.86 70.139 0.73019 10111/00 5 882643 2.384.2 0.77400 $ 1,845.37 $ 1,845.37 19.199.4 $ 53,060.23 72,523 0.73163 10113/00 5 882644 1,789.8 0.80400 $ 1,439.00 $ 1.439.00 20,989.2 $ 54.499.23 74.313 0.73337 10117/00 5 882645 2.158.0 0.81400 $ 1.756.61 $ 1.758.61 23,147.2 $ 56,255.84 76,471 0.73565 10118100 5 882646 1,766.1 0.61400 $ 1,437.61 $ 1437.61 24 913.3 $ 57.693.44 78.237 0.73742 10123/00 5 882647 2,289.1 0.77400 $ 1,771.76 $ 1,771.76 27202.4 $ 59,465.21 80,526 0.73846 10124/00 S 882648 2,081.2 0.77400 $ 1,610.85 $ 1.610.85 29,283.6 $ 61,076.06 82,608 0.73935 10125/00 5 882649 2,209.3 0.77400 $ 1,710.00 $ 1,710.00 31 492.9 $ 62.786.05 84,817 0.74025 10127/00 5 882650 1.954.2 0.77400 $ 1.512.55 $ 1512.55 33,447.1 $ 64,298.61 86,771 0.74101 10131/00 5 882651 2.070.1 0.76400 $ 1,581.56 $ 1,581.58 35,517.2 $ 65 880.16 88.841 0.74155 10131/00 Seal 4000-0270 18.878.0 0.71350 $ 13,538.74 $ 327.68 $ 13.866.42 54,395.2 $ 79,746.58 107.719 0.74032 10131/00 End of m....... W!!IIIIl_"\'!,,', ,~ '~,;~~ t; S 50,321.06 67,972 39,747 0.74032 ,. 11/01/00 5 882652 2 030.4 0.76400 $ 1.551.23 $ 1.551.23 56,425.6 $ 51.872.29 70,003 0.74101 11/07/00 5 882653 2183.8 0.75400 $ 1.646.59 $ 1,646.59 58.609.4 $ 53 518.87 72,188 0.74140 11/13/00 5 882654 2,315.6 0.74400 $ 1.722.81 $ 1.722.81 60,925.0 $ 55,241.68 74.S02 0.74148 11/14/00 5 882655 1.891.5 0.75400 $ 1426.19 $ 1.426.19 62.816.5 $ 56,667.87 76,394 0.74179 11/15/00 5 882656 1,518.4 0.76400 $ 1,160.06 $ 1.160.06 64 334.9 $ 57,827.93 77.912 0.74222 11/16/00 5 882657 1.601.1 0.78900 $ 1,263.27 $ 1,283.27 65,936.0 $ 59 091.19 79.513 0.74316 11/21/00 S 882858 1,215.9 0.80400 $ 977.58 $ 977.58 67.151.9 $ 60.068.78 80.729 0.74408 11/21/00 5 882659 2.314.5 0.80400 $ 1 860.86 $ 1.860.86 69,466.4 $ 61,929.64 83.043 0.74575 11/27/00 S 882660 2132.6 0.80400 $ 1714.61 $ 1.714.61 71.599.0 $ 63,644.25 85,176 0.74721 11/27/00 Seal 4000-0353 18 733.0 0.70941 $ 12,940.56 $ 348.78 $ 13 289.34 90.332.0 $ 76,933.59 103.909 0.74039 11/28/00 5 882861 1,782.5 0.80400 $ 1433.13 $ 1433.13 92.114.5 $ 78,366.72 105,692 0.74147 11/28/00 5 882662 1.729.9 0.80400 $ 1,390.84 $ 1 390.84 93.844.4 $ 79.757.58 107.421 0.74247 11/29/00 5 882663 2,256.5 0.80400 $ 1.814.23 $ 1.814.23 96.100.9 $ 81,571.78 109.678 0.74374 11130/00 5 882664 2337.3 0.79400 $ 1,855.82 $ 1,855.82 98,438.2 $ 83 427.60 112.015 0.74479 11/30100 End of_ $ 47,136.99 63,289 48.726 0.74479 12102100 5 882665 1.760.7 0.79400 $ 1,398.00 $ 1,398.00 100,198.9 $ 48.534.99 65.050 0.74612 12104/00 S 862666 2,078.1 0.79400 $ 1,650.01 $ 1.650.01 102.277.0 $ SO 185.00 67,128 0.74760 12105/00 5 882667 2.352.8 0.80400 $ 1891.65 $ 1.891.65 104,629.8 $ 52,076.65 69,481 0.74951 12106/00 5 882668 1999.2 0.80400 $ 1,607.36 $ 1,607.36 106 629.0 $ 53,684.01 71,480 0.75104 12107/00 5 882669 2.229.9 0.84400 $ 1.882.04 $ 1.882.04 108,858.9 $ 55.566.04 73.710 0.75385 12109100 5 882670 2,281.6 0.86400 $ 1971.30 $ 1971.30 111140.5 $ 57,537.34 75,992 0.75715 12112100 5 882699 1943.0 0.89600 $ 1,740.93 $ 1,740.93 113,083.5 $ 59.278.27 77,935 0.76062 12113/00 5 882700 2,152.7 0.89600 $ 1 928.82 $ 1.928.82 115.236.2 $ 61.207.09 80,087 0.76426 12118/00 Seal 400C>0434 18.835 0.74319 $ 13,647.28 $ 350.67 $ 13997.95 134,071.2 $ 75.205.04 98.922 0.76024 12120100 882701 1,000.1 0.95600 $ 956.10 $ 956.10 135,071.3 $ 76,161.14 99,922 0.76220 12131/00 Se.3 4000-0466 9.100.0 0.74319 $ 6,593.59 $ 169.42 $ 6.763.01 144.171.3 $ 82,924.15 109 022 0.76062 12/31/00 End of m....... $ 43,961.50 57,797 51,225 0.76062 01/02101 Se.3 4001-0009 9.439 1.01109 $ 9,367.92 $ 175.74 $ 9.543.66 153610.3 $ 53.505.16 67.236 0.79578 01/03101 S 882702 1.200.2 1.08600 $ 1.303.42 $ 1.303.42 154.810.5 $ 54 808.58 68.437 0.80087 01/10101 5 882703 1.002.0 1.03600 $ 1.038.07 $ 1,038.07 155 812.5 $ 55,846.65 69,439 0.80426 01/17/01 5 882704 1,002.0 1.02600 $ 1,028.05 $ 1,028.05 156 814.5 $ 56,874.70 70441 0.80741 01105101 5eaJ 4001-0508 9.100 1.01109 $ 9.031.48 I S 169.42 $ 9.200.90 165.914.5 $ 66,075.60 79.541 0.83072 01/17/01 Seal 4001.Qlll 9,396 1.01109 $ 9.325.25 $ 174.93 $ 9,500.18 175310.5 $ 75575.78 88 937 0.84977 01/24/01 S 534317 1200.9 0.99600 $ 1,196.10 $ 1.196.10 176.511.4 $ 76,771.88 90,137 0.85172 01/29/01 SeaJ 4001-0243 30,574 0.98733 $ 29.617.29 $ 569.22 $ 30,188.51 207065.4 $ 106.958.39 120.711 0.88607 01/31/01 End of mon'" , $ 49,676.49 56,066 64,645 0.88607 02114/01 S 882705 1200.6 0.81600 $ 979.69 $ 979.69 208,286.0 $ SO.658.18 57,267.0 0.88460 02114/01 Seal 4001.0J36 28,711 0.76227 $ 21,865.54 $ 21.885.54 236,997.0 $ 72.543.72 85.978.0 0.84375 02128/01 5 882706 1.021.2 0.77600 $ 792.45 $ 792.45 238.018.2 $ 73.336.17 86.999.2 0.84295 02/28/01 238,018.2 $ 32,772.37 38,878 48,121 0.84295 03108101 5e.J 4001-0439 18.878 0.67621 $ 12,417.39 $ 348.18 $ 12,765.57 256.896.2 $ 45.537.94 57,758.2 0.78845 03126101 5e.J 4001-0508 9439 0.87621 $ 6,208.70 $ 174.09 $ 6 382.79 266,335.2 $ 51.920.73 67.195.2 0.77269 03128/01 SeaJ 4001-0508 9.917 0.67621 $ 6.523.11 $ 182.91 S 6.706.02 276.252.2 $ 58,626.74 77112.2 0.76028 03107/01 5 882707 651.2 0.72600 $ 472.77 S 472.77 276,903.4 $ 59,099.51 77,763.4 0.75999 03121/01 5 882708 1,503.5 0.70600 $ 1.061.47 $ 1.061.47 278,406.9 $ 60.160.98 79.266.9 0.75897 Ad' 4001.0439 NlA NlA $ (552.80 $ (552.80 278.406.9 $ 59,608.18 79.266.9 0.75200 03131/01 End of_ ". S 23,234.56 30,897 48,369 0.75200 04/18/01 5eaJ 4001-05081 NlA NlA $ 1.109.87 I S 1.109.87 278,406.9 $ 24,344.43 30,897.4 0.78791 04/18/01 Seal 44324 I NlA NlA $ (179.7911 S 1179.79 278,406.9 $ 24.164.64 30,897.4 0.78209 04/18/01 Se.J 4001.Q243I NlA NlA $ (13.63ll $ (13.63 278.406.9 $ 24.151.01 30.897.4 0.78165 04/16101 SeaJ 4001-0566 19.226 0.68361 $ 12.788.56 I $ 354.60 $ 13143.16 297.632.9 $ 37,294.17 50,123.4 0.74405 04/30/01 End of m....... iQ; ., S 6.157.30 8,275 41,848 0.74405 05/02101 Seal 4001-0613 19.925 0.65201 $ 12 623.88 $ 367.49 $ 12.991.37 317.557.9 $ 19,148.67 28,200.4 0.67902 05108101 Sea3 4001-0243 $ 193.42 $ 193.42 317,557.9 $ 19.342.09 28 200.4 0.68588 05110101 Sea3 4001-0635 10.006 0.65201 $ 6,339.SO S 184.55 $ 6524.05 327.563.9 $ 25,866.14 38.206.4 0.67701 OS/21/01 Adi 4001-0508 NlA NlA $ 169.41 $ $ 169.41 327.563.9 $ 26,035.55 38,206.4 0.68144 OS/21/01 Adi 4OO1.OJ36 N/A NlA $ $ 534.53 $ 534.53 327.563.9 $ 26570.08 38,206.4 0.69543 05121/01 Sea3 4001-0682 19,140 0.65201 ~ 12.126.53 $ 353.03 S 12,479.58 346.703.9 $ 39,049.64 57 346.4 0.68094 05131/01 End of month ~,,\, 'G} ",' l'.('~,:( , ~ ~~'\0m $ 12,010.76 17,636 39.708 0.68094 08101/01 Sea3 19,718 0.61411 $ 11,745.42 $ 363.67 $ 12.109.09 366421.9 $ 24,119.85 37,356.4 0.84567 FYTD Totals 327 564 0.82704 $ 265,930.36 $ 4 625.63 $ 270 909.02 Page 1 of 1 CSW06/21/01 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 10/99 Therm Rate % Change from 10/99 Therm Rate Utility Tax Note: Fuel Rate per Therm 10101/73 Non-Utility Taxable FuellTherm ~ SMF MMF NA (1 - NA (4 + 3 Units) Units) NA (4 + Units) CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JULY 1, 2001 . SEPTEMBER 30, 2001 BASED ON APPROVED GAS ADJUSTMENT FACTORS LMF NA (4+ Units) $7.00 $15.00 $20.00 $50,00 $0.580 $0.580 $0.580 $0.580 0.160 0.160 0.160 0.160 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 $0.740 $0.740 $0.740 $0.740 $1.420 $1.420 0.680 0.680 0.680 0.680 $1.420 $1.420 $7.00 $15.00 $20.00 $50.00 Firm Natural Gas Rate Schedules SGS MGS LGS RAC GAC LAC 0- 18,000- 17,999 99,999 $15.00 $20.00 100,000 &up $50.00 $0.350 $0.510 0.680 $1.190 $50.00 NA(1- NA(O- NA(150 3 Units) 149 tons) tons & +) $7.00 if $15.00 if $15.00 if not prevo not prevo not prevo billed billed billed $0.200 0.160 0.160 $0.150 0.160 0.000 0.000 $0.310 0.680 $0.990 $0.100 0.160 0.000 0.000 $0.260 0.680 $0.940 $7.00 @ $15.00 @ $15.00 @ premise premise premise $15.00 $0.200 $0.360 $1.040 $15.00 + FAC ~ SL w/M& ReliQht NA NA NGV NA Interr. NG Rate NSS ~ NA 100,000 & up $25.00 $100.00 $0.470 $0.280 0.160 NA 0.000 NA $0.470 $0.410 0.000 0.000 $15.00 $7 Resl.! $15 GS if not prev. billed $0.300 $0.100 0.160 0.160 0.160 0.000 0.000 0.160 0.160 0.000 0.000 0.000 0.000 0.000 $0.630 $0.280 0.000 0.000 0.000 0.000 $0.630 $0.570 0.680 0.680 $1.310 $1,250 $0.360 0.680 $1.040 0.000 0.000 0.000 0.680 0.595 $15.00 $20.00 $0.460 $0.260 0.680 0.680 0.680 $1,310 $0.875 $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.299 $ 1.299 $ 1.299 $ 1.299 $ 1.199 $ 1.144 $ 1.089 $ 0.952 $ 0.906 $ 0.860 $ 0.952 $ 1.043 $ 0.860 $ 1.199 $ 0.801 $ 1.377 $ 1.377 $ 1.377 $ 1.377 $ 1.271 $ 1.212 $ 1.154 $ 1.009 $ 0.960 $ 0.912 $ 1.009 $ 1.106 $ 0.912 $ 1.271 $ 0.849 $1.140 $0.940 $15.00 $7 Resl./ +FAC $15GS@ premise + FAC $ 0.355 $ 0.355 $ 0.355 $ 0.355 $ 0.355 $ 0,355 $ 0.355 $ 0.355 $ 0.355 $ 0.355 $ 0.355 $ 0.355 $ 0.355 $ 0.355 $ 0,285 33.3% 33.3% 33.3% 33.3% 37.2% 39.7% 42.5% 51.8% 55.9% 60.7% 51.8% 45.2% 60.7% 37.2% 48.3% $0.069 $0.069 $0.069 $0.069 $0.611 $0.611 $0.611 $0.611 BTU FACTOR = THERMS/100 CUBIC FEET (CCFI Firm Service Rates Interruptible Service Rates 10100 11/00 1.049 1.050 1.054 12/00 01/01 $0.069 $0.069 $0.069 $0.611 1.077 $0.069 $0.611 04/01 05/01 $0.069 $0.611 06/01 1.073 $0.069 $0.611 07101 1.068 $0.069 $0.611 $0.069 $0.069 $0.611 $0.611 08/01 09/01 $0.069 $0.055 Attachment #4 Contract NG Rate ~ NA By Contract _ By Contract NA NA 0.000 Contract + $0.000 Plus 0.595 $0.595 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms - $ 0.285 91.9% $0.069 $0.526 1.028 1.030 1.033 1.059 1.039 $0.611 $0,611 02/01 03/01 1.081 1.084 1.060 1.063 1.056 1.074 1.053 1.052 1.047 $0,611 $0.540 CSW:06/21/01 Attachment #5 Page 1 of 2 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 JULY 1, 2001 - SEPTEMBER 30, 2001 BASED ON APPROVED GAS ADJUSTMENT FACTORS Contract LP Svc. RLP MLP GLP LLP LPV LPS CLP Applicable Annual Gallon Range NA NA o - 2,500 Gallons 2,501 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) Monthly Customer Charge $7.00 $15.00 $15.00 $20.00 $7.00 Res!. or $25.00 Set By Contract $15.00 GS if not ... Non-Fuel Enerav Charaes/Gallon: prey. billed @ premise Non-Fuel Energy Charge IGallon $1.400 $1 .400 $0.200 $0.150 $0.100 $0.390 Set By Contract Energy Conservation Adj.lGallon 0.146 0.146 0.146 0.146 0.146 0.146 NA Environm'llmposition Adj. IGallon 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 Total Non-Fuel Charges/Gallon $1.546 $1.546 $0.346 $0.296 $0.246 $0.536 By Contract + $0.000 Purchased Gas Adjustment/Gallon 0.670 0.670 0.670 0.670 0.670 0.670 0.670 Total Energy Charges/Gallon $2.216 $2.216 $1.016 $0.966 $0.916 $1.206 $0.670 + Contract NFE ~ Minimum Monthly Bill $7.00 $15.00 $15.00 $20.00 Any Applicable $25.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 10101/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm $0.509 $0.509 $0.509 $0.509 $0.509 $0.509 $0.509 Change from 10/99 Gallon Rate % Change from 10/99 Gallon Rate $ 0.202 10.0% $ 0.202 10.0% $ 0.202 24.8% $ 0.202 26.4% $ 0.202 28.3% $ 0.202 20.1% $ 0.120 21.8% ~------ CSW:06/21/01 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon Attachme~ Page 2 of 2 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR JULY 1, 2001 - SEPTEMBER 30, 2001 BASED ON APPROVED GAS ADJUSTMENT FACTORS ~ STANDARD RESIDENTIAL LP SERVICE WILL CALL SPLASH - PREPAID COMMERCIAL CONTRACT BRLP1 BRLP2 BRLP3 BRLP4 BRWCLP BRWCLP BRSPLP1 BRSPLP1 BRSPLP2 BRSPLP2 BCLP1 BCLP2 CLP Applicable Annual Gallon Range 0-60 60.1 - 120 120.1 - 300 > 300 o - 300 > 300 o -200 > 200 o - 400 >400 o - 2500 > 2500 NA or Other Rate Determinant -3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS IIIIL 'I Annual Customer Charge $ 84.00 $ 60.00 $ 48.00 $ 36.00 $ 36.00 NA $ 36.00 NA $ 36.00 NA $ 60.00 $ 60.00 Set by contract Non-Fuel Ener!:lv Charaes/Gallon: Non-Fuel Energy Charge/Gallon $ 1.300 $ 1.150 $ 0.700 $ 0.600 $ 0.700 $ 0.600 $ 0.600 $ 0.500 $ 0.500 $ 0.500 $ 0.200 $ 0.150 Set By Contract Energy Conservation Adj./Gallon 0.146 0.146 0.146 0.146 0.146 0.146 0.146 0.146 0.146 0.146 0.146 0.146 NA Environm'llmposition Adj./Gallon NA Weather Normalization Adj./Gallon 0.000 Total Non-Fuel Charges/Gallon $ 1.446 $ 1.296 $ 0.846 $ 0.746 $ 0.846 $ 0.746 $ 0.746 $ 0.646 $ 0.646 $ 0.646 $ 0.346 $ 0.296 Set By Contract + 0.000 Purchased Gas AdjustmenUGallon 0.670 0.670 0.670 0.670 0.670 0.670 0.670 0.670 0.670 0.670 0.670 0.670 0.670 ~, Total Energy Charges/Gallon $ 2.116 $ 1.966 $ 1.516 $ 1.416 $ 1.516 $ 1.416 $ 1.416 $ 1.316 $ 1.316 $ 1.316 $ 1.016 $ 0.966 0.670 + Contract NFE Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Therm 10101/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm 0.509 0.509 0.509 0.509 0.509 0.509 0.509 0.509 0.509 0.509 0.509 0.509 0.509 Change from 10/99 Gallon Rate $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ 0.202 $ % Change from 1 0/99 Gallon Rate 10.6% 11.5% 15.4% 0 .1% 18.1% 24.8% 26.4% 21.8%