Loading...
GAS ADJUSTMENTS EFFECTIVE JUNE 1, 1998 I I CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet TO: Mike Robertor City Manager c) FROM: Chuck Warrington, Gas System Managing Director COPIES: Rick Hedrickr Assistant City Manager; Cyndie Goudeau, City Clerk; Margie Simmons, Finance Director; Brad Varnum, Director of Customer Service; John Scott, Asst, Dir, of Cust. Service; Tom Madley, Senior Accountant/CCS; Karen Miles, Accounting Manager; CGS Management Team SUBJECT: GAS ADJUSTMENTS EFFECTIVE JUNE 1, 1998 DATE: May 21, 1998 April was a very good month, and we are now projecting over collection in both our Natural Gas Purchased Gas Adjustment (PGA) and Energy Conservation Adjustment (ECA) clauses of over $100,000 by fiscal year end unless we reduce our rates. Therefore, we are recommending a 1.5C and O,5C per therm reduction in these rates, respectively, Additionally, the Propane Gas (LP) cost per gallon has continued to fall this Spring allowing us to reduce the LP PGA by another 1 C per gallon, The net effect of these changes is a reduction in the typical bill of about 2C/therm, which follows a 2C reduction in each of the past 2 months in the price of gas for our typical customer, So this is a very good news report --- a reduction in our rates for a typical residential of nearly 6% in just 3 months! No other changes are proposed at this time. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after June 1, 1998: Natural Gas Firm Standard Rate Schedule PGA ..,.,., $0,395 per therm (down 1,5C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............, $0,275 per therm (down 1.5C/therm) Propane (LP) Gas Rate Schedule PGA ..................., $0.500 per gallon (down 1,OC/gallon) = $0.546 per therm equivalent (down 1 .1 C/therm) Energy Conservation Adjustment (ECA) ............... $0.050 per therm (down O,5C/therm) = $0.046 per gallon of LP (down OAC/gallon) 2/---102-[( (a/ ) ~ike Roberto, City Manager I Page 2 I May 21, 1998 Environmental Imposition Adjustment (EIA)......... $o.odo 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 $103,445,74, This positively impacts our bottom line financials, Attachment #3 shows Terry Neenan's and MGAF's current Natural Gas Purchased Gas Supply Cost Projections, Attachment #3 shows our FY 97/98 fiscal year-to- qate history of Propane (LP) Gas supply costs, 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 September 30r 1998, 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 UCS in order to make the appropriate adjustments in the billing formulas in time for the June 1 st billings, If you have any questions on thisr please call me, CSW /csw Attachments Approved: "~ Mike Roberto, City Manager - U:\My Documents\MSOFFICE\WINWORD\GASRA TES\Gas Adjustments for June 1998.doc CSW:05l21/98 ===r==~_L I I I -----L----__J_____________1 CLEARWATER GAS SYSTEM SUMMARYCfF-RATEADJUSTMENT CLAUSE COLLECTIONS I (Actuals thru April 1998 & Projections for Remainder of FY 91/98) I .-------1~____J_=_____._ .._ . -=:--__-1 I NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NG) Budget Reservation Commodity Interest Cost Center Month Charges Charges Expense Expenses (1) Prior Year _ Oct-97 $ 134,807.13 $ 227,499.60 $ 677.21 $11,777.83 Nov-97 $ 159,095.24 $ 383,880.42 $ 534.95 12,456.58 Dec-97 $ 69,627.35 $ 437,285.37 $ 772.90 17,544.16 ~_~n~~_~__~~5,986.87 $___ 530,558.49 f--~ 274.17 9,508.53 Jan-98 Transfer balance from WNA ~_+-~ - 78,836.06 Feb-98 $ 149,905.83 $ 590,706.67 $ 407.24 14,212.12 Mar-98 $ 162,719.00 $ 531,980.42 $ 415.79 13,265.22 Apr-98 $ 163,569.74 $ 429,474.94 $ 99.37 10,751.13 May-98 $ 86,000.00 $ 380,000.00 $ - 14,000.00 Jun-98 $ 85,100.00 $ 340,000.00 $ - 14,000.00 Jul-98 $ 88,000.00 $ 290,000.00 $ - 14,000.00 Aug-98 $ 88,000.00 $ 290,000.00 $ - 14,000.00 ~ep~98 _ J___85~2g~-=-00_ J__._________ __ 2~0~000.OO $ ~ _ _ __.)~~00.09_ !~~~ .L~~~,011.16 $ 4,721,385.91 $3,181.63 238,351.63 - .---.------ ___no ----- ~__ - - U____n__'_.._ .. _ ____________ PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) ---.---- Total NG Fuel Expenses $ - $ 374,761.77 $ $ 555,967~19-$- $ 52(229.78 $ $ 706,328.06 $ $ 78,836.06 $ 755,231.86 $ $ 708,380.43 $ $ 603,895.18 $ $ 480,000.00 $ $ 439,100.00 $ $ 392,000.00 $ $ 392,000.00 $ $ 389,200.00 $ ---.-. --------...- - - $ 6,400,930.33 $ Total NG PGA Billed 403,213.09 508,378.22 624,974.96 758,550.91 $ $ $ f $ 753,520.78 $ 771,666.41 $ 641,508.48 . $ 517,608.00 $ 432,762.00 $ 406,534.00 $ 406,5~.00 $ 408,114.00 $ ----if633~364-:-851$ A IT ACHMENT #1 Page 1 of 3 Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) $ (135,441.89) 28,451.32 $ (106,990.57) (47,588.97) $ (154,579.54) 99,745.18 $ (54,834.36) 52,222.85 $ (2,611.51) (78,836.06) $ (81,447.57) (1,711.08) $ (83,158.65) .450/.295 63,285.98 $ (19,872.67) .450/.295 37,613.30 $ 17,740.63 .410/.290 37,608.00 $ 55,348_63 .4101.290 (6,338.00) $ 49,010.63 .395/.275 14,534.00 $ 63,544.63 .395/.275 14,534.00 $ 78,078.63 .395/.275 18,914.09_ .~~9~.:!>~2~.?!-27_5 . 232,434.52 NG PGA RatelThenn Finn/Contr .415/.295 .415/.295 .415/.295 .450/.295 - f-. Budget Month Prior Year -~ _O~!:~~______1.?-,??~~Q. $ __t-.l~~ ____2.~.._!77.09 $ Dec-97 32,174.10 $ Jan-98 36,710.30 $ Jan-98 Transfer balance from WNA ~eb-98 30,019.60 $ Mar-98 -37,582.90 $ Apr-98 39,289.60 $ _~ay-9l! ..... .. __30,000.00 $ Jun-98 30,000.00 -$- Jul-98 30,000.00 $ Aug-98 30,000.00 $ Sep-98 30,000.00 $ Tolaf'VTD ---------367~02.b~.30 $. _0___ Monthly Cumulative LP PGA Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage Thenn/Gal. Expense Charges Expenses Billed (Shortage) (Shortage) $ - $ - $ - $ 5,973.76 $._-=-- -~~--.:,_ .1_______.-=-__ ~_ $ - $ 5,973. 76 __.~~ $ 8,390._~.J 8,390.78 $ 8,604.27 $ 213.49 $ 5,760.27 .557/.519_ --___ J.____8,793..Q!.. $_8~?~~Jl-.!.. _~____12,~7.74.. $_ 3,704J3 $ 9,464.99 _-:?57/.5!0_ $ 16,926.15 $ 16,926.15 $ 17,699.40 $ 773.25 $ 10,238.24 .601/.550 $ 19,206.46 $ 19,206.46 $ 20,272.60 $ 1,066.14 $ 11,304.38 .601/.550- $ 3,298.07 $ 3,298.07 $ - $ (3,298.07) $ 8,006.31__ $ 15,067.44 $ 15,067.44 $ 16,516.54 $ 1,449.10 $ 12,753.48 .601/.550 $ 19,066.93 $ 19,066.93 $ 20,696.03 $ 1,629.10 $ 14,382_58 .601/.550 $ 21,309.11 $ 21,309.11 $ 19,517.14 $ (1,791.97) $ 12,590.61 .557/.510 -..------- $-u__1~4..99?~_$___ 1~~07 ~o_ )~_____f?~6o~~c[ -$-'--392AO -$~T983:QI __ .~$fT.~!0_ $ 15,000.00 $ 15,000.00 $ 15,000.00 $ - $ 12,983.01 .546/.500 $ 15,000.00 $ 15,000.00 $ 15,000.00 $ - $ 12,983.01 .546/.500 $ 15,000.00 $ 15,000.00 _~__.__15..000_...og_ _$________=__ _$___----.!~~983:01_ .546/.500 -___ _!~QQQ:..QO $ 15,000.00 _!____15,QOO.00 $ - $ 12,983.01 .546/.500 $ - $ 186,965.55 $ 186,965.55 $ 191,103.72 $ 4,138.17 Gallons Sold Monthly WACOG $ 0.50044 ~--------_.._-_.- 0.52443 0.52608 0.52319 0.50192 0.50733 0.54236 0.49692 __.__.___n_______.__...____.___ ~n 0.50000 0.50000 0.50000 0.50000- ----__.____u.____ 0_"_ _n 0.50941 Pa e 1 - ATTACHMENT #1 Page 2 of 3 I I ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGfThenn Month Expenses Notes/Exceptionallterns Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ 13,611.96 Oct-97 $ 7,365.60 Sales/Promo 5.8K, Advertising 1.5K $ 7,365.60 $ 18,715.27 $ 11,349.67 $ 24,961.63 .030/.027 Nov-97 $ 15,267.86 Sales/Promo 14.6K $ 15,267.86 $ 24,135.90 $ 8,868.04 $ 33,829.67 .0301.027 --~---- .. ----- "--- -- - - _.-._--~~----------- --..--- ------- .--- ,---------~----- - -. .- ...-----.,-.-.,.". - Dec-97 $ 34,470.70 Promotion $ 34,470.70 $ 31,772.41 $ (2,698.29) $ 31,131.38 .030/.027 --..----.--- -- ~-, ---~-- -- ---- Jan-98 $ 20,999.00 Promotion 11 K, Adv City Mag 10K $ 20,999.00 $ 48,630.18 $ 27,631.18 $ 58,762.56 .040/.037 Feb-98 $ 27,547.17 Advertising 9K, Promotion 9K $ 27,547.17 $ 48,091.51 $ 20,544.34 $ 79,306.90 .040/.037 Mar-98 $ 39,050.30 Promo 31.7K,Adv 4.3K,Dues 0.5K $ 39,050.30 $ 49,882.60 $ 10,832.30 $ 90,139.20 .040/.037 Apr-98 $ 29,942.56 Advertising 3.2K, Promotion 26.8K $ 29,942.56 $ 58,048.49 $ 28,105.93 $ 118,245.13 .055/.050 May-98 $ 30,000.00 $ 30,000.00 $ 52,506.63 $ 22,506.63 $ 140,751.76 .0551.050 Jun-98 $ 30,000.00 $ 30,000.00 $ 40,396.05 $ 10,396.05 $ 151,147.81 .050/.046 Jul-98 $ 50,000.00 $ 50,000.00 $ 37,996.05 $ (12,003.95) $ 139,143.86 .0501.046 Aug-98 $ 60,000.00 $ 60,000.00 $ 37,996.05 $ (22,003.95) $ 117,139.91 .050/.046 Sep-98 $ 70,000.00 $ 70,000.00 $ 38,678.40 $ (31,321.60) $ 85,818.31 .050/.046 Total YTD $ 414,643.19 $ - $ 414,643.19 $ 486,849.54 $ 72,206.35 ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGfThenn Month Expenses Notes/Exceptional Items Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ - $ (67,178.16) Oct-97 $ 25,299.67 Prof serv&op supp 4.3K,env consult 21 K $ 25,299.67 $ 6,242.15 $ (19,057.52) $ (86,235.68) .010/.009 Nov-97 $ 4,048.20 Environmtl consulting $ 4,048.20 $ 8,045.31 $ 3,997.11 $ (82,238.57) .010/.009 Dec-97 $ 947.58 Environmtl consulting $ 947.58 $ 10,590.79 $ 9,643.21 $ (72,595.36) .010/.009 Jan-98 $ 8,953.83 Appraisals 9K, Prof fees 3K, Adj envir (3K) $ 8,953.83 $ 18,240.50 $ 9,286.67 $ (63,308.69) .015/.014 Feb-98 $ 2,505.24 Prof serv 1.4K, appraisal fees 1.1 K $ 2,505.24 $ 18,037.59 $ 15,532.35 $ (47,776.34) .015/.014 Mar-98 $ 2,680.20 Prof serv 1.7K,appraisal fees 0.9K I $ 2,680.20 $ 18,709.50 $ 16,029.30 $ (31,747.04) .0151.014 Apr-98 $ 23,011.81 I $ 23,011.81 $ 21,103.57 $ (1,908.24) $ (33,655.28) .020/.018 May-98 $ (427,500.00) Travelers Insurance Settlement 437.5K $ (427,500.00) $ - $ 427,500.00 $ 393,844.72 0 May-98 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 383,844.72 0 Jun-98 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 373,844.72 0 ---'----. Jul-98 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 363,844.72 0 Aug-98 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 353,844.72 0 Sep-98 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 343,844.72 0 Sep-98 $ - $ - $ - $ 343,844.72 0 Total YTD $ (310,053.47) $ - $ (310,053.47) $ 100,969.41 $ 411,022.88 ---- ----~------- 1------... ----- _on_.__._,___.__ ______ ___ __.~__._,_________._.__u_.__ ---.---- .-------.- -----------.-....---.--. .-.. --.... ... Page 2 - - ..---.----.---.-.---.-.-..- --.-...------.---.-.--- ---..-. ..-....... ..--- 52,099.8 2~440,854.4 - --- -----=t------ TOTAL A~L COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) I T Budget Month Prior Year Adj Oct-97 Nov-97 Dec-97 Jan-98 Feb-98 Mar-98 Apr-98 May-98 Jun-98 Jul-98 Aug-98 Se~9~__ ._ Total YTD ---- -__ L--...-_ WEATHER NORMALIZATION lWNA) Budget Month Beg. Ba!. Oct-97 Nov-97 Dec-97 Jan-98 -.--.--- -~--------- Jan-98 Transfer to NG PGA & LP PGA 1--- Feb-98 Mar-98 Apr-98 May-98 -. Jun-98 Jul-98 Aug-98 Sep-98 Totai VTO ------- ----- ..___m.. _______. Interest LP Gallons Expense Rate/Gallon 11,577.9 $ 0.046 16,869.8 $ 0.046 23,652.1 $ 0.046 $ - .----- " 1) Amount dl1fers from C08t center 2078 on the Stmt of Rev & Exp by the amount In taxes. A IT ACHMENT #1 Page 3 of 3 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Monthly Cumulative Total Total All Total Recovery Overage YTD Overage All Thenn Expenses Billed (Shortage) (Shortage) NGIlP - $ - $ - $ (183,034.33) - $ - $ - 415,817.~~ ~_~?8,170.51 $ 12,352.69 $ (170,681.64) .455/.546 584,076.27 $ 553,057.17 $ (31,019.10) $ (201,700.73) .455/.546 577,574.21 $ 685,037.56 $ 107,463.35 $ (94,237.38) .455/.641 837,621.48 $ 845,694.19 $ 8,072.71 $ (86,164.67) .505/.656 800,351.71 $ 836,166.42 $ 35,814.71 $ (50,349.96) .505/.656 769,177.86 $ 860,954.54 $ 91,776.68 $ 41 ,426.72 .505/.656 - 678,158.66 $ 740,177.68 $ 62,019.02 $ 103,445.74 .485/.632 107,407.60 $ 585,414.63 $ 478,007.03 $ 581,452.77 .465/.612 494,100.00 $ 488,158.05 $ (5,941.95) $ 575,510.82 .445/.596 467,000.00 $ 459,530.05 $ (7,469.95) $ 568,040.87 .445/.596 477,000.00 $ 459,530.05 $ (17,469.95) $ 550,570.92 .445/.596 _~!~QQ~Of ~~-----46~?.~~~9~ --$ _t~~_Q(60) - ---- ---.------------...- _.~ --.. $ 538,163.32 .445/.596 6,682,485.60 $ 7,403,683.25 $ 721,197.65 NG Thenns Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) $ (206,573.39) $ 31,212.18 $ (175,361.21) $ 40,246.16 $ (135,115.06) $ 52,980.93 $ (82,134.13) $ ___~ (82,~.~3) $ 82,134.13 $ 0.00 $ - $ 0.00 $ - $ 0.00 $$_ - $ O.Q()__. $ 0.00 - --------$-~- $ 0.00 $ - $ 0.00 $ - $ 0.00 ----..--______ $__ - ~_.____e>..OOu____._.__. $ 206,573.39 RatefThenn 613,591.9 789,402.9 1,037,858.6 $ 0.050 $ 0.050 $ 0.050 $ - 1 ~O$--82,134.130 -- PaQe 3 ---.-. .--.-.----._..___1--_.___._.__'--_.______ '---____ C:IMy DocumentsIMSOFFICEIEXCELIGASRATES\[Adjustment CI8use Recovery for FY 97-98.x1s]Recovety fi TJ fk J.I In € tJ r '*" 2- CLEARWATER FY87198 PURCHASED GAS COST PROJECTIONS AS OF _._n_ 5121198 a.Md on ActuaJ DTH'e Sold Eaulv_ _0 _m R........1oMd ....... u Ph... "I eo..- Ac:tuoI - Canlr8ct Canlr8ct c~ Av...... Av.U.bIe NNTS Pu_ 80Id Cooocl1v . ,,"-.lIv Por_ C.-.. Co...... Por Month Por_ Por_ Por_ DoIIltro Por_ PerMan'" .- -- -- ~~ ___~~Z,376 ~!,!~ _,__u________ . . _$0.00 -~.____'_~..88 0 __~__'~,500 -- _._. J.3.5,5.76 ~!.4L~~ ------- --- ---- ----..- ... -- ---- n _____.,_._ .-- 0 "------ ~0!.97 306,570 ____.__~]L~~ _ .._ ,..00 l00,I_~ -:f- ___. _~.l~OO ---- j_~t~ ___1.~_~t?_~ '------ -. ._~- --------..----- -- ...-- --. 0 _____u______ ._-----. ._~ ------ -----.-- Dec-" 31~ 5521t (S~22.:n) 175,460 31,011O 172,491 -- - - -_._---~!~.~ --"0>98 _3J~~ f-----~ ____t5i:is4.Sn 176 701 0 +- 46,500 195 293 '97.562 ------- ----- .._____~J .-- --~!! Z.~6t!!! 49 868 (~.!t157.15) 148 735 0 4~~ _I!~~ -- 1'6.793 --,---- ~_.~----'--3Q68 M.....,. -'-3i6.789 55 11 IS 1 170.00) 172,484 0 31000 199,516 200.269 -1178 Aor-98 306.'70 5U30 ($1 170.00) 206,266 0 22,500 153,734 '1115. -2736 M.v.98 14<4212 41188 ($ 1 170.00) 30 000 0 12400 0 156.000 .JISl lun-98 139,560 40._ CS1170.00) 48 000 0 10500 0 132000 .J151 ul.98 144212 41188 ISI 170.00) 62.000 0 108SO 0 124 000 .3151 Au..98 144212 41788 <11 170.001 62 000 0 108SO 0 124000 -3151 S...98 139 S60 40 _ ($1 170.00) 54 000 0 12000 0 126000 -]151 Total (113,323.941 -- --..- ---- 1,867,251 2793771 570.393 1 474.384 0 267 600 1,227.780 -- ~- P.......... Ptvjectod ===r~-d . ---- .-- __m___.__ f--~..-- -..--- ------ -~ Praj......_- it...,...... T....~'- _. Ptoj~_N!'T8_ --- - Projoctod -- -~v=.' -~COOI- - ----.. ... C.C.P_ WACDO .~~COI:I ---"-..........---- ...:..~;:-... >-~UV~ ~Uv_ R...."oUon U Adlu..........-- ,.... Cool ~._F. Pu.......-' 80Id F_ Total Per_ Per_ _ AI VoIu.... Per_ Por_ Por_ Por_ Por ...... Por_ -- - PorMan'" Por_ Oct-97 $101.153.27 $l 750.40 ~..3 534 086.07 $9.2.02 $l25 262.00 $39.54..03 $ 10 233.90 f---S2 372.58 5U4 $4.17 41.,"" $520.8 17 .so N0v-97 5115.512.38 $2 767.90 $2 242.46 $43 582.85 $1 094.27 $l78 075.39 $0.00 5 11 895.87 $7.797... $l.50 $3.1, 39.7"" 555U68.60 Dee-97 $119492.81 $4-'11.10 $1 15.19 $45 035.61 ~~~~7 $4fO-:'36.97 A ($84 028.30) 514 ...... $3439.45 $1... $3.2, 41.25');, $567.0'3.39 1.1>-98 $111,369-'3 $~.)8 U. 13.02 $45 035.61 $1 55U5 $562 3 '5.99 $941.11 $17717,99 $l,417.63 5U. $3.83 n.21');, $756,,,..... fob-9. $106 771." 55"8.82 $2 56.66 $40677.33 51493." $49.,167.22 $6.022.16 512.662.81 $3 443.87 53.62 $3.... 59.11');, $677 ,84f.54 01...-9. 5118.322.81 55 794.70 $1 29.00 S.5,03S.61 51 297." $423 612.20 $8 768.90 $14,470.44 $3,504.71 $l.lI $3.'0 U.OI'1. $620,OS4.41 ~ $114..461.20 $4415.67 $1 27.50 $43,512.8S $'.255.61 $300 0'5.06 $11,142.)6 511 2".61 53.170.27 $3.52 $3." 50.71'1. $S4 1,316.22 MJly.98 $53 226.77 54 602.74 $73 1.60 $3_4086.47 $982.02 U46,024.80 50.00 $10 554.36 $2 730.00 $2~ c----___85,32"- $452.287.54 ___~~~9_~ -~!~!'?-:Q) __g~_9.87 $619.50 $32986.91 5950.34 $290 083.15 $0.00 $8.895.99 $23 10.00 -~ 1---_ 74.64'L 5392.203.65 JuI-98 $S) 226.77 $3,313.1" $640.15 $34086,47 $982.02 $270939.91 $0.00 $8.072.02 $2.170.00 $).02 67.82'" $374.515.58 Aucr-98 $53 226.77 53,313.14 $640.15 $34.086.47 $982.02 $270 939.91 $0.00 -. $8.263.96 $2 179.00 >-------- ____.~3,02 __,____. 67.82'" .~_1~7...71}J__~. _ _____Sep-91 ---------- $5,',,47,2',03_ 53,",48.0!. - -...-- -. _ $708.00 .-- -- - $32,986.91. ___.___._1950.34 _n 5275,93991 $0.00 ,$71224.01 ~ j21~OS.OO -- $2.88 t _, n_ __. 71:~_~'I. f--' _ S}7,~I90~}6 - -- - nun ----- --- -------.'----,-- ._---~,-,-- .-.-f- ~---- -------- -- -- ---- -._-- I-----~- __ - ------- ---~ _._~- 1----- $2.029 56.212,614.97 $1,0$6,715.2' $50470.93 $" 058.76 $465 269.56 $15,553.54 $4,401,812.51 ($17.607.9n $135.758.84 $33 730.91 59.37"- Av~~ Nol~: ---.~-______.m~______ ~:::.-;;~~:;rr:~7;tistoriC4l1 u~ge 0100 el(~r~~E'4Ilher.~.fi_!_~S oiIliun oiInd fuel r<1les an~ based on oiIdu.1 Tolal Pro'ected DTH WACOG Tolal Reservoillion T~ill Commoditv Co~ Ttwse numtwn renrast>nl .. be>sllook rorward b.sed on CUlTMI d.la. 1st 6 Months $941 164.05 $2 760,489.27 U.701 653.31 1 024,093 .. $3.615 I---~-- 2nd 6 Monlm $S86.555.S5 $1,924,406.11 $2.510,961.66 843.158 $2.978 f---~.- -- -- t-. TOTAL $1,521719.59 $4,684,895,38 $6.212,614.97 1.867.251 U.327 iIAlMiustments for Decembor 1997 includes the FGT refund of overoavment of rates due to the rate seltlement93.894.74 -- , - - . . I , . P"PANE INVENTORY AND WEIGHTED COST OF GAS IWACOGI . I . PREPARED BY TERRY NEENAN . DATE D5I1811. -- LP .upplled by F.",,~~. : 544-141. A.k for Ma~__ .. ~-- --. -- Dati Contract End. tl30/l7 Victor INVENTORY TANK COST OF GALLONS DEUVERED DEUVERED TOTAL NEW DATE WITHDRAW INVENT. WACOG INVENT DEUVERED PRICE INVOICE GALLONS WACOG tl30117 27.893 16.905.0 0.50044 $8.459.94 $ S 16.905 $ 0.50044 1014117 26.201 $0.51299 S13,440.74 9.296 $ 0.53580 $ 4.960.80 26.201 SO.51299 10181t7 35.564 SO.51899 S18,457.43 9.363 S 0.53580 S 5.016.70 35.564 SO.51899 10181t7 44.951 $0.52250 S23.486.99 9.387 S 0.53580 $ 5.02955 44.951 SO.52250 10110117 54.233 $0.52478 S28.460.28 9.282 S 0.53580 $ 4.97330 54,233 SO.52478 10131/17 38 54.269 $0.52443 $28.460.28 . S 54.233 SO.52443 10131...7 26.640 25,429 $0.52443 $ 1 3.335.73 $ 54.233 SO.52443 11/121l17 34,797 $0.52211 S18.167.74 9.388 $ 0.51560 $ 4.632.01 63.601 $0.52211 11/121l17 43.797 $0.53447 $23.408.17 9.000 S 0.58227 S 5.240.43 72.601 SO 53447 11/121l17 53.169 $0.53118 $28.242.25 9.372 S 0.51560 S 4.834.08 81.973 $0.53118 11130187 515 53.684 SO.52608 S28.242.25 . 81.973 SO.52608 11130187 27,904 25,780 $0.52808 $13.56234 81.973 SO. 52608 12/10197 34.981 $0.51890 $18.151.53 9.201 $ 0.4988 $ 4.589.18 91.174 $0.51890 121111I7 44.281 $0.53221 $23,586.64 9.300 S 0.58227 S 5.415.11 100.474 SO.53221 12/16117 53,581 $0.54090 $28.981.75 9.300 S 0.58227 S 5.415.11 109.774 $0.54090 121261I7 62.944 $0.53186 S33.478.80 9,363 S 0.48030 $ 4.497.05 119.137 $0.53186 12/26117 72.263 $0.52522 $37,964.32 9.339 S 0.48030 $ 4.485.52 128.476 SO.52522 12131...7 280 72,563 $0.52319 $37.964.32 S S . 128.476 $0.52319 12131...7 43,779 28.784 $0.52318 S15,059.53 S . S . 128.478 $0.52319 01_ 38,133 $0.50667 $19,320.81 9,349 S 0.45580 $ 4.261.27 137.825 $0.50667 01/12/98 47.133 SO 53651 S25.287.54 9.000 $ 0.58227 $ 5.966.73 146.825 SO.53651 01/18198 56.296 $0.52207 S29.39073 9.163 $ 0.44780 S 4.103.19 155,988 SO.52207 0112219I 65.412 $0.52297 S34.208.42 9.116 S 0.44780 $ 4.81769 165,104 $0.52297 01131.... 3117.9 68.530 $0.50192 $34.396.38 165.104 SO 50192 01/31/18 44348.9 24,181 $0.50182 S12,l38.87 165.104 SO.50192 02103/98 33,481 $0.52451 $17,561.28 9.300 $ 0.58227 S 5.424.41 174,404 $0.52451 02/06198 42.482 $0.53896 S22.61 1.29 9.001 $ 0.58227 $ 5.250.01 183.405 SO.53696 02/27/1' 51.668 $0.52173 S26,956.93 9.186 S 0.45130 $ 4.145.64 192.591 SO.52173 02/28198 1,168 52,836 $0,50733 $26,805.44 192.591 SO.50733 36626 0212819I 38.672 13.964 SO.50733 $7.08438 192.591 SO. 50733 03ID3191 23.103 $0.48517 $11.208.79 9.139 $ 0.45130 $ 4.124.43 201.730 $0.48517 031D&191 32,381 $0.47548 $15,386.92 9.258 S 0.45130 $ 4.178.14 210.988 $0.47548 03112191 41.661 SO.49954 $20.81 1.33 9.300 $ 0.58227 S 5.424.41 220.288 SO.49954 03115191 50.861 $0.51469 $26,177.42 9.200 $ 0.58227 $ 5.366.08 229.488 $0.51469 03117/98 60,161 $0.52529 $31.601.63 9.300 $ 0.58227 $ 5.424.41 238.788 SO.52529 03120/98 69,162 $0.53283 S38,851.64 9.001 S 0.58227 S 5.250.01 247,789 $0.53263 03131...8 78.362 SO.53875 542,217.72 9.200 S 0.58227 $ 5.365.86 256.989 $0.53875 03131.... 87.563 $0.54343 547,584.19 9.201 $ 0.58227 $ 5.366.47 266,190 $0.54343 03131.... 173.00 87,736 $0.54238 547,584.19 266.190 $0.54238 03131.... 47.582 40.153 $0.54238 S21,m.38 266.190 $0.54236 04117191 49.615 $0.52377 S25,987.07 9.462 S 0.44560 $ 4.209.69 275.652 SO.52377 04127191 59.039 $0.51133 $30,188.29 9.424 S 0.44560 $ 4.201.22 285.076 $0.51133 04127.... 68.525 $0.50226 S34.417.15 9.486 S 0.44560 $ 4.228.86 294.562 $0.50226 04127...8 77,968 $0.49542 S38.626.84 9.443 S 0.44560 $ 4.209.69 304,005 SO.49542 4130198 28n 77,681 SO.49692 $38.601.32 304.005 SO.49692 4130198 42963 34,718 $0.49682 $17.252.07 304.005 $0.49692 Total GallOI18 Max Inv. Gal. Total GaftOl18 Wthdrawn 307 165 .7 738 Delivered 287 100 $ 150.627.08 A Irfk~7HFrJ- #-3 CSW:05/21/98 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Energy CharvelTherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Environmentallniposition Adj. (EIA) Weather Normalization Adj. (WNA) Total NDn-Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargefTherm Minimum Monthly Bill Compares to LP/Gallon Rate of with 6.0% Franchise Change from 9/97 Therm Rate UtIII(y Tax Note' Fuel Rate per Therm 10/01/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM - NATURAL GAS RATE BILLING FACTORS FOR JUNE 1,1998 - SEPTEMBER 30,1998 BASED ON APPROVED GAS ADJUSTMENT FACTORS ---RS... ...sML ....MML ...LME... NA (1 - NA (4 + NA (4 + NA (4 + 3 Units) Units) Units) Units) $7.00 $15.00 $0.580 $0.580 $0.580 0.050 0.050 0.000 0.000 0.000 0.000 $20.00 $50.00 $0.580 0.050 0.050 Q.llQll Q.llQll Q.llQll Q.llQll $0.630 $0.630 $0.630 $0.630 $1.025 $1.025 $1.025 .ll..395 .ll..395 .ll..395 .ll..395 $1.025 $7.00 $15.00 . $20.00 $50.00 Firm Natural Gall Rate Schedulllll ..sGS.... ....MGS.. ..L.GS.... ....BAC.... ~ ~ o - 16,000- 17,999 99,999 $15.00 $20.00 - 100,000 &up $50.00 $0.350 $0.400 .ll..395 $0.795 $50.00 NA (1 - NA (0 - NA (150 3 Units) 149 tons) tons & +) $7.00 If $15.00 If not prev. not prev. billed billed $0.200 $0.150 $15.00 If not prevo billed $0.100 0.050 $15.00 $0.200 ....sL.... SL wlM& ....HmL BeUgbt NA NA NA $15.00 $7 Resl.! $15 GS if not prevo billed $0.300 $0.100 0.050 0.050 0.050 Interr. HG..Ratll ..liSS.... --IS..- NA 100,000 &up $25.00 $100.00 $0.645 $15.00 +FAC $0.745 $0.545 $15.00 $7 Resl.! + FAC $15 GS @ premise +FAC $0.470 $0.260 $0.470 $0.410 0.050 0.050 0.050 0.050 NA 0.000 0.000 0.000 0.000 0.000 NA $0.069 $0.326 llZl9a $0.069 $0.326 Q.llQll Q.llQll Q.llQll Q.llQll Q.llQll ----HA $0.150 $0.250 $0.350 $0.150 $0.520 $0.280 $0.545 .ll..395 .ll..395 .ll..395 .ll..395 .ll..395 n.lli $0.915 $0.555 $25.00$100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in MD. $ 0.938 $ 0.938 $ 0.938 $ 0.938 $ 0.837 $ 0.782 $ 0.727 $ 0.590 $ 0.544 $ 0.499 $ 0.590 $ 0.682 $ 0.499 $ 0.837 $ 0.508 $ 0.994 $ 0.994 $ 0.994 $ 0.994 $ 0.887 $ 0.829 $ 0.771 $ 0.626 $ 0.577 $ 0.529 $ 0.626 $ 0.723 $ 0.529 $ 0.887 $ 0.538 $ 0.050 0.050 0.000 0.000 0.000 $7.00 @ $15.00 @ $15.00 @ premise premise premise $ (0.050) $ (0.050) $ (0.050) $ (0.050) $ (0.050) $ (0.050) $ (0.050) $ (0.050) $ (0.050) $ (0.050) $ (0.020) $0.069 $0.069 $0.069 $0.069 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) $ $ $ Firm Service Rates Interruptible Service Rates $0.326 $0.326 $0.326 $0.326 1llLaZ 11.laZ 1.073 1.074 12l9Z lI.1l9ll 0.000 0.000 ll.lll1O Q.llQll $0.520 $0.460 .ll..395 .ll..395 $0.915 $0.855 $0.069 $0.326 1.071 1.050 Q.llQll ll.lll1O Q.llQll $0.069 $0.069 $0.069 $0.055 $0.326 $0.326 $0.326 llalllJl llSLaa $0.220 ATTACHMENT #4 Contract HG..Ratll ~ NA By Contract By Contract NA NA ----HA By Contract n.lli $0.275 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Thenns $ (0.020) $0.069 $0.206 1.052 1.053 1.075 1.079 1.054 1.056 $15.00 $20.00 $0.069 $0.069 $0.326 $0.326 ll2llUl ~ 1.071 1.069 1.050 1.048 $0.250 $0.200 .ll..395 .ll..395 $0.645 $0.595 $0.069 $0.069 $0.326 $0.326 ~ ~ ~ 1.076 1.079 1.055 1.058