Skip to main content

EVA numerical with bar schedule (A to F)

Short answer

PV = Rs 25,500; EV = Rs 23,800; AC = Rs 25,500. CV = SV = −Rs 1,700, CPI = SPI = 0.93, EAC ≈ Rs 48,214. The project is over budget and behind schedule by work worth Rs 1,700; if trend continues, final cost will be about Rs 48,214, requiring corrective action.

Perform EVA and comment on the performance for the given project.

ActivityCost (Rs.)Planned days (of 1 to 7)
A50001-2
B100002-5
C150005-6
D70006-7
E60005-6
F20006-7

[Figure: bar chart with shaded cells showing the planned days of each activity, as in the table; read from the scan, may be off by a day.]

The progress was monitored and recorded at the end of 5th day.

Activity% CompletedExpenditure (Rs)
A1005000
B809000
C608000
D0X
E303500
F0X

Assumptions: the cost of each activity is spread uniformly over its planned (shaded) days, from day 1 to day 7. The review is at the end of day 5. Activities D and F have not started, so their actual cost ("X") is taken as zero.

Planned value (PV) at end of day 5

ActivityCost (Rs)Planned daysDays done by day 5PV (Rs)
A5,0001-2 (2 days)2 of 25,000
B10,0002-5 (4 days)4 of 410,000
C15,0005-6 (2 days)1 of 27,500
D7,0006-700
E6,0005-6 (2 days)1 of 23,000
F2,0006-700
Total45,00025,500

Earned value (EV) = % complete × budget

Activity% doneBudgetEV (Rs)AC (Rs)
A1005,0005,0005,000
B8010,0008,0009,000
C6015,0009,0008,000
E306,0001,8003,500
Total23,80025,500

BAC = 5,000 + 10,000 + 15,000 + 7,000 + 6,000 + 2,000 = Rs 45,000.

Variances and indices

CV=EV−AC=23,800−25,500=−1,700SV=EV−PV=23,800−25,500=−1,700CPI=EV/AC=23,800/25,500=0.933SPI=EV/PV=23,800/25,500=0.933EAC=BAC/CPI=45,000/0.9333=48,214VAC=BAC−EAC=−3,214\begin{aligned} CV &= EV - AC = 23{,}800 - 25{,}500 = -1{,}700 \\ SV &= EV - PV = 23{,}800 - 25{,}500 = -1{,}700 \\ CPI &= EV/AC = 23{,}800/25{,}500 = 0.933 \\ SPI &= EV/PV = 23{,}800/25{,}500 = 0.933 \\ EAC &= BAC/CPI = 45{,}000/0.9333 = 48{,}214 \\ VAC &= BAC - EAC = -3{,}214 \end{aligned}

Answer: PV = Rs 25,500; EV = Rs 23,800; AC = Rs 25,500; CV = −Rs 1,700; SV = −Rs 1,700; CPI = SPI = 0.93.

Comment: The project is over budget by Rs 1,700 and behind schedule by work worth Rs 1,700 (about 7%). Activity E is the main problem (30% done but 58% of its budget spent); B is also overspent. If the same trend continues, the final cost will be about Rs 48,214, i.e. Rs 3,214 above the budget. Corrective action is needed: speed up activities B, C and E, control the cost of E, and re-plan D and F.

✓ Answer checked by Claude Opus 5.5 (high effort)

Related questions

All Construction Management chapter 7 questions →