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/tier1 cities in the next 2 years.

AtliQ Mart is currently facing a problem where a few key customers did not extend the annual contract 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 on a 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 on a daily basis against the target service level set for each customer.

The Task to do:

Peter Pandey is the data analyst in the supply chain team who joined Atliq Mart recently. He has been briefed about the 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.

The Dashboard:

Key Insights:

The first and main observation is that we are not reaching any of the targets of ON TIME (OT), IN FULL (IF), and ON TIME IN FULL (OTIF) metrics.
Among all the metrics, the OTIF parameter was performing the least. This tells us that we are unable to deliver the full orders on time.
On the Order Insights page, we can also see that nearly 41% (13K) of the orders we receive are getting delayed.
The Customers: Lotus Mart, Acclaimed Stores, and cool blue are performing worse concerning OT %, IF %, and also the number of delayed orders.
From Product insights, we can observe that our AM Milk products are our top products having the highest number of orders (also in delayed deliveries), and the AM GHEE products being the lowest. We can increase the supply of AM Milk products so that they can be delivered in full and can decrease the supply of AM Ghee products as well.

Link to Interact with the dashboard:

Live Dashboard

_{Attribution to Icon Authors:}

home button and filter button : Home button icons created by Freepik - Flaticon
truck and orders button: Order icons created by Eucalyp - Flaticon
product insights button : Supply chain management icons created by Freepik - Flaticon
overview button: Overview icons created by lapiyee - Flaticon

sanjanaaa17 / atliq-mart-supply-chain-analysis Goto Github PK