Cost-to-Complete Review
Workflow purpose
Build an accurate, transparent cost-to-complete at any point in the project. Trigger remediation when CTC deviates from plan.
Trigger conditions
- Explicit: "run CTC", "cost-to-complete refresh", "pressure-test the remaining budget".
- Implicit:
workflows/draw_package_review finds CTC drift; workflows/change_order_review produces material cost delta; milestone slippage from schedule.
- Recurring: monthly per active project; re-run when a CO is reviewed.
Inputs (required / optional)
| Input |
Type |
Required |
Notes |
| Cost-to-date |
record |
required |
from draw or GL |
| Approved COs |
table |
required |
|
| Pending COs |
table |
required |
scenario view |
| Remaining scope |
table |
required |
assemblies, percent complete |
| Schedule update |
record |
required |
for duration-based escalation |
| Prior CTC |
record |
required |
for delta |
| Estimator baseline |
estimate |
required |
|
Outputs
| Output |
Type |
Shape |
| CTC refresh |
kpi_review |
per trade, per project |
| Driver decomposition |
table |
labor / material / scope / duration |
| Contingency posture |
kpi_review |
remaining vs. plan |
| Scenario set |
table |
base / upside / downside |
| Recommendation memo |
memo |
remediation and approval path |
Required context
Asset_class, segment, form_factor, market, project.
Process
- Inherit cost to date. From most recent draw or GL.
- Compute remaining cost. Remaining scope x unit costs from library; market-adjust via labor/material references; apply escalation per overlay to expected execution dates per schedule.
- Apply contingency. Remaining scope contingency per overlay.
- Delta vs. prior CTC. Attribute to labor, material, scope, duration, CO.
- Scenario set. Base, upside (favorable buyouts, scope value engineering), downside (labor shortage, material spike, additional COs).
- Recommendation. If CTC within overlay, monitor. If above threshold, recommend remediation: re-estimate, scope trim, re-bid, contingency pull. Any budget reallocation above threshold opens approval.
- Confidence banner. References surfaced.
Metrics used
cost_to_complete, contingency_remaining, contingency_burn_rate, change_orders_pct_of_contract, schedule_variance_days.
Reference files used
reference/normalized/capex_line_items__{scope}.csvreference/normalized/labor_rates__{market}.csvreference/normalized/material_costs__{region}_residential.csvreference/derived/contingency_assumptions__{org}.csvreference/normalized/construction_duration_assumptions__{region}.csvreference/normalized/approval_threshold_defaults.csv
Escalation points
- CTC variance above overlay threshold: CM -> AM -> executive.
- Contingency exhaustion risk: CM + AM approval request per overlay.
- Budget reallocation above threshold: approval row per overlay.
Required approvals
- Budget reallocation above threshold.
Failure modes
- CTC without escalation. Fix: overlay escalator applied by execution date.
- CTC without scenario set. Fix: scenario set mandatory.
- Silent contingency pull. Fix: contingency posture explicit.
- Ignoring pending COs. Fix: scenario view includes pending.
- Sample library used as authoritative. Fix: confidence banner surfaces status.
Edge cases
- Late-stage value engineering: scope trim may offset CTC drift; document VE basis.
- Trade buyout mid-project: favorable or unfavorable buyout feeds CTC;
trade_buyout_variance referenced.
- Force-majeure delay: duration escalation significant; surface clearly.
- Multiple stacked COs: aggregate effect on CTC; stacked approval path.
Example invocations
- "Run the April CTC for Willow Creek."
- "Pressure-test CTC on the South End renovation."
- "Compare CTC to underwriting baseline for Riverbend."
Example outputs
Output — CTC refresh (abridged, Willow Creek April)
Cost to date. Inherited.
Remaining cost. Market-adjusted, escalated.
Contingency. Applied per overlay; remaining within band.
Delta vs. prior CTC. Attributed: material drift on two line items; labor hours above baseline on one.
Scenario set. Base within overlay. Downside approaches contingency exhaustion if labor shortage persists.
Recommendation. Monitor; re-estimate two line items at next draw; no reallocation needed.
Confidence banner. capex_line_items@2026-03-31 (starter), labor_rates__charlotte@2026-03-31 (sample), material_costs__southeast_residential@2026-03-31 (sample).
1---2name: cost-to-complete-review3description: Recomputes cost-to-complete from current actuals plus remaining scope plus overlay-derived escalation and contingency. Compares against prior CTC and the underwriting baseline. Identifies the driver (labor, material, scope, duration) and recommends remediation (re-estimate, scope trim, re-bid, contingency pull).4---56# Cost-to-Complete Review78## Workflow purpose910Build an accurate, transparent cost-to-complete at any point in the project. Trigger remediation when CTC deviates from plan.1112## Trigger conditions1314- **Explicit:** "run CTC", "cost-to-complete refresh", "pressure-test the remaining budget".15- **Implicit:** `workflows/draw_package_review` finds CTC drift; `workflows/change_order_review` produces material cost delta; milestone slippage from schedule.16- **Recurring:** monthly per active project; re-run when a CO is reviewed.1718## Inputs (required / optional)1920| Input | Type | Required | Notes |21|---|---|---|---|22| Cost-to-date | record | required | from draw or GL |23| Approved COs | table | required | |24| Pending COs | table | required | scenario view |25| Remaining scope | table | required | assemblies, percent complete |26| Schedule update | record | required | for duration-based escalation |27| Prior CTC | record | required | for delta |28| Estimator baseline | estimate | required | |2930## Outputs3132| Output | Type | Shape |33|---|---|---|34| CTC refresh | `kpi_review` | per trade, per project |35| Driver decomposition | table | labor / material / scope / duration |36| Contingency posture | `kpi_review` | remaining vs. plan |37| Scenario set | table | base / upside / downside |38| Recommendation memo | `memo` | remediation and approval path |3940## Required context4142Asset_class, segment, form_factor, market, project.4344## Process45461. **Inherit cost to date.** From most recent draw or GL.472. **Compute remaining cost.** Remaining scope x unit costs from library; market-adjust via labor/material references; apply escalation per overlay to expected execution dates per schedule.483. **Apply contingency.** Remaining scope contingency per overlay.494. **Delta vs. prior CTC.** Attribute to labor, material, scope, duration, CO.505. **Scenario set.** Base, upside (favorable buyouts, scope value engineering), downside (labor shortage, material spike, additional COs).516. **Recommendation.** If CTC within overlay, monitor. If above threshold, recommend remediation: re-estimate, scope trim, re-bid, contingency pull. Any budget reallocation above threshold opens approval.527. **Confidence banner.** References surfaced.5354## Metrics used5556`cost_to_complete`, `contingency_remaining`, `contingency_burn_rate`, `change_orders_pct_of_contract`, `schedule_variance_days`.5758## Reference files used5960- `reference/normalized/capex_line_items__{scope}.csv`61- `reference/normalized/labor_rates__{market}.csv`62- `reference/normalized/material_costs__{region}_residential.csv`63- `reference/derived/contingency_assumptions__{org}.csv`64- `reference/normalized/construction_duration_assumptions__{region}.csv`65- `reference/normalized/approval_threshold_defaults.csv`6667## Escalation points6869- CTC variance above overlay threshold: CM -> AM -> executive.70- Contingency exhaustion risk: CM + AM approval request per overlay.71- Budget reallocation above threshold: approval row per overlay.7273## Required approvals7475- Budget reallocation above threshold.7677## Failure modes78791. CTC without escalation. Fix: overlay escalator applied by execution date.802. CTC without scenario set. Fix: scenario set mandatory.813. Silent contingency pull. Fix: contingency posture explicit.824. Ignoring pending COs. Fix: scenario view includes pending.835. Sample library used as authoritative. Fix: confidence banner surfaces status.8485## Edge cases8687- **Late-stage value engineering:** scope trim may offset CTC drift; document VE basis.88- **Trade buyout mid-project:** favorable or unfavorable buyout feeds CTC; `trade_buyout_variance` referenced.89- **Force-majeure delay:** duration escalation significant; surface clearly.90- **Multiple stacked COs:** aggregate effect on CTC; stacked approval path.9192## Example invocations93941. "Run the April CTC for Willow Creek."952. "Pressure-test CTC on the South End renovation."963. "Compare CTC to underwriting baseline for Riverbend."9798## Example outputs99100### Output — CTC refresh (abridged, Willow Creek April)101102**Cost to date.** Inherited.103104**Remaining cost.** Market-adjusted, escalated.105106**Contingency.** Applied per overlay; remaining within band.107108**Delta vs. prior CTC.** Attributed: material drift on two line items; labor hours above baseline on one.109110**Scenario set.** Base within overlay. Downside approaches contingency exhaustion if labor shortage persists.111112**Recommendation.** Monitor; re-estimate two line items at next draw; no reallocation needed.113114**Confidence banner.** `capex_line_items@2026-03-31 (starter)`, `labor_rates__charlotte@2026-03-31 (sample)`, `material_costs__southeast_residential@2026-03-31 (sample)`.
mariourquia