Project Plan with Gantt Timeline
A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.
SpreadsheetProject PlanningFree
PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.
Shown with sample data
PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.
Latest: $409,400
Earned value management answers the two questions sponsors care about: are we getting the work we paid for, and what will this cost at the end? Enter each work package’s budget, baseline dates, percent complete and actual cost; the tracker calculates planned value at the status date, earned value, variances, CPI and SPI, and forecasts EAC, ETC and VAC, with a monthly trend for the S-curve.
Planned value (PV) is the budgeted cost of work scheduled to date. Earned value (EV) is the budgeted cost of work actually completed. Actual cost (AC) is what that work really cost.
CPI = EV ÷ AC and SPI = EV ÷ PV. A CPI of 0.90 means you get 90 cents of work for every dollar spent; an SPI of 0.80 means you have done 80% of the work planned by now.
Estimate at completion is the forecast final cost. This tracker uses EAC = BAC ÷ CPI, which assumes current cost performance continues. Other formulas include AC + (BAC − EV) for one-off variances.
ETC (estimate to complete) = EAC − AC, the money still needed. VAC (variance at completion) = BAC − EAC; negative means an overrun. TCPI is the cost efficiency needed on the remaining work to finish on budget.
Download a copy
Downloads need a free account.