DCMA 14 Point Check – Critical Path Test

This is an extension to our previous article regarding the DCMA 14 Point Check. The following method was used for Primavera P6 version 6.1, there was no other schedule analytical tool available so we developed a work around approach.

Open up the project for analysis in Primavera P6.

Select a critical activity that sits towards the front end of the critical path.

Extend this activity by a large quantity.

Schedule the project.

Analyse if the end date changes on the project.

In this example the end date changes which demonstrates that the Critical Path is working. This means that this project meets the DCMA criteria.

There are a further 13 checks prescribed by the DCMA which along with the Critical Path Test Check that will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.

September 12, 2016 0

Daily H&T 014 – EVM Planned Value

September 7, 2016 0

Daily H&T 013 – Estimate To Complete (ETC)

September 6, 2016 0

H&T 012 -Budget At Complete (BAC)

September 5, 2016 0

DCMA 14 Point Check – Finish Start Relationship

First open the project that is to be checked then we need to create a new report through the Report Wizard.

As it is the relationships we are interested in here, select Activity Relationships in the Subject Area.

We do not require any additional subject areas so click next.

Click on Columns so we can select the appropriate data we wish to include in the report. In this case we are interested in the Relationship Type. Only include this in the Selected options column.

Name the Report.

“As we want the report in Excel select ASCII and ensure that the Text Qualifier is set to “.

The report will run.

Delete the top two rows.

Add a 1 next to each identified Relationship Type.

Now insert a pivot table to summarise the data into the relevant Relationship Types.

Now divide each total for each Relationship Type by the total for all Relationship Types. In this example that will be 1693/1869.

In this example the FS relationships make up over 90% of the total Relationship types on the project. The DCMA criteria states that FS relationships should be no less than 90% – therefor this project meets this criteria.

There are a further 13 checks prescribed by the DCMA which along with the Finish Start Relationships Check that will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.

September 5, 2016 0

H&T 010 – Budgeted Cost Work Performed (BCWP)

September 3, 2016 0

H&T 009 – Varinace At Complete (VAC)

September 2, 2016 0

DCMA 14 Point Check – Critical Path Length Index

Open the required project for analysis in Primavera P6.

Make a note of the Total Float – in this example it’s 0.

Select Group & Sort.

Select None in the grouping.

Now select Filter.

Filter in Critical activities only.

Go back into Grouping & Sort and select show grand totals.

The Duration for the Critical Path is shown, document this down.

Now we have the data we can apply the formula, so in the example used in this document this would look like:

Critical Path Length Index = (1293 – 0)/1293 = 1.

There are a further 13 checks prescribed by the DCMA which along with the CPLI Check that will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.

September 1, 2016 0

DCMA 14 Point Check – Baseline Execution Index Check

Open up the required project for analysis in Primavera P6.

First we need to create a new report through the Report Wizard.

Select 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.

Click on Columns.

Add BL Project Finish and Actual Finish.

Click Next.

Add the report title.

Click Run Report.

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.

Filter on all the completed activities and make a note of the count.

Filter on Not Started and In Progress.

Now filter on the current month for progress update in the BL Project Finish Column.

Now we have the necessary data we can carry out the BEI calculations:

683 (Completed) + 16 (Should have completed) = 699.

BEI = 683/699 = 0.98. The DCMA criteria states that this should be 0.95 or above. In this example the project meets the criteria.

There are a further 13 checks prescribed by the DCMA which along with the BEI Check that will be detailed out in further supporting documentation and video tutorials at http://www.myxacom.com where knowledge is no weight to carry.