Previous Topic: Contract Performance Report (CPR) Format 1 - WBSNext Topic: Contract Performance Report (CPR) Format 3 - Baseline


Contract Performance Report (CPR) Format 2 - Organizational Categories

Description

The CPR format 2 includes current period, cumulative, and at complete values for each organization unit assigned to a CWBS element or control account. It also contains header data showing quantity, targets, ceilings, and estimate at completion (EAC) calculations. This report also contains data about budget, pricing, management reserve (MR) and undistributed budget (UB).

This report is similar to the CPR format 1, except that it is organized by OBS unit.

Prerequisites
Parameters
Report(s)

Specifies the contracts, appearing in the report, to which you have at least view access. Select contracts by report period in the Report(s) field.

Report Fields
CLASSIFICATION

Displays the security classification for this report.

Values: Competition Sensitive, Confidential, Secret, Top Secret, Unclassified, and any customer-defined classifications.

Database Table and Column: CPR_BASE.CLASSIFICATION

DOLLARS IN

Displays the cost field format on the CPR report.

Values: Dollars, Hundreds, Thousands, Millions, and Billions

Table and Column: CPR_FORMAT_2.REPORT_UNIT

1. CONTRACTOR
a. Name

Displays the name of the organization submitting the report.

Table and Column: CPR_BASE.CONTRACTOR_NAME

b. Location
  • Address. Displays the organization address (lines 1 and 2).
  • City. Displays the city in which the organization resides.
  • State. Displays the state in which the organization resides.
  • Postal Code. Displays the organization zip code.
  • Country. Displays the country in which the organization is located.

Database Tables and Columns: CPR_BASE.ADDRESS_1, CPR_BASE.ADDRESS_2, CPR_BASE.CITY, CPR_BASE.STATE, CPR_BASE.POSTAL_CODE, CPR_BASE.COUNTRY

2. CONTRACT
a. Name

Displays the contract name.

Database Table and Column: CPR_BASE.CONTRACT_NAME

b. Number

Displays the contract unique ID.

Database Table and Column: CPR_BASE.CONTRACT_NUMBER

c. Type

Displays the contract type value. Only one type per contract is allowed.

Table and Column: CPR_BASE.CONTRACT_TYPE

d. Share Ratio

Displays the cost share ratio as defined in the negotiated contract terms.

Database Table and Column: CPR_BASE.CONTRACT_SHARE_RATIO

3. PROGRAM
a. Name

Displays the program name.

Database Table and Column: CPR_BASE.PROGRAM_NAME

b. Phase

Displays the program phase.

Database Table and Column: CPR_BASE.PROGRAM_PHASE

c. EVMS Acceptance

Displays an X next to NO or YES indicating whether EVMS is accepted or not. If accepted, then the date of EVMS acceptance is also displayed.

Database Table and Column: CPR_BASE.EVMS_ACCEPTANCE, CPR_BASE.EVMS_ACCEPT_DATE

4. Report Period
a. From

Displays the starting date for this reporting period.

Database Table and Column: CPR_BASE.PERIOD_FROM

b. To

Displays the end date for this reporting period.

Database Table and Column: CPR_BASE.PERIOD_TO

5. PERFORMANCE DATA
Item (1)

Each item is represented by the following type;

  1. Organizational Category (columns 2-16). Type 1

    Each OBS unit associated with a CWBS element and control account is listed on separate line. The [OH] OVERHEAD line reports the burdening costs for the Overhead Burdening Element and is based on the burden type of Overhead.

  2. Cost of Money (columns 2-16). Type 2

    Displays the Cost of Money burdened as a total of all line items in section 8a for the burdening type of COM.

  3. General & Administrative (columns 2-16). Type 3

    Displays General and Administrative as a total for all line items in section 8a for the burdening type of G&A.

  4. Undistributed Budget (columns 14-16). Type 4

    Displays the Undistributed Budget per contract baseline (column 14), EAC (column 15), and Variance (column 16).

  5. Subtotal (Performance Measurement Baseline) (columns 2-16). Type 5

    Displays the subtotals for all previous line items.

  6. Management Reserve (column 14). Type 6

    Displays the sum of money in the Management Reserve during the reporting period as a part of the reprogramming effort (column 13), and the reserve at the end of the reporting period (column 14) per the current contract baseline.

  7. Total (columns 2-14). Type 7

Database Tables and Columns: PERFORMANCE_ITEM_2.TYPE, PERFORMANCE_ITEM_2.SEQUENCE, PERFORMANCE_ITEM_2.NAME, PERFORMANCE_ITEM_2.ITEM_LEVEL, where:

  • TYPE is the numerical representation of the item.
  • SEQUENCE is the order of the line item.
  • NAME is the name of line item.
  • ITEM_LEVEL is the OBS level.
Current Period

Budgeted Cost--Work Scheduled (2)

Displays budgeted cost for work scheduled (BCWS).

Database Table and Column: PERFORMANCE_ITEM_2.CP_BC_WS

Budgeted Cost--Work Performed (3)

Displays budget cost for work performed (BCWP).

Database Table and Column: PERFORMANCE_ITEM_2.CP_BC_WP

Actual Cost Work Performed (9)

Displays the cumulative actual cost of work performed (ACWP).

Database Table and Column: PERFORMANCE_ITEM_2.CP_ACWP

Variance--Schedule (5)

Displays the schedule variance. This value is calculated based on BCWP - BCWS.

Database Table and Column: PERFORMANCE_ITEM_2.CP_V_S

Variance--Cost (6)

Displays the cost variance. This is value is calculated based on BCWP - ACWP.

Database Table and Column: PERFORMANCE_ITEM_2.CP_V_C

Cumulative To Date

Budgeted Cost--Work Scheduled (7)

Displays the cumulative budgeted cost for work scheduled (BCWS).

Database Table and Column: PERFORMANCE_ITEM_2.CTD_BC_WS

Budgeted Cost--Work Performed (8)

Displays the cumulative budget cost for work performed (BCWP).

Database Table and Column: PERFORMANCE_ITEM_2.CTD_BC_WP

Budgeted Cost--Work Performed (3)

Displays budget cost for work performed (BCWP).

Database Table and Column: PERFORMANCE_ITEM_2.CTD_ACWP

Variance--Schedule (10)

Displays the cumulative schedule variance. This is a calculated value based on cumulative BCWP - cumulative BCWS.

Database Table and Column: PERFORMANCE_ITEM_2.CTD_V_S

Variance--Cost (11)

Displays the cumulative cost variance. This is a calculated value based on cumulative BCWP - cumulative ACWP.

Database Table and Column: PERFORMANCE_ITEM_2.CTD_V_C

Reprogramming Adjustments

Cost Variance (12a)

Displays the reprogramming adjustment cost variance aggregated from all costs recorded against control accounts at this level.

Database Table and Column: PERFORMANCE_ITEM_2.RA_CV

Schedule Variance (12b)

Displays the reprogramming adjustment schedule variance aggregated from all costs recorded against control accounts at this level.

Database Table and Column: PERFORMANCE_ITEM_2.RA_SV

Budget (13)

Displays the reprogramming adjustment budget aggregated from all costs recorded against control accounts at this level.

Database Table and Column: PERFORMANCE_ITEM_2.RA_B

At Completion

Budgeted (14)

Displays the current baseline at completion (BAC) for this line item.

Database Table and Column: PERFORMANCE_ITEM_2.AC_B

Estimated (15)

Displays the estimate at completion (EAC) for the line item. Values are calculated based on the EAC selection in the CPR reports page of contract properties.

Values:

EAC. ACWP + ((BAC - BCWP) / CPIC)

EAC(T). AC + ETC

EAC(AT). (ACWP + (BAC - BCWP))

Database Table and Column: PERFORMANCE_ITEM_2.AC_E

Variance (16)

Displays the variance. This value is calculated using BAC - EAC.

Database Table and Column: PERFORMANCE_ITEM_2.AC_V

More Information

EVM CPR Report Data Generation Job

Set the Contract Performance Report (CPR) Parameters