Problem Statement
AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodara. They want to expand to other metros/Tier 1 cities in the next 2 years.
AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers daily basis so that they can respond swiftly to these issues.
The Supply Chain team decided to use a standard approach to measure the service level in which they will measure ‘On-time delivery (OT) %’, ‘In-full delivery (IF) %’, and OnTime in full (OTIF) %’ of the customer orders daily basis against the target service level set for each customer.
Dashboard Images
Key Analytics Findings
- Analyzed customer data, revealing Ahmedabad city as the primary customer base, while identifying critical supply chain performance metrics such as ONTIME%, OTIF%, and IN FULL% using DAX queries.
- Identified key customers, such as Lotus Mart and Acclaimed Stores, and their order volumes, pinpointing areas for improvement in delivery performance and product quantity fulfillment.
- Utilized data visualization and analysis to highlight discrepancies in product lines, emphasizing the need to optimize supply chain processes to improve line fill rates and enhance overall efficiency in delivering products like Amul milk, Amul curd, and Amul butter.