Earned Value Problem set

PJM6125 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 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 and

add your last name to the end of filename. Submit the file in Blackboard.

Review the rubric below for grading information.

Submit your assignment via the Assignment Link as an excel file type and via the TurnItIn

link below as a pdf file type).

Rubric(s)

Assessment Element

Above Standard (100-95%)

Meets Standards (94.9 – 84%)

Approaching Standards

(83.9 – 77%)

Below Standard (76.9 – 70%)

Not Evident (69.9 – 0%)

Excel Calculations and Data Entry (75%)

Contains no errors in data entry. Submits a 100% completed Excel file for review

Contains <2 errors in data entry. Submits a 100% completed Excel file for review

Contains >2 errors in data entry in either file. Submits a partially completed Excel file for review

Contains multiple errors in data (>5) entry and submits an incomplete Excel file for review

Files contains many errors in data entry, is not complete, or was not submitted

Assessment (25%)

Answers the two questions in a thorough manner, including any notations about how a late task may impact other tasks, with supporting data.

Answers both questions in a full manner, response could provide additional insight and supporting data

Answers both questions in the most basic manner without providing additional insight

Only partially addresses one of the questions

Does not include a Summary or Projection