view different cost (of different resource rates) in task...
in [Project]
|
Prev: Status of summary tasks incorrect
Next: Difference between Owner of a Project and Manager of a Project
From: Vit on 18 May 2008 22:41 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... Id like to view the different between the 2 costs... I have to do it by vba?? Or what else??? Thanks so much Vit
From: Rod Gill on 18 May 2008 23:26 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 "Vit" <FiNaR76(a)gmail.com> wrote in message news:7036e754-f90b-4074-aedd-3d7434595843(a)z24g2000prf.googlegroups.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
From: "Steve House" sjhouse at hotmail dot on 19 May 2008 09:46
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 "Vit" <FiNaR76(a)gmail.com> wrote in message news:7036e754-f90b-4074-aedd-3d7434595843(a)z24g2000prf.googlegroups.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 |