Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: Consolidated

Cost Center Name | Unhide cell B1 & B2 in Monthly Expense Categories; enter cost center group name in B1
Cost Center Number | Enter cost center numbers in cell B2 in Mo. Exp. Cat. Sheet
ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA
O&M REPORTING |  |  |  |  |  |  |  |  |  |  |  |  | O&M REPORTING
ENA  Legal - Consolidated
June 2001 Actual vs Plan |  |  |  |  |  |  |  |  |  |  |  |  | June 2001 Actual vs Plan
 | [NAME] |  | [NAME] |  | Monthly |  | [NAME] |  | [NAME] |  | YTD |  |  | [NAME] |  | Feb-01 |  | Mar-01 |  | Apr-01 |  | May-01 |  | [NAME] |  | Jul-01 |  | Aug-01 |  | Sep-01 |  | Oct-01 |  | [NAME] |  | Dec-01 |  | Total Yr |  | Total Yr |  | Total Yr
 | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  | Actual |  | Actual |  | Actual |  | Actual |  | Actual |  | Actual |  | Plan |  | Plan |  | Plan |  | Plan |  | Plan |  | Plan |  | Projection |  | Orig. Plan |  | [NAME]
Direct Expense: |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
Salaries and Wages |  |  |  |  |  | 1 |  |  |  |  |  |  | Salaries and Wages |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10769832
Benefits |  |  |  |  |  | 1 |  |  |  |  |  |  | Benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1433004
Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700644
Employee Expense |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1010184
Supplies & Expense |  |  |  |  |  |  |  |  |  |  |  |  | Supplies & Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 382476
Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4488105
Outside Tax |  |  |  |  |  |  |  |  |  |  |  |  | Outside Tax |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Travel & Entertainment |  |  |  |  |  | 2 |  |  |  |  |  |  | Travel & Entertainment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rent |  |  |  |  |  |  |  |  |  |  |  |  | Rent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other |  |  |  |  |  | 3 |  |  |  |  |  |  | Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13368
Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Marketing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Technology |  |  |  |  |  | 4 |  |  |  |  |  |  | Technology |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9660
System Development |  |  |  |  |  |  |  |  |  |  |  |  | System Development |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7008
Insurance |  |  |  |  |  |  |  |  |  |  |  |  | Insurance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Taxes Other than Income |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other than Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Deprec./Amor. Expense |  |  |  |  |  |  |  |  |  |  |  |  | Deprec./Amor. Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Controllable Infrastructure (EIS) |  |  |  |  |  | 5 |  |  |  |  |  |  | Controllable Infrastructure (EIS) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150012
EPSC Allocations (Corp Rent) |  |  |  |  |  | 6 |  |  |  |  |  |  | EPSC Allocations (Corp Rent) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 945240
Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19909533
Allocations-I/C Billing |  |  |  |  |  |  |  |  |  |  |  |  | Allocations-I/C Billing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9597270.49
Allocations - Other |  |  |  |  |  |  |  |  |  |  |  |  | Allocations - Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.731149137020111e-11
Net Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Net Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10312262.51
Headcount |  |  |  |  |  |  |  |  |  |  |  |  | Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
[NAME] explanations:
1.  Unfavorable variances due to special pays of $350K and bonus of $42K and headcount 7 over plan.  Also, the legal group for CALME
was moved to ENA and their plan dollars were not incorporated into the plan; their expenses are billed to EGM monthly at 25K.
2.  Unfavorable variance due to zero plan number because it was originally lumped into Employee Expense; this will be corrected in July.
Also, actual expense is over plan due to traveling costs to Tokyo, Portland, San Antonio and New York.
3.  Unfavorable variance due to charges for materials and supplies, postage and freight and fees and permits.
4.  Unfavorable variance due to computer purchases.
5.  Unfavorable variance due to long distance charges for April thru June, Bloomberg fees, computer and flat panel purchases.
6.  Unfavorable variance due to actual headcount 7 over plan and $14,778.40 will be reclassed to a capital work order for construction
buildout in May and June this July.