Spreadsheet: phillip_m_love__31214__Gas Three RM PMA Log 1001
Sheet: RM PMA log

Risk Profit & Loss vs General Ledger Variances
As of October 31, 2001
Bookcode | Month | Code | Type | Description | Risk
FT Carthage (!K) | Sep | RM | O | Miscellaneous rounding | -49
Book Admin: [NAME] |  |  |  | FT Carthage
FT Chicago | Mar | RM | O | Miscellaneous rounding | -80
FT Chicago | Aug | RM | O | Liquidated values in roll 7 cells C61 & 62 (8/01 & 8/02) | -6050
FT Chicago | Mar | RM | E | Gas daily pricing variance | 2259.43
Book Admin: [NAME] |  |  |  | FT Chicago
FT Denver & FT REGS (W5 & -O) | Jan | RM | O | Miscellaneous rounding | -2284
FT Denver & FT REGS (W5 & -O) | Aug | RM | O | FT Denver: HS Energy Services VP8863.1 & VP8866.1 liquidated but contract period 04/02-10/02 | -43399.96
FT Denver & FT REGS (W5 & -O) | Sep | RM | O | FT Denver: Kerr-McGee Energy Services - VP8863.1 for (67270) and VP8866.1 for 98,270 (Denver) liquidated but do not settle until April 02 per TAGG. | -31000
FT Denver & FT REGS (W5 & -O) | Sep | RM | O | FT Regs: Deutsche Bank AG - VQ8723.1 liguidated in Aug, should settle and liquidate for Oct Contract per TAGG | -42935
FT Denver & FT REGS (W5 & -O) | Oct | RM | O | FT Denver: Kerr-McGee Energy Services - VP8863.1 liquidated for $(142,500) and VP8866.1 liquidated for $151,500, April 2002 - October 2002 contract | 9000
FT Denver & FT REGS (W5 & -O) | Oct | RM | O | FT Denver: EX2226.5 not in DPR | 620
FT Denver & FT REGS (W5 & -O) | Oct | RM | O | FT Denver: EU2049.2 not in DPR | 620
FT Denver & FT REGS (W5 & -O) | Oct | RM | O | FT Regs: Sempra Energy Trading Co - VT7479.1 liquidated in Sep, November - March contract | -17250
FT Denver & FT REGS (W5 & -O) | Oct | RM | O | FT Regs: Allegheny Energy Supply - VQ0013.1 liquidated in Sep, Nov - Mar contract | 43500
Book Admin: [NAME] |  |  |  | FT Denver (W5) & FT Regs (-O)
FT Intra Central | Jan | RM | O | Central Mich: miscellaneous rounding | -2838
FT Intra Central | Jun | RM | O | Central Mich: gas daily pricing variance on deals VC4002.2 & VC7816.1.  Price for 30-Jun-01 was $3.12 but should have been $3.355 for GDP-MICHCON. | 5992.58
FT Intra Central | Oct | RM | O | Central Mich: liquidation date for post id 1380888 shows as 01-Nov-2001 when it should be 31-Oct-2001.  By using that liq date, values for November liquidated. | 8303.5
FT Intra Central | Sep | RM | O | Central Midcon: broker fees not taken | -644
Book Admin: Gulf - Michelle Akers; Mgmt & Mich CG - Jad Doan; Mich - Stephanie Hopkins; Midcon - Scott Palmer |  |  |  | FT Intra Central
FT Intra East (89) | Jan | RM | O | Intra East Market: miscellaneous rounding | 3666
FT Intra East (89) | Aug | RM | O | Intra East Trnspt: broker fees not taken | 625
FT Intra East (89) | Sep | RM | O | Intra East North: gas daily pricing variances | 33990.91
FT Intra East (89) | Sep | RM | O | Intra East Market: Conectiv Energy Supply - VQ1774 & VQ2147 float should be 3.295, VQ3389 float should be 3.301 | -1830
Book Admin: Gulf - [NAME]; Gulf 2 - Kristen Clause; North - Edward Brady; [NAME]; Trnsprt - Kimat Singla |  |  |  | FT Intra East (89)
FT Intra Ontario (43) | Jan | RM | O | [NAME] | 78
FT Intra Ontario (43) | Aug | RM | O | Tenaska Marketing Venture - V78806.1 did not liquidate, invoice 01082069 | -68045
FT Intra Ontario (43) | Sep | RM | O | Tenaska Marketing Venture - V78806.1 did not liquidate, invoice 01092376 | -278690
FT Intra Ontario (43) | Oct | RM | O | [NAME] (Jan - Mar) did not liquidate; settled with TransCanada | -561428.5
FT Intra Ontario (43) | Oct | RM | O | [NAME] conversion | 31920
Book Admin: Stephanie Hopkins |  |  |  | FT Intra Ontario (43)
[NAME] | May | RM | O | [NAME] | -496
[NAME] | Jul | RM | O | Texaco Natural Gas Inc - revalue VB9536 using fixed price of 3.7405 and float of 3.79 (inv 0107903) | -5400
Book [NAME]: [NAME] |  |  |  | [NAME]
FT Lonestar (5Y) | Aug | RM | O | Miscellaneous rounding | -4
FT Lonestar (5Y) | Oct | RM | O | AEP: deal VC4272.H - settled incorrectly originally - Pub code s/b Katy/Tail per TAGG - verified by O'Neal Winfree | -2170
Book Admin: [NAME] |  |  |  | FT Lonestar (5Y)
FT Peoples (G#) | Jan | RM | O | Miscellaneous rounding | -558
Book Admin: Jad Doan |  |  |  | FT Peoples (G#)
Intra Texas (PA) | Jan | RM | O | Miscellaneous rounding ($1000 miskey of Sep PMAs - took 24,994 instead of 25,994) | -1028
Book Admin: [NAME] |  |  |  | Intra Texas (PA)
Management West | Aug | RM | O | WC SJ: Mirant Americas Energy Mrkting - VG3347.1 volume should be 930,000 not 900K and float price should be 3.0079 not 2.9997 creating a variance of $1,692.00 | 1691.909999999974
Management West | Aug | RM | O | WC SJ: VZ1553.1 liguidated in DPR in Aug and Sept, GL liquidated Sept only (Sept inTAGG) | -344078.69
Management West | Oct | RM | O | WC SJ: Enserco Energy, Inc. - VV3419 was elpso/perm, changed to elpo/sj in tagg on 10/9/01, but settled on 10/5/01 | -65505
Management West | Oct | RM | O | WT SJ: Cinergy Marketing & Trading -Y11207.2 liquidated, July 02 / Sept 02 contract | -36750
 |  |  |  | WestSanJuan
Management West | Jul | RM | O | WT SOCAL: NN0111.3 with FT West - basis rate of -3.18 incorrect | -442215
Management West | Aug | RM | O | WT SOCAL: GDP-PG&E/CITIGA rate group - Sat, Sun, Mon should be same rate | 18599
Management West | Aug | RM | O | WT SOCAL: broker fees booked to old book name (FT West) | -648
Management West | Sep | RM | O | WT SOCAL: Las Vegas Cogeneration - DPR to be adjsted, float shld be $2.24 deals N02595.1/N02595.2 | -95635
Management West | Oct | RM | O | WT SOCAL: check figure not 0 | -387146
 |  |  |  | WT SOCAL
Management West | Oct | RM | O | WT CAL: Reliant Energy Services - Y00486 nwpl rocky mountain settle is $2.09 not $2.295 (liquid amt) | -2999.99
Management West | Oct | RM | O | WT CAL: Cornerstone Propane, L.P - Y17571.1 float rate for PG&E/CITIGATE pub code revised from $2.0904 to $2.0883 | -241.5
Management West | Oct | RM | O | WT CAL: Allegheny Energy Supply - correction of June FS recs - VB5398.1 originally settled incorrectly and correction made on invoice # 01104147 ($560,700.00) | -560700
Management West | Oct | RM | O | WT CAL: check figure not 0 | -13477
 |  |  |  | WT CAL
Management West | Oct | RM | O | WC CAL: [NAME] / Y23240 changed float PG&E CG | -1826
Management West | Oct | RM | O | WC CAL: PG&E Energy Trading - float Rate for deals Y13585.1, Y16168.1, and Y21935.1 liquidated incorrectly - price should be $2.1031 for Y13858.1 and Y16168.1 and 2.0475 for Y21935.1 | -2008
 |  |  |  | WC CAL
Management West | Sep | RM | O | WC ROX: e prime, inc. - VR5905.1 settled on invoice # 01092324 did not liquidate | -60542.4
 |  |  |  | [NAME]
Management West | Jul | RM | O | [NAME]: pricing variances on multiple deals - see "-W pricing" sheet for details | 32374.5
Management West | Jul | RM | O | [NAME]: Tractebel Energy Marketing - Deal # V97736.1 on invoice # 01072347 fixed rate is 3.815 not (.005) per liquidation schedule | -131980
Management West | Aug | RM | O | [NAME]: E Prime - VK0074 fixed price s/b 1.98 vs 2.03, VK2059.1 should have fix price of 1.995 vs 2.03 | -139819.46
Management West | Aug | RM | O | [NAME]: HS Energy Services VP8861.1 & VP8864.1 liquidated, 04/2002 - 10/2002 contract | -43399.96
Management West | Sep | RM | O | [NAME]: Avista Energy, Inc. - Remaining difference from above is Deal VV8822.1 liquidated for  ($37,510), 04/2002 - 10/2002 contract | 37510
Management West | Sep | RM | O | [NAME]: Kerr-McGee Energy Services - VP8861.1 for (67,270) VP8864.1for 98,270 liquidated but do not settle until April 02 per TAGG. | -31000
Management West | Oct | RM | O | [NAME]: Avista Energy, Inc. - VV8822.1 liquidated, 04/2002 - 10/2002 contract | -67500
Management West | Oct | RM | O | [NAME]: Kerr-McGee Energy Services - VP8861.1 liquidated for $142,500 and VP8864.1 liquidated for $(151,500), 04/2002 - 10/2002 contract | 9000
Management West | Oct | RM | O | [NAME]: deals VT0542.1, VT0888.1, VT3591.1, VT3593.1, VT3595.1 did not liquidate | 6975
Management West | Oct | RM | O | [NAME]: roll 9 cell B49 feeds to report page twice (in cells V42 and V44) | -170243
 |  |  |  | [NAME]
Book Admin: WestSanJuan - Ashley Worthing; [NAME]; WT CAL - Ryan O'Rourke; WT SOCAL - [NAME]; WestPerm - Ashley Fay; WC CAL - Monte Jones |  |  |  | Management West