4. The following tables show Total Budgeted Costs or Planned Value (Table 1). Earned Values (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 (Week 7). a. Calculate schedule variance (SV), cost variance (CV), schedule performance index (SPI) and cost performance index (CPI) at the end of Week 7. All calculations and formulas must be typed. (4 marks) b. Comment whether the project is within schedule and budget. Explain and justify your answer. (2 marks) C. Find the optimistic and the pesimestic Estimated Cost At Completion (EAC) and Variance At Completion (VAC). All calculations and formulas must be typed. (8 marks) Table 1. Total budgeted costs (Planned Value) WK2 WK3 WK4 WK5 WKO WKZ WKS WKO WK10 WK11 WK12 WK1 1000 500 2000 500 300 WBS 1.1 1.2 1.3 1.4 1.5 1.6 Task Name Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Total Budgeted Costs 3500 4200 4500 3300 3000 6700 700 200 900 2000 600 2000 1000 1000 700 800 1500 500 1000 800 700 2000 1000 2000 1000 Table 2. Earned Value WK 1 15% WK 2 50% 25% WBS Task Name 1.1 Task 1 12 Task 2 1.3 Task 3 1.4 Task 4 1.5 Task 5 1.6 Task 6 TBC 3500 4200 4500 3300 3000 6700 WX 3 100% 30% 25% Wk4 100% 60% 40% WKS 100% 75% 50% 25% Wk6 100% 90% 100% 80% 25% Wk 7 100% 100% 100% 90% 75% 50% Table 3. Actual costs Wk 4 WK 5 Wk6 WK 7 WK 1 800 WK 2 250 900 WBS Task Name 1.1 Task 1 1.2 Task 2 1.3 Task 3 1.4 Task 4 1.5 Task 5 WK 3 1500 700 300 1200 300 1700 1250 900 400 100 500 1500 700 600 400 500