Using MsProject for Earned Value Calculations

1. Using MsProject for Earned Value Calculations Advanced MsProject Course Dr. Leigh Geiger

2. Set Up Process • Create Project Plan • Baseline the Plan • Track progress/actuals & update the plan • Set the Status Date • Select the Earned Value method • Use MsProject EV Views & Reports

3. Set Up Process • Create Project Plan • Baseline the Plan • Track progress/actuals & update the plan • Set the Status Date • Select the Earned Value method • Use MsProject EV Views & Reports

4. Earned Value Methods • % Complete • Calculated for each task: [Act Dur/Dur]*100 • If you enter it directly -Project calculates Act. & Rem. Duration • Use if actual work is entered • Physical % Complete • Not calculated, must be entered directly • Use if Actuals aren’t accurate Possible to use up 90% of total task duration and still be only 10% Physical Complete, e.g., when most work is planned for the last minute.

5. EV Terms in Project

6. EV Views & Reports • Table Views • Earned Value • Earned Value Cost Indicators • Earned Value Schedule Indicators • Cost Reports • Earned Value • Visual Reports • EV Over Time