Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MAY 1, 2001
,;, J TO: FROM: COPIES: SUBJECT: DATE: 1 I ...L ~._" j 'I~ < "':'~, :~lIiJ~~ ,~l l PR .C1C .I''JUC U"l 1-\ .hUL ., CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet CITY CLERK DEPARTMENT William B. Horne II, Interim City Manager \ Chuck Warrington, Managing Director, SBS ()'V Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/CCS GAS ADJUSTMENTS EFFECTIVE MAY 1, 2001 April 13, 2001 Natural and Propane (LP) Gas supply prices have continued to fall, despite the fact that they remain at historic high seasonal levels. Most forecasters see them falling a little more into summer, but remaining at about double the historic rates for the next few years. Therefore, we are recommending about a 9% reduction in both our Natural Gas Purchased Gas Adjustment (PGA) as well as our Propane (LP) PGA in May and project further reductions over the next few months. We are recommending a decrease in our Natural Gas PGA of 10.0C per therm and a decrease in our LP PGA of 8.0C per gallon. We are also recommending an increase in our Energy Conservation Adjustment of 1.0C per thermo We are not recommending changes to any of our other Adjustment clauses at this time. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after May 1, 2001 : Natural Gas Firm Standard Rate Schedule PGA ....... $0.880 per therm (down 10.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.795 per therm (down 10.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.810 per gallon (down 8.0C/gallon) = $0.885 per therm equivalent (down 8.8C/therm) $0.120 per therm(up 1 .OC/therm) = $0.110 per gallon of LP (up 0.9C/gallon) $0.000 per therm (no change) = $0.000 per gallon of LP (no change) $0.000 per therm (no change) = $0.000 per gallon of LP (no change) Energy Conservation Adjustment (ECA) ............... Environmental Imposition Adjustment (EIA) ......... Weather Normalization Adjustment (WNA) .......... 2/~/02'()2. )/ ' / ) -~ William B. Horne II, Interimlcity Manager Page 2 I April 13, 2001 Attachments #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru March and projections for the remainder of the fiscal year. These show that our Natural Gas PGA is currently in deficit by nearly $236,000, but shows that we project to fully recover this deficit by the end of April. You will also note that our overall shortfall for all Adjustment Clauses is currently about $745,000, and we are projecting overcoming this in total by the end of June. This is important to our overall financials, as this has negatively impacted us FYTD. Thus, it is important that we recover this deficit by fiscal year end. Attachments #2 and #3 show our current annual projections for Natural Gas supply costs and LP historical FYTD costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. I should point out that the overall impact of this on our Residential customers is a 5.4% reduction from April rates (4.2% lower for LP), but this is a 39% increase in their therm rate above last May for natural gas (3% higher for LP). This means that our average customer will likely pay an overall bill of $11. 13/month higher this year ($1 .09 for LP) based on 25 therms/month, which is our average monthly residential customer consumption. Most all of this is as a result of the 100% increase in fuel supply costs that we and the nation are experiencing. It should be noted that we pass our gas supply costs directly along to our customers with no mark-up. It is our plan to use the above-proposed adjustments for billings through September 30, 2001, 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. Bill, 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 May 1 st billings. If you have any questions on this, please call me. CSW/csw Attachments Approved: -:zc iIIiam B. Horne II, Interim City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for May 2001.doc ... CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS PaQe 1 of'3 I NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NG) Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center (2) Total NG Fuel Total NG PGA Overage YTD Overage RatelTherm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) FirmlContr Prior Year $ - $ (151,708.91 ) Oct-OO $ 582,108.83 $ 673,430.37 $ 758.54 $ 14,229.04 (1 ) $ 1,270,526.78 $ 706,640.96 $ (563,885.82) $ (715,594.73) .6001.510 Nov-OO $ 151,759.51 $ 815,334.89 $ 3,577.97 $ 12,133.08 $ 982,805.45 $ 854,699.34 $ (128,106.11) $ (843,700.85) .6301.537 Dec-OO $ 160,913.04 $ 1,274,692.54 $ 4,218.50 $ 15,526.84 $ 1,455,350.92 $ 1,309,920.12 $ (145,430.80) $ (989,131.65) .7401.650 Jan-01 $ 160,406.07 $ 2,153,259.49 $ 4,945.66 $ 15,767.57 $ 2,334,378.79 $ 2,624,583.77 $ 290,204.98 $ (698,926.67) 1 .200/1 .110 Feb-01 $ 145,835.14 $ 2,128,738.39 $ 3,494.63 $ 20,324.55 $ 2,298,392.71 $ 2,438,289.22 $ 139,896.51 $ (559,030.16) 1.200/1.110 Mar-01 $ 158,346.66 $ 1,290,216.23 $ 2,795.15 $ 34,890.00 $ 1,486,248.04 $ 1,809,487.89 $ 323,239.85 $ (235,790.31) 1.200/1 .110 Apr-01 $ 124,000.00 $ 1,200,000.00 $ 5,000.00 $ 25,000.00 $ 1,354,000.00 $ 1,726,512.50 $ 372,512.50 $ 136,722.19 .9801.895 Jun-01 $ 84,000.00 $ 900,000.00 $ 5,000.00 $ 25,000.00 $ 1,014,000.00 $ 1,055,880.00 $ 41,880.00 $ 406,134.69 .7801.695 Jul-01 $ 84,000.00 $ 800,000.00 $ 5,000.00 $ 25,000.00 $ 914,000.00 $ 956,550.00 $ 42,550.00 $ 448,684.69 .7301.645 Aug-01 $ 84,000.00 $ 800,000.00 $ 5,000.00 $ 25,000.00 $ 914,000.00 $ 956,550.00 $ 42,550.00 $ 491,234.69 .7301.645 Sep-01 $ 84,000.00 $ 800,000.00 $ 5,000.00 $ 25,000.00 $ 914,000.00 $ 956,550.00 $ 42,550.00 $ 533,784.69 .7301.645 Sep-01 $ - $ - $ 533,784.69 Total YTD $1,903,369.25 $ 13,835;671.91 $ 49,790.46 $ 262,871.08 $ 16,051,702.70 $ 16,737,196.30 $ 685,493.60 (1) Includes annual charge for Admin and CCS chg of $464,740 (2) Cost Center Expenses incl. 100% of Langille's & 9% of Warrington's payroll = Approx. $55K annually. PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP) Monthly Cumulative LP PGA Budget Gallons Monthly Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) Prior Year $ (8,509.46) Oct-OO 29,981.5 $ 0.74032 $ 42.55 $ 22,195.90 (1 ) $ 43,693.29 $ 23,505.82 $ (20,187.47) $ (28,696.93) .874/.800 Nov-OO 26,242.3 $ 0.74479 $ 143.48 $ 19,545.00 $ 19,688.48 $ 21,574.47 $ 1,885.99 $ (26,810.94) .929/.850 Dec-OO 63,591.0 $ 0.76062 $ 134.05 $ 48,368.59 $ 48,502.64 $ 54,001.88 $ 5,499.24 $ (21,311.70) .929/~ Jan-01 58,901.0 $ 0.88607 $ 106.56 $ 52,190.41 $ 52,296.97 $ 55,908.11 $ 3,611.14 $ (17,700.56) 1.093/1.000 Feb-01 54,493.2 $ 0.84295 $ 88.50 $ 45,935.04 $ 46,023.54 $ 57,180.09 $ 11,156.55 $ (6,544.01 ) 1.202/1.100 Mar-01 44,779.5 $ 0.75200 $ 32.72 $ 33,674.18 $ 33,706.90 $ 49,180.71 $ 15,473.81 $ 8,929.79 1.202/1.100 Apr-01 62,000.0 $ 0.75000 $ - $ 46,500.00 $ 46,500.00 $ 52,421.00 $ 5,921.00 $ 14,850.79 .973/.890 Jun-01 48,000.0 $ 0.72000 $ - $ 34,560.00 $ 34,560.00 $ 35,568.00 $ 1,008.00 $ 18,630.79 .852/.780 Jul-01 42,000.0 $ 0.70000 $ - $ 29,400.00 $ 29,400.00 $ 29,925.00 $ 525.00 $ 19,155.79 .8201.750 Aug-01 42,000.0 $ 0.70000 $ - $ 29,400.00 $ 29,400.00 $ 29,925.00 $ 525.00 $ 19,680.79 .8201.750 Sep-01 42,000.0 $ 0.70000 $ - $ 29,400.00 $ 29,400.00 $ 29,925.00 $ . 525.00 $ 20,205.79 .8201.750 Total YTD 569,988.5 $ 0.75701 $ 547.86 431,489.13 $ 453,491.83 $ 482,207.08 $ 28,715.25 Cost Center Expenses CCS Chg Adj at per 5 fm 6,100 $ 8,370.00 (1) Analog phone line for software $ 300.00 (1 ) Software support 1140 (12x95) $ 1,140.00 (1 ) Suburban maint agmt $ 1,140.00 (1 ) Admin fee & Fuel $ 9,000.00 (1 ) LP Truck Lettering $ 500.00 (1 ) HP220 Printer $ 1,004.84 (1 ) Total $ 21,454.84 CSW:4/13/2001 Page 1 U :\windows\msoffice\excel\gasf20( sheet recovery) .. Attachment #1 PaQe 2 of S~ . ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptionalltems (3) Expense Expenses Billed (Shortage) (Shortage) (2) LP/Gal. Prior Year unadjusted $ - $ - $ (727,253.37) Oct-OO $ 471,136.93 Promo$7 ,425,Advetising$1.200Employ Costs$17,433.93 $ 3,636.27 (1 ) $ 474,773.20 $ 68,477.76 $ (406,295.44) $(1,133,548.81) .1101.101 Nov-OO $ 17,475.08 Promo$6,407,Advetising$750Employ Costs$15,240.88 $ 5,667.74 $ 23,142.82 $ 79,861.41 $ 56,718.59 $ (1,076,830.22) .1101.101 Dec-OO $ 84,846.24 Promo$75,339.72 & Balance Empl. Costs $ 5,384.15 $ 90,230.39 $ 112,136.94 $ 21,906.55 $ (1 ,054,923.67) .1101.101 Jan-01 $ 36,334.34 Promo$24,884.19 & Balance Empl. Costs $ 5,274.62 $ 41,608.96 $ 158,201.38 $ 116,592.42 $ (938,331.25) .1101.101 Feb-01 $ 48,825.84 Promo$38,727.43 & Balance Empl. Costs $ 4,691.66 $ 53,517.50 $ 135,968.60 $ 82,451.10 $ (855,880.15) .1101.101 Mar-01 $ 29,023.16 Promo$14,119.77 & Balance Empl. Costs $ 4,279.40 $ 33,302.56 $ 94,773.90 $ 61,471.34 $ (794,408.81) .1101.101 Apr-01 $ 50,000.00 $ 4,100.00 $ 54,100.00 $ 105,427.34 $ 51,327.34 $ (743,081.46) .1101.101 Jun-01 $ 50,000.00 $ 3,700.00 $ 53,700.00 $ 92,596.61 $ 38,896.61 $ (662,397.43) .1301.119 Jul-01 $ 50,000.00 $ 3,500.00 $ 53,500.00 $ 96,662.50 $ 43,162.50 $ (619,234.93) .1401.128 Aug-01 $ 50,000.00 $ 3,300.00 $ 53,300.00 $ 96,662.50 $ 43,362.50 $ (575,872.44) .1401.128 Sep-01 $ 50,000.00 $ 3,100.00 $ 53,100.00 $ 96,662.50 $ 43,562.50 $ (532,309.94) .1401.128 Total YTD $ 987,641.59 $ 50,533.84 $ 1,038,175.43 $ 1 ,233,118.85 $ 194,943.43 (1) Includes annual charges for Admin & CCS of $450,000 (3) Employee Costs includes 100% of McCulley's payroll & benefits = Approx. $65K annually. (2) Prior Year Cummulative balance adjusted by $308,286 for FY 99/00 Sales Cost & $124,712 Conversion Cost losses = $432,998 Total ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) Monthly Cumulative EIA Budget Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ 354,705.60 Oct-OO $ 60,192.83 $ - (1 ) $ 60,192.83 $ ( 1.27) $ (60,194.10) $ 294,511.50 .0001.000 Nov-OO $ 933.74 $ - $ 933.74 $ 0.08 $ (933.66) $ 293,577.84 .0001.000 Dec-OO $ 483.90 $ - $ 483.90 $ - $ (483.90) $ 293,093.94 .0001.000 Jan-01 $ 467.00 $ - $ 467.00 $ (69.70) $ (536.70) $ 292,557.24 .000r.mm- Feb-01 $ - $ - $ - $ - $ - $ 292,557.24 .0001.000 Mar-01 $ 16,090.80 Environmental Consultant $ - $ 16,090.80 $ (5.99) $ (16,096.79) $ 276,460.45 .0001.000 Apr-01 $ 2,500.00 $ - $ 2,500.00 $ - $ (2,500.00) $ 273,960.45 .0001.000 Jun-01 $ 2,500.00 $ - $ 2,500.00 $ - $ (2,500.00) $ 268,960.45 .0001.000 Jul-01 $ 2,500.00 $ - $ 2,500.00 $ - $ (2,500.00) $ 266,460.45 .0001.000 Aug-01 $ 2,500.00 $ - $ 2,500.00 $ - $ (2,500.00) $ 263,960.45 .0001.000 Sep-01 $ 2,500.00 $ - $ 2,500.00 $ - $ (2,500.00) $ 261,460.45 .000/.000 Sep-OO $ - $ - $ 261,460.45 Total YTD $ 93,168.27 $ - $ 93,168.27 $ (76.88) $ (93,245.15) (1 ) Includes annual admin & CCS charges of $60,000 -- age Attachment #1 PaQe 3 of 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage All Therm Month Expenses (3) Billed (Shortage) (Shortage) (2) NG/LP Prior Year $ - $ - $ - $ (532,766.14) Oct-OO (1 ) $ 1,849,186.10 $ 798,623.27 $(1,050,562.83) $ (1 ,583,328.97) .7101.984 Nov-OO $ 1,026,570.50 $ 956,135.30 $ (70,435.20) $ (1,653,764.17) .740/1.039 Dec-OO $ 1,594,567.85 $ 1,476,058.94 $ (118,508.91 ) $(1,772,273.08) .850/1.039 Jan-01 $ 2,428,751.72 $ 2,838,623.56 $ 409,871.84 $ (1,362,401.23) 1.310/1.203 Feb-01 $ 2,397,933.75 $ 2,631,437.91 $ 233,504.16 $(1,128,897.08) 1.310/1.312 Mar-01 $ 1,569,348.30 $ 1,953,436.51 $ 384,088.21 $ (744,808.87) 1.310/1.312 Apr-01 $ 1,457,100.00 $ 1,884,360.84 $ 427,260.84 $ (317,548.03) 1.090/1.083 Jun-01 $ 1,104,760.00 $ 1,184,044.61 $ 79,284.61 $ 31,328.50 .910/.971 Jul-01 $ 999,400.00 $ 1,083,137.50 $ 83,737.50 $ 115,066.00 .8701.960 Aug-01 $ 999,200.00 $ 1,083,137.50 $ 83,937.50 $ 199,003.50 .8701.960 Sep-01 $ 999,000.00 $ 1,083,137.50 $ 84,137.50 $ 283,140.99 .8701.960 Total YTO $ 17,636,538.22 $ 18,452,445.35 $ 815,907.13 (1 ) Incl. annual charge for Admin & CCS chg of $992,110; hence, current monthly shortage of ($60,429.99) (2) Prior Year Cummulative balance adjusted by $432,998 in ECA for Sales & Conversion Costs. (3) PGA-NG & ECA Personnel Costs - Approx. $120,000 annually. Note Total of above impacts = Approx. $1,545,000 annually. WEATHER NORMALIZATION (WNA) Monthly Cumulative WNA Budget Interest Overage YTD Overage NGlTherm Month LP Gallons Expense Rate/Gallon NG Therms RatelTherm (Shortage) (Shortage) LP/Gal Beg.Bal. $ - Oct-OO $ - $ - Nov-OO $ - $ - Dec-OO $ - $ - - Jan-01 $ - $ - Feb-01 $ - Mar-01 $ - $ - Apr-01 $ - $ - May-01 $ - $ - $ - Jun-01 $ - $ - $ - Jul-01 $ - $ - $ - Aug-01 $ - $ - $ - Sep-01 $ - $ - $ - Sep-01 $ - Total YTD - - - $ - Last Updated: 04/13/01 I CSW:4/13/2001 Page 3 U :\windowslmsoffice\excel\gasf20( sheet recovery) ,... IV / 'T"~1 MC"4'Vf- #f?- ~ CLEARWATER FYOO.o1 PURCHASED GAS COST PROJECTIONS AS OF Basod on Actual DTH'1 Sold Phase II Conltacl Capacity Per Month Equlvalenl Relinquished Capacity Per Month Dollars Phase III Conltact Capacity Per Monlh 3/6/01 Phase II Available Capacity Per Month Phase III Available Capacity Per Month Contract NNTS Per Month Projected Sold Per Month % of Purchased Gas losl Purchased Per Month Sold Per Month Sold Gas (PGA revenues) - Ocl-OO Nov-OO Dec-OO Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 232 376 41,788 $ (8.725.73) 117803 0 15500 156361 137584 138,000 -0.93% $ 706,640.96 306 570 53 430 $ (5 679.32) 177117 0 22.500 162883 157808 156,000 -8.29% $ 854,699.34 316789 55211 $ (2.231.00) 142637 0 31000 229 363 198.050 189000 5.83% $ 1,309,920.12 316789 55211 $ (2313.27) 109 062 0 46 500 262 938 216,000 216,000 286 132 49.868 $ 1.137.17) 156500 0 42 000 179 500 201 000 201,000 316789 55211 $ (5 629.50) 182000 0 31000 190 000 222,000 222,000 306 570 53 430 $ (33 777.00) 203 000 0 22 500 157000 190000 190,000 144212 41 788 $ (3 753.00) 46 000 0 12400 140000 157,000 157000 139560 40 440 $ (22518.00) 43 000 0 10500 13 7 000 140000 140 000 -- 144,212 41788 $ (23.268.60) 49 000 0 10850 137 000 13~.000 137 000 144 212 41788 $ (23 268.60) 49 000 0 10850 13 7 000 137000 137000 139560 40 440 $ (22518.00) 36 000 0 12000 144 000 137,000 137 000 Tol.1 2,793,771 570,393 ($154,819.19) Total Reservation Phase II Volumes Per Month Projected Transp. Phase II Volumes Per Month Projected NNTS Phase II Volumes Per Month Total Reservation Phese III Volumes Per Month 1,311,119 o 267,600 2,053,045 2,030,442 -4.90% 2,871,260.42 Projected Transp. Phase III Volumes Per Month Totel Commodity Cost Per Month FGU Managemenl fee Per Month WACOG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Total Billing :From FGU ... Infinite Adjustmenls Per Month Fuel Cost (Fuel Relention) Ocl-OO Nov-OO Dec-OO Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 $ 87210.71 $ 3 559.00 $ 914.50 $ 32 109.90 $ 2 445.07 $ 782037.13 $ - $ 24175.79 $ 5312.30 $ 5.75 $ 5.47 57.03% $ 899.405.96 $ 115055.72 $ 3041.07 $ 1 327.50 $ 41 055.61 $ 3621.31 $ 969 703.64 $ 337.40 $ 26091.53 $ 6065.18 $ 6.13 $ 7.16 50.80% $1,121,463.15 $ 118,890.91 $ 2642.15 $ 1 829.00 $ 42424.13 $ 5247.77 $ 1922501.93 $ (73.81) $ 40 734.95 $ 6 916.03 $ 9.08 $ 61.66% $2,083,414.97 $ 117 750.47 $ 6,159.37 $ 2 743.50 $ 42 225.37 3 454.g5 $ 2.441057.67 $ 158.87 $ 53 507.83 $ 7887.88 $ 9.89 $ - 70.68% $2,601,463.73 $ 106,355.26 $ 6149.73 $ 2 478.00 $ 38 139.05 $ 929.76 $ 1 500 768.00 $ (15092.87)$ 34,291.33 I ~ 6.315.91 $ 9.18 $ 53.42% $1,647.439.46 $ 38 139.05 $ 5 728.53 $ 1 829.00 $ 42424.13 $ 1 407.88 $ 998814.31 $ $ 28,540.15 $ 7 SODS $ 6.09 $ 51.08% $1.156328.86 $ 115.055.72 $ 4401.73 $ 1 327.50 $ 41055.61 $ 1,362.47 $ 827298.37 $ $ 23,642.68 $ 6 052.50 $ 6.06 $ 43.6101'0 $95~ $ 54,122.76 $ 4,174.01 $ 731.60 $ 32109.90 $ 1 065.59 $ 756 953.71 $ - $ 21 638.85 $ 5253.75 $ 6.00 $ 75.27% $840,164.97 $ 52376.87 $ 4.103.80 $ 619.50 $ 31 074.10 $ 1031.22 $ 741214.41 $ $ 21 187.89 $ 5 152.50 $ 5.86 $ 76.11% $802.766.87 $ 54122.76 $ 4046.51 $ 640.15 $ 32109.90 $ 1 065.59 $ 745 709.90 $ $ 21 320.05 $ 5118.75 $ 5.91 $ 73.66'k $809,314.11 $ 54122.76 $ 4.046.51 $ 640.15 $ 32,109.90 $ 1 065.59 $ 745 709.90 $ - $ 21 320.05 $ 5 118.75 $ 5.91 $ 77.42% $809,314.11 $ 52.376.87 $ 4401.30 $ 708.00 $ 31 074.10 $ 1031.22 $ 768 604.31 1,- $ 21 965.29 $ 5467.50 $ 5.77 $ 77.22% $830245.27 $965,579.87 $52,453.71 $15,788.40 $437,911.70 INote: Volumes are based on historical usage and expected weather. FGT transportation and fuel rates are based on actual approved gas tariff rates. These numbers represent a best look forward based on current data. I F:\SUPPlY\WACOC 2001.)(1, $23,728.43 $13,200,373.26 . ($14,670.41) $338,416.38 $72,164.80 $7.088 64.00% $14,552,281.67 Averaxe Total Projected DTH WACOG Total Reservation T alai Commodi Cost Sold 1 sl 6 Months $807,185.84 $8,702,330.30 $9,509,516.13 1,132,442 $8.397 2nd 6 Months $457274.95 $4,585490.59 $5 042 765.54 898,000 $5.616 TOT At $1,264,460.79 $13,287,820.89 $14,552,281.67 2,030,442 $7.17 Sold Wacog FYOl 8udget 2078 10,500,000.00 PO amounl $ 4,052,281.67 over budget . ~ PROPANE INVENTORY AND WEIGHTED COST OF GAS (WACOG) ATr&fI",~,Jr #.,3 5 = 5uburban Propane J PREPARED BY BRIAN LANGILLE I 5ea3 = 5ea-3 of Florida DATE 04/13/01 Tex = Texaco LP supplied by Suburban III Texaco 5uburban Greg Cope (800) 457.94 9 Texaco Joe Gump 888-920-057 Invoice INVENTORY TANK C05T OF GALLONS DELIVERED DELIVERED TOTAL NW Number DATE WITHDRAW INVENT. WACOG INVENT DELIVERED PRICE INVOICE GALLONS WAC G 09/30/00 28.532 53,324 $0.71588 $ 38 173.59 $ $ $ 0.715 8 Tex 25164 I 0/1/2000 62.428 $0.72389 $ 45 190.67 9104 $ 0.76877 $ 7017.08 9104 $0.723 9 5 882639 I 0/3/2000 64 432 $0.72576 $ 46 761.57 2004 $ 0.78400 $ 1 570.90 11 108 $0.725 6 5 882640 10/4/2000 66 322 $0.72742 $ 48 243.72 1891 $ 0.78400 $ 1482.15 12998 $0.727 2 5 882641 10/6/2000 67 999 $0.72881 $ 49 558.80 1677 $ 0.78400 $ 1315.08 14676 $0.728 1 5 882642 10/10/2000 70139 $0.73019 $ 51214.85 2140 $ 0.77400 $ 1 656.05 16815 $0.730 9 5 882643 10/11/2000 72 523 $0.73163 $ 53060.22 2.384 $ 0.77400 $ 1 845.37 19199 $0.731 3 5 882644 10/13/2000 74313 $0.73337 $ 54499.22 I 790 $ 0.80400 $ 1 439.00 20 989 $0.733 7 5 882645 10/17/2000 76471 $0.73565 $ 56255.84 2158 $ 0.81400 $ 1756.61 23147 $0.735 5 5 882646 10/18/00 78 237 $0.73742 $ 57693.44 1766.1 $ 0.81400 $ 1437.61 24913 $0.737 2 5 882647 10/23/00 80 526 $0.73846 $ 59 465.20 2289.1 $ 0.77400 $ 1 771.76 27 202 $0.738 6 5 882648 1 0/2 4/00 82 607 $0.73935 $ 61 076.05 2 081.2 0.77400 $ 1610.85 29284 $0.739 5 5 882649 10/25/00 84817 $0.74026 $ 62 786.05 2209.3 $ 0.77400 $ 1 710.00 31493 $0.740 6 5 882650 10/27/00 86771 $0.74102 $ 64298.60 1954.2 0.77400 $ 1 512.55 33447 $0.741 2 5 882651 10/31/00 88,841 $0.74155 $ 65.880.16 2070.1 0.76400 $ 1 581.56 35517 $0.741 5 5ea3 4000-0270 10/31/00 107,719 $0.74032 $ 79 746.58 18 878.0 0.71350 $ 13 866.42 54 395 $0.740 2 Month End 10/31/00 39 747 67,972 $0.74032 $ 50.321.06 5 882652 11/01/00 70,002 $0.74101 $ 51.872.29 2 030.4 0.76400 $ I 551.23 56 426 $0.741 1 5 882653 11/07/00 72 186 $0.74140 $ 53518.87 2183.8 0.75400 $ 1 646.59 58 609 $0.741 0 5 882654 11/13/00 74 502 $0.74148 $ 55 241.68 2315.6 0.74400 $ 1722.81 60925 $0.741 8 5 882655 11/14/00 76 393 $0.74179 $ 56 667.87 1 891.5 0.75400 $ 1426.19 62817 $0.74 I 9 5 882656 11/15/00 77 912 $0.74222 $ 57827.93 1 518.4 0.76400 $ 1160.06 64 335 $0.742 2 5 882657 11/16/00 79513 $0.74317 $ 59091.20 1601.1 0.78900 $ 1 263.27 65 936 $0.743 7 5 882658 11/21/00 80 729 $0.74408 $ 60068.78 1215.9 0.80400 $ 977.58 67152 $0.744 8 5 882659 11/21/00 83 043 $0.74575 $ 61 929.64 2314.5 0.80400 $ I 860.86 69 466 $0.745 5 5 882660 11/27/00 85 176 $0.74721 $ 63 644.25 2132.6 0.80400 $ 1714.61 71 599 $0.747 1 5ea3 4000-0353 11/27/00 103909 $0.74040 $ 76 933.59 18 733.0 0.70941 $ 13 289.34 90 332 $0.740 0 5 882661 11/28/00 105691 $0.74147 $ 78 366.72 1782.5 0.80400 $ 1433.13 92 115 $0.741 7 5 882662 11/28/00 107421 $0.74248 $ 79 757.56 I 729.9 0.80400 $ 1 390.84 93 844 $0.742 8 5 882663 11/29/00 109678 $0.74374 $ 81571.78 2 256.5 0.80400 $ 1814.23 96101 $0.743 4 5 882664 I 1/30/00 112015 $0.74479 $ 83427.60 2337.3 0.794 $ 1 855.82 98 438 $0.744 9 Month End 11/30/00 48 726 63 289 $0.74479 $ 47 136.99 5 882665 12/02/00 65 050 $0.74612 $ 48 534.98 1760.7 0.79400 $ 1 398.00 100199 $0.746 2 5 882666 12/04/00 67128 $0.74760 $ 50 184.99 2078.1 0.79400 $ 1650.01 102277 $0.747 0 5 882667 12/05/00 69481 $0.7495 I $ 52076.64 2 352.8 0.80400 $ 1 891.65 104 630 $0.749 I 5 882668 12/06/00 71480 $0.75104 $ 53 684.00 1999.2 0.80400 $ I 607.36 106 629 $0.751 4 5 882669 12/07/00 73710 $0.75385 $ 55 566.04 2229.9 0.84400 $ 1 882.04 108859 $0.753 5 5 882670 12/09/00 75991 $0.75716 $ 57 537.34 2 281.6 0.86400 $ 1 971.30 111 141 $0.757 6 5 882699 12/12/00 77934 $0.76062 $ 59 278.27 1943.0 0.89600 $ 1 740.93 113 084 $0.760 2 5 882700 12/13/00 80087 $0.76426 $ 61 207.09 2152.7 0.89600 $ 1.928.82 115236 $0.764 6 5ea3 12/18/00 98 922 $0.76025 $ 75 205.04 18835 0.74319 $ 13 997.95 134 071 $0.760 5 882701 12/20/00 99 922 $0.76221 $ 76161.13 1.000.1 0.956 $ 956.10 135071 $0.762 1 5ea3 4000-0466 12/31/00 109022 $0.76062 $ 82924.14 9.100.0 0.74319 $ 6 763.01 144171 $0.760 2 Month End 12131/00 51.225 57 797 $0.76062 $ 43 961.50 5ea3 400 1-0009 01/02/01 67236 $0.79578 $ 53505.16 9.439 1.01109 $ 9 543.66 153610 $0.795 8 5 882702 01/03/01 68 436 $0.80087 $ 54 808.58 1.200.2 1.08600 $ I 303.42 154811 $0.800 7 5 882703 01/10/01 69 438 $0.80426 $ 55 846.65 1.002.0 1.03600 $ I 038.07 155813 5 882704 01/17/01 70 440 $0.80742 $ 56874.70 1002.0 1.02600 $ 1 028.05 156815 $0.807 2 5ea3 01/05/01 79 540 $0.83072 $ 66075.60 9100 1.01109 $ 9200.90 165915 $0.830 2 5ea3 4001-0111 01/17/01 88 936 $0.84977 $ 75575.78 9396 1.01109 $ 9500.18 175311 $0.849 7 5 534317 01/24/01 90 137 $0.85172 $ 76771.88 1200.9 0.99600 $ 1196.10 176511 $0.851 2 5ea3 4001-0243 01/29/01 120711 $0.88607 $ 106 958.39 30 574 0.98733 $ 30186.51 207085 $0.886 7 Month End 01/31/01 64,645 56,066 $0.88607 $ 49 678.49 5 882705 02/14/01 57267 $0.88460 $ 50658.18 1200.6 0.81600 $ 979.69 208 286 $0.884 0 5ea3 4001-0336 02/14/01 85 978 $0.84375 $ 72543.72 28711 0.76227 $ 21 885.54 236997 $0.843 5 5 882706 02/28/01 86 999 $0.84295 $ 73336.17 1 02 1.2 0.77600 $ 792.45 238018 $0.842 5 Month End 02128/01 48121 38 878 $0.84295 $ 32 772.37 Sea3 4001-0439 03/08/0 I 57756 $0.78845 $ 45537.94 18.878 0.67621 $ 12 765.57 256 896 $0.788 5 5ea3 03/26/0 I 67195 $0.77269 $ 51 920.73 9.439 0.67621 $ 6 382.79 266 335 $0.772 9 5ea3 03/28/01 77 112 $0.76028 $ 58 626.74 9.917 0.67621 $ 6 706.02 276 252 $0.760 8 5 882707 03/0710 I 77 763 $0.75999 $ 59099.51 651.2 0.72600 $ 472.77 276 903 $0.759 9 5 882708 03/21/01 79267 $0.75897 $ 60160.99 1503.5 0.70600 $ 1061.47 278 407 $0.758 7 5ea3 ad ustment 79 267 $0.75200 $ 59608.19 N/A N/A $ (552.80 278 407 $0.752 0 Month End 03/31/01 48 369 30.897 $0.75200 $ 23 234.56 Total Gallons Max Inv. Gal. Total Gallons Withdrawn 300 833 112.015 Delivered 278 407 $ 223 957.07 Pounds ner Gal 3.696 Max Pounds 99 414,007.44 0.80442 WACOG (FY01) CSW:04/13/01 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Enerav CharaelTherm Non-Fuel Energy Charge Energy Conservation Adj. (ECA) Environmental Imposition Adj. (EIA) Weather Normalization Adj. (WNA) Total Non-Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelTherm Minimum Monthly Bill Compares to LP/Gallon Rate of with 6.0% Franchise Change from 10/99 Therm Rate % Change from 10/99 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/01/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR MAY 1, 2001 . SEPTEMBER 30,2001 BASED ON APPROVED GAS ADJUSTMENT FACTORS ~ SMF MMF LMF NA (1 - NA (4 + NA (4 + NA (4 + 3 Units) Units) Units) Units) $7.00 $15.00 $20.00 $50.00 $0.580 $0.580 $0.580 $0.580 0.120 0.120 0.120 0.120 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 0.000 Firm Natural Gas Rate Schedules SGS MGS LGS RAC GAC LAC o - 18,000- 17,999 99,999 $15.00 $20.00 100,000 &up $50.00 $0.350 NA(1- NA(O- NA(150 3 Units) 149 tons) tons & +) $7.00 if $15.00 if $15.00 if not prevo not prevo not prevo billed billed billed $0.200 $0.150 $0.100 $0.470 $0.410 0.120 0.120 0.120 0.120 0.000 0.000 0.000 0.000 0.000 NA 0.120 NA 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.120 0.120 $0.700 $0.700 $0.700 $0.700 $0.590 $0.530 $0.470 $0.320 $0.270 ~ SL w/M& NGV Reliaht NA NA NA $15.00 $15.00 $7 Resl./ $15 GS if not prev. billed $0.300 $0.100 Interr. NG Rate NSS ~ NA 100,000 &up $25.00 $100.00 $0.470 $0.280 $0.220 $0.320 $0.420 $0.220 $0.590 $0.280 $1.580 $1.580 0.880 0.880 0.880 0.880 0.880 0.880 0.880 0.880 0.880 $1.100 0.880 0.880 0.880 0.880 0.880 0.795 $1.470 $1.075 $1.580 $1.580 $7.00 $15.00 $20.00 $50.00 $1.470 $1.410 $1.350 $50.00 $1.200 $1.150 $7.00@ $15.00@ $15.00 @ premise premise premise $0.200 0.120 0.120 0.120 $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.446 $ 1.446 $ 1.446 $ 1.446 $ 1.345 $ 1.290 $ 1.235 $ 1.098 $ 1.052 $ 1.007 $ 1.098 $ 1.190 $ 1.007 $ 1.345 $ 0.984 $ 1.532 $ 1.532 $ 1.532 $ 1.532 $ 1.426 $ 1.368 $ 1.309 $ 1.164 $ 1.115 $ 1.067 $ 1.164 $ 1.261 $ 1.067 $ 1.426 $ 1.043 $15.00 $20.00 $1.200 $1.300 $1.100 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.515 $ 0.485 48.4% 48.4% 48.4% 48.4% 53.9% 57.5% 61.7% 75.2% 81.1% 88.0% 75.2% 65.6% 88.0% 53.9% 82.2% $0.069 $0.069 $0.069 $0.069 $0.811 $0.811 $0.811 $0.811 BTU FACTOR = THERMS/100 CUBIC FEET rCCF) Firm Service Rates Interruptible Service Rates 10/00 11/00 12/00 01/01 1.049 1.050 1.054 1.059 $0.069 $0.069 $0.811 $0.811 02/01 03/01 $0.069 $0.811 1.077 1.056 $0.069 $0.069 $0.069 $15.00 +FAC $15.00 $7 Resl./ +FAC $15GS@ premise + FAC $0.069 $0.069 $0.069 $0.069 $0.055 Attachment #4 Contract NG Rate CNS NA By Contract - 1.028 1.030 1.033 1.039 1.081 1.084 $0.811 $0.811 $0.811 $0.811 $0.811 $0.811 $0.811 $0.740 08/01 09/01 By Contract NA NA 0.000 Contract + $0.000 Plus 0.795 $0.795 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms - $ 0.485 156.5% $0.069 $0.726 1.060 1.063 04/01 05/01 06/01 07/01 1.074 1.053 Change from 10/99 Gallon Rate % Change from 10/99 Gallon Rate $ 0.306 15.2% $ 0.306 15.2% $ 0.306 37.6% $ 0.306 40.1% $ 0.306 42.9% $ 0.306 30.5% $ 0.260 47.3% CSW:04/13/01 ,J BTU Factor: BTU Factor: Therm Factor: Attachment #5 Page 2 of 2 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR MAY 1, 2001 - SEPTEMBER 30,2001 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL LP SERVICE WILL CALL SPLASH. PREPAID COMMERCIAL CONTRACT BRLP1 BRLP2 BRLP3 BRLP4 BRWCLP BRWCLP BRSPLP1 BRSPLP1 BRSPLP2 BRSPLP2 BCLP1 BCLP2 CLP Applicable Annual Gallon Range 0-60 60.1 -120 120.1 - 300 > 300 0-300 > 300 o -200 > 200 o - 400 >400 o - 2500 > 2500 NA or Other Rate Determinant -3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNIT 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS . " Annual Customer Charge $ 84.00 $ 60.00 $ 48.00 $ 36.00 $ 36.00 NA $ 36.00 NA $ 36.00 NA $ 60.00 $ 60.00 Set by contract Non-Fuel Enerav Charaes/Gallon: Non-Fuel Energy Charge/Gallon $ 1.300 $ 1.150 $ 0.700 $ 0.600 $ 0.700 $ 0.600 $ 0.600 $ 0.500 $ 0.500 $ 0.500 $ 0.200 $ 0.150 Set By Contract Energy Conservation Adj.lGallon 0.110 0.110 0.110 0.110 0.110 0.110 0.110 0.110 0.110 0.110 0.110 0.110 NA . Environm'llmposition Adj.lGallon NA Weather Normalization Adj.lGallon 0.000 Total Non-Fuel Charges/Gallon $ 1.410 $ 1.260 $ 0.810 $ 0.710 $ 0.810 $ 0.710 $ 0.710 $ 0.610 $ 0.610 $ 0.610 $ 0.310 $ 0.260 Set By Contract + 0.000 Purchased Gas Adjustment/Gallon 0.810 0.810 0.810 0.810 0.810 0.810 0.810 0.810 0.810 0.810 0.810 0.810 0.810 _ Total Energy Charges/Gallon $ 2.220 $ 2.070 $ 1.620 $ 1.520 $ 1.620 $ 1.520 $ 1.520 $ 1.420 $ 1.420 $ 1.420 $ 1.120 $ 1.070 0.810 + Contract NFE Note: No Monthly Minimum Bill Utilitv Tax Note: Fuel Rate per Therm 10/01/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm 0.649 0.649 0.649 0.649 0.649 0.649 0.649 0.649 0.649 0.649 0.649 0.649 0.649 Change from 10/99 Gallon Rate $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.306 $ 0.260 % Change from 10/99 Gallon Rate 16.0% 17.3% 23.3% 25.2% 0 0 0