Build an Earned Value Management (EVM) model using these variables:

Planned Value: $45,000

i.Note for understanding, this based on time, and what we expected to use based on time. Your schedule variance is based on earned and planned.

Actual Cost: $39,500

Earned Value (how much has been spent based on planned costs) : $43,500

i.Note for understanding, this usually based on expected costs at the task level. In other words, for the tasks complete the project was expected to use this much costs. Your cost variance is based on actual and earned.

Balance at Completion: $172,000

Original Time in Months: 14

Calculate in the model:

Cost Variance

Schedule Variance

Cost Performance Index

Schedule Performance Index

Estimate at Completion

Estimated Time

Use conditional formatting to render any bad values red, good values green and 0 values yellow. Do cell by Cell.

Analyze the data and denote your evaluation of the project. Include in the evaluation comments on schedule, costs, and performance