Project Performance Metrics Calculation

Project Performance Metrics Calculation

1. Given Data

• Budget at Completion (BAC) = $4000
• Total Project Duration = 4 years (48 months)
• Elapsed Time = 17 months
• Work Completed = 35% (0.35)
• Actual Cost (AC) = $1500

2. Calculations

• Planned Value (PV) = (Planned % Complete) * BAC
• Planned % Complete = 17 / 48
• PV = (17/48) * 4000 = $1416.67
• Earned Value (EV) = (Actual % Complete) * BAC
• EV = 0.35 * 4000 = $1400
• Cost Variance (CV) = EV - AC
• CV = 1400 - 1500 = -$100
• Cost Performance Index (CPI) = EV / AC
• CPI = 1400 / 1500 = 0.933
• Schedule Variance (SV) = EV - PV
• SV = 1400 - 1416.67 = -$16.67
• Schedule Performance Index (SPI) = EV / PV
• SPI = 1400 / 1416.67 = 0.988
• Estimate at Completion (EAC) = BAC / CPI
• EAC = 4000 / 0.933 = $4285.71
• Estimate to Complete (ETC) = EAC - AC
• ETC = 4285.71 - 1500 = $2785.71
• Variance at Completion (VAC) = BAC - EAC
• VAC = 4000 - 4285.71 = -$285.71
• To-Complete Performance Index (TCPI) = (BAC - EV) / (BAC - AC)
• TCPI = (4000 - 1400) / (4000 - 1500) = 0.933

3. Results Table

Metric	Value
BAC	$4000
PV	$1416.67
EV	$1400
AC	$1500
CV	-$100
CPI	0.933
SV	-$16.67
SPI	0.988
EAC	$4285.71
ETC	$2785.71
VAC	-$285.71
TCPI	0.933

4. Summary

The project performance metrics indicate that the project is slightly behind schedule (SPI < 1) and over budget (CPI < 1). The estimated cost at completion (EAC) is projected to be higher than the initial budget (BAC), leading to a negative variance at completion (VAC). If cost efficiency is not improved, the project will exceed its allocated budget.