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

A
Anoon Iimos 👤 Member for 19 years 8 months

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

J
Jose Ramirez 👤 Member for 17 years 9 months

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

R
Rafael Davila 👤 Member for 22 years 3 months

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.

J
Jose Ramirez 👤 Member for 17 years 9 months

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

J
Jose Ramirez 👤 Member for 17 years 9 months

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

J
Jose Ramirez 👤 Member for 17 years 9 months

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

R
Rafael Davila 👤 Member for 22 years 3 months

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

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts