Total budget
$119,000
Spent to date
$66,340
Cost performance (CPI)
0.9
Project Budget Tracker
Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.
7 free project cost tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 7 spreadsheets from Project Planning, Construction Project Management and Investment Tracking. Start with Project Budget Tracker, Earned Value Management Tracker and Crew Timesheet by Cost Code: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Total budget
$119,000
Spent to date
$66,340
Cost performance (CPI)
0.9
Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.
Budget at completion
$820,000
Earned value
$409,350
Project CPI
0.9
PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.
Hours this period
97.5
Overtime share
10%
Labour cost
$5,247
Daily crew hours by worker and cost code with regular and overtime pay, labour burden, and hours against budget for every code.
On hire now
3
Hire cost to date
$6,374
Long hires to review
1
Owned and hired equipment by site with hire days and cost (stopping at off-hire), long-hire reviews, service due dates for owned kit, and totals by site.
Portfolio budget
$3,305,000
Spent to date
$2,027,500
Portfolio CPI
1
Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.
Forward annual income
$1,439
Per month
$120
Portfolio yield
2%
Forward annual income, yield and yield on cost per holding, plus every payment logged by month.
Open RFIs
4
Overdue responses
2
Average days to answer
10.3
Track every request for information from question to answer, with due dates and cost and schedule impact.