Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MAY 1, 1997
I I (9) CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: Betty Deptula, 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 MAY 1, 1997 DATE: April 21, 1997 After experiencing the highest run -up this winter in gas supply pricing since the supply shortages of the 1970s, we are continuing to see relief for the forth month in our pricing forecast models for both natural and propane (LP) gas. This means that we can again lower our Purchased Gas Adjustment (PGA) gas supply prices for our customers. Attachment #1 shows our current projections of the effect of lowering our Natural Gas PGA factors by another 2.50 per therm (after lowering it by 100 per therm over the past 3 months) which would equate to another 5.8% PGA decrease for our firm natural gas customers. Attachment #1 also shows our current projections of the effect of lowering our Propane (LP) Gas PGA by another 20 per gallon (after lowering it by 250 per gallon over the past 3 months) which would equate to another 3.3% PGA decrease for our LP customers. These rates are still nearly 10% higher than historical levels which we hope to return to within the next year. We do not propose to make any changes in our Environmental Imposition Adjustment (EIA) clause rate at this time as our costs are running reasonably in line with our earlier projections. We are recommending another 10 per therm decrease in our Energy Conservation Adjustment (ECA) clause rate (after reducing this by 10 per therm last month) as we are continuing to run positive on this recovery. 1 Betty Deptula, City Manager Page 2 April 21, 1997 The above all results in a decrease this month of 3.50 in Natural Gas rates per therm and a decrease of 30 per gallon for Propane (LP). As I warned you over the past several months, the winter this year was very mild which resulted in poorer than projected Non -Fuel Energy Revenues and earnings. Therefore, I am asking for your approval to implement a Weather Normalization Adjustment (WNA) of +3.50 per therm for Natural Gas and +3.20 per gallon for Propane (LP) based on our projection that our Heating Degree Days will fall 160 or 31.9% short of our 10 year average of 501. This has cost us a projected shortfall in Non -Fuel Energy (NFE) revenues of $275,000. We are requesting your approval to spread this recovery over the next eight (8) months (thru December 31, 1997), which we project will allow us to recover this shortfall at the 3.50 per therm level. If we were to attempt to recover it all by the end of the current fiscal year, we would require a WNA rate of 5.90 per therm. Adoption of the 3.50 per therm WNA strategy will allow us to implement it this month with no net increase in our Natural Gas billing rates due to a corresponding 3.50 total reduction in PGA and ECA. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after May 1, 1997: Natural Gas Firm Standard Rate Schedule PGA ....... $0.405 per therm (down 2.50) Natural Gas Interruptible and Contract (Non- Standard) Rate Schedule PGA ............. $0.285 per therm (down 2.50) Propane (LP) Gas Rate Schedule PGA .................... $0.580 per gallon (down 20) _ $0.634 per therm equivalent (down 2.20) Energy Conservation Adjustment (ECA) ............... $0.020 per therm (down 10) = $0.018 per gallon of LP Environmental Imposition Adjustment (EIA) ......... $0.015 per therm (no change) = $0.014 per gallon of LP Weather Normalization Adjustment (WNA) .......... $0.035 per therm (up 3.50) = $0.32 per gallon of LP Attachment #2 shows our Natural Gas PGA budget. Attachment #3 shows the history of Propane (LP) prices for the fiscal year. Attachment #4 shows our calculation of the Weather Normalization Adjustment. Finally, Attachments #5 and #6 show the impact of these adjustment clause changes on our overall natural gas and LP rates, respectively. Betty Deptula, City Manager Page 3 April 21, 1997 It is our plan to use the above proposed adjustments for billings through September 30, 1997, land WNA through December 31, 1997) 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. We will also continue to provide you with a summary of our adjustment status as a part of our monthly financial statements. Betty, I would appreciate your approval of these revised PGA 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 May 1st billings. If you have any questions on this, please call me. CSW /cw Attachments Approved: m- :: Be4teptda, City Manager CSW:04/21/97 III I I ATTACHMENT #1. Page 1 of 2 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE OLLECTIONT NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NG) Monthly Cummulative NG PGA Budget Reservation Commodity Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm Month Charges Charges Expenses Expenses Billed (Shortage) (Shortage) Firm/Contr Prior Year - $ - $ - $ (172,741.06) Oct -96 $ 124,594.00 $ 233,422.38 $10,369.95 $ 368,386.33 $ 384,494.16 $ 16,107.83 $ (156,633.23) .380/.267 Nov -96 $ 170,385.78 $ 290,744.88 16,079.30 $ 477,209.96 $ 443,000.55 $ (34,209.41) $ (190,842.64) .390/.277 Dec -96 $ 179,288.40 $ 457,290.06 8,285.59 $ 644,864.05 $ 532,745.16 $(112,118.89) $ (302,961.53) .390/.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 $ 196,000.00 $ 400,000.00 10,000.00 $ 606,000.00 $ 582,435.00 $ (23,565.00) $ (372,645.63) .430/.310 May -97 $ 97,000.00 $ 330,000.00 10,000.00 $ 437,000.00 $ 513,945.00 $ 76,945.00 $ (295,700.63) .405/.285 Jun -97 $ 94,000.00 $ 300,000.00 10,000.00 $ 404,000.00 $ 486,607.50 $ 82,607.50 $ (213,093.13)1 .405/.285 Jul-97 $ 97,000.00 $ 270,000.00 10,000.00 $ 377,000.00 $ 462,915.00 $ 85,915.00 $ (127,178.13)1 .405/.285 Aug -97 $ 97,000.00 $ 270,000.00 10,000.00 $ 377,000.00 $ 461,092.50 $ 84,092.50 $ (43,085.63), Sep-97 594.000.00 X270.000.00 10.000.00 1 374,000.00 $ 470,205.00 1-96.205.00 $ 53.119.37 .405/.285 Total YTD $1,691,852.73 $ 4,683,248.88 137,921.88 $6,513,023.49 $ 6,738,883.92 $ 225,860.43 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LP) Monthly Cummulative 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) Oct -96 17,476.60 $ 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 Dec -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 .798/.730 Apr -97 31,000.00 $ 0.58694 $ 18,195.14 $ 18,195.14 $ 17,670.00 $ (525.14) $ 1,826.41 .656/.600 May -97 31,000.00 $ 0.56000 $ 17,360.00 $ 17,360.00 $ 17,081.00 $ (279.00) $ 1,547.41 .634/.580 Jun -97 31,000.00 $ 0.55000 $ 17,050.00 $ 17,050.00 $ 17,081.00 $ 31.00 $ 1,578.41 .634/.580 Jul -97 31,000.00 $ 0.54000 $ 16,740.00 $ 16,740.00 $ 17,081.00 $ 341.00 $ 1,919.41 .634/.580 Aug -97 31,000.00 $ 0.54000 $ 16,740.00 $ 16,740.00 $ 17,081.00 $ 341.00 $ 2,260.41 .634/.580 Sep-97 _33.000.00 $ 0.54000 1-17.820.00 $- 17.820.00 $ 18.183.00 x_363.00 $ 2.623.41 .634/.580 Total YTD 349,927.00 $ 0.60360 $ 211,215.38 $ 211,215.38 $ 214,759.46 $ 3,544.08 ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cummulative ECA Budget Cost Center I Total ECA Total ECA Overage YTD Overage NG/Therm Month Expenses Notes/ExceptionalItems Expenses Billed (Shortage) (Shortage) LP /Gal. Prior Year $ - $ - $ (77,801.10) Oct -96 $ 32,700.60 ParHomesAdv 2K, Incentives 22 $ 32,700.60 $ 31,561.27 $ (1,139.33) $ (78,940.43) 1 .040/.037 Nov -96 $ 21,839.00 Promotion 17K 1 $ 21,839.00 $ 35,099.12 $ 13,260.12 $ (65,680.31): .040/.037 Dec -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.3K, Promotion 10K $ 18,350.00 $ 57,220.68 $ 38,870.68 $ 112.92 .040/.037 Feb-97 $ 21,600.53 Promotion 15.8K $ 21,600.53 $ 49,787.09 $ 28,186.56 $ 28,299.48 j .0401.037 Mar -97 $ 12,125.00 $ 12,125.00 $ 45,466.54 $ 33,341.54 $ 61,641.02 .040/.037 Apr -97 $ 21,000.00 $ 21,000.00 $ 32,200.67 $ 11,200.67 $ 72,841.69 ! .030/.027 May -97 $ 21,000.00 $ 21,000.00 $ 20,137.11 $ (862.89) $ 71,978.80 ; .020/.018 Jun -97 $ 21,000.00 $ 21,000.00 $ 19,087.11 $ (1,912.89) $ 70,065.91 .020/.018 Jul-97 $ 21,000.00 $ 21,000.00 $ 18,177.11 $ (2,822.89) $ 67,243.02 .020/.018 Aug -97 $ 21,000.00 $ 21,000.00 $ 18,107.11 $ (2,892.89) $ 64,350.131 .020/.018 Sep-97 1 21,000.00 1-- 21.QQQM $ 18.482.73 $ (.52 17.27) j__§1 832.86 .020/.018 Total YTD $ 250,027.53 $ 250,027.53 $ 389,661.49 $ 139,633.96 I Page 1 chuck:ujexceVgasrateshewvery.xls Page 2 chuck :u: /exceVgaarateslrecovery.xls ENVIRONMENTAL IMPOSITION ADJUSTMENT Monthly Cummulative EIA Budget Cost Center I Total: EIA Total EIA Overage YTD Overage NG/Therm Month Expenses Notes /Exceptional items Expenses Billed (Shortage) (Shortage) LP /Gal. Prior Year $ - $ - $ - $ (98,133.59) Oct-96 $ - $ - $ 7,887.65 $ 7,887.65 $ (90,245.94) .010/.009 Nov -96 $ 31,785.68 Legal 9.7K, Env clean up 22K $ 31,785.68 $ 8,771.39 $ (23,014.29) $ (113,260.23) 010/.009 Dec -96 $ 29,035.90 Env cnslt8K,legal2.7K,appraisal $ 29,035.90 $ 11,079.32 $ (17,956.58) $ (131,216.81) .010/.009 Jan -97 $ 9,552.92 Legal fees 9.51K $ 9,552.92 $ 14,299.14 $ 4,746.22 $ (126,470.59) .010/.009 Feb-97 $ 1,290.75 $ 1,290.75 $ 18,672.71 $ 17,381.96 $ (109,088.63) .015/.014 Mar -97 $ 5,737.99 $ 5,737.99 $ 17,052.55 $ 11,314.56 $ (97,774.07) .015/.014 Apr -97 $ 7,500.00 $ 7,500.00 $ 16,100.33 $ 8,600.33 $ (89,173.74) .015/.014 May -97 $ 7,500.00 $ 7,500.00 $ 15,102.83 $ 7,602.83 $ (81,570.91) .015/.014 Jun-97 $ 7,500.00 $ 7,500.00 $ 14,315.33 $ 6,815.33 $ (74,755.57) .015/.014 Jul -97 $ 7,500.00 $ 7,500.00 $ 13,632.83 $ 6,132.83 $ (68,622.74) .015/.014 Aug -97 $ 7,500.00 $ 7,500.00 $ 13,580.33 $ 6,080.33 $ (62,542.41) .015/.014 Sep-97 $ 7,500.00 $— 7.500.00 $ 13,862.05 1-6.362.05 1— (56.180.36) .015/.014 Total YTD $ 122,403.24 $ 122,403.24 $ 164,356.47 $ 41,953.23 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cummulative Total Budget Total All Total Recovery Overage YTD Overage All Therm Month Expenses Billed (Shortage) (Shortage) NG /LP Prior Year $ - $ - $ - $ (346,669.41) Adj $ 3,246.28 $ - $ (3,246.28) $ (349,915.69) Oct -96 $ 410,680.71 $ 423,943.08 $ 13,262.37 $ (336,653.32) .430/.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) .440/.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) .555/.886 Mar -97 $ 752,204.51 $ 775,443.00 $ 23,238.49 $ (392,455.91) 0.515/.853 Apr -97 $ 652,695.14 $ 648,406.00 $ (4,289.14) $ (396,745.05) .475/.701 May -97 $ 482,860.00 $ 566,265.94 $ 83,405.94 $ (313,339.11) .440/.669 Jun-97 $ 449,550.00 $ 537,090.94 $ 87,540.94 $ (225,798.17) .440/.669 Jul-97 $ 422,240.00 $ 511,805.94 $ 89,565.94 $ (136,232.22) .440/.669 Aug-97 $ 422,240.00 $ 509,860.94 $ 87,620.94 $ (48,611.28) .440/.669 Se"7 S420,320,00 $ 520.732.78 2-100.412.78 $ 51,801.50 .440/.669 Total YTD $ 7,096,669.64 $ 7,498,386.83 $ 401,717.18 Page 2 chuck :u: /exceVgaarateslrecovery.xls Now CLEARWATER FY96197 PURCHASED GAS COST PROJECTIONS AS OF 4/21197 BmW w AoLI DTMr Sold Equivalent Phased Phase 111 Relinquished Plop II Plisse III Contract Actual Projected Contract Contract Capacity Available Available NNTS Purchased Sold Capacity Capacity Per Month Capacity Capacity Per Month Per Month Per Month Per Month Dollars Per Month Per Month Oct-" 232,378 41,788 D& U-8-0611 147,909 0 15,500 Nov-96 306,570 $3,430 1 212,262 0 22,500 Hum 6 Dec-96 316,789 55,211 18368 222,822 0 31,000 lam Jan-97 318,789 55,211 183,061 0 46,500 Feb-97 286,132 49,888 147,001 0 42,000 15Z.1" 174,163 Mar-97 316,769 55,211 51,300.00 197,817 0 31,000 14ult Apr-97 306 570 53 430 ($1,300.001 201,264 0 22,500 145,000 May- 144,212 41 788 ($1,300.00) 41,000 0 12.400 135 ODO Jun-97 135 580 40 440 ($1,300.00) 45,000 0 10,500 127,000 Jul-97 144,212 41,78a ($1,300,00) 59.000 0 10.&W 120 000 Aug47 144,212 41,708 ($1,300.00) 66,000 0 10,1150 119,000 sop-97 139,560 40,440 51 300.00 61 ODO 0 12,000 121,0D0 Total 2,793,T71 570 393 ($23,105.82) 1,51M.236 0 267.6W 942 688 1.674,789 Projected Projected Tramp. Projected NNTS Projected ProJected Transit. Projected Projected P Reservation Phase 11 Volumes Phase 11 Volumes I Resembm Phase M Volume Commodl Cost MGAF Dues Fuel Cost Adder WACOO Load Total Phase 9 Volumes Per Month Per Month Phase M Volumes Per Month Per Month Per Month Per Month Par Month Factor son Per Month - Per Month Oct-" 19 2,513.41 �{'.u2.eD 76 S s / 7 .e 5782.5]8.16 Nov-941 128 013.00 6 036 08 48 0 91 770 956.7] 29547 4 74.95% $560.078.48 Dee-96 1] 618 8194.49 1 11 6 7 8 10.10% X112.95 Jan-97 817 6509 IL R3_35 85 1111 58 03.34 733.7 6 9 .7 $873,825.671 Feb-97 1 1 454 8 0 89] 7 56.04 S"7.306.1 14,565. 7 88 116. 7 46 Mar-97 IIELLTL46 0 7 0 7 116.48 9 8 46.6 0611 -97 $150,480.85 S5,833.01 S43.582.115 $835.82 $271,310.75 $4,350.00 $19,001.95 $2,537.50 $3.45 44.09% $499,002.48 May-97 $61,412.21 $2,675.18 $34,08647 $497.28 5271854.23 $4,050.00 314 891.85 $2,352.50 52.93 77.98% $395,690.16 Jun-97 $59.387.20 $2184.27 $32,986.91 s4B1.21 $282,343.53 S3,1110.00 $14,569.36 $2,222.50 $2.99 75.00% $379,157.56 Ju�97 $62,775.48 S2,244.68 $34 088.47 $497.28 $248,584.86 $3,600.00 $12,749.09 $2,100.00 63.06 68.28% 3387 539.50 Ault-97 $62,775.48 $2,215.98 MSOB72.55 534 086.47 6497.28 S247,043.37 $3.570.00 $12,732,77 $2,08150 53.07 64.52% 6365 90549 sep-97 $60,750.47 $2,441.22 $32,986.91 6481.21 $251,729.43 $3 630.00 57 2411.87 $2 117.50 92.99 611,11 % VW 362 84 $1,221,707.49 380 073.64 $449,M.11 $13,642.04 $4,245,822.42 $43 153.15 $260,294.41 S32,763.79 $3.619 56.61 % $6,351,068 96 Average Note: VaWmes are based on historical usage and expected weather. FGT tram tlon and fuel rates are based on actual Total Projected OTH WACOG approved gas twiffrates. I I Total Reservation Total Cost These numbers represent a best look forward based on current data. 1 st 6 Months $1,000,432.60 $2,980,378.23 $3,980,810.83 907,789 6 4.385 2nd 6 Months 5668 170.99 S7 702 107.04 $2,370,278.03 767.000 3 3.090 TOTAL $1,668,W3.59 $4,6112,485.27 $6,351,088.86 1,674,789 $ 3.792 Now IL PROPANE INVENTORY AND WEIGHTED COST OF GAS ( WACOG) PREPARED BY TERRY NEENAN DATE 04/21197 LP supplied by Ferre4gas 5441416 Ask for Mary Date Contract Ends 9/30197 Victor - INVENTORY TANK COST OF GALLONS DELIVERED DELIVERED TOTAL NEW DATE WITHDRAW INVENT.1 WACOG INVENT DELIVERED PRICE INVOICE GALLONSI WACOG 9/30/96 20,897 43,857 $ 0.54895 4 24,075.30 ! s 43,857 ! 0.54895 10129196 53,125 $ 0.57104 s 30,336.76 9,268 41 0.67560 111 6,261.46 53,125 $0.57104 10/30/96 (991) 52,134 $ 0.58190 5 30,336.76 ! $ 53,125 $0.58190 11/1/96 29,216 22,916 $ 0.58190 $ 13,335.98 $ - $ - 53,125 $0.58190 11/1/96 32,224 s 0.60896 $ 19,623.12 9,306 $ 0.67560 11 6,287.13 62,431 $0.60896 11/1/96 41,582 1, 0.62396 1, 25,945.38 9,358 $ 0.67560 $ 6,322.26 71,789 $0.62396 11/2/96 50,926 $ 0.63343 $ 32,258.19 9,344 $ 0.67560 $ 6,312.81 81,133 $0.63343 11/30/96 (175) 50,751 $ 0.63562 $ 32,258.19 0 $ 81,133 $0.63562 11/30/96 36,509 14,242 $ 0.63562 s 9,052.50 - $ 11, 81,133 $0.63562 12102/98 23,443 $0.68467 $ 16,050.78 9,201 s 0.76060 $ 6,998.28 90,334 $0.68467 12/03196 32,635 $0.71451 $ 23,317.98 9,192 $ 0.79060 s 7,267.20 99,526 $0.71451 12/08/98 41,903 $0.73687 $ 30,876.96 9,288 $ 0.8156 s 7,558.98 108,794 40.73687 12/23196 51,019 $0.74994 $ 38,261.39 91116 1, 0.8156 s 7,384.43 117,910 $0.74994 12/23196 60,211 $0.75920 1; 45,712.43 9.192 1 0.8156 1, 7,451.04 127.102 $0.75920 12/30/96 (176) 60,035 $0.76304 $45,808.96 6 5 127,102 $0.76304 12/31/96 42,118 17,9171 $0.76304 s 13,671.39 - 5 - 5 - 127,102 $0.76304 01/02/97 27,047 $0.76222 41 20,615.67 9,130 It 0.78060 $ 6,944.28 136,232 $0.76222 01/08/97 36,353 $0.75412 s 27,414.63 9,306 s 0.73060 $ 6,798.98 145,538 $0.75412 01119/97 45,640 $0.74578 ! 34,037.19 9,287 1 0.71310 s 6,622.56 154,825 $0.74578 01/21/97 54,062 $0.73601 s 39,790.26 8,422 1 0.88310 11 5,753.07 163,247 $0.73601 01/22/97 83,463 $0.72817 $ 46,212.08 9,401 $ 0.68310 $ 6,421.82 172,648 $0.72817 01/22/97 72,641 $0.72248 s 52,481.57 9,178 1 0.88310 $ 6,269.49 181.826 $0.72248 01131/97 (45) 72,596 $0.72293 1 $52,481.57 1 111 181,826 $0.72293 01/31/97 42722 29,874 $0.72293 s 21,596.81 s ! 181,826 $0.72293 02114197 39,071 $0.68236 s 26,660.68 9,197 / 0.55060 $ 5,063.87 191,023 $0.68236 02/18197 48,196 $0.65742 s 31,684.90 9,125 $ 0.55060 $ 5,024.23 200,148 $0.65742 02/19197 57,321 $0.64041 s 36,709.13 9,125 s 0.55060 $ 5,024.23 209,273 $0.64041 02/19/97 66,532 $0.62798 $ 41,780.71 9,211 $ 0.55060 $ 5,071.58 218,484 $0.62798 02/28197 (95) 66,437 $0.62888 $41,780.71 218,484 $0.82888 02/28/97 34,422 32,015 $0.62888 s 20,133.59 $ $ - 218,484 $0.62888 03/11197 41,273 $0.61132 s 25,231.05 9,258 1 0.55060 11, 5,097.45 227,742 $0.61132 03/11197 50,546 $0.60018 s 30,336.76 9,273 1 0.55060 $ 5,105.71 237,015 $0.60018 03/13/97 59,833 $0.59249 s 35,450.18 9,287 $ 0.550601 $ 5,113.42 246,302 $0.59249 03115197 69,053 $0.58689 $ 40,526.72 9,220 $ 0.55060 $ 5,076.53 1 255,522 $0.58689 03/31/97 (5) 69,048 $0.58694 $ 40,526.72 255,522 $0.58694 03/31197 36,669 32,379 $0.58694 s 19,004.38 - $ - ! - 255,522 $0.58694 04117/97 41,732 $0.57039 s 23,803.41 9,353 $0.51310 $ 4,799.02 264,875 $0.57039 04/18/97 51,128 $0.55986 $ 28,624.49 9,396 $0.51310 $ 4,821.09 274,271 $0.55986 Total Gallons Max Inv. Gal. Total Gallons Withdrawn 241,066 72,641 Delivered 230,414 $ 150,850.91 Pounds per Gal 4.23 Max Pounds 95 307,271.43 (1,166) I $ 0.62577 s:wmrwraiurwAeoa.xu Shortfall in Heating Degree Days = M = 31.9% 10 Year Average HDDs 501 Projected Shortfall in Natural Gas Therms = 500,000 @ 530 /therm = $265,000 Projected Shortfall in LP Gas Gallons = 14,300 @ 700 /gallon = 10.000 Total Projected Shortfall in NFE Billings for FY 96/97 = $275,000 May - September 6,570,000 157,000 6,713,655 October - December 4.480.000 125.000 4,594.375 Total for 8 Months 11,050,000 282,000 11,308,030 Shortfall in FY 96/97 NFE Billings = $275.000 = 2.430 = 3.470 = Round to 3.50 Projected Equivalent 8 Mo.Therms 11,308,030 70 %* * = Projected percentage of applicable therms billed under a non - contract rate. Note: If this shortfall were to be collected over only 5 months (May - September), we would have to bill a WNA of 5.90 per therm. This is projected to provide a WNA recovery of: $ 175,000 in FY 96/97 100.000 in FY 97/98 $275,000 in Total See Page 2 of 2 for calculation of the therm shortfall. LP is projected proportionately. FY 96197 20 REVISED BUDGET LP GALLON PROJECTIONS 11000'1+1 ACTUAL % of FY 96197 LP GALLON SALES (THOUSANDS) i CSW:04 /20/97 PASCO TOTAL ANNUAL GALLONS - FY 96 -97 Budget TOTAL VARIANCE PINE 1 AS VARIANCE PASCO VARIANCE TOTAL OCTOBER 9.0 8.0 17.0 4.86% 9.2 8.3 17.5 0.2 0.3 0.5 NOVEMBER 11.0 10.0 21.0 6.01% 11.5 9.7 21.2 0.5 -0.3 0.2 DECEMBER 15.0 12.0 FY 96197 ORIGINAL BUDGET THERM PROJECTIONS IMILLIONSI 12.3 27.4 0.1 0.3 0.4 JANUARY % of 13.0 32.0 9.16% 19.5 20.9 - 0.5 7.9 _ FEBRUARY 19.3 ANNUAL.. 33.5 9.59% MONTH AM WEATHER PASCO -1.2 TOURISM INTERRUPT PROJECTED MDD 10Yr HOD 10Yr THERMS 8.87% 19.6 OCTOBER 0.97 0.01 0.01 -0.13 0.23 1.09 2 3 6.13% NOVEMBER 0.98 0.08 0.02 -0.10 0.24 1.21 21 38 6.85% DECEMBER 0.99 0.31 0.02 0.01 0.25 1.58 83 127 8.91% JANUARY 1.00 0.50 0.03 0.20 0.27 1.99 134 140 11.26% FEBRUARY 1.01 0.47 0.03 0.20 0.30 2.01 127 114 11.38% MARCH 1.02 0.33 0.04 0.15 0.30 1.83 88 61 10.35% TOTAL APRIL 1.03 0.15 0.04 0.08 0.29 1.59 39 17 8.96% MAY 1.04 0.03 0.05 0.00 0.26 1.38 9 1 7.79% JUNE 1.05 0.00 0.05 -0.05 0.25 1.30 1 0 7.36% JULY 1.06 0.00 0.06 -0.12 0.24 1.24 0 0 6.98% AUGUST 1.07 0.00 0.06 -0.13 0.23 1.23 0 0 6.95% SEPTEMBER 1.OA Q.QQ Q.O7 -D.12 Qm 1.26 Q Q 7.09% TOTAL 12.30 1.87 0.45 -0.01 3.09 17.71 501 501 100.00% 1 ACTUAL FY 96197 THERM SALES IMILLIONSI ACT.vs.PROJ. _ MOUTH AMI WEATHER PASCO TOURISM INTERRU PROJECTED mpp HW ACT.THERMS VARIANCE OCTOBER 0.97 0.01 0.01 -0.13 0.25 1.11 2 3 1.11 0.00 NOVEMBER 0.98 0.07 0.02 -0.10 0.28 1.25 20 36 1.26 0.01 DECEMBER 0.99 0.26 0.02 0.01 0.27 1.55 69 101 1.49 -0.06 JANUARY 1.00 0.43 0.03 0.15 0.29 1.90 117 132 1.89 -0.01 FEBRUARY 1.01 0.32 0.02 0.15 0.34 1.84 86 39 1.74 -0.10 MARCH 1.02 0.09 0.03 0.15 0.30 1.59 26 12 1.59 0.00 APRIL MAY JUNE JULY AUGUST SEPTEMBER TOTAL 5.97 1.18 0.13 0.23 1.73 9.24 317 323 9.08 -0.16 BUD.YTD 03/97 fim l,s$ Q14 Q, 1,Q,Q 8.Z1 4ff3 40 3.Qfl -0.63 YTD BUO.VAR. 0.00 -0.50 -0.01 -0.10 0.14 -0.47 -136 180 - 0.00 0.47 rY FY 96197 20 REVISED BUDGET LP GALLON PROJECTIONS 11000'1+1 ACTUAL % of FY 96197 LP GALLON SALES (THOUSANDS) MONTH PINE I AS PASCO TOTAL ANNUAL GALLONS PINE I AS ME= TOTAL VARIANCE PINE 1 AS VARIANCE PASCO VARIANCE TOTAL OCTOBER 9.0 8.0 17.0 4.86% 9.2 8.3 17.5 0.2 0.3 0.5 NOVEMBER 11.0 10.0 21.0 6.01% 11.5 9.7 21.2 0.5 -0.3 0.2 DECEMBER 15.0 12.0 27.0 7.73% 15.1 12.3 27.4 0.1 0.3 0.4 JANUARY 19.0 13.0 32.0 9.16% 19.5 20.9 40.4 0.5 7.9 8.4 FEBRUARY 19.3 14.2 33.5 9.59% 18.1 18.1 36.2 -1.2 3.9 2.7 MARCH 20.0 11.0 31.0 8.87% 19.6 - 11.8 31.4 -0.4 0.8 0.4 APRIL 19.0 12.0 31.0 8.87% MAY 18.0 13.0 31.0 8.87% JUNE 17.0 14.0 31.0 8.87% JULY 16.0 15.0 31.0 8.87% AUGUST 16.0 16.0 31.0 8.87% SEPTEMBER I" 12-Q d3.4 9 TOTAL 194.3 155.2 349.5 100.00% 93.0 81.1 174.1 -0.3 12.9 12.6 Pspa 1 CSW:04121/97 CLEARWATER OAS SYSTEM ATTACHMENT 05 NATURAL GAS RATE BILLING FACTORS FOR MAY 1, 1997 - SEPTEMBER 30, 1997 BASED ON APPROVED GAS ADJUSTMENT FACTORS - Firm Natural Gas Rata Schedules Interr. Contract RS SMF MMF LMF SOS MGS 102- RAC GAC -LAC- SL SL w /M& NGV NSS NG Rate Is NO Rat CNS Applicable Annual Therm Range NA 0 - NA 14 + NA (4 + NA (4 + 0- 18,000- 100,000 NA (i - NA (0 - NA (150 NA Rellaht NA NA NA 100,000 4111111111111!, NA or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up Monthly Customer Charge $6.00 $16.00 $20.00 $50.00 $15.00 $20.00 $50.00 $6.0011 $15.00 if $15.00 if $15.00 $15.00 $6 Rest./ $25.00 $100.00 By not prev. not prev, not prev. $15 GS if Contract Non -Fuel Enerav Charae/Therm billed billed billed not prev. billed Non -Fuel Energy Charge $0.530 $0.530 $0.530 $0.530 $0.470 $0.410 $0.350 $0.200 00.150 60.100 $0.200 $0.300 $0.100 $0.470 $0.280 By Energy Conservation Adj. (ECA) 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 Contract NA Environmental Imposition Adj. (EIA) 0.015 0.015 0.015 0.015 0.015 0.015 0.015 0.015 0.015 0.015 0.015 0.015 0.015 0.015 NA NA Weather Normalization Adj. (WNA) 0.035 0.035 0.035 0.035 0. 035 0. 035 0. 035 0. 035 0. 035 0.035 0.035 0.035 0.035 0.035 N N Total Non -Fuel Energy Charge $0.600 00.600 $0.600 $0.600 $0.540 $0.480 $0.420 $0.270 $0.220 $0.170 $0.270 $0.370 $0.170 $0.540 $0.280 By Purchased Gas Adjustment (PGA) 0.405 0,405 0.405 0.405 0.405 4.405 0.405 0,40¢ 0.405 0. 405 0.405 0.405 0.405 0.405 0.285 Contract 4.285 Total Energy Charge/Therm $1.005 $1.005 $1.005 $1.005 $0.945 $0.885 00.825 $0.675 $0.625 $0.575 $0.675 $0.775 $0.575 $0.945 $0.565 $0.285 Minimum Monthly Bill $6.00 $15.00 $20.00 $50.00 $15.00 $20.00 $50.00 $6.00 @ $15.00 @ $15.000 $15.00 115.00 $6 Rest./ $25.00 $100.00 + Non -Fuel Customer premise premise premise + FAC + FAC $15 GS @ + FAC + Non -Fuel Charge + premise Therm Rate for Non -Fuel Therm + FAC 250 theme; X Rate for Contract If Days in Mo. f of Themf O Compares to LP /Gallon Rate of $ 0.920 $ 0.920 $ 0.920 $ 0.920 0 0.865 $ 0.810 4 0.755 $ 0.618 $ 0.572 4 0.526 $ 0.618 4 0.709 $ 0.526 $ 0.865 $ 0.517 with 6.0% Franchise $ 0.975 $ 0.976 $ 0.975 5 0.975 $ 0.917 $ 0.858 $ 0.800 4 0.655 $ 0.606 $ 0.558 $ 0.655 $ 0.752 $ 0.558 $ 0.917 $ 0.548 Change from 9/96 Therm Rate Utility Tax Note: $ 0.066 0 0.106 0 0.155 4 0.205 4 0.045 $ 0.035 0 0.025 0 0.005 0 0.005 4 0.005 $ 0.005 4 0.005 4 0.005 0 0.045 4 0.032 4 0.012 Fuel Rate per Therm 10101/73 $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 Fuel/Therm STU FACTOR - THERMS 1100 CUBIC $0.336 FEET ICCF) $0.336 $0.336 $0.336 $0.336 $0.336 $0.336 00.336 $0.336 $0.336 $0.336 $0.336 $0.336 $0.336 $0.230 $0.216 Firm Service Rates 10196 1.068 11196 1.067 12 /9e 1.063 47147 1.077 02197 03/97 1.074 04187 05197 1.067 05/.47 07/97 45187 09/97 1.077 1.072 Interruptible Service Rates 1.047 1.046 1.042 1.056 1.056 1.053 1.051 1.046 � CSW:04 /21 /97 CLEARWATER GAS SYSTEM BTU Factor: 2.714 Gallons /100 cubic feet (CCF) PROPANE (LP) RATE BILLING FACTORS BTU Factor: 2.483 Therms /100 cubic feet (CCF) FOR MAY 1, 1997 - SEPTEMBER 30, 1997 BASED ON APPROVED GAS ADJUSTMENT FACTORS Therm Factor: 0.915 Therms /Gallon RLP MLP GLP LLP LPV LPS 411111111111hr 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) Monthly Customer Charge $6.00 $15.00 $15.00 $20.00 $6.00 Real. or $25.00 Set By Contract $15.00 GS if not Non -Fuel Energy Charge: prev. billed @ premise Non -Fuel Energy Charge /Gallon $0.700 $0.700 $0.390 $0.320 $0.100 $0.390 By Contract /Therm $0.765 $0.765 $0.426 $0.350 $0.109 $0.426 By Contr. Energy Conservation Adj. /Gallon 0.018 0.018 0.018 0.018 0.018 0.018 NA (ECA) /Therm 0.020 0.020 0.020 0.020 0.020 0.020 NA Environm'I Imposition Adj. /Gallon 0.014 0.014 0.014 0.014 0.014 0.014 NA (EIA) /Therm 0.015 0.015 0.015 0.015 0.015 0.015 NA Weather Normalization Adj. /Gallon 0.032 0,032 0.032 0.032 0.032 0.032 NA (WNA) /Therm 0.035 0.035 0.035 0.035 0.035 0,035 _NA Total Non -Fuel Charge /Gallon $0.764 $0.764 $0.454 $0.384 $0.164 $0.454 By Contract /Therrn $0.835 $0.835 $0.496 $0.420 $0.179 $0.496 By CntrqllllllIlllllll Purchased Gas Adjustment /Gallon 0. 580 0.580 0,580 0,580 0,580 0.580 0,580 ( PGA) /Therm 0.634 0.634 0.634 0,634 0.634 0.634 0.634 Total Energy Charges /Gallon $1.344 $1.344 $1.034 $0.964 $0.744 $1.034 $0.580 /Therm $1.469 $1.469 $1.130 $1.054 $0.813 $1.130 + NF $0.634 + NF Minimum Monthly Bill $6.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/96 /Gallon Rate $ 0.081 $ 0.381 $ 0.071 $ 0.061 $ 0.031 $ 0.071 $ 0.040 /Therm Rate $ 0.089 $ 0.416 $ 0.077 $ 0.067 $ 0.034 $ 0.077 $ 0.044 Note: Utiliy Tax is billed on total LP bill.