Michael Carey, Naval Center for Cost Analysis

1
Michael Carey, Naval Center for Cost
Analysis Virginie Collin-Banerji, IBM Global
Business Services
2
Four Ship Databases
3
Ships Databases Overview
Direct relationship (UIC level, EIC, and
ESWBS) Indirect relationship (EIC and ESWBS)
4
Ships Data Visibility
Level of Detail
Structure
Universe
Level of Analysis

• Common DoD Structure
• USN - to - MSC comparisons

MSC Ships Shipboard Systems
Least
CAIG CES

• Ship and system-level analyses
• Among similar ships/ systems
• Detailed analysis of some systems (ALRE)

Ships Shipboard Systems
VAMOSC CES

• System-level analysis
• Systems by EIC (3M)
• Systems by ESWBS (public depot)
• Depot by availability

Greatest
Detailed Ships
Tables
5
Whats new (Ships databases)

• Continued effort to increase data depth, breadth
  and accuracy
• OARS record corrections applied to past year data
  (FY96-06, 95 in progress) - (Ships/Systems/Detaile
  d Ships/MSC)
• New Standard Composite Rate calculation, applied
  to FY02-06 (Ships/Systems/MSC)
• New training data process, applied to FY01-06
  (Ships/Systems)
• Number of systems per UIC field populated
  (Systems)
• User manuals reformatting

6
Whats new (Ships databases) Cont.

• 9 new shipboard systems added to VAMOSC
• COMSEC (Communication Security) equipment
• AN/USQ-153 ISNS (Integrated Shipboard Network
  System)
• AN/USQ -144H ADNS (Automated Digital Network
  System)
• AN/USQ -148E SCI (Sensitive Compartmented
  Information) networks
• AN/USQ -119/166/172/184/187(v) GCCS-M (Global
  Command and Control System - Maritime)
• AN/USQ -185 CENTRIX-M (Combined Enterprise
  Regional Information Exchange System - Maritime)
• AN/SYQ-7/26/28 Tactical Messaging
• Secure Terminal Equipment
• AN/WSC-6 Shipboard Terminal System

7
Whats new (Ships databases) Cont.

• More shipboard systems included in the February
  2007 SSR release than ever before

• Now working on Diesel propulsion data (MPDE,
  SSDG, emergency Diesel generators)

8
Continued effort to increase data timeliness

• MSC and Detailed Ships data released in January
  2007
• Ships and Shipboard Systems data released in
  February 2007

9
Questions?
www.navyvamosc.com Mr. Michael Carey Program
Manager [phone], DSN 222-4901michael.j.ca
rey_at_navy.mil Ms. Virginie Collin-Banerji IBM
Deputy / Ships Ship Systems Team Lead (703)
322-5617Virginie.Collin-Banerji_at_us.ibm.com Ms.
Eunice Kim [phone]erkim_at_us.ibm.com
10
John Murray, Naval Center for Cost
Analysis Alicia Lankford, IBM Global Business
Services
11
USMC Universe Overview

• USMC Ground Equipment Universe is a database that
  reports the annual OS costs for Marine Corps
  ground systems or TAMCNs (Table of Authorized
  Material Control Number)
• Individual Equipment Repair Order (ERO) records
  are processed yielding labor, parts, fuel costs
  as well as OPTEMPO averages
• Separate Depot records, inventory quantities, and
  ammunition data are also processed and available

Depot records
ERO Record
ERO Record
Inventory quantities
ERO Record
ERO Record
Ammunition data
12
USMC Universe Overview

• The data is available in 5 folders
• Summarized Data (by TAMCN) depot, OI
  level labor, OI level parts (cons rep)
• RUC Breakdown (by RUC, MCC, RAC) OI level labor
  
• AMMO Cost (by TAMCN DODIC) qty fired, cost
  per round, ammo cost
• Fuel/OPTEMPO (by TAMCN) average
  OPTEMPO, fuel cost
• Inventory (by TAMCN location) inventory count

13
Accomplishments

• Updated Labor Calculation Process
• Labor (hours) x (Composite Rate)
• FY95-FY01 E4 SCR from the Comptroller is used
• FY02-Current FY VAMSOC Personnel Universe is
  used to determine the previous years count of
  Marine Enlisted active duty personnel by pay
  grade in RUCs that reported labor costs, then a
  weighted composite average is calculated based on
  those personnel counts and Comptroller rates
• Reset FY04 and FY05 Inventory
• In FY04 FY05, if inventory was not reported,
  but the TAMCN exhibited parts labor costs, than
  the inventory from the previous year was
  substituted for the current year
• This process was reversed, if inventory is not
  received it is not reported for the current year

14
Questions ?
15
Mike Carey, Naval Center for Cost Analysis Peter
Bowman, IBM Global Business Services
16
Monthly Personnel Universe Overview

• The Personnel Universe is a database that tracks
  actual pay and associated personnel attributes
  for all active and reserve Navy and Marine Corps
  personnel at the monthly level
• Pay data linked with Personnel attributes per
  person
• FY02-FY06 data available by month
• Query costs and counts of personnel

Monthly records linked by SSN
17
Monthly Personnel Universe Overview

• Data is organized in 4 folders
• Each folder contains the following

Date Range
Calendar Year/Month
Cost Elements
Non-cost Elements
Attributes (change per folder)
Then Year Dollars
Cost Objects
Escalated Dollars (3 choices)
Count who received dollars
Annual FTE Count who received dollars
Count Objects
Total personnel count
Annual FTE total personnel count
18
Monthly Personnel Universe Overview
Level 1
Level 2
Level 3
Level 4

• Cost Elements listed within the Cost Element
  Structure
• Level 1 Total Pay
• User selects one or many cost elements when
  building a query

19
Monthly Personnel Universe Overview

• Non-Cost Elements listed within each folder
• Some vary per folder
• User selects one or many non-cost elements when
  building a query

• Navy Officer
• Pay Grade
• Designator

• Navy Enlisted
• Pay Grade
• Present Rate

• Marine Officer
• Pay Grade
• Billet MOS

• Marine Enlisted
• Pay Grade
• Billet MOS

20
Accomplishments

• Corrected non-cost element Activity Sea/Shore
  Code
• Sea/Shore code of 5 is not valid (although
  still reported within the data)
• Within each record, UIC determined correct
  sea/shore code
• Expanded available Corporate Documents
• Data for all five fiscal years, for all available
  base elements has been pulled stored within the
  corporate document section of VAMSOC
• Built prototype of Annual Personnel Universe

21
Questions?
22
John Murray, Naval Center for Cost
Analysis Julian Kwan, IBM Global Business Services
23
Aviation Data Visibility

• Navy total, and by Fleet, Type, or Type/Model
• Roll-up of Type/Models air wing, tactical,
  transport, etc.
• By Type/Model or Type/Model/Series
• Break-outs by O-Level, I-Level, Depot, FRS,
  Mods, Support Services, CLS
• O-Level, I-Level, and FRS contain actual
  personnel costs
• By Work Unit Code (WUC)
• OI Level maintenance labor hours
• Aviation Depot Level Repairable costs
• Consumables costs
• Beyond Capability of Maint (BCM) Counts

Force
ATMSR
Aircraft
NAMSR
Subsystem
Aviation/Type/Model/Series Reporting Naval
Aviation Maintenance Subsystem Reporting
24
ATMSR Standard Cost Element Structure

• 1.0 Organizational / 4.0 FRS Costs
• Personnel (MilPers, Civ and Ctr)
• Operations
• Temporary Additional Duty
• Training Expendable Stores
• Support Supplies
• AVDLR
• Fuel
• PCS
• Training (4.0 series only)
• Maintenance Training
• Simulator Maintenance
• 2.0 Intermediate Maintenance Costs
• Personnel (MilPers, Civ and Ctr)

• 3.0 Depot Support Costs
• Aircraft Engine Rework
• Emergency Aircraft Engine Rework
• Commercial/DMISA/NAPRA
• Support Equipment Maintenance
• 5.0 Recurring Investment Costs
• Modification Kits, Spares Installs
• 6.0 Other Function Costs
• Naval Engineering Technical Services (NETS)
• Contractor Engineering Technical Services (CETS)
• Publications
• PRL/PRE/NPRE
• 7.0 Contractor Logistics Support Costs

25
ATMSR Non-cost Elements

• A.1 Aircraft Count
• A.2 Flying Hours
• A.3 Average Age Year End
• A.4 Average Total Flight
• Hours in Life Year End

Available in Standard and CAIG ATMSR
Presentations
Available in TMS Averages Folder

• Non-cost elements can be further subdivided by
• Regular and FRS
• Navy and Marine Corps

26
Whats New in ATMSR

• 2006 Annual Update (Feb 2007)
• Updated with FY06 cost count data
• New TMSs AH-1Z, T-44C, UH-1Y
• FY03 FY05 Marine PCS costs reprocessed (Feb
  2007)
• For MCAS UICs, only Mission Personnel costs are
  now reported
• Lower Marine PCS costs for C-9B, HH-1N, HH-46D,
  UC-12B, UC-12F, UC-35D

27
Whats New in ATMSR (contd)

• FY04 FY05 Reserve Military Personnel
  reprocessed (Mar 2007)
• Military Personnel costs for reservists had
  duplicate records
• Lower costs for TMSs with Reserve Military
  Personnel
• Will repeat for FY03 (June 2007)
• Maintenance Training Costs
• NETPDTC changed cost accounting systems
• FY06 costs calculated by Cost Per Training Day
  Per Person
• FY06 costs were significantly lower than FY05
• 119 per day in FY06 vs. 200 per day in FY05
• 136K training days in FY06 vs. 186K training days
  in FY05

28
Other ATMSR Anomalies

• Lower FY06 Commercial Engine Rework Costs
• 25M decrease for F414GE engine
• Program changed less material on GE contract
• Used by F/A-18E and F/A-18F
• 27M decrease for T56A-427
• Increased reliability and less need for depot
  support
• Used by E-2C and TE-2C

29
NAMSR Universe Overview
NAMSR Plus
NAMSR

• NAMSR ( 2 million records)
• Provides high-level AV-3M analyses
• 16 Data Dimensions
• 5 Data Measures (Then Year only)
• Available by fiscal year only
• Provides fast query response
• NAMSR Plus ( 61 million records)
• Supplements NAMSR
• Supports more in-depth analyses
• 37 Data Dimensions
• 21 Data Measures (Then Year only)
• Reports data by year, quarter or month

30
NAMSR Design

• Fiscal Year
• Type Equipment Code
• Type/Model/Series
• Type/Model
• Work Unit Code 2 Description
• Work Unit Code 3 Description
• Work Unit Code 4 Description
• Work Unit Code 5 Description
• Work Unit Code 6 Description
• Work Unit Code 7 Description
• AVDLR Cost
• Consumable Cost
• BCM Count
• O I Level Labor Hours

Note all Data Dimensions and Measures are
reported for Aircraft and Engines
31
NAMSR Plus Design

• Fiscal Year/Quarter
• Calendar Year/Month
• Action Org Major Claimant
• Action Org Code
• Action Org Long Name
• Action Org Type
• JCN Org Major Claimant
• JCN Org Code
• JCN Org Long Name
• JCN Org Type
• Bureau Number A/C
• Serial Number - Engine
• Type of Maintenance Code
• Type of Maintenance Description

• COG Code
• NIIN
• CAGE Code
• Part Number
• O I Level Maintenance Actions
• O I Level Repair Count
• O I Level Corrosion Count
• O I Level Consumable Cost
• O I Level Cannibalizations
• O I Level Failure Count
• O I Level Removal Count
• No Defect Removal Count
• Flight Hours

And ALL NAMSR Dimensions/Measures
COG, NIIN, CAGE, and Part Number data not
available for these elements
32
Whats New in NAMSR / NAMSR

• 2006 Annual Update (Jan 2007)
• Updated with FY06 cost count data
• O-level Maintenance Data found to be inflated for
  certain T/M/S for FY02 thru FY05 (Feb 2006)
• We reported both open and closed records for
  Optimized for Organizational Maintenance Activity
  (OOMA) activities. Only closed records should
  have been reported.
• T/M/Ss affected HH-60H SH-60F S-3B E-2C
  C-2A MV-22B
• FY04 and FY05 were reprocessed to remove open
  (OOMA) records (June 2006)
• FY01, FY02 and FY03 reprocessing complete (Sep
  2006)

33
Upcoming NAMSR Update

• Work Unit Code Description update (June 2007)
• Will cover WUC 2 7
• Source DECKPLATE

34
Aviation Almanacs

• Provide high-level displays of ATMSR and NAMSR
  Plus data by A/C Type/Model for
• A-6 (new) H-1
• C-130 (new) H-46 (new)
• E-2 (new) H-60
• F/A-18 P-3

Costs now reported in Constant Year
35
Aviation VAMOSC Views

• Graphical views of VAMOSC data for
• Fighter/Attack Aircraft Surveillance Aircraft
  (New)
• Rotary Wing Aircraft Transport Aircraft (New)
• Trainer Aircraft (Coming Soon)

36
VAMOSC Weapons
37
WSR Coverage

• AIR LAUNCHED SURFACE LAUNCHED TORPEDOES
• AMRAAM HARPOON (RGM-84) ASROC/VLA
• HARM RAM MK-46
• HARPOON (AGM-84) SPARROW (RIM-7) MK-48/MK-48
  ADCAP
• HELLFIRE STANDARD (SM-1MR) MK-50
• JDAM STANDARD (SM-2MR) MK-54
• JSOW STANDARD (SM-1ER)
• MAVERICK STANDARD (SM-2ER)
• PENGUIN TOMAHAWK (RGM-109)
• PHOENIX TOMAHAWK (UGM-109)
• SIDEARM
• SIDEWINDER (AIM-9M/X)
• SKIPPER
• SLAM
• SLAM-ER
• SPARROW (AIM-7)
• TOW
• WALLEYE

NEW
5 TORPEDOES
9 SURFACE LAUNCHED WEAPONS
18 AIR LAUNCHED WEAPONS
Weapon System Report
38
WSR Direct OS Cost Data

• Operations
• Maintenance (I-level, D-level Organic
  Contractor)
• Second Destination Transportation
• Receipt, Segregation, Storage, and Issue
• Logistics/Engineering Support
• Sustaining Investment
• System Software Maintenance
• Demilitarization and Disposal
• Modifications
• Other

39
Questions?

• www.navyvamosc.com
• Mr. John Murray
• Deputy Program Manager Aviation/USMC Programs
• [phone], DSN 222-4882
• John.M.Murray3_at_navy.mil
• Mr. Julian Kwan
• Aviation Weapons Team Lead
• [phone]
• Julian.Kwan_at_us.ibm.com