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” |