Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 1997
I I CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: Michael J. Roberto, City Manager ; FROM: Chuck Warrington, Gas System Managing Director COPIES: Kathy Rice, Deputy City Manager; Cyndie Goudeau, City Clerk; Margie Simmons, Finance Director; John Scott, Asst. Director Finance/UCS; Tom Madley, Senior Accountant/UCS; Karen Miles, Accounting Manager; CGS Management Team SUBJECT: GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 1997 DATE: September 19, 1997 This is the time of year that we adjust all of our billing adjustment clauses to reflect the FY 97/98 budget and our best forecast of the cost of purchased gas, both natural and propane (LP). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after October 1, 1997: Natural Gas Firm Standard Rate Schedule PGA ....... $0.415 per therm (no change) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.295 per therm (no change) Propane (LP) Gas Rate Schedule PGA .................... $0.510 per gallon (no change) = $0.557 per therm equivalent (no change) Energy Conservation Adjustment (ECA) ............... $0.030 per therm (up 1.5(:) = $0.027 per gallon of LP (up 1.3(:) Environmental Imposition Adjustment (EIA) ......... $0.010 per therm (down 0.5(:) = $0.009 per gallon of LP (down 0.5(:) Weather Normalization Adjustment (WNA) .......... $0.050 per therm (no change) = $0.046 per gallon of LP (no change) /J.j_/ 1i~.1 "(:';~ 0(, / (/kl ,- ,. .~ ;:fl' l II Michael J Roberto, City Mlnager Page 2 I September 19, 1997 Attachment #1 shows our current projections of the effect of these adjustment levels thru FY 96/97 fiscal year end. Attachment #2 shows our computation of the Natural Gas PGA for FY 97/98 and the differential applicable to contract and interruptible rates. Attachment #3 shows our computation of the ECA and EIA rates for FY 97/98. Attachment #4 shows our current projections of natural gas supply costs for FY 97/98, and Attachment #5 shows our FY 96/97 fiscal year-to-date history of propane (LP) gas supply costs. Finally, Attachments #6 and #7 show the impact of these adjustment clause changes on our overall Natural Gas and LP rates, respectively. You will note that the composite effect of these changes results in an overall increase of 1 e:: per therm in our standard natural gas rates and 0.8e:: per gallon in our propane (LP) rates. It is our plan to use the above proposed adjustments for billings through December 31, 1997, when our WNA is scheduled to end, 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 October 1 st billings. If you have any questions on this, please call me. CSW /cw Attachments Approved: ~ Michael J. Roberto, City Manager chuck:u:\windows\msoffice\winword\gasrates\gasadj 10.97 CSW:09I17197 I I 1 I I ~~ 'OJ I CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS I I I I I NATURAL GAS PURCHASED GAS ADJUSTMENT IPGA-NGl Monthly Cummulatlve NG PGA Budget Reservation Commodity Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelThenn Month Charges ChalV" Expenses Expenses Billed (ShortaGe) (Shortage) Flrm/Conlr Prior Year - $ - $ - $ (172,741.06) Oct-96 $ 124,594.00 $ 233,422.38 $10,369.95 $ 368,386.33 $ 384,494.18 $ 16,107.83 $ (156,633.23) .3801.261 Nov-96 $ 170,385.78 $ 290,744.88 16,079.30 $ 477,209.96 $ 443,000.55 $ (34,209.41) $ (190,842.64) .3901.277 Dec-96 $ 179,288.40 $ 457,290.06 8,285.59 $ 644,864.05 $ 532,745.16 $ (112,118.89) $ (302,961.53) .3901.277 Jan-97 $ 179,551.86 $ 727,198.21 4,853.98 $ 911,604.05 $ 920,292.04 $ 8,687.99 $ (294,273.54) .530/.417 Feb-97 $ 162,141.51 $ 628,500.10 30,720.03 $ 821,361.64 $ 790,952.42 $ (30,409.22) $ (324,682.76) .500/.387 Mar-97 $ 200,891.18 $ 506,093.25 7,613.03 $ 714,597.46 $ 690,199.59 $ (24,397.87) $ (349,080.63) .480/.367 Apr-97 $ 190,663.00 $ 388,090.11 7,529.20 $ 586,282.31 $ 510,896.02 $ (75,386.29) $ (424,466.92) .430/.310 May-97 $ 71,903.68 $ 323,805.53 15,782.31 $ 411,491.52 $ 537,774.11 $ 126,282.59 $ (298,184.33) .405/.285 Jun-97 $ 93,366.84 $ 286,291.47 20,009.23 $ 399,667.54 $ 453,761.75 $ 54,094.21 $ (244,090.12) .415/.295 Jul-97 $ 92,471.18 $ 284,402.43 34,102.09 $ 410,975.70 $ 431,221.06 $ 20,245.36 $ (223,844.76) .415/.295 Aug-97 $ 89,653.77 $ 257,678.88 12,322.87 $ 359,655.52 $ 416,635.48 $ 56,979.96 $ (166,864.80) .415/.295 ~ S 92 000 00 S 260 000 00 1500000 S 367 000 00 S 423 300 00 S 56 300 00 $ (110564 SO) .4151.295 Total YTD $1,646,911.20 $ 4,643,517.30 182,667.58 $ 6,473,096.08 $ 6,535,272.34 $ 62,176.26 PROPANE ILPl GAS PURCHASED GAS ADJUSTMENT IPGA-LPl Monthly Cummulatlve LP PGA Budget Gallons Monthly Commodity Total LP Fuel Total LP PGA Overage YTD Overage Therm/GaL Month Sold WACOG Charges Expenses Billed (Shortage) (Shortage) Prior Year $ - $ - $ - $ - $ 2,006.34 Adj 5,877.00 $ 0.55237 $ 3,246.28 $ 3,246.28 $ (3,246.28) $ (1,239.93) Od-96 17,476.~ $ 0.54895 $ 9,593.78 $ 9,593.78 $ 9,274.51 $ (319.27) $ (1,559.20) .579/.530 Nov-96 21,163.00 $ 0.58190 $ 12,314.75 $ 12,314.75 $ 11,644.94 $ (669.81) $ (1,909.74) .601/.550 Deo-96 27,404.20 $ 0.63562 $ 17,418.66 $ 17,418.66 $ 17,166.20 $ (252.46) $ (2,162.20) .689/.630 Jan-97 40,363.30 $ 0.76304 $ 30,798.81 $ 30,798.81 $ 32,680.85 $ 1,882.04 $ (280.16) .929/.850 Feb-97 24,124.30 $ 0.72293 $ 17,440.18 $ 17,440.18 $ 17,091.64 $ (348.54) $ (628.70) .831/.760 Mar-97 31,395.60 $ 0.62888 $ 19,744.06 $ 19,744.06 $ 22,724.32 $ 2,980.26 $ 2,351.55 .7981.730 Apr-97 25,067.70 $ 0.58694 $ 14,713.24 $ 14,713.24 $ 14,965.18 $ 251.94 $ 2,603.49 .656/.600 May-97 29,827.80 $ 0.53397 $ 15,927.15 $ 15,927.15 $ 17,486.75 $ 1,559.60 $ 4,163.09 .634/.580 Jun-97 20,336.30 $ 0.51706 $ 10,515.09 $ 10,515.09 $ 11,351.97 $ 836.88 $ 4,999.98 .612/.560 Jul-97 17,568.40 $ 0.50164 $ 8,813.01 $ 8,813.01 $ 9,800.96 $ 987.95 $ 5,987.92 .612/.560 Aug-97 18,524.80 $ 0.50002 $ 9,262.77 $ 9,262.77 $ 9,409.88 $ 147.11 $ 6,135.03 .557/.510 ~ 19.000.00 $ o 50000 S 9 500 00 S 9 500 00 S 9,593 10 $ 9310 S 6 228 13 .557/.510 Total YTD 292,252.00 $ 0.60236 $ 176,041.50 $ 176,041.50 $ 183,190.30 $ 7,148.80 E~ERGY CONSERVATION ADJUSTMENT IECAl Monthly Cummulatlve ECA Budget Cost Center Total ECA Total ECA Overage YTD OYerage NGlTherm Month Expenses NoteslExceptlonalltems Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ (77,801.10) Oct-96 $ 32,700.60 ParHomesAdv 2K, Incentives 22K $ 32,700.60 $ 31,561.27 $ (1,139.33) $ (78,940.43) .040/.037 Nov-96 $ 21,839.00 Promotion 17K $ 21,839.00 $ 35,099.12 $ 13,260.12 $ (65,680.31) .040/.037 Deo-96 $ 17,412.40 Advertising 4.3K, Promotion 11.4 $ 17,412.40 $ 44,334.95 $ 26,922.55 $ (38,757.76) .040/.037 Jan-97 $ 18,350.00 Advertising 6.31<, Promotion 10K $ 18,350.00 $ 57,220.68 $ 38,870.68 $ 112.92 .040/.037 Feb-97 $ 21,600.53 Promotion 15.81< $ 21,600.53 $ 49,787.09 $ 28,186.56 $ 28,299.48 .040/.037 Mar-97 $ 12,125.00 $ 12,125.00 $ 45,466.54 $ 33,341.54 $ 61,641.02 .040/.037 Apr-97 $ 12,425.00 Advertising 3K, Promotion 9.5K $ 12,425.00 $ 25,738.09 $ 13,313.09 $ 74,954.11 .030/.027 May-97 $ 26,472.60 Promotion 22K $ 26,472.60 $ 19,974.94 $ (6,497.66) $ 68,456.45 .020/.018 Jun-97 $ 18,221.40 Promotion 16.5K $ 18,221.40 $ 11,588.24 $ (6,633.16) $ 61,823.29 .015/.014 Jul-97 $ 22,839.13 $ 22,839.13 $ 11,183.45 $ (11,655.68) $ 50,167.61 .0151.014 Aug-97 $ 12,311.49 $ 12,311.49 $ 9,917.34 $ (2,394.15) $ 47,773.46 .015/.014 ~ S 20 000 00 S 20 000 00 L-1004343 S 19 956.57) S 37816 S9 .0151.014 Total YTD $ 236,297.15 $ 236,297.15 $ 351,915.14 $ 115,617.99 .. Page 1 chuck:u:lexceJ/gasratesh'ecovery .xis I I 1 ~. ''J ~ I I I .. I Monthly Cummulatlv. EIA BUdaet Cost Center Total EIA Total EIA Overage YTD Overa. NGlTherm Month Expen... 0MI1te.... Expen... BIIIec:I (Shortage) (ShortIIge) LP/Gal. Prior Year $ - $ . $ - $ (98,133.59) Qct-96 $ - $ . $ 7,887.65 $ 7,887.65 $ (90,245.94) .0101.009 Nov-96 $ 31,785.68 Legal 9.7K, Env clean up 22K $ 31,785.68 $ 8,771.39 S (23.014.29) S (113,260.23) .0101.009 Dec-96 $ 29,035.90 Env cnsIt 8K,leaaI2.7K,appralsaI1 $ 29,035.90 $ 11,079.32 $ (17,956.58) $ (131,216.81) .0101.009 Jan-97 $ 9,552.92 Leaal fees 9.51< $ 9,552.92 $ 14,299.14 $ 4,746.22 S (126,470.59) .0101.009 Feb-97 $ 1,290.75 $ 1,290.75 $ 18,672.71 $ 17,381.96 $ (109,088.63) .0151.014 Mar-97 $ 5,737.99 $ 5,737.99 $ 17,052.55 $ 11,314.56 $ (97,774.07) .0151.014 Apr-97 $ 396.37 $ 396.37 $ 13,025.56 $ 12,629.19 $ (85,144.88) .0151.014 May-97 $ 2,361.32 $ 2,361.32 $ 14,989.65 $ 12,628.33 $ (72,516.55) .0151.014 Jun-97 $ 1,479.22 $ 1,479.22 $ 11,588.24 $ 10,109.02 $ (62,407.53) .0151.014 Jul-97 $ 2,269.12 $ 2,269.12 $ 11,183.45 $ 8,914.33 $ (53,493.20) .0151.014 Aug-97 $ 4,821.13 Envir. Consultant 4K $ 4,821.13 $ 9,917.34 $ 5,096.21 $ (48,396.99) .0151.014 Smc9Z S '0.000 on S 20 000 00 $ 10,04343 S (9 956 57) $ (58 353 56) .015/.014 Total YTD $ 108,730.40 $ 108,730.40 $ 148,510.43 $ 39,780.03 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cummulatlye Total Budget Total All Total Recoyery Overage YTD Overage All Therm Month Expenses Billed (Shortage) (Shortage) NGlLP Prior Year $ - $ - $ - $ (346,669.41) Adj $ 3,246.28 $ - $ (3,246.28) $ (349,915.69) Qct-96 $ 410,680.71 $ 423,943.08 $ 13,262.37 $ (336,653.32) .4301.629 Nov-96 $ 543,149.39 $ 498,516.00 $ (44,633.39) $ (381,286.71) .440/.651 Dec-96 $ 708,731.01 $ 605,325.63 $ (103,405.38) $ (484,692.08) .4401.739 Jan-97 $ 970,305.78 $ 1,024,492.71 $ 54,186.93 $ (430,505.15) .580/.979 Feb-97 $ 861,693.10 $ 876,503.86 $ 14,810.76 $ (415,694.39) .5551.886 Mar-97 $ 752,204.51 $ 775,443.00 $ 23,238.49 $ (392,455.91) 0.5151.853 Apr-97 $ 613,816.92 $ 564,624.85 $ (49,192.07) $ (441,647.98) .4751.701 May-97 $ 456,252.59 $ 590,225.45 $ 133,972.86 $ (307,675.12) .4401.669 Jun-97 $ 429,883.25 $ 488,290.20 $ 58,406.95 $ (249,268.16) .445/.642 Jul-97 $ 444,896.96 $ 463,388.92 $ 18,491.96 $ (230,776.21) .445/.642 Aug-97 $ 386,050.91 $ 445,880.04 $ 59,829.13 $ (170,947.08) .445/.642 Smc9Z $ 416500 on S 452 979 95 S 36 479 95 S (134 467 12) .445/.642 Total YTD $ 6,994,165.13 $ 7,209,613.69 $ 215,448.56 WEATHER NORMALIZATION lWNA) Monthly Cumulative WNA Budget Overage YTD Overage NGlTherm Month LP Gallons Rate/Gallon NGlTherms ThermlRate (Shortage) (Shortage) LP/Gal. Beg. Bal. $ (369,000.00) May-97 16,854.9 $ 0.032 983,220.1 $ 0.035 $ 34,952.06 $ (334,047.94) .035/.032 Jun-97 13,689.7 $ 0.032 759,773.1 $ 0.035 $ 27,030.13 $ (307,017.81) .035/.032 Jul-97 12,476.9 $ 0.046 734,895.5 $ 0.050 $ 37,318.71 $ (269,699.10) .050/.046 Aua-97 11,704.6 $ 0.046 650,923.1 $ 0.050 $ 33,084.57 $ (236,614.53) .0501.046 Sep-97 11,970.0 $ 0.046 660,000.0 $ 0.050 $ 33,550.62 S (203,063.91) .0501.046 Qct-97 12,400.0 S 0.046 687,500.0 $ 0.050 $ 34,945.40 $ (168,118.51) .0501.046 Nov-97 14,640.0 S 0.046 770,000.0 $ 0.050 $ 39,173.44 S (128,945.07) .0501.046 Dec-97 20 400 0 S 0.046 940 500 0 $ 0.050 $ 47,963.40 $ (80,981.67) .0501.046 TotalYTD 114,136.1 6,186,811.8 $ 288,018.33 Page 2 chuck:u:JexceVgasraleslrecovery .xis '. CSW:09119/97 I I ATTACHMENT 62 Page 1 of 2 PURCHASED GAS ADJUSTMENT (PGA) CALCULA nONS FOR THE RIllING PERIOD OF 010/01/97.03/31/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 10/1/96 - 3131/97 (See attached Page 2) $0.120 II. Calculation of the Required Natural Gas PGA WACOG for FY 97/98 A. Therm Sales Projection for 10/1/97 - 9/30/98 = 18,500,000 B. Projected NG Reservation Cost 10/1/97 - 9/30/98 = $ Projected NG Commodity Cost 10/1/97 - 9/30/98 = $ Budgeted Other Supply Related Expenses = $ Total Recoyery Needed for FY 97/98 only = $ Projected Under Recovery from FY 97/98 = $ Total Annualized Recovery Needed for FY 97/98 = $ 1,514,000 4,626,000 200.000 6,340,000 111.000 6.451,000 C. Required Weighted Average Recovery CostlTherm = $ 0.349 55.0% Standard = ~ Non-Standard = 100.0% 10,175,000 Therms @ 8.325.000 Therms @ 18,500,000 Therms $ $ WACOG 0.405 0.285 Recoverv $ 4,120,875 $ 2.372.625 $ 6.493,500 $ 5,883,270 $ 610.230 $ 6.493,500 D. Projected NG PGA Annual Revenue = Pinellas NG PGA = Pasco NG PGA = Total NG PGA = III. Required Natural Gas PGA Billing Factors for 9/01/97 - 3/31/98 A. Required Standard Rate PGA Billing Factor for the Year $ 0.405 B. Plus Winter - Summer Rate Differential $ 0.010 C. Required Standard Rate PGA Billing Factor for the Winter Period $ 0.415 C. Less Non-Standard Differential for Reservation Cost $ (0.1201 D. Required Non-Standard PGA Billing Factor for the Winter Period $ 0.295 u:/chucklexcel\g8ar0t8S\pgal q97S.x18 ." ATTACHMENT '2 Page 2 of 2 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON-STANDARD THERMS Ir. RESERVATION CHARGES FOR 8/1196 - 7/31/97 ..... Subtotal Subtotal Net Net ChlIrge Per BRIng Total Interruptible % Contract % Non-$tanderd % Non- Stllnderd % ReMMItIon Standerd MaDib Ibtona IbIIma InterruDtlble IbmnI CmJIw:l IbmDI &IIndard IbIIma i1IlUWd CbImu IbIml Aug 1996 1,007.425 251,751 25.0% 48,053 4.8% 299,804 29.8% 707,621 70.2% $ 89,087.22 $ 0.126 Sap 1996 1,081,440 252,134 23.3% 55.485 5.1% 307,619 28.4% 773,821 71.6% $ 82,871.00 $ 0.107 Oct 1996 1,110,957 246,103 22.2% 84,875 7.6% 330,978 29.8% 719,979 70.2% $ 124,694.00 $ 0.160 Noy 1996 1,258,163 271,301 22.0% 115,853 9.2% 393,154 31.2% 865,009 68.8% $ 170,385.78 $ 0.197 Dec 1996 1.491,781 267.437 17.9% 132,341 8.9% 399,778 26.8% 1,092,003 73.2% $ 179,288.40 $ 0.184 Jan 1997 1.889.188 293,955 15.6% 186,930 9.9% 480,885 25.6% 1.408.303 74.5% $ 179,551.86 $ 0.127 Feb 1997 1,741.827 344,738 19.8% 171,130 9.8% 516,868 29.6% 1,226.969 70.4% $ 162,141.61 $ 0.132 Mer 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% 18B,080 15.0% 493.680 39.4% 759,773 60.6% $ 93,366.84 $ 0.123 Jul1997 1,219,542 292,022 23.9% 192,624 15.8% 484,646 39.7% 734,896 60.3% $ 92,471.18 $ 0.126 Total 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.146 # For -- Comoarison 8/95 - 7/96 17,297,368 3,256,682 18.8% 915,013 5.3% 4,171,695 24.1% 13,125,673 75.9% $ 1,570,748.67 $ 0.120 Change 1799,5751 217,148 2.2% 808,295 5.2% 1,025,443 7.4% (1,825,0181 -7.4% $ 66,469.08 . 0.025 Note: # This rather large increase in the Reservation Charge per Standard Therm which establishes the Interruptible and Contract Rate PGA Differential is primarily impacted by the warm weather last winter. It is recommended that we hold this differential at the current leyel of $0.120 for this semi-annual cycle. I I CSW:09/19/97 ATTACHMENT #3 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSmON ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/97 . 03/31/98 I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 97/98 Budgeted ECA Requirements for FY 97/98 only = Projected (Over) Under Recovery of ECA from FY 96/97 = Total Annualized ECA Recovery Needed during FY 97/98 = $ 535,000.00 (38,000 00) $ 497,000.00 Projected Therm Sales for FY97/98 Applicable to ECA Recovery = (Natural Gas@ 55% Standard = 10,175,000 and LP @ 55% Standard = 190,000 or 10.365.000 Total Applicable Therms) 10,365,000 Computed ECA Recovery Factor Necessary = $ 0.0479 Round Proposed ECA Recovery Rate to $ 0.050 # Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 518,250.00 Note: # Due to the application of WNA during October 1. 1997 - December 31, 1997, we recommend a ECA of $0.030 for this period and $0.060 for the remainder of the semi-annual period. We project that this will keep us whole during the first quarter. II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 97/98 Budgeted EIA Requirements for FY 97/98 only = Projected (Over) Under Recovery of EIA from FY 96.197 = Total Annualized EIA Recovery Needed during FY 97/98 = $ 150,000.00 58,000 00 $ 208,000.00 Projected Therm Sales for FY 97/98 Applicable to EIA = 10,365,000 Times 2 Years Recovery Period x2 Projected Therms for Recovery Timetable = 20,730,000 Computed EIA Recovery Factor Necessary for FY 97/98 = $ 0.01003 Round Proposed EIA Recovery Rate to $ 0.010 Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 103,650.00 u:/chuck\excel\gasrates\eca1 h978.xls A rO~CHmf.Nr .4- . . A . E , . , . L . I CLEARWATER FY97198 PURCHASED GAS COST PROJECTlONS AS OF 1/16197 2 BuM on~ DTlh SaId 2 E_nt 0 _n _In R.llnqu....... _I _II Conlnct Acluol - I ConlrKl Contncl Caoocllv A.....blo A_ NNTI PurcMood IolcI . ~ c:.oocllv Por_ Copaclly c:ap.cIly Por Month Por_ . Por Month Per Month Dol.... Por Month Por_ I . Oct-9. 232 376 41788 ($ 1 170.00) 149'64 0 15500 0 125 000 " N0Y-97 306 570 53 030 ($] 240.00) 220 000 0 22 500 0 140 000 " Dee-97 316789 55211 lS3 240.00) 201 000 0 31000 0 .71 000 .. ....,. 316789 55211 ($3 240.001 \77 000 0 46 SOO 0 195 000 II ,- 286 132 49 ". ($] 240.00) 141000 0 02000 0 195 000 10 Mof-98 316789 55211 lS3 240.00) 173 000 0 31000 0 199 000 II Apr-98 306 570 53 00 ($3 240.00) 197 000 0 22 SOO 0 163000 II Moy-98 141 212 41788 ($3 240.00) 30 000 0 12400 0 156 000 L-. 11 1- 139 560 40 4fO ($1170.00) .. 000 0 10500 0 132 000 II lul-98 141 212 41788 lSl 170.00) 62 000 0 \0850 0 120 000 .. Auo-98 141 212 41 788 lSI170.oo) 62 000 0 10850 0 ,.. 000 . --- 139 560 40 4fO lSll70.00) 54 000 0 12 000 0 126 000 J1 J2 JJ TOl.1 2 793 771 570 393 1$28.530.00) 15141M 0 267 600 0 1 850 000 .. 2f - _11 ProjecIH NNTI - __ T....... - - - - .. -- _ny_ _IIY_ - _IIY_ ~Coot IIOAF 0.- Fuol Coot - WACOG ~ ,... . _nyoI_ Por_ Por Month P_IIY- Por_ Por_ Por Month ...- ...- F_ -. 2f Por_ Por_ .. I.. Oct-97 99 983.27 2 .18 I 288.05 lot 0116.47 97.28 275 74'.42 .00 8 167.60 187'" 3.39 46.12"10 .....33'.17 .. N0Y-97 130 209.92 ....56 1 1169.75 3582.85 n.82 lOB 070.26 .00 10 826.40 450.00 3.57 39.as... -.129.56 .. Dee.97 I lot 658.25 323.14 2576.10 5 035.61 657.01 379 083.28 .00 12699.29 2992.... 3.40 47.07'10 _UIH." .. _98 110.]52.08 1.16'.02 2 743.50 566.32 795.04 72 230.61 .00 10049.35 3412.50 .39 53.68'10 10.81 .. feb.98 102 972.20 528.12 2 478.00 253.05 718.10 S4f 964.03 0.00 Il 9OS.lot 3412.50 3.66 59.S8'1o ~ .. MI..98 110352.08 486.22 1 829.00 566.32 795.04 _.521.55 .00 10891.47 3 "2.50 3.'6 54.78"1. 924.17 17 ""-98 110558.78 3418.58 1 327.50 3128.70 769.39 35'-'75.14 .00 11771.88 2.<2.50 3.22 46.40'10 25 .48 I.. -"8 50 29U9 3 563." 731.60 33 731.27 601.75 331 198.23 0.00 11095.10 2 730.00 2.78 88.00'10 "'ll 942.90 .. ....98 50 6lot.67 2.856.67 619.50 32 643.17 582.lot 280 785.19 .00 9 772.20 2 310.00 2.88 74.64... ""._.78 .. ul-98 52361.49 2565.0' 640.15 33731.27 601.75 264 476.70 .00 8 868.00 2170.00 2.95 67.82'10 UIoS.414.ll1 01 .....,. 52361.49 2565.01 fooIll.15 33731.27 601.75 264 476.70 .00 8859.97 2 170.00 2.95 67.82'10 UIoS.406.lS .. ....98 50 6lot.67 2 669.47 708.00 32 643.17 582.lot 268 192.22 .00 7 9lB.'ll 2 205.00 2.90 71.25" .10 .. .. I.. 11 063 370.40 U9 .81 117 051.30 ..". 699.87 17837.'9 115. <'>'00 <1l2 ....61 tn '7' M ".271 59.75" I .. 1.-- '" .. Note: .. II Volumes Oil! baed on hl.lOriGlI UJIlN! ond ..- _he.. FCT ...........tion ond fuel rot.. Oil! baed on actual ToIIl Pro.ected DTH WACOG .. I4riff..... ToI4l_on ToI4l Commodilv COlt U These numbers reoresenl a best look forward based on current dI... hi 6 Months $944 033.21 52 760 131.02 53 704, '64.23 1 02S 000 $1614 .. .. 2nd 6 Monlhs $569 958.16 $1 865 785.32 52 035.743.68 82S 000 N.!I5Z II If TOTAL $1 513991.57 $0625916.lot $6 139907.91 1.850.000 Po3" .. S:\sUDDMniltDra 9I.xh II It _ANI INVSITDRY AND ED eDIT Of ClAIIlWACDGI I PRfPAREO BY TERRY NEENAN I DATEI 09104/97 . I LP ..-... hv forr- &44-1416 Atk for ...... D... Conlroct Ends 9/30/97 - . INVDITDRY TANIl CDIT Of GALLONS DELIVERED DELIVERED TOTAL NEW DATE WITHDRAW IIIVENT. WACDG INVENT DEUVERED PRICE INVOICE GAU.ONS WACDG 8/30/98 20 897 43 867 to.64896 ....076.30 $ t .3 667 $ 0.114896 10/29/98 63 126 $0.67104 t30.338.78 9286 $ 0.67580 $ 6.261." 63 126 to.67104 10/30/96 (9911 62134 $0.66190 $30.336.76 $ $ 63 126 to.66190 111\/98 29.216 22.916 90.118190 tI3.336.86 t t 63.126 $0.58190 1111/98 32 224 $0.80896 tI9.623.12 9306 $ 0.87580 t 6267.13 62431 $0.80886 1111/98 41682 $0.82396 $26.948.38 9368 t 0.81680 t 6 322.26 71799 $0.62396 11/2198 60 826 $0.63343 t32 268.19 834. t 0.87680 t 6 312.81 II 133 $0.63343 11130/98 (1761 60761 $0.63662 t32 266.19 $ $ 81133 $0.63662 11/30/98 38.609 14.242 90.831162 ".062.60 $ t 61,133 to.63662 12/02198 23 443 to.68467 $16 060.78 9.201 t 0.78060 t 6.998.26 90334 $0.68467 12/03/98 32 836 to.71411 "3.317.98 9192 $ 0.79080 t 7.267.20 99 626 to.71451 12108/98 41.903 80.73887 t30.878.96 9.266 t 0.8166 t 7.668.96 108,794 to.73887 12/23/98 11.019 80.74994 t38.261.31 9.116 t 0.8166 t 7.394.43 117.910 to.74994 12/23/96 80.211 90.76920 t46.712.43 9.192 t 0.8168 t 7,461.04 127.102 $0.75920 12/30/98 (1761 80 036 to.76304 t46 806.96 t t 127102 to.78304 12131/98 42.118 17,917 90.78304 t13.871.39 t t 127.102 to.78304 . 01102117 27.047 80.76222 UO.616.87 9.130 t 0.78080 t 6.944.28 138.232 to.78222 Dl108It7 38.363 80.76412 U7.414.83 9.306 t 0.73080 t 6.798.98 146.638 to.75412 011\9197 46,840 80.74678 t34.037.19 9.287 t 0.71310 t 6.622.68 1114.826 to.74678 01/21197 54.062 80.73801 t39.790.28 8.422 t 0.68310 t 6.763.07 183,247 to.73801 01/22/97 83.483 80.72817 t".212.08 9.401 t 0.88310 t 8.421.82 172,846 to.72817 01/22197 72.941 80.72248 $62.461.67 9.178 t 0.88310 t 8.269.49 181,828 to.72248 01/31/97 (461 72 696 40.72293 $62.481.57 t t 181826 to.72293 01/31/87 42722 28.874 90.72293 "'.696.8' $ $ 181.828 to.72293 02114197 39.071 80.88238 "6.860.86 9.197 t 0.66080 t 6.063.87 191.023 to.86238 02118/97 48.198 90.86742 t31.894.90 9.126 t 0.66080 t 6.024.23 200.148 to.86742 02/19/97 67.321 80.84041 t38.709.13 9,126 $ 0.66080 t 5.024.23 208.273 to.84041 02119197 86.632 90.82798 t41.780.71 9.211 t 0.66080 t 6.071.68 218.484 to.82798 02/28197 1951 68.437 90.82888 t41.780.71 218.484 to.82888 . 02/29/97 34.422 32.016 90.82888 "0.133.69 $ t 218.484 to.82888 03/11/97 41.273 90.81132 "5.231.0& 9.268 $ 0.65080 t 6.097.45 227.7'2 to.81132 03/11/97 60.... 90.80018 t30.338.78 9.273 t 0.65080 t 6.106.71 237.016 to.80018 03113/97 89.833 90.69249 t36.460.18 9.287 t 0.66080 $ 6.113.42 248.302 to.69249 03118197 89,063 90.118889 t40.628.72 9.220 t 0.66080 $ 6.078.63 265.622 to.68688 03131/97 (61 89.048 80.68694 t40.626.72 266.622 to.68694 03131/97 36.1189 32.379 90.lIa694 $19.004.38 t t 266.622 to.68694 04117197 41732 40.67039 U3 803.41 9.363 t 0.61310 t 4,799.02 284 876 to.67039 04118/97 61128 to.66710 "8.463.66 9.396 $ 0.'9810 t 4.680.16 274 271 to.66710 04123/97 80700 to.54780 t33.261.37 9.672 t 0.49810 t 4.767.61 283 843 to.54780 04129/97 70001 to.5412O t37.884.19 9.301 $ 0.49810 t 4.632.83 293 144 to.6412O 04130/97 947 70 948 to.63397 t37.884.19 29 144 to.63397 04130/97 32.922 38.028 90.113397 "0.304.74 283.144 to.63397 06129/97 47341 to.62891 t24.944.54 9.316 t 0.49810 t 4.639.80 302.469 to.62681 06128197 66.742 to.62214 t29.627.16 9.401 t 0.49810 t 4.982.84 311.860 to.62214 05130/87 66 962 to.61878 t34.219.88 9.220 t 0.49810 $ 4.692.46 321 080 to.61876 0&130/97 74812 40.61633 $38 627.86 6860 $ 0.'9810 t 4408.19 329 930 $0.61833 06130/87 -108 74 708 to.61708 t38.627.86 329 930 to.61706 06130/97 30321 44,386 80.&1708 U2.949.71 329.930 to.I1 708 6130/97 63 044 40.61146 t32.243.76 16.669 t 0.49610 t 9.294.04 348 669 40.61146 8/30197 894 83 938 to.60184 t32.073.96 348.669 40.60184 8/30197 30.489 33.449 80.60184 $18.779.38 348.668 $0.60184 7/31/97 -12 33.437 to. 601 62 tI6,779.36 346.689 to.60182 7112197 61,901 to.60060 "6 976.28 18.'84 t 0.'9810 $ 9.196.92 367.063 to.6oo60 7/31/87 19720 32.181 90.60050 $16.106.48 367.063 to.60060 8/1/97 41691 to..9996 t20.793.80 9.410 $ 0.49810 . 4.887.12 376.483 to.49996 8/31/97 80 274 to..9938 $30.099.61 18.883 t 0.49810 t 9.306.00 395 146 $0.'9938 8/31/97 177.8) 80 196.4 to.6ooo2 $30.099.61 395 146 $0.60002 8/31187 2'.814.4 36.382.0 9D.60DD2 117.881.83 386.148 10.60002 Totat Galton, M.. low. 001. Total G.IIoM Withdr.wn 38 4 Oellvered 381 289 21 917. /4 TT AC1+I'\ €1J r #I ~ - --- :.. CSW:09/19/97 Applicable AnnuBI Therm Renge or Other Rate DatermlnBnt Monthly CUltom., ChBrge Nan-Fual EftA,av C~tMlThenn Non-Fuel Energy ChBrge Energy ConBervBtlon Adj. CECAl Envlronmentellmposltlon Adj. (EIAI WeBther NormallzBtlon Adj. IWNA) Total Non-Fual Energy Charge PUrChaBed Gaa AdJuBtmBnt IPGAI Total Energy, ChergefTllerm Minimum Monthly 611I Compar.. to LP/OeRon Rate of wtth 8.0% FrBnchlBe Change from 9/97 Therm Rate UtUttv TAX Not.. Fuel RBte per Therm 1010 1/73 Non-Utility TBxBble FuelfTllerm CLEARWATER GAS SYSTEM NATURAL GAS RATE.BILLlNG FACTORS FOR OCTOBER I, 1997 - DECEMBER 31,1997 BASED ON APPROVED GAS ADJUSTMENT FACTORS --BL ...I.ll4L ....IIlIMf.... ..J.I'4L NA(1- NA(4+ NAI4+ NAI4+ 3 Unital Unital UnltBl Unital '0.1180 '0.870 '7.00 $16.00 '0.680 0.030 0.010 Il,gIg '0.870 lM1i '1.086 '1.0811 $1.00 '111.00 120.00 40.660 0.030 0.010 g.om .0.870 lM1i $60.00 40.680 0.030 0.030 0.010 0.010 Rrm Natural aM R.t. Sehedulu ....ISiL. ....IMlL ..JJIL ....IWL ...aM&.. 416.00 0- 18,000- 100,000 NA (1 - NA (0 - NA 1160 17,999 99,999 I< up 3 Unital 149 tonll tonB I< +1 ....LAI:O.... .0.470 .O.HO lI.ll5. .0.976 416.00 120.00 $0.410 0.030 0.030 Il,gIg Il,gIg $0.870 lM1i lM1i 0.010 0.010 ".0811 .1.086 $20.00 '60.00 Il,gIg Il,gIg .0.1100 lM1i '0.916 420.00 0.8113 . 0.893 . 0.993 . 0.993 . 0.892 . 0.837 1.0112 . 1.D62 . 1.062 . 1.0112 . D.946 . D.887 . 0.080 . 0.080 . 0.080 . 0.080 . 0.010 . D.010 .0.089 $0.069 40.069 40.069 40.346 $0.346 40.346 40.346 BTU FACTOR - THERMS/l00 CUBIC FEET rCCFI Firm Service RateB IntBrruptlble Service RBtBS 1.073 1.062 .1DLI2 llL1Z .1.2lJ1 SlUU 40.069 $0.346 40.069 $0.346 ~ .ll3Ln $60.00 .0.360 .0.440 .0.81111 .60.00 $1.00 If not ptev. billed .0.200 0.030 0.030 416.00 If not pt8\!. billed .0.1 60 Il,gIg .0.240 lM1i .0.81111 416.00 If not pt8\!. billed 40.100 0.030 0.030 416.00 .0.200 .0.290 .0.705 415.00 + FAC -A.. NA SL w/MI< IIIlIab1 NA Int_. fIIfl.JlIlI ..1dL --..lL- NA NA 100.000 I< up 0.010 0.010 .0.069 .0.346 Q.5LU 0.010 0.010 0.010 . 0.010 . 0.010 . 0.010 . 0.010 ..&llL 126.00 $100.00 " ATTACHMENT' I ConIr_ fIIfl.JlIlI -<:JIlL. NA - Q.gG g.om Il,gIg .0.190 lM1i .0.7011 47.00 0 4111.00 0 '16.00 0 premiae premlBe premise 40.8011 416.00 $1 Real.1 $111 GS If not pt8\!. billed 40.300 40.100 0.030 0.030 0.030 40.470 40.280 .0.290 lM1i lM1i '0.069 40.346 WlLlIll lUlU 40.069 $0.346 0.010 0.010 0.010 0.030 NA By ~t IIy ConIrKt NA NA ---11I6 IIy ContrKt lUlli 40.291 + ........... eu._ CMrll8 + Non-FueI Therm Ratto for Contr8Ct , of Therms - . to.069 to.228 Il,gIg Il,gIg Q.gG 0.010 NA 40.390 .0.190 lI.ll5. lI.ll5. lM1i QJlIg ---11I6 40.805 .0.805 415.00 $1 Real.! +FAC 416GS@ premlae + FAC .0.11IO .0.280 lM1i lUlli 40.9711 .0.11711 125.00 4100.00 + FAC + Non-Fuel Therm Ratto for 2110 therme X . DBYB In Mo. 0.782 . 0.1411 . D.811 . D.II114 . D.146 e 0.737 . 0.8114 . D.B92 . D.UI 0.829 . D.184 4 0.8311 . 0.687 4 0.684 . 0.781 . 0.687 . 0.946 . 0.6118 '0.069 $0.346 .0.069 $0.346 ~ 0.010 . 0.010 . 0.010 . 40.069 .0.069 40.346 $0.346 QILSll lltwI 40.089 .0.056 $0.346 40.240 ,- . . CSW:09/19/97 ATTACHMENT .7 CLEARWATER GAS SYSTEM BTU FactDr: 2.11! Gallons/1 00 cubic faet ICCF) PROPANE (LP) RATE BILLING FACTORS BTU FactDr: 2A8.a Therms/1 00 cubic feet ICCF) FOR OCTOBER 1, 1997 - DECEMBER 31,1997 BASED ON APPROVED GAS AOJUSTMENT FACTORS Therm Factor: U1R Therm8/GallDn Contract LP lve. RLP MlP GlP UP lPV lPS ClP - Appl. Annu81 Gallon ITherml Range NA NA o - 2.499 GallDns 2,600 Gallons & Up NA NA NA Dr Other Rate Determinant 11 - 3 Units) 14 + Units) 10-2.287 Therms) 12.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 Chame: prev. billed @ premise Non-Fuel Energy Charge IGallon $0.750 $0.760 $0.390 $0.320 $0.100 $0.390 By Contract /Therm $0.820 $0.820 $0.428 $0.350 $0.109 $0.426 By Contr. Energy Conservation Adj. /Gallon 0.027 0.027 0.027 0.027 0.027 0.027 NA (ECA) /Therm 0.030 0.030 0.030 0.030 0.030 0.030 NA Environm'l Imposition Adj. /GallDn 0.009 0.009 0.009 0.009 0.009 0.009 NA (EIA) /Therm 0.010 0.Q10 0.010 0.Q10 0.Q10 0.010 NA Weather NormaJizatiDn Adj./GallDn Q..Q!6 Q..Q!6 Q..Q!6 Q..Q!6 Q..Q!6 ~ ~ (WNA) /Therm Q.Q5Q Q.Q5Q Q.Q5Q Q.Q5Q Q.Q5Q Q.Q5Q ~ Total NDn-Fuel Charge/Gallon $0.832 $0.832 $0.472 $0.402 $0.182 $0.472 By Contract IThenn $0.910 $0.910 $0.516 $0.440 $0.199 80.516 By Cntr. Purchased Gas Adjustment/Gallon ~ ~ ~ ~ Q.ilQ Q.ilQ Q.ilQ - IPGA) /Therm Q.5.51 Q.5.51 Q.5.51 Q.5.51 Q.5.51 Q.5.51 Q.5.51 Total Energy Charges /GalIDn 81.342 $1.342 $0.982 $0.912 $0.692 $0.982 80.510 lThenn $1.467 $1.467 $1.073 $0.997 $0.756 $1.073 + NF 80.557 +NF Minimum Monthly Bill $7.00 $15.00 $15.00 $20.00 Any Applicable $25.00 Customer Cherve + Customer Charge Non-Fual Energy Chg. + Any Applicable fDr the Contracted Facility Charges . of GaIIonaIMo. Change from 9/97 IGllllon Rate $ 0.058 . 0.058 $ 0.008 $ 0.008 $ 0.008 $ 0.008 . /Thenn Rate $ 0.065 $ 0.065 $ 0.010 $ 0.010 $ 0.010 $ 0.010 . Note: Utiliy Tax is billed on total LP bill.