HI Experts ,
I have a scenario.plz help me with the solution for it .
There is a Company example (Bench-mark), which has got 4 plants in Pune , Delhi, Gujarat & Chennai.
The cost of raw material , labour cost & over head cost is different in all the 4 plants as a result of which the cost of final material also varies. now all the finished product are collected at warehouse in Mumbai , from where it is distributed to customers.
Now i want to know once it is collecetd at common ware house in mumbai , how will i come to know which material has come from which storage location & it's price. (the material collecetd from all the plant is same).
Experts plz help me with the same, Suitable points will be given.
Thanks & regards,