Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MARCH 1, 1999
I I RFCEIVED M '::; (1.1.. 1999 CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: CITV CU.:;~tK DE-Pl: FROM: COPIES: Rick Hedrick, Deputy City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Laura Damico, Accountant/CCS-LP SUBJECT: GAS ADJUSTMENTS EFFECTIVE March 1, 1999 DATE: February 25r 1999 The unseasonably warm weather this Fall/Winter continues to taken its effect on our Natural Gas Purchased Gas Adjustment (PGA) recovery, Lower than expected therm sales have caused us to fall behind in our coverage of the fixed pipeline charges; however, our NG PGA increase last month seems to have stabilized this recovery clause, Therefore, we are not recommending any change in our Natural Gas PGA rates. AdditionallYr the connection of the newall-gas units in the Wellington & Grand Reserve projects have impacted the balances in the Energy Conservation Adjustment (ECA) clause; however, our increase in this rate component last month seems to have properly positioned this recovery clause by fiscal year-end. Our other adjustment clauses are also within planning ranges; therefore, no changes in our adjustment clauses are DroDosed at this time, It should be noted thatr even with the increases of since the first of the year, our Residential Natural Gas rates are 3C/therm below our rates of last March. That is a reduction in our rates for a typical residential customer of nearly 3 % from last winter's rates! Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after March 1, 1999: Natural Gas Firm Standard Rate Schedule PGA ,....., $0.415 per therm (no change) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ..........,.. $0,310 per therm (no change) Propane (LP) Gas Rate Schedule PGA ......,..........,.. $0.450 per gallon (no change) = $0.492 per therm equivalent (no change) Energy Conservation Adjustment (ECA) .............., $0,060 per therm (no change) = $0,055 per gallon of LP (no change) c1{- / 02 - 0/ ( ) Mike Roberto, City Manager I Page 2 I February 25, 1999 Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) = $0.000 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... $0.000 per therm (no change) = $0.000 per gallon of LP (no change) Attachment #1 shows the CGS Summary of Rate Adjustment Clause collections, which are currently in surplus by a total of $76,239.45. Please note that this balance has fallen by $473,686.88 since the beginning of the fiscal year, which has had a significant negative impact on our bottom line financials this year. This represents over half of our total fiscal year-to-date losses. Also note that the positive Total Adjustments balance includes $370,726.56 remaining in Environmental Imposition Adjustment (EIA) from the Manufactured Gas Plant insurance claim settlements. So, without EIA, we are behind in our adjustment clause collections this year by $294,487.11, which is the reason for the increases we have made in these clauses since the 1 st of the year. Please note that our projections show our turning this around in February with an anticipated $34,591.82 improvement in our overall adjustment clauses balance. Attachment #2 shows our Natural Gas cost projections, and Attachment #3 shows our history of LP Gas supply costs and projections for FY 98/99. Finally, Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. These later 2 are unchanged from last month with the exception of the updated March therm factor. It is our plan to use the above-proposed adjustments for billings through March 31, 1999, (with the exception of WNA discussed below) 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. You should also note that we will be presenting you with a proposed Gas Adjustments Letter Effective March 8, 1999, which will include the impact of early implementation of our Weather Normalization Clause, assuming the City Commission approves our gas rate revisions on 2nd reading on March 4th. Mike, I would appreciate your approval of these 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 March 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments ) Approved: Mike Roberto, City Manager - U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for March 1999.doc CSW:02/25/99 I I CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS I I NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NG) Monthly Cumulative Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Month Charges Ch_lIrges Expense Expenses Expenses Billed (Shortage) (Shortage) Prior Year $ - $ 133,245.29 Oct-98 $ 122,653.20 $ 272,024.65 $ 13,730.35 $ 408,408.20 $ 381,760.84 $ (26,647.36) $ 106,597.93 Nov-98 $ 159,667.40 $ 343,993.96 $ 15,650.30 $ 519,311.66 $ 434,908.27 $ (84,403.39) $ 22,194.54 n"p'ec-9~-!_~65,041E _~_~,_~3,021.57 $ 17,966.76 $ 606,030.10 $ 478,176.25 $ (127,853.85) $ (105,659.31) Jan-99 $ 166,415.65 $ 425,096.35 $ 528.30 $ 33,100.22 $ 625,140.52 $ 622,008.17 $ (3,132.35) $ (108,791.66) Feb-99 $ 150,000.00 -r---- 530:000.60'$ ---55ilOO-~$--20,OOO~00- $--700,550.00 $ 698,725.00 $ (1,825.00)1--$ (110,616.66) __,. ,_ ___ _n._ ,_ ___~__ Mar-99 ,$ ,)~I,QOO.OQ. t __ ~3Q.QQQ:QQ_ $ ___~OO.go $ _ 20!000:PQ J~!7-,-~20.Q.Q_ $ 754,852.50 $ 37,552.50 $ (73,064.16) Apr-99 $ 161,000.00 $ 460,000.00 $ 300.00 $ 20,000.00 $ 641,300.00 $ 640,372.50 $ (927.50) $ (73,991.66) -May:SS- i--C-SO:ooo~o6f-' -- 430:000.00 f---'so:oo -$-20:60'6:00- '$--54o.-050.0(f~5S8.09o.00- -$--18,040.00 $ (55,951.66) -'Jun-99 $ 87,000.06--$--400,000.66 ~----~$2O:ooo.60 $-S07,OOo.oo i---518,73750 $-'11,737:56- 'r (44,214.16) Jul-99 $ 90,000.00 $ "350,060.00- ~-'----i 20,000.00 $ 460,000.00 $ 479,385.00 $ 19,385.00 i~4,829.16) Aug-99 $ 90,000.00 $ 330,000.Q~_ $ 20,000.00 $ 440,000.00 $ 475,807.50 $ 35,807.50 $ 10,978.34 Sep-99 $ 87,000.00 $ 330,000.00 $ 20,000.00 $ 437,000.00 $ 486,540.00 $ 49,540.00 $ 60,518.34 TotalYTD $1,535,778~'62$--' 4,824,136.53 $ 1,728.3Cf' $ 240,447.63 $ 6,602,090.48 $ 6,529,363.53 $ (72,726.95) Note (1) Note (1) - Amount differs from cost center 2078 on the Statement of Revenue & Expenditures by the amount in taxes. PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) Attachment #1 Page 1 of3 NG PGA RatelTherm FirmlContr .375/.270 .375/.270 .375/.270 .405/.300 .415/.310 .405/.300 .405/.300 .405/.300 .405/.300 .405/.300 .405/.300 .405/.300 - Monthly Cumulative LP PGA Budget Gallons Monthly Prepaid Commodity Total LP Fuel Total LP PGA Overage YTD Overage ThermlGal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) Prior Year $ - $ 8,750.00 $ - $ 8,750.00 $ (8,750.00) $ 1,961.06 Oct-98 25,822.30 $ 0.38826 $ (1,790.10) $ 10,025.77 $ 8,235.67 $ 11,618.49 $ 3,382.82 $ 5,343.88 .492/.450 ~---- .---- Nov-98 33,281.20 $ 0.43852 $ (1,157.98) $ 14,594.47 $ 13,436.49 $ 14,974.35 $ 1,537.86 $ 6,881.74 .492/.450 . '-~~' Dec-98 37,883.40 $ 0.44613 $ (1,800.05) $ 16,900.92 $ 15,100.87 $ 17,044.44 $ 1,943.57 $ 8,825.31 .492/.450 ._-, Jan-99 42,490.89_ _~ 0.45947 $ (900.05) $ 19,523.25 $ 18,623.20 $ 18,904.2~ $ 281.05 $ 9,106.36 .492/.450 Feb-99 44,000.00 $ 0.46327 $ (2,000.091 $ 20,383.88 $ 18,383.88 $ 19,800.00 i 1,416.12 $ 10,522.48 .492/.450 Mar-99 46,000.00 $ 0.45500 $ (1,100.00) $ 20,930.00 $ 19,830.00 $ 20,700.00 $ 870.00 $ 11,392.48 .492/.450 - ~--- $ - ------. -~- Apr-99 42,000.00 $ 0.45000 - $ 18,900.00 $ 18,900.00 $ 18,900.00 $ - $ 11,392.48 .492/.450 May-99 37,000.00 $ 0.45000 $ - $ 16,650.00 $ 16,650.00 $ 16,650.00 $ - $ 11,392.48 .492/.450 Jun-99 31,000.00 $ 0.45000 $ - $ 13,950.00 $ 13,950.00 $ 13,950.00 $ - $ 11,392.48 .492/.450 Jul-99 31 ,000.o.~ $ 0.45000 $ - $ 13,950.00 $ 13,950.00 $ 13,950.00 $ - $ 11,392.48 .492/.450 Aug-99 31,000.00 $ 0.45000 $ - $ 13,950.00 $ 13,950.00 $ 13,950~QQ.. $ - $ 11,392.48 .492/.450 Sep-99 33,000.00 $ 0.45000 $ - $ 14,850.00 $ 14,850.00 $ 14,850.00 -$ - $ 11,392.48 .492/.450 Total YTD 434,477.70 $ 0.44791 $ 1.82 194,608.29 $ 185,860.11 $ 195,291.53 $ 9,431.42 --'--- LP purchases in gVnot billed $ - $ - $ - G/L amount 194,608.29 $ 185,860.11 $ 11,392.48 ----.. ," -- _"___________ f------, Page 1 U:\wIndowslmsollice\excel\gast9(sheet recovery) Attachment #1 -...---- Page 2 of 3 ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptional1t Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ 33,056.99 Oct-98 $ 27,698.94 Other promo 27.2K $ 27,698.94 $ 24,350.25 $ (3,348.69) $ 29,708.30 .040/.037 Nov-98 $ 71,805.77 Other promo 71.8K $ 71,805.77 $ 27,863.12 $ (43,942.65) $ (14,234.35) .0401.037 Dec-98 $ 36,624.30 Mailing 2.85K, Other promo 33.8K $ 36,624.30 $ 32,289.31 $ (4,334.99) $ (18,569.34) .040/.037 Jan-99 $ 217,062.90 Winter Pari< 85.8K,Wilson 100.8K $ 217,062.90 $ 40,830.43 $ (176,232.47) $ (194,801.81) .040/.037 Feb-99 $ 25,000.00 $ 25,000.00 $ 71,000.70 $ 46,000.70 $ (148,801.11 ) .060/.055 Mar-99 $ 25,000.00 $ 25,000.00 $ 72,155.40 $ 47,155.40 $ (101,645.71) .060/.055 Apr-99 $ 25,000.00 $ 25,000.00 $ 61,375.80 $ 36,375.80 $ (65,269.91) .060/.055 May-99 $ 25,000.00 $ 25,000.00 $ 53,511.30 $ 28,511.30 $ (36,758.61) .060/.055 Jun-99 $ 25,000.00 $ 25,000.00 $ 49,551.90 $ 24,551.90 $ (12,206.71) .060/.055 Jul-99 $ 25,000.00 $ 25,000.00 $ 45,921.90 $ 20,921.90 $ 8,715.19 .060/.055 Aug-99 $ 95,000.00 $ 95,000.00 $ 45,591.90 $ (49,408.10) $ (40,692.91) .060/.055 - Sep-99 $ 25,000.00 $ 25,000.00 $ 46,691.70 $ 21,691.70 $ (19,001.21 ) .060/.055 Total YTD $ 623,191.91 $ - $ 623,191.91 $ 571,133.71 $ (52,058.20) ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptional It Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ - $ 372,913.00 Oct-98 $ 405.89 Legal $ - $ 405.89 $ - $ (405.89) $ 372,507.11 .000/.000 Nov-98 $ - $ - $ - $ - $ 372,507.11 .000/.000 Dec-98 $ 1,663.05 Legal 0.6K, ECT 1.1 K $ 1,663.05 $ - $ (1,663.05) $ 370,844.06 .000/.000 Jan-99 $ 117.50 Legal $ 117.50 $ - $ (117.50) $ 370,726.56 .000/.000 Feb-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 359,726.56 .000/.000 Mar-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 348,726.56 .000/.000 Apr-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 337,726.56 .000/.000 May-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 326,726.56 .000/.000 -" Jun-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 315,726.56 .0001.000 ----.-..------..-.- -- ---,.----- -~--~- --.-------.- --- $ $ $ 304,726.56 Jul-99 $ 11,000.00 $ 11,000.00 - (11,000.00) .000/.000 Aug-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 293,726.56 .000/.000 Sep-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 282,726.56 .000/.000 --=-- $ 10,000.00 $ 10,000.00 $ $ (10,000.00) $ 272,726.56 .000/.000 Sep-9~_ - -$106~186:44 -, ,~ ---------.--.-.---.-. ----------- Total YTD $ - $ 100,186.44 $ - $ (100,186.44) f-' - - Page 2 U:\windowslmsolflCe\excel\gasf9(sheet recovery) or I I '0 M ~ CD 01 ., III ~ 0.. i .c: .. ( .. :i! ~ll. 8 N N N N N N N N N N NN )( M M M M LO LO LO LO LO LO LO LO ~ S CD...I Ll':! Ll':! Ll':! Ll':! Ll':! LO LO Ll':! Ll':! LO Ll':!Ll':! 8 .c _ \0 \0 \0 \0 \0 it5 it5 \0 \0 it5 lOin IE ~ .....0 0 =Z ~ ..... ..... ~ I"- co co co co co co co .. cC '<I: '<I: '<I: '<I: '<I: '<I: '<I: '<I: '<I: '<1:1 .s I ~ ." ~ N ~ N LO l"- I"- l"- I"- l"- I"- I"- I"- i c: CIl . j CIl 01 'i' N I"- "'" ~ ..... "'" I"- ..... 0 "'" .....1 ~ CIl 'i' > cO r-.: en ci en en r-.: 00 00 Il'i ~icO I , I I , , I , , , , , , :; ~ I! CIl I"- LO ~ ~ M C;; 0 LO 0 en 0 I M I ~ I! CIl l\I CD 1! ..... ..... N co "'" co "'" co 0 ""'Ico' l\I . 1! 'E ~ ~ ,...: Lri cD ci Lri 0) Lri ci ci . .1 'E ~ E 0 ~ ~ co LO I"- ..... co 0 "'" I"- 0 ~I~i i E 0 c .c LO M N ..... ..... N N N M N(W')! ~ .c ~ ~ ~I~! I ~ ~ ~I~ 0 ~ 0 ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ S N (ON r:::- N 0 0 010 0 ~!~Ir:::- ! 'i' 0 ...... ..... M ~ ~ en M M"", en ~I"':I-r: I 'i' , , , , , , , , , , , , , >oCll CIl ci en 0000 ..... a; r-.: 00 -r=oi 8 8 C;;;~I >0 . CIl I -'CIl LO 0 00 0 I"- ~ LO co 5 CIl = II! 1! r-- ~I~ N LO LO LON M CO.IN., N.. I! 1! I c CIl ~ ,...: 0) ~ ~ ~ LriLri 0) ""'101""'1 c . I I o > 0 ~ N M l"- I"- N M N N N COlT"'" 0 > 0 I I I :E1O .c ..... ..... :s ~I iN :E 0 .c ~ ~~ ~ ~ ~ ~~ ~ ~ ~ ~ ~~ ~ ~I~!: ~ ~ ~ ~~I~ 6C)IM:t.4 ~ ~ ~ ~ i ~ co "'" 0 LO 0 0 0 0 0 0 010:1"- I I I , LO I"- 0 co I"- en M ~ "'" en ~ ~!:;S I i CD en Il'i ci N Il'i r-.: 00 ..... en cO I I > N "'" ..... "'" N 0 ~ LO M LO ~ COiCO 0 "0 r-- r-- LO r--. LO r-- N N N "'1:il!:6 u :! ,...: ,...: ,...: co 0) ,...: ci <<i N 0) ~ CIl a: ~ l"- N co ~ N N co M ~ ~l~ . I iii "'" LO co I"- r-- co LO LO I"": .c S i 0 ..... I I ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~i~i~ ~ 0 0 N N N co 00 o 018 olol~1 I M 0 I"- en M ..... co 00 C! C! . C!IC!I . CD In ci 00 C"i 00 ~ C"i cici , 01 0000,0 co iii III <( CD LO "'" LO ~ M MO OILO.LO LOILO!1"- ~ 0.. In l"- I"- LO en en ..... N I"- en len en coo I CD s c <<i ! t 0) ci ~ McD NlcDio) 0) "":;0 x CD .l!l Cl. LO co LO I"- en ml:2lgl:2I~:~1 CIl , ~ lC co co co I"- I"-CO (:. .S: ~I w I I 'E ~ ~ ~ ~ ~ ~ ~I~ ~~'~i~i~:~i 0 i ::l Z 0 + i E III ~ C Q) ,g , oS "ii I >- + 0 I .0 ~ a. 1 i I I x I ~ I w ~ ~ O/S ~ i > Q) I , 0::: .. . - I In '" , 0 ~ l! c ~ i . I s Cl. ~ .5 lC C/) I w Cl Q) oS ~ c: I : I '" 0 I c co ,g I , I"- , I "ii 0 N I 0 CD ll. 'E ~ ...I i 8 < I I U; I I 8 i E ! 1 ,g ! l!! i I ~ '0 ~ I 'E ~ i i 5' I I 1 i ~ .... I ~ ... 8?J8? 8? 18? lil~ 0 .. III co co I .. en en en:enlen CIl 5 ~ co en en en en I CIl 5 "ii co co co en len en m~ ~ CIl en en en en en en en CIl en en en en 'en en enl~lenien en c is > 0 C .0 .!. ~ C lD is > o ci.o ~ " " I' 0.1- "0 0 0 III >'1 C - 0)' - "0 0 ... I >-1 c: 1- 01 2 ~ :E 0 0 ~ III Q) :!iE l\Il::l ::l::l'CD1l\I ~ ::E t 0 0 ~,~I~ ~ ~i~I~I~ ~ G)tl! ID 'C Z -. u.. :!iE1-' -'lcC:C/)!o ID z C/)I~ ~ I- 0.. , ,..... I i I ..... : CLEARWATER FYl7198 PURCHASED GAS COST PROJEC'nONS AS OF 2111/99 &u.d on AdI.a DTH'Ii Sold .......- _0 -. -. _81 Conlroct ActuoI P"'-'-' Conlroct Conlroct .,........ A._ A_ NNTlI Pu_ - ~ c.-llv .....- ~ c-.. .....- .....- .....- .....- - .....- ....- 0d-98 .~, 41718 $8.00 I'" . . 15-5011 135 t3. 1.,_ 0 N_ -'70 SH30 $8.00 '23 78 0 22.SOO 144"72 ,.....,22.4. .1055 - 31"-70 55_2 t1 151-.15) 'ZL'" . 31 011O u;a: I" 16Ui,'.s1 .1209 ....." 3"'" ".ill 15 I 354.57) I'" 2 . 46.SOO 200 56 175 ...... 0 - 286 132 49 868 15'157.15) 1]1 .2 0 .. 000 208 011O 20411. 0 Mor-99 316789 55211 ell 170.001 16' 500 0 31 000 211= 209 500 0 _-99 J06 570 53 '30 111 '70.001 165 000 0 22 500 179 000 195000 0 '44 212 -41 788 IS I 170.001 18500 0 12 400 156000 167 500 0 139S60 40 440 11 I I 70.001 29 500 0 10500 "5000 150 500 0 .44 212 41718 11 I 170.001 46 500 0 10850 1 34 000 139 500 . 144 212 41788 151170.001 52500 0 10.850 133000 133 500 0 139 S60 40 440 111 170.001 45 500 0 12 000 136000 134 500 0 T.... 2793 771 570 393 elll 707.87) 1 4~ 092 0 267 600 1 950 828 1913 931 .- ........... - T-. """"'-' NHTll """"'-' ...........T-. ........... C.C._ WACOG WACOG Lood """"'-' - _IIV_ _ n Volu_ R_ _111- "'~ec.o --- Fuel ec.o F.. - Sold F_ TolII _IIV_ .....- .....M_ _nlv_ ...- ...- .....- .....- .....- .....- _Goo -.. .....M_ ..... MonIh f--' Od-'8 W.MU3 SiMJ.14 ...US '34--..07 SS68.3. U'1.437.74 $8.00 ,liU3J.941 ',2:17U1 n.'7 'UI 4t.5no ...."'Ln - 'I1S.MUO rooi.6I ......,3 "UI2.85 'IMI." "'L"2.S0 IS 16.58) , I1:MU7 ,.. 797'" -~ S4.U 37.!2"Ilo '........,.., -- 511U9o.3I ,.... .. ,UI3.00 S4S 035." SS6LJ2 U'" '66.49 UJ4.a7 '1"!Nl.76 ,. !NU9 ,3.34 'UII 4O.lrnI. SS61.....'... ...... 5111.369.53 U.....:J6 5UI6.65 ..S.osUI 5970.36 UOfo...I64.14 5661.2S "uea.n U-.....ll 53.35 p,U 47.13"- $671 79UI Fol>99 5106 771.84 $5.....82 $2 478.00 540 6n.33 5864.40 $505414.54 $661.'5 512662.81 $3 572.07 '3.15 '321 60.15'1. '655 341.71 _.99 $118322.81 $5 794.70 " 829.00 545035.61 $ 1 297.46 $510486.19 $0.00 $14470.44 53 666.25 'UI pn 56-32"10 56n '57.12 A...... SI14461.20 .. 415.67 1 227.50 "2 582.85 $ 1 255.61 "37427.70 $0.00 $11 284.61 SJ "2.50 '3.34 n.07 S4.17" 5597976.25 .......1 $53 2'6.77 .. 602.74 $731.60 $34,086.47 5982.02 5J80 158.12 $0.00 $ 1 0 554.36 $2 931.25 53.01 $2.841 90.05"10 S469 372.95 ...-.1 $51 472.03 <j 689.87 '619.50 SJ2986.91 $950.34 5352 795.53 $0.00 $I <95.99 $2 633.75 53.OS $2.82 83.61'" "39 043.97 luI-99 553 226.77 SJ 313.14 <un.15 534 086.'7 $982.02 5325254.92 $0.00 $I 072.02 $2 441.25 53.011 $2.87 75.00"10 "'4 '78.30 Au..... $53'26.77 53 313.14 $640.15 $34 086.47 $982.02 $322 759.32 $0.00 $I 263.96 $2 336.25 53.1. P.DI 11.71,. '" IM2.70 s-4O SSI 472.03 52 ....07 $708.00 532986.91 $950.34 5230 335.13 $0.00 (1224.01 52 353.75 $3.06 P.l0 74.72'1t "16 672.07 51 043.24...9 "7 399.88 $14690.03 $465269.57 $11 '21.83 54 817 452.30 $ 1 540.79 $ 129 445.50 $34 964.53 SJ.252 61.76"10 56 347 <6J.34 A__ Not.: -- TOl'~od 1--- -~ Volumes .. tt.sed on hkIortaI ~ ~ -.- ed~..ther. FCTlrHKn owt.alkm ... fuel r.es ~ baed on <<tu.l OTH WACOG <<. lotll Reserv..lon Tolol i r~ Thete....-. _ .. bell look bwAld baed on (Vqnt dat&. 1516 Months $924 "'2.66 $2 673 59-4...2 SJ 598 527.08 1 009 572 SJ.564 2nd6_ SS86 555.55 52 162 770.71 -~2 74' 326.26 '20 500 $2.987 TOTAl $1,011.498.21 .. 836 365.13 $6 347 863.34 1 930 072 53.289 800'" 2078 $ 6.347,863.34 $ 3.29 - - ~ ~ ('. -::t- ~ ~ '-\ ~ \' ,4-fhdt ~ 1J;.-5 . . f . P"PANE INVENTORY AND WEIGHTED COST OF GAS IWACOG , - PREPARED BY TERRY NEENAN DATE I 02/11119l1 LP aul>lllied by Ferrellaaa 544-1416 Date Contract Enda 9130/99 J, Scott Hed"" INVENTORY TANK COST OF GALLONS DEUVERED DEUVERED TOTAL NEW DATE WITHDRAW INVENT. WACOG INVENT DEUVERED PRICE INVOICE GAllONS WACOG 9/30/96 32,068,0 0.38826 512,450.76 5 5 16,905 5 0.50044 Conoco Prepay 1014196 41,364 SO.42142 517,431.56 9296 5 0.53590 5 4,990.90 26,201 50.42142 5 8,750.00 10122197 50,363 SO.40499 5 20,396.75 8,999 5 0.32850 5 2,965.17 35200 SO.40499 10/22/97 50,363 SO.41393 5 20,846.70 5 0.05000 5 449.95 35,200 50.41393 5 449.95 10122197 50.363 SO.42818 5 21,564.63 5 0,07977 5 717.93 35,200 SO.42818 5 8,300.05 10122197 59,163 SO.41351 5 24,46423 8800 5 0.32850 5 2,899.90 44,000 SO.41351 10/22/97 59,163 SO.42094 5 24,904.23 5 0.05000 5 440.00 44,000 SO.42094 5 440.00 10122197 59,163 SO.43281 5 25,806.20 5 0.07977 5 701.97 44 000 SO.43281 5 7.860.05 10122/97 88,164 SO.41917 5 26,572.03 9001 5 0.32650 5 2,96583 53,001 SO.41917 10/22/97 88,164 $0.42577 5 29,022.08 5 0.05000 5 450.05 53001 $0.42577 5 450.05 10122197 88164 SO.43630 5 29,740.08 5 0.07977 5 716.00 53001 $0.43630 5 7,410.00 10122197 77,188 SO.42364 5 32,706.23 9002 5 0.32850 5 2,988.16 82,003 $0.42364 10122197 77,188 50.42968 $ 33,156.33 5 0.05000 5 450.10 62 003 $0.42988 5 450.10 10122/97 77,188 $0.43998 5 33,874.41 5 0.07977 5 716.08 62,003 50.43898 5 8,959.90 10130/98 77,188 $0.43898 5 33,874.41 62,003 $0.43898 10130/98 40,673 38,299 50.43898 $ 16,812.54 62,003 $0.43698 11/05198 47,100 SO.44277 $ 20,654.56 8,901 $ 0.32850 5 2,899.93 70,604 $0.44277 11105/98 47,100 $0.44277 $ 20,854.56 $ 0.05000 $ 440.05 70,804 $0.44277 $ 440.05 11/05198 47,100 $0.44277 $ 20,854.56 $ 0.07977 $ 702.05 70,804 $0.44277 $ 6,519.85 11105198 56,100 SO.44483 $ 24,955.04 9,000 $ 0.32850 $ 2,965.50 79,804 $0.44483 11/05198 56,100 SO.44463 $ 24,955.04 $ 0.05000 $ 450.00 79,804 $0.44463 $ 450.00 11105198 56,100 $0.44483 $ 24,955.04 $ 0.07977 $ 717.93 79,804 $0.44463 $ 6,069.85 11105198 65,000 SO.44681 $ 29,042.55 8,900 $ 0.32850 $ 2,932.55 88704 $0.44681 11105198 65,000 SO.44681 $ 29,042.55 $ 0.05000 $ 445.00 88,704 $0.44881 $ 445.00 11105198 65.000 $0.44681 $ 29,042.55 $ 0.07977 $ 709,95 88,704 $0.44681 $ 5,624.85 11/30/98 38,114 26 866 $0.44681 $ 12,012.89 88.704 $0.44881 12/08/98 35,885 $0.45156 $ 16,204.36 8,999 $ 0.33500 $ 3,023.67 97.703 $0.45156 12/08198 35.885 $0.45156 $ 16,204.36 $ 0.05000 $ 449.95 97,703 $0.45156 $ 449.95 12/08198 35,885 $0.45156 $ 16,204.36 $ 0.07977 $ 717.85 97,703 $0.45156 $ 5,174.90 12/08198 44,885 $0.45441 $ 20,396.29 9000 $ 0.33500 $ 3,024.00 106,703 $0.45441 12/08198 44,885 $0.45441 $ 20,396.29 $ 0.05000 $ 450.00 106,703 $0.45441 $ 450.00 12/08198 44,885 $0.45441 $ 20,396.29 $ 0.07977 $ 717.93 106,703 $0.45441 5 4,724.90 12/09/98 53 685 $0,45627 5 24,49506 6,800 $ 0.33500 $ 2,956.90 115,503 $0.45627 12/09/98 53,685 $0.45627 $ 24,495.06 $ 0.05000 $ 440.00 115,503 $0.45627 $ 440,00 12/09/98 53 685 $0.45627 $ 24,495.06 $ 0.07977 $ 701.98 115,503 $0.45627 $ 4.264.90 12/09/98 62,887 $0.45788 $ 28,781.08 9,202 $ 0.33500 $ 3,091.87 124,705 $0.45788 12/09/98 62,887 $0.45788 $ 28.781.08 $ 0.05000 $ 460.10 124,705 $0.45788 $ 460.10 12/09/98 62,887 $0.45788 $ 28,781.08 $ 0.07977 $ 734.04 124,705 $0.45788 $ 3,624.90 12/09/98 71,888 $0.45868 $ 32.973.47 9001 $ 0.33500 $ 3,024.34 133,706 $0.45668 12/09/98 71,888 $0.45868 $ 32.973.47 $ 0.05000 $ 450.05 133,706 $0.45868 $ 450.05 12/09/98 71,888 $0.45868 $ 32.973.47 $ 0.07977 $ 718.01 133,706 $0.45668 $ 3,374.75 12/10/98 90,888 $0.45947 $ 37,165.40 9000 $ 0.33500 $ 3,024.00 142,706 $0.45947 12/10/98 90,888 $0.45947 $ 37,165.40 $ 0.05000 $ 450.00 142,706 $0.45947 $ 450.00 12/10/98 90,888 $0.45947 $ 37,165.40 $ 0.07977 $ 717.93 142.706 $0.45947 $ 2,924.75 12/31/98 50,744 30,144 $0.45947 $ 13,850.19 01105/99 39.544 $0.48097 $ 18.228.42 9,400 $ 0.33500 $ 3.156.40 152,106 $0.48097 01105199 39,544 $0.48097 $ 18,22842 $ 0.05000 5 470.00 152,106 $0.46097 5 470.00 01/05199 39,544 $0.48097 $ 18,226.42 $ 0.07977 $ 749.84 152,106 $0.46097 $ 2,454.75 01105199 46,544 $0.48188 $ 22,420.35 9,000 $ 0.33500 $ 3.024.00 161,106 $0.48188 01105199 48,544 $0.48188 $ 22,420.35 $ 0.05000 $ 450.00 161.106 $0.46188 $ 450,00 01105199 48,544 $0.48188 $ 22,420.35 $ 0.07977 $ 717.93 161,106 $0.46188 $ 2,004.75 01/22/99 57,845 $0.46249 $ 26,752.48 9,301 $ 0.33500 $ 3,125.14 170,407 $0.46249 01/22199 57.845 $0.46249 $ 26,752.48 $ 0.05000 $ 465.05 170,407 $0.46249 $ 465,05 01/22/99 57,845 $0.48249 $ 26.752.48 $ 0.07977 $ 741,84 170,407 $0.46249 $ 1,539.70 01/22/99 66.846 $0.46293 $ 30,944.87 9,001 $ 0.33500 $ 3,024.34 179,408 $0.46293 01/22199 88.846 $0.46293 $ 30,944.87 $ 0.05000 $ 450.05 179,408 $0.46293 $ 450.05 01/22/99 88,846 $0.46293 $ 30,944.87 $ 0.07977 $ 718.01 179 408 $0.46293 $ 1,069.65 01/21119l1 76047 $0.46327 $ 35,230.42 9,201 $ 0.33500 $ 3,091.54 188,609 $0.46327 01/29/99 76,047 $0.46327 $ 35,230.42 $ 0.05000 $ 460.05 188,609 $0.46327 $ 460.05 01/28/99 76,047 $0,46327 $ 35,230.42 $ 0.07977 $ 733.96 188 609 $0.46327 $ 629.90 01/31/99 47 526 28.521 $0.46327 $ 13212.97 02/09/99 37721 $0.46388 $ 17,496.06 9,200 $ 0.33500 $ 3,091.20 197.609 $0.46388 02106199 37,721 $0.46388 $ 17,498.06 $ 0.05000 $ 480.00 197.809 $0.46388 $ 460.00 02106199 37.721 $0.46388 $ 17,498.06 $ 0.07977 $ 733.88 197,609 $0.46388 $ 169.90 02106199 41,113 $0.46418 $ 19,083.78 3392 $ 0.33500 $ 1,145.52 197.609 $0.46418 02106199 41,113 $0.46418 $ 19,083.78 $ 0.05000 $ 169.90 197,609 $0.46418 $ 169.60 02/06199 41,113 $0.46418 $ 19,083.78 $ 0.07977 $ 270.58 197.609 $0.46418 $ (0.00) 02106199 46,721 $0.45405 $ 21,213.51 5806 $0.30000 $ 1,882.40 197,609 $0.45405 02106199 46721 $0.45405 $ 21,213.51 0.07977 $ 447.35 197,609 $0.45405 CSW:02l25/99 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Enel'llY Cha'llefTherm 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 9/98 Therm Rate UtIII1y Tax Note- Fuel Rate per Therm 10/01173 Non-Utility Taxable FuellTherm -.B.S.... ....sML ...MML NA (1 - NA (4 + 3 Units) Units) NA(4+ Units) CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR FEBRUARY 1,1999 - MARCH 31, 1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS -LME... NA(4 + Units) $7.00 $15,00 $20.00 $50.00 $0.580 $0.580 $0,580 $0.580 0,060 0.060 0.060 0.060 0,000 0.000 0.000 0.000 ll..Ollll ll..Ollll ll..Ollll ll..Ollll $0.640 $0.640 $0,640 $0.640 $1,055 $1. 055 ~ ~ ~ ~ $1.055 $7.00 $15.00 $1.055 $20.00 $50.00 Firm Natural Gas Rate Schedules ~ -MGS.... ....LG.S- ...HAC.... ~ ....LAC.... 0- 18,000- 100,000 17,999 99,999 & up $15.00 $20,00 $50.00 $0.350 0,000 ll..Ollll $0.410 ~ $0,825 $50.00 NA(l- NA(O- NA(150 3 Units) 149 tons) tons & +) $7.00 if $15.00 if $15.00 if not prevo not prevo not prev, billed billed billed $0.200 $0.150 0.060 0,060 0.060 $0.100 0.060 -SL... SL wlM& RIlI.lgbt NA NA J:fmL NA Interr. tiG...BiltIl .-NS.S.... ----'L NA 100,000 &up $25.00 $100.00 $0.470 $0.280 0.000 0.000 0.000 0.000 0.000 NA 0.060 NA $15,00 $15,00 $7 Res!.1 $15 GS if not prevo billed $0,300 $0.100 ll..Ollll ll..Ollll ll..Ollll ll..Ollll ll..Ollll ~ $0.200 0,060 0.060 0.060 $0.160 $0.260 $0.360 $0.160 $0.530 $0.280 $0.575 ~ ~ ~ ~ ~ ll.a1ll $7.00 @ $15,00 @ $15.00 @ premise premise premise $0.675 $0.775 $0.575 $0.945 $0.590 $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 0.965 $ 0.965 $ 0.965 $ 0,965 $ 0.865 $ 0.810 $ 0.755 $ 0.618 $ 0.572 $ 0,526 $ 0.618 $ 0.709 $ 0,526 $ 0.865 $ 0.540 $ 1.023 $ 1,023 $ 1.023 $ 1.023 $ 0.917 $ 0.858 $ 0,800 $ 0.655 $ 0,606 $ 0.558 $ 0.655 $ 0.752 $ 0.558 $ 0.917 $ 0.572 $0,470 $0,410 0.000 0.000 ll..Ollll ll..Ollll $0.260 $0.210 ~ ~ $0.675 $0.625 $15.00 + FAC $15,00 $7 Resl./ +FAC $15GS@ premise + FAC $ 0.060 $ 0.060 $ 0,060 $ 0.060 $ 0.060 $ 0.060 $ 0.060 $ 0.060 $ 0,060 $ 0.060 $ 0,060 $ 0.060 $ 0.060 $ 0.060 $ 0.065 $0.069 $0.069 $0.069 $0.069 $0,346 $0.346 $0.346 $0.346 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) Firm Service Rates Interruptible Service Rates 1.O.laa 1.076 1.079 11l9a ~ ltlLa9 0.060 0.060 $0.069 $0.346 $0.069 $0.069 $0.346 $0.346 lML99 ~ ~ $0,069 $0.069 $0.069 $0.069 $0,069 $0.055 m~ m~ m~ m~ m~ m~ ~ ~ ll.9li9. ATTACHMENT #4 Contract NG.Ba1e -C.NL NA By Contract - By Contract NA NA ~ By Contract ll.a1ll $0.310 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms _. $ 0.065 $0.069 $0.241 1.055 1.058 1.080 1.081 1.059 1.059 0,000 0.000 ll..Ollll ll..Ollll $0,530 $0.470 ~ ~ $0,945 $0.885 $15.00 $20.00 $0,069 $0.069 $0.346 $0.346 ~ ~ 1.082 1.085 1.061 1.064 CSW: 0 1/28/99 ATTACHMENT #5 CLEARWATER GAS SYSTEM BTU Factor: ~ Gallons/100 cubic feet (CCF) PROPANE (lP) RATE BilLING FACTORS BTU Factor: 2Aa3 Therms/100 cubic feet (CCF) FOR FEBRUARY 1, 1999 - MARCH 31, 1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS Therm Factor: .Q..915 Therms/Gallon Contract LP Svc. RLP MLP GLP LLP LPV LPS CLP Appl. Annual Gallon (Therm) Range NA NA o - 2,499 Gallons 2,500 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (0-2,287 Therms) (2,288 Therms & Up) - Monthly Customer Charge $7.00 $15.00 $15.00 $20.00 $7.00 Resl. or $25.00 Set By Contract $15.00 GS if not Non-Fuel Energy Charge: prevo billed @ premise Non-Fuel Energy Charge IGallon $0.750 $0.750 $0.390 $0.320 $0.100 $0.390 By Contract /Therm $0.820 $0.820 $0.426 $0.350 $0.109 SO.426 By Contr. Energy Conservation Adj. IGallon 0.055 0.055 0.055 0.055 0.055 0.055 NA (ECA) /Therm 0.060 0.060 0.060 0.060 0.060 0.060 NA Environm'llmposition Adj. IGallon 0.000 0.000 0.000 0.000 0.000 0.000 NA (EIA) /Therm 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon Q.QQQ Q..QOO Q..QOO Q.QQQ Q..QOO Q.QQQ ~ (WNA) /Therm Q.QQQ Q.QQQ Q.QQQ Q..QOO Q.QQQ Q.QQQ ~ Total Non-Fuel Charge/Gallon $0.805 $0.805 $0.445 $0.375 $0.155 $0.445 By Contract /Thenn $0.880 $0.880 $0.486 $0.410 $0.169 $0.486 By Cntr. Purchased Gas Adjustment/Gallon M5Q M5Q .M.SQ M5Q M5Q M5Q M5Q - (PGA) /Therm M92 M92 M92 M92 M92 M92 M92 Total Energy Charges/Gallon $1.255 $1.255 $0.895 $0.825 $0.605 $0.895 $0.450 /Thenn $1.372 $1.372 $0.978 $0.902 $0.661 $0.978 + NF $0.492 +NF 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. Change from 9/98 IGallon Rate $ 0.009 $ 0.009 $ 0.009 $ 0.009 $ 0.009 $ 0,009 $ /Therm Rate $ 0.010 $ 0.010 $ 0.010 $ 0.010 $ 0.010 $ 0.010 $ Note: Utiliy Tax is billed on total LP bill.