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.

4 resources for a Activity

20 replies [Last post]
Mon, 2010-07-19 21:03
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Good Monig. Mr Rodel

I have an activity 10 days duration max.working Hr 10/d

This activity having four resources 2 nonlabour and 2 labour,


activity name is Foundation, OD 10 days. ( cal 6D/week)
Resource , 1 Execavator Nonlabour.
2. Execavator Operator (labour)
3. Roller Operator (labour)
4. Roller (nonlabour)
first 5 days for excavation, and last five days for Rolling,

i assing 100 units per resourece to avtivity all resource are over alocating,

Means in Res Sparesheet shows 12hr/d and Execavator working 14 Hr/d for 2 days.


Please advise me how i can assign these resource to activity avoid the resource over allocating.

How many units i have to allot for each resource so Res must work 10 hr/d only and work muct finished with in 10 days,

Thanks & Regards
Top

Replies

Wed, 2010-07-21 03:04
#1
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Sir

Thank so Much.

Now i am confident to perform my task.

I am very happy to gain the confidence under your Instruction.

Really you are wise man for Project Planning.

Once again thanks & Many Regards
Top
Wed, 2010-07-21 02:28
#2
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
Schedule % complete is calculated on Baseline Planned dates. It means that you are ahead of schedule and planned finished date is above the data date. If you want Schedule % complete = 100% complete, edit the planned finish date and change it below data date.
Top
Wed, 2010-07-21 02:22
#3
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Sir

It is lat point where i got stuck.

Project Physically 100% complete .

An Activity is showing 88.9 % while its SD and FD tickted

Phy Prog.100 but in Schedule % Complete Column its Showing 88.9 % Complete .

at the Project 0 level Schedule % Complete Showing 98.8% Complete but Performace Complete Column showing 100%.

i want Scedule % Complete Col.Rolled up and show the 100% complete.

Please advise me where i am making mistake.

Thanks & Regards
Top
Tue, 2010-07-20 22:47
#4
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
Your resource assigned has no Price/Unit and cost is manually entered. If you want to enter cost manually and don’t want to use resource Price/unit you need to remove mark or tick on calculate costs from unit. (Activity Window-> Resource tab-> Right click then select customize resources column and under general select calculate cost from unit) Once calculate cost from unit column is shown remove the tick.
You also need to change the setting on Project Window-> Calculation tab-> Resource Assignment then remove mark or tick from Recalculate Actual units and Cost when duration % complete change.
Top
Tue, 2010-07-20 22:28
#5
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Sir.

A new problem Arise.

i have update schedule ,

Activity Budegeted Cost has Removed.

I not able to see Budegeted cost which a had assign to the Resource.

even Activity 100% completed cost has removed.

those activity under Proggress say 65% 70% 97% completed
its cost also gone.

Please advise what mistake i have done.

Thanks & Regards
Top
Tue, 2010-07-20 21:36
#6
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
Remaining duration normally calculation OD-AD = RD but more often it does not feasible especially if the activity is delay. The best way is to ask the supervisor on how long for them to complete the remaining task. Sometimes remaining durations will take longer than the original duration due to resource constrain or waiting for other dependencies. If the activity is on track you can use the default original duration – actual duration = remaining duration or you can use a current productivity to estimate the remaining duration.

Ex: 100SQM plastering = 5 days = 20SQM/day
Actual = 3 day = 55SQM = 18.33SQM/day
Remaining = (100SQM – 55SQM) / 18.33SQM/day = 2.5 days
Top
Tue, 2010-07-20 20:54
#7
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Sir.

How to calculate remaining Duration ,

od-rd/od*100 is this correct for Cal. RD.


Thanks & Regards
Top
Tue, 2010-07-20 20:46
#8
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
That is correct, using Physical % Complete type all inputs are manual and independent which reflects the correct project status.
Top
Tue, 2010-07-20 20:36
#9
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Sir
Thanks for your reply.

I have Physical % complete Type activity,

What are the in put need to update this activity.

I have tick the start date of activity and Physical % value, (activity is not 100% complete.)

I heard that while % complete type is Physical.

Then we have to must manually enter Phy.Progress value, remaining Duration and Actual Units .

what is the correct method to update PHY. % Complete Type (activity)

Thanks & reghards.
Top
Tue, 2010-07-20 01:52
#10
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
Change the Timescale to Year/month or month/week. That should smooth the S-curve.
Top
Tue, 2010-07-20 01:18
#11
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Sir.

How can Show a smooth S-curve while i am printing it is like zig zag line and Holiday gap between vertical Bar like Sun , Sat .

i have assign a new curve for all Resource or all resource curve must be same.

Pleas advise

Thanks

Top
Tue, 2010-07-20 00:44
#12
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Sir

Thanks so much for your valuable efforts,

I have learnt a lots form you.

I had followed all your instruction and i succeed,

Once again Thanks


Best Regards
Top
Mon, 2010-07-19 23:50
#13
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Shazia,
Good work! For activity working 5 days assign 5 day calendar and for activity working 6 days assign 6 day calendar. Retain the Hours per time period with 10/d, 60/w, 260/m and 3120/y. Your activity duration should be calculated using calendar day and the working period is as defined in hours per time periods.

Note: Because you change the Hours per time period, you have to check your resources also and make sure the default is 10/d and max unit/time = 10/d. It will automatically adjust as 12.5 if previously defaulted to 8/d.

Best Regards,
Rodel
Top
Mon, 2010-07-19 23:43
#14
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Mr. Rodel.

What you have Suspect it was 100% correct ,

You was correct i had problem with Time periods.

this is the reason result was wrong.

now it is working fine resource also showing correct Units.


Thanks & Regards
Top
Mon, 2010-07-19 23:39
#15
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
In my cal time Periods is


Hr/day 8 Hr/week 40 Hr / Month 172 Hr/years 2000

while i change it Hr/d 10 Hr/M 260

Then execavation Start 02 sep and finished on 07-sep.
and rooling start 08 sep-10 and finished on 13-sep-10

with 5 days Duration.

Please advise me how i can set my cal and units Periods for 6days cal and 5d cal.

Thanks & Regards
Top
Mon, 2010-07-19 23:15
#16
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
Can you check your calendar because 07 Sep-10 and Finishing 10Sep-10 at 6 Pm is only 4 days which gave a result of 12.5 hrs per day. Also check Hours per time period (Edit-> Users Preferences-> Time Units tab-> Hours per time Period should be 10/d, 60/w etc...) I suspect that its default to 8/d.
Top
Mon, 2010-07-19 23:01
#17
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Sir

In my case SpredSheet Shows 13 Hr for each,

execavation start on 02,sep-10 and finished 6sep-10 at 6 pm

Rolling start on 07 Sep-10 and Finishing 10Sep-10 at 6 Pm

OD is 5 dasy for borh,

Error in Rolling finished date ,

resource working hr, is 13/d (showing in SpdSheet)

I have set resource Max /time 10/d with 6 days Global Cal.

each Res.units are 50 ,

for Operator 50 units
execavator 50 units
for same Rolling.

Please advise me where i am making mistake,

Thanks & Regards

Top
Mon, 2010-07-19 22:51
#18
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
You are very much welcome! I’m happy to help.

Best Regards,
Rodel
Top
Mon, 2010-07-19 22:39
#19
Shazia khan
User offline. Last seen 12 years 9 weeks ago. Offline
Joined: 21 Apr 2008
Posts: 139
Groups: Petro-Chem / Oil & Gas
Dear Mr.Rodel

Thanks so much. i have lots of regards for you.

I naver see any teacher in my life like you.

you are real master / expert of project planning and control ,you are making our life easy .

Thanks & best regards

Top
Mon, 2010-07-19 22:24
#20
Rodel Marasigan
User offline. Last seen 2 hours 42 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Shazia,
The best approach is to split your activity and assign resource to have a correct distribution. Resource should have 6 day calendar and hour per time period should be define as 10/d same as Global default calendar. See sample below:
Multiple Resource
Top