1.

Bid winner contractor has prepared schedule based on its agreement with Employer to complete the
substructure work of G+3 residential building in 45 working days. The contractor has measured the actual
executed work at the end of 20th working days and has put its plan and actual work together with actual cost as
shown in the table below. Using EVM solve the questions (problems) 1.1 to 1.3.

Description of

Contract Unit
of

executed work
Quantity up to

Quantity up to

Amount up to

Amount up to

including 10%
Actual cost of
activities

working day

working day

working day

working day
end of 20th

end of 20th

end of 20th

end of 20th
Quantity
Contract

Executed

Executed
Symbol
activity

Contract
Planned

Planned
Amount

profit
price
Unit
A Bulk excavation M3 140 240 140 140 33,200.0
0
B Trench excavation M3 90 240 90 90 22,000.0
0
C Pit excavation M3 45 240 45 45 11,000.0
0
D Trench masonry M3 63 210 63 32 67,500.0
0 0
E Back fill work around M3 32 320 32 32 10,240.
pit 00
F Back fill work at trench M3 42 320 42 0 0
masonry
G Back fill work under M3 96 320 48 0 0
hard core
H Concreting to footing M3 3.6 320 3.6 3.6 11,200.
pad 0 00
I Concreting to M3 2 320 2 2 7,600.
foundation column 0 00
J Concreting to grade M3 4 320 0 0 0
beam 0
K Concreting to ground M2 30 480 0 0 0
floor slab
L Hard coring M3 30 310 0 0 0
Total Amount in Birr 162,740.0
0
Questions (Problems):
1.1 Evaluate to date time performance of the substructure work
1.2 Evaluate cost performance of the substructure work
1.3 What will be the estimate at completion, assuming that same trend continues?
Formulas to remind you:
BCWS = Budgeted cost of work scheduled (Planned) SPI = Schedule performance index = BCWP/BCWS
BCWP = Budgeted cost of work performed (Earned) CPI = Cost performance index = BCWP/ACWP
ACWP = Actual cost of work performed (Actual) BAC = Budget at completion = Project contract value
SV = Schedule variance = BCWP - BCWS ETC = Estimate to completion = (BAC-BCWP)/CPI
CV = Cost variance = BCWP - ACWP EAC = Estimate at completion = ACWP + ETC
 Answer:
Symb Description of

Unit

Executed Quantity

Executed Amount
Planned Quantity

Contract Amount

Planned Amount
up to end of 20th

up to end of 20th

up to end of 20th

up to end of 20th
ol activities

executed work
including 10%
Actual cost of
given

working day

working day

working day

working day
Quantity
Contract

Contract
to
activi
price
Unit

ty
A Bulk excavation M 140 240 140 140 33,600.00 33,600.0 33,600. 33,200.
3 0 00 00

B Trench excavation M 90 240 90 90 21,600.00 21,600.0 21,600. 22,000.

3 0 00 00

C Pit excavation M 45 240 45 45 10,800.00 10,800.0 10,800. 11,000.

3 0 00 00

D Trench masonry M 63 210 63 32 132,300.00 132,300. 67,200. 67,500.

3 0 00 00 00

E Back fill work around M 32 320 32 32 10,240.00 10,240.0 10,240. 10,240.

pit 3 0 00 00

F Back fill work at M 42 320 42 0 13,440.00 13,440.0 - 0

trench masonry 3 0

G Back fill work under M 96 320 48 0 30,720.00 15,360.0 0

hard core 3 0 -

H Concreting to footing M 3.6 320 3.6 3.6 11,520.00 11,520.0 11,520. 11,200.
pad 3 0 0 00 00

I Concreting to M 2 320 2 2 6,400.00 6,400.0 6,400. 7,600.

foundation column 3 0 0 00 00

J Concreting to grade M 4 320 0 0 12,800.00 - 0

beam 3 0 -

K Concreting to ground M 30 480 0 0 14,400.00 - 0

floor slab 2 -

L Hard coring M 30 310 0 0 9,300.00 - 0

3
 -

Total Amount in Birr 307,120. 255,260. 161,360. 162,740.

00 00 00 00

1.1. SV = Schedule variance = BCWP - BCWS = 161,360.00 - 255,260.00 = - 93,900.00 Birr

SPI = Schedule performance index = BCWP/BCWS = 161,360.00 /255,260.00 = 0.632 = 63.2%.
 Therefore, time performance is not satisfactory.
1.2. CV = Cost variance = BCWP - ACWP = 161,360.00 - 162,740.00 = -1,380.00
CPI = Cost performance index = BCWP/ACWP = 161,360.00/162,740.00 = 0.992 = 99.2%
 Therefore, Cost performance is satisfactory or almost on budget.
1.3. ETC = Estimate to completion = (BAC-BCWP)/CPI = (307,120.00 - 161,360.00)/0.992 = 148,120.45
EAC = Estimate at completion = ACWP + ETC = 162,740.00 + 148,120.45 = 310,860.45