10:12 1 Photos : 3 / 4 75% + IO H1041 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 4.000 6,000 10,000 20,000 50% ? ? 2 ? Construction 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) [1 mark] b) Earned Value (EV) [1 mark] c) Actual Cost (AC) [1 mark] d) Cost Variance (CV) [2 marks] e) Schedule Variance (SV) [2 marks] 1) Cost Performance Index (CPI) [2 marks] 9) Schedule Performance Index (SPI) [2 marks] h) Budget at Completion (BAC) [1 mark] 1) Estimate at Completion (EAC) [2 marks] 1) Estimate to complete (ETC) [2 marks] k) is the project on time and within budget? Justify your answers using the appropriate indicators above. [4 marks] Formulas CV = EV - AC = BCWP - ACWP: SV = EV - PV = BCWP - BCWS: CPFVIAC BCWPIACWPA hori Send a Chat Formulas CV = EV - AC = BCWP - ACWP; SV = EV - PV = BCWP - BCWS; CPI = EVIAC = BCWP/ ACWP; SPI = EV/PV = BCWP/BCWS; EAC = BAC/CPI = BAC/(BCWP/ACWP); ETC = EAC-AC = EAC - ACWP