Contract Performance Report (CPR) Format 1

Earned Value Manager Report Descriptions › Contract Performance Report (CPR) Format 1 - WBS

Contract Performance Report (CPR) Format 1 - WBS

Description

The CPR format 1 includes current period, cumulative, and at complete values for each CWBS element. The report also contains header data showing quantity, targets, ceilings, and estimate at completion (EAC) calculations. Also contains data about budget, pricing, management reserve (MR) and undistributed budget (UB).

Prerequisites

Access rights are assigned to run jobs and reports, and to view contract data.
CPR data for each contract is entered.

The EVM CPR report data generation job is run.

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_1.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. Reporting 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. CONTRACT DATA

a. Quantity

Prod. Line 1 displays the production quantity.

R&D. Line 2 displays the research and development quantity.

Database Table and Column: CPR_FORMAT_1.QUANTITY_PROD, CPR_FORMAT_1.QUANTITY_RD

b. Negotiated Cost

Displays the total negotiated contract cost including MR. This is a calculated value based on the current baseline.

Database Table and Column: CPR_FORMAT_1.NEGOTIATED_COST

c. Est. Cost Authorized Unpriced Work

Displays the estimated cost of unpriced work, where value in this block and column of this report matches the value referenced in block 5.d of the CPR Format 3 report.

Database Table and Column: CPR_FORMAT_1.UNPRICED_WORK

d. Target Profit Fee

Displays the targeted profit fee. This value is displayed as:

baseline burden fees / percent, where percent is a calculated value based on contract fee / total contract cost.

Database Table and Column: CPR_FORMAT_1.TARGET_PROFIT_FEE

e. Target Price

Displays the target contract price. This is a calculated value based on the current baseline.

Database Table and Column: CPR_FORMAT_1.TARGET_PRICE

f. Estimate Price

Displays the same value as block 6.c of this report.

Database Table and Column: CPR_FORMAT_1.EST_PRICE

g. Contract Ceiling

Displays the contract ceiling.

Database Table and Column: CPR_FORMAT_1.CONTRACT_CEILING

h. Est. Contract Ceiling

Displays the estimated contract ceiling.

Database Table and Column: CPR_FORMAT_1.EST_CONTRACT_CEILING

i. Date of OTB/OTS

Displays the OTB/OTS date.

Database Table and Column: CPR_FORMAT_1.OTB_OTS_DATE

6. ESTIMATED COST AT COMPLETION

a. Best Case

Displays the best case, estimated cost at completion.

Database Table and Column: CPR_FORMAT_1.BEST_EST_AT_COMPLETION

b. Worst Case

Displays the worst case, estimated cost at completion.

Database Table and Column: CPR_FORMAT_1.WORST_EST_AT_COMPLETION

c. Most Likely

Management Estimate at Completion (1). Displays the most likely, estimated cost at completion.

Database Table and Column: CPR_FORMAT_1.MOST_LIKELY_EST_AT_COMPLETION

Contract Budget Base (2). Displays the most likely budget base. This is a calculated value based on (block 5.b) + (block 5.c).

Database Table and Column: CPR_FORMAT_1.MOST_LIKELY_BUDGET_BASE

Variance (3). Displays the most likely variance. This is a calculated value based on (block 6.c.2) - (block 6.c.1).

Database Table and Column: CPR_FORMAT_1.MOST_LIKELY_VARIANCE

7. AUTHORIZED CONTRACTOR REPRESENTATIVE

a. Name

Displays the name of person authorized to submit the report to the U.S. Government or Prime contractor (that is, the organization who holds the contract).

Database Table and Column: CPR_FORMAT_1.AUTH_CONTRACTOR_REP_NAME

b. Title

Displays the title of the person who is authorized to submit the report.

Database Table and Column: CPR_FORMAT_1.AUTH_CONTRACTOR_REP_TITLE

d. Date Signed

Displays the server date when the report was generated.

Database Table and Column: CPR_FORMAT_1.AUTH_CONTRACTOR_REP_DATE

8. PERFORMANCE DATA

Item (1)

Each item is represented by the following type:

Work Breakdown Structure (columns 2-16). Type 1
Displays the CWBS and Control Accounts based on the CWBS levels selected when the job is run. Each CWBS element and control accounts are 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.
Cost of Money (columns 2-16). Type 2
Displays the Cost of Money burdened as a total of all line items in block 8.a for the burdening type of COM.
General & Administrative (columns 2-16). Type 3
Displays General and Administrative as a total for all line items in block 8.a for the burdening type of G&A.
Undistributed Budget (columns 14-16). Type 4
Displays the Undistributed Budget per contract baseline (column 14), EAC (column 15), and Variance (column 16).
Subtotal (Performance Measurement Baseline) (columns 2-16). Type 5
Displays the subtotals for all previous line items.
Management Reserve (columns 13-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.
Total (columns 2-16). Type 7

Database Tables and Columns: PERFORMANCE_ITEM_1.TYPE, PERFORMANCE_ITEM_1.SEQUENCE, PERFORMANCE_ITEM_1.NAME PERFORMANCE_ITEM_1.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.
LEVEL is the CBWS level.

Current Period

Budgeted Cost--Work Scheduled (2)

Displays budgeted cost for work scheduled (BCWS).

Database Table and Column: PERFORMANCE_ITEM_1.CP_BC_WS

Budgeted Cost--Work Performed (8)

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

Database Table and Column: PERFORMANCE_ITEM_1.CP_BC_WP

Actual Cost Work Performed (4)

Displays the Actual cost of work performed (ACWP).

Database Table and Column: PERFORMANCE_ITEM_1.CP_ACWP

Variance--Schedule (5)

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

Database Table and Column: PERFORMANCE_ITEM_1.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_1.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_1.CTD_BC_WS

Budgeted Cost--Work Performed (8)

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

Database Table and Column: PERFORMANCE_ITEM_1.CTD_BC_WP

Actual Cost Work Performed (9)

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

Database Table and Column: PERFORMANCE_ITEM_1.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_1.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_1.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_1.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_1.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_1.RA_B

At Completion

Budgeted (14)

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

Database Table and Column: PERFORMANCE_ITEM_1.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_1.AC_E

Variance (16)

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

Database Table and Column: PERFORMANCE_ITEM_1.AC_V

9. RECONCILIATION TO CONTRACT BUDGET BASE

Cumulative To Date

a. Variance Adjustment

Variance--Schedule (10)

Displays the total from block 8.g.12b.

Database Table and Column: RECON_TO_CONTRACT_BGT_BASE.VARIANCE_SCHEDULED

Variance--Cost (11)

Displays the total from Block 8.g.12a

Database Table and Column: RECON_TO_CONTRACT_BGT_BASE.VARIANCE_COST

b. Total Contract Variance

Variance--Schedule (10)

Displays the sum of (block 8.g.10) + (block 9.a.10).

Database Table and Column: RECON_TO_CONTRACT_BGT_BASE.TOTAL_VARIANCE_SCHEDULED

Variance--Cost (11)

Displays the sum of (block 8.g.11) + (block 9.a.11).

Database Table and Column: RECON_TO_CONTRACT_BGT_BASE.TOTAL_VARIANCE_COST

At Completion

b. Total Contract Variance

Budgeted (14)

Displays the value from block 6.c.2.

Database Table and Column: RECON_TO_CONTRACT_BGT_BASE.TOTAL_BUDGET_AT_COMPLETION

Estimated (15)

Displays the value from block 6.c.1.

Database Table and Column: RECON_TO_CONTRACT_BGT_BASE.TOTAL_EST_AT_COMPLETION

Variance(16)

Displays the difference between (block 9.b.14) - (block 9.b.15).

Database Table and Column: RECON_TO_CONTRACT_BGT_BASE.TOTAL_VARIANCE_AT_COMPLETION

More information:

EVM CPR Report Data Generation Job

Set the Contract Performance Report (CPR) Parameters