You are assigned to a project with an initial budget of $200,000 USD. Midway through the project, you review the schedule and costs. Based on your review, You should have spent $50,000 to date based on your initial plans and 100 days activities that were based on the schedule.

You have actually spent $60,000 to date and completed activities for 110 days of the scheduled baseline, which should have cost $45,000 based on your initial plans. Budget required for the remaining work to be completed is estimated at $150,000.

Answer the following

PV (Planned Value) =
AC (Actual Cost) =
EV (Earned Value)=
ETC (Estimate to Complete) =
CPI =
SPI =
CV =
SV =
VAC (Variance at Completion) =
EAC (Estimate at Completion) =
TCPI =

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

hi there,

do u need ? ?

thx