how do I divide 2 different quantities into one cost?
example :
QTY 1. 29208
QTY 2. 14604
put together the cost is $12190
so how do I split this cost by the two different quantities?
Notice that the two quantities sum to 43,812
So...to apportion the cost between the two quantites
(29208 / 43812) * 12190 = $8126.67 = Qty 1's portion
And Qty 2 will just be 12190 - 8126.67 = $4063.33 = Qty 2's portion
