In our thirteenth article looking at the 14 point check we described how we checked the Critical Path Length Index, in this post we are going to take a look at the Baseline Execution Index.
The DCMA criteria states that the ratio between the number of tasks completed to the number of tasks that should have been completed should be 0.95 or greater.
Baseline Execution Index Check
To check this is Primavera P6 we used the following steps:
Step 1. Open up the required project for analysis in Primavera P6.
Step 2. Create a new report through the Report Wizard by selecting Activities in the subject area as this is the data we wish to see in the output report. Click past the additional subject area screen as we do not require any additional subjects for this report.
Step 3. Add the BL Project Finish and Actual Finish columns then click next.
Step 4. Add the report title and click Run Report.
Step 5. As we want the report in Excel select ASCII and ensure that the Text Qualifier is set to “. The Report will open in Microsoft Excel.
Step 6. Filter on all the completed activities and make a note of the count. Now filter on Not Started and In Progress and filter on the current month for progress update in the BL Project Finish Column.
Step 7. Now the Baseline Execution Index calculation can be used – BEI = Tasks with Actual Finish Date / (# of Baseline Tasks Scheduled to Finish Prior to Status Date +Tasks Missing Baseline Start or Finish Date).
If the ratio is 0.95 or greater than the criteria has been met, if lower then the schedule would require a review.
There are a further 13 checks prescribed by the DCMA which along with the Invalid Dates Check will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.