Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

% Complete Planned Vs Actual

2 replies [Last post]
Jithin Kambhikanam
User offline. Last seen 2 weeks 2 days ago. Offline

Hi All,

 

I have a schdule which is resource and cost loaded (By unit rate of Resouce), which is the baseline.

After a week I scheduled it. 

So in the WBS how can I see what was the Baseline Planned % til date for Progress and Cost 

And what is the actual % complete for progress and Cost on that scheduled daat date?

What coloumns represents that?

 

Warm Regards

Jtihin

 

Replies

Rodel Marasigan
User offline. Last seen 1 day 19 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699

Hi Jithin,

Assuming that you have all the settings in place and correct such as maintain and assigned baseline to current project and it was match on the project settings on baseline for earned value calculation, Earned Value calculation was set on Budgeted Value with Planned Date, checked and recalculate cost and total Budget At Completion is correct then the following should have the correct data:

Column to show:

  • Budget At Completion (BAC) = Baseline labour cost + Baseline non-labour cost + baseline material cost + baseline expenses = Baseline Total Cost
  • Schedule % Complete = Planned % complete up to the data date (Baseline completion % complete so far)
  • Plan Value Cost = Budget At Completion * Schedule % Complete (baseline plan value)
  • Performance % Complete = Percent use to calculate Earned Value (based on the settings technique your project using for computing performance % complete, Activity % Complete by default)
  • Earned Value Cost = Budget At Completion * Performance % Complete
  • Actual Cost = labour cost + non-labour cost + material cost + expenses = actual cost to date to data date (manual input)
  • Cost % Complete = Actual Cost / At Completion Total Cost
Bian Mutang Tagal
User offline. Last seen 1 year 29 weeks ago. Offline

Hi Jithin,

Try these columns to show Planned Values (PV) and Earned Values (EV). 

  • Budgeted Total Cost
  • BL Project Start
  • BL Project Finish
  • Start
  • Finish
  • Schedule % Complete
  • Performance % Complete
  • Planned Value Cost
  • Earned Value Cost
  • Schedule Variance

When you say Actual % do you mean the actual cost (such as operating costs, material costs, overheads) that is keyed in by the user, or do you mean the Earned Value, which is auto-calculated by P6 based on the % complete of the activities keyed in by the user