+ moodle.telt.unsw.edu.au Is Netflix Feelin... WhatsApp Search Results |.. Homework Help. (525) Earned va... Class Collabora. Paraphrasing To... in https://moodle.t... in https://moodle.t... 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 a. Calculate earned value (EV), cost variance (CV), schedule variance (SV), cost performance 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. Table 1. Total budgeted costs (Planned Value) WK3 WK7 WK9 WK10 WK11 WK12 WK2 WK5 WK6 WK8 WBS Task Name Total Budgeted Costs WK1 500 2000 1.1 Task 1 3500 1000 4200 500 800 900 2000 1.2 Task 2 700 2000 1000 800 1.3 Task 3 4500 200 600 1000 1500 1.4 Task 4 3300 700 500 1000 800 1000 1.5 Task 5 3000 700 2000 1000 2000 1.6 Task 6 6700 Table 2. cumulative % completion TBC Wk 1 Wk 2 Wk 3 Wk 4 Wk 5 Wk 6 Wk 7 WBS Task Nam 100% 100% 15% 50% 100% 1.1 Task 1 3500 100% 100% 100% 4200 25% 30% 60% 75% 90% 25% 1.3 Task 2 40% 50% 100% 100% Task 3 4500 25% 80% 90% 1.4 Task 4 3300 25% 75% 1.5 Task5 3000 50% 16 Task 6 6700 Table 3. Actual costs (weekly basis - not cumulative) Wk 6 Wk 7 Wk 1 Wk 3 Wk 5 WBS Task Name Wk 2 1500 1.1 Task 1 800 250 900 700 1200 1700 1.2 Task 2 300 300 1250 1500 1.3 Task 3 100 500 900 700 400 500 1.4 Task 4 400 600 15 Task 5