View Single Post
  #1   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.

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