Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: 105653

Cost Center Name | NA-Finance Orig M&A
Cost Center Number | 105653
ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA
O&M REPORTING |  |  |  |  |  |  |  |  |  |  |  |  | O&M REPORTING
ENA  Finance Orig M&A - Schuler/[NAME] (105653)
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 | 136282.41 |  | 165040 |  | 28757.59 |  | 903974.69 |  | 990240 |  | 86265.30999999959 |  | Salaries and Wages | 180566.13 |  | 140466.61 |  | 146755.53 |  | 138787.3 |  | 161116.71 |  | 136282.41 |  | 165040 |  | 165040 |  | 165040 |  | 165040 |  | 165040 |  | 165040 |  | 1894214.69 |  | 1980480 |  | 86265.31000000006
Benefits | 20404.9 |  | 20866 |  | 461.1000000000022 |  | 131794.55 |  | 125196 |  | -6598.550000000047 |  | Benefits | 20201.22 |  | 15689.45 |  | 29409.71 |  | 20205.79 |  | 25883.48 |  | 20404.9 |  | 20866 |  | 20866 |  | 20866 |  | 20866 |  | 20866 |  | 20866 |  | 256990.55 |  | 250392 |  | -6598.550000000017
Payroll Taxes | 4353.92 |  | 9524 |  | 5170.08 |  | 48360.24 |  | 57144 |  | 8783.76 |  | Payroll Taxes | 20324.38 |  | 39481.22 |  | -26798.04 |  | 5745.17 |  | 5253.59 |  | 4353.92 |  | 9524 |  | 9524 |  | 9524 |  | 9524 |  | 9524 |  | 9524 |  | 105504.24 |  | 114288 |  | 8783.76000000001
Employee Expense | 3694.45 |  | 16216 |  | 12521.55 |  | 22114.3 |  | 97296 |  | 75181.7 |  | Employee Expense | 5263.11 |  | 1518.12 |  | 638.92 |  | 5387.93 |  | 5611.77 |  | 3694.45 |  | 16216 |  | 16216 |  | 16216 |  | 16216 |  | 16216 |  | 16216 |  | 119410.3 |  | 194592 |  | 75181.7
Supplies & Expense | 639.28 |  | 5771 |  | 5131.72 |  | 7733.37 |  | 34626 |  | 26892.63 |  | Supplies & Expense | 928.05 |  | 2030.12 |  | 1642.87 |  | 1373.29 |  | 1119.76 |  | 639.28 |  | 5771 |  | 5771 |  | 5771 |  | 5771 |  | 5771 |  | 5771 |  | 42359.37 |  | 69252 |  | 26892.63
Outside Services | 104504.54 |  | 0 |  | -104504.54 |  | 996056.6300000007 |  | 0 |  | -996056.6300000007 |  | Outside Services | -894820.88 |  | 529521.78 |  | 717635.97 |  | 372505.15 |  | 166710.07 |  | 104504.54 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 996056.63 |  | 0 |  | -996056.63
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 | 10428.69 |  | 0 |  | -10428.69 | 1 | 82311.69 |  | 0 |  | -82311.69 |  | Travel & Entertainment | 7284.09 |  | 3521.49 |  | 5684.38 |  | 18894.17 |  | 36498.87 |  | 10428.69 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 82311.69 |  | 0 |  | -82311.69
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 | 3671.28 |  | 0 |  | -3671.28 | 2 | 4875.88 |  | 0 |  | -4875.88 |  | Other | 701.01 |  | -438.06 |  | 530.94 |  | 360 |  | 50.71 |  | 3671.28 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4875.88 |  | 0 |  | -4875.88
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 |  | 6768.45 |  | 0 |  | -6768.45 |  | Technology | 6406.34 |  | 362.11 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 6768.45 |  | 0 |  | -6768.45
System Development | 0 |  | 90 |  | 90 |  | 0 |  | 540 |  | 540 |  | System Development | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 90 |  | 90 |  | 90 |  | 90 |  | 90 |  | 90 |  | 540 |  | 1080 |  | 540
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 |  | 176.19 |  | 0 |  | -176.19 |  | Taxes Other than Income | 102.29 |  | 21.48 |  | 11.23 |  | -3.87 |  | 45.06 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 176.19 |  | 0 |  | -176.19
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) | 14816.23 |  | 1923 |  | -12893.23 | 3 | 20499.64 |  | 11538 |  | -8961.64 |  | Controllable Infrastructure (EIS) | -1969.7 |  | 1718.42 |  | 1543.76 |  | 1310.89 |  | 3080.04 |  | 14816.23 |  | 1923 |  | 1923 |  | 1923 |  | 1923 |  | 1923 |  | 1923 |  | 32037.64 |  | 23076 |  | -8961.64
EPSC Allocations (Corp Rent) | 15882.7 |  | 11220 |  | -4662.7 |  | 104651.98 |  | 67320 |  | -37331.98 |  | EPSC Allocations (Corp Rent) | 7053.31 |  | 23480.57 |  | 18711.78 |  | 24492.05 |  | 15031.57 |  | 15882.7 |  | 11220 |  | 11220 |  | 11220 |  | 11220 |  | 11220 |  | 11220 |  | 171971.98 |  | 134640 |  | -37331.98
Total Direct Expenses | 314678.4 |  | 230650 |  | -84028.40000000008 |  | 2329317.61 |  | 1383900 |  | -945417.6100000013 |  | Total Direct Expenses | -647960.65 |  | 757373.31 |  | 895767.05 |  | 589057.87 |  | 420401.63 |  | 314678.4 |  | 230650 |  | 230650 |  | 230650 |  | 230650 |  | 230650 |  | 230650 |  | 3713217.61 |  | 2767800 |  | -945417.6099999994
Allocations-I/C Billing | -127642.93 |  | -38217.54 |  | 89425.39 |  | -1709897.62 |  | -229305.24 |  | 1480592.38 |  | Allocations-I/C Billing | -79444.61 |  | -414966.78 |  | -590050.44 |  | -343549.44 |  | -154243.42 |  | -127642.93 |  | -38217.54 |  | -38217.54 |  | -38217.54 |  | -38217.54 |  | -38217.54 |  | -38217.54 |  | -1939202.86 |  | -458610.48 |  | 1480592.38
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 | 187035.47 |  | 192432.46 |  | 5396.989999999903 |  | 619419.9900000007 |  | 1154594.76 |  | 535174.7699999993 |  | Net Direct Expenses | -727405.26 |  | 342406.53 |  | 305716.61 |  | 245508.43 |  | 266158.21 |  | 187035.47 |  | 192432.46 |  | 192432.46 |  | 192432.46 |  | 192432.46 |  | 192432.46 |  | 192432.46 |  | 1774014.75 |  | 2309189.52 |  | 535174.7700000007
Headcount | 15 |  | 14 |  |  |  | 15 |  | 14 |  |  |  | Headcount | 15 |  | 14 |  | 15 |  | 17 |  | 16 |  | 15 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  |  |  | 14 |  | -0.9166666666666661
[NAME] explanations:
1.  Unfavorable variance due to zero plan number because it was originally lumped into
Employee Expense.  This will be corrected in July.
2.  Other actual expense includes charges for materials and supplies, subscription and a retainer fee of $2500.00 paid to [NAME].
3.  Unfavorable variance due to long distance charges for April thru June, 3 flat panels and 2 computers purchase and
Bloomberg fees.