none
Task Cost vs Resource Assignment Cost RRS feed

  • Question

  • Hello,

    Can someone help me with figuring out, how cost information is stored in MSP, please? Below steps to replicate and question.

    Steps:

    1.     Create New Project
    2.     Go to Resource sheet – create material resource with standard rate $1.0
    3.        Go back to Gantt Chart View
    4.        Create task
    5.        Insert “Cost” column
    6.        Enter $100 against this task.
    7.        Display “Task Form” view (split view)
    8.        Assign resources created in point 2.
    9.        Enter 50 units against assigned resource

    Now MSP shows tasks’ cost $150 ($100 original + $50 resource cost assignment)

    Question: Where (which column; field; table) MSP stores original cost? Its definitely stored somewhere, because after importing to different software package – I can see original $100 and $50 resource cost as separate items.  

    Thanks,

    Karol

    Tuesday, July 26, 2016 2:05 PM

Answers

  • Hi Karol,

    When you enter a cost (100) against a task with no assignment, it is actually stored in the fixed cost column and replicated in the cost column. When you add a resource, a cost is created due to the assignment (50), then the fixed cost is still 100, but the cost is the sum of fixed cost and assignment cost (150).

    Note that it can work on the other way around : if you first assign the resource, you'll get your 50. Then type 150 in the cost column (which is the total cost: fixed+assignment cost) and you'll see 100 auto calculated in the fixed cost: Project keeps the assignment cost at 50 and calculate 100 in the fixed cost to make the balance.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Tuesday, July 26, 2016 2:37 PM
    Moderator

All replies

  • Hi Karol,

    When you enter a cost (100) against a task with no assignment, it is actually stored in the fixed cost column and replicated in the cost column. When you add a resource, a cost is created due to the assignment (50), then the fixed cost is still 100, but the cost is the sum of fixed cost and assignment cost (150).

    Note that it can work on the other way around : if you first assign the resource, you'll get your 50. Then type 150 in the cost column (which is the total cost: fixed+assignment cost) and you'll see 100 auto calculated in the fixed cost: Project keeps the assignment cost at 50 and calculate 100 in the fixed cost to make the balance.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Tuesday, July 26, 2016 2:37 PM
    Moderator
  • Thanks Guillaume,

    This is exactly what I was looking for.

    Wednesday, July 27, 2016 12:13 AM