MS E Inventory Projection(Depletion)
- Surya M
Overview:
The apparel industry is constantly evolving, with new trends emerging each season. Inventory forecasting is a crucial aspect of the fashion industry. It involves predicting future sales and demand for a product to ensure that there is enough stock to meet demand
Objectives:
To simulate the sales at a store SKU level for a future period using projected ROS considering Revenue targets of Stores and past seasonality corresponding to the future forecast period
To determine the projected closing inventory for a brand for the selected future period
Use this Project sales and Projected closing inventory to determine the future buy, evaluate current overstocking and understocking considering the inbound stock and open orders with Vendors
Features:
True ROS: Predicts daily TrueROS for each Point of Sales - style code on the days where it was live
Unbroken Demand calculation: The TrueROS is calculated only on those days where the Style code was live with at least a minimum X% representation of pivotal sizes
Intelligently adjusts the predicted ROS by accounting for:
Seasonality
Changes in revenue targets
Potential Demand Identification: Predict potential demand by using AG-level ROS for Points of Sales where the style_code was not listed