EVA Worksheet

Problem $1$

Week AC PV EV CV CPI SV SPI

$2$ $$72,000$

A project manager is analyzing progress on a project to make a $10-$minute documentary. It$$s the end of week two on this three week project. The actual cost is $$72,000.$ They have $7$ minutes of usable film. The budgeted total cost is $$100,000.$ Determine PV$,$ EV$,$ CV$,$ CPI, SV$,$ and SPI.

a$.$ First, map each description to an EVA category. Then, fill in the table.

b$.$ What do the SPI and CPI values mean in this example? Explain in $$plain English.$$

c$.$ Could a project or task be where we expect in terms of cost$,$ but behind on schedule? $($Hint: see formulas$)$

Problem $2$

You are managing a project to film $5$ promotional videos to be posted on YouTube, to promote one of the UI fraternities. Your project has a BAC of $$12,000.$ One of the tasks on the critical path is to arrange filming locations. The task has a BAC of $$2,000.$ You have confirmed $4$ of the $10$ locations. The task is scheduled to take $2$ weeks $(10$ days$),$ and it is the end of day $2.$ You have spent $$300$ so far.

a$.$ Identify the task$$s BAC, AC$,$ EV and PV

b$.$ Calculate SPI and CPI.

c$.$ What do the results tell you about the task$$s schedule and budget?

Problem $3$

You are managing a construction project with a BAC of $$1,400,000.$ You have built $4$ of the $5$ houses, and you have just finished week $6$ on the project, out of the scheduled $11$ weeks. Your actual cost has been $$800,000$ so far. Determine the estimate to complete $($ETC$)$ the project, and briefly explain what the result means.

Problem $4$

You are managing a task on the critical path which has a BAC of $$500,000.$ The task is $80$ percent complete. The team has completed $10$ weeks on the task, and it was scheduled to take $10$ weeks. You have spent $$400,000$ on the task so far. Calculate the cost performance index $($CPI$)$ and schedule performance index $($SPI$).$ Briefly explain what the results mean.

Problem $5$

$5$a$.$ For the following tasks, complete EV$,$ SV$,$ CV$,$ CPI, SPI, ETC and EAC. Show your work.

All costs in $$000,$ all time in days. $\%$ Completion is given; note that tasks A through D should be $100\%$ complete at this point per the project schedule. PV $=$ BAC, and EV $=\%$Complete $*$ PV$,$ for those tasks, because we should be done with the project by now. Task E has a BAC of $$4\mathrm{.}30.$ Tip: Draw an AON diagram to see the relationships and timing of tasks.

Task $\%$

Complete Time $($days$)$ PV EV AC SV CV CPI SPI ETC EAC

A$.$ Breadboard design finalized

Predecessor: $-100\%8$ $$10$ $$11$

B$.$ Build $2$ breadboard mock$-$ups

Predecessor: A $90\%2$ $$2$ $$2\mathrm{.}50$

C$.$ Update rev A design

Predecessor: A $75\%7$ $$1$ $$1$

D$.$ Pay $1/2$ of ASIC NRE

Predecessor: A $100\%1$ $$400$ $$400$

E$.$ Prep for $1$st proto build $(20$ boards$)$

Predecessor: C $0\%50$ $$0$

$5$b$.$ What comments can you make about this project, based on a budget of $$417,300?$