ExcelFlux
← Construction and contracting

Project Portfolio and Cost at Completion

Track updated budgets, spend, remaining work and cost at completion across multiple work packages.

Premium workbook preview · Member downloads are not yet available

Results from the sample workbook

Updated budget
223,440
Completion forecast
323,712
Budget risk
100,272

Who can use it, and for what?

Project offices, construction and cost control

Identify packages forecast to exceed budget by completion, even when spend is still below it today.

A worked example from the workbook

K-001 has actual spend of 158,000 and an updated budget of 223,440. The completion forecast of 323,712 leaves a modelled budget risk of 100,272.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
Updated budget223,440
Completion forecast323,712
Budget risk100,272

How do you start with your own data?

  1. Set package budget, opening spend, open commitments and planned value.
  2. Log new spend, earned value, remaining work estimates and approved scope increases by date.
  3. Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
  4. Review per-record calculations on Analiz and totals and selected cards such as K-001 on Panel. Resolve unmatched codes, missing dates and duplicate records on Kontrol.

Test a different scenario

Raise Ayarlar B9 from 1.12 to 1.20. K-001’s completion forecast rises from 323,712 to 333,120 and its budget risk rises to 109,680. Keep K-001 selected on Panel and compare the result. Restore the original input when you finish.

Hücre adresleri ve formüller için Türkçe kılavuzu aç