P6primavera.wordpress.com/

How to track daily actual resource allocation (Labor, Non-Labor) and compare it against planned resource allocation:

If one wants to track / compare this info on a daily basis, one needs to display the time scale accordingly. This will provide info regarding planned numbers against the desired time period (daily in this case). Next the daily actual resource numbers (allocation units) are needed, which can be found in site daily reports.

It is pretty unlikely that daily reports would tell exactly how many numbers of which trade were employed at which specific activity. A planner needs to make several rounds all around the site every day (and making notes on drawings/sketches/diary) in order to have this and plenty of other very useful data first hand.

If the analysis is limited to just the numbers without reference to specific activities, it is very easy. Just follow para #1 and that's it.

It is also very rare for a schedule to be updated on a daily basis; normally there is at least a week's update. So if the schedule is not being updated daily, the planned information may be exported in an excel sheet and actual information fed in appropriately to produce desired reports. Else the schedule may be updated every day with actual numbers incorporated under the Resources tab > Actual Units field.

EARNED VALUE OPTIONS IN ADMIN PREFERENCES

These options enable selection of the manner in which planned values are required to be calculated.

The first one is pretty straightforward - Budgeted Values with Planned Dates :

The first image below shows the allocation of activity duration, units and costs.

When the above schedule is designated the baseline, and is updated midway (Update1, or U1), 50% planned and 20% accomplishment is easily understood, ref. image 2.

In the update process both activities are 20% complete with RD of first activity as 20d and that of the second activity as 10d. This makes the current total (or at complete) duration 22d and 12d, respectively. (Image-2)

Now, if this updated version U1 is applied as a baseline (B2) to U1 then planned values may be calculated based on the updated dates in U1, from actual start to expected finish (i.e. 22d, as explained above).

PV = elapsed duration / total duration * assigned cost = 2 / 22 * 1,000 = 90.91

In order to make the application disregard the original duration (10 days) which is stored in activity data, it has to be specified that “current’ date must be used. This is where we use the option of ‘Budgeted Values with Current Dates’. (Image-3)

The above calculation is wrt changed total (at complete) duration. What about changed total (at complete) cost?

Let’s assume the Remaining Cost (and thereby the At Completion Cost) increases by $200. Meaning At Completion Cost = $ 1,200

In this case, just as the change in manner of calculating the spread of time was specified using Budgeted Values with Current Dates, we will specify the change in spread of cost over time by using the option of “At Completion Values with Current Dates”. (Image-4)

PV = 2 / 22 * 1,200 = $ 109.09

Primavera P6 Expertise https://www.facebook.com/groups/PrimaveraP6Expertise/