The sum of the revenue in your example is 230000, so you will be
making a loss if your cost is 270000. Carrying through with this
example, though, your profit is -40000, which gives -14.8% profit. Is
this the profit margin you want to apply to all projects?

Pete

On Jan 16, 1:57*pm, Anders wrote:
% for example 20% on all of them.
--
Regards Anders



"Pete_UK" wrote:
By Profit Margin, do you mean the difference between revenue and cost,
or the percentage profit compared with cost?

Pete

On Jan 16, 12:18 pm, Anders wrote:
Hi,

I was wondering if someone could help me.

I have 5 projects with different set of revenues.

Project * * * * Rev * * * * * * Cost * * * * * *Profit margin
P1 * * * * * * *50000 * * * * * X1 * * * * * * *Y
P2 * * * * * * *10000 * * * * * X2 * * * * * * *Y
P3 * * * * * * *100000 * * * * * * * * *X3 * * * * * * *Y
P4 * * * * * * *20000 * * * * * X4 * * * * * * *Y
P5 * * * * * * *50000 * * * * * X5 * * * * * * *Y

I have total cost of X1-5 = 270000,-

And now I want the 270 000 to be distributed on my 5 project so that they
all have the same profit margin Y.

--
Regards Anders- Hide quoted text -

- Show quoted text -