Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE NOVEMBER 1, 1996
~ I I ~~~ (1t ~ : 0tu .~B.~! . ~i!: If/, If'- CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: Betty Deptula, City Manager \ FROM: Chuck Warrington, Gas System Managing Director cW COPIES: Kathy Rice, Deputy City Manager; Margie Simmons, Finance Director; CGS Management Team; John Scott, Asst. Director Finance/UCS; Tom Madley, Senior Accountant; Karen Miles, Accounting Manager SUBJECT: GAS ADJUSTMENTS EFFECTIVE NOVEMBER 1, 1996 DATE: October 30, 1996 In order to be proactive this year and avoid the large increases in our Purchased Gas Adjustment (PGA) that we had to make last winter, we need to react to two (2) PGA issues for the November billing cycle. First, Attachment #1 shows that we had projected in August that we would end FY 95/96 with a Natural Gas PGA balance of ($122,724.55). This had been based on some preliminary projections by our fuel supplier regarding August and September natural gas fuel supply prices. Instead fuel supply prices stayed higher than they projected, plus we booked a $30,871.40 payment for our SCADA system (which tracks our fuel supply flow and pressures) which we had inadvertently failed to consider in our year-end projections. This caused our actual year-end Natural Gas PGA, as reflected on Attachment #2, to be ($172,741.06) or an additional shortfall of ($50,016.45). We need to recover this as soon as possible within our PGA rate; therefore, we are proposing to raise the Natural Gas PGA adjustment rate by 1 C per therm effective with billings beginning on November 1 st. Additionally, Propane (LP) fuel supply prices have risen more rapidly than expected due to both a cooler than normal Fall thus far plus a tightening of LP supply nationally resulting from a problem with a major Mexican LP supply facility. Attachment #3 shows that our current LP Weighted Average Cost of Gas (WACOG) is $0.54895. We need to adjust for this so as to not fall behind on our LP PGA collections; therefore, we are proposing to raise the Propane (LP) PGA adjustment rate by 2C per gallon effective with billings beginning on November 1 st. ^ , "} I. ./ J I'" / ./ I '" I I Betty Deptula, City Manager Page 2 October 30, 1996 We do not propose to make any changes in our Energy Conservation Adjustment (ECA) and Environmental Imposition Adjustment (EIA) clause rates at this time as our costs are running reasonably in line with our earlier projections. Therefore, we recommend your approval of the following rates to become effective for billings rendered on and after November 1, 1996: Natural Gas Firm Standard Rate Schedule PGA ....... $0.390 per therm (up 1 C) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.277 per therm (up 1 C) Propane (LP) Gas Rate Schedule PGA .................... $0.550 per gallon (up 2C) = $0.601 per therm equivalent Energy Conservation Adjustment (ECA) ............... $0.040 per therm (no change) = $0.037 per gallon of LP Environmental Imposition Adjustment (EIA) ......... $0.010 per therm (no change) = $0.009 per Gallon of LP Weather Normalization Adjustment (WNA) .......... Not Applicable at this time It is our plan to use the above proposed adjustments for billings through March 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 November 1 st billings. If you have any questions on this, please call me. CSW /cw Attachments Approved: CSW 6129/00 J .. i : ATTACHMENT " -.----.--..- _-__-~-_~=~_=_~_~~~~~ff:~~~~TERGAS _SYSTEM .. ~U_ .." "~i----'-" cc: ----... Pa.oe ~. of.2 SUMMABY f..RAIfAI2J.USIMENI...CLAU_S..E...COLL_ECTION i ,---.--.----.-... . - ----. .. ..- ---..-.---..- -. -... -.- " ---"------ (Baaed on Eatlmatea for August & September, 1996) =- -r---=~=~I 1= r-"-==~-=L~ ~-=_=--~.__ fiAD.lBAL.GAS PURCHASED GAS ADJUSTMENT (~:Hm . J. .-. - . , .--..-- ,.----- Monthly Cummulatlve ._----- -- Budget Reservation Commodity Coat Center Total NG Fuel Total NG PGA Overage YTO Overage PGA Month ------- (Shortage) Charges Charges Expenses Expenses __.J!!!leC!.__ _ _ (Shortage) Rate __C-..- Prior Year S - S - $ - S - S . $ . $ . Oct-95 S 123,043.58 S 201,837.74 S 1,649.40 $ 326,530.72 $ 292,67984 $ (33,850.88) $ (33,850.88) 0.32/0.234 Nov-95 S 169,542.26 S 229,280.63 $ 953.99 $ 399,77688 $ 328,780.15 S (70,996.73) $ (104,847.61) 0.32/0.234 0ec-95 $ 178,384.56 S 361,079.89 $ 672.68 $ 540,137.13 S 466,281.94 S (73,855.19) $ (178,702.80) 0.32/0.234 Jan-96 $ 174.798.92 S 518,487.54 $ 713.36 $ 693,999.82 $ 705,130.51 $ 11,130.69 $(167,572.11) 0.36/0.274 Feb-96 $ 160,615.00 $ 591,968.27 $ 10,804.17 $ 763,387.44 $ 731,966.41 $ (31,421.03) $ (198,993.14) 0.36/0.274 Mar-96 $ 169,019.00 $ 443,010.57 $ 8,864.28 $ 620,893.85 $ 623,157.53 $ 2,263.68 $ (196,729.46) 0.36/0.274 Apr-96 $ 163,759.00 $ 413,027.00 $ 4,316.94 $ 581,102.94 $ 586,757.36 $ 5,654.42 $ (191 ,075.04) 0.36/0.243 May-96 $ 77,511.00 $ 371,578.00 $ 8,908.46 $ 457,997.46 $ 501,336.16 $ 43,338.70 $ (147,736.34) 0.36/0.243 Jun-96 $ 87,625.39 $ 316,179.68 $ 12,571.89 $ 416,376.96 $ 417,397.19 $ 1,020.23 $ (146,716.11) 0.36/0.243 Jul-96 $ 86,438.92 $ 278.713.18 $ 4,806.08 $ 369,958.18 $ 363,359.74 $ (6,598.44) $ (153,314.55) 0.39/0.273 Aug-96 S 87,250.00 $ 286,000.00 $ 10,000.00 $ 383,250.00 $ 395,070.00 $ 11,820.00 -$7141,494..55.l 0.39/0.273 Sep-96 $ 84,200.00 $ 293,800.00 $ 10,000.00 $ 388,000.00 $ 406,770.00 $ 18,770.00 $ (122,724.55' '0.39/0.273 Total YTD $1,562,187.63 $ 4,304,962.50 $ 74,261.25 $ 5,941,411.38 $ 5,818,686.83 $ (122,724.55) k. -- 1 """-. ~ PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT IPGA-lP) Monthly Cummulatlve Budget Gallons Monthly Commodity TotallP Fuel TotallP PGA Overage YTD Overage PGA Month Sold WACOG Charges Expenses Billed (Shortage) (Shortage) Rate Prior Year o $ - $ - $ - $ - $ - $ . Oct-95 9,884.67 $ 0.45915 $ 4,538.55 $ 4,538.55 $ 4,456.74 $ (81.81) $ (81.81) 0.48/0.525 Nov-95 10,048.28 $ 0.45848 $ 4,606.94 $ 4,606.94 $ 5,533.32 $ 926.38 $ 844.58 0.48/0.525 080-95 14,736.72 $ 0.45708 $ 6,735.86 $ 6,735.86 $ 8,685.86 $ 1,950.00 $ 2,794.58 0.48/0.525 Jan-96 20,710.64 $ 0.46244 $ 9,577 .43 $ 9,577.43 $ 7,413.29 $ (2,164.14) $ 630.44 0.48/0.525 Feb-96 19,241.97 $ 0.49890 $ 9,599.82 $ 9,599.82 $ 9,219.25 $ (380.57) $ 249.87 0.48/0.525 Mar-96 18,924.00 $ 0.54076 $ 10,233.34 $ 10,233.34 $ 9,083.05 $ (1,150.29) $ (900.42) 0.48/0.525 Apr-96 20,069.60 $ 0.55708 $ 11,180.37 $ 11,180.37 $ 11,164.21 $ (16.16) $ (916.58) 0.54/0.59 May-96 17,462.70 $ 0.53264 $ 9,301.33 $ 9,301.33 $ 9,429.88 $ 128.55 $ (788.04) 0.54/0.59 Jun-96 15,174.30 S 0.53264 $ 8,082.44 $ 8,082.44 $ 8,355.78 $ 273.34 $ (514.70) 0.54/0.59 Jul-96 11,724.70 $ 0.51768 $ 6,069.64 $ 6,069.64 $ 7,295.01 $ 1,225.37 $ 710.67 0.54/0.59 Aug-96 12,000.00 $ 0.50802 $ 6,096.24 S 6,096.24 $ 6,480.00 $ 383.76 $ 1,094.43 0.54/0.59 Sep-96 13,000.00 $ 0.50500 $ 6,565.00 $ 6,565.00 $ 7,020.00 $ 455.00 $ 1,549.43 0.54/0.59 Total YTD 182,977.58 $ 0.50600 $ 92,586.96 $ 92,586.96 $ 94,136.39 $ 1,549.43 ENERGY CONSERVATION ADJUSTMENT (ECAl I Monthly Cummulatlve Budget Cost Center I Total ECA Total ECA Overage YTD Overage ECA Month Expenses Notes/Exceptional Items Expenses Billed (Shortage) (Shortage) Rate Prior Year $ 99,542.54 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 $ 1,236.80 $ (98,305.74) 0.03 Nov-95 $ 26,460.44 $ 26,460.44 $ 19,533.89 $ (6,926.55) $ (105,232.29) 0.03 Dec-95 $ 57,977.65 $45.000 for Morton Plant NC $ 57,977.65 $ 29,093.63 $ (28,884.02) $(134,116.31) 0.03 Jan-96 $ 38,523.60 I $ 38,523.60 $ 39,599.40 $ 1,07580 $(133,040.51) 0.03 Feb-96 $ 26,324.00 $ 26,324.00 $ 39,803.89 $ 13,479.89 $ (119,560.62) 0.03 Mar-96 $ 50,867.20 Heavy Allow month $ 50,867.20 $ 34,315.84 $ (16,551.36) $ (136,111.98) 0.03 Apr-96 $ 34,725.65 $ 34,725.65 $ 42,412.02 $ 7,686.37 $ (128,425.61) 0.03 May-96 $ 46,002.60 .- -.. $ 46,002.60 $ $ $ (138,600.47) 35,827.74 (10,174.86) 0.03 Jun-96 $ 23,810.00 $ 23,810.00 $ 28,78131 $ 4,971.31 $ (133,629.16) 0.03 Jul-96 $ 53,601.05 $ 53,601.05 $ 52,153.33 $ (1,447.72) $ (135,076.88) 0.07 Aug-96 $ 35,000.00 -- $ 35,000.00 $ 55,860~Q. $ 20,860.00 $ (114,216.88) 0.07 Sep-96 $ 35,000.00 $ 35.000~ S 57,407.00 $ 22,407.00 $ (91,809.88) 0.07 $ 1$ ..- Total YTD 543,829.74 452,019.86 $ (91.809.88) .. 543,829.74 $ -----1 -- i I i Page 1 U. chucklwindows\msofficele xcel\gasra les ladjcalc2 .' I i ATTACHMENT .1 ==~-~=--=-'j":::-_-~- __d; J-- ---=~-== --.---.--------,-.---. -. ..-.- t _________ 1--.------._____ ~g82o'] ~1BQ.~~MP-9S~TlO~PJUSIM~ _V~JN ____ I - L----- ---------------....-.---- - ---- --- .. , j I Monthly Cummulatlve I --- -~-----------_..._j .------- -. -. Bud~! _~~.t Center ___________ __ Total EIA Total EIA Overage YTD Overage EIA --..----.- Month .._~~en8e~__ _ Note~~~xcep_~lonallt.em. Expenses Blllod (Shortage) (Shortage) Rate "rior Yearr_$ 121,43563 Feb. 1,1993 - Sept. 30, 1995 $ 121,435.63 $ -- - $ (121,435.63) $ (121,435.63) ---.-. Qct.95 $ 7,32179 ..-___-==r= S 7,321.79 $ 3,750.16 $ (3,571.63) $ (125,007.26) 0.005 Nov-95 I $ 2,51820 I $ 2,518.20 -S-4,25051 $ 1,732.31 $ (123,274.95) 0.005 --_______-4-- ,- ----- Dec-95 $ 2,057.59 ! $ 2,057.59 $ 6,33053 $ 4,272.94 $ (119,002.01) 0.005 - I 2,445.12 $ $ (112,830.09) Jan-96 $ 2,445.12 I $ 8,617.04 $ 6,171.92 0.005 Feb-96 $ 16,512.52 $ 16,512.52 $ 8,660.91 $ (7,851.61) $ (120,681.70) 0.005 Mar.96 S - $ - $ 7,467.51 $ 7,467.51 $ (113,214.19) 0.005 Apr-96 $ 3,741.40 $ 3,741.40 $ 7,079.03 $ 3,337.63 $ (109,876.56) 0.005 May-96 $ 1,198.41 i $ 1,198.41 $ 5,979.02 $ 4,780.61 $ (105,095.95) 0.005 Jun-96 S 27,620.00 Berry Site Remediation (1st) $ 27,620.00 $ 4,803.50 $ (22,816.50) $ (127,912.45) 0.005 Jul-96 $ 27,041.00 Berry Site Remediation (2nd) $ 27,041.00 $ 7,449.58 $ (19,591.42) $ (147,503.87) 0.01 Aug-96 $ 10,000.00 Berry Site Remediation (3rd) $ 10,000.00 $ 7,980.00 $ (2,020.00) $ (149,523.87) 0.01 Sep.96 $ (30,000.00) Recovery 0' Ins. (SSOK) + MGP $ (30,000.00) $ 8,201.00 $ 38,201.00 $ (111,322.87) 0.01 Total YTD $ 191,891.66 $ 191,891.66 $ 80,568.79 $ (111,322.87) TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) ! Monthly Cummulatlve Budget I ! Total All Total Recovery Overage YTD Overage Month I Expenses Billed (Shortage) (Shortage) Prior Year $ 220,978.17 $ - $ (220,978.17) $ (220,978.17) Oct-95 I $ 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) Dec-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 $ 815,823.78 $ 789,650.46 $ (26,173.32) $ (438,985.59) Mar-96 $ 681,994.39 $ 674,023.93 $ (7,970.46) $ (446,956.05) Apr-96 $ 630,750.36 $ 647,412.62 $ 16,662.26 $ (430,293.79) May-96 $ 514,499.80 $ 552,572.80 $ 38,073.00 $ (392,220.80) Jun-96 $ 475,889.40 $ 459,337.78 $ (16,551.62) $ (408,772.42) Jul-96 I $ 456,669.87 $ 430,257.66 $ (26,412.21) $ (435,184.63) Aug-96 $ 434,346.24 $ 465,390.00 $ 31,043.76 $ (404,140.87) Sep-96 $ 399,565.00 $ 479,398.00 $ 79,833.00 $ (324,307.87) Total YTD ! $ 6,769,719.74 $ 6,445,411.87 $ (324,307.87) Page 2 U: chucklwindows 1m sotr tCe\e xcel'\j a sra tes ladJcalc2 . aQe 0 s \Indc.atat'IpwoCllQ I I I I I I ---.----- · CLEARWA TER GAS SYSTEM · SUMMARYOF RATE ADJUSTMENT CLAUSE COLLECTIONS I I I NA TURAL 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,650.66) $ (33,850.88) Nov-95 $ 169,542.26 $ 229,280.63 $ 953.99 $ 399,776.66 $ 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 $ 169,019.00 $ 443,010.57 $ 8,864.28 $ 620,893.85 $ 623,157.53 $ 2,263.68 $ (196,729.46) Apr-96 $ 163,759.00 $ 413,027.00 $ 4,316.94 $ 581,102.94 $ 586,757.36 $ 5,654.42 $ (191,075.04) May-96 $ 77,511.00 $ 371,578.00 $ 8,908.46 $ 457,997.46 $ 501,336.16 $ 43,338.70 $(147,736.34) Jun-96 $ 87,625.39 $ 316,179.68 $ 12,571.89 $ 416,376.96 $ 417,397.19 $ 1,020.23 $(146,716.11) Jul-96 $ 86,438.92 $ 278,713.18 $ 4,806.08 $ 369,958.18 $ 363,359.74 $ (6,598.44) $(153,314.55) Aug-96 $ 89,087.22 $ 277,102.72 $ 6,734.80 $ 372,924.74 $ 357,358.00 $ (15,566.74) $(168,881.29) Sep-96 $ 82,871.00 $ 259,814.54 $ 46,746.19 $ 389,431.73 $ 385,571.96 $ .1..3..859 77) $(172,741.06) Total YTD $1,562,695.85 $ 4,262,079.76 $ 107,742.24 $5,932,517.85 $ 5,759,776.79 $ (172,741.06Y ) Costcenter indudes scada payments of $30,871.40 in September ~ I ~ PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) Monthly Cummulatlve Budget Gallons Monthly Commodity Total LP Fuel Total LP PGA Overage YTD Overage Month Sold WACOG Charges Expenses Billed (Shortage) (Shortage) Prior Year o $ - $ - $ - $ - $ - $ - 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 Oec-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 18,924.00 $ 0.54076 $ 10,233.34 $ 10,233.34 $ 9,083.05 $ (1,150.29) $ (900.42) Apr-96 20,069.60 $ 0.55708 $ 11,180.37 $ 11,180.37 $ 11,164.21 $ (16.16) $ (916.58) May-96 17,462.70 $ 0.53264 $ 9,301.33 $ 9,301.33 $ 9,429.88 $ 128.55 $ (788.04) Jun-96 15,174.30 $ 0.53264 $ 6,082.44 $ 8,082.44 $ 6,355.76 $ 273.34 $ (514.70) Jul-96 11,724.70 $ 0.51768 $ 6,069.64 $ 6,069.64 $ 7,295.01 $ 1,225.37 $ 710.67 Aug-96 10,608.40 $ 0.50802 $ 5,490.88 $ 5,490.88 $ 6,183.15 $ 692.27 $ 1,402.94 Sep-96 14,868.40 $ 0.50308 $ 7,479.99 $ 7,479.99 $ 8,083.40 $ 603.41 $ 2,006.34 Total YTO 163,654.38 $ 0.50562 $ 92,896.60 $ 92,896.60 $ 94,902.94 $ 2,006.34 ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cummulative Budget Cost Center Total ECA Total ECA Overage YTD Overage Month Expenses Notes/Exceptionalltems Expenses Billed (Shortage) (Shortage) Prior Year $ 99,542.54 April 1, 1995 - Sept. 30, 1995 $ 99,542.54 $ - $ (99,542.54) $ (99,542.54) Oct-95 $ 15,995.01 $ 15,995.01 $ 17,231.81 $ 1,236.80 $ (98.305.74) Nov-95 $ 26,460.44 $ 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,803.89 $ 13,479.89 $ (119,560.62) Mar-96 $ 50,867.20 Heavy Allow month $ 50,867.20 $ 34,315.84 $ (16,551.36) $(136,111.98) Apr-96 $ 34,725.65 $ 34,725.65 $ 42,412.02 $ 7,686.37 $(128,425.61) May-96 $ 46,002.60 $ 46,002.60 $ 35,627.74 $ (10,174.86) $(136.600.47) Jun-96 $ 23,810.00 $ 23,810.00 $ 28,781.31 $ 4,971.31 $(133,629.16) Jul-96 $ 53,601.05 $ 53,601.05 $ 52,153.33 $ (1,447.72) $(135,076.88) Aug-96 $ 24,543.20 $ 24,543.20 $ 50,003.76 $ 25.460.56 $(109,616.32) Sep-96 $ 22,769.64 $ 22,769.64 $ 54,584.86 $ 31,815.22 $ (77,801.10) Total YTD $ 521,142.58 $ 521,142.58 $ 443,341.48 $ (77,801.10) A TIACHMENT #2 P 1 f 2 Page 1 U. \w: ndows 1m sofficelexcellga sf6 (sheet recovery) A :/f2- P.::lOP '} of ' i----+---- I ~ ___L.. _____ J _ _H _m_ ____ ____L__ _________ . ENVIRONMENTAL IMPOSITION ADJ~STMENT (EIA) -----..--- --. Monthly Cummulatlve Budget Cost Center I Total ErA Total EIA Overage YTD Overage Month Expenses Notes/Exceptlonalltems 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 $ 16,512.52 $ 16,512.52 $ 8,660.91 $ (7,851.61) $(120,681.70) Mar-96 $ - $ - $ 7,467.51 $ 7,467.51 $(113,214.19) Apr-96 $ 3.741.40 $ 3,741.40 $ 7,079.03 $ 3,337.63 $(109,876.56) May-96 $ 1,198.41 $ 1,198.41 $ 5,979.02 $ 4,780.61 $(105,095.95) Jun-96 $ 27,620.00 $ 27,620.00 $ 4,803.50 $ (22,816.50) $(127,912.45) Jul-96 $ 27,041.00 $ 27,041.00 $ 7,449.58 $ (19,591.42) $(147,503.87) Aug-96 $ 13,171.20 $ 13,171.20 $ 7,142.34 $ (6,028.86) $(153,532.73) Sep-96 Ins. Claim Reimb $ - $ 50,000.00 $ 50,000.00 $(103,532.73) Sep-96 $ 2,429.31 $ 2,429.31 $ 7,828.45 $ 5,399.14 $ (98,133.59) Total YTO $ 227,492.17 $ 227,492.17 $ 129,358.58 $ (98,133.59) TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cummuratlve 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 $ 815,823.78 $ 789,650.46 $ (26,173.32) $(438,985.59) Mar-96 $ 681,994.39 $ 674,023.93 $ (7,970.46) $ (446,956.05) Apr-96 $ 630.750.36 $ 647,412.62 $ 16,662.26 $ (430,293.79) May-96 $ 514,499.80 $ 552,572.80 $ 38,073.00 $(392,220.80) Jun-96 $ 475,889.40 $ 459,337.78 $ (16,551.62) $ (408,772.42) Jul-96 $ 456,669.87 $ 430,257.66 $ (26,412.21) $ (435,184.63) Aug-96 $ 416,130.02 $ 420,687.25 $ 4,557.23 $ (430,627.40) Sep-96 $ 422,110.67 $ 506,068.67 $ 83,958.00 $ (346,669.41) Total YTO $6,774,049.20 $ 6,427,379.79 $ (346,669.41) Page 2 U: Iwindows Imsoffice\excellgasffi( sheet recovery) PROPANE INVENTORY AND WEIGHTED COST OF GAS IWACOGI PREPARED BY TERRY NEENAN DATE 10130/96 LP .uppRed by Farrellga. Data Cont,act End. 9130196 ~----_._- - __n__ DELIVERED DElIYERED --- -,.ClTAl ---NEW ~- .-..._- --- I_ INVENTORY TANK CDST OF GALLONS m__m__ ______. _H____ '.' -. - -~ -"- -- --WA-COG -INYENT -- -... DElivERED -----PRICE ----.- - uWACOG DATE WITHDRAW INYENT. INYOICE GALLONS $0.45915 $21,232.01 0 $0.0??oo $0.00 $0.45915 -- 913095 (595) 46,242 913095 7,848 34,760 $0.46916 $16.966.48 0 $0.0??oo $0.00 $0.45916 10/31/96 0 43,922 $0.46848 $20,137.32 9,172 0.466937636 $4,181.86 9,172 $0.45848 10131196 14,378 29,644 $0.46848 $13,646.33 0 $0.0??oo $0.00 9,172 $0.45848 10131196 11951 29,349 $0.46848 $13.456.93 0 $0.0??oo $0.00 9,172 $0.46848 11130195 0 68,976 $0.46708 $28,042.06 27,626 $0.45669 $12.686.13 36.798 $0.46708 11130196 17,306 39,669 $0.46708 $18,131.91 0 $0.0??oo $0.00 36,798 $0.46708 11130195 (673) 38,996 $0.46708 $17,824.29 0 0 $0.00 36,798 $0.45708 12/29196 0 48.016 $0.48244 $22,204.31 9,020 0.48669 $4,380.02 45.818 $0.46244 12/31196 20,969 27,047 $0.48244 $12,607.61 0 0 $0.00 45.818 $0.46244 12/31196 (475) 26.672 $0.46244 $12.287.96 0 0 $0.00 45.818 $0.46244 01110196 0 36,968 $0.48647 $17,461.30 9,396 0.650589613 $5,173.34 65,214 $0.48547 01117196 0 46,311 $0.49890 $22,606.46 9,343 0.66059 $6.144.16 64,657 $0.49890 01130198 22,276 23,036 $0.49890 $11,492.16 0 $0.0??oo $0.00 64.567 $0.49890 01130196 (286) 22,749 $0.49890 $11,349.48 0 $0.0??oo $0.00 64,657 $0.49890 02/1&196 0 31,974 $0.&181& $16,&67.42 9,477 $0.155059 $5,217.94 74,034 $0.51816 02/28196 (909) 40.642 $0.&4076 $21,923.36 9,225 $0.68059 $5,365.94 83,259 $0.54076 02/2B196 25,61B 14,924 $0.&4076 $8,070.30 0 $0.0??oo $0.00 83,259 $0.64076 03107196 0 24.372 $0.66008 $13,6&0.20 9448 0.59069 $5,679.89 92,707 $0.66008 03130198 0 33,726 $0.66864 $19,173.98 9,363 $0.69069 $6,623.79 102,060 $0.66854 -- 03131196 63 61.714 $0.66708 $28,806.71 17,989 $0.63669 $9,634.73 120,049 $0.&6708 03131198 24,431 27,220 $0.66708 $1&,163.72 0 $0.0??oo $0.00 120,049 $0.56708 04104196 36,474 $0.65163 $20,120.07 9,2&4 0.63569 $4,956.35 129,303 $0.66163 04116/96 46,884 $0.64270 $24,901.20 9.410 $0.60809 $4,781.13 138,713 $0.54270 04118196 66,366 $0.53878 $29,713.83 9,472 $0.50809 $4,812.83 148.185 $0.63678 04130196 23,222 41,470 $0.83090 $34,457.36 9336 $0.50809 $4,743.53 157.521 $0.83090 04130196 1$160) 41.310 0.63264 $22.003.36 0 $0.0??oo $0.00 167,521 $0.63264 05131196 (447) 40,863 0.153264 $21.766.27 0 $0.0??oo $0.00 167,621 $0.63264 06131196 16,467 24,406 0.63264 $12,999.61 0 $0.0??oo $0.00 167,521 $0.63264 06106196 33,688 $0.62312 $17,622.88 9,282 $0.49809 $4.623.27 166.803 $0.62312 06107196 43.041 $0.61768 $22,281.62 9,363 $0.49809 $4,668.64 176.166 $0.61768 06130196 (598) 42.443 $0.61768 $21.971.89 0 $0.0??oo $0.00 176,166 $0.&1768 06130196 16.009 26.434 $0.&1768 $13,684.36 0 $0.0??oo $0.00 176,166 $0.61768 07131/96 36.811 $0.60993 $18,261.17 9,377 $0.48809 $4,676.82 185,533 $0.60993 07131196 46,012 $0.50802 $22,B67. 1 0 9,201 $0.60069 $4,606.93 194,734 $0.60802 07131196 (543) 44.469 $0.60802 $22,591.14 0 $0.0??oo $0.00 194,734 $0.50802 07131/96 16,181 2B,288 $0.&0802 $14,370.87 0 $0.0??oo $0.00 194.734 $0.50802 08/16196 37,641 $0.60665 $19,029.51 9,353 $0.49809 $4,668.64 204,087 $0.60802 08115196 47,037 $0.60406 $23,709.66 9,396 $0.49809 $4.680.05 213.483 $0.60802 08120196 66,447 $0.50308 $28,397.62 9,410 $0.49820 $4,688.06 222,893 $0.50308 08131196 18570 37,877 $0.60308 $19.066.16 0 $0.0??oo $0.00 222,B93 $0.60308 08131196 (341) 37,636 $0.&0308 $18,883.61 0 $0.0??oo $0.00 222.893 $0.50308 09113196 46,837 $0.62443 $24.682.71 9.301 $0.61069 $5,679.10 232,194 $ 0.62443 09114/96 56,162 $0.53872 $30,260.35 9.315 $0.61059 $5,687.65 241.509 $ 0.63872 09/115/9S 66,472 $0.64896 $36,941.06 9,320 $0.61059 $6,690.70 260,829 $ 0.64896 0913019S 17181 64,764 $36.646.71 0 $0.0??oo $0.00 250,829 $ 0.64895 0913019S 20897 43,857 J; $0.64896 ~ $24,075.30 0 $0.0??oo $0.00 250,829 $ 0.54895 Tota' GallolJs Mu Iny. Gal. r-~ .A.. ota' Gallons -- Withdrawn 238.286 66.472 .;- Oallyarad 260.829 $ 131.620.30 POUlJds per Gal 4.23 .... Max Pounds 95 276,946.56 . . ,. S:\INCOCATOA\LPWACOO.XlS ATTACHM. #3 - -- CSW: 1 0/30/96 Applicable Annual The,m Range or Other Rate OetermllJalJt MOlJthly Customer Charge Non-Fulll Eneray Chara.lTh.rm Non-Fuel ElJ8rgy Cha'ge ElJergy COlJservatlon Adj. IECAI Environmentellmposition Adj. (EIAI Weether NormalizetlolJ Adj. IWNA) Total Non-Fuel Ene,gy Che'ga Purchased Gas Adjustment (PGAI Total Energy ChargelThe,m Minimum Monthly Bill Compare. to LP/Gallon Rata of with 6.0% F'alJchiae Change from 9/96 Therm Rate Utllttv Tax Note' Fuel Rate per Therm 10/01/73 Non-Utilitv Taxable FuelfTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR NOYEMBER 1, 1996. MARCH 31,1997 BASED ON NEW GAS RATES & ADJUSTMENT FACTORS -111.... ....iML ....IllIML ....LML NA (1 - NA 14 + NA (4 + NA 14 + 3 Units) Unltsl Units) Units) $6.00 $15.00 $20.00 $50.00 $0.530 $0.530 $0.530 $0.530 0.040 0.040 0.040 0.040 0.010 0,010 0.010 0.010 lUlllll lUlllll lUlllll lUlllll $0.580 $0.580 $0.580 $0.580 ~ ll..JSQ ll..JSQ ll..JSQ $0.970 $0.970 $0.970 .0.970 $6.00 $15.00 $20.00 $50.00 $ 0.888 $ 0.888 . 0.888 $ 0.888 $ 0.941 $ 0.941 $ 0.941 $ 0.941 Firm Natural G._ Am. Schedule. ....In... JJMlL ....IJi.L ~ ~ ....LAC.... $15.00 0- 18,000- 100,000 NA (1 . NA 10 - NA (150 17,999 99.999 & up 3 UlJits) 149 tOlJs) tons & + 1 $0.470 0.040 0.010 lUlllll .0.520 ~ .0.910 $15.00 $20.00 $0.410 0.040 0.010 lUlllll $0.460 ll..JSQ $0.850 $20.00 0.833 $ 0.n8 0.883 $ 0.824 . 0.020 . 0.070 . 0.120 . 0.170 . 0.010 . $0.069 $0.069 $0.069 $0.069 $0.321 $0.321 $0.321 $0.321 BTU FACTOR - THERMS/100 CUBIC FEET ICCFI Firm Service Rates Interruptible Service Rates .1.llLH. 1.11lIi $0.069 $0.321 jL SL w/M& B.ulIb1 NA NA $50.00 $6.00 If $15.00 if $15.00 If $15.00 not prev. not prevo not prev. billed billed billed $0.350 $0.200 $0.t50 $0.100 $0.200 0.010 0.010 0.040 0.040 0.040 0.040 0.040 0.010 0.010 lUlllll lUlllll lUlllll lUlllll $0.250 $0.640 $15.00 + FAC 0.723 $ 0.586 $ 0.540 $ 0.494 $ 0.586 0.766 $ 0.621 $ 0.572 $ 0.524 $ 0.621 $0.069 $0.069 $0.069 $0.069 .0.400 .0.250 .0.200 .0.150 $ 10.0101 . 10.030) . 10.030) $ 10.0301 . 10.0301 ~ NA $15.00 $6 Resl.1 $16 GS II not p,sv. billed $0.300 $0.100 0.040 0.040 0.010 0.010 0.010 Interr. &l..fIm JilL ----'I....- NA 100,000 & up $25.00 $100.00 $0.470 $0.280 0.040 NA 0.010 NA ATTACHMENT #4 Contr8Cl &l..fIm --.l:lU..- NA - ~ lUlU 1.068 1.067 $0.069 $0.321 llZllI2 lUlIQ ~ ll..JSQ ~ $0.069 $0.321 !ll..m lUlllll lUlllll lUlllll lUlllll -1lA By Contract By Contract NA NA ---1!16 By Contnc:t lUll to.zn + Non-FueI CustClrMr Charge + Non-Fuel Them! Rate fOf Contract lofTMnns ~ . 0.004 $0.069 $0.208 1.047 1.046 .0.790 $0.640 $0.590 $0.640 $50.00 $6.00 @ $15.00 @ $15.00@ premise p,emlse p,emlse $0.321 $0.321 $0.321 $0.321 l!3lll 2:!lU 25LU ~ $0.350 $0.150 ll..JSQ ~ lUlIQ $0.740 $0.540 $15.00 $6 Resr.1 + FAC $15 GS @ premise + FAC .0.520 .0.280 ~ lUll .0.910 $0.557 $25.00 $100.00 + FAC + Non-Fuel Tharm Rate fOf 250 therms X I Oeys in Mo. 0.677 . 0.494 $ 0.833 $ 0.510 0.718 $ 0.524 $ 0.883 $ 0.540 (0.0301 $ 10.030) 8 0.010 $ 0.024 $0.069 $0.069 $0.32t $0.321 ll.8Lll lWU $0.069 80.055 $0.321 $0.222 CSW: 1 0/30/96 BTU Factor: BTU Factor: Therm Factor: 2...1.il ~ 2.9ll. Gallons/100 cubic feet (CCF) Therms/100 cubic feet (CCF) Therms/Gallon CLEARWATER GAS SYSTEM PROPANE (LP) RATE BILLING FACTORS FOR NOVEMBER, 1996 - MARCH 31,1997 BASED ON NEW GAS RATES & ADJUSTMENT FACTORS ATTACHMENT '5 Contract LP SYc. - RLP MLP GLP LLP LPV LPS CLP Appl. Annual Gallon (Therm) Range NA NA o - 2,499 Gallons 2,500 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (0-2,287 Therms) 12,288 Therms & Up) Monthly Customer Charge $6.00 $15.00 $15.00 $20.00 $6.00 Resl. or $25.00 Set By Contract $15.00 GS if not Non-Fuel Eneray Charae: prey. billed @ premise Non-Fuel Energy Charge IGallon $0.700 $0.700 $0.390 $0.320 $0.100 $0.390 By Contract ITherm $0.765 $0.765 $0.426 $0.350 $0.109 $0.426 By Contr. Energy Conservation Adj. IGallon 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 Enyironm'l Imposition Adj. IGallon 0.009 0.009 0.009 0.009 0.009 0.009 NA (EIA) /Therm 0.010 0.010 0.Q10 0.010 0.010 0.010 NA Weather Normalization Adj./Gallon Q.QQQ Q.QQQ 2..QQQ Q.QQQ Q.QQQ Q.QQQ --.& (WNA) /Therm Q..Q:QQ 2..QQQ Q.QQQ Q.QQQ Q.QQQ Q.QQQ --.& Total Non-Fuel Charge/Gallon $0.746 $0.746 $0.436 $0.366 $0.146 $0.436 By COntnICI fTherm $0.815 $0.815 $0.476 $0.400 $0.159 $0.476 By Coo. -..' Pu,chased Gas Adjustment/Gallon ~ ~ ~ ~ ~ ~ ~ (PGA) /Therm Q&Ql Q&Ql Q&ll Q&ll Q&ll Q&Ql Q&ll Total Energy Charges /Gallon $1.296 $1.296 $0.986 $0.916 $0.696 $0.986 $0.550 ITherm $1.416 $1.416 $1.017 $1.001 $0.760 $1.077 + NF $0.601 + 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.033 $ 0.333 $ 0.023 $ 0.013 $ (0.017) $ 0.023 $ 0.010 lTherm Rate $ 0.036 $ 0.363 $ 0.024 $ 0.014 $ (0.0191 $ 0.024 $ 0.011 Note: Utiliy Tax is billed on total LP bill.