Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: 105657

Cost Center Name | NA-Phys & Fin Tradin
Cost Center Number | 105657
ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA
O&M REPORTING |  |  |  |  |  |  |  |  |  |  |  |  | O&M REPORTING
ENA  Financial Trading - Mark Taylor (105657)
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 | 216712.66 |  | 146238 |  | -70474.66 | 1 | 1145459.74 |  | 877428 |  | -268031.74 |  | Salaries and Wages | 149560.27 |  | 171177.84 |  | 167903.06 |  | 168320.73 |  | 271785.18 |  | 216712.66 |  | 146238 |  | 146238 |  | 146238 |  | 146238 |  | 146238 |  | 146238 |  | 2022887.74 |  | 1754856 |  | -268031.74
Benefits | 23455.24 |  | 19927 |  | -3528.24 | 1 | 140806.25 |  | 119562 |  | -21244.25 |  | Benefits | 19625.97 |  | 17092.33 |  | 31465.25 |  | 25339.38 |  | 23828.08 |  | 23455.24 |  | 19927 |  | 19927 |  | 19927 |  | 19927 |  | 19927 |  | 19927 |  | 260368.25 |  | 239124 |  | -21244.25
Payroll Taxes | 8511.21 |  | 10037 |  | 1525.79 |  | 79349.23 |  | 60222 |  | -19127.23 |  | Payroll Taxes | 22161.85 |  | 39440.13 |  | -10941.08 |  | 10231.77 |  | 9945.35 |  | 8511.21 |  | 10037 |  | 10037 |  | 10037 |  | 10037 |  | 10037 |  | 10037 |  | 139571.23 |  | 120444 |  | -19127.23
Employee Expense | 3975.23 |  | 7515 |  | 3539.77 |  | 38761.27 |  | 45090 |  | 6328.73000000001 |  | Employee Expense | 3883.36 |  | 8991.44 |  | 9388.28 |  | 5623.92 |  | 6899.04 |  | 3975.23 |  | 7515 |  | 7515 |  | 7515 |  | 7515 |  | 7515 |  | 7515 |  | 83851.27 |  | 90180 |  | 6328.73
Supplies & Expense | 923.42 |  | 1491 |  | 567.58 |  | 13712.86 |  | 8946 |  | -4766.86 |  | Supplies & Expense | 2407.67 |  | 2880.28 |  | 3539.3 |  | 2377.94 |  | 1584.25 |  | 923.42 |  | 1491 |  | 1491 |  | 1491 |  | 1491 |  | 1491 |  | 1491 |  | 22658.86 |  | 17892 |  | -4766.86
Outside Services | 59501.2 |  | 87947 |  | 28445.8 |  | 342394.58 |  | 527682 |  | 185287.42 |  | Outside Services | -34180.8 |  | 97411.22 |  | 84529.57 |  | 6477.36 |  | 128656.03 |  | 59501.2 |  | 87947 |  | 87947 |  | 87947 |  | 146578 |  | 146578 |  | 381102 |  | 1280493.58 |  | 1465781 |  | 185287.42
Outside Tax | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Outside Tax | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Travel & Entertainment | 8002.64 |  | 0 |  | -8002.64 | 2 | 27710.48 |  | 0 |  | -27710.48 |  | Travel & Entertainment | 2955.46 |  | 632.44 |  | 2211.98 |  | 5247.72 |  | 8660.24 |  | 8002.64 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 27710.48 |  | 0 |  | -27710.48
Rent | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Rent | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Transportation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Transportation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other | 776.94 |  | 0 |  | -776.94 |  | 5933.08 |  | 0 |  | -5933.08 |  | Other | 1085.86 |  | 492.42 |  | 2396.08 |  | 1011.27 |  | 170.51 |  | 776.94 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5933.08 |  | 0 |  | -5933.08
Marketing | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Marketing | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Charitable Contributions | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Charitable Contributions | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Technology | 1055.57 |  | 0 |  | -1055.57 |  | 8817.99 |  | 0 |  | -8817.99 |  | Technology | 4366.62 |  | 3019.71 |  | 13.98 |  | 362.11 |  | 0 |  | 1055.57 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 8817.99 |  | 0 |  | -8817.99
System Development | 0 |  | 103 |  | 103 |  | 0 |  | 618 |  | 618 |  | System Development | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 103 |  | 103 |  | 103 |  | 103 |  | 103 |  | 103 |  | 618 |  | 1236 |  | 618
Insurance | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Insurance | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Taxes Other than Income | 5.58 |  | 0 |  | -5.58 |  | 167.13 |  | 0 |  | -167.13 |  | Taxes Other than Income | 101.81 |  | 38.95 |  | 6.11 |  | 9.04 |  | 5.64 |  | 5.58 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 167.13 |  | 0 |  | -167.13
Deprec./Amor. Expense | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Deprec./Amor. Expense | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Controllable Infrastructure (EIS) | 7828.69 |  | 2198 |  | -5630.69 | 3 | 14290.94 |  | 13188 |  | -1102.94 |  | Controllable Infrastructure (EIS) | 0 |  | 3294.98 |  | 1427.24 |  | 860.7 |  | 879.33 |  | 7828.69 |  | 2198 |  | 2198 |  | 2198 |  | 2198 |  | 2198 |  | 2198 |  | 27478.94 |  | 26376 |  | -1102.94
EPSC Allocations (Corp Rent) | 15370.78 |  | 11823 |  | -3547.78 | 1 | 173256.56 |  | 70938 |  | -102318.56 |  | EPSC Allocations (Corp Rent) | 12496.01 |  | 57453.54 |  | 35450.1 |  | 36951.23 |  | 15534.9 |  | 15370.78 |  | 11823 |  | 11823 |  | 11823 |  | 11823 |  | 11823 |  | 11823 |  | 244194.56 |  | 141876 |  | -102318.56
Total Direct Expenses | 346119.16 |  | 287279 |  | -58840.16000000009 |  | 1990660.11 |  | 1723674 |  | -266986.11 |  | Total Direct Expenses | 184464.08 |  | 401925.28 |  | 327389.87 |  | 262813.17 |  | 467948.55 |  | 346119.16 |  | 287279 |  | 287279 |  | 287279 |  | 345910 |  | 345910 |  | 580434 |  | 4124751.11 |  | 3857765 |  | -266986.11
Allocations-I/C Billing | -212041.87 |  | -232323.96 |  | -20282.09000000005 |  | -1073364.08 |  | -1393943.76 |  | -320579.68 |  | Allocations-I/C Billing | -135322.39 |  | -179279.32 |  | -215017.39 |  | -153072.61 |  | -178630.5 |  | -212041.87 |  | -232323.96 |  | -232323.96 |  | -232323.96 |  | -290955 |  | -290955 |  | -525479.33 |  | -2877725.29 |  | -3198304.97 |  | -320579.68
Allocations - Other | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Allocations - Other | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Net Direct Expenses | 134077.29 |  | 54955.04 |  | -79122.25000000015 |  | 917296.03 |  | 329730.24 |  | -587565.79 |  | Net Direct Expenses | 49141.69 |  | 222645.96 |  | 112372.48 |  | 109740.56 |  | 289318.05 |  | 134077.29 |  | 54955.04 |  | 54955.04 |  | 54955.04 |  | 54955 |  | 54955 |  | 54954.66999999993 |  | 1247025.82 |  | 659460.03 |  | -587565.79
Headcount | 18 |  | 16 |  |  |  | 19 |  | 16 |  |  |  | Headcount | 20 |  | 19 |  | 20 |  | 20 |  | 18 |  | 18 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16 |  |  |  | 16
[NAME] explanations:
1.  Unfavorable variances due to June special pays of $50K and bonus of $15K , and actual headcount is 2 over plan.
2.  Unfavorable variance due to traveling costs to New York; Travel and Entertainment has a zero plan number because it was
originally lumped into Employee Expense.  This will be corrected in July.
3.  Unfavorable variance due to long distance charges for April thru June and 2 flat panels purchase.