JOINT COST ANALYSIS RESEARCH AND DATABASE

1
JOINT COST ANALYSIS RESEARCH AND
DATABASE Department of the Navy Cost Analysis
Symposium September 17, 2009
Saroja RamanJCARD Team LeadNAVAIR 4.2 Cost
Department
2
OUTLINE

• BACKGROUND
• DESCRIPTION
• JCARD PROCESS IN TRANSITION
• PAST/ PRESENT/ FUTURE
• GROWTH OF JCARD SYSTEM
• ACHIEVEMENTS
• DEMO (SCREEN SHOTS)
• SUMMARY

3
JCARD Project

• JCARD effort initiated November 2004 to alleviate
  challenges faced by DoD Cost Community
• Limited resources
• Services working independently resulting in
  duplicative efforts
• Lack of good quality data which is vital to daily
  business operations
• NCCA, NAVAIR and AFCAA signed MOU and formed
  working group with the intent to improve the way
  we do business within the Cost Community by
  sharing data, knowledge and resources among Cost
  Agencies more readily.

4
Fundamental problems exist with Cost Data
Collection/Analysis within DoD Cost Community

• Cost Teams and cost analysts work individually
• Data resides with cost teams and cost analysts
• Information and data is gathered via word of
  mouth
• Cost analysis research is generally contracted
  out by each service/agency resulting in very
  little capitalization of research efforts
• Stand alone databases developed leading to
  redundancies in data
• Practically no sharing of information and data
  resulting in high duplication of effort

5
JCARD Goal

• Develop a joint web information system with the
  objective of being the single information bridge
  between cost analysts and the DoD authoritative
  sources for Unclassified/For Official Use Only
  (U/FOUO) cost, technical and programmatic data.
• Bring DoD Cost Community into the 21st century in
  terms of locating and accessing vital information
  required for cost/estimating and analysis.

6
JCARD PROCESS IN TRANSITIONPAST PRESENT --
FUTURE
Cost Analyst
Cost Analyst
JCARD
JCARD
DB
Client
Client
Client
DB
DB
DB
DB
DB
DB
DB
DB
Cost Analyst

• Standard comparison charts
• Benchmarks

DB
DB
DB
DB
Files
Files
TASKS
10-20
80-90
in transition
80-90
10-20
7
JCARD Description

• JCARD IS NOT
• A Data Repository
• Storing calculated values
• A Data Dump
• A downloadable database
• A quick turnaround project

• JCARD IS
• Storing raw data in SQL tables building a
  relational database structure
• Storing lower level numbers calculations done by
  system
• Researching, organizing and validating cost,
  technical and programmatic data from an
  authoritative source AND providing information
• Web based tool for DoD Cost Community
• Long Term Project

8
(No Transcript)
9
(No Transcript)
10
JCARD Key Features

• Provide cost, technical and programmatic data in
  one easily accessible location for
• Aircraft systems (rotary fixed wing)
• Propulsion systems
• Avionics systems
• Missile systems
• Data Validation
• Consolidating various fragmented and dispersed
  data sets cross checking against authoritative
  sources and removing redundancies
• User will validate data from authoritative
  sources
• Documentation
• Complex comment system
• Denote issues with data, platform, sources, etc.
• Provide information

11
GROWTH OF JCARD SYSTEM
CCDR 1921 F/A-18ABCD
FY09 4th QTR to be completed
CTR Internal Reports F/A-18EF
Other Cost Data 4.2 Research Efforts
Technical Char gt100 A/C models
Quantity Info, Milestone Dates Additional A/C
added
CCDR 1921 E-2C, V-22 SDD
CTR Internal Reports F-14, F-15, F-16, AV-8B,
F/A-18ABCD
(1) Propulsion Data (Cost, Tech, Prog) gt30 Engine
Models
Propulsion Data (Cost, Tech, Prog) gt30 Engine
Models
A/C Technical Char Matl mix gt30 A/C Models
A/C Technical Char Matl mix gt30 A/C Models
A/C Quantity Info gt100 A/C Models
A/C Quantity Info gt100 A/C Models
A/C Milestone Dates 25 Aircraft
A/C Milestone Dates 10 Aircraft
Sustain
Navy Expenditure Data 287 TMSgt1000 data pts
Navy Expenditure Data 287 TMSgt1000 data pts
Navy Expenditure Data 287 TMSgt1000 data pts
Navy Weight Data 55 TMS gt25 data pts
Navy Weight Data 55 TMS gt25 data pts
Navy Weight Data 55 TMS gt25 data pts
JCARD
Weight Data F/A-18EF, F-22
Weight Data F/A-18EF, F-22
Weight Data F/A-18EF, F-22
Weight Data F/A-18EF, F-22
CCDR 1921-1 F/A-18EF, F-22
CCDR 1921-1 F/A-18EF, F-22
CCDR 1921-1 F/A-18EF, F-22
CCDR 1921-1 F/A-18EF, F-22
FY06
FY07
FY08
FY09
12
JCARD DEVELOPMENT/SUSTAINMENT
(NOTIONAL CONCEPT)
100
90
SUSTAINMENT
80
NOW

• UPDATES
• PROCESS IMPROVEMENT
• ENHANCEMENT

70
60
50
Analysis Research
DEVELOPMENT

• Build CER Libraries
• Perform addl validation/ crosschecks

40

• DATA
• Collection, organization, normalization,
  validation
• PROGRAMMING
• Develop table structure
• Write code
• Test System

30
20
10
0
FY05
13
JCARD ACHIEVEMENTS

• MAKING DATA ACCESSIBLE, ELIMINATING DUPLICATION
  OF EFFORT, CAPITALIZING ON RESEARCH EFFORTS,
  INCREASING SHARING OF DATA AND INFORMATION
• WEIGHT DATA (AIR FORCE NAVY)
• MACDAR
• 4.2 RESEARCH EFFORTS
• ACDB
• NAVY EXPENDITURE DATA
• IMPROVING QUALITY OF DATA
• CCDRS
• IMPROVING PROCESSES FOR OBTAINING DATA

14
DEMO (SCREENSHOTS)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
SUMMARY

• JCARD WEB INFORMATION SYSTEM HAS THE POTENTIAL TO
  BE A VERY POWERFUL TOOL FOR COST ANALYSTS WITHIN
  THE DOD COST COMMUNITY
• SEVERAL MORE YEARS OF DEVELOPMENT REQUIRED
  FOLLOWED BY YEARLY UPDATES AND MAINTENANCE