Spreadsheet: tracy_geaccone__40196__ETS - Total IC 10-19
Sheet: IT Infrastructure

 | Total cost per Business Unit
 | Service Category | Service | Service Options | Transwestern | Citrus | NN Gas | NPN Gas | EAMR | Enron Trans | Enron Pipe | ETS
 | Customer Support | Resolution Center |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Desktop support | General | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Traders | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Executive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Remote | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Desktop Hardware Support |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Printer Management Support |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal 2002
 | Production Operations Services | Production Operations Management |  |  |  |  |  |  |  |  | 9850.238999999998
 |  | Enterprise Command Center |  |  |  |  |  |  |  |  | 44826.39
 |  | Change & Configuration Management |  |  |  |  |  |  |  |  | 29298.21299999999
 |  | [NAME] (Future Service) |  |  |  |  |  |  |  |  | 0
 |  | Security Administration |  |  |  |  |  |  |  |  | 0
 |  | Data Center Operations |  |  |  |  |  |  |  |  | 157000.2329498137
 |  | IT Security Policy, Monitoring, and Investigation |  |  |  |  |  |  |  |  | 146186.0667212444
 |  | Software - Desktop Maintenance & Support |  |  |  |  |  |  |  |  | 1060392.999988474
 |  | Software - Server Maintenance & Support |  |  |  |  |  |  |  |  | 71086.00000199371
 |  | Application Storage Support |  |  |  |  |  |  |  |  | 0
 |  | User & Data Volume Support |  |  |  |  |  |  |  |  | 0
 |  | Remote Infrastructure Operation & Support |  |  |  |  |  |  |  |  | 0
 |  | Remote Trading Management |  |  |  |  |  |  |  |  | 0
 |  | UNIX Application Infrastructure |  |  |  |  |  |  |  |  | 0
 |  | General UNIX Infrastructure |  |  |  |  |  |  |  |  | 28523.33895713427
 |  | NT Application Infrastructure |  |  |  |  |  |  |  |  | 0
 |  | General NT Infrastructure |  |  |  |  |  |  |  |  | 180987.7841491333
 |  | Remedy |  |  |  |  |  |  |  |  | 18732.34664595
 |  | Email Administration |  |  |  |  |  |  |  |  | 56229.91618793051
 |  | Market Data Admin. Support |  |  |  |  |  |  |  |  | 8219.466712999998
 |  | Disk Space Allocations (E-mail) |  |  |  |  |  |  |  |  | 19970.330556
 |  | Messaging Operations (Exchange) |  |  |  |  |  |  |  |  | 265785.3478742018
 |  | Web Operations |  |  |  |  |  |  |  |  | 36696.54464594999
 |  | Terminal Server Operations |  |  |  |  |  |  |  |  | 0
 |  | Distributed Applications Management |  |  |  |  |  |  |  |  | 46443.71564595
 |  | EDI |  |  |  |  |  |  |  |  | 280872.96
 | Subtotal 2002
 | Data Communications Support | LAN Support |  |  |  |  |  |  |  |  | 260459.1801432008
 |  | [NAME] |  |  |  |  |  |  |  |  | 142015.276755
 |  | DMZ Security |  |  |  |  |  |  |  |  | 191477.6184965735
 |  | 24x7 Support |  |  |  |  |  |  |  |  | 190962.2949299999
 | Voice Communications Support | Telephony support |  |  |  |  |  |  |  |  | 336459.6814029548
 |  | Communication Trading Support |  |  |  |  |  |  |  |  | 0
 | Subtotal 2002
 | Special Services Support | Business Administration Project Management |  |  |  |  |  |  |  |  | 34344.7965
 |  | Technical Architecture Oversight |  |  |  |  |  |  |  |  | 50949.5175
 | Subtotal 2002
 | Subtotal
 | 2002 Infrastructure Plan Depreciation |  |  |  |  |  |  |  |  |  | 1593976
 | INDIRECTS | Overall (pre pass-thru) |  |  |  |  |  |  |  |  | 226022.0913924345
 | Other Compensation Expense |  |  |  |  |  |  |  |  |  | 212713
 | Subtotal Before Passthroughs
 | Infrastructure Passthroughs | Market Data Feeds |  |  |  |  |  |  |  |  | 152238.416296
 |  | Long Distance |  |  |  |  |  |  |  |  | 181324.7605301205
 |  | 800 (Inbound) |  |  |  |  |  |  |  |  | 108550.9216626506
 |  | Calling Card |  |  |  |  |  |  |  |  | 33564.324432
 |  | Audio Conferencing |  |  |  |  |  |  |  |  | 20156.591616
 |  | Video Conferencing |  |  |  |  |  |  |  |  | 47614.75180366492
 |  | Internet Access |  |  |  |  |  |  |  |  | 240045.7472655611
 |  | EOL - Internet Access |  |  |  |  |  |  |  |  | 0
 |  | ETS - Omaha Internet Access |  |  |  |  |  |  |  |  | 89984.784
 |  | MAN |  |  |  |  |  |  |  |  | 0
 |  | Remote Access (dial/VPN) |  |  |  |  |  |  |  |  | 223358.5420186246
 |  | [NAME] |  |  |  |  |  |  |  |  | 1092315.184422
 |  | Voice Circuit |  |  |  |  |  |  |  |  | 122219.3665076412
 |  | [NAME] |  |  |  |  |  |  |  |  | 0
 |  | Communications - Churns |  |  |  |  |  |  |  |  | 0
 | Subtotal of Passthroughs
 | Grand Total
 |  | Company | Headcount | % of Total
 |  | Transwestern Pipeline Co. | 90 | 0.06198347107438017
 |  | Citrus Corp. | 213 | 0.1466942148760331
 |  | Northern Natural Gas Co. | 550 | 0.3787878787878788
 |  | Northern Plains Natural Gas | 187 | 0.1287878787878788
 |  | Enron Asset Management Resources | 164 | 0.1129476584022039
 |  | Enron Transportation Services | 168 | 0.115702479338843
 |  | Enron Pipeline Services Corp. | 80 | 0.05509641873278237