How to distribute overhead costs accros a list of ZIP-Code Areas ?

[kerpui]

Hello,

I have got a problem with distributing common costs accros a range of ZIP-Codes.

As you can see in the attached screenshot I've got certain revenue as well as certain costs which are each individually assigned to the according ZIP-Code, but I've also got this big overhead lumpsum, which I would like to spread accross each ZIP-Code as per the individual count of Jobs in each area.

Thanks in advance your help,
Kai

[rubenmarin · Accepted solution]

Hi, it could be something like:

Sum(TOTAL OverheadCost)/Count(TOTAL Jobs)*Count(Jobs)

So if you have OverheadCost=100, Jobs Zip1=3 Jobs Zip2=7

For Zip1: 100/10*3=30

For Zip2: 100/10*7=70

[kerpui]

Thank you, i had completely forgotten about the TOTAL function...