Proportional Distribution of Purchase to Several Projects

Hi Sergei,

Thank you for your response. I appreciate that you took the time to come up with a formula that would work. 

Our clients generally tell us to equally distribute the cost of an item to several projects.  However, my employer does not accept equal distribution and requires we provide the specifics of what formula was used to make sure the distribution of an expense is proportionate.  Since projects have different duration and award amounts, it seems to me both must be in the equation in order to arrive at a proportional distribution. Unfortunately, there are two possible formula (A*D or A/D) that provide different distribution amounts and I wouldn't know which to apply or how to explain why one was chosen over the other.

Thanks again for your time and input.

Johanny