Project Profitability

[Doug Schurman]

I'm trying to calculate project profitability. I have it worked out if I use
the same expense / hour for all global resources. I can't figure out how to
calculate it based on unique expense rates per global resource. My basic
formula for 1 average rate is

+ Baseline Cost (Revenue)
- Intenal Labor Expense (customefield = Work * standard rate)
= Task Profit
Sum of all Task Profits = Project Profit

I've created a custom cost field (Resource Hourly Expense)for resources and
can enter the rate / hour expense for each resource but I can't figure a way
to get rolled up sum of each assignment hours * Resource Hourly Expense on
the task lines within the project.

Is there a way to accomlish this?

 

[Rod Gill]

Yes. In fact it's one of the macros in my VBA Book!

You need to have two rates for each Resource. Standard rate can be what's
charged to the Customer. Rate B can be internal cost rate.

The macro then Sets rate B to all assignments (assignment.costratetable)
then copies the new Task cost to Cost1 field.
Reset all assignments to Rate A(standard) and in Cost2 have Cost-Cost1 to
calculate Task margin. Have a formula to roll up margin in summary tasks.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com