QUESTION $1(15)$

Tutorial $9\mathrm{.}1$

Make use of the cash data as provided and answer the following:

a$.$ Calculate the estimate at completion $($EAC$)$ by making use of the following formula:

EAC$=(BAC$ACW$\frac{P}{B}CWP)\frac{1}{1+CV}\frac{1}{1+SV}$

$\backslash$table$[[$Pask$,1,2,3,4,5,6,7,8],[AB,4000,4000,,,2000,,,],[AC,1500,1500,2000,2000,,,,],[AD,5000,,,,,2000,3000,],[BE,,6000,8000,6000,,,,],[BF,,,3000,,2000,2000,2000,2000],[$DG$,,,4000,1000,,1000,1000,1000],[DH,,,,,,4000,6000,4000]]$

Completion Report $($after$6$ weeks$)$

$\backslash$table$[[$TASK$,\%$ COMPLETED,ACTUAL COST$],[AB,95\%,9600],[AC,80\%,7800],[AD,75\%,6400],[BE,100\%,18000],[BF,40\%,3500],[DG,60\%,5800],[DH,5\%,2500]]$

$\%$ complete is of the whole activity

b$.$ Complete the following table by calculating the answers and by explaining each scenario.

$\backslash$table$[[,$BAC,BCWS$,$BCWP$,$ACWP,EAC,SV$,$CV$],[1,\backslash$table$[[20000],[$UNITS X$],[$R$10]],\backslash$table$[[5000],[$UNITS$]],\backslash$table$[[5500],[$UNITS$]],$R$66000,($a$),($b$),($c$)],[2,$R$25000,$R$12000,($d$),$R$11500,($e$),10\%,($f$)],[3^{***},$R$30000,$R$15000,$R$18000,$R$18500,($g$),$R$3000,-3\%$