Question $1$:

The table shown below is for a project that is planned to be completed in $4$ months.

$($a$)$ What is the total planned budget $($Budget At Completion$)$ of the project?

$($b$)$ Calculate SV$,$ CV$,$ SPI and CPI at the end of second month. Can you comment on the status of the project? $($Please note that $EV=\%$ Completed $$BAC $)$

$($c$)$ Calculate the Estimate To Completion $($ETC$).$

$($d$)$ Calculate the Estimate At Completion $($EAC$)$ using Method #$3.$

$\backslash$table$[[$Month$,1,2,3,4],[\backslash$table$[[$Actual $\%$ of the project$],[$completed $($cumulative$)]],31\mathrm{.}25\%,54\mathrm{.}69\%,,],[$Planned Value,$$1,110,000,$$$600,000,$$$950,000,$$$540,000],[$Earned Value,$$1,000,000,,,],[$Actual Cost,$$1,250,000,$$$500,000,,]]$