Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Planned Value

5 replies [Last post]
Mon, 2007-03-26 21:34
SS Tsen
User offline. Last seen 18 years 11 weeks ago. Offline
Joined: 2 Mar 2007
Posts: 8
Groups: None
Why the planned value labor units on Activity table and Activity usage spreadsheet showing different value?

Is there any setting that could fix this ?

Top

Replies

Tue, 2007-03-27 21:30
#1
SS Tsen
User offline. Last seen 18 years 11 weeks ago. Offline
Joined: 2 Mar 2007
Posts: 8
Groups: None
Hi Rodel,

Thanks alot!
The explanation is very helpful.

Regards,
sansan
Top
Tue, 2007-03-27 07:30
#2
Rodel Marasigan
User offline. Last seen 23 weeks 17 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Sansan,

Sorry for the late reply, I was tied up with the meeting. Here are the explanations on your query.

Planned Value Units/Cost is the portion of the budgeted total Units/Cost of the activity that is scheduled to be completed as of the project data date, according to the baseline. Computed as Planned Value Units/Cost = Individual resource Budget At Completion * (Data Date of current project - Baseline Assignment Start Date) / (Baseline Assignment Finish Date - Baseline Assignment Start Date). The Planned Value Units/Cost of an activity is the sum of the Planned Value Units/Cost of each individual resource assignment on the activity.

Ex:
Baseline Start (BS) = 28-Feb-2007 Wed
Baseline Finish (BF) = 01-May-2007
Data Date (DD) = 10-Mar-2007
Original Duration (OD) = 12d
Actual Duration (AD) = 9d
Remaining Duration (RD) = 3d
Budget Labor Units (BLU) = 1500
Actual Labor Units (ALU) = 500
Remain Labor Units (RLU) = 611
Actual Progress (AP) = 45%
Schedule % Complete (S%C) = 75%

Planned Value Labor Units
(PV) = BAC * (DD-BS)/ (BF-BS)
= 1500*(10/Mar/07 – 28/Feb-07)/ (14/Mar/07 – 28/Feb/07)
= 1500*(10-Weekend)/ (14-Weekend)
= 1500*9/12
= 1125
Or you can calculate it as Schedule % Complete * Budget Labor Unit
PV = 75% * 1500 = 1125

If an activity has no resources, its Planned Value Units/Cost is calculated as the Budget At Completion * Schedule % Complete [(Data date - Baseline Start) / (Planned Finish - Baseline Start)]. The Schedule % Complete specifies how much of the activity’s original duration has been completed so far.

Earned Value (EV) = 1500 * 45% = 675

From this method you can have 3 comparisons between ALU, PV & EV

I hope this help.

Regards,
Rodel
Top
Tue, 2007-03-27 01:33
#3
SS Tsen
User offline. Last seen 18 years 11 weeks ago. Offline
Joined: 2 Mar 2007
Posts: 8
Groups: None
The planned value labor units column on the activity table shows zero hour whereas the planned value labor units of the activity usage spreadsheet by time interval shows positive numbers spread across months. My query is how to get the total planned value in the activity usage spreadsheet reflected in the planned value labor units column of the activity table.
I have sent you a screen dump.
Top
Tue, 2007-03-27 01:33
#4
SS Tsen
User offline. Last seen 18 years 11 weeks ago. Offline
Joined: 2 Mar 2007
Posts: 8
Groups: None
The planned value labor units column on the activity table shows zero hour whereas the planned value labor units of the activity usage spreadsheet by time interval shows positive numbers spread across months. My query is how to get the total planned value in the activity usage spreadsheet reflected in the planned value labor units column of the activity table.
I have sent you a screen dump.
Top
Mon, 2007-03-26 22:16
#5
Rodel Marasigan
User offline. Last seen 23 weeks 17 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Sansan,

I’m not sure if I interpreted you query correctly. Plan Value or Budgeted Units are shown in usage spreadsheets depend on which field you’re looking at. It may be cumulative spread or time interval. You might also need to check whether your fields are only the remaining units or other fields. Can you be specific on your queries or give examples so other PP’s understand your queries and able to help you further.

Regards,
Rodel
Top