Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: 105660

Cost Center Name | NA-Employment Lit
Cost Center Number | 105660
ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA
O&M REPORTING |  |  |  |  |  |  |  |  |  |  |  |  | O&M REPORTING
ENA  Labor & Employment Law - Michelle Cash (105660)
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 | 18166.68 |  | 12647 |  | -5519.68 | 1 | 107558.4 |  | 75882 |  | -31676.4 |  | Salaries and Wages | 17225.02 |  | 17333.34 |  | 19333.34 |  | 17333.34 |  | 18166.68 |  | 18166.68 |  | 12647 |  | 12647 |  | 12647 |  | 12647 |  | 12647 |  | 12647 |  | 183440.4 |  | 151764 |  | -31676.4
Benefits | 2633.06 |  | 1570 |  | -1063.06 | 1 | 15401.49 |  | 9420 |  | -5981.49 |  | Benefits | 2128.22 |  | 2162.44 |  | 3320.2 |  | 2470 |  | 2687.57 |  | 2633.06 |  | 1570 |  | 1570 |  | 1570 |  | 1570 |  | 1570 |  | 1570 |  | 24821.49 |  | 18840 |  | -5981.49
Payroll Taxes | 567.77 |  | 697 |  | 129.23 |  | 4312.24 |  | 4182 |  | -130.24 |  | Payroll Taxes | 1486.08 |  | 6029.98 |  | -4884.25 |  | 555.69 |  | 556.97 |  | 567.77 |  | 697 |  | 697 |  | 697 |  | 697 |  | 697 |  | 697 |  | 8494.24 |  | 8364 |  | -130.24
Employee Expense | 84.66 |  | 250 |  | 165.34 |  | 1044.59 |  | 1500 |  | 455.41 |  | Employee Expense | 785.31 |  | -21.25 |  | 195.87 |  | 0 |  | 0 |  | 84.66 |  | 250 |  | 250 |  | 250 |  | 250 |  | 250 |  | 250 |  | 2544.59 |  | 3000 |  | 455.41
Supplies & Expense | 250.09 |  | 233 |  | -17.09 |  | 816.14 |  | 1398 |  | 581.86 |  | Supplies & Expense | 290.05 |  | 102.2 |  | 57.39 |  | 116.41 |  | 0 |  | 250.09 |  | 233 |  | 233 |  | 233 |  | 233 |  | 233 |  | 233 |  | 2214.14 |  | 2796 |  | 581.86
Outside Services | 3441.2 |  | 0 |  | -3441.2 | 2 | 19738.25 |  | 0 |  | -19738.25 |  | Outside Services | -12563.01 |  | 18343.42 |  | 10053.74 |  | 0 |  | 462.9 |  | 3441.2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 19738.25 |  | 0 |  | -19738.25
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 | 533.02 |  | 0 |  | -533.02 | 3 | 5170.43 |  | 0 |  | -5170.43 |  | Travel & Entertainment | 295 |  | 2522.86 |  | 1819.55 |  | 0 |  | 0 |  | 533.02 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5170.43 |  | 0 |  | -5170.43
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 | 0 |  | 0 |  | 0 |  | 2578.31 |  | 0 |  | -2578.31 |  | Other | 84.53 |  | -84.53 |  | 0 |  | 0 |  | 2578.31 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2578.31 |  | 0 |  | -2578.31
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 | 0 |  | 0 |  | 0 |  | 1452 |  | 0 |  | -1452 |  | Technology | 1452 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1452 |  | 0 |  | -1452
System Development | 0 |  | 6 |  | 6 |  | 0 |  | 36 |  | 36 |  | System Development | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 36 |  | 72 |  | 36
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 | 0 |  | 0 |  | 0 |  | 18 |  | 0 |  | -18 |  | Taxes Other than Income | 14.56 |  | 3.44 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 18 |  | 0 |  | -18
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) | 242.31 |  | 137 |  | -105.31 | 4 | 1289.19 |  | 822 |  | -467.19 |  | Controllable Infrastructure (EIS) | 0 |  | 701.31 |  | 235.57 |  | 55 |  | 55 |  | 242.31 |  | 137 |  | 137 |  | 137 |  | 137 |  | 137 |  | 137 |  | 2111.19 |  | 1644 |  | -467.19
EPSC Allocations (Corp Rent) | 1612.94 |  | 1915 |  | 302.06 |  | 12869.32 |  | 11490 |  | -1379.32 |  | EPSC Allocations (Corp Rent) | 977.72 |  | 3627.67 |  | 2157.54 |  | 2757.79 |  | 1735.66 |  | 1612.94 |  | 1915 |  | 1915 |  | 1915 |  | 1915 |  | 1915 |  | 1915 |  | 24359.32 |  | 22980 |  | -1379.32
Total Direct Expenses | 27531.73 |  | 17455 |  | -10076.73 |  | 172248.36 |  | 104730 |  | -67518.36 |  | Total Direct Expenses | 12175.48 |  | 50720.88 |  | 32288.95 |  | 23288.23 |  | 26243.09 |  | 27531.73 |  | 17455 |  | 17455 |  | 17455 |  | 17455 |  | 17455 |  | 17455 |  | 276978.36 |  | 209460 |  | -67518.36
Allocations-I/C Billing | -817.42 |  | 0 |  | 817.42 |  | -13347.29 |  | 0 |  | 13347.29 |  | Allocations-I/C Billing | 12278.15 |  | -12332.02 |  | -12013.1 |  | 0 |  | -462.9 |  | -817.42 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -13347.29 |  | 0 |  | 13347.29
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 | 26714.31 |  | 17455 |  | -9259.310000000007 |  | 158901.07 |  | 104730 |  | -54171.07 |  | Net Direct Expenses | 24453.63 |  | 38388.86 |  | 20275.85 |  | 23288.23 |  | 25780.19 |  | 26714.31 |  | 17455 |  | 17455 |  | 17455 |  | 17455 |  | 17455 |  | 17455 |  | 263631.07 |  | 209460 |  | -54171.07
Headcount | 2 |  | 1 |  | -1 |  | 2 |  | 1 |  | -1 |  | Headcount | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  | 1 |  | -0.5
[NAME] explanations:
1.  Unfavorable variances due to actual headcount 1 over plan.
2.  Unfavorable variance due to cost incurred for investigative services provided by SJ Bashen Corp relating to employee
issues for $2,530.50.
3.  Unfavorable variance due to traveling costs to San Antonio; Travel and Entertainment has a zero plan
number because it was originally lumped into Employee Expense.  This will be corrected in July.
4.  Unfavorable variance due to long distance charges for April thru June.