Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(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.

cost loading

8 replies [Last post]
Mon, 2010-07-12 14:43
Kari Lucas
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 18 Jun 2010
Posts: 16
Groups: None
I’m working on cost loading from the program level and was thinking I might use the top loading feature in the EPS. The problem is I can’t see a way to spread the cost for cash flow projections. if anyone has an idea about how best to cost load on the program level please share with me.

Also, I just imported total budget cost into a schedule but it is not spreading the cost. The total budget shows up in the first month regardless of the activity duration being a year long. Any thoughts?

thanks in advance for any advice you all can give me!
Top

Replies

Thu, 2018-05-24 16:26
#1
Kathy Castle
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 17 Apr 2018
Posts: 22
Groups: None

Hi Kari

Below article may be helpful for Primavera Cost Loading

https://www.projectcubicle.com/primavera-p6-cost-loading/

Top
Fri, 2018-04-20 13:59
#2
Zoltan Palffy
User offline. Last seen 4 days 9 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3090
Groups: None

you can create a new resource call it lumpsum then create level of effort activities to summarize what you want to cost load for your cash flow. The activity type will be Level of Effort its predecessor will have a SS realtionship to the 1st activity to be summarized and its successor will have a FF relationship ot the lat actvity that you want to summarize.

create the LOE activity assign the LUMPSUM resource to it with the appropriate and then ASSSIGN A RESOURCE CURVE to that resource if you do not do this then your cost will stack up on the data date. 

you can create as many LOEs as you want to represent how your cost will be spread as it relates to time. 

Top
Tue, 2018-04-17 15:10
#3
Kathy Castle
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 17 Apr 2018
Posts: 22
Groups: None

Kari,

Check the planned start and the planned finish dates of your activities. If these dates are different than your activity start and finish dates, fix them

Top
Fri, 2010-07-16 11:57
#4
Kari Lucas
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 18 Jun 2010
Posts: 16
Groups: None
Thanks for your reply, Rodel. I will have to keep in mind what you said about the progress spotlight. As for the my cost quandry, the answer had to do with using budgeted units to calculate budget cost on a $1.00/LS price/unit resource setting. This way, when the project is updated, the duration percent complete is used to determine actual and remaining cost. It seems to be working the way I wanted so that’s what I’m going with.

Thanks again for your responses.
Top
Wed, 2010-07-14 18:14
#5
Rodel Marasigan
User offline. Last seen 21 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Kari,
Progress Spotlight use Planned dates and not current activity date. Meaning if you run a progress spotlight and planned date is behind or ahead of schedule (not the same as current date) it will update the schedule based on planned date and ignore current date.
Another thing that spotlight do is based on planned date progress it will calculate planned units. If you manually type your cost and calculate cost from unit is tick from the assigned resource (not on resource library) and your resource price/unit is zero then all your manually input cost will be overwritten by the zero (ex: 100 unit * 0 price/unit = 0) that is why all budgets and actual cost are back to zero. If calculate cost from unit is un-tick then P6 will ignore cost on calculation and use only units and you need to manually update your cost (all cost manually inputted are retained). The only way you can deal with this is update resource Price/unit on resource library and make sure that calculate cost from unit are all tick or mark on all resource assigned to activity.
Top
Wed, 2010-07-14 11:19
#6
Kari Lucas
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 18 Jun 2010
Posts: 16
Groups: None
Thank you, Rodel, for your response. I did as you said and unticked the Calc cost from unit selection.

What I am ultimately trying to do is update the schedule and show my earned and actual cost tracked against the budget of the project. I am using the Progress Spotlight and the Update Progress features to automatically update the schedule. But when I do this, the actualized activities lose their budgets completely. Needless to say there are no actual or earned cost either. Does anyone have a clue why this is happening? I just want to automatically update the schedule and get a new cost spread. Help!!!
Top
Mon, 2010-07-12 18:44
#7
Rodel Marasigan
User offline. Last seen 21 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Kari,
Your resources don’t have Price/unit and calculate cost from unit is tick. You need to remove the tick or mark on all resources assigned if you don’t want to link your cost from units. Under Activity Window-> Resources tab, right click and select Customize Resources Column and under General select Calculate cost from unit. Once the column is show remove the tick. Alternatively use Resource Window and show column Calculate cost from unit and from the first resource row remove the tick. Highlight all resources and while the cursor in on Calculate cost from unit column press Ctrl+e (fill command) and that should remove all tick from resources.
Top
Mon, 2010-07-12 17:12
#8
Kari Lucas
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 18 Jun 2010
Posts: 16
Groups: None
Ok, so I did get the budget cost to spread evenly by putting in a unit/day of 1 which just gives me the cost spread evenly by original duration.Then I wanted to do an automatic update with the progress spotlight but when I did it, I lost all my budget cost! Can anyone please help me out? I cannot figure out what I’m doing wrong and it seems like it should be a fairly simple exercise.
Top