GAS ADJUSTMENTS EFFECTIVE OCTOBER 2007
!.
,
CLEARWA TER GAS SYSTEM
Interoffice Correspondence Sheet
RECEIVED
i 01 2nl"!7
~' ! Uti
TO:
William B. Horne II, City Manager
T'C:!AI. REcr)!),,~ ..:
\.~ ~', 1....1 ;~
:,<; LA T'\iI: <::'l; ','
~ ~ . Il.. '"'" 1 \. 'I '.....
FROM:
,
Chuck Warrington, Managing Director tW1.,-J
COPIES: Rod Irwin, 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: GAS ADJUSTMENTS EFFECTIVE OCTOBER 2007
DATE: September 20, 2007
This is the time of year when we project the required levels for all our adjustment clauses
based on the forward price curve and our FY 07/08 budget projections. Natural Gas markets
remain high historically, and the forward market curve indicates that we need to increase our
Natural Gas Purchased Gas Adjustments (PGA), but we are seeing lower current costs than
the long-term market and we have built up substantial deferred NG PGA revenue. Therefore,
we are recommending that we initially drop our NG PGA by 5(:/therm at this time, which is
11 (:/therm lower than the forward curves suggest. We will closely monitor our actual gas
supply costs and propose changes if we see the near-term costs begin to rise. This
recommendation is also more in line with the actions of the other utilities in the region.
Our propane (LP) gas supply prices remain high historically but have stabilized somewhat,
such that we are recommending holding the Propane (LP) PGA at current levels, and we are
also not recommending any change in our Energy Conservation Adjustment (ECA), our
Environmental Imposition Adjustment (EIA), nor our Weather Normalization Adjustment
(WNA) clauses at this time.
The net effect of these recommended changes is a 5(:/therm decrease (-2.6%) in our typical
Residential Natural Gas customer's rate and no change in our typical Residential LP
customer's rate.
Therefore, we are recommending your approval of the following rates to become effective for
billings rendered on and after October 1, 2007:
Natural Gas Firm Standard Rate Schedule PGA ....... $1.08 per therm (down 5(:/therm)
Natural Gas Interruptible and Contract
(Non-Standard) Rate Schedule PGA ............. $1.00 per therm (down 5(:/therm)
Propane (LP) Gas Rate Schedule PGA .................... $1.91 per gallon (no change)
Energy Conservation Adjustment (ECA) ............... $0.18 per therm or gallon (no change)
Environmental Imposition Adjustment (EIA) ......... $0.00 per therm or gallon (no change)
Weather Normalization Adjustment (WNA) .......... $0.00 per therm or gallon (no change)
~
-,
William B. Horne II, City Manager
Page 2
September 20, 2007
Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals
thru August and projections thru Period 13 of this fiscal year. These show that we are
projecting being ahead on our collections by $1.1 million by FYE vs. starting the year behind
($770,000). This is a significant improvement in our financial position and will require us to
establish a deferred revenue account for NG PGA at FYE.
Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs,
respectively. Attachment #4 shows our projections for PGA requirements. Attachment #5
shows our projections for ECA and EIA requirements. Attachments #6 and #7 show the
impact of these adjustment clause changes on our overall Natural and LP Gas rates,
respectively. Attachment #8 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 tvDical Residential customer rates are now
47% lower than electric for Natural Gas and still 7% lower for LP. The natural gas margins
have increased since Progress Energy Florida implemented an increase in their Fuel
Adjustment charges last January, but they have announced that they are filing for lower Fuel
Adjustment charges beginning next January. In any event, we remain in al;'l extremely
competitive position vs. electricity.
It is our plan to use the above-proposed adjustments for billings through September 30,
2008, 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 October 1 st billings. If you have any questions on this, please call me.
CSW /csw
Attachments
Approved: ~8.~-:r:r.
William B. Horne II, City Manager
U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for October 2007.doc
~.
T'"C'l
.......
.. 0
c
CI)
~&
u III
~11.
c(
:l!
w
I-
~
II)
II)
c
Cl
a::
w
~
:i
-'
o
~ ~ ~ ~ ~ ~'1;1:1~~ g;i
~ ~ ~ q ~ ~!L, ,.!q o.
~~~~~2J'~ ~:.
,...,...,...,...,...,....10 coB
:::::::::::::::~I~ ~.
co C) ~IGI6 00...... 0) t-- r--. 0 Q) 0) C\I
~~ ~~~~~~:~~~~::~
>~ii~oowww....CO....~~NN....
;~I~~~O)~,....~.OO~~""'~M
~~!~~~~~~~gg~gg~g
EO~I~~~~~~I~Nwco~~~~
~cw ~N~"'" ,....,....,....,....
0>:-
..,..,....,...,..".w.,..,.w-utw-..w...,.
MOlIOIONCOOCOOMOlOr:::'CO
COCOf""-o)l""-................C>>CONOM......
Oc.;."j--=MNaiaio"';ccic:ir--:......:
WOl"'OOlOlIOCO""O""O"'~
MClON 1l)100lO(J) N,.... CON C') CO
ariaiaiN('t')Ot'ilrir:ti<6aOtOO"":
00 t--Mt--"'t--,....It) O)C\r.IC").......-.-
:e-W"'COIO"'MMN~N ~:
.....
c(E-=
CJ ~ 5
a..co
CJle
z&!ii:
1-::-
~ ;I~
;if!
c ~ 0
o>.c
:IE OIl!!.
16
z
cl:
CJ
I~
I-
Z
w
:IE
I-
Ul
::l
....
C
c(
Ul
c(
CJ
C
w
Ul
c(
:z:
o
It::
::l
a.
Ul
c(
CJ
...I
~
::l
~
Z
WW-W-Ef9-E.l9-utututw-w-..,.tIt....
,...0
MO
l"icci
MCO
alMM
lOoai
a::M!:2
c(
~~~
al
=:;
....
o
~
~
@l
c(
o
11.
.5:
"0
CD
tl
~
"0
U
<( II
~ Qj
....-
o lI)
.. a;
~~
~<3
-w
w_
~~
E I- II
e><<(
E~~
~::::B
1;)0l<(
~II~
"Cc$
"'0_
~'e 0
'51 ~ CD
~e'tO
E 11. a;
oo~
uz+
~
~
c(ii 000000 00
,....,.........,...,.... ,.... ~~
00 ~~~~~~ CJ!CJ!
l1.e :!:::!:::::::::::!::~ ~~
NNNNNN ii5Ci3
11.. CO coco coco CO .,..,.
..J.c ~~~~~~ "':"':
I- ,...,....,....,...,... ...... ~~
......V(f')t--NMC\lCDm,....COvLnCO
CD -r-:~~"":~t--:CC!~~~~......~":
."'~M.,.IO.,.NCON,...OIOW~MOl
>.I~.OlM,...~COOlIO~CO,...~wwo
~~ OOl~.,.,....,.OlOMNOlIO.,.1O
~~~M~Mm~~~~~o~om<<i
~O~O.,.~OOlCOIOMN~Ol~IONM
E -C"\INI~,...,...,....,........
~c.c ..........,--
o >:Il!!.
c(
CJ
11...,
0.
z=
-ID
~
I-
,....,.CONOlMO~CO.,.,...O co
~,...COOIOOl.,.,...OlM~O ~
C"ici<cir--:ai...tNMlric:ir---:c:i 1,-
,.....COcncn'llltNCOIOC'\I.....cnO It)
MMNOlCO,...COMOCOOlN co
,....-cD~NN-r.OCOM.,..:Na:iT"'"- a)
cot--.....(")t--<e,.........ONM...... 0
~~ONNNO,...,....,.M.,. ~
"":"":NNNNN"":"":"":"":-r--
N
~~~...~...~~~~......~...
'i
~ II)
1&..
Cl l!
~~
~.n
I-
OIOM""""IOOCOCO~COO""O
MCO,.... oao t--C"')U')O'" CO OM"'"
'~~~~;t~~~~8~g~~
,....,.O.,.N~MM,...,...MOOlO
<li~Mom~~~N<liM<liO~
~~~~m~~~;~~~~~
...,.:..,.:..,.:..,.:..,.:..,.:..,.:..,.:.,..:~~ ci
N
C1tu=tM-M-.,.M-.,.~I.i9-.,.~.,.M-M-
N
10
..
S:
;11>>
~i
~.n
o
NOCOOO""MNN~WO
OOCO......OC)MOOOOO
lril"i":ai<'ir..:l"iocci-ioo
COWCOONIO~NOOlCOO
~""WOl~MOl"'COOCOO
~~~~grere~~::;~~
W
.C"!O
.,.~
M~
~M
~~
.,.~
...
'0
c:
............~.........~~~..........:g
OO"'~OM"" W~OlO
C\!~~~ClC!~~ 1,1,1,0000'"
,....,.OlCOIO,...,... o+ccilri
~~~~~~. ~~~~
N~NmriN .....~N.....
~~ .~~~
OlM
...
I.i9-~M~KM~~.,.M-MWM-M-~~~
__l.O<<:)(OON...-Il)COMlOO "'02
~~~""':C"!~~~~~~~ I 0
CO~MNIl)~v""''''-CDLOO ou)
;:::l!J~~~~~~cH:8lg MU
~~O~<<iO~NN~OO ~u
~1O~COOlNCON~NNIO IO~II 11.
.....<<:)~~~~~~~~~~ ~~'" ~
...-......__............T""...-____...... ~CM <
~ c: 0 0
c(~ 11.
+<( I-
Oz
~311 ffi
~ + :::I
~:;; ~
o~~ =:
.5: ~ 5: 9
E~} ....
~~Qj ~
"0> 0
.E:=e c
CD 0 c.. w
..........................................~~~ ~
,...OMO,...MOl~ON,...O,...~'6~~~~-G
~~~~~~CJ!~~~~~~~~~lI) ~ ~
~~~~~~~~~~;8~~~~o ~ ~
~~~~~~~~~~~~~~a;~~ ~ ~
~~~~.~~m~~::~~~lI)~Qj ~ c(
N____......____...... NCO~00 M ~
M ~~~; ~ ~
ou.t..;. D.
~.........~...~~...~............E+Q ... =
.. Q~ ~ II W
..cm~~w,...,...,...,...~,...,...,...~M~~..... 3
~~>999999919999--> ~ ~
..,o..tl>uc:.c..l:;;~c:-ClIg...- ... 11.
~:::E~oi!~~~~~~~~ll~ ~ ~
0.. I- Z 11.
..CD
II) II)
~ i
~~
I~ti
.., .
o
E ..
E]!
00
o
,
c
.2 III
1ii!!
~ ~
. ca
1I).c
GlO
It::
I-=-
~.I;
s ~!
c .0
O>.c
:::IoUl
I~
......~......~~~...~.........~
M'I"""'COlOO)__NOOOM.mNl.O
lOM.....COlOO)NM,.....N........-CQM
""":ai__""":C":iiCi..or--:.,j-ai.o"":u:iM
.LO__COClOvCOCOOll)t,t)(J)vCO
CO,....t---CONIl)COCO..-MMCOlO
~~M~~g~~N~~~t:tO
:s
""Ul-tltC:ltWofltfA.fn-U)t/tMW-fA-."..
c(
Cl
11...,
11..
..J=
-a;
~
I-
Ol~NCOMto-MNNW"'O N
CONO__.....aoCOC'OO)OOC)O CJ:!
........:ccicciaicciaiNai......:C":iO IN
NONIO.,.MOOlIO.,.OlIO .,.
__ClOCO"'lltNlO__.....M......I'CO IX)
~M~~~~~~mN~<<i 0
IOIO~.,.CO,...~IO~~IO~ ,...
,...
N
co
.0
.,.
o
I~<( Gl ~
OJ
~ a::
'" <3lh
~I--I--I--W
W Q)
,... .c
ll"i ::
N 0
~ ~
~ ~
m @n
>- <(..
5 C>J!!
.5; 0.. lI)
'-' .5 ~
c: <(~
.g U<(
"C Wu
~ 'OW
~ .....co
e! .!!(5
~ :gl-
.Q ~x
~ ~~
u> >-N
,... u.~
~ Ell
N ~t:
~ "-0
N "E:e
1U Q)O
;; .5 g.
lI) ..
~c..
~~
~
..;..
.l!!
o
z
~
'-.:.
g.-'-
~~
..0
-'"
Bo.
1ij~
o~
U
c;;
(5
I-lh
..................~...............~...
'i
~II)
1&..
11.~
=~
~.n
I-
NlOCOMVCD__NVMO"-NI'
NO)ClC)(f')__(OCOM__COCOCOCON
cri......:......coo.,j-u:iu;NaONu:iai
~;!m!::~8l~~l!J~~~;!l!J
~~g?j~ltii~~~~~~~
N ~
.,.
--------------------
fIIoMU!tu:t-Mt:I)u:.fhCA-M-fn-f;ltfhU.
N
~II)
'g!.
e ~
e]!
00
o
......CO(J),....('l')1' VCC-.;t lOC\lO
__NO)ON__oomNNNO
g&1~~rri~~;t~c;;tig
WOlCO""O~IO"'WMOIO
"":oiNcO"":"':riLl'i"':ocilli
"'M~N~IOIO"'''''''''''''
M
r..:
Ol
~
~
W
10
ON
OCO
0.0
,...~
CO,...
~
to-
OO~MMOOO
OO""'__NOI'O
oai<'i-i-ioailri
OIONO..-lOCOCO
O--C')OVC\!lO,.....
.0 ~M..,f~ ~
-- -- ('l") ('I')
~............~~~...~...... ... ...
~~~~m~:e~~~~a; ~
.. . lriailrir..:cci<'iaiocci":-i<'i .0
.. II) __,.....__mOmCONll)l.t)vlO N
. C NO.~OlOl""W~IO"'MN Ol
S~ ~~ ~
c ><
-w
M6'tMM II)U}W Ul-....6'9-ffl.,. ...
vMOO......MONO)U).a CO
CO\OIO~N,...OOlWOlOO M
OMVCO__(J)__(J)NCOcnO C;
WNOOlCOOl""M~MOlO
----'''It:C!~C!-;~C'!~C''!~ "!
----------------------- ~
1~8
'CO
~~
U.eIt...,.IItUtfhf;!tMfA."fflffl
..
c..,
0-
= 0
IllUl
o
O)LOO)ON__NCO.........Il1C
~~g~r::::~g~gctg
COIO""N"'O""W""~COO
~~~~gli~~::;~g~
.. Q
..c~~~~,...,...,...,...to-""to-""""M~
j~~999999999999-->
"'o..->oc:.c"l:;;~C:-~~"-
~~OoOCD"'Gl"'~"'~~~Glal'"
m~~ozQ""~~<(~""""<(mo..(5
0.. I-
m~
"0 t:f!
c: Bg>
.:g <( ...J'- 5"
os: ~
(5$ E eE
+0/1 lI)Q)alo..
2'<( iii~1;)1;)...J
:tj.co C:OI-"'~~:g,
lI)Uo.. .!2~
Cc:t: -Q)a..~~e!
~oEO o~.2="''''~
~~~ Gl 0"E O~~ 0
Qj + ~ Qjl g. ~ 5 S S ~
c:~ ~>w:::c:c:,g
-;.c'~ ~ <(..",,,,~
UU~ C:~(9'~€€€
1;)moQj<(>-c..g.~~"E
lh88~~lr~~~~~8
~
N
N
W
m
~
.,.
......,
......
.... 0
;N
E CIl
.s::CIl
u:.
i
:i!
l!!
~
II)
~
~
III
i
:i
..J
o
E...:
~.!~
wl::-
(!)~
z
000000000000
CD CD CD CD CD CD CD CD CD CD CD CD
...........................................................
cicicicicicicicicicicici
..........................................................................
000000000000
CD CD CD CD CD CD CD CD CD CD CD CD
............................................................
ocicicicicicicicicicici
(\") 0 ~ r::: 6) t::'lco S N N CO (\i'10)'
COOv,.....COCOO<oMClOMM.....
CIl~~~~M~NN~Ncici~M~o
~ l! ;~q~~~~:~nDS;~~gl:::::;
~ ~ ~ ~ ~ ~ cO ~::- g g ~ ~ ~ ~ ~
EOOM~~~..,~NN~....M,~
.s:: ~,-~~ - ~~I ~
:IC'A
CJ~~
.-::
.&:~~
=I!~
c CIl 0
o >.s::
:::EOU)
I::;:
C(
CJ
!!!
I-
Z
w
:::E
l-
I/)
:J
a
0(
z
o
~
~
0::
W
I/)
Z
o
CJ
>
(!)
0::
W
Z
W
~~~~~~~~~~~~~~
t:: ~ ...... CD N N ~ CD 0 10 101t:: 0> M
MIOCDOCDCD.NIO.O>CD...~
..;ci";";~~~N~M";";~~
0..... 0 I"--CO 1'0 0) U').....<Oo,.... C\I
NMO>......OCD......~IO............~M.
C"iairOrOrOOai06N06-i06r-:C"i
N '" '" I"'- 0 ... C"') (W') ('I') .....I~ ,... 0)
I~ ,... ~I-('I)(\")
~~~~~~~~~~~~~~
~'O
W~
5iii
o
I-
CD......O>.IOCDO>MO>MOOO>.
1.0 N,..... <D CD co CD 00 OM 0..... m
I NCO,....:CONCO,...:CW'i..Nu)C':iaia;
.....lO("I')O)COv.....I,t)CI)('I')O)Ot--O
OCD.O....IO~.CDNO>MO>
rDai-irDNrD06NrOo0606r-:o
0..... ",,.....O)CO"llt MC\I.....O 0..... co
..... ..... ,... .....,... ..... - ..... ..... ..... ..... ..... ('f) 0)_
...
~~~~~~~~~~~~~~
0( III
CJ CIl
Will
~ i
~W
~;::~l8~l8~~~:g~lO ~
~~~~~$~g~~~~I<<;
C'\IMLOMMNClO(J)O).....OU') "'lIt
aio06r-:-i0606rD0606o": r-:
N.....m..........CI)C'\IC>>cn,....NN co
('1')..... ............... N..... 1.0_
....
~~~~~~~~~~~~~~
N
M
.... CIl
III III
CIl C
s l
=~
.......NO>...~......CDOO.......
..........COON......MCO..COOCO
~g~~~ttig~~~~:g
O>OO......::J:OIO.N....O>IO
.,.:MC'?NNN~.,.:__-..... .,.:
~filttR-....fltw....filtfilt....fIiIt.... In-
III
E
~
it
C
o
~
CIl
u
>C
W
...
S
o
z
o N."lf"
~ ~~-~~ ~~~
a)V('f')U')r')COOO"","COO
tnCX)lI)lt)II)\l')r--:muiN<r-
~::d:~~~;1~Il).~
~~~~~~.!!~!~J!
Ull:JUuurlllrlrl'"
i1:"''''i1:'i1:>-u'''uu8
~88~~.2i1:'8>-~i1:'
E~>-EE~%>-~%%
w.2.2WWWE.2EEE
o~~"":..;oW~WWW
q~W~~~~gUJ o~g
;;~~;~;~~~;~
> > > > > > > > > > >
~~~~~~~~~~~
~~~~~~~~;tg~
00,..... U)T"""CJ) CJ)Q),.....CON
T"""-CD-<r--M"":ll)-ctiN"":OC")
C'\IU)NIoI)\l)N"""U)(I')MN
<g<g <g<g<g<g<g <g<g<g<g
E E E E E E E E E E E
e e e e e e e e e e e
a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a..
""vO,.....",OCDC>>C>>CO,...O
COU')l()""CD,...CCCO,...C>>C\lO
ciN";~~NN";~~~ci
~~~l;;~N~~:gg~g
r-:r-:N-i":M-i06-i-iaio
C\lOcn,...,...CONC>>CJ)""",...C\l
C"'),... ,...,...,... N,...
...
s :
i l!!
~ ~
III >c
8w
~~~~~~~~~~~~ ~
~ 0
~~~~CD~........................~........................MI-
~1:>9999999~9099,...>
~Oou~~;~~9~53~~~~
m:::E~Ozo~~~c~~~cw~~
~ I-
<=:'
~
o
.c
W
~~
1::10
-ile
0(":
frl~
o
i
~~
CD
~
C II
U"C
w~
~.!
-fI)
'0 ;
~-=
...CD
I~~
c l.'l
~-6
c:E
~3
CDE
"0 :::I
..9!0
oE
ul'll
cE
u:::l
w.E
- )(
o I'll
~~
fI) CD
f!~
l-
II
~
CD
I'='
.
....
~
......
....
M
N
......cnCD
O~...
.o~ci
............M
CD...M
~-i~
ON ...
......
CD
:;;~~~
~
-
o
g
-611~
~~~
u~l8
+~.
ON06
IO~O>
IO_N
cOO,,?
MlI::....
~OCD
'O.!g
1.2 ~ ~
u......O>
I::ON
E(O~II
~~~~
~~EE
2+u;u;
I~O:E:E
:v~~~
-6~:g:g
Cii;!!.9!
~ '- .- "I::
~~~::
II) coo
CD~Ww
~:~ ~~
00>->
-=+~~
I~ I~I~
~ ~~
......
....
~
"1
.
~
~
....
I
I
;}W;<::r
0000 0 o'......:_:~o 0 0 0 0
""""""""""""1" -00000
~ ~ ~ ~ ~ C!::,';~ C! C! ~ C!
0000001" )00000
~ ~ ~ ~ ~ ~~.,:.:.,~. ~g g g g g
000000': :000 0 0
cicicicicici~cicicicici
. ~~~~~~~~~~~~~~
.~~C\I~""~C"')C"')CDO~oO""""""
~l!!~m::;R~~~~:g~~~88
i~io~o~w~~N~om~~~
:I0~c>>~mmo""NNNN""""""""
E 0 ,...,...~,...,...,...,...,...,...,...
c~
ci~!!!
10
N
ci
N
0>
rD
~
....
...
~
II
W
U
U
CD
z
E...:
0( CIl III
_.s::(!)
wl::-
(!)~
z
-=
.&:1 ~ ~
fil!!
c Gl 0
o>~
:::EoU)
I;;:;
C(
~
I-
Z
w
:::E
I-
U)
:J
'"")
C
0(
Z
o
~
in
o
Q.
!
..J
~
Z
w
:::E
z
o
0::
:>
z
w
M..W-WfA-MIR-..6lltW-tI)-C:.'9-C:.'9-tR-
(0101l)C"')C\lOmN,...NOO LO
~~~~~~~:~ci;;dl~
............MN............IO........................O CD
M_CD_M_CC!.IO."1CC!.Ie!Ie! ....Ie! 10. 0>
I~ 10 ...... CD CD O>,~ I~ t:.. g
W-W-EltW-..M.,.utW-W-CltutlR-tR-
0(
-'0
W CIl
~=
om
I-
,.....1.OU')('I')C'\lOO)C'\I,...NO
coCOCW')(CCJ)Il),...O)MN,...
";"":cO~~..;~,~,~N,t:: 0
CD 10 CD 0> 0> ~ 0, -, - ~, -
:6~:6~~o~
.... ....
~~~~~~~~~~~~~~
~:
Will
~:~
o >c
~w
MOOOOOOOOOOO M
NOOOMONOOOOO ......
"":NNNoNcDNNcOC'oio',.....:
IO......IO......N...................~......O ......
NC>>Nm~m..,.Q)C>>...-O)lt') LO
"':"':N~ ~r--.-ci
... M
~fA-MK-Cltf:A.6l9-.,.W-~.,.fA-'4W
.... CD
" III
CIl c
il
=~
I I I I I I I I I I , I I ,
~W-ER-MW6lltCf9W-6l9-EA-6l9-WW-W-
"
E
~
it
c
o
~
CIl
U
~
..
S
o
z
...
CD III
.... CIl
C III
~I~
r:l >c
CJW
MOOOOOOOOOOO
NOOOMONOOOOO
~NNNciN~NN~Nci
~S;~b;~S;;S;S;~Si~
~ .,.: N"': ,...,..:
...
~~~~~~~~~~~~ ~
~ 0
$~~~~~......................................................M~
~~>999999999099,...>
~o~->oc~~~~c~o~~-
:I:::E080CDI'llCD~~I'll:::l:::l:::lCDCDI'll
m ~ zo~~ c~~~cw~~
CD
M
'.0
.
10_
~
M
N
..;
CD
N
o
...
~
M
......
~
......
10
o
M
0
0
0
0
...
~
~
I'll
.c
U
I::
'E II
"CM
c{N
~..;
.ECD
fl)N
~
I~-
~ 0
"'lI::
-6 0 0
Ql
CO~ 10
:::I ~ N
I:: 3 0>
I:: CD N
"'0 0
fI)- N
CD 10
"CO
-51t
I:: + ~
I- II
~ W
U
U
CD
z
~
......,
~c
i'"
E Gl
~m
u:.
~
:E
I!!
rn
>-
rn
~
CI
iii:
w
I-
~
a:
:i
...
o
E
..
its
jeii
~Jl~
t:a.
CI..J
Z
000000
000000
":":":":":":
T"'" T"'"...... T"'"..... T"'"
000000
<0<0<0<0<0<0
~~~~~~
T"'"..... T"'" '1"""..........
000
0)0)0)
000
~ci~
000
<0<0<0
C\!C\!C\!
...... ...
GI ~~~~~~~~~~C2!~~~
.~~O)~v~...~v<O~~~NMo)
>m!o)~"''''~O'''N<ON'''N'''o)
~~=~<OO~O~<OMOOO..,~~
~~~~t~g~~~lci~~~~g~
EOo~~~~~e~ "'<Oo)~~~
~cm MMN..... ...............
o~-
.",.'
~!.~
= i! ~
C . 0
o>~
::&00
.....
<(
iii
+
~
w
+
:.!
CI
a.
~
..
o
aI
o
W
o
;:)
~
o
~
Z
w
::E
~
o
;:)
..,
o
<(
~
~
o
o
w
~
~
o
o
o
..J
..J
<(
..J
~
o
~
..........................................
m'l""'"M......l.OoC>>'l!tt--O)COMOT"'"
~<OO)~~vM~~N..,MOv
oOM.ncOcOcioOMcir-:cO"':cOoO
J:::C1i~~~~~~:ig~~:ll~
rDrDrD"':McitriMciN"rDMaiN"
8~~a;m~~~c;;~~M('I)~
~ ...:
64",*,64Wfl)MM64"6461lt619-64~"
~
>
8a:
.-
~=
_a1
.l!
o
~
a;~~!;t~~~~~OMg~~
'ccio""":aic:ilri-=crir--:Nocwiaici
~~~~~:e:g~~~:g:g~~
"':rD"':rD"':MN"-irDIl'iMM"':M
cg~~~f&~~~~~~::g~:;
"":"":N"NNNN"":"":"":"-:"-: -.i
N
....
II)
-GI
<(II)
ji
~~
O.,-......COvCO'lllltIl).....C'\I('I'),.....m......
I'o1l).....m.....NMcoco......cnCO.....O
l;e~~~~~~~~;tg~gf?j
T"'"oot--."r--.cor---""ltm.................cnM
i,aiMrD"':N"rD"':"':M-ici"':ci
<ON$~~:i~g~~~:~n~~
."f"":"":"":"":"":"":"":"'-:"":"":"-: N
N
....
.. 0
!=m~~~~~~~~~~~~~~
~C>IIII'III..:....191..!.. >
~oou~~;~~9'~53~~~m
a1::E~OZo..,~~<(~..,..,em~~
~ ~
>+11~ ~1~P;,
00000 o'lio 0./:,,;;0 0
oooooottil~(")C"'):' .'00
000000'1'00'00
e e e 1:2 e e:,i':<.~,s2 e_,:,',:':/e e
g g g g g g,'g gag g
~ ~ ~ ~ ~ ~ ",~,;,'~ ~',;~,',~ ~
00000 o'Ci'o o~'o 0
~? J~j ;::iTI~
i5 i5 0' S ~ ~ ~ ;:; ;::': 0 0
tit ~~~~~~~~"lf:C!~~~1
CD ~I"'="..... ..... ..... ..... 0 0 0 m 0 co 0 co <0
~ l!1;NNNN~~~~~~;~~
~~t~~~~~~~~~~~~~
~QI:. ~ ~~~~
o ~I!!.
...
...
~
cO
o
~
Il'i
<0
<0
M
...
II
rn
Gl
UI
:>
<ll
U
'E
Gl
E
..
~
~
2
~
~
'0
!!!
!l!
~ i
UI
Gl--Z
~ Q
~ ~
~ ~
m :i
~ ~
'C ~
~ Z
--~
e w
- J:
o ~
- <(
~ ~
iig
~ nl
t:CI
CIa:
Z..J
1-:- '
2:~~
=l!-r!
cGlo
o>~
::&O(/)
I::':'
.....................................u=........w..
<0
, I.t:! I
0)
:::
I.O(J)..-mco
1":~I.t:!~~1
00) co (!; v
~~:e"'I~
OM""':
<0 ~ ~
.....w........................,.~w-w~w..........
E
..
GI
~
S
000
..,..,..,
I I I I I 1000 I I I
cicici
.
e
GI
~
~
CI
Z
f'ooo.f'ooo...-CONC")..-CO~~~O
ClON(J)CON..........CO..-O'Jf'ooo.O
~o)~o)..,O..,CO~N~O
cirDci"':rDN"cOcirDrDMci
~~~N...~~v~<oO)o
~COO)""'N..-(J)""CO~('f')~
~~~NNN~"':""':""':~-""':""':
000
..,..,..,
I I I I I 1000 I I I
cicici
c
.2
ii
~
- .
II) II)
. c
.. !
S;:t
'=w
......,.w....ww................~w.....
II)
c
.2
ii
CI
a.
..J
o)l.Oo)ON..-NClO..-~",O
r...:a:iM......:...:r...:M..nLl'i..c:i
COCOCOltlf'ooo."-..-OO"""'OtDO
~~~NvO~<O~<O~O
~~~~g~~~~lifg'~
.~~<o<o<o~~~~~~~~~..,o
:~'voooooooooooo.....~
-aCaJ1>OI 111.t...1 I..!..' >-
~O~UOGl;~~19~5S~~~m
a1::&~ozo..,~~e~..,..,em~~
al f-
~
o
o
{:::!
~
...
en
't:.i
.l!!
<ll
-g
::>
..
<ll
-'
00
00
cOr-:
~ 0)
..,~
aiar>
C~
~
~
<0
rD
...
"!
...
N
en
Gl
'C:
..
~--
.f:
Cij
a;
~
o/l
<ll
,!,!
.~
c:
~--
o
~--
N
<0
N
N
<0
ai
co
v
...
N
cO
N
...
...
u
~
(5
o
Bf------
.!!!
a;
Cl
~
~
~
l!'
.
10 f-+-
..
<ll
~
o
...
c:
<ll
~
UI
o
o
J:
~e
3:(!)
J!!~
~(!)
c:Z
00
'0-
Ql ~
UI c:
~.!!!
-<ll
m.o
'Ew
0>-
~~-
me
~~
-
'00
Gl ..
[~
g;
ot=
~......
:::~
... ~ '" ~Ie "'0 "'~ "''''0
.... "'.... "'''' o~ NN'"
..,..: ""':cd acicti rQcQ mea cococ:o
Cl:
8!
~~
c.
"'''' "'''' "'''' "'''' "'''' "''''
....
gi
:!:!~
cZc.
~~
..
..-
:11
1l=
~Cl
00 00 00 00 00 g8
00 00 g8 8g 00
00 00 00 00
!l NO ,..:,..: lti.,.: f3ici ~~ arrvi
"'N "'''' ~~ ~~ ~~
~N NN
o~
1Ilc.
~~
:!:!'G
oct
III
8g 00 88 00 88 00
00 00 00
00 00 00 00 00 00
.. ~~ ~,..: wi"": 0;0 an. Iti.n
.. "'''' ~~ ~t:: ~~ ~~
II ~N NN
t,!Cl
"
Do
8 00 00 88 00 goo
00 00 00 00
0 ~~ gg ciQ ~~ goo
0 00 00
0 0'" 00 ..........
1: i~ 16~ ~t:: a)~ ~~ NNcO
..
E u
..
.!!
"
... "'''' "'... "'''' "'''' "'''' ......
.5
l 8 gg 88 gg 00 8go
00
b- 0 00 00 00 C!o.~
i> 0 cid go cid "':ei ~~~
..'" "'''' '" "'''' "''''N
11 E
.. "
u ~
<00 00 00 00 00 8g
~8 00 ~8 g8 00
00 00 00
i~ c:ici willi ":ui anN "':Iri
....:; ~'" ::~ ...~ N'" "'....
.:is
00 gg gg go 00 ~~
00 ",!ij! 0'"
"'''' 0'" '" ID
'GB anN ;;;~ ri"': ~~ dei ~g
~N ....'"
il
0';
Uz
ID 0 ID ~ OlD 0 ID :go
"'''' ~~ <0 ~ '" ID .... '" ...3
....... NN ID N ....... .... ....
"":ri villi ...16 tri..: ~ ; "":0
....'" "'''' ....'" "'.. ......
N
~ ~
I
.
U
'G IDO '" ~ PJ '" 0 ~ 0 N NO
1: "'... ID ID ... <0 N ~ ID
....'" ... ... ... '" N '" N'"
e ~g ~ ~ :8 Iti Iti ~ .,; ~ ~~
0 ;;; N '"
U ~ ~'" '" '" N
...
o
o
~
~
'0
..
..
r1
1t;
\..
\)
~
/....
Q:.
..co
8~
:: !
C) 0
l!1
.a 2"
~e:
cnii
o.a
U.:l
~q~~~99~~q~~ I
tqilH-5lii;l!i~~:;g.~ ....
OZO-'IL~<::E-,-'crn
ID
C>
cD
'"
8tit~~~{g~~~S;o;g
::IN.....:~...:.ncri~Nco~,...:
-.. m::; ~~~~~C;~~~~.~~
e~..........oo",,,,,,,,,,<o.......
o=f1'oo..."'oo......"'..."'...oooo
....iil~ "!"!"'.C!"!.........,"t"!"!"!"!
;;w~;;:;;:;:;";;;;;
c;
~
i
i~~~~~~~~~~~~
'3 ~~"''''.......'''~'''N''''''
-oCs.i5a:tClCDCDCO."CCQiOOCOClOCO
III 1;,'"
0...,
...JILa:
o
1
:1-
g
!
';/!-';/!-';/!-';/!-';/!-';/!-';/!-';/!-';/!-';/!-';/!-';/!-
s:;....,...COCQ."COet.....C'J.O."
.!!'licOmp;r;cd-':OJiC"imci"":
"0 0 iCDdD...............U).....~~O'I~Q)
~1l'!!
...JlL~
1
C>
C>
C>
o
.
N
...
" 88~888888888
-I! C>o<O"''''''':ll~'''o''''''
cf;!:i~l8~C!io"'l;;:;ll;;l;;
ffiE~.....oia:ig~oir;Q,..:<<iuicDu;
LA.. 8,...
. ..
en.
.
:E
tllttltW_tl'I'.,.Wf;&.,.....,.....
C>
c~g;~~~~i!~:!;~lli~
o,.......nCl)mC"')c>>C'\IC"),........-
8E~~~~~~~m.~~~~
ul~~~u;~:n~.~~~~
aa:
.r~
!!::
.,.....W-M..".Mt4..".~f:I't~~
C>
8
::
N
N
l!
~e
S II
rsi
:E,S
:i!
WWW..,.fiWvtWW....""...
6'
co
!
~
~
."'..."'."'Ul......"''''~O
1I~U!C!l'IlI!~ClC!<<!~~C!~~
itnN!5!N&D~l"')O&D~r-..r-..
ii::?~;niU;c>>:t~~i~:g
"ii~.n..."'o....ltio<ri..:<rirD<ri
.u;=m~cftNN..........m&D~OO
~i-~'lf:~llOct~~ C'I!C'I!
E
E
o
O.......".__w""...,.Wtlt
i
t
!:!.
;;OPJl!ll!l=8PJo;l8o;c;;:fl
;<=sf.li[lj[ljm~f.lis~ssR
N.!= ct~~~---:~C'tC!.CDO.~Q)
,;ulll
r;: Ii
::l
WMW""W~W"''''WMW
Il:
N
...
...
'"
Sjlll~;!:;;;:;:gSjihl;l~ih
~ .ncO..tC'ioicOcONcric:Oooi
.;=::! t; ~ ~ C; ~ ~ g ~ r:: 13 ~
J;GICJai"':o)CJi"':~crillill'i.n.n
tll.
r~
::l
M..__MW.,...".....WWW
co
~
,,;
...
N
~:e~:e8~:eg:e~~;e
~~~~~~~~~~~~
r-.......\IlMOU)__(QU)U)U)U)
....:NN..: .
.
II
eo
':"ti~
e~z
~
o
z
tfl't6f9....M........W......
...
'"
...
o
Ii;
f;;to~~~~~Si~S;S;~
:::~~~c;corriGi,;I~~<<i
N= ~.C!~.....~-.;.C!~.C!~.~.~
.~!i~.~~~~;~M~~r;
1:1&: ~
..
II
II: ".........""_""w....
o
i ~~~:gN:g~~~~~~
~ ~~gg:8g~lligjllilligj
I: =...NNN.....NUJO.....OO.....
ri!:il~~~~~~ric;:gc;~:g
I-ftI .....-...............
...~
...
...
"!.
:
N
M...""......"''''WMWEtlItW
r-..r-..""'qGOcococococococo
t~~ffi~~l~~~~~ i
OZO-'IL::E<l:::E-,-'<l:r'l ....
...
..
~
...
...
,.;
~
.
;;
~
...
~
..
&;
,,;
.
..
Il!
;
...
'"
...
=
=i
'"
i
...
...
...
fD
::
...
i
~
...
C>
"':
...
.
...
~
...
...
.
...
...
.
;t
...
1ft
:!
~
~
...
~
N
...
i
on
...
J
{
..
...
'"
~
Cl ,..:
o ...
U
~
g
C>
i~
:rIot
........
Ot,!
"
Do
...
... ":
~ ::
.. -.;.
1'1'"
DoU:t
i ~
....
:g
:al:i
~C!
e:e
0"
u...
i
....'"
efD
oil!
.,..
~~
..~
!:
!
o
....
5
c:
o
:E
Ul
~
'"
N
N
cO
...
GO
o
oci
*
C>
co
co
,,;
...
'"
C>
co
co
o
'"
N
...
...
C>
i
..
...
'"
...
'"
...
...
~
...
,.;
:;
..
~
'"
...
...
:i
...
:
.
...:
..
...
.,;
.
...
i
~
...
'"
~
,.;
:g
'"
C>
!
N
...
"t
~
...
..
C>
..
...
2
c
o
:E
Ul
-g
N
~
o
t--
It rr1u:'IMv,.Jr fJ..3
Propane Weighted Average Cost of Gas (WACOG)
FY 2006-07
9/10/2007
I
Sea-3 Invi'ic~&L Shlooino
Propane
Cost
Shipping
Cost
Cost of
Inventorv
Total
Cost
FYTD
Gallons
Gallons
Delivered
Propane
Rate
Date
Comoan
109/30/06
11 0/25/Q6
~0/31/06
, 10/31106
: 11/25/06
111/25106
11/30/06
11/30/06
!12/16/06
, 12/19/06
112/23/06
12/31/06
[12/31106
112/31/06
r 01/16107
101/31/07
l01t31/07
101/31/07
[02/07107
r 02/26/07 ~-
02/28/07
[02/28/07
,fJ_~/07/07
103/31/07
r~3/31/07
04/03/07
04/26/07
04/30/07
104/30/07
~5/09/07
05111/07
05/31/07
'05/31/07
L 06/05107
i 06/30107
106/30/07
lQII06I07
1 07/09/07
,07/31107
107/31/07
~08/15107
~/31/07
L Q8/31/07
I
$ 91457.13
1.06307 $ 40799.54 $ 914.27 $ 41,713.81 39,239.0 $ 133,170.94
$ $ 1 S $ 133,170.94
5. -..-: ;'ki-J?'I<H,r,iHt,'t~~t: ";"_-; 'i::l" '1;:::"",,:.'" - i-;_:^ S 86408.64
$ 29,924.92 $ 68!l!l_~ _~._. 30,805.59 66,452.0 $ 117 014.23
$ 9419.08 $ 214.24 , $ 9,633.32 77 647.0 $ 126,647.55
$ 561.56 S 561.56 $ 127,209.11
',"''''':;-(;.'';%'';[.''11.. i!,~~",'..L',,;';V '..r"" $ 81269.22
1.11327 S 20850.05 $ 445.30 S 21 095.35 96,596.0 $ 102,364.57
1.11327 $ 20,652.23 $ 445.35 S 21097.58 115547.0 $ 123462.15
1.11327 $ 10618.72 $ 228.98 S 1n647.70 125291.0 $ 134,309.85
0.03712 $;:"~ig"f~~~4;al;:;::~::,:w, S ~ ;, :::,291~ t~mE.~~
'f~1;~204 $ ~;~i0'k;~;,,1,~,: ___~,~~~c;;.ll-l~~~;c~ l_:~,:~:
$ S - $ $ 89682.08
~:ll:r~-;{.~:~>::' ':'f:-- >-:S:;~,,'--<,;,;~r~fi~'!-1,,~iJr~ Lm:;:l/ :',:.. '::'. $ 33749.04
38,838.29 S 854.80 $ 39693.09 190,930.0 $ 73,442.13
19,83898 $ 438.52 $ 20,277.50 209,832.0 $ 93,719.63
230.11 S S 230.11 $ 93949.74
, ~;._" $ 30 025.27
50,861.69 $ 1103.37 $ 51.965.06 256,764.Q.. ~,990.33
455.01 S S 45501 $ I!.~
'~i';Z:,. lJi.."",,,, H. $ 16840.12
45204.08 $ 916.55 $ 46,120.63 ~~1~~~,960.75
11258.80 $ 228.28 $ 11487.08 304 933.0 $ 74447.83
174.13 S S 17~ 1~ $ 74,621.96
>.A;;,' "1i;!;[~,'io;.ii>.' ,..;. $ 21 925,82
35916.09 S 887.72 S 36,603.81 333708.0 S 58,529.63
11,860.11 $ 227.10 S 12J087.21 343210.0 $ 70816.64
549.28 $ 3.10 , $ 552.38 S 71 169.22
"'~1k,,~.,-,,,J,i -id""",;i. ,,,";le ,Ljii> ;o';'ie:;~~ $ 2~243.03
$ 925.62 $ 49498.37 3;11:-939.0 $ 73 741.40
. 31.20 $ 73,772.60
;>Y~l!;o!'i:'Yu,.;'; " Ai j:,'!i<I!\!+.;E[',' $ 28 385.26
$ 224.64 $ 11,905.92 391,338.0 $ 40291.18
S 685~!lIl... S .___.3.6~04.76_." 420,040.0 S 76,695.94
$ 174.29 S 76,870.23
;~::'~~.4l'.\(!if:jf(::- ~ ,.1> $ 38 695.48
51824.67 $ 946.39 S g.E.L~_ __.1~9,83l!.J1.. $ 91,468.54
2016.45 $ 2016.45 S 93482.99
._~~~'\t::;~0';1!;l~~:.;f: i::';~~-1~~;. v' $ 41962.98
--~
Sea-3 4006-0864
!IIDNTHL Y INVENTORY ADJUSTMENT
END OF MONTH .....: _ :,>':NI;;'I;.1
Sea-3 14006-944 83404 83472
Sea-3 4006-969 83689
!IIDNTHL Y INVENTORY ADJUSTMENT
END OF MONTH -'YC;~ < \
Sea-3 4006-1014
Sea-3 14006-1035
Sea-3 4006-1074
INVENTORY ADJUSTMENT
fII0NTHL Y INVENTORY ADJUSTMENT
END OF MONTH
Sea-3 14007,0047 185016,85118, 8S:
INVENTORY ADJUSTMENT 1
fII0NTHL Y INVENTORY ADJ~~I!';,~I..._..~, ". ~'V,,_,.,....,r.~byp',,';7@ , '
END OF MONTH ';"""",..""..,..,.."o.~_ ."..<:."","",",."." :.,,,.t!"'..,,
Sea-3 4007-0108 185862,85873 37,004 1.07267 $
Sea-3 14007-0158,0181 186308 66403 18,902 1.07277 $
MONTHLY INVENTORY ADJUSTMENT 197 1.16807 S
END OF MONTH I!\ J'!Jir:~'; .. _ _
Sea-3 4007-0216 186929 86850
fII0NTHL Y INVENTORY ADJUSTMENT
END OF MONTH
Sea-3 4007-0297
Sea-3 4007-0349
MONTHLY INVENTORY ADJUSTMENT
END OF P.10NTH
Sea-3 4007-0389 88621 28,77_5 1.27207 $
Sea-3 4007-0407 1 88688 9,502 1.27207 $
MONTHLY INVENTORY ADJUSTMENT 397 1.39139 $
END OF MONTH ,"'fji''!l'~};4L'1'.;::; ",ii';.,,";A
Sea-3 4007-0466 189427,89390 38,729 1.27807 $
MONTHLY INVENTORY ADJUSTMENT 144 0.21867
END OF MONTH :>h"''):; ~~t:it> ;~~'i':1' i' }M*+~t-t :S41ii~ '~ -'!;:,;iU;j~~!ji4
Sea-3 4007-0537 -I 90198 9,399 1.26672 $
Sea.3 4007-0555 '90242 86 90308 28,702 1.26837 $
~~~~~L~~~.;.NTORY ADJUSTMENT 1~ l&~~;~~~:"'~
Sea-3 4007-0636 91024,91033 1 39,598 1.33267 $
MONTHLY INVENTORY ADJUSTMENT 1153 1.74887 S
END OF MONTH ,{#*t01i:~;v:;;;;;;,;';~~lt!1_k,-,;~;:~p~!.;t4::'^,~ __->t~,~~;:__~;$
--+
523 382 $ 10 840.00
39 239
29,213
9195
379
1.04787
1.04787
1.48189
64334
64404
64537
18,949
18951
9,744
24715
375
~~tj;..k't-:~~j-.t,~i:;,~-
28,635
46,952
247
1.10677 $
1.64215 $
~.'
"l'lo'
87653, l!.7569
88251 ,
38,548
9601
263
1.19645 $
1.19645 S
0.68209 $
48 572.75
31.20
?~i}
11,681.28
35,718,78
174.29
:FYTDTotals
459 ijjjj
518902
1,12894
I
Proiections
Delivered
~'YMEX. ..... . eGS C()st . Gal Delivered Inventory Cost
Aug-07 '~~&:~i~'~(:!~~\lf'D1\;~IlM!~,.ii 32,303 $ 41 ,962.98
.J_~1?>flh ~, ,^'5,"lEC--a~""".~~,~- """m
Sep-07 1.21 1.33 40,000 $ 53,200.00
Oct-07 1.26 1.38 48,000 $ 66,240.00
Nov-07 1.26 1.39 50,000 $ 69,500.00
Dec-07 1.27 1.40 50,000 $ 70,000.00
Projected
WACOG
1.30
1.32
1.34
1.36
1.37
Tank Tank WACOG
InventolY Withdraw!
75 480 1.21167
114,719 1,16084
114.719 1,16084
74436 40 283 1.16084
103 849 1.12895
112,844 -~
113223 1,12353
72 334 40 889 1.12353
91,283 1.12140
110234 1.12000
119,978 1,11945
95 283 1.40988
95,638 1 .40450
53106 42 532 1.40450
81,741 1.28453
81741 1.09715
81,819 1.09610
30 790 51029 1.09610
67 794 1,083_:u..
88,696 1,08101 I
86,893 _ 1,08121 I
27 770 59123 1.08121
74,722 1.09727
74969 1,09973
15313 59 656 1.09973
53,861 1,16895
63 462_ -~
63 725 1.17100
18724 45001 1.17100
47 499 1,23223
57,001 1.23887
57 398 1,23992
19552 37 846 1.23992
58281 1.26527
58 425 1.26269
22 480 35 945 1.26269
31,879 1.26388
60581 12~~
62,004 1.23976
31212 30 792 1.23976
70810 1.29172
71,963 1.29904~
32 303 39 660 . 1..29904
_..0. ----I
----j
CSW08l2712007
ATTACHMENT #4
Page 1 of2
PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS
FOR THE BILLING PERIOD OF 10/01/2007 - 09/30/2008
I. Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible &
Contract (Non-Standard) Rate Schedule PGA (See attached Page 2)
II. Calculation ofthe Required Natural Gas PGA WACOG for FY 07/08
A. Therm Sales Projection for 10/1/07 - 9/30/08 =
B. Projected NG ReselVation Cost 10/1107 - 9/30/08 = $
Projected NG Commodity Cost 10/1107 - 9130/08 = $
Budgeted Other Supply Related Expenses = $
Total Recovery Needed for FY 07/08 only = $
100% of Under Recovery of FYTD PGA thru 9/07 = $
Total Annualized Recovery Needed for FY 07/08 = $
C. Required Weighted Average Recovery CostlTherm = $
Currently overall PGA Recovery is:
Therefore, Contract PGA needs to bE $
Which makes Standard PGA: $
=
$0.080
22,800,000
1,400,000
17,100,000
3,600,000
22,100,000
22,100,000
0.969
94.6% of Contract Rate
1.02
1.10
D. Projected NG PGA Annual Revenue =
Pinellas NG PGA =
Pasco NG PGA =
Total NG PGA =
$ 19,269,765
$ 2,830,235
$ 22,100,000
III. Proposed Natural Gas PGA Billing Factors for 10101/07 - 09/30/0E
A. Proposed Standard Rate PGA Billing Factor $
B. Less Non-Standard Differential for ReselVation Cost $
C. Proposed Non-Standard PGA Billing Factor $
IV. Proposed LP Gas Billing Factors for 10/01/07 - 09130/08 $
(Assumes current LP market conditions persist)
Note: Includes 6 cents/gallon catch-up to recoup
$30,000 under-recovery from 550,000 gallons over the
year & 37 cents/gallon to recoup the $200,000 of Admin
& CCS projected charges. Base est. was $1.39/gallon.
U:\My DocumenlslEXCELlGASRATESlFY 07~PGA for FY OHI8.xls]PGACALC
PGA Only ECA in PGA Total PGA
1.10 $ 0.09 $ 1.19
(0.08) $ $ (0.08)
1.02 $ 0.09 $ 1.11
PGA Onlv. ECA in PGA Total PGA
1.82 $ 0.09 $ 1.91
;;~
1-0
ZN
WGl
~Q
l:lU
Ull.
~
c(
w....
:Eo
0::0
Wt:!
~E
0....
o::~
<(GO
"",00
"'zo
I!!~~
~UjI~
WZo
wOo::
<(ZO
eJujl&.
o::>w
WOW
1-0::
~<(o::
~o~
<(Zo
uJ~
..Jw
01&.1=
04(
!!~
~w
..Jw
<(0::
~..,
...
o
o
S
~
8
~
o
CD
:is
~i.
~ E il
E' .s .c
!.51-
0':
o
Z
~'2
&,1~
... c
lUSI-
c3W
:i"1
'21
.. III
CD'CI
Zj.c
wI-
S''2
sa,1
.QZc
:I:.!!S
WoW
'2
S,11
o c
liS.
:I"1L-
wc..--
o
Z
vCO....NCOONIlOI.I')OO)V
88l:;~~~:g~:gl:;88
c:ic:ic:ic:ic:ic:ic:ic:ic:ic:ic:ic:i
toIttolttolttolttolttolttolttolttolttolttolttolt
~?l~:g~!::~:g~g:lEl~
~""''''''N'''''''''''''''''''''''''"",,,,,,,,,,,
c:ic:ic:ic:ic:ic:ic:ic:ic:ic:ic:ic:i
toIttolttolttolttolttolttolttolttolttolttolttolt
'~I
1ii
~
.
:0
0::
N......... 0 MO....MO)..... ON
N......... 0 MI.I')1lO 1.1')0) CO 0.....
cci r--:cciccir--:.o"':.occi cO cON
MllOlI')..........I.I')MvMI.I')OM
....MlI')MO)M....COCO.....O)IlO
tci~~lili18~18~~gtci
......................... ......
toIttolttolttolttolttolttolttolttolttolttolttolt
~~~~~~~~~~~~
vNCOCOO)MN.....IlOCOvO
l5tl5t{:i{:i~~~~~~~~
O)~~~~:g~~:~n~;:!:!::
~Vl.l')lI')........VCOI.I')NOCO
"':"":cO&e)oio('l)~o)"":~"":
MNI.I')MNvNO)NOCOCO
1.1') 1.1') 1.1') COIlO 0) qO) co.... CO 1.1')
~~~~~~~~~~~~
COllOvv.........COO)NVCOO
MMNNcci.oMMccicricric:i
COCOCOCOI.I')I.I')I.I')I.I')I.I')I.I')lI')CO
M....lI')OO)MClOI.I')CO:lO....
:gC;?l~~~m[;;~~~~
aiai~M...:...:NO<DMonO
NNN I.I')I.I')ClOo) CO 1.1') MO CO
CD Q) CD C!. "": or:. ....... "": ........ ~ o. co
.........................................
"I
';Je~~~~~~~~~';Je~
Nm...............(')U")CONQ)O)<O
l5t~~~l5t~~~~~~~
II
0) 1.1') co........ MO)O).... COClO M
COO.........MO)I.I')N 0""0) CO
COO..... 1.1')"" ClOO 1.1') 1.1')1.1')"" 0)
~g~~t~m8~~~~
1.I')1.I')1.I')1.I')........CO....COI.I')lI'lv
"I
'#.'#.'#.';Je'#.'#.'#.'#.';Je';Je';Je~
vClOvMOvM..........CO.....v
"":cO......:.....:t\i-=N"";-.i-Lt:iati......:
NNNNNNNNNNNN
.
1m
s!l
.5
~~g:~~O~CO~:gN~
OlO.....IlOV;:t;ClO~NClO(f;v
g~:gg~figfi~~li~
vvvvvvvvvv....v
)1
~:elO~o;gn~~::~~d';
.....vClOOlCOo)MOMCOll'lN
"':l8g~g~~&fl8~g~
!SVVCOO).....N.....O)....lDV
~.....-.,.:~.,.:NNN.,.:.,.:r--.,.:
l!1
lD:E
COCOCOCOCO.....................,....
ooooooooogo....
~~~~~~~H3~N~g
QQ.a > 0 c:.Cl lii ~ ~c:N
~~o~~~~~~~~~
,.
N
UI
CD
o
o
-
....
II)
....
o
-
-
II)
o
cD
CD
....
N
CD
<'t
....
~
CO'!
....
v
CD:.!!
",f'i
N .
.....
Nv
~
fIIi
:.!!
Zo
cci
II)
r--~
v.
~a;
ID II)
CD
II)
N
....
~
....
:(
a.~
N....
.......j
v'"
....
'"
,..:
~
UI
.j
N
co~
....UI
o'
.v
~N
N
on
II)~
IDO
CO? .
.0
00
~....
....
N
....
~
cbS
00
co I-
s'S
~~
N
M
co
o
c:i
'ii
~ E
00
1&.0
CO?
o
o
o
~
-
o
co
.....
c:i
c:;-
o
o
e.
~
-
Cl)
N
.0
v
o
M
co
M.
CD'#.
.... ....
ON
v
....
a>
N
toIt
'#.
,....
cri
M
-
~
CI:!
....
(f;~
N .
.0)
Cl)M
0)
v
tt:i
~~
CD .
.v
N
v
CO?
~
M
c:i
co
:.!!
~
";'
.....'#.
.....M
co .
.0
VCO
M
0)
N
.....
~~
GO GO
v'
.N
GO I
CO?
e
~
ClO
cO
M
~
....
r.;
ClO';Je
~~
.CO
....M
ClO
ClO
......
C;;~
.... CO?
N .
.....
CO? '
....
~
:.!!
o
1.1')
M
N
'#.
'"":
....
M';Je
co 1.1')
N .
.M
....N
v
o
on
.,,';Ie.
II) ....
.... .
.v
GO
CO?
N
lI')~
00
~c:i
MO
M.....
v.
.....
N
o~
ID 0
v .
.0
GO
co
52
....
8!
co~
Eo
~~
GI
aJ
. C
aJnI
c.c
!O
o~
ai
"0
(;
Iii
::l
c:
c:
nI
co
Q
,....
o
>-
I&.
Gl
:5
~
.E
o
co
o
c:i
toIt
~
o
>-
c:
c:
Gl
Q.
Ui
~
.!2
x
Gl
c:
Gl
:5
.s
"tJ
Gl
"tJ
c:
::l
e
Gl
.Cl
~
c:
l!!
~
'6
'E
Gl
.s:::
I-
Gl
:c
:s.
2
~
~
c:
o
Z
:u
ll.
Gl
e'
nI
.s:::
~
Gl
:5
1ii
:5
"tJ
Gl
"tJ
c:
Gl
E
E
8
~
.!!!
=:
,.
i1i
(5
Z
o
~
~
"l(
~
...
o
t
.2
~
,..
..
'i'
...
o
~
'"
w
~
~
g
w
~
:l
~
B
<3
~
0;
.,
CSW:08/27/2007
ATTACHMENT #5
ENERGY CONSERVATION ADJUSTMENT (ECA) &
ENVIRONMENTAL IMPOSITION ADJUSTMENT (EIA) CALCULATIONS
FOR THE BILLING PERIOD OF 10/01/2007 - 9/30/2008
I. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 07/08:
Projected ECA Requirements for FY 07/08 only = $ 1,600,000
Projected Administrative & CCS Charges to ECA for FY 07/08 = $ 300,000
Projected Current FYE 06/07 (Over) Under Recovery of ECA = $
Total Annualized ECA Recovery Needed during FY 07/08 = $ 1,900,000
Less Projected ECA Recovery within PGA@$0.09/Therm or Gal = $ (100,000)
Total ECA Recovery Needed from Standard Rate Customers = $ 1,800,000
Projected Therm Sales for FY 07/08 Applicable to ECA Recovery = 10,000,000
(Natural Gas @40% Standard = 9,450,000 therms & LP @ 100%
Standard = 550,000 gal. or 10,000,000 Total Applicable Therms)
Computed ECA Recovery Factor Necessary = $ 0.1800
Propose Rounding ECA Recovery Rate to $ 0.180 #
Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 1,900,000
II. Calculation of the Environmental Imposition Adjustment (EIA) Required for FY 06/07
Budgeted EIA Requirements for FY 07/08 only =
Projected Current FYE 06/07 (Over) Under Recovery of EIA =
Total Annualized EIA Recovery Needed during FY 07/08 =
Round Proposed EIA Recovery Rate to
$ 100,000
$ (100,000)
$
$
$
$
Therefore, EIA needs to be for FY 07/08 =
Annual ECA Revenue Projection @ Proposed Recovery Rate =
U:\My Documents\EXCEL\GASRATESIFY 07-08\(ECA & EIA for FY 07-08.xls]Sheet1
..
.....'"
~o
<:~
II II
s::.Dl
U III
1IIQ.
:j::
~
o
...
U
cr:
II..
en...
a::Z
O~
1-'"
o!J
<Cd
LLcr:
C)~
ZCl
_0
..JW
2..J~
wM:a:
......Q.
~w~
(l)l-z
(I)<CO
~D::fil
a: -(I)
wn,cr:
.....JIO
~-!
a:W~
~Zo
~<C'"
un,a:
O:g
a::~
n,...
Q.
OW
w~
a::l:;
WCI
I-~
W....
:&15
10
e
U
o
a:
o
II..
LLLL
U U
2-2-
j J
~ ~
l3 a 6
88'ii
~~(!)
Ui Ui Ui
6 E E
= II II
~ ~ ~
~I ~I~I
.....
o
o
!::!
(l)
~
0;
o
~
U
L.:
L.; L.:.s
o 0 u
&i&i~
II.. u. E
~ ~ II
10 al...
o
~
...
uIL.
~d
z
o
U
a:
10(1)
~~
~
(I)
i~
.J
2
OQ.
U~
w~
~
:5
.J
:&
o
UQ.
~~
~(!)
~2
(I)
.J
(I)
WIL.
a:~
IL.a:
O~
o
~
>
~
i
cr:Q.
~~
~2
;:)2
2
Ij
c:(
z
0;
~c
~.e~~
i=~
~!fIt
~
c:(
z
o
lI)
N
^
CI
CI
lI)
N
CI
.l!!
'<;
~~
~
c:(!!
Z5
+
:!;.
Iil
~
c:( c::
z;:)
..,
~
II
co
c::
11I-
a:lij
c .~
,gE
III II
(!)Qj
liiO
~s
~~
II ....
:all
,~o
0.....
0.0
c:(
'0
g
c::
o
o
>.
al
Qj
en
o2@
ui:t:ijl
lien_II
~(!) ~'~8
08>{!!'":
00 '!! o.CI
fit ~ Co fit
fit
o
o
o
..,
fit
o
o
o
'"
fit
o
o
00
fit
8
o
'"
fit
o
o
00
fit
II
e'
!
o
li
E
o
Vi
::I
o
>.
1:
"E
o
:&
c
,g
.c:
U
z
'0
g
c::
<3 ~
>.
al
Qj
en
o
0>
..,
o
fit
CI
lI)
~
o
fit
o
o
'"
o
fit
o
o
co
o
fit
CI
CI
"!
;;;
o
CI
"!
~
fit
c::
.2
lii
!:2
81
e'
tIl
s::.
o
>.
e'
Gl
c::
W
Qj
::I
II..
~
Z
o
co
~
o
o
co
~
o
o
co
~
o
o
co
......
o
o
co
......
o
o
co
~
o
o
co
~
o
<:
.2
lii
~
~
6
~
Gl
<II
c::
o
o
>.
e'
II
c::
W
<(
z
o
o
o
o
8
o
o
8
CI
o
o
CI
o
o
o
o
o
o
o
o
o
o
o
o
CI
o
<:
.2
lii
!:2
~
c::
o
~
~
.5
-E
<:
e
'50
c::
W
~
!I
!
~
~
!
!
!
~
lii
~
~
<:
o
i
~
o
z
....
81
s::.
I
+
'0
l!!o
"Eo
oC=!
00
>.fIt
al
o
.....
lI)
o
fit
o
co
'"
o
fit
o
..,
..,
o
fit
o
co
..,
o
fit
o
...
(l)
o
fit
o
co
t-:
;;;
o
co
t-:
;;;
c::
.5!
ii
1
e'
III
.c:
U
'ii
::I
~
c::
o
z
!
~
~
~
51
~
~
51
~
<:
.2
lii
g
c::
II
i
::I
~
<II
III
(!)
i
III
s::.
I:?
::I
Q.
C.
+s::.
Gl<;'"t:I
we'e'~O
~B~g~
o'OliQj15~
~gE::Iolii
~c:.s~1C)
;8~6-::'O
+oz.e_
o
co
~
N
fit
o
o
o
lI)
fit
o
0>
~
N
fit
&~ <II
~tiiBII
-alt5= !:
.Q '- 8: os::.
o.Glc:(
~5~~
>. Vi c:( '0
~8+~
o
~
N
N
fit
o
o
o
..,
fit
o
(l)
'"
N
fit
o
o
o
N
fit
o
0>
co
N
fit
o
o
00
fit
o
0>
eo
....;
fit
8
o
N
fit
o
0>
co
....;
fit
o
o
00
fit
<:
.5!
ii
S2
;
e'
III
.c:
U
e;
II
c::
w
!
as
>.
:E
"E
o
:&
E
::I
E
'2
~
;
Ui
o
Ui
~
o
Ui
~
o
eo
~
o
Ui
~
o
Ui
o
Ui
......
o
Ui
~
o
..,
.....
0>
~
-
~
~
~
E
II
~
!
II
ii
a:
Qj
::I
U.
0>
~
t-:
;;;
a"#.
coo
..... '
.0>
oeo
fit
0>
~
.....
;;;
0;1.
co~
co .
,..,
Oll)
fit
0>
~
t-:
;;;
0;1.
eo.....
~.
oeo
fit
0>
~
;;;
0';1.
eo..,
~N
oeo
fit
0>
~
.....
;;;
0';1.
eo~
~ci
Oeo
fit
0>
~
t-:
;;;
0';1.
eo~
... .
.N
o~
fit
0>
~
t-:
;;;
0';1.
:8"":
,0
0..,
fit
0>
~
.....
;;;
0';1.
co~
co .
,0
0..,
fit
E
li
s::.
t::
16
::I
U.
Gl
:a
~
...
>.
~
:5
c':
o
z
II
llii
_0::
~15
<:=
o 1II
=(!)
~~
~~
Oc;
!::!~
~ E
E,g
e II
-01
II <:
011'0
<:s::.
!U
u';1.
C&W:1lI1912007 I I I I I I I I I Attachment #8
Residential Rate History By Components
Clearwater Gas System
I I I
fotal Rata I ComoonentslThem Contract LP
Month NGltherm LP/oaUon . ECA EIA W~ eGl\ fGA PGA/oaUon
Oct-04 $ 1.710 $ 2.030 $ 0.100 $ - $ - $ 1.030 $ 0.960 $ 1.130
Nov-04 $ 1.710 $ 2.030 $ 0.100 $ - $ - $1.030 $ 0.960 $ 1.130
Dec-04 $ 1.750 $ 2.090 $ 0.100 $ - $ - $ 1.070 $ 1.000 $ 1.190
Jan-OS $ 1.750 $ 2.090 $ 0.100 $ - $ - $1.070 $ 1.000 $ 1.190
FelHl5 $ 1.830 $ 2.150 $ 0.130 $ - $ 0.010 $ 1.110 $ 1.040 $ 1.210
Mar-05 $ 1.860 $ 2.180 $ 0.130 $ 0.020 $ 0.020 $ 1.110 $ 1.040 $ 1.210
Apr-OS $ 1.860 $ 2.280 $ 0.130 $ 0.020 $ 0.020 $ 1.110 $ 1.040 $ 1.210
Mev-OS $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ 1.140
Jun-05 $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ 1.140
Jul-OS $ 1.790 $ 2.190 $ 0.130 $ 0.020 $ - $ 1.060 $ 0.990 $ 1.140
Aug-05 $ 1.820 $ 2.220 $ 0.140 $ 0.020 $ - $ 1.080 $ 1.010 $ 1.160
SeD-OS $ 1.970 $ 2.300 $ 0.140 $ 0.020 $ - $ 1.230 $ 1.160 $ 1.240
FY 0.4105 A vg. $ 1.803 $ 2.162 s 0.122 i 50.012 $ 0.004 51.085 5 1.015 S 1.174
2004 Avo. i 5 1.652 S 1.958 S 0.123 $ . $ - $ 0.949 . $ 0.879 $ 1.046
Oct-OS $ 2.190 $ 2.530 $ 0.120 $ 0.020 $ - $ 1.470 $ 1.390 $ 1.490
Nov-05 $ 2.190 $ 2.530 $ 0.120 $ 0.020 $ - $ 1.470 $ 1.390 $ 1.490
Dec-05 $ 2.260 $ 2.490 $ 0.120 $ 0.020 $ - $ 1.540 $ 1.460 $ 1.450
Jan-06 $ 2.260 $ 2.490 $ 0.120 $ 0.020 $ - $ 1.540 $ 1.460 $ 1.450
Feb-06 $ 2.220 $ 2.460 $ 0.160 $ 0.010 $ - $ 1.470 $ 1.390 $ 1.390
Mar-06 $ 2.220 $ 2.460 $ 0.160 $0.010 $ - $1.470 $ 1.390 $ 1.390
AIlr-06 $ 2.110 $ 2.320 $ 0.170 $ 0.010 $ - $ 1.350 $ 1.270 $ 1.240
Mav-06 $ 1.960 $ 2.360 $ 0.170 $ 0.010 $ - $ 1 .200 $ 1.120 $ 1.260
Jun-06 $ 1.920 $ 2.420 $ 0.160 $ 0.010 $ - $ 1.150 $ 1.070 $ 1.330
JuI-06 $ 1.910 $ 2.500 $ 0.200 $ 0.D10 $ - $ 1.120 $ 1.040 $ 1.390
Aug-08 $ 1.860 $ 2.600 $ 0.200 $ 0.D10 $ - $1.070 $ 0.990 $ 1.490
SeD-06 $ 1.860 $ 2.600 $ 0.200 $0.010 $ - $ 1.070 $ 0.990 $ 1.490
FY 05106 Avo. 5 2.080 $ 2.480 $ 0.160 5 0.013 5 - $1.327 5 1.247 $ 1.407
2005 Avo. $ 1.925 $ 2.278 $ 0.127 S 0.017 $ 0.004 $ 1.198 :t 1.125 $ 1.256
Oct-06 $ 1.940 $ 2.600 $ 0.180 $ 0.D10 $ - $ 1.170 $ 1.090 $ 1.510
Nov-06 $ 1.940 $ 2.600 $ 0.180 $0.010 $ - $ 1.170 $ 1.090 $ 1.510
Dec-06 $ 1.940 $ 2.600 $ 0.180 $0.010 $ - $ 1.170 $ 1.090 $ 1.510
Jan-07 $ 1.940 $ 2.600 $ 0.180 $ 0.010 $ - $ 1.170 $ 1.090 $ 1.510
Feb-07 $ 1.940 $ 2.600 $ 0.180 $ 0.D10 $ - $ 1.170 $ 1.090 $ 1.510
Mar-07 $ 1.940 $ 2.600 $ 0.180 $ 0.D10 $ - $ 1.170 $ 1.090 $ 1.510
ADr-07 $ 1.940 $ 2.600 $ 0.180 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.490
Mev-07 $ 1.940 $ 2.740 $ 0.180 $ - $ 0.030 $ 1.150 $ 1.070 $ 1.630
Jun-07 $ 1.920 $ 2.990 $ 0.180 $ - $ 0.030 $ 1.130 $ 1.050 $ 1.880
Jul-07 $ 1.840 $ 2.990 $ 0.160 $ - $ - $ 1.060 $ 1.000 $ 1.910
Aug-07 $ 1.840 $ 2.990 $ 0.160 $ - $ - $ 1.060 $ 1.000 $ 1.910
Se0-07 $ 1.890 $ 2.990 $ 0.160 $ - $ - $ 1.130 $ 1.050 $ 1.910
FY 06107 Avg. $ 1.918 :t 2.742 S 0.180 S 0.005 $ O.OOB $1.145 'S 1.065 $ 1.649
20OBAvo. i 5 2.012 $ 2.501 $ 0.175 S 0.011 $ - i 5 1.248 ,5 1.166 $ lA15
Oct-07 $ 1.840 $ 2.990 $ 0.180 $ - $ - $1.060 $ 1.000 $ 1.910
Nov-07
Dee-07
Jan-08
Feb-08
Mar-08
Aor-08
Mav-08
Jun-08
Jul-08
Aug-08
Seo-08
FY 07108 Avo. S 1.840 $ 2.990 $ 0.180 S - $ - 51.080 $ 1.000 S 1.910
2007 Ava.
Incr. Above S 0.100 $ 0.390 $ . SlO.Ol0 S - $(0.090) $ (0.090) $ 0.400
Last Year
Same Month -5% 15% 0% -100% NA -8% -8% 26%
Incr. Based $ 12.00 $ 8.52
on 20 Therms -4% 14%
Eoulvalent
CentsIKWH 6.3 11.2
for Gas
VB. FPC Rata 12.0 12.0 Note: This indudes Pn ress Enenr s Increase in Janua 2007.
Residential)
Gas Cheaper
bv -47% -7%
Note: Added $1 oer month to Monthly Customer Chame for NG & LP efI'ective 41112005
I I
I I
Notes: I I
. Based on Bulk LP BRLP3 which is BD< lcable for customers usi.. 120.1 - 300 oaftonslllaar & eoual to Residential LP Will Call IBRWCLP).