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
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
Member for
22 years 9 months
Member for22 years10 months
Submitted by Alexandre Faul… on Fri, 2012-04-13 10:25
Member for
22 years 9 monthsRemi,1. to have MSP compute
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
Member for
13 years 7 monthsHi Alexandre, Thank you for
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
Member for
22 years 9 monthsRemi,this is doable with a
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