OTB: Style-Wise Output Depth
OTB SWB Output Depth column explanation:-
Column | Explanation | Remarks |
---|---|---|
period | period |
|
channel | channel |
|
store_code | store_code |
|
brand | brand |
|
cat | cat |
|
subcat | subcat |
|
gender | gender |
|
brand_segment | brand_segment |
|
price_bucket | price_bucket |
|
attribute1 | attribute1 |
|
attribute2 | attribute2 |
|
attribute3 | attribute3 |
|
attribute4 | attribute4 |
|
attribute5 | attribute5 |
|
attribute6 | attribute6 |
|
attribute7 | attribute7 |
|
attribute8 | attribute8 |
|
attribute9 | attribute9 |
|
proj_buy_qty | proj_buy_qty from OD contri and Final ASP and Store AOP |
|
calculated_options | divide Projected Buy Qty with STR Adjusted Sales Depth |
|
size_set_options | size_set_options input |
|
min_constraint | min_constraint input |
|
max_options_capacity | calculated as Min Display Capacity * Freshness Factor |
|
segmented_option_count | Number of Styles at the Dynamic Store + PA level having segmentation 1 |
|
final_options | If Calculated Options is in between the highest of min constraints & lowest of max constraint then the Final Option is the Calculated Options | This will be at a Dynamic Store + Primary Attribute level
|
final_depth | Divide Projected Buy Quantity with Final Options to get the final depth |
|
target_mrp | Sub Module 1 Projected Buy Qty and Adj ASP value for each Store- PA |
|