OTB : OTB Flow Output
- Siddharth Jain (Unlicensed)
- Somya Gupta (Unlicensed)
Column | Description |
Projected Sales | Calculated as explained earlier |
STR Adjusted Buy | Based on sell thru factor of 75% applied on the projected sales at each store + attribute group level |
Previous width | Unique Style Codes exposed in last year year from the analysis period and merchandise considered |
Relevant Width | Style Codes with more than 16 days of floor time in last year |
LT Correction Factor | MS Tool suggested increase/decrease factor in width based on Long Tail scenario. These factors are user defined and can be adjusted accordingly |
Ideal Width | Relevant Width * LT Correction Factor. This width indicates how much should be placed at a store to avoid long tail based on last year's data |
Potential Width | Based on projected sales and maximum sales a style can do within a store + attribute group (from last year data), potential width is calaculated |
Size set Width | Based on defined min. depth of Style Code for the store + category combination. This value ensures that all styles in the Attribute Group have a min. depth |
Width before MOQ | Resultant value from Ideal Width, Potential Width & Size Set Width. This width does not go above Size Set Width and go below Potential Width |
MOQ Adjusted Buy | Buy quantity after adjusting for the MOQ defined for each Category at a Company level |
Width from MOQ | Width of Attribute Groups which do not satisfy the MOQ condition is reduced and it is adjusted accordingly for this Attribute Group at all stores |
Final buy width | Width from MOQ adjustement is further decreased if any Attribute Group is exposed in higher width only at few stores and those additional styles are not able to meet MOQ condition |
Final Buy | Buy adjusted after ensuring each suggested Style in the store has the min. depth defined at Store + Category level |