Question

Question 1: The following data and table illustrate a small project: Activity A was completed on schedule • Activity B started as planned but it is expected to take four weeks more Activity C started as planned but finished one week later • %age of completion of activity D is 60% ACWP at the end of week 10 = SR 90400 Activity Original Planned Start Time Original Planned Finish Time Wage Complete Amount Completed BCWP Amount Scheduled BCWS Amount Spent ACWP 100 41.6666 100 Original Planned Cost BAC 50000 12000 16000 24000 12000 21000 20000 60 0 0 SUM 90400 Calculate: 1. BCWP and BCWS of the project. 2. CV, SV, BAC, EAC, ETC, SPI, CPI, variance from original budget. 3. Comment in the progress of the project. 4. Draw Gantt chart 5. Cumulative project cost/month

Answer 1

Solution:

% age of completion of activity “A” = 100%

Projected duration of activity “B” = 8 + 4 = 12 weeks

% age of completion of activity “B” = 5/12 = 41.6666%

% age of completion of activity “C” = 100%

1. BCWS₁₀ = A + C + 5/8*B + 5/6*D = 50000 + 16000 + 5/8*12000 + 5/6*24000 = SR 93500

[Note: 5/8 & 5/6 represent ratio off completion of activities B&D with respect to scheduled duration]

BCWP₁₀ = A + C + 0.4167*12000 + 0.60*24000 = SR 85400

[Note: 0.4167 & 0.6 represent ratio of completion of activities B&D with respect to actual completion duration]

2. CV = BCWP – ACWP = 85400 – 90400 = SR -5000 (Over Budget)

SV = BCWP – BCWS = 85400 – 93500 = SR -8100 (Behind Schedule)

BAC = 50000 + 12000 + 16000 + 24000 + 12000 + 21000 + 20000 = SR 155000

EAC = [ACWP/BCWP] * BAC = [90400/85400] * 155000 = SR 164075

ETC = EAC – ACWP = 164075 – 90400 = SR 73675

SPI = BCWP/BCWS = 85400/93500 = 0.9134

CPI = BCWP/ACWP = 85400/90400 = 0.9447

Variance from original budget = EAC – BAC = 164075 – 155000 = SR 9,075

3. As CV > 0, the cost performance is over budget.
   As SV < 0, the schedule (time) performance is behind schedule:
   
4. Please find below the Gantt Chart:

Gantt Chart Time to complete (in weeks) 15 5 10 | 15 20 25 == Activity