VAMOSC Visibility and Management of Operating

1
(No Transcript)
2
VAMOSC Visibility and Management of Operating
Support Costs

• Web-enabled management information system that
  collects and reports historical Navy and USMC
  Operating and Support (OS) costs on an annual
  basis
• 55B annual weapon system specific costs
  including Mil Pers
• 140 financial and non-financial data sources
• 1200 OS cost and non-cost elements
• Weapons systems direct and linked indirect costs
• Costs in Then Year and Constant Year dollars
• Data presented in alternative hierarchical
  formats
• VAMOSC cost element structure
• OSD CAIG cost element structure

3
Naval VAMOSC Components
Aviation
Ships
FY1984 - 2007 (Ships) FY1993 - 2007 (Shipboard
Systems)
FY1986 - 2007 (Top Level Report) FY1996 - 2007
(OI Level Maintenance)
149 Aircraft T/M/S 1000s Aircraft Subsystems
702 Active Ships 39 Naval Reserve Force Ships 956
Military Sealift Command 91 Shipboard Systems
FY2002 - 2007
FY1995 - 2007
FY1990 - 2007
18 Air-Launched Missiles 9 Surface-Launched
Missiles 5 Torpedoes
419 Ground Combat Systems
74 Cost Elements 51 Counts and Attributes
4
Naval VAMOSC Users

• Cost communities
• Analysis of current systems
• SYSCOMs, Other Services
• Estimates for emerging systems
• NCCA, OSD Program Analysis and Evaluation (PAE),
  SYSCOMs
• Navy maintenance, readiness, logistics
  communities
• SYSCOMs (Program Offices, Naval Warfare Centers)
• Naval Aviation Surface Warfare Enterprises
• OPNAV, Fleet staffs
• Cost research
• NPS Monterey
• Other government offices
• Congressional Budget Office
• Government Accountability Office

Approx 630 current registered VAMOSC users plus
100s of ad hoc users
5
Data Access

• Access granted to authorized users
• Government personnel and government-sponsored
  contractors
• Obtaining data
• Special request
• VAMOSC user account
• Corporate documents
• Custom queries

6
User Support Documentation

• User Manuals
• Updates and improvements
• Definition of cost data elements
• Usage tips - obtaining data
• Appendices
• Acronyms, escalation indices, data flow diagrams,
  valid values
• Anomalies Documents
• Changes in data sources, structures
• Abnormally high or low values
• Data provider explanations
• Deficiencies Documents
• Lists specifics on missing or incomplete data

7

• VAMOSC Enhancements
• Annual Personnel Universe
• Infrastructure Universe
• Depot Availability Universe
• LCM Universe
• Civilian Personnel
• Manpower Model

8
Annual Personnel Universe

• The Annual Personnel Universe is a database that
  sums the Monthly Personnel Universe data at the
  fiscal year level
• Universe was released to end users in January
  2008
• The same actual pay and associated personnel
  attributes are part of this universe design
• Changes to non-cost elements throughout the year
  (ex. change in UIC) are accounted for by using a
  proportioned count
• Costs are listed as base elements, there is no
  cost element structure or hierarchy

9
Annual Personnel Universe (cont)

• Four folders
• Similar to the Monthly Personnel Universe
• FY02-FY07 data available

10
Annual Personnel Universe (cont)

• Non-cost elements
• Subset of Monthly Personnel Universe
• Query costs
• Then year or escalated
• Some costs are not available at this time (ex.
  Bonus data)
• Query counts

11
Infrastructure Universe

• Enable users to view costs associated with
  maintaining and upgrading Navy infrastructure
• Air Operations - Personnel Support -
  Environmental
• Port Operations - Housing - Public Safety
• Operations Support - Facility Support -
  Command Staff

12
Infrastructure Universe (cont) Data Source 1
CNI Certified Obligations

• Costs to maintain or upgrade Naval facilities

Actual Year Appropriation Cost Account
Code UIC Cost Center / Sub-cost Center Expense
Element Functional / Subfunctional Category Job
Order Number Subactivity Group Subhead Gross
Auth. Obligations (labor non-labor) Labor Hours
13
Infrastructure Universe (cont) Data Source 2
iNFADS

• iNFADS Internet Naval Facilities Assets Data
  Store
• Real Property Inventory for the Navy

Facility ID, Name, Number Activity UIC Year
Built Dimensions (square footage, acres)
14
Infrastructure Universe (cont) Current Status

• Universe is in development
• CNI
• Currently gathering and validating 2006 2007
  cost data
• iNFADS
• Currently gathering a consistent version of the
  Navys real property inventory

15
Depot Availability Universe

• Universe Structure
• Standard Ships Data Presentation
• Common fields such as Fiscal Year (FY), Unit
  Identification Code (UIC), Hull Number, Ship
  Name, etc.
• Public Ship Yard Data
• Includes data specific for public shipyards such
  as Availability Number, Expanded Ship Work
  Breakdown Structure (ESWBS), public costs, etc.
• Private Ship Yard Data
• Includes data specific for private shipyards
  such as Start Date, Completion Date, Availability
  Type, private costs, etc.

Planned depot level availabilities
16
Depot Availability Universe (cont)

• Universe is in development
• Uses the CNO (Chief of Naval Operations) list of
  planned availabilities as a benchmark document.
• Records are pulled directly from the Detailed
  Ships Universe, so current data providers are
  utilized
• Will correct the Detailed Ships Universe
  disconnects between to start and end dates as
  well as unique availability numbers.

17
Depot Availability Universe (cont)
18
LCM Universe

• LCM universe
• Lifecycle management is an offshoot of the Ships
  Universe
• Originally requested by the Carrier Readiness
  Team we expanded the scope to cover each of the
  Navy Enterprises
• LCM collects the same cost data from the Ships
  providers on a quarterly basis and at a lower
  level of detail
• Our goal is to show a real time detailed view of
  the shipyards status
• Quarterly information provided below UIC level
  would allow users to make cost reduction
  decisions without sacrificing readiness

19
LCM Universe (cont)
20
LCM Universe (cont) Planned activities/enhancemen
ts

• Universe is in development
• Quarterly Data Request Schedule
• Q1 January 1st
• Q2 April 1st
• Q3 July 1st
• Q4 October 1st
• 76 of Q1 data collected
• Q2 data collection on-going

21
Civilian Personnel Universe

• The Civilian Personnel Universe is a database
  that tracks personnel attributes for all
  civilians, Navy wide
• Pay and attribute data contained within the same
  source
• Query costs and counts of civilian personnel

22
Civilian Personnel Universe (cont) Current Status

• Established a point of contact within Office of
  Civilian Human Resources (OCHR)
• Received sample data from the Defense Civilian
  Personnel Data System (DCPDS)
• Investigated cost non-cost elements
• Working on data access/transfer requirements
• Investigating acquiring data from DMDC

23
Civilian Personnel Universe (cont) Current Issues

• Couple of issues regarding DCPDS
• DCPDS receives bi-weekly data feeds from DCPS
  (Defense Civilian Payroll System) of select data,
  but DCPDS only retains 13 months of pay data
• DCPDS doesnt get all the data stored within DCPS
• DCPDS does NOT get fed payroll corrections (such
  as Pay Hours whether Comp Time, Overtime,
  Hazardous Pay)

24
VAMOSC Manpower Model (MPM)

• Create a robust manpower cost modeling tool for
  active duty and reserve personnel aboard ship
  platforms and systems utilizing
• Actuals from VAMOSC
• Budget to plug gaps in Actuals
• COAS for deriving marginal cost components
• Manning data from VAMOSC to simulate modeling at
  platform (Type, Class) level
• User specified manning to simulate modeling at
  system level
• Leverage web based technology for application
  availability and accessibility
• Establish a process and system infrastructure
  that will be flexible to manage new data sources
  and changing data formats
• Supply the most recent data to the model through
  dynamic feeds of data from VAMOSC databases
• Provide enhanced reporting capabilities for
  life-cycle trend analysis, delta analysis, and
  charting options for presentation

25
NCCA Cost Tool - COMET

• Cost of Manpower Estimating Tool
• Active, Reserve Civilian personnel
• Parameters from Cost of a Sailor (COAS) studies
• Modeling on budget dollars
• PC-based Windows Application

• Direct Costs
• Variable Indirect Costs
• Acquiring
• Training
• Locating
• Supporting
• Other Non-Navy Costs
• MGIB/DHP

26
MPM Project Scope - Overview

• Manpower Model
• Build a model scenario
• Using the manning document
• Using the cost elements document
• Perform LCC analysis
• Perform Delta analysis
• Create reports
• MPM v.1.0
• Model Active Duty personnel on Ships platform
• Documentation
• User Manual Operations Manual
• Training Video

27
MPM Project Scope - Components
28
Questions?
29
MPM Design Functionality
Process Step 1 Create/Load a scenario

• User Authentication
• Access to VAMOSC users
• New users (use VAMOSC Account request process)
• Create a new model scenario
• Select a platform
• Ship/Class/Flight
• Representative Ship (Year, UIC, Hull No.)
• Filter data by homeport
• Model using NAVCOMP rates (direct costs)
• Load and edit a previously saved scenario

30
MPM Design Functionality (cont.)

• Cost Baseline Component
• Direct costs for Officer and Enlisted personnel
• Categorized cost elements listed by pay grade
• Display costs for all Navy, or a
  Designator/Rating
• Indirect costs
• Training (MPN CNET, OMN Budget)
• Recruiting (MPN VAMOSC)
• Base Support (OMN VAMOSC)
• Medical
• TPPH
• Allocation per officer/enlisted personnel
• Display costs in Then Year or Constant FY dollars

31
MPM Design Functionality (cont.)

• Manning Component
• Separate manning documents for Enlisted and
  Officer personnel
• Based on representative ship (Year, Ship UIC,
  Hull No)
• Pre-populated for duration of analysis
• Reduce/increase yearly manning levels to reflect
  maturation/tech. insertion
• Include rotational crews (manning based on
  multiple UICs)
• Model at
• Pay Grade
• Designator/PRA
• NEC/AQD

32
MPM Design Functionality (cont.)

• LCC Analysis Component
• Calculate and display discounted and undiscounted
  costsfor model scenario
• Use NCCA inflation rates to view costs in
  Constant FY dollars
• User inputs discount rate ()
• Delta Analysis Component
• Compare alternative scenarios

33
MPM Design Functionality (cont.)

• Reporting Component
• Formatted for presentation
• Export reports to PDF or Excel
• Flexible reporting charting options
• Detailed report on delta analysis
• COMET style LCC reports
• Costs breakout Costs by skill type, MPN/OMN
  costs by pay grade
• Billets breakout Skill by pay grade
• Executive summaries
• Graphical representations of a model scenario
• Direct and Indirect cost element details
• Manning details