Spreadsheet: chris_stokley__3975__EES Activity Listing071301
Sheet: Sheet1

 | Commodity Affected |  | Project Owners |  | Focus Area |  |  | Core Project  To Address Issue |  |  |  |  | Metrics
Activities | Gas | Power | Business [NAME] | IT                A. Dayao | IT | Process | People | Phoenix | Gas Soln | Ranger | [NAME] | Interim  Power Soln | Total | Finished | Expected Completion | Comments
Data Accuracy Improvement Initiatives
Historical
Review / Rebook Large Deals | X | X | [NAME] | [NAME] [NAME] | X | X | X | X |  |  |  |  | 100 |  | Q4 | Led by Project Phoenix
Industrial Gas Deals | X |  | [NAME] | [NAME] | X | X | X |  | X |  |  |  | 5000 |  | Oct | Deal rebooking will be based on contract review into new system
Commercial Gas Deals | X |  | [NAME] | [NAME] | X | X | X |  | X |  |  |  | 25000 |  | Oct | Deal rebooking will be based on contract review into new system
Retail Power |  | X | [NAME] | [NAME] | X |  |  |  |  |  |  |  | 13500 |  | Jan | Deal rebooking will be based on contract review into new system
Wholesale (EPMI/ENA) Intercompany Tie-Out | X | X | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Jan | Deal rebooking will be based on contract review into new system
Contract / Trade Documentation | X | X | Toby Ellis |  |  |  |  |  |  |  |  |  | 16000 |  | Oct | Ensure company has all contractual documents in robust imaging/retention system.  Goals:  accessible, complete & maintained in livelink.
Go Forward
Integration with Global Common Data
Global Counterparties | X | X | [NAME] |  |  | X | X |  |  |  |  |  | 15000 | 5000 | Oct | Have Global Data systems integrated into gas & power trading systems, risk systems, & billing systems.  Input & validate historical backlog.
Global Contracts | X | X | Toby Ellis |  |  | X | X |  |  |  |  |  | 16000 | 1000 | Oct | < see above >
Global Facilities & Sites | X | X | [NAME] |  |  | X | X |  |  |  |  |  | 30000 |  | Gas - Oct Pwr - Jan | < see above >
Capture All New Deals
Deal Tickets | X | X | [NAME][NAME] -G |  |  | X | X |  | X |  |  | X |  |  | Gas - Jul Pwr - Aug | Working to transition deal capture from Deal Mgmt / Production Development to Risk.
Complete Site Listings | X | X | [NAME][NAME] -G |  |  | X | X | X | X |  |  | X |  |  | Gas - Jul Pwr - Aug | Need commitment from service management team and originators
Contract Validation
Back to Original Contracts | X | X | [NAME][NAME] -G | NEED NAME | X | X | X |  | X |  |  | X |  |  | Gas - Jul Pwr - Aug | Need workflow tools and additional personnel.  Have good support from Origination heads.
Fully Papered | X | X | [NAME][NAME] -G | NEED NAME | X | X | X |  | X |  |  | X |  |  | Gas - Jul Pwr - Aug | < see above >
Executed | X | X | [NAME][NAME] -G | NEED NAME | X | X | X |  | X |  |  | X |  |  | Gas - Jul Pwr - Aug | < see above >
Confirmation | X | X | [NAME][NAME] -G | NEED NAME | X | X | X |  | X |  |  | X |  |  | Gas - Jul Pwr - Aug | < see above >
Risk System Limitations
Global Risk Issues
Reliability/Timing of Market Risk Interface | X | X | [NAME] | [NAME] [NAME] | X | X |  |  | X |  |  | X |  |  | ST - Sep MT - Aug | Short Term:  Reduction of spreadsheets [NAME]:  Stabilizing of RGS / RPS
Reliability of Credit Aggregation System & Process | X | X | [NAME] [NAME] | [NAME] [NAME] | X | X |  |  | X |  |  | X |  |  | ST - Sep MT - Aug LT - Oct | Short Term:  Reduction of spreadsheets [NAME]:  Stabilizing of RGS / RPS Long Term:  GCP System Integration  & Counterparty Setup
Risk Information Not Real-Time | X | X | [NAME] [NAME] | [NAME] [NAME] | X | X | X |  | X | X |  | X |  |  | ST -  MT - Sep  LT - Oct | Short Term: Aggregate existing measurement info from CSC [NAME]: Have CSC pull from additional utilities for hrly/daily meter data [NAME]: Gas Solution & Power Solution
Energy Asset Management (EAM) | X | X | [NAME] |  | X | X | X |  | X |  |  | X |  |  | ST - Sep LT Gas - Oct LT Pwr - Jan | Short Term: Create EAM Books on EES side of business so DSM can manage;  rebook & hedge between EES & EWS Long Term: Gas Solution & Power Solution
Power Specific Issues
[NAME] |  | X | [NAME] | [NAME] | X |  |  |  |  |  |  | X |  |  | ST - Ongoing; Aug - Enpwr  MT - Sep  LT - Jan | Short Term: Current batch processes continue to be maintained; Capture all wholesale deals in Enpower; Integrate Enpower P&L and positions with RPS P&L and positions. [NAME]: Quick hit RPS/Enpower valuation buildout to reduce batch usage; IT Systems Buildout Long Term: New Systems Development
Validation Does Not Support All Risk Components |  | X | [NAME] | [NAME] | X | X |  |  |  |  |  | X |  |  | ST - Jul MT - Aug LT - Jan | Short Term: Proof of concept on Site Profile project [NAME]: Tariff curve database and tariff reporting [NAME]: IT system buildout
No Intramonth Reporting:  -  Positions   -  Valuation |  | X | [NAME] | [NAME] | X | X |  |  |  |  |  | X |  |  | MT - Sep  LT - Jan | Mid Term: Real time solutions above; load profiling & forecasting at daily/hourly increments [NAME]: Power Solution
No Liquidation |  | X | [NAME] [NAME] | [NAME] | X | X | X |  |  |  |  | X |  |  | ST - Jul LT - Jan | Short Term:  Pull liquidations from current batch processes [NAME]: Power solution
No Actualization |  | X | [NAME] [NAME] Herod | [NAME] | X | X | X |  |  | X | X | X |  |  | MT - Aug  LT - Q401/Q102 | Mid Term: Populate repository w/CSC invoice data "Ranger Short Term Deliverable" [NAME]: [NAME], [NAME], EWS Settlement support
Book Structure is Non-Existent |  | X | [NAME] | [NAME] | X | X | X |  |  |  |  | X |  |  | ST - Jul LT - Jan | Short Term:  Continue to "Shoe Horn" book structure [NAME]: Power Solution
Intrabook Activity (Tariff vs [NAME]); Commodity vs. Consumption; Site Profile |  | X | [NAME] | [NAME] | X | X |  |  |  |  |  | X |  |  | MT - Aug  LT - Jan | Mid Term: Review feasibility of deal rebooking to split out risks & ongoing maintenance [NAME]: Power Solution
Option Valuation |  | X | [NAME] | [NAME] | X | X |  | X |  |  |  | X |  |  | MT - Q301 LT - Jan | Mid Term: Spreadsheet models for day to day positions & P/L; Integration of regulatory switching options [NAME]: Power Solution
Curve Database Repository |  | X | [NAME] | [NAME] | X | X |  |  |  |  |  | X |  |  | MT - Aug/Sep | Mid Term: Implementation of the tariff curve database;  Implementation of the commodity curve database
Gas Specific Issues
Validation Does Not Support All Risk Components | X |  | [NAME] | [NAME]    Ramesh Rao | X | X |  |  | X |  |  |  |  |  | ST - Jul LT - Oct | Short Term: Proof of concept on Site Profile project [NAME]: IT system buildout for term business; physical business issues will be resolved with [NAME]
No Intramonth Reporting:  -  Positions   -  Valuation | X |  | [NAME] | [NAME]    Ramesh Rao | X | X |  |  | X |  |  |  |  |  | MT - Aug LT - Oct | Mid Term: Develop position reports using Altra data [NAME]: Gas Solution
No Actualization | X |  | [NAME] | [NAME]    Ramesh Rao | X | X | X |  | X | X | X |  |  |  | LT - Q401 | Long Term: [NAME], [NAME], EWS Settlement Support projects
Intrabook Activity Tariff; Commodity vs. Consumption; Site Profile | X |  | [NAME] | [NAME]    Ramesh Rao | X | X |  |  | X |  |  |  |  |  | LT - Q401 | Long Term: Gas Solution
Option Valuation | X |  | [NAME] | [NAME]    Ramesh Rao | X | X |  | X | X |  |  |  |  |  | MT - Q301 LT - Q401 | Mid Term: Spreadsheet models for day to day positions & P/L Long Term: Gas Solution
Billing System/Cash Issues
[NAME] in 13 Systems; Outsourced; [NAME] to Actual Impossible in Current State; No Consolidated Reporting; Info Not Flowing To Enron Often Enough | X | X | [NAME] | Neal Symms | X | X | X |  | X | X | X |  |  |  | ST - July  MT - Sept  LT - 2002 | Short Term: Develop one-off reports w/CSC each month to get actual [NAME]: Project Ranger Data Warehouse to pull info in consistent format [NAME]: Project Genysis (new consolidated billing system potentially w/new service provider)
Stabilizing in House Billing Complexities | X | X | [NAME] | Neal Symms | X | X | X | X | X |  |  |  |  |  | ST - Ongoing  MT - Sept  LT - 2002 | Short Term: Review individual excel models & update based upon Phoenix findings [NAME]: Same short term; Convert excel models to Oracle database for stability (Project Blizzard) [NAME]: Project [NAME]
CSC Relationship as Service Provider;  CSC Accountability; Improvement of Service w/Industry | X | X | [NAME] | Neal Symms | X | X | X |  | X |  | X |  |  |  | ST - Aug  MT - Sept  LT - 2002 | Short Term: Team created to visit/Study other options and present potential solutions.  Will be expensive [NAME]: Make decision on service provider vs in-house/ look at terminating relationship with CSC                Long Term: Develop and Implement decision focusing on "bulk" transactions first
No Regular Controls Reporting (Detailed Aging; [NAME] To Actual; Metrics) | X | X | [NAME] | Neal Symms | X | X | X |  | X | X | X | X |  |  | MT -  Q401 | Mid Term: Implementation of Global Data Reporting (Similar to ENA/EPMI Reporting.
No Cash Forecasting (See Liquidations Above) | X | X | [NAME] | Neal Symms | X | X | X |  | X | X | X |  |  |  | MT -  Q401 | Mid Term: Establish cash control & forecast reporting processes
Flash To Actual process (Dependent on Risk / Billing Projects Above)
No Regular Actualization for Risk Books | X | X | [NAME] | NEED NAME | X | X | X |  | X |  |  | X |  |  |  | < See Risk Issues Above >
Liquidation Issues |  | X | [NAME] | NEED NAME | X | X | X |  |  |  |  | X |  |  | MT - Jul LT - Jan | Mid Term: Pull liquidations from batches [NAME]: Power Solution
Billing Info Consolidation / Consistency Issues; No Balance Sheet Reconciliation's (Roll MTM; Control Flash to Actual) | X | X | [NAME] | NEED NAME | X | X | X |  | X | X | X |  |  |  | ST - July  MT - Sept  LT - 2002 | Short Term: Develop one-off reports with CSC each month to get actual [NAME]: Project Ranger Data Warehouse development to pull all info in a consistent format [NAME]: [NAME] (new consolidated billing system - potentially with new service provider)