• Calculate the following:

A) Construction project budget calls for the following expenditures:

B) Refer to the definitions of each term, calculate these values for the above project, and show your work:

1. Budget at completion (BAC)
2. Planned value (PV) as of May 1
3. Earned value (EV) as of May 1 if the foundation work is only two-thirds complete. Everything else is on schedule.
4. Schedule Variance (SV) as of May 1.
5. Actual cost as of May 1 is $160,000. Calculate the cost variance (CV) as of May 1.
6. Schedule performance index (SPI)
7. Cost performance index (CPI)
8. Estimate to complete (ETC), assuming that past variances are not expected to continue
9. Estimated Final Project Cost (EAC)

* Note: Make sure to include ALL tasks that were completed as of May 1st.

C) Show your work with formulas

• Answer the following questions:

1) Is the project on schedule as of May 1? What indicator did you use? Explain. 2) Is the project achieving more than predicted for the money as of May 1? What indicator did you use? Explain. 3) Is the project on budget as of May 1? What indicator did you use? Explain.

*Note: All cells that require input are highlighted in blue in the worksheet.

Construction Project Earned-Value Analysis
Project Budget
Task	Date	Budgeted Amount
Build forms	1-Apr	$10,000
Pour foundation	1-Apr	$50,000
1-May	$100,000
Frame walls	1-May	$30,000
1-Jun	$30,000
Remaining tasks	July 1 and beyond	$500,000
Budget at Completion (BAC)
Results as of May 1
Foundation completed %	66.67%
Everything else is on schedule.
Actual Cost	$160,000
Previous cost variances will not affect future costs
Calculate as of May 1st
PV
EV
AC
SV
CV
SPI
CPI
ETC
EAC
Answer the following questions
1) Is the project on schedule as of May 1? What indicator did you use? Explain.
2) Is the project achieving more than predicted for the money as of May 1? What indicator did you use? Explain.
3) Is the project on budget as of May 1? What indicator did you use? Explain.