Projects Billing

Home Forums Microsoft Project Discussion Forum Projects Billing


  • This topic has 2 replies, 2 voices, and was last updated 9 years ago by Alasdair.
Viewing 1 reply thread
  • Author
    • #96701


      Wondered if anyone can assist? Would like to know if there is a straight forward way of recording actual costs of in a project
      (i.e. the rates per hour of company resources) against the rates per hour charged to the client, in other words the billing rate.

      Thanks in advance.

    • #96983

      Hi Rob

      Many thanks for this. It would bea stand alone project. I thought it would be along the lines of a calculatd field, similiar to what I might do with calculating 2 columns in Excel and using a function or formula.

      Regards, Alasdair

    • #96898

      Are you using EPM or are these stand-alone project schedules? If they’re stand-alone schedules, you could use cost rate table A for the sell rate and cost rate table B for the cost rate (internal cost). You could then add a calculated column to the resource sheet to show the sell rate multiplied by the actual work for each resource, and another to show the cost rate multiplied by the actual work.
      This approach is problematic in EPM because there’s only five rate tables and your resources will have the same rates across all projects. You may not charge different customers the same amount for the same resources.

      You could also create custom cost variables and add them to the resource sheet. This works well in the resource sheet but won’t allow you to show those costs in the GANTT view.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.