WBS 1.1 1.2 1.3 1.4 1.5 1.6 Question 1 The following tables show total budgeted costs or planned value (Table 1), cumulative % completion (Table 2), and actual costs (Table 3) for a workpackage consists of six tasks. The planned duration of this workpackage is 12 weeks and earned values analysis has been done on a weekly basis until now (end of Week 7). Note: All calculations and tables of costs and project performance metrics on weekly basis must be presented. 12 marks Task Name Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 a. Calculate earned value (EV), cost variance (CV), schedule variance (SV), cost erformance index (CPI), and schedule performance index (SPI) for every week till the end of Week 7. b. Comment whether the project is within the planned schedule and budget at the end of Week 7 or not. Explain and justify your answer. c. Calculate estimated cost at completion (EAC) using four formula presented in Week 8 lecture and find the optimistic and the pessimistic EAC. Total Budgeted Costs 3500 4200 4500 3300 3000 6700 WBS Task Name 1.1 Task 1 1.2 1.3 1.4 1.5 Task 2 Task 3 Task 4 Task 5 WBS 1.1 1.2 1.3 1.4 1.5 WK1 WK2 WK3 1000 500 2000 500 800 Table 1. Total budgeted costs (Planned Value) Task 2 Task 3 Task 4 Task 5 TBC 3500 4200 4500 3300 3000 700 200 Wk 1 15% WK4 Wk 2 900 2000 600 50% 25% Table 2. cumulative % completion Wk 5 WK 3 WK5 2000 1000 1000 700 100% 30% 25% 300 100 Wk 4 WK6 WK7 800 1500 500 100% 60% 40% 300 500 1000 1200 1700 1250 900 400 WK 6 100% 100% 75% 90% 50% 100% 25% 80% 25% Table 3. Actual costs (weekly basis - not cumulative) Task Name WK 4 Wk 5 Wk 1 800 Wk 2 250 WK 3 1500 Task 1 900 700 WK8 Wk 6 1500 700 600 800 700 Wk 7 100% 100% 100% 90% 75% Wk 7 400 500 WK9 WK10 WK11 WK12 2000 1000 2000 1000