The URL can be used to link to this page

GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1998} CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: Mike Roberto, City Manager FROM: Chuck Warrington, Gas System Managing Director !'4_111 COPIES: Kathy Rice, Deputy City Manager; Rick Hedrick, Assistant City Manager; Cyndie Goudeau, City Clerk; Margie Simmons, Finance Director; John Scott, Asst. Director /UCS; Tom Madley, Senior Accountant /UCS; Karen Miles, Accounting Manager; CGS Management Team SUBJECT: GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1998 DATE: March 23, 1998 It is time for our semi - annual review of gas rate adjustment clauses. Attachment #1 shows the status of our adjustment clauses thru February and the projected impact of the following recommendations thru September 1998. We need to make several changes to our gas adjustment clause rates at this time to bring them in line with current levels of expenditures and forecasts. The net effect of these is a reduction in the typical bill of about 20 /therm. So this is a good news report! Attachment #2 shows an analysis of our proposed Natural Gas Purchased Gas Adjustment (PGA) for the second half of the fiscal year. This is driven by Attachment #3 which is our latest forecast of Natural Gas fuel pricing from the Municipal Gas Authority of Florida (MGAF). The impact is a recommended decrease in Natural Gas PGA of 40 per therm for the firm non - contract rates. We are proposing to decrease the Natural Gas PGA for interruptible and contract rates only 0.50 /therm and utilize a 120 /therm differential for the reservation discount. The above decreases in Natural Gas PGA is a result of seasonal reductions in gas pricing and a successful strategy by MGAF of buying strips of low cost gas. Additionally, Attachment #4 shows our purchasing Weighted Average Cost of Gas (WACOG) for Propane (LP) Gas. We are proposing to decrease the Propane (LP) Gas PGA at this time by 40 /gallon as we are seeing a lowering trend in seasonal market prices and we are currently over - recovered on LP PGA by $12,753.48 (see Attachment #1). Mike Roberto, City Manager tt March 23, 1998 1 Page 2 We are proposing to raise our Energy Conservation Adjustment (ECA) at this time by 1.50 per therm to 5.50 per therm. This is principally in anticipation of the Park Place and Wentworth project's impact on this clause. Additionally, we are proposing to raise our Environmental Imposition Adjustment (EIA) at this time by 0.50 per therm to 20 per therm. This is in order to speed our recovery of our existing deficit in our EIA account and due to anticipated increased expenses in the second half of this fiscal year from the Manufactured Gas Plant clean -up. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after April 1, 1998: Natural Gas Firm Standard Rate Schedule PGA ....... $0.410 per therm (down 40) Natural Gas Interruptible and Contract (Non- Standard) Rate Schedule PGA ............. $0.290 per therm (down 0.50 /therm) Propane (LP) Gas Rate Schedule PGA .................... $0.510 per gallon (down 40 /gallon) _ $0.557 per therm equivalent (down 4.40 /therm equivalent) Energy Conservation Adjustment (ECA) ............... $0.055 per therm (up 1.50 /therm) _ $0.050 per gallon of LP (up 1.30 /gallon) Environmental Imposition Adjustment (EIA) ......... $0.020 per therm (up 0.50 /therm) _ $0.018 per gallon of LP (up 0.40 /gallon) 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 deficit by a total of ($20,035.57). This negatively impacts our bottom line financials. Attachment #2 shows our calculation of required second half Natural gas PGA pricing based on Attachment #3 which is Terry Neenan's and MGAF's current Natural Gas Purchased Gas Supply Cost Projections. Attachment #4 shows our FY 97/98 fiscal year -to- date history of Propane (LP) Gas supply costs. Finally, Attachments #5 and #6 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Mike Roberto, City Manager March 23, 1998 Page 3 It is our plan to use the above- proposed adjustments for billings through September 30, 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 April 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: Mike Roberto, City Manager \ \GSA1 \CWARRING \My Documents \MSOFFICE \WINWORD \GASRATES \Gas Adjustments for April 1998.doc ATTACHMENT #1 Page 1 of 3 CSW:03/20/98 CLEARWATER GAS SYSTEM _ SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS NATURAL GAS PURCHASED GAS ADJUSTMENT (P A-N 1 �T Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel _Total NG PGA Overage _ YTD Overage Rate/Therm Month Charges Charges Expense Expenses (1) Expenses Billed (Shortage) (Shortage) Firm/Contr Prior Year - $ - $ (135,441.89) Oct -97 $ 134,807.13 $ 227,499.60 $ 677.21 $11,777.83 $ 374,761.77 $ 403,213.09 $ 28,451.32 $ (106,990.57) .415/.295 Nov -97 $ 159,095.24 $ 383,880.42 $ 534.95 12,456.58 $ 555,967.19 $ 508,378.22 $ (47,588.97) $ (154,579.54) .415/.295 Dec -97 $ 69,627.35 $ 437,285.37 $ 772.90 17,544.16 $ 525,229.78 $ 624,974.96 $ 99,745.18 $ (54,834.36) .4151.295 Jan -98 $ 165,986.87 1 $ 530,558.49 $ 274.17 9,508.53 $ 706,328.06 $ 758,550.91 $ 52,222.85 $ (2,611.51) .450/.295 Jan -98 Transfer balance from WNA $ - 78,836.06 $ 78,836.06 $ (78,836.06) $ (81,447.57) Feb-98 $ 149,905.83 $ 590,706.67 $ 407.24 14,212.12 $ 755,231.86 $ 753,520.78 $ (1,711.08) $ (83,158.65) .4501.295 Mar -98 $ 166,400.00 $ 520,000.00 $ 500.00 14,000.00 $ 700,900.00 $ 752,220.00 $ 51,320.00 $ (31,838.65) .450/.295 Apr -98 $ 159,700.00 $ 420,000.00 $ 250.00 14,000.00 $ 593,950.00 $ 561,372.00 $ (32,578.00) $ (64,416.65) .410/..290 May -98 $ 86,000.00 $ 390,000.00 1 - 14,000.00 $ 490,000.00 $ 537,264.00 $ _ 47,264.00 $ (17,152.65) .410/..290 Jun -98 $ 85,100.00 _ $ 350,000.00 $ - 14,000.00 $_449,100.00 $ 449,196.00 $ 96.00 $ (17,056.65) .4101..290 Jul -98 $ 88,000.00 $ 290,000.00 $ - 14,000.00 $ 392,000.00 $ 421,972.00 $ __ 29,972.00 $ .410/:.290 Aug -98 $ 88,000.00 $ 290,000.00 $ - 14,000.0_0 $_392,000.00 $ 421,972.00 $ 29,972.00 $ 42,887.35 .410/..290 Sep-98 $ 85,200.00 $ 290,000.00 $ - 14,000.00 $ 389,200.00 $ 423,612.00 $ 34,412.00 $ 77,299.35 .410/..290 Total YTD $ 1,437,822.42 $ 4,719,930.55 $3,416.47 242,335.28 $ 6,403,504.72 $ 6,616,245.96 $ 212,741_24 Monthly Overage PROPANE, LP)_GAS PURCHASED GAS ADJUSTMENT (PGA -LP) Commodity Total LP Fuel Total LP PGA Cumulative YTD Overage LP PGA Then�n/Gal. Gallons Monthly Interest Budget Month Sold WACOG Expense Charges Expenses Billed _ (Shortage) (Shortage) Prior Year _ $ - $ - $ - $ - , $ 5,973.76 Adj 16,766.80 $ 0.50044 $ - $ $ - 8,390.78 $ $ - 8,390.78 $ 8,604.27 $ $ - 213.49 $ $ 5,973.76 5,760.27 Oct -97 557/.510 Nov -97 - 24,477.00 $ 0.52443 $ 8,793.01 $ 8,793.01 $ 12,497.74 $ 3,704.73 $ 9,464.99 .557/.510 Dec -97 32,174.10 $ 0.52608 $ 16,926.15 $ 16,926.15 $ 17,699.40 $ 773.25 $ 10,238.24 .601/.550 Jan -98 36,710.30 $ 0.52319 $ 19,206.46 $ 19,206.46 $ 20,272.60 $ 1,066.14 $ 11,304.38 .601/.550 Jan -98 Transfer balance from WNA $ 3,298.07 $ 3,298.07 $ - $ (3,298.07) $ _8,006.31 Feb-98 Mar -98 30,019.60 0.00 35,000.00 $ $ 0.50192 0.50733 $ $ 15,067.44 17,756.55 $ $ 15,067.44 17,756.55 $ $_ 16,516.54 19,250.00 $ $ 1,449.10 1,493.45 $ $ 12,753.48 14,246.93 .601/.550 .601/.550 — Apr-98 - - -- 33,000.00 - - -- $ — 0.51000 - -- $ -- 16,830.00 $ 16,830.00 $ 16,830.00 $ - $ 14,246.93 .557/.510 May -98 30,000.00 $ 0.51000 $ 15,300.00 $ 15,300.00 $ 15,300.00 $ - $ 14,246.93 .557/.510 Jun -98 Jul -98 Aug -98 30,000.00 30,000.00 30,000.00 $ $ $ 0.50000 0.50000 - - 0.50000 $ $ $ 15,000.00 15,000.00 _ 15 ,000.00 $ $ $ 15,000.00 15,00_0.00_ -- 15,000.00 $ $ 15,300.00 15,300.00 $ $ $ 300.00 300.00 300.00 $ $ $ 14,546.93 14,846.93 - 15,146.93 .557/.510 .557/.510 - -- -_ $ 15,300.00 .557/.510 Sep-98 Total YTD 30,000.00 358,147.80 $ 0.50000 $ $ 15000400 181 568.46 $ $ 15,000.00 181,568 46 $ $ 15,300.00 18811 70 55 $ $ 300.00 - - 6,60209 $ 15,446.93 - 1 .55_7/.510_ - - $ 0.50697 $ - Page 1 ATTACHMENT 91 Page 2 of 3 ENERGY CONSERVATION ADJUSTMENT T Monthly Overage (Shortage) Cumulative ECA Budget (� -- Month ' Cost Center - -.- - ----- ----- Expenses Notes/Exceptional Items Interest Expense Total ECA Total ECA Billed YTD Overage NGrrherffTn - ------- Expenses (Shortage) LP/Gal. Prior Year $ $ - $ 249.67 $ 8,868.04 $ 13,611.96 $ 24,961.63 .030/.027 oct_�� Nov-97 $ 7,365.60 $ 15,267.86 rt Sales/Promo 5.8K, Advertising 1.5K $ — Sales/Promo 14.6K $ 15,267.86 $ 24,135.90 $ 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/.637 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 $ 30,000.00 $ 30,000.00 $ 48,704.28 $ 18,704.28 $ 98,011.18 .040/.037 Apr-98 $ 30,000.00 $ 30,000.00 $ 54,967.61 $ 24,967.61 $ 122,978.79 .055/.050 May-98' $ 30,000.00 $ 30,000.00 $ 52,506.63 $ 22,506.63 $ 145,485.42 .055/.050 Jun-98 $ 40,000.00 $ 40,000.00 $ 44,435.66 $ 4,435.66 $ 149,921.07 .055/.050 Jul-98 $ 50,000.00 $ 50,000.00 $ 41,795.66 $ (8,204.35) $ 141,716.73 .0551.050 Aug-98 $ 70.000.00 $ 70,000.00 $ 41,795.66 $ (28,204.35) $ 113,512.38 .055/.050 Sep-98 $ 70,000.00 $ 70,000.00 $ 42,546.24 $ (27,453.76) $ 86,058.62 .0551.050 Total YTD $ 425,650.33 $ $ 425,650.33 $ 498,096.99 $ 72,446.66 N 1 ITION ADJUSMIENIOJ& Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGfTherm 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 $ 4,048.20 $ 6,242.15 $ 8,045.31 $ (19,057.52) $ 3.997.11 $ (86,235.68) $ (82,238.57)1 .010/.009 .010/.009 Nov- -----4-,-048.n— _ffrivironmtl consulting --Dec -97 9 $ 947.58 $ 10,590.79 $ 9,643.21 $ (72,595.36)1 .010/.009 Jan-98 Feb-98 $ 8,953.83 Appraisals 9K, Prof fees 3K, Adj envir (3K) $ 8,953.83 $ 18,240.50 $ 9.286.67 $ (63,308.69) $ (47,776.34) *015/'014 .015/.014 $ 2,505.24 Prof sery 1.4K, appraisal fees 1.1 K $ 2,505.24 $ 18,037.59 $ 15,532.35 Mar-98 $ 10,000.00 $ 10,000.00 $ 18,264.11 $ 8,264.11 $ (39,512.24) .015/.014 Apr-98-- 10,000.00 $ 10,000.00 $ 19,988.22 $ 9,988.22 $ (29,524.02) .0201.018 May-98 $ 10,000.00 $ 10,000.00 $ 19,093.32 $ 9,093.32 $ (20,430.70) .020/.018 Jun-98 $ 10,000.00 $ 10,000.00 $ 16,158.42 $ 6,158.42 $ (14,272.28) .020/.018 Jul-98 $ 10,000.00 $ 10,000.00 $ 15,198.42 $ 5,198.42 $ (9,073.85) .020/.018 Aug-98 $ 10,000.00 $ 10,000.00 $ 15,198.42 $ 5,198.42 $ (3.875.43) .020/.018 Sep-98 $ 10,000.00 $ 10,000.00 $ 15.471.36 $ 5,471.36 $ 1,595.93 .0201.018 Sep-98 $ - $ - $ - $ 1,595.93 Total YTD 1,754.52 $ $ 111,754.52 $ 180,528.61 $ 68,774.09 ATTACHMENT #1 Page 3 of 3 Page 3 TOTAL ALL COST RECOVERY AD USTMENT GLeUSES (Both PGAs + ECA + E A) Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage All Therm Month Expenses Billed (Shortage) (Shortage) NG/LP Prior Year _ $ - $ - $ - $ (183,034.33) Ad1 $ - $ - $ - Oct -97 - — - -- _ - $ 415,817.82 $ 428,170.51 $ 12,352.69 $ (170,681.64) .455/.546 Nov -97 $ 5,076.27 84 _ $ 553,057.17 $ (31,019.10) $ (201,700.73) .455/.546 Dec -97 $ 577,574.21 $ 685,037.56 $ 107,463.35 $ (94,237.38) .455/.641 Jan -98 $ 837,621.48 $ 845,694.19 $ 8.M-71-$ (86,164.67) .505/.656 Feb-98 $ - $ 66,129.10 $ 66,129.10 $ (20,035.57) .5054656 Mar -98 $ 758,656.55 $ 838,438.39 $ 79,781.84 $ 21377.82 $ 59,746.26 $ 62,124.09 .5054656 r -98 $ 650,780.00 $ 653,157.83 .485/.632 May -98. $ 545,300.00 $ 624,163.95 $ 78,863.95 $ 140,988.04 .485/.632 Jun -98 $ 514,100.00 $ 525,090.08 $ 10,990.07 $ 151,978.11 .485/.632 Jul-98 $ 467,000.00 $ 494,266.08 $ 27,266.07 $ 179,244.19 .485/.632 Aug -98 $ 487,000.00 $ 494,266.08 $ 7,266.07 $ 186,510.26 .485/.632 Sep -98 $ 474,200.00--$ 496,929.60 $ 22,729.60 $ 209,239.86 .485/.632 Total YTD $ 6,312,126.32 _ $ 6,704,400.52 $ 392,274.19 WEATHER NORMALIZATION NA) _ Monthly Cumulative Budget Interest Overage YTD Overage Month LP Gallons Expense Rate /Gallon NG Therms Rate/Therm (Shortage) (Shortage) Beg. Bal. __ $ (206,573.39) Oct -97 _11,577.9 - -- -- - -- _ - -- $ 0.0_46 $0.046 $ - 6.046 613_,591.9_ $_ -- 0.050 $ -0.050 -- $ 31,212.18 $ 40,246.16 $ (175,361.21) $ (135,115.06) - - Nov -97 - Dec -97 - - -- _ -- 16,869.8 _ 789,402.9 23,652.1 1,037,8.58.6 $ - -- —0.050--$-- 52,980.93 $ (82,134.13) Jan -98 $ - $ - $ - - -$ (82,134.13) Jan-98 Transfer to NG PGA & LP PGA 1.0 $ 82,134.130 $ 82,134.13 Feb -98 _ $ _ $ _ 0.00 Mar -98 -- - -- - - - - -- - -- - - $ -$ . --------- 0.00- - - -- - -- Apr-98 _ $ - - -- $ 0.00 May -98 $ - $ - 0.00 Jun -98 $ - $ 0.00 JUI -98 $ - $ 0.00 - Aug -98 - - $ - $ 0.00 Sep -98 Total YTD 52,099.8 $ _ $ 0.00 - 2,440,854.4 $ 206,573.39 1) Amount differs from cost center 2078 on the Stmt of Rev & Exp by the amount in taxes. Page 3 CSW:'03/12/98 ATTACHMENT #2 Page 1 of 2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 04/01/98 - 09/30/98 I. Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible & Contract (Non - Standard) Rate Schedule PGA for the semi - annual period of 03/01/97 - 02/28198 (See attached Page 2) $0.120 Calculation of the Required Natural Gas PGA WACOG for FY 97/98 A. Therm Sales Projection for 10/1/97 - 9/30/98 = 18,450,000 B. Projected NG Reservation Cost 10/1/97 - 9/30/98 = $ 1,530,000 Projected NG Commodity Cost 10/1/97 - 9/30/98 = $ 4,720,000 Budgeted Other Supply Related Expenses = $ 230,000 Total Recovery Needed for FY 97/98 only = $ 6,480,000 Projected Under Recovery of FY 96/97 PGA +WNA $ 221,000 Total Annualized Recovery Needed for FY 97/98 = $ 6,701,000 C. Required Weighted Average Recovery Cost/Therm $ 0.363 55.0% Standard = 10,147,500 Therms @ 45.0% Non - Standard = 8,302,500 Therms @ 100.0% 18,450,000 Therms D. Projected NG PGA Annual Revenue = WACOG $ 0.420 = $ 0.300 = Pinellas NG PGA = Pasco NG PGA = Total NG PGA = III. Required Natural Gas PGA Billing Factors for 4/01/98 - 9/30/98 A. Required Standard Rate PGA Billing Factor for the Year B. Less Winter - Summer Rate Differential C. Required Standard Rate PGA Billing Factor for the Summer Period D. Less Non- Standard Differential for Reservation Cost E. Required Non - Standard PGA Billing Factor for the Winter Period Recovery $ 4,261,950 $ 2,490,750 $ 6,752,700 $ 6,416,742 $ 335,958 $ 6,752,700 $ 0.420 $ (0.010) $ 0.410 $ (0.120) $ 0.290 ulchuck\exceftgasrateMpga1 g978.x1s ATTACHMENT #2 Page 2 of 2 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON - STANDARD THERMS A RESERVATION CHARGES FOR 3/1197 - 2/28/98 Note: ' This figure has been increased by the amount of the FGT rate refund of $93,894.74. # This is a rather large increase in the Reservation Charge per Standard Therm (from it's previously used level of $0.12 /therm) which would establish the Interruptible and Contract Rate PGA Differential. It is recommended that we hold this differential at the current level of $0.120 for this semi - annual cycle to maintain the current PGA rate differentials. Subtotal Subtotal Net Net Charge Per Billing Month Total Therms Interruptible Therms Intemtptible % Contract Thug % Contract Non - Standard Therms % Non- Standard Standard Therms Standard % Reservation Charoes Standard Therm Mar 1997 1,587,359 295,836 18.6% 174,001 11.0% 469,837 29.6% 1,117,522 70.4% $ 200,891.18 $ 0.180 Apr 1997 1,361,196 332,678 24.4% 175,969 12.9% 508,647 37.4% 852,549 62.6% $ 190,663.00 $ 0.224 May 1997 1,495,462 314,275 21.0% 197,967 13.2% 512,242 34.3% 983,220 65.7% $ 71,903.68 $ 0.073 Jun 1997 1,253,453 305,600 24.4% 188,080 15.0% 493,680 39.4% 759,773 60.6% $ 93,366.84 $ 0.123 Jul 1997 1,219,542 292,022 23.9% 192,624 15.8% 484,646 39.7% 734,896 60.3°x6 $ 92,471.18 $ 0.126 Aug 1997 1,170,043 301,238 25.7% 217,883 18.6% 519,121 44.4% 650,922 55.6% $ 89,653.77 $ 0.138 Sep 1997 1,125,419 291,666 25.9% 247,242 22.0% 538,908 47.9% 586,511 52.1% $ 88,759.01 $ 0.151 Oct 1997 1,140,423 293,511 25.7% 233,320 20.5% 526,831 46.2% 613,592 53.8% $ 134,807.13 $ 0.220 Nov 1997 1,429,356 331,888 23.2% 308,065 21.6% 639,953 44.8% 789,403 55.2% $ 159,095.24 $ 0.202 Dec 1997 1,724,913 333,856 19.4% 353,199 20.5% 687,055 39.8% 1,037,858 60.2% $ 163,522.09 $ 0.158 Jan 1998 1,975,616 372,040 18.8% 409,915 20.7% 781,955 39.6°x6 1,193,661 60.4% $ 165,986.87 $ 0.139 Feb 1998 1,967,925 390,274 19.8% 398,250 20.2% 788,524 40.1% 1,179,401 59.9% $ 151,084.32 $ 0.128 Total 3197 -2198 17,450,707 3,854,884 22.1% 3,096,515 17.7% 6,951,399 39.8% 10,499,308 60.2% $ 1,602,204.31 $ 0.153 # For Comparison 8/96-7/97 16,497,793 3,473,830 21.1% 1,723,308 10.4% 5,197,138 31.5% 11,300,655 68.5% $ 1,637,215.65 $ 0.145 Change 952,914 381,054 1.0% 1,373,207 7.3% 1,754,261 8.3% (801,347) -8.3% $ (35,011.34) $ 0.008 Note: ' This figure has been increased by the amount of the FGT rate refund of $93,894.74. # This is a rather large increase in the Reservation Charge per Standard Therm (from it's previously used level of $0.12 /therm) which would establish the Interruptible and Contract Rate PGA Differential. It is recommended that we hold this differential at the current level of $0.120 for this semi - annual cycle to maintain the current PGA rate differentials. 4 T rl)C f *M FAi 'I �*_3 CLEARWATER FY97/98 PURCHASED GAS COST PROJECTIONS AS OF 3112198 Baaa4 on Aotuil DTH', SoM E ulvalnt phe" 11 Ph- R.Oinqul.hd Ph.- 0 .. II__Contract_ Phi- Acnil ict C_v_ Contract C.-ty A,.iib" A-1.,. hWI P.Id-.d Bold -------- -Cap-ity Par Month C-P-kY- C. achy P., Month Par Month Per Month Par Month Doll.. Par Month_ Per Month od.97 ____ .___ 1738 1",122 __AX2,3?fi, 0 13547110 _.._ -111 ,042 0 -NOV-97 306,570 53,430 50.00 ._ 217,064 - ____ 0 - _-!S_ 22 '500 159,656 -iiii3o. Dec -97 116 789 , 9,211 (52,622.22) !99'509 0 31,000 196,540 172,491 - - - 4952 198 316,789 S5,211 ($1,354_57) 174,438 0 46,500 195,293 197462 4111 Feb-98 286,132 49,668 (511,1157.13) 139,207 0 42,000 187,265 1%,793 -3068 M-98 316,769 55,211 (51,170.00) 173,000 0 31,000 0 199,000 -3151 Apr-98 306,570 53,430 ($1,17000) 197,000 o 22,500 0 163,000 -3151 Ma -98 144,212 41,788 (51,170.00) 30,000 0 12,400 0 156,000 -3151 Jun-98 139,560 40,440 (51,170.00) 48,000 0 10,500 0 132,000 -3151 Jul-98 144,212 41,788 ($1,17000) 62,000 0 10,8501 0 124,000 .3151 -AU081 144,212 41,788 ($1,17000) 62,000 0 10,8501 0 124,000 -3151 Se 98 139,560 4_0 440 ($1,17000) 54,000 0- 12,000 0 126,00 , 0 -3151 _ --847 824 579,393 ($13,323.94) Iola -1- 2,793 7_71 1,516,340 0 _26,666 874530 Pnf4!qtxFTninsp._ PnsJ- NNTS at" 11 Vokinvin; Pw Month L VJAC0Q sow - P_ March P=__ Pro _Iocbd --%d rwot!�Qnt P- Month - Fu.W C-t C. F" Par Mo,�- WACO* Prha-d -PW,60 - I Fckw t - -- Sold Oas *64 Madan Fitat w Phavat Itl V.1urnin; Phase IN Vokovins; Par Month "Iswents A� -- Per Month TOhI V.Ilu..n, Per Month Par P. Month Ott -97 1 $t01,153.27 $3,750.40 $3,434.93 $34,086.47 $962.02 3323,262.00 $39,S42.03 $10,233.110 ___ - $2,372.S$ - -- _ $3.84 $4.57 41.605 SS241,81Y." N--97 097 &512.38 SIL _ $119,492.81 $2,767." 1.10 $43,552.95 $2,0%.27 $376,073.39 s0aeo $11,895.87 - - - $3.50 _ _-IM - _91 39.79% Usk%IL" $45,035.6 - I $460,436.97 A 0211JO)_ 411112.1111 _12,797.48 $3,439.45 $2.88 9329 - 47.25% S%7,013-" F 9 S118�369.53 $106,771.94 $5,015.38 - $5,948.92 _$2,013.02 $2 ,06.66 $ts,035AI ...... S4_0_,6:F7._33 $1,556.85 _____$L4_93.64 -$496,167.22 5944.18 $17,717." $7,417.63 $7.98 Wits 53.21% $?K904.n $6,022.86 $12,662.81 $3,443.87 $3.62 $3.44 59.1 t% $677,11".54 Mar-98 $118,322.81 $5,794.70 829.00 $45,035.61 $1,297.46 $454,671.26 $0.00 $14,470.44 $3,482.50 $324 53.955 $644,106.23 Apir-98 $114,468.20 _551,226.77 _$4 415.67 $1327_50 $43,582.85 $1,255.61 $368,521.76 $0790 $11284.61 $2,852.50 $3.37 45.66% $549,446.18 MY -98 $460_ 2.74 $731.60 $34,086.47 2-02 196_ $346024.80 __ 554.36 S2,730.0D S2.90 6S.32% $45 7.S4 J98 $3,689.87 $6fi.50 $32,986.91 $950.34 $290,083.15 $0.00 $8.895.99 ':3,6026 $2.97 5392-I"fis JUl4V5T2Z6.77 $3,35.14 $640.15 $34,086.47 $982.02 $270.939.91 $0.00 $0,072.02 17 $3.02 _74.64% 67,82% 3374,515-59 $53,226.77 _ $3,313.14 $640.15 $34,086.47 $982.02 $270,939.91 $0.00 $8,263.96 $2,170.00 $3.02 67.82% $374,733.31 Se 98 - -------- j51,472.03 53,448.07 $708.00 $32,986.91 $950.34 $275,939.91 $0.00 $T224.01 $2,205.00 9248 71.25% 5375,905.36 31,056,71S.11 $50,470.93 ___$19,058.76 $465,269.56 $15,553.54 4 501 37 .27 ($37,519.23) $1355,758.84 $33391.01 $1.477 Average 58.94% $6,244,798.76 Volumes are based on approved gas tariff rates. hssforicalexpectecl lher. FGT Trans rtafio and fuel rates are I based on actual ____ - Total Reservation T.WC-modily Total Projecied i Com DTH WACOG __ .- These numbers mlreseni abed look f.-.Id based on current da IM 6 M.nfl�, ------- -- 2n d 6 Wmh, TOTAL (A) Adjustments for December 16-Ei7�ii;Uud-es- the --F-G-T- refund -of overpayment -ofrat-esdu-e-t-o- the -rate- settlement -g--3-.8" S94_1l(i4.05 $586,555.55 12,784,S43.01, �3,725,707.14 52519,09162 1,022,824 825,000 - 13.643 _53.053 51,527,719.59 -4,71 -7,07 9.17 --i-6 - 44,798.76 72 - 1,847,824 7 -------- A77-,Q,C0MC4V i A-¢- IPWPAME AND WEIGHTED COST OF GAB &A PREPARED TERRY NEINAN DATE 1 03H1198 1 - -- LP su hd Parnu as ,Date ConbaU End. 8/30197 841 -1416 Ask for M&rV Vletor C08TOF INVENTORY TANK GALLONS DELIVERED DELIVERED TOTAL NEW DATE WITHDRAW INVENT. WACOG INVENT DELIVERED PRICE INVOICE GALLONS WACOG 9130/97 27,893 18 905.0 0.500441 $8,459.94 E $ 16,905 $ 050044 - - __ 1014197 26,201 $0.51299 S13,440.74 9,298 S 0.53560 S 4,980.80 26,201 $0.51299 - - - -- 1018197 35,564 $0.51899 $18,457.43 9.383 S 0.53580 E 5,016.70 35,584 S051899 - - -- 1018197 44,951 $0.52250 $23,486.99 9.387 E 0.53580 $ 5029.55 4'951 $052250 _ 10/10197 54,233 $0.52478 $28,460.28 9,282 $ 0.53580 S 4,973.30 54,233 $052478 10/31197 36 54,269 $0.52443 $28,460.28 - S 54,233 $052443 _ 10131197 28,8401 25,429 :0.62443 $13,335.73 - S 54,233 5052443 11112197 34,797 $0.52211 $18,167.74 9,368 $ 0.51580 S 4,832.01 83,601 $0.52211 11H2/97 43,797 $0.53447 523,408.17 9,000 $ 0.58227 S 5,240.43 72,601 $053447 - - - -- - 11112/97 53,169 $0.53118 $28,242.25 9,372 $ 0.51580 $ 4,834.08 81,973 50.53116 11130197 515 53,684 50.52608 $28,242.25 61,973 $0 52608 11/30197 27,904 25,780 $0.52608 $13,562.34 81,973 $0.52608 -- 12/10197 34,981 $0.51890 $18,151.53 9,201 $ 0.4988 S 4,589.18 91,174 $051890 12/15/97 4'281 $0.53221 $23,566.64 9,300 S 0.58227 $ 5.415.11 100,474 $0.53221 - - - -- 12116/97 53,581 50.54090 $28,981.75 9,300 $ 0.58227 $ 5,415.11 109,774 $054090 12/28/97 82,944 $0.53188 533,478.80 9,363 $ 0.48030 S 4,497.05 119,137 $0.53188 12/28197 72,283 $0.52522 537,964.32 9,339 $ 0.48030 S 4,485.52 128,476 $0 52522 _ 12/31/97 280 72,563 $0.52319 $37,964.32 E S 128,476 50.52319 12131/97 43,779 28,764 $0.52319 $15,059.53 $ - $ - 128,476 50.52319 01109198 38,133 50.50667 $19,320.81 9,349 $ 0.45580 $ 4,261.27 137,825 $050667 0111VINI 47,133 $0.53851 $25,287.54 9,000 $ 0.58227 $ 5,966.73 146,825 $0.53651 01/16198 56,296 $0.52207 $29,390.73 9,163 1 0.44760 S 4,103.19 155,988 $0.52207 01/22/98 65,412 $0.52297 534,208.42 9,116 $ 0.44780 $ 4,817.69 165,104 $0.52297 _ 01131198 3117.9 68,530 50.50192 $34,396.36 165,104 $0.50192 01131198 44348.9 24,181 $0.50192 $12,136.87 165,104 $050192 02103198 33,481 $0.52424 $17,551.98 9,300 $ 0.58227 $ 5,415.11 174,404 $0.52424 02108198 42,482 $0.53653 $22,792.99 9,001 $ 0.58227 $ 5,241.01 183,405 $0.53653 02127198 51,668 $0.51880 $26,805.44 9.186 $ 0.43680 $ 4,012.44 192,591 $0 -51880 02128198 1,168 52,836 $0.50733 $26,805.44 192,591 $0.50733 36628 02128/98 38,872 13,964 $0.50733 $7,084.36 192,591 $050733 03103198 23,103 $0.47943 $11,076.27 9,139 $ 0.43680 $ 3,991.92 201,730 $0 -47943 03106198 32,361 $0.46723 $15,120.17 9,258 $ 0.43680 $ 4,043.89 210,988 $0 -46723 Total Gallons Max Inv. GaL Total Gallons Withdrawn 216,754 72,593 Delivered 194,083 1 $ 101,162.10 CSW:03/23/98 CLEARWATER GAS SYSTEM ATTACHMENT M NATURAL GAS RATE BILLING FACTORS FOR APRIL 1, 1998 - SEPTEMBER 30, 1998 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural a Rat Schedules Intern. Contract - � �� J_MF SGS JNGS J-GS JRAC GAC J AC SL w/M& NGV NSS NG Re Imo NG Rate _ Applicable Annual Therm Range NA (1 - NA (4 + NA (4 + NA (4 + 0- 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA light NA NA 100,000 NA or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up Monthly Customer Charge $7.00 $15.00 $20.00 $50.00 $15.00 $20.00 $50.00 $7.00 if $15.00 if $15.00 if $15.00 $15.00 $7 Rest./ $25.00 $100.00 By Non Energy not prev. not prev. not prev. $15 GS if Contract -Fuel Charge/Therm billed billed billed not prev. Non -Fuel Energy Charge $0.580 $0.580 $0.580 $0.580 $0.470 $0.410 $0.350 $0.200 $0.150 $0.100 $0.200 $0.300 billed $0.100 $0.470 $0.280 By Energy Conservation Adj. (ECA) 0.055 0.055 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 Contract NA Environmental Imposition Adj. (EIA) 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 0.020 NA NA Weather Normalization Adj. (WNA) 0.000 0.000 0.000 1000 0.000 0. 000 0.000 0.000 Q,= 0.000 0.000 Q= 0.000 0.000 _ A �8 Total Non -Fuel Energy Charge $0.655 $0.655 $0.655 $0.655 $0.545 $0.485 $0.425 $0.275 $0.225 $0.175 $0.275 $0.375 $0.175 $0.545 $0.280 By Purchased Gas Adjustment (PGA) 0,9,]Q Q-AJ2 Q.4111 0.410 0. 410 0. 410 0. 410 0. 410 0. 410 QAM 0.410 0.410 0.410 0 -410 Q yyQ Contract 02M Total Energy Charge/Therm $1.065 $1.065 $1.065 $1.065 $0.955 $0.895 $0.835 $0.685 $0.635 $0.585 $0.685 $0.785 $0.585 $0.955 $0.570 $0.290 Minimum Monthly Bill $7.00 $15.00 $20.00 $50.00 $15.00 $20.00 $50.00 $7.00 @ $15.00 @ $15.00 (8 $15.00 $15.00 $7 Resl./ $25.00 $100.00 + Non -Fuel Customer premise premise premise + FAC + FAC $15 GS @ + FAC + Non -Fuel Charge + premise Therm Rate for Non -Fuel Thern + FAC 250 therms X Rate for Contract 8 Days in Mo. 9 of Therms Compares to LP /Gallon Rate of $ 0.974 $ 0.974 $ 0.974 $ 0.974 $ 0.874 $ 0.819 $ 0.764 $ 0.627 $ 0.581 $ 0.535 $ 0.627 $ 0.718 $ 0.535 $ 0.874 $ 0.522 with 6.0% Franchise $ 1.033 $ 1.033 $ 1.033 $ 1.033 $ 0.926 $ 0.868 $ 0.810 $ 0.664 $ 0.616 $ 0.567 $ 0.664 $ 0.761 $ 0.567 $ 0.926 $ 0.553 1is, Change from 9/97 Therm Rate Utility Tax Note, $ 0.040 $ 0.040 $ 0.040 $ 0.040 $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.005) $ (0.005) Fuel Rate per Therm 10101f73 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.055 $0.069 Non - Utility Taxable Fuelfrherm $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.341 $0.235 $0.221 BTU FACTOR = THERMS /100 CURIC FEET (C 10/97 11/97 12/97 Qim 02/98 um 04/98 um 06/98 QZLH Mu 22M Firm Service Rates 1.073 1.074 1.075 1.079 1.071 1.069 1.071 Interruptible - ervice Rates 1.052 1.053 1.054 1.058 1.050 1.048 1.050 i . CSW:03/23/98 CLEARWATER GAS SYSTEM BTU Factor: 2214 Gallons /100 cubic feet (CCF) PROPANE (LP) RATE BILLING FACTORS BTU Factor: 2.483 Therms /100 cubic feet (CCF) FOR APRIL 1, 1998 - SEPTEMBER 30, 1998 BASED ON APPROVED GAS ADJUSTMENT FACTORS Therm Factor: 0.915 Therms /Gallon RLP MLP GLP LLP LPV LIDS Contract LP Svc. CLP Appl. Annual Gallon (Therm) Range NA NA 0 - 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) �t Monthly Customer Charge $7.00 $15.00 $15.00 $20.00 $7.00 Resl. or $25.00 Set By Contrad $15.00 GS if not Non -Fuel Energy Charge: prev. billed @ premise Non -Fuel Energy Charge /Gallon $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 $0.426 By Contr. Energy Conservation Adj. /Gallon 0.050 0.050 0.050 0.050 0.050 0.050 NA (ECA) /Therm 0.055 0.055 0.055 0.055 0.055 0.055 NA Environm'I Imposition Adj. /Gallon 0.018 0.018 0.018 0.018 0.018 0.018 NA (E IA) [Therm 0.020 0.020 0.020 0.020 0.020 0.020 NA Weather Normalization Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 N (WNA) /Therm 0.000 0.000 0.000 0.000 0.000 0.000 _NA Total Non -Fuel Charge /Gallon $0.818 $0.818 $0.458 $0.388 $0.168 $0.458 By Contract /Therm $0.895 $0.895 $0.501 $0.425 $0.184 $0.501 By Cntr. Purchased Gas Adjustment/Gallon 0.510 0.510 0.510 0.510 0.510 0.510 0.510 (PGA) /Therm 0.557 0.557 0.557 0.557 0.557 0.557 0.557 Total Energy Charges /Gallon $1.328 $1.328 $0.968 $0.898 $0.678 $0.968 $0.510 /Therm $1.452 $1.452 $1.058 $0.982 $0.741 $1.058 + NF $0.557 + 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/97 /Gallon Rate $ 0.044 $ 0.044 $ (0.006) $ (0.006) $ (0.006) $ (0.006) $ - /Therm Rate $ 0.050 $ 0.050 $ (0.005) $ (0.005) $ (0.005) $ (0.005) $ - Note: Utiliy Tax is billed on total LP bill.