Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: 107061

Cost Center Name | NA-Power Trading
Cost Center Number | 107061
ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA
O&M REPORTING |  |  |  |  |  |  |  |  |  |  |  |  | O&M REPORTING
ENA  Power Trading - Elizabeth Sager (107061)
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 | 280695.15 |  | 75229 |  | -205466.15 | 1 | 824233.45 |  | 451374 |  | -372859.45 |  | Salaries and Wages | 72537.48 |  | 93508.26 |  | 111112.06 |  | 105689.82 |  | 160690.68 |  | 280695.15 |  | 75229 |  | 75229 |  | 75229 |  | 75229 |  | 75229 |  | 75229 |  | 1275607.45 |  | 902748 |  | -372859.45
Benefits | 15609.68 |  | 10959 |  | -4650.68 | 1 | 85014.92 |  | 65754 |  | -19260.92 |  | Benefits | 10880.6 |  | 12910.13 |  | 18900.17 |  | 14704.56 |  | 12009.78 |  | 15609.68 |  | 10959 |  | 10959 |  | 10959 |  | 10959 |  | 10959 |  | 10959 |  | 150768.92 |  | 131508 |  | -19260.92
Payroll Taxes | 12261.98 |  | 5950 |  | -6311.98 | 1 | 54004.32 |  | 35700 |  | -18304.32 |  | Payroll Taxes | 16046.32 |  | 22834.07 |  | -7194.73 |  | 6021.47 |  | 4035.21 |  | 12261.98 |  | 5950 |  | 5950 |  | 5950 |  | 5950 |  | 5950 |  | 5950 |  | 89704.32 |  | 71400 |  | -18304.32
Employee Expense | 3218.38 |  | 5645 |  | 2426.62 |  | 19051.65 |  | 33870 |  | 14818.35 |  | Employee Expense | 57.81 |  | 1723.24 |  | 3428.28 |  | 7205.47 |  | 3418.47 |  | 3218.38 |  | 5645 |  | 5645 |  | 5645 |  | 5645 |  | 5645 |  | 5645 |  | 52921.65 |  | 67740 |  | 14818.35
Supplies & Expense | 733.77 |  | 1250 |  | 516.23 |  | 3113.95 |  | 7500 |  | 4386.05 |  | Supplies & Expense | 265.18 |  | 484.44 |  | 625.5 |  | 612.09 |  | 392.97 |  | 733.77 |  | 1250 |  | 1250 |  | 1250 |  | 1250 |  | 1250 |  | 1250 |  | 10613.95 |  | 15000 |  | 4386.05
Outside Services | 251486.33 |  | 0 |  | -251486.33 | 2 | 1131268.1 |  | 0 |  | -1131268.1 |  | Outside Services | 0 |  | 31.06 |  | 304444.4 |  | 571395.34 |  | 3910.97 |  | 251486.33 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1131268.1 |  | 0 |  | -1131268.1
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 | 6404.01 |  | 0 |  | -6404.01 | 3 | 35460.9 |  | 0 |  | -35460.9 |  | Travel & Entertainment | 4190.63 |  | 3179.33 |  | 3877.45 |  | 7999.8 |  | 9809.68 |  | 6404.01 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 35460.9 |  | 0 |  | -35460.9
Rent | 35.44 |  | 0 |  | -35.44 |  | 35.44 |  | 0 |  | -35.44 |  | Rent | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 35.44 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 35.44 |  | 0 |  | -35.44
Transportation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Transportation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other | 218.34 |  | 0 |  | -218.34 |  | 1061.33 |  | 0 |  | -1061.33 |  | Other | 0 |  | 66.84 |  | 775.29 |  | 0 |  | 0.86 |  | 218.34 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1061.33 |  | 0 |  | -1061.33
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 | 4041.52 |  | 0 |  | -4041.52 | 4 | 4461.21 |  | 0 |  | -4461.21 |  | Technology | 0 |  | 0 |  | 419.69 |  | 0 |  | 0 |  | 4041.52 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4461.21 |  | 0 |  | -4461.21
System Development | 0 |  | 64 |  | 64 |  | 0 |  | 384 |  | 384 |  | System Development | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 64 |  | 64 |  | 64 |  | 64 |  | 64 |  | 64 |  | 384 |  | 768 |  | 384
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 | 458.5 |  | 0 |  | -458.5 |  | 548.5 |  | 0 |  | -548.5 |  | Taxes Other than Income | 73.93 |  | 15.54 |  | 0.53 |  | 0 |  | 0 |  | 458.5 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 548.5 |  | 0 |  | -548.5
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) | 2814.2 |  | 1374 |  | -1440.2 | 5 | 5142.03 |  | 8244 |  | 3101.97 |  | Controllable Infrastructure (EIS) | 0 |  | 335.32 |  | 659.49 |  | 1003.02 |  | 330 |  | 2814.2 |  | 1374 |  | 1374 |  | 1374 |  | 1374 |  | 1374 |  | 1374 |  | 13386.03 |  | 16488 |  | 3101.97
EPSC Allocations (Corp Rent) | 6563.58 |  | 7882 |  | 1318.42 |  | 14772.42 |  | 47292 |  | 32519.58 |  | EPSC Allocations (Corp Rent) | 54.1 |  | 462.93 |  | 825.54 |  | 709.86 |  | 6156.41 |  | 6563.58 |  | 7882 |  | 7882 |  | 7882 |  | 7882 |  | 7882 |  | 7882 |  | 62064.42 |  | 94584 |  | 32519.58
Total Direct Expenses | 584540.88 |  | 108353 |  | -476187.88 |  | 2178168.22 |  | 650118 |  | -1528050.22 |  | Total Direct Expenses | 104106.05 |  | 135551.16 |  | 437873.67 |  | 715341.43 |  | 200755.03 |  | 584540.88 |  | 108353 |  | 108353 |  | 108353 |  | 108353 |  | 108353 |  | 108353 |  | 2828286.22 |  | 1300236 |  | -1528050.22
Allocations-I/C Billing | -195836.16 |  | 0 |  | 195836.16 |  | -1081883.4 |  | 0 |  | 1081883.4 |  | Allocations-I/C Billing | -4248.44 |  | 0 |  | -307580.19 |  | -573568.61 |  | -650 |  | -195836.16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -1081883.4 |  | 0 |  | 1081883.4
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 | 388704.72 |  | 108353 |  | -280351.72 |  | 1096284.82 |  | 650118 |  | -446166.8199999994 |  | Net Direct Expenses | 99857.61 |  | 135551.16 |  | 130293.48 |  | 141772.82 |  | 200105.03 |  | 388704.72 |  | 108353 |  | 108353 |  | 108353 |  | 108353 |  | 108353 |  | 108353 |  | 1746402.82 |  | 1300236 |  | -446166.8199999991
Headcount | 12 |  | 10 |  | -2 |  | 10 |  | 10 |  |  |  | Headcount | 10 |  | 10 |  | 10 |  | 10 |  | 9 |  | 12 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  |  | 10
[NAME] explanations:
1.  Unfavorable variances due to actual headcount 2 over plan and June special pays of $150K.
2.  Actual expense includes a placement fee from CKB Inc. of $53K for H. Murphy.
3.  Unfavorable variance due to traveling costs to Portland; 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 a computer purchase.
5.  Unfavorable variance due to long distance charges for April thru June.