University

Question $1$

$[20$ marks$]$

Table $1$ shows the schedule for a construction project that is intended to be completed in five months.

Table $1$ Project schedule and estimated costs

$\backslash$table$[[$Activity$,\backslash$table$[[$Estimated$],[$Cost$]],\backslash$table$[[$month$],[1]],\backslash$table$[[$month$],[2]],\backslash$table$[[$month$],[3]],\backslash$table$[[$month$],[4]],\backslash$table$[[$month$],[5]]],[$A$,1000,,,,,],[$B$,500,,,,,],[$C$,3000,,,,,],[$D$,2500,,,,,],[$E$,2200,,,,,],[$F$,2000,,,,,]]$

After two and a half months, activities A and B are $100\%$ complete, activity C is $80\%$ complete, activity $D$ is $30\%$ complete, activity $E$ is $20\%$ complete, and activity $F$ has not been started yet. The actual project cost to date is $$7,000.$

Perform the earned value analysis to determine the following values: $EV,PV,AC,SV,$ CV$,$ CPI, SPI, BAC, EAC, ETC, and VAC. Also, draw your conclusion about whether the project is over or under budget and whether it is ahead or behind schedule at this point. And explain what SPI and CPI indicate in this case.