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.

How Does 1 Adds Cost 2 Equip./Mtrl. That Have A 1x High

8 replies [Last post]
Thu, 2009-11-12 00:35
Jose Ramirez
User offline. Last seen 12 years 5 weeks ago. Offline
Joined: 6 Sep 2008
Posts: 105
Groups: None
How Does 1 Adds Cost 2 Equip./Mtrl. That Have A 1x High Purchase Cost To The Schedule Without affecting the CPI?

I have a few questions for my fellow Planners:

A: What is the concept of adding cost to Generators/Pumps/Equipment/Switchgear that have a One Time High Purchased Cost in the beginning of the project?

B: What about Equipment/Material that at least 65% of it’s original budgeted cost is at the start of its duration but the cost spreads linearly throughout its lifecycle?

C: How to avoid a poor CPI that has resulted when you applied a front loaded curve to a Material Resource on an activity that has a high one time cost?

D: Can you assign bucket or future period planning to a material resource? I cannot seem to edit the budgeted area when I select a Material Resource. Is this correct?


Thank You Guys,

Hope I Get An Answer To My Qs?

From: JoseR
Top

Replies

Thu, 2009-11-12 03:37
#1
Anoon Iimos
User offline. Last seen 2 years 27 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
let me try,

A. This is straightforward, each equipment has corresponding cost.

B. What do you mean spreads linearly throughout the lifecycle? This will depend on how you distribute or organize your activities (WBS). Your cost distribution, I supposed, will go with the distribution and organization of your activities.

C.& D - sorry I don’t know, let others answer

cheers
Top
Thu, 2009-11-12 18:58
#2
Jose Ramirez
User offline. Last seen 12 years 5 weeks ago. Offline
Joined: 6 Sep 2008
Posts: 105
Groups: None
Hey Rafael,

You know what I was so stupid, when i checked the starting date: i totally forgot about the starting hours (i was thinking since it was already set at 8:00Am since that was what all the Calendar had). So, I Had to go back to the User Preference and uncheck the "Do Not Show Time" option. I totally realized this when I exported the data to an excel spread sheet and saw the staring hours it was midday (11:38)You were so correct...So that was the reason why i had an extra half of a day of duration. Thank you. I going to try to follow your example. Thank you for the example: graphics, are so much better.

Yeah, i always use photobucket is great to get your point across and free..."i am glad i could help",

JoseR
Top
Thu, 2009-11-12 19:21
#3
Rafael Davila
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 1 Mar 2004
Posts: 5230
Groups: Spider Project Team
10-4
Top
Thu, 2009-11-12 18:16
#4
Rafael Davila
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 1 Mar 2004
Posts: 5230
Groups: Spider Project Team
Jose,

All is well, thanks, I wish you the same.

To load the cost as such:
EARLY START Budgeted Cost
12/4/2009 6000.00
12/5/2009 444.44 up to 12/15/2009 444.44

I did the following within SureTrak, sorry I do not use P6 nor P3, hope this can give you a clue.

RESOURCE 1 = A, 9 DAYS DURATION, 1 DAY RESOURCE LAG, $4,000 COST AT COMPLETION
RESOURCE 2 = A, 1 DAY DURATION, NO RESOURCE LAG, $6,000 COST AT COMPLETION

Note I use Cost at Completion for my data entry, works better for me, is a matter of preference.

10 days resource loading

By the way, I see you checked all calendars and all are the same, maybe double check project start date and hour just to make sure. Also it is possible edits on the resource assigment table override previous assigments.

Best regards,
Rafael

PS: I learned about photobucket in one of your previous postings, thanks.
Top
Thu, 2009-11-12 13:51
#5
Jose Ramirez
User offline. Last seen 12 years 5 weeks ago. Offline
Joined: 6 Sep 2008
Posts: 105
Groups: None
Thank You Anoon, for your quick reply and help:

Sorry, I wasn’t clear with my question?

What I am trying to do is to:

FOR Example:

Resource Name: Equipment (Generator)
Resource Type: Materical

Task Duration: 10
Budget Units: 10U
Max Unit/Days: 1U/D
Price/Unit: 1,000/1
Task Type: WBS Summary Activity

Task Planned Material Cost: 10,000 USD

This are my project setting for this example:

*Early Start: 12/04/2009
*Early Finish: 12/16/2009
The Default Calendar: 6 Days Per Week/8 Hours Per Day
The Project Calendar: 6 Days Per Week/8 Hours Per Day
The Resource Calendar: 6 Days Per Week/8 Hours Per Day
Fixed Duration and Units
Duration % Complete


But Why, On the Resource Assignment Window: I Get the Following DATA?

*This is without a Resource Curve. The results are the same if I applied a LINEAR curve to it.




EARLY START Budgeted Cost
12/4/2009 600
12/5/2009 1000
12/7/2009 1000
12/8/2009 1000
12/9/2009 1000
12/10/2009 1000
12/11/2009 1000
12/12/2009 1000
12/14/2009 1000
12/15/2009 1000
12/16/2009 600

Why: 11D 10200

Back to my original question: Lets make a massive assumption here that the numbers will be correct one day! If I wanted to load the cost as such:


EARLY START Budgeted Cost
12/4/2009 6000.00
12/5/2009 444.44
12/7/2009 444.44
12/8/2009 444.44
12/9/2009 444.44
12/10/2009 444.44
12/11/2009 444.44
12/12/2009 444.44
12/14/2009 444.44
12/15/2009 444.44


With A 10 Day Duration and A Budget of 9999.96

-OR- but the duration of the resource still 10 DAYS?

EARLY START Budgeted Cost
12/4/2009 10000.00
12/5/2009 0.00
12/7/2009 0.00
12/8/2009 0.00
12/9/2009 0.00
12/10/2009 0.00
12/11/2009 0.00
12/12/2009 0.00
12/14/2009 0.00
12/15/2009 0.00


With A 10 Day Duration and A Budget of 10000


I don’t know what I am doing wrong: since for every day if the cost spread/curve is set to LINEAR/Normal distribution it should be 1000 USD PER DAY or 10% of the budge. So, why these freaking weird numbers. This is so simple math but why am I getting the wrong answer/data?


Thank You Guys Again,

JOSEr
Top
Thu, 2009-11-12 14:03
#6
Jose Ramirez
User offline. Last seen 12 years 5 weeks ago. Offline
Joined: 6 Sep 2008
Posts: 105
Groups: None
RE: The CPI, If I try to get an EV. On how my data is been distributed on this example the numbers will be all wrong. The actual cost of the (12/4/2009) was 1000.00 USD but the budgeted cost is 600.00 USD (CPI = EV/AC (CPI: 600/1000 = .60). I am only getting .60 for every single dollar spent on the project today. Not So Good…lol…

EARLY START Budgeted Cost
12/4/2009 600
12/5/2009 1000
12/7/2009 1000
12/8/2009 1000
12/9/2009 1000
12/10/2009 1000
12/11/2009 1000
12/12/2009 1000
12/14/2009 1000
12/15/2009 1000
12/16/2009 600

Why: 11D 10200
Top
Thu, 2009-11-12 15:41
#7
Jose Ramirez
User offline. Last seen 12 years 5 weeks ago. Offline
Joined: 6 Sep 2008
Posts: 105
Groups: None
That was what i was thinking before but it’s set to start at 8am and it’s start date is not till Dec (because i was thinking since i created this thing today after eight, but that shouldn’t matter)...All the calendars have the same starting hour (8:00AM)...It’s actually only one resource i got rid-off all the other ones to make sure it’s reporting correct data. So, far is not...How are you doing Rafael? Hope all is well with you.

The data i provided is from the resource assignment table: all the days have the correct units but not the cost?

JoseR
Top
Thu, 2009-11-12 15:00
#8
Rafael Davila
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 1 Mar 2004
Posts: 5230
Groups: Spider Project Team
Jose,

Did you used a single resource assignment or two, a uniform resource assignment for 10 days for a % of cost as required and another one day assignment for the remaining?

Try checking resource assignment table on an hourly basis, maybe the start of the activity is set at midday.

Best regards,
Rafael
Top