Question 2: Calculate Earned Value Indicators Based on the following data: The Budget At Completion (BAC) cost of the project is estimated to be: $140,000. Earned value data is available for the first three weeks of the project (see below). The project is due to end on week 4.

Project Data	Week 1	Week 2	Week 3	Week 4
Cumulative Actual Costs	$2,700	$15,700	$37,800
Anticipated planned Value	$11,750	$22,000	$43,000	$64,000
Cumulative Earned value	$6,750	$21,500	$47,000

Based on the above data, calculate the following earned value indicators:

EVM Indicator	Week 1	Week 2	Week 3	Formula used
Cost Variance
Schedule Variance
Cost Performance Index
Schedule Performance Index
Estimated Cost At Completion (use the EAC = BAC / CPI formula)
Estimated Cost to Complete

For this question you need to:

• Identify which formulas you used for each indicator;
• Show an example of your calculations (work) for each indicator; and

Calculate each indicator for each of the first three weeks

Question 3:

• Based on the question 2 data, represent the projects earned value status in a visual format.
• Your image need only include your AC, EV, and PV over the four-week project (see example chart at right).
• This chart can be done in Excel (or equivalent), or it can be drawn by hand (and then digitally scanned or photographed, and included in your assignment).

Question 4: Interpret the Projects Status

Using the SV, CV, CPI, SPI, EAC and ETC values that you calculated in question 2 along with your earned value dashboard that you prepared in question 3, provide a descriptive analysis and interpretation of the projects status.

Answers the following questions:

• At week three, is the project on-budget? (Or over? Or under?)

How does this compare to week one?

• At week three, is the project on-schedule? (Or behind? Or ahead?)

How does this compare to week one?

• Are the projects cost and schedule performances improving over time? Or worsening?
• From week one to week three, has the estimated completion cost gone up? Or down?