Contract Performance Report (CPR) Format 4a

Earned Value Manager Report Descriptions › Contract Performance Report (CPR) Format 4a - Staffing (BAC)

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

Description

The Contract Performance Report (CPR) Format 4a provides a forecast of staffing by person-months and OBS units. This report contains header data, such as schedule dates for the contract and contains program variance thresholds for month, cumulative, and at-complete percentages and values.

Budget at complete (BAC) can be in months, days, or hours.

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 that will appear on the report. Click the Browse icon to select contracts by report period. Only contract reports to which you have at least view access are available for selection.

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

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's 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's zip code.
Country. Displays the organization's zip code.

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's name.

Database Table and Column: CPR_BASE.CONTRACT_NAME

b. Number

Displays the contract's unique ID.

Database Table and Column: CPR_BASE.CONTRACT_NUMBER

c. Type

Displays the contract type's 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's name.

Database Table and Column: CPR_BASE.PROGRAM_NAME

b. Phase

Displays the program's 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

ORGANIZATIONAL CATEGORY (1) (columns 2-16)

Displays staffing metrics aggregated by the OBS unit. Each OBS unit is defined by a Team Member Staffing OBS and is displayed on a separate line. The OBS units that display will vary depending on the OBS level selected when the EVM CPR Report Data Generation job is run.

Database Table and Column: PERFORMANCE_ITEM_4A.TYPE, PERFORMANCE_ITEM_4A.SEQUENCE, PERFORMANCE_ITEM_4A.NAME, and PERFORMANCE_ITEM_4A.ITEM_LEVEL, where

TYPE is 1. The numerical representation for Organizational Category.
SEQUENCE is the order of the line item.
NAME is the name of the OBS unit.
ITEM_LEVEL is the OBS level.

6. TOTAL DIRECT (columns 2-16)

Displays the total of the OBS staffing BAC metrics for each column.

Database Table and Column: PERFORMANCE_ITEM_4A.TYPE, where TYPE is 2.

Planned Current Period (2)

Displays the BAC staffing in man-months, hours or days for the current reporting period. These values are calculated when the EVM CPR Report Data Generation job based on the BAC usage for each assignment and aggregated based on the Team Staffing OBS unit assigned to the team record. If the Team Staffing OBS is blank, the head count is not included in this report.

Database Table and Column: PERFORMANCE_ITEM_4A.PLANNED_CURRENT_PERIOD

Planned End of Current Period (Cumulative) (3)

Displays the cumulative through the end of the reporting period.

Database Table and Column: PERFORMANCE_ITEM_4A.PLANNED_END_CURRENT_PERIOD

FORECAST (Non-Cumulative)

SIX MONTH FORECAST +1 (4)

Displays the staffing forecast (BAC) for the next month.

Database Table and Column: PERFORMANCE_ITEM_4A.M_FORECAST_1

SIX MONTH FORECAST +2 (5)

Displays the staffing forecast (BAC) for the second month after the current one.

Database Table and Column: PERFORMANCE_ITEM_4A.M_FORECAST_2

SIX MONTH FORECAST +3 (6)

Displays the staffing forecast (BAC) for the third month after the current one.

Database Table and Column: PERFORMANCE_ITEM_4A.M_FORECAST_3

SIX MONTH FORECAST +4 (7)

Displays the staffing forecast (BAC) for the fourth month after the current one.

Database Table and Column: PERFORMANCE_ITEM_4A.M_FORECAST_4

SIX MONTH FORECAST +5 (8)

Displays the staffing forecast (BAC) for the fifth month after the current one.

Database Table and Column: PERFORMANCE_ITEM_4A.M_FORECAST_5

SIX MONTH FORECAST +6 (9)

Displays the staffing forecast (BAC) for the sixth month after the current one.

Database Table and Column: PERFORMANCE_ITEM_4A.M_FORECAST_6

ENTER SPECIFIED PERIODS (columns 10-13)

Displays the staffing forecast (BAC) 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_4A.SP_FORECAST_1, PERFORMANCE_ITEM_4A.SP_FORECAST_2, PERFORMANCE_ITEM_4A.SP_FORECAST_3, PERFORMANCE_ITEM_4A.SP_FORECAST_4

ENTER SPECIFIED PERIODS (14)

Displays the remaining BAC 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_4A.SP_FORECAST_5

AT COMPLETION (15)

Displays the total staffing (BAC) for the entire OBS unit. This value is calculated when the EVM CPR Report Data Generation job is run.

Database Table and Column: PERFORMANCE_ITEM_4A.AT_COMPLETION

Forecast Column Headings (columns 4-15)

The PERFORMANCE_DATA_HEADER_4A table contains the column headings generated when the EVM CPR Report Data Generation job is run.