Skip to content

Total Budgeted Cost & Remaining Cost

Arnel LagumbayMember for 18 years 1 month
Created
6
2
0
To P6 experts,

Please enlingthened me with this problem I incountered,Iv got this Cost loaded programme which was develope in P3, I imported to P6 succesfully but the problem is when i exported to excel the Cost(Budgeted & Remaining)is not distributed thru its activity full duration.Or some settings that i missed here.

I need your reply guys..thanks

Best regards,
Rnel

6 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    Hi Arnel,

    Not really sure what do you mean not distributed in full duration. Are you using resource spreadsheet (copy & paste to excel) or export resource assignment to excel?
    Please clarify more details on your problem.
  2. 0
    Arnel Lagumbay ·
    Hi Rodel,

    Actually Im using activity usage spreadsheet(copy&paste to excel).Activity has its budgeted cost, but its not distributed to its activity duration,loading shows only at the begining of the activity duration.Im trying to generate a report out of this cost which is requirement from our client.

    Thanks Rodel..

    Regards,
    Rnel
  3. 0
    Rodel Marasigan ·
    Arnel,
    Is the resource assign with curve? If not, check the resource planned date. It may not the same as early dates.
    To check right click on Activity Detail-> Resource Tab. Select Customize Resource Column. Under Dates double click Planned Start, Planned Finish and under General double click on curve.
    Remove curve if have and Planned dates should be the same are early dates.
    Another cause is if it not using resource and used Expenses instead. You can change expenses distribution by changing accrual type to Uniform over activity.
  4. 0
    Arnel Lagumbay ·
    Thanks Rodel...

    Now its okey..i assigned linear curve and its doing fine.


    Regards,
    Rnel
  5. 0
    Ali Farhat ·
    Hi Arnel, everyone
    I just like to add something even if ur problem is solved...distribution of a resource over the assigned to activity depends also on the resource assignment duration which is equal to the activity duration by default...
    Regards
  6. 0
    Rodel Marasigan ·
    Ali,
    That’s not always the case. It depends on your Activities Project settings whether Link budget and At Completion for not started activities is mark/tick or not with the combination of either reset original duration and units to remaining or reset remaining duration to original duration and units.
    Resources is always using remaining duration spread for At Completion unit/cost and Original Duration spread for Planned unit/Cost which maybe different from remaining duration.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?