Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: 105659

Cost Center Name | NA-Gas Assets / Assistant
Cost Center Number | 105659
ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA
O&M REPORTING |  |  |  |  |  |  |  |  |  |  |  |  | O&M REPORTING
ENA  Upstream Originations - Gray/Hodge (105659)
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 | 283108.18 |  | 233353 |  | -49755.18 | 1 | 1189713.14 |  | 1400118 |  | 210404.86 |  | Salaries and Wages | 172458.66 |  | 176904.95 |  | 185655.98 |  | 163373.04 |  | 208212.33 |  | 283108.18 |  | 233353 |  | 233353 |  | 233353 |  | 233353 |  | 233353 |  | 233353 |  | 2589831.14 |  | 2800236 |  | 210404.86
Benefits | 20794.37 |  | 31185 |  | 10390.63 |  | 154295.57 |  | 187110 |  | 32814.43 |  | Benefits | 25473.24 |  | 21775.75 |  | 33639.31 |  | 25948.23 |  | 26664.67 |  | 20794.37 |  | 31185 |  | 31185 |  | 31185 |  | 31185 |  | 31185 |  | 31185 |  | 341405.57 |  | 374220 |  | 32814.43000000005
Payroll Taxes | 10346.24 |  | 15335 |  | 4988.76 |  | 91611.91 |  | 92010 |  | 398.0900000000111 |  | Payroll Taxes | 28491.12 |  | 42981.6 |  | -18022.82 |  | 8815.35 |  | 19000.42 |  | 10346.24 |  | 15335 |  | 15335 |  | 15335 |  | 15335 |  | 15335 |  | 15335 |  | 183621.91 |  | 184020 |  | 398.0899999999965
Employee Expense | 4498.12 |  | 10060 |  | 5561.88 |  | 20700.87 |  | 60360 |  | 39659.13 |  | Employee Expense | 4164.27 |  | 2386.01 |  | 862.48 |  | 3457.34 |  | 5332.65 |  | 4498.12 |  | 10060 |  | 10060 |  | 10060 |  | 10060 |  | 10060 |  | 10060 |  | 81060.87 |  | 120720 |  | 39659.13
Supplies & Expense | 1195.98 |  | 2615 |  | 1419.02 |  | 8648.14 |  | 15690 |  | 7041.86 |  | Supplies & Expense | 1888.06 |  | 1351.76 |  | 2175.62 |  | 1742.13 |  | 294.59 |  | 1195.98 |  | 2615 |  | 2615 |  | 2615 |  | 2615 |  | 2615 |  | 2615 |  | 24338.14 |  | 31380 |  | 7041.86
Outside Services | 364806.29 |  | 2314 |  | -362492.29 |  | 1079507.04 |  | 13884 |  | -1065623.04 |  | Outside Services | 32579.00999999991 |  | 37434.77 |  | 353134.05 |  | 354330.95 |  | -62778.03 |  | 364806.29 |  | 2314 |  | 2314 |  | 2314 |  | 3857 |  | 3857 |  | 10028 |  | 1104191.04 |  | 38568 |  | -1065623.04
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 | 5506.47 |  | 0 |  | -5506.47 | 2 | 60144.59 |  | 0 |  | -60144.59 |  | Travel & Entertainment | 12691.64 |  | 8116.43 |  | 16276.92 |  | 3915.82 |  | 13637.31 |  | 5506.47 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 60144.59 |  | 0 |  | -60144.59
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 | 250 |  | 0 |  | -250 |  | 857.48 |  | 0 |  | -857.48 |  | Other | -1488.34 |  | -956.53 |  | 0 |  | 3040.85 |  | 11.5 |  | 250 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 857.48 |  | 0 |  | -857.48
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 |  | 1992.38 |  | 0 |  | -1992.38 |  | Technology | 906.05 |  | 0 |  | 0 |  | 362.11 |  | 724.22 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1992.38 |  | 0 |  | -1992.38
System Development | 0 |  | 154 |  | 154 |  | 0 |  | 924 |  | 924 |  | System Development | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 154 |  | 154 |  | 154 |  | 154 |  | 154 |  | 154 |  | 924 |  | 1848 |  | 924
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 | 13.3 |  | 0 |  | -13.3 |  | 220.21 |  | 0 |  | -220.21 |  | Taxes Other than Income | 154.5 |  | 40.55 |  | 0.95 |  | 1.07 |  | 9.84 |  | 13.3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 220.21 |  | 0 |  | -220.21
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) | 9251.66 |  | 3297 |  | -5954.66 | 3 | 18653.96 |  | 19782 |  | 1128.04 |  | Controllable Infrastructure (EIS) | 0 |  | 3137.52 |  | 1701.81 |  | 2110.61 |  | 2452.36 |  | 9251.66 |  | 3297 |  | 3297 |  | 3297 |  | 3297 |  | 3297 |  | 3297 |  | 38435.96 |  | 39564 |  | 1128.04
EPSC Allocations (Corp Rent) | 15182.07 |  | 16673 |  | 1490.93 |  | 86034.16 |  | 100038 |  | 14003.84 |  | EPSC Allocations (Corp Rent) | 4246.47 |  | 17320.18 |  | 20343.22 |  | 10765.4 |  | 18176.82 |  | 15182.07 |  | 16673 |  | 16673 |  | 16673 |  | 16673 |  | 16673 |  | 16673 |  | 186072.16 |  | 200076 |  | 14003.84
Total Direct Expenses | 714952.68 |  | 314986 |  | -399966.68 |  | 2712379.45 |  | 1889916 |  | -822463.45 |  | Total Direct Expenses | 281564.68 |  | 310492.99 |  | 595767.52 |  | 577862.9 |  | 231738.68 |  | 714952.68 |  | 314986 |  | 314986 |  | 314986 |  | 316529 |  | 316529 |  | 322700 |  | 4613095.45 |  | 3790632 |  | -822463.45
Allocations-I/C Billing | -385056.25 |  | -5145.09 |  | 379911.16 |  | -1014407.09 |  | -30870.54 |  | 983536.55 |  | Allocations-I/C Billing | -18348.24 |  | -27098.74 |  | -337562.51 |  | -326140.32 |  | 79798.97 |  | -385056.25 |  | -5145.09 |  | -5145.09 |  | -5145.09 |  | -6687.87 |  | -6687.87 |  | -12858.97 |  | -1056077.07 |  | -72540.52 |  | 983536.55
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 | 329896.43 |  | 309840.91 |  | -20055.5199999999 |  | 1697972.36 |  | 1859045.46 |  | 161073.1 |  | Net Direct Expenses | 263216.44 |  | 283394.25 |  | 258205.01 |  | 251722.58 |  | 311537.65 |  | 329896.43 |  | 309840.91 |  | 309840.91 |  | 309840.91 |  | 309841.13 |  | 309841.13 |  | 309841.03 |  | 3557018.38 |  | 3718091.48 |  | 161073.1
Headcount | 12 |  | 24 |  |  |  | 20 |  | 24 |  |  |  | Headcount | 23 |  | 23 |  | 21 |  | 21 |  | 20 |  | 12 |  | 24 |  | 24 |  | 24 |  | 24 |  | 24 |  | 24 |  |  |  | 24
[NAME] explanations:
1.  Unfavorable variance due to June special pays of $110K and bonus of $27K, even though actual headcount is 12 below plan.
Also, the low headcount is a result of 7 employees leaving to AEP.
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 a computer purchase and long distance charges for April thru June.