If the consumer demand of products can be forecast with higher accuracy, the organization can achieve improved revenues and profitability. Out of stock cases can be minimized and inventory cost can be reduced greatly - leading to increased profits. We use advance time series models, taking into account external factors such as market trends, changing consumer preferences, competition etc. for making more accurate forecasts. The solution can be used at Store-SKU level.