Atliq Mart Supply Chain Analysis

*PROBLEM STATEMENT

AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodra. They want to expand to other metro/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 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 On Time in full (OTIF) % of the customer orders daily against the target service level set for each customer.

*TASK LIST

Peter Pandey is the data analyst in the supply chain team who joined Atliq Mart recently. He has been briefed about the task in the stakeholder business review meeting. Now Imagine yourself as Peter Pandey and play the role of the new data analyst who is excited to build this dashboard and perform the following task

Create the metrics according to the metrics list. Create a dashboard according to the requirements provided by stakeholders in the business review meeting. You will be provided with the transcript of this business review meeting in the form of a comic. Create relevant insights that are not provided in the metric list/stakeholder meeting.

*SOME MAJOR INSIGHTS

All the Key Metrics (OT%, IF%, OTIF%) are far behind the target On average, orders are delayed 0.42 days from the agreed date of delivery Lotus Mart, and Cool blue, Acclaimed stores have the highest orders as well as delayed the most to deliver the products on time Is it because we are not estimating the right delivery date? Is it because we are receiving more orders than expected? Ghee, curd and butter products are most delayed in delivery. There have been no noticeable improvements in any of the key metrics in the last few months There is a huge gap in IF% for most of the customers. Is it because of less production?