Material Resource - Applying an additional fixed cost

Member for

15 years 11 months

You are Welcome Sir Rafael.

Member for

21 years 8 months

With Spider Project we can apply as many cost codes we want either at fixed cost or at unit cost.  I expect you should be able to create similar models.  Within P6 having the option to apply different rates to the same cost code helps.

UP-cost-components

Materials-cost-components

Member for

21 years

Rafael,

P6 is below average at this. Whether a resource’s costs are fixed or per unit time, is a function of the activity NOT the resource assignment. A classic example from my oil and gas world is drilling. The drilling rig is hired by the day, but the drill string is a material whose costs are fixed.
I recommend my clients to use the P6 facility “Expenses” to add material costs. Expenses are always fixed, even on activities where all the resource costs are per unit time.

Member for

15 years 11 months

Sir Rafael,

For Clarity, 5 Rate Types are available and any of the Types can be assigned in Each Resources Assigned.

A Resource can be assigned 5 Times with different assigned Rate Types for each.

Hope this is clear for you.

 

 

Member for

15 years 11 months

Jesse,

I suggests to create UDF under Resource Assignment which contains the 6% x Budgeted units instead of the Price / Unit.

You can replace the Budgeted units with the UDF using the Global Change.

Prior to that create another UDF to store the original Budgeted Units so that you can easily revert back if needed.

 

Hope this will help.

Member for

16 years 3 months

I believe that Raf is correct you can have up to 5 rate types per resource 

Member for

7 years 5 months

Hi Raymund,

Thanks for the advice. I should have included in my original post that I had considered creating a different rate type and then utilised that for all materials in my projects. I don't have admin rights and wasn't sure how many rate types were available and if I could create a new one in the way you have described. Does anyone know if you can create that without the import? How many rate types are available in the system or can new rate types be created similarly to a UDF?

Cheers,

Jesse

Member for

7 years 5 months

Hi Raymund,

Thanks for the advice. I should have included in my original post that I had considered creating a different rate type and then utilised that for all materials in my projects. I don't have admin rights and wasn't sure how many rate types were available and if I could create a new one in the way you have described. Does anyone know if you can create that without the import? How many rate types are available in the system or can new rate types be created similarly to a UDF?

Cheers,

Jesse

Member for

21 years

You are not finished yet, Jesse!

In addition to what you have done, you need to ensure that the "Calculate costs from units" flag is removed from each material resource assignment, and from the resource dictionary, or when you apply progress the change you have made will be undone.

To remove the flag at the resource assignment, another global change will do….

Member for

21 years 8 months

There are 5 Rate Type you can use for Each Resource.

NICE

Member for

21 years 8 months

...

Member for

15 years 11 months

Jesse,

There are 5 Rate Type you can use for Each Resource. One of them can be used as the original rate x 6% then assign to affected Resources.

Use the Excel SDK to import the new Rate Type.

Hope this will help.

Member for

7 years 5 months

Hi Everyone,

Thanks for your responses. Zoltan's global change approach seems to have created the required effect. After creating and applying the global change, the budgeted cost of the materials has increased by 6% but the price/unit has remained the same - exactly what I was after. No other projects are affected because the price/unit of the material hasn't changed but i have the material price increase I need specific to my projects.

Cheers,

Member for

16 years 3 months

Vlad

He needs to add 6% to all of his material costs my advice is to run a global chnage to do this for him. 

Member for

24 years 9 months

Zoltan,

I don't understand your advice.

I understood that Jesse wants to change material unit costs (price / unit).

Activity cost includes the costs of required materials and depends on activity material consumption.

You suggest to change the costs of material assignments. But what happens if material consumption will become higher or lower for some reasons. Will material assignment cost be adjusted proportionally?

Member for

16 years 3 months

go to tools global change

on the right select new

up top under select subject area choose

Activity Resource Assignments

the the specification would be

where

resource type equals material

then

budgeted costs = budgeted costs  *   .06

 

then on the upper right select change

then on the bottom right select Comitt Changes

done

Member for

21 years

Putting to one side an important argument for using Expenses for materials, rather than Resources, I am not quite clear what you want. Is it:

For all materials on activities that have not started, add 6% to the cost?