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.

| Measure | Sample result |
|---|---|
| Updated budget | 223,440 |
| Completion forecast | 323,712 |
| Budget risk | 100,272 |
How do you start with your own data?
- Set package budget, opening spend, open commitments and planned value.
- Log new spend, earned value, remaining work estimates and approved scope increases by date.
- Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
- 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ç