Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2001
'I. I , R-c~-'n ffrr-'D , ' g""" \ !'"J':~ \.' J' ~t'" ? ,,,,,- !. L-.G l """," CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet !JUL 2 7 2001 CITY CLERK DEPARTMENT TO: FROM: William B. Horne II, City Manager Chuck Warrington, Managing Director, SBS ; COPIES: Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2001 DATE: July 27, 2001 Natural and Propane (LP) Gas supply prices have continued to fall somewhat, though natural gas remains above historical seasonal levels. Most forecasters see natural gas remaining at at least 50% above the historic rates for the next few years. Therefore, we are recommending an additional 7% reduction in our Natural Gas Purchased Gas Adjustment (PGA) and an additional 13% reduction in our Propane (LP) PGA in August. We believe that we are at about the bottom of the fuel cost curve for the summer. We are recommending a decrease in our Natural Gas PGA of 5.0C per therm and a decrease in our LP PGA of 9.0C per gallon. We are also recommending an increase in our Energy Conservation Adjustment of 2.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 August 1, 2001: Natural Gas Firm Standard Rate Schedule PGA ,...... $0.630 per therm (down 5.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.545 per therm (down 5.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.580 per gallon (down 9.0C/gallon) = $0.634 per therm equivalent (down 9.8C/therm) Energy Conservation Adjustment (ECA) ............... $0.180 per therm (up 2.0C/therm) = $0.165 per gallon of LP (up 1.9C/gallon) 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) ,2/~/O~~02 ) , ' William B. Horne II, City Marlager Page 2 I June 27, 2001 Attachment #1 shows the current status of our Adjustment Recovery Clause balances with actuals thru June and projections for the remainder of the fiscal year. These show that our Natural Gas PGA is positive by over $460,000. You will also note that our overall status for all Adjustment Clauses is currently about + $60,000; therefore, we have finally gone positive on this balance. This is important to our overall financials, as this has negatively impacted us FYTD. 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 26% reduction from our peak winter rates (24% lower for LP), but this is still an 7% increase in their therm rate above last August for natural gas (8% lower for LP). This means that our average customer will likely pay an overall bill of $2.88/month higher this year ($3.88 lower 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 nearly 20% 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, 2'001, 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 August 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: ~..~.. ~ illiam B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for August 2001.doc CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Paae 1 of 3 I 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) Firm/Contr Prior Year $ - $ (151,708.91) Oct-OO $ 834,888.83 $ 673,430.37 $ 758.54 $ 14,229.04 (1 ) $ 1,523,306.78 $ 706,640.96 $ (816,665.82) $ (968,374.73) .600f.510 Nov-OO $ 151,759.51 $ 815,334.89 $ 4,841.87 $ 12,133.08 $ 984,069.35 $ 854,699.34 $ (129,370.01 ) $ (1 ,097,744.75) .6301.537 Dec-OO $ 160,913.04 $ 1,274,692.54 $ 5,488.72 $ 15,526.84 $ 1,456,621.14 $ 1,309,920.12 $ (146,701.02) $ (1,244,445.77) .7401.650 Jan-01 $ 160,406.07 $ 2,153,259.49 $ 6,222.23 $ 15,767.57 $ 2,335,655.36 $ 2,624,583.77 $ 288,928.41 $ (955,517.36) 1.200/1.110 Feb-01 $ 145,835.14 $ 2,128,738.39 $ 4,777.59 $ 20,324.55 $ 2,299,675.67 $ 2,438,289.82 $ 138,614.15 $ (816,903.21) 1 .200f1.11 0 Mar-01 $ 158,346.66 $ 1,290,216.23 $ 4,084.52 $ 34,890.00 $ 1,487,537.41 $ 1,809,487.89 $ 321,95Q.48 $ (494,952.73) 1.200f1.110 Apr-01 $ 151,668.91 $ 910,013.55 $ 2,474.77 $ 16,772.27 $ 1,080,929.50 $ 1,657,081.16 $ 576,151.66 $ 81,198.93 .980f.895 May-01 $ 70,055.61 $ 918,278.97 $ - $ 22,038.49 $ 1,010,373.07 $ 1,189,850.14 $ 179,477.07 $ 260,676.00 .8801.795 Jun-01 $ 55,908.41 $ 701,211.72 $ - $ 24,458.25 $ 781,578.38 $ 987,016.07 $ 205,437.69 $ 466,113.69 .78~5 Jul-01 $ 60,000.00 $ 675,000.00 $ - $ 25,000.00 $ 760,000.00 $ 880,600.00 $ 120,600.00 $ 586,713.69 .6801.595 Sep-01 $ 70,000.00 $ 700,000.00 $ - $ 25,000.00 $ 795,000.00 $ 810,600.00 $ 15,600.00 $ 652,913.69 .630f.545 Sep-01 $ - $ - $ 652,913.69 Total YTD $2,079,782.18 $ 12,915,176.15 $ 28,648.25 $ 251,140.09 $ 15,274,746.67 $ 16,079,369.27 $ 804,622.60 (1 ) Includes annual charge for Admin and CCS chg of $717,520 ~- (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 ThermlGal. 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 ) $ 45,323.29 $ 23,505.82 $ (21,817.47) $ (30,326.93) .874/.800 Nov-OO 26,242.3 $ 0.74479 $ 151.63 $ 19,545.00 $ 19,696.63 $ 21,574.47 $ 1,877.84 $ (28,449.09) .929/.850 Dec-OO 63,591.0 $ 0.76062 $ 142.25 $ 48,368.59 $ 48,510.84 $ 54,001.88 $ 5,491.04 $ (22,958.05) .92.9L.a50 Jan-01 58,901.0 $ 0.88607 $ 114.79 $ 52,190.41 $ 52,305.20 $ 55,908.11 $ 3,602.91 $ (19,355.14) 1.093f1.000 Feb-01 54,493.2 $ 0.84295 $ 96.78 $ 45,935.04 $ 46,031.82 $ 57,180.09 $ 11,148.27 $ (8,206.87) 1.202/1.100 Mar-01 44,779.5 $ 0.75200 $ 41.03 $ 33,674.18 $ 33,715.21 $ 49,180.71 $ 15,465.50 $ 7,258.62 1.202/1.100 Apr-01 39,104.6 $ 0.74405 $ - $ 29,095.78 $ 29,095.78 $ 37,917.53 $ 8,821.75 $ 16,080.38 .973f.890 May-01 46,612.5 $ 0.68094 $ - $ 31,740.32 $ 31,740.32 $ 39,352.54 $ 7,612.22 $ 23,692.60 .885/.810 Jun-01 37,016.9 $ 0.64567 $ - $ 23,900.70 $ 23,900.70 $ 27,693.57 $ 3,792.87 $ 27,485.47 .8201.750 Jul-01 39,000.0 $ 0.55000 $ - $ 21,450.00 $ 21,450.00 $ 26,130.00 $ 4,680.00 $ 32,165.47 .732/.670 Sep-01 39,000.0 $ $ $ $ $ $ 34,505.47 I UI~;'I;\,; 0.55000 - 21,450.00 21,450.00 $ 22,620.00 1,170.00 .634f.580 Total YTD 517,722.5 $ 0.71659 $ 589.03 370,995.92 $ 394,669.79 $ 437,684.72 $ 43,014.93 Cost Center Expenses CCS Chg Adj at per 5 fm 6,100 $ 9,000.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 $ 10,000.00 (1 ) LP Truck Lettering I $ 500.00 1(1) HP220 Printer $ 1,004.84 (1 ) Total I $ 23,084.84 CSW:7/27f2001 Page 1 U :lwindowslmsofficelexcellgasf20( sheet recovery) I Attachment #1 Paqe 2 of 3 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,Advelising$1,200Employ CoSls$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 COsls$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.26 $ 82,450.76 $ (855,880.49) .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,409.15) .1101.101 Apr-01 $ 54,061.64 Promo$15,873.95 & Balance Empl. Costs $ 3,972.04 . $ 58,033.68 $ 104,501.27 $ 46,467.59 $ (747,941.56) .1101.101 May-01 $ 68,313.89 Promo$54,461.86 & Balance Empl. Costs $ 3,739.71 $ 72,053.60 $ 88,443.95 $ 16,390.35 $ (731,551.21 ) .1201.1j0 Jun-01 $ 43,287.39 Promo$28,220.08 & Balance Empl. Costs $ 3,657.76 $ 46,945.15 $ 87,202.42 $ 40,257.27 $ (691,293.94) . 14117.128 Jul-01 $ 50,000.00 $ 3,500.00 $ 53,500.00 $ 103,369.32 $ 49,869.32 $ (641,424.62) .1601.146 Sep-01 $ 50,000.00 $ 3,100.00 $ 53,100.00 $ 116,290.49 $ 63,190.49 $ (515,243.65) .1801.165 Total YTD $1,003,304.51 $ 50,203.35 $ 1,053,507.86 $ 1,265,517.58 $ 212,009.72 (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 fEIA) . 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 .O~O Feb-01 $ 4,472.95 $ - $ 4,472.95 $ - $ (4,472.95) $ 288,084.29 .0001.000 Mar-01 $ 15,536.80 Environmental Consultant $ - $ 15,536.80 $ (5.99) $ (15,542.79) $ 272,541.50 .0001.000 Apr-01 $ 3,704.92 $ - $ 3,704.92 $ 0.15 $ (3,704.77) $ 268,836.73 .0001.000 May-01 $ - $ - $ - $ (0.54) $ (0.54) $ 268,836.19 .0001.000 Jun-01 $ 10,343.51 $ - $ 10,343.51 $ - $ (10,343.51 ) $ 258,492.68 .0001.000 Jul-01 $ 2,500.00 $ - $ 2,500.00 $ - $ (2,500.00) $ 255,992.68 .0001.000 Sep-O 1 $ 2,500.00 $ - $ 2,500.00 $ - $ (2,500.00) $ 250,992.68 .0001.000 Sep-OO $ - $ - $ 250,992.68 Total YTD $ 103,635.65 $ - $ 103,635.65 $ (77.27) $ (103,712.92) (1 ) Includes annual admin & CCS charges of $60,000 I I CSW: 7/27/200 1 Pa e2 IAttachment #1 I Paqe 3 o~ 3 I 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 ) $ 2,103,596.10 $ 798,623.27 $(1,304,972.83) $(1,837,738.97) .710/.984 Nov-OO $ 1,027,842.55 $ 956,135.30 $ (71,707.25) $ (1 ,909,446.22) .740/1.039 Dec-OO $ 1,595,846.27 $ 1,476,058.94 $ (119,787.33) $ (2,029,233.55) .850/1.039 Jan-01 $ 2,430,036.52 $ 2,838,623.56 $ 408,587.04 $ (1 ,620,646.50) 1.310/1.203 Feb-01 $ 2,403,697.94 $ 2,631,438.17 $ 227,740.23 $ (1 ,392,906.28) 1.310/1.312 Mar-01 $ 1,570,091.98 $ 1,953,436.51 $ 383,344.53 $(1,009,561.75) 1.310/1.312 Apr-01 $ 1,171,763.88 $ 1,799,500.11 $ 627,736.23 $ (381,825.52) 1.090/1.083 May-01 $ 1,114,166.99 $ 1,317,646.09 $ 203,479.10 $ (178,346.41) 1.000/1.005 Jun-01 $ 862,767.74 $ 1,101,912.06 $ 239,144.32 $ 60,797.90 .9JIII!M0 Jul-01 $ 837,450.00 $ 1,010,099.32 $ 172,649.32 $ 233,447.22 .840/.892 Sep-01 $ 872,050.00 $ 949,510.49 $ 77,460.49 $ 423,168.19 .810/.814 Total YTD $ 16,826,559.97 $ 17,782,494.30 $ 955,934.33 (1 ) Incl. annual charge for Admin & CCS chg of $1 ,246,520; hence, October monthly shortage was really ($58,452.83) (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,800,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. Ba!. $ - 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: 07/24/01 I CSW:7/27/2001 Page 3 U :lwindowslmsofficelexcellgasf20( sheet recovery) II T1Ifc(fm~ #L- CLEARWATER FYOO-Gl PURCHASED GAS COST PROJECTIONS AS OF . Based on Act1.Ial OTH's Sold 7/17/2001 m-l Contract Capadty FTS-2 Contract Capadty Capadty Rellnquhhments FTS-l Available Capadty m-2 Available Capadty Contract NNTS Per Month Purchased Gas Sold Gas Projected Sold Per Month % 01 Purchased Sold Gas Gas lost (PGA revenoes) ~ Oct-OO Nov-oO Dec-oO Jao-Ol Feb-Ol Mar-Ol Apr-Ol May-Ol Jon-ol JoJ-ol Aog-ol Sep-Ol (ohase III (ohase JIll 232,376 41788 $ 8 725.73 117,803 0 15.500 156,361 137 584 138 000 -0.93% $ 706,640.96 306 570 53 430 $ 5 679.32 177 117 0 22,500 182,883 157 808 156 000 -8.29% $ 854,699.34 316 789 55.211 $ 2,231.00 142,637 0 31000 229,363 198.050 189 000 -6.82% $ 1,309,920.12 316.789 55211 $ 2,313.27 109,062 0 46 500 262,938 245,010 216000 11.77% $ 2,62"l,583.77 286 132 49,868 $ 1.137.17 159,220 0 42.000 176,780 231,985 201 000 1.09% $ 2,438,289.82 316,789 55211 $ 3458.18 170229 0 21,000 201,771 174.851 222 000 2.94% $ 1,809,487.89 306 570 53,430 $ 4 725.77 192,742 0 22.500 167,258 195,830 190 000 5.46% $ 1,657,081.16 144.212 41788 $ 15.292.58 36 386 0 23,250 149,614 158.127 157000 2.95% $ 1,189.850.14 139.560 40 440 $ 28,229.96 51.806 0 22,500 128,194 145,195 140 000 $ 987,016.07 144212 41788 $ 28499.85 49 000 0 23 250 137000 137 000 137 000 144212 41788 $ 28499.85 49 000 0 23 250 137000 137 000 137 000 139 560 40440 $ 18 387.00 36000 0 22 500 144 000 137 000 137000 Total 2,793,771 570,393 ($147.179.68) 1.291,002 o 315,750 2.073, I 62 2,055,440 1.32% ############# FTS-I Reservadon charges m-I Usage Charge FTS-l No-Notice charges m-2 Reservadon charges m-2 Usage Charge Total Commodity charges Monthly Adjustments Fuel Cost (Fuel Retention) FGU Management fee Per Month WACOG Purchased Per Month WACOG Sold Per Month Load Factor Purchased Gas Total Billing From FGU + InfinitE Oct-oO Nov-oO Dec-oO Jan-ol Feb-ol Mar-O I Apr-ol May-Ol Jon-Ol JnI-Ol Aog-ol Sep-Ol (ohase 11\ (nhase III NNTS (nhasellll (ohasellll $ 87.210.71 $ 3,559.00 $ 914.50 $ 32,109.90 $ 2,445.07 $ 782,037.13 $ $ 24, 175.79 $ 5,312.30 $ 5.7S 5 5.47 57.03% $ 899,405.96 $ 115,055.72 $ 3,041.07 $ 1,327.50 $ 41,055.61 $ 3,621.31 $ 969.703.64 $ 337.40 $ 26,091.53 $ 6,065.18 $ 6.13 $ 7.16 50.80% $1,121,463.15 $ 118,890.91 $ 2,642.15 $ 1,829.00 $ 42,424.13 $ 5.247.77 $ 1,922,501.93 $ 73.81 $ 40,734.95 $ 6,916.03 $ 9.08 $ 11.44 61.66% $2,083,414.97 $ 117,750.47 $ 6,159.37 $ 2,743.50 $ 42,225.37 $ 3454.95 $ 2.441 057.67 $ 158.87 $ 53,507.83 $ 7887.88 $ 9.89 $ 9.27 70.68% $2.601,463.73 $ 106355.26 $ 6 149.73 $ 2,478.00 $ 38,139.05 $ 929.76 $ 1,500.768.02 $ (t 5.092.87 $ 34,291.33 $ 6 3t 5.91 $ 9.31 $ 10.24 52.61% $1,646,603.16 $ I 17,750.47 $ 6.110.78 $ 1,829.00 $ 42.225.37 $ 1.383.36 $ 995,559.07 $ 175.75 $ 22,520.41 $ 6,316.89 $ 5.72 $ 8.21 54.24% 51,153,905.73 $ 113,952.07 $ I 877.56 $ I 579.35 $ 40,863.26 $ 1,605.22 $ 892,883.92 $ $ 20,471.50 $ 5 607.07 $ 6.24 $ 7.11 46.46% $1~98 $ 53.603.60 $ 2,537.51 $ 731.60 $ 31,098.63 $ 948.72 $ 728,21 I .23 $ 85.64 $ 17,526.43 $ 5,096.82 $ 5.34 $ 6.60 80.44% $798,352.48 $ 51,874.45 $ 1,567.15 $ 619.50 $ 30,021.66 5 1,057.26 $ 588 865.75 $ 859.01 $ 13,794.06 $ 4,902.64 $ 5.02 $ - 71.22% $643,151.40 $ 53 603.60 $ 2621.51 $ 640.15 $ 31 959.46 $ 743.83 $ 642899.78 $ $ 4 858.09 $ 5.11 $ 73.66% $700,603.14 $ 53 603.60 $ 2621.51 $ 640.15 $ 31 959.46 $ 743.83 $ 654611.66 $ $ 4 858.09 $ 5.20 $ - 77.42% $712,315.02 $ 51 874.45 $ 2944.11 $ 619.50 $ 30928.51 $ 719.83 $ 677 519.43 $ $ 5 186.70 $ 5.16 $ 77.22% $742554.89 $1,041,525.32 541,831.46 $15,951.75 $435,010.42 $22,900.90 $12,796,619.22 ($14,072.79) $253,113.83 $69,323.60 $6.824 64.45% $14,147,534.62 Average Total Projected DTH WACOG Total ReselVadoo Total Commodi Cost Purchased In 6 Months $888,769.81 $8,617,486.89 $9,506,256.70 1,210,096 $7.856 2nd 6 Months $456,538.01 $4,184,739.91 $4,641,277.92 863,066 $5.378 TOTAL $1,345,307.82 $12,802,226.80 514,147:534.62 2,073,162 $6.82 Purchased Wacog FYO 1 Budget 2078 10,500,000.00 PO amount 3,647,534.62 over budget I Note, Volumes are based on historkal usage and expected weather. FGT transportation and fuel rates are based on actual approved gas taliff rates. These numbers represent a best look fOlWard based on current data. I F,ISUPPL Y\WACOG 2001."" Propane Inventory and Weighted Cost of Gas (WACOG) 7/2012001 A f1 Acl+m ",,"I' .... .3 LP Supplied by: Sea.3 of Florida Suburban Propane I I Gallons Propane Propane Shipping Total FYTD Cost of Tank Tank WACOG Date ComDanv Invoice" Delivered Rate Cost Cost Cost Gallons Invento"' Invento"' W~hdrawl 09/30/00 $ 38,173.59 53,324 28,532 0.71588 10/01/00 Tex 25164 9104.0 0.76877 $ 7017.08 Is 7017.08 9104.0 $ 45 190.57 62,428 . 0.72388 10103100 5 882639 2 003.7 0.78400 $ 1 570.90 I. 1 570.90 11107.7 $ 46 761.57 64 432 0.72575 10104/00 5 882640 1890.5 0.78400 $ 1482.15 I. 1482.15 12998.2 $ 48243.72 66 322 0.72741 1 0106100 5 882641 1 877.4 0.78400 $ 1 315.08 $ 1315.08 14675.6 $ 49556.81 68 000 0.72881 10110/00 5 882642 2139.8 0.77400 $ 1 656.05 S 1 658.05 18815.2 $ 51 214.86 70139 0.73019 10/11/00 5 882643 2384.2 0.77400 $ 1 845.37 1 845.37 19199.4 $ 53 060.23 72 523 0.73163 10113/00 5 882644 1789.8 0.80400 1 439.00 1 439.00 20 9892 $ 5449923 74313 0.73337 10117/00 5 882645 2158.0 0.81400 $ 1756.81 1756.81 231472 , 56 255.84 76471 0.73565 10/18/00 5 882646 1768.1 0.81400 $ 1437.61 1437.81 24913.3 $ 57693.44 78237 0.73742 10/23/00 5 882647 2289.1 0.77400 $ 1 771.76 1 771.78 27,202.4 $ 59465.21 80 526 0.73846 10/24/00 5 882648 2081.2 0.77400 $ 1810.85 $ 1610.65 29 '93.6 61 076.06 82 008 0.73935 1 0/25/00 5 882649 2 209.3 0.77400 $ 1710.00 S 1710.00 31 492.9 $ B2 786.05 B4817 0.74025 10/27/00 5 882850 1954.2 0.77400 I . 1512.55 . 1512.55 33447.1 . 64298.61 86771 0.74101 10/31/00 5 882851 2070.1 0.78400 I . 1581.56 1581.58 355172 65 880.16 88841 0.74155 10131/00 5..3 4000-0270 18 878.0 0.71350 I . 13538.74 327.68 13868.42 543952 79 746.58 107719 0.74032 10/31/00 End of month $ 50,321.06 67,972 39,747 0.74032 11/01/00 5 882652 2 030.4 0.79400 I. 155123 I. 155123 58 425.8 $ 51 872.29 70 003 0.74101 11/07100 5 682653 2183.8 0.75400 I. 1 848.59 i. 1 646.59 58 009.4 $ 53518.87 72.186 0.74140 11/13/00 5 882654 2315.6 0.74400 i$ 1722.81 I, 1722.81 00 925.0 55241.68 74502 0.74148 11/14/00 5 882655 1891.5 0.75400 I. 1426.19 $ 1.428.19 62 816.5 $ 56667.87 76 394 0.74179 11/15/00 5 882658 1518.4 0.76400 $ 1160.06 I. 1160.08 64 334.9 57827.93 77912 0.74222 11/16/00 5 882657 1001.1 0.76900 $ 1 263.27 I, 1 29327 65 936.0 $ 59091.19 79513 0.74316 11/21/00 5 882658 1215.9 0.80400 $ 977.56 Is 977.56 07151.9 I. 60 088.78 80.729 0.74408 11/21/00 5 882659 2314.5 0.80400 $ 1 660.86 $ 1 860.88 69 466.4 I, 61 929.64 83 043 0.74575 11/27/00 5 882660 2132.6 0.60400 $ 1714.81 1714.61 71.599.0 $ 83 644.25 65 176 0.74721 11/27/00 Sea3 4000-0353 18 733.0 0.70941 , 12940.56 $ 348.78 13 '69.34 90 332.0 $ 76 933.59 103.909 0.74039 11/28/00 5 882661 1782.5 0.80400 $ 1433.13 1433.13 92114.5 1$ 78366.72 105 692 0.74147 11/28/00 5 862662 1729.9 0.80400 1 390.84 1 390.84 93 844.4 I, 79757.56 107421 0.74247 11/29/00 5 882663 2.256.5 0.80400 181423 1814.23 96100.9 I. 81571.78 109 678 0.74374 11/30100 5 882664 2337.3 0.79400 S 1 855.62 S 1 655.62 96 438.2 $ 83427.00 112015 0.74479 11/30/00 End of month S 471136.99 63,289 48,726 0.74479 12/02100 5 882665 1760.7 0.79400 1 398.00 . 1 398.00 100 196.9 S 48 534.99 65 050 0.74612 12/04100 5 882666 2076.1 0.79400 1850.01 . 1850.01 102 '77.0 S 50165.00 67128 0.74760 12105/00 5 882667 2 352.8 0.80400 1691.65 . 1691.65 104 629.6 $ 52078.65 89481 0.74951 12106100 5 882868 19992 0.80400 1 007.36 S 1 007.36 106629.0 . 53 684.01 71400 0.75104 12107/00 5 882669 2 ??9.9 0.84400 1 882.04 S 1 882.04 106658.9 S 55566.04 73710 0.75385 121091OO 5 862670 2281.6 0.88400 1971.30 S 1971.30 111140.5 . 57 "37.34 75 992 0.75715 12/12100 5 882699 1943.0 0.89600 S 1 740.93 . 1 740.93 113083.5 . 59 27827 77935 0.76062 12/13/00 5 882700 2152.7 0.89600 I . 1 928.62 $ 1 928.62 115 '362 . 81 '07.09 00 087 0.76426 12/18/00 5..3 4000-0434 18935 0.74319 I . 1364728 . 350.07 . 13997.95 134 0712 75 205.04 96 922 0.76024 12120100 882701 1000.1 0.95BOO I . 958.10 . 958.10 135 071.3 76161.14 99 922 0.76220 12/31/00 Sea3 4000-0488 9100.0 0.74319 I . 6 593.59 S 169.42 S 6 763.01 144171.3 62 924.15 109022 0.76062 12/31/00 End of month $ 43,9G1.60 67,797 51,225 0.76062 01102101 Sea3 4001.0009 9439 1.01109 9367.92 $ 175.74 9543.68 153 610.3 $ 53505.16 67'36 0.79578 01103101 5 682702 1200.2 1.06BOO 1 303.42 1 303.42 154 610.5 S 54 808.56 68 437 0.80087 01/10101 5 882703 1002.0 1.03600 1 036.07 1 038.07 155 812.5 55646.65 69439 0.80428 01/17/01 5 882704 1002.0 1.02BOO 1 028.05 $ 1 028.05 158 814.5 S 56874.70 70441 0.80741 01105/01 Sea3 4001-0508 9100 1.01109 9031.48 $ 169.42 9200.90 165 914.5 68 075.60 79541 0.83072 01/17101 5..3 4001.0111 9396 1.01109 $ 9 32525 $ 174.93 9500.18 175310.5 75575.78 88 937 0.84977 01/24/01 5 534317 1200.9 0.99600 , 1196.10 1196.10 178<11.4 $ 78771.88 90137 0.85172 01/29101 Sea3 4001.0243 30574 0.98733 S 2961729 $ 569.22 30 188.51 207 085.4 $ 108 958.39 120711 0.88607 01/31/01 End of month $ 49,678.49 56,066 64,645 0.88607 02/14/01 5 882705 1200.6 0.81000 $ 979.69 979.69 208 '86.0 I . 50 658.18 57 '87.0 0.88460 02/14/01 Sea3 4001-0338 28711 0.76227 21 885.54 21 885.54 236 997.0 $ 72 543.72 B5 978.0 0.84375 02126/01 5 882706 1021.2 0.77600 $ 792.45 I. 792.45 236 0182 I $ 73336.17 86 9992 0.84295 02/28101 236,0182 $ 32,772.37 38,878 48,121 0.84295 03106/01 Seal 4001-0439 18878 0.67621 12417.39 I . 348.18 $ 12786.57 258 8962 45537.94 57758.2 0.78845 03126/01 Seal 4001.0508 9439 0.87621 6.208.70 I . 174.09 I . 8382.79 268 3352 51 920.73 ff1195.2 0.77269 03/26/01 Seal 4001-0508 9917 0.87621 8523.11 I . 182.911. 8 708.02 278 "22 58628.74 77112.2 0.76028 03107/01 5 882707 651.2 0.72600 472.77 $ 472.77 278 903.4 59099.51 77 783.4 0.75999 03121/01 5 862708 1503.5 0.70600 1061.47 I. 1081.47 278406.9 00 160.98 79 '68.9 0.75897 Ad! 4001.0439 N/A NlA $ 552.00 $ 1552.00 278 408.9 59808.18 79 268.9 0.75200 03/31/01 End of month $ 23,234.56 30,897 48,369 0.75200 04118101 5..3 4001-0508 NlA NlA $ 1109.87 $ 1109.87 278 406.9 I . 24 344.43 30 897.4 0.78791 04/16/01 Seal 44324 NlA NlA $ 179.79 I. 1179.79 278406.9 $ 24 164.84 30 897.4 0.78209 04/16/01 5..3 4001.0243 NlA NlA 113.83 $ 13.63 278408.9 I , 24151.01 30 897.4 0.78165 04/16/01 Seal 4001-0566 19228 0.68381 12788.58 $ 354.00 $ 13143.18 297 632.9 $ 3i294.17 50 123.4 0.74405 04130101 End of month S 6,157.30 8,275 41,848 0.74405 05102101 5..3 4001-0813 19925 0.65201 $ 12 B23.B8 I . 367.49 $ 12 991.37 317.557.9 S 19148.67 28 200.4 0.67902 05108I01 Seal 4001-0243 $ 193.42 193.42 317557.9 $ 19 342.09 28 '00.4 0.68588 05110101 Sea3 4001-0835 10008 0.65201 $ 8 339.50 S 184.55 S 6 524.05 327'""'.9 $ 25 886.14 38 206.4 0.67701 05121101 Ad' 4001-0508 N/A NlA S 169.41 $ 189.41 327 563.9 S 26 035.55 38'208.4 0.68144 05121101 Ad' 4001-0338 NlA NlA 1$ $ 534.53 $ 534.53 327563.9 $ 26 570.08 38 '08.4 0.69543 05121101 Sea3 4001.0882 19140 0.65201 I $ 12 126.53 , 353.03 $ 12479.56 348703.9 39049.84 57 346.4 0.68094 05/31/01 End of moath $ 12,010.75 17,638 39,708 0.68094 06101/01 Sea3 I 19718 0.81411 S 11745.42 S 363.07 I. 12 109.09 388 421.9 $ 24 119.65 37356.4 0.64567 06130101 End of month $ 3,599.30 5,729 31,527 0.64567 07/03101 Sea3 4001-0612 57 993 $ 27895.72 $ 1069.61 28765.33 424414.9 $ 32484.63 63722.4 0.50947 I FYTO Totals .327564 0.82704 $ 265 930.36 $ 4.626.63 $ 270 909.02 Page 1 of 1 CSW:07/24/01 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Enerov CharoelTherm 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 10101/73 Non-Utility Taxable FuellTherm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR AUGUST 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.180 0.180 0.180 0.180 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 $0.760 $0.760 $0.760 $0.760 0.630 0.630 0.630 0.630 $1.390 $1.390 $1.390 $1.390 $7.00 $20.00 $50.00 $15.00 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 0.180 0.180 0.000 0.000 0.000 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 ~ SL w/M& NGV Relioht NA NA NA $15.00 $0.200 $1.010 $15.00 + FAC $15.00 $7 Resl.! $15GS if not prevo billed $0.300 $0.100 0.180 0.180 0.180 Interr. NG Rate NSS ---1L NA 100,000 & up $25.00 $100.00 $0.470 $0.280 0.180 0.180 0.000 0.000 0.000 0.000 0.000 0.000 0.000 NA 0.180 NA 0.180 0.180 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 $0.380 $0.330 $0.280 $0.380 $0.480 $0.280 $0.650 $0.280 $1.010 $0.910 . 0.630 0.630 0.630 0.630 0.630 0.630 0.630 0.545 $1.280 $0.825 $0.960 $7.00@ $15.00@ $15.00@ premise premise premise $0.069 $0.069 $0.069 $0.470 $0.410 0.000 0.000 0.000 $1.110 $0.910 $15.00 $7 Resl.! +FAC $15GS@ premise + FAC $25.00 $100.00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo. $ 1.272 $ 1.272 $ 1.272 $ 1.272 $ 1.171 $ 1.116 $ 1.061 $ 0.924 $ 0.878 $ 0.833 $ 0.924 $ 1.016 $ 0.833 $ 1.171 $ 0.755 $ 1.348 $ 1.348 $ 1.348 $ 1.348 $ 1.241 $ 1.183 $ 1.125 $ 0.980 $ 0.931 $ 0.883 $ 0.980 $ 1.077 $ 0.883 $ 1.241 $ 0.800 $0.650 $0.590 $0.530 $1.280 $1.220 0.630 0.630 0.630 $1.160 $15.00 $20.00 $50.00 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.325 $ 0.235 30.5% 30.5% 30.5% 30.5% 34.0% 36.3% 38.9% 47.4% 51.2% 55.6% 47.4% 41.4% 55.6% 34.0% 39.8% $0.069 $0.069 $0.069 $0.069 $0.561 $0.561 $0.561 $0.561 BTU FACTOR = THERMS/100 CUBIC FEET (CCFI 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.561 $0.561 02/01 1.081 1.084 $0.069 $0.561 03/01 $0.561 $0.561 $0.561 $0.069 $0.561 07/01 1.047 $0.069 $0.069 $0.069 $0.055 $0.561 $0.561 $0.561 $0.490 08/01 09/01 Attachment #4 Contract NG Rate ~ NA By Contract - By Contract NA NA 0.000 Contract + $0.000 Plus 0.545 $0.545 + Non-Fuel Customer Charge + Non-Fuel Therm Rate for Contract # of Therms - $ 0.235 75.8% $0.069 $0.476 1.028 1.030 1.033 1.039 1.060 1.063 04/01 05/01 06/01 1.077 1.074 1.073 1.068 1.056 1.053 1.052 1.066 1.045 CSW:07/24/01 Attachment #5 Page 1 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) METERED PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR AUGUST 1, 2001 . SEPTEMBER 30, 2001 BASED ON APPROVED GAS ADJUSTMENT FACTORS Contract LP Svc. RLP MLP GLP LLP LPV LPS CLP Applicable Annual Gallon Range NA NA 0- 2,500 Gallons 2,501 Gallons & Up NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) Monthly Customer Charge $7.00 $15.00 $15.00 $20.00 $7.00 Res!. or $25.00 Set By Contract $15.00 GS if not Non-Fuel Ener~1V Charaes/Gallon: prey. billed @ - premise Non-Fuel Energy Charge IGallon $1.400 $1.400 $0.200 $0.150 $0.100 $0.390 Set By Contract Energy Conservation Adj.lGallon 0.165 0.165 0.165 0.165 0.165 0.165 NA Environm'llmposition Adj. IGallon 0.000 0.000 0.000 0.000 0.000 0.000 NA Weather Normalization Adj.lGallon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Total Non-Fuel Charges/Gallon $1.565 $1.565 $0.365 $0.315 $0.265 $0.555 By Contract + $0.000 Purchased Gas Adjustment/Gallon 0.580 0.580 0.580 0.580 0.580 0.580 0.580 Total Energy Charges/Gallon $2.145 $2.145 $0.945 $0.895 $0.845 $1.135 $0.580 + Contract NFE - Minimum Monthly Bill $7.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. Utility Tax Note: Fuel Rate per Therm 10101/73 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non-Utility Taxable FuellTherm $0.419 $0.419 $0.419 $0.419 $0.419 $0.419 $0.419 Change from 10/99 Gallon Rate % Change from 10/99 Gallon Rate $ 0.131 6.5% $ 0.131 6.5% $ 0.131 16.1% $ 0.131 17.1% $ 0.131 18.3% $ 0.131 13.0% $ 0.030 5.5% CSW:07/24/01 Attachment #5 Page 2 of 2 - . CLEARWATER GAS SYSTEM c. , BTU Factor: 2.714 Gallons/100 cubic feet (CCF) BTU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE (lP) RATE BilliNG FACTORS Therm Factor: 0.915 Therms/Gallon FOR AUGUST 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 o - 300 > 300 o -200 > 200 0-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 UNITS 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 EnerQY 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.165 0.165 0.165 0.165 0.165 0.165 0.165 0.165 0.165 0.165 0.165 0.165 NA Environm'llmposition Adj.lGallon - - - - - - - - - - - - NA Weather Normalization Adj.lGallon - - - - - - - - - - - - 0.000 - Total Non-Fuel Charges/Gallon $ 1.465 $ 1.315 $ 0.865 $ 0.765 $ 0.865 $ 0.765 $ 0.765 $ 0.665 $ 0.665 $ 0.665 $ 0.365 $ 0.315 Set By Contract + 0.000 Purchased Gas AdjustmenUGallon 0.580 0.580 0.580 0.580 0.580 0.580 0.580 0.580 0.580 0.580 0.580 0.580 0.580 - -.' Total Energy Charges/Gallon $ 2.045 $ 1.895 $ 1.445 $ 1.345 $ 1.445 $ 1.345 $ 1.345 $ 1.245 $ 1.245 $ 1.245 $ 0.945 $ 0.895 0.580 + Contract NFE Note: No Monthly Minimum Bill Utility 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.419 0.419 0.419 0.419 0.419 0.419 0.419 0.419 0.419 0.419 0.419 0.419 0.419 Change from 10/99 Gallon Rate $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.131 $ 0.030 % Change from 10/99 Gallon Rate 6.8% 7.4% 10.0% 10.8% 10.0% 10.8% 10.8% 11.8% 11.8% 11.8% 16.1% 17.1% c; C;Of-