10:12 Photos H1041 3/4 - 75% + PROFESSIONAL AND MANAGERIAL SKILLS Question 2. Earned Value Analysis Perform an earned value analysis using the data in the table below. The project has a 12-month duration and a budget of 250,000. Data are provided for a project review after the first 6 months are completed. Activity January Feb March April May June Planned % Earned Value Completed Value Staffing 6,000 5,000 11,000 100% ? Blueprinting 3,000 6,000 9,000 100% ? Prototype 2,000 8,000 10,000 60% ? development Full Design Construction 4,000 6,000 10,000 20,000 50% ? 2,000 35,000 37,000 15% ? Transfer 6,000 6,000 0% ? TOTAL ? ? Monthly plan 6,000 10,000 14,000 4,000 8,000 51,000 Monthly 6,000 12,000 15,000 4,000 10,000 52,000 Actual Using the formulas provided, calculate the following: a) Planned Value (PV) b) Earned Value (EV) c) Actual Cost (AC) d) Cost Variance (CV) e) Schedule Variance (SV) f) Cost Performance Index (CPI) g) Schedule Performance Index (SPI) h) Budget at Completion (BAC) i) Estimate at Completion (EAC) j) Estimate to complete (ETC) k) Is the project on time and within budget? Justify your answers using the appropriate indicators above. Formulas CV EV-AC BCWP-ACWP; SV=EV-PV BCWP-BCWS; CPI EV/AC BCWP/ACWP O Send a Chat [1 mark] [1 mark] [1 mark] [2 marks] [2 marks] [2 marks] [2 marks] [1 mark] [2 marks] [2 marks] [4 marks] Formulas CV = EV - AC = BCWP - ACWP; SV = EV-PV = BCWP - BCWS; CPI = EV/AC = BCWP/ ACWP; SPI = EV/PV = BCWP/BCWS; EAC = BAC/CPI = BAC/(BCWP/ACWP); ETC = EAC-AC = EAC - ACWP