none
Inserting Cost Table RRS feed

  • Question

  • Hi,

    I want to add different Cost rate table for a particular assignment any easy steps and secondly need also some help in making a group cost. Anyone??

    Thanks,

    Emil Vega

    Sunday, April 27, 2014 7:18 AM

Answers

  • Dear Emil,

    There are very simple steps in MS 2010.

    to set a different Cost rate table for an Assignment:

    1.Display the TASK USAGE or Resource Usage view.

    2.Set a different cost rate table for a particular assignment.

    - Set a different cost rate table in the cost rate table Column

    a.Insert the Cost Rate Table Column

    b.If necessary, reposition the cost rate table column

    c.In the cost rate table column, from the cost rate table drop-down list corresponding to the appropriate assignment, select the desired cost rate table.

    d.Just press Enter

    -Set a different cost rate table in the Assignment Information dialog box.

    a. Double-click the appropriate resource or task corresponding to the desired assignment to display the Assignment Information dialog box.

    b. On the General page, from the Cost rate table drop-down list, select the appropriate cost rate table.
    c. Click OK.

    For Group Cost:

    Group costs using the Group Definition dialog box:
    1. Display the Cost table, or insert the appropriate columns in the desired view.
    2. On the View tab, in the Data section, choose Group by→More Groups to display
    the More Groups dialog box.
    3. If you want then, select Task or Resource to specify the type of group to create.
    4. Click New to display the Group Definition dialog box

    5. In the Group Definition dialog box, specify the desired settings.
    • In the Name text box, type a suitable name for the new group.
    • Check the Show in menu check box to display the new group on the Group by submenu.
    • Check the Group assignments, not tasks or Group assignments, not resources check box to display only resources or tasks, respectively.
    • In the Group Definition table, specify the grouping criteria.
    a. In the Field Name column, from the Field Name drop-down list corresponding to Group By, select the desired column name.
    b. If you need then, in the Order column, select Ascending or Descending to sort results in ascending or descending order, respectively.

    c. If necessary, in the remaining Then By rows of the Group Definition table, specify more grouping criteria.

    In the Group by setting for section, select the required Group By or Then By row and specify the desired font, cell background color, and pattern to be applied to tasks or resources that match the grouping criteria.

    I hope it helps you...

    Regards,

    Muhammad Enam Ur Rehman


    • Marked as answer by Emil Vega Sunday, April 27, 2014 8:00 AM
    Sunday, April 27, 2014 7:51 AM

All replies

  • Hi Emil,

    You can enter up to 5 rates for each work resource and choose one of the rates for each assignment in a project.

    See reference below:

    http://blog.advisicon.com/2009/07/29/how-to-change-a-resource-cost-rate/

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Sunday, April 27, 2014 7:27 AM
    Moderator
  • Dear Emil,

    There are very simple steps in MS 2010.

    to set a different Cost rate table for an Assignment:

    1.Display the TASK USAGE or Resource Usage view.

    2.Set a different cost rate table for a particular assignment.

    - Set a different cost rate table in the cost rate table Column

    a.Insert the Cost Rate Table Column

    b.If necessary, reposition the cost rate table column

    c.In the cost rate table column, from the cost rate table drop-down list corresponding to the appropriate assignment, select the desired cost rate table.

    d.Just press Enter

    -Set a different cost rate table in the Assignment Information dialog box.

    a. Double-click the appropriate resource or task corresponding to the desired assignment to display the Assignment Information dialog box.

    b. On the General page, from the Cost rate table drop-down list, select the appropriate cost rate table.
    c. Click OK.

    For Group Cost:

    Group costs using the Group Definition dialog box:
    1. Display the Cost table, or insert the appropriate columns in the desired view.
    2. On the View tab, in the Data section, choose Group by→More Groups to display
    the More Groups dialog box.
    3. If you want then, select Task or Resource to specify the type of group to create.
    4. Click New to display the Group Definition dialog box

    5. In the Group Definition dialog box, specify the desired settings.
    • In the Name text box, type a suitable name for the new group.
    • Check the Show in menu check box to display the new group on the Group by submenu.
    • Check the Group assignments, not tasks or Group assignments, not resources check box to display only resources or tasks, respectively.
    • In the Group Definition table, specify the grouping criteria.
    a. In the Field Name column, from the Field Name drop-down list corresponding to Group By, select the desired column name.
    b. If you need then, in the Order column, select Ascending or Descending to sort results in ascending or descending order, respectively.

    c. If necessary, in the remaining Then By rows of the Group Definition table, specify more grouping criteria.

    In the Group by setting for section, select the required Group By or Then By row and specify the desired font, cell background color, and pattern to be applied to tasks or resources that match the grouping criteria.

    I hope it helps you...

    Regards,

    Muhammad Enam Ur Rehman


    • Marked as answer by Emil Vega Sunday, April 27, 2014 8:00 AM
    Sunday, April 27, 2014 7:51 AM
  • Thanks Guys ,

    Issue Resolves ..

    Emil Vega



    Sunday, April 27, 2014 8:00 AM