Change Orders to Contract metric

Determines the percentage of a contract that is composed of change orders. In addition, related data shows the effect that potential change orders might contribute as a percentage of contract.

Details of the metric Description
Name Change Orders to Contract
Category Financial
Analysis objective When change orders make up a large percent of the overall contract, project managers need to determine why and act, especially if it is trending upward.
Description Identifies how much of a project’s budget is composed of change orders, as a percent of the original contract.
Source Customer Focus Group
Measurement Total Contract Change Order Amount / Contract Original Commitment
Dependent data that is calculated
  • Total Contract Change Order Amount = Sum of the “Change Amount” on each change order per contract
  • Contract Original Commitment = On the Contract General page, Summary section, A. Original Commitment amount.
Roles
  • PR Manager
  • PR Executive
Display chart types Score-based: Horizontal Stacked Bar Chart
Thresholds
  • Low Threshold: .1 (10%)
  • High Threshold: .2 (20%)
  • Range 1: Good/Positive/Green
  • Range 2: Under Performing/Caution/Yellow
  • Range 3: Poor/Negative/Red
Fact details Module: triMetricFact

Business Object: triCapitalProjectContractFact

Metric Queries: triCapitalProjectContractFact – Metric – Change Order to Contract (Score)

Drill paths
  • Program
  • Project
  • Vendor
  • Capture Period
Interactive filters
  • Geography
  • Organization
  • Vendor
Static filters Active projects
Time Months
Data point refresh rate Monthly