(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.
Hi All,
I'm in the process of building a fully resource loaded schedule and have recently been advised that I need to apply a 6% internal inventory charge to all materials to recoup internal stores costs.
The obvious answer is to adjust the price / unit for each material but that is not possible as these resources are already in use by multiple teams where this 6% rate doesn't apply. Total cost for all resources is calculated costs x units but I'm hoping someone can advise me as to how I could create and apply this 6% charge across the relevant materials.
Cheers
Printer-friendly version
Send to friend
You are Welcome Sir Rafael.
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.
Raymund thank you very much.
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.
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.
I believe that Raf is correct you can have up to 5 rate types per resource
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
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
glad I could help you Jesse
...
There are 5 Rate Type you can use for Each Resource.
NICE
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.
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,
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.
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?
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
Email: PPadmin@planningplanet.com
Replies