Hi all,
With Project 2007, I've entered all the resources / costs for the project, from the estimate. The amount shown in the column "cost" is the prime cost for each activity.
Now, I would like to apply a "mark-up" coefficient to each activity to obtain the selling price (the cost presented to our client) in another column if possible, using formulas, macros or MS project functions...
Does anybody know how to do this?
Many Thanks in Advance,
Regards,
RSa
Remi,
1. to have MSP compute the mark-up cost on the summay tasks, go to Customize, Fields, select your "mark-up" field and set up the Summay tasks report to "Sum"
2. to calculate the total cost after mark-up, use another user defined field and create a new formula
3. to have a different mark-up for manpower or material resources, add a if then else condition in your formula
Alexandre
Hi Alexandre,
Thank you for four answer, that's the way I thought I would do it too. However, I've got a couple of issues now with the total cost of the project and the costs shown on the summary lines:
The total prime cost of the project can be calculated automatically by Project but is there a way to calculate the total cost after mark-up?
Also, as shown in the example below if I want to apply a different mark up coefficient to some activities, project won't calculate the total cost after mark up, I have to calculate the coefficient for the summary lines manually.
[[wysiwyg_imageupload:1026:]]
Another question, is it possible to apply a different mark-up coefficient on the labour costs, on the material costs and on the subcontract costs? I can't see how to do that...
Many Thanks,
Regards,
Remi
Remi,
this is doable with a formula:
go to Tools, Customize, Fields
select a Cost field
write the following formula: Cost1 = Cost * (markup)
add the Cost1 field to the appropriate views, such as the Cost Table
Alexandre