cost Ranges

Alle Antworten

• Freitag, 4. Mai 2012 21:01

   

   
  

  0

  Mark,

  A few questions. Your example shows low work and high work yet you talk about task duration ranging from low to high. For reference, duration and work are two separate entities in Project. Duration is the working time between the task start and finish. Work on the other hand is the amount of estimated effort to accomplish the task. If a single resource is assigned to a given task full time then the work and duration are equal, but in most plans, resources are not necessarily assigned full time by themselves. There may be multiple resources or a single resource may only work part time. For example, due to various factors the duration of a task may increase but the work remains constant, or, the duration may be the same but the work changes. So, what is you scenario?

  If your plan is a simple structure of one resource assigned full time to each task, then a factor can be used to generate the two cost values. What field contains your "low work" and what field contains your "high work"?

  You can probably get what you want. It may be simple or it may be more complex. We just need to know more about your plan.

  John

  • Antworten
  • Zitieren

   
• Freitag, 4. Mai 2012 23:13

   

   
  

  0

  Hey John,

  Sorry for the confusion - I was referring to effort, and for the purposes of my example you could assume I was talking about effort (work) for a single resource. I am not referring to duration by any means - just looking to calculate ( rate x effort ) for multiple efforts for the same task to come up with cost for a low estimate and a high estimate.

  As a further example, I have tasks that are fixed 40 hour tasks (no low/highrange), and I have tasks that are 40 to 80 or 40 to 60 hour tasks (depending on additional discovery). If I can get the simple case figured out, I'm confident I can extend it to multiple resources and rates.  

  I am not looking to do a simple +/- %20 type of estimate, I have a firm grip on that type of calculation. As for the fields used, I created new custom fields, but just can't get at the resource rates to do the math in a formula.

  I hope this makes more sense. Thanks for your response.

  Cheers,

  Mark

  • Antworten
  • Zitieren

   
• Samstag, 5. Mai 2012 01:14

   

   
  

  1

  Mark,

  Perhaps the problem is you are trying to use the standard rate in a formula in a custom field in a task view and the Standard Rate is only available for custom fields in a resource view (e.g. Resource Sheet). However, you can get the standard rate value indirectly.

  In a sample file I set up four custom fields, Text1 and Text2 to be the "high work" and "low work" value in hours respectively. I then put a formula in Cost1 & Cost2 to calculate the "high cost" and "low cost" as follows:

  Cost1= [Text1]*[Cost]/[Work]*60

  Cost2 = [text2]*[Cost]/[Work]*60

  Does that help?

  John

  • Als Antwort markiert Mark Egan Montag, 7. Mai 2012 19:26
  •  
  • Antworten
  • Zitieren

   
• Samstag, 5. Mai 2012 01:24

   

   
  

  0

  Thanks John,

  I'll give this a try. I'm sure this is heading me in the right direction - needing to be in a resource view to get at the rates. 

  Thanks again for your help.

  Cheers,

  Mark

  • Antworten
  • Zitieren

   
• Samstag, 5. Mai 2012 02:44

   

   
  

  1

  Mark,

  You're welcome and thanks for the feedback. If this answered your question, please mark it as so.

  John

  
  

  • Bearbeitet John - Project Samstag, 5. Mai 2012 02:45
  •  
  • Antworten
  • Zitieren