Spreadsheet: phillip_m_love__31312__Gas Three RM PMA Log 0901
Sheet: RM PMA Log

Risk Profit & Loss vs General Ledger Variances
As of September 30, 2001
Bookcode | Month | Code | Type | Description | Risk
Firm Trade - Southeast (GA)
Book Admin: [NAME] |  |  |  | FT Southeast (GA)
FT Carthage (!K)
Book Admin: Chance Rabon |  |  |  | FT Carthage (!K)
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 (1E, 5W, 5X)
FT Denver & FT REGS (W5 & -O) | Jun | RM | O | FT Regs: Devon Energy Production - V55929.1 fixed price should be 4.28 (invoice 01061946) | 204596
FT Denver & FT REGS (W5 & -O) | Aug | RM | O | FT Denver: VJ6129 fixed price should be 1.81 vs 1.75 (invoice 01082020) | 9300.02
FT Denver & FT REGS (W5 & -O) | Sep | RM | O | FT Denver: EX2226.5 not in DPR | -5400
FT Denver & FT REGS (W5 & -O) | Sep | RM | O | FT Denver: EU2049.2 not in DPR | -5400
Book Admin: [NAME] |  |  |  | FT Denver (W5) & FT Regs (-O)
FT HPL Transport (A$, B{, B} ) | Sep | RM | O | Miscellaneous rounding | 773
Book Admin: O'Neal Winfree |  |  |  | FT HPL Transport (A$, B{, B} )
FT Intra Central | Jun | RM | O | Central Mich (55) 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 | Sep | RM | O | Central Mgmt: Y62234.1 premium did not liquidate (30,000 * 31 * .13 = 120,900) | 120900
FT Intra Central | Sep | RM | O | Central Midcon: broker fees not taken | -644
Book Admin: Gulf & Mgmt - Sladana Kulic; Mich & New - Jad Doan; Midcon - Bruce Mills |  |  |  | FT Intra Central
FT Intra East (89) | Jul | RM | O | Intra East North: NUI Energy Brokers, Inc - VI2296.1 & .2 fixed changed from .62 to .58 (invoice 01072327) | 15950
FT Intra East (89) | Aug | RM | O | Intra East North: TXU Energy Trading - VU4268.1, inv 01082078 did not liquidate | 22165
FT Intra East (89) | Aug | RM | O | Intra East North: broker fees not taken | 38
FT Intra East (89) | Sep | RM | O | Intra East North: gas daily pricing variances | 33990.91
FT Intra East (89) | Aug | RM | O | Intra East Trnspt: broker fees not taken | 625
FT Intra East (89) | Aug | RM | O | Intra East Mkt: broker fees not taken | 402
FT Intra East (89) | Aug | RM | O | Intra East Gulf: broker fees not taken | 278
Book Admin: Gulf - [NAME]; Mkt - James Hungerford; North - Kam Keiser; Trnsprt - Kimat Singla |  |  |  | FT Intra East (89)
FT Intra Ontario (43) | Aug | RM | O | Tenaska Marketing Venture - V78806.1 did not liquidate, invoice 01082069 | -68045
FT Intra Ontario (43) | Aug | RM | O | Miscellaneous rounding and broker fees
Book Admin: [NAME] |  |  |  | FT Intra Ontario (43)
[NAME] | Jul | FS | O | Texaco Natural Gas Inc - revalue VB9536 using fixed price of 3.7405 and float of 3.79 (inv 0107903) | -5400
Book Admin: O'Neal Winfree |  |  |  | [NAME] (!J)
FT Lonestar (5Y)
Book Admin: O'Neal Winfree |  |  |  | FT Lonestar (5Y)
FT Peoples (G#)
Book Admin: [NAME] |  |  |  | FT Peoples (G#)
Intra Texas (PA) | Jan | FO | O | Miscellaneous rounding and broker fees
Intra Texas (PA) | Apr | RM | O | [NAME] liquidated at $465,929 but financial settlements confirmed $496,929.  Liquidated value did not pick up $[NAME] set up on deal in TAGG (3,100,000 * $.01 = $31,000) - schedule E amount not cleared so taken twice by DPR | -31000
Intra Texas (PA) | Jul | RM | O | Broker fees in ngp&l but not in dpr | 1772.24
Book Admin: O'Neal Winfree |  |  |  | Intra Texas (PA)
Management West | Jun | RM | O | FT WT CAL (Northwest): sched E values in basis rolls from May 2001 not cleared in June so taken twice by book | 11686
Management West | Jul | RM | O | FT WT CAL: broker fees not in DPR - Northwest
Management West | Aug | RM | O | FT WT CAL: check figure not zero (roll 5, cell B 53 not picked up) | -52358
Management West | Aug | RM | O | FT WT CAL: GDP-PG&E/CITIGA rate group - Sat, Sun, Mon should be same rate | 29039
Management West | Sep | RM | O | FT WT CAL: roll 5 check figure not 0 | -6067
 |  |  |  | FT WT CAL
Management West | Jul | RM | O | FT WC CAL: broker fees not in DPR - GD New | -18445
Management West | Jul | RM | O | FT WC CAL: broker fees not in DPR - GD New JR | -1314
 |  |  |  | FT WC CAL
Management West | Jul | RM | O | FT WT SOCAL: NN0111.3 with FT West - basis rate of -3.18 incorrect | -442215
Management West | Aug | RM | O | FT WT SOCAL: broker fees not in DPR (FT West)
Management West | Aug | RM | O | FT WT SOCAL: GDP-PG&E/CITIGA rate group - Sat, Sun, Mon should be same rate | 18599
 |  |  |  | FT WT SOCAL
Management West | Jun | RM | O | FT WC SJ (Keystone): sched E values in basis rolls from May 2001 not cleared in June so taken twice by book | 8567
Management West | Jul | RM | O | FT WC SJ: broker fees not in DPR - FT Keystone Roll 6 | -618
Management West | Jul | RM | O | FT WC SJ: rolling problem - WestSJ_Key Roll 10 cell B 50 | -20828
Management West | Aug | RM | O | FT WC SJ: VZ1553.1 liguidated in DPR in Aug and Sept, GL liquidated Sept only (Sept inTAGG) | -344078.69
Management West | Jun | RM | O | FT WT SJ (San Juan): sched E values in basis rolls from May 2001 not cleared in June so taken twice by book | 17510
 |  |  |  | WestSanJuan
Management West | Jun | RM | O | FT WC PERM (Permian): sched E values in basis rolls from May 2001 not cleared in June so taken twice by book | 17676
 |  |  |  | FT WC PERM
Management West | Jul | RM | O | FT WT ROX: rolling problem - West PGE_Rox Roll 10 cell B 50 | 120359
Management West | Jul | RM | O | FT WT ROX: broker fees not in DPR - FT Rockies Roll 6 | -1277
Management West | Jul | RM | O | FT WT ROX: QY0005.1 Liquidated @ $4100, Canada settled @ $7050 (March contract) | -2950
Management West | Jul | RM | O | FT WT ROX: Tractebel Energy Marketing - Deal # V97736.1 on invoice # 01072347 fixed rate is 3.815 not (.005) per liquidation schedule | -131980
Management West | Jul | RM | O | FT WT ROX: pricing variances on multiple deals - see "-W pricing" sheet for details | 32374.5
Management West | Aug | RM | O | FT WT ROX: E Prime - VK0074 fixed price s/b 1.98 vs 2.03, VK2059.1 should have fix price of 1.995 vs 2.03 (invoice 01082020) | -139819.46
Management West | Aug | RM | O | FT WT ROX: roll 10 prior month liquidations (E29 and M32 don't match) | -3719
Management West | Aug | RM | O | FT WT ROX: GDP-PG&E/CITIGA rate group - Sat, Sun, Mon should be same rate | 11491
Management West | Jul | RM | O | FT WC ROX: broker fees not in DPR - FT PGE Roll 2 | -335
Management West | Jul | RM | O | FT WC ROX: pricing variances on multiple deals - see "-V pricing" sheet for details | -26703
Management West | Jul | RM | O | MGMT WT: rolling problem - WestSocal_MGMT Roll 10 cell B 50 | -32423
 |  |  |  | WestRox_Mgmt
Book Admin: WestSanJuan - Kristen Clause; [NAME]; WT CAL - Ryan O'Rourke; WT SOCAL - [NAME]; WestPerm - Michelle Akers; WC CAL - Monte Jones |  |  |  | Management West