Earned Value Management

BACKGROUND

 You are 18 months into a 27-month effort, to deliver a Sensor Package Integration Delivery Order; and although you expected to be completed through task 22 at this point, you have only completed work through task 17. Some things are going well, while others seem to be falling behind schedule. Your management has asked for an in-progress review and you want to put your newly acquired EVM analysis skills to work to assess schedule and cost status.

The table of completed tasks, along with schedule and cost metrics (located at the end of this assignment) has been provided by your corporate planning and accounting departments.  Use the provided information to complete the assignment as detailed below. For your convenience, they have also included an Excel spreadsheet populated with these values (it’s probably a good idea to use this as the basis of the assignment response).

Note 1: You are accumulating Earned Value using the 0/100 rule – you get 100% of the value when the task is complete.

Note 2: In the table below, the far-left hand column is NOT used to indicate the months of the project, it is simply a numerical ordering of the steps of the project.

Note 3: The gray shaded area represents where we had planned to be at this point in time, the red line indicates where we actually are at this point in time

REFERENCES
  1. Unit 7 – Earned Value Management & Assessment of Cost, Schedule, and Performance
  2. Assigned reading
Assignment
  1. Specifically, calculate and report the following cumulative values for the project (show your work):
    1. Planned Value
    2. Earned Value
    3. Actual Cost
    4. Cost Variance
    5. Schedule Variance
    6. Cost Performance Index
    7. Schedule Performance Index
    8. Budget At Completion for entire project
    9. Percent Scheduled vs. Percent Completed
    10. Months ahead of or behind schedule at the end of month 17
    11. Percent Spent at the end of month 17
    12. Estimate At Completion
    13. Variance At Completion
    14. To Complete Performance Index (BAC)
  2. Provide an analysis of what these values are telling you about the current and projected health of the project.  If there are variances, what could you do to try to bring things back in-line?