On this ACTIVITY, you will calculate$$PLANNED VALUE,$$ACTUAL COST,$$COST VARIANCE, and$$EARNED VALUE, using the same project discussed in the lecture for this module.

Below is the$$ORIGINAL SCHEDULE$$for the project:

CONSIDERING THE INFORMATION AND SCHEDULES PROVIDED ABOVE, ANSWER THE QUESTIONS BELOW. $($The BONUS QUESTION will not be graded, but MUST be answered$)$

$1.$ What is the TOTAL PLANNED COST for this project?

$2.$ What is the TOTAL ACTUAL COST of this project?

$3.$ What is the PLANNED VALUE on day $9?$

$4.$ What is the EARNED VALUE on day $9?$

$($for this exercise, assume that task B was evenly split in $4$ days, according to the FINAL SCHEDULE provided$)$

$5.$ What is the project's COST VARIANCE on day $9?$

$6.$ If you were tracking only COSTS as a KPI, and not EV$,$ what would be your conclusion about the performance of this project, if you compared the PLANNED COST and ACTUAL COST on day $9?$ Explain your conclusions using the concepts presented in this module.

BONUS QUESTION: As a project manager, you seem to have overestimated the duration of task B$.$ What kind of biases could have caused this overestimation? $($review BIASES in$$Module $11).$

$$

$$

$$

HOW TO SOLVE THIS ACTIVITY: Use Excel template

If using excel, I strongly suggest you create your own tables to solidify the concepts developed in this module and have a clear understanding of the relationships between planned value, actual cost, and earned value. That being said, here is a$$template for solving this activity$$Download template for solving this activity$($you still need to solve it$,$ but it is a little help to get to the final results$).$