view different cost (of different resource rates) in task...

[Vit]

Hi,
I clearly understand how to input different rates at the same
resource, but there is another question: is possible to view different
cost (example the cost of the selling and the internal cost to
calculate the gross margin...) in the same view, without change the
cost rate table in the resource usage view...
I’d like to view the different between the 2 costs...
I have to do it by vba?? Or what else???

Thanks so much
Vit

 

[Rod Gill]

Hi,

You have to apply different rates and a vba macro is the easiest way to
update the cost margin. Manually you need to:

In Usage view apply Rate B (or rate with internal cost to all assignments)
in Gantt chart apply cost table
Insert Cost1 field and rename to Internal Cost
Copy Cost column to Cost1 field
Reapply rate A (cost to customer) to all assignment in usage view
Insert column Cost2 and rename to Margin
Create a formula in Cost2 [Cost]-[Cost2]

Cost2 should now hold margin. To refresh re-apply and copy rate B costs.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I clearly understand how to input different rates at the same
resource, but there is another question: is possible to view different
cost (example the cost of the selling and the internal cost to
calculate the gross margin...) in the same view, without change the
cost rate table in the resource usage view...
I’d like to view the different between the 2 costs...
I have to do it by vba?? Or what else???

Thanks so much
Vit

 

[Steve House]

I urge caution with this as the cost is ALWAYS computed as an hourly rate
based on man-hours of work for the task at hand but there are a lot of
different ways a selling price might be computed. Your company may bill
in minimum whole day increments, for example. If that's the case, consider
a resource whose Cost A is $400/day reflecting your cost and Cost B is
$500/day reflecting your selling price. You send him to a client for a 1
day task, internal cost is $400 and selling price is $500 - margin is $100 -
simple. But you send him to a client for a 1 man-hour task, your internal
cost is $50 ($400/8) while your selling price is $500 (1 day minimum
charge), margin is $450 (correct). But MS Project will compute for that
task an internal cost based on Rate A of $50 (correct), a selling price
based on Rate B of $62.50 ($500/8), incorrect, and a margin of $12.50, also
incorrect!

While you may be able to kludge something together that works some of the
time, I am very uncomfortable with any attempt to use Project to track
revenues and profitability. It's simply not an accounting application nor
should it be used to replace proper accounting software - it's emphatically
NOT a time-and-billing program. Its costing components are telling you how
much of your firm's assets will be required in order to complete the project
and essentially ignores completely whether you actually will be able to pay
for it, your cash outlay or intake, or when you need to cut the cheques.
--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://project.mvps.org/faqs.htm for the FAQs



Hi,
I clearly understand how to input different rates at the same
resource, but there is another question: is possible to view different
cost (example the cost of the selling and the internal cost to
calculate the gross margin...) in the same view, without change the
cost rate table in the resource usage view...
I'd like to view the different between the 2 costs...
I have to do it by vba?? Or what else???

Thanks so much
Vit