Hi,
we are procuring a final chemical that is delivered to us by mixing 2 other chemicals in some ratio. we have to pay the cost of the final chemical on the basis of ratio mix of these chemicals.
example;
Price of chemical A + Price of chemical B = PB00
Cost of chemical is per kg of A = 100
Cost of chemical is per kg of B= 200
Say if A is mixed 30kg and B is mixed 100 kg, the final chemical price is as follows:
30 kg x 100+ 100 kg x 200 = PB00.
we have to reflect this separately in schema.
pl help how we can map this?
regards