How to calculate Weighted average SAM or weighted average SMV ?

Whenever there is a need to find the average SAM, It becomes quite clear that simple average doesn’t give us the right picture. This is because simple average divides the SAM equally between all the styles. This division is wrong because there will be some styles with bigger order Quantity and some styles with lesser order quantity and the effect of order quantity will not be reflected in the averaged SAM. Therefore we need to calculate weighted average SAM whenever there is need to find average. Continue reading “How to calculate Weighted average SAM or weighted average SMV ?”

A secret useful excel formula for merchandisers, planners and buyers

In this post I am going to tell you a useful excel formula for merchandisers, planners and buyers ( or every garment professional) which is going to save you a lot of time and will let your boss wondering about your speed and efficiency.

Many a times garment professionals have to copy a style information from one excel sheet to other. To do this, the normally adopted method is to open both the sheets, search the style number , select the style colour then copy the relevant data and paste it into the other sheet. Continue reading “A secret useful excel formula for merchandisers, planners and buyers”