Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2001
I I R' J:. , .t~ -' ,---. ' i ""'" < "' ,."" '., n -- ~ l l:,(,'~~~J CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet SEP 1 t~ 2001 Chuck Warrington, Managing Director, SBS ) TO: FROM: William B. Horne II, City Manager il"ITY CL~-' "" ' . : [...'-([,' , v J ..... '. COPIES: Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Tom Madley, Sr. Accountant/CCS; Laura Damico, Sr. Accountant/CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2001 DATE: September 17, 2001 Natural and Propane (LP) Gas supply prices have stabilized somewhat, although natural gas still remains above historical seasonal levels. Most forecasters see natural gas remaining at about 50% above the historic rates for the next few years. Therefore, we are recommending an increase of 11 % in our Standard Natural Gas Purchased Gas Adjustment (PGA), but a corresponding 6C decrease in the Energy Conservation Adjustment (ECA) Clause in October. We had planned for this last month. We believe that we are at the bottom of the fuel cost curve for this year. We are recommending a decrease in our Standard Natural Gas PGA of 6.0C per therm, no change in our Contract NG PGA, and a decrease in our Energy Conservation Adjustment of 6,OC per thermo Please note that this returns our normal differential between our Standard and Contract Natural Gas PGAs. 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 October 1, 2001: Natural Gas Firm Standard Rate Schedule PGA ....... $0.620 per therm (up 6.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.540 per therm (no change) Propane (LP) Gas Rate Schedule PGA .................... $0.550 per gallon (no change) = $0.601 per therm equivalent (no change) Energy Conservation Adjustment (ECA) ............... $0.140 per therm (down 6.0C/therm) = $0.130 per gallon of LP (down 5.3C/gallon) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) = $0.000 per gallon of LP (no change) /} / 10' ''I r, /'. ~., ,-.~ .' ~/ c/ ./" ) William B. Horne II, City M~nager Page 2 I September 17, 2001 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 August and projections for the remainder of the current fiscal year. These show that our Natural Gas PGA is positive by over $650,000. You will also note that our overall status for all Adjustment Clauses is currently about + $330,000; therefore, we have finally gone positive on this balance beyond our Environmental Impact Adjustment balance of nearly $250,000 from our Manufactured Gas Plant insurance claim recoveries. This is important to our overall financials, as this had negatively impacted our financials through May. Attachment #2 shows our calculation of the required Natural Gas PGAs for FY 01/02. Attachment #3 shows our calculation of the required ECA & EIA for FY 01/02. Attachments #4 and #5 show our current annual projections for Natural Gas supply costs and LP historical FYTD costs, respectively. Attachments #6 and #7 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. I should point out that the overall continued impact of this on our Residential customers is a 29% reduction from our peak winter rates (27% lower for LP), but this is still a 4% increase in their therm rate above last October for natural gas (14% lower for LP). This means that our average customer will likely pay an overall October bill of $1.25/month higher this year ($6.04 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 50% increase in fuel supply costs that we and the nation are still 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 March 31, 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 October 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: -rr IIliam B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for October 2001.doc .____~__~_______ _ . .. ___..__. IAttachment #1 ____._.____.~_~___________. .n.___._._._._._.___'--_... PaQe 1 of 3 I ' iliA niRAI GAS PURCHASED GAS ADJUSTMENT (PGA-NG) ____m__~ :.~..__~~_n___~__ - ----~-.----.t-----.--l .-- -- ,-' , -----~--~+-----------+--------:-- MonttilY---'Cum'ulative i NG PGA -- Budget_'3ese.~~~i~~_._~-==_gomn:'~~ity~~~=~.~-=- :-- Interest-L_~ost.Cen!~_LE2.L__!~tal N~!~eL_~__!~~1 NO PGA-'-=__ Overage "_C'YTD Overage 1 Rate/Therl11-- _~~nth.---,-_~~C1rge~_~n_____._.___ Charges-----'~~pen~'--_.Expenses I , Expenses--+-__,BiI!e~..__......L..@~o~~~L l (Shortage) 'I. FirmlContr Prior Year !, : ~ -1- i $ -: ! : $ (151,708.91), Oct-OO : $'834,8B8.83T$==-=-=========_=67"t~9~37':--$ 758.54 ,$--14,229']'4 +(1F$~1 ,523,306.78 ; $'-'-706,640.96 : $-_i816~6Ej5:m!$-- (968,374.73)! .600/.510 _.. Nov-OO : $_1~~~~~-,~1_..!____'m__.________________._._~1~,334.89 $ 4,841.87 ~ $ 12,133.08; : $ 984,069.35 i $ 854,699.34: $ (129,370.01)! $(1,097,744.75)! .630/.537 Dec-OO : $ 160,913.04 $ 1,274,692.54 $ 5,488.72l.!. 15,526.84 i i$ 1,456,621.141 $ 1,309,920.12: $ (146.701.02)! $(1,244,445.77)1 .740/.650 -Jan-01 T$"160,406.071$~-----------===='---2.153,259.49 $ 6,222.23 i $ 15.767.57! 1$ 2,335,655.361 $ 2,624.583.77 ~$ 288,928.41} $ (955,517.36)1' 1.200/1.110 Feb-01 $ 145,835.~___..____~____ 2.128.738.391 $ 4.777.59 I $ 20.324.551 i $ 2,299.675.67 $ 2,438,289.82 I $ 138,614.15~16,903.21) 1.200/1.110__ ----'Y1_ar-01 -lJ... 158,346.66 : $ __~_______u__________u__1 ,290,216.23 1 $ 4,084.52 i $ 34,890.00: ! $ 1,487,537.41 I $__1809,487.89 i $_E!.,950.48mf $ (494,952.73) I 1.200/1.110 Apr-01 i $ 151,668.91 $ 910,013.55 $ 2,474.7~.1 $ 16,772.27 I 1$ 1,080,929.50 I $, . ~.657,081.16n ' 576,151.66 ,$ 81,198.93 i .980/.895. May-01 1$ 70.055.61' $.~m______________.___ ------ 918,278.97 $ - l $ 22,038.49 I i $ 1.010,373.07 ~$ 1,189.850.14 i $ 179,477.071 $ 260.676.00 i .8801.795 ~~~-_~~~~~.~i-~~~lli~~~ .~o.. ..t~~.YI~L$2'~~'~~0.40t$ _==.----.---.-----.~,703,436.46:. $ 28,648.25 ! $ 247,771.68 I $15'049'356.7~) 15'900'..Q?4.~. I $ 850,717 ~~. :. i. _ n'_ (1)ilncludes~~,nual charge for-Admin andCCS chgot$717,520 -----..L --------+--------- . ._=--n___ --.-===-__-==~=~1~==~~~--- 1----_---= __._ (2) I Cos~~nte!.~xpenses in~Q~o/"--~ Langil~~.~~~~~/arringto~m___+-- t----u.---~--..------t- 1__ .--. .---j payrC),II..:'3.pprT $55K annually. --~~-_.-----------_m--f------.---t-------- f- -----~.-t----.----~l--------no-+. i -~ PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP)--._I -~=:~__u~_ I I- =L=-=====t==---j -------t----_= ~-ge!.:-~- GaIlOns--~=t=~~='-u_n._ Monthly ---------==-1 hlterest+ Commodity I i Total LP Fu-ertT'otal LP PGA~--- ~:;r~~~ I ~~m;~:~::e I T~:r~~~1. Month i Sold _'---'--. _~____ WACOG ~___________ l Expense I Charges Expenses' B~lIed ___-=r= (Shortage) , (Shortage) I _Prior Year I ~_____ I! I -L ! $ (8.509.46) I no_ Oct-OO i ___~,981.5i...L_~__.________ 0.740321 $ 42.551' $ 22,195.901(1)'1" $ 45,323.291' $ 23~21.817.47)1 $ (30.326.93)11' .874/.800 Nov-OO i 26.242.31L______________ . 0.74479 '$ 151.63 $ 19.545.00 I i $ 19.696.63 I $ 21,574.47 I $ 1,877.84 I $ (28,449.09) .9291.850 ~ec-OO L__ 63,591.0 I $ _~~_.~_______ 0.76062 ! $ 142.25 I $ 48.368.59 $ 48.510.84 : $ 54.001.88 i $ 5,491.04 I $ (22,958.05)1 .9~0 Jan-01' 58,901.0 i $ _m___~__.___.____ 0.88607 '1 $ 114.79, $ 52.190.41 ! $ 52.305.20 i $ 55,908.11 ! $ 3,602.91 1$ (19,355.14)1 1.093/1.000 Feb-01 54,493.2 ! $____0.84295 I $ 96.78 I $ 45.935.04 I ! $ 46.031.82 I $ 57.180.09 I $ 11,148.27 I $ (8,206.87) i 1.202/1.100 Mar-01 ____44,779.5 i $ 0.75200 : $ 41.03 , $ 33,674.18! i $ 33,715.21 i $ 49,180.71 l $ 15,465.50 [ $ 7.258.62! 1.202/1.100 Apr-01: 39,104.6 : $-________ 0.744051 $ - I,' $$ 29,095.78: 1 $ 29,095.78 ~_ 37,917.53 i $ 8.821.75 I $ 16.080.38 I .973/.890 May-01 46.612.5 I $_______________.__...._ 0.68094 i $ - 31,740.32 L 1$ 31,740.32 i $. 39,352.54 i $ 7,612.22 i $ 23,692.60 I .885/.810 Jun-01 ~ .37,016.9 : $ . , _, 0.64567 [ $ - 1 $ 23,900.70! I $ 23,900.70 I $ ., '--27,693.57 I $ 3,792.87 ,$ 27,485.47 1 .820/.750 Jul-01 L_____26,732.0 ~~_________.0.50947 i $ - .tt-- 13,619.15 I I $ 13.619.15~~n--17,282.35 : $___3,663.20.: $ 31,148.67 i .7321.670 ~.~.~.:.~.~{....'{" 28,924.7., .$g.51~~3.i{$ - i $14,~~0}~.).. .,.~.14:~~g.,~~..ii~1?2~.0.1~.I$ 2....3.29..931..$.....33..~.?8,.~.gil .634/.580 Si~Qrl;l.. . ...' ,..3:z,OOO,O.$O;.~~~OO}}$ "'}Ntrj::"'j::$:il~)~!{~;(i}O:,f ',i,ii" 'lgi,g140,tlq}::$i~{),~q~;Q\J.$ 1;110,P\Ji$.L..,i'M!~ii;~{):,..i:'i~ij~;'@'~~ TotalYTD 493,379.2 I $ _____________0.71836 [$ 589.031' 354,425.30 :1$ 378,099.17 i $ 421,197.23 ! $ 43,098.06!" , , . i -~--l---~m- m_ ~ Cost Center Expenses I t i i ! : I ---+-___ __-+-_ ,CCS Chg Adj at per 5 fm 6,100 ! i $ 9.000.00 I (1) i . iAnalog phone line fo"r sottWare'.----iT 300.0~ (1) ._____ iSoftware support1140(12x95) I i $ 1.140.00 , (1) I ISuburban maint agmt ' $ 1,140.00 ,(1) ______...________..__~Adminfee&Fuel-_---- I i $ 10,000.00 [(1)1 !LPTruckLeltering! ~$----- 500.001(1) i jHP220Printer ,'T$ 1,004.84:(1)i [Total I !$ 23.084.84 CLEARWATER GAS SYSTEM . ----..--- SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS .-- CSW:9/17/2001 Page 1 U :Iwindowslmsoffice lexcellgasf20( sheet recovery) : : ,i i 'Attachment #1 ===~===-'~.-_=--==-= ~=~~=~_-~~'~==n~_ - -==__._======:J=--==_____'__L__~_=t=l=-~=.==__=t-__====n-_=___=:-=:_~=~~=-__-=---=:.=~== _m__ Paqe 2 of3~ I ' I : ! : i ._.m__._.___ _______ ________________"... I ..__.___,__~~~.;.._____._..,_,____________1_______._______;__.__---------...,--...-~------..----.--- - -- -----.- -..-.----- -.- ----...-.--. ENERGY CONSERVATION ADJUSTMEN! (ECA) I i __ _ I I ] , . ~get--J,.._~~.center+__-====__=-__===__~_=--~_"~.,u__-==____.. ~t---Interest.. \ - ~~=___.__~=----c_--f,~~!~~ E~:---t-T:::~EC1;; .......L"..--~;;Jf~=__]=__J~~~~~~ci=-~.~~~~rm-= --=_Month__~xpe..~ses___!.-Notesi~-~~~..E!ional-ltE!I1l-SJ~t.___.._._____i.. _Expense J-~~----:=i--t-' _~xpe~~~_~~_n_.!3Jlled ____..1. (Shortage) J. (Shortage) (2) .. _--,"-P/Gal..__ Prior Year: unadjusted l____ .__. ____._____________.___.___..: I i ,_____1.1___~~~_.JJ.._~____~.E?2,253.EL_----- Oct-:.OO _' $ 471,136.93 iPro.':':.'c:~:.4~~~~':tis~ng$~~Q()E_rnJ'I~COS~.$17,433.93 i $ 3,636.27 i : (11L! 474,773.20 1 $..____ 68,477.76 i $ (406,295.44)1 $(1,133,548.81): .1101.101__ __ Nov-OO $ 17,475.08 iPromo$6,407.Advetising$750EmployCos!s$15.240~n__~.l.1. 5,667.74 1 ~___~._L..l.!. 23,142.82 l $ 79,861.41 i $. 56,718.59.g(1,076,830.22)l _ .1101.101 _J2~~-00__LL_J3~,846.242~~!!lO$7~339.72 ~~Iance E.n:'E~:. Cos~s.. : $ _ 5,384.151 ____._.__.,--l.!~,230.3911.___. 112,136.94 I $ . 21 ,906.55l!~~ ,054,923.67) i...J..!_0/.1 01 __ Jan~J..._ 36,334.34 IPromo$24,884.19 & Balance Empl. Costs '. $ 5,274.62 'r '. i $ 41,608.96 L!-__.158,201.38-L. $ 116,592.42 I $ (938,331.25)1 .110/.101 Feb-01 . $ 48,825.84 I Promo$38, 727.43 & BalanceEmpl. Costs . $ 4,691.66. ' : $ 53,517.50 : $ 135,968.26lJ.... 82,450.76 $ (855,880.49) i .110/.101 Mar-01 ,$ 29,023.16 IPromo$14,119.77 & Balance Empl. Costs i $ 4,279.40 I _, ! 1$ 33,302.561 $ 94,773.90: $ 61,471.34 $ (794,409.15)1 .1101.101__ APr-01___~. J._ 54,061.64 !PrOmO$15,873~95..&Bal.ance.Empl. Cost~ . $ 3,972.04 i .____ '. J $ 58,033..:~.ll-. _.,-.-104,501.27 -+ $ 46,467.59_ ~ $ (747,941.56)1...:.1....!.Q/.101_. May-01 : $ 68,313.89 rrOmO$54,461.86 & Bal~~~ EmpLCosts . $ 3,739~~_______-,- $ 72,053.60.L_t__ 88,443.95 ~ $ 16,390.35 I $ (731,551.21)1 .120/.110 ~~.L_ 43,287.39 Promo$28,220.08 & .~alance Empl. Costs l $ 3,657.76 I . j 'I $ 46,945.15 ! $ _ 87,202.42 i $ 40,257.27 i $ (691,293.94)1 .1~8 Jul-01 i $ 38,630.73 I Pro'!1_~.E4,420.~,~'!Y~!~9.0 & Bal. Empl. Costs i $ 3,456.47 --L ; $ 42,087.2011 90,805.48[$ 48,718.28 $ (642,575.66) I .160/.146 Tmol ~~)i 1:~~~~~4~~~,I<ha~'fuiAd~;"~~Soj $450000--~ : ~,~i70 '.. -=--h~~ :m:::~~:::~ t:l"d'~:::::f~i~II,y~:::~:,~l'fim ~~Pro) $65K ,""",IIy _.. _J2)!.prior Year cumm. ulativebalanCeadjustedbY$308,286f~!..FY99/00. SalesCost&____~-! ~=_ I.--~-=--==---=:===I~=--_~---L I. .-~ ___. . !$1?..'!~z.1~ Conversion Cost losses = $432,998 Total i -+- i i ! I -- 1---:--'----'---'---.m.-------------I---------~-~----! _~--------u-+----- --.--~--:~-~~~ ENVIRONMENTAL IMPOSITION ADJUSTMENT /EIA) -=-=:=.===t---=~.-- I ! ~--=-L_~=--==~==.-t .. ~~ ___----1-____.-J-__n______________n__u_.________~-.~ I i ...L---~--_1_ Monthly Cum~_ EIA Budget '. Cost Center -t--.-----------~-.------ , Interest i i 1 Total EIA i . Total EtA I. Overage YTD Overage I NG/Therm Month . Expenses ,Notes/Exception~.!.l!e_'!'...!.._______~,__ T. Expense I I. I Expenses, BiI!ed_-----.L-. (Shortage) (Shortage) I LP/Gal. Prior Year I I :'! $ -:- 1$ - 1$ 354,705.60 I '=~-~~~~~~=K-' -60,~~~:~!r---.==--~~=-.-~=-~-~-...=:=-=~,-..---==--.H------=-+'I : (111: 60~~;:H;(~~:)IT (60i~~~~:~fll': ;:~:~;;:~~ I :~~~~:~~~ Dec-OO i $ 483.90 ! ._____________ ___________1 $ - I H $ 483.90 ! $ - ! $ (483.90) $ 293,093.94! .000/.000 Jan-01 : $ 467.00 I_._______n_~_ ! $ - I jl $ 467.00 I $ ._J69.I.Q2lJ....::-- (536.70) $ 292,557.24' .O~O Feb-01 1$ 4,472.95 i. .-.~--.-~------u-----tt -. I .l.L- 4,472.95 I $~----------L!-- (4,472.95)[ $ 288,084.29+-.0001.000 Mar-01 : $ 15,536.80 LEnvironmental Consultant.___________.. $__ - I ----L ! $ 15,536.80 I~ ' (5.99): $ (15,542.79)i $ 272,541.50 1 .0001.000 f- Apr-01 1 $ _E04.92: _______~________. " i $ - I I i $?,704.92 i $'=-'::~n--QJ.~W- (3,704.77) $ 268,836.73 I .0001.000 _ May-01 I $ - :-~-~u------~~-U- - i .Li.! - l$ (0.54)l!. (0.54) $ 268,836.19 I .0001.000 Jun-01 i $ 10,343.51 I $ ---=---.J_- I i I $ 10,343.511 $ _ - I $ (10,343.51) $ 258,492.68! .000/.000 .~~~~~\.;i: ~:~;~::~J~-------.-------.J.!:. ~ I ,I.t~:~;~::~i!:.. , (53~05) ::. i~:~:~:~;~j;.~;~:~~~:~~J !!:~.~~~.!~!~~ s'~P7~i!' $?1~~(}:QQ' ..$i;;i!;i,;;.~;<;€ii%!i.;;,;%;++..g"..lP ~{~Qg;~Qr.~; ." '-$(glRqQ;~~.,;;~,'.~~~,I~~.~.i~~iH:{QQtfl.o~~r; T~::~D: $ 109~7305~_ =~==---_!$ . i i~~9273:05 : $_ (13032)!: (109.403:31)1~245,30223 ~ - __._ (1);lnC!UdeS annUaliadmin & CCS charges of_$60,000____~_. ! --1 I I . i ,. i --.----+ : ____ _..n~~~~-' u___.____:___________ -----~:'~~.~__~.~__=._~ ""--.-.---.---.--.--------r-'---.T----i-:~---------'1-~---_. i i :! i' I ,~~- i i---------,--- . CSW:9/17/2001 Page 2 U :lwindowslmsofficelexcellgasf20( sheet recovery) i . """ -_..__...t._-~.~_..._.,_. .,..._1.. iAttachment #1 "--._,.-._----~.._-_._- PaQe 3 of 3 ~ ! TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA+ EIAi __.t- , n~~.~=-~-t=~~-==-- __ In--------I---.--~-- , ..._.._____~____._ ; ~---- Monthiy !Cumulative-~~--Total~~ Budget ! --~===~-.==~==_~==-t..-._--.~=.==~~= =-fo:tal.!~n ...L}~}~ R~~very:~==-= O~~~~_=I_ YTDg~!rage I ~~ Th~~_ Month I _ ____________ ~: -+-~_ ExpellsEl~_ill.--L__..!!ined__ ___...._.~~!1.C)_~~~L__1 (Shortage) (2) I _n_!'IG/LF'.__ _p~~t~~a:_______-=~=-==.~.=. ___~__.______.t==--------+----"-----niIj=?,1~~~96~ 10 l: --798,623~27~rr(~,364)72~83)J!I~~~~: ;~~: ~;~ t~-~71 0/984 --- ~~~~~~ i =_=~==--==--'=',~=~~=-... ...__.., - ..-..., . -~.'. =======~==.~-. '-. .'~. ~:=-------L------j.-"i. 1.. : :~:u::;; 11 T:;:::;:~ ,t:d"( H~;~~t*;:~~;~~~;: I::*~~;; . __ Jan-01..J.____.__________--'--_.___.___ . __ _________ __..J._. i . ! $ 2,430,036.52 $ 2,838,623.56..L $ 408,587.04i $ (1 ,620,646.50) I 1.310/1.203 Feb-01 i ,__._______________.J.___ I I -.L! 2,403,697.94 $ 2,631,438.17 :.!_~27,z40.23~ $(1,392,906.28)i 1.310/1.312 ~. Mar-01.;_====-~.=_=r~=--==:~~-=- _d_~__________ n__~____.____~____t_._:_!. 1,570,091.98 $ 1,953,436.51 i $ .383,344.53 ~ $(1,009,561.75)1 1.310/1.312 _ Apr-~____________,____._.._. ______________..____~.-.---.,-- I ___-.--l___t! 1,171,763.88 tt= 1,799,500.11 1$ .,627,736.23 i $ (381,825.52)11.090/1.083 _ ~~t'Q!..L__.m____ _____ _ _,__ __.~______u_____J__,____ i i ---:.$ 1,114,166.991{- 1,317,646.09 I $ 203,479.10# (178,346.41)1 1000/1.005 Jun-01: -~---t: -- . ------ on____ _~__.__.~__~_~ I ----l' $ 862,767.74 $ 1,101,912.06 , $ 239,144.32 H 60,797.90 I .9~0 ___-!..~:Q.!..__+_ _______ _~ ____. _ __~_______n~L -I . i $ 747,447.71 $ 912,440.04 i $ . 164,992.33 +!__. 225,790.23 I .8401.892 p,u9-011 i I! i ,$ n6,179.04 $ 883,785.73 I $ 107,6~6.69! ~ ..333,396.92 i. .810/.814 gl;!P-.ol". _ . ,.. '" :,',,:. ,'; ,} '"";::i!;;:;facti".IS:;':;.z~~.:,' -d' '$'''1Mik!iL~~lO~jl, ~ '~:'~ .,. 9Iei~~6\~~,. $ ,..U5,~'m~~" $':Y~I,~J&!E1'~{!1!<,' , .1l6,lJ.I,8QJI =~<>.t~~TD t===-.~= -, =.=i-=-==--=----=-=~=-==-__~_-=:-=-L ~-==i--- --+--: $ 16,598,276.72 $ __~,~~9,81~.73 L~~._~~1~~=Q.!.t ____ _--=i_~_ "n__ n (1): Incl. annual charge for Admin & CCS chg of $1 ,246,520; hence, October monthly shortage was really ($58,452.83) -=-----------1-...! : _ . (2) I Prior Year Cummulative balance adjusted. by $432,998 in ECA for Sales &. CO_f!.~rsion Costs.. I ! .___.__________________._. I ' ~EAT::e.:::~~:~:::N;~~~ri~;ol;:~~~':;:~Ll_ __t~,....~~.==~n__=l~~ - - .--j . ~-----= ______ i .L~______u________________l~---- _____~L.lu_,__~.____ I Monthly I_Cumulative.. WNA ..Budge!.J_________L. .____ .._u_.___. . Interest i ~ =~_. i' Overage . YTD Overage NGlTherm Bet;:,'--=---=.=:__ L~~:-~_--- . LP G,IIo" , Exp.ns. Rale/G,IIon : NG Thonns- RalelTh.nn ---tr (Shortag.) IT (Shortage) i LP/G" oct-*' ,. . I . . ----.~ ~=~ ==t:= -~------.---- I $ :-- $ '--::--',--- __on_ _~~~:~~ L _ 1=-=-:-=:=.-~====-=- i ~J ! 1- ---i- i : :, : : .1-- ~:~~~1.1 i +='---.- ..=-==-+: ~ . _ IT~= } .~-tt-c-:: : i-- ~:;:g; i -t-- --=-=....::===~__-+- - ~+-==_ j ~- __=__-1.._ - --- i: . : H---: :- _~:n ~:;;~; ,i . :: ., ---+ , c__ I:--.-+t-~I-- -Jul-01 T----~i-~_.---m'--u. : $ ! .----t-+--__+_ ! $.... 1 $ +--._~- ~~~~~~ i .---- . . j ~ i - i ! i if--' i ~ ~-.--- T~tC:~;D i ---- +-=_ .~n~:--~=__>=~~~~=~=_-----t T L-+-! 1T"'~==~=-J!_.-- ~---t=~=_-== -----, 1,' ===~.:_---l=~~.:.._=~.~.-~_-=---. t- i ~ : ________+-~===.__1_.--~ -+ -.--.-- -"-'._.~-I-----._._----~-_._--------- -~-'-l- --- -----;----- -----------~, .-....--"'T-.--------- -------- Last Update~:_09/1..~'01 CSW:9/17/2001 Page 3 U. Iwindowslmsofficelexcellgasf20( sheet recovery) CSW:08/30101 I I ATTACHMENT #2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/01 - 03/31/02 I. Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible & Contract (Non-Standard) Rate Schedule PGA (See attached Page 2) = $0.080 II. Calculation of the Required Natural Gas PGA WACOG for FY 00/01 A. Therm Sales Projection for 10/1/01 - 9/30102 = 21,600,000 B. Projected NG Reservation Cost 10/1/01 - 9130/02 = $ Projected NG Commodity Cost 10/1/01 - 9/30/02 = $ Budgeted Other Supply Related Expenses = $ Total Recovery Needed for FY 01/02 only = $ Under Recovery of FYTD PGA thru 7/01 = Total Annualized Recovery Needed for FY 01/02 = $ 1,350,000 9,500,000 1,550,000 12,400,000 NA 12,400,000 C. Required Weighted Average Recovery CostfTherm = $ 0.574 45.0% Standard = 9,720,000 Therms @ 55.0% Non-Standard = 11,880,000 Therms @ 100.0% 21,600,000 Therms $ $ WACOG 0.620 0.540 = Recovery $ 6,026,400 $ 6,415,200 $ 12,441,600 $ 11,444,267 $ 997,333 $ 12,441,600 = D. Projected NG PGA Annual Revenue = Pine lias NG PGA = Pasco NG PGA = Total NG PGA = III. Proposed Natural Gas PGA Billing Factors for 10/01/01 - 03/31/02 A. Proposed Standard Rate PGA Billing Factor $ 0.620 B. Less Non-Standard Differential for Reservation Cost $ (0.080) C. Proposed Non-Standard PGA Billing Factor $ 0.540 C:IDocuments and SellingslcwarringlDeskloplNew BriefcaseIMy DocumenlslEXCELlGASRATESIFY 01-02\{PGA for 1 sl Ha~ of FY 01-02,xlsjPGACALC ATTACHMENT #2 Page 2 of 2 CSWOB/30/01 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON-STANDARD THERMS & RESERVATION CHARGES FOR 08/01/00 - 07/31/01 - Subtotal Subtotal Net Net Charge Per Charge Per Billing Total Interruptible % Contract % Non-Standard % Non- Standard % Reservation Standard Non-Interruptible Month Therms Therms Interruptible Therms Contract Therms Standard Therms Standard CharQes Therm Therm Aug 2000 1,274,600 330,219 25.9% 389,780 30.6% 719,999 56.5% 554,601 43.5% $ 67,283.40 $ 0.121 $ 0.071 Sep 2000 1,357,861 362,857 26.7% 426,572 31.4% 789,429 58.1% 568,432 41.9% $ 77,136.32 $ 0.136 $ 0.078 Oct 2000 1,375,842 347,991 25.3% 426,098 31.0% 774,089 56.3% 601,753 43.7% $ 117,368.83 $ 0.195 $ 0.114 Nov 2000 1,578,084 362,172 23.0% 506,868 32.1% 869,040 55.1% 709,044 44.9% $ 151,759.51 $ 0.214 $ 0.125 Oec 2000 1,980,498 374,874 18.9% 633,689 32.0% 1,008,563 50.9% 971,935 49.1% $ 160,913.04 $ 0.166 $ 0.100 Jan 2001 2,450,098 376,947 15.4% 667,748 27.3% 1,044,695 42.6% 1 ,405,403 57.4% $ 160,406.07 $ 0.114 $ 0.077 Feb 2001 2,319,847 427,813 18.4% 686,206 29.6% 1,114,019 48.0% 1,205,828 52.0% $ 145,835.14 $ 0.121 $ 0.077 Mar 2001 1,748,513 351 ,123 20.1% 566,728 32.4% 917,851 52.5% 830,662 47.5% $ 158,346.66 $ 0.191 $ 0.113 Apr2001 1,958,308 408,157 20.8% 626,255 32.0% 1,034,412 52.8% 923,896 47.2% $ 151,908.41 $ 0.164 $ 0.098 May 2001 1,581,271 373,429 23.6% 504,211 31.9% 877,640 55.5% 703,631 44.5% $ 70,055.61 $ 0.100 $ 0.058 Jun 2001 1,451,951 368,318 25.4% 471,232 32.5% 839,550 57.8% 612,401 42.2% $ 55,908.41 $ 0.091 $ 0.052 Jul2001 1,339,466 327,663 24.5% 429,012 32.0% 756,675 56.5% 582,791 43.5% $ 55,544.24 $ 0.095 $ 0.055 Total 8/00-7/01 20,416,339 4,411,563 21.6"10 6,334,399 31.0"10 10,745,962 52.6"10 9,670,377 47.4"10 $ 1,372,465.64 $ 0.142 $ 0.086 # - For Comparison Total 3/00-2/01 20,352,338 4,374,412 21.5% 6,122,832 30.1% 10,497,244 51.6% 9,855,094 48.4% $ 1,346,328.50 $ 0.137 $ 0.084 Change 64,001 37,151 0.1"10 211,567 0.9"10 248,718 1.1"10 (184,717) -1.1"10 $ 26,137.14 $ 0.005 $ 0.001 Note: # It is recommended that the "Charge Per Non-Interruptible Therm" differential be rounded to the next lowest penny or $0.080 for the next semi-annual cycle. C:\Documents and Settings\cwarring\Desktop\New Briefcase\My Documents\EXCEL\GASRATES\FY 01.02\[PGA for 1st Half of FY 01-02.xls]pGACALC I I CSW:09/17/01 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/01 - 3131102 I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 01/02 Budgeted ECA Requirements for FY 01/02 only = $ 870,000 Projected Current FYTO 00/01 (Over) Under Recovery of ECA = $ 530,000 Total Annualized ECA Recovery Needed during FY 01/02 = $ 1,400,000 Projected Therm Sales for FY 01/02 Applicable to ECA Recovery = 9,994,500 (Natural Gas @ 45% Standard = 9,720,000 therms & LP @ 50% Standard = 300,000 gal. or 9,994,500 Total Applicable Therms) Computed ECA Recovery Factor Necessary = $ 0.1401 Propose Rounding ECA Recovery Rate to $ 0.140 # Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 1,399,230 II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 01/02 Budgeted EIA Requirements for FY 01/02 only = $ 100,000 Projected Current FYTO 00/01 (Over) Under Recovery of EIA = $ (245,000) Total Annualized EIA Recovery Needed during FY 01/02 = $ (145,000) We are over-recovered in ECA & project to stay over-recovered for the FY 00/01 period. Therefore, EIA needs to be = $ Round Proposed EIA Recovery Rate to $ Annual ECA Revenue Projection @ Proposed Recovery Rate = $ ATTACHMENT #3 C:IDocuments and SettingslcwarringlOesktoplNew BriefcaseIMy DocumentslEXCELIGASRATESIFY 01-02\(ECA & EIA for 1st Half of FY 01-02.xls]Sheet1 A t'f ct d, 1VI-"nJ-- u.. 4- CLEARWATER FYOt-02 PURCHASED GAS COST PROJECTIONS AS OF Bmd on Actual DTH's Sold 8/3012001 FTS-l Contract Capacity FTS-2 Contract Capacity Capacity Rennqubhments m-l Available Capacity FTS-2 Available Capacity Contract NNTS Per Month Purthased Cas Sold Cas Projected Sold Per Month % of Purchased Cas lost Sold Cas (PCA revennes) -- Oct.Ol Nov-Ol Dee-Ol )an-02 Feb-02 M.....02 Apr-02 Hay-02 )un-02 )ul-02 Aug-02 Sep-02 (Dhase 11\ (Dhase nil 164 940 40 440 $ 20439.54 40 380 0 15,000 165000 100.00% 306 570 53 430 $ 1 858:50 165000 0 22 500 195000 306 570 53 430 $ 1 115.10 137000 0 30 000 223 000 316789 55211 $ 1371.70 152000 0 46 500 220 000 286 132 49 868 $ 1743.40) 117 000 0 42 000 219000 316789 55211 $ 11151.00) 166000 0 31,000 206 000 216570 53 430 $ 11151.00 99 000 0 22 500 171000 144212 41788 $ 5761.35 29 000 0 12400 157000 139560 40440 $ 11151.00) 29 000 0 10500 151000 144212 41788 $ 11 522.70 35 000 0 10850 151000 144212 41,788 $ 14 868.00 35 000 0 10 850 151000 1 39 560 40440 S 11151.00 29 000 0 10500 151000 Total 2,626,116 567,264 ($101,284.29) 1,033,380 o 264,600 2,160,000 o 100.00% $ FT5-1 Reservadon charges m-l Usage Charge m.1 No-NoUce charges FTS.2 Reservation charges m.2 Usage Charge Total Commodity charges Monthly Adjustments Fuel Cost (Fuel RetenUon) FGU Management ree Per Month WACOG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Total 8i11lng From FGU + InfinitE Oct-OI Nov-Ol Dec-Ol )an-02 Feb-02 Har-02 Apr.02 May-02 )un-02 )ul-02 Aug-02 Sep-02 {nhase III Inhaselll NNTS Inhaselil\ Inhase 1111 $ 61 308.20 $ 3570.48 $ 885.00 $ 30928.51 $ 719.83 $ 692 620.67 $ $ 24 175.79 $ 6 079.20 $ 4.64 $ 80.34% $765 302.84 $ 113952.07 $ 4 162.43 $ 1 327.50 $ 40 863.26 $ 951.05 $ 902 842.61 $ $ 26091.53 $ 7354.20 $ 5.42 $ 54.17% $1057126.94 $ 113 952.07 $ 5 136.83 $ 1 770.00 $ 40 863.26 $ 951.05 $ I 152 376.68 $ $ 40734.95 $ 8 544.20 $ 5.86 $ 61.94% $1307846.92 $ 117 750.47 $ 4943.76 $ 2 743.50 $ 42 225.37 $ 982.76 $ 1 184914.72 $ $ 53507.83 S 8 384.11 $ 6.12 $ 59.14% $1 347262.36 $ 106355.26 $ 5 846.00 S 2478.00 $ 38 139.05 $ 542.62 $ 1 035207.83 $ $ 22 882.70 $ 8 435.08 $ 5.39 $ 65.18% $1 181436.74 $ 117750.47 $ 4 799.52 $ I 829.00 $ 42 225.37 $ 807.34 $ 861761.91 $ $ 19009.94 $ 7789.11 $ 4.91 $ 55.38% $LQ12A15.75 $ 80499.07 $ 2048.29 $ I 327.50 $ 40 863.26 $ I 605.22 $ 733 004.38 $ $ 17 276.46 $ 6 334.20 $ 4.94 $ 63.33% m4 543.22 $ 53 603.60 $ 2819.50 $ 731.60 $ 31 098.63 $ 948.53 $ 617501.86 $ $ 17 526.43 $ 5 708.09 $ 4.44 $ 84.41% $697 174.33 $ 51 874.45 $ 2 428.38 $ 619.50 $ 30021.66 $ 1054.81 $ 609 718.48 $ $ 13 794.06 $ 5 484.20 $ 4.51 $ 83.89% $681,083.09 $ 53 603.60 $ 3010.90 $ 640.15 $ 31 959.46 $ 743.83 $ 611 209.01 $ $ 14371.48 $ 5 453.09 $ 4.54 $ 81.18% $685,889.52 $ 53 603.60 $ 3 800.58 $ 640.15 $ 31 959.46 $ 743.83 $ 559 499.20 $ $ 6417.50 $ 4.18 $ 81.18% $630 834.41 $ 51 874.45 $ 3847.49 $ 619.50 $ 30928.51 $ 719.83 $ 557974.98 $ $ 6417.50 $ 4.17 $ 77.22% $630246.45 $976,127.31 $46,414.14 $15,611.40 $432,075.82 $10,770.69 $9,518,632.35 $0.00 $249,371.17 $82,400.48 $5.019 Average 70.61% $10,841,162.58 I Note: Volumes are based on historical usage and expected weather. FGT transportation and fuel rates are based on <lemal approved gas tariff rates. These numbers represent a best look forward based on current data. I F:\SUPPLY\WACOG 2002.x1s Total Projected DTII Total Reservation Total Commodity Cost Purchased 1st 6 Months $841,667.13 $5,829,724.42 $6,671,391.55 1,228,000 2nd 6 Months $480,863.12 $3,688,907.91 $4 169,771.03 932,000 TOTAL $1,322,530.24 $9,518,632.34 $10,841,162.58 2,160,000 8udget 2078 10,500,000.00 PO amount 341,162.58 over budget WACOC $5.433 $4.474 $5.02 Purchased Wacog FYOl Atr.:.....citwt<"-1')4... 1tts; Propane Inventory and Weighted Cost of Gas (WACOG) 9/1412001 I .~-..--...=",-...........~_......"",~-..,~-~.,..,.,.."-=...",,, ,-__..._,......~_.....d..>."'..,..,'.""._.,""__ ." I LP Supplied b : Sea-3 of Flori Suburban Propan Gallons Propane Propane Shipping Total FYTD Cost or Tank Tank WACOG Date ComDanv Invoice # Delivered Rate Cost Cost Cost Gallons Inventorv Inventorv Wlthdrawl 09130/00 $ 38,173.59 53,324 28,532 0.71588 10101/00 Tex 25164 9104.0 0.76877 7017.08 $ 7017.08 9104.0 $ 45 190.67 62 428 0.72388 10103/00 S 882639 2003.7 0.76400 $ 1 570.90 $ 1 570.90 11107.7 $ 46761.57 64 432 0.72575 10104/00 S 882640 1890.5 0,76400 $ 14B2.15 $ 1482.15 12998.2 Is 4B 243.72 66 322 0.72741 10108/00 S 882641 1 B77.4 0.78400 I . 1315.08 $ 1315.08 14675.8 $ 49 558.81 6B 000 0,72881 10/10/00 S 882642 2139.B 0.77400 I s 1 656.05 $ 1 656.05 lB8152 $ 51 214.86 70,139 0.73019 10111/00 S 882643 2384.2 0.77400 $ 1 845.37 $ 1 845.37 19199.4 $ 53 060.23 72 523 0.73163 10/13/00 S BB2644 1789.8 0.80400 $ 1 439.00 $ 1 439.00 20 989.2 $ 54 499.23 74313 0.73337 10/17/00 S B82645 215B.0 0.B1400 I S 175B.61 Is 1756.61 23 147.2 S 56255.84 78471 0.73565 10118/00 S 882646 1765.1 0.B1400 $ 1437.61 $ 1437.Bl 24 913.3 $ 57693.44 78237 0,73742 10123100 5 882647 2289.1 0.77400 1 771.78 $ 1 771.7B 27202.4 $ 59465.21 80 526 0.73846 10124/00 5 88264B 2081.2 0.77400 1610.B5 $ 1610.85 29 283.6 $ 61 076.08 82 BOB 0.73935 10125/00 5 882649 2 209.3 0.77400 S 1710.00 $ 1710.00 .' 31492.9 $ 82 788.05 84817 0.74025 10/27/00 S 862650 19542 0.77400 $ 1512.55 !; 1512.55 33447.1 $ 6429B.61 88771 0.74101 10/31/00 5 B82651 2070.1 0.76400 15Bl.56 $ 1581.56 35,5172 $ 65 880.16 88841 0.74155 10/31/00 5..3 40Q0.0270 lB B7B.0 0.71350 $ 1353B.74 $ 327.68 $ 13 886.42 543952 $ 79 74B.58 107719 0.74032 10/31/00 End of month $ 50,321.06 67,972 39,747 0.74032 11/01/00 5 882852 2 030.4 0.76400 I S 155123 $ 1551.23 56425.6 I $ 51 872.29 70 003 0.74101 11/07/00 S B82653 2183.B 0.75400 $ 1 64B.59 $ 1 646.59 58 609.4 I S 5351B.87 72186 0.74140 11/13/00 5 882654 2315.B 0.74400 $ 1722.Bl 1722.81 60 925.0 $ 55241.86 74502 0.74148 11/14/00 S 882655 1 B9l.5 0.75400 $ 1426.19 1428.19 62 816.5 $ 56 B67.87 76 394 0.74179 11/15/00 S 86265B 1.51B.4 0.78400 I S 1180.08 1160.08 64 334.9 I $ 57 B27.93 77 912 0.74222 11/16/00 5 882657 1601.1 0.7B_ $ 1 263.27 1 263.27 65 936.0 $ 59091.19 79513 0.74316 11/21/00 5 BB265B 1215.9 0,80400 S 977.5B 977.5B B7151.9 $ 60 068.7B 60 729 0.74408 11/21/00 5 882659 2314.5 0.80400 1 8BO.B6 1 860.86 69 466.4 81 929,64 B3 043 0.74575 11/27/00 S 882660 2132.6 O.B0400 $ 1714.61 1714.81 71 599.0 83 844.25 6517B 0,74721 11/27/00 5..J 4000.0353 1 B 733.0 0.70941 $ 12940.5B $ 34B.7B 13289.34 90 332.0 7B 933.59 103 909 0.74039 11/26/00 S 882881 1782.5 O.B0400 $ 1433.13 1433.13 92114.5' 7B 368.72 105 692 0.74147 11/28/00 S 882662 1729.9 0.B0400 $ 1 390.84 $ 1 390.84 93844.4 $ 79757.56 107421 0.74247 11129100 S 882663 2 256.5 0.60400 $ 1814.23 1814.23 96 100,9 $ 81571.78 109878 0.74374 11130100 S 882864 2337.3 0.79400 $ 1 855.82 $ 1 655.82 96 43B.2 $ 83 427.60 112015 0.74479 11/30100 End of month $ 47,136.99 63.289 4B,726 0.74479 12102100 S 882666 1760.7 0.79400 Is 1 398.00 1 398.00 100 198.9 $ 4B.534.99 65 050 0.74612 121041OO S 882666 207B.l 0.79400 S 1850.01 1850.01 102277.0 $ 50185.00 6712B 0.74760 12105100 5 882687 2352.8 0.80400 Is 1891.65 $ 1891.65 104 629.B $ 52 07B.65 694Bl 0.74951 12106100 S 882668 19992 0.80400 $ 1 607.36 i. 1807.36 108 629.0 I S 53 884.01 71460 0.75104 12107/00 S 882689 2 "9.9 0.B4400 $ 1 882.04 $ 1 882.04 108 858.9 !; 55 586.04 73710 0.75385 12109/00 S 882670 22Bl.6 0.86400 $ 1971.30 $ 1971.an 111140.5 57537.34 75 992 0.75715 12112100 5 882699 1943.0 0.89600 $ 1 740.93 $ 1 740.93 113083.5 $ 59 27B.27 77 935 0.76062 12113/00 5 682700 2152.7 O.B9600 1 92B.82 1 92B.82 115 236.2 61 '07.09 80 OB7 0.76426 12116/00 5..J 400Q.0434 lB835 0.74319 $ 138472B $ 350.87 $ 13997.95 134 071.2 $ 75205.04 98 922 0.76024 12120100 882701 1000.1 0.95800 95B.l0 956.10 135 071.3 $ 7B 181.14 99 922 0.76220 12131100 5..J 400Q.0466 9100.0 0.74319 8 593.59 $ 169.42 6.783.01 144 171.3 I S 82924.15 109 022 0.76062 12/31/00 End of nionth $ 43,961.50 57,797 51,225 0.76062 01/02101 Se.13 4001-0009 9439 1.01109 9367.92 $ 175.74 I!; 9543.68 153 610.3 1$ 53505.16 67 ?38 0.79578 01/03101 S 882702 1.2Q0.2 1.08800 $ 1 303.42 Is 1 303.42 154 Bl0.5 Is 54 608.58 B8 437 0.80087 01/10/01 S B82703 1,002.0 1.03800 $ 1 O3B.07 I. 1 O3B.07 155 812.5 1$ 55 846.65 B9 439 0.80426 01/17/01 5 B62704 1002.0 1.02800 $ 1 028.05 Is 1 028.05 15B 814.5 $ 56 B74.70 70441 0.80741 01/05101 Seal 4001.0508 9100 1.01109 . 9031.4B I !; 169.42 $ 9 '00.90 185 914.5 $ 68 075.60 79541 0.83072 01/17/01 5..l 4001.0111 9396 1.01109 S 9325.25 I S 174.93 $ 9.500.18 175310.5 $ 75575.78 88 937 . 0.84977 01124101 5 534317 1200.9 0.99600 1196.10 $ 1196.10 17B511.4 S 78771.88 90137 0.85172 01/29101 5..J 4001.0243 30574 0.98733 S 29 BI7.29 $ 569.22 S 30168.51 207 085.4 S 108 95B.39 120711 0.8.8807 01/31/01 End of month $ 49,678.49 56,066 64,645 0.88607 02114/01 5 882705 1200.B 0.81800 $ 979.89 $ 979.89 2082BB.0 Is 50658.18 57267.0 0.88480 02114/01 S..J 4001-<>336 28711 0.7B227 21 885.54 $ 21 885.54 236 997.0 $ 72.543.72 85 978.0 0.84375 02128101 5 882708 1021.2 0.77600 I $ 792.45 $ 792.45 236 01B2 , $ 73.338.17 86 999.2 0.84295 02128101 236.01B.2 $ 32,772.37 38,118 48,121 0.84295 03108/01 Seal 4001-0439 18 B78 0,67621 $ 12417.39 $ 348.18 I S 12765.57 256 896.2 $ 45537.94 57756.2 0.78845 03128101 SeaJ 4001-0508 9439 0.67821 $ 6208.70 $ 174.09 $ B 382.79 268 335.2 $ 51920.73 67 195.2 0.77289 03l2B/()1 5..J 4001.0508 9917 0.67B21 $ 6.523.11 $ 182.91 Is B 708.02 27B2522 $ 58628.74 77112.2 0.78028 03107101 5 882707 6512 0.72800 $ 472.77 $ 472.77 276 903.4 $ 59099.51 77 763.4 0.75999 03121101 5 882708 1503.5 0.7??oo 1081.47 I. 1081.47 27B 408.9 $ 60 160.98 79266.9 0.75897 Ad 4001-0439 NJA NJA $ (552.80 $ 1552.80 278.408.9 $ 59B08,18 79286.9 0.75200 03/31101 End of month $ 23,234.56 30,897 48,369 0.75200 04/18101 Seal 4001-0508 NJA NJA 1$ 1109.B7 1$ 1109.87 278408.9 $ 24344.43 30897.4 0.78791 04/18101 Seal 44324 NJA NJA $ 1179.79 1$ 1179.79 278408.9 $ 24 184.84 30897.4 0.78209 0411001 Seal 4001-0243 NJA NJA $ 113.63 1$ 113.83 27B 408.9 S 24151.01 30897.4 0.78185 04/16101 Sea3 4001.0566 19226 0.68361 $ 12788.56 $ 354.80 I $ 13143.1B 297 832.9 S 37294.17 50 123,4 0,74405 04130101 E.... of monch $ 6,157.30 1,275 41,848 0.74405 05102/01 Sea3 4001.0813 19925 0.85201 t 12623.88 $ 367.49 1$ 12991.37 317 557.9 $ 19 148.67 28 200.4 0.87902 05108/0 1 Seal 4001.0243 S 193.42 1$ 193.42 317 557.9 $ 19342.09 28,200.4 0.68588 05/10101 Sea3 4001.0835 10.006 0.65201 $ B 339.50 1$ 184.55 $ 6524.05 327 563.9 $ 25866.14 3B,208.4 0.67701 05121101 Ad' 4001.0508 NJA NJA $ 169.41 $ $ lB9.41 327 563.9 $ 28,035.55 3B 208.4 0.68144 OS/21/01 Adi 4001.0336 NJA NJA $ $ 534.53 $ 534.53 327 563.9 $ 26570,08 38 206.4 0.89543 05121/0 1 Sea3 4001.0662 19140 0.85201 $ 12,12B.53 $ 353.03 $ 12479.56 346,703.9 39.049.64 5734B.4 0,68094 05/31/01 End of month $ 12,010.76 17,638 39,708 0.68094 08/01/0 1 Sea3 I 19718 0.61411 $ 11745.~? ! 363.B7 I $ 12109.09 366 421.9 $ 24 119.85 37,356.4 0.84567 06130/01 End of month .. $ 3,699.30 5,729 31,627 0.64567 07103/01 Sea3 14001-0812 : 32464.B3 63722.4 0.50947 07131/01 End of month 18,176.56 35,677 28,045 0.50947 08115/01 Sea3 14001.0926 39 142.61 75 266 0.52004 08131/01 Resource 200109.5101 19,140 0.49928 $ 9.555.90 o $ 9555.90 4B3 145.9 $ 48,698.51 94 408 0.51583 08/31/01 End of month j, $ 33,812.74 65,550 28,858 0.51583 I FYTD Totals 483146 0.70849 $ 335177.01 $ 7128.38 $ 342305.39 CSW:09/17/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 10/01/73 Non-Utility Taxable FuellTherm ~ SMF MMF NA (1 - NA (4 + 3 Units) Units) $7.00 $15.00 $0.580 $0,580 0.140 NA(4 + Units) $20.00 $0.580 0.140 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR OCTOBER 1, 2001 - MARCH 31, 2002 BASED ON APPROVED GAS ADJUSTMENT FACTORS LMF NA(4 + Units) $50.00 $0.580 0.140 0.140 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 $0,720 $0.720 $0.720 $0.720 $1.340 $1.340 0.620 0.620 0.620 0.620 $1,340 $7.00 $15.00 $1.340 $20.00 $50.00 Firm Natural Gas Rate Schedules sas MaS Las RAC GAC LAC o - 18,000- 17,999 99,999 $15.00 $20.00 100,000 & up $50.00 $0.350 $0,490 $1.110 $50.00 NA (1 - NA (0 - NA (150 3 Units) 149 tons) tons & +) $7.00 if $15.00 if not prevo not prevo billed billed $0.200 $0.150 $15.00 if not prevo billed $0.100 0.140 0.000 0.000 $0.240 0.620 $0,860 $7.00@ $15.00@ $15.00 @ premise premise premise $15.00 $0.200 $0.340 $0.960 $15.00 + FAC ~ SL w/M& ReliQht NA NA NGV Interr. NG Rate NSS ---1L NA NA 100,000 & up $0.470 $0.410 0.140 0.140 0.140 $15,00 $7 Resl.! $15 GS if not prevo billed $0.300 $0.100 0.140 0.140 0.140 $25.00 $100.00 0.140 0.140 0.000 0.000 0.000 0.000 0.000 0.000 $0.470 $0.280 0.000 0.000 0.000 0.000 $0.610 $0.550 0.620 0.620 $1.230 $1.170 0.000 0.000 0.000 0.000 0.000 0.000 0.140 NA $15.00 $20.00 $0.340 $0.290 $0.440 $0.240 0.620 0.620 0.620 0.000 NA 0.620 0.620 0.620 $1,060 $0,860 $15.00 $7 Resl.! +FAC $15GS@ premise + FAC 0.000 0.000 $0.960 $0.910 $0.610 $0.280 0.620 0.540 $1.230 $0.820 $25.00 $100.00 + FAC + Non.Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.226 $ 1.226 $ 1,226 $ 1.226 $ 1.125 $ 1.071 $ 1.016 $ 0.878 $ 0.833 $ 0787 $ 0.878 $ 0.970 $ 0,787 $ 1,125 $ 0.750 $ 1.300 $ 1.300 $ 1.300 $ 1.300 $ 1,193 $ 1.135 $ 1.077 $ 0.931 $ 0.883 $ 0.834 $ 0.931 $ 1.028 $ 0.834 $ 1.193 $ 0.795 $ 0.050 $ 0.050 $ 0.050 $ 0.050 $ 0.050 $ 0.050 $ 0.050 $ 0.050 $ 0.050 $ 0,050 $ 0.050 $ 0,050 $ 0.050 $ 0.050 $ 0.030 3.9% 3.9% 3.9% 3.9% 4.2% 4.5% 4.7% 5.5% 5.8% 6.2% 5.5% 5.0% 6.2% 4.2% 3.8% $0.069 $0.069 $0.069 $0.069 $0.551 $0.551 $0.551 $0.551 BTU FACTOR = THERMS/100 CUBIC FEET ICCFI Firm Service Rates Interruptible Service Rates 10/01 11/01 1.059 1,039 12/01 01/02 $0,069 $0.069 $0551 $0.551 02/02 03/02 $0.069 $0.551 $0,069 $0,069 $0.069 $0,551 07/02 $0.069 $0.551 $0.069 $0.069 $0.069 $0.055 Attach ment #6 Contract Na Rate ~ NA By Contract -- By Contract NA NA 0.000 Contract + $0 000 Plus 0.540 $0.540 + Non.Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms ..-. $ 0,030 5,9% $0.069 $0.471 $0.551 $0.551 04/02 05/02 06/02 $0551 $0.551 08/02 09/02 $0.551 $0.485 CSW:09/17/01 Attachment #7 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 OCTOBER 1, 2001 - MARCH 31, 2002 BASED ON APPROVED GAS ADJUSTMENT FACTORS Contract LP Svc. RLP MLP GLP LLP LPV LPS CLP Applicable Annual Gallon Range NA NA 0- 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 EnerQV CharQes/Gallon: prevo billed @ --.ol 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.130 0.130 0.130 0.130 0.130 0.130 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.530 $1.530 $0.330 $0.280 $0.230 $0.520 By Contract + $0.000 Purchased Gas Adjustment/Gallon 0.550 0.550 0.550 0.550 0.550 0.550 0.550 Total Energy Charges/Gallon $2.080 $2.080 $0.880 $0.830 $0.780 $1.070 $0.550 + 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.389 $0.389 $0.389 $0.389 $0.389 $0.389 $0.389 Change from 10/99 Gallon Rate % Change from 10/99 Gallon Rate $ 0.066 3.3% $ 0.066 3.3% $ 0.066 8.1% $ 0.066 8.6% $ 0.066 9.2% $ 0.066 6.6% $ 0.0% CSW:09/17/01 Attachment.#7 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 OCTOBER 1, 2001 - MARCH 31, 2002 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 .... 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 EnerQV CharQes/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 ConseNation Adj.lGallon 0.130 0.130 0.130 0.130 0.130 0.130 0.130 0.130 0.130 0.130 0.130 0.130 NA Environm'llmposition Adj.lGallon - - - - - - - - - - - - NA Weather Normalization Adj.lGallon - - - - - - - - - - - - 0.000 - Total Non-Fuel ChargeslGallon $ 1.430 $ 1.280 $ 0.830 $ 0.730 $ 0.830 $ 0.730 $ 0.730 $ 0.630 $ 0.630 $ 0.630 $ 0.330 $ 0.280 Set By Contract + 0.000 Purchased Gas Adjustment/Gallon 0.550 0.550 0.550 0.550 0.550 0.550 0.550 0.550 0.550 0.550 0.550 0.550 0.550 - - Total Energy Charges/Gallon $ 1.980 $ 1.830 $ 1.380 $ 1.280 $ 1.380 $ 1.280 $ 1.280 $ 1.180 $ 1.180 $ 1.180 $ 0.880 $ 0.830 0.550 + Contract NFE Note: No Monthly Minimum Bill Utilitv Tax Note: Fuel Rate per Therm 10/01/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuelfTherm 0.389 0.389 0.389 0.389 0.389 0.389 0.389 0.389 0.389 0.389 0.389 0.389 0.389 Change from 10/99 Gallon Rate $ 0.066 $ 0.066 $ 0.066 $ 0.066 $ 0.066 $ 0.066 $ 0066 $ 0.066 $ 0.066 $ 0.066 $ 0.066 $ 0066 $ - % Change from 10/99 Gallon Rate 3.4% 3.7% 5.0% 5.4% 5.0% 5.4% 5.4% 5.9% 5.9% t:; QO/" Q 10L n <'0 ~