Earned Value Manager Report Descriptions › Contract Performance Report (CPR) Format 3 - Baseline

Previous Topic: Contract Performance Report (CPR) Format 2 - Organizational Categories

Next Topic: Contract Performance Report (CPR) Format 4a - Staffing (BAC)

Contract Performance Report (CPR) Format 3 - Baseline

Description

The CPR format 3 provides a forecast of monthly changes to the baseline, management reserve (MR), and undistributed budget (UB) for the entire contract. It also contains header data showing the schedule dates for the contract.

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

Database Table and Column: CPR_FORMAT_3.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 DTA
a. Original Negotiated Cost

Displays the total contract cost as of the original, first baseline. This total includes management reserve (MR), but excludes profit/fee.

Database Table and Column: CPR_FORMAT_3.ORIGINAL_NEGOTIATED_COST

b. Negotiated Contract Changes

Displays the sum of all baseline changes between the first baseline and the current baseline. This value is calculated based on Current Contract BAC - First Contract Baseline BAC.

Database Table and Column: CPR_FORMAT_3.NEGOTIATED_CHANGES

c. Current Negotiated Cost

Displays the total negotiated contract cost including MR. This is a calculated value based on the current baseline, or the sum of (block 5.a) + (block 5.b).

Database Table and Column: CPR_FORMAT_3.CURRENT_NEGOTIATED_CHANGES

d. Estimated Cost of Authorized Unpriced Work

Displays the estimated cost of unpriced work. This value is the same as the value found in block 5.c in the CPR Format 1 report.

Database Table and Column: CPR_FORMAT_3.EST_COST_AUTH_UNPRICED_WORK

e. Contract Budget Base

Displays a calculated value based on (block 5.c) + (block 5.d).

Database Table and Column: CPR_FORMAT_3.CONTRACT_BUDGET_BASE

f. Total Allocated Budget

Displays the contract's total BAC + MR + UB. This value includes burdens, but excludes the fee. This total should be the same value as block 8.g.14 in the CPR Format 1 report.

Database Table and Column: CPR_FORMAT_3.TOTAL_ALLOCATED_BUDGET

g. Difference

Displays the calculated value based on the difference of (block 5.e) - (block 5.f).

Database Table and Column: CPR_FORMAT_3.DIFFERENCE

h. Contract Start Date

Displays the date the contract starts.

Database Table and Column: CPR_FORMAT_3.CONTRACT_START_DATE

i. Contract Definitization Date

Displays the date the contract was definitized.

Database Table and Column: CPR_FORMAT_3.CONTRACT_DEFINITIZATION_DATE

j. Planned Completion Date

Displays the date the contract is planned to complete.

Database Table and Column: CPR_FORMAT_3.PLANNED_COMPLETION_DATE

k. Contract Completion Date

Displays the contracted completion date.

Database Table and Column: CPR_FORMAT_3.CONTRACT_COMPLETION_DATE

l. Estimated Completion Date

Displays the date when the organization will most likely achieve the EAC cost found in block 6.c.1 of the CPR Format 1 report.

Database Table and Column: CPR_FORMAT_3.ESTIMATED_COMPLETION_DATE

6. PERFORMANCE DATA
Item (1)

Each item is represented by the following type:

  1. PERFORMANCE MEASUREMENT BASELINE Beginning of Period (columns 2-16) Type 1

    Displays the BCWS from the contract baseline, current as of the start of the reporting period.

  2. BASELINE CHANGES AUTHORIZED DURING REPORT PERIOD (column 16) Type 2

    Displays each baseline between the baseline of block 6.a and the baseline of block 6.c.

  3. Performance Measurement Baseline End of Period (columns 2-16) Type 3

    Displays the BCWS from the contract baseline, current as of the end of the reporting period.

Database Tables and Columns: PERFORMANCE_ITEM_3.NAME, PERFORMANCE_ITEM_3.SEQUENCE, PERFORMANCE_ITEM_3.TYPE, where

  • NAME is the name of the line item. For block 6.a.1, this is blank.
  • SEQUENCE is the order of the line item.
  • TYPE is the numerical representation of the item.
7. Management Reserve (columns 2-16)

Displays the management reserve balance as of the end of the reporting period. Values should be the same as those reported on the CPR Format 1 and CPR Format 2 reports. These values are calculated when the EVM CPR report data generation job is run.

Database Tables and Columns: PERFORMANCE_ITEM_3.NAME, PERFORMANCE_ITEM_3.SEQUENCE,

PERFORMANCE_ITEM_3.TYPE, where TYPE us 4.

8. TOTAL

Displays the sum of (block 6.c.16) + (block 7.16). This value should match the value reported in block 8.g.14 of the CPR Format 1 report.

Database Tables and Columns: PERFORMANCE_ITEM_3.NAME, PERFORMANCE_ITEM_3.SEQUENCE,

PERFORMANCE_ITEM_3.TYPE, where TYPE is 5.

BCWS Cumulative To Date (2)

For block 6.a and block 6.c, displays the cumulative BCWS to-date. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_CUMULATIVE

BCWS For Report Period (3)

For block 6.a and block 6.c, displays the reporting period BCWS . This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_REPORT_PERIOD

BUDGETED COST FOR WORK SCHEDULED (BCWS) (Non-Cumulative)

SIX MONTH FORECAST +1 (4)

For block 6.a and block 6.c, displays the next month BCWS. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_6M_FORECAST_1

SIX MONTH FORECAST +2 (5)

For block 6.a and block 6.c, displays the BCWS for the second month after the current one. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_6M_FORECAST_2

SIX MONTH FORECAST +3 (6)

For block 6.a and block 6.c, displays the BCWS for the third month after the current one. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_6M_FORECAST_3

SIX MONTH FORECAST +4 (7)

For block 6.a and block 6.c, displays the BCWS for the fourth month after the current one. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_6M_FORECAST_4

SIX MONTH FORECAST +5 (8)

For block 6.a and block 6.c, displays the BCWS for the fifth month after the current one. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_6M_FORECAST_5

SIX MONTH FORECAST +6 (9)

For block 6.a and block 6.c, displays the BCWS for the sixth month after the current one. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_6M_FORECAST_6

ENTER SPECIFIED PERIODS (columns 10-13)

For block 6.a and block 6.c, displays the BCWS for the next user-specified periods (that is month, quarter, or annual) after column 9, where each subsequent column represents the next period. These values are calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_SP_FORECAST_1, PERFORMANCE_ITEM_3.BCWS_SP_FORECAST_2, PERFORMANCE_ITEM_3.BCWS_SP_FORECAST_3, PERFORMANCE_ITEM_3.BCWS_SP_FORECAST_4

ENTER SPECIFIED PERIODS-TC (14)

For block 6.a and block 6.c, displays the remaining BCWS from column 13 to the end of the contract. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.BCWS_SP_FORECAST_5

Undistributed Budget (15)

For block 6.a and block 6.c, displays the undistributed budget associated with this baseline. This value is calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.UNDISTRIBUTED_BUDGET

Total Budget (16)

Displays the total budget at completion (BAC). For block 6.b line items, displays the total BAC associated with that baseline. These values are calculated when the EVM CPR report data generation job is run.

Database Table and Column: PERFORMANCE_ITEM_3.TOTAL_BUDGET

Forecast Column Headings (columns 4-15)

The PERFORMANCE_DATA_HEADER_3 table contains the column headings generated when the EVM CPR report data generation job is run.

More Information:

Access Rights

EVM CPR Report Data Generation Job

Schedule Jobs to Calculate Earned Value Metrics