Calculator inputs
Plotly graph
This chart compares planned, earned, actual, and forecast values to highlight control gaps quickly.
Example data table
| Item | Example value | Interpretation |
|---|---|---|
| BAC | $120,000.00 | Total approved project budget. |
| PV | $60,000.00 | Planned value by the review date. |
| EV | $54,000.00 | Value of work actually earned. |
| AC | $58,000.00 | Actual money spent to date. |
| CPI | 0.931 | Cost efficiency is below target. |
| SPI | 0.900 | Schedule performance is behind plan. |
| EAC | $136,765.43 | Composite forecasted final cost. |
| Delay | 20.00 days | Estimated finish slips without correction. |
Formula used
- CV = EV - AC
- SV = EV - PV
- CPI = EV / AC
- SPI = EV / PV
- Earned progress % = (EV / BAC) × 100
- Planned progress % = (PV / BAC) × 100
- Time progress % = (Elapsed Duration / Planned Duration) × 100
- Burn rate = AC / Elapsed Duration
- TCPI on BAC = (BAC - EV) / (BAC - AC)
- EAC, CPI based = BAC / CPI
- EAC, atypical work = AC + (BAC - EV)
- EAC, composite = AC + (BAC - EV) / (CPI × SPI)
- ETC = EAC - AC
- VAC = BAC - EAC
- Estimated total duration = Planned Duration / SPI
- Schedule delay = Estimated Total Duration - Planned Duration
- Risk adjusted EAC = EAC × (1 + Risk Reserve % / 100)
How to use this calculator
- Enter the project name and choose the reporting currency.
- Provide BAC, PV, EV, and AC from your latest reporting cycle.
- Enter planned duration, elapsed duration, and physical progress for a broader performance view.
- Select the forecast method that best matches your control approach, then add manual ETC only when needed.
- Submit the form to view ratios, forecasted cost, duration risk, the comparison chart, and downloadable summaries.
FAQs
1) What does this calculator measure?
It evaluates project health using earned value management. You can compare budget, progress, schedule, forecasted finish cost, and expected delay in one place.
2) Why are CPI and SPI important?
CPI shows cost efficiency, while SPI shows schedule efficiency. Values above 1.00 are generally favorable, and values below 1.00 signal attention is needed.
3) Which forecast method should I choose?
Use CPI based when current cost efficiency is likely to continue. Use atypical work when remaining work differs. Use composite when both cost and schedule performance will influence the finish.
4) What is BAC?
BAC means Budget at Completion. It is the total approved budget for the entire project baseline and anchors most earned value comparisons.
5) Why compare physical progress with earned progress?
Physical progress checks whether earned value credit reflects real field progress. A large gap can suggest scoring rules, reporting timing, or progress measurements need review.
6) What does negative VAC mean?
Negative VAC means forecasted final cost is above the approved budget. The larger the negative value, the larger the expected overrun at completion.
7) Why include a risk reserve percentage?
Risk reserve creates a more cautious forecast. It helps teams understand how known uncertainty could affect the likely completion cost after baseline performance is considered.
8) Can this calculator estimate schedule delay?
Yes. It uses SPI to estimate total duration, then compares that estimate with the planned duration. It is a useful directional signal, not a full critical-path analysis.