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.

Cloumn for Max time/Unit

9 replies [Last post]
Fri, 2010-07-16 00:07
Shazia khan
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Hi -All

Please advise how to change a Resource , Column which is Max.Time/Unit defult is 8/d i want that 0/d

Thanks

Top

Replies

Fri, 2010-07-16 03:06
#1
Shazia khan
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Mr.Rodel

Could you please advise me how i can assign weight factor to SCH.

For example

Activity weighting here it is?

Activity 1= EREC OF PACKAGES ON SKID w.factor

Activity 2= SKID/PACKAGE UNIT HANDLING 5% = 35,000
Activity 3= SKID/PACKAGE UNIT ERECTION 45% = 315,000
Activity 4=SKID/PACKAGE UNIT ALIGNMENT 25% = 175,000
Activity 5=SKID/PACKAGE UNIT FINISHING 20% = 140,000
activity 6=SKID/PACK FINAL CHECK/CERTIF 5% = 35,000

i want to update these Acticity with respect to Progress Measurment Sysytem which having same Weighting in xl format.

Thanks & Best Regards
Top
Fri, 2010-07-16 02:10
#2
Shazia khan
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Thanks so Much . i succeed,


Please advise what will be the problem while updating Mat resource.

Thanks , you are more then expert.
Top
Fri, 2010-07-16 01:55
#3
Rodel Marasigan
User offline. Last seen 2 days 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
If you want front loading payment you have two ways to do this.
1) You can use Expenses Tab instead of Resource and enter the Amount of 700,000 then change the Accrual type to Start of Activity.

2) Assign a Material Resource (Skid) then change the resource Curve. You can use future bucket feature by manually typing cost on the 1st month and zero on the succeeding month of duration or modify a Resource Curve (Enterprise-> Resource curve and first two field enter 50 - 50 and rest are zero or first field 100 and rest are zero then assigned it to material resource.
Top
Fri, 2010-07-16 01:44
#4
Shazia khan
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Thanks for your reply.

My company and SKid Manufactur Paymnet term some thing like this,

But My client and my Payment terms Install the Compelet Pakg. witout piping get 90% Paymanet,10% after commissioning.

anyway , my basic Problem is i am not able to put my Material Res to activity.

Mat. is equipment or skid , its cost 700,00 USD duration of skid installation is 50 dyas,(included Piping)

I want to see this 700,000 amount in front of activity (with in budgeted Material cost Column)

How i can do taht.

Best Regards
Top
Fri, 2010-07-16 01:33
#5
Rodel Marasigan
User offline. Last seen 2 days 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
Is this for material procurement measurement or construction progress measurement?

For Material procurement measurement it should be by supplier contract base. (i.e. 10% down payment and rest upon delivery or progress payment through manufacturing of skid)

For construction measurement it should be by production step milestone or weighting.
Ex: EREC OF PACKAGES ON SKID = 700,000
SKID/PACKAGE UNIT HANDLING 5% = 35,000
SKID/PACKAGE UNIT ERECTION 45% = 315,000
SKID/PACKAGE UNIT ALIGNMENT 25% = 175,000
SKID/PACKAGE UNIT FINISHING 20% = 140,000
SKID/PACK FINAL CHECK/CERTIF 5% = 35,000
Top
Fri, 2010-07-16 01:14
#6
Shazia khan
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
again Thanks.

Could you please advise for Material resource , what will be the Value for ( price / unit) field.

for example i have one skid , cost of this skid is USD 700,000 ,

Activity Duration is 50 dyas ( where is Mat.Res.assign)

what will be price / unit ? Please advise



700,000 / Duration = Price unit is this correct.

Thanks
Top
Fri, 2010-07-16 00:55
#7
Rodel Marasigan
User offline. Last seen 2 days 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
The proper approach is to define the price/unit of each resource and enter the qty or unit. That should calculate the correct cost equivalent.

Once Resource is defines as Material you should be able to select the unit of measurement under Resource-> Detail tab (i.e. Linear Meter, Nos, Square Meter, Cubic Meter...etc.)

You can define all of these under Admin-> Admin Categories-> Unit of Measure tab.

If you are using variable rates (multiple rates on material items) you can change the rate source on resource assignment to Override and you should be able to enter different rates for same material resource.
Top
Fri, 2010-07-16 00:40
#8
Shazia khan
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Mr.Rodel

Thanks for your reply.

i was confused about it while creating a Material Resource.

Could you please advise in Material Resource what should i enter,

Material Cost , Or Material Qty. or Units which will be work for material.

for example i have , Pipe in Mtr. Fittings and Valves in Nos.
Skid and Equipmets each. etc and how enter its cost to know that Budgeted cost for these item.

Thanks.

Top
Fri, 2010-07-16 00:14
#9
Rodel Marasigan
User offline. Last seen 2 days 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
Max Time/Unit settings can be found on Enterprise-> Resources-> Units & Prices.

Just a quick query and I’m a little bit confused. Why do you want to change it to 0/d which will make your resource over allocated.

I suggest to remove the data by selecting delete on the bottom of Unit & Prices tab instead of changing Max Time/Unit = 0. This will make your resource unlimited. The default is on Resources-> Detail tab. You can change the default to 0/d if you wish.
Top