Re-engineering Assortment Planning for Newly Opened Large Format Stores (Rare Rabbit)
This project focused on improving assortment planning for newly opened Rare Rabbit large-format stores by identifying planning gaps and reducing dependence on subjective decision-making. Analysis of AW25 and SS25 data revealed 8,332 units of inventory mismatch worth approximately ₹2.08 crore, caused by under-dispatching high-performing categories and over-dispatching low-performing ones. To address this, three analytical tools—Option Productivity Index (OPI), Exposure Efficiency Score (EES), and Regional Deviation Factor—were developed and integrated into a structured 7-step decision framework for data-driven store planning.