Question: Open the data file “ev.sav”. This shows the earned value data for a project, after nine months into a two year project. The reporting “period” is monthly, and the values for BCWP, ACWP, and BCWS are in thousands of dollars ($K).

a) What is the BAC (budget at completion) for this project (duration and cost)?

b) Create new variables, and calculate the SPI and CPI (schedule and cost performance indices) for each reporting period to date. (Transform/Compute)

c) Make a line graph of SPI and CPI versus reporting period. Use Graphs/Line/Multiple for “Values of individual cases” (in SPSS 15 or later, Graphs/Legacy Dialogs/Line/Multiple). Lines represent cpi and spi, and the Category Label is the Variable “period”. Indicate graphically when CPI and SPI went into the green, yellow, or red zones as defined by the US Marines (per slide 39 of week 3 lecture). The latter can be done manually in Word after pasting the graph, using the Drawing toolbar.

d) Make and show a line graph of BCWP, ACWP, and BCWS versus period.

e) Based on the trends seen in part c), determine the EAC. Explain how you arrived at this. Remember to give both cost and schedule components.

f) What are the projected cost and schedule overruns? How would you describe the state of this project in terms of cost and schedule?

g) As of the ninth month, how much money was actually spent on the project?

h) As of the ninth month, what are the cost variance, schedule variance, and schedule slip?