4 resources for a Activity

S
Shazia khan 👤 Member for 18 years 1 month
S
Shazia khan 👤 Member for 18 years 1 month

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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.

S
Shazia khan 👤 Member for 18 years 1 month

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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.

S
Shazia khan 👤 Member for 18 years 1 month

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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

S
Shazia khan 👤 Member for 18 years 1 month

Sir.



How to calculate remaining Duration ,



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





Thanks & Regards

R
Rodel Marasigan 👤 Member for 19 years 7 months

Shazia,

That is correct, using Physical % Complete type all inputs are manual and independent which reflects the correct project status.

S
Shazia khan 👤 Member for 18 years 1 month

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.

R
Rodel Marasigan 👤 Member for 19 years 7 months

Shazia,

Change the Timescale to Year/month or month/week. That should smooth the S-curve.

S
Shazia khan 👤 Member for 18 years 1 month

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


S
Shazia khan 👤 Member for 18 years 1 month

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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

S
Shazia khan 👤 Member for 18 years 1 month

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

S
Shazia khan 👤 Member for 18 years 1 month

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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.

S
Shazia khan 👤 Member for 18 years 1 month

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


S
Shazia khan 👤 Member for 18 years 1 month

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


R
Rodel Marasigan 👤 Member for 19 years 7 months

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts