Spreadsheet: sally_beck__35439__IT ReOrg
Sheet: Enterprise Frameworks

 | Enterprise [NAME]
 | DBA's
 |  |  |  |  |  |  |  | $ENA Saving |  | $EGM Saving |  | $[NAME]
 | Total Team | HC | Dollars | %c [NAME] | ENA | EGM | EIM | $[NAME] | $Exp | $[NAME] | $Exp | $[NAME] | $Exp
 | Contractors | 2
 | Consultants | 0
 | Employees | 56
 | Total
 | Scenario 1
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose DB Architecture Group
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose Night Cover
 | Employees |  |  |  |  |  |  |  |  |  |  |  |  | Lose EGM specfic support
 | Total |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] support
 | Approximate Savings |  |  | 0.8 | 0.6 | 0.2 | 0.2 |  |  |  |  |  |  | [NAME] lose 20%
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] support
 | Scenario 2
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose DB Architecture Group
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose Night Cover
 | Employees |  |  |  |  |  |  |  |  |  |  |  |  | Lose EGM specfic support
 | Total |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] lose 20%
 | Approximate Savings |  |  | 0.8 | 0.6 | 0.2 | 0.2 |  |  |  |  |  |  | [NAME] support
 | Scenario 3
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose DB Architecture Group
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] lose 20%
 | Employees |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] support
 | Total
 | Approximate Savings |  |  | 0.5 | 0.6 | 0.2 | 0.2
 | Business Analaysts
 | Total Team | HC | Dollars
 | Contractors | 0
 | Consultants | 0
 | Employees | 27
 | Total
 | Scenario 1
 | Contractors | 0
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose all BA's
 | Employees | 0
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 2
 | Contractors | 0
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose 80 % BA's
 | Employees | 6
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 3
 | Contractors | 0
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose 50% BA's
 | Employees | 13
 | Total
 | Approximate Savings |  |  | 0.5 | 0.7 | 0.15 | 0.15
 | Strategic Communications
 | Total Team | HC | Dollars
 | Contractors | 0
 | Consultants | 0
 | Employees | 10
 | Total
 | Scenario 1
 | Contractors | 0
 | Consultants | 0
 | Employees | 0
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 2
 | Contractors | 0
 | Consultants | 0
 | Employees | 2
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 3
 | Contractors | 0
 | Consultants | 0
 | Employees | 2
 | Total
 | Approximate Savings |  |  | 0.5 | 0.7 | 0.15 | 0.15
 | Project Control
 | Total Team | HC | Dollars
 | Contractors | 0
 | Consultants | 0
 | Employees | 3
 | Total
 | Scenario 1
 | Contractors | 0
 | Consultants | 0
 | Employees | 1
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 2
 | Contractors | 0
 | Consultants | 0
 | Employees | 2
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 3
 | Contractors | 0
 | Consultants | 0
 | Employees | 3
 | Total
 | Approximate Savings |  |  | 0.5 | 0.7 | 0.15 | 0.15
 | QA / Testers
 | Total Team | HC | Dollars
 | Contractors | 0
 | Consultants | 1
 | Employees | 27
 | Total
 | Scenario 1
 | Contractors | 0
 | Consultants | 0
 | Employees | 0
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 2
 | Contractors | 0
 | Consultants | 0
 | Employees | 0
 | Total
 | Approximate Savings |  |  | 0.8 | 0.7 | 0.15 | 0.15
 | Scenario 3
 | Contractors | 0
 | Consultants | 0
 | Employees | 10
 | Total
 | Approximate Savings |  |  | 0.5 | 0.7 | 0.15 | 0.15
 | Architecture
 | Total Team | HC | Dollars
 | Contractors | 1
 | Consultants | 8
 | Employees | 20
 | Total
 | Scenario 1
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] and Production Component Support
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Decomission Drive Train
 | Employees | 4
 | Total
 | Approximate Savings |  |  | 0.8 | 0.6 | 0.2 | 0.2
 | Scenario 2 |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] and Production Component Support
 | Consultants | 0
 | Employees | 6
 | Total
 | Savings |  |  | 0.8 | 0.6 | 0.2 | 0.2
 | Scenario 3 |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] and Production Component Support
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Research & Development
 | Employees | 10 |  |  |  |  |  |  |  |  |  |  |  | Retain good technical staff
 | Total
 | Savings |  |  | 0.5 | 0.6 | 0.2 | 0.2
 | Global Data
 | Total Team | HC | Dollars
 | Contractors | 4
 | Consultants | 0
 | Employees | 10
 | Total
 | Scenario 1
 | Contractors | 0
 | Consultants | 0
 | Employees | 2
 | Total
 | Approximate Savings |  |  | 0.8 | 0.6 | 0.2 | 0.2
 | Scenario 2
 | Contractors | 0
 | Consultants | 0
 | Employees | 4
 | Total
 | Approximate Savings |  |  | 0.8 | 0.6 | 0.2 | 0.2
 | Scenario 3
 | Contractors | 0
 | Consultants | 0
 | Employees | 6
 | Total
 | Approximate Savings |  |  | 0.5 | 0.6 | 0.2 | 0.2
 | Global Valuation
 | Total Team | HC | Dollars
 | Contractors | 0
 | Consultants | 1
 | Employees | 10
 | Total
 | Scenario 1
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | If EGM stopped using GV
 | Consultants | 0
 | Employees | 0
 | Total
 | Approximate Savings |  |  | 0.8 | 0 | 1 | 0
 | Scenario 2
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Assuming EGM was using GV
 | Consultants | 0
 | Employees | 2
 | Total
 | Savings |  |  | 0.8 | 0 | 1 | 0
 | Scenario 3
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Assuming EGM was using GV
 | Consultants | 0
 | Employees | 4
 | Total
 | Savings |  |  | 0.5 | 0 | 1 | 0
 | MKM | Houston
 | Total Team | HC | Dollars
 | Contractors | 0
 | Consultants | 0
 | Employees | 13
 | Total
 | Scenario 1
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Merge into Architecture group, take key people
 | Consultants | 0
 | Employees | 3
 | Total
 | Approximate Savings |  |  | 0.8 | 0.3 | 0.4 | 0.3
 | Scenario 2
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Merge into Architecture group, take key people
 | Consultants | 0
 | Employees | 3
 | Total
 | Savings |  |  | 0.8 | 0.3 | 0.4 | 0.3
 | Scenario 3
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | Slowly scaling with more systems coming on line
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Cost effective
 | Employees | 6
 | Total
 | Savings |  |  | 0.5 | 0.3 | 0.4 | 0.3
 | RAC | London
 | Total Team | HC | Dollars
 | Contractors | 1
 | Consultants | 0
 | Employees | 24
 | Total
 | Scenario 1
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose ALL web-conversion
 | Employees |  |  |  |  |  |  |  |  |  |  |  |  | Lose newer team members from Analytics
 | Total
 | Approximate Savings |  |  | 0.8 | 0.8 | 0.1 | 0.1
 | Scenario 2
 | Contractors | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Consultants | 0 |  |  |  |  |  |  |  |  |  |  |  | Lose some web-conversion
 | Employees
 | Total
 | Savings |  |  | 0.8 | 0.8 | 0.1 | 0.1
 | Scenario 3
 | Contractors | 0
 | Consultants | 0
 | Employees
 | Total
 | Savings |  |  | 0.5 | 0.8 | 0.1 | 0.1
 | Total Enterprise Frameworks
 | Total Team | HC | Dollars
 | Contractors
 | Consultants
 | Employees
 | Total
 | Scenario 1
 | Contractors
 | Consultants
 | Employees
 | Total
 | Savings
 | Scenario 2
 | Contractors
 | Consultants
 | Employees
 | Total
 | Savings
 | Scenario 3
 | Contractors
 | Consultants
 | Employees
 | Total
 | Savings
 |  |  |  |  |  |  |  | $ENA Saving |  | $EGM Saving |  | $[NAME]
 |  |  | Check |  |  |  |  | [NAME] | Exp | [NAME] | Exp | [NAME] | Exp
 |  |  |  |  |  | Scenario 1
 |  |  |  |  |  | Scenario 2
 |  |  |  |  |  | Scenario 3