Project Monitoring Using Earned Value Concepts in Microsoft Project


Project monitoring is a crucial aspect of project management, and one of the most effective methods for tracking project performance is through the Earned Value Management (EVM) system. Microsoft Project offers tools that allow project managers to apply Earned Value concepts to monitor project progress, assess performance, and predict future project trends. This article will explain how to use Earned Value concepts in Microsoft Project to ensure projects stay on track.

What is Earned Value Management (EVM)?

Earned Value Management is a project management technique that integrates project scope, schedule, and cost to help project managers assess performance and make data-driven decisions. EVM compares the planned progress of a project with the actual progress and cost, providing insights into how well the project is performing. It calculates three key metrics:

  • Planned Value (PV): The value of the work that was planned to be completed by a specific time.
  • Earned Value (EV): The value of the work that has actually been completed by a specific time.
  • Actual Cost (AC): The actual costs incurred for the work performed by a specific time.

Key Earned Value Metrics

The key performance indicators derived from Earned Value are crucial for monitoring and controlling the project:

  • Cost Variance (CV): CV = EV - AC. This indicates whether the project is under or over budget.
  • Schedule Variance (SV): SV = EV - PV. This shows whether the project is ahead or behind schedule.
  • Cost Performance Index (CPI): CPI = EV / AC. This measures cost efficiency and shows how well the project is using its budget.
  • Schedule Performance Index (SPI): SPI = EV / PV. This measures schedule efficiency and indicates how well the project is adhering to the schedule.

Setting Up Earned Value in Microsoft Project

Microsoft Project provides built-in functionality to calculate Earned Value metrics, and with a few configurations, you can start tracking project performance in real-time. Follow these steps to set up Earned Value tracking:

  1. Open your project in Microsoft Project.
  2. Ensure that you have defined tasks, durations, and resources in your project plan.
  3. Go to the "Project" tab and click "Set Baseline." This will record the original project plan and allow Microsoft Project to compare planned and actual progress.
  4. Under the "View" tab, select "Table: Cost" from the "Tables" dropdown. This will display columns for "Planned Value," "Earned Value," and "Actual Cost."
  5. Once your baseline is set, as work progresses, Microsoft Project will automatically calculate the Earned Value metrics based on the data you enter for actual work and cost.

Example 1: Tracking Earned Value in Microsoft Project

Let’s assume you are managing a project with three key tasks: "Task 1," "Task 2," and "Task 3." Each task has an assigned cost and a planned duration. You want to track Earned Value to see how the project is progressing against the plan.

  • Task 1: Planned duration: 10 days, Planned cost: $10,000
  • Task 2: Planned duration: 15 days, Planned cost: $15,000
  • Task 3: Planned duration: 5 days, Planned cost: $5,000

After 5 days, Task 1 is 50% complete, Task 2 is 30% complete, and Task 3 has not started. You input the actual work completed and the actual costs incurred into Microsoft Project.

The Earned Value metrics would be automatically calculated as follows:

  • Planned Value (PV): PV is the cost of work that was planned to be completed by the current date. For Task 1, the planned cost is $5,000 (50% of $10,000). For Task 2, the planned cost is $4,500 (30% of $15,000). Task 3 has no PV as it has not started.
  • Earned Value (EV): EV is the value of the work that has actually been completed. For Task 1, EV is $5,000 (50% of $10,000). For Task 2, EV is $4,500 (30% of $15,000). Task 3 has no EV as it is incomplete.
  • Actual Cost (AC): AC is the actual cost incurred for the work performed. For Task 1, the AC is $4,500, for Task 2, the AC is $5,000, and for Task 3, the AC is $0 (no work done).

Example 2: Calculating Earned Value Metrics

Using the values from the previous example, we can calculate the following Earned Value metrics:

  • Cost Variance (CV): CV = EV - AC = $9,500 (EV) - $9,500 (AC) = $0. This means the project is on budget.
  • Schedule Variance (SV): SV = EV - PV = $9,500 (EV) - $9,000 (PV) = $500. This means the project is ahead of schedule.
  • Cost Performance Index (CPI): CPI = EV / AC = $9,500 / $9,500 = 1. This indicates that the project is performing efficiently in terms of cost.
  • Schedule Performance Index (SPI): SPI = EV / PV = $9,500 / $9,000 = 1.06. This indicates that the project is progressing faster than planned.

Using Earned Value Reports in Microsoft Project

Microsoft Project also allows you to generate reports based on Earned Value metrics to track project performance visually. Follow these steps to generate an Earned Value report:

  1. Go to the "Report" tab in the ribbon.
  2. Click "Visual Reports" in the "Reports" group.
  3. In the "Visual Reports" dialog box, select "Earned Value" as the report type.
  4. Choose a chart type (e.g., a line or bar chart) and specify the data fields you want to include in the report (e.g., EV, PV, AC, CV, SPI, CPI).
  5. Click "View" to generate the report, and Microsoft Project will display the visual chart based on the Earned Value metrics.

Conclusion

Using Earned Value Management in Microsoft Project allows project managers to monitor the health of their projects by comparing actual progress with planned progress. By calculating key metrics such as Planned Value, Earned Value, and Actual Cost, and deriving performance indicators like Cost and Schedule Variance, and Performance Indices, you can get a clear picture of your project's status. Microsoft Project's built-in tools make it easy to implement Earned Value tracking and generate insightful reports to guide your project to successful completion.





Advertisement