For this assignment, the earned value problem sets offer an opportunity to practice using excel to calculate earned value measures.

Please reference the attached document for specific assignment instructions and the assignment rubric.

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

2

>Sheet

1

nding

2

uration

inish

omplete

C

A

%

%

s

0

7

0 0 0

4

C
0 4 4

2

A Task

EV

PV CV SV

1 1 5 5 5 10 10 2 12 A

D F B

0 5 5 5 0 10 10 0 12

0

0 0 0

B
0 0 5 5 3 8
E

7 2 10 Task % Complete EV AC PV CV SV
A 100% 35
B 100% 24
C

24

D 0% 0
E

%

10

ID

2 3 4 5 6 7 8 9 10

12 Cumulative Totals 0

0 0 0

A

10 10 10 10

B

8 4 8 4 8

C

12 12 12 12

D

6 2 2 2 6 Task % Complete EV AC PV CV SV

E

8 8 12 A 100% 35

F 40

20 B 100% 24

Total

18

18 14 20

26 2 6 20 20 C 100% 32

Cumulative 18 32 50

206 D

20

E 100% 20
Cumulative Totals 0

0 0 0

Period EV AC PV

2
4
6
8

																																																																																																																																																																																																																																																																																																																																																																																																																																																																																							Legend	Status Report:				E	Period
Early Start					D	Early		F				Task	%				C					EV							A					PV				CV				SV
	ID			7									5	25
Late Start	Slack	Late Finish						B	5																							0									12
			Cumulative	Total			3
							4									8
					6												10	Status Report: Ending Period 4
		% Complete				AC
			10	0%			35
			100%				24
Cumulative Totals	5	9
Status Report: Ending Period 6
75%
	50
Budget	0 1	11	93
	40
		32
48	Status Report: Ending Period 8
			18
28
						20
	206		14		26	22
64	84	110	132	158	160	166	186	33%
131
Include your assessment here in this section
Performance Index Summary
SPI	CPI
EAC =	VAC =