Project Evaluation: Earned Value Problem

Project Evaluation: Earned Value Problem Set

Overview and Rationale
These problem sets offer an opportunity to practice using excel to calculate earned value measures.

Program and Course Outcomes
This assignment provides a baseline understanding to the course topics, and is directly related to these course learning objectives:
LO5:    Perform Earned Value analysis to provide both variance and forecasting performance measures for a simulated project

Essential Components
From Chapter 13 of the Gray & Larson textbook (7th edition), complete Exercise 4 that starts on page 489 and continues to 490. To submit your answer, utilize the provided worksheet in Excel that matches those found on pages 489-490 in Gray & Larson and enter the missing data based on the material provided.
Include an Assessment section either at the bottom of your table that refers to your calculations, especially your EACf and VACf calculations: what is your assessment of the current status of the project?  At completion?
    Status Summary
    Projected Status at Completion (include estimates for cost and budget; to go above and beyond, include details about various tasks that may impact projected status)

If you have not done earned value before, this may take some time to complete, so please be sure to start early working on this assignment.
Complete all calculations in the designated cells within the spreadsheet.  Save the spreadsheet
Review the rubric below for grading information.