Spreadsheet: errol_mclaughlin_jr__10297__103820OPMHoursSurveyJan01
Sheet: 105620

Cost Center - 103820 Financial Gas Support |  |  |  |  |  |  |  | Avg. hours/month (assume 40 hour/week) | 168
POSITIONS | MGR | SSP | SPE | ANA | STA | SCL | CLK | TPC | TOTAL
# of FTE's |  | 2 | 4 | 2 |  | 1
ACTIVITIES
DS001 - Deal/Data Set Up |  |  | 114 | 20 |  | 108
RM001 - Calculating Books |  | 160 | 478 | 160 |  | 50
RM002 - Routine Trading Monitoring and Reporting
ES001 - Adminstrative Support & Ad Hoc Requests |  | 56 | 66 |  |  | 10
ES002 - Non Routine Trade Monitoring & Reporting
[NAME] to Actual (OA)
ES006 - Process Improvements |  |  | 40 | 28
TOTAL
Check figure
Activity Definitions
DS001 - Deal/Data Setup | * | notification of new facilities, contracts, or counterparties
 | * | gathering information
 | * | setup in global facilities, contracts, or counterparties databases
 | * | entering settled prices both manually and through automated downloads
 | * | handing out or collection of deal tickets
 | * | entering deals including NYMEX, OTC, EFP, EOL, and Triggers
 | * | notify users of additions/deletions
RM001 - Calculating Books | * | curve validation (perform rotation schedule for curves)
 | * | curve setup
 | * | calculating the books (both manual and automated)
 | * | calc sheets (price updates to deals)
 | * | issue, resolution to traders' questions
 | * | preparing/generating reports
 | * | dealing with all variances and issues that arise
RM002 - Routine Trading Monitoring and Reporting | * | daily intelligence gathering, including pipeline information, position worksheets, storage levels, and any other data deemed critical or
 |  | useful to traders/originators
 | * | monitoring day forward trades to ensure books are flat
 | * | monitoring trading activities (internal and external)
 | * | resolving issues that stem from trading (bridge monitoring)
 | * | Reporting for daily, monthly, year to date, etc. trading activities
ES001 - Administrative Support and Ad Hoc Requests | * | projects related to administrative work, ie data cleanup
 | * | preparing/generating reports
 | * | planning and budgeting
 | * | employee training, coaching, evaluation
 | * | HR related tasks; recruiting, PRC, new hires, mentoring, etc.
ES002 - Non Routine Commercial Support and Ad Hoc Requests | * | issue, resolution to traders' questions outside of daily operational issues
 | * | special projects
 | * | preparing/generating reports
[NAME] to Actual (OA) | * | reviewing liquidation report and resolving imbalances
 | * | proactive month to date liquidation report for analysis of positions
 | * | phase I and II, identifying discrepancies between data captured at flash and at settlements both during the month and at the end of the month
 | * | verify customer data is correct from the OA variance report
 | * | verify internal information is accurate, ie systems are consistent
 | * | consolidating accounting data at an entity level for interface with Gas Accounting
 | * | analyze price and volumes (for PMA's, transport expense, imbalances, storage and synthetic storage by region by pipeline)
 | * | reviewing historical variances and making adjustments as needed
ES006 - Technology Maintenance and  Process Improvements | * | system design, development, testing, implementation, and training
 | * | set up and testing of pipes to EDI, using GISB standards
 | * | identifying, coordinating, and implementing opportunities for improvements in our commodity processes
 | * | production or user support (ie Unify, Sitara, Enpower, TAGG, etc)