Projects Metrics Report
Capital Projects / Projects
Projects Metrics Report
From the Monitor Process, you can access the Projects Metrics report. This report includes the following project metrics.
|
Metric |
Description |
|---|---|
|
Cost Variance |
Budgeted Cost of Work Performed - Actual Cost of Work Performed |
|
Schedule Variance |
Budgeted Cost of Work Performed - Budgeted Cost for Work Scheduled |
|
Budget Remaining |
Total Budget - Actual Cost of Work Performed |
|
Budgeted Cost of Work Remaining |
Total Budget - Budgeted Cost of Work Performed |
|
Cost Performance Index |
Budgeted Cost of Work Performed/Actual Cost of Work Performed; >1 indicates costs are under budget; <1 indicates costs are over budget |
|
Schedule Performance Index |
Budgeted Cost of Work Performed/Budgeted Cost for Work Scheduled; >1 indicates ahead of schedule; <1 indicates behind schedule |
|
% Complete by Budget |
100 * (Budgeted Cost of Work Performed/Total Budget) |
|
% Budget Spent |
100 * (Actual Cost of Work Performed/Total Budget) |
|
Owner Changes |
Total actual costs for all change order actions initiated by the owner. |
|
Vendor Changes |
Total actual costs for all change order actions initiated by the vendor. |
Calculations
The following table shows the calculations used for the above metrics. The calculations use design and actual costs entered for action items.
- You enter design costs for action items during the planning or design phase. See Estimate Design Costs.
- You enter actual costs for action items during the project's execution phase. See Updating Actions.
| Metric | Calculation |
|---|---|
|
Budgeted Cost of Work Performed |
Sum of (activity_log.cost_est_design_cap + activity_log.cost_est_design_exp) for all activity_log records in this project where the status is Completed/-Verified/Closed. |
|
Actual Cost of Work Performed |
Sum of (activity_log.cost_act_cap + activity_log.cost_actual ) for all activity_log records in this project where the status is Completed/-Verified/Closed |
|
Budgeted Cost for Work Scheduled |
Sum of (activity_log.cost_est_design_cap + activity_log.cost_est_design_exp) for all activity_log records in this project where the status is Planned/Scheduled/In Progress. |
|
Total Budget |
Sum of (activity_log.cost_est_design_cap + activity_log.cost_est_design_exp) for all activity_log records in this project |
|
Total actual costs for all change order actions initiated by the owner |
Sum of (activity_log.cost_act_cap + activity_log.cost_actual) for all activity_log records in this project where the activity_type is “CHANGE ORDER” and the request type is “Owner” |
|
Total actual costs for all change order actions initiated by the vendor |
Sum of (activity_log.cost_act_cap + activity_log.cost_actual) for all activity_log records in this project where the activity_type is “CHANGE ORDER” and the request type is “Vendor” |
