Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Cost Calculations (MS Project 2000)

    I need to display costs by Resource Group on my Gantt Chart in seperate columns. ie I have two main groups of resources internal and external. My client wants to see costs per group per task.

    Can this be done if so how ?

    <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Multiple Cost Calculations (MS Project 2000)

    In your Gantt Chart view? I would suggest the Resource Usage or Task Usage views might be more useful.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Oct 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Cost Calculations (MS Project 2000)

    Thanks Catharine,

    I am aware of the Resource Usage and Task Usage views but this does not resolve my problem.

    Basically I have a project with two main resource groups. The costs for the resource groups need to be shown seperately on the Gantt chart by task. The Cost column will simply act as the overall cost.

    The question is how can I customise the calculation of one of the cost fields (ie Cost 1) to show only the costs associated with resources belonging to a certain resource group ?

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Multiple Cost Calculations (MS Project 2000)

    Have you tried applying a Filter while in the Gantt Chart view?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Multiple Cost Calculations (MS Project 2000)

    Alternate solution:
    Step 1 In Gantt Chart view. Insert a new column, for the Field Name select Resource Group (I am assuming you've assigned the resource to resource groups earlier). Name the column as you wish.
    Step 2 Select the Project, Sort, Sort by menu.
    Step 3 Set the sort to sort by the Resource Group field and disable the Keep Outline Structure option.

    This may be more detail than you required - but I wanted other readers to be able to follow the instructions.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    andring
    Guest

    Re: Multiple Cost Calculations (MS Project 2000)

    I wish to do the same thing, I have multiple resources assigned to the same task, the resources work for different companies. I would like to see costs per company on the task sheet. I tried Catharine's solution and it does not work, because one task can have more than one resource group assigned.

    I have been trying to put formulas into a custom cost field, but no luck yet. Has anyone done much with formulas in custom fields, I would appreciate the help.

    Thanks,

    Lee

  7. #7
    Star Lounger
    Join Date
    Oct 2001
    Location
    Ellettsville, Indiana, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Cost Calculations (MS Project 2000)

    Ok. I am getting close to an actual formula that you can use Paul. i will also email you.
    Iif([Resource Group]="Ext",[Actual Cost]-[Fixed Cost],Iif[Resource group]="Ext,Int",([Actual Cost]-[Fixed Cost])/2,Iif([Resource Group]="int,Ext",([Actual Cost]-[Fixed Cost])/2,0)))

    I subtracted actual cost from fixed cost because I wasn't sure if you wanted that and it is a part of the cost equation. You would have to continue to create other Iif statements if there were other senerios (ie: Ext,Ext,Int) and put a paranthesis at the end for every IF statement. Now I divided the Actual cost by 2 where there were two groups in the same field. I am still trying to work on the formula that would simply subtract the resource group (Int) cost info like: [Actual Cost]-[Fixed Cost]-[Resource Group]="Int" but no luck yet. Its a start though.
    You will have to create this same formula in Cost 2 and flip the Ext with Int.
    Good Luck
    Tdoll

  8. #8
    Star Lounger
    Join Date
    Oct 2001
    Location
    Ellettsville, Indiana, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Cost Calculations (MS Project 2000)

    A side note on the equation: instead of dividing by 2 you will probably want to divide something like this:
    [Resource Group]="Ext"*[units]-[Resource Group]="Int"
    I havent tried it yet but I think it is more in the right direction.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •