Industry Use Cases

How to Track Public Works Change Orders Against the Project Budget

The contract value rose after an approved change. The budget report still shows the original commitment. The next review needs both the approved total and the pending exposure.

What to pull

Use Excel budget, commitment and change logs or export them from project controls and finance. Keep project, cost code, change number, status, amount and funding source.

How to check it

Use one budget revision and reporting date. Add approved changes once. Show pending changes separately and flag changes already included in revised commitments.

Select the relevant sheets in Jolene.pro and run this check.

Which cost codes are over budget or at risk from pending changes? Show the status and source rows.

What to do with the result

Give the project manager the approved variance and pending exposure separately so they can review funding and scope with the right owners.

Confirm change approvals and funding authority before updating the official forecast.

Try Jolene.pro ยท Follow Jolene.pro on LinkedIn

Leave a comment