Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 1999
I I CLEARWA TER GAS SYSTEM Interoffice Correspondence Shert FROM: .R ~tf"'V. , ..; !} j 1fT! .I.J i\.1 'fr- - < \' iN v 1"\. ' .,u iU) Mike Robertor City Manager J tER {,~ 1 1n ~j99 Chuck Warrington, Gas System Managing Director f"Ty CLt~.::rIJ{ u'!'-' '~::pr Rick Hedrickr Deputy City Manager; Cyndie Goudeau, City Clerk; , CGS & CCS Management Teams; Laura Damico, Accountant/CCS-LP TO: COPIES: SUBJECT: GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 1999 DATE: January 28, 1999 The unseasonably warm weather this Fall 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, Therefore, we must recommend an increase in our Natural Gas PGA rates of another 1 C/therm, Additionally, the connection of the newall-gas units in the Wellington & Grand Reserve projects have impacted the balances in the Energy Conservation Adjustment (ECA) clause necessitating a 2C/therm increase in this rate component, Our other adjustment clauses are within planning ranges; therefore, no other changes in our adjustment clauses are proposed at this time. It should be noted that, even with this increase, our Residential Natural Gas rates are 3C/therm below our rates of last February, That is a reduction in our rates for a typical residential customer of nearly 3% from last winter's ratesl Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after February 1, 1999: Natural Gas Firm Standard Rate Schedule PGA ....... $0.415 per therm (up 1.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ....,....,... $0.310 per therm (up 1,OC/therm) Propane (LP) Gas Rate Schedule PGA .............,...... $0.450 per gallon (no change) = $0.492 per therm equivalent (no change) ,2 ; '- j ~., / () ) I Mike Roberto, City Manager Page 2 January 28, 1999 Energy Conservation Adjustment (ECA) ......, \......, $0,060 per therm (up 2,OC/therm) = $0,055 per gallon of LP (up O,8C/gallon) 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 $279,875,03, Please note that this balance has fallen by $261 r301,31 since the beginning of the fiscal year, which negatively impacts our bottom line financials, This represents about half of our fiscal year-to-date losses, Also note that the positive Total Adjustments balance includes $370r844.06 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 $109,542,75 which is the reason for the increases this month, 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, It is our plan to use the above-proposed adjustments for billings through March 31, 1999, 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, Mike, 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 February 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 February 1999.doc CSW:01/28/99 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS 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 Charges Expense Expenses Expenses Billed (Shortage) (Shortage) Prior Year _____ __ _$~_______ ___________~__ _________ ~_1_~~,245.2~ ~ct~~ $~2~,6~~~~+-~---- 272,024.6~ ______ L 13,7~Q}~,J~0~~0~"-~0_ $___3~1-,-7l)0~~_ Lj~~~!"-3~) ~____1g~,597~3__:~Z~L2J_~___ -~~:~- -~-~~:~~~~~ ~ ~;:~:~:~-~~-----: ~~~~~~~~~ {-1~~~~~~:~:- L~J~~~~~[ 3=-({~~:j~:~ }--(~1:~~~~)h~~~~~~~~ Jan-99 $ 166,200.00 $ 590,000.00 $ 15,000.00 $ 771,200.00 $ 679,725.00 $ (91,475.00) $ (172,700.00) .405/.300 Feb-99 $ 150,000.00 $ 530,000.00 $ 15,000.00 $ 695,000.00 $ 698,725.00 $ 3,725.00 $ (168,975.00) .415/.310 Mar-99 $ 167,000.00 $ 530,000.00 $ 15,000.00 $ 712,000.00 $ 754,852.50 $ 42,852.50 $ (126,122.50) .405/.300 Apr-99 $ 161,000.00 $ 460,000.00 $ 15,000.00 $ 636,000.00 $ 640,372.50 $ 4,372.50 $ (121,750.00) .405/.300 May-99 $ 90,000.00 $ 400,000.00 $ 15,000.00 $ 505,000.00 $ 558,090.00 $ 53,090.00 $ (68,660.00) .4051.300 Jun-99 $ 87,000.00 $ 370,000.00 $ 15,000.00 $ 472,000.00 $ 518,737.50 $ 46,737.50 $ (21,922.50) .405/.300 Jul-99 $ 90,000.00 $ 330,000.00 $ 15,000.00 $ 435,O~0.OQ_~____ 479,3!15.OO ~44,~~~"-OO L_2~~462.5q, _.405/.300 _ AUQ.:~_ $ 90,000.00 $ 330,000.00 $ 15,000.00 $ 435,000.00 $ 475,807.50 $ 40,807.5~_.-!_ 63,270.00 .4051.300 Sep-99 S---S7:00c:fOO $ 330,000.00 $ 15,ooo.0~_ $ 432,000.00 $_ 486,540.00 $ 54,540.00_~_!g810.00 .405/.300 Tot,al YTQ _$~~5~?,~~~}~ $ 4,889,178.95 $ - $ 177,774.33 $ 6,602,515.65 $ 6,587,080.36 $ (15,435.29)f--______ . .---.--___ __.__.u__._..u_ _o. ._.______._______._________ _.. . ____No~e_iL_ ._.. _____._n_u____ ____._._.___.__1-________. _._ __._.____.___.__._ _ _n.__ _ Note (1) - Amount differs from cost center 2078 on the Statement of Revenue & Expenditures by the amount in taxes. - - '-T------- ----_In--------uu-----r----------L:-.- -- ------------- _nu____ ~------------- -- -- --- -----.-. PROPANE ILP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) . . -------~ n Bu~~ Month Prior Year Oct-98 Nov-98 Dee-98 e--.. Jan-99 Feb-99 Mar-99 _,o\pr:-_99 !-1..al-99 Jun-99 Jul-99 Aug-99 Sep-99 Total YTD Gallons --- Sold 25,822.30 33,281.20 37,883.40 44,000.00 33,000.00 46,000.00 ___42,000:00 __~-,-QQQ..:2.0 31,000.00 31,000.00 31,000.00 33,000.00 424,986.90 '" Monthly Prepa~____~omm~~ity_ __Total LP Fuel WACOG Expense Charges Expenses $ - $ 8,750.00 $ - $ 8,750.00 $ 0.38826 $ (1, 790.1~) $ 10,025.77 $ 8,235.67 $ 0.43852 $ (1,157.98) $ 14,594.47 $ 13,436.49 $ 0.44613 $ (1,800.05) $ 16,900.92 $ 15,100.87 $ 0.45857 $ (2,000.00) $ 20,177.08 $ 18,177.08 $ 0.46500 $ (2,000.00) $ 15,345.00 $ 13,345.00 $ 0.46000 $ - $ 21,160.00 $ 21,160.00 $ 0.45000 $ - $ 18,900.00 $ 18,900.00 $ - .------ 0.45000 _$_____.__--:-__ $--16.650.00-$-16~650.()O $------0.45000- -$------:-- -$--13~95O:00 -$----13;950:00 $ 0.45000 $ .. $ 13,950.00 $ 13,950.00 $ 0.45000 $ - $ 13,950.00 $ 13,950.00 $ 0.45000 $ - $ 14,850.00 $ 14,850.00 $ 0.44814 $ 1.87 190,453.24 $~181,705.11 LP purchases in gVnot billed G/L amount $ 190,453.24 $ 181,705.11 Page 1 Total LP PGA Billed $ 11,618.49 $ 14,974.35 $ 17,044.44 $ 19,800.00 $ 14,850.00 $ 20,700.00 $ 18,900.00 -$--16~65(fOOu -$----.----13:~f50.06 $ 13,950.00 $ 13,950.00 $ 14,850.00 $ 191,237.28 Monthly Overage __lShortage) $ (8,750.00) $ 3,382.82 $ 1,537.86 $ 1,943.57 $ 1,622.92 $ 1,505.00 $ (460.00) $ - ------- ----------_.-._.~-_."' $ - -$-- -----~--- $ - $ - $ - $ 9,532.17 $ Attachment #1 Page 1 of 3 NG PGA RatelThenn FinnlContr --..- _II ------ Cumulative LP PGA YTD Overage ThennlGal. (Shortage) $ 1,961.06 $ 5,343.88 .492/.450 $ 6,881.74 .492/.450 $ 8,825.31 .492/.450 $ 10,448.23 .492/.450 $ 11,953.23 .492/.450 $ 11,493.23 .492/.450 ~_____~~~~~~~ _:49~:..4~0 _ __ $ 11,493.23 .492/.450 -$ --nOon ,493.23 ----:492/A50 $ 11,493.23 .492/.450 $ 11,493.23 .492/.450 $ 11,493.23 .492/.450 - $ $ 11,493.23 U:\windowslmsotrlCelexcel'<Jas19(sheet racovery) I Attachment #1 ENERGY CONSERVATION ADJUSTMENT (ECA) Page 2 of 3 Monthly Cumulative ECA . Budget Cost Center Interest Total ECA . Total ECA Overage YTD Overage NGlThenn Month Expenses Notes/Exceptional It 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) .040/.037 Dec-98 $ 36,624.30 $ 36,624.30 $ 32,289.31 $ (4,334.99) $ (18,569.34) .040/.037 Jan-99 $ 210,000.00 $ 210,000.00 $ 43,410.40 $ (166,589.60) $ (185,158.94) .040/.037 Feb-99 $ 25,000.00 $ 25,000.00 $ 71,000.70 $ 46,000.70 $ (139,158.24) .060/.055 Mar-99 $ 25,000.00 $ 25,000.00 $ 72,155.40 $ 47,155.40 $ (92,002.84) .060/.055 Apr-99 $ 25,000.00 $ 25,000.00 $ 61,375.80 $ 36,375.80 $ (55,627.04) .060/.055 May-99 $ 25,000.00 $ 25,000.00 $ 53,511.30 $ 28,511.30 $ (27,115.74) .060/.055 Jun-99 $ 25,000.00 $ 25,000.00 $ 49,551.90 $ 24,551.90 $ (2,563.84) .060/.055 . Jul-99 $ 25,000.00 $ 25,000.00 $ 45,921.90 $ 20,921.90 $ 18,358.06 .060/.055 Aug-99 $ 95,000.00 $ 95,000.00 $ 45,591.90 $ (49,408.10) $ (31,050.04) .060/.055 Sep-99 $ 25,000.00 $ 25,000.00 $ 46,691.70 $ 21,691.70 $ (9,358.34) .060/.055 .- IIIl Total YTD $ 616,129.01 $ - $ 616,129.01 $ 573,713.68 $ (42,415.33) ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlThenn 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 $ 1,663.05 $ - $ (1,663.05) $ 370,844.06 .000/.000 Jan-99 $ 8,000.00 $ 8,000.00 $ - $ (8,000.00) $ 362,844.06 .000/.000 Feb-99 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 352,844.06 .000/.000 Mar-99 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 342,844.06 .000/.000 Apr-99 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 332,844.06 .000/.000 May-99 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 322,844.06 .000/.000 - ... Jun-99 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 312,844.06 .000/.000 Ju1-99- $"10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 302,844.06 .000/.000 Aug-99 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 292,844.06 .000/.000 Sep-99 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 282,844.06 .000/.000 Sep-98 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 272,844.06 .000/.000 -- 100,068.94- ~.._---~.- Total YTD $ 100,068.94 L - $ $ - $ (100,068.94) --- -~---"_._-- ---r- ...._---~- -~_._._.-_.,------- ------.------ ..---.----.-..--. --.------ __u__._..__.._... _.___ __m_.'______._ __ ___ ._. '._._.______,__ --.-- -- .------.-----.-.-- -------.-....-. ---- --'.- ---._-.- -.---- -,-.---, - -.---.-- --- - --,------,--_..-..._--. ---- --'---"'---"- ........ ___'_"W___' ---_.-.---..-- --- -....------.-.-... _n________,._.___.___ .---- -------,.~ .----..-- ---~--_..._-_.__._--- -------_.._._----~---- ----------- --.---- ---~- ----------.----. m__.__._ -------._---_.------- - __._u.. -_...-. n n___.__n_ .----- --. ------~-----.~-~ -- --.----- .--..-- . . Page 2 U:\windows\msoffice\excel\gasf9(sheet recovery) I . TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) __ _______ _______ __~on~ly Cumulative Budget T~tal A~_ Total Recovery Overage YTD Overage Month Expenses Billed (Shortage) (Shortage) Prior Year $ 8,750.00 $ - $ (8,750.00) $ 541,176.34 --Oct=SS- -------- ~------~==-_ $ 444,748.70 $ 4172~~_~ (27,019.12) $ 514,157.22 .415/.532 _Nov-9~___________ _____________ .__________ $__~Q4_'~?~:~?_~__~U,745.74 $ (126,808.18) $__ 387,349.0~ _~5/.~3~_ Dec-98 ___________.__ _u____ ... _ .. _ . _______.____._ $__~34.984.01$n___?~!..210..Q.0_ JJ1Q7,4!~:.01} $ 2!9,8T5.()3_ n_.~~?/:532___ ______ Jan-99 $ 1,007,377.08 $ 742,935.40 $ (264,441.68) $ 15,433.35 .445/.532 -Feb=9g-- - --- - __n_n___. ---- _______n__n_______________ -$--n--743)45~OO $ 784,575)6 -$n-41~i3-0.70- $__ 56,664.05 - A75i.S52-- ----- ~ar~9J~-n--------:~~=_=~= ~.. --=---= ==:==:_ J=~7~1~0.00 $ 8~207.90_ _~ 79,54L~_ ~__13~~2f1.9~ - .465/.552 n_~.r:~_9_ _____1--_______ $ 689,900.00 $ 720,648.30 $ 30,748.30 $ 166,960.25 .465/.552 May-99 $ 556,650.00 $ 628,251.30 $ 71,601.30 $ 238,561.55 .465/.552 Jun-99 ._ $ 520,950.00 $ 582,239.40 $ 61,289.40 $ 299,850.95 .465/.552 Jul-99 $ 483,950.00 $ 539,256.90 $ 55,306.90 $ 355,157.85 .465/.552 Aug-99 $ 553,950.00 $ 535,349.40 $ (18,600.60) $ 336,557.25 .465/.552 Sep-99 $ 481,850.00 $ 548,081.70 $ 66,231.70 $ 402,788.95 .465/.552 Total YTD $ 7,499,168.71 $ 7,352,031.32 $ (147,137.39) .--..----- __n ____ _._____ _n.__n___ mn ._______u.______ ___._____ --.- .... -- .- .... ~~~_ER~..~t?R~A~I~ TION- (WNAf -.--.-.-- Budget Month Beg. Bal. Oct-98 Nov-98 Dee-98 Jan-gg --. Feb-gg Mar-99 Apr-99 ~9 Jun-99 Jul-99 Aug-99 Sep-99 Total YTD 1) ---- Interest Expense Rate/Gallon NG Therm& RatelThenn LP Gallons ." $ $ -~------- Amount differs from cost center 2078 on the Stmt of Rev & Exp by the amount in taxes. ---- -.--- ---.------ ~---_. -----. Page 3 Attachment #1 Page 3 of 3 Total All Thenn NG/LP -.. . f--- . . . . -.---.-.-.--. ._n___ f------. Monthly Cumulative Overage YTD Overage (Shortage) (Shortage) $ - $ - $ - $ - $ - $ - - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - -~ $ - $ - $ - $ - $ - _-00_ ________ f---. U:\windowslmsofflce\excel\gas19(sheet recovery) It T'r Ac!+flI€P) r J:F 2...' CLEARWATER FY97198 PURCHASED GAS COST PROJECTIONS AS OF 1/13199 Eoulvolont Bnecf on. Actu.t OTH's SoId__ ~- P..... II ""-In Rollnoulshod P..... II ""-In Controcl A.....I p.......... Controcl Controcl Co....,1lv AvoUoblo Av.la.ble NNTS - Sold Copoclly c_ Por_ CaDocIlv Copoclly Por_ Por_ Per Month Por_ 001"" Per Month Por Month -.-------- ---- ----~~:'~ __"_U_____ _ _~~~-!' ~88 $0.00 __._u_ ___1.3.112_3.1_ --------~ - .__m._~ ~_--'-3~ -~~.!..~:!~ ---- 0 ------- --~~~ 306,570 -- 53AJO ~_-:~...jlO --~- ____-.J~~!.. _._._---_.~ _n_....~ -------1~ t--------1~!!2_~~2 ------~- - -1055 --------- . ------ --. -~~.,~ __1.!~l!g ---_!~!!! ----_..~-~.'~_!~) - .. ~~3l"O8 ____...0 -- ~ _____ ._~.11~ ___._'~88 n_---.!~"'~',~I u___.___..u___ . -------- -_.o- r-. .1209 ~n-99 316789 5S 211 ____tS_~l~!~._~n - --- _ . .----..-!.8_2t~O~ -- ----.-.- --.Q --- -~-~QO 211 000 189 ~~~ -.---- -----.-.- 0 f!b-99 286 '32 49 868 !SlJ.!~7,_~5) - ___~~l~l?O --- --. 0 42.000 208 000 209 500 0 M....99 316789 55211 (51170.001 162500 0 3' 000 211000 209 SOO 0 ""'.99 306 570 53430 <$1170.00) 1~ -- 0 22 500 179 000 195000 0 Mily-99 144212 4'788 <$ 1 170.00) 18 SOQ Or- t--~~ , 56 000 167 500 0 1--- un-99 139 S60 40 440 ($1170.00) 2~ 0 10500 145,000 150500 0 htI-99 144212 41788 ($_l~OO) 46 500 0 10850 134 000 ~~ ~- 0 ------- Au...99 144212 41788 (5 I 170.00) 52 SOO 0 10850 133,000 133500 0 1--- -- -- s.~ 139 S60 40 440 15' 170.001 '5 SOO 0 12 000 136 000 134 500 0 1--- ~~I 2 793 771 570393 (511 707.8n 1414..24 0 167 600 1.961592 1 93] 598 ._- - - - ProIOd8d ~T_. Pro_ NNTS ........... ...........T~. ~ C. C. Poco WACOO WACOO Lood "'-" R_ ....... II v_ Phase II VoIumee R......a.. Phaae III Volumes ~Cool ~.. Fuel Coet F.. Purdlued Sold F_ T_ -- _-ilv_ PerMonlh PwMonth PhM, III Volumes Per Month Per Month Por Month Per Month Por Month Per Month SoldO.. BiIlIno --- _-"",-Pol- Per Month ~- Od-98 $87.65~.21 $2,893.84 5842.l5 $34.08....7 5568.32 $32U37.74 50.00 f'O 2lJ.!lO $Un.sa 53.27 5171 49.s8'llo _.0.8.78 N~ ~5 638.20 52.891.68 584...3 50.58U5 $' 041.64 $42~.so lSl6.58) 511895.17 $2.797'" $4.07 $4.32 37.92'llo 55811.619.89 _.98 119.399.3' $3.5Bl.f6 $1611.00 $45 035.6' $568.32 $396-:266.49 $230...7 $13,59L76 $'.943.29 $U4 fU8 40.07'4 5561,308.26 ~_~n-99 $118369.53 $3 783.3 1 $2 743.50 $45035.61 $900.99 $590 968.01 $0.00 ~93.15 $3 692.50 $3.s9 $3.99 50.97'1. $757 116.65 _99 $106 771.84 $584U2 52478.00 540 677.33 58".40 $507640.58 $0.00 512 662.81 $3 666.25 $3.16 $3.14 62.35'1. $657.567.75 - MM-99 $118311.81 IS 79-4.70 '1 829.00 $45035.61 $ 1 297.46 $510486.19 50.00 $14470.44 $3 666.25 53.21 $3n 56.32'llo $677457.12 ""'-99 $114468.20 $4415.67 $ 1 327.50 50 582.85 $1255.61 ~43?d56.34 50.00 $11284.61 53.4 '2.50 5l.35 $3.08 54.17" $599 904.89 "'~99 553226.77 54602.74 5731.60 534086.47 5982.02 _.___$.381'~4 -r---- jO.!lO__ $ '0.55'.36 $29lI.25 $3.02 $2.81 9O.05'llo $471.1)4.... un-99 $51472.03 $3 689.87 $619.50 532986.91 $950.34 $3S4.350~~ _ _50.00 58895.99 52 6l3.75 $3.0, $2.83 83.61'1. $410 599.13 lu~99 $53 226.77 53 313.14 $640.15 534,086.47 $982.Q2.. r-___$~.?6 314.85 50.00 58 072.02 $2 "41.25 $3.10 $2.88 75.00'- $415 438.2-4 AUR-99 $53226.77 $3313.14 $640.15 ~-~ $982.02 _._-1!.~13 50.00 58 263.96 $2 336.25 Sl.10 f3.08 71.77'- $412 934.52 Sol>99 nJ~_!L472.03 53 418.07 $708.00 532 9l!6.91 --S9ScJ:34 $331411.52 $0.00 57 "4.01 $2353.75 <3.07 f3.1I 74.72'" 5417748.'6 1-. --- ------.- ._--~- $ 1 043 246.49 547 578.83 $lS 016.88 $465 269.57 $11343.46 $4912829.84 5218.29 5131449.88 535247.10 $3.277 62.2'" $6413 762.l5 1--- -- - -- Averue ------ Note: '---. ~- _'!~~~~ _WAl;OC Volu,!!!, .In! twsed ~_~Il_'?:!:~L~~.p~~ wP.lltwr. FGT Ir.Msp oOIlion and fuel rales oOIre based on .Idual -_.- I--.-n--- _______n~ --.----.--,-- DTH ~oved R.n witt r..n. Tol..1 Rese-rvalion Tot.ll Com~itv Co" TMw numbers ~Pf"nl! I iI bell look fOfWilrd bOIW'd on current d.lt.l. 1 Sl 6 Months 5925 269.51 t----~~Z.~8.95 53 686 Q88.47 1 029 240 $3.581 ---- 52.996 2nd 6 Months 5586555.55 $2 171 118.33 52 757673.8' 920 500 ~. ---_._~.- _.- l------. - $ i:s. l-w:06 $3.305 TOTAL $4931937.28 $6 443 762.35 19-49740 -~--- Iud..' 2078 $ 6,443,762.35 $ 3.l0 y - - r I I .J - I PROPANE INVENTORY AND WEIGHTED COST OF GAS IWACOGT . i PREPARED BY TERRY NEENAN i , DATE 01128/tt i I : LP IUDDlled bv FenellD" 644-1411 : Date CDntract End. I13ll19t J. ScolI: H_ I INVENTORY TANK COST OF GALLONS DEUVERED DEUVERED TOTAL NEW DATE WITHDRAW INVENT. WACOG INVENT DEUVERED PRICE INVOICE GALLONS WACOG tI3Q/98 32,068.0 0.38821 S12,450.78 - S 5 16,905 S 0.50044 ConocoPrep lll108 41,364 SO.42142 517,431.58 9,296 S 0.53580 S 4,960.80 26,201 SO.42142 5 8.750.00 101221t7 50,363 $0.40482 S 20,387.75 8.999 5 0.32850 S 2.956.17 35,200 SO.40482 101221t7 50,363 $0.41375 S 20,837.70 S 0.05000 5 449.95 35.200 SO.41375 S 441.95 101221t7 50,363 $0.42801 S 21.555.63 S 0.07977 S 717.83 35.200 SO 42801 5 8.300.05 1D122J17 59,163 $0.41320 S 24.446.43 8,800 5 0.32850 5 2.890.80 44,000 50.41320 101221t7 59,183 $0.42064 S 24.886.43 S 0.05000 S 440.00 44.000 SO.42064 S 440.00 101221t7 59,163 $0.43251 S 25,588.40 S 0.07977 S 701.17 44,000 SO.43251 S 7,860.05 101221t7 68,164 $0.41877 S 28,545.23 9,001 S 0.32850 S 2,956.83 53.001 SO.41877 101221t7 68,164 $0.42538 S 28,995.28 S 0.05000 S 450.05 53.001 SO.42538 S 450.05 10/22117 68,164 $0.43591 5 29,713.28 S 0.07977 5 711.00 53,001 $0.43591 S 7,410.00 1D122J17 77,166 $0.42338 S 32,670.43 9.002 S 0.32850 S 2,957.16 62,003 $0.42338 10/22117 77,166 $0.42921 S 33,120.53 S 0.05000 S 450.10 62.003 50.42921 S 450.1D 101221t7 77,166 SO.43852 S 33,838.61 S 0.07977 5 711.08 62,003 SO.43852 S 6,959.90 101301111 77,166 $0.43852 S 33,838.61 62,003 SO.43852 101301111 40.673 38.299 $0.43152 S 16.794.77 62.003 SO 43852 1110519I 47,100 SO.44221 S 20,828.00 8,801 5 0.32850 S 2,891.13 70,804 $0.44221 111051II 47,100 $0.44221 S 20.828.00 S 0.05000 S 440.05 70,804 $0.44221 5 440.05 111051II 47,100 $0.44221 S 20,828.00 S 0.07977 5 702.05 70,804 50.44221 S 6,519.85 111051ll1 56,100 $0.44420 S 24,919.58 9.000 S 0.32850 S 2.956.50 79,804 SO.4442O 111051ll1 56,100 $0.44420 S 24,919.58 5 0.05000 5 450.00 79,804 SO.44420 111051ll1 56,100 $0.44420 $ 24,919.58 5 0.07977 5 717.13 79,804 50.44420 $ 717.93 1110519I 65,000 $0.44613 $ 28,998.18 8,900 $ 0.32850 $ 2.923.65 88,704 $0.44613 5 5.801.92 111051II 65,000 $0.44613 5 28.998.18 $ 0.05000 5 445.00 88,704 $0.44613 111051ll1 65,000 $0.44613 5 28,998.18 $ 0.07977 S 701.15 88,704 SO.44613 11130/98 38,114 26,886 $O.44t13 $ 11.994.54 88,704 $0.44613 12/08191 35.885 $0.45080 $ 16.177.00 8.999 $ 0.33500 5 3.014.67 97,703 SO.45080 12/08191 35.885 $0.45080 S 16,177.00 S 0.05000 S 449.95 97,703 $0.45080 5 449.95 12/08191 35,885 $0.45080 $ 16,177.00 $ 0.07977 5 717.15 97.703 $0.45080 $ 5,351.97 12/08191 44,885 $0.45360 $ 20,359.93 9,000 $ 0.33500 $ 3.015.00 106,703 $0.45360 12/08191 44.885 $0.45360 S 20,359.93 S 0.05000 S 450.00 106,703 $0.45360 5 450.00 12/08191 44.885 $0.45360 $ 20,359.93 S 0.07977 5 717.13 106,703 SO.45360 5 4.901.97 121Ot1t8 53,685 $0.45543 S 24.449.91 8,800 S 0.33500 2.948.00 115,503 $0.45543 121Ot1t8 53,685 SD.45543 S 24,449.91 S 0.05000 440.00 115,503 $0.45543 5 440.00 121Ot1t8 53,685 $0.45543 S 24,449.91 S 0.07977 701.18 115.503 $0.45543 5 4,461.97 121Ot1t8 82.887 $0.45680 S 28,726.72 9.202 5 0.33500 3.082.67 124,705 $0.45680 121Ot1t8 62,887 $0.45680 S 28,726.72 S 0.05000 460.10 124.705 $0.45680 5 460.10 121Ot1t8 82,887 $0.45680 S 28,728.72 $ 0.07977 734.04 124705 $0.45680 5 4.001.87 121O\l/91 71,888 $0.45780 S 32910.12 9,001 S 0.33500 3,015.34 133,706 SO.45780 121Ot1t8 71,888 $0.45780 S 32,910.12 S 0.05000 450.05 133,706 50.45780 S 450.D5 121O\l/91 71,888 $0.45780 $ 32,910.12 S 0.07977 711,01 133,706 SO.45780 5 3.551.82 1211l1/tl1 80,888 $0.45857 S 37.093.05 9.000 5 0.33500 3.015.00 142,706 50.45857 1211l1/tl1 80,888 $0.45857 S 37,093.05 $ 0.05000 450.00 142,706 $0.45857 S 450,00 1211011I 80,888 $0.45167 S 37,093.05 S 0.07977 717.83 142,706 $0.45857 5 3.101.82 12131/t8 50,745 30,143 $0.45167 5 13.822.76 011D111t 39,543 $0.46005 S 18.191.80 9,400 $ 0.33500 5 3,149.00 9,400 SO.46005 011D111t 39.543 $0.46005 S 18.191.60 $ 0.05000 $ 470.00 9,400 $0.46005 5 470.00 011D111t 39.543 $0.46005 $ 18.191.80 S 0.07977 5 741.14 9.400 $0.46005 $ 2.631.82 011D111t 48,543 $0.46092 $ 22,374.53 9.000 5 0.33500 S 3,015.00 18,400 $0.46092 011051tt 48,543 $0.46092 S 22,374.53 5 0.05000 S 450.00 18,400 $0.46092 S 450.00 01111519t 48.543 $0.46092 $ 22,374.53 $ 0.07977 S 717,13 18,400 $0.46092 $ 2.181.82 TolllI Gallons Malt 1nV. GaL T olllI GeI10na W1hcnwn 129.532 ao__ Delivered 1U2Dl $ 67.274.37 Pounds Del" Gal 423 Max Pound8 95 342,156.24 - 0.46653194 ! , I A rTlk:-HfIl'f ~, ~.3 CSW:01128/99 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fual Enal'gy Cha'V8IThann Non-Fuel Energy Charge Energy Conservation Adj. (ECA) EnvironmentallmpositiDn Adj. (EIA) Weather Normalization Adj. (WNA) Total Non-Fuel Energy Charge Purchased Gas Adjustment (PG1f) Total Energy ChargelThenn Minimum Monthly Bill CDmpares to LP/Gallon Rate of with 8.0% Franchise Change from 9/98 Therm Rate UtIlI\}' Tax Nota. Fuel Rate ~rThenn 10101/73 Non-Utility Taxable FueVTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR FEBRUARY 1,1999 - MARCH 31,1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS ---BS.... ~ JaIL ...u4E... NA (1 - NA (4 + NA (4 + NA (4 + 3 Unital Units) Units) Units) $7.00 $15.00 $20.00 $50.00 $0.580 $0.580 $0.580 $0.580 0.080 0.060 0.060 0.060 0.000 0.000 0.000 0.000 Q.QQQ Q.QQQ Q.QQQ Q.QQQ $0.640 $0.640 $0.640 $0.640 Ull Ull Ull Ull $1.055 $1.055 $1.055 $1.055 $7.00 $15.00 $20.00 $50.00 Finn Natural Ga. Rata Schedule. ....sGS.... ....MGS.... ...lGS.... ...BAk... ....GAC.... ....LAC..- o - 18,000- 100,000 17,999 99,999 & up $15.00 $20.00 $50.00 $0.350 0.060 0.000 Q.QQQ $0.410 Ull $0.825 $50.00 NA(1- NA(O- NA(150 3 Unital 149 tons) tons & +) $7.00 if $15.00 if $15.00 if not prev. not prev. not prev. billed billed billed $0.200 $0.150 $0.100 $15.00 $0.200 $0.675 $15.00 +FAC .-SL-. SL wlM& .JmY... .B8IIgbl NA NA NA $15.00 $7 Resl./ $15 GS if nDt prevo billed $0.300 $0.100 0.080 0.080 0.060 Intarr. f!IG..Bata ~ ---lS- NA 100,000 &up $25.00 $100.00 $0.470 $0.280 0.060 0.060 0.060 0.000 0.000 0.000 0.000 0.000 NA 0.060 NA 0.000 0.000 Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ ~ Q.QQQ Q.QQQ Ull Ull $0.160 $0.260 $0.360 $0.180 $0.530 $0.280 $0.260 $0.210 $0.675 $0.625 $0.575 Ull Ull Ull Ull Ull a.llil $0.945 $0.590 $7.00@ $15.00@ $15.00@ premise premise premise $0.089 $0.069 $0.069 $0.470 $0.410 $0.775 $0.575 $15.00 $7 Resl./ +FAC $15GS@ premise +FAC $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days In Mo. $ 0.985 $ 0.985 $ 0.985 $ 0.985 $ 0.885 $ 0.810 $ 0.755 $ 0.618 $ 0.572 $ 0.528 $ 0.618 $ 0.709 $ 0.526 $ 0.885 $ 0.540 $ 1.023 $ 1.023 $ 1.023 $ 1.023 $ 0.917 $ 0.858 $ 0.800 $ 0.855 $ 0.606 $ 0.558 $ 0.655 $ 0.752 $ 0.558 $ 0.917 $ 0.572 0.060 0.060 $ 0.060 $ 0.060 $ 0.060 $ 0.080 $ 0.060 $ 0.080 $ 0.060 $ 0.060 $ 0.060 $ 0.060 $ 0.080 $ 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 1llLS8. 11l9a 0.000 0.000 Q.QQQ Q.QQQ $0.530 $0.470 Ull Ull $0.945 $0.885 $0.069 $0.346 $0.346 $0.346 $0.348 $0.069 $0.346 lllLaa $0.069 $0.069 $0.069 $0.055 $0.348 $0.346 $0.346 0BLaa QSLa9 $0.255 '.. ATTACHMENT #4 Contract f!IG..Bata ~ NA By Contract - By Contract NA NA ~ By Contract a.llil $0.310 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms - $ 0.065 $0,069 $0.241 12lllB. ll1LS.a 1.076 1.081 1.079 1.080 1.055 1.059 1.059 1.058 $15.00 $20.00 $0.069 $0.069 $0.346 $0.346 ~ Q3LS.a 1.082 1.061 ~ Q5Lall 0BLaa CSW:O 1 128/99 ATTACHMENT #5 CLEARWATER GAS SYSTEM BTU Factor: 2..Z.H Gallons/100 cubic feet (CCF) PROPANE (lP) RATE BilLING FACTORS BTU Factor: 2.Aa3 Therms/100 cubic feet (CCF) FOR FEBRUARY 1,1999 - MARCH 31, 1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS Therm Factor: Q.9.1S 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 rrherm $0.820 $0.820 $0.426 $0.350 $0.109 $0.426 By Contr. Energy Conservation Adj. IGallon 0.055 0.055 0.055 0.055 0.055 0.055 NA (ECA) " rrherm 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) rrherm 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon ?..?oo ?..?oo ?.?oo ?..?oo ?..?oo ?..?oo ~ (WNA) rrherm ?..?oo ?..?oo ?..?oo ?..?oo ?..?oo ?..?oo ~ 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 ~ ~ ~ ~ ~ ~ ~ -- (PGA) fTherm 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 $ fTherm Rate $ 0.010 $ 0.010 $ 0.010 $ 0.010 $ 0.010 $ 0.010 $ Note: Utiliy Tax is billed on total LP bill.