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.
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
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Tue, 2020-08-11 14:33
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?
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
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Fri, 2020-08-07 14:38
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
Member for21 years8 months
Submitted by Rafael Davila on Fri, 2020-08-07 13:57
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
Member for16 years4 months
Submitted by Zoltan Palffy on Thu, 2020-08-06 16:08
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
Member for16 years4 months
Submitted by Zoltan Palffy on Wed, 2020-08-05 14:05
Member for
15 years 11 monthsYou are Welcome Sir Rafael.
You are Welcome Sir Rafael.
Member for
21 years 8 monthsWith Spider Project we can
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.
Member for
21 yearsRafael, P6 is below average
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
21 years 8 monthsRaymund thank you very much.
Raymund thank you very much.
Member for
15 years 11 monthsSir Rafael,For Clarity, 5
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 monthsJesse,I suggests to create
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 monthsI believe that Raf is correct
I believe that Raf is correct you can have up to 5 rate types per resource
Member for
7 years 5 monthsHi Raymund,Thanks for the
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 monthsHi Raymund,Thanks for the
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
16 years 3 monthsglad I could help you Jesse
glad I could help you Jesse
Member for
21 yearsYou are not finished yet,
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 monthsThere are 5 Rate Type you can
There are 5 Rate Type you can use for Each Resource.
NICE
Member for
21 years 8 months...
...
Member for
15 years 11 monthsJesse,There are 5 Rate Type
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 monthsHi Everyone,Thanks for your
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 monthsVladHe needs to add 6% to all
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 monthsZoltan,I don't understand
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 monthsgo to tools global changeon
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 yearsPutting to one side an
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?