Roy G said:
Is there a way of showing the markup on each individual resource which can be
used to create the customer estimate.
In other words is there a way of showing the standard rate type column with
another column showing the marked up rate
Roy G,
I assume you are trying to show cost versus price for each resource. It
depends on which view you want to show the added information. If it is a
task view (e.g. Gantt Chart), it could be done by customizing a spare
cost or text field with a formula that applies the mark up. This
approach gets more complex if multiple resources are assigned to any
given task (i.e. multiple spare fields and formulas would be needed).
If you want to see the information on the Resource Usage view the
process is quite simple. Designate a spare cost field (e.g. Cost1) and
customize it with a formula. For example, for a 150% rate mark up, the
following formula is all you need:
Cost1 = [Cost]*1.5
Be advised that the mark up values will only appear on resource rows of
the Resource Usage view. The data could be made to also appear on
assignment rows, but that would require VBA since spare assignment
fields cannot be customized with a formula.
Hope this helps.
John
Project MVP
