Optimum Depth Help Section

CHANNEL

Channel to which the Store belongs

STORE

Store for which the category contribution needs to be overwritten on MS Enterprise™ output

CATEGORY

Category for which the revenue contribution needs to be overwritten on MS Enterprise™ output

FORECAST_PERIOD

Forecast period for which the category contribution needs to be overwritten on MS Enterprise™ output

REVENUE_CONTRIBUTION

Value mentioned here will be overwritten as the category contribution in that store on top of the value suggested by MS Enterprise™. Used to incorporate brand inputs

MAX_DISCOUNT_LIMIT

Maximum allowed discount in the Forecast period. ASP calculated by the tool will be readjusted if the past discount after clean-ups was higher than the specified benchmark
Eg., MRP of a product is 2000 and the ASP based on past sales is 1400 (30% average discount). If this benchmark is given as 20%, ASP will be readjusted to 2000*(1-20/100) i.e., 1600

PERIOD

The period for which forecast will be done.Multiple forecast periods can be entered and for each forecast period, multiple sale periods can be entered

SALES_START_DATE

Start date of the historical Sales period on which the Forecast will be based

SALES_END_DATE

End date of the historical Sales period on which the Forecast will be based

FORECAST_START_DATE

Start date of the forecast period

FORECAST_END_DATE

End date of the forecast period

SEASON

Styles belonging to these seasons from the sales period will be considered for analysis

EVENT_FLAG

1 if the forecast period is a special event. If set to 1, all the data will be considered instead of first n weeks

SALES_PERIOD_PRIORITY

If multiple Sales periods are defined for the same forecast period, this flag indicates the priority of the sales periods