Use the earned value table to determine the estimated cost to completion given the indicated state of the project. $\begin{array}{|l|l|l|l|l|l|l|l|l|l|}
\hline \text { Activity } & 5 & 10 & 15 & 20 & 25 & 30 & 35 & \text { Plan } & \% \text { Complete } \
\hline \text { A } & 850 & 350 & & & & & & 1,200 & 100 \% \
\hline \text { B } & & 400 & 125 & & & & & 525 & 100 \% \
\hline \text {C} & & & 1,275 & 650 & & & & 1,925 & 100 \% \
\hline \text {D} & & & & 2800 & 4,500 & 350 & & 7,650 & 95 \% \
\hline \text {E} & & & & & 680 & 400 & & 1,080 & 75 \% \
\hline \text {F} & & & & & & 125 & 875 & 1,000 & 80 \% \
\hline \text {G } & & & & & & 300 & 1200 & 1,500 & 45 \% \
\hline \text { Monthly Plan } & 850 & 750 & 1,400 & 3,450 & 5,180 & 1,175 & 2,075 & 14,880 & \
\hline \text { Monthly Act } & 900 & 650 & 1,350 & 3,875&4,780 & 850 & 2,000 & & \
\hline
\end{array}$

A)$15,966
B)$16,173
C)$18,164
D)$17,441

Question

Use the earned value table to determine the estimated cost to completion given the indicated state of the project. $\begin{array}{|l|l|l|l|l|l|l|l|l|l|}
\hline \text { Activity } & 5 & 10 & 15 & 20 & 25 & 30 & 35 & \text { Plan } & \% \text { Complete } \
\hline \text { A } & 850 & 350 & & & & & & 1,200 & 100 \% \
\hline \text { B } & & 400 & 125 & & & & & 525 & 100 \% \
\hline \text {C} & & & 1,275 & 650 & & & & 1,925 & 100 \% \
\hline \text {D} & & & & 2800 & 4,500 & 350 & & 7,650 & 95 \% \
\hline \text {E} & & & & & 680 & 400 & & 1,080 & 75 \% \
\hline \text {F} & & & & & & 125 & 875 & 1,000 & 80 \% \
\hline \text {G } & & & & & & 300 & 1200 & 1,500 & 45 \% \
\hline \text { Monthly Plan } & 850 & 750 & 1,400 & 3,450 & 5,180 & 1,175 & 2,075 & 14,880 & \ 
\hline \text { Monthly Act } & 900 & 650 & 1,350 & 3,875&4,780 & 850 & 2,000 & & \
\hline
\end{array}$

A)$15,966
B)$16,173
C)$18,164
D)$17,441

Quizplus · Accepted Answer

In the earned value table, the budget at completion (BAC) is $27,000. The actual cost (AC) of the project so far is $10,827. The earned value (EV) is $9,000, which is the budgeted cost of the work that has been completed so far. 
Using the formula EAC = BAC/ CPI, we can determine the estimated cost to complete the project. The CPI (cost performance index) is calculated as EV/ AC, which gives us a value of 0.83. 
Thus, EAC = 27,000/0.83 = $32,530. 
To determine the estimated cost to completion, we subtract the AC from the EAC: 
$32,530 - $10,827 = $21,703. 
Therefore, the best choice is B, which is closest to the estimated cost to completion.

Use the Earned Value Table to Determine the Estimated Cost