When you need it
Use during delivery to reconcile approved budget, orders, incurred costs and remaining work. Update when scope changes, commitments are revised or new information affects the expected cost of completion.
XLSX /
AI tools and documents for engineering and project management.
Commitment and Cost-to-Complete Forecast
Reconcile budget, commitments, actual cost and remaining work to a supported completion-cost forecast.
How to use this templateThis Excel template contains prepared working sheets and completion notes on a separate sheet. Enter your project data and review the completed workbook before use.
This editable workbook helps you organise project information. Check any included formulas, assumptions and results before use; it does not replace professional review.
The form prepares a separate brief; it does not fill the Word or Excel file.
Read product descriptions in your language. The Word and Excel template files are in English.
Only selected pages are shown. This is not the complete template. The full editable Word or Excel file is supplied with purchase.
Learning
How to use this template
What it helps you decide
The forecast reveals exposure beyond invoices and signed orders. It helps managers distinguish unused commitments from actual remaining needs and explains why expected completion cost differs from the previous forecast.
How to complete it
- Reconcile Approved budget and Current commitment for each Cost package. Distinguish approved order changes, pending exposure and documented cancellations or unused balances.
- Check Actual / accrued values against invoices and received goods or services. Remove duplicate coverage where an accrual and invoice relate to the same work.
- Define Remaining scope and Cost-to-complete basis using supported quantities and rates. Explain Completion forecast changes through Movement explanation, keeping cost separate from cash timing.
Who prepares and reviews it
The cost controller prepares it with procurement, quantity surveyors, package managers and finance. A reviewer checks actuals and accruals; the project manager or delegated financial authority decides corrective action and budget changes.
A mistake to avoid
Adding the entire unused commitment to actual costs and then pricing the same remaining work again overstates the forecast and hides uncommitted scope elsewhere.
Illustrative example
Illustrative example: a mechanical package has a large unused order balance, but several uncommitted tie-ins remain outside the order. The forecast records both conditions and reconciles received-but-unbilled work. The manager reviews the supported completion estimate rather than assuming the remaining order value covers every outstanding activity.
Document contents
- Document control and decision owner
- Evidence, scope and applicability
- Commitment reconciliation
- Actual and accrued cost
- Remaining scope forecast
- Forecast bridge
- Open points, competent review and decision
Required inputs
- Project / asset identity, assessment date, scope and authorized decision owner
- Verified source documents with exact revision and record locators
- Current approved budget and scope breakdown
- Purchase orders and contracts with changes
- Actual costs and accruals
- Remaining quantities, forecasts and pending changes
Practical tools.
Professional judgment.
Confirm the adopted edition, local amendments, National Annex where relevant, and contract requirements.
Prepare project brief