Cost Loading the Schedule

D
Dost Hyd 👤 Member for 15 years

Hi,

I would like to cost load the schedule. I do not want to cost load it based on units/time. I want to give an activity a Lump Sum Budgeted Cost. Get a cost curve to see how much we would be spending per month.

I have created a Non-labor Resource called Budget and physically typed in the Budgeted cost. That is the only way I knew. But, I guess that is not very effective.

Can any one tell me the best way to cost load a schedule and obtain a cash curve?

Thanks Much.

Dost.

Z
Zoltan Palffy 👤 Member for 17 years

Alex this will not work if they already have been set up that way. What you have to do is get rid of this setting for each activity that uses that resource that has calcuale cost from units checked. 

To do this go to

tools Global change and add  a new global change

uptop under the Select Subject Area chang this to Activity Resource Assignments

where calculate costs from units equal Yes

then calculate costs from units = No

then on the right select change then comitt changes

A
Alex Fernandez 👤 Member for 8 years 11 months

I know this is an old thread but in case anyone is still looking the trick is to tell primavera to look at a budgeted sum rather than a budgeted cost per unit. Assign your resource as normal, got to the resource tab and make sure the "Calculate costs from units" column is showing and untick the box. Then enter your budgeted cost/at complete cost in the relavent field and Primavera will look at this rather than unit costs

D
Dieter Wambach 👤 Member for 19 years 6 months

Hi Dost (=Deepak?)

 

It isn'T that difficult as you may believe:

- Expenses can only be assigned to existing activities

- You'll need to attach at least one expense to an activity

- You'll create an export file, type "Expenses"; it might be helpful to export the type Activities as well.

- In Excel you'll duplicate the records, without any modification of the format

- You'll add the information, watch the activity_ID!

- You'll import that file again and the expenses should be added automatically

Good luck

Dieter

D
Dost Hyd 👤 Member for 15 years

Thanks all for replying.

I have used both expenses and costs. Expenses is not the best way to cost load a thousand activity Schedule. ( I could not find a import from xcel option for this. I had to manually type in each expense).

That said, Using a non- labor resource is the easiest way. But, I am unable to produce a curve for this resource. Is there any one who can help me with producing curves please?

 

Thanks,

Deepak.

D
Dieter Wambach 👤 Member for 19 years 6 months

Hi Dost

 

It depends on how you use costs for the other projects within your database and on your needs for reporting. P6 allows both:

- Expenses (=costs which are independent from resources): at start or finish of each activity, or even distributed over activity's duration.

- Attached to a special resource (labour or nonlabour). You'll have to set "Rate Source" = "override".

If you'll use detailed or summary (LoE or WBS) activities depends on your requirements for granularity of cost planning - I prefer on activity level.

Good  luck for your plan

Dieter

A
AB Timo 👤 Member for 15 years 1 month

Use expense tab and Add the activity cost directly there.

S
Syed Abrar 👤 Member for 18 years 2 months

HI all,

 

    we are also using in similar fashion, as u said that on non-Labour resorce as Budget or some name then uploading the Budgeted cost for that particular activity.

But in primavera there is a option called cost accounts in Entrerprises of  Toool bar drop down menu. It seems similar like activity code.

 

if some one has got any idea please reply to me too.

 

Syed Abrar

 

M
Mike Testro 👤 Member for 20 years 7 months

Hi Dost

In Asta PowerProject I put the cost in the appropriate summary bar,

Best regards

Mike Testro

A
Anoon Iimos 👤 Member for 19 years 10 months

use "Expenses"; it is not the best way, but it might work for you

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts