Resource Plans versus Planned Work

[Shawn Everingham]

I am trying to understand the data from the MSP_Portfolio_Analyzer cube,
specifically for capacity planning into the future.

I was under the impression that when you created a project plan that was
going to use a resource plan, you created the tasks, assigned the resources
to the tasks where appropriate, not caring about their percentage of
allocation, because the resource plan would 'trump' project plan.

So created a nice view of the future, and as expected the curve was a
downward trend the further out we went. Looking at the data, my operation
plan with a resource plan, was off the roof...4000 hours a month, 6 months
out. My resource plan only had my guys reserved for 5% of their time, should
of been maybe 100 hours per month.

Checking all the available fields and using my project as an example, it
looks like msps treats the two types of data differently. So...work = planned
work in the project and the resource plan field = planned capacity in the
resource plan.

This is confusing me, if one trumps the other, then I'm going to have to do
some magic to say, if resource plan, the take the data from this field, if no
resource plan then take the data from this other field.

Am I thinking straight? any help or explanation? probably pebkac problem.

 

[Mike Mahoney]

I am trying to understand the data from the MSP_Portfolio_Analyzer cube,
specifically for capacity planning into the future.

I was under the impression that when you created a project plan that was
going to use a resource plan, you created the tasks, assigned the resources
to the tasks where appropriate, not caring about their percentage of
allocation, because the resource plan would 'trump' project plan.

So created a nice view of the future, and as expected the curve was a
downward trend the further out we went. Looking at the data, my operation
plan with a resource plan, was off the roof...4000 hours a month, 6 months
out. My resource plan only had my guys reserved for 5% of their time, should
of been maybe 100 hours per month.

Checking all the available fields and using my project as an example, it
looks like msps treats the two types of data differently. So...work = planned
work in the project and the resource plan field = planned capacity in the
resource plan.

This is confusing me, if one trumps the other, then I'm going to have to do
some magic to say, if resource plan, the take the data from this field, ifno
resource plan then take the data from this other field.

Am I thinking straight? any help or explanation? probably pebkac problem.

Hi Shawn

The resource plan can only trump the project assignment in MSP
Resource usage views. In data analysis views the data are displayed
separately so some magic required.

regards

Mike