Internal price vs sales price RRS feed

  • Question

  • Hi!

    Do you know if its possible to get the internal sales price (cost) vs the sales price (benefit) in MS Project? This so that we can easily see the surplus of the project.

    Wednesday, November 26, 2014 2:56 PM

All replies

  • Hi,

    You could use the cost rate table with the internal cost as rate A and the external cost as rate B. Then just switch the assignments from A to B table to see the external cost.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller |

    Wednesday, November 26, 2014 3:03 PM
  • Chhaukas87,

    Guillaume's approach will provide a first order value but normally cost versus price is more complicated. For example, price not only includes basic labor and material rates but also labor burden, material burden, overhead and profit. Since each of those factors are applied at different levels it is not easy to incorporate those into cost rate tables, which apply at resource level only.

    If all you need is a first order value for price, then go ahead and factor up resource rates in each rate table (e.g. rate table B for each resource). Rate tables are applied via the Cost Rate Table field in the Task or Resource Usage views.

    If however you want a more accurate value for price, then you can either export and manipulate Project's cost data in another application such as Excel, or you could with some VBA, (or possibly some formulas in custom fields), calculate the price data in a custom field in Project.


    Wednesday, November 26, 2014 3:54 PM