Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 1998
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: Mike Roberto, City Manager FROM: Chuck Warrington, Gas System Managing Director 1998 f COPIES: Rick Hedrick, Deputy City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Laura Damico, Accountant /CCS -LP SUBJECT: GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 1998. DATE: September 25, 1998 GOOD NEWS CONTINUES M This is the time of year when we forecast our fuel and other adjustment clause pricing for the new fiscal year. The good news is that fuel prices for both Natural and Propane (LP) Gas have held fairly stable during the summer months at lower levels than we experienced last winter. The result, based on our forecasts for pricing through the next year, does require us to increase our Firm Purchased Gas Adjustment (PGA) by 10 per therm for natural gas, but we are able to hold our LP PGA at its current level. This is offset by a reduction in our forecasted Energy Conservation Adjustment (ECA) of 10 per therm; hence, we are able to hold our firm Natural Gas rates constant this Fall and LP rates will actually fall. It should be noted that the overall effect of this is a reduction in the typical natural gas residential bill of 90 /therm for our customers since last winter. That is a reduction in our rates for a typical residential customer of over 8% from last winter's rates! We are maintaining our residential natural gas rates below the 51.00 /therm threshold at 99.50 /therm, which we had been above for 19 months from January 1997 thru July 1998!!! No other changes are proposed at this time. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after October 1, 1998: Natural Gas Firm Standard Rate Schedule PGA ....... $0.375 per therm (up 1.00 /therm) Natural Gas Interruptible and Contract (Non- Standard) Rate Schedule PGA ............. $0.270 per therm (up 2.50 /therm) Propane (LP) Gas Rate Schedule PGA .................... $0.450 per gallon (no change) = $0.492 per therm equivalent (no change) Mike Roberto, City Manager Page 2 September 25, 1998 Energy Conservation Adjustment (ECA) ............... $0.040 per therm (down 1.00 /therm) _ $0.037 per gallon of LP (down 0.90 /therm) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) _ $0.000 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... $0.000 per therm (no change) _ $0.000 per gallon of LP (no change) Attachment #1 shows the CGS Summary of Rate Adjustment Clause Collections, which are currently in surplus by a total of $671,254.80. This positively impacts our bottom line financials. Please note that this includes the $437,500 Manufactured Gas Plant insurance claim recovery. The balance without the surplus in the Environmental Imposition Adjustment (EIA) bucket is really $290,439.87. Attachment #2 shows our PGA Calculations. You will note that we are recommending your approval of a 10.50 /therm differential between the Firm (Standard) Rate PGA and the Natural Gas Interruptible & Contract (Non- Standard) Rate Schedule PGA. Attachment #3 shows our calculations for the requirements for the ECA and EIA Adjustments. Attachment #4 shows Terry Neenan's and MGAF's FY 98/99 Natural Gas Purchased Gas Supply Cost Projections. Attachment #5 shows our FY 97/98 fiscal year -to- date history of LP Gas supply costs and projections for FY 98/99. Finally, Attachments #6 and #7 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 March 31, 1999, 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 CCS 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 /csw Attachments Approved: Mike Roberto, City Manager U: \My Documents \MSOFFICE \WINWORD \GASRATES \Gas Adjustments for October 1998.doc ATTACHMENT #1 Page 1 of 3 cSw.MIs/se _ _ (Actuals thru August 1998 $ Projections for Remainder of FY 97198) CLEARWATER GAS SYSTEM 3 MMAR_Y_QF_RXT _AMJ JSTMENT CLAUSE COLLECTIONS - - - -- - NATUReL GAS PURCHASED GAS ADJUSTMENT Budget Month Prior Year Oct-97 Nov -97 Dec-97 Jan-98 Jan -98 Feb-98 Mar -98 Apr -98 May -98 Jun-98 Reservation Charges $ 134,807.13 $ $ 159,095.24 $ $ 69,627.35 $ $ 165,986.87 1 $ Transfer balance from WNA $ 149,905.83 $ $ 162,719.36 $ $ 163,569.74 $ $ 75,888.33 $ $ 73,081.74 $ Commodity Charges 227,499.60 398,997.14 437,285.37 530,558.49 590,706.67 531,980.42 429,474.94 363,813.27 313,008.44 __ Interest Expense $ 677.21 $ 534.95 $ 848.48 $ 350.13 $ - $ 483.58 $ 492.52 $ 176.46 $ - $ - —60-8 _ __ t Center Expenses (1) $11,777.83 12,456.58 17,544.16 9,508.53 78,836.06 14,212.12 13,265.22 10,751.13 12,990.35 11,551.38 _ Total NG Fuel Expenses $ - $ 374,761.77 $ 571,083.91 $ 525,305.36_ $ 706,404.02 $ 78,836.06 $ 755,308.20 $ 708,457.52 $ 603,972.27 $ 452,691.95 F $ $ $ $__624,974.96 $ $ $ $ 1 $ $ $ $ $ _ Total NG PGA Billed 403,213.09 508,378.22 758,550.91 753,520.78 771,666.41 641,508.48 533,984.68 _ 444,456.72 367,012.95 402,867.02 367,920.00 6,578;054.22 $ $ $ $ $ $ $ $ $ $_4_6,815.16 Monthly Overage (Shortage) 28,451.32 (62,705.69) 99,669.60 52,146.89 (78,836.06) (1,787.42) 63,208.89 37,536.21 81,292.73 _Cumulative _YTD $ $ $ $ $ $ $ $ $ $ $ Overage (Shortage) (135,441.89) (106,990.57) (169,696.26) (70,026.66) (17,879.78) (96,715.84) (98,503.26) (35,294.37) 2,241.84 83,534.57 130,349.73 NG PGA RatelTherm Firm/Contr .415/.295 .415/.295 .415/.295 .450/.295 .450/.295 .450/.295 .410/.290 .410/.290 .395/.275 Jul-98 Aug -98 Sep-98 Total YTD $ 84,081.06 $ . 81,660.31 $ 86,000.00 $ 1,406,422.96 $ 266,484.55 $ 290,993.83 $ 295,000.00 $ 4,675,802.72 $ - $ - $ - $ 3,563.34 13,146.80 11,565.51 14,200.00 231,805.67 _397,6_4_1.56 $^ 363,712.41 $ 384,219.65 $ 395,200.00 $ 6,317,594.69 $ 3,300.54 $ 18,647.37 $ (27,280.00) $ 260,459.53 $ 133,650.27 $ 152,297.64 $ 125,017.64 .385/.265 .365/.245 .365/.245 PROPANE (LP) AS PURCHASED GAS ADJUSTMENT (PGA-LP) — -- Budget Month Prior Year Adj Oct-97 Nov -97 Dec-97 Jan -98 Jan -98 Feb-98 Mar -98 Apr -98 May -98 Jun-98 Jul -98 Aug -98 Sep-98 Total YTD Gallons Sold $ 16,766.8 $ 24,477.0 $ 32,174.1 $ 36,710.3 $ Transfer balance from WNA 30,019.6 $ 37,582.9 $ 39,289.6 $ 36,811.8 $ 39,283.1 $ 23,753.5 $ 26,217.4 $ 28,000.0 $ 371,086.1 $ Monthly WACOG - 0.50044 0.52443 0.52608 0.52319 0.50192 0.50733 0.54236 0.49692 0.46430 0.42817 0.43126 0.40110 0.48856 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Pre -pay Expense - - - - - - - - - 8,750.00 - - - - 8,750.00 Commodity Charges $ - $ - $ 8,390.78 $ 8,793.01 $ 16,926.15 $ 19,206.46 $ 3,298.07 $ 15,067.44 $ 19,066.93 $ 21,309.11 $ 18,292.52 $ 18,239.14 $ 10,170.54 $ 11,306.52 $ 11,230.80 $ 181,297.47 Total LP Fuel Expenses $ - $ - $ 8,390.78 $ 8,793.01 $ 16,926.15 $ 19,206.46 $ 3,298.07 $ 15,067.44 $ 19,066.93 $ 21,309.11 $ 27,042.52 $ 18,239.14 $ 10,170.54 $ 11,306.52 $ 11,230.80 $ 190,047.47 $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total LP PGA Billed 8,604.27 12,497.74 17,699.40 20,272.60 - 16,516.54 20,696.03 19,517.14 18,774.53 20,175.24 11,259.84 11,967.85 12,600.00 190,581.18 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Monthly Overage (Shortage) - - 213.49 3,704.73 773.25 1,066.14 (3,298.07) 1,449.10 1,629.10 (1,791.97) (8,267.99) 1,936.10 1,089.30 _661.3_3 1,369.20 533.71 Cumulative YTD Overage (Shortage) $ 5,973.76 $ 5,973.76 $ 6,187.25 $ 9,891.98 $ 10,665.23 $ 11,731.37 $ 8,433.30 $ 9,882.40 $ 11,511.50 $ 9,719.53 $ 1,451.54 $ 3,387.64 $ 4,476.94 $_ 5,138.27_ $ 8,507.47 LP PGA Therm/Gal. .5571.510 .557/.510 .6011.550 .6011.550 _ .601/.550 .601/.550 .557/.510 .557/.510 .546/.500 .513/.470 .492/.450_ .492/.450 ATTACHMENT #1 Page 2 of 3 Page 2 ENERGY CONSERVATION ADJUSTMENT Al Monthly Cumulative ECA Budget Month Cost Center Expenses _ Interest Expense Total ECA Total ECA Overage YTD Overage NG/Thenm _ Notes/ExceptionalItems _ Expenses Billed (Shortage) (Shortage) LP /Gal. Prior Year $ - $ - $ 13,611.96 Oct-97 $ 7,365.60 Sales/Promo 5.8K, Advertising 1.5K $ 7,365.60 $ 18,715.27 $ 11,349.67 $ 24,961.63 _ .030/.027 Nov -97 $ 15,267.86 Sales/Promo 14.6K $ 15,267.86 $ 24,135.90 $ 8,868.04 $ 33,829.67 .030/.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 1 O $ 20,999.00 $ 48,630.18 $ 27,631.18 $ 58,762.56 .040/.037 Feb-98 $ 27,547.17 Advertising 9K, Promotion 9K $ 27,547.17 $ 48,091.51 $ 20,544.34 $ 79,306.90 .040/.037 Mar -98 $ 36,550.30 Promo 31.7K,Adv 4.3KDues 0.5K $ 36,550.30 $ 49,882.60 $ 13,332.30 $ 92,639.20 .040/.037 Apr -98 $ 29,942.56 Advertising 3.2K, Promotion 26.8K $ 29,942.56_ $ 58,048.49 $ 28,105.93 $ 120,745.13 .055/.050 May -98 $ 23,839.22 Advertising 3.1 K, Promotion 20.7K $ 23,839.22 $ 46,231.13 $ 22,391.91 $ 143,137.04 .055/.050 Jun -98 $ 28,635.80 Postal 2.3KAdv 2.5KPromo 23.5K $ 28,635.80 $ 35,327.41 $ 6,691.61 $ 149,828.65 .050/.046 Jul-98 $ 64,814.29 Grand Reserve 42.9K Adv 26K,Promo 18K $__64_,814.29 $ 16,036.60 $ 28,609.50 $ (36,204.79) $ 113,623.86 .0501.046_ Aug -98 $ 16,036.60 Promotion 15.8K Advertising 0.25K _ $ 35,416.69 $ 19,380.09 $ 133,003.95 .050/.046 Sep-98 $ 61,700.00 $ 61,700.00 $ 38,678.40 $ (23,021.60) $ 109,982.35 .050/.046 Total YTD $ 367,169.10 $ - $ 367,169.10 $ 463,539.49 $ 96,370.39 ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIAI Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NG/Thenn Month Expenses Notes/ExceptionalItems Expense Expenses Billed (Shortage) (Shortage) LP /Gal. Prior Year $ - $ - $ - $ (67,178.16) Oct -97 $ 25,299.67 Prof serv&op supp 4.3Kenv consult 21 K $ 25,299.67 $ 6,242.15 $ (19,057.52) $ (86,235.68) .010/.009_ Nov -97 $ 4,048.20 Envlronmtl consulting _ _ $ 4,048.20 _ $ 8,045.31 $ 3,997.11 $ (82,238.57) .010/.009 Dec-97 $ 947.58 Environrntl consulting $ 947.58 $ 10,590.79 $ 9,643.21 $ (72,595.36) .010/.009 Jan -98 $ 8,953.83 Appraisals 9K, Prof fees 3K, Adj envir (3K) _ _ $ 8,953.83 - -- — - - $ 2,505.24 $ 18,24_0.50 . _ ._ $ 18,037.59 $ 9,286.67 $ (63,308.69) $ (47,776.34) .015/.014 --- - -.. .015/.014 Feb-98 $ 2,505.24 Prot sery 1.4K, appraisal fees 1.1 K - _ $ 15,532.35 Mar -98 $ 2,680.20 Prof sery 1.7K,appraisal fees 0.9K $ 2,680.20 $ 18,709.50 $ 16,029.30 $ (31,747.04) .0151.014_ Apr -98 $ 23,011.81 Prof sery 1.9K,Enviro Cons 21K $ 23,011.81 $ 21,103.57 $ (1,908.24) $ (33,655.28) .020/.018 May -98 $ 15,012.03 Prof Sery 1.4K, Apprasal fees 13.6K $ 15,012.03 $ - $ (15,012.03) $ (48,667.31) 0 May -98 $ (437,500.00) Travelers Insururance Settlement (437.5K) $ (437,500.00) $ - $ 437,500.00 $ 388,832.69 0 Jun -98 $ 6,495.76 Prof sery 4K,Appraisal fees 2.5K $ 6,495.76 $ - $ (6,495.76) $ 382,336.93 0 Jul-98 $ 204.43 $ 204.43 $ - $ (204.43) $ 382,132.50 0 Aug -98 $ 1,317.57 $ 1,317.57 $ - $ (1,317.57) $ 380,814.9_3 0 Sep-98 $ 20,000.00 _ $ 20,000.00 $ - $ (20,000.00) $ 360,814.93 0 Sep48 $ $ - $ - $ 360,814.93 0 -- Total YTD $ (327,023.68) $ - $ (327,023.68) $ 100,969.41 $ 427,993.09 Page 2 ATTACHMENT #1 Page 3 of 3 Page 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) . - - - - - - -- — Budget Month._ Adj Prior Year Oct-97 Nov -97 Dec-97 Jan -98 Mar-98 -98 Mar Apr -98 May -98 Jun -98 Jul Aug-- 8 98 Sep-98 Total YTD Total All -------- - - - - -- Expenses $ $ 415,817.82 $ 599,192.99 $ 577,649.79 $ 837,697.45 $ 800,428.05 $ 766,754.95 $ 678,235.75 $ 81,085.72 $ 451,012.26 $ 438,901.67 $ 412,880.34 $ 468,130.80 $ 6,527,787.57 Total Recovery - - - - - -- - -- Billed - $ $ 436,774.78 $ 553,057.17 $ 685,037.56 $ 845,694.19 $ 836,166.42 $ 860,954.54 $ 740,177.68 $ 598,990.34 $ 499,959.37 $ 406,882.29 $ 450,251.56 $ 419,198.40 $ 7,333,144.30 Monthly Cumulative YTD Overage Total All Therm_ ___- — (Shortage) $ $ 20,956.96 $ (46,135.82) $ 107,387.77 $ 7,996.74 $ 35,738.37 $ 94,199.59 $ 61,941.93 $ 517,904.62 $ 48,947.11 $ (32,019.38) $ 37,371.22 $ (48,932.40) $ 805,356.73 (Shortage) $ (183,034.33) $ (162,077.37) $ (208,213.18) $ (100,825.41) $ (92,828.67) $ (57,090.30) $ 37,109.29 $ 99,051.22 $ 616,955.84 $ 665,902.95 $ 633,883.57 $ 671,254.80 $ 622,322.40 NG/LP .4551.546 .455/.546 .4551.641 .5051.656 .5051.656 .505/.656 .4851.632 .4651.612 .445/.596 .435/.563 .4151.542 .4151.542 i6fEATHER NORMALIZATION A) Budget Month Beg. Bal. Oct -97 Nov -97 Deo-97 Jan -98 Jan -98 Feb-98 Mar -98 Apr -98 May -98 Jun -98 Jul-98 Aug -98 LP Gallons 11,577.9 16,869.8 23,652.1 Transfer to NG PGA & LP PGA Interest Expense — Rate /Gallon $ 0.046 $ 0.046 $ 0.046 $ - — — - NG Therms 613,591.9 789,402.9 1,037,858.6 1.0 -- 2,440,854.4 -- Rate/Thenn $ 0.050 $ 0.050 $ 0.050 $ - $ 82,134.130 -- Monthly Overage (Shortage) $ 31,212.18 $ 40,246.16 $ 52,980.93 $ - $ 82,134.13 $ - $ - $ $ - $ - $ - $ - $ - $ 206,573.39 Cumulative YTD Overage (Shortage) $ (206,573.39) $ (175,361.21) $ (135,115.06) $ (82,134.13) $ (82,134.13) $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 _- 0-_ ._ 0_ 0 T-o tal YTD - --- , . 1) Amount differs from cost Center 2078 on the Stmt of Rev b Exp by the amount In taxes. C:1My Doaiments WSOFFICE %EXCELWASRATESXAdustment Clause Recovery for FY 97.99,dsjRe0overy Page 3 CSW:09 /16/98 ATTACHMENT #2 Page 1 of 2 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 09/01/98 03131/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 = 19,850,000 B. Projected NG Reservation Cost 10/1/98 - 9/30/99 = $ 1,510,000 Projected NG Commodity Cost 10/1/98 - 9/30/99 = $ 4,810,000 Budgeted Other Supply Related Expenses = $ 210,000 Total Recovery Needed for FY 98/99 only = $ 6,530,000 Projected Over Recovery of FY 97/98 PGA = $ (125,000) Total Annualized Recovery Needed for FY 98/99 = $ 6,405,000 C. Required Weighted Average Recovery Cost/Therm $ 0.323 WACOG 55.0% Standard = 10,917,500 Therms @ $ 0.370 45.0% Non - Standard = 8,932,500 Therms @ $ 0.265 100.0% 19,850,000 Themes D. Projected NG PGA Annual Revenue = Pinellas NG PGA = Pasco NG PGA = Total NG PGA = 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. Plus 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 $0.105 _ $ Recovery 4,039,475 _ $ 2,367,113 $ 6,406,588 $ 5,952,582 $ 454,005 $ 6,406,588 $ 0.370 $ 0.005 $ 0.375 $ (0.105) $ 0.270 u: 1d»ukbxo9hpesratemppe 1 g978.xis Billing Sep 1997 Oct 1997 Nov 1997 Dec 1997 Jan 1998 Feb 1998 Mar 1998 Apr 1998 May 1998 Jun 1998 Jul 1998 Aug 1998 Total 919748198 For 3/97-2/98 Change CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NONSTANDARD THERMS A RESERVATION CHAR FOR 9/1/97 1/98 Total Th0IDt3 Interruptible Th4rTna lateral % to Ibie Contract Therin8 % Contrac _ Subtotal Non-Standard Therms Subtotal % Non - Standard 1,125,419 291,666 25.9% 247,242 22.0% 538,908 47.9% 1,140,423 293.511 25.7% 233,320 20.5% 526,831 46.2% 1,429,356 331,888 23.2% 308,085 21.6% 639,953 44.8% 1,724,913 333,856 19.4% 353,199 20.5% 687,055 39.8% 1,975,618 372,040 18.8% 409,915 20.7% 781,955 39.6% 1,967,925 390,274 19.8% 398,250 20.2% 788,524 40.1% 2,002,693 345,797 17.3% 435,661 21.8% 781,458 39.0% 1,811,580 379,691 21.0% 398,955 22.0% 778,646 43.0% 1,528,777 342,123 22.4% 369,250 24.2% 711,373 46.5% 1,327,372 319,430 24.1% 318,095 24.0% 637,525 48.0% 1,142,747 297,177 26.0% 285,381 25.0% 582,558 51.0% 1,306,543 313,011 24.0% 296,114 22.7% 609,125 46.6% 18,483,364 4,010,464 21.7% 4,053,447 21.9% 6,063,911 43.6% Net Standard 586,511 613,592 789,403 1,037,858 1,193,661 1,179,401 1,221,235 1,032,934 817,404 689,847 560,189 697,418 10,419,453 ATTACHMENT 82 Page 2 of 2 Net 3,854,884 Charge Per 3,096,515 Charge Per % Standard Reservation s Standard Therm Non - Interruptible Them 52.1% $ 88,759.01 $ 0.151 $ 0.106 53.8% $ 134,807.13 $ 0.220 $ 0.159 55.2% $ 159,095.24 $ 0.202 $ 0.145 60.2% $ 163,522.09 ' $ 0.158 $ 0.118 60.4% $ 165,986.87 $ 0.139 $ 0.104 59.9% $ 149,905.83 $ 0.127 $ 0.095 61.0% $ 162,719.36 $ 0.133 $ 0.098 57.0% $ 163,569.74 $ 0.158 $ 0.114 53.5% $ 75,888.33 $ 0.093 $ 0.064 52.0% $ 73,081.74 $ 0.106 $ 0.073 49.0% $ 84,081.06 $ 0.150 $ 0.099 53.4% $ 81,660.31 $ 0.117 $ 0.082 56.4% $ 1,603,076.71 $ 0.144 i $ 0.104 ti# 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 $ d.153 $ 0.118 1,032,657 165,580 -0.4% 966,932 4.2% 1,112,612 3.8% (79,856) -3.8% $ (99,127.60) $ (0.008) $ (0.014) Note: This figure has been Increased by the amount of the FGT rate refund of $93,894.74. 0 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. #at It is recommended that instead we use the "Charge Per Non - Interruptible Therm" differential rounded to the nearest 0.5 cent or $0.105 for this semi - annual cycle. CSW:09/16/98 ATTACHMENT #3 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/98 - 03131/99 I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 98/99 Budgeted ECA Requirements for FY 98/99 only = Projected (Over) Under Recovery of ECA from FY 97/98 = Total Annualized ECA Recovery Needed during FY 98/99 = Projected Therm Sales for FY98/99 Applicable to ECA Recovery = (Natural Gas @ 55% Standard = 10,917,500 therms & LP @ 50% Standard = 217,500 gal. or 11,100,000 Total Applicable Therms) Computed ECA Recovery Factor Necessary = Round Proposed ECA Recovery Rate to Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 535,000. $ (110,000) $ 425,000 11,100,000 $ 0.0383 $ 0.040 # $ 444,000.00 II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 98/99 Budgeted EIA Requirements for FY 98/99 only = Projected (Over) Under Recovery of EIA from FY 97/98 = Total Annualized EIA Recovery Needed during FY 98/99 = We are over - recovered in ECA & project to stay over - recovered for the FY 98/99 period; therefore, we recommend a EIA rate of $ 100,000 $ (360,000) $ (260,000) $ 0.00 w /chuck%exceltgasrateslecal h978.xis - - CLEARWATER FY97198 PURCHASED GAS COST PROJECTIONS AS OF 911111199 plwe 1 maw M Ea uLNeMnI R.11,qul.hd - -Phaw pha" Is - Act-I _ O Contract -_ Centrad capacity Contract C sow par Month C.Pacity Par Month Dollars Avall ble Ca Par Month AeWlable C-PmltY Per Month NNTD Per Monty Purcha"d Per Month Per Month O/t•97 04 v47 DacA7 e 232,376 306,570 11 78! 117" 53,430 55,211 30.00 30.00 _(52,672_21) 138,588 200,144 175160 0 0 - - - -- __ -0 15 22,500 ]1000 -._.._ __ r- ,SU0 -- -- - -- 42,000 31AN 72 13S.576 159 ,656 1!6510 ____._._____ - 1932!] 187,265 199,S16 ls1 114 .042 142,936 177 !t i 197,5 62 M793 200,269 let 158 0 0 6952 F b.98 Mafia 8 31 789 284,132 31 7H 306,570 5!211 N 33 ,211 53,430 (517513 (51,157.15) (51672.53) $0.00 176707 110775 172,464 206,266 0 -- 0 0 0 -- _ ______ - _ 601 =3068 - - •316 6 ma"s uMt 1 MOB 90 1",212 139 60 1",212 144,212 139,560 117" 40 41 117" 40,440 (51 371731) 01 170.00) (51 170.00) (51170.00) 61 170.00) 7 K 47,263 71,725 S5,346 54,000 0 0 0 0 0 17 1 10 850 10650 12,000 133406 116,377 120.319 117,329 0 IS2734 132,737 114,27S 130654 126,000 - -33306 -36801 •13137 •19419 -3151 Taal 2 797 771 S70,393 ($21803.98) 1 179981 0 267 600 1,715,211 1 "1 651 Tmsp. Projectd NNTD eC4ed P aCbd Rwenrtetl Phew 1 Vebntw MMon01 f10t 137.17 Ells 1738 Ell! "Al It fs7 . Phw M Velunre M Month Phase a Volumes Par Month Rewnatbn Phew MI Vobmra Per MOnm $31086.47 $43 112." $43,03S.61 $45033.61 ___5-3035.61 ] a.as 384 016,47 532,96s,91 _3N,"8.q _-- f]I,eK ,47 $32,986.91 . Phaw 11 VoWmw _Par Montll $9112.02 $2094.27 $7028.97 $1,556.43 - - - .___. 1!31(7 ,46511],617.70_ 1 753.61 $992.02 $950.34 $987.02 _. .. ._.... .---- S9Q.07 (950.71 acted FUM Cent (10,77].!0 sot 5.87 fl {182." 317717.!! -_L /7 x-- 1 �11�70.M 511 784.61 $10,5$4.36 3 "S.9! ...18,071,02 _ 117H.x $7,224.01 C. C. Pam WACOO WACOO lead Con-Ad Coat Par Month $725262.00 $378075.39 $460176.97 f8. I3.!! $4 k!WJZ 6300 013.K $2116,736,119 f25S 978./0 f7 »,651," _ -- -l217,]I 1." $27S,939.91 Ad uetlrlenb Par Month $39,542.03 30,00 A (586028.30) $146.18 ,022.116 _ 1,8..768.(0_ 11 142.]6 $0.00 S2,107.011 _ ..So.00 -- -;o.00 _ $0.00 Fee Par Month Purchased Par MerM sow Per Month Faeter sow Ow Tod _ ___ 0ct+97 NoH7 OW-97 $]750.10 S 67.10 $4 1110 SS IS.IB _"fall $3,434,93 $2 42{6 31 IS3f 8.7 120: Ms-c-" ]7758 3 797,48 $36439.45 3,617.631 31M- 7 f].N $339 $248 $].w - -- $437 $331 $328 "37 - 4110% 39.70% 1725% 53.21% 59.11% 70 1730 33 K8." 5367 I]_T! sss." ny1s� h498 " hdM 113 078.26 $41 79.26 $SI 720] 28.77 331 172.07 115.07 113 10].01 117 37 1114 _1,7,311(5 $3118.07 1 )1730 5771" $61930 IS _ }NO.p 11708.00 ]501,71 170.27 f 672." $2,322.90 11,!9!.11 7,(81,45 $2,205-00 3.11 $1.10 3/,4711 M AI 332 $2," LIS }7.fi 9.13 $Los S2A8 5231 ".19 �. _ hu 5032% 10135% 8133% x.22% .__.,__.._ _ _- _ 11.68% (311 18.27 40147 $]17 7 Elf 1728.!! 314171" !• (3.00 71.2S% $3771691,16 $1,043,235.17 1150970.20 1119019.76 f16S 269.56 f1S 557.51 $1261702.17 If IS 500.89) $135758.84 $37632.96 (2.999 62.04% $6038244.20 Ave s N�r tweed on attwl Taal Ro'ecled DiM WACOC Voluries re bead on NNOrkal w and ed -.A&dh r. FGT 1r i n and luel rat. art We rMe< TM1e number abed too6 krward Mred °^ CvRIM da4, __ 184 6 Manhr Taal It -lion -- 59403.158.99 Total C-di _ 513766491,33 oN q1, ,651.11 1 021093 1,1.613 2nd 6 Mon1M $564.S91.33 $1,771,999.36 $2.336,590.89 837,558 $2.7 9(5 TOTAL - 10Ot11r1t/ far D6-_ --- 1997 Intl11ds1 the FGT rshxld Of overply- - Of _ _ _ d- ro the 1118 settlement 83,894.74 $1 04 7SOS1 $4,533,493.69 $6,038,244.20 1 861 6S1 $3.213 a a �n 11 JPGDPANE INVENTORY AND WEIGHTED COST OF GAS ACOG PREPARED BY TERRY NEENAN DAj:EE 0910/98 LP dod fom110ao 844.1416 Ask for Mary Dab ConMad Endo 930197 Vklor I INVENTORY TANK COSTOi GALLONS DELIVERED DELIVERED TOTAL NEW DATE WRHDRAW INVENT. WACOO 94VENT DEWERED PRICE INVOICE GALLONS WACOG 930197 27.893 16,905.0 0.50044 S" 459.94 S S 16,905 S 050044 194197 26201 50.51299 $13,440.74 9295 S 0.535"0 S 1980.80 26,201 $0 -51299 101997 35.564 $0.51899 $18,45743 9 363 S 0.53580 S 5,018.70 35 584 $0.51899 10!997 44.951 s0 -52250 $23.486.99 9 387 S 013580 S 5.029.55 44,261 50.52250 1011047 54.233 50.52479 S26,46028 9.292 $ 0.53580 S 4,973.30 64,233 50.52478 10/31/97 38 54.269 S012443 $28.480.28 S 64.233 5012443 101UNT 28,840 25,429 SO.52443 513,335.73 S 54233 50.52443 1119297 34,797 50.52211 518167.74 9368 S 0.51580 3 4,832.01 63,601 50.52211 11/12197 43,797 50.53447 323,106.17 9000 S 0.58227 S 5,240.43 72,801 50.53447 11M 2197 53,169 $0.53118 $28242.25 9.372 _S___0.51580 S 4,6U.08 81,973 $0.53118 11130197 515 53.684 $0.52606 326 4225 81,973 SUM 11/30/97 27.904 25.780 SUMS 513,582.34 61,973 so.s2"oe 12/10197 34,981 $0.61890 $18.151.53 9201 S 0.4988 $ 4,589.18 91.174 $0.51890 12113197 44.281 SO.53221 523,566.64 1 9100 S 0.58227 S 5,415.11 100,474 50.53221 12116197 53.581 50.54090 $28.981-751 9.300 S 0.58227 S 5,415.11 1 109,774 50.54090 12/26197 62.944 50.53188 533,478.80 1 9183 S 0.48030 S 4.497.051 119137 $0.53188 12/2997 72.283 50.52522 $37,964.32 1 9.339 S 0.48030 S 4,485.52 128,476 $0.52522 12/31197 280 72,563 5012319 S37,964.32 $ S 128,476 SO.=19 12/31197 43,779 28,784 $0.52319 $15,059.53 S S 120.476 $0.52319 0110996 38,133 30.50887 519320.81 9.349 f 0.15580 S 428127 137.825 50.50687 01112Ns 47,137 90.53851 $25287.54 9.000 S QS8227 S 5,986.73 146,825 50.53861 01116196 56,296 $0.52207 529,390.73 9.163 S 0.44780 3 4,103.19 155,988 5012207 01/22Ne 65,412 S0.S2297 534,208.42 9.116 S 0.44780 S 4.617.69 165,104 $0.52297 01131198 3117.9 68.530 $0,50192 $34,396.36 165,104 $0.50192 01131198 44348.9 24,1el So.50192 Si$136.87 165,104 50.50192 02/0.4498 1 33.481 50.52451 517,56129 9.300 i 0.58227 S 5.424.41 174,404 50.52451 02/06195 42.482 50.53698 S22,e11.29 9 -001 S 0.58227 S 5.250.01 183,405 $0.536% 02/27198 51,668 50.52173 526,956.93 9.186 S 0.45130 S 4,145.64 192,591 $0.52173 02/26196 1,168 52,636 $0.50733 $26,805.44 192,591 $0.50733 36628 02121/98 38,872 13,964 50.50733 $7,064.36 192,591 $0.50733 03/03198 23,103 $0.48517 511208.79 9,139 S 0.45130 S 4,124.43 201,730 $0.48517 0310698 32.361 $0.47548 $15,386.92 9.258 5 0.45130.$ 4,178.14 210,988 1 $0.47548 03117AS 41,661 $0.49954 $20,811.33 9.300 S 0.58227 3 5,424.41 220,2881 50.49954 03/13198 50,861 $0.51489 528177.42 9200 S QSW7 S 5,366.08 229.4881 $0.51469 03117/98 60.161 50.52529 531,601.83 9.300 S 0.58427 S 5,424.41 238,788 $0.52529 03/20195 69,162 50.53283 $36,851.84 9.001 S 0.58227 S 5,250.01 247,789 50.63283 03131193 78.362 5013884 $4220812 9200 S 0.58227 S 5,356.88 258,989 $0.53864 03131198 87,563 $0.54322 $47,566.19 9201 $ 0.58227 S 5357.47 266,190 50.54322 03/31198 173.00 97,736 $0.54236 $47,584.50 266.190 50.54238 03131198 47. 582 40,153 S0.5423e 921.777.38 266,190 $0.54238 04117198 49,615 $0.52395 $25,995.54 9.462 S 0.44580 $ 4218.16 275,652 $0.52395 04/27198 59,039 5051117 $30,196.78 1 9.424 5 0.44590 i 420122 285,076 $0.51 U7 04127198 68,525 50.50238 534,425.62 9.486 S 0.44590 S 42211.86 294,562 so.50238 04127198 77,968 50.49553 538,635.31 9.443 S 0.44580 S 4209.69 304,005 $0.49553 413ONe 287 77,681 $0.49736 $38,835.31 304,005 50.49736 400198 42963 34,718 50.49692 517252.07 304,005 50.49692 Conoco Preps 91198 34,718 $0.49692 S 17252.07 304,005 $0.49692 S 8,750.00 3121198 43,133 $0.48285 $20.818.35 8.415 S 0.42380 S 3,56628 312,420 $0.48265 6121198 51,524 $0.47307 524,374.45 8.391 S 0.42380 S 3.558.11 320,811 1 $0.47307 6121198 60,791 so 46558 $28,301.81 9267 S 0.42380 I S 3,927.35 330.0781 $0.46556 6121/98 69.987 $0.46007 532,199.07 9,196 S 0.42380 S 3,89726 339.274 50.46007 5131198 637.4 69.350 $0.46430 Mi9g.07 339,274 $0.46430 5/31/9$ 30.229 39,121 $9.46430 $18,163.88 339,274 $0.46430 926198 73.477 50.42783 $31.435.60 34.355 S 0.38630 S 13271.72 373.630 50.42783 8130198 58.0 73,419 50.428/7 $31435.60 373,830 S0.42e17 9301" 29,759.0 43,650.0 S9A2817 $10.889.82 373,630 $0.42817 713119e 13.1 43,337 $0.43126 514689.62 373.630 $0.43126 7131M 27,668 15,669.0 SOA3126 $5.757.41 373,630 50.43126 926198 24.179 50.41544 510,044.83 8.510 S 0.38630 S 3.287.41 382,140 SO.41544 812619" 33,432 S0.10737 $13.61925 9.253 S 0.38630 3 3,574.43 391,393 50.40737 812tH" 41,833 50.40314 518,864.57 8.401 S 0.38630 i 3245.31 399,794 $0.40314 92"198 51,072 $0.40009 520433.59 9239 S 0.38630 S 3,569.03 409,033 $0.40009 8131198 128 50,944 50.10110 520,433.59 409,033 $0.40110 8131A8 25,155 25,789.0 $0.40110 510,343.94 409,033 50.40110 TOW Gan" Max Inv. Gal Total God" NA rArown 418,869 $7,736 Deirred 392,1n S 192,512.46 Pounds per Gal 423 Max Pounds 95 371,123.28 0.4909429 Propane Gas Projection 98 -99 Page 1 0 r3 In ?. _I it tZ PROPANE WACOG Projections for FY98/99 Date 8/20/98 Gallons Monthly Total Fuel PGA Net Gain Floating Levelizedl EST. PGA Month Sold WACOG Charge Recovery (Joss) Month PGA PGA Recovery Oct -98 E 25,000 E $0.43000 E $10,750.00 E $11,250.00 $500.00 0.45 0.46 $11,500.00 Nov -98 E 32,000 E $0.43000 E $13,760.00 E $14,400.00 $640.00 0.45 0.46 $14,720.00 Dec -98 E 40,000 E $0.46490 E $18,596.00 E $18,400.00 $196.00 0.46 # 0.46 $18,400.00 Jan -99 E 44,000 E $0.46490 E $20,455.60 E $20,680.00 $224.40 0.47 # _ o.46 $20,240.00 Feb-99 E 43,000 E $0.46490 E $19,990.70 E $20,210.00 $219.30 0.47 # 0.46 $19,780.00 Mar -99 E 46,000 E $0.46490 E $21,385.40 E $21,620.00 $234.60 0.47 # 0.46 $21,160.00 -Apr-99 E 42,000 E $0.45000 E 1 $18,900.00 E $19,320.00 $420.00 0.46 # o.46 $19,320.00 May-99 E 37,000 E $0.45000 E $16,650.00 E $16,650.00 $0.00 0.45 # $17,020.00 Jun -99 E 31,000 E $0.45000 E $13,950.00 E $13,950.00 $0.00 0.45 # _0.46 0.46 $14,260.00 Jul -99 E 31,000 E $0.45000 E $13,950.00 E $13,950.00 $0.00 0.45 # 0.46 $14,260.00 Aug-99 E 31,000 E $0.45000 E $13,950.00 E $13,950.00 $0.00 0.45 #_ 0.46 $14,260.00 Se 99 E 33,000 E $0.45000 E $14,850.00 E $14,850.00 $0.00 0.45 # _ 0.46 $15,180.00 Total E 435,000 $ 0.45331 $ 197,187.70 $ 199,230.00 $ 2,042.30 0.45667 $200,100.00 E = Estimated Gallons & Weighted Average Cost of Gas ( WACOG) A = WACOG based on propane purchases # = Projected recovery based on PGA of 1 .43 to .47 cents Page 1 0 r3 In ?. _I it tZ r CSW.09/16/98 CLEARWATER GAS SYSTEM ATTACHMENT 06 NATURAL GAS RATE BILLING FACTORS FOR OCTOBER 1, 1998 - MARCH 31, 11999 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural Gas Rate Schedules Intern. Contrail -83- SMF MMF LMF SGS MGS LGS SAC SAC_ -LAC_ �L_ SL w/M& NGV _NSB_ Neste Is NG Rate CNS Applicable Annual Therm Range NA (1 - NA (4 + NA (4 + NA (4 + 0- 18,000- 100,000 NA (1 - NA (0 - NA (150 NA Rallght NA 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 not prev. not prev. not prev. $15 GS if Contract Non -Fuel Energy Charge/Therm billed billed billed not prev. billed 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 $0.100 $0.470 $0.280 By Contract Energy Conservation Adj. (ECA) 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 NA NA Environmental Imposition Adj. (EIA) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA NA Weather Normalization Adj. (NINA) 4.444 p,pj?p 4.44Il 4.Q4II 4.444 4.!?4II O.Q4Q 4.4D4 0.000 j),Qj� j),12j�j1 0.000 4.09Q 0.000 NA �A Total Non -Fuel Energy Charge $0.620 $0.620 $0.620 $0.620 $0.510 $0.450 $0.390 $0.240 $0.190 $0.140 $0.240 $0.340 $0.140 $0.510 $0.280 By Contrail Purchased Gas Adjustment ( PGA) 0.375 4 3Zfi QS 4.3ZS Q,�g 0.375 0.375 0.375 4,Sj� 0.375 0.375 0.375 0.375 4.37fi 0.270 0.270 Total Energy Charge/Therm $0.995 $0.995 $0.995 $0.995 $0.885 $0.825 $0.765 $0.615 $0.565 $0.515 $0.615 $0.715 $0.515 $0.885 $0.550 $0.270 + Non -Fuel Minimum Monthly Bill $7.00 $15.00 $20.00 $50.00 $15.00 $20.00 $50.00 $7.00(M $15.00Q $15.000 $15.00 $15.00 $7 Rest./ $25.00 $100.00 Customer premise premise premise + FAC + FAC $15 GS 0 + FAC + Non -Fuel Charge + premise Therm Rate for Non -Fuel Therm + FAC 250 therms X Rate for Contract 0 Days in Mo. 0 of Themes Compares to LP /Galion Rate of $ 0.910 $ 0.910 $ 0.910 $ 0.910 $ 0.810 $ 0.755 $ 0.700 $ 0.563 $ 0.517 $ 0.471 $ 0.563 $ 0.654 $ 0.471 $ 0.810 $ 0.503 ttltrtl+ with 6.0% Franchise $ 0.965 S 0.965 $ 0.965 $ 0.965 $ 0.858 $ 0.800 $ 0.742 $ 0.596 $ 0.648 $ 0.499 $ 0.596 $ 0.693 $ 0.499 $ 0.858 $ 0.533 Change from 9/98 Therm Rate Utift Tax Note, $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 0.025 $ 0.025 Fuel Rate per Therm 10/01/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 Fue1/Therrm $0.306 $0.306 $0.306 $0.306 $0.306 50.306 $0.306 $0.306 $0.306 $0.306 $0.306 $0.306 $0.306 $0.306 $0.215 $0.201 BTU FACTOR - THERMS /100 CUBIC FEET ( CM 10198 11198 17/98 01199 42/4fl 4319.3 49138 45/83 4N122 !]7188 0=2 04122 Finn Service Rates 1.076 Interruptible Service Rates 1.055 CSW:09/16/98 RLP BTU Factor. 2714 Gallons/100 cubic feet (CCF) BTU Factor. 2.483 Therms/100 cubic feet (CCF) Therm Factor. 0.915 Therms/Gallon CLEARWATER GAS SYSTEM PROPANE (LP) RATE BILLING FACTORS FOR OCTOBER 1, 1998 - MARCH 31,1998 BASED ON APPROVED GAS ADJUSTMENT FACTORS RLP MLP GLP LLP LPV LPS Contract LP Svc. CLP Appl. Annual Gallon (Therm) Range NA NA 0 - 2,499 Gallons 2,500 Gallons $ Up NA NA NA 0� or Other Rate Determinant (1 - 3 Units) (4 + Units) (0 -2,287 Therms) (2,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 Charge: prev, billed @ Non -Fuel Energy Charge /Gallon $0.750 $0.750 $0.390 $0.320 premise $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.037 0.037 0.037 0.037 0.037 0.037 NA (ECA) /Therm 0.040 0.040 0.040 0.040 0.040 0.040 NA Environm'I Imposition Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 NA (EIA) /Therm 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj. /Gallon 0.000 0.000 0.000 0.000 0.000 0.000 (WNA) /Therm 0.000 Q= 4.444 4.444 4.444 4.444 �� -NA Total Non -Fuel Charge /Gallon $0.787 $0.787 $0.427 $0.357 $0.137 $0.427 By Contract /Therm $0.860 $0.860 $0.466 $0.390 $0.149 $0.466 By r V. Purchased Gas Adjustment /Gallon 0. 450 0 .450 0.450 0.450 0.450 0.450 0.450 (PGA) [Therm 0.513 Total Energy Charges /Gallon $1.237 $1.237 $0.877 $0.807 $0.587 $0.877 $0.450 /Therm $1.373 $1.373 $0.979 $0.903 $0.662 $0.979 + NF $0.513 Minimum Monthly Bill $7.00 $15.00 $15.00 $20.00 Any Applicable $25.00_ + NF Customer Charge + Customer Charge Non -Fuel Energy Chg + Any Applicable for the Contracted Facility Charges # of Gallons/Mo. Change from 9/98 /Gallon Rate $ (0.009) $ (0.009) $ (0.009) $ (0.009) $ (0.009) $ (0.009) $ - /Therm Rate $ (0.010) $(0.010) $ (0.010) $ (0.010) $ (0.010) $ (0.010) $ - Note: Utiliy Tax is billed on total LP bill.