Thread: Proportion problem

Hello, I am posting on something I am working on at work and didn't know how to go about this as I am stumped.

Without putting any sensitive material in this post, I will make a made up transaction that should equal percentage wise but doesnt.

I have 2 orders, one for copper@ $1 for 100,000 KGs of which 50% was prepaid and of the outstanding 50% 27,989Kgs were sold off, and 22,011 is still owed, and one for Nickel @ $2 for 25,000 KGs of which 50% were prepaid, and of the outstanding 50% 8,750 were sold off, and 3,750 are still owed.

Now when I sum it up it to percentages of the totals, I cannot get a consistent number in how much is owed. its either 19.67% $'s in liabilites or 20.60% Kg's in liabilities. since the KGs and the $'s are related, shouldn't the Percentage that is associated with the liabilities outstanding be the same? If not why not?

I drew up a table in excel to show how I am putting all this information together.

Any insight on this is much appreciated and would help me greatly.

Originally Posted by hlam

Now when I sum it up it to percentages of the totals, I cannot get a consistent number in how much is owed. its either 19.67% $'s in liabilites or 20.60% Kg's in liabilities. since the KGs and the $'s are related, shouldn't the Percentage that is associated with the liabilities outstanding be the same? If not why not?

KG's: 25761 / 125000 = 20.6%
$'s : 29511 / 150000 = 19.7%

They're different because the Nickel batch was sold @ $2, not $1.