Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1996
I I CLEARWATER GAS SYSTEM Interoffice Co"espondence Sheet TO: Betty Deptula, City Manager FROM: \ Chuck Warrington, Gas System Managing Director VX'u COPIES: CGS Management Lead Team; John Scott, Asst. Director Finance/UCS; Tom Madley, Senior Accountant; Karen Miles, Accounting Manager SUBJECT: GAS ADJUSTMENTS EFFECTIVE APRIL 1, 1996 DATE: March 19, 1996 We have forecasted our Purchased Gas Adjustment (PGA), Energy Conservation Adjustment (ECA), and Environmental Imposition Adjustment (EIA) costs for the next six (6) month period and recommend your approval of the following rates to become effective April 1, 1996: Natural Gas Firm Standard Rate Schedule PGA ....... $0.360 per therm (no change) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.243 per therm (down 3.1 (:) Propane (LP) Gas Rate Schedule PGA .................... $0.540 per gallon (up 6(:) = $0.590 per therm equivalent Energy Conservation Adjustment (ECA) ............... $0.030 per therm (up 0.7(:) = $0.027 per gallon of LP (up 0.6(:) Environmental Imposition Adjustment (EIA) ......... $0.005 per therm (no change) = $0.005 per Gallon of LP (no change) Weather Normalization Adjustment (WNA) .......... Not Applicable at this time --1 / ( I I Betty Deptula, City Manager Page 2 March 19, 1996 The following attachments document these recommended rates: Attachment #1: Attachment #2: Attachment #3: Attachment #4: Attachment #5: Attachment #6: Attachment #7: Attachment #8: Computes the proposed Natural Gas PGA rates based on Attachment #1 Page 2 of 2 and Attachment #2. A projection of Natural Gas fuel costs which reflect the best estimates of Terry Neenan and our MGAF Buyers, Citrus Marketing. Computes the Propane (LP) Gas PGA rate based on FY -to-date performance and forecasted fuel supply prices based on current conditions (see Attachment # 4) and estimates of the market supply cost for the next 6 months. You will note that the supply cost of LP has risen in recent months from a low of 45.6(: per gallon to our latest purchase price of 59.1 (: per gallon. We expect this to begin moderating in the next month as the winter season passes. The historical WACOG for Propane (LP) Gas for this FY. The Summary of Rate Adjustments year-to-date. The computation of ECA and EIA based on current balances and projected expenditures for the balance of the year. You will note that we are projecting a need to increase the ECA factor somewhat to recover our costs in this area. We recommend holding EIA at the current level. The resulting Natural Gas billing factors. The resulting Propane (LP) Gas billing factors. It is our plan to use the above proposed adjustments for billings through September 30, 1996, 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. We will monitor these monthly 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 the monthly financial statements. I I Betty Deptula, City Manager Page 3 March 19, 1996 You should note that the impact of undercollection of our adjustment clauses has caused our financial earnings to be understated by $425,716.69 through February 1996. These new rates should allow us to catch up all but about $100,000 in longer term EIA Recovery revenues by September 30, 1996. Betty, I would appreciate your approval of these new adjustment clause rates so that I may get them to UCS for implementation on April 1, 1996. If you have any questions on this, please call me. CSW /csw Attachments Approved: ~ ~ Bety Deplula, Cit~ Manager CSW:03/19/96 I ATTACHMENT #1 I NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA) CALCULATION FOR THE BILLING PERIOD OF 04/01/98 .09/30/98 I. Calculation of the 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 4/1/96 - 9/30/96 A. Reservation Charges for the Most Recent 12 Months 3/95 - 9/95 10/95 - 2/96 Total $674,237 $810.362 $1,484,599 B. Standard Rate Schedule Therm Usage for the Most Recent 12 Months 2/95 - 1/96 Total Therm Usage 2/95 - 1/96 Non-Standard Usage (Page 2) 2/95 - 1/96 Standard Usage 16,030,288 /3.298.9351 12,731,353 100.0% 20.6% 79.4% C. Differential Applicable for Interruptible & Contract Rate Schedules for 4/1/96 - 9/30/96 A C $1.484.599 12,731,353 II. Calculation of PGA Factor for the period of 4/1/96 - 9/30/96 Therm Sales Projection for 4/1/96 - 9/30/96 = Projected shortfall from 10/1/95 - 3/31/96 = Projected Natural Gas Cost 4/1/96 - 9/30/96 = Total Recovery Needed for 4/1/96 - 9/30/96 = Required Average Cost/therm to recover = 79.4% Standard = ~ Non-Standard = 100.0% 5,916,836 Therms @ 1,533.164 Therms @ 7,450,000 Therms III. WACOG Recommendation for 3/1/96 - 9/30/96 A. Standard Rate Schedule WACOG B. less Differential C. Non-Standard Rate Schedule WACOG 7,450,000 $ 185,000.00 $ 2,320.782.60 $ 2,505,782.60 $ 0.336 $ $ PGA Rate 0.360 0.243 $0.360 /$0.1171 $0.243 $0.117 Recovery $ 2,130,061 L-373157 $ 2,503,218 Page 1 of 2 ATTACHMENT #1 Page 2 of 2 GAS INTERRUPTIBLE & CONTRACT CUSTOMER THERM CONSUMPTION DETAIL FEBRUARY 95 - JANUARY 96 CUSTOMER NAME Feb-95 Mar-95 Apr-95 May-95 Jun-95 Jul-95 Aug-95 Sep-95 Oct-95 Nov-95 Dec-95 Jan-96 TOTAL LEVEROCKS SEAFOOD 2,076 2,710 2,316 2,705 2,746 1,986 2,681 2,356 2,014 1,715 2,492 3,055 28,852 CLW POINT SWIM CLUB 6,142 5,856 3,625 2,000 618 499 572 429 CHANGED TO MEDIUM CLASS RATE 19,741 BELLEAIR BEACH MOTEL 1,195 959 905 625 364 317 507 297 238 221 702 846 7,177 DUNEDIN BCH CAMPGROUND 2,406 2,324 1,482 864 171 155 135 127 133 727 1,880 3,463 13,866 - AUNTCHILADA'S 929 1,007 929 1,155 1,056 930 1,047 1,051 897 890 940 1,261 12,092 YA-YA'S 866 918 865 866 909 851 813 889 904 777 743 737 10,140 BAREFOOT BISTRO 895 696 659 776 620 579 740 1,051 897 890 940 1,261 10,005 CRABBY BILLS P.HARBOR 1,813 1,502 1,517 1,646 1,183 1,253 1,506 1,349 1,202 1,188 1,127 1,571 16,855 LONG CENTER 4,029 2,976 1,881 1,327 686 663 716 1,558 4,734 6,695 11 ,294 36,561 PARADISE DRY CLEANERS 2,357 2,698 2,609 2,084 2,391 1,348 2,788 1,824 1,797 1,968 21,863 CLIPPER COVE CONDO 1,438 1,886 1,947 1,541 502 365 432 371 313 666 2,170 2,576 14,206 THAI PAN EXPRESS 249 423 341 339 364 335 382 393 2,825 ACME SPONGE & CHAMOIS 5,736 5,365 4,604 6,081 6,639 3,933 4,038 3,902 4,903 3,974 4,903 5,254 59,331 NEIGHBORLY SR svcs 2,185 2,460 2,249 2,758 3,167 3,556 3,720 3,971 CHANGED TO VEHICLE RATE 24,066 NATLCREMATION SOCIETY 6,520 6,096 6,369 6,022 5,983 5,881 6,936 5,426 6,305 3,616 6,007 6,037 71,197 HOLLYWOOD DINER FOXY O'TooLES LA PIZZERIA ITALIANA 218 254 472 ------------------------------------------------------------------------------------------------------------- --~-- SUBTOT AL CONTRACT 32,201 35,807 32,799 31,619 28,144 23,499 26,521 23,623 22,515 21,554 30,997 39,970 349,249 OTHER INTERRUPTIBLE 286,068 259,376 2n,764 240,657 241,212 221,784 217,381 228,368 221,255 234,135 249,200 2n,486 2,949,686 TOT AL INT & CONTRACT 318,269 295,183 310,563 272,276 269,356 245,283 243,902 251,991 243 ,no 255,689 280,197 312,456 3,298,935 ATTACHMENT #2 - CLEARWATER FY95196 PURCHASED GAS COST PROJECTIONS AS OF 3/14196 hMd on AduaI MMBtu'. $old Eaulvalent Ph_n Phuelll "-Ilnqulllhed ......." _,n eon..... _"'_T NNl$ ...._R_ T eon..... :'=~ ~''l A'4'all:"~ :;'''~:-Ih NNTlI -- _.v_ ,.,.... II VoIumN PMM n v..... P'heM II Yotumee -..- ~--- .. .- T_ Per"..... - .... - - iiiill...... ,. ..... ... 0<<.95 232,345 4',7'88 25,000 207.345 4',788 15.500 ...... $90,701,70 $8,032. n 11.075,70 131,53308 12,001.&1 122U5837 1000 ",lIOIl58 JIl 45 on. --'71 NQv.95 306.570 55.211 35,000 271,570 56.211 22,500 101."5 1128,403,87 $8,2500.90 11.58'.50 $olO,39308 12.611,81 1317,78751 1000 S5.1186.. - 38 .,,. -.-... 00e-95 316,789 55.211 10,000 308,789 55.211 31,000 'n.4'. $131,847.99 $8,819.4' 12,151.40 141,739.52 I3.0.0en S4OI.838.11 1000 '7.337.24 S.... 32 2m< ~ J..... 316,789 55.211 5,000 311,189 55.211 48,500 211).120 S133,913,87 S'0,56O.28 $3.227.10 $41,81'.21 12,17870 S587,08I78 10.00 S8,ln.78 42_ S7W7.7J1.77 F...... 296.351 51,&19 5,000 211,351 51.&19 15,500 211,101 SI25,07850 18,930,35 10.00 139,113.71 $3,12845 "'7,011.80 10.00 $7,75848 58_ S8Q,A1UT M...96 318,789 55.211 5,000 311,788 $5,211 31,000 170,000 1140,856.83 1''',888.71 12,151.40 143,232.87 12,75165 131I1,00000 00 .80000 1M 583ft S8Ol.2llD 28 Ajlt... 306,570 53,'30 10,000 :/M,570 53.430 22,110O 1&4.000 &133,789.118 "4,594.25 $1,561.50 $41,838.21 12,88288 .200.00 10.00 ,18000 28 50.000.. _,lIOIl86 Moy.95 144,212 4',788 15,000 121,212 "',788 12.400 131,000 S58,21O.89 12.978.42 S880.58 132,722.02 12.082,86 1282.18000 10.00 15.2.000 50 00._ ,134.35 ........ '.....212 40,_ 20,000 124.212 ..0....0 10500 120,000 SSII,03S08 13.32...' $728,70 $31.668.47 $2.015.41 S25t,200 00 10.00 ,800.00 1273 .,..,.,. S357.770.52 Jul... 144.212 41,788 25,000 11',212 41,788 10,150 117,000 153,771.44 $3,278.28 $752.99 S32.722 02 12,08288 1252,72000 1000 ,",88000 112 71_ S3S0,01317 --.. 144.212 41.788 25,000 111.212 41,718 10,850 110.000 $53,n9," $3.717.48 $752.99 S32.722.02 12,082.88 1237,60000 10.00 14,00000 1286 78_ _'301.80 ....... 139,560 40,_ 25,000 114,580 40,_ 12.000 113,000 ", 880.81 13.127.34 183280 $31,868.47 12.015.41 1244.010.00 1000 ,",52000 1307 75.c:JCN; S337,1ll2.00 T.... 2,808,811 573.955 205,000 2.103,811 573,155 24',100 1,882.358 SI,I58,35888 189,3&4.90 $15,ese.64 ....'.180.. 129.458." 14,020,123.51 1000 170,441.41 S3.278 805ft S5.82'.563.07 10195-_ Not. Vok.m.. ... baed on hillOrical ut . end ed WMlher. FOT end fuel ,..... .. ...... on ec:su.I T_ ""... WACOG -",""gta'-- """'"'" oooto_ "_onl2.3OIMMBtu lIO-ApnI, TcMlR~ T.... '"'""- Cool M-.y: Sept8mblt... baed on ammer pras of S2.181MMBIu gas. 11. IS Manthe _,992.21 12.504,786, '8 1),503,78047 "7,358 S 3._ TheM runben,.......... belt look rorw.d baed on CUT8I"Il d8U1. """8_ 1818,182.21 11,704,800.40 12.320.782.80 745.(0) . 3."5 TOTAl " 1 ,174 ,388.58 ,82', 07 1.tnI2,358 S ..... I ATTACHMENT #3 I PROPANE -~ Date 3/15/96 , , i I i Gallons Monthly Total Fuel PGA Net Gain , i Month s.2ld WACOG Charge Recovery (loss) Month I Oct-95 9,884.67 $0.45915 $4,538.55 $4,456.74 ($81.81) Nov-95 10,048.28 $0.45848 $4,606.94 $5,533.32 $926.38 Dec-95 14,736.72 $0.45708 $6,735.86 $8,685.86 $1,950.00 Jan-96 20,710.64 $0.46244 $9,577.43 $7,413.29 ($2,164.14) Feb-96 19,241.97 $0.49890 $9,599.82 $9,219.25 ($380.57) Mar-96 E 20,000.00 A $0.54076 E $10,815.20 * $9,600.00 ($1,215.20) Apr-96 E 15,896.30 E $0.57 E $9,060.89 # $8,584.00 ($476.89) 0.54 May-96 E 15,896.30 E $0.56 E $8,901.93 # $8,584.00 ($317.93) Jun-96 E 15,896.30 E $0.53 E $8,425.04 # $8,584.00 $158.96 Jul-96 E 15,896.30 E $0.51 E $8,107.11 # $8,584.00 $476.89 Aug-96 E 15,896.30 E $0.50 E $7,948.15 # $8,584.00 $635.85 Sep-96 E 15,896.30 E $0.50 E $7,948.15 # $8,584.00 $635.85 Total 190,000.08 $ 0.50666 $ 96,265.06 $ 96,412.47 $ 147.41 E = Estimated Gallons & Weighted Average Cost of Gas 0NACOG} A = WACOG based on February propane purchases · = Recovery based on current Purchased Gas Adjustment (PGA) of 48 cents # = Projected recovery based on new PGA of 54 cents AITACHMEr-l'T' #4 PROPANE INVENTORY AND WEIGHTED COST OF GAS (WACOG) PREPARED BY TERRY NEENAN DATE I 03/18/96 LP supplied by FerreUgas Date Contract Ends 9/30/96 INVENTORY TANK COST OF GALLONS DELIVERED DELIVERED TOTAL NEW DATE WITHDRAW INVENT. WACOG INVENT DELIVERED PRICE INVOICE GALLONS WACOG 9/3095 595 (595) $0.45915 ($273.191 0 $0.00000 $0,00 $0.45915 9/3095 7,848 34,750 $0.45915 $15,955.46 0 $0.00000 $0.00 $0,45915 10/31/95 0 43,922 $0.45848 $20,137,32 9,172 0.455937636 $4,181.86 9,172 $0,45848 10/31/95 14,378 29,544 $0.45848 $13,545,33 0 $0.00000 $0,00 9,172 $0.45848 10/31/95 195 29,349 $0.45848 $13.455.93 0 $0.00000 $0,00 9,172 $0.45848 11/30/95 0 56,975 $0.45708 $26,042.06 27,626 $0.45559 $12,586.13 36,798 $0,45708 11/30/95 17,306 39,669 $0.45708 $16,131.91 0 $0.00000 $0.00 36,798 $0,45706 ----------- 11/30/95 673 38,996 $0.45708 $17,824.29 0 0 $0.00 36,798 $0.45708 12/29/95 0 48,016 $0.46244 $22,204.31 9,020 0.48559 $4,380.02 45,818 $0,46244 12/31195 20,969 27,047 $0.46244 $12,507.61 0 0 $0.00 45,818 $0,46244 12/31195 475 26,572 $0.46244 $12,287.96 0 0 $0.00 45,818 $0,46244 01/10/96 0 35,968 $0.48547 $17,461.30 9,396 0.550589613 $5,173.34 55,214 $0.48547 01117/96 0 45,311 $0.49890 $22,605.46 9,343 0.55059 $5,144.16 64,557 $0,49890 01/30/96 22,276 23,035 $0,49890 $11,492.16 0 $0.00000 $0.00 64,557 $0.49890 01/30/96 286 22,749 $0.49890 $11,349.48 0 $0.00000 $0.00 64,557 $0,49890 02/15/96 0 31,974 $0.51815 $ 16,567.42 9.477 $0.55059 $5,217.94 74,034 $0,51815 02/28/96 909 40,542 $0.54076 $21,923.36 9,225 $0.58059 $5,355.94 83,259 $0.54076 02/28/96 25,618 14,924 $0.54076 $8,070.30 0 $0.00000 $0.00 83,259 $0.54076 03/07/96 0 24,372 $0.56008 $13,650.20 9448 0.59059 $5,579.89 92,707 $0.56008 03/30/96 0 33,725 $0.56854 $19,173.98 9,353 $0.59059 $5,523.79 102,060 $0.56854 03/31/96 -- 03/31/96 04/29/96 04/30/96 04/30/96 -- 05/31/96 ---- 05/31/96 05/31/96 06/18/96 -- -------" 06/30/96 06/30/96 07/31/96 07/31/96 ..------- ----------.---- 08/31/96 -. ----------- - 08/31/96 08/31/96 09/13/96 09/14/96 09/15/96 09/30/96 Total Gallons Max Inv. Gal. Total Gallons Withdrawn 111,528 56,975 Delivered 102.060 $ 53,143,08 - ..... - . CSW:2102/96 I I I I I CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS I I NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NG) Monthly Cummulatlve Budget Reservation Commodity Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Month Charges Charges Expenses Expenses Billed (Shortage) (Shortage) Prior Year $ - $ - $ - $ - $ - $ - $ - Oct-95 $ 123,043.58 $ 201,837.74 $ 1,649.40 $ 326,530,72 $ 292,679.84 $ (33,850,88) $ (33.850.88) Nov-95 $ 169,542,26 $ 229,280,63 $ 953.99 $ 399,776.88 $ 328,780.15 $ (70,996.73) $(104,847,61) Dec-95 $ 178,384.56 $ 361,079.89 $ 672.68 $ 540,137,13 $ 466,281.94 $ (73,855,19) $(178,702,80) Jan-96 $ 174,798.92 $ 518,487,54 $ 713.36 $ 693,999.82 $ 705,130.51 $ 11,130,69 $(167,572.11) Feb-96 $ 160,615,00 $ 591,968,27 $ 10,804,17 $ 763,387.44 $ 731,966,41 $ (31,421.03) $(198,993.14) Mar-96 $ - $ - $(198,993.14) Apr-96 $ - $ - $(198,993,14) May-96 $ - $ - $(198,993.14) Jun-96 $ - $ - $ (198,993, 14) Jul-96 $ - $ - $(198,993.14) Aug-96 $ - $ - $(198,993,14) Sep-96 $ - $ - $(198,993.14) Total YTD $ 806,384,32 $ 1,902,654.07 $ 14,793.60 $2,723,831.99 $ 2,524,838.85 $ (198,993.14) PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) Monthly Cummulative Budget Gallons Monthly Commodity Total LP Fuel Total LP PGA Overage YTD Overage Month Sold WACOG Charges Expenses Billed (Shortage) (Shortage) Prior Year 0 $ - $ - $ - $ - $ - $ - Oct-95 9,884.67 $ 0.45915 $ 4,538.55 $ 4,538.55 $ 4,456.74 $ (81.81 ) $ (81,81) Nov-95 10,048.28 $ 0.45848 $ 4,606.94 $ 4,606.94 $ 5,533.32 $ 926,38 $ 844.58 Dec-95 14,736.72 $ 0.45708 $ 6,735.86 $ 6,735.86 $ 8,685.86 $ 1,950.00 $ 2,794.58 Jan-96 20,710.64 $ 0.46244 $ 9,577.43 $ 9,577.43 $ 7,413.29 $ (2,164,14) $ 630.44 Feb-96 19,241.97 $ 0.49890 $ 9,599.82 $ 9,599.82 $ 9,219.25 $ (380.57) $ 249.87 Mar-96 $ 0,54076 $ - $ - $ - $ 249.87 Apr-96 $ - $ - $ - $ 249.87 May-96 $ - $ - $ - $ 249.87 Jun-96 $ - $ - $ - $ 249.87 Jul-96 $ - $ - $ - $ 249,87 Aug-96 $ - $ - $ - $ 249.87 Sep-96 $ - $ - $ - $ 249.87 Total YTD 74622.28 $ 0.4698 $ 35,058.59 $ 35,058.59 $ 35,308.46 $ 249.87 ENERGY CONSERVATION ADJUSTMENT (ECA) I Monthly Cummulative Budget Cost Center Total ECA Total ECA Overage YTD Overage Month Expenses Notes/Exceptionalltems Expenses Billed ! (Shortage) (Shortage) Prior Year $ 96,673,65 April 1 , 1995 - Sept. 30, 1995 $ 99,542,54 $ - $ (99,542.54) $ (99,542,54) Oct-95 $ 15,995.01 I $ 15,995.01 $ 17,231.81 i $ 1,236.80 $ (98,305.74) Nov-95 $ 26,460.44 I $ 26,460.44 $ 19,533.89 : $ (6,926.55) $ (105,232.29) Dec-95 $ 57,977.65 $45,000 for Morton Plant NC $ 57,977,65 $ 29,093.63 $ (28,884.02) $(134,116.31) Jan-96 $ 38,523,60 $ 38,523.60 $ 39,599.40 $ 1,075.80 $ (133,040.51) Feb-96 $ 26,324,00 $ 26,324.00 $ 39,421,92 $ 13,097,92 $(119,942,59) Mar -96 $ - $ - $(119,942,59) Apr-96 $ - $ - $ (11 9,942.59) May-96 I $ - $ - $(119,942,59) Jun-96 $ - $ - $ (119,942.59) Jul-96 $ - $ - $(119,942,59) Aug-96 $ - $ - $(119,942.59) Sep-96 $ - $ - $ (119,942.59) Total YTD $ 261,954.35 $ 264,823.24 $ 144,880.65 $ (119,942.59) ATTACHMENT #5 Page 1 of 2 Page 1 U: \windows\msoffice\excellgasf6( sheet recovery) Ii .. a.e:e 0 I I ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) Monthly Cummulative Budget Cost Center Total EIA Total EIA Overage YTD Overage Month Expenses Notes/Exceptional Items Expenses Billed (Shortage) (Shortage) Prior Year $ 121,435,63 Feb. 1, 1993 - Sept. 30,1995 $ 121,435,63 $ - $ (121,435,63) $(121,435,63) Oct-95 $ 7,321.79 $ 7,321,79 $ 3,750.16 $ (3,571,63) $(125,007,26) Nov-95 $ 2,518.20 $ 2,518.20 $ 4,250.51 $ 1,732.31 $ (123,274,95) Dec-95 $ 2,057.59 $ 2,057.59 $ 6,330,53 $ 4,272,94 $ (119,002,01) Jan-96 $ 2,445.12 $ 2,445.12 $ 8,617,04 $ 6,171.92 $ (112,830.09) Feb-96 $ 2,770.71 $ 2,770,71 $ 8,569.97 $ 5,799.26 $ (1 07,030.83) Mar-96 $ - $ - $(107,030.83) Apr-96 $ - $ - $(107,030,83) May-96 $ - $ - $(107,030.83) Jun-96 $ - $ - $(107,030.83) Jul-96 $ - $ - $(107,030,83) Aug-96 $ - $ - $(107,030.83) Sep-96 $ - $ - $(107,030,83) Total YTO $ 138,549,04 $ 138,549,04 $ 31,518,21 $ (107,030,83) TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly CummuJative Budget Total All Total Recovery Overage YTD Overage Month Expenses Billed (Shortage) (Shortage) Prior Year $ 220,978.17 $ - $ (220,978,17) $ (220,978.17) Oct-95 $ 354,386.07 $ 318,118.55 $ (36,267,52) $(257,245.69) Nov-95 $ 433,362.46 $ 358,097,87 $ (75,264.59) $(332,510.27) Oec-95 $ 606,908,23 $ 510,391,96 $ (96,516,27) $ (429,026.54) Jan-96 $ 744,545.97 $ 760,760.24 $ 16,214.27 $(412,812.27) Feb-96 $ 802,081.97 $ 789,177.55 $ (12,904.42) $(425,716.69) Mar-96 $ - $ - $ - $(425,716.69) Apr-96 $ - $ - $ - $(425,716,69) May-96 $ - $ - $ - $(425,716.69) Jun-96 $ - $ - $ - $(425,716.69) Jul-96 $ - $ - $ - $(425,716,69) Aug-96 $ - $ - $ - $(425,716,69) Sep-96 $ - $ - $ - $(425,716.69) Total YTO $ 3, 162,262.86 $ 2,736,546.17 $ (425,716.69) ATTACHMENT #5 p 2 f 2 Page 2 U :\windowslmsofficelexcellgasf6( sheet recovery) I I CSW:03/19/96 ATTACHMENT #6 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 04/01/96 - 09/30/96 I. Calculation of the Energy Conservation Adjustment (ECA) Budget ECA Revenues for FY 95/96 Collected ECA FYTD thru 2/29/96 (See Attachment #5) Projected ECA to be Collected in March, 1996 Target ECA to be Collected by FYE 95/96 $ 390,000.00 $ (144,880.65) L (30.000.00) $ 215,119.35 Projected Therm Billing for 3/1/96 - 9/30/96 7,450,000 Computed ECA Recovery Factor Necessary Round to $ 0.02888 $ 0.030 II. Calculation of the Environmental Imposition Adjustment (EIA) Current EIA Shortfall (See Attachment #5) $ 107,030.83 Current Annual Therm Projection Times 3 Years Projected Therms for Recovery Timetable 16,440,000 .3 49,320,000 Computed EIA Recovery Factor Necessary Round to Current Recovery Level of $ 0.00217 $ 0.005 u :/ch uck\excel\gasrates\eca_2h96.xls CSW:03/19/96 CLEARWATER GAS SYSTEM A IT ACHMENT 1/7 NATURAL GAS RATE BILLING FACTORS FOR THE PERIOD OF 04/01/96 - 09/30/96 Interr . Contract Firm Natural Gas Rate Schedules N.G...Bm tiG...8I1!l -BL ~ ~ --1GL ~ ~ ~ ~ SL w/M80 ~ ~ ~ -.tNL Bmight - Applicable Annual Therm Range NA (1- 0- 18,000- 100,000 NA (1 - NAtO- NA (150 NA NA NA NA 100,000 NA or Other Rate Determinant 3 Units) 17,999 99.999 & up 3 Units) 149 tons) tons & +) & up Monthly Customer Charge $5.00 $15.00 $20.00 $50.00 $5.00 if $15.00 if $15.00 if $15.00 $15.00 $ 5 Resl.! $25,00 $100,00 By not prev. not prev. not prev. $15 GS if Contract Non-Fuel Enerav CharvelTherm billed billed billed not prev, billed Non-Fuel Energy Charge $0.480 $0.430 $0.380 $0.330 $0.200 $0.150 $0.100 $0.200 $0.300 $0.100 $0,430 $0.260 By Contract Energy Conservation Adj. (ECA) 0.030 0.030 0.030 0.030 0.030 0.030 0,030 0.030 0.030 0.030 0.030 NA NA Environmental Imposition Adj. (EIA) 0,005 0.005 0.005 0.005 0.005 0.005 0.005 0.005 0.005 0.005 0.005 NA NA Weather Normalization Adj. (WNA) Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ -1iA -1iA Total Non-Fuel Energy Charge $0.515 $0.465 $0.415 $0.365 $0.235 $0.185 $0.135 $0.235 $0.335 $0.135 $0.465 $0.260 By Contnlct Purchased Gas Adjustment (PGA) M2Q M2Q M2Q M2Q M2Q M2Q M2Q M2Q M2Q M2Q M2Q 2..2.4J 2..2.4J Total Energy ChargelTherm $0.875 $0.825 $0.775 $0.725 $0.595 $0.545 $0.495 $0.595 $0.695 $0.495 $0.825 $0.503 $0.243 + Non-FueI - Minimum Monthly Bill $5.00 $15.00 $20.00 $50.00 $5.00 @ $15.00 @ $15.00 @ $15.00 $15.00 $5 Resl.! $25.00 $100.00 Customer premise premise premise + FAC + FAC $15 GS @ + FAC + Non-Fuel Charge + premise Therm Rate for Non-Fuel Therm + FAC 250 therms X Rate for Contract Utilitv Tax Note: 1/ Days in Mo. I of Therms 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.055 $0.069 Non-Utility Taxable FuellTherm $0.291 $0.291 $0,291 $0.291 $0.291 $0.291 $0.291 $0.291 $0.291 $0,291 $0.291 $0.188 $0.174 BTU FACTOR - THERMS/100 CUBIC FEET ICCFI ~ ~ ~ ~ ~ Q.3L.H ~ ~ ~ QJJM ~ ~ Firm Service Rates 1.063 1.067 1.065 1.067 1.072 1.071 1.070 Interruptible Service Rates 1.043 1.046 1.044 1.046 1.051 1,050 1.049 CSW:03/19/96 ATTACHMENT #8 CLEARWATER GAS SYSTEM BTU Factor: ~ Gallons/100 cubic feet (CCF) PROPANE (LP) RATE BILLING FACTORS BTU Factor: 2A..6..3. Therms/100 cubic feet (CCF) FOR THE SEMI-ANNUAL PERIOD OF 04/01/96 - 09/30/96 Therm Factor: Q..a15. Therms/Gallon Contract LP Svc. ..... RLP GLP LLP LPV LPS CLP Appl. Annual Gallon (Therml Range NA o - 2,499 Gallons 2,500 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (0-2,287 Therms) (2,288 Therms & Up) Monthly Customer Charge $5.00 $15.00 $20.00 $5.00 Resl. or $25.00 Set By Contract $15.00 GS if not Non-Fuel Energy Charae: prev. billed @ premise Non-Fuel Energy Charge /Gallon $0.650 $0.350 $0.290 $0.100 $0.350 By Contract /Therm $0.710 $0.383 $0.317 $0.109 $0.383 By Contr. Energy Conservation Adj. /Gallon 0.027 0.027 0.027 0.027 0.027 NA (ECAI /Therm 0.030 0.030 0.030 0.030 0.030 NA Environm'l Imposition Adj. /Gallon 0.005 0.005 0.005 0.005 0.005 NA (EIA) /Therm 0.005 0.005 0.005 0.005 0.005 NA Weather Normalization Adj./Gallon Q...QQQ Q...QQQ Q..QQQ Q..QQQ Q...QQQ ~ (WNA) /Therm Q..QQQ Q...QQQ Q...QQQ Q..QQQ Q...QQQ ~ Total Non-Fuel Charge/Gallon $0.682 $0.382 $0.322 $0.132 $0.382 By Contract /Therm $0.745 $0.418 $0.352 $0.144 $0.418 By Cntr. Purchased Gas Adjustment/Gallon Q..5.4Q Q..5.4Q Q..5.4Q Q....5.4Q Q..5.4Q ~ (PGA) /Therm Q...5..9.Q Q...5..9.Q ~ Q....5..9.Q Q...5..9.Q Q...5..9.Q Total Energy Charges /Gallon $1.222 $0.922 $0.862 $0.672 $0.922 $0.540 /Therm $1 .335 $ 1.008 $0.942 $0.734 $ 1.008 + NF $0.590 + NF Minimum Monthly Bill $5.00 $15.00 $20.00 Any Applicable $25.00 Customer Charge + Customer Charge Non-Fuel Energy Chg + Any Applicable for the Contracted Note: Utiliy Tax is billed on total LP bill. Facility Charges # of Gallons/Mo.