Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: 105654

Cost Center Name | NA-Power Assets / PS Labor True Up
Cost Center Number | 105654
ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA
O&M REPORTING |  |  |  |  |  |  |  |  |  |  |  |  | O&M REPORTING
ENA  West Originations - Sheila Tweed (105654)
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 | 71925.93 |  | 101843 |  | 29917.07 | 1 | 512022.53 |  | 611058 |  | 99035.47000000009 |  | Salaries and Wages | 86187.85 |  | 88954.62 |  | 96143.07 |  | 96583.1 |  | 72227.96 |  | 71925.93 |  | 101843 |  | 101843 |  | 101843 |  | 101843 |  | 101843 |  | 101843 |  | 1123080.53 |  | 1222116 |  | 99035.47
Benefits | 11129.3 |  | 13420 |  | 2290.7 | 1 | 74357.18 |  | 80520 |  | 6162.820000000022 |  | Benefits | 14257.93 |  | 10781.99 |  | 17170.08 |  | 10755.92 |  | 10261.96 |  | 11129.3 |  | 13420 |  | 13420 |  | 13420 |  | 13420 |  | 13420 |  | 13420 |  | 154877.18 |  | 161040 |  | 6162.820000000007
Payroll Taxes | 4311.58 |  | 6482 |  | 2170.42 | 1 | 47571.06 |  | 38892 |  | -8679.060000000012 |  | Payroll Taxes | 12694.89 |  | 18538.88 |  | 1194.38 |  | 4923.86 |  | 5907.47 |  | 4311.58 |  | 6482 |  | 6482 |  | 6482 |  | 6482 |  | 6482 |  | 6482 |  | 86463.06 |  | 77784 |  | -8679.06
Employee Expense | 3615.73 |  | 22656 |  | 19040.27 |  | 18873.13 |  | 135936 |  | 117062.87 |  | Employee Expense | 3427.32 |  | 2384.82 |  | 3975.18 |  | 2795.98 |  | 2674.1 |  | 3615.73 |  | 22656 |  | 22656 |  | 22656 |  | 22656 |  | 22656 |  | 22656 |  | 154809.13 |  | 271872 |  | 117062.87
Supplies & Expense | 350.66 |  | 4899 |  | 4548.34 |  | 4834.15 |  | 29394 |  | 24559.85 |  | Supplies & Expense | 509.32 |  | 1030.28 |  | 2137.82 |  | 1374.47 |  | -568.4 |  | 350.66 |  | 4899 |  | 4899 |  | 4899 |  | 4899 |  | 4899 |  | 4899 |  | 34228.15 |  | 58788 |  | 24559.85
Outside Services |  |  | 0 |  |  |  | 2118050 |  | 0 |  |  |  | Outside Services | -67679.86 |  | 53610.18 |  | -20412.09 |  | 534477.95 |  | 782753.6 |  | 835300.49 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2080387.28 |  | 0 |  | -2080387.28
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 |  |  | 0 |  |  | 2 | 66751 |  | 0 |  |  |  | Travel & Entertainment | 2513.1 |  | 13404.04 |  | 8217.21 |  | 27780.02 |  | 13727.6 |  | 1109.33 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 104414.29 |  | 0 |  | -104414.29
Rent | 328.87 |  | 0 |  | -328.87 |  | 673.78 |  | 0 |  | -673.78 |  | Rent | 0 |  | 0 |  | 0 |  | 344.91 |  | 0 |  | 328.87 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 673.78 |  | 0 |  | -673.78
Transportation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Transportation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other | 1510.37 |  | 0 |  | -1510.37 |  | 5113.66 |  | 0 |  | -5113.66 |  | Other | 3031.5 |  | 46.01 |  | 403.43 |  | 64.15 |  | 58.2 |  | 1510.37 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5113.66 |  | 0 |  | -5113.66
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 | 198.1 |  | 0 |  | -198.1 |  | 1104.15 |  | 0 |  | -1104.15 |  | Technology | 906.05 |  | 0 |  | 0 |  | 0 |  | 0 |  | 198.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1104.15 |  | 0 |  | -1104.15
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 | 1229.76 |  | 0 |  | -1229.76 |  | 3244.16 |  | 0 |  | -3244.16 |  | Taxes Other than Income | 259.74 |  | 769.55 |  | 279.83 |  | 314.42 |  | 390.86 |  | 1229.76 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3244.16 |  | 0 |  | -3244.16
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) | 2852.61 |  | 1374 |  | -1478.61 | 3 | 7764.49 |  | 8244 |  | 479.5100000000011 |  | Controllable Infrastructure (EIS) | 0 |  | 1538.6 |  | 1558.77 |  | 876.31 |  | 938.2 |  | 2852.61 |  | 1374 |  | 1374 |  | 1374 |  | 1374 |  | 1374 |  | 1374 |  | 16008.49 |  | 16488 |  | 479.51
EPSC Allocations (Corp Rent) | 5845.25 |  | 6663 |  | 817.75 |  | 26667.14 |  | 39978 |  | 13310.86 |  | EPSC Allocations (Corp Rent) | 1697.72 |  | 4501.24 |  | 3544 |  | 5623.55 |  | 5455.38 |  | 5845.25 |  | 6663 |  | 6663 |  | 6663 |  | 6663 |  | 6663 |  | 6663 |  | 66645.14 |  | 79956 |  | 13310.86
Total Direct Expenses |  |  | 157401 |  | -782306.98 |  | 2887027 |  | 944406 |  | -1942621 |  | Total Direct Expenses | 57805.56 |  | 195560.21 |  | 114211.68 |  | 685914.64 |  | 893826.93 |  | 939707.98 |  | 157401 |  | 157401 |  | 157401 |  | 157401 |  | 157401 |  | 157401 |  | 3831433 |  | 1888812 |  | -1942621
Allocations-I/C Billing | -958749.98 |  | 0 |  | 958749.98 | 4 | -2380932.87 |  | 0 |  | 2380932.87 |  | Allocations-I/C Billing | 87073.77 |  | -203585.81 |  | 35422.75 |  | -557932.48 |  | -783161.12 |  | -958749.98 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2380932.87 |  | 0 |  | 2380932.87
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 | -19042.00000000035 |  | 157401 |  | 176443 |  | 506094.1300000008 |  | 944406 |  | 438311.8699999992 |  | Net Direct Expenses | 144879.33 |  | -8025.600000000006 |  | 149634.43 |  | 127982.16 |  | 110665.81 |  | -19042.00000000035 |  | 157401 |  | 157401 |  | 157401 |  | 157401 |  | 157401 |  | 157401 |  | 1450500.13 |  | 1888812 |  | 438311.87
Headcount | 9 |  | 10 |  | 1 |  | 9.333333333333334 |  | 10 |  | 0.6666666666666661 |  | Headcount | 10 |  | 10 |  | 9 |  | 8 |  | 7 |  | 9 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  |  | 10
[NAME] explanations:
1.  Favorable variances due to actual headcount one below plan.
2.  Unfavorable variance due to 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.
4.  Actual allocations do not reflect a reclass made in error of $153,542.83 for services; actual allocations amount should be
(805,207.17) as a result, the net direct expenses should be 134,500.83.  This will be corrected in July.