Loading...
GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1999 CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet (:!/.. ,; /..." lr '~~ "70 ~1 Ji' "''>. . 'to '<? t". . ") ,1,,- 'f .' ,~~., . 7 .,.....;, "". I . 7) ......,,(1'> ":'0 -: ''; (.? 1 '" 1 TO: Mike Roberto, City Manager Tllb , .l!4D 199,9 FROM: "i'< '. . , -'-; l/{ DEp Chuck Warrington, Gas System Managing,Director ' 1: COPIES: Rick Hedrick, Deputy City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Laura Damico, Accountant/CCS-LP SUBJECT: GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1999 DATE: March 26, 1999 Good News!!! Gas rates are moderating slightly such that we can recommend lowering our Natural Gas Purchased Gas Adjustment (PGA) by 0.5C::/therm. Additionally, we have done our semi-annual assessment of the Interruptible differential, which results in our ability to cut Interruptible and Contract Natural Gas Rates by an additional 0.5C::/therm. No other changes in our adjustment clauses are proposed at this time. It should be noted that, even with the increases since the first of the year due to the unseasonably warm winter weather this year, our Residential Natural Gas rates are only 0.5C::/therm higher this April than last year. Therefore, we are recommending your approval of the following rates to become effective for all billings rendered on and after April 1, 1999: Natural Gas Firm Standard Rate Schedule PGA ....... $0.410 per therm (down 0.5C::) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.300 per therm (down 1.0C::) 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) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) = $0.000 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... $0.030 per therm (no change) = $0.027 per gallon of LP (no change) ::2/~/()2'o( (~) : ~ Mike Roberto, City Manager 1 Page 2 . . I March 26, 1999 Attachment #1 shows the CGS Summary of Rate Adjustment Clause collections, which as of the end of February were in surplus by a total of $114,929.19. Please note that this balance has fallen by $395,108.24 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 $369,300.31 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 $254,371.12, which is the reason for the increases we have made in these clauses since the 1 st of the year. Please note that we turned this trend around in February with a $69,807.27 monthly improvement in our overall adjustment clause balance. Attachment #2 shows our computation of the Interruptible Natural Gas Differential. Attachments #3 and #4 show the Natural and LP Gas history and projections, respectively. Finally, Attachments #5 and #6 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 30, 1999, unless we determine that there is cause to change these. 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 April 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: ~ Mike Roberto, City Manager C:\My Documents\MsOFFICE\WINWORD\GAsRATEs\Gas Adjustments for April1999.doc CSW:03/25199 Attachment #1. CLEARWATER GAS SYSTEM . -------1----- __Page_1.~f ~. SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA.NG) Monthly Cumulative NG PGA -- Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelTherm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) FirmlContr Prior Year $ - $ 102,106.38 Oct-98 $ 122,653.20 $ 272,024.65 $ 13,730.35 $ 408,408.20 $ 381,760.84 $ (26,647.36) $ 75,459.02 .375/.270 Nov-98 $ 159,667.40 $ 343,993.96 $ 15,650.30 $ 519,311.66 $ 434,908.27 $ (84,403.39) $ (8,944.37) .375/.270 Dee-98 $ 165,041.77 $ 423,021.57 $ 17,966.76 $ 606,030.10 $ 478,176.25 $ (127,853.85) $ (136,798.22) .375/.270 Jan-99 $ 166,415.65 $ 425,096.35 $ 683.99 $ 33,100.22 $ 625,296.21 $ 622,008.17 $ (3,288.04) $ (140,086.26) .405/.300 Feb-99 $ 149,815.14 $ 468,771.58 $ 700.43 $ 35,464.49 $ 654,751.64 $ 684,627.41 $ 29,875.77 $ (110,210.49) .415/.310 Mar-99 $ 167,000.00 $ 500,000.00 $ 600.00 $ 20,000.00 $ 687,600.00 $ 661,950.00 $ (25,650.00) $ (135,860.49) .415/.310 Apr-99 $ 161,000.00 $ 450,000.00 $ 700.00 $ 20,000.00 $ 631,700.00 $ 630,875.00 $ (825.00) $ (136,685.49) .410/.300 . May-99 $ 90,000.00 $ 430,000.00 $ 800.00 $ 20,000.00 $ 540,800.00 $ 562,380.00 $ 21,580.00 $ (115,105.49) .410/.300 ,- Jun-99 $ 87,000.00 $ 400,000.00 $ 750.00 $ 20,000.00 $ 507,750.00 $ 522,725.00 $ 14,975.00 $ (100,130.49) .410/.300 Jul-99 $ 90,000.00 $ 360,000.00 $ 700.00 $ 20,000.00 $ 470,700.00 $ 483,070.00 $ 12,370.00 $ (87,760.49) .410/.300 Aug-99 $ 90,000.00 $ 330,000.00 $ 550.00 $ 20,000.00 $ 440,550.00 $ 479,465.00 $ 38,915.00 $ (48,845.49) .410/.300 Sep-99 $ 87,000.00 $ 330,000.00 $ 250.00 $ 20,000.00 $ 437,250.00 $ 490,280.00 $ 53,030.00 $ 4,184.51 .410/.300 Total YTD $1,535,593.16 $ 4,732,908.11 $ 5,734.42 $ 255,912.12 $ 6,530,147.81 $ 6,432,225.94 $ (97,921.87) Note (1) Note (1) - Amount differs from cost center 2078 on the Statement of Revenue & Expenditures by the amount in taxes. Cumulative Overage for prior year was adjusted in 3/99 by ($31,138.91) for Period 13 adjustment to accrued vacation. I I PROPANE (l...P) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) Budget Month Prior Year Oct-98 Nov-98 Dee-98 Jan-99 Feb-99 Mar-99 Apr-99 May-99 Jun...99 Jul-99 Aug-99 Sep-99 Total YTD Gallons Sold 25,822.30 33,281.20 37,883.40 42,490.80 43,123.30 46,000.00 42,000.00 37,000.00 31,000.00 31,000.00 31,000.00 33,000.00 433,601.00 Monthly WACOG $ - $ $ 0.38826 $ $ 0.43852 $ $ 0.44613 $ $ 0.45947 $ $ 0.46327 $ .$---------0.43628 $ $ 0.45000 $ $ 0.45000 $ $ 0.45000 $ $ 0.45000 $ $ 0.45000 $ $ 0.45000 $ $ 0.44590 $ LP purchases in gVnot billed G1L amount Prepaid Commodity Expense Charges 8,750.00 $ - (1,790.10) $ 10,025.77 (1,157.98) $ 14,594.47 (1,800.05) $ 16,900.92 (1,0~~~~ 19,523.2~ (2,295.1 ~l L~,___! 9,9]01..:?3 (1,100.00) $ 20,068.88 - $ 18,900.00 - $ 16,650.00 - $ 13,950.00 - $ 13,950.00 - $ 13,950.00 - $ !4,85~o., (470.40) 193,341.02 $ 193,341.02 $ Monthly Cumulative LP PGA Total LP Fuel Total LP PGA Overage YTD Overage ThermlGal. Expenses Billed (Shortage) (Shortage) $ 8,750.00 $ (8,750.00) $ 1,961.06 $ 8,235.67 $ 11,618.49 $ 3,382.82 $ 5,343.88 .492/.450 $ 13,4~6~ ..$___ 14,974.35 $ 1,537.86 $ 6,881.74 .492/.450 $ 15,100.87 $ 17,044.44 $ 1,943.57 $ 8,825.31 .492/.450 $ '18,446,13 $ 18,904.25,$_____<$~~..:.~$_u_,9!~~.3~~ _..:.~~~..:.~~O__~_ _,___ -ill $--.i?~68~~~f~~,-.T9,.p32:51 $ 1,349.93 $ 10,633.36 .492/.450___~_ $ 18,968.88 $ 20,700.00 $ 1,731.12 $ 12,364.48 .492/.450 $ 18,900.00 $ 18,900.00 $ - $ 12,364.48 .492/.450 $ 16,650.00 $ 16,650.00 $ - $ 12,364.48 .492/.450 $ 13,950.00 $ 13,950.00 $ - $ 12,364.48 .492/.450 $ 13,950.00 $ 13,950.00 $ - $ 12,364.48 .492/.450 $ 13,950.00 $ 13,950.00 $ - $ 12,364.48 .492/.450 $. 14,850.00 $ 14,850.00 $ - $ 12,364.48 .492/.450 .,--,~-_.- -'-------,-,----,_... $ 184,120.62 $ 194,524.04 $ 10,403.42 -- $ $ $ 12,364.48 184,120.62 Page 1 U:\windows\msolflCe\excel\gasf9(sheet recovlllY) Attachment #1 Page 2 of3 ENERGY CONSERVATION ADJUSTMENT tECA) ---------... -- --~ ------.-.. " Monthly Cumulative ECA .- --~- _______um__.u Budget Cost Center Interest Total ECA Total ECA _5Jverage YTD Overage NGlThenn ---------- Month Expenses Notes/Exceptlonallt 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 Dee-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 Park 85.8K,Wilson 100.8K $ 217,062.90 $ 40,830.43 $ (176,232.47) $ (194,801.81) .040/.037 Feb-99 $ 24,273.05 Other Promo 23.7K $ 24,273.05 $ 64,280.87 $ 40,007.82 $ (154,793.99) .060/.055 Mar-99 $ 25,000.00 $ 25,000.00 $ 61,925.40 $ 36,925.40 $ (117,868.59) .060/.055 Apr-99 $ 25,000.00 $ 25,000.00 $ 60,055.80 $ 35,055.80 $ (82,812.79) .060/.055 May-99 $ 25,000.00 $ 25,000.00 $ 53,511.30 $ 28,511.30 $ (54,301.49) .060/.055 Jun-99 $ 25,000.00 $ 25,000.00 $ 49,551.90 $ 24,551.90 $ (29,749.59) .060/.055 ',- Jul-99 $ 25,000.00 $ 25,000.00 $ 45,921.90 $ 20,921.90 $ (8,827.69) .060/.055 Aug-99 $ 95,000.00 $ 95,000.00 $ 45,591.90 $ (49,408.10) $ (58,235.79) .060/.055 Sep-99 $ 25,000.00 $ 25,000.00 $ 46,691.70 $ 21,691.70 $ (36,544.09) .060/.055 Total YTD $ 622,464.96 $ - $ 622,464.96 $ 552,863.88 $ (69,601.08) ---.- ENVIRONMENTAL IMPOSmON ADJUSTMENT (EIA) Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlThenn Month Expenses Notes/Exception_lit 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 Dee-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 $ 1,426.25 Legal 755, Envir Cons 671 $ 1,426.25 $ - $ (1,426.25) $ 369,300.31 .000/.000 - Mar-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 358,300.31 .000/.000 Apr-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 347,300.31 .000/.000 May-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 336,300.31 .000/.000 Jun-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 325,300.31 .000/.000 Jul-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 314,300.31 .000/.000 Aug-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 303,300.31 .000/.000 Sep-99 $ 11,000.00 $ 11,000.00 $ - $ (11,000.00) $ 292,300.31 .000/.000 Sep-98 $ 10,000.00 $ 10,000.00 $ - $ (10,000.00) $ 282,300.31 .000/.000 Total YTD $ 90,612.69 $ - $ 90,612.69 $ - $ (90,612.69) - ..-- -- -~-- -_._._-----"."'_._~-- Page 2 -~ ~~~._-,-~~- TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Budget Total All Total Recovery -_. Month Expenses Billed Prior Year $ 8,750.00 S - Oct-98 S 444,748.70 $ 417,729.58 Nov-98 $ 604,553.92 $ 477,745.74 Dee-98 $ 659.418.32 S 527,510.00 Jan-99 S 860,922.74 S 681,742.85 Feb-99 $ 698,133.52 S 767,940.79 Mar-99 S 742,568.88 $ 744,575.40 Apr-99 S 686,600.00 S 709,830.80 May-99 $ 593,450.00 $ 632,541.30 Jun-99 S 557,700.00 $ 586,226.90 Jul-99 $ 520,650.00 S 542,941.90 Aug-99 $ 560,500.00 S 539,006.90 Sep-99 S 488,100.00 $ 551,821.70 Total YTD S 7,426,096.08 $ 7,179,613.86 -+--_._---+ WEATHER NORMALIZATION lWNA) Budget Month Beg. Sa!. Oct-98 Nov-98 Dee-98 Jan-99 Feb-99 Mar-99 Apr-99 May-99 Jun-99 Jul-99 Aug-99 Sep-99 Total YTD Interest Expense Rate/Gallon LP Gallons NG Therms RatelThenn _.._-~--~_.- Started 3/8/99 -- -~_. 30,000.00 $ 1,400.00 S 0.027 1,200,000.0 S 0.030 42,000.00 S 1,200.00 $ 0.027 _ __!..!_9.o}l.oQ.g s 0.030 -_no 37,000.00 S 1,000.00 S 0,027 --- 1,560,000.0 -f..-----.O:030- 31,000.00 $ 800.00 S 0.027 1,450,000.0 $ 0.030 31,000.00 S 600.00 $ 0.027 1,340,000.0 $ 0.030 31,000.00 $ 400.00 $ 0.027 1,330,000.0 S 0.030 33,000.00 $ 200.00 $ 0.027 1,360,000.0 S 0.030 235,000.0 $ 5,600.00 10,030,000.0 1) Amount differs from cost center 2078 on the Stmt of Rev & Exp by the amount in taxes. Page 3 Monthly Overage (Shortage) $ (8,750.00) $ S (27,019.12) $ S (126,808.18) $ $ (131,908.32) $ S (179,179.89) $ $ 69,807.27 $ S 2,006.52 $ S 23,230.80 S $ 39,091.30 $ $ 28,526.90 $ $ 22,291.90 $ $ (21,493.10) $ $ 63,721.70 $ $ (246,482.22) __ ..'__n'_'____ __ Cumulative YTD Overage (Shortage) 510,037.43 483,018.31 .415/.532 356,210.13 .415/.532 224,301.l!~ ~15/.532 45,121.92 .445/.532 114,929.19 .475/.552 116,935.71 .475/.552 140,166.51 .470/.552 179,257.81 .470/.552 207,784.71 .470/.552 230,076.61 .470/.552 208,583.51 .470/.552 272,305.21 .470/.552 Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) s - S - $ - S - $ - $ - S ... "_....-=--S____,___-=. S (273,905.00) $ (273,905.00) S 35,410.00 $ (238,495.00) S 53,634.00 $ (184,861.00) $ 46,799.00 $ (138,062:60) S 43,537.00 $ (94,525.00) $ 40,437.00 $ (54,088.00) $ 40,337.00 $ (13,751.00) $ 41,491.00 $ 27,740.00 $ 27,740.00 Total All Thenn NG/LP WNA NGlTherm LP/GaI. Attachment #1 Page 3 of 3 - . -- -' '-,-_._--_., ---~ -.._--,--" _n .0301.027 .030/.027 .030/.027 .030/.027 .030/.027 .030/.027 .030/.027 U:\w1ndowslmsollice\exce a -.... CSW:03125/99 I I ATTACHMENT #2 Page 1 of 2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 03/01/99 - 09/30/99 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) II. Calculation of the Required Natural Gas PGA WACOG for FY 97/98 A. Therm Sales Projection for 10/1/98 - 9/30/99 = B. Projected NG Reservation Cost 10/1/98 - 9/30/99 = $ Projected NG Commodity Cost 10/1/98 - 9/30/99 = $ Budgeted Other Supply Related Expenses = $ Total Recovery Needed for FY 98/99 only = $ Over Recovery of FY 97/98 PGA = $ Total Annualized Recovery Needed for FY 98/99 = $ C. Required Weighted Average Recovery CosVTherm $ 50.0% Standard = ~ Non-Standard = 100.0% 9,125,000 Therms @ 9,125,000 Therms @ 18,250,000 Therms D. Projected NG PGA Annual Revenue = III. Required Natural Gas PGA Billing Factors for 10/01/98 - 3/31/99 A. Required Standard Rate PGA Billing Factor for the Year B. Less Non-Standard Differential for Reservation Cost C. Required Non-Standard PGA Billing Factor = $0.110 18,250,000 1,510,000 4,790,000 255,000 6,555,000 (102,ooo) 6,453,000 0.354 $ $ WACOG 0.410 0.300 Pinellas NG PGA = Pasco NG PGA = Total NG PGA = = Recovery $ 3,741,250 $ 2,737,500 $ 6,478,750 $ 5.978,366 $ 500,384 $ 6,478,750 = $ $ 0.410 (O.110) $ 0.300 u:/chuck\excel\gasrateslpge1 q978.xls Note: # It is recommended that the "Charge Per Non-Interruptible Therm" differential be rounded to the nearest 0.5 cent or SO.11 0 for this semi-annual cycle. 1~ ~~_~W~TE~_FY88II' PURc:~~.ED GA.~, COST PR~!,CT10tl~ ~S.Q!,__ 311111119 _.~-.~---- - -----._---- --_._~-------._..- -- ..-- "----- _ _._u_ ----..- ___h'__ __n ."--..-..---- --------,. --.- ------- ---- -- _ ___..____.._..________ 1Se_~on~,!:Ll1'f!_~ ---- -. Eaulv_ -. _HI ~u""'" _u _m ~ Actual P"'-"" - - c-Ilv A'I........ A..la-b. NHTlI Purdouod - c:--.. Per Month C. "-"" P.,Monlh ....- ....Monlh ....Monlh -.. ....- ....- Oct..,. 232 76 41788 $0.00 131,2n . .uoo 135932 ..,""... 0 Nov-9I .... 7. SH20 $0.00 _---EM'-' . 22..... 144 472 116122.42 4.055 - 3'6. 7., S5211 ISl.l106.15) 223..... . 3..... WLl.. ""'91" 1 ,1209 1---.. '- 316. ,., 55'11 1S'3S4.5 _ _ 1~"2 . 46 200236 I7S.3Oe.SO -517 ~ 2'" 132 .,-- C$' 157.151 __-1-~2" . .2 000 177_'90 "7701.10 0 _-9' l16 78' 55211 ($ 1 170.(1)) --.. 177805 0 ll000 211000 194 195 0 -," 306 570 53 '30 ($1 170.(0) 165000 0 22 500 179 000 195 000 0 ....-99 ,..212 ., 788 1$ 1 170.001 18500 0 12400 156 000 167500 0 u".gg 139560 40 440 ($ I 170.001 29 500 0 10500 145000 150500 0 01," 1.... 212 41188 ($ 1 170,(0) '6 500 0 10850 134 000 139500 0 ......" 144212 " 788 1$ 1 170,(0) 52 500 0 10850 133 000 133500 0 5eo-" 139560 40 440 1$ 1 170,001 45500 0 12000 136 000 1 J4 500 0 Tot.1 2 793 771 570 393 ($11 707.en 1465813 0 267 600 1920218 1 "2 209 ............ _T_. NNTS ........... ""'.......T_. ........... c.c,_ WACOG WACOG LoecI ............ -- _IIV_ _UV_ Reoelvatkln _III V_ CammndItw Coot Fuel Coot F.. - Said F.- T_ _IIV_ ....- ....- _III V_ P.,Man1h p.,- Pot_ p.,- Pot_ ....- SoldO.. -.. ....- ....Man1h Ocl..,. $87"2.23 $2 lM $842.1S 5J4 -"7 5568.32 532...37.7. $0.00 $ 10 233.90 $2 72.58 $1.27 .3.11 _ _ 4'~ ......'L7I .......,. 5'lS"lL2. 52 1.68 ....'3 __ _.J4~1I! ---~~ --r~:.: c--- -~~}-- l!.!tltS.17 S2. 797'" 14..7. --_..._~ 1------______~7,?~ ._---~I!.~ -... 11'9.1'9.1' $3 83.16 $ .... 3.00 -t~~::: -..i"L76 12. 943.29 $U' '3.11 :i~ . ~ ....." 0"'369.53 13. 004.36 'US $979,36 SS'" 164.1. S661.2S SIZ Z...77 $3 ...... $US "'.Ill ,.., .-i07 137.76 55 I4lUI2 SU22.07 S4Cl"32.4S "'lL.. $3"....".. S661.2S $12662." $3 14.77 '3-07 SU. 13.16.. SS4S.......,. ....-99 (118122.11 $5 794.70 11 829.00 SO 035.61 $1297.46 $517 869," 10,00 S 14470.44 13 398.41 $US n.S3 52,20"1. $684.840,92 _-99 $11' 468,20 t..41S.67 II 327.50 '43 582.85 " 255,61 $437 "21.70 $0.00 $11284.61 53 "2,50 $3.34 $2.07 54.11'" $591976.25 ....-99 $53226.77 $4 602,7' '731.60 Sl" 016.47 $982.02 $JaO 158,12 10.00 S 10554.36 $1 931.25 $3-01 12.10 90.05'10 $469 372.95 Jun." IS 1 4n.03 53 689.87 1619,50 532986.91 $950.34 5352 795,53 10.00 18895.99 $2633.75 13-03 12.92 83.61"- $439043.97 Jul," $53 226,77 53 313,1' $640,15 U4 086.41 $982,02 5325254,92 10.00 $8 012.02 12 441.25 IU' $2,17 15.OM. $414378.30 AUII-" $53226.77 13313.1' $640,15 $34 016.41 - $982.02 1322759,32 10.00 $8 263.96 $1.336.25 53.'. '3.01 11.77'1. 1411 "2.10 5op." $5l '12.03 3 448.07 $708,00 $32 986,91 $950,!~ 5330 335,13 10.00 $722..., $1 353.75 $3.06 .~~ '4,72" '416672.01 ----,-~ ._----~-. -- - .~-,- --- -- - --- -.. -, .------.- - -.-- -----. -------- . --------.---.- ------ ---.-.--- .-. -- ------- .------- ------ - ----- --...--- --- ----.- -..- -- _. - ___ o. - -.------ ----.- .- ___._.u._ _ ~--.J,t".'Q!,l9 .----..- .._. ---- . ---'6.ii,.l7Ci.40 -- ___'~1~3J.'_I~:~L -- $'7,399.88 ''',6)4,10 "61,224.69 '11,696.19 '''l'''j071.]' $ 1,540," _'1~?,-U5.50 $3.2" _~I.:..o..~~ ._._.u__ ---- - A~!!!p_ __ -- -..-- - -..- --~------ N~_;_------- ---~ ----- f---- -------..---- ----..---... -- '--- - ---- ___.n.____. .-- __._'____'n - --- _. __u___ -------- v;,-~ .,.-~..d;' hh10riul ~;.- and.;;;;; ;d,;....h;;:- Fer 1-;-';'; ;;t;'I;;"Ud ruel r~-;;;;' hued on ~~~i ~---- , ... ..... .---.,,- ..-----.-------- -. --.-.--- -r.t.1 P';;j~d.d --- -, DTH WACOC I"DnfOVIIId IP.lI$I.,riffralft. T atoll Retervoltlon Tot.l Commoditv C... Thtose numben ~ a betllook IoIwMd tt.sed on current ct.t.. lsa6Monlhs 1925207.78 $1 570 836.37 $3496 04'.15 977 851 $3,575 2nd 6 Monlhs $586555.55 $2 162710.71 $1 7'9 326.26 920 500 $2.987 TOTAL 11.511 763.32 $' 733 607.08 $6245,370.40 1898 351 $3.290 8ud... 2078 $ 6,245.370.40 $ 3.29 ..... -- .. r i PROPA". INVENTORY AND WEIGHTED COST OF GAIIWACOG . --. ,PREPARED BY TERRY NEENAN DATE O3fISIII , I LP ........... hv F........ 544-141. '0... Conlnct Enda _ J. Scott 1Md... IN\/ENTORY TANK COST OF GALlONS DEUVERED DEUVERED TOTAL NEW DATE YiITHORAW INVENT. WACOG INVENT DELIVERED PRICE INVOICE GAlLONS WACOG - 32.0118.0 0.38828 '12.450,7' . . 16,~ . 0.500<< Conoco P.-poy 101_ 41364 $0.42142 '17431.58 i.29ll . 0.53580 . 4 i80.1O 26,201 '0.42142 . ',750.00 10122/i7 50 383 $0.404" , 20 3ll8.75 I.M , 0.32850 , 2 iIS.17 35,200 $O.40411i 10122/i7 50 383 $0.41393 , 20 848.70 , 0.05000 , 44i,i5 35,200 $0.41393 , 449,i5 101221117 50 383 $0.42818 , 21 584.83 , 0.079n , 717.93 35,200 $0.42818 , 8,300,05 10122/i7 58183 $0.41351 , 24 464.23 1.100 , 0.32850 , 2 m.1O 44.000 $0,41351 10/22/97 5il83 $0.42094 , 24 904,23 , 0.05000 , 44ll.00 44.000 $0.42094 . 44ll.00 10/22/97 . 59183 $0,43281 , 25,106.20 , 0.079n . 701.17 44,000 $0.43281 . 7,860.05 1 0/22/97 68164 $O,41i17 , 28 572.03 9,001 . 0.32850 . 2.965.83 53.001 $0.41917 10/22117 68.164 $O.425n . 29 022.01 , 0.05000 . 450.05 53,001 $0.42577 . 450.05 10122187 68164 $0.43830 . 29 740.01 , O,079n , 718.00 53.001 $0.43630 . 7,410.00 10/22/97 nl. $0.42384 , 32 708.23 9.002 . 0,32850 , 2,968.18 62,003 $0.42364 10/22/97 nl. $0.42968 , 33 158.33 . 0,05000 . 450,10 62.003 $0.42968 . 450.10 10122/97 n,lt11 $0,43891 . 33,874,41 . 0.079n . 71'.01 62.003 $0.43698 . 6,i59.90 10/30/91 nlt11 $0,43891 33,874.41 62.003 $0,43896 10/30/91 40,673 36.2i9 $0.431" 16.812.54 62,003 $0.43698 1110519I 47100 $O.442n 20.854.58 8,101 . 0.32850 . 2 899.93 70 104 $O.442n 11105198 47100 $O.442n 20.854.58 , 0.05000 . 440.05 70,104 $0.44277 . 44ll.05 11105198 47100 $O,44ID 20 854.58 . 0.079n , 702.05 70,104 $0,44277 . 6.519.85 11/05198 58100 $0,44463 24 955.04 9.000 , 0.32850 . 2 965.50 79 104 $0.44483 1110519I 58100 $0,44463 24 955.04 , 0.05000 450.00 79104 $0.44463 . 450.00 11105198 58100 $0.44463 24 955.04 . 0.079n 717.13 79104 $0.44463 . 8 089.85 11105198 85 000 $0.44881 29 042.58 8900 , 0.32850 2 932.55 .704 $0.44881 11105198 85 000 $0.44881 29.042.58 , 0.05000 445.00 .704 $0.44881 , 445.00 11_ 85 000 $0,44881 29,042.58 , 0.07977 70UB 68,704 $0,44661 . 5,624.85 1113019I 36,114 26 B86 $0.44611 12012.89 68704 $0,44661 12101I8I 35 685 $0.45158 16.204.36 1M . 0.33500 3 023.87 97 703 $0.45158 12/011t1 35 685 $0.45158 18 '"".31 . 0.05000 449.i5 97.703 $0,45158 . 448.i5 12/08181 35 685 $0.45158 . 16.204.31 . 0.079n 717.85 97 703 $0,45158 . 5 174.80 12101I8I 44 685 $0.45441 . 2O,396.2i i.ooo . 0.33500 3024.00 108,703 $0.45441 12/08/18 44.685 $0.45441 . 20 396.2i . 0,05000 450.00 106 703 $0.45441 . 450.00 1_ 44 685 $0.45441 . 20.396.28 . O,079n 717.13 108 703 $0,45441 . 4,724.80 12/01181 53 685 $0.45627 . 24.4i5.08 1.1OlI , 0.33500 2958.10 115,503 $0.45627 12108188 53.685 $0.45627 , 24.495.08 . 0.05000 44ll.00 115,503 $0.45627 . 440.00 1210919I 53,685 $0.45627 . 24 4i5.08 . 0.078n . 701.11 115.503 $0.45827 . 4,264.80 12101l191 62 687 $0.45768 . 28,781.01 9.202 . 0,33500 . 3.091.17 124,705 $0.45768 12/09191 62.687 $0.45768 . 21711.01 , 0.05000 . 460.10 124,705 $0.45768 . 46().10 12/09191 62 687 $0.45768 . 29,781.01 , 0.07877 . 734.04 124,705 $0.45768 . 3,624.80 12109191 71,881 $0.45868 . 32.973.47 iOOl . 0.33500 . 3024.34 133,708 $0.45868 12/09/91 71 ,881 $0,45868 . 32,873.47 . 0.05000 . 450.05 133.708 $0.45881 . 450.05 1 ZI09I9I 71,881 $0.45868 . 32 973.47 . O,079n . 711.01 133.708 $0.45881 . 3,374.75 12/111t1 10 881. $0.45947 . 37 165.40 9000 . 0,33500 . 3.024.00 142.708 $0.45947 12/10181 10 B86 $0.45947 . 37 165.40 . 0,05000 . 450.00 142.706 $0.45947 . 450.00 12/1 0191 10 881 $0.45947 . 37 165.40 , 0.079n . 717.13 142.708 $0.45947 . 2,824.75 12131181 50.744 30,144 $0.45947 . 13850.1i 0110519t 311544 $O,4eOll7 . 11,229.42 8._ . 0.33500 . 3.158.40 152.108 $O.4eOll7 01105198 311544 $O.4eOll7 . 11.22U2 , 0.05000 . 470.00 152108 '0.4eOll7 . 470.00 01105198 38 544 $O.4eOll7 . 18.22U2 . O.079n , 749.14 152,108 $O.4eOll7 . 2,454.75 0110519t ....544 $0....,. . 22 QII,35 8.000 . 0.33500 . 3,024.00 181,108 $0.461. 0110519t ...544 $0....118 . 22 QII,35 . 0.05000 . 450.00 181.108 $0.461. . 450.00 0110519t ...544 $0.461. . 22.QII.35 . 0.078n . 717.13 181108 $0.46168 . 2.004.75 01122199 57 B45 $0.46248 . 26.752.... 8,301 , 0.33500 . 3,125.14 170.407 $0.46249 01122199 57 B45 $0,46248 . 26 752.46 . 0.05000 . 465.05 170,407 $0.46248 . 485.05 01122199 57 B45 $O.4624i . 26 752.46 . 0.079n . 741.94 170.407 $0.46248 . 1,538.70 01122199 68 848 $0.46293 . 30 944.87 8,001 . 0.33500 . 3,024.34 179 408 $O.462i3 011221119 68 lI48 $0.46293 . 30 944.87 . 0.05000 . 450.05 179,408 $0.46283 . 450.05 011221118 68.848 $0.46293 . 30.844.87 , 0.078n , 711.01 179,408 $0.46293 . 1,019.85 01121199 76 047 $0.46327 , 35,230.42 8.21l1 , 0,33500 . 3091.54 168,809 $0.46327 0112_ 78 047 $0.48327 , 35 .42 . 0.05000 , 460.05 188.809 $0.46327 , 46().05 0112_ 78,047 $0.46327 I 35 .42 , 0.078n , 733." 188 BOt 10.46327 I 628.80 01/31'" 47,526 21.521 $0.48327 , 13,212.87 0_ 37.721 $0._ , 17 481.08 8.200 I 0.33500 , 3091.20 187 BOt $0,46368 0_ 37721 $0._ I 17 496.08 , 0.05000 I 460.00 187 BOt $0._ , 480.00 0_ 37721 $0._ , 17,488.08 I 0.07W7 I 733,U 187 108 $0._ , 188.10 02/CI6I98 41113 $0.46411 I 18083.78 3382 , 0.33500 , 1145.52 201~1 $0.46418 0_ 41.113 $0.46411 , 18083.78 , 0.05000 , ll1l1.eo 201.21l1 $0.46418 , 118.10 0_ 41113 $0.46418 , 18083.78 I O.079n . 27O,U 201.21l1 $0,46418 , 10.00 0_ 46721 $0.45405 , 21.213.51 5.801 $0.30000 . 18112.40 208108 $0.45405 02/06/81 46721 $0.45405 , 21 '13.51 O.079n . 447,35 201.201 $0,45405 021231118 58158 g' 24815.32 8434 0.3lI23lIll2i . 3701.11 218.243 $O.443lIlI 02122188 85 832 $0 , 21634,00 un 0.3lI23lIll2i . 3.718.88 225 720 $0.43621 0_ 43,389 22,ZJ3 n; 28' 8.8811.I1 03I03IlI8 31714 '"'"Il1Z!lITi , 32 354.34 8.461 . 0,38240 . 3 720.34 235.201 ".020'8 03I03IlI8 41153 $0.87820 , 36 051.20 8,438 , 0.311240 I 3 703.. 244 &40 $0.87820 Tolaf Gallona IIu !nY. GaL Total G-.. - 220 45lI eo 881 ~ 227 735 , 88 493.27 Pounda _ Gal 8.23 M.._117 503 832.24 - 0,3797979 CSW:03l25/99 Applicable Annual Therm Range or Other Rate Determinant Monthly Custorrier Charge Non.Fuel Ene'1aY Cha'llelTherm Non.Fuel Energy Charge Energy Conservation Adj. (ECA) Environmenlallmposltion Adj. (EIA) Weather Normalization Adj. (WNA) Total Non-FueI Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelThenn Minimum Monthly Bill Compares to LPIGal10n Rate of with 6.0% Frenchlse Change from 9/98 Therm Rate UtII~ Tax Note. Fuel Rate perTherm 10101/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR APRil I, 1999- SEPTEMBER 30, 1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS -B.S.... -B!E.... .JIML -.lME.... NA (1 - NA (4 + NA (4 + NA (4 + 3 Units) Units) Units) 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.ll3Q ll.ll3Q ll.ll3Q ll.ll3Q $0.870 $0.870 $0.870 $0.670 U1Q U1Q U1Q U1Q $1.080 $1,080 $1.080 $1,080 $7.00 $15.00 $20.00 $50.00 Firm Natural Gas Rate Schedules ...sGS.... ...MGS.... ...J.GL ~ ..JiAC.... ....LAC.... 0- 18,000- 17,999 99,999 $15.00 $20.00 $0.470 $0.410 0.060 0.060 0.000 0,000 ll.ll3Q ll.ll3Q $0.560 $0,500 U1Q U1Q $0.970 $0,910 100,000 &up NA (1 - NA (0 - NA (150 3 Units) 149 tons) tons & +) $50.00 $7.00 if $15.00 if $15.00 if $15.00 not prevo not prevo not prevo billed billed billed $0.350 $0.200 $0.150 $0,100 $0.200 ll.ll3Q $0.440 U1Q $0.850 $50.00 0.060 0,060 0,060 0.060 0.060 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA 0.000 ....sL... SL wlM& .J'iGY... B8Iigbl NA NA NA Interr. lQ.Ba1t ..l:lSS.... ---IS...... NA 100,000 &up $15.00 $7 Resl./ $25.00 $100.00 $15 GS if not prev. billed $0.300 $0.100 $0.470 $0.280 0.060 0,060 0.060 NA ll.ll3Qll.ll3Qll.ll3Qll.ll3Qll.ll3Qll.ll3Qll.ll3Qll.ll3Q $0.290 $0,240 $0.190 $0.290 $0.390 $0.190 $0,560 $0.310 $0.700 $0.650 $0.700 U1Q U1Q U1Q U1Q U1Q U1Q U1Q ll.3llll $0,970 $0.610 $0.800 $7.00@ $15.00@ $15,OO@ premise premise premise $15.00 +FAC $0.800 $0.600 $15,00 $7 Res!.1 + FAC $15GS@ premise +FAC $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 0.988 $ 0,988 $ 0,988 $ 0.988 $ 0,888 $ 0,833 $ 0.778 $ 0.641 $ 0.595 $ 0.549 $ 0.641 $ 0.732 $ 0.549 $ 0.888 $ 0.558 $ 1,047 $ 1.047 $ 1.047 $ 1.047 $ 0,941 $ 0,883 $ 0.824 $ 0,679 $ 0.630 $ 0.582 $ 0.679 $ 0.776 $ 0.582 $ 0.941 $ 0.592 $15.00 $20.00 $ 0.085 $ 0.085 $ 0.085 $ 0.085 $ 0,085 $ 0.085 $ 0.085 $ 0.085 $ 0.085 $ 0,085 $ 0.085 $ 0.085 $ 0.085 $ 0.085 $ 0.085 $0.069 $0.069 $0.069 $0.069 $0,341 $0.341 $0.341 $0.341 BTU FACTOR. THERMS/l00 CUBIC FEET ICCF) Firm Service Rates Interruptible Service Rates .tllLill 11LSB. 12lia D.1Lii 1.076 1.079 1.080 1.081 $0.089 $0.069 $0.341 $0.341 ll2L9ll Q3lia $0,069 $0.341 lMla9 1.082 1.061 $0,069 $0.069 $0,069 $0.069 $0.089 $0,069 $0.069 $0.055 $0.341 $0.341 $0.341 QSLS.a $0.245 .' ATTACHMENT #5 Contract HG..Bata ~ NA By Contract - By Contract NA NA ll.ll3Q Contract + $0,030 Plus ll.3llll $0.330 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms ~ $ 0.085 $0.069 $0.231 1,055 1.058 1,059 1,059 1,082 1.085 1.061 1.064 $0,341 $0.341 $0,341 $0,341 ~ llll.l92 .llZlii llll.l92 CSW:03/25/99 Attachment #6 Page 1 of 3 BTU Factor: 2..l.M Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2Aaa Therms/100 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS (NEW CUST. EFF. 3/8/99) Therm Fador: ~ Therms/Gallon FOR APRIL 1, 1999 - SEPTEMBER 30, 1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS Contract LP Svc. RLP MLP GLp. LLP LPV LPS CLP Applicable Annual Gallon Range NA NA o - 2,500 Gallons 2,501 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) Monthly Customer Charge $7.00 $15.00 $15.00 $20.00 $7.00 Res!. or $25.00 Set By Contra... $15.00 GS if not Non-Fuel Energy Charges/Gallon: prevo billed @ premise Non-Fuel Energy Charge IGallon $1.400 $1.400 $0.200 $0.150 $0.100 $0.390 Set By Contrad Energy Conservation Adj.lGallon 0.055 0.055 0.055 0.055 0.055 0.055 NA Environm'llmposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0Jl2Z 0Jl2Z 0Jl2Z 0Jl2Z 0Jl2Z 0Jl2Z 0Jl2Z Total Non-Fuel Charges/Gallon $1.482 $1.482 $0.282 $0.232 $0.182 $0.472 By Contract + $0.027 Purchased Gas Adjustment/Gallon ~ ~ ~ ~ ~ ~ ~ -, Total Energy Charges/Gallon $1.932 $1.932 $0.732 $0.682 $0.632 $0.922 $0.477 + Contrad NFE Minimum Monthly Bill $7.00 $15.00 $15.00 $20.00 Any Applicable $25.00 Customer Charge + Customer Charge Non-Fuel Energy Ch + Any Applicable for the Contraded Facility Charges # of Gallons/Mo. Note: Utility Tax is billed on total LP bill. . . .' CSW:03125/99 Attachment #6 Page 2 of 3 BTU Factor: 2..Z.M Gallons!100 cubic feet (ccF) CLEARWATER GAS SYSTEM BTU Factor: 2MJ Therms!100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: Q...915 Therms!Gallon FOR APRIL 1, 1999. SEPTEMBER 30, 1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL LP SERVICE WILL CALL SPLASH - PREPAID COMMERCIAL CONTRACT ..... BBL!1 IIBIJ!Z .BBLf3 .BBLfj ~~ BBllfLe1 BRSPLP1 BBSeL.e2 BRSPLP2 BkLe1 Sld.f1 kLf Applk:llble Annu. G-'1on Range 0- 80 80.1-120 120.1 - 300 > 300 0-300 > 300 o -200 >200 0-400 >400 o - 2500 > 2500 NA or Other Rate Determinant 1-3 UNIT 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNIT 1-3 UNIT 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annu. Customer Charge $ 84,00 $ 80.00 $ 48.00 $ 36.00 $ 38.00 NA $ 38.00 NA $ 38,00 NA $ 80,00 $ 80,00 Set by connel Non-Fua. Ena~ Cha'VHlGallon' Non-Fuel Energy Charge/Gallon $ 1.300 $ 1.150 $ 0.700 $ 0.800 $ 0.700 $ 0.800 $ 0.600 $ 0.500 $ 0.500 $ 0.500 $ 0.200 $ 0.150 Set By Contract Energy Conservation Adj.lGallon 0.055 0.055 0,055 0.055 0.055 0.055 0.055 0.055 0,055 0,055 0.055 0.055 NA Environm'llmposition Adj.lGallon - - - - - - - - - - - - NA Weather NOnNIlizallon Adj.lGellon 0.027 0,027 ~ 0.027 ~ 0,027 0,027 0,027 0,027 0.027 0,027 0,027 M2l Total Non-Fuel ChargNIGallon $ 1.382 $ 1.232 $ 0.782 $ 0.682 $ 0.712 $ 0.682 $ 0.682 $ 0.682 $ 0.682 $ 0.1582 $ 0.282 $ 0.232 Set By Contract + ..' 0.027 Purcha88d Gas Adjustment/Gallon 0.450 0,450 0.450 0.450 0.450 0.450 0.450 0.450 0.450 0,450 0.450 0.450 ~ - - Total Energy ChargeslGallon $ 1.832 $ 1.182 $ 1.232 $ 1.132 $ 1.232 $ 1.132 $ 1.132 $ 1.032 $ 1.032 $ 1.032 $ 0.732 $ 0.682 0.477 + Contract NFE Notes: 1. No Monthly Minimum Bm 2. Utility Tax Is billed on total LP bill. cSW:03/25/99 BTU Factor: BTU Factor: Therm Factor: 2..Z.1A Gallons/100 cubic feet (CCF) ~ Therms/100 cubic feet (CcF) l2.i15 Therms/Gallon CLEARWATER GAS SYSTEM CLOSED METERED PROPANE (LP) RATE BILLING FACTORS (THRU 3/31/2000) FOR APRIL 1, 1999 - SEPTEMBER 30, 1999 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #6 Page 3 of3 Contract LP Svc. RLP-C MLP-C GLP-C LLP-C LPV-C LPS-C CLP-C Applicable Annual Gallon Range NA NA o - 2,499 Gallons 2,500 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) .-.-' Monthly Customer Charge S7.00 S15.00 $15.00 $20.00 $7.00 Resl. or $25.00 Set By Contract $15.00 GS if not Non.Fuel Enel:gY Charg../Gallon: prevo billed @ premise Non-Fuel Energy Charge IGallon $0,750 $0.750 SO. 390 SO.320 $0.100 $0.390 Set By Contract Energy Conservation Adj. IGallon 0.055 0.055 0.055 0.055 0.055 0.055 NA Envlronm'llmposltion Adj. IGallon 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon Q.Q2Z Q.Q2Z o...o.2Z Q.Q2Z Q.Q2Z Q.Q2Z Q.Q2Z Total Non-Fuel Charges/Gallon $0.832 $0.832 $0.472 $0.402 $0.182 $0.472 Set By Contract + $0.027 Purchased Gas Adjustment/Gallon MSQ MSQ MSQ MSQ MSQ MSQ MSQ -- Total Energy Charges/Gallon $1.282 $1.282 $0.922 SO.852 SO.632 $0.922 $0.477 + Contract NFE Minimum Monthly Bill $7.00 $15.00 S15.00 $20.00 Any Applicable S25.00 Customer Charge + Customer Charge Non-Fuel Energy chg. + Any Applicable for the Contracted Facility Charges # of Gallons/Mo. Note: Utility Tax is billed on total LP bill.