Expenses allocation?

[taemoor90]

revenues january febraury march aprile

cost center business unite
sales cairo 20000 25000 15000 40000
production cairo 30000 10000 5000 65000
finance newyourk 25000 15000 10000 50000
expenses 30000 25000 10000 60000


-i want allocat this expenses on every cost center according his revenu in every month?

[taemoor90]

i have 2 business unite(cairo,newyork) and i have 2 cost centers in cairo,1costcenter in newyork.
cost center is dependent segment on business unite

[admin]

Have you tried allocation formula? tks