CADE USER M - PDF document

1 CADE USER M ANUAL Data & Analytics
CADE USER M ANUAL Data & Analytics 1 Table of Contents 1. Introduction to CADE ................................................. ............................ ....2 2. Data and Analytics ..................................................... .......................... ... .. .. 3 3. Search............................................................................. ............................ .10 4. Dashboard...................................................................... ..............................17 5. Library.... ..................................................................... ................................ 43 6 . Glossary of Terms and Acronyms ..................................... .........................47 7 . References...................................................................... .............................49 2 Introduction to CADE What is CADE? The Cost Assessment Data Enterprise

2 (CADE) is an initiative of the Office of
(CADE) is an initiative of the Office of the Secretary of Defense Cost Assessment and Program Evaluation (OSD CAPE) with the goal to increase analyst productivity and effectiveness by collecting, organizing and displaying data in an integrated web - based application. CADE provides all DoD Government analysts with a websit e housing authoritative source data which are easily searchable and retrievable. To learn more visit “http://cade.osd. mil /”. About this Document The Data and Analytics application of CADE provides analyst s the capability to query and download Cost and Software Data Report ing (CSDR), Earned Value Management (EVM) , and Select ed Acquisition Report (SAR) data. Additionally, analysts have access to various “search” and “save” tools like CADE Library and My Favorite Programs to better help them navigate the database and find the cost and program data most relevant to them. The purpose of this manual

3 is to provide all CADE users and studen
is to provide all CADE users and students with a detailed description of each of the main functional areas of the site, as well as serve as a step - by - step guide on how to fully utilize the technical functionalities and interpret related content. Registration and Getting Started Registering for CADE is a simple step - by - step process for which you will need to create a username and secure password, and provide a government or company email address. If you are a new user, please read the “CADE Registration Instructions” and then you can “Request a CADE Account” in the top right corner of the CADE Public website: http://cade.osd.mil . All returning CADE users and students may click “CADE Portal Login” and “Student FA C ADE Login , ” respectively, in th e top right corner of the CADE public website for access. 3 Data and Analytics From the CADE Portal Home Page, you can access the Data &Analytics application b

4 y clicking on the named link located un
y clicking on the named link located under the Applications - Analyst menu on the left - hand side of the screen as shown in Figure 1. Figure 1: CADE Portal Home Page 4 The Homepage The first screen or “Homepage” that an analyst will view in the Data & Analytics application is shown below in Figure 2. Figure 2: Data & Analytics Homepage The Data & Analytics “Homepage” is focused on ensuring analyst s are aware of the data available in CADE. As shown in Figure 3, analyst s have the ability to search D ata by P rogram using the drop down menu. Figure 3: Data & Analytics Program Search Dropdown Menu 5 The “ Advanced Program Search ” option, which is located next to the Search Program s d rop d own m enu, seen below in Figure 4, allows an analyst to define search preferences. Figure 4: Data & Analytics Advanced Program Search A nalysts will be directed to t

5 he “Advanced Program Search” page (F
he “Advanced Program Search” page (Figure 4a) where they will have the ability to browse and find programs meeting the defined criteria . On this page, analysts will also have the ability to select their favorite programs by selecting the star next to the program of choice. Figure 4a: Advanced Program Search Page 6 Analyst s can see the programs they selected as their favorite s from the homepage by selecting “ My Favorite Programs ,” as shown below in Figure 5. F igure 5 : Data & Analytics My Favorite Programs Selecting “ My Favorite Programs ” will allow the analyst to see a list of their favorite programs ( Figure 5 a). Figure 5a: My Favorite Programs Page 7 Select Favorite Programs: A favorite program is one that has been marked by the user for easy access. To mark the program as a favorite, click on the outlined blue star to the righ t of the Data by P rogram bar; the

6 star will fill in solid blue , denoti
star will fill in solid blue , denoting it is an analyst’s favorite, seen in Figure 6 . All favorited programs will appear in a list as shown in Figure 5a. To remove a program from the favorites list, simply click the solid blue star to toggle the setting. Figure 6 : Save Favorite Programs 8 From the Homepage analysts will have access to various types of data and resources (Figure 7 ) . Analyst s will have the ability to Browse Data A cross Programs with: CSDR Data  Browse CSDR Submissions : Browse Contractor Cost Data Report ( CCDR ) , Contractor Work Breakdown Structure ( CWBS ) Dictionary , and Software Resources Data Report ( SRDR ) submissions by service, commodity, etc.  Business Base Data: 1921 - 3 : Contractor overhead rates, reported annually , including 1921 - 3s and Forward Pricing Rate ( FPR) data  Cross - Report CCDR Query : Specialized tool used for searching parsed da

7 ta within CCDR files Other Cost Data
ta within CCDR files Other Cost Data  Search ACDB Inventory : Search Army d atabase s for normalized schedule, cost, and technical data  CADE Library : Library of cost estimate documents : reports , cost estimates, sit e visits, etc. Analyst will also have access to different types of resources: Resources  External Links : Links to useful cost estimation websites , such as Defense Acquisition University ( DAU ) , Defense Acquisition Management Information Retrieval ( DAMIR ) , and the service cost centers  Downloadable Tools : Collection of software tools such as inflation calculators and the contracts database Figure 7 : V arious types of data and resources 9 The Navigation Bar The Data & Analytics navigation bar has been organized into three ma in m en u s ( Data , Tools , and Retrieve Files ) ; access back to the CADE Portal ; and easy navigation to the Data & Analytics Homepage

8 via the home icon (Figure 8 ) .
via the home icon (Figure 8 ) . Figure 8 : Navigation bar with Data dropdown options To navigate between the sections, utilize the black navigation bar , which will always appear across the top of the screen. To view a particular section, click on the title or hover your cursor over the title to view a dropdown list of selected subsections und er each title. An example of the dropdown list is shown in Figure 8 . 10 Search Advanced Programs Search Function The “ Advanced Programs Search ” function allows analysts to query, filter, favorite, and select programs based upon certain criteria. It contains a combination of dropdown and text fields. To utilize this function, go to the Data & Analytics Homepage and select “Advanced Program Search .” Group By: In this section, the user can arrange the outputs by Service, DAES Group, Acquisition Category (ACAT), or Commodity Group. In the example given in Figure 9

9 , the results will be grouped by Servi
, the results will be grouped by Service . Filter By: This optional filter function allows analysts to query the list of programs available to a subset of programs based on the input entered . Program Name: Enter the (partial) program name to narrow your search. Services: Select from a list of military departments and agencies. DAES Group: A group of programs that undergo the Defense Acquisition Executive Summary (DAES) Review on a quarterly basis. ACAT: If known, select the appropriate Acquisition Category. Commodity Group: A group of weapon systems belonging to the same militar y standard category. Contractor: Enter the (partial) name of the prime or subcontractor. Figure 9 : Advanced Program Search Screen Reporting Statuses: 1. Select “Active Only” if you are searching for an acquisition program that is actively providing reports (i.e. , is responsible for future submissions).

10 2. Select “All” if you want to
2. Select “All” if you want to search across defe nse programs, including legacy programs that are no longer active in reporting. 11 Latest Earned Value Management – Central Repository ( EVM - CR ) Defense Acquisition Executive Summary ( DAES ) Assessment: Users can filter the search results based on the latest DAES assessment. The options for assessment ratings are Good, OK, Partial, Non - compliant, No Data, and Not Reporting. This provides use rs with a quick look at which programs have a specific rating. The results will appear to the right of the “Group By” and “Filter By” options seen in Figure 10 and will be categorized by the selected group (Service, DAES Group, ACAT, Commodity Group). C lick the downward ( upward ) pointing arrow on the left - hand side of the grey tabs to expand ( hide ) the results. Figure 10 : Search Program Screen 12 Cross - Report CCDR Q

11 uery Function To access the Cross
uery Function To access the Cross - Report CCDR Query function, go to the Data & Analytics Homepage and select “ Cross - Report CCDR Query ” or move your cursor over “Data” on the black navigation bar and click on “Cross - Report CCDR Query .” Here, analysts query, filter, and compile all Extensible Markup Language (XML) converted Cont ractor Cost Data Reports (CCDR) and export the data into an analysis - ready flat file. Please note that most files dated from the year 2000 through the present are XML converted files. All files dating back to the 1960’s are available in MS Excel or jpeg format . To create a new query, click “ Edit/Run ” in the left side of the Query toolbar. Fi gure 11 : Query Function Query Functions (Edit/Run) A. Click “ Add Filter ” and select the category (Commodity, Program, Service, etc.) by which the search results should be filtered and click “ Run .” To generate all report

12 s with a given keyword such as Radar o
s with a given keyword such as Radar or Airframe , select the WBS Element Name filter and a search field will appear. Enter the keyword and press “OK.” Figure 1 2 : Edit/Run Query Screen 13 B. On the following filter screen, select one or more of the available field options to specify your search and click “O K .” Figure 1 3 : Edit/Run Filter Screen C. On the final screen, the filters and selection results will appear. To add to the filter selection, select a different option on the “Add Filter” dropdown . To remove the latest filter, click the red “X” on the right - hand side of that filter row. Figure 1 4 : Selection Results 14 D. Click “Run” to generate a list of CCDRs and related metadata by program. E. Results can be sorted in any particular order by clicking on the column title; to nest sort columns, click the title

13 s in the order desired. F. Utilize t
s in the order desired. F. Utilize the “Include All”, “Exclude All”, or green check mark / red “do not e nter” toggle on the left - hand side of the screen to determine which files will be included or removed from the export; the number of “Included Reports” will update in the top right corner of the screen. Figure 1 5 : Query Results Report Detail To view more details for each report , click on the underlined name in the Repo rt Name column seen in Figure 15 . Within the Report Details view you can review basic program, contract, and submission information. All forms associated with the given report will app ear in tabs as seen in Figure 16 . To move to a different report in the list , you can click the Previous and Next buttons. Figure 1 6 : Report Details 15 Export Data and Retrieve Files Click the export icon located above the report name on the “Report Detai ls” screen. As seen i n Figure

14 17 , an option bar will appear for all
17 , an option bar will appear for all files exported with under the Report Details functionality. From there, flat files may be opened or saved to your local drive. Figure 1 7 : Export Flat Files from Report Details To export select specific reports and determine the data outputs and format for each, click on the export button in the “Results” section of the toolbar in the top left section of the screen, the pop - up window seen in Figure 1 8 will appear. Note: Export to .csv (comma separated values) when retrieving detailed export tables for several dozen files. Exports will always be provided in a default MS Excel format otherwise. Files that are too large for E xcel will also export as .csv files. Export Query Results explained: A. Quick Export Tables a. Metadata : Will return a table by CCDR with associated metadata including program name, contract number, prime/sub - contractor name, location, and other information abou

15 t the data reports Figure 18 : Expor
t the data reports Figure 18 : Export Query Table 16 b. Summary Elements : Will return a data table with “below the line” data elements including subtotal cost, general and administrative (G&A) costs, management reserve (MR), profit, and total price. c. Element 1.0 Only : For each CCDR this export will provide the cost, hours and quantities for Element 1.0 only, further segregated by functional resource categories such as engineering labor and raw materials. B. Detailed Data Tables a. Functional Cost and Hours : Will return the f ull range of cost, hours and quantity data within the CCDR for all elements within the WBS hierarchy (i.e., data from DD Forms 1921 and 1921 - 1). b. Progress Curve : For programs in sequential production this data table will provide unit recurring cost and hour s (i.e., data from DD Form 1921 - 2) . C. Native Documents a. This export option will provide a ZIP file that contains a raw unde

16 rlying submission for the Contract Cost
rlying submission for the Contract Cost Data Reports (CCDRs) such as legacy Excel or XML files. b. The identifying link between native doc uments (excel or xml files from which the original data is retrieved) and the export tables will be the CCDR report ID (seen in Figure 17) which serves as a unique identifier. When a user has successfully exported their report(s ) , the docume nt(s) will a utomatically be sent to the queue accessible on the navigation bar under the “ Retrieve Files ” outlined in Figure 19 . Click the blue down arrow icon under “Actions” to download the document or the trash can icon to delete and remove files from the queue. Figure 19 : Retrieve Files Screen Cross - Report CCDR Query data are exported in E xcel format and contain comprehensive program information related to the selections in the export query. Be sure to control for items such as the CCDR Report ID, WBS Reporting Level, Units of Measurement

17 , and other factors that may cause data
, and other factors that may cause data to be double - counted, skewed, or otherwise inaccurately represented. A sample export can be seen in Figure 20 . Figure 20 : Exported Query 17 Dashboard Program - specific information can be accessed at any point by a program from the Data by Program dropdown menu on Data & Analytics Homepage (seen in Figure 3) or from the Data by Program dropdown menu when on a program - specific page . From this point, you have ea sy access to specific P rogram C ontract s and D ata A vailability information , as well as related Acquisition , Cost , Earned Value Management (EVM) , and Cost Analysis Requirements Description ( CARD ) data . Only one program may be viewed at a given time. Figure 21 : Program Dashboard View 18 Widget s The Widgets can be viewed on the left - hand side of the selecte d program’s Dashboard (Figure 22 ). Figure 22 : Program Dashboard wi

18 th Widget options - Program F
th Widget options - Program Funding Detail from DAMIR : Provides a quick summary of the program funding detail from the Defense Acquisition Management Information Retrieval (DAMIR) system for the program being displayed in the Dashboard.  The “View Funding Detail” link has been provided so the user can quickl y navigate to view funding details. - SAR Schedule Events : Provides a quick summary of Selected Acquisition Report (SAR) program events from DAMIR for the program being displayed in the Dashboard.  The “View and Plot Events” link is provided so the user can quickly navigate to View and Plot Events - Key Events : Provides a summary of key events in the program’s history. Events are maintained by the CADE user community.  Select “View and Plot Key Events” to select and add key events to EVM Views or Create New Key Events. - CARD s : T he user can submit, browse, and search for Cost Analysis Req

19 uirements Description (CARD) file s
uirements Description (CARD) file s - Library : Provides a summary of the recent activity in the CADE Library. The latest files that have been uploaded are highlighted in the widget. The user can also select the View Library link to navigate to the library. - Community Knowledge : All users can select the link to share and view information related to a specific program. - ACDB Systems : Provides visibility into ACDB data av ailable by program and allows user to search ACDB data with the “Search ACDB” link. 19 Side bar Navigation Sidebar navigation tools are available on the left - hand side of the page above the W idgets and will allow the analyst to view specific program - related Acquisition, Cost, EVM, and CARD Data, as seen in Figure 23 . A program will only show data that is available. The following sections detail the information, data, and functions that can be accessed through this sidebar nav

20 igation . F igure 23 : Data Availab
igation . F igure 23 : Data Availability on Program Dashboard View Program Search and My Favorite Programs Functions The Data by Program dropdown menu to the left of the screen will display the name of the Program that is currently being viewed. This search function will also allow the user to search for a different program by typing in a (partial) program name in the white search bar and selecting ente r. The displayed program can be added or removed from the My Favorite Programs list by selecting or deselecting the blue star to the right of the program name. Click on the “My Favorite Programs” on the Data & Analytics Homepage link to access a complete l ist of favorit ed programs as shown in Figure 5 . Program Summary Table and Graphs The first table displays high - level program - specific information in a summary format. The user can quickly understand the Program Name and associated Program Number (PNO) as it is listed in th

21 e CADE and DAMIR databases. The table
e CADE and DAMIR databases. The table also provides the lead ser vice, DoD Program Group, Acquisition Category (ACAT), date of the latest SAR, the Acquisition Cost in millions of Then - Year dollars (TY$M) , and the Quantity. 20 The two graphs displayed in the middle of the dashboard view provide a high - level look at Acquis ition cost and quantity data using SAR data. Further details on these charts will appear in the Acquisition Views section ( add link to section w/section #). Program Contracts and Data Availability Table This dashboard function lists the CSDR and EVM data that are available by contract for the program. Click the blue addition sign to view contract - specific EVM and CSDR sub - tables that summarize the data by task. EVM Data (By Task) sub - table provides a quick view of the reports available in CADE; click the binoculars icon to browse EVM data. To the right of this function, click the magnifying glass to ac

22 cess various EVM graphs, or the double
cess various EVM graphs, or the double down blue arrows to export and down load the data. Similarly, the CSDR Data (By Task) sub - table can be expanded using the blue addition sign to view the CSDR submissions, their dates, and the types of reports available. The binoculars allow the user to navigate to the Browse/Export data page and the double down blue arrows allow the user to select and download the available CSDR data. Figure 24 : Expanded View of the Program Contracts and Data Availability Table 21 Acquisition In the Acquisition section of the blue program menu, you will find data and information from the Defense Acquisition Management Information Repository (DAMIR). You can navigate to the pages with acquisition data by selecting Acquisition on the left side of t he program - specific dashboard using the tabs as shown below in Figure 25 . F igure 25 : Availability for Acquisition Data A. Views There are four dist

23 inct Acquisition views available to the
inct Acquisition views available to the user as seen in Figure 26 . Each provides access to various budget, quantity, and schedule data over periods of time. The analyst can select the icon for each graphic to access the data, view and/or edit the chart, and download the data. Figure 26 : Acquisition Views 22 a. Acquisition Cost and Quantity Estimate across SAR Submissions – This graph, which can be seen in the Dashboard (Figure 2 1 ), displays the total cost and quantity estimates for e ach annual SAR submission. This view also shows the total program funding for acquisition appropriations over time. Each bar, along the left - axis, represents the total acquisition cost in then - year dollars for a particular SAR submission. It is pre - selected to be broken out by Research, Development, Test and Evaluation (RDT&E), Procurement, Mil itary Construction (MILCON), and Operations and Maintenance (O&M). The line along the right - axis shows

24 the total pr ocurement quantity. In Fig
the total pr ocurement quantity. In Figure 2 7 , we see that the total acquisition cost and quantity has grown from ~$13B and 1,000 units in the Dec - 04 su bmission to ~$28B and 1,100 units in the Dec 2015 submission. Changes may be applied or reset and will be displayed in the visual graph if applicable. The “Export Data to Ex cel” function is available above the Maximum and Mini mum Options fields. To the l eft of the controls is a “Zoom In” function that can be used to enlarge the visual data. The legend appears in the top right corner of the graph. Figure 27 : Acquisition Cost and Quantity Estimate b. Time - Phased Acquisition Costs and Quantity – This view displays the time phasing of cost by appropriation and procurement quantities from the most recent SAR submission; this graph can also be viewed on th e Dashboard as seen in Figure 21 . For the most recent SAR submission, this view displays the time phasin g of the acquisi

25 tion budget authorized by congress. On
tion budget authorized by congress. On the left - axis, the annual program funding in then - year dollars is broken out by RDT&E, Procurement, MILCON, and O&M. The dotted line on the right - axis shows the annual procurement quantity ordered, or in the case of a future period, the forecasted order. 23 In F igure 28 you can view a program for which funding began in fiscal year 2003 and procurement is expected to end in fiscal year 2029. Changes may be applied or reset and will be displayed in the visual graph if applicable. Set filters by clicking the appropriate fields under the “View Controls” section on the left - hand side of the screen. To the right of the controls is a “Zoom In” funct ion that can be used to enlarge the visual data; the legend will appear on the graph. The “Export Data to Excel” function is available below the Maximum and Minimum Options fields. Figure 28 : Time - Phased Acquisition Cost and Quantity c. Av

26 erage Procurement Unit Cost (APUC)
erage Procurement Unit Cost (APUC) This view displays the APUC across various SAR submissions in a single view. Though the APUC reported in the SAR is in constant base year dollars, this chart only provides a then - year dollar seen with the bars on the left - axis. Constant - dollar data for t he APUC are available by utilizing the export option. Note that the base year of the APUC may change over time according to baseline updates. For a consistent constant - dollar view, the analysts can normalize the then year costs available in the export usin g an inflation index, properly weighted by the budget appropriation. T he dotted line along the right axis represents the total estimated procurement quantity. 24 Figure 29 : Average Procurement Unit Cost d. SAR Events Over Time/ Schedule Events The SAR Schedule Events provides a graph and chart of the Current Estimate, Acquisition Program Baseline Objective, APB Threshold, and

27 SAR Baseline of various SAR events (mil
SAR Baseline of various SAR events (milestone decisions, design reviews, etc.) for each SAR submission. This view allows the user to observe chronological changes in the schedule of a selected program. Analysts have the ability to export event flat files and chart data by clicking the respective links in the top left corner of the page; you will be prompted to open or save the generated document. Submission Effective Dates may also be chosen to be displayed on the graph. The vertical axis displays the SAR completion date as the horizontal axis will display SAR submissions dates; schedule slips to program events are displaye d by an increasing line. A table of all program events listed the selected SAR submission is situated below the chart and program events selection field. Select the SAR submission tabs to view program events for a different estimate. Changing the table does not affect the view above. 25 Figure 30 : SAR Estimates over Time

28 B. Program Information: Provide rev
B. Program Information: Provide review key program information, a list of sub programs, and the Mission and Executive Summary from the Selected Acquisition Reports (SARs). a. S AR Annual Funding: Provides summary budget figures in tabular format. Key information listed includes then year costs, base year costs, and procurement quantities by fiscal year and budget appropriation. The export options provided include the “Single SAR Export” which provides all cost and quantity data for a selected SAR submission, and the “SAR Flat File Export,” which provides one export including the cost and quantity data from all SAR submissions for that program. The files may be opened or saved to y our local drive. b. M AR Annual Funding: This section is the same as the SAR Annual Funding, but pertains to Major Automated Information Systems (MAIS) instead of Major Defense Acquisition Programs (MDAP). The data fields for this section of the MAR are the s ame

29 as the SAR. The MAR export does not yet
as the SAR. The MAR export does not yet include a “MAR Flat File Export,” though it does provide a flat file for a single MAR submis sion in the “Single MAR Export. c. Contract Budgets: Provides information on major contracts as reported in the Defense Acq uisition Executive Summary (DAES) grouped by budget appropriation. These data further breaks - out into completed contracts, large active contracts, small active contracts, future contracts, and non - contract (program office) costs. 26 Cost and Software Data Reports ( CSDR ) In the CSDR section under the Dashboard tab , the user will be able to browse, view and export CSDR files and reports based on the criteria selected using the filters. Figure 31 : Availability for CSDR Data a. Brow se Submissions - Browse CCDR, CWBS, & SRDR Submissions by service, commodity, etc. Browse Submissions is a feature within Data & Analytics that allows the analyst t

30 o filter S ubmissions by Commodity, Pha
o filter S ubmissions by Commodity, Phase, Service, Contract Type, Reporting Contractor, Min Date, Max Date, Contractor Type, and Search, as seen in Figure 32 and 32 a. Figure 32 : Filter Submissions 27 Figure 32 a: Filter Submissions The results of the filtered submission will show up in the Submi ssions table, shown in Figure 33 Figure 33 : Results from Filtering 28 The analyst can also filter in the Submissions by usi ng the table, shown in Figure 34 . Figure 34 : Filtering from Submissions Table b. Browse/Export - Browse function to view Cost and Software Data Reports submission. Here the analyst can drilldown specific contract, contract tasks, and submissions and export in either a flat file or traditional CCDR format. When clicking on the arrow, as seen in Figure 35a, a list of associated contracts will drop down with ability to click on them. Figure 35 : Browse/ Export Data 29 Figure 3

31 5a: Dropdown of Contracts 30
5a: Dropdown of Contracts 30 Earned Value Management (EVM) In this section of the blue program menu bar analysts can access program - specific earned value management data using the report view browse function, build charts using one of 13 EVM views, run validity checks, and export the data using a variety of filters. The contract task/ effort table is accessible from all the EVM Pages. The analyst must select an effort before they c an see data or char ts (Figure 36) . Figure 36 : Availability of EVM Data by contract task/effort table Views Once the analyst select a contract task or effort they can see the Views (Figure 33) , analysts can build various graphs using the IPMR 1 - 4 formats. Each graph contains a header bar that lists the contract number, contract phase and task, and the performing contractor. Other functions, like data exportation and graph manipulation features are available in each view but will alter form. O

32 ther features are completely unique to t
ther features are completely unique to the current view. 31 Figure 37 : EVM Views 1. Performance over Time - This view, as shown in Figure 38 , will provide an EVM metrics of the contract task over a specified time period. - Adjust the primary and secondary y - axes in the fields or add and remove multiple EV variables to the graph and set the corresponding scale and metric for each. Below the graphs are fields in which the date range can be set for the x - axis and decimal points for the y - axis. Figure 38 : Performance over Time View Adjust the Primary and Secondary Y - axes and its functions. Set date, range, decimals, filter data, and format the tables and files 32 2. Element Performance Comparison - This view, as shown in Figure 39 , allows the analyst to compare across WBS elements in one, or at most two, time periods rather than just one element over time. - The analyst to select the number of

33 and level at which elements will be com
and level at which elements will be compared. The Primary axis (left - hand side) allows the analyst to view an EVM metric across the WBS elements. This will be represented as bars. The value for the selected metric will be displayed for two time periods which the analyst can select (“Date 1” in pink and “Date 2” in blue). - The secondary axis (right - hand side) allows the analyst to compare a different metric represented as a diamond scatter plot. This allows the analyst to, for example, find the largest elements in terms of budget using the primary axis metric (bars) and compare all their cost performance index values using the secondary axis metric (scatter). Figure 39 : Element Performance Comparison View 3. Gold Card - As shown in Figure 40 , - This view provides standard EVM Gold Card metrics over time. Add overlaying summary and performance metrics and update minimum and maximum values summary and performance values. - Under

34 View Controls, select the series of var
View Controls, select the series of variables to be displayed in the graph and select the chart style. - Add overlaying summary and performance metrics and update minimum and maximum values summary and performance values Update the primary and secondary axes and report Utilize these fu nctions to zoom in, export the data, or copy the chart Adjust the dates and table formatting 33 Figure 40 : Gold Chart View 4. Galaxy Chart - This chart will provide a snapshot of how dollar figures are broken out among categories. The size and location of each circle is relative and proportional to that variables impact on the overall budget. - Adjust the parameter s for the main and dashed circles including metrics and choose the series that need to be represented. - In the gray box labeled “Total”, review a detailed list of the segments and sub - segments comprising the galaxy chart. - Select the total number of le vels in the bo

35 x below “Total” or change the report
x below “Total” or change the reporting period at the top of the screen. Figure 41 : Galaxy Chart View Select the appropriate series, minimum/maximum options and viewing options Adjust the reporting period, number of total levels, and view a breakdown of each individual bubble. Adjust the metrics for the main and dashed circles 34 5. To Complete Performance Index (TCPI) – The purpose of this view, shown in Figure 42 , is to show the cost performance index (CPI) versus the To - Complete Performance Index (TCPI). The CPI signals current cumulative cost performance, where 1.00 is performance to plan and values lower than 1.00 indicate cost overruns. The TCPI indicates what future cost performance is required in order for the contractor to hit their Estimate at Complete (EAC). - Under View Controls, adjust the start and end date for the reporting period or edit controls such as the WBS element, graph conventions (labels, s prea

36 d lines), or adjust the minimum and maxi
d lines), or adjust the minimum and maximum values for cost efficiency and percent growth. - As a general rule, when the TCPI value exceeds that of the CPI by of 0.10 or more, the contractor is unlikely to come in at their estimated costs and may requ ire a re - plan. Adjust the Figure 42 : TCPI View Adjust the WBS elements, conventions, and Min/Max options 35 6. EAC Growth Rate (Estimate at Complete) – This view allows the analyst, for a selected WBS element, to plot the contractor’s Budget at Complete (BAC) relative to the Estimate at Complete (EAC). It also allows the analyst to validate the contractor EAC by creating various Independent EACs. This c an be done using a user - defined weighted average of cost and schedule performance indexes (CPI and SPI) based on either the cumulative values or a 3 or 6 months moving average of the performance index values. Further, the analyst can forecast the

37 future BAC, EAC, or IEAC using a linea
future BAC, EAC, or IEAC using a linear or log - linear regression based on observed values set by the analyst. The forecasted metrics will go out to the contractor estimated completion date, which can be overridden by the analyst if an independent schedule is prov ided. Finally, the analyst may plot and forecast metrics as either dollar or % growth (y - axis) and by month or percent (%) complete (x - axis). Note: the view defaults to “Cost of Money” which does not have the EVM performance metrics. - Set thresholds f or the graph. They include an as - of - date as well as high and low growth percentages. Under the Select Independent EAC function you set parameters for the performance index measured and the CPI and SPI weights. - Select the reporting level and element and adjust the override planned end date. Figure 43 : Independent EAC Growth for Cost of Money View Set thresholds, select independent EAC’s and elements, set f

38 orecasts, and override planned end dates
orecasts, and override planned end dates 36 7. Management Reserve - This chart provides an accounting perspective on managerial funds, more specifically, the baseline, remaining funds against work remaining, and the overall funding. Management Reserve is budget held to cover cost growth that may occur due to the materializ ation of risk. Burning down management reserve early in the contract can signal performance risk. Select the series to be displayed in the chart and set your minimum, maximum, and percent values. Figure 4 4 : Manag ement Reserve View Select series and the Min/Max options 37 8. Budget Shifting - This view shows the analyst which WBS elements have had the greatest volatility in the BAC and/or EAC. The performance issue it is intended to pick up on is when contractors move budget out of back - end elements, such as integration and test, to cover cost overruns in front - end ele

39 ments, such as requirements and design.
ments, such as requirements and design. Note that the dark solid bars represent changes in BAC between two selected dates, colored by cumulative CPI on the latter date. The transparent bars that overlay the dark solid bars repres ent the change in EAC for that exact same Element and time - frame. - To the left of this chart, set the date range, reporting level, number of elements, metrics, and views specific to this chart. - Update the thresholds for the CPI Bin. Updates may be la beled as GOOD, FAIR, or POOR. Figure 45 : Budget Shifting View Select date ranges, adjust the number and reporting level of elements, metrics, select views, and thresholds 38 9. Planning Performance - This view is intended to show planning performance over a six month windows. It is available for “Baseline” dollar plans (Format 3) and “Staffing” plans (Format 4). Both options will show, for the last several reporting periods, what

40 the actual value was f or that period,
the actual value was f or that period, as well as the forecasted values for the next six months. This view allows the analyst to see whether the contractor has expended the amount of dollars it forecasted it would (Baseline option) or whether the contractor has expended the am ount of staffing units it forecasted (Staffing option). - Under View Controls, select your report type, series, preferred viewing options, and minimum and maximum value options. Figure 46 : Planning Performance View 10. WBS Contribution - This chart allows the user to drill down the WBS and view the contribution of children elements to either the “Parent EAC” or the “Total EAC.” It can provide the analyst into which elements are cost drivers, and which elements have been changing over time . - “Select an element to highlight” allows the analyst to select which WBS element to display in the chart - Chose the parameters for the conventions, the date,

41 percent EAC, series type, and the minim
percent EAC, series type, and the minimum and maximum options. Set the report type, preferred viewing options, min/max options, and ser ies selections 39 Figur e 47 : WBS Contribution View 11. Budgeted Work - This chart displays comparative data relating to work planned versus work performed. - Adjust the views for this specific chart and set minimum and maximum values. Figure 48 : Budgeted Work View Set the elements, conventions, percent EAC’s and series types Select the date and Min/Max options 40 12. Staffing Deviat ion - The intent of this chart is to display staffing changes over time. The analyst has the ability to select the baseline and compare it with the actual staffing levels, planned staffing levels, and 6 month projections. - Select the desired series and set minimum and maximum values and cumulative values. Figure 49 : Staffing Deviation View 13. Burn Rate - This chart will disp

42 lay the monthly burn rate for ACWP for a
lay the monthly burn rate for ACWP for a given project. - Select a WBS element; choose conventio ns to include a linear regression, or polynomial regression. Set minimum and maximum options. - The analyst may also use this chart to plot a linear or a polynomial regression to get summary statistics for Figure 50 : Burn Rate View 41 Browse Data From th is page, analysts can view the Integrated Program Management Reports (IPMR) formats 1 - 4 Metadata, by WBS Elements, Summary elements, by OBS elements, Baselines, and Staffing. Figure 51 : Browse Views 42 Export Data Click here to export EVM data in Microsoft Excel format. Figure 52 : Export EVM Data A. All Periods Data Dump - Include or exclude CPR Header, WBS Elements and Summary Elements, OBS Elements and Summary Elements, Baseline Elements, and Budgeted and Estimated Staffing. Set effective period dates and choose OBS and WBS levels. In t

43 his format WBS elements will be liste d
his format WBS elements will be liste d as rows and time periods as columns. B. Alternative Format 1 Data Dump - Include or exclude a Header and Summary. Set effective period dates and choose WBS levels. In this format, time periods will be displayed in a single values column. C. Formatted CPR Repo rt - Include or exclude formatting for OBS, WBS, Baseline, and Staffing. This format provides data in the legacy human readable PDF version of the CPR. D. Validity Check Report - Select the appropriate time period and update the percent thresholds on checks fo r ACWP versus BCWP and comparisons. E. Export by EVM Metric - Include or exclude the Estimate and Budget at Completion (EAC and BAC) and cumulative amounts for ACWP, BCWP, and BCWS. Adjust the effective period dates and WBS levels. F. Raw Files - Include or excl ude the formatted Human Readable CPR, CFSR File, and Native Format Schedule. Click here to extend to the views an

44 d select the tabs and variables to be
d select the tabs and variables to be included in the export as well as the format 43 Library The CADE library is a document repository primarily used to store hanging files that are searchable by document title, as - of date, container type, commodity type, organization name, life - cycle phase and program name and does not search the Cost and Softwar e Data Reports (CSDR) or Earned Value Management (EVM) data stored in DACIMS, the EVM - Central Repository (EVM - CR), or CADE. The CADE library has three main functions: Upload New, Simple Search, and Advanced Search. The default “view” for the CADE library is the “Simple Search”. Upload New In “Upload New” the user can create a new entity within the CADE library called a “container.” A Container is a group of closely related easily accessible files with a common set of metadata. While Containers corresp ond to a single program, it can be tagged with up to seven program

45 s. A. Required Data a. Contai
s. A. Required Data a. Container Title - This should include the program name and a brief description of the container. b. As - Of Date - Use the calendar icon to select the appropriate date. This dat e reflects the as - of date of the data and not the upload date. c. Container Type - Select the appropriate type from the drop - down. If the needed Container Type is not listed, select “Other” and notify the CADE HelpDesk of a new container type that should be a dded to the list. If your document does not fit into one of the preexisting containers, contact the CADE HelpDes k via email at cadesupport@tecolote.com . d. Organization - Select the organization that created th e file(s) from the drop - down list. e. Container Files - Attach relevant files and references B. Optional Data a. Point of Contact (POC) – The point of contact for the container. In some cases, this is the analyst that uploaded the data

46 . This could also be the author of the f
. This could also be the author of the file(s). b. Commodity: If known, select the commodity associated with the file(s). c. Publish Date – This is the date that the data can be published into CADE. This is used by the CADE librarian when access to data or information is restricted by date. d. Life Cycle Phase: If known, select the Life Cycle Phase that corresponds to the associat ed file(s). e. Program Description 44 Figure 53 : Upload New Screen C. Add File - Utilize the Browse function to upload one or more files. Examples of multiple files include : a. A CARD b. Memo with attachments c. Multiple briefs from a site visit All distinct items such as a CARD and ICE should be uploaded in separate containers. Source selection sensitive data or MS Excel files or models should never be uploaded. D. Add a Reference - Select the “Add a Reference” link to associate the files in this container with

47 other containers in the CADE library. F
other containers in the CADE library. For example, an ICE container should be linked to the corresponding CARD container. Simple Search In Simple Search, the user can search or scroll to view all documents available in the CADE library. Within Simple Search, the user can also open the container, view the metadata, and download the associated files 45 Figure 54 : Library Search Options Advanced Search To narrow your results, use the “Advanced Search” option. Select one or more of the Container Level Metadata fields to filter data by the program life cycle phase, organization, commodity group, or file type. Search by clicking “Apply” on the bottom left - h and side of the screen or click “Clear Filters” to start over. Click column headings to sort results, open the container, view metadata, or download associated files. Word Search and Filters Enter a title, keyword, organizatio

48 n, performer, or documen t type in the s
n, performer, or documen t type in the search bar and click “Apply” to search across all metadata categories rather than a specific one. Enter a title, keyword, organization, performer, or document type in the search bar and click “Apply.” Use the “Word Search” function to filter results in the table and click column headings to change the sort order of the table. All results will appear in alphabetical order. 46 Result Displays All results matching the search criteria will display in containers at the bottom of the screen returning information regarding the Flag, Title, As - Of Date, Container Title, Commodity Group, and Program. Figure 55 : Advanced Search 47 Glossary of Terms and Acronyms ACAT - Acquisition Category ACWP - Actual Cost of Work Performed AFCAA - Air Force Cost Analysis Agency AFTOC - Air Force Total Ownership Cost APUC - Averag

49 e Procurement Unit Cost BAC - Budge
e Procurement Unit Cost BAC - Budget at Completion BCWP - Budgeted Cost of Work Performed BMDS - Ballistic Missile Defense CADE - Cost Assessment Data Enterprise CA PE - Cost Assessment and Program Evaluation CARD - Cost Analysis Requirements Description CCDR - Contractor Cost Data Reporting CER - Cost Estimating Relationship CFSR - Contract Funds Status Report CPR - Cost Performance Report CSDR - Cost and Software Dat a Reports DAMIR - Defense Acquisition Management Information Retrieval (Repository) DAES - Defense Acquisition Executive Summary DCARC - Defense Cost and Resource Center DoD - Department of Defense EAC - Estimate at Completion EVM - Earned Value Management FACADE - Functional Academic Cost Assessment Data Enterprise Demonstration and Training Site FCoM - Full Cost of Manpower ICE - Independent Cost Estimate MAIS - Major Automated Information System MAR

50 – MAIS Annual Report MILCON -
– MAIS Annual Report MILCON - Military Construction OBS - Organizational Breakdown Structure O&M - Operations and Maintenance O&S - Operation and Sustainment OSMIS - Army’s Operation and Support Management Information System 48 RDTE - Research, Development, Test and Evaluation SARs - Selected Acquisition Report s SCP - Service Cost Position SRDR - Software Resources Data Reports SSGCS - Surveillance Satellite Ground Control System TCPI - To Complete Performance Index TDR - Technical Data Report VAMOSC - The Navy Visibility and Management of Operating and Support Costs VATs - Visual Analysis Tools WBS - Work Breakdown Structure XML - Extensible Markup Language 49 References Webs ites CADE The Military Standard 881D The Military Factory Dictionary If you have any questions pertaining to the guide, please reach out to the CADE Help Desk: CADE Help Desk: