Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Prime Costs / Selling Price MS Project 2007

3 replies [Last post]
Remi S
User offline. Last seen 1 year 5 weeks ago. Offline
Joined: 12 Apr 2012
Posts: 10
Groups: None

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

Replies

Remi S
User offline. Last seen 1 year 5 weeks ago. Offline
Joined: 12 Apr 2012
Posts: 10
Groups: None

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.

1026
untitled.png

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