Project Earned Value

ccppmop157
The Project Earned Value report displays the earned value information of a project by period and in total, allowing you to measure the project performance and progress. The report includes general project information, current performance values, indexes, and cost estimates. The charts include an S-Curve, comparing planned value, actual cost and earned value amounts by period; and an Indexes Curve, comparing target, CPI, and SPI values by period. There is also a report option to display the chart amounts by period in a table format.
The following image displays the Project Earned Value report with Earned Value curves.
 
Image displaying the Project Earned Value report with Earned Value curves.
 
The following image displays the Earned Value Detail table.
 
Image displaying the Earned Value Detail table.
 
 
Report Prerequisites
 
Verify that you have completed the following prerequisites before you run this report:
  • There must be at least one earned value reporting period that is created (
    Administration/Earned Value Management-Period Definitions
    ). The earned value reporting period must have a status of active. The report supports earned value reporting periods set up with a scale of weekly, monthly, quarterly, or annually. The periods that are displayed in the report depend on the earned value reporting period that is associated with the project.
  • The project must have an earned value reporting period that is associated for the project to display in the report. It must also have an earned value calculation method that is selected for earned value to calculate for the project. Both of these fields are in the earned value section of the settings properties on the project. 
    Clarity PPM
     also has an earned value calculation method field on the task; it is not on the properties by default. Configure the task properties and add the field if you want to manage the calculation method differently for tasks compared to the method that is defined on the project. If a task has a calculation method that is defined, then it is used to calculate earned value of the task. If the task does not have a calculation method that is defined, then the task uses the calculation method of a parent task. If a parent task does not have a calculation method that is defined, then the project calculation method is used for all calculations.
     The calculation methods are described in the 
    Report Fields and Calculations
     section. Calculation of earned value always uses the current revision of the baseline.
  • The project must have a baseline for the following to display or calculate: baseline start date, baseline finish date, planned value, earned value, CPI, SPI, CV, SV, BAC, and VAC.
  • There must be a rate matrix created (
    Administration/Finance-Manage Matrix
    ) and associated as a system default rate matrix (
    Administration/Finance-Setup/Defaults/Project Transaction Entry Defaults
    ) or a project-specific rate matrix for calculation of cost amounts.
  • The project must have team members that are assigned to tasks with estimates to calculate metrics that are included in the report. It must also have assignments to post actuals to the project.
  • The project must have actual hours posted through timesheets, transaction entry, or imported into PPM to calculate actual cost.
  • If the earned value calculation method on the project is a percent complete method, then the project must have % complete entered on the tasks in the work breakdown structure. There is a % complete calculation field in the general section of the settings properties on the project. If this field is set to manual, then the % complete must be manually updated in the work breakdown structure. If this field is set to effort or duration, then the % complete is calculated by running the 
    Update % Complete
     job.
     The 
    Update % Complete
     job is automatically run when running the 
    Update Earned Value History
     or 
    Update Earned Value and Cost Total
    s job, so it is not necessary to run it separately if you are running one of these jobs. 
  • The project per period cost and index amounts in the line charts and table are dependent upon running the 
    Update Earned Value History
     job. This job calculates earned value metrics for a project or group of projects, based on parameters that are selected, and creates earned value snapshots of the data by time period. This data is based on the earned value reporting period set on the project and earned value calculation method set on the project, or tasks. The 
    Update Earned Value History
     invokes and also runs the 
    Update % Complete
     job so it is not necessary to run this job separately. The 
    Update % Complete
     job updates the % complete values whenever you change project or task data that affects the percent complete calculation. This job only updates the % complete values if the % Complete Calculation field is set to effort or duration. This is a field in the general section of the settings properties on the project.
  • The project total cost amounts in the current performance, indexes and cost estimates report sections are dependent upon running the 
    Update Cost Totals
     job or the 
    Update Earned Value and Cost Totals
     job. The 
    Update Cost Totals
     job is available in the Actions pull-down on the task list or baseline list. The 
    Update Cost Totals
     job runs the following items:
    • Runtime extraction of rates (calculates rates that are based on the matrix but does not populate the data mart rate table) 
    •  
      Update % Complete
       job
    • Update Earned Value and Cost Totals job.
      If you want to update costs across several projects instead of updating costs for only one project, run the job from the menu is the same as the job in the Actions pull-down, except it updates all the projects meeting the parameter criteria when run instead of updating only one project.
 
Report Properties
 
The following values list the report properties
:
 
 
Name
: Project Earned Value
 
Resource ID
: CSK_PRJ_EarnedValue
 
Description
: Project Management (PMO Accelerator)
 
Folder
: CA PPM/Reports/Project Management/Project Earned Value
 
Path
: /ca_ppm/reports/project_management/CSK_PRJ_EarnedValue
 
Data Source
: CA PPM Bean Data Source
 
Report Parameter Options
 
The following table lists the report parameter options.
 
Prompt Text
Parameter Name
 
 
Type
 
 
Input Control Name
Input Control Resource ID
 
 
Mandatory
Default Value
 
Project OBS Type
projectOBSTypeKey_1
Single-select
query
Project OBS Type
projectOBSTypeKey_1
No
Project OBS Unit
projectOBSUnitKey_1
Single-select
query
Project OBS Unit
projectOBSUnitKey_1
No
Project Manager
projectManagerKey_1
Multiple-select
query
Project Manager
projectManagerKey_1
No
Project
projectKey_1
Multiple-select
query
Project
projectKey_1
No
Start Date
startDateNotRequired
Single value
date
Start Date
startDateNotRequired
No
End Date
endDateNotRequired
Single value
Date
End Date
endDateNotRequired
No
Show Period Earned Value Numbers?
showPeriodEarnedValueNumbers
Boolean
Not applicable
No
Checked
Include Inactive Projects?
includeInactiveProjects
Boolean
Include Inactive Projects?
includeInactiveProjects
No
Unchecked
Database Schema
ppmDBSchema
Hidden
Not applicable
Yes
Passed through 
Clarity PPM
 
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through 
Clarity PPM
 
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through 
Clarity PPM
 
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through 
Clarity PPM
 
 
Parameter Lookup Values
There are no parameter lookup values for this report.
 
Parameter Explanations
 
The following list describes the parameters:
  • The Project OBS Type is a cascading parameter and determines which units are listed in the Project OBS Unit parameter. This parameter is not used to control which projects display in the report.
  • The Project OBS Unit parameter displays values that are based upon the Project OBS Type selected. When you select an OBS unit in this parameter, the report displays the projects that are attached to the OBS unit and descendants of the unit you select.
  • The Start Date and End Date parameters control which periods display in the charts and detail table. These parameters must be completed for data to display in the charts or detail table. The amounts in the current performance, indexes, and cost estimates sections of the report are project level amounts and do not change based on the date parameters selected.
  • The Show Period Earned Value Numbers parameter controls whether the amounts by period that is displayed in the charts also display in a table below the charts. If the parameter is checked, a table showing earned value amounts by period displays below the charts for each project. If the parameter is not checked, the table does not display.
 
Report Fields and Calculations
 
The report displays the project name, project manager, project ID, status, progress, start date, finish date, baseline start date, baseline finish date in the project information section. The current performance section includes: as of date and the system-calculated amounts of planned value, actual cost, and earned value. The indexes section includes: CPI, SPI, CV, and SV. The cost estimates section includes: BAC, ETC, EAC, and VAC. These amounts can be viewed in PPM on the schedule & performance properties of the project. Programs and templates are excluded.
The report includes two line charts that are used to visualize the trend in project performance over the reporting periods. The S-Curve chart displays planned value, actual cost, and earned value amounts over the earned value reporting periods. The Indexes Curve chart displays CPI and SPI, compared to the Target index, over the same earned value reporting periods.
When the Show Period Earned Value Numbers parameter is checked the report includes a table that displays the planned value, actual cost, earned value, CV, SV, CPI, SPI, and target indexes for each earned value reporting period.
This report contains the following calculations:
  •  
    Planned Value
    . This is the system-calculated value of budgeted cost of work scheduled (BCWS) or the budgeted amount that you can spend on the project in a given time. It is the sum of the BAC through a point in time. This point in time is the project as of date set on the schedule & performance properties of the project. If there is no as of date, then the calculation uses the current date (that is, today). This calculation requires a baseline.
  •  
    Actual Cost
    . This is the system-calculated value of actual cost of worked performed (ACWP) and is based on posted actuals. It is the sum of the actuals on the project through a point in time. This point in time is the project as of date set on the schedule & performance properties of the project. If there is no as of date, then the calculation uses the current date (that is, today). If you have future posted actuals, they arel not be included in this calculation unless you set the "as of date" to a date that is the same as or after the last date of posted actuals.
  •  
    Earned Value
    . This is the system-calculated value of budgeted cost of work performed (BCWP) and represents the amount of budgeted cost (BAC) completed based on performance. Performance is measured using the EV Calculation Method that is selected on the project. This calculation requires a baseline.
    The EV calculation method is set in the earned value section of the settings properties on the project. If you want to manage this at the task level, you can add the EV calculation method field to the task properties and can select a value on the task instead of using the value set on the project. The EV calculation methods are as follows:
    •  
      Percent Complete
      . This method is calculated by the product. At the project level, Earned Value is the sum of Earned Value for all level one tasks. At the task level, Earned Value = BAC * %Complete. Note: Percent Complete is the default method if you do not change it.
    •  
      0/100
      . This method is calculated by the product. If % Complete = 100, then the Earned Value = BAC; else, Earned Value = 0. The % complete field is on the schedule & performance project properties. 
    •  
      50/50
      .
       
      This method is calculated by the product.
      If %Complete = 100, then Earned Value = BAC.
      If %Complete > 0 but < 100 then Earned Value = BAC / 2.
      If %Complete = 0, then BCWP = 0.
      The % complete field is on the schedule & performance project properties.
    •  
      Level of Effort (LOE)
      . This method is calculated by the product. Earned Value = Planned Value.
    •  
      Weighted Milestones
      . This method is not calculated by the product. Use the Earned Value (BCWP) Override field in the earned value section of the settings properties on the project to manually enter the earned value. If you are managing the EV calculation method at the task level, you can also add the (BCWP) Override field to the task and enter the earned value at the task level.
    •  
      Milestone Percent Complete (PC). 
      This method is not calculated by PPM. You must use the Earned Value (BCWP) Override field in the earned value section of the settings properties on the project to manually enter Earned Value.  If you are managing the EV calculation method at the task level, you can also add the (BCWP) Override field to the task and enter it at the task level.
    •  
      Apportioned Effort (AE)
      . This method is not calculated by the product. Use the Earned Value (BCWP) Override field in the earned value section of the settings properties on the project to manually enter the earned value. If you are managing the EV calculation method at the task level, you can also add the (BCWP) Override field to the task and enter the earned value at the task level.
  •  
    CPI
    . This is the system-calculated value of cost performance index (CPI) and is the ration of work that is performed to money spent. A value greater than or equal to one indicates a favorable condition at or under budget. A value of less than one indicates an unfavorable condition of over budget. This calculation requires a baseline.
    Formula:
    Earned Value / Actual Cost (or BCWP / ACWP)
  •  
    SPI
    . This is the system-calculated value of schedule performance index (SPI) and is the ratio of work that is performed to work scheduled. A value greater than or equal to one indicates a favorable condition of work ahead of or on schedule. A value of less than one indicates an unfavorable condition of work behind schedule. This calculation requires a baseline.
    Formula:
    Earned Value / Planned Value (or BCWP / BCWS)
  •  
    CV
    . This is the system-calculated value of cost variance (CV) and is the amount of what has been accomplished compared to what has been spent. This calculation requires a baseline.
    Formula:
    Earned Value - Actual Cost (or BCWP - ACWP)
  •  
    SV
    . This is the system-calculated value of schedule variance (SV) and is amount of work that is performed compared to what is scheduled to date. This calculation requires a baseline.
    Formula:
    Earned Value - Planned Value (or BCWP - BCWS)
  •  
    BAC
    . This is the system-calculated value of baseline at completion, which is the baseline cost at the time of the current baseline revision. It is the sum of all the assignment level actual cost values for the project and the ETC cost, at the time the baseline is recorded. It also includes future posted actual costs. This calculation requires a baseline. 
  •  
    ETC
    . This is the system-calculated value of the estimate cost to complete the project. ETC cost is the total of the remaining labor and non-labor cost to complete the project. 
  •  
    EAC
    . This is the system-calculated value of estimate at completion and is the cost of total effort.
    Formula:
    Actual Cost + ETC (or ACWP + ETC)
  •  
    VAC
    . This is the difference between the estimate at completion (EAC) and the baseline at completion (BAC). This calculation requires a baseline.
    Formula:
    EAC – BAC
 
Report Security and Technical Details
 
Security is determined by project view rights.