In one of our client there is three level bom: SKU--->SFGs+Packing materials,SFG-->SFGs((Type 2) +packing mats and SFG(Type 2)--->Raw mat+pack
He wants to get variance for FG(SKU).Can you help me out for the logic how to derive variance in this case? And his requirement is that variance should match with FBL3n entry in which GL which hits variance is entered and summation is matched.
we have already given a report in which we are driving variance Raw material and packing material wise by calculation standard and actual consumption of RM and PM ,Then calculationg GRN of SKU (101-102 Mvt type in AUFM)
then planned variance=actual GRN of SKU(101-102) - (standard consumption)
now variance for a material(RM or PM)= Actual conump - standard consu - planned variance proportionally divided for thant material(RM or PM)
Now how can i derive for SKU??