Planners' Place

View Original

Baseline Execution Index (BEI) in Microsoft Project

The Defense Contract Management Agency (DCMA) 14-Point Assessment is a set of metrics used to evaluate the quality of a project schedule to ensure that the schedule is fit for purpose. And one of the 14 metrics is the Baseline Execution Index (BEI) which is an indication of how a schedule is performing against a set baseline and the video below explains how to set-up a Microsoft Project schedule to display BEI.

I must confess that as someone based in the UK, the DCMA metrics have not been a requirement on projects that I have worked on but I know they are common in the US and other countries. A good resource that explains Baseline Execution Index (BEI) is Jason Grabowski’s blog post, https://baselineachieved.com/tutorials/baseline-execution-index/.

Once again, this tutorial was prompted by a question on the MSOfficeForums Project forum and I hope you find it useful.

Addendum (04-May-21)

If you are having errors in your BEI calculation where a summary only contains subtasks that are milestones or all subtasks start dates (current and baseline) are in the future, modify the BEI formula as shown below (changes are highlighted in bold).

IIf([Summary] AND [x = No. of Completed Tasks] <> 0 AND [y = Not 100% & BF <= Status Date] <> 0, [x = No. of Completed Tasks] /([x = No. of Completed Tasks] +[y = Not 100% & BF <= Status Date] ), 0)

See this content in the original post