EARNED VALUE MANAGEMENT (EMV)

Consider a ten week long project with four different work packages and a total cost, or budget-at-completion (BAC) of $170,000. Complete an earned value management (EMV) analysis at the end of week six for Project-X.pdf execution of the project using the Earned-Value-Management.xlsx template. Determine the (a) estimated-at-completion or EAC, (b) estimated-time-to-complete or ETC, and (c) discuss the Project X execution of the project, i.e., what is happening.

- project-x.pdf

- earned-value-management.xlsx

Work Package A Work Package B Work Package C Work Package D Total for Week, or Planned Value (PV) Planned Value (PV) Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Total for Work Package 10,000 15,000 5,000 30,000 10.000 10.000 10.000 20.000 10.000 10.000 70,000 5,000 5,000 25,000 5,000 40,000 5,000 5,000 20,000 30,000 10,000 25,000 15,000 10,000 25,000 15,000 35,000 10,000 5,000 20,000 $170,000 Cumulative Percentage of Planned Work Complete Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Work Package A Hours Worked 240 535 300 Work Package B Hours Worked 45 60 220 475 200 220 Work Package C Hours Worked 125 160 600 110 Work Package D Hours Worked 110 120 480 Total Hours Worked for Week 240 580 360 220600360820220120480 Cumulative Total Hours Worked for Week 240 8 201 ,180 1,400 2,000 2,360 3,1803.400 3.5204,000 Cumulative Percent of Planned Work Completed 6% 20.5% 29.5% 35% 50% 59% 79,5% 85% 88% 100% Project X's Actual Cost (AC) Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Work Package A 8.000 12.500 3.500 6,000 Work Package B 1 5.000 5.500 8,000 17,000 8,000 Work Package C 3,500 3.500 Work Package D Total for Week, or Actual Cost (AC) 8.000 17.500 9,000 14,000 20,500 11.500 Project X's Cumulative Percentage of Actual Work Complete Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Work Package A Hours Worked 160 340 100 Work Package B Hours Worked 200 200 240 500 240 Work Package C Hours Worked 1100 120 Work Package D Hours Worked Total Hours Worked for Week 160 5401300240600360 Cumulative Total Hours Worked for Week 160 700 1.000 1.240 1.840 2.200 Cumulative Percent of Actual Work Completed 4% 17,5% 25% 31% 46% 55% Period Period 2 Period 3 Period 4 Period 5 Period 6 Budget at Completion (BAC) Planned Time to Complete Planned Value (PV) Cumulative Planned Value (PV) Actual Cost (AC) Cumulative Actual Cost (AC) % Actual Work Complete % Planned Work Complete Rate of Performance (RP) Earned Value (EV) - PVRP Cost Variance (CV) - EVAC Schedule Variance (SV) - EV-PV Cost Perf Indicator (CPI - EVIAC Schedule Pertind (SPN EVIPY Estimate at Completion (EAC) Estimated Time to Complete