Spreadsheet: mark_haedicke__24614__Legal0600O&MReport-Haedicke
Sheet: Legal-June

LEGAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
ENA |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
TOT_OPS_EXPENSES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000 |  | PLAN2000
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense (By Acct):
TOT_COMP | Compensation | 849382 |  | 781460 |  |  |  | 4660758 |  | 4636641 |  |  |  | Headcount - Actual | 86 |  | 86 |  | 88 |  | 87 |  | 87 |  | 92 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88
[NAME] | Benefits and Payroll Taxes | 109895 |  | 157499.5194999999 |  |  |  | 789654 |  | 939067.9109999998 |  |  |  | Headcount - Plan | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88 |  | 88
TOT_EMP_EXP | Employee Expenses | 157837 |  | 92541.34 |  |  |  | 652741 |  | 593444.04
TOT_RECRUITING | Recruiting & Relocations | 47626 |  | 0 |  |  |  | 95704 |  | 2000
TOT_OSIDE_SERV | Outside Services | 1754775 |  | 1140427 |  |  |  | 7016258 |  | 4842558
[NAME] | Supplies and Expense | 23185 |  | 21879 |  |  |  | 228999 |  | 131274 |  |  |  | Direct Expense:
TOT_MKT | Marketing | 812 |  | 0 |  |  |  | 3884 |  | 0 |  |  |  | Compensation | 721252 |  | 779866 |  | 765058 |  | 751052 |  | 794148 |  | 849382 |  | 781461 |  | 781460 |  | 781461 |  | 781460 |  | 781460 |  | 781461
TOT_CHAR_CONT | Charitable Contributions | 122 |  | 0 |  |  |  | 1107 |  | 0 |  |  |  | Benefits and Payroll Taxes | 201719 |  | 34268 |  | 142215 |  | 139811 |  | 161746 |  | 109895 |  | 157500.5194999999 |  | 157499.5194999999 |  | 157499.5194999999 |  | 157500.5194999999 |  | 157500.5194999997 |  | 157499.5195000002
TOT_RENT | Rent (3rd Party) | 731 |  | 2169 |  |  |  | 22301 |  | 13014 |  |  |  | Employee Expenses | 73449 |  | 83827 |  | 103655 |  | 127343 |  | 106630 |  | 157837 |  | 92540.34 |  | 92540.34 |  | 92540.34 |  | 92541.34 |  | 92540.34 |  | 92544.25
TOT_TECH | Technology | 20727 |  | 300 |  |  |  | 77758 |  | 1800 |  |  |  | Recruiting & Relocations | 803 |  | 42732 |  | 338 |  | 0 |  | 4205 |  | 47626 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOT_TRANS | Transportation | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | Outside Services | 560467 |  | 1110220 |  | 796401 |  | 1323288 |  | 1471107 |  | 1754775 |  | 640426 |  | 640425 |  | 1140426 |  | 2548987 |  | 2548986 |  | 2683226
CORP_IT | Corporate IT | 14224 |  | 43989 |  |  |  | 188030 |  | 263934 |  |  |  | Supplies and Expense | 12985 |  | 94903 |  | 18617 |  | 26018 |  | 53291 |  | 23185 |  | 21879 |  | 21879 |  | 21879 |  | 21879 |  | 21879 |  | 21875
CORP_RENT | Corporate Rent | 90376 |  | 89994 |  |  |  | 528720 |  | 539964 |  |  |  | Marketing | 988 |  | 388 |  | 395 |  | 1072 |  | 229 |  | 812 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOT_OTH_EXP | Other Expenses | 58825 |  | 169667 |  |  |  | 625786 |  | 1018002 |  |  |  | Charitable Contributions | 221 |  | 220 |  | 383 |  | 10 |  | 151 |  | 122 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] | Taxes Other Than Income | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | Rent (3rd Party) | 2510 |  | 2371 |  | 2674 |  | 3521 |  | 10494 |  | 731 |  | 2169 |  | 2169 |  | 2169 |  | 2169 |  | 2169 |  | 2169
[PHONE] | Capital Allocation | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | Technology | 6768 |  | 575 |  | 17919 |  | 17438 |  | 14331 |  | 20727 |  | 300 |  | 300 |  | 300 |  | 300 |  | 300 |  | 300
TOT_DEP_AMOR | Depreciation & Amortization | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | Transportation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT | 40649 |  | 31427 |  | 31730 |  | 0 |  | 70000 |  | 14224 |  | 43989 |  | 43989 |  | 43989 |  | 43989 |  | 43989 |  | 43988.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent | 94503 |  | 86254 |  | 91413 |  | 80753 |  | 85421 |  | 90376 |  | 89994 |  | 89994 |  | 89994 |  | 89994 |  | 89994 |  | 89994
9230999860 | Allocated Intercompany Billings | -194066 |  | -271515.8260869565 |  |  |  | -2634197 |  | -1626743.694565217 |  |  |  | Other Expenses | 153711 |  | 807430 |  | -592600 |  | 105797 |  | 92623 |  | 58825 |  | 169667 |  | 169667 |  | 169667 |  | 169667 |  | 169667 |  | 169667
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
4130005 | Direct Expense (By RC): |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings | -1393020 |  | -762938 |  | 959922 |  | -924678 |  | -319417 |  | -194066 |  | -271515.8260869565 |  | -271514.8869565218 |  | -271515.8260869565 |  | -328803.3695652173 |  | -328803.3695652173 |  | -557951.8043478262
4440005 | 444-0005 - Canada | 214587 |  | 63540 |  |  |  | 376737 |  | 380146
4130006 | 413-0006 - Finance | 1171864 |  | 662656.4739999999 |  |  |  | 3464408 |  | 2969947.97 |  |  |  | Net Expenses
4130007 | 413-0007 - Power/Liquids | 80162 |  | 512873.2683333333 |  |  |  | 1983630 |  | 2074931.026
4130102 | 413-0102 - Executive | 174643 |  | 254366.4573333333 |  |  |  | 1335969 |  | 1525907.161
4130630 | 413-0630 - Litigation | 477813 |  | 171873.2021666667 |  |  |  | 1880612 |  | 1030212.213
4131157 | 413-1157 - Financial Trading | 491869 |  | 399206.4359999998 |  |  |  | 2356997 |  | 2390814.844
4131159 | 413-1159 - Emerging Markets | 256727 |  | 196705.6561666668 |  |  |  | 1537602 |  | 1178437.563
4131495 | 413-1495 - Finance Assets | 239013 |  | 207029.5553333334 |  |  |  | 1451777 |  | 1241066.168
4131929 | 413-1929 - Employee Matters | 21839 |  | 31674.81016666666 |  |  |  | 503968 |  | 190236.006
 | Total Direct Expenses
4131898 | 413-1898 - Intercompany Billing | -194066 |  | -271515.8260869565 |  |  |  | -2634197 |  | -1626743.694565217
 | Net Expenses
 | [NAME]:
 | 444-0005: Unfavorable variance primarily due to overage in outside services related to BlueRange and Canadian turbine purchase.
 | 413-0006: Unfavorable variance due to overage in outside services.
 | 413-0007: Favorable variance due to a credit in outside services as a result of capitalizing legal costs associated with the 2000 Peakers and Pastoria;  In
 | addition, a credit hit for duplicate payment of an invoice paid in May.
 | 413-0630: Unfavorable variance due to overage in outside services primarily due to the following projects:  Beeson/Mills, Enron/NSM.
 | 413-1157: Unfavorable variance due to overage in outside services primarily related to Enron Online and relocation expenses for [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services | 7016.258
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Exps | 6198.857
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Corp Charges | 625.786
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Corp Rent | 528.72
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Office Exps | 256.291
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Corp IT | 188.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Technology | 77.758