View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Anders Anders is offline
external usenet poster
 
Posts: 54
Default Calculate X1-5 and Y? If total cost is given.

% 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