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.