Answer:
The computations are shown below:
Explanation:
The computations are as follows
The planned value is the value which is to be considered while following the work schedule i.e $50,000
The actual cost is the actual spending amount i.e $60,000
The earned value is the value which s to be considered while performing the work i.e $45,000
Now
Cost performance index (CPI) is the ratio of earned value to actual cost
CPI = Earned value ÷ Actual cost
= $45,000 ÷ $60,000
= 0.75 × 100
= 75%
Schedule performance index is the ratio of earned value to planned value
SPI = Earned value ÷ Planned value
= $45,000 ÷ $50,000
= 0.9 × 100
= 90%
Cost variance is the earned value minus the actual cost.
In mathematically,
CV = Earned value - actual value
= $45,000 - $60,000
= - $15,000
The Schedule variance is the earned value minus the planned value.
SV = Earned value - planned value
= $45,000 - $50,000
= -$5,000
Now the EAC (Estimate at Completion) is
= Initial project amount ÷ CPI
= $200,000 ÷ 75%
= $266,666.67
The VAC (Variance at Completion) is
= Initial cost - EAC
= $200,000 - $266,666.67
= -$66,666.67
And, the ETC is
= EAC - actual cost
= $266,666.67 - $60,000
= $206,666.67
