Loading...
GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 2005RECEIVE[ CLEARWATER GAS SYSTEM JAN 2 8 2005 Interoffice Correspondence Sheet OFFICIAL RECORDS AND TO: William B. Horne II, City Manager LEGISLATIVE SRVCS DEPT \\ FROM: Chuck Warrington, Managing Director vJ J COPIES: Garry Brumback, Assistant City Manager; Cyndie Goudeau, City Clerk; CGS & CCS Management Teams; Janet Dorrough, Sr. Accountant /CGS; Tom Medley, Sr. Accountant /CCS; Laura Damico, Sr. Accountant /CCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 2005 DATE: January 25, 2005 Natural and LP gas supply prices are still historically high and continue to increase somewhat. Therefore, we are recommending an increase of 40/therm in our Natural Gas Purchased Gas Adjustments (PGA) and an increase in our Propane (LP) PGA of U /gallon. We are also recommending an increase in our Energy Conservation Adjustment (ECA) of 30/therm or gallon due to the continuing level of growth. Finally, the weather has been warmer than normal FYTD such that we are recommending the implementation of a 1 0/therm or gallon Weather Normalization Adjustment (WNA) at this time, which we expect to require thru June. The final timing of the WNA discontinuance will depend on the weather for the remainder of the winter. We are not recommending any other adjustment clause changes at this time. The net effect of these recommended changes is an increase in our typical Residential Natural Gas customer's rate of 80/therm (up 4.6 %1 and an increase in our typical Residential LP customer's rate of 60 /gallon (up 2.9 %). Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after February 1, 2005: Natural Gas Firm Standard Rate Schedule PGA ....... $1.11 per therm (up 40/therm) Natural Gas Interruptible and Contract (Non - Standard) Rate Schedule PGA ............. $1.04 per therm (up 40/therm) Propane (LP) Gas Rate Schedule PGA .................... $1.21 per gallon (up 20/gallon) Energy Conservation Adjustment (ECA) ............... $0.13 per therm (up 30/therm) & $0.13 per gallon of LP (up 30/gallon) Environmental Imposition Adjustment (EIA) ......... $0.00 per therm (no change) and $0.00 per gallon of LP (no change) Weather Normalization Adjustment (WNA) .. ......... $0.01 per therm (up 1 0/therm) & $0.01 per gallon of LP (up 1 0/gallon) William B. Horne II, City Manager January 25, 2005 Page 2 Attachment #1 shows the FY 04/05 FYTD status of our Adjustment Recovery Clause balances with actuals thru December and projections through FYE Period 13. These show that we are nearly $3.0 Million behind in our recovery clauses as of December and are projecting to catch up on this by the end of the fiscal year. It is important to our overall financials for FY 04/05 that we bring this close to balance by the Fiscal Year End, and our recommended recovery factors are based on recovering the current deficit. Attachments #2 and #3 show our current annual projections for Natural Gas supply costs and LP supply costs, respectively. Attachment #4 shows our methodology for calculating our proposed WNA. Attachments #5 and #6 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #7 shows our rate history over the past 3 years and shows our relationship to electric prices. I should point out that the overall effect is that our typical Residential customer rates are still 34% lower than electric for Natural Gas and 15% lower for LP. This was impacted by a fairly significant increase in Progress Energy rates in January also due to their supply cost increases and another increase is expected in the Spring due to their hurricane losses last year. Therefore, we still remain very competitive as compared to electric rates. It is our plan to use the above - proposed adjustments for billings through September 30, 2005, unless there is a significant change in our forecasts or we project a significant over /under recovery of our adjustment clauses. 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 we can get this information to CCS in order to make the appropriate adjustments in the billing formulas in time for the February 1 st billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: William B. Horne II, City Manager U: \My Documents \MSOFFICE \WINWORD \GASRATES \Gas Adjustments for December 2004.doc r M � O C P E°f L �a a W F } N Q l7 W a C j V Q € = FO 00 w'0 a W Mcn o� 0000 00 N (�L O 000fg O O o,�� mCD U1 O (,� NNNN r M n O ;r r O r O r O r O r O r O U a1 IL 00 r 01! r r r Z r � r r nn r .m+ to C4 r Z a�w3 O Q w a J C N N M M M M M N N ° W 09, -mtOW WnoMaar- W d Ulm NI��hPI�I�MMMMEO m m nvto0N c\v m WDmEOx LCI G M OD nmxmootpov, G pp M 0 N O U') C4 V omCDW)oDCDr CO y L CD Go r- voU)' t� o0 NO 11, a Lo A m !� Ilt NnO U)n 0 0r�MM U)M� t0 Co W'1 NMn EOM m m l�EON mamnmm M Lo Mna N t0 N I-0 EOZa�O amr Chi voaqWk vEMM nN (� y EOLr0monl°vN`•' ati M n EO r I, to rNMN WOM ��rNNNNrvv ... C V < II Y 69 V! !A ER V) V) fA V! to o fA ti) to f9 N m co V► f9 W fIi M 69 Vi fA to Vi f w W fA C y �O nv I�wm NOr E00 nO001 n O C nNm It -w0000000000 C7 eF OCa 0010a U)EO w Q� („) m O O1 n N Y» m(D— 0) n ee}} v to 0)nNtomn r n v m o O U m m mxn N OM000l0Cp tt)Pm U)m vi O �7 atNN c) in W a myL� V mmno U1 M O�nNnMNvMME7 U)ID �q+ t1�tp NCOMnNNON MG010>� W tAn n pU W ID p EOO a 04 00110m10 W� U+ C m p EMDMD1 ----- � N r M r M M M M M N L to w C E K fH Vi 69 114161 V► fH Vf V1' V► V) fA !fl FA 2� �a l`0 U V! fA Vl to 64 tq f9 69 u9 Vi V► M V) f!! W �Ln E `E a tp oo000 tOn000000000 0000000 n O a m fO to r "000000000 l�Mvo U.)in 0U1 CO O (7 d ED g M MOn O N W CV m I EO co N 0Mm CV N - W w (' N nMn O C" NCD M t0 w 0 CC M toNN a v Lo p 9 II O '0 m n Cp WiMM rCpOCOt+) NtpW'ih n p O. d� ONC?NONEOmmNrr � C Z— m of NMnrrNO MEO EO mtomtO I�WC)optq n EONNN tpNN10 00mM �p N) O E� J= Co V E�mmmr-mU)vavv M �h v0 MPMNN 0 c� m O }+ >< m E p N C F IL u) 69 Vl f9 f9 dl di fA fH fH Vi f9 to Vi m �[- w O W I I Vl V► u► &Sj G&j H fA V► tR ers fil vl en «! ¢ J df m �T 0) I�Nn 00 M to mCO N O M�mOMNrp^c M W f) m O O 1 M O rOM000000000100 n O O CDC O O O O O i O M U) LL d C w OvU100mtp fO�r 10 tp NMnMNGv M M 10010) tDmNMMfOM NN r- N ON tp O 0 7 LL m N O CQn CO a tO U) CD thn U) n OCGOGpCN ED O Wn 010 GO comM a U) O to MvMO to 'o p 0- LL C V r rn Z m O. CO MraoEOOwtD V W1NrNnMMM u) MNC 20001 CGr fD 0 Ea Q J M NM O v U)M ED O U110 Lo Com vM A M MMMra N N W N - — - N — rr V_N rrrr -.n" vco EO CU r 0 O O ~ 69 fA 69 6011 64 611 tq 6! fA 69 Vi 69 d3 64 U Z ~ Vs 19 fH EA ui 69 60 w fA V) 69 fN uT !A N M M —.c4 M O O O O O pp O O O O n r a If'l n x 0 0 p 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N_ O O N n O 0 O 0 O W O O fp C Co cm MNn000000000 t00000CCC00 0)Qa a a a a C a a f0 C 9 co warn M MOOOOOCO0a DOE000OCome) r N ONpO> v1DO U1 tO u�0 N0 O) M m C mO to OOOOOCO00 U) O Q1 NNCOm EOOMrC V r v to E00rr M m rrOrtONO N V Nv CO U)100 tp w to tO U) W) b E W Nmwkn pLove) U) tp maa MMM NN w m W) fl- to � U1 01 w x U w V V tss u► 6'1 � fA w 6'T fA 69 69 tf) V1• f9 � Vi fA V► fA vs � tH fss to v► fA ui N mNCONnm Co U1 M U) r N CDM O M vO U1 m coo 0 n O to M W n x0011000000 0 0 0 0 0 0 0 O N m C co O rnh CO O co v W) O O MM co m f-MNO..��{{N E O CO �pp WOmNNI� m N t 9 t 0 N r N E m C �N m W)V to N tn000p n O O O t p C N W) m I�Nr�OMh to Co M vMMN M N c x - C IY W to fH to 6! to tf? to tf3 to f9 64 to fA c Vol tH Vil vil fn K Vs 69 0% fA V). fA onE000000000o voE000OOOO . N M motp00000000o W1mED000aaCaa0 x n to O101f100 M to 0 0 8 0 000000 0 0 0 0 0 v n10 N a CI 0 0n1 3 N O0 W co O co O O O a O <o M a m 0 c 0 0 0 0 0 0 0 n a nm mmmCpOOEnO anD CO to t0 M m M CO to O 000000000 O O O pp 8pOOC Mto co O d 000000000000 O nmMCD Eon tOM 000 O J C Z r p c a to d c 4 O m m 0 E= C LU r cc O a lc0 p z U v y U) d .0 0 my r NU a En o a: �0 d CL a 40 .` 0 « r > W a N ° 'p o W Nv- two D m UUg r ��� mts« ° w U0 —aka c Qa d9 w f9 Vi rA fR 69 6'i Vi fA f9 19 EA !0 V �;'~ M OU a (,� 6 A Va 69 to uw ;Q (°) V LL IL d J J CCy J W Q nNN000000000 tp CO M000000000 n ON000000000 t7 M = O Y1 m MOe� too OGOGOOOOC 000000000 EG M 7a C a(7 d m On co EO toP x 000000000 00000000 v N N mL E7 2 Nm00o000000 Mnn to 0 lO wva0000 Cor to to co CO to N O ca O to �a co CS a on owe MM10 c; O - M - M t0 - tO U)CO - N wto toxxMMM 00000 CEO hf� O M 0 a U La r ti N � r M 7 G N a (� Vl to W. to E9 fA V) 69 fa 63 f9 ti! CA C LL (3Wp J 64 J J g C} O vvNNW")W7M Q Q O O O O Q Q p 0 0 `� w a �.. m CCav S} O O p O Q Lt) C 10 O M U1 O WD O 0 ~ ° °°AO °�LGL)2M j-') °mom:°. w IL °`o0o0mmmct�o >> O >a�idm Z m (L �� a�aH d °o�aOz�'- �LL ag -1 -)acna o H - r M C o m N E L m Q N QNQ f9 3� QC W J U O O O O CDs O r r 0 .. r 0 r 0 ..� 0 0 0 0 S p°° 0 0 0 0 0 N N V t :7 O O OO O OO O OO G O G O Q�� 12 O a OO °O° OO O O OO OO °aO O OO C as G Z J O O O O M L � d J 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N O N O O O O O O O O o 0 0 0 (Q Z 0 0 0 0 0 0 0 0 0 0 0 7 CN CO ¢CV m cnO1�fONCONCiOfNWCOM tC1O0NnOW W Cl! W aOCO m . -VVaVV nnnnnnnnnnnni. V V•tV V V Vv R m m LL7 CV �ehOW V: GCV 4�NC'70C�Cp 9CO W C OOCC)O� CV CO CO��F V CO CO MO COM Q Uc W m CC'!OO 4"I MC74")�C1 O OD V n V I,:. CCl V f1t. In V In V bCfJ�4oe V V 0NCO O V -� Ph (O EQ > OW0 -e-W In to to OCOnW WM >�� OnCOW O ��l1 ED E pmn V�nu��nNV�V V V CO CO n V CO Vv�n WO aO ESL WnnCO �c1��}MN� ANN V L N .O. � 0 V } vsugvsu�v�wv�vsv►v�v�wusys w� m wwv►vsysv�v►vsv►vsviu�rnvs nn W V MP MO nOOOOOOOOOOO n m m CO Woo CDNO�nCG VCOt0O vm�ononaoWwM C-V CO VOO�n CO CVMGe 114q =CO u� Q U u m m M00000000000 �v°�u�i °o °o °o °OOH �irfOi � M -� CoOPt�MN� Lq W V_NOOOO$oo ag n C nNO Cn 0O W - —V_rgi. A CO O! W OfOOMMM �M W 0 �MM NMN t0� y p O p tee- 1n �Q p Lu a�dl yrvsysysysuseAU�viwv►ww1 �a c vs e9mviusus44wv444 641,48.vsw OOO 0 �000 M CO O CD, CO °OOOOOo N O O O CO N 2 N CO CO Q CON W COr I-CCpp O n CO n nnNn M) ON CO CD -vi �-ON d� Q 000 I O CC V W 0 N W M to O n C g M act 0 0 0 M M C L W M M M O ON w CO CO OOONMNO N CO NN W W W W Worm 1n 3 C MPjM i-m m O Em vi di vi fA fR fR vi to wo fH vi tH fA f9 U W iH Ch fR Ul /A CA V► v► di fA fsf t9 di noOO°oOOOOoppO MOOOOOOOOOOO n M ton Mn W CO�p V W V OONO1nO� O COMn aoN V W E m V W O01O t00000NNNnM nn10�MCOM t00 W CCI CONNCA CO O CO Q p O NO W CC1MOOOO CO a 0 0 0 a 0000 0000 C O W C COO W NNN NNNNNN V V n N W O N 0 mmom 0 0 0 0 0 0 0 0 a0 n W — O O O O O O O O O m C m W 00000 CA p� F a ��.- . -�.-�� m HZ vs vsessv►vsysysv►d♦64 vius vs �� v,viwv►�wvivsysysu�us.nv: N V a M C�NM� OCD co W ayh VONOMO Ow mp-0 O i C N O MMIq N alto N w 0 0 n1n CO wNNNnMCO m w CO to N W M N C V MMM V V t0 m Ja C N � CL xx � C W V3 fR vi fA b1 fH M M v► Cf? vi Cl4 fA V! di EH di W di W CA v► to vi 19 fA fR t` r N co co t0 O O N 0 r co 6S CO cq O 0 0 V > C Go O O CL CL 6 0 L N M E �E E w mMV gg LM Q E VUd .° W ,� t C >> v Z C U c yVj o a+ v Q Q > v Q C�9 m} C LL m w o E W M m yCO4 Q Cl h u i Q u W w 0 2 E E m� m a Q Z a. a a m o Z Z O O m m t m m CO a 0 CO W N O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 pp 0 M M dl n M 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n M H Q C y W CO ao�00000cooc V CO r 0000 0 0 0 OOOO 0 0 0 CO O°O 0 0 r Lo fJ C CcE6 Q p d 2 .� C; p m p N W ?N O OOpOOOOOOO° C O 0000000000 G C O O C O O O O O O CO c C CC W C7 w yy p, IAN n V W CC) �00O0 O OCt C7 - QO OOOO Cnp y V w J � ~ C m O M W W W W 00000 r .- O) W yy m Z N I K W r -- � - - -- O m� 7 O 0 `° Q K W 7 3 v>�vsvvsysysysyrv►v>� cLL � V V L4 g 44 v►aviwvvivsvi�wv 64 'O C} VO Y OOS�M > V C Oi OQQOQQ�� a.. �• N �M} C V V H00 OCn Cn 2 Lo °9RQ U')0 NMI W 7 m�aOZO�Ia_�Q���QNaFm- 0 O O m m m CO l0 C 7 7 7 m m .m. 9 m�a°cOZOm�i�Q`2mn�Qtna p> c 4q A C 7 m m� W �Z o H - r M d M E m r � v w �a Q m a c� rc v 9 4 ac NN N I�MM� 1008 M O 0000 000000 Lo Iii �� Q== 0000 0000 00 �- ;; �.- Z�jtn aaaa aaaa as ° Ht� t J MM O to N taO N La N to N �� N N i Z J 0000 0 0 0 0 0 0 0 0. 00 O O 0000 0 0 0 0 00 z tCJONOf h �C9pp� W t n m t n t O� O M m mY0 n • p ' p O m"t M m N 00 M N O a O 0 0 0 0 0 0 0 0 0 0 J p�lOaO tqONmN0)to r m E tv_°mwmvO�c�rnm�M v m E Q O _ .0 ..OD Do00o V tll � cn N N N C%j C14 � T fA VA N► M• 01 fA fA ER ffl f9 lil IA V! ty Vi ER d! Eta m . m q H c! C"! V m ro 0 uial000 mNLo CM 'v�e�doitriv ANN c Ol • • t C �L M n Nto W N l-C7NNW 'Q N m m r- m N M c �- C �' L� 0 CC,; 0 i 30; 0 0 »� 0 CC,; 0 O 5 �dl Ov O Mm CO � W- mNMv OD1C'!�aa MC�MY� W 00 N n ��� • O 0% G% iH fA dl fA M' ti7 U! to 69 fH ff! tf> f9 fA to N9 m <O 0 O 0 Of 0 M 0 O 0 0 0 10 0 LQ 0 O 0 ao 0 n 0 n P ' oirad�c�cririvv�00 aOnmN�ntgNNnnn OMaOaN(OmNON00 cc ' Y> m� f�NtFm<O� m10 N 00000_0000 » » »» _ O:msfm MMa WON NO°f_n0Rq 0 L ODD O l� b � �NNNN — — — N N # # # ##+c### ~ fR fR n to v Nm Of N nOl tp N OR N U M � m M M O> m _ a 0aon pvad(cno�omm mmtr� ��^ 2 Q _ w C nva v_m a� hu,nN 01ntpt� -m001 r N M C cc ;t to to tO O W m m nmMClnOfMm00nnn O) 0 0! N N �- I� �- P a N OI m C m V 0 HY W NOOf e-Om LgC!C! N - L � jl N — N NN — N (' C O 000000000 .a! + C Q (� to to tq to v! 64 fA M 61 to f9 69 W } C O C4 V7 l0 Y� a O 10 —mn d°ON� V O a N L d (m7Mto S J La N W QN J V F Z W N Q Z W V � H J N V 0 J Z J Q .+ ` c0 st M M tC1 to m <n N t0 m � W 9 Cm� Q0000�O4--1 vr rQ F 7 0 0-6 O N C.�]gOO A N t0 w CQ 7 7 1 7 &— N G7 t0 �_., a 0 OD O N ec N O c�� W jOZO-�tL�¢i��Qcnam�OZO��a o H m 0 0 c W 0 W f Y F— W) S V LL w w I� C V z� V Y ci a v Y I A A r a C A A m m m m m ol INS, Q aN- MqO��MN'Mp� 3 d N aorcyi mmm01 000 W xx O a o `m'0 b xxxxx OWm mpNp W CO xxxx tO x; AOm m1�t�N�O�mc90 �p f N qoo p0 o O Q QmQ Or0O Om O 5P C JLL�a tY O O-N O O p� V y' e� YY�ff O tN0 p �Np O 1 b ON l�V 1•► � W N ' 6 U xxx�xxa�xxxx NNN g R 0 ^! L � 00g0g��Q0�0000 ONt7 2 N RD i ° 0 n . ,9ot�c���r. o �m :21 n m � 3 m O oe�ryFi,$ as °oo °Og$$ ~ N °o °o �i N KA�0gS�00S m ici vi y� ui mmr Ol 0 7 m O 10 A N NMr mf0� mmm m LL �� g m � a m N A f WW O pp O pp pp O O pp pp pp pp oo O El�p11 1` C 88O 0 ppOpp ppOpp pO 88O O pppS �$ ry 0 0 0< V m � v m a � N LL LL N m N N N N H8 S p pO O O ?a P! r o �ONN o O ooN P1N p O U NpNpp N t�Pl a'Of 17 ; A ONmmpN �[pp N ���S0s8g oSoo °$g0 m m Mp� Q OI�mN r or MMiO �-NN r x W LL A m N 0 0 0 C3 O 3 ®R N 0 0 0 0 ��yy �N S�RpN pl7 0 0 m NNOOOO CpC U N m N a r IWO r r e �t m f pmcu�mavao� e N N O�.qqf O� uN'f f riWpe &i la1OOi of a�aror�irn Ln U �Omm �m'NNr1AmmNi1] L to m� � �� NN1lf O A mmmmm N NNO oo aW N N ryA AP! i:omrmrodr N �-mOmm vcb vi oiri{:� O ^h M m m ' a Y OK N m N O �t n N q p; v O O A n m H 4°'tm p'4�4y 4 {,1 qQ$$p u c6OQ,o Ala b O ZC �U.2 rL, IQw ~ i N m N b A N ^ N 3 m RO ry� mr O M m u'lmN N N r m N� m 0f INS, Q aN- MqO��MN'Mp� g_@ $U�OWbamNM- 6Zm aorcyi mmm01 000 F� a o `m'0 L xxxxx OWm mpNp W CO xxxx tO ` O AOm m1�t�N�O�mc90 �p f N qoo p0 o O Q QmQ Or0O Om O 5P C JLL�a tY O O-N O O p� V y' e� YY�ff O tN0 p �Np O 1 b ON l�V 1•► � W N ' r xxx�xxa�xxxx NNN g R 0 ^! L � N �'! ufW�rro`ao ONt7 2 N RD i r NNm 8 Uf No n tqy o �f z n m � 3 m � oe�ryFi,$ as °oo °Og$$ ~ N °o °o �i N � e ��W�ipamm�im m ici vi y� ui mmr Ol vi W O 7 m O W N NR1N0 W mmm W LL �� g m � m N A f hoAo OL� W A WW adr� Vf N GmN m m rprp��.pp- �- m N �$ A�mpp +7Y]7l'fMNNNM (N(yy �0�OO1 ((pp pMp WAW O ��N� m a � N LL LL N m s e fi c n N n NpNpp Npp 1q A ONmmpN �[pp N � 00'�I�Nf7 N N W (W'1 m 0 0 T LL A m N 0 0 0 C3 N awq$ry°d'��om �t m e N N O�.qqf O� uN'f f riWpe &i la1OOi of a�aror�irn Ln �Omm �m'NNr1AmmNi1] L to O N N N N N N ryA AP! i:omrmrodr N �-mOmm vcb vi oiri{:� O tm n� p"ai N(00N�mm�UY of ill LL'OZ O Z N N N N O A WA V m gn�v`�iggm N N N m = Np I Oi N�p N O O tV o °a W t�l n m � M m m e+l u'i ImNO W ni — IN V) g J O #q N N O a m N M a 0 a M 0 M M 0 M M A a NVmMoMmrmrrm W n o V. 1 G R q ���N�NmEo aNOO��O�mop . de W W b mN N �Nm ��mlp v) L N N N N N i N m N b A N ^ N 3 m o e re M IL a o `m'0 O e O Iyts m A N �p f N qoo p0 o O Q le {Y tY O O-N O O p� V y' e� YY�ff O tN0 p �Np O 1 b ON l�V 1•► � W N ' r NNN g R 0 ^! 4 n tqy o �f n m � N m Z v N ~ N NN N m O O n O g m � m N A f � Lp N N O m m a � N m e A N N N 4yt!���g4R4c��44�� u At^TAc+4rnEdr SO Propane Weighted Average Cost of Gas (WACOG) 1/25/2005 FY 2003 -04 Date Company Invoice R Gallons Delivered Propane Rate Propane Cost Shipping Cost Total ost FYTD Gallons Cost of Invento Tank Invan Tank Wlthdrav4 WACOG 51,600.00 0.899 Mar -05 0.735 $ 0.845 50,000 $ 42,250.00 0.886 Apr -05 0.730 $ 09130104 30,000 $ 24,900.00 0.880 May -05 0.730 $ 0.830 $ 38,962-24 46,805 34,809 0.83368 Jun -05 0.730 $ 0.830 10/12104 Seal 4004-0749 36 956 0.94926 S 38153.89 $ 825.29 36 979.10 38 956.0 75,841.42 85,561 0.866 0.88640 10/31/04 inv adjustment 344 0.94727 S 325.86 25,125.00 S 325.86 38 956.0 78167.28 85,905 0.840 0.88664 10/31/04 ad'ustment WA N/A 6,337.30 WA 11,337.30 38 956.0 67 829.98 a5 905 0.76959 10/31/04 11/09/04 End of month Sea-3 4004 -0814 - 8,337.31 $ 8.337.31 36 955.0 S 39 576.90 47,914.21 50,123 35,7112 0.78959 50.123 0.95592 11/16/04 Sea-3 4004-0846 38 783 1.05835 $ 40196.07 828.58 77 719.0 88 938.84 88.886 1.00059 11130/04 inv ustment 286 $ 77 719.0 88 938.84 69,152 0.99760 11/30/04 12/13104 End of month Sea-3 4004 -0924 36 095 0.98768 37 580.85 S 824.89 77 719.0 $ 46 493.79 64,699.53 46,595 85 490 42,557 0.99760 0.99309 12/15/04 Suburban 132945 2 217 1.04420 2 314.78 WA 79 B35.B S 87 214.32 87 707 0.99438 12/20/04 Sea-3 4004 -0948 19 661 0.98761 19 001.77 415.59 99 596. B 106 631.66 107 366 0.99314 12/31/04 inv ad ustment 231 1.78839 413.35 99 5968 S 107 045.03 107 589 0.99485 12/31/04 End of month S 48 49 40 59,306 0.99485 F"D Totals 139 087 099674 135 996.59 894.33 Propane FY 2005 Projections Projected Current Jan -05 N T mr.,& uus cost $ 0.995 $ 0.860 Gal Delivered 48,293 60,000 Inventory Cost $ 48,044.48 $ 51,600.00 WACOG 0.920 Feb -05 0.750 $ 0.860 60,000 $ 51,600.00 0.899 Mar -05 0.735 $ 0.845 50,000 $ 42,250.00 0.886 Apr -05 0.730 $ 0.830 30,000 $ 24,900.00 0.880 May -05 0.730 $ 0.830 30,000 $ 24,900.00 0.874 Jun -05 0.730 $ 0.830 30,000 $ 24,900.00 0.870 Jul -05 0.730 $ 0.830 30,000 $ 24,900.00 0.866 Aug -05 0.738 $ 0.838 30,000 $ 25,125.00 0.864 Sep-05 0.740 $ 0.840 40,000 $ 33,600.00 0.862 x C s r a d 0 N 0 U o °o °000 °o �° %0 00 — O O oo C O d V1 O 00 00 ON ON 00 C6 ° O kn 0 �+ z � II II 2'� II II II o o a�i a 0 II 40. CS -d II 0 I'D 0 .-• o .r 0 c o v .. W, o 601' ° b C> °o G7 cV 'tl has .CI 0000 07 All 000 M I a as 6A h O an p O o o II to [� M O $. u► O w z O 00 Vi 00 N ti O w w z w p >o A .� Cl a A � � = 0 C 0 > tw a 7ca `0 'ti " o cc N GO 'b Q °: b b L y 'v >4 40. 0 e E L v a w O (i H Z W 0 a O LL > FZ2 W a }Ja 0JZ 0 LU Wm a F m a v► O N N U W J g °0 FW- H a Z O N R' a m LL 0' LL 0 N O U c E 2 c a€i € m o c U E L L L l0 O M G H U U U c c a m m W c m p y D1 Z m m V w d U W W a 0 Z e 0 � � 0) U Q L lL G L Z l0 W 7 n 0 G O o c c G d c Q 2 Z Z W W F. rn m Gol� fo LO w W) m 6s to O O O) p O O ra to i O aa O O O � O 0 O co O N O O O h 0 f rn � o °o• m ci O CD N O O O 10 O rn o O 0 0 o M ° C to G% Im O O O G co O O 0 °: m Z " € C a� G W LL 0) L M O Q O o ° T E LL l I 0:t! 3 LL m 0 P, (D o Im I F- o E o m 1L U U o �cC c� U Z U A?� U UUU Z� ZO X d a°0 z °m 1i C4 a rZ - o N Z m NU t F N ik 10 Go % Z Q o n et 00 o O o O m O O N n O U 100 N 10 0 9 V+ Z H 0 ft 0 C O G G Q Z - � N N ° 0 F ad N :3 O �f9 � N + d10 i G O• 6s V► d! 19 O M p J N O O O N Z oil C O O rrlll Wj Q + N .- cq ? C N 93.6% to J^II N S O I °1 '0 U 0 �° ° 0 — O Q N f r 60 6s 1A Q O N up w O CL O I M 1D � ° E G N C GO to N � 19 di fA w OI �p O d p OI N R O N /+0I l+0! M !D C L c0 0 0 0 0 V) f9 ° E O N N � n d t n® °° G ° N p� C7m °o e9 rA N10 � °v, rA 0- 0 t Z 0 0 c 1c t9 C rA � •- C N N 1- <Z 43. (A 19 p° d O o 1U N M O ° °O) a O O 0 „O, 1N O IIW00 GO V! W O 19 .- C N GO vi 19 0 Z9I ° 0 0 o wo oa° oc o v o of Un o M € O OfA G C C O �I p 10 10 N O .- •- N LL v to yl N Cc, O) c o N r, n M p O ° O O f0 o N h O O r 100 10 f0 O .�- O O G O G 1A to ' ._ !+7 O N fA di f9 r2 + O O O O O O O� O O 10 O34 J " G 7 O Y0Y r O OI 0 —1 � ° ° I� P O t0 Z � G G O O fA rJl y % 19 fA 19 = 0 OD lh 04 cl) O O c Q O 0 O CI r 0 p f0 I� M 0 Z+ N� 0 0 O G C C f9 q y 0) 1A H to N? t o 0 r°i g °� n °I n °o a I 1n o 0 o coo �?m Z e9 vs 0 0 19 i9 .M �T ° 19 m fA M Z r N O r O O o N CO O r � 10 19 vs O r 10 r, V Oi o 69 yi 19 " UP c E 2 c a€i € m o c U E L L L l0 O M G H U U U c c a m m W c m p y D1 Z m m V w d U W W a 0 Z e 0 � � 0) U Q L lL G L Z l0 W 7 n 0 G O o c c G d c Q 2 Z Z W W F. rn m Gol� fo LO w W) m 6s to O O O) p O O ra to i O aa O O O � O 0 O co O N O O O h 0 f rn � o °o• m ci O CD N O O O 10 O rn o O 0 0 o M ° C to G% Im O O O G co O O 0 O m O ° O C O O ID O O M 0 LO 0 �I r G G � 0 m a N a € ji c °: m m m € " € C a� G W LL 0) L M O o O o ° E LL m a 0:t! 3 E Q 0 Z a F- cc a W 1u G 0) m F- r - E c U m 1L U U o LL 2 O m O ° O C O O ID O O M 0 LO 0 �I r G G � 0 m a N a € ji c N w C O d O E orn + U a m A W m E' r3° Q + z t Lam° V c 0 0 ii 0 U cc d V 2 O CD m G UO �I N C Q «LL Y C7 O O Q1 C7 7 O O /A m + UZwgk �► O H V LL. m C LLI w a Fa- d Co J z °o rn M ° °o o .- o e°� ee� o o eO eA o 0 OF ? MElr ovr G C O 00 r-I - MM o o v Ca Qa LL (, C9 W `o o w rn O Z o J C) c —y tv m m m M at e > �J>d =u o�y d_ O) oo ° Eo m °oo °v ° er°� �Ug�v adQU m °c°o w d o0 > m o 0 N oerr �I a o�E �. emit U) Q 61 to CL GO yr yin f O C7 W Wam cis J ago 'i N 0 O o 0 r 0 O 0 OI 0 N 0 0 G rn o� W 6z N A p N O C G O O Vs NI 1°o N O err e0 O el9 eh e9 err Ja W aW 0 0 I cl W y C 0 ° N L6 N e°n °o O ° —I o' o 0 NI 0 ee) 00 eA O o e �1p N N ur °ur ° ° d c; c OOf o v W o ow � W � gaK N m W LL O: J d W O J c Q Z 1 0°D r O cm O t0 ° M 0 J .� EA G vi C G O ppplll O 69 O N C w J_ IL Cl O m p O q O °) p + Lei ° ° ° uO C N � � O N r Gr dr yr Q U U _ `41 d c W r, $ n a! ^ O U ° 0' v O G 000lll N � EA O O N O O O_ O EA EA 5 H y O m m C C C C C C « m C7 �? C A M « m I ° ° 45 a': o Nv NI OI m Q Q C O i7 U cc t 7 m LL C m m E °o T m N 2 N ° N m () Q en m V 7+ N N MO O E o o m .0 m m E m Z x a N c e E ° mrn c ii ei LL a« �+ > > T c m` Z W W E i qn ° ° O O C C N 0C_ 01 f00 V U m m Q z Z W w H d H LL Z Uo N J O N N U) J 1• a E Z d m tj m W U. o c� N d J E 0 C c Z O -i n. p STS A U U Z C Q V Q m m Z O Z Ci pl m O r r C 0 7 V LL W z c y + fn N v V U mN In O .- o C, O O O O O O O F J N J O p v7 r N O O � O r- O LL U LQ L �O U-) >- M a) m 0 W W J C 9 c m 3 c W tH to aW W2 7 U w p GO. i - •- - IMMIM [ Liu ' E SE , : , , wig ff , [ EJKLU] ----- - -�e�- 'Same Month i■���������s�■�� incr. B on 45 Therms Equivalent vs. FPC Rate 5 - to - 9,zaiI -- i p urin • Based on Bul LP ADRLP3) which is uapplicable for customers YJI - csw tlrzsroa Attachment 07 Page 2 of 2 Residential Rate History By Components Clearwater Gas S stem Month Total NGltherm Rate LP/ allon " ECA Com on CIA nts/Thenn MA Contract LP PGA PGA PGAI Ilon Oct 00 $ 1.290 $ 1.601 _ $ 0.110 $ - $ - $ 0.600 $ 0.510 $ 0.800 Nov -00 Dec-00 Jan-01 Feb -01 Mar -01 Apr -01 May -01 Jun -01 Jul -01 Aug -01 Seo-01 FY Average 2000 Avg. $ 1.320 $ 1.430 $ 1.890 $ 1.890 $ 1.890 $ 1.670 $ 1.580 $ 1.500 $ 1.420 $ 1.390 1.3 0 ; 1.551 $ 1.222 $ 1.651 $ 1.651 $ 1.801 $ 1.901 $ 1.901 $ 1.691 $ 1.620 $ 1.578 $ 1.516 $ 1.445 .433 $ 1.649 1.584 $ 0.110 $ 0.110 $ 0.110 $ 0.110 $ 0.110 $ 0.110 IF 0.120 $ 0.140 $ 0.160 $ 0.180 0.2 $ 0.131 0.103 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - ; - 0.003 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - ; - $0.0 0 $ 0.630 $ 0.740 $ 1.200 $ 1.200 $ 1.200 $ 0.980 $ 0880 $ 0.780 $ 0.680 -C 0.630 0.560 $ 0.840 0.527 $ 0.540 $ 0.650 $ 1.110 $ 1.110 $ 1.110 $ 0.895 $ 0.795 $ 0.695 $ 0.595 T 0.545 =1 0.54 $ 0.850 -t 0.850 $ 1.000 $ 1.100 $ 0.890 $ 0.810 $ 0.750 $ 0.670 $ 0.580 $ 0.550 $ 0.758 0.431 ; 0.829 0.77 Oct -01 Nov -01 Dec-01 Jan -02 Feb -02 Mar -02 A r -02 May-02 Jun -02 Jul-02 Aug -02 Sep-02 $ 1.340 $ 1.340 $ 1.340 $ 1.360 $ 1.360 $ 1.360 $ 1.360 $ 1.340 $ 1.340 $ 1.360 $ 1.360 1.360 $ 1.360 $ 1.380 $ 1.380 $ 1.390 $ 1.390 $ 1.420 $ 1.420 $ 1.550 $ 1.550 $ 1.620 $ 1.690 1.690 1 A88 .586 $ 0.140 $ 0.140 $ 0.140 $ 0.160 $ 0.160 $ 0.160 $ 0.160 $ 0.160 $ 0.160 $ 0.160 $ 0.160 0.160 0.155 .138 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - �_ - - $ - $ - $ - $ 0.020 $ 0.020 $ 0.040 $ 0.040 0.040 $ 0.040 $ 0.040 $ 0.040 0.040 0.027 - $ 0.620 $ 0.620 $ 0.620 $ 0.600 $ 0.600 $ 0.580 $ 0.580 $ 0.560 $ 0.560 $ 0.580 $ 0.580 0.580 0.5901 .83 $ 0.540 $ 0.540 T-0.540 $ 0.520 $ 0.520 $ 0.500 $ 0.500 $ 0.480 $ 0.480 $ 0.500 $ 0.500 0.500 0.510 0.75 $ 0.550 $ 0.550 $ 0.550 $ 0.520 $ 0.520 $ 0.520 $ 0.520 $ 0.550 $ 0.550 $ 0.620 $ 0.690 $ 0.690 0.569 0.758 FY Avera a 2001 Avg. 1.352 1.549 Oct -02 Nov -02 Dec-02 Jan -03 Feb -03 Mar -03 Apr -03 May -03 Jun -03 Jul -03 Aug -03 Sep-03 FY Average 2002 Avg. $ 1.300 $ 1.300 $ 1.300 $ 1.420 $ 1.480 $ 1.560 $ 1.560 $ 1.560 $ 1.560 $ 1.560 $ 1.560 1.560 1.477 1.342 $ 1.640 $ 1.640 $ 1.640 $ 1.770 $ 1.810 $ 1.900 $ 1.900 $ 1.900 $ 1.900 $ 1.900 $ 1.900 1.900 1.817 1.553 $ 0.100 $ 0.100 $ 0.100 $ 0.120 $ 0.120 $ 0.160 $ 0.16-0-4- $ 0.160 $ 0.160 $ 0.160 $ 0.160 0.160 0.138 0. 45 $ - $ - $ - $ - $ - $ - ---s $ - -$--- $ - $ - �_ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - - $ 0.620 $ 0.620 $ 0.620 $ 0.720 -$7 0.780 $ 0.820 $ 0.820 $ 0.820 $ 0.820 $ 0.820 $ 0.820 0.820 $ 0.550 $ 0.550 $ 0.550 $ 0.650 $ 0.650 $ 0.750 -C 0.750 $ 0.750 $ 0.750 $ 0.750 $ 0.750 $ 0.740 $ 0.740 $ 0.740 $ 0.850 $ 0.890 $ 0.940 $ 0.940 $ 0.940 $ 0.940 $ 0.940 $ 0.940 0.750 $ 0.940 0.878 0.617 - - - 0.027 0.758 0.5 0 0.683 0.51-3- Oct -03 Nov -03 Dec-03 Jan -04 Feb -04 Mar -04 Apr -04 May -04 Jun -04 Jul -04 Aug -04 Sen -04 $ 1.530 $ 1.530 $ 1.530 $ 1.590 $ 1.590 $ 1.590 $ 1.590 $ 1.610 $ 1.610 $ 1.690 $ 1.690 1.690 $ 1.830 $ 1.830 $ 1.830 $ 1.910 $ 1.910 $ 1.910 $ 1.910 $7 1.910 $ 1.910 $ 1.990 $ 1.990 2.030 1.913 .864 $ 0.100 $ 0.100 $ 0.100 $ 0.120 $ 0.120 $ 0.120 $ 0.120 $ 0.120 -$7 0.120 $ 0.150 $ 0.150 0.150 0.123 0.138 $ - $ - $ - $ - $ - $ - $ - $ - $ - - - $ - $ - $ - $ - $ - $ - $ - - $ - $ - - $ 0.850 $ 0.850 $ 0.850 $ 0.890 $ 0.890 $ 0.890 $ 0.890 $ 0.910 $ 0.910 0.960 $ 0.960 LS.96Q $ 0.780 $ 0.780 $ 0.780 $ 0.930 $ 0.930 $ 0.930 $ 0.820 $ 0.820 $ 0.990 $ 0.990 $ 0.820 $ 0.820 $ 0.990 $ 0.990 $ 0.840 $ 0.840 $ 0.890 $ 0.890 LS.890 0.831 1 .741 $ 0.990 $ 0.990 $ 1.040 $ 1.040 $ 1.080 0.991 s 0.926 FY Average 2003 Avg. 1.503 1 1.534 0.901 0.8 6 Notes: * Based on Bulk LP BRLP3 which is aDpLlicable for customers using 120.1 - 300 gallon fear & equal to Residential LP Will Call (BRWCLP).