Different Markup Rates on Different Resource Types

[Ken Steinhoff]

I am new to MSProject.
I need to set up my projects with different markup rates on different types of resources used in a project.

For example:
Hourly labour charges for employees have no standard markup applied.
Materials provided to the project get a 25% markup.
Subcontractors used on the project get a 25% markup.

The entire project (labour, materials, and subcontractors) gets an 8% management fee applied.

I have been manually calculating the markups and management fee and using the totals in the resource sheet to establish cost.
I also need to produce a report that shows the base costs without markup and management fee applied.

Is there a way to achieve this?

[Larry Christofaro]

Ken,
Unfortunately Microsoft Project doesn’t do very well with this kind of requirement. Project is about costs, not billings or markups. You might be able to use cost rate tables if you know what you are doing but it is also a manual process. Best bet is to export to an Excel file and preconfigure or use macros to calculate margin. It’s actually not that hard if you spend some time to set it up. Hope that helps…

[Author]

Posts