Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2003
- 1 1 RECEIVED SEP 2 2 2003 CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet OFFICIAL RECORDS AND LEGISLATIVE SRVCS DEPT TO: FROM: COPIES: William B. Horne II, City Manager \, Chuck Warrington, Managing Director C/}'l) Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Tom Madley, Sr. Accountant/CCS; Laura Damico, Sr. Accountant/CCS SUBJECT: DATE: GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2003 September 16, 2003 It is that time of year when we fully review our adjustment rates and make new projections for the upcoming fiscal year. Natural supply prices have increased somewhat. Therefore, we are recommending an increase of 3C/therm in our Natural Gas Purchased Gas Adjustments (PGA), but Propane (LP) Gas supply prices have been more stable such that we are-recommending a decrease in our LP PGA of 1 C/gallon. We are also recommending an Energy Conservation Adjustment (ECA) of 10C per therm and gallon, which is a reduction of 6C. We are recommending that we continue to not collect any Weather Normalization Adjustment (WNA) due to last winter's weather nor Environmental Imposition Adjustment (EIA) as our balance for this is still positive. The net effect of these recommended changes is a reduction in our typical Residential Natural Gas customer's rate of 3C/therm (down 1.9%) and a reduction in our typical Residential LP customer's rate of 7c/gallon (down 3.7%). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after October 1, 2003: Natural Gas Firm Standard Rate Schedule PGA ....... $0.850 per therm (up 3.0C/therm) Natural Gas Interruptible and Contract (Non-Standard) Rate Schedule PGA ............. $0.780 per therm (up 3.0C/therm) Propane (LP) Gas Rate Schedule PGA .................... $0.930 per gallon (down 1.0C/gallon) Energy Conservation Adjustment (ECA) ............... $0.100 per therm (down 6.0C/therm) & $0.100 per gallon of LP (down 6.0C/gal.) Environmental Imposition Adjustment (EIA) ......... $0.000 per therm (no change) and $0.000 per gallon of LP (no change) ~../--/OJ' 03 Weather Normalization Adjustment (WNA) .......... $0.000 per therm (no change) & $0.000 per gallon of LP (no change) (7) CLEARWATER GAS SYSTEM Attachment #1 SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Pane 1 of 3 . ,- NATURAL GAS PURCHASED GAS ADJUSTMENT tPGA-NG) Monthly Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage RatelTherm Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) Firm/Contr Prior Year $ - $ (631,673,84) Oct-02 $ 1,438,099,75 $ 574,282,78 $ 3,158.37 $ 35,263.36 1 $ 2,050,804,26 $ 749,048,20 $ (1,301,756,06) $(1,933,429,90) ,620/,550 Nov-02 $ 151,855,31 . , 660,060.06 $ 9,667.15 $ 22,705.89 $ 844,288.41 $ 838,391,19 $ (5,897,22) $(1,939,327,12) ,620/,550 Dec-02 $ 212,927,94 $ 935,500,06 $ 9,696,64 $ 30,755.41 2 $ 1,188,880,05 $ 1,167,133,57 $ (21,746.48) $ (1,961 ,073,60) ,620/,550 Jan-03 $ 158,054,13 $ 1,152,723,26 $ 9,805,37 $ 38,475,75 $ 1,359,058,51 $ 1,489,977.76 $ 130,919,25 $ (1 ,830,154,35) ,720/,650 Feb-03 $ 145,103,78 $ 1,322,831,91 $ 9,150,77 $ 32,036,30 $ 1,509,122,76 $ 1,651,291.64 $ 142,168,88 $ (1 ,687,985.47) ,780/,650 Mar-03 $ 157,188,88 $ 1,097,675.80 $ 8,439,93 $ 24,457.96 $ 1,287,762,57 $ 1,443,369,93 $ 155,607,36 $ (1 ,532,378.11) ,820/,750 Apr-03 $ 120,066,70 $ 938,581.42 $ 7,661.89 $ 22,335.62 $ 1,088,645,63 $ 1,244,307,88 $ 155,662.25 $(1,376,715,86) ,820/,750 May-03 $ 75,034,80 $ 886,741.14 $ 6,883,58 $ 39,148,23 $ 1,007,807,75 $ 1,168,016,14 $ 160,208.39 $(1,216,507.47) ,820/,750 Jun-03 $ 64,013,72 $ 775,601.45 $ 6,082.54 $ 21,684,86 $ 867,382,57 $ 978,942,69 $ 111,560,12 $(1,104,947,35) ,820/,700. Jul-03 $ 65,786,61 $ 731,673,02 $ 5,524.74 $ 40,381.01 $ 843,365,38 $ 932,391.13 $ 89,025.75 $(1,015,921,60) ,820/,750 Aug-03 $ 65,779,02 $ 735,490,24 $ 5,079.61 $ 33,606.02 $ 839,954.89 $ 956,809,89 $ 116,855,00 $ (899,066,60) ,820/,750 Sep-03 $ 66,000.00 $ 740,000.00 $ 4,600.00 $ 30,000,00 $ 840,600,00 $ 965,600.00 $ 125,000,00 $ (774,066,60) ,820/,750 Period 13 9 $ 1,123,612.21 $ - $ (1,123,612,21) $(1,897,678.81) Total YTD $ 2,719,910,64 $ 10,551,161,14 $ 85,750.59 $ 370,850.41 $ 14,851,284,99 $ 13,585,280,02 $ (1,266,004,97) (1 ) Includes annual charge for Admin and CCS cho of $1 ,365,580 (2) Includes FY 01/02 Write-off of $54,257,06 & related WNA of $379.77 (9) = Transfer of ECA collected in PGA @ 1/2 of ECA rate (for NG Therms proportion) (3) PROPANE fLPI GAS PURCHASED GAS ADJUSTMENTIPGA-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 $ (21,297.42) Oct-02 34,825,6 $ 0,54105 $ 106.49 $ 18,842.39 1 $ 99,328,30 $ 24,709,85 $ (74,618.45) $ (95,915,87) ,809/,740 Nov-02 28,534.4 $ 0,59308 $ 479,58 $ 16,923.18 $ 17 ,402. 76 $ 20,317,51 $ 2,914,75 $ (93,001,12) ,809/,740 Dec-02 65,721,8 $ 0,60620 $ 465,01 $ 39,840.56 $ 40,305,57 $ 48,157,87 $ 7,852,30 $ (85,148,82) ,809/.740 Jan-03 64,213,9 $ 0,64636 $ 425.74 $ 41,505.30 $ 41,931.04 $ 51,387,03 $ 9,455,99 $ (75,692,82) ,929/,850 Feb-03 47,493,2 $ 0,73646 $ 378.46 $ 34,976,84 $ 35,355,30 $ 40,746,17 $ 5,390,87 $ (70,301,95) ,973/,8~ Mar-03 53,037.1 $ 0,64148 $ 351.51 $ 34,022,24 $ 34,373,75 $ 47,685,57 $ 13,311,82 $ (56,990,13) 1,027/,940 Apr-03 44,430.4 $ 0,63753 $ 284,95 $ 28,325.71 $ 28,610,66 $ 40,052,84 $ 11,442,18 $ (45,547.96) 1,027/,940 May-03 40,418,6 $ 0,64388 $ 227,74 $ 26,024,73 $ 26,252.47 $ 36,841,23 $ 10,588,76 $ (34,959,19) 1,027/,940 Jun-03 34,845,3 $ 0,64688 $ 174.80 $ 22,540,73 $ 22,715,53 $ 31,453,28 $ 8,737,75 $ (26,221.44) 1,0271.940 Jul-03 34,403,5 $ 0,64300 $ 131.11 $ 22,121.45 $ 22,252,56 $ 31,414,37 $ 9,161,81 $ (17,059,63) 1,027/,940 Aug-03 26,477.7 $ 0,64606 $ 85,30 $ 17,106,18 $ 17,191.48 $ 24,984,97 $ 7,793.49 $ (9,266,14) 1,027/.940 Sep-03 26,000,0 $ 0,65000 $ 50,00 $ 16,900.00 $ 16,950,00 $ 23,660,00 $ 6,710,00 $ (2,556,14) 1,0271.940 Period 13 9 $ 26,766,54 $ - $ (26,766,54) $ (29,322,69) Total YTD 500,401.5 $ 0,63775 $ 3,160,69 319,129.31 $ 429,435,96 $ 421,410,69 $ (8,025,27) Cost Center Expenses . CCS Chg & Admin 61,900,00 1 (9) = Transfer of ECA collected in PGA @ 1/2 of ECA rate (for LP Gall Fuel 15,000.00 1 FY 01/02 Write-off of $3,271,96 & related WNA $48.46 3,320.42 1 PC Anywhere software for Suburban program 159,00 1 Total 80,379.42 ~- I . . Attachment #1 Paqe 2 of"3 ENERGY CONSERVATION ADJUSTMENT (ECAl Monthly Cumulative ECA Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $(1,127,315.49) Oct-02 $ 232,922,99 Promo$27,818,Adv $902, Employ Costs$47,673 $ 5,636.58 1 $ 238,559,57 $ 58,434.55 $ (180,125,02) $(1,307,440,51) ,100/,100 Nov-02 $ 80,207,24 Promo$37,675.Adv $1600, Employ Costs$40,932 $ 6,537,20 . $ 86,744.44 $ 67,980.32 $ (18,764,12) $(1,326,204,63) .100/,100 Dec-02 $ 82,103.43 Promo$36,338,Adv $52, Employ Costs$41 ,346 $ 6,631,02 2 $ 88,734.45 $ 106,912.84 $ 18,178.39 $ (1 ,308,026,24) ,100/,100 Jan-03 $ 133,097,30 Promo$66,639,Adv $200, Employ Costs$66,258 $ 6,540,13 $ 139,637.43 $ 150,189,82 $ 10,552.39 $(1,297,473,85) ,120/,120 Feb-03 $ 91,475,98 Promo$45,016,Adv $871, Employ Costs$45,589 $ 6,487,37 $ 97,963.35 $- 159,112.46 $ 61,149.11 $(1,236,324.74) ,120/.120 Mar-03 $ 130,259,30 Promo$82,394,Adv $625, Employ Costs$47,211 $ 6,181,62 $ 136,440.92 $ 155,383,96 $ 18,943,04 $(1,217,381,71 ) ,160/,160 Apr-03 $ 84,117,66 Promo$41 ,370,Adv $0, Employ Costs$42,748 $ 6,086,91 $ 90,204.57 $ 131,473.83 $ 41,269.26 $ (1,176,112.45) ,160/,160 May-03 $ 83,800.83 Promo$41, 178,Adv $630, Employ Costs$41,993 $ 5,880,56 $ 89,681.39 $ 121,577.16 $ 31,895.77 $(1,144,216,68) ,160/.160... ... Jun-03 $ 74,927,13 Promo$35,338,Adv$310, Employ Costs$39,279 $ 5,721,08 $ 80,648.21 $ 91,808,51 $ 11,160,30 $ (1,133,056,38) ,160/,160 Jul-03 $ 103,357,34 Promo$59,795,Adv$413, Employ Costs$43,149 $ 5,665,28 $ 109,022,62 $ 91,366.89 $ (17,655,73) $(1,150,712,11) .160/,160 Aug-03 $ 81,798,82 Promo$19,771,Adv$l,450, Employ Costs$60,578 $ 5,753,56 $ 87,552.38 $ 91,077.67 $ 3,525,29 $(1,147,186.82) .160/.160 Sep-03 $ 90,000,00 $ 5,735,93 . $ 95,735.93 $ 92,544,00 $ (3,191,93) $(1,150,378,76) .160/,160 Period 13 9 $ 1,150,378.76 $ 1,150,378.76 $ - Total YTD $ 1,268,068,02 $ 72,857,26 $ - $ 1,340,925.28 $ 2,468,240.77 $ 1,127,315.49 (1 ) Includes annual charge for Admin and CCS chg of $156,530 (9) = Transfer of ECA collected in PGA @ 1/2 of the ECA rate, (2) Includes FY 01/02 Write-off of $4,367.37 (3) I ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIAl Monthly Cumulative EIA Budaet Cost Center Interest Total EIA Total EIA Overage YTD Overage NGlTherm Month Expenses Notes/Exceptionalltems Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ - $ 219,904,76 Oct-02 $ 12,743,00 $ - 1 $ 12,743,00 $ - $ (12,743,00) $ 207,161,76 ,000/,000 Nov-02 $ 450,65 $ - $ 450.65 $ - $ (450,65) $ 206,711,11 .000/,000 Dec-02 $ 456,97 $ - 2 $ 456.97 $ - $ (456,97) $ 206,254.14 ,OOO/,Oac... Jan-03 $ 433,00 $ - $ 433.00 $ - $ (433,00) $ 205,821,14 .000/,000 Feb-03 $ 17,775,15 $ - $ 17,775.15 $ - $ (17,775,15) $ 188,045,99 ,000/,000 Mar-03 $ 433,00 $ - $ 433.00 $ - $ (433,00) $ 187,612,99 .000/,000 Apr-03 $ 787.00 $ - $ 787.00 $ - $ (787,00) $ 186,825.99 ,000/,000 May-03 $ 2,474,28 $ - $ 2,474.28 $ - $ (2,474,28) $ 184,351,71 ,000/,000 Jun-03 $ 433,00 $ - . $ 433,00 $ - $ (433,00) $ 183,918,71 .000/,000 Jul-03 $ 4,578,17 $ - $ 4,578.17 $ (0,24) $ (4,578.41) $ 179,340,30 ,000/,000 Aug-03 $ 433,00 $ - $ 433.00 $ - $ (433,00) $ 178,907.30 ,000/,000 Sep-03 $ 15,000,00 $ - . $ 15,000.00 $ - $ (15,000.00) $ 163,907,30 ,000/.000 Period 13 $ - $ - $ - $ 163,907,30 Total YTD $ 55,997,22 $ - $ 55,997.22 $ (0,24) $ (55,997.46) (1 ) Includes annual charges for Admin Charge $10,0000 (2) Includes FY 01/02 Write-off of $23.97 I Attachment #1 Pa~e 3 of3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + EIA) Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage NGlTh (Firm Month Expenses Billed (Shortage) (Shortage) LP/Gal Prior Year $ - $ - $ - $(1,560,381,99) Oct-02 $ 2,401,435,12 $ 832,192,60 $ (1,569,242,52) $(3,129,624,51) ,720/,840 Nov-02 $ 948,886,26 $ 926,689,02 $ (22,197.24) $ (3,151,821,76) .720/,840 Dec-02 $ 1,318,377.04 $ 1,322,204,28 $ 3,827,24 $ (3,147,994,52) ,720/,840 Jan-03 $ 1,541,059,98 $ 1,691,554,61 $ 150,494,63 $ (2,997,499.88) .840/,970_ Feb-03 $ 1,660,216,56 $ 1,851,150.27 $ 190,933,71 $ (2,806,566.18) .900/1,010 Mar-03 $ 1,459,010,24 $ 1,646,439.46 $ 187,429,22 $ (2,619,136.96) ,980/1,100 Apr-03 $ 1,208,247,86 $ 1,415,834,55 $ 207,586.69 $ (2,411,550.27) .980/1,100 May-03 $ 1,126,215,89 $ 1,326,434.53 $ 200,218,64 $(2,211,331.63) .980/1.1 Qll. _ Jun-03 $ 971,179.31 $ 1,102,204.48 $ 131,025,17 $ (2,080,306.46) .980/1,100 Jul-03 $ 979,218.73 $ 1,055,172,15 $ 75,953.42 $ (2,004,353.04) .980/1.100 Aug-03 $ 945,131.75 $ 1,072,872.53 $ 127,740.78 $(1,876,612.27) .980/1,100 Sep-03 $ 968,285.93 $ 1,081,804.00 $ 113,518,07 $ (1,763,094.20) .980/1.100 Period 13 $ 1,150,378,76 $ 1,150,378,52 $ (0,24) $(1,763,094.44) .980/1,100 Total YTD $ 16,677,643,45 $ 16,474,931,00 $ (202,712.45) Note: Total of all Admin & CCS Transfer Charges Collected thru Adjustment Clauses = $1,594,010 included in October WEATHER NORMALIZATION (WNA) Monthly Cumulative WNA Budget Interest Overage YTD Overage NGlTherm Month LP Gallons Expense Rate/Gallon NG Therms RatelTherm (Shorta~e) (Shortage) LP/Gal Beg, Bal. $ - $ - Oct-02 34,825.6 $ - $ - 1,382,272,0 $ - $ 190,96 $ 190,96 ,000/,000 Nov-02 28,534.4 $ - $ - 1,537,770,0 $ - $ (77.71) $ 113,25 .000/,000 Dec-02 65,721.8 $ - $ - 2,098,959.0 $ - $ (53,21 ) $ 60,04 .000/.000 Jan-03 64,213,9 $ - $ - 2,335,835,0 $ - $ (16,34) $ 43.70 ,OOO/,OClll.. - Feb-03 47,493,2 $ - $ - 2,471,107,0 $ - $ (17,57) $ 26.13 .000/.000 Mar-03 53,037.1 $ - $ - 2,044,158.0 $ - $ (3,08) $ 23,05 ,000/,000 Apr-03 44,430.4 $ - $ - 1,793,728,0 $ - $ (4,36) $ 18.69 .000/.000 May-03 40,418,6 $ - $ - 1,681,949,0 $ - $ (1.44) $ 17.25 ,000/.000 Jun-03 34,845,3 $ - $ - 1,459,875.0 $ - $ (0.45) $ 16.80 ,000/,000 Jul-03 34,403,5 $ - $ - 1,372,232,0 $ - $ (3,51) $ 13,29 ,000/,000 Aug-03 26,477.7 $ - $ - 1,408,085.0 $ - $ ( 1,12) $ 12.17 ,000/.000 Sep-03 $ (0,06) #D1V/O! #DIV/O! #DIV/O! ,000/,000 Period 13 . Total YTD 474,401.5 (0,06) 19,585,970,0 #DIV/O! #DIV/O! Write Off U:\Mv Documents\EXCEL\GASRATES\FY 02-03\rAdiustment Clause Recoverv for FY 02-03,xlslSheet1 CSW: Updated 09/16/03 IfTr ItG/+/Yl &./lJ"; if- 2-- CGS Natural Gas Cost ActuaUProjections FY04 as of 9/10/2003 ~ Oct-03 1'10'.1-03 Dec-03 Jan-Q4 Fcb-04 Mar-04 Apr-04 Ma'y'--04 Jun-04 Jul-O.1- i\ug-04 Sep-04 Contract Capacity Contract Excess Capacity Relinquishment Purchased Sold Gas Sold Gas Purchased % Sold Gas WACOG FTS-1 FTS-2 No-Nollce Capaclly Volume Cosl Gas Aclual Projected Gas lost tPGA revenues\ Purchased 170.438 41,788 15,500 42,226 21700 $ 10,850,00 170,000 146,000 100.00% $ 5.52 306,570 53 430 22,500 158 000 15,000 $ (2,250.00 202 000 170,000 $ 6,20 316.789 55,211 31,000 124,000 15000\ $ 11,500.00 248,000 202,000 $ 6.26 3'16.789 55,211 46,500 131000 15,000 $ (1,500,001 241,000 248,000 $ 6.36 286,132 49 868 42 000 110000 15,000 $ (1 500,00 226,000 241,000 $ 6.30 316.789 55,211 31,000 173,000 30,000 $ (4,500,00) 199,000 226,000 $ 6.40 216,570 53.430 22,500 106000 20.000) $ 13,000,00) 164 000 199,000 $ 5.87 144,212 41,788 12.400 32,000 15,500 $ 17.750,00 154,000 154,000 $ 559 139,560 40,440 10,500 31,000 36,000 $ 18,000.00 149,000 154,000 $ 5,53 144.212 41 788 10850 36 000 37,200 $ (18600,00 150,000 149,000 $ 5.53 144.212 41.788 10.850 36,000 37200) $ 16.600.00 150,000 150,000 $ 5.50 139,560 40.440 10,500 34.000 27 000 $ 13.500,00 146000 150,000 $ 5.67 Total 2,641,833 570,393 266,100 1,013,226 (284,600) ($101,550,00) 2,199,000 o 2,199,000 100,00% $ $5,96 Oel-03 Nov-03 D(w-03 ,Jan-04 Feb-04 l\;iar-04 Apr-04 ~k;y-04 Jun-04 Jul-04 Aug-04 Sep-04 Reservation charges FTS-1 FTS-1 FTS-2 FGU Load Load Total FTS-1 FTS-2 No-Notice charges Usage Charge Usage Charge Tolal Monll1ly Fuel Cost Management fee Faclor Factor Billing lohase ill lohase IIIl NNTS (ohase Ill' (chase 1I1l' Commodilv charoes Ad'uslments IFuel Retention) Per Month wI RelinQuish w/o RelinQuish IFGU\ $ 63.215.45 $ :n.926.03 $ 914.50 $ 5,423.37 $ 1,057.24 $ 852,781.50 $ $ 23.836.70 $ 10,200.00 89.2% 80.1% 593-(,987.49 $ 113.706.81 $ 40,820.52 $ 1,327,50 $ 8,284.51 $ 1,351.78 $ 1,099,801.80 $ $ 30,813,51 $ 12,120.00 58.6%. 56.1%, $1.253.406.63 $ 117,497.04 S; 42,181.20 $ 1.829.00 $ 8,154.97 $ 1,396,84 $ 1,392,205,14 $ $ 39,042.53 $ 14,880.00 69.5% 66.7% $1,552,212.38 :5 117.497.04 $ 42,181.20 $ 2,743.50 $ 7 858.87 1 396.84 $ 1 371 987.64 $ $ 38 453,33 $ 14.460.00 67.5% 64.8% $1,537,909.38 $ 106.126.36 $ 38.099.15 $ 2,478.00 $ 7.450.38 $ 1,26166 $ 1 278 858.57 $ - $ 35.831.12 $ 13,56000 70.4% 67,3% $1.424.06:'08 $ 117,497.04 $ 42.1tl1.20 $ 1,829.00 $ 6 082,27 $ 1.396.84 $ 1,117,500.80 $ $ 31,297.89 $ 11,940.00 58.2IJit) 53.5% $1,2(4,508.04 $ 80,325.81 $ 40.820.52 $ 1,327.50 $ 4677.11 $ 1.351.78 $ 843707.55 $ $ 24,722.66 $ 9,840.00 65,6% 60.7% S963 ,1 R 1.38 $ G3.--188.23 $ 31,926.03 $ 731,60 $ 4,746.57 $ 1.057.24 $ 781.808,44 $ $ 22.890,44 $ 9,240.00 90.3t% 82.8% $860,204.31 $ 51,762.80 $ 30,896.16 $ 619,50 $ 4 592.09 $ 1.023.13 $ /59,332,02 $ $ 22.230,80 $ 8,940.00 103.5% 82.8% $824,610.49 $ 53.488.23 $ 31,926.03 $ 640.15 $ 4,577.37 $ 1.057.24 $ 762,060.89 $ $ 22,310.29 $ g,OOO.OO 100.8% 60.6% $829,515.31 $ 53.488.23 $ 31,926.03 $ 640.15 $ 4.577.37 $ 1,057.24 $ 757,714,50 $ $ 22,179,90 $ 9,000.00 100.81.'/(1 78,5% $825,168.91 $ 51,762.50 $ 30,896.16 $ 619.50 $ 4,634.39 $ 1023.13 $ 757,582,78 $ $ 22,175,26 $ 9,000.00 95.4% 0.0% $827,361.24 -- Total $979,855,86 $435,780,25 $15.699,90 $69,059,28 $14,430,94 $11,775,341,64 $ $335,784,42 $132,180,00 80,8% 64.5% $13,105,127,65 Total Projected DTH WACOG Total ReselVation Total Commodity Cost Purchased 151 6 Monll1s $861,950,56 $ 7,113,135,45 $7,975,086,01 1,286,000 $6,201 2nd 6 Months $467,835,45 4,662,206,19 $5,130,041,64 913,000 $5.619 TOTAL $1.329,786,01 11,775,341,64 $13,105,127,65 2,199,000 $5,96 Budget 2078 9,890,000,00 PO amount 3,215,127,65 over budget 1,924,160 Other PGA costs ,. Propane Inventory and Weighted Cost of Gas (WACO'-) 9/16/2003 LP Supplied by: Sea-3 of Florida Suburban Propane A Tr i~M'\,(!~;- $3 comoanvl Gallons Propane Propane Shipping Total FyrD Cost of Tank Tank WACOG Date Invoice # Delivered Rate Cost Cost Cost Gallons Inventorv Inventorv Withdrawl I I 1 I I 09/30/02 $ 29,193.34 57,611 0.50673 10/17/02 Resources 200210-8157 27,439 0,59294 $ 16,269,69 Inteorated $ 16,269,69 27,439,0 $ 45,463,03 85,050 0,53454 10/17/02 Sea-3 4002-0737 9,600 0,59533 $ 5,524,51 $ 190,61 $ 5,715,12 37,039,0 $ 51,178,15 94,650 0,54071 10/31/02 inv adiustment 306 0,64605 $ 197,69 _: 51,375,84 94,956 0,54105 10/31/02 End of month 29,968,21 55,389 39,567 0.54105 11/14/02 Resources 200211-8446 90,000 gal call ootion Iil. 2,75ct oremium Dec-Febl $ 2,475,00 $ 32,443,21 55,389 0,58573 11/17/02 Resources 200211-8483 9,133 0,60334 $ 5,510,31 Inteorated $ 5,510,31 46,172,0 $ 37,953,52 64,522 0,58822 11/20/02 Sea-3 4002-0833 18,002 0,60573 $ 10,546,83 $ 357,44 $ 10,904,27 64,174,0 $ 48,857,79 82,524 0,59204 11/21/02 Suburban 612540 2,275,5 0,62600 $ 1,424,46 N/A $ 1,424,46 66,449,5 $ 50,282,25 84,800 0,59295 11/22/02 Suburban 533546 2,022,0 0,63900 $ 1,292,06 N/A $ 1,292,06 68,471,5 $ 51,574,31 86,822 0,59403 11/30102 inv ad'ustment 138 - $ - $ - $ 68,471,5 $ 51,574,31 86,960 0,59308 13/30/02 End of month ii $ 24,074.84 40,593 46,367 0.59308 12/1 0/02 Suburban I 822716 T 2,227 0,64900 $ 1,445,39 N/A $ 1 ,445,39 70,698,6 $ 25,520,23 42,820 0,59599 12/11/02 Suburban I 882717 1 2,015 0,64900 $ 1,307,99 N/A $ 1,307,99 72,714,0 $ 26,828,22 44,835 0,59837 12/12/02 Suburban I 752401 1 2,412 0,66000 $ 1,591,99 N/A $ 1,591,99 75,126,1 $ 28,420,21 47,247 0,60152 12/13/02 Suburban 882718 1,607 0,64900 $ 1,043,07 N/A $ 1,043,07 76,733,3 $ 29.463,28 48,855 0,60308 12/14/02 Suburban 882719 2,346 0,64900 $ 1,522.49 N/A $ 1,522,49 79,079,2 $ 30,985,77 51,200 0,60519 12/12/02 Resources 200212-8845 9,601 0,60394 $ 5,798.42 Inteorated $ 5,798,42 88,680,2 $ 36,784,19 60,801 0,60499 12/13/02 Resources 200212-8834 9,103 0,60394 $ 5,497,67 Intenrated $ 5497,67 97 783,2 $ 42,281,86 69,904 0,60485 12/14/02 Sea-3 14002-0912 1 19,576 0,60642 $ 11,480,74 $ 390,55 $ 11,871,29 117 ,359,2 $ 54,153,15 89,480 0,60520 12/31/03 ResourcesI200302-9019 1 18,268 0,60394 $ 11,032,78 Inteorated $ 11,032,78 135,627,2 $ 65,185,93 107,748 0,60498 12/31/02 inv adiustment 1 439 0,90574 $ - $ - $ 397,62 135,627,2 $ 65,583,55 108,187 0,60620 12/31/02 End of month , $ 28,082.61 46,325 61,862 0.60620 01/12/03 Resources 200301-9237 18,267 0,67924 $ 12,407,68 Intearated $ 12,407,68 153894,2 $ 40,490,29 64,592 0,62686 01/13/03 refund - - $ 1720,541 153,894,2 $ 39769,75 64,592 0,61570 01/15/03 Sea-3 4003-0053 19,240 0,68191 $ 12,732,45 $ 387,50 $ 13,119,95 173 134,2 $ 52,889,70 83 832 0.63090 01/21/03 Suburban 882720 2,199 0,71600 $ 1,574,20 N/A $ 1,574,20 175,332,8 $ 54,463,90 86,031 0,63307 01/23/03 Suburban 882721 1,976 0,75900 $ 1,500,01 N/A $ 1,500,01 177 309,1 $ 55,963,91 88,007 0.63590 01/24/03 Sea-3 4003-0082 19,268 0,68191 $ 12,750,98 $ 388,06 $ 13,139,04 196,577.1 $ 69,102.95 107,275 0,64416 01128/03 Suburban 533581 2045 0,75900 $ 1,551,85 N/A $ 1,551,85 198,621,7 $ 70,654,80 109,320 0,64631 01/31/03 invad'ustment 54 0,74315 $ 40,13 $ - $ 40,13 198,621,7 $ 70,694,93 109,374 0,64636 01/31/03 End of month $ 29,146.91 45,094 64,280 0.64636 02/10/03 Resources 200302-9819 18,255 0,80667 $ 14,725,76 Intenrated $ 14,725,76 216,876,7 $ 43,872.67 63,349 0,69256 02/14/03 Resources Refund - - $ - $ - $ 13,115,171 216,878,7 $ 40,757,50 63,349 0,64338 02/26/03 Suburban 533593 2,291 0,91600 $ 2,098,92 N/A $ 2,098,92 219,168,1 $ 42,656,42 65,640 0,65290 02/28/03 Suburban 533595 2,373 0,91600. $ 2,173,76 N/A $ 2,173,76 221,541,2 $ 45,030,18 68,013 0,66208 02/28/03 Resources 200303-10068 18,208 0,86820 $ 15,808,20 Intenrated $ 15,808,20 239,749,2 $ 60,838,38 86,221 0,70561 02/28/03 Resources 200303-10085 18,207 0,86820 $ 15,807,32 Inteorated $ 15807,32 257,956,2 $ 76,645,70 104 428 0.73395 02/28/03 inv ad'ustment 531 1,22985 $ 653,05 N/A $ 653,05 257,958,2 $ 77,298,75 104,959 0.73646 02/28/03 End of month $ 40,061.70 54,397 50,562 0.73646 03/17103 Resources1200303-1 026~ 18,002 0,81977 $ 13,051,45 $ 1 706,05 $ 14,757,50 275,958,2 $ 54,819,20 72,399 0,75718 03/20/03 Resourcesl Refund - - $ - $ - $ 18,188,831 275,958 2 $ 46 630,37 72,399 0,64407 03/27/03 Suburban 1 450308 2049,6 0,89000 $ 1,824,14 N/A $ 1,824,14 278,007,8 $ 48,454,51 74,449 0.65084 03/31103 inv adiustment - 1,086 - N/A $ - 278,007,8 $ 48,454,51 75,535 0,64148 03/31103 End of month $ 18,689.01 29,134 46,401 0.64148 04/03/03 Sea-3 4003-0320 9,830 0,77319 $ 7,400,64 $ 199,84 $ 7,600,48 287,837,8 $ 26,289,49 38,984 0,67471 04/07/03 Resources 200304-10474 9,303 0,61977 $ 4,884,08 $ 881,64 $ 5765,72 297 140,8 $ 32,055,21 48,267 0,66412 04/08103 Sea-3 4003-0335 9,832 0,55403 $ 5,247,33 $ 199,89 $ 5,447,22 306,972,8 $ 37,502,43 58,099 0,64549 04/08103 Resources 200304-1047 9,000 0,61977 $ 4,725,00 $ 852,93 $ 5,577 ,93 315,972,8 $ 43,080,36 87,099 0,64204 04/30/03 inv adiustment 766 0,24210 $ 185.45 $ 185,45 315,972.8 $ 43,265,81 67,865 0,63753 04/30103 End of month , $ 13,033.62 20,444 47,421 0.63753 05/01/03 Sea-3 14003-0389 I 28,708 I 0,63970 1 $ 17,783,74 $ 580,91 $ 18,364,65 I 344,680,8 I $ 31,398,27 49,152 0,63880 OS/22103 Sea-3 14003-0439 1 28,051 0,63961 1 $ 17,376,75 $ 584,95 I $ 17,941,70 I 372,731,8 I $ 49,339,97 77 ,203 0,63909 05/31/03 inv adiustment I 5981 1,26147 I $ 754,36 1$ 754,36 I 372,731,8 1 $ 50,094,33 77,801 0.64388 05/31/03 End of month $ 26,720,29 41,499 36,302 0.64388 06/13/03 Sea-3 14003-0487 19,033 0,66881 $ 12,346,14 $ 383,33 $ 12729,47 391,764,8 $ 39,449,76 60,532 0,65172 06/16/03 Sea-3 14003-0504 18,600 0,66881 $ 12,065,26 $ 374,60 $ 12,439,86 410,364,8 $ 51,889,62 79,132 0,65573 06/30/03 Adiustment - $ 1567,591 $ - $ 1567,59\ 410,364,8 $ 51,322,03 79,132 0,64856 06/30/03 inv ad'ustment 454 0,35291 $ 160,22 $ - $ 160,22 410,364,8 $ 51,482,25 79,586 0,64688 06/30/03 End of month ,. $ 29,930.94 46,270 33,316 0.64688 0711 8/03 Sea-3 14003-0566 1 19,3991 0,65652 I $ 12,348,82 $ 387,01 I $ 12,735,83 1 429,763,8 1 $ 42,666,77 65,669 0.64972 07/31/03 inv ad'ustment 1 819 I 0,10418 I $ 85,32 $ - 1$ 85,32 1 429,763.8 1 $ 42,752,09 66,488 0,64300 07/31/03 End of month '1> $ 21,490,51 33,422 33,066 0.64300 08/07/03 Sea-3 14003-0610 I 28,898 1 0,63182 $ 17 ,68 1,82 $ 576,52 I $ 18,258,34 1 458,661,8 1 $ 39,748,85 62,320 0,63782 08/31/03 inv adjustment I 1 1 1,08412 $ 1,270,59 $ - Us; ..591_: 41,019.44 63,492 0,64606 08/31/03 End of month " 23,792,98 36,828 26,664 0.64606 09/09/03 Sea-3 18,999 09/10/03 Sea-3 19,000 FYTD Totals 496 661 0,61048 $ 300,587,11 $ 8,421.83 $303,203,83 Page 1 of 1 CSW:09/16/03 ATTACHMENT #4 Page 2 of 2 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON-STANDARD THERMS & RESERVATION CHARGES FOR 09/01/02 - 08/31/03 - Subtotal Subtotal Net Net Charge Per Charge Per Billing Total Interruptible % Contract % Non-Standard % Non- Standard % Reservation Standard Non-Interruptible Month Therms lliJ:!!!! InterruDtible Therms Contract Therms Standard lliJ:!!!! Standard Charaes Therm Therm Sep 2002 1,325,972 293,052 22.1% 454,532 34.3% 747,584 56,4% 578,388 43,6% $ 50,098,82 $ 0.087 $ 0.049 Oct 2002 1,382,272 323,161 23.4% 478,173 34,6% 801,334 58,0% 580,938 42,0% $ 72,519,75 $ 0,125 $ 0.068 Nov 2002 1,537,770 350,684 22.8% 524,357 34.1% 875,041 56,9% 662,729 43,1% $ 151,855,31 $ 0.229 $ 0,128 Dec 2002 2,098,959 370,209 17.6% 700,270 33.4% 1,070,479 51,0% 1,028,480 49,0% $ 158,291,11 $ 0.154 $ 0,092 Jan 2003 2,335,835 394,086 16.9% 734,982 31.5% 1,129,068 48,3% 1,206,767 51,7% $ 158,054,13 $ 0.131 $ 0,081 Feb 2003 2,471,107 447,258 18.1% 732,558 29,6% 1,179,816 47,7% 1,291,291 52,3% $ 145,103,78 $ 0,112 $ 0.072 Mar 2003 2,044,159 389,654 19,1% 717,850 35,1% 1,107,504 54,2% 936,655 45,8% $ 157,188,88 $ 0,168 $ 0.095 Apr2003 1,793,728 394,168 22,0% 608,474 33,9% 1,002,642 55,9% 791,086 44.1% $ 120,066,70 $ 0,152 $ 0.086 May 2003 1,681,949 376,868 22.4% 573,558 34.1% 950,426 56.5% 731,523 43,5% $ 75,034.80 $ 0,103 $ 0.057 Jun 2003 1,459,875 353,739 24,2% 518,466 35,5% 872,205 59,7% 587,670 40,3% $ 64,013,72 $ 0,109 $ 0.058 Jul2003 1,372,232 339,881 24.8% 471,358 34,3% 811,239 59,1% 560,993 40,9% $ 65,786,61 $ 0,117 $ 0,064 Aug 2003 1,408,085 342,156 24,3% 500,485 35,5% 842,641 59.8% 565,444 40,2% $ 65,779,02 $ 0,116 $ 0.062 Total 9102-8103 20,911,943 4,374,916 20.9% 7,015,063 33.5% 11,389,979 54.5% 9,521,964 45.5% $ 1,283,792.63 $ 0.135 $ 0.0776 # -- For ComDarison Total 9/01-8/02 19,786,847 4,381,726 22,1% 6,375,186 32,2% 10,756,912 54,4% 9,029,935 45,6% $ 1,152,697,34 $ 0,128 $ 0,0748 Change 1,125,096 (6,810) -1.2% 639,877 1.3% 633,067 0.1% 492,029 -0.1% $ 131,095.29 $ 0.007 $ 0.003 Note: # It is recommended that the "Charge Per Non-Interruptible Therm" differential be rounded to the next lowest penny or $0,070 for the next semi-annual cycle. U:\My DocumentslEXCELIGASRATESIFY 03-04~PGA for 1st Half of FY 03-04,x1s]PGACALC I I CSW:09/16/03 ATTACHMENT #5 ENERGY CONSERVATION ADJUSTMENT (ECA) & ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/03 - 3/31/04 , I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 03/04 Projected ECA Requirements for FY 03/04 only = $ 1,500,000 Projected Administrative & CCS Charges to ECA for FY 03/04 = $ 250,000 Projected Current FYTD 02/03 (Over) Under Recovery of ECA = $ Total Annualized ECA Recovery Needed during FY 02/03 = $ 1,750,000 Less Projected ECA Recovery within PGA @ $0.05rrherm or Gal = $ (750,000) Total ECA Recovery Needed from Standard Rate Customers = $ 1,000,000 Projected Therm Sales for FY 03/04 Applicable to ECA Recovery = 10,410,000 (Natural Gas @ 45% Standard = 9,900,000 therms & LP @ 95% Standard = 510,000 gal. or 10,410,000 Total Applicable Therms) - Computed ECA Recovery Factor Necessary = $ 0.0961 Propose Rounding ECA Recovery Rate to $ 0.100 # Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 1,791,000 II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 03/04 Budgeted EIA Requirements for FY 03/04 only = Projected Current FYTD 02/03 (Over) Under Recovery of EIA = Total Annualized EIA Recovery Needed during FY 02/03 = $ 100,000 $ (165,000) $ (65,000) We are over-recovered in ECA & project to stay over-recovered for the FY 03/04 period. Therefore, EIA needs to be = $ Round Proposed EIA Recovery Rate to $ Annual ECA Revenue Projection @ Proposed Recovery Rate = $ U:\My Documenls\EXCEL\GASRA TES\FY 03-04\[ECA & EIA for 1 sl Half of FY 03-04,xJs]SheeI1 CSW:09/16/03 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge Non-Fuel Eneray CharaelTherm Non-Fuel Energy Charge Energy Conservation Adj, (ECA) EnYironmentallmposition 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 01/01 Therm Rate % Change from 01/01 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/01/73 Non-Utility Taxable FuellTherm ~ NA (1- 3 Units) $7,00 $0.580 0,100 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR OCTOBER 1, 2003 - MARCH 31, 2004 BASED ON APPROVED GAS ADJUSTMENT FACTORS SMF MMF LMF NA(4+ Units) $15,00 $0,580 0,100 NA(4+ NA(4+ Units) Units) $20,00 $0,580 $50,00 $0,580 0,000 0,000 0,000 0,000 0,100 0,100 0,000 0,000 0,000 0,000 $0,680 $0,680 $0,680 $0,680 $1,530 0,850 0,850 0,850 0,850 $1,530 $7,00 $1,530 $15,00 $1,530 $20,00 $50,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,100 0,000 0,000 $0,450 0,850 $1,300 $50,00 NA(l- NA(O- NA(150 3 Units) 149 tons) tons & +) $7,00 if $15,00 if not prey, not prey, billed billed $0.200 $0,150 $20,00 if not prey, billed $0,100 0,100 0,000 0,000 $0,200 0,850 $1. 050 $7.00 @ $15,00 @ $20,00 @ premise premise premise ~ SL w/M& Reliaht NA NA $15,00 $0,200 0,100 NGV NA $15,00 $7 Resl.l $15 GS if not prey, billed $0,300 $0,100 0,100 0,100 Interr. ~ NSS ---1L NA 100,000 &up $30,00 $100,00 $1,250 $1.050 $15,00 $7 Resl.l + FAC $15 GS@ premise + FAC $0.470 $0,280 BTU FACTOR = THERMS/100 CUBIC FEET (CCFI Firm Service Rates Interruptible Service Rates $0,470 $0,410 0,100 0,100 0,000 0,000 0,000 0,000 NA 0,100 NA 0,000 0,000 0,000 0,000 0,000 $0,300 $0.400 $0,200 $0,570 $0,280 $1,150 0,850 0,850 0,850 0,850 0,780 $1,420 $1,060 $15,00 +FAC $30,00 $100,00 + FAC + Non-Fuel Therm Rate for 250 therms X # Days in Mo, $ 1.400 $ 1,400 $ 1.400 $ 1.400 $ 1,299 $ 1.244 $ 1,190 $ 1,052 $ 1,007 $ 0,961 $ 1,052 $ 1,144 $ 0,961 $ 1,299 $ 0,970 $ 1.484 $ 1.484 $ 1,484 $ 1.484 $ 1,377 $ 1,319 $ 1,261 $ 1,115 $ 1,067 $ 1,018 $ 1,115 $ 1,212 $ 1,018 $ 1,377 $ 1,028 0,100 0,100 0,000 0,000 0,000 0,000 $0,300 $0,250 0,850 0,850 $1.150 $1,100 $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0,360) $ (0.360) $ (0,360) $ (0,360) $ (0,330) -19,0% -19,0% -19,0% -19,0% -20,2% -20,9% -21,7% -23,8% -24,6% -25,5% -23,8% -22.4% -25,5% -20,2% -23,7% $0,069 $0,069 $0,069 $0,069 $0,781 $0,781 $0,781 $0,781 1,066 1,045 10/03 11/03 12/03 0,000 0,000 0,000 0,000 $0,570 $0,510 0,850 0,850 $1,420 $1,360 $15,00 $20,00 $0,069 $0,069 $0,781 $0,781 01/04 02/04 $0,069 $0,781 03/04 $0,069 $0,069$0,069 $0,781 $0,781 $0,781 04/04 05/04 06/04 $0,069 $0,781 07/04 $0,069 $0,069 $0,781 $0,781 08/04 09/04 $0,069 $0,055 $0,781 $0,725 Attachment #6 Contract NG Rate ~ NA By Contract By- Contract NA NA 0,000 Contract + $0,000 Plus 0,780 $0,780 + Non-Fuel Customer Charge + Non-Fuel T Rate for Cc # of Therm - $ (0,330) -29,7% $0,069 $0,711 CSW:09/16/03 Attachment #7 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 OCTOBER 1,,2003 - MARCH 31, 2004 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI-FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPS CLP Applicable Annual Gallon Range NA NA NA o - 2,500 >2,501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (1 - 3 Units) Monthly Customer Charge $7.00 $15.00 $7.00 $15,00 $20,00 $7.00 Res!. or $30.00 Set By Contract $15,00 GS if not - Non-Fuel Enerqy Charqes/Gallon: prey, billed @ premise Non-Fuel Energy Charge /Gallon $1.600 $1,600 $0.800 $0.200 $0.150 $0.100 $0,390 Set By Contract Energy Conservation Adj.lGallon 0,100 0,100 0.100 0.100 0,100 0.100 0,100 NA Environm'llmposition Adj, /Gallon 0,000 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 0,000 Total Non-Fuel Charges/Gallon $1,700 $1,700 $0.900 $0.300 $0.250 $0,200 $0,490 By Contract + $0.000 Purchased Gas AdjustmenUGallon 0,930 0,930 0,930 0,930 0,930 0,930 0,930 0,930 Total Energy Charges/Gallon $2,630 $2,630 $1,830 $1,230 $1,180 $1.130 $1.420 $0.930 + Contract NFE Minimum Monthly Bill $7,00 $15,00 $7.00 $15,00 $20,00 Any Applicable $30,00 Customer Charge + _I Customer Charge Non-Fuel Energy Chg. + Any Applicable for the Contracted Facility Charges # of Gallons/Mo, Utility Tax Note: Fuel Rate per Therm 10/01n3 0,161 0.161 0.161 0.161 0,161 0.161 0,161 0.161 Non-Utility Taxable FuellTherm $0,769 $0,769 $0,769 $0,769 $0.769 $0.769 $0,769 $0,769 Change from 01/01 Gallon Rate $ 0,129 $ 0.129 NA $ (O,071) $ (O,071) $ (0.071) $ (O,071) $ (O,070) % Change from 01/01 Gallon Rate 5,2% 5,2% NA -5.5% -5,7% -5.9% -4,8% -7.0% , CSW:09/16/03 Attachment #7 Page 2.of 2 BTU Factor: 2,714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE {lP} RATE BilliNG FACTORS Therm Factor: 0.915 Therms/Gallon FOR OCTOBER 1, 2003 . MARCH 31, 2004 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" COMMERCIAL "WILL CALL" CONTRACT "WILL CALL" (Rate Class is Based on AnnuallP Gallon Usage level) (Based on Annual Usage level) BRLP1 BRLP2 BRLP3 BRLP4 WRLP BCLP1 BCLP2 CLP Applicable Annual Gallon Range 0-60 60,1 -120 120.1 - 300 > 300 1 st 300 > 300 o - 2,500 > 2,500 Any - or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS For Add'!. Annual Customers in this Customers in this Contract Customers Who Gallons Used Range of Usage Range of Usage Request Bulk Delivery Annual Customer Charge $ 96.00 $ 72.00 $ 60,00 $ 48,00 $ 48.00 NA $ 60,00 $ 60.00 Set by contract Non-Fuel Enerav Charaes/Gallon: Non-Fuel Energy Charge/Gallon $ 1.500 $ 1,300 $ 0.800 $ 0,700 $ 0.800 $ 0,700 $ 0.200 $ 0,150 Set By Contract Energy Conservation Adj.lGallon 0.100 0,100 0.100 0.100 0,100 0,100 0,100 0,100 NA Environm'llmposition Adj.lGallon - - - - - - - - NA Weather Normalization Adj.lGallon - - - - - - - - 0,000 Total Non-Fuel Charges/Gallon $ 1.600 $ 1.400 $ 0.900 $ 0.800 $ 0.900 $ 0.800 $ 0.300 $ 0.250 Set By Contract + 0.000 -, Purchased Gas Adjustment/Gallon 0,930 0,930 0.930 0.930 0,930 0,930 0.930 0,930 0,930 Total Energy Charges/Gallon $ 2.530 $ 2.330 $ 1.830 $ 1.730 $ 1.830 $ 1.730 $ 1.230 $ 1.180 0.930 + 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 Non-Utility Taxable FuellTherm 0,769 0,769 0,769 0,769 0,769 0,769 0.769 0,769 0,769 Change from 01/01 Gallon Rate $ 0.129 $ 0.079 $ 0.029 $ 0.029 $ 0.029 $ 0,029 $ (0,071) $ (0,071)$ (0,070) % Change from 01/01 Gallon Rate 5.4% 3,5% 1,6% 1,7% 1.6% 1.6% -5,5% -5,7% -7.0% . I CSW:09/16/03 I I . I I I I I Attachment #8 I I I I I I I I I I I Residential Rate History By Components Clearwater Gas System I I I I Total Rate ComnonentslTherm Contract LP Month NGltherm LP/oallon ECA EIA WNA PGA PGA PGAlaallon Oct-OO $ 1,290 $ 1,601 $ 0,110 $ - $ - $ 0,600 $ 0,510 $ 0,800 Nov-OO $ 1,320 $ 1,651 $ 0,110 $ - $ - $ 0,630 $ 0,540 $ 0,850 Dee-OO $ 1.430 $ 1,651 $ 0,110 $ - $ - $ 0,740 $ 0,650 $ 0,850 Jan-01 $ 1,890 $ 1,801 $ 0,110 $ - $ - $ 1,200 $ 1,110 $ 1,000 Feb-01 $ 1,890 $ 1,901 $ 0,110 $ - $ - $ 1,200 $ 1,110 $ 1,100 Mar-01 $ 1,890 $ 1,901 $ 0,110 $ - $ - $ 1,200 $ 1,110 $ 1,100 Apr-01 $ 1,670 $ 1,691 $ 0,110 $ - $ - $ 0,980 $ 0,895 $ 0,890 May-Ol $ 1,580 $ 1,620 $ 0,120 $ - $ - $ 0,880 $ 0,795 $ 0,810 Jun-Ol $ 1,500 $ 1,578 $ 0,140 $ - $ - $ 0,780 $ 0,695 $ 0,750 Jul-Ol $ 1.420 $ 1,516 $ 0,160 $ - $ - $ 0,680 $ 0,595 $ 0,670 Aug-Ol $ 1,390 $ 1,445 $ 0,180 $ - $ - $ 0,630 $ 0,545 $ 0,580 ~ !Ii 1,340 !Ii 1.433 $ 0,200 ~ $ - $ 0,560 $ 0,540 !Ii 0,550 FY Average $ 1.551 $ 1.649 $ 0.131 $ - $ - $ 0.840 $ 0.758 $ 0.829 2000 Avg. $ 1.222 $ 1.584 $ 0.103 $ 0.003 $ 0.010 $ 0.527 $ 0.431 $ 0.779 Oct-Ol $ 1,340 $ 1,380 $ 0,140 $ - $ - $ 0,620 $ 0,540 $ 0,550 Nov-O 1 $ 1,340 $ 1,380 $ 0,140 $ - $ - $ 0,620 $ 0,540 $ 0,550 Dec-Ol $ 1,340 $ 1,380 $ 0,140 $ - $ - $ 0,620 $ 0,540 $ 0,550 Jan-02 $ 1,360 $ 1,390 $ 0,160 $ - $ 0,020 $ 0,600 $ 0,520 $ 0,520 F eb-02 $ 1,360 $ 1,390 $ 0,160 $ - $ 0,020 $ 0,600 $ 0,520 $ 0,520 Mar-02 $ 1,360 $ 1.420 $ 0,160 $ - $ 0,040 $ 0,580 $ 0,500 $ 0,520 Apr-02 $ 1,360 $ 1.420 $ 0,160 $ - $ 0,040 $ 0,580 $ 0,500 $ 0,520 May-02 $ 1,340 $ 1,550 $ 0,160 $ - $ 0,040 $ 0,560 $ 0,480 $ 0,550 Jun-02 $ 1,340 $ 1,550 $ 0,160 $ - $ 0,040 $ 0,560 $ 0,480 $ 0,550 Jul-02 $ 1,360 $ 1,620 $ 0,160 $ - $ 0,040 $ 0,580 $ 0,500 $ 0,620 Aug-02 $ 1,360 $ 1,690 $ 0,160 $ - $ 0,040 $ 0.580 $ 0,500 $ 0,690 Sltl!:,02 !Ii 1,360 $ 1,690 $ 0 160 $ - $ 0,040 $ 0,580 $ 0,500 $ 0,690 FY Average 1.352 1.488 0.155 - 0.027 0.590 0.510 0.569 2001 Avg. $ 1.549 $ 1.586 $ 0.138 $ . $ - $ 0.831 $ 0.751 $ 0.758 Oct-02 $ 1,300 $ 1.640 $ 0,100 $ - $ - $ 0,620 $ 0,550 $ 0,740 Nov-02 $ 1,300 $ 1,640 $ 0,100 $ - $ - $ 0,620 $ 0,550 $ 0,740 Dec-02 $ 1,300 $ 1.640 $ 0,100 $ - $ - $ 0,620 $ 0,550 $ 0,740 Jan-03 $ 1.420 $ 1,770 $ 0,120 $ - $ - $ 0,720 $ 0,650 $ 0,850 Felr03 $ 1.480 $ 1,810 $ 0,120 $ - $ - $ 0,780 $ 0,650 $ 0,890 Mar-03 $ 1,560 $ 1,900 $ 0,160 $ - $ - $ 0,820 $ 0,750 $ 0,940 Apr-03 $ 1,560 $ 1,900 $ 0.160 $ - $ - $ 0,820 $ 0,750 $ 0,940 May-03 $ 1,560 $ 1,900 $ 0,160 $ - $ - $ 0,820 $ 0,750 $ 0,940 Jun-03 $ 1,560 $ 1,900 $ 0,160 $ - $ - $ 0,820 $ 0,750 $ 0,940 Jul-03 $ 1,560 $ 1,900 $ 0,160 $ - $ - $ 0,820 $ 0,750 $ 0,940 AUQ-03 $ 1,560 $ 1,900 $ 0,160 $ - $ - $ 0,820 $ 0,750 $ 0,940 Seo-03 $ 1,560 $ 1,900 $ 0,160 I- - ~ - $ 0,820 $ 0,750 5; 0,940 FY Average 1.477 1.817 0.138 - - 0.758 0.683 0.878 2002 Avg. $ 1.342 $ 1.553 $ 0.145 $ . $ 0.027 $ 0.590 $ 0.513 $ 0.617 Oct-03 $ 1,530 $ 1,830 $ 0,100 $ - $ - $ 0,850 $ 0,780 $ 0,930 Nov=03 Dec-03 .. Jan-04 Feb-04 Mar-04 Apr-04 Mav-04 Jun-04 Jul-04 Aug-04 Seo-04 FY Average 1.530 1.830 0.100 - - 0.850 0.780 0.930 2002 Avg. Incr. Above $ 0.230 $ 0.190 $ - $ - $ - $ 0.230 $ 0.230 $ 0.190 Last Year Same Month 18% 12% 0% NA NA 37% 42% 26% Incr. Based $ 4.60 $ 4.15 on 20 Therms 14% 10% Eauivalent Cents/KWH 5.2 6.8 for Gas vs. FPC Rate 8.4 8.4 (Residential) Gas Cheaper bv -38% -18%