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.

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”