You've been assigned as a PM for a website development project. Their goals are to complete the project in 12 months for a budge of $im. The cost baseline is shown in the following Excel spread sheet and the project has been done for 6 months You decide to use the EVM you've learnt from the course to determine how well the project is progressing by June a. Work out the EVM indices CV, SV, CPI, SPI. estimated cost at completion (EAC) and estimated time to complete. Explain the progress of the project based on the EVM indices. (12) b. Use a simple cost vs time graph to show the AC, EV, PV curves and forecast the EAC (2) 1 13 6 Month 21 3 4 5 6 7 BI 9 101 11 12 Total Cost 0000) $ 13 16 8 1 1 1 $ 33 $ $ - 5 73 7373 $ 224 5 35 35 35 $ 110 5 43 43 43 $ 134 5 43 43 43 $ 134 17 53 53 53 $ 178 3 3 3 7 $ 15 21 2. 2 2 21 2 2 21 2 25 22 2 2 2 3 3 3 2 3 2 11$ 27 35 11 $ 100 $ 100 20 32199 200 217 61 51 12 12 106 1,000 20 32 199 200 217 61 61 60 12 12 106 40 72 271 471 688 749 810 870 882 894 1,000 22 35 210 220 245 42 77 287 507 752 16 29 188 185 215 36 65 253 438 653 WBS Categories 1. Analysis 2. Design 3. Development 3.1 Website 3.11 Html 3.12 CSS 313 Multimedia 3.1.4 Programming 3.2 Deployment 3 3 Documentation 3.4 Stakeholder communications 4. Training 6. Supporting Subtotal Reserves Total Monthly Planned Value (PV) Cumulative Planned Value (PV) Monthly Actual Cost (AC) Cumulative Actual Cost (AC) Monthly Eamed Value (EV) Cumulative Earned Value (EV) Project EV as of June Project PV as of June Project AC as of June CV-EV-AC SV-EV-PV CPI-EVIAC SP-EVIP Estimate at Completion (EAC) Estimated time to completo 1 20 20 20 20 20 20 20 ? 2 2 ? 7