Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Materials vs. Expenses

7 replies [Last post]
Dennis Hanks
User offline. Last seen 8 years 2 weeks ago. Offline
Joined: 17 Apr 2007
Posts: 310

How do you treat material costs? Given the distinction between expenses and material costs is depreciation, and there is either a Resource tab or an Expense tab (bottom Layout)

2509
layout.jpg

. how do you list your material costs-say bulks? There is a Budgeted Material Costs column in the Activity listing, but not on either the Resource or Expense tabs in the Bottom Layout. This is a Level 1 schedule that has two S/Cs (expenses - transportation) and three procurement activities - topsides, jacket, and bulks. I would not normaly list any non-time related item on a schedule, but this is an interesting case - pre-FEED planning/bugeting. Thanks.

Replies

David Kelly
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

Excellent conversation, and one I have thought about a lot.

 

I always try and use expenses for material costs:

 

1) Expenses are "lump sum" independent of the duration type of the activity. So I can code $100k per day for the drilling rig as my Duration Type freezes the cost per day, and $200k for materials which are not duration dependent

 

2) I really,really do not want the materials catalogue in the resource dictionary. Expenses allow ad-hoc descriptions, not a pick-list

David Kelly
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

Excellent conversation, and one I have thought about a lot.

 

I always try and use expenses for material costs:

 

1) Expenses are "lump sum" independent of the duration type of the activity. So I can code $100k per day for the drilling rig as my Duration Type freezes the cost per day, and $200k for materials which are not duration dependent

 

2) I really,really do not want the materials catalogue in the resource dictionary. Expenses allow ad-hoc descriptions, not a pick-list

Dennis Hanks
User offline. Last seen 8 years 2 weeks ago. Offline
Joined: 17 Apr 2007
Posts: 310

Zoltan;

Not that it makes any difference, but I've decided any non-labor cost is an expense. I like the characteriization better using the Project Expense tab. Apparently any item over $5000 is depreciable. Conceptually, I resist the inclusion of any non-time sensitive item in the schedule. If it doesn't have a time component like labor, equipt. rental, scaffolding, it shouldn't be on the schedule. This Level I schedule is an exception. No need to respond.

Dennis Hanks
User offline. Last seen 8 years 2 weeks ago. Offline
Joined: 17 Apr 2007
Posts: 310

It does. Material is a resource. Interesting. Makes sense, from an accounting stand point. Thanks again, I hope my education is not becoming too tedious.

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

not sure I exactly understand the question I will try to answer it anyway

you can create a resource that TYPE that is Material and you can make the unit of measure anything that you want such as lump sum or you can go to admin then admin categories and create a NEW unit of measure such as bulk whatever

then on the resource tab you can enter the number of Budgeted Units if it is bulk maybe the unit is only 1 and you can put in the Budgeted cost for this resource also

its the same as any labor activity but the resource is material 

hope this answers your question

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

not sure I exactly understand the question I will try to answer it anyway

you can create a resource that TYPE that is Material and you can make the unit of measure anything that you want such as lump sum or you can go to admin then admin categories and create a NEW unit of measure such as bulk whatever

then on the resource tab you can enter the number of Budgeted Units if it is bulk maybe the unit is only 1 and you can put in the Budgeted cost for this resource also

its the same as any labor activity but the resource is material 

hope this answers your question

Dennis Hanks
User offline. Last seen 8 years 2 weeks ago. Offline
Joined: 17 Apr 2007
Posts: 310

2511
layout.jpg