Percent Complete Problem

Hi there,


I really want to help u, but when I saw the 10 milestone of the programme have been completed 10% each I get confused, I assumed that all milestone in same line/ date,….

Let me tell you what I think, as duration wise you will have it sorted in the programme i.e. in the P6 alike you said, but as physical % that means you need weight your activities in the programme depending on efforts like(cost or man-hour) in separate excel sheet, bearing in mind that the total of the sum of the activity weights should be 100% in this case you can agree this with your PM i.e. the weighting system.

I hope this was clear for you or to gives you an idea how to manage the physical 100%

Regards,

Salar

Thanks for replying!

Let me try and clarify what I mean.

I’m not using the physical % complete in P6.

My question is:
I have 10 milestones and each one of them represents 10% of the work in the project. So each time a milestone is completed, 10% of the work is done. So if 3 of them are complete, you could say that 30% of the project is complete. What I’m looking for is a way of weighting these milestones and then rolling the total up into a summary bar.
So in the above example, the summary bar would say 30% complete in a column.

The project has a decent level of detail in it and I report the normal duration % complete usually. The PM has requested this different reporting and I’m just trying to show it in P6. If it is not possible I will just put all the data into excel or something.

I hope that is clearer!

Thanks

Try to do it manually, for example: 10 WBS (equivalent of your 10 milestones). You can update the activities under each WBS so that it sums up to 10% for each WBS.

How you do it? I supposed there are steps (for physical % complete); or costs; or units.

To roll-up, I supposed performance % complete works.

I never done it myself by the way.

cheers!

Hi Michael,

I presumed that you have only 10 Milestones in one project and no cost resource loaded to other activities, only the 10 milestone. If this is the case then, you can try this:

Assign "Expenses" to the 10 milestone.
Budgeted Units = 1
Price / Unit = 1

When done, update the 3 milestone (i.e. 100%) and add one column for the "Performance % Complete".

Let us know if the above steps works.

Regards,

Arnold

Hello Arnold, thanks for replying.

I have a couple of queries on your post:

In the expenses tab there are no entries for budgeted units or price/unit. These fields are in the resource tab and I cannot apply resources to milestones. The expenses tab contains budgeted cost, actual cost etc. I’m not sure which you mean.

At the moment I have 100% complete in the ’Performance % Complete’ for each milestone that is complete but it is still not rolling up to the summary bar.

I feel like I’m getting closer now!

Michael

To achieve 100% and project’s end, the sum over all expenses should be 100. Then you’ll easily be able to produce an s-curve.

If a ms represents e.g. 3% of the project, you’ll assign 3 (Euro, Pound, Dollar...) budgeted costs to it. Report "Cost %-Complete.

Regards
Dieter

Hi Michael,

Yes, you are correct, you cannot assign resource to Milestone because of zero duration.

To show the Budgeted Units and Price/Unit, right click on the open area of "Expenses" tab, and select "Customize Expense Columns".

Performance % Complete will only roll-up when you have resource cost assign to your activities.

Regards,

Arnold